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

{"sheet":"Laporan Pengeluaran","index":0,"n_rows":24,"n_cols":13,"rows_kept":24,"merged":[[3,2,3,3],[3,5,3,6],[3,9,3,10],[4,2,4,3],[4,5,4,6],[4,9,4,10],[5,2,5,3],[5,5,5,6],[5,9,5,10],[6,2,6,3],[6,5,6,6],[6,9,6,10],[7,9,7,10]]}
[null,"LAPORAN PENGELUARAN"]
[null,"CONTOSO, LTD"]
[null,"123 South Main Street, North Buffalo, NY 12345"]
[null,"TELEPON",4255550121,null,"NAMA","Kirana Ariani",null,null,"TUJUAN","Seminar Penjualan Tahunan",null,"BIAYA PERJALANAN",{"v":5000,"d":"Rp5,000.00/mil"}]
[null,"FAKS",4255550122,null,"DEPARTEMEN","Penjualan",null,null,"DARI",{"$f":"IFERROR(MIN(Pengeluaran[TANGGAL]),\"\")","v":"2018-06-04"},null,"BIAYA KONSUMSI",{"v":300000,"d":"Rp300,000.00/hari"}]
[null,"EMAIL","info@contoso.com",null,"POSISI","Direktur Pengelolaan",null,null,"HINGGA",{"$f":"IFERROR(MAX(Pengeluaran[TANGGAL]),\"\")","v":"2018-07-04"},null,"BIAYA HOTEL",{"v":2000000,"d":"Rp2,000,000.00/malam"}]
[null,"WEB","www.contoso.com",null,"MANAJER","Mursadi Tunjung",null,null,"DIBUAT OLEH","Kirana Ariani",null,"BIAYA TELEPON",{"v":100000,"d":"Rp100,000.00/hari"}]
[{"$nulls":8},"DISETUJUI OLEH","Mursadi Tunjung",null,"BIAYA LAIN",{"v":500000,"d":"Rp500,000.00/hari"}]
[]
[null,"TANGGAL","PERIHAL","DESKRIPSI","HOTEL","TRANSPORTASI","KONSUMSI","TELEPON","LAIN-LAIN","ODOMETER \nAWAL","ODOMETER \nAKHIR","TOTAL \nJARAK TEMPUH","TOTAL "]
[null,{"$f":"TODAY()","v":"2018-06-04"},"Penjualan","Jarak tempuh",{"$nulls":4},{"v":500000,"d":"Rp500,000.00"},{"v":11378.5,"d":"11,378.5 mi."},{"v":11456.2,"d":"11,456.2 mi."},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[ODOMETER \nAWAL]:[ODOMETER \nAKHIR]])=2,(Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*BiayaPerjalanan,\"\")","v":{"v":388500.0000000036,"d":"Rp388,500"}},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[TANGGAL]:[ODOMETER \nAKHIR]])=0,\"\",SUM(Pengeluaran[[#This Row],[HOTEL]:[TRANSPORTASI]],Pengeluaran[[#This Row],[KONSUMSI]:[LAIN-LAIN]],((Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*(BiayaPerjalanan))))","v":{"v":888500.0000000036,"d":"Rp888,500"}}]
[null,{"$f":"TODAY()+30","v":"2018-07-04"},"Penjualan","Konvensi",{"v":4450000,"d":"Rp4,450,000.00"},{"v":2250000,"d":"Rp2,250,000.00"},{"v":200000,"d":"Rp200,000.00"},null,{"v":50000,"d":"Rp50,000.00"},{"v":11500,"d":"11,500.0 mi."},{"v":11560,"d":"11,560.0 mi."},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[ODOMETER \nAWAL]:[ODOMETER \nAKHIR]])=2,(Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*BiayaPerjalanan,\"\")","v":{"v":300000,"d":"Rp300,000"}},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[TANGGAL]:[ODOMETER \nAKHIR]])=0,\"\",SUM(Pengeluaran[[#This Row],[HOTEL]:[TRANSPORTASI]],Pengeluaran[[#This Row],[KONSUMSI]:[LAIN-LAIN]],((Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*(BiayaPerjalanan))))","v":{"v":7250000,"d":"Rp7,250,000"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[ODOMETER \nAWAL]:[ODOMETER \nAKHIR]])=2,(Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*BiayaPerjalanan,\"\")","v":""},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[TANGGAL]:[ODOMETER \nAKHIR]])=0,\"\",SUM(Pengeluaran[[#This Row],[HOTEL]:[TRANSPORTASI]],Pengeluaran[[#This Row],[KONSUMSI]:[LAIN-LAIN]],((Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*(BiayaPerjalanan))))","v":{"v":0,"d":"Rp0"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[ODOMETER \nAWAL]:[ODOMETER \nAKHIR]])=2,(Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*BiayaPerjalanan,\"\")","v":""},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[TANGGAL]:[ODOMETER \nAKHIR]])=0,\"\",SUM(Pengeluaran[[#This Row],[HOTEL]:[TRANSPORTASI]],Pengeluaran[[#This Row],[KONSUMSI]:[LAIN-LAIN]],((Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*(BiayaPerjalanan))))","v":{"v":0,"d":"Rp0"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[ODOMETER \nAWAL]:[ODOMETER \nAKHIR]])=2,(Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*BiayaPerjalanan,\"\")","v":""},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[TANGGAL]:[ODOMETER \nAKHIR]])=0,\"\",SUM(Pengeluaran[[#This Row],[HOTEL]:[TRANSPORTASI]],Pengeluaran[[#This Row],[KONSUMSI]:[LAIN-LAIN]],((Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*(BiayaPerjalanan))))","v":{"v":0,"d":"Rp0"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[ODOMETER \nAWAL]:[ODOMETER \nAKHIR]])=2,(Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*BiayaPerjalanan,\"\")","v":""},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[TANGGAL]:[ODOMETER \nAKHIR]])=0,\"\",SUM(Pengeluaran[[#This Row],[HOTEL]:[TRANSPORTASI]],Pengeluaran[[#This Row],[KONSUMSI]:[LAIN-LAIN]],((Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*(BiayaPerjalanan))))","v":{"v":0,"d":"Rp0"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[ODOMETER \nAWAL]:[ODOMETER \nAKHIR]])=2,(Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*BiayaPerjalanan,\"\")","v":""},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[TANGGAL]:[ODOMETER \nAKHIR]])=0,\"\",SUM(Pengeluaran[[#This Row],[HOTEL]:[TRANSPORTASI]],Pengeluaran[[#This Row],[KONSUMSI]:[LAIN-LAIN]],((Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*(BiayaPerjalanan))))","v":{"v":0,"d":"Rp0"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[ODOMETER \nAWAL]:[ODOMETER \nAKHIR]])=2,(Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*BiayaPerjalanan,\"\")","v":""},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[TANGGAL]:[ODOMETER \nAKHIR]])=0,\"\",SUM(Pengeluaran[[#This Row],[HOTEL]:[TRANSPORTASI]],Pengeluaran[[#This Row],[KONSUMSI]:[LAIN-LAIN]],((Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*(BiayaPerjalanan))))","v":{"v":0,"d":"Rp0"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[ODOMETER \nAWAL]:[ODOMETER \nAKHIR]])=2,(Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*BiayaPerjalanan,\"\")","v":""},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[TANGGAL]:[ODOMETER \nAKHIR]])=0,\"\",SUM(Pengeluaran[[#This Row],[HOTEL]:[TRANSPORTASI]],Pengeluaran[[#This Row],[KONSUMSI]:[LAIN-LAIN]],((Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*(BiayaPerjalanan))))","v":{"v":0,"d":"Rp0"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[ODOMETER \nAWAL]:[ODOMETER \nAKHIR]])=2,(Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*BiayaPerjalanan,\"\")","v":""},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[TANGGAL]:[ODOMETER \nAKHIR]])=0,\"\",SUM(Pengeluaran[[#This Row],[HOTEL]:[TRANSPORTASI]],Pengeluaran[[#This Row],[KONSUMSI]:[LAIN-LAIN]],((Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*(BiayaPerjalanan))))","v":{"v":0,"d":"Rp0"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[ODOMETER \nAWAL]:[ODOMETER \nAKHIR]])=2,(Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*BiayaPerjalanan,\"\")","v":""},{"$f":"IF(COUNTA(Pengeluaran[[#This Row],[TANGGAL]:[ODOMETER \nAKHIR]])=0,\"\",SUM(Pengeluaran[[#This Row],[HOTEL]:[TRANSPORTASI]],Pengeluaran[[#This Row],[KONSUMSI]:[LAIN-LAIN]],((Pengeluaran[[#This Row],[ODOMETER \nAKHIR]]-Pengeluaran[[#This Row],[ODOMETER \nAWAL]])*(BiayaPerjalanan))))","v":{"v":0,"d":"Rp0"}}]
[null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,Pengeluaran[HOTEL])","v":{"v":4450000,"d":"Rp4,450,000.00"}},{"$f":"SUBTOTAL(109,Pengeluaran[TRANSPORTASI])","v":{"v":2250000,"d":"Rp2,250,000.00"}},{"$f":"SUBTOTAL(109,Pengeluaran[KONSUMSI])","v":{"v":200000,"d":"Rp200,000.00"}},{"$f":"SUBTOTAL(109,Pengeluaran[TELEPON])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[LAIN-LAIN])","v":{"v":550000,"d":"Rp550,000.00"}},{"$nulls":3},{"$f":"SUBTOTAL(109,Pengeluaran[[TOTAL ]])","v":{"v":8138500.000000004,"d":"Rp8,138,500"}}]
[{"$nulls":11},"UANG MUKA",{"v":0,"d":"Rp0"}]
[{"$nulls":11},"TOTAL",{"$f":"Pengeluaran[[#Totals],[TOTAL ]]-Perkembangan","v":{"v":8138500.000000004,"d":"Rp8,138,500"}}]