{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Utbetalingssammendrag","Utbetalingsjournal"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Utbetalingssammendrag","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"Utbetalingssammendrag",null,null,"Du kan endre kategorinavnene i overskriftene til tabellen Utbetalingssammendrag nedenfor for å tilpasse den til dine egne behov. Hvis du trenger å legge til flere kategorier, kopierer du den siste kolonnen i tabellen og limer den inn til høyre for den kopierte kolonnen. Når du endrer navnet på kategorien oppdateres formlene automatisk. Pass på at denne tabellen har samme antall rader som regnearket Utbetalingsjournal."]
[null,"Dato","Bilforsikring","Kontorutstyr","Elektrisitet","Boliglån","Telefon","Tom 1","Tom 2","Tom 3","Tom 4"]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A1),1),\"\")","v":"2018-04-05"},{"$f":"IFERROR(INDIRECT(\"Register[@Beløp]\")*(INDIRECT(\"Register[@Kategori]\")=Kategorinavn),\"\")","v":0},0,0,{"v":1200,"d":"kr 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A2),1),\"\")","v":"2018-04-10"},0,0,{"v":85,"d":"kr 85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A3),1),\"\")","v":"2018-04-15"},{"v":100,"d":"kr 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A4),1),\"\")","v":"2018-04-20"},0,0,0,{"v":1200,"d":"kr 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A5),1),\"\")","v":"2018-04-25"},0,0,0,{"v":99,"d":"kr 99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A6),1),\"\")","v":"2018-04-30"},0,0,0,0,{"v":68,"d":"kr 68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A7),1),\"\")","v":"2018-05-05"},{"v":100,"d":"kr 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A8),1),\"\")","v":"2018-05-10"},0,{"v":345,"d":"kr 345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A9),1),\"\")","v":"2018-05-15"},0,0,0,{"v":1200,"d":"kr 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A10),1),\"\")","v":"2018-05-20"},0,0,{"v":74,"d":"kr 74.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A11),1),\"\")","v":"2018-05-25"},0,0,0,0,{"v":123,"d":"kr 123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A12),1),\"\")","v":"2018-05-30"},0,{"v":99,"d":"kr 99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A13),1),\"\")","v":"2018-06-04"},{"v":100,"d":"kr 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A14),1),\"\")","v":"2018-06-09"},0,0,0,{"v":1200,"d":"kr 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A15),1),\"\")","v":"2018-06-14"},0,{"v":128,"d":"kr 128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,Utbetalingssammendrag[Bilforsikring])","v":{"v":300,"d":"kr 300.00"}},{"$f":"SUBTOTAL(109,Utbetalingssammendrag[Kontorutstyr])","v":{"v":572,"d":"kr 572.00"}},{"$f":"SUBTOTAL(109,Utbetalingssammendrag[Elektrisitet])","v":{"v":159,"d":"kr 159.00"}},{"$f":"SUBTOTAL(109,Utbetalingssammendrag[Boliglån])","v":{"v":4899,"d":"kr 4,899.00"}},{"$f":"SUBTOTAL(109,Utbetalingssammendrag[Telefon])","v":{"v":191,"d":"kr 191.00"}},{"$f":"SUBTOTAL(109,Utbetalingssammendrag[Tom 1])","v":0},{"$f":"SUBTOTAL(109,Utbetalingssammendrag[Tom 2])","v":0},{"$f":"SUBTOTAL(109,Utbetalingssammendrag[Tom 3])","v":0},{"$f":"SUBTOTAL(109,Utbetalingssammendrag[Tom 4])","v":0}]

{"sheet":"Utbetalingsjournal","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"Utbetalingsjournal"]
[null,"Dato","Antall","Beskrivelse","Kategori","Beløp"]
[null,{"$f":"TODAY()-70","v":"2018-04-05"},"100","Woodgrove Bank","Boliglån",{"v":1200,"d":"kr 1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-10"},101,"Offentlige utgifter","Elektrisitet",{"v":85,"d":"kr 85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-15"},102,"Humongous Insurance","Bilforsikring",{"v":100,"d":"kr 100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-20"},103,"Woodgrove Bank","Boliglån",{"v":1200,"d":"kr 1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-25"},104,"Offentlige utgifter","Boliglån",{"v":99,"d":"kr 99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-04-30"},105,"The Phone Company","Telefon",{"v":68,"d":"kr 68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-05"},106,"Humongous Insurance","Bilforsikring",{"v":100,"d":"kr 100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-10"},107,"Litware, Inc.","Kontorutstyr",{"v":345,"d":"kr 345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-15"},110,"Woodgrove Bank","Boliglån",{"v":1200,"d":"kr 1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-20"},111,"Offentlige utgifter","Elektrisitet",{"v":74,"d":"kr 74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-25"},108,"The Phone Company","Telefon",{"v":123,"d":"kr 123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-30"},109,"Litware, Inc.","Kontorutstyr",{"v":99,"d":"kr 99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-04"},112,"Humongous Insurance","Bilforsikring",{"v":100,"d":"kr 100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-09"},113,"Woodgrove Bank","Boliglån",{"v":1200,"d":"kr 1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-14"},114,"Litware, Inc.","Kontorutstyr",{"v":128,"d":"kr 128.00"}]
[null,"Totaler",{"$nulls":3},{"$f":"SUBTOTAL(109,Register[Beløp])","v":{"v":6121,"d":"kr 6,121.00"}}]