{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Açıklama","Maliyet Hesabı","Sabit Maliyet","Maliyet Kırılım","Hacim-Birim Maliyet","Day.Sınıfına Göre Maliyet","Karlılık Analizi","Sevkiyat","Sheet2","Sheet3"],"not_rendered":{"charts":8,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":"Açıklama","index":0,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,3,24,12],[25,3,25,12],[19,3,19,12],[20,3,20,12],[21,3,21,12],[22,3,22,12],[23,3,23,12],[18,3,18,12],[14,2,14,5],[6,2,8,12],[10,2,10,12],[12,2,12,12],[14,11,14,12],[17,2,17,12],[15,3,15,11]]}
[]
[]
[]
[]
[]
[]
[null,null,"HAZIRLAYAN: YASİN ENGİN (İnş.Yük.Müh)               "]
[]
[]
[]
[null,null,"www.betonvecimento.com "]
[]
[null,null,"yasin.engin@gmail.com"]
[]
[null,null,"Güncelleme Kontrol Et",null,null,null,null,null,null,null,"Versiyon 5","Ocak,2016"]
[null,null,null,"TIKLA TAKİP ET!"]
[]
[null,null,"AÇIKLAMALAR"]
[null,null,1,"Makronuzu etkinleştiriniz."]
[null,null,2,"Maliyet Hesabı sayfasındaki sarı hücrelere veri girişi yapınız. "]
[null,null,3,"Maliyet Hesabı sayfasında yer alan \"sabit maliyet\" kısmı için hesapla düğmesine tıklayınız."]
[null,null,4,"Sabit Maliyet sayfasında iki yöntem mevcuttur. Sarı hücrelere veri girip hesaplama yapabilirsiniz ya da turuncu hücrelere manuel giriş yapabilirsiniz. Bu durumda otomatik formülasyon iptal olur."]
[null,null,5,"Sabit Maliyet sayfasında normal amortisman hesabı yapabilirsiniz. Bu hesaplama linear olarak hesaplanır. Aylık beton üretim miktarını girdiğinizde Maliyet Hesabı sayfasında birim sabit maliyet otomatik olarak hesaplanır."]
[null,null,6,"Hacim-Birim Maliyet sayfasındaki hesaplamalar daha önce girilen verileri referans alır. Sadece sarı renkli hücrelere veri girişi yapılmalıdır."]
[null,null,7,"Day.Sınıfında Göre Maliyet Hesabı daha önceki verilerden bağımsızdır. Buradaki analiz farklı beton reçetelerindeki dayanım-maliyet ilişkisi üzerinedir. Bu sayfadaki ortalama dayanım satırındaki hücreler boş bırakılırsa karakteristik küp  basınç dayanımı kullanılır."]
[null,null,8,"Karlılık Analizi sayfasında Day.Sınıfında Göre Maliyet Hesabı sayfasındaki veriler kullanılmaktadır. Sadece sarı renkli hücrelere satış fiyatı bilgisi girilmelidir."]

