Spreadsheet: 98530d1297384218-formula-for-chronologically-aligning-days-of-the-week-xa-test-total-cat-inv-combine-total-names-for-excel-study-
Sheet: SUN

 | COMPANY: |  |  |  |  |  |  | Work Order # |  |  |  |  | TRI-STATE ELECTRICAL CONTRACTORS, INC |  |  |  |  |  |  |  |  | Cost Multiplier |  | OT | No Multiplier |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPANY: |  |  |  |  |  |  | Work Order # |  |  |  |  | TRI-STATE ELECTRICAL CONTRACTORS, INC |  |  |  |  |  |  |  |  |  |  | TAX |  |  |  | PERCENT |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPANY: |  |  |  |  |  |  |  |  |  |  |  | Work Order # |  |  |  |  |  | TRI-STATE ELECTRICAL CONTRACTORS, INC |  |  |  |  |  |  |  |  |  |  | COMPANY: |  |  |  |  |  |  | Work Order # |  |  |  |  | TRI-STATE ELECTRICAL CONTRACTORS, INC |  |  |  |  |  |  |  |  | COMPANY: |  |  |  | Work Order # |  |  | TRI-STATE ELECTRICAL CONTRACTORS, INC
 | LOCATION  : |  |  |  |  |  |  | PO # |  |  |  |  | JOB # EC |  |  |  | DATE |  |  |  |  | 0.75 |  | 1.5 | 1 |  |  | SALE |  |  |  |  | COST |  |  |  |  |  |  |  |  |  |  |  |  |  | LOCATION  : |  |  |  |  |  |  | PO # |  |  |  |  | JOB #   EC |  |  |  | DATE |  |  |  |  |  |  | 0.08375 |  |  |  | 0.22 |  |  |  |  | SALE |  |  | COST |  |  |  |  |  | LOCATION  : |  |  |  |  |  |  |  |  |  |  |  | PO # |  |  |  |  |  | JOB #  EC |  |  |  |  | DATE |  |  |  |  |  | LOCATION  : |  |  |  |  |  |  | PO # |  |  |  |  | JOB # EC |  |  |  | DATE |  |  |  |  | LOCATION  : |  |  |  | PO # |  |  | JOB #   EC |  | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | trip
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | miles
 | LABOR & EQUIPMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MATERIAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JSA    (job safety analysis) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RFI    (request for information) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CO (change order)
 | CALENDAR |  |  | IDENTIFICATION |  |  |  |  | HOURS |  |  |  |  | [NAME] |  | TRIP | DITCH | TOTALS |  |  |  | sale units |  |  |  |  |  |  |  |  |  |  | TOTAL OVER RIDE |  | cost |  |  |  |  |  |  |  |  |  |  |  | LINE | CODE |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | QNTY |  | SALE |  |  | COST |  | TAX |  | COST + TAX |  | MARKUP |  |  | VENDOR |  | PACKING SLIP |  |  | PERCENT OVERRIDE |  |  | SALE PRICE OVERRIDE |  |  | TSEC / 24225 N COUNCIL RD, EDMOND, OK [PHONE] / [PHONE] / www.tsecinc.com |  |  |  |  |  |  |  |  |  |  |  | Revision Number: |  |  |  | 3 | Day: |  |  |  |  |  | Page: |  | 1 | of | 1 |  | LINE | RFI # |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | DATE SUBMITTED |  | DATE REPLIED |  |  | C/O # | TASK |  |  | STATUS |  |  | DATE SUBMITTED | DATE APPROVED | AMOUNT
 | day | date |  | NAME & EQUIPMENT ID |  |  | POSITION & EQUIPMENT |  | reg time | OT time | no charge | travel time | mobil time | [NAME] | [NAME] | per diem | trench ft' | TOTAL |  |  |  | reg time | OT time | no charge | travel time | mobili- zation time | trench ft' | [NAME] | mobili- zation miles | per diem |  |  |  |  | emp & eqp | exp | total |  | range list |  |  |  |  | range list |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | Location Name: |  |  |  |  |  |  |  |  |  |  |  | Name of Client: |  |  |  |  |  |  |  |  |  |  | Date: |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | Job Description: |  |  |  | (see details below) |  |  |  |  |  |  |  | Contractor Personnel Properly Trained? |  |  |  |  |  |  |  |  |  | ü | Yes |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | If No, Explain:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | Sequence of Job Steps: |  |  |  |  |  |  |  |  |  |  |  |  | Hazards
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall Potential |  |  |  |  | Chemical Burns |  |  |  |  | Pinch Points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Flammable |  |  |  |  | Slip / Trip |  |  |  |  | Ingestion / Inhalation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Overhead Lifts |  |  |  |  | Pressure |  |  |  |  | Airborne Particles
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical Shock |  |  |  |  | Public |  |  |  |  | Heat Stress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | H2S |  |  |  |  | Vehicle |  |  |  |  | Inadequate Lighting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weather |  |  |  |  | Sharp Objects |  |  |  |  | Lifting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dropped Objects |  |  |  |  | Contamination (Skin / Clothing)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | Hot / Cold Surfaces |  |  |  |  | Other - Explain:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | Required / Recommended Personal Protective Equipment: |  |  |  |  |  |  |  |  |  |  |  |  | Recommended Actions & Safe Work Practices / Procedures:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | Hard hat |  |  |  |  |  | Steel Toed Shoes / Boots |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | Safety Glasses / Goggles |  |  |  |  |  | Face Shield |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | Work Gloves |  |  |  |  |  | Chemical Gloves |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | Chemical Apron |  |  |  |  |  | Hearing Protection |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | Fall Protection |  |  |  |  |  | Respirator / Work Line |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | Other - Explain: |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | Check and Review |  |  |  |  |  |  |  |  |  |  |  |  | Permits Required
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | Lock Out / Tag Out |  |  |  |  |  | Fire Extinguisher(s) |  |  |  |  |  |  | [NAME] |  |  |  |  | Hot Work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | Scaffold (Inspected) |  |  |  |  |  | Ladder (Secured) |  |  |  |  |  |  | Trenching |  |  |  |  | Posted at Job Site
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | Inspection of Equipment |  |  |  |  |  | MSDS Review |  |  |  |  |  |  | Other (Specify):
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | Employee Name: |  |  |  |  |  |  |  |  |  | Employee Name: |  |  |  |  |  |  |  |  | Employee Name:
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meeting Conducted By: |  |  |  |  |  |  |  |  |  |  |  |  | Signature: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31