Forum Discussion

Copper Contributor

Aug 23, 2022

Solved

PoE Switch Planning

I could use some help on this. I have 3 types of network switches. An 8 port, a 24 port and a 48 port. I have several different types of IP cameras, each with their own required wattage consumption ...

Charting

Formulas and Functions

Macros and VBA

CharlesMcD27
Aug 25, 2022
mtarler That's perfect really. I'm a visual person so I'm happy to have the visual cues for when the switch is full vs being over wattage budget. So, is it difficult to populate the IP camera list with actual camera models without messing anything up? I have a list of them.

Thank you. I really appreciate your help. Just like a cleaning up a messy room, I had nowhere to begin.

CharlesMcD27

Copper Contributor

Aug 25, 2022

mtarler That's perfect really. I'm a visual person so I'm happy to have the visual cues for when the switch is full vs being over wattage budget. So, is it difficult to populate the IP camera list with actual camera models without messing anything up? I have a list of them.

Thank you. I really appreciate your help. Just like a cleaning up a messy room, I had nowhere to begin.

mtarler

Silver Contributor

Aug 26, 2022

CharlesMcD27 no it shouldn't be hard. In fact if you start in the middle and use "insert cells" and push the existing ones down then you can be pretty sure excel will adjust all the ranges for the formulas and drop down lists accordingly. Then type over or delete the existing demo lines.