Spreadsheet with various IPv6 tools

[Ted Mittelstaedt]

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
>