Flange Factors (VIII-1, App. 2)

[Cobra17]

Just curious if anyone knows if there is a source that has Figures 2-7.2 , 2-7.3, 2-7.4, 2-7.5, 2-7.6 in table format? I use the long equations in excel, but I'd like to use lookups to reduce space

 

[Christine74]

All the necessary formulas are right there in Table 2-7.1.

The formulas are pretty complex (needlessly complex in my opinion) so you might want to check if somebody's already prepared a similar spreadsheet and posted it online.


-Christine

 

[Cobra17]

I have the formula working in my spreadsheet, I just want to reduce the complexity by using a table lookup.

 

[Christine74]

Sorry I misunderstood. I don't know of any source that has those charts in tabular form, but if you've already built all the formulas into Excel you populate your own tables and then use VLOOKUP to extract values.


-Christine

 

[Cobra17]

I started to do that, then changed my mind and put the formula's into a UDF (User Defined Function), it does all the math in my macros.xlam and returns the value for F, V and f as things are changed. Keeps my job workbook nice and clean.