Find Your Solution with AiSara

Optimize with no equation

Do you know that you can easily find an optimize solution with AiSara? The trick is to utilize AiSara in combination with the Excel Solver. But before that let us discuss why you want to optimize.

In oil and gas, you want to maximize production, reverse engineer what your reservoir looks like (via history matching) so you can make better prediction, design parameters that give you the maximum production, field development planning, and many more.

Application in other industry include sales, what to sell, when and where, minimum house pricing based on desired criteria and so much more, There is also the resource allocation problem, company and government policy, environmental assessment, plant optimization, engineering design, transportation, scheduling, etc. These are all some form of optimization problems.

Now, how do we do this with AiSara? For those who can’t be bothered to read this whole article and find all this very easy,, here is how.

Use the PREDICT function to get to a solution, any solution, by providing a first pass input set. Then you can use the Solver to find the combination of input data that yield either the minimum, maximum or a certain target value. 

Now here is a walk-through step by step. 

I am using the oil and gas History Matching 6 variables from the Sample Data-set as the objective there is to find a minimum target value which represents the minimum error.

Why minimum error? Because the minimum error represents the best solution possible in this case.

Using the Sample, download the history match data-set.

Then you let AiSara learn the relationship between the input variables and the output variables using the LEARN function. 

You almost always start with LEARN.

In case you want to understand the source of the data, it is coming from hours of simulation to produce the results for each row. This time consuming process to locate the minimum is exacty why  predicting the minimum results based on limited data will cut the time. So yes, you always need data to use AiSara, but you may need less than usual to reach your answer. 

Ok, here we are going to take a quick look at the SPIDER. The SPIDER will provide results for combination of data, In this article, we will not dwell too much on SPIDER. 

But what SPIDER will provide here quickly is the minimum and maximum values for each input. You can then use this to constrain the Solver later

Typically you want to PREDICT within the range of your data.  

To find your solution, in the case the minimum, you first need to create a prediction. The input values are not too important here. Solver will then vary the input and watch the PREDICTion change. It will iterate to find the minimum.

See below how you constraints the Solver.

If you don't see the Solver, you probably need to Install the Add-In. Click here to see how. Otherwise, click the Solve button and Solver will now look for the Minimum. It may take some time as for every iteration, AiSara will need to do the PREDICTion. Let us look at the results below.

Objective Achieved

The results show a new PREDICT value of 0.011147 (minimum) versus previous starting value of 0.052348. This is a 26% reduction from the minimum available in the data-set of 0.014079 meaning, AiSara did try to find the minimum.

We don't have the 3D plot feature yet, but if we do, we can show that it  is in the area where we expect the minimum is. You can always verify how accurate AiSara prediction is by doing your own blind-test. Use the learn function on just some of the data-set and predict the value of the learned data-set and that which was not included in the learn and compare. In fact, this is what is achieved via the Blindtest button. 

You can imagine where this may help though. Apart from locating the minimum, maximum of your data-set, you can use it to predict what those numbers are even before you have the data or in absence of the data.

We hope this article has been useful. It shows AiSara capability can be combined with Excel's Solver to find an optimum solution.. This feature can also be useful to accelerate your search for a solution.

Rather than run hours and hours of simulation/computations, you can quickly estimate what those values are and verify later.

Without AiSara you will need an equation to describe the relationship between the input and output and this is often not available, especially with real data.

If you have any question don't hesitate to contact us. You can email us at enquiry@aisara.ai