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

{"sheet":"Laporan Pengeluaran","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,"Laporan Biaya Perjalanan"]
[]
[null,"Nama","Kirana Ariani ","Disahkan oleh",null,null,"Yogi Budiman",null,"Biaya Penggantian per Mil",null,null,{"v":0.32,"d":"Rp0.32"}]
[]
[null,"Departemen","Penjualan","Tanggal Dikirim",null,null,{"$f":"TODAY()","v":"2018-01-19"},null,"Total Biaya Penggantian",null,null,{"$f":"TotalBiayaPenggantian","v":{"v":6463524.32,"d":"Rp6,463,524.32"}}]
[]
[null,"Periode",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"d/m/yy\"),\"Dari \"&TEXT(MIN(B10:B13),\"d/m/yy\")&\" hingga \"&TEXT(MAX(B10:B13),\"d/m/yy\"))","v":"Dari 20/12/17 hingga 25/12/17"}]
[]
[null,"Tanggal","Deskripsi Pengeluaran","Tiket pesawat","Akomodasi","Transportasi Darat \n(Bahan Bakar, Sewa Mobil, Taksi)","Konsumsi & Tips","Konferensi dan Seminar","Mil","Penggantian Berdasarkan Jarak","Lain-lain","Kurs Mata Uang","Mata Uang Pengeluaran","Total"]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"Perjalanan ke kantor klien",{"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('Laporan Pengeluaran'!I10<>\"\",'Laporan Pengeluaran'!I10*BiayaPerjalanan,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":1E-4,"d":"0.0001"},"CAD",{"$f":"IFERROR(IF(OR('Laporan Pengeluaran'!$L10=\"\",'Laporan Pengeluaran'!$L10=1),SUM('Laporan Pengeluaran'!$J10:$K10,'Laporan Pengeluaran'!$D10:$H10)*1,SUM('Laporan Pengeluaran'!$J10:$K10,'Laporan Pengeluaran'!$D10:$H10)/'Laporan Pengeluaran'!$L10),\"\")","v":{"v":6182000,"d":"Rp6,182,000.00"}}]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"Makan siang dengan klien",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF('Laporan Pengeluaran'!I11<>\"\",'Laporan Pengeluaran'!I11*BiayaPerjalanan,\"\")","v":3.84},null,{"v":1E-4,"d":"0.0001"},"CAD",{"$f":"IFERROR(IF(OR('Laporan Pengeluaran'!$L11=\"\",'Laporan Pengeluaran'!$L11=1),SUM('Laporan Pengeluaran'!$J11:$K11,'Laporan Pengeluaran'!$D11:$H11)*1,SUM('Laporan Pengeluaran'!$J11:$K11,'Laporan Pengeluaran'!$D11:$H11)/'Laporan Pengeluaran'!$L11),\"\")","v":{"v":281400,"d":"Rp281,400.00"}}]
[null,"2017-12-20","Seminar sore",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF('Laporan Pengeluaran'!I12<>\"\",'Laporan Pengeluaran'!I12*BiayaPerjalanan,\"\")","v":1.92},null,{"v":1,"d":"1.0000"},"IDR",{"$f":"IFERROR(IF(OR('Laporan Pengeluaran'!$L12=\"\",'Laporan Pengeluaran'!$L12=1),SUM('Laporan Pengeluaran'!$J12:$K12,'Laporan Pengeluaran'!$D12:$H12)*1,SUM('Laporan Pengeluaran'!$J12:$K12,'Laporan Pengeluaran'!$D12:$H12)/'Laporan Pengeluaran'!$L12),\"\")","v":{"v":101.92,"d":"Rp101.92"}}]
[null,{"$f":"TODAY()-25","v":"2017-12-25"},"Perjalanan ke bandara",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF('Laporan Pengeluaran'!I13<>\"\",'Laporan Pengeluaran'!I13*BiayaPerjalanan,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.0000"},"IDR",{"$f":"IFERROR(IF(OR('Laporan Pengeluaran'!$L13=\"\",'Laporan Pengeluaran'!$L13=1),SUM('Laporan Pengeluaran'!$J13:$K13,'Laporan Pengeluaran'!$D13:$H13)*1,SUM('Laporan Pengeluaran'!$J13:$K13,'Laporan Pengeluaran'!$D13:$H13)/'Laporan Pengeluaran'!$L13),\"\")","v":{"v":22.400000000000002,"d":"Rp22.40"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Pengeluaran[Tiket pesawat])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,Pengeluaran[Akomodasi])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Pengeluaran[Transportasi Darat \n(Bahan Bakar, Sewa Mobil, Taksi)])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,Pengeluaran[Konsumsi & Tips])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,Pengeluaran[Konferensi dan Seminar])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Pengeluaran[Mil])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,Pengeluaran[Penggantian Berdasarkan Jarak])","v":39.36},{"$f":"SUBTOTAL(109,Pengeluaran[Lain-lain])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,Pengeluaran[Total])","v":{"v":6463524.32,"d":"Rp6,463,524.32"}}]