已完成

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

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.

技能: 数据处理, Excel, VB.NET, Visual Basic, Visual Basic的应用程式

查看更多: vba sort column a to z, excel vba sort column descending, excel vba sort column alphabetically, excel vba autofilter sort ascending, how to create a sort macro in excel, vba sort column ascending, excel vba sort data multiple columns, vba sort key, visual basic data grid sort, data mining online poker project, data list sort, excel vba look data sheet, home based data entry form filling project bangalore, excel vba refresh data moves right, vba extract data closed file, msaccess vba gather data web site, vba format data series, vba import data project, vba import data project excel, excel vba read data project

关于此雇主:
( 1条评论 ) London, United Kingdom

项目ID: #17334751

授予:

£400 GBP 在7天内
(752条评论)
7.8

5 威客就此工作平均出价 £421

schoudhary1553

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 h 更多

£600 GBP 在5天内
(270条评论)
7.5
£250 GBP 在3天内
(356条评论)
7.3
£555 GBP 在3天内
(6条评论)
4.1
£300 GBP 在3天内
(0条评论)
0.0