{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Sheet2","ПЛ лицевая","ПЛ обратная","1","2","3","4","5","6","7","8","9","10","11","12","Лист1","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":23,"comments":1,"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":"Sheet2","index":0,"n_rows":799,"n_cols":31,"rows_kept":799,"cut":false,"hidden":true,"merged":[[797,1,797,11],[798,4,798,8],[688,0,688,2],[690,0,690,10],[691,0,691,10],[692,6,692,10],[774,14,774,17],[775,12,775,13],[783,14,783,15],[752,0,752,10],[753,0,753,3],[753,6,753,10],[754,0,754,4],[756,0,756,6],[757,0,757,6],[723,14,723,15],[731,12,731,13],[717,14,717,17],[713,14,713,17],[710,14,710,17],[715,12,715,13],[636,0,636,10],[637,0,637,10],[638,0,638,3],[638,6,638,10],[641,0,641,6],[642,0,642,6],[639,0,639,4],[795,1,795,11],[796,5,796,8],[732,0,732,2],[735,1,735,11],[736,5,736,8],[737,1,737,11],[749,0,749,2],[751,0,751,10],[696,0,696,6],[738,4,738,8],[677,12,677,13],[678,0,678,2],[681,1,681,11],[682,5,682,8],[683,1,683,11],[695,0,695,6],[656,14,656,17],[659,14,659,17],[663,14,663,17],[669,14,669,15],[661,12,661,13],[684,4,684,8],[693,0,693,4],[692,0,692,3],[603,14,603,17],[624,0,624,2],[605,14,605,17],[609,14,609,17],[615,14,615,15],[634,0,634,2],[628,6,628,9],[630,5,630,9],[627,2,627,10],[629,2,629,11],[206,0,206,6],[141,0,141,6],[187,0,187,2],[137,6,137,10],[203,0,203,3],[203,6,203,10],[140,0,140,6],[137,0,137,3],[138,0,138,4],[589,0,589,6],[581,0,581,2],[583,0,583,10],[192,3,192,7],[75,0,75,6],[122,0,122,2],[124,0,124,10],[585,0,585,3],[585,6,585,10],[125,4,125,7],[266,0,266,4],[588,0,588,6],[201,0,201,10],[202,0,202,10],[126,0,126,10],[127,3,127,7],[586,0,586,4],[189,0,189,10],[190,4,190,7],[191,0,191,10],[269,0,269,6],[315,0,315,2],[204,0,204,4],[254,0,254,10],[207,0,207,6],[584,0,584,10],[264,0,264,10],[265,0,265,3],[265,6,265,10],[250,0,250,2],[72,0,72,4],[70,0,70,10],[71,0,71,3],[71,6,71,10],[263,0,263,10],[333,0,333,10],[330,0,330,2],[332,0,332,10],[320,3,320,7],[268,0,268,6],[319,0,319,10],[465,0,465,6],[466,0,466,6],[388,0,388,10],[334,0,334,3],[334,6,334,10],[335,0,335,4],[337,0,337,6],[0,0,0,2],[2,0,2,10],[3,0,3,10],[4,0,4,3],[4,6,4,10],[58,0,58,10],[5,0,5,4],[255,3,255,7],[261,0,261,2],[252,0,252,10],[253,4,253,7],[69,0,69,10],[133,0,133,2],[74,0,74,6],[135,0,135,10],[136,0,136,10],[199,0,199,2],[7,0,7,6],[8,0,8,6],[54,0,54,2],[56,0,56,10],[67,0,67,2],[57,4,57,7],[59,3,59,7],[462,0,462,3],[462,6,462,10],[401,0,401,6],[402,0,402,6],[446,0,446,2],[398,6,398,10],[387,4,387,7],[389,3,389,7],[394,0,394,2],[21,13,21,18],[88,13,88,16],[89,13,89,16],[90,13,90,16],[230,12,230,13],[448,0,448,10],[399,0,399,4],[157,14,157,17],[169,14,169,17],[398,0,398,3],[284,14,284,17],[282,14,282,17],[176,14,176,17],[220,14,220,17],[396,0,396,10],[397,0,397,10],[317,0,317,10],[288,14,288,17],[289,14,289,17],[318,4,318,7],[225,12,225,13],[221,14,221,17],[154,14,154,17],[156,14,156,17],[235,14,235,17],[238,12,238,13],[285,12,285,13],[286,12,286,13],[290,12,290,13],[287,14,287,17],[291,14,291,17],[92,13,92,16],[104,13,104,16],[171,14,171,17],[172,14,172,17],[222,14,222,17],[292,14,292,17],[351,14,351,17],[352,14,352,17],[370,15,370,18],[449,4,449,7],[417,12,417,13],[424,14,424,17],[299,12,299,13],[297,12,297,13],[295,14,295,17],[300,12,300,13],[302,12,302,13],[301,14,301,17],[425,14,425,17],[426,12,426,13],[338,0,338,6],[384,0,384,2],[386,0,386,10],[570,3,570,7],[531,0,531,6],[523,0,523,2],[525,0,525,10],[527,0,527,3],[528,0,528,4],[514,0,514,10],[526,0,526,10],[527,6,527,10],[567,0,567,10],[568,4,568,7],[569,0,569,10],[545,14,545,17],[565,0,565,2],[530,0,530,6],[516,0,516,10],[517,3,517,7],[515,4,515,7],[371,15,371,18],[428,14,428,17],[433,14,433,17],[427,14,427,17],[434,14,434,17],[512,0,512,2],[426,14,426,17],[450,0,450,10],[483,14,483,16],[484,14,484,16],[485,14,485,16],[499,14,499,17],[463,0,463,4],[480,14,480,17],[451,3,451,7],[458,0,458,2],[460,0,460,10],[461,0,461,10]]}
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 208 D",null,null,null,null,null,"государственный номерной знак 8060 АМ-7"]
["за январь  2006 года"]
[]
["Материально ответственное лицо "]
[" Звездов О В"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D12+E12","v":478248},null,497.89,null,{"$f":"H12+#REF!-K12+I12","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H13+#REF!-K13+I13","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F12","v":478248},410,{"$f":"D14+E14","v":478658},null,240.54,250.02,{"$f":"H14+#REF!-K14+I14","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F14","v":478658},263,{"$f":"D15+E15","v":478921},null,{"$f":"J14","v":{"$error":"#REF!"}},null,{"$f":"H15+#REF!-K15+I15","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F15","v":478921},826,{"$f":"D16+E16","v":479747},null,{"$f":"J15","v":{"$error":"#REF!"}},185.05,{"$f":"H16+#REF!-K16+I16","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F16","v":479747},1400,{"$f":"D17+E17","v":481147},null,{"$f":"J16","v":{"$error":"#REF!"}},334,{"$f":"H17+#REF!-K17+I17","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F17","v":481147},1400,{"$f":"D18+E18","v":482547},null,{"$f":"J17","v":{"$error":"#REF!"}},197,{"$f":"H18+#REF!-K18+I18","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J18","v":{"$error":"#REF!"}},230,{"$f":"H19+#REF!-K19+I19","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E14:E18)","v":4299},null,null,null,{"$f":"SUM(I14:I19)","v":1196.0700000000002},null,{"$f":"SUM(K14:K19)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-01-02","1549064"," Звездов О В",360481,{"$f":"489-6*2","v":477},{"$f":"D22+E22","v":360958},"город, за городом",45.45,null,{"$f":"ROUND(H22+I22-K22,2)","v":2.42},43.03,{"$f":"K22","v":43.03},null,"Минск ул. Железнод 27-п. Городея ООО ПМК-217 г                     мИнск ул Железнод 27-г. слоним и обратно  г Минск пр-д Чижевских -г минск ул.Железнод 27",null,null,null,null,null,"и обратно",null,"80-80  155-155 7-",null,"по год 67*9,4/100=6,29  за городом 410*8,96/100=36,74"]
["2006-01-03",null," Звездов О В",{"$f":"F22","v":360958},null,{"$f":"D23+E23","v":360958},"город",{"$f":"J22","v":2.42},null,2.42,{"$f":"ROUND(9.4/100*E23,2)","v":0},{"$f":"K23","v":0}]
["2006-01-04",null," Звездов О В",360958,null,360958,"город",2.42,null,2.42,{"$f":"ROUND(9.4/100*E24,2)","v":0},0]
["2006-01-05",null," Звездов О В",360958,null,360958,"город",2.42,null,2.42,0,0]
["2006-01-06",null," Звездов О В",360958,null,360958,"город",2.42,null,2.42,0,0]
["2006-01-09",null," Звездов О В",360958,null,360958,"город",2.42,null,2.42,0,0]
["2006-01-10","1549870"," Звездов О В",360958,22,360980,"город",2.42,null,0.35,2.0699999999999998,2.0699999999999998]
["2006-01-11","1549065"," Звездов О В",360980,12,360992,"город",0.35,20.8,20.02,1.1299999999999999,1.1299999999999999,39281,325,"10+10,8"]
["2006-01-12",null," Звездов О В",360992,null,360992,"город",20.02,null,20.02,0,0]
["2006-01-13","1549871"," Звездов О В",360992,20,361012,"город",20.02,17,35.14,1.88,1.88,112024]
["2006-01-16","1549066"," Звездов О В",361012,{"$f":"14*2+11*2+8*2","v":66},361078,"город",35.14,null,28.94,6.2,6.2]
["2006-01-17",null," Звездов О В",361078,null,361078,"город",28.94,null,28.94,0,0]
["2006-01-18",null," Звездов О В",361078,null,361078,"город",28.94,null,28.94,0,0]
["2006-01-19",null," Звездов О В",361078,null,361078,"город",28.94,null,28.94,0,0]
["2006-01-20",null," Звездов О В",361078,null,361078,"город",28.94,null,28.94,0,0,null,"минск ул. Железнод 27 -г. Пружаны и обратно",null,null,null,null,null,"не хват топлива",null,"надо 52,8"]
["2006-01-23",null," Звездов О В",361078,null,361078,"город",28.94,null,28.94,0,0]
["2006-01-24",null," Звездов О В",361078,null,361078,"город",28.94,null,28.94,0,0,null,"минск ул. Железнод 27 -г.Микашевичи и обратно ",null,null,null,null,"не хват топлива",null,255]
["2006-01-25","1549872"," Звездов О В",361078,{"$f":"194*2","v":388},361466,"город, за городом",28.94,20,14,34.94,34.94,null,"мИнск ул Железнод 27-г. слоним и обратно ",null,null,null,null,null,null,{"$f":"20*2*9.4/100","v":3.76},{"$f":"348*8.96/100","v":31.180800000000005}]
["2006-01-26",null," Звездов О В",361466,null,361466,"город",14,null,14,0,0,null,null,null,null,null,null,null,null,null,{"$f":"U39+V39","v":34.940800000000003}]
["2006-01-27",null," Звездов О В",361466,null,361466,"город",14,null,14,0,0,61731,null,10.199999999999999]
["2006-01-28",null," Звездов О В",361466,null,361466,"город",14,10.199999999999999,24.2,0,0]
["2006-01-30",null," Звездов О В",{"$f":"F41","v":361466},null,361466,"город",24.2,null,24.2,0,0]
["2006-01-31","1549873"," Звездов О В",{"$f":"F41","v":361466},47,361513,"город",24.2,13,32.78,4.42,4.42,"0428"]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"ROUND(7.2/100*E45,2)","v":0}]
[null,null," Звездов О В",{"$f":"F45","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J45","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F52","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J52","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F53","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J53+16","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E22:E44)","v":1032},null,null,null,{"$f":"SUM(I23:I44)","v":81},null,{"$f":"SUM(K22:K44)","v":93.67},{"$f":"K55","v":93.67}]
[]
["Составил  ФИО  _________________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,80.956999999999994]
[null,null,null,null,"(подпись)"]
["Проверил  _____________________________________"]
[null,null,null,"(подпись)"]
[]
[]
[]
[]
[]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 208 D",null,null,null,null,null,"государственный номерной знак 8060 АМ-7"]
["за февраль  2006 года"]
[]
["Материально ответственное лицо "]
[" Звездов О В"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D79+E79","v":478248},null,497.89,null,{"$f":"H79+#REF!-K79+I79","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H80+#REF!-K80+I80","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F79","v":478248},410,{"$f":"D81+E81","v":478658},null,240.54,250.02,{"$f":"H81+#REF!-K81+I81","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F81","v":478658},263,{"$f":"D82+E82","v":478921},null,{"$f":"J81","v":{"$error":"#REF!"}},null,{"$f":"H82+#REF!-K82+I82","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F82","v":478921},826,{"$f":"D83+E83","v":479747},null,{"$f":"J82","v":{"$error":"#REF!"}},185.05,{"$f":"H83+#REF!-K83+I83","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F83","v":479747},1400,{"$f":"D84+E84","v":481147},null,{"$f":"J83","v":{"$error":"#REF!"}},334,{"$f":"H84+#REF!-K84+I84","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F84","v":481147},1400,{"$f":"D85+E85","v":482547},null,{"$f":"J84","v":{"$error":"#REF!"}},197,{"$f":"H85+#REF!-K85+I85","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J85","v":{"$error":"#REF!"}},230,{"$f":"H86+#REF!-K86+I86","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E81:E85)","v":4299},null,null,null,{"$f":"SUM(I81:I86)","v":1196.0700000000002},null,{"$f":"SUM(K81:K86)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-02-01","1549067"," Звездов О В",{"$f":"F44","v":361513},{"$f":"7*2+4*2+160","v":182},{"$f":"D89+E89","v":361695},"город, за городом",32.78,null,{"$f":"ROUND(H89+I89-K89,2)","v":16.239999999999998},{"$f":"2.07+14.47","v":16.54},{"$f":"K89","v":16.54},null,"г. Минск ул. Железнод 27 - г. Борисов ул. Гагарина 46А и обратно",null,null,null,null,null,{"$f":"31*9.4/100","v":2.9140000000000001},{"$f":"129*8.96/100","v":11.558400000000001},{"$f":"T89+U89","v":14.4724}]
["2006-02-02","1549875"," Звездов О В",{"$f":"F89","v":361695},160,{"$f":"D90+E90","v":361855},"город, за городом",{"$f":"J89","v":16.239999999999998},20,21.77,14.47,{"$f":"K90","v":14.47},61662,"г. Минск ул. Железнод 27 - г. Борисов ул. Гагарина 46А и обратно"]
["2006-02-03","1549068"," Звездов О В",361855,160,362015,"город, за городом",21.77,null,7.3,14.47,14.47,null,"г. Минск ул. Железнод 27 - г. Борисов ул. Гагарина 46А и обратно"]
["2006-02-04",null," Звездов О В",362015,null,362015,"город",7.3,55,62.3,{"$f":"ROUND(9.4/100*E92,2)","v":0},0,203583]
["2006-02-05","1549876"," Звездов О В",362015,{"$f":"245*2","v":490},362505,"город, за городом",62.3,null,18.260000000000002,44.04,44.04,null,"г. Минск ул. Железнод 27 - г. Береза и обратно",null,null,null,null,null,null,{"$f":"15*2*9.4/100","v":2.82},null,{"$f":"460*8.96/100","v":41.216000000000001},{"$f":"U93+W93","v":44.036000000000001}]
["2006-02-06",null," Звездов О В",362505,null,362505,"город",18.260000000000002,null,18.260000000000002,0,0]
["2006-02-07",1549069," Звездов О В",362505,230,362735,"город",18.260000000000002,23,19.64,21.62,21.62,207767]
["2006-02-08",null," Звездов О В",362735,null,362735,"город",19.64,null,19.64,0,0]
["2006-02-09","1549877"," Звездов О В",362735,15,362750,"город",19.64,35,53.23,1.41,1.41,8034]
["2006-02-10","1549878"," Звездов О В",362750,320,363070,"город",53.23,20,43.15,30.08,30.08,115]
["2006-02-11",null," Звездов О В",363070,null,363070,"город",43.15,null,43.15,0,0]
["2006-02-13","1549070"," Звездов О В",363070,480,363550,"город",43.15,{"$f":"10.25+50+45","v":105.25},103.28,45.12,45.12,"45553,0305,0495,0493"]
["2006-02-14",null," Звездов О В",363550,null,363550,"город",103.28,null,103.28,0,0]
["2006-02-15",null," Звездов О В",363550,null,363550,"город",103.28,null,103.28,0,0]
["2006-02-16","1549072"," Звездов О В",363550,360,363910,"город",103.28,{"$f":"54.19+8.55","v":62.739999999999995},132.18,33.840000000000003,33.840000000000003,"0098,0169,0109"]
["2006-02-17",null," Звездов О В",363910,null,363910,"город",132.18,null,132.18,0,0]
["2006-02-19","1549879"," Звездов О В",363910,490,364400,"город, за городом",132.18,null,88.14,44.04,44.04,null,"г. Минск ул. Железнод 27 - г. Береза и обратно"]
["2006-02-20","1549880"," Звездов О В",364400,130,364530,"город",88.14,10,85.92,12.22,12.22,6.3299999999999995E-2]
["2006-02-21",null," Звездов О В",364530,null,364530,"город",85.92,null,85.92,0,0]
["2006-02-22","1549071"," Звездов О В",364530,{"$f":"14*2+17*2","v":62},364592,"город",85.92,8.5,88.59,5.83,5.83,231039]
["2006-02-23",null," Звездов О В",364592,null,364592,"город",88.59,null,88.59,0,0]
["2006-02-24",null," Звездов О В",364592,null,364592,"город",88.59,null,88.59,0,0]
["2006-02-27",null," Звездов О В",364592,null,364592,"город",88.59,10,98.59,0,0,91658]
["2006-02-28","1549881"," Звездов О В",364592,109,364701,"город",98.59,null,88.34,10.25,10.25]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"ROUND(7.2/100*E113,2)","v":0}]
[null,null," Звездов О В",{"$f":"F113","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J113","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F120","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J120","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F121","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J121+16","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E89:E112)","v":3188},null,null,null,{"$f":"SUM(I89:I112)","v":349.49},null,{"$f":"SUM(K89:K112)","v":293.93},{"$f":"K123","v":293.93}]
[]
["Составил  ФИО  _________________"]
[null,null,null,null,"(подпись)",null,null,null,null,null,null,null,null,null,314.49]
["Проверил  _____________________________________"]
[null,null,null,"(подпись)"]
[]
[]
[]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 208 D",null,null,null,null,null,"государственный номерной знак 8060 АМ-7"]
["за март  2006 года"]
[]
["Материально ответственное лицо "]
[" Звездов О В"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D145+E145","v":478248},null,497.89,null,{"$f":"H145+#REF!-K145+I145","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H146+#REF!-K146+I146","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F145","v":478248},410,{"$f":"D147+E147","v":478658},null,240.54,250.02,{"$f":"H147+#REF!-K147+I147","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F147","v":478658},263,{"$f":"D148+E148","v":478921},null,{"$f":"J147","v":{"$error":"#REF!"}},null,{"$f":"H148+#REF!-K148+I148","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F148","v":478921},826,{"$f":"D149+E149","v":479747},null,{"$f":"J148","v":{"$error":"#REF!"}},185.05,{"$f":"H149+#REF!-K149+I149","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F149","v":479747},1400,{"$f":"D150+E150","v":481147},null,{"$f":"J149","v":{"$error":"#REF!"}},334,{"$f":"H150+#REF!-K150+I150","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F150","v":481147},1400,{"$f":"D151+E151","v":482547},null,{"$f":"J150","v":{"$error":"#REF!"}},197,{"$f":"H151+#REF!-K151+I151","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J151","v":{"$error":"#REF!"}},230,{"$f":"H152+#REF!-K152+I152","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E147:E151)","v":4299},null,null,null,{"$f":"SUM(I147:I152)","v":1196.0700000000002},null,{"$f":"SUM(K147:K152)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-03-01","1549073"," Звездов О В",{"$f":"F112","v":364701},{"$f":"7*2+25*2","v":64},{"$f":"D155+E155","v":364765},"город",88.34,10,{"$f":"ROUND(H155+I155-K155,2)","v":92.32},{"$f":"ROUND(9.4/100*E155,2)","v":6.02},{"$f":"K155","v":6.02},241780,null,"г. Минск, ул. Железнод 27- г. Солигорск и обратно",null,null,null,null,{"$f":"94*9.4/100","v":8.8360000000000003},{"$f":"216*8.96/100","v":19.3536},{"$f":"T155+U155","v":28.189599999999999}]
["2006-03-02",null," Звездов О В",{"$f":"F155","v":364765},null,{"$f":"D156+E156","v":364765},"город",{"$f":"J155","v":92.32},null,92.32,0,{"$f":"K156","v":0}]
["2006-03-03","1549074"," Звездов О В",364765,{"$f":"120*2","v":240},365005,"город, за городом",92.32,25,95.64,21.68,21.68,2.8400000000000002E-2,{"$f":"40*9.4/100","v":3.76},"г. Минск, ул. Железнод 27- г. Кобрин и обратно",null,null,null,null,null,{"$f":"20*2*9.4/100","v":3.76},{"$f":"554*8.96/100","v":49.638400000000004},{"$f":"U157+V157","v":53.398400000000002}]
["2006-03-06",null," Звездов О В",365005,null,365005,"город",95.64,null,95.64,0,0,null,{"$f":"200*8.96/100","v":17.920000000000002},"г. Минск, ул. Железнод 27- г. Вилейка и обратно",null,null,null,null,null,{"$f":"15*2*9.4/100","v":2.82},{"$f":"170*8.96/100","v":15.232000000000001},{"$f":"U158+V158","v":18.052}]
["2006-03-07",null," Звездов О В",365005,null,365005,"город",95.64,null,95.64,0,0,null,{"$f":"N157+N158","v":21.68}]
["2006-03-08",null," Звездов О В",365005,null,365005,"город",95.64,null,95.64,0,0]
["2006-03-09",null," Звездов О В",365005,null,365005,"город",95.64,null,95.64,0,0]
["2006-03-10",null," Звездов О В",365005,null,365005,"город",95.64,null,95.64,0,0]
["2006-03-13",null," Звездов О В",365005,null,365005,"город",95.64,null,95.64,0,0]
["2006-03-14",null," Звездов О В",365005,null,365005,"город",95.64,null,95.64,0,0]
["2006-03-15",null," Звездов О В",365005,null,365005,"город",95.64,null,95.64,0,0]
["2006-03-16",null," Звездов О В",365005,null,365005,"город",95.64,null,95.64,0,0]
["2006-03-17",null," Звездов О В",365005,null,365005,"город",95.64,null,95.64,0,0]
["2006-03-20",null," Звездов О В",365005,null,365005,"город",95.64,null,95.64,0,0]
["2006-03-21","1549075"," Звездов О В",365005,{"$f":"35*2+128+65+170","v":433},365438,"город, за городом",95.64,null,56.49,39.15,39.15,null,null,{"$f":"80*9.4/100","v":7.52},{"$f":"353*8.96/100","v":31.628800000000002},{"$f":"O169+P169","v":39.148800000000001}]
["2006-03-22","1549076"," Звездов О В",365438,{"$f":"99+100+160+50*2","v":459},365897,"город, за городом",56.49,null,14.99,41.5,41.5,null,null,"г. Минск, ул. Железнод 27- аг Олехновичи, у. Радошковичская 43 и обр"]
["2006-03-23",null," Звездов О В",365897,null,365897,"город",14.99,null,14.99,0,0,null,null,{"$f":"85*9.4/100","v":7.99},{"$f":"374*8.96/100","v":33.510400000000004},{"$f":"O171+P171","v":41.500400000000006},null,null,null,{"$f":"20*9.4/100","v":1.88},{"$f":"58*8.96/100","v":5.1968000000000005},{"$f":"U171+V171","v":7.0768000000000004}]
["2006-03-24",null," Звездов О В",365897,null,365897,"город",14.99,null,14.99,0,0,null,null,"г. Минск, ул. Железнод 27- г. Заславль и обратно",null,null,null,null,null,{"$f":"23*9.4/100","v":2.1620000000000004},{"$f":"53*8.96/100","v":4.7488000000000001},{"$f":"U172+V172","v":6.9108000000000001}]
["2006-03-27",null," Звездов О В",365897,null,365897,"город",14.99,10,24.99,0,0,"0049",null,"г. Минск, ул. Железнод 27-г. Минск ул. Жудро 37-27 и обратно"]
["2006-03-28",null," Звездов О В",365897,null,365897,"город",24.99,null,24.99,0,0]
["2006-03-29","1549078"," Звездов О В",365897,{"$f":"164+80+260","v":504},366401,"город, за городом",24.99,21.3,0.56000000000000005,45.73,45.73,"0329"]
["2006-03-30",null," Звездов О В",366401,null,366401,"город",0.56000000000000005,null,0.56000000000000005,0,0]
["2006-03-31",null," Звездов О В",366401,null,366401,"город",0.56000000000000005,null,0.56000000000000005,0,0,null,null,"г. Минск, ул. Железнод 27-г. Лида и обратно",null,null,null,null,null,{"$f":"20*2*9.4/100","v":3.76},{"$f":"374*8.96/100","v":33.510400000000004},{"$f":"U177+V177","v":37.270400000000002}]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"D178+E178","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"ROUND(7.2/100*E178,2)","v":0}]
[null,null," Звездов О В",{"$f":"F178","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J178","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F185","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J185","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F186","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J186+16","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E155:E177)","v":1700},null,null,null,{"$f":"SUM(I155:I177)","v":66.3},null,{"$f":"SUM(K155:K177)","v":154.07999999999998},{"$f":"K188","v":154.07999999999998}]
[]
["Составил  ФИО  _________________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"70*9.4/100","v":6.58},{"$f":"437*8.96/100","v":39.155200000000008},{"$f":"P190+Q190","v":45.735200000000006}]
[null,null,null,null,"(подпись)"]
["Проверил  _____________________________________"]
[null,null,null,"(подпись)"]
[]
[]
[]
[]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 208 D",null,null,null,null,null,"государственный номерной знак 8060 АМ-7"]
["за апрель  2006 года"]
[]
["Материально ответственное лицо "]
[" Звездов О В"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D211+E211","v":478248},null,497.89,null,{"$f":"H211+#REF!-K211+I211","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H212+#REF!-K212+I212","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F211","v":478248},410,{"$f":"D213+E213","v":478658},null,240.54,250.02,{"$f":"H213+#REF!-K213+I213","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F213","v":478658},263,{"$f":"D214+E214","v":478921},null,{"$f":"J213","v":{"$error":"#REF!"}},null,{"$f":"H214+#REF!-K214+I214","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F214","v":478921},826,{"$f":"D215+E215","v":479747},null,{"$f":"J214","v":{"$error":"#REF!"}},185.05,{"$f":"H215+#REF!-K215+I215","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F215","v":479747},1400,{"$f":"D216+E216","v":481147},null,{"$f":"J215","v":{"$error":"#REF!"}},334,{"$f":"H216+#REF!-K216+I216","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F216","v":481147},1400,{"$f":"D217+E217","v":482547},null,{"$f":"J216","v":{"$error":"#REF!"}},197,{"$f":"H217+#REF!-K217+I217","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J217","v":{"$error":"#REF!"}},230,{"$f":"H218+#REF!-K218+I218","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E213:E217)","v":4299},null,null,null,{"$f":"SUM(I213:I218)","v":1196.0700000000002},null,{"$f":"SUM(K213:K218)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-04-03","1549079"," Звездов О В",{"$f":"F177","v":366401},5,{"$f":"D221+E221","v":366406},"город",0.56000000000000005,null,{"$f":"ROUND(H221+I221-K221,2)","v":0.09},{"$f":"ROUND(9.4/100*E221,2)","v":0.47},{"$f":"K221","v":0.47},null,null,"г. Минск, ул. Железнод 27-Пинский р-н д. Вяз и обратно",null,null,null,null,"нет топлива"]
["2006-04-04",null," Звездов О В",{"$f":"F221","v":366406},null,{"$f":"D222+E222","v":366406},"город",{"$f":"J221","v":0.09},null,0.09,{"$f":"ROUND(9.4/100*E222,2)","v":0},{"$f":"K222","v":0},null,null,"г. Минск ул. Железнод 27 - г. Береза и обратно",null,null,null,null,"нет топлива"]
["2006-04-05",null," Звездов О В",366406,null,366406,"город",0.09,null,0.09,0,0,null,null,"г. Минск, ул. Железнод 27-г. Брест и обратно",null,null,null,null,"нет топлива"]
["2006-04-06","1549080"," Звездов О В",366406,45,366451,"город",0.09,20.72,16.579999999999998,4.2300000000000004,4.2300000000000004,195953]
["2006-04-07",null," Звездов О В",366451,null,366451,"город",16.579999999999998,null,16.579999999999998,0,0]
["2006-04-10",null," Звездов О В",366451,null,366451,"город",16.579999999999998,{"$f":"10+7","v":17},33.58,0,0,3259.1389100000001]
["2006-04-11","1549081"," Звездов О В",366451,{"$f":"21*2","v":42},366493,"город",33.58,{"$f":"27.11+18.2","v":45.31},74.94,3.95,3.95,",0013,0570,0012"]
["2006-04-12",null," Звездов О В",366493,null,366493,"город",74.94,null,74.94,0,0]
["2006-04-13",null," Звездов О В",366493,null,366493,"город",74.94,null,74.94,0,0]
["2006-04-14",null," Звездов О В",366493,null,366493,"город",74.94,null,74.94,0,0]
["2006-04-17",null," Звездов О В",366493,null,366493,"город",74.94,27,101.94,0,0,71995.116848999998]
["2006-04-18","1549082"," Звездов О В",366493,{"$f":"194*2","v":388},366881,"город, за городом",101.94,null,66.91,35.03,35.03,null,null,null,{"$f":"60*9.4/100","v":5.64},{"$f":"328*8.96/100","v":29.3888},{"$f":"P232+Q232","v":35.028799999999997}]
["2006-04-19",null," Звездов О В",366881,null,366881,"город",66.91,null,66.91,0,0]
["2006-04-20",null," Звездов О В",366881,null,366881,"город",66.91,null,66.91,0,0]
["2006-04-21",null," Звездов О В",366881,null,366881,"город",66.91,40.31,107.22,0,0,",0015"]
["2006-04-24","1549077"," Звездов О В",366881,{"$f":"245*2","v":490},367371,"город, за городом",107.22,null,62.96,44.26,44.26,null,null,"г. Минск ул. Железнод 27 - г. Береза и обратно"]
["2006-04-25",null," Звездов О В",367371,null,367371,"город",62.96,10,72.959999999999994,0,0,11282,null,{"$f":"80*9.4/100","v":7.52},{"$f":"410*8.96/100","v":36.736000000000004},{"$f":"O237+P237","v":44.256}]
["2006-04-26","1549882"," Звездов О В",367371,43,367414,"город",72.959999999999994,10.199999999999999,79.12,4.04,4.04,559]
["2006-04-27",1549083," Звездов О В",367414,{"$f":"10*2","v":20},367434,"город",79.12,6,83.24,1.88,1.88,41264.330776000003,null,null,20.27]
["2006-04-28",null," Звездов О В",367434,null,367434,"город",83.24,null,83.24,0,0]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"ROUND(7.2/100*E241,2)","v":0}]
[null,null," Звездов О В",{"$f":"F241","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J241","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F248","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J248","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F249","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J249+16","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E221:E240)","v":1033},null,null,null,{"$f":"SUM(I221:I240)","v":176.54},null,{"$f":"SUM(K221:K240)","v":93.86},{"$f":"K251","v":93.86}]
[]
["Составил  ФИО  _________________"]
[null,null,null,null,"(подпись)"]
["Проверил  _____________________________________"]
[null,null,null,"(подпись)"]
[]
[]
[]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 208 D",null,null,null,null,null,"государственный номерной знак 8060 АМ-7"]
["за май  2006 года"]
[]
["Материально ответственное лицо "]
[" Звездов О В"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D273+E273","v":478248},null,497.89,null,{"$f":"H273+#REF!-K273+I273","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H274+#REF!-K274+I274","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F273","v":478248},410,{"$f":"D275+E275","v":478658},null,240.54,250.02,{"$f":"H275+#REF!-K275+I275","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F275","v":478658},263,{"$f":"D276+E276","v":478921},null,{"$f":"J275","v":{"$error":"#REF!"}},null,{"$f":"H276+#REF!-K276+I276","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F276","v":478921},826,{"$f":"D277+E277","v":479747},null,{"$f":"J276","v":{"$error":"#REF!"}},185.05,{"$f":"H277+#REF!-K277+I277","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F277","v":479747},1400,{"$f":"D278+E278","v":481147},null,{"$f":"J277","v":{"$error":"#REF!"}},334,{"$f":"H278+#REF!-K278+I278","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F278","v":481147},1400,{"$f":"D279+E279","v":482547},null,{"$f":"J278","v":{"$error":"#REF!"}},197,{"$f":"H279+#REF!-K279+I279","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J279","v":{"$error":"#REF!"}},230,{"$f":"H280+#REF!-K280+I280","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E275:E279)","v":4299},null,null,null,{"$f":"SUM(I275:I280)","v":1196.0700000000002},null,{"$f":"SUM(K275:K280)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-05-01","1549085"," Звездов О В",{"$f":"F240","v":367434},{"$f":"100*2","v":200},{"$f":"D283+E283","v":367634},"город, за городом",83.24,null,{"$f":"ROUND(H283+I283-K283,2)","v":64.25},{"$f":"21.99-3","v":18.989999999999998},{"$f":"K283","v":18.989999999999998},null,null,"г. Минск ул. Железнод 27 - г.Вилейка и обратно",null,null,null,null,{"$f":"70*9.4/100-3","v":3.58},{"$f":"172*8.96/100","v":15.411200000000001},{"$f":"T283+U283","v":18.991199999999999}]
["2006-05-02",null," Звездов О В",{"$f":"F283","v":367634},null,{"$f":"D284+E284","v":367634},"город",{"$f":"J283","v":64.25},null,64.25,{"$f":"ROUND(9.4/100*E284,2)","v":0},{"$f":"K284","v":0}]
["2006-05-03","1549084"," Звездов О В",367634,{"$f":"194+86+92+7*2+14*2","v":414},368048,"город, за городом",64.25,null,27.56,36.69,36.69,null,null,"г. Минск ул. Железнод 27 - г.Слоним и обратно; г. Минск ул. Железнод 27 - г.Вилейка и обратно",null,null,null,null,{"$f":"81*9.4/100+3","v":10.614000000000001},{"$f":"(372-81)*8.96/100","v":26.073600000000003},{"$f":"T285+U285","v":36.687600000000003}]
["2006-05-04",null," Звездов О В",368048,null,368048,"город",27.56,25,52.56,0,0,320.03219999999999]
["2006-05-05",1549086," Звездов О В",368048,{"$f":"8*2","v":16},368064,"город",52.56,{"$f":"10+8.5","v":18.5},69.56,1.5,1.5,530229.06449999998]
["2006-05-08","1549088"," Звездов О В",368064,{"$f":"269*2","v":538},368602,"город, за городом",69.56,null,20.96,48.6,48.6,null,null,"г. Минск ул. Железнод 27 - гБуда-Кашелев и обратно",null,null,null,null,{"$f":"92*9.4/100","v":8.6480000000000015},{"$f":"446*8.96/100","v":39.961600000000004},{"$f":"T288+U288","v":48.609600000000007}]
["2006-05-09",null," Звездов О В",368602,null,368602,"город",20.96,null,20.96,0,0,null,null,"г. Минск ул. Железнод 27 - гБуда-Кашелев и обратно",null,null,null,null,"не хват топлив"]
["2006-05-10",null," Звездов О В",368602,null,368602,"город",20.96,null,20.96,0,0,null,null,"г. Минск ул. Железнод 27 - г. Береза и обратно",null,null,null,null,"не хват топлив"]
["2006-05-11","1549087"," Звездов О В",368602,130,368732,"город",20.96,55,63.74,12.22,12.22,358.35183000000001]
["2006-05-12","1549089"," Звездов О В",368732,{"$f":"291+86+186","v":563},369295,"город, за городом",63.74,null,12.98,50.76,50.76,null,null,"г. Минск ул. Железнод 27 - г. Дрогичин и обратно,г. Минск ул. Железнод 27 -д. Замки и обратно",null,null,null,null,null,{"$f":"71*9.4/100","v":6.6739999999999995},{"$f":"492*8.96/100","v":44.083200000000005},{"$f":"U292+V292","v":50.757200000000005}]
["2006-05-15","1549091"," Звездов О В",369295,16,369311,"город",12.98,20,31.48,1.5,1.5,218370,null,"г. Минск ул. Железнод 27 - г. Дрогичин и обратно",null,null,null,null,"не хват топлив"]
["2006-05-16",null," Звездов О В",369311,null,369311,"город",31.48,null,31.48,0,0]
["2006-05-17",null," Звездов О В",369311,null,369311,"город",31.48,10,41.48,0,0,141638]
["2006-05-18","1549092"," Звездов О В",369311,{"$f":"147*2","v":294},369605,"город, за городом",41.48,null,14.79,26.69,26.69,null,null,"г. Минск ул. Железнод 27 - г. Барановичи и обратно",null,null,null,null,{"$f":"78*9.4/100","v":7.3320000000000007},{"$f":"216*8.96/100","v":19.3536},{"$f":"T296+U296","v":26.685600000000001}]
["2006-05-19",null," Звездов О В",369605,null,369605,"город",14.79,20,34.79,0,0,339.31900000000002]
["2006-05-22","1549093"," Звездов О В",369605,240,369845,"город",34.79,20,32.229999999999997,22.56,22.56,75070.023799999995]
["2006-05-23",null," Звездов О В",369845,null,369845,"город",32.229999999999997,10,42.23,0,0,408]
["2006-05-24","1549094"," Звездов О В",369845,280,370125,"город",42.23,20,35.909999999999997,26.32,26.32,207.02780000000001]
["2006-05-25",1549090," Звездов О В",370125,{"$f":"10*2+12*2","v":44},370169,"город",35.909999999999997,20,51.77,4.1399999999999997,4.1399999999999997,380.00209999999998]
["2006-05-26","1549883"," Звездов О В",370169,{"$f":"157*2","v":314},370483,"город, за городом",51.77,40,63.27,28.5,28.5,"0032",null,"г. Минск ул. Железнод 27 -д. Замки и обратно",null,null,null,null,{"$f":"82*9.4/100","v":7.7080000000000011},{"$f":"232*8.96/100","v":20.787200000000002},{"$f":"T302+U302","v":28.495200000000004}]
["2006-05-29","1549884"," Звездов О В",370483,250,370733,"город",63.27,57,96.77,23.5,23.5,380563.03590000002]
["2006-05-30","1549885"," Звездов О В",{"$f":"F303","v":370733},191,370924,"город",96.77,10,88.82,17.95,17.95,5218]
["2006-05-31",null," Звездов О В",{"$f":"F304","v":370924},null,370924,"город",88.82,null,88.82,0,0]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"ROUND(7.2/100*E306,2)","v":0}]
[null,null," Звездов О В",{"$f":"F306","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J306","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F313","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J313","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F314","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J314+16","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E283:E305)","v":3490},null,null,null,{"$f":"SUM(I283:I305)","v":325.5},null,{"$f":"SUM(K283:K305)","v":319.91999999999996},{"$f":"K316","v":319.91999999999996}]
[]
["Составил  ФИО  _________________"]
[null,null,null,null,"(подпись)"]
["Проверил  _____________________________________"]
[null,null,null,"(подпись)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 208 D",null,null,null,null,null,"государственный номерной знак 8060 АМ-7"]
["за июнь 2006 года"]
[]
["Материально ответственное лицо "]
[" Звездов О В, Таратушкин И П"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D342+E342","v":478248},null,497.89,null,{"$f":"H342+#REF!-K342+I342","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H343+#REF!-K343+I343","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F342","v":478248},410,{"$f":"D344+E344","v":478658},null,240.54,250.02,{"$f":"H344+#REF!-K344+I344","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F344","v":478658},263,{"$f":"D345+E345","v":478921},null,{"$f":"J344","v":{"$error":"#REF!"}},null,{"$f":"H345+#REF!-K345+I345","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F345","v":478921},826,{"$f":"D346+E346","v":479747},null,{"$f":"J345","v":{"$error":"#REF!"}},185.05,{"$f":"H346+#REF!-K346+I346","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F346","v":479747},1400,{"$f":"D347+E347","v":481147},null,{"$f":"J346","v":{"$error":"#REF!"}},334,{"$f":"H347+#REF!-K347+I347","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F347","v":481147},1400,{"$f":"D348+E348","v":482547},null,{"$f":"J347","v":{"$error":"#REF!"}},197,{"$f":"H348+#REF!-K348+I348","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J348","v":{"$error":"#REF!"}},230,{"$f":"H349+#REF!-K349+I349","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E344:E348)","v":4299},null,null,null,{"$f":"SUM(I344:I349)","v":1196.0700000000002},null,{"$f":"SUM(K344:K349)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-06-01","1549095"," Звездов О В",{"$f":"F305","v":370924},{"$f":"208*2+7*2","v":430},{"$f":"D352+E352","v":371354},"город, за городом",88.82,10,{"$f":"ROUND(H352+I352-K352,2)","v":60.05},38.770000000000003,{"$f":"K352","v":38.770000000000003},558,null,"г. Минск ул. Железнод 27 -г. Орша и обратно",null,null,null,null,null,{"$f":"56*9.4/100","v":5.2639999999999993},{"$f":"374*8.96/100","v":33.510400000000004},{"$f":"U352+V352","v":38.7744}]
["2006-06-02","1549096"," Звездов О В",{"$f":"F352","v":371354},{"$f":"257+127+310+7*2+12*2+209*2","v":1150},{"$f":"D353+E353","v":372504},"город, за городом",{"$f":"J352","v":60.05},45,1.58,103.47,{"$f":"K353","v":103.47},20179,null,"г. Минск ул. Железнод 27 -г.Волковыск и обратно,г. Минск ул. Железнод 27 -д. Замки и обратно",null,null,null,null,null,{"$f":"98*9.4/100","v":9.2119999999999997},{"$f":"1052*8.96/100","v":94.259200000000007},{"$f":"U353+V353","v":103.47120000000001}]
["2006-06-05",null," Звездов О В",372504,null,372504,"город",1.58,10,11.58,{"$f":"ROUND(9.4/100*E354,2)","v":0},0,391581]
["2006-06-06","1549097"," Звездов О В",372504,{"$f":"7*2+19*2","v":52},372556,"город",11.58,12,18.690000000000001,4.8899999999999997,4.8899999999999997,97001]
["2006-06-07",1549098," Звездов О В",372556,{"$f":"15*2+17*2+7*2","v":78},372634,"город",18.690000000000001,null,11.36,7.33,7.33]
["2006-06-08","1549886"," Звездов О В",372634,31,372665,"город",11.36,20,28.45,2.91,2.91,16157]
["2006-06-09",null," Звездов О В",372665,null,372665,"город",28.45,40,68.45,0,0,92927]
["2006-06-12",null,"Сансевич И А",372665,null,372665,"город",68.45,null,68.45,0,0]
["2006-06-13",null,"Сансевич И А",372665,null,372665,"город",68.45,10,78.45,0,0,23961]
["2006-06-14","1549099","Таратушкин И П",372665,{"$f":"13*2","v":26},372691,"город",78.45,10,86.01,2.44,2.44,63980]
["2006-06-15","1549100","Таратушкин И П",372691,{"$f":"14*2+7*2","v":42},372733,"город",86.01,null,82.06,3.95,3.95]
["2006-06-16",null,"Таратушкин И П",372733,null,372733,"город",82.06,null,82.06,0,0]
["2006-06-19",null,"Таратушкин И П",372733,null,372733,"город",82.06,15,97.06,0,0,25401]
["2006-06-20",null,"Таратушкин И П",372733,null,372733,"город",97.06,null,97.06,0,0]
["2006-06-21",null,"Таратушкин И П",372733,null,372733,"город",97.06,null,97.06,0,0,null,null,null,",г. Минск ул. Железнод 27 -д. Замки и обратно",null,null,null,null,"не хват топлив"]
["2006-06-22","1549101","Таратушкин И П",372733,{"$f":"7*2+8*2","v":30},372763,"город",97.06,null,94.24,2.82,2.82]
["2006-06-23","1549102","Таратушкин И П",372763,{"$f":"8*2+394*2","v":804},373567,"город, за городом",94.24,null,21.72,72.52,72.52]
["2006-06-24",null,"Таратушкин И П",373567,null,373567,"город",21.72,{"$f":"50.98+15+15.62","v":81.599999999999994},103.32,0,0,"0028,0035,0034",null,null,{"$f":"110*9.4/100","v":10.34},null,{"$f":"694*8.96/100","v":62.182400000000008},{"$f":"P369+R369","v":72.522400000000005}]
["2006-06-26","1549103","Таратушкин И П",373567,{"$f":"30*2","v":60},373627,"город",103.32,{"$f":"10+4.1","v":14.1},111.87,5.55,5.55,43910.024700000002,null,null,{"$f":"40*9.4/100","v":3.76},{"$f":"20*8.96/100","v":1.7920000000000003},{"$f":"P370+Q370","v":5.5519999999999996}]
["2006-06-27",1549887,"Таратушкин И П",373627,{"$f":"246*2","v":492},374119,"город, за городом",111.87,null,67.41,44.46,44.46,null,null,null,"г. Минск ул. Железнод 27 -г.Белоозерск и обратно",null,null,null,{"$f":"86*9.4/100","v":8.0839999999999996},{"$f":"406*8.96/100","v":36.377600000000001},{"$f":"T371+U371","v":44.461600000000004}]
["2006-06-28","1549888","Таратушкин И П",374119,{"$f":"246*2","v":492},374611,"город, за городом",67.41,null,22.95,44.46,44.46,null,null,null,"г. Минск ул. Железнод 27 -г.Белоозерск и обратно"]
["2006-06-29","1549104","Таратушкин И П",374611,{"$f":"11*2","v":22},374633,"город",22.95,null,20.88,2.0699999999999998,2.0699999999999998]
["2006-06-30","1549105","Таратушкин И П",374633,{"$f":"12*2+22*2+14*2","v":96},374729,"город",20.88,null,11.86,9.02,9.02]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F375","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J375","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F382","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J382","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F383","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J383+16","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E352:E374)","v":3805},null,null,null,{"$f":"SUM(I352:I374)","v":267.7},null,{"$f":"SUM(K352:K374)","v":344.65999999999991},{"$f":"K385","v":344.65999999999991}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,267.7]
["Составил  ФИО  _________________"]
[null,null,null,null,"(подпись)"]
["Проверил  _____________________________________"]
[null,null,null,"(подпись)"]
[]
[]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 208 D",null,null,null,null,null,"государственный номерной знак 8060 АМ-7"]
["за июль  2006 года"]
[]
["Материально ответственное лицо "]
["Таратушкин И П"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D406+E406","v":478248},null,497.89,null,{"$f":"H406+#REF!-K406+I406","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H407+#REF!-K407+I407","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F406","v":478248},410,{"$f":"D408+E408","v":478658},null,240.54,250.02,{"$f":"H408+#REF!-K408+I408","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F408","v":478658},263,{"$f":"D409+E409","v":478921},null,{"$f":"J408","v":{"$error":"#REF!"}},null,{"$f":"H409+#REF!-K409+I409","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F409","v":478921},826,{"$f":"D410+E410","v":479747},null,{"$f":"J409","v":{"$error":"#REF!"}},185.05,{"$f":"H410+#REF!-K410+I410","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F410","v":479747},1400,{"$f":"D411+E411","v":481147},null,{"$f":"J410","v":{"$error":"#REF!"}},334,{"$f":"H411+#REF!-K411+I411","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F411","v":481147},1400,{"$f":"D412+E412","v":482547},null,{"$f":"J411","v":{"$error":"#REF!"}},197,{"$f":"H412+#REF!-K412+I412","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J412","v":{"$error":"#REF!"}},230,{"$f":"H413+#REF!-K413+I413","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E408:E412)","v":4299},null,null,null,{"$f":"SUM(I408:I413)","v":1196.0700000000002},null,{"$f":"SUM(K408:K413)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-07-03",null,"Таратушкин И П",{"$f":"F374","v":374729},null,{"$f":"D416+E416","v":374729},"город",11.86,null,{"$f":"ROUND(H416+I416-K416,2)","v":11.86},{"$f":"ROUND(9.4/100*E416,2)","v":0},{"$f":"K416","v":0}]
["2006-07-04","1549106","Таратушкин И П",{"$f":"F416","v":374729},{"$f":"7*2+14*2","v":42},{"$f":"D417+E417","v":374771},"город",{"$f":"J416","v":11.86},null,7.91,{"$f":"ROUND(9.4/100*E417,2)","v":3.95},{"$f":"K417","v":3.95}]
["2006-07-05",null,"Таратушкин И П",374771,null,374771,"город",7.91,{"$f":"17+50+10","v":77},84.91,0,0,"441405,21761,122950"]
["2006-07-06",null,"Таратушкин И П",374771,null,374771,"город",84.91,null,84.91,0,0]
["2006-07-07",1549107,"Таратушкин И П",374771,{"$f":"10*2+13*2+17*2","v":80},374851,"город",84.91,null,77.39,7.52,7.52]
["2006-07-10",null,"Таратушкин И П",374851,null,374851,"город",77.39,null,77.39,0,0]
["2006-07-11","1549108","Таратушкин И П",374851,{"$f":"10*2","v":20},374871,"город",77.39,null,75.510000000000005,1.88,1.88]
["2006-07-12","1549109","Таратушкин И П",374871,{"$f":"12*2","v":24},374895,"город",75.510000000000005,40,113.25,2.2599999999999998,2.2599999999999998,79450]
["2006-07-13",null,"Таратушкин И П",374895,null,374895,"город",113.25,null,113.25,0,0]
["2006-07-14","1549889","Таратушкин И П",374895,{"$f":"320*2","v":640},375535,"город, за городом",113.25,null,55.54,57.71,57.71,null,null,"г. Минск ул. Железнод 27 -г брест и обратно",null,null,null,{"$f":"85*9.4/100","v":7.99},{"$f":"555*8.96/100","v":49.728000000000002},{"$f":"S425+T425","v":57.718000000000004}]
["2006-07-17","1549110","Таратушкин И П",375535,{"$f":"9*2+32*2","v":82},375617,"город, за городом",55.54,15,63.01,7.53,7.53,337,null,"г. Минск ул. Железнод 27 -г брест и обратно",null,null,null,null,"не хват топлив",null,{"$f":"42*9.4/100","v":3.948},{"$f":"40*8.96/100","v":3.5840000000000005},{"$f":"V426+W426","v":7.532}]
["2006-07-18","1549111","Таратушкин И П",375617,{"$f":"315*2","v":630},376247,"город, за городом",63.01,60,66.25,56.76,56.76,553.10015499999997,null,"г. Минск ул. Железнод 27 -г витебск и обратно",null,null,null,null,{"$f":"71*9.4/100","v":6.6739999999999995},{"$f":"559*8.96/100","v":50.086400000000005},{"$f":"T427+U427","v":56.760400000000004}]
["2006-07-19","1549113","Таратушкин И П",376247,430,376677,"город, за городом",66.25,null,27.33,38.92,38.92,null,null,"г. Минск ул. Железнод 27 -г Орша и обратно",null,null,null,null,{"$f":"89*9.4/100","v":8.3659999999999997},{"$f":"341*8.96/100","v":30.553600000000003},{"$f":"T428+U428","v":38.919600000000003}]
["2006-07-20",null,"Таратушкин И П",376677,null,376677,"город",27.33,null,27.33,0,0,null,null,"г. Минск ул. Железнод 27 -г витебск и обратно",null,null,null,null,"не хват топлив"]
["2006-07-21","1549112","Таратушкин И П",376677,{"$f":"13*2","v":26},376703,"город",27.33,{"$f":"30.2+12","v":42.2},67.09,2.44,2.44,441,374]
["2006-07-24",null,"Таратушкин И П",376703,null,376703,"город",67.09,null,67.09,0,0]
["2006-07-25","1549114","Таратушкин И П",376703,16,376719,"город",67.09,20,85.59,1.5,1.5,21968,null,null,null,null,null,null,{"$f":"110*9.4/100","v":10.34},{"$f":"310*8.96/100","v":27.776000000000003},{"$f":"T432+U432","v":38.116}]
["2006-07-26",null,"Таратушкин И П",376719,null,376719,"город",85.59,null,85.59,0,0]
["2006-07-27",1549890,"Таратушкин И П",376719,{"$f":"270*2","v":540},377259,"город, за городом",85.59,15,51.73,48.86,48.86,181502,null,"г. Минск ул. Железнод 27 -г Верхнедвинск и обр",null,null,null,null,{"$f":"109*9.4/100","v":10.246000000000002},{"$f":"431*8.96/100","v":38.617600000000003},{"$f":"T434+U434","v":48.863600000000005}]
["2006-07-28","1549891","Таратушкин И П",377259,{"$f":"170*2","v":340},377599,"город, за городом",51.73,30,50.91,30.82,30.82,137,null,"г. Минск ул. Железнод 27 -г Орша и обратно",null,null,null,null,{"$f":"82*9.4/100","v":7.7080000000000011},{"$f":"258*8.96/100","v":23.116800000000001},{"$f":"T435+U435","v":30.824800000000003}]
["2006-07-31","1549892","Таратушкин И П",377599,{"$f":"202*2","v":404},378003,"город, за городом",50.91,{"$f":"15.5+9.6","v":25.1},39.44,36.57,36.57,110.44799999999999,null,null,null,null,null,null,{"$f":"85*9.4/100","v":7.99},{"$f":"319*8.96/100","v":28.582400000000003},{"$f":"T436+U436","v":36.572400000000002}]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"ROUND(7.2/100*E437,2)","v":0}]
[null,null," Звездов О В",{"$f":"F437","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J437","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F444","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J444","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
[null,null," Звездов О В",{"$f":"F445","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$f":"J445+16","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E417:E436)","v":3274},null,null,null,{"$f":"SUM(I417:I436)","v":324.3},null,{"$f":"SUM(K416:K436)","v":296.71999999999997},{"$f":"K447","v":296.71999999999997}]
[]
["Составил  ФИО  _________________"]
[null,null,null,null,"(подпись)",null,null,null,null,null,null,null,null,null,324.3]
["Проверил  _____________________________________"]
[null,null,null,"(подпись)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H416+I447-K447","v":39.440000000000055}]
[]
[]
[]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 208 D",null,null,null,null,null,"государственный номерной знак 8060 АМ-7"]
["за август 2006 года"]
[]
["Материально ответственное лицо "]
["Таратушкин И П"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D470+E470","v":478248},null,497.89,null,{"$f":"H470+#REF!-K470+I470","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H471+#REF!-K471+I471","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F470","v":478248},410,{"$f":"D472+E472","v":478658},null,240.54,250.02,{"$f":"H472+#REF!-K472+I472","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F472","v":478658},263,{"$f":"D473+E473","v":478921},null,{"$f":"J472","v":{"$error":"#REF!"}},null,{"$f":"H473+#REF!-K473+I473","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F473","v":478921},826,{"$f":"D474+E474","v":479747},null,{"$f":"J473","v":{"$error":"#REF!"}},185.05,{"$f":"H474+#REF!-K474+I474","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F474","v":479747},1400,{"$f":"D475+E475","v":481147},null,{"$f":"J474","v":{"$error":"#REF!"}},334,{"$f":"H475+#REF!-K475+I475","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F475","v":481147},1400,{"$f":"D476+E476","v":482547},null,{"$f":"J475","v":{"$error":"#REF!"}},197,{"$f":"H476+#REF!-K476+I476","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J476","v":{"$error":"#REF!"}},230,{"$f":"H477+#REF!-K477+I477","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E472:E476)","v":4299},null,null,null,{"$f":"SUM(I472:I477)","v":1196.0700000000002},null,{"$f":"SUM(K472:K477)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-08-01","1549115","Таратушкин И П",{"$f":"F436","v":378003},{"$f":"37*2","v":74},{"$f":"D480+E480","v":378077},"город, за городом",39.44,20,{"$f":"ROUND(H480+I480-K480,2)","v":52.68},6.76,{"$f":"K480","v":6.76},21315,20,{"$f":"15*2*9.4/100","v":2.82},{"$f":"44*8.96/100","v":3.9424000000000001},{"$f":"O480+P480","v":6.7623999999999995}]
["2006-08-02","1549117","Таратушкин И П",{"$f":"F480","v":378077},{"$f":"110*2","v":220},{"$f":"D481+E481","v":378297},"город, за городом",{"$f":"J480","v":52.68},null,32.57,20.11,{"$f":"K481","v":20.11},null,null,"г. Минск ул. Железнод 27 - гБуда-Кашелев и обратно г. Минск ул. Железнод 27 -Слуцк и обрат",null,null,null,null,null,{"$f":"91*9.4/100","v":8.5540000000000003},{"$f":"129*8.96/100","v":11.558400000000001},{"$f":"135*8.96/100","v":12.096000000000002},{"$f":"U481+V481","v":20.112400000000001}]
["2006-08-03",null,"Таратушкин И П",378297,null,378297,"город",32.57,null,32.57,{"$f":"ROUND(9.4/100*E482,2)","v":0},0]
["2006-08-04",null,"Таратушкин И П",378297,null,378297,"город",32.57,null,32.57,0,0,null,null," г. Минск ул. Железнод 27 -Слуцк и обрат"]
["2006-08-07",1549116,"Таратушкин И П",378297,{"$f":"12*2+126*2+13*2","v":302},378599,"город, за городом",32.57,10,14.98,27.59,27.59,559,10,"г. Минск ул. Железнод 27 -г.Волковыск и обратно Минск-Солигорск",null,null,"нет топлива",null,null,{"$f":"120*9.4/100","v":11.28},{"$f":"182*8.96/100","v":16.307200000000002},{"$f":"U484+V484","v":27.587200000000003}]
["2006-08-08","1549893","Таратушкин И П",378599,{"$f":"3.5*2","v":7},378606,"город",14.98,null,14.32,0.66,0.66,null,null,"г. Минск ул. Железнод 27 -Ляховичи Минск-Слуцк и обратно",null,null,"нет топлива"]
["2006-08-09",null,"Таратушкин И П",378606,null,378606,"город",14.32,null,14.32,0,0,null,null," Минск-Солигорск",null,null,"нет топлива"]
["2006-08-10","1549119","Таратушкин И П",378606,{"$f":"73*2","v":146},378752,"город, за городом",14.32,46.5,47.52,13.3,13.3,"0030",46.5,null,{"$f":"25*2*9.4/100","v":4.7},{"$f":"96*8.96/100","v":8.6016000000000012},{"$f":"P487+Q487","v":13.301600000000001}]
["2006-08-11",null,"Таратушкин И П",378752,null,378752,"город",47.52,10,57.52,0,0,395,10]
["2006-08-14","1549120","Таратушкин И П",378752,210,378962,"город, за городом",57.52,15,52.78,19.739999999999998,19.739999999999998,51507,15]
["2006-08-15",null,"Таратушкин И П",378962,null,378962,"город",52.78,{"$f":"30+15","v":45},97.78,0,0,37551.040000000001,15,30]
["2006-08-16",null,"Таратушкин И П",378962,null,378962,"город",97.78,null,97.78,0,0]
["2006-08-17","1549122","Таратушкин И П",378962,{"$f":"14*2","v":28},378990,"город",97.78,null,95.15,2.63,2.63]
["2006-08-18","1549123","Таратушкин И П",378990,{"$f":"10*2+12*2","v":44},379034,"город",95.15,null,91.01,4.1399999999999997,4.1399999999999997]
["2006-08-21",null,"Таратушкин И П",379034,null,379034,"город",91.01,null,91.01,0,0]
["2006-08-22",null,"Таратушкин И П",379034,null,379034,"город",91.01,null,91.01,0,0]
["2006-08-23",null,"Таратушкин И П",379034,null,379034,"город",91.01,null,91.01,0,0]
["2006-08-24",null,"Таратушкин И П",379034,null,379034,"город",91.01,null,91.01,0,0]
["2006-08-25",1549125,"Таратушкин И П",379034,{"$f":"21*2","v":42},379076,"город",91.01,null,87.06,3.95,3.95]
["2006-08-28",null,"Таратушкин И П",379076,null,379076,"город",87.06,null,87.06,0,0]
["2006-08-29","1549121","Таратушкин И П",379076,{"$f":"142*2","v":284},379360,"город, за городом",87.06,null,61.31,25.75,25.75,null,null," Минск-Солигорск",null,null,null,{"$f":"35*2*9.4/100","v":6.58},{"$f":"214*8.96/100","v":19.174400000000002},{"$f":"S500+T500","v":25.754400000000004}]
["2006-08-30",null,"Таратушкин И П",379360,null,379360,"город",61.31,null,61.31,0,0]
["2006-08-31",null,"Таратушкин И П",379360,null,379360,null,61.31,null,61.31,0]
["2006-09-01",null,"Таратушкин И П",379360,null,379360,null,61.31,null,61.31,0]
["2006-09-02",null,"Таратушкин И П",379360,null,379360,null,61.31,null,61.31,0]
["2006-09-03",null,"Таратушкин И П",379360,null,379360,null,61.31,null,61.31,0]
["2006-09-04",null,"Таратушкин И П",379360,null,379360,null,61.31,null,61.31,0]
["2006-09-05",null,"Таратушкин И П",379360,null,379360,null,61.31,null,61.31,0]
["2006-09-06",null,"Таратушкин И П",379360,null,379360,null,61.31,null,61.31,0]
["2006-09-07",null,"Таратушкин И П",379360,null,379360,null,61.31,null,61.31,0]
["2006-09-08",null,"Таратушкин И П",379360,null,379360,null,61.31,null,61.31,0]
["2006-09-09",null,"Таратушкин И П",379360,null,379360,null,61.31,null,61.31,0]
["2006-08-31","1549126","Таратушкин И П",379360,14,{"$f":"D512+E512","v":379374},"город",61.31,null,59.99,1.32,{"$f":"K512","v":1.32}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E480:E512)","v":1371},null,null,null,{"$f":"SUM(I480:I501)","v":146.5},null,{"$f":"SUM(K480:K512)","v":125.94999999999997},{"$f":"K513","v":125.94999999999997}]
[]
["Составил  ФИО  _________________"]
[null,null,null,null,"(подпись)"]
["Проверил  _____________________________________",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"146.5+15+1","v":162.5}]
[null,null,null,"(подпись)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,156.5,15]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H480+I513-K513","v":59.990000000000023}]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 208 D",null,null,null,null,null,"государственный номерной знак 8060 АМ-7"]
["за сентябрь 2006 года"]
[]
["Материально ответственное лицо "]
["Таратушкин И П"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D535+E535","v":478248},null,497.89,null,{"$f":"H535+#REF!-K535+I535","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H536+#REF!-K536+I536","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F535","v":478248},410,{"$f":"D537+E537","v":478658},null,240.54,250.02,{"$f":"H537+#REF!-K537+I537","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F537","v":478658},263,{"$f":"D538+E538","v":478921},null,{"$f":"J537","v":{"$error":"#REF!"}},null,{"$f":"H538+#REF!-K538+I538","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F538","v":478921},826,{"$f":"D539+E539","v":479747},null,{"$f":"J538","v":{"$error":"#REF!"}},185.05,{"$f":"H539+#REF!-K539+I539","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F539","v":479747},1400,{"$f":"D540+E540","v":481147},null,{"$f":"J539","v":{"$error":"#REF!"}},334,{"$f":"H540+#REF!-K540+I540","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F540","v":481147},1400,{"$f":"D541+E541","v":482547},null,{"$f":"J540","v":{"$error":"#REF!"}},197,{"$f":"H541+#REF!-K541+I541","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J541","v":{"$error":"#REF!"}},230,{"$f":"H542+#REF!-K542+I542","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E537:E541)","v":4299},null,null,null,{"$f":"SUM(I537:I542)","v":1196.0700000000002},null,{"$f":"SUM(K537:K542)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-09-01","1549127","Таратушкин И П",{"$f":"F512","v":379374},291,{"$f":"D545+E545","v":379665},"город",{"$f":"J512","v":59.99},17,{"$f":"ROUND(H545+I545-K545,2)","v":49.64},{"$f":"ROUND(9.4/100*E545,2)","v":27.35},{"$f":"K545","v":27.35},337]
["2006-09-04",null,"Таратушкин И П",{"$f":"F545","v":379665},null,{"$f":"D546+E546","v":379665},"город",{"$f":"J545","v":49.64},null,49.64,{"$f":"ROUND(9.4/100*E546,2)","v":0},{"$f":"K546","v":0}]
["2006-09-05",null,"Таратушкин И П",379665,null,379665,"город",49.64,null,49.64,0,0]
["2006-09-06","1549128","Таратушкин И П",379665,{"$f":"22*2","v":44},379709,"город",49.64,10,55.5,4.1399999999999997,4.1399999999999997,280]
["2006-09-07",1549129,"Таратушкин И П",379709,{"$f":"41*2","v":82},379791,"город, за городом",55.5,10,58.03,7.47,7.47,238,null,null,null,null,{"$f":"30*9.4/100","v":2.82},{"$f":"52*8.96/100","v":4.6592000000000011},{"$f":"R549+S549","v":7.4792000000000005}]
["2006-09-08","1549130","Таратушкин И П",379791,{"$f":"12*2+157*2","v":338},380129,"город, за городом",58.03,null,27.28,30.75,30.75,null,null,"Минск-Замки",null,null,{"$f":"106*9.4/100","v":9.9640000000000004},{"$f":"232*8.96/100","v":20.787200000000002},{"$f":"R550+S550","v":30.751200000000004}]
["2006-09-11","1549132","Таратушкин И П",380129,{"$f":"41*2","v":82},380211,"город, за городом",27.28,15,34.799999999999997,7.48,7.48,44496,null,null,null,null,{"$f":"30*9.4/100","v":2.82},{"$f":"52*8.96/100","v":4.6592000000000011},{"$f":"R551+S551","v":7.4792000000000005}]
["2006-09-12","1549131","Сансевич И А",380211,7,380218,"город",34.799999999999997,50,84.14,0.66,0.66,"551413"]
["2006-09-13",null,"Таратушкин И П",380218,null,380218,"город",84.14,9,93.14,0,0,17479]
["2006-09-14","1549133","Таратушкин И П",380218,{"$f":"145*2","v":290},380508,"город, за городом",93.14,20,87.39,25.75,25.75,362,null,"Минск-Солигорск",null,null,{"$f":"35*2*9.4/100","v":6.58},{"$f":"214*8.96/100","v":19.174400000000002},{"$f":"R554+S554","v":25.754400000000004}]
["2006-09-15","1549124","Таратушкин И П",380508,{"$f":"145*2","v":290},380798,"город, за городом",87.39,null,61.64,25.75,25.75,null,null,"Минск-Солигорск",null,null,{"$f":"35*2*9.4/100","v":6.58},{"$f":"214*8.96/100","v":19.174400000000002},{"$f":"R555+S555","v":25.754400000000004}]
["2006-09-18",null,"Таратушкин И П",380798,null,380798,"город",61.64,null,61.64,0,0]
["2006-09-19","1549894","Таратушкин И П",380798,{"$f":"191*2","v":382},381180,"город, за городом",61.64,25,52.16,34.479999999999997,34.479999999999997,263,null,"Минск-ганцевичи",null,null,{"$f":"29*2*9.4/100","v":5.4520000000000008},{"$f":"324*8.96/100","v":29.030400000000004},{"$f":"R557+S557","v":34.482400000000005}]
["2006-09-20","1549895","Таратушкин И П",381180,{"$f":"157*2","v":314},381494,"город, за городом",52.16,30,53.66,28.5,28.5,28783,null,"Минск -д. Замки",null,null,{"$f":"82*9.4/100","v":7.7080000000000011},{"$f":"232*8.96/100","v":20.787200000000002},{"$f":"R558+S558","v":28.495200000000004}]
["2006-09-21","1549896","Таратушкин И П",381494,{"$f":"145*2","v":290},381784,"город, за городом",53.66,46.5,74.41,25.75,25.75,606,null,"Минск-Солигорск",null,null,{"$f":"35*2*9.4/100","v":6.58},{"$f":"214*8.96/100","v":19.174400000000002},{"$f":"R559+S559","v":25.754400000000004}]
["2006-09-22","1549134","Таратушкин И П",381784,{"$f":"86*2","v":172},381956,"город, за городом",74.41,40,98.78,15.63,15.63,466,null,null,null,null,{"$f":"25*2*9.4/100","v":4.7},{"$f":"122*8.96/100","v":10.9312},{"$f":"R560+S560","v":15.6312}]
["2006-09-25","1549135","Таратушкин И П",381956,{"$f":"18*2","v":36},381992,"город",98.78,17.600000000000001,113,3.38,3.38,281]
["2006-09-26","1549136","Таратушкин И П",381992,{"$f":"12*2+13*2","v":50},382042,"город",113,null,108.3,4.7,4.7]
["2006-09-27",1549137,"Таратушкин И П",382042,{"$f":"9*2+10*2","v":38},382080,"город",108.3,null,104.73,3.57,3.57]
["2006-09-28",null,"Таратушкин И П",382080,null,382080,"город",104.73,null,104.73,0,0]
["2006-09-29","1549897","Таратушкин И П",382080,282,382362,"город",104.73,20,98.22,26.51,26.51,7220]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E545:E565)","v":2988},null,null,null,{"$f":"SUM(I545:I565)","v":310.10000000000002},null,{"$f":"SUM(K545:K565)","v":271.87},{"$f":"K566","v":271.87}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"за октябрь",310]
["Составил  ФИО  _________________",null,null,null,null,null,null,null,null,null,null,null,null,310.10000000000002,null,"2,9 спринтер"]
[null,null,null,null,"(подпись)",null,null,null,null,null,null,null,null,null,null,null,null,null,"за ноябрь",287.3]
["Проверил  _____________________________________"]
[null,null,null,"(подпись)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"за  декаб",120]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 208 D",null,null,null,null,null,"государственный номерной знак 8060 АМ-7"]
["за октябрь 2006 года"]
[]
["Материально ответственное лицо "]
["Таратушкин И П"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D593+E593","v":478248},null,497.89,null,{"$f":"H593+#REF!-K593+I593","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H594+#REF!-K594+I594","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F593","v":478248},410,{"$f":"D595+E595","v":478658},null,240.54,250.02,{"$f":"H595+#REF!-K595+I595","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F595","v":478658},263,{"$f":"D596+E596","v":478921},null,{"$f":"J595","v":{"$error":"#REF!"}},null,{"$f":"H596+#REF!-K596+I596","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F596","v":478921},826,{"$f":"D597+E597","v":479747},null,{"$f":"J596","v":{"$error":"#REF!"}},185.05,{"$f":"H597+#REF!-K597+I597","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F597","v":479747},1400,{"$f":"D598+E598","v":481147},null,{"$f":"J597","v":{"$error":"#REF!"}},334,{"$f":"H598+#REF!-K598+I598","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F598","v":481147},1400,{"$f":"D599+E599","v":482547},null,{"$f":"J598","v":{"$error":"#REF!"}},197,{"$f":"H599+#REF!-K599+I599","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J599","v":{"$error":"#REF!"}},230,{"$f":"H600+#REF!-K600+I600","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E595:E599)","v":4299},null,null,null,{"$f":"SUM(I595:I600)","v":1196.0700000000002},null,{"$f":"SUM(K595:K600)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-10-02",null,"Таратушкин И П",{"$f":"F565","v":382362},null,{"$f":"D603+E603","v":382362},"город",98.22,null,{"$f":"ROUND(H603+I603-K603,2)","v":98.22},{"$f":"ROUND(9.4/100*E603,2)","v":0},{"$f":"K603","v":0}]
["2006-10-03","1549138","Таратушкин И П",{"$f":"F603","v":382362},{"$f":"277*2+89*2","v":732},{"$f":"D604+E604","v":383094},"город, за городом",{"$f":"J603","v":98.22},null,32.24,65.98,{"$f":"K604","v":65.98},null,null,"г. Минск ул. Желез- п. Смолевичи Г. Минск-Пружаны",null,null,null,null,{"$f":"89*9.4/100","v":8.3659999999999997},{"$f":"643*8.96/100","v":57.612800000000007},{"$f":"T604+U604","v":65.978800000000007}]
["2006-10-04",null,"Таратушкин И П",383094,null,383094,"город",32.24,10,42.24,{"$f":"ROUND(9.4/100*E605,2)","v":0},0,77616]
["2006-10-05","1549141","Таратушкин И П",383094,{"$f":"6*2+41*2+182*2","v":458},383552,"город, за городом",42.24,null,0.65,41.59,41.59,null,null,"г. Минск ул. Желез- г Лида",null,null,null,null,{"$f":"125*9.4/100","v":11.75},{"$f":"333*8.96/100","v":29.836800000000004},{"$f":"T606+U606","v":41.586800000000004}]
["2006-10-06",null,"Таратушкин И П",383552,null,383552,"город",0.65,null,0.65,0,0]
["2006-10-09",null,"Таратушкин И П",383552,null,383552,"город",0.65,20,20.65,0,0,77758]
["2006-10-10",null,"Таратушкин И П",383552,null,383552,"город",20.65,20,40.65,0,0,83485]
["2006-10-11","1549143","Таратушкин И П",383552,{"$f":"41*2","v":82},383634,"город, за городом",40.65,null,33.17,7.48,7.48,null,null,"г. Минск ул. Желез- г Лида",null,null,null,"не хват топлив",{"$f":"30*9.4/100","v":2.82},{"$f":"52*8.96/100","v":4.6592000000000011},{"$f":"T610+U610","v":7.4792000000000005}]
["2006-10-12",null,"Таратушкин И П",383634,null,383634,"город",33.17,null,33.17,0,0]
["2006-10-13","1549144","Таратушкин И П",383634,{"$f":"41*2+11*2","v":104},383738,"город, за городом",33.17,null,23.62,9.5500000000000007,9.5500000000000007,null,null,null,null,null,null,null,{"$f":"52*9.4/100","v":4.8879999999999999},{"$f":"52*8.96/100","v":4.6592000000000011},{"$f":"T612+U612","v":9.5472000000000001}]
["2006-10-16",null,"Таратушкин И П",383738,null,383738,"город",23.62,null,23.62,0,0]
["2006-10-17",null,"Таратушкин И П",383738,null,383738,"город",23.62,20,43.62,0,0,853]
["2006-10-18",null,"Таратушкин И П",383738,null,383738,"город",43.62,15,58.62,0,0,82833]
["2006-10-19","1549147","Таратушкин И П",383738,{"$f":"15*2+277*2","v":584},384322,"город, за городом",58.62,null,5.8,52.82,52.82,null,null," Г. Минск-Пружаны",null,null,null,null,{"$f":"113*9.4/100","v":10.622},{"$f":"471*8.96/100","v":42.201600000000006},{"$f":"T616+U616","v":52.823600000000006}]
["2006-10-20",null,"Таратушкин И П",384322,null,384322,"город",5.8,null,5.8,0,0]
["2006-10-23","1549149","Таратушкин И П",384322,{"$f":"7*2","v":14},384336,"город",5.8,20,24.48,1.32,1.32,515]
["2006-10-24","1549139","Таратушкин И П",384336,311,384647,"город",24.48,{"$f":"40+25","v":65},60.25,29.23,29.23,439.00439999999998]
["2006-10-25","1549140","Таратушкин И П",384647,365,385012,"город",60.25,null,25.94,34.31,34.31]
["2006-10-26",1549142,"Таратушкин И П",385012,356,385368,"город",25.94,30,22.48,33.46,33.46,281]
["2006-10-27","1549145","Таратушкин И П",385368,230,385598,"город",22.48,null,0.86,21.62,21.62]
["2006-10-30","1549154","Таратушкин И П",385598,{"$f":"21*2","v":42},385640,"город",0.86,30,26.91,3.95,3.95,5.5999999999999999E-3]
["2006-10-31","1549155","Таратушкин И П",385640,{"$f":"25*2+14*2","v":78},385718,"город",26.91,{"$f":"30+50","v":80},99.58,7.33,7.33,202126.88690000001]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E603:E624)","v":3356},null,null,null,{"$f":"SUM(I603:I624)","v":310},null,{"$f":"SUM(K603:K624)","v":308.64},{"$f":"K625","v":308.64}]
[]
[]
[null,null,"Составил  ФИО  _________________"]
[null,null,null,null,null,null,"(подпись)"]
[null,null,"Проверил  _____________________________________"]
[null,null,null,null,null,"(подпись)"]
[]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 208 D",null,null,null,null,null,"государственный номерной знак 8060 АМ-7"]
["за ноябрь 2006 года"]
[]
["Материально ответственное лицо "]
["Таратушкин И П"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D646+E646","v":478248},null,497.89,null,{"$f":"H646+#REF!-K646+I646","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H647+#REF!-K647+I647","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F646","v":478248},410,{"$f":"D648+E648","v":478658},null,240.54,250.02,{"$f":"H648+#REF!-K648+I648","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F648","v":478658},263,{"$f":"D649+E649","v":478921},null,{"$f":"J648","v":{"$error":"#REF!"}},null,{"$f":"H649+#REF!-K649+I649","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F649","v":478921},826,{"$f":"D650+E650","v":479747},null,{"$f":"J649","v":{"$error":"#REF!"}},185.05,{"$f":"H650+#REF!-K650+I650","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F650","v":479747},1400,{"$f":"D651+E651","v":481147},null,{"$f":"J650","v":{"$error":"#REF!"}},334,{"$f":"H651+#REF!-K651+I651","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F651","v":481147},1400,{"$f":"D652+E652","v":482547},null,{"$f":"J651","v":{"$error":"#REF!"}},197,{"$f":"H652+#REF!-K652+I652","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J652","v":{"$error":"#REF!"}},230,{"$f":"H653+#REF!-K653+I653","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E648:E652)","v":4299},null,null,null,{"$f":"SUM(I648:I653)","v":1196.0700000000002},null,{"$f":"SUM(K648:K653)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-11-01","1549156","Таратушкин И П",{"$f":"F624","v":385718},{"$f":"18*2+12*2+253*2","v":566},{"$f":"D656+E656","v":386284},"город, за городом",99.58,null,{"$f":"ROUND(H656+I656-K656,2)","v":48.2},51.38,{"$f":"K656","v":51.38},null,null,"Минск-Берестовица",null,null,{"$f":"151*9.4/100","v":14.194000000000001},{"$f":"415*8.96/100","v":37.184000000000005},{"$f":"R656+S656","v":51.378000000000007},null,"ул Энгельса 1"]
["2006-11-02",null,"Таратушкин И П",{"$f":"F656","v":386284},null,{"$f":"D657+E657","v":386284},"город",{"$f":"J656","v":48.2},20,68.2,{"$f":"ROUND(9.4/100*E657,2)","v":0},{"$f":"K657","v":0},530]
["2006-11-03",null,"Таратушкин И П",{"$f":"F657","v":386284},null,386284,"город",{"$f":"J657","v":68.2},null,68.2,0,0]
["2006-11-04",null,"Таратушкин И П",386284,null,386284,"город",68.2,9,77.2,0,0,88938]
["2006-11-06",null,"Таратушкин И П",386284,null,386284,"город",77.2,null,77.2,0,0]
["2006-11-07",null,"Таратушкин И П",386284,null,386284,"город",77.2,null,77.2,0,0]
["2006-11-08",null,"Таратушкин И П",386284,null,386284,"город",77.2,{"$f":"25+30","v":55},132.19999999999999,0,0,95708.048500000004]
["2006-11-09","1549146","Таратушкин И П",386284,{"$f":"194*2+244*2+101*2","v":1078},387362,"город, за городом",132.19999999999999,null,34.799999999999997,97.4,97.4,null,null,"минск-слоним Минск-Браслов Минск-Замостье",null,null,{"$f":"186*9.4/100","v":17.484000000000002},{"$f":"892*8.96/100","v":79.923200000000008},{"$f":"R663+S663","v":97.407200000000017},null,"Свердлова 86"]
["2006-11-10",null,"Таратушкин И П",387362,null,387362,"город",34.799999999999997,{"$f":"30+60+30","v":120},154.80000000000001,0,0,"113425,7426,64047"]
["2006-11-13","1549148","Таратушкин И П",387362,52,387414,"город",154.80000000000001,7.8,157.71,4.8899999999999997,4.8899999999999997,11977]
["2006-11-14","1549162","Таратушкин И П",387414,{"$f":"10*2","v":20},387434,"город",157.71,15.5,171.33,1.88,1.88,1499]
["2006-11-15",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0,null,null,"Минск-Верхнедвинск",null,null,{"$f":"120*9.4/100","v":11.28},{"$f":"436*8.96/100","v":39.065600000000003},{"$f":"R667+S667","v":50.345600000000005}]
["2006-11-16",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0,null,null,"Минск-Молодечно"]
["2006-11-17",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0]
["2006-11-20",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0]
["2006-11-21",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0]
["2006-11-22",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0,null,null,"Минск-Берестовица Минск-Браслов"]
["2006-11-23",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0]
["2006-11-24",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0]
["2006-11-27",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0,63692]
["2006-11-28",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0,null,null,"Минск-Берестовица Минск-Замостье"]
["2006-11-29",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0,483]
["2006-11-30",null,"Таратушкин И П",387434,null,387434,"город",171.33,null,171.33,0,0]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E656:E678)","v":1716},null,null,null,{"$f":"SUM(I656:I678)","v":227.3},null,{"$f":"SUM(K656:K678)","v":155.54999999999998},{"$f":"K679","v":155.54999999999998}]
[]
[]
[null,"Составил  ФИО  _________________"]
[null,null,null,null,null,"(подпись)"]
[null,"Проверил  _____________________________________"]
[null,null,null,null,"(подпись)"]
[]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 212 D",null,null,null,null,null,"государственный номерной знак 5936 АА-7"]
["за ноябрь 2006 года"]
[]
["Материально ответственное лицо "]
["Таратушкин И П"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D700+E700","v":478248},null,497.89,null,{"$f":"H700+#REF!-K700+I700","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H701+#REF!-K701+I701","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F700","v":478248},410,{"$f":"D702+E702","v":478658},null,240.54,250.02,{"$f":"H702+#REF!-K702+I702","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F702","v":478658},263,{"$f":"D703+E703","v":478921},null,{"$f":"J702","v":{"$error":"#REF!"}},null,{"$f":"H703+#REF!-K703+I703","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F703","v":478921},826,{"$f":"D704+E704","v":479747},null,{"$f":"J703","v":{"$error":"#REF!"}},185.05,{"$f":"H704+#REF!-K704+I704","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F704","v":479747},1400,{"$f":"D705+E705","v":481147},null,{"$f":"J704","v":{"$error":"#REF!"}},334,{"$f":"H705+#REF!-K705+I705","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F705","v":481147},1400,{"$f":"D706+E706","v":482547},null,{"$f":"J705","v":{"$error":"#REF!"}},197,{"$f":"H706+#REF!-K706+I706","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J706","v":{"$error":"#REF!"}},230,{"$f":"H707+#REF!-K707+I707","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E702:E706)","v":4299},null,null,null,{"$f":"SUM(I702:I707)","v":1196.0700000000002},null,{"$f":"SUM(K702:K707)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-11-01",null,"Таратушкин И П",0,null,{"$f":"D710+E710","v":0},"город",0,null,{"$f":"ROUND(H710+I710-K710,2)","v":0},0,{"$f":"K710","v":0},null,null,"Минск-Берестовица",null,null,{"$f":"151*9.4/100","v":14.194000000000001},{"$f":"415*8.96/100","v":37.184000000000005},{"$f":"R710+S710","v":51.378000000000007},null,"ул Энгельса 1"]
["2006-11-02",null,"Таратушкин И П",{"$f":"F710","v":0},null,{"$f":"D711+E711","v":0},"город",{"$f":"J710","v":0},null,0,{"$f":"ROUND(9.4/100*E711,2)","v":0},{"$f":"K711","v":0},530]
["2006-11-03",null,"Таратушкин И П",{"$f":"F711","v":0},null,0,"город",{"$f":"J711","v":0},null,0,0,0]
["2006-11-04",null,"Таратушкин И П",{"$f":"F712","v":0},null,0,"город",{"$f":"J712","v":0},null,0,0,0,88938]
["2006-11-06",null,"Таратушкин И П",0,null,0,"город",0,null,0,0,0]
["2006-11-07",null,"Таратушкин И П",0,null,0,"город",0,null,0,0,0]
["2006-11-08",null,"Таратушкин И П",0,null,0,"город",0,null,0,0,0,95708.048500000004]
["2006-11-09",null,"Таратушкин И П",0,null,0,"город",0,null,0,0,0,null,null,"минск-слоним Минск-Браслов Минск-Замостье",null,null,{"$f":"186*9.4/100","v":17.484000000000002},{"$f":"892*8.96/100","v":79.923200000000008},{"$f":"R717+S717","v":97.407200000000017},null,"Свердлова 86"]
["2006-11-10",null,"Таратушкин И П",0,null,0,"город",0,null,0,{"$f":"ROUND(9.4/100*E718,2)","v":0},0,"113425,7426,64047"]
["2006-11-13",null,"Таратушкин И П",0,null,0,"город",0,null,0,0,0,11977,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Нормы топлива"]
["2006-11-14",null,"Таратушкин И П",0,null,0,"город",0,null,0,0,0,1499]
["2006-11-15","1549163","Таратушкин И П",228355,{"$f":"278*2","v":556},228911,"город, за городом",171.33,null,112.08,59.25,59.25,null,null,"Минск-Верхнедвинск",null,null,{"$f":"120*11.66/100","v":13.992000000000001},{"$f":"436*10.38/100","v":45.256800000000005},{"$f":"R721+S721","v":59.248800000000003},null,null,null,null,null,null,null,null,"город 10,9+7%",null,"за городом -5%"]
["2006-11-16","1549151","Таратушкин И П",228911,{"$f":"76*2","v":152},229063,"город, за городом",112.08,null,95.64,16.440000000000001,16.440000000000001,null,null,"Минск-Молодечно",null,null,{"$f":"52*11.66/100","v":6.0632000000000001},{"$f":"100*10.38/100","v":10.38},{"$f":"R722+S722","v":16.443200000000001},null,null,null,null,null,null,null,null,11.66,null,10.38]
["2006-11-17",null,"Таратушкин И П",229063,null,229063,"город",95.64,null,95.64,0,0]
["2006-11-20",null,"Таратушкин И П",229063,null,229063,"город",95.64,null,95.64,0,0]
["2006-11-21",null,"Таратушкин И П",229063,null,229063,"город",95.64,null,95.64,0,0]
["2006-11-22","1549166","Таратушкин И П",229063,{"$f":"14*2+225*2+203*2","v":884},229947,"город, за городом",95.64,null,0.87,94.77,94.77,null,null,"Минск-Берестовица Минск-Браслов",null,null,{"$f":"235*11.66/100","v":27.401},{"$f":"649*10.38/100","v":67.366200000000006},{"$f":"R726+S726","v":94.767200000000003}]
["2006-11-23",null,"Таратушкин И П",229947,null,229947,"город",0.87,null,0.87,0,0]
["2006-11-24",null,"Таратушкин И П",229947,null,229947,"город",0.87,null,0.87,0,0]
["2006-11-27",null,"Таратушкин И П",229947,null,229947,"город",0.87,20,20.87,0,0,63692]
["2006-11-28","1549153","Таратушкин И П",229947,{"$f":"91*2","v":182},230129,"город, за городом",20.87,null,0.94,19.93,19.93,null,null,"Минск-Берестовица Минск-Замостье",null,null,{"$f":"81*11.66/100","v":9.4446000000000012},{"$f":"101*10.38/100","v":10.4838},{"$f":"R730+S730","v":19.928400000000003},null,{"$f":"19.93-9.44","v":10.49}]
["2006-11-29",null,"Таратушкин И П",230129,null,230129,"город",0.94,40,40.94,0,0,483]
["2006-11-30","1549169","Таратушкин И П",230129,{"$f":"46*2+136*2","v":364},230493,"город, за городом",40.94,null,1.62,39.32,39.32,null,null,null,null,null,{"$f":"120*11.66/100","v":13.992000000000001},{"$f":"244*10.38/100","v":25.327200000000001},{"$f":"R732+S732","v":39.319200000000002},null,null,null,{"$f":"0.777+0.068","v":0.84499999999999997},null,null,{"$f":"39.32-13.99","v":25.33}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E710:E732)","v":2138},null,null,null,{"$f":"SUM(I710:I732)","v":60},null,{"$f":"SUM(K710:K732)","v":229.70999999999998},{"$f":"K733","v":229.70999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"364/2","v":182}]
[]
[]
[null,"Составил  ФИО  _________________"]
[null,null,null,null,null,"(подпись)"]
[null,"Проверил  _____________________________________"]
[null,null,null,null,"(подпись)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ООО Белпромсистем"]
[]
["Карточка № "]
["учета расхода ДТ автомобилем"]
["Марка автомобиля МЕРСЕДЕС БЕНЦ 212 D",null,null,null,null,null,"государственный номерной знак 5936 АА-7"]
["за декабрь 2006 года"]
[]
["Материально ответственное лицо "]
["Таратушкин И П"]
[null,"ДТ"]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км","Показание спидометра после поездки",null,"Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л.","Расход топлива фактически, л."]
["2000-11-28",401421,"Свентицкий А.М.",478048,200,{"$f":"D761+E761","v":478248},null,497.89,null,{"$f":"H761+#REF!-K761+I761","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-04",null,"Свентицкий А.М.",null,null,null,null,440.54,null,{"$f":"H762+#REF!-K762+I762","v":{"$error":"#REF!"}}]
["2000-12-07",401422,"Свентицкий А.М.",{"$f":"F761","v":478248},410,{"$f":"D763+E763","v":478658},null,240.54,250.02,{"$f":"H763+#REF!-K763+I763","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401423,"Свентицкий А.М.",{"$f":"F763","v":478658},263,{"$f":"D764+E764","v":478921},null,{"$f":"J763","v":{"$error":"#REF!"}},null,{"$f":"H764+#REF!-K764+I764","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-13",401424,"Свентицкий А.М.",{"$f":"F764","v":478921},826,{"$f":"D765+E765","v":479747},null,{"$f":"J764","v":{"$error":"#REF!"}},185.05,{"$f":"H765+#REF!-K765+I765","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-15",186080,"Свентицкий А.М.",{"$f":"F765","v":479747},1400,{"$f":"D766+E766","v":481147},null,{"$f":"J765","v":{"$error":"#REF!"}},334,{"$f":"H766+#REF!-K766+I766","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["2000-12-19",186078,"Свентицкий А.М.",{"$f":"F766","v":481147},1400,{"$f":"D767+E767","v":482547},null,{"$f":"J766","v":{"$error":"#REF!"}},197,{"$f":"H767+#REF!-K767+I767","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"J767","v":{"$error":"#REF!"}},230,{"$f":"H768+#REF!-K768+I768","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["ДЕКАБРЬ",null,"ИТОГО",null,{"$f":"SUM(E763:E767)","v":4299},null,null,null,{"$f":"SUM(I763:I768)","v":1196.0700000000002},null,{"$f":"SUM(K763:K768)","v":{"$error":"#REF!"}}]
[1,2,3,4,5,6,7,8,9,10,11,12]
["2006-12-01",null,"Таратушкин И П",{"$f":"F732","v":230493},null,{"$f":"D771+E771","v":230493},"город",1.62,null,{"$f":"ROUND(H771+I771-K771,2)","v":1.62},0,{"$f":"K771","v":0}]
["2006-12-04",null,"Таратушкин И П",{"$f":"F771","v":230493},null,{"$f":"D772+E772","v":230493},"город",{"$f":"J771","v":1.62},null,1.62,{"$f":"ROUND(11.66/100*E772,2)","v":0},{"$f":"K772","v":0},null,null,"Минск-Берестовица",null,null,{"$f":"151*9.4/100","v":14.194000000000001},{"$f":"415*8.96/100","v":37.184000000000005},{"$f":"R772+S772","v":51.378000000000007},null,"ул Энгельса 1",null,null,"не хват топлива"]
["2006-12-05",null,"Таратушкин И П",{"$f":"F772","v":230493},null,230493,"город",{"$f":"J772","v":1.62},null,1.62,{"$f":"ROUND(11.66/100*E773,2)","v":0},0]
["2006-12-06",null,"Таратушкин И П",230493,null,230493,"город",{"$f":"J773","v":1.62},null,1.62,0,0]
["2006-12-07",null,"Таратушкин И П",230493,null,230493,"город",1.62,null,1.62,0,0]
["2006-12-08",null,"Таратушкин И П",230493,null,230493,"город",1.62,null,1.62,0,0]
["2006-12-11",null,"Таратушкин И П",230493,null,230493,"город",1.62,null,1.62,0,0]
["2006-12-12",null,"Таратушкин И П",230493,null,230493,"город",1.62,null,1.62,0,0,null,null,"Минск-Берестовица",null,null,{"$f":"151*9.4/100","v":14.194000000000001},{"$f":"415*8.96/100","v":37.184000000000005},{"$f":"R778+S778","v":51.378000000000007},null,"ул Энгельса 1",null,null,"не хват топлива"]
["2006-12-13","1549170","Таратушкин И П",230493,{"$f":"41*2+12*2+67*2","v":240},230733,"город, за городом",1.62,60,35.950000000000003,25.67,25.67,154250,null,"минск-столбцы",null,null,{"$f":"59*11.66/100","v":6.8794000000000004},{"$f":"181*10.38/100","v":18.787800000000001},{"$f":"R779+S779","v":25.667200000000001},null,null,null,null,null,null,null,null,"Нормы топлива"]
["2006-12-14","1549177","Таратушкин И П",230733,{"$f":"37*2+14*2","v":102},230835,"город, за городом",35.950000000000003,20,44.75,11.2,11.2,368,null,null,null,null,{"$f":"48*11.66/100","v":5.5968000000000009},{"$f":"27*2*10.38/100","v":5.6052000000000008},{"$f":"R780+S780","v":11.202000000000002},null,null,{"$f":"11.2-5.59","v":5.6099999999999994}]
["2006-12-15",null,"Таратушкин И П",230835,null,230835,"город",44.75,40,84.75,0,0,41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"город 10,9+7%",null,"за городом -5%"]
["2006-12-18",null,"Таратушкин И П",230835,null,230835,"город",84.75,null,84.75,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.66,null,10.38]
["2006-12-19","1549179","Таратушкин И П",230835,{"$f":"18*2","v":36},230871,"город",84.75,null,80.78,3.97,3.97,null,null,null,null,null,{"$f":"18*11.66/100","v":2.0987999999999998},{"$f":"18*10.38/100","v":1.8684000000000001},{"$f":"R783+S783","v":3.9672000000000001},null,{"$f":"3.97-2.09","v":1.8800000000000003}]
["2006-12-20",null,"Таратушкин И П",230871,null,230871,"город",80.78,null,80.78,0,0]
["2006-12-21",null,"Таратушкин И П",230871,null,230871,"город",80.78,null,80.78,0,0]
["2006-12-22","1549181","Таратушкин И П",230871,{"$f":"42*2+8*2","v":100},230971,"город, за городом",80.78,null,69.86,10.92,10.92,null,null,null,null,null,{"$f":"42*11.66/100","v":4.8972000000000007},{"$f":"58*10.38/100","v":6.0204000000000004},{"$f":"R786+S786","v":10.9176},{"$f":"10.92-4.89","v":6.03}]
["2006-12-25","1549150","Таратушкин И П",230971,{"$f":"283*2","v":566},231537,"город, за городом",69.86,null,9.18,60.68,60.68,null,null,"Минск-Берестовица",null,null,{"$f":"151*11.66/100","v":17.6066},{"$f":"415*10.38/100","v":43.077000000000005},{"$f":"R787+S787","v":60.683600000000006},null,"ул Энгельса 1",null,{"$f":"0.36+0.03+0.005","v":0.39500000000000002}]
["2006-12-26","1549182","Таратушкин И П",231537,{"$f":"12*2","v":24},231561,"город",9.18,null,6.38,2.8,2.8]
["2006-12-27",null,"Таратушкин И П",231561,null,231561,"город",6.38,null,6.38,0,0,null,null,null,null,{"$f":"0.035+0.06","v":9.5000000000000001E-2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.602+1.718","v":2.3199999999999998}]
["2006-12-28",null,"Таратушкин И П",231561,null,231561,"город",6.38,null,6.38,0,0]
["2006-12-29",null,"Таратушкин И П",231561,null,231561,"город",6.38,null,6.38,0,0]
["2006-12-30",null,"Таратушкин И П",231561,null,231561,"город",6.38,null,6.38,0,0,null,null,"Минск-Берестовица",null,null,{"$f":"151*9.4/100","v":14.194000000000001},{"$f":"415*8.96/100","v":37.184000000000005},{"$f":"R792+S792","v":51.378000000000007},null,"ул Энгельса 1",null,null,"не хва топлива"]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E771:E791)","v":1068},null,null,null,{"$f":"SUM(I771:I791)","v":120},null,{"$f":"SUM(K771:K791)","v":115.24},{"$f":"K793","v":115.24},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.154+0.109+0.104","v":0.36699999999999999}]
[]
[]
[null,"Составил  ФИО  _________________"]
[null,null,null,null,null,"(подпись)"]
[null,"Проверил  _____________________________________"]
[null,null,null,null,"(подпись)"]

{"sheet":"ПЛ лицевая","index":1,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,0,1,4],[0,6,0,9],[0,13,0,14],[0,15,0,17],[1,6,1,10],[1,15,1,17],[3,15,3,17],[5,0,5,4],[5,13,5,14],[5,15,5,17],[6,0,6,4],[6,15,6,17],[8,9,8,10],[8,13,8,15],[10,0,12,0],[10,1,10,3],[10,4,10,5],[10,6,12,6],[10,7,10,13],[10,14,11,15],[11,5,12,5],[39,2,39,3],[38,0,38,3],[10,16,11,17],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,7,11,8],[11,9,11,10],[11,11,11,13]]}
[null,null,null,null,null,null,"ПУТЕВОЙ ЛИСТ №",null,null,null,1,null,null,"Автомобиль",null,"Автомобиль"]
["ООО \"Пример\"",null,null,null,null,null,"служебного легкового автомобиля",null,null,null,null,null,null,null,null,"(марка, регистрационный знак)"]
[]
["                     наименование организации",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10-01 АА-7"]
[]
["г. Минск",null,null,null,null,null,null,null,null,null,null,null,null,"Водитель",null,"Иванов И.И., \nПетров П.П."]
["адрес",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(фамилия, инициалы)"]
[]
[null,null,null,null,null,null,{"$f":"IF(A15=\"\",\"\",DAY(A15))","v":""},"по",{"$f":"IF(C40=\"\",\"\",DAY(C40))","v":""},{"$f":"CHOOSE(MONTH(A15), \"января\",\"февраля\",\"марта\",\"апреля\",\"мая\",\"июня\", \"июля\",\"августа\",\"сентября\",\"октября\",\"ноября\",\"декабря\")","v":"января"},null,2026,"г.","Водительское удостоверение"]
[]
["Дата (число, месяц)","Время (ч, мин)",null,null,"Показания\n спидометра",null,"Пробег,\nкм","Движение топлива",null,null,null,null,null,null,"Автомобиль техничекски исправен",null,"При возвращении\nавтомобиль"]
[null,"выезда","возвра-щения","в наряде","при\nвыезде","при возвра-ении",null,"остаток топлива, л",null,"заправлено топлива",null,"расход топлива, л"]
[null,null,null,null,null,null,null,"при выезде","при возвра-щении","марка топлива","количество,\nл","по\nнорме","фактически","экономия, перерасход","выезд разрешен ","принял ","сдал ","принял "]
["1","2","3","4","5","6","7","8","9",10,11,13,14,15,16,17,18,19]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого за период"]
[{"$f":"IF(COUNTA(A15:A38)=0,\"\",MIN(A15:A38))","v":""},"по",{"$f":"IF(COUNT(A15:A38)=0,\"\",MAX(A15:A38))","v":""},null,"Х","Х",{"$f":"SUM(G15:G38)","v":0},"Х","Х",null,{"$f":"SUM(K15:K38)","v":0},{"$f":"SUM(L15:L39)","v":0},{"$f":"SUM(M15:M39)","v":0},null,"Х","Х","Х","Х"]

{"sheet":"ПЛ обратная","index":2,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,0,29,2],[2,5,3,5],[0,0,0,5],[2,0,3,0],[2,1,2,2],[2,3,3,3],[2,4,3,4]]}
["Выполненные задания",null,null,null,null,null,null,1]
[]
["Дата\n(число,\nмесяц)","Маршрут следования",null,"Пробег,\nкм","Подпись лица пользовавшегося автомобилем","Прочие\nсведения"]
[null,"откуда","куда"]
["21","22","23","24","25","26"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого за месяц:",null,null,{"$f":"SUM(D6:D29)","v":0}]
["Для расчетов:"]

{"sheet":"1","index":3,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,13,0,14],[2,13,2,14],[0,0,0,3],[4,0,4,1],[4,13,4,14],[3,13,3,14],[6,0,6,16],[40,0,40,6],[40,9,40,15],[41,5,41,9],[7,0,7,5],[7,8,7,14],[8,9,8,10],[38,0,38,1],[10,0,10,1],[10,2,10,6]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-01-30"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",1]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"январь"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И., Петров П.П."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-01-05",{"$f":"$J$6","v":1},"Петров П.П.",100000,null,24,{"$f":"E15+F15","v":24},{"$f":"D15+G15","v":100024},"Минск",40,null,{"$f":"ROUND(J15+K15-O15,2)","v":36.33},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":3.67},{"$f":"M15+N15","v":3.67},{"$f":"O15","v":3.67},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-01-06",{"$f":"$J$6","v":1},"Иванов И.И.",{"$f":"H15","v":100024},null,32,{"$f":"E16+F16","v":32},100056,"Минск",{"$f":"L15","v":36.33},null,31.43,{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":4.9000000000000004},{"$f":"M16+N16","v":4.9000000000000004},{"$f":"O16","v":4.9000000000000004},{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-01-08",{"$f":"$J$6","v":1},"Петров П.П.",100056,null,28,28,100084,"Минск",{"$f":"L16","v":31.43},null,27.15,{"$f":"ROUND($P$5/100*E17,2)","v":0},{"$f":"ROUND(IF(I17=\"Минск\",$P$3/100*F17,$P$4/100*F17),2)","v":4.28},{"$f":"M17+N17","v":4.28},4.28,0,"Рабочий день"]
["2026-01-09",1,"Иванов И.И.",100084,null,36,36,100120,"Минск",27.15,null,21.64,0,5.51,5.51,{"$f":"O18","v":5.51},0,"Рабочий день"]
["2026-01-12",1,"Иванов И.И.",100120,null,39,39,100159,"Минск",21.64,40,55.67,0,5.97,{"$f":"M19+N19","v":5.97},{"$f":"O19","v":5.97},{"$f":"P19-O19","v":0},"Рабочий день"]
["2026-01-12",1,"Петров П.П.",100159,null,28,28,100187,"Минск",55.67,null,51.39,0,4.28,{"$f":"M20+N20","v":4.28},{"$f":"O20","v":4.28},{"$f":"P20-O20","v":0},"Рабочий день"]
["2026-01-13",1,"Иванов И.И.",100187,498,35,533,100720,"Минск - Могилёв-Минск",51.39,60,37.049999999999997,69.72,4.62,74.34,74.34,0,"Рабочий день"]
["2026-01-14",1,"Иванов И.И.",100720,null,41,41,100761,"Минск",37.049999999999997,null,30.78,0,6.27,6.27,6.27,0,"Рабочий день"]
["2026-01-15",1,"Иванов И.И.",100761,null,32,32,100793,"Минск",30.78,null,25.88,0,{"$f":"ROUND(IF(I23=\"Минск\",$P$3/100*F23,$P$4/100*F23),2)","v":4.9000000000000004},4.9000000000000004,4.9000000000000004,0,"Рабочий день"]
["2026-01-16",1,"Петров П.П.",100793,null,28,28,100821,"Минск",25.88,40,61.6,0,4.28,4.28,4.28,0,"Рабочий день"]
["2026-01-19",1,"Иванов И.И.",100821,null,17,17,100838,"Минск",61.6,null,59,0,2.6,2.6,2.6,0,"Рабочий день"]
["2026-01-20",1,"Иванов И.И.",100838,null,44,44,100882,"Минск",59,null,52.27,0,6.73,6.73,6.73,0,"Рабочий день"]
["2026-01-21",1,"Иванов И.И.",100882,299,34,333,101215,"Минск - Гродно",52.27,40,45.92,41.86,4.49,46.35,46.35,0,"Рабочий день"]
["2026-01-22",1,"Иванов И.И.",101215,null,56,56,101271,"Гродно",45.92,40,78.53,0,7.39,7.39,7.39,0,"Рабочий день"]
["2026-01-23",1,"Иванов И.И.",101271,299,44,343,101614,"Гродно-Минск",78.53,null,30.86,41.86,5.81,47.67,47.67,0,"Рабочий день"]
["2026-01-26",1,"Иванов И.И.",101614,null,28,28,101642,"Минск",30.86,50,76.58,0,4.28,4.28,4.28,0,"Рабочий день"]
["2026-01-27",1,"Иванов И.И.",101642,null,35,35,101677,"Минск",76.58,null,71.22,0,5.36,5.36,5.36,0,"Рабочий день"]
["2026-01-28",1,"Иванов И.И.",101677,null,21,21,101698,"Минск",71.22,null,68.010000000000005,0,3.21,3.21,3.21,0,"Рабочий день"]
["2026-01-29",1,"Иванов И.И.",101698,null,16,16,101714,"Минск",68.010000000000005,null,65.56,0,2.4500000000000002,2.4500000000000002,2.4500000000000002,0,"Рабочий день"]
["2026-01-30",1,"Иванов И.И.",101714,null,18,18,101732,"Минск",65.56,null,{"$f":"ROUND(J34+K34-O34,2)","v":62.81},0,2.75,{"$f":"M34+N34","v":2.75},{"$f":"O34","v":2.75},{"$f":"P34-O34","v":0},"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":1096},{"$f":"SUM(F15:F38)","v":636},{"$f":"SUM(G15:G38)","v":1732},null,null,null,{"$f":"SUM(K15:K38)","v":270},null,{"$f":"SUM(M15:M38)","v":153.44},{"$f":"SUM(N15:N38)","v":93.75},{"$f":"SUM(O15:O38)","v":247.19},{"$f":"SUM(P15:P38)","v":247.19},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":1732}]
["Составил  ",null,null,null,null,null,null,null,null,"Проверил"]

{"sheet":"2","index":4,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[41,5,41,9],[40,0,40,6],[40,9,40,15],[0,13,0,14],[3,13,3,14],[2,13,2,14],[38,0,38,1],[8,9,8,10],[10,0,10,1],[0,0,0,3],[4,0,4,1],[4,13,4,14],[7,0,7,5],[7,8,7,14],[10,2,10,6],[6,0,6,16]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-02-27"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",2]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"февраль"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-02-02",{"$f":"$J$6","v":2},"Иванов И.И.",{"$f":"'1'!H34","v":101732},null,null,null,{"$f":"D15+G15","v":101732},"Минск",{"$f":"'1'!L34","v":62.81},null,{"$f":"ROUND(J15+K15-O15,2)","v":62.81},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":0},{"$f":"M15+N15","v":0},{"$f":"O15","v":0},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-02-04",{"$f":"$J$6","v":2},"Иванов И.И.",{"$f":"H15","v":101732},null,null,null,101732,"Минск",{"$f":"L15","v":62.81},null,62.81,{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":0},{"$f":"M16+N16","v":0},0,{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-02-04",{"$f":"$J$6","v":2},"Иванов И.И.",{"$f":"H16","v":101732},null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-05",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-06",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-09",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-10",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-11",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-12",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-13",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-16",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-17",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-18",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-19",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-20",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-23",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-24",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-25",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-26",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-02-27",2,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":0},{"$f":"SUM(F15:F38)","v":0},{"$f":"SUM(G15:G38)","v":0},null,null,null,{"$f":"SUM(K15:K38)","v":0},null,{"$f":"SUM(M15:M38)","v":0},{"$f":"SUM(N15:N38)","v":0},{"$f":"SUM(O15:O38)","v":0},{"$f":"SUM(P15:P38)","v":0},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":0}]
["Составил  ",null,null,null,null,null,null,null,null,"Проверил"]

