{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["ana girdiler","amerikan","Program","kaynatma suyu hesabı","maya tablosu","tahıl tablosu","serbetçi otu tablosu","malt donusum","sot donusum","şeker ve katkılar","utilisation chart"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ana girdiler","index":0,"n_rows":94,"n_cols":21,"rows_kept":94,"cut":false,"hidden":false,"merged":[[2,1,2,3],[3,1,3,3],[8,1,8,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[9,1,9,3],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[18,8,20,9],[23,14,23,15],[23,11,23,12],[11,0,12,0],[11,1,12,1],[11,2,12,2],[0,17,0,19],[1,17,1,19],[12,11,12,12],[0,13,0,15],[0,8,1,9],[1,13,1,15],[0,10,0,12],[35,11,35,12],[36,11,36,12],[24,14,24,15],[24,11,24,12],[32,3,32,6],[33,3,34,3],[33,4,34,6],[25,3,25,4],[28,3,30,4],[50,14,50,15],[73,3,74,3],[72,3,72,6],[73,4,74,6],[93,0,95,5]]}
["Sarı Alanları Giriniz",null,null,null,null,null,null,null,"METRİK REÇETE PROGRAMI",null,{"$f":"'ana girdiler'!B3","v":"English Bitter Ale"},null,null,"www.birazbira.com",null,null,null,"Fermantasyon Hacmini Değiştirin"]
[null,null,null,null,null,null,null,null,null,null,"HEDEFLENEN ÖLÇÜLER",null,null,{"$f":"IF(AND(Program!T23>0,Program!P51>0),\"Partial Mash Reçetesi\",IF(Program!T23>0,\"Tam Tahıl Reçetesi\",IF(Program!P51>0,\"Malt Özü-Extract Reçetesi\",0)))","v":"Tam Tahıl Reçetesi"},null,null,null,12,null,null,"sarı alana giriş yaparak hazırladığınız reçeteyi istediğiniz son hacimde oransal değiştirebilirsiniz"]
["Reçete İsmi","English Bitter Ale",null,null,null,null,null,null,null,null,"Fermantasyon Hacmi",{"$f":"IF(R2=0,('ana girdiler'!B4),R2)","v":12},"litre"]
["Fermantasyon Hacmi  (litre)",12,null,null,null,null,null,null,null,null,"Kaynatma Hacmi",{"$f":"'kaynatma suyu hesabı'!B30","v":15.48},"litre"]
["Mayşeleme Süresi (dak)",60,null,null,null,null,null,null,null,null,"İlk yoğunluk (OG)",{"$f":"IFERROR(((Program!K23*'ana girdiler'!B8/100)/('ana girdiler'!L3/3.79)+((Program!J51)/('ana girdiler'!L3/3.79))+1000),0)","v":1059.5320767195767}]
["Kaynatma Süresi (dak)",60,null,null,null,null,null,null,null,null,"Son Yoğunluk (FG)",{"$f":"IFERROR((((L5-1000)*(100-(VLOOKUP(Program!B4,'maya tablosu'!A2:D300,4,0)))/100)+1000),0)","v":1014.8830191798942}]
["Mayşeleme sıcaklığı (0C)",66,null,null,null,null,null,null,null,null,"Tahmini Kaynatma Yoğunluğu",{"$f":"IFERROR(((Program!K23*'ana girdiler'!B8/100)/(L4/3.79)+(Program!J51/(L4/3.79))+1000),0)","v":1046.1488966818424}]
["Mayşe Verimi %",75,null,null,null,null,null,null,null,null,"ABV (Alkol Oranı)",{"$f":"(L5-L6)*0.131","v":5.8490265376984114},"%"]
["Maya Seçimi","Fermentis Safale S-04 ",null,null,null,null,null,null,null,null,"Acılık",{"$f":"IFERROR(Program!I36,0)","v":43.719333333333324},"IBU"]
["protein dinlenmesi (dak)",null,null,null,null,null,null,null,null,null,"Renk (EBC)",{"$f":"IFERROR((Program!N51+Program!P23),0)","v":16.098398954340485},"EBC",{"$f":"L10","v":16.098398954340485}]
[null,null,null,null,null,null,null,null,null,null,"Fermantasyon Sıcaklığı",{"$f":"IFERROR((IF(Program!B5=\"ale\",\"18-22\",\"12-16\")),0)","v":"18-22"},"0C"]
[{"$f":"Program!A12","v":"Malt Türü"},{"$f":"Program!B12","v":"kg"},{"$f":"Program!C12","v":"g"},{"$f":"Program!D12","v":"mayşede % malt oranı kontrolü"},{"$f":"Program!F12","v":"% mayşede malt  yüzdesi"},{"$f":"Program!G12","v":"%mayşede max malt yüzdesi"},{"$f":"Program!L12","v":"% toplam ağırlıkta"},null,null,null,"Tahmini Kalori Hesabı (50cc için)",{"$f":"Program!E55","v":300.37545646239005},"cal"]
[null,null,null,null,null,null,null,null,null,null,"MALT MİKTARI","Malt Miktarı",null,"Yüzde"]
["Maris Otter (Muntons)",null,2700,{"$f":"IFERROR(Program!D13,0)","v":"yüzde uygun"},{"$f":"IFERROR(Program!F13,0)","v":90},{"$f":"Program!G13","v":100},{"$f":"IFERROR(Program!L13,0)","v":85.714285714285708},null,null,null,{"$f":"'ana girdiler'!A14","v":"Maris Otter (Muntons)"},{"$f":"IF((Program!H13)=0,0,Program!H13)","v":2700},{"$f":"IF(L14>0,\"g\",\" \")","v":"g"},{"$f":"IFERROR((Program!L13/100),0)","v":0.8571428571428571}]
["Munich II (weyermann)",null,300,{"$f":"IFERROR(Program!D14,0)","v":"yüzde uygun"},{"$f":"IFERROR(Program!F14,0)","v":10},{"$f":"Program!G14","v":10},{"$f":"IFERROR(Program!L14,0)","v":9.5238095238095237},null,null,null,{"$f":"'ana girdiler'!A15","v":"Munich II (weyermann)"},{"$f":"IF((Program!H14)=0,0,Program!H14)","v":300},{"$f":"IF(L15>0,\"g\",\" \")","v":"g"},{"$f":"IFERROR((Program!L14/100),0)","v":9.5238095238095233E-2}]
[null,null,null,{"$f":"IFERROR(Program!D15,0)","v":0},{"$f":"IFERROR(Program!F15,0)","v":0},{"$f":"Program!G15","v":0},{"$f":"IFERROR(Program!L15,0)","v":0},null,null,null,{"$f":"'ana girdiler'!A16","v":0},{"$f":"IF((Program!H15)=0,0,Program!H15)","v":0},{"$f":"IF(L16>0,\"g\",\" \")","v":" "},{"$f":"IFERROR((Program!L15/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D16,0)","v":0},{"$f":"IFERROR(Program!F16,0)","v":0},{"$f":"Program!G16","v":0},{"$f":"IFERROR(Program!L16,0)","v":0},null,null,null,{"$f":"'ana girdiler'!A17","v":0},{"$f":"IF((Program!H16)=0,0,Program!H16)","v":0},{"$f":"IF(L17>0,\"g\",\" \")","v":" "},{"$f":"IFERROR((Program!L16/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D17,0)","v":0},{"$f":"IFERROR(Program!F17,0)","v":0},{"$f":"Program!G17","v":0},{"$f":"IFERROR(Program!L17,0)","v":0},null,null,null,{"$f":"'ana girdiler'!A18","v":0},{"$f":"IF((Program!H17)=0,0,Program!H17)","v":0}," ",{"$f":"IFERROR((Program!L17/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D18,0)","v":0},{"$f":"IFERROR(Program!F18,0)","v":0},{"$f":"Program!G18","v":0},{"$f":"IFERROR(Program!L18,0)","v":0},null,"TEMEL REÇETELER",null,{"$f":"'ana girdiler'!A19","v":0},{"$f":"IF((Program!H18)=0,0,Program!H18)","v":0}," ",{"$f":"IFERROR((Program!L18/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D19,0)","v":0},{"$f":"IFERROR(Program!F19,0)","v":0},{"$f":"Program!G19","v":0},{"$f":"IFERROR(Program!L19,0)","v":0},null,null,null,{"$f":"'ana girdiler'!A20","v":0},{"$f":"IF((Program!H19)=0,0,Program!H19)","v":0}," ",{"$f":"IFERROR((Program!L19/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D20,0)","v":0},{"$f":"IFERROR(Program!F20,0)","v":0},{"$f":"Program!G20","v":0},{"$f":"IFERROR(Program!L20,0)","v":0},null,null,null,{"$f":"'ana girdiler'!A21","v":0},{"$f":"IF((Program!H20)=0,0,Program!H20)","v":0}," ",{"$f":"IFERROR((Program!L20/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D21,0)","v":0},{"$f":"IFERROR(Program!F21,0)","v":0},{"$f":"Program!G21","v":0},{"$f":"IFERROR(Program!L21,0)","v":0},null,null,null,{"$f":"'ana girdiler'!A22","v":0},{"$f":"IF((Program!H21)=0,0,Program!H21)","v":0}," ",{"$f":"IFERROR((Program!L21/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D22,0)","v":0},{"$f":"IFERROR(Program!F22,0)","v":0},{"$f":"Program!G22","v":0},{"$f":"IFERROR(Program!L22,0)","v":0},null,null,null,{"$f":"'ana girdiler'!A23","v":0},{"$f":"IF((Program!H22)=0,0,Program!H22)","v":0}," ",{"$f":"IFERROR((Program!L22/100),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"ŞERBETÇİ OTU MİKTARI","Şot Miktarı",null,"Alfa Asit%","Kaynatma Süresi"]
[null,null,null,"Diastatik Güç Kontrolü",null,null,null,null,null,null,{"$f":"'ana girdiler'!A41","v":"Perle"},{"$f":"IFERROR(Program!F26,0)","v":12},{"$f":"IF(L26>0,\"g\",\" \")","v":"g"},{"$f":"'ana girdiler'!E41/100","v":7.2999999999999995E-2},{"$f":"IF(AND(C41=0,K26>0),\"whirpool\",'ana girdiler'!C41)","v":60},{"$f":"IF(O26=\"whirpool\",\"soğuk ek.\",IF(O26>0,\"dakika\",0))","v":"dakika"}]
[null,null,null,"Mayşe Diastatik Gücü ",{"$f":"IF(N2=\"Tam Tahıl Reçetesi\",(IFERROR((Program!R23/(Program!H23)),0)),0)","v":55.8},null,null,null,null,null,{"$f":"'ana girdiler'!A42","v":"Target"},{"$f":"IFERROR(Program!F27,0)","v":20},"g",{"$f":"'ana girdiler'!E42/100","v":0.107},{"$f":"IF(AND(C42=0,K27>0),\"whirpool\",'ana girdiler'!C42)","v":20},"dakika"]
[null,null,null,"Diastatik Güç kontrolü",{"$f":"IF(N2=\"Tam Tahıl Reçetesi\",(IF(E27>40,\"uygun\",\"uygun değil\")),0)","v":"uygun"},null,null,null,null,null,{"$f":"'ana girdiler'!A43","v":"Perle"},{"$f":"IFERROR(Program!F28,0)","v":25},"g",{"$f":"'ana girdiler'!E43/100","v":7.2999999999999995E-2},{"$f":"IF(AND(C43=0,K28>0),\"whirpool\",'ana girdiler'!C43)","v":5},"dakika"]
[null,null,null,"İkinci kontrol diastatik kontroldür malt % kontrolü maltları teker teker kontrol ederken bu kontrol Lintern derecesi ile kontrole eder. Diastatik sınır 40 alınmıştır.",null,null,null,null,null,null,{"$f":"'ana girdiler'!A44","v":"Target"},{"$f":"IFERROR(Program!F29,0)","v":25},"g",{"$f":"'ana girdiler'!E44/100","v":0.107},{"$f":"IF(AND(C44=0,K29>0),\"whirpool\",'ana girdiler'!C44)","v":"whirpool"},"soğuk ek."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'ana girdiler'!A45","v":"Tettnang"},{"$f":"IFERROR(Program!F30,0)","v":10},"g",{"$f":"'ana girdiler'!E45/100","v":4.2000000000000003E-2},{"$f":"IF(AND(C45=0,K30>0),\"whirpool\",'ana girdiler'!C45)","v":"whirpool"},{"$f":"IF(O30=\"whirpool\",\"soğuk ek.\",IF(O30>0,\"dakika\",0))","v":"soğuk ek."}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'ana girdiler'!A46","v":0},{"$f":"IFERROR(Program!F31,0)","v":0}," ",{"$f":"'ana girdiler'!E46/100","v":0},{"$f":"IF(AND(C46=0,K31>0),\"whirpool\",'ana girdiler'!C46)","v":0},{"$f":"IF(O31=\"whirpool\",\"soğuk ek.\",IF(O31>0,\"dakika\",0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'ana girdiler'!A47","v":0},{"$f":"IFERROR(Program!F32,0)","v":0}," ",{"$f":"'ana girdiler'!E47/100","v":0},{"$f":"IF(AND(C47=0,K32>0),\"whirpool\",'ana girdiler'!C47)","v":0},0]
[null,null,null,"Mayşe Oranı (toplam malt / ilk su hacmi)",null,null,null,null,null,null,{"$f":"'ana girdiler'!A48","v":0},{"$f":"IFERROR(Program!F33,0)","v":0}," ",{"$f":"'ana girdiler'!E48/100","v":0},{"$f":"IF(AND(C48=0,K33>0),\"whirpool\",'ana girdiler'!C48)","v":0},0]
[null,null,null,{"$f":"IF(N2=\"Partial Mash Reçetesi\",0,IFERROR(((Program!H23/1000)/'kaynatma suyu hesabı'!B26),0))","v":0.2},"Genelde  1/3 , 1/4 veya 1/5 olmalı",null,null,null,null,null,{"$f":"'ana girdiler'!A49","v":0},{"$f":"IFERROR(Program!F34,0)","v":0}," ",{"$f":"'ana girdiler'!E49/100","v":0},{"$f":"IF(AND(C49=0,K34>0),\"whirpool\",'ana girdiler'!C49)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'ana girdiler'!A50","v":0},{"$f":"IFERROR(Program!F35,0)","v":0}," ",{"$f":"'ana girdiler'!E50/100","v":0},{"$f":"IF(AND(C50=0,K35>0),\"whirpool\",'ana girdiler'!C50)","v":0},0]
[]
[null,null,null,null,null,null,null,null,null,null,"MALT DIŞI KATKILAR- MALT ÖZLERİ","Katkı Miktarı",null,"Yüzde"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'ana girdiler'!A61","v":"Akçağaç Şurubu"},{"$f":"Program!G41","v":150},{"$f":"IF(L38>0,\"g\",\" \")","v":"g"},{"$f":"IFERROR((Program!E41/100),0)","v":4.7619047619047616E-2}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'ana girdiler'!A62","v":0},{"$f":"Program!G42","v":0}," ",{"$f":"IFERROR((Program!E42/100),0)","v":0}]
[{"$f":"Program!A25","v":"Şerbetçi Otu Türü"},{"$f":"Program!B25","v":"g"},{"$f":"Program!C25","v":"dak."},{"$f":"Program!D25","v":"Önerilen Kullanım şekli"},{"$f":"Program!E25","v":"AA %"},null,null,null,null,null,{"$f":"'ana girdiler'!A63","v":0},{"$f":"Program!G43","v":0}," ",{"$f":"IFERROR((Program!E43/100),0)","v":0}]
["Perle",12,60,{"$f":"IF(A41=0,0,(VLOOKUP(A41,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":"Acılık"},{"$f":"IF(A41=0,0,VLOOKUP(A41,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":7.3},null,null,null,null,null,{"$f":"'ana girdiler'!A64","v":0},{"$f":"Program!G44","v":0}," ",{"$f":"IFERROR((Program!E44/100),0)","v":0}]
["Target",20,20,{"$f":"IF(A42=0,0,(VLOOKUP(A42,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":"Acılık"},{"$f":"IF(A42=0,0,VLOOKUP(A42,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":10.7},null,null,null,null,null,{"$f":"'ana girdiler'!A65","v":0},{"$f":"Program!G45","v":0}," ",{"$f":"IFERROR((Program!E45/100),0)","v":0}]
["Perle",25,5,{"$f":"IF(A43=0,0,(VLOOKUP(A43,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":"Acılık"},{"$f":"IF(A43=0,0,VLOOKUP(A43,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":7.3},null,null,null,null,null,{"$f":"'ana girdiler'!A66","v":0},{"$f":"Program!G46","v":0}," ",{"$f":"IFERROR((Program!E46/100),0)","v":0}]
["Target",25,0,{"$f":"IF(A44=0,0,(VLOOKUP(A44,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":"Acılık"},{"$f":"IF(A44=0,0,VLOOKUP(A44,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":10.7},null,null,null,null,null,{"$f":"'ana girdiler'!A67","v":0},{"$f":"Program!G47","v":0}," ",{"$f":"IFERROR((Program!E47/100),0)","v":0}]
["Tettnang",10,0,{"$f":"IF(A45=0,0,(VLOOKUP(A45,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":"Aroma"},{"$f":"IF(A45=0,0,VLOOKUP(A45,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":4.2},null,null,null,null,null,{"$f":"'ana girdiler'!A68","v":0},{"$f":"Program!G48","v":0}," ",{"$f":"IFERROR((Program!E48/100),0)","v":0}]
[null,null,null,{"$f":"IF(A46=0,0,(VLOOKUP(A46,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A46=0,0,VLOOKUP(A46,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,{"$f":"'ana girdiler'!A69","v":0},{"$f":"Program!G49","v":0}," ",{"$f":"IFERROR((Program!E49/100),0)","v":0}]
[null,null,null,{"$f":"IF(A47=0,0,(VLOOKUP(A47,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A47=0,0,VLOOKUP(A47,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,{"$f":"'ana girdiler'!A70","v":0},{"$f":"Program!G50","v":0},{"$f":"IF(L47>0,\"g\",\" \")","v":" "},{"$f":"IFERROR((Program!E50/100),0)","v":0}]
[null,null,null,{"$f":"IF(A48=0,0,(VLOOKUP(A48,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A48=0,0,VLOOKUP(A48,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,"MAYA","Kuru Maya Miktarı"]
[null,null,null,{"$f":"IF(A49=0,0,(VLOOKUP(A49,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A49=0,0,VLOOKUP(A49,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,{"$f":"Program!B4","v":"Fermentis Safale S-04 "},{"$f":"IFERROR((IF(Program!B5=\"ale\",(750000*L3*((L5-1000)/4)/20000000),(IF(Program!B5=\"lager\",(1500000*L3*((L5-1000)/4)/20000000),0)))),0)","v":6.6973586309523796},"g"]
[null,null,null,{"$f":"IF(A50=0,0,(VLOOKUP(A50,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A50=0,0,VLOOKUP(A50,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"ADIMLAR","litre","derece 0C","dakika",{"$f":"IF(L52>0,\"Çift Kademeli\",\"Tek Kademeli\")","v":"Tek Kademeli"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A26","v":"Protein Dinlenmesi"},{"$f":"IF($B$10=0,0,'kaynatma suyu hesabı'!B26)","v":0},{"$f":"IF($B$10=0,0,(\"44-59\"))","v":0},{"$f":"B10","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A27","v":"Mayşeleme"},{"$f":"IF($B$5=0,0,'kaynatma suyu hesabı'!B27)","v":15},{"$f":"IF($B$5=0,0,(B7))","v":66},{"$f":"'ana girdiler'!B5","v":60}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A28","v":"Mayşelemeden sonraki hacim(mash-out)"},{"$f":"IF($B$5=0,0,'kaynatma suyu hesabı'!B28)","v":11.5},{"$f":"IF($B$5=0,0,75)","v":75},{"$f":"IF($B$5=0,0,10)","v":10}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A29","v":"Yağmurlama (Sparge)"},{"$f":"IF($B$5=0,0,'kaynatma suyu hesabı'!B29)","v":3.8300000000000005},{"$f":"IF($B$5=0,0,75)","v":75},{"$f":"IF($B$5=0,0,\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A30","v":"Tahmini kaynatma hacmi"},{"$f":"'kaynatma suyu hesabı'!B30","v":15.48},">100",{"$f":"'ana girdiler'!B6","v":60}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A31","v":"Toplam kullanılacak su miktarı"},{"$f":"'kaynatma suyu hesabı'!B31","v":18.830000000000002}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A32","v":"Minimum kaynatma kazanı hacmi"},{"$f":"'kaynatma suyu hesabı'!B32","v":18}]
[]
[{"$f":"Program!A40","v":"Malt Dışı Katkılar ve Malt Özleri"},{"$f":"Program!B40","v":"kg"},{"$f":"Program!C40","v":"g"},{"$f":"Program!D40","v":"toplam  %şeker katkı kontrolü"},{"$f":"Program!E40","v":"% toplam ağırıkta "},{"$f":"Program!F40","v":"%maks şeker ve katkı"},null,null,null,null,null,"Irish Moss Miktarı"]
["Akçağaç Şurubu",null,150,{"$f":"IFERROR(Program!D41,0)","v":"yüzde uygun"},{"$f":"IFERROR(Program!E41,0)","v":4.7619047619047619},{"$f":"Program!F41","v":10},null,null,null,null,"Irish Moss",{"$f":"0.2*L56","v":3.0960000000000001},"g"]
[null,null,null,{"$f":"IFERROR(Program!D42,0)","v":0},{"$f":"IFERROR(Program!E42,0)","v":0},{"$f":"Program!F42","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D43,0)","v":0},{"$f":"IFERROR(Program!E43,0)","v":0},{"$f":"Program!F43","v":0},null,null,null,null,"mayşeleme su kaybı saatte 0.5 litre olarak kabul edilmiştir"]
[null,null,null,{"$f":"IFERROR(Program!D44,0)","v":0},{"$f":"IFERROR(Program!E44,0)","v":0},{"$f":"Program!F44","v":0},null,null,null,null,"kaynatma su kaybı saatte 3 litre olarak kabul edilmiştir"]
[null,null,null,{"$f":"IFERROR(Program!D45,0)","v":0},{"$f":"IFERROR(Program!E45,0)","v":0},{"$f":"Program!F45","v":0},null,null,null,null,"Tahmini ölü yer ve tahmini çökelme kaybı 0 olarak kabul edilmiştir."]
[null,null,null,{"$f":"IFERROR(Program!D46,0)","v":0},{"$f":"IFERROR(Program!E46,0)","v":0},{"$f":"Program!F46","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D47,0)","v":0},{"$f":"IFERROR(Program!E47,0)","v":0},{"$f":"Program!F47","v":0},null,null,null,null,"yukarıdaki kabuller tek kademeli normal BIAB süreci içindir "]
[null,null,null,{"$f":"IFERROR(Program!D48,0)","v":0},{"$f":"IFERROR(Program!E48,0)","v":0},{"$f":"Program!F48","v":0},null,null,null,null,"aksi halde kaynatma suyu hesabını değiştirin"]
[null,null,null,{"$f":"IFERROR(Program!D49,0)","v":0},{"$f":"IFERROR(Program!E49,0)","v":0},{"$f":"Program!F49","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D50,0)","v":0},{"$f":"IFERROR(Program!E50,0)","v":0},{"$f":"Program!F50","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Fermantasyon Kabı Hacmi",{"$f":"(L3/3)*4","v":16},"litre"]
[]
[null,null,null,"DME cinsinden  malt özü oranı (toplam DME/ils su hacmi)",null,null,null,null,null,null,"Genç Bira Hacmi",{"$f":"L3*0.85","v":10.199999999999999},"litre"]
[null,null,null,{"$f":"IFERROR(((Program!Q51+0.84*Program!R51)/1000)/'kaynatma suyu hesabı'!B26,0)","v":0},"Genelde 1/4, 1/6 veya 1/8 olmalı",null,null,null,null,null,"(ikinci fermantasyon yapılırsa biranın en az"]
[null,null,null,null,null,null,null,null,null,null,"0,15 oranında hacmi dökülecektir)"]
[]
[null,null,null,null,null,null,null,null,null,null,"KİŞİSEL NOTLAR"]
[]
[]
[]
[]
["Kaynatma Suyu Değerleri","miktar","birim"]
["44-59 derecede protein rest",0.3,"litre/s","protein dinlenmesi bölümü opsiyoneldir"]
["Ortalama 66 derecede mayşeleme",0.5,"litre/s","standart olarak ortalama 660C'de  0,5 litre girilmiştir."]
["Kaynatma Süresi",3,"litre/s","standart olarak ortalama 3 litre girilmiştir."]
["Tahmini Ölü yer kaybı",0,"litre","bu alan ekipmanın dibinde kalan sıvıdır bunu elle girmeniz gerekir,mayşelemeden sonra sıvının hepsini kullanıyorsanız 0 kalabilir."]
["Tahmini çökelme   kaybı",0,"litre","özellikle mash-tun tekniğinde dipte çökelen maddelerdir bunu varsa elle girmeniz gerekir,BIAB yönteminde 0 olabilir."]
[]
[]
[]
[]
[]
[]
["TABLO AYARLARI"]

{"sheet":"amerikan","index":1,"n_rows":87,"n_cols":21,"rows_kept":87,"cut":false,"hidden":true,"merged":[[93,0,95,9],[72,3,72,6],[73,3,74,3],[73,4,74,6],[25,3,25,4],[28,3,30,4],[32,3,32,6],[33,3,34,3],[33,4,34,6],[50,14,50,15],[11,6,12,6],[12,11,12,12],[23,11,23,12],[23,14,23,15],[24,11,24,12],[24,14,24,15],[36,11,36,12],[35,11,35,12],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[2,1,2,3],[0,8,1,9],[0,10,0,12],[0,13,0,15],[0,17,0,19],[1,17,1,19],[1,13,1,15]]}
["Sarı Alanları Giriniz",null,null,null,null,null,null,null,"AMERİKAN REÇETESİ ",null,{"$f":"amerikan!B3","v":0},null,null,"www.birazbira.com",null,null,null,"Fermantasyon Hacmini Değiştirin"]
[null,null,null,null,null,null,null,null,null,null,"HEDEFLENEN ÖLÇÜLER",null,null,{"$f":"IF(AND(Program!T23>0,Program!P51>0),\"Partial Mash Reçetesi\",IF(Program!T23>0,\"Tam Tahıl Reçetesi\",IF(Program!P51>0,\"Malt Özü-Extract Reçetesi\",0)))","v":"Tam Tahıl Reçetesi"},null,null,null,0,null,null,"sarı alana giriş yaparak hazırladığınız reçeteyi istediğiniz son hacimde oransal değiştirebilirsiniz"]
["Reçete İsmi",null,null,null,null,null,null,null,null,null,"Fermantasyon Hacmi",{"$f":"IF(R2=0,(amerikan!B4*Program!C60),R2)","v":0},"litre"]
["Fermantasyon Hacmi (us gallon)",null,null,null,null,null,null,null,null,null,"Kaynatma Hacmi",{"$f":"'kaynatma suyu hesabı'!B30","v":15.48},"litre"]
["Mayşeleme Süresi (dak)",null,null,null,null,null,null,null,null,null,"İlk yoğunluk (OG)",{"$f":"IFERROR(((Program!K23*amerikan!B8/100)/(amerikan!L3/3.79)+((Program!J51)/(amerikan!L3/3.79))+1000),0)","v":0}]
["Kaynatma Süresi (dak)",null,null,null,null,null,null,null,null,null,"Son Yoğunluk (FG)",{"$f":"IFERROR((((L5-1000)*(100-(VLOOKUP(Program!B4,'maya tablosu'!A2:D300,4,0)))/100)+1000),0)","v":750}]
["Mayşeleme sıcaklığı (fahreneit)",null,null,null,null,null,null,null,null,null,"Tahmini Kaynatma Yoğunluğu",{"$f":"IFERROR(((Program!K23*amerikan!B8/100)/(L4/3.79)+(Program!J51/(L4/3.79))+1000),0)","v":1002.4288892990444}]
["Mayşe Verimi %",null,null,null,null,null,null,null,null,null,"ABV (Alkol Oranı)",{"$f":"(L5-L6)*0.131","v":-98.25},"%"]
["Maya Seçimi",null,null,null,null,null,null,null,null,null,"Acılık",{"$f":"IFERROR(Program!I36,0)","v":43.719333333333324},"IBU"]
["protein dinlenmesi (dak)",null,null,null,null,null,null,null,null,null,"Renk (EBC)",{"$f":"IFERROR((Program!N51+Program!P23),0)","v":16.098398954340485},"EBC",{"$f":"L10","v":16.098398954340485}]
[null,null,null,null,null,null,null,null,null,null,"Fermantasyon Sıcaklığı",{"$f":"IFERROR((IF(Program!B5=\"ale\",\"18-22\",\"12-16\")),0)","v":"18-22"},"0C"]
[{"$f":"Program!A12","v":"Malt Türü"},"libre","oz",{"$f":"Program!D12","v":"mayşede % malt oranı kontrolü"},{"$f":"Program!F12","v":"% mayşede malt  yüzdesi"},{"$f":"Program!G12","v":"%mayşede max malt yüzdesi"},{"$f":"Program!L12","v":"% toplam ağırlıkta"},null,null,null,"Tahmini Kalori Hesabı (50cc için)",{"$f":"Program!E55","v":300.37545646239005},"cal"]
[null,null,null,null,null,null,null,null,null,null,"MALT MİKTARI","Malt Miktarı",null,"Yüzde"]
[null,null,null,{"$f":"IFERROR(Program!D13,0)","v":"yüzde uygun"},{"$f":"IFERROR(Program!F13,0)","v":90},{"$f":"Program!G13","v":100},{"$f":"IFERROR(Program!L13,0)","v":85.714285714285708},null,null,null,{"$f":"amerikan!A14","v":0},{"$f":"IF((Program!H13)=0,0,Program!H13)","v":2700},{"$f":"IF(L14>0,\"g\",\" \")","v":"g"},{"$f":"IFERROR((Program!L13/100),0)","v":0.8571428571428571}]
[null,null,null,{"$f":"IFERROR(Program!D14,0)","v":"yüzde uygun"},{"$f":"IFERROR(Program!F14,0)","v":10},{"$f":"Program!G14","v":10},{"$f":"IFERROR(Program!L14,0)","v":9.5238095238095237},null,null,null,{"$f":"amerikan!A15","v":0},{"$f":"IF((Program!H14)=0,0,Program!H14)","v":300},{"$f":"IF(L15>0,\"g\",\" \")","v":"g"},{"$f":"IFERROR((Program!L14/100),0)","v":9.5238095238095233E-2}]
[null,null,null,{"$f":"IFERROR(Program!D15,0)","v":0},{"$f":"IFERROR(Program!F15,0)","v":0},{"$f":"Program!G15","v":0},{"$f":"IFERROR(Program!L15,0)","v":0},null,null,null,{"$f":"amerikan!A16","v":0},{"$f":"IF((Program!H15)=0,0,Program!H15)","v":0},{"$f":"IF(L16>0,\"g\",\" \")","v":" "},{"$f":"IFERROR((Program!L15/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D16,0)","v":0},{"$f":"IFERROR(Program!F16,0)","v":0},{"$f":"Program!G16","v":0},{"$f":"IFERROR(Program!L16,0)","v":0},null,null,null,{"$f":"amerikan!A17","v":0},{"$f":"IF((Program!H16)=0,0,Program!H16)","v":0},{"$f":"IF(L17>0,\"g\",\" \")","v":" "},{"$f":"IFERROR((Program!L16/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D17,0)","v":0},{"$f":"IFERROR(Program!F17,0)","v":0},{"$f":"Program!G17","v":0},{"$f":"IFERROR(Program!L17,0)","v":0},null,null,null,{"$f":"amerikan!A18","v":0},{"$f":"IF((Program!H17)=0,0,Program!H17)","v":0}," ",{"$f":"IFERROR((Program!L17/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D18,0)","v":0},{"$f":"IFERROR(Program!F18,0)","v":0},{"$f":"Program!G18","v":0},{"$f":"IFERROR(Program!L18,0)","v":0},null,null,null,{"$f":"amerikan!A19","v":0},{"$f":"IF((Program!H18)=0,0,Program!H18)","v":0}," ",{"$f":"IFERROR((Program!L18/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D19,0)","v":0},{"$f":"IFERROR(Program!F19,0)","v":0},{"$f":"Program!G19","v":0},{"$f":"IFERROR(Program!L19,0)","v":0},null,null,null,{"$f":"amerikan!A20","v":0},{"$f":"IF((Program!H19)=0,0,Program!H19)","v":0}," ",{"$f":"IFERROR((Program!L19/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D20,0)","v":0},{"$f":"IFERROR(Program!F20,0)","v":0},{"$f":"Program!G20","v":0},{"$f":"IFERROR(Program!L20,0)","v":0},null,null,null,{"$f":"amerikan!A21","v":0},{"$f":"IF((Program!H20)=0,0,Program!H20)","v":0}," ",{"$f":"IFERROR((Program!L20/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D21,0)","v":0},{"$f":"IFERROR(Program!F21,0)","v":0},{"$f":"Program!G21","v":0},{"$f":"IFERROR(Program!L21,0)","v":0},null,null,null,{"$f":"amerikan!A22","v":0},{"$f":"IF((Program!H21)=0,0,Program!H21)","v":0}," ",{"$f":"IFERROR((Program!L21/100),0)","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D22,0)","v":0},{"$f":"IFERROR(Program!F22,0)","v":0},{"$f":"Program!G22","v":0},{"$f":"IFERROR(Program!L22,0)","v":0},null,null,null,{"$f":"amerikan!A23","v":0},{"$f":"IF((Program!H22)=0,0,Program!H22)","v":0}," ",{"$f":"IFERROR((Program!L22/100),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"ŞERBETÇİ OTU MİKTARI","Şot Miktarı",null,"Alfa Asit%","Kaynatma Süresi"]
[null,null,null,"Diastatik Güç Kontrolü",null,null,null,null,null,null,{"$f":"amerikan!A41","v":0},{"$f":"Program!F26","v":12},{"$f":"IF(L26>0,\"g\",\" \")","v":"g"},{"$f":"amerikan!E41/100","v":0},{"$f":"IF(AND(C41=0,K26>0),\"whirpool\",amerikan!C41)","v":0},{"$f":"IF(O26=\"whirpool\",\"soğuk ek.\",IF(O26>0,\"dakika\",0))","v":0}]
[null,null,null,"Mayşe Diastatik Gücü ",{"$f":"IF(N2=\"Tam Tahıl Reçetesi\",(IFERROR((Program!R23/(Program!H23)),0)),0)","v":55.8},null,null,null,null,null,{"$f":"amerikan!A42","v":0},{"$f":"Program!F27","v":20},"g",{"$f":"amerikan!E42/100","v":0},{"$f":"IF(AND(C42=0,K27>0),\"whirpool\",amerikan!C42)","v":0},{"$f":"IF(O27=\"whirpool\",\"soğuk ek.\",IF(O27>0,\"dakika\",0))","v":0}]
[null,null,null,"Diastatik Güç kontrolü",{"$f":"IF(N2=\"Tam Tahıl Reçetesi\",(IF(E27>40,\"uygun\",\"uygun değil\")),0)","v":"uygun"},null,null,null,null,null,{"$f":"amerikan!A43","v":0},{"$f":"Program!F28","v":25},"g",{"$f":"amerikan!E43/100","v":0},{"$f":"IF(AND(C43=0,K28>0),\"whirpool\",amerikan!C43)","v":0},{"$f":"IF(O28=\"whirpool\",\"soğuk ek.\",IF(O28>0,\"dakika\",0))","v":0}]
[null,null,null,"İkinci kontrol diastatik kontroldür malt % kontrolü maltları teker teker kontrol ederken bu kontrol Lintern derecesi ile kontrole eder. Diastatik sınır 40 alınmıştır.",null,null,null,null,null,null,{"$f":"amerikan!A44","v":0},{"$f":"Program!F29","v":25},"g",{"$f":"amerikan!E44/100","v":0},{"$f":"IF(AND(C44=0,K29>0),\"whirpool\",amerikan!C44)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"amerikan!A45","v":0},{"$f":"Program!F30","v":10},"g",{"$f":"amerikan!E45/100","v":0},{"$f":"IF(AND(C45=0,K30>0),\"whirpool\",amerikan!C45)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"amerikan!A46","v":0},{"$f":"Program!F31","v":0}," ",{"$f":"amerikan!E46/100","v":0},{"$f":"IF(AND(C46=0,K31>0),\"whirpool\",amerikan!C46)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"amerikan!A47","v":0},{"$f":"Program!F32","v":0}," ",{"$f":"amerikan!E47/100","v":0},{"$f":"IF(AND(C47=0,K32>0),\"whirpool\",amerikan!C47)","v":0},0]
[null,null,null,"Mayşe Oranı (toplam malt / ilk su hacmi)",null,null,null,null,null,null,{"$f":"amerikan!A48","v":0},{"$f":"Program!F33","v":0}," ",{"$f":"amerikan!E48/100","v":0},{"$f":"IF(AND(C48=0,K33>0),\"whirpool\",amerikan!C48)","v":0},0]
[null,null,null,{"$f":"IF(N2=\"Partial Mash Reçetesi\",0,IFERROR(((Program!H23/1000)/'kaynatma suyu hesabı'!B26),0))","v":0.2},"Genelde 1/3 , 1/4 veya 1/5 olmalı",null,null,null,null,null,{"$f":"amerikan!A49","v":0},{"$f":"Program!F34","v":0}," ",{"$f":"amerikan!E49/100","v":0},{"$f":"IF(AND(C49=0,K34>0),\"whirpool\",amerikan!C49)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"amerikan!A50","v":0},{"$f":"Program!F35","v":0}," ",{"$f":"amerikan!E50/100","v":0},{"$f":"IF(AND(C50=0,K35>0),\"whirpool\",amerikan!C50)","v":0},0]
[]
[null,null,null,null,null,null,null,null,null,null,"MALT DIŞI KATKILAR- MALT ÖZLERİ","Katkı Miktarı",null,"Yüzde"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"amerikan!A61","v":0},{"$f":"Program!G41","v":150},{"$f":"IF(L38>0,\"g\",\" \")","v":"g"},{"$f":"IFERROR((Program!E41/100),0)","v":4.7619047619047616E-2}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"amerikan!A62","v":0},{"$f":"Program!G42","v":0}," ",{"$f":"IFERROR((Program!E42/100),0)","v":0}]
[{"$f":"Program!A25","v":"Şerbetçi Otu Türü"},"oz",{"$f":"Program!C25","v":"dak."},{"$f":"Program!D25","v":"Önerilen Kullanım şekli"},{"$f":"Program!E25","v":"AA %"},null,null,null,null,null,{"$f":"amerikan!A63","v":0},{"$f":"Program!G43","v":0}," ",{"$f":"IFERROR((Program!E43/100),0)","v":0}]
[null,null,null,{"$f":"IF(A41=0,0,(VLOOKUP(A41,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A41=0,0,VLOOKUP(A41,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,{"$f":"amerikan!A64","v":0},{"$f":"Program!G44","v":0}," ",{"$f":"IFERROR((Program!E44/100),0)","v":0}]
[null,null,null,{"$f":"IF(A42=0,0,(VLOOKUP(A42,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A42=0,0,VLOOKUP(A42,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,{"$f":"amerikan!A65","v":0},{"$f":"Program!G45","v":0}," ",{"$f":"IFERROR((Program!E45/100),0)","v":0}]
[null,null,null,{"$f":"IF(A43=0,0,(VLOOKUP(A43,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A43=0,0,VLOOKUP(A43,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,{"$f":"amerikan!A66","v":0},{"$f":"Program!G46","v":0}," ",{"$f":"IFERROR((Program!E46/100),0)","v":0}]
[null,null,null,{"$f":"IF(A44=0,0,(VLOOKUP(A44,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A44=0,0,VLOOKUP(A44,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,{"$f":"amerikan!A67","v":0},{"$f":"Program!G47","v":0}," ",{"$f":"IFERROR((Program!E47/100),0)","v":0}]
[null,null,null,{"$f":"IF(A45=0,0,(VLOOKUP(A45,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A45=0,0,VLOOKUP(A45,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,{"$f":"amerikan!A68","v":0},{"$f":"Program!G48","v":0}," ",{"$f":"IFERROR((Program!E48/100),0)","v":0}]
[null,null,null,{"$f":"IF(A46=0,0,(VLOOKUP(A46,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A46=0,0,VLOOKUP(A46,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,{"$f":"amerikan!A69","v":0},{"$f":"Program!G49","v":0}," ",{"$f":"IFERROR((Program!E49/100),0)","v":0}]
[null,null,null,{"$f":"IF(A47=0,0,(VLOOKUP(A47,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A47=0,0,VLOOKUP(A47,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,{"$f":"amerikan!A70","v":0},{"$f":"Program!G50","v":0}," ",{"$f":"IFERROR((Program!E50/100),0)","v":0}]
[null,null,null,{"$f":"IF(A48=0,0,(VLOOKUP(A48,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A48=0,0,VLOOKUP(A48,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,"MAYA","Kuru Maya Miktarı"]
[null,null,null,{"$f":"IF(A49=0,0,(VLOOKUP(A49,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A49=0,0,VLOOKUP(A49,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},null,null,null,null,null,{"$f":"Program!B4","v":"Fermentis Safale S-04 "},{"$f":"IFERROR((IF(Program!B5=\"ale\",(750000*L3*((L5-1000)/4)/20000000),(IF(Program!B5=\"lager\",(1500000*L3*((L5-1000)/4)/20000000),0)))),0)","v":0},"g"]
[null,null,null,{"$f":"IF(A50=0,0,(VLOOKUP(A50,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A50=0,0,VLOOKUP(A50,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"ADIMLAR","litre","derece 0C","dakika",{"$f":"IF(L52>0,\"Çift Kademeli\",\"Tek Kademeli\")","v":"Tek Kademeli"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A26","v":"Protein Dinlenmesi"},{"$f":"IF($B$10=0,0,'kaynatma suyu hesabı'!B26)","v":0},{"$f":"IF($B$10=0,0,(\"44-59\"))","v":0},{"$f":"B10","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A27","v":"Mayşeleme"},{"$f":"IF($B$5=0,0,'kaynatma suyu hesabı'!B27)","v":0},{"$f":"IF($B$5=0,0,(((amerikan!B7-32)*5)/9 ))","v":0},{"$f":"amerikan!B5","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A28","v":"Mayşelemeden sonraki hacim(mash-out)"},{"$f":"IF($B$5=0,0,'kaynatma suyu hesabı'!B28)","v":0},{"$f":"IF($B$5=0,0,75)","v":0},{"$f":"IF($B$5=0,0,10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A29","v":"Yağmurlama (Sparge)"},{"$f":"IF($B$5=0,0,'kaynatma suyu hesabı'!B29)","v":0},{"$f":"IF($B$5=0,0,75)","v":0},{"$f":"IF($B$5=0,0,\"-\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A30","v":"Tahmini kaynatma hacmi"},{"$f":"'kaynatma suyu hesabı'!B30","v":15.48},">100",{"$f":"amerikan!B6","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A31","v":"Toplam kullanılacak su miktarı"},{"$f":"'kaynatma suyu hesabı'!B31","v":18.830000000000002}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'kaynatma suyu hesabı'!A32","v":"Minimum kaynatma kazanı hacmi"},{"$f":"'kaynatma suyu hesabı'!B32","v":18}]
[]
[{"$f":"Program!A40","v":"Malt Dışı Katkılar ve Malt Özleri"},"libre","oz",{"$f":"Program!D40","v":"toplam  %şeker katkı kontrolü"},{"$f":"Program!E40","v":"% toplam ağırıkta "},{"$f":"Program!F40","v":"%maks şeker ve katkı"},null,null,null,null,null,"Irish Moss Miktarı"]
[null,null,null,{"$f":"IFERROR(Program!D41,0)","v":"yüzde uygun"},{"$f":"IFERROR(Program!E41,0)","v":4.7619047619047619},{"$f":"Program!F41","v":10},null,null,null,null,"Irish Moss",{"$f":"(0.2*L56)","v":3.0960000000000001},"g"]
[null,null,null,{"$f":"IFERROR(Program!D42,0)","v":0},{"$f":"IFERROR(Program!E42,0)","v":0},{"$f":"Program!F42","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D43,0)","v":0},{"$f":"IFERROR(Program!E43,0)","v":0},{"$f":"Program!F43","v":0},null,null,null,null,"mayşeleme su kaybı saatte 0.5 litre olarak kabul edilmiştir"]
[null,null,null,{"$f":"IFERROR(Program!D44,0)","v":0},{"$f":"IFERROR(Program!E44,0)","v":0},{"$f":"Program!F44","v":0},null,null,null,null,"kaynatma su kaybı saatte 3 litre olarak kabul edilmiştir"]
[null,null,null,{"$f":"IFERROR(Program!D45,0)","v":0},{"$f":"IFERROR(Program!E45,0)","v":0},{"$f":"Program!F45","v":0},null,null,null,null,"Tahmini ölü yer ve tahmini çökelme kaybı 0 olarak kabul edilmiştir."]
[null,null,null,{"$f":"IFERROR(Program!D46,0)","v":0},{"$f":"IFERROR(Program!E46,0)","v":0},{"$f":"Program!F46","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D47,0)","v":0},{"$f":"IFERROR(Program!E47,0)","v":0},{"$f":"Program!F47","v":0},null,null,null,null,"yukarıdaki kabuller tek kademeli normal BIAB süreci içindir "]
[null,null,null,{"$f":"IFERROR(Program!D48,0)","v":0},{"$f":"IFERROR(Program!E48,0)","v":0},{"$f":"Program!F48","v":0},null,null,null,null,"aksi halde kaynatma suyu hesabını değiştirin"]
[null,null,null,{"$f":"IFERROR(Program!D49,0)","v":0},{"$f":"IFERROR(Program!E49,0)","v":0},{"$f":"Program!F49","v":0}]
[null,null,null,{"$f":"IFERROR(Program!D50,0)","v":0},{"$f":"IFERROR(Program!E50,0)","v":0},{"$f":"Program!F50","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Fermantasyon Kabı Hacmi",{"$f":"(L3/3)*4","v":0},"litre"]
[]
[null,null,null,"DME cinsinden  malt özü oranı (toplam DME/ils su hacmi)",null,null,null,null,null,null,"Genç Bira Hacmi",{"$f":"L3*0.85","v":0},"litre"]
[null,null,null,{"$f":"IFERROR(((Program!Q51+0.84*Program!R51)/1000)/'kaynatma suyu hesabı'!B26,0)","v":0},"Genelde 1/4, 1/6 veya 1/8 olmalı",null,null,null,null,null,"(ikinci fermantasyon yapılırsa biranın en az"]
[null,null,null,null,null,null,null,null,null,null,"0,15 oranında hacmi dökülecektir)"]
[]
[null,null,null,null,null,null,null,null,null,null,"KİŞİSEL NOTLAR"]
[]
[]
[]
[]
["Kaynatma Suyu Değerleri","miktar","birim"]
["44-59 derecede protein rest",0.3,"litre/s","protein dinlenmesi bölümü opsiyoneldir"]
["Ortalama 66 derecede mayşeleme",0.5,"litre/s","standart olarak ortalama 660C'de  0,5 litre girilmiştir."]
["Kaynatma Süresi",3,"litre/s","standart olarak ortalama 3 litre girilmiştir."]
["Tahmini Ölü yer kaybı",0,"litre","bu alan ekipmanın dibinde kalan sıvıdır bunu elle girmeniz gerekir,mayşelemeden sonra sıvının hepsini kullanıyorsanız 0 kalabilir."]
["Tahmini çökelme   kaybı",0,"litre","özellikle mash-tun tekniğinde dipte çökelen maddelerdir bunu varsa elle girmeniz gerekir,BIAB yönteminde 0 olabilir."]

{"sheet":"Program","index":2,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":true,"merged":[[10,1,10,7],[4,1,4,3],[53,1,53,3],[3,1,3,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[57,1,57,3],[54,1,54,3],[53,4,53,5],[54,4,54,5],[23,1,23,7]]}
["Lütfen Sarı Alanları Giriniz"]
[]
[]
["Maya Seçimi",{"$f":"IF(('ana girdiler'!B9)=0,(amerikan!B9),('ana girdiler'!B9))","v":"Fermentis Safale S-04 "}]
["Maya Tipi",{"$f":"VLOOKUP(B4,'maya tablosu'!A$2:D$299,2,0)","v":"ale"}]
["orjinal tasarım / modifiye tasarım",{"$f":"B8/B7","v":1}]
["Fermantasyon Hacmi",{"$f":"IF(('ana girdiler'!B4)=0,(amerikan!B4*C60),('ana girdiler'!B4))","v":12}]
["Modifiye Fermantasyon Hacmi",{"$f":"IF(('ana girdiler'!R2=0),(amerikan!R2),('ana girdiler'!R2))","v":12}]
["Kaynatma Yoğunluğu",{"$f":"IF(('ana girdiler'!L3)=0,(amerikan!L7),('ana girdiler'!L7))","v":1046.1488966818424}]
[]
[]
["Malt Türü","kg","g","mayşede % malt oranı kontrolü","Cinsi","% mayşede malt  yüzdesi","%mayşede max malt yüzdesi","Toplam malt (g)","Toplam(g) pound","ppg","ppg x ağırlık","% toplam ağırlıkta","renk (SRM)","renk (lovibond)","malt MCU","Düzeltilmiş EBC","Lintern Derecesi"," Lintern Değeri","Kontrol","Nümerik Kontrol"]
[{"$f":"IF(('ana girdiler'!A14)=0,(amerikan!A14),('ana girdiler'!A14))","v":"Maris Otter (Muntons)"},{"$f":"IF(('ana girdiler'!B14)=0,(IF($B$8=0,(amerikan!B14*$C$61),((amerikan!B14*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B14),(('ana girdiler'!B14)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C14)=0,(IF($B$8=0,(amerikan!C14*$C$59),((amerikan!C14*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C14),(('ana girdiler'!C14)*$B$6))))","v":2700},{"$f":"IF(A13=0,0,IF((F13>G13),\"yüzdeyi kontrol edin\",\"yüzde uygun\"))","v":"yüzde uygun"},{"$f":"IF(A13=0,0,VLOOKUP(A13,'tahıl tablosu'!A$2:F$35,2,0))","v":"Malt"},{"$f":"IF(A13=0,0,(H13*100/($H$23)))","v":90},{"$f":"IF(A13=0,0,VLOOKUP(A13,'tahıl tablosu'!A$2:F$35,6,0))","v":100},{"$f":"(B13*1000)+(C13)","v":2700},{"$f":"H13/453.6","v":5.9523809523809517},{"$f":"IF(A13=0,0,VLOOKUP(A13,'tahıl tablosu'!A$2:F$35,5,0)-1000)","v":36},{"$f":"(I13*J13)","v":214.28571428571425},{"$f":"IF(A13=0,0,H13*100/($H$23+$G$51))","v":85.714285714285708},{"$f":"IF(A13=0,0,VLOOKUP(A13,'tahıl tablosu'!A$2:F$35,3,0))","v":2.2999999999999998},{"$f":"(M13+0.76)/1.35","v":2.2666666666666662},{"$f":"IF(A13=0,0,((H13/1000)*N13*2.205)/(IF($B$8=0,($B$7*0.264),($B$7*0.264*$B$6))))","v":4.2596590909090901},{"$f":"POWER(O13,0.6859)*1.4922*1.97","v":7.9429433779706651},{"$f":"IF(A13=0,0,VLOOKUP(A13,'tahıl tablosu'!A$2:F$35,4))","v":62},{"$f":"H13*Q13","v":167400},{"$f":"IF(A13=0,0,VLOOKUP(A13,'tahıl tablosu'!$A$2:$F$35,2,0))","v":"Malt"},{"$f":"IF(S13=\"Malt\",1,0)","v":1}]
[{"$f":"IF(('ana girdiler'!A15)=0,(amerikan!A15),('ana girdiler'!A15))","v":"Munich II (weyermann)"},{"$f":"IF(('ana girdiler'!B15)=0,(IF($B$8=0,(amerikan!B15*$C$61),((amerikan!B15*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B15),(('ana girdiler'!B15)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C15)=0,(IF($B$8=0,(amerikan!C15*$C$59),((amerikan!C15*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C15),(('ana girdiler'!C15)*$B$6))))","v":300},"yüzde uygun",{"$f":"IF(A14=0,0,VLOOKUP(A14,'tahıl tablosu'!A$2:F$35,2,0))","v":"Malt"},{"$f":"IF(A14=0,0,(H14*100/($H$23)))","v":10},{"$f":"IF(A14=0,0,VLOOKUP(A14,'tahıl tablosu'!A$2:F$35,6,0))","v":10},{"$f":"(B14*1000)+(C14)","v":300},{"$f":"H14/453.6","v":0.66137566137566139},{"$f":"IF(A14=0,0,VLOOKUP(A14,'tahıl tablosu'!A$2:F$35,5,0)-1000)","v":36},23.80952380952381,{"$f":"IF(A14=0,0,H14*100/($H$23+$G$51))","v":9.5238095238095237},{"$f":"IF(A14=0,0,VLOOKUP(A14,'tahıl tablosu'!A$2:F$35,3,0))","v":11},{"$f":"(M14+0.76)/1.35","v":8.7111111111111104},{"$f":"IF(A14=0,0,((H14/1000)*N14*2.205)/(IF($B$8=0,($B$7*0.264),($B$7*0.264*$B$6))))","v":1.8189393939393936},{"$f":"POWER(O14,0.6859)*1.4922","v":2.2492429029565755},{"$f":"IF(A14=0,0,VLOOKUP(A14,'tahıl tablosu'!A$2:F$35,4))","v":0},0,{"$f":"IF(A14=0,0,VLOOKUP(A14,'tahıl tablosu'!$A$2:$F$35,2,0))","v":"Malt"},{"$f":"IF(S14=\"Malt\",1,0)","v":1}]
[{"$f":"IF(('ana girdiler'!A16)=0,(amerikan!A16),('ana girdiler'!A16))","v":0},{"$f":"IF(('ana girdiler'!B16)=0,(IF($B$8=0,(amerikan!B16*$C$61),((amerikan!B16*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B16),(('ana girdiler'!B16)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C16)=0,(IF($B$8=0,(amerikan!C16*$C$59),((amerikan!C16*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C16),(('ana girdiler'!C16)*$B$6))))","v":0},0,{"$f":"IF(A15=0,0,VLOOKUP(A15,'tahıl tablosu'!A$2:F$35,2,0))","v":0},0,{"$f":"IF(A15=0,0,VLOOKUP(A15,'tahıl tablosu'!A$2:F$35,6,0))","v":0},0,0,{"$f":"IF(A15=0,0,VLOOKUP(A15,'tahıl tablosu'!A$2:F$35,5,0)-1000)","v":0},0,0,{"$f":"IF(A15=0,0,VLOOKUP(A15,'tahıl tablosu'!A$2:F$35,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A15=0,0,VLOOKUP(A15,'tahıl tablosu'!A$2:F$35,4))","v":0},0,{"$f":"IF(A15=0,0,VLOOKUP(A15,'tahıl tablosu'!$A$2:$F$35,2,0))","v":0},0]
[{"$f":"IF(('ana girdiler'!A17)=0,(amerikan!A17),('ana girdiler'!A17))","v":0},{"$f":"IF(('ana girdiler'!B17)=0,(IF($B$8=0,(amerikan!B17*$C$61),((amerikan!B17*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B17),(('ana girdiler'!B17)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C17)=0,(IF($B$8=0,(amerikan!C17*$C$59),((amerikan!C17*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C17),(('ana girdiler'!C17)*$B$6))))","v":0},0,{"$f":"IF(A16=0,0,VLOOKUP(A16,'tahıl tablosu'!A$2:F$35,2,0))","v":0},0,{"$f":"IF(A16=0,0,VLOOKUP(A16,'tahıl tablosu'!A$2:F$35,6,0))","v":0},0,0,{"$f":"IF(A16=0,0,VLOOKUP(A16,'tahıl tablosu'!A$2:F$35,5,0)-1000)","v":0},0,0,{"$f":"IF(A16=0,0,VLOOKUP(A16,'tahıl tablosu'!A$2:F$35,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A16=0,0,VLOOKUP(A16,'tahıl tablosu'!A$2:F$35,4))","v":0},0,{"$f":"IF(A16=0,0,VLOOKUP(A16,'tahıl tablosu'!$A$2:$F$35,2,0))","v":0},0]
[{"$f":"IF(('ana girdiler'!A18)=0,(amerikan!A18),('ana girdiler'!A18))","v":0},{"$f":"IF(('ana girdiler'!B18)=0,(IF($B$8=0,(amerikan!B18*$C$61),((amerikan!B18*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B18),(('ana girdiler'!B18)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C18)=0,(IF($B$8=0,(amerikan!C18*$C$59),((amerikan!C18*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C18),(('ana girdiler'!C18)*$B$6))))","v":0},0,{"$f":"IF(A17=0,0,VLOOKUP(A17,'tahıl tablosu'!A$2:F$35,2,0))","v":0},0,{"$f":"IF(A17=0,0,VLOOKUP(A17,'tahıl tablosu'!A$2:F$35,6,0))","v":0},0,0,{"$f":"IF(A17=0,0,VLOOKUP(A17,'tahıl tablosu'!A$2:F$35,5,0)-1000)","v":0},0,0,{"$f":"IF(A17=0,0,VLOOKUP(A17,'tahıl tablosu'!A$2:F$35,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A17=0,0,VLOOKUP(A17,'tahıl tablosu'!A$2:F$35,4))","v":0},0,{"$f":"IF(A17=0,0,VLOOKUP(A17,'tahıl tablosu'!$A$2:$F$35,2,0))","v":0},0]
[{"$f":"IF(('ana girdiler'!A19)=0,(amerikan!A19),('ana girdiler'!A19))","v":0},{"$f":"IF(('ana girdiler'!B19)=0,(IF($B$8=0,(amerikan!B19*$C$61),((amerikan!B19*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B19),(('ana girdiler'!B19)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C19)=0,(IF($B$8=0,(amerikan!C19*$C$59),((amerikan!C19*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C19),(('ana girdiler'!C19)*$B$6))))","v":0},0,{"$f":"IF(A18=0,0,VLOOKUP(A18,'tahıl tablosu'!A$2:F$35,2,0))","v":0},0,{"$f":"IF(A18=0,0,VLOOKUP(A18,'tahıl tablosu'!A$2:F$35,6,0))","v":0},0,0,{"$f":"IF(A18=0,0,VLOOKUP(A18,'tahıl tablosu'!A$2:F$35,5,0)-1000)","v":0},0,0,{"$f":"IF(A18=0,0,VLOOKUP(A18,'tahıl tablosu'!A$2:F$35,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A18=0,0,VLOOKUP(A18,'tahıl tablosu'!A$2:F$35,4))","v":0},0,{"$f":"IF(A18=0,0,VLOOKUP(A18,'tahıl tablosu'!$A$2:$F$35,2,0))","v":0},0]
[{"$f":"IF(('ana girdiler'!A20)=0,(amerikan!A20),('ana girdiler'!A20))","v":0},{"$f":"IF(('ana girdiler'!B20)=0,(IF($B$8=0,(amerikan!B20*$C$61),((amerikan!B20*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B20),(('ana girdiler'!B20)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C20)=0,(IF($B$8=0,(amerikan!C20*$C$59),((amerikan!C20*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C20),(('ana girdiler'!C20)*$B$6))))","v":0},0,{"$f":"IF(A19=0,0,VLOOKUP(A19,'tahıl tablosu'!A$2:F$35,2,0))","v":0},0,{"$f":"IF(A19=0,0,VLOOKUP(A19,'tahıl tablosu'!A$2:F$35,6,0))","v":0},0,0,{"$f":"IF(A19=0,0,VLOOKUP(A19,'tahıl tablosu'!A$2:F$35,5,0)-1000)","v":0},0,0,{"$f":"IF(A19=0,0,VLOOKUP(A19,'tahıl tablosu'!A$2:F$35,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A19=0,0,VLOOKUP(A19,'tahıl tablosu'!A$2:F$35,4))","v":0},0,{"$f":"IF(A19=0,0,VLOOKUP(A19,'tahıl tablosu'!$A$2:$F$35,2,0))","v":0},0]
[{"$f":"IF(('ana girdiler'!A21)=0,(amerikan!A21),('ana girdiler'!A21))","v":0},{"$f":"IF(('ana girdiler'!B21)=0,(IF($B$8=0,(amerikan!B21*$C$61),((amerikan!B21*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B21),(('ana girdiler'!B21)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C21)=0,(IF($B$8=0,(amerikan!C21*$C$59),((amerikan!C21*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C21),(('ana girdiler'!C21)*$B$6))))","v":0},0,{"$f":"IF(A20=0,0,VLOOKUP(A20,'tahıl tablosu'!A$2:F$35,2,0))","v":0},0,{"$f":"IF(A20=0,0,VLOOKUP(A20,'tahıl tablosu'!A$2:F$35,6,0))","v":0},0,0,{"$f":"IF(A20=0,0,VLOOKUP(A20,'tahıl tablosu'!A$2:F$35,5,0)-1000)","v":0},0,0,{"$f":"IF(A20=0,0,VLOOKUP(A20,'tahıl tablosu'!A$2:F$35,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A20=0,0,VLOOKUP(A20,'tahıl tablosu'!A$2:F$35,4))","v":0},0,{"$f":"IF(A20=0,0,VLOOKUP(A20,'tahıl tablosu'!$A$2:$F$35,2,0))","v":0},0]
[{"$f":"IF(('ana girdiler'!A22)=0,(amerikan!A22),('ana girdiler'!A22))","v":0},{"$f":"IF(('ana girdiler'!B22)=0,(IF($B$8=0,(amerikan!B22*$C$61),((amerikan!B22*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B22),(('ana girdiler'!B22)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C22)=0,(IF($B$8=0,(amerikan!C22*$C$59),((amerikan!C22*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C22),(('ana girdiler'!C22)*$B$6))))","v":0},0,{"$f":"IF(A21=0,0,VLOOKUP(A21,'tahıl tablosu'!A$2:F$35,2,0))","v":0},0,{"$f":"IF(A21=0,0,VLOOKUP(A21,'tahıl tablosu'!A$2:F$35,6,0))","v":0},0,0,{"$f":"IF(A21=0,0,VLOOKUP(A21,'tahıl tablosu'!A$2:F$35,5,0)-1000)","v":0},0,0,{"$f":"IF(A21=0,0,VLOOKUP(A21,'tahıl tablosu'!A$2:F$35,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A21=0,0,VLOOKUP(A21,'tahıl tablosu'!A$2:F$35,4))","v":0},0,{"$f":"IF(A21=0,0,VLOOKUP(A21,'tahıl tablosu'!$A$2:$F$35,2,0))","v":0},0]
[{"$f":"IF(('ana girdiler'!A23)=0,(amerikan!A23),('ana girdiler'!A23))","v":0},{"$f":"IF(('ana girdiler'!B23)=0,(IF($B$8=0,(amerikan!B23*$C$61),((amerikan!B23*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B23),(('ana girdiler'!B23)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C23)=0,(IF($B$8=0,(amerikan!C23*$C$59),((amerikan!C23*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C23),(('ana girdiler'!C23)*$B$6))))","v":0},0,{"$f":"IF(A22=0,0,VLOOKUP(A22,'tahıl tablosu'!A$2:F$35,2,0))","v":0},0,{"$f":"IF(A22=0,0,VLOOKUP(A22,'tahıl tablosu'!A$2:F$35,6,0))","v":0},0,0,{"$f":"IF(A22=0,0,VLOOKUP(A22,'tahıl tablosu'!A$2:F$35,5,0)-1000)","v":0},0,0,{"$f":"IF(A22=0,0,VLOOKUP(A22,'tahıl tablosu'!A$2:F$35,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A22=0,0,VLOOKUP(A22,'tahıl tablosu'!A$2:F$35,4))","v":0},0,{"$f":"IF(A22=0,0,VLOOKUP(A22,'tahıl tablosu'!$A$2:$F$35,2,0))","v":0},0]
[null,null,null,null,null,null,"toplam malt",{"$f":"SUM(H13:H22)","v":3000},null,"toplam ppg",{"$f":"SUM(K13:K22)","v":238.09523809523807},null,null,null,"toplam EBC",{"$f":"SUM(P13:P22)","v":10.19218628092724},"toplam lintern",{"$f":"SUM(R13:R22)","v":167400},null,{"$f":"SUM(T13:T22)","v":2}]
[]
["Şerbetçi Otu Türü","g","dak.","Önerilen Kullanım şekli","AA %","g","u%","cg","IBU"]
[{"$f":"IF(('ana girdiler'!A41)=0,(amerikan!A41),('ana girdiler'!A41))","v":"Perle"},{"$f":"IF(('ana girdiler'!B41)=0,(IF($B$8=0,(amerikan!B41*$C$59),((amerikan!B41*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!B41),(('ana girdiler'!B41)*$B$6))))","v":12},{"$f":"IF(('ana girdiler'!C41)=0,(amerikan!C41),('ana girdiler'!C41))","v":60},{"$f":"IF(A26=0,0,(VLOOKUP(A26,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":"Acılık"},{"$f":"IF(A26=0,0,VLOOKUP(A26,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":7.3},{"$f":"B26","v":12},{"$f":"VLOOKUP(C26,'utilisation chart'!$A$4:$L$28,MATCH($B$9,'utilisation chart'!$B$3:$L$3,1)+1,1)","v":0.252},{"$f":"IF($B$9>1050,1+((($B$9-1050)/1000)/2),1)","v":1},{"$f":"IF(C26<16,0,(B26*G26*E26*1000)/(IF($B$8=0,($B$7*H26*100),($B$7*H26*100*$B$6))))","v":18.395999999999997}]
[{"$f":"IF(('ana girdiler'!A42)=0,(amerikan!A42),('ana girdiler'!A42))","v":"Target"},{"$f":"IF(('ana girdiler'!B42)=0,(IF($B$8=0,(amerikan!B42*$C$59),((amerikan!B42*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!B42),(('ana girdiler'!B42)*$B$6))))","v":20},{"$f":"IF(('ana girdiler'!C42)=0,(amerikan!C42),('ana girdiler'!C42))","v":20},{"$f":"IF(A27=0,0,(VLOOKUP(A27,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":"Acılık"},{"$f":"IF(A27=0,0,VLOOKUP(A27,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":10.7},20,{"$f":"VLOOKUP(C27,'utilisation chart'!$A$4:$L$28,MATCH($B$9,'utilisation chart'!$B$3:$L$3,1)+1,1)","v":0.14199999999999999},{"$f":"IF($B$9>1050,1+((($B$9-1050)/1000)/2),1)","v":1},{"$f":"IF(C27<16,0,(B27*G27*E27*1000)/(IF($B$8=0,($B$7*H27*100),($B$7*H27*100*$B$6))))","v":25.323333333333331}]
[{"$f":"IF(('ana girdiler'!A43)=0,(amerikan!A43),('ana girdiler'!A43))","v":"Perle"},{"$f":"IF(('ana girdiler'!B43)=0,(IF($B$8=0,(amerikan!B43*$C$59),((amerikan!B43*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!B43),(('ana girdiler'!B43)*$B$6))))","v":25},{"$f":"IF(('ana girdiler'!C43)=0,(amerikan!C43),('ana girdiler'!C43))","v":5},{"$f":"IF(A28=0,0,(VLOOKUP(A28,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":"Acılık"},{"$f":"IF(A28=0,0,VLOOKUP(A28,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":7.3},25,{"$f":"VLOOKUP(C28,'utilisation chart'!$A$4:$L$28,MATCH($B$9,'utilisation chart'!$B$3:$L$3,1)+1,1)","v":3.1E-2},1,0]
[{"$f":"IF(('ana girdiler'!A44)=0,(amerikan!A44),('ana girdiler'!A44))","v":"Target"},{"$f":"IF(('ana girdiler'!B44)=0,(IF($B$8=0,(amerikan!B44*$C$59),((amerikan!B44*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!B44),(('ana girdiler'!B44)*$B$6))))","v":25},{"$f":"IF(('ana girdiler'!C44)=0,(amerikan!C44),('ana girdiler'!C44))","v":0},{"$f":"IF(A29=0,0,(VLOOKUP(A29,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":"Acılık"},{"$f":"IF(A29=0,0,VLOOKUP(A29,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":10.7},25,{"$f":"VLOOKUP(C29,'utilisation chart'!$A$4:$L$28,MATCH($B$9,'utilisation chart'!$B$3:$L$3,1)+1,1)","v":0},1,0]
[{"$f":"IF(('ana girdiler'!A45)=0,(amerikan!A45),('ana girdiler'!A45))","v":"Tettnang"},{"$f":"IF(('ana girdiler'!B45)=0,(IF($B$8=0,(amerikan!B45*$C$59),((amerikan!B45*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!B45),(('ana girdiler'!B45)*$B$6))))","v":10},{"$f":"IF(('ana girdiler'!C45)=0,(amerikan!C45),('ana girdiler'!C45))","v":0},{"$f":"IF(A30=0,0,(VLOOKUP(A30,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":"Aroma"},{"$f":"IF(A30=0,0,VLOOKUP(A30,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":4.2},10,{"$f":"VLOOKUP(C30,'utilisation chart'!$A$4:$L$28,MATCH($B$9,'utilisation chart'!$B$3:$L$3,1)+1,1)","v":0},1,0]
[{"$f":"IF(('ana girdiler'!A46)=0,(amerikan!A46),('ana girdiler'!A46))","v":0},{"$f":"IF(('ana girdiler'!B46)=0,(IF($B$8=0,(amerikan!B46*$C$59),((amerikan!B46*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!B46),(('ana girdiler'!B46)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C46)=0,(amerikan!C46),('ana girdiler'!C46))","v":0},{"$f":"IF(A31=0,0,(VLOOKUP(A31,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A31=0,0,VLOOKUP(A31,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},0,{"$f":"VLOOKUP(C31,'utilisation chart'!$A$4:$L$28,MATCH($B$9,'utilisation chart'!$B$3:$L$3,1)+1,1)","v":0},1,0]
[{"$f":"IF(('ana girdiler'!A47)=0,(amerikan!A47),('ana girdiler'!A47))","v":0},{"$f":"IF(('ana girdiler'!B47)=0,(IF($B$8=0,(amerikan!B47*$C$59),((amerikan!B47*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!B47),(('ana girdiler'!B47)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C47)=0,(amerikan!C47),('ana girdiler'!C47))","v":0},{"$f":"IF(A32=0,0,(VLOOKUP(A32,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A32=0,0,VLOOKUP(A32,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},0,{"$f":"VLOOKUP(C32,'utilisation chart'!$A$4:$L$28,MATCH($B$9,'utilisation chart'!$B$3:$L$3,1)+1,1)","v":0},1,0]
[{"$f":"IF(('ana girdiler'!A48)=0,(amerikan!A48),('ana girdiler'!A48))","v":0},{"$f":"IF(('ana girdiler'!B48)=0,(IF($B$8=0,(amerikan!B48*$C$59),((amerikan!B48*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!B48),(('ana girdiler'!B48)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C48)=0,(amerikan!C48),('ana girdiler'!C48))","v":0},{"$f":"IF(A33=0,0,(VLOOKUP(A33,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A33=0,0,VLOOKUP(A33,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},0,{"$f":"VLOOKUP(C33,'utilisation chart'!$A$4:$L$28,MATCH($B$9,'utilisation chart'!$B$3:$L$3,1)+1,1)","v":0},1,0]
[{"$f":"IF(('ana girdiler'!A49)=0,(amerikan!A49),('ana girdiler'!A49))","v":0},{"$f":"IF(('ana girdiler'!B49)=0,(IF($B$8=0,(amerikan!B49*$C$59),((amerikan!B49*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!B49),(('ana girdiler'!B49)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C49)=0,(amerikan!C49),('ana girdiler'!C49))","v":0},{"$f":"IF(A34=0,0,(VLOOKUP(A34,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A34=0,0,VLOOKUP(A34,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},0,{"$f":"VLOOKUP(C34,'utilisation chart'!$A$4:$L$28,MATCH($B$9,'utilisation chart'!$B$3:$L$3,1)+1,1)","v":0},1,0]
[{"$f":"IF(('ana girdiler'!A50)=0,(amerikan!A50),('ana girdiler'!A50))","v":0},{"$f":"IF(('ana girdiler'!B50)=0,(IF($B$8=0,(amerikan!B50*$C$59),((amerikan!B50*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!B50),(('ana girdiler'!B50)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C50)=0,(amerikan!C50),('ana girdiler'!C50))","v":0},{"$f":"IF(A35=0,0,(VLOOKUP(A35,'serbetçi otu tablosu'!A$2:D$30,4,0)))","v":0},{"$f":"IF(A35=0,0,VLOOKUP(A35,'serbetçi otu tablosu'!A$1:D$30,3,0))","v":0},0,{"$f":"VLOOKUP(C35,'utilisation chart'!$A$4:$L$28,MATCH($B$9,'utilisation chart'!$B$3:$L$3,1)+1,1)","v":0},1,0]
[null,null,null,null,null,null,null,"toplam IBU",{"$f":"SUM(I26:I35)","v":43.719333333333324}]
[]
[]
[]
["Malt Dışı Katkılar ve Malt Özleri","kg","g","toplam  %şeker katkı kontrolü","% toplam ağırıkta ","%maks şeker ve katkı","Toplam (g)","toplam(pound)","ppg","ppg x ağırlık","renk (SRM)","renk (lovibond)","katkı şeker MCU","Düzeltilmiş EBC","Kontrol","Nümerik Kontrol","DME Kontrol","LME Kontrol"]
[{"$f":"IF(('ana girdiler'!A61)=0,(amerikan!A61),('ana girdiler'!A61))","v":"Akçağaç Şurubu"},{"$f":"IF(('ana girdiler'!B61)=0,(IF($B$8=0,(amerikan!B61*$C$61),((amerikan!B61*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B61),(('ana girdiler'!B61)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C61)=0,(IF($B$8=0,(amerikan!C61*$C$59),((amerikan!C61*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C61),(('ana girdiler'!C61)*$B$6))))","v":150},{"$f":"IF(A41=0,0,IF((E41>F41),\"yüzdeyi kontrol edin\",\"yüzde uygun\"))","v":"yüzde uygun"},{"$f":"G41*100/($H$23+$G$51+$J$24)","v":4.7619047619047619},{"$f":"IF(A41=0,0,VLOOKUP(A41,'şeker ve katkılar'!A$2:E$298,5,0))","v":10},{"$f":"(B41*1000)+(C41)","v":150},{"$f":"G41/453.6","v":0.3306878306878307},{"$f":"IF(A41=0,0,VLOOKUP(A41,'şeker ve katkılar'!A$2:E$298,4,0)-1000)","v":30},{"$f":"H41*I41","v":9.9206349206349209},{"$f":"IF(A41=0,0,VLOOKUP(A41,'şeker ve katkılar'!A$2:E$298,3,0))","v":35},{"$f":"(K41+0.76)/1.35","v":26.488888888888887},{"$f":"((G41/1000)*L41*2.205)/((IF($B$8=0,($B$7*0.264),($B$7*0.264*$B$6))))","v":2.7655303030303027},{"$f":"POWER(M41,0.6859)*1.4922*1.97","v":5.9062126734132452},{"$f":"IF(A41=0,0,VLOOKUP(A41,'şeker ve katkılar'!$A$2:$E$300,2,0))","v":"Katkı"},{"$f":"IF(OR(O41=\"LME\",O41=\"DME\"),1,0)","v":0},{"$f":"IF(O41=\"DME\",G41,0)","v":0},{"$f":"IF(O41=\"LME\",G41,0)","v":0}]
[{"$f":"IF(('ana girdiler'!A62)=0,(amerikan!A62),('ana girdiler'!A62))","v":0},{"$f":"IF(('ana girdiler'!B62)=0,(IF($B$8=0,(amerikan!B62*$C$61),((amerikan!B62*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B62),(('ana girdiler'!B62)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C62)=0,(IF($B$8=0,(amerikan!C62*$C$59),((amerikan!C62*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C62),(('ana girdiler'!C62)*$B$6))))","v":0},0,{"$f":"G42*100/($H$23+$G$51)","v":0},{"$f":"IF(A42=0,0,VLOOKUP(A42,'şeker ve katkılar'!A$2:E$298,5,0))","v":0},0,{"$f":"G42/453.6","v":0},{"$f":"IF(A42=0,0,VLOOKUP(A42,'şeker ve katkılar'!A$2:E$298,4,0)-1000)","v":0},0,{"$f":"IF(A42=0,0,VLOOKUP(A42,'şeker ve katkılar'!A$2:E$298,3,0))","v":0},{"$f":"(K42+0.76)/1.35","v":0.56296296296296289},{"$f":"((G42/1000)*L42*2.205)/((IF($B$8=0,($B$7*0.264),($B$7*0.264*$B$6))))","v":0},{"$f":"POWER(M42,0.6859)*1.4922*1.97","v":0},{"$f":"IF(A42=0,0,VLOOKUP(A42,'şeker ve katkılar'!$A$2:$E$300,2,0))","v":0},{"$f":"IF(OR(O42=\"LME\",O42=\"DME\"),1,0)","v":0},{"$f":"IF(O42=\"DME\",G42,0)","v":0},{"$f":"IF(O42=\"LME\",G42,0)","v":0}]
[{"$f":"IF(('ana girdiler'!A63)=0,(amerikan!A63),('ana girdiler'!A63))","v":0},{"$f":"IF(('ana girdiler'!B63)=0,(IF($B$8=0,(amerikan!B63*$C$61),((amerikan!B63*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B63),(('ana girdiler'!B63)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C63)=0,(IF($B$8=0,(amerikan!C63*$C$59),((amerikan!C63*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C63),(('ana girdiler'!C63)*$B$6))))","v":0},0,0,{"$f":"IF(A43=0,0,VLOOKUP(A43,'şeker ve katkılar'!A$2:E$298,5,0))","v":0},0,0,{"$f":"IF(A43=0,0,VLOOKUP(A43,'şeker ve katkılar'!A$2:E$298,4,0)-1000)","v":0},0,{"$f":"IF(A43=0,0,VLOOKUP(A43,'şeker ve katkılar'!A$2:E$298,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A43=0,0,VLOOKUP(A43,'şeker ve katkılar'!$A$2:$E$300,2,0))","v":0},0,0,0]
[{"$f":"IF(('ana girdiler'!A64)=0,(amerikan!A64),('ana girdiler'!A64))","v":0},{"$f":"IF(('ana girdiler'!B64)=0,(IF($B$8=0,(amerikan!B64*$C$61),((amerikan!B64*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B64),(('ana girdiler'!B64)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C64)=0,(IF($B$8=0,(amerikan!C64*$C$59),((amerikan!C64*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C64),(('ana girdiler'!C64)*$B$6))))","v":0},0,0,{"$f":"IF(A44=0,0,VLOOKUP(A44,'şeker ve katkılar'!A$2:E$298,5,0))","v":0},0,0,{"$f":"IF(A44=0,0,VLOOKUP(A44,'şeker ve katkılar'!A$2:E$298,4,0)-1000)","v":0},0,{"$f":"IF(A44=0,0,VLOOKUP(A44,'şeker ve katkılar'!A$2:E$298,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A44=0,0,VLOOKUP(A44,'şeker ve katkılar'!$A$2:$E$300,2,0))","v":0},0,0,0]
[{"$f":"IF(('ana girdiler'!A65)=0,(amerikan!A65),('ana girdiler'!A65))","v":0},{"$f":"IF(('ana girdiler'!B65)=0,(IF($B$8=0,(amerikan!B65*$C$61),((amerikan!B65*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B65),(('ana girdiler'!B65)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C65)=0,(IF($B$8=0,(amerikan!C65*$C$59),((amerikan!C65*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C65),(('ana girdiler'!C65)*$B$6))))","v":0},0,0,{"$f":"IF(A45=0,0,VLOOKUP(A45,'şeker ve katkılar'!A$2:E$298,5,0))","v":0},0,0,{"$f":"IF(A45=0,0,VLOOKUP(A45,'şeker ve katkılar'!A$2:E$298,4,0)-1000)","v":0},0,{"$f":"IF(A45=0,0,VLOOKUP(A45,'şeker ve katkılar'!A$2:E$298,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A45=0,0,VLOOKUP(A45,'şeker ve katkılar'!$A$2:$E$300,2,0))","v":0},0,0,0]
[{"$f":"IF(('ana girdiler'!A66)=0,(amerikan!A66),('ana girdiler'!A66))","v":0},{"$f":"IF(('ana girdiler'!B66)=0,(IF($B$8=0,(amerikan!B66*$C$61),((amerikan!B66*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B66),(('ana girdiler'!B66)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C66)=0,(IF($B$8=0,(amerikan!C66*$C$59),((amerikan!C66*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C66),(('ana girdiler'!C66)*$B$6))))","v":0},0,0,{"$f":"IF(A46=0,0,VLOOKUP(A46,'şeker ve katkılar'!A$2:E$298,5,0))","v":0},0,0,{"$f":"IF(A46=0,0,VLOOKUP(A46,'şeker ve katkılar'!A$2:E$298,4,0)-1000)","v":0},0,{"$f":"IF(A46=0,0,VLOOKUP(A46,'şeker ve katkılar'!A$2:E$298,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A46=0,0,VLOOKUP(A46,'şeker ve katkılar'!$A$2:$E$300,2,0))","v":0},0,0,0]
[{"$f":"IF(('ana girdiler'!A67)=0,(amerikan!A67),('ana girdiler'!A67))","v":0},{"$f":"IF(('ana girdiler'!B67)=0,(IF($B$8=0,(amerikan!B67*$C$61),((amerikan!B67*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B67),(('ana girdiler'!B67)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C67)=0,(IF($B$8=0,(amerikan!C67*$C$59),((amerikan!C67*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C67),(('ana girdiler'!C67)*$B$6))))","v":0},0,0,{"$f":"IF(A47=0,0,VLOOKUP(A47,'şeker ve katkılar'!A$2:E$298,5,0))","v":0},0,0,{"$f":"IF(A47=0,0,VLOOKUP(A47,'şeker ve katkılar'!A$2:E$298,4,0)-1000)","v":0},0,{"$f":"IF(A47=0,0,VLOOKUP(A47,'şeker ve katkılar'!A$2:E$298,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A47=0,0,VLOOKUP(A47,'şeker ve katkılar'!$A$2:$E$300,2,0))","v":0},0,0,0]
[{"$f":"IF(('ana girdiler'!A68)=0,(amerikan!A68),('ana girdiler'!A68))","v":0},{"$f":"IF(('ana girdiler'!B68)=0,(IF($B$8=0,(amerikan!B68*$C$61),((amerikan!B68*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B68),(('ana girdiler'!B68)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C68)=0,(IF($B$8=0,(amerikan!C68*$C$59),((amerikan!C68*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C68),(('ana girdiler'!C68)*$B$6))))","v":0},0,0,{"$f":"IF(A48=0,0,VLOOKUP(A48,'şeker ve katkılar'!A$2:E$298,5,0))","v":0},0,0,{"$f":"IF(A48=0,0,VLOOKUP(A48,'şeker ve katkılar'!A$2:E$298,4,0)-1000)","v":0},0,{"$f":"IF(A48=0,0,VLOOKUP(A48,'şeker ve katkılar'!A$2:E$298,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A48=0,0,VLOOKUP(A48,'şeker ve katkılar'!$A$2:$E$300,2,0))","v":0},0,0,0]
[{"$f":"IF(('ana girdiler'!A69)=0,(amerikan!A69),('ana girdiler'!A69))","v":0},{"$f":"IF(('ana girdiler'!B69)=0,(IF($B$8=0,(amerikan!B69*$C$61),((amerikan!B69*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B69),(('ana girdiler'!B69)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C69)=0,(IF($B$8=0,(amerikan!C69*$C$59),((amerikan!C69*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C69),(('ana girdiler'!C69)*$B$6))))","v":0},0,0,{"$f":"IF(A49=0,0,VLOOKUP(A49,'şeker ve katkılar'!A$2:E$298,5,0))","v":0},0,0,{"$f":"IF(A49=0,0,VLOOKUP(A49,'şeker ve katkılar'!A$2:E$298,4,0)-1000)","v":0},0,{"$f":"IF(A49=0,0,VLOOKUP(A49,'şeker ve katkılar'!A$2:E$298,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A49=0,0,VLOOKUP(A49,'şeker ve katkılar'!$A$2:$E$300,2,0))","v":0},0,0,0]
[{"$f":"IF(('ana girdiler'!A70)=0,(amerikan!A70),('ana girdiler'!A70))","v":0},{"$f":"IF(('ana girdiler'!B70)=0,(IF($B$8=0,(amerikan!B70*$C$61),((amerikan!B70*$C$61)*$B$6))),(IF($B$8=0,('ana girdiler'!B70),(('ana girdiler'!B70)*$B$6))))","v":0},{"$f":"IF(('ana girdiler'!C70)=0,(IF($B$8=0,(amerikan!C70*$C$59),((amerikan!C70*$C$59)*$B$6))),(IF($B$8=0,('ana girdiler'!C70),(('ana girdiler'!C70)*$B$6))))","v":0},0,0,{"$f":"IF(A50=0,0,VLOOKUP(A50,'şeker ve katkılar'!A$2:E$298,5,0))","v":0},0,0,{"$f":"IF(A50=0,0,VLOOKUP(A50,'şeker ve katkılar'!A$2:E$298,4,0)-1000)","v":0},0,{"$f":"IF(A50=0,0,VLOOKUP(A50,'şeker ve katkılar'!A$2:E$298,3,0))","v":0},0.56296296296296289,0,0,{"$f":"IF(A50=0,0,VLOOKUP(A50,'şeker ve katkılar'!$A$2:$E$300,2,0))","v":0},0,0,0]
[null,null,null,null,null,"toplam şeker ve katkı",{"$f":"SUM(G41:G50)","v":150},null,null,{"$f":"SUM(J41:J50)","v":9.9206349206349209},null,null,"toplam EBC",{"$f":"SUM(N41:N50)","v":5.9062126734132452},null,{"$f":"SUM(P41:P50)","v":0},{"$f":"SUM(Q41:Q50)","v":0},{"$f":"SUM(R41:R50)","v":0}]
[]
[]
["alkolden gelen kalori (kcal)","karbonhidrattan  gelen kalori (kcal)",null,null,"Toplam kalori (kcal)"]
[{"$f":"IF(('ana girdiler'!L3)=0,(1881.22*amerikan!L6*(amerikan!L5-amerikan!L6)/(1775-amerikan!L5)/1000),(1881.22*'ana girdiler'!L6*('ana girdiler'!L5-'ana girdiler'!L6)/(1775-'ana girdiler'!L5)/1000))","v":119.14551579815407},{"$f":"IF(('ana girdiler'!L3)=0,(((3550*amerikan!L6*((0.1808*amerikan!L5)+(0.8192*amerikan!L6)-1001)))/1000000),(((3550*'ana girdiler'!L6*((0.1808*'ana girdiler'!L5)+(0.8192*'ana girdiler'!L6)-1001)))/1000000))","v":79.102285467023393},null,null,{"$f":"((A55+B55)*0.5)/0.33","v":300.37545646239005}]
[]
[]
[null,"Birimler"]
[null,"1 oz",28.35,"g"]
[null,"1 gal",3.7850000000000001,"litre"]
[null,"1 libre",0.4536,"kg"]

{"sheet":"kaynatma suyu hesabı","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[34,0,34,6]]}
["Lütfen Sarı alanları  İhtiyaç Varsa Doldurunuz"]
["Yeşil Alanlar Sonuçtur"]
[]
["ANA GİRDİLER","Süre","Birim"]
["Hedef Şıra",{"$f":"IF(('ana girdiler'!L3)=0,(amerikan!L3),('ana girdiler'!L3))","v":12},"litre"]
["Toplam Malt ve Tahıl",{"$f":"SUM(Program!H23)/1000","v":3},"kg"]
["Tahıl Dışı Katkılar",{"$f":"Program!G51/1000","v":0.15},"kg"]
[]
["MAYŞELEME KADEMESİ","Süre","Birim","Isı Kaynağının Kaynatma oranı  litre/saat"]
["44-59 derecede protein dinlenmesi",{"$f":"IF(('ana girdiler'!$L$3)=0,(amerikan!B10),('ana girdiler'!B10))","v":0},"dakika",{"$f":"IF(('ana girdiler'!$L$3)=0,(amerikan!B83),('ana girdiler'!B83))","v":0.3}]
["ortalama 66 derecede mayşeleme",{"$f":"IF(('ana girdiler'!$L$3)=0,(amerikan!B5),('ana girdiler'!B5))","v":60},"dakika",{"$f":"IF(('ana girdiler'!$L$3)=0,(amerikan!B84),('ana girdiler'!B84))","v":0.5},"mayşeleme süresini ve kazanınızın saatte ne kadar su buharlaştırdığı bilgisini girin"]
["Kaynatma Süresi",{"$f":"IF(('ana girdiler'!$L$3)=0,(amerikan!B6),('ana girdiler'!B6))","v":60},"dakika",{"$f":"IF(('ana girdiler'!$L$3)=0,(amerikan!B85),('ana girdiler'!B85))","v":3},"mayşeleme süresini ve kazanınızın saatte ne kadar su buharlaştırdığı bilgisini girin"]
[]
[]
["TAHMİNİ KAYIPLAR ve ARTIŞLAR","Süre","Birim"]
["Tahmini Malt Tahıl Kaybı",{"$f":"B6","v":3},"litre","ortalama malt ağırlığı kadardır"]
["Tahmini tahıl dışı katkı artışı",{"$f":"B7","v":0.15},"litre","Mesela kaynatmada eklediğiniz candi şekerinin hacmi,bu artış yağmurlama suyunu etkiler"]
["Tahmini Mayşeleme Kaybı",{"$f":"(B11*D11)/60","v":0.5},"litre","Tahmini mayşeleme sırasındaki kayıptır"]
["Tahmini Ölü yer kaybı",{"$f":"IF(('ana girdiler'!$L$3)=0,(amerikan!B86),('ana girdiler'!B86))","v":0},"litre","bu alan ekipmanın dibinde kalan sıvıdır bunu elle girmeniz gerekir,mayşelemeden sonra sıvının hepsini kullanıyorsanız 0 kalabilir."]
["Tahmini Kaynatma  kaybı",{"$f":"(D12*B12)/60","v":3},"litre","kaynatma nedeniyle buharlaşan sudur "]
["Tahmini çökelme   kaybı",{"$f":"IF(('ana girdiler'!$L$3)=0,(amerikan!B87),('ana girdiler'!B87))","v":0},"litre","özellikle mash-tun tekniğinde dipte çökelen maddelerdir bunu varsa elle girmeniz gerekir,BIAB yönteminde 0 olabilir."]
["Tahmini Soğumada küçülme kaybı",{"$f":"0.04*B5","v":0.48},"litre","soğumada suyun küçülme oranıdır"]
[]
[]
["SONUÇ","Hacim","Birim"]
["Protein Dinlenmesi",{"$f":"B5+B16","v":15},"litre","protein dinlenmesi hacmidir"]
["Mayşeleme",{"$f":"B5+B16-((D10*B10)/60)","v":15},"litre","ilk başlangıçtaki mayşeleme suyu hacmidir "]
["Mayşelemeden sonraki hacim(mash-out)",{"$f":"B27-B18-B16","v":11.5},"litre","Yağmurlamadan önceki hacimdir"]
["Yağmurlama (Sparge)",{"$f":"B30-B28-B17","v":3.8300000000000005},"litre","Yağmurlama hacmidir"]
["Tahmini kaynatma hacmi",{"$f":"B5+B19+B20+B21+B22","v":15.48},"litre","Tahmini kaynatma hacmidir"]
["Toplam kullanılacak su miktarı",{"$f":"B29+B26","v":18.830000000000002},"litre","Toplam Kullanılan Su hacmidir"]
["Minimum kaynatma kazanı hacmi",{"$f":"IF((B6+B26)>(B7+B30),(B6+B26),(B7+B30))","v":18},"litre","Kaynatma kazanı hacmi kullanılacak malt miktarı ve başlangıçtaki mayşeleme suyu hacmi ile bulunur."]
[]
[]
["Daha detaylı kaynatma suyu hesabı için"]
["www.birazbira.com/tam-tahil-biraciligi-icin-kaynatma-suyu-hesabi/"]
["sayfasını ziyaret edebilirsiniz"]

{"sheet":"maya tablosu","index":4,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["Maya ","Maya Tipi","Üretici","Attenuation %"]
["Danstar American West Coast Yeast ","ale","Danstar",72,null,null,null,"Maya tablosu değerlerini Türkiye'deki tedarikçilerden veya "]
["Danstar Belle Saison Yeast ","ale","Danstar",80,null,null,null,"http://www.brewunited.com/yeast_database.php"]
["Danstar Diamond Lager ","lager","Danstar",77,null,null,null,"sitesinden alabilirsiniz."]
["Danstar Munich Dry Wheat Yeast ","ale","Danstar",75]
["Danstar Nottingham ","ale","Danstar",80]
["Danstar BRY-97 Ale Bira Mayası","ale","Danstar",75]
["Danstar Windsor ","ale","Danstar",70]
["Fermentis Safale K-97 ","ale","Fermentis",81]
["Fermentis Safale S-04 ","ale","Fermentis",75]
["Fermentis Safale US-05 ","ale","Fermentis",81]
["Fermentis Safbrew Abbaye  BE-256","ale","Fermentis",82]
["Fermentis Safbrew F-2 ","ale","Fermentis",80]
["Fermentis Safbrew S-33 ","ale","Fermentis",70]
["Fermentis Safbrew T-58 ","ale","Fermentis",70]
["Fermentis Safbrew WB-06 ","ale","Fermentis",86]
["Fermentis Saflager S-189 ","lager","Fermentis",84]
["Fermentis Saflager S-23 ","lager","Fermentis",82]
["Fermentis Saflager W-34/70","lager","Fermentis",83]
["Fermentis Belgian Saison BE-134","ale","Fermentis",90]
["Mangrove Jack Bavarian Wheat Yeast M20","ale","Mangrove Jack",73]
["Mangrove Jack Bavarian Lager Yeast M76","lager","Mangrove Jack",77]
["Mangrove Jack Empire Ale M15","ale","Mangrove Jack",75]
["Mangrove Jack Empire Liberty Bell Ale M36","ale","Mangrove Jack",76]
["Mangrove Jack Belgian Ale Yeast M41","ale","Mangrove Jack",78]
["Mangrove Jack Belgian Abbey Ale Yeast M47","ale","Mangrove Jack",78]
["Mangrove Jack Belgian Trippel Ale Yeast M31","ale","Mangrove Jack",82]
["Mangrove Jack Belgian Witbier Yeast M21","ale","Mangrove Jack",72]
["Mangrove Jack French Saison Ale Yeast M29","ale","Mangrove Jack",85]
["Mangrove Jack Bohemian Lager Yeast  M84","lager","Mangrove Jack",78]
["Mangrove Jack Californian Lager Yeast M54","lager","Mangrove Jack",78]
["Mangrove Jack British Ale Yeast","ale","Mangrove Jack",78]
["Mangrove Jack Burton Union Yeast ","ale","Mangrove Jack",78]
["Mangrove Jack Newcastle Dark Ale Yeast ","ale","Mangrove Jack",73]
["Mangrove Jack UK Dark Ale Yeast ","ale","Mangrove Jack",73]
["Mangrove Jack UK New World Strong Ale Yeast M42","ale","Mangrove Jack",78]
["Mangrove Jack US West Coast Yeast Ale M44","ale","Mangrove Jack",78]
["Mangrove Jack Workhorse Beer Yeast M10","ale","Mangrove Jack",78]

{"sheet":"tahıl tablosu","index":5,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["İsim","Tip","Renk (SRM)","Lintern","Tahmini Yoğunluk","partide max %"]
["Amber Malt (muntons)","Malt",22,20,1035,20,null,null,"Malt tablosu değerlerini Türkiye'deki tedarikçilerden veya "]
["Arpa Ezmesi","Tahıl",1.7,0,1032,20,null,null,"http://www.brewunited.com/grain_database.php"]
["Arpa ham","Tahıl",2,0,1028,15,null,null,"sitesinden alabilirsiniz."]
["Arpa Kabuğu","Tahıl",0,0,1000,5]
["Arpa,kavrulmuş","Tahıl",300,0,1025,10]
["Buğday Ezmesi","Tahıl",1.6,0,1035,40]
["Buğday maltı ,açık (weyermann)","Malt",2.2999999999999998,130,1040,60]
["Buğday, kavrulmuş","Tahıl",425,0,1025,10]
["Cara aroma (weyermann)","Malt",195,0,1035,15]
["Cara Münich II (weyermann)","Malt",60,0,1036,10]
["Caraamber (weyermann)","Malt",35,0,1035,20]
["CaraBohemian (weyermann)","Malt",85,0,1034,10]
["Carafa I (weyermann)","Malt",475,0,1036,5]
["Carahell (weyermann)","Malt",12,0,1035,15]
["Caramalt (muntons)","Malt",16,0,1035,20]
["Carapils (weyermann)","Malt",2.5,0,1034,10]
["Carared (weyermann)","Malt",22,0,1035,25]
["Çavdar Ezmesi","Tahıl",2,0,1036,10]
["Çavdar maltı","Malt",4.7,75,1029,15]
["Kayın isli maltı (weyermann)","Malt",2.5,0,1037,100]
["Maris Otter (Muntons)","Malt",2.2999999999999998,62,1036,100]
["Melanoidin Malt (Weyermann)","Malt",32,0,1037,20]
["Mısır Ezmesi ","Tahıl",1.3,0,1037,40]
["Munich  I (Weyermann)","Malt",7.1,50,1038,100]
["Munich II (weyermann)","Malt",11,0,1036,10]
["Pale Ale Malt (weyermann)","Malt",3.5,85,1036,100]
["Pilsner Malt (Weyermann)","Malt",2,110,1038,100]
["Pirinç Ezmesi","Tahıl",1,0,1032,25]
["Pirinç Kabuğu","tahıl",0,0,1000,5]
["Propino Pale Ale (muntons)","Malt",3.5,85,1036,100]
["Vienna Malt (Weyermann)","Malt",3,50,1038,100]
["Yulaf Ezmesi","Tahıl",1,0,1037,30]
["Yulaf maltı","Tahıl",1,0,1037,10]

{"sheet":"serbetçi otu tablosu","index":6,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["İsim","Ülke","Alfa Asit (%)","Kullanım "]
["Amarillo","Amerika",8.4,"Aroma",null,null,null,"ŞOT tablosu değerlerini Türkiye'deki tedarikçilerden veya "]
["Cascade","Amerika",6.9,"Acılık ve Aroma",null,null,null,"http://www.brewunited.com/hop_database.php"]
["Centennial","Amerika",10,"Acılık",null,null,null,"sitesinden alabilirsiniz."]
["Chinook","Amerika",12,"Acılık"]
["Citra","Amerika",12.4,"Aroma"]
["Columbus","Amerika",12.4,"Acılık"]
["El dorado","Amerika",12.4,"Acılık ve Aroma"]
["Equinox","Belçika",16.399999999999999,"Acılık ve Aroma"]
["Fuggle","İngiltere",4.5,"Aroma"]
["Golding","İngiltere",6.2,"Aroma"]
["Hersbrucker","Almanya",3.1,"Aroma"]
["Hüll Melon","Almanya",7.2,"Aroma"]
["Lemondrop","Amerika",5.3,"Aroma"]
["Lubelski","Polonya",3.8,"Aroma"]
["Magnum","Almanya",14.3,"Acılık"]
["Mandarina","Almanya",9.3000000000000007,"Aroma"]
["Mittelfrueh","Almanya",4.5,"Aroma"]
["Mosaic","Belçika",11.1,"Acılık ve Aroma"]
["Nugget","Amerika",12.3,"Acılık"]
["Perle","Almanya",7.3,"Acılık"]
["Saaz","Çekya",3.5,"Aroma"]
["Simcoe","Amerika",13.1,"Acılık ve Aroma"]
["Spalter","Almanya",5.5,"Aroma"]
["Summit","Belçika",18,"Acılık"]
["Target","İngiltere",10.7,"Acılık"]
["Tettnang","Almanya",4.2,"Aroma"]
["Willamette","Amerika",5.5,"Aroma"]
["Zeus","Amerika",14,"Acılık"]

{"sheet":"malt donusum","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"sot donusum","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"şeker ve katkılar","index":9,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["İsim","Tip","Renk (SRM)","Tahmini Yoğunluk","partide max %"]
["Akçağaç Şurubu","Katkı",35,1030,10,null,null,null,"Malt dışı katkı tablosu değerlerini Türkiye'deki tedarikçilerden veya "]
["Bal","Katkı",1,1035,100,null,null,null,"http://beersmith.com/grain-list/"]
["Candi Şekeri, açık","Şeker",5,1036,20,null,null,null,"sitesinden alabilirsiniz."]
["Candi Şekeri, Dark","Şeker",177,1036,20]
["DME,  ekstra Koyu","DME",50,1044,100]
["DME, ekstra açıık renk","DME",3,1044,100]
["DME, Koyu","DME",30,1044,100]
["DME, Orta","DME",13,1044,100]
["DME,açık renk","DME",8,1044,100]
["DME,Buğday","DME",6,1044,100]
["Esmer Şeker, Koyu","Şeker",50,1046,10]
["Esmer Şeker, Light","Şeker",8,1046,10]
["Evritik Şeker","Şeker",0,1046,10]
["Hububat,kırma","Katkı",1,1037,10]
["Kişniş Tohumu ","Katkı",0,1000,5]
["LME, açık","LME",6,1036,100]
["LME, Amber","LME",10,1036,100]
["LME, Dark","LME",25,1036,100]
["LME,Buğday","LME",8,1036,100]
["LME,ekstra açık","LME",3,1036,100]
["LME,marris otter","LME",6,1036,100]
["Mısır Şekeri (Dekstroz)","Şeker",0,1046,5]
["Mısır Şurubu","Şeker",1,1036,10]
["Pancar Şekeri","Şeker",0,1046,7]
["Pekmez","Şeker",80,1036,5]
["Pirinç özü şurubu","Katkı",7,1032,15]
["Portakal Kabuğu Kurusu","Katkı",0,1005,5]
["Sofra Şekeri (sukroz)","Şeker",1,1046,10]
["Süt Şekeri (Lactose)","Şeker",0,1035,10]

{"sheet":"utilisation chart","index":10,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":true,"merged":[[0,0,0,11],[1,1,1,11]]}
["%U DEĞERİ"]
["Kaynatma","OG"]
["Süre (dak.)",1030,1040,1050,1060,1070,1080,1090,1100,1110,1120,1130]
[0,0,0,0,0,0,0,0,0,0,0,0]
[3,3.4000000000000002E-2,3.1E-2,2.9000000000000001E-2,2.5999999999999999E-2,2.4E-2,2.1999999999999999E-2,0.02,1.7999999999999999E-2,1.7000000000000001E-2,1.4999999999999999E-2,1.4E-2]
[6,6.5000000000000002E-2,5.8999999999999997E-2,5.3999999999999999E-2,4.9000000000000002E-2,4.4999999999999998E-2,4.1000000000000002E-2,3.7999999999999999E-2,3.5000000000000003E-2,3.2000000000000001E-2,2.9000000000000001E-2,2.5999999999999999E-2]
[9,9.1999999999999998E-2,8.4000000000000005E-2,7.6999999999999999E-2,7.0000000000000007E-2,6.4000000000000001E-2,5.8999999999999997E-2,5.3999999999999999E-2,4.9000000000000002E-2,4.4999999999999998E-2,4.1000000000000002E-2,3.6999999999999998E-2]
[12,0.11600000000000001,0.106,9.7000000000000003E-2,8.7999999999999995E-2,8.1000000000000003E-2,7.3999999999999996E-2,6.8000000000000005E-2,6.2E-2,5.6000000000000001E-2,5.1999999999999998E-2,4.7E-2]
[15,0.13700000000000001,0.125,0.114,0.105,9.6000000000000002E-2,8.6999999999999994E-2,0.08,7.2999999999999995E-2,6.7000000000000004E-2,6.0999999999999999E-2,5.6000000000000001E-2]
[18,0.156,0.14199999999999999,0.13,0.11899999999999999,0.109,9.9000000000000005E-2,9.0999999999999998E-2,8.3000000000000004E-2,7.5999999999999998E-2,6.9000000000000006E-2,6.3E-2]
[21,0.17299999999999999,0.158,0.14399999999999999,0.13200000000000001,0.12,0.11,0.10100000000000001,9.1999999999999998E-2,8.4000000000000005E-2,7.6999999999999999E-2,7.0000000000000007E-2]
[24,0.187,0.17100000000000001,0.157,0.14299999999999999,0.13100000000000001,0.12,0.109,0.1,9.0999999999999998E-2,8.3000000000000004E-2,7.5999999999999998E-2]
[27,0.20100000000000001,0.183,0.16800000000000001,0.153,0.14000000000000001,0.128,0.11700000000000001,0.107,9.8000000000000004E-2,8.8999999999999996E-2,8.2000000000000003E-2]
[30,0.21199999999999999,0.19400000000000001,0.17699999999999999,0.16200000000000001,0.14799999999999999,0.13500000000000001,0.124,0.113,0.10299999999999999,9.4E-2,8.5999999999999993E-2]
[33,0.223,0.20300000000000001,0.186,0.17,0.155,0.14199999999999999,0.13,0.11899999999999999,0.108,9.9000000000000005E-2,9.0999999999999998E-2]
[36,0.23200000000000001,0.21199999999999999,0.19400000000000001,0.17699999999999999,0.16200000000000001,0.14799999999999999,0.13500000000000001,0.124,0.113,0.10299999999999999,9.4E-2]
[39,0.24,0.219,0.2,0.183,0.16700000000000001,0.153,0.14000000000000001,0.128,0.11700000000000001,0.107,9.8000000000000004E-2]
[42,0.247,0.22600000000000001,0.20599999999999999,0.189,0.17199999999999999,0.158,0.14399999999999999,0.13200000000000001,0.12,0.11,0.10100000000000001]
[45,0.253,0.23200000000000001,0.21199999999999999,0.19400000000000001,0.17699999999999999,0.16200000000000001,0.14799999999999999,0.13500000000000001,0.123,0.113,0.10299999999999999]
[48,0.25900000000000001,0.23699999999999999,0.216,0.19800000000000001,0.18099999999999999,0.16500000000000001,0.151,0.13800000000000001,0.126,0.115,0.105]
[51,0.26400000000000001,0.24099999999999999,0.221,0.20200000000000001,0.184,0.16900000000000001,0.154,0.14099999999999999,0.129,0.11799999999999999,0.108]
[54,0.26900000000000002,0.246,0.224,0.20499999999999999,0.188,0.17100000000000001,0.157,0.14299999999999999,0.13100000000000001,0.12,0.109]
[57,0.27300000000000002,0.249,0.22800000000000001,0.20799999999999999,0.19,0.17399999999999999,0.159,0.14499999999999999,0.13300000000000001,0.121,0.111]
[60,0.27600000000000002,0.252,0.23100000000000001,0.21099999999999999,0.193,0.17599999999999999,0.161,0.14699999999999999,0.13500000000000001,0.123,0.112]
[70,0.28499999999999998,0.26100000000000001,0.23799999999999999,0.218,0.19900000000000001,0.182,0.16600000000000001,0.152,0.13900000000000001,0.127,0.11600000000000001]
[80,0.29099999999999998,0.26600000000000001,0.24299999999999999,0.222,0.20300000000000001,0.186,0.17,0.155,0.14199999999999999,0.13,0.11899999999999999]
[90,0.29499999999999998,0.27,0.247,0.22600000000000001,0.20599999999999999,0.188,0.17199999999999999,0.157,0.14399999999999999,0.13200000000000001,0.12]
[120,0.30099999999999999,0.27500000000000002,0.252,0.23,0.21,0.192,0.17599999999999999,0.161,0.14699999999999999,0.13400000000000001,0.123]
[]
[]
[]
[]
["Renk","EBC","R","G ","B"]
[null,4,249,247,83]
[null,6,246,245,19]
[null,8,236,230,26]
[null,12,213,188,38]
[null,16,191,146,59]
[null,20,191,129,59]
[null,26,187,103,49]
[null,33,141,76,50]
[null,39,92,52,26]
[null,47,83,1,3]
[null,57,64,0,0]
[null,69,46,0,0]
[null,79,3,4,3]