Force Account Analysis
Diary → Extra Work Bill

Step 1 of 2

Upload the inspector's daily diary

Labor and equipment lines are read from the diary, priced against the current equipment rental rate book and prevailing wage determinations, and placed on the Extra Work Bill for your review.

Setup

Project and work item

The project supplies the county, prime contractor and markups; the work item tells the parser which diary hours to use.

1
Parse
Finds the labor / equipment table in an Excel diary or a c-mis PDF report and reads class, hours by item column, names and equipment numbers.
2
Match
Crafts get the prevailing wage basic rate and fringe for your county. Equipment is looked up in the rate book, then the miscellaneous rates.
3
Compute
Every worksheet formula runs live. Edit any cell, then print or export to Excel.

Step 2 of 2

Review the Extra Work Bill

Every field is editable. Amounts recalculate as you type. Highlighted cells need your attention.

Library

Saved Extra Work Bills

Search and filter the EWBs saved by your team. Filters stack. Open one to review or update it.

ProjectContractCCOReportDateTotalSaved by

Overview

Dashboard

Force account totals by project, work item and contractor, from every EWB you can see.

By project

ProjectLabor / EquipEWBsTotal

By work item / CCO

ItemLabor / EquipEWBsTotal

By contractor

ContractorRoleEWBsTotal

By month

Recent EWBs

ProjectItemContractorDateTotal

Settings

Projects

Each project holds the county, prime contractor, markups and work items used for its force account analyses. Projects are private to you unless you share them.

ProjectCountyPrime contractorWork itemsMU · LSC · labor · equip · matlShared withStatus

Settings

Prevailing wage sources

Which DIR determinations the scheduled download fetches (February and August issues, plus monthly checks). Changes are saved to the repository and take effect on the next sync. Removing a craft keeps the documents already downloaded.

Journeyman determinations

CraftDIR listDownloaded · coverage

Apprentice wage sheets

CraftSearch countyDownloaded · coverage