Hello All,
Good Day.
I am attaching below, two spreadsheets on calculation of Inbreathing and Outbreathing Requirements for Air/N2/Gas Blanketed tanks.
They follow API 2000 (7th Edition, 2014) requirements and guidelines and I have explained and illustrated the relevant calculations and the basis for them. I have input some sample values just for illustration.
I have also included the Control Valve sizing for the Inlet and Outlet PCV's of the tank.
For this, we first select a valve with a given Cv, based on a supplier. Then calculate the Cv based on flow conditions and compare if the Valve selected is suitable, if not, then we select the valve with the next largest Cv.
The ratio of the Calculated Valve Cv to the Selected Valve Cv gives the valve opening required.
I enjoy making spreadsheets in my free time and expanding my understanding of chemical engineering and my perspective of it. The very process of making the spreadsheet itself refines one's understanding of all the underlying concepts involved in the Process.
So, I would really love your feedback on the spreadsheets and any comments you have, additional data that can be added, and criticism.
The file is protected to prevent unintended changes but there is no password and the calculations are visible.
This spreadsheet has been made based on my understanding of concepts stated in references I have bought myself, so am not in violation of any Copyrights.
EDITED : There have been some updates made to the file though the calculations remain the same so please refer to the post below as well and please find the updated files attached.
Regards,
Shantanu
Attached Files
Edited by shantanuk100, 22 November 2015 - 11:39 PM.