Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to create input boxes which enables user to input the value which would change the required and output quantities.
Eg:
Units/Hr. Expectation | 124 |
Hrs/worker = 8.5
Units to be completed | 78,998 |
No. of hours required to complete the available units = 78998/124 = 637.08
No. of workers required = 637.08/8.5 ~ 75
In the attached application,
i would like to allow user to enter the value for any of the parameters (units to be completed (or) hours req. (or) workers req)
so the user can see the pro rated values when one of the value is changed.
Any help is highly appreciated.
May be this:
='Units/Hr. Expectation | ' & vUnits & Chr(10) & |
'Hrs/worker = ' * vHours & Chr(10) &
'Units to be completed | ' & vWorkers & Chr(10) & |
'No. of hours required to complete the available units = ' & vWorkers & '/' & vUnits & ' = ' & Round(vWorkers/vUnits, 0.01) & Chr(10) &
'No. of workers required = ' & Round(vWorkers/vUnits, 0.01) & '/' & vHours & ' ~ ' & Round(vWorkers/vUnits/vHours)
May be this:
='Units/Hr. Expectation | ' & vUnits & Chr(10) & |
'Hrs/worker = ' * vHours & Chr(10) &
'Units to be completed | ' & vWorkers & Chr(10) & |
'No. of hours required to complete the available units = ' & vWorkers & '/' & vUnits & ' = ' & Round(vWorkers/vUnits, 0.01) & Chr(10) &
'No. of workers required = ' & Round(vWorkers/vUnits, 0.01) & '/' & vHours & ' ~ ' & Round(vWorkers/vUnits/vHours)
That's perfect sunny.
I was doing some error in Round () and calculation.
You nailed it
Thanks again.