Firefighting Network Calculation

I need an extension of a firefighting network for six buildings. You will need to calculate flowrate and pressure for additional hydrants using Excel macros.

Requirements:
- Model flowrate and pressure
- Add hydrants to existing network
- Provide results in Excel macros
- Detailed report with explanations

Ideal Skills:
- Proficiency in Excel macros
- Experience with firefighting network modeling
- Knowledge of hydraulic calculations

Size of the existing network:
- 37 piping routes
- 35 nodes
- 1 source