The Excel file calculates friction loss (by Hazen-Williams formula), pressure loss or gain due to elevation change, also helps to find equivalent K Factor, and Equivalent length of fittings based on C factor or internal diameter of the pipe. This file is applicable for Tree piping.