{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Anggaran 18 Periode"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Anggaran 18 Periode","index":0,"n_rows":26,"n_cols":22,"rows_kept":26,"merged":[[0,1,1,4],[1,8,1,9],[12,1,12,20],[26,1,26,21]]}
[null,"anggaran perusahaan"]
[{"$nulls":6},"TANGGAL MULAI","2011-01-01","JANGKA WAKTU (DALAM HARI)",null,14,"TANGGAL AKHIR",{"$f":"TEXT(T5,\"dd/mm/yyyy\")","v":"26/08/2012"}]
[]
[]
[null,null,{"$f":"UPPER(TEXT(H2,\"dd-mmm\"))","v":"01-JAN"},{"$f":"UPPER(TEXT(C5+DayInterval,\"dd-mmm\"))","v":"15-JAN"},"29-JAN","12-FEB","26-FEB","11-MAR","25-MAR","08-APR","22-APR","06-MEI","20-MEI","03-JUN","17-JUN","01-JUL","15-JUL","29-JUL","12-AGU","26-AGU","TOTAL","TREN"]
[null,"PENGHASILAN BERSIH",{"$f":"IncomeTable[[#Totals],[Week 1]]-ExpensesTable[[#Totals],[Week 1]]","v":{"v":1750,"d":"Rp1,750.00"}},{"$f":"IncomeTable[[#Totals],[Week 2]]-ExpensesTable[[#Totals],[Week 2]]","v":{"v":2236,"d":"Rp2,236.00"}},{"$f":"IncomeTable[[#Totals],[Week 3]]-ExpensesTable[[#Totals],[Week 3]]","v":{"v":1442,"d":"Rp1,442.00"}},{"$f":"IncomeTable[[#Totals],[Week 4]]-ExpensesTable[[#Totals],[Week 4]]","v":{"v":2253,"d":"Rp2,253.00"}},{"$f":"IncomeTable[[#Totals],[Week 5]]-ExpensesTable[[#Totals],[Week 5]]","v":{"v":1533,"d":"Rp1,533.00"}},{"$f":"IncomeTable[[#Totals],[Week 6]]-ExpensesTable[[#Totals],[Week 6]]","v":{"v":1086,"d":"Rp1,086.00"}},{"$f":"IncomeTable[[#Totals],[Week 7]]-ExpensesTable[[#Totals],[Week 7]]","v":{"v":1594,"d":"Rp1,594.00"}},{"$f":"IncomeTable[[#Totals],[Week 8]]-ExpensesTable[[#Totals],[Week 8]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 9]]-ExpensesTable[[#Totals],[Week 9]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 10]]-ExpensesTable[[#Totals],[Week 10]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 11]]-ExpensesTable[[#Totals],[Week 11]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 12]]-ExpensesTable[[#Totals],[Week 12]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 13]]-ExpensesTable[[#Totals],[Week 13]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 14]]-ExpensesTable[[#Totals],[Week 14]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 15]]-ExpensesTable[[#Totals],[Week 15]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 16]]-ExpensesTable[[#Totals],[Week 16]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 17]]-ExpensesTable[[#Totals],[Week 17]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 18]]-ExpensesTable[[#Totals],[Week 18]]","v":0},{"$f":"IncomeTable[[#Totals],[Total]]-ExpensesTable[[#Totals],[Total]]","v":{"v":11894,"d":"Rp11,894.00"}}]
[]
["penghasilan"]
[null,"ITEM PENGHASILAN 1",{"v":3000,"d":"Rp3,000.00"},{"v":3500,"d":"Rp3,500.00"},{"v":2978,"d":"Rp2,978.00"},{"v":3384,"d":"Rp3,384.00"},{"v":2858,"d":"Rp2,858.00"},{"v":2809,"d":"Rp2,809.00"},{"v":3220,"d":"Rp3,220.00"},{"$nulls":11},{"$f":"SUM(IncomeTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":21749,"d":"Rp21,749.00"}}]
[null,"ITEM PENGHASILAN 2",{"v":1150,"d":"1,150.00"},{"v":1200,"d":"1,200.00"},{"v":1144,"d":"1,144.00"},{"v":1400,"d":"1,400.00"},{"v":1358,"d":"1,358.00"},{"v":1154,"d":"1,154.00"},{"v":1245,"d":"1,245.00"},{"$nulls":11},{"$f":"SUM(IncomeTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":8651,"d":"8,651.00"}}]
[null,"ITEM PENGHASILAN 3",{"v":300,"d":"300.00"},{"v":350,"d":"350.00"},{"v":392,"d":"392.00"},{"v":326,"d":"326.00"},{"v":381,"d":"381.00"},{"v":364,"d":"364.00"},{"v":315,"d":"315.00"},{"$nulls":11},{"$f":"SUM(IncomeTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":2428,"d":"2,428.00"}}]
[null,"TOTAL PENGHASILAN",{"$f":"SUBTOTAL(109,IncomeTable[Week 1])","v":{"v":4450,"d":"Rp4,450.00"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 2])","v":{"v":5050,"d":"Rp5,050.00"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 3])","v":{"v":4514,"d":"Rp4,514.00"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 4])","v":{"v":5110,"d":"Rp5,110.00"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 5])","v":{"v":4597,"d":"Rp4,597.00"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 6])","v":{"v":4327,"d":"Rp4,327.00"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 7])","v":{"v":4780,"d":"Rp4,780.00"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 8])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 9])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 10])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 11])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 12])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 13])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 14])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 15])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 16])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 17])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 18])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Total])","v":{"v":32828,"d":"Rp32,828.00"}}]
[]
["pengeluaran"]
[null,"GAJI",{"v":1500,"d":"Rp1,500.00"},{"v":1577,"d":"Rp1,577.00"},{"v":1823,"d":"Rp1,823.00"},{"v":1529,"d":"Rp1,529.00"},{"v":1759,"d":"Rp1,759.00"},{"v":1947,"d":"Rp1,947.00"},{"v":1875,"d":"Rp1,875.00"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":12010,"d":"Rp12,010.00"}}]
[null,"SEWA",{"v":1000,"d":"1,000.00"},{"v":1000,"d":"1,000.00"},{"v":1000,"d":"1,000.00"},{"v":1000,"d":"1,000.00"},{"v":1000,"d":"1,000.00"},{"v":1000,"d":"1,000.00"},{"v":1000,"d":"1,000.00"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":7000,"d":"7,000.00"}}]
[null,"LISTRIK",{"v":40,"d":"40.00"},{"v":43,"d":"43.00"},{"v":40,"d":"40.00"},{"v":42,"d":"42.00"},{"v":45,"d":"45.00"},{"v":40,"d":"40.00"},{"v":42,"d":"42.00"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":292,"d":"292.00"}}]
[null,"TELEPON",{"v":12,"d":"12.00"},{"v":11,"d":"11.00"},{"v":13,"d":"13.00"},{"v":14,"d":"14.00"},{"v":11,"d":"11.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":91,"d":"91.00"}}]
[null,"INTERNET",{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":105,"d":"105.00"}}]
[null,"AIR",{"v":11,"d":"11.00"},{"v":10,"d":"10.00"},{"v":13,"d":"13.00"},{"v":10,"d":"10.00"},{"v":13,"d":"13.00"},{"v":10,"d":"10.00"},{"v":12,"d":"12.00"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":79,"d":"79.00"}}]
[null,"GAS",{"v":23,"d":"23.00"},{"v":27,"d":"27.00"},{"v":26,"d":"26.00"},{"v":27,"d":"27.00"},{"v":22,"d":"22.00"},{"v":29,"d":"29.00"},{"v":21,"d":"21.00"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":175,"d":"175.00"}}]
[null,"IURAN SAMPAH",{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":28,"d":"28.00"}}]
[null,"TV KABEL",{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":70,"d":"70.00"}}]
[null,"PERLENGKAPAN KANTOR",{"v":25,"d":"25.00"},{"v":57,"d":"57.00"},{"v":68,"d":"68.00"},{"v":146,"d":"146.00"},{"v":125,"d":"125.00"},{"v":111,"d":"111.00"},{"v":132,"d":"132.00"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":664,"d":"664.00"}}]
[null,"ASURANSI",{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":420,"d":"420.00"}}]
[null,"TOTAL PENGELUARAN",{"$f":"SUBTOTAL(109,ExpensesTable[Week 1])","v":{"v":2700,"d":"Rp2,700.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 2])","v":{"v":2814,"d":"Rp2,814.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 3])","v":{"v":3072,"d":"Rp3,072.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 4])","v":{"v":2857,"d":"Rp2,857.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 5])","v":{"v":3064,"d":"Rp3,064.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 6])","v":{"v":3241,"d":"Rp3,241.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 7])","v":{"v":3186,"d":"Rp3,186.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 8])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 9])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 10])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 11])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 12])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 13])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 14])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 15])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 16])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 17])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 18])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Total])","v":{"v":20934,"d":"Rp20,934.00"}}]