Less than 1 month –
Less than 10 hrs/week –
VBA; solver; dictionary items; arrays; multidimensional arrays; loops; xy scatter charts; pro forma and finance experience; modified arps equation; oil and gas; PV and XIRR; Solving Hyperbolic, exponential, b factor less than 1, and for unconventional b factor less than 2.
Basically using a macro to forecast oil production based on historical production by matching type curves with the modified arps equation and excel solver. Graphing historical production with forecasted production. Building a proforma and well economics. Then creating a ...