{"sheet":"Maliyet Hesabı","index":1,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,6],[19,5,20,5],[19,4,20,4],[15,1,15,2],[14,3,14,5]]}
[]
[null,"SARI RENKLİ HÜCRELERE VERİ GİRİNİZ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C16/20"]
[null,"C55/67","Miktar (kg/m3)","Birim fiyat (TL/ton)","Nakliye mesafesi(km)","Nakliye Masrafı(TL./ton.km)","Maliyet (TL)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C20/25"]
[null,"1 NO",510,12,20,0.1,{"$f":"C4*(D4+2*E4*F4)/1000","v":8.16},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C25/30"]
[null,"2 NO",500,12,25,0.1,{"$f":"C5*(D5+2*E5*F5)/1000","v":8.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C30/37"]
[null,"TAŞ TOZU ",500,12,25,0.1,8.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C35/45"]
[null,"KUM",380,20,30,0.1,9.8800000000000008,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C40/50"]
[null,"GERİ DÖN. AGREGA",0,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C45/55"]
[null,"SU",100,3,null,null,0.3,null,null,null,null,null," ",null,null,null,null,null,null,null,null,"C50/60"]
[null,"GERİ DÖN. SU",60,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C55/67"]
[null,"ÇİMENTO",250,175,null,null,43.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C60/75"]
[null,"CÜRUF/U.KÜL",50,130,null,null,6.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C70/85"]
[null,"ELYAF/ÇELİK LİF",0,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C80/95"]
[null,"KATKI",4.5,1200,null,null,5.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C90/105"]
[null,"TOPLAM",{"$f":"SUM(C4:C14)","v":2354.5},"HAMMADDE MALİYETİ",null,null,{"$f":"SUM(G4:G14)","v":90.990000000000009},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C100/115"]
[null,"OPERASYONEL GİDERLER",null,null,"SABİT MALİYET",{"$f":"'Sabit Maliyet'!J9","v":17.544000280848522},{"$f":"C26","v":2}]
[null,"YÜKLÜ Mikser yakıt sarfiyatı (litre/km)",0.85,null,"OPER. GİDERLER",{"$f":"SUM(C26,C25,C24,C23)","v":13.83},{"$f":"F16","v":17.544000280848522}]
[null,"BOŞ Mikser yakıt sarfiyatı (litre/km)",0.55000000000000004,null,null,null,{"$f":"C23","v":1}]
[null,"Pompalama yakıt sarfiyatı(litre/m3)",0.85,null,null,null,{"$f":"C24","v":7.6}]
[null,"Mazot fiyat(TL/L)",3.8,null,"TOPLAM MALİYET (TL/m3)",{"$f":"G15+C23+C24+C25+F16+C26","v":122.36400028084853},{"$f":"C25","v":3.23}]
[null,"Mikser yükü(m3)",7,null,null,null,"(KDV hariç)",null,"  "]
[null,"Şantiye uzaklık (km)",10,null,null,null,{"$f":"C25","v":3.23}]
[null,"Elektrik (TL/m3)",1,null,"SATIŞ FİYATI",130,"(KDV hariç)"]
[null,"Nakliye (TL/m3)",{"$f":"C22*C17*C20/C21+C22*C18*C20/C21","v":7.6}]
[null,"Pompalama (TL/m3)",{"$f":"C20*C19","v":3.23},null,"NET KAR",{"$f":"(F23-F20)","v":7.6359997191514708},{"$f":"F25/F20","v":6.2403972586916143E-2}]
[null,"Diğer Operasyonel Giderler(TL/m3)",2]
[null,"DİĞER OPERASYONEL  ",null,null,null,null,null,null,null,null,null,null,"Min",100]
[null,"SABİT GİDER",null,null,null,null,null,null,null,null,null,null,"Max",125]
[null,"ELEKTRİK"]
[null,"NAKLİYE",null,null,null,null,null,null,null,null,null,"Value","Degs",null,"x","y"]
[null,"POMPALAMA",null,null,null,null,null,null,null,null,"Min",{"$f":"N27","v":100},0,null,{"$f":"50-(50*COS(RADIANS(M33)))","v":97.281835764179988},{"$f":"50*SIN(RADIANS(M33))","v":16.261242473104854}]
[null,"AMORTİSMAN",null,null,null,"Hammadde",{"$f":"G15","v":90.990000000000009},null,null,null,"Max",{"$f":"N28","v":125},180,null,{"$f":"50-(2*COS(RADIANS(M33+90)))","v":50.650449698924191},{"$f":"2*SIN(RADIANS(M33+90))","v":-1.8912734305672001}]
[null,null,null,null,null,"Sabit Gider",{"$f":"F16","v":17.544000280848522},null,null,null,"Actual",{"$f":"F20","v":122.36400028084853},{"$f":"((L33-L31)/(L32-L31))*180","v":161.02080202210939},null,{"$f":"50-(2*COS(RADIANS(M33-90)))","v":49.349550301075809},{"$f":"2*SIN(RADIANS(M33-90))","v":1.8912734305672001}]
[null,null,null,null,null,"Nakliye",{"$f":"C24","v":7.6},null,null,null,"Scale1",{"$f":"(($L$32-$L$31)/5)+L31","v":105},null,null,{"$f":"O31","v":97.281835764179988},{"$f":"P31","v":16.261242473104854}]
[null,null,null,null,null,"Pompalama",{"$f":"C25","v":3.23},null,null,null,"Scale2",{"$f":"(($L$32-$L$31)/5)+L34","v":110},null,null,50,0]
[null,null,null,null,null,"Elektrik",{"$f":"C23","v":1},null,null,null,"Scale3",{"$f":"(($L$32-$L$31)/5)+L35","v":115}]
[null,null,null,null,null,"Diğer",{"$f":"C26","v":2},null,null,null,"Scale4",120]
[null,null,null,null,null,null,{"$f":"SUM(G32:G37)","v":122.36400028084853}]

{"sheet":"Sabit Maliyet","index":2,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[49,9,49,10],[50,9,50,10],[51,9,51,10],[52,9,52,10],[11,9,11,10],[44,9,44,10],[45,9,45,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[13,5,13,11],[19,0,19,1],[47,0,52,1],[53,0,53,1],[41,4,41,6],[42,4,42,6],[43,4,43,6],[40,4,40,6],[1,9,2,11],[3,9,4,11],[6,9,7,11],[8,9,9,11],[10,0,10,1],[1,5,2,7],[3,5,4,7],[6,5,7,7],[8,5,9,7]]}
[null,"AYLIK SABİT GİDER","Manuel Giriş"]
["MALZEME",{"$f":"IF(C2=\"\",SUM(B3:B10),C2)","v":2400},null,null,null,"Toplam Aylık Sabit Maliyet",null,null,null,"Aylık Ortalama Üretim (m3)"]
["Yedek Parça",500]
["Temizlik Malzemeleri",200,null,null,null,{"$f":"B2+B12+B21+B46","v":219300.0035106065},null,null,null,12500]
["Elektrik Malzemeleri",300]
["Küçül El Aletleri",100]
["Atölye ve Laboratuvar Malzemeleri",100,null,null,null,"Toplam Günlük Sabit Maliyet",null,null,null,"Sabit Gider (TL/m3)"]
["Kişisel Koruyucu Ekipman - İş Elbisesi",100]
["İnşaat Bakım Malzemeleri",100,null,null,null,{"$f":"F4/30","v":7310.0001170202167},null,null,null,{"$f":"IF(M10=\"\",F4/J4,M10)","v":17.544000280848522},null,null,"Manuel Giriş"]
["Diğer Malzemeler",1000]
[null,null,"Manuel Giriş"]
["ÜRETİM İŞÇİLİK GİDERLERİ",{"$f":"IF(C12=\"\",SUM(B13:B19),C12)","v":144000},null,null,null,null,null,null,null,"Amortisman (TL/m3)",null,{"$f":"B46/J4","v":4}]
["Brüt Ücret",120000]
["Mesai",5000,null,null,null,"SARI RENKLİ HÜCRELERE VERİ GİRİNİZ."]
["Prim",5000]
["Yemek",5000]
["Ulaşım",2000]
["Personel Sigorta (sağlık-kaza vb.)",5000]
["Diğer",2000]
[null,null,"Manuel Giriş"]
["DİĞER GİDERLER",{"$f":"IF(C21=\"\",SUM(B22:B44),C21)","v":22900.003510606512}]
["Jeneratör (Motorin)",1000]
["Su",500]
["Doğal Gaz (Isınma)",1000]
["Elektrik ( Üretim dışı )",1000]
["Gayrimenkul Kiraları",0]
["Makine Kiraları",0]
["Bakım/Onarım/Temizlik",0]
["Oto Kiralama",4000]
["Bilgi İşlem",200]
["Müşavirlik-Danışmanlık",1000]
["Personel Sigorta (sağlık-kaza vb.)",3.5106065132954885E-3]
["Diğer Sigorta Giderleri",5000]
["Telefon-İnternet-Kargo",1000]
["Kırtasiye",200]
["Reklam/İlan",500]
["Levha/Pano",1000]
["Temsil",1000]
["Tazminat ve Cezalar",1000]
["Mutfak",500]
["Çevre/Temizlik Vergisi",500,null,null,"Duran Varlık Toplamı (TL)",null,null,3700000,null,"VARLIKLAR",null,"MALİYET"]
["İhale ve Mukavele",500,null,null,"Hurda değeri (TL)",null,null,700000,null,"SANTRAL",null,1000000]
["Harçlar ve Aidatlar",2000,null,null,"Hizmet Ömrü",null,null,5,null,"TRANMİKSERLER",null,1200000]
["Diğer",1000,null,null,"Yıllık Amortisman",null,null,{"$f":"(H41-H42)/H43","v":600000},null,"POMPALAR",null,900000]
[null,null,"Manuel Giriş",null,null,null,null,null,null,"KAMYONLAR",null,600000]
["AMORTİSMAN",{"$f":"IF(C46=\"\",H44/12,C46)","v":50000},null,null,null,null,null,null,null,"KEPÇE",null,120000]
[null,null,null,null,null,null,null,null,null,"SİLOBAS",null,200000]
["Amortisman Ayırma Şartları:\n\n- İşletmede bir yıldan fazla kullanılabilir olması\n- Yıpranmaya, aşınmaya veya kıymetten düşmeye maruz bulunması\n- Değerleme gününde envantere dahil ve kullanıma hazır olması\n- İktisadi kıymetin değerinin 880 TL’yi (2015 yılı için) aşması",null,null,null,null,null,null,null,null,"LABORATUVAR",null,50000]
[null,null,null,null,null,null,null,null,null,"OFİS DEMİRBAŞ",null,50000]
[null,null,null,null,null,null,null,null,null,"PREFABRİK YAPILAR",null,30000]
[null,null,null,null,null,null,null,null,null,"BİNEK ARAÇLAR",null,100000]
[null,null,null,null,null,null,null,null,null,"DİĞER",null,150000]
[null,null,null,null,null,null,null,null,null,"TOPLAM",null,{"$f":"SUM(L42:L52)","v":4400000}]
["2015 yılı amortisman oranları"]

{"sheet":"Maliyet Kırılım","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[]
[null,"Aylık Ortalama Üretim (m3)",{"$f":"'Sabit Maliyet'!J4","v":12500}]
[null,"Hammadde",{"$f":"'Maliyet Hesabı'!G15","v":90.990000000000009},{"$f":"C3/$C$8","v":0.74360105742833471}]
[null,"Operasyonel(yakıt-enerji)",{"$f":"'Maliyet Hesabı'!F17","v":13.83},{"$f":"C4/$C$8","v":0.11302343800674654}]
[null,"İşçilik",{"$f":"'Sabit Maliyet'!B12/'Sabit Maliyet'!J4","v":11.52},9.414533664770211E-2]
[null,"Malzeme, Bakım ve Diğer",{"$f":"('Sabit Maliyet'!B2+'Sabit Maliyet'!B21)/'Sabit Maliyet'!J4","v":2.0240002808485209},1.6540814914542328E-2]
[null,"Amortisman",{"$f":"'Sabit Maliyet'!L12","v":4},3.2689353002674344E-2]
[null,"Toplam",{"$f":"SUM(C3:C7)","v":122.36400028084853},1]

{"sheet":"Hacim-Birim Maliyet","index":4,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[13,1,13,2],[16,0,16,10]]}
[]
["AYLIK ORTALAMA ÜRETİM",3000,5000,7500,10000,12000,15000,17500,20000,25000,30000]
["AYLIK DEĞİŞKEN MALİYET",{"$f":"('Maliyet Hesabı'!$F$17+'Maliyet Hesabı'!$G$15)*B2","v":314460},{"$f":"('Maliyet Hesabı'!$F$17+'Maliyet Hesabı'!$G$15)*C2","v":524100.00000000006},{"$f":"('Maliyet Hesabı'!$F$17+'Maliyet Hesabı'!$G$15)*D2","v":786150},{"$f":"('Maliyet Hesabı'!$F$17+'Maliyet Hesabı'!$G$15)*E2","v":1048200.0000000001},{"$f":"('Maliyet Hesabı'!$F$17+'Maliyet Hesabı'!$G$15)*F2","v":1257840},{"$f":"('Maliyet Hesabı'!$F$17+'Maliyet Hesabı'!$G$15)*G2","v":1572300},{"$f":"('Maliyet Hesabı'!$F$17+'Maliyet Hesabı'!$G$15)*H2","v":1834350.0000000002},{"$f":"('Maliyet Hesabı'!$F$17+'Maliyet Hesabı'!$G$15)*I2","v":2096400.0000000002},{"$f":"('Maliyet Hesabı'!$F$17+'Maliyet Hesabı'!$G$15)*J2","v":2620500},{"$f":"('Maliyet Hesabı'!$F$17+'Maliyet Hesabı'!$G$15)*K2","v":3144600}]
["AYLIK SABİT MALİYET",{"$f":"'Sabit Maliyet'!$F$4","v":219300.0035106065},{"$f":"'Sabit Maliyet'!$F$4","v":219300.0035106065},{"$f":"'Sabit Maliyet'!$F$4","v":219300.0035106065},{"$f":"'Sabit Maliyet'!$F$4","v":219300.0035106065},{"$f":"'Sabit Maliyet'!$F$4","v":219300.0035106065},{"$f":"'Sabit Maliyet'!$F$4","v":219300.0035106065},{"$f":"'Sabit Maliyet'!$F$4","v":219300.0035106065},{"$f":"'Sabit Maliyet'!$F$4","v":219300.0035106065},{"$f":"'Sabit Maliyet'!$F$4","v":219300.0035106065},{"$f":"'Sabit Maliyet'!$F$4","v":219300.0035106065}]
["TOPLAM",{"$f":"SUM(B3:B4)","v":533760.00351060648},{"$f":"SUM(C3:C4)","v":743400.00351060659},1005450.0035106065,1267500.0035106067,1477140.0035106065,1791600.0035106065,2053650.0035106067,2315700.0035106069,2839800.0035106065,3363900.0035106065]
[]
["BİRİM MALİYET (TL/m3)",{"$f":"B5/B2","v":177.92000117020217},{"$f":"C5/C2","v":148.6800007021213},134.06000046808086,126.75000035106068,123.09500029255054,119.44000023404043,117.35142877203467,115.78500017553034,113.59200014042426,112.13000011702022]
["DEĞİŞKEN MALİYET ORANI (%)",{"$f":"B3/B5","v":0.58914118317550423},{"$f":"C3/C5","v":0.70500403218322338},0.78188870381928133,0.82698224623020966,0.85153742841611979,0.87759544369229059,0.89321451896100867,0.9052986124376442,0.92277625070797087,0.93480781138507618]
[]
["SATIŞ FİYATI",120,120,120,120,120,120,120,120,120,120]
["KAR/ZARAR (TL/m3)",{"$f":"B10-B7","v":-57.92000117020217},{"$f":"C10-C7","v":-28.680000702121305},-14.060000468080858,-6.7500003510606774,-3.0950002925505373,0.55999976595957435,2.6485712279653342,4.2149998244696576,6.4079998595757388,7.8699998829797835]
["TOPLAM KAR/ZARAR (TL)",{"$f":"B11*B2","v":-173760.0035106065},{"$f":"C11*C2","v":-143400.00351060653},-105450.00351060643,-67500.003510606781,-37140.003510606446,8399.9964893936158,46349.99648939335,84299.996489393146,160199.99648939347,236099.9964893935]
[]
["BBN (BAŞA BAŞ NOKTASI) (m3)",{"$f":"'Sabit Maliyet'!F4/('Maliyet Hesabı'!F23-'Maliyet Hesabı'!G15-'Maliyet Hesabı'!F17)","v":8709.293229174209}]
[]
[]
["SARI RENKLİ HÜCRELERE VERİ GİRİNİZ."]

{"sheet":"Day.Sınıfına Göre Maliyet","index":5,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,25,6],[19,1,19,2],[17,1,17,2],[18,1,18,2],[1,3,1,10],[14,1,14,2],[16,1,16,2],[21,1,21,2],[22,1,22,2]]}
[]
[null,null,null,"Reçete (kg/m3)"]
[null,"Hammadde","Birim fiyat (TL/ton)","C16/20","C20/25","C25/30","C30/37","C35/45","C40/50","C45/55","C50/60"]
[null,"1 NO",15,510,510,510,510,510,510,510,510,null,{"$f":"$C$4*D4/1000","v":7.65},{"$f":"$C$4*E4/1000","v":7.65},7.65,7.65,7.65,7.65,7.65,{"$f":"$C$4*K4/1000","v":7.65}]
[null,"2 NO",15,500,500,500,500,500,500,500,500,null,{"$f":"$C$5*D5/1000","v":7.5},{"$f":"$C$5*E5/1000","v":7.5},7.5,7.5,7.5,7.5,7.5,{"$f":"$C$5*K5/1000","v":7.5}]
[null,"TAŞ TOZU ",15,500,500,500,480,450,450,420,420,null,{"$f":"$C$6*D6/1000","v":7.5},{"$f":"$C$6*E6/1000","v":7.5},7.5,7.2,6.75,6.75,6.3,{"$f":"$C$6*K6/1000","v":6.3}]
[null,"KUM",20,400,400,400,400,400,380,380,360,null,{"$f":"$C$7*D7/1000","v":8},{"$f":"$C$7*E7/1000","v":8},8,8,8,7.6,7.6,{"$f":"$C$7*K7/1000","v":7.2}]
[null,"GERİ DÖN. AGREGA",0,0,0,0,0,0,0,0,0,null,{"$f":"$C$8*D8/1000","v":0},{"$f":"$C$8*E8/1000","v":0},0,0,0,0,0,{"$f":"$C$8*K8/1000","v":0}]
[null,"SU",3,100,100,100,100,100,100,100,100,null,{"$f":"$C$9*D9/1000","v":0.3},{"$f":"$C$9*E9/1000","v":0.3},0.3,0.3,0.3,0.3,0.3,{"$f":"$C$9*K9/1000","v":0.3}]
[null,"GERİ DÖN. SU",0,60,60,60,60,60,60,60,60,null,{"$f":"$C$10*D10/1000","v":0},{"$f":"$C$10*E10/1000","v":0},0,0,0,0,0,{"$f":"$C$10*K10/1000","v":0}]
[null,"ÇİMENTO",165,220,260,230,260,290,315,390,410,null,{"$f":"$C$11*D11/1000","v":36.299999999999997},{"$f":"$C$11*E11/1000","v":42.9},37.950000000000003,42.9,47.85,51.975000000000001,64.349999999999994,{"$f":"$C$11*K11/1000","v":67.650000000000006}]
[null,"CÜRUF/U.KÜL",130,0,0,50,50,50,50,0,0,null,{"$f":"$C$12*D12/1000","v":0},{"$f":"$C$12*E12/1000","v":0},6.5,6.5,6.5,6.5,0,{"$f":"$C$12*K12/1000","v":0}]
[null,"ELYAF/ÇELİK LİF",0,0,0,0,0,0,0,0,0,null,{"$f":"$C$13*D13/1000","v":0},{"$f":"$C$13*E13/1000","v":0},0,0,0,0,0,{"$f":"$C$13*K13/1000","v":0}]
[null,"KATKI",1200,4.5,4.5,4.5,4.5,4.5,4.5,4.5,4.5,null,{"$f":"$C$14*D14/1000","v":5.4},{"$f":"$C$14*E14/1000","v":5.4},5.4,5.4,5.4,5.4,5.4,{"$f":"$C$14*K14/1000","v":5.4}]
[null,"Birim Ağırlık(kg/m3)",null,{"$f":"SUM(D4:D14)","v":2294.5},{"$f":"SUM(E4:E14)","v":2334.5},2354.5,2364.5,2364.5,2369.5,2364.5,2364.5,null,{"$f":"SUM(M4:M14)","v":72.650000000000006},{"$f":"SUM(N4:N14)","v":79.25},80.800000000000011,85.45,89.95,93.675000000000011,99.1,102.00000000000001]
[]
[null,"Hammadde Maliyeti (TL/m3)",null,{"$f":"M15","v":72.650000000000006},{"$f":"N15","v":79.25},80.800000000000011,85.45,89.95,93.675000000000011,99.1,102.00000000000001]
[null,"Operasyonel Giderler (TL/m3)",null,{"$f":"SUM('Maliyet Hesabı'!$C$25,'Maliyet Hesabı'!$C$26,'Maliyet Hesabı'!$C$24,'Maliyet Hesabı'!$C$23)","v":13.83},{"$f":"SUM('Maliyet Hesabı'!$C$25,'Maliyet Hesabı'!$C$26,'Maliyet Hesabı'!$C$24,'Maliyet Hesabı'!$C$23)","v":13.83},{"$f":"SUM('Maliyet Hesabı'!$C$25,'Maliyet Hesabı'!$C$26,'Maliyet Hesabı'!$C$24,'Maliyet Hesabı'!$C$23)","v":13.83},{"$f":"SUM('Maliyet Hesabı'!$C$25,'Maliyet Hesabı'!$C$26,'Maliyet Hesabı'!$C$24,'Maliyet Hesabı'!$C$23)","v":13.83},{"$f":"SUM('Maliyet Hesabı'!$C$25,'Maliyet Hesabı'!$C$26,'Maliyet Hesabı'!$C$24,'Maliyet Hesabı'!$C$23)","v":13.83},{"$f":"SUM('Maliyet Hesabı'!$C$25,'Maliyet Hesabı'!$C$26,'Maliyet Hesabı'!$C$24,'Maliyet Hesabı'!$C$23)","v":13.83},{"$f":"SUM('Maliyet Hesabı'!$C$25,'Maliyet Hesabı'!$C$26,'Maliyet Hesabı'!$C$24,'Maliyet Hesabı'!$C$23)","v":13.83},{"$f":"SUM('Maliyet Hesabı'!$C$25,'Maliyet Hesabı'!$C$26,'Maliyet Hesabı'!$C$24,'Maliyet Hesabı'!$C$23)","v":13.83}]
[null,"Sabit Maliyet (TL/m3)",null,{"$f":"'Maliyet Hesabı'!$F$16","v":17.544000280848522},{"$f":"'Maliyet Hesabı'!$F$16","v":17.544000280848522},{"$f":"'Maliyet Hesabı'!$F$16","v":17.544000280848522},{"$f":"'Maliyet Hesabı'!$F$16","v":17.544000280848522},{"$f":"'Maliyet Hesabı'!$F$16","v":17.544000280848522},{"$f":"'Maliyet Hesabı'!$F$16","v":17.544000280848522},{"$f":"'Maliyet Hesabı'!$F$16","v":17.544000280848522},{"$f":"'Maliyet Hesabı'!$F$16","v":17.544000280848522}]
[null,"Toplam Maliyet (TL/m3)",null,{"$f":"SUM(D17:D19)","v":104.02400028084853},{"$f":"SUM(E17:E19)","v":110.62400028084852},112.17400028084853,116.82400028084852,121.32400028084852,125.04900028084853,130.47400028084851,133.37400028084852]
[null,null,null,24,29,34,41,49,54,59,64]
[null,"Ortalama Dayanım(MPa)"]
[null,"Birim Dayanım Maliyeti (TL/MPa)",null,{"$f":"D17/D24","v":3.0270833333333336},{"$f":"E17/E24","v":2.7327586206896552},{"$f":"F17/F24","v":2.3764705882352946},2.0841463414634145,1.8357142857142859,1.7347222222222225,1.6796610169491524,1.5937500000000002]
[null,null,null,{"$f":"IF(D22=\"\",D21,D22)","v":24},{"$f":"IF(E22=\"\",E21,E22)","v":29},34,41,49,54,59,64]
[]
[null,"SARI RENKLİ HÜCRELERE VERİ GİRİNİZ."]

{"sheet":"Karlılık Analizi","index":6,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,2],[5,1,5,2],[6,1,6,2],[22,0,22,10]]}
[]
[null,null,null,"C16/20","C20/25","C25/30","C30/37","C35/45","C40/50","C45/55","C50/60"]
[null,"Toplam Maliyet (TL/m3)",null,{"$f":"'Day.Sınıfına Göre Maliyet'!D20","v":104.02400028084853},{"$f":"'Day.Sınıfına Göre Maliyet'!E20","v":110.62400028084852},{"$f":"'Day.Sınıfına Göre Maliyet'!F20","v":112.17400028084853},{"$f":"'Day.Sınıfına Göre Maliyet'!G20","v":116.82400028084852},{"$f":"'Day.Sınıfına Göre Maliyet'!H20","v":121.32400028084852},{"$f":"'Day.Sınıfına Göre Maliyet'!I20","v":125.04900028084853},{"$f":"'Day.Sınıfına Göre Maliyet'!J20","v":130.47400028084851},{"$f":"'Day.Sınıfına Göre Maliyet'!K20","v":133.37400028084852}]
[null,"Satış Fiyatı (TL/m3)",null,108,115,117,120,125,130,134,140]
[]
[null,"Net Kar (TL)",null,{"$f":"D4-D3","v":3.9759997191514742},{"$f":"E4-E3","v":4.3759997191514799},4.8259997191514685,3.1759997191514771,3.6759997191514771,4.9509997191514685,3.5259997191514856,6.6259997191514799]
[null,"Kar %",null,{"$f":"D6/D3","v":3.8221945978013698E-2},{"$f":"E6/E3","v":3.9557417088894251E-2},4.3022444658019486E-2,2.7186192148156842E-2,3.0299031606623904E-2,3.9592477413109894E-2,2.7024539077223693E-2,4.9679845436134247E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SARI RENKLİ HÜCRELERE VERİ GİRİNİZ."]

{"sheet":"Sevkiyat","index":7,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,6,1,7],[3,0,10,0],[14,0,21,0],[16,1,16,4],[6,1,6,4],[4,3,5,4],[15,3,15,4],[1,1,1,4]]}
[]
[null,"HAMMADDE NAKLİYE",null,null,null,null,"HAZIR BETON NAKLİYE"]
[]
["ORTALAMA",null,"Miktar","Ton/sefer","Sefer",null,null,"Miktar"]
[null,"Aylık Ortalama Üretim (m3)",{"$f":"'Sabit Maliyet'!J4","v":12500},null,null,null,"Aylık Ortalama Üretim (m3)",{"$f":"'Sabit Maliyet'!J4","v":12500}]
[null,"Günlük Ortalama Üretim (m3)",{"$f":"C5/30","v":416.66666666666669},null,null,null,"Günlük Ortalama Üretim (m3)",{"$f":"H5/30","v":416.66666666666669}]
[null,"Günlük Hammadde İhtiyacı",null,null,null,null,"Trankmikser Ort. Yük (m3)",8]
[null,"Mıcır(ton)",{"$f":"C6*'Maliyet Hesabı'!$C$4/1000","v":212.5},25,{"$f":"C8/D8","v":8.5},null,"Günlük sefer sayısı",{"$f":"H6/H7","v":52.083333333333336}]
[null,"Kum(ton)",{"$f":"C6*'Maliyet Hesabı'!$C$7/1000","v":158.33333333333334},25,{"$f":"C9/D9","v":6.3333333333333339}]
[null,"Çimento(ton)",{"$f":"C6*'Maliyet Hesabı'!$C$11/1000","v":104.16666666666667},30,3.4722222222222223]
[null,"Toplam(ton)",{"$f":"SUM(C8:C10)","v":475.00000000000006},null,{"$f":"SUM(E8:E10)","v":18.305555555555557}]
[]
[]
[]
["MAKSİMUM",null,"Miktar","Ton/sefer","Sefer",null,null,"Miktar"]
[null,"Günlük Max.Üretim (m3)",1000,null,null,null,"Günlük Ortalama Üretim (m3)",1000]
[null,"Günlük Hammadde İhtiyacı",null,null,null,null,"Trankmikser Ort. Yük (m3)",8]
[null,"Mıcır(ton)",{"$f":"C16*'Maliyet Hesabı'!$C$4/1000","v":510},25,{"$f":"C18/D18","v":20.399999999999999},null,"Günlük sefer sayısı",{"$f":"H16/H17","v":125}]
[null,"Kum(ton)",{"$f":"C16*'Maliyet Hesabı'!$C$7/1000","v":380},25,{"$f":"C19/D19","v":15.2}]
[null,"Çimento(ton)",{"$f":"C16*'Maliyet Hesabı'!$C$11/1000","v":250},30,8.3333333333333339]
[null,"Toplam(ton)",{"$f":"SUM(C18:C20)","v":1140},null,{"$f":"SUM(E18:E20)","v":43.93333333333333}]

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

{"sheet":"Sheet3","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}