{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CPR","Manufacturing Steps","Languages"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":1,"defined_names":44,"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":"CPR","index":0,"n_rows":82,"n_cols":31,"rows_kept":82,"cut":false,"hidden":false,"merged":[[55,24,55,26],[2,24,2,26],[9,8,9,10],[13,8,13,10],[16,11,16,12],[30,13,30,14],[16,10,17,10],[16,7,16,8],[30,11,30,12],[29,11,29,12],[11,11,11,12],[20,13,20,14],[16,13,16,15],[16,9,17,9],[17,13,17,14],[21,13,21,14],[22,13,22,14],[9,13,9,14],[44,9,44,10],[43,9,43,10],[55,19,56,19],[16,24,16,26],[17,24,17,25],[29,24,29,25],[4,1,4,5],[13,1,13,3],[9,1,9,3],[7,1,7,3],[5,1,5,5],[11,1,11,3],[16,6,17,6],[11,5,11,6],[13,5,13,6],[16,2,17,2],[16,3,17,3],[28,1,28,3],[40,1,40,3],[16,1,17,1],[42,4,42,6],[44,4,44,6],[43,4,43,6],[16,4,17,4],[44,2,44,3],[43,2,43,3],[151,25,151,26],[142,25,142,26],[143,25,143,26],[144,25,144,26],[145,25,145,26],[146,25,146,26],[147,25,147,26],[15,1,15,3],[41,2,41,3],[16,5,17,5],[45,7,45,8],[45,2,45,3],[41,9,41,10],[45,9,45,10],[77,2,77,3],[47,4,47,6],[47,9,47,10],[47,7,47,8],[46,9,46,10],[47,2,47,3],[45,4,45,6],[45,15,45,16],[43,11,43,14],[141,25,141,26],[134,25,134,26],[135,25,135,26],[136,25,136,26],[148,25,148,26],[149,25,149,26],[150,25,150,26],[78,2,78,3],[130,25,130,26],[131,25,131,26],[57,8,79,10],[73,2,73,3],[77,13,77,18],[59,13,59,18],[68,13,68,18],[137,25,137,26],[138,25,138,26],[139,25,139,26],[140,25,140,26],[69,1,69,3],[81,13,81,20],[81,0,81,9],[71,13,71,15],[75,2,75,3],[76,2,76,3],[72,13,73,14],[74,2,74,3],[75,4,75,5],[76,4,76,5],[77,4,77,5],[72,2,72,3],[132,25,132,26],[133,25,133,26],[78,4,78,5],[73,4,73,5],[74,4,74,5],[74,13,75,14],[66,3,66,5],[70,4,71,5],[72,4,72,5],[70,2,71,3],[46,2,46,3],[46,4,46,6],[52,13,52,18],[46,11,46,14],[47,11,47,14],[46,15,46,16],[55,4,56,4],[54,1,54,3],[55,6,56,6],[47,15,47,16],[47,17,47,18],[46,7,46,8],[55,17,55,18],[55,8,56,10],[70,1,71,1],[58,17,58,18],[58,15,58,16],[48,13,48,18],[54,13,54,15],[50,13,50,18],[55,2,56,2],[55,3,56,3],[55,1,56,1],[32,11,32,12],[36,13,36,18],[41,4,41,6],[41,7,41,8],[42,7,42,8],[41,15,41,16],[42,15,42,16],[41,17,41,18],[55,5,56,5],[42,9,42,10],[44,7,44,8],[43,7,43,8],[44,17,44,18],[43,17,43,18],[35,11,35,12],[42,2,42,3],[70,6,71,6],[45,17,45,18],[42,17,42,18],[42,11,42,14],[44,11,44,14],[41,11,41,14],[55,15,55,16],[32,13,32,14],[29,13,29,14],[31,11,31,12],[34,13,34,14],[45,11,45,14],[38,13,38,18],[46,17,46,18],[44,15,44,16],[43,15,43,16],[35,13,35,14],[33,13,33,14],[33,11,33,12],[34,11,34,12],[67,15,67,16],[63,17,64,18],[67,13,67,14],[66,13,66,14],[63,19,65,19],[67,17,67,18],[63,13,65,14],[63,15,65,16],[66,15,66,16],[62,13,62,15],[55,13,55,14],[58,13,58,14],[2,10,2,12],[7,8,7,10],[7,11,7,12],[2,8,2,9],[11,8,11,10],[28,24,28,26],[40,24,40,26],[41,24,41,25],[2,16,2,17],[2,18,2,19],[16,17,17,17],[16,18,17,18],[16,16,17,16],[24,13,24,18],[26,13,26,18],[19,13,19,14],[16,19,17,19],[18,13,18,14],[31,13,31,14],[23,13,23,14],[7,13,7,14]]}
[]
[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,"Middle in total"]
[null,null,null,null,null,null,null,null,"Language:",null,"English",null,null,null,null,null,"Category:     ",null,"M014 Rolled Rings",null,null,null,null,null,"Header",null,null,null,{"$f":"AVERAGE(AC21,AC34,AC45,AC61,AC75,AC14)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current","Cell","Max."]
[]
[null,"Cost Parameter Request (CPR_Version A6_01.02.2022)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L12=\"\",\"\",AA6)","v":""},"L12",0.5]
[null,null,null,null,null,null,null," "]
[null,{"$f":"Languages!A163","v":"Part No. / Drawing No.: "},null,null,null,null,null,null,{"$f":"Languages!A166","v":"Supplier Name:"},null,null,null,null,{"$f":"IF(L10=\"\",\"\",Languages!A260)","v":""},null,null,{"$f":"Languages!A171","v":"Date:"},null,null,null,null,null,null,null,{"$f":"IF(E12=\"\",\"\",AA8)","v":""},"E12",0.25]
[]
[null,{"$f":"Languages!A164","v":"Part Name:"},null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A167,\" \",\"[\",Languages!A334,\" / \",Languages!A335,\"]\")","v":"Manufacturing Location: [Country / City]"},null,null,null,null,null,null,null,{"$f":"Languages!A170","v":"Supplier Contact:"},null,null,null,null,null,null,null,{"$f":"IF(OR(E14=\"\",F14=\"\"),\"\",AA10)","v":""},"E14+F14",0.1]
[]
[null,{"$f":"Languages!A165","v":"Peak-Volume:"},null,null,null,{"$f":"IF(E14=\"FCA\",Languages!A258,IF(E14=\"\",\"\",Languages!A259))","v":""},null,null,{"$f":"Languages!A168","v":"Production Hours per Year:"},null,null,null,null,null,null,null,{"$f":"Languages!A172","v":"Schaeffler Contact:"},null,null,null,null,null,null,null,{"$f":"IF(OR(L10=\"\",N10=\"\"),\"\",AA12)","v":""},"L10+N10",0.15,null,"Summary Header-Info"]
[]
[null,{"$f":"Languages!A162","v":"Incoterms:"},null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A169,\" [\",Languages!A149,\"]\")","v":"Currency / Quantity Unit in: [pcs]"},null,null,"EUR",1,null,null,null,{"$f":"Languages!A173","v":"Price Reduction Steps:"},null,null,"-3% / -2% / -2%",null,null,null,null,{"$f":"SUM(Y6,Y8,Y10,Y12)","v":0},"∑",{"$f":"+AA6+AA8+AA12+AA10","v":1},null,{"$f":"+Y14","v":0}]
[]
[null,{"$f":"Languages!A3","v":"Material Costs"}]
[null,{"$f":"Languages!$A$4","v":"Pos."},{"$f":"Languages!A5","v":"Material Designation\n[Raw Material / Purchased Parts / \nExternal Processes]"},{"$f":"Languages!A6","v":"Manufacturer / Raw Material Supplier"},{"$f":"Languages!A14","v":"Substance- / Material- / Part-ID"},{"$f":"Languages!A12","v":"Dimension \n[LxWxH, Ø,…]\nin mm"},{"$f":"Languages!A17","v":"Procurement Type"},{"$f":"Languages!A16","v":"Reimbursement"},null,{"$f":"Languages!A11","v":"Net Weight per Part\n[kg]"},{"$f":"Languages!A13","v":"Gross Weight per Part\n[kg]"},{"$f":"Languages!A15","v":"Material Price"},null,{"$f":"Languages!A18","v":"Purchased Parts / External Processes"},null,null,{"$f":"Languages!A19","v":"Material \nOverhead \n[%]"},{"$f":"Languages!A113","v":"Scrap Rate\n[%]"},{"$f":"CONCATENATE(Languages!A114,,\"[\",$L$14,\"]\")","v":"Scrap Cost\n[EUR]"},{"$f":"CONCATENATE(Languages!A20,\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\")","v":"Material Cost\n[EUR/1 pcs]"},null,null,null,null,"Material line"]
[null,null,null,null,null,null,null,"[yes/no]",{"$f":"CONCATENATE(Languages!A26,\" \",Languages!A25)","v":"Pos. \n[e.g.: M1]"},null,null,{"$f":"CONCATENATE(Languages!A8,\"[\",$L$14,\"/\",Languages!A150,\"]\")","v":"[Base]\n[EUR/kg]"},{"$f":"CONCATENATE(Languages!A9,\"[\",$L$14,\"/\",Languages!A150,\"\",\"]\")","v":"[Surcharges]\n[EUR/kg]"},{"$f":"Languages!A10","v":"[Quantity]\n[pcs]"},null,{"$f":"CONCATENATE(\"[\",Languages!A257,\"]\",\" \",\"[\",$L$14,\"/\",Languages!A149,\"]\")","v":"[Price] [EUR/pcs]"},null,null,null,null,null,null,null,null,"No. of min. cells",null,{"$f":"COUNTA(C17,D17,E17,F17,G17,H18,J17,K17,L18,M18,Q17,R17)","v":12}]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((T19-(T19/(100+Q19)*Q19))*(R19/100),0)","v":0},{"$f":"IF(AND(L19<>\"\",P19<>\"\"),Languages!$A$174,IF(AND(H19=\"yes\",I19=\"\"),Languages!$A$174,IF(H19=\"yes\",IF(L19<>\"\",MAX(K19,J19)*L19,N19*P19*(1+VLOOKUP(I19,$B$19:$Q$24,16,FALSE)/100))*(-1),IF(L19<>\"\",K19*L19*(1+Q19/100),N19*P19*(1+Q19/100)))*$M$14))","v":0},null,null,null,null,{"$f":"IF(T19=Languages!$A$174,1,COUNTA(C19:R19))","v":0},null,{"$f":"IF(Y19=0,\"\",IF(Y19/$AA$18>1,1,Y19/$AA$18))","v":""}]
[null,{"$f":"+B19+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((T20-(T20/(100+Q20)*Q20))*(R20/100),0)","v":0},{"$f":"IF(AND(L20<>\"\",P20<>\"\"),Languages!$A$174,IF(AND(H20=\"yes\",I20=\"\"),Languages!$A$174,IF(H20=\"yes\",IF(L20<>\"\",MAX(K20,J20)*L20,N20*P20*(1+VLOOKUP(I20,$B$19:$Q$24,16,FALSE)/100))*(-1),IF(L20<>\"\",K20*L20*(1+Q20/100),N20*P20*(1+Q20/100)))*$M$14))","v":0},null,null,null,null,{"$f":"IF(T20=Languages!$A$174,1,COUNTA(C20:R20))","v":0},null,{"$f":"IF(Y20=0,\"\",IF(Y20/$AA$18>1,1,Y20/$AA$18))","v":""},null,"Middle Material"]
[null,{"$f":"+B20+1","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(L21<>\"\",P21<>\"\"),Languages!$A$174,IF(AND(H21=\"yes\",I21=\"\"),Languages!$A$174,IF(H21=\"yes\",IF(L21<>\"\",MAX(K21,J21)*L21,N21*P21*(1+VLOOKUP(I21,$B$19:$Q$24,16,FALSE)/100))*(-1),IF(L21<>\"\",K21*L21*(1+Q21/100),N21*P21*(1+Q21/100)))*$M$14))","v":0},null,null,null,null,{"$f":"IF(T21=Languages!$A$174,1,COUNTA(C21:R21))","v":0},null,"",null,{"$f":"IF(ISERROR(AVERAGE(AA19:AA24)),0,AVERAGE(AA19:AA24))","v":0}]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(L22<>\"\",P22<>\"\"),Languages!$A$174,IF(AND(H22=\"yes\",I22=\"\"),Languages!$A$174,IF(H22=\"yes\",IF(L22<>\"\",MAX(K22,J22)*L22,N22*P22*(1+VLOOKUP(I22,$B$19:$Q$24,16,FALSE)/100))*(-1),IF(L22<>\"\",K22*L22*(1+Q22/100),N22*P22*(1+Q22/100)))*$M$14))","v":0},null,null,null,null,{"$f":"IF(T22=Languages!$A$174,1,COUNTA(C22:R22))","v":0},null,""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((T23-(T23/(100+Q23)*Q23))*(R23/100),0)","v":0},{"$f":"IF(AND(L23<>\"\",P23<>\"\"),Languages!$A$174,IF(AND(H23=\"yes\",I23=\"\"),Languages!$A$174,IF(H23=\"yes\",IF(L23<>\"\",MAX(K23,J23)*L23,N23*P23*(1+VLOOKUP(I23,$B$19:$Q$24,16,FALSE)/100))*(-1),IF(L23<>\"\",K23*L23*(1+Q23/100),N23*P23*(1+Q23/100)))*$M$14))","v":0},null,null,null,null,{"$f":"IF(T23=Languages!$A$174,1,COUNTA(C23:R23))","v":0},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(H24=\"yes\",IF(AND(K24<>\"\",P24<>\"\"),Languages!$A$174,IF(OR(K24<>0,L24<>0),(K24+L24)*(MAX(I24,J24))+K24/100*(MAX(I24,J24))*Q24,P24*N24+P24*(N24/100)*Q24))*(-1),IF(AND(K24<>\"\",P24<>\"\"),Languages!$A$174,IF(OR(K24<>0,L24<>0),(K24+L24)*J24+K24/100*J24*Q24,P24*N24+P24*(N24/100)*Q24))),Languages!$A$174)*R24/100","v":0},{"$f":"IF(AND(L24<>\"\",P24<>\"\"),Languages!$A$174,IF(AND(H24=\"yes\",I24=\"\"),Languages!$A$174,IF(H24=\"yes\",IF(L24<>\"\",MAX(K24,J24)*L24,N24*P24*(1+VLOOKUP(I24,$B$19:$Q$24,16,FALSE)/100))*(-1),IF(L24<>\"\",K24*L24*(1+Q24/100),N24*P24*(1+Q24/100)))*$M$14))","v":0},null,{"$f":"IF(OR(H24=\"ja\",H24=\"yes\",H24=\"si\"),\"AA\",\"BB\")","v":"BB"},null,null,{"$f":"IF(T24=Languages!$A$174,1,COUNTA(C24:R24))","v":0},null,"",null,null,null,{"$f":"IFERROR((T24-(T24/(100+Q24)*Q24)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A21,\" \",\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\",\":\")","v":"Subtotal Material Costs [EUR/1 pcs]:"},null,null,null,null,null,{"$f":"IF(SUMPRODUCT(--ISTEXT(T19:T24))>0,Languages!$A$174,SUM(T19:T24))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A116,\" \",\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\",\":\")","v":"Subtotal Material Scrap Costs [EUR/1 pcs]:"},null,null,null,null,null,{"$f":"SUM(S19:S24)","v":0}]
[null,null,null,null,null,null,null,null," "]
[null,{"$f":"Languages!A24","v":"Manufacturing Costs"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manufacturing line"]
[null,{"$f":"Languages!A26","v":"Pos."},{"$f":"Languages!A27","v":"Manufacturing Steps\n[Designation] "},{"$f":"Languages!A28","v":"Material*\n[Material \nCost Pos.]\n[e.g.: M1]"},{"$f":"Languages!A29","v":"Equipment \n[Designation]"},{"$f":"Languages!A30","v":"Cycle time \n[sec./Parts per Cycle]"},{"$f":"Languages!A32","v":"Parts per Cycle\n[pcs]"},{"$f":"+Languages!A121","v":"OEE [%]\ninformation only"},{"$f":"CONCATENATE(Languages!A33,\"[\",$L$14,\"]\")","v":"Working System Invest\n[EUR]"},{"$f":"CONCATENATE(Languages!A34,\"[\",$L$14,\"/\",Languages!A151,\"]\")","v":"Working System Hourly Rate   \n[EUR/h]"},{"$f":"CONCATENATE(Languages!A35,\"[\",$L$14,\"]\")","v":"Working System Cost \nper Part\n[EUR]"},{"$f":"CONCATENATE(Languages!A36,\"[\",$L$14,\"/\",Languages!A151,\"]\")","v":"Direct Labor Hourly Rate\n[EUR/h]"},null,{"$f":"Languages!A37","v":"Headcount at Working System \n[%]"},null,{"$f":"CONCATENATE(Languages!A38,\"[\",$L$14,\"]\")","v":"Labor Cost per Part\n[EUR]"},{"$f":"Languages!A41","v":"Residual Manufacturing \nOverhead\n[%]"},{"$f":"Languages!A40","v":"Scrap Rate \n[%]"},{"$f":"CONCATENATE(Languages!A115,\"[\",$L$14,\"]\")","v":"Scrap Cost\n[EUR]"},{"$f":"CONCATENATE(Languages!A42,\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\")","v":"Manufacturing Step Cost\n[EUR/1 pcs]"},null,null,null,null,"No. of min. cells",null,{"$f":"COUNTA(C30,E30:J30,L30,N30,Q30,R30)","v":11}]
[null,1,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J31/(3600/F31*G31),0)","v":0},null,null,null,null,{"$f":"IFERROR((L31*(N31/100)/(3600/F31*G31)),0)","v":0},null,null,{"$f":"IFERROR(T31/$M$14*(R31/100), 0)","v":0},{"$f":"((K31+P31)/100*Q31+(K31+P31))*$M$14","v":0},null,null,null,null,{"$f":"COUNTA(C31:J31,L31:M31,Q31,N31,R31)","v":0},null,{"$f":"IF(Y31=0,\"\",IF(Y31/$AA$30>1,1,Y31/$AA$30))","v":""}]
[null,{"$f":"+B31+1","v":2},null,null,null,null,null,null,null,null,{"$f":"IFERROR(J32/(3600/F32*G32),0)","v":0},null,null,null,null,{"$f":"IFERROR((L32*(N32/100)/(3600/F32*G32)),0)","v":0},null,null,{"$f":"IFERROR(SUM(T$31:T32)/$M$14*(R32/100),0)","v":0},{"$f":"((K32+P32)/100*Q32+(K32+P32))*$M$14","v":0},null,null,null,null,{"$f":"COUNTA(C32:J32,L32:M32,Q32,N32,R32)","v":0},null,{"$f":"IF(Y32=0,\"\",IF(Y32/$AA$30>1,1,Y32/$AA$30))","v":""}]
[null,{"$f":"+B32+1","v":3},null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IFERROR(SUM(T$31:T33)/$M$14*(R33/100),0)","v":0},{"$f":"((K33+P33)/100*Q33+(K33+P33))*$M$14","v":0},null,null,null,null,0,null,"",null,"Middle Manufact."]
[null,4,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J34/(3600/F34*G34),0)","v":0},null,null,null,null,{"$f":"IFERROR((L34*(N34/100)/(3600/F34*G34)),0)","v":0},null,null,{"$f":"IFERROR(SUM(T$31:T34)/$M$14*(R34/100),0)","v":0},{"$f":"((K34+P34)/100*Q34+(K34+P34))*$M$14","v":0},null,null,null,null,0,null,"",null,{"$f":"IF(ISERROR(AVERAGE(AA31:AA36)),0,AVERAGE(AA31:AA36))","v":0}]
[null,5,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J35/(3600/F35*G35),0)","v":0},null,null,null,null,{"$f":"IFERROR((L35*(N35/100)/(3600/F35*G35)),0)","v":0},null,null,{"$f":"IFERROR(SUM(T$31:T35)/$M$14*(R35/100),0)","v":0},{"$f":"((K35+P35)/100*Q35+(K35+P35))*$M$14","v":0},null,null,null,null,0,null,""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"IFERROR(SUM(T$31:T36)/$M$14*(R36/100),0)","v":0},{"$f":"((K36+P36)/100*Q36+(K36+P36))*$M$14","v":0},null,null,null,null,0,null,""]
[null,null,{"$f":"Languages!A45","v":"*)   Assemblies"},null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A44,\" \",\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\",\":\")","v":"Subtotal Manufacturing Costs [EUR/1 pcs]:"},null,null,null,null,null,{"$f":"SUM(T31:T36)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A117,\" \",\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\",\":\")","v":"Subtotal Manufacturing Scrap Costs [EUR/1 pcs]:"},null,null,null,null,null,{"$f":"SUM(S31:S36)*$M$14","v":0}]
[]
[null,{"$f":"Languages!A48","v":"Setup Costs"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Setup line"]
[null,{"$f":"Languages!A49","v":"Pos."},{"$f":"Languages!A50","v":"Manufacturing Steps\n[Designation] "},null,{"$f":"Languages!A52","v":"Manufacturing Lot Size\n[pcs]"},null,null,{"$f":"Languages!A55","v":"Setup Time\n[h]"},null,{"$f":"CONCATENATE(Languages!A57,\"[\",$L$14,\"/\",Languages!A151,\"]\")","v":"Setup Labor Hourly Rate \n[EUR/h]"},null,{"$f":"CONCATENATE(Languages!A59,\"[\",$L$14,\"/\",Languages!A151,\"]\")","v":"Working System Hourly Rate\n[EUR/h]"},null,null,null,{"$f":"CONCATENATE(Languages!A63,\"[\",$L$14,\"]\")","v":"Setup Cost\n[EUR]"},null,{"$f":"Languages!A64","v":"Residual Manufacturing \nOverhead\n[%]"},null,{"$f":"CONCATENATE(Languages!A65,\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\")","v":"Setup Cost\n[EUR/1 pcs]"},null,null,null,null,"No. of min. cells",null,{"$f":"COUNTA(C42:O42,R42)","v":6}]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((J43+L43)*H43)","v":0},null,null,null,{"$f":"IFERROR((((P43/100)*R43+P43)/E43*$M$14),0)","v":0},null,null,null,null,{"$f":"COUNTA(C43:O43,R43)","v":0},null,{"$f":"IF(Y43=0,\"\",IF(Y43/$AA$42>1,1,Y43/$AA$42))","v":""}]
[null,{"$f":"+B43+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((J44+L44)*H44)","v":0},null,null,null,{"$f":"IFERROR((((P44/100)*R44+P44)/E44*$M$14),0)","v":0},null,null,null,null,{"$f":"COUNTA(C44:O44,R44)","v":0},null,{"$f":"IF(Y44=0,\"\",IF(Y44/$AA$42>1,1,Y44/$AA$42))","v":""},null,"Middle Setup"]
[null,{"$f":"+B44+1","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((J45+L45)*H45)","v":0},null,null,null,0,null,null,null,null,0,null,"",null,{"$f":"IF(ISERROR(AVERAGE(AA43:AA48)),0,AVERAGE(AA43:AA48))","v":0}]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((J46+L46)*H46)","v":0},null,null,null,0,null,null,null,null,0,null,""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR((((P47/100)*R47+P47)/E47*$M$14),0)","v":0},null,null,null,null,{"$f":"COUNTA(C47:O47,R47)","v":0},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((J48+L48)*H48)","v":0},null,null,null,{"$f":"IFERROR((((P48/100)*R48+P48)/E48*$M$14),0)","v":0},null,null,null,null,0,null,{"$f":"IF(Y48=0,\"\",IF(Y48/$AA$42>1,1,Y48/$AA$42))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A67,\" \",\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\",\":\")","v":"Subtotal Setup Costs [EUR/1 pcs]:"},null,null,null,null,null,{"$f":"SUM(T43:T48)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A118,\" \",\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\",\":\")","v":"Total Scrap Costs [EUR/1 pcs]:"},null,null,null,null,null,{"$f":"SUM(T27,T39)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A68,\" \",\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\",\":\")","v":"Subtotal Production Costs [EUR/1 pcs]:"},null,null,null,null,null,{"$f":"IF(OR(T27=Languages!$A$174,T39=Languages!$A$174,T25=Languages!$A$174,T37=Languages!$A$174,T49=Languages!$A$174),Languages!$A$174,(SUM(T27,T39,T25,T37,T49)))","v":0}]
[]
[null,{"$f":"Languages!A71","v":"Product Specific Allocation"},null,null,null,null,null,null,{"$f":"Languages!A261","v":"Remarks"},null,null,null,null,{"$f":"Languages!A96","v":"Overheads"}]
[null,{"$f":"Languages!A73","v":"Pos."},{"$f":"Languages!A74","v":"Designation\n[e.g. Tooling, Devices, \nResearch & Development, Validation, etc.]"},{"$f":"Languages!A27","v":"Manufacturing Steps\n[Designation] "},{"$f":"CONCATENATE(Languages!A76,\"[\",$L$14,\"]\")","v":"Cost\n[EUR]"},{"$f":"Languages!A77","v":"Allocation Quantity\n[1..n]"},{"$f":"CONCATENATE(Languages!A79,\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\")","v":"Allocation Cost\n[EUR/1 pcs]"},null,"Additional information to CPR, given by supplier\n[only in English]",null,null,null,null,{"$f":"Languages!A97","v":"SG&A\n"},null,{"$f":"Languages!A104","v":"Profit on Material\n"},null,{"$f":"Languages!A98","v":"Profit on Value Add\n"},null,{"$f":"CONCATENATE(Languages!A99,\"[\",Languages!A107,\"/\",$M$14,\" \",Languages!A149,\"]\")","v":"Allocation Costs\n[Allocation Cost/1 pcs]"},null,null,null,null,"Overheads"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Languages!A152","v":"Base 1"},{"$f":"Languages!A105","v":" %"},{"$f":"Languages!A153","v":"Base 2"},{"$f":"Languages!A105","v":" %"},{"$f":"Languages!A154","v":"Base 3"},{"$f":"Languages!A105","v":" %"},null,null,null,null,null,"SG&A",null,{"$f":"IF(O58=\"\",\"\",1)","v":""}]
[null,1,null,null,null,null,{"$f":"IFERROR(E58/F58*$M$14,0)","v":0},null,null,null,null,null,null,{"$f":"T53","v":0},null,{"$f":"IF(T25=Languages!$A$174,Languages!$A$174,(SUMPRODUCT((H19:H24=\"\")*1,K19:K24,L19:L24)+SUMPRODUCT((H19:H24=\"no\")*1,K19:K24,L19:L24)+SUMPRODUCT((H19:H24=\"no\")*1,N19:N24,P19:P24)+SUMPRODUCT((H19:H24=\"\")*1,N19:N24,P19:P24)-SUMPRODUCT((H19:H24=\"yes\")*1,K19:K24,L19:L24))*$M$14)","v":0},null,{"$f":"SUM(T37,T49)","v":0},null,{"$f":"G67","v":0}]
[null,{"$f":"+B58+1","v":2},null,null,null,null,{"$f":"IFERROR(E59/F59*$M$14,0)","v":0},null,null,null,null,null,null,{"$f":"IF(O58=\"\",CONCATENATE(\"[\",$L$14,\" \",\"/\",\" \",$M$14,\" \",Languages!A149,\"]\"),N58*O58)","v":"[EUR / 1 pcs]"},null,{"$f":"IF(Q58=\"\",CONCATENATE(\"[\",$L$14,\" \",\"/\",\" \",$M$14,\" \",Languages!A149,\"]\"),(P58*Q58))","v":"[EUR / 1 pcs]"},null,{"$f":"IF(S58=\"\",CONCATENATE(\"[\",$L$14,\" \",\"/\",\" \",$M$14,\" \",Languages!A149,\"]\"),(R58*S58))","v":"[EUR / 1 pcs]"},null,{"$f":"IF(T58<0.00000001,CONCATENATE(\"[\",$L$14,\" \",\"/\",\" \",$M$14,\" \",Languages!A149,\"]\"),T58)","v":"[EUR / 1 pcs]"},null,null,null,null,"Profit (Mat.)",null,{"$f":"IF(Q58=\"\",\"\",1)","v":""}]
[null,{"$f":"+B59+1","v":3},null,null,null,null,0,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A69,\" \",\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\",\":\")","v":"Subtotal Overhead Costs [EUR/1 pcs]:"},null,null,null,null,null,{"$f":"SUM(N59:T59)","v":0},null,null,null,null,null,null,null,null,"Middle Overhead"]
[null,4,null,null,null,null,0,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A156,\", \",Languages!A157,\", \",Languages!A158)","v":"Base 1 = Production Costs, Base 2 = Material Costs without sum of Surcharges, Base 3 = Sum of Manufacturing Costs and Setup Costs"},null,null,null,null,null,null,null,null,null,null,"Profit (VA)",null,{"$f":"IF(S58=\"\",\"\",1)","v":""},null,{"$f":"IF(ISERROR(AVERAGE(AA57,AA59,AA61)),0,AVERAGE(AA57,AA59,AA61))","v":0}]
[null,5,null,null,null,null,0]
[null,6,null,null,null,null,0,null,null,null,null,null,null,{"$f":"Languages!A95","v":"Terms of Payment and Delivery"}]
[null,7,null,null,null,null,0,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A100,\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\")","v":"Packaging\n[EUR/1 pcs]"},null,{"$f":"CONCATENATE(Languages!A101,\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\")","v":"Transport\n[EUR/1 pcs]"},null,{"$f":"Languages!A103","v":"Duty\n"},null,{"$f":"CONCATENATE(Languages!A102,\"[\",Languages!A106,\"]\",\"\n\",\"[\",$L$14,\" \",\"/\",\" \",$M$14,\" \",Languages!A149,\"]\")","v":"Payment Terms\n[days]\n[EUR / 1 pcs]"}]
[null,8,null,null,null,null,0]
[null,{"$f":"+B65+1","v":9},null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Languages!A108","v":"Base"},{"$f":"Languages!A105","v":" %"}]
[null,null,null,{"$f":"CONCATENATE(Languages!A81,\" \",\"[\",L14,\"/\",$M$14,Languages!A149,\"]\",\":\")","v":"Subtotal Allocation Costs [EUR/1pcs]:"},null,null,{"$f":"SUM(G58:G66)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(N68=\"\",\"\",CPR!N68/CPR!T53),0)","v":""},null,{"$f":"IFERROR(IF(P68=\"\",\"\",CPR!P68/CPR!T53),0)","v":""},null,null,{"$f":"IFERROR(R68/R67,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment/Delivery/Onetime-pay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A70,\" \",\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\",\":\")","v":"Subtotal Terms of Payment and Delivery Costs [EUR/1 pcs]:"},null,null,null,null,null,{"$f":"SUM(N68:T68)","v":0},null,null,null,null,"Current","Cell","Max."]
[null,{"$f":"Languages!A83","v":"One-time Payments"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N68=\"\",\"\",AA70)","v":""},"pack.",{"$f":"1/COUNTA($Z$70:$Z$80)","v":0.16666666666666666}]
[null,{"$f":"Languages!A85","v":"Pos."},{"$f":"Languages!A86","v":"Designation\n[e.g. Tooling, Devices, \nResearch & Development, Validation, etc.]"},null,{"$f":"Languages!A88","v":"Lifetime in Cycles\n[pcs]"},null,{"$f":"CONCATENATE(Languages!A91,\"[\",$L$14,\"]\")","v":"Cost\n[EUR]"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Languages!A161","v":"Degree of Filling:"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P68=\"\",\"\",AA72)","v":""},"transp.",{"$f":"1/COUNTA($Z$70:$Z$80)","v":0.16666666666666666}]
[null,1,null,null,null,null,null,null,null,null,null,null,null,"[%]"]
[null,{"$f":"+B73+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R68=\"\",\"\",AA74)","v":""},"duty",{"$f":"1/COUNTA($Z$70:$Z$80)","v":0.16666666666666666},null,"Summary Terms and alloc."]
[null,{"$f":"+B74+1","v":3},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Y82","v":0}]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T68=\"\",\"\",AA76)","v":""},"paym.",{"$f":"1/COUNTA($Z$70:$Z$80)","v":0.16666666666666666}]
[null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A119,\" \",\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\",\" \",Languages!A120,\":\")","v":"Total Price [EUR/1 pcs] (Price after reduction steps):"},null,null,null,null,null,{"$f":"IF(OR(T60=Languages!$A$174,T69=Languages!$A$174,T53=Languages!$A$174),Languages!$A$174,SUM(T60,T69,T53))","v":0},null,null,null,null,{"$f":"IF(T58=0,\"\",AA78)","v":""},"alloc.",{"$f":"1/COUNTA($Z$70:$Z$80)","v":0.16666666666666666}]
[null,{"$f":"+B78+1","v":7}]
[null,null,null,{"$f":"CONCATENATE(Languages!A93,\" \",\"[\",$L$14,\"]\",\":\")","v":"Total One-time Payments [EUR]:"},null,null,{"$f":"SUM(G73:G79)","v":0},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Languages!A125,\" \",\"[\",$L$14,\"/\",$M$14,\" \",Languages!A149,\"]\",\" \",\":\")","v":"Surcharges not incl. in part price [EUR/1 pcs] :"},null,null,null,{"$f":"SUMPRODUCT(K19:K24,M19:M24)*$M$14","v":0},null,null,null,null,{"$f":"IF(G80=0,\"\",AA80)","v":""},"onetime p.",{"$f":"1/COUNTA($Z$70:$Z$80)","v":0.16666666666666666}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"WE NEED THE COMPLETED CPR-SHEET IN EXCEL FORMAT; OTHER FORMATS WILL NOT DO\nAll rights reserved to Schaeffler Technologies AG & Co. KG, in particular in case of grant of an IP right.",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y70,Y72,Y74,Y76,Y78,Y80)","v":0},"∑",{"$f":"SUM(AA70,AA72,AA74,AA76,AA78,AA80)","v":0.99999999999999989}]

