Cham · Zug · Switzerland
Workload controlling for educational institutions
Separate spreadsheets for staffing, group assignments and programme utilisation make it difficult to maintain a shared view. AppSolution develops custom workload and capacity controlling applications based on your institution’s planning rules and workflows, rather than a fixed template.
Connect staffing and capacity planning
Contract changes, absences and different support programmes affect available capacity. A shared data model can connect this information with teams, groups and assignments. The key questions are which rules apply on each date and how your institution defines over- or under-allocation.
A concrete project example
For an educational institution supporting learners with additional needs, a web app was built to handle employees, contracts, workloads, absences and learner assignments. It includes date-aware calculations, a utilisation dashboard, role-based access, Azure AD sign-in and an Excel import. Our reference page describes the project. These are features of that specific implementation, not a promise of an identical scope for every new project.
Make calculations understandable
Before implementation, we document terminology, sources and rules. How is a workload calculated? When do changes take effect? How should part-time contracts, absences and school-year transitions appear in reports? Agreed example cases help validate results and expose conflicting assumptions early.
Start with your existing workflow
A process sketch and anonymised examples of current reports are enough for an initial discussion. They help define import, permissions and reporting requirements. There is no need to send personal data in advance. We assess whether extending current tools or building a separate application is appropriate.
Frequently asked questions
Is this an off-the-shelf product?
This is custom software development based on your requirements. The existing reference illustrates a possible implementation, not an unchanged standard package.
Can existing Excel data be imported?
The reference project includes an Excel import. Your file format, completeness and field mapping need assessment before an import can be confirmed.
Can access rights be defined?
Roles follow your organisation’s responsibilities. The reference project uses role-based permissions and Azure AD sign-in; the appropriate approach is agreed for each institution.