Is there a way to create your own method / function of Second, because I know the structure of the system I have already designed an iterative solver which is much faster than the Excel iterative solver, but I am not sure how to implement this in Excel. Does this mean that the solver + iterative calculation cannot be used together? Is not changed at all and it promptly stops saying solution found. However I have found that the solver does not appear to wait until the first iteration loop is complete - in fact the decision variable reaching a steady state), the second step is to optimize the system using Excel Solver.
System models which include feedback, and because of the inherent loop this creates circular references, and the iterative calculation tick box sorts this one out. First, I have a developed an excel add in which allows the user to build steady state I have a couple of questions regarding the iterative calculation (Excel Options - Formulas - Enable iterative calculation) and the use of the Excel solver in Excel 2007.