{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Индия","Китай","Лист1","Доп","AIR from China"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Индия","index":0,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[9,1,9,7],[19,1,19,7],[8,1,8,7],[23,1,23,7],[21,1,21,7],[12,1,12,7],[10,1,10,7],[11,1,11,7],[27,1,27,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[34,1,34,2],[33,1,33,2],[25,1,25,3],[13,1,13,7],[14,1,14,7],[15,1,15,7],[16,1,16,7],[17,1,17,7],[18,1,18,7],[20,1,20,7],[35,1,35,2],[36,1,36,2]]}
[]
[]
[]
[]
[]
[null,"Индия"]
[]
[null,"Наименование",null,null,null,null,null,null,"Кол-во штук","Расчетный вес","Загруженность"]
[null,"20*STD","20*STD","20*STD","20*STD","20*STD","20*STD","20*STD",null,{"$f":"I9*3000","v":0},{"$f":"J23/3000*100%","v":1.260278}]
[null,"40*std","40*std","40*std","40*std","40*std","40*std","40*std",0,{"$f":"I10*Лист1!C4","v":0},{"$f":"J23/7000*100%","v":0.54011914285714291}]
[null,"Диск МКС внутренний 316L б /MKS Inner disk 316L 10007926","Диск МКС внутренний 316L б /MKS Inner disk 316L 10007926","Диск МКС внутренний 316L б /MKS Inner disk 316L 10007926","Диск МКС внутренний 316L б /MKS Inner disk 316L 10007926","Диск МКС внутренний 316L б /MKS Inner disk 316L 10007926","Диск МКС внутренний 316L б /MKS Inner disk 316L 10007926","Диск МКС внутренний 316L б /MKS Inner disk 316L 10007926",5600,{"$f":"I11*0.675","v":3780.0000000000005}]
[null,"Диск МКС нижний 316L а/MKS Bottom disk 316L 12 отверстий","Диск МКС нижний 316L а/MKS Bottom disk 316L 12 отверстий","Диск МКС нижний 316L а/MKS Bottom disk 316L 12 отверстий","Диск МКС нижний 316L а/MKS Bottom disk 316L 12 отверстий","Диск МКС нижний 316L а/MKS Bottom disk 316L 12 отверстий","Диск МКС нижний 316L а/MKS Bottom disk 316L 12 отверстий","Диск МКС нижний 316L а/MKS Bottom disk 316L 12 отверстий",null,{"$f":"I12*0.675","v":0}]
[null,"Диск МКС средний 316L/MKS Intermediate disk 316L 6 отверстий 10007928","Диск МКС средний 316L/MKS Intermediate disk 316L 6 отверстий 10007928","Диск МКС средний 316L/MKS Intermediate disk 316L 6 отверстий 10007928","Диск МКС средний 316L/MKS Intermediate disk 316L 6 отверстий 10007928","Диск МКС средний 316L/MKS Intermediate disk 316L 6 отверстий 10007928","Диск МКС средний 316L/MKS Intermediate disk 316L 6 отверстий 10007928","Диск МКС средний 316L/MKS Intermediate disk 316L 6 отверстий 10007928",null,{"$f":"I13*0.675","v":0}]
[null,"Зажим односторонний 16-25; ","Зажим односторонний 16-25; ","Зажим односторонний 16-25; ","Зажим односторонний 16-25; ","Зажим односторонний 16-25; ","Зажим односторонний 16-25; ","Зажим односторонний 16-25; ",null,{"$f":"I14*0.9","v":0}]
[null,"Зажим односторонний 6-15; ","Зажим односторонний 6-15; ","Зажим односторонний 6-15; ","Зажим односторонний 6-15; ","Зажим односторонний 6-15; ","Зажим односторонний 6-15; ","Зажим односторонний 6-15; ",null,{"$f":"I15*0.9","v":0}]
[null,"Клапан Snapin тип 1 L10,5; ","Клапан Snapin тип 1 L10,5; ","Клапан Snapin тип 1 L10,5; ","Клапан Snapin тип 1 L10,5; ","Клапан Snapin тип 1 L10,5; ","Клапан Snapin тип 1 L10,5; ","Клапан Snapin тип 1 L10,5; ",null,{"$f":"I16*0.55","v":0}]
[null,"Клапан подвиж. BDH 14LL12,7 s2; ","Клапан подвиж. BDH 14LL12,7 s2; ","Клапан подвиж. BDH 14LL12,7 s2; ","Клапан подвиж. BDH 14LL12,7 s2; ","Клапан подвиж. BDH 14LL12,7 s2; ","Клапан подвиж. BDH 14LL12,7 s2; ","Клапан подвиж. BDH 14LL12,7 s2; ",null,{"$f":"I17*0.55","v":0}]
[null,"Клапан подвиж. BDH 16LL12,7 s1.5; ","Клапан подвиж. BDH 16LL12,7 s1.5; ","Клапан подвиж. BDH 16LL12,7 s1.5; ","Клапан подвиж. BDH 16LL12,7 s1.5; ","Клапан подвиж. BDH 16LL12,7 s1.5; ","Клапан подвиж. BDH 16LL12,7 s1.5; ","Клапан подвиж. BDH 16LL12,7 s1.5; ",null,{"$f":"I18*0.55","v":0}]
[null,"Пластина крепеж. выпукл. 47х27х2; ","Пластина крепеж. выпукл. 47х27х2; ","Пластина крепеж. выпукл. 47х27х2; ","Пластина крепеж. выпукл. 47х27х2; ","Пластина крепеж. выпукл. 47х27х2; ","Пластина крепеж. выпукл. 47х27х2; ","Пластина крепеж. выпукл. 47х27х2; ",null,{"$f":"I19*0.03","v":0}]
[null,"Шайба выпуклая 11/32х2;","Шайба выпуклая 11/32х2;","Шайба выпуклая 11/32х2;","Шайба выпуклая 11/32х2;","Шайба выпуклая 11/32х2;","Шайба выпуклая 11/32х2;","Шайба выпуклая 11/32х2;",null,{"$f":"I20*0.04","v":0}]
[null,"Шпилька приварная М10х20; ","Шпилька приварная М10х20; ","Шпилька приварная М10х20; ","Шпилька приварная М10х20; ","Шпилька приварная М10х20; ","Шпилька приварная М10х20; ","Шпилька приварная М10х20; ",null,{"$f":"I21*0.01","v":0}]
[null,"Шпилька резьб М10х50 уплощен 1; ","Шпилька резьб М10х50 уплощен 1; ","Шпилька резьб М10х50 уплощен 1; ","Шпилька резьб М10х50 уплощен 1; ","Шпилька резьб М10х50 уплощен 1; ","Шпилька резьб М10х50 уплощен 1; ","Шпилька резьб М10х50 уплощен 1; ",556,{"$f":"I22*0.0015","v":0.83399999999999996}]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J9:J22)","v":3780.8340000000003}]
[]
[null,"Условия поставки"]
[null,"EXW Pune,India"]
[]
[null,"Расчет ниже"]
[]
[null,"Категория",null,"EXPRESS"]
[null,"Фрахт"]
[null,"Customs servise"]
[null,"Termilnal"]
[null,"Local to Serpukhov"]
[null,"DEPARTURE AIRPORT COSTS"]
[null,"Delivery time"]
[null,"Total, USD"]

