About this template
List your prefixes and hosts; instantly see duplicate or overlapping CIDRs, misaligned networks, orphan IPs, duplicate IPs and subnet utilisation.
What you get
IPAM-Lite-Overlap-Detection-Workbook.xlsx- Tests sheet inside the workbook: every formula checked against hand-computed answers (shows ALL n TESTS PASS)
- Read Me sheet with how-to, limits and sources
Who it is for: network and systems engineers, IT admins, students preparing for networking exams and consultants who need a reliable, auditable spreadsheet instead of an ad-hoc one.
How to use: open the workbook, type into the yellow cells, read the computed columns; red-highlighted check cells tell you what to fix. Start with the sample data, then overwrite it with yours.
What it is NOT: Not a networked IPAM (no discovery, no DHCP/DNS integration, no multi-user locking). IPv4 only. 195 prefixes and 495 host records per sheet. Uses MINIFS (Excel 2019/365 or LibreOffice 5.2+).
Verification: 51 hand-computed tests (see Tests sheet) pass; the build re-evaluates all 8507 formula cells with an independent formula evaluator and finds 0 errors. NOT opened in desktop Excel by the author: recalculates on open. Uses MINIFS (Excel 2019/365, LibreOffice 5.2+).
*Created with AI assistance and reviewed by the author.*
Questions
What file type do I get and what software do I need?
You get one Excel (.xlsx) file, IPAM-Lite-Overlap-Detection-Workbook.xlsx. It uses MINIFS, so you need Excel 2019/365 or LibreOffice 5.2+.
Can I edit the formulas, and how do I know they are correct?
The workbook has 8507 formulas across 7 sheets, and you type your data into the yellow cells. A Tests sheet checks the formulas against 51 hand-computed answers and shows ALL n TESTS PASS. The author has not opened the file in desktop Excel, and the text does not say whether the sheets are protected.
How do I start, and does it replace a real IPAM tool?
Open the workbook, start with the sample data, then overwrite it with yours and read the computed columns. Red-highlighted check cells show what to fix. It does not replace a networked IPAM, because it has no discovery and no DHCP or DNS integration.
