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

{"sheet":"Laporan Perbelanjaan","index":0,"n_rows":27,"n_cols":14,"rows_kept":27,"merged":[[9,10,10,10]]}
[" LAPORAN PERBELANJAAN"]
[null,"CONTOSO, LTD"]
[null,"123 South Main Street, North Buffalo, NY 12345"]
[null,"TELEFON","425.555.0121",null,"NAMA","Kim Abercrombie",null,null,"TUJUAN","Seminar Jualan Tahunan",null,"KADAR PERBATUAN",{"v":0.5,"d":"RM0.50/batu"}]
[null,"FAKS","425.555.0122",null,"BAHAGIAN","Jualan",null,null,"PERMULAAN","2012-12-01",null,"KADAR MAKANAN",{"v":30,"d":"RM30.00/hari"}]
[null,"E-MEL","info@contoso.com",null,"KEDUDUKAN","Pengarah Urusan",null,null,"PENAMAT","2012-12-05",null,"KADAR HOTEL",{"v":200,"d":"RM200.00/malam"}]
[null,"WEB","www.contoso.com",null,"PENGURUS","Michael Tucker",null,null,"DISEDIAKAN OLEH","Kim Abercrombie",null,"KADAR TELEFON",{"v":10,"d":"RM10.00/hari"}]
[{"$nulls":8},"DILULUSKAN OLEH","Michael Tucker",null,"KADAR RAMPAIAN",{"v":50,"d":"RM50.00/hari"}]
[]
[{"$nulls":10},"ODOMETER",null,null," "]
[{"$nulls":13}," "]
[]
[null,"TARIKH","AKAUN","PERIHALAN","HOTEL","PENGANGKUTAN","MAKANAN","TELEFON","RAMPAIAN","MULA","TAMAT","JUMLAH","JUMLAH "]
[null,"2012-12-01","Jualan","Perbatuan",{"$nulls":5},{"v":11378.5,"d":"11,378.5 mi."},{"v":11456.2,"d":"11,456.2 mi."},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[MULA]:[TAMAT]])=2,(tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*MileageRate,\"\")","v":{"v":38.850000000000364,"d":"RM38.85"}},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[TARIKH]:[TAMAT]])=0,\"\",SUM(tblExpenses[[#This Row],[HOTEL]:[PENGANGKUTAN]],tblExpenses[[#This Row],[MAKANAN]:[RAMPAIAN]],((tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*(MileageRate))))","v":{"v":38.850000000000364,"d":"RM38.85"}}]
[null,"2012-12-02","Jualan","Konvensyen",{"v":445,"d":"RM445.00"},{"v":225,"d":"RM225.00"},{"v":20,"d":"RM20.00"},null,{"v":5,"d":"RM5.00"},null,null,{"$f":"IF(COUNTA(tblExpenses[[#This Row],[MULA]:[TAMAT]])=2,(tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[TARIKH]:[TAMAT]])=0,\"\",SUM(tblExpenses[[#This Row],[HOTEL]:[PENGANGKUTAN]],tblExpenses[[#This Row],[MAKANAN]:[RAMPAIAN]],((tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*(MileageRate))))","v":{"v":695,"d":"RM695.00"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[MULA]:[TAMAT]])=2,(tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[TARIKH]:[TAMAT]])=0,\"\",SUM(tblExpenses[[#This Row],[HOTEL]:[PENGANGKUTAN]],tblExpenses[[#This Row],[MAKANAN]:[RAMPAIAN]],((tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[MULA]:[TAMAT]])=2,(tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[TARIKH]:[TAMAT]])=0,\"\",SUM(tblExpenses[[#This Row],[HOTEL]:[PENGANGKUTAN]],tblExpenses[[#This Row],[MAKANAN]:[RAMPAIAN]],((tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[MULA]:[TAMAT]])=2,(tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[TARIKH]:[TAMAT]])=0,\"\",SUM(tblExpenses[[#This Row],[HOTEL]:[PENGANGKUTAN]],tblExpenses[[#This Row],[MAKANAN]:[RAMPAIAN]],((tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[MULA]:[TAMAT]])=2,(tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[TARIKH]:[TAMAT]])=0,\"\",SUM(tblExpenses[[#This Row],[HOTEL]:[PENGANGKUTAN]],tblExpenses[[#This Row],[MAKANAN]:[RAMPAIAN]],((tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[MULA]:[TAMAT]])=2,(tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[TARIKH]:[TAMAT]])=0,\"\",SUM(tblExpenses[[#This Row],[HOTEL]:[PENGANGKUTAN]],tblExpenses[[#This Row],[MAKANAN]:[RAMPAIAN]],((tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[MULA]:[TAMAT]])=2,(tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[TARIKH]:[TAMAT]])=0,\"\",SUM(tblExpenses[[#This Row],[HOTEL]:[PENGANGKUTAN]],tblExpenses[[#This Row],[MAKANAN]:[RAMPAIAN]],((tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[MULA]:[TAMAT]])=2,(tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[TARIKH]:[TAMAT]])=0,\"\",SUM(tblExpenses[[#This Row],[HOTEL]:[PENGANGKUTAN]],tblExpenses[[#This Row],[MAKANAN]:[RAMPAIAN]],((tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[MULA]:[TAMAT]])=2,(tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[TARIKH]:[TAMAT]])=0,\"\",SUM(tblExpenses[[#This Row],[HOTEL]:[PENGANGKUTAN]],tblExpenses[[#This Row],[MAKANAN]:[RAMPAIAN]],((tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[MULA]:[TAMAT]])=2,(tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(tblExpenses[[#This Row],[TARIKH]:[TAMAT]])=0,\"\",SUM(tblExpenses[[#This Row],[HOTEL]:[PENGANGKUTAN]],tblExpenses[[#This Row],[MAKANAN]:[RAMPAIAN]],((tblExpenses[[#This Row],[TAMAT]]-tblExpenses[[#This Row],[MULA]])*(MileageRate))))","v":""}]
[null,"JUMLAH",null,null,{"$f":"SUBTOTAL(109,tblExpenses[HOTEL])","v":{"v":445,"d":"RM445.00"}},{"$f":"SUBTOTAL(109,tblExpenses[PENGANGKUTAN])","v":{"v":225,"d":"RM225.00"}},{"$f":"SUBTOTAL(109,tblExpenses[MAKANAN])","v":{"v":20,"d":"RM20.00"}},{"$f":"SUBTOTAL(109,tblExpenses[TELEFON])","v":{"v":0,"d":"RM0.00"}},{"$f":"SUBTOTAL(109,tblExpenses[RAMPAIAN])","v":{"v":5,"d":"RM5.00"}},{"$nulls":3},{"$f":"SUBTOTAL(109,tblExpenses[[JUMLAH ]])","v":{"v":733.8500000000004,"d":"RM733.85"}}]
[{"$nulls":11},"PENDAHULUAN",{"v":0,"d":"RM0.00"}]
[{"$nulls":11},"JUMLAH",{"$f":"tblExpenses[[#Totals],[JUMLAH ]]-Advances","v":{"v":733.8500000000004,"d":"RM733.85"}}]