Find Jobs
Hire Freelancers

Data compiled for CFO reporting - excel & access

$30-100 USD

Completed
Posted over 14 years ago

$30-100 USD

Paid on delivery
My company makes deliveries five days a week. We make deliveries using trucks on routes. We have about 10? routes a day making deliveries. I would like to get the raw route data put into a report format that I can present to our CFO. I am including a sample of what the data should look like: Spreadsheet - Route Analysis sheet Sort by Revenue The raw data: Spreadsheet - a_rt_analysis_100909_RAC sheet Normal ## Deliverables The final spreadsheet needs to be in .xls...not the newer version of Excel The deliverables will be two spreadsheets in one excel file: One with data for each week beginning on Monday for: (1) raw data I? labeled "normal" and (2) raw data I labeled "hotshots" The sample should detail the specific info I am looking for. In brief, I am looking for summary of: A) Total number of routes for the week B) Of A, the number of? routes over $6K C) Of A, the total number of routes below $6K and Below 18 "stops" You get extra credit for making a? cool graph? that will? WOW my CFO. Note: the challange of this project will be breaking the raw data down into? weekly summary form for the? deliverables.
Project ID: 2913601

About the project

2 proposals
Remote project
Active 14 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
See private message.
$42.50 USD in 2 days
5.0 (1 review)
1.3
1.3
2 freelancers are bidding on average $47 USD for this job
User Avatar
See private message.
$51 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Newark, United States
5.0
180
Payment method verified
Member since Mar 24, 2008

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.