Spreadsheet: 36302d1234190477-count-with-countif-sumif-sumproduct-countciscostuff
Sheet: Site 1

Switch
Closet / Switch in each stack
Device Type | WS-C4503 | WS-C4503 | WS-C6506 | WS-C6506 | Cisco 7206VXR (NPE-G1) | Cisco 7206VXR (NPE-G1) | WS-C3560-48PS | WS-C3750-48TS | WS-C4948 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C3560G-48PS | WS-C3560G-48PS | WS-C3560G-48PS | WS-C3560G-48PS | WS-C3560G-48PS | WS-C3560G-48PS | WS-C2948 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C2950G-48 | WS-C3560G-48PS | WS-C3560G-48PS | WS-C2950G-48 | WS-C2950G-48 | WS-C3750-48TS | WS-C3750-48TS | WS-C3750-48TS
Module 1
Module 2
Module 3
Module 4
Module 5
Module 6
Module 7
Module 8
Module 9
Module 10
Module 11
Module 12
Module 13
Power Supply 1 (Modular Switches)
Power Supply 2 (Modular Switches)
R-Redundant/C-Combined
Ethernet Ports (Cat5/Cat5e/Cat6) | 0 | 0 | 48 | 48 | 7 | 7 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48 | 48
Not Connected | N/A | N/A | 27 | 45 | 3 | 3 | 35 | 30 | 13 | 13 | 15 | 35 | 23 | 32 | 17 | 27 | 18 | 0 | 9 | 26 | 46 | 18 | 45 | 3 | 2 | 17 | 7 | 3 | 6 | 31 | 9 | 7 | 4 | 10 | 3 | 10 | 3 | 2 | 34
[NAME]
Hardware  EOL (Y/N)
Hardware Last Day of Support (if EOL)
Alternate Hardware
HW PoE Capability (Y/N)
[NAME] (Y/N)
IOS | 12.2(25)EWA11 | 12.2(25)EWA11 | 12.2(18)SXF6 | 12.2(18)SXF6 | 12.3(14)T7 | 12.3(14)T7 | 12.2(40)SE | 12.2(40)SE | 12.2(31)SGA4 | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.2(35)SE5 | 12.2(35)SE5 | 12.2(35)SE5 | 12.2(35)SE5 | 12.2(35)SE5 | 12.2(35)SE5 | 6.4(21) | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.1(22)EA10a | 12.2(35)SE5 | 12.2(35)SE5 | 12.1(22)EA10a | 12.1(22)EA10a | 12.2(35)SE5 | 12.2(35)SE5 | 12.2(35)SE5
IOS Image File | cat4000-i9k91s-mz.122-25.EWA11.bin | cat4000-i9k91s-mz.122-25.EWA11.bin | [NAME] | [NAME] | c7200-is-mz.123-14.T7.bin | c7200-is-mz.123-14.T7.bin | c3560-ipservicesk9-mz.122-40.SE.bin | c3750-ipservicesk9-mz.122-40.SE.bin | cat4500-ipbase-mz.122-31.SGA4.bin | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | c3560-ipbase-mz.122-35.SE5.bin | c3560-ipbase-mz.122-35.SE5.bin | c3560-ipbase-mz.122-35.SE5.bin | c3560-ipbase-mz.122-35.SE5.bin | c3560-ipbase-mz.122-35.SE5.bin | c3560-ipbase-mz.122-35.SE5.bin | cat4000.6-4-21.bin | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | c3560-ipbase-mz.122-35.SE5.bin | c3560-ipbase-mz.122-35.SE5.bin | [NAME] | [NAME] | c3750-ipservicesk9-mz.122-40.SE.bin | c3750-ipservicesk9-mz.122-40.SE.bin | c3750-ipservicesk9-mz.122-40.SE.bin
Status A-Active/R-RETIRED | Retired | Retired | Retired | Retired | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Retired | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active | Active
Routing Enabled (Y/N)
Routing Protocols
[NAME] (Y-YES/N-NO)
DSCP 46 Y-YES/N-NO
Is additional Ethernet Module needed for additional 5% port capacity?
Module Part Number
Quantity
[NAME] / module / switch to be replaced (Y/N)
Module Part Number
Quantity
Number of outlets
Type of outlets
Voltage / Amperage
[NAME] (Y/N)
Supervisor Part Number
Quantity
GBIC/ [NAME] required
Module part number
Quantity
GBIC connector part number
Quantity
Replacement / Redundant power system
Quantity
Number of outlets
Type of outlets
Voltage / Amperage
Additional Switch requirement
Model Number (details in Master Parts list)
Quantity
Number of outlets
Type of outlets
Voltage / Amperage
Other action items