Keegan4123
New Member
- Joined
- Mar 30, 2022
- Messages
- 29
- Office Version
- 2016
- Platform
- Windows
I am trying to build a calculator for a common task that calculates the required amount of fluid needed in a mixture to achieve the desired temperature.
Issue I have is the chemistry formula solves for 1 variable, but I need to solve for 2. There can only be 2 exact numbers given the variables, so not sure how to build the forumula.
Known Values
temp1 30.00
temp2 50.00
tempfinal 37.50
massttotal 36.00
Unknown Values
mass1 ??
mass2 ??
Total 36.00
Single Mass Formula m2 = m1 (T1 - Tf) / (Tf - T2)
or
m1 = m2 (T2 - Tf) / (Tf - T1)
Issue I have is the chemistry formula solves for 1 variable, but I need to solve for 2. There can only be 2 exact numbers given the variables, so not sure how to build the forumula.
Known Values
temp1 30.00
temp2 50.00
tempfinal 37.50
massttotal 36.00
Unknown Values
mass1 ??
mass2 ??
Total 36.00
Single Mass Formula m2 = m1 (T1 - Tf) / (Tf - T2)
or
m1 = m2 (T2 - Tf) / (Tf - T1)
Book1.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Known Values | |||||||||||
2 | t1 | 30.00 | Single Mass Formula | m2 = m1 (T1 - Tf) / (Tf - T2) | ||||||||
3 | t2 | 50.00 | or | |||||||||
4 | tf | 37.50 | m1 = m2 (T2 - Tf) / (Tf - T1) | |||||||||
5 | mt | 36.00 | ||||||||||
6 | Calculated using above formula | M1 | 13.5 | |||||||||
7 | Unknown Values | M2 | 22.5 | |||||||||
8 | m1 | 13.50 | ||||||||||
9 | m2 | 22.50 | ||||||||||
10 | Total | 36.00 | ||||||||||
11 | ||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J6 | J6 | =B9*(B2-B4)/(B4-B3) |
J7 | J7 | =B8*(B3-B4)/(B4-B2) |
B10 | B10 | =SUM(B8:B9) |