{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Gider Raporu"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Gider Raporu","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"merged":[[0,1,0,5],[2,3,2,5],[2,6,2,7],[2,8,2,10],[4,3,4,5],[4,6,4,7],[4,8,4,10]]}
[null,"Seyahat Gider Raporu"]
[]
[null,"Ad","Merve Demir","Yetki veren:",null,null,"Burak Şahin",null,"Kilometre Başı Geri Ödeme",null,null,{"v":0.32,"d":"0.32 ₺"}]
[]
[null,"Departman","Satış","Gönderildiği Tarih",null,null,{"$f":"TODAY()","v":"2018-05-15"},null,"Geri Ödenecek Toplam Tutar",null,null,{"$f":"GeriÖdenecekToplamTutar","v":{"v":2100.894923547401,"d":"2,100.89 ₺"}}]
[]
[null,"Dönem",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"g.a.yy\"),\"Tarih aralığı: \"&TEXT(MIN(B10:B13),\"g.a.yy\")&\" - \"&TEXT(MAX(B10:B13),\"g.a.yy\"))","v":"Tarih aralığı: 15.4.18 - 20.4.18"}]
[]
[null,"Tarih","Gider Açıklaması","Uçak Bileti","Konaklama","Kara Ulaşımı \n(Yakıt, Araç Kiralama, Taksi)","Yemek ve Bahşişler","Konferans ve Seminerler","Mesafe","Seyahat Geri Ödemesi","Çeşitli","Para Birimi Döviz Kuru","Gider Para Birimi","Toplam"]
[null,{"$f":"TODAY()-30","v":"2018-04-15"},"Müşterinin ofisine ziyaret",{"v":350,"d":"350.00"},{"v":150,"d":"150.00"},{"v":45,"d":"45.00"},{"v":12,"d":"12.00"},{"v":50,"d":"50.00"},{"v":35,"d":"35.00"},{"$f":"IF('Gider Raporu'!I10<>\"\",'Gider Raporu'!I10*KilometreBirimFiyatı,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":0.327,"d":"0.33"},"TRY",{"$f":"IFERROR(IF(OR('Gider Raporu'!$L10=\"\",'Gider Raporu'!$L10=1),SUM('Gider Raporu'!$J10:$K10,'Gider Raporu'!$D10:$H10)*1,SUM('Gider Raporu'!$J10:$K10,'Gider Raporu'!$D10:$H10)/'Gider Raporu'!$L10),\"\")","v":{"v":1890.5198776758411,"d":"1,890.52 ₺"}}]
[null,{"$f":"TODAY()-30","v":"2018-04-15"},"Müşteriyle öğle yemeği",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF('Gider Raporu'!I11<>\"\",'Gider Raporu'!I11*KilometreBirimFiyatı,\"\")","v":3.84},null,{"v":0.327,"d":"0.33"},"TRY",{"$f":"IFERROR(IF(OR('Gider Raporu'!$L11=\"\",'Gider Raporu'!$L11=1),SUM('Gider Raporu'!$J11:$K11,'Gider Raporu'!$D11:$H11)*1,SUM('Gider Raporu'!$J11:$K11,'Gider Raporu'!$D11:$H11)/'Gider Raporu'!$L11),\"\")","v":{"v":86.05504587155963,"d":"86.06 ₺"}}]
[null,"2018-04-15","Öğleden sonraki seminer",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF('Gider Raporu'!I12<>\"\",'Gider Raporu'!I12*KilometreBirimFiyatı,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"TRY",{"$f":"IFERROR(IF(OR('Gider Raporu'!$L12=\"\",'Gider Raporu'!$L12=1),SUM('Gider Raporu'!$J12:$K12,'Gider Raporu'!$D12:$H12)*1,SUM('Gider Raporu'!$J12:$K12,'Gider Raporu'!$D12:$H12)/'Gider Raporu'!$L12),\"\")","v":{"v":101.92,"d":"101.92 ₺"}}]
[null,{"$f":"TODAY()-25","v":"2018-04-20"},"Havaalanına gidiş",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF('Gider Raporu'!I13<>\"\",'Gider Raporu'!I13*KilometreBirimFiyatı,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"TRY",{"$f":"IFERROR(IF(OR('Gider Raporu'!$L13=\"\",'Gider Raporu'!$L13=1),SUM('Gider Raporu'!$J13:$K13,'Gider Raporu'!$D13:$H13)*1,SUM('Gider Raporu'!$J13:$K13,'Gider Raporu'!$D13:$H13)/'Gider Raporu'!$L13),\"\")","v":{"v":22.400000000000002,"d":"22.40 ₺"}}]
[null,"Toplam",null,{"$f":"SUBTOTAL(109,Giderler[Uçak Bileti])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,Giderler[Konaklama])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Giderler[Kara Ulaşımı \n(Yakıt, Araç Kiralama, Taksi)])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,Giderler[Yemek ve Bahşişler])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,Giderler[Konferans ve Seminerler])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Giderler[Mesafe])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,Giderler[Seyahat Geri Ödemesi])","v":39.36},{"$f":"SUBTOTAL(109,Giderler[Çeşitli])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,Giderler[Toplam])","v":{"v":2100.894923547401,"d":"2,100.89 ₺"}}]