Find Jobs
Hire Freelancers

Customized Excel File

$250-750 USD

Completed
Posted almost 10 years ago

$250-750 USD

Paid on delivery
**Team please read carefully** Project that I need done it might be simple for some. I will need a Excel file that will contain the following things: **Main Entry Sheet** 01. Driver ID# & Name (and I will need separate sheet in the file where I can enter drivers info...example: {ID#, Last & Fist name, Address, Phone#1, Phone#2, Email, Driver License Number) 02. Customer (another separate sheet with customers info...example: {Customer name, Phone#1, Phone#, Fax#, Email,) 03. Rate charged to the customer ( Rate in USD $$) 04. Driver's rate (USD currency) 05. Loading city and state/providence (want to be able to have all US and Canadian cities under that field) 06. Delivery city and state/providence (want to be able to have all US and Canadian cities under that field) 07. Total loaded miles (I will manually enter total miles) 08. Agreed rate per mile (Manually entered) 09. Additional add-on $ (Manually entered) 10. Total payout (loaded miles x agreed rate + if any additional add-on $$$ ) 11. Factor/Billed (want ability to choose either Factor or Billed. If factored it will be at 5%, if billed it will vary per customer (some customers charge % some don't) 12. Company profit (in USD $ {Customer rate - driver cost - factoring cost / - tax payout = COMPANY PROFIT$$$} 13. Average payout tax $$ (USD) (usually it's 25% of the company's profit) 14. Factored/Billed? (Need a option where I can choose if it was factored or billed to the customer) -------- I have attached a sample file I am using now. I need more options and better interface where I can have our company Logo, Company name, address, phone number, fax number) Will also need a weekly payroll sheet summary for all the driver's payout (want to be able to print out onto 8 1/2 x 11 inch for each driver's total payout ) Also I want ability to have for each driver YTD summary (year-to-date summary) Please email me if you can do it. Thanks BEST
Project ID: 6097108

About the project

13 proposals
Remote project
Active 10 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
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$452 USD in 7 days
4.9 (165 reviews)
6.4
6.4
13 freelancers are bidding on average $396 USD for this job
User Avatar
Hello, my name is Cristian, I have a degree in Business and I work with excel every day. I have much experience creating spreadsheets and creating formulas to process the information the way I want. I can Improve your spreadsheet and make it work for you. Greetings.
$255 USD in 5 days
4.9 (241 reviews)
6.9
6.9
User Avatar
Dear Sir, I am a software engineer and I have much of experience for this project. my expertise lies in quality service and delivery on Time i guarantee you 100% satisfaction. kindly if you wants high quality work then as soon as possible contact me. Please give me chance to prove myself. Hoping positive response........thanks
$255 USD in 5 days
4.9 (31 reviews)
4.5
4.5
User Avatar
A proposal has not yet been provided
$250 USD in 5 days
5.0 (11 reviews)
4.6
4.6
User Avatar
I am an MBA with 20 years of Excel VBA experience. This is a straight forward model, but it would be important to discuss how you enter your information to ensure this is a clean easy to manage model that you can update in the future without paying another programmer. I see clean Excel spreadsheets with data validation on the fields where you need a drop down list. But some Visual Basic code to create your driver summaries on demand, so you can get clean well-sorted and displayed reports. Thank you for considering my proposal Triche
$350 USD in 10 days
5.0 (4 reviews)
3.5
3.5
User Avatar
Proposal belum diberikan
$555 USD in 3 days
5.0 (9 reviews)
3.0
3.0
User Avatar
A proposal has not yet been provided
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello............................................................. .......................................
$388 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am 35 year old computer professional. i have worked like data entry in word and excel. my typing speed in english is 40 wpm with 99.99% accuracy. i will justify this project.
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I can provide best solution for your work so please provide one chance to me for this work related... I’m not just looking for any kind of one project or some money but I’m looking for long and strong business relationship with client... so let's start with this project... :-) Thanks in advance
$700 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Aucune proposition n'a encore été fournie.
$555 USD in 3 days
0.0 (2 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Salem, United States
0.0
0
Payment method verified
Member since Jun 21, 2014

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.