Excel Automation of National SGU-Solar Data Analysis
The bot performs:
Download data from the government regulator;
Copy data from downloaded spreadsheet to the analysing spreadsheet;
Data cleansing and analysing for each state by month;
Create a chart for the analysed result.
* Screen updating is turned on to show the bot's working process (usually turned off for better efficiency).
Excel x PDF x Outlook - A Small But Handy Bot
The bot performs:
Create a PDF letter using a personalised template;
Open Outlook and write an email in a customised template;
Attach the letter to an email, display it (in this video), or send it straightaway.
* The bot can be dragged down to send bulk emails (without displaying them).
* All names and numbers are randomly generated; no real data exists.
Excel crawls Seek and then Google search each business's profile
The bot performs:
Crawl Seek for a specific position with filters;
Google search each business after crawl Seek;
If the business has Google Business Profile, then record down its phone number, address and website.
* Screen updating is turned on to show the bot's working process (usually turned off for better efficiency).
Excel Generates Journal Entries for Reckon (accounting software)
The bot performs:
Data cleansing based on existing rules;
Calculation and organising data, separate each category on individual worksheets;
Generate .iif documents that can be readily uploaded to Reckon.
* All names and data are randomly generated; no real data exists.
* Screen updating has been turned off to boost bot efficiency.