已关闭

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.

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

查看更多: 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

关于此雇主:
( 2个评论 ) London, United Kingdom

项目ID: #17225185

43 威客就此工作平均出价 £503

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

£611 GBP 在4天内
(616条评论)
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 更多

£1000 GBP 在20天内
(764条评论)
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 更多

£500 GBP 在5天内
(282条评论)
7.6
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 更多

£500 GBP 在7天内
(196条评论)
7.1
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 更多

£450 GBP 在7天内
(152条评论)
6.7
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 更多

£1500 GBP 在30天内
(119条评论)
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 更多

£444 GBP 在5天内
(81条评论)
6.7
abdolah2014

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

£444 GBP 在10天内
(38条评论)
5.3
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 更多

£400 GBP 在6天内
(48条评论)
6.0
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 更多

£432 GBP 在10天内
(67条评论)
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 更多

£555 GBP 在15天内
(70条评论)
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 在10天内
(48条评论)
5.3
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 更多

£750 GBP 在21天内
(2条评论)
5.0
£538 GBP 在20天内
(18条评论)
5.4
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 更多

£611 GBP 在10天内
(16条评论)
4.8
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 更多

£250 GBP 在10天内
(21条评论)
4.6
£250GBP 在1天里
(34条评论)
5.1
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 在5天内
(21条评论)
4.7
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 更多

£450 GBP 在10天内
(34条评论)
4.4
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 更多

£250 GBP 在5天内
(11条评论)
3.8