Mailing List Archive: Spreadsheet with various IPv6 tools

I have been cleaning up and reworking some old stuff of mine regarding
how to determine required address space based on sizes of sites, sizes
of different VLANs, etc. I have versions of these for IPv4, IPv6 using
actual network sizes, and IPv4 using a /48 prefix or smaller for every
site. I also included some other IPv6 related examples that I've shared
various places in the past to help folks making the transition from IPv4
understand things like nibble boundaries, sparse allocation, etc.

If you are interested I would love to get your thoughts and opinions on
any or all of these. My plan is to share them more widely at some point
in the near future, but I've been staring at them for so long now that
it's time for new eyes. :)

The formatting is still a bit rough, I need to polish/test in MS Excel
once I'm comfortable with the content. It should work in LibreOffice
now, as that's what I've been using.

Thanks,

Doug

https://dougbarton.us/IPv4%20and%20IPv6%20Network%20Structure%20Planning-20190519.xls

It loads fine in Excel 2016 although some of the columns are a bit narrow.

It is always interesting to see a different direction to come at a problem.

It really helped me understand IPv6 subnetting when I built the HaCi
https://sourceforge.net/projects/haci/ IP tracking server and put my
IPv6 subnets into it. Seeing the subnets graphically expanded helped
a lot.

I think your spreadsheet could serve as the base of a large poster of
IPv6 subnetting that would be a useful training aid.

Ted

On 5/19/2019 5:10 PM, Doug Barton wrote:
> I have been cleaning up and reworking some old stuff of mine regarding
> how to determine required address space based on sizes of sites, sizes
> of different VLANs, etc. I have versions of these for IPv4, IPv6 using
> actual network sizes, and IPv4 using a /48 prefix or smaller for every
> site. I also included some other IPv6 related examples that I've shared
> various places in the past to help folks making the transition from IPv4
> understand things like nibble boundaries, sparse allocation, etc.
>
> If you are interested I would love to get your thoughts and opinions on
> any or all of these. My plan is to share them more widely at some point
> in the near future, but I've been staring at them for so long now that
> it's time for new eyes. :)
>
> The formatting is still a bit rough, I need to polish/test in MS Excel
> once I'm comfortable with the content. It should work in LibreOffice
> now, as that's what I've been using.
>
> Thanks,
>
> Doug
>
> https://dougbarton.us/IPv4%20and%20IPv6%20Network%20Structure%20Planning-20190519.xls
>