IP Tool Guide

 

IP Tool (Excel Macro) — Step‑by‑Step Run Guide (English)

1) What you need (Prerequisites)

  1. Microsoft Excel Desktop (Windows/Mac) is required. (Macros do not run in Excel Online / browser Excel.)
  2. The tool file must be macro‑enabled: *.xlsm
  3. When you open the file, you must allow macros by clicking Enable Content / Enable Macros (if prompted).

2) File structure (Do not change headers)

  1. Open the tool file.
  2. Go to the sheet named Input.
  3. Confirm the columns (row 1 headers) are exactly:
    Site | Hub | Network | gateway | IP

✅ Only the gateway column is mandatory input.

3) How to enter input

  1. In Input sheet, fill Column D (gateway) with values like:
    • IPv4 example: 10.71.149.94/28
    • IPv6 example: 1234:56:84:789a:0:BcA:0:a001/120
  2. You may also fill Site and Hub columns if you want (optional).
  3. Leave Network and IP columns empty — the tool will fill them in the output.

4) Run the tool (Macro)

 Run via Macro List

  1. Press ALT + F8
  2. Select the macro:
    Build_OUTPUT_With_IPv6_UserPrompt
  3. Click Run

What happens next

  • A pop‑up will ask:
    “IPv6: How many usable IPs you want?”
    Enter a number like 16 (or 32/50/etc.) and press OK.

5) Where to find the output

  1. After the macro finishes, a new sheet named OUTPUT is created.
  2. In OUTPUT, you will see the same columns:
    Site | Hub | Network | gateway | IP
  3. The tool will:
    • Fill Network automatically (network/prefix).
    • Generate IPv4 pool based on prefix rules.
    • Generate IPv6 first N usable IPs (N = the number you entered), starting from gateway+1.

✅ You can now copy the results from OUTPUT and use them anywhere.

Notes (Important)

  • Do not rename the Input sheet and do not change the header names.
  • Each time you run the macro, the tool recreates/clears the OUTPUT sheet (so keep a backup if you manually edit OUTPUT).

Troubleshooting (Quick Fixes)

A) “No output / OUTPUT sheet not created”

Cause: Macros are blocked.
Fix:

  1. Close Excel
  2. Reopen the file
  3. Click Enable Editing (if shown) and Enable Content / Enable Macros

B) Macro name not visible in ALT+F8 list

Cause: File saved as .xlsx (macros removed).
Fix: Save as Excel Macro‑Enabled Workbook (.xlsm) and reopen.

C) Company laptop shows “Macros are disabled by admin”

Cause: Organization policy.
Fix options:

  • Ask IT to allow macros for this file, OR
  • Add the folder to Trusted Locations (Excel → Options → Trust Center → Trusted Locations)

D) Wrong/blank output for a row

Cause: Gateway format incorrect or blank.
Fix: Ensure Column D has valid IP/prefix format.

  1. Open file → 2) Enable macros → 3) Fill gateway → 4) Run macro → 5) Take OUTPUT.

Comments

Post a Comment

Popular posts from this blog

  Microwave Transmission: 30 Technical Interview Questions and Answers What is the difference between TDM and Ethernet in microwave communication? Ans: TDM (Time Division Multiplexing) allocates fixed time slots for data streams, ideal for circuit-switched traffic like voice. Ethernet is packet-based, better for variable data loads and flexible bandwidth usage. What are the key layers in a microwave transmission system? Explain their roles. Ans: Key layers include Physical (signal transmission), Data Link (framing, error detection), and Network (routing). Together, they ensure reliable data delivery across microwave links. What is the difference between Line-of-Sight (LOS) and Non-Line-of-Sight (NLOS) links? Ans: LOS requires a clear direct path between antennas, offering better performance. NLOS uses reflection, diffraction, or scattering to establish connectivity in obstructed environments. How does Adaptive Modulation work in microwave radios? Ans: Adaptive Modulation dynami...
Read more
  20 important questions for L1 Network Engineers What is the OSI model, and why is it essential in networking? The OSI (Open Systems Interconnection) model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven abstraction layers. It helps in understanding, designing, and discussing network architectures. The layers include physical, data link, network, transport, session, presentation, and application. Explain the difference between TCP and UDP protocols. TCP (Transmission Control Protocol) is connection-oriented and provides reliable, ordered, and error-checked delivery of data. UDP (User Datagram Protocol) is connectionless and offers a simpler, faster, and more lightweight communication method but without guaranteed delivery. How does ARP work, and what is its purpose in networking? ARP (Address Resolution Protocol) is used to map a known IP address to a MAC address in a local network. When a device wants to communicate ...
Read more
  Q:why we have so many microwave antenna on cell tower A: Microwave antennas on cell towers serve various essential purposes, which is why multiple antennas are often installed on these towers. Here are some key reasons for having multiple microwave antennas on a cell tower: Redundancy : Redundancy is crucial in telecommunications to ensure network availability and reliability. If one antenna or link were to fail due to equipment issues or adverse weather conditions, the network can automatically switch to another antenna, minimizing service disruptions. Redundancy is especially important for critical communication services. High Capacity : With the increasing demand for data services and the growth of mobile networks, cell towers require high-capacity backhaul connections to transport large volumes of data. Multiple microwave antennas can be used to aggregate and distribute data efficiently, ensuring that the network can handle the load. Load Balancing : Multiple antennas can bal...
Read more