Develop a spreadsheet to implement pump affinity laws. The spreadsheet should calculate Q$,$ H and BHP values for alternate rotational speed $($ N $)$ and alternate impeller diameter $($D$).$

Given a Goulds Model $10$DXC pump curve, use the spreadsheet to develop an alternate pump curve for a rotational speed of $1850$ RPM$.$ Show results in tabular and graphical form.

MODEL $10$DXC

$($Effective July $17,2019)$

Vertical Turbine Pump

$\backslash$table$[[$Model$,10$DXC$],[$RPM$,1770],[$Freq I Poles,$60Hz||4-$pole$],[$Pump Type,Lineshaft$],[$EFFICIENCY CORRECTION$],[1-$STAGE,$0\mathrm{.}0],[2-$STAGE,$0\mathrm{.}0],[3-$STAGE,$0\mathrm{.}0],[4-$STAGE,$0\mathrm{.}0],[$Impeller Type,Enclosed$],[$Ns$,3105],[$Thrust K$-$Factor,$14\mathrm{.}00l\frac{b}{f}t$