When the boss is bidding a job they need to assign a several crews to a
job.
1. Select year the work is to be completed.
2. Select job type
3. Select the description (ie labor & equipment)
These are all drop down boxes.
4. Identify the quantity of the labor & equipment.
5. Identify the number of manhours per day for the labor and
equipment.

Steps 1-5 should all be inputed by the end user.

This is what I need to have the workbook do. The end user is not very
computer literate and needs something that will be some what "error
proof" they are used to using Lotus notes and manually adding in
everything to include the calculations.

Calculations Needed:
1. Unit Price-based on the year and the type of job to find the rate.
Heavy jobs are always straight time. IE Year is 2008, Job type is Heavy
so look at the description and find it on the Equipment and labor sheet
and bring back the rate for Straight_Time_2008.
If the job is commercial anything over 8 hours is considered overtime
so if the manhours are 10 you need to find the straight time rate of
whatever year for the 8 and the overtime rate for the year for 2 hours.
2. Total price-this is based on the quantity, hours and the rate. IE
(Hours * Quantity)*Rate.


--
butrfly_kis3
------------------------------------------------------------------------
butrfly_kis3's Profile: http://www.thecodecage.com/forumz/member.php?userid=8
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=6858