Home

NetworkingUDF Add-In

Add-In for MS Excel that contains functions related to networking. The list of functions with short descriptions is below.

Ip2Bin(IP)

Takes IP as input and returns binary

Bin2Ip(BinaryIP)

Takes 32 bit number and return coresponding IP (4 decimal numbers delimited by dot)

isValidIP(IP)

Returns True if the given IP is Valid IP. 4 decimal numbers in range 0-255 separated by dot

isValidMask(Mask)

Returns True if given IP is valid Mask. Valid IP which in Binary is string of consecutive 1s folowed by consecutive 0s

isValidCIDR(CIDR)

Returns True if input is valid CIDR notation IP/Mask where ex: 10.0.0.0/8

isPrivate(IP)

Returns True if IP is in private range

ReverseIP(IP)

Returns reverse IP. Ex: 140.255.15.10 -> 10.15.255.140

networkIP(IP, Mask)

returns network IP corresponding to IP and Mask combination

broadcastIP(IP, Mask)

returns broadcast IP coresponding to given IP and Mask combination

MinHost(IP, Mask)

Returns first host in given network

MaxHost(IP, Mask)

Returns last host in given network

CIDR(IP, Mask)

Returns IP and Mask in CIDR Notation. Ex: 10.0.0.0/8

CIDR2Mask(CIDR)

Returns the Mask coresponding to mask in CIDR Notation. Ex: 10.0.0.0/8 -> 255.0.0.0

Hostname(FQDN)

Return hostname of given FQDN

Domain(FQDN)

Returns domain of given FQDN