10b Mon Feb 23 - Build PSS Forecast spreadsheet with max of 30 day pressure steps

pdf

School

Texas A&M University *

*We aren’t endorsed by this school

Course

416

Subject

Industrial Engineering

Date

Nov 24, 2024

Type

pdf

Pages

Uploaded by SargentTeamDugong21

Petroleum Engineering 416 Build a Spreadsheet to Forecast Production Using a Max of 30-day Time Steps to Increment Pressure Steps Texas A&M University 1

Here’s where we left off with our PSS Forecasting spreadsheet that used the Pseudo Steady State Flow Equation and a Natural Log Function to Increment Pressure Steps We calculated the Pressure steps using a natural logarithmic function in Columns A through D This worked well when all we were doing was plotting the data, etc. But, to get this information into an economic spreadsheet, we need to summarize volumes on a monthly basis 2

Off to the right in the Natural Log Function PSS Forecast spreadsheet, I added 4 columns to summarize the volumes into 30-day increments or 1 month increments. Our economics spreadsheet requires monthly volumes……. For simplicity, in this class, use 30-day months The problem with the way the PSS spreadsheet using a Natural Log Function to Calculate Pressure Steps is that the Incremental Time between pressure steps could be larger than 30 days making interpolating every 30 days less accurate. Notice how several months could be the same. It’s having a hard time interpolating. 3

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

So, I got rid of the old way of calculating pressure steps and invented a new one that pays attention to the Incremental Time to Reach pbar (Column M) All we are doing is changing the pressure steps, i.e., the frequency at which calculations are made. Notice the answers in the green cells do not change from the previous slide Delete the stuff that was in columns A, B, C, and D and change the way the Pressure Increment is calculated 4

Using this “New” method, I adjust the pressure increment in Cell F30, such that the Incremental Time in Cell M30 is < 30 days. My formula in Column F takes care of the rest. By doing this, there is always a unique place to interpolate at 30-day time increments Remember, a grey cell is Input 5

Formula for Cell F31 Hopefully, this formula will prevent the Incremental Time in Column M from being greater than 30 days. If you see numbers greater than 30 in column M, try making the pressure increment in cell F30 smaller 6

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Notice, that as the Incremental Time in Colum M approaches 30 days, the pressure increment in Column F is automatically cut in half Formula for Cell F34 7

Cell G29 is still the initial reservoir pressure 8

Cell G29 is still the initial reservoir pressure, but the rest of column G uses a different formula, for example for Cell G30 Cell G30 =MAX($J$17,(G29-F30)) Again, this is so pbar doesn’t go below the FBHP (pwf) in cell J17 9

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Here’s what my spreadsheet looks like at the end. Forecast to whenever you reach 14,400 days or an Average Reservoir Pressure equal to the Minimum Flowing Bottomhole Pressure for Your Case (In this example, the Minimum FBHP = 500 psi) Remember my formula for Column F Formula for Cell F384 =IF(G383=$J$17,0,IF(M383+(M383-M382)>28,MAX(0.1,F383/2),F383)) $J$17 is the Flowing Bottomhole Pressure Cell G383= MAX($J$17,(G382-F383)) 10

Use 30 days for 1 month, 12 months in a year Use Interpolation to get Cum Gas at a specific time 11

10b Mon Feb 23 - Build PSS Forecast spreadsheet with max of 30 day pressure steps

Related Documents