ࡱ>   a (CommandButton4rt &   Microsoft Forms 2.0 FormEmbedded Object9q*+,-./0VERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} UserFormAddpart Caption = "Add Parts" ClientHeight = 6120 ClientLeft = 45 ClientTop = 330 ClientWidth = 7200 StartUpPosition = 1 'CenterOwner TypeInfoVer = 225 End |}~VBFrame;+FormHelp.G:%y%f@OoFLB \p Kim Manners Ba=    ThisWorkbook=ZxTahoma1>Tahoma1+Tahoma1+Arial1+Tahoma1<Tahoma1 Tahoma1Arial1Tahoma1Arial1Arial1Arial1Arial1Arial1#Arial1Arial1Arial1Arial1Arial1(Arial1(Arial1(Arial1Arial1#Arial1Arial1Arial1Arial1Arial12Arial1-Arial1-Arial1-Arial1#Arial12Arial1-Arial1-Arial1-Arial1#Arial1-Arial1-Arial1-Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Verdana1,Century Gothic1Tahoma1 Tahoma1 Tahoma1 Tahoma1Tahoma1+Tahoma1 Tahoma1 Tahoma1 Tahoma1 Tahoma1 Tahoma"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0.00"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)[$-409]h:mm:ss\ AM/PM$[$-409]dddd\,\ mmmm\ dd\,\ yyyy \ \w\ks #\ ?/8[$-409]h:mm:ss\ \w\ks;@[$-409]h:mm:ss\ \w\ks 0.00\ AM/PM% [$-F800]dddd\,\ mmmm\ dd\,\ yyyy[$-409]mmmm\ d\,\ yyyy;@0.0 m/d/yy\ h:mm m/d/yy "$"#,##0.000 0.000"PRODUCT = "\ General0.00_);\(0.00\)"PRODUCT ="\ General #,##0.0 "PRODUCT = "                + ) , *           "      0 !  !8         0  8!@@ *   (      a8 a0 a0 ax @+ ax @+ ax@+ ax8 a<@ @ ax+  a|  @ ax8ax 8ax 8ax 88  ( 8 1q < 1q< 8  8 1q < 1q(< (8 8"!@ @    , 0 8 8  h x 1q < x  h       8 0 0  x@@ x@ x @ x  @88  @ x 8x8x 8x 8 p@  p8  x8 x 8 p  @ P x!@@ 8 x!@ 8 8 8 x 8@@  0@ x #x x ! @ 8 x 8 x 8 x 8   ax @ / x @ 8ax@@ / #x!@ 8x  x  x  !x  P ax/ ax@ @ / ax@ @ + x@ @ + x@ @ + |@@ |@@ x@ @ + a<@ @  |  @ |8x8x8x8x@@8 8! @ ax! @ / x @ / x/ x/ x@@  x @  x@  <"@ @ x ax@ / a|@ / x@/ x @ / x/ x/ x @ / x@@ / x8 p x@@  0 x x x@ @  |@ @ |@ @ |@ @ |@ @ x @ 8 x 8 4@ 8@  p  x  8 x@/ x / x@@/ x @ / *x!@ @  x!@  x"@ + |@ + | + |  + 8  <!@ x  < 8"@ @ !x !x x x x 8 x 8 x 8 x x x x x x x x x   x@ @  8@ @ 8!@ @ x@  x!@ @  x!@  8!@ @ 8!@ @ 8!!@ @  8!@ @  0 a< @ a<@ @ |!@ @ |@ @ <@ @ |@ @ <@ @ <@@ ax@ / a|@ / K˒|yCjY[A*ߐ=cuoyVWIѼVVӶfTSՖ'4B嘘ꉉ쾡" Kj57ZGc'ɣ>ZMGUmxY'헃"vsܺ#sδ9MY]YT?~%|8vk= ׎/%Kin{cZuťiL7n#lLW_E?5I| JI'rc}bKٯ֋T cw-hpñw+;{iLnE^қajw#d=Ӄ]|7 'tp/\ΊGwri;91p{z5'f<f:wVͤ{{r+-qW-=Fm9bO& j.f)iqǿQ+Ӎx~ gw[N] j}\<ۇ$NL6ڗmN*q=Vѝ27 w>yqN9Խ7lXlݑL5|sPۘ]<a`s6y$vE=ph.qIAK%L㮒AZ 4-xcѤFՠ $ ((dHqq놐Bh۝vW[:V@s]H +J}\\Okq.UMt#`h.^kpwN>Jʸ)"6F]5<F7-n+/q]_tNxV6K4\\4kworKn=6)]Oll9#K#?%ϧF[dds4mq+8o T>3?.> \,y)7%W(`w>GdyȏW/G|_۞i3<ڨho0RZ١&664uߒ ֳ3릹~iբ#mw,))q%Omv1G:ZI'*3_K~kqU}&|jǧ6iU-3[Gݹp _l7+g\Yqqtf"û;m6\KD5[t7~w×ksYpt|y=f]y)q91qd} DzF5!p\:zw\ 9{>ov5}![ nPBꆃә|=ˣ鼞򼧪¼کeW*cqG|Zw ԼwJޑhƬ5dF=m5Xz%@XVDribw1Hx7=?HigqIuEʨmk^<f|J[UKQCT9JDĖzutNJ|NymHCռ8n#n{L\?FI93.IߛKJ=:ó7ׇ?|6t{<3um=NONK+ђJP:( zF$MA;p]`8~z3p3)5h䱮/1c<>HvyUpwuMw$v;QLjcu-~&bun췋-Sr8a|=;Riy+'|ESxbꖟ{Dt_g?7٘/O` _=1y^WaItU=cdN?TH |SeԸ6I×VH50ϐrwv_>w]/^o '6T?%߽~:^2몖iq[U?{_lrS\aǤ.388OgNilȮ4 kqCCW޺ޞvKo[t?IC8\;??rEȧW(3 sk3A+iݣ]&MAoM] {CSUJFϋ#-xj\w}CCUM-4 tr4|Ncqb1O̸ {{S՜ztsʇW|tjv/'1h\*hC~ &N[_On-\C/ߩn%>O=͏yrr[o\IcR)@=ǰ^=ZLn%v;=EPڋ[LO8Cys#`:4?DW;˝smq]| =+UIq"+IjͯDm6i:} t ÿ..OSElq5< v8'eyYcͺ?[z5u\lixIK&;hw乱cP˒)]Uv&j<ܵߣƥyWVɡ{[[DApp)wGxN";˧q~ң'.,~(vϳ^f[^>}YfY#.Vw0ߒ/_590Ď۫0OK ]}^V ѕٽ׾1qSTyg#>q7?xjsdݿvpAC5s9cBkO.rp5}|uXV/ o][mc1S@q.v0HnտԈכo3&5]5-5x lc$Nr{Ν\DRZe__qJxҟqp]Խ0㯼=< {K^?dϳwrV%wVrƧTwHN.?G"{\Kwa5ǝ[ ۧ>qnO<kvmpK"3>DZ5 l zay'?<]%tb<;#.x._Hll I%z)a#N\Na %;_^M+;%K+ءInON=만ڝ<w=Ʈ@a-cRi=<--IoKVD0%Q>w_bgsN2GW_^{qܭeu0n]r6騳I(-\U9rO׫68tiݯpĴ m#t0YN22` 5˒cnq? ^zs^8g-eESYl $F浹>gvYils0^"f%c] K͝2)2Z_Ź;Wjo4ޯTT멠n8ې202p:IգxgwN6 eeME==]^ږTVt"CaWg>~ ?wVbwoh髩&`vak ቘúb&5.%} Chorf'Ͻ|Iy8;LJ!8{aQ4{ l(Q)t;4RMt--ݐu=^F\|_Dl?Ovu~w1ͩl4:fJwc2I6J.Hqر?jq.ty|rI7}AU^[,}>LT:Bck0֍ zhln1>3gOǁ>'s/ԺW ؖQ9-uLǞSҭ}pms>wC3o HkcMSdzSU?/k7ڬtvX_]?Ֆ@b{wvm1V<=Z 5z3@xe9'rbqL0/Xz2ߴo@VNkDzkrVd:ɹESKe``W6_ }7jFTOP'ҶYi!yÀ=T`n׾aZm.~+!o\I2C283oԍ]o[ZS:޹wg u\OF#PZM$hhi=LyS#SG_gf5=qu}=-)3 jQLUBch$`_ WS4#%:}ULL4,Gu`iLu(q,y̽5LJ9m/9!cC깮|1'y嘞5YKoHd}$ÛvGU\<]Douat7ZJYMֹ=Z2Ou+l8 1[n=2$Zz\?lY:DObio<(%5YvWUz;Z'ˡ?@˶}~uVWk--K,?M7-d7 5#|Su7T_G<b4S5`vH9}m7' Ew׷Ob3Lκw~fql)e ed4rdo%'FT1W6j%wOWAtKUfdfqѐC2 i&=7;Oe7oUSl:;3KL1gdvU :*"сuk//$lQhGͿ2;|4͗KWkd/,`@>~*ſʙ-M:soGM-U%DsSLFYL6*Hu0{OMım\Ax٪ʶSSuK]0k#V;[fֈeiZI׺G*⧠DzI c  S GY(zDyΔZꦥ,xQ4Q9jcZ⻐}:`8I1vǣF3VH+|(.o_:=ڞ[ө"ɥ$厑ʇ#xY[G6kSW+1dxh.a2$x{TN8{JђwƤ˨-z|Pk %9ƴ`w5XmE:OSs*uNj!U6%N+^I+[ '"0#{>On"1Węn -D:=`; z@c|nNgLxPcL5w>8+)k  ݎ*Hʌz;H͑p%T*߼4[a^]Aq+8o8ۖ|HW^Z4䟾@*~C_~ Q9VkyqU?7niR;o6&A6dQ5˖fg"##o6qu8 \X%';8s+җ66Uô[Z(碑ܸ%F>'cO];c$bz74eU[(ISoIdsc1Z$iKDdLGp}\[jjI57*-H tb;Fﺿ g僚3*,OK_bA[V2xŁ \pCRkNmw\٧FJ5:o_;*z6j Ij]#ϤF[L扞b;WUu=s}ƽԚ1GfGfG;s$م#Z3g{!vJa ":Wte܉[6>1>8. :+"S,c&_n5?G}Q7 %%M##9=sCӫVpO;y+%QȪVtH2DZG\uեE+ hTKG-fC4Hd bdLz\zH5:Q=c/4EG3Ӳrv+lS=:Kݥ(aT:Q=5CZ Hs54J_`e]*L3APJݺ$Djfwi߷]fgUWR9lc5 -oW;驘 ږ^pZḲ UYj=vI3s⢹&']ca.®eѭ0:-$F.ݶ]w/U]km+[׾q5Wzا(&m<3_+:7Ogbnmkn1Zm΅)&d9ZӖ:FʱzD>{ݞ+thd1Mz/-/Nh`6x_DR ᧦0C$IIӜ*ڿ1=*G%7{I=firFK34o_7rY<;ςi6'4]SWR2x{^qZ+Z.jZs1lrTLzXH=6--´~ *JRr *uJd?l{V2V-iٞ1^%_OEu:!Q%-C6#-;k\۷hS$L-{˞Zo!gc,3:f6+4FOݼp5NS,zqNq66sN1u,qS,YlRd׎`qUf^o~7&,헤 vOCp]~z-5Llm׬w%KnԺMhvˆVs Xw,0YRܹ>#J!GĜ%S-yDu8q'][7 SZ6jCd2%k;kk`Ͻrۗudx5{*d}5"g8)jmltNsiF f}]qGFvuSٜ[8iB~H餑^8=V(r*D?k<[/vȺ^:},{Kw~FyRg>/g3o45PÑ>!2i6fd26oT&\5==>&l\ApUFPʚg #b@*"tq%scvf}h"(do&wf77YN9}V|gj0֏y3;(BY[H<5?Z&S\UTC\K5 xɧ} uӨ_.]M8z|p c[u$.im2z釟+1nU8"M'۠$@\jH7,lkFXѐGc2M zȜ$fs:`yբȊm2jpt FuDyiכ nU7JWe7%y0Oxv`5s]ӆXN:ưcs *3+q!8n4>q^[mܶ\47[ [+Xw$Z%L7xNd lz5>6> \V卸OY<o31̎>+>ffW9rh; U1_jUlp \p//..n'Sc- =)C>Q><GNo7]:Ay3RsspflsmKŻ$VK5ҧ<7<28:FHwp3g~V6ܒzD/664p3\;u4 y[5FE;mUk=p>7TD}"\{ -m +/Pmϔs sa-ws^|8V>RPN!leou9<ɿ448/lwf8ՖYA(wV^49 <ǴKFckWŏ'䑣WWV%H9d_WZ}ƻq?x^hm𺢮W77';2T+-qmnv^htqty@ώO?D;:RV??0}(WoԩQ0KSC-ʂxDu-p˘ {Hܹ>h)k#jH3%unEZ;Xo+,S1Xu d{p LJ+䦬V SЃ,-Yuc:55n.hFoh+ #ܮw2Yɘiqi!=;**ISPO!^\7; CRXllUвJjvF~N{<_=-UJ_юCFGu9tg#ӆ 4Qn+? 6E#edݯa.xm.'Ķi.t,GyKmx9-ӳ~Wr4i(t9xf>C9i9'z><ܩ}S g}c#DPwGJ .uJZq'+ώ}cLV՝.Jj{)Y;˺gNo_w[S3OAp4\3ۢs:Gjq|%2S^--ڂ'n0בKv=uׯ9C{M]an{QhyScٹ[;A2іxoշ,mKz} NI&7<}xZ~csfPi(mdЍ,cF=cG /U^/*D"❹Ϟ7+ņ)]zsZ͏n31)~GYeS^WDinthF}f"mu.^-5M+aԍ(fMr%L*x?%};1 l$}-ځPؤ;'QX#♟$':NU,RNciqRz=;޵1 ~Qw?gu*Xc| k٩>gei/͓-=A K~-M;zKH6f7f]B#$iiHxrO/Zo}s9׆-Ajgix8|nk#J_x\b21]$.oo|9 *JѾStώOh{rA. J!Y;;=ˣV5h=fH<ϵsdݛW#.ծgp8 rյ7[f;xt̚ UˋwJkoa%Ph{DmoznζIJ X%tӹq.U8|?YkyϪrsf#Q G>+Vla;0{l-ufO&zG&*5+Vt0#wUxi^>~vcL.f {j܋2ݘŸ#T2_Eao2jgo2>Xն[)Efե `pt͸;Ki掚lԕP괵jeqM31L2H?n_vL|-ZӴ;Pz$":y7n Z]ZfmMƺi(C|0(5gH~N0'qK50犞)m.{o⪋j^C"Ak~A6m5J1ӳ}\ i'`{zL+2)I=ע>_g^+{8܇\QKS-/D$K?.>cЭ1צn&VOdSrC&fOt0~ ZZ`#*PAqE9esi#aӬˆM-[iLZxehL.}Q+>+?A*5KdShi蝮H]oBn5*&1!_d;>C -6Ui{ O2U5=4<2]=WtnaFw5,U|>cwsٜznQHqKM0LcV.%g7Ϟ ZˈHrame12t, <ComboBoxTopicse  Microsoft Forms 2.0 FormEmbedded Object9quTahoma2tVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} FormHelp Caption = "Help-Definitions" ClientHeight = 2910 ClientLeft = 45 ClientTop = 330 ClientWidth = 4665 StartUpPosition = 1 'CeneVZt|M6]5MK+&éb՚\nT0D[!|S]N!W\(N؎nZI)|>%-pvՄH84z2k> Bj9wr:lM\fá$h&j-tVwg>F_9kO%zV?=Wm?òբ:1+Im ٱ-;sWlSKj=Oy.3F>1O%>vGܨ|d MH0{Xf,,6$jyJذGH䞝z@=~n;H(fťowt G1Ӽ?4p~!T;ZE*\$5C-;c`nVZrђ<ؼFCP| kgVE4SNxCygLR-{&SaL^h^jߩ0Zip{ӪD!![t}\<J@CgF7g8v'2tq3u? ጜ4|jb~+>Y̺7 /EƙsW:#iV:ʊJgM 睃 @g羭vfcv022'"RٶH}u^0\EXp Ư.n.k,ro:覨дgv^ oEsYuӆi͖_&T`mzbPP[ᢥfx}&w;d"Wl7[U]` uQ>#[jvYC3]U+px<>YEKr@NvφBro[}S$vm]N<M;{Zr\\la<3XyφVf5 qdbNCCO%$ rX'+UzcUH%+/~p:0cu~e4 Wl 7SK*k>G4âVqx~؃*tyf+dM <=G`S|uzz+jၵ i[tx.kg{U#i8njj*D>*Z~"Cܲ5S\2'-P:-3Zr|zG/WGKl%qT~$tI'7oIwulNPSS9.>gao*T{=7S0WT<ƭ,*5ک~YyߧExpNfq] w[e=ςlBj!j#eYKPԉ5{Vc=7eumYC}9K;wkVy' GyB\:oTQJ3 Cn;k6Ǹǒ"zfL/257qY0lϕL۸[RS.48ڦ*mp:h# %[<|jTrН⪁#dzFcPjz4nis1Qc?ฯ qyǻU>[-XZg_cgCʔ"icv =g;0Ƿ_./ Z{Qeu/fWp.d{}/#ۻ2ޤFY N?C6v3}ʶkb=֭-n3죄ʎ,02JS<ΝbF;w\\nJ9oݥ1|AULt#꺠Cz7>m ͦzJviʆ_OUv]Cdg9JMXo+k)\ w7I'oq˺+'EU o(#N=_\@e1""8oVqm@dc pp=Q"ےin1.fQTn,}A_RS#0^[{u wը߭,yT4V0i`T;9U^X4KӮl[e5%3劼>,7Ᏽst;'}U-ݤ7{2]w;r6B\jl##G*/ydMV;zM{tcY׸+ ݞ _yc.H|7"xy7ZR言fp7`5 )AV,TT!noyg>jwpdn͎8NH>y\6{gs:LNG/D1<᫸aԏL,m??od#$OvY΍Qbwgc |N[5د™)nm;[=Wjν~n#usg}+V&uSEA霳c]VU=Y9;$jhrKF}޼>? >s~J?en{yW(^RTEE?~Iƀƒwid8u=wsNBeWMɇ@Տɿi/6yVDWk<8O ;Ue,5쪥P0jS% \SIfCOgJ\iCAP.5x伏hE삭Q`%s EmD^6J$qwQYKXo~iKULj@@A \2ӱ<)n7\nj<:Jx{/DZS/Xm%M G,\ӸK|8;VjNJ-~ #˴pypk];|lLsD룆|CM lt{rcm(#w8R7~F;TQ4sӰKFOd汦?22fm4&`і)֣QtmmuRa@s1,Zf=m'=W4dΝY)ZDZAQ;|sCvZ-mh/{#a| cwsp~lwϢ * ax$ai\@@@@@@@@@@@@@Amiב3- gWъf:׼6[(1$ipY֫ekG^[tzqV]'xPj:4X%I- L̚F仮eY%cD}vb ]G:XZ8K%sm}bh\\.Ӿ#w3 “ioRTGO-0Dn>sFoLc..zttT6~oH]kvUۢkmG'FAtӳR[Ze 6SPц3

