Find Jobs
Hire Freelancers

VBA Developer for Data Extraction, Sort and Formatting Project -- 2

£250-750 GBP

I përfunduar
Postuar over 5 years ago

£250-750 GBP

Paguhet në dorëzim
OVERVIEW: I would like to be able to complete the following project by the 8th July 2018. I will download a report daily as an xml file that will be saved with the same name. There will be two reports in total (both in the same format with the same headers), one for each location. All the below will need to be completed so that we can analyse the data for each location and the combined data for both locations. The structure of the data will be: • Parent – Category Type • Child 1 – Category • Child 2 – Product • Child 3 – Modifiers *All the above will then have a variety of data associated with it including Volume, Tax, Time Stamp etc. TASK: A macro will be needed to perform the following: 1. Open a daily XML file as mentioned above (this will be in a standard format with varying data). 2. Correlate a small amount of the data against a reference sheet (in a separate .xls file) to add in an extra column to the raw data. - All sale items have a “Category” attached to them in the xml file, we will need to attach a “Category Type” to all the categories also allowing for any new categories/Category Types being added into the reference sheet (If there is no corresponding “Category Type” in the reference sheet it should default to a “Category Type of “Uncategorised”. 3. Sort, filter and extract relevant data (indicated in the attached file “XML Map [login to view URL]”) - This will includes splitting the Product to show the modifiers (these are separated by a “+” and I have given an example in the attached file “Product Modifier [login to view URL]” 4. Produce a Daily report, with calculations, to measure selected KPIs 5. Combine the daily reports into a weekly summary 6. Create a spreadsheet that will track the weekly trends and predict the following weeks sales 7. Automate the import, sort and exporting of both daily report, weekly summary report and running trend and predictions report via a Task Scheduler VBS Script 8. Be able to pull in historic reports for back dated data NOTES: All steps to be tested and should account for error handling in the raw data. There should be a file path line in the final spreadsheet which will be used to export the reports to. I am happy to answer any questions and will be available for roughly 1-2 hours per day to work with you on this project.
ID e Projektit: 17334751

Rreth projektit

4 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
£400 GBP në 7 ditë
5,0 (811 përshtypje)
7,9
7,9
4 freelancers are bidding on average £451 GBP for this job
Avatari i Përdoruesit
Hello, I can help with you in your project VBA Developer for Data Extraction, Sort and Formatting. I have more than 5 years of experience in Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps . We have worked on several similar projects before! We have worked on 350+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
£600 GBP në 5 ditë
4,9 (311 përshtypje)
7,8
7,8

Rreth klientit

Flamuri i UNITED KINGDOM
London, United Kingdom
5,0
2
Mënyra e pagesës u verifikua
Anëtar që nga maj 27, 2018

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.