{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","Inject","Input"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,3,1,5],[2,3,2,5]]}
[null,"Injection Molded Plastic Part Cost Estimator"]
[null,"Design Organization",null,"Mechanical Design Process",null,null,null,null,"Date"]
[null,"Part Evaluated",null,"Part on page 326 4th edition"]
[]
[null,"Shape of part",null,null,"Part complexity",null,null,"What finish?"]
[]
[]
[]
[null,"Units",null,null,"What tolerance?",null,null,"What material?"]
[]
[]
[]
[null,{"$f":"IF(Input!A$5=3,\"Diamerter\", \"Length\")","v":"Length"},null,3.7]
[null,{"$f":"IF(Input!A$5=3,\"\", \"Width\")","v":"Width"},null,1.77]
[null,"Depth into mold",null,1.6,null,"Number of mold cavities",{"$f":"ROUNDDOWN(Inject!O23,0)","v":3}]
[null,"Wall thickness",null,0.1,null,"Total mold cost",{"$f":"Inject!O28","v":89251.791960430477},"$"]
[null,"Parts to be made",null,1000000,null,"Cycle time per heat",{"$f":"Inject!O14/G15","v":2.4060939428196817},"sec"]
[null,"Hourly rate",null,35,"$","working cost per part",{"$f":"Inject!O32","v":4.8612408241394796E-2},"hr"]
[null,null,null,null,null,"mold cost per part",{"$f":"Inject!O29","v":8.9251791960430482E-2},"$"]
[null,null,null,null,null,"Cost of material/part",{"$f":"Inject!O11","v":6.4771650215999996E-2},"$"]
[null,"Results",null,null,null,"working cost per part",{"$f":"Inject!O32","v":4.8612408241394796E-2},"$"]
[null,null,null,null,null,"Total cost",{"$f":"Inject!O33","v":0.27486420020182528},"$"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The Mechanical Design Process",null,null,null,null,"Designed by Professor David G. Ullman"]
[null,"Copyright 2008, McGraw Hill",null,null,null,null,"Form # 15.0"]

{"sheet":"Inject","index":1,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Mill"]
["L ",null,null,{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7},{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7},{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7},{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7},{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7},{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7},{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7},{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7},{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7},{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7},{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7},{"$f":"IF(Input!$A$13=1,Main!$D13, Main!$D13/2.54)","v":3.7}]
["W ",null,null,{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77},{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77},{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77},{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77},{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77},{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77},{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77},{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77},{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77},{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77},{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77},{"$f":"IF(Input!$A$13=1,Main!$D14, Main!$D14/2.54)","v":1.77}]
["D ",null,null,{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6},{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6},{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6},{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6},{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6},{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6},{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6},{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6},{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6},{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6},{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6},{"$f":"IF(Input!$A$13=1,Main!$D15, Main!$D15/2.54)","v":1.6}]
["H",null,null,{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1},{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1},{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1},{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1},{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1},{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1},{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1},{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1},{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1},{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1},{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1},{"$f":"IF(Input!$A$13=1,Main!$D16, Main!$D16/2.54)","v":0.1}]
["NT","Number of parts",null,100,250,500,1000,5000,10000,50000,100000,500000,1000000,10000000,{"$f":"Main!D17","v":1000000}]
["AP","projected area",null,{"$f":"IF(Input!$A5=1,D2*D3,IF(Input!$A5=2,D2*D3,0.785*D2^2))","v":6.5490000000000004},{"$f":"IF(Input!$A5=1,E2*E3,IF(Input!$A5=2,E2*E3,0.785*E2^2))","v":6.5490000000000004},{"$f":"IF(Input!$A5=1,F2*F3,IF(Input!$A5=2,F2*F3,0.785*F2^2))","v":6.5490000000000004},{"$f":"IF(Input!$A5=1,G2*G3,IF(Input!$A5=2,G2*G3,0.785*G2^2))","v":6.5490000000000004},{"$f":"IF(Input!$A5=1,H2*H3,IF(Input!$A5=2,H2*H3,0.785*H2^2))","v":6.5490000000000004},{"$f":"IF(Input!$A5=1,I2*I3,IF(Input!$A5=2,I2*I3,0.785*I2^2))","v":6.5490000000000004},{"$f":"IF(Input!$A5=1,J2*J3,IF(Input!$A5=2,J2*J3,0.785*J2^2))","v":6.5490000000000004},{"$f":"IF(Input!$A5=1,K2*K3,IF(Input!$A5=2,K2*K3,0.785*K2^2))","v":6.5490000000000004},{"$f":"IF(Input!$A5=1,L2*L3,IF(Input!$A5=2,L2*L3,0.785*L2^2))","v":6.5490000000000004},{"$f":"IF(Input!$A5=1,M2*M3,IF(Input!$A5=2,M2*M3,0.785*M2^2))","v":6.5490000000000004},{"$f":"IF(Input!$A5=1,N2*N3,IF(Input!$A5=2,N2*N3,0.785*N2^2))","v":6.5490000000000004},{"$f":"IF(Input!$A5=1,O2*O3,IF(Input!$A5=2,O2*O3,0.785*O2^2))","v":6.5490000000000004}]
["SP","Surface area",null,{"$f":"IF(Input!$A5=1,2*D2*D3,IF(Input!$A5=2,D2*D3+D2*D4+D3*D4,3.14*D2*D4+3.14*D2^2/4))","v":15.301000000000002},{"$f":"IF(Input!$A5=1,2*E2*E3,IF(Input!$A5=2,E2*E3+E2*E4+E3*E4,3.14*E2*E4+3.14*E2^2/4))","v":15.301000000000002},{"$f":"IF(Input!$A5=1,2*F2*F3,IF(Input!$A5=2,F2*F3+F2*F4+F3*F4,3.14*F2*F4+3.14*F2^2/4))","v":15.301000000000002},{"$f":"IF(Input!$A5=1,2*G2*G3,IF(Input!$A5=2,G2*G3+G2*G4+G3*G4,3.14*G2*G4+3.14*G2^2/4))","v":15.301000000000002},{"$f":"IF(Input!$A5=1,2*H2*H3,IF(Input!$A5=2,H2*H3+H2*H4+H3*H4,3.14*H2*H4+3.14*H2^2/4))","v":15.301000000000002},{"$f":"IF(Input!$A5=1,2*I2*I3,IF(Input!$A5=2,I2*I3+I2*I4+I3*I4,3.14*I2*I4+3.14*I2^2/4))","v":15.301000000000002},{"$f":"IF(Input!$A5=1,2*J2*J3,IF(Input!$A5=2,J2*J3+J2*J4+J3*J4,3.14*J2*J4+3.14*J2^2/4))","v":15.301000000000002},{"$f":"IF(Input!$A5=1,2*K2*K3,IF(Input!$A5=2,K2*K3+K2*K4+K3*K4,3.14*K2*K4+3.14*K2^2/4))","v":15.301000000000002},{"$f":"IF(Input!$A5=1,2*L2*L3,IF(Input!$A5=2,L2*L3+L2*L4+L3*L4,3.14*L2*L4+3.14*L2^2/4))","v":15.301000000000002},{"$f":"IF(Input!$A5=1,2*M2*M3,IF(Input!$A5=2,M2*M3+M2*M4+M3*M4,3.14*M2*M4+3.14*M2^2/4))","v":15.301000000000002},{"$f":"IF(Input!$A5=1,2*N2*N3,IF(Input!$A5=2,N2*N3+N2*N4+N3*N4,3.14*N2*N4+3.14*N2^2/4))","v":15.301000000000002},{"$f":"IF(Input!$A5=1,2*O2*O3,IF(Input!$A5=2,O2*O3+O2*O4+O3*O4,3.14*O2*O4+3.14*O2^2/4))","v":15.301000000000002}]
["TR","Resetting time",null,{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5},{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5},{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5},{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5},{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5},{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5},{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5},{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5},{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5},{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5},{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5},{"$f":"IF(Input!$A5=1,3,IF(Input!$A5=2,5,7))","v":5}]
["Volume",null,null,{"$f":"IF(Input!$A5=1,(1.15*D2*D3*D5),IF(Input!$A5=2,(1.2*(D2*D3+2*D4*(D2+D3))*D5),(1.2*(3.1415*D3^2/4+3.1415*D3*D4)*D5)))","v":2.8863599999999998},{"$f":"IF(Input!$A5=1,(1.15*E2*E3*E5),IF(Input!$A5=2,(1.2*(E2*E3+2*E4*(E2+E3))*E5),(1.2*(3.1415*E3^2/4+3.1415*E3*E4)*E5)))","v":2.8863599999999998},{"$f":"IF(Input!$A5=1,(1.15*F2*F3*F5),IF(Input!$A5=2,(1.2*(F2*F3+2*F4*(F2+F3))*F5),(1.2*(3.1415*F3^2/4+3.1415*F3*F4)*F5)))","v":2.8863599999999998},{"$f":"IF(Input!$A5=1,(1.15*G2*G3*G5),IF(Input!$A5=2,(1.2*(G2*G3+2*G4*(G2+G3))*G5),(1.2*(3.1415*G3^2/4+3.1415*G3*G4)*G5)))","v":2.8863599999999998},{"$f":"IF(Input!$A5=1,(1.15*H2*H3*H5),IF(Input!$A5=2,(1.2*(H2*H3+2*H4*(H2+H3))*H5),(1.2*(3.1415*H3^2/4+3.1415*H3*H4)*H5)))","v":2.8863599999999998},{"$f":"IF(Input!$A5=1,(1.15*I2*I3*I5),IF(Input!$A5=2,(1.2*(I2*I3+2*I4*(I2+I3))*I5),(1.2*(3.1415*I3^2/4+3.1415*I3*I4)*I5)))","v":2.8863599999999998},{"$f":"IF(Input!$A5=1,(1.15*J2*J3*J5),IF(Input!$A5=2,(1.2*(J2*J3+2*J4*(J2+J3))*J5),(1.2*(3.1415*J3^2/4+3.1415*J3*J4)*J5)))","v":2.8863599999999998},{"$f":"IF(Input!$A5=1,(1.15*K2*K3*K5),IF(Input!$A5=2,(1.2*(K2*K3+2*K4*(K2+K3))*K5),(1.2*(3.1415*K3^2/4+3.1415*K3*K4)*K5)))","v":2.8863599999999998},{"$f":"IF(Input!$A5=1,(1.15*L2*L3*L5),IF(Input!$A5=2,(1.2*(L2*L3+2*L4*(L2+L3))*L5),(1.2*(3.1415*L3^2/4+3.1415*L3*L4)*L5)))","v":2.8863599999999998},{"$f":"IF(Input!$A5=1,(1.15*M2*M3*M5),IF(Input!$A5=2,(1.2*(M2*M3+2*M4*(M2+M3))*M5),(1.2*(3.1415*M3^2/4+3.1415*M3*M4)*M5)))","v":2.8863599999999998},{"$f":"IF(Input!$A5=1,(1.15*N2*N3*N5),IF(Input!$A5=2,(1.2*(N2*N3+2*N4*(N2+N3))*N5),(1.2*(3.1415*N3^2/4+3.1415*N3*N4)*N5)))","v":2.8863599999999998},{"$f":"IF(Input!$A5=1,(1.15*O2*O3*O5),IF(Input!$A5=2,(1.2*(O2*O3+2*O4*(O2+O3))*O5),(1.2*(3.1415*O3^2/4+3.1415*O3*O4)*O5)))","v":2.8863599999999998}]
["MATCOS","cost of material",null,{"$f":"Input!$A31*D10","v":6.4771650215999996E-2},{"$f":"Input!$A31*E10","v":6.4771650215999996E-2},{"$f":"Input!$A31*F10","v":6.4771650215999996E-2},{"$f":"Input!$A31*G10","v":6.4771650215999996E-2},{"$f":"Input!$A31*H10","v":6.4771650215999996E-2},{"$f":"Input!$A31*I10","v":6.4771650215999996E-2},{"$f":"Input!$A31*J10","v":6.4771650215999996E-2},{"$f":"Input!$A31*K10","v":6.4771650215999996E-2},{"$f":"Input!$A31*L10","v":6.4771650215999996E-2},{"$f":"Input!$A31*M10","v":6.4771650215999996E-2},{"$f":"Input!$A31*N10","v":6.4771650215999996E-2},{"$f":"Input!$A31*O10","v":6.4771650215999996E-2}]
["TF","filling time",null,{"$f":"D9*0.1","v":0.5},{"$f":"E9*0.1","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,{"$f":"L9*0.1","v":0.5},{"$f":"M9*0.1","v":0.5},{"$f":"N9*0.1","v":0.5},0.5]
["TC","cooling time",null,{"$f":"IF(Input!$A28=1,1.1*(D5*10)^2.1,IF(Input!$A28=2,(D5*10)^2,IF(Input!$A28=3,0.92*(D5*10)^2,IF(Input!$A28=4,2.4*(D5*10)^1.9,EXP(D5*10)-1))))","v":1.7182818284590451},{"$f":"IF(Input!$A28=1,1.1*(E5*10)^2.1,IF(Input!$A28=2,(E5*10)^2,IF(Input!$A28=3,0.92*(E5*10)^2,IF(Input!$A28=4,2.4*(E5*10)^1.9,EXP(E5*10)-1))))","v":1.7182818284590451},{"$f":"IF(Input!$A28=1,1.1*(F5*10)^2.1,IF(Input!$A28=2,(F5*10)^2,IF(Input!$A28=3,0.92*(F5*10)^2,IF(Input!$A28=4,2.4*(F5*10)^1.9,EXP(F5*10)-1))))","v":1.7182818284590451},{"$f":"IF(Input!$A28=1,1.1*(G5*10)^2.1,IF(Input!$A28=2,(G5*10)^2,IF(Input!$A28=3,0.92*(G5*10)^2,IF(Input!$A28=4,2.4*(G5*10)^1.9,EXP(G5*10)-1))))","v":1.7182818284590451},{"$f":"IF(Input!$A28=1,1.1*(H5*10)^2.1,IF(Input!$A28=2,(H5*10)^2,IF(Input!$A28=3,0.92*(H5*10)^2,IF(Input!$A28=4,2.4*(H5*10)^1.9,EXP(H5*10)-1))))","v":1.7182818284590451},{"$f":"IF(Input!$A28=1,1.1*(I5*10)^2.1,IF(Input!$A28=2,(I5*10)^2,IF(Input!$A28=3,0.92*(I5*10)^2,IF(Input!$A28=4,2.4*(I5*10)^1.9,EXP(I5*10)-1))))","v":1.7182818284590451},{"$f":"IF(Input!$A28=1,1.1*(J5*10)^2.1,IF(Input!$A28=2,(J5*10)^2,IF(Input!$A28=3,0.92*(J5*10)^2,IF(Input!$A28=4,2.4*(J5*10)^1.9,EXP(J5*10)-1))))","v":1.7182818284590451},{"$f":"IF(Input!$A28=1,1.1*(K5*10)^2.1,IF(Input!$A28=2,(K5*10)^2,IF(Input!$A28=3,0.92*(K5*10)^2,IF(Input!$A28=4,2.4*(K5*10)^1.9,EXP(K5*10)-1))))","v":1.7182818284590451},{"$f":"IF(Input!$A28=1,1.1*(L5*10)^2.1,IF(Input!$A28=2,(L5*10)^2,IF(Input!$A28=3,0.92*(L5*10)^2,IF(Input!$A28=4,2.4*(L5*10)^1.9,EXP(L5*10)-1))))","v":1.7182818284590451},{"$f":"IF(Input!$A28=1,1.1*(M5*10)^2.1,IF(Input!$A28=2,(M5*10)^2,IF(Input!$A28=3,0.92*(M5*10)^2,IF(Input!$A28=4,2.4*(M5*10)^1.9,EXP(M5*10)-1))))","v":1.7182818284590451},{"$f":"IF(Input!$A28=1,1.1*(N5*10)^2.1,IF(Input!$A28=2,(N5*10)^2,IF(Input!$A28=3,0.92*(N5*10)^2,IF(Input!$A28=4,2.4*(N5*10)^1.9,EXP(N5*10)-1))))","v":1.7182818284590451},{"$f":"IF(Input!$A28=1,1.1*(O5*10)^2.1,IF(Input!$A28=2,(O5*10)^2,IF(Input!$A28=3,0.92*(O5*10)^2,IF(Input!$A28=4,2.4*(O5*10)^1.9,EXP(O5*10)-1))))","v":1.7182818284590451}]
["TMAC","cycle time",null,{"$f":"D9+D12+D13","v":7.2182818284590446},7.2182818284590446,7.2182818284590446,7.2182818284590446,7.2182818284590446,7.2182818284590446,7.2182818284590446,7.2182818284590446,7.2182818284590446,7.2182818284590446,7.2182818284590446,7.2182818284590446]
["AT ","size effect",null,{"$f":"5+0.25*(100*D7)^0.5+0.2*D7","v":12.707553511975902},{"$f":"5+0.25*(100*E7)^0.5+0.2*E7","v":12.707553511975902},12.707553511975902,12.707553511975902,12.707553511975902,12.707553511975902,12.707553511975902,12.707553511975902,{"$f":"5+0.25*(100*L7)^0.5+0.2*L7","v":12.707553511975902},{"$f":"5+0.25*(100*M7)^0.5+0.2*M7","v":12.707553511975902},{"$f":"5+0.25*(100*N7)^0.5+0.2*N7","v":12.707553511975902},12.707553511975902]
["TX ","texture score",null,{"$f":"0.025*(D15+Input!$C9)","v":4.6301888377993974},{"$f":"0.025*(E15+Input!$C9)","v":4.6301888377993974},{"$f":"0.025*(F15+Input!$C9)","v":4.6301888377993974},{"$f":"0.025*(G15+Input!$C9)","v":4.6301888377993974},{"$f":"0.025*(H15+Input!$C9)","v":4.6301888377993974},{"$f":"0.025*(I15+Input!$C9)","v":4.6301888377993974},{"$f":"0.025*(J15+Input!$C9)","v":4.6301888377993974},{"$f":"0.025*(K15+Input!$C9)","v":4.6301888377993974},{"$f":"0.025*(L15+Input!$C9)","v":4.6301888377993974},{"$f":"0.025*(M15+Input!$C9)","v":4.6301888377993974},{"$f":"0.025*(N15+Input!$C9)","v":4.6301888377993974},{"$f":"0.025*(O15+Input!$C9)","v":4.6301888377993974}]
["TT","tolerance dependence",null,{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5},{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5},{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5},{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5},{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5},{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5},{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5},{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5},{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5},{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5},{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5},{"$f":"IF(AND(Input!$A$9=1,Input!$A$17=1),1.5,IF(AND(Input!$A$9=1,Input!$A$17=2),7.5,IF(AND(Input!$A$9=1,Input!$A$17=3),18.75,IF(AND(Input!$A$9=2,Input!$A$17=1),3.5,IF(AND(Input!$A$9=2,Input!$A$17=2),17.5,IF(AND(Input!$A$9=2,Input!$A$17=3),43.7,IF(Input!$A$17=1,5.5,IF(Input!$A$17=2,27.5,68.75))))))))","v":17.5}]
["TH ","finish dependence",null,{"$f":"IF(Input!$A21=1,(1.5*0.035*10*D8^0.5),IF(Input!$A21=2,(1.5*0.06*10*D8^0.5),1.5*0.1*10*D8^0.5))","v":2.0536158659788351},{"$f":"IF(Input!$A21=1,(1.5*0.035*10*E8^0.5),IF(Input!$A21=2,(1.5*0.06*10*E8^0.5),1.5*0.1*10*E8^0.5))","v":2.0536158659788351},{"$f":"IF(Input!$A21=1,(1.5*0.035*10*F8^0.5),IF(Input!$A21=2,(1.5*0.06*10*F8^0.5),1.5*0.1*10*F8^0.5))","v":2.0536158659788351},{"$f":"IF(Input!$A21=1,(1.5*0.035*10*G8^0.5),IF(Input!$A21=2,(1.5*0.06*10*G8^0.5),1.5*0.1*10*G8^0.5))","v":2.0536158659788351},{"$f":"IF(Input!$A21=1,(1.5*0.035*10*H8^0.5),IF(Input!$A21=2,(1.5*0.06*10*H8^0.5),1.5*0.1*10*H8^0.5))","v":2.0536158659788351},{"$f":"IF(Input!$A21=1,(1.5*0.035*10*I8^0.5),IF(Input!$A21=2,(1.5*0.06*10*I8^0.5),1.5*0.1*10*I8^0.5))","v":2.0536158659788351},{"$f":"IF(Input!$A21=1,(1.5*0.035*10*J8^0.5),IF(Input!$A21=2,(1.5*0.06*10*J8^0.5),1.5*0.1*10*J8^0.5))","v":2.0536158659788351},{"$f":"IF(Input!$A21=1,(1.5*0.035*10*K8^0.5),IF(Input!$A21=2,(1.5*0.06*10*K8^0.5),1.5*0.1*10*K8^0.5))","v":2.0536158659788351},{"$f":"IF(Input!$A21=1,(1.5*0.035*10*L8^0.5),IF(Input!$A21=2,(1.5*0.06*10*L8^0.5),1.5*0.1*10*L8^0.5))","v":2.0536158659788351},{"$f":"IF(Input!$A21=1,(1.5*0.035*10*M8^0.5),IF(Input!$A21=2,(1.5*0.06*10*M8^0.5),1.5*0.1*10*M8^0.5))","v":2.0536158659788351},{"$f":"IF(Input!$A21=1,(1.5*0.035*10*N8^0.5),IF(Input!$A21=2,(1.5*0.06*10*N8^0.5),1.5*0.1*10*N8^0.5))","v":2.0536158659788351},{"$f":"IF(Input!$A21=1,(1.5*0.035*10*O8^0.5),IF(Input!$A21=2,(1.5*0.06*10*O8^0.5),1.5*0.1*10*O8^0.5))","v":2.0536158659788351}]
["CL","cost per cavity",null,{"$f":"(D15+Input!$C9+Input!$E9+D17+D18+D16)*Main!$D18","v":14328.697537551394},{"$f":"(E15+Input!$C9+Input!$E9+E17+E18+E16)*Main!$D18","v":14328.697537551394},{"$f":"(F15+Input!$C9+Input!$E9+F17+F18+F16)*Main!$D18","v":14328.697537551394},{"$f":"(G15+Input!$C9+Input!$E9+G17+G18+G16)*Main!$D18","v":14328.697537551394},{"$f":"(H15+Input!$C9+Input!$E9+H17+H18+H16)*Main!$D18","v":14328.697537551394},{"$f":"(I15+Input!$C9+Input!$E9+I17+I18+I16)*Main!$D18","v":14328.697537551394},{"$f":"(J15+Input!$C9+Input!$E9+J17+J18+J16)*Main!$D18","v":14328.697537551394},{"$f":"(K15+Input!$C9+Input!$E9+K17+K18+K16)*Main!$D18","v":14328.697537551394},{"$f":"(L15+Input!$C9+Input!$E9+L17+L18+L16)*Main!$D18","v":14328.697537551394},{"$f":"(M15+Input!$C9+Input!$E9+M17+M18+M16)*Main!$D18","v":14328.697537551394},{"$f":"(N15+Input!$C9+Input!$E9+N17+N18+N16)*Main!$D18","v":14328.697537551394},{"$f":"(O15+Input!$C9+Input!$E9+O17+O18+O16)*Main!$D18","v":14328.697537551394}]
["CRL",null,null,{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006},{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006},{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006},{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006},{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006},{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006},{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006},{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006},{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006},{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006},{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006},{"$f":"(Main!$D18+45)*0.93","v":74.400000000000006}]
["CRN",null,null,{"$f":"(Main!$D18+45)*3.6","v":288},{"$f":"(Main!$D18+45)*3.6","v":288},{"$f":"(Main!$D18+45)*3.6","v":288},{"$f":"(Main!$D18+45)*3.6","v":288},{"$f":"(Main!$D18+45)*3.6","v":288},{"$f":"(Main!$D18+45)*3.6","v":288},{"$f":"(Main!$D18+45)*3.6","v":288},{"$f":"(Main!$D18+45)*3.6","v":288},{"$f":"(Main!$D18+45)*3.6","v":288},{"$f":"(Main!$D18+45)*3.6","v":288},{"$f":"(Main!$D18+45)*3.6","v":288},{"$f":"(Main!$D18+45)*3.6","v":288}]
["NCC",null,null,{"$f":"(D6/D19*(D20*8500-D21*300)/(8200*1.71)*D14/(3600*0.85))^0.6035","v":1.18292478919055E-2},2.0564299868957137E-2,3.1245359832078087E-2,4.7474142920361326E-2,0.1253965333908687,0.19052726484539353,0.50325202433111049,0.7646402107850937,2.0196937917248907,3.0687190750568751,12.315644179828039,3.0687190750568751]
["NC ","number of cavities",null,{"$f":"IF(D22<1,1,D22)","v":1},1,1,1,1,1,1,1,2.0196937917248907,3.0687190750568751,12.315644179828039,3.0687190750568751]
["HP",null,null,{"$f":"IF(Input!$A9=1,D4+10,D4+15)","v":16.600000000000001},{"$f":"IF(Input!$A9=1,E4+10,E4+15)","v":16.600000000000001},{"$f":"IF(Input!$A9=1,F4+10,F4+15)","v":16.600000000000001},{"$f":"IF(Input!$A9=1,G4+10,G4+15)","v":16.600000000000001},{"$f":"IF(Input!$A9=1,H4+10,H4+15)","v":16.600000000000001},{"$f":"IF(Input!$A9=1,I4+10,I4+15)","v":16.600000000000001},{"$f":"IF(Input!$A9=1,J4+10,J4+15)","v":16.600000000000001},{"$f":"IF(Input!$A9=1,K4+10,K4+15)","v":16.600000000000001},{"$f":"IF(Input!$A9=1,L4+10,L4+15)","v":16.600000000000001},{"$f":"IF(Input!$A9=1,M4+10,M4+15)","v":16.600000000000001},{"$f":"IF(Input!$A9=1,N4+10,N4+15)","v":16.600000000000001},{"$f":"IF(Input!$A9=1,O4+10,O4+15)","v":16.600000000000001}]
["Aca",null,null,{"$f":"(D2+5)*(D3+5)*D23+5*(D2+D3+10)*D23^0.5+25","v":161.249},161.249,161.249,161.249,161.249,161.249,161.249,161.249,253.88461746665052,341.24435665501494,1021.828525570613,341.24435665501494]
["CB","plate cost",null,{"$f":"1000+45*D25*D24^0.4","v":23323.011294463391},23323.011294463391,23323.011294463391,23323.011294463391,23323.011294463391,23323.011294463391,23323.011294463391,23323.011294463391,36147.313677595252,48241.233296217601,142460.03830918434,48241.233296217601]
["CN","multicavity cost",null,{"$f":"D19*((1.71*D23^0.657)-0.71)","v":14328.697537551394},{"$f":"E19*((1.71*E23^0.657)-0.71)","v":14328.697537551394},14328.697537551394,14328.697537551394,14328.697537551394,14328.697537551394,14328.697537551394,14328.697537551394,{"$f":"L19*((1.71*L23^0.657)-0.71)","v":28711.026290704973},{"$f":"M19*((1.71*M23^0.657)-0.71)","v":41010.558664212884},{"$f":"N19*((1.71*N23^0.657)-0.71)","v":117362.73347171579},41010.558664212884]
["Mcost","moldcost",null,{"$f":"D26+D27","v":37651.708832014789},37651.708832014789,37651.708832014789,37651.708832014789,37651.708832014789,37651.708832014789,37651.708832014789,37651.708832014789,64858.339968300221,89251.791960430477,259822.77178090013,89251.791960430477]
["KM","mold cost/part",null,{"$f":"D28/D6","v":376.51708832014788},150.60683532805916,75.303417664029581,37.651708832014791,7.5303417664029579,3.765170883201479,0.75303417664029582,0.37651708832014791,0.12971667993660044,8.9251791960430482E-2,2.5982277178090013E-2,8.9251791960430482E-2]
["FK ","clamping force",null,{"$f":"D7*6*D23","v":39.294000000000004},39.294000000000004,39.294000000000004,39.294000000000004,39.294000000000004,39.294000000000004,39.294000000000004,39.294000000000004,79.361847852037869,120.58224733528486,483.93092240216305,120.58224733528486]
["RC",null,null,{"$f":"IF(D30<500,0.93,IF(D30<800,1,IF(D30<1100,1.1,IF(D30<1600,1.2,IF(D30<3200,1.36,IF(D30<5000,1.88,IF(D30<8500,2.46,3.6)))))))","v":0.93},0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93]
["CPP","working cost/part",null,{"$f":"(Main!$D18+45)*D31*D14/(D23*3600)","v":0.14917782445482025},{"$f":"(Main!$D18+45)*E31*E14/(E23*3600)","v":0.14917782445482025},{"$f":"(Main!$D18+45)*F31*F14/(F23*3600)","v":0.14917782445482025},{"$f":"(Main!$D18+45)*G31*G14/(G23*3600)","v":0.14917782445482025},{"$f":"(Main!$D18+45)*H31*H14/(H23*3600)","v":0.14917782445482025},{"$f":"(Main!$D18+45)*I31*I14/(I23*3600)","v":0.14917782445482025},{"$f":"(Main!$D18+45)*J31*J14/(J23*3600)","v":0.14917782445482025},{"$f":"(Main!$D18+45)*K31*K14/(K23*3600)","v":0.14917782445482025},{"$f":"(Main!$D18+45)*L31*L14/(L23*3600)","v":7.3861604697718589E-2},{"$f":"(Main!$D18+45)*M31*M14/(M23*3600)","v":4.8612408241394796E-2},{"$f":"(Main!$D18+45)*N31*N14/(N23*3600)","v":1.2112872236042726E-2},{"$f":"(Main!$D18+45)*O31*O14/(O23*3600)","v":4.8612408241394796E-2}]
["GTPP","grand total/part",null,{"$f":"D29+D32+Input!$A29","v":376.80326614460267},{"$f":"E29+E32+Input!$A29","v":150.89301315251399},{"$f":"F29+F32+Input!$A29","v":75.589595488484406},{"$f":"G29+G32+Input!$A29","v":37.937886656469608},{"$f":"H29+H32+Input!$A29","v":7.8165195908577783},{"$f":"I29+I32+Input!$A29","v":4.0513487076562988},{"$f":"J29+J32+Input!$A29","v":1.039212001095116},{"$f":"K29+K32+Input!$A29","v":0.66269491277496817},{"$f":"L29+L32+Input!$A29","v":0.34057828463431905},{"$f":"M29+M32+Input!$A29","v":0.27486420020182528},{"$f":"N29+N32+Input!$A29","v":0.17509514941413273},{"$f":"O29+O32+Input!$A29","v":0.27486420020182528}]

{"sheet":"Input","index":2,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
["Flat - negiglble depth"]
["Box"]
["cylinderical"]
[2,"SHAPE"]
["Simple",null,28.5,null,0]
["Intermediate",null,172.5,null,200]
["Complex",null,445,null,500]
[2,"GCOMP",{"$f":"IF(A9=1,C6,IF(A9=2,C7,C8))","v":172.5},"GC",{"$f":"IF(A9=1,E6,IF(A9=2,E7,E8))","v":200},"PSP"]
[]
["inches"]
["cm"]
[1,"UNITS"]
["Large"]
["Intermediate"]
["Fit"]
[2,"TOL",null,null,null,{"$f":"IF(A17=1,0.8,IF(A17 =2,1,1.3))","v":1},"TF"]
["Not critical"]
["High quality opaque"]
["Transparent, optical"]
[1,"FIN",null,null,null,{"$f":"IF(A21=1,0.7,IF(A21=2,1,1.4))","v":0.7},"FF"]
[]
["ABS",0.7,"cts/cm3"]
["Polycarbonate",0.88500000000000001]
["Nylon",0.41199999999999998]
["Polypropylene",0.13700000000000001]
["Polystyrene",0.13700000000000001]
[5,"MATLL"]
[{"$f":"IF(A28=1,B23,IF(A28=2,B24,IF(A28=3,B25,IF(A28=4,B26,B27))))","v":0.13700000000000001},"COST/cm3"]
[{"$f":"A29*16.38","v":2.2440600000000002},"COST/in3"]
[{"$f":"A30*0.01","v":2.2440600000000002E-2},"$/in3"]