Find Jobs
Hire Freelancers

Need help generating automated reports from raw excel spreadsheets

$250-750 USD

Closed
Posted over 6 years ago

$250-750 USD

Paid on delivery
I have 2 projects that I would like to complete. First - we get a raw data in an excel spreadsheet for our trucking company. Would like to have a program that automatically creates payroll reports for our drivers and creates summary reports for our trucks. Second - I have a report that I have to generate manually from some raw data. There is some work that has to be done to get the data in the correct format, and then generate and email a PDF of the desired output.
Project ID: 15468888

About the project

37 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
37 freelancers are bidding on average $348 USD for this job
User Avatar
Hi, I am good at Excel and vba. I have reviewed the description. Please attach the raw data to work on and it helps me to base the further discussion on the requirement. -Chandra Relevant Skills and Experience Excel vba, Automation, Data Analysis Proposed Milestones $500 USD - Milestone
$500 USD in 5 days
5.0 (853 reviews)
8.0
8.0
User Avatar
Hello. Basically, your two jobs are identical. Meaning creating the raw data section, setting up formulas and VBA code and create automatied dashboard reports in the front end. Relevant Skills and Experience Excel, VBA, Data Processing, Dashboard design. I will create the Excel template which you will be able to update easily with your own data in the future without any assistance. Proposed Milestones $526 USD - Will be paid when job is done and customer is 100% satisfied I'm mostly available if you wanna discuss further. Thanks.
$526 USD in 10 days
5.0 (141 reviews)
7.1
7.1
User Avatar
Hi. My name's Paris. I can create the needed code to automate these two processes by just clicking a couple of buttons. Relevant Skills and Experience I am an expert in developing Excel spreadsheets for about a decade. Please, check my past reviews in my portfolio. Proposed Milestones $150 USD - Deliver a draft version for feedback $250 USD - Once you approve the last verion of the file When can we chat or talk? I am online from 3 to 11 pm (GMT+3).
$400 USD in 3 days
4.9 (220 reviews)
7.4
7.4
User Avatar
I can develop the required payroll report and truck summary report solution (also, reformat of data and ability to Email PDF). I do such tasks in Excel almost on a daily basis. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 15 MONTHS , spent at least 250 HOURS on automation in Excel every month. Proposed Milestones $150 USD - Initial Delivery $150 USD - Final Delivery
$300 USD in 7 days
5.0 (187 reviews)
6.8
6.8
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia relevante VBA/Models/Databases Htos propuestos $400 USD - final delivery
$400 USD in 5 days
4.9 (224 reviews)
6.9
6.9
User Avatar
Hi, Reading your project description about generating automated reports from Excel raw data, makes me feel like you have me in mind when creating the project. I have all it takes to deliver - 100%. Relevant Skills and Experience I am confident I can exceed your expectations since I am accustomed to doing this sort of job on a regular basis. I can assure you of a job well done. Please refer to my profile for more details. Proposed Milestones $250 USD - Project Completion
$250 USD in 10 days
4.9 (52 reviews)
6.4
6.4
User Avatar
Greetings from Easton PA USA Highly experienced (25+years) EXCEL Programming and Database expert. Strong Automation, Data Integration, Reporting, and User Interface skills. Relevant Skills and Experience Strong Accounting, Costing, Finance, Inventory, Order Processing, PAYROLL+TIME, Scheduling, and Sales+Marketing business application knowledge. Confidentiality and satisfaction guaranteed. Proposed Milestones $555 USD - 50% down.. 50% upon completion.. (negotiable) Please contact us via chat before awarding. Respectfully, Carol+Bill.
$555 USD in 10 days
4.9 (29 reviews)
6.0
6.0
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $250 USD - 100% milestone and release upon completion
$250 USD in 3 days
4.8 (71 reviews)
5.5
5.5
User Avatar
I am suggesting to build an Excel AddIn that will create 2 buttons in Excel Ribbon and upon clicking the required button with the data in agreed format in active sheet will perform the action. Relevant Skills and Experience I have more than 11 years of experience in Excel Automation using VBA and Excel AddIns. Proposed Milestones $530 USD - Final Delivery
$530 USD in 10 days
5.0 (7 reviews)
5.2
5.2
User Avatar
hi sir how r u i am interested in both of your project as i am expert in excel as well as data entry and done quite a big job on excel and data entry related work kindly pm me details Relevant Skills and Experience excel formulas re arrangement of work in excel as required Proposed Milestones $250 USD - on work completion
$250 USD in 3 days
5.0 (18 reviews)
4.9
4.9
User Avatar
Hi, I am a skilled professional and have an experience of working as financial analyst for last 5 years. And very good in accounting and excel as well. Please contact with me. Thanks. Relevant Skills and Experience Accounting, excel
$250 USD in 10 days
4.7 (15 reviews)
4.4
4.4
User Avatar
I have good command over MS Excel especially povit table, charts, advance formulas etc. VBA code as well. DO let me know more detail in PM
$400 USD in 7 days
4.9 (23 reviews)
4.0
4.0
User Avatar
A proposal has not yet been provided
$350 USD in 21 days
5.0 (16 reviews)
3.9
3.9
User Avatar
I will create a very effective excel workbook to calculate and print payroll Relevant Skills and Experience In expert in excel Proposed Milestones $250 USD - Payrol system
$250 USD in 3 days
5.0 (6 reviews)
3.6
3.6
User Avatar
. Relevant Skills and Experience . Proposed Milestones $150 USD - ms1_project1 $155 USD - ms2_project2 I read ur project details very carefully. I have a done similar projects recently. Pls pm for demo
$305 USD in 5 days
5.0 (9 reviews)
3.1
3.1
User Avatar
Requirements: One button can run VB logic to generate driver pay and truck report. Second button will re format data and email as pdf. Relevant Skills and Experience Degree in Computer science. 15 plus years of IT systems development for SWIFT in Virginia, Unisys Corporation in London, HSBC bank in Hong Kong & BHP NZ Steel in New Zealand. Now in good demand for teaching advanced Excel topics including VB programming. No job is small for me as freelancing is my hobby now. Additional Services: (1)USD 25: Suggestions to improve your Excel system. (2) USD 50: My estimate of effort to implement the suggestions Questions: Can you clarify more details reg reports and the reformatting needed for the data. That can reduced the quote further.
$277 USD in 10 days
5.0 (4 reviews)
2.8
2.8
User Avatar
Hello, I understood that you are looking for 2 programs which can read a excel file and generate reports in the format after some calculations. and then send an email of the same in desired format. Relevant Skills and Experience I can work on your project. We have 3 PHP developers with over 7 yrs of experience and we will give our best to deliver this project ASAP as per requirements. Proposed Milestones $555 USD - Please discuss further details to understand complexity of the work
$555 USD in 15 days
5.0 (1 review)
2.4
2.4
User Avatar
Hello, I am Roland. I’ve read your brief and I am interested in it. I will give you quality work at very affordable rate. I will work within your budget and time frame. Relevant Skills and Experience You can view my profile for reviews and portfolio. Proposed Milestones $250 USD - excel vba
$250 USD in 3 days
4.4 (3 reviews)
2.3
2.3
User Avatar
I had been code data processing/mining tools for semiconductor company around 2years. My expertise is on processing huge numbers of raw data and present them in an user friendly way to the engineers. Relevant Skills and Experience visual basic application (VBA) / Excel Macro, visual basic script. VB .net, CSharp, Pythjon Proposed Milestones $150 USD - Completion of first phrase $222 USD - Completion of second phrase Additional Services Offered $100 USD - New enhancement and upgrade on the completed project As long as the source is in excel file format, i am able to generate it in presentative way.
$277 USD in 10 days
4.3 (2 reviews)
1.9
1.9
User Avatar
A proposal has not yet been provided
$277 USD in 1 day
4.1 (3 reviews)
1.7
1.7

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Oct 23, 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.