Find Your Solution with AiSara

Updated: Mar 19, 2019

Optimize with no equation

#optimization #maximization #minimization #oilandgasexample #solvingcomplexproblem

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.

Click Sample and Retrieve this Dataset

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.
LEARN is usually one of the first things you do

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.

Next, time to do the SPIDER. This is not a necessary step, but it will conveniently provide the min and max later for the Solver.

So there you go. The SPIDER shows the min and max of the input range

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.

You can now do the PREDICT, first variable is the LEARNed cell, the input data range (any reasonable numbers to start with), and which output column, in this case 1, there is only 1 output column here anyway..

See below how you constraints the Solver.

You can now call on the Solver from Data, Solver, and then you can specify the cell Set Objective to where you have your PREDICT just now, and enter the constraints from the SPIDER output. This ensures that you will search your solution within your dataset. Notice that we set Objective to Minimum.

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.

The results showed a new value with the input parameters. We don't have the 3d plot feature yet, but if we do =, we can show you that it is in the area where we expect the minimum is.


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


No. A-8-3, Floor 8, Block A,

Megan Avenue 1,

 Jalan Tun Razak,

50400 Kuala Lumpur

  • Twitter
  • Instagram
  • Facebook
  • YouTube
  • LinkedIn