{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Summary Table","MOLEX","WALDOM"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"Summary Table","index":0,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,21,0,22]]}
["Spalte1","Supplier","Notes","Spalte2","PN","Requested Volume (pcs)","Offered Volume (pcs)","Selling Price (EUR/100 pcs)","Selling Volume (EUR/100 pcs)","QTY In-Stock (Ships Now)","QTY Ships in 7 Days","Lead Time (Weeks)","MOQ (pcs)","SPQ (pcs)","Purchasing price/100 pcs","Purchasing VOLUME/EUR","Price Note","Margin","IF","kontrola",null,"Rocny obrat",null,"Margin","Supplier","IF"]
[null,"Molex",null,1,123,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E2,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":100},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E2,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M2,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E2,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":100},{"$f":"IFERROR(O2/(1-R2)*(1+S2),0)","v":6.3437499999999991},{"$f":"IFERROR(G2*H2/100,0)","v":6.3437499999999991},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E2,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E2,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":2},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E2,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":100},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E2,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":100},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E2,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":5},{"$f":"IFERROR(O2*G2/100,0)","v":5},null,{"$f":"_xlfn.IFS(P2<=W$2,X$2,P2<=W$3,X$3,P2<=W$4,X$4,P2<=W5,X$5,P2>W$6,X$6)","v":0.2},{"$f":"VLOOKUP(B2,Y$2:Z$14,2,0)","v":1.4999999999999999E-2},{"$f":"IFERROR(H2/O2,0)","v":1.2687499999999998},null,"do",2000,0.2,"Molex",1.4999999999999999E-2]
[null,"Waldom",null,2,1234,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E3,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":200},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E3,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M3,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E3,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":200},6.3125,12.625,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E3,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":1},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E3,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E3,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":1},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E3,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":200},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E3,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":200},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E3,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":5},10,null,{"$f":"_xlfn.IFS(P3<=W$2,X$2,P3<=W$3,X$3,P3<=W$4,X$4,P3<=W6,X$5,P3>W$6,X$6)","v":0.2},{"$f":"VLOOKUP(B3,Y$2:Z$14,2,0)","v":0.01},1.2625,null,"do",4000,0.17,"Waldom",0.01]
[null,"Molex",null,3,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E4,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E4,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M4,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E4,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},{"$f":"IFERROR(O4/(1-R4)*(1+S4),0)","v":0},{"$f":"IFERROR(G4*H4/100,0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E4,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E4,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E4,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E4,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E4,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,{"$f":"_xlfn.IFS(P4<=W$2,X$2,P4<=W$3,X$3,P4<=W$4,X$4,P4<=W7,X$5,P4>W$6,X$6)","v":0.2},{"$f":"VLOOKUP(B4,Y$2:Z$14,2,0)","v":1.4999999999999999E-2},{"$f":"IFERROR(H4/O4,0)","v":0},null,"do",6000,0.15,"A-ICC",5.0000000000000001E-3]
[null,"Waldom",null,4,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E5,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E5,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M5,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E5,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E5,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E5,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E5,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E5,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E5,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E5,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0,null,"do",8000,0.12,"A-FCI",5.0000000000000001E-3]
[null,"Molex",null,5,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E6,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E6,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M6,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E6,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E6,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E6,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E6,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E6,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E6,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0,null,"nad",8000,0.12,"A-TUCHEL",0.02]
[null,"Waldom",null,6,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E7,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E7,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M7,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E7,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E7,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E7,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E7,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E7,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E7,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E7,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0,null,null,null,null,"A-LTW",0.13]
[null,"Molex",null,7,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E8,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E8,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M8,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E8,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E8,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E8,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E8,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E8,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E8,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0,null,null,null,null,"A-M-AirLB",0]
[null,"Waldom",null,8,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E9,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E9,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M9,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E9,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E9,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E9,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E9,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E9,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E9,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E9,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0,null,null,null,null,"A-M-AirLBFr",0.01]
[null,"Molex",null,9,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E10,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E10,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M10,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E10,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E10,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E10,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E10,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E10,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E10,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0,null,null,null,null,"PTR",1.4999999999999999E-2]
[null,"Waldom",null,10,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E11,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E11,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M11,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E11,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E11,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E11,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E11,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E11,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E11,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E11,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0,null,null,null,null,"Sharp",5.0000000000000001E-3]
[null,"Molex",null,11,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E12,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E12,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M12,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E12,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E12,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E12,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E12,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E12,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E12,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0,null,null,null,null,"FederalMogul",0]
[null,"Waldom",null,12,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E13,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E13,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M13,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E13,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E13,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E13,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E13,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E13,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E13,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E13,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0,null,null,null,null,"Cinch GB",1.4999999999999999E-2]
[null,"Molex",null,13,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E14,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E14,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M14,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E14,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E14,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E14,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E14,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E14,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E14,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0,null,null,null,null,"Cinch US",0.45]
[null,"Waldom",null,14,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E15,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E15,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M15,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E15,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E15,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E15,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E15,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E15,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E15,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E15,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0]
[null,"Molex",null,15,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E16,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E16,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M16,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E16,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E16,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E16,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E16,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E16,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E16,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0]
[null,"Waldom",null,16,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E17,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E17,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M17,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E17,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E17,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E17,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E17,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E17,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E17,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E17,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0]
[null,"Molex",null,17,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E18,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E18,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M18,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E18,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E18,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E18,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E18,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E18,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E18,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0]
[null,"Waldom",null,18,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E19,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E19,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M19,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E19,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E19,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E19,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E19,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E19,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E19,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E19,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0]
[null,"Molex",null,19,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E20,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E20,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M20,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E20,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E20,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E20,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E20,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E20,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E20,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0]
[null,"Waldom",null,20,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E21,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E21,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M21,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E21,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E21,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E21,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E21,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E21,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E21,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E21,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0]
[null,"Molex",null,21,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E22,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E22,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M22,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E22,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E22,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E22,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E22,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E22,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E22,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0]
[null,"Waldom",null,22,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E23,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E23,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M23,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E23,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E23,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E23,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E23,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E23,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E23,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E23,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0]
[null,"Molex",null,23,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E24,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E24,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M24,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E24,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E24,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E24,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E24,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E24,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E24,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0]
[null,"Waldom",null,24,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E25,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E25,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M25,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E25,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E25,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E25,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E25,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E25,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E25,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E25,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0]
[null,"Molex",null,25,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E26,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E26,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M26,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E26,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E26,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E26,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E26,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E26,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E26,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0]
[null,"Waldom",null,26,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E27,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E27,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M27,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E27,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E27,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E27,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E27,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E27,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E27,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E27,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0]
[null,"Molex",null,27,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E28,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E28,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M28,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E28,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E28,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E28,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E28,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E28,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E28,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0]
[null,"Waldom",null,28,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E29,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E29,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M29,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E29,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E29,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E29,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E29,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E29,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E29,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E29,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0]
[null,"Molex",null,29,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E30,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E30,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M30,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E30,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E30,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E30,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E30,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E30,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E30,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0]
[null,"Waldom",null,30,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E31,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E31,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M31,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E31,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E31,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E31,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E31,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E31,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E31,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E31,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0]
[null,"Molex",null,31,null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E32,Tabelle1[#All],MATCH(F$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E32,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0)>=M32,IFERROR(IF($B$2:$B$330=\"Molex\",VLOOKUP($E32,Tabelle1[#All],MATCH(G$1,Tabelle1[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E32,Tabelle1[#All],MATCH(J$1,Tabelle1[#Headers],0),0),0),0)","v":0},null,{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E32,Tabelle1[#All],MATCH(L$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E32,Tabelle1[#All],MATCH(M$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E32,Tabelle1[#All],MATCH(N$1,Tabelle1[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$329=\"Molex\",VLOOKUP($E32,Tabelle1[#All],MATCH(O$1,Tabelle1[#Headers],0),0),0),0)","v":0},0,null,0.2,1.4999999999999999E-2,0]
[null,"Waldom",null,32,null,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E33,Tabelle2[#All],MATCH(F$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IF(IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E33,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0)>=M33,IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E33,Tabelle2[#All],MATCH(G$1,Tabelle2[#Headers],0),0),0),0),\"Pod MOQ\")","v":0},0,0,{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E33,Tabelle2[#All],MATCH(J$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E33,Tabelle2[#All],MATCH(#REF!,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E33,Tabelle2[#All],MATCH(L$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E33,Tabelle2[#All],MATCH(M$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E33,Tabelle2[#All],MATCH(N$1,Tabelle2[#Headers],0),0),0),0)","v":0},{"$f":"IFERROR(IF($B$2:$B$330=\"Waldom\",VLOOKUP($E33,Tabelle2[#All],MATCH(O$1,Tabelle2[#Headers],0),0),0),0)","v":0},0,null,0.2,0.01,0]
[null,"Molex",null,33,null,null,null,0,0,null,null,null,null,null,null,0,null,0.2,1.4999999999999999E-2,0]
[null,"Waldom",null,34,null,null,null,0,0,null,null,null,null,null,null,0,null,0.2,0.01,0]
[null,"Molex",null,35,null,null,null,{"$f":"IFERROR(O36/(1-R36)*(1+S36),0)","v":0},{"$f":"IFERROR(G36*H36/100,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(O36*G36/100,0)","v":0},null,{"$f":"_xlfn.IFS(P36<=W$2,X$2,P36<=W$3,X$3,P36<=W$4,X$4,P36<=W39,X$5,P36>W$6,X$6)","v":0.2},{"$f":"VLOOKUP(B36,Y$2:Z$14,2,0)","v":1.4999999999999999E-2},{"$f":"IFERROR(H36/O36,0)","v":0}]
[null,"Waldom",null,36,null,null,null,0,0,null,null,null,null,null,null,0,null,0.2,0.01,0]
[null,"Molex",null,37,null,null,null,{"$f":"IFERROR(O38/(1-R38)*(1+S38),0)","v":0},{"$f":"IFERROR(G38*H38/100,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(O38*G38/100,0)","v":0},null,{"$f":"_xlfn.IFS(P38<=W$2,X$2,P38<=W$3,X$3,P38<=W$4,X$4,P38<=W41,X$5,P38>W$6,X$6)","v":0.2},{"$f":"VLOOKUP(B38,Y$2:Z$14,2,0)","v":1.4999999999999999E-2},{"$f":"IFERROR(H38/O38,0)","v":0}]
[null,"Waldom",null,38,null,null,null,0,0,null,null,null,null,null,null,0,null,0.2,0.01,0]
["Ergebnis"]

{"sheet":"MOLEX","index":1,"n_rows":21,"n_cols":57,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,4,2]]}
[]
[]
[]
[]
[]
["PN","Eng.No / Old PN","Requested Volume (pcs)","Offered Volume (pcs)","MOQ (pcs)","SPQ (pcs)","Purchasing price/100 pcs","Quantity 1","Price 1","Quantity 2","Price 2","Quantity 3","Price 3","Quantity 4","Price 4","Quantity 5","Price 5","Quantity 6","Price 6","Quantity 7","Price 7","Quantity 8","Price 8","Quantity 9","Price 9","Message","Description","Sales Status","Sales Text","Design Registerable","Country Of Origin","Customer Material","Lead-Time(work) Days","Lead Time (Weeks)","Delivery Plant","Est Ship Date","MLQ","DU","PPQ","Net Value","QTY In-Stock (Ships Now)","U/M","Price Per","Currency","Contract Type","Contract No.","Contract Price","Contract Price Per","Contract Start Date","Contract End Date","Customer/Partner","EU RoHS Status","Series","UPC","Pricing Code","Net Price","Resale Price"]
[123,null,100,100,100,{"$f":"AL7","v":100},{"$f":"IFERROR(INDEX(H7:Y7,(INT(MATCH(D7,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H7:Y7<>0),H7:Y7),1)/2)+1)*2)/10,0)","v":5},20,10,40,20,60,30,80,40,100,50,120,60,250,70,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,100,100]
[null,null,null,null,{"$f":"AK8","v":0},{"$f":"AL8","v":0},{"$f":"IFERROR(INDEX(H8:Y8,(INT(MATCH(D8,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H8:Y8<>0),H8:Y8),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H9:Y9,(INT(MATCH(D9,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H9:Y9<>0),H9:Y9),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H10:Y10,(INT(MATCH(D10,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H10:Y10<>0),H10:Y10),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H11:Y11,(INT(MATCH(D11,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H11:Y11<>0),H11:Y11),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H12:Y12,(INT(MATCH(D12,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H12:Y12<>0),H12:Y12),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H13:Y13,(INT(MATCH(D13,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H13:Y13<>0),H13:Y13),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H14:Y14,(INT(MATCH(D14,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H14:Y14<>0),H14:Y14),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H15:Y15,(INT(MATCH(D15,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H15:Y15<>0),H15:Y15),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H16:Y16,(INT(MATCH(D16,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H16:Y16<>0),H16:Y16),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H17:Y17,(INT(MATCH(D17,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H17:Y17<>0),H17:Y17),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H18:Y18,(INT(MATCH(D18,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H18:Y18<>0),H18:Y18),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H19:Y19,(INT(MATCH(D19,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H19:Y19<>0),H19:Y19),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H20:Y20,(INT(MATCH(D20,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H20:Y20<>0),H20:Y20),1)/2)+1)*2)/10,0)","v":0}]
[null,null,null,null,0,0,{"$f":"IFERROR(INDEX(H21:Y21,(INT(MATCH(D21,IF((LEFT($H$6:$Y$6,8)=\"Quantity\")*(H21:Y21<>0),H21:Y21),1)/2)+1)*2)/10,0)","v":0}]

{"sheet":"WALDOM","index":2,"n_rows":24,"n_cols":35,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Waldom Quote Number:","R63010-0049-RRA","Waldom Contact:","Ronny Asmus"]
["Quote Name/ Reference:","Lukas Pollak","Waldom Email Address:","ronny.asmus@waldom.com"]
["Quote Date:","02/10/2021","Waldom Phone Number:","+31 (0) 208912740"]
["Quote Expiration Date:","03/10/2021"]
["Customer Name:","Burisch Elektronik Bauteile"]
["Customer Contact Name:","Lukas Pollak"]
[]
["PN","Manufacturer","Customer Part Number","Requested Volume (pcs)","Offered Volume (pcs)","MOQ (pcs)","SPQ (pcs)","Purchasing price/100 pcs","Extension","Comments","QTY In-Stock (Ships Now)","QTY Ships in 7 Days","QTY Ships in 10 Days","QTY Ships in 14 Days","QTY On Order","Qty On Order Due Date (DD/MM/YYYY)","Lead Time (Weeks)","Quantity 1","Price 1","Quantity 2","Price 2","Quantity 3","Price 3","Quantity 4","Price 4","Quantity 5","Price 5","Quantity 6","Price 6","Quantity 7","Price 7","Quantity 8","Price 8","Quantity 9","Price 9"]
[1234,"MOLEX ELECTRONICS",null,200,200,200,200,{"$f":"IFERROR(INDEX(R10:AI10,(INT(MATCH(E10,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R10:AI10<>0),R10:AI10),1)/2)+1)*2)*100,0)","v":5},null,null,1,1,null,1,1,null,1,10,0.01,50,0.02,100,0.03,150,0.04,200,0.05,300,0.06]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R11:AI11,(INT(MATCH(E11,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R11:AI11<>0),R11:AI11),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R12:AI12,(INT(MATCH(E12,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R12:AI12<>0),R12:AI12),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R13:AI13,(INT(MATCH(E13,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R13:AI13<>0),R13:AI13),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R14:AI14,(INT(MATCH(E14,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R14:AI14<>0),R14:AI14),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R15:AI15,(INT(MATCH(E15,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R15:AI15<>0),R15:AI15),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R16:AI16,(INT(MATCH(E16,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R16:AI16<>0),R16:AI16),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R17:AI17,(INT(MATCH(E17,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R17:AI17<>0),R17:AI17),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R18:AI18,(INT(MATCH(E18,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R18:AI18<>0),R18:AI18),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R19:AI19,(INT(MATCH(E19,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R19:AI19<>0),R19:AI19),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R20:AI20,(INT(MATCH(E20,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R20:AI20<>0),R20:AI20),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R21:AI21,(INT(MATCH(E21,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R21:AI21<>0),R21:AI21),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R22:AI22,(INT(MATCH(E22,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R22:AI22<>0),R22:AI22),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R23:AI23,(INT(MATCH(E23,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R23:AI23<>0),R23:AI23),1)/2)+1)*2)*100,0)","v":0}]
[null,"MOLEX ELECTRONICS",null,null,null,null,null,{"$f":"IFERROR(INDEX(R24:AI24,(INT(MATCH(E24,IF((LEFT($R$9:$AI$9,8)=\"Quantity\")*(R24:AI24<>0),R24:AI24),1)/2)+1)*2)*100,0)","v":0}]