Excel models for municipalities

This model helps you if you manage a budget process for a municipal operation. In the export sheet you can paste data from previous years’ budgets or actuals. The FileName column determines which data ends up in which file. You can then send the files out to the respective managers and let them fill them in. Afterwards you import them via the import sheet.

BudgetMasterfil_Kommun_LL231003_Public

————-

This model helps you as a municipal official to calculate the effects of a new development. You enter the likely age ranges for the new residential area and the costs associated with the project. Once you have entered the data, you click Save Scenario, and the effects on local schools and on the municipality’s budget are shown.

ExploateringKommun_LL231106

————-

Calculates OB pay (unsocial-hours supplements) based on a time report and the selected agreements.

OB_Uträknare

————-

This model can fetch images from an e-mail address and show on a list where the images were taken. It is a very simple tool for reporting technical faults.

ExploateringKommun_LL231106