Spreadsheet: 863343d1710863078-conditionally-format-rows-based-on-values-in-a-column-job-cost-summary-active
Sheet: Sheet1

 |  |  |  |  | BUDGET HOURS | OT BUDGET HOURS | JV BUDGET HOURS | BUDGET HOURS | LAB HOURS | OT HOURS | JV HOURS | HOURS | BUDGET LABOR | BUDGET OT | BUDGET BURDEN | BUDGET FRINGE | BUDGET JV LABOR | BUDGET LABOR | LABOR | OT | BURDEN | FRINGE | JV LABOR | LABOR | BUDGET LABOR RATE | LABOR RATE | DIFF LABOR RATE | BUDGET MATERIAL | BUDGET JV MATERIAL | BUDGET MATERIAL | MATERIAL | JV MATERIAL | MATERIAL | BUDGET EQUIPMENT | BUDGET SUBCONTRACTOR | BUDGET MISC | BUDGET  EQUIP / SUB  / MISC | EQUIPMENT | SUBCONTRACTOR | MISC | EQUIP / SUB  / MISC | TOTAL      BUDGET COST | TOTAL COST | COMMITTED COST | BILLED  AMOUNT | GROSS MARGIN
CLASS | JOB # | DATE OPEN | DATE LAST COST | DATE LAST INVOICED | esthours | esthours2 | esthours3 | BUDGET HOURS | LAB HOURS | OT HOURS | JV HOURS | HOURS | estcost | estcost2 | estcost3 | estcost4 | estcost5 | BUDGET LABOR | cost | cost2 | cost3 | cost4 | cost5 | LABOR | BUDGET LABOR RATE | LABOR RATE | DIFF  LABOR RATE | estcost6 | estcost7 | BUDGET MATERIAL | cost6 | cost7 | MATERIAL | estcost8 | estcost9 | estcost10 | BUDGET  EQUIP / SUB  / MISC | cost8 | [NAME] | cost10 | EQUIP / SUB  / MISC | TOTAL      BUDGET COST | TOTAL COST | COMMITTED COST | BILLED  AMOUNT | GROSS  MARGIN | GM % | TOTAL CONTRACT AMOUNT
DP | 82693 | 2023-08-09 00:00:00 | 2024-03-15 00:00:00 | 2024-02-23 00:00:00 | 1413.32 | 0 | 0 |  | 1054.5 | 0 | 0 |  | 83057.6 | 0 | 0 | 0 | 0 |  | 40752.64 | 0 | 5057.54 | 22183.54 | 0 |  |  |  |  | 169663.01 | 0 |  | 167152.88 | 0 |  | 3475 | 17312 | 11727.82 |  | 1115.54 | 0 | 722.65 |  |  |  | 10901.57 | 189318.41 |  |  | 354300
DP | 77750 | 2022-02-23 00:00:00 | 2024-03-19 00:00:00 | 2024-02-26 00:00:00 | 20630.4 | 0 | 0 |  | 8471 | 414.5 | 21523.5 |  | 1038424.39 | 0 | 0 | 0 | 0 |  | 245093 | 15033.01 | 28277.53 | 134428.42 | 1115458.32 |  |  |  |  | 1710759.94 | 0 |  | 1767755.26 | 18000.05 |  | 18410 | 533713 | 21657.67 |  | 52098.52 | 499935 | 44927.2 |  |  |  | 93669.27 | 3887891.49 |  |  | 3887891.49
DP | 83638 | 2024-02-05 00:00:00 | 2024-03-14 00:00:00 | 0 | 0 | 0 | 0 |  | 43 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 1544.5 | 0 | 151.4 | 872.79 | 0 |  |  |  |  | 0 | 0 |  | 451.32 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 1040.94 | 0 |  |  | 0
DP | 82731 | 2023-08-18 00:00:00 | 2024-01-25 00:00:00 | 0 | 0 | 0 | 0 |  | 36 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 1442.71 | 0 | 140.97 | 818.29 | 0 |  |  |  |  | 0 | 0 |  | 32.72 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  | 0
DP | 82804 | 2023-09-05 00:00:00 | 2023-10-25 00:00:00 | 0 | 0 | 0 | 0 |  | 22 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 892.98 | 0 | 74.91 | 469.86 | 0 |  |  |  |  | 0 | 0 |  | 183.09 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  | 1620.84
DP | 83735 | 2024-02-23 00:00:00 | 2024-03-04 00:00:00 | 0 | 0 | 0 | 0 |  | 30 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 858.4 | 0 | 99.99 | 342.6 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  | 2848
DP | 83734 | 2024-02-23 00:00:00 | 2024-02-27 00:00:00 | 0 | 0 | 0 | 0 |  | 16 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 606.4 | 0 | 52.34 | 335.02 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  | 2360
DP | 76100W | 2024-02-02 00:00:00 | 2024-03-04 00:00:00 | 0 | 0 | 0 | 0 |  | 15 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 568.5 | 0 | 71.49 | 314.08 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  | 0
DP | 83823 | 2024-03-12 00:00:00 | 2024-03-15 00:00:00 | 0 | 0 | 0 | 0 |  | 7 | 4 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 265.3 | 227.4 | 42.51 | 254.88 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 390.84 | 0 |  |  | 7523
DP | 82980 | 2023-10-08 00:00:00 | 2023-10-09 00:00:00 | 0 | 0 | 0 | 0 |  | 4 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 147.6 | 0 | 12.73 | 80.73 | 0 |  |  |  |  | 0 | 0 |  | 140.15 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  | 0
DP | 83822 | 2024-03-12 00:00:00 | 2024-03-12 00:00:00 | 0 | 0 | 0 | 0 |  | 0 | 4 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 210.36 | 18.17 | 102.8 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  | 1783
DP | 83787 | 2024-03-04 00:00:00 | 2024-03-04 00:00:00 | 0 | 0 | 0 | 0 |  | 0 | 2 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 113.7 | 9.82 | 54.17 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  | 0
DP | 83188 | 2023-11-13 00:00:00 | 2023-11-30 00:00:00 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  | 19.63 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 4 |  |  |  | 0 | 0 |  |  | 0
DP | 83826 | 2024-03-12 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  | 22995
DP | 83848 | 2024-03-18 00:00:00 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  | 0
DP | 82654 | 2023-08-04 00:00:00 | 2024-03-18 00:00:00 | 2024-02-23 00:00:00 | 2830.89 | 0 | 0 |  | 687 | 4 | 0 |  | 192972.02 | 0 | 0 | 0 | 0 |  | 27364.68 | 253.26 | 3257.13 | 18729.75 | 0 |  |  |  |  | 248575.77 | 0 |  | 102895.19 | 0 |  | 8575 | 103250 | 14739.69 |  | 0 | 0 | 5834.9 |  |  |  | 210590.51 | 161570.41 |  |  | 659862
DP | 76750 | 2021-08-27 00:00:00 | 2023-12-15 00:00:00 | 2023-12-06 00:00:00 | 8258.49 | 0 | 0 |  | 12649 | 57.5 | 0 |  | 528948.01 | 0 | 0 | 0 | 0 |  | 418959.2 | 3329.18 | 45649.96 | 253597.3 | 0 |  |  |  |  | 752053.82 | 0 |  | 726496.12 | 0 |  | 6770 | 291310.54 | 22824.91 |  | 100242.78 | 438797.97 | 7021.13 |  |  |  | 0 | 2184034.34 |  |  | 2184034.34
DP | 82668 | 2023-08-07 00:00:00 | 2024-03-15 00:00:00 | 2024-02-21 00:00:00 | 23068.67 | 0 | 0 |  | 2059.5 | 208 | 1543 |  | 1210550.55 | 0 | 0 | 0 | 0 |  | 53988.83 | 5754.24 | 6337.85 | 23006.85 | 99396.59 |  |  |  |  | 2545436.3 | 0 |  | 846076.25 | 25.68 |  | 642280.97 | 0 | 235.98 |  | 3416.05 | 244793.05 | 3901.7 |  |  |  | 1149765.14 | 1509937.75 |  |  | 5159628
DP | 82607 | 2023-07-25 00:00:00 | 2024-03-12 00:00:00 | 2024-02-23 00:00:00 | 995.65 | 0 | 0 |  | 1034 | 8 | 0 |  | 55753.59 | 0 | 0 | 0 | 0 |  | 38960.93 | 255.77 | 4437.35 | 22172.42 | 0 |  |  |  |  | 66180.08 | 0 |  | 40835.26 | 0 |  | 0 | 0 | 2083.4 |  | 0 | 7585 | 192.42 |  |  |  | 0 | 146051 |  |  | 135380
DP | 83691 | 2024-02-16 00:00:00 | 2024-02-14 00:00:00 | 2024-03-05 00:00:00 | 0 | 0 | 0 |  | 8 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 303.2 | 0 | 58.31 | 167.52 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 714 |  |  | 0
DP | 83280 | 2023-12-04 00:00:00 | 2024-02-07 00:00:00 | 2024-03-04 00:00:00 | 0 | 0 | 0 |  | 20.5 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 828.2 | 0 | 159.68 | 472.56 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 1991.28 |  |  | 0
DP | 76930 | 2021-09-22 00:00:00 | 2024-01-18 00:00:00 | 2023-11-01 00:00:00 | 724.52 | 0 | 0 |  | 943 | 0 | 0 |  | 50585.99 | 0 | 0 | 0 | 0 |  | 36226.04 | 0 | 3288.4 | 20187.28 | 0 |  |  |  |  | 67264.98 | 0 |  | 54477.45 | 0 |  | 9500 | 18210 | 3335.86 |  | 4479.1 | 16660 | 1294.36 |  |  |  | 0 | 191282 |  |  | 196164
DP | 83583 | 2024-01-25 00:00:00 | 2024-02-02 00:00:00 | 2024-02-02 00:00:00 | 0 | 0 | 0 |  | 65 | 56 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 2953.14 | 4102.56 | 955.59 | 2887.84 | 0 |  |  |  |  | 0 | 0 |  | 13405.14 | 0 |  | 0 | 0 | 0 |  | 314.91 | 650 | 65.63 |  |  |  | 0 | 36111.9 |  |  | 36111.9
DP | 83670 | 2024-02-09 00:00:00 | 2024-02-09 00:00:00 | 2024-02-20 00:00:00 | 0 | 0 | 0 |  | 0 | 4 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 243.96 | 21.06 | 113.68 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 601.12 |  |  | 601.12
DP | 82254 | 2023-05-08 00:00:00 | 2023-07-06 00:00:00 | 2023-07-28 00:00:00 | 0 | 0 | 0 |  | 226 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 8339.4 | 0 | 722.18 | 4560.95 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 24776.12 |  |  | 24776.12
DP | 83566 | 2024-01-22 00:00:00 | 2024-02-05 00:00:00 | 2024-02-01 00:00:00 | 0 | 0 | 0 |  | 8 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 323.2 | 0 | 62.16 | 184.44 | 0 |  |  |  |  | 0 | 0 |  | 393.07 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 0 | 1758 |  |  | 1758
DP | 81010 | 2022-09-22 00:00:00 | 2022-12-01 00:00:00 | 2022-09-26 00:00:00 | 0 | 0 | 0 |  | 75 | 19.5 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 2022.3 | 582.53 | 224.47 | 714.03 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 2369 |  |  |  | 0 | 43660.81 |  |  | 0