Welfare Costs Calculator

(GL/SB/JW CCFR 2006-2009)

The tool is used by local authorities to enable them to compare and analyse the relative values of different types of care for children.

The data features information about each child, and each placement, and breaks the cost down into each stage of the care process. Reports are then created on the fly in Excel, featuring 6 different structures of interactive pivot tables.

Users can import data from different sources, and can easily change the format of imports with a field-mapping table. This means that if there are changes to the input data column headings, these new or modified fields can be simply mapped across to the correct place in the destination tables. This greatly reduces need for expensive modifications to the code. Users can also export the imported data for analysis.

Users can also change the cost tables on which the calculations are based. They can also run 'scenarios' whereby costs are calculated 'as if' any types of placements were substituted for any others.

The database was split between a front end containing the forms, code and reports, and a back end that contained the raw data.

This Access Database was an upgrade from a Excel solution which had speed and security issues. Access allowed four separate levels for login security.

To find out how we could make a project like this help your business, call +44 (0)1949 21212

(show full list)

120

Access, Excel

(A,F)