Find Jobs
Hire Freelancers

Text SQL table data to populate in excel, then read back to prepare xml

€30-250 EUR

Completed
Posted over 6 years ago

€30-250 EUR

Paid on delivery
I need someone to do this project for me. Data will be available as sql table, excel, text or csv, comma delimited files Total count of columns are less than 10, so very easy to handle data tables. System will read the data, filter it as required, open a pre-designed excel sheet, start populating the data as per the filter in rows and columns. Excel sheet will have several named ranges, and same type of data may have multiple occurrences based on the currency and country data. Named range for currency and country to be added dynamically in the excel sheets. Once the provided data is populated in the excel sheets, excel will calculate it in multiple columns in each row and and there will be sub grouping of total on rows. All formulas will be provided in excel (=formula) format. After the data is populated and verified by the user, a button will read data including all source rows , calculated rows, by keeping all attributes into a text, csv or sql table and save it. The saved data then will prepare xml files in a special but very simple format. A small web page which initially will run from the localhost. Later, on I will book a domain to use it. It must be developed using ASP.Net, SQL and Excel (all latest versions). As later on I will be including in my existing project, I will require complete source code with explanation notes. All above work is being done manually, so actually it is automation of the process. There are almost 20 different sheet format but source data table is 98% the same. Once this is done, then we can go for other automation tasks. If you have ASP.Net and Excel knowledge, it is for you. Give your price and we can further discuss it on this weekend. All sample data and process will be provided after discussion.
Project ID: 15857693

About the project

14 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, As spoken to you I have created 3 milestones. I will ensure the good quality of work and I work with desired efficiency. Thanks for considering me.
€150 EUR in 22 days
4.8 (6 reviews)
3.0
3.0
14 freelancers are bidding on average €165 EUR for this job
User Avatar
p.s. I think Ms access app will be best fit here. I've coded several similar projects with Access/Exce/xml automations. Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current project very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
€250 EUR in 5 days
4.7 (36 reviews)
6.0
6.0
User Avatar
Sir, I'm Mou .I've got experience of SEO,SMM,website design & development .I read about your project I've experience about your project .If you got any doubt please take my interview. I've got many year experience SEO ,SMM, web design & web development .i give all of clients unlimited revision for projects. Please choose for project cause I'm great for this.
€111 EUR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€155 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€111 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€111 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€194 EUR in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BELGIUM
Brussels, Belgium
5.0
3
Member since May 10, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.