{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Arve","Kliendid","Arved – peamine","Arve üksikasjad","Arvete ülevaate teave"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Arve","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"merged":[[1,1,1,2],[1,3,1,4],[1,5,1,6],[2,1,2,2],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,3,4,4],[5,3,5,4],[37,1,37,4],[38,1,38,4]]}
[null,"Ettevõtte nimi"]
[null,"Tänav, maja",null,"T: telefoninumber",null,"Meiliaadress"]
[null,"Linn, maakond, sihtnumber",null,"F: faksinumber",null,"Veebisait"]
[null,"Arve saaja:",{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngArve,ArvedPeamine[],2,FALSE),KliendiLoend[],3,TRUE),\"\")","v":"AS Vetevalla"},{"$f":"\"Telefon: \"&IFERROR(VLOOKUP(VLOOKUP(rngArve,ArvedPeamine[],2,FALSE),KliendiLoend[],9,FALSE),\"\")","v":"Telefon: 3722222222"},null,"Arve nr:","3-456-2"]
[null,"Aadress:",{"$f":"IFERROR(IF((VLOOKUP(VLOOKUP(rngArve,ArvedPeamine[],2,FALSE),KliendiLoend[],5,FALSE))=\"\",\"\",(VLOOKUP(VLOOKUP(rngArve,ArvedPeamine[],2,FALSE),KliendiLoend[],5,FALSE))),\"\")","v":"Kiigepuu tee 1"},{"$f":"\"Faks:     \"&IFERROR(VLOOKUP(VLOOKUP(rngArve,ArvedPeamine[],2,FALSE),KliendiLoend[],11,FALSE),\"\")","v":"Faks:     3724444444"},null,"Arve kuupäev:",{"$f":"IFERROR(IF(VLOOKUP(rngArve,ArvedPeamine[],3,FALSE)=\"\",\"\",VLOOKUP(rngArve,ArvedPeamine[],3,FALSE)),\"\")","v":"2019-08-11"}]
[null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngArve,ArvedPeamine[],2,FALSE),KliendiLoend[],6,FALSE)&\", \"& VLOOKUP(VLOOKUP(G4,ArvedPeamine[],2,FALSE),KliendiLoend[],7,FALSE)&\" \"&VLOOKUP(VLOOKUP(G4,ArvedPeamine[],2,FALSE),KliendiLoend[],8,FALSE),\"\")","v":"Pärnu, Pärnumaa 098765"},{"$f":"\"Meiliaadress: \"&IFERROR(VLOOKUP(VLOOKUP(rngArve,ArvedPeamine[],2,FALSE),KliendiLoend[],10,FALSE),\"\")","v":"Meiliaadress: keegi@näidis.com"}]
[null,{"$f":"\"Arve saaja: \"&IFERROR(VLOOKUP(rngArve,ArvedPeamine[],4),\"\")","v":"Arve saaja: Projekt 2"}]
[null,"Üksuse nr","Kirjeldus","Kogus","Ühiku hind","Allahindlus","Hind"]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(1:1)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4567"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(1:1)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 1"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(1:1)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":39},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(1:1)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":5,"d":"5.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(1:1)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":0},{"$f":"IFERROR((D9*E9)-F9,\"\")","v":{"v":195,"d":"195.00 €"}}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(2:2)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4568"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(2:2)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 2"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(2:2)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":40},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(2:2)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":4,"d":"4.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(2:2)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":5,"d":"5.00 €"}},{"v":155,"d":"155.00 €"}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(3:3)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4569"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(3:3)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 3"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(3:3)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":30},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(3:3)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":6,"d":"6.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(3:3)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":7,"d":"7.00 €"}},{"v":173,"d":"173.00 €"}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(4:4)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4570"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(4:4)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 4"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(4:4)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":40},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(4:4)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":7,"d":"7.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(4:4)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":0},{"v":280,"d":"280.00 €"}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(5:5)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4571"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(5:5)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 5"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(5:5)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":10},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(5:5)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":4,"d":"4.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(5:5)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":0},{"v":40,"d":"40.00 €"}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(6:6)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4572"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(6:6)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 6"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(6:6)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":5},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(6:6)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":8,"d":"8.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(6:6)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":0},{"v":40,"d":"40.00 €"}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(7:7)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4573"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(7:7)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 7"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(7:7)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":70},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(7:7)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":6,"d":"6.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(7:7)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":0},{"v":420,"d":"420.00 €"}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(8:8)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4574"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(8:8)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 8"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(8:8)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":25},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(8:8)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":4,"d":"4.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(8:8)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":0},{"v":100,"d":"100.00 €"}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(9:9)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4575"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(9:9)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 9"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(9:9)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":5},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(9:9)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":7,"d":"7.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(9:9)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":3,"d":"3.00 €"}},{"v":32,"d":"32.00 €"}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(10:10)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4576"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(10:10)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 10"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(10:10)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":80},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(10:10)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":1,"d":"1.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(10:10)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":0},{"v":80,"d":"80.00 €"}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(11:11)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4577"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(11:11)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 11"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(11:11)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":65},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(11:11)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":7,"d":"7.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(11:11)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":0},{"v":455,"d":"455.00 €"}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(12:12)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":"Z4578"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(12:12)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":"Arve 3-456-2 andmed 12"},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(12:12)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":44},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(12:12)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":{"v":1,"d":"1.00 €"}},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(12:12)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":0},{"v":44,"d":"44.00 €"}]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(13:13)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(13:13)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(13:13)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(13:13)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(13:13)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(14:14)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(14:14)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(14:14)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(14:14)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(14:14)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(15:15)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(15:15)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(15:15)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(15:15)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(15:15)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(16:16)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(16:16)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(16:16)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(16:16)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(16:16)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(17:17)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(17:17)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(17:17)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(17:17)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(17:17)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(18:18)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(18:18)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(18:18)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(18:18)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(18:18)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(19:19)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(19:19)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(19:19)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(19:19)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(19:19)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(20:20)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(20:20)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(20:20)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(20:20)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(20:20)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(21:21)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(21:21)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(21:21)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(21:21)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(21:21)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(22:22)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(22:22)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(22:22)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(22:22)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(22:22)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(23:23)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(23:23)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(23:23)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(23:23)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(23:23)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(24:24)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(24:24)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(24:24)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(24:24)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(24:24)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(25:25)), MATCH($B$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(25:25)), MATCH($C$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(25:25)), MATCH($D$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(25:25)), MATCH($E$8, Arveandmed[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Arveandmed[],SMALL(IF(Arveandmed[Arve nr]=rngArve,ROW(Arveandmed[])-ROW(Arveandmed[#Headers])), ROW(25:25)), MATCH($F$8, Arveandmed[#Headers], 0)),\"\")","v":""},""]
[{"$nulls":5},"Arve vahesumma",{"$f":"SUM(Projektiarve[Hind])","v":{"v":2014,"d":"2,014.00 €"}}]
[{"$nulls":5},"Maksumäär",{"$f":"VLOOKUP(rngArve,ArvedPeamine[],5)","v":{"v":0.0875,"d":"8.75%"}}]
[{"$nulls":5},"Käibemaks",{"$f":"G34*G35","v":{"v":176.225,"d":"176.23 €"}}]
[{"$nulls":5},"Muu",{"$f":"VLOOKUP(rngArve,ArvedPeamine[],6)","v":0}]
[null,{"$f":"\"Tšeki alusel makstakse raha \"&EttevõtteNimi&\".\"","v":"Tšeki alusel makstakse raha Ettevõtte nimi."},{"$nulls":3},"Saadud ettemaks",{"$f":"VLOOKUP(rngArve,ArvedPeamine[],7)","v":0}]
[null,"Maksetähtaeg <#> päeva. Makse hilinemise korral arvestatakse viivist <#>% kuus.",{"$nulls":3},"KOKKU",{"$f":"(G34+G36+G37)-G38","v":{"v":2190.225,"d":"2,190.23 €"}}]

