Spreadsheet: 101216d1299352227-excel-2007-getting-vlookup-to-ignore-1st-ic-prov-and-return-value-on-second-ic-prov-sample
Sheet: template

INCL | -1 |  |  |  |  |  |  |  |  |  | TO |  | TO |  | TO |  | TO |  | TO | 0 | TO | TOTAL | TO
 |  |  |  |  |  |  |  | Per No | M/UP | 48 | INV | 49 | INV | 50 | INV | 51 | INV | 52 | INV | 0 | INV | PAYROLL | INV |  |  |  |  |  |  |  |  |  |  |  | Per No | 48 | 49 | 50 | 51 | 52
 |  |  | COST TO COMPANY BREAKDOWN |  |  |  |  | Date |  | 30/01/2011 |  | 06/02/2011 |  | 13/02/2011 |  | 20/02/2011 |  | 28/02/2010 |  | 0 |  |  |  |  | DATE | INV | INV NO |  | [NAME] | DR | CR | BAL |  | Co no | Date | 30/01/2011 | 06/02/2011 | 13/02/2011 | 20/02/2011 | 28/02/2010
 |  |  |  |  |  |  |  | TOTALS - |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 513 | TOTALS - | 0 | 0 | 0 | 0 | 0
Day | 0.4532 |  | SALES | 0 |  |  |  | Day | 0.4532 | 61330.31 | 89125.206492 | 41778.04 | 60711.847728 | 33400.33 | 48537.359556 | 43213.01 | 62797.146132 | 36227.11 | 52645.236252 | 0 | 0 | 215948.8 | 313816.79616 |  |  |  |  |  |  |  |  |  |  | 513 | Day | 61330.31 | 41778.04 | 33400.33 | 43213.01 | 36227.11
Afterno | 0.4532 |  |  |  |  |  |  | Afterno | 0.4532 | 25514.56 | 37077.75859200001 | 35384.78 | 51421.162296 | 27099.75 | 39381.3567 | 21768.49 | 31633.969668 | 22825.22 | 33169.609704 | 0 | 0 | 132592.8 | 192683.85696 |  |  |  |  |  |  |  |  |  |  | 513 | Afterno | 25514.56 | 35384.78 | 27099.75 | 21768.49 | 22825.22
Night | 0.4532 |  | A. EARNINGS (GROSS PAY) | 734738.27 |  |  |  | Night | 0.4532 | 35458.24 | 51527.914368 | 22846.24 | 33200.15596800001 | 33746.22 | 49040.006904 | 29064.77 | 42236.923764 | 28097.17 | 40830.807444 | 0 | 0 | 149212.64 | 216835.808448 |  |  |  |  |  |  |  |  |  |  | 513 | Night | 35458.24 | 22846.24 | 33746.22 | 29064.77 | 28097.17
Ot 1.3 | 0.4532 |  | COSTS INCLUDED IN MARK-UP |  |  |  |  | Ot 1.5 | 0.4532 | 14425.48 | 20963.107536 | 11348.16 | 16491.146112 | 7322.35 | 10640.83902 | 10253.15 | 14899.87758 | 9966.31 | 14483.041692 | 0 | 0 | 53315.45 | 77478.01194 |  |  |  |  |  |  |  |  |  |  | 513 | Ot 1.5 | 14425.48 | 11348.16 | 7322.35 | 10253.15 | 9966.31
Ot 1.5 | 0.4532 |  | Sick | 5937.6 |  |  |  | Ot 2.0 | 0.4532 | 5833.2 | 8476.80624 | 3717.28 | 5401.951296 | 2670.69 | 3881.046708 | 7315.44 | 10630.797408 | 1115.07 | 1620.419724 | 0 | 0 | 20651.68 | 30011.021376 |  |  |  |  |  |  |  |  |  |  | 513 | Ot 2.0 | 5833.2 | 3717.28 | 2670.69 | 7315.44 | 1115.07
Ot 2.0 | 0.4532 |  | Family | 1158.4 |  |  |  | N/S 1.5 | 0.4532 | 7934.59 | 11530.546188 | 8209.12 | 11929.493184 | 9064.7 | 13172.82204 | 3034.64 | 4409.938848 | 499.69 | 726.149508 | 0 | 0 | 28742.74 | 41768.94976800001 |  |  |  |  |  |  |  |  |  |  | 513 | N/S 1.5 | 7934.59 | 8209.12 | 9064.7 | 3034.64 | 499.69
N/S 1.3 | 0.4532 |  | WCA |  |  |  |  | N/S 2.0 | 0.4532 | 18529.07 | 26926.444524 | 5647.97 | 8207.630004 | 13659.49 | 19849.970868 | 12336.8 | 17927.83776 | 4663.63 | 6777.187116 | 0 | 0 | 54836.96 | 79689.070272 |  |  |  |  |  |  |  |  |  |  | 513 | N/S 2.0 | 18529.07 | 5647.97 | 13659.49 | 12336.8 | 4663.63
N/S 1.5 | 0.4532 |  | L/Bonus |  |  |  |  | A/S 1.5 | 0.4532 | 8716.13 | 12666.280116 | 9833.84 | 14290.536288 | 5416.92 | 7871.868144 | 7116.69 | 10341.973908 | 3891.3 | 5654.83716 | 0 | 0 | 34974.88 | 50825.495616 |  |  |  |  |  |  |  |  |  |  | 513 | A/S 1.5 | 8716.13 | 9833.84 | 5416.92 | 7116.69 | 3891.3
N/S 2.0 | 0.4532 |  | L/P out |  |  |  |  | A/S 2.0 | 0.4532 | 1380.15 | 2005.63398 | 1944.17 | 2825.267844 | 430.96 | 626.271072 | 621.74 | 903.512568 | 0 | 0 | 0 | 0 | 4377.02 | 6360.685464000001 |  |  |  |  |  |  |  |  |  |  | 513 | A/S 2.0 | 1380.15 | 1944.17 | 430.96 | 621.74 | 0
A/S 1.3 | 0.4532 |  |  |  |  |  |  | A/S ALL | 0.4532 | 2041.16 | 2966.213712 | 2830.75 | 4113.6459 | 2167.95 | 3150.46494 | 1741.46 | 2530.689672 | 1826.06 | 2653.630392 | 0 | 0 | 10607.38 | 15414.644616 |  |  |  |  |  |  |  |  |  |  | 513 | A/S ALL | 2041.16 | 2830.75 | 2167.95 | 1741.46 | 1826.06
A/S 1.5 | 0.4532 |  |  |  |  |  |  | N/S ALL | 0.4532 | 5318.74 | 7729.192968 | 3426.93 | 4980.014676 | 5061.94 | 7356.011208 | 4359.72 | 6335.545104000001 | 4214.59 | 6124.642188000001 | 0 | 0 | 22381.92 | 32525.406144 |  |  |  |  |  |  |  |  |  |  | 513 | N/S ALL | 5318.74 | 3426.93 | 5061.94 | 4359.72 | 4214.59
A/S 2.0 | 0.4532 |  |  |  |  |  |  | Sick | -1 | 2159.84 | 0 | 598.56 | 0 | 1589.6 | 0 | 1589.6 | 0 | 0 | 0 | 0 | 0 | 5937.6 | 0 |  |  |  |  |  |  |  |  |  |  | 513 | Sick | 2159.84 | 598.56 | 1589.6 | 1589.6 | 0
A/S ALL | 0.4532 |  | LESS | 7096 |  |  |  | Family | -1 | 0 | 0 | 463.36 | 0 | 231.68 | 0 | 463.36 | 0 | 0 | 0 | 0 | 0 | 1158.4 | 0 |  |  |  |  |  |  |  |  |  |  | 513 | Family | 0 | 463.36 | 231.68 | 463.36 | 0
N/S ALL | 0.4532 |  | DIFFERENCE | 727642.27 |  |  |  | *TOT:EARN* |  | 188641.47 |  | 148029.2 |  | 141862.58 |  | 142878.87 |  | 113326.15 |  | 0 |  | 734738.27 |  |  |  |  |  |  |  |  |  |  |  | 513 | *TOT:EARN* | 188641.47 | 148029.2 | 141862.58 | 142878.87 | 113326.15
BP Nrm | 0.4532 |  |  |  |  |  |  | Tax |  | 12271.07 |  | 8862.99 |  | 8752.49 |  | 9008.19 |  | -46160.51 |  | 0 |  | -7265.770000000004 |  |  |  |  |  |  |  |  |  |  |  | 513 | Tax | 12271.07 | 8862.99 | 8752.49 | 9008.19 | -46160.51
BP Over | 0.4532 |  | B. COMPANY CONTRIBUTIONS |  |  |  |  | U.I.F. |  | 1879.87 |  | 1480.22 |  | 1418.56 |  | 1428.75 |  | 1133.18 |  | 0 |  | 7340.58 |  |  |  |  |  |  |  |  |  |  |  | 513 | U.I.F. | 1879.87 | 1480.22 | 1418.56 | 1428.75 | 1133.18
Sick | -1 | inc | [NAME] |  |  |  |  | [NAME] |  | 8214.28 |  | 6670.36 |  | 6340.19 |  | 6342.29 |  | 5684.82 |  | 0 |  | 33251.94 |  |  |  |  |  |  |  |  |  |  |  | 513 | [NAME] | 8214.28 | 6670.36 | 6340.19 | 6342.29 | 5684.82
Family | -1 | inc | [NAME] | 717 |  |  |  | [NAME] |  | 166.5 |  | 162 |  | 127.5 |  | 129 |  | 132 |  | 0 |  | 717 |  |  |  |  |  |  |  |  |  |  |  | 513 | [NAME] | 166.5 | 162 | 127.5 | 129 | 132
WCA | -1 | inc | [NAME] | 17.17 |  |  |  | IC CBL |  | 1201.55 |  | 1195.61 |  | 946.22 |  | 954.33 |  | 861.87 |  | 0 |  | 5159.58 |  |  |  |  |  |  |  |  |  |  |  | 513 | IC CBL | 1201.55 | 1195.61 | 946.22 | 954.33 | 861.87
L/Bonus | -1 | inc | IC DRL | 253.34 |  |  |  | IC DRL |  | 58.83 |  | 57.24 |  | 45.05 |  | 45.58 |  | 46.64 |  | 0 |  | 253.34 |  |  |  |  |  |  |  |  |  |  |  | 513 | IC DRL | 58.83 | 57.24 | 45.05 | 45.58 | 46.64
L/P out | -1 | inc | [NAME] | 966.09 |  |  |  | [NAME] |  | 227.51 |  | 226.46 |  | 174.91 |  | 176.38 |  | 160.83 |  | 0 |  | 966.09 |  |  |  |  |  |  |  |  |  |  |  | 513 | [NAME] | 227.51 | 226.46 | 174.91 | 176.38 | 160.83
Pub.Hol | 0.01 |  |  |  |  |  |  | Union |  | 60.57 |  | 60.57 |  | 23.16 |  | 23.16 |  | 30.85 |  | 0 |  | 198.31 |  |  |  |  |  |  |  |  |  |  |  | 513 | Union | 60.57 | 60.57 | 23.16 | 23.16 | 30.85
Special | 0 |  |  |  |  |  |  | Transpo |  | 10109.26 |  | 10126.32 |  | 7802.27 |  | 0 |  | 0 |  | 0 |  | 28037.85 |  |  |  |  |  |  |  |  |  |  |  | 513 | Transpo | 10109.26 | 10126.32 | 7802.27 | 0 | 0
S-Day | 0.4532 |  |  |  |  |  |  | Advance1 |  | 393.53 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 393.53 |  |  |  |  |  |  |  |  |  |  |  | 513 | Advance1 | 393.53 | 0 | 0 | 0 | 0
S-Aft | 0.4532 |  |  | 1953.6 |  |  |  | Safety |  | 0 |  | 0 |  | 0 |  | 0 |  | 2093.13 |  | 0 |  | 2093.13 |  |  |  |  |  |  |  |  |  |  |  | 513 | Safety | 0 | 0 | 0 | 0 | 2093.13
S-Ot1.5 | 0.4532 |  |  |  |  |  |  | Garnish |  | 100 |  | 50 |  | 0 |  | 0 |  | 0 |  | 0 |  | 150 |  |  |  |  |  |  |  |  |  |  |  | 513 | Garnish | 100 | 50 | 0 | 0 | 0
Sp All | 0.4532 |  | C. U.I.F. | 7340.58 |  |  |  | *TOT:DED * |  | 34682.97 |  | 28891.77 |  | 25630.35 |  | 18107.68 |  | -36017.19 |  | 0 |  | 71295.57999999999 |  |  |  |  |  |  |  |  |  |  |  | 513 | *TOT:DED * | 34682.97 | 28891.77 | 25630.35 | 18107.68 | -36017.19
Advance | 0.4532 |  |  |  |  |  |  | *TOT:NET * |  | 153958.5 |  | 119137.43 |  | 116232.23 |  | 124771.19 |  | 149343.34 |  | 0 |  | 663442.69 |  |  |  |  |  |  |  |  |  |  |  | 513 | *TOT:NET * | 153958.5 | 119137.43 | 116232.23 | 124771.19 | 149343.34
 |  |  | D. SUNDRIES |  |  |  |  | U.I.F. |  | 1879.87 |  | 1480.22 |  | 1418.56 |  | 1428.75 |  | 1133.18 |  | 0 |  | 7340.58 |  |  |  |  |  |  |  |  |  |  |  | 513 | U.I.F. | 1879.87 | 1480.22 | 1418.56 | 1428.75 | 1133.18
 |  |  |  |  |  |  |  | [NAME] |  | 8214.28 |  | 6670.36 |  | 6340.19 |  | 6342.29 |  | 5684.82 |  | 0 |  | 33251.94 |  |  |  |  |  |  |  |  |  |  |  | 513 | [NAME] | 8214.28 | 6670.36 | 6340.19 | 6342.29 | 5684.82
 |  |  |  |  |  |  |  | [NAME] |  | 166.5 |  | 162 |  | 127.5 |  | 129 |  | 132 |  | 0 |  | 717 |  |  |  |  |  |  |  |  |  |  |  | 513 | [NAME] | 166.5 | 162 | 127.5 | 129 | 132
 |  |  |  |  |  |  |  | [NAME] |  | 0 |  | 0 |  | 0 |  | 0 |  | 17.17 |  | 0 |  | 17.17 |  |  |  |  |  |  |  |  |  |  |  | 513 | [NAME] | 0 | 0 | 0 | 0 | 17.17
 |  |  |  |  |  |  |  | IC DRL |  | 58.83 |  | 57.24 |  | 45.05 |  | 45.58 |  | 46.64 |  | 0 |  | 253.34 |  |  |  |  |  |  |  |  |  |  |  | 513 | IC DRL | 58.83 | 57.24 | 45.05 | 45.58 | 46.64
 |  |  |  |  |  |  |  | [NAME] |  | 227.51 |  | 226.46 |  | 174.91 |  | 176.38 |  | 160.83 |  | 0 |  | 966.09 |  |  |  |  |  |  |  |  |  |  |  | 513 | [NAME] | 227.51 | 226.46 | 174.91 | 176.38 | 160.83
 |  |  |  |  |  |  |  | SDL |  | 1886.4 |  | 1480.32 |  | 1418.64 |  | 1428.77 |  | 1133.18 |  | 0 |  | 7347.310000000001 |  |  |  |  |  |  |  |  |  |  |  | 513 | SDL | 1886.4 | 1480.32 | 1418.64 | 1428.77 | 1133.18
 |  |  |  |  |  |  |  | *TOT:CC  * |  | 12433.39 |  | 10076.6 |  | 9524.85 |  | 9550.77 |  | 8307.82 |  | 0 |  | 49893.43 |  |  |  |  |  |  |  |  |  |  |  | 513 | *TOT:CC  * | 12433.39 | 10076.6 | 9524.85 | 9550.77 | 8307.82
 |  |  | E. SDL | 7347.310000000001 |  |  |  | *TOT:COST* |  | 201074.86 |  | 158105.8 |  | 151387.43 |  | 152429.64 |  | 121633.97 |  | 0 |  | 784631.7 |  |  |  |  |  |  |  |  |  |  |  | 513 | *TOT:COST* | 201074.86 | 158105.8 | 151387.43 | 152429.64 | 121633.97
 |  |  |  |  |  |  |  | *TOT:PERK* |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 513 | *TOT:PERK* | 0 | 0 | 0 | 0 | 0
 |  |  | F. SLUSH |  |  |  |  | *TAX:EARN* |  | 188641.47 |  | 148029.2 |  | 141862.58 |  | 142878.87 |  | 113326.15 |  | 0 |  | 734738.27 |  |  |  |  |  |  |  |  |  |  |  | 513 | *TAX:EARN* | 188641.47 | 148029.2 | 141862.58 | 142878.87 | 113326.15
 |  |  | Day Shift | 7736.789999999999 |  |  |  | *TAX:NET * |  | 188641.47 |  | 148029.2 |  | 141862.58 |  | 142878.87 |  | 113326.15 |  | 0 |  | 734738.27 |  |  |  |  |  |  |  |  |  |  |  | 513 | *TAX:NET * | 188641.47 | 148029.2 | 141862.58 | 142878.87 | 113326.15
 |  |  | Aft Shift | 4757.66 |  |  |  | *RFI     * |  | 124462.95 |  | 101070.98 |  | 96067.58 |  | 96099.23 |  | 86135.5 |  | 0 |  | 503836.24 |  |  |  |  |  |  |  |  |  |  |  | 513 | *RFI     * | 124462.95 | 101070.98 | 96067.58 | 96099.23 | 86135.5
 |  |  | Night Sh | 5342.029999999999 |  |  |  | *EARN 11 * |  | 208473.6 |  | 211046.4 |  | 212044 |  | 214200 |  | 318994.25 |  | 0 |  | 1164758.25 |  |  |  |  |  |  |  |  |  |  |  | 513 | *EARN 11 * | 208473.6 | 211046.4 | 212044 | 214200 | 318994.25
 |  |  | Ot 1.5 | 1277.73 |  |  |  | *NO. EMP.* |  | 192 |  | 192 |  | 193 |  | 195 |  | 426 |  | 0 |  | 1198 |  |  |  |  |  |  |  |  |  |  |  | 513 | *NO. EMP.* | 192 | 192 | 193 | 195 | 426
 |  |  | Ot 2.0 | 363.58 |  |  |  | Day Shift |  | 2142.79 |  | 1458.07 |  | 1162.57 |  | 1552.8 |  | 1420.56 |  | 0 |  | 7736.789999999999 |  |  |  |  |  |  |  |  |  |  |  | 513 | Day Shift | 2142.79 | 1458.07 | 1162.57 | 1552.8 | 1420.56
 |  |  | NS 1.5 | 581.62 |  |  |  | Aft Shift |  | 911.29 |  | 1243.93 |  | 945.4 |  | 750.72 |  | 906.32 |  | 0 |  | 4757.66 |  |  |  |  |  |  |  |  |  |  |  | 513 | Aft Shift | 911.29 | 1243.93 | 945.4 | 750.72 | 906.32
 |  |  | NS 2.0 | 842.09 |  |  |  | Night Sh |  | 1250.95 |  | 784 |  | 1198.12 |  | 1006.06 |  | 1102.9 |  | 0 |  | 5342.029999999999 |  |  |  |  |  |  |  |  |  |  |  | 513 | Night Sh | 1250.95 | 784 | 1198.12 | 1006.06 | 1102.9
 |  |  | AS 1.5 | 773.78 |  |  |  | Ot 1.5 |  | 331.48 |  | 265.5 |  | 170.01 |  | 248.09 |  | 262.65 |  | 0 |  | 1277.73 |  |  |  |  |  |  |  |  |  |  |  | 513 | Ot 1.5 | 331.48 | 265.5 | 170.01 | 248.09 | 262.65
 |  |  | AS 2.0 | 74.13 |  |  |  | Ot 2.0 |  | 102.67 |  | 64 |  | 46.11 |  | 129.48 |  | 21.32 |  | 0 |  | 363.58 |  |  |  |  |  |  |  |  |  |  |  | 513 | Ot 2.0 | 102.67 | 64 | 46.11 | 129.48 | 21.32
 |  |  | [NAME] | 208 |  |  |  | NS 1.5 |  | 155.57 |  | 170 |  | 184.05 |  | 61 |  | 11 |  | 0 |  | 581.62 |  |  |  |  |  |  |  |  |  |  |  | 513 | NS 1.5 | 155.57 | 170 | 184.05 | 61 | 11
 |  |  | Family Hrs | 40 |  |  |  | NS 2.0 |  | 281.55 |  | 85.54 |  | 211 |  | 187 |  | 77 |  | 0 |  | 842.09 |  |  |  |  |  |  |  |  |  |  |  | 513 | NS 2.0 | 281.55 | 85.54 | 211 | 187 | 77
 |  |  |  |  |  |  |  | AS 1.5 |  | 192 |  | 213.05 |  | 118.73 |  | 155.58 |  | 94.42 |  | 0 |  | 773.78 |  |  |  |  |  |  |  |  |  |  |  | 513 | AS 1.5 | 192 | 213.05 | 118.73 | 155.58 | 94.42
 |  |  |  |  |  |  |  | AS 2.0 |  | 24 |  | 31.08 |  | 8 |  | 11.05 |  | 0 |  | 0 |  | 74.13 |  |  |  |  |  |  |  |  |  |  |  | 513 | AS 2.0 | 24 | 31.08 | 8 | 11.05 | 0
 |  |  |  |  |  |  |  | [NAME] |  | 72 |  | 24 |  | 56 |  | 56 |  | 0 |  | 0 |  | 208 |  |  |  |  |  |  |  |  |  |  |  | 513 | [NAME] | 72 | 24 | 56 | 56 | 0
 |  |  |  | 2199.741 |  |  |  | Family Hrs |  | 0 |  | 16 |  | 8 |  | 16 |  | 0 |  | 0 |  | 40 |  |  |  |  |  |  |  |  |  |  |  | 513 | Family Hrs | 0 | 16 | 8 | 16 | 0
 |  |  |  |  |  |  |  | *SHIFTS  * |  | 550 |  | 437 |  | 421 |  | 418 |  | 429 |  | 0 |  | 2255 |  |  |  |  |  |  |  |  |  |  |  | 513 | *SHIFTS  * | 550 | 437 | 421 | 418 | 429
 |  |  | G. PROVISIONS MADE |  |  | EARNINGS DERIVED |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | PROV LEAVE PAY | 34834.66656000001 | 0.069 | Day | 215948.8 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | PROV BONUS | 42054.024992 | 0.0833 | Afterno | 132592.8 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | PROV PUBLIC H. |  |  | Night | 149212.64 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | PROV WCA | 6159.172928 | 0.0122 | Sick | 5937.6 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  | Family | 1158.4 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 83047.86448 |  |  | 504850.24 | 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 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | TOTAL CC (A - G) |  |  | 829531.36548 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | LESS   *TOT:COST* |  |  | 784631.7 | AS PER VIP | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | DIFF |  |  | 44899.66548000008 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | LESS | PROVISIONS |  | -83047.86448 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | SLUSH |  | -2199.741 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | LESS INCL IN COSTS |  | 7096 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  | -33251.93999999992 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | TOTAL INV |  | 270995.104716 |  | 213572.851296 |  | 203508.0171600001 |  | 204648.212412 |  | 164685.56118 |  | 0 |  | 1057409.746764
 |  |  |  |  |  |  |  |  | INVOICED |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | DIFF |  | -270995.104716 |  | -213572.851296 |  | -203508.0171600001 |  | -204648.212412 |  | -164685.56118 |  | 0 |  | -1057409.746764
 |  |  | COMMISSION: |  |  |  |  |  | % |  | -1 |  | -1 |  | -1 |  | -1 |  | -1 |  |  |  | -1
 |  |  | SALES |  |  | 0
 |  |  | LESS COSTS |  |  | 829531.36548 |  | SALES | COST WAGES |  | COMPANY CONTR |  | UIF | SUNDRIES | SDL | SLUSH | PR L/P | PR BON | PR PPH | PR WCA | COST | DIFF | COMM
 |  |  | DIFFERENCE |  |  | -829531.36548 | #N/A | 0 | 727642.27 |  | 1953.6 |  | 7340.58 |  | 7347.310000000001 | 2199.741 | 34834.66656000001 | 42054.024992 | 0 | 6159.172928 | 829531.36548 | -829531.36548 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 784631.7 | TOT COST VIP | 0.25
 |  |  | COMMISSION | 0.25 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44899.66548000008 | DIFF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LESS | PROVISIONS |  | -83047.86448
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SLUSH |  | -2199.741
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LESS INCL IN COSTS |  | 7096
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -33251.93999999992