{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Izdevumu kopsavilkums","Izdevumu žurnāls"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Izdevumu kopsavilkums","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"Izdevumu kopsavilkums",null,null,"Tabulas Izdevumu kopsavilkums galvenē modificējiet kategorijas nosaukumu, lai pielāgotu šo veidni savām vajadzībām. Ja vēlaties pievienot papildu kategorijas, kopējiet tabulas pēdējo kolonnas un ielīmējiet to pa labi no kopētās kolonnas. Ja mainīsit kategorijas nosaukumu, formulas tiks automātiski atjauninātas. Pārliecinieties, vai šajā tabulā ir tikpat daudz rindu kā darblapā Izdevumu žurnāls."]
[null,"Datums","Auto apdrošināšana","Biroja piederumi","Elektrība","Hipotekārais kredīts","Tālrunis","Tukšs 1","Tukšs 2","Tukšs 3","Tukšs 4"]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A1),1),\"\")","v":"2018-04-05"},{"$f":"IFERROR(INDIRECT(\"Žurnāls[@Summa]\")*(INDIRECT(\"Žurnāls[@Kategorija]\")=Kategorijas_nosaukums),\"\")","v":0},0,0,{"v":1200,"d":"1,200.00 EUR"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A2),1),\"\")","v":"2018-04-10"},0,0,{"v":85,"d":"85.00 EUR"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A3),1),\"\")","v":"2018-04-15"},{"v":100,"d":"100.00 EUR"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A4),1),\"\")","v":"2018-04-20"},0,0,0,{"v":1200,"d":"1,200.00 EUR"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A5),1),\"\")","v":"2018-04-25"},0,0,0,{"v":99,"d":"99.00 EUR"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A6),1),\"\")","v":"2018-04-30"},0,0,0,0,{"v":68,"d":"68.00 EUR"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A7),1),\"\")","v":"2018-05-05"},{"v":100,"d":"100.00 EUR"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A8),1),\"\")","v":"2018-05-10"},0,{"v":345,"d":"345.00 EUR"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A9),1),\"\")","v":"2018-05-15"},0,0,0,{"v":1200,"d":"1,200.00 EUR"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A10),1),\"\")","v":"2018-05-20"},0,0,{"v":74,"d":"74.00 EUR"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A11),1),\"\")","v":"2018-05-25"},0,0,0,0,{"v":123,"d":"123.00 EUR"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A12),1),\"\")","v":"2018-05-30"},0,{"v":99,"d":"99.00 EUR"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A13),1),\"\")","v":"2018-06-04"},{"v":100,"d":"100.00 EUR"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A14),1),\"\")","v":"2018-06-09"},0,0,0,{"v":1200,"d":"1,200.00 EUR"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Žurnāls[],ROW(A15),1),\"\")","v":"2018-06-14"},0,{"v":128,"d":"128.00 EUR"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Auto apdrošināšana])","v":{"v":300,"d":"300.00 EUR"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Biroja piederumi])","v":{"v":572,"d":"572.00 EUR"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Elektrība])","v":{"v":159,"d":"159.00 EUR"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Hipotekārais kredīts])","v":{"v":4899,"d":"4,899.00 EUR"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Tālrunis])","v":{"v":191,"d":"191.00 EUR"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Tukšs 1])","v":0},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Tukšs 2])","v":0},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Tukšs 3])","v":0},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Tukšs 4])","v":0}]

{"sheet":"Izdevumu žurnāls","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"Izdevumu žurnāls"]
[null,"Datums","Numurs","Apraksts","Kategorija","Summa"]
[null,{"$f":"TODAY()-70","v":"2018-04-05"},"100","Woodgrove Bank","Hipotekārais kredīts",{"v":1200,"d":"1,200.00 EUR"}]
[null,{"$f":"TODAY()-65","v":"2018-04-10"},101,"City Power & Light","Elektrība",{"v":85,"d":"85.00 EUR"}]
[null,{"$f":"TODAY()-60","v":"2018-04-15"},102,"Humongous Insurance","Auto apdrošināšana",{"v":100,"d":"100.00 EUR"}]
[null,{"$f":"TODAY()-55","v":"2018-04-20"},103,"Woodgrove Bank","Hipotekārais kredīts",{"v":1200,"d":"1,200.00 EUR"}]
[null,{"$f":"TODAY()-50","v":"2018-04-25"},104,"City Power & Light","Hipotekārais kredīts",{"v":99,"d":"99.00 EUR"}]
[null,{"$f":"TODAY()-45","v":"2018-04-30"},105,"The Phone Company","Tālrunis",{"v":68,"d":"68.00 EUR"}]
[null,{"$f":"TODAY()-40","v":"2018-05-05"},106,"Humongous Insurance","Auto apdrošināšana",{"v":100,"d":"100.00 EUR"}]
[null,{"$f":"TODAY()-35","v":"2018-05-10"},107,"Litware, Inc.","Biroja piederumi",{"v":345,"d":"345.00 EUR"}]
[null,{"$f":"TODAY()-30","v":"2018-05-15"},110,"Woodgrove Bank","Hipotekārais kredīts",{"v":1200,"d":"1,200.00 EUR"}]
[null,{"$f":"TODAY()-25","v":"2018-05-20"},111,"City Power & Light","Elektrība",{"v":74,"d":"74.00 EUR"}]
[null,{"$f":"TODAY()-20","v":"2018-05-25"},108,"The Phone Company","Tālrunis",{"v":123,"d":"123.00 EUR"}]
[null,{"$f":"TODAY()-15","v":"2018-05-30"},109,"Litware, Inc.","Biroja piederumi",{"v":99,"d":"99.00 EUR"}]
[null,{"$f":"TODAY()-10","v":"2018-06-04"},112,"Humongous Insurance","Auto apdrošināšana",{"v":100,"d":"100.00 EUR"}]
[null,{"$f":"TODAY()-5","v":"2018-06-09"},113,"Woodgrove Bank","Hipotekārais kredīts",{"v":1200,"d":"1,200.00 EUR"}]
[null,{"$f":"TODAY()","v":"2018-06-14"},114,"Litware, Inc.","Biroja piederumi",{"v":128,"d":"128.00 EUR"}]
[null,"Kopā",{"$nulls":3},{"$f":"SUBTOTAL(109,Žurnāls[Summa])","v":{"v":6121,"d":"6,121.00 EUR"}}]