{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Personlig pengeoversikt","Månedlig sammendrag","Diagramdata"],"not_rendered":{"charts":2,"defined_names":8,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Personlig pengeoversikt","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[8,3,8,6],[19,1,20,1],[21,1,23,1]]}
[null,"Personlig pengeoversikt"]
[]
[{"$nulls":3},"Kontantsammendrag"]
[{"$nulls":3},"Konto","Kontanter ved start","Forbruk totalt","Gjenstående kontanter"]
[{"$nulls":3},"Lønnskonto",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(CashSpent[Konto],\"=\" &CashSummaryTable[[#This Row],[Konto]],CashSpent[Beløp])","v":{"v":428,"d":"428.00"}},{"$f":"CashSummaryTable[[#This Row],[Kontanter ved start]]-CashSummaryTable[[#This Row],[Forbruk totalt]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"Sparing",{"v":500,"d":"500.00"},{"$f":"SUMIF(CashSpent[Konto],\"=\" &CashSummaryTable[[#This Row],[Konto]],CashSpent[Beløp])","v":{"v":450,"d":"450.00"}},{"$f":"CashSummaryTable[[#This Row],[Kontanter ved start]]-CashSummaryTable[[#This Row],[Forbruk totalt]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"Annet",{"v":200,"d":"200.00"},{"$f":"SUMIF(CashSpent[Konto],\"=\" &CashSummaryTable[[#This Row],[Konto]],CashSpent[Beløp])","v":{"v":30,"d":"30.00"}},{"$f":"CashSummaryTable[[#This Row],[Kontanter ved start]]-CashSummaryTable[[#This Row],[Forbruk totalt]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3},"Totalt",{"$f":"SUBTOTAL(109,CashSummaryTable[Kontanter ved start])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[Forbruk totalt])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[Gjenstående kontanter])","v":{"v":2792,"d":"2792.00"}}]
[]
[{"$nulls":3},"Kontanter jeg har brukt"]
[{"$nulls":3},"Dato","Beskrivelse","Beløp","Konto"]
[{"$nulls":3},"2012-01-04","Minibankuttak",{"v":40,"d":"40.00"},"Lønnskonto"]
[{"$nulls":3},"2012-01-05","Lunsj",{"v":5,"d":"5.00"},"Lønnskonto"]
[{"$nulls":3},"2012-01-06","Billån",{"v":230,"d":"230.00"},"Sparing"]
[{"$nulls":3},"2012-02-03","Strømregning",{"v":70,"d":"70.00"},"Lønnskonto"]
[{"$nulls":3},"2012-02-07","Middag",{"v":53,"d":"53.00"},"Lønnskonto"]
[{"$nulls":3},"2012-03-01","Kontantuttak",{"v":100,"d":"100.00"},"Sparing"]
[{"$nulls":3},"2012-03-06","Billån",{"v":230,"d":"230.00"},"Lønnskonto"]
[{"$nulls":3},"2012-04-06","Strømregning",{"v":70,"d":"70.00"},"Sparing"]
[null,"Gjenstående\nkontanter:",null,"2012-04-20","Minibankuttak",{"v":30,"d":"30.00"},"Lønnskonto"]
[{"$nulls":3},"2012-05-03","Minibankuttak",{"v":50,"d":"50.00"},"Sparing"]
[null,{"$f":"CashSummaryTable[[#Totals],[Gjenstående kontanter]]/CashSummaryTable[[#Totals],[Kontanter ved start]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-10","Minibankuttak",{"v":30,"d":"30.00"},"Annet"]

{"sheet":"Månedlig sammendrag","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Månedlig sammendrag"]
[null,"Kontosammendrag"]
{"$rows_empty":13}
[null,"Forbrukssammendrag"]
[null,"Detaljer"]
[null,null,"Annet","Lønnskonto","Sparing","Totalsum"]
[null,"jan",null,{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},{"v":275,"d":"275.00"}]
[null,"feb",null,{"v":123,"d":"123.00"},null,{"v":123,"d":"123.00"}]
[null,"mar",null,{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},{"v":330,"d":"330.00"}]
[null,"Billån",null,{"v":230,"d":"230.00"},null,{"v":230,"d":"230.00"}]
[null,"Kontantuttak",null,null,{"v":100,"d":"100.00"},{"v":100,"d":"100.00"}]
[null,"apr",null,{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},{"v":100,"d":"100.00"}]
[null,"mai",{"v":30,"d":"30.00"},null,{"v":50,"d":"50.00"},{"v":80,"d":"80.00"}]
[null,"Totalsum",{"v":30,"d":"30.00"},{"v":428,"d":"428.00"},{"v":450,"d":"450.00"},{"v":908,"d":"908.00"}]

{"sheet":"Diagramdata","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"Pivotdiagramdata"]
[null,"Denne pivottabellen er datakilden for pivotdiagrammet for Kontosammendrag i Månedlig sammendrag-arket."]
[null,"Summer av Beløp","Kolonneetiketter"]
[null,"Radetiketter","Annet","Lønnskonto","Sparing","Totalsum"]
[null,"jan",null,{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},{"v":275,"d":"275.00"}]
[null,"feb",null,{"v":123,"d":"123.00"},null,{"v":123,"d":"123.00"}]
[null,"mar",null,{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},{"v":330,"d":"330.00"}]
[null,"apr",null,{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},{"v":100,"d":"100.00"}]
[null,"mai",{"v":30,"d":"30.00"},null,{"v":50,"d":"50.00"},{"v":80,"d":"80.00"}]
[null,"Totalsum",{"v":30,"d":"30.00"},{"v":428,"d":"428.00"},{"v":450,"d":"450.00"},{"v":908,"d":"908.00"}]