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][/td][td]
[Table="width:, class:grid"][/td][td]A
[/td][td]B
[/td][td]C
[/td][td]D
[/td][/tr]E
[tr][td][/td][td]1
[/td][td]Min Per hour
[/td][td]Process time
[/td][td]Wafers
[/td][td][/td][/tr]Unit Per Hour
[tr][td][/td][td]2
[/td][td]60
[/td][td]0:36:00
[/td][td]25
[/td][td]3.6
[/td][/tr]41.66667
[tr][td][/td][td]3
[/td][td]60
[/td][td]0:15:00
[/td][td][/td][td]25
[/td][/tr]100
[tr][td][/td][td]4
[/td][td]60
[/td][td]1:00:00
[/td][td][/td][td]25
[/td][/tr]25
[/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!