Sorry
@tursiops but I'm just following the GUE Min gas CAT formula. Would I be correct in that at least?
And I'm just showing for reference that's all.
I tell you what... I will change the AL80 to the actual CF and see what turns up.
So your CAT is Consumption * Average ATA * Time. OK.
You say your consumption is 2+0.75=1.5 cuft/min. OK.
You say your average ATA is (use 100 ft) 50/33 + 1 = 2.515. OK.
You say your time is 1 + 100/10 = 11 mins. OK
So CAT gives 41.58 cuft. OK. (you said 41.25, but that is because you used 2.5 for the Average ATA.
Now, what do you do with the 41.58?
You
should then calculate 41.58/77.4 * 3000 = 1612 psi, the gas you need to surface.
Then you round up to 1700, per GUE dictums.
I have made exactly that calculation here, except not the roundoffs until the end. All the steps are shown so you can see where everything is coming from.
depth | avg depth | avg ATA | time | 2*SAC | CAT | AL80 | Tank PSI | MINGAS | Roundup |
30 | 15 | 1.45 | 4.0 | 1.5 | 8.727 | 77.4 | 3000 | 338.3 | 500 |
40 | 20 | 1.61 | 5.0 | | 12.045 | | | 466.9 | 500 |
50 | 25 | 1.76 | 6.0 | | 15.818 | | | 613.1 | 700 |
60 | 30 | 1.91 | 7.0 | | 20.045 | | | 777.0 | 800 |
70 | 35 | 2.06 | 8.0 | | 24.727 | | | 958.4 | 1000 |
80 | 40 | 2.21 | 9.0 | | 29.864 | | | 1157.5 | 1200 |
90 | 45 | 2.36 | 10.0 | | 35.455 | | | 1374.2 | 1400 |
100 | 50 | 2.515 | 11.0 | | 41.500 | | | 1608.5 | 1700 |
The Excel formula for MINGAS is: =F2/$G$2*$H$2.
For you Excel buffs, the roundoff formula is:
=IF(ROUNDUP(I2/1000,1)*1000<500,500,ROUNDUP(I2/1000,1)*1000)