Headcount Planning
Find clarity and focus by drilling down to the data that matters
Copy this doc
As companies grow, so do the categories used to organize all employees. With spreadsheets, a grid of every possible combination is generally used leaving you with a sea of empty cells to look at and the important data more scattered than it should be. With Coda, we can define new departments, teams, and initiatives on the fly, then add only what combinations exist with the push of a button. This is an example doc showing how to make that happen along with being able to aggregate and display your data in any way you can dream up. The goal is to find more focus by narrowing down what you need to assess to only what exists and what applies.
Getting started is easy:
Add only what you need with Coda buttons
Adding a new Team or Department could mean having to recreate all of your spreadsheets to fit the new value in. With Coda’s tables, its as easy as adding the new option as a new row. To make it even quicker, that can be programmed into a one-click button.
All options added!
Headcount Table
Big Rock
Team
Department
Sub-Tier
Employee Count
Mobile App Design
Mobile
Engineering
P1
1
Mobile App Design
Mobile
Engineering
M2
1
Mobile App Design
AI
Design
1
Mobile App Design
Mobile
Design
P2
1
Mobile App Design
AI
Data
1
Mobile App Design
AI
Security
P2
2
Mobile App Design
Mobile
Data
2
Mobile App Design
AI
Design
M2
1
Mobile App Design
AI
Data
M3
1
Mobile App Design
AI
Security
P3
1
There are no rows in this table
Grouping columns achieves the same grid layout you’re used while retaining the powerful advantage of keeping data in a table structure
Grouped View of Capacity Table
M2
M3
P1
P2
P3
Mobile App Design
10
Mobile
4
Data
1
2
Design
1
1
Engineering
2
1
1
AI
6
Data
2
1
1
Design
2
1
1
Security
2
2
1
Aggregates and statistics roll up to their option tables easily and efficiently
Sub-Tier Counts
Sub-Tier
Employee Count
M1
0
M2
2
M3
1
M4
0
M5
0
P1
1
P2
3
P3
1
P4
0
P5
0
There are no rows in this table
Sub-Tier Chart
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.