November 2012

network calculations in Excel 2010

i need often to calculate network addresses, subnet-masks/bits, Hosts and more. For this i wrote this script Network.bas, which you can implement in your Excel file or your Default template book.xltm:

i implemented this functions:

  • NetworkCalculate
    • Add or subract from an IP-Address:
    NetworkBitsToSubnetmask
    NetworkBroadCastAddress
    NetworkClientHighestAddress
    NetworkClientLowestAddress
    NetworkClientRange
    NetworkSubnetAddress
    NetworkSubnetMaskToBits
    NetworkBitsToSubnetMask
add second default route to Synology NAS

Shortly i need to connect a Synology NAS to two separated networks. At default you can only define one Gateway for your Synology NAS. To define a second route, do this steps:

Activate SSH access to your Synology NAS:

configure first LAN interface:

configure second LAN interface:

configure default gateway:

Connect to NAS by ssh and configure the second route:

after configuring this, you can disable ssh access again.