{"sheet":"Китай","index":1,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[13,1,13,7],[8,1,8,7],[9,1,9,7],[10,1,10,7],[11,1,11,7],[12,1,12,7],[14,1,14,7],[16,1,16,3],[18,1,18,2],[20,1,20,2],[20,3,20,4],[20,5,20,6],[21,1,21,2],[21,3,21,4],[21,5,21,6],[22,1,22,2],[22,3,22,4],[22,5,22,6],[26,5,26,6],[23,1,23,2],[23,3,23,4],[23,5,23,6],[24,1,24,2],[24,3,24,4],[24,5,24,6],[27,9,27,10],[27,1,27,2],[27,3,27,4],[27,5,27,6],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[25,1,25,2],[25,3,25,4],[25,5,25,6],[26,1,26,2],[26,3,26,4]]}
[]
[]
[]
[]
[]
[null,"Китай"]
[]
[null,"Наименование",null,null,null,null,null,null,"Кол-во штук","Расчетный вес"]
[null,"Клапан UFM"]
[null,"RING"]
[null,"Прокат"]
[null,"RING"]
[null,"Воротники"]
[null,"40*std rail"]
[]
[null,"Условия поставки"]
[null,"FOB"]
[]
[null,"Расчет ниже"]
[]
[null,"Категория",null,"AIR",null,"Sea LCL",null,"Sea 20*std","Sea 40*std","Rail LCL",null,"Rail 20*std","Rail 40*std"]
[null,"Фрахт"]
[null,"Customs servise"]
[null,"Termilnal"]
[null,"Local to Serpukhov"]
[null,"Additional cost"]
[null,"Delivery time"]
[null,"Total, USD"]