{"sheet":"3","index":5,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[10,2,10,6],[6,0,6,16],[41,5,41,9],[7,0,7,5],[7,8,7,14],[8,9,8,10],[10,0,10,1],[40,0,40,7],[40,10,40,16],[38,0,38,1],[0,13,0,14],[2,13,2,14],[3,13,3,14],[4,0,4,1],[4,13,4,14],[0,0,0,3]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-03-31"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",3]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"март"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-03-02",{"$f":"$J$6","v":3},"Иванов И.И.",{"$f":"'2'!H34","v":101732},null,null,null,{"$f":"D15+G15","v":101732},"Минск",{"$f":"'2'!L34","v":62.81},null,{"$f":"ROUND(J15+K15-O15,2)","v":62.81},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":0},{"$f":"M15+N15","v":0},{"$f":"O15","v":0},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-03-03",{"$f":"$J$6","v":3},"Иванов И.И.",{"$f":"H15","v":101732},null,null,null,101732,"Минск",{"$f":"L15","v":62.81},null,{"$f":"J16+K16-O16","v":62.81},{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":0},{"$f":"M16+N16","v":0},{"$f":"O16","v":0},{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-03-04",{"$f":"$J$6","v":3},"Иванов И.И.",101732,null,null,null,101732,"Минск",{"$f":"L16","v":62.81},null,{"$f":"J17+K17-O17","v":62.81},0,0,{"$f":"M17+N17","v":0},0,{"$f":"P17-O17","v":0},"Рабочий день"]
["2026-03-05",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-06",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-09",3,"Иванов И.И.",101732,null,null,null,101732,"Минск - Брест",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-10",3,"Иванов И.И.",101732,null,null,null,101732,"Брест",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-11",3,"Иванов И.И.",101732,null,null,null,101732,"Брест-Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-12",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-13",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-16",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-17",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-18",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-19",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-20",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-23",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-24",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-25",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-26",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-27",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-30",3,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-03-31",3,"Иванов И.И.",101732,null,null,null,{"$f":"D36+G36","v":101732},"Минск",62.81,null,62.81,{"$f":"ROUND($P$5/100*E36,2)","v":0},{"$f":"ROUND(IF(I36=\"Минск\",$P$3/100*F36,$P$4/100*F36),2)","v":0},{"$f":"M36+N36","v":0},{"$f":"O36","v":0},{"$f":"P36-O36","v":0},"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":0},{"$f":"SUM(F15:F38)","v":0},{"$f":"SUM(G15:G38)","v":0},null,null,null,{"$f":"SUM(K15:K38)","v":0},null,{"$f":"SUM(M15:M38)","v":0},{"$f":"SUM(N15:N38)","v":0},{"$f":"SUM(O15:O38)","v":0},{"$f":"SUM(P15:P38)","v":0},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":0}]
["Составил  ",null,null,null,null,null,null,null,null,null,"Проверил"]

{"sheet":"4","index":6,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[41,5,41,9],[7,0,7,5],[7,8,7,14],[40,0,40,7],[8,9,8,10],[10,0,10,1],[40,9,40,15],[38,0,38,1],[10,2,10,6],[6,0,6,16],[0,13,0,14],[2,13,2,14],[3,13,3,14],[4,0,4,1],[4,13,4,14],[0,0,0,3]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-04-30"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",4]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"апрель"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-04-01",{"$f":"$J$6","v":4},"Иванов И.И.",{"$f":"'3'!H36","v":101732},null,null,null,{"$f":"D15+G15","v":101732},"Минск",{"$f":"'3'!L36","v":62.81},null,{"$f":"ROUND(J15+K15-O15,2)","v":62.81},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":0},{"$f":"M15+N15","v":0},{"$f":"O15","v":0},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-04-02",{"$f":"$J$6","v":4},"Иванов И.И.",{"$f":"H15","v":101732},null,null,null,101732,"Минск",{"$f":"L15","v":62.81},null,{"$f":"J16+K16-O16","v":62.81},{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":0},{"$f":"M16+N16","v":0},0,{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-04-03",{"$f":"$J$6","v":4},"Иванов И.И.",101732,null,null,null,101732,"Минск",{"$f":"L16","v":62.81},null,{"$f":"J17+K17-O17","v":62.81},0,0,{"$f":"M17+N17","v":0},0,{"$f":"P17-O17","v":0},"Рабочий день"]
["2026-04-06",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-07",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-08",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-09",4,"Иванов И.И.",101732,null,null,null,101732,"Минск - Могилёв-Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-10",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-13",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-14",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-15",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-16",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-17",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-20",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-22",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-23",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-24",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-27",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,{"$f":"ROUND($P$5/100*E32,2)","v":0},{"$f":"ROUND(IF(I32=\"Минск\",$P$3/100*F32,$P$4/100*F32),2)","v":0},{"$f":"M32+N32","v":0},{"$f":"O32","v":0},{"$f":"P32-O32","v":0},"Рабочий день"]
["2026-04-28",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-29",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-04-30",4,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":0},{"$f":"SUM(F15:F38)","v":0},{"$f":"SUM(G15:G38)","v":0},null,null,null,{"$f":"SUM(K15:K38)","v":0},null,{"$f":"SUM(M15:M38)","v":0},{"$f":"SUM(N15:N38)","v":0},{"$f":"SUM(O15:O38)","v":0},{"$f":"SUM(P15:P38)","v":0},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":0}]
["Составил  ",null,null,null,null,null,null,null,null,"Проверил"]

{"sheet":"5","index":7,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,0,38,1],[40,0,40,7],[40,9,40,15],[41,5,41,9],[7,0,7,5],[7,8,7,14],[10,0,10,1],[8,9,8,10],[10,2,10,6],[6,0,6,16],[0,13,0,14],[2,13,2,14],[3,13,3,14],[4,0,4,1],[4,13,4,14],[0,0,0,3]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-05-29"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",5]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"май"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-05-04",{"$f":"$J$6","v":5},"Иванов И.И.",{"$f":"'4'!H35","v":101732},null,null,null,{"$f":"D15+G15","v":101732},"Минск",{"$f":"'4'!L35","v":62.81},null,{"$f":"ROUND(J15+K15-O15,2)","v":62.81},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":0},{"$f":"M15+N15","v":0},{"$f":"O15","v":0},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-05-05",{"$f":"$J$6","v":5},"Иванов И.И.",{"$f":"H15","v":101732},null,null,null,101732,"Минск",{"$f":"L15","v":62.81},null,{"$f":"ROUND(J16+K16-O16,2)","v":62.81},{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":0},{"$f":"M16+N16","v":0},0,{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-05-06",{"$f":"$J$6","v":5},"Иванов И.И.",101732,null,null,null,101732,"Минск",{"$f":"L16","v":62.81},null,62.81,0,0,{"$f":"M17+N17","v":0},0,{"$f":"P17-O17","v":0},"Рабочий день"]
["2026-05-07",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-08",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-11",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-12",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-13",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-14",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-15",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-18",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-19",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-20",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-21",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-22",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-25",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-26",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-27",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-28",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-05-29",5,"Иванов И.И.",101732,null,null,null,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":0},{"$f":"SUM(F15:F38)","v":0},{"$f":"SUM(G15:G38)","v":0},null,null,null,{"$f":"SUM(K15:K38)","v":0},null,{"$f":"SUM(M15:M38)","v":0},{"$f":"SUM(N15:N38)","v":0},{"$f":"SUM(O15:O38)","v":0},{"$f":"SUM(P15:P38)","v":0},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":0}]
["Составил  ",null,null,null,null,null,null,null,null,"Проверил"]

