# Plant Switch Port Budget Worksheet > Source: https://netray.co/tools/plant-switch-port-budget-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer List devices by plant area, add growth, and get the ports required, switches needed and spare ports for each closet or cell. ## Category industry-templates ## Industry Discrete Manufacturing ## Audience - IT manager - Network engineer - Controls engineer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Area or closet **Key:** area **Type:** text #### Main device types **Key:** kind **Type:** select **Options:** - Office PCs and phones - Shop floor terminals - PLCs and HMIs - Cameras - Wi-Fi access points - Mixed #### Devices today **Key:** devices **Type:** number **Help:** Wired devices that need a port. #### Growth allowance **Key:** growth **Type:** number **Unit:** % #### Uplink and stack ports **Key:** uplinks **Type:** number #### Ports per switch **Key:** per_sw **Type:** number #### Ports required **Key:** need **Type:** number **Expr:** ceil(devices * (1 + growth / 100)) + uplinks **Format:** integer #### Switches needed **Key:** switches **Type:** number **Expr:** ceil(need / per_sw) **Format:** integer #### Installed capacity **Key:** cap **Type:** number **Expr:** switches * per_sw **Format:** integer #### Spare ports **Key:** spare **Type:** number **Expr:** cap - need **Format:** integer **Rows:** **Area:** Main office IDF **Kind:** Office PCs and phones **Devices:** 72 **Growth:** 15 **Uplinks:** 4 **Per sw:** 48 **Area:** Machine shop cell A **Kind:** PLCs and HMIs **Devices:** 18 **Growth:** 25 **Uplinks:** 2 **Per sw:** 12 **Area:** Assembly line 1 **Kind:** Shop floor terminals **Devices:** 30 **Growth:** 20 **Uplinks:** 2 **Per sw:** 24 **Area:** Warehouse and shipping **Kind:** Wi-Fi access points **Devices:** 14 **Growth:** 30 **Uplinks:** 2 **Per sw:** 24 **Area:** Plant perimeter **Kind:** Cameras **Devices:** 20 **Growth:** 20 **Uplinks:** 2 **Per sw:** 24 **Totals:** #### Total devices today **Key:** devices **Agg:** sum **Format:** integer #### Total ports required **Key:** need **Agg:** sum **Format:** integer #### Total switches **Key:** switches **Agg:** sum **Format:** integer #### Total spare ports **Key:** spare **Agg:** sum **Format:** integer **Summary:** #### Spare ports as share of capacity **Key:** spare_pct **Expr:** sum_spare / sum_cap * 100 **Format:** percent #### Average switches per area **Key:** avg_sw **Expr:** sum_switches / count **Format:** decimal **Notes:** Add PoE budget separately: total PoE watts per switch must cover cameras, access points and phones. Keep OT and IT on separate VLANs or switches, and record uplink speeds in your asset inventory. ## Content **Intro:** Port counts are the cheapest thing to plan and the most annoying to get wrong. This worksheet gives each plant area a ports-required figure, switch count and spare capacity, so the next cell or camera does not become a project of its own. **Sections:** #### How to use the worksheet **Body:** Add one row per closet, cell or area. Count the wired devices that actually need a port today, including printers, scales, barcode stations, PLCs, HMIs, cameras and access points. Enter a growth allowance based on how fast that area changes, then uplink and stack ports and the port count of the switch model you use. The sheet computes required ports, number of switches, installed capacity and spare ports. Export to Excel for purchasing and as-built records. **Bullets:** - Walk the area, do not trust old diagrams - Use higher growth for lines being expanded - Keep 20 percent spare as a starting policy #### The calculation **Body:** Ports required is devices times one plus the growth percentage, rounded up, plus uplink ports. Switches needed is ports required divided by ports per switch, rounded up, because you cannot buy half a switch. Installed capacity is switches times ports per switch, and spare ports is capacity minus ports required. The summary shows spare share overall, which tells you if the whole plant is running too tight. #### Reading the results **Body:** A spare share under about 10 percent means almost any change will force new hardware. Very high spare means you may be over-buying. Pay attention to areas with a single switch and one uplink, which are single points of failure. In cells with PLCs, consider managed industrial switches with rings or redundancy, and plan for DIN-rail power and environment ratings rather than office-grade gear. #### Common mistakes **Body:** Ignoring PoE power budgets, mixing OT and IT traffic on a flat network, forgetting ports for temporary equipment and vendor laptops, and not recording what each port connects to. Pair this sheet with a segmentation plan and a patching schedule, and update the counts whenever a line is moved or a new machine is commissioned. **Cta:** If port, device and asset data lives in separate spreadsheets, Netray can help turn it into one searchable inventory your team can query in plain language. **Faq:** #### How many spare ports should I keep? **Answer:** Many teams keep 15 to 25 percent spare per closet. Fast-changing areas like new assembly lines may need more, and static offices less. Revisit after each expansion. #### Do uplinks count against the switch ports? **Answer:** Yes, if uplinks use the same front-panel ports. Some switches have dedicated uplink ports. Enter only the uplink ports that consume ports from the total you are counting. #### How do I plan PoE? **Answer:** Add up the maximum watts of each PoE device and compare it to the switch PoE budget, not the port count. Cameras and access points can use 10 to 30 watts each, so budget can run out before ports do. #### Should OT devices share switches with office devices? **Answer:** Generally no. Separate switches or at least separate VLANs with controlled routing between them, in line with a segmentation approach such as the Purdue model, reduce risk and troubleshooting time. ## Search terms switch port calculator, network port planning spreadsheet, how many switch ports do i need, plant network port budget, idf closet port count, industrial ethernet port planning, switch capacity planning worksheet, network growth planning excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json