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!
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).
windows 2000 / xp
excel 2000 / xp