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.

Defaults

Project settings

Saved in this browser and applied to every new analysis. A county is required: it selects the prevailing wage area for each craft.

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