{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","База данных"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Исходные данные"]
["Коэффициент порожнего пробега",0.56999999999999995]
["Кол-во осей подвижного состава",4]
["Коэффициент",1.242]
["Тарифное расстояние,км","Результат"]
[110,{"$f":"ROUND(VLOOKUP(A6*B2,'База данных'!D4:F55,3,1)*B3*B4,1)","v":241.9}]
[]
[null,"формула ВПР"]

{"sheet":"База данных","index":1,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,3,1,4]]}
[]
[null,null,null,"Расстояние,км"]
[null,null,null,"от ","до","Тариф"]
[null,null,null,0,10,7.5]
[null,null,null,11,20,11.2]
[null,null,null,21,30,18.7]
[null,null,null,31,40,26.2]
[null,null,null,41,50,33.700000000000003]
[null,null,null,51,60,41.2]
[null,null,null,61,70,48.7]
[null,null,null,71,80,56.2]
[null,null,null,81,90,63.7]
[null,null,null,91,100,71.2]
[null,null,null,101,120,82.4]
[null,null,null,121,140,97.4]
[null,null,null,141,160,112.4]
[null,null,null,161,180,125.9]
[null,null,null,181,200,139.30000000000001]
[null,null,null,201,220,152.5]
[null,null,null,221,240,165.6]
[null,null,null,241,260,178.4]
[null,null,null,261,280,191.1]
[null,null,null,281,300,203.6]
[null,null,null,301,330,219.1]
[null,null,null,331,360,237.4]
[null,null,null,361,390,255.5]
[null,null,null,391,420,273.3]
[null,null,null,421,450,291]
[null,null,null,451,480,308.5]
[null,null,null,481,510,325.89999999999998]
[null,null,null,511,540,343.1]
[null,null,null,541,570,360.3]
[null,null,null,571,600,377.4]
[null,null,null,601,650,400.1]
[null,null,null,651,700,428.4]
[null,null,null,701,750,456.5]
[null,null,null,751,800,484.7]
[null,null,null,801,850,512.79999999999995]
[null,null,null,851,900,540.9]
[null,null,null,901,950,569]
[null,null,null,951,1000,597.20000000000005]
[null,null,null,1001,1070,631.1]
[null,null,null,1071,1140,670.8]
[null,null,null,1141,1210,710.6]
[null,null,null,1211,1280,750.6]
[null,null,null,1281,1350,790.6]
[null,null,null,1351,1420,830.8]
[null,null,null,1421,1490,871.2]
[null,null,null,1491,1590,920.3]
[null,null,null,1591,1690,978.3]
[null,null,null,1691,1790,1036.5]
[null,null,null,1791,1890,1094.9000000000001]
[null,null,null,1891,1990,1153.4000000000001]
[null,null,null,1991,2090,1212.0999999999999]
[null,null,null,2091,2190,1270.8]