undersize assessment

ucesmik

New member
Joined
Sep 12, 2014
Messages
2
Reaction score
0
Points
0
Dear All,
Please can you assist amendment to equation in column F so that I can get same answer with equation in column F to desired answer manually inserted in column G
Thanks in advance
Ijaz
 

Attachments

  • excel spreadsheet equation.xlsx
    14.6 KB · Views: 19

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Please describe the logic that is to be used to get those desired results.
 

WizzardOfOz

New member
Joined
Sep 4, 2013
Messages
184
Reaction score
0
Points
0
Location
Australia
Excel Version(s)
Office 365
If you look at your column H and I you will note that there is a perfect linear correlation with
Flange diam = 0.915497124 * Velocity + 0.173924952 and I suggest this is the formula that you are wanting.
Secondly your "suggested answer" column G is wrong, you are merely showing the nearest velocity in your lookup table.
Warning a simple lookup is not going to give you the correct answer as what you are wanting is which item in Col H is closest to Col C. As an example 460 is closest to 500 then 400 but lookup will return 400 (>= but < next)
 

ucesmik

New member
Joined
Sep 12, 2014
Messages
2
Reaction score
0
Points
0
Many thanks, your suggestion is highly appreciated
 
Top