Monitor your IP with Microsoft Excel
Вставка
- Опубліковано 3 гру 2022
- How to monitor your ip addresses using Microsoft Excel
Ping & Response Time Function docdro.id/slPD5MN
Nice T-shirt for you have-fun-2.creator-spring.com
Dream 600K Sub / netvn82
#netvn #pingpong #ping #excel #microsoftexcel
Excellent and perhaps one of the best video related to the topic with crystal clear instruction. Highly appreciate the content.👏👏👏
Hey everyone, so I've successfully recreated the report from the video, and it works! Though it is not without its flaws. When sending a ping command to a network device, it is not uncommon for that device to occasionally fail to acknowledge the ping, and thus in my observations, devices that I knew were online would sometimes show as down on this report. With that being said, I think that I identified a simple solution, I added a bit of redundancy to the formulas in columns D & E, they are as follows... =IF(ping(C3),"Up",IF(ping(C3),"Up","Down")) and =IF(ping(C3),rsp_time(C3),IF(ping(C3),rsp_time(C3),"")). Essentially, the formulas return the status & response time if the ping was successful just like in the video, however, if the ping was unsuccessful, it will ping a second time to validate the first attempt at which point, if it failed to ping a second time, it would return the value "Down". I observed significant improvements with this method, and you will not experience false occurrences of the report showing online devices being offline. Hope this helps some of you!
Obrigado por re-upload este vídeo, o anterior eu não encontrava mais🙇🏻♂️♥️
Thank you brother, i am admin (technical officer) of it department, its help me a lot, thank you again
Excelent vídeo. Congratulations.
Hay quá Ad ơi. Nhiều khi tốn mớ tiền lại không bằng mấy thứ free ngay trước mắt 😂
Excellent tutorial. Once of the best & useful.
Thanks.. How we could extend this feature to create a log of every minute of status and latency?
Awesome. Thank you!!!!!!
Wow, I had no idea that Excel could be used for programming. 👏👏
love this, is there a way to add it to a dashboard? thinking as a smart home integration
Use uptime Kuma instead , much easy ,fancy and can alert you.
Thank you sir, you are the universal god of excel, for being generous sir.
Want more videos on excel ❤
Great! My friend.
Great Learning, ^hank you Sir.
Excelllent!! Brillant!!
Great 👍
Como obtener un valor en excel que mando por ip desde una balanza? Gracias
Hello friend, do you have a video tutorial about how to install windows from one laptop to another computer? If you have it please share a link