Completed

Fancy Excel Payroll sheet with lookup function

Attached is my payroll excel worksheet. My goal is to automate and clean it up.

What you need to know about this file:

The 6 month collections and visits are entered manually from another system.

I need this to do the following;

automatically insert the rates from the table based on the number of visits and the average collection.

automatically increment the dates (the pay period is weekly, but we get paid every 2 weeks.

automatically create a saved copy of the current pay period's worksheet ( I guess I see one file with 26 tabs?)

fix the "pay the higher of commission or base" so that it doesn't show both numbers when printed.

add a health insurance deduction field.

On clocked employees: some employees we enter weekly totals, while on others we only get the total regular and OT hours.

Once filled out we usually print then fax this in, I would like the ability to email the current period's sheet to the payroll processor.

Any other cool stuff that you can think of!

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

windows 2000 / xp

excel 2000 / xp

Skills: PHP

See more: payroll 1, numbers function, need to hire employees, my payroll, get paid for excel work, function of numbers, function numbers, excel out source, collections etc, payroll number, excel party hire, excel for hire, sheet, run sheet, print is cool, print cool, payroll system, payroll so, i print stuff, Hire Excel

About the Employer:
( 117 reviews ) Montgomery, United States

Project ID: #3119057

Awarded to:

letregrandecoder

See private message.

$25.5 USD in 6 days
(38 Reviews)
4.7

10 freelancers are bidding on average $98 for this job

allegrovw

See private message.

$63.75 USD in 6 days
(27 Reviews)
4.3
hawkswayvw

See private message.

$425 USD in 6 days
(12 Reviews)
4.5
herothecatvw

See private message.

$80.75 USD in 6 days
(15 Reviews)
4.4
RGATRAC

See private message.

$72.25 USD in 6 days
(11 Reviews)
3.6
gregorymvw

See private message.

$55.25 USD in 6 days
(6 Reviews)
2.2
danielharmanvw

See private message.

$42.5 USD in 6 days
(0 Reviews)
0.0
jaikrishanvw

See private message.

$85 USD in 6 days
(0 Reviews)
0.0
drprince

See private message.

$61.2 USD in 6 days
(0 Reviews)
0.0
iwcoetzer

See private message.

$72.25 USD in 6 days
(0 Reviews)
0.0