{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Settings","References","Instructions","1.General","2.Exp_Prem"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":53,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Settings","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["For Department Use Only"]
[]
["Click button below to unprotect all sheets of this file."]
[]
["Password:","CNPL6V0h"]
[]
["Click button below to reprotect all sheets of this file."]
[]
[]
["Enter Edition Date here=>","01/04/2021"]
["Click button below to update footers for each sheet of the application with new edition date."]
[]
["Check to ensure that each sheet's print preview shows the correct edition date."]
[]
["Click button below to hide sheets that are for Department use only, i.e. Input sheet."]
["(Note: Run macro explicitly from Developer menu to unhide sheet.)"]
[]
[]
["RangeNames"]
["Edition_Date",{"$f":"B10&\" Edition\"","v":"01/04/2021 Edition"}]
["Co_Name",{"$f":"IF(ISBLANK('1.General'!$C$12),\"\",'1.General'!$C$12)","v":""}]
["General_Line",{"$f":"INDEX(List_GeneralLine,References!$F$5,1)","v":0}]
["CDI_FileNo",{"$f":"IF(ISBLANK('1.General'!$B$10),\"\",'1.General'!$B$10)","v":""}]
["Completed_By",{"$f":"IF(ISBLANK('1.General'!$B$8),\"\",'1.General'!$B$8)","v":""}]
["Completed_Date",{"$f":"IF(ISBLANK('1.General'!$F$8),\"\",'1.General'!$F$8)","v":""}]
["AggMethod",{"$f":"INDEX(List_AggMethod,References!$L$5,1)","v":{"$error":"#NAME?"}}]

{"sheet":"References","index":1,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["For Department Use Only"]
[null,"Y/N Indicator",null,"Line Type",null,"General Line (Page 1)",null,null,"Detailed Line Description/AS Line Number (Page 1)",null,null,"Data Aggregation Method (Page 1)",null,"Exhibits to Print (Page 1)",null,"Detailed Line Description(s) Converter"]
[null,"Y/N/na Indicator",null,null,null,null,null,null,null,null,null,null,null,null,null,"(Index to text)"]
[null,"(Not Used)"]
["Combo Box controls listed to the right on this row, if applicable=>",null,null,3,null,1,null,null,null,null,null,0,null,1]
[null,"Y",null,"Commercial",null,null,null,null,null,null,null,"Accident Quarter",null,"Exposure & Premium",null,1,1]
[null,"N",null,"Personal",null,"Aircraft",null,null,"Aircraft",22,null,"Report Quarter",null,null,null,2,1]
[null,"n/a",null,null,null,"Allied Lines",null,null,"Allied Lines",2.1,null,"Policy Quarter",null,null,null,3,1]
[null,null,null,null,null,"Auto Liability and Physical Damage",null,null,"Auto Warranty",17,null,null,null,null,null,4,1]
[null,null,null,null,null,"Auto Warranty",null,null,"Boiler & Machinery",27,null,null,null,null,null,5,1]
[null,null,null,null,null,"Boiler & Machinery",null,null,"Burglary & Theft",26,null,null,null,null,null,6,1]
[null,null,null,null,null,"Burglary & Theft",null,null,"Commercial Auto Liability",19.399999999999999,null,null,null,null,null,7,1]
[null,null,null,null,null,"Earthquake",null,null,"Commercial Auto Physical Damage",21.2,null,null,null,null,null,8,1]
[null,null,null,null,null,"Farmowners",null,null,"Commercial Multiple Peril (Combined)",5,null,null,null,null,null,9,1]
[null,null,null,null,null,"Fidelity",null,null,"Commercial Multiple Peril (Liability)",5.2,null,null,null,null,null,10,1]
[null,null,null,null,null,"Fire",null,null,"Commercial Multiple Peril (Non-Liability)",5.0999999999999996]
[null,null,null,null,null,"Fire & Allied Lines",null,null,"Earthquake",12]
[null,null,null,null,null,"Flood",null,null,"Earthquake w/consideration for the cost of reinsurance","12.0R"]
[null,null,null,null,null,"Homeowners",null,null,"Farmowners Multiple Peril",3]
[null,null,null,null,null,"Home Warranty",null,null,"Fidelity",23]
[null,null,null,null,null,"Inland Marine",null,null,"Fire",1]
[null,null,null,null,null,"Medical Malpractice",null,null,"Home Warranty",9]
[null,null,null,null,null,"Multiple Peril",null,null,"Homeowners Multiple Peril",4]
[null,null,null,null,null,"Other Liability",null,null,"Inland Marine",9]
[null,null,null,null,null,"Products Liability",null,null,"Medical Malpractice",11]
[null,null,null,null,null,"Surety",null,null,"Medical Malpractice (Claims-Made)",11.2]
[null,null,null,null,null,null,null,null,"Medical Malpractice (Occurrence)",11.1]
[null,null,null,null,null,null,null,null,"Medical Malpractice - incl. reinsurance costs","11.0R"]
[null,null,null,null,null,null,null,null,"Medical Malpractice (Claims-Made) - incl. reinsurance costs","11.2R"]
[null,null,null,null,null,null,null,null,"Medical Malpractice (Occurrence) - incl. reinsurance costs","11.1R"]
[null,null,null,null,null,null,null,null,"Other Liability",17]
[null,null,null,null,null,null,null,null,"Other Liability (Claims-Made)",17.2]
[null,null,null,null,null,null,null,null,"Other Liability (Occurrence)",17.100000000000001]
[null,null,null,null,null,null,null,null,"Private Passenger Auto Liability",19.2]
[null,null,null,null,null,null,null,null,"Private Passenger Auto Physical Damage",21.1]
[null,null,null,null,null,null,null,null,"Products Liability",18]
[null,null,null,null,null,null,null,null,"Products Liability (Claims-Made)",18.2]
[null,null,null,null,null,null,null,null,"Products Liability (Occurrence)",18.100000000000001]
[null,null,null,null,null,null,null,null,"Surety",24]
[null,null,null,null,null,null,null,null,"Detailed Line Description for Selected General Line"]

{"sheet":"Instructions","index":2,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Instructions for Completing the"]
["Supplemental Exposure and Premium Template"]
["for COVID Impacted Lines"]
[]
[null,"The Supplemental Exposure and Premium Template is required for the lines of insurance impacted by the COVID-19 pandemic as referenced in the Bulletin 2020-3."]
[null,"http://www.insurance.ca.gov/0250-insurers/0300-insurers/0200-bulletins/bulletin-notices-commiss-opinion/upload/Bulletin_2020-3_re_covid-19_premium_reductions-2.pdf"]
[null,"Note:  For information on populating the application in its entirety, including the Prior Approval Rate Application, Prior Approval Rate Template, Standard Exhibits Template, and Supplemental Quarterly Development Template, refer to the complete Prior Approval Rate Filing Instructions posted in PDF format on the CDI website, below:"]
[null,"http://www.insurance.ca.gov/0250-insurers/0800-rate-filings/"]
[]
["1)","The Supplemental Exposure and Premium Template is required to be completed for each coverage (e.g., BI, PD, MP, UM, COLL, COMP, etc.) or program (e.g., Auto Dealers, Garagekeepers, Truckers/Motor Carriers, etc.) separately identified in the Prior Approval Rate Template.  For each new filing submitted, download a new template - do not \"recycle\" a template from a previously approved filing."]
["2)","All data on \"2.Exp_Prem\" must be submitted. Written premium should be submitted gross of the COVID refund while earned premium should be submitted net of the COVID refund. The COVID refund is the actual premium refunded or credited, and should exclude any normal dividend.   "]
["3)","Areas of insurer input are generally identified with blue font text and/or light blue outlined boxes. "]
["4)","In addition to identifying the coverage, forms or programs included in this template, enter the insurer information common to all coverages in the \"1.General\" page, including, but not limited to: Company Name; General Line; and Most Recent Fiscal Period."]
["5)","The coverages/forms/programs must be in the same order as in the Prior Approval Rate Template and Standard Exhibits Template."]
["6)","Refer to the complete Prior Approval Rate Filing Instructions for additional information."]

{"sheet":"1.General","index":3,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[11,2,11,5]]}
["State of California",null,null,null,null,"Company:",{"$f":"Co_Name","v":""},null,"Error Messages, if Any, Associated with General to the Left"]
["Department of Insurance (CDI)",null,null,null,null,"Line:",{"$f":"General_Line","v":0},null,"(DEPARTMENT USE ONLY)"]
[]
[]
["Supplemental Exposure and Premium Template for COVID Impacted Lines"]
["GENERAL INFORMATION"]
[]
["Completed by:",null,"Date:"]
[]
["CDI File # (Department Use Only):"]
[]
["Company Name:"]
[]
["Line Type:"]
[]
["General Line :",null,null,null,null,null,null,null,{"$f":"IF(INDEX(List_GeneralLine,References!$F$5,1)=\"\",\"← ERROR! Select a General Line from the pull-down menu.\",\"\")","v":"← ERROR! Select a General Line from the pull-down menu."}]
[]
["Detailed Line Description(s)",null,"Coverage/Form/Program"]
["(Enter name of each coverage/form/program included in this application. Otherwise, enter a blank. Do not skip coverages."]
[]
[{"$f":"IF(INDEX(List_DetailLine,References!Q6,1)=\"\",\"\",INDEX(List_DetailLine,References!Q6,1))","v":""},null,null,{"$f":"IF(OR(Covg01=\"NA\",Covg01=\"N/A\",Covg01=\"\"),\"\",1)","v":""},null,null,null,null,{"$f":"IF(AND(Covg01<>\"\",$A21=\"\"),\"← ERROR! Select a Detailed Line Description.\",IF(AND($A21<>\"\",Covg01=\"\"),\"← ERROR! Select a Coverage/Form/Program.\",\"\"))","v":""}]
[{"$f":"IF(INDEX(List_DetailLine,References!Q7,1)=\"\",\"\",INDEX(List_DetailLine,References!Q7,1))","v":""},null,null,{"$f":"IF(OR(Covg02=\"NA\",Covg02=\"N/A\",Covg02=\"\"),\"\",1)","v":""},null,null,null,null,{"$f":"IF(AND(Covg02<>\"\",$A22=\"\"),\"← ERROR! Select a Detailed Line Description.\",IF(AND($A22<>\"\",Covg02=\"\"),\"← ERROR! Select a Coverage/Form/Program.\",\"\"))","v":""}]
[{"$f":"IF(INDEX(List_DetailLine,References!Q8,1)=\"\",\"\",INDEX(List_DetailLine,References!Q8,1))","v":""},null,null,{"$f":"IF(OR(Covg03=\"NA\",Covg03=\"N/A\",Covg03=\"\"),\"\",1)","v":""},null,null,null,null,{"$f":"IF(AND(Covg03<>\"\",$A23=\"\"),\"← ERROR! Select a Detailed Line Description.\",IF(AND($A23<>\"\",Covg03=\"\"),\"← ERROR! Select a Coverage/Form/Program.\",\"\"))","v":""}]
[{"$f":"IF(INDEX(List_DetailLine,References!Q9,1)=\"\",\"\",INDEX(List_DetailLine,References!Q9,1))","v":""},null,null,{"$f":"IF(OR(Covg04=\"NA\",Covg04=\"N/A\",Covg04=\"\"),\"\",1)","v":""},null,null,null,null,{"$f":"IF(AND(Covg04<>\"\",$A24=\"\"),\"← ERROR! Select a Detailed Line Description.\",IF(AND($A24<>\"\",Covg04=\"\"),\"← ERROR! Select a Coverage/Form/Program.\",\"\"))","v":""}]
[{"$f":"IF(INDEX(List_DetailLine,References!Q10,1)=\"\",\"\",INDEX(List_DetailLine,References!Q10,1))","v":""},null,null,{"$f":"IF(OR(Covg05=\"NA\",Covg05=\"N/A\",Covg05=\"\"),\"\",1)","v":""},null,null,null,null,{"$f":"IF(AND(Covg05<>\"\",$A25=\"\"),\"← ERROR! Select a Detailed Line Description.\",IF(AND($A25<>\"\",Covg05=\"\"),\"← ERROR! Select a Coverage/Form/Program.\",\"\"))","v":""}]
[{"$f":"IF(INDEX(List_DetailLine,References!Q11,1)=\"\",\"\",INDEX(List_DetailLine,References!Q11,1))","v":""},null,null,{"$f":"IF(OR(Covg06=\"NA\",Covg06=\"N/A\",Covg06=\"\"),\"\",1)","v":""},null,null,null,null,{"$f":"IF(AND(Covg06<>\"\",$A26=\"\"),\"← ERROR! Select a Detailed Line Description.\",IF(AND($A26<>\"\",Covg06=\"\"),\"← ERROR! Select a Coverage/Form/Program.\",\"\"))","v":""}]
[{"$f":"IF(INDEX(List_DetailLine,References!Q12,1)=\"\",\"\",INDEX(List_DetailLine,References!Q12,1))","v":""},null,null,{"$f":"IF(OR(Covg07=\"NA\",Covg07=\"N/A\",Covg07=\"\"),\"\",1)","v":""},null,null,null,null,{"$f":"IF(AND(Covg07<>\"\",$A27=\"\"),\"← ERROR! Select a Detailed Line Description.\",IF(AND($A27<>\"\",Covg07=\"\"),\"← ERROR! Select a Coverage/Form/Program.\",\"\"))","v":""}]
[{"$f":"IF(INDEX(List_DetailLine,References!Q13,1)=\"\",\"\",INDEX(List_DetailLine,References!Q13,1))","v":""},null,null,{"$f":"IF(OR(Covg08=\"NA\",Covg08=\"N/A\",Covg08=\"\"),\"\",1)","v":""},null,null,null,null,{"$f":"IF(AND(Covg08<>\"\",$A28=\"\"),\"← ERROR! Select a Detailed Line Description.\",IF(AND($A28<>\"\",Covg08=\"\"),\"← ERROR! Select a Coverage/Form/Program.\",\"\"))","v":""}]
[{"$f":"IF(INDEX(List_DetailLine,References!Q14,1)=\"\",\"\",INDEX(List_DetailLine,References!Q14,1))","v":""},null,null,{"$f":"IF(OR(Covg09=\"NA\",Covg09=\"N/A\",Covg09=\"\"),\"\",1)","v":""},null,null,null,null,{"$f":"IF(AND(Covg09<>\"\",$A29=\"\"),\"← ERROR! Select a Detailed Line Description.\",IF(AND($A29<>\"\",Covg09=\"\"),\"← ERROR! Select a Coverage/Form/Program.\",\"\"))","v":""}]
[{"$f":"IF(INDEX(List_DetailLine,References!Q15,1)=\"\",\"\",INDEX(List_DetailLine,References!Q15,1))","v":""},null,null,{"$f":"IF(OR(Covg10=\"NA\",Covg10=\"N/A\",Covg10=\"\"),\"\",1)","v":""},null,null,null,null,{"$f":"IF(AND(Covg10<>\"\",$A30=\"\"),\"← ERROR! Select a Detailed Line Description.\",IF(AND($A30<>\"\",Covg10=\"\"),\"← ERROR! Select a Coverage/Form/Program.\",\"\"))","v":""}]
[null,null,null,{"$f":"SUM(D21:D30)","v":0}]
["Most Recent Fiscal Period (Enter in YYYYQ format.)",null,20204,null,null,null,null,null,{"$f":"IF(OR(AND(RIGHT(FYQtr,1)<>\"1\",RIGHT(FYQtr,1)<>\"2\",RIGHT(FYQtr,1)<>\"3\",RIGHT(FYQtr,1)<>\"4\"),LEFT(FYQtr,4)<\"2013\",LEFT(FYQtr,4)>\"2025\",LEN(FYQtr)<>5),\"← ERROR! Enter the most recent fiscal period in YYYYQ format.\",\"\")","v":""}]
[]
[]
["Select Exhibits to Print"]

{"sheet":"2.Exp_Prem","index":4,"n_rows":50,"n_cols":91,"rows_kept":50,"cut":false,"hidden":false,"merged":[[6,57,6,63],[6,66,6,72],[6,75,6,81],[6,84,6,90],[6,3,6,9],[6,12,6,18],[6,21,6,27],[6,30,6,36],[6,39,6,45],[6,48,6,54]]}
[]
[null,"Exposure and Premium",null,null,null,null,null,null,null,null,"Exposure and Premium",null,null,null,null,null,null,null,null,"Exposure and Premium",null,null,null,null,null,null,null,null,"Exposure and Premium",null,null,null,null,null,null,null,null,"Exposure and Premium",null,null,null,null,null,null,null,null,"Exposure and Premium",null,null,null,null,null,null,null,null,"Exposure and Premium",null,null,null,null,null,null,null,null,"Exposure and Premium",null,null,null,null,null,null,null,null,"Exposure and Premium",null,null,null,null,null,null,null,null,"Exposure and Premium"]
[null,"California Company-Specific Premium Trend Data",null,null,null,null,null,null,null,null,"California Company-Specific Premium Trend Data",null,null,null,null,null,null,null,null,"California Company-Specific Premium Trend Data",null,null,null,null,null,null,null,null,"California Company-Specific Premium Trend Data",null,null,null,null,null,null,null,null,"California Company-Specific Premium Trend Data",null,null,null,null,null,null,null,null,"California Company-Specific Premium Trend Data",null,null,null,null,null,null,null,null,"California Company-Specific Premium Trend Data",null,null,null,null,null,null,null,null,"California Company-Specific Premium Trend Data",null,null,null,null,null,null,null,null,"California Company-Specific Premium Trend Data",null,null,null,null,null,null,null,null,"California Company-Specific Premium Trend Data"]
[null,{"$f":"Covg01","v":0},null,null,null,null,null,null,null,null,{"$f":"Covg02","v":0},null,null,null,null,null,null,null,null,{"$f":"Covg03","v":0},null,null,null,null,null,null,null,null,{"$f":"Covg04","v":0},null,null,null,null,null,null,null,null,{"$f":"Covg05","v":0},null,null,null,null,null,null,null,null,{"$f":"Covg06","v":0},null,null,null,null,null,null,null,null,{"$f":"Covg07","v":0},null,null,null,null,null,null,null,null,{"$f":"Covg08","v":0},null,null,null,null,null,null,null,null,{"$f":"Covg09","v":0},null,null,null,null,null,null,null,null,{"$f":"Covg10","v":0}]
[null,null,null,{"$f":"IF(COUNTIF(D9:D48,0)=0,\"\",\"For calendar quarters where business was not being written and there are no exposures, enter blank cells rather than cells containing zero.\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(M9:M48,0)=0,\"\",\"For calendar quarters where business was not being written and there are no exposures, enter blank cells rather than cells containing zero.\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(V9:V48,0)=0,\"\",\"For calendar quarters where business was not being written and there are no exposures, enter blank cells rather than cells containing zero.\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AE9:AE48,0)=0,\"\",\"For calendar quarters where business was not being written and there are no exposures, enter blank cells rather than cells containing zero.\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AN9:AN48,0)=0,\"\",\"For calendar quarters where business was not being written and there are no exposures, enter blank cells rather than cells containing zero.\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AW9:AW48,0)=0,\"\",\"For calendar quarters where business was not being written and there are no exposures, enter blank cells rather than cells containing zero.\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(BF9:BF48,0)=0,\"\",\"For calendar quarters where business was not being written and there are no exposures, enter blank cells rather than cells containing zero.\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(BO9:BO48,0)=0,\"\",\"For calendar quarters where business was not being written and there are no exposures, enter blank cells rather than cells containing zero.\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(BX9:BX48,0)=0,\"\",\"For calendar quarters where business was not being written and there are no exposures, enter blank cells rather than cells containing zero.\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(CG9:CG48,0)=0,\"\",\"For calendar quarters where business was not being written and there are no exposures, enter blank cells rather than cells containing zero.\")","v":""}]
[]
[null,null,null,"Quarterly Data",null,null,null,null,null,null,null,null,"Quarterly Data",null,null,null,null,null,null,null,null,"Quarterly Data",null,null,null,null,null,null,null,null,"Quarterly Data",null,null,null,null,null,null,null,null,"Quarterly Data",null,null,null,null,null,null,null,null,"Quarterly Data",null,null,null,null,null,null,null,null,"Quarterly Data",null,null,null,null,null,null,null,null,"Quarterly Data",null,null,null,null,null,null,null,null,"Quarterly Data",null,null,null,null,null,null,null,null,"Quarterly Data"]
[null,"Calendar YYYYQ",null,"Written Exposures","Written Premium","On-Level Written Premium","Earned Exposures","Earned Premium1","On-Level Earned Premium1","COVID Refund","Calendar YYYYQ",null,"Written Exposures","Written Premium","On-Level Written Premium","Earned Exposures","Earned Premium1","On-Level Earned Premium1","COVID Refund","Calendar YYYYQ",null,"Written Exposures","Written Premium","On-Level Written Premium","Earned Exposures","Earned Premium1","On-Level Earned Premium1","COVID Refund","Calendar YYYYQ",null,"Written Exposures","Written Premium","On-Level Written Premium","Earned Exposures","Earned Premium1","On-Level Earned Premium1","COVID Refund","Calendar YYYYQ",null,"Written Exposures","Written Premium","On-Level Written Premium","Earned Exposures","Earned Premium1","On-Level Earned Premium1","COVID Refund","Calendar YYYYQ",null,"Written Exposures","Written Premium","On-Level Written Premium","Earned Exposures","Earned Premium1","On-Level Earned Premium1","COVID Refund","Calendar YYYYQ",null,"Written Exposures","Written Premium","On-Level Written Premium","Earned Exposures","Earned Premium1","On-Level Earned Premium1","COVID Refund","Calendar YYYYQ",null,"Written Exposures","Written Premium","On-Level Written Premium","Earned Exposures","Earned Premium1","On-Level Earned Premium1","COVID Refund","Calendar YYYYQ",null,"Written Exposures","Written Premium","On-Level Written Premium","Earned Exposures","Earned Premium1","On-Level Earned Premium1","COVID Refund","Calendar YYYYQ",null,"Written Exposures","Written Premium","On-Level Written Premium","Earned Exposures","Earned Premium1","On-Level Earned Premium1","COVID Refund"]
[1,{"$f":"IF(RIGHT(B10,1)=\"1\",B10-7,B10-1)","v":20111},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(K10,1)=\"1\",K10-7,K10-1)","v":20111},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(T10,1)=\"1\",T10-7,T10-1)","v":20111},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(AC10,1)=\"1\",AC10-7,AC10-1)","v":20111},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(AL10,1)=\"1\",AL10-7,AL10-1)","v":20111},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(AU10,1)=\"1\",AU10-7,AU10-1)","v":20111},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(BD10,1)=\"1\",BD10-7,BD10-1)","v":20111},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(BM10,1)=\"1\",BM10-7,BM10-1)","v":20111},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(BV10,1)=\"1\",BV10-7,BV10-1)","v":20111},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(CE10,1)=\"1\",CE10-7,CE10-1)","v":20111}]
[2,20112,null,null,null,null,null,null,null,null,20112,null,null,null,null,null,null,null,null,20112,null,null,null,null,null,null,null,null,20112,null,null,null,null,null,null,null,null,20112,null,null,null,null,null,null,null,null,20112,null,null,null,null,null,null,null,null,20112,null,null,null,null,null,null,null,null,20112,null,null,null,null,null,null,null,null,20112,null,null,null,null,null,null,null,null,20112]
[3,20113,null,null,null,null,null,null,null,null,20113,null,null,null,null,null,null,null,null,20113,null,null,null,null,null,null,null,null,20113,null,null,null,null,null,null,null,null,20113,null,null,null,null,null,null,null,null,20113,null,null,null,null,null,null,null,null,20113,null,null,null,null,null,null,null,null,20113,null,null,null,null,null,null,null,null,20113,null,null,null,null,null,null,null,null,20113]
[4,20114,null,null,null,null,null,null,null,null,20114,null,null,null,null,null,null,null,null,20114,null,null,null,null,null,null,null,null,20114,null,null,null,null,null,null,null,null,20114,null,null,null,null,null,null,null,null,20114,null,null,null,null,null,null,null,null,20114,null,null,null,null,null,null,null,null,20114,null,null,null,null,null,null,null,null,20114,null,null,null,null,null,null,null,null,20114]
[5,20121,null,null,null,null,null,null,null,null,20121,null,null,null,null,null,null,null,null,20121,null,null,null,null,null,null,null,null,20121,null,null,null,null,null,null,null,null,20121,null,null,null,null,null,null,null,null,20121,null,null,null,null,null,null,null,null,20121,null,null,null,null,null,null,null,null,20121,null,null,null,null,null,null,null,null,20121,null,null,null,null,null,null,null,null,20121]
[6,20122,null,null,null,null,null,null,null,null,20122,null,null,null,null,null,null,null,null,20122,null,null,null,null,null,null,null,null,20122,null,null,null,null,null,null,null,null,20122,null,null,null,null,null,null,null,null,20122,null,null,null,null,null,null,null,null,20122,null,null,null,null,null,null,null,null,20122,null,null,null,null,null,null,null,null,20122,null,null,null,null,null,null,null,null,20122]
[null,20123,null,null,null,null,null,null,null,null,20123,null,null,null,null,null,null,null,null,20123,null,null,null,null,null,null,null,null,20123,null,null,null,null,null,null,null,null,20123,null,null,null,null,null,null,null,null,20123,null,null,null,null,null,null,null,null,20123,null,null,null,null,null,null,null,null,20123,null,null,null,null,null,null,null,null,20123,null,null,null,null,null,null,null,null,20123]
[null,20124,null,null,null,null,null,null,null,null,20124,null,null,null,null,null,null,null,null,20124,null,null,null,null,null,null,null,null,20124,null,null,null,null,null,null,null,null,20124,null,null,null,null,null,null,null,null,20124,null,null,null,null,null,null,null,null,20124,null,null,null,null,null,null,null,null,20124,null,null,null,null,null,null,null,null,20124,null,null,null,null,null,null,null,null,20124]
[null,20131,null,null,null,null,null,null,null,null,20131,null,null,null,null,null,null,null,null,20131,null,null,null,null,null,null,null,null,20131,null,null,null,null,null,null,null,null,20131,null,null,null,null,null,null,null,null,20131,null,null,null,null,null,null,null,null,20131,null,null,null,null,null,null,null,null,20131,null,null,null,null,null,null,null,null,20131,null,null,null,null,null,null,null,null,20131]
[null,20132,null,null,null,null,null,null,null,null,20132,null,null,null,null,null,null,null,null,20132,null,null,null,null,null,null,null,null,20132,null,null,null,null,null,null,null,null,20132,null,null,null,null,null,null,null,null,20132,null,null,null,null,null,null,null,null,20132,null,null,null,null,null,null,null,null,20132,null,null,null,null,null,null,null,null,20132,null,null,null,null,null,null,null,null,20132]
[null,20133,null,null,null,null,null,null,null,null,20133,null,null,null,null,null,null,null,null,20133,null,null,null,null,null,null,null,null,20133,null,null,null,null,null,null,null,null,20133,null,null,null,null,null,null,null,null,20133,null,null,null,null,null,null,null,null,20133,null,null,null,null,null,null,null,null,20133,null,null,null,null,null,null,null,null,20133,null,null,null,null,null,null,null,null,20133]
[null,20134,null,null,null,null,null,null,null,null,20134,null,null,null,null,null,null,null,null,20134,null,null,null,null,null,null,null,null,20134,null,null,null,null,null,null,null,null,20134,null,null,null,null,null,null,null,null,20134,null,null,null,null,null,null,null,null,20134,null,null,null,null,null,null,null,null,20134,null,null,null,null,null,null,null,null,20134,null,null,null,null,null,null,null,null,20134]
[null,20141,null,null,null,null,null,null,null,null,20141,null,null,null,null,null,null,null,null,20141,null,null,null,null,null,null,null,null,20141,null,null,null,null,null,null,null,null,20141,null,null,null,null,null,null,null,null,20141,null,null,null,null,null,null,null,null,20141,null,null,null,null,null,null,null,null,20141,null,null,null,null,null,null,null,null,20141,null,null,null,null,null,null,null,null,20141]
[null,20142,null,null,null,null,null,null,null,null,20142,null,null,null,null,null,null,null,null,20142,null,null,null,null,null,null,null,null,20142,null,null,null,null,null,null,null,null,20142,null,null,null,null,null,null,null,null,20142,null,null,null,null,null,null,null,null,20142,null,null,null,null,null,null,null,null,20142,null,null,null,null,null,null,null,null,20142,null,null,null,null,null,null,null,null,20142]
[null,20143,null,null,null,null,null,null,null,null,20143,null,null,null,null,null,null,null,null,20143,null,null,null,null,null,null,null,null,20143,null,null,null,null,null,null,null,null,20143,null,null,null,null,null,null,null,null,20143,null,null,null,null,null,null,null,null,20143,null,null,null,null,null,null,null,null,20143,null,null,null,null,null,null,null,null,20143,null,null,null,null,null,null,null,null,20143]
[null,20144,null,null,null,null,null,null,null,null,20144,null,null,null,null,null,null,null,null,20144,null,null,null,null,null,null,null,null,20144,null,null,null,null,null,null,null,null,20144,null,null,null,null,null,null,null,null,20144,null,null,null,null,null,null,null,null,20144,null,null,null,null,null,null,null,null,20144,null,null,null,null,null,null,null,null,20144,null,null,null,null,null,null,null,null,20144]
[null,20151,null,null,null,null,null,null,null,null,20151,null,null,null,null,null,null,null,null,20151,null,null,null,null,null,null,null,null,20151,null,null,null,null,null,null,null,null,20151,null,null,null,null,null,null,null,null,20151,null,null,null,null,null,null,null,null,20151,null,null,null,null,null,null,null,null,20151,null,null,null,null,null,null,null,null,20151,null,null,null,null,null,null,null,null,20151]
[null,20152,null,null,null,null,null,null,null,null,20152,null,null,null,null,null,null,null,null,20152,null,null,null,null,null,null,null,null,20152,null,null,null,null,null,null,null,null,20152,null,null,null,null,null,null,null,null,20152,null,null,null,null,null,null,null,null,20152,null,null,null,null,null,null,null,null,20152,null,null,null,null,null,null,null,null,20152,null,null,null,null,null,null,null,null,20152]
[null,20153,null,null,null,null,null,null,null,null,20153,null,null,null,null,null,null,null,null,20153,null,null,null,null,null,null,null,null,20153,null,null,null,null,null,null,null,null,20153,null,null,null,null,null,null,null,null,20153,null,null,null,null,null,null,null,null,20153,null,null,null,null,null,null,null,null,20153,null,null,null,null,null,null,null,null,20153,null,null,null,null,null,null,null,null,20153]
[7,20154,null,null,null,null,null,null,null,null,20154,null,null,null,null,null,null,null,null,20154,null,null,null,null,null,null,null,null,20154,null,null,null,null,null,null,null,null,20154,null,null,null,null,null,null,null,null,20154,null,null,null,null,null,null,null,null,20154,null,null,null,null,null,null,null,null,20154,null,null,null,null,null,null,null,null,20154,null,null,null,null,null,null,null,null,20154]
[8,20161,null,null,null,null,null,null,null,null,20161,null,null,null,null,null,null,null,null,20161,null,null,null,null,null,null,null,null,20161,null,null,null,null,null,null,null,null,20161,null,null,null,null,null,null,null,null,20161,null,null,null,null,null,null,null,null,20161,null,null,null,null,null,null,null,null,20161,null,null,null,null,null,null,null,null,20161,null,null,null,null,null,null,null,null,20161]
[9,20162,null,null,null,null,null,null,null,null,20162,null,null,null,null,null,null,null,null,20162,null,null,null,null,null,null,null,null,20162,null,null,null,null,null,null,null,null,20162,null,null,null,null,null,null,null,null,20162,null,null,null,null,null,null,null,null,20162,null,null,null,null,null,null,null,null,20162,null,null,null,null,null,null,null,null,20162,null,null,null,null,null,null,null,null,20162]
[10,20163,null,null,null,null,null,null,null,null,20163,null,null,null,null,null,null,null,null,20163,null,null,null,null,null,null,null,null,20163,null,null,null,null,null,null,null,null,20163,null,null,null,null,null,null,null,null,20163,null,null,null,null,null,null,null,null,20163,null,null,null,null,null,null,null,null,20163,null,null,null,null,null,null,null,null,20163,null,null,null,null,null,null,null,null,20163]
[11,20164,null,null,null,null,null,null,null,null,20164,null,null,null,null,null,null,null,null,20164,null,null,null,null,null,null,null,null,20164,null,null,null,null,null,null,null,null,20164,null,null,null,null,null,null,null,null,20164,null,null,null,null,null,null,null,null,20164,null,null,null,null,null,null,null,null,20164,null,null,null,null,null,null,null,null,20164,null,null,null,null,null,null,null,null,20164]
[12,20171,null,null,null,null,null,null,null,null,20171,null,null,null,null,null,null,null,null,20171,null,null,null,null,null,null,null,null,20171,null,null,null,null,null,null,null,null,20171,null,null,null,null,null,null,null,null,20171,null,null,null,null,null,null,null,null,20171,null,null,null,null,null,null,null,null,20171,null,null,null,null,null,null,null,null,20171,null,null,null,null,null,null,null,null,20171]
[13,20172,null,null,null,null,null,null,null,null,20172,null,null,null,null,null,null,null,null,20172,null,null,null,null,null,null,null,null,20172,null,null,null,null,null,null,null,null,20172,null,null,null,null,null,null,null,null,20172,null,null,null,null,null,null,null,null,20172,null,null,null,null,null,null,null,null,20172,null,null,null,null,null,null,null,null,20172,null,null,null,null,null,null,null,null,20172]
[14,20173,null,null,null,null,null,null,null,null,20173,null,null,null,null,null,null,null,null,20173,null,null,null,null,null,null,null,null,20173,null,null,null,null,null,null,null,null,20173,null,null,null,null,null,null,null,null,20173,null,null,null,null,null,null,null,null,20173,null,null,null,null,null,null,null,null,20173,null,null,null,null,null,null,null,null,20173,null,null,null,null,null,null,null,null,20173]
[15,20174,null,null,null,null,null,null,null,null,20174,null,null,null,null,null,null,null,null,20174,null,null,null,null,null,null,null,null,20174,null,null,null,null,null,null,null,null,20174,null,null,null,null,null,null,null,null,20174,null,null,null,null,null,null,null,null,20174,null,null,null,null,null,null,null,null,20174,null,null,null,null,null,null,null,null,20174,null,null,null,null,null,null,null,null,20174]
[16,20181,null,null,null,null,null,null,null,null,20181,null,null,null,null,null,null,null,null,20181,null,null,null,null,null,null,null,null,20181,null,null,null,null,null,null,null,null,20181,null,null,null,null,null,null,null,null,20181,null,null,null,null,null,null,null,null,20181,null,null,null,null,null,null,null,null,20181,null,null,null,null,null,null,null,null,20181,null,null,null,null,null,null,null,null,20181]
[17,20182,null,null,null,null,null,null,null,null,20182,null,null,null,null,null,null,null,null,20182,null,null,null,null,null,null,null,null,20182,null,null,null,null,null,null,null,null,20182,null,null,null,null,null,null,null,null,20182,null,null,null,null,null,null,null,null,20182,null,null,null,null,null,null,null,null,20182,null,null,null,null,null,null,null,null,20182,null,null,null,null,null,null,null,null,20182]
[18,20183,null,null,null,null,null,null,null,null,20183,null,null,null,null,null,null,null,null,20183,null,null,null,null,null,null,null,null,20183,null,null,null,null,null,null,null,null,20183,null,null,null,null,null,null,null,null,20183,null,null,null,null,null,null,null,null,20183,null,null,null,null,null,null,null,null,20183,null,null,null,null,null,null,null,null,20183,null,null,null,null,null,null,null,null,20183]
[19,20184,null,null,null,null,null,null,null,null,20184,null,null,null,null,null,null,null,null,20184,null,null,null,null,null,null,null,null,20184,null,null,null,null,null,null,null,null,20184,null,null,null,null,null,null,null,null,20184,null,null,null,null,null,null,null,null,20184,null,null,null,null,null,null,null,null,20184,null,null,null,null,null,null,null,null,20184,null,null,null,null,null,null,null,null,20184]
[20,20191,null,null,null,null,null,null,null,null,20191,null,null,null,null,null,null,null,null,20191,null,null,null,null,null,null,null,null,20191,null,null,null,null,null,null,null,null,20191,null,null,null,null,null,null,null,null,20191,null,null,null,null,null,null,null,null,20191,null,null,null,null,null,null,null,null,20191,null,null,null,null,null,null,null,null,20191,null,null,null,null,null,null,null,null,20191]
[21,20192,null,null,null,null,null,null,null,null,20192,null,null,null,null,null,null,null,null,20192,null,null,null,null,null,null,null,null,20192,null,null,null,null,null,null,null,null,20192,null,null,null,null,null,null,null,null,20192,null,null,null,null,null,null,null,null,20192,null,null,null,null,null,null,null,null,20192,null,null,null,null,null,null,null,null,20192,null,null,null,null,null,null,null,null,20192]
[22,20193,null,null,null,null,null,null,null,null,20193,null,null,null,null,null,null,null,null,20193,null,null,null,null,null,null,null,null,20193,null,null,null,null,null,null,null,null,20193,null,null,null,null,null,null,null,null,20193,null,null,null,null,null,null,null,null,20193,null,null,null,null,null,null,null,null,20193,null,null,null,null,null,null,null,null,20193,null,null,null,null,null,null,null,null,20193]
[23,20194,null,null,null,null,null,null,null,null,20194,null,null,null,null,null,null,null,null,20194,null,null,null,null,null,null,null,null,20194,null,null,null,null,null,null,null,null,20194,null,null,null,null,null,null,null,null,20194,null,null,null,null,null,null,null,null,20194,null,null,null,null,null,null,null,null,20194,null,null,null,null,null,null,null,null,20194,null,null,null,null,null,null,null,null,20194]
[24,20201,null,null,null,null,null,null,null,null,20201,null,null,null,null,null,null,null,null,20201,null,null,null,null,null,null,null,null,20201,null,null,null,null,null,null,null,null,20201,null,null,null,null,null,null,null,null,20201,null,null,null,null,null,null,null,null,20201,null,null,null,null,null,null,null,null,20201,null,null,null,null,null,null,null,null,20201,null,null,null,null,null,null,null,null,20201]
[25,20202,null,null,null,null,null,null,null,null,20202,null,null,null,null,null,null,null,null,20202,null,null,null,null,null,null,null,null,20202,null,null,null,null,null,null,null,null,20202,null,null,null,null,null,null,null,null,20202,null,null,null,null,null,null,null,null,20202,null,null,null,null,null,null,null,null,20202,null,null,null,null,null,null,null,null,20202,null,null,null,null,null,null,null,null,20202]
[26,{"$f":"IF(RIGHT(B48,1)=\"1\",B48-7,B48-1)","v":20203},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(K48,1)=\"1\",K48-7,K48-1)","v":20203},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(T48,1)=\"1\",T48-7,T48-1)","v":20203},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(AC48,1)=\"1\",AC48-7,AC48-1)","v":20203},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(AL48,1)=\"1\",AL48-7,AL48-1)","v":20203},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(AU48,1)=\"1\",AU48-7,AU48-1)","v":20203},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(BD48,1)=\"1\",BD48-7,BD48-1)","v":20203},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(BM48,1)=\"1\",BM48-7,BM48-1)","v":20203},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(BV48,1)=\"1\",BV48-7,BV48-1)","v":20203},null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(CE48,1)=\"1\",CE48-7,CE48-1)","v":20203}]
[27,{"$f":"FYQtr","v":20204},null,null,null,null,null,null,null,null,{"$f":"$B$48","v":20204},null,null,null,null,null,null,null,null,{"$f":"$B$48","v":20204},null,null,null,null,null,null,null,null,{"$f":"$B$48","v":20204},null,null,null,null,null,null,null,null,{"$f":"$B$48","v":20204},null,null,null,null,null,null,null,null,{"$f":"$B$48","v":20204},null,null,null,null,null,null,null,null,{"$f":"$B$48","v":20204},null,null,null,null,null,null,null,null,{"$f":"$B$48","v":20204},null,null,null,null,null,null,null,null,{"$f":"$B$48","v":20204},null,null,null,null,null,null,null,null,{"$f":"$B$48","v":20204}]
[]
[null,null,null,"1 Earned Premiums are net of COVID Refund",null,null,null,null,null,null,null,null,"1 Earned Premiums are net of COVID Refund",null,null,null,null,null,null,null,null,"1 Earned Premiums are net of COVID Refund",null,null,null,null,null,null,null,null,"1 Earned Premiums are net of COVID Refund",null,null,null,null,null,null,null,null,"1 Earned Premiums are net of COVID Refund",null,null,null,null,null,null,null,null,"1 Earned Premiums are net of COVID Refund",null,null,null,null,null,null,null,null,"1 Earned Premiums are net of COVID Refund",null,null,null,null,null,null,null,null,"1 Earned Premiums are net of COVID Refund",null,null,null,null,null,null,null,null,"1 Earned Premiums are net of COVID Refund",null,null,null,null,null,null,null,null,"1 Earned Premiums are net of COVID Refund"]