Spreadsheet: 33089d1229368801-if-statement-help-file
Sheet: Week 1

 |  |  |  |  |  |  |  |  |  |  |  |  | Closures Pension |  |  |  |  | Closures Life |  |  |  |  | Policy Maintenanc e
Worktype | Reportable Losses | OUR ERROR REPORTABLE LOSS | Reportable Gains | Non Reportable Losses | Non Reportable Gains | Area | Value | 2008-11-03 00:00:00 |  | OUR ERROR VALUE |  |  | Reportable Losses | Reportable Gains | Non Reportable Losses | Non Reportable Gains |  | Reportable Losses | Reportable Gains | Non Reportable Losses | Non Reportable Gains |  | Reportable Losses | Reportable Gains | Non Reportable Losses | Non Reportable Gains
Revtrout |  |  |  |  | 1045.95 | Pension | Reportable Losses | -7745.74 |  | 0
Revtrout |  |  |  |  | 259.72 | Pension | Reportable Gains | 70008.68000000001
Revtrout |  |  |  |  | 288.62 | Pension | Non Reportable Losses | -36037.50999999999 |  | OUR ERROR COUNT
Surrenders |  |  |  | -394.92 |  | Life | Non Reportable Gains | 99091.45 |  | #N/A
Cretterm |  |  |  |  | 1116.44 | Pension | Total Losses | -43783.24999999999
Cretterm |  |  |  |  | 372.55 | Pension | Total Gains | 169100.13
Cretterm |  |  | 627.12 |  |  | Pension
Cretterm |  |  | 368.44 |  |  | Pension
Cretterm |  |  | 620.82 |  |  | Pension
Cretterm |  |  | 1127.58 |  |  | Pension
Retterm |  |  |  |  | 474.45 | Pension
Retterm |  |  |  |  | 330.11 | Pension
Retterm |  |  |  | -625.49 |  | Pension
Penpo |  |  |  | -905.62 |  | Pension
Retterm |  |  |  |  | 450.39 | Pension
Retterm |  |  |  |  | 317.8 | Pension
Retterm |  |  |  |  | 860.03 | Pension | Closures Life
Retterm |  |  |  |  | 574.88 | Pension
Retterm |  |  |  |  | 563.8 | Pension | Value
Retterm |  |  |  |  | 302.96 | Pension | Reportable Losses | 0
Retterm |  |  |  |  | 1026.39 | Pension | Reportable Gains | 0
Retterm |  |  |  |  | 271.69 | Pension | Non Reportable Losses | 0
Retterm |  |  |  |  | 348.33 | Pension | Non Reportable Gains | 0
Retterm |  |  |  |  | 483.58 | Pension | Total Losses | 0
 |  |  | 1551.85 |  |  | #N/A | Total Gains | 0