{"sheet":"6","index":8,"n_rows":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":false,"merged":[[38,0,38,1],[40,0,40,7],[40,9,40,15],[41,5,41,9],[7,0,7,5],[7,8,7,14],[8,9,8,10],[10,0,10,1],[10,2,10,6],[6,0,6,16],[0,0,0,3],[0,13,0,14],[2,13,2,14],[3,13,3,14],[4,0,4,1],[4,13,4,14]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-06-30"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",6]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"июнь"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-06-01",{"$f":"$J$6","v":6},"Иванов И.И.",{"$f":"'5'!H34","v":101732},null,null,{"$f":"E15+F15","v":0},{"$f":"D15+G15","v":101732},"Минск",{"$f":"'5'!L34","v":62.81},null,{"$f":"ROUND(J15+K15-O15,2)","v":62.81},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":0},{"$f":"M15+N15","v":0},{"$f":"O15","v":0},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-06-02",{"$f":"$J$6","v":6},"Иванов И.И.",{"$f":"H15","v":101732},null,null,{"$f":"E16+F16","v":0},101732,"Минск",{"$f":"L15","v":62.81},null,{"$f":"ROUND(J16+K16-O16,2)","v":62.81},{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":0},{"$f":"M16+N16","v":0},0,{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-06-03",{"$f":"$J$6","v":6},"Иванов И.И.",101732,null,null,0,101732,"Минск",{"$f":"L16","v":62.81},null,62.81,0,0,{"$f":"M17+N17","v":0},0,{"$f":"P17-O17","v":0},"Рабочий день"]
["2026-06-04",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-05",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-08",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-09",6,"Иванов И.И.",101732,null,null,{"$f":"E21+F21","v":0},101732,"Минск",62.81,null,{"$f":"ROUND(J21+K21-O21,2)","v":62.81},{"$f":"ROUND($P$5/100*E21,2)","v":0},{"$f":"ROUND(IF(I21=\"Минск\",$P$3/100*F21,$P$4/100*F21),2)","v":0},{"$f":"M21+N21","v":0},{"$f":"O21","v":0},{"$f":"P21-O21","v":0},"Рабочий день"]
["2026-06-10",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-11",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-12",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-15",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-16",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-17",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-18",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-19",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-22",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-23",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-24",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-25",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-26",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-29",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-06-30",6,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":0},{"$f":"SUM(F15:F38)","v":0},{"$f":"SUM(G15:G38)","v":0},null,null,null,{"$f":"SUM(K15:K38)","v":0},null,{"$f":"SUM(M15:M38)","v":0},{"$f":"SUM(N15:N38)","v":0},{"$f":"SUM(O15:O38)","v":0},{"$f":"SUM(P15:P38)","v":0},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":0}]
["Составил  ",null,null,null,null,null,null,null,null,"Проверил"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"J15+K39-O39","v":62.81}]

