Monitor your IP with Microsoft Excel
Monitor your IP with Microsoft Excel
How to monitor your ip addresses using Microsoft Excel
Ping \u0026 Response Time Function https://docdro.id/slPD5MN
================
Thanks for watching. Help me 500K subscribers / netvn82
#netvn
Content
1.28 -> hi, in this video i show you how to monitor ip devices using microsoft excel
7.168 -> Here is my spreadsheet file with some ip devices to monitor
11.776 -> This file will help me monitor devices like router, computer and tell me whether they are online or offline
18.688 -> If the ip device is online, what is its response time?
23.04 -> Microsoft Excel's menu doesn't have Developer by default so I'll add it
32.512 -> Next I open the Visual Basic window and add a new Module for this workbook
44.032 -> Then I add the commands to create the necessary functions for the network monitoring tool
50.176 -> I prepared two functions to monitor ip devices
54.272 -> I put this file in the description of the video
64.512 -> A function called ping to check if the target ip address is online or offline
70.656 -> The second function will tell me the response time of the target ip address
79.616 -> To use the above two functions I save the spreadsheet file with the extension xlsm
95.232 -> This is my spreadsheet file and you will see its extension xlsm
100.352 -> Next steps I will use this file
103.168 -> This new file will allow me to use the newly added functions to monitor ip devices
108.544 -> So how to use those functions to monitor my target ip devices?
113.152 -> First is to check if ip address 10.11.32.1 is online or offline
119.04 -> I will use IF function and Ping function to check the status of ip address 10.11.32.1
125.696 -> If this ip address is online it will return UP, otherwise it will return DOWN
137.472 -> Same for other ip addresses and i see that only ip address 10.11.32.191 is offline
145.152 -> I want to know the response time of each ip address when it is online
149.76 -> So I use the IF command and the response time function to display the response time of each ip address
165.888 -> If that ip address is offline, its response time is not displayed
180.48 -> Next I will highlight the column named status
188.16 -> If an ip address is offline, its status will be red
199.424 -> As for ip addresses that are online, their status will be green
204.288 -> So if there is an ip address that is offline, it will be easier for me to recognize because it has a different color
211.456 -> The current spreadsheet file will not automatically check the status of the addresses
217.856 -> so want to check manually I use the key combination Crtl Shift Alt F9
221.44 -> But I want this tool to automatically check the status of the devices every minute
226.304 -> So I created a new table with the list of names and ip addresses of the devices
231.68 -> Next I delete the original list of names and ip addresses
238.592 -> Instead of entering data manually I will get the data from the right table
243.2 -> I will create a new table and get information like name and ip address from the right table
265.727 -> The data will be mapped from the right table to the left table
285.439 -> Next I will set it so that every minute the data will be refreshed and this way the status of each ip address will be checked every minute
292.607 -> You can change the refresh time depending on your wish
303.615 -> As you can see every minute ip addresses are updated status once and response time is also updated every minute
310.527 -> Thank you for watching don't forget to like and subscribe
Source: https://www.youtube.com/watch?v=fcqi6Tu7DiM