for liquid flow here is an Excel file in comma delimated format. Copy and save this as orifice.csv then open with Excel
Remove the " from around the formula and it should work. (the numbers in the column next to the formula are the results with the given example.)
--- PROGRAM BEGINS FOLLOWING THIS
ORIFICE PLATE SIZING FOR LIQUID FLOW,,,,,,,,,
"Tung and Mikasinovic, Chemical Engineering, Dec 12, 1983 p 69",,,,,,,,,
K vs beta correlation by JNS,,,,,,,,,
,,Find orifice size,,,,,Find pressure drop,,
Input Data,,,,,,,,,
,Flow rate,USgpm,,15,,Flow rate,USgpm,,15
,Fluid SG,,,1,,Fluid SG,,,1
,Pipe ID,in,,1.5,,Pipe ID,in,,1.5
,Press. drop,psi,,32,,Orifice dia,in,,0.375
Result,,,,,,,,,
,Orifice dia,in,"""=E10*E19""",0.374,,Press. drop,psi,"""=J19/144""",32
Calcs,Vel,fps,"""=(E8/7.5/60)/(PI()*((E10/12)^2)/4)""",2.716,,Vel,fps,"""=(J8/7.5/60)/(PI()*((J10/12)^2)/4)""",2.716
,Density,pcf,"""=E9*62.4""",62.40,,Density,pcf,"""=J9*62.4""",62.40
,Press drop,psf,"""=E11*144""",4608,,beta,,"""=J11/J10""",0.250
,K,,"""=2*E17*32.2/E15^2/E16""",645,,k,,"""=1.64863*(1/J17^4.29881)""",639
,beta,,"""=(1.64863/E18)^(1/4.29881)""",0.249,,Press drop,psf,"""=J18*J16*J15^2/2/32.2""",4566
--- END OF PROGRAM
lET ME KNOW IF YOU NEED A SPREADSHEET FOR GAS SIZING