**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
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
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.
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
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
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.
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