{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Nobraukuma žurnāls","Žurnāla dati","Aprēķini"],"not_rendered":{"charts":1,"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Nobraukuma žurnāls","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"merged":[[0,1,1,6]]}
[null,"NOBRAUKUMA ŽURNĀLS"]
{"$rows_empty":9}
[null,null,"KOMPENSĒJAMIE",null,"KOPĒJĀ"]
[null,null,"KILOMETRI",null,"KOMPENSĀCIJA"]
[]
[]
[]
[]
[null,null,"2012-05-01",null,"2012-05-10"]
[]
[null,null,"PERIODS",null,"PERIODS"]
[null,null,"SĀKUMS",null,"BEIGAS"]
[]
[]
[]
[]
[]
[null,null,54,null,{"v":9800,"d":"9,800"}]
[]
[null,null,"KOMPENSĀCIJA",null,"IEPRIEKŠĒJAIS DEGVIELAS"]
[null,null,"l/km",null,"ODOMETRA RĀDĪJUMS"]

{"sheet":"Žurnāla dati","index":1,"n_rows":19,"n_cols":15,"rows_kept":19,"merged":[[0,1,1,4]]}
[null,"NOBRAUKUMA ŽURNĀLS"]
[{"$nulls":14}," "]
[]
[]
[null,"DATUMS","DARBĪBA","ODOM. 1","ATRAŠANĀS VIETA","ODOM. 2","MĒRĶIS","KOMPENSĒT","LITRI","IZMAKSAS","KILOMETRI","l/km","LITRI/KM","PIEZĪMES"]
[null,"2012-05-01","Brauciens",{"v":10123,"d":"10,123"},"Rožu iela",{"v":10130,"d":"10,130"},null,null,15.56,{"v":64.11,"d":"64.11 €"},{"$f":"Kilometri","v":7},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]
[null,"2012-05-01","Brauciens",{"v":10130,"d":"10,130"},"Birojs",{"v":10200,"d":"10,200"},"Augļu iela","Jā",null,"",{"$f":"Kilometri","v":70},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]
[null,"2012-05-01","Brauciens",{"v":10200,"d":"10,200"},"Tirgus",{"v":10285,"d":"10,285"},"Birojs","Jā",null,"",{"$f":"Kilometri","v":85},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]
[null,"2012-05-02","Brauciens",{"v":10285,"d":"10,285"},"Birojs",{"v":10450,"d":"10,450"},"Viesu nams","Jā",null,"",{"$f":"Kilometri","v":165},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]
[null,"2012-05-02","Degviela",{"v":10450,"d":"10,450"},"Benzīntanks",{"$nulls":3},{"v":11.2,"d":"11.20"},{"v":55.42,"d":"55.42 €"},{"$f":"Kilometri","v":650},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":{"v":58.03571428571429,"d":"58.0"}},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":{"v":8.526153846153846,"d":"8.5"}}]
[null,"2012-05-02","Brauciens",{"v":10500,"d":"10,500"},"Viesu nams",{"v":10518,"d":"10,518"},"Birojs","Jā",null,"",{"$f":"Kilometri","v":18},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]
[null,"2012-05-03","Brauciens",{"v":10518,"d":"10,518"},"Birojs",{"v":10745,"d":"10,745"},"Birojs","Jā",null,"",{"$f":"Kilometri","v":227},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]
[null,"2012-05-04","Degviela",{"v":10745,"d":"10,745"},"Rožu iela",{"$nulls":3},{"v":16.6,"d":"16.60"},{"v":69.24,"d":"69.24 €"},{"$f":"Kilometri","v":295},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":{"v":17.771084337349397,"d":"17.8"}},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":{"v":23.471186440677965,"d":"23.5"}}]
[null,"2012-05-04","Brauciens",{"v":10745,"d":"10,745"},"Birojs",{"v":10800,"d":"10,800"},"Sigulda","Jā",null,"",{"$f":"Kilometri","v":55},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]
[null,"2012-05-04","Brauciens",{"v":10800,"d":"10,800"},"Sigulda",{"v":10875,"d":"10,875"},"Birojs","Jā",null,"",{"$f":"Kilometri","v":75},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]
[null,"2012-05-07","Brauciens",{"v":10875,"d":"10,875"},"Birojs",{"v":10921,"d":"10,921"},"Augļu iela","Jā",null,"",{"$f":"Kilometri","v":46},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]
[null,"2012-05-07","Brauciens",{"v":10921,"d":"10,921"},"Tirgus",{"v":10969,"d":"10,969"},"Birojs","Jā",null,"",{"$f":"Kilometri","v":48},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]
[null,"2012-05-09","Brauciens",{"v":10969,"d":"10,969"},"Birojs",{"v":11000,"d":"11,000"},"Jūrmala","Jā",null,"",{"$f":"Kilometri","v":31},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]
[null,"2012-05-09","Brauciens",{"v":11000,"d":"11,000"},"Jūrmala",{"v":11100,"d":"11,100"},"Mājas","Nē",null,"",{"$f":"Kilometri","v":100},{"$f":"IF(OR(LEN(Dati[[#This Row],[ODOM. 2]]),Dati[[#This Row],[ODOM. 1]]=\"\"),\"\",IFERROR(Dati[[#This Row],[KILOMETRI]]/Dati[[#This Row],[LITRI]],\"\"))","v":""},{"$f":"IF(Dati[[#This Row],[l/km]]=\"\",\"\",100*Dati[[#This Row],[IZMAKSAS]]/Dati[[#This Row],[KILOMETRI]])","v":""}]