Retterm |  |  |  | -536.7 |  | Pension
Retterm |  |  |  | -476.49 |  | Pension
Retterm |  |  |  | -273.7 |  | Pension | Closures Pension
Retterm |  |  |  |  | 412.76 | Pension
Retterm |  |  |  |  | 775.64 | Pension | Value
Penpo |  |  | 3408.71 |  |  | Pension | Reportable Losses | 0
Retterm |  |  |  |  | 388.25 | Pension | Reportable Gains | 0
Retterm |  |  |  |  | 361.5 | Pension | Non Reportable Losses | 0
Lifepo |  |  |  |  | 511.02 | Life | Non Reportable Gains | 0
Retterm |  |  |  | -376.33 |  | Pension | Total Losses | 0
Retterm |  |  |  | -380.31 |  | Pension | Total Gains | 0
Retterm |  |  |  |  | 422.1 | Pension
Retterm |  |  |  |  | 737.62 | Pension
Retterm |  |  |  |  | 321.16 | Pension | Policy Maintenance
Retterm |  |  |  |  | 320.65 | Pension
Cretterm |  |  |  |  | 466.09 | Pension | Value
Cretterm |  |  |  |  | 251.56 | Pension | Reportable Losses | 0
Cretterm |  |  | 397.56 |  |  | Pension | Reportable Gains | 0
Cretterm |  |  | 505.15 |  |  | Pension | Non Reportable Losses | 0
Cretterm |  |  | 264.79 |  |  | Pension | Non Reportable Gains | 0
Cretterm |  |  | 336.44 |  |  | Pension | Total Losses | 0
Revtrout |  |  |  |  | 540.95 | Pension | Total Gains | 0
Cretterm |  |  |  | -282.46 |  | Pension
Cretterm |  |  |  | -344.94 |  | Pension
Cretterm |  |  |  |  | 740.17 | Pension
Revtrout |  |  |  |  | 609.15 | Pension
Revtrout |  |  |  |  | 254.97 | Pension
Revtrout |  |  |  |  | 349.65 | Pension
Cretterm |  |  | 1191.98 |  |  | Pension
Cretterm |  |  | 1272.26 |  |  | Pension
Cretterm |  |  |  |  | 800.68 | Pension
Cretterm |  |  |  |  | 685.86 | Pension
Cretterm |  |  |  |  | 274.27 | Pension
Cretterm |  |  |  |  | 392.25 | Pension
Cretterm |  |  |  |  | 306.83 | Pension
Cretterm |  |  |  |  | 421.73 | Pension
Surrenders |  |  |  |  | 375.08 | Life
Pendss |  |  |  |  | 324.7 | Policy
Pendss |  |  |  |  | 284.49 | Policy
Pendss |  |  |  |  | 261.74 | Policy
Penpo |  |  |  |  | 453.64 | Pension
Penpo |  |  |  |  | 785.78 | Pension
Penpo |  |  |  |  | 751.82 | Pension
Retterm | -2123.29 |  |  |  |  | Pension
Retterm |  |  |  |  | 765.85 | Pension
Penpo |  |  |  |  | 629.13 | Pension
Retterm |  |  |  |  | 270.38 | Pension
Penpo |  |  |  | -294.58 |  | Pension
Lifepo |  |  |  |  | 563.92 | Life
 |  |  |  | -289.3 |  | #N/A
