{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Iesniegums","Darbu tips","Ielu reģistrs","Koefic"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Iesniegums","index":0,"n_rows":67,"n_cols":25,"rows_kept":67,"merged":[[0,0,0,14],[2,0,2,2],[2,3,2,14],[3,0,3,2],[3,3,3,14],[4,0,4,2],[4,3,4,14],[5,0,5,2],[5,3,5,14],[6,0,6,2],[6,3,6,14],[7,0,7,2],[7,3,7,14],[8,0,8,2],[8,3,8,14],[9,0,9,2],[9,3,9,14],[10,0,10,2],[10,3,10,14],[11,0,12,1],[11,3,11,14],[12,3,12,14],[13,0,13,2],[13,3,13,14],[14,0,14,1],[14,3,14,14],[15,0,15,1],[15,3,15,14],[17,1,17,24],[19,0,22,0],[19,1,22,1],[19,2,22,2],[19,3,22,3],[19,4,22,4],[19,5,22,5],[19,6,19,12],[19,16,19,24],[20,6,20,14],[20,15,22,15],[20,16,20,24],[21,6,21,8],[21,9,21,12],[21,16,21,18],[21,19,21,22],[30,0,30,5],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[45,0,45,1],[45,2,45,4],[46,0,46,1],[46,2,46,4],[46,10,46,14],[47,0,47,1],[47,2,47,4],[48,0,48,1],[48,2,48,4],[48,10,48,14],[49,0,49,4],[52,0,52,16],[55,0,55,1],[56,0,56,1],[58,0,58,1],[59,0,59,1],[61,0,61,14],[62,0,62,14],[63,0,63,14],[64,0,64,14],[66,0,66,14]]}
["IESNIEGUMS par ielas aizņemšanu"]
[]
["Darbu veicējs"]
["juridiskās personas nosaukums/vārds, uzvārds"]
["vienotais reģistrācijas Nr./personas kods"]
["PVN maksātāja Nr."]
["bankas nosaukums"]
["bankas konta Nr."]
["juridiskā adrese/deklarētā adrese"]
["kontakttālrunis"]
["e-pasts"]
["Līguma paraksttiesīgā persona",null,"vārds, uzvārds"]
[null,null,"amats"]
["Darbu pasūtītājs "]
["Fiziska persona\nJuridiska persona",null,"vārds, uzvārds\nnosaukums"]
["Fiziska persona\nJuridiska persona",null,"personas kods1\nvienotais reģistrācijas Nr., juridiskā adrese"]
[]
[null,"Veicamo darbu apjoms pašvaldības īpašumā"]
[]
["Nr.p.k.","Darbu veikšanas iela","Precizējums \n(posma nosaukums, ielas adrese u.c.)","DARBU VEIDS","Veicamie darbi","Veicamo darbu raksturs","SARKANO LĪNIJU ROBEŽĀS",{"$nulls":9},"ĀRPUS SARKANAJĀM LĪNIJĀM"]
[{"$nulls":6}," IELAS ELEMENTA SEGUMS, PLATĪBA  (m2) ",{"$nulls":8},"KOPĀ (bez PVN)","SEGUMS, PLATĪBA  (m2) "]
[{"$nulls":6},"IETVE VAI GĀJĒJU CEĻŠ",null,null,"BRAUCAMĀ DAĻA",{"$nulls":3},"NOMALE","ZAĻĀ ZONA",null,"IETVE VAI GĀJĒJU CEĻŠ",null,null,"BRAUCAMĀ DAĻA",{"$nulls":3},"NOMALE","ZAĻĀ ZONA"]
[{"$nulls":6},"ASFALTS","BRUĢIS","CITS","ASFALTS","BRUĢIS","GRANTS","CITS","GRANTS","MELNZEME",null,"ASFALTS","BRUĢIS","CITS","ASFALTS","BRUĢIS","GRANTS","CITS","GRANTS","MELNZEME"]
[1,{"$nulls":14},{"$f":"IFERROR((VLOOKUP(B24,'Ielu reģistrs'!$B$2:$H$447,7,FALSE)*SUM(J24:M24)*$D$35)+((SUM(G24:I24)*0.5)*$D$35), 0)","v":{"v":0,"d":"0.00"}}]
[2,{"$nulls":14},{"$f":"IFERROR((VLOOKUP(B25,'Ielu reģistrs'!$B$2:$H$447,7,FALSE)*SUM(J25:M25)*$D$35)+((SUM(G25:I25)*0.5)*$D$35), 0)","v":{"v":0,"d":"0.00"}}]
[3,{"$nulls":14},{"$f":"IFERROR((VLOOKUP(B26,'Ielu reģistrs'!$B$2:$H$447,7,FALSE)*SUM(J26:M26)*$D$35)+((SUM(G26:I26)*0.5)*$D$35), 0)","v":{"v":0,"d":"0.00"}}]
[4,{"$nulls":14},{"$f":"IFERROR((VLOOKUP(B27,'Ielu reģistrs'!$B$2:$H$447,7,FALSE)*SUM(J27:M27)*$D$35)+((SUM(G27:I27)*0.5)*$D$35), 0)","v":{"v":0,"d":"0.00"}}]
[5,{"$nulls":14},{"$f":"IFERROR((VLOOKUP(B28,'Ielu reģistrs'!$B$2:$H$447,7,FALSE)*SUM(J28:M28)*$D$35)+((SUM(G28:I28)*0.5)*$D$35), 0)","v":{"v":0,"d":"0.00"}}]
[6,{"$nulls":14},{"$f":"IFERROR((VLOOKUP(B29,'Ielu reģistrs'!$B$2:$H$447,7,FALSE)*SUM(J29:M29)*$D$35)+((SUM(G29:I29)*0.5)*$D$35), 0)","v":{"v":0,"d":"0.00"}}]
[7,{"$nulls":14},{"$f":"IFERROR((VLOOKUP(B30,'Ielu reģistrs'!$B$2:$H$447,7,FALSE)*SUM(J30:M30)*$D$35)+((SUM(G30:I30)*0.5)*$D$35), 0)","v":{"v":0,"d":"0.00"}}]
["Kopā:",{"$nulls":5},{"$f":"SUM(G24:G30)","v":0},{"$f":"SUM(H24:H30)","v":0},0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":3},"DD.MM.GGGG",null,"DD.MM.GGGG"]
[null,"Darbi tiks veikti no",null,null,"līdz"]
[null,"Rakšanas darbu ilgums (dienas)",null,{"$f":"F34+1-D34","v":1}]
[]
[null,"Plānotā nomas maksa, euro bez PVN",null,{"$f":"IF(D43=\"\",0,IF(D43=\"Jā\",0,IF(D42=\"Jā\",0,SUM(P24:P30))))","v":{"v":0,"d":"0.00"}}]
[null,"Plānotā nomas maksa, euro PVN 21%",null,{"$f":"D39-D37","v":{"v":0,"d":"0.00"}}]
[null,"Plānotā nomas maksa, euro ar PVN",null,{"$f":"D37*1.21","v":{"v":0,"d":"0.00"}}]
[]
[null,"Plānoti darbi",null,"Jā"]
[null,"Avārijas darbi",null,{"$f":"IF(D41=\"\",\"\",IF(D41=\"Nē\",\"Jā\",\"Nē\"))","v":"Nē"}]
[null,"Atvieglojumi2",null,"Nē"]
[null,"Vai darbi tiek veikti  kultūras pieminekļu aizsardzības zonā (kultūras pieminekļu teritorijā vai to aizsardzības zonās)",null,"Nē"]
[]
["Apliecinājuma karte Nr."]
["Būvatļauja Nr."]
["Paskaidrojuma raksts Nr."]
["Paziņojums par būvniecību Nr."]
["(Aizpildīt nepieciešamo. Neplānotu avārijas darbu gadījumā aizpildīt nav nepieciešams)"]
[]
[]
["INFORMĀCIJA PAR FIZISKO PERSONU DATU APSTRĀDI: \nEsmu informēts/ta, ka fizisko personas datu apstrādes pārzinis ir Jelgavas valstspilsētas pašvaldība un informācija par personu datu apstrādi pieejama Jelgavas valstspilsētas pašvaldības tīmekļa vietnē www.jelgava.lv vai saņemot informāciju klātienē."]
[]
[]
[{"$nulls":3},"kontakttālrunis"]
["vārds, uzvārds, paraksts3"]
[]
[]
["(datums)"]
[]
["Piezīmes:"]
["1 - aizpilda gadījos, ja paredzēti atvieglojumi personai ar invaliditāti."]
["2 - no maksas atbrīvoti valsts vai pašvaldības institūcija vai kapitālsabiedrība, kurā attiecīgi valsts vai pašvaldība ir 100 % kapitāldaļu turētāja, vai persona, kurai deleģēta valsts vai pašvaldības pārvaldes uzdevumu pildīšana, vai fiziska persona, kurai noteikta I vai II invaliditātes grupa."]
["3 - dokumenta rekvizītus \"paraksts\" un \"datums\" neaizpilda, ja elektroniskais dokuments ir sagatavots atbilstoši normatīvajiem aktiem par elektronisko dokumentu noformēšanu."]
[]
["*ŠIS DOKUMENTS IR ELEKTRONISKI PARAKSTĪTS AR DROŠU ELEKTRONISKO PARAKSTU UN SATUR LAIKA ZĪMOGU"]

{"sheet":"Darbu tips","index":1,"n_rows":27,"n_cols":1,"rows_kept":27,"hidden":true}
[]
["Apgaismojuma tīklu būvdarbi"]
["Bērnu rotaļlaukuma izbūve"]
["Bērnu rotaļu ierīču būvdarbi"]
["Caurtekas būvdarbi"]
["Celmu raušana"]
["Dīķa rakšana/tīrīšana"]
["Dzelzceļa pārbrauktuves būvdarbi"]
["Elektroapgādes tīklu būvdarbi"]
["Gāzesvada būvdarbi"]
["Ģeoloģiskā izpēte – dziļurbumu veikšana"]
["Ielas būvdarbi"]
["Ietves būvdarbi"]
["Koku stādīšana"]
["Labiekārtošanas darbi"]
["Lietus ūdens kanalizācijas būvdarbi"]
["Meliorācijas sistēmas būvdarbi"]
["Optisko tīklu būvdarbi"]
["Saimnieciskās kanalizācijas būvdarbi"]
["Satiksmes organizācijas tehnisko līdzekļu būvdarbi"]
["Siltumtīklu būvdarbi"]
["Tilta būvdarbi"]
["Transformatoru apakšstacijas būvdarbi"]
["Ūdensvada būvdarbi"]
["Ūdensvada un saimnieciskās kanalizācijas būvdarbi"]
["Vājstrāvas tīklu būvdarbi"]
["Citi būvdarbi"]

{"sheet":"Ielu reģistrs","index":2,"n_rows":447,"n_cols":8,"rows_kept":447,"hidden":true}
[null,null,"Klase","eiro/ dienā","Gads","Gadi","Koef.","eiro/dienā ar koef."]
[1,"1. līnijas posms no Dobeles šosejas līdz Ganību ielai","C",1.65,2000,{"$f":"YEAR(TODAY())-E2","v":24},{"$f":"VLOOKUP(F2,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D2*G2","v":1.65}]
[2,"1. līnijas posms no Ganību ielas līdz Meiju ceļam","D",0.83,2000,24,{"$f":"VLOOKUP(F3,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[3,"2.līnijas posms no Dobeles šosejas līdz Nameja ielai","D",0.83,2024,0,{"$f":"VLOOKUP(F4,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[4,"2.līnijas posms no Nameja ielas līdz Ošu ceļam","D",0.83,2024,0,{"$f":"VLOOKUP(F5,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[5,"2.līnijas posms no Ošu ceļa līdz pilsētas administratīvajai robežai","D",0.83,2024,0,{"$f":"VLOOKUP(F6,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[6,"3.līnijas posms no Dobeles šosejas līdz Nameja ielai","D",0.83,2024,0,{"$f":"VLOOKUP(F7,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[7,"3.līnijas posms no Nameja ielas līdz Meža ceļam","D",0.83,2024,0,{"$f":"VLOOKUP(F8,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[8,"4.līnija","C",1.65,2010,14,{"$f":"VLOOKUP(F9,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[9,"5.līnija","D",0.83,2010,14,{"$f":"VLOOKUP(F10,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[10,"6.līnija","D",0.83,2010,14,{"$f":"VLOOKUP(F11,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[11,"Ābelītes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F12,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[12,"Ābeļu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F13,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[13,"Agroķīmiķu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F14,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[14,"Aizsargu iela","A",4.13,2023,1,{"$f":"VLOOKUP(F15,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},20.65]
[15,"Aizsargu ielas satiksmes rotācijas aplis","A",4.13,2023,1,{"$f":"VLOOKUP(F16,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},20.65]
[16,"Akāciju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F17,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[17,"Akadēmijas iela","B",2.48,2010,14,{"$f":"VLOOKUP(F18,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[18,"Akmeņu ielas posms no Imantas ielas līdz Kronvalda ielai","C",1.65,2021,3,{"$f":"VLOOKUP(F19,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[19,"Akmeņu ielas posms no Brīvības bulvāra līdz Imantas ielai","C",1.65,2010,14,{"$f":"VLOOKUP(F20,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[20,"Aku ceļš","D",0.83,2019,5,{"$f":"VLOOKUP(F21,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[21,"Alkšņu iela","D",0.83,2020,4,{"$f":"VLOOKUP(F22,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[22,"Amatu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F23,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[23,"Apiņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F24,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[24,"Apoga iela","D",0.83,2000,24,{"$f":"VLOOKUP(F25,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[25,"Apšu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F26,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[26,"Āraišu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F27,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[27,"Arāju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F28,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[28,"Aroniju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F29,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[29,"Asnu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F30,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[30,"Aspazijas iela","C",1.65,2010,14,{"$f":"VLOOKUP(F31,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[31,"Asteru iela","C",1.65,2010,14,{"$f":"VLOOKUP(F32,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[32,"Atmodas ielas posms no Dambja ielas līdz Dobeles šosejai","A",4.13,2017,7,{"$f":"VLOOKUP(F33,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},8.26]
[33,"Atmodas ielas posms no Ganību ielas līdz Ganību ielai Nr.66","D",0.83,2018,6,{"$f":"VLOOKUP(F34,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[34,"Atmodas ielas posms no Ganību ielas Nr.66 līdz Meiju ceļam","D",0.83,2017,7,{"$f":"VLOOKUP(F35,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[35,"Atpūtas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F36,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[36,"Audēju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F37,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[37,"Augļudārzu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F38,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[38,"Augstkalnes iela","D",0.83,2020,4,{"$f":"VLOOKUP(F39,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[39,"Augusta iela","D",0.83,2014,10,{"$f":"VLOOKUP(F40,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[40,"Ausekļa iela","D",0.83,2000,24,{"$f":"VLOOKUP(F41,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[41,"Ausmas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F42,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[42,"Austrumu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F43,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[43,"Aveņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F44,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[44,"Aviācijas ielas posms no Cukura ielas līdz Garozas ielai","D",0.83,2014,10,{"$f":"VLOOKUP(F45,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[45,"Aviācijas ielas posms no Garozas ielas līdz Loka maģistrālei","B",2.48,2000,24,{"$f":"VLOOKUP(F46,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[46,"Aviācijas ielas posms no Loka maģistrāles līdz Aviācijas ielai 42","C",1.65,2014,10,{"$f":"VLOOKUP(F47,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},3.3]
[47,"Avotu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F48,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[48,"Baldones iela","D",0.83,2000,24,{"$f":"VLOOKUP(F49,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[49,"Baložu iela","C",1.65,2010,14,{"$f":"VLOOKUP(F50,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[50,"Bāra ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F51,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[51,"Baraviku iela","D",0.83,2000,24,{"$f":"VLOOKUP(F52,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[52,"Bauskas ielas posms no Lapu ielas līdz Miera ielai","C",1.65,2000,24,{"$f":"VLOOKUP(F53,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[53,"Bauskas ielas posms no Miera ielas līdz Bauskas ielai 19","C",1.65,2000,24,{"$f":"VLOOKUP(F54,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[54,"Bauskas ielas posms no Bauskas ielas 19 līdz Valsts reģionālajam autoceļam P94","C",1.65,2024,0,{"$f":"VLOOKUP(F55,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[55,"Bebru ceļa posms no Dambja ielas līdz Dūņu ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F56,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[56,"Bebru ceļa posms no Dūņu ielas līdz Smilgu ielai","D",0.83,2017,7,{"$f":"VLOOKUP(F57,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[57,"Bebru ceļa posms no Smilgu ielas līdz Dambja ielai","D",0.83,2020,4,{"$f":"VLOOKUP(F58,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[58,"Bērzaines iela","D",0.83,2000,24,{"$f":"VLOOKUP(F59,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[59,"Bērzu ceļa posms no Vecā ceļa līdz Loka maģistrālei","C",1.65,2020,4,{"$f":"VLOOKUP(F60,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[60,"Bērzu ceļa asfaltētais posms no Loka maģistrāles līdz Bērzu ceļam Nr.46","D",0.83,2020,4,{"$f":"VLOOKUP(F61,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[61,"Bērzu ceļa posms no Bērzu ceļa Nr.46 līdz Klijēnu ceļam","D",0.83,2000,24,{"$f":"VLOOKUP(F62,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[62,"Biešu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F63,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[63,"Birzes iela","D",0.83,2021,3,{"$f":"VLOOKUP(F64,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[64,"Bišu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F65,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[65,"Blaumaņa iela","B",2.48,2000,{"$f":"YEAR(TODAY())-E66","v":24},{"$f":"VLOOKUP(F66,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[66,"Blāzmas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F67,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D67*G67","v":0.83}]
[67,"Briežu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F68,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[68,"Brigaderes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F69,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[69,"Brīvības bulvāris","B",2.48,2010,14,{"$f":"VLOOKUP(F70,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[70,"Bruģa iela","D",0.83,2024,0,{"$f":"VLOOKUP(F71,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[71,"Brūkleņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F72,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[72,"Bumbieru ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F73,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[73,"Būriņu ceļa posms no Baložu ielas līdz Zemgaļu ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F74,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[74,"Būriņu ceļa posms no Sniega ielas līdz Bāra ceļam","C",1.65,2000,24,{"$f":"VLOOKUP(F75,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[75,"Celtnieku ielas posms no Satiksmes ielas līdz Traktoristu ielai","D",0.83,2023,1,{"$f":"VLOOKUP(F76,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[76,"Celtnieku ielas posms no Traktoristu ielas līdz Vasaras ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F77,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D77*G77","v":0.83}]
[77,"Cepļu iela","D",0.83,2021,3,{"$f":"VLOOKUP(F78,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[78,"Ceriņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F79,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[79,"Ciedru iela","D",0.83,2000,24,{"$f":"VLOOKUP(F80,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D80*G80","v":0.83}]
[80,"Ciema iela","D",0.83,2000,24,{"$f":"VLOOKUP(F81,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D81*G81","v":0.83}]
[81,"Cīruļu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F82,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[82,"Cukura iela","C",1.65,2014,10,{"$f":"VLOOKUP(F83,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},3.3]
[83,"Čiekuru iela","D",0.83,2024,0,{"$f":"VLOOKUP(F84,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[84,"Dainas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F85,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[85,"Dalbes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F86,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[86,"Dambja ielas posms no Lielās ielas līdz Sarmas ielai","B",2.48,2000,24,{"$f":"VLOOKUP(F87,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[87,"Dambja ielas posms no Sarmas ielas līdz Mazajam ceļam","B",2.48,2017,7,{"$f":"VLOOKUP(F88,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},4.96]
[88,"Dambja ielas posms no Bebru ceļa līdz Atmodas ielai","B",2.48,2017,7,{"$f":"VLOOKUP(F89,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},4.96]
[89,"Dambja ielas posms no Atmodas ielas līdz Kārklu ielai","C",1.65,2017,7,{"$f":"VLOOKUP(F90,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},3.3]
[90,"Dārza iela","D",0.83,2021,3,{"$f":"VLOOKUP(F91,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[91,"Dārzkopju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F92,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[92,"Dīķa iela","D",0.83,2000,24,{"$f":"VLOOKUP(F93,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[93,"Dobeles iela","C",1.65,2010,14,{"$f":"VLOOKUP(F94,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[94,"Dobeles šoseja","A",4.13,2010,14,{"$f":"VLOOKUP(F95,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},4.13]
[95,"Draudzības iela","D",0.83,2000,24,{"$f":"VLOOKUP(F96,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[96,"Driksas ielas posms no Pasta ielas līdz Katoļu ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F97,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[97,"Driksas ielas posms no Katoļu ielas līdz Akadēmijas ielai","C",1.65,2000,24,{"$f":"VLOOKUP(F98,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[98,"Driksas ielas posms no Akadēmijas ielas līdz Jāņa Čakstes bulvārim 7","D",0.83,2000,24,{"$f":"VLOOKUP(F99,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[99,"Druvienas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F100,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[100,"Druvu iela","D",0.83,2015,9,{"$f":"VLOOKUP(F101,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[101,"Dūņu iela","D",0.83,2017,7,{"$f":"VLOOKUP(F102,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[102,"Dzelzceļnieku iela","D",0.83,2000,24,{"$f":"VLOOKUP(F103,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[103,"Dzērveņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F104,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[104,"Dzērves iela","D",0.83,2000,24,{"$f":"VLOOKUP(F105,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[105,"Dzirnavu ielas posms no Lietuvas šosejas līdz Dzirmavu ielai Nr.1","C",1.65,2019,5,{"$f":"VLOOKUP(F106,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[106,"Dzirnavu ielas posms no Dzirmavu ielas Nr.1 līdz Bauskas ielai","C",1.65,2000,{"$f":"YEAR(TODAY())-E107","v":24},{"$f":"VLOOKUP(F107,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D107*G107","v":1.65}]
[107,"Eduarda Vedenbauma iela","D",0.83,2000,24,{"$f":"VLOOKUP(F108,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[108,"Egas ielas posms no Dambja ielas līdz Maija ielai","D",0.83,2021,3,{"$f":"VLOOKUP(F109,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[109,"Egas ielas posms no Maija ielas līdz Sakņudārza ielai","D",0.83,2010,14,{"$f":"VLOOKUP(F110,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[110,"Egļu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F111,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[111,"Elejas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F112,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D112*G112","v":0.83}]
[112,"Elektrības iela","D",0.83,2000,24,{"$f":"VLOOKUP(F113,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D113*G113","v":0.83}]
[113,"Emburgas iela","D",0.83,2021,3,{"$f":"VLOOKUP(F114,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[114,"Emīla Dārziņa iela no Kļavu ielas līdz Ausmas ielai","D",0.83,2024,0,{"$f":"VLOOKUP(F115,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[115,"Emīla Dārziņa iela no Kļavu ielas līdz Augstkalnes ielai","D",0.83,2010,14,{"$f":"VLOOKUP(F116,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[116,"Emīla Dārziņa iela no Augstkalnes ielas līdz Rūpniecības ielai","D",0.83,2019,{"$f":"YEAR(TODAY())-E117","v":5},{"$f":"VLOOKUP(F117,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},{"$f":"D117*G117","v":4.1499999999999995}]
[117,"Emīla Melngaiļa  iela","D",0.83,2000,24,{"$f":"VLOOKUP(F118,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[118,"Ērgļu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F119,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[119,"Filozofu ielas posms no Raiņa ielas līdz Rūpniecības ielai","B",2.48,2000,24,{"$f":"VLOOKUP(F120,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[120,"Filozofu ielas posms no Rūpniecības ielas līdz Dambja ielai","C",1.65,2010,14,{"$f":"VLOOKUP(F121,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[121,"Floras iela","D",0.83,2000,24,{"$f":"VLOOKUP(F122,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[122,"Gaismas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F123,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[123,"Ganību ielas posms no Dobeles ielas līdz Kazarmes ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F124,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[124,"Ganību ielas posms no Kazarmes ielai līdz Satiksmes ielai","D",0.83,2020,4,{"$f":"VLOOKUP(F125,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[125,"Ganību ielas posms no Satiksmes ielas līdz 1.līnijai","C",1.65,2000,24,{"$f":"VLOOKUP(F126,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[126,"Ganību ielas posms no 1.līnijas līdz 2.līnijai","D",0.83,2024,0,{"$f":"VLOOKUP(F127,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[127,"Gārņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F128,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[128,"Gala iela","D",0.83,2024,0,{"$f":"VLOOKUP(F129,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[129,"Garozas ielas posms no Rīgas ielas līdz Peldu ielai","A",4.13,2020,4,{"$f":"VLOOKUP(F130,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},20.65]
[130,"Garozas ielas posms no Peldu ielas līdz Prohorova ielai","A",4.13,2010,14,{"$f":"VLOOKUP(F131,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},4.13]
[131,"Garozas ielas posms no Prohorova ielas līdz Jelgavas pilsētas robežai","A",4.13,2020,4,{"$f":"VLOOKUP(F132,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},{"$f":"D132*G132","v":20.65}]
[132,"Gatves iela","D",0.83,2020,4,{"$f":"VLOOKUP(F133,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[133,"Gobu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F134,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[134,"Graudu iela","C",1.65,2021,3,{"$f":"VLOOKUP(F135,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},{"$f":"D135*G135","v":8.25}]
[135,"Griezes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F136,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[136,"Grīvas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F137,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[137,"Gulbju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F138,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[138,"Gundegas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F139,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[139,"Iecavas iela","D",0.83,2021,3,{"$f":"VLOOKUP(F140,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[140,"Ielejas iela","D",0.83,2000,{"$f":"YEAR(TODAY())-E141","v":24},{"$f":"VLOOKUP(F141,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[141,"Ievu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F142,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[142,"Imantas iela","D",0.83,2010,14,{"$f":"VLOOKUP(F143,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[143,"Indrānu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F144,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[144,"Indras iela","D",0.83,2000,24,{"$f":"VLOOKUP(F145,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[145,"Institūta iela","D",0.83,2010,14,{"$f":"VLOOKUP(F146,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[146,"Īsā iela","D",0.83,2000,24,{"$f":"VLOOKUP(F147,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[147,"Īves iela","D",0.83,2000,24,{"$f":"VLOOKUP(F148,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[148,"Izstādes iela","C",1.65,2000,24,{"$f":"VLOOKUP(F149,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[149,"Jāņa Asara iela","D",0.83,2000,24,{"$f":"VLOOKUP(F150,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[150,"Jāņa Čakstes bulvāra posms no Raiņa ielas līdz Lielajai ielai","C",1.65,2016,8,{"$f":"VLOOKUP(F151,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},3.3]
[151,"Jāņa Čakstes bulvāra posms no Lielās ielas līdz Ausekļa ielai","D",0.83,2016,8,{"$f":"VLOOKUP(F152,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[152,"Jāņa ielas posms no Mātera ielas līdz Pasta ielai","D",0.83,2010,14,{"$f":"VLOOKUP(F153,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[153,"Jāņa ielas posms no Pasta ielas līdz Zemgales prospektam","C",1.65,2010,14,{"$f":"VLOOKUP(F154,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[154,"Jasmīnu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F155,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[155,"Jaunais ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F156,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[156,"Jēkaba ielas posms no Raiņa ielas līdz Pavasara ielai","D",0.83,2019,5,{"$f":"VLOOKUP(F157,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[157,"Jēkaba ielas posms no Pavasara ielas līdz Zirgu ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F158,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[158,"Kadiķu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F159,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[159,"Kaimiņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F160,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[160,"Kalmju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F161,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[161,"Kalna iela","D",0.83,2000,24,{"$f":"VLOOKUP(F162,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[162,"Kalnciema ceļš no Vecā ceļa līdz pilsētas administratīvajai robežai","A",4.13,2010,14,{"$f":"VLOOKUP(F163,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},4.13]
[163,"Kalnciema ceļš no Rīgas ielas līdz Vecajam ceļam ","A",4.13,2020,4,{"$f":"VLOOKUP(F164,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},20.65]
[164,"Kameņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F165,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[165,"Kārklu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F166,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[166,"Kārļa iela","D",0.83,2021,3,{"$f":"VLOOKUP(F167,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[167,"Kārļa Praula iela","D",0.83,2000,24,{"$f":"VLOOKUP(F168,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[168,"Kārniņu ceļš","C",1.65,2000,24,{"$f":"VLOOKUP(F169,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[169,"Kastaņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F170,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[170,"Katoļu iela","C",1.65,2010,14,{"$f":"VLOOKUP(F171,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[171,"Kazarmes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F172,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[172,"Keramiķu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F173,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[173,"Klijēnu ceļa asfaltētais posms no Kalnciema ceļa līdz Klijēnu ceļam Nr.5 ","D",0.83,2000,24,{"$f":"VLOOKUP(F174,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[174,"Klijēnu ceļa asfaltētais posms starp Veco ceļu un Rīgas ielu","D",0.83,2017,7,{"$f":"VLOOKUP(F175,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[175,"Klijēnu ceļa posms no Klijēnu ceļa Nr.6 līdz asfaltētajam posmam pēc Vecā ceļa un pēc asfaltētā posma līdz Rīgas ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F176,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[176,"Klusā iela","D",0.83,2000,24,{"$f":"VLOOKUP(F177,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[177,"Kļavu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F178,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[178,"Kļavu ielas posms no Tērvetes ielas līdz Emīla Dārziņa ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F179,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[179,"Kļavu ielas posms Emīla Dārziņa ielas līdz Filozofu ielai","D",0.83,2016,8,{"$f":"VLOOKUP(F180,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[180,"Kooperatīva iela","D",0.83,2000,24,{"$f":"VLOOKUP(F181,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[181,"Krasta iela","D",0.83,2000,24,{"$f":"VLOOKUP(F182,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[182,"Krastmalas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F183,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[183,"Kreimeņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F184,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D184*G184","v":0.83}]
[184,"Kristapa Helmaņa iela","C",1.65,2000,24,{"$f":"VLOOKUP(F185,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[185,"Krišjāņa Barona iela","C",1.65,2000,24,{"$f":"VLOOKUP(F186,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[186,"Kronvalda ielas posms no Izstādes ielas līdz Imantas ielai","C",1.65,2010,14,{"$f":"VLOOKUP(F187,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[187,"Kronvalda ielas posms no Imantas ielas līdz Pumpura ielai","C",1.65,2021,3,{"$f":"VLOOKUP(F188,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[188,"Kūliņu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F189,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[189,"Kungu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F190,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[190,"Ķeguma iela","D",0.83,2000,24,{"$f":"VLOOKUP(F191,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[191,"Ķiršu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F192,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[192,"Lāčplēša ielas posms no Aviācijas ielas līdz Kronvalda ielai","C",1.65,2010,14,{"$f":"VLOOKUP(F193,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[193,"Lāčplēša ielas posms no Kronvalda ielas līdz Rīgas ielai","D",0.83,2010,14,{"$f":"VLOOKUP(F194,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[194,"Lāču iela","D",0.83,2000,24,{"$f":"VLOOKUP(F195,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[195,"Laimas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F196,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[196,"Laipu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F197,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[197,"Lakstīgalu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F198,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[198,"Langervaldes iela","B",2.48,2020,4,{"$f":"VLOOKUP(F199,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},12.4]
[199,"Lapskalna ielas posms no Blaumaņa ielas līdz Zvejnieku ielai","B",2.48,2020,4,{"$f":"VLOOKUP(F200,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},12.4]
[200,"Lapskalna ielas posms no Zvejnieku ielas līdz Slokas ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F201,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[201,"Lapu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F202,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[202,"Lauksaimnieku iela","D",0.83,2000,24,{"$f":"VLOOKUP(F203,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[203,"Lauku iela","D",0.83,2000,24,{"$f":"VLOOKUP(F204,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[204,"Lazdu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F205,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[205,"Lediņu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F206,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[206,"Līču iela","D",0.83,2021,3,{"$f":"VLOOKUP(F207,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[207,"Lidotāju ielas posms no Ganību ielas līdz Vasaras ielai ","D",0.83,2020,4,{"$f":"VLOOKUP(F208,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[208,"Lidotāju ielas posms no Vasaras ielas līdz Traktoristu ielai","D",0.83,2007,{"$f":"YEAR(TODAY())-E209","v":17},{"$f":"VLOOKUP(F209,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[209,"Līduma iela","D",0.83,2000,24,{"$f":"VLOOKUP(F210,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[210,"Lieknes ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F211,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[211,"Lielā iela","A",4.13,2013,11,{"$f":"VLOOKUP(F212,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},4.13]
[212,"Lielupes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F213,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[213,"Liepājas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F214,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[214,"Liepu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F215,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[215,"Liesmas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F216,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[216,"Lietuvas šosejas posms no Pasta ielas līdz Miera ielai","A",4.13,2013,11,{"$f":"VLOOKUP(F217,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},4.13]
[217,"Lietuvas šosejas posms no Miera ielas līdz pilsētas administratīvajai robežai","A",4.13,2015,9,{"$f":"VLOOKUP(F218,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},8.26]
[218,"Līgas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F219,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[219,"Līgotāju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F220,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[220,"Linu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F221,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[221,"Loka iela","D",0.83,2000,24,{"$f":"VLOOKUP(F222,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[222,"Loka maģistrāle","A",4.13,2020,4,{"$f":"VLOOKUP(F223,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},20.65]
[223,"Madaru iela","D",0.83,2020,4,{"$f":"VLOOKUP(F224,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[224,"Maija iela","D",0.83,2000,24,{"$f":"VLOOKUP(F225,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[225,"Malienas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F226,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[226,"Malkas ceļš","C",1.65,2000,24,{"$f":"VLOOKUP(F227,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[227,"Māras iela","D",0.83,2010,14,{"$f":"VLOOKUP(F228,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[228,"Mārtiņa iela","D",0.83,2020,4,{"$f":"VLOOKUP(F229,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[229,"Mātera iela","C",1.65,2011,13,{"$f":"VLOOKUP(F230,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[230,"Mazā Dambja iela","D",0.83,2000,24,{"$f":"VLOOKUP(F231,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[231,"Mazā Viršu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F232,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[232,"Mazais ceļš no Sakņudārza ielas līdz Mazajam ceļam 9B","D",0.83,2016,8,{"$f":"VLOOKUP(F233,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[233,"Mazais ceļš no Mazā ceļa 9B līdz Dambja ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F234,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[234,"Mednieku iela","D",0.83,2000,24,{"$f":"VLOOKUP(F235,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[235,"Medus iela","D",0.83,2000,24,{"$f":"VLOOKUP(F236,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[236,"Meiju ceļš","C",1.65,2000,24,{"$f":"VLOOKUP(F237,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[237,"Meldru ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F238,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[238,"Melleņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F239,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[239,"Mētru iela","D",0.83,2000,24,{"$f":"VLOOKUP(F240,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[240,"Meža ceļa posms no 3.līnijas līdz Šūmaņu ceļam","D",0.83,2000,24,{"$f":"VLOOKUP(F241,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[241,"Meža ceļa posms no 4.līnijas līdz Gobu ceļam","D",0.83,2000,24,{"$f":"VLOOKUP(F242,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[242,"Meža ceļa posms no 4.līnijas līdz Šūmaņu ceļam","C",1.65,2000,24,{"$f":"VLOOKUP(F243,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[243,"Mežmalas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F244,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[244,"Miera  ielas posms no Lietuvas šosejas līdz Aizsargu ielas rotācijas aplim","A",4.13,2000,24,{"$f":"VLOOKUP(F245,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},4.13]
[245,"Miera  ielas posms no Aizsargu ielas rotācijas apļa līdz Lediņu ceļam/Jelgavas pilsētas robežai","A",4.13,2024,0,{"$f":"VLOOKUP(F246,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},20.65]
[246,"Miezītes ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F247,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[247,"Nākotnes iela","C",1.65,2020,4,{"$f":"VLOOKUP(F248,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[248,"Namdaru iela","D",0.83,2020,4,{"$f":"VLOOKUP(F249,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[249,"Nameja ielas posms no 1.līnijas līdz Nameja ielai 1A","D",0.83,2000,24,{"$f":"VLOOKUP(F250,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[250,"Nameja ielas posms no Nameja ielas 1A līdz Nameja ielai 6","D",0.83,2024,0]
[251,"Nameja ielas posms no Nameja ielas 6 līdz 4.līnijai","D",0.83,2010,14,{"$f":"VLOOKUP(F252,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D252*G252","v":0.83}]
[252,"Neretas iela","D",0.83,2020,4,{"$f":"VLOOKUP(F253,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[253,"Niedru iela","D",0.83,2000,24,{"$f":"VLOOKUP(F254,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D254*G254","v":0.83}]
[254,"Nomales iela","D",0.83,2000,24,{"$f":"VLOOKUP(F255,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[255,"Olaines iela","D",0.83,2000,24,{"$f":"VLOOKUP(F256,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[256,"Oļu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F257,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[257,"Ošu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F258,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[258,"Ozolu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F259,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[259,"Paceplīšu ela","D",0.83,2000,24,{"$f":"VLOOKUP(F260,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[260,"Palejas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F261,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[261,"Palīdzības iela","D",0.83,2015,9,{"$f":"VLOOKUP(F262,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[262,"Palienas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F263,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[263,"Palu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F264,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[264,"Pambakaru ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F265,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[265,"Papardes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F266,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[266,"Parka ielas posms no Garozas ielas līdz Rasas ielai","D",0.83,2019,5,{"$f":"VLOOKUP(F267,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[267,"Parka ielas posms no Rasas ielas līdz Jaunajam ceļam ","D",0.83,2020,4,{"$f":"VLOOKUP(F268,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[268,"Pārmiju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F269,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[269,"Pārslu iela","D",0.83,2000,{"$f":"YEAR(TODAY())-E270","v":24},{"$f":"VLOOKUP(F270,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[270,"Pasta ielas posms no Dobeles ielas līdz Sudraba Edžus ielai","B",2.48,2000,24,{"$f":"VLOOKUP(F271,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[271,"Pasta ielas posms no Sudraba Edžus ielas līdz Lietuvas šosejai","B",2.48,2015,9,{"$f":"VLOOKUP(F272,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},4.96]
[272,"Paula Lejiņa iela","C",1.65,2020,{"$f":"YEAR(TODAY())-E273","v":4},{"$f":"VLOOKUP(F273,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[273,"Pavasara iela","D",0.83,2000,24,{"$f":"VLOOKUP(F274,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[274,"Peldu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F275,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[275,"Pērnavas iela","C",1.65,2020,4,{"$f":"VLOOKUP(F276,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[276,"Pētera iela","D",0.83,2000,24,{"$f":"VLOOKUP(F277,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[277,"Pīlādžu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F278,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[278,"Pilssalas iela","D",0.83,2024,0,{"$f":"VLOOKUP(F279,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[279,"Pionieru ielas posms no Ganību ielas līdz Namdaru ielai","D",0.83,2020,4,{"$f":"VLOOKUP(F280,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[280,"Pionieru ielas posms no Namdaru ielas līdz Meiju ceļam ","D",0.83,2000,24,{"$f":"VLOOKUP(F281,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[281,"Platones iela","C",1.65,2021,3,{"$f":"VLOOKUP(F282,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[282,"Plostu  iela","D",0.83,2000,24,{"$f":"VLOOKUP(F283,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[283,"Pludmales iela","D",0.83,2000,24,{"$f":"VLOOKUP(F284,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[284,"Plūmju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F285,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[285,"Pļavu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F286,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[286,"Pogu lauku ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F287,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[287,"Priežu iela","D",0.83,2009,15,{"$f":"VLOOKUP(F288,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[288,"Prohorova iela","C",1.65,2020,4,{"$f":"VLOOKUP(F289,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[289,"Puķu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F290,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[290,"Pulkveža  Brieža iela","C",1.65,2000,24,{"$f":"VLOOKUP(F291,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[291,"Pulkveža Oskara Kalpaka iela","C",1.65,2010,14,{"$f":"VLOOKUP(F292,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[292,"Pumpura iela","C",1.65,2020,4,{"$f":"VLOOKUP(F293,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[293,"Pūpolu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F294,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[294,"Pūra ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F295,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[295,"Pureņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F296,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[296,"Putnu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F297,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[297,"Raiņa iela","B",2.48,2010,14,{"$f":"VLOOKUP(F298,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[298,"Rasas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F299,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[299,"Riekstu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F300,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[300,"Rīgas iela","A",4.13,2011,13,{"$f":"VLOOKUP(F301,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},4.13]
[301,"Riņķa iela","D",0.83,2000,24,{"$f":"VLOOKUP(F302,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[302,"Rītausmas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F303,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[303,"Robežu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F304,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[304,"Rogu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F305,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[305,"Romas ielas posms no Miera ielas līdz Turaidas ielai","C",1.65,2018,6,{"$f":"VLOOKUP(F306,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},3.3]
[306,"Romas ielas posms no Turaidas ielas līdz Jelgavas pilsētas robežai","C",1.65,2020,4,{"$f":"VLOOKUP(F307,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[307,"Rosmes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F308,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[308,"Rožu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F309,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[309,"Rubeņu ceļa posms no Garozas ielas līdz Loka maģistrālei","D",0.83,2020,4,{"$f":"VLOOKUP(F310,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[310,"Rubeņu ceļa posms no Garozas ielas līdz Neretas ielai","D",0.83,2021,3,{"$f":"VLOOKUP(F311,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[311,"Rudens iela","D",0.83,2000,24,{"$f":"VLOOKUP(F312,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[312,"Rudzu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F313,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[313,"Ruļļu iela","C",1.65,2020,4,{"$f":"VLOOKUP(F314,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[314,"Rūpniecības iela","A",4.13,2017,7,{"$f":"VLOOKUP(F315,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},8.26]
[315,"Sakarnieku iela","D",0.83,2000,24,{"$f":"VLOOKUP(F316,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[316,"Sakņudārza iela","D",0.83,2000,24,{"$f":"VLOOKUP(F317,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[317,"Saldus iela","D",0.83,2000,24,{"$f":"VLOOKUP(F318,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[318,"Salnas ielas posms no Tērvetes ielas līdz Ruļļu ielai","C",1.65,2000,24,{"$f":"VLOOKUP(F319,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[319,"Salnas ielas posms no Ruļļu ielas līdz Platones ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F320,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D320*G320","v":0.83}]
[320,"Sapņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F321,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[321,"Sargu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F322,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[322,"Sarmas iela","C",1.65,2010,14,{"$f":"VLOOKUP(F323,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[323,"Satiksmes ielas posms no Dobeles šosejas līdz Ganību ielai","B",2.48,2000,24,{"$f":"VLOOKUP(F324,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[324,"Satiksmes ielas posms no Ganību ielas līdz Meiju ceļam","B",2.48,2020,4,{"$f":"VLOOKUP(F325,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},12.4]
[325,"Saulaines iela","D",0.83,2000,24,{"$f":"VLOOKUP(F326,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[326,"Saules iela","D",0.83,2000,24,{"$f":"VLOOKUP(F327,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[327,"Saulgriežu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F328,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[328,"Saulītes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F329,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[329,"Savienības iela","C",1.65,2000,24,{"$f":"VLOOKUP(F330,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[330,"Senču iela","D",0.83,2000,24,{"$f":"VLOOKUP(F331,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[331,"Siena ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F332,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[332,"Sieramuižas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F333,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[333,"Sila iela","D",0.83,2000,24,{"$f":"VLOOKUP(F334,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[334,"Skautu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F335,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[335,"Skolas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F336,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[336,"Skolotāju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F337,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[337,"Skuju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F338,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[338,"Sliežu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F339,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[339,"Slokas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F340,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[340,"Smilgu iela","D",0.83,2000,{"$f":"YEAR(TODAY())-E341","v":24},{"$f":"VLOOKUP(F341,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[341,"Smilšu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F342,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[342,"Smiltnieku iela","D",0.83,2020,4,{"$f":"VLOOKUP(F343,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[343,"Sniedzes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F344,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[344,"Sniega iela","D",0.83,2000,24,{"$f":"VLOOKUP(F345,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[345,"Spāru ielas posms no Gatves ielas 5 līdz Gatves ielai 15","D",0.83,2000,24,{"$f":"VLOOKUP(F346,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[346,"Spāru ielas posms no Gatves ielas līdz Spāru ielai 62","D",0.83,2019,5,{"$f":"VLOOKUP(F347,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[347,"Spāru ielas posms no Spāru ielas 62 līdz Spāru ielai 64","D",0.83,2000,24,{"$f":"VLOOKUP(F348,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[348,"Sporta iela","C",1.65,2015,9,{"$f":"VLOOKUP(F349,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},3.3]
[349,"Sprīdīšu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F350,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[350,"Sprieguma iela","D",0.83,2000,24,{"$f":"VLOOKUP(F351,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[351,"Stacijas ielas posms no Pulkveža Oskara Kalpaka ielas līdz Pasta ielai","D",0.83,2015,9,{"$f":"VLOOKUP(F352,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},1.66]
[352,"Stacijas ielas posms no Pasta ielas līdz Zemgales prospektam","B",2.48,2015,9,{"$f":"VLOOKUP(F353,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},4.96]
[353,"Stadiona ielas posms no Vecā ceļa līdz Robežu ielai","D",0.83,2024,0,{"$f":"VLOOKUP(F354,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[354,"Stadiona ielas posms no Robežu ielas līdz Stadiona ielai 51","D",0.83,2024,0,{"$f":"VLOOKUP(F355,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[355,"Staļģenes ielas posms no Bauskas ielas līdz Vīksnas ielai","C",1.65,2021,3,{"$f":"VLOOKUP(F356,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[356,"Staļģenes ielas posms no Vīksnas ielas līdz Kārniņu ceļam","C",1.65,2022,2,{"$f":"VLOOKUP(F357,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[357,"Staļģenes ielas posms no Kārniņu ceļa līdz Staļģenes ielai 73","D",0.83,2000,24,{"$f":"VLOOKUP(F358,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[358,"Stārķu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F359,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[359,"Stiebru iela","D",0.83,2000,24,{"$f":"VLOOKUP(F360,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[360,"Straumes iela","D",0.83,2020,4,{"$f":"VLOOKUP(F361,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[361,"Strautnieku iela","D",0.83,2000,24,{"$f":"VLOOKUP(F362,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[362,"Strautu ceļš","D",0.83,2020,4,{"$f":"VLOOKUP(F363,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[363,"Strazdu ielas posms no Rīgas ielas līdz Kronvalda ielai","D",0.83,2020,4,{"$f":"VLOOKUP(F364,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[364,"Strazdu ielas posms no Rīgas ielas līdz Vecajam ceļam","D",0.83,2020,4,{"$f":"VLOOKUP(F365,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[365,"Stūrīša iela","D",0.83,2000,24,{"$f":"VLOOKUP(F366,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[366,"Sudrabu Edžus iela","C",1.65,2010,14,{"$f":"VLOOKUP(F367,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[367,"Sūnu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F368,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[368,"Svētes ielas posms no Sakņudārza ielas līdz Pulkveža Oskara Kalpaka ielai","D",0.83,2010,14,{"$f":"VLOOKUP(F369,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[369,"Svētes ielas posms no Pulkveža Oskara Kalpaka ielas līdz Pasta ielai","C",1.65,2010,14,{"$f":"VLOOKUP(F370,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[370,"Šķūņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F371,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[371,"Šūmaņu ceļš","C",1.65,2000,24,{"$f":"VLOOKUP(F372,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[372,"Teodora Grothusa iela","D",0.83,2000,24,{"$f":"VLOOKUP(F373,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[373,"Tērvetes ielas posms no Raiņa ielas līdz Rūpniecības ielai","B",2.48,2010,14,{"$f":"VLOOKUP(F374,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[374,"Tērvetes ielas posms no Rūpniecības ielas līdz Jelgavas pilsētas robežai","A",4.13,2010,14,{"$f":"VLOOKUP(F375,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},4.13]
[375,"Tīreļa iela","D",0.83,2000,24,{"$f":"VLOOKUP(F376,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[376,"Tirgoņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F377,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[377,"Traktoristu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F378,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[378,"Tukuma iela","D",0.83,2000,24,{"$f":"VLOOKUP(F379,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[379,"Tulpju iela","D",0.83,2000,24,{"$f":"VLOOKUP(F380,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[380,"Turaidas iela","D",0.83,2020,4,{"$f":"VLOOKUP(F381,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[381,"Ūdens iela","D",0.83,2000,24,{"$f":"VLOOKUP(F382,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[382,"Ūdensvada iela","D",0.83,2000,24,{"$f":"VLOOKUP(F383,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[383,"Upeņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F384,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D384*G384","v":0.83}]
[384,"Upes ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F385,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[385,"Upes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F386,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[386,"Upes ielas asfaltētais posms pie krustojuma ar Neretas ielu","D",0.83,2020,4,{"$f":"VLOOKUP(F387,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[387,"Uzvaras ielas posms no Lielās ielas līdz Dobeles ielai","B",2.48,2013,11,{"$f":"VLOOKUP(F388,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[388,"Uzvaras ielas posms no Dobeles ielas līdz Lapskalna ielai","C",1.65,2010,14,{"$f":"VLOOKUP(F389,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[389,"Uzvaras ielas posms no Lapskalna ielas līdz Slokas ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F390,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[390,"Vaivaru iela","D",0.83,2000,24,{"$f":"VLOOKUP(F391,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[391,"Valgundes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F392,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[392,"Vālodzes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F393,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[393,"Vaļņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F394,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[394,"Vangaļu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F395,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[395,"Vārpu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F396,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[396,"Vasaras iela","D",0.83,2020,4,{"$f":"VLOOKUP(F397,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[397,"Vasarnieku iela","D",0.83,2000,24,{"$f":"VLOOKUP(F398,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[398,"Vecā ceļa posms no Kalnciema ceļa līdz Institūta ielai","C",1.65,2010,14,{"$f":"VLOOKUP(F399,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[399,"Vecā ceļa posms no Institūta ielai līdz Pērnavas ielai","C",1.65,2020,4,{"$f":"VLOOKUP(F400,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[400,"Vecā ceļa posms no Loka maģistrāles līdz Klijēnu ceļam","D",0.83,2000,24,{"$f":"VLOOKUP(F401,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D401*G401","v":0.83}]
[401,"Veco Strēlnieku iela","D",0.83,2000,24,{"$f":"VLOOKUP(F402,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[402,"Vecpilsētas iela","C",1.65,2010,14,{"$f":"VLOOKUP(F403,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[403,"Vēja ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F404,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[404,"Veldzes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F405,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[405,"Veselības iela","D",0.83,2000,24,{"$f":"VLOOKUP(F406,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[406,"Vēsmas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F407,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[407,"Vētras iela","D",0.83,2000,24,{"$f":"VLOOKUP(F408,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[408,"Vidus iela","C",1.65,2000,24,{"$f":"VLOOKUP(F409,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[409,"Viestura ielas posms no Dobeles ielas līdz Ausekļa ielai","D",0.83,2000,24,{"$f":"VLOOKUP(F410,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[410,"Viestura ielas posms no Ausekļa ielas līdz Kazarmes ielai","D",0.83,2000,{"$f":"YEAR(TODAY())-E411","v":24},{"$f":"VLOOKUP(F411,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[411,"Vīgriežu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F412,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[412,"Vīksnas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F413,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[413,"Viktorijas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F414,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[414,"Vilces iela","D",0.83,2000,24,{"$f":"VLOOKUP(F415,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[415,"Vircavas iela","D",0.83,2000,24,{"$f":"VLOOKUP(F416,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[416,"Viršu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F417,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[417,"Viskaļu ielas posms no Ruļļu ielas līdz Lietuvas šosejai","C",1.65,2010,14,{"$f":"VLOOKUP(F418,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[418,"Viskaļu ielas posms no Ruļļu ielas līdz Viskaļu ielai 139","D",0.83,2000,24,{"$f":"VLOOKUP(F419,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[419,"Vītolu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F420,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[420,"Vizbuļu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F421,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[421,"Zālītes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F422,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[422,"Zaļā iela","D",0.83,2000,24,{"$f":"VLOOKUP(F423,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[423,"Zāļu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F424,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[424,"Zaļumu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F425,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},{"$f":"D425*G425","v":0.83}]
[425,"Zanderu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F426,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[426,"Zemeņu ielas atzars pa kreisi no Miera ielas (nr.8-12)","D",0.83,2000,24,{"$f":"VLOOKUP(F427,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[427,"Zemeņu ielas posms no Graudu ielas līdz Romas ielai","C",1.65,2019,5,{"$f":"VLOOKUP(F428,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[428,"Zemeņu ielas posms no Miera ielas līdz Zemeņu ielai 2J","C",1.65,2020,4,{"$f":"VLOOKUP(F429,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},8.25]
[429,"Zemgales prospekts","B",2.48,2015,9,{"$f":"VLOOKUP(F430,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},4.96]
[430,"Zemgaļu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F431,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[431,"Zemītes 1.līnija","D",0.83,2000,24,{"$f":"VLOOKUP(F432,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[432,"Zemītes 2.līnija","D",0.83,2000,24,{"$f":"VLOOKUP(F433,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[433,"Zemītes iela","D",0.83,2000,24,{"$f":"VLOOKUP(F434,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[434,"Ziediņu ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F435,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[435,"Ziedoņa iela","D",0.83,2000,24,{"$f":"VLOOKUP(F436,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[436,"Ziedu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F437,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[437,"Zileņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F438,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[438,"Zīles ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F439,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[439,"Zirgu ielas posms no Pasta ielas līdz Mātera ielai","C",1.65,2015,9,{"$f":"VLOOKUP(F440,[1]Koefic!$A$1:$B$40,2,FALSE)","v":2},3.3]
[440,"Zirgu ielas posms no Mātera ielas līdz Tērvetes ielai","C",1.65,2010,14,{"$f":"VLOOKUP(F441,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},1.65]
[441,"Zirgu ielas posms no Tērvetes ielas līdz Smilšu ielai","D",0.83,2020,4,{"$f":"VLOOKUP(F442,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[442,"Zirņu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F443,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[443,"Zvaigžņu iela","D",0.83,2019,5,{"$f":"VLOOKUP(F444,[1]Koefic!$A$1:$B$40,2,FALSE)","v":5},4.1499999999999995]
[444,"Zvanu iela","D",0.83,2000,24,{"$f":"VLOOKUP(F445,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]
[445,"Zvejnieku iela","B",2.48,2010,14,{"$f":"VLOOKUP(F446,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},2.48]
[446,"Žagaru ceļš","D",0.83,2000,24,{"$f":"VLOOKUP(F447,[1]Koefic!$A$1:$B$40,2,FALSE)","v":1},0.83]

{"sheet":"Koefic","index":3,"n_rows":40,"n_cols":2,"rows_kept":40,"hidden":true}
[0,5]
[1,5]
[2,5]
[3,5]
[4,5]
[5,5]
[6,2]
[7,2]
[8,2]
[9,2]
[10,2]
[11,1]
[12,1]
[13,1]
[14,1]
[15,1]
[16,1]
[17,1]
[18,1]
[19,1]
[20,1]
[21,1]
[22,1]
[23,1]
[24,1]
[25,1]
[26,1]
[27,1]
[28,1]
[29,1]
[30,1]
[31,1]
[32,1]
[33,1]
[34,1]
[35,1]
[36,1]
[37,1]
[38,1]
[39,1]