Question description:
This user has given permission to use the problem statement for this
blog.
so im trying to find time out, and i realized it only works if i dont change the current number made, and keep it at 0. other than that, it works well. but i need to including current amount of chairs, so as the day goes along, it gives more accurate time out
Solved by G. Y. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
27/07/2018 - 06:41
Hello
Excelchat Expert
27/07/2018 - 06:41
How are you?
User
27/07/2018 - 06:43
im well
Excelchat Expert
27/07/2018 - 06:43
Nice to hear that
User
27/07/2018 - 06:44
so here, you see ive set up an example
Excelchat Expert
27/07/2018 - 06:44
Ok.
User
27/07/2018 - 06:44
im trying to get it, as i change the current chair, the time out doesnt change
User
27/07/2018 - 06:45
as i increase the chairs done, it decreases the time out which is what i dont want
Excelchat Expert
27/07/2018 - 06:46
Total number of chairs are fixed?
Excelchat Expert
27/07/2018 - 06:46
i.e. 1000
User
27/07/2018 - 06:46
built
User
27/07/2018 - 06:46
the schedule is how many we need to build, and current chair would be how many completed
User
27/07/2018 - 06:46
and chairs left is how many we still need to build
Excelchat Expert
27/07/2018 - 06:47
so for example you have built 50 chairs
Excelchat Expert
27/07/2018 - 06:48
Yes so the chairs left to be built are 950
Excelchat Expert
27/07/2018 - 06:48
so the time required to built would reduce for 950
Excelchat Expert
27/07/2018 - 06:49
Ok. I understand what you are looking for. You need to keep the clock for 1000 chairs but you want to keep increasing current chairs
User
27/07/2018 - 06:49
yes
User
27/07/2018 - 06:50
so if we run at 100% (usually do) the time to get out is 11:16 AM in this scenario.
Excelchat Expert
27/07/2018 - 06:51
=E3*B1/60
Excelchat Expert
27/07/2018 - 06:51
instead of this make it on B2
Excelchat Expert
27/07/2018 - 06:51
B2*B1/60
Excelchat Expert
27/07/2018 - 06:53
So E2 and F2 remains same
User
27/07/2018 - 06:53
alright :) so if we did end up running at say....98%, would i just add a % to it to calculate the remaining time?
Excelchat Expert
27/07/2018 - 06:54
where are you accounting for running 100% or 50%?
User
27/07/2018 - 06:54
100%, but sometimes we run at 98% if we have bad parts
User
27/07/2018 - 06:55
so like....if we ran at 98% that day, all day. instead of 100%
Excelchat Expert
27/07/2018 - 06:55
so if you run at 100% time to complete is 19 minutes
Excelchat Expert
27/07/2018 - 06:55
right
Excelchat Expert
27/07/2018 - 06:56
and if you will run at 98% it will take 19.93 minutes, right?
Excelchat Expert
27/07/2018 - 06:57
I would suggest to add another variable of efficiency
User
27/07/2018 - 06:59
alright. thank you :)
Excelchat Expert
27/07/2018 - 06:59
Since I made it fix to 19
Excelchat Expert
27/07/2018 - 07:00
so when efficiency is 100% it is 19 minutes
Excelchat Expert
27/07/2018 - 07:00
try it now by changing the efficieny
User
27/07/2018 - 07:01
that works :) thank you
Excelchat Expert
27/07/2018 - 07:01
My pleasure.
Excelchat Expert
27/07/2018 - 07:01
Please do provide good review.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
