{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Oversigt over udbetalinger","Journal over udbetalinger"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Oversigt over udbetalinger","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"Oversigt over udbetalinger",null,null,"Rediger kategorinavnene i overskriften af tabellen Oversigt over udbetalinger nedenfor for at tilpasse denne skabelon, så den passer til dine behov. Hvis du har brug for at tilføje flere kategorier, skal du kopiere den sidste tabelkolonne og indsætte den til højre for den kopierede kolonne. Når du ændrer kategorinavnet, opdateres formlerne automatisk. Sørg for, at tabellen har samme antal rækker som i regnearket Journal over udbetalinger."]
[null,"Dato","Bilforsikring","Kontorforsyninger","El","Boliglån","Telefon","Tom 1","Tom 2","Tom 3","Tom 4"]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A1),1),\"\")","v":"2018-04-04"},{"$f":"IFERROR(INDIRECT(\"Regnskab[@Beløb]\")*(INDIRECT(\"Regnskab[@Kategori]\")=Kategorinavn),\"\")","v":0},0,0,{"v":1200,"d":"kr. 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A2),1),\"\")","v":"2018-04-09"},0,0,{"v":85,"d":"kr. 85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A3),1),\"\")","v":"2018-04-14"},{"v":100,"d":"kr. 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A4),1),\"\")","v":"2018-04-19"},0,0,0,{"v":1200,"d":"kr. 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A5),1),\"\")","v":"2018-04-24"},0,0,0,{"v":99,"d":"kr. 99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A6),1),\"\")","v":"2018-04-29"},0,0,0,0,{"v":68,"d":"kr. 68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A7),1),\"\")","v":"2018-05-04"},{"v":100,"d":"kr. 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A8),1),\"\")","v":"2018-05-09"},0,{"v":345,"d":"kr. 345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A9),1),\"\")","v":"2018-05-14"},0,0,0,{"v":1200,"d":"kr. 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A10),1),\"\")","v":"2018-05-19"},0,0,{"v":74,"d":"kr. 74.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A11),1),\"\")","v":"2018-05-24"},0,0,0,0,{"v":123,"d":"kr. 123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A12),1),\"\")","v":"2018-05-29"},0,{"v":99,"d":"kr. 99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A13),1),\"\")","v":"2018-06-03"},{"v":100,"d":"kr. 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A14),1),\"\")","v":"2018-06-08"},0,0,0,{"v":1200,"d":"kr. 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Regnskab[],ROW(A15),1),\"\")","v":"2018-06-13"},0,{"v":128,"d":"kr. 128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,Udbetalingsoversigt[Bilforsikring])","v":{"v":300,"d":"kr. 300.00"}},{"$f":"SUBTOTAL(109,Udbetalingsoversigt[Kontorforsyninger])","v":{"v":572,"d":"kr. 572.00"}},{"$f":"SUBTOTAL(109,Udbetalingsoversigt[El])","v":{"v":159,"d":"kr. 159.00"}},{"$f":"SUBTOTAL(109,Udbetalingsoversigt[Boliglån])","v":{"v":4899,"d":"kr. 4,899.00"}},{"$f":"SUBTOTAL(109,Udbetalingsoversigt[Telefon])","v":{"v":191,"d":"kr. 191.00"}},{"$f":"SUBTOTAL(109,Udbetalingsoversigt[Tom 1])","v":0},{"$f":"SUBTOTAL(109,Udbetalingsoversigt[Tom 2])","v":0},{"$f":"SUBTOTAL(109,Udbetalingsoversigt[Tom 3])","v":0},{"$f":"SUBTOTAL(109,Udbetalingsoversigt[Tom 4])","v":0}]

{"sheet":"Journal over udbetalinger","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"Journal over udbetalinger"]
[null,"Dato","Nummer","Beskrivelse","Kategori","Beløb"]
[null,{"$f":"TODAY()-70","v":"2018-04-04"},"100","Woodgrove Bank","Boliglån",{"v":1200,"d":"kr. 1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-09"},101,"City Power & Light","El",{"v":85,"d":"kr. 85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-14"},102,"Humongous Insurance","Bilforsikring",{"v":100,"d":"kr. 100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-19"},103,"Woodgrove Bank","Boliglån",{"v":1200,"d":"kr. 1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-24"},104,"City Power & Light","Boliglån",{"v":99,"d":"kr. 99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-04-29"},105,"Telefonselskab","Telefon",{"v":68,"d":"kr. 68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-04"},106,"Humongous Insurance","Bilforsikring",{"v":100,"d":"kr. 100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-09"},107,"Litware, Inc.","Kontorforsyninger",{"v":345,"d":"kr. 345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-14"},110,"Woodgrove Bank","Boliglån",{"v":1200,"d":"kr. 1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-19"},111,"City Power & Light","El",{"v":74,"d":"kr. 74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-24"},108,"Telefonselskab","Telefon",{"v":123,"d":"kr. 123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-29"},109,"Litware, Inc.","Kontorforsyninger",{"v":99,"d":"kr. 99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-03"},112,"Humongous Insurance","Bilforsikring",{"v":100,"d":"kr. 100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-08"},113,"Woodgrove Bank","Boliglån",{"v":1200,"d":"kr. 1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-13"},114,"Litware, Inc.","Kontorforsyninger",{"v":128,"d":"kr. 128.00"}]
[null,"Samlede beløb",{"$nulls":3},{"$f":"SUBTOTAL(109,Regnskab[Beløb])","v":{"v":6121,"d":"kr. 6,121.00"}}]