Spreadsheet: 38463420-86d3-4d67-9b6b-6fac81b62d6b
Sheet: Sheet1

Narrowband Spectrum Requirements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Only cells in RED can be edited | Unnamed: 8 | Unnamed: 9
Narrowband | Number of |  |  | Services & Penetration Rates
PPDR User Category | Users |  | NB Voice | NB Message | NB Status
Police | 1344 |  | 1 | 0.2 | 0.2 |  | Enter PENETRATION RATE for each SERVICE
Fire | 2881 |  | 1 | 0.2 | 0.2 |  | in each User CATEGORY  (between 0.0 and 1.0)
EMS/Paramedic | 1350 |  | 1 | 0.2 | 0.2
General Gov't - Utilities | 0 |  | 1 | 0.2 | 0.2 |  | Assume traffic data used is "busy hour average" loading
Civilian | 0 |  | 1 | 0.2 | 0.2 |  | per PPDR User
Police - Traffic Control | 0 |  | 1 | 0.2 | 0.2
Police - Other (SWAT) | 0 |  | 0 | 0 | 0 |  | Penetration Rate would be % of "active users" during
Federal | 0 |  | 0 | 0 | 0 |  | Busy Hour using that service
Robotic Devices | 0 |  | 0 | 0 | 0
Other (Helicopter) | 0 |  | 0 | 0 | 0
Total NB PPDR Users | 5575 |  | 5575 | 1115 | 1115
 | Users per cell |  | 307.5395793461474 | 61.50791586922949 | 61.50791586922949
 | Population Density (pop/km2) |  | 1.309 | 0.1087698761096478 | 0.1087698761096478
 | Spectrum Required (MHz) |  | 6.837199108674209 | 0.2223382477683806 | 0.009590526181612737
Narrowband Spectrum | 7.069127882624203 | MHz
Use calculator to determine the effects of changing site/cell radius and layout on number of sites required to cover study area
Site/Cell Geometry Calculator |  |  |  |  |  |  | Geographic/Environment Considerations
Area of "Study Area" | 51255 | km2 |  |  |  |  | Site/Cell radius dependent upon
Average NB site/cell radius | 30 | km |  |  |  |  |  | Density = dense urban, urban, suburban, rural
 | area of each site/cell/sector |  | minimum number of cells to cover study area |  |  |  |  | Mobility = in-building, pedestrian, vehicular
"O" = Omni sites/cells | 2827.433388230814 | km2 | 18.12774801816688 | sites/cells required |  |  |  | System Design & Technology Choice
"H" = Hex sites/cells | 2340 | km2 | 21.90384615384615 | sites/cells required
"S" = 3 sector hex cells | 780 | km2 | 65.71153846153847 | sectors required
Choose parameters for modeling |  |  |  |  |  |  | When "number of cells to cover study area" is low,
- entry here automatically updates the calculation sheets (NB Calc) |  |  |  |  |  |  | make sure there are sufficient number of cells to actually
Narrowband Site/Cell Geometry |  |  |  |  |  |  | cover the geographic area
Area of "Study Area" | 51255 | km2
Enter site/cell type = O, H, or S | O
Enter sites/cell radius | 30 | km | A3 | Representative cell area and geometry for each operational environment type
Calculated site/cell area | 2827.433388230814 | km2
Calculated number of sites/cells to cover "Study Area" | 18.12774801816688
 |  |  |  |  |  | Typical Re-use Patterns
Frequency Re-Use Pattern |  |  |  |  |  | 12 = wide-area system design, portable only, w/o power control
Sites/cells in re-use pattern | 21 |  | B8 | Group Size |  | 21 = wide-area system design, mixed portable & mobile, w/o power control
 |  |  |  |  |  | Typical Grade-of-Service Multipliers
Grade-of-Service |  |  |  |  |  | 1.5 = typical multiplier for PPDR systems to ensure capacity
Traffic Multiplier | 1.5 |  | B8 | Grade of Service |  |  | to handle peak load traffic
 |  |  |  |  |  | 1.1 to 1.2 = multipliers used for commercial systems
Narrowband Net System Capability
Total width of frequency band | 3.6 | MHz | Enter spectrum available for narrowband
 |  | 1.8 | MHz |  |  | each for outbound or inbound channel sub-bands
 | FDMA | Select "TDMA" or "FDMA" technology
Channel bandwidth | 12.5 |  | kHz |  |  | displays 12.5 for FDMA and 25 for TDMA
 |  | 144 | FDD channels within band
% of spectrum not used for traffic channels | 5 | % | 180 | kHz |  | usually  0 to 10%
 |  | 7.2 | Guard Band & Reserved channels |  |  | channels used for Guard Band, [NAME], Direct Mode,
 |  | 136.8 | available traffic channels |  |  | Talk-around, Interoperability, etc
traffic/channel |  | 1 | slots/channel |  |  | displays 1 for FDMA and 4 for TDMA
data/channel |  | 7.2 | kbps/slot
overhead & signalling |  | 1.33333 | overhead factor
 |  | 9.599976 | kbps raw rate per slot/channel
raw bit rate per channel |  | 9.599976 | kbps
re-use group factor | 21 |  | frequency re-use pattern selected above
 |  | 6.857142857142857 | FDD channels per cell
Cell capacity |  | 62.53698651428572 | kb/sec/cell
Total capacity available |  | 34.74277028571429 | kbit/sec/MHz/cell |  |  | Capacity on outbound or inbound channel
 |  | 0.03474277028571428 | Mbit/sec/MHz/cell |  |  | C5 | Net System Capability for Technology and [NAME] chosen
Summary of other Parameters used:
Environment | urban pedestrian
Cell Radius (km) | 30
Study Area (km2) | 51255
Cell Area (km2) | 2827.433388230814 |  | (calculated)
Cells per Study Area | 18.12774801816688 |  | (calculated)
Net User Bit Rate | 9.599976 | kbps
 | 4.8 | [NAME], data, or image per slot
 | 2.4 | kbps forward error correction per slot
 | 2.399976 | kbps channel overhead and signalling
 |  |  | PSWAC | PSWAC | PSWAC
 |  |  | NB Voice | NB Data | NB Status
 |  |  | uplink | uplink | uplink
Erlangs per Busy Hour |  |  | 0.007328447777777777 | 0.003020100000179167 | 0.0001539131944444445
Busy Hour Call Attempts |  |  | 3.535 | 5.183 | 2.375
Effective Call Duration |  |  | 7.4632 | 2.097696315 | 0.2333
Activity Factor |  |  | 1 | 1 | 1
 |  |  | downlink | downlink | downlink
Erlangs per Busy Hour |  |  | 0.046310500002125 | 0.0057013 | 0.0002222830555555556
Busy Hour Call Attempts |  |  | 6.283 | 5.183 | 3.43
Effective Call Duration |  |  | 26.53474455 | 3.96 | 0.2333
Activity Factor |  |  | 1 | 1 | 1
Group Size | 21
Grade of Service Factor | 1.5
Net System Capacity | 0.03474277028571428 | kbps/MHz/cell
Alpha Factor | 1
Beta Factor | 1