Count usable switch ports after uplinks

Reserve the uplink ports

Enter total switch ports and the ports reserved for upstream links. The default 16-port and 2-uplink inputs leave 14 user ports for the device rows.

user ports = switch ports - uplink ports

The default network uses 8 device ports, leaving 6 of the 14 user ports available.

Multiply quantity by port use

Each CSV quantity consumes the same number of physical ports as devices. Access points, cameras, and doorbells remain separate rows so a change is easy to review.

device ports used = sum(quantity)

Keep class as a reference label

PoE class is carried into the table for review. Use the actual switch and device documentation for the per-port watt assumption rather than inferring draw from the class text.