Question description:
This user has given permission to use the problem statement for this
blog.
I have something that is charged by units.
I have a total unit count (ie 100), but the dollar value is different for each unit length (ie 0 to 25, 25 to 50 etc) how do I create these different ranges from the original total?
Solved by M. C. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
25/03/2018 - 05:45
Welcome, Thanks for choosing Got It Pro-Excel
User
25/03/2018 - 05:48
how do i put a value in column E?
User
25/03/2018 - 05:50
Using the values for D1 and D2/
Excelchat Expert
25/03/2018 - 05:50
Thank you for such a good question.
Excelchat Expert
25/03/2018 - 05:51
Are we suppose to create different ranges from the original total?
User
25/03/2018 - 05:54
I know the final totals (D1 and D2) I know the ranges A5 to C7 and A11 to C17.
User
25/03/2018 - 05:55
I need to know how to calculate a value for D5 to D7 and D11 to D17
Excelchat Expert
25/03/2018 - 05:55
Alright, please give a moment to solve your problem. Thank you!
User
25/03/2018 - 06:01
are you still there?
Excelchat Expert
25/03/2018 - 06:01
Yeah, figuring out the problem. Is there something which you can add on the question?
User
25/03/2018 - 06:04
It is a diamond driiling program. First the drill casing to bedrock total = total casing is "D2" it is charged at 3 different rates. Then they start coring bedrock then it is charged at various rates.
User
25/03/2018 - 06:05
In the end I know my totals. Is it possible to calculate the amount of meters in each range from the total?
Excelchat Expert
25/03/2018 - 06:07
Yes it is possible.
User
25/03/2018 - 06:08
please explain how I may do it.
User
25/03/2018 - 06:08
Thank you
Excelchat Expert
25/03/2018 - 06:09
One way of solving this is solving the "What-if-Analysis"
Excelchat Expert
25/03/2018 - 06:10
We can collaborate online, but in order to work on a What-if-Analysis on this, then I have to work on this locally and send you a file.
User
25/03/2018 - 06:11
ok thanks, do you know how long this may take?
Excelchat Expert
25/03/2018 - 06:13
Yeah, before the session ends we will be in a position to provide you with the solution.
Excelchat Expert
25/03/2018 - 06:13
If analysis needs one to identify the conditions which are in the problem.
User
25/03/2018 - 06:14
one other little wrinkle. if they drill 18 meters of casing for example then under the coring the first from would be 18 not 0.
Excelchat Expert
25/03/2018 - 06:14
Okay. Kindly provide all such like conditions so that they are factored in Analysis.
Excelchat Expert
25/03/2018 - 06:15
This will help us to provide you with the most accurate solution. Thank you.
User
25/03/2018 - 06:15
that should be all the conditions.
User
25/03/2018 - 06:16
ie if they drill 18 m of casing and the final hole depth was 333m
User
25/03/2018 - 06:18
I would be charged 15m @ "H5" 3m at "H6", 132m at "H11" 150m at "H12" and 33m at "H13"
Excelchat Expert
25/03/2018 - 06:18
Good. In your Desktop application, What-If-Analysis is located in the Data tab, under the Data Tools Group. Click on the Seek Goal option.
User
25/03/2018 - 06:19
ok
User
25/03/2018 - 06:26
now what?
Excelchat Expert
25/03/2018 - 06:28
The conditions are not all. The values that are being returned are not equivalent with those in D1 and D2 i.e. for Final Depth and Casing.
Excelchat Expert
25/03/2018 - 06:29
Is it possible I can have the whole problem statement?
Excelchat Expert
25/03/2018 - 06:31
I apologize, I am unable to finish your problem since the conditions provided are insufficient.
Excelchat Expert
25/03/2018 - 06:32
Kindly provide the whole problem statement so that we are in the position to examine all the conditions. Thank you.
User
25/03/2018 - 06:32
I know my final depth of casing. I know the dollar value per depth range. I need to figure out how much meterage is in each range.
User
25/03/2018 - 06:34
Then I know my total depth of coreing which is the total - casing and again I I know the dollar value per depth range. I need to figure out how much meterage is in each range.
User
25/03/2018 - 06:35
Then I will be able to times the meterage by the dollar value and and get my total costs per rang. I can then ads these up and I will have my total costs.
User
25/03/2018 - 06:39
no luck?
Excelchat Expert
25/03/2018 - 06:40
Since the information you have added was not there initially, the session will end automatically before we factor it in the solution. I kindly request you to re-post the question with all the information and we will be in a position to help you.
Excelchat Expert
25/03/2018 - 06:41
We apologize for that. Your credits will not be deducted. Thank you for understanding.
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.
