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

 |  |  | Type of Claim | Base | Frame | [NAME] | Fix | PCI | Total
 |  |  | Forecasted Percentage of Return | 0.15 | 0.25 | 0.3 | 0.15 | 0.1
 |  |  | Forecasted Days of Return | 28 | 21 | 49 | 28 | 56
Job Number | Client Name | Total Claim | Start Date | Base | Frame | [NAME] | Fix | PCI | 2017-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-09-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
24163 | B | 696252
24169 | C | 358927
24188 | D | 485170
24191 | E | 504204
24200 | F | 448000
24201 | G | 334000
24203 | H | 645601
24205 | I | 557671
24206 | J | 848123
24210 | K | 525434
24213 | L | 700769
24218 | M | 508167.18
24219 | N | 465649
24221 | O | 634908
24222 | P | 641321
24223 | Q | 412575
24225 | R | 489615
24226 | S | 417310
24228 | T | 540652
24233 | U | 474915
24234 | V | 463928
24235 | W | 835198
24239 | X | 498279
24240 | Y | 426051
24242 | Z | 587991
24243 | AA | 560651
24247 | BB | 540329
24248 | CC | 502112
24249 | DD | 501327
24250 | EE | 509100
24251 | FF | 662899
24253 | GG | 563417
24254 | HH | 484797
24256 | II | 452923
24258 | JJ | 750182
24260 | KK | 458232
24263 | LL | 578932
24268 | MM | 362138
24273 | NN | 569231
24275 | OO | 489013
24277 | PP | 456576
24281 | QQ | 1142285
24283 | RR | 550678
24285 | SS | 661425
24287 | TT | 280255
24288 | UU | 456765
24289 | VV | 641016
24292 | WW | 420479
24297 | XX | 692233
24298 | YY | 593172
24304 | ZZ | 694689
24305 | AAA | 553986
TOTALS
 |  |  |  |  |  |  |  |  |  | Date | Amt | [NAME]
 |  |  |  |  |  |  |  |  |  | 2017-01-02 00:00:00 | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 104437.8 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 96840.15 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 243910.35 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 178298.5 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 236602.95 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 411541.75 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 158794.65 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 266295.35 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 399854.5 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 84097.65 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 775456.6 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 447019.7999999999 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 674360.25 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 853909.35 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 207633.15 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 1048483.1 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 616839.6 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 516251.227 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 441445.55 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 488387.55 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 442121.595 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 1237803.65 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 200733.6 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 1118362.5 | ForecastConstr
 |  |  |  |  |  |  |  |  |  | 2017-09-18 00:00:00 | 518301.4 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 886660.2 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 655114 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 1251848 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 1358029.85 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 935394.05 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 1161682.65 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 452030.8 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 480567.054 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 263395.4 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 774504.1000000001 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 1040318.15 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 332563.6 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 683910.4 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 510830.777 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 271931.85 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 82601.7 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 453129.3 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 245932.55 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 88975.8 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 225946.1 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 181287.9 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 55067.8 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 183451.8 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 107158.418 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 48901.3 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 59317.2 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr
 |  |  |  |  |  |  |  |  |  |  | 0 | ForecastConstr