I am confused between using a correct correlation for determining pressure drop for Compressible Fluids.
1. I have seen people using Darcy Weisbach for compressible too

this is only good if Dp is less than 10% (GPSA_Section 10).
2. Some recommend Panhandle & Weymouth 's correlation which is easy but inaccurate too.
3. Some use Fline Software method based on Adiabatic rather than Isothermal Pressure drop.
4. ProII gives you Beggs-Brill, Dukler Eaton, Oilmens, Mukerjee-Brill, Gray or Hagedorn Brown Correlations.
Now which one is correct (or more realistic). I have a huge network for which I am planning to incorporate piping details in an Excel Spreadsheet to have it done in 1 go (I know it would be numerous iteration across each pipe segment before it reaches the final solution).
little help would be appreciable.
Thanks.