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.

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

Another good article at Designing Attribute Acceptance Sampling Plans (http://www.mathdl.org/mathDL/4/?pa=content&sa=viewDocument&nodeId=428&bodyId=417) 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!

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!

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.

check (activex), tanks to ganesha.org:
http://www.ct-yankee.com/sampplan/

it's great. :magic:

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".