{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1-5","6-7","TallinnTroll","Design TallinnBus","Design EST"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1-5","index":0,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,3,4,3],[3,2,4,2],[19,2,22,2],[12,2,14,2],[24,2,25,2],[16,0,17,0],[19,0,22,0],[9,2,10,2],[16,2,17,2],[24,0,25,0],[2,0,2,1],[3,0,4,0],[3,1,4,1],[9,0,10,0],[12,0,14,0]]}
["RP SIA \"Rīgas satiksme\""]
["Nakts dežūrsatiksme",null,"darba dienā"]
[]
["Maršr.Nr","Maršruta nosaukums","Autobusu skaits","Noskrējiens, km",20,20]
[]
["x162","6. AP - Zolitūde - Āgenskalns  - 2.TP",1,171.92400000000001]
["x163","6. AP - Abrenes iela",1,130.88399999999999]
["x164","6. AP - Bolderāja",1,147.88800000000001]
["x165","6. AP - Zolitūde - Abrenes iela",1,122.97799999999999]
["x166","6. AP - Zolitūde - Mārupe - Ziepniekkalns - Abrenes iela",1,87.658000000000001]
[null,"Papildus nobraukums, ja 1.braucienā brauc līdz Mārupes novada domei",null,2.379]
["x167","6. AP - Iļģuciems - Abrenes iela",1,37.933999999999997]
["x171","7. AP - Purvciems - 1. TP",1,143.39500000000001]
[null,"Papildus nobraukums, ja 1.braucienā brauc stacijai \"Vecdaugava\"",null,5.9]
[null,"Papildus nobraukums, ja 4.braucienā brauc līdz Tralleru ielai Mangaļsalā",null,8.9000000000000057]
["x172","7. AP - Mežciems - Jugla - Abrenes iela",1,128.17900085449219]
["x173","7. AP - Ķengarags -3. TD - Abrenes iela",1,{"$f":"138.583-D18","v":135.56299999999999}]
[null,"Papildus nobraukums, ja 4. ,5.braucienā līdz Līvzemes/Gaismas ielai Salaspilī",null,3.02]
["x174","7. AP - Čiekurkalns - 5. TD - Abrenes iela",1,114.38]
["x175","7. AP - Pļavnieki",1,125.825]
[null,"Papildus nobraukums, ja 1.braucienā brauc pa Pērnavas, A.Deglava ielu",null,0.75]
[null,"Papildus nobraukums, ja 3.braucienā brauc pa Pērnavas, A.Deglava ielu",null,0.75]
[null,"Papildus nobraukums, ja 4.braucienā brauc pa Matīsa, Valmieras, Lienes ielu",null,0.93800000000000239]
["x177","7. AP - Vecmīlgrāvis - 7. AP",1,107.547]
["x178","7. AP - Valdlauči - Ziepniekkalns - Abrenes iela",1,135.893]
[null,"Papildus nobraukums, ja 4. un 5.braucienā brauc līdz Upesciemam",null,8.4210000000000207]
[null,"Kopā TL:",{"$f":"SUM(C6:C26)","v":13}]
[null,"Ar sarkanu norādīts papildus nobraukums, kas jāpieskaita pamatnobraukumam, ja tiek veikts brauciens pēc pieprasījuma"]
[]
[null,null,"Nobraukums pamata maršrutos:",{"$f":"D6+D7+D8+D9+D10+D12+D13+D16+D17+D19+D20+D24+D25","v":1590.0480008544921}]
[null,null,"Nobraukums maršrutos pēc pieprasījuma:",{"$f":"D11+D14+D15+D18+D21+D22+D23+D26","v":31.058000000000028}]
[null,null,"Nobraukums kopā:",{"$f":"D31+D30","v":1621.1060008544921}]

