...
LMTD = ((Temp Hot Inlet - Temp Outlet Cold) - (Temp Outlet Hot - Temp Inlet Cold)) / LN ((Temp Hot Inlet - Temp Outlet Cold) - (Temp Outlet Hot - Temp Inlet Cold))
DIV(SUB(SUB(0,0),SUB(0,0)),LN(SUB(SUB(0,0),SUB(0,0))))
To build this calculation in layers we are going to work in steps
- Create the two most low level subtractions SUB(0,0) (Temp Hot Inlet - Temp Outlet Cold), (Temp Outlet Hot - Temp Inlet Cold)
- Then add these two SUBS to the basket
- Create a new SUB(0,0) and drag each previos previous subtractions calculations from the basket into the new Sub Calculation to get SUB(SUB(0,0),SUB(0,0))
- Then add to the basket
- Create a new LN(0) and Drag the SUB(SUB(0,0),SUB(0,0)) into the calculationcalculation from the basket into it
- Then add to basket
- Now its Time to create the final calculation. We have created the numerator and denominator of the calculation.
- Numerator = SUB(SUB(0,0),SUB(0,0))
- Denominator = LN(SUB(SUB(0,0),SUB(0,0)))
- Create a DIV(0,0) and Add Both the Numerator and Denominator into calculation from the basket.
- Now you have created the calculation
STEP 4 - USING YOUR CALCULATION
...