Đã Đóng

VBA Developer for Data Extraction, Sort and Formatting Project

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.

Kĩ năng: Xử lí dữ liệu, Excel, VB.NET, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: functional specification project overview, visual basic data grid sort, data mining online poker project, how to sort data in excel 2010 using vba, sort numbers vba, sort worksheet vba, how to sort data in pivot table vba, how to do sorting in vba, vba code for sorting data in excel, sort with headers vba, sort special vba, data entry, software development, data processing, software architecture, excel, visual basic, visual basic for apps, microsoft excel, data list sort

Về Bên Thuê:
( 2 nhận xét ) London, United Kingdom

ID dự án: #17225185

44 freelancer đang chào giá trung bình £500 cho công việc này

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Thêm

£611 GBP trong 4 ngày
(605 Nhận xét)
8.3
cgullapalli

HI, I am good at Excel and VBA. I have reviewed the requirements in brief. Looking forward to discuss in details with the excel files provided. I can contribute 2 hours daily on this and discuss on the requiremen Thêm

£1000 GBP trong 20 ngày
(755 Nhận xét)
7.8
schoudhary1553

Hello, I can help with you in your project VBA Developer for Data Extraction, Sort and Formatting Project. I have more than 5 years of experience in Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for App Thêm

£500 GBP trong 5 ngày
(271 Nhận xét)
7.5
cugamelover

I read your requirements carefully and I confirm that I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data import from other Excel files a Thêm

£500 GBP trong 7 ngày
(196 Nhận xét)
7.1
katilinas

Dear Employer, I'm ready to work on "vba developer for data extraction, sort and formatting project" project. I have 5 years experience in Visual Basic, Excel, Visual Basic for Apps. 1500 GBP - proposed project bu Thêm

£1500 GBP trong 30 ngày
(119 Nhận xét)
6.4
zekovicm

Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within th Thêm

£444 GBP trong 5 ngày
(80 Nhận xét)
6.7
paris2785

Hello! My name is Paris Pallas and just had the chance to read your project's brief. I was very excited that you mention Excel because this is my favorite field and Excel projects are among tasks I work with regular Thêm

£450 GBP trong 7 ngày
(148 Nhận xét)
6.7
satishtl

- Went through the descirption. and the files. “XML Map [login to view URL]” Product Modifier [login to view URL]” [login to view URL] Daily [login to view URL] - Can get the data from the XML files for both locaitons includi Thêm

£400 GBP trong 6 ngày
(47 Nhận xét)
5.9
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Thêm

£432 GBP trong 10 ngày
(67 Nhận xét)
5.7
royalcalif

Here my suggestion, we can do your all requirements in MS ACCESS with VBA. If you wish to do this with Excel I will do it. But the access will fulfill your needs with a professional look. Hi Mr. Employer I have lot of Thêm

£555 GBP trong 15 ngày
(69 Nhận xét)
5.3
abdolah2014

Hi I am an excel-vba Expert and I can finish your project so fast start the chat discuss more . ....................................................................................................................

£444 GBP trong 10 ngày
(38 Nhận xét)
5.3
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

£555 GBP trong 10 ngày
(44 Nhận xét)
5.2
tudiptechnology

Hi there, Thank you for going through my proposal. We have 7+ years experience on freelancer in various domains. We have proven track record of delivering C#/.Net web applications with AngularJS front end. Also Thêm

£750 GBP trong 21 ngày
(2 Nhận xét)
5.0
£538 GBP trong 20 ngày
(18 Nhận xét)
5.4
£250 GBP trong 1 ngày
(34 Nhận xét)
5.1
vinod150987

Hi Hope you well ! I am Vinod Kumar. I am working as Senior Software Developer in IT company. I have 4 + years experience in .NET with C#,VB,ASP.NET, Web Service, WCF, Javascript, JQuery, SQL, XML ,XSLT and HTM Thêm

£611 GBP trong 10 ngày
(16 Nhận xét)
4.8
vmadhavan15

I am not a random bidder.. Please check my profile to know more about me and my projects... Please ping me if you are interested with my proposal and share more details if any.. thank you.

£650 GBP trong 5 ngày
(20 Nhận xét)
4.6
sloker18

I am proficient with excel macro/VBA , I've gone through the attached files, I can write the macro to convert XML report into excel for daily report as specified in your description, I am available to start your projec Thêm

£450 GBP trong 10 ngày
(32 Nhận xét)
4.4
KellogITSolution

Hello I am working with MS-Excel and VBA for the past 15 years and have completed successfully many Excel projects. I am ready to do your work and have gone through your project specifications. Give me the job, get Thêm

£250 GBP trong 10 ngày
(21 Nhận xét)
4.6
cranius

Greetings, I would to purpose the following architecture for developing your project: The final product will consist of a macro file, upon opening you will be presented with a dashboard containing data of your choi Thêm

£250 GBP trong 5 ngày
(10 Nhận xét)
3.8