Spreadsheet: 542148d1507730498-return-total-amount-values-based-on-multiple-criteria-542074d1507706459-return-total-amount-values-based-on-multiple-criteria-reporting
Sheet: FORECAST- PRE CONSTR.

 |  |  | Type of Claim | Pre Construction | Council | Base | Frame | [NAME] | Fix | PCI | Total
 |  |  | Forecasted Percentage of Return | 0 | 0.05 | 0.15 | 0.25 | 0.3 | 0.15 | 0.1 | 1
 |  |  | Forecasted Days of Return | 119 | 7 | 28 | 21 | 49 | 28 | 56 | 308
Job Number | Client Name | Total Claim | Start Date | Pre Construction | Council | Base | Frame | [NAME] | Fix | PCI | 2017-01-02 00:00:00 | 2017-01-09 00:00:00 | 2017-01-16 00:00:00 | 2017-01-23 00:00:00 | 2017-01-30 00:00:00 | 2017-02-06 00:00:00 | 2017-02-13 00:00:00 | 2017-02-20 00:00:00 | 2017-02-27 00:00:00 | 2017-03-06 00:00:00 | 2017-03-13 00:00:00 | 2017-03-20 00:00:00 | 2017-03-27 00:00:00 | 2017-04-03 00:00:00 | 2017-04-10 00:00:00 | 2017-04-17 00:00:00 | 2017-04-24 00:00:00 | 2017-05-01 00:00:00 | 2017-05-08 00:00:00 | 2017-05-15 00:00:00 | 2017-05-22 00:00:00 | 2017-05-29 00:00:00 | 2017-06-05 00:00:00 | 2017-06-12 00:00:00 | 2017-06-19 00:00:00 | 2017-06-26 00:00:00 | 2017-07-03 00:00:00 | 2017-07-10 00:00:00 | 2017-07-17 00:00:00 | 2017-07-24 00:00:00 | 2017-07-31 00:00:00 | 2017-08-07 00:00:00 | 2017-08-14 00:00:00 | 2017-08-21 00:00:00 | 2017-08-28 00:00:00 | 2017-09-04 00:00:00 | 2017-09-11 00:00:00 | 2017-09-18 00:00:00 | 2017-09-25 00:00:00 | 2017-10-02 00:00:00 | 2017-10-09 00:00:00 | 2017-10-16 00:00:00 | 2017-10-23 00:00:00 | 2017-10-30 00:00:00 | 2017-11-06 00:00:00 | 2017-11-13 00:00:00 | 2017-11-20 00:00:00 | 2017-11-27 00:00:00 | 2017-12-04 00:00:00 | 2017-12-11 00:00:00 | 2017-12-18 00:00:00 | 2017-12-25 00:00:00 | 2018-01-01 00:00:00 | 2018-01-08 00:00:00 | 2018-01-15 00:00:00 | 2018-01-22 00:00:00 | 2018-01-29 00:00:00 | 2018-02-05 00:00:00 | 2018-02-12 00:00:00 | 2018-02-19 00:00:00 | 2018-02-26 00:00:00 | 2018-03-05 00:00:00 | 2018-03-12 00:00:00 | 2018-03-19 00:00:00 | 2018-03-26 00:00:00 | 2018-04-02 00:00:00 | 2018-04-09 00:00:00 | 2018-04-16 00:00:00 | 2018-04-23 00:00:00 | 2018-04-30 00:00:00 | 2018-05-07 00:00:00 | 2018-05-14 00:00:00 | 2018-05-21 00:00:00 | 2018-05-28 00:00:00 | 2018-06-04 00:00:00 | 2018-06-11 00:00:00 | 2018-06-18 00:00:00 | 2018-06-25 00:00:00 | 2018-07-02 00:00:00 | 2018-07-09 00:00:00 | 2018-07-16 00:00:00 | 2018-07-23 00:00:00 | TOTAL
24262 | BBB | 467105 | 2017-06-29 00:00:00 | 2017-10-26 00:00:00 | 2017-11-02 00:00:00 | 2017-11-30 00:00:00 | 2017-12-21 00:00:00 | 2018-02-08 00:00:00 | 2018-03-08 00:00:00 | 2018-05-03 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23355.25 | 0 | 0 | 0 | 70065.75 | 0 | 0 | 116776.25 | 0 | 0 | 0 | 0 | 0 | 0 | 140131.5 | 0 | 0 | 0 | 70065.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 46710.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 467105
24266 | CCC | 469673 | 2017-05-25 00:00:00 | 2017-09-21 00:00:00 | 2017-09-28 00:00:00 | 2017-10-26 00:00:00 | 2017-11-16 00:00:00 | 2018-01-04 00:00:00 | 2018-02-01 00:00:00 | 2018-03-29 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23483.65 | 0 | 0 | 0 | 70450.95 | 0 | 0 | 117418.25 | 0 | 0 | 0 | 0 | 0 | 0 | 140901.9 | 0 | 0 | 0 | 70450.95 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 46967.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 469673
24267 | DDD | 466904 | 2017-05-25 00:00:00 | 2017-09-21 00:00:00 | 2017-09-28 00:00:00 | 2017-10-26 00:00:00 | 2017-11-16 00:00:00 | 2018-01-04 00:00:00 | 2018-02-01 00:00:00 | 2018-03-29 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23345.2 | 0 | 0 | 0 | 70035.59999999999 | 0 | 0 | 116726 | 0 | 0 | 0 | 0 | 0 | 0 | 140071.2 | 0 | 0 | 0 | 70035.59999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 46690.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 466904
24274 | EEE | 689845 | 2017-05-22 00:00:00 | 2017-09-18 00:00:00 | 2017-09-25 00:00:00 | 2017-10-23 00:00:00 | 2017-11-13 00:00:00 | 2018-01-01 00:00:00 | 2018-01-29 00:00:00 | 2018-03-26 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34492.25 | 0 | 0 | 0 | 103476.75 | 0 | 0 | 172461.25 | 0 | 0 | 0 | 0 | 0 | 0 | 206953.5 | 0 | 0 | 0 | 103476.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 68984.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 689845
24290 | FFF | 449427 | 2017-06-29 00:00:00 | 2017-10-26 00:00:00 | 2017-11-02 00:00:00 | 2017-11-30 00:00:00 | 2017-12-21 00:00:00 | 2018-02-08 00:00:00 | 2018-03-08 00:00:00 | 2018-05-03 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22471.35 | 0 | 0 | 0 | 67414.05 | 0 | 0 | 112356.75 | 0 | 0 | 0 | 0 | 0 | 0 | 134828.1 | 0 | 0 | 0 | 67414.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 44942.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 449427
24300 | GGG | 738848 | 2017-09-12 00:00:00 | 2018-01-09 00:00:00 | 2018-01-16 00:00:00 | 2018-02-13 00:00:00 | 2018-03-06 00:00:00 | 2018-04-24 00:00:00 | 2018-05-22 00:00:00 | 2018-07-17 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36942.4 | 0 | 0 | 0 | 110827.2 | 0 | 0 | 184712 | 0 | 0 | 0 | 0 | 0 | 0 | 221654.4 | 0 | 0 | 0 | 110827.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 73884.8 | 738848
24307 | HHH | 493014 | 2017-09-07 00:00:00 | 2018-01-04 00:00:00 | 2018-01-11 00:00:00 | 2018-02-08 00:00:00 | 2018-03-01 00:00:00 | 2018-04-19 00:00:00 | 2018-05-17 00:00:00 | 2018-07-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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24650.7 | 0 | 0 | 0 | 73952.09999999999 | 0 | 0 | 123253.5 | 0 | 0 | 0 | 0 | 0 | 0 | 147904.2 | 0 | 0 | 0 | 73952.09999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 49301.4 | 0 | 493014
24309 | III | 476612 | 2017-08-21 00:00:00 | 2017-12-18 00:00:00 | 2017-12-25 00:00:00 | 2018-01-22 00:00:00 | 2018-02-12 00:00:00 | 2018-04-02 00:00:00 | 2018-04-30 00:00:00 | 2018-06-25 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23830.6 | 0 | 0 | 0 | 71491.8 | 0 | 0 | 119153 | 0 | 0 | 0 | 0 | 0 | 0 | 142983.6 | 0 | 0 | 0 | 71491.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 47661.2 | 0 | 0 | 0 | 0 | 476612
24317 | JJJ | 604679 | 2017-09-19 00:00:00 | 2018-01-16 00:00:00 | 2018-01-23 00:00:00 | 2018-02-20 00:00:00 | 2018-03-13 00:00:00 | 2018-05-01 00:00:00 | 2018-05-29 00:00:00 | 2018-07-24 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 | 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 | 30233.95 | 0 | 0 | 0 | 90701.84999999999 | 0 | 0 | 151169.75 | 0 | 0 | 0 | 0 | 0 | 0 | 181403.7 | 0 | 0 | 0 | 90701.84999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 544211.1
24318 | KKK | 606327 | 2017-09-19 00:00:00 | 2018-01-16 00:00:00 | 2018-01-23 00:00:00 | 2018-02-20 00:00:00 | 2018-03-13 00:00:00 | 2018-05-01 00:00:00 | 2018-05-29 00:00:00 | 2018-07-24 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 | 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 | 30316.35 | 0 | 0 | 0 | 90949.05 | 0 | 0 | 151581.75 | 0 | 0 | 0 | 0 | 0 | 0 | 181898.1 | 0 | 0 | 0 | 90949.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 545694.3
TOTALS |  | 5462434 |  |  |  |  |  |  |  |  | 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 | 34492.25 | 46828.85000000001 | 0 | 0 | 103476.75 | 140486.55 | 45826.60000000001 | 172461.25 | 234144.25 | 0 | 137479.8 | 0 | 0 | 252963.6 | 206953.5 | 280973.1 | 24650.7 | 108434.2 | 164027.05 | 140486.55 | 468064.7 | 110827.2 | 181650.9 | 123253.5 | 322191.8 | 302751.5 | 68984.5 | 236641.3 | 0 | 0 | 147904.2 | 293146.2 | 454955 | 0 | 73952.09999999999 | 110827.2 | 181650.9 | 0 | 0 | 47661.2 | 0 | 0 | 49301.4 | 73884.8 | 5341333.399999999
 | Forecast PreConstr
 | Date | Amt | [NAME]
 | 2017-01-02 00:00:00 | 0 | Forecast PreConstr
 | 2017-01-09 00:00:00 | 0 | Forecast PreConstr
 | 2017-01-16 00:00:00 | 0 | Forecast PreConstr
 | 2017-01-23 00:00:00 | 0 | Forecast PreConstr
 | 2017-01-30 00:00:00 | 0 | Forecast PreConstr
 | 2017-02-06 00:00:00 | 0 | Forecast PreConstr
 | 2017-02-13 00:00:00 | 0 | Forecast PreConstr
 | 2017-02-20 00:00:00 | 0 | Forecast PreConstr
 | 2017-02-27 00:00:00 | 0 | Forecast PreConstr
 | 2017-03-06 00:00:00 | 0 | Forecast PreConstr
 | 2017-03-13 00:00:00 | 0 | Forecast PreConstr
 | 2017-03-20 00:00:00 | 0 | Forecast PreConstr
 | 2017-03-27 00:00:00 | 0 | Forecast PreConstr
 | 2017-04-03 00:00:00 | 0 | Forecast PreConstr
 | 2017-04-10 00:00:00 | 0 | Forecast PreConstr
 | 2017-04-17 00:00:00 | 0 | Forecast PreConstr
 | 2017-04-24 00:00:00 | 0 | Forecast PreConstr
 | 2017-05-01 00:00:00 | 0 | Forecast PreConstr
 | 2017-05-08 00:00:00 | 0 | Forecast PreConstr
 | 2017-05-15 00:00:00 | 0 | Forecast PreConstr
 | 2017-05-22 00:00:00 | 0 | Forecast PreConstr
 | 2017-05-29 00:00:00 | 0 | Forecast PreConstr
 | 2017-06-05 00:00:00 | 0 | Forecast PreConstr
 | 2017-06-12 00:00:00 | 0 | Forecast PreConstr
 | 2017-06-19 00:00:00 | 0 | Forecast PreConstr
 | 2017-06-26 00:00:00 | 0 | Forecast PreConstr
 | 2017-07-03 00:00:00 | 0 | Forecast PreConstr
 | 2017-07-10 00:00:00 | 0 | Forecast PreConstr
 | 2017-07-17 00:00:00 | 0 | Forecast PreConstr
 | 2017-07-24 00:00:00 | 0 | Forecast PreConstr
 | 2017-07-31 00:00:00 | 0 | Forecast PreConstr
 | 2017-08-07 00:00:00 | 0 | Forecast PreConstr
 | 2017-08-14 00:00:00 | 0 | Forecast PreConstr
 | 2017-08-21 00:00:00 | 0 | Forecast PreConstr
 | 2017-08-28 00:00:00 | 0 | Forecast PreConstr
 | 2017-09-04 00:00:00 | 0 | Forecast PreConstr
 | 2017-09-11 00:00:00 | 0 | Forecast PreConstr
 | 2017-09-18 00:00:00 | 0 | Forecast PreConstr
 | 2017-09-25 00:00:00 | 34492.25 | Forecast PreConstr
 | 2017-10-02 00:00:00 | 46828.85000000001 | Forecast PreConstr
 | 2017-10-09 00:00:00 | 0 | Forecast PreConstr
 | 2017-10-16 00:00:00 | 0 | Forecast PreConstr
 | 2017-10-23 00:00:00 | 103476.75 | Forecast PreConstr
 | 2017-10-30 00:00:00 | 140486.55 | Forecast PreConstr
 | 2017-11-06 00:00:00 | 45826.60000000001 | Forecast PreConstr
 | 2017-11-13 00:00:00 | 172461.25 | Forecast PreConstr
 | 2017-11-20 00:00:00 | 234144.25 | Forecast PreConstr
 | 2017-11-27 00:00:00 | 0 | Forecast PreConstr
 | 2017-12-04 00:00:00 | 137479.8 | Forecast PreConstr
 | 2017-12-11 00:00:00 | 0 | Forecast PreConstr
 | 2017-12-18 00:00:00 | 0 | Forecast PreConstr
 | 2017-12-25 00:00:00 | 252963.6 | Forecast PreConstr
 | 2018-01-01 00:00:00 | 206953.5 | Forecast PreConstr
 | 2018-01-08 00:00:00 | 280973.1 | Forecast PreConstr
 | 2018-01-15 00:00:00 | 24650.7 | Forecast PreConstr
 | 2018-01-22 00:00:00 | 108434.2 | Forecast PreConstr
 | 2018-01-29 00:00:00 | 164027.05 | Forecast PreConstr
 | 2018-02-05 00:00:00 | 140486.55 | Forecast PreConstr
 | 2018-02-12 00:00:00 | 468064.7 | Forecast PreConstr
 | 2018-02-19 00:00:00 | 110827.2 | Forecast PreConstr
 | 2018-02-26 00:00:00 | 181650.9 | Forecast PreConstr
 | 2018-03-05 00:00:00 | 123253.5 | Forecast PreConstr
 | 2018-03-12 00:00:00 | 322191.8 | Forecast PreConstr
 | 2018-03-19 00:00:00 | 302751.5 | Forecast PreConstr
 | 2018-03-26 00:00:00 | 68984.5 | Forecast PreConstr
 | 2018-04-02 00:00:00 | 236641.3 | Forecast PreConstr
 | 2018-04-09 00:00:00 | 0 | Forecast PreConstr
 | 2018-04-16 00:00:00 | 0 | Forecast PreConstr
 | 2018-04-23 00:00:00 | 147904.2 | Forecast PreConstr
 | 2018-04-30 00:00:00 | 293146.2 | Forecast PreConstr
 | 2018-05-07 00:00:00 | 454955 | Forecast PreConstr
 | 2018-05-14 00:00:00 | 0 | Forecast PreConstr
 | 2018-05-21 00:00:00 | 73952.09999999999 | Forecast PreConstr
 | 2018-05-28 00:00:00 | 110827.2 | Forecast PreConstr
 | 2018-06-04 00:00:00 | 181650.9 | Forecast PreConstr
 | 2018-06-11 00:00:00 | 0 | Forecast PreConstr
 | 2018-06-18 00:00:00 | 0 | Forecast PreConstr
 | 2018-06-25 00:00:00 | 47661.2 | Forecast PreConstr
 | 2018-07-02 00:00:00 | 0 | Forecast PreConstr
 | 2018-07-09 00:00:00 | 0 | Forecast PreConstr
 | 2018-07-16 00:00:00 | 49301.4 | Forecast PreConstr
 | 2018-07-23 00:00:00 | 73884.8 | Forecast PreConstr
 | TOTAL