{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Intro","Balance Sheet","P & L","Cash Flow","Premium Ratios","Nationwide Premium by LOB","Nationwide Incurred Loss by LOB","Nation Net Prem & Loss Dev LOB","ST","Assumptions","Warning"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Intro","index":0,"n_rows":58,"n_cols":20,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"AK","Alaska",{"$f":"IF(TRIM(M2)=\"TRUE\",N2,\"Z\")","v":"Z"},"NC"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"AL","Alabama",{"$f":"IF(TRIM(M3)=\"TRUE\",N3,\"Z\")","v":"Z"},"PR","Current"]
[null,null,null,"AK","Alaska",null,null,"MT","Montana",null,null,null,false,"AR","Arkansas","Z","TN",null,"Alaska","Go to AK"]
[null,null,null,"AL","Alabama",null,null,"NC","North Carolina",null,null,null,false,"AS","American Samoa","Z","WI",null,"Alabama","Go to AL"]
[null,null,null,"AR","Arkansas",null,null,"ND","North Dakota",null,null,null,false,"AZ","Arizona","Z","Z",null,"Arkansas","Go to AR"]
[null,null,null,"AS","American Samoa",null,null,"NE","Nebraska",null,null,null,false,"CA","California","Z","Z",null,"American Samoa","Go to AS"]
[null,null,null,"AZ","Arizona",null,null,"NH","New Hampshire",null,null,null,false,"CO","Colorado","Z","Z",null,"Arizona","Go to AZ"]
[null,null,null,"CA","California",null,null,"NJ","New Jersey",null,null,null,false,"CT","Connecticut","Z","Z",null,"California","Go to CA"]
[null,null,null,"CO","Colorado",null,null,"NM","New Mexico",null,null,null,false,"DC","District Of Columbia","Z","Z",null,"Colorado","Go to CO"]
[null,null,null,"CT","Connecticut",null,null,"NV","Nevada",null,null,null,false,"DE","Delaware","Z","Z",null,"Connecticut","Go to CT"]
[null,null,null,"DC","District Of Columbia",null,null,"NY","New York",null,null,null,false,"FL","Florida","Z","Z",null,"District Of Columbia","Go to DC"]
[null,null,null,"DE","Delaware",null,null,"OH","Ohio",null,null,null,false,"GA","Georgia","Z","Z",null,"Delaware","Go to DE"]
[null,null,null,"FL","Florida",null,null,"OK","Oklahoma",null,null,null,false,"GU","Guam","Z","Z",null,"Florida","Go to FL"]
[null,null,null,"GA","Georgia",null,null,"OR","Oregon",null,null,null,false,"HI","Hawaii","Z","Z",null,"Georgia","Go to GA"]
[null,null,null,"GU","Guam",null,null,"PA","Pennsylvania",null,null,null,false,"IA","Iowa","Z","Z",null,"Guam","Go to GU"]
[null,null,null,"HI","Hawaii",null,null,"PR","Puerto Rico",null,null,null,true,"ID","Idaho","ID","Z",null,"Hawaii","Go to HI"]
[null,null,null,"IA","Iowa",null,null,"RI","Rhode Island",null,null,null,false,"IL","Illinois","Z","Z",null,"Iowa","Go to IA"]
[null,"Enter  the Applicant Company Name:",null,"ID","Idaho",null,null,"SC","South Carolina",null,null,null,false,"IN","Indiana","Z","Z",null,"Idaho","Go to ID"]
[null,null,null,"IL","Illinois",null,null,"SD","South Dakota",null,null,null,false,"KS","Kansas","Z","Z",null,"Illinois","Go to IL"]
[null,"Applicant Company Name",null,"IN","Indiana",null,null,"TN","Tennessee",null,null,null,false,"KY","Kentucky","Z","Z",null,"Indiana","Go to IN"]
[null,null,null,"KS","Kansas",null,null,"TX","Texas",null,null,null,false,"LA","Louisiana","Z","Z",null,"Kansas","Go to KS"]
["Year 1:",null,null,"KY","Kentucky",null,null,"UT","Utah",null,null,null,false,"MA","Massachusetts","Z","Z",null,"Kentucky","Go to KY"]
[null,null,null,"LA","Louisiana",null,null,"VA","Virginia",null,null,null,false,"MD","Maryland","Z","Z",null,"Louisiana","Go to LA"]
["Year 2:",{"$f":"B23+1","v":1},null,"MA","Massachusetts",null,null,"VI","U.S. Virgin Islands",null,null,null,false,"ME","Maine","Z","Z",null,"Massachusetts","Go to MA"]
[null,null,null,"MD","Maryland",null,null,"VT","Vermont",null,null,null,false,"MI","Michigan","Z","Z",null,"Maryland","Go to MD"]
["Year 3:",{"$f":"B23+2","v":2},null,"ME","Maine",null,null,"WA","Washington",null,null,null,false,"MN","Minnesota","Z","Z",null,"Maine","Go to ME"]
[null,null,null,"MI","Michigan",null,null,"WI","Wisconsin",null,null,null,false,"MO","Missouri","Z","Z",null,"Michigan","Go to MI"]
[null,null,null,"MN","Minnesota",null,null,"WV","West Virginia",null,null,null,false,"MS","Mississippi","Z","Z",null,"Minnesota","Go to MN"]
[null,null,null,"MO","Missouri",null,null,"WY","Wyoming",null,null,null,false,"MT","Montana","Z","Z",null,"Missouri","Go to MO"]
[null,null,null,"MS","Mississippi",null,null,null,null,null,null,null,false,"NC","North Carolina","Z","Z",null,"Mississippi","Go to MS"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"ND","North Dakota","Z","Z",null,"Montana","Go to MT"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"NE","Nebraska","Z","Z",null,"North Carolina","Go to NC"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"NH","New Hampshire","Z","Z",null,"North Dakota","Go to ND"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"NJ","New Jersey","Z","Z",null,"Nebraska","Go to NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"NM","New Mexico","Z","Z",null,"New Hampshire","Go to NH"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"NV","Nevada","Z","Z",null,"New Jersey","Go to NJ"]
["Updated: 08/18/2014",null,null,null,null,null,null,null,null,null,null,null,false,"NY","New York","Z","Z",null,"New Mexico","Go to NM"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"OH","Ohio","Z","Z",null,"Nevada","Go to NV"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"OK","Oklahoma","Z","Z",null,"New York","Go to NY"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"OR","Oregon","Z","Z",null,"Ohio","Go to OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"PA","Pennsylvania","Z","Z",null,"Oklahoma","Go to OK"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"PR","Puerto Rico","Z","Z",null,"Oregon","Go to OR"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"RI","Rhode Island","Z","Z",null,"Pennsylvania","Go to PA"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"SC","South Carolina","Z","Z",null,"Puerto Rico","Go to PR"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"SD","South Dakota","Z","Z",null,"Rhode Island","Go to RI"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"TN","Tennessee","Z","Z",null,"South Carolina","Go to SC"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"TX","Texas","Z","Z",null,"South Dakota","Go to SD"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"UT","Utah","Z","Z",null,"Tennessee","Go to TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"VA","Virginia","Z","Z",null,"Texas","Go to TX"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"VI","U.S. Virgin Islands","Z","Z",null,"Utah","Go to UT"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"VT","Vermont","Z","Z",null,"Virginia","Go to VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"WA","Washington","Z","Z",null,"U.S. Virgin Islands","Go to VI"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"WI","Wisconsin","Z","Z",null,"Vermont","Go to VT"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"WV","West Virginia","Z","Z",null,"Washington","Go to WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"WY","Wyoming","Z","Z",null,"Wisconsin","Go to WI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West Virginia","Go to WV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wyoming","Go to WY"]

{"sheet":"Balance Sheet","index":1,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,7,0,12]]}
[null,null,null,null,"Company Name:",null,null,{"$f":"Intro!B21","v":"Applicant Company Name"}]
[null,null,null,null,"(Property & Casualty Insurance Company)"]
[null,null,null,null,"Pro Forma Statutory Balance Sheet"]
[null,null,null,null,"(In Thousands)"]
[]
[]
[]
[null,null,null,{"$f":"Intro!B23","v":0},null,null,null,null,null,null,{"$f":"Intro!B25","v":1},null,null,null,null,null,null,{"$f":"Intro!B27","v":2}]
["Admitted Assets"]
["-------------------"]
["1.   Bonds"]
["2.  Common Stock"]
["3.  Real Estate/Mortgage Loans"]
["4.  Affiliated Investments"]
["5.  Affiliated Receivables"]
["6.  Cash/Cash Equivalents"]
["7.  All assets other than investments"]
["8.  Total Admitted Assets",null,null,{"$f":"SUM(D11:D17)","v":0},null,null,null,null,null,null,{"$f":"SUM(K11:K17)","v":0},null,null,null,null,null,null,{"$f":"SUM(R11:R17)","v":0}]
[]
[]
[]
["Liabilities"]
["-------------------"]
["9.   Losses (Case & IBNR)"]
["10.   Loss Adjustment Expenses"]
["11.  Unearned Premiums"]
["12.  Ceded Reinsurance Payable"]
["13.  Payable to Parents, Subsidiaries & Affiliates"]
["14.  All Other Liabilities"]
["15.  Total Liabilities(9+10+11+12+13+14)",null,null,{"$f":"SUM(D24:D29)","v":0},null,null,null,null,null,null,{"$f":"SUM(K24:K29)","v":0},null,null,null,null,null,null,{"$f":"SUM(R24:R29)","v":0}]
[]
["Capital and Surplus"]
["-------------------"]
["16.  Capital Stock"]
["17.  Gross Paid in and Contributed Surplus"]
["18.  Surplus Notes"]
["19.  Unassigned Surplus"]
["20.  Other Items(elaborate)"]
["21. Total Capital and Surplus(16+17+18+19+20) ",null,null,{"$f":"SUM(D34:D38)","v":0},null,null,null,null,null,null,{"$f":"SUM(K34:K38)","v":0},null,null,null,null,null,null,{"$f":"SUM(R34:R38)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,"Risk-Based Capital Analysis"]
[]
["22. Authorized Control Level Risk-Based Capital"]
["23. Calculated Risk-Based Capital (21/22)",null,null,{"$f":"IF(D45=0,0,D39/D45)","v":0},null,null,null,null,null,null,{"$f":"IF(K45=0,0,K39/K45)","v":0},null,null,null,null,null,null,{"$f":"IF(R45=0,0,R39/R45)","v":0}]
["    "]

{"sheet":"P & L","index":2,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,7,0,10]]}
[null,null,null,null,null,"Company Name:",null,{"$f":"Intro!B21","v":"Applicant Company Name"}]
[null,null,null,null,null,"(Property & Casualty Insurance Company)"]
[null,null,null,null,null,"Pro Forma Statutory Profit & Loss Statement"]
[null,null,null,null,null,"(In Thousands)"]
[]
[null,null,null,null,{"$f":"Intro!B23","v":0},null,null,null,{"$f":"Intro!B25","v":1},null,null,null,{"$f":"Intro!B27","v":2}]
[]
[null,"1.  Net Premiums Earned",null,null,0]
[null,"2.  Net Losses Incurred (Case & IBNR)",null,null,0]
[null,"3.  Net Loss Adjustment Expenses Incurred",null,null,0]
[null,"4.  Direct and Assumed Commissions & Brokerage",null,null,0]
[null,"5.  Reinsurance Ceding Commissions",null,null,0]
[null,"6.  Net Commissions Incurred (4-5)",null,null,{"$f":"IF(E8=\" \",\" \",E11-E12)","v":0},null,null,null,{"$f":"IF(I8=\" \",\" \",I11-I12)","v":0},null,null,null,{"$f":"IF(M8=\" \",\" \",M11-M12)","v":0}]
[null,"7.  Other Contractual Agreements*",null,null,0,null,null,null,0]
[null,"8.  Other Underwriting Expenses Incurred**",null,null,0]
[null,"9.  Underwriting Gain (Loss) (1-(2+3+6+7+8))",null,null,{"$f":"E8-(E9+E10+E13+E14+E15)","v":0},null,null,null,{"$f":"I8-(I9+I10+I13+I14+I15)","v":0},null,null,null,{"$f":"M8-(M9+M10+M13+M14+M15)","v":0}]
[]
[null,"10. Net Investment Income",null,null,0]
[null,"11. Other Income",null,null,0]
[null,"12.  Income Taxes Incurred",null,null,0,null,null,null,0]
[null,"13. Net Operating Income (Loss) after taxes",null,null,{"$f":"IF(E16=\" \",\" \",E16+E18+E19-E20)","v":0},null,null,null,{"$f":"IF(I16=\" \",\" \",I16+I18+I19-I20)","v":0},null,null,null,{"$f":"IF(M16=\" \",\" \",M16+M18+M19-M20)","v":0}]
[]
[null,"14.  Prior YE Surplus"]
[null,"15.  Net Income",null,null,{"$f":"E21","v":0},null,null,null,{"$f":"I21","v":0},null,null,null,{"$f":"M21","v":0}]
[null,"16.  Capital Increases"]
[null,"17.  Other Increases (Decreases)",null,null,0]
[null,"18.  Dividends to Stockholders"]
[null,"19.  YE Surplus",null,null,{"$f":"E23+E24+E25+E26-E27","v":0},null,null,null,{"$f":"I23+I24+I25+I26-I27","v":0},null,null,null,{"$f":"M23+M24+M25+M26-M27","v":0}]
[]
[null,"      Operating Percentages:"]
[null,"       Net Premiums Earned",null,null,1,null,null,null,1,null,null,null,1]
[]
[null,"20. Net Losses Incurred to Net Premiums Earned(2/1)",null,null,{"$f":"IF(E8=0,0,E9/E8)","v":0},null,null,null,{"$f":"IF(I8=0,0,I9/I8)","v":0},null,null,null,{"$f":"IF(M8=0,0,M9/M8)","v":0}]
[]
[null,"21. Net Loss Adjustment Expenses Incurred to Net Premiums Earned(3/1)",null,null,{"$f":"IF(E8=0,0,E10/E8)","v":0},null,null,null,{"$f":"IF(I8=0,0,I10/I8)","v":0},null,null,null,{"$f":"IF(M8=0,0,M10/M8)","v":0}]
[]
[null,"22. Other Underwriting Expenses to Net Premiums Earned ((6+7+8)/1)",null,null,{"$f":"IF(E8=0,0,(E13+E14+E15)/E8)","v":0},null,null,null,{"$f":"IF(I8=0,0,(I13+I14+I15)/I8)","v":0},null,null,null,{"$f":"IF(M8=0,0,(M13+M14+M15)/M8)","v":0}]
[]
[null,"23. Net Underwriting Gain Or (Loss) (9/1)",null,null,{"$f":"IF(E8=0,0,E16/E8)","v":0},null,null,null,{"$f":"IF(I8=0,0,I16/I8)","v":0},null,null,null,{"$f":"IF(M8=0,0,M16/M8)","v":0}]
[]
[null,"      Other Percentages:"]
[]
[null,"24. Other Underwriting Expenses to Net Premiums Written"]
[null,"      ((6+7+8)/Total Net Premiums Written))",null,null,{"$f":"IF('Nationwide Premium by LOB'!L70=0,0,(E13+E14+E15)/('Nationwide Premium by LOB'!L70/1000))","v":0},null,null,null,{"$f":"IF('Nationwide Premium by LOB'!L143=0,0,(I13+I14+I15)/('Nationwide Premium by LOB'!L143/1000))","v":0},null,null,null,{"$f":"IF('Nationwide Premium by LOB'!L215=0,0,(M13+M14+M15)/('Nationwide Premium by LOB'!L215/1000))","v":0}]
[]
[null,"25. Net Loss and Loss Adjustment Expenses Incurred to"]
[null,"      Net Premiums Earned ((2+3)/1)",null,null,{"$f":"IF(E8=0,0,(E9+E10)/E8)","v":0},null,null,null,{"$f":"IF(I8=0,0,(I9+I10)/I8)","v":0},null,null,null,{"$f":"IF(M8=0,0,(M9+M10)/M8)","v":0}]
[]
[]
[]
[]
[]
[null,"*ie... MGA(excluding amounts included above as agents commissions), service contracts, claims payment contracts"]
[null,"**   Itemize in assumptions"]