Penpo |  |  |  |  | 906.87 | Pension
Retterm |  |  |  |  | 749.89 | Pension
Retterm |  |  |  |  | 254.42 | Pension
Lifepo |  |  |  |  | 906.67 | Life
Penpo |  |  |  |  | 333.13 | Pension
Retterm |  |  |  | -359.53 |  | Pension
Lifepo |  |  |  |  | 632.08 | Life
Deathclaim |  |  |  |  | 868.18 | Life
Deathclaim |  |  |  |  | 905.14 | Life
Deathclaim |  |  |  |  | 364.6 | Life
Deathclaim |  |  |  |  | 455.35 | Life
Acriticaln | -3546.84 |  |  |  |  | Life
Surrenders |  |  |  |  | 578.72 | Life
Cretterm |  |  |  |  | 475.81 | Pension
Cretterm |  |  |  |  | 840.51 | Pension
Cretterm |  |  |  |  | 346.02 | Pension
Cretterm |  |  |  |  | 261.05 | Pension
Deathclaim |  |  | 1791.92 |  |  | Life
Deathclaim |  |  | 3385.01 |  |  | Life
Deathclaim |  |  | 976.16 |  |  | Life
Deathclaim |  |  | 612.49 |  |  | Life
Cretterm |  |  |  |  | 334.76 | Pension
Surrenders |  |  | 879.91 |  |  | Life
Surrenders |  |  | 856.93 |  |  | Life
Surrenders |  |  |  |  | 407.59 | Life
Cretterm |  |  |  |  | 545.78 | Pension
Cretterm |  |  |  |  | 488.7 | Pension
Cretterm |  |  |  |  | 315.2 | Pension
Cretterm |  |  |  |  | 326.55 | Pension
Surrenders |  |  |  | -687.91 |  | Life
Surrenders |  |  |  |  | 1428.75 | Life
Cretterm |  |  |  |  | 331.05 | Pension
Cretterm |  |  | 1745.54 |  |  | Pension
DSSRec |  |  |  |  | 5038.15 | Policy
DSSRec |  |  |  | -5248.39 |  | Policy
DSSRec |  |  |  |  | 2156.69 | Policy
DSSRec |  |  |  | -2246.69 |  | Policy
Penpo |  |  | 2374.65 |  |  | Pension
Penpo |  |  | 9149.24 |  |  | Pension
DSSRec |  |  |  |  | 1948.44 | Policy
DSSRec |  |  |  | -2029.74 |  | Policy
DSSRec |  |  |  |  | 1718.88 | Policy
DSSRec |  |  |  | -1790.61 |  | Policy
DSSRec |  |  |  |  | 1566.41 | Policy
DSSRec |  |  |  | -1631.77 |  | Policy
Penpo |  |  |  |  | 428.66 | Pension
DSSdeathpo |  |  |  |  | 1156.88 | Life
Retterm |  |  |  |  | 312.34 | Pension
Retterm |  |  |  |  | 671.52 | Pension
Retterm |  |  |  |  | 702.16 | Pension
Penpo |  |  |  |  | 473.51 | Pension
Retterm |  |  |  |  | 415.67 | Pension
Penpo |  |  |  |  | 359.62 | Pension
DSSdeathpo |  |  |  |  | 383.1 | Life
Retterm |  |  |  |  | 382 | Pension
Retterm |  |  |  |  | 750.08 | Pension
Retterm |  |  |  |  | 708.14 | Pension
Retterm |  |  |  |  | 419.72 | Pension
Retterm |  |  |  |  | 840.18 | Pension
Penpo |  |  |  |  | 843.4 | Pension
HB2Mat |  |  |  |  | 658.64 | Life
Eppalt |  |  |  |  | 578.39 | Policy
Cretterm |  |  |  |  | 806.31 | Pension
Eppalt |  |  |  | -653.83 |  | Policy
Cretterm |  |  |  |  | 532.32 | Pension
Cretterm |  |  | 1253.87 |  |  | Pension
Cretterm |  |  | 1446.19 |  |  | Pension
Revtrout |  |  |  |  | 604.27 | Pension
Revtrout |  |  |  |  | 377.73 | Pension
Revtrout |  |  |  |  | 509.52 | Pension
Revtrout |  |  |  |  | 321.53 | Pension
Revtrout |  |  |  |  | 567.16 | Pension
Cretterm |  |  | 879.37 |  |  | Pension
Cretterm |  |  | 830.78 |  |  | Pension
Cretterm |  |  |  |  | 744.23 | Pension
Cretterm |  |  |  |  | 479.6 | Pension
Retterm |  |  |  |  | 344.77 | Pension
Retterm |  |  |  |  | 1062.03 | Pension
Retterm |  |  |  |  | 259.75 | Pension
Retterm |  |  |  |  | 334.14 | Pension
Retterm |  |  | 1619.62 |  |  | Pension
Retannu |  |  |  |  | 1429.16 | Pension
Retterm |  |  | 10869.31 |  |  | Pension
Lifepo |  |  |  |  | 377.81 | Life
Retterm |  |  |  |  | 873.1 | Pension
Retterm |  |  |  |  | 471.36 | Pension
Retterm |  |  | 2365.44 |  |  | Pension
Retterm |  |  |  |  | 1029.75 | Pension
Retterm |  |  |  |  | 1132.64 | Pension
Retterm |  |  |  |  | 470.7 | Pension
Retterm |  |  | 3768.94 |  |  | Pension
Penpo |  |  |  |  | 381.56 | Pension
Lifepo |  |  | 1947.56 |  |  | Life
Retterm |  |  |  |  | 1215.11 | Pension
Lifepo | -913 |  |  |  |  | Life
Lifepo | -1162.61 |  |  |  |  | Life
Retterm |  |  |  |  | 430.52 | Pension
Retterm |  |  |  |  | 791.63 | Pension
Retterm |  |  | 4546.6 |  |  | Pension
Retterm |  |  |  |  | 344 | Pension
Retterm |  |  |  |  | 584.18 | Pension
Retannu |  |  |  |  | 1237.61 | Pension
Lifepo |  |  |  |  | 715.97 | Life
Retterm |  |  |  |  | 295.82 | Pension
Pendeathpo |  |  |  |  | 310.24 | Life
Lifepo |  |  |  | -1042.88 |  | Life
Penpo |  |  |  |  | 1036.4 | Pension
Penpo |  |  |  |  | 315.36 | Pension
Retterm |  |  |  |  | 299.26 | Pension
Retterm |  |  |  | -585.83 |  | Pension
Retterm |  |  |  | -714.11 |  | Pension
Retterm |  |  | 2496.22 |  |  | Pension
Cretterm |  |  |  | -263.16 |  | Pension
Revtrout |  |  |  | -662.13 |  | Pension
Cretterm |  |  |  |  | 554.62 | Pension
Cretterm |  |  |  |  | 535.37 | Pension
Cretterm |  |  |  |  | 482.06 | Pension
Cretterm |  |  |  | -494.44 |  | Pension
Penpo |  |  |  |  | 1298.41 | Pension
Retterm |  |  |  |  | 466.93 | Pension
Penfundsw |  |  |  |  | 1719.9 | Policy
Penfundsw |  |  |  | -1800.57 |  | Policy
Penfundsw |  |  |  |  | 2921.54 | Policy
Penfundsw |  |  |  | -3058.56 |  | Policy
Retterm |  |  |  | -311.79 |  | Pension
Penpo |  |  |  | -755.08 |  | Pension
Retterm |  |  |  | -438.75 |  | Pension
Retterm |  |  |  |  | 1361.38 | Pension
Retterm |  |  |  | -268.3 |  | Pension
Penpo |  |  |  | -328.87 |  | Pension
Retterm |  |  |  |  | 343.75 | Pension
Retterm |  |  |  | -449.9 |  | Pension
Retterm |  |  |  |  | 409.15 | Pension
Penpo |  |  |  |  | 492.36 | Pension
Retterm |  |  |  |  | 252.91 | Pension
Retterm |  |  |  |  | 372.36 | Pension
Retterm |  |  |  |  | 1401.31 | Pension
Retterm |  |  |  |  | 496.69 | Pension
Retterm |  |  |  | -300.05 |  | Pension
Retterm |  |  |  | -269.12 |  | Pension
Retterm |  |  |  |  | 265.75 | Pension
Penpo |  |  |  | -711.38 |  | Pension
Retterm |  |  |  | -528.8 |  | Pension
Retterm |  |  | 4540.23 |  |  | Pension
Penpo |  |  |  |  | 567.36 | Pension
Retterm |  |  |  | -506.02 |  | Pension
Lifepo |  |  |  |  | 937.01 | Life
Retterm |  |  |  | -679.59 |  | Pension
Retterm |  |  |  |  | 429.57 | Pension
Retterm |  |  |  |  | 390.71 | Pension
Deathpo |  |  |  | -687.77 |  | Life
Lifepo |  |  |  |  | 678.5 | Life
Retterm |  |  |  | -261.84 |  | Pension
Retterm |  |  |  |  | 737.18 | Pension
Penpo |  |  |  |  | 822.61 | Pension
Retterm |  |  |  | -1089.26 |  | Pension
 | -7745.74 | 0 | 70008.68000000001 | -36037.50999999999 | 99091.45
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0