{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Июнь","Июль","ТС","Сотрудники"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Июнь","index":0,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,0,1,15],[2,0,2,15],[3,14,3,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Июнь",null,null,null,-2,null,null,null,"Экономия","Базовая норма расхода на 100 км","Базовая норма расхода на 1 мото/час"]
["Общество с ограниченной ответственностью  \"Втормет Царицыно\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-я пол.","2018-06-01","2018-06-15",{"$f":"ТС!E5","v":500},{"$f":"SUMIFS(Июнь[Выдано топливо, литр],Июнь[Дата],\">=\"&$S$2,Июнь[Дата],\"<=\"&$T$2)+IF(MONTH(T2)<>MONTH(S2),INDIRECT(TEXT(A7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT(A7-1,\"ММММ\")&\"!V1:V2\")))+SUMIFS($U$7:$U$37,Июнь[Дата],\">=\"&$S$2,Июнь[Дата],\"<=\"&$T$2)+IF(MONTH(T2)<>MONTH(S2),INDIRECT(TEXT(A7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT(A7-1,\"ММММ\")&\"!V1:V2\")))","v":920},{"$f":"IF(V2=0,0,(SUMIFS(N7:N37,A7:A37,\">=\"&S2,A7:A37,\"<=\"&T2)+SUMIFS(INDIRECT(TEXT(A7-1,\"ММММ\")&\"!N7:N37\"),INDIRECT(TEXT(A7-1,\"ММММ\")&\"!A7:A37\"),\">=\"&S2))/(V2-U2+IF(MONTH(T2)=MONTH(S2),G7,INDEX(INDIRECT(TEXT(A7-1,\"ММММ\")&\"!G7:G37\"),DAY(S2)))))","v":{"$error":"#REF!"}},{"$f":"SUMIFS(Июнь[Отклонение от нормы (Перерасход(+), экономия(-)), литр],Июнь[Дата],\">=\"&$S$2,Июнь[Дата],\"<=\"&$T$2)","v":71.348000000000013},{"$f":"IF(Y4=\"Зима\",VLOOKUP(Z4,Расчет[[Номер гос.регистрации / Заводской номер]:[Итога норма а/м \"ЛЕТО\"]],8,FALSE),VLOOKUP(Z4,Расчет[[Номер гос.регистрации / Заводской номер]:[Итога норма а/м \"ЛЕТО\"]],9,FALSE))","v":46.86},{"$f":"IF(Y4=\"Зима\",VLOOKUP(Z4,Расчет[[Номер гос.регистрации / Заводской номер]:[Итога норма а/м \"ЛЕТО\"]],13,FALSE),VLOOKUP(Z4,Расчет[[Номер гос.регистрации / Заводской номер]:[Итога норма а/м \"ЛЕТО\"]],14,FALSE))","v":5.5}]
["Отчет водителя ломовоза с манипулятором",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-я пол.",{"$f":"T2+1","v":"2018-06-16"},{"$f":"INDEX(Июнь[Дата],COUNT(Июнь[Дата]))-T1","v":"2018-07-02"},{"$f":"ТС!E6","v":500},{"$f":"SUMIFS(Июнь[Выдано топливо, литр],Июнь[Дата],\">=\"&$S$3,Июнь[Дата],\"<=\"&$T$3)+IF(MONTH(T3)<>MONTH(S3),SUMIFS(INDIRECT(TEXT(T3,\"ММММ\")&\"[Выдано топливо, литр]\"),INDIRECT(TEXT(T3,\"ММММ\")&\"[Дата]\"),\">=\"&$S$3,INDIRECT(TEXT(T3,\"ММММ\")&\"[Дата]\"),\"<=\"&$T$3))+SUMIFS($U$7:$U$37,Июнь[Дата],\">=\"&$S$3,Июнь[Дата],\"<=\"&$T$3)+IF(MONTH(T3)<>MONTH(S3),SUMIFS(INDIRECT(TEXT(T3,\"ММММ\")&\"!$U$7:$U$37\"),INDIRECT(TEXT(T3,\"ММММ\")&\"[Дата]\"),\">=\"&$S$3,INDIRECT(TEXT(T3,\"ММММ\")&\"[Дата]\"),\"<=\"&$T$3))","v":1110},{"$f":"(SUMIFS(Июнь[Расход топлива по норме, литр],Июнь[Дата],\">=\"&$S$3,Июнь[Дата],\"<=\"&$T$3)+IF(MONTH(T3)<>MONTH(S3),SUMIFS(INDIRECT(TEXT(T3,\"ММММ\")&\"[Расход топлива по норме, литр]\"),INDIRECT(TEXT(T3,\"ММММ\")&\"[Дата]\"),\">=\"&$S$3,INDIRECT(TEXT(T3,\"ММММ\")&\"[Дата]\"),\"<=\"&$T$3)))/(V3-U3+IF(MONTH($T$3)=MONTH($S$3),$G$7,INDEX(INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!$G$7:$G$37\"),DAY($S$3))))","v":{"$error":"#REF!"}},{"$f":"SUMIFS(Июнь[Отклонение от нормы (Перерасход(+), экономия(-)), литр],Июнь[Дата],\">=\"&$S$3,Июнь[Дата],\"<=\"&$T$3)","v":-27.518999999999977}]
[null,null,null,null,null,null,null,"за",2018,null,null,null,null,null,"т 056 вв 197",null,null,null,{"$f":"IF(INDEX(Июнь[Дата],COUNT(Июнь[Дата]))=T3,\"\",T3+1)","v":"2018-07-03"},null,null,null,{"$f":"IFERROR(IF(S4=\"\",\"\",INDIRECT(TEXT(A7+40,\"ММММ\")&\"!W2\")),)","v":1.9057656612529001},null,"Лето","Норма 1"]
[]
["Дата","ФИО водителя","Показание одометра машины на начало дня, км","Показание одометра машины на конец дня, км","Пройдено за день, км","Выдано топливо, литр","Остаток топлива в баке на начало дня, литр","Показание счетчика моточасов спецоборудования на начало дня, м/ч","Показание счетчика моточасов  спецоборудования на конец дня, м/ч","Работа спецоборудования за день, м/ч","Количество ходок","Расход топлива на работу спецоборудования, литр","Остаток топлива в баке на конец дня, литр","Расход топлива по норме, литр","Фактический расход топлива, литр","Отклонение от нормы (Перерасход(+), экономия(-)), литр",null,"Дата","Обнуление одометра, км","Пройдено за день, км","Выдано топливо, литр","Обнуление счетчика моточасов спецоборудования, м/ч","Работа спецоборудования за день, м/ч","Расход топлива по норме, литр","Фактический расход топлива, литр","Дата"]
["2018-06-01","Малышев О.С.",216988,217041,53,0,500,848,852,4,3,22,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":449},46.835999999999999,51,4.1640000000000015,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-01"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-01"}]
["2018-06-02",null,217041,217041,0,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M7)","v":449},852,852,0,null,0,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":449},0,0,0,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-02"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-02"}]
["2018-06-03","Малышев О.С.",217041,217085,44,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M8)","v":449},852,857,5,3,27.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":397},48.118000000000002,52,3.8819999999999979,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-03"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-03"}]
["2018-06-04","Малышев О.С.",217085,217137,52,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M9)","v":397},857,862,5,3,27.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":341},51.866999999999997,56,4.1330000000000027,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-04"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-04"}]
["2018-06-05","Малышев О.С.",217137,217217,80,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M10)","v":341},862,864,2,1,11,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":288},48.488,53,4.5120000000000005,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-05"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-05"}]
["2018-06-06","Малышев О.С.",217217,217380,163,200,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M11)","v":288},864,865,1,2,5.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":399},81.882000000000005,89,7.117999999999995,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-06"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-06"}]
["2018-06-07","Малышев О.С.",217380,217484,104,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M12)","v":399},865,869,4,3,22,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":322},70.733999999999995,77,6.2660000000000053,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-07"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-07"}]
["2018-06-08","Малышев О.С.",217484,217590,106,250,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M13)","v":322},869,873,4,2,22,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":494},71.671999999999997,78,6.328000000000003,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-08"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-08"}]
["2018-06-09","Малышев О.С.",217590,217770,180,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M14)","v":494},873,875,2,2,11,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":391},95.347999999999999,103,7.652000000000001,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-09"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-09"}]
["2018-06-10","Малышев О.С.",217770,217843,73,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M15)","v":391},875,879,4,3,22,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":330},56.207999999999998,61,4.7920000000000016,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-10"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-10"}]
["2018-06-11","Малышев О.С.",217843,217960,117,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M16)","v":330},879,884,5,4,27.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":241},82.325999999999993,89,6.6740000000000066,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-11"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-11"}]
["2018-06-12","Малышев О.С.",217960,218091,131,300,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M17)","v":241},884,887,3,3,16.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":457},77.887,84,6.1129999999999995,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-12"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-12"}]
["2018-06-13","Малышев О.С.",218091,218157,66,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M18)","v":457},887,890,3,3,16.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":406},47.427999999999997,51,3.5720000000000027,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-13"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-13"}]
["2018-06-14",null,218157,218157,0,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M19)","v":406},890,890,0,null,0,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":406},0,0,0,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-14"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-14"}]
["2018-06-15","Малышев О.С.",218157,218273,116,170,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M20)","v":406},890,893,3,2,16.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":500},70.858000000000004,77,6.1419999999999959,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-15"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-15"}]
["2018-06-16","Кобалян М.В.",218273,218364,91,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M21)","v":500},893,896,3,3,16.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":442},59.143000000000001,58,-1.1430000000000007,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-16"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-16"}]
["2018-06-17","Кобалян М.В.",218364,218539,175,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M22)","v":442},896,901,5,3,27.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":335},109.505,107,-2.5049999999999955,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-17"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-17"}]
["2018-06-18","Кобалян М.В.",218539,218634,95,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M23)","v":335},901,905,4,4,22,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":270},66.516999999999996,65,-1.5169999999999959,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-18"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-18"}]
["2018-06-19","Кобалян М.В.",218634,218755,121,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M24)","v":270},905,909,4,3,22,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":193},78.700999999999993,77,-1.7009999999999934,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-19"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-19"}]
["2018-06-20","Кобалян М.В.",218755,218930,175,300,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M25)","v":193},909,913,4,3,22,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":392},104.005,101,-3.0049999999999955,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-20"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-20"}]
["2018-06-21","Кобалян М.В.",218930,219101,171,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M26)","v":392},913,917,4,4,22,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":293},102.131,99,-3.1310000000000002,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-21"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-21"}]
["2018-06-22","Кобалян М.В.",219101,219280,179,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M27)","v":293},917,920,3,4,16.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":195},100.379,98,-2.3790000000000049,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-22"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-22"}]
["2018-06-23","Кобалян М.В.",219280,219393,113,270,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M28)","v":195},920,924,4,4,22,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":392},74.951999999999998,73,-1.9519999999999982,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-23"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-23"}]
["2018-06-24","Кобалян М.В.",219393,219472,79,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M29)","v":392},924,927,3,3,16.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":340},53.518999999999998,52,-1.5189999999999984,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-24"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-24"}]
["2018-06-25","Кобалян М.В.",219472,219537,65,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M30)","v":340},927,930,3,2,16.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":294},46.959000000000003,46,-0.95900000000000318,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-25"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-25"}]
["2018-06-26","Кобалян М.В.",219537,219638,101,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M31)","v":294},930,934,4,3,22,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":226},69.328999999999994,68,-1.3289999999999935,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-26"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-26"}]
["2018-06-27","Кобалян М.В.",219638,219718,80,260,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M32)","v":226},934,939,5,2,27.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":423},64.988,63,-1.9879999999999995,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-27"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-27"}]
["2018-06-28","Кобалян М.В.",219718,219840,122,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M33)","v":423},939,941,2,2,11,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":357},68.168999999999997,66,-2.1689999999999969,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-28"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-28"}]
["2018-06-29","Кобалян М.В.",219840,219920,80,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M34)","v":357},941,944,3,2,16.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":304},53.988,53,-0.98799999999999955,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-29"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-29"}]
["2018-06-30","Кобалян М.В.",219920,220024,104,0,{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M35)","v":304},944,945,1,1,5.5,{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":251},54.234000000000002,53,-1.2340000000000018,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-30"},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":"2018-06-30"}]
["",null,"",null,"","",{"$f":"IF(Июнь[[#This Row],[Дата]]=\"\",\"\",M36)","v":""},"",null,"",null,"",{"$f":"IFERROR(IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))),\"\")","v":""},"","","",null,{"$f":"Июнь[[#This Row],[Дата]]","v":""},null,null,null,null,null,null,null,{"$f":"Июнь[[#This Row],[Дата]]","v":""}]
["Итог",null,null,null,{"$f":"SUBTOTAL(109,[Пройдено за день, км])","v":3036},{"$f":"SUBTOTAL(109,[Выдано топливо, литр])","v":1750},null,null,null,{"$f":"SUBTOTAL(109,[Работа спецоборудования за день, м/ч])","v":97},{"$f":"SUBTOTAL(109,[Количество ходок])","v":77},{"$f":"SUBTOTAL(109,[Расход топлива на работу спецоборудования, литр])","v":533.5},null,{"$f":"SUBTOTAL(109,[Расход топлива по норме, литр])","v":1956.1710000000003},{"$f":"SUBTOTAL(109,[Фактический расход топлива, литр])","v":2000},{"$f":"SUBTOTAL(109,[Отклонение от нормы (Перерасход(+), экономия(-)), литр])","v":43.829000000000036},null,"1-я пол.",{"$f":"SUMIFS(S$7:S$37,INDIRECT(\"Июнь[Дата]\"),\">=\"&$S$2,INDIRECT(\"Июнь[Дата]\"),\"<=\"&$T$2)+IF(MONTH($T$2)<>MONTH($S$2),INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!V1:V2\")))","v":0},{"$f":"SUMIFS(T$7:T$37,INDIRECT(\"Июнь[Дата]\"),\">=\"&$S$2,INDIRECT(\"Июнь[Дата]\"),\"<=\"&$T$2)+IF(MONTH($T$2)<>MONTH($S$2),INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!V1:V2\")))","v":0},0,0,0,0,0,"1-я пол."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(K7:K37,A7:A37,\">=\"&$S$2,A7:A37,\"<=\"&$T$2)","v":34},null,null,null,null,null,null,"2-я пол.",{"$f":"SUMIFS(S$7:S$37,INDIRECT(\"Июнь[Дата]\"),\">=\"&$S$3,INDIRECT(\"Июнь[Дата]\"),\"<=\"&$T$3)+IF(MONTH($T$3)<>MONTH($S$3),INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!V1:V2\")))","v":{"$error":"#REF!"}},{"$f":"SUMIFS(T$7:T$37,INDIRECT(\"Июнь[Дата]\"),\">=\"&$S$3,INDIRECT(\"Июнь[Дата]\"),\"<=\"&$T$3)+IF(MONTH($T$3)<>MONTH($S$3),INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!V1:V2\")))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"2-я пол."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(K7:K37,A7:A37,\">=\"&$S$3,A7:A37,\"<=\"&$T$3)","v":43}]

