{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["База","Лист1","Тарифне керівництво"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"База","index":0,"n_rows":55,"n_cols":17,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,8,1,8],[0,6,1,7]]}
["Дата расчета","2018-12-09",null,null,null,null,"Расстояние,км",null,"Тариф",null,null,"Ставки, коэффициенты","Данные"]
["Тарифное расстояние,км"]
[346,"Сумма без НДС","НДС","Сумма",null,null,"от ","до",null,null,null,null,200]
[null,null,null,null,null,null,0,10,7.5]
["Компенсация затрат на перевозку",{"$f":"VLOOKUP(ROUND(A3*VLOOKUP(B1,O10:Q11,3)-0.1,0),G4:I55,3)*4*M11","v":663.68000000000006},{"$f":"B5*20/100","v":132.73600000000002},{"$f":"B5+C5","v":796.41600000000005},null,null,11,20,11.2]
["вариант№2",{"$f":"VLOOKUP(ROUND(A3*VLOOKUP(B1,O10:Q11,3),0),G4:I55,3)*4*M11","v":663.68000000000006},null,null,null,null,21,30,18.7]
["Должно быть:","Сумма без НДС","НДС","Сумма",null,null,31,40,26.2]
["Компенсация затрат на перевозку",663.7,132.74,796.44,null,null,41,50,33.700000000000003]
[null,null,null,null,null,null,51,60,41.2,null,null,null,null,null,"дата новых коэффициентов с :","ставка","коэффициент"]
[null,null,null,null,null,null,61,70,48.7]
[null,null,null,null,null,null,71,80,56.2,null,null,"коэффициент на груз",1.0880000000000001,null,"2018-11-13",819,0.57999999999999996]
[null,null,null,null,null,null,81,90,63.7]
[null,null,null,null,null,null,91,100,71.2]
[null,null,null,null,null,null,101,120,82.4]
[null,null,null,null,null,null,121,140,97.4]
[null,null,null,null,null,null,141,160,112.4]
[null,null,null,null,null,null,161,180,125.9]
[null,null,null,null,null,null,181,200,139.30000000000001]
[null,null,null,null,null,null,201,220,152.5]
[null,null,null,null,null,null,221,240,165.6]
[null,null,null,null,null,null,241,260,178.4]
[null,null,null,null,null,null,261,280,191.1]
[null,null,null,null,null,null,281,300,203.6]
[null,null,null,null,null,null,301,330,219.1]
[null,null,null,null,null,null,331,360,237.4]
[null,null,null,null,null,null,361,390,255.5]
[null,null,null,null,null,null,391,420,273.3]
[null,null,null,null,null,null,421,450,291]
[null,null,null,null,null,null,451,480,308.5]
[null,null,null,null,null,null,481,510,325.89999999999998]
[null,null,null,null,null,null,511,540,343.1]
[null,null,null,null,null,null,541,570,360.3]
[null,null,null,null,null,null,571,600,377.4]
[null,null,null,null,null,null,601,650,400.1]
[null,null,null,null,null,null,651,700,428.4]
[null,null,null,null,null,null,701,750,456.5]
[null,null,null,null,null,null,751,800,484.7]
[null,null,null,null,null,null,801,850,512.79999999999995]
[null,null,null,null,null,null,851,900,540.9]
[null,null,null,null,null,null,901,950,569]
[null,null,null,null,null,null,951,1000,597.20000000000005]
[null,null,null,null,null,null,1001,1070,631.1]
[null,null,null,null,null,null,1071,1140,670.8]
[null,null,null,null,null,null,1141,1210,710.6]
[null,null,null,null,null,null,1211,1280,750.6]
[null,null,null,null,null,null,1281,1350,790.6]
[null,null,null,null,null,null,1351,1420,830.8]
[null,null,null,null,null,null,1421,1490,871.2]
[null,null,null,null,null,null,1491,1590,920.3]
[null,null,null,null,null,null,1591,1690,978.3]
[null,null,null,null,null,null,1691,1790,1036.5]
[null,null,null,null,null,null,1791,1890,1094.9000000000001]
[null,null,null,null,null,null,1891,1990,1153.4000000000001]
[null,null,null,null,null,null,1991,2090,1212.0999999999999]
[null,null,null,null,null,null,2091,2190,1270.8]

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