{"sheet":"7","index":9,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,0,38,1],[40,0,40,7],[40,9,40,15],[41,5,41,9],[7,0,7,5],[7,8,7,14],[8,9,8,10],[10,0,10,1],[10,2,10,6],[6,0,6,16],[0,0,0,3],[0,13,0,14],[2,13,2,14],[3,13,3,14],[4,0,4,1],[4,13,4,14]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-07-31"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",7]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"июль"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-07-01",{"$f":"$J$6","v":7},"Иванов И.И.",{"$f":"'6'!H36","v":101732},null,null,{"$f":"E15+F15","v":0},{"$f":"D15+G15","v":101732},"Минск",{"$f":"'6'!L36","v":62.81},null,{"$f":"ROUND(J15+K15-O15,2)","v":62.81},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":0},{"$f":"M15+N15","v":0},{"$f":"O15","v":0},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-07-02",{"$f":"$J$6","v":7},"Иванов И.И.",{"$f":"H15","v":101732},null,null,{"$f":"E16+F16","v":0},101732,"Минск",{"$f":"L15","v":62.81},null,{"$f":"ROUND(J16+K16-O16,2)","v":62.81},{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":0},{"$f":"M16+N16","v":0},0,{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-07-03",{"$f":"$J$6","v":7},"Иванов И.И.",101732,null,null,0,101732,"Минск",{"$f":"L16","v":62.81},null,62.81,0,0,{"$f":"M17+N17","v":0},0,{"$f":"P17-O17","v":0},"Рабочий день"]
["2026-07-06",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-07",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-08",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-09",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-10",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-13",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-14",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-15",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-16",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-17",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-20",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-21",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-22",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-23",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-24",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-27",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-28",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-29",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-30",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-07-31",7,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":0},{"$f":"SUM(F15:F38)","v":0},{"$f":"SUM(G15:G38)","v":0},null,null,null,{"$f":"SUM(K15:K38)","v":0},null,{"$f":"SUM(M15:M38)","v":0},{"$f":"SUM(N15:N38)","v":0},{"$f":"SUM(O15:O38)","v":0},{"$f":"SUM(P15:P38)","v":0},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":0}]
["Составил  ",null,null,null,null,null,null,null,null,"Проверил"]

{"sheet":"8","index":10,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,0,38,1],[40,0,40,7],[40,9,40,15],[41,5,41,9],[7,0,7,5],[7,8,7,14],[8,9,8,10],[10,0,10,1],[10,2,10,6],[6,0,6,16],[0,0,0,3],[0,13,0,14],[2,13,2,14],[3,13,3,14],[4,0,4,1],[4,13,4,14]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-08-31"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",8]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"август"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-08-03",{"$f":"$J$6","v":8},"Иванов И.И.",{"$f":"'7'!H37","v":101732},null,null,{"$f":"E15+F15","v":0},{"$f":"D15+G15","v":101732},"Минск",{"$f":"'7'!L37","v":62.81},null,{"$f":"ROUND(J15+K15-O15,2)","v":62.81},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":0},{"$f":"M15+N15","v":0},{"$f":"O15","v":0},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-08-04",{"$f":"$J$6","v":8},"Иванов И.И.",{"$f":"H15","v":101732},null,null,{"$f":"E16+F16","v":0},101732,"Минск",{"$f":"L15","v":62.81},null,{"$f":"ROUND(J16+K16-O16,2)","v":62.81},{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":0},{"$f":"M16+N16","v":0},0,{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-08-05",{"$f":"$J$6","v":8},"Иванов И.И.",101732,null,null,0,101732,"Минск",{"$f":"L16","v":62.81},null,62.81,0,0,{"$f":"M17+N17","v":0},0,{"$f":"P17-O17","v":0},"Рабочий день"]
["2026-08-06",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-07",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-10",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-11",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-12",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-13",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-14",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-17",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-18",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-19",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-20",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-21",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-24",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-25",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-26",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-27",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-28",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-08-31",8,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":0},{"$f":"SUM(F15:F38)","v":0},{"$f":"SUM(G15:G38)","v":0},null,null,null,{"$f":"SUM(K15:K38)","v":0},null,{"$f":"SUM(M15:M38)","v":0},{"$f":"SUM(N15:N38)","v":0},{"$f":"SUM(O15:O38)","v":0},{"$f":"SUM(P15:P38)","v":0},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":0}]
["Составил  ",null,null,null,null,null,null,null,null,"Проверил"]

{"sheet":"9","index":11,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,0,38,1],[40,0,40,7],[40,9,40,15],[41,5,41,9],[7,0,7,5],[7,8,7,14],[8,9,8,10],[10,0,10,1],[10,2,10,6],[6,0,6,16],[0,0,0,3],[0,13,0,14],[2,13,2,14],[3,13,3,14],[4,0,4,1],[4,13,4,14]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-09-30"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",9]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"сентябрь"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-09-01",{"$f":"$J$6","v":9},"Иванов И.И.",{"$f":"'8'!H35","v":101732},null,null,{"$f":"E15+F15","v":0},{"$f":"D15+G15","v":101732},"Минск",{"$f":"'8'!L35","v":62.81},null,{"$f":"ROUND(J15+K15-O15,2)","v":62.81},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":0},{"$f":"M15+N15","v":0},{"$f":"O15","v":0},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-09-02",{"$f":"$J$6","v":9},"Иванов И.И.",{"$f":"H15","v":101732},null,null,{"$f":"E16+F16","v":0},101732,"Минск",{"$f":"L15","v":62.81},null,{"$f":"ROUND(J16+K16-O16,2)","v":62.81},{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":0},{"$f":"M16+N16","v":0},0,{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-09-03",{"$f":"$J$6","v":9},"Иванов И.И.",101732,null,null,0,101732,"Минск",{"$f":"L16","v":62.81},null,62.81,0,0,{"$f":"M17+N17","v":0},0,{"$f":"P17-O17","v":0},"Рабочий день"]
["2026-09-04",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-07",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-08",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-09",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-10",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-11",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-14",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-15",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-16",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-17",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-18",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-21",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-22",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-23",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-24",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-25",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-28",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-29",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-09-30",9,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":0},{"$f":"SUM(F15:F38)","v":0},{"$f":"SUM(G15:G38)","v":0},null,null,null,{"$f":"SUM(K15:K38)","v":0},null,{"$f":"SUM(M15:M38)","v":0},{"$f":"SUM(N15:N38)","v":0},{"$f":"SUM(O15:O38)","v":0},{"$f":"SUM(P15:P38)","v":0},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":0}]
["Составил  ",null,null,null,null,null,null,null,null,"Проверил"]

