skjoex
Have a look at the attached worksheet I think the program loop looks a lot neater.
I can’t understand why you want your answers separated by a comma!!!!!!
Regards
Mikehttp://files.engineering.com/getfile.aspx?folder=0404cf4c-a0cf-4058-bc74-33fb86af9b17&file=exmp3.mcd
See attached worksheet.
You haven't used any units through out your worksheet, why?
Do your pipes have an internal diameter of >6m.
I think the previous post has made an error as his head loss per meter seems too high.
There is also no need for all those vectorize functions, also see...
Something like attached.
The script can be changed to suit.
Regards
Mikehttp://files.engineering.com/getfile.aspx?folder=25261c8e-e17d-41d3-92dc-2a9afa1cf93f&file=Example.mcd