Extrapolation Method

[BJW75]

I inherited some reports where we are calculating lost yield. We currently use a formula converting the minutes of sampling into the hours worked as a percent. The weight found as a loss is then summed for the shift and then divided by this percent. This does not seem correct, but I am having trouble finding a better method, as we do not have a theoretical loss to calculate yield loss based on theoretical to experimental findings.

Any ideas?

 

[Joe4]

Welcome to the Board!

Any ideas

Possibly. But your question is pretty vague/generic.
I think you may have better look if you could post an example for us, along with some expected results regarding what you are looking for.

 

[BJW75]

Thank you. I have included the formulas and table sample format below for better explanation.

​	Hours worked per day	10​	0.83% ‘% inspct	=MIN /(HRS*60)
​	Total Min of Waste Insp	5​		​
Waste​	Sums of QC data​	Calculated Tonnage​		​
Widgets <1”​	23.90​	55.00​		​
Waste widgets​	13.86​	27.00​		​
Machining xs scrap​	3.36​	15.00​		​
Burrs/gores scrap​	3.67​	5.00​		​
Inspections Total​	44.78​	102.00​		​
Day​	6447.96 =IFERROR(total/ % inspected)​	14,688.00 =IFERROR(total tonnage/ % inspected)​		​

 

[Joe4]

Sorry, I have been away for a while, and just getting back now.

Not sure if I am the best person to help with this. But I am curious. I am looking at your chart, and I am not too sure what I am looking at, or at least how it relates to your problem.
You might need to explain how it all ties in to your problem, and what hope/expect to get out of it.
Maybe someone who has some experience in this arena will see it and be able to provide some suggestions.