{"sheet":"Manufacturing Steps","index":1,"n_rows":185,"n_cols":16,"rows_kept":185,"cut":false,"hidden":false,"merged":[]}
[null,"A","D","H","N","S","V",null,null,null,null,null,null,null,null,1]
["alpha-v-check","alpha-v-check","debinding","handling","nitriding","sawing","varnishing"]
["annealing","annealing","deburring","HAR / hot air riveting","O","selective soldering","vulcanization"]
["anti-corrosion","anti-corrosion","deep drawing","hardening","oiling","setting","W"]
["AOI / automated optical inspection","AOI / automated optical inspection","deflection test","heat- / force-set test","others / miscellaneous","shearing","washing "]
["arc forming","arc forming","demagnetize","heat treatment","outbound logistics","shot blasting","welding"]
["array for spray","array for spray","dephosphating","high pressure washing","overmolding","shot peening","winding"]
["array on fixture","array on fixture","detensioning","hobbing","P","sintering","X"]
["assembling","assembling","disassembling","honing","pack","sizing","x-ray"]
[null,"B","DMC marking","hot bar soldering","packaging","skiving"]
["balancing","balancing","drawing + pressing","hot rolling","PCB depaneling","SMT / surface mounted technology"]
["bending","bending","drilling","hot setting","phosphating","software flashing"]
["blanking","blanking","drying","hot staking","pickling","solder paste printing"]
["blending","blending","durability test","hydrogen decrepitation","plating","soldering"]
["bonding","bonding","E","I","polishing","sorting"]
["boring","boring","e-coating","IC test / integrated circuit test","post curing","spinning"]
["broaching","broaching","eddy current","inbound logistics","potting","spot welding"]
["brushing","brushing","EOL test / end of line test","induction heating","powder coating","spraying"]
[null,"C","F","injection","preforming","sputtering / PVD"]
["calibration","calibration","fine cutting","inspection","press-fit assembly","stamping"]
["carburizing","carburizing","finishing","intermediate test","pressing","storage of powder"]
["casting","casting","flashing","J","pressure test","straightening"]
["chamfering","chamfering","forging","jet-milling","pretreatment","stripe casting, flakes production"]
["cleaning","cleaning","forming","L","Q","surface treatment"]
["coating","coating","friction welding","lapping","quench + tempering","T"]
["coiling","coiling","functional test","laser marking","R","tempering"]
["compacting","compacting","G","leakage test","raw material inspection","testing"]
["condensation","condensation","gating removal","liquid dispensing, application (seal, paste)","reaming","transform"]
["conservation","conservation","grain boundary diffusion (GBD)","loading, feeding","reflow oven","transport"]
["cooling","cooling","gearing","M","rolling","trimming"]
["cooling lubricant system","cooling lubricant system","glue ","machining",null,"tumbling"]
["crimping","crimping","green machining","magnetic property test",null,"turning"]
["curing","curing","grinding ID","magnetizing",null,"U"]
["cutting","cutting","grinding OD","marking",null,"ultrasonic cleaning"]
[null,null,null,"material preparation and compounding",null,"ultrasonic welding"]
["debinding",null,null,"measuring"]
["deburring",null,null,"mechanical treatment"]
["deep drawing",null,null,"melting"]
["deflection test",null,null,"micro peening"]
["demagnetize",null,null,"milling"]
["dephosphating",null,null,"mixing"]
["detensioning",null,null,"molding"]
["disassembling",null,null,"MPI"]
["DMC marking"]
["drawing + pressing"]
["drilling"]
["drying"]
["durability test"]
[]
["e-coating"]
["eddy current"]
["EOL test / end of line test"]
[]
["fine cutting"]
["finishing"]
["flashing"]
["forging"]
["forming"]
["friction welding"]
["functional test"]
[]
["gating removal"]
["grain boundary diffusion (GBD)"]
["gearing"]
["glue "]
["green machining"]
["grinding ID"]
["grinding OD"]
[]
["handling"]
["HAR / hot air riveting"]
["hardening"]
["heat- / force-set test"]
["heat treatment"]
["high pressure washing"]
["hobbing"]
["honing"]
["hot bar soldering"]
["hot rolling"]
["hot setting"]
["hot staking"]
[]
["IC test / integrated circuit test"]
["inbound logistics"]
["induction heating"]
["injection"]
["inspection"]
["intermediate test"]
[]
["jet-milling"]
[]
["lapping"]
["laser marking"]
["leakage test"]
["liquid dispensing, application (seal, paste)"]
["loading, feeding"]
[]
["machining"]
["magnetic property test"]
["magnetizing"]
["marking"]
["material preparation and compounding"]
["measuring"]
["mechanical treatment"]
["melting"]
["micro peening"]
["milling"]
["mixing"]
["molding"]
["MPI"]
[]
["nitriding"]
[]
["oiling"]
["others / miscellaneous"]
["outbound logistics"]
["overmolding"]
[]
["pack"]
["packaging"]
["PCB depaneling"]
["phosphating"]
["pickling"]
["plating"]
["polishing"]
["post curing"]
["potting"]
["powder coating"]
["preforming"]
["press-fit assembly"]
["pressing"]
["pressure test"]
["pretreatment"]
[]
["quench + tempering"]
[]
["raw material inspection"]
["reaming"]
["reflow oven"]
["rolling"]
[]
["sawing"]
["selective soldering"]
["setting"]
["shearing"]
["shot blasting"]
["shot peening"]
["sintering"]
["sizing"]
["skiving"]
["SMT / surface mounted technology"]
["software flashing"]
["solder paste printing"]
["soldering"]
["sorting"]
["spinning"]
["spot welding"]
["spraying"]
["sputtering / PVD"]
["stamping"]
["storage of powder"]
["straightening"]
["stripe casting, flakes production"]
["surface treatment"]
[]
["tempering"]
["testing"]
["transform"]
["transport"]
["trimming"]
["tumbling"]
["turning"]
[]
["ultrasonic cleaning"]
["ultrasonic welding"]
[]
["varnishing"]
["vulcanization"]
[]
["washing "]
["welding"]
["winding"]
[]
["x-ray"]
["others"]

