on 10-20-2014 3:53 PM
hi, experts
We faced one situation,use sample-drawing procedure:
IF P2<= 3 THEN P2 ELSEIF P2 <=300 THEN ROUND(SQRT(P2)+1) ELSE ROUND(SQRT(P2)/2+1)
The formula was too long beyond 60 chars. So I was try to use user-defined formula, such as:
But another question appeared:
When I used TFKT:ZC() or TFKT:ZD() which used nested parameters, it couldnot correctly calculate the physical sample.
Was I make some error for ZC/ZD?
Any advice will be helpful!
It looks like you'll have to build a sampling scheme for this.
I did that fo SQRT(N) +1 once for a sampling procedure.
It's not too bad. I used Excel to figure the calculations out and then was able to combine lines. Then I basically built the entries in Excel as they are in SAP and was able to copy and paste most of the data into the scheme.
I think it wound up to be about 90 lines or so for up to a sample size of 10,000. Not fun, but you only have to do it once, (in each client!).
Craig
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have resolve this question. The formula was with syntax error.
The correct formula is like below,
in the sample-drawing procedure, the formula should be defined like this
IF P1<=3 THEN P1 ELSE TFKT:Z1(P1)
In the user-defined procedure is " IF #1<=300 THEN (SQRT(#1)+1) ELSE ROUND(SQRT(#1)/2+1)"
Hello Craig,
I have a similar requirement as above. I searched for some existing threads and I found your suggestion.
I have a question regarding building up the sampling scheme as you suggested, because in my case the quantity of the pallet/container size varies for every material
For example:
Material A: 1 Container = 132 PC
Material B: 1 Container = 1600 PC
Material C: 1 Container = 3000 PC
Sample Drawing procedure:
1 to 2 pallet Sampling Quantity = 10
3 to 5 pallet Sampling Quantity = 20
6 to 20 Pallet Sampling Quantity = 30
>20 Pallet Sampling Quantity = 40
In such case how to create the sampling scheme, because it is difficult to create sampling scheme for every material.Please give your suggestions.
Best Regards
Hari
Its not clear in your example what the relationship is between pallet and container.
In your shipment, you have two values it appears to work with. 1) the number of PC's. 2) the number of pallets.
What you don't indicate is how these containers relate to a pallet.
If one pallet of material A has 20 containers and hence, 2640 PC are you sampling 10?
If one pallet of material B has 10 containers and hence 16,000 PC are you also sampling only 10?
Both are only one pallet. This doesn't sound right.
Typically you set up a sampling procedure for each UOM used by receipting. I.e. usually this would be by case, box, etc...
The above is easy of you truly sample by pallet. But I suspect you don't.
Which means you really need to set up your sampling scheme on either eaches or case, or box or whatever your sampling is truly done for.
Craig
Hello Craig,
Sorry. It is my mistake to mention as container, we receive the materials in pallets and do the sampling in PC's. No containers in this case.
Material A: 1 Pallet= 132 PC
Material B: 1 Pallet= 1600 PC
Material C: 1 Pallet= 3000 PC
Sample Drawing procedure:
1 to 2 pallet Sampling Quantity = 10
3 to 5 pallet Sampling Quantity = 20
6 to 20 Pallet Sampling Quantity = 30
>20 Pallet Sampling Quantity = 40
For the above case:
When we receive material A with 5 Pallets (Total Quantity 132*5 = 660 PC) then the sampling should be 20 PC
When we receive material B with10 Pallets (Total Quantity 1600*10= 16000 PC) then the sampling should be 30 PC.
So the sampling size needs to be calculated based on the number of pallets. Which type of sampling scheme do you suggest.
Thank you very much
Best Regards
Hari
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.