• Increase font size
  • Default font size
  • Decrease font size
Home Products Resolver Production Data Reconciliation

Resolver Production Data Reconciliation

Resolver is an Excel add-in that performs data reconciliation using a high performance, accurate, and robust algorithm optimized for the data reconciliation problem. It uses the same problem setup as the Solver Excel-add-in. In fact the problems are interchangeable. You can setup and solve a problem in Resolver and then use the same setup and problem definition to try and solve it with Solver, just in case you want verification of the results! Resolver is not limited to trivial problems: it has been tested with hundreds of variables, and hundreds of constraints, both linear and nonlinear.


Resolver came about as a result of trying to use Solver to solve process data reconciliation problems, as reported in Is Excel Solver suitable for Production Data Reconciliation?. As noted, Excel has a lot of advantages for setting up process data reconciliation problems, and is widely used for operational and production accounting. Along with some advantages, some issues were revealed which have been overcome with Resolver.Resolver uses a reconciliation model defined via constraint equations expressed as Excel cell formula in the same way as Solver.

The data reconciliation problem is defined in a very similar way to Excel Solver. In fact the model definitions are interchangeable, although Resolver can only solve for the Gaussian objective function, and Solver cannot produce the reconciliation diagnostics.

Resolving will write the results back into the variable cells, and also produces a report to help diagnose the reconciliation problems. This produces the well established gross, constraint, and measurement error diagnostics.




“I have been working with Peter since 1995 and I'm lucky under his mentorship from that time. With Peter I was working on different projects on Oil & Gas company, starting with Material Balance, KPI, Balance Scorecard, Integration system and Volumetric system for whole company.
Peter has incredible passion about his work and Peter's innovative ideas had a profound effect on the technological direction the company took, making it an attractive proposition to larger multi nationals. Peter is one of the only people I know who is able to communicate his ideas and enthusiasm in such a unique way that ensures the 'buy in' of other key stake holders within the organization.
I believe Peter is a genius and technology visionary, he has unique way to anticipate the future and finds a way to make it comprehensible for those around him in the present and as person I believe he is unique because that encourage people to do more that they believe they can.”

Guillermo Losada, Sr Production Management - Technical Lead, Matrikon Inc.