{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Ny data","I alt","Strøm","Vand","Gas","Varmeenhed"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ny data","index":0,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,7,0,11],[0,13,0,15],[14,0,14,5]]}
["Ny registrering",null,null,null,null,null,null,"Opdatering af priser",null,null,null,null,null,"Første aflæsning - Må kun udføres én gang"]
["Dato",null,"dd-mm-åååå"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dato","2013-01-01","dd-mm-åååå"]
[{"$f":"H4","v":"Forbrugstype"},"Enhedsmængde",null,null,null,null,null,"Forbrugstype","Pris",null,null,null,null,{"$f":"H4","v":"Forbrugstype"},"Målerstand","Enhedstype"]
["El",null,{"$f":"P5","v":"kWh"},null,null,null,null,{"$f":"A5","v":"El"},0,{"$f":"\"/\"&P5","v":"/kWh"},null,null,null,{"$f":"H5","v":"El"},0,"kWh"]
["Vand",null,{"$f":"P6","v":"m3"},null,null,null,null,{"$f":"A6","v":"Vand"},0,{"$f":"\"/\"&P6","v":"/m3"},null,null,null,{"$f":"H6","v":"Vand"},0,"m3"]
[{"$f":"H7","v":"Gas"},null,{"$f":"P7","v":"m3"},null,null,null,null,{"$f":"N7","v":"Gas"},0,{"$f":"\"/\"&P7","v":"/m3"},null,null,null,"Gas",0,"m3"]
[]
[]
[]
[]
[]
[]
[]
["Vejledning - Læs denne vejledning inden brug. Det vil spare dig for meget frustration.\n\nFørste gang du bruger regnearket\nUnder overskriften \"Første aflæsning\" udfylder du de gule felter og trykker på \"Registrer første måling\". Dette skal kun gøres én gang.\n\nHerefter udfylder du dine forbrugspriser under overskriften \"Opdatering af priser\" og trykker på \"Opdater priser\". Dette skal gøres første gang, men du kan også ændre priserne løbende, hvis du fx finder ny leverandør eller priserne falder/stiger.\n\nHusk at opdatere eventuelle prisændringer inden du foretager ny registrering .\n\nNy registrering\nIndtast dato for aflæsning i korrekt format.\n\nIndtast de aflæste tal i de gule celler for hhv. strøm, vand og varme.\n\nTryk \"Registrer data\"\n\nBemærk: Dette regneark er i betaversion. Hvis du finder fejl eller mangler, er du meget velkommen til at kontakte mig via http://pengepugeren.dk/kontakt-pengepugeren-2/, så jeg kan opdatere arket med din fejlerettelse."]

{"sheet":"I alt","index":1,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Daglige forbrugsudgifter"]
["Dato",{"$f":"'Ny data'!N5","v":"El"},{"$f":"'Ny data'!N6","v":"Vand"},{"$f":"'Ny data'!N7","v":"Gas"},"I alt","Kr./dag",null,"Gns.","Dag","Md.","År"]
[{"$f":"Strøm!A3","v":"2013-01-01"},{"$f":"Strøm!G3","v":0},{"$f":"Vand!G3","v":0},{"$f":"Gas!G3","v":0},{"$f":"SUM(B3:D3)","v":0},{"$f":"IFERROR(Strøm!G3+Vand!G3+Gas!G3,\"\")","v":0},null,"EL",0,{"$f":"I3*30.44","v":0},{"$f":"I3*365.25","v":0}]
[null,null,null,null,null,null,null,"Vand",0,{"$f":"I4*30.44","v":0},{"$f":"I4*365.25","v":0}]
[null,null,null,null,null,null,null,"Gas",0,{"$f":"I5*30.44","v":0},{"$f":"I5*365.25","v":0}]
[null,null,null,null,null,null,null,"I alt",{"$f":"SUM(I3:I5)","v":0},{"$f":"SUM(J3:J5)","v":0},{"$f":"SUM(K3:K5)","v":0}]

{"sheet":"Strøm","index":2,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,6],[3,14,4,14],[0,7,0,14]]}
[{"$f":"'Ny data'!A5&\"forbrug\"","v":"Elforbrug"},null,null,null,null,null,null,"Kolonner til egne noter (Her kan du gøre hvad du vil. Overskrifterne er kun til inspiration)"]
["Dato",{"$f":"'Ny data'!P5","v":"kWh"},{"$f":"\"Kr/\" & B2","v":"Kr/kWh"},"Kr","Kr","Forb/dag","Kr./dag","Note",null,"Forventet årligt forbrug",null,"Betalt","Betalt a conto","Periode","Faktisk (ca.) forbrug"]
["2013-01-01",0,0,{"$f":"IFERROR((((B3-B2)*C3)),0)","v":0},{"$f":"IFERROR(((E2+D3)),0)","v":0},{"$f":"IFERROR(((B3-B2)/(A3-A2)),0)","v":0},{"$f":"IFERROR(((D3/(A3-A2))),0)","v":0}]

{"sheet":"Vand","index":3,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,7,0,14]]}
[{"$f":"'Ny data'!A6&\"forbrug\"","v":"Vandforbrug"},null,null,null,null,null,null,"Kolonner til egne noter (Her kan du gøre hvad du vil. Overskrifterne er kun til inspiration)"]
["Dato",{"$f":"'Ny data'!P6","v":"m3"},{"$f":"\"Kr/\" & B2","v":"Kr/m3"},"Kr","Kr","Forb/dag","Kr./dag","Note",null,"Forventet årligt forbrug",null,"Betalt","Betalt a conto","Periode","Faktisk (ca.) forbrug"]
["2013-01-01",0,0,{"$f":"IFERROR((((B3-B2)*C3)),0)","v":0},{"$f":"IFERROR(((E2+D3)),0)","v":0},{"$f":"IFERROR(((B3-B2)/(A3-A2)),0)","v":0},{"$f":"IFERROR(((D3/(A3-A2))),0)","v":0}]

{"sheet":"Gas","index":4,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,7,0,14]]}
[{"$f":"'Ny data'!A7&\"forbrug\"","v":"Gasforbrug"},null,null,null,null,null,null,"Kolonner til egne noter (Her kan du gøre hvad du vil. Overskrifterne er kun til inspiration)"]
["Dato",{"$f":"'Ny data'!P7","v":"m3"},{"$f":"\"Kr/\" & B2","v":"Kr/m3"},"Kr","Kr","Forb/dag","Kr./dag","Note",null,"Forventet årligt forbrug",null,"Betalt","Betalt a conto","Periode","Faktisk (ca.) forbrug"]
["2013-01-01",0,0,{"$f":"IFERROR((((B3-B2)*C3)),0)","v":0},{"$f":"IFERROR(((E2+D3)),0)","v":0},{"$f":"IFERROR(((B3-B2)/(A3-A2)),0)","v":0},{"$f":"IFERROR(((D3/(A3-A2))),0)","v":0}]

{"sheet":"Varmeenhed","index":5,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Gas"]
["Olie"]
["Fjernvarme"]
["El (Benyttes ikke)"]
["Andet"]