Uggg, still can't get it.
Yes, I could use pressure drop, but I want my spreadsheet to do the calcs as then I don't need the app, and I can also include my own stuff.
Cross referencing the application (not reverse engineering) I have all the same numbers for dyn viscosity, density and I have triple-checked my conversion from Pascal to mH20.
Still not right.
The app takes friction into consideration, whereas my spreadsheet doesn't, but the spreadsheet is returning numbers 1/10th mine.
I mean, the equation is:
delta Pressure = ( Density/2 ) * ( v2^2 - v1^2 )
Me and the app agree density = 998.2 kg/m3
Me and the app agree dyn viscosity = 0.001002
Me and the app agree v2 = say, 9m/s
I thus get 40427.1 pascals.
Conversion factor is 0.000102 mH20 per Pascal
Hence 4.12 m of head.
The application (with zero roughness) gets 0.05 "bar", which converts to 0.5m of head using the apps own calculator. Obviously I'm wrong as none of these blocks could work if they were as restrictive as my calcs, but I am blind to my mistake....
Uggg, where am I going wrong?