Spreadsheet: 875973d1722604491-help-in-removing-the-div-o-in-a-cell-test
Sheet: Master 2024

Job Number | Customer | Sell Price | Contract (Due) Date | Ready to Ship Date | [NAME] to Ship On Time | Invoice Request Date | LABOR BUDGET $ | TOTAL LABOR $ | LABOR VARIANCE | MATERIAL BUDGET $ | TOTAL MATERIAL $ | MATERIAL [NAME] | TOTAL COST BUDGET | TOTAL ACTUAL COST | [NAME] | ON BUDGET | "As Sold" Budget Margin % | "As Completed" Margin | Difference between Budget / Completed | Completed Margin     (+Gain / -Loss) | As Sold Margin | Margin (+/-) As Sold Margin
23-4089 | Airco | 42576 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 |  | 2024-01-24 00:00:00 | 6446 | 8141.82 |  | 21211
24-4095 | Airco | 4386 | 2024-01-31 00:00:00 | 2024-01-30 00:00:00 |  | 2024-01-31 00:00:00 | 660 | 442.74 |  | 2186 | 1832.35
24-4103 | Airco | 2918 | 2024-01-31 00:00:00 | 2024-01-30 00:00:00 |  | 2024-01-31 00:00:00 | 275 | 429 |  | 1563 | 1822.7
23-4007 | Andritz | 50618 | 2024-01-10 00:00:00 | 2024-01-03 00:00:00 |  | 2024-01-17 00:00:00 | 16720 | 20137.34 |  | 17613.8
24-4102 | Bachmann - Canada | 8800 | 2024-03-08 00:00:00 | 2024-01-30 00:00:00 |  | 2024-01-31 00:00:00 | 1320 | 1651.83 |  | 2800
23-4086 | Bachmann - Syncrude Seals | 5100 | 2024-01-15 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 2255 | 2331.09 |  | 1050 | 1304.01
23-4087 | Bachmann - Syncrude Seals | 5100 | 2024-01-15 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 2255 | 1402.5 |  | 1050
23-4092 | [NAME] | 2624 | 2024-01-19 00:00:00 | 2024-01-18 00:00:00 |  | 2024-01-19 00:00:00 | 847 | 1041.33 |  | 925 | 772.51
24-4096 | [NAME] | 1980 | 2024-01-26 00:00:00 | 2024-01-18 00:00:00 |  | 2024-01-19 00:00:00 | 297 | 548.17 |  | 1046 | 758.46
24-4097 | [NAME] | 4350 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 |  | 2024-01-17 00:00:00 |  |  |  | 2520 | 2401.57
23-4065 | Black Mountain Sand | 4101 | 2024-01-16 00:00:00 | 2024-01-08 00:00:00 |  | 2024-01-10 00:00:00 | 379.5 | 763.58 |  | 2405.1 | 2477.1
23-4064 | Cleveland-Cliff | 10060 | 2023-12-20 00:00:00 | 2024-01-11 00:00:00 |  | 2024-01-15 00:00:00 | 4070 | 5478 |  | 2292.73 | 1912.43
23-4085 | Damper & Control Systems | 4320 | 2024-01-22 00:00:00 | 2024-01-12 00:00:00 |  | 2024-01-15 00:00:00 | 1562 | 1807.66 |  | 1372 | 1200.66
24-4111 | Eriks | 1275 | 2024-02-01 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 352 | 270.42 |  | 220 | 171.53
23-4091 | Kronospan | 1300 | 2024-01-08 00:00:00 | 2024-01-08 00:00:00 |  | 2024-01-10 00:00:00 | 0 |  |  | 715 | 796.46
24-4110 | L&M Industrial | 3235 | 2024-01-29 00:00:00 | 2024-01-29 00:00:00 |  | 2024-01-31 00:00:00 | 264 | 207.17 |  | 1349 | 1276.65
24-4099 | Mitsubishi Power | 11633.91 | 2024-01-16 00:00:00 | 2024-01-16 00:00:00 |  | 2024-01-19 00:00:00 |  |  |  | 6802.27 | 6802.27
23-4063 | North American Construction | 13950 | 2024-01-10 00:00:00 | 2024-01-02 00:00:00 |  | 2024-01-04 00:00:00 | 0 |  |  | 9474 | 9345.62
24-4104 | Power Systems | 3808.8 | 2024-02-06 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 |  |  |  | 1711 | 1623
24-4105 | Power Systems | 621 | 2024-02-06 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 |  |  |  | 275 | 175
23-4019 | St. Mary's Cement | 38701 | 2024-01-10 00:00:00 | 2024-01-03 00:00:00 |  | 2024-01-05 00:00:00 | 4398 |  |  | 21773.73
24-4098 | Technos | 10458.75 | 2024-01-19 00:00:00 | 2024-01-17 00:00:00 |  | 2024-01-19 00:00:00 | 1908.5 | 787.42 |  | 3517 | 3054.33
23-4077 | Valmet | 44730 | 2024-05-01 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 16351.5 | 14028.65 |  | 13993
2024-01-01 00:00:00
24-4094 |  | 8330 | 2024-02-28 00:00:00 | 2024-02-07 00:00:00 |  | 2024-02-07 00:00:00 | 4031.5 | 4672.24 |  | 1479
23-4081 |  | 61475 | 2024-01-05 00:00:00 | 2024-02-07 00:00:00 |  | 2024-02-09 00:00:00 | 20020 | 21225.41 |  | 14500 | 14073.12
24-4106 |  | 1025 | 2024-02-01 00:00:00 | 2024-02-07 00:00:00 |  | 2024-02-08 00:00:00 | 481.25 | 386.83
24-4112 |  | 680 | 2024-02-26 00:00:00 | 2024-02-06 00:00:00 |  | 2024-02-06 00:00:00 | 121 | 66.92 |  | 255 | 240.43
24-4107 |  | 1800 | 2024-03-07 00:00:00 | 2024-02-05 00:00:00 |  | 2024-02-05 00:00:00 | 440 | 378.58 |  | 560 | 309.32
24-4113 |  | 900 | 2024-02-10 00:00:00 | 2024-02-02 00:00:00 |  | 2024-02-05 00:00:00 | 352 |  |  | 153.4 | 154.66
24-4101 |  | 480 | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 |  | 2024-02-01 00:00:00 |  |  |  | 145 | 235
24-4093 |  | 1315 | 2024-03-01 00:00:00 | 2024-02-11 00:00:00 |  | 2024-02-14 00:00:00 |  |  |  | 876 | 859.49
24-4118 |  | 5200 | 2024-02-29 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-22 00:00:00 |  |  |  | 3372 | 3208.5
24-4115 |  | 3808.8 | 2024-03-04 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-22 00:00:00 |  |  |  | 1711 | 1725.55
24-4116 |  | 5875 | 2024-03-04 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-22 00:00:00 | 1100 | 483.09 |  | 1605
24-4117 |  | 16560 | 2024-03-11 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-26 00:00:00 | 6143.5 | 4155.26 |  | 4608 | 1814.8
24-4127 |  | 8210 | 2024-02-27 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-26 00:00:00 | 1540 | 258.5 |  | 2154 | 1854.52
24-4109 |  | 47200 | 2024-05-23 00:00:00 | 2024-02-19 00:00:00 |  | 2024-02-26 00:00:00 | 7150 | 4391.75 |  | 18038
24-4126 |  | 1360 | 2024-03-22 00:00:00 | 2024-02-26 00:00:00 |  | 2024-02-28 00:00:00 | 242 | 110.92 |  | 492 | 459.76
24-4124 |  | 6895 | 2024-03-15 00:00:00 | 2024-02-29 00:00:00 |  | 2024-02-29 00:00:00 | 1408 | 507.53 |  | 3038 | 2702.61
23-4090 |  | 880 | 2024-02-28 00:00:00 | 2024-02-28 00:00:00 |  | 2024-02-28 00:00:00 |  |  |  | 88 | 88
23-4077 |  | 1000 | 2024-05-01 00:00:00 | 2024-02-15 00:00:00 |  | 2024-02-15 00:00:00 | 440 | 440 |  | 210 | 210
24-4122 |  | 500 | 2024-03-13 00:00:00 | 2024-02-15 00:00:00 |  | 2024-02-15 00:00:00 |  |  |  | 50 | 50
2024-02-01 00:00:00
24-4108 |  | 2807 | 2024-03-07 00:00:00 | 2024-02-23 00:00:00 |  | 2024-03-07 00:00:00 | 660 | 251.17 |  | 1164 | 1388.9
24-4129 |  | 2560 | 2024-03-04 00:00:00 | 2024-03-01 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 1211 | 1112.54
24-4100 |  | 5425 | 2024-03-04 00:00:00 | 2024-03-04 00:00:00 |  | 2024-03-04 00:00:00 | 605 | 443.67 |  | 2377 | 1481.42
24-4121 |  | 3450 | 2024-03-15 00:00:00 | 2024-02-27 00:00:00 |  | 2024-03-07 00:00:00 | 1083.5 | 1693.08 |  | 1072
24-4137 |  | 5890 | 2024-03-11 00:00:00 | 2024-03-11 00:00:00 |  | 2024-03-11 00:00:00 | 715 | 198.92 |  | 1836
24-4123 |  | 4135 | 2024-03-20 00:00:00 | 2024-03-08 00:00:00 |  | 2024-03-11 00:00:00 | 1853.5 | 1819.59 |  | 727
24-4131 |  | 2250 | 2024-03-11 00:00:00 | 2024-03-08 00:00:00 |  | 2024-03-11 00:00:00 | 825 | 590.34 |  | 654 | 406.4
24-4125 |  | 4265 | 2024-03-20 00:00:00 | 2024-03-08 00:00:00 |  | 2024-03-13 00:00:00 | 946 | 534.42 |  | 1820 | 1847.7
24-4133 |  | 2100 | 2024-03-20 00:00:00 | 2024-03-11 00:00:00 |  | 2024-03-13 00:00:00 | 863.5 | 439.08 |  | 501 | 438.8
24-4139 |  | 2075 | 2024-03-27 00:00:00 | 2024-03-22 00:00:00 |  | 2024-03-25 00:00:00 | 495 | 356.59 |  | 734 | 686.13
24-4119 |  | 3825 | 2024-03-22 00:00:00 | 2024-03-22 00:00:00 |  | 2024-03-25 00:00:00 | 330 | 55 |  | 2166.64 | 1884.32
24-4134 |  | 3510 | 2024-04-01 00:00:00 | 2024-03-27 00:00:00 |  | 2024-03-28 00:00:00 | 550 | 297.92 |  | 1172 | 1537.1
24-4114 |  | 27969 | 2024-04-11 00:00:00 | 2024-03-27 00:00:00 |  | 2024-03-28 00:00:00 | 10505 | 11896.5 |  | 8500
24-4128 |  | 19430 | 2024-04-08 00:00:00 | 2024-03-29 00:00:00 |  | 2024-04-01 00:00:00 |  |  |  | 13210 | 11998
2024-03-01 00:00:00
24-4146 |  | 21345 | 2024-04-02 00:00:00 | 2024-04-01 00:00:00 |  | 2024-04-01 00:00:00 | 0 |  |  | 13233 | 12975
24-4132 |  | 16476 | 2024-03-22 00:00:00 | 2024-03-28 00:00:00 |  | 2024-04-08 00:00:00 |  |  |  | 9170.88 | 8082.19
24-4150 |  | 2440 | 2024-04-02 00:00:00 | 2024-04-02 00:00:00 |  | 2024-04-08 00:00:00 |  |  |  | 1302.16
24-4147 |  | 28130 | 2024-04-10 00:00:00 | 2024-04-10 00:00:00 |  | 2024-04-10 00:00:00 | 7139 | 5214 |  | 11128 | 9545.76
24-4158 |  | 3610 | 2024-04-12 00:00:00 | 2024-04-15 00:00:00 |  | 2024-04-15 00:00:00 | 935 | 1056.91 |  | 894
24-4120 |  | 95880 | 2024-04-15 00:00:00 | 2024-04-12 00:00:00 |  | 2024-04-15 00:00:00 | 32560 | 20405.01 |  | 26889.24 | 20693.08
24-4141 |  | 7505 | 2024-04-30 00:00:00 | 2024-04-17 00:00:00 |  | 2024-04-17 00:00:00 | 1199 | 692.08 |  | 3592 | 3036.42
24-4143 |  | 16470 | 2024-04-16 00:00:00 | 2024-04-15 00:00:00 |  | 2024-04-16 00:00:00 |  |  |  | 7416 | 7424
24-4136 |  | 12200 | 2024-04-15 00:00:00 | 2024-04-15 00:00:00 |  | 2024-04-16 00:00:00 | 3355 | 3287.17 |  | 4212.16
24-4155 |  | 900 | 2024-05-10 00:00:00 | 2024-04-22 00:00:00 |  | 2024-04-22 00:00:00 | 247.5 | 220 |  | 265 | 160.61
24-4130 |  | 5495 | 2024-04-22 00:00:00 | 2024-04-19 00:00:00 |  | 2024-04-19 00:00:00 |  |  |  | 3736 | 3676.02
24-4145 |  | 5460 | 2024-04-29 00:00:00 | 2024-04-22 00:00:00 |  | 2024-04-22 00:00:00 | 1815 | 1967.17 |  | 1422 | 946.24
24-4148 |  | 13605 | 2024-04-19 00:00:00 | 2024-04-19 00:00:00 |  | 2024-04-22 00:00:00 | 1375 | 1227.42 |  | 5554 | 2967.11
24-4159 |  | 3200 | 2024-04-15 00:00:00 | 2024-04-16 00:00:00 |  | 2024-04-22 00:00:00 | 715 | 747.08 |  | 1422 | 572.15
24-4135 |  | 8862 | 2024-04-22 00:00:00 | 2024-04-19 00:00:00 |  | 2024-04-23 00:00:00 | 4441.25 | 4521.92 |  | 1581 | 1448.21
24-4166 |  | 7848 | 2024-04-25 00:00:00 | 2024-04-23 00:00:00 |  | 2024-04-23 00:00:00 | 1738 | 1344.75 |  | 2184 | 1884.38
24-4138 |  | 5728 | 2024-04-26 00:00:00 | 2024-04-25 00:00:00 |  | 2024-04-26 00:00:00 | 1509.75 | 1540 |  | 2173 | 1284.94
24-4151 |  | 2140 | 2024-04-26 00:00:00 | 2024-04-26 00:00:00 |  | 2024-04-29 00:00:00 |  |  |  | 1284 | 1068.23
24-4142 |  | 17488 | 2024-04-26 00:00:00 | 2024-04-26 00:00:00 |  | 2024-04-29 00:00:00 | 1265 | 639.84 |  | 10583 | 10029.01
24-4163 |  | 2500 | 2024-04-23 00:00:00 | 2024-04-19 00:00:00 |  | 2024-04-29 00:00:00 |  |  |  | 1170
24-4164 |  | 3675 | 2024-04-30 00:00:00 | 2024-04-29 00:00:00 |  | 2024-04-29 00:00:00 | 759 | 553.67 |  | 1259.5 | 1140.45
 |  | 1000 | 2024-04-28 00:00:00 | 2024-04-28 00:00:00 |  | 2024-04-30 00:00:00 |  |  |  | 163 | 163