{"sheet":"Aprēķini","index":2,"n_rows":69,"n_cols":13,"rows_kept":69,"hidden":true}
["*** Šī lapa paliek paslēpta ***"]
[]
[]
[]
[]
[{"$nulls":8},{"$f":"OFFSET(I9,,otrāAss=\"degvielas izmaksas\")","v":"l/km"}]
[{"$nulls":12},2]
[{"$nulls":7},"Brauciens","Degviela","Degviela",null,"Otrā ass:  ",{"$f":"REPT(\"l/km\",M7=1)&REPT(\"Degvielas Izmaksas\",M7=2)","v":"Degvielas Izmaksas"}]
[{"$nulls":7},"Nobrauktie kilometri","l/km","l/km"]
[null,null,"Kompensējamie kilometri:  ",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[KOMPENSĒT],\"Jā\",Dati[DATUMS],\">=\"&periodsSākums,Dati[DATUMS],\"<=\"&periodsBeigas)","v":820},null,1,{"$f":"periodsSākums","v":"2012-05-01"},{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G10,Dati[DARBĪBA],$H$8)","v":162},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G10,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G10,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[null,null,"Kopējā kompensācija:  ",{"$f":"D10*KompensācijaPaKilometriem/100","v":{"v":442.8,"d":"442.80 €"}},null,2,{"$f":"G10+1","v":"2012-05-02"},{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G11,Dati[DARBĪBA],$H$8)","v":183},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G11,Dati[DARBĪBA],$I$8),NA())","v":{"v":58.03571428571429,"d":"58.0"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G11,Dati[DARBĪBA],$J$8),NA())","v":{"v":8.526153846153846,"d":"8.5"}}]
[{"$nulls":5},3,"2012-05-03",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G12,Dati[DARBĪBA],$H$8)","v":227},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G12,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G12,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},4,"2012-05-04",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G13,Dati[DARBĪBA],$H$8)","v":130},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G13,Dati[DARBĪBA],$I$8),NA())","v":{"v":17.771084337349397,"d":"17.8"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G13,Dati[DARBĪBA],$J$8),NA())","v":{"v":23.471186440677965,"d":"23.5"}}]
[{"$nulls":5},5,"2012-05-05",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G14,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G14,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G14,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},6,"2012-05-06",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G15,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G15,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G15,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},7,"2012-05-07",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G16,Dati[DARBĪBA],$H$8)","v":94},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G16,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G16,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},8,"2012-05-08",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G17,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G17,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G17,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},9,"2012-05-09",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G18,Dati[DARBĪBA],$H$8)","v":131},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G18,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G18,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},10,"2012-05-10",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G19,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G19,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G19,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},11,"2012-05-11",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G20,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G20,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G20,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},12,"2012-05-12",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G21,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G21,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G21,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},13,"2012-05-13",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G22,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G22,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G22,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},14,"2012-05-14",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G23,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G23,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G23,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},15,"2012-05-15",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G24,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G24,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G24,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},16,"2012-05-16",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G25,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G25,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G25,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},17,"2012-05-17",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G26,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G26,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G26,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},18,"2012-05-18",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G27,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G27,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G27,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},19,"2012-05-19",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G28,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G28,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G28,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},20,"2012-05-20",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G29,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G29,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G29,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},21,"2012-05-21",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G30,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G30,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G30,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},22,"2012-05-22",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G31,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G31,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G31,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},23,"2012-05-23",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G32,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G32,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G32,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},24,"2012-05-24",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G33,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G33,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G33,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},25,"2012-05-25",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G34,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G34,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G34,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},26,"2012-05-26",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G35,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G35,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G35,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},27,"2012-05-27",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G36,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G36,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G36,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},28,"2012-05-28",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G37,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G37,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G37,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},29,"2012-05-29",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G38,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G38,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G38,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},30,"2012-05-30",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G39,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G39,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G39,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},31,"2012-05-31",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G40,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G40,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G40,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},32,"2012-06-01",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G41,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G41,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G41,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},33,"2012-06-02",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G42,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G42,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G42,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},34,{"$f":"G42+1","v":"2012-06-03"},{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G43,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G43,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G43,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},35,"2012-06-04",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G44,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G44,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G44,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},36,"2012-06-05",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G45,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G45,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G45,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},37,"2012-06-06",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G46,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G46,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G46,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},38,"2012-06-07",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G47,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G47,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G47,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},39,"2012-06-08",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G48,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G48,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G48,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},40,"2012-06-09",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G49,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G49,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G49,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},41,"2012-06-10",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G50,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G50,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G50,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},42,"2012-06-11",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G51,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G51,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G51,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},43,"2012-06-12",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G52,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G52,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G52,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},44,"2012-06-13",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G53,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G53,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G53,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},45,"2012-06-14",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G54,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G54,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G54,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},46,"2012-06-15",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G55,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G55,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G55,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},47,"2012-06-16",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G56,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G56,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G56,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},48,"2012-06-17",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G57,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G57,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G57,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},49,"2012-06-18",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G58,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G58,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G58,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},50,"2012-06-19",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G59,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G59,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G59,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},51,"2012-06-20",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G60,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G60,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G60,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},52,"2012-06-21",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G61,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G61,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G61,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},53,"2012-06-22",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G62,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G62,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G62,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},54,"2012-06-23",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G63,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G63,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G63,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},55,"2012-06-24",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G64,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G64,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G64,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},56,"2012-06-25",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G65,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G65,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G65,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},57,"2012-06-26",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G66,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G66,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G66,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},58,"2012-06-27",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G67,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G67,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G67,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},59,"2012-06-28",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G68,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G68,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G68,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},60,"2012-06-29",{"$f":"SUMIFS(Dati[KILOMETRI],Dati[DATUMS],G69,Dati[DARBĪBA],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(Dati[l/km],Dati[DATUMS],G69,Dati[DARBĪBA],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(Dati[LITRI/KM],Dati[DATUMS],G69,Dati[DARBĪBA],$J$8),NA())","v":{"$error":"#N/A"}}]