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

{"sheet":"Laporan Pengeluaran","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"merged":[[0,1,0,8],[0,9,0,11],[2,2,2,3],[2,4,2,5],[2,6,2,7],[5,2,5,3],[5,6,5,7],[5,10,5,11],[6,2,6,3],[6,6,6,7],[6,10,6,11],[17,1,17,10],[18,1,18,10],[19,1,19,10],[20,2,20,4],[20,6,20,9]]}
[null,"Nama Perusahaan",{"$nulls":7},"Hanya Untuk Keperluan Kantor"]
[null,"Laporan Pengeluaran"]
[null,"TUJUAN:",null,null,"NOMOR PERNYATAAN:",{"$nulls":4},"PERIODE PEMBAYARAN:","Dari",{"$f":"IFERROR(IF(LEN(B10)=0,\"\",MIN(Pengeluaran[Tanggal])), \"\")","v":""}]
[{"$nulls":10},"Hingga",{"$f":"IFERROR(IF(LEN(B10)=0,\"\",MAX(Pengeluaran[Tanggal])), \"\")","v":""}]
[null,"INFORMASI KARYAWAN:"]
[null,"Nama",{"$nulls":3},"Posisi",{"$nulls":3},"KTP/NIPER"]
[null,"Departemen",{"$nulls":3},"Manajer",{"$nulls":3},"ID Karyawan"]
[]
[null,"Tanggal","Akun","Deskripsi","Hotel","Transportasi","Bahan bakar","Konsumsi","Telepon","Hiburan","Lain-lain","Total"]
[{"$nulls":11},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Hotel]:[Lain-lain]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Hotel]:[Lain-lain]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Hotel]:[Lain-lain]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Hotel]:[Lain-lain]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Hotel]:[Lain-lain]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Hotel]:[Lain-lain]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Pengeluaran[[#This Row],[Hotel]:[Lain-lain]]), \"\")","v":0}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,Pengeluaran[Hotel])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Transportasi])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Bahan bakar])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Konsumsi])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Telepon])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Hiburan])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Lain-lain])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Total])","v":0}]
[null,"Subtotal",{"$nulls":9},{"$f":"IFERROR(SUM(Pengeluaran[[#Totals],[Total]]), \"\")","v":0}]
[null,"Jumlah Tarik Tunai"]
[null,"Total",{"$nulls":9},{"$f":"IFERROR((L18-L19), \"\")","v":0}]
[null,"DISETUJUI:",{"$nulls":3},"CATATAN: "]