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

{"sheet":"Laporan Pengeluaran","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[18,1,18,9],[27,1,27,9],[35,1,35,9],[40,1,43,4]]}
["NAMA PERUSAHAAN"]
["LAPORAN PENGELUARAN"]
[]
[null,"KARYAWAN:","Kim Abercrombie",{"$nulls":3},"DIOTORISASI OLEH:"]
[null,"DEPARTEMEN:","Penjualan"]
[null,"AKHIR MINGGU:","2013-03-10",{"$nulls":3},"TANGGAL:"]
[null,"TINGKAT JARAK TEMPUH:","0,67"]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"dddd\"))","v":"SENIN"},{"$f":"UPPER(TEXT(D10,\"dddd\"))","v":"SELASA"},"RABU","KAMIS","JUMAT","SABTU","MINGGU"]
[null,"TRANSPORTASI",{"$f":"WeekEnding-6","v":"2013-03-04"},{"$f":"WeekEnding-5","v":"2013-03-05"},{"$f":"WeekEnding-4","v":"2013-03-06"},{"$f":"WeekEnding-3","v":"2013-03-07"},{"$f":"WeekEnding-2","v":"2013-03-08"},{"$f":"WeekEnding-1","v":"2013-03-09"},{"$f":"WeekEnding","v":"2013-03-10"},"TOTAL"]
[null,"Mil Dipakai",145,{"$nulls":6},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":145}]
[null,"Penggantian Biaya Mil",{"$f":"C11*MileageRate","v":{"v":97.15,"d":"Rp97"}},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":97.15,"d":"Rp97"}}]
[null,"Parkir dan Tol",{"$nulls":3},{"v":17,"d":"Rp17"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":17,"d":"Rp17"}}]
[null,"Sewa Mobil",{"v":79,"d":"Rp79"},null,null,{"v":79,"d":"Rp79"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":158,"d":"Rp158"}}]
[null,"Taksi / Limo",{"$nulls":7},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya (Kereta atau Bus)",{"$nulls":7},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"Rp0"}}]
[null,"Ongkos Pesawat",{"$nulls":3},{"v":235,"d":"Rp235"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":235,"d":"Rp235"}}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":176.15,"d":"Rp176"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":"Rp0"}},null,{"$f":"SUBTOTAL(109,F12:F17)","v":{"v":331,"d":"Rp331"}},{"$f":"SUBTOTAL(109,G12:G17)","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,H12:H17)","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,I12:I17)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(J12:J17)","v":{"v":507.15,"d":"Rp507"}}]
[]
[null,"PENGINAPAN & MAKANAN"]
[null,"Penginapan",{"v":145,"d":"Rp145"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":145,"d":"Rp145"}}]
[null,"Sarapan pagi",{"v":11.49,"d":"Rp11"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":11.49,"d":"Rp11"}}]
[null,"Makan Siang",{"v":12,"d":"Rp12"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":12,"d":"Rp12"}}]
[null,"Makan malam",{"v":17,"d":"Rp17"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":17,"d":"Rp17"}}]
[null,"Makanan ringan",{"$f":"C24*MileageRate","v":{"v":11.39,"d":"Rp11"}},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":11.39,"d":"Rp11"}}]
[null,"Subtotal Makanan",{"$f":"SUM(C22:C24)","v":{"v":40.49,"d":"Rp40"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"Rp0"}},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":40.49,"d":"Rp40"}}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":185.49,"d":"Rp185"}},{"$f":"SUBTOTAL(109,D21,D26)","v":{"v":0,"d":"Rp0"}},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"$f":"SUBTOTAL(109,J21,J26)","v":{"v":185.49,"d":"Rp185"}}]
[]
[null,"LAIN-LAIN"]
[null,"Persediaan",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"Rp0"}}]
[null,"Perlengkapan",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"Rp0"}}]
[null,"Telepon, Faks, Internet",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya*",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"Rp0"}}]
[null,"Hiburan*",{"$nulls":3},{"v":199,"d":"Rp199"},{"$nulls":3},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":199,"d":"Rp199"}}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,Misc[Day 1])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Misc[Day 2])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Misc[Day 3])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Misc[Day 4])","v":{"v":199,"d":"Rp199"}},{"$f":"SUBTOTAL(109,Misc[Day 5])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Misc[Day 6])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Misc[Day 7])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Misc[Total])","v":{"v":199,"d":"Rp199"}}]
[]
[null,"TOTAL KESELURUHAN",{"$f":"SUM(Misc[[#Totals],[Day 1]],LodgingMeals[[#Totals],[Day 1]],Transportation[[#Totals],[Day 1]])","v":{"v":361.64,"d":"Rp362"}},{"$f":"SUM(Misc[[#Totals],[Day 2]],LodgingMeals[[#Totals],[Day 2]],Transportation[[#Totals],[Day 2]])","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Misc[[#Totals],[Day 3]],LodgingMeals[[#Totals],[Day 3]],Transportation[[#Totals],[Day 3]])","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Misc[[#Totals],[Day 4]],LodgingMeals[[#Totals],[Day 4]],Transportation[[#Totals],[Day 4]])","v":{"v":530,"d":"Rp530"}},{"$f":"SUM(Misc[[#Totals],[Day 5]],LodgingMeals[[#Totals],[Day 5]],Transportation[[#Totals],[Day 5]])","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Misc[[#Totals],[Day 6]],LodgingMeals[[#Totals],[Day 6]],Transportation[[#Totals],[Day 6]])","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Misc[[#Totals],[Day 7]],LodgingMeals[[#Totals],[Day 7]],Transportation[[#Totals],[Day 7]])","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Misc[[#Totals],[Total]],LodgingMeals[[#Totals],[Total]],Transportation[[#Totals],[Total]])","v":{"v":891.64,"d":"Rp892"}}]
[]
[{"$nulls":9},"TOTAL PENGELUARAN"]
[null,"*Tujuan bisnis untuk \"Hiburan\" dan item \"Lainnya\":",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":891.64,"d":"Rp892"}}]
[{"$nulls":9},"PENGAMBILAN UANG DI MUKA"]
[]
[{"$nulls":9},"TOTAL PENGGANTIAN BIAYA"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":891.64,"d":"Rp892"}}]
[{"$nulls":9},"Harap lampirkan semua tanda terima."]