Instructions for using the Excel models
Make sure that you have the Solver facility installed in Excel.
Set the required floor; go to Tools/Solver and click the Solve box. 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 total of Final Grant for all authorities in the group is equal to the amount available as specified in the Solver drop-down menu).
If the Solver 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.
This is not the definitive model so there may be slight differences between the results with this spreadsheet and those in the consultation papers (eg scaling factors not identical beyond the eighth decimal place);
The models only handle the floor calculation for the specified group of authorities, according to the scheme for those authorities as described in the floor damping methodology paper;
These spreadsheets are being made available on an 'as is' basis - we do not have the resources to provide advice and assistance on the workings of the spreadsheet or on the modelling of floor/ceiling options.
- Education/PSS Authorities (MS Excel 2002 157kb)
- Police Authorities (MS Excel 2002 53kb)
- Fire Authorities (MS Excel 2002 40kb)
- Shire Districts (MS Excel 2002 229kb)
Return to Local Government Finance Settlement Index
Updated 1 February 2006
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