Material to study EPANET hydraulics

Hello,

I am a masters student in water resources. I have studied hydraulics for my curriculum. I want to understand how EPANET hydraulics work.

I learned how to solve a network in a spreadsheet by gradient descent method from here https://youtube.com/playlist?list=PLmWwzbjnLbQ0xc7AEPNe9SSS8407Fnwor.

I want to do the same for say PDA methods. I can replicate various methods from literature in EPANET, but not in the spreadsheet. Research papers explain the methodologies in matrice notations, which are difficult to follow.

Can anyone point me towards a course, a book or research paper? I tried Coursera, but it had none.

Thanks,
Bhargav.

You can find a step by step description of the EPANET solution algorithm, suitable to run in a spreadsheet (for small networks), at https://epanet22.readthedocs.io/en/latest/12_analysis_algorithms.html.