• 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 had the honor of working with Peter for somewhere around 4 years in various roles directly or indirectly managed by Peter. I have always been amazed by how much there is to Peter. He is a brilliant visionary with a passion for technology. He is well versed in technologies that support his vision, whether they are mainstream or emerging areas. He can take these technologies and envision and create solutions to complex technical and business domain problems. Beyond the technical brilliance, Peter is a great educator and spokes man. Peter does a great job of explaining very intricate and difficult technical details to other technical people in order to realize implementation of that vision. At the same time, Peter can adapt to the communication needs of other stakeholders involved in the projects and products he’s managing.
Peter is an extremely hard working individual. He never seems to stop working or thinking. Even laden with heavy travel, Peter doesn’t slow down, but merely appears to live and work in 3 parts of the world simultaneously. When he’s not working hard, there is a very interesting personal side full of interesting hobbies and interesting conversations. I will miss having those conversations in person.
I would certainly invite the opportunity to work with Peter again in the future. I learned a lot, grew a lot and can see that I have much to improve if I am to become a shadow of what he has been for these past 4 years.”

Greg Hansen, Software Developer, Matrikon Inc.