CCTV SWITCH CAMERA POWER ALLOCATION.xlsx

XLSX spreadsheet 69 KB Posted

Attached to
MRHS Security Camera System Replacement P State and local contract opportunity
Solicitation number
BD-26-1965-09-09-118762
Issued by
Hampden County, Massachusetts

About this file

Written by GovTribe AI ·

The file is an Excel spreadsheet titled "CCTV SWITCH CAMERA POWER ALLOCATION.xlsx" detailing power allocation and usage across multiple switch stacks in various building locations (A211, A222, B117, B218, C107, D130, E137, and MDF). The document provides a comprehensive breakdown of Power over Ethernet (PoE) switch infrastructure, listing available watts, used watts, and remaining watts for each switch stack. Each section includes detailed information about switchports, their power consumption, POE class, and maximum power capacity, with some notes indicating specific technical considerations such as transceivers, offline ports, and migration plans.

The spreadsheet appears to be supporting documentation for the Hampden-Wilbraham Regional School District's security camera system replacement project at Minnechaug Regional High School. The power allocation data suggests a detailed technical assessment of the existing network infrastructure to support the planned installation of 89 new or replacement cameras. The document reveals nuanced power management across multiple switch locations, with some switches having significant remaining power capacity and others approaching their power limits. Notably, one section mentions a new 9300X switch with 90W per port UPOE+ capability and ongoing migration of camera connections, indicating a technical upgrade and optimization of the existing network infrastructure to support the new security camera system.

View the file

Other files for this state and local contract opportunity

Other files attached to MRHS Security Camera System Replacement P, newest first.
File Type Posted
MRHS Map Floor 1.jpg JPG image
WageSchedule_20250721155655.pdf PDF
GoogleFolderLink.docx DOCX document
MRHS Map 2nd Floor_IDF.jpg JPG image
FY26MRHSCameraProjectBidDetailsWithDesign~1.pdf PDF
MRHS Map 2nd Floor-2.jpg JPG image
MRHS Map Floor 1_MDF_IDF.jpg JPG image
08122025 Minnechaug High School BOM-Full System Upgrade and Mounts.xlsx XLSX spreadsheet
Minnechaug Regional High School Full BOM Revised 08122025.pdf PDF

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

A211-STACK1

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
A211-STACK1-10370150.7219.3
A211-STACK1-2037095.5274.5
A211-STACK1-3037058.7311.3

A211-STACK2

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
A211 STACK2-1037083.5286.5
A211 STACK2-28370201.8168.2
SwitchportUsed WattsPOE ClassMax Power
Gi2/0/3115.4330
Gi2/0/4015.4330
Gi2/0/417230
Gi2/0/4215.4330
Gi2/0/4315.4030
Gi2/0/4415.4030
Gi2/0/4515.4030
Gi2/0/4615.4030

A222-STACK1

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
A222-STACK1-1037095.5274.5
A222-STACK1-21370154.1215.9
A222-STACK1-30370150.3219.7
SwitchportUsed WattsPOE ClassMax Power
Gi2/0/4615.4430

A222-STACK2

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
A222-STACK2-10370166.7203.3
A222-STACK2-20370154.2215.8
A222-STACK2-3037083.5286.5

A222-STACK3

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
A222-STACK3-10370150.7219.3
A222-STACK3-20370150.7219.3
A222-STACK3-3037093.3276.7

A222-STACK4

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
A222-STACK4-1037069.3300.7
A222-STACK3-2037068302
A222-STACK3-323370236.6133.4
SwitchportUsed WattsPOE ClassMax PowerNotes
Gi3/0/115.4030
Gi3/0/215.4330
Gi3/0/315.4030
Gi3/0/415.4030
Gi3/0/515.4330
Gi3/0/615.4330
Gi3/0/715.4030
Gi3/0/815.4030
Gi3/0/915.4330
Gi3/0/1015.4030
Gi3/0/1115.4030
Gi3/0/1215.4030
Gi3/0/1315.4030
Gi3/0/147230
Gi3/0/157230
Gi3/0/167230
Gi3/0/1715.4330
Gi3/0/220n/a30Transceiver
Gi3/0/230n/a30Transceiver

B117-STACK1

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
B117-STACK1-10370104266
B117-STACK1-2037057.3312.7
B117-STACK1-3037093.3276.7

B117-STACK2

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
B117-STACK2-10370116254
B117-STACK2-20370129.3240.7

B117-STACK3

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
B117-STACK3-10370173.4196.6
B117-STACK3-214370321.648.4
SwitchportUsed WattsPOE ClassMax PowerNotes
Gi2/0/3215.4030
Gi2/0/3315.4030
Gi2/0/3415.4030
Gi2/0/3515.4030
Gi2/0/3615.4030
Gi2/0/3715.4030
Gi2/0/3815.4030
Gi2/0/3915.4030
Gi2/0/4015.4030
Gi2/0/4115.4030
Gi2/0/4215.4030
Gi2/0/4315.4030
Gi2/0/4415.4030
Gi2/0/4515.4330

