How do I link results to an economic model in an Excel spreadsheet?

The CapEx, OpEx and production data that you need for the economic model can be downloaded to Excel by selecting the "Model Output" report in PetroVR. When you report the "Model Output" to Excel, a sheet named "Econ In" is created in your default spreadsheet.

When linking to an economic model in Excel you have two options. You can either make the economic model the default PetroVR spreadsheet, in which case the "Econ In" sheet appears in your Excel economic model. Alternatively, you can create a link in your economic model spreadsheet to the default spreadsheet. In both cases, each output line in the "Econ In" sheet has a range name, making is easy to set up the links.

You can bring the economic results back to PetroVR by returning the values as Excel input to the PetroVR economic modeling tool. Please check the economic model in the "Excel Econ Model" project for an example.

When you return the results to PetroVR, you will operate PetroVR exactly the same way as if you had an economic model in PetroVR: If you change a parameter and want to see the influence on the economics, all you need to do is to calculate the project by pressing the "calculator" button, and calculate the economic model by pressing the "calculator with a dollar sign" button.