Instructions for using the Excel models
Make sure that you have the Goal Seek facility installed in Excel.
Set the required floor and ceiling
Set the cursor on cell R166
Go to Tools/Goal Seek. The Set cell should read R166. Set the to value to 0 and set the By changing cell to scaling The model will tell you if it finds a solution and will set the scaling factor. The Solver attempts to find a value for the scaling factor which ensures that the cost of the floor equals the sum of the money raised through both the ceiling and the scaling factor.
If Goal Seek fails to find a solution then you should not accept the offer to 'keep solver solution' -- if you do keep the 'solution' after the Solver has failed to find a solution you will find the model fails to work properly. If this happens you can either reload the model from a saved version and/or set the scaling factor back to one.
If you see the word 'error' this is a signal that you must run the Solver to get a valid solution.
Spreadsheets
- Model (MS Excel 97 92kb)
Updated 19 September 2005
Return to Local Government Finance Index
Return to Local and Regional Government Index
Return to ODPM What's New Page
Return to ODPM Home Page
ODPM Web site terms