{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Input","InputYear2","2024 & 2025 Assessment","CalculationYear2","Keys"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Instructions","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"This template is intended to reconcile the Temporary Supplemental Fee (TSF) Recoupment in year 1. If the company plans to modify the recoupment %, please select \"Yes\" in question D in the \"Input\" Tab"]
[]
[null,"Please provide the following information within the \"Input\" tab:"]
[null,0,"This Template is intended for updating Temporary Supplemental Fee (TSF) Recoupment in year 2 for a 2-year recoupment period. If the company has a one year recoupment period, this template is not applicable."]
[null,1,"The company group name in cell E1. If company is not part of a group, please input the company name."]
[null,2,"All relevant company information above table A."]
[null,3,"Complete table A; the \"Total\" row is calculated automatically."]
[null,4,"Item B, the line of business in cell D25. NOTE: If the company needs to recoup from both personal and commercial lines, the company would need to complete two separate templates. Cell G25 is calculated automatically."]
[null,6,"Complete table D; the \"Total\" row is calculated automatically."]
[null,7,"Table A, \"Total Recoupment Amount\" Column is automatically calculated. "]
[null,8,"If you have a two year recoupment period, and plan to update the recoupment % for year 2, please select \"Two\" in D27, and \"Yes\" in D29"]
[]
[null,"Please provide the following information within the \"InputYear2\" :"]
[null,1,"The two tabs (InputYear2 and CalculationYear2) are intended for updating Temporary Supplemental Fee (TSF) Recoupment in year 2 for a 2-year recoupment period. If the company has a one year recoupment period or the company does not intend to update the recoupment %, this two tabs are not applicable."]
[null,2,"The company group name in cell E1. If company is not part of a group, please input the company name."]
[null,3,"All relevant company information above table A."]
[null,4,"Complete table A; the \"Total\" row is calculated automatically. \"Total Recoupment Amount\" colum is also calculated automatically. "]
[null,5,"Item B, the line of business in cell D25. NOTE: If the company needs to recoup from both personal and commercial lines, the company would need to complete two separate templates. Cell G25 is calculated automatically."]
[null,6,"Complete table E; the \"Total\" row is calculated automatically."]
[null,7,"Under \"Total Expected Written Premium Next Renewal Cycle\", please input expected written premium after accounting for on-leveling and expected mix changes"]
[null,"With regard to the \"CalculationYear2\" tab:"]
[null,8,"NOTE: Everything in the \"CalculationYear2\" tab is automatically populated."]
[null,9,"Any red fonts are error notifications. Please correct them accordingly. "]
[null,10,"The calculated result, recoupment as a percentage of annual WP, is displayed in cell B12 of the \"Calculation\" tab."]

