Respected members,
I am a junior engineer and it was assigned to me that i calculate breathing capacities for PVRV's and emergency valves for 40 tanks(most of tanks were filled with fluids whom physical data and properties are not known or provided from client) and to verify vendor provided data to ensure that vendor quoted valve sizes & capacites are acceptable or not. I calculated breathing capacites as per API 2000 but i couldn't find any method to in API regarding valve sizing.
I continously follow this forum and learn alot always, in some of the threads it is mentioned that technical paper 410 is to be used for calculation of valve size etc etc. I still am unable to get the philosphy that how to utilize pressure drop function for valve sizing due to my lack of knowledge.
so after manually calculating the breathing capacities i thought to do these calculation in excel with my limited knowledge. During surfing internet i found a formula (stated below in red) but couldn't find any reference about this formula
kd =[ {(0.269906*(Outlet pressure/Inlet pressure)}^2-{0.751687*(outlet pressure / inlet pressure)+1.18178)}*0.95]
*outlet pressure/inlet pressure OR p2/p1 OR pressure ratio
It stated that dividing the total breathing capacity (i.e. inbreathing/outbreathing/Emergency) by kd to get therotical flow and i calculated back the area required to flow by the equation provided in API 2000 to calculate therotical flow.
My excel sheet is attached for your review, i utilized the same formula of kd and calculated valve size by calculating theoratical flow.
Being a process design engineer i have learned that never trust a told value, always calculate your own value so that you can prove how you do it, i am confused about presenting this sheet because this formula is not justified because i don't have any reference for this formula.
I thought it will be nice to have your opinion and suggestion about this problem of mine.
This excel sheet might seem bit odd due to my limited knowledge of excel and being inexperienced in making calculation sheets. And it would be very kind of you to spare your precious time to provide your comments about my problem and making this sheet more user-friendly.
Regards,
Ammad Khan