/p㟆ߴ^,/xL'P7R:enQHgv\Wk+GgGıύ?&,vXHp9x/Ou6^z6GTLD&cHc gHr!x&F13D}Tb6[h {\3 ?*߲sk#E5;\щd>~ &7T5EpࢨME##N\zG=H-a`P0xʵ)p&; iq =}Wԍ-+IMS8]VR;c_9^Z#i,'_Q+&=unۍJ*u7+Dfe@w&;]8,sWѿYsT- v ;)xpW T Z֘D5X>ѵը&uq?M.[UȧpV,kNil+`V` ~+'Vp'4Pй$[|yIV:Y'_摂JwS0gf= qo-چ*Sidon$i.uœy9ɏ_@+ sڴ Al29gmTs'QvQM+\ne@#pj]rz_-ܭ҉ifiŮxC9qɮAcC>CޭJMYĝ KMD} @ZW?]tߪZ9]Q,/ a~zܽ&'3c^vqLs4ky~wZܻl^4FIi :MXi8cUoם$=ǟw{ᚪV@o|jInp=iq]5-_d=VqiZ흥qCH_JmbGUwaXF-竜^_}٢-;Mc'gTI>)|T_-h"sz8烲ͣ]kZ3u\RiYi_Pq+w.k&i岩f ii)oUT0vvsp[3IAIGHw0FJז`[h_ah>mUvӒy?!x'CE$`B~:V֮vv~{%[i8=qp}<{Cr>NWlq(H)깺]^'$y{Ş {U;9ڱ/~zţ;o-pnYfLlc~jPC\7JL Ca< x[cqS? qH| }`v>>j;U]&#y=\ߪ⸲ReY@A]GSP3|/!^qWU nTDilG iYev(Zcn?*e >]$q+/Z_4X bz&/6]3S]OVx hds#߽O6YEe!ÂފinC[) E\L3sudkmY)0Nÿp-+aq3BU .k#9僱/[m 1Նc;tώxb^'lcџqwYkc"VUT ?;-hKRAI|ltC4 j}:M%y kK5J#G,mbɫv+Oy=fvօ*kڃQS=ۄnG~/[D\UՍSX՚E'}M=h}Kg9LCQi K=\ZLxmL춪)epN|iӖe#4sLITi;$wE?7{Mv9CkI{=thIEmqncv7i\۳AK2i#{dxmΚzzwȩwzx-pe.cᖸA(9Db 5.w=úR>kck10?HB[[(Y}U=|Q:raZ2sN/M-mwWL5[7?zuAEZv8Oul%EbTw!)WHBFd;8> ^r|mX^t; ַ.^i|o`l G*!w#XkQ%qxعqIAa{GRth|Ohڮ S0hhnNܜftcܮjjq8ݪF7~jV{+ ZiQdJqΛ%.a1rn-֜FviSxrov }^i9VgNj[n>"KrgG\TWuibU"=y|SPY|4Oǚ>fr5 Bc])BU:kCTn;/ž(ǷmNJS$'?Brɫ.iA\7'vجrmkLsKj)&2F nz?>"hmCH_^Ӄ2:89 #s{9rrn\){Ɨn\v:.$WEip|PMѬzV>߇(7V:V5&|BV}TVx7 žKG&Ǟ~}7!ǵ6z65:ܞ2} , 鮊:3ȆHKPN5{33s!Ӿ:{OX00Ǐ<^yt+ogqfd\ wk"ݸ;sNbk!04/| 9-{Xc0cmYT, K̏vJV7I5lohF>L ^(fk%ېߵd7$'`hHȨsﺂWR9iG;LM3gv48|BEZSigu1Qaljω}̤@r7is[{*i^'/3$zqFSVw$Z$740VfWdFC(jjl\ .4`)LE7e7>UHAk  /ocYl8h],rL!t|TkND9puL _1\XfS4ýp5%rr_JP iϹH~}޶A?2O̪yOdg-Cod;rs|] oEo5!IcƉ^uq6'.w^Nv ܇D:ұ̘<$8~BūgeMUE4}=;i;F5YIμԉRs#ٖT *i8MTuMTt#=|DLgK0م=BZýveiTQR? ;zIczxWP@@@@Aƻi\En >jkV"͇1ߛ`he#QYcwӺ1bAiTY?IQ*7~˒~qt@AzZW;jȁ}SL7Yt?DÞC3|\Fжʘc{DcT.q?WO#FJER_v&S ϐw[s^}8{Mg˻+V<:)_ɒ9u=-俢kXj;8miܶ:7沕'/h;jmMHm%KE8_W)\v Dn\{xUf[%݂m`@Af :Yj -/{s~%Wt2#asqxHMűV^nlSӱ|sd?92jf([[Y_N,AMtzA~@XczTPw-uϼg^{zܴl>>״{8'4i#[î k*\3\i#q+ wp]Ւ4p3n Ap+)D o^\ޢc*`|X,{rgIy#OjK|``4DC2]ԕ\)f|i,ywvW :ޞ1͒V'QɡU-*0/cg;ȷF*@@@@@A8CoS>p[ZѤSkDXwKvD#fw␖ycPM+K14zsrquT]}I굢;ϫ+ٟ +g=dzG'֓:ۅ -Atd5Ok]UnjDѩf!#O rx'Q^F< [-;Gfc͖U$x[OkL6G٧y-)ᄂa9?Z'`!49=k]RD4I+Ӿ [nM:ict"n׏~5vk]Cư7ܠdw߰?Ύʑ!s#kTi 깛 C5 ܞϥVJWǵs7X3plIiIbٽ/RI]N?.G3\FNY}Zc=Fwi͒f޿, :ASR|{K򆸛j û\#[m7x%Zy.;Sޑǯ].S4kwAfwQddOcgDFO'y.dusX;aeZ|6H*m(ړ$9r"G+RrVG F4zm.⢔<2~~v9YS>oO9z4:b$r~T5Lss7y8cUiMdznZKvl.* oѷm[^y_\)1o# cϙ!){d6k7O^'RV4voŗZtCY>1+zdC]C]<+ieN&luk p] l<GhlN{O {8%:,uB U?|b3δQtqƉFwwB@Va"b1-^|r|P@ỡ==_L׽-gNIHl6nV)@i 7*LT-sr|I=> % gDtpHHy^_TrrbYwgc^/U5}}/{<P,kG2CR'Yv?^cwS:I靖m^Bʩl` Ϗx*Oq>w⇳3ՁoWcdzͷuV^%K{cwGrK aoa|ry@ 75?s.TOb:SJ"8FV17 q$H w-j_ kIjSon !˾CWevYlJ10gcj^XY/4}%s}֕|ieR8--Q+UoG+"7 **Td =F-/ Eed \ਊ9a~ 3iŵ;o"\}=Ⴆ"SL`}hq9w悫4PFd+2Lt,f[7 RW'5eͷCs;86UYګ*E7 yҴ; RKIa_iAqdYK A /—wyRM>[=VC(^DkxܹU(Jr*hgD +"][A+&+RL*yd=8T7#d9ie}C)>WU֏kU>>19ߞ5}뛆?k{,Fw]L-0V-|;yۭjc:_?Ktq Ϳf_ӕ8?N;'S#Bp {ZG 6 =n5꺣$ Gۏv.+/;j ۈ`07¦^Xgtο} 8>V XF{yzR}^^#{Otdwϑ8}mCZM<:;?gM [GY9Biબ]6_ЊSh2R汽uF9Ū$Pi9RTRHHgOb.};n76@T[qCv;ߜ nPkUeL{%ΔZ⧌&@~׳{wLSfY!J憸{N0*MM,y4t^K{|!Lj$^e~Y .Ǻ2pYCvgZ]R݁SItSi\-TGMO%D{AwI=_Ϫ>m 5."sgPH[W@#t`͏{v禛s]l5(vݫԐjX?u=-lskZA^Ɓn&/@|YADHFvqc\$2Qڊ|ti1O^Kz^-mYfBttN-W6I$3xeV2R&fa>Hf6N= ٻ:(߸zڮU<1;`ׇ5L}iT$@Am@=FM]F?F=G(띞Ȯid7,+l׉|gG8N.IV1]*zap4kf2MܤL]dWIu4*f݀ nhKn>U}ysf wL+&6>cM$cXxPk˿ݜaLw%LuHR<|L 'B|ETjx,>6[ P;a`jp*|u SMTժ,zU|O7'n2yS-xxJ ;< w3]K߬8g횞HVz$`w^ϻ~+ɫ w|^t o͖~#Tl qQtpJ;/X;VI40h*ixRڟ>[q}ei+ݴ) |\mqOףl;R]pc\@ߍ׽~83x N9Imo_kXqSV_xO,*'cvgZjMUpFzT[M4pt U];/eG U=;3v##XZ;e_"%֋Z#n{ (iwFӧT;S-[Mh1F0t ʋAK18~zX?1661IЌgȬu+;u5’:g(#~;-d Dk-7OS^4CJ@ݭ潪v4O;oTi׼qUmRduw/vC6]NvO#/Oh%rGAH߯ޓFϷW|#_z5?%;'+5<7ad?_V@E ^X߸ jr9Y ytT<1ںDO)9\;sZ=}$͆%q3S0{MצCG\5B~y7Ǵ5@3<i/Ue~Y}I]C-&/b"fJJZ7a為;%e_P Si*{Ud}}#9M7DlܭZZV]F;lWsczEl -Y 7oRiuyc\4 i>s8//χ[xO'LƂ2WA3vjdž|XN:D8f1S RgpÞܟџUxJA_COpaF"#;?UH"uL|=-~E^fj@!HPxAqv( n0w#ޡ.-Sx7еh[=g{{y%Vhjݧp%6V)rrK] =>vnUDd؇ە*KH}7R3C?)ֳK瘶i+S=4Eꠀ2Ńnudˉ0cPhH˽X%&:Oڭ U6:ZAR왥/'S^cq?.0I{.z(_m,Od`Uq\=ۯ] Y"ɰf9]8#8{s|n|_g( :H&0ex-sgf[nRЈ{hWtܥWH۝IXRH懐I Oq ֧ךrluT׷]9TPU;a؞<ݻux۬S]aǞv֟cv[qzvgq,t@$#˓{3 Q]f$q9$.6[ɡTz-djwipÆw=ЬG,T1:>vV+oرyZ*S7LI!3ӗH1[:%wTA*)~[4q|zh|i)S :ItTFz>C+^#,9pbӻZނڈ⧎"wnCNp6+gnGCVɨ m;l7[p9o{g=}5E;)ZZ#.Yq)3=M NMt|'b]:GR\8ZzPZx|Wf+_9Gɗ)>g#xK(ĞvEJ:fSFId{}ZiE ~~;pVq;Z0R-I+~W CsK>Hu/Y_ UCvb:jK/ vP@vAj=J JXx>g=>홠vosyLŜ%Y8c;/zsoc`?rЪ0mUdZ=n I_E4cb/q 8ajWgFeߺP G?\uqs諘]q\㳘>By,{' W:<ᦽc:i~onsYY$7vp[zw5pcz{o+upt:k*\ҿNKQxJۦZ]RQGU a߻(p/VMS]c凐w|Tn.nϸL#l%#hGvTa1Ůkm|+=-d.a7!*Mf!2;Id>U/RX}cSY9i9kݏq3):Ip*~#˯pt4 cݹNcPӹ6kR:NxЏ":Smۭl,jƢ:tQ̳T@A{lz? @z} L13n%ac]0uw>(}:#jo'\qѲTR\1žl| *]!˜uJi!ٳ٬O]CK CԵ,Oj.>ozgk2o28V#Zg8/;\Þf]gCuUA@Ǻ;bХG3k;Ĥ&_T<%r&4in.]N70o4O-ߪ#ll,ciCt+zHѾ~1Ę|xv7V㛍v #\og] N1F?I[%%mK[4z /pqsk 99|#le I:%}.])GiGvLDv%Y!N(4庛v篵yffӾfz KU1S /[Awl1_ά{q&;uf DKds:BiCHƼ?RQB;ͭ/ IJAWj>>TNˆKs5#ꭚ4Uphʼta:W"c{mTmRѷ2?x˦J](x9h#v n뮬 {$Ծ1H;N/4Lj ut5@A Ut1ONԫx)աƆOs#_ʧ=[U)*=Y= #y=ܸf~k$7N{3Vg0i; 'L[K9d j_G_ fJ'j?v57C {s^:ƶ+ETaE% U⑚GeN};\ӿG'MAZ|%D²F+IdEIR澲9t];RJ]sKv3@kt lYT6g^)Jjk亣=eW^#襹[g|ǧ>((d+[# F\3nl6yJHSoht{e3ĐS1oGu#擒EanHY $t!_泸E. kF$s~WE&QM L10{eh<@A u:($29.ՙr3I$ ~˛THةaFBusBtաYrw:."36F0YVaYМTjk[  i0WI,|=^%ݖS{W55hL{>n+|G1d,FIa:I`?/bKȍFC.'耧FޠF5NFjWv-uص^i?@9:[;D&1 Z<1&뿅 ۼIfB@KFb!SYSiuHԎxj\+n Jռr/ݶ:?)HdX d#"I8,g\2<3sWy =+T|вqA*JOY '޴r49"96>D~M8kt?ez8iEF)ZA#dasJՊ"7|j hELcfZױl<2MÉ\&Qځst2CeMW.<wpTٜAj;=N) zv )XA8볚&j^ag->ꉾC88zsqU~^ߣZjsz#(Rw=oGtXtM$wYT6ߩcK%|O 9- yVu}zd]C8Gܣד̅uڪaFThs]4cr&mKÆuGE~|5U*, ;`8?A)bNJ޽To1:csƣ庁ӂގztGqi|P<=5mQw:z .%hR#'{pB |5|9"_'6RK: G +s\hk[p#PAK# 8A"AV:FSF64muBU X@/)s999Ѐ%=x@/<B 9@P `A0 9Ё@Pz;w8$/,wZqN q_v5M\4mGglbTP8rphlLL|fu />Es}|JQ[vn-! c{9-'OOGY9ςp.4;_uiS ²ME55k?ӲdyAym+z\8MM'A̪]ٓvztq#OC%HGkstJgko4?pP% xӇMOnҦ T9g삧2pgENjw=`aV-m͹q}A6?LZ4vbm_SW6~w+TiZ9Gbv>agqڕ(|j Ik<=ʱʔ-ipJ#  2L%m#ܟeu&0ZVPuA`F:FTs.G$eFP,hڧHڏJ4m[&ɣkiBVwSm\oc(ѵdZ3)65$ XE:Fט滢qkB wTǕ:F6xhg&2V;Z:T6hHP$c:6)G2FTi;]kT% t)ңFEdq4 Iv>Emهᆍ vyu~`mۺ!&" s7?4OgZ̿wUH!vmpG̐Pap_\|P:B|rZge뿱Yt>6gaܕ4M`S{)Wқ\&-+[R Y%JJ"xj=PJ9'%-)fTDžXZPi|'[55uSL{l6wICKqUTMUf9+vLUfYWk ٥I'nHN[Vs "X 5+V[jKh+)y=EDldXS,mNj|U@:M}Vcy9RjYQ6bA4ŮL)zJҵL"UVXqQ0%)/!QtS)7Zi4U&12),iei{HF$rsuNFbtITSK#T,t VI>)5UT$@@@@@@@AT=!5m pۿ]M3Ӹ=v#ǪA:L#즒oBj{_,0ݾάYt: ﻉC\h⳷Zdq 6l;ު<)ꗳHc+n۪"grҹmYGsR8m﫱pQg)+w^*[ ҋ>wH"մkaһn4tx6$ j/}8ه_[oZ<'e/Qh;R ̣uwgAXܕIjLB&X^u9J#X0["j*fE٤lmA+T_dJ f.!^!IE/*-)2LUZe5C~!>VVZKGLƎ=iHH~@ZEU jEDi /lYZVU6Ӳ֬oyՅ6EWn#ll=MVk+x9Zѕmi~YHW1*U{!#nVsOrL&%ԡ)[fD=B%~UJJz]( "S0|WQ$lUY,7+m]+ev2SFIp $T1!=CNT^%أvUfTqPfF (*A CqjSHIAMM@R=Op:AǐE:+svحPRD諾cMX>LﻦTęӂhUד[641 g 7-ƞJ褚2 {p> /k|RE~eHOyce6B]~# r1a#]EVV*.h{K]`P|}+Ɛ *%h8{g7K,gU%&ת+Mգv9wը8߆i#~E;^{ {gaUA1+*DmVVe$ΚL-tiXrU%xSSUD,8VUC,@KߺcX͕Vb=J19QxbTCD+2rL!'Et ʫ.!mXci[C~JZJe5c-yB^S(1kY˕0+;CJBK4U[_QvJ;J/\k#)eȴgn3Vfʡ+^D$_VpQpZK8l0$c2tΉ *L=u0DPwBT#T D[A,M˓e}) @++Cjʚ-C!+("6|ndT]QBAV"jDC(UVFT<5+’K ~Df޳UvGQ$GtѶSnêЫEU([3TETFIJT$@@@@AGsd䨔u^YӲ'f{CVڈ\Nǘ $|j4EVɎ2mL+y|MRD=QeiIp\cii<;*ցs. cӓ%K0|FNO^Pѻn:~gWQSa)q`5ۥI jJ쩲* J>F͕eT(RL5J_siP$m-fERqkߦ2TYԿTxa)KAnʗ^XxZЈFU\iRlOptIJ̏uEUG -+fv8LòʜW=uYbZAVs-"ne5Z ?WE3>UQѲLY)r%BbWr>:3~e9Sqe-`5"I4kZs3^tJs#%vYCMēGRpb;r\}*sKUVae4Svfx3 W (-:u(5&NCVUVlU'X2C,4U 0jfR J-Qee#NunwE1TMI3K+;KJeYPZu+O$~IKQJxuAG!Jv=0(٥EgV٥F0T%O!Jv.(14zciAl0)4 Vy&+ ٟExfQWVVsd|SQ0X=Wnc%9Nfu$쓪)H 6aB^X|hҟGgVz(JA!Tv%:-T22_,>}QVibvi-5wCC,5t6d/tl93I!8::چi]Dnə~UYR'㫎˫N'Zi.t>` $cWQ+yX\1$뺄2ns $6wOu݁a ӎp$;#UnKM #p=<։tjb)gSSi故n[H{~>3;if쾛stu5wi^|nTZTiGT_H^qvJ+`qm_&:H0iöja3}WT%HK)i>2FհKLکh5GL, v{etFN]!~w+]i|!xִUG!d췉sL$8bSGD(mqDٵitvקuEDžgke5dJY7omRMTFO8?l\s<L4vN~<ۥpŖA}[d"Yfv#kq걧'R->sk-6/R픛RRAQR oJ̯*Ѷ3O29^k<]m cG2tvN@PH)-Nh)4DС* H@ @@4(t1> Ьx:pꌆ]txuM!{?8vrUAd5صal*8c Up-`] zu*v:<@Aco .k]} cX0<*@@@@@@Abl*'[_QH*n@*'[_QPNG  IHDR&>sRGB pHYs+)IDATx^=.ZDHba]ZHi Rh"B`qREईpLE@?d{ݙݙk7n#O=[÷?Wh4qj׿>Mr%#0 .=CW^/0K!`ʉ`W_YYo $#0Q⋯*\[o?17?ģ/_;\2Dz1jBg?Xgxbh5裏{ !r bXaM9qadvdm|w}>@XOw@^XL!G7xO[.]z_Czh'?Ɇ碍L#w!%{J$iqU +><#ҼYRQ4s>,e3@p݂=@@i<=!mIɇݤ>S(R ?!+a"cHd2| {wr(֠w&:_~:&X2m\m@Vx^aB3:1MK뚼NnLҧz 蚮g۔aG7`]|G87˼Y> MM0c3м~[M#يx; Az% y#$T22 #aAc]$27@]d=Dx4:#~Yrf#"xI[a@pX l7l47͉wu8ǣA^".gڎ~q;頡%q+&-rhM9 {l':aa8ꡳf!jӍ900RA АN[ܐr2 : t豖Rɐ9lȖr&M#<˺c"ku8 aM ! #+68AbY5w#(t!Q$ v(3{uB9tvO2P,4yAăirm`z\v͔Stl8RN('L^4@J+ȇjƄb>CRg'L9)OM3>ߗM@ݩJIߵH"f$wsO&^m1${( Vt (jZP4(aA#a^RHs+T5B _y5lؖ*63M! M+"8^?\L9o0B/bXF&XM jlkxD\$mfuOuZ`=SC=]!Prz82F"?ߥ&7`%ѪV[=W.j NV509Xwxb߶Ê9yA@6 ]Oc 8=c橭'r]vTkOWrz0VnѾܻЏ0#ʤBMImX-)lnnD9F$lOTD9&(HutC}tC]0{E"D Rsf]0F:c.\I |` jK9n0 P6R|t_aVSZd8P#`@sr=:#`6A% b)BڴptF`*9T6L$0¸ G|۸7:/qP:7#Pf7-mC!& eJl|%`rFԉ@!UGA;ÅxCk簞;n@|J6CT4#bB]k^ڕaD9Ewjq%67U9!b9n)GI%p] m`C9Cm\n)'t*ypzĞ|q"VNfEHD&J? ``Q8M _W8 t{muBƩRthnkkpFr@P&G<8.xw97#`r+WNJ5O#`@vM9M 8\gh0]L9ߣ"^?i_bG# It )'2m#t[] T~>51\i[]fʉlaFƵ׮]{waT… m >,G"ց/qL9& @u KQպ#0:pߗ 1L,Tmmz/z{5>'54DKRg-ŶtF [1p%)'RN$r ' x+R^]#>L@OєxT_r 怫jjrPψmv%˵mt< Տ 6p3&TJ+V\)qL9K!h }M(Rڐi ԕryqlRN4#=+S`>0dr!pN=[q㏗9#`#pӍ7ILpSs$t>CsX=y+Gչnّl:C'nV8y`Gl2PIϙf5( wsgަȡTϰBVAA)X))_ AdsoRXș<9NP֊+Lu%3ޒ ̓n2oR RSŔrv6#ɝB?\zuvܨ}w UCM HMtS)'_؇XWH.pZ'xb<ê<+75Dds˚/,˔l˾CPS.'U|fg@4hԫ)'_h(H <6r&`/xظ_NLzs%Nq%Xz?)g=?u=}%T&$ OR%M9|߄ģmr1~­aJρ@A8m.:*% 7ea-C9pa7I>VtOd7( Žl< C727z50Wu,=g,)'j)-m5&n<[,E(źqL`׎JSu`"HT / Yp~ C6|CJiG=Wrz([ 87xBp0}a?Օn KABSB0-;B 8@A[o()3t 9'[+2)ة)jHlJVNclL9 H9>k=;rkhWՕ fs/cB(7Dim%ф|3]h^!]\Yι@Hƹ9L9-I9B5%'HjIXk9!"<ڽ/B3*ˌsXwIXT ,7Cyn@{ƌGf.VIdpY񁿐ӰwˋubV8;ŊZ p0Gqb $AvHr7P3D/lLch-ԓ#9Oϓg!btʪ 堻@quEy'#b%8s'd+x=NUt0DApi6wJEiO F74KPt%)gee0m 卒pV͢/en+Cx^z/<̩m8'9N pU-ٕs$~{ 1:bO|3'L?x{O?X/ѯr|׿/+,Bnw}y7no~jo.>Gv!=3VR^z%J?@$#Cdk?Ï?*UF4-µ7?~'Jœd&:>jg!ݏ~1F?9a-PկJ䜽 eh)'Y,u:I %`4I5iCWTWpF@7,)K F/C+A/žv$|7uZ(NgNкPUq : ڽr2^>Ёd&hߗӃd\ޗS,ߗq |+hdVn츱+ؗʅi~Ga1o1X> Eٮm*jB9ۢc`PȠ*cYNB`[_@ujԕ+W ܔki!msrX j)H-'NUX[@ãd4<ǖ!PI͍:SNb§eܷp+s.OkFiُ3/f% :CXFm@r#;2F58"{Xu݌@r#Dc( ^s(6E3FE{P(y3^^3Y-$FA:8wˍF\ٽyjqcµ_;ƃ/w )Κ\Ud*( |c=qzy45L9RD˶:O,ԙ&(ZJܳI-Eֻ`Nl"c[c^HfʉbrKюXF(;Q "Ȍk=G3w=!PTek̞ m-H߱otcFiU Kh0P.e`3OkA+z7[ޏ𼑤uDg@s GEa=*h^VM7eA[;` ؖhV4&gp~Do.qft.€r'8 c'#%w6;Ua#Xh'A{1e]_g|E+-t$KRffgKS:Fvusmve11΢1O+ۦ6&lRJa^r؈͖tfșI%R,irBժksp̙V3b n`b"I8ڼP+ CRÝ9sZJ.wH"k._˜v ! vAi,أgPNie lz+Šs.:23͋M Yt΋lX7)7e4S7&9^Iyi;XV皣hLyr12:7lh% [qZn)gѳc(`᮪yV5Be@>lY'Gq⡱$'C>tFa!HIQ'2{Q VW[HrFaJTr4"ZҪI[anz6%H?=R@92r``5xYv0D  =͙- d,yW.C`'%0]m8ͶG$-.)k4JC)Yl[Vzjd@ApH6 [ yH},و˲)hHglɪ-0,~B K Eg#fAx$C?roC#>+6>t|S:RNq|… W\i}Pd1q+W׬g1AC S++qr6%d9u0S'j^ӧ6tz97{ܬ5_!S T(Gaxt[9pi19wY١{:<8){ݜ5M9$R2;2W Z{>hۘ޹\Sa^BK1?`݃p ᐙϐ +wvĚr"/Ur/=<8d}nk\zXJrJBF_tIUMZE/'So UO:GC5ƂN+<-ޢR!ޓȰ1ߌjʉC<9&u2pT1ڤ.<8y"d#p#Zzk=mُsQh:l|-] z ?\T}8OT@C,eٖ[+Uάc}@]u)[!,m1d4-GgHK&)G&('hF=Hc=ܡ{ذ1h<aR׋2J,}@FoCX}XXY"H( S6=4j`e3(Ac_a$Q:{I\h6 .0u 16 !K.Etcç0eɘ=ةPIe|7 օ G~P3wE9C]6;Zlet0H,zϟϻ?_ӏ &n*f%aBOe]e'()BLI&YAҢ Ӥhr䤄7M>t/l֫R3/ w1 Ly釜0l.B=M93̯l@ t&xWN6f@t:㔭lE&^ 5hPn40PPֳa1F7Oyysm?o ڵkݿ3@h9MqLR y\MCtc-ʕ[@or/ߣx-OXG <5lL9uVk"V k~c0/s3 YaB9m?fԇѶ \M;+[I=XGsI,/2μ ͐;32S6kJD2om9OF kY6ü97V3GZt8HD䩭b!܌@9uId1Wov3OA sE>p罉;J{Vrٶ8l\L9Ŗ0h(t+mc7˂(\ 0 27䉓(s 7u8V gn/XcˡY5?= DHM~n$Vd>Q-@ףV$ x0%ibkH Y gqshKL7Ů>Cx+{77VrKm9A XyMn|? \6KrF(/avijlY #?Lz5aGH>uzn][I ȇ/I+^|"RRz&^G u 0 !r)/I!ݜO- lSe04yIQ"ȼ&b 5Kev0t”)ʲh¥0 l>$zNw *^DǂYr ҆IH=GOha㴨gC{ˊ(gq=hY O[~nDZi GhV@9଼ =0LLH|D 䃔 ) e} A,rN3rt VVgBKOm9\` &{./a ucrRFK$MΙ5#`N`UQMX 46ܳ@μR+>SzD'żR̈́B蝨(g[ $=BH wH<=LI $>}9Ssz#0r ˜5j%v/q" ֌zv)2:-iH -X"&eK3QtgOpA"Tx`nRe. *JywBxUn8)1ӕLD` =v}No:3/ )^Ax:GzgN|ΔFc-/j5 {KFKAH\PrȤSv>G*[inJ(G3rHbR ̂2I+"2n%XUtaF b0}]Љ,9xx\ɟZ (Xk2.Rkqu0*X _&MQn?FA(|zMhCtmpdV8"BĈgA7SN Nc@XX.u<^yԵ ߁nzNkʂ͜h77B:EJ=70) SNM#qb>/TFPbՐ Z!L, u;!-'OH҉Ɍ@H\8W/qF.Q V"E`Ӯ$q-F40)GJ]iBA 1_S ! XrgYݼnʱ솬,(S&i7T`}颌鶔o$Sǯ:,x@3Ѻ|z%-]PN8ԂTخg.&9r,l2\hcȊN+| Eۃ㜳ϻ`&`RFw]pYر]-D M1DIʥD6;` v)ZDH`n[% +@\̣"z6 r"2@٩U@Tgn&!nq~4٤} `=\I3z Fʹ"b\&KKC,6)rU@~$yj8?d?LC{u*-` Ĭ59o^_d|˔Lge@#4yg9ۨj|IBHr"Ɯ 8y]ֶ,8WB=YF8 \Y8wn1=RF MB07zHF@SL}jr]i)g7C 1FL9r0;Gc)gC3FL9<O.~ MMXhdz>:W;Imv:d }~{Nո7T5"`){XE˿Ǎ0!pz\FƷnRi9F3Ѱ5ы8nq~@hrq!a}j EOsr2h߹cW 4xTŦӍsڭ bޑkSzQ+s82H9֭8L9^%fAv[W0L}B_#W\%2|Vr_MƤL9}9ґ8Զ N~XhvSy6Bq8IENDB`bgBe= ON ngBe= ONPNG  IHDR4#m-sRGB pHYs+PLTE555FFFUUUmmmbbb~~~uuuzzzttt55UUFFuubbmm~~†HH!IDAThے0Yx#I j8TƐN?,Cd !2D"Cd !IʖȣVe)*=y+(Yqɺ~'3>j[*U]5^D)AY zeY"$4emlՃ(IW"f2>@vEݏe_fDSyzg"N^֟ڂ":D3w| Et8G1L!:DT rbX /H+JiQڌ<h("SIqqdDYY9$"G ~n(>HyJr"KRaqdDYLYvұZy@CgԵ2 . %)r0Q޹koQ"}|)wo"a EvUgXX,xOF(FUvIaD~NIAA ] L: *膪Ӄ*VfR2͗>US'%wRNV,]"! J` 4]!B\pbNDoTA)Q>%ӼN72E{S>il?%іU/@ QuVOk 3Dџf"CԴX2IENDB`$$$bC"HݤnC"HݤPNG  IHDR6R sRGB pHYs+CIDATx^\X@ aF RPpVՊZZ^EZl-m^:( @ da7!`JN E\{𾶡&8e^P)mP U0CRF{kCҲrrXMV?Ad[|]m]DȗiR־y6zg9#ҮNQEy- Ft+J Y{rY%W寏o=ަfaehv3Lm' MPܟx&bE1u6-(ޕG*VÏ;~0x髗v^ /ugXuǺkSUYDuمI9In&.^{~Vq"}gggJt҆o# [ G00@ihh`X*)p0w\>WYfpppCBWsϮ& Ư6zl_Nѥ|0ۜԜc/vF蛡YO\Ͷ{mlѧL(K'8K@pe +xK䙓]Z,&'w'X&z7 &|sA |[ՒgKs˵טǘ )IJ7zkƜq>#T_C\%S;N᜝}c Wx]u@;dş̫N1Q.t_宯;)EPe"B­ojE* Dejnt=ƞmUmuX?يeRg}g{3̽Ozd[]]]Jl/_ ԗ kii_ q &CգÇACp# Q?i g ]ڑkϑwPL)̨'+k*j>Y l`۾o5i5^;k9ڏV~k.9w'+ po5ED%̭)Wl#W^R3M%8ҡK1gc`KApFq>Y 'jt|xiSrw枃񭓷E[m6 pV"y+0$^ؼ>j=|}L#oZQe)Kj$=Q1Q͞;z[Kf#k| ɄKϋ,v㾍!CT 9>`( ]B;O;!jTBD~~~0Pw}wǎ;w$* lRUUErss{J§ U/ Ӎ6oތU5x )uu3u yS++m6*(0P SBkqmh- H<8y /FʕʢJճWύ75bϥ73MlMVЌ9tg5_bu-7ґU'Mv8m4-iO ܊ƻvAbF =!۸A CRh#08z(~">>r &@lJM`rO垲G3:1IY)9lIJ)?9^Pp.A__ ?17#wʩt/: MP';/X?NQ9C|xy֓\fim8r2̶g>6򂸂Z(#drD5Yg5s4cLfGJ[߄HDbCaoٍJe( aaU({C_OɫIB!TGԱ,bNREE OޝlfT 54el;eTSX+ʾƾ|?}>/O_ g[-P3F[k[B-ƺXA3P}y%ifgg X|iƈo q JmPq `/dȂ o J b7$>b= nkethQ-b)򁛄7EA1\G<yy̫o,7h$M=<0;4&3(}P2!2u7؍jHƻ-RV4kY2ڂ_ s>,YT34`Bah4tqa@ R%@(!tĉXfu۷#2Bs‹ 3V£:|0%rӉ)S"B eUUL+KO1H%<hJ~SG:4-=KTJ#GXԼK 𔀐^3[L':mHOA_]^{:62<,jk*Xef}F۲2+ˀƺz nІ켿3RRcccjggWSSH"""BGGyy8p` ,/HxBe= Qe&X**_,Jvp1t;i|uPp&(ߓ~w.3ћ6K++6}ͽM&-߹ol̎g_H%a Muufq.~y$9v٩ n^\^I7w\X,9wr-J:k,P)Uk rpf? sSUQ{;>DEsrLLš5k,Y"0~u(%dxk*H@1_6 qh0 .]# Adji=,c%c~Z~Ul ~b er/!QQ]c]# [;/;s:<6J_ɭ:s|QX$,/.`blGB$L=_$m&l]m 5)lZ6C& 5 8VsC3FЪ@JT~?;+}RA598MAmKDGG:>pT߸O\)ѝ:\GC IENDB`b \ FDX n \ FDXPNG  IHDRAoބsRGB pHYs+ qIDATx^KM_6Kr rKIeaGP6Ȃ-ldeC 7D%)V꼧9zf4;s\3sf_29:t``0M[~:f̘+Vxg̘1|^zsÇ[H5k̝vήϔ)SF0_|ؼ"h9rȡCtRO2M+!_pرc6RT!yܹ3g~޽{ׯ_8o޼ 6I]v}ӧO_lP^*0!l?j甶6@zjBwnYxɓ$8Y ʧO3"&E&߾}1y[_|) 휝#sݝ2=C;o>hI19sFo+XZ!Q@PRzZz}vIEV̬BZ08#eOI 3- =W^"4,|x4GAYѣQlQk,Ws(~ XS$K(/: eOȜN3VVGL|xȪJ8Gu^CSd~b`MU hg *M,ݖ=4B`~dNJf>ȧ-[ͫ~W$~['6k^*>:22$8Z}&ѣG2pI,]"`߿͛7;wݸq#*F;wr dYŋ-FĉϞ=[G*0pf\ s͛!o$]„ Hd0ܹshN!j7IlIszY۶m1QYpix&~[ gϞ]z 3a-nԸK 5WEĨ~M+0wRk.ܽe˖J[BgMs!6'NW9}i]J[8n8UxOEѣG+3gF.?~={8#+3$.Q=jǤ5a2L_|YhQ1 $蠗;!ן} -i+.+ǏB vޝkC1i$/-Githzö 5l7#@,(Ra{S5hy+89I^]T(u nd?2Kݴl>Ο)G`rx8My܋Uty|K-ar9#ŊA4F*=Eb؎FA|eT=\wHe^Sؔh+j*(2@ĨeϞ=.\8vǏH#{J,K([d #:̚ oܸȜ>̴~-BoڴsUBL|vM>|l4t"Q ]wZ D%ķ,:li=׍`8T WKB!|yG8@eT_[W-OpafPr%R |uZM$G[^2у, U1\Es}NUA BѤ(;!ua2JO9 Ze%\Vbx%G0e[Г+GxB8)betGeu|$)u9}%)M>.ck<^ Ү[RҶ=휦OHsdgE"KD ra嬇$uXnΊ- 63\p{j ><%qMǞ 4IENDB`b S;" T nx S;" TPNG  IHDR4JsRGB pHYs+ IDATx^[OHKjɮu噐z%J F-.\EBD U!-Z\j!<1\HZQ&I˴7o{_Ƿ3g99L\kkpΥX@cNi h9mq=ƜƀИsz>9-1|sN[@ci44Ɯii 8m9-ӘpsN[\'9?0;20`k#֭II?n[!Ur*OMM+%%%n d.?99i+LP r%a.ittә3,RA\Q#GDĉ^\\򓝝-zeӗHXPPP]]hm+W S[[gK)q==)uuԬp1ŧƍñ [OOАD<.VLy9{I134 4@^=VOܹs7:^+b0JuVQ0m$}5Z[ݺ,2u^~Duuu;㳳Fxy#W#7@m<? B~FY233%?~@Mˇ2Ԗ3?Xرc$PFsoC??hxoKz+) 5I5p z] ѪA0?cH%Wp$ógϨ@#9% ,%׮" J@&(m߾]˗F:ubAgwk( T_@b6 {nQAc DW@VtG2&Yq=_O"o%yW$!D0 K'wJZ$###tL?@S9@2 2=hIt^_%'T=ZUZE.O ;~iۯ߅@tɊo^~`sk$Ŀ#9,vІGnVV^0qdYs?a-f[ MX}wzى̴PLNPOBB\#V~ell̊"Іxv/~lИ/m*g1-Mb,q33rX{1/1z]NDe"xo@%pX?佝7rri+_yИ VߌP:#R/]bRm ^~8.aP@F=  ŋaN冋[:v영L\B\ niݨhʟ܇`˖-,ŮC-0!"3aBDal!Q ԉpXgEKșXvsXᆩlLES+ Wq ٳg_fL1ckm 8TԖ%e<,.\pǠku$=L! Gg{ 211A^h]ս]+@C5=%s]C#Han ٴ2l5,-vR?KL燣܅-''gΝs9Iw/#rכ(*Â00@;~.eѫ @:OOj 9H,077Gs3fx7VGƜF[ZZrzN=ڶskGC{hX}mϩ14טskGCy?2IENDB`3 A@@   ;List the parts that are added to the assembly in this step.DFM PART EVAL FACTORDFM PROCESS EVAL FACTOR PROCESS COST/HR SETUP COST/HRPROCESS SETUP TIME (hrs)DEV. START TIME (wk) PART COUNT = %TIME TO LAUNCH%PARTS %PROCESSES STEP COUNT=10. DFM ASSEMBLY EVAL DATA 8. DFM PART EVAL DATAPART DFM EVAL SCORES = ASSEMBLY ANALYSISPROCESS DFM EVAL SCORES = FACTOR SUM FACTOR SUM COST PENALTYUNIT COST RISKDEV TIME END (wks)TOTAL SET UP TIME (Hrs) 12. SUPPLY CHAIN COSTS 13. COMPARATIVE PLANT DATAPart Inventory Direct PartDirect AssemblyIndirect Supply Chain DESIGN HEADER DESIGN NUMBER/VERSION %% NOTES %% INDIRECTUnit Cost RiskAn estimate of the maximum increase in the base line part cost. Causes of increase could be raw material prices, sourcing difficulty, or order quantity limits.DAn estimate of the maximum delay in completing the part development.Quality Control RequirementsPart EliminationcAn assessment of the likelihood this part can be eliminated and why. Select the most likely reason.Select the smallest dimensional tolerance from the design specifications for this part. The scale is generalized, you may opt to adjust this scale based on the specific part fabrication process. Alpha symmetry refers to symmetry about a part's "most repeatable" axis. Beta symmetry is perpendicular to the alpha axis. An Alpha/Beta symmetric part can turn 180 about its axis and have the same orientation. Such parts requires less orientation during assembly.Refers to potential part damage during handling. This may include special containers, packing order, environmental control (e.g. moisture control) or protective covers (e.g. sheets). Methods which are employed simply for productivity should not be considered.Refers to how the part can be feed automatically into an assembly machine. The best case is where existing automatic feed machines can be deployed. 100% manual indicates that at that the part cannot be fed automatically in a reasonable manner.ASSEMBLY PROCESS EVALUATIONESTIMATED ASSEMBLY COSTESTIMATED PART COSTDFM Part PenaltyDFM Process Penalty"TOTAL UNIT PART & MATERIAL COST = % TOTAL UNIT ASSEMBLY PROCESS COST = Previous usage experience with this material (0-1) Standard - Used now (2-3) Speciality - Used now (3-6) Standard - First Use (5-10) Speciality - First Use Ease of locating a reliable source (0-1) Inhouse existing (1-4) Inhouse first time (0-4) Multiple known vendors (2-6) New vendor - large pool (4-10) New Vendor - small pool A2. Sourcing DifficultyA3. In-bound Quality ControlRequired inspection to ensure reliable quality (0) None (1-4) Limited in-process (3-7) 5-10% Sampling (5-10) Significant - High variance B2. Alignment EaseEase with which part is aligned for assembly (0-1) Easy - natural resting (2-4) Locator pins (5-7) Single peg insertion (8-10) Multiple peg insertions Extra time and effort to prevent part damage (0-1) None (2-5) Prevent tangling, scratches, tears, etc. (3-8) Electronic protection (5-10) Individual wrapping  RESPONSE SCALE %lD2. Process ExperienceK2. Inspections Specs{Number of new critical to quality (CTQ) features (0-2) None (3-6) Between 1 and 3 (3-6) Between 4 and 7 (7-10) More than 7 K. QUALITY & TESTINGK3. Process CapabilityThe process potential index (Cp) given by the allowable to actual spread ratio (0-2) Cp > 1.5 (3-7) 1.3 < Cp < 1.5 (6-9) 1.0 < Cp < 1.3 (8-10) Cp < 1.0 D3. Process Failure ModesNumber of new failure modes (process stop, slow, etc.) (0) None (1-3) Between 1 and 2 (4-7) Between 3 and 5 (8-10) More than 5 Projected changes in current equipment output rate (0) 10%+ increase (1) No change (2-5) 0 to 5% decrease (6-7) 5 to 10% decrease (8-10) 10%+ decrease Existing experience with this process (0-2) Mature in-house/vendor (1-5) Similar to existing (4-8) Limited in-house/vendor (8-10) New requires R&DD4. Fastening TypeRatio of new required to available capacity of process equipment (0) 0 to 70% (1-3) 70 to 100% (3-7) 100 to 150% (8-10) More than 150% Need for new machine due to design requirements (0) None required (1-5) Retrofit of existing (4-8) Requires new operator (6-10) Requires new purchase Time and effort required for process implementation (0) Existing, minimal effort (1-5) Moderate training effort (6-10) Complex/Skilled effort YNeed/difficulty in preserving assembly orientation (0-2) None (3-6) Moderate (7-10) High Container movement frequency and equipment (0) Continuous, conveyor (1-4) <15 min, manual (2-7) 15-60 min,manual truck (6-10) 30+ min, power truck qWhere to move for next step (0-2) To immediate vicinity (3-7) To intermediate storage (8-10) Needs to be stocked Orientation symmetry of the part (0) Obvious from key feature (0-2) Alpha or Beta Symmetric (3-6) Alpha or Beta semi-symmetric (7-10) Non Symmetric C3. Part Feed Automation - Part feeding into assembly machines will be (0-2) Automatic on existing (2-5) Automatic needs new (4-8) Manual assisted (5-10) 100% Manual C2. Handling Difficulty - New procedures or devices for handling part (0-2) None required (3-5) <50% change in present (6-8) New procedure (7-10) New handling device C1. Part Damage - Extra time and effort to prevent part damage (0-1) None (2-5) Prevent tangling, scratches, tears, etc. (3-8) Electronic protection (5-10) Individual wrapping A1. Material Knowledge -Previous usage experience with this material (0-1) Standard - Used now (2-3) Speciality - Used now (3-6) Standard - First Use (5-10) Speciality - First Use A2. Sourcing Difficulty - Ease of locating a reliable source (0-1) Inhouse existing (1-4) Inhouse first time (0-4) Multiple known vendors (2-6) New vendor - large pool (4-10) New Vendor - small pool A3. In-bound Quality Control - Required inspection to ensure reliable quality (0) None (1-4) Limited in-process (3-7) 5-10% Sampling (5-10) Significant - High variance Process Cost / hrThere are two options to enter the process cost. If a reliable hourly cost is available enter the amount directly. Alternatively you may use the ProDFM CostCalc. To do activate the CostCalc option and then click on the Calculate Now button.Setup Cost / hr)The aggregated plant cost per setup hour.Required Development TimeMaximum Develop Time RiskStart DevelopmentREQUIRED DEVELOPMENT TIME - MAXIMUM DEVELOP TIME RISK - START DEVELOPMENT - }The time in weeks, required to develop the process (design, validate, and tooling). For an existing process the time is zero.GAn estimate of the maximum delay in completing the process development.How many weeks into the NPD project is the development of this passembly process likely to start. The end time is derived as the sum of the start time plus the development time.List any new and existing equipment or production lines/cells that are expected to be used in this step. While all details may not be readily available include all that is known.A brief description of the process including type (e.g., welding). This will allow members of the NPD team to immediately understand what the process does and how it will be done.Setup Time (hrs)The estimated total time (internal plus external) to setup the machine for executing this step. Note that if CostCalc is used this value will be automatically filled in.Production Rate / hrAverage Batch SizeMax Process Cost Risk (%)Target Quality Reject Rate (%)FThe estimated output in units per hour from this assembly process step 11. ASSEMBLY COSTCALC DETAILSDefault ProcessAn estimate of the average production batch size after the initial production launch phase (6 months). Where the line is dedicated then enter the weekly output and enter setup time as zero.An estimate of the maximum increase in the hourly process cost. Causes of increase could be varainaces in abor times, output rates, and batch sizes.The expected reject rate (1-yield) from the assembly process< . For instance if we expect 25 in a batch of 1000 will fail then the reject rate is 2.5%.CostCalcThe CostCalc lets you specify the detailed labor and equipment requirements for this assembly step, including equipment setup times. After entering thhe data click on Calculate to derive the CostCalc summary. Confirm your enetered data and then click on Update process Sheet. Labor DetailsEnter for upto 4 operators. Hourly Rate - operator labor cost. Productivity - relative to the production rate (80% implies only 80% output). Busy Time - what % of time is dedicated to this step, if he operates 2 machines then 50%, if he works for10 mins in a 100 min run then 10%.Equipment DetailsEnter for upto 3 equipment. Hourly Rate - cost to operate the machine minus labor. Utilization - % of run time that the machine is busy on this step, if a blender is needed for 5 mins in a 50 min step then 10%. Setup Time - time to setup a batch run.B1. Dimensional Tolerance - Smallest dimensional tolerance for critical features of the part (0) +/- 0.01 inch (1-3) +/- 0.005 inch (4-7) +/- 0.001 inch (8-10) +/- 0.0001 inch B2. Alignment Ease - Ease with which part is aligned for assembly (0-1) Easy - natural resting (2-4) Locator pins (5-7) Single peg insertion (8-10) Multiple peg insertions B3. Part Symmetry - Orientation symmetry of the part (0) Obvious from key feature (0-2) Alpha or Beta Symmetric (3-6) Alpha or Beta semi-symmetric (7-10) Non Symmetric D1. Steady Yield Interval - Time for new batch to reach steady state (0-3) < 2% of batch time (2-5) 2-4% of batch time (5-8) 4-6% of batch time (8-10) > 6% of batch time D2. Process Experience - Existing experience with this process (0-2) Mature in-house/vendor (1-5) Similar to existing (4-8) Limited in-house/vendor (8-10) New requires R&D D3. Process Failure Modes - Number of new failure modes (process stop, slow, etc.) (0) None (1-3) Between 1 and 2 (4-7) Between 3 and 5 (8-10) More than 5 D5. Output Rate - Projected changes in current equipment output rate (0) 10%+ increase (1) No change (2-5) 0 to 5% decrease (6-7) 5 to 10% decrease (8-10) 10%+ decrease E1. Available capacity - Ratio of new required to available capacity of process equipment (0) 0 to 70% (1-3) 70 to 100% (3-7) 100 to 150% (8-10) More than 150% E2. New Machine - Need for new machine due to design requirements (0) None required (1-5) Retrofit of existing (4-8) Requires new operator (6-10) Requires new purchase E3. Process Control Design - Time and effort required for process implementation (0) Existing, minimal effort (1-5) Moderate training effort (6-10) Complex/Skilled effort F1. New Tooling - Need for new tool due to design features (0) None required (1-2) <10% retrofit of existing (3-5) <50% retrofit of existing (5-8) Existing vendor purchase (7-10) New vendor purchase F2. Complexity - Extra time and effort for tool configuration (0-3) Standard, no extra (4-7) Some extra effort (8-10) Significant extra effort G1. Setup Time - Projected time to complete setup activity (internal) (0-2) Less than 10 mins (3-5) 10 to 15 mins (6-8) 15 to 30 mins (9-10) 30+ mins G2. Commonality - Setup process that is common to similar products (0) 100% commonality (1-3) 80 to 100% commonality (4-7) 50 to 80% commonality (8-10) < 50% commonality  ALTERNATE PLANTSH1. Container - Container movement frequency and equipment (0) Continuous, conveyor (1-4) <15 min, manual (2-7) 15-60 min,manual truck (6-10) 30+ min, power truck mH2. Orientation - Need/difficulty in preserving assembly orientation (0-2) None (3-6) Moderate (7-10) High J1. Production Volumes - Batch runs at end of year-1 are expected to be (0-3) 20+ hours (4-7) 10 to 20 hours (8-10) Less than 10 hours J2. Work-in-Process - Where to move for next step (0-2) To immediate vicinity (3-7) To intermediate storage (8-10) Needs to be stocked K1. Test Process Experience - Existing test process experience (0-2) Mature (3-7) Reconfigure current (6-9) Limited - new equipment (8-10) None - new equipment K2. Inspections Specs - Number of new critical to quality (CTQ) features (0-2) None (3-6) Between 1 and 3 (3-6) Between 4 and 7 (7-10) More than 7 K3. Process Capability - The process potential index (Cp) given by the allowable to actual spread ratio (0-2) Cp > 1.5 (3-7) 1.3 < Cp < 1.5 (6-9) 1.0 < Cp < 1.3 (8-10) Cp < 1.0 Number of Part VariantsCount Quantity / UnitFNumber of the part or material quantity used in each product assembly.Order QuantityUnit Part CostAn estimate of the base line part. For procured parts the costs is taken from and initial vendor quote, for in-house parts the a plant quote is used. PRODUCTION COST ANALYTICS DESIGN DEVELOPMENT TIME LINEQUALITY REJECT ESTIMATED DFM PART ANALYTICSMax DFM Part Eval Factor =Highest Cost Criterion = DFM PROCESS ANALYTICSMax DFM Proc Eval Factor = (0.0) - No%TOTAL  COST RISK %PART ELIMINATIONQC REQUIREMENTS Default PartDATE =A. PROCUREMENTA1. Material KnowledgeSmallest dimensional tolerance for critical features of the part (0) +/- 0.01 inch (1-3) +/- 0.005 inch (4-7) +/- 0.001 inch (8-10) +/- 0.0001 inch C. PART HANDLINGPart feeding into assembly machines will be (0-2) Automatic on existing (2-5) Automatic needs new (4-8) Manual assisted (5-10) 100% Manual D1. Steady Yield IntervalTime for new batch to reach steady state (0-3) < 2% of batch time (2-5) 2-4% of batch time (5-8) 4-6% of batch time (8-10) > 6% of batch time D. PROCESS DIFFICULTYBATCH SETUP TIME (hrs) DIRECT TOTAL PART COST =  INDIRECT TOTAL PART COST = " INBOUND UNIT SUPPLY CHAIN COST =PART INVENTORY EVAL FACTOR = MAXAVERAGEDFM PART EVAL FACTORS = DFM PROCESS EVAL FACTORS = 2 DFM EVAL FACTORS (Used to calculate cost penalty)MAXIMUMFACTOR DFM PART EVALDFM PROCESS EVAL DFM EVALUATION SUMMARYThe 0 score represents an optimal condition implying that no significant impact on the manufacturing cost and effort will be experienced. Conversely a score of 10 implies the worst case where the maximum negative impact is expected. %TOTAL %COST RISK% DFM+INV PENALTY%DFM+INV PENALTYPARTS ANALYSIS  RATIO TO EUP %NUMBER OF PARTS =TOTAL PART COST RISK =MAXIMUM PART COST =CompObjHMRaVBFrameT*validateform)Py%@Η%fYCTOTAL UNIT PART COST =TOTAL UNIT ASSEMBLY COST = TOTAL ASSEMBLY COST RISK = MAXIMUM ASSEMBLY COST = NUMBER OF PROCESS STEPS =  UNIT PRODUCTION COST SUMMARY" PRODUCT DEVELOPMENT TIME SUMMARYPART DEV TIME RISK (Weeks) =  REQD. PART DEV TIME (Weeks) = ' ESTIMATED UNIT PRODUCTION (EUP) COST =)ESTMATED DEVELOPMENT TIME (EDT) (Weeks) =  RATIO TO EDT %!PART DEV TIME DURATION (Weeks) = $PROCESS DEV TIME DURATION (Weeks) = " REQD. PROCESS DEV TIME (Weeks) = PROCESS DEV TIME RISK (Weeks) = TOTAL =RELATIVE TO EUP COST %RELATIVE TO EUP COST % &ESTIMATED UNIT PRODUCTION (EUP) COST =#3. NPD/DFM EXECUTIVE SUMMARY REPORT LABOR COSTS! 6. DFM EVALUATION SUMMARY REPORT(4. ESTIMATED UNIT PRODUCTION COST REPORTPROCESS COST RISK RANGE (%)1. NPD/DFM ANALYSIS COVER PAGE PRODUCT NAME % % PROJECT MANAGER %% Design Team % % Manufacturing Team %% Marketing Team %% Supply Chain Team %% NPD/DFM TEAM NPD/DFM ANALYSIS START DATE % %ORDER QTY (wks of supply) 7. PART/MATERIAL DATA) 5. ANALYSIS OF PRODUCTION COSTS BY PLANTCOMMENTSPART. DEV. TIME (wks)PROD RATE / HRINVENTORY EVAL FACTOR PART & MATERIAL COST ESTIMATES ASSEMBLY PROCESS COST ESTIMATESINV+DFM COST PENALTYPART SUPPLY CHAIN COSTPROD BATCH SIZE 9. ASSEMBLY PROCESS DATAPROCESS EQUIPMENTPROCESS DEV. TIME (wks)PROCESS TOOLINGTOTAL UNIT PART COSTS % DIRECT TOTAL ASSEMBLY C< OST = INDIRECT TOTAL ASSEMBLY COST = TOTAL UNIT ASSEMBLY COSTS % REPORT DATE =UNIT PART COSTMATERIAL"OUTBOUND UNIT SUPPLY CHAIN COST = INDIRECT PART RATE = OUTBOUND UNIT SUPPLY CHAIN COSTINBOUND UNIT SUPPLY CHAIN COSTS PLANT LOCATIONPLANT LOCATION % PART OR MATERIAL NAMEOPERATING COST/HRTOTAL DIRECT ASSEMBLY COST =  EQUIPMENT COSTSUTILIZATION (%)NET COST / HOURINDIRECT PRODUCT RATEINDIRECT PROCESS RATE DFM PART EVAL FACTOR Weighted % OPERATOR 2 OPERATOR 3 OPERATOR 4 TOTAL SCORE (Column Sum) OPERATOR 1" DFM PROCESS EVAL FACTOR Weighted % PRODUCT = UNIT PROD COST SUPPLY CHAIN COSTS. RELATIVE COST FACTORS% 2. DESIGN REVIEW DFM ACTION ITEM LOGPROBLEM/OPPORTUNITY ASSEMBLY COST PART COSTMANUFACTURING TEAM NOTESA description of the various criteria and sub-criteria used in the Pro-DFM analysis is provided below, along with guidelines for selecting the applicable response for each criteria in a given case. Note that the response scale is 0 (best) to 10 (worst).%CRITICAL FEATURES AND NEW TECHNOLGIES PRODUCT = PART COUNTTOTAL EQUIPMENT COST/HRHOURLY RATE ($/hr)PRODUCTIVITY (%) BUSY TIME (%) EQUIPMENT 1 SET UP TIME EQUIPMENT 2 EQUIPMENT 3@Oprator Variables Hourly Rate Productivity Busy time Gross CostBEquipment variables Hourly Rate Utilization Setup time Gross Cost Labor CostEquipment Rate SetUp timeCOUNT / QTY PER UNITDEV. TIME RISK (wks)PART OR MATERIAL NAMEPLANT =QUALITY REJECT RATEINDIRECT PART =INDIRECT PROC =INDIRECT PROCESS RATE = LABOR RATE PRODUCTIVITY SETUP COSTSINDIRECT PRODUCTINDIRECT PROCESSPLANT #NO. OF PART VARIANTSTOTAL LABOR COST/HRPLANT LOCATIONDIRECT INDIRECT LocationSTEP #ASSEMBLY PROCESSPART #B. PART GEOMETRYB1. Dimensional ToleranceB3. Part Symmetry C. HANDLINGC1. Part DamageC2. Handling Difficulty PART/MATERIAL PRIMARY FUNCTIONAL REQUIREMENTS COUNT QTYDATECRITERIA DESCRIPTIONPART EVALUATIONDESIGN TEAM NOTESC3. Part Feed AutomationThe product will be manufactured by a series of assembly process steps, typically listed in the process plan. Identify each process step, as each will be individually analyzed. DescriptionProcess EquipmentProcess ToolingList any new and existing tooling (molds, dies, etc.) that are expected to be used. No need to specify common tools (wrench) or those that are dedicated to the process equipment.Refers to any new part handling requirements. New would imply that currently this is not a requirement for manufacturing operations. An example would be that a new stacking container is needed, or that a new unload tool is required.ALERTSPART REDUCTION OPPORTUNITY = This refers exclusively to the time and effort associated with tool setup and configuration for the new design. If the effort is the same as current equivalent tooling then we consider it as standard. If the effort is estimated as 25% more then it is considered a some extra effort. ITEM #LOG DATE CLOSE DATE LEAD PERSONPART/PROCESS EFFECTED HOW RESOLVEDPROGRESS NOTES Refers to our knowledge and experience with the product testing process. Mature implies 5 + years of processing experience, while limited implies 1+ years experience. A new process implies less than 1 year experience, while none implies it is a new testing process.This estimates the setup efficiencies associated with production step. Longer batch runs ensure better economics and less manual monitoring since the line is in steady state condition./1. Pro-DFM Worksheet initialized for new design&2. First Review of Part DFM Evaluation&3. First Review Process DFM Evaluation@4. Manufacturing Team Review of Pro-DFM Manufacturability Report36. Final Review of Part and Process DFM Evaluations17. Acceptance of Pro-DFM Executive Summary Report PROJECT PLANALERT SCORE LIMIT = Primary FRsIdentifies design features which are critical to the functionality of the part and the final assembly. Typically, these features will be of the highest priority in quality control activities. eAn assessment of the likelihood this part can be eliminated and why. Select the most likely reason. Primary part attributes to be evaluated and inspected before/after the part is assembled to the product. This provides guidance to manufacturing about what are the CTQs.  TOTAL SCORE (Column Sum)NOTESD5. Output Rate E. EQUIPMENTE1. Available capacityE2. New MachineE3. Process Control Design F. TOOLINGF1. New ToolingF2. ComplexityG. SETUPG1. Setup TimeG2. Commonality H. HANDLING H1. ContainerH2. Orientation J. INVENTORYJ1. Production VolumesJ2. Work-in-Process K. TESTINGK1. Test Process Experience AVERAGE SCORE MAXIMUM SCORE PART EVALUATION PROCESS EVALUATIONEVENT14. HELP SHEETPART/MATERIAL - COUNT QUANTITY / UNIT - NUMBER OF PART VARIANTS - MATERIAL - ORDER QUANTITY - 'CRITICAL FEATURES & NEW TECHNOLOGIES - PART ELIMINATION - QUALITY CONTROL REQUIREMENTS - UNIT PART COST - UNIT COST RISK - Functional requirements (FRs) describe what the part is supposed to do. For example, for a refrigerator door the FRs are to keep cold air in, and allow inside access. Functional requirements (FRs) describe what the part is supposed to do. For example, for a refrigerator door the FRs are to keep cold air in, and allow inside access.PRIMARY FRS - New procedures or devices for handling part (0-2) None required (3-5) <50% change in present (6-8) New procedure (7-10) New handling device Need for new tool due to design features (0) None required (1-2) <10% retrofit of existing (3-5) <50% retrofit of existing (5-8) Existing vendor purchase (7-10) New vendor purchase Existing test process experience (0-2) Mature (3-7) Reconfigure current (6-9) Limited - new equipment (8-10) None - new equipment nBatch runs at end of year-1 are expected to be (0-3) 20+ hours (4-7) 10 to 20 hours (8-10) Less than 10 hours ~Extra time and effort for tool configuration (0-3) Standard, no extra (4-7) Some extra effort (8-10) Significant extra effort Projected time to complete setup activity (internal) (0-2) Less than 10 mins (3-5) 10 to 15 mins (6-8) 15 to 30 mins (9-10) 30+ mins Setup process that is common to similar products (0) 100% commonality (1-3) 80 to 100% commonality (4-7) 50 to 80% commonality (8-10) < 50% commonality PARTS ASSEMBLED Part/MaterialTWill typically be a Bill of Material item retrieved from the product specifications.MaterialbIdentifies the primary material of the part. Should be obtained from BOM or design specifications.Identifies design features which are critical to the functionality of the part and the final assembly. Typically, these features will be of the highest priority in quality control activities.How long after setup an acceptable yield is reached. Will depend on the number of configurable factors and their interrelationship. For example in injection molding we may need to adjust temperatures and pressure for the next 20 cycles to attain stability. Refers to the number of new critical to quality features. For example, in a current assembly operation inspection focuses on two attributes, in the new product we may require that two additional attributes be inspected. Then the selection would be between 1 and 3.Refers to process failure modes related to this specific design. A failure mode occurs when the process either stops, slows significantly, or has a drop in quality yield. For example a new geometry bottle label starts to misfeed causing process halt.The product will be manufactured by a series of assembly process steps, typically listed in the process plan. Identify each process step, as each will be individually analyzed. ASSEMBLY PROCESS -PROCESS EQUIPMENT - DESCRIPTION -< PROCESS TOOLING -PROCESS COST / HR -SETUP TIME (HRS) -SETUP COST / HR -REQUIRED DEVELOPMENT TIME -MAXIMUM DEVELOP TIME RISK -START DEVELOPMENT -PRODUCTION RATE / HR -AVERAGE BATCH SIZE -MAX PROCESS COST RISK (%) - TARGET QUALITY REJECT RATE (%) - COSTCALC -A brief description of the process including type (e.g., welding). This will allow members of the NPD team to immediately understand what the process does and how it will be done. List any new and existing equipment or production lines/cells that are expected to be used in this step. While all details may not be readily available include all that is known. List any new and existing tooling (molds, dies, etc.) that are expected to be used. No need to specify common tools (wrench) or those that are dedicated to the process equipment. There are two options to enter the process cost. If a reliable hourly cost is available enter the amount directly. Alternatively you may use the ProDFM CostCalc. To do activate the CostCalc option and then click on the Calculate Now button. The estimated total time (internal plus external) to setup the machine for executing this step. Note that if CostCalc is used this value will be automatically filled in. +The aggregated plant cost per setup hour. The time in weeks, required to develop the process (design, validate, and tooling). For an existing process the time is zero. IAn estimate of the maximum delay in completing the process development. How many weeks into the NPD project is the development of this passembly process likely to start. The end time is derived as the sum of the start time plus the development time. IThe estimated output in units per hour from this assembly process step. An estimate of the average production batch size after the initial production launch phase (6 months). Where the line is dedicated then enter the weekly output and enter setup time as zero. An estimate of the maximum increase in the hourly process cost. Causes of increase could be varainaces in abor times, output rates, and batch sizes. The expected reject rate (1-yield) from the assembly process. For instance if we expect 25 in a batch of 1000 will fail then the reject rate is 2.5%. The CostCalc lets you specify the detailed labor and equipment requirements for this assembly step, including equipment setup times. After entering thhe data click on Calculate to derive the CostCalc summary. Confirm your enetered data and then click on Update process Sheet. LABOR DETAILS -EQUIPMENT DETAILS -PARTS ASSEMBLED -SCORE ANALYSISFACTOR ANALYSISEnter for upto 4 operators. Hourly Rate - operator labor cost. Productivity - relative to the production rate (80% implies only 80% output). Busy Time - what % of time is dedicated to this step, if he operates 2 machines then 50%, if he works for10 mins in a 100 min run then 10%. Enter for upto 3 equipment. Hourly Rate - cost to operate the machine minus labor. Utilization - % of run time that the machine is busy on this step, if a blender is needed for 5 mins in a 50 min step then 10%. Setup Time - time to setup a batch run. =List the parts that are added to the assembly in this step. Primary fastener type used in this step (0-2) Integrated with assembly (snaps etc.) (3-5) Rivets, staples,& adhesive (5-7) Screws & Nails (8-10) Multi-pieces (nut & bolt) D4. Fastening Type - Primary fastener type used in this step (0-2) Integrated with assembly (snaps etc.) (3-5) Rivets, staples,& adhesive (5-7) Screws & Nails (8-10) Multi-pieces (nut & bolt) The type of fastener used to complete this step. Where multiple fasteners types are used, select the highest applicable score. If the fastener is not listed use an approximation from the scale. When assembly is done on existing equipment then this refers to any changes in the output rate. For example if the new design requires the process rate be reduced by 5% this would imply higher production costs. If a new press or equipment is be used select no change.The available machine capacity is 100 minus the average utilization. The ratio between the required new and available capacity is indicative of scheduling constraints. For example if the available capacity is 15 hrs/week and the new requirements is 5 hrs/week then the ratio is 33%. When the new design cannot be produced on any existing machine then this may require the purchase of a new machine. When retrofit of an existing machine will bring in the capability then the retrofit option is selected. For example we may need to add a heater to a machine.#Refers to the time and effort required by manufacturing to install this manufacturing step in the plant. For an existing process with no change select minimal. Select moderate when less than 10 man days or training will be involved. For more than 10 man days we consider it a complex effort.When the design cannot be produced with existing tooling then this may require the purchase of a new tool. Select retrofit when a current tools can be adapted. When a new tool has to be purchased select the appropriate vendor option.Internal setup time consists of activities that must be done when the equipment is stopped. For example the die cutter cannot be removed while the machine is running. The projected setup time is estimated and scaled. If no reliable estimate is available select Less than 10 mins. Ideally if the setup for the new design is identical to an existing design this would imply little training. Here we evaluate the degree of commonality. For example if 2 of 4 steps are common then the commonality is 50%. Where the setup is completely new then the last option is selected.Refers to both the frequency and how the product is handled between steps. Longer frequencies imply higher WIP inventory, while handling equipment implies overhead. When the part moves automatically to the next step, select continuous. If a fork lift is needed select power truck./For parts with orientation an attempt must be made to preserve it during handling. For parts with no specific orientation (e.g. circle) select none. When orienting features are difficult to detect, select none. An example of moderate would be a rectangular shape, which is easily reoriented by stacking.How the WIP inventory will be stored between steps. Immediate vicinity implies a short distance to the subsequent machine. If moved first to a holding area and then moved again select intermediate. If moved to warehouse space and then retrieved select needs to be stocked.INBOUNDOUTBOUNDVWill typically be a Bill of Material item retrieved from the product specifications. HNumber of the part or material quantity used in each product assembly. Where several variations (color, size, etc.) of the part are used depending on assembly model, list the number of different SKUs. dIdentifies the primary material of the part. Should be obtained from BOM or design specifications. The quantity in which the part/material is ordered, as measured by the weeks of supply. For example if the order quantity is 1000 and the average weekly demand is 100, then we have a 10 week inventory at order receipt. An estimate of the base line part. For procured parts the costs is taken from and initial vendor quote, for in-house parts the a plant quote is used. An estimate of the maximum increase in the base line part cost. Causes of increase could be raw material prices, sourcing difficulty, or order quantity limits. The time in weeks, required to develop the part (design, test, and source). For an existing part the time is zero. This time provides a window for any DFM motivated changes. FAn estimate of the maximum delay in completing the part development. How many weeks into the NPD project is the development of this part likely to start. The end time is derived as the sum of the start time plus the development time. The process capability index (Cp) is the ratio between the allowable and actual spread of key quality dimensions or attributes (e.g., weight, color, etc.). Estimate the Cp from past process history and select accordingly. <% For a new process use similar data.Where several variations (color, size, etc.) of the part are used depending on assembly model, list the number of different SKUs.The quantity in which the part/material is ordered, as measured by the weeks of supply. For example if the order quantity is 1000 and the average weekly demand is 100, then we have a 10 week inventory at order receipt.The time in weeks, required to develop the part (design, test, and source). For an existing part the time is zero. This time provides a window for any DFM motivated changes.How many weeks into the NPD project is the development of this part likely to start. The end time is derived as the sum of the start time plus the development time.$Critical Features & New TechnologiesPrimary part attributes to be evaluated and inspected before/after the part is assembled to the product. This provides guidance to manufacturing about what are the CTQs.Refers to the primary part material. Evaluates the potential for manufacturing difficulties with this material on the basis of previous experience. A specialty part is made to the design specs. A first use material is one which has not actively been used in the past 5 years.Refers to the difficulty in finding a reliable vendor source. In-house indicates the part will be made at our facility. A known vendor is one with which the company has done business in the last three years. A large pool is 10+ vendors.65. NPD Team Review of Pro-DFM Executive Summary ReportEffort to inspect parts before assembly. Limited in-process refers to visual inspection by the process operator. Sampling refers to the inspection quantity using a tool or device. High variance indicates the part source is unreliable and rejects could be 4%+.A part needs to be aligned or positioned prior to assembly. If the alignment is obvious select natural resting. Where locator pins are provided than the alignment is facilitated. If the assembly is of the peg-in-hole type select the appropriate scale. Refers to our existing experience with the manufacturing process. Mature implies 5 + years of processing experience, while limited implies 1+ years experience. Where the process knowledge is readily available from an existing process then it is classified as similar.Assembly ProcessParts Assembled K#.IDB ~ +4M^" ͹1{v\ n &@{O `_EVZ[ ) N,leTG,3W'# )X|(( cc@z     dMbP?_*+%&?'?(?)?MKhp psc 2200 series!@m߀dBe@RLdArial8'Beںں\\BASEMENT\hp psc 2200 series,LocalOnly,DrvConvert"^XU} 7} 7} -7}  7} 7} (7} $7} $ 7f@ !@ @@@! !! ! ! !  @ X@X@X@X@X@X@X@ /@  !  p mi  q nj  q! oj! rlk, " s'(),# t*+,, # t *+,, # t *+,, $ u -./,  v wL %q &  qd  qe  qf  j qg  q  qh  ri . ,((*.****>(((,(((.((  ( ( t@JA(global_splashWelcome to ConvaTec9]&`, ( t@JA(global_splashWelcome to ConvaTec9]&`-~v ( <%A@AA?]&. xp ( 6A@AA?6[6]&/ | ( B'6O,A @AA?&]&/ >@<d z      7 Sheet10bb"  ;/5  dMbP?_*+%&?'?(?)?MKhp psc 2200 series!@m߀dBe@RLdArial8'Beںں\\BASEMENT\hp psc 2200 series,LocalOnly,DrvConvert"]XU} 7} 7} 7}  7} 7}  7} 7} 7} $ 7  f@  !  @  X @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @   20!PK'1.Cover Page'!E4B1 "@@!A  [ \ ] ^  _ ` a~ ?~ @~ @~ @~ @~ @ ~ @ ~  @ ~ "@ ~ $@ ~ &@~ (@~ *@~ ,@~ .@~ 0@~ 1@~ 2@~ 3@~ 4@4&z&&&&&&&&&&&&&&&&&&&  J  @2(  @| @ B'6O,A@AA?c!]&4 ~v  @ <%A@AA?+]& d4 >@<d  7 Sheet3bb"  _AY@`f  dMbP?_*+%5&?'?(?)?MKhp psc 2200 series!@m߀dBe@RLdArial8'Beںں\\BASEMENT\hp psc 2200 series,LocalOnly,DrvConvert"ZXX??U} 7}  7} 7}  7} 7} 7} 7}  7} 7} 7} 7} 7} $ 7_  O@  @  @  @ -@ @ < <@  @  @  @  @  @  @ f@  @ @ @ @ @ f@  @ @ @ @ @  @ @ @ @ @ @  2!'1.Cover Page'!E4B / ? "\@@!A9::;  6! '4.Prod Cost Est.'!E4B <6! '4.Prod Cost Est.'!G4B =6! '4.Prod Cost Est.'!I4B  > ???  $?! $$B A 2!'7.DATA-Parts'!M6B A ~ ?  A    K         r"   8 ! "'6.DFM Eval Summary'!f3B   8 !"'6.DFM Eval Summary'!H3B  16 B?!  '4.Prod Cost Est.'!L6B  6 !  '4.Prod Cost Est.'!D9B= ! 'D D DB  6 !  '4.Prod Cost Est.'!H9B= ! 'D D DB CD   6 !  '4.Prod Cost Est.'!E9B= ! 'D D DB  6 !  '4.Prod Cost Est.'!I9B= ! 'D D DB 26 B?!  '4.Prod Cost Est.'!L8B  ! !  D D = ! 'D D DB  ! !  D D = !'D D DB CD EF       !D  ? D   CD  2!'7.DATA-Parts'!J6B=!'D DDB 6!  '9.DATA-Processes'!J6B=!'D DDB  CD  2@!'7.DATA-Parts'!K6B=!'D DDB 6! '9.DATA-Processes'!K6B=!'D DDB  CD  E E E E E E EEF                ?@!)'6.DFM Eval Summary'!D6:D8"B@!t'6.DFM Eval Summary'!C6B'6.DFM Eval Summary'!C7B'6.DFM Eval Summary'!C8B   9@!#'6.DFM Eval Summary'!E19BF! 0'4.Prod Cost Est.'!H14B@D@  CD  0 ! D A@!+'6.DFM Eval Summary'!D10:D16"B!@! '6.DFM Eval Summary'!C10B'6.DFM Eval Summary'!C11B'6.DFM Eval Summary'!C12B'6.DFM Eval Summary'!C13B'6.DFM Eval Summary'!C14B'6.DFM Eval Summary'!C15B'6.DFM Eval Summary'!C16B 9@!#'6.DFM Eval Summary'!E20B6! '4.Prod Cost Est.'!O6B  CD  1 !D YY!CD  *'8.DATA-Parts Eval'!F7BD B E 7! !'4.Prod Cost Est.'!P14B7!!'4.Prod Cost Est.'!O14B  EF   ! D QQQQQQQQ  B !,'4.Prod Cost Est.'!D6BD D no  < ! &'4.Prod Cost Est.'!H6BD no  S ! ='4.Prod Cost Est.'!D7B'4.Prod Cost Est.'!H7Bno  S ! ='4.Prod Cost Est.'!D8B'4.Prod Cost Est.'!H8Bno # !1K % no Dl*@\ 4n *H00r*vLL~lG  @! @" @# @$ @% @& @' @( @) @* @+ @, @- @. @/ @0 @1 @2 @3 @4 @ 5 @6 7 8 9 : ; < = > ?  no !no "no #no $no %no &no 'no (no )no *no +no ,no -no .no /no 0no 1no 2no 3no 4pqqqqqqqq 55 6no 7no 8no 9no :no ;no <no =no >no ?no DLl*@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^  @no Ano Bno Cno Dno Eno Fno Gno Hno Ino Jno Kno Lno Mno Nno Ono Pno Qno Rno Sno Tno Uno Vno Wno Xno Yno Zno [no \no ]no ^pqqqqqqqq BXH  q q   Es     Cos 08 (  8 8 t@JA(global_splashWelcome to ConvaTec]&`7 8 t@JA(global_splashWelcome to ConvaTec]&`8 8 t@JA(global_splashWelcome to ConvaTec]&`9 8 t@JA(global_splashWelcome to ConvaTecS]&`: 8 t@JA(global_splashWelcome to ConvaTec  ]&`|; 8 t@JA(global_splashWelcome to ConvaTec_]&`d< 8 t@JA(global_splashWelcome to ConvaTecm]&`L= 8 t@JA(global_splashWelcome to ConvaTec_]&`4>  8 t@JA(global_splashWelcome to ConvaTec5]& `?| 8 B'6O,A@AA?z! ]&@ ~v 8 <%A@AA? & ]&`@ xp 8 6NMM?m04]XA  "XA??3` h3` "D 4` h5` 3V~J3 d] 3QQ ; Q ; Q3_ O   MM< 43_ O 3  MM< 43_ O 2  MM< 43_ O   MM< 43_ O ff6  MM< 43_ O   MM< 43_ O   MM< 43_ O   MM< 4E4D$% MP(3O&5Q4$% MP(3O&3Q4FA( 3O 3" 44% L)iMZ3O6n&VQ $EUP Cost Roll-up'4% M3O&4Q'PP PZaajkR R R Rkk S S4S S 4eee xp 8 6NMM? {(7]B  MKhp psc 2200 series!@m߀DrdXBe@RLdArial8'Beںں\\BASEMENT\hp psc 2200 series,LocalOnly,DrvConvert"dXX??3` J6` J7`  U* կ3 d 3QQ9 Q9 Q3_4E4D $% MP(3O&7Q4$% MP(3O&6Q4FAJ  3OJ  3 b#M!  O43*N#M! M! M NM43" :dd44% PMP3O&UQ F!DFM Part + Inventory Penalty Cost'44e?ee xp 8 6NMM?' {4] C  "C??3` J8` J9`  W ժ3 d23 M NM4 3QQ9%Q9$Q3_4E4D $% MP(3O&9Q4$% MP(3O&8Q4FAJ  3OJ  3 b#M!  O43*N#M! M! M NM43" :dd44% qRMP3O&WQ 4DFM Process Penalty Cost'44e?ee xp 8 6NMM?5 5](D  "(D??3` 8:` '3;` #)<` '3=` #)> 3 dB 3QQQQ3_ M NM  MM<4E4 3QQQQ3_ O ff6  MM<4E4 3QQQQ3_4E4 3_ M NM  MM<4 3_ M NM  MM<43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<4D$% MP(3O&=Q4$% MP(3O&;Q4FAc` 3Oue 3 bPP PZaajkR R R RR RV VdtP!M&>! M NMS S43*!M&>! M NM4%  7M3O &<Q WEEKS'43" :dd4S S4% FCMP3O6 &:Q .PART DEVELOPMENT TIME'4S S 4e???ee xp 8 6NMM?s5 5]D  MCanon i475D߁ odLetterBJDM VT$m,`Oj,`OjVT$m,`Oj,`OjXXDRAFTSample 1'dVT$mVT$mH  VT$mCanon i475D߁ odLetter."d??3` L6?` '3@` #)A` '3B` #)C U 3 d2 3QQ ;  Q ; Q3_ M NM  MM<4E4 3QQ ;  Q ; Q3_ O 3<  MM<4E4 3QQ ;  Q ; Q3_ O ̙/  MM<4E43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<4 3_ M NM  MM<4 3_ M NM  MM<4D$% MP(3O&BQ4$% MP(3O&@Q4FA3O3 bPP PZaajkR R R RR RV VdtP!M&C! M NMS S43*!M&C! M NM4%  :M 3O &AQ WEEKS'43" :dd4S S4% -CKMP3O> &?Q 4PROCESS DEVELOPMENT TIME'4S S 4e'Default Process'Default Process'Default Process   ee xp 8 6NMM?6 NK]pE  MHP LaserJet 6L PCL@gXX @MSUDHP LaserJet 6L PCL&d "dXX??3` '3D` '3E` 8 Y` 8 Z` c6\]` c6\^ U/3 dBX 3QQ9Q9Q3_ M NM  MM<4E4 3QQ9Q9Q3_ O ff6  MM<4E4 3QQ9Q9Q3_4E43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<4 3_ M NM  MM<4 3_ M NM  MM<4D$% MP(3O&EQ4$% MP(3O&DQ4FA1 3O1 3 bPP PZaajkR R R RR RV VdtP!M&]! M NMS S43*!M&]! M NM4% j` M3O*&^Q WEEKS'43" :dd4S S4% OMP3O&YPYZ&Q P&PART DEVELOPMENT TIME (Planned + Risk)'4S S 4e???ee xp 8 6NMM?KZ ^]F  "F??3` '3F` '3G` L6X` L6[` L6\` ]6_*3 d 3QQ9!Q9 Q3_ M NM  MM<4E4 3QQ9"Q9 Q3_ O 3<  MM<4E4 3QQ9#Q9 Q3_ O ̙/  MM<4E43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<43_ M NM  MM<4 3_ M NM  MM<4 3_ M NM  MM<4D$% MP(3O&GQ4$% MP(3O&FQ4FA3O3 bPP PZaajkR R R RR RV VdtP!M&X! M NMS S43*!M&X! M NM4% M 3O*&_Q WEEKS'43" :dd4S S4% MZ3O&[P[\)Q V)PROCESS DEVELOPMENT TIME (Planned + Risk)'4S S 4e???ee >@<d 7 Sheet2bbggh'h      dMbP?_*+%&?'?(?)?MHP LaserJet 6L PCL@gXX @MSUDHP LaserJet 6L PCL&d "dXXcU} _} _} _}  _}  _} _} _}  _}  _} _} _} _} $ _} _} $ _O@ @ @ cxccccc c  c X]  o o ^X^ s@ /7;c\ |||}}~| ]y z2!'1.Cover Page'!E4B{ &]@@!A``aab de f!! DD !! DD 9!#D D D D    g yzzezzzzzzh  b! D  gd  D g   ~  $@ D  !c! D D h !  D Dhji  !D f D!.#'12.DATA - Supply Chain Costs'!$D$7B   3 ~  ?a '!DDD=!'D '7.DATA-Parts'!I6Bx '!DDD0 ee @B  jji   = ! 'D DDB= ! 'D DDB  = ! 'D DDB= ! 'D DDB kl J  :B ;I <K < < < < </ = ni ~ C2 DT ! '7.DATA-Parts'!C5B Default Part2 E! '7.DATA-Parts'!D5B2 F! '7.DATA-Parts'!H5B G! m?'7.DATA-Parts'!E5B @B333333?'7.DATA-Parts'!G5B4@B@7 G! !'8.DATA-Parts Eval'!H6B. H! D D D D ( H! D D D I I! 3D "'12.DATA - Supply Chain Costs'!D11B pi ' ! D D D  (! D  '  ! "2# #!  % # #! % # $! %  ql # '!  % # (! % C ' Kmmmmmmmmmr ))) >@ ?A = = = = = =  =0  =  @. )))~ A8Bp ! "'9.DATA-Processes'!$C$5BDefault Process@8!"'9.DATA-Processes'!$G$5B8!"'9.DATA-Processes'!$H$5B8!"'9.DATA-Processes'!$I$5B~  < !&'10.DATA-Process Eval'!$E$6Bz dDD  @EDD DDDD@@D BO* 9D $D DDD B!+  D D C+ -D DDDB 3%  D % H5KD % D# &  % \#,  %#,  %#,  % vvvvwx,|6 D,<l v     D  D         @  (     t@JA(global_splashWelcome to ConvaTec]&`H  t@JA(global_splashWelcome to ConvaTecMm]&`PI  t@JA(global_splashWelcome to ConvaTec]& `J  t@JA(global_splashWelcome to ConvaTecMm]& `K  t@JA(global_splashWelcome to ConvaTec]&`K  t@JA(global_splashWelcome to ConvaTecMm]&`L  t@JA(global_splashWelcome to ConvaTec]&`M  t@JA(global_splashWelcome to ConvaTecMm]&`N  t@JA(global_splashWelcome to ConvaTec]&`O  t@JA(global_splashWelcome to ConvaTec]&`DP  t@JA(global_splashWelcome to ConvaTecM ]&`,Q  t@JA(global_splashWelcome to ConvaTecM ]&`R~v  <%A@AA? (" ]&R |  B'6O,A@AA? ! ]&XS >@<K A  @  7 Sheet6bb ggD   C  dMbP?_*+%&?'?(?)?MHP LaserJet 6L PCL@gXXi08J n``:%:%fJoIKHDCompObjFp @MSUDHP LaserJet 6L PCL&d "ZXXU} 7} 7} 7}  7}  7}  7} 7} $ 7 O@ @@ O@@X@@O@ X@  +"mmm,,-...mm#m/ 2!'1.Cover Page'!E4B ') (^@@!A*$jjjji            -9 .< /4 /5 /6 / /7 /8  /=  />  /=  />  0 0 ~ 1?42 !'3.Exec Summary'!E3B LocationZ?Z?Z?Z?6[?! '4.Prod Cost Est.'!L6B6[?! '4.Prod Cost Est.'!L8B8 ! "'4.Prod Cost Est.'!$D$6B! ! D D8 ! "'4.Prod Cost Est.'!$H$6B! ! D DB !,!'12.DATA - Supply Chain Costs'!D9BB! ,!'12.DATA - Supply Chain Costs'!D7B9!8K#D D D D D D *tuuuuuuuuuuuu}{{| 4(. H    u  |  h PH (  H H t@JA(global_splashWelcome to ConvaTecsy]&`XV H t@JA(global_splashWelcome to ConvaTec& m]&`pW H t@JA(global_splashWelcome to ConvaTecsy]&`XX H t@JA(global_splashWelcome to ConvaTec& m]&`@Y H t@JA(global_splashWelcome to ConvaTecsy]&`(Z H t@JA(global_splashWelcome to ConvaTec& m]&`[ H t@JA(global_splashWelcome to ConvaTecsy]&`[  H t@JA(global_splashWelcome to ConvaTec& m]& `\  H t@JA(global_splashWelcome to ConvaTec ]& `]  H t@JA(global_splashWelcome to ConvaTec ]& `^ H t@JA(global_splashWelcome to ConvaTecs]&`_ H t@JA(global_splashWelcome to ConvaTecs]&`4`~v H <%A@AA?&]&a | H B'6O,A@AA? <!]&xa >@<d 7 Sheet12bb  &C  dMbP?_*+%&?'?(?)?MKhp psc 2200 series!@m߀dBe@RLdArial8'Beںں\\BASEMENT\hp psc 2200 series,LocalOnly,DrvConvert"UXXU} 7} 7} 7}  7}  7} $ 7} (7} $ 7&  O@  @  @   ) ) ) ) !  !  !  !  !  ! ! ! !  ! !   f       "  f  2333 2!'1.Cover Page'!E4B G4!'7.DATA-Parts'!$D$7B  8!"'9.DATA-Processes'!$B$5B M   X 4P 556  k~ @@ D  k!UD <'8.DATA-Parts Eval'!I10:K10"wD@B>!('8.DATA-Parts Eval'!I6:K9"B~ 7889 Ck!UD <'8.DATA-Parts Eval'!L10:N10"D@B>!('8.DATA-Parts Eval'!L6:N9"B~ :;;< Fk!UD <'8.DATA-Parts Eval'!O10:Q10"wD@B>!('8.DATA-Parts Eval'!O6:Q9"B~ =>>?  k~ @@ D CD l !VD ='10.DATA-Process Eval'!F7:J7" D@BA !+'10.DATA-Process Eval'!F6:J6"B~  @AAB sh ! RD 9'10.DATA-Process Eval'!K7:M7"wDBA ! +'10.DATA-Process Eval'!K6:M6"B~  CDDE wh ! RD 9'10.DATA-Process Eval'!N7:O7"wDBA ! +'10.DATA-Process Eval'!N6:O6"B~  CDDE zh ! RD 9'10.DATA-Process Eval'!P7:Q7"wDBA ! +'10.DATA-Process Eval'!P6:Q6"B~  CDDE }h ! RD 9'10.DATA-Process Eval'!R7:S7"wDBA ! +'10.DATA-Process Eval'!R6:S6"B~  CDDE h! RD 9'10.DATA-Process Eval'!T7:U7"wDBA! +'10.DATA-Process Eval'!T6:U6"B~ CDDE  h!RD 9'10.DATA-Process Eval'!V7:X7"wDBA!+'10.DATA-Process Eval'!V6:X6"B~ FGGH CCD    CCD =!'D DDB>!('8.DATA-Parts Eval'!H6:H6"B>!('8.DATA-Parts Eval'!H6:H6"7NCCD  =!'D DDBA!+'10.DATA-Process Eval'!E6:E6"BA!+'10.DATA-Process Eval'!E6:E6"tEEF  !'7.DATA-Parts'!$B:$B"B '8.DATA-Parts Eval'!$C$6:$H$8"'8.DATA-Parts Eval'!$H$6:$H$8"B'8.DATA-Parts Eval'!$H$6:$H$8"B@" B !! '7.DATA-Parts'!$B:$B"B '8.DATA-Parts Eval'!$R$5"'8.DATA-Parts Eval'!$S$6"'7.DATA-Parts'!$B:$B"B"NB'8.DATA-Parts Eval'!$S$6"'7.DATA-Parts'!$B:$B"B"N@B@"N B  ! '3.Exec Summary'!$H$11B  '10.DATA-Process Eval'!$C$6:$E$8" '10.DATA-Process Eval'!$E$6:$E$8"B '10.DATA-Process Eval'!$E$6:$E$8"B@" BDl&Vkk&J&I&  ! " # $ % " $ !K'3.Exec Summary'!$H$11B '10.DATA-Process Eval'!$Y$5"'10.DATA-Process Eval'!$Z$6"'3.Exec Summary'!$H$11B"NB'10.DATA-Process Eval'!$Z$6"'3.Exec Summary'!$H$11B"N@B@"N B !"#$%FdL<    '3.  ary  `x(    t@JA(global_splashWelcome to ConvaTecm/]&`xd  t@JA(global_splashWelcome to ConvaTecc%]&`e   t@JA(global_splashWelcome to ConvaTecc%]& `Xf   t@JA(global_splashWelcome to ConvaTecc%]& `@g   t@JA(global_splashWelcome to ConvaTecc%]& `(h   t@JA(global_splashWelcome to ConvaTec ]& `i   t@JA(global_splashWelcome to ConvaTec ]& `i|  B'6O,A@AA?!]&j ~v  <%A@AA?"]&@<d )))" 7;$ osts by Process!@m D ;$ osts by Process!@m  Sheet5bb   taf  dMbP?_*+%&?'?(?)?MHP LaserJet 6L PCL@gXX @MSUDHP LaserJet 6L PCL&d "UXXU} 7} 2} 7} } } 7}  7}  7} 7} $ 7 O  ! H* X0 X0 X@<@s3- .. &VVVV 2!'1.Cover Page'!E4B @@! A 0B 1. 1, 1: 2 1 1 1  1  1-  1  1  3~ 8 9445*677 !   D D  2 #L  %#M  % ^,s  eeB# t  % # u  %  v# w ;K % B U 77 33  333 27777777 87 7  Dp ,,(  ,  , t@JA(global_splashWelcome to ConvaTec%C]& `q  , t@JA(global_splashWelcome to ConvaTec<]& `r  , t@JA(global_splashWelcome to ConvaTec<]& `ts  , t@JA(global_splashWelcome to ConvaTec<]& `\t , t@JA(global_splashWelcome to ConvaTec<]&`Du , t@JA(global_splashWelcome to ConvaTecM ]&`,v , t@JA(global_splashWelcome to ConvaTecM ]&`w| , B'6O,A@AA? & ]&w ~v , <%A@AA? <" ]&Xx >@<d 7 Sheet11bb2   ^sv}  dMbP?_*+% &?'?(?)?MHP LaserJet 6L4C odXXLetterDINU"4`f"PXXcU} } 2} } } 5} 5} } } } $  O   B@ ! 0 00 <@#.  I  JK  IC  JK IJK " 2!'1.Cover Page'!E4B_@@!AA    6  7  D  9  E G H Q7 < 4  5  8    :  N ;   B  J    x <???????? ?  DA. PROCUREMENT  D B. PART GEOMETRY  DC. PART HANDLING~ {2| !'7.DATA-Parts'!C5B Default Part }} }; %?eeBZyyyyyyyyzf!P'7.DATA-Parts'!$D$5B'7.DATA-Parts'!$H$5BDAA!B ,e e BZZZB ,e e BZZZB ,eeBZZZ+!DZZ 8 D p#  %#   % #   % #   % #   % #   % #  %#  %#  %#  %#  %T# @K %#! % 34 1" 77 777` (VCLDH 7      Z tsJ42(  4| 4 B'6O,A@AA?5&]&{ ~v 4 <%A@AA?Q]&{ >@<Z   7 Sheet13llbb2ggD  B  dMbP?_*+%&?'?(?)?MHP LaserJet 6L PCL@g @MSUDHP LaserJet 6L PCL&d "QXU} } } } }  } }  } O  H@ X! X! /@!@# %QQQRSTTTTTUV N O2P!'1.Cover Page'!E4B b`@@!`KA$/////T W@ XA YN Y Y Y Y Y  Y  Y-  Y  Z  [~ \ ]l __! I'11.DATA - Proc Costs'!$D$8B'11.DATA - Proc Costs'!$E$8B$_` !  D D  " $ 6#  %#   % #   %  #   % B333  3? 0 " T     "roc  D$8  1.D c CJ <2(  <v  < <%A@AA?  ]& | |  < B'6O,A@AA? *! ]&  >@<d 7 Sheet14bb2  ֋%  dMbP?_*+% &?'?(?)?MHP LaserJet 6L PCL@g @MSUDHP LaserJet 6L PCL&d "McU} } } } #} } } }  } !$ ??O ? ?X ?B@ ?* ?R ?!?! ? ? ? ? ? ????#!   LMMMN  Qs  RS  QwS QzS L}O LO L@ PO! 2!'1.Cover Page'!E4B  = C G  r  t  u  v  x y { | ~     > A!7 <  F aD   E  H  I  J      L K  M  ? BT777777777777777777777777777777> @ A  x ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?(  DD. PROCESS DIFFICULTYT  D  E. EQUIPMENTp  D  F. TOOLING  D G. SETUP  D H. HANDLING  D J. INVENTORY  cKDK. QUALITY & TESTING  "~  l; %ffffff?eeB.                   !'7.DATA-Parts'!$B:$B"B e e B'4.Prod Cost Est.'!O15"'7.DATA-Parts'!$B:$B"BDBN'4.Prod Cost Est.'!$K15"'7.DATA-Parts'!$B:$B"BDBN B!'7.DATA-Parts'!$B:$B"B e e B'4.Prod Cost Est.'!$O16"'7.DATA-Parts'!$B:$B"BBN'4.Prod Cost Est.'!$K16"'7.DATA-Parts'!$B:$B"BBN B!'7.DATA-Parts'!$B:$B"B e e B'4.Prod Cost Est.'!$O16"'7.DATA-Parts'!$B:$B"BBN'4.Prod Cost Est.'!$K16"'7.DATA-Parts'!$B:$B"BBN B!'7.DATA-Parts'!$B:$B"B eeB'4.Prod Cost Est.'!$O16"'7.DATA-Parts'!$B:$B"BBN'4.Prod Cost Est.'!$K16"'7.DATA-Parts'!$B:$B"BBN B!'7.DATA-Parts'!$B:$B"B eeB'4.Prod Cost Est.'!$O16"'7.DATA-Parts'!$B:$B"BBN'4.Prod Cost Est.'!$K16"'7.DATA-Parts'!$B:$B"BBN B!'7.DATA-Parts'!$B:$B"B eeB'4.Prod Cost Est.'!$O16"'7.DATA-Parts'!$B:$B"BBN'4.Prod Cost Est.'!$K16"'7.DATA-Parts'!$B:$B"BBN B!'7.DATA-Parts'!$B:$B"B eeB'4.Prod Cost Est.'!$O16"'7.DATA-Parts'!$B:$B"BBN'4.Prod Cost Est.'!$K16"'7.DATA-Parts'!$B:$B"BBN B  " #  %#  %#  %#  %#  % #   % #  % #  % #  % #  %#  %#  %#  %#  %#  %#  %#  %#  %#  %#! %#! %#! %#! %#! %#! %#! %  " QB"77777777777777777777777777777777777777777777777777777> 7 7777777777777777777777777777777777777777777777777777> 7 7777777777777777777777777777777777777777777777777777> 7 7777777777777777777777777777777777777777777777777777> 7 7777777777777777777777777777777777777777777777777777> 7 7777777777777777777777777777777777777777777777777777>77777777777777777777777777777777777777777777777777777>77777777777777777777777777777777777777777777777777777>77777777777777777777777777777777777777777777777777777>&@&~6(^0 7 7 7 7J2(  |  B'6O,A@AA?=!]&l ~v  <%A@AA?]&ȃ >@<Z :   7 Sheet4bb2ggD   V  dMbP?_*+%&?'?(?)?MHP LaserJet 6L PCL@g @MSUDHP LaserJet 6L PCL&d "MXU} } } }  } } } "  ##f@ #[ #*[#Z#Z# # #OZ #/ 'W ?kH@@@Aghiijjjkjjjjjjjjjjjjjjjjjljjm"LW:;<=>====ccccccccccccdeeeeeeeeeeef" X 829!cK'1.Cover Page'!E4B  " "X T UUU  V   UUU V  UUU VUUX T# UUU V% UUU V&  UUW" 3@ 4A 4; 4 4 5  5! 5"  5     !  "   5  5! 5" 5   ! "   7 5 5$ 5   $  5  5 !5$ "6~ 8 ! "'9.DATA-Processes'!$C$5BDefault Process- D D DD' DDD") $$$!BL  "6D  @DD@DB  L  6D   @D D @D BL  6D  @DD@DBL 6D  @DD@DB% DDd% DDd!%"  DD dLX " dP|P0     JT2(  T| T B'6O,A@AA?m!]&\ ~v T <%A@AA?`]& >@ :"  7 Sheet1bb2   f  dMbP?_*+%&?'?(?)?MHP LaserJet 6L PCL@gX @MSUDHP LaserJet 6L PCL&d "dXU} } } } } - <@*@ @ X@ @@ @O@ @  @ @  f@  7 ? EEFH I2N!'1.Cover Page'!E4BJ ~ G? 4 ! '3.Exec Summary'!E3B Location D  ~!'7.DATA-Parts'!$B:$B"B Xe '7.DATA-Parts'!$D$5"'7.DATA-Parts'!$B:$B"bbN@B B B . 0 !KD Location ~ B3 CD !'7.DATA-Parts'!$C5B Default Part~   ~ X0_?Tp0    '7. s'!JP2(  Pv P <%A@AA?]&L | P B'6O,A@AA?J&]& >@   7 Sheet16bb2   Y  dMbP?_*+%&?'?(?)?MKhp psc 2200 series!@m߀dXBe@RLdArial8'Beںں\\BASEMENT\hp psc 2200 series,LocalOnly,DrvConvert"dXXU} } } } } -<@ @ ! @ @@@@@ @    @ @  f@ X7 ? EEKL M2N!'1.Cover Page'!E4BJ GU` !1'5.Comp Cost Analysis'!B7:C7"Bf LocationO P4:V?!$'5.Comp Cost Analysis'!D7BQ R5:W?!$'5.Comp Cost Analysis'!E7BQ R6:W?! $'5.Comp Cost Analysis'!F7BQ R0:W?!$'5.Comp Cost Analysis'!g7BQ R 6X?!  '4.Prod Cost Est.'!L6B S T 6 Y?!  '4.Prod Cost Est.'!L8B   # ! %   @ A t !KD Location ~ B8 C !"'9.DATA-Processes'!$C$5BDefault Processj ! T'4.Prod Cost Est.'!$E$17B !D'4.Prod Cost Est.'!$K$17B'4.Prod Cost Est.'!$J$17BDD'4.Prod Cost Est.'!$G$17B'4.Prod Cost Est.'!$D$17B@@D'4.Prod Cost Est.'!$H$17B'4.Prod Cost Est.'!$I$17B'4.Prod Cost Est.'!$E$17B@B  ~"X|````\\IT<   '4.  Es B L(  L  L t@JA(global_splashWelcome to ConvaTec]& `<  L t@JA(global_splashWelcome to ConvaTec  ]& `  L t@JA(global_splashWelcome to ConvaTec]& `А  L t@JA(global_splashWelcome to ConvaTec  ]& ` L t@JA(global_splashWelcome to ConvaTec]&` L t@JA(global_splashWelcome to ConvaTec]&` L t@JA(global_splashWelcome to ConvaTec  ]&`p L t@JA(global_splashWelcome to ConvaTec]&`X L t@JA(global_splashWelcome to ConvaTec  ]&`@| L B'6O,A@AA?M!]&( ~v L <%A@AA?="]& >@   7 Sheet15bb2  ^      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstvwxyz{|}~(z  dMbP?_*+%&?'?(?)?MHP LaserJet 6L PCL@gXX @MSUDHP LaserJet 6L PCL&d "TXXU} } %} U^<@<@ ( X( (!!"     @@@@ @@@@ ! &' 2_  `a YZ [O\ M N             # $ Y  Z % [  l    ' ( &    6  7  D ) 9  E * G + H W Q , ]-^Dl "!+"+#+$+%+&+'+()*++,+-+.+/+0+1+2+3@4@5@6@7@8@9@:@;@<@=@>@?@ M N ! !R "S "c #T #b $U $V %U %V &d &e 'W 'X (Y (_ )Z )` *[ *a +f +j ,g ,m -h -n .i .o /p /q 0r 0s 1t 1u 2 2 3 3 4= 4 5C 5 6G 6 7r 7 8t 8 9u 9 :v : ;x ; <y <Z ={ = >| > ?~ ?Dl@@A@B@C@D@E@ F/7G@H@I@J@K@L@M@N@O@P@Q@R@S@T@U@V@W@X@Y@Z@[@\@]@ @ @ A Ac B B C Cb D> D EA EF@ D " (  X  3  symm ]&`xp  6A@AA?f=a]& |  B'6O,A@AA?!]& ~v  <%A@AA?C ]&d >@*7 Sheet7bb  <]s   dMbP?_*+%&?'?(?MKhp psc 2200 series!@m߀dBe@RLdArial8'Beںں\\BASEMENT\hp psc 2200 series,LocalOnly,DrvConvert"dXX??U} m&H} $EP} $ H} H} $ H<@@@ LM     C    /                        |  |       4     IIIIIIIII   R S  T  v  w  x  Q P O  ,   y z  {    |  }  ~               Y' Y(  K)  J*  J+" JJJJJJJJJJJJJJ # $,NNONNNNNNNNNNNNNNNN Y  Z %   [    l        ' (   &        6  \  7  ]  D ) ^  9    E *  m G +  n H W  o Q ,   R   S c   T b   U V   U V   d e   W X   Y _   Z `  D l8L&L88888888888888*88888888 ! " N # $  % h& :' ( ) v* v+ v, v- v. H/ v0H1v2v3H4H5@6H78H9v:v; [ a   !f !j ! ! "g "m " " #h #n # # $i $o $ $ %p %q % % &r &s & & 't 'u ' ' ( ( ( ( ) ) *= * +C + ,G , -r - .t . /u / 0v 0 1x 1 2y 2Z 3{ 3 4| 4 5~ 5 6 6 7 7c7S 8 8 9 9b :> : ;A ;<F888888888&PH$0( x  $>@7 Sheet9bb ThisWorkbook"&__SRP_2__SRP_3RSheet3  !"#$&'()*+,-./012346789:;<=>?@ABCDEFGHIJKMNOQRSTUVWXYZ[\]^_abcdefghijklmnoqrstuvwxyz{|}~Protect worksheet #4dfm1209:<4.Prod Cost Est.$6B@8A> @B@Bo ' F@P *(HP J!L."p "%6P HelpSheet %6B@N$RB@H "%6P14.HELP %6B@Np$RB@H`` "%6P13.DATA-Plants %6B@N$RB@H "%6P12.DATA - Supply Chain Costs %6B@N$RB@H "%6P11.DATA - Proc Costs %6B@N$RB@H "%6P10.DATA-Process Eval %6B@N$RB@H "%6P9.DATA-Processes %6B@N$RB@H "%6P8.DATA-Parts Eval %6B@N$RB@H "%6P 7.DATA-Parts %6B@N$RB@H "%6P6.DFM Eval Summary %6B@N$RB@H "%6P5.Comp Cost Analysis %6B@N$RB@H "%6P4.Prod Cost Est. %6B@N$RB@H "%6P3.Exec Summary %6B@N$RB@H "%6P2.Action Items %6B@N$RB@H "%6P 1.Cover Page %6B@N$RB@HProtect worksheet #4dfm1209:<4.Prod Cost Est. %6B@8 V "(T *(XSheet1 "%6B@. *(XSheet2 "%6B@. *(XSheet3 "%6B@. *(X "B@Z ^ *%\B@B *(H @B@` bB@Bd @B@`kpoh: creates a new workbook with wsCount (1 to 255) worksheets].d f f Gzj *!j'h f *(j J!L.d h *(ji( *(H "B@Z 1.Cover Page "%6B@H b!p!dE4+n b!r!dE5+n b!t!dE6+n vE7+n3.Exec Summary "%6B@H b!x!dE3+n 1.Cover Page "%6B@H *(Hoh]D]hDFM-Project Explorer *%,B@. *!,!L.|DFM-Project Explorer |(  |( |! l7L. "Select a sheet from the list belowC@ 1.Cover PageC@2.Action ItemsC@3.Exec SummaryC@4.Prod Cost Est.C@5.Comp Cost AnalysisC@6.DFM Eval SummaryC@ 7.DATA-PartsC@8.DATA-Parts EvalC@9.DATA-ProcessesC@10.DATA-Process EvalC@11.DATA - Proc CostsC@12.DATA - Supply Chain CostsC@13.DATA-PlantsC@14.HELPC@999View9 99 9$Select a sheet from the left to view9Module1.DisplayMessage9qXqP |(o80!Attribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2Option /licit Dim ms@g As Sn"g Ans dirflaBooleanfil epathwbӁ PY] Sub _BeforeCly(Cancel!2) OXrror ResuNex]Appba4.CommandBars("DFM-ProjectB:r")@.DeletZ Call Module1.Menu_End&A*Open($5 C Wd{P#PY# Js'iF-sF/x-sF/Y# Js'iME, [LSS0$<~<6"L "<0<4<8<<<N0{00020819-0000-0000-C000-000000000046}xbh< @"#Dx@ % &`d i(  4 `$kh D` `TIIiF WS,d(` X bifC: %)  %`h lh` \ l z``11y |% %%b@4@b8@b (@@h( h@(%%6>@@x @h @d @(T @@D @X4 @$ h(PTlTD*\R1*#2ad$*\Rffff*0U44bcb529*\R1*#dc$*\Rffff*0V44bcb52c$*\Rffff*0W44bcb52cH  ( "  08(@  hx " 6<   "      00@p. 4 B h : : 60h 8 2 8 X :p 6 4P 4h 2 :( h x     ( @ P `p x B   @  0 @P" X ` p "  8  X h " p  x   (       @ ,H x       8 X x  &       ( 8 @ H ,P       x]]@]]h](@DFM-Project Explorer *%,B@. 0B2o'@tAwsheet #4 MSA!4.d Cos!st.C  Passd:="dfm1209", UserInterFOnly:=Cm?E-A+@2 Form roValues.Show 2Pub@J6 cel(ac'‚@~GZ y=  If  The@ `S enUpdcng[DSE@={s.Add ,ÀOLHelpO@JCopy Af@CP:=wb1@^Cells(1, 1).S`:c`A 14.HELP  13.DATA-PlantsK t`12 -3Zy ChainF 51e uOc Q,ab,0 Ancess Eval###9J Ve?"?"e 8 art!!7 6. *`D\ry? ? ! 5pB Analysi_,_,B,zizY3.Exec?!BGZO,Z2.APItem?GG 21ver Page?tb?Ml ?f2f'pDgjfffVb\eLinks\xlNe #wDisyA\le4vcG["1evc2e3w !valogs(xlDiSaveAshBw/qi"q{s.Hid|itD@p'|2 g~If-VFDun-New(wsCountѕager)  's a new q wi(1 to 255)ҏsӠOrigiD!rLon1X PNoth0< 1 Or >1‡pit 5s= J>InOJ@ T? E?=? 1 Û inB!aentry10,H5Ia Range("E4")`_)a.TBoxЄduct/"5alB-IDE6DetailsE7N3A d"EC ae_A;{!0*T@ctbr ;7cbc'List`{boPooէ;foek11 = ~_3!Hz.{a"/ .mmandBar.Position = msoTop With cbrCoControls  Se tHcHList(Box_L.Add(Type:=Dropdpown)gB>  @Item "Select a shewfrom the ls below" .1.Cover Page 2.Ac+s 3.E@xec Suzry 4.Prod Cost Est. 55mpAnalysi ,6.DFM Eval.7.DAT@A-Part8  ;9rocesse 1011 - @6c/L2Supply Chai n 3 -Plan 014.HEL"P-Wid= 200w.AD@15 .APInde1.CapD"Viez.StyleÃ@boLa@ BeginGroupTrue Tooltip0Text לeft to v"$ OnD= "Module[isplayMk End AK VisibB<4 Sub IrU 0  a P  1Y #Ha `` IWW0   X<:T%c4%d:h%x! x dd)xd $ XX$ xd0   0   0 (  0 h  HH0rU T(`d#$A`h (`U#0`Y&=$`]$A`an'dW#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0DxAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2'dA#xSheet10-%UserFormIntroValues(*0W__SRP_65__SRP_7LME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0DxAttribute VB_Name = "Sheet10" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2rU @//a/ )Qy< PGK Sub CommandButton2_Click()Unload MyEnd4'TextBox'dID.En6IDetPathExists9Len(VBA.Dir(u:=F, ƙ s:=vb@ ectory)@3'GfOeger  '= FreeFilvpp?Yalogs(xlDiAOpen).Show@'BNDlg.An@ Bina$ryAa#f@['Put @, , E1.AClAu@s'MsgO "Abox tS successfully sain " &N"Fl' Set CancelError is C  On GoT*oHlH s ilterpecify default fDis_y the "&:db)  'of sel@6e2!TonC11.wab\=AYars("Workshe menu bar"). klgiAdva%d FuncAnsJSuDy Cha`/CoT\+  6 Analys9by Plant2 x.Hid)Call This#book.NHewT@Bab z @nt}aCBdA:,' pr`P@4{:J `A'%`+t9 wF0#41A S2/4. `dWEst.CPassd:="dfm12`09", wrF@Only:=-onOKǓE$'Do Wh ?%nq= 1Q("P En` a uct vbOK .@qFocu`g'H%LoopŠ4ID>d*#!'ID Hc!ve<~(Q019у9ro2art A9"DCЈP!;Ngh: x Q Evc8t&?P+IEditDataH?Qh4|RgoP" <0{4444A90B-0956-44C1-B1FE-69CFA2129155}{D6752D26-7564-44AF-9370-5FBF672F12DA}b8 @Pro-DFM%% `0xk ` ((  ` 3 `x|+KxpH%x %b(Hb4@HKeyC8@@ActionYWr TQuerlo@x =pHHxP(l D$*\Rffff*0W44bcb52c*\R0*#1e*\R0*#1d <@DHLPTX\`O  "(  0@ " H $P $x T  ( .@ p   F   0 8 H ` " $ $ l pp     $8 @6` "  & <  8 H FX :    0`@hbfpnjH "  ]Pro-DFM]]H A@ro8TextBoxProdID.Enabled = FalseTextBoxProdDet.Enabled = Falseeet NPathExists = Len(VBA.Dir(PathName:=Myoutputlocation, Attributes:=vbDirectory))Dim fn As Integer fn = FreeFile  *%\B@B'Open CommDlg.Filename For Binary As #fnPut #fn, , Text1.Text Close #fnText1.Text = ""?MsgBox "Textbox text successfully saved in " & CommDlg.FilenameEnd Sub Set CancelError is True Set flags Set filters Specify default filter Display the Open dialog box Display name of selected fileMsgBox CommonDialog1.Filename'Supply Chain CostsAdvanced FunctionsPro-DFMWorksheet menu bar$,%%%(Cost Analysis by PlantAdvanced FunctionsPro-DFMWorksheet menu bar$,%%%( B@` Bz|User pressed the Cancel button|Protect worksheet #4dfm1209:<4.Prod Cost Est.$6B@8o`' Do While Me.TextBoxProdName = ""5msg = MsgBox("Please Enter a Product Name", vbOKOnly)TextBoxProdName.SetFocusExit SubLoop?Do While Me.TextBoxProdID = "" And TextBoxProdID.Enabled = True3msg = MsgBox("Please Enter a Product ID", vbOKOnly)TextBoxProdID.SetFocusExit SubLoop Bz  BD Delete Parts Part ActionsPro-DFMWorksheet menu bar$,%%%(DFM Part Evaluation Part ActionsPro-DFMWorksheet menu bar$,%%%(Edit Part Data Part ActionsPro-DFMWorksheet menu bar$,%%%(Delete ProcessProcess ActionsPro-DFMWorksheet menu bar$,%%%(DFM Process EvaluationProcess ActionsPro-DFMWorksheet menu bar$,%%%(Edit Process DataProcess ActionsPro-DFMWorksheet menu bar$,%%%(o@'o( Attribute VB_Name = "UserFormIntroValues" Bas0{4A90B-0956-44C1-B1FE-69CFA2129155}{D6752D26-7564JAF-9370-5FBF672F12DA} dGlobal!SpacoFalse CreatablPre declaIdTru BExpose0TemplateDerivCustomizDConst Myoutputlocation As SngPro-DFM~ Dim0 msg fla Booleahn Sheet4 PSheet5`Sheet6 p~__SRP_8'd#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0DxAttribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2'd!8#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0DxAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2<jxd30#< $DYIA F"ILBMѳx|x"ILBMѳx| $DYIAME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` % %`h8@HH0D$*\Rffff*0X44bcb52c4xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU Iq!4`rU @n__SRP_9 'BSheet7Sheet11Module1K('dO#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0DxAttribute VB_Name = "She@et7" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2'd6#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0DxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2\R3*#4f*\R3*#50*\R3*#30*\R0*#12*\R0*#14*\R1*#f1  (@X`hpx  0"  \+  ,&tL ( 8 " 8P Xp6\x6o  Da  h Fp "  6(6`  D+(o, )d$xME<~< 0> LLLLLLL(… @0@Pro-DFM` %H\@l @pt @ @ @@0 @`k`t >``k!`x `v`t 28` =`` `!k--M`x ` ` ` ` `  P`$kvvz`x ` ` @`  `  ` s if` ired`` 06/1` ` our ` Ple `   Z%  % $`  (P`  ,`   2 `  4 `  8P `  < ` ! @ ` * D`  3 H` CC<`J`T V`  Z `  \@ `  ` `  d `  f `  h@ `  j ` il`n t ` IIil x ` X ]]il  ` W``````````````l`` ```` ` e` ```` `"`$`&`(`*``,`.`0`2```4`>`l`H`J`L`N`Pon7`R`Ts Ac`Veet `X%`ZDele`\`remo` cess`f`h****`j.HEL`l****`nDi`pect`rnewS`ts("W`v ' .`xontr`zWi`|O `~msoC`:=1)`ons `rols`.OnA`En`wSub` `  P`  `  i. .iActi`En ` (++&iHihed Fi nu b`.+R `  ]]Qite Di i@Adishee`%`Cost``(+!` !il  in@ed Fi`nu biil`` Cha` P"` (")HND O% #` #VV+ $` $  "%` %  $P&` &$  &'` '__' i(En *((` (ZZ i,heet`lrols 0)` h) i2e:=m`lore: 6*` *h  : +` +k  <,` ,//o  >x%PH@( @ P @T@d@@| @h @ @ PPP@  h @P  (x 8 P@ (Hp @ P H*,sht @0p :@`l oces@\ @xX @T t wo@P dfm1@N Prod@L 0ect wo@@< dfm1@8 DATA@4 8 tct wo@X$ dfm1@p .DAT@ B@8@ @ `Prsheet (@! h Z@ d @ T @ D @ 4 @!$ @(! @p! @X! @ @! @! @! @ @ x@#"#"#p"0#,@"t @"d @"` @#\ @X#L @H @$D `$#@@ @p#0 @# @# @# @# @($ @ @@$ `X$$ @ @h$ `$@$@$ `$h$@$ `$$@ `$$ 8Hx%X&%p&%&,@%t @%d @%` @&\ @(&L @H @@&8 @&( @& @& `'p&@& @& @ @ @ ' `8'& @H' ``' '@p' `'H'@' `'p'%@' `''+@' `('2@( `(('9@8( `P((Q@`( `x(8(X@ ``(`p-- ^D*\R1*#21a$*\Rffff*0V44bcb52c*\R1*#2ac*\R1*#e8*\R1*#d7*\R3*#8c*\R3*#4d*\R3*#4e*,  ."8 @,LH xJKD3  ,L( X.:` ,L 2: ,L  P4:X ,L 2:(  8 @ ,LH  x 0: &     "  B X Jb`  .: ,   Jb(  x 0: (    Jb  8 6:@ . x   Jb   .: * @ p Lx  Nb  2:(0 `Nb 4:, 0 `hNbp 8:8 8 @NbH 0:*  T `l  V 8`  n 8 RP 4  THPbP ::2   (Pb0 8:, &  Pb( x4:* " Z xr  N( 0x  t P Th @  "   0:P  "  "  "  6 H8h :"   6@ x8 :0@" H P6p 8 : `p" x 6 8 0:P "  6  8( ` :   "  6! 8!8X! !:!!"" " "60" h"8" ":" #0#" 8# @# P#`#"h######### "$ ($H$2`$ $2$ $2% 8%@%$H%p%%%%%%%% "% "&0&2H& &2& &2&  '28' p'2' '2' (2((  `("p( (" ( ((" (((" ( (6)P)`)" h) p)6)))" ) )*" *&*@*" H* P*`*"  h*p* x******++++ (+@+(H+p+ +++ + "  + +"++,B0,x,, ,,,,,, ,, -- 0- :H-- -- -- .. 0.H. `.x. .. .. ./  /8/ P/h/ "///P0h0101112n2 03 P3 `3p3 "  x3 3$33333444 404 H4`4 x44 44 44 5 5 85P5 h55 55 55 56 (6@6 X6p6 66 66 67 707 H7`7 x77 "7 779 9@:X:x;;<<=> ?8? X@ x@  @@" @ @ @ "@ @@ N(A "xA VA &A V B 6xBBBBBBBBBBBCCCC8CPCpCCCCCCCDDD  D 8D PD `DpD DD DD DD E E8E PEhE EE EEE EF (F@F XFpF F F FF  F"G 0G@G.XG G GG G"G HH.0H `H HH.H H &H * I &PI LxI I I $J  0J"@J hJxJ.JJLJ0K,HKxK,KK  KKL(LHLhLLL L L *LM(M 8M`HMhMbNlxNN NNOO (O8O@OHOPO ZXO 0O ZO "HPpP"xPPP PPPPQQQ & Q NHQ &Q Q Q RR (R &8R `R RR R &R R $S S $T T $U U BXV V $V VVWW 8W HWhWWWW 6WWX X @X PX hXxXXXXXXX  X X,Y0YHYhY $Y :Y VY &@Z VhZZ ,ZZ[0[8[@[X[h[x[[[[ [ [[[\\8\ H\,`\$\\ \L\ 0] 8] @] X] h],] $]] ]^^^ ^ V_ (X_ V_ _ _`` ` @`H```p````` ` ``` a(a @a Pa paa aaaaa bb b(b@b `bpb b b bb bb c c(c 0c,Hc xc,c c,c d(dz@d d d0d eR0e eHe ef  f,@f pf,f f,f g,g Hg,`g g <g 0g " h Hh (Xh h hhhhhi i(i@iPiXi`i hipixiiiPi  j V8j j Zj ,k Z8k "kk"k lXl plXl lXl PmFhm mFm nF(n pnFn nFn V0o *o Vo p 0p"Hp pp,p p,p q0q Hq0`q :qqHq 0r @r>Xr rr rr " r r s "s8s B@s Rs ,s (t .8t$htttttttttuuu (u8uPu `upu  u uu u u vv (v  8v Xvhv v vvvvvw w8w Xwhw w  wwwwwx x8x Xxhx x  xxxxxy y8y Xyhy y  yyyyyz z8z Xzhz z  zzzzz{ {8{ X{h{ { {{{{{| |8| X|h| | |||||} }8} X}h} } } }} } }}~~~(~8~H~P~X~ `~ p~ ~~  ~ ~~ ~  0 H X x  (@ X x Ȁ(@ X x  ȁ(@ X x Ȃ(@ X x ȃ(@ X x  Ȅ(@ X x ȅ(@ X x "؆   x Z V *x V > @HPX`hpx  ȉЉ  ؉ 0 PXp  &   8 Ph   ,ȋ  ,  Hh xf ( 0H `x  ؍   8P pȎ Ў   0@ ` "p ȏ؏ fnpjpP ȑБ    ,8h,,В,H  `p Г , (P .x$Д20  h px , $ .ؕ$8Pp xȖ &ؖ  8 H `p  "8Ph  ؘ 0@PXx  P ( PX`hpx   @  ` p   ؛  0 P `Ȝ؜  0@ `p  ȝ    8H hx   08@P p  ȟ؟  0 HX x  Р  2( `x  ء 2 X2p 2  06H   ȣ   0@ .` .ؤ. .8 hR $إ  $ @ P &h  P , R8" &Ч  $\8 \ \( \ \ x\ \ hH ȫH (H@ H H HH` H H hH PȮ & N@&ȯ 0 80P  ذ ( @ P P` ( Pر( H`hpxȲвز 08@ H ` pȳ س 2 Xpx  ȴ 8@H PXp &  ص   ( 8 P ` x   ȶ ض 0@HP X *p  $з$$ $H$p$ Fȸ   $0 "X.   к   8 Xh" p x "   "  Ȼ л"  .0 `"  hpx м  (HPhp x Ƚ 8 @P h  B  Ⱦоؾ  " 0@X`  hx  ȿп ؿ0 @PX p   $ 08  @Php  x      0HP  Xh   ( HX "` B  "0@PX p $ "  &0HX" `h p @0p @(h @ `x@Xp $ ,H`x , 8P h,( @` 6$  B (08" @HP " X`h"  px    8Ph  (@Xp  0H `x     8Ph (@Xp 0 H ` 6 "   0Php 0@ *H"x08P`h p   , 08@HX`x  " (@H`px   0 "  8@ $H p (@PX `p *$(08@PXpx   $ 8@Xhpx   *$Hp  08 @P`  "h    @H`px  0 8P`h p  ""* 0 H X" ` hx" "  :(0  @Ph 0$Px""@ Xx$$$,0`x 6      ]Pro-DFM]]]](]] ]]H]]]p]@]]h]]*Deny the access if the software is expired]( 06/10/2006'' Z  PPSorry. Your license has expired. Please contact info@cloversoft.net for renewal.A@B@ B@B "kh  Z  6 You have  Z L Days left for your license. Please contact info@cloversoft.net for renewal.A@ElseMsgBox ("This is shown when it is more than 10 days before the program expires. (Dr.Das, we my not need this one. Just for confirming it's go thru the check correctly.)")ko@]]]1Just added by atipol for checking expiration dateAEnd of just added' worksheet menu bar *%,!! worksheet menu bar *%,%! '|k x   lWorksheet menu bar$,!%L. @ The "&" denotes a shortcut key assignment (Alt+M in this case). 9q8AAk ofor creating main menu]] ' worksheet menu bar *%,!! worksheet menu bar *%,%! 'kX   Worksheet menCompObj^pi20Q]W n``<%<%fzoVXsu bar$,%B@.ko(for creating submenus in the first level8]x Worksheet menu bar$,%. Create/Open a Pro-DFM File l5%L( openexfileCreate/Open a Pro-DFM File7(q] Worksheet menu bar$,%.  Part Actions l5%L(qh] Worksheet menu bar$,%. Process Actions l5%L(q] Worksheet menu bar$,%. Advanced Functions l5%L(qh] Worksheet menu bar$,%. Definitions Help l5%L(helperDefinitions Help7(q] Worksheet menu bar$,%.  About Pro-DFM l5%L(about About Pro-DFM7(q ofor creating menu items<*******************PARTS************************************]H Part Actions Worksheet menu bar$,%%.  Add New Part l5%L( Code_Estimate Add New Part7(q]` Part Actions Worksheet menu bar$,%%. Edit Part Data l5%L(EditpartEdit Part Data7(q ]x Part Actions Worksheet menu bar$,%%. DFM Part Evaluation l5%L(evalpartDFM Part Evaluation7(qP] Part Actions Worksheet menu bar$,%%.   Delete Parts l5%L( removeparts Delete Parts7(qE***************************PROCESS***********************************]Process Actions Worksheet menu bar$,%%.  Add New Process l5%L(processdetailsAdd New Process7(qh]Process Actions Worksheet menu bar$,%%. Edit Process Data l5%L(EditprocEdit Process Data7(q]Process Actions Worksheet menu bar$,%%. DFM Process Evaluation l5%L(evaluateprocessDFM Process Evaluation7(q]Process Actions Worksheet menu bar$,%%. Delete Process l5%L( removeprocDelete Process7(qN************************************15.HELP***********************************Dim newSubItem3 As Object^ Set newSubItem3 = CommandBars("Worksheet menu bar") ' .Controls(mainmenu).Controls("About")With newSubItem3O .Controls.Add(Type:=msoControlButton, Before:=1).Caption = "Definitions Help"2 .Controls("Definitions Help").OnAction = "helper"End WithDim newSubItem3a As Object_ Set newSubItem3a = CommandBars("Worksheet menu bar") ' .Controls(mainmenu).Controls("About")With newSubItem3aL .Controls.Add(Type:=msoControlButton, Before:=1).Caption = "About Pro-DFM". .Controls("About Pro-DFM").OnAction = "about"End WithN***********************************REPORTS************************************]Advanced Functions Worksheet menu bar$,%%. Update DFM Eval Summary l5%L(evalsumUpdate DFM Eval Summary7(q ] Advanced Functions Worksheet menu bar$,%%. Cost Analysis by Plant l5%L(ccaCost Analysis by Plant7(Cost Analysis by Plant7(q ]8Advanced Functions Worksheet menu bar$,%%. Supply Chain Costs l5%L(supchSupply Chain Costs7(Supply Chain Costs7(qS********************************SAVE AND OTHERS ***********************************Dim newSubItem4 As ObjectdSet newSubItem4 = CommandBars("Worksheet menu bar") ' .Controls(mainmenu).Controls("Save Workbook") With newSubItem4H .Controls.Add(Type:=msoControlButton, Before:=1).Caption = "Save As"* .Controls("Save As").OnAction = "Save"End WithDim newSubItem5 As Objectf Set newSubItem5 = CommandBars("Worksheet menu bar") ' .Controls(mainmenu).Controls("Save Workbook") With newSubItem5N .Controls.Add(Type:=msoControlButton, Before:=1).Caption = "Email Report"9 .Controls("Email Report").OnAction = "Mail_workbook"End WithoP]delete if it existsFlexible Manufacturing " *!,%L. (oX &B@Bo8 *B@BoPProtect worksheet #4dfm1209:<4.Prod Cost Est.$6B@8Protect worksheet #8dfm1209:<8.DATA-Parts Eval$6B@8Proetct worksheet #10dfm1209:<10.DATA-Process Eval$6B@8 0 .B@BoProtect worksheet #4dfm1209:<4.Prod Cost Est.$6B@8Protect worksheet #8dfm1209:<8.DATA-Parts Eval$6B@8Proetct worksheet #10dfm1209:<10.DATA-Process Eval$6B@8 0 .B@BoProtect worksheet #4dfm1209:<4.Prod Cost Est.$6B@8Protect worksheet #8dfm1209:<8.DATA-Parts Eval$6B@8Proetct worksheet #10dfm1209:<10.DATA-Process Eval$6B@8 0 6B@BoProtect worksheet #4dfm1209:<4.Prod Cost Est.$6B@8Protect worksheet #8dfm1209:<8.DATA-Parts Eval$6B@8Proetct worksheet #10dfm1209:<10.DATA-Process Eval$6B@8 :B@BoXPProtect worksheet #4dfm1209:<4.Prod Cost Est.$6B@8Protect worksheet #8dfm1209:<8.DATA-Parts Eval$6B@8Proetct worksheet #10dfm1209:<10.DATA-Process Eval$6B@8 >B@Bo(Protect worksheet #4dfm1209:<4.Prod Cost Est.$6B@8Protect worksheet #8dfm1209:<8.DATA-Parts Eval$6B@8Proetct worksheet #10dfm1209:<10.DATA-Process Eval$6B@8 0 BB@BoProtect worksheet #4dfm1209:<4.Prod Cost Est.$6B@8Protect worksheet #8dfm1209:<8.DATA-Parts Eval$6B@8Proetct worksheet #10dfm1209:<10.DATA-Process Eval$6B@8 0 FB@Bo *(H]DP'J8.DATA-Parts Eval$6B@H$RB@H_P L%NB@H L!Px k J 'J6.DFM Eval Summary$6B@H8.DATA-Parts Eval update$RB@H J L%N!P$R L(P L%NB@H J L%N!P$R L(P L%NB@H J L%N!P$R L(P]h'T10.DATA-Process Eval$6B@H$RB@H_p L%NB@H L!Px@k8 T 'T 6.DFM Eval Summary$6B@H10.DATA-Process Eval update $RB@H T L%N!P$R L(P L%NB@H T L%N!P$R L(P L%NB@H T L%N!P$R L(P L%NB@H T L%N!P$R L(P L%NB@H T L%N!P$R L(P L%NB@H T L%N!P$R L(P L%NB@H T L%N!P$R L(P *(H6.DFM Eval Summary$6B@Zo` XB@Bo@3.Exec Summary$6B@Zo Protect worksheet #4dfm1209:<4.Prod Cost Est.$6B@8 0 ^B@Bo@ Protect worksheet #4dfm1209:<4.Prod Cost Est.$6B@8 0 bB@Bo  4.Prod Cost Est.$6B@Zo 14.Process Guidelines$6B@Zo @B@Bo@ ] updating partdata sheet 7.DATA-Parts$6B@H$RB@H_( L%NB@H L!P lxk p!rB@.$RB@H'n L%N!P PART COUNTb L%NB@H n L(P n 'nPoH *(H8.DATA-Parts Eval$6B@H$RB@H L%N!P/There are no parts, please enter the first part v$'|kx_p L%NB@H L!P lx@k80 L%NB@H 6!x!d L(P L%NB@H 6!z!d L(P L%NB@H3ActiveCell.Value = UserFormEvalPart.TextBoxQCR.Text 6!|!d L(P L%NB@H 6!~!d L(P L%NB@H 6!!d L(P L%NB@H 6!!d L(P L%NB@H 6!!d L(P L%NB@H 6!!d L(P L%NB@H 6!!d L(P L%NB@H 6!!d L(P L%NB@H 6!!d L(P L%NB@H 6!!d L(P L%NB@H 6!!d L(PJust added by Atipol 7/22/05 L%NB@H='7.DATA-Parts'!$D$ l X *'7.DATA-Parts'!$H$ l X *(1-VALUE(MID($F$ l X ,2,3))) L( L%NB@H=0.5*SUMPRODUCT($I$5:$K$5,$I l X :$K l X )*('7.DATA-Parts'!$H$ l X )*('7.DATA-Parts'!$D$ l X )/90 L( L%NB@H=0.5*SUMPRODUCT($L$5:$N$5,$L l X :$N l X )*('7.DATA-Parts'!$H$ l X )*('7.DATA-Parts'!$D$ l X )/90 L( L%NB@H=0.5*SUMPRODUCT($O$5:$Q$5,$O l X :$Q l X )*('7.DATA-Parts'!$H$ l X )*('7.DATA-Parts'!$D$ l X )/90 L( L%NB@H=$R$ l X *'7.DATA-Parts'!$H$ l X *'7.DATA-Parts'!$D$ l X L( L%NB@Hend *(Ho  *(H10.DATA-Process Eval$6B@H$RB@H_(  L%NB@H L!P lx k  L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(P L%NB@H F!!d L(PJust added by Atipol 7/22/05 L%NB@H=0.7*SUMPRODUCT($F$5:$J$5,$F$ l X :$J$ l X J)*OFFSET(INDIRECT("'4.Prod Cost Est.'!$O$15"),MAX('7.DATA-Parts'!$B:$B)+$B l X R,0)/(190*OFFSET(INDIRECT("'4.Prod Cost Est.'!$K$15"),MAX('7.DATA-Parts'!$B:$B)+$B$ l X ,0)) L( L%NB@H=0.7*SUMPRODUCT($K$5:$M$5,$K$ l X :$M$ l X J)*OFFSET(INDIRECT("'4.Prod Cost Est.'!$O$15"),MAX('7.DATA-Parts'!$B:$B)+$B l X R,0)/(190*OFFSET(INDIRECT("'4.Prod Cost Est.'!$K$15"),MAX('7.DATA-Parts'!$B:$B)+$B$ l X ,0)) L( L%NB@H=0.7*SUMPRODUCT($N$5:$O$5,$N$ l X :$O$ l X J)*OFFSET(INDIRECT("'4.Prod Cost Est.'!$O$15"),MAX('7.DATA-Parts'!$B:$B)+$B l X R,0)/(190*OFFSET(INDIRECT("'4.Prod Cost Est.'!$K$15"),MAX('7.DATA-Parts'!$B:$B)+$B$ l X ,0)) L( L%NB@H=0.7*SUMPRODUCT($P$5:$Q$5,$P$ l X :$Q$ l X J)*OFFSET(INDIRECT("'4.Prod Cost Est.'!$O$15"),MAX('7.DATA-Parts'!$B:$B)+$B l X R,0)/(190*OFFSET(INDIRECT("'4.Prod Cost Est.'!$K$15"),MAX('7.DATA-Parts'!$B:$B)+$B$ l X ,0)) L( L%NB@H=0.7*SUMPRODUCT($R$5:$S$5,$R$ l X :$S$ l X J)*OFFSET(INDIRECT("'4.Prod Cost Est.'!$O$15"),MAX('7.DATA-Parts'!$B:$B)+$B l X R,0)/(190*OFFSET(INDIRECT("'4.Prod Cost Est.'!$K$15"),MAX('7.DATA-Parts'!$B:$B)+$B$ l X ,0)) L( L%NB@H=0.7*SUMPRODUCT($T$5:$U$5,$T$ l X :$U$ l X J)*OFFSET(INDIRECT("'4.Prod Cost Est.'!$O$15"),MAX('7.DATA-Parts'!$B:$B)+$B l X R,0)/(190*OFFSET(INDIRECT("'4.Prod Cost Est.'!$K$15"),MAX('7.DATA-Parts'!$B:$B)+$B$ l X ,0)) L( L%NB@H=0.7*SUMPRODUCT($V$5:$X$5,$V$ l X :$X$ l X J)*OFFSET(INDIRECT("'4.Prod Cost Est.'!$O$15"),MAX('7.DATA-Parts'!$B:$B)+$B l X R,0)/(190*OFFSET(INDIRECT("'4.Prod Cost Est.'!$K$15"),MAX('7.DATA-Parts'!$B:$B)+$B$ l X ,0)) L( L%NB@Hend *(Ho`?x *(H@@@@@@@@@@@@@@@@@@@@@@@@@@@@9this module updates all part related data in the workbookHfirst 7.DATA-Parts sheet is updated and then the other links are updated@@@@@@@@@@@@@@@@@@@@@@@@@@@@P################################################################################UPDATING THE 7.DATA-Parts SHEETP################################################################################/adding parts and changes for 7.DATA-Parts Sheet] ] ] ] ] ]0 ]H ]` ]x ] ] ] ] 7.DATA-Parts$6B@H$RB@H L%N!' L%N!' L%N!''_@< L%NB@H  ' L!P PART COUNTx;k;;insert listing value changesdetails p!rB@ .! L(P L%NB@H .!X L(P L%NB@H .!X L(P L%NB@H .! L(P cost values L%NB@H .!X L(P L%NB@H .!X L(P L%NB@H .!X L(P time values L%NB@H .!X L(P L%NB@H .!X L(P L%NB@H .!X L(P L%NB@H .!!d L(P L%NB@HFormula changeschange quantity L%NB@H L!'   L%NB@H L!'  L%NB@H=Sum(  :  ) L( L!' change size L%NB@H L!'   L%NB@H L!'  L%NB@H=Sum(  :  ) L( L%NB@H pB@N L%NB@H    pB@change est dev end timeActiveCell.Offset(-1, 4).Select$MyColumnLetterf = ActiveCell.AddressActiveCell.Offset(-2, 4).SelectESelection.AutoFill Destination:=Range("C13:C24"), Type:=xlFillDefaultRange("C13:C24").Selectchange est dev end timeActiveCell.Offset(1, 0).Select L!'   L%NB@H L!'  L%NB@H=MAX(  :  ) L( L%NB@H=SUMPRODUCT(I5:I  X ,D5:D  X ) p( L%NB@H =SUM(J5:J  X ) p( L%NB@H =SUM(K5:K  X ) p( L%NB@H L!' L%N!' L%N!' L%N!' L%NB@H .!!d L(P L%NB@H L%NB@H pB@   A L%N!P Default Part p!rB@.  '  L(P Delete Parts Part ActionsPro-DFMWorksheet menu bar$,%%%(DFM Part Evaluation Part ActionsPro-DFMWorksheet menu bar$,%%%(Edit Part Data Part ActionsPro-DFMWorksheet menu bar$,%%%(Supply Chain CostsAdvanced FunctionsPro-DFMWorksheet menu bar$,%%%('d1_1 L%NB@H L!P  L(Px0k00k0T####################################################################################*UPDATING THE 8.DATA-Parts EvalUATION SHEETT####################################################################################update partevaluation sheet'8.DATA-Parts Eval$6B@H$RB@H_@/ L%NB@H  ' L!Px/k.. p!rB@ActiveCell.Offset(0, -1).SelectGActiveCell.Formula = "='7.DATA-Parts'!UserFormAddpart.TextBoxName.Text"ActiveCell.Offset(0, -1).SelectActiveCell.Value = partno L%NB@H pB@N L%NB@H B@Just added by Atipol on 7/22/05 L%NB@H pB@N L%NB@H B@ActiveCell.Offset(0, 10).SelectActiveCell.Formula = "=SUMPRODUCT($I$5:$K$5,$I" + CStr(partno2 + 5) + ":$K" + CStr(partno2 + 5) + ")*('7.DATA-Parts'!$H$" + CStr(partno2 + 4) + ")*('7.DATA-Parts'!$D$" + CStr(partno2 + 4) + ")/90"ActiveCell.Offset(0, 1).SelectActiveCell.Formula = "=SUMPRODUCT($L$5:$N$5,$L" + CStr(partno2 + 5) + ":$N" + CStr(partno2 + 5) + ")*('7.DATA-Parts'!$H$" + CStr(partno2 + 4) + ")*('7.DATA-Parts'!$D$" + CStr(partno2 + 4) + ")/90"ActiveCell.Offset(0, 1).SelectActiveCell.Formula = "=SUMPRODUCT($O$5:$Q$5,$O" + CStr(partno2 + 5) + ":$Q" + CStr(partno2 + 5) + ")*('7.DATA-Parts'!$H$" + CStr(partno2 + 4) + ")*('7.DATA-Parts'!$D$" + CStr(partno2 + 4) + ")/90"ActiveCell.Offset(0, 1).SelectActiveCell.Formula = "=$R$" + CStr(partno2 + 5) + "*'7.DATA-Parts'!$H$" + CStr(partno2 + 4) + "*'7.DATA-Parts'!$D$" + CStr(partno2 + 4)  L%NB@H "Modify according to new code addedEnd of just addedActiveCell.Offset(0, 1).Select] l L! A L%NB@H l$R!P L%N!'dp( L%N!'kH(/Create summation formula for newly added column l L! A L%NB@H l$RB@H L!P p!rB@.  ''dX'  L%NB@H'k('  L(P L%NB@H='7.DATA-Parts'!C  X L($RB@H L%N!'   AActiveCell.Offset(0, 1).Select4ActiveCell.Value = CInt(UserFormAddpart.TextBoxSize)P################################################################################UPDATING THE SUPPLY CHAIN SHEETP################################################################################] 12.DATA - Supply Chain Costs$6B@H $RB@H L%N!''_$ L%NB@H  ' L!P p!rB@xp$kh$`$ $RB@H L!' L%N!P L%NB@H  L(P L%NB@H p!rB@. L%NB@H='7.DATA-Parts'!$C  X p(   L%Nb L%NB@H L(P=sum( L!X : L!X )  L%N("d"  L%NB@H  L(P L%NB@H='7.DATA-Parts'!$C  X p(   L%Nb L%NB@H L(P =SUMPRODUCT( L!X :   L%N!X <,OFFSET('7.DATA-Parts'!$D$5,0,0,MAX('7.DATA-Parts'!$B:$B)) )   L%N(&Just updated the formula by Atipol 8/2 !k!  L!X AP################################################################################"UPDATING THE COST ESTIMATION SHEETP################################################################################] 4.Prod Cost Est.$6B@H $RB@H' L%N!'_ L%NB@H  ' L!P p!rB@xhk`X $RB@H L%N!P $RB@H   L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@ L%NB@H p!rB@.  ' L%NB@H  p(P'd $RB@H   L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@ L%NB@H  p(P'k L%NB@H='7.DATA-Parts'!C  X p( L%NB@H='7.DATA-Parts'!D  X p( L%NB@H='7.DATA-Parts'!H  X p(Make this formula hidden L%NB@H=MIN(1,0.4*('7.DATA-Parts'!E  X #/12)) + MAX(0,0.6*('7.DATA-Parts'!G  X /52)) p( p(  L%NB@H='8.DATA-Parts Eval'!H  X p( L%NB@H=D  X !*'12.DATA - Supply Chain Costs'!D  X p( L%NB@H=D  X *F  X *E  X p( L%NB@H=F  X p( L%NB@H =SUM(H13:H  X ) p( L%NB@H =SUM(I13:I  X ) p( L%NB@H =SUM(J13:J  X ) p( L%NB@H =SUM(O13:O  X ) p( L%NB@H =SUM(P13:P  X ) p( L%NB@H=(1+L6)*'7.DATA-Parts'!I  X $R(*If ActiveCell.Offset(3, -8).Value = 0 ThenCells(4, 5).Formula = "=E7"Else!Cells(4, 5).Formula = "=E7+H6+H7"End If L%N!' ]8 ]P  L%N!' L%N!' L%NB@H_ L%NB@H L!Pxk]h ]  L%N!' L%N!' $RB@H =SUMPRODUCT(  :  ,  :  ) p( $RB@HPSelection.Formula = "=SUM('7.DATA-Parts'!$I" + CStr(partno3 + 4) + ":" + "$I$5)"   AT####################################################################################%UPDATING THE EVALUATION SUMMARY SHEETT####################################################################################6.DFM Eval Summary$6B@H$RB@H='7.DATA-Parts'!  p($RB@H=SUM('8.DATA-Parts Eval'!I  X :K  X )/(3*F3) p( L%NB@H=SUM('8.DATA-Parts Eval'!L  X :N  X )/(3*F3) p( L%NB@H=SUM('8.DATA-Parts Eval'!o  X :q  X )/(3*F3) p($RB@H=MAX('8.DATA-Parts Eval'!I6:K  X ) p( L%NB@H=MAX('8.DATA-Parts Eval'!L6:N  X ) p( L%NB@H=MAX('8.DATA-Parts Eval'!o6:q  X ) p($RB@H=SUM('8.DATA-Parts Eval'!H6:H  X ) p($RB@H=MAX('8.DATA-Parts Eval'!H6:H  X ) p(P################################################################################$UPDATING THE EXECUTIVE SUMMARY SHEETP################################################################################3.Exec Summary$6B@HG6$nB@H='7.DATA-Parts'!  p(D19$nB@H='7.DATA-Parts'!J  X p(D20$nB@H='7.DATA-Parts'!K  X p($RB@H='4.Prod Cost Est.'!P  X p( $RB@H='4.Prod Cost Est.'!O  X p(3Just added for updating part elimination likelihoodD26$nB@H!=IF(M27=0,0,'8.DATA-Parts Eval'!F  X /M27) p(End $RB@H=('4.Prod Cost Est.'!H  X ) - I26 p( 7.DATA-Parts$6B@H 7.DATA-Parts$6B@Z *(Ho  *(H@@@@@@@@@@@@@@@@@@@@@@@@@@@@] <this module updates all process related data in the workbookLfirst 9.DATA-Processes sheet is updated and then the other links are updated%*************************************!update 11.DATA - Proc Costs sheet(****************************************11.DATA - Proc Costs$6B@H] '$RB@H_@  L%NB@H L!PSTEP #x k ] L%NB@H L!P L%NB@H p!rB@  L(P L%NB@H L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@for operator 1 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for operator 2 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for operator 3 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for operator 4 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for equipment1 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for equipment2 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for equipment3 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@$RB@H L!' p!rB@.b7AH7Ad$RB@H'_ L%NB@H  ' L!Pxk p!rB@  L(P L!' L%NB@H L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@for operator 1 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for operator 2 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for operator 3 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for operator 4 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for equipment1 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for equipment2 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@for equipment3 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@H pB@N L%NB@H B@b7AI  X A'ky] ]8 $nB@H L%N!P L%N!P L%N!P L%N!P'dpx'k`x L%N!P L%N!P L%N!P' dw' kwP#################################################################################UPDATING THE 9.DATA-Processes SHEETP################################################################################7adding Processes and changes for 9.DATA-Processes Sheet]P]h]]]]]]]](]@]X]p '"d8v'"k(v9.DATA-Processes$6B@H$RB@H L%N!'0 L%N!'2_u L%NB@H L!Pxxukpu " '"Xu p!rB@ActiveCell.Offset(0, -4).Select " L(P L%NB@H B!6!d L(P L%NB@H B!8!d L(P L%NB@H B!:!d L(P L%NB@H B!<!d L(P] L!'>%*************************************update Process Data%*************************************9.DATA-Processes$6B@H >$nB@H L%NB@H='11.DATA - Proc Costs'!$D$ " X + '11.DATA - Proc Costs'!$E$ " X p(   B!@!d L(Pkr L%NB@H B!B!d L(P L%NB@H B!D!d L(P L%NB@H B!!d L(P L%NB@H B!!d L(P L%NB@H B!!d L(P L%NB@H B!F!d L(P L%NB@H L%NB@H$R!P L%N!'d0q L!'kq L%NB@H pB@N L%NB@H B@ " L%NB@H L!'insert here for max formula$RB@H L%NB@H L!P p!rB@.procno = procno - 1Delete ProcessProcess ActionsPro-DFMWorksheet menu bar$,%%%(DFM Process EvaluationProcess ActionsPro-DFMWorksheet menu bar$,%%%(Edit Process DataProcess ActionsPro-DFMWorksheet menu bar$,%%%(Cost Analysis by PlantAdvanced FunctionsPro-DFMWorksheet menu bar$,%%%('d0n " L%NB@H'kn " L(P L!'4 L%NB@H =MAX(M5:M " X ) L( L%NB@H =SUM(I5:I " X ) p( L%NB@H =SUM(J5:J " X ) p( L%NB@H =SUM(K5:K " X ) p( L%NB@H L!'* L%N!', L%N!'. L%N!'($RB@H L%N!'& & ( A%*************************************!update 11.DATA - Proc Costs sheet(****************************************11.DATA - Proc Costs$6B@H$RB@H_k L%NB@H L!P " L%NB@H='9.DATA-Processes'!$C$ " X p(xjkjj%*************************************update processevaluation sheet(****************************************'$10.DATA-Process Eval$6B@H$RB@H L%N!'&_i L%NB@H $ '$ L!PxHik@i8i p!rB@ActiveCell.Offset(0, -1).Select B!6!d L(P L%NB@H pB@N L%NB@H B@ L%NB@H] l L! $A L%NB@H l L%N!'(Just added by Atipol 7/22/05 L%NB@H l L! $A L%NB@H lend & ( A ''''''''''''$RB@H L%NB@H L!P p!rB@. $ '$df $ L%NB@Hkf $ L(PJ**************************************************************************"updating the cost estimation sheetI*************************************************************************]]]]]]0]H]`]x]]]]4.Prod Cost Est.$6B@H $RB@H'_d L%NB@H L!PASSEMBLY PROCESS L%N!' L!'H L%NB@H L!'J L%NB@H L!'N L%NB@H L!'P L%NB@H L!'R L%NB@H L%NB@H L!'Z L%NB@Hxxckpchc_`c L%NB@H  ' L!P p!rB@xckcc H$nB@H L%N!P H$nB@H  L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@ L%NB@H L%NB@H p!rB@.  '  L%NB@H  p(P'd` H$nB@H  L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@ L%NB@H pB@N L%NB@H B@ L%NB@H  L%NB@H  p(P'k^ L%NB@H='9.DATA-Processes'!$C$  X p( L%NB@H B!^!d L(P L%NB@H B!`!d L(P L%NB@H B!b!dXd L(P L!'\ L%NB@H='9.DATA-Processes'!$G$  X p( L%NB@H='9.DATA-Processes'!$H$  X p( L%NB@H='9.DATA-Processes'!$I$  X p( L%NB@H B!d!dXd L(P L%NB@H='10.DATA-Process Eval'!$E$  X p( L%N!'  L%NB@H L!'L L%NB@H L!'T L%NB@H L!'V L%NB@H L!'X L%NB@H=SUM( J : L ) p( L%NB@H=SUM( N : T ) p( L%NB@H=SUM( P : V ) p( L%NB@H=SUM( R : X ) p( $RB@H = SUMPRODUCT( Z : \ , J : L ) p(If Cells(13, 2).Value = 0 ThenCells(4, 5).SelectActiveCell.Formula = "=H6+H7"ElseCells(4, 5).Select ActiveCell.Formula = "=E7+H6+H7"End If   AJ**************************************************************************%updating the evaluation summary sheetL****************************************************************************6.DFM Eval Summary$6B@H$RB@H='9.DATA-Processes'! 4 p( $RB@HActiveCell.Offset(1, 0).Select=SUM('10.DATA-Process Eval'!f  X :j  X )/(5*H3) p( L%NB@H=SUM('10.DATA-Process Eval'!k  X :m  X )/(3*H3) p( L%NB@H=SUM('10.DATA-Process Eval'!n  X :o  X )/(2*H3) p( L%NB@H=SUM('10.DATA-Process Eval'!p  X :q  X )/(2*H3) p( L%NB@H=SUM('10.DATA-Process Eval'!r  X :s  X )/(2*H3) p( L%NB@H=SUM('10.DATA-Process Eval'!t  X :u  X )/(2*H3) p( L%NB@H=SUM('10.DATA-Process Eval'!v  X :x  X )/(3*H3) p( $RB@H=MAX('10.DATA-Process Eval'!f6:j  X ) p( L%NB@H=MAX('10.DATA-Process Eval'!k6:m  X ) p( L%NB@H=MAX('10.DATA-Process Eval'!n6:o  X ) p( L%NB@H=MAX('10.DATA-Process Eval'!p6:q  X ) p( L%NB@H=MAX('10.DATA-Process Eval'!r6:s  X ) p( L%NB@H=MAX('10.DATA-Process Eval'!t6:u  X ) p( L%NB@H=MAX('10.DATA-Process Eval'!v6:x  X ) p($RB@H=SUM('10.DATA-Process Eval'!E6:E  X ) p($RB@H=MAX('10.DATA-Process Eval'!E6:E  X ) p(I************************************************************************* updating executive summary sheetH************************************************************************3.Exec Summary$6B@HI6$nB@H='9.DATA-Processes'! * p(H19$nB@H='9.DATA-Processes'!J  X p(H20$nB@H='9.DATA-Processes'!K  X p(]] f h f h+ h f f h f h+ h fJ**************************************************************************!updating the 13.DATA-Plants sheetI*************************************************************************13.DATA-Plants$6B@H$RB@H] ]8]P]h]]]]]]]](]@]X]p]]'l'j_M L%NB@H L!PSTEP #xLkLL L%NB@H L!P L(PdxL_pL L%NB@H j 'j L!P p!rB@ j L(PxLkLLkK L%NB@H='9.DATA-Processes'!$C$ j X p($RB@H_K L%NB@H L!PxXKkPK l 'l8K4.Prod Cost Est.$6B@H$RB@H_J L%NB@H L!PSTEP #xJkJJ_J L%NB@H L!P jxxJkpJhJget values from cost estimation L%NB@H L!'n L%NB@H L!'p L%NB@H L!'r L%NB@H L!'t L%NB@H L!'v L%NB@H L!'x L%NB@H L!'z13.DATA-Plants$6B@H $RB@H_H L%NB@H L!P jxHkHH L%NB@H$get values from 13.DATA-Plants sheet l l  L%NB@H j  L%N!'| j  L%N!'~ j  L%N!' j  L%N!' j  L%N!' j  L%N!']=(  *((1+'4.Prod Cost Est.'! z )/(1-'4.Prod Cost Est.'! x )))*( (( | / ~ )*(('4.Prod Cost Est.'! r )/('4.Prod Cost Est.'! n )) )+ ((  *('4.Prod Cost Est.'! t ))*('4.Prod Cost Est.'! v )/('4.Prod Cost Est.'! p ))) '  p( L!' j  L%N!' j  L%NB@H=sum(  :  ) p( $nB@H lb12 X A++9.DATA-Processes$6B@H9.DATA-Processes$6B@Z *(HoD C:\MyFile.xls B@o`D B@Bo@DP] L!'   L%NB@H L!'  L%NB@H=Sum(  :  ) L(oC] :  ' $nB@H   p%(   p%(  p% 9 9qC  p% 9 9.ColorIndex = xlBlackqB  p% 9 9.ColorIndex = xlBlackq`B  p% 9 9.ColorIndex = xlBlackqB  p% 9 9.ColorIndex = xlBlackqA   p%.LineStyle = xlContinuous 9qhAd`AkXA $nB@Ho@A]`]x' select position8.DATA-Parts Eval$6B@H  $RB@H'k@  $RB@H'k`@ $RB@H'k(@ do operation]]     L!P   'k? L%NB@H   L%NB@H kH? select position10.DATA-Process Eval$6B@H $RB@H'k>  $RB@H'k> $RB@H'kP> $RB@H'k> $RB@H'k= $RB@H'k= $RB@H'kp= do operation     L!P   'k= L%NB@H   L%NB@H k<6.DFM Eval Summary$6B@H 'Rih<]]]8.DATA-Parts Eval$6B@H l n  $RB@H     L!P   'k; L%NB@H   L%NB@H 6. DFM Eval Summary$6B@H 'i; !!dplease enter values v$' !( !B@o:P' !(d !(d !(d !(d !!dX+ !!dX+ !!dX+' !!d$$$$' + X !(dkX9 !!dX+ !!dX+ !!dX+' !!d$$$$' + X !(dk`8 !!dX+ !!dX+ !!dX+' !!d$$$$' + X !(dkh7 !!dX+ !!dX+ !!dX+' !!d$$$$' + X !(dkp6     X !(d !!dX+ !!dX+ !!dX+$$d'$' + X !(d !!dX+ ! !dX+ ! !dX+$$d'$' + X !(d !!dX+ !!dX+ !!dX+$$d'$' + X !(d    X !(d    X !(d        X B!@(d    X B!D(d     X B!(d    X B!(do2 ' i2'o2'o2P$RB@H_h2 L%NB@H L!P (x82k02(2 L%NB@H L%NB@H L%NB@Hfor operator 1 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@Hfor operator 2 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@Hfor operator 3 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@Hfor operator 4 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@Hfor equipment1 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@Hfor equipment2 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P L%NB@Hfor equipment3 L%NB@H$ L(P L%NB@H$ L(P L%NB@H$ L(P X !(d    X !(d    X !(d        X b!@(d    X b!D(do,]update 7.DATA-Parts sheet 7.DATA-Parts$6B@H$RB@H_+ L%NB@H L!P ,x`+kX+P+ p!rB@.'l$RB@H_+ L%NB@H L!Px*k* l L(P l 'l*$update 8.DATA-Parts Evaluation sheet8.DATA-Parts Eval$6B@H$RB@H_@* L%NB@H L!P ,x*k** p!rB@.'l$RB@H_) L%NB@H L!Px)k) l L(P l 'lh) update supply chain sheet12.DATA - Supply Chain Costs$6B@H $RB@H_( L%NB@H L!P ,x(k(( p!rB@.'l $RB@H_( L%NB@H L!PxP(kH( l L(P l 'l (update cost estimation sheet4.Prod Cost Est.$6B@H $RB@H_' L%NB@H L!P ,x'k'x' p!rB@.'l $RB@H_@' L%NB@H L!Px'k' l L(P l 'l& l :B.o&(]update 9.DATA-Processes sheet9.DATA-Processes$6B@H$RB@H_P& L%NB@H L!P 2x &k&& p!rB@.'l$RB@H_% L%NB@H L!Px%k% l L(P l 'lx%$update 8.DATA-Parts Evaluation sheet10.DATA-Process Eval$6B@H$RB@H_% L%NB@H L!P 2x$k$$ p!rB@.'l$RB@H_$ L%NB@H L!PxX$kP$ l L(P l 'l($updating the plant data sheet13.DATA-Plants$6B@H $RB@H_# L%NB@H L!P 2x#k## p!rB@.'l $RB@H_H# L%NB@H L!Px#k# l L(P l 'l"#update process cost analysis sheet11.DATA - Proc Costs$6B@H$RB@H_p" L%NB@H L!P 2x@"k8"0" p!rB@.'l$RB@H_! L%NB@H L!Px!k! l L(P l 'l!update cost estimation sheet4.Prod Cost Est.$6B@H $RB@H_0! L%NB@H L!PASSEMBLY PROCESSx k  L%NB@H_  L%NB@H L!P 2x k x p!rB@.'l $RB@H_@  L%NB@H L!PASSEMBLY PROCESSx k L%NB@H_ L%NB@H L!Pxk l L(P l 'lhJust Added on 8/1 by Atipol6.DFM Eval Summary$6B@H$RB@H=MAX('9.Data-Processes'!$B:$B) L(End of just added l >B4o 8B@Bo++o@ ]` *!,!@.>3 Determine which control was clicked and act on it. >5View >!d 1.Cover PageKT 1.Cover Page$6B@Z2.Action ItemsKT2.Action Items$6B@Z3.Exec SummaryKT3.Exec Summary$6B@Z4.Prod Cost Est.KT4.Prod Cost Est.$6B@Z5.Comp Cost AnalysisKT5.Comp Cost Analysis$6B@Z6.DFM Eval SummaryKT6.DFM Eval Summary$6B@Z 7.DATA-PartsKT 7.DATA-Parts$6B@Z8.DATA-Parts EvalKT8.DATA-Parts Eval$6B@Z9.DATA-ProcessesKT9.DATA-Processes$6B@Z10.DATA-Process EvalKT10.DATA-Process Eval$6B@Z11.DATA - Proc CostsKT11.DATA - Proc Costs$6B@Z12.DATA - Supply Chain CostsKT12.DATA - Supply Chain Costs$6B@Z13.DATA-PlantsKT13.DATA-Plants$6B@Z14.HELPKT14.HELP$6B@Zn8k0q(o Attribute VB_Name = "Module1" Const mainmenu As$ SngPr o-DFMJDi m msg< $fla&Boolean(equiptarray(3, 4)8@Double#operator"4"calcula `gco1 P234 *e'e'e'es5ss ccasheetcreationNv'Deny the access ifsoftware is expired Sub Auto_Open() @dQD06/10/2006@z If  >qThe@wMsgBox ("Sorry. Your lice@nse ha$. Pcontact info@clover0.net for renewal ."D-ActiveWorkbook.ClosAEnd If1*(2-B-) <= 10 ,*(ve " &7C"ys lef&yH6v3'El˅./'OThoshown wX iIs movthan2da@$beIepro0gram/~s. (Dr.Das, we my not need one. Ju`|-1firmi{it's gorue c@heck c@:ectly.)"1- @MMM`d_CAWe(MmyMObj \har![Integerbexists+^Baddby @bpolbD=iaeaS@all'_ 'aAof jB B e = Fa1F NcE To App XBp.CommandBars("w P"t  bar") ntrols.coupnt P(a ap='WTru_Ex D/`Next`7a*`Sl2= k _lAdd(Type`:=msoAPopup, BR:=8cEWith`P @"' "&" deRes a ]rtcut ke;ssig!t (Alt+M@QVe). .C$B aCA#RItem#Y!(B* !'e±d!7^Delet^ϢH`~[l3 PPPO, K,?(aԀ?(2(W'<= *'^ &&a4(E).aS Ksub9qnL0NOlevelcPJ#H`g|J23k  b'0ts(,.O5olButtonW51A"sVqk"/R~5d File|(e0MOn!w nexfw6y22࣏Fq4 (}2olH2jPart s w0 ™ _ _ Qsw,] 3 3 ro WK1xC' 4r  .4   4 Advanc~Fun O7 5т? 0 5? ? {Oh@a 54 :J:5: @Defini}s Help J9.). 8hPer۰I76D 6wH|#$6nK6y bo~@ AkaR7; ``{ai~s_8Addaa'*PARTSoIA2d1$D6Ԗ_f"L4@aols.Add(Type:=msoControlButton, Beford1).Caption = " New Part" .ts( >@).OnActCode_EstimatevEnd WithH Dim newSubItem212 As Object!Set = CommandBar}Workshe&menu bar") _;main/kxg Us")K6 x%B2Edit Datarp I2@uPlP2P3PDFMCPEvaluaQ SeYS QΡ33WPcP3sP4KPelete(sR'k&remove&!&'*PROpCESS8E/3>1/__Wrocess31/CQ0M0pdetail 1k32'(((?(1(Ѩ <(/-(Pbr`("P$3__P_T n("RTTXed)TU}3TI}(?}?}?}l}3U_}]UUbz$UDU?U/T*15.HELnP'--' ;mA'C/bout']3AD efinis Helpu "Nhper'mLa_J,a/onuzAo3a++=OBa (REPORTO*]4 ]+ODODODODAdvanced Fun4 W0hUpd AWaY dSury56"YsumYY4b,b,{,_a֑4~bs-@ "Cost Analysis by PlanO-sccڿU)@.Enabl#= FalseƗ4c,,,´nctions") With newSubItem4c`.Controls.Add(Type:=msoTButton,@ Befor21 ).Cap = "Supply Chain Costs"(%`).OnAFsupch&9Enabled8False End$ '*SAVE AND OTHERS @ 'Dim As ObjecBtx'Set =mmandBars("Workshemenu bar") _' (mave book'$k=AACp'&"SmAm'`I.5II5pCoߡII ̼5I@IE@il ReportL("  LMail_ws@@  CreateThool(cATL, cbtlD@delete if it exis P = AwicayG+0Nam}" Flm Manufacturing", Posi`Flo ng@ .Visi= TruthelperAFormH.pShowy chUserCh1Code_Estim&A!'Prots -Co#4d SSqr4.`d 1@.")Passd:="dfm1209@Int aceO`nly:=cq 8k 8.DATA-Parts Ev$al er et$ct 10 10 rocesae/Addp/ vbM .l L6A(det]s0et000F>0r>Ya>00oL0&ge@L?Rh003000)007rF7o?00A 5<<0J\removea0/I0t/I"_BV/I ##WWW uRH_0_0H#aHhOh|50``k_yro_y:_y_yOOOOOOO_yo/&/&!&EPyQ~HHaupC/1/1/1/1 /1/1y aPubl$icb !sumScreenUpdw!dcount A9 ger g= s("8.DATA-Parts Eval").Select Cells(5, 2LDo Activet.Offset(1, "0FIf DValue = "" Then Exit End@ If p|c0ount% + 1 Loop SheetA6.DFM Summary' update6, 5DmyCif(C,ew-wl, 1)R(882U82]83 3 Dim processlAs Integerr = 0m10ęCCn ( 2Q510H'D(I r*O_]J {hkO`Okƒ--4 ^`4?l@[zCE++fs9`jH6r7l+7bbpplication.ScreenU!ing FFals`z0B#Subub cca( UserFormCC@A.Showe`xesum 3.Exec' a Edita'Prot@ worksA #4 L 4.`d Cost Es t.օPassd:="dfm1209", rFaceOnly:=Tru! vbModss Puo q o o o _b b cest OF 5!ig1 0 Guiines0openexpfileA%ro9s remopvep(i Gp '!rj(q.'ga-1#0a r"r7߈ ;I5D???5i/d"s8EntireRow.DP%5j@`Do WhG1).R <> "PART COUNT"LGoGaj Aj z?eupAAGGԦϱףϱ|  0msNMsgBox("re a0no "s, please er the firC7vbOKaA&rI4`/"/"/"/"A"4ڿ e)E6K@2KTextPFR.`N`#o$=2R]aiCF_vl[' o QC OOEliminmLi_ A׿ PA' /?qP/MS?//R   VP~Koooo$c$V>H____Y$DT____YTS//loooiP_3ڳValue = UserFormEvalPart.TextBoxPD$ ActiveCell.Offset(0, 1).S`elect >HRPFA'Just added by Atipol 7/22/05*Ɂula"='7.DATA-s'!$D$" + CStHr(i4)" *H(1-VALUE(MID(($F5$,2@,3)))"W0.5*SUMPRODUCT($I$5:$K$5,<$I \P)*("4 G)/904E4LA4NA4LR4^N4|4hOA4QA4OR4Q44}d|$RYbgnH-B5''endfpplication.ScreenHUpdngyTrue End0 Sub euateproc@zAs Int eger) Fals Sheet`s("10ehss "As (5, 2gDoC@ 1, 0gI f hei Then`xit If Loop!ar4G *B YST1_ PCE ?ͻ Q P'  _+cb@+OR AC 寁PNM__YPCl O+___ZOOOJG6?O+?CO +ONo o o o }OOOOOIP>V____YWI>PooooiTPQ%%%%%FfMbGpJi0.7ʬF Jϳ+ ":$Jo ")*OFFSET(INDIREP""'4.pd Co0Est.O$15""),MAXB:$B)+$B",0)/(190__PK_U_ aoٟGb̝:$MKMoT( ԟ@ϟgڟf'֐:$,$N/Oo?)=ٟ//Prod Cost Est.'!$K$15""),MAX('7.DATA-PartslB:$B)+$B$" + @CStr(i 5)",0))" ActiveCell.Offset(0, 1).Select >Formula = "=0.7*SUMPRODUCT($P$5:$Q$5, l)*OFFSET(INDIREH""'4.O /q/(1902RSbR:$SR!$ERR($TARUARTSRUR_RR?){V!)X!)V3)X?){9?)O}?)4-8G' end pplication.ScreenU$pdng@True End Sub InsertRow()Fals`' '@'this mod ule ues@ all p` related a in the workbook fir̉ɀ sheet @ qc d a@co r link r!?#?( UPING THE SHE|ET ? ?)b.axddi ̜̟rd"Һ$oodtr>r//// #ds? @22notes&@''PBB q7ityJG穔}_*S`!X? -(A S-p, Rb1]?HaSu m( + ":sqA{tp8 'change size ActiveCell.Offset(-1, 1).Select mycolumnletterf = dAddress(partno -, 0=s&QO JFo rmulaM"=Sum(" + + ":s ")" c2, 8]ion.Copy v PasteSpecial :=xl]s, Operat/ None, SkipBlanks:= _8C(FalsTranspose<:=best dev end tim'M|49'MyC|L| K>AutoFill D$in9R("C13:C24"), Typ3@E Defaul@' Ƨ@!:KgݧMAXñ}0, -5g5iUMPRODUCT(I5:IgCStr{+ 4)h,D5:Dk(J5:J? i? UM(K5:K? , 2'e Nkexecsumf1pan-3).2curbottomrigh~tv @!F0Value User!BT.TextBoxnotesm-0oP7)G@Clear eCaborders(`top@left, ,@ flag)InfB"drt" Then  EntireRow.Dt!= j  CommandBa"Worksheet menu bar")@ntrols("Pro-DFMkons Enabled4TruCo8C B Ev![p oooEditDataHAdvancFunPmSupply Chain Cost cca1RcreV BEz Do2t([i++E*:$)0x0!E~If Loop`5'#xUPDATING THE 8.A-Ps"#UON SHEET'@update2e* b 92p0>97 %@`_ld_alum*M9M13Mt(VM L| @RG R @2.EntireRohw.DtJ=p2 - 1 flag@\FaSCU_ , 0GDTru@CV(D].&wsCR@2@s(5M&Ltoplef_KW`FKBab qers(G, `T|, @a(E6C q(UserA@ #.T`fBoxS8ize a%a'#O?(UPING THE SUPPLY CHAIN SHEE>T ? ?)co|stG*! cSheets("12 TSupppChain Cs"OCd1Gf=y+ = /$=CS3`0oq#E  %+Aiss"" TgsIn @E`xit D@ehLoopc"urZfXk#`h|E"a-@@z@3304Do Whidle_ (-4)k <> " +  ] 0g(LR:l. ) "[C#$[?XQ?@on.߯oa/ @= 1SUMPRODUCT__?_W2S,O@FFSET(mD$5,0MAXB:$B)) )" 'JQupd0d theby Atipol 8/2"ym9q, X , ?~i`##fiCOST ESTIMATIOOi?r(diYiei4.Prodbh Est.hS3ieRPi?Pfhhnokh&hhh{f RTpl 3 p3, 5'!`CopyOWt(.PasOZP_i_?ߒ_qS3OcO-7nӿO*ezt(-1, 1).Select  8ion.Copy ActiveCell.O@ffset(0>Sheet. Pasted0, -7Value = partno3 fla"gTruHEnd If VFormulaG"='7.D ATA-Pas'!C" + CStr(r4)0B/D[/H/'Make this f~hidden#ǞMIN@z0.h4*(PE!Q" /12))MAX(0,0.6jG5"ɟDqH'1Ƅ3'8ȁ Eval'!S5>3QɚQDF*'12 - Supply Chain CostՒ0"5"FPa;`?dP7p  `-8]SUM(H13:7) I?Eg8 I I$ K J J ->O O ނ5 P P -6 g; s(9, )$(1+L6)*̎1u'If: 3`@I%0 TTh'4E7`F'ElsϘ`+H6+HCc`xcurbottomright _/! Address Dim revprocaddfs As ingmljj=T4).  =2 |DoO5Ke""tE0xit qE~LoopAAD[e_lX?  \_d_9h*@C?OCP2PRODUCT(q2 s`j:LeA,K+| " @G35, '?M= "=a;4$5+ 4{S"$I$5Call bor ders(.topleft, /, Qk '~#`UPING THE EVALUA TION MARY SHEETo Rs("6.DFM2}mmary"wNS#4OOA  columnletterpgcoun 6, /f'!+ 6K,)/(3*F3C!6?(!LONex1!oOq8XBB?06":+ s1C/__DLTo_w/oT[41Co;/_Hs(\6_ Ư56?JG QXECUTIVEQ '#L Sheets("3.Exec Summary").SelectDRange(" G6ion.Formula = "='7.DATA-Parts'!" + e stdevFD1 9-GJHCStrD(p,no3+5R))20)K)Cells(26, 8w4.Prod Cost Est.'!P+13V,90,O'Juadded for updating K elimin@on likh ood uD2uIF(M27=@0,0,'8x Eval'!F&$6)i"/ )"IEn@ @4, @('WH@A) - I2AŴIɇActivate A pplicBL.S@creenUET=p Tru3bBub Insertrowpro c(@{Fals'E@ Dim Aessexi`es all!% reld Aa in the workboDokfir 9G9 s s# H JandAJorHnk` rb;'***q 11B6`hcbh`_ # >!E)noc (Integer +a= 1S1, 2tDoBACeW.Offset(`0gIf GC ValueSTEP #" The5Exit aGIf Loopc HaEntireRow.Z $'d 0, 1'$al d-)Copy 0 ".PasyM{??'q'q`opera~ta-i,O earray( ~0N 12/ o </j1!2'3D b>EI5N o%O/7c}/3D\2, /q 4.P H/ /4ay(3llLcJGequipmento_=l%f_BB R1__4G ?_C_ ActiveCell.Offset(0, 1).Select Value = equipmentarra8y(1fX;2)P-n ion`.Copy870Sheet.Paste 'forp3&12, 0k4(1M(^d^ZAs(7(, 2 ks@taddressAǂEntireRow.DwCall borders("b7", "AHFalseS E$proPcnoc@#1 Do֏A E+ If HE"" ThenAGExit E nd IfLoop4GInser}c 0E/%| ?Mb|!%?c$ ,I?i7boperatK _@]c@_ ? /f>aMʥ 2// 8.uI/  )PDe/q>/?}/JP//}ϔϔ1//// "R"?@3G4R_93_B0 / ~?_7/j O_O/O/I/&S6_G|o_?G?G% >cw $nt^r^///{F Selection.Copy AveCell.Offset(1, 0). Sheet.Paste 0Call borders("b7", "AI" + CStr(procnoc7), True)7essex ist = @End IfZD im op$costflag As IntegeHr eq Range(startaddri If z0, 5).ValueH0 AF913#7 @Then |=d 1ls 0 k22"E26 3GIC,bH,NJ,p '#?JUPDATING @THE 9.A -Ps SHEET?-'Ping Ga@chAs for#gԅAno2curtopleftA @bottomrigh.estdevngno3nxecsumf1 e s5s.mycolumnletter@u`6trs iprcoun!A Y!0X& W"K"njs(4, ӠoE !=p8).A#2?O@aHHo H+y"" Exit D +ALoopaEntireRow.Ins8ertl/-4$ A 1UForm"p.TextBoxAss! (%× ! Type "9 oc T @Eq8uip_ _ _Tool5uthisDs5 +Pw!vA *pu pdateR Data/8es(8Sh # d)%g-$ulaA@8"='11e - Cs'!$D$< 6)@H"+ ?st1E9? 62JO Or v$;o4 *B$rPQ$G6??s5sS8t(D6d508PST tir/B!Brdtf Gdtr~r* ds/ gnotesX-m(_5agq5q 0d,jF-olFGE?Ə ts? ?sRI%ҽ/-x s~ Qibu hereҤmaxqmIWQ=CSۧ~Dfa'z0 -CommBaQWorksa menu bar0ZContr ol0=-DFM=\"on1]uc`Enabled     EvaOOPg ODEd4Q qssheet menu bar").Controls("Pro-DFM LAdvanced Func tions v@a'4C anoa`0h60 E n65, i8GRRj<-IcC!/3=%+ 1 s?<"">f-,;EntireRow.Inser'rD!eMU`tC.TextBoxAss!; !^gCopySK#C m.Past \Dim i As Inte`ger = 0 To 189FchangefSm(XI3G# F? 5N i&0"/TveI Q`1Ju`add0Atipol 7/22/05B,t(+ 6 la] s  t 'endqZurZvdZ 3"[A' P Ps(07#!?2Q&0Dga$O7 oi2~7J{Z25j?J`#ling the c imaR#_ 5assstarPs vfir`,7|l;9iOS1-P/Q/OS2.Q_tr / BO m"(_ >Sf4.`Rdb Est.@-fno32kDP_0'"ASSEMBLY PROCESSct :`g_6 J c=LOJt(@9ȑ0NH"Ya%'-5O -6'(OA?t(qY1MJ[_#1 if&po~.$#?U/Rv(E$G \p '\? Q 9).Select pion.Copy ActiveCell.Offset`(1, 0|Sheet.PasTted-f3`1c0, -5cEntire`Row.Dpartno3 =b - 1)1AValue flagFals@{EBRange(assst@/!,????ODɅDTruDnd If #BFormulaM"='9.DATA-Processes'!$C$" + CStr(K+ 4) CeUser!Add .TextBoxTPRHb? &? TBS P(CInt(RRP )) / 100 trtl`*( r*>3G3'˟@@H =I 69MYR6qf10Af Eval gE53costcurbottomright"o#o'XXOS2++u{Pd.Q?{wy%SU M(1Kfirs2tK":B9+ ")"_8 o+ OS1dO = "=E PHQO) QHD Qhs(9otI  PRODUCT""NWO,C)'If C1@3, 2).\0 Then '4, ('8I H6+H7'#෿oE7+tCall bo@rders(t;topleft, <, B>'**pupdating th(e eFuon summary sp*phQs("6.DFMM S"C8W.q./!"columnletterp`rcoun)1[9A0('ZMZf!,6)=j )/(5*H3Dcme?O ck:mG 3F H#mn% o' 2tvpE qO Q[r}] + 6)@":s"`CStr(partno3p)/(2*H3)" ActiveCell.Offset(1, 0).Se@lect ion.Formula = "=SUM('10.DATA-Process EvalH'!tw:utvIxI3 s(10, 4HMAXf67"t:j;5۹ 20 K Dim i1 As Integer AjK= 0 To 2 `3 equipmentarray(ij1)0 Next j1i  operator @%o *0#*t he 13dlants/*?7*xz, 2+ipdp ^strtA07S0b?rp?rs?,rp@yrdeMalphaMbet>gaAHdelpi^omeg:enras+J 75s / i`= 'Do If (ValueSTEP #" Then Exit E If Loop :  Else _ pYqQ+! e !1WUEntireRow.Inser1O 3&jEq`y13^q^!$C$S34)84, 380k'sK%!Stm4.d Cost Est.XC#"9C_ N_ R ** +*/0 0'get v3s f`rom cQwimatPbP=8Addro#Rss~p0?#so d;Z  3ty= _q,oDt,2, ]2).Select Do ActiveCell.Offset(1, 0If Value = ipd Then Exit End If LoopC0, 1 ' get vQs from 13.DATA-Plants sheeAFor is0 To p - 1#balpha;-(7 +c)wAddres@s bet6gamm5(del14pi b3omeg I2R im formstrin@g As SB  H= "=("@0+ "*((1+'4.Prod Cost E`st.'! de ")/(1-  ty ))*( (m/d(WpD )+n@*sC pt/X2bC)"ion.muljGY proce=ކstar>tȌ-(+@s~Q"=sum3':a4Ec Ra0nge(Next iCall borders("b12", C`O, True)aoperatorarray(4, 4)@ 0 equipXmen"!3'S 9dA+sses"Xbnatepplicat6ScreenUpd`e=`@6 Sub SaveName(#wWorkbook.AkFilen :="C:\My.xls@D" c Mail,_w EmF.Show b%cchA0L(mycolumnletteFr`|, pIno2!Integer Dks>SD Vi-( TN _ ֏ XGm"=SXYZ33Vt@opleft#,@ttomrighflag1Boolean$,}_r5`тb= eboF limgys(xlDiagonalDown).Lin eStylafxlxNon/!$UpuWith xlEdgeL1Continuoux&We= xlMedium./AETop .6'.Color IndexHxl Black? ? 8 Bo o o o o o h RQ_ _ _ _ _ _ T InsideVertXl ǯ  Thia1 s3<3_D1/ * Horiz-aE '/z/ QSQHls:q1wDC@!KtFunon NbuP7f(kG_,T mnp)scoc{ Pn1's" posi7vlD|8D|js EX|Ap!ags(6, 9G{q3a4261Oϑmd3o`5'do crx n rlo TH1s0cߣ 4 y>`Uq= '1D^P-cWr#?1#e?#U10+o# p o#llb#65Eo#'1x'DO#A42 4', 16).Sele ct c = 2PEnd If 4If pl5 ThenHCells(6P, 18+620+D7D2D3 'do operatiof For rn1 To k s 0 c - 1 Active.Value 8> mHco`untif#+ $I*Offs0et(0 iNe0xt sF1, -cr ~Sheets("6.DFM Eval Summary" my.1Fun>L  F p(i As IntegePr, jJkJlJmH) Dim #rO J:8.DATA-Parts<:i+- l@ńkl{ۂQ c{oc yH+yGw wAD;Sub check`Due(tNboxtem p,TBox)Q@ Me..`^""Gbmsg Msg("pl@ease e Er s", vb@OKOnly  l BackCol@u= &HF&`SetFocud,` alproccost( calc ulate`TrueUser o"ЄR d(((1"*A$2)) /1)), 2"3a >DCStr(! } ?6o%256 ?6"56o ?623p2 01,2 `0`?%'7: c362, Bop33p3P?6y(`S3k8663r]64op44V3ir gwS8tr(6toeq1 +j 23"4JD(OPSTb(9OOPCL'JOEQMe1 End SubPublic Function ulating() As Boolean HrEeC   change(@, 8Tru  dis FalsI `editp@wt(ynoA*IntegerCells(6, 2).Select: Do A@9ve.Offset (1, 0G If Value The@!Exi t )If LoopA 01a 'for operat1 l`0'l$ B3 2= %2r%bF 1 1T 9%39oJ3__D 0__o _%#~J`J_%&D+%43E2973aH>5O &F#/ l!C URֈK7)Z ̌ a% at(tc  6IIoy4I#"#HHOGďȏ\E2CSrϬ࿟1뙶xe? 2 Qvremove@partsa(number`Dim i(:update 7.@DATA-PA PsheeSas(""'4jijP0+n,`n= YNn @llc@_ estimat@l4.Prod Ah Est.i2i? 1?_%%4e?l0lCall UserFormRemoveP.combo@x(i) SLub: rp rocsaon"(aessAs Integerq`Dim DGC9v-@@cesCC4CCg  CCo1CCx84Bs EvԒy109"N6O_6_6CH*O~O~A~=/ ߁V?sP3s'Wing the plant sa513/rL //r5ceōW&o o o o Dߍ/B5+ ranalysis 1Rs6PE5Ұr _ _ _ Qe55i ? 7_`6P3ASSEMBLY PROCES~Sə)1-1' oZ3???e$(?_b* ?_0?_00ҽ__NDddrO/*O/O/D/Just Added on 8/1 by Atipol/6.DFM"mmary3, 8+/ѧula"=MAX('ataǡ'!$B:$B)"`8+of j .a Qe.prجPublic b abou t(ABT.0Show1arrayinitTialvalues() equipmentarray(3, 4) = 0 operator`4`End Sub  DisplayMess(age Dim ctl As CommandBarControl !Set!= Application.,ps.Ac46' Determine which cU was BcHked o act on iDt.9Wit,t~AIf .Cap2x"View" Then Sele&CaseY.Text"1aver P"'heets( )wvate,2 Items- . C3.Execukry\ _4.Prodst Est.W _5pCAnalysiH _6.DFM E@dK _7.DATA-Part1 _8H1 9d roce=? 10J mQ? 11" - `Xc"LR? 12% Su`y Cha4GH F'e@rror h@SlIf RI: Then Msg$ "PleaEr a !al",iExIma aI8f a@ the/ ? 20#/ Rity /Unit $" numbe r of  vari0-soo`nr"&  NCP. ~sq~BooP@!sMM Cells(4, 3).NDo Whi@ActP!.Su<> "GE6uE])&You)ve aldy eq'this 4na@f,bno "{xOffset(0, -1r}*OKOnly 5Exi0t Do+1, 0Loop17pt Г 1 .  Ac72oQ/)/5P4<'detailpo`valid0`mN.!j@ O2J _el3ZB7qoel4jX'[ P10 3el1[ Åtbtimeoa5kdP16Z!u7ks|1$=%b E_+Ѻ'_@Q;Smlod|s/9woc%W߲0&s%݃T dWrlappM'X"/"r(m_Ipi@@zeA"1L0^:3xv "0Pp HXx" ESPONDWOR KSHEEHATNTAINS!HELP PICS Cons\t @/Sn>grd$ HANGC-CAPTION DISPL`AYED 3RfM CaCV DefiniA\sB*1B" P@n@p Sub User_I alize$()! iecd befor@e the m is show(n @ ApRovwJgSe@Ahisibook.ms(O H= Appa0.FxFuncBŒAG.Range("A:A")7 '= 1ȚC/AComboBoxBs.AddItemg;.Cells(, 1 Next ,ListIndezx0# Y`U pd1/ En~d!2W 4F2s1h c *- 1Me.EG="%& " `(" & jof@&)")K)With Label"* L @c+) , 2,AutoSR)BWid@ = 212 Ûa+ Fr@1.Scxrol` "*H`eight.d+ 5C If#!Mhen @vi ousBun.Enƪ Ew *T aQ  Orror ResuFpm}FocusO2[+V_C}k=.wᏥach}dCG5 .r+__o Q  e m<>Ip !*< ; -If/Ћ1^7? ;  l. |( R{=1 g0P vjExit.   Unload M`q)We I`sts(sht)mBooleaxoi]o5xQ01 =| TqVc#Errp-0E @?<7{RQe  Sheet9validateform,w Sheet11Sheet14) HLOdxME(SPSSS0{4DB3CDD2-9141-47FF-999B-C31C3714071F}{A4916845-7252-472E-8139-6C6ED282792A}p BX  J  NpII`R rene h% %bpXp 8Dv "0Pp HXx"  "(8HXh x "  " &2 X`*p6.8 @HPpZ (0H  P`h Pp   0@ P`p    & 0 * ,8 *h , , * .( ,X . 0 6  "0 8  @  P ` p ] HelpSheet$D( Help: Add Part F( HelpSheet$6B@H H9$nB@HxH9$n!PI9$n!P H10$n!PX I10$n!PX H11$n!PX I11$n!PX H12$n!PX I12$n!PX H13$n!PX I13$n!PX H14$n!PX I14$n!PX H15$n!PX I15$n!PX H16$n!PX I16$n!PX H17$n!PX I17$n!PX H18$n!PX I18$n!PX F!H( 0 FB@B HelpSheet$D( 7.DATA-Parts$6B@Ho X B@`o .!(d .!(d .!(d .!(d .!(d .!(d .!(d .!(d .!(d .!(d .!(d L(o B@`o error handler !Please Enter a Material PA@kp !#Please Enter the Part/Material Name PA@k  !Please Enter Quantity /Unit PA@@k !(Please Enter the number of part variants PA@k !Please Enter the Unit Part Cost PA@k@]X'R 7.DATA-Parts$6B@H$RB@Hx L!Pb !!d L!PX  /You have already entered this name for part no  L%N!PX vA@'Rxk L%NB@H R|k ! ! ! ! !details ! T(H ! T(V ! T(X ! T(Zcosts ! T(\ ! T(^ ! T(`times ! T(b ! T(d ! T(f TB@BkXoPPrivate Sub UserForm_Activate())UserFormAddpart.TextBoxacrrange.Text = ""$UserFormAddpart.TextBoxdst.Text = "" %UserFormAddpart.TextBoxdtrr.Text = ""$UserFormAddpart.TextBoxMat.Text = ""%UserFormAddpart.TextBoxName.Text = ""$&UserFormAddpart.TextBoxQuant.Text = ""$UserFormAddpart.TextBoxrdt.Text = ""'UserFormAddpart.TextBoxrUcost.Text = ""%UserFormAddpart.TextBoxSize.Text = ""'UserFormAddpart.TextBoxsUcost.Text = ""*UserFormAddpart.TextBoxnotespart.Text = ""0UserFormAddpart.TextBoxnotespart.WordWrap = TrueEnd Subp' L( j(oAttribute VB_Name = "UserFormAddpart" Bas0{4DB3CDD2-9141-47FF-999B-C31C3714071F}{A49xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0DxAttribute VB_Name = "She@et9" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD24 0LwdxME(SPSSS0{096F30B0-72E1-4EEC-BF9F-D78DC310A4C7}{4BCE4B79-A96B-47DB-848D-C691AFDtdtxMEPSPSSS?@ABDEFGHIJKLMNOPQRTUVWXYZ[\]^_`abcdefghjklmnopqrstuvwxyz{}~ME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0DxAttribute VB_Name = "Sheet11" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2'dQ#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0DxAttribute VB_Name = "Sheet14" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD23d8#xSheet13UserFormHelp-SUserFormAddProcess&#(i*Sheet2C   'B !#$%&(;)-+,./<123456789:*D=>?@ACyEDFGHJJbLMNOPQRSTUVWXYZ[\]^_`Icdefghijklmnopqrstuvwxyz{|}~ME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0D xAttribute VB_Name = "Sheet13" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2 L3d^xME(SPSSS0{CE227952-B960-4062-A377-5345A6914034}{97753553-5254-4EA2-9062-8CF0063A1533} ph@%p %P@pD " ( A@ro`XAttribute VB_Name = "UserFormHelp" Bas0{CE227952-B960-4062-A377-5345A6914034}{97753553-5254-4 EA2-9T8CF0063A1533} dGlobalSpaco False Cr@eatablPredeclaDIdTru BE`xpose0TemplateDerivCus tomizD P Sub Label2_Click() Unload MGEnd 'do#xME PxPkH@ B!6!d !( Calculate !()) X !(d 0 B@BoA$ A@ro JThe data entered for the current process will be lost. Please ADD process. $'d0'k (6 ( ( (: (8 (D ( (@ (B ( (< B!^(d B!`(d B!b(d B!d(d B!F(do A@roH B!6!d$Please enter a Assembly Process Name v$'|k B!8!d Please enter a brief description v$'|8k0 B!:!d.Please enter Equipment needs (default is none) v$'|k B!<!d.Please enter a Tooling needs (default is none) v$'|hk` B!@!dPlease enter the Process Cost v$'|k B!B!d,Please enter the Setup cost (default is 0.0) v$'|k B!D!d,Please enter the Setup time (default is 0.0) v$'|@k8 B!!d;Please enter the required development time (default is 0.0) v$'|k B!!dEPlease enter the maximum development time risk range (default is 0.0) v$'|Hk@ B!!d8Please enter the development start week (default is 0.0) v$'|k B!^!d4Please enter the production rate (default is 100000) v$'|`kX B!`!d:Please enter the production batch size (default is 100000) v$'x|k B!b!d3Please enter the process cost risk (default is 0.0) v$'|xkp B!d!dL!dwxME(SPSSS0{7AC63E75-2917-420E-8EB7-DB433DA3C45A}{D75416A8-63C5-4949-B17D-EAAA75F440CF}( ` `x  J H N\\   H **` %8 %bh bh0HH@ 0@hD"  ( 0Php    "(0 8H "P X\h       0 @ P ` p     "  "6(`h p2 @( 0 8@P  0  >P X `>x  N0 8 @XX  J( 0 8FP  L   F8  H     ( "0 8 "@ H h   r 8 H  h  "   "   . 2 28 0p 2 0 0 .8 .h . . . .( .X . 6      0@ "HPXh]@]h0A"]p'9.DATA-Processes$6B@H$RB@H_ L%NB@H  'Us L!5Please enter the quality reject rate (default is 0.0) v$'|k 0B L('oo HelpSheet$D(Help: Add Process ( HelpSheet$6B@HH9$nB@HH24$n!PX I24$n!PX H25$n!PX I25$n!PX H26$n!PX I26$n!PX H27$n!PX I27$n!PX H28$n!PX I28$n!PX H29$n!PX I29$n!PX H30$n!PX I30$n!PX H31$n!PX I31$n!PX H32$n!PX I32$n!PX H33$n!PX I33$n!PX H34$n!PX I34$n!PX H35$n!PX I35$n!PX H36$n!PX I36$n!PX H37$n!PX I37$n!PX !X( 0 B@B HelpSheet$D(9.DATA-Processes$6B@Hop (oPH]$ '(If calcu = False Then 'Removed by Atipol+UserFormAddProcess.TextBoxAssProc.Text = "",UserFormAddProcess.TextBoxProcType.Text = "")UserFormAddProcess.TextBoxEquip.Text = ""+UserFormAddProcess.TextBoxTooling.Text = ""*UserFormAddProcess.TextBoxrPcost.Text = "")UserFormAddProcess.TextBoxsScost.Text = 0'UserFormAddProcess.TextBoxPST.Text = ""'UserFormAddProcess.TextBoxrdt.Text = ""(UserFormAddProcess.TextBoxdtrr.Text = ""'UserFormAddProcess.TextBoxdst.Text = ""(UserFormAddProcess.TextBoxTPRH.Text = ""'UserFormAddProcess.TextBoxTBS.Text = ""(UserFormAddProcess.TextBoxTRRP.Text = ""'UserFormAddProcess.TextBoxTYR.Text = ""0UserFormAddProcess.TextBoxnotesprocess.Text = "" L( ( (PElseEnd IfoA$oAttribute VB_Name = "UserFormAddProcess"D Bas0{7AC63E75-2917-420E-8EB7-DB433DA3C45A}{D75416A8-63C5-4949-B17D-EAAA75F440CF} dGlobalSpacAoFalse CreatablPredeclaIdTru BExpose0Template DerivCu@stomizDDim flag As Boolean  ms Sng P-1 Sub CommandButton5_Click() Call changecalcu %prnumber1Integer  = 0 Sheets("9.DATA-es").Select@ell@s(4, 2DRoZct@=C@.Offset(18, 0+ 1 If AValuAh"" TheAExit End If Loop Prcost9.Label39.Captionpϧ.TextBoxAss7 W@Tcuv"o@;o$Cq(?jP1Show vbMod\|ssoA>|X2LdisUnload M3fB= D2AaR= Msg)("4 d k e`Jg for th@e curr` "pC wiRbe l6. P`\`ADD.",OKCancel͠#Ex  @p Me*9+"#`1dstotrrEquip1DTypQ PSTrdo rPaSNsSnOU]x2DTi ngwZTPRHM!RE&TBS_CeTRRPd YRIwnotesC)Son4S?[x j[/R_dX_ asembly !G AZOnlyAZby?YlP$?a brief descriKd_/iw@m?needs (default is none) 1mN>/ @R@?T1O }O eI4O O gtWjE ?? ? 5 R"CQxE//)Setup rI0.0t   Rti`Bb4aB?5R#Z  re br@develop- > dj maximum? risk r?*8.8 st  y start week ?? pSx("JQ8hdur!'1000ᬟ'rAKiwo o ee batch size f'< ~ aߓC&::ub^f 9_ _ e quality rej0/`  { l pule1.In trowAP2.EnW4#dKFr1wIHelp 2η Workst!2Visic)12: u@Sheet").Select Range(" H9dUserHelp2.Label3.Caption = CStr(r24tValue) + 4I4H255H265H27c5 H28 H2 H3051 H31 H32W H33W H3׆H3׆H3׆H3׆MShow vbHModssWorkssSVisibleFalse  9.DATA-Process es@YEnd Sub P@rivate OBButton2_Click() Command5.EnadTru |Form_A ct Dim calcu As Boolean #=#lating'If= " Then 'Removed by Ati@pol ' AddD.TextBoxAss!9""Ty pe EquipTrPcostsS0}ST? d `.dtrVr  ds TPRH  TBSceRRPYRdnotesppLk2HkyVo;*v. \'Eb'tIf u#~tDeauCall disBs(SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0DxAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2L3dxMEUserFormRemovePart&$UserFormEvalPart"%o<UserFormEvalProc" 7UserFormSugvalues$S[ P=A Sub cmdcancel_Click() Unload MlEndrIf MsgBox("Are you suwant to " + ,+fromA r analysis?. All da wi@be lost", vbYesNovbQues tion)@avbThen E(xit,EBwCa@Module1. psac(I> 'Up@e (1@ i1 To Combo9TUs.ListCo@unt '@2 item a6the @ . MC IA 0 Next iA\.E_InitializeIf;g_ vw'*Execd befoiA)m is show@R@ B 5Set She@= ThisWorkbook.s(Al&D"7.DATA-As").Spelecd&# 0[Cells(4, 2LA6ve.Offset(1, 0).Vatluv0@d=FR`Cv no ?, pleᎠder irstBMOKOnly  bDAdd@ow.M12@ u(oF3k 'a)sa+(.5, yDo@ +=+ 1 '%"PART COUNT"D'b CLoop' /-/'MyColumnLetpterffh'rXessl (- 1)":t s %C# (a|ula "=Sum(@:s ") c!x ^ s rˇ_ChangeNrwRrZcbde=Index>CɚjƠ(ȀA# s"help rR = BtB!E64hAqAA-A@add a23 f@k@a>W1tOKa4Q/31:qMC3nQF::& [rv= 0,p6SS*PubPs -(pZLD@RowJ 'qp9ppPav.MFunPKon.R ANRR0"A:A<") AwA= 5awA+ 33%Es_$R$3#TCRv*t*yZ+=TQO5P F5 Dk " 0 "8t@  & THE WORKSHEET THAT CONTAINS THE HELP TOPICS ]8.DATA-Parts Eval0$CUSTOMIZE THE FOLLOWING STATEMENT TO(CHANGE THE CAPTION DISPLAYED ON THE FORM]Help !x(d !z(dMe.TextBoxQCR.Text = "" !~(d !(d !(d !(d !(d !(d !(d !(d !(d !(do  nAto` A@ro He@*$#,##0.00;($#,##0.00)_H,,5Tahoma6iHelp {w@Tahoma61 'CenterOwner TypeInfoVer = 67 End 16,XCommandButton2eM., PCommandButton3eM.( j4TextBoxOPCto9P lr$MaskEdBox1toC3mgkgtgnnmnmninigthkgogggvmkhinjggnvm( k4lpSheet$D(Help: Part Details ( HelpSheet$6B@HH19$nB@HH19$n!PX I19$n!PX H20$n!PX I20$n!PX H21$n!PX I21$n!PX H22$n!PX I22$n!PX !H( 0 B@B HelpSheet$D(8.DATA-Parts Eval$6B@Ho HelpSheet$D(A. PROCUREMENT: Response Scale ( HelpSheet$6B@HH3$nB@HH3$n!PX I3$n!PX J3$n!PX !H( 0 B@B HelpSheet$D(10.DATA-Process Eval$6B@Ho  HelpSheet$D( B. PART GEOMETRY: Response Scale ( HelpSheet$6B@HK3$nB@HK3$n!PX L3$n!PX M3$n!PX !H( 0 B@B HelpSheet$D(10.DATA-Process Eval$6B@HoLdxME(SPSSS0{D65475A8-7A21-4F39-90FE-416DCC50FED4}{42DF6043-0591-443D-87FF-7DF345F5D70E}(@bn`n"   h8((`` x i . i`xxP% %bb8xHHPDk " 0 "8t@  &0 @ PX` "h *p  8 B8      , @HP &X * 0 * * R@    " .  "  @X x* (8@H Pp" x P.  0@ HX h]]]H A@rt.TextoH Are you sure you want to remove  + from your analysis?. All data will be lost   $ H|@d8 n 0B*UpdateForm (1)( l ~! Remove an item from the ListBox. ~B@ lNAhko$ Executed before the form is shown2Set PartSheet = ThisWorkbook.Sheets(PartSheetName) 7.DATA-Parts$6B@H]$RB@H L%N!P/There are no parts, please enter the first part v$' .B@B|hk`] $RB@H&Worksheet(PartSheet.Cells(5, 3).Select_ L%NB@H  ' L!P PART COUNTxkActiveCell.Offset(-1, 0).Select$MyColumnLetterf = ActiveCell.Address*ActiveCell.Offset(-(partno - 1), 0).Select$MyColumnLetters = ActiveCell.Address"x#ActiveCell.Offset(partno, 0).SelectLActiveCell.Formula = "=Sum(" + MyColumnLetterf + ":" + MyColumnLetters + ")" A@.oP8( Executed when the ComboBox is changed ~! 'n nA@ox Updates the help topic n ~( 7.DATA-Parts$6B@H$RB@H L%N!Pplease add a part first v$'|k$RB@H_ L%NB@H L!P xk L%N!P'o]8ITopicCount = Application.WorksheetFunction.CountA(PartSheet.Range("A:A")) x  x 7.DATA-Parts$6%R ~B@ x ~('n nA@oAttribute VB_Name = "UserFormRemovePart"D Bas0{D65475A8-7A21-4F39-90FE-416DCC5D4}{42DF6043-059J43D-87FF-7DF345F5D70E} dGlobalSpacoFalse CreatablPredeclaIdTru BExpo se0TemplateDerivCustomizDDim msg As Sng  str5 curren@ttopic Integer` HelpSheet$D( C. PART HANDLING: Response Scale ( HelpSheet$6B@HK3$nB@HN3$n!PX O3$n!PX P3$n!PX !H( 0 B@B HelpSheet$D(10.DATA-Process Eval$6B@HoH$ Executed before the form is shown]2Set PartSheet = ThisWorkbook.Sheets(PartSheetName)8.DATA-Parts Eval$6B@H$RB@H L%N!P/There are no parts, please enter the first part v$' .B@B|kStart of newly added codeEliminationList.Value = "" | (1.0) - No - Provides Primary FRC@ (1.0) - No - Motion RequirementsC@"(0.8) - No - Material RestrictionsC@"(0.7) - No - Assembly RestrictionsC@%(0.6) - Yes - Possible to Transfer FRC@&(0.5) - Yes - Possible to Reduce CountC@!(0.3) - Yes - Easy to Transfer FRC@!(0.2) - Yes - FR maybe EliminatedC@(0.0) - Yes - Redundant FRC@(1.0) - No - Unable to EvaluateC@qEliminationList.End of newly added code$RB@H&Worksheet(PartSheet.Cells(5, 3).Select_X L%NB@H  ' L!PxkActiveCell.Offset(-1, 0).Select$MyColumnLetterf = ActiveCell.Address*ActiveCell.Offset(-(partno - 1), 0).Select t .dxMEPSPSSSz?2?Call e u Ep(iuC on3 Unload`& ( QLabelT~s("!").pVisicSuges.%`:bt Deta8ilsX" SelecRang2e19@  "1h CStr(Value)h + II" RH20WH21VH22G1Show vbMod`&ss ?5/).g-D)U-9!t!!!!A. PROCURa: RespP]e Scalre"et@ 38s."" m (IJs>.t10krocesk/bD20OO?<kO@B@ART GEOMETRYo = DKAG&=oho`L>Mooo41%OooLV42~<VQJVCd`DLoo04oҽ!ohNOPo?oooE)4al7oS%*_Initializ e'Execpd befor@e the m is sYnC=RZћ'S`ThisA 0bookCs(4% \6Cells(5, 2wIctp.Offset(p1, 0 }$`00 The = Msg("0 !P no ѿs,0 pleqerir",iOKOnlyP '8AddQ0xiftfIfLt of new@ly addcn#'EliminaList.BA "bWit\h L.PItem "(1.0) - No@Provides `:mary FNROFMoRequiremsO0.8Gr$npnoc7fAssemb'ro x 0. 6aY - Pos^to Tra8nsf 0. 5 ReduPCount"  .AddItem "(0.3) - YesEasy to Transfer( FR2jFR maybe Eliminate dj05Redu ndantd1. .NoUnableEvalucbEnd With'ionList. of newly added codeCells(5, 2).SelectWorksheet(PartS .3 Do @Active.Offs1, 0p"no = + 1 ITf Vne"" Then `Exit .tIf LoopZ '6- 7'MyColumnLetpterf ress (D(- 1)0sC #Formula"=Sum (" + /+ ":s@ ")CmnTopic½(pplicatE@.uFunkon.B AxRange("A:A" ))' Row6 Top4ComboBoxBs؂s("8.DATA-Ads "), 3NextAIndex!0Ccurrexntt;@"UpdT (I HSubAHPriv  '(c As Integ4er' #s the helpq@, I"ip 4tkgjni0h"msg@$Msg4("please a a: first", vbOKOnlyBpB&pav\҂a#1CO0Λ0Me.TM`!PF~RB#"( 1ˠ CF Id#l s#&-a "(Prov id`@_marygEls{ #=a #% 0AQ~C\0$ H%g0M>S0OOGVPK_."t(o=hH__O WDT_YyTSlOO Po hPDo d+ _,9D H? OONPFA ' S. 6>`>VH/PK2CapQFH qw!& " P& Czb Q`"_Pq' Labelsw~.t)q^F.AutoSiz!Fa&N' .Width` 212ѹTruP'M1 TFrame1.Scrol 4'Height .4+ 5G$]n= 1z PreviousDBun.E¿d2 pp{?1 t q!On Error Resu|me  xSetFocu`P~ I_Ck(Execu@ w is chMѭd ʙ= [.禒)g ߟ [ e * <>$#  , 槯 WU q/#/ + 7 f |* z r topic)  End If 8Sub Private 8 ExitButton_Click('xecuted when theAR is cXedUnload MeFunction Sheetpsts(sht) As B@ooleanGDim Temp(Works5On Error Resume NextSet9= Thisbook.";If% = 0GqN TruxlsZ Fa rkx](]P]]x](]P]]]/CUSTOMIZE THE FOLLOWING STATEMENT TO CORRESPOND.TO THE WORKSHEET THAT CONTAINS THE HELP TOPICS-Par]10.DATA-Process Eval$CUSTOMIZE THE FOLLOWING STATEMENT TO(CHANGE THE CAPTION DISPLAYED ON THE FORM]Help nAJoPo A@ro` HelpSheet$D(%D. PROCESS DIFFICULTY: Response Scale ( HelpSheet$6B@HH5$n!PX I5$n!PX J5$n!PX K5$n!PX L5$n!PX !H( 0 B@B HelpSheet$D(10.DATA-Process Eval$6B@Ho HelpSheet$D(E. EQUIPMENT: Response Scale ( HelpSheet$6B@HM5$n!PX N5$n!PX O5$n!PX !H( 0 B@B HelpSheet$D(10.DATA-Process Eval$6B@HoP HelpSheet$D(F. TOOLING: Response Scale ( HelpSheet$6B@HP5$n!PX Q5$n!PX !H( 0 B@B HelpSheet$D(10.DATA-Process Eval$6B@Ho HelpSheet$D(G. SETUP: Response Scale ( HelpSheet$6B@HR5$n!PX S5$n!PX !H( 0 B@B HelpSheet$D(10.DATA-Process Eval$6B@Ho HelpSheet$D(H. HANDLING: Response Scale ( HelpSheet$6B@HT5$n!PX U5$n!PX !H( 0 B@B HelpSheet$D(10.DATA-Process Eval$6B@Ho HelpSheet$D(J. INVENTORY: Response Scale ( HelpSheet$6B@HV5$n!PX W5$n!PX !H( 0 B@B HelpSheet$D(10.DATA-Process Eval$6B@HtoP HelpSheet$D($K. QUALITY & TESTING: Response Scale ( HelpSheet$6B@HtiveCeX5$n!PX Y5$n!PX Z5$n!PX !H(Ac 0 B@Bla HelpSheet$D(rf + "10.DATA-Process Eval$6B@HIToofile = ThisWorkbook.NameA(Workbooks(file).Activate$ Executed before the form is shownval$]2Set PartSheet = ThisWorkbook.Sheets(PartSheetName)10.DATA-Process Eval$6B@H $RB@Hpic_ L%NB@H  '$ L!PxxkphActiveCell.Offset(-1, 0).Selectea$MyColumnLetterf = ActiveCell.Address*ActiveCell.Offset(-(partno - 1), 0).Select$MyColumnLetters = ActiveCell.Address#ActiveCell.Offset(partno, 0).Select!xLActiveCell.Formula = "=Sum(" + MyColumnLetterf + ":" + MyColumnLetters + ")"L!PITopicCount = Application.WorksheetFunction.CountA(PartSheet.Range("A:A")) x  x10.DATA-Process Eval$6%R ~B@ x ~('nA@oP Updates the help topic n ~(10.DATA-Process Eval$6B@H$RB@H L%N!P7There are no process steps, please enter the first step v$' BB@B|Hd@$RB@H_  L%NB@H t ,d8xMEPSPSSS_Initializ e'= ThisHbook.Q '5s().Activp0Execd befor@e the m is spnS=RPP 'Sw\bjd?*:*1Cells(5, A3).Select Do ActiveCell.Offset(1, 0partno =  + 1 If nValueB"" Then Exit End If Loop 'm- n'MyColumnLet0terfV3AddressH(- 1) Ss)( &GFormula'"=Sum (" + _+ ": s")"'Topi@cCountQpplication.WorksheetFun׀QA(PS .Range("A`:A"))'O Row%6 To 4ComboBoxBs.W Item s("10.DATA -Proc] E@val").As"(, 3NextLis@tIndex"0CcurrenttA<@#Upd8ateUSuBbHPriv Հ ('@ Cs the hexlp "J N \=I+ A5x, 2ˋƊ0msg>Msg `("re a p\steps, pleas$e Ler9first A", vbOKOnlyCUserOrl`.ShowSElse#~s(!w(]Ra3j+c悂daュ0, 4G,Q.TO`(YST_).H2 1? P|CE @ x.Q t PT G*OR AaaAC mNM PCD 5e *OOf55GS l.6VO qI OoȉoooxCON ًMoxOoo/cPVw; oxWIPooooPOQ6 OOox%` %%¬{sFoia3 #qS'PmC_12{ Prev@iousBun.EnabledFa`u u?5Tr ns~ _WPOn Error Resume  xSЦocusO oteb)_CkExecut`w⌁ is chd = [.wRɑ硯 ; w e ": <> " ! < rA1 q ~ ? ;  f "/Sȧ={ c "?a.  Unload Mo uӓ`sts(sht) As Booleap Dim Temp5x01%=5isbookc#0:p; <7C pF-e CL(SPSSS0{5981114A-7436-42C4-9140-62C878EFB3F0}{8AC9B982-32D4-4EE2-BB51-16A956E4E75A} ph@%p %P@pD " ( A@ro`XAttribute VB_Name = "UserFormSugvalues" " Bas0{5981114A-7436-42C4-9140-62C878EFB3F0}{8AC9B982-32D4-4EE2-BB51-16A956E4E75A} dGlobalSpaco False Cr@eatablPredeclaDIdTru BE`xpose0TemplateDerivCus tomizD P Sub Label2_Click() Unload MGEnd HLOdxME(SPSSS0{B2504UserFormInitialData(& UserFormEditPart"U,UserFormEditProcess(LUserFormABT+iart first v$'kX$RB@H_8 L%NB@H L!P nxk L%NB@H !!d L(P L%NB@H !!d L(P L%NB@H !!d L(P L%NB@H !!d L(P L%NB@H !!d L(P L%NB@H !!d L(P L%NB@H !!d L(P L%NB@H !!d L(P L%NB@H !!d L(P L%NB@H !!d L(Po HelpSheet$D(Help: Part Specifications F( HelpSheet$6B@HH9$nB@HH9$n!PX I9$n!PX H10$n!PX I10$n!PX H11$n!PX I11$n!PX H12$n!PX I12$n!PX H13$n!PX I13$n!PX H14$n!PX I14$n!PX H15$n!PX I15$n!PX H16$n!PX I16$n!PX H17$n!PX I17$n!PX H18$n!PX I18$n!PX F!H( 0 FB@B HelpSheet$D( 7.DATA-Parts$6B@Hop$ Executed before the form is shown]02Set PartSheet = ThisWorkbook.Sheets(PartSheetName) 7.DATA-Parts$6B@H 7.DATA-Parts$6B@H]H$RB@H L%N!Pplease enter a part first v$' .B@B|0k(]`$RB@H&Worksheet(PartSheet.Cells(5, 3).Select_ L%NB@H  ' L!P PART COUNTxkxpActiveCell.Offset(-1, 0).Select$MyColumnLetterf = ActiveCell.Address*ActiveCell.Offset(-(partno - 1), 0).Select$MyColumnLetters = ActiveCell.Address#ActiveCell.Offset(partno, 0).SelectLActive      !"#$%&'()*+,-./0123456789:;<=>?@ABC]FGHIULMNOPQRSTEVWiYZ\~_`abcdefghXjkumnopqrst[vwxz{|}PtX"dCxMEPSPSSS'Cells(4, 2).Select 'St@ worksheet #P4 SAs0("4.\yst Est.")! Passd:="dfm1209DIkF@f,:=88.DATA-Parts Eval:etct 10 10 roces`)Je Addiby Atipol on 7/22/05 E*%2Range0("S6@eAct`t7.!ulae=SUMPRODUCT($I$5:$K$5,$I66)*('7)'!$H5D5)/90`VTLNL-N*MD5jUjOaQajO`QslV=R6-H5-D5`''alof j@a@ Call`isWk@book.idA`entryYou have sucaRfully cJanalysis fifor " +8 Me"" p Unload`V2GAB ɪmDetails_cѡem/ '/ /  Ug 5-B9DC-0373A9F6CB04}{6B76D1FB-8401-4B2F-8D28-E2554AAA858A}P X N..` THE B hx..`xeet `:`t Es BBi$6  X  , I 8i  p%x% %bnxXX xD"  "(0HP,p   8P h    (@ Xp    "&@` x8Hh  " * 8