Carlr Ray,
I'm aware of limited built-in statistical capability in Excel. Writing
macros for statistical functions in Excel sounds very painful, as you say.
Some would argue that you shouldn't do it at all. Look here:
http://www.qualitydigest.com/sep99/html/excel.html
... although others might argue that the author of the article has ulterior
motives.
You can find lots of Excel add-on macro packages by searching the net with
Google. Consider Q1 Macro, SPC IV Excel, and macros from BaRaN Systems.
They less that a half days pay at your full burdened rate. How can you go
wrong?
Dave Fish
----- Original Message -----
From: "Carlr Ray" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Friday, January 31, 2003 3:03 PM
Subject: Re: [TN] CP CPK Calculations
> Dave,
> Does Excel have a function for calculating CPK? I have a hard time
> trying to get the formulas right.
>
> >>> [log in to unmask] 01/31/03 09:56AM >>>
> RE: [TN] CP CPK CalculationsJohn Grabski III,
>
>
>
> For calculating Cpk on you Palm, try: MobileSPC 1.0 by Visual
> Solutions [[log in to unmask]]
>
>
>
> While "Mobile SPC" will calculate Cpk with your Palm, we use Excel to
> print charts and record Cpk calculations. Our concern about doing Cpk
> calculations on the Palm is it promotes a tendency to "quickie"
> decisions. Yano, when a Cpk "pops-up" on the computer, "it must be
> true" type thing. We want to sit-down and assure ourselves that all the
> prerequisites [ie, normal distribution, stable, in-control, etc] are
> met.
>
>
>
> On the Palm, we collect data and do data grubbing with "ProStats 2.3.4"
> by Software Engineering Inc. [[log in to unmask]].
>
>
>
> On a different, barely related, statistical topic, while you're rooting
> around "palmgear.com" [ tucows.com, palmblvd.com, or where ever] finding
> "Mobile SPC", download "Six Sigma Calculator v1.3" by Embark
> Technologies [[log in to unmask]]. It is two calculators for the price
> of one [Actually it's freeware, such a bargain!!!]. The calculators
> determine:
>
> * Process sigma using given opportunities and defects.
>
> * Allowed defects for a specified number of opportunities and target
> sigma. Includes a table for allowed DPMO.
>
>
>
> Dave Fish
>
>
>
> ----- Original Message -----
> From: Grabski III, John R.
> To: [log in to unmask]
> Sent: Thursday, January 30, 2003 11:00 AM
> Subject: Re: [TN] CP CPK Calculations
>
>
> I'm a minitab n00b and even I find it easy!!
>
>
>
> (I'm wondering if there's a Palm version, or any Palm software that
> does this stuff. My Visor Treo 90's beggin to come to work with me J)
>
>
>
> -John Grabski III
>
> Engineering Tech.
>
> Badger Technologies
>
>
>
> -----Original Message-----
> From: Becerra Alejandro [mailto:[log in to unmask]]
> Sent: Tuesday, January 21, 2003 9:49 AM
> To: [log in to unmask]
> Subject: Re: [TN] CP CPK Calculations
>
>
>
> Minitab is a great software for calculate process capability.
> It also calculates overall capability Pp and Ppk.
>
> Alejandro Becerra
>
> -----Original Message-----
> From: Carlr Ray [mailto:[log in to unmask]]
> Sent: Tuesday, January 21, 2003 7:37 AM
> To: [log in to unmask]
> Subject: [TN] CP CPK Calculations
>
>
>
> Hey guys,
> Got any ideas for some quick and dirty software to use for CP and CPK
>
> Calculation?
>
> Carl Ray
>
> ---------------------------------------------------
> Technet Mail List provided as a free service by IPC using LISTSERV
> 1.8e
> To unsubscribe, send a message to [log in to unmask] with following
> text in
> the BODY (NOT the subject field): SIGNOFF Technet
> To temporarily halt or (re-start) delivery of Technet send e-mail to
> [log in to unmask]: SET Technet NOMAIL or (MAIL)
> To receive ONE mailing per day of all the posts: send e-mail to
> [log in to unmask]: SET Technet Digest
> Search the archives of previous posts at:
> http://listserv.ipc.org/archives
> Please visit IPC web site http://www.ipc.org/html/forum.htm for
> additional
> information, or contact Keach Sasamori at [log in to unmask] or
> 847-509-9700 ext.5315
> -----------------------------------------------------
>
> ---------------------------------------------------
> Technet Mail List provided as a free service by IPC using LISTSERV
> 1.8e
> To unsubscribe, send a message to [log in to unmask] with following
> text in the BODY (NOT the subject field): SIGNOFF Technet
> To temporarily halt or (re-start) delivery of Technet send e-mail to
> [log in to unmask]: SET Technet NOMAIL or (MAIL)
> To receive ONE mailing per day of all the posts: send e-mail to
> [log in to unmask]: SET Technet Digest
> Search the archives of previous posts at:
> http://listserv.ipc.org/archives
> Please visit IPC web site http://www.ipc.org/html/forum.htm for
> additional information, or contact Keach Sasamori at [log in to unmask] or
> 847-509-9700 ext.5315
> -----------------------------------------------------
> ---------------------------------------------------
> Technet Mail List provided as a free service by IPC using LISTSERV
> 1.8e
> To unsubscribe, send a message to [log in to unmask] with following
> text in the BODY (NOT the subject field): SIGNOFF Technet
> To temporarily halt or (re-start) delivery of Technet send e-mail to
> [log in to unmask]: SET Technet NOMAIL or (MAIL)
> To receive ONE mailing per day of all the posts: send e-mail to
> [log in to unmask]: SET Technet Digest
> Search the archives of previous posts at:
> http://listserv.ipc.org/archives
> Please visit IPC web site http://www.ipc.org/html/forum.htm for
> additional information, or contact Keach Sasamori at [log in to unmask] or
> 847-509-9700 ext.5315
> -----------------------------------------------------
>
> ---------------------------------------------------
> Technet Mail List provided as a free service by IPC using LISTSERV
> 1.8e
> To unsubscribe, send a message to [log in to unmask] with following text
> in
> the BODY (NOT the subject field): SIGNOFF Technet
> To temporarily halt or (re-start) delivery of Technet send e-mail to
> [log in to unmask]: SET Technet NOMAIL or (MAIL)
> To receive ONE mailing per day of all the posts: send e-mail to
> [log in to unmask]: SET Technet Digest
> Search the archives of previous posts at:
> http://listserv.ipc.org/archives
> Please visit IPC web site http://www.ipc.org/html/forum.htm for
> additional
> information, or contact Keach Sasamori at [log in to unmask] or
> 847-509-9700 ext.5315
> -----------------------------------------------------
>
> ---------------------------------------------------
> Technet Mail List provided as a free service by IPC using LISTSERV 1.8e
> To unsubscribe, send a message to [log in to unmask] with following text in
> the BODY (NOT the subject field): SIGNOFF Technet
> To temporarily halt or (re-start) delivery of Technet send e-mail to
[log in to unmask]: SET Technet NOMAIL or (MAIL)
> To receive ONE mailing per day of all the posts: send e-mail to
[log in to unmask]: SET Technet Digest
> Search the archives of previous posts at: http://listserv.ipc.org/archives
> Please visit IPC web site http://www.ipc.org/html/forum.htm for additional
> information, or contact Keach Sasamori at [log in to unmask] or 847-509-9700
ext.5315
> -----------------------------------------------------
>
---------------------------------------------------
Technet Mail List provided as a free service by IPC using LISTSERV 1.8e
To unsubscribe, send a message to [log in to unmask] with following text in
the BODY (NOT the subject field): SIGNOFF Technet
To temporarily halt or (re-start) delivery of Technet send e-mail to [log in to unmask]: SET Technet NOMAIL or (MAIL)
To receive ONE mailing per day of all the posts: send e-mail to [log in to unmask]: SET Technet Digest
Search the archives of previous posts at: http://listserv.ipc.org/archives
Please visit IPC web site http://www.ipc.org/html/forum.htm for additional
information, or contact Keach Sasamori at [log in to unmask] or 847-509-9700 ext.5315
-----------------------------------------------------
|