]Analysis: 1. level
COCO offline
Preconditions for using COCO offline modules:
- Of course offline analyses can be formed with any kind of (N)LP support, but in this case we will talk about the support based on the Solver module of MS Excel. The solver can be activated on the add-ins sheet in the Excel.
- The solver can be run from macro,
- but the size of the OAM to be processed is limited.
- In order to be able to set up the parameters in the solver, you may need to know the VLOOKUP(), IF(), SUM(), and the PRODUCT(), SUMSQ(), AVERAGE(), STD(), RANK(), PERCENTRANK(), QUARTILE(), COUNT(), COUNTIF(), SUMIF(), etc. formulas.
- The setting up of the OAM presumes the routine use of the pivot table wizard, because the OAM is a pivot view, where the rows are the objects, and the columns are the attributes, and their measure units.
- Important to know: the solver does not produce a final, stable solution in all cases...
- Good to know: multiple solver-modules can be activated in an excel workbook, and when copying worksheets, solver-options will be inherited.
- The object of solver is to approximate the stairs defined in the models as parameters. So, the solver is quasi a search engine that allows goal-oriented search. Solver can be replaced with MCM solutions that provide random groping (cf. RAND()) and with self made macros (e.g. Roxfort-algorithm), that minimize the relevance of coincidence, and does an almost goal-oriented stair shuffling with the gradual minimization of the error, always adapting the previous best status as a start.
- There is no (positive) experience with the Open Office.