{"sheet":"Июль","index":1,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,0,1,15],[2,0,2,15],[3,14,3,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Июль",null,null,null,null,null,null,null,"Экономия","Базовая норма расхода на 100 км","Базовая норма расхода на 1 мото/час"]
["Общество с ограниченной ответственностью  \"Втормет Царицыно\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-я пол.",{"$f":"INDIRECT(TEXT(A7-1,\"ММММ\")&\"!T3\")+1","v":"2018-07-03"},"2018-07-16",{"$f":"ТС!E5","v":500},{"$f":"SUMIFS(Июль[Выдано топливо, литр],Июль[Дата],\">=\"&$S$2,Июль[Дата],\"<=\"&$T$2)+IF(MONTH(T2)<>MONTH(S2),INDIRECT(TEXT(A7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT(A7-1,\"ММММ\")&\"!V3:V2\")))+SUMIFS($U$7:$U$37,Июль[Дата],\">=\"&$S$2,Июль[Дата],\"<=\"&$T$2)+IF(MONTH(T2)<>MONTH(S2),INDIRECT(TEXT(A7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT(A7-1,\"ММММ\")&\"!V3:V2\")))","v":680},{"$f":"IF(V2=0,0,(SUMIFS(N7:N37,A7:A37,\">=\"&S2,A7:A37,\"<=\"&T2)+SUMIFS(INDIRECT(TEXT(A7-1,\"ММММ\")&\"!N7:N37\"),INDIRECT(TEXT(A7-1,\"ММММ\")&\"!A7:A37\"),\">=\"&S2))/(V2-U2+IF(MONTH(T2)=MONTH(S2),G7,INDEX(INDIRECT(TEXT(A7-1,\"ММММ\")&\"!G7:G37\"),DAY(S2)))))","v":1.9057656612529001},{"$f":"SUMIFS(Июль[Отклонение от нормы (Перерасход(+), экономия(-)), литр],Июль[Дата],\">=\"&$S$2,Июль[Дата],\"<=\"&$T$2)","v":-391.38499999999999},{"$f":"IF(Y4=\"Зима\",VLOOKUP(Z4,Расчет[[Номер гос.регистрации / Заводской номер]:[Итога норма а/м \"ЛЕТО\"]],8,FALSE),VLOOKUP(Z4,Расчет[[Номер гос.регистрации / Заводской номер]:[Итога норма а/м \"ЛЕТО\"]],9,FALSE))","v":46.86},{"$f":"IF(Y4=\"Зима\",VLOOKUP(Z4,Расчет[[Номер гос.регистрации / Заводской номер]:[Итога норма а/м \"ЛЕТО\"]],13,FALSE),VLOOKUP(Z4,Расчет[[Номер гос.регистрации / Заводской номер]:[Итога норма а/м \"ЛЕТО\"]],14,FALSE))","v":5.5}]
["Отчет водителя ломовоза с манипулятором",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-я пол.",{"$f":"T2+1","v":"2018-07-17"},{"$f":"INDEX(Июль[Дата],COUNT(Июль[Дата]))-T1","v":"2018-07-31"},{"$f":"ТС!E6","v":500},{"$f":"SUMIFS(Июль[Выдано топливо, литр],Июль[Дата],\">=\"&$S$3,Июнь[Дата],\"<=\"&$T$3)+IF(MONTH(T3)<>MONTH(S3),SUMIFS(INDIRECT(TEXT(T3,\"ММММ\")&\"[Выдано топливо, литр]\"),INDIRECT(TEXT(T3,\"ММММ\")&\"[Дата]\"),\">=\"&$S$3,INDIRECT(TEXT(T3,\"ММММ\")&\"[Дата]\"),\"<=\"&$T$3))+SUMIFS($U$7:$U$37,Июль[Дата],\">=\"&$S$3,Июнь[Дата],\"<=\"&$T$3)+IF(MONTH(T3)<>MONTH(S3),SUMIFS(INDIRECT(TEXT(T3,\"ММММ\")&\"!$U$7:$U$37\"),INDIRECT(TEXT(T3,\"ММММ\")&\"[Дата]\"),\">=\"&$S$3,INDIRECT(TEXT(T3,\"ММММ\")&\"[Дата]\"),\"<=\"&$T$3))","v":0},{"$f":"IF(V3=0,0,(SUMIFS(N7:N37,A7:A37,\">=\"&S3,A7:A37,\"<=\"&T3)+SUMIFS(INDIRECT(TEXT(A7-1,\"ММММ\")&\"!N7:N37\"),INDIRECT(TEXT(A7-1,\"ММММ\")&\"!A7:A37\"),\">=\"&S3))/(V3-U3+IF(MONTH(T3)=MONTH(S3),G7,INDEX(INDIRECT(TEXT(A7-1,\"ММММ\")&\"!G7:G37\"),DAY(S3)))))","v":0},{"$f":"SUMIFS(Июль[Отклонение от нормы (Перерасход(+), экономия(-)), литр],Июль[Дата],\">=\"&$S$3,Июль[Дата],\"<=\"&$T$3)","v":0}]
[null,null,null,null,null,null,null,"за",2018,null,null,null,null,null,"т 056 вв 197",null,null,null,{"$f":"IF(INDEX(Июль[Дата],COUNT(Июль[Дата]))=T3,\"\",T3+1)","v":""},null,null,null,{"$f":"IFERROR(IF(S4=\"\",\"\",INDIRECT(TEXT(A7+40,\"ММММ\")&\"!W2\")),)","v":""},null,"Лето","Норма 1"]
[]
["Дата","ФИО водителя","Показание одометра машины на начало дня, км","Показание одометра машины на конец дня, км","Пройдено за день, км","Выдано топливо, литр","Остаток топлива в баке на начало дня, литр","Показание счетчика моточасов спецоборудования на начало дня, м/ч","Показание счетчика моточасов  спецоборудования на конец дня, м/ч","Работа спецоборудования за день, м/ч","Количество ходок","Расход топлива на работу спецоборудования, литр","Остаток топлива в баке на конец дня, литр","Расход топлива по норме, литр","Фактический расход топлива, литр","Отклонение от нормы (Перерасход(+), экономия(-)), литр",null,"Дата","Обнуление одометра, км","Пройдено за день, км","Выдано топливо, литр","Обнуление счетчика моточасов спецоборудования, м/ч","Работа спецоборудования за день, м/ч","Расход топлива по норме, литр","Фактический расход топлива, литр","Дата"]
["2018-07-01","Кобалян М.В.",220024,220036,12,0,251,945,946,1,1,5.5,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":251},11.122999999999999,0,-11.122999999999999,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-01"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-01"}]
["2018-07-02","Кобалян М.В.",220036,220071,35,280,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M7)","v":251},946,947,1,1,5.5,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":531},21.901,0,-21.901,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-02"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-02"}]
["2018-07-03","Малышев О.С.",220071,220293,222,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M8)","v":531},947,950,3,2,16.5,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},120.529,63,-57.528999999999996,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-03"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-03"}]
["2018-07-04","Малышев О.С.",220293,220423,130,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M9)","v":500},950,953,3,3,16.5,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":459},77.418000000000006,41,-36.418000000000006,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-04"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-04"}]
["2018-07-05","Малышев О.С.",220423,220525,102,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M10)","v":459},953,957,4,3,22,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":422},69.796999999999997,37,-32.796999999999997,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-05"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-05"}]
["2018-07-06","Малышев О.С.",220525,220646,121,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M11)","v":422},957,960,3,2,16.5,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":384},73.200999999999993,38,-35.200999999999993,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-06"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-06"}]
["2018-07-07","Малышев О.С.",220646,220730,84,300,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M12)","v":384},960,963,3,2,16.5,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":655},55.862000000000002,29,-26.862000000000002,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-07"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-07"}]
["2018-07-08","Малышев О.С.",220730,220879,149,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M13)","v":655},963,965,2,1,11,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":613},80.820999999999998,42,-38.820999999999998,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-08"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-08"}]
["2018-07-09","Малышев О.С.",220879,221022,143,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M14)","v":613},965,970,5,3,27.5,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":563},94.51,50,-44.510000000000005,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-09"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-09"}]
["2018-07-10","Малышев О.С.",221022,221195,173,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M15)","v":563},970,972,2,3,11,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":515},92.067999999999998,48,-44.067999999999998,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-10"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-10"}]
["2018-07-11","Малышев О.С.",221195,221339,144,380,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M16)","v":515},972,975,3,4,16.5,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":851},83.977999999999994,44,-39.977999999999994,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-11"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-11"}]
["2018-07-12",null,221339,221339,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M17)","v":851},975,975,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":851},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-12"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-12"}]
["2018-07-13",null,221339,221339,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M18)","v":851},975,975,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":851},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-13"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-13"}]
["2018-07-14",null,221339,221339,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M19)","v":851},975,975,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":851},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-14"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-14"}]
["2018-07-15",null,221339,221339,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M20)","v":851},975,975,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":851},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-15"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-15"}]
["2018-07-16","Малышев О.С.",221339,221460,121,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M21)","v":851},975,978,3,2,16.5,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},73.200999999999993,38,-35.200999999999993,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-16"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-16"}]
["2018-07-17",null,221460,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M22)","v":500},978,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-17"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-17"}]
["2018-07-18",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M23)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-18"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-18"}]
["2018-07-19",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M24)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-19"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-19"}]
["2018-07-20",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M25)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-20"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-20"}]
["2018-07-21",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M26)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-21"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-21"}]
["2018-07-22",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M27)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-22"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-22"}]
["2018-07-23",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M28)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-23"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-23"}]
["2018-07-24",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M29)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-24"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-24"}]
["2018-07-25",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M30)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-25"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-25"}]
["2018-07-26",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M31)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-26"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-26"}]
["2018-07-27",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M32)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-27"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-27"}]
["2018-07-28",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M33)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-28"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-28"}]
["2018-07-29",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M34)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-29"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-29"}]
["2018-07-30",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M35)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-30"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-30"}]
["2018-07-31",null,0,null,0,0,{"$f":"IF(Июль[[#This Row],[Дата]]=\"\",\"\",M36)","v":500},0,null,0,null,0,{"$f":"IF($T$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($T$3=[Дата],VLOOKUP([Дата],S$2:U$3,3),IF($S$2=[Дата],VLOOKUP([Дата],S$2:U$3,3),INDIRECT($P$1&\"!F\"&ROW())+INDIRECT($P$1&\"!U\"&ROW())+INDIRECT($P$1&\"!G\"&ROW())-INDIRECT($P$1&\"!O\"&ROW()))))","v":500},0,0,0,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-31"},null,null,null,null,null,null,null,{"$f":"Июль[[#This Row],[Дата]]","v":"2018-07-31"}]
["Итог",null,null,null,{"$f":"SUBTOTAL(109,[Пройдено за день, км])","v":1436},{"$f":"SUBTOTAL(109,[Выдано топливо, литр])","v":960},null,null,null,{"$f":"SUBTOTAL(109,[Работа спецоборудования за день, м/ч])","v":33},{"$f":"SUBTOTAL(109,[Количество ходок])","v":27},{"$f":"SUBTOTAL(109,[Расход топлива на работу спецоборудования, литр])","v":181.5},null,{"$f":"SUBTOTAL(109,[Расход топлива по норме, литр])","v":854.40899999999999},{"$f":"SUBTOTAL(109,[Фактический расход топлива, литр])","v":430},{"$f":"SUBTOTAL(109,[Отклонение от нормы (Перерасход(+), экономия(-)), литр])","v":-424.40899999999999},null,"1-я пол.",{"$f":"SUMIFS(S$7:S$37,INDIRECT(\"Июль[Дата]\"),\">=\"&$S$2,INDIRECT(\"Июль[Дата]\"),\"<=\"&$T$2)+IF(MONTH($T$2)<>MONTH($S$2),INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!V1:V2\")))","v":0},{"$f":"SUMIFS(T$7:T$37,INDIRECT(\"Июль[Дата]\"),\">=\"&$S$2,INDIRECT(\"Июль[Дата]\"),\"<=\"&$T$2)+IF(MONTH($T$2)<>MONTH($S$2),INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!V1:V2\")))","v":0},0,0,0,0,0,"1-я пол."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(K7:K37,A7:A37,\">=\"&$S$2,A7:A37,\"<=\"&$T$2)","v":25},null,null,null,null,null,null,"2-я пол.",{"$f":"SUMIFS(S$7:S$37,INDIRECT(\"Июль[Дата]\"),\">=\"&$S$3,INDIRECT(\"Июль[Дата]\"),\"<=\"&$T$3)+IF(MONTH($T$3)<>MONTH($S$3),INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!V1:V2\")))","v":0},{"$f":"SUMIFS(T$7:T$37,INDIRECT(\"Июль[Дата]\"),\">=\"&$S$3,INDIRECT(\"Июль[Дата]\"),\"<=\"&$T$3)+IF(MONTH($T$3)<>MONTH($S$3),INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!F38\")-SUM(INDIRECT(TEXT($A$7-1,\"ММММ\")&\"!V1:V2\")))","v":0},0,0,0,0,0,"2-я пол."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(K7:K37,A7:A37,\">=\"&$S$3,A7:A37,\"<=\"&$T$3)","v":0}]

{"sheet":"ТС","index":2,"n_rows":33,"n_cols":25,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,15,2,24],[2,6,2,7],[2,11,2,12]]}
[null,null,null,null,null,null,"Зима :","01.11 - 31.03",null,null,null,"Зима :","01.11 - 31.03",null,null,"Расчет максимальной нормы расхода ДТ (литр/100км)"]
[null,null,null,null,null,null,"Лето:","01.04 - 30.10",null,null,null,"Лето:","01.04 - 30.10"]
[null,null,null,null,null,null,"доп.коэфф-т к норме",null,null,null,null,"доп.коэфф-т к норме"]
["№ п/п","Номер гос.регистрации / Заводской номер","Километраж, км","Спецоборудование, м/ч","Топливо, л","Базовая норма расхода на 100 км","Зима","Лето","Итога норма а/м ЗИМА","Итога норма а/м ЛЕТО","Базовая норма расхода на 1 мото/час","\"Зима\"","\"Лето\"","Итога норма а/м \"ЗИМА\"","Итога норма а/м \"ЛЕТО\"","Норма на 100 км, литров","движение с манипулятором","Тоннаж","Литры","На движение с грузом","Тоннаж1","К-т загрузки","ИТОГ","25% за работу в городе с населением свыше 3 млн. человек","10 % за работу зимой"]
[1,"Норма 1",209024,620,500,46.86,10,0,{"$f":"F5*(100+G5)%","v":51.546000000000006},{"$f":"F5*(100+H5)%","v":46.86},5.5,10,0,{"$f":"K5*(100+L5)%","v":6.0500000000000007},{"$f":"K5*(100+M5)%","v":5.5},32.200000000000003,{"$f":"R5*S5","v":2.9379999999999997},2.2599999999999998,1.3,{"$f":"U5*V5*S5","v":5.2},8,0.5,{"$f":"P5+Q5+T5","v":40.338000000000008},{"$f":"W5*25%+W5","v":50.422500000000014},{"$f":"W5*10%+X5","v":54.456300000000013}]
[2,"Норма 2",null,null,500,{"$f":"F5-F5*5%","v":44.516999999999996},10,0,{"$f":"F6*(100+G6)%","v":48.968699999999998},{"$f":"F6*(100+H6)%","v":44.516999999999996},{"$f":"K5-K5*5%","v":5.2249999999999996},10,0,{"$f":"K6*(100+L6)%","v":5.7475000000000005},{"$f":"K6*(100+M6)%","v":5.2249999999999996},32.200000000000003,{"$f":"R6*S6","v":2.9379999999999997},2.2599999999999998,1.3,{"$f":"U6*V6*S6","v":5.2},8,0.5,{"$f":"P6+Q6+T6","v":40.338000000000008},{"$f":"W6*25%+W6","v":50.422500000000014},{"$f":"W6*10%+X6","v":54.456300000000013}]
[3,"Норма 3",null,null,500,{"$f":"F5-F5*10%","v":42.173999999999999},10,0,{"$f":"F7*(100+G7)%","v":46.391400000000004},42.173999999999999,{"$f":"K5-K5*10%","v":4.95},10,0,{"$f":"K7*(100+L7)%","v":5.4450000000000003},{"$f":"K7*(100+M7)%","v":4.95},32.200000000000003,{"$f":"R7*S7","v":2.9379999999999997},2.2599999999999998,1.3,{"$f":"U7*V7*S7","v":5.2},8,0.5,{"$f":"P7+Q7+T7","v":40.338000000000008},{"$f":"W7*25%+W7","v":50.422500000000014},{"$f":"W7*10%+X7","v":54.456300000000013}]
[4,"Переход 1",null,null,500,46.86,10,0,{"$f":"F8*(100+G8)%","v":51.546000000000006},{"$f":"F8*(100+H8)%","v":46.86},5.5,10,0,{"$f":"K8*(100+L8)%","v":6.0500000000000007},{"$f":"K8*(100+M8)%","v":5.5},null,{"$f":"R8*S8","v":0},null,null,{"$f":"U8*V8*S8","v":0},null,null,{"$f":"P8+Q8+T8","v":0},{"$f":"W8*25%+W8","v":0},{"$f":"W8*10%+X8","v":0}]
[5,"Переход 2",null,null,500,{"$f":"F8-F8*5%","v":44.516999999999996},10,0,{"$f":"F9*(100+G9)%","v":48.968699999999998},{"$f":"F9*(100+H9)%","v":44.516999999999996},{"$f":"K8-K8*5%","v":5.2249999999999996},10,0,{"$f":"K9*(100+L9)%","v":5.7475000000000005},{"$f":"K9*(100+M9)%","v":5.2249999999999996},null,{"$f":"R9*S9","v":0},null,null,{"$f":"U9*V9*S9","v":0},null,null,{"$f":"P9+Q9+T9","v":0},{"$f":"W9*25%+W9","v":0},{"$f":"W9*10%+X9","v":0}]
[6,"Переход 3",null,null,500,{"$f":"F8-F8*10%","v":42.173999999999999},10,0,{"$f":"F10*(100+G10)%","v":46.391400000000004},42.173999999999999,{"$f":"K8-K8*10%","v":4.95},10,0,{"$f":"K10*(100+L10)%","v":5.4450000000000003},{"$f":"K10*(100+M10)%","v":4.95},null,{"$f":"R10*S10","v":0},null,null,{"$f":"U10*V10*S10","v":0},null,null,{"$f":"P10+Q10+T10","v":0},{"$f":"W10*25%+W10","v":0},{"$f":"W10*10%+X10","v":0}]
[]
[null,"Зима"]
[null,"Лето"]
[]
[null,"Январь"]
[null,"Февраль"]
[null,"Март"]
[null,"Апрель"]
[null,"Май"]
[null,"Июнь"]
[null,"Июль"]
[null,"Август"]
[null,"Сентябрь"]
[null,"Октябрь"]
[null,"Ноябрь"]
[null,"Декабрь"]
[]
[null,"Норма 1"]
[null,"Норма 2"]
[null,"Норма 3"]
[null,"Переход 1"]
[null,"Переход 2"]
[null,"Переход 3"]

{"sheet":"Сотрудники","index":3,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Ф.И.О."]
[null,"Зяблов А.А"]
[null,"Ильин А.Г."]
[null,"Ильин Е.Н."]
[null,"Ильичев Ю.Ф."]
[null,"Кобалян М.В."]
[null,"Лагутенко А.А."]
[null,"Малышев О.С."]
[null,"Никляев В.А."]
[null,"Сергеев Д.О."]
[null,"Ястребов Е.В."]