{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Euro Truck","Small Trucks"],"not_rendered":{"charts":0,"images":5,"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":"Euro Truck","index":0,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,14,61,21],[59,23,61,29],[0,0,0,1]]}
["Estimation Tool for transportations round\n Russian Federation from Serpukhov"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ГОРОД","КМ","AGILITY","DACHSER","ASSTRA","SOVTRANS","MIN","Перевозчик",null,"ГОРОД","AGILITY","DACHSER","ASSTRA","SOVTRANS","MIN","Перевозчик"]
["Please choose the correct conditions for transportation and fill in the green cells :",null,null,null,null,null,null,null,null,null,null,null,null,null,"ATYRAU",1883,999999,150000,140000,114000,{"$f":"MIN(Q3:T3)","v":114000},{"$f":"IF(U3=Q3,$Q$2,IF(R3=U3,$R$2,IF(U3=S3,$S$2,IF(U3=T3,$T$2,0))))","v":"SOVTRANS"},null,"ATYRAU",{"$f":"IFERROR(Q3-Q3*10%,0)","v":899999.1},{"$f":"IFERROR(R3-R3*10%,0)","v":135000},{"$f":"IFERROR(S3-S3*10%,0)","v":126000},{"$f":"IFERROR(T3-T3*10%,0)","v":102600},{"$f":"MIN(Y3:AB3)","v":102600},{"$f":"IF(AC3=Y3,$Y$2,IF(Z3=AC3,$Z$2,IF(AC3=AA3,$AA$2,IF(AC3=AB3,$AB$2,0))))","v":"SOVTRANS"}]
["Equipment","Unit of measure","Estimated amount","Amount of required transport",null,null,null,null,null,null,null,null,null,null,"ACHINSK",4070,290000,265000,240000,231000,231000,{"$f":"IF(U4=Q4,$Q$2,IF(R4=U4,$R$2,IF(U4=S4,$S$2,IF(U4=T4,$T$2,0))))","v":"SOVTRANS"},null,"ACHINSK",{"$f":"IFERROR(Q4-Q4*10%,0)","v":261000},{"$f":"IFERROR(R4-R4*10%,0)","v":238500},{"$f":"IFERROR(S4-S4*10%,0)","v":216000},{"$f":"IFERROR(T4-T4*10%,0)","v":207900},{"$f":"MIN(Y4:AB4)","v":207900},{"$f":"IF(AC4=Y4,$Y$2,IF(Z4=AC4,$Z$2,IF(AC4=AA4,$AA$2,IF(AC4=AB4,$AB$2,0))))","v":"SOVTRANS"}]
["Random Packing (gross volume from Sulprice)","m3",0,{"$f":"C5/42","v":0},null,null,null,null,null,null,null,null,null,null,"ACTAU",2580,210000,243000,9999999,152000,152000,"SOVTRANS",null,"ACTAU",189000,218700,8999999.0999999996,136800,136800,"SOVTRANS"]
["Structured Packing (gross volume from Sulprice)","m3",0,{"$f":"C6/39","v":0},null,null,null,null,null,null,null,null,null,null,"ANGARSK",5242,380000,340000,395000,288750,288750,"SOVTRANS",null,"ANGARSK",342000,306000,355500,259875,259875,"SOVTRANS"]
["Trays (gross weight from Sulprice)","kg",0,{"$f":"C7/7000","v":0},null,null,null,null,null,null,null,null,null,null,"ASTRAKHAN",1351,120000,92000,89000,81900,81900,"SOVTRANS",null,"ASTRAKHAN",108000,82800,80100,73710,73710,"SOVTRANS"]
["Internals (gross weight from Sulprice)","kg",5000,{"$f":"C8/8000","v":0.625},null,null,null,"MOZYR, BY",null,null,null,null,null,null,"BALASHIHA",122,25000,19500,20000,17600,17600,"SOVTRANS",null,"BALASHIHA",{"$f":"IFERROR(Q8-Q8*15%,0)","v":21250},{"$f":"IFERROR(R8-R8*15%,0)","v":16575},17000,14960,14960,"SOVTRANS"]
["Total q-ty of standard trucks or containers x 40 \"",null,null,{"$f":"ROUNDUP(SUM(D5:D8),0)","v":1},null,null,null,"NOVOPOLOCK. BY",null,null,null,null,null,null,"BLAGOVESHSCENSK, AMUR",7900,600000,550000,480000,483000,480000,"ASSTRA",null,"BLAGOVESHSCENSK, AMUR",540000,495000,432000,434700,432000,"ASSTRA"]
[null,null,null,null,null,null,null,"ATYRAU",null,null,null,null,null,null,"BLAGOVESHSCENSK, BASH",1400,60000,100000,88000,39900,39900,"SOVTRANS",null,"BLAGOVESHSCENSK, BASH",54000,90000,79200,35910,35910,"SOVTRANS"]
["Destination City","ANGARSK",null,null,null,null,null,"ACTAU",null,null,null,null,null,null,"BORISOGLEBSK",574,60000,42000,9999999,39900,39900,"SOVTRANS",null,"BORISOGLEBSK",54000,37800,8999999.0999999996,35910,35910,"SOVTRANS"]
["Transportation time, days",{"$f":"ROUNDUP(VLOOKUP(B11,O:P,2,0)/500,0)","v":11},null,null,null,null,null,null,null,null,null,null,null,null,"BRATSK",4919,380000,335000,320000,309750,309750,"SOVTRANS",null,"BRATSK",342000,301500,288000,278775,278775,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOROGOBUZH",346,40000,30000,999999,25200,25200,"SOVTRANS",null,"DOROGOBUZH",36000,27000,899999.1,22680,22680,"SOVTRANS"]
["Details:",null,null,null,null,null,null,null,null,null,null,null,null,null,"DZERZHINSK",490,40000,37000,33000,28350,28350,"SOVTRANS",null,"DZERZHINSK",{"$f":"IFERROR(Q14-Q14*15%,0)","v":34000},{"$f":"IFERROR(R14-R14*15%,0)","v":31450},28050,24097.5,24097.5,"SOVTRANS"]
["COO, once for an ICO",{"$f":"IF(ISNUMBER(MATCH($B$11,$H$8:$H$11,0)),5900,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"GAGARIN",201,30000,25000,40000,21000,21000,"SOVTRANS",null,"GAGARIN",{"$f":"IFERROR(Q15-Q15*15%,0)","v":25500},21250,34000,17850,17850,"SOVTRANS"]
["InC from FSTEC of Russia, once for an ICO",{"$f":"IF(ISNUMBER(MATCH($B$11,$H$8:$H$11,0)),8000,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"KALUGA",133,25000,23000,24000,18700,18700,"SOVTRANS",null,"KALUGA",{"$f":"IFERROR(Q16-Q16*15%,0)","v":21250},19550,20400,15895,15895,"SOVTRANS"]
["Total freight & logistics costs",{"$f":"SUM(B15:B16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"KAZAN",912,999999,60000,65000,54600,54600,"SOVTRANS",null,"KAZAN",{"$f":"IFERROR(Q17-Q17*15%,0)","v":849999.15},51000,55250,46410,46410,"SOVTRANS"]
["Details:","🚚 Truck  Euro",null,null,null,null,null,null,null,null,null,null,null,null,"KEMEROVO",3711,280000,255000,195000,204750,195000,"ASSTRA",null,"KEMEROVO",252000,229500,175500,184275,175500,"ASSTRA"]
["Total freight forwarder & logistics costs ",{"$f":"IF(ISNA(VLOOKUP(B11,H8:H22,1,0))=TRUE,VLOOKUP(B11,X:AD,6,0)*D9,SUM(VLOOKUP(B11,X:AD,6,0)*D9,B17))","v":259875},null,null,null,{"$f":"VLOOKUP(B11,X:AD,7,0)","v":"SOVTRANS"},null,null,null,null,null,null,null,null,"KIRISHI",749,55000,43000,40000,36750,36750,"SOVTRANS",null,"KIRISHI",49500,38700,36000,33075,33075,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIROVO-CHEPECK",1106,100000,72000,76000,54600,54600,"SOVTRANS",null,"KIROVO-CHEPECK",90000,64800,68400,49140,49140,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KRASNODAR",1312,100000,84000,85000,75600,75600,"SOVTRANS",null,"KRASNODAR",90000,75600,76500,68040,68040,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KRASNOYARSK",4239,320000,275000,230000,236250,230000,"ASSTRA",null,"KRASNOYARSK",288000,247500,207000,212625,207000,"ASSTRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KSTOVO",538,50000,38000,32000,29400,29400,"SOVTRANS",null,"KSTOVO",{"$f":"IFERROR(Q23-Q23*15%,0)","v":42500},{"$f":"IFERROR(R23-R23*15%,0)","v":32300},27200,24990,24990,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KURGAN",2200,165000,140000,160000,132300,132300,"SOVTRANS",null,"KURGAN",148500,126000,144000,119070,119070,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIPECK",423,55000,32000,33000,26250,26250,"SOVTRANS",null,"LIPECK",49500,28800,29700,23625,23625,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONCHEGORSK",1910,175000,390000,130000,120750,120750,"SOVTRANS",null,"MONCHEGORSK",157500,351000,117000,108675,108675,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOSCOW",103,25000,19000,19000,16500,16500,"SOVTRANS",null,"MOSCOW",{"$f":"IFERROR(Q27-Q27*15%,0)","v":21250},{"$f":"IFERROR(R27-R27*15%,0)","v":16150},16150,14025,14025,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOZYR, BY",738,70000,54000,999999,999999,{"$f":"MIN(Q28:T28)","v":54000},"DACHSER",null,"MOZYR, BY",63000,48600,899999.1,899999.1,48600,"DACHSER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NIZHNEKAMSK",1230,95000,75000,70000,59850,59850,"SOVTRANS",null,"NIZHNEKAMSK",{"$f":"IFERROR(Q29-Q29*15%,0)","v":80750},{"$f":"IFERROR(R29-R29*15%,0)","v":63750},59500,50872.5,50872.5,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NIZHNEVARTOVSK",3234,255000,205000,185000,183750,183750,"SOVTRANS",null,"NIZHNEVARTOVSK",229500,184500,166500,165375,165375,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NIZHNY NOVGOROD",499,45000,35000,32000,29400,29400,"SOVTRANS",null,"NIZHNY NOVGOROD",{"$f":"IFERROR(Q31-Q31*15%,0)","v":38250},{"$f":"IFERROR(R31-R31*15%,0)","v":29750},27200,24990,24990,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOVIY URENGOY",3761,300000,253000,215000,225750,215000,"ASSTRA",null,"NOVIY URENGOY",270000,227700,193500,203175,193500,"ASSTRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOVOMOSKOVSK",851,32000,23000,26000,17850,17850,"SOVTRANS",null,"NOVOMOSKOVSK",{"$f":"IFERROR(Q33-Q33*15%,0)","v":27200},{"$f":"IFERROR(R33-R33*15%,0)","v":19550},22100,15172.5,15172.5,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOVOPOLOCK. BY",659,60000,45000,999999,999999,45000,"DACHSER",null,"NOVOPOLOCK. BY",54000,40500,899999.1,899999.1,40500,"DACHSER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOVOSHAHTINSK",981,80000,68000,78000,61950,{"$f":"MIN(Q35:T35)","v":61950},"SOVTRANS",null,"NOVOSHAHTINSK",72000,61200,70200,55755,55755,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OMSK",2803,220000,175000,140000,162750,140000,"ASSTRA",null,"OMSK",{"$f":"IFERROR(Q36-Q36*10%,0)","v":198000},157500,126000,146475,126000,"ASSTRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORENBURG",1463,120000,100000,103000,94500,94500,"SOVTRANS",null,"ORENBURG",108000,90000,92700,85050,85050,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORSK",1753,135000,114000,105000,105000,105000,"ASSTRA",null,"ORSK",121500,102600,94500,94500,94500,"ASSTRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAVLODAR",3225,280000,245000,999999,999999,245000,"DACHSER",null,"PAVLODAR",252000,220500,899999.1,899999.1,220500,"DACHSER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERM",1544,125000,95000,100000,91350,91350,"SOVTRANS",null,"PERM",{"$f":"IFERROR(Q40-Q40*15%,0)","v":106250},{"$f":"IFERROR(R40-R40*15%,0)","v":80750},85000,77647.5,77647.5,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PODOLSK",68,18000,19000,21000,14700,14700,"SOVTRANS",null,"PODOLSK",{"$f":"IFERROR(Q41-Q41*15%,0)","v":15300},16150,17850,{"$f":"IFERROR(T41-T41*15%,0)","v":12495},12495,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROSTOV-NA-DONU",1034,85000,70000,75000,63000,63000,"SOVTRANS",null,"ROSTOV-NA-DONU",76500,63000,67500,56700,56700,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RYAZAN",233,30000,23000,26000,18900,18900,"SOVTRANS",null,"RYAZAN",27000,20700,23400,17010,17010,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALAVAT, BEL",1654,95000,100000,999999,99999,95000,"AGILITY",null,"SALAVAT, BEL",85500,90000,899999.1,89999.1,85500,"AGILITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAMARA",1054,75000,70000,68000,63000,63000,"SOVTRANS",null,"SAMARA",67500,63000,61200,56700,56700,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANKT-PETERBURG",810,50000,39000,39000,39900,39000,"DACHSER",null,"SANKT-PETERBURG",{"$f":"IFERROR(Q46-Q46*15%,0)","v":42500},{"$f":"IFERROR(R46-R46*15%,0)","v":33150},33150,33915,33150,"DACHSER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SARATOV",795,65000,60000,65000,53550,53550,"SOVTRANS",null,"SARATOV",58500,54000,58500,48195,48195,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALAVAT",1500,125000,99999999,98000,89250,89250,"SOVTRANS",null,"SALAVAT",112500,89999999.099999994,88200,80325,80325,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SYZRAN",898,70000,65000,69000,63000,63000,"SOVTRANS",null,"SYZRAN",63000,58500,62100,56700,56700,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAGANROG",1100,80000,74000,78000,68250,68250,"SOVTRANS",null,"TAGANROG",72000,66600,70200,61425,61425,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TATARSTAN",1262,80000,67000,65000,99999,65000,"ASSTRA",null,"TATARSTAN",72000,60300,58500,89999.1,58500,"ASSTRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TULA",92,22000,22000,25000,16800,16800,"SOVTRANS",null,"TULA",{"$f":"IFERROR(Q52-Q52*15%,0)","v":18700},{"$f":"IFERROR(R52-R52*15%,0)","v":18700},21250,14280,14280,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TUMEN",2209,185000,145000,140000,133350,133350,"SOVTRANS",null,"TUMEN",166500,130500,126000,120015,120015,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ULYANOVSK",880,70000,65000,63000,59850,59850,"SOVTRANS",null,"ULYANOVSK",63000,58500,56700,53865,53865,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UST-KUT (IRKUTSK)",5269,395000,323000,320000,299250,299250,"SOVTRANS",null,"UST-KUT (IRKUTSK)",355500,290700,288000,269325,269325,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VELIKI NOVGOROD",682,45000,37000,38000,33600,33600,"SOVTRANS",null,"VELIKI NOVGOROD",{"$f":"IFERROR(Q56-Q56*15%,0)","v":38250},{"$f":"IFERROR(R56-R56*15%,0)","v":31450},32300,28560,28560,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VOLGOGRAD",928,70000,65000,65000,52500,52500,"SOVTRANS",null,"VOLGOGRAD",63000,58500,58500,47250,47250,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VORONEZH",482,35000,35000,35000,27300,27300,"SOVTRANS",null,"VORONEZH",31500,31500,31500,24570,24570,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YAROSLAVL",375,35000,28000,26000,24150,24150,"SOVTRANS",null,"YAROSLAVL",{"$f":"IFERROR(Q59-Q59*15%,0)","v":29750},{"$f":"IFERROR(R59-R59*15%,0)","v":23800},22100,20527.5,20527.5,"SOVTRANS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ФУРА 20т",null,null,null,null,null,null,null,null,"(СТАВКА - НДС) + ЗАПАС"]

{"sheet":"Small Trucks","index":1,"n_rows":62,"n_cols":54,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,0,0,1],[3,47,3,51],[61,8,63,15],[61,17,63,24],[61,26,63,33],[3,35,3,39],[3,41,3,45]]}
["Estimation Tool for transportations round\n Russian Federation from Serpukhov"]
[]
["Please choose the correct conditions for transportation and fill in the green cells :"]
["Destination city","ASTRAKHAN",null,null,null,null,null,null,"ГОРОД","КМ","AGILITY","DACHSER","ASSTRA","SOVTRANS","MIN","Перевозчик",null,"ГОРОД","КМ","AGILITY","DACHSER","ASSTRA","SOVTRANS","MIN","Перевозчик",null,"ГОРОД","КМ","AGILITY","DACHSER","ASSTRA","SOVTRANS","MIN","Перевозчик",null,"(СТАВКА - НДС) + ЗАПАС 10ТОННИК",null,null,null,null,null,"(СТАВКА - НДС) + ЗАПАС 10ТОННИК",null,null,null,null,null,"(СТАВКА - НДС) + ЗАПАС 3ТОННИК (СБОРКА)",null,null,null,null,null,"MOZYR, BY"]
["Transportation time, days",{"$f":"ROUNDUP(VLOOKUP(B4,I5:J60,2,0)/500,0)","v":3},null,null,null,null,null,null,"ATYRAU",1883,0,0,0,0,{"$f":"MIN(K5:N5)","v":0},{"$f":"IF(O5=K5,$K$4,IF(O5=L5,$L$4,IF(O5=M5,$M$4,IF(O5=N5,$N$4,0))))","v":"AGILITY"},null,"ATYRAU",1883,0,0,0,0,{"$f":"MIN(T5:W5)","v":0},{"$f":"IF(X5=T5,$T$4,IF(X5=U5,$U$4,IF(X5=V5,$V$4,IF(X5=W5,$W$4,0))))","v":"AGILITY"},null,"ATYRAU",1883,9999999,60000,9999999,9999999,{"$f":"MIN(AC5:AF5)","v":60000},{"$f":"IF(AG5=AC5,$AC$4,IF(AG5=AD5,$AD$4,IF(AG5=AE5,$AE$4,IF(AG5=AF5,$AF$4,0))))","v":"DACHSER"},null,{"$f":"IFERROR(K5-K5*10%,0)","v":0},{"$f":"IFERROR(L5-L5*10%,0)","v":0},0,0,{"$f":"MIN(AJ5:AM5)","v":0},null,{"$f":"IFERROR(T5-T5*10%,0)","v":0},{"$f":"IFERROR(U5-U5*10%,0)","v":0},0,0,{"$f":"MIN(AP5:AS5)","v":0},null,{"$f":"IFERROR(AC5-AC5*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD5-AD5*10%,0)","v":54000},8999999.0999999996,8999999.0999999996,{"$f":"MIN(AV5:AY5)","v":54000},null,"NOVOPOLOCK. BY"]
[null,null,null,null,null,null,null,null,"ACHINSK",4070,{"$f":"240000-240000*10%","v":216000},225000,180000,196350,180000,{"$f":"IF(O6=K6,$K$4,IF(O6=L6,$L$4,IF(O6=M6,$M$4,IF(O6=N6,$N$4,0))))","v":"ASSTRA"},null,"ACHINSK",4070,9999999,185000,9999999,157080,157080,{"$f":"IF(X6=T6,$T$4,IF(X6=U6,$U$4,IF(X6=V6,$V$4,IF(X6=W6,$W$4,0))))","v":"SOVTRANS"},null,"ACHINSK",4070,9999999,170000,9999999,133980,133980,{"$f":"IF(AG6=AC6,$AC$4,IF(AG6=AD6,$AD$4,IF(AG6=AE6,$AE$4,IF(AG6=AF6,$AF$4,0))))","v":"SOVTRANS"},null,{"$f":"IFERROR(K6-K6*10%,0)","v":194400},202500,162000,176715,{"$f":"MIN(AJ6:AM6)","v":162000},null,{"$f":"IFERROR(T6-T6*10%,0)","v":8999999.0999999996},166500,8999999.0999999996,141372,{"$f":"MIN(AP6:AS6)","v":141372},null,{"$f":"IFERROR(AC6-AC6*10%,0)","v":8999999.0999999996},153000,8999999.0999999996,120582,{"$f":"MIN(AV6:AY6)","v":120582},null,"ATYRAU"]
[null,null,null,null,null,null,null,null,"ACTAU",2580,160000,195000,9999999,null,160000,"AGILITY",null,"ACTAU",2580,9999999,148000,9999999,9999999,148000,"DACHSER",null,"ACTAU",2580,9999999,140000,9999999,9999999,140000,"DACHSER",null,144000,175500,8999999.0999999996,0,0,null,8999999.0999999996,133200,8999999.0999999996,8999999.0999999996,133200,null,8999999.0999999996,126000,8999999.0999999996,8999999.0999999996,126000,null,"ACTAU"]
["Details:",null,null,null,null,null,null,null,"ANGARSK",5242,320000,290000,367000,245437.5,245437.5,"SOVTRANS",null,"ANGARSK",5242,9999999,241000,9999999,196350,196350,"SOVTRANS",null,"ANGARSK",5242,9999999,218000,9999999,167475,167475,"SOVTRANS",null,288000,261000,330300,220893.75,220893.75,null,8999999.0999999996,216900,8999999.0999999996,176715,176715,null,8999999.0999999996,196200,8999999.0999999996,150727.5,150727.5]
["COO, once for an ICO",{"$f":"IF(ISNUMBER(MATCH($B$4,$BB$4:$BB$7,0)),5900,0)","v":0},null,null,null,null,null,null,"ASTRAKHAN",1351,100000,77000,56000,69615,56000,"ASSTRA",null,"ASTRAKHAN",1351,9999999,65000,9999999,55692,55692,"SOVTRANS",null,"ASTRAKHAN",1351,9999999,58000,9999999,47502,47502,"SOVTRANS",null,90000,69300,50400,62653.5,50400,null,8999999.0999999996,58500,8999999.0999999996,50122.8,50122.8,null,8999999.0999999996,52200,8999999.0999999996,42751.8,42751.8]
["InC from FSTEC of Russia, once for an ICO",{"$f":"IF(ISNUMBER(MATCH($B$4,$BB$4:$BB$7,0)),8000,0)","v":0},null,null,null,null,null,null,"BALASHIHA",122,20000,17000,18000,14960.000000000002,14960.000000000002,"SOVTRANS",null,"BALASHIHA",122,9999999,15000,9999999,11968,11968,"SOVTRANS",null,"BALASHIHA",122,9999999,13000,13000,10208,10208,"SOVTRANS",null,{"$f":"IFERROR(L10-L10*15%,0)","v":14450},{"$f":"IFERROR(M10-M10*15%,0)","v":15300},12716.000000000002,12716.000000000002,12716.000000000002,null,{"$f":"IFERROR(T10-T10*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U10-U10*15%,0)","v":12750},8499999.1500000004,10172.799999999999,10172.799999999999,null,{"$f":"IFERROR(AC10-AC10*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD10-AD10*15%,0)","v":11050},11050,8676.7999999999993,{"$f":"MIN(AV10:AY10)","v":8676.7999999999993}]
["Total freight & logistics costs (to be added in Sulprice)",{"$f":"SUM(B9:B10)","v":0},null,null,null,null,null,null,"BLAGOVESHSCENSK, AMUR",7900,475000,450000,395000,410550,395000,"ASSTRA",null,"BLAGOVESHSCENSK, AMUR",7900,9999999,390000,395000,328440,328440,"SOVTRANS",null,"BLAGOVESHSCENSK, AMUR",7900,9999999,380000,315000,280140,280140,"SOVTRANS",null,{"$f":"IFERROR(L11-L11*10%,0)","v":405000},{"$f":"IFERROR(M11-M11*10%,0)","v":355500},369495,355500,355500,null,8999999.0999999996,{"$f":"IFERROR(U11-U11*10%,0)","v":351000},{"$f":"IFERROR(V11-V11*10%,0)","v":355500},{"$f":"IFERROR(W11-W11*10%,0)","v":295596},295596,null,{"$f":"IFERROR(AC11-AC11*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD11-AD11*10%,0)","v":342000},283500,252126,252126]
["Details:","🚚 Truck 10t","🚚 Truck 5t","🚚 Truck 3t / LTL",null,"🚚 Truck 10t",null,null,"BLAGOVESHSCENSK, BASH",1400,95000,90000,73000,33915,33915,"SOVTRANS",null,"BLAGOVESHSCENSK, BASH",1400,9999999,78000,73000,27132,27132,"SOVTRANS",null,"BLAGOVESHSCENSK, BASH",1400,9999999,62000,58000,23142,23142,"SOVTRANS",null,{"$f":"IFERROR(L12-L12*10%,0)","v":81000},65700,30523.5,30523.5,30523.5,null,8999999.0999999996,70200,65700,24418.799999999999,24418.799999999999,null,{"$f":"IFERROR(AC12-AC12*10%,0)","v":8999999.0999999996},55800,52200,20827.8,20827.8]
["Total freight & logistics costs ",{"$f":"IF(ISNA(VLOOKUP(B4,F17:F20,1,0))=TRUE,VLOOKUP(B4,I:P,7,0),SUM(VLOOKUP(B4,I:P,7,0),B11))","v":56000},{"$f":"IF(ISNA(VLOOKUP(B4,F17:F20,1,0))=TRUE,VLOOKUP(B4,R:Y,7,0),SUM(VLOOKUP(B4,R:Y,7,0),B11))","v":55692},{"$f":"IF(ISNA(VLOOKUP(B4,F17:F20,1,0))=TRUE,VLOOKUP(B4,AA:AH,7,0),SUM(VLOOKUP(B4,AA:AH,7,0),B11))","v":47502},null,{"$f":"VLOOKUP(B4,I:P,8,0)","v":"ASSTRA"},null,null,"BORISOGLEBSK",574,50000,38000,9999999,33915,33915,"SOVTRANS",null,"BORISOGLEBSK",574,9999999,32000,9999999,27132,27132,"SOVTRANS",null,"BORISOGLEBSK",574,9999999,29000,9999999,23142,23142,"SOVTRANS",null,34200,8999999.0999999996,30523.5,30523.5,30523.5,null,8999999.0999999996,28800,8999999.0999999996,24418.799999999999,24418.799999999999,null,8999999.0999999996,26100,8999999.0999999996,20827.8,20827.8]
[null,null,null,null,null,null,null,null,"BRATSK",4919,295000,285000,250000,263287.5,250000,"ASSTRA",null,"BRATSK",4919,9999999,237000,9999999,210630,210630,"SOVTRANS",null,"BRATSK",4919,9999999,220000,9999999,179655,179655,"SOVTRANS",null,256500,225000,236958.75,225000,225000,null,8999999.0999999996,213300,8999999.0999999996,189567,189567,null,8999999.0999999996,198000,8999999.0999999996,161689.5,161689.5]
[null,null,null,null,null,"🚚 Truck 5t",null,null,"DOROGOBUZH",346,35000,26000,9999999,21420,21420,"SOVTRANS",null,"DOROGOBUZH",346,9999999,24000,9999999,17136,17136,"SOVTRANS",null,"DOROGOBUZH",346,9999999,22000,9999999,14615.999999999998,14615.999999999998,"SOVTRANS",null,23400,8999999.0999999996,19278,19278,19278,null,8999999.0999999996,21600,8999999.0999999996,15422.4,15422.4,null,8999999.0999999996,19800,8999999.0999999996,13154.399999999998,13154.399999999998]
[null,null,null,null,null,{"$f":"VLOOKUP(B4,R:Y,8,0)","v":"SOVTRANS"},null,null,"DZERZHINSK",490,33000,32000,25000,24097.5,24097.5,"SOVTRANS",null,"DZERZHINSK",490,9999999,28000,9999999,19278,19278,"SOVTRANS",null,"DZERZHINSK",490,9999999,25000,15000,16443,15000,"ASSTRA",null,{"$f":"IFERROR(L16-L16*15%,0)","v":27200},{"$f":"IFERROR(M16-M16*15%,0)","v":21250},20482.875,20482.875,20482.875,null,{"$f":"IFERROR(T16-T16*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U16-U16*15%,0)","v":23800},8499999.1500000004,16386.3,16386.3,null,{"$f":"IFERROR(AC16-AC16*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD16-AD16*15%,0)","v":21250},12750,13976.55,12750]
[null,null,null,null,null,null,null,null,"GAGARIN",201,25000,21000,35000,17850,17850,"SOVTRANS",null,"GAGARIN",201,9999999,18000,9999999,14280,14280,"SOVTRANS",null,"GAGARIN",201,9999999,16000,9999999,12180,12180,"SOVTRANS",null,{"$f":"IFERROR(L17-L17*15%,0)","v":17850},29750,15172.5,15172.5,15172.5,null,{"$f":"IFERROR(T17-T17*15%,0)","v":8499999.1500000004},15300,8499999.1500000004,12138,12138,null,{"$f":"IFERROR(AC17-AC17*15%,0)","v":8499999.1500000004},13600,8499999.1500000004,10353,10353]
[null,null,null,null,null,"🚚 Truck 3t",null,null,"KALUGA",133,22000,18000,17000,15895.000000000002,15895.000000000002,"SOVTRANS",null,"KALUGA",133,9999999,15000,9999999,12716,12716,"SOVTRANS",null,"KALUGA",133,9999999,13000,12000,10846,10846,"SOVTRANS",null,15300,14450,13510.750000000002,13510.750000000002,13510.750000000002,null,8499999.1500000004,12750,8499999.1500000004,10808.6,10808.6,null,8499999.1500000004,11050,10200,9219.1,9219.1]
[null,null,null,null,null,{"$f":"VLOOKUP(B4,AA:AH,8,0)","v":"SOVTRANS"},null,null,"KAZAN",912,70000,50000,38000,46410,38000,"ASSTRA",null,"KAZAN",912,9999999,44000,9999999,37128,37128,"SOVTRANS",null,"KAZAN",912,9999999,39000,30000,31667.999999999996,30000,"ASSTRA",null,42500,32300,39448.5,32300,32300,null,8499999.1500000004,37400,8499999.1500000004,31558.799999999999,31558.799999999999,null,8499999.1500000004,33150,25500,26917.799999999996,25500]
[null,null,null,null,null,null,null,null,"KEMEROVO",3711,220000,220000,160000,174037.5,160000,"ASSTRA",null,"KEMEROVO",3711,9999999,180000,9999999,139230,139230,"SOVTRANS",null,"KEMEROVO",3711,9999999,168000,9999999,118754.99999999999,118754.99999999999,"SOVTRANS",null,{"$f":"IFERROR(L20-L20*10%,0)","v":198000},{"$f":"IFERROR(M20-M20*10%,0)","v":144000},156633.75,144000,144000,null,8999999.0999999996,{"$f":"IFERROR(U20-U20*10%,0)","v":162000},{"$f":"IFERROR(V20-V20*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(W20-W20*10%,0)","v":125307},125307,null,{"$f":"IFERROR(AC20-AC20*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD20-AD20*10%,0)","v":151200},8999999.0999999996,106879.49999999999,106879.49999999999]
[null,null,null,null,null,null,null,null,"KIRISHI",749,45000,37000,35000,31237.5,31237.5,"SOVTRANS",null,"KIRISHI",749,9999999,32000,9999999,24990,24990,"SOVTRANS",null,"KIRISHI",749,9999999,29000,9999999,21315,21315,"SOVTRANS",null,{"$f":"IFERROR(L21-L21*10%,0)","v":33300},31500,28113.75,28113.75,28113.75,null,8999999.0999999996,28800,8999999.0999999996,22491,22491,null,{"$f":"IFERROR(AC21-AC21*10%,0)","v":8999999.0999999996},26100,8999999.0999999996,19183.5,19183.5]
[null,null,null,null,null,null,null,null,"KIROVO-CHEPECK",1106,85000,62000,49000,46410,46410,"SOVTRANS",null,"KIROVO-CHEPECK",1106,9999999,50000,9999999,37128,37128,"SOVTRANS",null,"KIROVO-CHEPECK",1106,9999999,46000,9999999,31667.999999999996,31667.999999999996,"SOVTRANS",null,55800,44100,41769,41769,41769,null,8999999.0999999996,45000,8999999.0999999996,33415.199999999997,33415.199999999997,null,8999999.0999999996,41400,8999999.0999999996,28501.199999999997,28501.199999999997]
[null,null,null,null,null,null,null,null,"KRASNODAR",1312,85000,70000,65000,64260,64260,"SOVTRANS",null,"KRASNODAR",1312,9999999,59000,9999999,51408,51408,"SOVTRANS",null,"KRASNODAR",1312,9999999,55000,55000,43848,43848,"SOVTRANS",null,63000,58500,57834,57834,57834,null,8999999.0999999996,53100,8999999.0999999996,46267.199999999997,46267.199999999997,null,8999999.0999999996,49500,49500,39463.199999999997,39463.199999999997]
[null,null,null,null,null,null,null,null,"KRASNOYARSK",4239,250000,243000,170000,200812.5,170000,"ASSTRA",null,"KRASNOYARSK",4239,9999999,205000,9999999,160650,160650,"SOVTRANS",null,"KRASNOYARSK",4239,9999999,185000,155000,137025,137025,"SOVTRANS",null,218700,153000,180731.25,153000,153000,null,8999999.0999999996,184500,8999999.0999999996,144585,144585,null,8999999.0999999996,166500,139500,123322.5,123322.5]
[null,null,null,null,null,null,null,null,"KSTOVO",538,40000,33000,24000,24990,24000,"ASSTRA",null,"KSTOVO",538,9999999,29000,9999999,19992,19992,"SOVTRANS",null,"KSTOVO",538,9999999,26000,19000,17052,17052,"SOVTRANS",null,{"$f":"IFERROR(L25-L25*15%,0)","v":28050},{"$f":"IFERROR(M25-M25*15%,0)","v":20400},21241.5,20400,20400,null,{"$f":"IFERROR(T25-T25*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U25-U25*15%,0)","v":24650},8499999.1500000004,16993.2,16993.2,null,{"$f":"IFERROR(AC25-AC25*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD25-AD25*15%,0)","v":22100},16150,14494.2,14494.2]
[null,null,null,null,null,null,null,null,"KURGAN",2200,140000,126000,135000,112455,112455,"SOVTRANS",null,"KURGAN",2200,9999999,112000,9999999,89964,89964,"SOVTRANS",null,"KURGAN",2200,9999999,105000,9999999,76734,76734,"SOVTRANS",null,{"$f":"IFERROR(L26-L26*10%,0)","v":113400},{"$f":"IFERROR(M26-M26*10%,0)","v":121500},101209.5,101209.5,101209.5,null,8999999.0999999996,{"$f":"IFERROR(U26-U26*10%,0)","v":100800},{"$f":"IFERROR(V26-V26*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(W26-W26*10%,0)","v":80967.600000000006},80967.600000000006,null,{"$f":"IFERROR(AC26-AC26*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD26-AD26*10%,0)","v":94500},8999999.0999999996,69060.600000000006,69060.600000000006]
[null,null,null,null,null,null,null,null,"LIPECK",423,45000,28000,25000,22312.5,22312.5,"SOVTRANS",null,"LIPECK",423,9999999,24000,9999999,17850,17850,"SOVTRANS",null,"LIPECK",423,9999999,20000,20000,15224.999999999998,15224.999999999998,"SOVTRANS",null,{"$f":"IFERROR(L27-L27*10%,0)","v":25200},22500,20081.25,20081.25,20081.25,null,8999999.0999999996,21600,8999999.0999999996,16065,16065,null,{"$f":"IFERROR(AC27-AC27*10%,0)","v":8999999.0999999996},18000,18000,13702.499999999998,13702.499999999998]
[null,null,null,null,null,null,null,null,"MONCHEGORSK",1910,145000,102000,85000,102637.5,85000,"ASSTRA",null,"MONCHEGORSK",1910,9999999,90000,9999999,82110,82110,"SOVTRANS",null,"MONCHEGORSK",1910,9999999,77000,9999999,70035,70035,"SOVTRANS",null,91800,76500,92373.75,76500,76500,null,8999999.0999999996,81000,8999999.0999999996,73899,73899,null,8999999.0999999996,69300,8999999.0999999996,63031.5,63031.5]
[null,null,null,null,null,null,null,null,"MOSCOW",103,20000,17000,15000,14025.000000000002,14025.000000000002,"SOVTRANS",null,"MOSCOW",103,9999999,14000,9999999,11220,11220,"SOVTRANS",null,"MOSCOW",103,9999999,12000,10000,9570,9570,"SOVTRANS",null,{"$f":"IFERROR(L29-L29*15%,0)","v":14450},{"$f":"IFERROR(M29-M29*15%,0)","v":12750},11921.250000000002,11921.250000000002,11921.250000000002,null,{"$f":"IFERROR(T29-T29*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U29-U29*15%,0)","v":11900},8499999.1500000004,9537,9537,null,{"$f":"IFERROR(AC29-AC29*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD29-AD29*15%,0)","v":10200},8500,8134.5,8134.5]
[null,null,null,null,null,null,null,null,"MOZYR, BY",738,60000,45000,9999999,9999999,45000,"DACHSER",null,"MOZYR, BY",738,9999999,40000,9999999,9999999,40000,"DACHSER",null,"MOZYR, BY",738,9999999,37000,9999999,9999999,37000,"DACHSER",null,{"$f":"IFERROR(L30-L30*10%,0)","v":40500},{"$f":"IFERROR(M30-M30*10%,0)","v":8999999.0999999996},8999999.0999999996,40500,40500,null,8999999.0999999996,{"$f":"IFERROR(U30-U30*10%,0)","v":36000},{"$f":"IFERROR(V30-V30*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(W30-W30*10%,0)","v":8999999.0999999996},36000,null,{"$f":"IFERROR(AC30-AC30*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD30-AD30*10%,0)","v":33300},8999999.0999999996,8999999.0999999996,33300]
[null,null,null,null,null,null,null,null,"NIZHNEKAMSK",1230,80000,64000,48000,50872.5,48000,"ASSTRA",null,"NIZHNEKAMSK",1230,9999999,52000,9999999,40698,40698,"SOVTRANS",null,"NIZHNEKAMSK",1230,9999999,48000,35000,34713,34713,"SOVTRANS",null,{"$f":"IFERROR(L31-L31*15%,0)","v":54400},{"$f":"IFERROR(M31-M31*15%,0)","v":40800},43241.625,40800,40800,null,{"$f":"IFERROR(T31-T31*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U31-U31*15%,0)","v":44200},8499999.1500000004,34593.300000000003,34593.300000000003,null,{"$f":"IFERROR(AC31-AC31*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD31-AD31*15%,0)","v":40800},29750,29506.05,29506.05]
[null,null,null,null,null,null,null,null,"NIZHNEVARTOVSK",3234,190000,183000,144000,156187.5,144000,"ASSTRA",null,"NIZHNEVARTOVSK",3234,9999999,145000,9999999,124950,124950,"SOVTRANS",null,"NIZHNEVARTOVSK",3234,9999999,135000,9999999,106575,106575,"SOVTRANS",null,{"$f":"IFERROR(L32-L32*10%,0)","v":164700},{"$f":"IFERROR(M32-M32*10%,0)","v":129600},140568.75,129600,129600,null,8999999.0999999996,{"$f":"IFERROR(U32-U32*10%,0)","v":130500},{"$f":"IFERROR(V32-V32*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(W32-W32*10%,0)","v":112455},112455,null,{"$f":"IFERROR(AC32-AC32*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD32-AD32*10%,0)","v":121500},8999999.0999999996,95917.5,95917.5]
[null,null,null,null,null,null,null,null,"NIZHNY NOVGOROD",499,35000,30000,24000,24990,24000,"ASSTRA",null,"NIZHNY NOVGOROD",499,9999999,27000,9999999,19992,19992,"SOVTRANS",null,"NIZHNY NOVGOROD",499,9999999,24000,19000,17052,17052,"SOVTRANS",null,{"$f":"IFERROR(L33-L33*15%,0)","v":25500},{"$f":"IFERROR(M33-M33*15%,0)","v":20400},21241.5,20400,20400,null,{"$f":"IFERROR(T33-T33*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U33-U33*15%,0)","v":22950},8499999.1500000004,16993.2,16993.2,null,{"$f":"IFERROR(AC33-AC33*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD33-AD33*15%,0)","v":20400},16150,14494.2,14494.2]
[null,null,null,null,null,null,null,null,"NOVIY URENGOY",3761,230000,22000,165000,191887.5,22000,"DACHSER",null,"NOVIY URENGOY",3761,9999999,180000,9999999,153510,153510,"SOVTRANS",null,"NOVIY URENGOY",3761,9999999,172000,145000,130934.99999999999,130934.99999999999,"SOVTRANS",null,{"$f":"IFERROR(L34-L34*10%,0)","v":19800},{"$f":"IFERROR(M34-M34*10%,0)","v":148500},172698.75,19800,19800,null,8999999.0999999996,{"$f":"IFERROR(U34-U34*10%,0)","v":162000},{"$f":"IFERROR(V34-V34*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(W34-W34*10%,0)","v":138159},138159,null,{"$f":"IFERROR(AC34-AC34*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD34-AD34*10%,0)","v":154800},130500,117841.49999999999,117841.49999999999]
[null,null,null,null,null,null,null,null,"NOVOMOSKOVSK",851,25000,20000,17000,15172.5,15172.5,"SOVTRANS",null,"NOVOMOSKOVSK",851,9999999,18000,9999999,12138,12138,"SOVTRANS",null,"NOVOMOSKOVSK",851,9999999,16000,12000,10353,10353,"SOVTRANS",null,{"$f":"IFERROR(L35-L35*15%,0)","v":17000},{"$f":"IFERROR(M35-M35*15%,0)","v":14450},12896.625,12896.625,12896.625,null,{"$f":"IFERROR(T35-T35*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U35-U35*15%,0)","v":15300},8499999.1500000004,10317.299999999999,10317.299999999999,null,{"$f":"IFERROR(AC35-AC35*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD35-AD35*15%,0)","v":13600},10200,8800.0499999999993,8800.0499999999993]
[null,null,null,null,null,null,null,null,"NOVOPOLOCK. BY",659,50000,39000,9999999,9999999,39000,"DACHSER",null,"NOVOPOLOCK. BY",659,9999999,35000,9999999,9999999,35000,"DACHSER",null,"NOVOPOLOCK. BY",659,9999999,33000,9999999,9999999,33000,"DACHSER",null,{"$f":"IFERROR(L36-L36*10%,0)","v":35100},{"$f":"IFERROR(M36-M36*10%,0)","v":8999999.0999999996},8999999.0999999996,35100,35100,null,8999999.0999999996,{"$f":"IFERROR(U36-U36*10%,0)","v":31500},{"$f":"IFERROR(V36-V36*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(W36-W36*10%,0)","v":8999999.0999999996},31500,null,{"$f":"IFERROR(AC36-AC36*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD36-AD36*10%,0)","v":29700},8999999.0999999996,8999999.0999999996,29700]
[null,null,null,null,null,null,null,null,"NOVOSHAHTINSK",981,60000,60000,58000,52657.5,{"$f":"MIN(K37:N37)","v":52657.5},"SOVTRANS",null,"NOVOSHAHTINSK",981,9999999,50000,9999999,42126,{"$f":"MIN(T37:W37)","v":42126},"SOVTRANS",null,"NOVOSHAHTINSK",981,9999999,46000,9999999,35931,{"$f":"MIN(AC37:AF37)","v":35931},"SOVTRANS",null,{"$f":"IFERROR(L37-L37*10%,0)","v":54000},52200,47391.75,47391.75,47391.75,null,8999999.0999999996,45000,8999999.0999999996,37913.4,37913.4,null,{"$f":"IFERROR(AC37-AC37*10%,0)","v":8999999.0999999996},41400,8999999.0999999996,32337.9,32337.9]
[null,null,null,null,null,null,null,null,"OMSK",2803,175000,154000,110000,138337.5,110000,"ASSTRA",null,"OMSK",2803,9999999,133000,9999999,110670,110670,"SOVTRANS",null,"OMSK",2803,9999999,110000,9999999,94395,94395,"SOVTRANS",null,{"$f":"IFERROR(L38-L38*10%,0)","v":138600},99000,124503.75,99000,99000,null,{"$f":"IFERROR(T38-T38*10%,0)","v":8999999.0999999996},119700,8999999.0999999996,99603,99603,null,{"$f":"IFERROR(AC38-AC38*10%,0)","v":8999999.0999999996},99000,8999999.0999999996,84955.5,84955.5]
[null,null,null,null,null,null,null,null,"ORENBURG",1463,95000,85000,75000,80325,75000,"ASSTRA",null,"ORENBURG",1463,9999999,70000,9999999,64260,64260,"SOVTRANS",null,"ORENBURG",1463,9999999,64000,9999999,54810,54810,"SOVTRANS",null,{"$f":"IFERROR(L39-L39*10%,0)","v":76500},{"$f":"IFERROR(M39-M39*10%,0)","v":67500},72292.5,67500,67500,null,8999999.0999999996,{"$f":"IFERROR(U39-U39*10%,0)","v":63000},{"$f":"IFERROR(V39-V39*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(W39-W39*10%,0)","v":57834},57834,null,{"$f":"IFERROR(AC39-AC39*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD39-AD39*10%,0)","v":57600},8999999.0999999996,49329,49329]
[null,null,null,null,null,null,null,null,"ORSK",1753,110000,97000,80000,89250,80000,"ASSTRA",null,"ORSK",1753,9999999,82000,9999999,71400,71400,"SOVTRANS",null,"ORSK",1753,9999999,75000,9999999,60899.999999999993,60899.999999999993,"SOVTRANS",null,{"$f":"IFERROR(L40-L40*10%,0)","v":87300},72000,80325,72000,72000,null,8999999.0999999996,73800,8999999.0999999996,64260,64260,null,{"$f":"IFERROR(AC40-AC40*10%,0)","v":8999999.0999999996},67500,8999999.0999999996,54809.999999999993,54809.999999999993]
[null,null,null,null,null,null,null,null,"PAVLODAR",3225,230000,210000,9999999,9999999,210000,"DACHSER",null,"PAVLODAR",3225,9999999,190000,9999999,9999999,190000,"DACHSER",null,"PAVLODAR",3225,9999999,177000,9999999,9999999,177000,"DACHSER",null,189000,8999999.0999999996,8999999.0999999996,189000,189000,null,8999999.0999999996,171000,8999999.0999999996,8999999.0999999996,171000,null,8999999.0999999996,159300,8999999.0999999996,8999999.0999999996,159300]
[null,null,null,null,null,null,null,null,"PERM",1544,90000,80000,75000,77647.5,75000,"ASSTRA",null,"PERM",1544,9999999,65000,9999999,62118,62118,"SOVTRANS",null,"PERM",1544,9999999,55000,9999999,52983,52983,"SOVTRANS",null,{"$f":"IFERROR(L42-L42*15%,0)","v":68000},{"$f":"IFERROR(M42-M42*15%,0)","v":63750},66000.375,63750,63750,null,{"$f":"IFERROR(T42-T42*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U42-U42*15%,0)","v":55250},8499999.1500000004,52800.3,52800.3,null,{"$f":"IFERROR(AC42-AC42*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD42-AD42*15%,0)","v":46750},8499999.1500000004,45035.55,45035.55]
[null,null,null,null,null,null,null,null,"PODOLSK",68,15000,17000,18000,12495,12495,"SOVTRANS",null,"PODOLSK",68,9999999,14000,9999999,9996,9996,"SOVTRANS",null,"PODOLSK",68,9999999,12000,12000,8526,8526,"SOVTRANS",null,{"$f":"IFERROR(L43-L43*15%,0)","v":14450},15300,10620.75,10620.75,10620.75,null,{"$f":"IFERROR(T43-T43*15%,0)","v":8499999.1500000004},11900,8499999.1500000004,8496.6,8496.6,null,{"$f":"IFERROR(AC43-AC43*15%,0)","v":8499999.1500000004},10200,10200,7247.1,7247.1]
[null,null,null,null,null,null,null,null,"ROSTOV-NA-DONU",1034,70000,60000,55000,53550,53550,"SOVTRANS",null,"ROSTOV-NA-DONU",1034,9999999,49000,9999999,42840,42840,"SOVTRANS",null,"ROSTOV-NA-DONU",1034,9999999,45000,47000,36540,36540,"SOVTRANS",null,{"$f":"IFERROR(L44-L44*10%,0)","v":54000},{"$f":"IFERROR(M44-M44*10%,0)","v":49500},48195,48195,48195,null,8999999.0999999996,{"$f":"IFERROR(U44-U44*10%,0)","v":44100},{"$f":"IFERROR(V44-V44*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(W44-W44*10%,0)","v":38556},38556,null,{"$f":"IFERROR(AC44-AC44*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD44-AD44*10%,0)","v":40500},42300,32886,32886]
[null,null,null,null,null,null,null,null,"RYAZAN",233,18000,19000,17000,16065,16065,"SOVTRANS",null,"RYAZAN",233,9999999,17000,9999999,12852,12852,"SOVTRANS",null,"RYAZAN",233,9999999,14000,13000,10962,10962,"SOVTRANS",null,{"$f":"IFERROR(L45-L45*10%,0)","v":17100},15300,14458.5,14458.5,14458.5,null,8999999.0999999996,15300,8999999.0999999996,11566.8,11566.8,null,{"$f":"IFERROR(AC45-AC45*10%,0)","v":8999999.0999999996},12600,11700,9865.7999999999993,9865.7999999999993]
[null,null,null,null,null,null,null,null,"SALAVAT, BEL",1654,80000,85000,9999999,9999999,80000,"AGILITY",null,"SALAVAT, BEL",1654,9999999,75000,9999999,9999999,75000,"DACHSER",null,"SALAVAT, BEL",1654,9999999,70000,9999999,9999999,70000,"DACHSER",null,76500,8999999.0999999996,8999999.0999999996,72000,72000,null,8999999.0999999996,67500,8999999.0999999996,8999999.0999999996,67500,null,8999999.0999999996,63000,8999999.0999999996,8999999.0999999996,63000]
[null,null,null,null,null,null,null,null,"SAMARA",1054,60000,60000,45000,53550,45000,"ASSTRA",null,"SAMARA",1054,9999999,48000,9999999,42840,42840,"SOVTRANS",null,"SAMARA",1054,9999999,43000,35000,36540,35000,"ASSTRA",null,54000,40500,48195,40500,40500,null,8999999.0999999996,43200,8999999.0999999996,38556,38556,null,8999999.0999999996,38700,31500,32886,31500]
[null,null,null,null,null,null,null,null,"SANKT-PETERBURG",810,45000,32000,29000,33915,29000,"ASSTRA",null,"SANKT-PETERBURG",810,9999999,28000,9999999,27132,27132,"SOVTRANS",null,"SANKT-PETERBURG",810,9999999,26000,25000,23142,23142,"SOVTRANS",null,{"$f":"IFERROR(L48-L48*15%,0)","v":27200},{"$f":"IFERROR(M48-M48*15%,0)","v":24650},28827.75,24650,24650,null,{"$f":"IFERROR(T48-T48*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U48-U48*15%,0)","v":23800},8499999.1500000004,23062.2,23062.2,null,{"$f":"IFERROR(AC48-AC48*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD48-AD48*15%,0)","v":22100},21250,19670.7,19670.7]
[null,null,null,null,null,null,null,null,"SARATOV",795,50000,50000,42000,45517.5,42000,"ASSTRA",null,"SARATOV",795,9999999,41000,9999999,36414,36414,"SOVTRANS",null,"SARATOV",795,9999999,38000,9999999,31058.999999999996,31058.999999999996,"SOVTRANS",null,{"$f":"IFERROR(L49-L49*10%,0)","v":45000},{"$f":"IFERROR(M49-M49*10%,0)","v":37800},40965.75,37800,37800,null,8999999.0999999996,{"$f":"IFERROR(U49-U49*10%,0)","v":36900},{"$f":"IFERROR(V49-V49*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(W49-W49*10%,0)","v":32772.6},32772.6,null,{"$f":"IFERROR(AC49-AC49*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD49-AD49*10%,0)","v":34200},8999999.0999999996,27953.1,27953.1]
[null,null,null,null,null,null,null,null,"SALAVAT",1500,100000,9999999,75000,75862.5,75000,"ASSTRA",null,"SALAVAT",1500,9999999,9999999,9999999,60690,60690,"SOVTRANS",null,"SALAVAT",1500,9999999,9999999,9999999,51765,51765,"SOVTRANS",null,{"$f":"IFERROR(L50-L50*10%,0)","v":8999999.0999999996},67500,68276.25,67500,67500,null,8999999.0999999996,8999999.0999999996,8999999.0999999996,54621,54621,null,{"$f":"IFERROR(AC50-AC50*10%,0)","v":8999999.0999999996},8999999.0999999996,8999999.0999999996,46588.5,46588.5]
[null,null,null,null,null,null,null,null,"SYZRAN",898,60000,59000,46000,53550,46000,"ASSTRA",null,"SYZRAN",898,9999999,45000,9999999,42840,42840,"SOVTRANS",null,"SYZRAN",898,9999999,40000,9999999,36540,36540,"SOVTRANS",null,53100,41400,48195,41400,41400,null,8999999.0999999996,40500,8999999.0999999996,38556,38556,null,8999999.0999999996,36000,8999999.0999999996,32886,32886]
[null,null,null,null,null,null,null,null,"TAGANROG",1100,65000,65000,58000,58012.5,58000,"ASSTRA",null,"TAGANROG",1100,9999999,52000,9999999,46410,46410,"SOVTRANS",null,"TAGANROG",1100,9999999,48000,9999999,39585,39585,"SOVTRANS",null,58500,52200,52211.25,52200,52200,null,8999999.0999999996,46800,8999999.0999999996,41769,41769,null,8999999.0999999996,43200,8999999.0999999996,35626.5,35626.5]
[null,null,null,null,null,null,null,null,"TATARSTAN",1262,95000,58000,38000,9999999,38000,"ASSTRA",null,"TATARSTAN",1262,9999999,50000,9999999,9999999,50000,"DACHSER",null,"TATARSTAN",1262,9999999,46000,30000,9999999,30000,"ASSTRA",null,52200,34200,8999999.0999999996,34200,34200,null,8999999.0999999996,45000,8999999.0999999996,8999999.0999999996,45000,null,8999999.0999999996,41400,27000,8999999.0999999996,27000]
[null,null,null,null,null,null,null,null,"TULA",92,18000,18000,17000,14280,14280,"SOVTRANS",null,"TULA",92,9999999,15000,9999999,11424,11424,"SOVTRANS",null,"TULA",92,9999999,14000,12000,9744,9744,"SOVTRANS",null,{"$f":"IFERROR(L54-L54*15%,0)","v":15300},{"$f":"IFERROR(M54-M54*15%,0)","v":14450},12138,12138,12138,null,{"$f":"IFERROR(T54-T54*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U54-U54*15%,0)","v":12750},8499999.1500000004,9710.4,9710.4,null,{"$f":"IFERROR(AC54-AC54*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD54-AD54*15%,0)","v":11900},10200,8282.4,8282.4]
[null,null,null,null,null,null,null,null,"TUMEN",2209,150000,128000,98000,113347.5,98000,"ASSTRA",null,"TUMEN",2209,9999999,110000,9999999,90678,90678,"SOVTRANS",null,"TUMEN",2209,9999999,90000,9999999,77343,77343,"SOVTRANS",null,{"$f":"IFERROR(L55-L55*10%,0)","v":115200},{"$f":"IFERROR(M55-M55*10%,0)","v":88200},102012.75,88200,88200,null,8999999.0999999996,{"$f":"IFERROR(U55-U55*10%,0)","v":99000},{"$f":"IFERROR(V55-V55*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(W55-W55*10%,0)","v":81610.2},81610.2,null,{"$f":"IFERROR(AC55-AC55*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD55-AD55*10%,0)","v":81000},8999999.0999999996,69608.7,69608.7]
[null,null,null,null,null,null,null,null,"ULYANOVSK",880,60000,55000,40000,50872.5,40000,"ASSTRA",null,"ULYANOVSK",880,9999999,42000,9999999,40698,40698,"SOVTRANS",null,"ULYANOVSK",880,9999999,39000,9999999,34713,34713,"SOVTRANS",null,{"$f":"IFERROR(L56-L56*10%,0)","v":49500},36000,45785.25,36000,36000,null,8999999.0999999996,37800,8999999.0999999996,36628.199999999997,36628.199999999997,null,{"$f":"IFERROR(AC56-AC56*10%,0)","v":8999999.0999999996},35100,8999999.0999999996,31241.7,31241.7]
[null,null,null,null,null,null,null,null,"UST-KUT (IRKUTSK)",5269,330000,290000,250000,254362.5,250000,"ASSTRA",null,"UST-KUT (IRKUTSK)",5269,9999999,262000,9999999,222768,222768,"SOVTRANS",null,"UST-KUT (IRKUTSK)",5269,9999999,250000,9999999,190008,190008,"SOVTRANS",null,261000,225000,228926.25,225000,225000,null,8999999.0999999996,235800,8999999.0999999996,200491.2,200491.2,null,8999999.0999999996,225000,8999999.0999999996,171007.2,171007.2]
[null,null,null,null,null,null,null,null,"VELIKI NOVGOROD",682,38000,32000,27000,28560,27000,"ASSTRA",null,"VELIKI NOVGOROD",682,9999999,29000,9999999,22848,22848,"SOVTRANS",null,"VELIKI NOVGOROD",682,9999999,27000,23000,19488,19488,"SOVTRANS",null,{"$f":"IFERROR(L58-L58*15%,0)","v":27200},{"$f":"IFERROR(M58-M58*15%,0)","v":22950},24276,22950,22950,null,{"$f":"IFERROR(T58-T58*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U58-U58*15%,0)","v":24650},8499999.1500000004,19420.8,19420.8,null,{"$f":"IFERROR(AC58-AC58*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD58-AD58*15%,0)","v":22950},19550,16564.8,16564.8]
[null,null,null,null,null,null,null,null,"VOLGOGRAD",928,60000,55000,44000,44625,44000,"ASSTRA",null,"VOLGOGRAD",928,9999999,46000,9999999,35700,35700,"SOVTRANS",null,"VOLGOGRAD",928,9999999,42000,35000,30449.999999999996,30449.999999999996,"SOVTRANS",null,{"$f":"IFERROR(L59-L59*10%,0)","v":49500},{"$f":"IFERROR(M59-M59*10%,0)","v":39600},40162.5,39600,39600,null,8999999.0999999996,{"$f":"IFERROR(U59-U59*10%,0)","v":41400},{"$f":"IFERROR(V59-V59*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(W59-W59*10%,0)","v":32130},32130,null,{"$f":"IFERROR(AC59-AC59*10%,0)","v":8999999.0999999996},{"$f":"IFERROR(AD59-AD59*10%,0)","v":37800},31500,27404.999999999996,27404.999999999996]
[null,null,null,null,null,null,null,null,"VORONEZH",482,30000,32000,25000,23205,23205,"SOVTRANS",null,"VORONEZH",482,9999999,26000,9999999,18564,18564,"SOVTRANS",null,"VORONEZH",482,9999999,23000,19000,15833.999999999998,15833.999999999998,"SOVTRANS",null,{"$f":"IFERROR(L60-L60*10%,0)","v":28800},22500,20884.5,20884.5,20884.5,null,8999999.0999999996,23400,8999999.0999999996,16707.599999999999,16707.599999999999,null,{"$f":"IFERROR(AC60-AC60*10%,0)","v":8999999.0999999996},20700,17100,14250.599999999999,14250.599999999999]
[null,null,null,null,null,null,null,null,"YAROSLAVL",375,28000,23000,17000,20527.5,17000,null,null,"YAROSLAVL",375,9999999,20000,9999999,16422,16422,null,null,"YAROSLAVL",375,9999999,18000,12000,14006.999999999998,12000,null,null,{"$f":"IFERROR(L61-L61*15%,0)","v":19550},{"$f":"IFERROR(M61-M61*15%,0)","v":14450},17448.375,14450,14450,null,{"$f":"IFERROR(T61-T61*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(U61-U61*15%,0)","v":17000},8499999.1500000004,13958.7,13958.7,null,{"$f":"IFERROR(AC61-AC61*15%,0)","v":8499999.1500000004},{"$f":"IFERROR(AD61-AD61*15%,0)","v":15300},10200,11905.949999999999,10200]
[null,null,null,null,null,null,null,null,"Авто 10т",null,null,null,null,null,null,null,null,"Авто 5т",null,null,null,null,null,null,null,null,"Авто 3т"]