Department Resource spreadsheet which represents individual staff, considers start and end dates to present an FTE and Headcount view

Role ID - Numbers
First Name - Free Text
Last Name - Free text
Position Number - Numbers
Personnel Number - Numbers
Level - A1, A2, A3, A4, A5, A6, D1, D2, E1, E2, E3
Job Group - Developer, Tester, Project Administration
Job Title - Free Text
Employment Type - Direct, Vendor, Contractor
Cost Allocation - Program of Work, Business as Usual
Status - Active, Planned, Confirmed, Closed, LTL, Open, Proposed
Start Date - AUS Date Format
End Date - AUS Date Format
Contract End Date - AUS Date Format
FTE - Number
Team Name - Free Text
Reporting Manager Name - Free Text
Director Name - Free Text
*Option to add more columns manually

Visuals/Tables
Summary Data Tables
1. each month from Jan 2024 - June 2025
2. Financial Year
3. 6 Month View Jan-June, July-Dec etc

Summary Date Tables with filters based on status showing.
1. FTE by Employment TYPE, FTE by Level
2. Headcount by Employment TYPE, Headcount by Level