Data Base (Worksheet)
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 8.0px Arial; color:
#4349aa }table.t1 {border-collapse: collapse}td.td1 {background-color:
#000000 ; border-style: solid; border-width: 0.8px 0.8px 0.8px 0.8px; border-color:
#cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td2 {background-color:
#000000 ; border-style: solid; border-width: 0.8px 1.0px 1.0px 1.0px; border-color:
#38d4d6 #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>
Job Number | Project Name | Bid Item Number | Bid Item Desccription | Unit | Bid Qty | Bid Price | Blank | Prior Quantities | Jan Qty | Feb Qty | Mar Qty | Apr Qty | May Qty | Jun Qty | July Qty | Aug Qty | Sep Qty | Oct Qty | Nov Qty | Dec Qty |
<tbody>
</tbody>
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 9.0px Arial; color: #3da779}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 9.0px Arial; color: #3da779}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 9.0px Arial; min-height: 10.0px}p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 9.0px Arial}p.p5 {margin: 0.0px 0.0px 0.0px 0.0px; font: 9.0px Arial}table.t1 {border-collapse: collapse}td.td1 {background-color:
#ffd5a9 ; border-style: solid; border-width: 0.8px 0.8px 0.8px 0.8px; border-color:
#cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td2 {background-color:
#000000 ; border-style: solid; border-width: 0.8px 0.8px 0.8px 0.8px; border-color:
#cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td3 {background-color:
#000000 ; border-style: solid; border-width: 0.8px 1.0px 0.8px 1.0px; border-color:
#a7a7a7 #cbcbcb #a7a7a7 #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>
15031 | Fossil Heritage Trail (Fossil) | 10 | Mobilization | LS | 4.00 | 500.00 | | | | | 1.00 | | | | | | | | | |
15031 | Fossil Heritage Trail (Fossil) | 30 | Temporary Signs In Place | SQFT | 545.00 | 14.00 | | | | | 513.50 | | | | | | | | | |
15031 | Fossil Heritage Trail (Fossil) | 40 | Temporary Barricades, Type II | EA | 24.00 | 45.00 | | | | | 39.00 | | | | | | | | | |
15031 | Fossil Heritage Trail (Fossil) | 50 | Temporary Barricades, Type III | EA | 5.00 | 95.00 | | | | | 5.00 | | | | | | | | | |
15031 | Fossil Heritage Trail (Fossil) | 80 | Temporary Type 1 Fence | Foot | 153.00 | 10.50 | | | | | 160.00 | | | | | | | | | |
15031 | Fossil Heritage Trail (Fossil) | 470 | Unit Pavers | SF | 1,600.00 | 12.50 | | | | | | | | | | | | | | |
<tbody>
</tbody>
Pivot Data (Pivot table worksheet)
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Arial}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px Arial}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px Arial}p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Arial; color:
#4349aa }p.p5 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px Arial; color:
#4349aa ; min-height: 11.0px}p.p6 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px Arial; color:
#4349aa }table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.5px 1.0px 1.5px 1.5px; border-color:
#4349aa #cbcbcb #4349aa #4349aa ; padding: 0.0px 5.0px 0.0px 5.0px}td.td2 {border-style: solid; border-width: 1.5px 0.8px 1.5px 1.0px; border-color:
#4349aa #4349aa #4349aa #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td3 {border-style: solid; border-width: 1.5px 1.0px 1.5px 1.0px; border-color:
#4349aa #cbcbcb #4349aa #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td4 {border-style: solid; border-width: 1.5px 1.5px 1.5px 1.0px; border-color:
#4349aa #4349aa #4349aa #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td5 {background-color:
#d6d7ff ; border-style: solid; border-width: 0.8px 1.0px 0.8px 1.0px; border-color:
#d6d7ff #cbcbcb #ffffff #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td6 {border-style: solid; border-width: 0.8px 0.8px 0.8px 1.0px; border-color:
#d6d7ff #4349aa #d6d7ff #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td7 {border-style: solid; border-width: 0.8px 1.0px 0.8px 1.0px; border-color:
#d6d7ff #cbcbcb #d6d7ff #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>
Bid Item Number | Description | Prior Quantities | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sep | Oct | Nov | Dec |
10 | Mobilization | | | | 1 | | | | | | | | | |
30 | Temporary Signs In Place | | | | 513.5 | | | | | | | | | |
40 | Temporary Barricades, Type II | | | | 39 | | | | | | | | | |
50 | Temporary Barricades, Type III | | | | 5 | | | | | | | | | |
80 | Temporary Type 1 Fence | | | | 160 | | | | | | | | | |
470 | Unit Pavers | | | | | | | | | | | | | |
560 | Remove Existing Signs | | | | | | | | | | | | | |
570 | Remove & Reinstall Existing Signs | | | | | | | | | | | | | |
<tbody>
</tbody>
Estimate (Worksheet) Most information comes from the Pivot Table
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px 'Times New Roman'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Arial}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px 'Times New Roman'; min-height: 11.0px}p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Arial; min-height: 12.0px}p.p5 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 12.0px Helvetica; min-height: 14.0px}p.p6 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 12.0px Helvetica}p.p7 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Arial; min-height: 14.0px}p.p8 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Arial}p.p9 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Arial; min-height: 12.0px}p.p10 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 12.0px 'Times New Roman'; min-height: 15.0px}p.p11 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px 'Times New Roman'; min-height: 11.0px}p.p12 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 12.0px 'Times New Roman'; min-height: 15.0px}p.p13 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px 'Times New Roman'}p.p14 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Times New Roman'; min-height: 11.0px}p.p15 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Times New Roman'}p.p16 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px Arial}p.p17 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 9.0px Arial}p.p18 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px Arial}p.p19 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Arial; min-height: 11.0px}p.p20 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px Arial; min-height: 11.0px}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td2 {background-color: #000000; border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td3 {background-color: #000000; border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #000000 #cbcbcb #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td4 {background-color: #000000; border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td5 {border-style: solid; border-width: 1.0px 1.0px 0.8px 1.0px; border-color: #cbcbcb #cbcbcb #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td6 {border-style: solid; border-width: 0.8px 0.8px 0.8px 0.8px; border-color: #000000 #000000 #000000 #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td7 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td8 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #000000 #cbcbcb #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td9 {border-style: solid; border-width: 1.0px 0.8px 1.0px 1.0px; border-color: #000000 #000000 #cbcbcb #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td10 {border-style: solid; border-width: 1.0px 1.0px 1.0px 0.8px; border-color: #000000 #cbcbcb #cbcbcb #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td11 {border-style: solid; border-width: 1.0px 0.8px 1.0px 0.8px; border-color: #000000 #000000 #cbcbcb #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td12 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #000000 #cbcbcb #cbcbcb #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td13 {border-style: solid; border-width: 1.0px 0.8px 1.0px 1.0px; border-color: #cbcbcb #000000 #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td14 {border-style: solid; border-width: 1.0px 0.8px 1.0px 0.8px; border-color: #cbcbcb #000000 #000000 #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td15 {border-style: solid; border-width: 1.0px 1.0px 1.0px 0.8px; border-color: #cbcbcb #cbcbcb #000000 #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td16 {border-style: solid; border-width: 1.0px 0.8px 1.0px 1.0px; border-color: #000000 #000000 #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td17 {border-style: solid; border-width: 1.0px 0.8px 1.0px 0.8px; border-color: #000000 #000000 #000000 #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td18 {border-style: solid; border-width: 1.0px 1.0px 1.0px 0.8px; border-color: #000000 #cbcbcb #000000 #000000; padding: 0.0px 5.0px 0.0px 5.0px}</style><style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px 'Times New Roman'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Arial}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px 'Times New Roman'; min-height: 11.0px}p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Arial; min-height: 12.0px}p.p5 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 12.0px Helvetica; min-height: 14.0px}p.p6 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 12.0px Helvetica}p.p7 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Arial; min-height: 14.0px}p.p8 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Arial}p.p9 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Arial; min-height: 12.0px}p.p10 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 12.0px 'Times New Roman'; min-height: 15.0px}p.p11 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px 'Times New Roman'; min-height: 11.0px}p.p12 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 12.0px 'Times New Roman'; min-height: 15.0px}p.p13 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px 'Times New Roman'}p.p14 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Times New Roman'; min-height: 11.0px}p.p15 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Times New Roman'}p.p16 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px Arial}p.p17 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 9.0px Arial}p.p18 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px Arial}p.p19 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Arial; min-height: 11.0px}p.p20 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px Arial; min-height: 11.0px}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td2 {background-color: #000000; border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td3 {background-color: #000000; border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #000000 #cbcbcb #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td4 {background-color: #000000; border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td5 {border-style: solid; border-width: 1.0px 1.0px 0.8px 1.0px; border-color: #cbcbcb #cbcbcb #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td6 {border-style: solid; border-width: 0.8px 0.8px 0.8px 0.8px; border-color: #000000 #000000 #000000 #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td7 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td8 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #000000 #cbcbcb #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td9 {border-style: solid; border-width: 1.0px 0.8px 1.0px 1.0px; border-color: #000000 #000000 #cbcbcb #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td10 {border-style: solid; border-width: 1.0px 1.0px 1.0px 0.8px; border-color: #000000 #cbcbcb #cbcbcb #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td11 {border-style: solid; border-width: 1.0px 0.8px 1.0px 0.8px; border-color: #000000 #000000 #cbcbcb #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td12 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #000000 #cbcbcb #cbcbcb #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td13 {border-style: solid; border-width: 1.0px 0.8px 1.0px 1.0px; border-color: #cbcbcb #000000 #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td14 {border-style: solid; border-width: 1.0px 0.8px 1.0px 0.8px; border-color: #cbcbcb #000000 #000000 #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td15 {border-style: solid; border-width: 1.0px 1.0px 1.0px 0.8px; border-color: #cbcbcb #cbcbcb #000000 #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td16 {border-style: solid; border-width: 1.0px 0.8px 1.0px 1.0px; border-color: #000000 #000000 #000000 #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}td.td17 {border-style: solid; border-width: 1.0px 0.8px 1.0px 0.8px; border-color: #000000 #000000 #000000 #000000; padding: 0.0px 5.0px 0.0px 5.0px}td.td18 {border-style: solid; border-width: 1.0px 1.0px 1.0px 0.8px; border-color: #000000 #cbcbcb #000000 #000000; padding: 0.0px 5.0px 0.0px 5.0px}</style>
Subcontractor:
|
|
|
|
|
|
|
|
| Month
| | | |
Address:
|
|
|
| Contract No.
| XXXXX
|
|
|
|
| Mar
| | |
|
|
|
| Project Name:
| Fossil Heritage Trail (Fossil)
|
|
| | | | | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Quantity
| Unit
| Total
|
| Previously
| THIS
| Original
| Contract
|
| |
Item #
| Description
| To-Date
| Price
| Earned
|
| Earned
|
| ESTIMATE
| Quantity
| Amount
|
| |
10
| Mobilization
| 1.00
| 500.00
| 500.00
|
|
|
| 500.00
| 4.00
| 2,000.00
|
| |
30
| Temporary Signs In Place
| 513.50
| 14.00
| 7,189.00
|
|
|
| 7,189.00
| 545.00
| 7,630.00
|
| |
40
| Temporary Barricades, Type II
| 39.00
| 45.00
| 1,755.00
|
|
|
| 1,755.00
| 24.00
| 1,080.00
|
| |
<tbody>
</tbody>
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Arial}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px Arial}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px Arial}p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Arial; color:
#4349aa }p.p5 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px Arial; color:
#4349aa ; min-height: 11.0px}p.p6 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 10.0px Arial; color:
#4349aa }table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.5px 1.0px 1.5px 1.5px; border-color:
#4349aa #cbcbcb #4349aa #4349aa ; padding: 0.0px 5.0px 0.0px 5.0px}td.td2 {border-style: solid; border-width: 1.5px 0.8px 1.5px 1.0px; border-color:
#4349aa #4349aa #4349aa #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td3 {border-style: solid; border-width: 1.5px 1.0px 1.5px 1.0px; border-color:
#4349aa #cbcbcb #4349aa #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td4 {border-style: solid; border-width: 1.5px 1.5px 1.5px 1.0px; border-color:
#4349aa #4349aa #4349aa #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td5 {background-color:
#d6d7ff ; border-style: solid; border-width: 0.8px 1.0px 0.8px 1.0px; border-color:
#d6d7ff #cbcbcb #ffffff #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td6 {border-style: solid; border-width: 0.8px 0.8px 0.8px 1.0px; border-color:
#d6d7ff #4349aa #d6d7ff #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}td.td7 {border-style: solid; border-width: 0.8px 1.0px 0.8px 1.0px; border-color:
#d6d7ff #cbcbcb #d6d7ff #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>