ࡱ> fn  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdeghijklmnopqrstuvwxyz{|}~Root Entry F*nfWorkbook(_VBA_PROJECT_CUR"$6n*nMsoDataStore&6nKnBFVCK1EMIIA==26nKnItem 6 Properties)bVBA%Kn'n g2\pFellows, Carl (Admin) Ba=MN]g7ftuvwxy ThisWorkbook=ijJx-8X@"1Arial1ZCalibri1ZCalibri1ZCalibri1ZCalibri1ZArial1ZArial1ZArial1@ ZArial1 ZArial18ZArial1ZArial1ZArial1ZCalibri1 ZArial1 ZArial1 ZArial1ZArial1ZArial1ZArial1ZArial1ZArial1*h6Z Calibri Light1,6ZCalibri16ZCalibri16ZCalibri1ZCalibri1>ZCalibri1ZCalibri16ZCalibri1?ZCalibri14ZCalibri14ZCalibri1 ZCalibri1 ZCalibri1ZCalibri1ZCalibri1 ZCalibri""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- 0.000                                        &  &  &  &  &  &  &  &  &  &  &  &       " ff + ) , * $    P  P       ! `             % a #       @ >   @          *  @  `@ >   h@ >   H   H " "p@ > "P  @ @  "0@ @   @ @   @ @   @ @  "0@ @  "0 "0@ @  "0@ @  "0@ @  "8@ @  "8@ @    ( "  *    (    @ @   @ @   @ @   (@ @  8@ @  8@ @   (@ @  8@ @  p@ @  8@ @  p@ @ 3 0@ @  8@ @   (@ @  x@ @ 8 x@ @ 1 "8@ @  "8@ @  !8@ @  !8@ @  *8@ @  ( "4@ @  "4@ @  "4@ @  "4@ @  )   h@ >  `@ >   @   @   H   x@ @  x@ @  x@ @  x@ @   x@ @  x@ @  x@ @   x@ @   x@ @   x@ @   |@ @     h@ @   h@ @   h@ @   h@ @  !x@ @  !x@ @   h@ @   h@ @  #|@ @  #|@ @   x@ @   x@ @  #|@ @  #|@ @  x@ @  x@ @   h@ @   h@ @     `> (p@ > (P \  H  L )X )X .X .X ! ) ! ! 8@ @  8@ @  8@ @     ) !  X .\ ! ) !    (8@ @   (8@ @   (8@ @   8@ @   8  8@ @   8@ @   8@ @   8@ @  *   X ||}-}8 _-;_-* "}(}e _-;_-* "}(}nP_-;_-* "}(}p_-;_-* "}(}t23_-;_-* "}(}u_-;_-* "}(} _-;_-* "}(}_-;_-* "}(}_-;_-* "}(}_-;_-* "}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}(}_-;_-* "}<} _-;_-* "?_-;_-@_}(}_-;_-* "}(}_-;_-* "}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}<} _-;_-* "?_-;_-@_}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}(} _-;_-* "}-}= _-;_-* "}A}1 _-;_-* "-@_- }A}2 _-;_-* "?-@_- }A}3 _-;_-* "23-@_- }-}4 _-;_-* "}A}0 a_-;_-* "-@_- }A}( _-;_-* "-@_- }A}7 e_-;_-* "-@_- }}5 ??v_-;_-* "̙-@_-    }}; ???_-;_-* "-@_- ??? ??? ??? ???}}) }_-;_-* "-@_-    }A}6 }_-;_-* "-@_- }}* _-;_-* "-@_- ??? ??? ??? ???}-}? _-;_-* "}x}:_-;_-* "-@_??? ??? ???}-}/ _-;_-* "}U}> _-;_-* "-@_ }A}" _-;_-* "-@_}A} _-;_-* "ef-@_}A} _-;_-* "L-@_}A} _-;_-* "23-@_}A}# _-;_-* "-@_}A} _-;_-* "ef-@_}A} _-;_-* "L-@_}A} _-;_-* "23-@_}A}$ _-;_-* "-@_}A} _-;_-* "ef-@_}A} _-;_-* "L-@_}A} _-;_-* "23-@_}A}% _-;_-* "-@_}A} _-;_-* "ef-@_}A} _-;_-* "L-@_}A} _-;_-* "23-@_}A}& _-;_-* "-@_}A} _-;_-* "ef-@_}A} _-;_-* "L-@_}A}  _-;_-* "23-@_}A}' _-;_-* " -@_}A} _-;_-* "ef -@_}A} _-;_-* "L -@_}A}! _-;_-* "23 -@_                                                           20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L˭ % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  L % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23 % 60% - Accent3M( 60% - Accent3 23 % 60% - Accent4M, 60% - Accent4 23f % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23Ў % "Accent1AAccent1 [ % #Accent2A!Accent2 }1 % $Accent3A%Accent3  % %Accent4A)Accent4  % &Accent5A-Accent5 Dr % 'Accent6A1Accent6  pG %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 DTj%[2 Heading 2G Heading 2 DTj%?3 Heading 3G Heading 3 DTj%234 Heading 49 Heading 4 DTj% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%"Normal 8Normal 27Normal 2 %9 Normal 2 2 :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title DTj% >TotalMTotal %[[? Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight168$i3ffff̙̙3f3fff3ff³p3f.333\` ۯCoverYPurpose of spreadsheetVersion ControlhSummary - Fire_E,GAnnGenHiddenLists*h Factor Listlx-Series Number x-216 x-217 x-218 r7x-219 cjx-220 x-221, J  ( BaseTablesList;# DATE_MODIFIED:)FACTOR_LIST_AGE_DEF:(FACTOR_LIST_CLIENT:2FACTOR_LIST_DATE_IMPLEMENTED: -FACTOR_LIST_DATE_ISSUED: -FACTOR_LIST_DESCRIPTION:/FACTOR_LIST_FACTOR_STATUS: -FACTOR_LIST_FACTOR_TYPE:(FACTOR_LIST_GENDER:. FACTOR_LIST_HEADINGS;+FACTOR_LIST_REFERENCE:4FACTOR_LIST_REFERENCE_GUIDANCE: )FACTOR_LIST_RELATED: )FACTOR_LIST_SECTION:0FACTOR_LIST_SECTION_NUMBER:/FACTOR_LIST_SERIES_NUMBER:(FACTOR_LIST_SOURCE:*FACTOR_LIST_TABLE_ID:+FACTOR_LIST_TIMESTAMP:)FACTOR_LIST_USER_ID:* ImprovementsList;#  ; <  <  <  <  ;.   ; .   ; . # TABLE_AGE_DEF: #  TABLE_AGE_DEF: #  TABLE_AGE_DEF: #  TABLE_AGE_DEF: #  TABLE_AGE_DEF: #  TABLE_AGE_DEF: # TABLE_AGE_DEF: %TABLE_AGE_DEF_1: % TABLE_AGE_DEF_1: % TABLE_AGE_DEF_1: % TABLE_AGE_DEF_1: % TABLE_AGE_DEF_1: % TABLE_AGE_DEF_1:  TABLE_AREA<  TABLE_AREA<$ TABLE_AREA;$ TABLE_AREA;$ TABLE_AREA;?$ TABLE_AREA; ?$ TABLE_AREA; ?" TABLE_AREA_1<?"  TABLE_AREA_1<?"  TABLE_AREA_1<?"  TABLE_AREA_1<?& TABLE_AREA_1;B& TABLE_AREA_1; B" TABLE_CLIENT:"  TABLE_CLIENT:"  TABLE_CLIENT:"  TABLE_CLIENT:"  TABLE_CLIENT:"  TABLE_CLIENT: " TABLE_CLIENT: $TABLE_CLIENT_1:$ TABLE_CLIENT_1:$ TABLE_CLIENT_1:$ TABLE_CLIENT_1:$ TABLE_CLIENT_1:$ TABLE_CLIENT_1: ,TABLE_DATE_IMPLEMENTED:, TABLE_DATE_IMPLEMENTED:, TABLE_DATE_IMPLEMENTED:, TABLE_DATE_IMPLEMENTED:, TABLE_DATE_IMPLEMENTED:, TABLE_DATE_IMPLEMENTED: ,TABLE_DATE_IMPLEMENTED: .TABLE_DATE_IMPLEMENTED_1:. TABLE_DATE_IMPLEMENTED_1:. TABLE_DATE_IMPLEMENTED_1:. TABLE_DATE_IMPLEMENTED_1:. TABLE_DATE_IMPLEMENTED_1:. TABLE_DATE_IMPLEMENTED_1: 'TABLE_DATE_ISSUED:' TABLE_DATE_ISSUED:' TABLE_DATE_ISSUED:' TABLE_DATE_ISSUED:' TABLE_DATE_ISSUED:' TABLE_DATE_ISSUED: 'TABLE_DATE_ISSUED: )TABLE_DATE_ISSUED_1:) TABLE_DATE_ISSUED_1:) TABLE_DATE_ISSUED_1:) TABLE_DATE_ISSUED_1:) TABLE_DATE_ISSUED_1:) TABLE_DATE_ISSUED_1: 'TABLE_DESCRIPTION: ' TABLE_DESCRIPTION: ' TABLE_DESCRIPTION: ' TABLE_DESCRIPTION: ' TABLE_DESCRIPTION: ' TABLE_DESCRIPTION: 'TABLE_DESCRIPTION: )TABLE_DESCRIPTION_1: ) TABLE_DESCRIPTION_1: ) TABLE_DESCRIPTION_1: ) TABLE_DESCRIPTION_1: ) TABLE_DESCRIPTION_1: ) TABLE_DESCRIPTION_1: )TABLE_FACTOR_STATUS:) TABLE_FACTOR_STATUS:) TABLE_FACTOR_STATUS:) TABLE_FACTOR_STATUS:) TABLE_FACTOR_STATUS:) TABLE_FACTOR_STATUS: )TABLE_FACTOR_STATUS: +TABLE_FACTOR_STATUS_1:+ TABLE_FACTOR_STATUS_1:+ TABLE_FACTOR_STATUS_1:+ TABLE_FACTOR_STATUS_1:+ TABLE_FACTOR_STATUS_1:+ TABLE_FACTOR_STATUS_1: 'TABLE_FACTOR_TYPE:' TABLE_FACTOR_TYPE:' TABLE_FACTOR_TYPE:' TABLE_FACTOR_TYPE:' TABLE_FACTOR_TYPE:' TABLE_FACTOR_TYPE: 'TABLE_FACTOR_TYPE: )TABLE_FACTOR_TYPE_1:) TABLE_FACTOR_TYPE_1:) TABLE_FACTOR_TYPE_1:) TABLE_FACTOR_TYPE_1:) TABLE_FACTOR_TYPE_1:) TABLE_FACTOR_TYPE_1: " TABLE_GENDER: "  TABLE_GENDER: "  TABLE_GENDER: "  TABLE_GENDER: "  TABLE_GENDER: "  TABLE_GENDER: " TABLE_GENDER: $TABLE_GENDER_1: $ TABLE_GENDER_1: $ TABLE_GENDER_1: $ TABLE_GENDER_1: $ TABLE_GENDER_1: $ TABLE_GENDER_1: $ TABLE_INFO;$ TABLE_INFO;$ TABLE_INFO;$ TABLE_INFO;$ TABLE_INFO;$ TABLE_INFO; $ TABLE_INFO; & TABLE_INFO_1;& TABLE_INFO_1;& TABLE_INFO_1;& TABLE_INFO_1;& TABLE_INFO_1;& TABLE_INFO_1; %TABLE_REFERENCE:% TABLE_REFERENCE:% TABLE_REFERENCE:% TABLE_REFERENCE:% TABLE_REFERENCE:% TABLE_REFERENCE: %TABLE_REFERENCE: 'TABLE_REFERENCE_1:' TABLE_REFERENCE_1:' TABLE_REFERENCE_1:' TABLE_REFERENCE_1:' TABLE_REFERENCE_1:' TABLE_REFERENCE_1: .TABLE_REFERENCE_GUIDANCE:. TABLE_REFERENCE_GUIDANCE:. TABLE_REFERENCE_GUIDANCE:. TABLE_REFERENCE_GUIDANCE:. TABLE_REFERENCE_GUIDANCE:. TABLE_REFERENCE_GUIDANCE: .TABLE_REFERENCE_GUIDANCE: 0TABLE_REFERENCE_GUIDANCE_1:0 TABLE_REFERENCE_GUIDANCE_1:0 TABLE_REFERENCE_GUIDANCE_1:0 TABLE_REFERENCE_GUIDANCE_1:0 TABLE_REFERENCE_GUIDANCE_1:0 TABLE_REFERENCE_GUIDANCE_1: # TABLE_RELATED:#  TABLE_RELATED:#  TABLE_RELATED:#  TABLE_RELATED:#  TABLE_RELATED:#  TABLE_RELATED: # TABLE_RELATED: %TABLE_RELATED_1:% TABLE_RELATED_1:% TABLE_RELATED_1:% TABLE_RELATED_1:% TABLE_RELATED_1:% TABLE_RELATED_1: # TABLE_SECTION:#  TABLE_SECTION:#  TABLE_SECTION:#  TABLE_SECTION:#  TABLE_SECTION:#  TABLE_SECTION: # TABLE_SECTION: %TABLE_SECTION_1:% TABLE_SECTION_1:% TABLE_SECTION_1:% TABLE_SECTION_1:% TABLE_SECTION_1:% TABLE_SECTION_1: *TABLE_SECTION_NUMBER: * TABLE_SECTION_NUMBER: * TABLE_SECTION_NUMBER: * TABLE_SECTION_NUMBER: * TABLE_SECTION_NUMBER: * TABLE_SECTION_NUMBER: *TABLE_SECTION_NUMBER: ,TABLE_SECTION_NUMBER_1: , TABLE_SECTION_NUMBER_1: , TABLE_SECTION_NUMBER_1: , TABLE_SECTION_NUMBER_1: , TABLE_SECTION_NUMBER_1: , TABLE_SECTION_NUMBER_1: )TABLE_SERIES_NUMBER: ) TABLE_SERIES_NUMBER: ) TABLE_SERIES_NUMBER: ) TABLE_SERIES_NUMBER: ) TABLE_SERIES_NUMBER: ) TABLE_SERIES_NUMBER: )TABLE_SERIES_NUMBER: +TABLE_SERIES_NUMBER_1: + TABLE_SERIES_NUMBER_1: + TABLE_SERIES_NUMBER_1: + TABLE_SERIES_NUMBER_1: + TABLE_SERIES_NUMBER_1: + TABLE_SERIES_NUMBER_1: title: 8 JVersion ControlSheet Description SpecificationGovernment Actuary's DepartmentCover100 Series - Club Transfer200 Series - Non Club Transfers'300 Series - Pension Sharing on divorce500 Series - Commutation600 Series - Scheme PaysSummary of Factors x-x=0x=1"800 Series - Other Scheme SpecificClient Factor Type Series NumberDate Factors Issued to Client#Date Factors Implemented (if known)%400 Series - Early or Late Retirement<700 Series - Additional Benefits or Additional ContributionsGender Data Item Factor ListFactor Table InformationVersion Control fThis sheet sets out the purpose of the spreadsheet and includes caveats on the use of the spreadsheet.This sheet is used to show which factor tables have been updated since the last issued version of the consolidated factor spreadsheet.fThis sheet lists the full suite of factors that are in force together with the following information: pThis sheet summaries the full suite of factors that are in force and the date when the factors were implemented.x-101 and onwardsx-201 and onwardsx-301 and onwardsx-401 and onwardsx-501 and onwardsx-601 and onwardsx-701 and onwardsx-801 and onwardsPurpose of SpreadsheetVersion controlWVersion control on this sheet commences with the 2017/18 factor review (version 2018-1))Provides the following new factor tables:'Provides the following revised factors:Factors still to follow:Methodology changes:Purpose of spreadsheetx=2Fire_ESectionSection Number (x)'Table Reference (Section-Series Number)Section NumberTable ReferenceTable Reference in GuidancekRelated Factor Table Reference (where the factor uses the same table as another factor in this spreadsheet)!Enter the client name eg NHSPS_EW$Enter the section name eg NHSPS 2015TEnter a description of the factor (eg use description from factor table in guidance)"Enter either "unisex" or "m and f"Enter section number (this relates to the number used to identify the scheme section - see top of summary tab for section number)~Enter series number (this reflects the number in the relevant series eg if it s the first ER/LR factor then it would be "401")Enter table number (this is the section number plus the series number so we can identify the section and factor type eg if the section number for NHSPS 2015 was 0 and the factor was the first in the ER/LR factor series then this would be "0-401" entered here.1Enter the table reference from the guidance notesIf the factor table on this sheet is the same as another factor in the spreadsheet. Then enter that table reference here eg 0-.201. If this factor table is unique then put "n/a".3Enter the date the factors are issued to the client+Enter the date the factors are implemented aCopy the relevant factor table and foot notes here. Unisex or male factor table in this grey box.Enter the factor type (which should be consistent with the series header types found on the summary sheet (eg early or late retirement)4see sheet "x-Series Number" for description of entryTable IDSourceUserID Time StampDO NOT REMOVE WORKSHEETBaseTablesListImprovementsListPCFA00PCMA00PFA80PFA92 PFA92 - 08PFA92-10PMA80PMA92 PMA92 - 08PMA92-10PNFA00 PNFA00-06 PNFA00-08 PNFA00-10PNMA00 PNMA00-06 PNMA00-08 PNMA00-10S1DFAS1DFA-06S1DFA-08S1DFA-10S1DFA-12S1DFA-14S1DFA-16S1DFA-L S1DFA-L-06 S1DFA-L-08 S1DFA-L-10 S1DFA-L-12S1IFAS1IFA-06S1IFA-08S1IFA-10S1IFA-12S1IFA-14S1IFA-16 S1IFA-STSS-16 S1IFA-TPS-16S1IMAS1IMA-06S1IMA-08S1IMA-10S1IMA-12S1IMA-14S1IMA-16 S1IMA-STSS-16 S1IMA-TPS-16S1NFAS1NFA-06S1NFA-08S1NFA-10S1NFA-12S1NFA-14S1NFA-16S1NFA-L S1NFA-L-06 S1NFA-L-08 S1NFA-L-10 S1NFA-L-12 S1NFA-L-14 S1NFA-L-16 S1NFA-L-STSSS1NFA-L-STSS-06S1NFA-L-STSS-08S1NFA-L-STSS-10S1NFA-L-STSS-12S1NFA-L-STSS-14S1NFA-L-STSS-16 S1NFA-L-TPSS1NFA-L-TPS-06S1NFA-L-TPS-08S1NFA-L-TPS-10S1NFA-L-TPS-12S1NFA-L-TPS-14S1NFA-L-TPS-16S1NMAS1NMA-06S1NMA-08S1NMA-10S1NMA-12S1NMA-14S1NMA-16S1NMA-L S1NMA-L-06 S1NMA-L-08 S1NMA-L-10 S1NMA-L-12 S1NMA-L-14 S1NMA-L-16S1PFAS1PFA-06S1PFA-08S1PFA-10S1PFA-12S1PFA-14S1PFA-16S1PMAS1PMA-06S1PMA-08S1PMA-10S1PMA-12S1PMA-14S1PMA-16S2DFAS2DFA-12S2DFA-14S2DFA-16S2DFLS2DFL-12S2DFL-16S2IFAS2IFA-12S2IFA-14S2IFA-16S2IMAS2IMA-12S2IMA-14S2IMA-16S2NFAS2NFA-12S2NFA-14S2NFA-16 S2NFA-CMIS2NMA S2NMA_L-16 S2NMA-12 S2NMA-14S2NMA-16 S2NMA-CMIS2PFAS2PFA-12S2PFA-14S2PFA-16S2PFLS2PFL-12S2PFL-16S2PMAS2PMA-12S2PMA-14S2PMA-16S2PMLS2PML-12S2PML-16 SMPI-2018UKFUKF2004UKF2006UKF2008UKF2010UKF2012UKMUKM2004UKM2006UKM2008UKM2010UKM2012CMI2016F-07-1pt5CMI2016M-07-1pt5 Long Cohort Medium CohortPFA80impPMA80imp Short Cohort SMPI-2018imp UKF2004imp UKF2006impUKF2006imp_HLEUKF2006imp_LLE UKF2008imp UKF2010imp UKF2012imp UKF2014imp UKf2016HLEimp UKF2016imp UKf2016LLEimp UKM2004imp UKM2006impUKM2006imp_HLEUKM2006imp_LLE UKM2008imp UKM2010imp UKM2012imp UKM2014imp UKm2016HLEimp UKM2016imp UKm2016LLEimpNone Factor Status;Enter whether table is inforce, withdrawn, refer to gad etcFactor Age/Period DefinitionEnter in age definitionDate modified:The 100 series factors contain the club transfer factors. Each different type of club transfer factor is set out on a separate sheet starting with sheet x-101, where x relates to the scheme section (if applicable).The 200 series factors contain the non club transfer factors. Each different type of non club transfer factor is set out on a separate sheet starting with sheet x-201, where x relates to the scheme section (if applicable).The 300 series factors contain the pension sharing on divorce factors. Each different type of pension sharing on divorce factor is set out on a separate sheet starting with sheet x-301, where x relates to the scheme section (if applicable).The 400 series factors contain the early of late retirement factors. Each different type of early or late retirement factor is set out on a separate sheet starting with sheet x-401, where x relates to the scheme section (if applicable).The 500 series factors contain the commutation factors. Each different type of commutation factor is set out on a separate sheet starting with sheet x-501, where x relates to the scheme section (if applicable).The 600 series factors contain the scheme pays factors. Each different type of scheme pays factor is set out on a separate sheet starting with sheet x-601, where x relates to the scheme section (if applicable).The 700 series factors contain the additional benefit or additional contribution factors. Each different type of additional benefit or additional contribution factor is set out on a separate sheet starting with sheet x-701, where x relates to the scheme section (if applicable).The 800 series factors contain the other scheme specific factors. Each different type of other scheme specific factor is set out on a separate sheet starting with sheet x-801, where x relates to the scheme section (if applicable).Summary - Fire_ETV In (non-club)7Statutory CETV incoming transfer service credit factorsMale"Age last birthday at relevant dateTable C1AgeFemaleTable C2IStatutory CETV incoming transfer service credit factors - Special membersTable C3Table C42Factors for non-club transfers - in based on NPA60 Table NM60 Table NF60wL:\Factors\2017\FIRE\Client output\Tranche 2_2.4%\FIRE_E_CETV bespoke outputs - A + B - C T0.03 - Tranche 2 - 2.4%.xlsmThannimaGross pension of 1 pa$Surviving Partner's Penions of 1 pa$Adjustment for GMP of 1 pa - Pre 88<2 %Adjustment for GMP of 1 pa - Post 88All other seriesGNone - tables should be used with existing guidance notes as referencedRelated Factor GuidanceIssued x-220, x-221x-216, x-217, x-218, x-219Version 2018 - 1 (January 2019)Fire_WYThis spreadsheet contains updated factors for the Firefighters' Pension Schemes in Wales.This spreadsheet is provided by GAD at the request of the ʶ Government. Its purpose is to set out in one place for convenience the actuarial factors provided by GAD to the ʶfrom time to time in respect of Firefighters' Pension Schemes (Wales) and related schemes, and the dates on which these factors have been sent to the client. It should not be used or relied on for any other purpose and GAD has no liability for any act or omission taken on the basis of this spreadsheet. In particular, it does not constitute an instruction or manual for plan administration purposes, and it does not cover the implementation or backdating of factors other than to specify the factor implementation date (if provided by the ʶ Government). GAD has no liability for any changes made to this spreadsheet whilst being used by the ʶor any other third party. This spreadsheet should not be made available online without the express permission of GAD. This spreadsheet is password protected. hThis sheet is intended to assist ʶin understanding which factors have changed and when. The Firefighters Pension Scheme 2015 (Wales) Actuarial Factors for Individual Cash Equivalent Transfers from 1 April 2015 Dated 27 March 2015Fire_W - TVIN factorsSConfirms that the following factor table is no longer required by ʶ Government:#New Firefighters Pension Scheme (2006) New Firefighters Pension Sheme (Northern Ireland) 2007 Firefighters Pension Scheme (Scotland) 2007 Firefighters Pension Scheme (Wales) 2007 Factors and Example Calculations for Service Credits for non-Club Incoming Transfers Dated 12 December 2012x-220 FIRE_E_x-220x-221 FIRE_E_x-221x-216 FIRE_E_x-216x-217 FIRE_E_x-217x-218 FIRE_E_x-218x-219 FIRE_E_x-219?Purpose of the ʶConsolidated Factor SpreadsheetCDiscontinued - factors will now be produced on a case-by-case basis}Discontinued - factors will now be produced on a case-by-case basis. Please contact ʶif a factor is required.Rv )wwYx6zLh{|'}i b уU ! { τS,lC@D)Z3S1MxjYec7Jx p ccG PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V{+#x$~:\x(q]`^hG8|PNG0%616aI\&8A'7JT+FĮޘL;C]:Q# klX(,|8Lj\gNpZnIEQV뫿.3UԜ0|+^Wr F#XiEwa5P[V^_+PD+P7WW_KW7 RmK~,WC&YM+ !.9ńb[EK@ AÄ8dBP8 *~ STDFLƐQBf~ ^] ŏ_}s0CT7|׳^=ʎ:>/@X* /~/X!0w`m* &s|0Dİ@!^_ ju;  xu~: <`vXb 59<'O:BǶg2A&E@ScƖ%Ĉ%p5$CrhhD ڈèm]|l"@B~ƫh.Pds9DDh#9X$#2=Ŕ91fs#jIbO]D&2s1#(Q4a$uGJ97ykF۠:U_%W13wʀjLi_u]i] Z{kR .713 ~o巯+ [t֭P: ڽshO> J;؊GY_ i0  D3]d3Sx:8}b-i*xiCZ}WliyI@ھ m2DBAR4 ¢iaѐ`Ɂ]W=0#xBeT/63-FfbYL7%׭˓KK6HhfPQ=hꔣnRjГPAih⢹um4vNZnCɌЬNF3.NH$ e%\tӀ+I "'%Q˕@c![Βkk fdGBO6"#^§ZaU_,-='!'_/ @4co4s![ZcdWj(Gtb•tU*[3T IA5i5R[F2rhz*kU̘aby&Z4MtKnsukK@Y9Fm5AM2ޔa٨; @ABw Sheet1b(b( ggD g2   dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3cU   ; ;   @  @ @ v@ @ @ @ CCCCCCCCCCCC uD _C> Enter workbook title here *#Enter workbook title in Cover sheet #BFire_W - TVIN factorsDDDDDDDDDDD E(EEEEEEEEEEE .c!filename$B}C:\Users\fulkerl\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\1N801RT8\[WG - 2019 - W-FRSC(2019) 03 - Fire Wales TVins - January 2019 alias.xlsm]Purpose of spreadsheetc GGG G fHHHHHHHHHHHU 5 c..0$0$$$$  >@   Sheet2b(b(PggD g2   dMbP?_*+%&ffffff?'ffffff?(?)?M \\GAD-PRINT.DOMAIN.GAD\GAD-MFD' dXXdPcKV@4 ****4 **** EE0010000L -L - 2 dd@ ? ?XX0J,X< Off0000Arial?  A A A A""""""""""""""""dPcKPV0dPcK'VdPcK NVDConfidential 1dPcKV3 7 dPcKdVdPcKcV<z" dXX333333?333333?&<3cU} B} I} >   ; ;           @ CCCCCCCCCCCC uD _C> Enter workbook title here *#Enter workbook title in Cover sheet #BFire_W - TVIN factorsDDDDDDDDDDD EEEEEEEEEEEE .c!filename$B}C:\Users\fulkerl\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\1N801RT8\[WG - 2019 - W-FRSC(2019) 03 - Fire Wales TVins - January 2019 alias.xlsm]Version Controlc GGG @)@ ^6^ ^*^ @2 @e A+ d   A, d 0 A9 d 1 A-d , A.d - AG8.<@"..&&&&& 8 rl\>@%%% Sheet3b(b(3ggD g2 , 7$,c5=+F  dMbP?_*+%Y &L&Z&F [&A]&LPage &P of &N&R&T &D&ffffff?'ffffff?(?)?M\\10.13.56.16\P-CP2-0-E-H08-D d 4-oA4#<<DPCAwww.;http://;file://;mailto:;https://;ftp://d 4 C:\Users\fulkerl\AppData\Local\Temp\6\Low\UniPrint\UPDLGSTTN.TMPN.TMP0" -333333?333333?&<3cU} mO} O} >} O} mO   ; ;            LPPKPPPKKuN _C> Enter workbook title here *#Enter workbook title in Cover sheet #BFire_W - TVIN factorsQQJQQQJJ M QQJQQQJJ.F!filename$B}C:\Users\fulkerl\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\1N801RT8\[WG - 2019 - W-FRSC(2019) 03 - Fire Wales TVins - January 2019 alias.xlsm]Summary - Fire_E v v v0 x1 YRw|@wX@z @[ZTSSS y XUWWW \ ~ X@Y@ U||| \ ~ XY@ U||| \ ~ XY@ U||| \ ~ XZ@ U||| \ ~ X@Z@U||| \ ~ XZ@U||| \ ~ XZ@U||| \ ~ X[@U||| \ ~ X@[@U||| \ ~ X[@U||| \ ~ X[@U||| \ ~ X\@U||| \ ~ X@\@U||| \ ~ X\@U||| \ ~ X\@U||| \ ~ X]@U||| \ ~ X@]@U||| \ ~ X]@U||| \ ~ X]@U||| \ ~ X^@U||| \ ~ X@^@H}}}g \ ~ X^@U|||@D((*8"....................0 !"#$%&'()*+,-./0123456789:;<=>? \ ~ X^@ U||| !\ ~ !X_@!U||| "\ ~ "X@_@"U|||f#]ZT~~~H $y$XU||| %\ ~ %X i@%U||| &\ ~ &X@i@&U||| '\ ~ 'X`i@'U||| (\ ~ (Xi@(U||| )\ ~ )Xi@)U||| *\ ~ *Xi@*U||| +\ ~ +Xi@+U||| ,\ ~ ,Xj@,U||| -\ ~ -X j@-U||| .\ ~ .X@j@.U||| /\ ~ /X`j@/U||| 0\ ~ 0Xj@0U||| 1\ ~ 1Xj@1U||| 2\ ~ 2Xj@2U||| 3\ ~ 3Xj@3U||| 4\ ~ 4Xk@4U||| 5\ ~ 5X k@5U||| 6\ ~ 6X@k@6U||| 7\ ~ 7X`k@7U||| 8\ ~ 8Xk@8U||| 9\ ~ 9Xk@9U||| :\ ~ :Xk@:U||| ;\ ~ ;Xk@;U||| <\ ~ <Xl@<U||| =\ ~ =X l@=V>]ZT~~~ ?y?XU|||Dl..0".........................@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @\ ~ @Xr@@U||| A\ ~ AXr@AU||| B\ ~ BXr@BU||| C\ ~ CXs@CU||| D\ ~ DXs@DU||| E\ ~ EX s@EU||| F\ ~ FX0s@FU||| G\ ~ GX@s@GU||| H\ ~ HXPs@HU||| I\ ~ IX`s@IU||| J\ ~ JXps@JU||| K\ ~ KXs@KU||| L\ ~ LXs@LU||| M\ ~ MXs@MU||| N\ ~ NXs@NU||| O\ ~ OXs@OU||| P\ ~ PXs@PU||| Q\ ~ QXs@QU||| R\ ~ RXs@RU||| S\ ~ SXt@SU||| T\ ~ TXt@TU||| U\ ~ UX t@UU||| V\ ~ VX0t@VU||| W\ ~ WX@t@WU||| X\ ~ XXPt@XVY]ZT~~~ ZyZXU||| [\ ~ [Xy@[U||| \\ ~ \X y@\U||| ]\ ~ ]X0y@]U||| ^\ ~ ^X@y@^U||| _\ ~ _XPy@_U|||Dl........................."....`abcdefghijklmnopqrstuvwxyz{|}~ `\ ~ `X`y@`U||| a\ ~ aXpy@aU||| b\ ~ bXy@bU||| c\ ~ cXy@cU||| d\ ~ dXy@dU||| e\ ~ eXy@eU||| f\ ~ fXy@fU||| g\ ~ gXy@gU||| h\ ~ hXy@hU||| i\ ~ iXy@iU||| j\ ~ jXz@jU||| k\ ~ kXz@kU||| l\ ~ lX z@lU||| m\ ~ mX0z@mU||| n\ ~ nX@z@nU||| o\ ~ oXPz@oU||| p\ ~ pX`z@pU||| q\ ~ qXpz@qU||| r\ ~ rXz@rU||| s\ ~ sXz@sVt]ZT~~~ uy uXU||| v\ ~ vXP@vU||| w\ ~ wX`@wU||| x\ ~ xXp@xU||| y\ ~ yX@yU||| z\ ~ zX@zU||| {\ ~ {X@{U||| |\ ~ |X@|U||| }\ ~ }X@}U||| ~\ ~ ~X@~U||| \ ~ X@U|||Dl...................."......... \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X @U||| \ ~ X(@U||| \ ~ X0@U||| \ ~ X8@U||| \ ~ X@@U||| \ ~ XH@U||| \ ~ XP@U||| \ ~ XX@U||| \ ~ X`@U||| \ ~ Xh@V]ZT~~~ y XU||| \ ~ XȂ@U||| \ ~ XЂ@U||| \ ~ X؂@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X @U||| \ ~ X(@U||| \ ~ X0@U||| \ ~ X8@U|||Dl...............".............. \ ~ X@@U||| \ ~ XH@U||| \ ~ XP@U||| \ ~ XX@U||| \ ~ X`@U||| \ ~ Xh@U||| \ ~ Xp@U||| \ ~ Xx@U||| \ ~ X@U||| \ ~ X@V]ZT~~~ yXU||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X @U||| \ ~ X(@U||| \ ~ X0@U||| \ ~ X8@U||| \ ~ X@@U||| \ ~ XH@U||| \ ~ XP@U||| \ ~ XX@U||| \ ~ X`@U||| \ ~ Xh@U||| \ ~ Xp@U||| \ ~ Xx@U||| \ ~ X@U|||Dl.........."................... \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U|||]ZT~~~ yXU||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X @U||| \ ~ X(@U||| \ ~ X0@U||| \ ~ X8@U||| \ ~ X@@U||| \ ~ XH@U||| \ ~ XP@U||| \ ~ XX@U||| \ ~ X`@U||| \ ~ Xh@U||| \ ~ Xp@U||| \ ~ Xx@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ X@U||| \ ~ Xȉ@VDl....."........................  ~>@d   Sheet5b(b(1ggD g2 $HO"UYh^bxg  dMbP?_*+% &L&Z&F [&A]&LPage &P of &N&R&T &D&ffffff?'ffffff?(?)?MAdobe PDFS 4dA4PRIV ''''0P4(FFSMTJ0EBDAStandard" d333333?333333?&<3cU      K L M N  O  P  Q  R  S Q T  U U V  W  X  Y  Z  [  \  ]  ^  _  `  a  b  c  d  e  f  g  h  i  j BX !"#$%&'()*+,-./0123456789:;<=>? k  !l ! "m " #n #  $o %p &q 'r (s )t *u +v ,w -x .y /z 0{ 1| 2} 3~ 4 5 6 7 8 9 : ; < = > ?Dxl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _D@l`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ D@l                                D@l>@ Sheet27ggD g2 |WZ"zB b*J'j/27>FNRV^ek  dMbP?_*+% &L&Z&F [&A]&LPage &P of &N&R&T &D&ffffff?'ffffff?(?)?M GAD-MFD on GAD-PRINT.DOMAIN.GA' ddPcKV@4 ****4 **** EE0010000L -L - 2 dd@ ? ?X0J,X< Off0000Arial?  A A A A""""""""""""""""dPcKPV0dPcK'VdPcK NVDConfidential 1dPcKV3 7 dPcKdVdPcKcV<z" d333333?333333?&<3cU} }  } } m=} m}  _} m} I } m} m} m0_} I } } $ } }  } m& * * * * W;;_       L KKKKKKKKKK uN _C> Enter workbook title here *#Enter workbook title in Cover sheet #BFire_W - TVIN factors JJJJJJJJJJJ  M JJJJJJJJJJJ .F!filename$B}C:\Users\fulkerl\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\1N801RT8\[WG - 2019 - W-FRSC(2019) 03 - Fire Wales TVins - January 2019 alias.xlsm]Factor List { {2 I I I I  I3 I I4  I7  I.  I  I  I  {G {H {I {J F F F F F F F F F  F  F  F  F  F 3~ \@    ?k@ ?    :  H  @ & '4@ 3~ \@     ? k@ A  : H B & ' 4@ 3~ \@      ?@k@ C ! : H D & ' 4@ 3~ \@      ?`k@ E " : H F & ' 4@ 3~ |@  #   k@ ; $ 7~ <@ / < & ' 4@ 3~ |@  #   k@ = % 7~ <@ / > & ' 4@`bOOObOOOOb `bOOObOOOOb `bOOObOOOOb `bOOObOOOOb `bOOObOOOOb `bOOObOOOOb $ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOODl<< ((((((((((( !"#$%&'()*+,-./0123456789:;<=>?$ ObOOObOOOObOOOO$!ObOOObOOOObOOOO$"ObOOObOOOObOOOO$#ObOOObOOOObOOOO$$ObOOObOOOObOOOO$%ObOOObOOOObOOOO$&ObOOObOOOObOOOO$'ObOOObOOOObOOOO$(ObOOObOOOObOOOO$)ObOOObOOOObOOOO$*ObOOObOOOObOOOO$+ObOOObOOOObOOOO$,ObOOObOOOObOOOO$-ObOOObOOOObOOOO$.ObOOObOOOObOOOO$/ObOOObOOOObOOOO$0ObOOObOOOObOOOO$1ObOOObOOOObOOOO$2ObOOObOOOObOOOO$3ObOOObOOOObOOOO$4ObOOObOOOObOOOO$5ObOOObOOOObOOOO$6ObOOObOOOObOOOO$7ObOOObOOOObOOOO$8ObOOObOOOObOOOO$9ObOOObOOOObOOOO$:ObOOObOOOObOOOO$;ObOOObOOOObOOOO$<ObOOObOOOObOOOO$=ObOOObOOOObOOOO$>ObOOObOOOObOOOO$?ObOOObOOOObOOOODl(((((((((((((((((((((((((((((((@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_$@ObOOObOOOObOOOO$AObOOObOOOObOOOO$BObOOObOOOObOOOO$CObOOObOOOObOOOO$DObOOObOOOObOOOO$EObOOObOOOObOOOO$FObOOObOOOObOOOO$GObOOObOOOObOOOO$HObOOObOOOObOOOO$IObOOObOOOObOOOO$JObOOObOOOObOOOO$KObOOObOOOObOOOO$LObOOObOOOObOOOO$MObOOObOOOObOOOO$NObOOObOOOObOOOO$OObOOObOOOObOOOO$PObOOObOOOObOOOO$QObOOObOOOObOOOO$RObOOObOOOObOOOO$SObOOObOOOObOOOO$TObOOObOOOObOOOO$UObOOObOOOObOOOO$VObOOObOOOObOOOO$WObOOObOOOObOOOO$XObOOObOOOObOOOO$YObOOObOOOObOOOO$ZObOOObOOOObOOOO$[ObOOObOOOObOOOO$\ObOOObOOOObOOOO$]ObOOObOOOObOOOO$^ObOOObOOOObOOOO$_ObOOObOOOObOOOODl(((((((((((((((((((((((((((((((`abcdefghijklmnopqrstuvwxyz{|}~$`ObOOObOOOObOOOO$aObOOObOOOObOOOO$bObOOObOOOObOOOO$cObOOObOOOObOOOO$dObOOObOOOObOOOO$eObOOObOOOObOOOO$fObOOObOOOObOOOO$gObOOObOOOObOOOO$hObOOObOOOObOOOO$iObOOObOOOObOOOO$jObOOObOOOObOOOO$kObOOObOOOObOOOO$lObOOObOOOObOOOO$mObOOObOOOObOOOO$nObOOObOOOObOOOO$oObOOObOOOObOOOO$pObOOObOOOObOOOO$qObOOObOOOObOOOO$rObOOObOOOObOOOO$sObOOObOOOObOOOO$tObOOObOOOObOOOO$uObOOObOOOObOOOO$vObOOObOOOObOOOO$wObOOObOOOObOOOO$xObOOObOOOObOOOO$yObOOObOOOObOOOO$zObOOObOOOObOOOO${ObOOObOOOObOOOO$|ObOOObOOOObOOOO$}ObOOObOOOObOOOO$~ObOOObOOOObOOOO$ObOOObOOOObOOOODl((((((((((((((((((((((((((((((($ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmopqrstuvwxyz{|}~ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOODl((((((((((((((((((((((((((((((($ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOODl((((((((((((((((((((((((((((((($ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOODl((((((((((((((((((((((((((((((($ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOODl(((((((((((((((((((((((((((((((     $ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ ObOOObOOOObOOOO$ ObOOObOOOObOOOO$ ObOOObOOOObOOOO$ ObOOObOOOObOOOO$ ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOODl((((((((((((((((((((((((((((((( !"#$%&'()*+,-./0123456789:;<=>?$ ObOOObOOOObOOOO$!ObOOObOOOObOOOO$"ObOOObOOOObOOOO$#ObOOObOOOObOOOO$$ObOOObOOOObOOOO$%ObOOObOOOObOOOO$&ObOOObOOOObOOOO$'ObOOObOOOObOOOO$(ObOOObOOOObOOOO$)ObOOObOOOObOOOO$*ObOOObOOOObOOOO$+ObOOObOOOObOOOO$,ObOOObOOOObOOOO$-ObOOObOOOObOOOO$.ObOOObOOOObOOOO$/ObOOObOOOObOOOO$0ObOOObOOOObOOOO$1ObOOObOOOObOOOO$2ObOOObOOOObOOOO$3ObOOObOOOObOOOO$4ObOOObOOOObOOOO$5ObOOObOOOObOOOO$6ObOOObOOOObOOOO$7ObOOObOOOObOOOO$8ObOOObOOOObOOOO$9ObOOObOOOObOOOO$:ObOOObOOOObOOOO$;ObOOObOOOObOOOO$<ObOOObOOOObOOOO$=ObOOObOOOObOOOO$>ObOOObOOOObOOOO$?ObOOObOOOObOOOODl(((((((((((((((((((((((((((((((@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_$@ObOOObOOOObOOOO$AObOOObOOOObOOOO$BObOOObOOOObOOOO$CObOOObOOOObOOOO$DObOOObOOOObOOOO$EObOOObOOOObOOOO$FObOOObOOOObOOOO$GObOOObOOOObOOOO$HObOOObOOOObOOOO$IObOOObOOOObOOOO$JObOOObOOOObOOOO$KObOOObOOOObOOOO$LObOOObOOOObOOOO$MObOOObOOOObOOOO$NObOOObOOOObOOOO$OObOOObOOOObOOOO$PObOOObOOOObOOOO$QObOOObOOOObOOOO$RObOOObOOOObOOOO$SObOOObOOOObOOOO$TObOOObOOOObOOOO$UObOOObOOOObOOOO$VObOOObOOOObOOOO$WObOOObOOOObOOOO$XObOOObOOOObOOOO$YObOOObOOOObOOOO$ZObOOObOOOObOOOO$[ObOOObOOOObOOOO$\ObOOObOOOObOOOO$]ObOOObOOOObOOOO$^ObOOObOOOObOOOO$_ObOOObOOOObOOOODl(((((((((((((((((((((((((((((((`abcdefghijklmnopqrstuvwxyz{|}~$`ObOOObOOOObOOOO$aObOOObOOOObOOOO$bObOOObOOOObOOOO$cObOOObOOOObOOOO$dObOOObOOOObOOOO$eObOOObOOOObOOOO$fObOOObOOOObOOOO$gObOOObOOOObOOOO$hObOOObOOOObOOOO$iObOOObOOOObOOOO$jObOOObOOOObOOOO$kObOOObOOOObOOOO$lObOOObOOOObOOOO$mObOOObOOOObOOOO$nObOOObOOOObOOOO$oObOOObOOOObOOOO$pObOOObOOOObOOOO$qObOOObOOOObOOOO$rObOOObOOOObOOOO$sObOOObOOOObOOOO$tObOOObOOOObOOOO$uObOOObOOOObOOOO$vObOOObOOOObOOOO$wObOOObOOOObOOOO$xObOOObOOOObOOOO$yObOOObOOOObOOOO$zObOOObOOOObOOOO${ObOOObOOOObOOOO$|ObOOObOOOObOOOO$}ObOOObOOOObOOOO$~ObOOObOOOObOOOO$ObOOObOOOObOOOODl((((((((((((((((((((((((((((((($ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOODl((((((((((((((((((((((((((((((($ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOO$ObOOObOOOObOOOODl((((((((((((((((((((((((((((((($ObOOObOOOObOOOO$ObOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOODl((((((((((((((((((((((((((((((($OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOODl(((((((((((((((((((((((((((((((     $OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$ OOOOObOOOObOOOO$ OOOOObOOOObOOOO$ OOOOObOOOObOOOO$ OOOOObOOOObOOOO$ OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOODl((((((((((((((((((((((((((((((( !"#$%&'()*+,-./0123456789:;<=>?$ OOOOObOOOObOOOO$!OOOOObOOOObOOOO$"OOOOObOOOObOOOO$#OOOOObOOOObOOOO$$OOOOObOOOObOOOO$%OOOOObOOOObOOOO$&OOOOObOOOObOOOO$'OOOOObOOOObOOOO$(OOOOObOOOObOOOO$)OOOOObOOOObOOOO$*OOOOObOOOObOOOO$+OOOOObOOOObOOOO$,OOOOObOOOObOOOO$-OOOOObOOOObOOOO$.OOOOObOOOObOOOO$/OOOOObOOOObOOOO$0OOOOObOOOObOOOO$1OOOOObOOOObOOOO$2OOOOObOOOObOOOO$3OOOOObOOOObOOOO$4OOOOObOOOObOOOO$5OOOOObOOOObOOOO$6OOOOObOOOObOOOO$7OOOOObOOOObOOOO$8OOOOObOOOObOOOO$9OOOOObOOOObOOOO$:OOOOObOOOObOOOO$;OOOOObOOOObOOOO$<OOOOObOOOObOOOO$=OOOOObOOOObOOOO$>OOOOObOOOObOOOO$?OOOOObOOOObOOOODl(((((((((((((((((((((((((((((((@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_$@OOOOObOOOObOOOO$AOOOOObOOOObOOOO$BOOOOObOOOObOOOO$COOOOObOOOObOOOO$DOOOOObOOOObOOOO$EOOOOObOOOObOOOO$FOOOOObOOOObOOOO$GOOOOObOOOObOOOO$HOOOOObOOOObOOOO$IOOOOObOOOObOOOO$JOOOOObOOOObOOOO$KOOOOObOOOObOOOO$LOOOOObOOOObOOOO$MOOOOObOOOObOOOO$NOOOOObOOOObOOOO$OOOOOObOOOObOOOO$POOOOObOOOObOOOO$QOOOOObOOOObOOOO$ROOOOObOOOObOOOO$SOOOOObOOOObOOOO$TOOOOObOOOObOOOO$UOOOOObOOOObOOOO$VOOOOObOOOObOOOO$WOOOOObOOOObOOOO$XOOOOObOOOObOOOO$YOOOOObOOOObOOOO$ZOOOOObOOOObOOOO$[OOOOObOOOObOOOO$\OOOOObOOOObOOOO$]OOOOObOOOObOOOO$^OOOOObOOOObOOOO$_OOOOObOOOObOOOODl(((((((((((((((((((((((((((((((`abcdefghijklmnopqrstuvwxyz{|}~$`OOOOObOOOObOOOO$aOOOOObOOOObOOOO$bOOOOObOOOObOOOO$cOOOOObOOOObOOOO$dOOOOObOOOObOOOO$eOOOOObOOOObOOOO$fOOOOObOOOObOOOO$gOOOOObOOOObOOOO$hOOOOObOOOObOOOO$iOOOOObOOOObOOOO$jOOOOObOOOObOOOO$kOOOOObOOOObOOOO$lOOOOObOOOObOOOO$mOOOOObOOOObOOOO$nOOOOObOOOObOOOO$oOOOOObOOOObOOOO$pOOOOObOOOObOOOO$qOOOOObOOOObOOOO$rOOOOObOOOObOOOO$sOOOOObOOOObOOOO$tOOOOObOOOObOOOO$uOOOOObOOOObOOOO$vOOOOObOOOObOOOO$wOOOOObOOOObOOOO$xOOOOObOOOObOOOO$yOOOOObOOOObOOOO$zOOOOObOOOObOOOO${OOOOObOOOObOOOO$|OOOOObOOOObOOOO$}OOOOObOOOObOOOO$~OOOOObOOOObOOOO$OOOOObOOOObOOOODl((((((((((((((((((((((((((((((($OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOODl((((((((((((((((((((((((((((((($OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOODl((((((((((((((((((((((((((((((($OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOODl((((((((((((((((((((((((((((((($OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOODl(((((((((((((((((((((((((((((((     $OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$ OOOOObOOOObOOOO$ OOOOObOOOObOOOO$ OOOOObOOOObOOOO$ OOOOObOOOObOOOO$ OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOO$OOOOObOOOObOOOODl((((((((((((((((((((((((((((((( !"#$%&'()*+,-./0123456789:;<=>?$ OOOOObOOOObOOOO$!OOOOObOOOObOOOO$"OOOOObOOOObOOOO$#OOOOObOOOObOOOO$$OOOOObOOOObOOOO$%OOOOObOOOObOOOO$&OOOOObOOOObOOOO$'OOOOObOOOObOOOO$(OOOOObOOOObOOOO$)OOOOObOOOObOOOO$*OOOOObOOOObOOOO$+OOOOObOOOObOOOO$,OOOOObOOOObOOOO$-OOOOObOOOObOOOO$.OOOOObOOOObOOOO$/OOOOObOOOObOOOO$0OOOOObOOOObOOOO$1OOOOObOOOObOOOO$2OOOOObOOOObOOOO$3OOOOObOOOObOOOO$4OOOOObOOOObOOOO$5OOOOObOOOObOOOO$6OOOOObOOOObOOOO$7OOOOObOOOObOOOO$8OOOOObOOOObOOOO$9OOOOObOOOObOOOO$:OOOOObOOOObOOOO$;OOOOObOOOObOOOO$<OOOOObOOOObOOOO$=OOOOObOOOObOOOO$>OOOOObOOOObOOOO$?OOOOObOOOObOOOODl(((((((((((((((((((((((((((((((@ABCDEFGHIJKLMNOPQRSTUV$@OOOOObOOOObOOOO$AOOOOObOOOObOOOO$BOOOOObOOOObOOOO$COOOOObOOOObOOOO$DOOOOObOOOObOOOO$EOOOOObOOOObOOOO$FOOOOObOOOObOOOO$GOOOOObOOOObOOOO$HOOOOObOOOObOOOO$IOOOOObOOOObOOOO$JOOOOObOOOObOOOO$KOOOOObOOOObOOOO$LOOOOObOOOObOOOO$MOOOOObOOOObOOOO$NOOOOObOOOObOOOO$OOOOOObOOOObOOOO$POOOOObOOOObOOOO$QOOOOObOOOObOOOO$ROOOOObOOOObOOOO$SOOOOObOOOObOOOO$TOOOOObOOOObOOOO$UOOOOObOOOObOOOO$VOOOOObOOOObOOOO2d(((((((((((((((((((((( O O>@  "  Sheet26b(b(8df23?ggD g2 @#  dMbP?_*+%&~?'~?(~?)~?M \\GAD-PRINT\GAD_MFD5F340-7793-$ dXX"dPcKRp 4 ****4 **** EE0010000L -L - ddP@ ? ?XX0J,X< Factory Default0000Arial?  A A A A""""""""""""""""dPcKPR0dPcK'RdPcK NRDConfidential 1dPcKR3  dPcKdRdPcKcR<" dXX `? `?&`cU} a} m(a} $ a}  a}  a@   ; ;     @ @   @ @  @ u _C> Enter workbook title here *#Enter workbook title in Cover sheet #BFire_W - TVIN factors*C - x-C Enter the factor type (which should be consistent with the series header types found on the summary sheet (eg early or late retirement) - x-Enter series number (this reflects the number in the relevant series eg if it s the first ER/LR factor then it would be "401").!filename$B}C:\Users\fulkerl\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\1N801RT8\[WG - 2019 - W-FRSC(2019) 03 - Fire Wales TVins - January 2019 alias.xlsm]x-Series Number    9 2 :  E  ;  <    5 =  > 6 ? 7 @ 8 A  B  C     D       <(c  !"#$%&'()*@+,(@-./0123456789:;<=>?  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?D@l  rl\>@U  Sheet28ggD g2   dMbP?_*+%&~?'~?(~?)~?M \\GAD-PRINT\GAD_MFD5F340-7793-$ dXX"dPcKRp 4 ****4 **** EE0010000L -L - ddP@ ? ?XX0J,X< Factory Default0000Arial?  A A A A""""""""""""""""dPcKPR0dPcK'RdPcK NRDConfidential 1dPcKR3  dPcKdRdPcKcR<" dXX `? `?&`cU} a} a}  a   ; ;            @ u _C> Enter workbook title here *#Enter workbook title in Cover sheet #BFire_W - TVIN factors*Cz - x-CTV In (non-club) - x-216.!filename$B}C:\Users\fulkerl\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\1N801RT8\[WG - 2019 - W-FRSC(2019) 03 - Fire Wales TVins - January 2019 alias.xlsm]x-216     3  2~ \@              5~ ?  ~ k@  6 ?  7   . :   I    ,?|(g,,,,,,,,,,,,,   rl\>@U ;@ BA' ;BA';BA' ;BA';@ BA' ;BA'{U{&;@ ZcdW{U{&;ZcdW{U{ &;ZcdW{U{ &;ZcdW{U{&;@ ZcdW{U{&;ZcdW Sheet29ggD g2 O  dҁHMbP?_*+%&~?'~?(~?)~?M \\GAD-PRINT\GAD_MFD5F340-7793-$ dXX"dPcKRp 4 ****4 **** EE0010000L -L - ddP@ ? ?XX0J,X< Factory Default0000Arial?  A A A A""""""""""""""""dPcKPR0dPcK'RdPcK NRDConfidential 1dPcKR3  dPcKdRdPcKcR<" dXX `? `?&`cU} a} a}  a   ; ;            @@ u _C> Enter workbook title here *#Enter workbook title in Cover sheet #BFire_W - TVIN factors*C{ - x-CTV In (non-club) - x-217.!filename$B}C:\Users\fulkerl\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\1N801RT8\[WG - 2019 - W-FRSC(2019) 03 - Fire Wales TVins - January 2019 alias.xlsm]x-217     3  2~ \@              5~ ?  ~  k@  6 A  7   . :   I    ,?|(g,,,,,,,,,,,,,   rl\>@U ;@ BA' ;BA';BA' ;BA';@ BA' ;BA';BA' ;BA' ;BA' ;BA'{U{ &;@ ZcdW{U{ &;ZcdW{U{ &;ZcdW{U{&;ZcdW{U{&;@ ZcdW{U{&;ZcdW{U{&;ZcdW{U{&;ZcdW{U{&;ZcdW{U{&;ZcdW Sheet30ggD g2 *>1  dMbP?_*+%&~?'~?(~?)~?M \\GAD-PRINT\GAD_MFD5F340-7793-$ dXX"dPcKRp 4 ****4 **** EE0010000L -L - ddP@ ? ?XX0J,X< Factory Default0000Arial?  A A A A""""""""""""""""dPcKPR0dPcK'RdPcK NRDConfidential 1dPcKR3  dPcKdRdPcKcR<" dXX `? `?&`cU} a} a}  a   ; ;            @@ u _C> Enter workbook title here *#Enter workbook title in Cover sheet #BFire_W - TVIN factors*C| - x-CTV In (non-club) - x-218.!filename$B}C:\Users\fulkerl\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\1N801RT8\[WG - 2019 - W-FRSC(2019) 03 - Fire Wales TVins - January 2019 alias.xlsm]x-218     3  2~ \@               5~ ?  ~ @k@  6 C  7 !  . :   I     .a(g,,,,,,,,,,,,,   rl\>@U ;@ BA' ;BA';BA' ;BA';@ BA' ;BA';BA' ;BA' ;BA' ;BA'{U{ &;@ ZcdW{U{ &;ZcdW{U{ &;ZcdW{U{&;ZcdW{U{&;@ ZcdW{U{&;ZcdW{U{&;ZcdW{U{&;ZcdW{U{&;ZcdW{U{&;ZcdW Sheet31ggD g2 ]/d  dMbP?_*+%&~?'~?(~?)~?M \\GAD-PRINT\GAD_MFD5F340-7793-$ dXX"dPcKRp 4 ****4 **** EE0010000L -L - ddP@ ? ?XX0J,X< Factory Default0000Arial?  A A A A""""""""""""""""dPcKPR0dPcK'RdPcK NRDConfidential 1dPcKR3  dPcKdRdPcKcR<" dXX `? `?&`cU} a} a}  a   ; ;            $@@ u _C> Enter workbook title here *#Enter workbook title in Cover sheet #BFire_W - TVIN factors*C} - x-CTV In (non-club) - x-219.!filename$B}C:\Users\fulkerl\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\1N801RT8\[WG - 2019 - W-FRSC(2019) 03 - Fire Wales TVins - January 2019 alias.xlsm]x-219     3  2~ \@               5~ ?  ~ `k@  6 E  7 "  . :   I     .a(g,,,,,,,,,,,,,   rl\>@U ;@ BA' ;BA';BA' ;BA';@ BA' ;BA';BA' ;BA' ;BA' ;BA'{U{ &;@ ZcdW{U{ &;ZcdW{U{ &;ZcdW{U{&;ZcdW{U{&;@ ZcdW{U{&;ZcdW{U{&;ZcdW{U{&;ZcdW{U{&;ZcdW{U{&;ZcdW Sheet32ggD g2 C8  dMbP?_*+%&~?'~?(~?)~?M \\GAD-PRINT\GAD_MFD5F340-7793-$ dXX"dPcKRp 4 ****4 **** EE0010000L -L - ddP@ ? ?XX0J,X< Factory Default0000Arial?  A A A A""""""""""""""""dPcKPR0dPcK'RdPcK NRDConfidential 1dPcKR3  dPcKdRdPcKcR<" dXX `? `?&`cU} a} a}  aC   ; ;            @ u _C> Enter workbook title here *#Enter workbook title in Cover sheet #BFire_W - TVIN factors*C~ - x-CTV In (non-club) - x-220.!filename$B}C:\Users\fulkerl\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\1N801RT8\[WG - 2019 - W-FRSC(2019) 03 - Fire Wales TVins - January 2019 alias.xlsm]x-220     3  2~ |@      #        5~   ~ k@  6 ;  7 $  . 7  ~  <@     /   ( ) * +~ 2@fffff3@pv@`s@G@$3@@v@ps@G@$4@@v@ps@G@~ 5@fffff3@v@s@G@$6@@v@s@G@$7@@v@s@G@$8@@v@s@G@<q(g,,,,,,,,,,,,, , F<((<(( !"#$%&'()*+,-./0123456789:;<=>?$ 9@@v@s@G@$!:@@w@s@H@$";@@ w@s@H@$#<@@0w@s@H@$$=@@@w@t@H@$%>@@`w@t@H@$&?@@@ t@H@~ '@@'3@'w@0t@H@~ (@@(3@(w@@t@H@$)A@@w@ @H@$*A@@w@`t@H@~ +B@+Gz3@+w@pt@H@~ ,B@,(\3@,w@t@H@~ -C@-(\3@-x@t@H@$.C@@ x@t@?$/D@@0x@t@?$0D@@@x@t@?$1E@@Px@t@?$2E@@`x@t@?$3F@@x@u@?~ 4F@4(\3@4x@u@I@~ 5G@5(\3@5x@ u@I@~ 6G@6= ףp}3@6x@0u@I@~ 7H@7= ףp}3@7x@Pu@I@~ 8H@8= ףp}3@8x@`u@I@~ 9I@9= ףp}3@9x@pu@I@~ :I@:= ףp}3@:x@u@J@$;J@3@px@u@J@$<J@3@`x@u@J@$=K@@@x@u@J@$>K@@0x@ @J@~ ?L@?(\3@?x@v@J@Dl(((((((<<((<<<((((((<<<<<<<((((@AB$@L@@w@ v@J@$AM@@w@@v@J@$BM@@w@`v@K@ (((  >@U BB;@ BA' ;BA'BB;BA' ;BA';@ BA' ;BA'&;BA' ;BA' ;@ BA' ;BA'{U{B&;@ ZcdW{U{B&;ZcdW{U{B&;ZcdW{U{B&;ZcdW{U{&;@ ZcdW{U{&;ZcdW{U{ &;ZcdW{U{ &;ZcdW{U{&;@ ZcdW{U{&;ZcdW Sheet33ggD g2 C,  dMbP?_*+%&~?'~?(~?)~?M \\GAD-PRINT\GAD_MFD5F340-7793-$ dXX"dPcKRp 4 ****4 **** EE0010000L -L - ddP@ ? ?XX0J,X< Factory Default0000Arial?  A A A A""""""""""""""""dPcKPR0dPcK'RdPcK NRDConfidential 1dPcKR3  dPcKdRdPcKcR<" dXX `? `?&`cU} a} a}  aC   ; ;            y@ u _C> Enter workbook title here *#Enter workbook title in Cover sheet #BFire_W - TVIN factors*C - x-CTV In (non-club) - x-221.!filename$B}C:\Users\fulkerl\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\1N801RT8\[WG - 2019 - W-FRSC(2019) 03 - Fire Wales TVins - January 2019 alias.xlsm]x-221     3  2~ |@      #        5~   ~ k@  6 =  7 %  . 7  ~  <@     /   ( ) * +~ 2@fffff3@pv@@p@C@$3@@v@Pp@C@$4@@v@Pp@C@~ 5@fffff3@v@`p@C@$6@@v@pp@C@$7@@v@p@D@$8@@v@p@D@<q(g,,,,,,,,,,,,, , F<((<(( !"#$%&'()*+,-./0123456789:;<=>?$ 9@@v@p@D@$!:@@w@p@D@$";@@ w@p@D@$#<@@0w@p@D@$$=@@@w@p@D@$%>@@`w@p@D@$&?@@@p@D@~ '@@'3@'w@p@D@~ (@@(3@(w@p@D@$)A@@w@q@D@$*A@@w@q@D@~ +B@+Gz3@+w@ q@D@~ ,B@,(\3@,w@ q@D@~ -C@-(\3@-x@@D@$.C@@ x@@q@D@$/D@@0x@Pq@E@$0D@@@x@`q@E@$1E@@Px@pq@E@$2E@@`x@pq@E@$3F@@x@q@E@~ 4F@4(\3@4x@q@E@~ 5G@5(\3@5x@q@E@~ 6G@6= ףp}3@6x@q@E@~ 7H@7= ףp}3@7x@q@E@~ 8H@8= ףp}3@8x@q@E@~ 9I@9= ףp}3@9x@q@E@~ :I@:= ףp}3@:x@q@E@$;J@3@px@r@E@$<J@3@`x@ r@F@$=K@@@x@0r@F@$>K@@0x@@r@F@~ ?L@?(\3@?x@`r@F@Dl(((((((<<((<<<((((((<<<<<<<((((@AB$@L@@w@pr@F@$AM@@w@r@F@$BM@@w@s@G@ (((  >@U BB;@ BA' ;BA'BB;BA' ;BA';@ BA' ;BA';BA' ;BA' ;@ BA' ;BA' ;BA' ;BA'{U{B&;@ ZcdW{U{B&;ZcdW{U{B&;ZcdW{U{B&;ZcdW{U{ &;@ ZcdW{U{ &;ZcdW{U{ &;ZcdW{U{ &;ZcdW{U{&;@ ZcdW{U{&;ZcdW{U{&;ZcdW{U{&;ZcdW Sheet34ggD   !"#$%&'(*+,-.0123456789:;<=>@BCDFGHIJKLMNOPQRSTVWXYZ[\]^_`abcdfghijklmnopqrstvwxyz{|}~76    !"#$%&'()*+,-./0123458<9:;=O>A249973092019-01-24 - Fire Wales TVins - January 2019Message registered by Myers, Cerys (EPS - CSD) on 24 January 2019 11:56:282019-01-24T11:56:24Zfalsetrue2019-01-24T11:56:34Z2019-01-24T11:57:02ZMyers, Cerys (EPS - CSD)Objective Global Folder:Business File Plan:Education & Public Services (EPS):Education & Public Services (EPS) - Local Government - Community Safety:1 - Save:Fire Services Branch:Fire & Rescue Services Branch - WorkForce & Pensions:Firefighter Pension Scheme Valuations:Fire & Rescue Service - Pensions - Firefighters - Valuation Wales - 2016-2020:# 2018 Factor Review# 2018 Factor ReviewPublishedvA496540181.01First versionqA1216019Official ИB#ThisWorkbook -Sheet1/DatabaseFormatCalcs( L__SRP_2?hxME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2P  rU~|  j d%f%Column heading cannot be a blank cellA@lMacro terminated.A@l|k j} j Z j d%f$n!Column heading cannot be a numberA@lMacro terminated.A@l|pkh j j Z j d%f$pColumn heading cannot be a dateA@lMacro terminated.A@l|k jW Delete names from ranges where the name is identical to the selected column heading.]] v!x!h'rz0 j Z | r j d%f | v!x%! | v!x%! | v!x%!! $~ ! | v!x%! | v!x%!! $ | v!x%!! $~ | v!x%! | v!x%! | v!x%!! $~'t The range t is already named  j d%f in the worksheet  !. Delete name  j d%f from the range  t? $l'` `  | v!x%B@ r 'rzdMacro terminated.A@l|kk | j, Replace " " with "_" in database sheet name !'b j b b j$  j_ b b $'b j be b b $_'bdh b j $_ b j b j $'bkk j b (d4ActiveSheet.name.Replace What:=" ", Replacement:="_"*TempHolder = ActiveSheet.Cells("B1").Value*ActiveSheet.Cells("A2") = ActiveSheet.name<ActiveSheet.Cells("A2").Replace what = " ", Replacement:="_"*ActiveSheet.name = ActiveSheet.Cells("A2")$ActiveSheet.Cells("A2") = TempHolder3 Replace spaces with u8ИDxME (<6<6 <` X `@h$$+K ИP#xME (SLSS<N0{00020819-0000-0000-C000-000000000046} $@Gi& `%h``G"  8 >@ P X n( P  (8  .@ Fp        0 8 @H P h px 4    hX p x  0    ,(  @ P h p 2 Macro written by Michael Scanlon on 1 August 20078 This macro is designed to format new sheets as requiredI Edited by Michael Tagg on 1 April 2008 to produce gad corporate colours.R Edited by Michael Scanlon 24 April 2008 to produce one page width of colour only.g Edit the page setup to include the short file name, sheet name, time and date in the header and footerI This part is implemented whether the new sheet is a worksheet or a chart &!( &Z&F [&A]9*OO Page &P of &N9,&T &D9.q' Formats sheet to GAD corporate colours@ This part is only implemented when the new sheet is a worksheet &!l 0 2(4A1:I1$6!879: >9<q BA1:I1$6%@ F9D J9H9:qA2:I3$6!8 9: >9<qGovernment Actuary's DepartmentA1$6(LA1$6!N9P9:9RqT=IF(title="> Enter workbook title here","Enter workbook title in Cover sheet",title)A2$6(LA2$6!N 9P9:9Rqp> Enter worksheet title hereA3$6(LA3$6!N 9P19:9Rq=CELL("filename",R[-3]C)A4$6(LA4$6!N(P 2(4A3$6B@HkoشAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomi6zD2P Sub _NewSheet(ByVal Sh As Object) ' Macro written by @Michaec@anlon 1 Aug9 20L07 mis designVto format new s EQba  here"",""CA"#u) C B߁` 1 o$lsR:c 4 lo6=49G `O14=CELL(""gAfR[-3]Cnt.4)8'OO uqSelЄIfi@ Macro recorded 19/12/2007 by jeremyc 14`Zx \tPq0%`^AAAg``JFi0`bVAol`r`t+``i@L``` ` 8%` p%`b %````` VP%(^]$*\Rffff*0B5e369ae4_" 6 J@ 6    N `x2   .8h  ,(0 8 ^H    \H   ( 8 @ H h px   2    &0 X&h F     : 0P 0 B 0 *( :X  (  b P X p     @  P  p  x    2        0     ( @ H  P  ` ^p    :  ` p    B  j 8 ,X :  08.P " 6 F H  Fh " <   T(d   0 (@ Hh RHhp x V (  F  Xh 0 F&0X` 4h& ^ V8    l 0 @ `x    : 0 N@ Hh^@ "&$&$@h N  & J `  8  P `&p     > h > VpV2( 0 @ @P  (   , H P p !!~ !!!! !  ! ! !/ Macro written by Jeremy Clarke, January 2008C By selecting column heading(s) from a table, each of the columnsted by0 are named after thier corresponding headings. c 2(4(]p]]]] d!f!h'ZH Error messages if the selected cells contain blanks, numbers or dates j Znderscores in Column Headings j Z _ j d%fB@ j\ Asks the user to change the value of cells if two cells with the same value are selected. j Z | j Z j d%f | d%fPCells j d%f! and  | d%f!" have the same names. Rename cell  j d%f!.$' Macro terminatedA@l|k $n&The column heading cannot be a number.A@l0k( $p$The column heading cannot be a date.A@lk  j d%f(k | jW Column named with heading value. Cells containing column names are written in bold. j Z j d%f.\A1 \$6!!h'^ \= !!RC ^ !xB@ j d!N(R d!N( 2(4oX c This function returns the Column Letter for a particular column number. Works for Columns A to ZZ2 Col is the present column, not the number of cols]AASCII value for capital A]]]4 THIS ALGORITHM ONLY WORKS UP TO ZZ. It fails on AAA  'zk    $'d  '   $  $'kx 'ih/ Macro written by Jeremy Clarke, January 2008@ This macro is designed to create a new spreadsheet containingB formulae and values from a specified row of the selected table.? This macro does not work if there are blank rows between the heading row and the data.5 Minor ammendments by Michael Scanlon 19 March 2008 2(4] FCopyHeader is the Rnage in the database containing the Column Headings]@]XUCopyHeader is the row of the database containing which will have it's formulae copied]x]]]]]$' !'b d!!!h d!%.A Error message if at least one of the selected cells are empty. j d!f!h j d%f!EEmpty cell selected. Please select any non-empty cell from the table.A@lMacro terminated.A@l| k jO The user is required to select the row to be copied, and an error appears if! the row does not contain data.z 7Enter the row number of the data you would like to copy$' Macro terminated.A@l|p kh $n#Please enter number into Input Box.A@lz k A1 d!%$6!!h d!!!h Row does not contain data.A@lz k A1 d!%$6!!h Row does not contain data.A@lz0 k( A1 d!%$6!!h  d!!!h d!%%.O The user is given the option to copy the formulae from the selected row into the rest of the table. B@f New worksheet created contain the formulae and values from the specified row of the selected table. !. Names new worksheet b Formulae ''x   ( !a B@  '   (3 Pagesetup of formulae sheet changed to landscape  !((H Data, headings and info input into formulae sheet and columns autofitThis sheet was created .A4 !$%6("It contains the formulae from row  of sheet  b.A5 !$%6($This sheet will not update if sheet b is altered.A6 !$%6( !A1 !$,6HeadingsA8 !$,6ColumnB8 !$,6FormulaeC8 !$,6ValuesD8 !$,6A8:D8$6!N(RH Copy column headings in the database into column A of the formula sheet B@A9 !$%6B@D Insert column letters / numbers into column B of the formulae sheet j !!ha1 j %f!$6!!h $ / a1 j %f!$6!!h jb8$6%( j2 Copy formulae into column C of the formulae sheet B@ 2(C9 !$%6B@ 2( (Dim pastevalues As Range8Set pastevalues = Sheets(FormulaeSheet.name).Range("D9")a Copy values into formulae sheet column D. This is complicated because this sheet shows formulae8 so getting the values formated correctly is not trivial j !!h j %f!' j %f!$p' j %f! j %f! %d j d9$6, j %f!$ne' j %f! j %f! %d j d9$6,d j %f! j d9$6,k j f!B@: Format cells in the Values column of the formulae sheet j !!!h jc8$6%B@  jd8$6%B@ 2( j% Delete names in the formulae sheet | v!x!h' !' | v!x%! | v!x%!! $ | v!x%!! $~ | v!x%B@#REF | v!x%! | v!x%!! $ | v!x%!! $~e | v!x%B@@k8 | 2(4oAttribute VB_Name = "DatabaseFormatCalcs" Sub Columns(X) 0.DescriptionMacro recorded 19/12/2007 by jeremycaaNProcZInvoke_FuncZ \n14; '  jwritte n^J^ Clarke, January }81By selec@ting cn head(s) from a leach @of thesA"are nd@ afterixrespon&*s.VApplica.ScreenUpdB= FalseADim SNo nNumb*As Sng   Rang YesNoISheet~=G$.Cells.Count+A`Error messages iKXcA !Nntaihla@nks, nB)s @AeU ix1 To AD z If"(i)A" Then MsgBox ("JEa cannot be@wb! &"F tminated.EExit SubCEnd# Next iB/Isueric(FyT2),1P3?0er/Isse^0>%/]QDVrsxrcs wh`Bxa iTdentql toU "wck ^AeshLonqAdbk "d= A`veWorkbook.gh1000GaT}!Ljd' c3cR ight(It@em(j).!#, Len) - In(1,s "!")) A?f#Ž`CLefRefersToR1Cak 1),B"=2ta.9$@= -. .// '0D`= #O("S 2 " &" &2alrqyn1K" ]qrw.se>P. :Rx1 ls?", vb \110U% |9% WGAZ=- 1Go l=qER~ogmgPVdh ij)j' Re place0" with "_rX" @1IUL?;>K,PMid(f, i, 12{0G{ |e q6PCQ & 2Kv21\!t !I`H,` )A)_DoԘ`JPi + - i !9E;1'M LC$What:=" 08t%m`u`TempHold0#s("B1").V8aluZA2~"") w a"  "ls(0 s5sp@66unsn TH UǏPӿsEQ=O,=HשAsdksҎus ch"vaQwod QXsaϓER15o׺ 1- ,+:Mjys5ReLq"pInputЩls.Add2fl a@Vos!ih8aveb!s.0O&fƥ  "EOdDdճExշit Sub  End If If IsNumeric(RenameCell) = True Then bMsgBox ("4 column heading cannot be a numb er.") >GoTo 2000 DateKd(5KSelection.s(i).Val= 3lv15 v tNe@xt j i 'C@d withv17. ?ntains are written in bold.AFor iv1 @a3j!-Set CName <  By Range("AH1",). sQuntCA@PveSheet.@s.Add ::=D,@TfersToR1C1:="=" & A "!RC$T0Font.NBB+A I talicF (AppaB|ScreenUp[Ut Fun GetXL@$( As Integer)XStrA'is fE returns theQ Leqr fna partic0ularED Work@ @s A to ZZ '! present, v ofE!s=nst = 65 ASCI I Qcapi ' ADim iMult@Gs$" A BRema`U%c`$HIS ALGORITHM ONLY WORKS UP TO`. It fails opn AA$ >x 70^*3`="" Ex8 v <= 25L= Chr(A +a-ElseU i=!B(C/ 26)) - n1 )] K_'Moda s! `uRb@pymKe(T Macroby Je@remy CPke, JanuaDry8 ThLmdesignedQ@h!ew sPad~sMC] aBM[rom@specifi rowAUWs 0able`does\wd ifAl`blank ` stw`|! !A a Minrmmend` ^#Michael SlQ19@(rch$*IڊFa"F bCopyHer!9 '+aRnage!baseH 1)zG=Row_IwadtqB_3iwhkll hav t'2JcopPs`g?Aa)N1#TireP%d B1SuffixYSYes$No = Now11g =h'esF= 'fCuDrr@WRegR`1ze(1,K\s9ErrP'messBf a t lea@Zone1cempty+`jo33DN ""8PUfEQ Q E9. P e0=y8ln- f=a$t;UVCHtermin[SOCٔS@e us3+requiraBo_Aa,rp3),bGan eappexars`CSA%FEcakA 1 5_put("Er"97wq! you would likeSp@A 0YO#n8@!HO(",p in In@~ P3L - ɣ22ows(01)). >?35,u/ ("` ata r?ӟ h < 0O O R%gbcpy[OGteOG.kIKG.Offset(Tb\, 02L1-9giv@ʡ/opq.1fA~3!'m(9e!P} cD!Yf rmr.ShowAAN р4d< ODo@ Kl=ú1l P@i bl r& "  4m= On bor Resume Next FormulaeSheet.na= Base & Suffix Do Until Err.number = 0 Clear Z,+ 1#Loopd' Pagesetup oHf f s changed to landspcape7 ASA.Orient ationxlL 46Data, headings  infoput4 A@columnuptofi}Os"().RY("A4").ValueE"Thisjwas creatl"TimeC& ".".5.It coE|iRthefrom row RowNrA[Y‚Ng 67ill not upd9 if> DalteredA==1")S]"8"HbZB C C E)m" D s ő8:.Fx.BoDld?Tru' Copy~in A@_abinZX A?hDc3jA !#er.A *`\9`@PasteSpecial Transpose:=InserATlet@>s / ÊsnBe) ip1 To sYuns` d'b!`*.Off(i, 0rGetX L@:($a1",j ells(i).Address) - 1)=`w"Z y! i/D9i6Cw"!5py @Applic.DisplayA l`/s&FalswFB}:C: >ActiveWindow$bDim pHvs AsC8 ' J= ?D * B*̻ND. cB com(bPecau tǷs0hows& so g`Z n  bcorrect lytriv`eNZd9 Z&a>t8=TC A_If Is e>(ET en3,d3A.A3`"'Q.Work2cFunon.T?_co4 at:)EP) ericO U>O >O O O ).H "Eo`8End IfY@C$.Ereg.A@FC cS' @jB&c u)ntRegP.0T("cT%.a:=x6lS sDCutModa$KYR Dede c[=200y j Bc$I`,book.0(S. @0= Right(Left(es.Item(j efersToR1C1, InStr(??4"!Af /!2)(>CGouR*:"#REF"O OOk8_ X <1)O//O OOBTHj:j%+bSenU`=G ÙaSub arU $`a(`&$`nИ^#x__SRP_3 AfrmCopyCells?#Sheet2 ESheet3UME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2  ИO#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 " Иiq#xSheet27eSheet5uSheet28Sheet26ME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "Sheet27" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2ИB#xXL_ И=xME(S<S<S<S<0{E3196CBF-AD5F-442F-B46E-664782F8CB03}{D1882474-52AF-4740-960B-D5EED5933A8A} @    @      @   `rminH@%pH % H="  " ( 0@"H P"X ` "h p "x  "  "  "  "  ".((8 "@ RH ^  * Ppx  0@ A@rho`@A@ B@o8o(oo@oxohoXoH@o8 d!!!h d!%f! ( d!%f! ( ! (o]DFirstColumn is the column number of the first coulmn in the database A1 d!%$6!!h  d!!!h d!%%. d!%f! ' j   d!!!h  j $%f!" j $%fB@ $ a1 j $%f$6!!h$f a1 j $%f$6!!h$f$6B@ 2(k joRAttribute VB_Name = "frmCopyCells" Bas0{E3196CBF-AD5F-442F-B46E-664782F8CB03}{D188247 4-52AJ740-960B-D5EED5933A8A} dGlobalSpacAoFalse CreatablPredeclaIdTru BExpose0Template DerivCu@stomizDP Sub btnNo_Click() Un@load MFEnd YesRow Me.Hid  Label1 /2!3% 5 txtBotK@3_ChangeAD*K #>d TopUserForm`- InitializB- 3.ValuSelection.Curre`ntRegB(U,s.Coun@t, 1). . C31 +\ 1NA&v~eCHT2Dim FirstColumn As Long 'is the cCnumberh off@ulinbdu]Set !D`s6#es-5').Offse t(' - RM"A1",  ows(1)/f10u I=¥(0c@L iiToJ++W +: If F h).i).HasZulaA Then a7%b& FQ,=E)aA)V )), _ ls(i1;).PasteSpec q 0:=xlsAndNQatsѧAppat[pyMod(A$bIf Next iME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2ИB#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "Sheet28" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2Иr#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "Sheet26" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2Иj#xSheet32Sheet33Sheet29 Sheet30ME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "Sheet32" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2Иy#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "Sheet33" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2ИL#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "Sheet29" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2ИJ#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "Sheet30" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2Иo#xSheet31Sheet34Module1_VBA_PROJECThME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "Sheet31" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2ИA#x      !"#%&'()*+,-./012345679:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXZ[\^j`abcdefghiklmnoprtuvwyz{|}~ME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "Sheet34" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2|И[xME(<<< < @`  BX% H  Bspon%`(`^]" R >`    " T >P    LThis routine will go through and Protect all the worksheets for the workbook8Change the Password to any required value or leave blank]@ B v!3  F@ctors2018!F BB@Do`NThis routine will go through and Unprotect all the worksheets for the workbook8Change the Password to any required value or leave blank] B v!O F@ctors2018!F BB@J^(o 2Attribute VB_Name = "Module1" Sub LockWorksheets() 'This routine will go th"gh and Pro@tect a4thF~ forT!$bookNChangePassword toHy required value ;leave blan: @Dim ws As  BF2Each $In Active*B.s '.dK:="F@ctors2018!Next4E{UnlUnpz1N2jO촀0* pHd ColumnNames8@ = t  ^]( J< rstdole>stdole h%^*\G{00020430-;C 0046}#2.0#0#C:\Windows\Sys@WOW64\e2.tlb#OLE Automat8ion0EOfficEOficEE2DF8D04CRfjlF^K+~A.=d GBœCj8Bh@w )`= BasenameExcel+VBAWin16~Win32Win64xMacVBA6#VBA7# ColumnNamesPstdole`OfficeuMSFormsC ThisWorkbook| _EvaluateWorkbook_NewSheet+|Sh_ PageSetup LeftHeader LeftFooter RightFooter|S xlWorksheet, Application*ScreenUpdating! Range Interior; ColorIndexPatternixlSolid7nBordersC" xlEdgeBottom LineStylew xlContinuous[Weight1xlThinw FormulaR1C1SFontUSizeBoldSheet1DatabaseFormatCalcs NameColumns9SelectionNumber" ColumnNamew ColumnNumberYesNoC SheetName6 SelectionZCellsCount0vi`MsgBoxR IsNumeric$*IsDate2 CountNamess NamedCellsActiveWorkbookNamesο1000"/jaRight Itemz ActiveSheet%N RefersToR1C1cvbYesNovbYesa?DeletexReplacefWhatC Replacement1500I2000 RenameCell1InputBox AddressValueKColumnsp9AddrItalic!GetXLColColHAXiMultssColHiRemainChrK~ CopyFormulaet CopyHeader  RowNumberCopyData FormulaeSheetߏ Worksheet TimeCreatedSuffix_MNow% CurrentRegion|Resize@4RowsUOffset frmCopyCellsShow WorksheetsErronumber-Clear Orientationw xlLandscape&Sheets Copyƿ PasteSpecialK Transpose DisplayAlerts ActiveWindow+DisplayFormulasl NumFormat NumberFormatRWorksheetFunction& EntireColumnAutoFit& PastexlPasteFormats CutCopyMode btnNo_Click+! btnYes_ClickdCopyRow Hide9z Label1_Click Label2_Click Label3_Click< Label5_Click=txtBottomRow_Change3txtCopyRow_Change txtTopRow_ChangeOUserForm_ClickUserForm_Initialize5c txtBottomRowƚRow txtTopRowY txtCopyRow ActiveCell FirstColumn'YColumni HasFormulaxlPasteFormulasAndNumberFormatstSheet2Sheet3Sheet27LPSheet5Sheet28MPSheet26KPSheet32lPSheet33mPSheet29NPSheet30jPSheet31kPSheet34nPModule1bLockWorksheets) wsWorksheetProtectfPasswordUnlockWorksheets  Unprotect?Workbookk1 -3 5 7 9 ;=?UW '$*)#!*+%-+/,.2a  *\G{000204EF-0000-0000-C000-000000000046}#4.1#9#C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.7#0#C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE#Microsoft Excel 14.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation4*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.5#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\MSO.DLL#Microsoft Office 15.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\SysWOW64\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{8483388F-A76C-4EA8-97D0-3563F5C65A3D}#2.0#0#C:\Users\fulkerl\AppData\Local\Temp\6\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M  ^]  ИThisWorkbook015e369ac2!ThisWorkbookPQ Sheet1025e369ac2U Sheet1B%&DatabaseFormatCalcs0B5e369ae4V&DatabaseFormatCalcsD08frmCopyCells045e369ac2frmCopyCells=H Sheet2055e369ac2' Sheet2^`% Sheet3065e369ac2) Sheet3Ox%Sheet27075e369ac2+Sheet27iq% Sheet5085e369ac2- Sheet5B%Sheet28095e369ac2/Sheet28B%Sheet260:5e369ac21Sheet26r%Sheet320;5e369ac23Sheet32j%Sheet330<5e369ac25Sheet33y%Sheet290=5e369ac27Sheet29L %Sheet300>5e369ac29Sheet30J8%Sheet310?5e369ac2;Sheet31oP%Sheet340@5e369ac2=Sheet34Ah%Module10A5e369ac2>Module1[PH 8`x0hQ,$K J.lGr@a_kAF ӰURVIeK*Nj;hD'xl FhtI0K,6hHzCPL˰~f ,2{@W1Y1e>0ahUUA'd083Ԃ քN#rm;d8hAZ[fƯ@A4A2A!+e(OA=4vdir$__SRP_08,__SRP_1YfrmCopyCells!'n'n-5BFA-101B-BDE5EAAC42EProgram Files (x86)\Common \Microsoft Shared\OFFICE14\MSO.DLL#P 15.0 Object Lib0raryNMSForms>SFrms3D452EE1-E08"F1A-8-02608C4D0BB4TFM20L'B @a&/;"1lrAr00}#0r# 50 A848338@5A76C-4EA8-97D0-3563F5C65A3D6Users\fulkerl\AppData\Local\Temp\6\V BE@c7.exdHd<".E .`PM DИ¾ThisWorkb@ookGT@ilWokbAok 2E HB1QB,P""+bsSheet1G Se`at1 !w2 % B .basea*atCalcsG&Ta@a@ a"eYC`lts28D!%frmCopyCell!8fnC6pyC'~l`#8o-*=#*(*&5*28282828^8 3 j3 3 3 TO "Q27G❱U27@2SAiq55555BU8888R_6_6Z6_6_$rR3 +l3A+3P+_j_S+M+W+_a_y_R29999@L_0]30Y30]ÿJ_S e Ae1_1o_S444_4__PA_ModuleM@`duߵS U_[YhpK*rU~~~~~~~~k \xA@ᰂ     A  )Y        ) A Y q Y ColumnNames ThisWorkbookSheet1DatabaseFormatCalcs frmCopyCellsSheet2Sheet3Sheet27Sheet5Sheet28Sheet26Sheet32Sheet33Sheet29Sheet30Sheet31Sheet34Module1F /C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLLVBA  I0F8lN5cZ=:C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXEExcel  @0FC:\Windows\SysWOW64\stdole2.tlbstdole !iPL-[DREC:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\MSO.DLLOffice `.E .`M C:\Windows\SysWOW64\FM20.DLLMSForms  1yp5C:\Users\fulkerl\AppData\Local\Temp\6\VBE\MSForms.exd   y NameColumnsGetXLCol CopyFormulae TrU  $Macro recorded 19/12/2007 by jeremyc 14Cold(H  @$}-!R KQDBTahoma ( 4txtTopRowqH,,5Tahoma1f]o "_CompObj#qaVBFrames+H,,5Tahoma1(oText, numbers, currency, percentages, dates and times will only be copied if they are preceded by the = symbol.O5Tahoma1(yYeso OuTahoma1H,,5Tahoma1<(,Would you like to copy the formulae from row'5Tahoma1( into rows 5Tahoma1(toho5Tahoma1(?05Tahoma(nNoEOuTahoma"( 4txtBottomRow"(2Label5q$8btnYes ( 4txtCopyRowow( 2\Label1( 2<Label2"( 24Label3"( 24Label4S"(78 btnNo41   Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} frmCopyCells Caption = "Copy Formulae" ClientHeight = 2400 ClientLeft = 45 ClientTop = 435 ClientWidth = 4815 StartUpPosition = 1 'CenterOwner TypeInfoVer = 36 End PROJECTwmxPROJECTSummaryInformation('DocumentSummaryInformation8l$ThisWorkbookThisWorkbookSheet1Sheet1DatabaseFormatCalcsDatabaseFormatCalcsfrmCopyCellsfrmCopyCellsSheet2Sheet2Sheet3Sheet3Sheet5Sheet5Sheet26Sheet26Sheet28Sheet28Sheet27Sheet27Sheet29Sheet29Sheet30Sheet30Sheet31Sheet31Sheet32Sheet32Sheet33Sheet33Sheet34Sheet34Module1Module1ID="{001883F7-E00F-4429-A344-2464B2E807A1}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=DatabaseFormatCalcs Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} BaseClass=frmCopyCells Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Document=Sheet5/&H00000000 Document=Sheet26/&H00000000 Document=Sheet28/&H00000000 Document=Sheet27/&H00000000 Document=Sheet29/&H00000000 Document=Sheet30/&H00000000 Document=Sheet31/&H00000000 Document=Sheet32/&H00000000 Document=Sheet33/&H00000000 Document=Sheet34/&H00000000 Module=Module1 HelpFile="" Name="ColumnNames" HelpContextID="0" VersionCompatible32="393222000" CMG="F0F2618765876587658765" DPB="E0E2717272727272" GC="D0D241624262429D" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C DatabaseFormatCalcs=0, 0, 0, 0, C frmCopyCells=0, 0, 0, 0, C, 25, 25, 1600, 698, C Sheet2=0, 0, 0, 0, C Sheet3=0, 0, 0, 0, C Sheet5=0, 0, 0, 0, C Sheet26=0, 0, 0, 0, C Sheet28=0, 0, 0, 0, C Sheet27=0, 0, 0, 0, C Sheet29=0, 0, 0, 0, C Sheet30=0, 0, 0, 0, C Sheet31=0, 0, 0, 0, C Sheet32=0, 0, 0, 0, C Sheet33=0, 0, 0, 0, C Sheet34=0, 0, 0, 0, C Module1=0, 0, 0, 0, C Oh+'0HPd  Brian AllanFellows, Carl (Admin)Microsoft Excel@۶i@vFgD@wnTION_1'x-221'!TABLE_SECTION_1'x-216'!TABLE_SECTION_NUMBER'x-217'!TABLE_SECTION_NUMBER'x-218'!TABLE_SECTION_NUMBER'x-219'!TABLE_SECTION_NUMBER'x-220'!TABLE_SECTION_NUMBER'x-221'!TABLE_SECTION_NUMBERTABLE_SECTION_NUMBER'x-216'!TABLE_SECTION_NUMBER_1'x-217'!TABLE_SECTION_NUMBER_1'x-218'!TABLE_SECTION_NUMBER_1'x-219'!TABLE_SECTION_NUMBER_1'x-220'!TABLE_SECTION_NUMBER_1'x-221'!TABLE_SECTION_NUMBER_1'x-216'!TABLE_SERIES_NUMBER'x-217'!TABLE_SERIES_NUMBER'x-218'!TABLE_SERIES_NUMBER'x-219'!TABLE_SERIES_NUMBER'x-220'!TABLE_SERIES_NUMBER'x-221'!TABLE_SERIES_NUMBERTABLE_SERIES_NUMBER'x-216'!TABLE_SERIES_NUMBER_1'x-217'!TABLE_SERIES_NUMBER_1'x-218'!TABLE_SERIES_NUMBER_1'x-219'!TABLE_SERIES_NUMBER_1'x-220'!TABLE_SERIES_NUMBER_1'x-221'!TABLE_SERIES_NUMBER_1title  Worksheets  Named Ranges"+?w     #+K_s kw !  SW-DOC-IDSW-FINGERPRINT Objective-IdObjective-TitleObjective-DescriptionObjective-CreationStampObjective-IsApproved Objective-IsPublished Objective-DatePublished Objective-ModificationStamp Objective-Owner Objective-PathObjective-ParentObjective-StateObjective-VersionIdObjective-VersionObjective-VersionNumberObjective-VersionCommentObjective-FileNumberObjective-ClassificationObjective-CaveatsObjective-LanguageObjective-Date AcquiredObjective-What to KeepObjective-Official TranslationObjective-Connect CreatorObjective-CommentObjective-Language [system]!Objective-Date Acquired [system] Objective-What to Keep [system] (Objective-Official Translation [system]!#Objective-Connect Creator [system]$3ca5445f6e7b4f7d890fddad30f93fa4 A2499730902019-01-24 - Fire Wales TVins - January 2019LMessage registered by Myers, Cerys (EPS - CSD) on 24 January 2019 11:56:28@E*۳ @E*۳@۳Myers, Cerys (EPS - CSD)Objective Global Folder:Business File Plan:Education & Public Services (EPS):Education & Public Services (EPS) - Local Government - Community Safety:1 - Save:Fire Services Branch:Fire & Rescue Services Branch - WorkForce & Pensions:Firefighter Pension Sch# 2018 Factor Review Published vA496540181.0?First version[Inherited - Official]LMessage registered by Myers, Cerys (EPS - CSD) on 24 January 2019 11:56:28E_DESCRIPTION_1'x-216'!TABLE_FACTOR_STATUS'x-217'!TABLE_FACTOR_STATUS'x-218'!TABLE_FACTOR_STATUS'x-219'!TABLE_FACTOR_STATUS'x-220'!TABLE_FACTOR_STATUS'x-221'!TABLE_FACTOR_STATUSTABLE_FACTOR_STATUS'x-216'!TABLE_FACTOR_STATUS_1'x-217'!TABLE_FACTOR_STATUS_1'x-218'!TABLE_FACTOR_STATUS_1'x-219'!TABLE_FACTOR_STATUS_1'x-220'!TABLE_FACTOR_STATUS_1CompObjk՜.+,D՜.+, PX  > Government Actuary's Department CoverPurpose of spreadsheetVersion ControlSummary - Fire_EAnnGenHiddenLists Factor Listx-Series Numberx-216x-217x-218x-219x-220x-221BaseTablesListDATE_MODIFIEDFACTOR_LIST_AGE_DEFFACTOR_LIST_CLIENTFACTOR_LIST_DATE_IMPLEMENTEDFACTOR_LIST_DATE_ISSUEDFACTOR_LIST_DESCRIPTIONFACTOR_LIST_FACTOR_STATUSFACTOR_LIST_FACTOR_TYPEFACTOR_LIST_GENDERFACTOR_LIST_HEADINGSFACTOR_LIST_REFERENCEFACTOR_LIST_REFERENCE_GUIDANCEFACTOR_LIST_RELATEDFACTOR_LIST_SECTIONFACTOR_LIST_SECTION_NUMBERFACTOR_LIST_SERIES_NUMBERFACTOR_LIST_SOURCEFACTOR_LIST_TABLE_IDFACTOR_LIST_TIMESTAMPFACTOR_LIST_USER_IDImprovementsList'Summary - Fire_E'!Print_Area'x-220'!Print_Area'x-221'!Print_Area'x-Series Number'!Print_Area'x-216'!TABLE_AGE_DEF'x-217'!TABLE_AGE_DEF'x-218'!TABLE_AGE_DEF'x-219'!TABLE_AGE_DEF'x-220'!TABLE_AGE_DEF'x-221'!TABLE_AGE_DEFTABLE_AGE_DEF'x-216'!TABLE_AGE_DEF_1'x-217'!TABLE_AGE_DEF_1'x-218'!TABLE_AGE_DEF_1'x-219'!TABLE_AGE_DEF_1'x-220'!TABLE_AGE_DEF_1'x-221'!TABLE_AGE_DEF_1'x-218'!TABLE_AREA'x-219'!TABLE_AREA'x-220'!TABLE_AREA'x-221'!TABLE_AREA TABLE_AREA'x-220'!TABLE_AREA_1'x-221'!TABLE_AREA_1'x-216'!TABLE_CLIENT'x-217'!TABLE_CLIENT'x-218'!TABLE_CLIENT'x-219'!TABLE_CLIENT'x-220'!TABLE_CLIENT'x-221'!TABLE_CLIENT TABLE_CLIENT'x-216'!TABLE_CLIENT_1'x-217'!TABLE_CLIENT_1'x-218'!TABLE_CLIENT_1'x-219'!TABLE_CLIENT_1'x-220'!TABLE_CLIENT_1'x-221'!TABLE_CLIENT_1'x-216'!TABLE_DATE_IMPLEMENTED'x-217'!TABLE_DATE_IMPLEMENTED'x-218'!TABLE_DATE_IMPLEMENTED'x-219'!TABLE_DATE_IMPLEMENTED'x-220'!TABLE_DATE_IMPLEMENTED'x-221'!TABLE_DATE_IMPLEMENTEDTABLE_DATE_IMPLEMENTED!'x-216'!TABLE_DATE_IMPLEMENTED_1!'x-217'!TABLE_DATE_IMPLEMENTED_1!'x-218'!TABLE_DATE_IMPLEMENTED_1!'x-219'!TABLE_DATE_IMPLEMENTED_1!'x-220'!TABLE_DATE_IMPLEMENTED_1!'x-221'!TABLE_DATE_IMPLEMENTED_1'x-216'!TABLE_DATE_ISSUED'x-217'!TABLE_DATE_ISSUED'x-218'!TABLE_DATE_ISSUED'x-219'!TABLE_DATE_ISSUED'x-220'!TABLE_DATE_ISSUED'x-221'!TABLE_DATE_ISSUEDTABLE_DATE_ISSUED'x-216'!TABLE_DATE_ISSUED_1'x-217'!TABLE_DATE_ISSUED_1'x-218'!TABLE_DATE_ISSUED_1'x-219'!TABLE_DATE_ISSUED_1'x-220'!TABLE_DATE_ISSUED_1'x-221'!TABLE_DATE_ISSUED_1'x-216'!TABLE_DESCRIPTION'x-217'!TABLE_DESCRIPTION'x-218'!TABLE_DESCRIPTION'x-219'!TABLE_DESCRIPTION'x-220'!TABLE_DESCRIPTION'x-221'!TABLE_DESCRIPTIONTABLE_DESCRIPTION'x-216'!TABLE_DESCRIPTION_1'x-217'!TABLE_DESCRIPTION_1'x-218'!TABLE_DESCRIPTION_1'x-219'!TABLE_DESCRIPTION_1'x-220'!TABLE_DESCRIPTION_1'x-221'!TABLE_DESCRIPTION_1'x-216'!TABLE_FACTOR_STATUS'x-217'!TABLE_FACTOR_STATUS'x-218'!TABLE_FACTOR_STATUS'x-219'!TABLE_FACTOR_STATUS'x-220'!TABLE_FACTOR_STATUS'x-221'!TABLE_FACTOR_STATUSTABLE_FACTOR_STATUS'x-216'!TABLE_FACTOR_STATUS_1'x-217'!TABLE_FACTOR_STATUS_1'x-218'!TABLE_FACTOR_STATUS_1'x-219'!TABLE_FACTOR_STATUS_1'x-220'!TABLE_FACTOR_STATUS_1'x-221'!TABLE_FACTOR_STATUS_1'x-216'!TABLE_FACTOR_TYPE'x-217'!TABLE_FACTOR_TYPE'x-218'!TABLE_FACTOR_TYPE'x-219'!TABLE_FACTOR_TYPE'x-220'!TABLE_FACTOR_TYPE'x-221'!TABLE_FACTOR_TYPETABLE_FACTOR_TYPE'x-216'!TABLE_FACTOR_TYPE_1'x-217'!TABLE_FACTOR_TYPE_1'x-218'!TABLE_FACTOR_TYPE_1'x-219'!TABLE_FACTOR_TYPE_1'x-220'!TABLE_FACTOR_TYPE_1'x-221'!TABLE_FACTOR_TYPE_1'x-216'!TABLE_GENDER'x-217'!TABLE_GENDER'x-218'!TABLE_GENDER'x-219'!TABLE_GENDER'x-220'!TABLE_GENDER'x-221'!TABLE_GENDER TABLE_GENDER'x-216'!TABLE_GENDER_1'x-217'!TABLE_GENDER_1'x-218'!TABLE_GENDER_1'x-219'!TABLE_GENDER_1'x-220'!TABLE_GENDER_1'x-221'!TABLE_GENDER_1'x-216'!TABLE_INFO'x-217'!TABLE_INFO'x-218'!TABLE_INFO'x-219'!TABLE_INFO'x-220'!TABLE_INFO'x-221'!TABLE_INFO TABLE_INFO'x-216'!TABLE_INFO_1'x-217'!TABLE_INFO_1'x-218'!TABLE_INFO_1'x-219'!TABLE_INFO_1'x-220'!TABLE_INFO_1'x-221'!TABLE_INFO_1'x-216'!TABLE_REFERENCE'x-217'!TABLE_REFERENCE'x-218'!TABLE_REFERENCE'x-219'!TABLE_REFERENCE'x-220'!TABLE_REFERENCE'x-221'!TABLE_REFERENCETABLE_REFERENCE'x-216'!TABLE_REFERENCE_1'x-217'!TABLE_REFERENCE_1'x-218'!TABLE_REFERENCE_1'x-219'!TABLE_REFERENCE_1'x-220'!TABLE_REFERENCE_1'x-221'!TABLE_REFERENCE_1!'x-216'!TABLE_REFERENCE_GUIDANCE!'x-217'!TABLE_REFERENCE_GUIDANCE!'x-218'!TABLE_REFERENCE_GUIDANCE!'x-219'!TABLE_REFERENCE_GUIDANCE!'x-220'!TABLE_REFERENCE_GUIDANCE!'x-221'!TABLE_REFERENCE_GUIDANCETABLE_REFERENCE_GUIDANCE#'x-216'!TABLE_REFERENCE_GUIDANCE_1#'x-217'!TABLE_REFERENCE_GUIDANCE_1#'x-218'!TABLE_REFERENCE_GUIDANCE_1#'x-219'!TABLE_REFERENCE_GUIDANCE_1#'x-220'!TABLE_REFERENCE_GUIDANCE_1#'x-221'!TABLE_REFERENCE_GUIDANCE_1'x-216'!TABLE_RELATED'x-217'!TABLE_RELATED'x-218'!TABLE_RELATED'x-219'!TABLE_RELATED'x-220'!TABLE_RELATED'x-221'!TABLE_RELATEDTABLE_RELATED'x-216'!TABLE_RELATED_1'x-217'!TABLE_RELATED_1'x-218'!TABLE_RELATED_1'x-219'!TABLE_RELATED_1'x-220'!TABLE_RELATED_1'x-221'!TABLE_RELATED_1'x-216'!TABLE_SECTION'x-217'!TABLE_SECTION'x-218'!TABLE_SECTION'x-219'!TABLE_SECTION'x-220'!TABLE_SECTION'x-221'!TABLE_SECTIONTABLE_SECTION'x-216'!TABLE_SECTION_1'x-217'!TABLE_SECTION_1'x-218'!TABLE_SECTION_1'x-219'!TABLE_SECTION_1'x-220'!TABLE_SEC FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89q