2024-04-01 00:00:00
24-4165 |  | 850 | 2024-05-03 00:00:00 | 2024-05-03 00:00:00 |  | 05/06/2024 | 165 | 22.92 |  | 213.21 | 201.97
24-4157 |  | 4000 | 2024-05-13 00:00:00 | 2024-05-03 00:00:00 |  | 05/06/2024 | 1760 | 1103.67
24-4152 |  | 23809 | 2024-05-15 00:00:00 | 2024-05-07 00:00:00 |  | [NAME] | 2970 | 3212.92 |  | 12730 | 10533.4
24-4167 |  | 5260 | 2024-05-10 00:00:00 | 2024-05-09 00:00:00 |  | 05/10/2024 |  |  |  | 2825.6 | 2980.76
24-4154 |  | 9485 | 2024-05-24 00:00:00 | 2024-05-09 00:00:00 |  | 05/14/2024 | 1540 | 1294.34 |  | 4134.72
24-4171 |  | 2010 | 2024-05-15 00:00:00 | 2024-05-15 00:00:00 |  | 05/16/2024 | 401.5 |  |  | 392
24-4162 |  | 9900 | 2024-05-13 00:00:00 | 2024-05-13 00:00:00 |  | 05/13/2024 | 2585 | 2583.16 |  | 3219.52 | 1638.96
23-4045 |  | 383798 | 2024-04-08 00:00:00 | 2024-04-08 00:00:00 |  | 05/17/2024 |  |  |  | 237804.75 | 226906.75
23-4067 |  | 119480 | 2024-06-26 00:00:00 | 2024-05-30 00:00:00 |  | 05/31/2024 | 19030 | 21564.59 |  | 57080.25
24-4172 |  | 23288 | 2024-05-23 00:00:00 | 2024-05-23 00:00:00 |  | [NAME] | 2915 | 2119.33 |  | 7097
24-4174 |  | 4930 | 2024-06-03 00:00:00 | 2024-05-31 00:00:00 |  | 05/31/2024 | 1705 | 2618.93 |  | 1249
24-4149 |  | 5430 | 2024-05-08 00:00:00 | 2024-05-08 00:00:00 |  | 05/13/2024 | 918.5 | 911.17 |  | 2061
24-4161 |  | 36350 | 2024-05-20 00:00:00 | 2024-05-20 00:00:00 |  | 05/31/2024 | 7755 | 5195.66 |  | 15000 | 16284.14
24-4156 |  | 16990 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00 |  | 2024-06-05 00:00:00 | 715 | 582.08 |  | 8987.5
2024-05-01 00:00:00
24-4178 |  | 5625 | 2024-06-05 00:00:00 | 2024-06-05 00:00:00 |  | 06/05/2024 |  |  |  | 3168.3 | 3137.85
24-4194 |  | 2520 | 2024-06-14 00:00:00 | 2024-06-11 00:00:00 |  | 06/12/2024 | 605 | 989.08 |  | 840 | 740.06
24-4169 |  | 4250 | 2024-06-10 00:00:00 | 2024-06-10 00:00:00 |  | 06/12/2024 | 880 | 758.1 |  | 1800 | 1630.08
24-4144 |  | 38584 | 2024-06-17 00:00:00 | 2024-06-04 00:00:00 |  | 06/12/2024 | 6820 | 6181.09 |  | 16200
24-4173 |  | 2125 | 2024-06-14 00:00:00 | 2024-06-07 00:00:00 |  | 06/14/2024 | 990 | 303.42 |  | 275 | 376.34
24-4190 |  | 1360 | 2024-07-01 00:00:00 | 2024-06-17 00:00:00 |  | 06/18/2024 | 242 | 18.33 |  | 568 | 459.76
24-4186 |  | 2776 | 2024-06-11 00:00:00 | 2024-06-16 00:00:00 |  | 06/18/2024 | 946 | 531.67 |  | 446
24-4187 |  | 1060 | 2024-06-11 00:00:00 | 2024-06-11 00:00:00 |  | 06/18/2024 | 165 | 44.92 |  | 424.52 | 381.4
24-4170 |  | 15280 | 2024-06-17 00:00:00 | 2024-06-18 00:00:00 |  | 06/24/2024 | 5170 | 4565.9 |  | 5000 | 3903.48
24-4192 |  | 18750 | 2024-07-18 00:00:00 | 2024-06-24 00:00:00 |  | 06/27/2024 | 3630 | 2211.73 |  | 7530 | 7391.77
24-4181 |  | 19380 | 2024-07-01 00:00:00 | 2024-06-28 00:00:00 |  | 07/01/2024 | 7507.5 | 6162.74 |  | 5567.85 | 3628.19
24-4200 |  | 2750 | 2024-06-24 00:00:00 | 2024-06-24 00:00:00 |  | 06/27/2024 |  |  |  | 1569 | 1319.5
24-4180 |  | 12050 | 2024-06-25 00:00:00 | 2024-06-27 00:00:00 |  | 07/07/2024 |  |  |  | 7227 | 6882
2024-06-01 00:00:00
24-4183 |  | 23980 | 2024-07-16 00:00:00 | 2024-07-08 00:00:00 |  | 07/11/2024 | 6765 |  |  | 8939
24-4212 |  | 4355 | 2024-07-31 00:00:00 | 2024-07-11 00:00:00 |  | 07/11/2024 |  |  |  | 2611
24-4202 |  | 2050 | 2024-07-19 00:00:00 | 2024-07-09 00:00:00 |  | 07/12/2024 | 286
24-4216 |  | 550 | 2024-07-17 00:00:00 | 2024-07-18 00:00:00 |  | 07/23/2024 | 55 |  |  | 225
24-4217 |  |  | 2024-07-24 00:00:00 | 2024-07-24 00:00:00 |  | 07/24/2024
24-4193 |  | 16200 | 2024-07-09 00:00:00 | 2024-07-10 00:00:00 |  | 07/24/2024 |  |  |  | 9070
24-4182 |  | 4415 | 2024-07-08 00:00:00 | 2024-07-09 00:00:00 |  | 07/24/2024 |  |  |  | 2470
24-4209 |  | 740 | 2024-07-18 00:00:00 | 2024-07-18 00:00:00 |  | 07/24/2024 | 165 |  |  | 220
24-4197 |  | 83080 | 2024-07-12 00:00:00 | 2024-07-12 00:00:00 |  | 07/30/2024 | 37455 |  |  | 11907.7
24-4203 |  | 6760 | 2024-07-24 00:00:00 | 2024-07-31 00:00:00 |  | 07/31/2024 | 291.5 |  |  | 3578
24-4214 |  | 5260 | 2024-07-24 00:00:00 | 2024-07-31 00:00:00 |  | 07/31/2024 |  |  |  | 3018.32
2024-07-01 00:00:00
2024-08-01 00:00:00
Year To Date Total
 |  |  |  |  | SUMMARY OF YEAR TO DATE RESULTS
 |  |  |  |  | On                          Time               Shipped | Total Shipped | Not on Time | As Sold Margin | As Completed Margin | Completed Margin            (+Gain / -Loss) | As Sold Margin | Margin (+/-) As Sold Margin | # of Shipments Under Budget | # of Shipments over Budget
 |  |  |  |  |  |  | [NAME] | On Time | Late
 |  |  |  |  |  | Jan | 23 | 20 | 3
 |  |  |  |  |  | Feb | 19 | 17 | 2
 |  |  |  |  |  | Mar | 14 | 14
 |  |  |  |  |  | Apr | 22 | 20 | 2
 |  |  |  |  |  | May | 14 | 14
 |  |  |  |  |  | Jun | 13 | 12 | 1
 |  |  |  |  |  | Jul
 |  |  |  |  |  | Aug
 |  |  |  |  |  | Sep
 |  |  |  |  |  | Oct
 |  |  |  |  |  | Nov
 |  |  |  |  |  | Dec
 |  |  |  |  |  | Totals