Temperature Drop through Insulated Pipe (Steady State) This VBA function/Excel tool calculates the temperature drop through a pre-insulated buried single steel pipe (steady-state).