Inspiration
Once we started working from home, our daily video stand-up ran into internet speed issues. Teammates would complain about the internet speed and we had to turn off the camera or drop and join back. Most of the team faced issues while having screen share meetings because of a drop in audio and video quality.
Eventually, many of us realised that we need to switch to a different provider, upgrade our plan or change our meeting to a different time of the day. The solution was to have the speed data statistics over time and other analysis done regarding internet speed. Our project theme is Employee Care & Productivity.
What it does
- Recommends if current internet speed plan works for the customer.
- Suggest upgrade plan details from the same provider.
- Provides top 5 alternate internet providers and plans based on the customer’s zip code.
- Checks if any unknown devices are stealing the wifi.
- Reports the number of devices connected to wifi every hour.
- Proposes the best and worst time for download and upload in 3 distinct shifts.
- Notes the highest and lowest download and upload speed over a fixed period.
- Summarizes the information in tables, graphs and emails to the customer in a readable format.
How we built it
- Bot logs into customer’s internet provider account to capture speed plan and customer’s zip code details. For the botathon we have designed a UI for internet service provider website using google sites Truefast
- Configurable bot will perform the speed test by running every 30 minutes over a period of 1 to 3 days and capture the download and upload speed.
- The captured date will be put in excel sheet for consolidation and calculation.
- Based on the hourly average speed collected, bot will calculate the best download and upload speed in 3 distinct shifts and generate a graph (please check the email in the video).
- Speed is deemed acceptable if the average speed is above 80% (configurable) of plan speed.
- Bot emails the user if the internet speed is acceptable.
- Bot will search for top 5 internet providers and plans based on the customer zip code. This is done by logging into Broadband Search website and searching the best internet providers for the extracted zipcode.
- Scheduled bot will log into software “Who is on my wifi” and identify any unknown/suspicious devices is stealing the wifi and number of devices connected.
- Reducing the number of devices connected to wifi will help in improving the speed. Bot will generate a graph on number data connected for the desired time interval.
- Email the consolidated data to the customer after the scheduled processes are completed.
Challenges we ran into
- Design solution on how to develop a configurable bot which can capture internet speed over 1 to 3 days.
- We spent time in figuring out how to test the prototype without waiting for scheduled bot.
- Explain the complete process and feature in less than 3 minutes in a video. It was a tough to decide on what features should we include and what feature should we drop from the timed video.
- Applying excel formulas for calculation.
Accomplishments that we're proud of
- Come up with an idea for a common problem and then add various features to it.
- Started as a novice RPA developer for A2019 version but this botathon has encouraged us to explore more in Automation Anywhere.
- Providing different options to the customer to make him aware of all possible issues and fixes.
- Configurable design.
What we learned
- Exploring the advance options of A2019 and Microsoft excel.
- Botathon is a fun way to learn and give us liberty to implement ideas and explore the tool.
- Decision making and problem solving.
What's next for Internet Speed Analyzer
- In case the speed issues are found, request a router reset time to the customer.
- Bot to reset the router from command prompt.
- Check the internet latency.
- Provide online tips on how to improve the internet speed.
Log in or sign up for Devpost to join the conversation.