Find Jobs
Hire Freelancers

C# Program (MRP) for Monthly Reports from Excel Spreadsheets

$250-750 USD

Completed
Posted over 8 years ago

$250-750 USD

Paid on delivery
We have a collection of spreadsheets produced by an accounting program. Each spreadsheet has one row per Item and 10 columns of data. The spreadsheets need to be parsed into 13 columns, and made into a database. Program can either append a new spreadsheet, in which case the db is cumulative, or the db is created anew to contain all records (one per spreadsheet row) for all spreadsheets selected in the UI. To date, there are about 25 spreadsheets. First task is to write a C# program to construct the database. The program needs a simple UI to allow controlling which spreadsheets are appended, or included in the database. Second task is to provide a control on the UI which can access preformatted SQL queries from a file table, and to supply the first report for the first query.
Project ID: 8548597

About the project

38 proposals
Remote project
Active 9 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
Hi Sir/Madam. Ready to start. Thanks. Our slogan :  ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **
$250 USD in 2 days
4.9 (157 reviews)
6.4
6.4
38 freelancers are bidding on average $415 USD for this job
User Avatar
Hello I'm interesting your project very well I'm a Good C#, Java, DB, Math, Algorithm expert. I m quite well experienced in these jobs. Let's go ahead with me I want to service for you continously. Thanks
$550 USD in 3 days
5.0 (451 reviews)
8.8
8.8
User Avatar
Hi, I am VB and GIS developer and well versed in Excel and programming of Excel using VBA or even developing Add-in for Excel using VSTO of .NET. I gave also courses in Excel for UN employees here in Palestine - Gaza. The attached image is screen shot for Add-in for Excel to integrate Excel with another application called MetaTrader4 to allow the users to trade from within Excel. This project is complicated and deal with many technologies and fields like calling underlying layer for communications and graphics to have dynamic charts and link to MS Access to store the actions by the user and finally controlling MetaTrader from Excel. I am ready to discuss and doing your project. Regards, Eyad
$555 USD in 15 days
5.0 (32 reviews)
7.4
7.4
User Avatar
Hello. So If I have understood the tasks correctly, you want to create a database(probably single table) from all spreadsheets and then there will be different tab where we have control for query file browse and we can search the records in database on based on that query. My Question 1. The database should be mysql, mssql or something else?
$526 USD in 10 days
4.8 (116 reviews)
7.7
7.7
User Avatar
Hi, I am Nallakumar. I have more than 9 years of experience in C# and Excel Automation. I would suggest you the following, 1. Create a VSTO Excel AddIn using C#, that will create 2 buttons in Excel Ribbon. 2. The first button is Create DB button. Upon clicking this button will allow the user to select multiple Excel files. Upon selecting the files, the AddIn will create the Database (append, if already records are there) by manipulating the columns accordingly. 3. Generate report button. This will generate the report in another sheet as defined. This will make the work easier for user also. I am ready to create a C# Winform application also doing the above functionality. My current bid holds good either of the options. Thanks, Nalla
$631 USD in 3 days
5.0 (72 reviews)
7.4
7.4
User Avatar
Hello sir, Ref your project description we would like you to share with us the mockup of what you are looking for and possibly the excel sheet with some dummy data on it. we have a vast experience of working on various excel sheet to c# software converion system and hence we prefer to get the full requirement before putting our head in the conversation to avoid any miscommunication and waste your precious time. Looking forward to your valued response. Regards, OK Team
$789 USD in 15 days
5.0 (13 reviews)
6.2
6.2
User Avatar
Hello I am C# expert and interested in this project. I have reviewed the requirements carefully and confident to handle this project perfectly. Please communicate to discuss further. Regards Anshu
$444 USD in 7 days
4.6 (83 reviews)
5.8
5.8
User Avatar
Respected Sir / Madam i can develop the application in C# to create database(s) from excel spreadsheets and other tasks as needed Warm Regards vnb400
$250 USD in 10 days
4.8 (49 reviews)
5.4
5.4
User Avatar
Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 6+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net,Asp.net MVC - Linq to SQL,Entity Framework - Javascript,Jquery,KnockoutJS,AngularJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Facebook Graph API - Application Security Remediation - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. Thanks Nikhil Mahajan
$250 USD in 5 days
4.7 (32 reviews)
5.6
5.6
User Avatar
I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experiences over all the factors in your project.
$250 USD in 5 days
5.0 (6 reviews)
4.5
4.5
User Avatar
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end. We never failed to deliver any projects in last 4 years and hope to work in even better way on your project. Thanks Pragati Shinde
$750 USD in 15 days
4.7 (8 reviews)
4.9
4.9
User Avatar
Good evening, I have 10 year experience with software development and data migration as well. I presume you are intending to use MS SQL Server to store the data, right? I can develop your solution on time and budget, its an urgent task. Feel free to ask anything and discuss deadline/prices. Thanks.
$555 USD in 7 days
5.0 (7 reviews)
4.2
4.2
User Avatar
I have experience in solving such tasks, therefore I can do it efficiently and quickly. Hope I'll be able to help you with this task.
$250 USD in 5 days
5.0 (4 reviews)
4.1
4.1
User Avatar
Hello, We're a team with 3 software engineers. Please give me more details in private chat. Thank you!
$300 USD in 7 days
5.0 (2 reviews)
3.2
3.2
User Avatar
So based off the description this is my understanding of your needs. You have a program, that every month gives you a spreadsheet. The program, must parse data from a spreadsheets, and add that data into the database. It must parse that data 10 columns into 13 columns. That data must be displayed and must be filtered ( IE by date, employeeID). Some pre-written SQL queries, but me able to be run via UI. I will complete the project in 2 stages. The first stage will be designing a UI that fits your needs, and will submit it for your approval. After that, I will create the program that will import the data, add it to the database and add the functionality to the UI for you to view and filter it. The benefit of hiring me over anyone else, is that I am always available via Skype, and am happy to have a meeting to really determine everything that you need. I have experience doing UIs and specialize in database creation and deployment ( The project i just finished is similar.) I am currently developing a mock UI for you and should have it completed by the end of the night. I look forward to working with you. I know that we can have a beneficial relationship, for not only your immediate needs, but also your programming needs going forward.
$500 USD in 5 days
5.0 (1 review)
3.2
3.2
User Avatar
Your task looks like a weekend job. Actually my wife is an accountant and that's just how my usual homework from her looks: "Look, we've got this spreadsheet exported from AMS. But look here - the data in this two columns have some internal structure so we need to split them in such a way. And here is more...". Well, that's how my weekends go by when they do their reports :). Besides that I've written tons of other stuff in C# where data are pumped between Excel and C# both ways. I could give you some more info on that if required. Furthermore as a programmer I extensively use metadata which is used for source code generating with the Microsoft T4 Toolkit. To generate the code from metadata I've crafted sophisticated system where Excel is used as the data storage and c# app as a code generating engine. Those tools have been polished by me for years and them do all the bizarre things that you can ever imagine between Excel and C# :) including pumping data between Microsoft SQL Server and Excel. That metadata stuff for the average size project includes several Excel Workbooks with tens Worksheets in each. So I guess that I've got enough of background to consider you task as the weekend job :) There are some things that should be clarified from the start. It would be nice to see a sample Excel file. It's also necessary to discuss which RDBMS you're going to use, the target DB structure and some more. I would give you any additional info if required. Happy accounting, Alexander
$277 USD in 3 days
5.0 (1 review)
3.3
3.3
User Avatar
Sir I am interested in your project. I am a professional ASP.NET C# developer. I can do this job easily. Even I can do it with in 4 days but my bid is 250 dollars in 7 days because of the risk Management. I hope you will also satisfy from my work. Have a good day. Thanks
$250 USD in 7 days
3.5 (5 reviews)
4.3
4.3
User Avatar
Hi, Please understand that this is not a copy pasted proposal. I have vast experience in developing systems that import and export excel. I also have expertise in developing systems on . net framework using c#. I have read and understood your requirements and can deliver the code within 3 days. I am confident about this as I have boiler plate code to read excel to database and code to generate reports from db. I would love to work with you on this. sincere regards, vishnoo Rath
$250 USD in 2 days
5.0 (9 reviews)
3.0
3.0
User Avatar
Dear customer, I am a ASP.NET developer with 2+ production experience. Recently worked with excel. Have strong SQL skills I will complete this task in 7 days. Ready to start immediately. Best regards, Aliaksandr
$750 USD in 7 days
5.0 (1 review)
3.2
3.2
User Avatar
Hello. More 20 years programming experience. I need more details to set real time and price. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
$250 USD in 10 days
5.0 (3 reviews)
2.8
2.8
User Avatar
Hello. My name is Brent. I am a Ms Office, .Net and web developer. I have extensive experience developing for the database and reporting requirements you list in the project brief and I would like to work with you to deliver this solution. My work style is to deliver ongoing drafts of the software daily or bi - daily until the solution matches your precise requirements. This helps to highlight issues early, keeps communication lines open and everybody on the same page.
$277 USD in 5 days
5.0 (4 reviews)
2.2
2.2

About the client

Flag of UNITED STATES
Lexington, United States
4.9
4
Member since Sep 24, 2015

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.