Find Jobs
Hire Freelancers

Write some Software to process CSV files and run reports

$250-750 AUD

Completed
Posted over 7 years ago

$250-750 AUD

Paid on delivery
Hello Programmers! The outline: build a program to process monthly reports, apply calculations, and output smaller reports, and send the reports via email INPUT I receive a CSV file once a month. It contains a report of what work we have done for the month based on client and provider as well as what we earned for each client broken up into 2 parts. Initial Fee – Upfront and an Ongoing Fee – Trail. PROCESSING For each client, we need to break down the report based on who was the operations manager or referrer or both. Program needs to be receive the information, save it to a DB. Allow for manual interaction to assign to each file an operations contact and/or a referrer. Calculate a % of the fee for each section For each subsequent month, it needs to read previous month’s report and see who has already been assigned to old clients, and assign manually to new clients OUTPUT For each operations manager, referrer and the head group, create a detailed report in excel, and a summary invoice in PDF for each month. We have a current program in EXCEL its around 95% complete, but is this the BEST way? Would you prefer to fix this or start again? Build in a different program? Please ask questions in your bids, thank you!
Project ID: 11562660

About the project

37 proposals
Remote project
Active 8 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
Let's get started on this project asap. I'll convert your Excel db to an Access db - this will be significantly more efficient for your business. Here's what you can expect: 1) 100% money back guarantee if pre-agreed acceptance criteria are not met! 2) Error-free solution 3) Timely submission Do get in touch - after all, what do you have to lose? I'm confident my 14 years experience in all things Access, VBA and Excel will serve you well
$250 AUD in 7 days
5.0 (1 review)
2.4
2.4
37 freelancers are bidding on average $437 AUD for this job
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. We have 100% client satisfaction ratio. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
$250 AUD in 2 days
4.9 (674 reviews)
8.6
8.6
User Avatar
I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactorily completed. Contact me at your soonest convenience so we may get your solution delivered quickly. Thanks, coderXO
$685 AUD in 10 days
4.9 (769 reviews)
8.3
8.3
User Avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy
$250 AUD in 7 days
5.0 (497 reviews)
7.8
7.8
User Avatar
hello, i read your project discription in details and can i see the current program that you are using so that will get the idea ready to start now thanks
$622 AUD in 7 days
4.8 (201 reviews)
7.4
7.4
User Avatar
Hello, Hope You are doing well. Arity Infoway is complete web based solutions company. We able to provide web solutions from scratch to hosting . We always go through every point of your projects scope and provide you our comments & suggestions. ARITY INFOWAY is leading growing company in outsourcing business. We are having 15+ members with expertise in various technology. Web Designing :- HTML5, PSD to HTML, CSS3, JS, Angular JS, Node JS, jQuery, Responsive Web Designing, UI Development, Frontend Development, Logo Designing, Theme Integration, AJAX, Web Services PHP:- MySQL, Core PHP, Magento, Joomla, Wordpress, CMS, Blogs, Codeigniter , Smarty, Moodle, Symfony, Yii, Drupal, eCommerce, OSCommerce, Shopping Cart .NET:- ASP.NET, VB.NET, C#, MVC, Umbraco, Entity Framework, BioSecure Software, SQL Server, HSQL DB, Kendo UI, Telerik Control, Azure Storage, CDN Storage, WCF, WPF, Web API, HRM Integration, Desktop Applications Payment gateway Development & integration:- PayPal, Avangate, Skrill, CCAvenue, WorldPay, Stripe Network support, Web Hosting:- Network Setup, Web Hosting, WHM,Cpanel, Firewall Configuration, Advance DNS Solution, Server Installation and setup, Mail Server, SMTP, Router Configuration, System admin, Cloud Server, Critical Data Recovery, Remote Server Support, Security, Network Monitoring, troubleshooting, Web Security, Computer Help. We never Place any GENERIC BID so we frequently contact you to meet you expectations. We love to spread SMILES :-)
$452 AUD in 6 days
4.9 (178 reviews)
7.5
7.5
User Avatar
Hello Sir, I am an excellent C#, VBA and .Net developer and can certainly help you with this report generation. I would like to see the existing exe but would prefer to create a new one to give the complete functionality as requested by you. Thanks Aanvik
$777 AUD in 10 days
5.0 (68 reviews)
7.0
7.0
User Avatar
UNless you are looking for a web based solution, processing data in Excel and taking PDF outputs for your clients is a very widely implemented method. I made several solutions in this way. Contact me to discuss more. Thanks..
$526 AUD in 7 days
5.0 (141 reviews)
7.2
7.2
User Avatar
My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. I can show you some examples of my work. Please contact me to discuss your project.
$611 AUD in 10 days
4.9 (47 reviews)
6.9
6.9
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.
$773 AUD in 10 days
5.0 (27 reviews)
7.0
7.0
User Avatar
Hello, here is the details of how i will do the requirement 1. Admin dashboard for view monthly CSV file summary details (new clients,old clients,Initial Fee,Ongoing Fee) 2. Add email functionality to send reports. 3. Store reports in back-end for future verification. 4. Store section wise percentage for make calculation. 5. Process the CSV file and store in db. 6. Calculate price for each section and store in db. 7. Create report for Operations manager, referrer & head group and send to their respective email as PDF. 8. Please send your CSV file to review. Regards thanga
$300 AUD in 10 days
5.0 (221 reviews)
6.7
6.7
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. If you have any observations regarding excel which is bothering you then we can think of something else but let us review the current work first. Please send me more details about the work. It will help me estimate time and cost. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$500 AUD in 15 days
4.9 (165 reviews)
6.5
6.5
User Avatar
Hello sir, I suggest to build the report system on web based. It will be hosted at IIS local server or internet hosting then you can access the report internet/intranet as well. I suggest to use ASP.Net MVC to build the front end of report system. C# to process excel files data then display report on UI by microsoft report (*.rdlc). You can execute/export data to pdf/excel file. I can show you a sample of report system which I built for another client. Looking forward your response as soon as possible! Thanks, Hao
$388 AUD in 10 days
4.8 (34 reviews)
6.1
6.1
User Avatar
A proposal has not yet been provided
$633 AUD in 14 days
5.0 (8 reviews)
5.3
5.3
User Avatar
Hi, I have lot of experience processing txt files. I am sure I can develop for you this CSV program. I think it is better do it via a compiled exe (program). If in the future you need any modifications, you can make them (I will provide you the .exe and the source code) I would like to have an input (CSV) and output example(PDF and dabase file) Let's talk. Best regards, Monillo
$555 AUD in 10 days
4.7 (10 reviews)
5.4
5.4
User Avatar
Hi, I am a student who expert in automation and data analytics. I will write a program using vb. Net and read the csv files and automatically calculate and create necessary output files. If interested please message me so that we can discuss further
$250 AUD in 3 days
5.0 (21 reviews)
5.1
5.1
User Avatar
Dear Manager, I'm creative Freelancer and develop my career in IT field. I love & like to take challenge. I am a hard working person. Hard working is my habit.I am expert in wordpress,Database,MYSql,SQL Server, Oracle,PHP,HTML,CSS with website designing. I have enough knowledge in Data Entry, MS word, Excel, MS Access, HTML, CSS, Database, Joomla, Basic Photoshop and other programming language. I'm very interested in your job post involving these skills. I am available to chat by email or Skype(hossainmd94), and would be happy to set up a convenient time to discuss the application you're moving and some ideas about the safest way to get it into the cloud. I will be available 40 hours per week for this position. Regards, Hossain
$250 AUD in 10 days
5.0 (2 reviews)
5.1
5.1
User Avatar
Hi, After reading your job requirements, I am certain that I’ll be a valuable addition in accomplishing your task. I have a degree in Software Engineering and my web development tools are HTML/CSS, JavaScript/ JQuery/AJAX and PHP/MySQL/PostgreSQL and software development tools such as C++, C#, VB.NET, ASP.NET, Java, JSP and Lazarus (Pascal), administrative, RND, Data extracting / data mining and other experience in different companies has prepared me to take on more responsibility in a fast-paced environment. In addition, I am expert in third party frameworks like bootstrap for UI and UX implementation, CodeIgniter, Laravel, and Wordpress and also MS office applications such as Word and Excel. Besides job specific tasks, I have a proven ability to maintain the confidentiality of the typed information with accuracy. Moreover, I have good communication skills and full command over written and verbal English and a few other languages. I am confident upon the skills and knowledge I have gained in the past years. I have also gained the experience in diversified sectors of an industry, communication skills, customer service and administration. I have well read and understood your job description. I possess the skills required to handle this job as well. Regards, Hisham
$250 AUD in 10 days
4.9 (30 reviews)
4.6
4.6
User Avatar
I would create a small php app with ajax/html frontend. The process of parsing csv files can be automated (by sending it to specific email or uploading it via ftp) or you could manually upload it within web app. Once the csv is processed and stored in mysql database various reports can be done - in word, excel or pdf formats. I usually finish apps like that in a week. Contact me if interested and we will arrange the details. Regards, Marko
$388 AUD in 7 days
5.0 (10 reviews)
3.6
3.6
User Avatar
Hello, I can make a python system for csv file analysis, submitting of data into database and data processing. The output of the data processing can be given in any format you like. Let us discuss more on chat. Thank you
$555 AUD in 10 days
5.0 (7 reviews)
3.2
3.2
User Avatar
Native English speaker. Excel/VBA expert. Expertise in handling large data sets and building custom Excel-based applications. I have experience with parsing CSV files. I'm curious as to your database backend. Are you using Access? Best, Jay
$555 AUD in 10 days
5.0 (3 reviews)
2.9
2.9

About the client

Flag of AUSTRALIA
East Sydney, Australia
5.0
9
Payment method verified
Member since Jan 21, 2016

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.