Election Cost Allocation Template

Produced by the SOLGM Electoral Working Party

The SOLGM Electoral Working Party produced a range of resources to assist local authorities in their cost allocation.

The template is in a spreadsheet that Electoral Officers can use to apportion the costs of your election. It provides a framework that you can modify for your own election. Hopefully, you can use the derived spreadsheets with no changes. The only modifications that might be needed would be to add new rows and columns into the tables if your election is more complex than already provided for.

There are three files in this product which consists of the following.  These documents are updated as at 11 August 2010:

• Microsoft Excel spreadsheet (xls file) entitled Election Expense Spreadsheet v2-5 Example1.xls. This document serves only as an example of how to use the spreadsheet. Do not use this particular spreadsheet for your own election.
  Download File: Election Expense Spreadsheet Example.xls (Excel Spreadsheet, 339 kb)
  
• Microsoft Excel template (xlt file) entitled Election Expense Template v2-5 without numbers.xlt. This is the Excel template you will use to create one or more Excel spreadsheets for your own election(s).
  Download File: Election Expense Template.xlt (Excel Template, 338 kb)
  
• User Guide written with Microsoft Word 2003.
  Download File: Election Expense Allocation Template User Guide (Word, 1.3 mb)

Download a zip archive file of the three files above (ZIP, 426 kb)
Remember: before using the product, you should move the three components from the Zip archive into a Windows folder.

The template is distributed as a spreadsheet template file (with type = .XLT). To create a spreadsheet from the template, simple double-click the XLT file and save the derived Excel workbook (spreadsheet) using a suitable filename of your choice. You then work only with the derived spreadsheets. Use the template to create as many working Excel workbooks as you need for your own election(s).

This template was developed using Excel 2003. Some of the instructions contained below for modifying the spreadsheet layout may be different when using earlier versions of Excel.