{"sheet":"Languages","index":2,"n_rows":407,"n_cols":8,"rows_kept":407,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"CPR!K3","v":"English"},"Deutsch","English","Español","中文","한국","русский язык","Türkce"]
[{"$f":"HLOOKUP($A$2,$B$2:$H$456,ROW()-1,FALSE)","v":"Material Costs"},"Materialkosten","Material Costs","Costo de Material","材料成本","재료비","Расходы на материал"]
["Pos.","Pos.","Pos.","Pos.","序号","항목","Поз."]
["Material Designation\n[Raw Material / Purchased Parts / \nExternal Processes]","Materialbezeichnung\n [Rohmaterial / Zukaufteile / \nExterne Prozesse]","Material Designation\n[Raw Material / Purchased Parts / \nExternal Processes]","Designación de Material\n[Materia Prima / Componentes / \nProcesos Externos]","材料名称\n[原材料/外购件/外协工序]","재료구분\n[원재 / 구매품 / 외주가공]","Обозначание материала [Сырье / Покупаемые детали / Внешние процесcы]"]
["Manufacturer / Raw Material Supplier","Hersteller / Rohmateriallieferant","Manufacturer / Raw Material Supplier","Fabricante / Proveedor de materias primas","生产厂商/原材料供应商","제조사/원재 공급사","производитель / Поставщик сырья"]
["Dimension*\n[Diameter x Rod Length]\n[mm]","Maße*\n[Durchmesser x Stablänge]\n[mm]","Dimension*\n[Diameter x Rod Length]\n[mm]","Dimensiones*\n[Diámetro x Longitud de Varilla]\n[mm]","尺寸*\n[直径*长度]\n[mm]","크기*\n[직경 x 봉길이]\n[mm]","Размеры*\n[Диаметр х длина стержня] [мм]"]
["[Base]\n","[Basis]\n","[Base]\n","[Base]\n","[基价]\n","[기준]\n","[Основание (Базовая цена)]"]
["[Surcharges]\n","[Zuschläge]\n","[Surcharges]\n","[Recargo]\n","[附加费]\n","[할증료]\n","[Надбавки]"]
["[Quantity]\n[pcs]","[Stückzahl]\n[St.]","[Quantity]\n[pcs]","[Cantidad]\n[pzas]","[数量]\n[件]","[수량]\n[개]","[Количество] [шт]"]
["Net Weight per Part\n[kg]","Nettogewicht pro Teil\n[kg]","Net Weight per Part\n[kg]","Peso Neto por Pieza\n[kg]","净重\n[公斤]","순중량\n[kg]","Вес нетто одной детали [кг]"]
["Dimension \n[LxWxH, Ø,…]\nin mm","Abmessung \n[LxBxH, Ø,…] \nin mm","Dimension \n[LxWxH, Ø,…]\nin mm","Dimensiones\n[LxAxA, Ø,….]\nen mm","尺寸\n[长x宽x高,直径,…]","치수\n[LxWxH, Ø,…]","измерение \n[ДхШхВ, Ø,…]\nв mm "]
["Gross Weight per Part\n[kg]","Bruttogewicht pro Teil\n[kg]","Gross Weight per Part\n[kg]","Peso Bruto por Pieza\n[kg]","毛重\n[公斤]","총 중량\n[kg]","Вес брутто одной детали [кг]"]
["Substance- / Material- / Part-ID","Werkstoff- / Material- / Bauteil-ID","Substance- / Material- / Part-ID","Sustancia- / Material- / ID-Parte","材质/原料/零件编号","물질- / 재료- / 파트-ID","Идентификатор (ID) Материала / компонента"]
["Material Price","Materialpreis","Material Price","Precio de Materia Prima","材料价格","재료 단가","Цена материала"]
["Reimbursement","Rückerstattung","Reimbursement","Reembolso","废料出售","변제(스크랩 판매)","Возмещение (Возвратные отходы) "]
["Procurement Type","Bezugsart","Procurement Type","Tipo de aprovisionamiento","采购类别","조달 유형","тип закупки"]
["Purchased Parts / External Processes","Zukaufteile / Externe Prozesse","Purchased Parts / External Processes","Componentes / Procesos Externos","外购件/外协工序"," 구매품 / 외주가공","Покупные детали / Внешние процессы"]
["Material \nOverhead \n[%]","Material-\ngemeinkosten \n[%]","Material \nOverhead \n[%]","Gastos Generales \nde Material\n[%]","材料管理费\n[%]","재료 일반관리비\n[%]","Накладные расходы по обеспечению материалом [%]"]
["Material Cost\n","Materialkosten\n","Material Cost\n","Costo Directo de Material\n","材料成本\n","개당 재료비\n","Материальные затраты"]
["Subtotal Material Costs","Zwischensumme Materialkosten ges.","Subtotal Material Costs","Subtotal Costo de Material","材料成本合计","재료비 부분합","Итого Материальные затраты"]
[0]
[0]
["Manufacturing Costs","Fertigungskosten","Manufacturing Costs","Costo de Producción","制造成本","제조 공정비","Затраты на производство"]
["\n[e.g.: M1]","\n[z.B.: M1]","\n[e.g.: M1]","\n[p.e.: M1]","\n[例：M1]","\n[예: M1]","\n[например: М1]"]
["Pos.","Pos.","Pos.","Pos.","序号","항목","Поз."]
["Manufacturing Steps\n[Designation] ","Fertigungsschritte\n[Bezeichnung]","Manufacturing Steps\n[Designation] ","Proceso\n[Designación]","制造工艺步骤\n[名称]","제조 단계\n[공정명] ","Этапы производства (последовательность операций) [обозначение]"]
["Material*\n[Material \nCost Pos.]\n[e.g.: M1]","Material*\n[Materialkosten Pos.]\n[z.B.: M1]","Material*\n[Material \nCost Pos.]\n[e.g.: M1]","Material*\n[Pos. Costo de Material]\n[p.e.: M1]","材料*\n[材料成本序号]\n[例：M1]","재료*\n[재료비 항목]\n[예: M1]","Материал* [Материальные затраты Поз.] [например: М1]"]
["Equipment \n[Designation]","Anlage\n[Bezeichnung]","Equipment \n[Designation]","Maquinaria y/o Equipo\n[Designación]","设备\n[名称]","설비\n[설비명]","Оборудование [Обозначение]"]
["Cycle time \n[sec./Parts per Cycle]","Zykluszeit \n[Sek./Teile pro Zyklus]","Cycle time \n[sec./Parts per Cycle]","Tiempo de Ciclo\n[seg./Pieza por Ciclo]","节拍时间\n[秒/每节拍件数]","사이클 타임\n[사이클당 sec./Parts]","время цикла\n[сек./Части за цикл]"]
["Net Output / OEE\n[pcs/h] ","Netto Ausbringungs-menge\n[St./Std.]","Net Output / OEE\n[pcs/h] ","Cantidad Neta Producida / OEE\n[pzas/h]","净产出/OEE\n[件/小时]","시간당 양품생산량\n[pcs/h] ","Количество годной продукции / Эффективность всего оборудования (ЭВО) [шт/ч]"]
["Parts per Cycle\n[pcs]","Teile pro Zyklus\n[St.]","Parts per Cycle\n[pcs]","Piezas por Ciclo\n[pzas]","件数/节拍\n[件]","사이클당 생산수량\n[pcs]","Детали за цикл [шт] (для информации)"]
["Working System Invest\n","Anschaffungs-kosten Maschine\n","Working System Invest\n","Valor de Adquisición de Maquinaria                         y/o Equipo\n","设备投资\n","설비 투자비\n","Стоимость рабочей системы в год приобретения"]
["Working System Hourly Rate   \n","Maschinen-\nstundensatz\n","Working System Hourly Rate   \n","Costo Hora-Máquina\n","设备工时费\n","설비 임율\n","Часовая ставка рабочей системы"]
["Working System Cost \nper Part\n","Maschinenkosten pro Teil\n","Working System Cost \nper Part\n","Costo Directo de Máquina                                          por Pieza\n","设备成本/件\n","개당 가공비\n","Затраты рабочей системы на одну деталь"]
["Direct Labor Hourly Rate\n","Fertigungslohn am Arbeitssystem\n","Direct Labor Hourly Rate\n","Salario Personal Operativo\n","直接人工工时费\n","작업자 임율\n","Часовая ставка основных производственных рабочих"]
["Headcount at Working System \n[%]","Anzahl Mitarbeiter am Arbeitssystem\n[%]","Headcount at Working System \n[%]","No. Operadores en                                                       Estación de Trabajo\n[%]","操作工人数/设备\n[%]","작업 인원수\n[%]","Число работников в производственной системе [%]"]
["Labor Cost per Part\n","Arbeitskosten pro Teil\n","Labor Cost per Part\n","Costo Mano de Obra Directa por Pieza\n","人工成本/件\n","개당 인건비\n","Трудо-затраты на одну деталь"]
[0]
["Scrap Rate \n[%]","Fertigungs-\nausschussrate\n[%]","Scrap Rate \n[%]","Nivel de\nDesecho\n[%]","报废率\n[%]","불량율 \n[%]","Процент брака                                   [%]"]
["Residual Manufacturing \nOverhead\n[%]","Restfertigungs-\ngemeinkosten\n[%]","Residual Manufacturing \nOverhead\n[%]","Gastos Indirectos \nde Fabricación\n[%]","制造管理费\n[%]","제조 간접비\n[%]","Остальные накладные расходы  на производство [%]"]
["Manufacturing Step Cost\n","Fertigungskosten\n","Manufacturing Step Cost\n","Costo Directo de Producción\n","制造成本\n","개당 제조 원가\n","Затраты по этапам производства"]
[0]
["Subtotal Manufacturing Costs","Zwischensumme Fertigungskosten ges.","Subtotal Manufacturing Costs","Subtotal Costo de Producción","制造成本合计","제조공정비 부분합","Итого затраты на производство"]
["*)   Assemblies","*)   Baugruppen","*)   Assemblies","*)   Ensambles","*）装配","*)   조립","*) Сборки"]
[0]
[0]
["Setup Costs","Rüstkosten","Setup Costs","Costo de Set-up (Preparación de Línea)","换型成本","형번교체비","Затраты на наладку / переналадку"]
["Pos.","Pos.","Pos.","Pos.","序号","항목","Поз."]
["Manufacturing Steps\n[Designation] ","Fertigungsschritte\n[Bezeichnung]","Manufacturing Steps\n[Designation] ","Proceso\n[Designación]","制造工艺步骤\n[名称]","제조 단계\n[공정명] ","Этапы производства (последовательность операций) [обозначение]"]
[0]
["Manufacturing Lot Size\n[pcs]","Fertigungslosgröße\n[St.]","Manufacturing Lot Size\n[pcs]","Tamaño de Lote de Producción\n[pzas]","生产批量\n[件]","생산 Lot 크기\n[pcs]","Количество на единицу продукции [шт]"]
[0]
[0]
["Setup Time\n[h]","Rüstzeit\n[Std.]","Setup Time\n[h]","Tiempo de Set-up\n[h]","换型时间\n[h]","형번교체시간\n[h]","Время наладки / переналадки [ч]"]
[0]
["Setup Labor Hourly Rate \n","Fertigungslohn Rüstvorgang\n","Setup Labor Hourly Rate \n","Salario Personal Set-up\n","换型人工工时费\n","형번교체 직접인건비 임율\n","Часовая ставка рабочего-наладчика"]
[0]
["Working System Hourly Rate\n","Maschinenstundensatz\n","Working System Hourly Rate\n","Costo Hora-Máquina\n","设备工时费\n","생산시스템 시간당 임율\n","Часовая ставка рабочей системы (наладочного оборудования)"]
[0]
[0]
[0]
["Setup Cost\n","Rüstkosten\n","Setup Cost\n","Costo de Set-up\n","换型成本\n","형번교체 비용\n","Затраты на наладку / переналадку"]
["Residual Manufacturing \nOverhead\n[%]","Restfertigungs-\ngemeinkosten\n[%]","Residual Manufacturing \nOverhead\n[%]","Gastos Indirectos de\nFabricación\n[%]","制造管理费\n[%]","제조 간접비\n[%]","Остальные накладные расходы  на производство [%]"]
["Setup Cost\n","Rüstkosten\n","Setup Cost\n","Costo Directo de Set-up\n","换型成本\n","개당 형번교체 원가\n","Затраты на наладку / переналадку"]
["Designation","Beschreibung","Designation","Descripción","名称","품명","Назначение"]
[{"$f":"HLOOKUP($A$2,$B$2:$H$456,ROW()-1,FALSE)","v":"Subtotal Setup Costs"},"Zwischensumme Rüstkosten ges.","Subtotal Setup Costs","Subtotal Costo de Set-up","换型成本合计","형번교체비용 부분합","Итого затраты на наладку / переналадку"]
["Subtotal Production Costs","Zwischensumme Produktionskosten ges.","Subtotal Production Costs","Subtotal Costo de Manufactura","生产成本合计","생산원가 부분합","Итого издержки производства"]
["Subtotal Overhead Costs","Zwischensumme Gemeinkosten ges.","Subtotal Overhead Costs","Subtotal Gastos Generales (Overheads)","管理费合计","간접비 부분합","Итого Накладные расходы"]
["Subtotal Terms of Payment and Delivery Costs","Zwischensumme Zahlungs- und Lieferbed. ges.","Subtotal Terms of Payment and Delivery Costs","Subtotal Condiciones de Pago y Entrega","帐期及物流成本合计","지불 및 인도조건의 부분합","Итого Условия оплаты и расходы по доставке"]
["Product Specific Allocation","Produktspezifische Umlage","Product Specific Allocation","Amortizaciones Específicas de Producto","产品专项摊销","생산 특별 추가비용","Специфические затраты для данного конкретного продукта"]
[0]
["Pos.","Pos.","Pos.","Pos.","序号","항목","Поз."]
["Designation\n[e.g. Tooling, Devices, \nResearch & Development, Validation, etc.]","Beschreibung\n[z.B. Werkzeuge, Vorrichtungen,\nEntwicklung, Validierung, usw.]","Designation\n[e.g. Tooling, Devices, \nResearch & Development, Validation, etc.]","Descripción\n[p/e: Herramentales, Dispositivos, \nInvestigación y Desarrollo, Validación, etc.]","名称\n[如:模具,工装,研发,测试验证等]","품명\n[예, 공구, 장치, 시험 연구, 검증 등]","Назначение [напр.: Оснастка (инструмент), Приспособления, НИОКР, Валидация и т.д.]"]
[0]
["Cost\n","Kosten\n","Cost\n","Costos\n","成本\n","원가\n","Стоимость"]
["Allocation Quantity\n[1..n]","Umlagemenge\n[1..n]","Allocation Quantity\n[1..n]","Volumen de Amortización\n[1..n]","摊销数量\n[1…n]","할당 수량\n[1..n]","Количество распределения [1...]"]
[0]
["Allocation Cost\n","Umlagekosten\n","Allocation Cost\n","Amortizaciones\n","摊销成本\n","개당 비용\n","Распределение затрат"]
[0]
["Subtotal Allocation Costs","Zwischensumme Umlagekosten ges.","Subtotal Allocation Costs","Subtotal Amortizaciones","摊销成本合计","추가비용 부분합","Итого специфические затраты"]
[0]
["One-time Payments","Einmalzahlungen","One-time Payments","Pagos en una sola Exhibicíón","一次性付款","1회성 비용","Единовременные выплаты Шэффлер (для информации)"]
[0]
["Pos.","Pos.","Pos.","Pos.","序号","항목","Поз."]
["Designation\n[e.g. Tooling, Devices, \nResearch & Development, Validation, etc.]","Beschreibung\n[z.B. Werkzeuge, Vorrichtungen,\nEntwicklung, Validierung, usw.]","Designation\n[e.g. Tooling, Devices, \nResearch & Development, Validation, etc.]","Descripción\n[p/e: Herramentales, Dispositivos, \nInvestigación y Desarrollo, Validación, etc.]","名称\n[如:模具,工装,研发,测试验证等]","품명\n[예, 공구, 장치, 시험 연구, 검증 등]","Назначение [напр.: Оснастка (инструмент), приспособления, НИОКР, валидация и т.д.]"]
[0]
["Lifetime in Cycles\n[pcs]","Lebensdauer in Zyklen \n[St.]","Lifetime in Cycles\n[pcs]","Vida útil en Ciclos \n[pzas]","寿命\n[件]","보증 수량\n[pcs]","Срок службы в циклах [шт]"]
[0]
[0]
["Cost\n","Kosten\n","Cost\n","Costos\n","成本\n","원가\n","Стоимость"]
[0]
["Total One-time Payments","Einmalzahlungen ges.","Total One-time Payments","Pagos en una sola Exhibición","一次性付款合计","1회성 비용 부분합","Всего Единовременные выплаты"]
[0]
["Terms of Payment and Delivery","Zahlungs- und Lieferbedingungen","Terms of Payment and Delivery","Condiciones de Pago y Entrega:","帐期及交付","지불 및 인도 조건","Условия оплаты и доставки"]
["Overheads","Gemeinkosten","Overheads","Gastos Generales (Overheads)","管理费","간접비","Накладные расходы"]
["SG&A\n","VVGK\n","SG&A\n","Gastos de Venta y Admón.","管理费\n","일반관리비\n","Коммерческие, общехозяйственные и административные расходы"]
["Profit on Value Add\n","Gewinn auf die Wertschöpfung\n","Profit on Value Add\n","Ganancia sobre Valor Agregado","生产利润率\n","부가가치에 대한 이윤\n","Прибыль на добавленную стоимость"]
["Allocation Costs\n","Umlagekosten\n","Allocation Costs\n","Amortizaciones\n","摊销成本\n","특별 추가비\n","Распределение затрат"]
["Packaging\n","Verpackung\n","Packaging\n","Empaque\n","包材\n","포장비\n","Затраты на упаковка"]
["Transport\n","Transport\n","Transport\n","Transporte\n","运输\n","물류비\n","Расходы на транспортировку"]
["Payment Terms\n","Zahlungsbedingungen\n","Payment Terms\n","Condiciones de Pago\n","账期\n","지불조건\n","Условия оплаты"]
["Duty\n","Zoll\n","Duty\n","Impuesto Aduanal\n","关税\n","관세\n","Пошлины, сборы"]
["Profit on Material\n","Gewinn auf das Material\n","Profit on Material\n","Ganancia sobre Material\n","材料利润率\n","재료비에 대한 이윤\n","Прибыль по материалу"]
[" %","%"," %","%","%"," %","%"]
["days","Tage","days","Días","天数","일수","дни"]
["Allocation Cost","Umlagekosten","Allocation Cost","Amortizaciones","摊销成本","추가 비용","Распределение затрат"]
["Base","Basis","Base","Base","基数","기준","База (Основа)"]
["FCA","FCA","FCA","FCA","FCA","FCA","FCA"]
["DAP","DAP","DAP","DAP","DAP","DAP","DAP"]
["DDP","DDP","DDP","DDP","DDP","DDP","DDP"]
[0]
["Scrap Rate\n[%]","Material-\nausschussrate\n[%]","Scrap Rate\n[%]","Nivel de Desperdicio\n[%]","报废率\n[%]","불량율\n[%]","Процент брака                                   [%]"]
["Scrap Cost\n","Material-\nausschusskosten\n","Scrap Cost\n","Costo de Desperdicio\n","报废成本\n","불량 금액\n","Стоимость брака"]
["Scrap Cost\n","Fertigungs-\nausschusskosten\n","Scrap Cost\n","Costo de\nDesecho\n","报废成本\n","불량 금액\n","Стоимость брака"]
["Subtotal Material Scrap Costs","Zwischensumme Materialausschusskosten ges.","Subtotal Material Scrap Costs","Subtotal Desperdicio Material","材料报废成本合计","재료 불량 금액 부분합","Итого стоимость бракованного материала"]
["Subtotal Manufacturing Scrap Costs","Zwischensumme Fertigungsausschusskosten ges.","Subtotal Manufacturing Scrap Costs","Subtotal Desecho Proceso","工艺报废成本合计","제조공정 불량 금액 부분합","Итого стоимость бракованной продукции"]
["Total Scrap Costs","Ausschusskosten ges.","Total Scrap Costs","Costo Total de Rechazo","报废成本合计","총 불량 비용","Всего Стоимость брака"]
["Total Price","Gesamtpreis","Total Price","Precio Total","零件总价","개당 총 원가","Итого цена"]
["(Price after reduction steps)","(Preis nach Preisabbaustufen)","(Price after reduction steps)","(Precio con descuentos)","（年降后价格）","(절감 후 최종단가)","Цена после действий по сокращению"]
["OEE [%]\ninformation only","GAE [%]\nzur Information","OEE [%]\ninformation only","OEE [%]\nSolamente informativo","OEE [%]\n仅供参考","OEE(설비종합효율) [%]\n참고 정보","OEE [%]\nдля информации"]
[0]
[0]
[0]
["Surcharges not incl. in part price","Nicht im Teilepreis enthaltene Zuschläge:","Surcharges not incl. in part price","Sobrecargos no incluidos en el precio de la pieza","未体现在单价中的附加费"]
[0]
[0]
[0]
[0]
[0]
[{"$f":"HLOOKUP($A$2,$B$2:$H$456,ROW()-1,FALSE)","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
["pcs","Stück","pcs","Piezas","件","pcs","шт"]
["kg","kg","kg","kg","公斤","kg","кг"]
["h","Std.","h","h","小时","h","ч"]
["Base 1","Basis 1","Base 1","Base 1","基数 1","기준 1","Основание 1"]
["Base 2","Basis 2","Base 2","Base 2","基数 2","기준 2","Основание 2"]
["Base 3","Basis 3","Base 3","Base 3","基数 3","기준 3","Основание 3"]
[0]
["Base 1 = Production Costs","Basis 1 = Produktionskosten","Base 1 = Production Costs","Base 1 = Costo de Manufactura","基数 1 = 生产成本","기준 1 = 생산원가","Основание 1 = Производственные затраты"]
["Base 2 = Material Costs without sum of Surcharges","Basis 2 = Materialkosten ohne Zuschläge","Base 2 = Material Costs without sum of Surcharges","Base 2 = Costo de Material (sin Recargos)","基数 2 = 材料成本不含附加费","기준 2 = 추가비용(할증)없는 재료비","Основание 2 = Материальные затраты без суммы надбавок"]
["Base 3 = Sum of Manufacturing Costs and Setup Costs","Basis 3 = Fertigungskosten und Rüstkosten","Base 3 = Sum of Manufacturing Costs and Setup Costs","Base 3 = Suma Costo de Producción + Costo Set-up","基数 3 = 制造成本+换型成本","기준 3 = 제조원가와 셋업비용 합계","Основание 3 = Сумма производсвтенных затрат и затрат на наладку / переналадку"]
[0]
[0]
["Degree of Filling:","Füllgrad:","Degree of Filling:","Nivel de Detalle:","填写完整度:","자료 충실도 :","Степень заполнения формы CPR:"]
["Incoterms:","Internationale Handelsklauseln:","Incoterms:","Incoterms:","国际贸易条款:","인코텀스:","ИНКОТЕРМС:"]
["Part No. / Drawing No.: ","Artikelnr. / Zeichnungsnr.: ","Part No. / Drawing No.: ","No. Parte / No. Dibujo: ","零件号/图纸号:","품번. / 도번: ","№ детали / № чертежа:"]
["Part Name:","Teilebezeichnung:","Part Name:","Nombre de la Pieza:","零件名：","품명:","Наименование детали:"]
["Peak-Volume:","Kammstückzahl:","Peak-Volume:","Volumen Máximo Contratado:","峰值年量：","연간 최고 생산수량:","Максимальное (пиковое) годовое количество:"]
["Supplier Name:","Lieferantenname:","Supplier Name:","Nombre del Proveedor:","供应商名称：","공급업체명:","Наименование поставщика (краткое наименование в т.ч. организационно-правовая форма):"]
["Manufacturing Location:","Produktionsstandort:","Manufacturing Location:","Lugar / País de Fabricación:","生产地址：","제조 위치:","Производственная площадка (город):"]
["Production Hours per Year:","Produktionsstunden pro Jahr:","Production Hours per Year:","Horas Producción x Año:","总工时/年:","연간 작업 시간:","Производственные часы за год:"]
["Currency / Quantity Unit in:","Währung / Mengeneinheit in:","Currency / Quantity Unit in:","Moneda / Unidades en:","货币/数量单位：","환율 / 수량 단위:","Валюта / Единица измерения в:"]
["Supplier Contact:","Lieferantenkontakt:","Supplier Contact:","Contacto Proveedor:","供应商联系方式：","공급업체 담당자 :","Контактное лицо поставщика:"]
["Date:","Datum:","Date:","Fecha:","日期：","제출일자:","Дата:"]
["Schaeffler Contact:","Schaeffler Kontakt:","Schaeffler Contact:","Contacto Schaeffler:","舍弗勒联系方式：","셰플러 담당자:","Контактное лицо Шэффлер:"]
["Price Reduction Steps:","Preisabbaustufen:","Price Reduction Steps:","Descuentos de Precio:","年降：","원가 절감 단계:","Действия по сокращению цены:"]
["Error","Fehler","Error","Error","错误","오류","Ошибка"]
["ARS","ARS","ARS","ARS","ARS","ARS","ARS"]
["AUD","AUD","AUD","AUD","AUD","AUD","AUD"]
["BGN","BGN","BGN","BGN","BGN","BGN","BGN"]
["BRL","BRL","BRL","BRL","BRL","BRL","BRL"]
["BYR","BYR","BYR","BYR","BYR","BYR","BYR"]
["CAD","CAD","CAD","CAD","CAD","CAD","CAD"]
["CHF","CHF","CHF","CHF","CHF","CHF","CHF"]
["CNY","CNY","CNY","CNY","CNY","CNY","CNY"]
["CZK","CZK","CZK","CZK","CZK","CZK","CZK"]
["DKK","DKK","DKK","DKK","DKK","DKK","DKK"]
["EGP","EGP","EGP","EGP","EGP","EGP","EGP"]
["EUR","EUR","EUR","EUR","EUR","EUR","EUR"]
["GBP","GBP","GBP","GBP","GBP","GBP","GBP"]
["HKD","HKD","HKD","HKD","HKD","HKD","HKD"]
["HRK","HRK","HRK","HRK","HRK","HRK","HRK"]
["HUF","HUF","HUF","HUF","HUF","HUF","HUF"]
["IDR","IDR","IDR","IDR","IDR","IDR","IDR"]
["ILS","ILS","ILS","ILS","ILS","ILS","ILS"]
["INR","INR","INR","INR","INR","INR","INR"]
["JPY","JPY","JPY","JPY","JPY","JPY","JPY"]
[{"$f":"HLOOKUP($A$2,$B$2:$H$456,ROW()-1,FALSE)","v":"KRW"},"KRW","KRW","KRW","KRW","KRW","KRW"]
["MAD","MAD","MAD","MAD","MAD","MAD","MAD"]
["MXN","MXN","MXN","MXN","MXN","MXN","MXN"]
["MYR","MYR","MYR","MYR","MYR","MYR","MYR"]
["NOK","NOK","NOK","NOK","NOK","NOK","NOK"]
["NZD","NZD","NZD","NZD","NZD","NZD","NZD"]
["PHP","PHP","PHP","PHP","PHP","PHP","PHP"]
["PLN","PLN","PLN","PLN","PLN","PLN","PLN"]
["RON","RON","RON","RON","RON","RON","RON"]
["RSD","RSD","RSD","RSD","RSD","RSD","RSD"]
["RUB","RUB","RUB","RUB","RUB","RUB","RUB"]
["SEK","SEK","SEK","SEK","SEK","SEK","SEK"]
["SGD","SGD","SGD","SGD","SGD","SGD","SGD"]
["THB","THB","THB","THB","THB","THB","THB"]
["TRY","TRY","TRY","TRY","TRY","TRY","TRY"]
["TWD","TWD","TWD","TWD","TWD","TWD","TWD"]
["UAH","UAH","UAH","UAH","UAH","UAH","UAH"]
["USD","USD","USD","USD","USD","USD","USD"]
["VND","VND","VND","VND","VND","VND","VND"]
["ZAR","ZAR","ZAR","ZAR","ZAR","ZAR","ZAR"]
["ZZA","ZZA","ZZA","ZZA","ZZA","ZZA","ZZA"]
["ZZC","ZZC","ZZC","ZZC","ZZC","ZZC","ZZC"]
["ZZD","ZZD","ZZD","ZZD","ZZD","ZZD","ZZD"]
["ZZE","ZZE","ZZE","ZZE","ZZE","ZZE","ZZE"]
["ZZF","ZZF","ZZF","ZZF","ZZF","ZZF","ZZF"]
["ZZI","ZZI","ZZI","ZZI","ZZI","ZZI","ZZI"]
["ZZL","ZZL","ZZL","ZZL","ZZL","ZZL","ZZL"]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
["Price","Preis","Price","Precio","价格","가격","Цена"]
["Location of forwarder","Standort Spediteur","Location of forwarder","Ubicacion de broker","货代地点","포워더 위치","Пункт назначения согласно Incoterms (город)"]
[{"$f":"HLOOKUP($A$2,$B$2:$H$456,ROW()-1,FALSE)","v":"Location Schaeffler"},"Standort Schaeffler","Location Schaeffler","Ubicacion de Schaeffler","舍弗勒地点","셰플러 위치","Расположение подразделения компании Шэффлер (напр.: Шэффлер Россия)"]
["Receiving plant Schaeffler","Anlieferwerk Schaeffler","Receiving plant Schaeffler","Planta entrega Schaeffler","舍弗勒收货工厂","셰플러 부품 입고 공장","Завод Шэффлер - получатель деталей"]
["Remarks","Bemerkung","Remarks","Comentarios","备注","비고","Примечания"]
[0]
[0]
[0]
["M014 Rolled Rings","M014 Gewalzte Ringe","M014 Rolled Rings","M014 Anillos (Rolado)","M014 套圈","M014 전조 링","M014 Раскатные кольца"]
["M016 Forged Parts","M016 Schmiedeteile","M016 Forged Parts","M016 Piezas de Fundición","M016 锻造","M016 단조","M016 Кованные детали"]
["M017 Profiles","M017 Profile","M017 Profiles","M017 Perfiles","M017 型材","M017 프로파일","M017 Профильный металл"]
["M310 Plastic Parts","M310 Kunststoffspritzteile","M310 Plastic Parts","M310 Inyección de Plástico","M310 塑料件","M310 플라스틱 부품","M310 Пластиковые детали"]
["M314 Wet Friction","M314 Reibbelag Nass","M314 Wet Friction","M314 Recubrimiento Acuoso","M314 湿式摩擦材料","M314 습식 마찰","M314 Фрикционные материалы жидкостные"]
["M315 Friction materials","M315 Reibbelaege","M315 Friction materials","M315 Recubrimientos de Fricción","M315 摩擦材料","M315 마찰재","M315 Фрикционные накладки"]
["M316 Ring Gears","M316 Zahnkränze","M316 Ring Gears","M316 Coronas Dentadas","M316 齿圈","M316 링기어","M316 Зубчатые ободы"]
["M317 Hose Lines for Clutch Release Systemes","M317 Leitungen f. Ausrücksysteme","M317 Hose Lines for Clutch Release Systemes","M317 Mangueras","M317 管路","M317 호스 라인","M317 Патрубки для подшипников сцепления"]
["M320 Elastomeric Moulding Materials","M320 Elastomere Formteile","M320 Elastomeric Moulding Materials","M320 Elastómeros (Piezas Moldeadas)","M320 橡胶件","M320 고무 성형품","M320 Высокоэластичные формовочные материалы"]
["M330 Aluminum casted parts","M330 Aluminium Gussteile","M330 Aluminum casted parts","M330 Fundición de Aluminio y Maquinado","M330 铝压铸件（含机加工）","M330 가공포함 알미늄 주조","M330 Алюминиевые литые детали"]
["M340 Cast Housings","M340 Gussgehäuse","M340 Cast Housings","M340 Carcazas Forjadas","M340 铸造壳体","M340 주물 하우징","M340 Литые корпуса"]
["M342 Iron Casting","M342 Eisenguss","M342 Iron Casting","M342 Fundición de Hierro","M342 铸铁件","M342 철주물","M342 Чугунное литьё"]
["M343 Sintering","M343 Sintern","M343 Sintering","M343 Sinterizado","M343 粉末冶金","M343 소결","M343 Порошковая металлургия"]
["M345 Cold Forged Parts","M345 Kalt- und Fließpressen","M345 Cold Forged Parts","M345 Forjado en frío","M345 冷成型件","M345 냉간단조품","M345 Детали, изготовленные холодной формовкой (высадкой)"]
["M346 Metal Cages","M346 Metallkäfige","M346 Metal Cages","M346 Jaulas de Metal","M346 金属保持架","M346 스틸 케이지","M346 Металлические садки"]
["M347 Crank shaft decoupling Systems","M347 Kurbelwellen Entkopplungs-Systeme","M347 Crank shaft decoupling Systems","M347 Sistemas de Desacoplamiento del Cigüeñal","M347 曲轴前端减震器","M347 크랭크 샤프트 디커플링 시스템","M347 Развязывающие системы коленчатого вала"]
["M350 Stamping Parts","M350 Stanzteile","M350 Stamping Parts","M350 Estampado","M350 冲压件","M350 압조품 / 프레스 품","M350 Штампованные детали"]
["M355 Springs","M355 Technische Federn","M355 Springs","M355 Resortes","M355 弹簧","M355 스프링","M355 Пружины"]
["M360 Turned Rings","M360 Gedrehte Ringe","M360 Turned Rings","M360 Anillos Torneados","M360 车削套圈","M360 선삭 링","M360 Кольца, полученные точением"]
["M361 Turned and Milled Parts","M361 Dreh- und Frästeile","M361 Turned and Milled Parts","M361 Torneado y Fresado","M361 车铣件","M361 선삭 / 밀링 품","M361 Токарная и фрезерная обработка"]
["M362 Turned Flanges","M362 Gedrehte Flansche","M362 Turned Flanges","M362 Bridas Torneadas","M362 车削法兰","M362 선삭 플렌지","M362 Фланцы, полученные точением"]
["M366 Geared Parts","M366 Verzahnungsteile","M366 Geared Parts","M366 Piezas Dentadas / Engranes","M366 齿形部件","M366 기어류","M366 Редукторы"]
["M370 Electromechanics","M370 Elektromechanik","M370 Electromechanics","M370 Electromecánica","M370 电子机械连接件","M370 전자 기계","M370 Электромеханика"]
["M371 Electronic Modules","M371 Elektronik Module","M371 Electronic Modules","M371 Módulos Electrónicos","M371 电子控制模块","M371 전자 모듈","M371 Электронный блок"]
["M372 Motors","M372 Motoren","M372 Motors","M372 Motores","M372 电机","M372 모터","M372 Двигатели"]
["M373 Stab Bars","M373 Stabilisatoren","M373 Stab Bars","M373 Estabilizadores (barras estabilizadoras)","M373 稳定杆","M373 스탭 바","M373 Стабилизаторы"]
["M374 Electronic Component","M374 Elektronikkomponente","M374 Electronic Component","M374 Componente electrónico","M374 电子元器件","M374 전자 부품","M374 Электронные компоненты"]
["M375 Magnets / RE-metal","M375 Magnete / SE-Metall","M375 Magnets / RE-metal","M375 Imanes (metal de tierras raras)","M375 磁钢 / 稀土金属","M375 자석 / 희토류 금속","M375 Магниты / Редкоземельные металлы"]
["M376 Power Electronics","M376 Leistungselektronik","M376 Power Electronics","M376 Electrónica de potencia","M376 功率电子件","M376 전력 전자","M376 Силовая электроника"]
["M377 Sensors","M377 Sensoren","M377 Sensors","M377 Sensores","M377 传感器模块","M377 센서","M377 Сенсоры"]
["M378 Embedded Software","M378 Embedded Software","M378 Embedded Software","M378 Software integrado","M378 嵌入式软件","M378 임베디드 소프트웨어","M378 Встроенное программное обеспечение"]
["M379 PCB-Assembly / EMS","M379 PCB-Bestückung / EMS","M379 PCB-Assembly / EMS","M379 Montaje de PCB / EMS","M379 印刷电路板组件","M379 PCB조립 / EMS","M379 Монтаж печатных плат / Услуги электронного производства"]
["M380 Subcontracting PM","M380 Lohnarbeiten","M380 Subcontracting PM","M380 Servicios","M380 外协件","M380 외주 가공품","M380 Субподряд производственные материалы"]
["M381 Surface Treatment","M381 Oberflächenbeschichtung","M381 Surface Treatment","M381 Tratamientos Superficiales","M381 表面处理","M381 표면처리","M381 Покрытие (обработка поверхности)"]
["M382 Heat Treatment","M382 Wärmebehandlung","M382 Heat Treatment","M382 Tratamientos Térmicos","M382 热处理","M382 열처리","M382 Термическая обработка"]
["M383 Subcontracting Samples","M383 Lohnarbeiten  Muster/Prototypen","M383 Subcontracting Samples","M383 Muestras y Prototipos (Outsourcing)","M383 外协样品","M383 외주 샘플","M383 Образцы / прототипы произведенные по субподряду"]
["M384 Customer Control Services","M384 Kundenspez. Kontrolldiestleistungen","M384 Customer Control Services","M384 Servicios de Control Específicos del Cliente","M384 第三方服务","M384 고객 관리 서비스","M384 Службы контроля клиента"]
["M392 Traded ball-/roller bearings","M392 Handelsware","M392 Traded ball-/roller bearings","M392 Rodamientos comerciales de bolas / rodillos","M392 贸易件","M392 볼/롤러 베어링 상품","M392 Торговые шариковые и роликовые подшипники"]
["M393 Rolling Elements","M393 Wälzkörper","M393 Rolling Elements","M393 Rodamientos","M393 滚动体","M393 전동체","M393 Элементы качения"]
["M394 Plain Bearings","M394 Gleitlager","M394 Plain Bearings","M394 Rodamientos lisos","M394 滑动轴承","M394 플레인 베어링 ","M394 подшипники скольжения"]
["M396 AAM Transmission","M396 AAM Transmission","M396 AAM Transmission","M396 AAM Transmisión","M396 变速箱售后市场","M396 AAM 트랜스미션","M396 AAM трансмиссия"]
["M397 AAM Engine","M397 AAM Engine","M397 AAM Engine","M397 AAM Motor","M397 发动机售后市场","M397 AAM 엔진","M397 AAM мотор"]
["M398 AAM Chassis","M398 AAM Chassis","M398 AAM Chassis","M398 AAM Chasis","M398 底盘售后市场","M398 AAM 샤시","M398 AAM шасси"]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[{"$f":"HLOOKUP($A$2,$B$2:$H$456,ROW()-1,FALSE)","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
["Country","Land","Country","país","国家","국가","страна"]
["City","Ort","City","ciudad","城市","도시","город"]
["Egypt","Ägypten","Egypt","Egipto","埃及","이집트","Египет"]
["Albania","Albanien","Albania","Albania","阿尔巴尼亚","알바니아","Албания"]
["Algeria","Algerien","Algeria","Algeria","阿尔及利亚","알제리","Алжир"]
["Americas","Americas","Americas","Américas","美国","아메리카","Северная и Южная Америка"]
["Argentina","Argentinien","Argentina","Argentina","阿根廷","아르헨티나","Аргентина"]
["Australia","Australien","Australia","Australia","澳大利亚","호주","Австралия"]
["Belgium","Belgien","Belgium","Bélgica","比利时","벨기에","Бельгия"]
["Bosnia-Herzegovina","Bosnien und Herzegowina","Bosnia-Herzegovina","Bosnia-Herzegovina","波斯尼亚 - 黑塞哥维那","보스니아 헤르체고비나","Босния и Герцеговина"]
["Brazil","Brasilien","Brazil","Brasil","巴西","브라질","Бразилия"]
["Bulgaria","Bulgarien","Bulgaria","Bulgaria","保加利亚","불가리아","Болгария"]
["China","China","China","China","中国","중국","Китай"]
["Denmark","Dänemark","Denmark","Dinamarca","丹麦","덴마크","Дания"]
["Germany","Deutschland","Germany","Alemania","德国","독일","Германия"]
["Estonia","Estland","Estonia","Estonia","爱沙尼亚","에스토니아","Эстония"]
["Finland","Finnland","Finland","Finlandia","芬兰","핀란드","Финляндия"]
["France","Frankreich","France","Francia","法国","프랑스","Франция"]
["Greece","Griechenland","Greece","Grecia","希腊","그리스","Греция"]
["Hong Kong","Hongkong","Hong Kong","Hong Kong","香港特别行政区","홍콩","Гонконг"]
["India","Indien","India","India","印度","인도","Индия"]
["Indonesia","Indonesien","Indonesia","Indonesia","印度尼西亚","인도네시아","Индонезия"]
["Ireland","Irland","Ireland","Irlanda","爱尔兰","아일랜드","Ирландия"]
["Israel","Israel","Israel","Israel","以色列","이스라엘","Израиль"]
["Italy","Italien","Italy","Italia","意大利","이탈리아","Италия"]
["Japan","Japan","Japan","Japón","日本","일본","Япония"]
["Canada","Kanada","Canada","Canadá","加拿大","캐나다","Канада"]
["Croatia","Kroatien","Croatia","Croacia","克罗地亚","크로아티아","Хорватия"]
["Latvia","Lettland","Latvia","Letonia","拉脱维亚","라트비아","Латвия"]
["Lithuania","Litauen","Lithuania","Lituania","立陶宛","리투아니아","Литва"]
["Luxembourg","Luxemburg","Luxembourg","Luxemburgo","卢森堡","룩셈부르크","Люксембург"]
["Malaysia","Malaysia","Malaysia","Malasia","马来西亚","말레이시아","Малайзия"]
["Malta","Malta","Malta","Malta","马耳他","몰타","Мальта"]
["Morocco","Marokko","Morocco","Marruecos","摩洛哥","모로코","Марокко"]
["Macedonia","Mazedonien","Macedonia","Macedonia","马其顿","마케도니아","Македония"]
["Mexico","Mexiko","Mexico","México","墨西哥","멕시코","Мексика"]
["Montenegro","Montenegro","Montenegro","Montenegro","黑山共和国","몬테네그로","Черногория"]
["New Zealand","Neuseeland","New Zealand","Nueva Zelandia","新西兰","뉴질랜드","Новая Зеландия"]
["Netherlands","Niederlande","Netherlands","Países Bajos","荷兰","네덜란드","Нидерланды"]
["Norway","Norwegen","Norway","Noruega","挪威","노르웨이","Норвегия"]
["Austria","Österreich","Austria","Austria","奥地利","오스트리아","Австрия"]
["Philippines","Philippinen","Philippines","Filipinas","菲律宾","필리핀","Филиппины"]
["Poland","Polen","Poland","Polonia","波兰","폴란드","Польша"]
["Portugal","Portugal","Portugal","Portugal","葡萄牙","포르투갈","Португалия"]
["Romania","Rumänien","Romania","Rumania","罗马尼亚","루마니아","Румыния"]
["Russia","Russland","Russia","Rusia","俄罗斯","러시아","Россия"]
["Sweden","Schweden","Sweden","Suecia","瑞典","스웨덴","Швеция"]
["Switzerland","Schweiz","Switzerland","Suiza","瑞士","스위스","Швейцария"]
["Serbia","Serbien","Serbia","Serbia","塞尔维亚","세르비아","Сербия"]
["Singapore","Singapur","Singapore","Singapur","新加坡","싱가포르","Сингапур"]
["Slovakia","Slowakei","Slovakia","Eslovaquia","斯洛伐克","슬로바키아","Словакия"]
["Slovenia","Slowenien","Slovenia","Eslovenia","斯洛文尼亚","슬로베니아","Словения"]
["Spain","Spanien","Spain","España","西班牙","스페인","Испания"]
[{"$f":"HLOOKUP($A$2,$B$2:$H$456,ROW()-1,FALSE)","v":"South Africa"},"Südafrika","South Africa","Sudáfrica","南非","남아프리카 공화국","ЮАР"]
["South Korea","Südkorea","South Korea","Corea del Sur","韩国","대한민국","Южная Корея"]
["Taiwan","Taiwan","Taiwan","Taiwán","中国台湾","대만","Тайвань"]
["Thailand","Thailand","Thailand","Tailandia","泰国","태국","Таиланд"]
["Czech Republic","Tschechische Republik","Czech Republic","República Checa","捷克共和国","체코","Чешская Республика"]
["Tunisia","Tunesien","Tunisia","Tunisia","突尼斯","튀니지","Тунис"]
["Turkey","Türkei","Turkey","Turquía","土耳其","터키","Турция"]
["Ukraine","Ukraine","Ukraine","Ucrania","乌克兰","우크라이나","Украина"]
["Hungary","Ungarn","Hungary","Hungría","匈牙利","헝가리","Венгрия"]
["USA","USA","USA","EE.UU.","美国","미국","США"]
["United Arab Emirates","Vereinigte Arabische Emirate","United Arab Emirates","Emiratos Árabes Unidos","阿拉伯酋长国","아랍에미리트","ОАЭ"]
["United Kingdom","Vereinigtes Königreich","United Kingdom","Reino Unido","英国","영국","Великобритания"]
["Vietnam","Vietnam","Vietnam","Vietnam","越南","베트남","Вьетнам"]
["Belarus","Weißrussland","Belarus","Bielorrusia","白俄罗斯","벨로루시","Беларусь"]
["Cyprus","Zypern","Cyprus","Chipre","塞浦路斯","키프로스","Кипр"]
[0]
[0]
[0]
[0]
[0]
[0]