Excel spreadsheet for calculating pressure drop in pipes

Build an Excel spreadsheet with SI figures, using the Hazen-Williams equation (it's on wikipedia) to calculate pressure drops in pipework systems. Users can select flow rates, maximum pump pressure available, pipe sizes, materials, and common fittings via dropdowns. Default values are provided for quicker calculations. Numerical fields allow specification of pipe length, number and type of fittings, and up to 5 reductions in pipe sizes and associated fittings. The options to use more than one pipe size should be via a dropdown to hide unrequired data inputs. The spreadsheet outputs the total pressure drop across the system and the maximum pipe length supported given the input pressure. We will supply the various constants and ratios that will be used in the back-end for the calculations. there will be a maximum of 12 different pipe sizes, 4 different materials, and 6 different fitting types. Video calls are suggested to fine-tune the project.