{"sheet":"Cash Flow","index":3,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,7,0,10]]}
[null,null,null,null,null,"Company Name:",null,{"$f":"Intro!B21","v":"Applicant Company Name"}]
[null,null,null,null,null,"(Property & Casualty Insurance Company)"]
[null,null,null,null,null,"Pro Forma Statutory Cash Flow Statement"]
[null,null,null,null,null,"(In Thousands)"]
[]
[null,null,null,null,{"$f":"Intro!B23","v":0},null,null,null,{"$f":"Intro!B25","v":1},null,null,null,{"$f":"Intro!B27","v":2}]
[null,"Cash From Operations"]
[null,"1.  Premiums Collected Net of Reinsurance"]
[null,"2.  Loss and Loss Adjustments Expenses Paid (Net of S&S)"]
[null,"3.  Underwriting Expenses Paid"]
[null,"4.  Other Underwriting Income(expenses)"]
[null,"5.  Total Cash From Underwriting(1-2-3+4)",null,null,{"$f":"E8-E9-E10+E11","v":0},null,null,null,{"$f":"I8-I9-I10+I11","v":0},null,null,null,{"$f":"M8-M9-M10+M11","v":0}]
[]
[null,"6.  Net Investment Income"]
[null,"7.  Other Income"]
[null,"8.  Dividends to Policyholders",null,null,0]
[null,"9.  Federal and Foreign Income Taxes (Paid) Recovered"]
[null,"10. Net Cash From Operations(5+6+7-8+9)",null,null,{"$f":"E12+E14+E15-E16+E17","v":0},null,null,null,{"$f":"I12+I14+I15-I16+I17","v":0},null,null,null,{"$f":"M12+M14+M15-M16+M17","v":0}]
[]
[null,"Cash From Investments"]
[null,"11. Net Cash from Investments"]
[]
[]
[null,"Cash From Financing and Misc Sources"]
[null,"12. Capital and Paid in Surplus"]
[null,"13.  Surplus Notes"]
[null,"14.  Borrowed Funds"]
[null,"15.  Dividends"]
[null,"16.  Other Cash Provided (applied)"]
[null,"17.  Net Cash from Financing and Misc. Sources",null,null,{"$f":"E25+E26+E27-E28+E29","v":0},null,null,null,{"$f":"I25+I26+I27-I28+I29","v":0},null,null,null,{"$f":"M25+M26+M27-M28+M29","v":0}]
[null,"18.  Net Change in Cash, Cash Equivalents and "]
[null,"     Short-Term  Investments(10+11+17)",null,null,{"$f":"E18+E21+E30","v":0},null,null,null,{"$f":"I18+I21+I30","v":0},null,null,null,{"$f":"M18+M21+M30","v":0}]

