{"text_format":"2","workbook":"xls","n_sheets":12,"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","Multipliers"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":97,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Intro","index":0,"n_rows":144,"n_cols":20,"rows_kept":144,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[{"$nulls":12},false]
[{"$nulls":12},false,"AK","Alaska","Z","NC"]
[{"$nulls":12},false,"AL","Alabama","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,false,"ID","Idaho","Z","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:",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:",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",{"$nulls":7},false,"NC","North Carolina","Z","Z",null,"Mississippi","Go to MS"]
[{"$nulls":12},false,"ND","North Dakota","Z","Z",null,"Montana","Go to MT"]
[{"$nulls":12},false,"NE","Nebraska","Z","Z",null,"North Carolina","Go to NC"]
[{"$nulls":12},false,"NH","New Hampshire","Z","Z",null,"North Dakota","Go to ND"]
[{"$nulls":12},false,"NJ","New Jersey","Z","Z",null,"Nebraska","Go to NE"]
[{"$nulls":12},false,"NM","New Mexico","Z","Z",null,"New Hampshire","Go to NH"]
[{"$nulls":12},false,"NV","Nevada","Z","Z",null,"New Jersey","Go to NJ"]
["Updated: 08/18/2014"]
[]
["OIR-D0-2119",{"$nulls":11},false,"NY","New York","Z","Z",null,"New Mexico","Go to NM"]
["Rev 8/14",{"$nulls":11},false,"OH","Ohio","Z","Z",null,"Nevada","Go to NV"]
["RULE 69O-143.056",{"$nulls":11},false,"OK","Oklahoma","Z","Z",null,"New York","Go to NY"]
[{"$nulls":12},false,"OR","Oregon","Z","Z",null,"Ohio","Go to OH"]
[{"$nulls":12},false,"PA","Pennsylvania","Z","Z",null,"Oklahoma","Go to OK"]
[{"$nulls":12},false,"PR","Puerto Rico","Z","Z",null,"Oregon","Go to OR"]
[{"$nulls":12},false,"RI","Rhode Island","Z","Z",null,"Pennsylvania","Go to PA"]
[{"$nulls":12},false,"SC","South Carolina","Z","Z",null,"Puerto Rico","Go to PR"]
[{"$nulls":12},false,"SD","South Dakota","Z","Z",null,"Rhode Island","Go to RI"]
[{"$nulls":12},false,"TN","Tennessee","Z","Z",null,"South Carolina","Go to SC"]
[{"$nulls":12},false,"TX","Texas","Z","Z",null,"South Dakota","Go to SD"]
[{"$nulls":12},false,"UT","Utah","Z","Z",null,"Tennessee","Go to TN"]
[{"$nulls":12},false,"VA","Virginia","Z","Z",null,"Texas","Go to TX"]
[{"$nulls":12},false,"VI","U.S. Virgin Islands","Z","Z",null,"Utah","Go to UT"]
[{"$nulls":12},false,"VT","Vermont","Z","Z",null,"Virginia","Go to VA"]
[{"$nulls":12},false,"WA","Washington","Z","Z",null,"U.S. Virgin Islands","Go to VI"]
[{"$nulls":12},false,"WI","Wisconsin","Z","Z",null,"Vermont","Go to VT"]
[{"$nulls":12},false,"WV","West Virginia","Z","Z",null,"Washington","Go to WA"]
[{"$nulls":12},false,"WY","Wyoming","Z","Z",null,"Wisconsin","Go to WI"]
[{"$nulls":18},"West Virginia","Go to WV"]
[{"$nulls":18},"Wyoming","Go to WY"]
{"$rows_empty":83}
[{"$nulls":12},false]

{"sheet":"Balance Sheet","index":1,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,7,3,13]],"flags":["formulas_cached_only"]}
[]
[]
[]
[{"$nulls":4},"Applicant Company Name:",null,null,"Applicant Company Name"]
[{"$nulls":4},"(Title Insurance Company)"]
[{"$nulls":4},"Pro Forma Statutory Balance Sheet"]
[{"$nulls":4},"(In Thousands)"]
["Admitted Assets",null,null,0,{"$nulls":7},1,{"$nulls":7},2]
["-------------------"]
["1.   Bonds"]
["2.  Stocks"]
["3.  Title Plants"]
["4.  Real Estate/Mortgage Loans"]
["5.  Affiliated Receivable",{"$nulls":17},"_____________"]
["6.  Affiliated Investments",{"$nulls":17},"_____________"]
["7.  Cash/Cash Equivalents"]
["8.  All Other Admitted Assets"]
["9.  Total Admitted Assets",null,null,0,{"$nulls":7},0,{"$nulls":6},0,0]
[]
[]
[]
["Liabilities"]
["-------------------"]
["10.   Known Claims Reserve",{"$nulls":17},"____________"]
["11.   Statutory Premium Reserve",{"$nulls":17},"____________"]
["12.   Other Required Reserve",{"$nulls":17},"____________"]
["13.   Ceded Reinsurance Payable",{"$nulls":17},"____________"]
["14.  Payable to Parents, Subsidiaries & Affiliates"]
["15.   All Other Liabilities"]
["16.  Total Liabilities(10+11+12+13+14+15)",null,null,0,{"$nulls":7},0,{"$nulls":7},0]
[]
["Capital and Surplus"]
["-------------------"]
["17.  Capitol Stock"]
["18.  Gross Paid In and Contributed Surplus",{"$nulls":17},"___________"]
["19.  Surplus Notes",{"$nulls":17},"___________"]
["20.  Unassigned Surplus"]
["21.  Other Items(elaborate)"]
["22.  Total Capital and Surplus(17-21) ",null,null,0,{"$nulls":7},0,{"$nulls":7},0]

