Where to find an acceptance sampling excel macro or .xls template?

[mondolfo]

Hello there, I´m looking for an excel macro which calculate the aprox. n having as an input: AQL, LTPD, Beta and the Alpha.

Can any boby can help me?

Thanks.

 

[Al Rosen]

Hello there, I´m locking for a excel macro wich claculate the aprox. n having as an imput: AQL , LTPD , Beta and the Alpha.

Can any boby can help me?

Thanks.

Try www.samplingplans.com

 

[Al Rosen]

Designing Attribute Acceptance Sampling Plans and Excel Macro

Another good article at Designing Attribute Acceptance Sampling Plans with an excel macro. You can control n & c of the sampling plan to meet your alpha & beta. It also displays the Operating Curve. Really nice!

 

[Caster]

Kenneth Stephens is the Man

Hello there, I´m locking for a excel macro wich claculate the aprox. n having as an imput: AQL , LTPD , Beta and the Alpha.

Can anybody can help me?

Thanks.

I highly recommend "The Handbook of Applied Acceptance Sampling" by Kenneth Stephens.

It comes with a CD jam packed with Excel spreadsheets.

It is also a ripping good read if you really have to understand sampling plans. He writes so even I can understand.

It's worth way more than my company paid for it.

It was recommended to me by another Cover.

Good luck!

 

[Govind]

Hello there, I´m locking for a excel macro wich claculate the aprox. n having as an imput: AQL , LTPD , Beta and the Alpha.
Can any boby can help me?
Thanks.

www.variation.com is also a very useful site on acceptance Sampling related topics, tables, etc. They publish a book "Guide to acceptance Sampling" that come with a floppy disk containing various DOS based Sampling program.
Another place would be Statgraphics Plus statistical software. This comes with Variable and Attribute Sampling features.
Regards,
Govind.

 

[Darius]

check (activex), tanks to ganesha.org:
(broken link removed)

it's great.

 

[Craig H.]

Hello there, I´m locking for a excel macro wich claculate the aprox. n having as an imput: AQL , LTPD , Beta and the Alpha.

Can any boby can help me?

Thanks.

Check out Dr. Ken Stephens' "Applied Acceptance Sampling".