{"sheet":"10","index":12,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[41,5,41,9],[6,0,6,16],[38,0,38,1],[40,9,40,15],[10,0,10,1],[7,0,7,5],[7,8,7,14],[8,9,8,10],[10,2,10,6],[40,0,40,7],[4,0,4,1],[0,0,0,3],[0,13,0,14],[2,13,2,14],[3,13,3,14],[4,13,4,14]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-10-30"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",10]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"октябрь"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-10-01",{"$f":"$J$6","v":10},"Иванов И.И.",{"$f":"'9'!H36","v":101732},null,null,{"$f":"E15+F15","v":0},{"$f":"D15+G15","v":101732},"Минск",{"$f":"'9'!L36","v":62.81},null,{"$f":"ROUND(J15+K15-O15,2)","v":62.81},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":0},{"$f":"M15+N15","v":0},{"$f":"O15","v":0},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-10-02",{"$f":"$J$6","v":10},"Иванов И.И.",{"$f":"H15","v":101732},null,null,{"$f":"E16+F16","v":0},101732,"Минск",{"$f":"L15","v":62.81},null,{"$f":"ROUND(J16+K16-O16,2)","v":62.81},{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":0},{"$f":"M16+N16","v":0},0,{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-10-05",{"$f":"$J$6","v":10},"Иванов И.И.",101732,null,null,0,101732,"Минск",{"$f":"L16","v":62.81},null,62.81,0,0,{"$f":"M17+N17","v":0},0,{"$f":"P17-O17","v":0},"Рабочий день"]
["2026-10-06",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-07",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-08",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-09",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-12",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-13",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-14",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-15",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-16",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-19",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-20",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-21",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-22",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-23",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-26",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-27",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-28",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-29",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-10-30",10,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":0},{"$f":"SUM(F15:F38)","v":0},{"$f":"SUM(G15:G38)","v":0},null,null,null,{"$f":"SUM(K15:K38)","v":0},null,{"$f":"SUM(M15:M38)","v":0},{"$f":"SUM(N15:N38)","v":0},{"$f":"SUM(O15:O38)","v":0},{"$f":"SUM(P15:P38)","v":0},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":0}]
["Составил  ",null,null,null,null,null,null,null,null,"Проверил"]

