5s rrssssss s s s s            EO K!H#$&m's()*+,125/ q H       ' ( ) *+, -125 d h @isaaf(h @isapp(GCALC''GCOL$$GCOLUMN$$GDATA1 @GDATA2A sGHEADERGINSTGINSTNS-1%.GINSTNS-2;%KGMEAN_SL1GMEAN_SL2GMEAN_SL3GMEAN_SL4GMEAN_SL5 GMENU''GNAME GSET GSET 1rGSET 2rGSET 3rGSET 4  rGSET 5  rGSETS GTABLEGTITLE15GVALUES G\0$$G\C'('(G\D'I'IG\E''G\F']']G\I'e'eG\J'm'mG\M$$G\P'5'5G\R'%'% @0 # gi( f$%&'(( LB)"*-qq                 #'\m$'{menubranch menu}''ENTER DATA('DELETE DATA)'CALC DATA *'PRINT +'QUIT,'INSTRUCTIONS1'PART NUMBER2'X5uJ@7 " STATS-5.0                G''Enter Print Nominal, Spec. Limits, and "X" Number of Data Points?('Erase All Data and Analysis Fields (takes a few seconds),)'Calculate and View Statistical ValuesF*'Print Title, Specification, Statistical Values, and/or Raw Data$+'Quit Worksheet, Return to DOS/,"View or Print Brief Program Instructions1'PART NAME2'Y ('STATISTICAL DATA ANALYSIS PROGRAM #'column $''{branch \e}('{branch \c})'{branch calc}*'{branch \p} +'/qye,"{branch \I}1'REVISION2'Z #'col$  1'SUPPLIER2'1 2 1'BY: 2'MJM*'NOTE: 100 POINTS MAX. PER DATA SET' ANALYSIS TABLE$'{menubranch menu}*''{calc}{PANELOFF}{goto}P10~{PANELON} $'{BEEP 4}''{branch \m}"|\*'*\*\*\*\* \* \* \* "|  "|  ^SET 1 "|  ^SET 2 "|  ^SET 3 "| ^SET 4 "| ^SET 5 "| "| \* "| \* "| \* "| \* "| \* "| \* "|   "| \* "| \* "| \* "| \* "| \* "| "| "|  ^SET 1 "|  ^SET 2 "|  ^SET 3 "|  ^SET 4 "|  ^SET 5 "|   ^NOMINAL "|   "|   "|   "|   "|   "| "| \* "| \* "| \* "| \* "| \* "| \* "|   'UP. SPEC. "|   "|   "|   "|   "|   "| "| 'SAMPLE MEAN "|* יfQ2fQ;3  "|* ֙fQ2fQ;3  "|* ֙fQ2fQ;3  "|* ֙fQ2fQ;3  "|* ՙ fQ2fQ;3  "|   'LOW SPEC. "|   "|   "|   "|   "|   "| "| 'SAMPLE STD. DEV. "|k ՙ\eXeReR  # 2eXeReR  # ;3  "|k ՙ\eXeReR  # 2eXeReR  # ;3  "|k ԙ \eXeReR  # 2eXeReR  # ;3  "|k ԙ\eXeReR  # 2eXeReR  # ;3  "|k ә\eXeReR  # 2eXeReR  # ;3  "|\*\*\*\*\*\*\*\* \* \* \* \*"|"HIGHEST SAMPLE VALUE"|+әdT2dT;3"|+әdT2dT;3"|+ҙ dT2dT;3"|+ҙdT2dT;3"|+ҙdT2dT;3"|"-DATA- 1"| \* \* \*   \*   \*"|"LOWEST SAMPLE VALUE"|+љ cS2cS;3"|+љcS2cS;3"|+ЙcS2cS;3"|+ЙcS2cS;3"|+ЙcS2cS;3"| "| \* \* \*   \*   \*"|'MEAN + 3 SIGMA "|3$   2   ;"|3$ 2 ;"|3$ 2 ;"|3$ 2 ;"|3$ 2 ;"| "| \* \* \*   \*   \*"|'MEAN - 3 SIGMA "|3$   2   ;"|3$   2   ;"|3$   2   ;"|3$   2   ;"|3$   2   ;"|' ENTER 4"| \* \* \*   \*   \*"|\*"|\*"|\*"|\*"|\*"|\*"|' "Q" 5"| \* \* \*   \*   \*"|'MEAN + 4 SIGMA "|3$   2   ;"|3$   2   ;"|3$   2   ;"|3$   2   ;"|3$   2   ;"|' FOR 6"| \* \* \*   \*   \*"|'MEAN - 4 SIGMA "|3$   2   ;"|3$   2   ;"|3$   2   ;"|3$   2   ;"|3$   2   ;"|' STATS-5.0)!" STATISTICAL ANALYSIS PROGRAM' LAST 7"| \* \* \*   \*   \*"|\*"|\*"|\*"|\*"|\*"|\*"|' POINT 8"| \* \* \*   \*   \*"|'MEAN + 6 SIGMA "|3$   2   ;"|3$   2   ;"|3$   2   ;"|3$   2   ;"|3$   2   ;"|!'INSTRUCTIONS  "| \* \* \*   \*   \*"|'MEAN - 6 SIGMA "|3$   2   ;"|3$   2   ;"|3$   2   ;"|3$   2   ;"|3$   2   ;"|  "| \* \* \*   \*   \*"|\*"|\*"|\*"|\*"|\*"|\*"|7'1. To start, choose "ENTER DATA" from the menu.  "| \* \* \*   \*   \*"|'% TOL. USED, 8 SIGMA"|Cϙ 4   2   ;3"|Cϙ4   2   ;3"|Cϙ4   2   ;3"|CΙ 4   2   ;3"|CΙ4   2   ;3"|L'2. Follow the directions concerning data entry and # of data points.  "| \* \* \*   \*   \*"|\*"|\*"|\*"|\*"|\*"|\*"|I'3. When finished entering data, hit "Q", then choose "CALC DATA".  "| \* \* \*   \*   \*"|^CPk M>2.00 P>1.33"|@͙1 S  2 S  ;3"|@͙1 S  2 S  ;3"|@͙1S  2S  ;3"|@̙ 1S  2S  ;3"|@̙1S  2S  ;3"|F' Program will calculate values and move to "ANALYSIS TABLE". "| \* \* \*   \*   \*"|\*"|\*"|\*"|\*"|\*"|\*"|D'4. To print analysis of current data, choose "PRINT". Enter "| \* \* \*   \*   \*=" Y or N when prompted regarding printing raw data. &"\e''{GOTO}B1~ "| \* \* \*   \*   \*B'5. To erase all data and start over, choose "DELETE DATA".N''{getnumber "Enter Data Set (1 thru 5): ",column}{WINDOWSOFF}{PANELOFF} "| \* \* \*   \*   \*M'6. If you make an entry error, you may edit the value before leaving !''{calc}{WINDOWSON}{PANELON}   "|   \*   \*   \*   \*   \*N " data entry column by simply re-entering the appropriate value. If /' '{getnumber "Enter Print Nominal: ",AE8} !!"| !!\* !!\* !!\*  ! !\*  ! !\*O!" you are elsewhere in the program, exit the macro , "CONTROL-BREAK", 2'!'{getnumber "Enter Upper Spec Limit: ",AE9} """| ""\* ""\* ""\*  " "\*  " "\*M"' "ESC", edit in Lotus (F2), and restart the macro, "ALT M". Don't I'"'{getnumber "Enter Lower Spec Limit: ",AE10}{WINDOWSOFF}{PANELOFF} ##"| ##\* ##\* ##\*  # #\*  # #\*@#" forget the choose "CALC DATA" after any data editing.<'#'{goto}AE8~/C{END}{DOWN}~{HOME}{DOWN 11}{RIGHT COL+1}~ $$"| $$\* $$\* $$\*  $ $\*  $ $\*G$'7. To SAVE DATA, exit the macro and save the worksheet under a 8'$'{GOTO}B9~{down 7}{right col}~{WINDOWSON}{PANELON} %%"| %%\* %%\* %%\*  % %\*  % %\*4%" "DIFFERENT" name, such as a part number.W'%'{?}~{if @cellpointer("contents")="q"}{PANELOFF}/re~{GOTO}B1~{panelon}{branch \m} &&"| &&\* &&\* &&\*  & &\*  & &\*<&'8. To quit the program, choose "QUIT". (tricky, huh)'&'{down}{branch \r} ''"| ''\* ''\* ''\*  ' '\*  ' '\*A''9. Press "ENTER" to return to menu or "PgDn" to continue. (("| ((\* ((\* ((\*  ( (\*  ( (\*L('10. To change print nominal and/or spec limits while keeping the same &("\cT'('{PANELOFF}{WINDOWSOFF}/reD12.D14~/reF12.F14~/reH12.H14~/reJ12.J14~/reL12.L14~ ))"| ))\* ))\* ))\*  ) )\*  ) )\*H)' data points, choose "ENTER DATA" again for the same data set ')'/reSET 1~ **"| **\* **\* **\*  * *\*  * *\*N*' (1 thru 5), re-enter the new print specs, the use the down arrow to'*'/reSET 2~ ++"| ++\* ++\* ++\*  + +\*  + +\*N+' go the bottom of the data points, and enter "Q". Then "CALC DATA".'+'/reSET 3~ ,,"| ,,\* ,,\* ,,\*  , ,\*  , ,\*','/reSET 4~ --"| --\* --\* --\*  - -\*  - -\*'-'/reSET 5~ . ."| ..\* ..\* ..\*  . .\*  . .\* '.'{calc} /!/"| //\* //\* //\*  / /\*  / /\*$'/'{GOTO}B1~{PANELON}{WINDOWSON} 0"0"| 00\* 00\* 00\*  0 0\*  0 0\*'0'{BRANCH \M} 1#1"| 11\* 11\* 11\*  1 1\*  1 1\* 2$2"| 22\* 22\* 22\*  2 2\*  2 2\* 3%3"| 33\* 33\* 33\*  3 3\*  3 3\* 4&4"| 44\* 44\* 44\*  4 4\*  4 4\* 5'5"| 55\* 55\* 55\*  5 5\*  5 5\* &5"\PP'5"{GETLABEL "Do You Want the Raw Data Included in Printout, Y or N: ",AM55} 6(6"| 66\* 66\* 66\*  6 6\*  6 6\* &6'6"{IF AM55="Y"}{BRANCH \D} 7)7"| 77\* 77\* 77\*  7 7\*  7 7\*.'7'{WINDOWSOFF}{PANELOFF}/REAM55~{PANELON} 8*8"| 88\* 88\* 88\*  8 8\*  8 8\*0'8'{GETLABEL "Enter the Part Number: ",AY1} 9+9"| 99\* 99\* 99\*  9 9\*  9 9\*D9' Press "ENTER" to return to menu or "PgDn" to continue.*'9'{GETLABEL "Enter Part Name: ",AY2} :,:"| ::\* ::\* ::\*  : :\*  : :\*)':'{GETLABEL "Enter Revision: ",AY3} ;-;"| ;;\* ;;\* ;;\*  ; ;\*  ; ;\*&;'.';'{GETLABEL "Enter Supplier Name: ",AY4} <.<"| <<\* <<\* <<\*  < <\*  < <\**'<'{GETLABEL "Enter Your Name: ",AY6} =/="| ==\* ==\* ==\*  = =\*  = =\*\'='{GETLABEL "Is Your Printer Ready (align paper)? If Yes, Hit ENTER: ",AM60}{PANELOFF} >0>"| >>\* >>\* >>\*  > >\*  > >\*'>'/PPRNAME~AG ?1?"| ??\* ??\* ??\*  ? ?\*  ? ?\*'?'RTITLE~G @2@"| @@\* @@\* @@\*  @ @\*  @ @\*'@'RVALUES~G A3A"| AA\* AA\* AA\*  A A\*  A A\*'A'RHEADER~G B4B"| BB\* BB\* BB\*  B B\*  B B\*'B'RTABLE~G C5C"| CC\* CC\* CC\*  C C\*  C C\*PC'If you have any comments, questions, problems, or suggestions for refine- 'C'PQ D6D"| DD\* DD\* DD\*  D D\*  D D\*ID'ments, additions, or corrections, please call or drop me a note on'D'{GOTO}B1~ E7E"| EE\* EE\* EE\*  E E\*  E E\*E"Exec-PC.'E'{WINDOWSON} F8F"| FF\* FF\* FF\*  F F\*  F F\*'F'{BRANCH \M} G9G"| GG\* GG\* GG\*  G G\*  G G\* H:H"| HH\* HH\* HH\*  H H\*  H H\*!H' Malcolm McClung I;I"| II\* II\* II\*  I I\*  I I\* &I"\D.'I'{WINDOWSOFF}{PANELOFF}/REAM55~{PANELON} J<J"| JJ\* JJ\* JJ\*  J J\*  J J\*0'J'{GETLABEL "Enter the Part Number: ",AY1} K=K"| KK\* KK\* KK\*  K K\*  K K\*# K' "STATS" version 5.0*'K'{GETLABEL "Enter Part Name: ",AY2} L>L"| LL\* LL\* LL\*  L L\*  L L\*)'L'{GETLABEL "Enter Revision: ",AY3} M?M"| MM\* MM\* MM\*  M M\*  M M\*.'M'{GETLABEL "Enter Supplier Name: ",AY4} N@N"| NN\* NN\* NN\*  N N\*  N N\**'N'{GETLABEL "Enter Your Name: ",AY6} OAO"| OO\* OO\* OO\*  O O\*  O O\*'O'Press "ENTER" to return to menu.&O'YU'O"{GETLABEL "Do You Have Fewer than 51 Data Points per Data Set, Y or N: ",AM80} PBP"| PP\* PP\* PP\*  P P\*  P P\*\'P'{GETLABEL "Is Your Printer Ready (align paper)? If Yes, Hit ENTER: ",AM60}{PANELOFF} QCQ"| QQ\* QQ\* QQ\*  Q Q\*  Q Q\*'Q'/PPRNAME~AG RDR"| RR\* RR\* RR\*  R R\*  R R\*'R'RTITLE~G SES"| SS\* SS\* SS\*  S S\*  S S\*'S'RVALUES~G TFT"| TT\* TT\* TT\*  T T\*  T T\*'T'RHEADER~G UGU"| UU\* UU\* UU\*  U U\*  U U\*'U'RTABLE~G VHV"| VV\* VV\* VV\*  V V\*  V V\*'V"{IF AM80="N"}{BRANCH \F} WIW"| WW\* WW\* WW\*  W W\*  W W\*'W'PRDATA1~G XJX"| XX\* XX\* XX\*  X X\*  X X\* 'X'PQ YKY"| YY\* YY\* YY\*  Y Y\*  Y Y\*'Y'{GOTO}B1~ ZLZ"| ZZ\* ZZ\* ZZ\*  Z Z\*  Z Z\*'Z'{WINDOWSON} [M["| [[\* [[\* [[\*  [ [\*  [ [\*'['{BRANCH \M} \N\"| \\\* \\\* \\\*  \ \\*  \ \\* ]O]"| ]]\* ]]\* ]]\*  ] ]\*  ] ]\* &]"\F']'PRDATA1~G ^P^"| ^^\* ^^\* ^^\*  ^ ^\*  ^ ^\*'^'PRDATA2~G _Q_"| __\* __\* __\*  _ _\*  _ _\* '_'PQ `R`"| ``\* ``\* ``\*  ` `\*  ` `\*'`'{GOTO}B1~ aSa"| aa\* aa\* aa\*  a a\*  a a\*'a'{WINDOWSON} bTb"| bb\* bb\* bb\*  b b\*  b b\*'b'{BRANCH \M} cUc"| cc\* cc\* cc\*  c c\*  c c\* dVd"| dd\* dd\* dd\*  d d\*  d d\* eWe"| ee\* ee\* ee\*  e e\*  e e\* &e"\IN'e"{GETLABEL "Do You Want to Print or View Instructions, P or V: ",AM103} fXf"| ff\* ff\* ff\*  f f\*  f f\*&f'v 'f"{IF AM103="P"}{BRANCH \J} gYg"| gg\* gg\* gg\*  g g\*  g g\*'g'{paneloff}{goto}inst~ hZh"| hh\* hh\* hh\*  h h\*  h h\* 'h'{?}~ i[i"| ii\* ii\* ii\*  i i\*  i i\*'i'{GOTO}B1~{panelon} j\j"| jj\* jj\* jj\*  j j\*  j j\*'j'{branch \m} k]k"| kk\* kk\* kk\*  k k\*  k k\* l^l"| ll\* ll\* ll\*  l l\*  l l\* m_m"| mm\* mm\* mm\*  m m\*  m m\* &m"\J'm"{WINDOWSOFF}{PANELOFF} n`n"| nn\* nn\* nn\*  n n\*  n n\*'n"/PPRINSTNS-1~AG oao"| oo'* oo'* oo'*  o o'*  o o'*'o"RINSTNS-2~G pbp"| pp'* pp'* pp'*  p p'*  p p'* 'p'PQ qcq"| qq'* qq'* qq'*  q q'*  q q'*'q'{GOTO}B1~ rdr"| rr'* rr'* rr'*  r r'*  r r'*'r'{WINDOWSON}{PANELON}s\*s\*s\*s\*s\*s\* s\* s\* s\* s\*'s'{BRANCH \M}