Excel spreadsheet to track flat-rate jobs

Closed Posted Sep 10, 2015 Paid on delivery
Closed

I am a flat rate auto mechanic who is paid by the job. I would like an excel spreadsheet where I can enter in a work order number, hours per job, and a job description. For example: An oil change and tire rotation would look like:

Work order Units (Hours) Job

1111111 .4 Oil Change

.2 Tire Rotation

1111112 1.0 Tune Up

.1 Change tail light

I would like the units to tally up and display at the top of the screen perhaps, where it would show me a total per each day, and a running weekly total. I would like a seperate column for each day of the week. The time card will be to track a two week period. If the dates could automatically be entered, that would be great too. Any other ideas appreciated, I am very open to suggestions.

Colours, formatting, all that eye candy jazz would be appreciated, I created a spreadsheet in excel but it is non-functioning. You can download/view it here: [login to view URL]

Arts & Crafts Odd Jobs Script Install Shell Script Software Architecture

Project ID: #8445201

About the project

8 proposals Remote project Active Nov 3, 2015

8 freelancers are bidding on average $16/hour for this job

agilepksolutions

Hi, I’ve had a good look at your project description and I’m very interested in providing a solution. I have 3+ hands on experience on developing quality web solutions as well as desktop standalone solutions. I u More

$16 USD / hour
(18 Reviews)
6.5
mdkass

Hello, I have good Excel experience and looking to do this project for you, I couldn't download the Excel file,could you please resend it here? Best regards

$18 USD / hour
(74 Reviews)
5.7
zExcel

A proposal has not yet been provided

$30 USD / hour
(20 Reviews)
5.6
Mesaryb

Предложение еще не подано

$2 USD / hour
(0 Reviews)
0.0
esmielozano

Hello, I would love to do this project for you! I have great attention to detail. I am very creative and have a good eye to make things look good and easy to read so I can create the unique design you are looking for. More

$27 USD / hour
(0 Reviews)
0.0
mikleru

Hi You give a detailed description. Thank you! I have experience in excel automation due my past manager's job. I spent a bit time to create worksheet according your description. It's functional. Just need yo More

$5 USD / hour
(0 Reviews)
0.0
ujjalmajumdar

I have experience of handling big data and very large files and very big databases. I can help you on this. Please share the excel as I am unable to access the link provided by you.

$17 USD / hour
(0 Reviews)
0.0
mchawla16

Hello, I have more than 18 years of experience working in software companies. I am an expert in working with all Microsoft Office tools like Project, Word, Excel, Outlook, Powerpoint. During the course of More

$15 USD / hour
(0 Reviews)
0.0