equation with 2 unknown values
Sorry for the bother, but I really need your help.
I need the excel formula for my equation.This is the scenario...
I run from "A" to "B" with a total of 288000 rpm in 3000 minutes
Now for example I want to run the same distance(288000 rpm) within the same
total running time(3000minutes) at 2 different set of rpm let's say I want to run for a certain tIme (unknown value 1) at 88 rpm and for a certain time (unknown value 2) at 105 rpm, after how much time I should change my speed from 88 to 105 in order to arrive always within the 3000 minutes Total time ?
Thanks a lot in advance for your assistance
equation with 2 unknown values
This is task for Solver Add-In. In Excel create table like this:
rpm min total rpm
88 rpm* min
105 rpm * min
total sum sum
In Solver set target value for sum of minutes 3000, with constraints like this: total rpm=288000, and changing cells are min (for 88 rpm) and min (for 105 rpm).
Result is like this:
rpm min total rpm
88 1588,25 139766,30
105 1411,75 148233,70
total 3000,00 288000,00
So, you need to drive at 88 rpm for 1588,25 minutes, then to change to 105 rpm and drive for 1411,75 minutes. Thus, you will drive for 3000 minutes, with total of 288000 rpm.
Are you satisfied with this solution?
Are you satisfied with this solution?