Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
What this planner helps you decide
Best for
Agencies and service teams reconciling delivery capacity with committed pipeline.
Outputs
Billable hours, revenue capacity and the remaining or overcommitted team capacity.
Start here
Add each team group with realistic availability and rate assumptions, then enter committed work.
Use a different tool when: Do not use this to compare quoted and actual job economics and identify overruns; use Job Costing & Margin Planner for that decision. Use this tool to compare team billable and revenue capacity with committed pipeline.
Quote & capacity
Agency Team Capacity & Revenue: billable hours
Billable hours, revenue capacity and the remaining or overcommitted team capacity.
Amounts use the same currency as your inputs. No currency conversion is performed.
Team capacity and pipeline
Add up to 100 explicit member or role rows; commercial amounts exclude indirect tax.
Agency capacity and pipeline gap
Positive gaps are unused capacity; negative gaps are over-commitment.
PDF and CSV exports stay on this device. Clean page links contain no inputs.
Current revenue capacity is 561,792.00, compared with 480,000.00 committed and a 81,792.00 gap.
Revenue excluding indirect tax
| Pipeline and capacity | Revenue excluding indirect tax |
|---|---|
| Committed pipeline (current) | 480,000.00 |
| Revenue capacity | 561,792.00 |
Capacity scenarios
See how revenue capacity changes when utilisation or billable rates move.
ScenarioResultDifference
Entered team and pipeline561,792.00Baseline
All utilisation rates 10 points lower477,888.00-83,904.00
All billable rates 10% higher617,971.2056,179.20
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Billable capacity
Total billable hours
sum of member-row billable hours3,648senior billable hours
headcount ร working weeks ร hours per week ร billable utilisation1,276.8consultant billable hours
headcount ร working weeks ร hours per week ร billable utilisation2,371.2Result3,648.00 hours
Annual billable capacity summed across the entered team rows. The engine retains raw precision; displayed hours are rounded to two decimal places.
Review the team-capacity formulas โInputs used by these formula steps
- Total billable hoursSenior
- 1,276.8
- Total billable hoursConsultant
- 2,371.2
- senior billable hoursHeadcount
- 1
- senior billable hoursWeeks
- 48
- senior billable hoursHours Per Week
- 38
- senior billable hoursUtilisation
- 0.7
- consultant billable hoursHeadcount
- 2
- consultant billable hoursWeeks
- 48
- consultant billable hoursHours Per Week
- 38
- consultant billable hoursUtilisation
- 0.65
Pipeline hours coverage
Total billable hours
sum of member-row billable hours3,648Pipeline hours coverage
committed pipeline hours รท total billable hours0.88Result87.72%
Committed pipeline hours divided by annual billable capacity. The engine retains raw precision; available percentages are rounded to two decimal places for display.
Review the hours-coverage formula โInputs used by these formula steps
- Total billable hoursSenior
- 1,276.8
- Total billable hoursConsultant
- 2,371.2
- Pipeline hours coveragePipeline Hours
- 3,200
- Pipeline hours coverageTotal Billable Hours
- 3,648
Revenue capacity ex indirect tax
Total revenue capacity
sum of member-row revenue capacity561,792senior revenue capacity
billable hours ร hourly rate ex indirect tax229,824consultant revenue capacity
billable hours ร hourly rate ex indirect tax331,968Result561,792.00
Annual currency-unit revenue capacity excluding indirect tax; not a demand forecast. The engine retains raw precision; the money formatter rounds only the displayed result.
Review the revenue-capacity formulas โInputs used by these formula steps
- Total revenue capacitySenior
- 229,824
- Total revenue capacityConsultant
- 331,968
- senior revenue capacityBillable Hours
- 1,276.8
- senior revenue capacityRate
- 180
- consultant revenue capacityBillable Hours
- 2,371.2
- consultant revenue capacityRate
- 140
Pipeline revenue coverage
Total revenue capacity
sum of member-row revenue capacity561,792Pipeline revenue coverage
committed pipeline revenue รท total revenue capacity0.85Result85.44%
Committed ex-indirect tax pipeline revenue divided by annual ex-indirect tax revenue capacity. The engine retains raw precision; available percentages are rounded to two decimal places for display.
Review the revenue-coverage formula โInputs used by these formula steps
- Total revenue capacitySenior
- 229,824
- Total revenue capacityConsultant
- 331,968
- Pipeline revenue coveragePipeline Revenue
- 480,000
- Pipeline revenue coverageTotal Revenue Capacity
- 561,792
Unused revenue capacity
Total revenue capacity
sum of member-row revenue capacity561,792Revenue capacity gap
total revenue capacity โ committed pipeline revenue81,792Result81,792.00
Annual ex-indirect tax revenue capacity less committed ex-indirect tax pipeline revenue; a negative value is over-commitment. The engine retains raw precision; the money formatter rounds only the displayed result.
Review the revenue-gap formula โInputs used by these formula steps
- Total revenue capacitySenior
- 229,824
- Total revenue capacityConsultant
- 331,968
- Revenue capacity gapCapacity
- 561,792
- Revenue capacity gapPipeline Revenue
- 480,000
Capacity hours gap
Total billable hours
sum of member-row billable hours3,648Capacity hours gap
total billable hours โ committed pipeline hours448Result448.00 hours
Annual billable capacity less committed pipeline hours; a negative value is over-commitment. The engine retains raw precision; displayed hours are rounded to two decimal places.
Review the hours-gap formula โInputs used by these formula steps
- Total billable hoursSenior
- 1,276.8
- Total billable hoursConsultant
- 2,371.2
- Capacity hours gapBillable Hours
- 3,648
- Capacity hours gapPipeline Hours
- 3,200
Inputs used
- senior headcount
- 1
- senior working weeks
- 48
- senior hours per week
- 38
- senior billable utilisation
- 70.00%
- senior hourly rate ex indirect tax
- 180.00
- consultant headcount
- 2
- consultant working weeks
- 48
- consultant hours per week
- 38
- consultant billable utilisation
- 65.00%
- consultant hourly rate ex indirect tax
- 140.00
- Committed pipeline hours
- 3,200.00 hours
- Committed pipeline revenue ex indirect tax
- 480,000.00
Open this calculator with preset values
This calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| members | Number of role rows encoded in the capacity scenario. | whole role rows | 1 to 100 | Required | 2 |
| pipeline_hours | Committed pipeline delivery hours. | billable hours/planning period | 0 to 1000000000 | Required | 3200 |
| pipeline_revenue | Committed pipeline revenue excluding indirect tax. | currency units/planning period ex tax | 0 to 1000000000000 | Required | 480000 |
| r0_headcount | row 0 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | 1 |
| r0_hours | row 0 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | 38 |
| r0_rate | row 0 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | 180 |
| r0_utilisation | row 0 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | 0.7 |
| r0_weeks | row 0 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | 48 |
| r1_headcount | row 1 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | 2 |
| r1_hours | row 1 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | 38 |
| r1_rate | row 1 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | 140 |
| r1_utilisation | row 1 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | 0.65 |
| r1_weeks | row 1 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | 48 |
| r10_headcount | row 10 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r10_hours | row 10 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r10_rate | row 10 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r10_utilisation | row 10 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r10_weeks | row 10 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r11_headcount | row 11 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r11_hours | row 11 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r11_rate | row 11 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r11_utilisation | row 11 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r11_weeks | row 11 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r12_headcount | row 12 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r12_hours | row 12 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r12_rate | row 12 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r12_utilisation | row 12 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r12_weeks | row 12 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r13_headcount | row 13 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r13_hours | row 13 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r13_rate | row 13 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r13_utilisation | row 13 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r13_weeks | row 13 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r14_headcount | row 14 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r14_hours | row 14 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r14_rate | row 14 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r14_utilisation | row 14 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r14_weeks | row 14 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r15_headcount | row 15 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r15_hours | row 15 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r15_rate | row 15 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r15_utilisation | row 15 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r15_weeks | row 15 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r16_headcount | row 16 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r16_hours | row 16 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r16_rate | row 16 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r16_utilisation | row 16 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r16_weeks | row 16 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r17_headcount | row 17 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r17_hours | row 17 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r17_rate | row 17 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r17_utilisation | row 17 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r17_weeks | row 17 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r18_headcount | row 18 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r18_hours | row 18 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r18_rate | row 18 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r18_utilisation | row 18 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r18_weeks | row 18 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r19_headcount | row 19 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r19_hours | row 19 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r19_rate | row 19 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r19_utilisation | row 19 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r19_weeks | row 19 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r2_headcount | row 2 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r2_hours | row 2 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r2_rate | row 2 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r2_utilisation | row 2 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r2_weeks | row 2 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r20_headcount | row 20 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r20_hours | row 20 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r20_rate | row 20 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r20_utilisation | row 20 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r20_weeks | row 20 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r21_headcount | row 21 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r21_hours | row 21 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r21_rate | row 21 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r21_utilisation | row 21 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r21_weeks | row 21 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r22_headcount | row 22 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r22_hours | row 22 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r22_rate | row 22 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r22_utilisation | row 22 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r22_weeks | row 22 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r23_headcount | row 23 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r23_hours | row 23 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r23_rate | row 23 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r23_utilisation | row 23 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r23_weeks | row 23 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r24_headcount | row 24 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r24_hours | row 24 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r24_rate | row 24 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r24_utilisation | row 24 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r24_weeks | row 24 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r25_headcount | row 25 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r25_hours | row 25 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r25_rate | row 25 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r25_utilisation | row 25 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r25_weeks | row 25 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r26_headcount | row 26 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r26_hours | row 26 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r26_rate | row 26 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r26_utilisation | row 26 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r26_weeks | row 26 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r27_headcount | row 27 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r27_hours | row 27 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r27_rate | row 27 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r27_utilisation | row 27 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r27_weeks | row 27 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r28_headcount | row 28 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r28_hours | row 28 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r28_rate | row 28 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r28_utilisation | row 28 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r28_weeks | row 28 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r29_headcount | row 29 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r29_hours | row 29 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r29_rate | row 29 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r29_utilisation | row 29 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r29_weeks | row 29 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r3_headcount | row 3 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r3_hours | row 3 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r3_rate | row 3 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r3_utilisation | row 3 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r3_weeks | row 3 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r30_headcount | row 30 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r30_hours | row 30 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r30_rate | row 30 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r30_utilisation | row 30 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r30_weeks | row 30 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r31_headcount | row 31 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r31_hours | row 31 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r31_rate | row 31 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r31_utilisation | row 31 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r31_weeks | row 31 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r32_headcount | row 32 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r32_hours | row 32 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r32_rate | row 32 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r32_utilisation | row 32 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r32_weeks | row 32 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r33_headcount | row 33 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r33_hours | row 33 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r33_rate | row 33 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r33_utilisation | row 33 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r33_weeks | row 33 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r34_headcount | row 34 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r34_hours | row 34 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r34_rate | row 34 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r34_utilisation | row 34 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r34_weeks | row 34 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r35_headcount | row 35 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r35_hours | row 35 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r35_rate | row 35 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r35_utilisation | row 35 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r35_weeks | row 35 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r36_headcount | row 36 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r36_hours | row 36 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r36_rate | row 36 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r36_utilisation | row 36 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r36_weeks | row 36 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r37_headcount | row 37 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r37_hours | row 37 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r37_rate | row 37 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r37_utilisation | row 37 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r37_weeks | row 37 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r38_headcount | row 38 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r38_hours | row 38 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r38_rate | row 38 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r38_utilisation | row 38 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r38_weeks | row 38 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r39_headcount | row 39 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r39_hours | row 39 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r39_rate | row 39 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r39_utilisation | row 39 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r39_weeks | row 39 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r4_headcount | row 4 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r4_hours | row 4 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r4_rate | row 4 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r4_utilisation | row 4 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r4_weeks | row 4 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r40_headcount | row 40 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r40_hours | row 40 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r40_rate | row 40 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r40_utilisation | row 40 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r40_weeks | row 40 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r41_headcount | row 41 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r41_hours | row 41 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r41_rate | row 41 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r41_utilisation | row 41 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r41_weeks | row 41 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r42_headcount | row 42 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r42_hours | row 42 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r42_rate | row 42 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r42_utilisation | row 42 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r42_weeks | row 42 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r43_headcount | row 43 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r43_hours | row 43 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r43_rate | row 43 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r43_utilisation | row 43 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r43_weeks | row 43 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r44_headcount | row 44 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r44_hours | row 44 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r44_rate | row 44 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r44_utilisation | row 44 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r44_weeks | row 44 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r45_headcount | row 45 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r45_hours | row 45 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r45_rate | row 45 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r45_utilisation | row 45 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r45_weeks | row 45 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r46_headcount | row 46 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r46_hours | row 46 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r46_rate | row 46 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r46_utilisation | row 46 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r46_weeks | row 46 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r47_headcount | row 47 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r47_hours | row 47 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r47_rate | row 47 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r47_utilisation | row 47 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r47_weeks | row 47 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r48_headcount | row 48 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r48_hours | row 48 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r48_rate | row 48 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r48_utilisation | row 48 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r48_weeks | row 48 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r49_headcount | row 49 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r49_hours | row 49 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r49_rate | row 49 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r49_utilisation | row 49 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r49_weeks | row 49 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r5_headcount | row 5 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r5_hours | row 5 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r5_rate | row 5 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r5_utilisation | row 5 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r5_weeks | row 5 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r50_headcount | row 50 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r50_hours | row 50 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r50_rate | row 50 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r50_utilisation | row 50 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r50_weeks | row 50 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r51_headcount | row 51 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r51_hours | row 51 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r51_rate | row 51 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r51_utilisation | row 51 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r51_weeks | row 51 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r52_headcount | row 52 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r52_hours | row 52 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r52_rate | row 52 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r52_utilisation | row 52 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r52_weeks | row 52 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r53_headcount | row 53 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r53_hours | row 53 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r53_rate | row 53 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r53_utilisation | row 53 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r53_weeks | row 53 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r54_headcount | row 54 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r54_hours | row 54 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r54_rate | row 54 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r54_utilisation | row 54 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r54_weeks | row 54 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r55_headcount | row 55 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r55_hours | row 55 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r55_rate | row 55 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r55_utilisation | row 55 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r55_weeks | row 55 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r56_headcount | row 56 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r56_hours | row 56 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r56_rate | row 56 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r56_utilisation | row 56 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r56_weeks | row 56 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r57_headcount | row 57 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r57_hours | row 57 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r57_rate | row 57 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r57_utilisation | row 57 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r57_weeks | row 57 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r58_headcount | row 58 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r58_hours | row 58 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r58_rate | row 58 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r58_utilisation | row 58 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r58_weeks | row 58 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r59_headcount | row 59 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r59_hours | row 59 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r59_rate | row 59 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r59_utilisation | row 59 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r59_weeks | row 59 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r6_headcount | row 6 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r6_hours | row 6 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r6_rate | row 6 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r6_utilisation | row 6 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r6_weeks | row 6 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r60_headcount | row 60 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r60_hours | row 60 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r60_rate | row 60 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r60_utilisation | row 60 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r60_weeks | row 60 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r61_headcount | row 61 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r61_hours | row 61 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r61_rate | row 61 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r61_utilisation | row 61 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r61_weeks | row 61 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r62_headcount | row 62 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r62_hours | row 62 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r62_rate | row 62 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r62_utilisation | row 62 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r62_weeks | row 62 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r63_headcount | row 63 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r63_hours | row 63 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r63_rate | row 63 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r63_utilisation | row 63 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r63_weeks | row 63 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r64_headcount | row 64 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r64_hours | row 64 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r64_rate | row 64 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r64_utilisation | row 64 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r64_weeks | row 64 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r65_headcount | row 65 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r65_hours | row 65 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r65_rate | row 65 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r65_utilisation | row 65 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r65_weeks | row 65 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r66_headcount | row 66 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r66_hours | row 66 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r66_rate | row 66 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r66_utilisation | row 66 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r66_weeks | row 66 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r67_headcount | row 67 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r67_hours | row 67 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r67_rate | row 67 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r67_utilisation | row 67 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r67_weeks | row 67 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r68_headcount | row 68 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r68_hours | row 68 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r68_rate | row 68 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r68_utilisation | row 68 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r68_weeks | row 68 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r69_headcount | row 69 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r69_hours | row 69 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r69_rate | row 69 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r69_utilisation | row 69 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r69_weeks | row 69 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r7_headcount | row 7 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r7_hours | row 7 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r7_rate | row 7 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r7_utilisation | row 7 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r7_weeks | row 7 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r70_headcount | row 70 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r70_hours | row 70 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r70_rate | row 70 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r70_utilisation | row 70 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r70_weeks | row 70 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r71_headcount | row 71 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r71_hours | row 71 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r71_rate | row 71 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r71_utilisation | row 71 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r71_weeks | row 71 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r72_headcount | row 72 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r72_hours | row 72 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r72_rate | row 72 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r72_utilisation | row 72 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r72_weeks | row 72 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r73_headcount | row 73 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r73_hours | row 73 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r73_rate | row 73 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r73_utilisation | row 73 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r73_weeks | row 73 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r74_headcount | row 74 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r74_hours | row 74 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r74_rate | row 74 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r74_utilisation | row 74 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r74_weeks | row 74 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r75_headcount | row 75 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r75_hours | row 75 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r75_rate | row 75 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r75_utilisation | row 75 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r75_weeks | row 75 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r76_headcount | row 76 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r76_hours | row 76 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r76_rate | row 76 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r76_utilisation | row 76 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r76_weeks | row 76 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r77_headcount | row 77 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r77_hours | row 77 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r77_rate | row 77 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r77_utilisation | row 77 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r77_weeks | row 77 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r78_headcount | row 78 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r78_hours | row 78 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r78_rate | row 78 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r78_utilisation | row 78 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r78_weeks | row 78 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r79_headcount | row 79 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r79_hours | row 79 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r79_rate | row 79 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r79_utilisation | row 79 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r79_weeks | row 79 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r8_headcount | row 8 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r8_hours | row 8 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r8_rate | row 8 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r8_utilisation | row 8 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r8_weeks | row 8 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r80_headcount | row 80 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r80_hours | row 80 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r80_rate | row 80 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r80_utilisation | row 80 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r80_weeks | row 80 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r81_headcount | row 81 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r81_hours | row 81 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r81_rate | row 81 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r81_utilisation | row 81 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r81_weeks | row 81 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r82_headcount | row 82 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r82_hours | row 82 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r82_rate | row 82 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r82_utilisation | row 82 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r82_weeks | row 82 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r83_headcount | row 83 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r83_hours | row 83 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r83_rate | row 83 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r83_utilisation | row 83 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r83_weeks | row 83 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r84_headcount | row 84 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r84_hours | row 84 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r84_rate | row 84 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r84_utilisation | row 84 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r84_weeks | row 84 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r85_headcount | row 85 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r85_hours | row 85 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r85_rate | row 85 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r85_utilisation | row 85 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r85_weeks | row 85 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r86_headcount | row 86 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r86_hours | row 86 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r86_rate | row 86 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r86_utilisation | row 86 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r86_weeks | row 86 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r87_headcount | row 87 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r87_hours | row 87 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r87_rate | row 87 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r87_utilisation | row 87 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r87_weeks | row 87 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r88_headcount | row 88 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r88_hours | row 88 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r88_rate | row 88 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r88_utilisation | row 88 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r88_weeks | row 88 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r89_headcount | row 89 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r89_hours | row 89 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r89_rate | row 89 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r89_utilisation | row 89 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r89_weeks | row 89 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r9_headcount | row 9 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r9_hours | row 9 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r9_rate | row 9 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r9_utilisation | row 9 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r9_weeks | row 9 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r90_headcount | row 90 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r90_hours | row 90 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r90_rate | row 90 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r90_utilisation | row 90 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r90_weeks | row 90 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r91_headcount | row 91 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r91_hours | row 91 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r91_rate | row 91 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r91_utilisation | row 91 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r91_weeks | row 91 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r92_headcount | row 92 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r92_hours | row 92 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r92_rate | row 92 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r92_utilisation | row 92 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r92_weeks | row 92 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r93_headcount | row 93 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r93_hours | row 93 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r93_rate | row 93 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r93_utilisation | row 93 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r93_weeks | row 93 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r94_headcount | row 94 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r94_hours | row 94 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r94_rate | row 94 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r94_utilisation | row 94 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r94_weeks | row 94 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r95_headcount | row 95 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r95_hours | row 95 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r95_rate | row 95 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r95_utilisation | row 95 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r95_weeks | row 95 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r96_headcount | row 96 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r96_hours | row 96 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r96_rate | row 96 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r96_utilisation | row 96 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r96_weeks | row 96 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r97_headcount | row 97 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r97_hours | row 97 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r97_rate | row 97 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r97_utilisation | row 97 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r97_weeks | row 97 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r98_headcount | row 98 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r98_hours | row 98 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r98_rate | row 98 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r98_utilisation | row 98 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r98_weeks | row 98 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
| r99_headcount | row 99 headcount represented by the role row. | whole people/role row | 1 to 100 | Optional | โ |
| r99_hours | row 99 hours available each week. | paid hours/person/week | 5e-324 to 168 | Optional | โ |
| r99_rate | row 99 rate excluding indirect tax. | currency units/billable hour ex tax | 0 to 1000000000000 | Optional | โ |
| r99_utilisation | row 99 utilisation available for billable work. | decimal fraction of paid hours | 0 to 1 | Optional | โ |
| r99_weeks | row 99 weeks available in the planning year. | working weeks/person/year | 5e-324 to 52 | Optional | โ |
Agency Team Capacity & Revenue: billable hours
Use the capacity result to reconcile sellable delivery time with committed work before accepting more pipeline.
Formula summary
- Primary formula
- revenue capacity = ฮฃ (headcount ร weeks ร hours ร utilisation ร rate)
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Act on the result
Assign the remaining capacity or resolve an overcommitment through timing, scope, pricing, contractors or hiring.
Stress-test the decision
Retest lower utilisation and unavailable weeks so the plan leaves room for management, sales and unplanned delivery work.
When this estimate can be misleading
- This is a deterministic capacity scenario, not a sales forecast or hiring recommendation.
- Rates, utilisation and pipeline values are user supplied; no industry benchmark is used.
- It excludes payroll, loaded labour cost, awards, leave entitlements and collection risk.
- Use the capacity result to reconcile sellable delivery time with committed work before accepting more pipeline.
Educational estimate, not advice. See all assumptions & limitations โ
Related reading
Guides to interpret the decision and its assumptions.
- Agency Economics: Utilisation, Rate, Scope and Pipeline
Connect utilisation, recovery rate, scope delivery and committed pipeline without treating one ratio as an agency forecast.
Read guide
Frequently asked questions
How do I compare team billable and revenue capacity with committed pipeline?
Assign the remaining capacity or resolve an overcommitment through timing, scope, pricing, contractors or hiring.
Does unused capacity mean I should hire or sell more?
No. The gap only compares your entered capacity and pipeline; operational decisions need wider evidence.
Are the rates market benchmarks?
No. Every rate and utilisation value is entered by you.
Does Margin101 store team details?
Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.