{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Maksusuoritusten yhteenveto","Maksusuorituspäivyri"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Maksusuoritusten yhteenveto","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"Maksusuoritusten yhteenveto",null,null,"Voit mukauttaa tätä mallia tarpeidesi mukaan muokkaamalla luokkien nimiä Maksusuoritusten yhteenveto -taulukossa alla. Jos haluat lisätä uuden luokan, kopioi taulukon viimeinen sarake ja liitä se kopioidun sarakkeen oikealle puolelle. Kun muutat luokan nimeä, kaavat päivitetään automaattisesti. Varmista, että tässä taulukossa on sama määrä rivejä kuin Maksusuorituspäivyri-laskentataulukossa."]
[null,"Päivämäärä","Autovakuutus","Toimistotarvikkeet","Sähkö","Asuntolaina","Puhelin","Tyhjä 1","Tyhjä 2","Tyhjä 3","Tyhjä 4"]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A1),1),\"\")","v":"2018-04-05"},{"$f":"IFERROR(INDIRECT(\"Rekisteri[@Summa]\")*(INDIRECT(\"Rekisteri[@Luokka]\")=Luokan_nimi),\"\")","v":0},0,0,{"v":1200,"d":"1,200.00 €"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A2),1),\"\")","v":"2018-04-10"},0,0,{"v":85,"d":"85.00 €"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A3),1),\"\")","v":"2018-04-15"},{"v":100,"d":"100.00 €"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A4),1),\"\")","v":"2018-04-20"},0,0,0,{"v":1200,"d":"1,200.00 €"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A5),1),\"\")","v":"2018-04-25"},0,0,0,{"v":99,"d":"99.00 €"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A6),1),\"\")","v":"2018-04-30"},0,0,0,0,{"v":68,"d":"68.00 €"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A7),1),\"\")","v":"2018-05-05"},{"v":100,"d":"100.00 €"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A8),1),\"\")","v":"2018-05-10"},0,{"v":345,"d":"345.00 €"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A9),1),\"\")","v":"2018-05-15"},0,0,0,{"v":1200,"d":"1,200.00 €"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A10),1),\"\")","v":"2018-05-20"},0,0,{"v":74,"d":"74.00 €"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A11),1),\"\")","v":"2018-05-25"},0,0,0,0,{"v":123,"d":"123.00 €"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A12),1),\"\")","v":"2018-05-30"},0,{"v":99,"d":"99.00 €"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A13),1),\"\")","v":"2018-06-04"},{"v":100,"d":"100.00 €"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A14),1),\"\")","v":"2018-06-09"},0,0,0,{"v":1200,"d":"1,200.00 €"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Rekisteri[],ROW(A15),1),\"\")","v":"2018-06-14"},0,{"v":128,"d":"128.00 €"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,Maksusuoritusten_yhteenveto[Autovakuutus])","v":{"v":300,"d":"300.00 €"}},{"$f":"SUBTOTAL(109,Maksusuoritusten_yhteenveto[Toimistotarvikkeet])","v":{"v":572,"d":"572.00 €"}},{"$f":"SUBTOTAL(109,Maksusuoritusten_yhteenveto[Sähkö])","v":{"v":159,"d":"159.00 €"}},{"$f":"SUBTOTAL(109,Maksusuoritusten_yhteenveto[Asuntolaina])","v":{"v":4899,"d":"4,899.00 €"}},{"$f":"SUBTOTAL(109,Maksusuoritusten_yhteenveto[Puhelin])","v":{"v":191,"d":"191.00 €"}},{"$f":"SUBTOTAL(109,Maksusuoritusten_yhteenveto[Tyhjä 1])","v":0},{"$f":"SUBTOTAL(109,Maksusuoritusten_yhteenveto[Tyhjä 2])","v":0},{"$f":"SUBTOTAL(109,Maksusuoritusten_yhteenveto[Tyhjä 3])","v":0},{"$f":"SUBTOTAL(109,Maksusuoritusten_yhteenveto[Tyhjä 4])","v":0}]

{"sheet":"Maksusuorituspäivyri","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"Maksusuorituspäivyri"]
[null,"Päivämäärä","Numero","Kuvaus","Luokka","Summa"]
[null,{"$f":"TODAY()-70","v":"2018-04-05"},"100","Woodgrove Bank","Asuntolaina",{"v":1200,"d":"1,200.00 €"}]
[null,{"$f":"TODAY()-65","v":"2018-04-10"},101,"City Power & Light","Sähkö",{"v":85,"d":"85.00 €"}]
[null,{"$f":"TODAY()-60","v":"2018-04-15"},102,"Humongous Insurance","Autovakuutus",{"v":100,"d":"100.00 €"}]
[null,{"$f":"TODAY()-55","v":"2018-04-20"},103,"Woodgrove Bank","Asuntolaina",{"v":1200,"d":"1,200.00 €"}]
[null,{"$f":"TODAY()-50","v":"2018-04-25"},104,"City Power & Light","Asuntolaina",{"v":99,"d":"99.00 €"}]
[null,{"$f":"TODAY()-45","v":"2018-04-30"},105,"The Phone Company","Puhelin",{"v":68,"d":"68.00 €"}]
[null,{"$f":"TODAY()-40","v":"2018-05-05"},106,"Humongous Insurance","Autovakuutus",{"v":100,"d":"100.00 €"}]
[null,{"$f":"TODAY()-35","v":"2018-05-10"},107,"Litware, Inc.","Toimistotarvikkeet",{"v":345,"d":"345.00 €"}]
[null,{"$f":"TODAY()-30","v":"2018-05-15"},110,"Woodgrove Bank","Asuntolaina",{"v":1200,"d":"1,200.00 €"}]
[null,{"$f":"TODAY()-25","v":"2018-05-20"},111,"City Power & Light","Sähkö",{"v":74,"d":"74.00 €"}]
[null,{"$f":"TODAY()-20","v":"2018-05-25"},108,"The Phone Company","Puhelin",{"v":123,"d":"123.00 €"}]
[null,{"$f":"TODAY()-15","v":"2018-05-30"},109,"Litware, Inc.","Toimistotarvikkeet",{"v":99,"d":"99.00 €"}]
[null,{"$f":"TODAY()-10","v":"2018-06-04"},112,"Humongous Insurance","Autovakuutus",{"v":100,"d":"100.00 €"}]
[null,{"$f":"TODAY()-5","v":"2018-06-09"},113,"Woodgrove Bank","Asuntolaina",{"v":1200,"d":"1,200.00 €"}]
[null,{"$f":"TODAY()","v":"2018-06-14"},114,"Litware, Inc.","Toimistotarvikkeet",{"v":128,"d":"128.00 €"}]
[null,"Summat",{"$nulls":3},{"$f":"SUBTOTAL(109,Rekisteri[Summa])","v":{"v":6121,"d":"6,121.00 €"}}]