|
Instructions for using the Excel models
Make sure that you have the Goal Seek facility installed in Excel.
Set the required floor; go to Tools/Goal Seek and complete the drop-down box. The model will tell you if it finds a solution and will set the scaling factor. Goal seek 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 Goal Seek drop-down menu).
If Gal Seek fails to find a solution then you should not accept the offer to 'keep solution' -- if you do keep the 'solution' after Goal Seek 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 Goal Seek to get a valid solution.
Notes
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.
Spreadsheets
- Education/PSS Authorities (MS Excel 127kb)
- Police Authorities (MS Excel 48kb)
- Fire Authorities (MS Excel 44kb)
- Shire Districts (MS Excel 182kb)
Updated 6 December 2007
Return to Local Government Finance Index
Return to DCLG Local Government Index
Return to DCLG Home Page
Terms and conditions