{"sheet":"6-7","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,3,4,3],[3,2,4,2],[12,2,14,2],[19,2,22,2],[16,0,17,0],[19,0,22,0],[9,2,10,2],[16,2,17,2],[24,0,25,0],[24,2,25,2],[2,0,2,1],[3,0,4,0],[3,1,4,1],[9,0,10,0],[12,0,14,0]]}
["RP SIA \"Rīgas satiksme\""]
["Nakts dežūrsatiksme",null,"brīvdienā"]
[]
["Maršr.Nr","Maršruta nosaukums","Autobusu skaits","Noskrējiens, km",20,20]
[]
["x162","6. AP - Zolitūde - Āgenskalns  - 2.TP",1,190.73199462890625]
["x163","6. AP - Abrenes iela",1,161.69399999999999]
["x164","6. AP - Bolderāja",1,163.90799999999999]
["x165","6. AP - Zolitūde - Abrenes iela",1,143.47300000000001]
["x166","6. AP - Zolitūde - Mārupe - Ziepniekkalns - Abrenes iela",1,122.911]
[null,"Papildus nobraukums, ja 1.braucienā brauc līdz Mārupes novada domei",null,2.379]
["x167","6. AP - Iļģuciems - Abrenes iela",1,37.933999999999997]
["x171","7. AP - Purvciems - 1. TP",1,176.005]
[null,"Papildus nobraukums, ja 1.braucienā brauc stacijai \"Vecdaugava\"",null,5.9]
[null,"Papildus nobraukums, ja 4.braucienā brauc līdz Tralleru ielai Mangaļsalā",null,8.9000000000000057]
["x172","7. AP - Mežciems - Jugla - Abrenes iela",1,157.59700012207031]
["x173","7. AP - Ķengarags -3. TD - Abrenes iela",1,157.59799999999998]
[null,"Papildus nobraukums, ja 4.braucienā līdz Līvzemes/Gaismas ielai Salaspilī",null,3.02]
["x174","7. AP - Čiekurkalns - 5. TD - Abrenes iela",1,136.107]
["x175","7. AP - Pļavnieki",1,155.68199999999999]
[null,"Papildus nobraukums, ja 1.braucienā brauc pa Pērnavas, A.Deglava ielu",null,0.75]
[null,"Papildus nobraukums, ja 3.braucienā brauc pa Pērnavas, A.Deglava ielu",null,0.75]
[null,"Papildus nobraukums, ja 4.braucienā brauc pa Matīsa, Valmieras, Lienes ielu",null,0.93800000000000239]
["x177","7. AP - Vecmīlgrāvis - 7. AP",1,134.25299999999999]
["x178","7. AP - Valdlauči - Ziepniekkalns - Abrenes iela",1,169.84200000000001]
[null,"Papildus nobraukums, ja 4. un 5.braucienā brauc līdz Upesciemam",null,8.4210000000000207]
[null,"Kopā TL:",{"$f":"SUM(C6:C26)","v":13}]
[null,"Ar sarkanu norādīts papildus nobraukums, kas jāpieskaita pamatnobraukumam, ja tiek veikts brauciens pēc pieprasījuma"]
[]
[null,null,"Nobraukums pamata maršrutos:",{"$f":"D6+D7+D8+D9+D10+D12+D13+D16+D17+D19+D20+D24+D25","v":1907.7359947509767}]
[null,null,"Nobraukums maršrutos pēc pieprasījuma:",{"$f":"D11+D14+D15+D18+D21+D22+D23+D26","v":31.058000000000028}]
[null,null,"Nobraukums kopā:",{"$f":"D31+D30","v":1938.7939947509767}]

{"sheet":"TallinnTroll","index":2,"n_rows":21,"n_cols":27,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,7,1,23],[4,3,4,6],[4,7,4,10],[4,2,5,2],[4,15,4,17],[3,2,3,26],[15,1,15,2],[4,22,4,24],[4,11,4,14],[4,26,5,26],[4,18,4,21],[4,25,5,25],[3,1,5,1]]}
[]
[null,"Trolli plaanilised näitajad",null,null,null,null,null,"Tallinna Trammi-ja Trollibussikoondise AS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"alates:","01.06.2006.a."]
[]
[null," Liini nr",{"$f":"IF([1]!pikasKeywords()=\"6\",\"Laupäev\",IF([1]!pikasKeywords()=\"7\",\"Pühapäev\",\"Tööpäev\"))","v":"Tööpäev"}]
[null,null," Kehtib alates","Masinpäevad",null,null,null,"Veootsade arv",null,null,null,"Liiniläbisõit",null,null,null," Liinitunnid",null,null,"Üldläbisõit",null,null,null,"Üldtunnid",null,null,"Eksp. kiirus "," Kkm"]
[null,null,null," Normaal"," Liigend"," Haagis"," Kokku"," Normaal"," Liigend"," Haagis"," Kokku"," Normaal"," Liigend"," Haagis"," Kokku"," Normaal"," Liigend"," Kokku"," Normaal"," Liigend"," Haagis"," Kokku"," Normaal"," Liigend"," Kokku"]
[null,{"$f":"[1]!pikasRoute()","v":""},{"$f":"[1]!pikasDate()","v":""},{"$f":"[1]!pikasRouteShifts(\"N\")","v":0},{"$f":"[1]!pikasRouteShifts(\"L\")","v":0},{"$f":"[1]!pikasRouteShifts(\"H\")","v":0},{"$f":"[1]!pikasRouteShifts()","v":0},{"$f":"K7-J7-I7","v":0},{"$f":"[1]!pikasRouteTrips(\"L\")","v":0},{"$f":"[1]!pikasRouteTrips(\"H\")","v":0},{"$f":"[1]!pikasRouteTrips()","v":0},{"$f":"O7-N7-M7","v":0},{"$f":"ROUND([1]!pikasRouteKm(\"L\"),2)","v":0},{"$f":"ROUND([1]!pikasRouteKm(\"H\"),2)","v":0},{"$f":"ROUND([1]!pikasRouteKm(),2)","v":0},{"$f":"R7-Q7","v":0},{"$f":"[1]!pikasRouteDuration(\"L\")/60","v":0},{"$f":"[1]!pikasRouteDuration()/60","v":0},{"$f":"V7-U7-T7","v":0},{"$f":"ROUND([1]!pikasRouteKm(\"L\",\"+0\"),2)","v":0},{"$f":"ROUND([1]!pikasRouteKm(\"H\"),2)","v":0},{"$f":"ROUND([1]!pikasRouteKm(\"*\",\"+0\"),2)","v":0},{"$f":"Y7-X7","v":0},{"$f":"[1]!pikasRouteDuration(\"L\",\"+0\")/60","v":0},{"$f":"[1]!pikasRouteDuration(,\"+0\")/60","v":0},{"$f":"O7/R7","v":{"$error":"#DIV/0!"}},{"$f":"[1]!pikasRouteCapacityKm()","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"KOKKU:",null,{"$f":"SUM(D7:D15)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(L16:N16)","v":0},{"$f":"SUM(P7:P15)","v":0},0,0,0,0,0,{"$f":"SUM(S16:U16)","v":0},{"$f":"SUM(W7:W15)","v":0},{"$f":"SUM(X7:X15)","v":0},{"$f":"SUM(Y7:Y15)","v":0},{"$f":"O16/R16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA7:AA15)","v":0}]
[]
[null,null,"Liikluse planeerimise ja järelvalve"]
[null,null,"osakonna juhataja"]
[]
[null,null," \"…….\" ………………………. 200…."]

{"sheet":"Design TallinnBus","index":3,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":true,"merged":[[4,17,5,17],[17,6,17,10],[3,1,5,1],[15,1,15,2],[4,18,5,18],[3,2,3,18],[4,3,4,6],[4,7,4,10],[4,16,5,16],[4,2,5,2],[4,11,4,15]]}
[]
[null,"LIINIDE PLAANID",null,null,null,null,null,null,"Tallinna Autobussikoondise AS",null,null,null,null,null,null,"alates:","01.06.2006.a."]
[]
[null," Liini nr",{"$f":"IF([1]!pikasKeywords()=\"6\",\"Laupäev\",IF([1]!pikasKeywords()=\"7\",\"Pühapäev\",\"Tööpäev\"))","v":"Tööpäev"}]
[null,null," Kehtib alates","Masinpäevad",null,null,null,"Veootsade arv",null,null,null,"Liiniläbisõit",null,null,null,null," Liinitunnid","Tunnid"," Kkm"]
[null,null,null," Normaal"," Liigend"," Haagis"," Kokku"," Normaal"," Liigend"," Haagis"," Kokku"," Normaal"," Liigend"," Haagis"," Kokku","Outside Tallinn"]
[null,{"$f":"[1]!pikasRoute()","v":""},{"$f":"[1]!pikasDate()","v":""},{"$f":"[1]!pikasRouteShifts(\"N\")","v":0},{"$f":"[1]!pikasRouteShifts(\"L\")","v":0},{"$f":"[1]!pikasRouteShifts(\"H\")","v":0},{"$f":"[1]!pikasRouteShifts()","v":0},{"$f":"K7-J7-I7","v":0},{"$f":"[1]!pikasRouteTrips(\"L\")","v":0},{"$f":"[1]!pikasRouteTrips(\"H\")","v":0},{"$f":"[1]!pikasRouteTrips()","v":0},{"$f":"O7-N7-M7","v":0},{"$f":"ROUND([1]!pikasRouteKm(\"L\"),2)","v":0},{"$f":"ROUND([1]!pikasRouteKm(\"H\"),2)","v":0},{"$f":"ROUND([1]!pikasRouteKm(),2)","v":0},{"$f":"ROUND([1]!pikasKm(,\"-0; (num Like '[3456789]???*')\"),2)","v":0},{"$f":"[1]!pikasRouteDuration()/(24*60)","v":0},{"$f":"[1]!pikasRouteDuration(,\"+0\")/(24*60)","v":0},{"$f":"[1]!pikasRouteCapacityKm()","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"KOKKU:",null,{"$f":"SUM(D7:D15)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(L16:N16)","v":0},{"$f":"SUM(P7:P15)","v":0},{"$f":"SUM(Q7:Q15)","v":0},{"$f":"SUM(R7:R15)","v":0},{"$f":"SUM(S7:S15)","v":0}]
[]
[null,null,{"$f":"C4 & \"ad:\"","v":"Tööpäevad:"},1,null,"Km:",{"$f":"D18*O16","v":0}]
[]
[null,null," …………………………pargi",null,null,null,null,null,null,null,null,"Tallinna Transpordiameti"]
[null,null,"direktori asetaitja liikluse alal",null,null,null,null,null,null,null,null,"reisijateveo peaspetsialist"]
[]
[null,null," \"…….\" ………………………. 200….",null,null,null,null,null,null,null,null," \"…….\" ………………………. 200…."]

{"sheet":"Design EST","index":4,"n_rows":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":true,"merged":[[4,14,4,15],[6,1,8,1],[18,1,18,2],[7,17,8,17],[6,2,6,17],[7,3,7,6],[7,7,7,10],[7,16,8,16],[7,2,8,2],[7,11,7,15]]}
[]
[null,null,null,null,null,null,null,null,null,"LISA 6 Tallinna Transpordiameti-ja Tallinna Trammi-ja Trollibussikonndise AS"]
[null,null,null,null,null,null,null,null,null,"vahel …….a solmitud lepingu nr ….. Juurde"]
[null,"Tallinna Trammi-ja Trollibussikoondise AS"]
[null,null,null,null,null,null,null,null,null,"Liinitöö näitajad",null,null,null,null,"alates:",null,"01.09.2000.a."]
[]
[null," Liini nr",{"$f":"IF([1]!pikasKeywords()=\"6\",\"Laupäev\",IF([1]!pikasKeywords()=\"7\",\"Pühapäev\",\"Tööpäev\"))","v":"Tööpäev"}]
[null,null," Kehtib alates","Masinpäevad",null,null,null,"Veootsade arv",null,null,null,"Liiniläbisõit",null,null,null,null," Liinitunnid"," Kkm"]
[null,null,null," Normaal"," Liigend"," Haagis"," Kokku"," Normaal"," Liigend"," Haagis"," Kokku"," Normaal"," Liigend"," Haagis"," Kokku","Outside Tallinn"]
[null,{"$f":"[1]!pikasRoute()","v":""},{"$f":"[1]!pikasDate()","v":""},{"$f":"[1]!pikasShifts(\"N\")","v":0},{"$f":"[1]!pikasShifts(\"L\")","v":0},{"$f":"[1]!pikasShifts(\"H\")","v":0},{"$f":"[1]!pikasShifts()","v":0},{"$f":"[1]!pikasTrips(\"N\",\"-0,A>B,B>A\")","v":0},{"$f":"[1]!pikasTrips(\"L\",\"-0,A>B,B>A\")","v":0},{"$f":"[1]!pikasTrips(\"H\",\"-0,A>B,B>A\")","v":0},{"$f":"[1]!pikasTrips(\"*\",\"-0,A>B,B>A\")","v":0},{"$f":"[1]!pikasKm(\"N\",\"-0\")","v":0},{"$f":"[1]!pikasKm(\"L\",\"-0\")","v":0},{"$f":"[1]!pikasKm(\"H\",\"-0\")","v":0},{"$f":"SUM(L10:N10)","v":0},{"$f":"[1]!pikasKm(,\"-0; (num Like '[23456789]???*')\")","v":0},{"$f":"[1]!pikasDuration(\"*\",\"-0\")/60","v":0},{"$f":"[1]!pikasCapacityKm(\"*\",\"-0\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"KOKKU:",null,{"$f":"SUM(D10:D18)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(L19:N19)","v":0},{"$f":"SUM(P10:P18)","v":0},{"$f":"SUM(Q10:Q18)","v":0},{"$f":"SUM(R10:R18)","v":0}]
[]
[null,null," …………………………pargi",null,null,null,null,null,null,null,null,"Tallinna Transpordiameti"]
[null,null,"direktori asetaitja liikluse alal",null,null,null,null,null,null,null,null,"reisijateveo peaspetsialist"]
[]
[null,null," \"…….\" ………………………. 200….",null,null,null,null,null,null,null,null," \"…….\" ………………………. 200…."]