...
2. Build the calculation in layers adding each layer into the basket.
We know the calculation we want to do is:
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(tag0,tag0) (Temp Hot Inlet - Temp Outlet Cold), (Temp Outlet Hot - Temp Inlet Cold)
- Then THen add these two SUBS to the basket
- Create a new SUB(0,0) and drag each previos sub subtractions calculations into the new Sub Calculation to get SUB(SUB(0,0),SUB(0,0))
- Then add to the basket
- Create a new new calcualtion with LN(0) then add the SUB(SUB(0,0),SUB(0,0)) into the calculation
- Add Then add to basket
STEP 4 - USING YOUR CALCULATION
...