Spreadsheet: 86176d1286206192-vba-for-grouping-and-colouring-rows-uat-dashboard-2010-wip
Sheet: Completed

UAT COMPLETED JOBS LIST 2010 | AREA | TYPE | [NAME] | RELEASED TO UAT | IMPLEMENTED | DURATION |  | JOB SIZE | AVERAGE TURNAROUND
[NAME] Wheels | Motor Claims | [NAME] | New policy set up covering car and motorbike | 2010-01-20 00:00:00 | 2010-01-22 00:00:00 | 2 |  | ALL | 25.05
Claims Listing for PRN MI Report | Motor Claims | [NAME] | Report to show number of PRN referrals | 2009-11-11 00:00:00 | 2010-01-25 00:00:00 | 75 |  | SMALL (0 - 10 days) | 3.75
ITP New Law Decline Letter | Motor Claims | ITP | Letter to insured confirming they have declined | 2010-01-11 00:00:00 | 2010-01-25 00:00:00 | 14 |  | MEDIUM (11 - 20 days) | 15.25
New Law Enhancements | Motor Claims | [NAME] | Referral functionality updated to XML | 2010-01-11 00:00:00 | 2010-01-25 00:00:00 | 14 |  | LARGE  (21 - 50 days) | 35.76470588235294
New Law Excess on FNOC | Motor Claims | [NAME] | Excess was not coming across into instruction | 2010-01-29 00:00:00 | 2010-01-29 00:00:00 | 0 |  | X LARGE (51 - 99 days) | 66.16666666666667
Credit Hire To CT contact issue | Motor Claims | [NAME] | Contact reference was not being added to claim correctly if added manually | 2010-02-01 00:00:00 | 2010-02-01 00:00:00 | 0 |  | SUPER (100 + days) | 121.5
Fraud Triggers Motor - Robot Reports | Motor Claims | [NAME] | Providing workflow to fraud team on claims that could be potential fraud | 2010-01-29 00:00:00 | 2010-02-02 00:00:00 | 4
Hunter TP address | Motor Claims | [NAME] | Change to rules within [NAME] for details that are sent to [NAME] | 2010-01-29 00:00:00 | 2010-02-09 00:00:00 | 11 |  | JOB AREAS | TOTAL NO OF JOBS | SMALL | MEDIUM | LARGE | X LARGE | SUPER
Claims Closing Sections | Motor Claims | [NAME] | Ability to close individual nature lines | 2010-01-27 00:00:00 | 2010-02-22 00:00:00 | 26 |  | MOTOR | 37 | 15 | 8 | 10 | 3 | 1
PRN Billing | Motor Claims | [NAME] | Split of types of payment for MI purposes | 2010-01-15 00:00:00 | 2010-02-25 00:00:00 | 41 |  | HOUSEHOLD | 7 | 2 | 0 | 2 | 2 | 1
Claims Closing Sections-Historic Load | Motor Claims | [NAME] | Section claims closing for historic data | 2010-03-09 00:00:00 | 2010-03-15 00:00:00 | 6 |  | COMMERCIAL | 5 | 2 | 1 | 2 | 0 | 0
[NAME] Bright Idea | Motor Claims | ITP | Change to broker letter | 2010-02-01 00:00:00 | 2010-03-17 00:00:00 | 44 |  | GENERAL | 11 | 5 | 1 | 4 | 1 | 0
[NAME] | Motor Claims | [NAME] | Part of Fraud triggers | 2010-03-15 00:00:00 | 2010-03-25 00:00:00 | 10
REC - Chase TP Direct | Motor Claims | ITP | Change to TP direct letter | 2010-02-10 00:00:00 | 2010-03-31 00:00:00 | 49
Blank Section Status on Claim Enquiry | Motor Claims | [NAME] | Part of closing claim sections | 2010-03-18 00:00:00 | 2010-04-01 00:00:00 | 14
PRN SMS/Email Function | Motor Claims | [NAME] | Ability to send text or email to insured through the  system | 2009-11-30 00:00:00 | 2010-04-07 00:00:00 | 128
Bulk Print & E.mail | Motor Claims | Swordfish | Change in Swordfish to allow bulk sending / printing of documents to save time | 2010-02-09 00:00:00 | 2010-04-11 00:00:00 | 61
Credit Hire To F12 Section closure | Motor Claims | [NAME] | Ability to opt close section from credit hire screen | 2010-04-20 00:00:00 | 2010-04-21 00:00:00 | 1
[NAME] and Pres Letters | Motor Claims | ITP | Letters advising we were moving offices | 2010-04-12 00:00:00 | 2010-04-23 00:00:00 | 11
[NAME] | Motor Claims | [NAME] | New policy set up | 2010-04-13 00:00:00 | 2010-04-27 00:00:00 | 14
[NAME]) | Motor Claims | ITP | Letter advising policyholders of our referral fee | 2010-04-19 00:00:00 | 2010-04-28 00:00:00 | 9
Phase 1 MOJ Portal | Motor Claims | [NAME] | Set up of MOJ for faster PI claims processing | 2010-03-12 00:00:00 | 2010-04-30 00:00:00 | 49
Closed [NAME]/Add Payment to DC & Chq Reversal | Motor Claims | [NAME] | Were not able to decline chq if section closed | 2010-04-27 00:00:00 | 2010-05-05 00:00:00 | 8
Hastings Bike and Car | Motor Claims | [NAME] | New policy set up | 2010-04-22 00:00:00 | 2010-05-07 00:00:00 | 15
Cashiers Cheque Reversal (Closing Claims Sections) | Motor Claims | [NAME] | Also to do with section closed and ability to reverse cheques | 2010-05-06 00:00:00 | 2010-05-07 00:00:00 | 1
Call Assist Admiral [NAME] | Motor Claims | [NAME] | New policy set up | 2010-05-05 00:00:00 | 2010-05-12 00:00:00 | 7
SF Payment Pack Doc | Motor Claims | Swordfish | New document type to easily identify credit hire payment packs and avoid late penalties | 2010-05-12 00:00:00 | 2010-05-12 00:00:00 | 0
Duplicate Payments - PRN | Motor Claims | [NAME] | Stops duplicate payments being entered | 2010-04-27 00:00:00 | 2010-05-12 00:00:00 | 15
[NAME] | Motor Claims | ITP | Post management system changes | 2010-04-06 00:00:00 | 2010-06-24 00:00:00 | 79
Engineer Activity Report - All Lines of Business | Motor Claims | [NAME] | Report to show activities that are not result coded | 2010-06-29 00:00:00 | 2010-07-01 00:00:00 | 2
PRN Search 'ALL' | Motor Claims | [NAME] | Able to search all PRNs rather than specified radius | 2010-07-12 00:00:00 | 2010-07-13 00:00:00 | 1
ITP Para M465 Details Incorrect | Motor Claims | ITP | Correction of paragraph in letter | 2010-07-07 00:00:00 | 2010-07-31 00:00:00 | 24
[NAME] | Motor Claims | [NAME] | Transfer of work to Portsmouth | 2010-06-11 00:00:00 | 2010-07-31 00:00:00 | 50
[NAME] | Motor Claims | [NAME] | Transfer of work to Portsmouth | 2010-06-11 00:00:00 | 2010-07-31 00:00:00 | 50
[NAME] | Motor Claims | [NAME] | Transfer of work to Portsmouth | 2010-06-16 00:00:00 | 2010-07-31 00:00:00 | 45
Drive Assist Enhancements | Motor Claims | [NAME] | To send referrals to [NAME] through [NAME] on intial claim set up | 2010-08-05 00:00:00 | 2010-08-09 00:00:00 | 4
Fleet Support group | Motor Claims | [NAME] | Amendments to existing policy | 2010-07-23 00:00:00 | 2010-08-25 00:00:00 | 33
[NAME] Communication | HH Claims | [NAME] | Cover details were not coming across on data feed | 2010-01-05 00:00:00 | 2010-02-02 00:00:00 | 28
Swordfish HH and Commercial non-motor | HH Claims | Swordfish | Swordfish installed for HH and commercial and awaiting implementation | 2010-02-09 00:00:00 | 2010-04-11 00:00:00 | 61
Saga HH Renewal | HH Claims | [NAME] | Saga data feed for policy renewals | 2010-03-15 00:00:00 | 2010-04-15 00:00:00 | 31
ITP Supplier Instructions | HH Claims | ITP | Option to instruct supplier through Prostar | 2010-01-01 00:00:00 | 2010-04-26 00:00:00 | 115
Lloyds Renewal (Manchester) | HH Claims | [NAME] | Claims check for [NAME] policies for underwriting | 2010-02-24 00:00:00 | 2010-04-28 00:00:00 | 63
PHSS Escape of Water Excess | HH Claims | [NAME] | Increases in HH EOW excesses | 2010-06-09 00:00:00 | 2010-06-15 00:00:00 | 6
HDA Keycare Homeserve | HH Claims | [NAME] | New scheme | 2010-07-01 00:00:00 | 2010-07-02 00:00:00 | 1
Prostar Event Rep error | General | [NAME] | Additions to Prostar event report | 2010-02-03 00:00:00 | 2010-02-03 00:00:00 | 0
[NAME] | General | [NAME] | ITP footer issue resolved | 2010-01-14 00:00:00 | 2010-02-05 00:00:00 | 22
Claim Workload Report | General | [NAME] | Failure of FTP function for claims reporting resulting in failure to transfer reports to required format | 2010-02-04 00:00:00 | 2010-02-23 00:00:00 | 19
CNCD New earning pattern | General | [NAME] | Changes to contingency bordereuax policy | 2010-02-24 00:00:00 | 2010-03-05 00:00:00 | 9
ITP Word Docs to PDF Cronos Font | General | ITP | Font was defaulting to incorrect one in some letters | 2010-03-17 00:00:00 | 2010-04-29 00:00:00 | 43
Reprint of Doc After Batch | General | ITP | Could not previously reprint after batch run of some documents | 2010-04-13 00:00:00 | 2010-05-05 00:00:00 | 22
Duplicate Payments | General | [NAME] | Error message displayed when duplicate payment attempted | 2010-03-15 00:00:00 | 2010-05-12 00:00:00 | 58
[NAME] | General | [NAME] | Making [NAME] password case sensitive for security | 2010-05-27 00:00:00 | 2010-06-02 00:00:00 | 6
Claim Number Per Page | General | ITP | Claim number to appear on all pages of ITP letters and claim forms | 2010-07-20 00:00:00 | 2010-07-21 00:00:00 | 1
Prevent Auto Auth For Reopened Claims | General | [NAME] | Stops payments being raised, auto authd and claim settled without being reviewed to stop fraud | 2010-07-26 00:00:00 | 2010-08-17 00:00:00 | 22
Section Settle/Reopen in [NAME] | General | [NAME] | To stop sections being settled or reopened in enquiry mode | 2010-08-12 00:00:00 | 2010-08-18 00:00:00 | 6
New Risk code for [NAME] | Commercial | [NAME] | Changes to existing scheme | 2010-02-26 00:00:00 | 2010-02-26 00:00:00 | 0
Select and Protect Aggregator Scheme | Commercial | [NAME] | New borderaux | 2010-04-20 00:00:00 | 2010-05-07 00:00:00 | 17
Litigation Code Proff Indem | Commercial | [NAME] | Error where litigation code was not coming through via claims header screen | 2010-05-26 00:00:00 | 2010-06-01 00:00:00 | 6
Professional Indemnity (New Product-Comm) | Commercial | [NAME] | New scheme set up | 2010-05-17 00:00:00 | 2010-06-07 00:00:00 | 21
CZDA Barbon Tens Liab (Property) | Commercial | [NAME] | Changes to existing scheme | 2010-05-24 00:00:00 | 2010-06-22 00:00:00 | 29