{"sheet":"P & L ","index":2,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,7,1,10]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":5},"Applicant Company Name:",null,"Applicant Company Name"]
[{"$nulls":5},"(Title Insurance Company)"]
[{"$nulls":5},"Pro Forma Statutory Profit & Loss Statement"]
[{"$nulls":5},"(In Thousands)"]
[{"$nulls":4},0,null,null,null,1,null,null,null,2]
[]
[null,"1.  Title Premium Earned"]
[null,"2.  Escrow Charges"]
[null,"3.  Other Related Income"]
[null,"4.  Net Losses Incurred"]
[null,"5.  Net Loss Adjustment Expenses Incurred"]
[null,"6.  Direct Commissions & Brokerage"]
[null,"7.  Reinsurance Ceding Commissions"]
[null,"8.  Net Commissions Incurred (6-7)",null,null,0,null,null,null,0,null,null,null,0]
[null,"9.  Other Contractual Agreements*"]
[null,"10.  Other Underwriting Expenses Incurred**"]
[null,"11.  Underwriting Gain (Loss) (1+2+3-(4+5+8+9+10))",null,null,0,null,null,null,0,null,null,null,0]
[null,"12. Net Investment Income"]
[null,"13. Other Income"]
[null,"14. Income Taxes Incurred"]
[null,"15. Net Operating Income (Loss) "]
[null,"     (11+12+13-14)",null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"16.  Prior YE Surplus"]
[null,"17.  Net Income",null,null,0,null,null,null,0,null,null,null,0]
[null,"18.  Capital Increases"]
[null,"19.  Other Increases (decreases)"]
[null,"20. Dividends to Stockholders"]
[null,"21.  YE Surplus",null,null,0,null,null,null,0,null,null,null,0]
[null,"      Operating Percentages:"]
[null,"       Net Premiums Earned",null,null,1,null,null,null,1,null,null,null,1]
[]
[null,"22. Net Losses Incurred to Title Insurance "]
[null,"      Net Premiums Earned (4/(1+2+3))",null,null,0,null,null,null,0,null,null,null,0]
[null,"23. Net Loss Adjustment Expenses Incurred to Title Insurance "]
[null,"      Net Premium Earned (5/(1+2+3))",null,null,0,null,null,null,0,null,null,null,0]
[null,"24. Other Underwriting Expenses to Title Insurance "]
[null,"      Net Premium Earned ((8+9+10)/(1))",null,null,0,null,null,null,0,null,null,null,0]
[null,"25. Net Underwriting Gain Or (Loss) (11/(1+2+3))",null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"      Other Percentages:"]
[]
[null,"26. Other Underwriting Expenses to Net Premiums Written"]
[null,"      ((8+9+10)/Total Net Premiums Written))",null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"27.   Net Loss and Loss Adjustment Expenses Incurred to"]
[null,"        Title Insurance and Related Income((4+5)/(1+2+3))",null,null,0,null,null,null,0,null,null,null,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":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,7,1,10]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":5},"Applicant Company Name:",null,"Applicant Company Name"]
[{"$nulls":5},"(Title Insurance Company)"]
[{"$nulls":5},"Pro Forma Statutory Cash Flow Statement"]
[{"$nulls":5},"(In Thousands)"]
[{"$nulls":4},0,null,null,null,1,null,null,null,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,0,null,null,null,0,null,null,null,0]
[]
[null,"6.  Net Investment Income"]
[null,"7.  Other Income"]
[null,"8.  Dividends to Policyholders"]
[null,"9.  Federal and Foreign Income Taxes (Paid) Recovered"]
[null,"10. Net Cash From Operations(5+6+7-8+9)",null,null,0,null,null,null,0,null,null,null,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,0,null,null,null,0,null,null,null,0]
[]
[null,"18. Net (+/-) Change in Cash "]
[null,"     (10+11+17)",null,null,0,null,null,null,0,null,null,null,0]

