We built a solution in Excel to automate the drafting of AFEs for oil & gas projects. This solution gives the user a method for entering values for each well individually or entering values for a number of wells at the same time. Entering values individually is useful for wells with a unique pricing scheme. Entering values for a number of wells at the same time is useful for inputting a whole pad at once or if an item's price changes and the user needs to go back and redraft past AFEs. The file also saves all previous inputs to a 'database' sheet.
Once inputs are made, any number of wells can be chosen to generate the AFEs for. With the click of a button, the inputted price scheme values are taken and run through calculations in the background. Then, for each well, a new excel file is created with the calculated values in an AFE format. The calculated values are also saved to a PDF file in the AFE format. The VBA code finishes by opening a file explorer window for the user to view the generated Excel and PDF files.
This solution is especially helpful when a price changes. For example, if the snubbing unit day rate is reduced by $2000/day for the foreseeable future, we can save a lot of time on redrafting AFEs. Instead of going back to each AFE file individually to change the value and reprint with the new total, we can simply open our database sheet and change this value for each well by clicking and dragging. Then, to recalculate we just click the button and generate the new AFEs. This process could take as little as 5 minutes compared to as many as a couple days without our solution.
TL;DR: VBA code pulls inputs then calculates outputs generated into AFE format for an unlimited number of wells
Time Saved by Millstream Solution: 30 minutes/well
Key Words: Visual Basic for Applications (VBA), Microsoft Excel, Automation