{"sheet":"Premium Ratios","index":4,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,7,1,10]]}
[]
[null,null,null,null,"Company Name:",null,null,{"$f":"Intro!B21","v":"Applicant Company Name"}]
[null,"Nationwide",null,null,"(Property & Casualty Insurance Company)"]
[null,null,null,null,"Premiums Written to Surplus Ratios"]
[null,null,null,null,"Amounts in Whole Dollars"]
[]
["Year","Direct",null,"Assumed ",null,"Gross ",null,"Ceded",null,"Net",null,"Gross",null,"Net"]
[null,"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums",null,"Premiums ",null,"Written Premiums",null,"Written Premiums"]
[null,"Written",null,"Written",null,"Written",null,"Written",null,"Written",null,"to Surplus",null,"to Surplus"]
[null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------"]
[]
[]
[{"$f":"Intro!B23","v":0},{"$f":"+'Nationwide Premium by LOB'!F70","v":0},null,{"$f":"'Nationwide Premium by LOB'!H70","v":0},null,{"$f":"B13+D13","v":0},null,{"$f":"'Nationwide Premium by LOB'!J70","v":0},null,{"$f":"F13-H13","v":0},null,{"$f":"IF('Balance Sheet'!$D$39=0,0,'Premium Ratios'!F13/'Balance Sheet'!$D$39/1000)","v":0},null,{"$f":"IF('Balance Sheet'!$D$39=0,0,'Premium Ratios'!J13/'Balance Sheet'!$D$39/1000)","v":0}]
[]
[]
[{"$f":"Intro!B25","v":1},{"$f":"'Nationwide Premium by LOB'!F143","v":0},null,{"$f":"'Nationwide Premium by LOB'!H143","v":0},null,{"$f":"B16+D16","v":0},null,{"$f":"'Nationwide Premium by LOB'!J143","v":0},null,{"$f":"F16-H16","v":0},null,{"$f":"IF('Balance Sheet'!$K$39=0,0,'Premium Ratios'!F16/'Balance Sheet'!$K$39/1000)","v":0},null,{"$f":"IF('Balance Sheet'!$K$39=0,0,'Premium Ratios'!J16/'Balance Sheet'!$K$39/1000)","v":0}]
[]
[]
[{"$f":"Intro!B27","v":2},{"$f":"'Nationwide Premium by LOB'!F215","v":0},null,{"$f":"'Nationwide Premium by LOB'!H215","v":0},null,{"$f":"B19+D19","v":0},null,{"$f":"'Nationwide Premium by LOB'!J215","v":0},null,{"$f":"F19-H19","v":0},null,{"$f":"IF('Balance Sheet'!$R$39=0,0,'Premium Ratios'!F19/'Balance Sheet'!$R$39/1000)","v":0},null,{"$f":"IF('Balance Sheet'!$R$39=0,0,'Premium Ratios'!J19/'Balance Sheet'!$R$39/1000)","v":0}]

{"sheet":"Nationwide Premium by LOB","index":5,"n_rows":216,"n_cols":22,"rows_kept":216,"cut":false,"hidden":false,"merged":[[3,7,3,11],[76,7,76,11],[148,7,148,11]]}
[]
[]
[]
[null,"Nationwide",null,null,"Company Name:",null,null,{"$f":"Intro!$B$21","v":"Applicant Company Name"}]
[null,"Year 1",null,{"$f":"Intro!B23","v":0},"(Property & Casualty Insurance Company)"]
[null,null,null,null,"Planned Premium Volume By Line of Business"]
[null,null,null,null,"Amounts in Whole Dollars"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mult","Adjusted ","Adjusted "]
[null,"Annual",null,null,null,"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"Gross","Net","Direct",null,"Assumed",null,"Ceded",null,"Net"]
[null,"Statement",null,null,null,"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,null,null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums"]
[null,"Line",null,"Description",null,"Written",null,"Written",null,"Written",null,"Written",null,null,null,"Earned",null,"Earned",null,"Earned",null,"Earned"]
[null,"---------",null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------",null,null,null,"---------",null,"---------",null,"---------",null,"---------"]
[null,1,null,"Fire",null,null,null,null,null,null,null,{"$f":"F13+H13-J13","v":0},{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$f":"(F13+H13)*M13","v":{"$error":"#REF!"}},{"$f":"L13*M13","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"P13+R13-T13","v":0}]
[null,2.1,null,"Allied Lines",null,null,null,null,null,null,null,{"$f":"F14+H14-J14","v":0},{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$f":"(F14+H14)*M14","v":{"$error":"#REF!"}},{"$f":"L14*M14","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"P14+R14-T14","v":0}]
[null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,8,null,"Ocean Marine",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,9,null,"Inland Marine",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,12,null,"Earthquake",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,13,null,"Group A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.4,null,"Non-Renew-Stated Reasons Only A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,{"$f":"F35+H35-J35","v":0},{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$f":"(F35+H35)*M35","v":{"$error":"#REF!"}},{"$f":"L35*M35","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"P35+R35-T35","v":0}]
[null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,23,null,"Fidelity",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,24,null,"Surety",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,28,null,"Credit",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,28,null,"Credit Disability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,30,null,"Warranty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Bail Bonds",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Glass",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Title",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Livestock",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Reinsurance",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Other - Property",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Other - Casualty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Other ",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,null,null,null,null,"___________",null,"___________",null,"___________",null,"___________",null,"___________","___________","___________",null,"___________",null,"___________",null,"___________"]
[null,null,null,"Total",null,{"$f":"SUM(F13:F68)","v":0},null,{"$f":"SUM(H13:H68)","v":0},null,{"$f":"SUM(J13:J68)","v":0},null,{"$f":"SUM(L13:L68)","v":0},null,{"$f":"SUM(N13:N68)","v":{"$error":"#REF!"}},{"$f":"SUM(O13:O68)","v":{"$error":"#REF!"}},{"$f":"SUM(P13:P68)","v":0},null,{"$f":"SUM(R13:R68)","v":0},null,{"$f":"SUM(T13:T68)","v":0},null,{"$f":"SUM(V13:V68)","v":0}]
[null,null,null,null,null,"==========",null,"==========",null,"==========",null,"==========",null,"==========","==========","==========",null,"==========",null,"==========",null,"=========="]
[]
[]
[]
[]
[]
[null,"Nationwide",null,null,"Company Name:",null,null,{"$f":"Intro!$B$21","v":"Applicant Company Name"}]
[null,"Year 2",null,{"$f":"Intro!B25","v":1},"(Property & Casualty Insurance Company)"]
[null,null,null,null,"Planned Premium Volume By Line of Business"]
[null,null,null,null,"Amounts in Whole Dollars"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mult","Adjusted ","Adjusted "]
[null,"Annual",null,null,null,"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"Gross","Net","Direct",null,"Assumed",null,"Ceded",null,"Net"]
[null,"Statement",null,null,null,"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,null,null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums"]
[null,"Line",null,"Description",null,"Written",null,"Written",null,"Written",null,"Written",null,null,null,"Earned",null,"Earned",null,"Earned",null,"Earned"]
[null,"---------",null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------",null,null,null,"---------",null,"---------",null,"---------",null,"---------"]
[null,1,null,"Fire",null,null,null,null,null,null,null,{"$f":"F86+H86-J86","v":0},{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$f":"(F86+H86)*M86","v":{"$error":"#REF!"}},{"$f":"L86*M86","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"P86+R86-T86","v":0}]
[null,2.1,null,"Allied Lines",null,null,null,null,null,null,null,{"$f":"F87+H87-J87","v":0},{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$f":"(F87+H87)*M87","v":{"$error":"#REF!"}},{"$f":"L87*M87","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"P87+R87-T87","v":0}]
[null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,8,null,"Ocean Marine",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,9,null,"Inland Marine",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,12,null,"Earthquake",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,13,null,"Group A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.4,null,"Non-Renew-Stated Reasons Only A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,23,null,"Fidelity",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,24,null,"Surety",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,28,null,"Credit",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,28,null,"Credit Disability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,30,null,"Warranty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Bail Bonds",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Glass",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Title",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Livestock",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Reinsurance",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Other - Property",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Other - Casualty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Other ",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,null,null,null,null,"___________",null,"___________",null,"___________",null,"___________",null,null,null,"___________",null,"___________",null,"___________",null,"___________"]
[null,null,null,"Total",null,{"$f":"SUM(F86:F141)","v":0},null,{"$f":"SUM(H86:H141)","v":0},null,{"$f":"SUM(J86:J141)","v":0},null,{"$f":"SUM(L86:L141)","v":0},null,{"$f":"SUM(N86:N141)","v":{"$error":"#REF!"}},{"$f":"SUM(O86:O141)","v":{"$error":"#REF!"}},{"$f":"SUM(P86:P141)","v":0},null,{"$f":"SUM(R86:R141)","v":0},null,{"$f":"SUM(T86:T141)","v":0},null,{"$f":"SUM(V86:V141)","v":0}]
[null,null,null,null,null,"==========",null,"==========",null,"==========",null,"==========",null,"==========","==========","==========",null,"==========",null,"==========",null,"=========="]
[]
[]
[]
[]
[null,"Nationwide",null,null,"Company Name:",null,null,{"$f":"Intro!$B$21","v":"Applicant Company Name"}]
[null,"Year 3",null,{"$f":"Intro!B27","v":2},"(Property & Casualty Insurance Company)"]
[null,null,null,null,"Planned Premium Volume By Line of Business"]
[null,null,null,null,"Amounts in Whole Dollars"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mult","Adjusted ","Adjusted "]
[null,"Annual",null,null,null,"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"Gross","Net","Direct",null,"Assumed",null,"Ceded",null,"Net"]
[null,"Statement",null,null,null,"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,null,null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums"]
[null,"Line",null,"Description",null,"Written",null,"Written",null,"Written",null,"Written",null,null,null,"Earned",null,"Earned",null,"Earned",null,"Earned"]
[null,"---------",null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------",null,null,null,"---------",null,"---------",null,"---------",null,"---------"]
[null,1,null,"Fire",null,null,null,null,null,null,null,{"$f":"F158+H158-J158","v":0},{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$f":"(F158+H158)*M158","v":{"$error":"#REF!"}},{"$f":"L158*M158","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"P158+R158-T158","v":0}]
[null,2.1,null,"Allied Lines",null,null,null,null,null,null,null,{"$f":"F159+H159-J159","v":0},{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$f":"(F159+H159)*M159","v":{"$error":"#REF!"}},{"$f":"L159*M159","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"P159+R159-T159","v":0}]
[null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,8,null,"Ocean Marine",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,9,null,"Inland Marine",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,12,null,"Earthquake",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,13,null,"Group A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.4,null,"Non-Renew-Stated Reasons Only A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,23,null,"Fidelity",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,24,null,"Surety",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,28,null,"Credit",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,28,null,"Credit Disability",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,30,null,"Warranty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Bail Bonds",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Glass",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Title",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Livestock",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Reinsurance",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Other - Property",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Other - Casualty",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,34,null,"Other ",null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(#REF!,#REF!,#REF!,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,0]
[null,null,null,null,null,"___________",null,"___________",null,"___________",null,"___________",null,"___________","___________","___________",null,"___________",null,"___________",null,"___________"]
[null,null,null,"Total",null,{"$f":"SUM(F158:F213)","v":0},null,{"$f":"SUM(H158:H213)","v":0},null,{"$f":"SUM(J158:J213)","v":0},null,{"$f":"SUM(L158:L213)","v":0},null,{"$f":"SUM(N158:N213)","v":{"$error":"#REF!"}},{"$f":"SUM(O158:O213)","v":{"$error":"#REF!"}},{"$f":"SUM(P158:P213)","v":0},null,{"$f":"SUM(R158:R213)","v":0},null,{"$f":"SUM(T158:T213)","v":0},null,{"$f":"SUM(V158:V213)","v":0}]
[null,null,null,null,null,"==========",null,"==========",null,"==========",null,"==========",null,"==========","==========","==========",null,"==========",null,"==========",null,"=========="]

{"sheet":"Nationwide Incurred Loss by LOB","index":6,"n_rows":224,"n_cols":12,"rows_kept":224,"cut":false,"hidden":false,"merged":[[4,5,4,8],[79,5,79,8],[153,5,153,8]]}
[]
[]
[]
[]
[null,"Nationwide",null,null,"Company Name:",{"$f":"Intro!$B$21","v":"Applicant Company Name"}]
[null,"Year 1",null,{"$f":"Intro!B23","v":0},"(Property & Casualty Insurance Company)"]
[null,null,null,null,"Incurred Loss Summary By Line of Business"]
[null,null,null,null,"Amounts in Whole Dollars"]
[]
[null,"Annual",null,null,null,"Direct",null,"Assumed ",null,"Ceded",null,"Net"]
[null,"Statement",null,null,null,"Losses ",null,"Losses",null,"Losses",null,"Losses"]
[null,"Line",null,"Description",null,"Incurred*",null,"Incurred*",null,"Incurred*",null,"Incurred*"]
[null,"---------",null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
[null,1,null,"Fire",null,null,null,null,null,null,null,{"$f":"F14+H14-J14","v":0}]
[null,2,null,"Allied Lines",null,null,null,null,null,null,null,{"$f":"F15+H15-J15","v":0}]
[null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,0]
[null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,0]
[null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,0]
[null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,0]
[null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,0]
[null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,0]
[null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,0]
[null,8,null,"Ocean Marine",null,null,null,null,null,null,null,0]
[null,9,null,"Inland Marine",null,null,null,null,null,null,null,0]
[null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,0]
[null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,0]
[null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,0]
[null,12,null,"Earthquake",null,null,null,null,null,null,null,0]
[null,13,null,"Group A&H",null,null,null,null,null,null,null,0]
[null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,0]
[null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,0]
[null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,0]
[null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,0]
[null,15.4,null,"Non-Renew - Stated Reasons Only A&H",null,null,null,null,null,null,null,0]
[null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,0]
[null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,0]
[null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,0]
[null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,0]
[null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,0]
[null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,0]
[null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,0]
[null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,0]
[null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,0]
[null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,0]
[null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,0]
[null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,0]
[null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,0]
[null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,0]
[null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,0]
[null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,0]
[null,23,null,"Fidelity",null,null,null,null,null,null,null,0]
[null,24,null,"Surety",null,null,null,null,null,null,null,0]
[null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,0]
[null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,0]
[null,28,null,"Credit",null,null,null,null,null,null,null,0]
[null,28,null,"Credit Disability",null,null,null,null,null,null,null,0]
[null,30,null,"Warranty",null,null,null,null,null,null,null,0]
[null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,0]
[null,34,null,"Bail Bonds",null,null,null,null,null,null,null,0]
[null,34,null,"Glass",null,null,null,null,null,null,null,0]
[null,34,null,"Title",null,null,null,null,null,null,null,0]
[null,34,null,"Livestock",null,null,null,null,null,null,null,0]
[null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,0]
[null,34,null,"Reinsurance",null,null,null,null,null,null,null,0]
[null,34,null,"Other",null,null,null,null,null,null,null,0]
[null,34,null,"Other",null,null,null,null,null,null,null,0]
[null,34,null,"Other",null,null,null,null,null,null,null,{"$f":"F69+H69-J69","v":0}]
[null,null,null,null,null,"_________",null,"_________",null,"_________",null,"_________"]
[]
[null,null,null,"Total",null,{"$f":"SUM(F14:F69)","v":0},null,{"$f":"SUM(H14:H69)","v":0},null,{"$f":"SUM(J14:J69)","v":0},null,{"$f":"SUM(L14:L69)","v":0}]
[null,null,null,"Verification from P & L",null,"=========",null,"=========",null,"=========",null,{"$f":"('P & L'!E9+'P & L'!E10)*1000","v":0}]
[]
[null,null,"* Include loss adjustment expenses."]
[]
[]
[]
[]
[null,"Nationwide",null,null,"Company Name:",{"$f":"Intro!$B$21","v":"Applicant Company Name"}]
[null,"Year 2",null,{"$f":"Intro!B25","v":1},"(Property & Casualty Insurance Company)"]
[null,null,null,null,"Incurred Loss Summary By Line of Business"]
[null,null,null,null,"Amounts in Whole Dollars"]
[]
[null,"Annual",null,null,null,"Direct",null,"Assumed ",null,"Ceded",null,"Net"]
[null,"Statement",null,null,null,"Losses ",null,"Losses",null,"Losses",null,"Losses"]
[null,"Line",null,"Description",null,"Incurred*",null,"Incurred*",null,"Incurred*",null,"Incurred*"]
[null,"---------",null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
[null,1,null,"Fire",null,null,null,null,null,null,null,{"$f":"F89+H89-J89","v":0}]
[null,2,null,"Allied Lines",null,null,null,null,null,null,null,{"$f":"F90+H90-J90","v":0}]
[null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,0]
[null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,0]
[null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,0]
[null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,0]
[null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,0]
[null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,0]
[null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,0]
[null,8,null,"Ocean Marine",null,null,null,null,null,null,null,0]
[null,9,null,"Inland Marine",null,null,null,null,null,null,null,0]
[null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,0]
[null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,0]
[null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,0]
[null,12,null,"Earthquake",null,null,null,null,null,null,null,0]
[null,13,null,"Group A&H",null,null,null,null,null,null,null,0]
[null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,0]
[null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,0]
[null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,0]
[null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,0]
[null,15.4,null,"Non-Renew - Stated Reasons Only A&H",null,null,null,null,null,null,null,0]
[null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,0]
[null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,0]
[null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,0]
[null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,0]
[null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,0]
[null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,0]
[null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,0]
[null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,0]
[null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,0]
[null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,{"$f":"F119+H119-J119","v":0}]
[null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,0]
[null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,0]
[null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,0]
[null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,0]
[null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,0]
[null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,0]
[null,23,null,"Fidelity",null,null,null,null,null,null,null,0]
[null,24,null,"Surety",null,null,null,null,null,null,null,0]
[null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,0]
[null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,0]
[null,28,null,"Credit",null,null,null,null,null,null,null,0]
[null,28,null,"Credit Disability",null,null,null,null,null,null,null,0]
[null,30,null,"Warranty",null,null,null,null,null,null,null,0]
[null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,0]
[null,34,null,"Bail Bonds",null,null,null,null,null,null,null,0]
[null,34,null,"Glass",null,null,null,null,null,null,null,0]
[null,34,null,"Title",null,null,null,null,null,null,null,0]
[null,34,null,"Livestock",null,null,null,null,null,null,null,0]
[null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,0]
[null,34,null,"Reinsurance",null,null,null,null,null,null,null,0]
[null,34,null,"Other",null,null,null,null,null,null,null,0]
[null,34,null,"Other",null,null,null,null,null,null,null,0]
[null,34,null,"Other",null,null,null,null,null,null,null,0]
[null,null,null,null,null,"_________",null,"_________",null,"_________",null,"_________"]
[]
[null,null,null,"Total",null,{"$f":"SUM(F89:F144)","v":0},null,{"$f":"SUM(H89:H144)","v":0},null,{"$f":"SUM(J89:J144)","v":0},null,{"$f":"SUM(L89:L144)","v":0}]
[null,null,null,"Verification from P & L",null,"=========",null,"=========",null,"=========",null,{"$f":"('P & L'!I9+'P & L'!I10)*1000","v":0}]
[]
[null,null,"* Include loss adjustment expenses."]
[]
[]
[]
[null,"Nationwide",null,null,"Company Name:",{"$f":"Intro!$B$21","v":"Applicant Company Name"}]
[null,"Year 3",null,{"$f":"Intro!B27","v":2},"(Property & Casualty Insurance Company)"]
[null,null,null,null,"Incurred Loss Summary By Line of Business"]
[null,null,null,null,"Amounts in Whole Dollars"]
[]
[null,"Annual",null,null,null,"Direct",null,"Assumed ",null,"Ceded",null,"Net"]
[null,"Statement",null,null,null,"Losses ",null,"Losses",null,"Losses",null,"Losses"]
[null,"Line",null,"Description",null,"Incurred*",null,"Incurred*",null,"Incurred*",null,"Incurred*"]
[null,"---------",null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
[null,1,null,"Fire",null,null,null,null,null,null,null,{"$f":"F163+H163-J163","v":0}]
[null,2,null,"Allied Lines",null,null,null,null,null,null,null,{"$f":"F164+H164-J164","v":0}]
[null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,0]
[null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,0]
[null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,0]
[null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,0]
[null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,0]
[null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,0]
[null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,0]
[null,8,null,"Ocean Marine",null,null,null,null,null,null,null,0]
[null,9,null,"Inland Marine",null,null,null,null,null,null,null,0]
[null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,0]
[null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,0]
[null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,0]
[null,12,null,"Earthquake",null,null,null,null,null,null,null,0]
[null,13,null,"Group A&H",null,null,null,null,null,null,null,0]
[null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,0]
[null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,0]
[null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,0]
[null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,0]
[null,15.4,null,"Non-Renew - Stated Reasons Only A&H",null,null,null,null,null,null,null,0]
[null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,0]
[null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,0]
[null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,0]
[null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,0]
[null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,0]
[null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,0]
[null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,0]
[null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,0]
[null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,0]
[null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,0]
[null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,0]
[null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,0]
[null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,0]
[null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,0]
[null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,0]
[null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,0]
[null,23,null,"Fidelity",null,null,null,null,null,null,null,0]
[null,24,null,"Surety",null,null,null,null,null,null,null,0]
[null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,0]
[null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,0]
[null,28,null,"Credit",null,null,null,null,null,null,null,0]
[null,28,null,"Credit Disability",null,null,null,null,null,null,null,0]
[null,30,null,"Warranty",null,null,null,null,null,null,null,0]
[null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,0]
[null,34,null,"Bail Bonds",null,null,null,null,null,null,null,0]
[null,34,null,"Glass",null,null,null,null,null,null,null,0]
[null,34,null,"Title",null,null,null,null,null,null,null,0]
[null,34,null,"Livestock",null,null,null,null,null,null,null,0]
[null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,0]
[null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,0]
[null,34,null,"Reinsurance",null,null,null,null,null,null,null,0]
[null,34,null,"Other",null,null,null,null,null,null,null,0]
[null,34,null,"Other",null,null,null,null,null,null,null,0]
[null,34,null,"Other",null,null,null,null,null,null,null,0]
[null,null,null,null,null,"_________",null,"_________",null,"_________",null,"_________"]
[]
[null,null,null,"Total",null,{"$f":"SUM(F163:F218)","v":0},null,{"$f":"SUM(H163:H218)","v":0},null,{"$f":"SUM(J163:J218)","v":0},null,{"$f":"SUM(L163:L218)","v":0}]
[null,null,null,"Verification from P & L",null,"=========",null,"=========",null,"=========",null,{"$f":"('P & L'!M9+'P & L'!M10)*1000","v":0}]
[]
[null,null,"* Include loss adjustment expenses."]

{"sheet":"Nation Net Prem & Loss Dev LOB","index":7,"n_rows":73,"n_cols":22,"rows_kept":73,"cut":false,"hidden":false,"merged":[[2,7,2,12]]}
[]
[]
[null,"Nationwide",null,null,"Company Name:",null,null,{"$f":"Intro!B21","v":"Applicant Company Name"}]
[null,null,null,null,"(Property & Casualty Insurance Company)"]
[null,null,null,null,"Net Premium and Loss Developments By Line of Business",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Amounts in Whole Dollars"]
[]
[null,"Annual",null,null,null,null,null,{"$f":"Intro!B23","v":0},null,null,null,null,null,{"$f":"Intro!B25","v":1},null,null,null,null,null,{"$f":"Intro!B27","v":2}]
[null,"Statement",null,null,null,"Premiums ",null,"Losses ",null,"Loss",null,"Premiums ",null,"Losses ",null,"Loss",null,"Premiums ",null,"Losses ",null,"Loss"]
[null,"Line",null,"Description",null,"Earned",null,"Incurred*",null,"Ratio",null,"Earned",null,"Incurred*",null,"Ratio",null,"Earned",null,"Incurred*",null,"Ratio"]
[null,"---------",null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------"]
[null,1,null,"Fire",null,{"$f":"'Nationwide Premium by LOB'!V13","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L14","v":0},null,{"$f":"IF(F12=0,0,H12/F12)","v":0},null,{"$f":"'Nationwide Premium by LOB'!V86","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L89","v":0},null,{"$f":"IF(L12=0,0,N12/L12)","v":0},null,{"$f":"'Nationwide Premium by LOB'!V158","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L163","v":0},null,{"$f":"IF(R12=0,0,T12/R12)","v":0}]
[null,2.1,null,"Allied Lines",null,{"$f":"'Nationwide Premium by LOB'!V14","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L15","v":0},null,{"$f":"IF(F13=0,0,H13/F13)","v":0},null,{"$f":"'Nationwide Premium by LOB'!V87","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L90","v":0},null,{"$f":"IF(L13=0,0,N13/L13)","v":0},null,{"$f":"'Nationwide Premium by LOB'!V159","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L164","v":0},null,{"$f":"IF(R13=0,0,T13/R13)","v":0}]
[null,2.2000000000000002,null,"Multiple Peril Crop",null,{"$f":"'Nationwide Premium by LOB'!V15","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L16","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V88","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L91","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V160","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L165","v":0},null,0]
[null,2.2999999999999998,null,"Federal Flood",null,{"$f":"'Nationwide Premium by LOB'!V16","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L17","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V89","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L92","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V161","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L166","v":0},null,0]
[null,3,null,"Farmowners Multiple Peril",null,{"$f":"'Nationwide Premium by LOB'!V17","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L18","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V90","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L93","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V162","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L167","v":0},null,0]
[null,4,null,"Homeowners Multiple Peril",null,{"$f":"'Nationwide Premium by LOB'!V18","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L19","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V91","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L94","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V163","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L168","v":0},null,0]
[null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,{"$f":"'Nationwide Premium by LOB'!V19","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L20","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V92","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L95","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V164","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L169","v":0},null,0]
[null,5.2,null,"Commercial Mutiple Peril (Liability Portion)",null,{"$f":"'Nationwide Premium by LOB'!V20","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L21","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V93","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L96","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V165","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L170","v":0},null,0]
[null,6,null,"Mortgage Guaranty",null,{"$f":"'Nationwide Premium by LOB'!V21","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L22","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V94","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L97","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V166","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L171","v":0},null,0]
[null,8,null,"Ocean Marine",null,{"$f":"'Nationwide Premium by LOB'!V22","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L23","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V95","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L98","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V167","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L172","v":0},null,0]
[null,9,null,"Inland Marine",null,{"$f":"'Nationwide Premium by LOB'!V23","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L24","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V96","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L99","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V168","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L173","v":0},null,0]
[null,10,null,"Financial Guaranty",null,{"$f":"'Nationwide Premium by LOB'!V24","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L25","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V97","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L100","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V169","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L174","v":0},null,0]
[null,11.1,null,"Medical Professional Liability - Occurrence",null,{"$f":"'Nationwide Premium by LOB'!V25","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L26","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V98","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L101","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V170","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L175","v":0},null,0]
[null,11.2,null,"Medical Professional Liability - Claims Made",null,{"$f":"'Nationwide Premium by LOB'!V26","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L27","v":0},null,{"$f":"IF(F25=0,0,H25/F25)","v":0},null,{"$f":"'Nationwide Premium by LOB'!V99","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L102","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V171","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L176","v":0},null,{"$f":"IF(R25=0,0,T25/R25)","v":0}]
[null,12,null,"Earthquake",null,{"$f":"'Nationwide Premium by LOB'!V27","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L28","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V100","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L103","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V172","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L177","v":0},null,0]
[null,13,null,"Group A&H",null,{"$f":"'Nationwide Premium by LOB'!V28","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L29","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V101","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L104","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V173","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L178","v":0},null,0]
[null,14,null,"Credit A&H (Group & Individual)",null,{"$f":"'Nationwide Premium by LOB'!V29","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L30","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V102","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L105","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V174","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L179","v":0},null,0]
[null,15.1,null,"Collectively Renewable A&H",null,{"$f":"'Nationwide Premium by LOB'!V30","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L31","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V103","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L106","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V175","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L180","v":0},null,0]
[null,15.2,null,"Non-Cancellable A&H",null,{"$f":"'Nationwide Premium by LOB'!V31","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L32","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V104","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L107","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V176","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L181","v":0},null,0]
[null,15.3,null,"Guaranteed Renewable A&H",null,{"$f":"'Nationwide Premium by LOB'!V32","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L33","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V105","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L108","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V177","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L182","v":0},null,0]
[null,15.4,null,"Non-Renew-Stated Reasons Only A&H",null,{"$f":"'Nationwide Premium by LOB'!V33","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L34","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V106","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L109","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V178","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L183","v":0},null,0]
[null,15.5,null,"Other Accident Only",null,{"$f":"'Nationwide Premium by LOB'!V34","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L35","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V107","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L110","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V179","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L184","v":0},null,0]
[null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,{"$f":"'Nationwide Premium by LOB'!V35","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L36","v":0},null,{"$f":"IF(F34=0,0,H34/F34)","v":0},null,{"$f":"'Nationwide Premium by LOB'!V108","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L111","v":0},null,{"$f":"IF(L34=0,0,N34/L34)","v":0},null,{"$f":"'Nationwide Premium by LOB'!V180","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L185","v":0},null,{"$f":"IF(R34=0,0,T34/R34)","v":0}]
[null,15.7,null,"All Other A&H",null,{"$f":"'Nationwide Premium by LOB'!V36","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L37","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V109","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L112","v":0},null,{"$f":"IF(L35=0,0,N35/L35)","v":0},null,{"$f":"'Nationwide Premium by LOB'!V181","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L186","v":0},null,{"$f":"IF(R35=0,0,T35/R35)","v":0}]
[null,15.8,null,"Federal Employees Health Benefits Program",null,{"$f":"'Nationwide Premium by LOB'!V37","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L38","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V110","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L113","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V182","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L187","v":0},null,0]
[null,16,null,"Workers' Compensation",null,{"$f":"'Nationwide Premium by LOB'!V38","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L39","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V111","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L114","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V183","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L188","v":0},null,0]
[null,17.100000000000001,null,"Other Liability",null,{"$f":"'Nationwide Premium by LOB'!V39","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L40","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V112","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L115","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V184","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L189","v":0},null,0]
[null,17.3,null,"Excess Workers Compensation",null,{"$f":"'Nationwide Premium by LOB'!V40","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L41","v":0},null,{"$f":"IF(F39=0,0,H39/F39)","v":0},null,{"$f":"'Nationwide Premium by LOB'!V113","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L116","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V185","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L190","v":0},null,{"$f":"IF(R39=0,0,T39/R39)","v":0}]
[null,18.100000000000001,null,"Products Liability - Occurrence",null,{"$f":"'Nationwide Premium by LOB'!V41","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L42","v":0},null,{"$f":"IF(F40=0,0,H40/F40)","v":0},null,{"$f":"'Nationwide Premium by LOB'!V114","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L117","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V186","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L191","v":0},null,{"$f":"IF(R40=0,0,T40/R40)","v":0}]
[null,18.2,null,"Products Liability - Claims Made",null,{"$f":"'Nationwide Premium by LOB'!V42","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L43","v":0},null,{"$f":"IF(F41=0,0,H41/F41)","v":0},null,{"$f":"'Nationwide Premium by LOB'!V115","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L118","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V187","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L192","v":0},null,{"$f":"IF(R41=0,0,T41/R41)","v":0}]
[null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,{"$f":"'Nationwide Premium by LOB'!V43","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L44","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V116","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L119","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V188","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L193","v":0},null,0]
[null,19.2,null,"Other Private Passenger Auto Liability",null,{"$f":"'Nationwide Premium by LOB'!V44","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L45","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V117","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L120","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V189","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L194","v":0},null,0]
[null,19.3,null,"Commercial Auto No-Fault (PIP)",null,{"$f":"'Nationwide Premium by LOB'!V45","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L46","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V118","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L121","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V190","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L195","v":0},null,0]
[null,19.399999999999999,null,"Other Commercial Auto Liability",null,{"$f":"'Nationwide Premium by LOB'!V46","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L47","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V119","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L122","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V191","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L196","v":0},null,0]
[null,21.1,null,"Private Passenger Auto Phys Damage",null,{"$f":"'Nationwide Premium by LOB'!V47","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L48","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V120","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L123","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V192","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L197","v":0},null,0]
[null,21.2,null,"Commercial Auto Physical Damage",null,{"$f":"'Nationwide Premium by LOB'!V48","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L49","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V121","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L124","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V193","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L198","v":0},null,0]
[null,22,null,"Aircraft (All Perils)",null,{"$f":"'Nationwide Premium by LOB'!V49","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L50","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V122","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L125","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V194","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L199","v":0},null,0]
[null,23,null,"Fidelity",null,{"$f":"'Nationwide Premium by LOB'!V50","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L51","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V123","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L126","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V195","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L200","v":0},null,0]
[null,24,null,"Surety",null,{"$f":"'Nationwide Premium by LOB'!V51","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L52","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V124","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L127","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V196","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L201","v":0},null,0]
[null,26,null,"Burglary and Theft",null,{"$f":"'Nationwide Premium by LOB'!V52","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L53","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V125","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L128","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V197","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L202","v":0},null,0]
[null,27,null,"Boiler and Machinery",null,{"$f":"'Nationwide Premium by LOB'!V53","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L54","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V126","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L129","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V198","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L203","v":0},null,0]
[null,28,null,"Credit",null,{"$f":"'Nationwide Premium by LOB'!V54","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L55","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V127","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L130","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V199","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L204","v":0},null,0]
[null,28,null,"Credit Disability",null,{"$f":"'Nationwide Premium by LOB'!V55","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L56","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V128","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L131","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V200","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L205","v":0},null,0]
[null,30,null,"Warranty",null,{"$f":"'Nationwide Premium by LOB'!V56","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L57","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V129","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L132","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V201","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L206","v":0},null,0]
[null,34,null,"Prepaid Legal",null,{"$f":"'Nationwide Premium by LOB'!V57","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L58","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V130","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L133","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V202","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L207","v":0},null,0]
[null,34,null,"Bail Bonds",null,{"$f":"'Nationwide Premium by LOB'!V58","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L59","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V131","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L134","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V203","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L208","v":0},null,0]
[null,34,null,"Glass",null,{"$f":"'Nationwide Premium by LOB'!V59","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L60","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V132","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L135","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V204","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L209","v":0},null,0]
[null,34,null,"Title",null,{"$f":"'Nationwide Premium by LOB'!V60","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L61","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V133","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L136","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V205","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L210","v":0},null,0]
[null,34,null,"Livestock",null,{"$f":"'Nationwide Premium by LOB'!V61","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L62","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V134","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L137","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V206","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L211","v":0},null,0]
[null,34,null,"Industrial Extended Coverage",null,{"$f":"'Nationwide Premium by LOB'!V62","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L63","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V135","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L138","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V207","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L212","v":0},null,0]
[null,34,null,"Mobile Home Multiple Peril",null,{"$f":"'Nationwide Premium by LOB'!V63","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L64","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V136","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L139","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V208","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L213","v":0},null,0]
[null,34,null,"Mobile Home Physical Damage",null,{"$f":"'Nationwide Premium by LOB'!V64","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L65","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V137","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L140","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V209","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L214","v":0},null,0]
[null,34,null,"Reinsurance",null,{"$f":"'Nationwide Premium by LOB'!V65","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L66","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V138","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L141","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V210","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L215","v":0},null,0]
[null,34,null,"Other",null,{"$f":"'Nationwide Premium by LOB'!V66","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L67","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V139","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L142","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V211","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L216","v":0},null,0]
[null,34,null,"Other",null,{"$f":"'Nationwide Premium by LOB'!V67","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L68","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V140","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L143","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V212","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L217","v":0},null,0]
[null,34,null,"Other",null,{"$f":"'Nationwide Premium by LOB'!V68","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L69","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V141","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L144","v":0},null,0,null,{"$f":"'Nationwide Premium by LOB'!V213","v":0},null,{"$f":"'Nationwide Incurred Loss by LOB'!L218","v":0},null,0]
[null,null,null,null,null,"______________",null,"______________",null,"_______",null,"_____________",null,"_____________",null,"_______",null,"_____________",null,"_____________",null,"_______"]
[]
[null,null,null,"Total",null,{"$f":"SUM(F12:F67)","v":0},null,{"$f":"SUM(H12:H67)","v":0},null,{"$f":"IF(F70=0,0,H70/F70)","v":0},null,{"$f":"SUM(L12:L67)","v":0},null,{"$f":"SUM(N12:N67)","v":0},null,{"$f":"IF(L70=0,0,N70/L70)","v":0},null,{"$f":"SUM(R12:R67)","v":0},null,{"$f":"SUM(T12:T67)","v":0},null,{"$f":"IF(R70=0,0,T70/R70)","v":0}]
[null,null,"Verification from P & L - should equal line above.",null,null,{"$f":"IF('P & L'!E8=0,\" \",'P & L'!E8*1000)","v":" "},null,{"$f":"IF('P & L'!E9+'P & L'!E10=0,\" \",('P & L'!E9+'P & L'!E10)*1000)","v":" "},null,null,null,{"$f":"IF('P & L'!I8=0,\" \",'P & L'!I8*1000)","v":" "},null,{"$f":"IF('P & L'!I9+'P & L'!I10=0,\" \",('P & L'!I9+'P & L'!I10)*1000)","v":" "},null,null,null,{"$f":"IF('P & L'!M8=0,\" \",'P & L'!M8*1000)","v":" "},null,{"$f":"IF('P & L'!M9+'P & L'!M10=0,\" \",('P & L'!M9+'P & L'!M10)*1000)","v":" "}]
[null,null,null,null,null,"==============",null,"==============",null,"=========",null,"=============",null,"=============",null,"=======",null,"=============",null,"=============",null,"======="]
[null,null,"* Include loss adjustment expenses."]

{"sheet":"ST","index":8,"n_rows":215,"n_cols":75,"rows_kept":215,"cut":false,"hidden":true,"merged":[[145,2,145,4],[145,8,145,13],[0,60,0,65],[73,2,73,4],[73,8,73,13],[2,8,2,13],[0,54,0,56],[2,28,2,30],[2,34,2,36]]}
["State Navigation Menu",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C3","v":"State"},null,null,"Company Name:",null,null,{"$f":"+I3","v":"Applicant Company Name"}]
[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,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,"(Property & Casualty Insurance Company)"]
[null,null,"State",null,null,null,"Company Name:",null,{"$f":"Intro!$B$21","v":"Applicant Company Name"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C3","v":"State"},null,null,null,"Company Name:",null,{"$f":"Intro!$B$21","v":"Applicant Company Name"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Premium and Loss Developments By Line of Business",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Year 1",null,{"$f":"Intro!B23","v":0},null,"(Property & Casualty Insurance Company)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,{"$f":"+E4","v":0},null,"(Property & Casualty Insurance Company)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amounts in Whole Dollars"]
[null,null,null,null,null,null,"Planned Premium Volume By Line of Business",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,"Incurred Loss Summary By Line of Business "]
[null,null,null,null,null,null,"Amounts in Whole Dollars",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,"Amounts in Whole Dollars",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual",null,null,null,null,null,{"$f":"Intro!B23","v":0},null,null,null,null,null,{"$f":"Intro!B25","v":1},null,null,null,null,null,{"$f":"Intro!B27","v":2}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statement",null,null,null,"Premiums ",null,"Losses ",null,"Loss",null,"Premiums ",null,"Losses ",null,"Loss",null,"Premiums ",null,"Losses ",null,"Loss"]
[null,null,"Annual",null,null,null,"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"Direct",null,"Assumed",null,"Ceded",null,"Net",null,null,null,null,null,null,null,"Annual",null,null,null,"Direct",null,null,"Assumed ",null,"Ceded",null,"Net",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line",null,"Description",null,"Earned",null,"Incurred*",null,"Ratio",null,"Earned",null,"Incurred*",null,"Ratio",null,"Earned",null,"Incurred*",null,"Ratio"]
[null,null,"Statement",null,null,null,"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums",null,null,null,null,null,null,null,"Statement",null,null,null,"Losses ",null,null,"Losses",null,"Losses",null,"Losses",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,"Line",null,"Description",null,"Written",null,"Written",null,"Written",null,"Written",null,"Earned",null,"Earned",null,"Earned",null,"Earned",null,null,null,null,null,null,null,"Line",null,"Description",null,"Incurred*",null,null,"Incurred*",null,"Incurred*",null,"Incurred*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"Fire",null,{"$f":"+U12","v":0},null,{"$f":"AN12","v":0},null,{"$f":"IF(BG10=0,0,BI10/BG10)","v":0},null,{"$f":"U83","v":0},null,{"$f":"AN83","v":0},null,{"$f":"IF(BM10=0,0,BO10/BM10)","v":0},null,{"$f":"U155","v":0},null,{"$f":"AN155","v":0},null,{"$f":"IF(BS10=0,0,BU10/BS10)","v":0}]
[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,null,null,null,null,null,null,2.1,null,"Allied Lines",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,1,null,"Fire",null,null,null,null,null,null,null,{"$f":"G12+I12-K12","v":0},null,null,null,null,null,null,null,{"$f":"O12+Q12-S12","v":0},null,null,null,null,null,null,null,1,null,"Fire",null,null,null,null,null,null,null,null,{"$f":"(AG12+AJ12-AL12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,null,"Multiple Peril Crop",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,2.1,null,"Allied Lines",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,2,null,"Allied Lines",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2999999999999998,null,"Federal Flood",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"Farmowners Multiple Peril",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"Homeowners Multiple Peril",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.2,null,"Commercial Mutiple Peril (Liability Portion)",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"Mortgage Guaranty",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"Ocean Marine",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"Inland Marine",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,8,null,"Ocean Marine",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,8,null,"Ocean Marine",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,"Financial Guaranty",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,9,null,"Inland Marine",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,9,null,"Inland Marine",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.1,null,"Medical Professional Liability - Occurrence",null,0,null,0,null,0,null,{"$f":"U95","v":0},null,0,null,0,null,0,null,0,null,0]
[null,null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.2,null,"Medical Professional Liability - Claims Made",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,"Earthquake",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,"Group A&H",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,12,null,"Earthquake",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,12,null,"Earthquake",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,null,"Credit A&H (Group & Individual)",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,13,null,"Group A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,13,null,"Group A&H",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.1,null,"Collectively Renewable A&H",null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"U172","v":0},null,{"$f":"AN172","v":0},null,0]
[null,null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.2,null,"Non-Cancellable A&H",null,0,null,0,null,0,null,0,null,{"$f":"AN101","v":0},null,{"$f":"IF(BM28=0,0,BO28/BM28)","v":0},null,0,null,0,null,0]
[null,null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.3,null,"Guaranteed Renewable A&H",null,0,null,0,null,0,null,{"$f":"U102","v":0},null,0,null,0,null,0,null,0,null,0]
[null,null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.4,null,"Non-Renew-Stated Reasons Only A&H",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,"Other Accident Only",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,15.4,null,"Non-Renew-Stated Reasons Only A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.4,null,"Non-Renew - Stated Reasons Only A&H",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,{"$f":"+U34","v":0},null,{"$f":"AN34","v":0},null,{"$f":"IF(BG32=0,0,BI32/BG32)","v":0},null,0,null,0,null,{"$f":"IF(BM32=0,0,BO32/BM32)","v":0},null,0,null,0,null,{"$f":"IF(BS32=0,0,BU32/BS32)","v":0}]
[null,null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.7,null,"All Other A&H",null,{"$f":"+U35","v":0},null,{"$f":"AN35","v":0},null,{"$f":"IF(BG33=0,0,BI33/BG33)","v":0},null,0,null,0,null,{"$f":"IF(BM33=0,0,BO33/BM33)","v":0},null,0,null,0,null,{"$f":"IF(BS33=0,0,BU33/BS33)","v":0}]
[null,null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,{"$f":"G34+I34-K34","v":0},null,null,null,null,null,null,null,{"$f":"O34+Q34-S34","v":0},null,null,null,null,null,null,null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.8,null,"Federal Employees Health Benefits Program",null,{"$f":"+U36","v":0},null,{"$f":"AN36","v":0},null,{"$f":"IF(BG34=0,0,BI34/BG34)","v":0},null,0,null,0,null,{"$f":"IF(BM34=0,0,BO34/BM34)","v":0},null,0,null,0,null,{"$f":"IF(BS34=0,0,BU34/BS34)","v":0}]
[null,null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,"Workers' Compensation",null,0,null,0,null,0,null,{"$f":"U108","v":0},null,{"$f":"AN108","v":0},null,0,null,0,null,0,null,0]
[null,null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.100000000000001,null,"Other Liability",null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"U181","v":0},null,{"$f":"AN181","v":0},null,{"$f":"IF(BS36=0,0,BU36/BS36)","v":0}]
[null,null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.3,null,"Excess Workers Compensation",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.100000000000001,null,"Products Liability - Occurrence",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.2,null,"Products Liability - Claims Made",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.2,null,"Other Private Passenger Auto Liability",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.3,null,"Commercial Auto No-Fault (PIP)",null,0,null,0,null,0,null,{"$f":"U115","v":0},null,{"$f":"AN115","v":0},null,0,null,0,null,0,null,0]
[null,null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.399999999999999,null,"Other Commercial Auto Liability",null,{"$f":"+U45","v":0},null,{"$f":"AN45","v":0},null,{"$f":"IF(BG43=0,0,BI43/BG43)","v":0},null,0,null,0,null,{"$f":"IF(BM43=0,0,BO43/BM43)","v":0},null,0,null,0,null,0]
[null,null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21.1,null,"Private Passenger Auto Phys Damage",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,{"$f":"G45+I45-K45","v":0},null,null,null,null,null,null,null,{"$f":"O45+Q45-S45","v":0},null,null,null,null,null,null,null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,null,{"$f":"(AG45+AJ45-AL45)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,21.2,null,"Commercial Auto Physical Damage",null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"U190","v":0},null,{"$f":"AN190","v":0},null,{"$f":"IF(BS45=0,0,BU45/BS45)","v":0}]
[null,null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,null,"Aircraft (All Perils)",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,null,"Fidelity",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,"Surety",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,23,null,"Fidelity",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,23,null,"Fidelity",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,null,"Burglary and Theft",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,24,null,"Surety",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,24,null,"Surety",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,null,"Boiler and Machinery",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,null,"Credit",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,null,"Credit Disability",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,28,null,"Credit",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,28,null,"Credit",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,"Warranty",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,28,null,"Credit Disability",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,28,null,"Credit Disability",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Prepaid Legal",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,30,null,"Warranty",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,30,null,"Warranty",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Bail Bonds",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Glass",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,34,null,"Bail Bonds",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Bail Bonds",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Title",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,34,null,"Glass",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Glass",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Livestock",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,34,null,"Title",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Title",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Industrial Extended Coverage",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,34,null,"Livestock",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Livestock",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Mobile Home Multiple Peril",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Mobile Home Physical Damage",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Reinsurance",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Other",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,34,null,"Reinsurance",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Reinsurance",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Other",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,34,null,"Other",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Other",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,"Other",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,34,null,"Other",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Other",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Other",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Other",null,null,null,null,null,null,null,null,0]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(BG10:BG65)","v":0},null,{"$f":"SUM(BI10:BI65)","v":0},null,{"$f":"IF(BI68=0,0,BI68/BG68)","v":0},null,{"$f":"SUM(BM10:BM65)","v":0},null,{"$f":"SUM(BO10:BO65)","v":0},null,{"$f":"IF(BO68=0,0,BO68/BM68)","v":0},null,{"$f":"SUM(BS10:BS65)","v":0},null,{"$f":"SUM(BU10:BU65)","v":0},null,{"$f":"IF(BU68=0,0,BU68/BS68)","v":0}]
[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",null,{"$f":"SUM(AG12:AG67)","v":0},null,null,{"$f":"SUM(AJ12:AJ67)","v":0},null,{"$f":"SUM(AL12:AL67)","v":0},null,{"$f":"SUM(AN12:AN67)","v":0}]
[null,null,null,null,"Total",null,{"$f":"SUM(G12:G67)","v":0},null,{"$f":"SUM(I12:I67)","v":0},null,{"$f":"SUM(K12:K67)","v":0},null,{"$f":"SUM(M12:M67)","v":0},null,{"$f":"SUM(O12:O67)","v":0},null,{"$f":"SUM(Q12:Q67)","v":0},null,{"$f":"SUM(S12:S67)","v":0},null,{"$f":"SUM(U12:U67)","v":0},null,null,null,null,null,null,null,"Verification from Net Premiums and Loss Development by LOB",null,null,null,"=========",null,null,"=========",null,"=========",null,{"$f":"BI68","v":0}]
[null,null,"Verification from Net Premiums and Loss Development by LOB",null,null,null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,{"$f":"BG68","v":0},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,null,null,"* Include loss adjustment expenses."]
[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,"* Include loss adjustment expenses."]
[]
["State Navigation Menu",null,{"$f":"C3","v":"State"},null,null,null,"Company Name:",null,{"$f":"Intro!$B$21","v":"Applicant Company Name"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C3","v":"State"},null,null,null,"Company Name:",null,{"$f":"+I74","v":"Applicant Company Name"}]
[null,null,"Year 2",null,{"$f":"Intro!B25","v":1},null,"(Property & Casualty Insurance Company)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 2",null,{"$f":"+E75","v":1},null,"(Property & Casualty Insurance Company)"]
[null,null,null,null,null,null,"Planned Premium Volume By Line of Business",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,"Incurred Loss Summary By Line of Business "]
[null,null,null,null,null,null,"Amounts in Whole Dollars",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,"Amounts in Whole Dollars"]
[]
[null,null,"Annual",null,null,null,"Direct",null,"Assumed",null,"Ceded",null,"Net",null,"Direct",null,"Assumed",null,"Ceded",null,"Net",null,null,null,null,null,null,null,"Annual",null,null,null,"Direct",null,null,"Assumed",null,"Ceded",null,"Net"]
[null,null,"Statement",null,null,null,"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums",null,null,null,null,null,null,null,"Statement",null,null,null,"Losses ",null,null,"Losses",null,"Losses",null,"Losses"]
[null,null,"Line",null,"Description",null,"Written",null,"Written",null,"Written",null,"Written",null,"Earned",null,"Earned",null,"Earned",null,"Earned",null,null,null,null,null,null,null,"Line",null,"Description",null,"Incurred*",null,null,"Incurred*",null,"Incurred*",null,"Incurred*"]
[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,1,null,"Fire",null,null,null,null,null,null,null,{"$f":"G83+I83-K83","v":0},null,null,null,null,null,null,null,{"$f":"O83+Q83-S83","v":0},null,null,null,null,null,null,null,1,null,"Fire",null,null,null,null,null,null,null,null,{"$f":"(AG83+AJ83-AL83)","v":0}]
[null,null,2.1,null,"Allied Lines",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,2,null,"Allied Lines",null,null,null,null,null,null,null,null,0]
[null,null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,null,0]
[null,null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,null,0]
[null,null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,null,0]
[null,null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,null,0]
[null,null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,null,0]
[null,null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,null,0]
[null,null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,null,0]
[null,null,8,null,"Ocean Marine",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,8,null,"Ocean Marine",null,null,null,null,null,null,null,null,0]
[null,null,9,null,"Inland Marine",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,9,null,"Inland Marine",null,null,null,null,null,null,null,null,0]
[null,null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,null,0]
[null,null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,null,0]
[null,null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,null,0]
[null,null,12,null,"Earthquake",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,12,null,"Earthquake",null,null,null,null,null,null,null,null,0]
[null,null,13,null,"Group A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,13,null,"Group A&H",null,null,null,null,null,null,null,null,0]
[null,null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,null,0]
[null,null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,null,0]
[null,null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,null,0]
[null,null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,null,0]
[null,null,15.4,null,"Non-Renew-Stated Reasons Only A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.4,null,"Non-Renew - Stated Reasons Only A&H",null,null,null,null,null,null,null,null,0]
[null,null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,null,0]
[null,null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,{"$f":"G105+I105-K105","v":0},null,null,null,null,null,null,null,{"$f":"O105+Q105-S105","v":0},null,null,null,null,null,null,null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,null,0]
[null,null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,null,0]
[null,null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,null,0]
[null,null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,null,0]
[null,null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,null,0]
[null,null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,null,0]
[null,null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,null,0]
[null,null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,null,0]
[null,null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,null,0]
[null,null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,null,0]
[null,null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,null,0]
[null,null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,{"$f":"G116+I116-K116","v":0},null,null,null,null,null,null,null,{"$f":"O116+Q116-S116","v":0},null,null,null,null,null,null,null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,null,{"$f":"(AG116+AJ116-AL116)","v":0}]
[null,null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,null,0]
[null,null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,null,0]
[null,null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,null,0]
[null,null,23,null,"Fidelity",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,23,null,"Fidelity",null,null,null,null,null,null,null,null,0]
[null,null,24,null,"Surety",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,24,null,"Surety",null,null,null,null,null,null,null,null,0]
[null,null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,null,0]
[null,null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,null,0]
[null,null,28,null,"Credit",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,28,null,"Credit",null,null,null,null,null,null,null,null,0]
[null,null,28,null,"Credit Disability",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,28,null,"Credit Disability",null,null,null,null,null,null,null,null,0]
[null,null,30,null,"Warranty",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,30,null,"Warranty",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Bail Bonds",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Bail Bonds",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Glass",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Glass",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Title",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Title",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Livestock",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Livestock",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Reinsurance",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Reinsurance",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Other",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Other",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Other",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Other",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Other",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Other",null,null,null,null,null,null,null,null,0]
[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,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",null,{"$f":"SUM(AG83:AG138)","v":0},null,null,{"$f":"SUM(AJ83:AJ138)","v":0},null,{"$f":"SUM(AL83:AL138)","v":0},null,{"$f":"SUM(AN83:AN138)","v":0}]
[null,null,null,null,"Total",null,{"$f":"SUM(G83:G138)","v":0},null,{"$f":"SUM(I83:I138)","v":0},null,{"$f":"SUM(K83:K138)","v":0},null,{"$f":"SUM(M83:M138)","v":0},null,{"$f":"SUM(O83:O138)","v":0},null,{"$f":"SUM(Q83:Q138)","v":0},null,{"$f":"SUM(S83:S138)","v":0},null,{"$f":"SUM(U83:U138)","v":0},null,null,null,null,null,null,null,"Verification from Net Premiums and Loss Development by LOB",null,null,null,"=========",null,null,"=========",null,"=========",null,{"$f":"BO68","v":0}]
[null,null,"Verification from Net Premiums and Loss Development by LOB",null,null,null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,{"$f":"BM68","v":0}]
[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,"* Include loss adjustment expenses."]
[]
[]
[null,null,{"$f":"C3","v":"State"},null,null,null,"Company Name:",null,{"$f":"Intro!$B$21","v":"Applicant Company Name"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C3","v":"State"},null,null,null,"Company Name:",null,{"$f":"+I146","v":"Applicant Company Name"}]
["State Navigation Menu",null,"Year 3",null,{"$f":"Intro!B27","v":2},null,"(Property & Casualty Insurance Company)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3",null,{"$f":"+E147","v":2},null,"(Property & Casualty Insurance Company)"]
[null,null,null,null,null,null,"Planned Premium Volume By Line of Business",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,"Incurred Loss Summary By Line of Business "]
[null,null,null,null,null,null,"Amounts in Whole Dollars",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,"Amounts in Whole Dollars"]
[]
[null,null,"Annual",null,null,null,"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"Direct",null,"Assumed",null,"Ceded",null,"Net",null,null,null,null,null,null,null,"Annual",null,null,null,"Direct",null,null,"Assumed ",null,"Ceded",null,"Net"]
[null,null,"Statement",null,null,null,"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums",null,null,null,null,null,null,null,"Statement",null,null,null,"Losses ",null,null,"Losses",null,"Losses",null,"Losses"]
[null,null,"Line",null,"Description",null,"Written",null,"Written",null,"Written",null,"Written",null,"Earned",null,"Earned",null,"Earned",null,"Earned",null,null,null,null,null,null,null,"Line",null,"Description",null,"Incurred*",null,null,"Incurred*",null,"Incurred*",null,"Incurred*"]
[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,1,null,"Fire",null,null,null,null,null,null,null,{"$f":"G155+I155-K155","v":0},null,null,null,null,null,null,null,{"$f":"O155+Q155-S155","v":0},null,null,null,null,null,null,null,1,null,"Fire",null,null,null,null,null,null,null,null,{"$f":"(AG155+AJ155-AL155)","v":0}]
[null,null,2.1,null,"Allied Lines",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,2,null,"Allied Lines",null,null,null,null,null,null,null,null,0]
[null,null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,2.2000000000000002,null,"Multiple Peril Crop",null,null,null,null,null,null,null,null,0]
[null,null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,2.2999999999999998,null,"Federal Flood",null,null,null,null,null,null,null,null,0]
[null,null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,3,null,"Farmowners Multiple Peril",null,null,null,null,null,null,null,null,0]
[null,null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,4,null,"Homeowners Multiple Peril",null,null,null,null,null,null,null,null,0]
[null,null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,5.0999999999999996,null,"Commercial Multiple Peril (Non-Liability Portion)",null,null,null,null,null,null,null,null,0]
[null,null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,5.2,null,"Commercial Multiple Peril (Liability Portion)",null,null,null,null,null,null,null,null,0]
[null,null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,6,null,"Mortgage Guaranty",null,null,null,null,null,null,null,null,0]
[null,null,8,null,"Ocean Marine",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,8,null,"Ocean Marine",null,null,null,null,null,null,null,null,0]
[null,null,9,null,"Inland Marine",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,9,null,"Inland Marine",null,null,null,null,null,null,null,null,0]
[null,null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,10,null,"Financial Guaranty",null,null,null,null,null,null,null,null,0]
[null,null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,11.1,null,"Medical Professional Liability - Occurrence",null,null,null,null,null,null,null,null,0]
[null,null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,11.2,null,"Medical Professional Liability - Claims Made",null,null,null,null,null,null,null,null,0]
[null,null,12,null,"Earthquake",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,12,null,"Earthquake",null,null,null,null,null,null,null,null,0]
[null,null,13,null,"Group A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,13,null,"Group A&H",null,null,null,null,null,null,null,null,0]
[null,null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,14,null,"Credit A&H (Group & Individual)",null,null,null,null,null,null,null,null,0]
[null,null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.1,null,"Collectively Renewable A&H",null,null,null,null,null,null,null,null,0]
[null,null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.2,null,"Non-Cancellable A&H",null,null,null,null,null,null,null,null,0]
[null,null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.3,null,"Guaranteed Renewable A&H",null,null,null,null,null,null,null,null,0]
[null,null,15.4,null,"Non-Renew-Stated Reasons Only A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.4,null,"Non-Renew - Stated Reasons Only A&H",null,null,null,null,null,null,null,null,0]
[null,null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.5,null,"Other Accident Only",null,null,null,null,null,null,null,null,0]
[null,null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,{"$f":"G177+I177-K177","v":0},null,null,null,null,null,null,null,{"$f":"O177+Q177-S177","v":0},null,null,null,null,null,null,null,15.6,null,"Medicare Title XVII exempt from state taxes or fees",null,null,null,null,null,null,null,null,0]
[null,null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.7,null,"All Other A&H",null,null,null,null,null,null,null,null,0]
[null,null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15.8,null,"Federal Employees Health Benefits Program",null,null,null,null,null,null,null,null,0]
[null,null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,16,null,"Workers' Compensation",null,null,null,null,null,null,null,null,0]
[null,null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,17.100000000000001,null,"Other Liability",null,null,null,null,null,null,null,null,0]
[null,null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,17.3,null,"Excess Workers Compensation",null,null,null,null,null,null,null,null,0]
[null,null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,18.100000000000001,null,"Products Liability - Occurrence",null,null,null,null,null,null,null,null,0]
[null,null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,18.2,null,"Products Liability - Claims Made",null,null,null,null,null,null,null,null,0]
[null,null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,19.100000000000001,null,"Private Passenger Auto No-Fault (PIP)",null,null,null,null,null,null,null,null,0]
[null,null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,19.2,null,"Other Private Passenger Auto Liability",null,null,null,null,null,null,null,null,0]
[null,null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,19.3,null,"Commercial Auto No-Fault (PIP)",null,null,null,null,null,null,null,null,0]
[null,null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,{"$f":"G188+I188-K188","v":0},null,null,null,null,null,null,null,{"$f":"O188+Q188-S188","v":0},null,null,null,null,null,null,null,19.399999999999999,null,"Other Commercial Auto Liability",null,null,null,null,null,null,null,null,{"$f":"(AG188+AJ188-AL188)","v":0}]
[null,null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,21.1,null,"Private Passenger Auto Phys Damage",null,null,null,null,null,null,null,null,0]
[null,null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,21.2,null,"Commercial Auto Physical Damage",null,null,null,null,null,null,null,null,0]
[null,null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,22,null,"Aircraft (All Perils)",null,null,null,null,null,null,null,null,0]
[null,null,23,null,"Fidelity",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,23,null,"Fidelity",null,null,null,null,null,null,null,null,0]
[null,null,24,null,"Surety",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,24,null,"Surety",null,null,null,null,null,null,null,null,0]
[null,null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,26,null,"Burglary and Theft",null,null,null,null,null,null,null,null,0]
[null,null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,27,null,"Boiler and Machinery",null,null,null,null,null,null,null,null,0]
[null,null,28,null,"Credit",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,28,null,"Credit",null,null,null,null,null,null,null,null,0]
[null,null,28,null,"Credit Disability",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,28,null,"Credit Disability",null,null,null,null,null,null,null,null,0]
[null,null,30,null,"Warranty",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,30,null,"Warranty",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Prepaid Legal",null,null,null,null,null,null,null,null,{"$f":"(AG199+AJ199-AL199)","v":0}]
[null,null,34,null,"Bail Bonds",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Bail Bonds",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Glass",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Glass",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Title",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Title",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Livestock",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Livestock",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Industrial Extended Coverage",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Mobile Home Multiple Peril",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Mobile Home Physical Damage",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Reinsurance",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Reinsurance",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Other",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Other",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Other",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Other",null,null,null,null,null,null,null,null,0]
[null,null,34,null,"Other",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,34,null,"Other",null,null,null,null,null,null,null,null,0]
[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,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",null,{"$f":"SUM(AG155:AG210)","v":0},null,null,{"$f":"SUM(AJ155:AJ210)","v":0},null,{"$f":"SUM(AL155:AL210)","v":0},null,{"$f":"SUM(AN155:AN210)","v":0}]
[null,null,null,null,"Total",null,{"$f":"SUM(G155:G210)","v":0},null,{"$f":"SUM(I155:I210)","v":0},null,{"$f":"SUM(K155:K210)","v":0},null,{"$f":"SUM(M155:M210)","v":0},null,{"$f":"SUM(O155:O210)","v":0},null,{"$f":"SUM(Q155:Q210)","v":0},null,{"$f":"SUM(S155:S210)","v":0},null,{"$f":"SUM(U155:U210)","v":0},null,null,null,null,null,null,null,"Verification from Net Premiums and Loss Development by LOB",null,null,null,"=========",null,null,"=========",null,"=========",null,{"$f":"BU68","v":0}]
[null,null,"Verification from Net Premiums and Loss Development by LOB",null,null,null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,{"$f":"BS68","v":0}]
[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,"* Include loss adjustment expenses."]

{"sheet":"Assumptions","index":9,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["List all of the relevant assumptions used to create the proformas.  "]
["Note, assumptions enclosed within the Plan of Operation need not be disclosed again here."]

{"sheet":"Warning","index":10,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,0,0,10]]}
["Are you sure you want to delete the selected states?"]
[]
[]
[]
[{"$f":"IF(Intro!M2=TRUE,\"X\",\"\")","v":""},"AK","Alaska",null,{"$f":"IF(Intro!M20=TRUE,\"X\",\"\")","v":""},"KS","Kansas",null,{"$f":"IF(Intro!M39=TRUE,\"X\",\"\")","v":""},"OH","Ohio"]
[{"$f":"IF(Intro!M3=TRUE,\"X\",\"\")","v":""},"AL","Alabama",null,{"$f":"IF(Intro!M21=TRUE,\"X\",\"\")","v":""},"KY","Kentucky",null,{"$f":"IF(Intro!M40=TRUE,\"X\",\"\")","v":""},"OK","Oklahoma"]
[{"$f":"IF(Intro!M4=TRUE,\"X\",\"\")","v":""},"AR","Arkansas",null,{"$f":"IF(Intro!M22=TRUE,\"X\",\"\")","v":""},"LA","Louisiana",null,{"$f":"IF(Intro!M41=TRUE,\"X\",\"\")","v":""},"OR","Oregon"]
[{"$f":"IF(Intro!M5=TRUE,\"X\",\"\")","v":""},"AS","American Samoa",null,{"$f":"IF(Intro!M23=TRUE,\"X\",\"\")","v":""},"MA","Massachusetts",null,{"$f":"IF(Intro!M42=TRUE,\"X\",\"\")","v":""},"PA","Pennsylvania"]
[{"$f":"IF(Intro!M6=TRUE,\"X\",\"\")","v":""},"AZ","Arizona",null,{"$f":"IF(Intro!M24=TRUE,\"X\",\"\")","v":""},"MD","Maryland",null,{"$f":"IF(Intro!M43=TRUE,\"X\",\"\")","v":""},"PR","Puerto Rico"]
[{"$f":"IF(Intro!M7=TRUE,\"X\",\"\")","v":""},"CA","California",null,{"$f":"IF(Intro!M25=TRUE,\"X\",\"\")","v":""},"ME","Maine",null,{"$f":"IF(Intro!M44=TRUE,\"X\",\"\")","v":""},"RI","Rhode Island"]
[{"$f":"IF(Intro!M8=TRUE,\"X\",\"\")","v":""},"CO","Colorado",null,{"$f":"IF(Intro!M26=TRUE,\"X\",\"\")","v":""},"MI","Michigan",null,{"$f":"IF(Intro!M45=TRUE,\"X\",\"\")","v":""},"SC","South Carolina"]
[{"$f":"IF(Intro!M9=TRUE,\"X\",\"\")","v":""},"CT","Connecticut",null,{"$f":"IF(Intro!M27=TRUE,\"X\",\"\")","v":""},"MN","Minnesota",null,{"$f":"IF(Intro!M46=TRUE,\"X\",\"\")","v":""},"SD","South Dakota"]
[{"$f":"IF(Intro!M10=TRUE,\"X\",\"\")","v":""},"DC","District Of Columbia",null,{"$f":"IF(Intro!M28=TRUE,\"X\",\"\")","v":""},"MO","Missouri",null,{"$f":"IF(Intro!M47=TRUE,\"X\",\"\")","v":""},"TN","Tennessee"]
[{"$f":"IF(Intro!M11=TRUE,\"X\",\"\")","v":""},"DE","Delaware",null,{"$f":"IF(Intro!M30=TRUE,\"X\",\"\")","v":""},"MT","Montana",null,{"$f":"IF(Intro!M48=TRUE,\"X\",\"\")","v":""},"TX","Texas"]
[{"$f":"IF(Intro!M12=TRUE,\"X\",\"\")","v":""},"FL","Florida",null,{"$f":"IF(Intro!M31=TRUE,\"X\",\"\")","v":""},"NC","North Carolina",null,{"$f":"IF(Intro!M49=TRUE,\"X\",\"\")","v":""},"UT","Utah"]
[{"$f":"IF(Intro!M13=TRUE,\"X\",\"\")","v":""},"GA","Georgia",null,{"$f":"IF(Intro!M32=TRUE,\"X\",\"\")","v":""},"ND","North Dakota",null,{"$f":"IF(Intro!M50=TRUE,\"X\",\"\")","v":""},"VA","Virginia"]
[{"$f":"IF(Intro!M14=TRUE,\"X\",\"\")","v":""},"GU","Guam",null,{"$f":"IF(Intro!M33=TRUE,\"X\",\"\")","v":""},"NE","Nebraska",null,{"$f":"IF(Intro!M51=TRUE,\"X\",\"\")","v":""},"VI","U.S. Virgin Islands"]
[{"$f":"IF(Intro!M15=TRUE,\"X\",\"\")","v":""},"HI","Hawaii",null,{"$f":"IF(Intro!M34=TRUE,\"X\",\"\")","v":""},"NH","New Hampshire",null,{"$f":"IF(Intro!M52=TRUE,\"X\",\"\")","v":""},"VT","Vermont"]
[{"$f":"IF(Intro!M16=TRUE,\"X\",\"\")","v":""},"IA","Iowa",null,{"$f":"IF(Intro!M35=TRUE,\"X\",\"\")","v":""},"NJ","New Jersey",null,{"$f":"IF(Intro!M53=TRUE,\"X\",\"\")","v":""},"WA","Washington"]
[{"$f":"IF(Intro!M17=TRUE,\"X\",\"\")","v":"X"},"ID","Idaho",null,{"$f":"IF(Intro!M36=TRUE,\"X\",\"\")","v":""},"NM","New Mexico",null,{"$f":"IF(Intro!M54=TRUE,\"X\",\"\")","v":""},"WI","Wisconsin"]
[{"$f":"IF(Intro!M18=TRUE,\"X\",\"\")","v":""},"IL","Illinois",null,{"$f":"IF(Intro!M37=TRUE,\"X\",\"\")","v":""},"NV","Nevada",null,{"$f":"IF(Intro!M55=TRUE,\"X\",\"\")","v":""},"WV","West Virginia"]
[{"$f":"IF(Intro!M19=TRUE,\"X\",\"\")","v":""},"IN","Indiana",null,{"$f":"IF(Intro!M38=TRUE,\"X\",\"\")","v":""},"NY","New York",null,{"$f":"IF(Intro!M56=TRUE,\"X\",\"\")","v":""},"WY","Wyoming"]
[]
["X - Indicates the state is selected to be deleted."]