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]
Calculate productivity in time basis
-
-
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...
[tr][td]
[Table="width:, class:grid"][/td][td]
A
[/td][td]
B
[/td][td]
C
[/td][td]
D
[/td][td]
E
[/td][/tr]
[tr][td]1
[/td][td]
[/td][td]Min Per hour
[/td][td]Process time
[/td][td]Wafers
[/td][td]Unit Per Hour
[/td][/tr]
[tr][td]2
[/td][td]
[/td][td]60
[/td][td]0:36:00
[/td][td]25
[/td][td]3.6
41.66667
[/td][/tr]
[tr][td]3
[/td][td]
[/td][td]60
[/td][td]0:15:00
[/td][td]25
[/td][td]100
[/td][/tr]
[tr][td]4
[/td][td]
[/td][td]60
[/td][td]1:00:00
[/td][td]25
[/td][td]
25
[/td][/tr]
[/table]
D2=1/24/B2*C2
copied down -
Re: Calculate productivity in time basis
Glad to help
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!