{"sheet":"Input","index":1,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["State of California",null,null,"Group:"]
["Department of Insurance (CDI)"]
[]
["FAIR PLAN TEMPORARY SUPPLEMENTAL FEE TEMPLATE (Year 2)"]
["GENERAL INFORMATION"]
[]
["Completed by",null,null,"Date:"]
[]
["Prior TSF Recoup. Company File #:",null,null,"Effective Date:"]
[]
["A. Input in the Total Assessment by Company and by Line"]
["Company Name","Line of Business","NAIC Group #","NAIC #","Assessment Amount ($)","Recoup %","Amount Recouped in Year 1 ($)","Total Recoupment Amount ($)"]
[null,null,null,null,null,null,null,{"$f":"IF(E13*F13=0,\"\",E13*F13)","v":""},{"$f":"IFERROR(IF(B13=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(Input!D13,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(Input!D13,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(Input!D13,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$H$3:$H$308,MATCH(Input!D13,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},{"$f":"IF(IFERROR(ABS(I13-E13)<1000,TRUE),\"\",\"Assessment Amount does not match\")","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B14=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(Input!D14,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(Input!D14,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(Input!D14,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$H$3:$H$308,MATCH(Input!D14,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},{"$f":"IF(IFERROR(ABS(I14-E14)<1000,TRUE),\"\",\"Assessment Amount does not match\")","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B15=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(Input!D15,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(Input!D15,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(Input!D15,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(Input!D15,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B16=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(Input!D16,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(Input!D16,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(Input!D16,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(Input!D16,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B17=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(Input!D17,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(Input!D17,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(Input!D17,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(Input!D17,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B18=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(Input!D18,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(Input!D18,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(Input!D18,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(Input!D18,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B19=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(Input!D19,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(Input!D19,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(Input!D19,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(Input!D19,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B20=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(Input!D20,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(Input!D20,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(Input!D20,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(Input!D20,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B21=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(Input!D21,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(Input!D21,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(Input!D21,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(Input!D21,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B22=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(Input!D22,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(Input!D22,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(Input!D22,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(Input!D22,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
["Total",null,null,null,{"$f":"IFERROR(IF(SUM(E13:E22)=0,\"\",SUM(E13:E22)),\"\")","v":""},null,{"$f":"IFERROR(IF(SUM(G13:G22)=0,\"\",SUM(G13:G22)),\"\")","v":""},{"$f":"IFERROR(IF(SUM(H13:H22)=0,\"\",SUM(H13:H22)),\"\")","v":""}]
[]
["B. What line of business is included in the filing",null,null,null,null,null,{"$f":"IFERROR(SUMIFS($G$13:$G$22,$B$13:$B$22,$D$25),\"\")","v":0},{"$f":"IFERROR(SUMIFS($H$13:$H$22,$B$13:$B$22,$D$25),\"\")","v":0}]
[]
["C. What is your current recoupment plan, in number of years? ",null,null,null,null,{"$f":"IF(ISBLANK(D27),\"Please input recoupment time frame\",IF(H25<G25,\"There is an overage on amount recouped, please provide how you plan to refund in section E\",\"\"))","v":"Please input recoupment time frame"}]
[]
["C2. (For two year recoupment only) Would you like to update recoupment % in Year 2? ",null,null,null,null,{"$f":"IF(D29=\"Yes\", \"Please proceed forward to tab 'InputYear2'\",\"\")","v":""}]
[]
["D. Memo"]
["For companies who chose one year recoupment period, if there is over-recoupment, please provide a detailed plan on how and when you plan to provide refunds (no additional recoupment if under-recouped)."]

{"sheet":"InputYear2","index":2,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["State of California",null,null,"Group:"]
["Department of Insurance (CDI)"]
[]
["FAIR PLAN TEMPORARY SUPPLEMENTAL FEE TEMPLATE (Year 2)"]
["GENERAL INFORMATION"]
[]
["Completed by",null,null,"Date:"]
[]
["Prior TSF Recoup. Company File #:",null,null,"Effective Date:"]
[]
["A. Input in the Total Assessment by Company and by Line"]
["Company Name","Line of Business","NAIC Group #","NAIC #","Assessment Amount ($)","Recoup %","Amount Recouped in Year 1 ($)","Total Recoupment Amount ($)"]
[null,null,null,null,null,null,null,{"$f":"IF(E13*F13=0,\"\",E13*F13)","v":""},{"$f":"IFERROR(IF(B13=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(InputYear2!D13,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(InputYear2!D13,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(InputYear2!D13,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$H$3:$H$308,MATCH(InputYear2!D13,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},{"$f":"IF(IFERROR(ABS(I13-E13)<1000,TRUE),\"\",\"Assessment does not match\")","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B14=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(InputYear2!D14,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(InputYear2!D14,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(InputYear2!D14,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$H$3:$H$308,MATCH(InputYear2!D14,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B15=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(InputYear2!D15,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(InputYear2!D15,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(InputYear2!D15,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(InputYear2!D15,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B16=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(InputYear2!D16,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(InputYear2!D16,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(InputYear2!D16,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(InputYear2!D16,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B17=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(InputYear2!D17,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(InputYear2!D17,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(InputYear2!D17,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(InputYear2!D17,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B18=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(InputYear2!D18,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(InputYear2!D18,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(InputYear2!D18,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(InputYear2!D18,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B19=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(InputYear2!D19,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(InputYear2!D19,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(InputYear2!D19,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(InputYear2!D19,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B20=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(InputYear2!D20,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(InputYear2!D20,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(InputYear2!D20,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(InputYear2!D20,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B21=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(InputYear2!D21,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(InputYear2!D21,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(InputYear2!D21,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(InputYear2!D21,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IFERROR(IF(B22=\"Commercial\",INDEX('2024 & 2025 Assessment'!$I$3:$I$308,MATCH(InputYear2!D22,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$K$3:$K$308,MATCH(InputYear2!D22,'2024 & 2025 Assessment'!$A$3:$A$308,0)),INDEX('2024 & 2025 Assessment'!$J$3:$J$308,MATCH(InputYear2!D22,'2024 & 2025 Assessment'!$A$3:$A$308,0))+INDEX('2024 & 2025 Assessment'!$L$3:$L$308,MATCH(InputYear2!D22,'2024 & 2025 Assessment'!$A$3:$A$308,0))),\"\")","v":""},""]
["Total",null,null,null,{"$f":"IFERROR(IF(SUM(E13:E22)=0,\"\",SUM(E13:E22)),\"\")","v":""},null,{"$f":"IFERROR(IF(SUM(G13:G22)=0,\"\",SUM(G13:G22)),\"\")","v":""},{"$f":"IFERROR(IF(SUM(H13:H22)=0,\"\",SUM(H13:H22)),\"\")","v":""}]
[]
["B. What line of business is included in the filing",null,null,null,null,null,{"$f":"IFERROR(SUMIFS($G$13:$G$22,$B$13:$B$22,$D$25),\"\")","v":0},{"$f":"IFERROR(SUMIFS($H$13:$H$22,$B$13:$B$22,$D$25),\"\")","v":0}]
[]
["C. What is your current recoupment plan, in number of years? ",null,null,"Two",null,null,null,null,null,{"$f":"IF(ISBLANK(D27),\"Please input recoupment time frame\",\"\")","v":""}]
[]
["D. What is the Recoupment as a % of Total WP for Year 1 from prior template?"]
["     (Please include % in input)"]
[]
["E. Recoupment by Coverage/Form/Product"]
["Coverage/Form/Program","Latest Available Annual Written Premium (e.g. 2025)","Total Expected Written Premium Next Renewal Cycle","Total Expected Written Exposure Per Annum Next Renewal Cycle","Percent of Total Premium"]
[null,null,null,null,{"$f":"IF(IFERROR(C34/$C$44=0,TRUE),\"\",C34/$C$44)","v":""}]
[null,null,null,null,{"$f":"IF(IFERROR(C35/$C$44=0,TRUE),\"\",C35/$C$44)","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
["Total",{"$f":"IFERROR(IF(SUM(B34:B43)=0,\"\",SUM(B34:B43)),\"\")","v":""},{"$f":"IFERROR(IF(SUM(C34:C43)=0,\"\",SUM(C34:C43)),\"\")","v":""},{"$f":"IFERROR(IF(SUM(D34:D43)=0,\"\",SUM(D34:D43)),\"\")","v":""},{"$f":"IFERROR(IF(SUM(E34:E43)=0,\"\",SUM(E34:E43)),\"\")","v":""}]
[]
["F. Please confirm that the Coverage/Form/Program is the same as last template",null,null,null,null,{"$f":"IF(D46=\"No\",\"If answer to Question F is No, please explain in Memo why that is the case\",\"\")","v":""}]
[]
["G. Memo"]
["Please input any additional comments that you want to share. "]
["For example, if you have selected \"Other Coverage\", please specify which coverages here."]

{"sheet":"2024 & 2025 Assessment","index":3,"n_rows":324,"n_cols":13,"rows_kept":324,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,642400000,15700000,331400000,10500000,{"$f":"SUM(H1:K1)","v":1000000000}]
["NAIC #","NAIC Group #","Company Name","2024 FINAL PARTICIPATION RATE (DWELLING)","2024 FINAL PARTICIPATION RATE (COMMERCIAL)","2025 FINAL PARTICIPATION RATE DWELLING","2025 FINAL PARTICIPATION RATE - COMMERCIAL","2024 DWELLING ASSESSMENT","2024 COMMERCIAL ASSESSMENT","2025 DWELLING ASSESSMENT","2025 COMMERCIAL ASSESSMENT","Total Assessment"]
[10048,0,"Hyundai Marine & Fire Ins Co Ltd",5.0399999999999999E-5,0,7.75E-5,0,{"$f":"ROUND(D3*H$1,0)","v":32377},{"$f":"ROUND(E3*I$1,0)","v":0},{"$f":"ROUND(F3*J$1,0)","v":25684},{"$f":"ROUND(G3*K$1,0)","v":0},{"$f":"SUM(H3:K3)","v":58061}]
[10683,0,"Wawanesa Gen Ins Co",3.1495E-3,0,3.3673000000000002E-3,0,2023239,0,1115923,0,3139162]
[10830,0,"Business Alliance Ins Co",0,8.9459999999999995E-4,0,1.1728999999999999E-3,0,14045,0,12315,26360]
[11118,0,"Federated Rural Electric Ins Exch",6.8000000000000001E-6,0,1.38E-5,0,4368,0,4573,0,8941]
[11231,0,"Generali Us Branch",0,2.9999999999999999E-7,0,0,0,5,0,0,5]
[13528,0,"Brotherhood Mut Ins Co",0,5.8703999999999996E-3,0,6.3116999999999999E-3,0,92165,0,66273,158438]
[27480,0,"California Mut Ins Co",7.4499999999999995E-5,2.2491E-3,1.013E-4,3.1665E-3,47859,35311,33571,33248,149989]
[32107,0,"Sutter Ins Co",9.9999999999999995E-8,0,0,0,64,0,0,0,64]
[33499,0,"Dorinco Reins Co",2.6999999999999999E-5,0,2.7100000000000001E-5,0,17345,0,8981,0,26326]
[37800,0,"Kookmin Best Ins Co Ltd",0,1.1903E-3,0,0,0,18688,0,0,18688]
[38300,0,"Samsung Fire & Marine Ins Co Ltd",0,9.9000000000000001E-6,0,5.9000000000000003E-6,0,155,0,62,217]
[39861,0,"Golden Bear Ins Co",8.2160000000000002E-4,3.2523999999999999E-3,4.7800000000000002E-4,0,527796,51063,158409,0,737268]
[40975,0,"Dentists Ins Co",0,4.9781000000000001E-3,0,5.4364000000000001E-3,0,78156,0,57082,135238]
[41459,0,"Armed Forces Ins Exch",2.496E-4,0,2.2020000000000001E-4,0,160343,0,72974,0,233317]
[13935,7,"Federated Mut Ins Co",1.2022000000000001E-3,1.2486000000000001E-3,1.4128999999999999E-3,1.7124E-3,772293,19603,468235,17980,1278111]
[28304,7,"Federated Serv Ins Co",1.7000000000000001E-4,0,1.9799999999999999E-4,0,109208,0,65617,0,174825]
[10358,8,"Encompass Ins Co",2.7271999999999999E-3,0,3.1307000000000001E-3,0,1751953,0,1037514,0,2789467]
[16217,8,"National Farmers Union Prop & Cas",0,1.496E-4,0,1.95E-5,0,2349,0,205,2554]
[19232,8,"Allstate Ins Co",3.8143000000000003E-2,1.44403E-2,3.20895E-2,1.1592E-2,{"$f":"ROUND(D21*H$1,0)+1","v":24503064},{"$f":"ROUND(E21*I$1,0)","v":226713},{"$f":"ROUND(F21*J$1,0)+1","v":10634461},{"$f":"ROUND(G21*K$1,0)","v":121716},35485954]
[19240,8,"Allstate Ind Co",9.2200000000000005E-5,0,6.58E-5,0,{"$f":"ROUND(D22*H$1,0)","v":59229},0,{"$f":"ROUND(F22*J$1,0)","v":21806},0,81035]
[26905,8,"Century Natl Ins Co",1.299E-3,0,8.1840000000000005E-4,0,834478,0,271218,0,1105696]
[29742,8,"Integon Natl Ins Co",6.4044000000000002E-3,6.6956000000000003E-3,4.9608999999999999E-3,7.7038000000000002E-3,4114187,105121,1644042,80890,5944240]
[19380,12,"American Home Assur Co",3.9966999999999997E-3,2.8900000000000001E-5,4.0875E-3,1.4800000000000001E-5,2567480,454,1354598,155,3922687]
[19402,12,"AIG Prop Cas Co",1.5918E-3,0,0,0,1022572,0,0,0,1022572]
[19429,12,"Insurance Co Of The State Of PA",2.6699999999999998E-4,1.6647000000000001E-3,7.6349999999999996E-4,1.6171E-3,171521,26136,253024,16980,467661]
[19445,12,"National Union Fire Ins Co of Pittsb",0,1.16017E-2,5.2000000000000002E-6,1.66877E-2,0,182147,1723,175221,359091]
[23809,12,"Granite State Ins Co",1.6799999999999998E-5,7.6219999999999999E-4,2.8E-5,4.5849999999999998E-4,10792,11967,9279,4814,36852]
[23841,12,"New Hampshire Ins Co",7.6000000000000001E-6,1.548E-4,3.8E-6,2.0689999999999999E-4,4882,2430,1259,2172,10743]
[26611,12,"Blackboard Ins Co",0,6.1530000000000005E-4,0,0,0,9660,0,0,9660]
[10111,19,"American Bankers Ins Co Of FL",4.9040999999999998E-3,0,4.1608000000000001E-3,0,3150394,0,1378889,0,4529283]
[42978,19,"American Security Ins Co",8.7986999999999996E-3,0,6.9046999999999997E-3,0,5652285,0,2288218,0,7940503]
[42986,19,"Standard Guar Ins Co",4.5500000000000001E-5,0,5.9899999999999999E-5,0,29229,0,19851,0,49080]
[19976,28,"Amica Mut Ins Co",4.5599999999999998E-3,0,4.5827000000000003E-3,0,2929344,0,1518707,0,4448051]
[10391,31,"Berkshire Hathaway Direct Ins Co",7.6100000000000007E-5,9.4039999999999998E-4,2.677E-4,2.3992000000000002E-3,48887,14764,88716,25192,177559]
[20052,31,"National Liab & Fire Ins Co",0,0,2.3799999999999999E-5,0,0,0,7887,0,7887]
[22276,31,"Berkshire Hathaway Specialty Ins Co",0,4.4579999999999999E-4,0,5.4330000000000003E-4,0,6999,0,5705,12704]
[22314,31,"RSUI Ind Co",2.329E-4,0,2.142E-4,0,149615,0,70986,0,220601]
[25895,31,"United States Liab Ins Co",1.2227E-3,0,9.9660000000000005E-4,0,785462,0,330273,0,1115735]
[35416,31,"Us Underwriters Ins Co",9.9999999999999995E-8,0,9.9999999999999995E-8,0,64,0,33,0,97]
[42390,31,"Amguard Ins Co",4.8271E-3,1.7586899999999999E-2,3.7598000000000002E-3,1.86628E-2,3100929,276114,1245998,195959,4819000]
[20117,33,"California Cas Ind Exch",5.0509999999999999E-3,0,4.9414999999999997E-3,0,3244762,0,1637613,0,4882375]
[21415,62,"Employers Mut Cas Co",4.4180000000000001E-4,1.199E-3,3.3750000000000002E-4,1.2451999999999999E-3,283812,18824,111848,13075,427559]
[10014,65,"Affiliated Fm Ins Co",6.9971E-3,0,7.9828999999999994E-3,0,4494937,0,2645533,0,7140470]
[21482,65,"Factory Mut Ins Co",1.5269700000000001E-2,0,1.5410999999999999E-2,0,9809255,0,5107205,0,14916460]
[10315,69,"Civic Prop & Cas Co ",7.2749999999999996E-4,0,0,0,467346,0,0,0,467346]
[10317,69,"Neighborhood Spirit Prop & Cas Co",1.7325999999999999E-3,0,0,0,1113022,0,0,0,1113022]
[10318,69,"Exact Prop & Cas Co Inc",3.0469999999999998E-4,0,0,0,195739,0,0,0,195739]
[11185,69,"Foremost Ins Co Grand Rapids MI",1.85687E-2,0,1.8062399999999999E-2,0,11928533,0,5985879,0,17914412]
[11800,69,"Foremost Prop & Cas Ins Co",7.6040000000000005E-4,0,1.023E-3,0,488481,0,339022,0,827503]
[20796,69,"21st Century Premier Ins Co",5.6199999999999997E-5,0,9.0799999999999998E-5,0,36103,0,30091,0,66194]
[21652,69,"Farmers Ins Exch",2.32096E-2,5.9615899999999999E-2,3.7924600000000003E-2,6.3219600000000001E-2,14909847,935970,12568212,663806,29077835]
[21660,69,"Fire Ins Exch",4.31227E-2,5.1108000000000001E-2,4.9586999999999999E-2,6.8521600000000002E-2,{"$f":"ROUND(D54*H$1,0)+1","v":27702023},802396,{"$f":"ROUND(F54*J$1,0)+1","v":16433133},719477,45657029]
[21687,69,"Mid Century Ins Co",1.6887300000000001E-2,1.2681700000000001E-2,1.85687E-2,1.30075E-2,{"$f":"ROUND(D55*H$1,0)","v":10848402},199103,{"$f":"ROUND(F55*J$1,0)","v":6153667},136579,17337751]
[21709,69,"Truck Ins Exch",1.133E-4,2.7379799999999999E-2,1.248E-4,2.79067E-2,72784,429863,41359,293020,837026]
[25321,69,"Farmers Direct Prop & Cas Ins Co",3.2062000000000002E-3,0,2.6004999999999999E-3,0,2059663,0,861806,0,2921469]
[10759,71,"Universal N Amer Ins Co",3.9633999999999997E-3,0,2.5891E-3,0,2546088,0,858028,0,3404116]
[22012,79,"Motors Ins Corp",0,0,3.1050000000000001E-4,0,0,0,102900,0,102900]
[22101,83,"Grange Ins Assn",1.1563000000000001E-3,2.8608000000000001E-3,9.8620000000000001E-4,2.9670999999999999E-3,742807,44915,326827,31155,1145704]
[16691,84,"Great Amer Ins Co",8.1799999999999996E-5,5.6797000000000002E-3,2.029E-4,5.4939000000000003E-3,52548,89171,67241,57686,266646]
[21172,84,"Vanliner Ins Co",3.9999999999999998E-7,6.4399999999999993E-5,0,7.0099999999999996E-5,257,1011,0,736,2004]
[22136,84,"Great Amer Ins Co of NY",0,3.7035000000000002E-3,6.9999999999999999E-6,2.1651999999999999E-3,0,58145,2320,22735,83200]
[26344,84,"Great Amer Assur Co",1.42E-5,4.4593999999999996E-3,2.9799999999999999E-5,6.0277000000000004E-3,9122,70013,9876,63291,152302]
[26832,84,"Great Amer Alliance Ins Co",0,5.5902E-3,1.03E-5,5.2126999999999998E-3,0,87766,3413,54733,145912]
[32620,84,"National Interstate Ins Co",9.9999999999999995E-8,1.8369999999999999E-4,0,2.0239999999999999E-4,64,2884,0,2125,5073]
[33723,84,"Great Amer Spirit Ins Co",0,2.3E-6,0,2.5000000000000002E-6,0,36,0,26,{"$f":"SUM(H67:K67)","v":62}]
[10815,88,"Verlan Fire Ins Co MD",0,3.1026000000000001E-3,0,3.1254E-3,0,48711,0,32817,81528]
[22292,88,"Hanover Ins Co",0,7.8490999999999995E-3,0,6.9879E-3,0,123231,0,73373,196604]
[22306,88,"Massachusetts Bay Ins Co",0,9.4803000000000005E-3,0,4.0496000000000004E-3,0,148841,0,42521,191362]
[31534,88,"Citizens Ins Co Of Amer",0,5.3547999999999998E-3,0,1.7681999999999999E-3,0,84070,0,18566,102636]
[36064,88,"Hanover Amer Ins Co",0,2.2173000000000002E-3,0,1.4385000000000001E-3,0,34812,0,15104,49916]
[41840,88,"Allmerica Fin Benefit Ins Co",0,0,0,5.3000000000000001E-6,0,0,0,56,56]
[42552,88,"Nova Cas Co",0,2.6998999999999999E-3,0,2.6404000000000002E-3,0,42388,0,27724,70112]
[11000,91,"Sentinel Ins Co Ltd",1.0905999999999999E-3,4.3800400000000003E-2,9.0260000000000004E-4,4.0303899999999997E-2,700601,687666,299122,423191,2110580]
[19682,91,"Hartford Fire Ins Co",1.9973999999999999E-3,1.3350900000000001E-2,2.4047000000000001E-3,1.45194E-2,1283130,209609,796918,152454,2442111]
[22357,91,"Hartford Accident & Ind Co",0,9.5999999999999996E-6,0,1.01E-5,0,151,0,106,257]
[27120,91,"Trumbull Ins Co",2.2108000000000002E-3,0,1.4797E-3,0,1420218,0,490373,0,1910591]
[29424,91,"Hartford Cas Ins Co",8.9999999999999996E-7,1.516E-4,5.9999999999999997E-7,1.5440000000000001E-4,578,2380,199,1621,4778]
[29459,91,"Twin City Fire Ins Co Co",4.2599999999999999E-5,0,2.9499999999999999E-5,3.5200000000000002E-5,27366,0,9776,370,37512]
[30104,91,"Hartford Underwriters Ins Co",7.4900000000000005E-5,2.7100000000000001E-5,6.2399999999999999E-5,1.25346E-2,48116,425,20679,131613,200833]
[34690,91,"Property & Cas Ins Co Of Hartford",5.2807000000000002E-3,0,3.7315E-3,0,3392322,0,1236619,0,4628941]
[37478,91,"Hartford Ins Co Of The Midwest",0,1.9999999999999999E-6,0,6.1E-6,0,31,0,64,95]
[42307,91,"Navigators Ins Co",0,6.0559999999999998E-4,0,1.0579000000000001E-3,0,9508,0,11108,20616]
[10749,98,"Intrepid Ins Co",0,5.2689999999999996E-4,0,8.2140000000000002E-4,0,{"$f":"ROUND(E85*I$1,0)","v":8272},0,{"$f":"ROUND(G85*K$1,0)","v":8625},16897]
[25224,98,"Great Divide Ins Co",9.9999999999999995E-8,3.7849999999999998E-4,0,3.6969999999999999E-4,64,5942,0,3882,9888]
[29580,98,"Berkley Regional Ins Co",7.3000000000000004E-6,6.5959999999999999E-4,8.3499999999999997E-5,5.4330000000000003E-4,{"$f":"ROUND(D87*H$1,0)","v":4690},10356,{"$f":"ROUND(F87*J$1,0)","v":27672},5705,48423]
[32603,98,"Berkley Ins Co",1.1999999999999999E-6,0,7.9999999999999996E-7,0,771,0,265,0,1036]
[36684,98,"Riverport Ins Co",0,1.34E-5,0,3.6900000000000002E-5,0,210,0,387,597]
[38911,98,"Berkley Natl Ins Co",2.007E-4,8.4820000000000002E-4,2.7399999999999999E-4,8.1559999999999998E-4,128930,13317,90804,8564,241615]
[40045,98,"Starnet Ins Co",2.7E-6,8.407E-4,8.6000000000000007E-6,6.4610000000000004E-4,1734,13199,2850,6784,24567]
[44318,98,"Admiral Ind Co",0,3.3500000000000001E-5,0,4.0800000000000002E-5,0,526,0,428,954]
[21458,111,"Employers Ins Co of Wausau",2.9166000000000001E-3,0,2.9543E-3,0,1873624,0,979055,0,2852679]
[23035,111,"Liberty Mut Fire Ins Co",3.6258000000000002E-3,1.1961000000000001E-3,3.3538000000000001E-3,2.5692000000000002E-3,2329214,18779,1111449,26977,3486419]
[23043,111,"Liberty Mut Ins Co",2.6305E-3,5.3010000000000004E-4,2.9586999999999999E-3,3.2469999999999998E-4,1689833,8323,980513,3409,2682078]
[24066,111,"American Fire & Cas Co",0,2.3132000000000001E-3,0,1.8927E-3,0,36317,0,19873,56190]
[24074,111,"Ohio Cas Ins Co",8.5699999999999996E-5,5.4592E-3,6.9599999999999998E-5,4.3975000000000004E-3,55054,85709,23065,46174,210002]
[24082,111,"Ohio Security Ins Co",4.84E-4,3.1645600000000003E-2,4.0539999999999999E-4,2.5917099999999998E-2,310922,496836,134350,272130,1214238]
[24724,111,"First Natl Ins Co Of Amer",5.5580999999999998E-3,0,5.1628999999999998E-3,0,3570523,0,1710985,0,5281508]
[24732,111,"General Ins Co Of Amer",2.2759399999999999E-2,0,2.3437699999999999E-2,0,14620639,0,7767254,0,22387893]
[24740,111,"Safeco Ins Co Of Amer",2.3001799999999999E-2,9.6199999999999996E-4,2.2494699999999999E-2,1.31E-3,14776356,15103,7454744,13755,22259958]
[39012,111,"Safeco Ins Co Of IL",6.4589000000000001E-3,0,6.5031000000000004E-3,0,4149197,0,2155127,0,6304324]
[42404,111,"Liberty Ins Corp",2.08221E-2,0,2.0797699999999999E-2,0,13376117,0,6892358,0,20268475]
[44393,111,"West Amer Ins Co",3.4299999999999999E-4,1.7247499999999999E-2,3.1770000000000002E-4,1.57664E-2,220343,270786,105286,165547,761962]
[23396,124,"Amerisure Mut Ins Co",3.1999999999999999E-6,5.8000000000000004E-6,2.7999999999999999E-6,8.8999999999999995E-6,2056,91,928,93,3168]
[11991,140,"National Cas Co",5.7609999999999996E-4,2.9999999999999999E-7,5.4500000000000002E-4,3.5999999999999998E-6,370087,5,180613,38,550743]
[15580,140,"Scottsdale Ind Co",5.5800000000000001E-5,9.2230000000000003E-4,5.0000000000000002E-5,6.2569999999999998E-4,35846,14480,16570,6570,73466]
[18961,140,"Crestbrook Ins Co",3.0517999999999999E-3,1.7022999999999999E-3,2.6392999999999998E-3,1.3472E-3,1960476,26726,874664,14146,2876012]
[19100,140,"Amco Ins Co",2.1202E-3,3.0792699999999999E-2,1.7E-5,1.51214E-2,1362016,483445,5634,158775,2009870]
[23760,140,"Nationwide Gen Ins Co",0,0,1.3900000000000001E-5,9.2469999999999998E-4,0,0,4606,9709,14315]
[23779,140,"Nationwide Mut Fire Ins Co",1.1000000000000001E-6,0,0,0,707,0,0,0,707]
[23787,140,"Nationwide Mut Ins Co",2.5478799999999999E-2,1.8592899999999999E-2,2.5339400000000002E-2,1.52278E-2,16367581,291909,8397477,159892,25216859]
[25453,140,"Nationwide Ins Co Of Amer",1.329E-4,1.7286000000000001E-3,2.1500000000000001E-5,1.0491999999999999E-3,85375,27139,7125,11017,130656]
[28223,140,"Nationwide Agribusiness Ins Co",4.7249999999999999E-4,2.6658100000000001E-2,5.842E-4,2.2246100000000001E-2,303534,418532,193604,233584,1149254]
[42579,140,"Allied Prop & Cas Ins Co",4.6470000000000002E-4,0,0,0,298523,0,0,0,298523]
[12262,150,"Pennsylvania Manufacturers Assoc Ins",0,1.1964E-3,0,1.2397E-3,0,18783,0,13017,31800]
[20095,150,"BITCO Gen Ins Corp",4.9999999999999998E-7,4.4000000000000002E-6,9.9999999999999995E-7,8.8999999999999995E-6,321,69,331,93,814]
[20109,150,"BITCO Natl Ins Co",1.5999999999999999E-6,0,0,1.1000000000000001E-6,1028,0,0,12,1040]
[36897,150,"Manufacturers Alliance Ins Co",0,6.0240000000000001E-4,0,4.7189999999999998E-4,{"$f":"ROUND(D119*H$1,0)","v":0},9458,{"$f":"ROUND(F119*J$1,0)","v":0},4955,14413]
[41424,150,"Pennsylvania Manufacturers Ind Co",0,5.13E-5,0,1.8700000000000001E-5,0,805,0,196,1001]
[14042,155,"ASI Select Ins Corp",5.7365000000000003E-3,0,4.6116000000000004E-3,0,3685128,0,1528284,0,5213412]
[10936,158,"Seneca Ins Co Inc",5.0969999999999998E-4,2.8457000000000001E-3,5.9119999999999995E-4,3.0157000000000001E-3,327431,44677,195924,31665,599697]
[13269,158,"Zenith Ins Co",0,1.3734700000000001E-2,0,1.3503100000000001E-2,0,215635,0,141783,357418]
[16624,158,"Allied World Specialty Ins Co",0,6.2960000000000002E-4,0,2.396E-4,0,9885,0,2516,12401]
[19489,158,"Allied World Assur Co US Inc",0,5.2200000000000002E-5,0,0,0,820,0,0,820]
[21105,158,"North River Ins Co",2.9960000000000002E-4,7.6000000000000001E-6,2.5950000000000002E-4,4.8000000000000001E-5,192463,119,85998,504,279084]
[21113,158,"United States Fire Ins Co",6.7000000000000002E-5,4.216E-4,7.0999999999999998E-6,8.451E-4,43041,6619,2353,8874,60887]
[22730,158,"Allied World Ins Co",0,6.3999999999999997E-6,0,0,0,100,0,0,100]
[25054,158,"Hudson Ins Co",1.5999999999999999E-5,1.9446000000000001E-3,1.63E-5,2.0024000000000001E-3,10278,30530,5402,21025,67235]
[44768,158,"Vantapro Specialty Ins Co",0,2.152E-4,0,1.404E-4,0,3379,0,1474,4853]
[18031,161,"Topa Ins Co",0,2.9234999999999999E-3,0,1.3678E-3,0,45899,0,14362,{"$f":"SUM(H131:K131)","v":60261}]
[13978,169,"Florists Mut Ins Co",5.1380000000000002E-4,0,4.9010000000000004E-4,0,330065,0,162419,0,492484]
[21180,169,"Sentry Select Ins Co",1.683E-4,0,1.7310000000000001E-4,0,108116,0,57365,0,165481]
[23434,169,"Middlesex Ins Co",7.2199999999999999E-4,0,8.2359999999999996E-4,0,463813,0,272941,0,736754]
[24988,169,"Sentry Ins Co",6.2089999999999997E-4,0,6.3869999999999997E-4,0,398866,0,211665,0,610531]
[25151,176,"State Farm Gen Ins Co",0.16797380000000001,9.2869900000000005E-2,0.16620280000000001,9.3252399999999999E-2,{"$f":"ROUND(D136*H$1,0)+1","v":107906370},1458057,55079608,979150,165423185]
[29700,181,"Swiss Re Corp Solutions Elite Ins Co",2.0209E-3,9.9699999999999998E-5,2.2617000000000002E-3,1.206E-4,{"$f":"ROUND(D137*H$1,0)","v":1298226},1565,749527,1266,2050584]
[29874,181,"Swiss Re Corp Solutions Amer Ins Co",3.0199999999999999E-5,0,5.4700000000000001E-5,0,19400,0,18128,0,37528]
[39845,181,"Westport Ins Corp",8.3700000000000002E-5,0,5.8000000000000004E-6,0,53769,0,1922,0,55691]
[18600,200,"USAA Gen Ind Co",8.1846000000000002E-3,0,8.6803999999999996E-3,0,5257787,0,2876685,0,8134472]
[21253,200,"Garrison Prop & Cas Ins Co",5.6461000000000003E-3,0,6.3594000000000003E-3,0,3627055,0,2107505,0,5734560]
[25941,200,"United Serv Automobile Assn",2.3669599999999999E-2,0,2.2812300000000001E-2,0,15205351,0,7559996,0,22765347]
[25968,200,"USAA Cas Ins Co",2.1143200000000001E-2,0,1.9846800000000001E-2,0,13582392,0,6577230,0,20159622]
[25976,201,"Utica Mut Ins Co",0,1.63E-5,0,2.1800000000000001E-5,0,256,0,229,485]
[25984,201,"Graphic Arts Mut Ins Co",0,2.9000000000000002E-6,0,3.1E-6,0,46,0,33,79]
[16535,212,"Zurich Amer Ins Co",1.23348E-2,5.2846000000000004E-3,1.43328E-2,7.7813999999999999E-3,7923876,82968,4749890,81705,12838439]
[21326,212,"Empire Fire & Marine Ins Co",1.9E-6,0,1.5E-6,0,1221,0,497,0,1718]
[26247,212,"American Guar & Liab Ins",2.0921999999999998E-3,1.2765999999999999E-3,9.9730000000000001E-4,2.6064E-3,1344029,20043,330505,27367,1721944]
[27855,212,"Zurich Amer Ins Co Of IL",6.1999999999999999E-6,5.8000000000000004E-6,2.72E-5,5.9000000000000003E-6,3983,{"$f":"ROUND(E149*I$1,0)","v":91},9014,{"$f":"ROUND(G149*K$1,0)","v":62},13150]
[39306,212,"Fidelity & Deposit Co Of MD ",1.011E-4,2.4258000000000001E-3,2.375E-4,2.2843999999999998E-3,64947,38085,78708,23986,205726]
[40142,212,"American Zurich Ins Co",2.1999999999999999E-5,5.4909999999999996E-4,6.5400000000000004E-5,6.179E-4,14133,8621,{"$f":"ROUND(F151*J$1,0)","v":21674},6488,50916]
[10914,215,"Kemper Independence Ins Co",3.3995000000000002E-3,0,2.5084E-3,0,2183839,0,831284,0,3015123]
[10915,215,"Unitrin Direct Prop & Cas Co",5.2000000000000002E-6,0,3.9999999999999998E-6,0,3340,0,1326,0,4666]
[11142,215,"United Cas Ins Co Of Amer",6.2700000000000006E-5,0,5.2299999999999997E-5,0,40278,0,17332,0,57610]
[16063,215,"Unitrin Auto & Home Ins Co",9.3309999999999997E-4,0,5.9000000000000003E-4,0,599423,0,195526,0,794949]
[31968,215,"Merastar Ins Co",1.3699999999999999E-5,0,1.1199999999999999E-5,0,8801,0,3712,0,12513]
[20427,218,"American Cas Co Of Reading PA",2.1800000000000001E-5,1.5043000000000001E-3,8.81E-5,2.5692000000000002E-3,14004,23618,29196,26977,93795]
[20443,218,"Continental Cas Co",9.3539999999999997E-4,7.9235E-3,1.1885999999999999E-3,3.1717999999999998E-3,600901,124399,393902,33304,1152506]
[20478,218,"National Fire Ins Co Of Hartford",5.1000000000000003E-6,2.9543999999999998E-3,2.58E-5,3.1449999999999998E-3,3276,46384,8550,33023,91233]
[20494,218,"Transportation Ins Co",5.4E-6,1.9983000000000002E-3,3.3200000000000001E-5,1.2687E-3,3469,31373,11002,13321,59165]
[20508,218,"Valley Forge Ins Co",0,4.2764999999999999E-3,5.13E-5,2.0519000000000002E-3,0,67141,17001,21545,105687]
[35289,218,"Continental Ins Co",1.351E-4,3.5723E-3,6.5699999999999998E-5,3.9744999999999997E-3,86788,56085,21773,41732,206378]
[23248,225,"Occidental Fire & Cas Co Of NC",8.275E-4,0,1.34E-5,0,531586,0,4441,0,536027]
[28886,225,"Transguard Ins Co Of Amer Inc",3.7400000000000001E-5,0,3.43E-5,1.17E-5,24026,0,11367,123,35516]
[36560,225,"SafePort Ins Co",0,0,4.214E-4,0,0,0,139652,0,139652]
[10677,244,"The Cincinnati Ins Co",3.0481000000000002E-3,2.0699999999999999E-4,2.8007000000000002E-3,1.9709999999999999E-4,1958099,3250,928152,2070,2891571]
[23280,244,"The Cincinnati Ind Co",1.9999999999999999E-7,0,4.9999999999999998E-7,2.9600000000000001E-5,128,0,166,311,605]
[28665,244,"The Cincinnati Cas Co",1.1000000000000001E-6,3.1999999999999999E-6,1.5E-6,4.1999999999999996E-6,707,50,497,44,1298]
[14974,246,"Pennsylvania Lumbermens Mut Ins",1.0124000000000001E-3,0,1.1594000000000001E-3,0,{"$f":"ROUND(D169*H$1,0)","v":650366},0,384225,0,1034591]
[13021,248,"United Fire & Cas Co",5.3810000000000001E-4,0,7.2150000000000003E-4,2.23E-5,345675,0,239105,234,585014]
[31453,248,"Financial Pacific Ins Co",1.4249999999999999E-4,4.0069999999999998E-4,1.3750000000000001E-4,4.4870000000000001E-4,91542,6291,45568,4711,148112]
[16608,256,"New York Marine & Gen Ins Co",3.4000000000000001E-6,6.5749999999999999E-4,1.5E-6,6.2790000000000003E-4,2184,10323,497,6593,19597]
[12890,280,"Eagle W Ins Co",2.6899999999999998E-4,0,2.4459999999999998E-4,2.2099999999999998E-5,172806,0,81060,232,254098]
[13544,280,"California Capital Ins Co",5.6205999999999999E-3,2.7659199999999998E-2,5.7253E-3,3.08545E-2,3610673,434249,1897364,323972,6266258]
[23540,280,"Monterey Ins Co",0,2.9323000000000001E-3,0,3.9122000000000002E-3,0,46037,0,41078,87115]
[22578,300,"Horace Mann Ins Co",1.5039000000000001E-3,0,1.6647999999999999E-3,0,966105,0,551715,0,1517820]
[22756,300,"Horace Mann Prop & Cas Ins Co",4.5919999999999999E-4,0,4.8040000000000002E-4,0,294990,0,159205,0,454195]
[14559,303,"GuideOne Specialty Ins Co",1.1000000000000001E-6,6.9839999999999995E-4,9.9999999999999995E-8,2.3929999999999999E-4,707,10965,33,2513,14218]
[15032,303,"GuideOne Ins Co",8.9999999999999996E-7,3.1657999999999999E-3,0,4.3857000000000002E-3,578,49703,0,46050,96331]
[10847,306,"Cumis Ins Society Inc",6.8000000000000001E-6,7.3450000000000002E-4,9.9000000000000001E-6,7.6889999999999999E-4,4368,11532,3281,8073,27254]
[10004,313,"Seaview Ins Co",2.3425E-3,0,3.3429000000000002E-3,0,1504822,0,1107837,0,2612659]
[33898,313,"Aegis Security Ins Co",2.285E-4,0,1.7405000000000001E-3,0,146788,0,576802,0,723590]
[10693,323,"Civil Serv Employees Ins Co",1.7312E-3,0,1.5016000000000001E-3,0,1112123,0,{"$f":"ROUND(F183*J$1,0)","v":497630},0,1609753]
[18953,323,"CSE Safeguard Ins Co",4.0873999999999997E-3,0,3.8227999999999999E-3,0,2625746,0,1266876,0,3892622]
[21261,350,"Electric Ins Co",1.84E-4,0,1.7019999999999999E-4,0,118202,0,56404,0,174606]
[11452,361,"Hartford Steam Boil Inspec & Ins Co",0,3.1999999999999999E-6,0,1.7E-6,0,50,0,18,68]
[19720,361,"American Alt Ins Corp",2.2000000000000001E-6,2.5398E-3,1.078E-4,2.6053000000000001E-3,1413,39875,35725,27356,104369]
[23450,361,"American Family Home Ins Co",0,1.907E-4,0,1.427E-4,0,2994,0,1498,4492]
[23469,361,"American Modern Home Ins Co",1.2989E-3,3.0699999999999998E-4,4.6700000000000002E-4,0,834413,4820,154764,0,993997]
[41998,361,"American Southern Home Ins Co",9.9999999999999995E-8,6.6310000000000002E-4,1.7200000000000001E-5,7.6979999999999995E-4,64,10411,5700,8083,24258]
[42722,361,"American Modern Prop & Cas Ins Co",7.1284E-3,0,8.0940000000000005E-3,0,4579284,0,2682352,0,7261636]
[19801,408,"Argonaut Ins Co",0,2.0350000000000001E-4,0,1.081E-4,0,3195,0,1135,4330]
[28401,408,"American Natl Prop & Cas Co",4.5897999999999998E-3,1.712E-3,3.5720000000000001E-3,9.9259999999999995E-4,2948488,26878,1183761,10422,4169549]
[36927,408,"Colony Specialty Ins Co",1.2300000000000001E-5,0,1.6799999999999998E-5,0,7902,0,5568,0,13470]
[23876,411,"Mapfre Ins Co",9.1889999999999995E-4,0,9.2429999999999997E-4,0,590301,0,306313,0,{"$f":"SUM(H195:K195)","v":896614}]
[11005,473,"Homesite Ins Co Of CA",7.8861000000000001E-3,0,7.0438000000000002E-3,0,5066031,0,2334315,0,7400346]
[13927,473,"Homesite Ins Co Of The Midwest",7.0289999999999997E-3,0,8.9758000000000008E-3,0,4515430,0,2974580,0,7490010]
[27138,473,"Midvale Ind Co",0,5.4000000000000001E-4,0,1.8852000000000001E-3,0,8478,0,19795,28273]
[29068,473,"American Family Connect Prop & Cas I",9.2680000000000002E-3,0,8.4974000000000004E-3,0,5953763,0,2816038,0,8769801]
[12254,517,"Glencar Ins Co",0,0,0,1.3999999999999999E-6,0,0,0,15,15]
[41343,517,"HDI Global Ins Co",6.0360000000000003E-4,2.6130000000000001E-4,1.9009999999999999E-3,1.3229999999999999E-4,{"$f":"ROUND(D201*H$1,0)","v":387753},4102,629991,1389,1023235]
[18023,572,"Star Ins Co",0,1.4233E-3,0,2.173E-3,0,22346,0,22817,45163]
[21903,572,"Procentury Ins Co",0,5.9999999999999997E-7,0,5.9999999999999997E-7,0,9,0,6,15]
[25780,572,"Williamsburg Natl Ins Co",9.9999999999999995E-8,1.08E-5,9.9999999999999995E-8,1.03E-5,64,170,33,108,375]
[10030,626,"Westchester Fire Ins Co",0,0,2.6000000000000001E-6,2.061E-4,0,0,862,2164,3026]
[10052,626,"Chubb Natl Ins Co",5.4999999999999999E-6,0,5.1000000000000003E-6,1.3070000000000001E-4,3533,0,1690,1372,6595]
[12777,626,"Chubb Ind Ins Co",2.6000000000000001E-6,3.4999999999999999E-6,1.7999999999999999E-6,5.3890000000000003E-4,1670,55,597,5658,7980]
[18279,626,"Bankers Standard Ins Co",4.9440999999999999E-3,0,4.7109999999999999E-3,0,3176090,0,1561225,0,4737315]
[20281,626,"Federal Ins Co",8.2976000000000005E-3,3.7786E-2,8.6721000000000003E-3,1.30064E-2,5330378,593240,2873934,136567,8934119]
[20303,626,"Great Northern Ins Co",9.3000000000000007E-6,1.7983000000000001E-3,1.27E-5,1.3787000000000001E-3,5974,28233,4209,14476,52892]
[20346,626,"Pacific Ind Co",6.9099999999999999E-5,1.4139999999999999E-4,5.8E-5,9.6899999999999997E-5,44390,2220,19221,1017,66848]
[20397,626,"Vigilant Ins Co",8.5799999999999998E-5,1.467E-3,7.47E-5,7.8479999999999999E-4,55118,23032,24756,8240,111146]
[20699,626,"Ace Prop & Cas Ins Co",0,2.3281E-3,0,2.3115000000000002E-3,0,{"$f":"ROUND(E213*I$1,0)","v":36551},0,{"$f":"ROUND(G213*K$1,0)","v":24271},60822]
[20702,626,"Ace Fire Underwriters Ins Co",0,1.6673E-3,0,1.1676E-3,0,26177,0,12260,38437]
[22667,626,"Ace Amer Ins Co",1.1004000000000001E-3,5.1650399999999999E-2,1.0983E-3,4.9136199999999998E-2,706897,810911,{"$f":"ROUND(F215*J$1,0)","v":363977},515930,2397715]
[22713,626,"Insurance Co of N Amer",1.0903E-3,2.3E-6,1.4074999999999999E-3,0,700409,36,466446,0,1166891]
[22748,626,"Pacific Employers Ins Co",1.1050000000000001E-3,2.1892999999999999E-3,1.3121999999999999E-3,1.8033999999999999E-3,709852,34372,434863,18936,1198023]
[35181,626,"Executive Risk Ind Inc",7.9999999999999996E-7,0,7.9999999999999996E-7,0,514,0,265,0,779]
[43575,626,"Indemnity Ins Co Of North Amer",0,3.4743E-3,0,3.3722000000000001E-3,0,54547,0,35408,89955]
[14907,645,"Oregon Mut Ins Co",1.4446999999999999E-3,5.8907999999999999E-3,3.0689999999999998E-4,7.3939000000000001E-3,928075,92486,101707,77636,1199904]
[11908,660,"Mercury Cas Co",1.4600000000000001E-5,1.09952E-2,1.98E-5,5.0229000000000003E-3,9379,172625,6562,52740,241306]
[31046,660,"California Gen Underwriters Ins Co",0,4.7340000000000004E-3,0,1.2354199999999999E-2,0,74324,0,129719,204043]
[38342,660,"California Automobile Ins Co",4.9950599999999998E-2,0,5.31803E-2,0,{"$f":"ROUND(D223*H$1,0)+1","v":32088266},0,{"$f":"ROUND(F223*J$1,0)+1","v":17623952},0,49712218]
[21849,761,"American Automobile Ins Co",0,2.6679999999999998E-4,0,2.812E-4,{"$f":"ROUND(D224*H$1,0)","v":0},4189,{"$f":"ROUND(F224*J$1,0)","v":0},2953,7142]
[21873,761,"Firemans Fund Ins Co",5.1079999999999995E-4,1.7855800000000002E-2,7.3629999999999995E-4,2.1195800000000001E-2,328138,280336,244010,222556,1075040]
[21881,761,"National Surety Corp",0,0,0,4.6999999999999999E-6,0,0,0,49,49]
[22810,761,"Chicago Ins Co",0,4.7820000000000002E-4,0,3.8749999999999999E-4,0,7508,0,4069,11577]
[22837,761,"AGCS Marine Ins Co",0,3.5790000000000001E-3,0,3.5174E-3,0,56190,0,36933,93123]
[35300,761,"Allianz Global Risks US Ins Co",6.5856999999999999E-3,0,5.8640999999999997E-3,0,4230654,0,1943363,0,6174017]
[36420,761,"Allianz Underwriters Ins Co",0,0,2.9999999999999999E-7,0,0,0,99,0,99]
[13714,775,"Pharmacists Mut Ins Co",1.2999999999999999E-5,1.2906E-3,6.7000000000000002E-6,1.4812E-3,8351,20262,2220,15553,46386]
[13056,783,"RLI Ins Co",0,1.143E-4,0,6.4409999999999999E-4,0,1795,0,6763,8558]
[37206,783,"Contractors Bonding & Ins Co",0,5.1600000000000001E-5,0,4.8300000000000002E-5,0,810,0,507,1317]
[12831,785,"State Natl Ins Co Inc",1.1849999999999999E-4,8.0014000000000005E-3,2.8069999999999999E-4,0,76124,125622,93024,0,294770]
[22608,785,"National Specialty Ins Co",0,0,0,1.56E-5,0,0,0,164,164]
[28932,785,"Markel Amer Ins Co",6.2600000000000004E-4,6.6080000000000002E-4,6.1240000000000003E-4,8.7169999999999999E-4,402142,10375,202949,9153,624619]
[38970,785,"Markel Ins Co",0,1.6105E-3,1.5E-6,1.7983999999999999E-3,0,25285,497,18883,44665]
[24414,796,"General Cas Co Of WI",4.751E-4,4.8701999999999999E-3,1.1781999999999999E-3,4.6040000000000002E-4,305204,76462,390455,4834,776955]
[24449,796,"Regent Ins Co",4.0500000000000002E-5,2.4756000000000001E-3,3.8259999999999998E-4,4.9669999999999998E-4,26017,38867,126794,5215,196893]
[37257,796,"Praetorian Ins Co",2.8239999999999998E-4,0,6.0320000000000003E-4,0,181414,0,199900,0,381314]
[39217,796,"QBE Ins Corp",3.9709999999999997E-3,5.9860000000000002E-4,3.0339E-3,4.9390000000000002E-4,2550970,9398,1005434,5186,3570988]
[13625,800,"Western Mut Ins Co",4.1E-5,0,3.82E-5,0,26338,0,12659,0,38997]
[15776,800,"Residence Mut Ins Co",3.8890000000000001E-3,0,3.9173999999999997E-3,0,2498294,0,1298226,0,3796520]
[32859,920,"Penn Amer Ins Co",4.9999999999999998E-7,4.32E-5,0,0,321,678,0,0,999]
[42048,920,"Diamond State Ins Co",0,1.8430000000000001E-4,0,4.593E-4,0,2894,0,4823,7717]
[19518,968,"Catlin Ins Co",0,0,1.1999999999999999E-6,0,0,0,398,0,398]
[22322,968,"Greenwich Ins Co",3.2279999999999999E-4,2.3065E-3,3.8880000000000002E-4,2.225E-3,207367,36212,128848,23363,395790]
[24554,968,"XL Ins Amer Inc",3.2615999999999999E-3,0,2.0717999999999999E-3,5.1400000000000003E-5,2095252,0,686595,540,2782387]
[37885,968,"XL Specialty Ins Co",2.029E-4,0,2.1440000000000001E-4,0,130343,0,71052,0,201395]
[10120,1120,"Everest Natl Ins Co ",2.48E-5,8.2669999999999998E-4,8.5799999999999998E-5,9.9820000000000009E-4,15932,12979,28434,10481,67826]
[10921,1278,"CSAA Fire & Cas Ins Co",7.1608000000000002E-3,0,6.894E-3,0,4600098,0,2284672,0,6884770]
[15539,1278,"CSAA Ins Exch",6.5829600000000002E-2,0,5.6807799999999999E-2,0,{"$f":"ROUND(D252*H$1,0)+1","v":42288936},0,{"$f":"ROUND(F252*J$1,0)+1","v":18826106},0,61115042]
[11150,1279,"Arch Ins Co",3.9400000000000002E-5,4.4146999999999997E-3,1.9599999999999999E-5,3.8484999999999999E-3,{"$f":"ROUND(D253*H$1,0)","v":25311},69311,{"$f":"ROUND(F253*J$1,0)","v":6495},40409,141526]
[13722,1316,"Knightbrook Ins Co",8.6500000000000002E-5,0,6.4700000000000001E-5,0,{"$f":"ROUND(D254*H$1,0)","v":55568},0,{"$f":"ROUND(F254*J$1,0)","v":21442},0,77010]
[15598,1318,"Interins Exch Of The Automobile Club",5.0230700000000003E-2,0,4.9982600000000002E-2,0,{"$f":"ROUND(D255*H$1,0)+1","v":32268203},0,{"$f":"ROUND(F255*J$1,0)+1","v":16564235},0,48832438]
[19879,2538,"Security Natl Ins Company",5.8499999999999999E-5,7.9527E-3,2.8600000000000001E-5,8.3113000000000006E-3,{"$f":"ROUND(D256*H$1,0)","v":37580},124857,{"$f":"ROUND(F256*J$1,0)","v":9478},87269,259184]
[25011,2538,"Wesco Ins Co",1.5299999999999999E-5,8.0354999999999992E-3,2.1500000000000001E-5,1.09012E-2,9829,126157,7125,114463,257574]
[42376,2538,"Technology Ins Co Inc",5.9999999999999997E-7,1.785E-4,3.9999999999999998E-7,8.1199999999999995E-5,385,2802,133,853,4173]
[37850,2898,"Pacific Specialty Ins Co",1.78391E-2,0,1.7259E-2,0,11459838,0,5719633,0,{"$f":"SUM(H259:K259)","v":17179471}]
[10945,3098,"Tokio Marine Amer Ins Co",3.0633000000000001E-3,1.1931999999999999E-3,3.0842E-3,1.3748E-3,1967864,18733,1022104,14435,3023136]
[12873,3098,"Privilege Underwriters Recp Exch",6.4178999999999998E-3,0,6.7491000000000001E-3,0,4122859,0,2236652,0,6359511]
[18058,3098,"Philadelphia Ind Ins Co",0,4.1612299999999998E-2,0,4.1862700000000003E-2,0,653313,0,439558,1092871]
[32301,3098,"TNUS Ins Co",0,5.2000000000000002E-6,0,0,0,82,0,0,82]
[41238,3098,"Trans Pacific Ins Co",0,1.537E-4,0,5.2500000000000002E-5,0,2413,0,551,2964]
[11126,3219,"Sompo Amer Ins Co",4.4752999999999998E-3,6.0880000000000005E-4,3.3649000000000001E-3,5.4109999999999998E-4,2874933,9558,1115128,5682,4005301]
[20370,3416,"AXIS Reins Co",9.9999999999999995E-8,0,0,0,64,0,0,0,64]
[37273,3416,"Axis Ins Co",2.0019999999999999E-4,1.7819999999999999E-4,1.06E-4,9.7700000000000003E-5,128608,2798,35128,1026,167560]
[15884,3494,"Falls Lake Fire & Cas Co",1.05E-4,0,6.9200000000000002E-5,0,67452,0,22933,0,90385]
[19038,3548,"Travelers Cas & Surety Co",0,5.2000000000000002E-6,0,5.5999999999999997E-6,0,82,0,59,141]
[19070,3548,"Standard Fire Ins Co",3.38643E-2,0,2.9243999999999999E-2,0,{"$f":"ROUND(D270*H$1,0)+1","v":21754427},0,{"$f":"ROUND(F270*J$1,0)+1","v":9691463},0,31445890]
[24767,3548,"St Paul Fire & Marine Ins Co",2.7900000000000001E-5,0,6.6000000000000003E-6,0,{"$f":"ROUND(D271*H$1,0)","v":17923},0,{"$f":"ROUND(F271*J$1,0)","v":2187},0,20110]
[25674,3548,"Travelers Prop Cas Co Of Amer",8.8794000000000008E-3,4.2394599999999998E-2,1.1372200000000001E-2,5.6176900000000002E-2,5704127,665595,3768747,589857,10728326]
[25682,3548,"Travelers Ind Co Of CT",0,2.0423299999999998E-2,0,3.4620199999999997E-2,0,320646,0,363512,684158]
[36137,3548,"Travelers Commercial Ins Co",0,0,3.9999999999999998E-7,0,0,0,133,0,133]
[26379,4234,"Accredited Surety & Cas Co Inc",1.182E-4,5.421E-4,1.1908000000000001E-3,1.9276E-3,75932,8511,394631,20240,499314]
[10069,4359,"Housing Authority Prop A Mut Co",0,1.1623E-3,0,1.1620000000000001E-3,0,18248,0,12201,30449]
[11206,4359,"Housing Enterprise Ins Co Inc",0,9.9109999999999997E-4,0,1.3619999999999999E-3,0,{"$f":"ROUND(E277*I$1,0)","v":15560},0,{"$f":"ROUND(G277*K$1,0)","v":14301},29861]
[35408,4381,"Imperium Ins Co",3.9999999999999998E-6,0,3.9999999999999998E-6,0,2570,0,1326,0,3896]
[38733,4485,"Alaska Natl Ins Co",2.7E-6,1.5500000000000001E-5,2.9000000000000002E-6,2.7399999999999999E-5,1734,243,961,288,3226]
[10200,4666,"Hiscox Ins Co Inc",0,2.0542999999999998E-3,0,2.4796000000000002E-3,0,32253,0,26036,58289]
[38318,4670,"Starr Ind & Liab Co",2.9300000000000001E-5,0,4.4519999999999998E-4,0,18822,0,147539,0,166361]
[12502,4672,"DB Ins Co Ltd (US Branch)",1.7551999999999999E-3,0,3.4093000000000001E-3,0,1127540,0,1129842,0,2257382]
[20362,4715,"Mitsui Sumitomo Ins Co of Amer",1.2959E-3,4.5383999999999997E-3,1.5556999999999999E-3,4.5287000000000001E-3,832486,71253,515559,47551,1466849]
[22551,4715,"Mitsui Sumitomo Ins USA Inc",3.9100000000000002E-5,1.3699000000000001E-3,4.2899999999999999E-5,1.2773999999999999E-3,25118,21507,14217,13413,74255]
[10970,4718,"Response Ind Co Of CA",8.141E-4,4.6603E-3,1.0552000000000001E-3,5.1002E-3,522978,73167,349693,53552,999390]
[43460,4734,"Aspen Amer Ins Co",3.055E-4,9.7999999999999997E-5,0,2.37E-5,196253,1539,0,249,198041]
[19615,4761,"American Reliable Ins Co",0,5.6900000000000001E-5,0,4.8900000000000003E-5,0,893,0,513,1406]
[15563,4794,"Clear Spring Prop & Cas Co",0,3.4100000000000002E-5,0,5.3000000000000001E-5,0,535,0,557,1092]
[28860,4850,"Clear Blue Ins Co",1.0070000000000001E-3,0,5.5800000000000001E-4,0,646897,0,184921,0,831818]
[18767,4851,"Church Mut Ins Co S I ",3.8699999999999999E-5,7.6138000000000004E-3,8.0699999999999996E-5,9.4733999999999999E-3,24861,119537,26744,99471,270613]
[15900,4857,"US Coastal Prop & Cas Ins Co",9.9999999999999995E-8,0,0,0,64,0,0,0,64]
[16578,4869,"Stillwater Prop & Cas Ins Co",2.0803000000000002E-3,0,1.8468E-3,0,1336385,0,612030,0,1948415]
[25180,4869,"Stillwater Ins Co",8.1480000000000007E-3,1.4629000000000001E-3,6.7298999999999996E-3,2.0666999999999999E-3,5234275,22968,2230289,21700,7509232]
[41394,4886,"Benchmark Ins Co",0,1.7799999999999999E-5,0,1.42E-5,0,279,0,149,428]
[27154,4904,"Atlantic Specialty Ins Co",2.8039999999999999E-4,2.7867999999999999E-3,2.9E-4,2.6262E-3,180129,43753,96106,27575,347563]
[23752,4908,"Ascot Ins Co",0,1.607E-4,0,1.6000000000000001E-4,0,2523,0,1680,4203]
[23663,4935,"National Amer Ins Co",3.9999999999999998E-7,0,1.9999999999999999E-7,0,257,0,66,0,323]
[22225,4969,"Trisura Ins Co",0,5.0000000000000004E-6,0,6.1E-6,0,79,0,64,143]
[19269,4987,"Incline Natl Ins Co",7.9999999999999996E-7,0,1.5229999999999999E-4,0,514,0,50472,0,50986]
[25496,4990,"StarStone Natl Ins Co",0,2.9999999999999999E-7,0,0,0,5,0,0,5]
[10220,4997,"Accelerant Natl Ins Co",1.3786E-3,0,2.3914000000000001E-3,0,885613,0,792510,0,1678123]
[38776,5001,"SiriusPoint Amer Ins Co",1.9599999999999999E-5,1.5980000000000001E-4,4.7999999999999998E-6,4.6999999999999999E-6,12591,2509,1591,49,16740]
[24376,5010,"Spinnaker Ins Co",7.5183000000000003E-3,4.8289999999999997E-4,6.6931999999999998E-3,1.3703000000000001E-3,4829756,7582,2218126,14388,7069852]
[16023,5032,"Lemonade Ins Co",7.1238999999999999E-3,0,6.8754999999999997E-3,0,4576393,0,2278541,0,6854934]
[40550,5034,"Lio Ins Co",0,5.622E-4,0,4.6680000000000002E-4,0,8827,0,4901,13728]
[21857,5037,"The Pie Ins Co",0,0,0,2.5000000000000002E-6,0,0,0,26,26]
[38148,5049,"Granada Ind Co",0,0,0,3.2885000000000002E-3,0,0,0,34529,34529]
[25798,5065,"Sutton National Ins Co",4.4112999999999999E-3,0,1.3329499999999999E-2,0,2833819,0,4417396,0,7251215]
[null,null,null,{"$f":"SUM(D3:D308)","v":1.000000199999999},0.99999949999999993,0.99999960000000032,0.9999999000000005,642400130,15699994,331399875,10500001,1000000000]
[null,null,null,null,null,null,null,{"$f":"H1-H309","v":-130},{"$f":"I1-I309","v":6},{"$f":"J1-J309","v":125},{"$f":"K1-K309","v":-1},{"$f":"L1-L309","v":0},"Difference"]
[]
[]
[null,null,"Zero assessment: "]
[22209,140,"Freedom Specialty Ins Co",0,0,0,0,0,0,0,0,0]
[23582,140,"Harleysville Ins Co",0,0,0,0,0,0,0,0,0]
[42587,140,"Depositors Ins Co",0,0,0,0,0,0,0,0,0]
[26433,225,"Harco Natl Ins Co",0,0,0,0,0,0,0,0,0]
[25585,1279,"Watford Ins Co",0,0,0,0,0,0,0,0,0]
[29599,3098,"US Specialty Ins Co",0,0,0,0,0,0,0,0,0]
[19046,3548,"Travelers Cas Ins Co Of Amer",0,0,0,0,0,0,0,0,0]
[36161,3548,"Travelers Prop Cas Ins Co",0,0,0,0,0,0,0,0,0]
[14354,4889,"Jewelers Mut Ins Co S I ",0,0,0,0,0,0,0,0,0]
[]
["Note: $1 added to 6 insurers with over $30M in assessment in order to balance to $1B"]

{"sheet":"CalculationYear2","index":4,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["State of California",null,null,"Group",null,null,null,null,{"$f":"InputYear2!$G$1","v":0}]
["Department of Insurance (CDI)",null,null,"Line:",null,null,null,null,{"$f":"InputYear2!D25","v":0}]
[]
["FAIR PLAN RECOUPMENT ASSESSMENT TEMPLATE (Year 2)"]
["GENERAL INFORMATION"]
[]
["Total Recoupment Amount",{"$f":"InputYear2!H25","v":0}]
["Recouped Amount in Year 1",{"$f":"InputYear2!G25","v":0}]
["Remaining Recoupment Amount",{"$f":"B7-B8","v":0}]
["Total Written Premium Next Renewal Cycle",{"$f":"InputYear2!C44","v":""}]
["Annual Recoupment as a % of Total WP Next Renewal Cycle",{"$f":"IFERROR(IF(B10=0,\"\",B9/B10),\"\")","v":""}]
["Selected Recoupment as a % of Total WP",{"$f":"B11","v":""}]
[]
[{"$f":"\"Calculation of Recoupment Assessment as a Percent of Written Premium Based on \"&InputYear2!D27&\" Collection Period\"","v":"Calculation of Recoupment Assessment as a Percent of Written Premium Based on Two Collection Period"}]
["Line of Business","Total premium","Average Premium","Average Recoupment","Percent Annual Assessment","LOB"]
[{"$f":"IF(ISBLANK(InputYear2!A34),\"\",InputYear2!A34)","v":""},{"$f":"IF(ISBLANK(InputYear2!C34),\"\",InputYear2!C34)","v":""},{"$f":"IFERROR(InputYear2!C34/InputYear2!D34,\"\")","v":""},{"$f":"IFERROR(C16*$B$12,\"\")","v":""},{"$f":"IFERROR(D16/C16,\"\")","v":""},{"$f":"IFERROR(INDEX(Keys!$C$2:$C$23,MATCH(CalculationYear2!A16,Keys!$B$2:$B$24,0)),\"\")","v":""}]
[{"$f":"IF(ISBLANK(InputYear2!A35),\"\",InputYear2!A35)","v":""},{"$f":"IF(ISBLANK(InputYear2!C35),\"\",InputYear2!C35)","v":""},{"$f":"IFERROR(InputYear2!C35/InputYear2!D35,\"\")","v":""},{"$f":"IFERROR(C17*$B$12,\"\")","v":""},{"$f":"IFERROR(D17/C17,\"\")","v":""},{"$f":"IFERROR(INDEX(Keys!$C$2:$C$23,MATCH(CalculationYear2!A17,Keys!$B$2:$B$24,0)),\"\")","v":""}]
[{"$f":"IF(ISBLANK(InputYear2!A36),\"\",InputYear2!A36)","v":""},{"$f":"IF(ISBLANK(InputYear2!C36),\"\",InputYear2!C36)","v":""},{"$f":"IFERROR(InputYear2!C36/InputYear2!D36,\"\")","v":""},{"$f":"IFERROR(C18*$B$12,\"\")","v":""},"",{"$f":"IFERROR(INDEX(Keys!$C$2:$C$23,MATCH(CalculationYear2!A18,Keys!$B$2:$B$24,0)),\"\")","v":""}]
[{"$f":"IF(ISBLANK(InputYear2!A37),\"\",InputYear2!A37)","v":""},{"$f":"IF(ISBLANK(InputYear2!C37),\"\",InputYear2!C37)","v":""},{"$f":"IFERROR(InputYear2!C37/InputYear2!D37,\"\")","v":""},{"$f":"IFERROR(C19*$B$12,\"\")","v":""},"",{"$f":"IFERROR(INDEX(Keys!$C$2:$C$23,MATCH(CalculationYear2!A19,Keys!$B$2:$B$24,0)),\"\")","v":""}]
[{"$f":"IF(ISBLANK(InputYear2!A38),\"\",InputYear2!A38)","v":""},{"$f":"IF(ISBLANK(InputYear2!C38),\"\",InputYear2!C38)","v":""},{"$f":"IFERROR(InputYear2!C38/InputYear2!D38,\"\")","v":""},"","",{"$f":"IFERROR(INDEX(Keys!$C$2:$C$23,MATCH(CalculationYear2!A20,Keys!$B$2:$B$24,0)),\"\")","v":""}]
[{"$f":"IF(ISBLANK(InputYear2!A39),\"\",InputYear2!A39)","v":""},{"$f":"IF(ISBLANK(InputYear2!C39),\"\",InputYear2!C39)","v":""},{"$f":"IFERROR(InputYear2!C39/InputYear2!D39,\"\")","v":""},"","",{"$f":"IFERROR(INDEX(Keys!$C$2:$C$23,MATCH(CalculationYear2!A21,Keys!$B$2:$B$24,0)),\"\")","v":""}]
[{"$f":"IF(ISBLANK(InputYear2!A40),\"\",InputYear2!A40)","v":""},{"$f":"IF(ISBLANK(InputYear2!C40),\"\",InputYear2!C40)","v":""},{"$f":"IFERROR(InputYear2!C40/InputYear2!D40,\"\")","v":""},"","",{"$f":"IFERROR(INDEX(Keys!$C$2:$C$23,MATCH(CalculationYear2!A22,Keys!$B$2:$B$24,0)),\"\")","v":""}]
[{"$f":"IF(ISBLANK(InputYear2!A41),\"\",InputYear2!A41)","v":""},{"$f":"IF(ISBLANK(InputYear2!C41),\"\",InputYear2!C41)","v":""},{"$f":"IFERROR(InputYear2!C41/InputYear2!D41,\"\")","v":""},"","",{"$f":"IFERROR(INDEX(Keys!$C$2:$C$23,MATCH(CalculationYear2!A23,Keys!$B$2:$B$24,0)),\"\")","v":""}]
[{"$f":"IF(ISBLANK(InputYear2!A42),\"\",InputYear2!A42)","v":""},{"$f":"IF(ISBLANK(InputYear2!C42),\"\",InputYear2!C42)","v":""},{"$f":"IFERROR(InputYear2!C42/InputYear2!D42,\"\")","v":""},"","",{"$f":"IFERROR(INDEX(Keys!$C$2:$C$23,MATCH(CalculationYear2!A24,Keys!$B$2:$B$24,0)),\"\")","v":""}]
[{"$f":"IF(ISBLANK(InputYear2!A43),\"\",InputYear2!A43)","v":""},{"$f":"IF(ISBLANK(InputYear2!C43),\"\",InputYear2!C43)","v":""},{"$f":"IFERROR(InputYear2!C43/InputYear2!D43,\"\")","v":""},"","",{"$f":"IFERROR(INDEX(Keys!$C$2:$C$23,MATCH(CalculationYear2!A25,Keys!$B$2:$B$24,0)),\"\")","v":""}]
["Total",{"$f":"SUM(B16:B25)","v":0},{"$f":"IFERROR(InputYear2!C44/InputYear2!D44,\"\")","v":""},"",""]
[]
["Annual Recoupment by Line of Business"]
["Line of Business","Year 2 Recoupment"]
["Homeowner",{"$f":"IFERROR(SUMIFS($B$16:$B$25,$F$16:$F$25,A30)*$B$12,\"\")","v":""}]
["Fire and Allied",{"$f":"IFERROR(SUMIFS($B$16:$B$25,$F$16:$F$25,A31)*$B$12,\"\")","v":""}]
["Farmowners",""]
["CMP - Property",""]
["CMP - Liability",""]
["Other",""]
["Total",{"$f":"SUM(B30:B35)","v":0},{"$f":"IF(CalculationYear2!B36=(InputYear2!H25-InputYear2!G25),\"\",\"Recoupment amount does not match with input figures\")","v":""}]
[]
["Total Assessment Amount Allocated to Lines of Business"]
["Line of Business","Written Premium","Allocated Assessment"]
["Homeowner",{"$f":"SUMIFS($B$16:$B$25,$F$16:$F$25,A40)","v":0},{"$f":"IFERROR(B40*$B$11,\"\")","v":""}]
["Fire and Allied",0,""]
["Farmowners",0,""]
["CMP - Property",0,""]
["CMP - Liability",0,""]
["Other",0,""]
["Total",{"$f":"SUM(B40:B45)","v":0},{"$f":"SUM(C40:C45)","v":0},{"$f":"IF(C46=(InputYear2!H25-InputYear2!G25),\"\",\"Recoupment amount does not match with input figures\")","v":""}]

{"sheet":"Keys","index":5,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["POLICY_TYPE","Key",null,null,null,"Personal","Commercial",null,null,null,null,"Personal"]
["DO         ","Dwelling Owner-Occupied (Non-Seasonal)","Fire and Allied",null,null,"Dwelling Owner-Occupied (Non-Seasonal)","Farmowners",null,null,null,null,"Commercial"]
["DS         ","Dwelling Owner-Occupied (Seasonal)","Fire and Allied",null,null,"Dwelling Owner-Occupied (Seasonal)","Commercial Multi-Peril - Property Line"]
["DT         ","Dwelling Tenant-Occupied","Fire and Allied",null,null,"Dwelling Tenant-Occupied","Commercial Multi-Peril - Liability Line"]
["DC         ","Dwelling Contents-Only","Fire and Allied",null,null,"Dwelling Contents-Only","Commercial Fire and Allied"]
["FP         ","Force-Placed Occupied","Other",null,null,"Force-Placed Occupied","Other Coverage"]
["FX         ","Force-Placed Vacant","Other",null,null,"Force-Placed Vacant"]
["XX         ","Vacant","Other",null,null,"Vacant"]
[1,"HO-1","Homeowner",null,null,"HO-1"]
[2,"HO-2","Homeowner",null,null,"HO-2"]
[3,"HO-3","Homeowner",null,null,"HO-3"]
[4,"HO-4","Homeowner",null,null,"HO-4"]
[5,"HO-5","Homeowner",null,null,"HO-5"]
[6,"HO-6","Homeowner",null,null,"HO-6"]
["R6         ","HO-6 (Tenant-Occupied)","Homeowner",null,null,"HO-6 (Tenant-Occupied)"]
[7,"HO-7","Homeowner",null,null,"HO-7"]
["R7         ","HO-7 (Tenant-Occupied)","Homeowner",null,null,"HO-7 (Tenant-Occupied)"]
[8,"HO-8","Homeowner",null,null,"HO-8"]
[null,"Farmowners","Farmowners",null,null,"Other Fire and Allied"]
[null,"Commercial Multi-Peril - Property Line","CMP - Property",null,null,"Other Coverage"]
[null,"Commercial Multi-Peril - Liability Line","CMP - Liability"]
[null,"Other Coverage","Other"]
[null,"Commercial Fire and Allied","Fire and Allied"]
[null,"Other Fire and Allied","Fire and Allied"]
[]
[]
["One"]
["Two"]
[]
["Yes"]
["No"]