I am trying to create a spreadsheet that has all of my networks and subnetworks in it. My goal is pretty simple, but I can't think of a way to easily do it--
Column 1 should have something like this:
Now, I want to be able to click on the "+" sign to "open up" 10.0.0.0 with a heading to the right of:
Then, to the right of 10.1.0.0 it would be the same
and so on....
Then, I woud use the group outline menu to collapse everything
My purpose is to easily see what subnets i've used and which ones are available to allocate.
10.0.128.0 New York
10.0.160.0 1st Street
10.0.192.0 Los Angelos
I've attached a small example, but it took me a really long time to do this, there MUST be an easier way....
Thanks for the help.... OH one more thing.... I don't need a subnetting calculator -- I have several. I need to lay out my current network so that I know what subnets are available.