In our blog A simple guide to IPv4 addressing we offered a Free Excel IPv4 Subnet Calculator which you can get by signing up below.
Check out the video to see the spreadsheet in action to get an idea of how it works.
Simply edit the IP address and subnet mask and the spreadsheet does the rest. You can see the subnet mask in dot-decimal, the subnet address, broadcast address, number of networks, number of hosts, the wildcard mask the binary and hexadecimal representations of the IP address. The spreadsheet will highlight if the range includes conflicts or other problems.
Other sheets show available subnets, address block allocations and address ranges. All this in an xlsx spreadsheet with no macros, no catches, and no problems.
If you’ve come this far, then you probably have a good use for the calculator. It’s my go-to tool for the job – you know you want to 🙂