Model team capacity and hiring needs
FormulasEasyDeterministic scoringLatest run
Passed by 11 of 12 products on their best model. Failed: Gemini in Sheets.
Prompt
Add formulas for available hours and projected headcount at 85% target utilization
Add a gap formula showing how many people we need to hire or can let go
Starting spreadsheet
Sheet1| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | |||
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | |||
| 4 | QA Engineers | 5 | 78 | 38 | 45 | |||
| 5 | DevOps | 3 | 88 | 40 | 48 | |||
| 6 | Product Managers | 4 | 85 | 40 | 45 | |||
| 7 | Designers | 6 | 73 | 38 | 45 | |||
| 8 | Data Engineers | 7 | 93 | 42 | 50 | |||
| 9 | ML Engineers | 2 | 95 | 44 | 50 |
A passing output
Autosheet in Excel · Opus 5.5F2=B2*E2-B2*D2*C2/100
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap | Hiring Action | Target Utilization | 85% |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 97.6 | 8 | 0 | On target | ||
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 81.4 | 13 | 1 | Hire 1 | ||
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 76.8 | 5 | 0 | On target | ||
| 5 | DevOps | 3 | 88 | 40 | 48 | 38.4 | 4 | 1 | Hire 1 | ||
| 6 | Product Managers | 4 | 85 | 40 | 45 | 44.0 | 4 | 0 | On target | ||
| 7 | Designers | 6 | 73 | 38 | 45 | 103.6 | 6 | 0 | On target | ||
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 76.6 | 8 | 1 | Hire 1 | ||
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 16.4 | 3 | 1 | Hire 1 | ||
| 10 | Total | 47 | 534.7 | 51 | 4 | Hire 4 |
Pass criteria
All must be met, checked automatically.F2:F9hold the expected values, in an accepted formF2:H9use formulas- Rows 2–9: projected headcount at 85% and its gap, in an accepted way
Passed 21
Autosheet in Excel Opus 5.5 · Medium
F2=B2*E2-B2*D2*C2/100
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap | Hiring Action | Target Utilization | 85% |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 97.6 | 8 | 0 | On target | ||
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 81.4 | 13 | 1 | Hire 1 | ||
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 76.8 | 5 | 0 | On target | ||
| 5 | DevOps | 3 | 88 | 40 | 48 | 38.4 | 4 | 1 | Hire 1 | ||
| 6 | Product Managers | 4 | 85 | 40 | 45 | 44.0 | 4 | 0 | On target | ||
| 7 | Designers | 6 | 73 | 38 | 45 | 103.6 | 6 | 0 | On target | ||
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 76.6 | 8 | 1 | Hire 1 | ||
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 16.4 | 3 | 1 | Hire 1 | ||
| 10 | Total | 47 | 534.7 | 51 | 4 | Hire 4 |
Autosheet in Excel GPT-6 Astra · Low
F2=B2*E2*(1-C2/100)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 64.8 | 8 | 0 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 48.6 | 13 | 1 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 49.5 | 5 | 0 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 17.3 | 4 | 1 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 27.0 | 4 | 0 |
| 7 | Designers | 6 | 73 | 38 | 45 | 72.9 | 6 | 0 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 24.5 | 8 | 1 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 5.0 | 3 | 1 |
Autosheet in Sheets Opus 5.5 · Medium
F2=B2*(E2-D2)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap | Hiring Action | Target Utilization | 85% |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 40 | 8 | 0 | On target | ||
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 36 | 13 | 1 | Hire 1 | ||
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 35 | 5 | 0 | On target | ||
| 5 | DevOps | 3 | 88 | 40 | 48 | 24 | 4 | 1 | Hire 1 | ||
| 6 | Product Managers | 4 | 85 | 40 | 45 | 20 | 4 | 0 | On target | ||
| 7 | Designers | 6 | 73 | 38 | 45 | 42 | 6 | 0 | On target | ||
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 56 | 8 | 1 | Hire 1 | ||
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 12 | 3 | 1 | Hire 1 |
Autosheet in Excel Sonnet 5.5 · Medium
F2=B2*D2*(1-C2/100)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap | Target Utilization % | 85 | |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 57.6 | 7.8 | -0.2 | |||
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 45.36 | 12.9 | 0.9 | |||
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 41.8 | 4.6 | -0.4 | |||
| 5 | DevOps | 3 | 88 | 40 | 48 | 14.4 | 3.2 | 0.2 | |||
| 6 | Product Managers | 4 | 85 | 40 | 45 | 24 | 4 | 0 | |||
| 7 | Designers | 6 | 73 | 38 | 45 | 61.56 | 5.2 | -0.8 | |||
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 20.58 | 7.7 | 0.7 | |||
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 4.4 | 2.3 | 0.3 |
Claude in Excel Opus 5.5 · High
F2=B2*E2*$B$12
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap | Hiring Action |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 306.0 | 7 | -1 | Let go 1 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 459.0 | 12 | 0 | No change |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 191.3 | 4 | -1 | Let go 1 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 122.4 | 3 | 0 | No change |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 153.0 | 4 | 0 | No change |
| 7 | Designers | 6 | 73 | 38 | 45 | 229.5 | 5 | -1 | Let go 1 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 297.5 | 7 | 0 | No change |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 85.0 | 2 | 0 | No change |
| 10 | |||||||||
| 11 | |||||||||
| 12 | Target Utilisation | 85% | |||||||
| 13 | Total to Hire | 0 | |||||||
| 14 | Total to Let Go | 3 | |||||||
| 15 | Net Headcount Change | -3 |
Autosheet in Excel Haiku 5.5 · High
F2=B2*E2*$K$1-B2*D2*C2/100
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap | Target Utilization | 85% | |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 43.6 | 7 | -1 | |||
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 0.36 | 12 | 0 | |||
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 43.05 | 4 | -1 | |||
| 5 | DevOps | 3 | 88 | 40 | 48 | 16.8 | 3 | 0 | |||
| 6 | Product Managers | 4 | 85 | 40 | 45 | 17 | 4 | 0 | |||
| 7 | Designers | 6 | 73 | 38 | 45 | 63.06 | 5 | -1 | |||
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 24.08 | 7 | 0 | |||
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 1.4 | 2 | 0 |
Claude in Sheets Opus 5.5 · Medium
F2=B2*(E2-D2)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap | Hire / Reduce | Target Utilization | 85% |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 40 | 8 | 0 | No change | ||
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 36 | 13 | +1 | Hire 1 | ||
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 35 | 5 | 0 | No change | ||
| 5 | DevOps | 3 | 88 | 40 | 48 | 24 | 4 | +1 | Hire 1 | ||
| 6 | Product Managers | 4 | 85 | 40 | 45 | 20 | 4 | 0 | No change | ||
| 7 | Designers | 6 | 73 | 38 | 45 | 42 | 6 | 0 | No change | ||
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 56 | 8 | +1 | Hire 1 | ||
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 12 | 3 | +1 | Hire 1 |
Claude Code + Sheets MCP Opus 5.5 · Medium
F2=B2*E2*(1-C2/100)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 64.8 | 8 | - |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 48.6 | 13 | +1 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 49.5 | 5 | - |
| 5 | DevOps | 3 | 88 | 40 | 48 | 17.3 | 4 | +1 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 27.0 | 4 | - |
| 7 | Designers | 6 | 73 | 38 | 45 | 72.9 | 6 | - |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 24.5 | 8 | +1 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 5.0 | 3 | +1 |
| 10 | ||||||||
| 11 | Target Utilization % | 85 |
Autosheet in Excel GPT-6.1 Sol · Medium
F2=B2*(E2-D2*C2/100)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 97.60 | 7 | -1 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 81.36 | 12 | 0 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 76.80 | 4 | -1 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 38.40 | 3 | 0 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 44.00 | 4 | 0 |
| 7 | Designers | 6 | 73 | 38 | 45 | 103.56 | 5 | -1 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 76.58 | 7 | 0 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 16.40 | 2 | 0 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
F2=B2*E2*(1-C2/100)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap | Target Utilization | 85% | |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 64.8 | 7.7 | -0.3 | |||
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 48.6 | 12.8 | 0.8 | |||
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 49.5 | 4.6 | -0.4 | |||
| 5 | DevOps | 3 | 88 | 40 | 48 | 17.3 | 3.1 | 0.1 | |||
| 6 | Product Managers | 4 | 85 | 40 | 45 | 27.0 | 4.0 | 0.0 | |||
| 7 | Designers | 6 | 73 | 38 | 45 | 72.9 | 5.2 | -0.8 | |||
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 24.5 | 7.7 | 0.7 | |||
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 5.0 | 2.2 | 0.2 |
ChatGPT + Autosheet MCP GPT-6 · Medium
F2=B2*D2*(1-C2/100)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Headcount Gap (+ Hire / - Release) | Target Utilization | 85% | |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 57.6 | 8 | 0 | |||
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 45.4 | 13 | +1 | |||
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 41.8 | 5 | 0 | |||
| 5 | DevOps | 3 | 88 | 40 | 48 | 14.4 | 4 | +1 | |||
| 6 | Product Managers | 4 | 85 | 40 | 45 | 24.0 | 4 | 0 | |||
| 7 | Designers | 6 | 73 | 38 | 45 | 61.6 | 6 | 0 | |||
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 20.6 | 8 | +1 | |||
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 4.4 | 3 | +1 |
Autosheet in Sheets Haiku 5.5 · High
F2=B2*E2*0.85-B2*D2*C2/100
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 43.6 | 7 | -1 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 0.36 | 12 | 0 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 43.05 | 4 | -1 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 16.8 | 3 | 0 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 17 | 4 | 0 |
| 7 | Designers | 6 | 73 | 38 | 45 | 63.06 | 5 | -1 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 24.08 | 7 | 0 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 1.4 | 2 | 0 |
ChatGPT in Excel GPT-6 Astra · Medium
F2=B2*(E2-D2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 40 | 8 | 0 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 36 | 13 | 1 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 35 | 5 | 0 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 24 | 4 | 1 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 20 | 4 | 0 |
| 7 | Designers | 6 | 73 | 38 | 45 | 42 | 6 | 0 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 56 | 8 | 1 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 12 | 3 | 1 |
| 10 | ||||||||
| 11 | Target Utilization | 85% |
Claude in Excel Haiku 5.5 · High
F2=B2*D2*$B$12
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 272 | 7.7 | 0 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 428 | 12.8 | +1 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 162 | 4.6 | 0 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 102 | 3.1 | 0 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 136 | 4.0 | 0 |
| 7 | Designers | 6 | 73 | 38 | 45 | 194 | 5.2 | -1 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 250 | 7.7 | +1 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 75 | 2.2 | 0 |
| 10 | ||||||||
| 11 | ||||||||
| 12 | Target utilization | 85% |
Claude in Sheets Haiku 5.5 · High
F2=B2*E2*$K$1/100
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap | Target Utilization % | 85% | |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 306 | 8 | No change | |||
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 459 | 13 | +1 to hire | |||
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 191 | 5 | No change | |||
| 5 | DevOps | 3 | 88 | 40 | 48 | 122 | 4 | +1 to hire | |||
| 6 | Product Managers | 4 | 85 | 40 | 45 | 153 | 4 | No change | |||
| 7 | Designers | 6 | 73 | 38 | 45 | 230 | 6 | No change | |||
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 298 | 8 | +1 to hire | |||
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 85 | 3 | +1 to hire |
Autosheet in Excel GPT-6 Luna · High
F2=B2*E2-(B2*D2*C2/100)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 97.6 | 7 | -1 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 81.36 | 12 | 0 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 76.8 | 4 | -1 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 38.4 | 3 | 0 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 44 | 4 | 0 |
| 7 | Designers | 6 | 73 | 38 | 45 | 103.56 | 5 | -1 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 76.58 | 7 | 0 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 16.4 | 2 | 0 |
Copilot in Excel Auto
F2=B2*(E2-D2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 40 | 8 | 0 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 36 | 13 | +1 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 35 | 5 | 0 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 24 | 4 | +1 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 20 | 4 | 0 |
| 7 | Designers | 6 | 73 | 38 | 45 | 42 | 6 | 0 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 56 | 8 | +1 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 12 | 3 | +1 |
ChatGPT + Drive MCP GPT-6 · Medium
F2=B2*E2-B2*D2*C2/100
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 97.6 | 7 | -1 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 81.36 | 12 | 0 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 76.8 | 4 | -1 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 38.4 | 3 | 0 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 44 | 4 | 0 |
| 7 | Designers | 6 | 73 | 38 | 45 | 103.56 | 5 | -1 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 76.58 | 7 | 0 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 16.4 | 2 | 0 |
ChatGPT in Excel GPT-6 Luna · High
F2=B2*E2*(1-C2/100)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 64.8 | 7.717647059 | 0 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 48.6 | 12.84705882 | 1 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 49.5 | 4.588235294 | 0 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 17.28 | 3.105882353 | 1 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 27 | 4 | 0 |
| 7 | Designers | 6 | 73 | 38 | 45 | 72.9 | 5.152941176 | 0 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 24.5 | 7.658823529 | 1 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 5 | 2.235294118 | 1 |
ChatGPT in Sheets GPT-6 Astra · Medium
F2=B2*(E2-D2)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 40.0 | 7.72 | -0.28 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 36.0 | 12.85 | +0.85 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 35.0 | 4.59 | -0.41 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 24.0 | 3.11 | +0.11 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 20.0 | 4.00 | 0.00 |
| 7 | Designers | 6 | 73 | 38 | 45 | 42.0 | 5.15 | -0.85 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 56.0 | 7.66 | +0.66 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 12.0 | 2.24 | +0.24 |
| 10 | ||||||||
| 11 | Target Utilization | 85% |
ChatGPT in Sheets GPT-6 Luna · High
F2=B2*E2*(1-C2/100)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | 64.8 | 7.717647059 | -0.282352941 |
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | 48.6 | 12.84705882 | 0.847058823 |
| 4 | QA Engineers | 5 | 78 | 38 | 45 | 49.5 | 4.588235294 | -0.411764706 |
| 5 | DevOps | 3 | 88 | 40 | 48 | 17.28 | 3.105882353 | 0.105882353 |
| 6 | Product Managers | 4 | 85 | 40 | 45 | 27 | 4 | 0 |
| 7 | Designers | 6 | 73 | 38 | 45 | 72.9 | 5.152941176 | -0.847058823 |
| 8 | Data Engineers | 7 | 93 | 42 | 50 | 24.5 | 7.658823529 | 0.658823529 |
| 9 | ML Engineers | 2 | 95 | 44 | 50 | 5 | 2.235294118 | 0.235294118 |
Failed 1
Gemini in Sheets Auto
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Resource | Current Headcount | Utilization % | Avg Hours/Week | Max Capacity Hours | Available Hours | Projected Headcount | Gap |
| 2 | Frontend Engineers | 8 | 82 | 40 | 45 | |||
| 3 | Backend Engineers | 12 | 91 | 42 | 45 | |||
| 4 | QA Engineers | 5 | 78 | 38 | 45 | |||
| 5 | DevOps | 3 | 88 | 40 | 48 | |||
| 6 | Product Managers | 4 | 85 | 40 | 45 | |||
| 7 | Designers | 6 | 73 | 38 | 45 | |||
| 8 | Data Engineers | 7 | 93 | 42 | 50 | |||
| 9 | ML Engineers | 2 | 95 | 44 | 50 |
Why it failed: Still working at the 5-minute time limit. F2:H9 hold no formula. Not met: row 2: projected headcount at 85% and its gap.