Find Jobs
Hire Freelancers

Customized Excel File

$250-750 USD

Cancelled
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: 6097171

About the project

6 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
6 freelancers are bidding on average $434 USD for this job
User Avatar
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing code / debugging Excel VBA code. You may check my portfolio images to see few pieces of my kind of work. (This is what I do on daily basis). I am a professional and I can do a very good job. Also fast and accurate. Do not hesitate to contact me for further details. Kind Regards, Jon
$350 USD in 5 days
5.0 (37 reviews)
5.0
5.0
User Avatar
A proposal has not yet been provided
$700 USD in 20 days
4.9 (7 reviews)
4.1
4.1
User Avatar
Am foarte mult timp liber la dispozitie ; Ma pricep ; Imi place sa-mi duc sarcinile la bun sfarsit ; Caut mereu sa surprind ; Vreau sa lucrez
$555 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$333 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I read your email and can complete this easily but I did not find any attached sheet. Please send it Regards Avinash Yadav
$333 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$333 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Colombo, United States
0.0
0
Member since Mar 8, 2011

Client Verification

Other jobs from this client

Project SYS
$10-30 USD
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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.