An API 610 Nozzle Loading Spreadsheet???

[JohnBreen]

Hey Y'all,

Has anybody ever gotten around to putting the calculations for the API 610 Standard into a spreadsheet? Seem like many similarly tedious tasks have gone that route so pehaps someone has already done it.

Just thought I would ask.

Regards, John.

 

[StressGuy]

I'm betting you're talking about the Appendix F calculation. I think I started to work on a spreadsheet one time. But, once I figured out that Caesar had it built in, I abandoned the effort.

Edward L. Klein
Pipe Stress Engineer
Houston, Texas

"All the world is a Spring"

All opinions expressed here are my own and not my company's.

 

[JohnBreen]

Hi Ed,

Yep, you got it, thoses are the calcs I want to "auto-mate". I am looking at MANY sets of analyses output from the archives (some were done with DOS programs) and I want to get a summer intern to run all the pump loads through a spreadsheet to see what the original margin was. Like you, I usually just add it to my C2 analyses but this is data that I don't have C2 models for.

Maybe developing the spreadsheet will be good training for her. She will have a chance to become more familiar with the Standard that way.

Regards, John.

 

[richay]

John,

You don't need to have a CAESAR II model, since the API-610 module is stand-alone. Just type in the numbers and you should be all set.

Richard Ay
COADE, Inc.

 

[JohnBreen]

Hi Rich,

Well, thanks for the reminder!!!

I don't know where my head was but I completely forgot that the C2 API 610 module was stand-alone. I did about 50 or 60 of the WRC nozzle load calcs with C2 and should have remembered that I could do the same thing with API 610 - and I am not even blonde!!! (if that l'il blonde Texan I'm married to saw that comment she'd put a wuppin on me).

Thanks to all for helpin' an ol' guy remember.

Regards, John.

 

[StressGuy]

John,

If you've got an engineering intern, I bet she's probably stronger at Excel than you or I (and I'm pretty strong, myself). I'd say hand her that Appendix F and she'll probably have a working spreadsheet in about and hour.

If's she's really strong, she could even input the basic table allowables and create a lookup table in the spreadsheet so you would only have to specifiy the nozzle size and the type of nozzle to get the allowables to compare to. That would take some more time to work out the logic, but it would give a completely standalone spreadsheet that you wouldn't even need the code to look up the numbers in.

Man, I wish I had time to do that myself. I like building spreadsheets like that. But, then again, I'm a geek

Edward L. Klein
Pipe Stress Engineer
Houston, Texas

"All the world is a Spring"

All opinions expressed here are my own and not my company's.

 

[JohnBreen]

Hi Ed,

That was my thought too! I know she is good with Excel (and surprisingly (age considered) good at focusing on finding clever solutions to lots of other challanges). So maybe I have her do a spreadsheet ("as an exercise") and check it via C2 calcs!? If it works out I will let you know.

Regards, John.

 

[richay]

And then send it to me too. I'm always looking for secondary verification tools.

Richard Ay
COADE, Inc.