Forum Discussion
Assistance Creating a Custom Formula
Hey All,
I want to create a formula that automatically calculates based on variables being changed The formula is below:
180lb user outputting 200 Watts:
Convert patient weight to kg: 180/2.2 = 81.82kg
Convert watts to kcal/min: 200 x 0.0143 = 2.86 kcal/min
Convert kcal/min to litres O2/min: 2.86 kcal/min / 5.05 kcal/L O2 = .567 litres O2/min
Convert liters O2/min to ml/kg/min: .567 litres O2 x 1000 mL litre = 567 mL
567mL/min / 81.82kg = 6.93 O2/kg·min
Convert mL O2/kg·min to METs: 6.93 O2/kg·min / 3.5mL/kg/min = 1.98 METs
5.05 kcal/L O2, 1000 mL litre, and 3.5mL/kg/min are all "constants" Ideally would love a way to calculate this in a form type of setting when it automatically computes the end result.
1 Reply
- You just need to put your variables into cells values and make a formula accordingly using your different constant values (as per output unit)
Lets say to convert Lbs to Kg
A2 its a variable where the user will input the weight in Lbs
=A2/2.2
By the way, there is a formula that can convert a lot of different units
CONVERT(Number,FromUnit,ToUnit)