{"sheet":"Kliendid","index":1,"n_rows":6,"n_cols":12,"rows_kept":6}
[]
[null,null,"Kliendid"]
[null,"Otsing","Ettevõte nr","Ettevõtte nimi","Kontaktisiku nimi","Aadress","Linn","Maakond","Sihtnumber","Telefon","Meiliaadress","Faks"]
[null,{"$f":"C4& \" - \"&D4","v":"1 - AS Meie Vara "},1,"AS Meie Vara ","Allan Pääsuke","Kaldaserva 6","Viljandi","Viljandimaa","123456",3721111111,"keegi@näidis.com",3723333333]
[null,"2 - AS Vetevalla",2,"AS Vetevalla","Markus Kangur","Kiigepuu tee 1","Pärnu","Pärnumaa","098765",3722222222,"keegi@näidis.com",3724444444]
[null,"Kokku",{"$f":"\"Kliente kokku: \"&SUBTOTAL(103,KliendiLoend[Ettevõte nr])","v":"Kliente kokku: 2"}]

{"sheet":"Arved – peamine","index":2,"n_rows":6,"n_cols":11,"rows_kept":6}
[]
[null,"Arved"]
[null,"Arve nr","Ettevõte","Arve kuupäev","Projekti kirjeldus","Maksumäär","Muu","Sissemakse","Üksikasjade kogusumma","Arve kokku","Märkmed"]
[null,"3-456-1","1 - AS Meie Vara ",{"$f":"TODAY()","v":"2019-08-01"},"Projekt 1",{"v":0.0875,"d":"8.75%"},{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"$f":"SUMIF(Arveandmed[Arve nr],\"=\"&ArvedPeamine[[#This Row],[Arve nr]],Arveandmed[Kokku])","v":{"v":5200,"d":"5,200.00 €"}},{"$f":"(ArvedPeamine[[#This Row],[Üksikasjade kogusumma]]*(1+ArvedPeamine[[#This Row],[Maksumäär]]))+ArvedPeamine[[#This Row],[Muu]]-ArvedPeamine[[#This Row],[Sissemakse]]","v":{"v":5654.999999999999,"d":"5,655.00 €"}}]
[null,"3-456-2","2 - AS Vetevalla",{"$f":"TODAY()+10","v":"2019-08-11"},"Projekt 2",{"v":0.0875,"d":"8.75%"},null,null,{"$f":"SUMIF(Arveandmed[Arve nr],\"=\"&ArvedPeamine[[#This Row],[Arve nr]],Arveandmed[Kokku])","v":{"v":2014,"d":"2,014.00 €"}},{"$f":"(ArvedPeamine[[#This Row],[Üksikasjade kogusumma]]*(1+ArvedPeamine[[#This Row],[Maksumäär]]))+ArvedPeamine[[#This Row],[Muu]]-ArvedPeamine[[#This Row],[Sissemakse]]","v":{"v":2190.225,"d":"2,190.23 €"}}]
[null,"Kokku",{"$f":"\"Arvete koguarv: \"&SUBTOTAL(103,ArvedPeamine[Arve nr])","v":"Arvete koguarv: 2"},{"$nulls":3},{"$f":"SUBTOTAL(109,ArvedPeamine[Muu])","v":{"v":100,"d":"100.00 €"}},{"$f":"SUBTOTAL(109,ArvedPeamine[Sissemakse])","v":{"v":100,"d":"100.00 €"}},{"$f":"SUBTOTAL(109,ArvedPeamine[Üksikasjade kogusumma])","v":{"v":7214,"d":"7,214.00 €"}},{"$f":"SUBTOTAL(109,ArvedPeamine[Arve kokku])","v":{"v":7845.2249999999985,"d":"7,845.23 €"}}]