{"sheet":"Лист1","index":2,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Наименование",null,null,null,null,null,"FCA Mumbai,India"]
[null,"20*STD",3000,{"$f":"LOOKUP(Индия!B11:H22,)","v":{"$error":"#VALUE!"}},null,null,null,"FOB Nhava Sheva,India"]
[null,"40*std",7000,{"$f":"LOOKUP(Индия!B10:H23,B4:B17,C4:C17)","v":{"$error":"#VALUE!"}},null,null,null,"EXW Pune,India"]
[null,"Диск МКС внутренний 316L б /MKS Inner disk 316L 10007926",0.68500000000000005,{"$f":"LOOKUP(Индия!B11:H24,B5:B18,C5:C18)","v":{"$error":"#VALUE!"}}]
[null,"Диск МКС нижний 316L а/MKS Bottom disk 316L 12 отверстий",0.67500000000000004,null,null,null,null,"FOB"]
[null,"Диск МКС средний 316L/MKS Intermediate disk 316L 6 отверстий 10007928",0.24,{"$f":"LOOKUP(Индия!B13:H26,B7:B20,C7:C20)","v":{"$error":"#VALUE!"}},null,null,null,"FCA"]
[null,"Зажим односторонний 16-25; ",0.09,{"$f":"LOOKUP(Индия!B22:H27,B8:B21,C8:C21)","v":{"$error":"#VALUE!"}},null,null,null,"EXW"]
[null,"Зажим односторонний 6-15; ",0.06,{"$f":"LOOKUP(Индия!B23:H28,B9:B22,C9:C22)","v":{"$error":"#VALUE!"}}]
[null,"Клапан Snapin тип 1 L10,5; ",5.5E-2,{"$f":"LOOKUP(Индия!B24:H29,B10:B23,C10:C23)","v":{"$error":"#VALUE!"}}]
[null,"Клапан подвиж. BDH 14LL12,7 s2; ",0.04,{"$f":"LOOKUP(Индия!B25:H29,B11:B24,C11:C24)","v":{"$error":"#VALUE!"}}]
[null,"Клапан подвиж. BDH 16LL12,7 s1.5; ",0.04,{"$f":"LOOKUP(Индия!B26:H29,B12:B25,C12:C25)","v":{"$error":"#VALUE!"}}]
[null,"Пластина крепеж. выпукл. 47х27х2; ",0.03,{"$f":"LOOKUP(Индия!B27:H29,B13:B26,C13:C26)","v":{"$error":"#VALUE!"}}]
[null,"Шайба выпуклая 11/32х2;",0.02,{"$f":"LOOKUP(Индия!B28:H29,B14:B27,C14:C27)","v":{"$error":"#VALUE!"}}]
[null,"Шпилька приварная М10х20; ",0.01,{"$f":"LOOKUP(Индия!B29:H29,B15:B28,C15:C28)","v":{"$error":"#N/A"}}]
[null,"Шпилька резьб М10х50 уплощен 1; ",1.5E-3,{"$f":"LOOKUP(Доп!B1:H6,B16:B29,C16:C29)","v":{"$error":"#VALUE!"}}]
[]
[null,"20*std sea",3000,{"$f":"LOOKUP(Китай!B9:H14,Лист1!B18:B25,Лист1!C18:C25)","v":{"$error":"#VALUE!"}}]
[null,"40*std rail",7000]
[null,"40*std sea",7000]
[null,"RING",1]
[null,"Воротники",2]
[null,"Клапан UFM",3]
[null,"Прокат",4]
[null,"Сетка",5]

{"sheet":"Доп","index":3,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":true,"merged":[[6,1,6,2],[6,3,6,4],[6,5,6,6],[7,1,7,2],[7,3,7,4],[7,5,7,6],[4,1,4,2],[4,3,4,4],[4,5,4,6],[5,1,5,2],[5,3,5,4],[5,5,5,6],[2,1,2,2],[2,3,2,4],[2,5,2,6],[3,1,3,2],[3,3,3,4],[3,5,3,6],[0,1,0,2],[0,3,0,4],[0,5,0,6],[1,1,1,2],[1,3,1,4],[1,5,1,6]]}
[null,"Категория",null,"AIR",null,"Sea LCL",null,"Sea 20*std","Sea 40*std","EXPRESS"]
[null,"Фрахт",null,{"$f":"'AIR from China'!$C$19","v":14367.1692},null,{"$f":"Индия!$J$23*350/1000","v":1323.2919000000002},null,1750,2000]
[null,"Customs servise",null,250,null,350,null,350,350]
[null,"Termilnal",null,{"$f":"'AIR from China'!C27","v":2067.64359375}]
[null,"Local to Serpukhov",null,250,null,456,null,620,916]
[null,"DEPARTURE AIRPORT COSTS",null,120]
[null,"Delivery time",null,"1 week",null,"9 week",null,"8 week","8 week"]
[null,"Total, USD",null,{"$f":"SUM(D2:E7)","v":17054.812793749999},null,{"$f":"SUM(F2:G7)","v":2129.2919000000002},null,{"$f":"SUM(H2:H7)","v":2720},{"$f":"SUM(I2:I7)","v":3266}]

{"sheet":"AIR from China","index":4,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":true,"merged":[[9,26,9,30],[0,0,0,5],[2,26,4,30],[5,26,5,30],[6,26,6,30],[8,26,8,30],[10,26,10,30],[12,0,12,1],[12,2,12,3],[14,0,14,1],[14,2,14,3],[14,4,14,5],[15,16,16,16],[15,17,16,17],[15,18,16,18],[15,19,16,19],[10,0,10,4],[19,0,19,4],[16,0,16,1],[16,2,16,3],[17,14,18,14],[17,15,18,15],[15,14,16,14],[15,15,16,15],[17,18,18,18],[17,19,18,19],[18,0,18,1],[18,2,18,3],[18,4,18,5],[17,16,18,16],[17,17,18,17],[20,0,20,1],[20,2,20,3],[21,0,21,4],[22,0,22,1],[22,2,22,3],[22,4,22,5],[23,0,23,4],[24,0,24,1],[24,2,24,3],[25,0,25,4],[26,0,26,1],[26,2,26,3],[27,0,27,5],[28,0,28,1],[28,2,28,3],[29,0,29,5],[30,0,30,1],[30,2,30,3]]}
["Please choose the correct coditions for transportation and fill in the green cell:"]
[]
["Crate lenght, cm","Crate width, cm","Crate height, cm","Gross weight, kg","Volume weight, kg","Estimated weight, kg"]
[null,null,null,{"$f":"Индия!J23","v":3780.8340000000003},{"$f":"A4*B4*C4/6000","v":0},{"$f":"IF(E4>D4,E4,D4)","v":3780.8340000000003}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL ESTIMATED WEIGHT, kg :",null,null,null,null,{"$f":"F4+F5+F6+F7+F8+F9+F10","v":3780.8340000000003}]
[]
["FROM",null,null,null,null,null,null,null,"FCA Mumbai, India"]
[null,null,null,null,null,null,null,null,1]
["DELIVERY PLACE",null,null,null,null,null,null,null,"Serpukhov"]
[null,null,null,null,null,null,null,null,"Other",null,null,null,null,null," +45kgs","+100kgs","+300kgs","+500kgs","+1000kgs",2000]
["AIRPORT ARRIVAL",null,null,null,null,null,null,null,1,null,null,1]
[null,null,null,null,null,null,null,null,"DME",11500,null,null,null,null,6.4,5.9,5.4,4.7,3.8,3.8]
[" AIR FREIGHT COST",null,{"$f":"O30","v":14367.1692},null,null,null,null,null,null,14000]
[null,null,null,null,null,null,null,null,7000,7000]
["DEPARTURE AIRPORT COSTS",null,120,null,null,null,null,null,1]
[]
["LOCAL TRANSPORTATION ",null,{"$f":"IF(I17=1,I20,0)/B33","v":109.375},null,{"$f":"IF(I17=2,\"Сontact log.dep\",\"\")","v":""}]
[]
["CUSTOMS SERVICE COST",null,{"$f":"IF(I21=1,J18,J19)/B33","v":179.6875}]
[]
["ARRIVAL AIRPORT COSTS",null,{"$f":"F11*35/B33","v":2067.64359375}]
[]
["DELIVERY TIME, days",null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF(AND('AIR from China'!F11<45,'AIR from China'!F11<=45),'AIR from China'!O18,IF(AND('AIR from China'!F11>45,'AIR from China'!F11<=100),'AIR from China'!O18,IF(AND('AIR from China'!F11>100,'AIR from China'!F11<=300),'AIR from China'!P18,IF(AND('AIR from China'!F11>300,'AIR from China'!F11<=500),'AIR from China'!Q18,IF(AND('AIR from China'!F11>500,'AIR from China'!F11<=1000),'AIR from China'!R18,IF(AND('AIR from China'!F11>1000,'AIR from China'!F11<=2000),'AIR from China'!S18,IF(AND('AIR from China'!F11>2000,'AIR from China'!F11<=3000),'AIR from China'!S18,IF(AND('AIR from China'!F11>3000,'AIR from China'!F11<=4000),'AIR from China'!S18,IF(AND('AIR from China'!F11>4000,'AIR from China'!F11<=30000),'AIR from China'!S18,\"\"))))))))))*F11","v":14367.1692}]
["TOTAL COSTS ",null,{"$f":"O30+C21+C23+C25+C27","v":16843.875293749999}]
[]
["Currency rate $  / RUR ",64]