Dear blvn,
yuo've done a huge quantity of calculations that, at least, demonstrates passion and perseverance, essential things for a good trainee.
You should now look at some other aspects, in order to make clearer to your coordinator that you'll be a good engineers that, in the near future, will help him in saving time...
My (initial) suggestions (trying to expand the right advices of Zauz & Bobby):
1) you're working on two different items: a ) pressure drops in lines, b ) pump calculations. You can think I'm joking, but two good spreadsheets (and the relevant clear procedures) for these two items are the solid foundations of a good process department in a good engineering company. So, try to clearly separate the two items.
2) don't use the "scientific" notations in a spreadsheet but utilize simpler "engineering" notations (eg m3, not m3....). You'll save time and the spreadsheet will be clearer, saving the time of your coordinator. Moreover, formulas shall be reported for quality reasons, but they shall not be too many (if you need a lot it is better to separate them in a page of procedure).
3) a similar engineering/clever approach shal be applied to: a ) number of shown significant digits; b ) number of void rows. Both shall be minimized.
4) use the correct unit of measures and their symbols (eg m, not mtr; absolute and relative pressures shall be clearly indicated by a and g)
5) put a clear and simple but exhaustive sketch of the circuit at the top of the pump calculation spreadsheet; ISOMs & GAs shall be in your documentation
6) whenever you study an existing pump you shall obtain its original/updated data sheets and the relevant characteristic curves (flow vs H, NPSHR, eff, absorbed power. Design figures should be integrated by field data, according to Zauz post. Your assumption about efficiency is very poor: if you don't have the eff/abs power curve, try to find/utilize a published correlation (vs H and Q)
7)......
Good luck!
Edited by gegio1960, 24 April 2017 - 12:50 PM.