Reads NodeDetails (NodeName, Latitude, Longitude, Combined Vendor + all columns) and MediaDetails (A-End child → B-End parent + MediaType), draws an editable map, and exports an updated workbook with your changes tagged.
Input. Opens the Media Connectivity workbook — reads NodeDetails (NodeName, Latitude, Longitude, Combined Vendor + all columns) and MediaDetails (A-End child → B-End parent + MediaType).
Map encoding. Node symbol = Combined Vendor; line colour = MediaType. Both legends refresh automatically when a new vendor or media type appears. Toggle any of them on/off in the Layers panel.
MediaType is a controlled list. Pick from the dropdown in a link; use ⚙ Manage list to add/remove allowed types so spellings can't drift. RingID (optional) groups links into a named ring; hub vs leaf is derived automatically (a node is a Hub if anything terminates on it). Two media between the same pair (e.g. OFC + MW) are kept as separate links — not duplicates — and drawn as parallel lines.
Edit on map. Turn on Edit mode (bottom-right). Drag a node to move it; click a node to edit; click a line to see its details and drag its A/B end-handles onto nodes; double-click a line to edit A/B/MediaType.
Change tracking. Export adds MediaNetwork_ChangeType (NEW / EDITED) and MediaNetwork_ChangedFields to both sheets, for reconciling against your master database.
Merge newer Excel overlays a newer workbook (updates matching nodes, adds new ones). Make Team Copy bakes the current data into a copy of this tool so the team opens it with no file selection.
🩺 Health lists data-quality issues (unresolved links, duplicates, missing coordinates) before you push to the master DB. 📝 Changes reviews everything new/edited since load. 📡 LoS fetches a terrain profile, draws the Fresnel zone, checks clearance and estimates the link budget; node popups also offer ↟ To root, ✦ Links and ◎ Range rings (click empty map to clear a highlight).
More: filter the side lists by vendor / OA / media type; use 🧰 Tools → Measure to click any two points for distance + bearing; export the network as KML (Google Earth) or GeoJSON (GIS). Crowded areas auto-declutter labels — toggle it in Layers.
Everything runs in your browser; internet is only needed for map tiles and the two libraries.