The goal at 3NY Automation Solutions is to automate the boring parts of your day, so you can spend more time doing what you love.
- Nyron Ali , Founder
The following examples demonstrate a variety of ways that work tasks can be automated or simplified. The types of tasks vary from creating reminders, creating reports, checking email, and smarter cell phone notifications.
Sending a Reminder Text
The problem
Forgetting to plug in electric car
The solution
Send a text message if the car is not plugged in
The automation
- capture a screenshot from a security camera in the garage
- crop out the bottom right corner of the camera image
- using image recognition AI, compare the cropped image against a database of images to determine if the car is plugged in
- if the car is not plugged in, send a text message at a specific time
Checking Emails
The problem
Multiple email addresses that need to be checked frequently
The solution
Setup a single point of access for all emails
The automation
- configure each email address to automatically forward to a designated main email
- configure the main email interface to be able to send as any of the desired email addresses
Laptop to Tablet
The problem
On-site employees switched from laptops to tablets to fill out forms, but the Excel spreadsheets requires frequent keyboard input to record results
The solution
Upgrade the existing Excel macro replacing the need for keyboard input with touch sensitive controls
The automation
- instead of having the user type "Y" or "N" to answer a form question, allow them to click a box that will toggle between the allowed values (and also a blank value)
- combine multiple sheets into a single sheet to allow for easier navigation with a touch screen
- by simulating keyboard input using a macro, all existing validation continues to be executed
Report Generation and Delivery
The problem
Need to send many individualized reports on a frequent basis
The solution
Automatically produce customized reports to be emailed to each individual
The automation
- starting with the full data set, run an personalized Excel macro to filter only the desired data for one individual report
- repeat this process for as many custom reports are required
- using Mail Merge, send each report to the specific recipient(s)
Context Based Text Message Sounds
The problem
Receiving too many text messages with very little substance
The solution
Play a different sound based on the content of the message, so you don't need to read every one
The automation
- using Tasker, create a profile that will be triggered when a text message is received
- if the contents of the text is just the text "yes", then play a defined "Yes" sound
- repeat this process for any number of desired phrases (e.g., "No", "OK", "Thank you/Thanks")
Mass Producing Calculations
The problem
Excel reports requires thousands of formulas entered, using the results to find bad data
The solution
Excel macro to auto generate all the formulas and highlight the results that are not desirable
The automation
- after the macro is developed, assign a hot key for the user to execute it
- when the user presses the hot key (e.g., F12), the macro gets executed and the entire spreadsheet will be processed and formatted to the desired specification
- if applicable, the resulting spreadsheet can be formatted based on the results of the formulas
