Here's a program I wrote almost 10 years ago to help project engineers size pumps. I've used this successfully to size about 50 pumps.
I suggest you make an extra copy in case you scramble something.
The instructions are simple. The yellow cells are entries. There are sheets attached for physical properties and calculating K for the fittings. The program estimates motor efficiencies using information I collected from Pacific Gas and Electric. Hydraulic efficiency is either an entry or can be estimated using equations from Chemical Engineering Progess (CEP) and the Hydraulic Institute. You will see that it presents the information in a single cut sheet. Sheets are available for the two types of pumping configurations: suction lift and suction head. For the later, there is a static head to compensate for the losses to the pump eye. Choose the sheet based on configuration.
This program will work for slurries, laminar flow, etc., assuming the fluid will flow.
There are a few assumptions about the Ks for various fittings but these are unavoidable.
Use at your own risk.
Dirk Willard