{"sheet":"Premium Ratios","index":4,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,7,1,10]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":4},"Applicant Company Name:",null,null,"Applicant Company Name"]
[null,"Nationwide",null,null,"(Title Insurance Company)"]
[{"$nulls":4},"Premiums Written to Surplus Ratios"]
[{"$nulls":4},"(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,"---------"]
[]
[]
[0,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[]
[1,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[]
[2,0,null,0,null,0,null,0,null,0,null,0,null,0]
{"$rows_empty":8}
[{"$nulls":5},"No data entry is required on this page."]

{"sheet":"Nationwide Premium by LOB","index":5,"n_rows":49,"n_cols":22,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,7,2,11],[18,7,18,11],[35,7,35,11]],"flags":["formulas_cached_only"]}
[]
[]
[null,"Nationwide",null,null,"Applicant Company Name:",null,null,"Applicant Company Name"]
[null,"Year 1",null,0,"(Title Insurance Company)"]
[{"$nulls":4},"Planned Premium Volume By Line of Business"]
[{"$nulls":4},"(Amounts in Whole Dollars)"]
[{"$nulls":12},"Mult","Adjusted ","Adjusted "]
[{"$nulls":5},"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"Gross","Net","Direct",null,"Assumed",null,"Ceded",null,"Net"]
[{"$nulls":5},"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,null,null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums"]
[null,null,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,"---------"]
[null,null,null,"Title",{"$nulls":7},0,0.9,0,0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":9},0]
[{"$nulls":5},"___________",null,"___________",null,"___________",null,"___________",null,"___________","___________","___________",null,"___________",null,"___________",null,"___________"]
[null,null,null,"Total",null,0,null,0,null,0,null,0,null,0,0,0,null,0,null,0,null,0]
[{"$nulls":5},"==============",null,"==============",null,"==============",null,"==============",null,"==========","==========","==============",null,"==============",null,"==============",null,"=============="]
[]
[]
[null,"Nationwide",null,null,"Applicant Company Name:",null,null,"Applicant Company Name"]
[null,"Year 2",null,1,"(Title Insurance Company)"]
[{"$nulls":4},"Planned Premium Volume By Line of Business"]
[{"$nulls":4},"(Amounts in Whole Dollars)"]
[{"$nulls":12},"Mult","Adjusted ","Adjusted "]
[{"$nulls":5},"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"Gross","Net","Direct",null,"Assumed",null,"Ceded",null,"Net"]
[{"$nulls":5},"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,null,null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums"]
[null,null,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,"---------"]
[null,null,null,"Title",{"$nulls":7},0,0.8,0,0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":9},0]
[{"$nulls":5},"___________",null,"___________",null,"___________",null,"___________",null,null,null,"___________",null,"___________",null,"___________",null,"___________"]
[null,null,null,"Total",null,0,null,0,null,0,null,0,null,0,0,0,null,0,null,0,null,0]
[{"$nulls":5},"==============",null,"==============",null,"==============",null,"==============",null,"==========","==========","==============",null,"==============",null,"==============",null,"=============="]
[]
[]
[]
[null,"Nationwide",null,null,"Applicant Company Name:",null,null,"Applicant Company Name"]
[null,"Year 3",null,2,"(Title Insurance Company)"]
[{"$nulls":4},"Planned Premium Volume By Line of Business"]
[{"$nulls":4},"(Amounts in Whole Dollars)"]
[{"$nulls":12},"Mult","Adjusted ","Adjusted "]
[{"$nulls":5},"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"Gross","Net","Direct",null,"Assumed",null,"Ceded",null,"Net"]
[{"$nulls":5},"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,null,null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums"]
[null,null,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,"---------"]
[null,null,null,"Title",{"$nulls":7},0,1.25,0,0,{"$nulls":6},0]
[{"$nulls":11},0,{"$nulls":9},0]
[{"$nulls":5},"___________",null,"___________",null,"___________",null,"___________",null,"___________","___________","___________",null,"___________",null,"___________",null,"___________"]
[null,null,null,"Total",null,0,null,0,null,0,null,0,null,0,0,0,null,0,null,0,null,0]
[{"$nulls":5},"==============",null,"==============",null,"==============",null,"==============",null,"==========","==========","==============",null,"==============",null,"==============",null,"=============="]

{"sheet":"Nationwide Incurred Loss by LOB","index":6,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[3,5,3,8],[24,5,24,8],[44,5,44,8]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Nationwide",null,null,"Applicant Company Name:","Applicant Company Name"]
[null,"Year 1",null,0,"(Title Insurance Company)"]
[{"$nulls":4},"Incurred Loss Summary By Line of Business"]
[{"$nulls":4},"(Amounts in Whole Dollars)"]
[]
[{"$nulls":5},"Direct",null,"Assumed ",null,"Ceded",null,"Net"]
[{"$nulls":5},"Losses ",null,"Losses",null,"Losses",null,"Losses"]
[null,null,null,"Description",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred"]
[null,"---------",null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
[null,null,null,"Title",{"$nulls":7},0]
[{"$nulls":5},"______________",null,"______________",null,"______________",null,"______________"]
[]
[null,null,null,"Total",null,0,null,0,null,0,null,0]
[null,null,null,"Verification from P & L",null,"===============",null,"=============",null,"=============",null,0]
{"$rows_empty":7}
[null,"Nationwide",null,null,"Applicant Company Name:","Applicant Company Name"]
[null,"Year 2",null,1,"(Title Insurance Company)"]
[{"$nulls":4},"Incurred Loss Summary By Line of Business"]
[{"$nulls":4},"(Amounts in Whole Dollars)"]
[]
[{"$nulls":5},"Direct",null,"Assumed ",null,"Ceded",null,"Net"]
[{"$nulls":5},"Losses ",null,"Losses",null,"Losses",null,"Losses"]
[null,null,null,"Description",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred"]
[null,"---------",null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
[null,null,null,"Title",{"$nulls":7},0]
[{"$nulls":5},"______________",null,"______________",null,"______________",null,"______________"]
[]
[null,null,null,"Total",null,0,null,0,null,0,null,0]
[null,null,null,"Verification from P & L",null,"=============",null,"=============",null,"=============",null,0]
[]
[]
[]
[]
[]
[]
[null,"Nationwide",null,null,"Applicant Company Name:","Applicant Company Name"]
[null,"Year 3",null,2,"(Title Insurance Company)"]
[{"$nulls":4},"Incurred Loss Summary By Line of Business"]
[{"$nulls":4},"(Amounts in Whole Dollars)"]
[]
[{"$nulls":5},"Direct",null,"Assumed ",null,"Ceded",null,"Net"]
[{"$nulls":5},"Losses ",null,"Losses",null,"Losses",null,"Losses"]
[null,null,null,"Description",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred"]
[null,"---------",null,"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------"]
[null,null,null,"Title",{"$nulls":7},0]
[{"$nulls":5},"______________",null,"______________",null,"______________",null,"______________"]
[]
[null,null,null,"Total",null,0,null,0,null,0,null,0]
[null,null,null,"Verification from P & L",null,"=============",null,"=============",null,"=============",null,0]

{"sheet":"Nation Net Prem & Loss Dev LOB ","index":7,"n_rows":15,"n_cols":22,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,7,0,12]],"flags":["formulas_cached_only"]}
[null,"Nationwide",null,null,"Applicant Company Name:",null,null,"Applicant Company Name"]
[{"$nulls":4},"(Title Insurance Company)"]
[{"$nulls":4},"Net Premium and Loss Developments By Line of Business",{"$nulls":13},""]
[{"$nulls":4},"(Amounts in Whole Dollars)"]
[]
[{"$nulls":7},0,{"$nulls":5},1,{"$nulls":5},2]
[{"$nulls":5},"Premiums ",null,"Losses ",null,"Loss",null,"Premiums ",null,"Losses ",null,"Loss",null,"Premiums ",null,"Losses ",null,"Loss"]
[null,null,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,"---------"]
[null,null,null,"Title",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$nulls":5},"___________",null,"___________",null,"_______",null,"___________",null,"___________",null,"______",null,"___________",null,"___________",null,"_____"]
[]
[null,null,null,"Total",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,"Verification from P & L - should equal line above.",null,null," ",null," ",null,null,null," ",null," ",null,null,null," ",null," "]
[{"$nulls":5},"==============",null,"==============",null,"=========",null,"==============",null,"==============",null,"========",null,"==============",null,"==============",null,"========="]

{"sheet":"ST","index":8,"n_rows":57,"n_cols":124,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,79,2,81],[2,87,2,92],[0,53,0,55],[0,59,0,64],[2,53,2,55],[2,59,2,64],[39,105,39,107],[39,112,39,117],[21,79,21,81],[21,87,21,92],[40,79,40,81],[40,87,40,92],[21,8,21,13],[2,8,2,13],[20,105,20,107],[20,112,20,117],[2,105,2,107],[2,112,2,117],[2,27,2,29],[2,33,2,35],[21,27,21,29],[21,33,21,35]],"flags":["formulas_cached_only"]}
["State Navigation Menu"]
["State"]
[null,null,"State",null,null,null,"Applicant Company Name:",null,"Applicant Company Name",{"$nulls":18},"State",null,null,null,"Company Name:",null,"Applicant Company Name",{"$nulls":19},"State",null,null,"Company Name:",null,null,"Applicant Company Name",{"$nulls":19},"State",{"$nulls":5},"Company Name:",null,"Applicant Company Name",{"$nulls":17},"State",{"$nulls":4},"Company Name:",null,"Applicant Company Name"]
[null,null,"Year 1",null,0,null,"(Title Insurance Company)",{"$nulls":20},"Year 1",null,0,null,"(Title Insurance Company)",{"$nulls":24},"(Title Insurance Company)",{"$nulls":22},"Year 1",null,0,null,null,null,"(Title Insurance Company)",{"$nulls":19},"Year 1",null,0,null,null,"(Title Insurance Company)"]
[{"$nulls":6},"Planned Premium Volume By Line of Business",{"$nulls":24},"Incurred Loss Summary By Line of Business ",{"$nulls":24},"Net Premium and Loss Developments By Line of Business",{"$nulls":13},"",{"$nulls":14},"Expense Allocation to Lines of Direct Business Written",{"$nulls":24},"Expense Allocation to Lines of Business Net of Reinsurance "]
[{"$nulls":6},"(Amounts in Whole Dollars)",{"$nulls":24},"(Amounts in Whole Dollars)",{"$nulls":24},"(Amounts in Whole Dollars)",{"$nulls":28},"(Amounts in Whole Dollars)",{"$nulls":24},"(Amounts in Whole Dollars)"]
[]
[{"$nulls":6},"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"Direct",null,"Assumed",null,"Ceded",null,"Net",{"$nulls":10},"Direct",null,null,"Assumed ",null,"Ceded",null,"Net",{"$nulls":20},0,{"$nulls":5},1,{"$nulls":5},2,{"$nulls":16},"Loss",null,"Commission",null,"Taxes,",null,"Other",{"$nulls":19},"Loss",null,"Commission",null,"Taxes,",null,"Other"]
[{"$nulls":6},"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums",{"$nulls":10},"Losses ",null,null,"Losses",null,"Losses",null,"Losses",{"$nulls":18},"Premiums ",null,"Losses ",null,"Loss",null,"Premiums ",null,"Losses ",null,"Loss",null,"Premiums ",null,"Losses ",null,"Loss",{"$nulls":9},"Direct","Direct",null,"Direct",null,"Adjustment",null,"& Brokerage",null,"Licenses,",null,"Acquisition",null,"All Other",{"$nulls":12},"Net","Net",null,"Net",null,"Adjustment",null,"& Brokerage",null,"Licenses,",null,"Acquisition",null,"All Other"]
[{"$nulls":4},"Description",null,"Written",null,"Written",null,"Written",null,"Written",null,"Earned",null,"Earned",null,"Earned",null,"Earned",{"$nulls":8},"Description",null,"Incurred",null,null,"Incurred",null,"Incurred",null,"Incurred",{"$nulls":16},"Description",null,"Earned",null,"Incurred*",null,"Ratio",null,"Earned",null,"Incurred",null,"Ratio",null,"Earned",null,"Incurred",null,"Ratio",{"$nulls":7},"Premiums, Losses, Expenses and Percentages",null,"Premiums ","Premiums ",null,"Losses",null,"Expenses",null,"Expenses",null,"& Fees",null,"Expenses ",null,"Expenses",{"$nulls":10},"Premiums, Losses, Expenses and Percentages",null,"Premiums ","Premiums ",null,"Losses",null,"Expenses",null,"Expenses",null,"& Fees",null,"Expenses ",null,"Expenses"]
[{"$nulls":4},"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",{"$nulls":8},"----------------------------------",null,"---------",null,null,"---------",null,"---------",null,"---------",{"$nulls":16},"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",{"$nulls":7},"To Premiums Earned for Direct Business Written",null,"Written","Earned",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",{"$nulls":10},"To Premiums Earned for Business Net of Reinsurance",null,"Written","Earned",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred"]
[{"$nulls":4},"Title",{"$nulls":7},0,{"$nulls":7},0,{"$nulls":8},"Title",{"$nulls":8},0,{"$nulls":16},"Title",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$nulls":7},"---------------------------------------------------------------------",null,"---------","---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",{"$nulls":10},"---------------------------------------------------------------------",null,"---------","---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------"]
[{"$nulls":6},"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",{"$nulls":10},"___________",null,null,"____________",null,"___________",null,"___________",{"$nulls":18},"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",{"$nulls":9},"Amount","Amount ","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%",{"$nulls":11},"Amount","Amount ","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%"]
[{"$nulls":29},"Total",null,0,null,null,0,null,0,null,0,{"$nulls":42},"Title",null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$nulls":9},"Title",null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$nulls":4},"Total",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null," ",{"$nulls":6},"Verification from Net Premiums and Loss Development by LOB",null,null,null,"===========",null,null,"============",null,"===========",null,0,{"$nulls":16},"Total",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$nulls":9},"__________","_________","_____","_________","_____","_________","_____","_________","_____","_________","_____","_________","_____","_________","_____",{"$nulls":11},"_________","_________","_______","___________","_____","____________","_____","__________","______","___________","______","___________","_____","___________","______"]
[null,null,"Verification from Net Premiums and Loss Development by LOB",null,null,null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,0,{"$nulls":36},"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"========="]
[{"$nulls":81},"Total",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},"Total",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":79},"Verification from Planned Premium Volume by LOB Year 1.",null,null,null,0,0,{"$nulls":24},"=========","=========","=======","===========","======","============","======","===========","======","===========","======","===========","======","===========","======"]
[{"$nulls":83},"==========","=========","=====","=========","=====","=========","=====","=========","=====","=========","=====","=========","=====","=========","=====",{"$nulls":6},""]
[]
[{"$nulls":105},"State",{"$nulls":4},"Company Name:",null,"Applicant Company Name"]
[null,null,"State",null,null,null,"Applicant Company Name:",null,"Applicant Company Name",{"$nulls":18},"State",null,null,null,"Company Name:",null,"Applicant Company Name",{"$nulls":45},"State",{"$nulls":5},"Company Name:",null,"Applicant Company Name",{"$nulls":17},"Year 2",null,1,null,null,"(Title Insurance Company)"]
[null,null,"Year 2",null,1,null,"(Title Insurance Company)",{"$nulls":20},"Year 2",null,1,null,"(Title Insurance Company)",{"$nulls":47},"Year 2",null,1,null,null,null,"(Title Insurance Company)",{"$nulls":24},"Expense Allocation to Lines of Business Net of Reinsurance "]
[{"$nulls":6},"Planned Premium Volume By Line of Business",{"$nulls":24},"Incurred Loss Summary By Line of Business ",{"$nulls":53},"Expense Allocation to Lines of Direct Business Written",{"$nulls":24},"(Amounts in Whole Dollars)"]
[{"$nulls":6},"(Amounts in Whole Dollars)",{"$nulls":24},"(Amounts in Whole Dollars)",{"$nulls":53},"(Amounts in Whole Dollars)"]
[{"$nulls":114},"Loss",null,"Commission",null,"Taxes,",null,"Other"]
[{"$nulls":6},"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"Direct",null,"Assumed",null,"Ceded",null,"Net",{"$nulls":10},"Direct",null,null,"Assumed ",null,"Ceded",null,"Net",{"$nulls":49},"Loss",null,"Commission",null,"Taxes,",null,"Other",{"$nulls":14},"Net","Net",null,"Net",null,"Adjustment",null,"& Brokerage",null,"Licenses,",null,"Acquisition",null,"All Other"]
[{"$nulls":6},"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums",{"$nulls":10},"Losses ",null,null,"Losses",null,"Losses",null,"Losses",{"$nulls":44},"Direct","Direct",null,"Direct",null,"Adjustment",null,"& Brokerage",null,"Licenses,",null,"Acquisition",null,"All Other",{"$nulls":10},"Premiums, Losses, Expenses and Percentages",null,"Premiums ","Premiums ",null,"Losses",null,"Expenses",null,"Expenses",null,"& Fees",null,"Expenses ",null,"Expenses"]
[{"$nulls":4},"Description",null,"Written",null,"Written",null,"Written",null,"Written",null,"Earned",null,"Earned",null,"Earned",null,"Earned",{"$nulls":8},"Description",null,"Incurred",null,null,"Incurred",null,"Incurred",null,"Incurred",{"$nulls":42},"Premiums, Losses, Expenses and Percentages",null,"Premiums ","Premiums ",null,"Losses",null,"Expenses",null,"Expenses",null,"& Fees",null,"Expenses ",null,"Expenses",{"$nulls":10},"To Premiums Earned for Business Net of Reinsurance",null,"Written","Earned",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred"]
[{"$nulls":4},"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",{"$nulls":8},"----------------------------------",null,"---------",null,null,"---------",null,"---------",null,"---------",{"$nulls":42},"To Premiums Earned for Direct Business Written",null,"Written","Earned",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",{"$nulls":10},"---------------------------------------------------------------------",null,"---------","---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------"]
[{"$nulls":4},"Title",{"$nulls":7},0,{"$nulls":7},0,{"$nulls":8},"Title",{"$nulls":8},0,{"$nulls":42},"---------------------------------------------------------------------",null,"---------","---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",{"$nulls":12},"Amount","Amount ","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%"]
[{"$nulls":6},"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",{"$nulls":10},"___________",null,null,"____________",null,"___________",null,"___________",{"$nulls":44},"Amount","Amount ","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%",{"$nulls":9},"Title",null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$nulls":29},"Total",null,0,null,null,0,null,0,null,0,{"$nulls":42},"Title",null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$nulls":11},"_________","_________","_______","___________","_____","____________","_____","__________","______","___________","______","___________","_____","___________","______"]
[{"$nulls":4},"Total",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null," ",{"$nulls":6},"Verification from Net Premiums and Loss Development by LOB",null,null,null,"===========",null,null,"============",null,"===========",null,0,{"$nulls":44},"__________","_________","_____","_________","_____","_________","_____","_________","_____","_________","_____","_________","_____","_________","_____"]
[null,null,"Verification from Net Premiums and Loss Development by LOB",null,null,null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,0,{"$nulls":86},"Total",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":81},"Total",null,0,0,0," ",0," ",0," ",0," ",0," ",0," ",0,{"$nulls":11},"=========","=========","=======","===========","======","============","======","===========","======","===========","======","===========","======","===========","======"]
[{"$nulls":79},"Verification from Planned Premium Volume by LOB Year 1.",null,null,null,0,0,{"$nulls":19},""]
["State Navigation Menu",{"$nulls":82},"==========","=========","=====","=========","=====","=========","=====","=========","=====","=========","=====","=========","=====","=========","====="]
["State"]
[{"$nulls":105},"State",{"$nulls":4},"Company Name:",null,"Applicant Company Name"]
[null,null,"State",null,null,null,"Applicant Company Name:",null,"Applicant Company Name",{"$nulls":18},"State",null,null,null,"Company Name:",null,"Applicant Company Name",{"$nulls":45},"State",{"$nulls":5},"Company Name:",null,"Applicant Company Name",{"$nulls":17},"Year 3",null,2,null,null,"(Title Insurance Company)"]
[null,null,"Year 3",null,2,null,"(Title Insurance Company)",{"$nulls":20},"Year 3",null,2,null,"(Title Insurance Company)",{"$nulls":47},"Year 3",null,2,null,null,null,"(Title Insurance Company)",{"$nulls":24},"Expense Allocation to Lines of Business Net of Reinsurance "]
[{"$nulls":6},"Planned Premium Volume By Line of Business",{"$nulls":24},"Incurred Loss Summary By Line of Business ",{"$nulls":53},"Expense Allocation to Lines of Direct Business Written",{"$nulls":24},"(Amounts in Whole Dollars)"]
[{"$nulls":6},"(Amounts in Whole Dollars)",{"$nulls":24},"(Amounts in Whole Dollars)",{"$nulls":53},"(Amounts in Whole Dollars)"]
[{"$nulls":114},"Loss",null,"Commission",null,"Taxes,",null,"Other"]
[{"$nulls":6},"Direct",null,"Assumed ",null,"Ceded",null,"Net",null,"Direct",null,"Assumed",null,"Ceded",null,"Net",{"$nulls":10},"Direct",null,null,"Assumed ",null,"Ceded",null,"Net",{"$nulls":49},"Loss",null,"Commission",null,"Taxes,",null,"Other",{"$nulls":14},"Net","Net",null,"Net",null,"Adjustment",null,"& Brokerage",null,"Licenses,",null,"Acquisition",null,"All Other"]
[{"$nulls":6},"Premiums ",null,"Premiums ",null,"Premiums",null,"Premiums ",null,"Premiums",null,"Premiums",null,"Premiums ",null,"Premiums",{"$nulls":10},"Losses ",null,null,"Losses",null,"Losses",null,"Losses",{"$nulls":44},"Direct","Direct",null,"Direct",null,"Adjustment",null,"& Brokerage",null,"Licenses,",null,"Acquisition",null,"All Other",{"$nulls":10},"Premiums, Losses, Expenses and Percentages",null,"Premiums ","Premiums ",null,"Losses",null,"Expenses",null,"Expenses",null,"& Fees",null,"Expenses ",null,"Expenses"]
[{"$nulls":4},"Description",null,"Written",null,"Written",null,"Written",null,"Written",null,"Earned",null,"Earned",null,"Earned",null,"Earned",{"$nulls":8},"Description",null,"Incurred",null,null,"Incurred",null,"Incurred",null,"Incurred",{"$nulls":42},"Premiums, Losses, Expenses and Percentages",null,"Premiums ","Premiums ",null,"Losses",null,"Expenses",null,"Expenses",null,"& Fees",null,"Expenses ",null,"Expenses",{"$nulls":10},"To Premiums Earned for Business Net of Reinsurance",null,"Written","Earned",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred"]
[{"$nulls":4},"----------------------------------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",{"$nulls":8},"----------------------------------",null,"---------",null,null,"---------",null,"---------",null,"---------",{"$nulls":42},"To Premiums Earned for Direct Business Written",null,"Written","Earned",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",null,"Incurred",{"$nulls":10},"---------------------------------------------------------------------",null,"---------","---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------"]
[{"$nulls":4},"Title",{"$nulls":7},0,{"$nulls":7},0,{"$nulls":8},"Title",{"$nulls":8},0,{"$nulls":42},"---------------------------------------------------------------------",null,"---------","---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",null,"---------",{"$nulls":12},"Amount","Amount ","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%"]
[{"$nulls":6},"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",null,"_________",{"$nulls":10},"___________",null,null,"____________",null,"___________",null,"___________",{"$nulls":44},"Amount","Amount ","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%",{"$nulls":9},"Title",null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$nulls":29},"Total",null,0,null,null,0,null,0,null,0,{"$nulls":42},"Title",null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$nulls":11},"_________","_________","_______","___________","_____","____________","_____","__________","______","___________","______","___________","_____","___________","______"]
[{"$nulls":4},"Total",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null," ",{"$nulls":6},"Verification from Net Premiums and Loss Development by LOB",null,null,null,"===========",null,null,"============",null,"===========",null,0,{"$nulls":44},"__________","_________","_____","_________","_____","_________","_____","_________","_____","_________","_____","_________","_____","_________","_____"]
[null,null,"Verification from Net Premiums and Loss Development by LOB",null,null,null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,"=========",null,0,{"$nulls":86},"Total",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":81},"Total",null,0,0,0," ",0," ",0," ",0," ",0," ",0," ",0,{"$nulls":11},"=========","=========","=======","===========","======","============","======","===========","======","===========","======","===========","======","===========","======"]
[{"$nulls":79},"Verification from Planned Premium Volume by LOB Year 1.",null,null,null,0,0,{"$nulls":19},""]
[{"$nulls":83},"==========","=========","=====","=========","=====","=========","=====","=========","=====","=========","=====","=========","=====","=========","====="]

{"sheet":"Assumptions","index":9,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":8}
["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]],"flags":["formulas_cached_only"]}
["Are you sure you want to delete the selected states?"]
[]
[]
[]
["","AK","Alaska",null,"","KS","Kansas",null,"","OH","Ohio"]
["","AL","Alabama",null,"","KY","Kentucky",null,"","OK","Oklahoma"]
["","AR","Arkansas",null,"","LA","Louisiana",null,"","OR","Oregon"]
["","AS","American Samoa",null,"","MA","Massachusetts",null,"","PA","Pennsylvania"]
["","AZ","Arizona",null,"","MD","Maryland",null,"","PR","Puerto Rico"]
["","CA","California",null,"","ME","Maine",null,"","RI","Rhode Island"]
["","CO","Colorado",null,"","MI","Michigan",null,"","SC","South Carolina"]
["","CT","Connecticut",null,"","MN","Minnesota",null,"","SD","South Dakota"]
["","DC","District Of Columbia",null,"","MO","Missouri",null,"","TN","Tennessee"]
["","DE","Delaware",null,"","MT","Montana",null,"","TX","Texas"]
["","FL","Florida",null,"","NC","North Carolina",null,"","UT","Utah"]
["","GA","Georgia",null,"","ND","North Dakota",null,"","VA","Virginia"]
["","GU","Guam",null,"","NE","Nebraska",null,"","VI","U.S. Virgin Islands"]
["","HI","Hawaii",null,"","NH","New Hampshire",null,"","VT","Vermont"]
["","IA","Iowa",null,"","NJ","New Jersey",null,"","WA","Washington"]
["","ID","Idaho",null,"","NM","New Mexico",null,"","WI","Wisconsin"]
["","IL","Illinois",null,"","NV","Nevada",null,"","WV","West Virginia"]
["","IN","Indiana",null,"","NY","New York",null,"","WY","Wyoming"]
[]
["X - Indicates the state is selected to be deleted."]

{"sheet":"Multipliers","index":11,"n_rows":62,"n_cols":56,"rows_kept":62,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,null,1,2.1,2.2,2.3,3,4,5.1,5.2,6,8,9,10,11,12,13,14,15.1,15.2,15.3,15.4,15.5,15.6,15.7,16,17,19.1,19.2,19.3,19.4,21.1,21.2,22,23,24,26,27,28,28,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31]
[null,null,null,"Fire","Allied Lines","Multiple Peril Crop","Federal Flood","Farmowners Multiple Peril","Homeowners Multiple Peril","Commercial Multiple Peril (Non-Liability Portion)","Commercial Multiple Peril (Liability Portion)","Mortgage Guaranty","Ocean Marine","Inland Marine","Financial Guaranty","Medical Malpractice","Earthquake","Group A&H","Credit A&H (Group & Individual)","Collectively Renewable A&H","Non-Cancellable A&H","Guaranteed Renewable A&H","Non-Renew-Stated Reasons Only A&H","Other Accident Only","All Other A&H","Federal Employees Health Benefits Program","Workers' Compensation","Other Liability","Private Passenger Auto No-Fault (PIP)","Other Private Passenger Auto Liability","Commercial Auto No-Fault (PIP)","Other Commercial Auto Liability","Private Passenger Auto Phys Damage","Commercial Auto Physical Damage","Aircraft (All Perils)","Fidelity","Surety","Burglary and Theft","Boiler and Machinery","Credit","Credit Disability","Auto Warranties","Prepaid Legal","Bail Bonds","Glass","Title","Livestock","Industrial Extended Coverage","Mobile Home Multiple Peril","Mobile Home Physical Damage","Home Warranties","Service Warranties","Reinsurance","Other - Property","Other - Casualty","Other "]
[]
[1,"AK","Alaska",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[2,"AL","Alabama",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[3,"AR","Arkansas",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[4,"AS","American Samoa",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[5,"AZ","Arizona",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[6,"CA","California",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[7,"CO","Colorado",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[8,"CT","Connecticut",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[9,"DC","District Of Columbia",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[10,"DE","Delaware",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[11,"FL","Florida",0.9,0.9,0.9,0.9,1.25,1.25,0.9,1.25,1,1,1,1,1.25,0.9,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1,1,1.25,1.25,1.25,1.25,1.25,1,1,1.25,1,1.25,0.9,1.25,0.9,0.9,0.9,1.25,0.9,1.25,1]
[12,"GA","Georgia",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[13,"GU","Guam",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[14,"HI","Hawaii",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[15,"IA","Iowa",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[16,"ID","Idaho",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[17,"IL","Illinois",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[18,"IN","Indiana",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[19,"KS","Kansas",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[20,"KY","Kentucky",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[21,"LA","Louisiana",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[22,"MA","Massachusetts",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[23,"MD","Maryland",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[24,"ME","Maine",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[25,"MI","Michigan",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[26,"MN","Minnesota",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[27,"MO","Missouri",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[28,"MS","Mississippi",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[29,"MT","Montana",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[30,"NC","North Carolina",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[31,"ND","North Dakota",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[32,"NE","Nebraska",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[33,"NH","New Hampshire",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[34,"NJ","New Jersey",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[35,"NM","New Mexico",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[36,"NV","Nevada",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[37,"NY","New York",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[38,"OH","Ohio",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[39,"OK","Oklahoma",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[40,"OR","Oregon",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[41,"PA","Pennsylvania",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[42,"PR","Puerto Rico",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[43,"RI","Rhode Island",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[44,"SC","South Carolina",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[45,"SD","South Dakota",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[46,"TN","Tennessee",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[47,"TX","Texas",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[48,"UT","Utah",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[49,"VA","Virginia",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[50,"VI","U.S. Virgin Islands",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[51,"VT","Vermont",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[52,"WA","Washington",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[53,"WI","Wisconsin",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[54,"WV","West Virginia",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[55,"WY","Wyoming",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[56]
[null,null,"Multiplier Used",2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54]
[null,null,"FL",0.9,0.9,0.9,0.9,1.25,1.25,0.9,1.25,1,1,1,1,1.25,0.9,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1,1,1.25,1.25,1.25,1.25,1.25,1,1,1.25,1,1.25,0.9,1.25,0.9,0.9,0.9,1.25,0.9,1.25,1]