Yea, friction losses for viscous fluids is a different process, but I figured that would help to at least show you the general viscinity you are in. A specific gravity of 1.53 is not that much more than water, relatively speaking.
Here's a link that shows you the expected losses in sch. 40 pipe for various viscous fluids. 50.97 CentiStokes is roughly 260 SSU (
conversion), so bear that in mind when looking at the lines.
Viscous Fluid Friction Losses
I have a fluid dynamics program for process plants, running a quick simulation put it in the 130 gpm range. Some online calculators suggest around 100 gpm. When I said significantly higher, I didn't mean that it would be like 600 gpm, I just mean that it was a measurable and physically significant difference.
The thing to take from this, though, is that if you are going to use the method you used. What you want to do is make an initial guess (say 81.5 gpm) and figure out what the discharge pressure is. In this case you got over 7 psi. So you know your flow is too low. So you increase it to 150, you'll get a negative pressure, so it's too high. Keep doing these iterations, with logical progressions, and you will hone in on the correct answer.
Or, you can use the Darcy-Weisbach equation and do all the math:
Helpful link on that
However, because you don't know the flow, this becomes an iterative process for you anyway...
The table you are referring to likely used the D-W equations.
Unluckily for you, this scenario seems to be in the transition zone (Reynolds number in the 2000's), making an accurate calculation using the D-W equation difficult.