{"sheet":"11","index":13,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[41,5,41,9],[6,0,6,16],[38,0,38,1],[40,9,40,15],[10,0,10,1],[7,0,7,5],[7,8,7,14],[8,9,8,10],[10,2,10,6],[40,0,40,7],[4,0,4,1],[0,0,0,3],[0,13,0,14],[2,13,2,14],[3,13,3,14],[4,13,4,14]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-11-30"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",11]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"ноябрь"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-11-02",{"$f":"$J$6","v":11},"Иванов И.И.",{"$f":"'10'!H36","v":101732},null,null,{"$f":"E15+F15","v":0},{"$f":"D15+G15","v":101732},"Минск",{"$f":"'10'!L36","v":62.81},null,{"$f":"ROUND(J15+K15-O15,2)","v":62.81},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":0},{"$f":"M15+N15","v":0},{"$f":"O15","v":0},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-11-03",{"$f":"$J$6","v":11},"Иванов И.И.",{"$f":"H15","v":101732},null,null,{"$f":"E16+F16","v":0},{"$f":"D16+G16","v":101732},"Минск",{"$f":"L15","v":62.81},null,{"$f":"ROUND(J16+K16-O16,2)","v":62.81},{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":0},0,0,{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-11-04",{"$f":"$J$6","v":11},"Иванов И.И.",{"$f":"H15","v":101732},null,null,0,{"$f":"D17+G17","v":101732},"Минск",{"$f":"L16","v":62.81},null,{"$f":"ROUND(J17+K17-O17,2)","v":62.81},0,0,{"$f":"M17+N17","v":0},0,{"$f":"P17-O17","v":0},"Рабочий день"]
["2026-11-05",11,"Иванов И.И.",{"$f":"H17","v":101732},null,null,0,101732,"Минск",62.81,null,62.81,0,0,{"$f":"M18+N18","v":0},0,{"$f":"P18-O18","v":0},"Рабочий день"]
["2026-11-06",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-09",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-10",11,"Иванов И.И.",101732,null,null,0,101732,"Минск - Витебск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-11",11,"Иванов И.И.",101732,null,null,0,101732,"Витебск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-12",11,"Иванов И.И.",101732,null,null,0,101732,"Витебск-Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-13",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-16",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-17",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-18",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-19",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-20",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-23",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-24",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-25",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-26",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-27",11,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-11-30",11,"Иванов И.И.",{"$f":"H34","v":101732},null,null,{"$f":"E35+F35","v":0},{"$f":"D35+G35","v":101732},"Минск",{"$f":"L34","v":62.81},null,{"$f":"ROUND(J35+K35-O35,2)","v":62.81},{"$f":"ROUND($P$5/100*E35,2)","v":0},{"$f":"ROUND(IF(I35=\"Минск\",$P$3/100*F35,$P$4/100*F35),2)","v":0},{"$f":"M35+N35","v":0},{"$f":"O35","v":0},{"$f":"P35-O35","v":0},"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":0},{"$f":"SUM(F15:F38)","v":0},{"$f":"SUM(G15:G38)","v":0},null,null,null,{"$f":"SUM(K15:K38)","v":0},null,{"$f":"SUM(M15:M38)","v":0},{"$f":"SUM(N15:N38)","v":0},{"$f":"SUM(O15:O38)","v":0},{"$f":"SUM(P15:P38)","v":0},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":0}]
["Составил  ",null,null,null,null,null,null,null,null,"Проверил"]

{"sheet":"12","index":14,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[41,5,41,9],[6,0,6,16],[38,0,38,1],[40,9,40,15],[10,0,10,1],[7,0,7,5],[7,8,7,14],[8,9,8,10],[10,2,10,6],[40,0,40,7],[4,0,4,1],[0,0,0,3],[0,13,0,14],[2,13,2,14],[3,13,3,14],[4,13,4,14]]}
["ООО \"Пример\"",null,null,null,null,null,null,null,null,null,null,null,null,"линейная норма",null,"13,2 л",null,null,"бак",72,"литра"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Минск",null,15.3,"л"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"город",null,13.2,"л"]
[{"$f":"WORKDAY(DATE(2026, J6 + 1, 1), -1)","v":"2026-12-31"},null,null,null,null,null,null,null,null,null,null,null,null,"за городом",null,14,"л"]
[null,null,null,null,null,null,null,null,"Карточка №",12]
["учета расхода бинзина АИ-92 автомобилем"]
["Марка автомобиля Автомобиль",null,null,null,null,null,null,null,"Регистрационный номер 10-01 АА-7"]
[null,null,null,null,null,null,null,"за",{"$f":"CHOOSE(J6, \"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\")","v":"декабрь"},"2026 года"]
[]
["Водитель: ",null,"Иванов И.И."]
[]
["Число месяца","Номер путевого листа","Ф.И.О. водителя","Показание спидометра перед поездкой","Пробег , км  за городом","Пробег , км город","Пробег , км Общий","Показание спидометра после поездки","Служебное задание (маршрут следования)","Остаток топлива при выезде, л.","Приобретено топлива на АЗС, л.","Остаток топлива при возврате, л","Расход топлива по норме, л. Трасса","Расход топлива по норме, л.","Расход топлива по норме, л. Общий","Расход топлива фактически, л.","Результат работы (экономия/перерасход)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["2026-12-01",{"$f":"$J$6","v":12},"Иванов И.И.",{"$f":"'11'!H35","v":101732},null,null,{"$f":"E15+F15","v":0},{"$f":"D15+G15","v":101732},"Минск",{"$f":"'11'!J15","v":62.81},null,{"$f":"ROUND(J15+K15-O15,2)","v":62.81},{"$f":"ROUND($P$5/100*E15,2)","v":0},{"$f":"ROUND(IF(I15=\"Минск\",$P$3/100*F15,$P$4/100*F15),2)","v":0},{"$f":"M15+N15","v":0},{"$f":"O15","v":0},{"$f":"P15-O15","v":0},{"$f":"IF(WORKDAY(A15-1, 1)=A15, \"Рабочий день\", \"Выходной\")","v":"Рабочий день"}]
["2026-12-02",{"$f":"$J$6","v":12},"Иванов И.И.",{"$f":"H15","v":101732},null,null,{"$f":"E16+F16","v":0},101732,"Минск",{"$f":"L15","v":62.81},null,{"$f":"ROUND(J16+K16-O16,2)","v":62.81},{"$f":"ROUND($P$5/100*E16,2)","v":0},{"$f":"ROUND(IF(I16=\"Минск\",$P$3/100*F16,$P$4/100*F16),2)","v":0},{"$f":"M16+N16","v":0},0,{"$f":"P16-O16","v":0},"Рабочий день"]
["2026-12-03",{"$f":"$J$6","v":12},"Иванов И.И.",101732,null,null,0,101732,"Минск",{"$f":"L16","v":62.81},null,62.81,0,0,{"$f":"M17+N17","v":0},0,{"$f":"P17-O17","v":0},"Рабочий день"]
["2026-12-04",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-07",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-08",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-09",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-10",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-11",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-14",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-15",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-16",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-17",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-18",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-21",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-22",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-23",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-24",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-28",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-29",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-30",12,"Иванов И.И.",101732,null,null,0,101732,"Минск - Гомель-Минск",62.81,null,62.81,0,0,0,0,0,"Рабочий день"]
["2026-12-31",12,"Иванов И.И.",101732,null,null,0,101732,"Минск",62.81,null,62.81,{"$f":"ROUND($P$5/100*E36,2)","v":0},{"$f":"ROUND(IF(I36=\"Минск\",$P$3/100*F36,$P$4/100*F36),2)","v":0},{"$f":"M36+N36","v":0},{"$f":"O36","v":0},{"$f":"P36-O36","v":0},"Рабочий день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"}]
["ИТОГО за месяц",null,null,null,{"$f":"SUM(E15:E38)","v":0},{"$f":"SUM(F15:F38)","v":0},{"$f":"SUM(G15:G38)","v":0},null,null,null,{"$f":"SUM(K15:K38)","v":0},null,{"$f":"SUM(M15:M38)","v":0},{"$f":"SUM(N15:N38)","v":0},{"$f":"SUM(O15:O38)","v":0},{"$f":"SUM(P15:P38)","v":0},{"$f":"SUM(Q15:Q38)","v":0}]
[null,null,null,null,null,null,{"$f":"E39+F39","v":0}]
["Составил  ",null,null,null,null,null,null,null,null,"Проверил"]

{"sheet":"Лист1","index":15,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["Столбец1","Столбец2","Столбец3","Столбец4","Столбец5","Столбец6","Столбец7","Столбец8","Столбец9","Столбец10","Столбец11","Столбец12"]

{"sheet":"Лист2","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}