Need formula to calculate total units for one hour.
[TABLE="width: 396"]
Min Per hour
[/td]Process time
[/td]Wafers
[/td]Unit Per Hour
[/td]60
[/td]0:36:00
[/td]25
[/td]60
[/td]0:15:00
[/td]25
[/td]60
[/td]1:00:00
[/td]25
[/td]
[/TABLE]
Need formula to calculate total units for one hour.
[TABLE="width: 396"]
Min Per hour
[/td]Process time
[/td]Wafers
[/td]Unit Per Hour
[/td]60
[/td]0:36:00
[/td]25
[/td]60
[/td]0:15:00
[/td]25
[/td]60
[/td]1:00:00
[/td]25
[/td]
[/TABLE]
Re: Calculate productivity in time basis
Explain your logic if you were to do this manually with pen and paper.
Re: Calculate productivity in time basis
Try this...
[Table="width:, class:grid"]
[/td][td]
A
[/td][td]
B
[/td][td]
C
[/td][td]
D
[/td][td]
E
[/td][/tr]
1
[/td][td]
Min Per hour
Process time
Wafers
Unit Per Hour
[/td][/tr]
2
[/td][td]
60
0:36:00
25
3.6
41.66667
[/td][/tr]
3
[/td][td]
60
0:15:00
25
100
[/td][/tr]
4
[/td][td]
60
1:00:00
25
[/td][td]
25
[/td][/tr]
[/table]
D2=1/24/B2*C2
copied down
Re: Calculate productivity in time basis
Hi,
Yes, this is what I want.
Thank you.
Re: Calculate productivity in time basis
Glad to help
Don’t have an account yet? Register yourself now and be a part of our community!