I’ve been a bit busy recently so blog traffic is a bit low

I’m workin’ on documenting a customer network, and one of the things I needed to do was calculate the number of fast Ethernet ports available on each floor. Since I have a little if & then experience from my PHP work I figured I could achieve this in excel.

Unfortunately excels if & then’s aren’t nested so this may look a little nasty.

The deal is this, I have 4 types of switches Cat 5509, 5505, 5500 or 6509. Cell B3 tells me what type of switch I have, F3 tells me whether I’m using 24 or 48 port blades, and I assume that each Cat Switch has 2 supervisor cards.

The formula breaks down like this

sadly WordPress has hidden my nesting, but hopefully this makes sense

This entry was posted on Wednesday, 17th May, 2006 at 2:33 pm and is filed under Blog. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.