{"sheet":"Тарифне керівництво","index":2,"n_rows":61,"n_cols":18,"rows_kept":61,"cut":false,"hidden":true,"merged":[[5,15,5,16],[6,15,6,16],[4,11,4,13],[5,11,5,13],[6,11,6,13],[7,11,7,13],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[4,2,4,10],[5,2,5,10],[6,2,6,4],[6,5,6,7],[6,8,6,10],[7,2,7,10]]}
[]
[]
["Схема 1 (гривень за вагон) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Схема 14 (гривень за вісь) "]
["Відстань,",null,"Універсальний вагон ",null,null,null,null,null,null,null,null,"Універсальний вагон "]
["км ",null,"розрахункова маса, тонн ",null,null,null,null,null,null,null,null,"розрахункова маса, тонн ",null,null,null,"Відстань,",null,"Схема 14.1 "]
[null,null,"55 ",null,null,"60 ",null,null,"65 ",null,null,"70 ",null,null,null,"км ",null,"власні або орендовані "]
[null,null,"складові плати (тарифу) ",null,null,null,null,null,null,null,null,"складові плати (тарифу) ",null,null,null,"від ","до ","вантажні (пасажирські) вагони з навантаженням до 12,5 т/вісь "]
["від ","до ","І - для вагона перевізника ","І - для власного або орендованого вагона ","В - для вагона перевізника ","І - для вагона перевізника ","І - для власного або орендованого вагона ","В - для вагона перевізника ","І - для вагона перевізника ","І - для власного або орендованого вагона ","В - для вагона перевізника ","І - для вагона перевізника ","І - для власного або орендованого вагона ","В - для вагона перевізника ",null,"0 ","10 ","7,5 "]
["0 ","10 ","735 ","707 ","180 ","737 ","708 ","180 ","739 ","710 ","180 ","742 ","712 ","180 ",null,"11 ","20 ","11,2 "]
["11 ","20 ","797 ","764 ","190 ","801 ","766 ","190 ","805 ","769 ","190 ","808 ","772 ","190 ",null,"21 ","30 ","18,7 "]
["21 ","30 ","923 ","877 ","212 ","929 ","882 ","212 ","935 ","886 ","212 ","941 ","891 ","212 ",null,"31 ","40 ","26,2 "]
["31 ","40 ","1049 ","991 ","234 ","1057 ","998 ","234 ","1065 ","1004 ","234 ","1074 ","1010 ","234 ",null,"41 ","50 ","33,7 "]
["41 ","50 ","1174 ","1105 ","255 ","1185 ","1113 ","255 ","1196 ","1121 ","255 ","1206 ","1130 ","255 ",null,"51 ","60 ","41,2 "]
["51 ","60 ","1300 ","1219 ","277 ","1313 ","1229 ","277 ","1326 ","1239 ","277 ","1339 ","1249 ","277 ",null,"61 ","70 ","48,7 "]
["61 ","70 ","1426 ","1333 ","298 ","1441 ","1345 ","298 ","1456 ","1356 ","298 ","1472 ","1368 ","298 ",null,"71 ","80 ","56,2 "]
["71 ","80 ","1551 ","1447 ","320 ","1569 ","1460 ","320 ","1587 ","1474 ","320 ","1604 ","1488 ","320 ",null,"81 ","90 ","63,7 "]
["81 ","90 ","1677 ","1560 ","342 ","1697 ","1576 ","342 ","1717 ","1591 ","342 ","1737 ","1607 ","342 ",null,"91 ","100 ","71,2 "]
["91 ","100 ","1803 ","1674 ","363 ","1825 ","1692 ","363 ","1848 ","1709 ","363 ","1870 ","1726 ","363 ",null,"101 ","120 ","82,4 "]
["101 ","120 ","1991 ","1845 ","396 ","2017 ","1865 ","396 ","2043 ","1885 ","396 ","2069 ","1905 ","396 ",null,"121 ","140 ","97,4 "]
["121 ","140 ","2108 ","1948 ","413 ","2137 ","1971 ","413 ","2166 ","1993 ","413 ","2194 ","2015 ","413 ",null,"141 ","160 ","112,4 "]
["141 ","160 ","2217 ","2045 ","429 ","2249 ","2070 ","429 ","2280 ","2094 ","429 ","2312 ","2118 ","429 ",null,"161 ","180 ","125,9 "]
["161 ","180 ","2331 ","2147 ","447 ","2365 ","2173 ","447 ","2399 ","2199 ","447 ","2433 ","2226 ","447 ",null,"181 ","200 ","139,3 "]
["181 ","200 ","2411 ","2218 ","458 ","2447 ","2246 ","458 ","2483 ","2273 ","458 ","2519 ","2301 ","458 ",null,"201 ","220 ","152,5 "]
["201 ","220 ","2553 ","2346 ","482 ","2591 ","2376 ","482 ","2630 ","2406 ","482 ","2669 ","2436 ","482 ",null,"221 ","240 ","165,6 "]
["221 ","240 ","2694 ","2473 ","506 ","2735 ","2505 ","506 ","2777 ","2537 ","506 ","2818 ","2569 ","506 ",null,"241 ","260 ","178,4 "]
["241 ","260 ","2834 ","2600 ","529 ","2878 ","2634 ","529 ","2922 ","2668 ","529 ","2966 ","2702 ","529 ",null,"261 ","280 ","191,1 "]
["261 ","280 ","2973 ","2725 ","553 ","3020 ","2762 ","553 ","3067 ","2798 ","553 ","3114 ","2834 ","553 ",null,"281 ","300 ","203,6 "]
["281 ","300 ","3111 ","2850 ","576 ","3160 ","2888 ","576 ","3210 ","2927 ","576 ","3260 ","2965 ","576 ",null,"301 ","330 ","219,1 "]
["301 ","330 ","3282 ","3005 ","605 ","3335 ","3046 ","605 ","3388 ","3087 ","605 ","3441 ","3128 ","605 ",null,"331 ","360 ","237,4 "]
["331 ","360 ","3486 ","3189 ","640 ","3542 ","3233 ","640 ","3599 ","3277 ","640 ","3656 ","3321 ","640 ",null,"361 ","390 ","255,5 "]
["361 ","390 ","3687 ","3371 ","674 ","3748 ","3418 ","674 ","3808 ","3465 ","674 ","3869 ","3512 ","674 ",null,"391 ","420 ","273,3 "]
["391 ","420 ","3887 ","3552 ","709 ","3951 ","3602 ","709 ","4016 ","3652 ","709 ","4080 ","3702 ","709 ",null,"421 ","450 ","291,0 "]
["421 ","450 ","4085 ","3732 ","743 ","4154 ","3785 ","743 ","4222 ","3837 ","743 ","4290 ","3890 ","743 ",null,"451 ","480 ","308,5 "]
["451 ","480 ","4282 ","3910 ","776 ","4354 ","3966 ","776 ","4426 ","4021 ","776 ","4498 ","4077 ","776 ",null,"481 ","510 ","325,9 "]
["481 ","510 ","4478 ","4088 ","810 ","4554 ","4146 ","810 ","4630 ","4205 ","810 ","4706 ","4263 ","810 ",null,"511 ","540 ","343,1 "]
["511 ","540 ","4674 ","4264 ","843 ","4753 ","4326 ","843 ","4832 ","4387 ","843 ","4912 ","4448 ","843 ",null,"541 ","570 ","360,3 "]
["541 ","570 ","4868 ","4440 ","876 ","4951 ","4504 ","876 ","5034 ","4569 ","876 ","5117 ","4633 ","876 ",null,"571 ","600 ","377,4 "]
["571 ","600 ","5062 ","4616 ","910 ","5148 ","4683 ","910 ","5235 ","4750 ","910 ","5322 ","4817 ","910 ",null,"601 ","650 ","400,1 "]
["601 ","650 ","5319 ","4849 ","954 ","5411 ","4920 ","954 ","5502 ","4990 ","954 ","5594 ","5061 ","954 ",null,"651 ","700 ","428,4 "]
["651 ","700 ","5640 ","5140 ","1009 ","5738 ","5215 ","1009 ","5836 ","5291 ","1009 ","5933 ","5366 ","1009 ",null,"701 ","750 ","456,5 "]
["701 ","750 ","5961 ","5430 ","1064 ","6065 ","5510 ","1064 ","6169 ","5591 ","1064 ","6272 ","5671 ","1064 ",null,"751 ","800 ","484,7 "]
["751 ","800 ","6282 ","5721 ","1119 ","6392 ","5806 ","1119 ","6501 ","5890 ","1119 ","6611 ","5975 ","1119 ",null,"801 ","850 ","512,8 "]
["801 ","850 ","6603 ","6011 ","1174 ","6719 ","6101 ","1174 ","6834 ","6190 ","1174 ","6950 ","6280 ","1174 ",null,"851 ","900 ","540,9 "]
["851 ","900 ","6924 ","6303 ","1229 ","7046 ","6397 ","1229 ","7168 ","6491 ","1229 ","7290 ","6585 ","1229 ",null,"901 ","950 ","569,0 "]
["901 ","950 ","7246 ","6594 ","1285 ","7374 ","6693 ","1285 ","7502 ","6792 ","1285 ","7630 ","6891 ","1285 ",null,"951 ","1000 ","597,2 "]
["951 ","1000 ","7569 ","6886 ","1340 ","7703 ","6990 ","1340 ","7837 ","7094 ","1340 ","7971 ","7197 ","1340 ",null,"1001 ","1070 ","631,1 "]
["1001 ","1070 ","7957 ","7238 ","1407 ","8099 ","7348 ","1407 ","8240 ","7457 ","1407 ","8381 ","7566 ","1407 ",null,"1071 ","1140 ","670,8 "]
["1071 ","1140 ","8412 ","7650 ","1485 ","8562 ","7766 ","1485 ","8712 ","7882 ","1485 ","8862 ","7998 ","1485 ",null,"1141 ","1210 ","710,6 "]
["1141 ","1210 ","8869 ","8064 ","1564 ","9027 ","8186 ","1564 ","9186 ","8309 ","1564 ","9344 ","8431 ","1564 ",null,"1211 ","1280 ","750,6 "]
["1211 ","1280 ","9327 ","8479 ","1642 ","9494 ","8608 ","1642 ","9661 ","8737 ","1642 ","9828 ","8866 ","1642 ",null,"1281 ","1350 ","790,6 "]
["1281 ","1350 ","9787 ","8896 ","1722 ","9963 ","9032 ","1722 ","10139 ","9167 ","1722 ","10314 ","9303 ","1722 ",null,"1351 ","1420 ","830,8 "]
["1351 ","1420 ","10249 ","9314 ","1801 ","10433 ","9457 ","1801 ","10618 ","9599 ","1801 ","10802 ","9742 ","1801 ",null,"1421 ","1490 ","871,2 "]
["1421 ","1490 ","10712 ","9734 ","1881 ","10906 ","9883 ","1881 ","11099 ","10033 ","1881 ","11292 ","10182 ","1881 ",null,"1491 ","1590 ","920,3 "]
["1491 ","1590 ","11277 ","10246 ","1978 ","11481 ","10403 ","1978 ","11685 ","10561 ","1978 ","11888 ","10718 ","1978 ",null,"1591 ","1690 ","978,3 "]
["1591 ","1690 ","11944 ","10850 ","2092 ","12160 ","11017 ","2092 ","12377 ","11184 ","2092 ","12593 ","11351 ","2092 ",null,"1691 ","1790 ","1036,5 "]
["1691 ","1790 ","12614 ","11456 ","2208 ","12842 ","11633 ","2208 ","13071 ","11810 ","2208 ","13300 ","11987 ","2208 ",null,"1791 ","1890 ","1094,9 "]
["1791 ","1890 ","13285 ","12065 ","2323 ","13527 ","12251 ","2323 ","13768 ","12438 ","2323 ","14010 ","12625 ","2323 ",null,"1891 ","1990 ","1153,4 "]
["1891 ","1990 ","13958 ","12675 ","2439 ","14213 ","12871 ","2439 ","14467 ","13067 ","2439 ","14721 ","13264 ","2439 ",null,"1991 ","2090 ","1212,1 "]
["1991 ","2090 ","14633 ","13286 ","2555 ","14900 ","13492 ","2555 ","15167 ","13698 ","2555 ","15434 ","13905 ","2555 ",null,"2091 ","2190 ","1270,8 "]
["2091 ","2190 ","15309 ","13899 ","2671 ","15589 ","14115 ","2671 ","15869 ","14331 ","2671 ","16148 ","14547 ","2671 "]