Speed-Talk is running on www.Speed-Talk.com

IMPORTANT: Update your bookmarks to https://www.speed-talk.com/forum/
(Right-click the URL and select "Bookmark this link")

Spreadsheet CFM numbers HELP!

Tech questions that don't fit above forums

Moderator: Team

Post Reply
Roy
New Member
New Member
Posts: 34
Joined: Mon Oct 21, 2019 5:36 pm
Location:

Spreadsheet CFM numbers HELP!

Post by Roy »

Having issues setting up a spreadsheet so that I can measure at say 40 inches of water and have CFM results corrected to another standard (in this case 28". Cannot for the life of me figure out what I'm doing wrong. ](*,)

cell C23 =IF(E110>0,(Choose(D110,$D$72,$D$73,$D$74,$D$75,$D$76,$D$77)*E110)*$H$6, )
(wanting the cell to only show a value if theres data, otherwise all the columns say error when I print it out. Not very professional)
IF(measured percent>0,(Choose (Measured scale, corrected to measured scale 1,2,3,4,5,6)*Measured percent)*Correction factor for desired pressure

E110 is the cell I input the percentage of flow from the meter

D110 is the cell I input the range I am running

D72 through D77 =(($H$4/25)^0.5)*B72 through B77.
((Measured @ pressure/OEM scale pressure)^.5)*oem flowbench 100% numbers

H4 is the cell I specify what the flow is MEASURED at.

B72 through B77 is the OEM flow calibration numbers at 25"

H6 =(H5/H4)^0.5
(Chart pressure/Measured pressure)^.5

H5 is the cell I specify what I want the chart to show flow at.

So in short (or long...)

IF(<Logic>measured percent is greater then 0,<value if true>Choose(<# representing which choice>Flow scale,<Choice 1,2,3 etc is returned, in this case a variation of>((Specified measured pressure/oem chart pressure)^.5)*oem chart flow value at specified scale)*Flow percentage from meter*((Chart pressure/measured pressure)^.5)

When I change the measured at pressure my numbers don't change so I KNOW I have something screwed up but after 3 hours I still have no clue. When someone points it out I know its something with my math cancelling out because I have it wrong.. I also kknow its wrong because below .100 lift I am exceeding the DC by a fair amount, but If I return to my old spreadsheet which I only measured at 28" and charted at 28" It falls back in line. Please be gentle, I am not an expert in this one bit..
User avatar
Stan Weiss
Vendor
Posts: 4219
Joined: Tue Feb 20, 2007 1:31 pm
Location: Philadelphia, PA

Re: Spreadsheet CFM numbers HELP!

Post by Stan Weiss »

I am not sure I understand how it should work. But see if this does it.

Stan
Roy.xlsx
You do not have the required permissions to view the files attached to this post.
Stan Weiss/World Wide Enterprises
Offering Performance Software Since 1987
http://www.magneticlynx.com/carfor/carfor.htm
Do you use engine simulation software that uses cylinder head flow files?
We have a package of more than 3025 DFW/FLW Files
Post Reply