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

{"sheet":"Anggaran Keluarga","index":0,"n_rows":28,"n_cols":16,"rows_kept":28,"merged":[[11,1,11,15]]}
[null,"ANGGARAN KELUARGA SMITH"]
[null,"TAHUN:",2013]
[]
[null,"KAS TERSEDIA","JAN","FEB","MAR","APR","MEI","JUN","JUL","AGU","SEP","OKT","NOV","DES","TOTAL BERJALAN","TREN"]
[null,"Kas Bulanan",{"$f":"tblIncome[[#Totals],[JAN]]-tblExpenses[[#Totals],[JAN]]","v":{"v":1220,"d":"Rp1,220.00"}},{"$f":"tblIncome[[#Totals],[FEB]]-tblExpenses[[#Totals],[FEB]]","v":{"v":1587,"d":"Rp1,587.00"}},{"$f":"tblIncome[[#Totals],[MAR]]-tblExpenses[[#Totals],[MAR]]","v":{"v":1174,"d":"Rp1,174.00"}},{"$f":"tblIncome[[#Totals],[APR]]-tblExpenses[[#Totals],[APR]]","v":{"v":1445,"d":"Rp1,445.00"}},{"$f":"tblIncome[[#Totals],[MEI]]-tblExpenses[[#Totals],[MEI]]","v":{"v":1391,"d":"Rp1,391.00"}},{"$f":"tblIncome[[#Totals],[JUN]]-tblExpenses[[#Totals],[JUN]]","v":{"v":1434,"d":"Rp1,434.00"}},{"$f":"tblIncome[[#Totals],[JUL]]-tblExpenses[[#Totals],[JUL]]","v":{"v":1085,"d":"Rp1,085.00"}},{"$f":"tblIncome[[#Totals],[AGU]]-tblExpenses[[#Totals],[AGU]]","v":{"v":1181,"d":"Rp1,181.00"}},{"$f":"tblIncome[[#Totals],[SEP]]-tblExpenses[[#Totals],[SEP]]","v":{"v":1445,"d":"Rp1,445.00"}},{"$f":"tblIncome[[#Totals],[OKT]]-tblExpenses[[#Totals],[OKT]]","v":{"v":1466,"d":"Rp1,466.00"}},{"$f":"tblIncome[[#Totals],[NOV]]-tblExpenses[[#Totals],[NOV]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"tblIncome[[#Totals],[DES]]-tblExpenses[[#Totals],[DES]]","v":{"v":0,"d":"Rp0.00"}},{"$f":"tblIncome[[#Totals],[TOTAL BERJALAN]]-tblExpenses[[#Totals],[TOTAL BERJALAN]]","v":{"v":13428,"d":"Rp13,428.00"}}]
[]
[null,"TIPE PENGHASILAN","JAN","FEB","MAR","APR","MEI","JUN","JUL","AGU","SEP","OKT","NOV","DES","TOTAL BERJALAN","TREN"]
[null,"Penghasilan 1",{"v":4000,"d":"Rp4,000.00"},{"v":4410,"d":"Rp4,410.00"},{"v":4019,"d":"Rp4,019.00"},{"v":4263,"d":"Rp4,263.00"},{"v":4123,"d":"Rp4,123.00"},{"v":4308,"d":"Rp4,308.00"},{"v":4162,"d":"Rp4,162.00"},{"v":4165,"d":"Rp4,165.00"},{"v":4248,"d":"Rp4,248.00"},{"v":4324,"d":"Rp4,324.00"},null,null,{"$f":"SUM(tblIncome[[#This Row],[JAN]:[DES]])","v":{"v":42022,"d":"Rp42,022.00"}}]
[null,"Penghasilan 2",{"v":275,"d":"Rp275.00"},{"v":296,"d":"Rp296.00"},{"v":251,"d":"Rp251.00"},{"v":269,"d":"Rp269.00"},{"v":252,"d":"Rp252.00"},{"v":252,"d":"Rp252.00"},{"v":262,"d":"Rp262.00"},{"v":258,"d":"Rp258.00"},{"v":296,"d":"Rp296.00"},{"v":270,"d":"Rp270.00"},null,null,{"$f":"SUM(tblIncome[[#This Row],[JAN]:[DES]])","v":{"v":2681,"d":"Rp2,681.00"}}]
[null,"Penghasilan Lain",{"v":500,"d":"Rp500.00"},{"v":507,"d":"Rp507.00"},{"v":551,"d":"Rp551.00"},{"v":556,"d":"Rp556.00"},{"v":588,"d":"Rp588.00"},{"v":534,"d":"Rp534.00"},{"v":533,"d":"Rp533.00"},{"v":585,"d":"Rp585.00"},{"v":560,"d":"Rp560.00"},{"v":520,"d":"Rp520.00"},null,null,{"$f":"SUM(tblIncome[[#This Row],[JAN]:[DES]])","v":{"v":5434,"d":"Rp5,434.00"}}]
[null,"TOTAL PENGHASILAN",{"$f":"SUBTOTAL(109,tblIncome[JAN])","v":{"v":4775,"d":"Rp4,775.00"}},{"$f":"SUBTOTAL(109,tblIncome[FEB])","v":{"v":5213,"d":"Rp5,213.00"}},{"$f":"SUBTOTAL(109,tblIncome[MAR])","v":{"v":4821,"d":"Rp4,821.00"}},{"$f":"SUBTOTAL(109,tblIncome[APR])","v":{"v":5088,"d":"Rp5,088.00"}},{"$f":"SUBTOTAL(109,tblIncome[MEI])","v":{"v":4963,"d":"Rp4,963.00"}},{"$f":"SUBTOTAL(109,tblIncome[JUN])","v":{"v":5094,"d":"Rp5,094.00"}},{"$f":"SUBTOTAL(109,tblIncome[JUL])","v":{"v":4957,"d":"Rp4,957.00"}},{"$f":"SUBTOTAL(109,tblIncome[AGU])","v":{"v":5008,"d":"Rp5,008.00"}},{"$f":"SUBTOTAL(109,tblIncome[SEP])","v":{"v":5104,"d":"Rp5,104.00"}},{"$f":"SUBTOTAL(109,tblIncome[OKT])","v":{"v":5114,"d":"Rp5,114.00"}},{"$f":"SUBTOTAL(109,tblIncome[NOV])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,tblIncome[DES])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,tblIncome[TOTAL BERJALAN])","v":{"v":50137,"d":"Rp50,137.00"}}]
[]
[null,"PENGELUARAN","JAN","FEB","MAR","APR","MEI","JUN","JUL","AGU","SEP","OKT","NOV","DES","TOTAL BERJALAN","TREN"]
[null,"Rumah",{"v":1500,"d":"Rp1,500.00"},{"v":1500,"d":"Rp1,500.00"},{"v":1500,"d":"Rp1,500.00"},{"v":1500,"d":"Rp1,500.00"},{"v":1500,"d":"Rp1,500.00"},{"v":1500,"d":"Rp1,500.00"},{"v":1500,"d":"Rp1,500.00"},{"v":1500,"d":"Rp1,500.00"},{"v":1500,"d":"Rp1,500.00"},{"v":1500,"d":"Rp1,500.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":15000,"d":"Rp15,000.00"}}]
[null,"Bahan Makanan",{"v":250,"d":"Rp250.00"},{"v":331,"d":"Rp331.00"},{"v":299,"d":"Rp299.00"},{"v":333,"d":"Rp333.00"},{"v":324,"d":"Rp324.00"},{"v":313,"d":"Rp313.00"},{"v":338,"d":"Rp338.00"},{"v":225,"d":"Rp225.00"},{"v":258,"d":"Rp258.00"},{"v":322,"d":"Rp322.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":2993,"d":"Rp2,993.00"}}]
[null,"Pembayaran mobil",{"v":345,"d":"Rp345.00"},{"v":345,"d":"Rp345.00"},{"v":345,"d":"Rp345.00"},{"v":345,"d":"Rp345.00"},{"v":345,"d":"Rp345.00"},{"v":345,"d":"Rp345.00"},{"v":345,"d":"Rp345.00"},{"v":345,"d":"Rp345.00"},{"v":345,"d":"Rp345.00"},{"v":345,"d":"Rp345.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":3450,"d":"Rp3,450.00"}}]
[null,"Asuransi",{"v":120,"d":"Rp120.00"},{"v":120,"d":"Rp120.00"},{"v":120,"d":"Rp120.00"},{"v":120,"d":"Rp120.00"},{"v":120,"d":"Rp120.00"},{"v":120,"d":"Rp120.00"},{"v":120,"d":"Rp120.00"},{"v":120,"d":"Rp120.00"},{"v":120,"d":"Rp120.00"},{"v":120,"d":"Rp120.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":1200,"d":"Rp1,200.00"}}]
[null,"Telepon rumah",{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":500,"d":"Rp500.00"}}]
[null,"Ponsel",{"v":72,"d":"Rp72.00"},{"v":70,"d":"Rp70.00"},{"v":80,"d":"Rp80.00"},{"v":70,"d":"Rp70.00"},{"v":75,"d":"Rp75.00"},{"v":80,"d":"Rp80.00"},{"v":90,"d":"Rp90.00"},{"v":73,"d":"Rp73.00"},{"v":75,"d":"Rp75.00"},{"v":70,"d":"Rp70.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":755,"d":"Rp755.00"}}]
[null,"TV Kabel",{"v":60,"d":"Rp60.00"},{"v":63,"d":"Rp63.00"},{"v":65,"d":"Rp65.00"},{"v":60,"d":"Rp60.00"},{"v":65,"d":"Rp65.00"},{"v":60,"d":"Rp60.00"},{"v":63,"d":"Rp63.00"},{"v":60,"d":"Rp60.00"},{"v":63,"d":"Rp63.00"},{"v":60,"d":"Rp60.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":619,"d":"Rp619.00"}}]
[null,"Internet",{"v":45,"d":"Rp45.00"},{"v":45,"d":"Rp45.00"},{"v":45,"d":"Rp45.00"},{"v":45,"d":"Rp45.00"},{"v":45,"d":"Rp45.00"},{"v":45,"d":"Rp45.00"},{"v":45,"d":"Rp45.00"},{"v":45,"d":"Rp45.00"},{"v":45,"d":"Rp45.00"},{"v":45,"d":"Rp45.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":450,"d":"Rp450.00"}}]
[null,"Listrik",{"v":155,"d":"Rp155.00"},{"v":155,"d":"Rp155.00"},{"v":158,"d":"Rp158.00"},{"v":160,"d":"Rp160.00"},{"v":165,"d":"Rp165.00"},{"v":200,"d":"Rp200.00"},{"v":340,"d":"Rp340.00"},{"v":350,"d":"Rp350.00"},{"v":240,"d":"Rp240.00"},{"v":180,"d":"Rp180.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":2103,"d":"Rp2,103.00"}}]
[null,"Air",{"v":35,"d":"Rp35.00"},{"v":35,"d":"Rp35.00"},{"v":37,"d":"Rp37.00"},{"v":39,"d":"Rp39.00"},{"v":45,"d":"Rp45.00"},{"v":42,"d":"Rp42.00"},{"v":42,"d":"Rp42.00"},{"v":36,"d":"Rp36.00"},{"v":38,"d":"Rp38.00"},{"v":40,"d":"Rp40.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":389,"d":"Rp389.00"}}]
[null,"Gas",{"v":50,"d":"Rp50.00"},{"v":45,"d":"Rp45.00"},{"v":40,"d":"Rp40.00"},{"v":40,"d":"Rp40.00"},{"v":42,"d":"Rp42.00"},{"v":50,"d":"Rp50.00"},{"v":55,"d":"Rp55.00"},{"v":40,"d":"Rp40.00"},{"v":43,"d":"Rp43.00"},{"v":30,"d":"Rp30.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":435,"d":"Rp435.00"}}]
[null,"Hiburan",{"v":123,"d":"Rp123.00"},{"v":92,"d":"Rp92.00"},{"v":58,"d":"Rp58.00"},{"v":131,"d":"Rp131.00"},{"v":46,"d":"Rp46.00"},{"v":105,"d":"Rp105.00"},{"v":84,"d":"Rp84.00"},{"v":108,"d":"Rp108.00"},{"v":132,"d":"Rp132.00"},{"v":136,"d":"Rp136.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":1015,"d":"Rp1,015.00"}}]
[null,"Uang Sekolah",{"v":550,"d":"Rp550.00"},{"v":550,"d":"Rp550.00"},{"v":550,"d":"Rp550.00"},{"v":550,"d":"Rp550.00"},{"v":550,"d":"Rp550.00"},{"v":550,"d":"Rp550.00"},{"v":550,"d":"Rp550.00"},{"v":550,"d":"Rp550.00"},{"v":550,"d":"Rp550.00"},{"v":550,"d":"Rp550.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":5500,"d":"Rp5,500.00"}}]
[null,"Tabungan",{"v":200,"d":"Rp200.00"},{"v":225,"d":"Rp225.00"},{"v":300,"d":"Rp300.00"},{"v":200,"d":"Rp200.00"},{"v":200,"d":"Rp200.00"},{"v":200,"d":"Rp200.00"},{"v":250,"d":"Rp250.00"},{"v":325,"d":"Rp325.00"},{"v":200,"d":"Rp200.00"},{"v":200,"d":"Rp200.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DES]])","v":{"v":2300,"d":"Rp2,300.00"}}]
[null,"TOTAL PENGELUARAN",{"$f":"SUBTOTAL(109,tblExpenses[JAN])","v":{"v":3555,"d":"Rp3,555.00"}},{"$f":"SUBTOTAL(109,tblExpenses[FEB])","v":{"v":3626,"d":"Rp3,626.00"}},{"$f":"SUBTOTAL(109,tblExpenses[MAR])","v":{"v":3647,"d":"Rp3,647.00"}},{"$f":"SUBTOTAL(109,tblExpenses[APR])","v":{"v":3643,"d":"Rp3,643.00"}},{"$f":"SUBTOTAL(109,tblExpenses[MEI])","v":{"v":3572,"d":"Rp3,572.00"}},{"$f":"SUBTOTAL(109,tblExpenses[JUN])","v":{"v":3660,"d":"Rp3,660.00"}},{"$f":"SUBTOTAL(109,tblExpenses[JUL])","v":{"v":3872,"d":"Rp3,872.00"}},{"$f":"SUBTOTAL(109,tblExpenses[AGU])","v":{"v":3827,"d":"Rp3,827.00"}},{"$f":"SUBTOTAL(109,tblExpenses[SEP])","v":{"v":3659,"d":"Rp3,659.00"}},{"$f":"SUBTOTAL(109,tblExpenses[OKT])","v":{"v":3648,"d":"Rp3,648.00"}},{"$f":"SUBTOTAL(109,tblExpenses[NOV])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,tblExpenses[DES])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,tblExpenses[TOTAL BERJALAN])","v":{"v":36709,"d":"Rp36,709.00"}}]