Hello All!
I am trying to write a macro that makes changes to the dates of existing cases based on the available number of rigs. For example,
I have a spreadsheet with a list of 1000 cases (aka wells) that start on a particular date
Start Date
Case 1 5/1/2016
Case 2 6/1/2016
Case 3 7/1/2016
Case n 8/22/2025
I want to create a macro that drills the cases (aka wells) based on the number of rigs available. For example
Year # of Rigs
2016 2
2017 3
2018 4
2019 4
Each rig drills 14 wells per year. So 2 rigs will drill 28 wells per year. Three rigs will drill 42 wells per year, so on so forth. Imagine that in 2016 we have to drill 100 wells in a given scenario, but with a change in the number of rigs we can only drill only 28 wells. I want to change the dates of the wells based on the availability of the number of rigs.
I can do this manually however it would take a lot of time considering our schedule goes out till 2056. Any inputs or suggestions to start this workflow would be much appreciated.
Thanks,
Ganesh
Bookmarks