{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sammanfattning av utbetalningar","Utbetalningslogg"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Sammanfattning av utbetalningar","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"Sammanfattning av utbetalningar",null,null,"Ändra kategorinamnen i tabellen Sammanfattning av utbetalningar och anpassa mallen så den uppfyller dina behov. Om du behöver lägga till ytterligare kategorier kopierar du den sista kolumnen i tabellen och klistrar in den till höger om den kopierade kolumnen. När du ändrar kategorinamnet uppdateras formlerna automatiskt. Se till att den här tabellen har samma antal rader som kalkylbladet Utbetalningslogg."]
[null,"Datum","Bilförsäkring","Kontorsmaterial","Elektricitet","Amortering","Telefon","Tom 1","Tom 2","Tom 3","Tom 4"]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A1),1),\"\")","v":"2018-04-06"},{"$f":"IFERROR(INDIRECT(\"Register[@Belopp]\")*(INDIRECT(\"Register[@Kategori]\")=Kategorinamn),\"\")","v":0},0,0,{"v":1200,"d":"1,200.00 kr"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A2),1),\"\")","v":"2018-04-11"},0,0,{"v":85,"d":"85.00 kr"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A3),1),\"\")","v":"2018-04-16"},{"v":100,"d":"100.00 kr"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A4),1),\"\")","v":"2018-04-21"},0,0,0,{"v":1200,"d":"1,200.00 kr"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A5),1),\"\")","v":"2018-04-26"},0,0,0,{"v":99,"d":"99.00 kr"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A6),1),\"\")","v":"2018-05-01"},0,0,0,0,{"v":68,"d":"68.00 kr"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A7),1),\"\")","v":"2018-05-06"},{"v":100,"d":"100.00 kr"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A8),1),\"\")","v":"2018-05-11"},0,{"v":345,"d":"345.00 kr"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A9),1),\"\")","v":"2018-05-16"},0,0,0,{"v":1200,"d":"1,200.00 kr"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A10),1),\"\")","v":"2018-05-21"},0,0,{"v":74,"d":"74.00 kr"},0,0,0,0,0,{"$f":"IFERROR(INDIRECT(\"Register[@Belopp]\")*(INDIRECT(\"Register[@Kategori]\")=Kategorinamn),\"\")","v":0}]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A11),1),\"\")","v":"2018-05-26"},0,0,0,0,{"v":123,"d":"123.00 kr"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A12),1),\"\")","v":"2018-05-31"},0,{"v":99,"d":"99.00 kr"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A13),1),\"\")","v":"2018-06-05"},{"v":100,"d":"100.00 kr"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A14),1),\"\")","v":"2018-06-10"},0,0,0,{"v":1200,"d":"1,200.00 kr"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A15),1),\"\")","v":"2018-06-15"},0,{"v":128,"d":"128.00 kr"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,SammanfattningUtbetalningar[Bilförsäkring])","v":{"v":300,"d":"300.00 kr"}},{"$f":"SUBTOTAL(109,SammanfattningUtbetalningar[Kontorsmaterial])","v":{"v":572,"d":"572.00 kr"}},{"$f":"SUBTOTAL(109,SammanfattningUtbetalningar[Elektricitet])","v":{"v":159,"d":"159.00 kr"}},{"$f":"SUBTOTAL(109,SammanfattningUtbetalningar[Amortering])","v":{"v":4899,"d":"4,899.00 kr"}},{"$f":"SUBTOTAL(109,SammanfattningUtbetalningar[Telefon])","v":{"v":191,"d":"191.00 kr"}},{"$f":"SUBTOTAL(109,SammanfattningUtbetalningar[Tom 1])","v":0},{"$f":"SUBTOTAL(109,SammanfattningUtbetalningar[Tom 2])","v":0},{"$f":"SUBTOTAL(109,SammanfattningUtbetalningar[Tom 3])","v":0},{"$f":"SUBTOTAL(109,SammanfattningUtbetalningar[Tom 4])","v":0}]

{"sheet":"Utbetalningslogg","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"Utbetalningslogg"]
[null,"Datum","Siffra","Beskrivning","Kategori","Belopp"]
[null,{"$f":"TODAY()-70","v":"2018-04-06"},"100","Banken","Amortering",{"v":1200,"d":"1,200.00 kr"}]
[null,{"$f":"TODAY()-65","v":"2018-04-11"},101,"Elbolaget","Elektricitet",{"v":85,"d":"85.00 kr"}]
[null,{"$f":"TODAY()-60","v":"2018-04-16"},102,"Humongous Insurance","Bilförsäkring",{"v":100,"d":"100.00 kr"}]
[null,{"$f":"TODAY()-55","v":"2018-04-21"},103,"Banken","Amortering",{"v":1200,"d":"1,200.00 kr"}]
[null,{"$f":"TODAY()-50","v":"2018-04-26"},104,"Elbolaget","Amortering",{"v":99,"d":"99.00 kr"}]
[null,{"$f":"TODAY()-45","v":"2018-05-01"},105,"Telefonbolaget","Telefon",{"v":68,"d":"68.00 kr"}]
[null,{"$f":"TODAY()-40","v":"2018-05-06"},106,"Humongous Insurance","Bilförsäkring",{"v":100,"d":"100.00 kr"}]
[null,{"$f":"TODAY()-35","v":"2018-05-11"},107,"Litware, Inc.","Kontorsmaterial",{"v":345,"d":"345.00 kr"}]
[null,{"$f":"TODAY()-30","v":"2018-05-16"},110,"Banken","Amortering",{"v":1200,"d":"1,200.00 kr"}]
[null,{"$f":"TODAY()-25","v":"2018-05-21"},111,"Elbolaget","Elektricitet",{"v":74,"d":"74.00 kr"}]
[null,{"$f":"TODAY()-20","v":"2018-05-26"},108,"Telefonbolaget","Telefon",{"v":123,"d":"123.00 kr"}]
[null,{"$f":"TODAY()-15","v":"2018-05-31"},109,"Litware, Inc.","Kontorsmaterial",{"v":99,"d":"99.00 kr"}]
[null,{"$f":"TODAY()-10","v":"2018-06-05"},112,"Humongous Insurance","Bilförsäkring",{"v":100,"d":"100.00 kr"}]
[null,{"$f":"TODAY()-5","v":"2018-06-10"},113,"Banken","Amortering",{"v":1200,"d":"1,200.00 kr"}]
[null,{"$f":"TODAY()","v":"2018-06-15"},114,"Litware, Inc.","Kontorsmaterial",{"v":128,"d":"128.00 kr"}]
[null,"Totalsummor",{"$nulls":3},{"$f":"SUBTOTAL(109,Register[Belopp])","v":{"v":6121,"d":"6,121.00 kr"}}]