Pressure in a Sphere?

This may get you started on your quest for learning.

If however,you want a cut-and-paste solution,I will not be helpful.

http://www.ar.cc.mn.us/chemistry/Chem1061/Labs/GasLaws/GasLaws-vm.pdf

If temp is constant, each added volume of V raises the gauge pressure by 0.1469 V psi.

Given constant volume (V), pressure (P) in your sphere is proportional to the product of the amount of gas inside (nR) and the temperature (T).

PV=nRT or P=nRT/V

In answer to the original question, yes, of course it can. If the question can be put into a formula, and if a set of parameters are supplied, then an if-then statement can be used in Excel to read in each set of parameters, apply the formula, and output the result. The final result of all of this is a table of data. So again, yes, of course it can.

The way I thought of the problem was to consider the initial volume plus the added volume as the starting point and then calculated what the change in pressure would be assuming 14.7 psi atmospheric pressure initially and then calculate the increased pressure reducing the volume to in initial volume and then subtracting the initial atmospheric pressure: Below is how I arranged the problem in Excel:

You can change the initial and added volumes or even the initial pressure and get the change in pressure in the container you're using. Of course this assumes no change in temperature. Being somewhat lazy I try to avoid the nRT calculation because I have to look up too many things; for instance if you added a gas other than air you would then have to do the calculations using the nRT thing to take both gases into account.

Hope this helps...

From physics textbooks the excess pressure in a bubble is 2 times the surface tension divided by the radius. For something other than a bubble, the tensile properties of the material containing the gas can be substituted for the surface tension criterion. One must take into account that putting more gas into a fixed volume increases its temperature as well as the pressure according to the characteristics of the particular gas or mixture of gases. The properties of the containing material will vary with temperature as well.

Of course <...excel...> can do the calculation, as can a pocket calculator, a slide rule, a set of log tables or manual arithmetic! However, getting the mathematical model of the physical conditions right is fundamental to avoid GIGO, whatever calculabe is eventually employed.

...and throw in the effect the removal of air from outside the vessel has on the external pressure.....and being ultra fussy any heat flow across the walls to equalize temperature...

PV = NRT is near enough for me.....confirming #2, #3 and #4

Quite.