\u00c7e\u015fitli matematiksel ve lojistik i\u015flemleri kolayla\u015ft\u0131ran elektronik tablo programlar\u0131 olan Excel ve Google E-Tablolar, i\u015f verimlili\u011fini art\u0131ran fonksiyonlara sahiptir. Bit d\u00fczeyinde i\u015flemler i\u00e7in kullan\u0131lan i\u015flevlerden biri de sa\u011fa kayd\u0131rma i\u015flemidir. Bu i\u015flev, belirtilen bit de\u011ferlerini istenen say\u0131da bit kadar sa\u011fa kayd\u0131rarak yeni bir say\u0131 \u00fcretir. MS Excel’de bu i\u015fleve MS Excel ve Google E-Tablolar’daki sa\u011fa kayd\u0131rma i\u015flevi, bir say\u0131n\u0131n binary (ikili) formunu sa\u011fa do\u011fru belirli bir bit say\u0131s\u0131 kadar kayd\u0131r\u0131r ve bu i\u015flem sonucunda elde edilen yeni de\u011feri d\u00f6nd\u00fcr\u00fcr. Bu i\u015flev, \u00f6zellikle bit d\u00fczeyinde izin verme, eri\u015fim kontrol\u00fc veya h\u0131zl\u0131 matematiksel hesaplamalar gibi alanlarda kullan\u0131l\u0131r.<\/p>\n \u0130\u015flevin uygulanabilece\u011fi pratik \u00f6rnekler a\u015fa\u011f\u0131daki gibi s\u0131ralanabilir:<\/p>\n 64 say\u0131s\u0131n\u0131n 2 bit sa\u011fa kayd\u0131r\u0131lmas\u0131 i\u015flemi a\u015fa\u011f\u0131da g\u00f6sterilmi\u015ftir. 64’\u00fcn ikilik tabandaki hali 1000000’d\u0131r. 2 bit sa\u011fa kayd\u0131rd\u0131\u011f\u0131m\u0131zda 10000, yani ondal\u0131k sistemde 16 elde edilir.<\/p>\n Bir IP adresinin her bir oktetini ayr\u0131\u015ft\u0131rmak i\u00e7in sa\u011fa kayd\u0131rma i\u015flevi kullan\u0131labilir. 192.168.1.1 gibi bir IP adresinin her bir par\u00e7as\u0131n\u0131 almak i\u00e7in her 8 bitlik segment, s\u0131ras\u0131yla sa\u011fa kayd\u0131r\u0131labilir ve AND i\u015flemi ile maskeleme yap\u0131labilir.<\/p>\n Bu y\u00f6ntemle, network ileti\u015fimi veya d\u00fczenleme g\u00f6revlerinde IP adresleri \u00fczerinde rahatl\u0131kla i\u015flem yap\u0131labilir.<\/p>\n MS Excel ve Google E-Tablolar’da sa\u011fa kayd\u0131rma i\u015flevi, \u00f6zellikle bit d\u00fczeyinde veri i\u015fleme gerektiren durumlar i\u00e7in b\u00fcy\u00fck kolayl\u0131k sa\u011flar. Yukar\u0131da bahsedilen iki \u00f6rnek, bu i\u015flevin farkl\u0131 durumlarda nas\u0131l kullan\u0131labilece\u011fini g\u00f6stermektedir. Fonksiyon, finansal hesaplamalar, a\u011f ayarlar\u0131, g\u00fcvenlik protokolleri gibi \u00e7e\u015fitli alanlarda verimlili\u011fi art\u0131ran etkili bir ara\u00e7 olarak \u00f6n plana \u00e7\u0131kmaktad\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":" Kayd\u0131rma_miktar\u0131 bit kadar sa\u011fa kayd\u0131r\u0131lan bir de\u011fer say\u0131s\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[583],"tags":[],"class_list":["post-15293","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"\nBITRSHIFT<\/code> ad\u0131 verilirken, Google E-Tablolar’da da benzer bir i\u015flev kullan\u0131l\u0131r. \u0130\u015fte bu i\u015flevin detayl\u0131 bir a\u00e7\u0131klamas\u0131.<\/p>\nSa\u011fa Kayd\u0131rma Fonksiyonunun Kullan\u0131m\u0131<\/h2>\n
=BITRSHIFT(say\u0131, kayd\u0131rma_bit_say\u0131s\u0131) <\/code> <\/pre>\n\n
Pratik Uygulamalar ve \u00c7\u00f6z\u00fcmler<\/h2>\n
1. \u00d6rnek: Basit Sa\u011fa Kayd\u0131rma<\/h3>\n
=BITRSHIFT(64, 2) \/\/ Sonu\u00e7: 16 <\/code> <\/pre>\n2. \u00d6rbe\u00f6k: IP Adresi Ayr\u0131\u015ft\u0131rma<\/h3>\n
\/\/=bit_and(bitrshift(3232235777, 24), 255) \/\/ IP'nin ilk b\u00f6l\u00fcm\u00fcn\u00fc al\u0131r: 192 \/\/=bit_and(bitrshift(3232235777, 16), 255) \/\/ \u0130kinci b\u00f6l\u00fcm\u00fc al\u0131r: 168 \/\/=bit_and(bitrshift(3232235777, 8), 255) \/\/ \u00dc\u00e7\u00fcnc\u00fc b\u00f6l\u00fcm\u00fc al\u0131r: 1 \/\/=bit_and(3232235777, 255) \/\/ D\u00f6rd\u00fcnc\u00fc b\u00f6l\u00fcm\u00fc al\u0131r: 1 <\/code> <\/pre>\nSonu\u00e7<\/h2>\n