Blog

Project Title: Checking Clean and Corrupt Files Project Description: I have a requirement to check files are clean and those which have to been corrupted (.xls, .xlsx, .doc, .docx files). A simple workflow that looks for files on the source folder, validates them by opening and closing. Successful Open and Close will be moved to ‘Checked’ folder, corrupt ones i.e. ones that cannot be opened,…

Project Title: Data-set Appending and Cleaning Project Description: I have two data sets, 1. A list of suburbs with other information 2. Suburbs with corresponding postcodes. I need to match the suburbs (suburbs sheet) with postcodes on another sheet (postcode list). Both are contained in the attached excel work book. Some of the names will not be a perfect match as there might be a…

Project Title: Excel Data De-duplication, Merging and Cleaning Project Description: I have 120 Excel documents with customer contact information I would like merged into one master document. Each document has around twelve columns and a combined total of around 1M rows. There are many duplicate entries within these documents in which I need to match all the duplicates up and complete the entry with as…

Project Title: Data Organizing and Processing Service Project Description: We’re looking for a data processing specialist to transfer Data from Excel files to Database CRM. We want a long term relation, someone to help the Customer Success Team. Deliverable: – Transfer customer data from Excel Files into Customer Database CRM – Compile and organize customer data into one standardize CSV File ready for CRM Importation…

Project Title: Cleaning Client Contacts Database Project Description: I am looking for assistance with cleaning a database of around 600 client contacts. I need assistance with checking details for accuracy and then working to source accurate contact details (email and telephone number) where possible. The list consist of clients who have bought a financial services product from my client in recent years. Some contact may…