The desk-sharing ratio has become one of the most consequential numbers in corporate real estate, yet the method for calculating it rigorously is rarely documented in one place. Organizations that set their ratio by instinct end up either over-providing space that sits empty or under-providing it and creating daily friction that undermines the return-to-office experience. The question of how to translate attendance patterns into a desk-sharing ratio is fundamentally a data problem before it is a design problem, and the methodology below addresses it in full.
Why the Ratio Matters More Than the Floor Plan
The desk-sharing ratio expresses how many workers share each available workstation. A ratio of 1.5:1, for example, means one desk is allocated for every one and a half people assigned to that space. The number directly determines how many square feet a lease must cover, which makes it the bridge between people strategy and portfolio strategy.
Getting the ratio wrong has compounding consequences. Too conservative a ratio inflates the footprint, adds rent expense and signals to leadership that real estate is not being managed as a financial asset. Too aggressive a ratio creates overcrowding on peak days, erodes employee experience and generates complaints that ultimately reverse the policy.
The ratio is also a governance artifact. Executives, finance teams and facilities managers all scrutinize it when approving a renewal, a disposition or a new requirement. A ratio derived from documented attendance data carries far more credibility in those conversations than one borrowed from an industry benchmark.
Defining Attendance in Terms the Data Can Capture
Before any calculation is possible, the team must agree on what "attendance" means in measurable terms. Attendance can be captured at three distinct levels: badge entry into the building, Wi-Fi or Bluetooth association with a device, and actual seat or workstation occupancy recorded by sensors or booking systems.
Each signal captures something different. Badge data tells you how many people entered the building on a given day but not whether they ever sat at a desk. Wi-Fi association tells you how many devices were active in a zone but conflates phones, tablets and laptops. Sensor or booking data at the workstation level is the closest proxy for actual desk demand, but it requires either physical occupancy sensors or a mandatory booking policy.
The methodology here treats seat-level occupancy as the gold standard. If your organization does not yet have that signal, badge entry data corrected for a utilization factor is a defensible substitute. The utilization factor accounts for the gap between building presence and desk use — in a building with open-floor seating, a hypothetical example might assume 80 percent of badge holders are actively at a workstation at any given moment, though your own observation data should anchor that factor.
Defining attendance also requires a time window. A single week of data tells you almost nothing about structural patterns. A minimum of eight to twelve consecutive working weeks, excluding major holidays and atypical events, produces enough variation to distinguish regular behavior from noise.
Structuring the Data Collection Phase
The data collection phase has three layers: scope, granularity and cadence. Scope defines which floors, wings or zones are being studied. Granularity defines whether you are measuring at the building level, the floor level or the workstation cluster level. Cadence defines how often the measurement is taken — hourly, half-daily or daily.
For desk-sharing purposes, the most useful granularity is the floor or neighborhood zone level, measured at multiple points through the working day. A daily badge count gives you a headcount ceiling; hourly or half-hourly occupancy readings give you the demand curve. The demand curve is what actually drives the ratio, because peak simultaneous presence is what determines whether desks run out.
Daily totals mask intraday variation that matters enormously in practice. An organization might show 60 percent of its workforce in the building across the full day, but if 80 percent of those arrivals land between 9 a.m. and 11 a.m. and all leave by 4 p.m., the peak simultaneous occupancy during the morning window might be 55 percent, making the design constraint different from what the daily number suggests.
Collect data by day of week in addition to by date. Day-of-week patterns are almost always the dominant variable in hybrid environments. Tuesdays, Wednesdays and Thursdays consistently show higher presence than Mondays and Fridays across a wide range of organizations, though the magnitude of that skew varies and should never be assumed without measurement.
Calculating Peak Simultaneous Occupancy
Once you have several weeks of data, the core calculation is peak simultaneous occupancy, expressed as a percentage of the total headcount assigned to that space. This is distinct from average daily attendance, which is the number most commonly cited in workforce announcements.
To find peak simultaneous occupancy, take each day's highest intraday occupancy reading and record it as a share of total assigned headcount. If a floor is assigned to 200 people and the peak sensor reading on a given Tuesday is 142 people present at 10:30 a.m., peak occupancy for that day is 71 percent. Repeat this for every day in the observation window.
From the resulting distribution, the design threshold is typically derived from the 90th or 95th percentile of observed peak days, not the absolute maximum. Using the absolute maximum risks designing for a one-time event — a company all-hands or a town hall — that inflates the footprint for the other 249 working days of the year. The percentile choice is a deliberate policy decision that the real estate team should document and get stakeholder sign-off on before it drives a lease decision.
The 90th percentile threshold means the space will be adequately supplied with desks on nine out of ten peak days, with modest overflow on the highest-demand days. Teams that have conference rooms, collaborative booths or focused work pods can partially absorb that overflow into alternative work settings, which reduces the pressure on workstation count.
Adjusting for Role and Team Heterogeneity
A single building-level ratio conceals enormous variation across business units, functions and seniority levels. Sales teams, client-facing functions and roles that require specific equipment tend to show very different attendance distributions from knowledge workers in primarily virtual roles.
The correct approach is to calculate a ratio for each distinct population and then blend them into a floor- or building-level number weighted by headcount. A hypothetical scenario illustrates the point: if a finance team of 50 shows 85th-percentile peak occupancy of 68 percent and a technology team of 100 shows 85th-percentile peak occupancy of 38 percent, their weighted blended rate is roughly (50 × 68% + 100 × 38%) / 150, which works out to approximately 48 percent. Each population is driving a different ratio, and designing to the blended number without understanding the composition will misplace desks relative to actual demand.
Role heterogeneity also matters for desk type. Workers who bring physical materials, specialized peripherals or who conduct video calls requiring acoustic separation have needs that a standard workstation does not fully address. When calculating how many workstations of each type to include in the program, the ratio for specialty stations should be derived from that specific population's peak occupancy, not the blended average.
Managers and senior leaders introduce another adjustment. Many organizations provide enclosed or semi-enclosed spaces for people managers, reducing the shared-desk pool available to individual contributors. Mapping those assignments before computing the ratio prevents an error where designated spaces are counted in the shared inventory and inflate the apparent supply.
Factoring in Planned and Unplanned Variability
Attendance is not static. It shifts with organizational headcount, hybrid policy changes, seasonal rhythms and strategic decisions like team relocations or department expansions. A ratio calibrated on a twelve-week snapshot will drift if the workforce or its behavior changes materially.
Planned variability includes growth or contraction in headcount, changes to hybrid work policy and scheduled events like trainings or client days that concentrate attendance. These can be incorporated as scenario inputs to the ratio model. If the organization plans to grow by 20 percent over the lease term, the ratio must either absorb that growth or the footprint must expand at a future point, and both outcomes should be modeled before the lease is signed.
Unplanned variability is harder to anticipate but can be bounded. Historical analysis of attendance data across comparable organizations shows that peak-day occupancy rarely exceeds the 95th-percentile threshold by more than a few percentage points, assuming the hybrid policy does not change. Building a small buffer into the ratio — sometimes called the safety margin — guards against that tail risk without requiring a material increase in the footprint.
The safety margin is not the same as a vacancy allowance. A vacancy allowance is the fraction of the portfolio held deliberately empty for growth. The safety margin is an operational buffer added to the peak occupancy number before computing the desk count. The two should be sized and documented separately so that decision-makers understand what each one is buying.
Translating Occupancy Percentage Into a Desk Count and Ratio
With a percentile-based peak occupancy figure and a safety margin established, the desk count calculation becomes straightforward. The formula is: required desks = (assigned headcount × peak occupancy percentile) × (1 + safety margin).
Using hypothetical numbers: 300 assigned workers, a 90th-percentile peak occupancy of 60 percent, and a 5 percent safety margin produces 300 × 0.60 × 1.05 = 189 desks. The desk-sharing ratio is then 300 ÷ 189 = 1.59:1, meaning approximately 1.6 workers per desk.
The ratio should then be validated against operational constraints before it becomes a brief. Constraints include the minimum aisle width and exit-access requirements under fire code, the number of power and data drops per zone, the number of lockers or storage units required when workers lack assigned desks, and the acoustic capacity of the floor plate. Any one of these constraints might require the desk count to increase above what the occupancy math alone would suggest, which effectively tightens the ratio.
The validated desk count feeds the space program, which in turn drives the size requirement in square feet. Multiplied by an appropriate density factor — typically expressed as rentable square feet per workstation — the desk count produces a usable area target that the site selection brief can carry forward. That brief should state the ratio explicitly so that landlords, architects and project managers are working from the same number.
Building the Scenario Model
No single ratio should be presented to leadership as a point estimate without a scenario model flanking it. The scenario model runs at least three cases: a base case using the median attendance trajectory, a conservative case that assumes attendance grows toward the higher end of the observed distribution, and an aggressive case that assumes attendance stays flat or declines.
Each scenario produces a different required desk count and therefore a different lease size. Presenting the spread gives decision-makers a clear view of how sensitive the footprint is to shifts in attendance behavior. It transforms the desk-sharing ratio from an engineering output into a strategy input.
The scenario model should also include a lease economics comparison across the cases. If the conservative scenario requires 20,000 more square feet than the aggressive case, the incremental annual rent cost can be calculated and weighed against the operational risk of under-providing desks.
Scenario outputs should be expressed in terms leadership already tracks — total annual occupancy cost, cost per seat and cost per square foot — so that the desk-sharing ratio connects visibly to financial performance rather than remaining an abstract facility metric.
Governance and Validation Before the Decision
A methodology is only as defensible as its documentation. Before the desk-sharing ratio influences a lease decision, renewal negotiation or portfolio strategy review, the team should produce a brief record of how it was derived: the data sources used, the observation window, the percentile threshold chosen, the safety margin applied and the population segments underlying any blended calculation.
This record serves multiple purposes. It provides a basis for challenge and improvement if circumstances change. It allows a successor team to replicate or update the analysis. And it gives the finance or audit function the evidence trail needed to treat the space program as a supported business decision rather than an arbitrary estimate.
Validation from a secondary source strengthens the record. If your occupancy sensor data can be cross-checked against meeting room booking patterns or access control logs, discrepancies worth investigating often surface. A floor that shows high badge entry but low workstation sensor activation might have a malfunctioning sensor array, an unmapped population using collaboration zones instead of desks, or a data collection error. Catching those discrepancies before the brief is published prevents a flawed ratio from propagating through the whole transaction.
Embedding the Ratio Into the Portfolio Decision
The desk-sharing ratio does not live in isolation once it has been calculated. It is a parameter in a broader portfolio decision that considers lease expiration dates, capital expenditure obligations, geographic market conditions and the organization's long-range workforce plan. A ratio that makes sense for a 36-month lease in a market with high availability may need to be renegotiated before a 10-year renewal in a market where reconfiguration costs are significant.
For organizations managing multiple locations, the ratio should be calculated at each location separately before any attempt to establish a system-wide standard. A central office in a dense urban market may show very different attendance dynamics from a suburban campus or a regional hub. Averaging across locations to produce a single enterprise ratio obscures the site-level variation that actually drives site-level decisions.
Revisiting the ratio at defined intervals — typically aligned with lease-event milestones or annual portfolio strategy reviews — prevents it from becoming a stale assumption that no longer reflects how the workforce actually behaves. Embedding a critical-date calendar trigger ensures the review happens before it matters rather than after the lease has already been signed on out-of-date assumptions.
Communicating the Ratio to Stakeholders
The ratio needs translation for each audience that will act on it. For facilities managers, it drives the number of desks, lockers and collaborative settings in the fit-out program. For HR, it determines whether the physical environment can support the hybrid policy the organization has committed to. For finance, it is the primary lever on occupancy cost per employee. For the C-suite, it is a signal about how effectively the organization is managing its second or third largest cost category.
Communication should lead with the business problem being solved. The desk-sharing ratio exists because hybrid work has permanently changed the relationship between headcount and space demand. Explaining the methodology in terms of risk management — the risk of paying for empty desks versus the risk of turning employees away from a full floor — resonates across all these audiences without requiring them to understand the technical details of occupancy sensor data.
A well-prepared presentation of the ratio includes the scenario range, the occupancy data it rests on, the policy assumptions embedded in it, and a recommendation with a clear owner and decision timeline. That package is what distinguishes a real estate team functioning as a strategic partner from one that simply executes space requests as they arrive.
Maintaining the Ratio Over Time
The desk-sharing ratio should be treated as a living parameter, not a one-time calculation. Organizations that set it once and treat it as permanent end up with a growing misalignment between their space supply and their workforce behavior, usually noticed only when a lease event forces a reckoning.
A sustainable maintenance process involves two elements: continuous measurement and scheduled review. Continuous measurement means keeping the occupancy data collection running throughout the lease term, not just at the beginning. Scheduled review means designating a point — annually or at defined lease milestones — at which the latest data is compared to the founding assumptions and the ratio is adjusted if the drift is material.
Material drift is worth defining in advance. A change of five percentage points or more in 90th-percentile peak occupancy is a reasonable threshold for triggering a formal ratio review. Below that threshold, the existing ratio and desk count likely remain within the operational buffer provided by the safety margin. Above it, the ratio may need recalibration, which could influence a sublet strategy, an expansion negotiation or a disposition decision depending on the direction of the drift.
The discipline of translating attendance patterns into a desk-sharing ratio — rigorously, with documented assumptions and scenario modeling — is ultimately what separates real estate decisions that hold up over time from those that require expensive corrections. The methodology is not complex, but it demands the kind of structured, evidence-based thinking that characterizes mature portfolio management.
About Advantai
Advantai is a commercial real estate intelligence and operations platform operated by ADVANTAGE AI LLC, a Delaware limited liability company. It connects client relationships, property research, documents and financial decisions in one workspace for commercial real estate teams — advisers and brokerage teams, occupier and facility teams, and portfolio teams. The platform covers CRM and origination, requirements and site selection, Property X-Ray (an interactive 3D building workspace), financial modeling and comparison, document intelligence, transactions and diligence, client collaboration, and portfolio strategy with critical dates. The optional Super Agent upgrade adds specialist, source-backed research and automated scenario analysis.
Get Started with Advantai
Ready to see your next move clearly? Go to advantaico.com, click Request a demo and tell us about your next project. Prefer to start with a single project? Visit advantaico.com/getting-started to plan your first one.