Charting PSI to CFM - Help!!?

Question

I work for a graphic equipment supply company that sells dry vacuum/pressure pumps and I have to create a chart at work, using Excel. On the (X) axis, it will be PSI (pounds per square inch/measurements 1.38 to 8.50) and on the (Y) axis, it will be CFM (cubic feet per minute/measurements from 0 to 500 with) . What formula do I use? For example, my PSI is 1.38...how do I figure out the CFM? Am I looking at the information the wrong way? Any help would be appreciated. I am really behind deadline

Answer 1

You will need to list the actual performance
figures of the pump.
They should have been supplied to you to
complete the task.
(That should extend your deadline a bit.)

Answer 2

P + (1/2)ρv² + ρgh = k
Q = ρAv
P + Q²/(2ρA²) + ρgh = k
Q = A√(2ρ(k - ρgh - P))

A and k will be unique to the model with which you are working. An alternative is:

P1 + Q²/(2ρ1A1²) + ρ1gh1 = P2 + Q²/(2ρ2A2²) + ρ2gh2
Q²(1/(2ρ1A1²) - 1/(2ρ2A2²)) = (P2 - P1) + g(ρ2h2 - ρ1h1)