✅ Free Tool — No account required

Workforce FTE Calculator

Enter your team's hours, leave entitlements, and workload demand. See your real staffing capacity and where the gaps are — in real time.

Alberta defaults pre-loaded. Export results as PDF or CSV.

1 Organization Setup

Organization Name

Department / Team

Standard Work Week (hours)

Alberta standard: 35 hrs/week for many public sector roles

Work Weeks Per Year

2 Employee Roster

Add each employee or position. Enter their contracted hours per week — FTE is calculated automatically based on your standard work week above.

Name / Position	Role / Classification	Hrs/Week	FTE	Status
Total		0.0	0.00

Tip: You can add vacant positions too — enter the planned hours and label it as "(Vacant)" in the name field to see what your roster should look like when fully staffed.

3 Effective Capacity — Leave & Time Away

These are organization-wide defaults. Actual days away reduce the effective FTE your team provides. Alberta defaults are pre-loaded.

Vacation Days / Year

AB min: 10 days (after 1 yr)

Stat / Public Holidays

Alberta: 9 general + 2 optional

Sick / Personal Days

Typical public sector average

Other Leave (Training, etc.)

Professional development, etc.

—

Total Days Away / Year

—

Working Days Available

—

Effective Capacity %

4 Workload & Gap Analysis

Enter the FTE your workload actually demands. This can come from service volume data, benchmarks, or your own assessment of what it takes to do the work.

FTE Required (Workload Demand)

How many full-time equivalents your current workload requires

Projected Growth / Change (%)

Optional: adjust demand for anticipated growth

Planning Horizon

5 Results Summary

—
Nominal FTE (Rostered)

—

Effective FTE (After Leave)

—

FTE Required (Demand)

—

FTE Gap / Surplus

—

Capacity Utilization

—

Adjusted FTE (With Growth)

Want a professional FTE analysis for your organization?

This calculator gives you a starting point. A professional workforce analysis goes deeper — validating your demand assumptions, benchmarking against comparable organizations, and producing an audit-ready report your board or funder will accept. CommonGround Data Solutions serves municipalities, First Nations, health organizations, and large employers across Alberta.

See what's included → Book a free scoping call