{"sheet":"Arve üksikasjad","index":3,"n_rows":40,"n_cols":8,"rows_kept":40}
[]
[null,"Arve üksikasjad"]
[null,"Kirjeldus","Arve nr","Üksuse nr","Kogus","Ühiku hind","Allahindlus","Kokku"]
[null,"Arve 3-456-1 andmed 1","3-456-1",1,1,{"v":1,"d":"1.00 €"},{"v":1,"d":"1.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Arve 3-456-1 andmed 2","3-456-1",2,2,{"v":2,"d":"2.00 €"},{"v":2,"d":"2.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":2,"d":"2.00 €"}}]
[null,"Arve 3-456-1 andmed 3","3-456-1",3,3,{"v":3,"d":"3.00 €"},{"v":3,"d":"3.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":6,"d":"6.00 €"}}]
[null,"Arve 3-456-1 andmed 4","3-456-1",4,4,{"v":4,"d":"4.00 €"},{"v":4,"d":"4.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":12,"d":"12.00 €"}}]
[null,"Arve 3-456-1 andmed 5","3-456-1",5,5,{"v":5,"d":"5.00 €"},{"v":5,"d":"5.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":20,"d":"20.00 €"}}]
[null,"Arve 3-456-1 andmed 6","3-456-1",6,6,{"v":6,"d":"6.00 €"},{"v":6,"d":"6.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":30,"d":"30.00 €"}}]
[null,"Arve 3-456-1 andmed 7","3-456-1",7,7,{"v":7,"d":"7.00 €"},{"v":7,"d":"7.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":42,"d":"42.00 €"}}]
[null,"Arve 3-456-1 andmed 8","3-456-1",8,8,{"v":8,"d":"8.00 €"},{"v":8,"d":"8.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":56,"d":"56.00 €"}}]
[null,"Arve 3-456-1 andmed 9","3-456-1",9,9,{"v":9,"d":"9.00 €"},{"v":9,"d":"9.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":72,"d":"72.00 €"}}]
[null,"Arve 3-456-1 andmed 10","3-456-1",10,10,{"v":10,"d":"10.00 €"},{"v":10,"d":"10.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":90,"d":"90.00 €"}}]
[null,"Arve 3-456-1 andmed 11","3-456-1",11,11,{"v":11,"d":"11.00 €"},{"v":11,"d":"11.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":110,"d":"110.00 €"}}]
[null,"Arve 3-456-1 andmed 12","3-456-1",12,12,{"v":12,"d":"12.00 €"},{"v":12,"d":"12.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":132,"d":"132.00 €"}}]
[null,"Arve 3-456-1 andmed 13","3-456-1",13,13,{"v":13,"d":"13.00 €"},{"v":13,"d":"13.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":156,"d":"156.00 €"}}]
[null,"Arve 3-456-1 andmed 14","3-456-1",14,14,{"v":14,"d":"14.00 €"},{"v":14,"d":"14.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":182,"d":"182.00 €"}}]
[null,"Arve 3-456-1 andmed 15","3-456-1",15,15,{"v":15,"d":"15.00 €"},{"v":15,"d":"15.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":210,"d":"210.00 €"}}]
[null,"Arve 3-456-1 andmed 16","3-456-1",16,16,{"v":16,"d":"16.00 €"},{"v":16,"d":"16.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":240,"d":"240.00 €"}}]
[null,"Arve 3-456-1 andmed 17","3-456-1",17,17,{"v":17,"d":"17.00 €"},{"v":17,"d":"17.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":272,"d":"272.00 €"}}]
[null,"Arve 3-456-1 andmed 18","3-456-1",18,18,{"v":18,"d":"18.00 €"},{"v":18,"d":"18.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":306,"d":"306.00 €"}}]
[null,"Arve 3-456-1 andmed 19","3-456-1",19,19,{"v":19,"d":"19.00 €"},{"v":19,"d":"19.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":342,"d":"342.00 €"}}]
[null,"Arve 3-456-1 andmed 20","3-456-1",20,20,{"v":20,"d":"20.00 €"},{"v":20,"d":"20.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":380,"d":"380.00 €"}}]
[null,"Arve 3-456-1 andmed 21","3-456-1",21,21,{"v":21,"d":"21.00 €"},{"v":21,"d":"21.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":420,"d":"420.00 €"}}]
[null,"Arve 3-456-1 andmed 22","3-456-1",22,22,{"v":22,"d":"22.00 €"},{"v":22,"d":"22.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":462,"d":"462.00 €"}}]
[null,"Arve 3-456-1 andmed 23","3-456-1",23,23,{"v":23,"d":"23.00 €"},{"v":23,"d":"23.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":506,"d":"506.00 €"}}]
[null,"Arve 3-456-1 andmed 24","3-456-1",24,24,{"v":24,"d":"24.00 €"},{"v":24,"d":"24.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":552,"d":"552.00 €"}}]
[null,"Arve 3-456-1 andmed 25","3-456-1",25,25,{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":600,"d":"600.00 €"}}]
[null,"Arve 3-456-2 andmed 1","3-456-2","Z4567",39,{"v":5,"d":"5.00 €"},null,{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":195,"d":"195.00 €"}}]
[null,"Arve 3-456-2 andmed 2","3-456-2","Z4568",40,{"v":4,"d":"4.00 €"},{"v":5,"d":"5.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":155,"d":"155.00 €"}}]
[null,"Arve 3-456-2 andmed 3","3-456-2","Z4569",30,{"v":6,"d":"6.00 €"},{"v":7,"d":"7.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":173,"d":"173.00 €"}}]
[null,"Arve 3-456-2 andmed 4","3-456-2","Z4570",40,{"v":7,"d":"7.00 €"},null,{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":280,"d":"280.00 €"}}]
[null,"Arve 3-456-2 andmed 5","3-456-2","Z4571",10,{"v":4,"d":"4.00 €"},null,{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":40,"d":"40.00 €"}}]
[null,"Arve 3-456-2 andmed 6","3-456-2","Z4572",5,{"v":8,"d":"8.00 €"},null,{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":40,"d":"40.00 €"}}]
[null,"Arve 3-456-2 andmed 7","3-456-2","Z4573",70,{"v":6,"d":"6.00 €"},null,{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":420,"d":"420.00 €"}}]
[null,"Arve 3-456-2 andmed 8","3-456-2","Z4574",25,{"v":4,"d":"4.00 €"},null,{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":100,"d":"100.00 €"}}]
[null,"Arve 3-456-2 andmed 9","3-456-2","Z4575",5,{"v":7,"d":"7.00 €"},{"v":3,"d":"3.00 €"},{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":32,"d":"32.00 €"}}]
[null,"Arve 3-456-2 andmed 10","3-456-2","Z4576",80,{"v":1,"d":"1.00 €"},null,{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":80,"d":"80.00 €"}}]
[null,"Arve 3-456-2 andmed 11","3-456-2","Z4577",65,{"v":7,"d":"7.00 €"},null,{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":455,"d":"455.00 €"}}]
[null,"Arve 3-456-2 andmed 12","3-456-2","Z4578",44,{"v":1,"d":"1.00 €"},null,{"$f":"(Arveandmed[[#This Row],[Kogus]]*Arveandmed[[#This Row],[Ühiku hind]])-Arveandmed[[#This Row],[Allahindlus]]","v":{"v":44,"d":"44.00 €"}}]

{"sheet":"Arvete ülevaate teave","index":4,"n_rows":40,"n_cols":3,"rows_kept":40,"merged":[[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,2,7,7],[8,2,8,7],[9,2,9,7],[10,2,10,7],[11,2,11,7],[12,1,12,7],[13,2,13,3],[14,2,14,7],[15,1,15,7],[16,2,16,7],[17,2,17,7],[18,2,18,7],[19,2,19,7],[20,2,20,7],[21,2,21,7],[22,1,22,7],[23,1,23,7],[24,2,24,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[28,1,28,7],[29,1,29,7],[30,2,30,7],[31,2,31,7],[32,2,32,7],[33,2,33,7],[34,2,34,7],[36,2,36,7],[37,2,37,7],[38,2,38,7],[39,2,39,7]]}
[null,"Arvete ülevaate teave"]
[]
[]
[null,"Arvete ülevaate eesmärk on säilitada klientide ajalugu, arveid ja arvete andmeid nii, et oleks võimalik talletada korraga mitut arvet, kuid ei peaks selleks looma mitut faili. Samuti saate kasutada arvete jälgijat varem esitatud arvete andmete analüüsimiseks. Näiteks saate vaadata kõiki kliendi või konkreetse projekti arveid või vaadata kõiki arveid viimase kuu, viimase aasta ja muu põhjal."]
[null,"Enne alustamist heitke pilk esitatud näidisandmetele. Valige lehel Arve lahter, mis on lahtrist Arve nr (lahter L8) paremal, ja ilmub ripploend. Valige rippnool ja seejärel valige arve näidis. Pange tähele, kuidas kogu arve teave valitud arve kajastamiseks automaatselt muutub. Nüüd vaadake lehti Kliendid, Arved – peamine ja Arve üksikasjad. Kõik need lehed edastavad arvele teavet ja kõik mis tahes muudatused värskendatakse automaatselt. "]
[null,"Kuidas alustada?"]
[null,"Muutke järgmiseid samme kasutades lehte Arve, et see kajastaks teie ettevõtte teavet."]
[null,"1.","Liikuge lehele Arve ja menüüs Läbivaatus grupis Kaitse valige suvand Võta lehe kaitse maha. "]
[null,null,"Märkus. Tahtmatute muudatuste vältimise abistamiseks on leht Arve kaitstud, kuna nagu eespool mainitud, hangitakse enamik sellel lehel olevaid andmeid töövihiku kõikidelt teistelt lehtedelt. "]
[null,"2.","Kohandage arvee päist, tippides oma ettevõtte nime, tänava, maja, linna, sihtnumbri, meiliaadressi, veebisaidi jne. Muutke arve allosas (rida 43) maksmise juhiseid. "]
[null,null,"NB! Ärge muutke arveldamist ega arve teavet. Kõikides nendes lahtrites on valemid, mis värskendavad arvet automaatselt, nagu jaotises Arvete ülevaate teave mainitud.  "]
[null,"3.","(Valikuline) Muutke värve terves töövihikus. Valige menüüs Küljendus grupis Kujundused suvand Värvid ja valige värvide galeriist muu värviskeem. "]
[null,"Näpunäide. Looge kohandatud kujunduse värviskeem, mis vastab teie ettevõtte sümboolikale. Selleks valige menüüs Küljendus grupis Kujundused suvand Värvid ja seejärel valige suvand Kohanda värve. Lisateavet kohandatud värviskeemi loomise kohta leiate järgmisest spikriteemast. "]
[null,null,"Dokumendi kujunduse kohandamine."]
[null,"4.","Kui olete soovitud muudatused teinud, naaske lehele Arve ja valige menüü Läbivaatus grupis Muutused suvand Lehe kaitsmine ning seejärel valige OK. Kui leht Arve on kaitstud, saate valida ainult lahtri, kus on rippmenüü Arve nr."]
[null,"Kuidas luua arvet?"]
[null,"1.","Sisestage lehel Kliendid kliendi teave, nagu ettevõtte nimi ja aadress. Pange tähele, et ettevõtte nr on oluline kirje, kuna see lisab igale ettevõttele ainuidentifikaatori, mida kasutatakse läbivalt terves arve ülevaates. Samuti pange tähele, et teil on vaja ettevõte lisada üks kord. Sama ettevõtte järgmiste arvete jaoks võib selle sammu vahele jätta. "]
[null,null,"Märkus. Kui määrate sama numbri rohkem kui ühele ettevõttele või sisestate sama ettevõtte nime mitu korda, muutuvad kirjed dubleerimisest teavitamiseks punaseks. "]
[null,"2.","Sisestage lehel Arved – peamine arve põhiandmed, nagu arve nr, arve kuupäev ja projekti kirjeldus. Sarnaselt kirjele Ettevõtte nr on Arve nr oluline kirje, kuna see lisab igale arvele ainuidentifikaatori ja seda kasutatakse läbivalt terves arve ülevaates. Teine oluline kirje on Ettevõte. Kui valite ripploendist ettevõtte, seotakse teie arve selle ettevõttega. Seejärel kui valite lehel Arve suvandi Arve nr, lisatakse ettevõtte teave (nt ettevõtte nimi ja aadress) arvele automaatselt."]
[null,null,"Märkus. Kui määrate sama numbri rohkem kui ühele arvele, muutuvad kirjed dubleerimisest teavitamiseks punaseks. "]
[null,"3.","Sisestage lehel Arve üksikasjad arve üksikasjad, nagu kauba kirjeldus, üksuse nr, kogus ja ühiku hind. Ripploendis Arve nr on loetletud lehel Arved – peamine sisestatud arvete loend, et hõlbustada andmete sisestamist. Sarnaselt eelmises etapis kirjele Ettevõtte nr, seob kirje Arve nr selle üksikasjaliku üksuse konkreetse arvega. Kui valite suvandi Arve nr lehel Arve ripploendist Arve nr, kuvatakse selle arvega seotud arve üksikasjade üksused."]
[null,null,"Märkus. Arvel võib olla 25 üksikasjalikku üksust. Kui lisatud on rohkem kui 25 üksust, muutuvad kõik vastavad kirjed sellest piirangust teavitamiseks punaseks. Kui teil arvele lisada rohkem kui 25 üksust, peate looma teise arve. "]
[null,"Kuidas lisada rohkem kliente, arveid ja arve üksikasju?"]
[null,"Klientide, arvete ja arve üksikasjade andmed on talletatud Exceli tabelites. Kui lisate tabelisse uue rea, vormindatakse äsja lisatud rida automaatselt ja kõik arvutused kopeeritakse. Tabeli uute ridade lisamiseks tehke ühte järgmistest."]
[null,"● ","Kui tabelis pole kokkuvõtterida, alustage tabeli alla tippimist ja tabel laiendatakse sisestusklahvi (Enter) või tabeldusklahvi (Tab) vajutamisel automaatselt."]
[null,"● ","Asetage lahtrikursor viimasesse summarea kohal asuvasse lahtrisse (nt viimase arve tabel Arved lahtris Märkused) ja vajutage tabeldusklahvi (Tab)."]
[null,"● ","Valige menüüs Avaleht grupis Lahtrid suvand Lisa ja seejärel valige Tabeliread üles või Tabelirida alla. "]
[null,"● ","Viige kursor tabeli paremas allnurgas tabeli suuruse muutmise pidemele ja lohistage seda allapoole, et suurendada saadaolevate tabeliridade arvu."]
[null,"Kuidas analüüsida arve üksikasju?"]
[null,"Nagu arve ülevaate jaotises mainitud, saate mitme arve sisestamise järel vaadata kõikide arvete loendit konkreetse kliendi, projekt, määratud kuupäevaintervalli ja palju muu põhjal. Seda tüüpi analüüs saavutatakse filtri abil, mis võimaldab andmete loendit kiiresti piiritleda. Tabelites Kliendid, Arved või Arve üksikasjad asuvale filtrile juurdepääsemiseks valige mis tahes tabeli väljanime kõrval olev rippnool. Kuvatakse paan Filter, kus on mitmed filtreerimisvõimalused. Järgnevalt on alustamiseks toodud mõned filtreerimise näited."]
[null,"● ","Konkreetsele kliendile väljastatud arvete kogusumma kuvamiseks tehke järgmist. Valige lehel Arved – peamine väljast Ettevõtte nr paremal rippnool. Klõpsake paanil Filter nuppu Vali kõik, et valida kõik ettevõtted, valige soovitud ettevõte ja seejärel valige OK. "]
[null,null,"Näpunäide. Paanil Filtreeri saate samuti sisestada kliendi nime tekstiväljale Otsi, et kiiresti saadaolevast loendist otsida."]
[null,"● ","Konkreetse kliendi ja konkreetse(te) projekti(de) kõikide arvete vaatamiseks tehke järgmist. Alustuseks filtreerige eelmises näites toodud sammudega soovitud kliendini. Seejärel valige väljast Projekti nr paremal rippnool. Valige paanil Filter soovitud projekt või projektid ja seejärel valige OK. "]
[null,"● ","Eelmise kuu kõikide arvete kuvamiseks tehke järgmist. Valige lehel Arved – peamine väljast Arve kuupäev paremal asuv rippnool, osutage valikule Kuupäeva filtrid ja seejärel valige Eelmine kuu."]
[null,"● ","Kõigi sama suunakoodiga klientide kuvamiseks tehke järgmist. Valige lehel Kliendid väljast Telefon paremal rippnool. Klõpsake paanil Filter tekstivälja Otsing, sisestage suunakood ja seejärel valige OK. "]
[null,"Filtreerimise näpunäited"]
[null,"● ","Kui tabelil on kokkuvõtterida (nt kliendid ja arved), kajastatakse arvutatud kogusummad ainult filtreeritud loendis."]
[null,"● ","Tulemite viimistlemiseks saate kasutada mitut filtrit ühel väljal või mitme välja üleselt."]
[null,"● ","Ühe filtri eemaldamiseks valige eelnevalt filtreeritud veeru rippnool ja seejärel valige Tühjenda filter väljalt <välja nimi>."]
[null,"● ","Mitme filtri samaaegseks eemaldamiseks asetage lahtrikursor tabelisse, valige menüüs Avaleht grupis Redigeerimine suvand Sordi ja filtreeri ja seejärel valige Tühjenda."]