Spreadsheet: 47f548a8-182d-43a3-855a-ab0dcf5d1f21
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 | 5847 |  | 1 | 0.2 | 0.2 |  | Enter PENETRATION RATE for each SERVICE
Fire | 5114 |  | 1 | 0.2 | 0.2 |  | in each User CATEGORY  (between 0.0 and 1.0)
EMS/Paramedic | 2371 |  | 1 | 0.2 | 0.2
General [NAME] | 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 | 13332 |  | 13332 | 2666.400000000001 | 2666.400000000001
 | Users per cell |  | 400.3361855628905 | 80.06723711257811 | 80.06723711257811
 | Population Density (pop/km2) |  | 1.309 | 2.149282605191037 | 2.149282605191037
 | Spectrum Required (MHz) |  | 16.65924276071106 | 0.2894263112590987 | 0.01248435950016843
Narrowband Spectrum | 16.96115343147033 | 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" | 6203 | km2 |  |  |  |  | Site/Cell radius dependent upon
Average NB site/cell radius | 7.7 | 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 | 186.2650284313389 | km2 | 33.30201086183257 | sites/cells required |  |  |  | System Design & Technology Choice
"H" = Hex sites/cells | 154.154 | km2 | 40.23898179742335 | sites/cells required
"S" = 3 sector hex cells | 51.38466666666667 | km2 | 120.71694539227 | 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" | 6203 | km2
Enter site/cell type = O, H, or S | O
Enter sites/cell radius | 7.7 | km | A3 | Representative cell area and geometry for each operational environment type
Calculated site/cell area | 186.2650284313389 | km2
Calculated number of sites/cells to cover "Study Area" | 33.30201086183257
 |  |  |  |  |  | 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 | 35.1 | MHz | Enter spectrum available for narrowband
 |  | 17.55 | 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
 |  | 1404 | FDD channels within band
% of spectrum not used for traffic channels | 5 | % | 1755 | kHz |  | usually  0 to 10%
 |  | 70.2 | Guard Band & Reserved channels |  |  | channels used for Guard Band, [NAME], Direct Mode,
 |  | 1333.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
 |  | 66.85714285714286 | FDD channels per cell
Cell capacity |  | 609.7356185142856 | kb/sec/cell
Total capacity available |  | 34.74277028571428 | 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) | 7.7
Study Area (km2) | 6203
Cell Area (km2) | 186.2650284313389 |  | (calculated)
Cells per Study Area | 33.30201086183257 |  | (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.05019996944444444 | 0.003020100000179167 | 0.0001539131944444445
Busy Hour Call Attempts |  |  | 13 | 5.183 | 2.375
Effective Call Duration |  |  | 13.90153 | 2.097696315 | 0.2333
Activity Factor |  |  | 1 | 1 | 1
 |  |  | downlink | downlink | downlink
Erlangs per Busy Hour |  |  | 0.02426203138611111 | 0.0057013 | 0.0002222830555555556
Busy Hour Call Attempts |  |  | 6.283 | 5.183 | 3.43
Effective Call Duration |  |  | 13.90153 | 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