DM2
Mechanical
- Oct 20, 2007
- 147
I'm trying to write a formula in EXCEL that will tell me how much liquid CO2 I need, given the volume, and temperature of a particular space. I need this as part of another formula to resolve some quantity calculations for Fire Protection.
NFPA 12, Appendix D, offers the following formula that I'm trying to tweak in EXCEL:
[tab]X = 2.0303 (Log10[100/100-C])
[tab]Where:
[tab][tab]X = Volume of CO2 expressed in ft3
[tab][tab]C = Desired Concentration (usually 34%)
The result is ft3 so I then divide by 9 (i.e. 1 lb of CO2 expands to 9 ft3 at 86°F).
My problem is that this is based on the expansion of CO2 at 86°F at 1 atmosphere. The temperatures I'm dealing in range from 40°F to 400°F. Normally I won't worry about this due to how CO2 is packaged in cylinders (i.e. 25, 50, 75, 100, or 120lb capacity cylinders). The problem is I need to determine the leak rate from an opening and add CO2 accordingly. The added CO2 can vary anywhere from 1 to 30 lbs per minute over more than 20 minutes. If I can't get more accurate, I'll find myself adding several cylinders at a cost of $2,500.00 each (installed).
Does anyone know how I might modify this formula to allow me to insert different temperatures, and possible pressures?
Regards,
Dan
NFPA 12, Appendix D, offers the following formula that I'm trying to tweak in EXCEL:
[tab]X = 2.0303 (Log10[100/100-C])
[tab]Where:
[tab][tab]X = Volume of CO2 expressed in ft3
[tab][tab]C = Desired Concentration (usually 34%)
The result is ft3 so I then divide by 9 (i.e. 1 lb of CO2 expands to 9 ft3 at 86°F).
My problem is that this is based on the expansion of CO2 at 86°F at 1 atmosphere. The temperatures I'm dealing in range from 40°F to 400°F. Normally I won't worry about this due to how CO2 is packaged in cylinders (i.e. 25, 50, 75, 100, or 120lb capacity cylinders). The problem is I need to determine the leak rate from an opening and add CO2 accordingly. The added CO2 can vary anywhere from 1 to 30 lbs per minute over more than 20 minutes. If I can't get more accurate, I'll find myself adding several cylinders at a cost of $2,500.00 each (installed).
Does anyone know how I might modify this formula to allow me to insert different temperatures, and possible pressures?
Regards,
Dan