{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Anggaran Perjalanan Bisnis"],"not_rendered":{"charts":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Anggaran Perjalanan Bisnis","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4]]}
[null,"Anggaran Perjalanan Bisnis"]
[null,"Target anggaran perjalanan ",null,{"v":2500,"d":"Rp2,500.00"},null,null,{"$f":"D3","v":{"v":2369.3599999999997,"d":"Rp2,369.36"}}]
[null,"Total biaya perjalanan",null,{"$f":"SUBTOTAL(9,Data[Jumlah])","v":{"v":2369.3599999999997,"d":"Rp2,369.36"}},null,null,{"$f":"D2","v":{"v":2500,"d":"Rp2,500.00"}}]
[null,{"$f":"IF(D2>D3,\"Anda di bawah anggaran sebanyak\",\"Anda melebihi anggaran sebanyak\")","v":"Anda di bawah anggaran sebanyak"},null,{"$f":"(D2-D3)","v":{"v":130.64000000000033,"d":"Rp130.64"}}]
[null,"Item","Deskripsi","Biaya","Jml","Jumlah","Catatan"]
[null,"Tiket pesawat","Tiket",{"v":300,"d":"Rp300.00"},1,{"$f":"Data[[#This Row],[Jml]]*Data[[#This Row],[Biaya]]","v":{"v":300,"d":"Rp300.00"}}]
[null,"Tiket pesawat","Tiket",{"v":350,"d":"Rp350.00"},1,{"$f":"Data[[#This Row],[Jml]]*Data[[#This Row],[Biaya]]","v":{"v":350,"d":"Rp350.00"}}]
[null,"Hotel","Ruang",{"v":125,"d":"Rp125.00"},3,{"$f":"Data[[#This Row],[Jml]]*Data[[#This Row],[Biaya]]","v":{"v":375,"d":"Rp375.00"}}]
[null,"Hotel","Ruang",{"v":150,"d":"Rp150.00"},3,{"$f":"Data[[#This Row],[Jml]]*Data[[#This Row],[Biaya]]","v":{"v":450,"d":"Rp450.00"}}]
[null,"Sewa mobil","Biaya per hari",{"v":52,"d":"Rp52.00"},6,{"$f":"Data[[#This Row],[Jml]]*Data[[#This Row],[Biaya]]","v":{"v":312,"d":"Rp312.00"}}]
[null,"Bahan bakar","Biaya per galon",{"v":1.74,"d":"Rp1.74"},14,{"$f":"Data[[#This Row],[Jml]]*Data[[#This Row],[Biaya]]","v":{"v":24.36,"d":"Rp24.36"}}]
[null,"Hiburan","Jumlah",{"v":130,"d":"Rp130.00"},1,{"$f":"Data[[#This Row],[Jml]]*Data[[#This Row],[Biaya]]","v":{"v":130,"d":"Rp130.00"}}]
[null,"Hadiah","Jumlah",{"v":85,"d":"Rp85.00"},1,{"$f":"Data[[#This Row],[Jml]]*Data[[#This Row],[Biaya]]","v":{"v":85,"d":"Rp85.00"}}]
[null,"Lain-lain","Jumlah",{"v":55,"d":"Rp55.00"},1,{"$f":"Data[[#This Row],[Jml]]*Data[[#This Row],[Biaya]]","v":{"v":55,"d":"Rp55.00"}}]
[null,"Makanan","Biaya per hari",{"v":48,"d":"Rp48.00"},6,{"$f":"Data[[#This Row],[Jml]]*Data[[#This Row],[Biaya]]","v":{"v":288,"d":"Rp288.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Data[Jumlah])","v":{"v":2369.3599999999997,"d":"Rp2,369.36"}}]