B218-STACK1

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
B218-STACK1-1037081.3288.7
B218-STACK1-20370117.3252.7
B218-STACK1-30370128242

B218-STACK2

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
B218-STACK2-10370105.3264.7
B218-STACK2-2037081.3288.7
B218-STACK2-30370161.4208.6

B218-STACK3

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
B218-STACK3-10370164.7205.3
B218-STACK3-210370154216
SwitchportUsed WattsPOE ClassMax PowerNotes
Gi2/0/1315.4030
Gi2/0/1415.4030
Gi2/0/1515.4030
Gi2/0/1615.4030
Gi2/0/1715.4030
Gi2/0/1815.4030
Gi2/0/1915.4330
Gi2/0/2015.4330
Gi2/0/2115.4330
Gi2/0/2215.4330

C107-STACK1

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
C107-STACK1-10370162.5207.5
C107-STACK1-210370207.5162.5
SwitchportUsed WattsPOE ClassMax PowerNotes
Gi2/0/3315.4330
Gi2/0/3515.4330
Gi2/0/3615.4330
Gi2/0/3715.4330
Gi2/0/3815.4330
Gi2/0/3915.4330
Gi2/0/4015.4330
Gi2/0/4115.4330
Gi2/0/4215.4330
Gi2/0/4315.4330
Gi2/0/4415.4330
Gi2/0/4515.4330
Gi2/0/460330Transceiver
Gi2/0/470330Transceiver

D130-STACK1

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
D130-STACK1-10370119.5250.5
D130-STACK1-22370170.7199.3
D130-STACK1-33370222.7147.3
SwitchportUsed WattsPOE ClassMax PowerNotes
Gi2/0/247230
Gi2/0/2515.4030
Gi3/0/2515.4330
Gi3/0/2615.4330
Gi3/0/2715.4330

D130-STACK2

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
D130-STACK2-124370306.663.4
SwitchportUsed WattsPOE ClassMax PowerNotes
Gi1/0/10n/a30Transceiver Offline?
Gi1/0/20n/a30?
Gi1/0/315.4030
Gi1/0/415.4030
Gi1/0/515.4030
Gi1/0/615.4030
Gi1/0/715.4030
Gi1/0/815.4030
Gi1/0/915.4030
Gi1/0/1015.4030
Gi1/0/1115.4030
Gi1/0/1215.4330
Gi1/0/1315.4030
Gi1/0/1415.4030
Gi1/0/1515.4030
Gi1/0/1615.4030
Gi1/0/1715.4030
Gi1/0/1815.4330
Gi1/0/1915.4330
Gi1/0/200n/a30Transceiver
Gi1/0/217230
Gi1/0/227230
Gi1/0/2315.4330
Gi1/0/2415.4330

E137-STACK1

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
E137-STACK1-10370160210
E137-STACK1-2037071.3298.7
E137-STACK1-315370231139
SwitchportUsed WattsPOE ClassMax PowerNotes
Gi3/0/915.4030
Gi3/0/1015.4030
Gi3/0/1115.4030
Gi3/0/1215.4030
Gi3/0/1315.4030
Gi3/0/1415.4030
Gi3/0/1515.4030
Gi3/0/1615.4030
Gi3/0/1715.4030
Gi3/0/1815.4030
Gi3/0/1915.4030
Gi3/0/2015.4330
Gi3/0/2115.4330
Gi3/0/2215.4330
Gi3/0/2315.4330

MDF-9300X-STACK2

CLOSET-SWITCH STACK#-SWITCH #NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
MDF-2960-STACK2(being decommissioned)737099.4270.6
SwitchportUsed WattsPOE ClassMax PowerNotes
Gi3/0/115.4030
Gi3/0/27230
Gi3/0/315.4030
Gi3/0/415.4030
Gi3/0/515.4030
Gi3/0/615.4030
Gi3/0/715.4030
Some cameras POE are not working with new 9300X switch so they were left on old 2960 switch. New 9300X switch has 90 W per port UPOE+.
Cameras connected to above switch will be migrated to switch 3 below.
NUMBER OF CAMERASAvailable (Watts)Used (Watts)Remaining (Watts)
MDF-9300X-STACK2-1060092508
MDF-9300X-STACK2-2057076.3493.7
MDF-9300X-STACK2-3757022.7547.3
SwitchportUsed WattsPOE ClassMax PowerNotes
Te3/0/190
Te3/0/290
Te3/0/390
Te3/0/490
Te3/0/590
Te3/0/690
Te3/0/790

File details come from the government source that posted it. Updated .