VBA Developer for Data Extraction, Sort and Formatting Project
£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 Projekti: #17225185
Rreth projektit
36 profesionistë freelancer dërguan një ofertë mesatare prej £486 për këtë punë
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 Më shumë
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 Më shumë
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.
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 Më shumë
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 Më shumë
Hi I am an excel-vba Expert and I can finish your project so fast start the chat discuss more . ....................................................................................................................
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.
hi, I am very good in Excel vba, macro, chart etc. I have done several projects with VBA coding and if you want to see my excel VBA skills i can share with you some of my work on excel. I feel fit myself for this proj Më shumë
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 Më shumë
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 Më shumë
I read your description and saw your attached files. I have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development. I am sure i can handle your request
Dear Mardam or Sir, You need an accountant . I am the one you need . I have great experience working as an Accounting throughout my career. I have over 10 years of experience and knowledge of accounting and good skill Më shumë
I am an expert in accounting, virtal assistant having skills like Excel, Macros, VBA, Word, Quickbooks etc, with more than 10 years of experience. Please consider me for the job. Looking forward to hear from you soon.
Hi, I read your project and it seems that I can finish it I am a professional VB developer I can build you an MS access using VBA that read the required xml files parse them ,correlate data and infer reports about the Më shumë