{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Version","Instructions","Contacts","Section A-1 - Main","Section A-2 - Vendors","Section A-3 - Attorneys","Section A-4 - Public Adjuster","Valid Responses"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":13,"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":"Version","index":0,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,0,11,9],[12,0,12,9]]}
[null,null,null,null,null,null,null,null,null,"VERSION",2025]
[null,null,null,null,null,null,null,null,null,"25.02.A"]
[]
[]
[]
[]
[]
[]
["Florida Property Claims Lifecycle Data Call Reporting Form\n"]
[]
[]
[]
["Pursuant to Section 624.424(11), Florida Statutes"]
[]
[]
[]
[]
["Form OIR-B1-2222"]
["Effective Date XX/XX"]
["Rule 69O-171.011, Florida Administrative Code"]

{"sheet":"Instructions","index":1,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["GENERAL INSTRUCTIONS"]
[]
["WHAT: Pursuant to section 624.424(11), Florida Statutes, each authorized insurer or insurer group issuing personal lines or commercial lines residential property insurance policies shall report, for each such line of insurance, an annual Florida Property Claims Lifecycle Data Call (PCLR) reporting form detailing closed claim experience. For PCLR, insurers are required to provide information related to closed claims with and without payment for personal or commercial residential property policies to include:\n\n• Claims closed with and without payment in Florida in the prior calendar year for Sections A-1, A-2, A-3 and A-4.\n\nWHO: PCLR must be completed by insurers licensed in Florida for the following lines of business:\n\n• Allied Lines\n• Commercial Multi-Peril\n• Farmowners Multi-Peril\n• Homeowners Multi-Peril\n• Mobile Homeowners Multi-Peril\n• Mobile Homeowners Physical Damage Only\n• Property (Fire)\n\nDUE DATE:  PCLR is due by 11:59 PM ET annually, on or before March 1, via the Insurance Regulation Filing System (IRFS) located at: \n"]
["irfs.fldfs.com "]
["NO DATA: A “No data” option may only be used by insurers with no personal or commercial residential closed claims with and without payment in the prior calendar year for the lines of business listed above.\n\nFIELDS TO BE COMPLETED: Insurers are required to complete all fields in Sections A-1, A-2, A-3, and A-4. \n\nINDIVIDUAL SUBMISSIONS: Data should be submitted on an individual company basis. Once submitted, data may be aggregated at the group level by OIR.\n\nTRADE SECRET SUBMISSIONS: An affidavit must accompany a filing that is submitted as a trade secret per section 624.4213, Florida Statutes. Refer to the Contacts tab for additional information."]
["Failure to respond to the data call may result in administrative action."]
["ADDITIONAL RESOURCES & CONTACT INFORMATION"]
["Information about IRFS Filing Instructions and FAQs are located at:"]
["https://floir.com/tools-and-data/data-call-reporting"]
["To search for a Florida Bar number:"]
["https://www.floridabar.org/directories/find-mbr/"]
["To research a Florida license number:"]
["https://licenseesearch.fldfs.com/"]
["Questions regarding this report may be directed to research@floir.com or (850) 413-3147."]

{"sheet":"Contacts","index":2,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,0,2,7],[2,8,2,9],[0,8,1,9],[0,10,2,10]]}
[null,null,null,null,null,null,null,null,"CONTACT INFORMATION",null,"VALIDATION\nCHECKS"]
[]
["HIDDEN COLUMNS",null,null,null,null,null,null,null,"Verify pre-populated information and complete any missing responses"]
[null,null,null,null,null,null,null,null,"Is this filing being submitted as Trade Secret? If yes, once this report is uploaded, the Company must upload the affidavit as required by section 624.4213, Florida Statutes.",null,{"$f":"IF(COUNTBLANK(J4),FALSE,TRUE)","v":false}]
["Seq_Num","is_public","is_error","is_ts","is_confid","confid_id","Rpt_Year","Rpt_Qtr","LineDesc","Response","RowValidation"]
[1,0,0,{"$f":"IF($J$4=\"YES\",1,0)","v":0},0,0,{"$f":"Version!K$1","v":2025},0,"Report Date (Date Completed) mm/dd/yyyy",null,{"$f":"IF(COUNTBLANK(J6),FALSE,TRUE)","v":false}]
[2,0,0,0,0,0,{"$f":"Version!K$1","v":2025},0,"Provide the name of the individual who completed this form. ",null,false]
[3,0,0,0,0,0,{"$f":"Version!K$1","v":2025},0,"Individual's Email Address",null,false]
[4,0,0,0,0,0,{"$f":"Version!K$1","v":2025},0,"Individual's Phone Number",null,false]
[5,0,0,0,0,0,{"$f":"Version!K$1","v":2025},0,"Company Name",null,false]
[6,0,0,0,0,0,{"$f":"Version!K$1","v":2025},0,"Company NAIC Code (\"00000\" if no NAIC Code exists)",null,false]
[7,0,0,0,0,0,{"$f":"Version!K$1","v":2025},0,"Florida Company Code",null,false]
[8,0,0,0,0,0,{"$f":"Version!K$1","v":2025},0,"Company FEIN",null,false]
[9,0,0,0,0,0,{"$f":"Version!K$1","v":2025},0,"NAIC Group Code (\"0000\" if no NAIC group code exists)",null,false]
[12,0,0,0,0,0,{"$f":"Version!K$1","v":2025},0,"Comments regarding information in the data call.  If you do not have any comments, type N/A.",null,false]
[13,0,0,0,0,0,{"$f":"Version!K$1","v":2025},0,"Is Trade Secret?",{"$f":"IF(COUNTBLANK(J4),\"\",J4)","v":""},true]

{"sheet":"Section A-1 - Main","index":3,"n_rows":7,"n_cols":30,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,7,3,7],[2,8,3,8],[2,13,3,13],[0,0,0,7],[1,0,1,27],[2,17,2,27],[2,14,2,15],[2,2,2,3],[2,1,3,1],[2,0,3,0],[0,10,0,13],[2,10,3,10],[2,9,3,9],[2,11,3,11],[2,12,3,12],[2,16,3,16],[2,4,3,4],[2,5,3,5],[2,6,3,6]]}
[{"$f":"\"Section A-1: Main Claim Information\"&IF(Contacts!$J$4=\"Yes\",\" - TRADE SECRET\",\"\")","v":"Section A-1: Main Claim Information"},null,null,null,null,null,null,null,null,null,{"$f":"IF(AC1=1,TRUE,\"Section A-1 - Main sheet not validated\")","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,7]
[{"$f":"\"DETAILED CLAIM INFORMATION FOR EVERY PROPERTY CLAIM CLOSED BETWEEN JANUARY 1, \" & Version!K1 & \" AND DECEMBER 31, \" & Version!K1","v":"DETAILED CLAIM INFORMATION FOR EVERY PROPERTY CLAIM CLOSED BETWEEN JANUARY 1, 2025 AND DECEMBER 31, 2025"}]
["Claim ID","Type of Policy\n(See Valid Responses)","Location of Claim",null,"Date of Initial Loss/Incident mm/dd/yyyy","Date Reported to Insurer mm/dd/yyyy","Date Initially Closed mm/dd/yyyy","Date Most Recently Closed\nmm/dd/yyyy","Peril As Reported to Insurer\n(See Valid Responses)","Hurricane Name As Reported to Insurer \n(See Valid Responses)","Was Claim Initially Closed with Payment? (Y/N/Unknown)","Date Re-Opened Claim Reported to Insurer (if applicable) mm/dd/yyyy","Date Supplemental Claim Reported to Insurer (if applicable) mm/dd/yyyy","Initial Estimate Amount by Insurer","Total Amount Paid by Insurer",null,"Trade Secret?","VALIDATION CHECKS"]
[null,null,"Zip Code","County  \n(See Valid Responses)",null,null,null,null,null,null,null,null,null,null,"Indemnity","LAE",null,"Row Complete?","Required Fields Complete?","Is Policy Type Valid?","Is Zip Code Valid?","Is County Valid? (See Valid Responses)","Is Peril Valid? (See Valid Responses)","Is Hurricane Name Valid? (See Valid Responses)","Is Y/N/Unknown Data Correct? (Column K)","Is Date Re-Opened Claim Reported Correct?","Is Date Supplemental Claim Reported Correct?","Is Initial Estimate Amount by Insurer Correct?"]
["s. 624.424(11)(a)","s. 624.424(11)(b)","s. 624.424(11)(c)","s. 624.424(11)(d)","s. 624.424(11)(e)","s. 624.424(11)(g)","s. 624.424(11)(h)","s. 624.424(11)(k)","s. 624.424(11)(f)","s.624.424(11)(t)","s. 624.424(11)(h)","s. 624.424(11)(i)","s. 624.424(11)(j)","s.624.424(11)(t)","s. 624.424(11)(n)","s. 624.424(11)(o)"]
["Claim_ID","Pol_Type","Zip_Cd","County","Loss_Dt","Rptd_Dt","Int_Cld_Dt","Rct_Cld_Dt","Peril","Hurricane_Nm","Clm_Cld_Pymt","Reopen_Clm_Dt","Suppl_Clm_Dt","Init_Est_Amt","Indmn","LAE","Trade_Secret","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Contacts!$J$4=\"YES\",\"Yes\",\"No\")","v":"No"},{"$f":"IF((AND(S7=TRUE,T7=TRUE,U7=TRUE,V7=TRUE,W7=TRUE,X7=TRUE,Y7=TRUE,Z7=TRUE,AA7=TRUE,AB7=TRUE)),TRUE,FALSE)","v":true},{"$f":"IF(COUNTBLANK(A7:P7)=16,TRUE,IF(AND(I7<>\"HURR\",COUNTBLANK(J7)=1,COUNTBLANK(A7:I7)+COUNTBLANK(K7:P7)=0),TRUE,IF(COUNTBLANK(A7:P7)=0,TRUE,FALSE)))","v":true},{"$f":"IF(ISBLANK(B7),TRUE,IF(ISNA(MATCH(B7,'Valid Responses'!$C$3:$C$15,0)),\"Error: Invalid Policy\",TRUE))","v":true},{"$f":"IF(ISBLANK(C7),TRUE,IF(C7=\"UNKNOWN\",TRUE,IF(AND(LEN(C7)=5,ISNUMBER(C7)), TRUE, \"Error: Enter 5 digit zip or 'Unknown'\")))","v":true},{"$f":"IF(ISBLANK(D7),TRUE,IF(ISNA(MATCH(D7,'Valid Responses'!$G$2:$G$69,0)),\"Error: Invalid County\",TRUE))","v":true},{"$f":"IF(ISBLANK(I7),TRUE,IF(ISNA(MATCH(I7,'Valid Responses'!$J$3:$J$10,0)),\"Error: Invalid Peril\",TRUE))","v":true},{"$f":"IF(AND(ISBLANK(J7),I7<>\"HURR\"),TRUE,IF(AND(ISNA(MATCH(J7,'Valid Responses'!$C$20:$C$80,0)),I7=\"HURR\"),\"Error: Invalid Hurricane Name\",IF(I7<>\"HURR\",\"Error: Peril <> HURR, Hurricane Name must be blank\",TRUE)))","v":true},{"$f":"IF(OR(ISBLANK(K7),NOT(ISNA(MATCH(K7,'Valid Responses'!$J$28:$J$30,0)))),TRUE,\"Error: Select Y, N or Unknown\")","v":true},{"$f":"IF(ISBLANK(L7),TRUE,IF(L7=\"N/A\",TRUE,IF(ISERROR(DATE(DAY(L7),MONTH(L7),YEAR(L7))),\"Error: Enter mm/dd/yyyy or 'N/A'\",IF(YEAR(L7)<1990,\"Error: Enter date greater than 12/31/1989 or 'N/A'\",TRUE))))","v":true},{"$f":"IF(ISBLANK(M7),TRUE,IF(M7=\"N/A\",TRUE,IF(ISERROR(DATE(DAY(M7),MONTH(M7),YEAR(M7))),\"Error: Enter mm/dd/yyyy or 'N/A'\",IF(YEAR(M7)<1990,\"Error: Enter date greater than 12/31/1989 or 'N/A'\",TRUE))))","v":true},{"$f":"IF(ISBLANK(N7),TRUE,IF(N7=\"UNKNOWN\",TRUE,IF(ISNUMBER(N7), TRUE, \"Error: Enter amount or 'UNKNOWN'\")))","v":true}]

{"sheet":"Section A-2 - Vendors","index":4,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,6,2,10],[1,0,1,10],[0,0,0,2],[2,0,3,0],[2,5,3,5],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[0,5,0,8]]}
[{"$f":"\"Section A-2: Vendor Information\"&IF(Contacts!$J$4=\"Yes\",\" - TRADE SECRET\",\"\")","v":"Section A-2: Vendor Information"},null,null,null,null,{"$f":"IF(L1=1,TRUE,\"Section A-2 - Vendors sheet not validated\")","v":true},null,null,null,null,null,1,7]
[{"$f":"\"DETAILED CLAIM INFORMATION FOR EVERY PROPERTY CLAIM CLOSED BETWEEN JANUARY 1, \" & Version!K1 & \" AND DECEMBER 31, \" & Version!K1","v":"DETAILED CLAIM INFORMATION FOR EVERY PROPERTY CLAIM CLOSED BETWEEN JANUARY 1, 2025 AND DECEMBER 31, 2025"}]
["Claim ID","Type of Vendor (See Valid Responses)","Vendor/Company Name","Initial Invoice/ Demand Amount from Vendor","Final Paid Amount to Vendor by Insurer","Trade Secret?","VALIDATION CHECKS"]
[null,null,null,null,null,null,"Row Complete?","Required Fields Complete?","Is Type of Vendor Correct? ","Is Initial Invoice/Demand Amount from Vendor Correct?","Is Final Paid Amount to Vendor by Insurer Correct?"]
["s. 624.424(11)(a)","s. 624.424(11)(f)","s. 624.424(11)(f)","s.624.424(11)(t)","s.624.424(11)(t)"]
["Claim_ID","Repairs","Company_Nm","Init_Inv_Amt","Final_Paid_Amt","Trade_Secret","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation"]
[null,null,null,null,null,{"$f":"IF(Contacts!$J$4=\"YES\",\"Yes\",\"No\")","v":"No"},{"$f":"IF((AND(H7=TRUE,I7=TRUE,J7=TRUE,K7=TRUE)),TRUE,FALSE)","v":true},{"$f":"IF(COUNTBLANK(A7:E7)=5,TRUE,IF(COUNTBLANK(A7:E7)=0,TRUE,FALSE))","v":true},{"$f":"IF(ISBLANK(B7),TRUE,IF(ISNA(MATCH(B7,'Valid Responses'!$J$15:$J$25,0)),\"Error: Invalid Vendor Type\",TRUE))","v":true},{"$f":"IF(ISBLANK(D7),TRUE,IF(D7=\"UNKNOWN\",TRUE,IF(ISNUMBER(D7), TRUE, \"Error: Enter amount or 'UNKNOWN'\")))","v":true},{"$f":"IF(ISBLANK(E7),TRUE,IF(E7=\"UNKNOWN\",TRUE,IF(ISNUMBER(E7), TRUE, \"Error: Enter amount or 'UNKNOWN'\")))","v":true}]

{"sheet":"Section A-3 - Attorneys","index":5,"n_rows":7,"n_cols":26,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,2,3,2],[2,4,3,4],[2,1,3,1],[2,11,3,11],[0,7,0,10],[0,0,0,4],[2,6,3,6],[2,7,3,7],[1,0,1,23],[2,14,2,23],[2,3,3,3],[2,5,3,5],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,12,3,12],[2,13,3,13],[2,0,3,0]]}
[{"$f":"\"Section A-3: Attorney Information\"&IF(Contacts!$J$4=\"Yes\",\" - TRADE SECRET\",\"\")","v":"Section A-3: Attorney Information"},null,null,null,null,null,null,{"$f":"IF(Y1=1,TRUE,\"Section A-3 - Attorneys sheet not validated\")","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,7]
[{"$f":"\"DETAILED CLAIM INFORMATION FOR EVERY PROPERTY CLAIM CLOSED BETWEEN JANUARY 1, \" & Version!K1 & \" AND DECEMBER 31, \" & Version!K1","v":"DETAILED CLAIM INFORMATION FOR EVERY PROPERTY CLAIM CLOSED BETWEEN JANUARY 1, 2025 AND DECEMBER 31, 2025"}]
["Claim ID","Did You Receive a Property Insurance Intent to Initiate Litigation Notice? (Y/N/Unknown)","Litigation?\n(Y/N/Unknown)","Florida Bar Number","Attorney Firm","Name of Attorney","Jurisdiction of Case (See Valid Responses)","Case Number","Amount Paid for Claimant's Attorney Fees Named in Column D","Amount Paid for Claimant's Attorney Expenses Named in Column D","Contingency Fee Multiplier Requested by Claimant's Attorney in Column D","Amount of Insurer's Defense Costs for this Claim","Contingency Fee Multiplier Awarded to Attorney in Column D","Trade Secret?","VALIDATION CHECKS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Row Complete?","Required Fields Complete?","Is Y/N/Unknown Data Correct (Column B)?","Is Y/N/Unknown Data Correct (Column C)?","Is Jurisdiction of Case Correct? (See Valid Responses)","Is Data Correct (Column I)?","Is Data Correct (Column J)?","Is Data Correct (Column K)?","Is Data Correct (Column L)?","Is Data Correct (Column M)?"]
["s. 624.424(11)(a)","s.624.424(11)(t)","s. 624.424(11)(t)","s. 624.424(11)(m)","s.624.424(11)(t)","s. 624.424(11)(m)","s.624.424(11)(t)","s.624.424(11)(t)","s. 624.424(11)(p)","s. 624.424(11)(q)","s. 624.424(11)(r)","s.624.424(11)(t)","s. 624.424(11)(s)"]
["Claim_ID","Rcv_Prop_Ins_Int_Notice","Litigation","Attorney_Num","Attorney_Firm","Attorney_Nm","Case_Jurisdiction","Case_Num","Attorney_Fee_Pd","Attorney_Exp_Pd","Contingency_Fee_Req","Defense_Clm_Cost_Amt","Contingency_Fee_Awd","Trade_Secret","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation","RowValidation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Contacts!$J$4=\"YES\",\"Yes\",\"No\")","v":"No"},{"$f":"IF((AND(P7=TRUE,Q7=TRUE,R7=TRUE,S7=TRUE,T7=TRUE,U7=TRUE,V7=TRUE,W7=TRUE,X7=TRUE)),TRUE,FALSE)","v":true},{"$f":"IF(COUNTBLANK(A7:M7)=13,TRUE,IF(AND(C7<>\"Y\",COUNTBLANK(G7)=1,COUNTBLANK(A7:F7)+COUNTBLANK(H7:M7)=0),TRUE,IF(COUNTBLANK(A7:M7)=0,TRUE,FALSE)))","v":true},{"$f":"IF(OR(ISBLANK(B7),NOT(ISNA(MATCH(B7,'Valid Responses'!$J$28:$J$30,0)))),TRUE,\"Error: Select Y, N or Unknown\")","v":true},{"$f":"IF(OR(ISBLANK(C7),NOT(ISNA(MATCH(C7,'Valid Responses'!$J$28:$J$30,0)))),TRUE,\"Error: Select Y, N or Unknown\")","v":true},{"$f":"IF(AND(ISBLANK(G7),C7<>\"Y\"),TRUE,IF(AND(ISNA(MATCH(G7,'Valid Responses'!$J$33:$J$35,0)),C7=\"Y\"),\"Error: Invalid Jurisdiction\",IF(C7<>\"Y\",\"Error: Litigation <> Y, Jurisdiction must be blank\",TRUE)))","v":true},{"$f":"IF(ISBLANK(I7),TRUE,IF(I7=\"UNKNOWN\",TRUE,IF(ISNUMBER(I7), TRUE, \"Error: Enter amount or 'UNKNOWN'\")))","v":true},{"$f":"IF(ISBLANK(J7),TRUE,IF(J7=\"UNKNOWN\",TRUE,IF(ISNUMBER(J7), TRUE, \"Error: Enter amount or 'UNKNOWN'\")))","v":true},{"$f":"IF(ISBLANK(K7),TRUE,IF(K7=\"UNKNOWN\",TRUE,IF(ISNUMBER(K7), TRUE, \"Error: Enter amount or 'UNKNOWN'\")))","v":true},{"$f":"IF(ISBLANK(L7),TRUE,IF(L7=\"UNKNOWN\",TRUE,IF(ISNUMBER(L7), TRUE, \"Error: Enter amount or 'UNKNOWN'\")))","v":true},{"$f":"IF(ISBLANK(M7),TRUE,IF(M7=\"UNKNOWN\",TRUE,IF(ISNUMBER(M7), TRUE, \"Error: Enter amount or 'UNKNOWN'\")))","v":true}]

{"sheet":"Section A-4 - Public Adjuster","index":6,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,6,2,9],[1,0,1,9],[0,0,0,2],[2,0,3,0],[2,2,3,2],[2,5,3,5],[2,1,3,1],[2,3,3,3],[2,4,3,4],[0,5,0,8]]}
[{"$f":"\"Section A-4: Public Adjuster Information\"&IF(Contacts!$J$4=\"Yes\",\" - TRADE SECRET\",\"\")","v":"Section A-4: Public Adjuster Information"},null,null,null,null,{"$f":"IF(K1=1,TRUE,\"Section A-4 - Public Adjuster sheet not validated\")","v":true},null,null,null,null,1,7]
[{"$f":"\"DETAILED CLAIM INFORMATION FOR EVERY PROPERTY CLAIM CLOSED BETWEEN JANUARY 1, \" & Version!K1 & \" AND DECEMBER 31, \" & Version!K1","v":"DETAILED CLAIM INFORMATION FOR EVERY PROPERTY CLAIM CLOSED BETWEEN JANUARY 1, 2025 AND DECEMBER 31, 2025"}]
["Claim ID","DFS License Number","Name of Public Adjuster","Initial Invoice/ Demand Amount from Public Adjuster","Final Paid Amount to Public Adjuster by Insurer","Trade Secret?","VALIDATION CHECKS"]
[null,null,null,null,null,null,"Row Complete?","Required Fields Complete?","Is Data Correct (Column D)?","Is Data Correct (Column E)?"]
["s. 624.424(11)(a)","s.624.424(11)(t)","s. 624.424(11)(l)","s.624.424(11)(t)","s.624.424(11)(t)"]
["Claim_ID","Dfs_Lic_Num","Adj_Nm","Init_Inv_Amt","Final_Paid_Amt","Trade_Secret","RowValidation","RowValidation","RowValidation","RowValidation"]
[null,null,null,null,null,{"$f":"IF(Contacts!$J$4=\"YES\",\"Yes\",\"No\")","v":"No"},{"$f":"IF((AND(H7=TRUE,I7=TRUE,J7=TRUE)),TRUE,FALSE)","v":true},{"$f":"IF(COUNTBLANK(A7:E7)=5,TRUE,IF(COUNTBLANK(A7:E7)=0,TRUE,FALSE))","v":true},{"$f":"IF(ISBLANK(D7),TRUE,IF(D7=\"UNKNOWN\",TRUE,IF(ISNUMBER(D7), TRUE, \"Error: Enter amount or 'UNKNOWN'\")))","v":true},{"$f":"IF(ISBLANK(E7),TRUE,IF(E7=\"UNKNOWN\",TRUE,IF(ISNUMBER(E7), TRUE, \"Error: Enter amount or 'UNKNOWN'\")))","v":true}]

{"sheet":"Valid Responses","index":7,"n_rows":80,"n_cols":11,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,9,0,10],[12,9,12,10]]}
["Type of Policy","Description","Type of Policy",null,"Errors",null,"County of Loss",null,"Peril","Type of Peril"]
["DP-1","Dwelling Fire - Basic Coverage","Code","Description","Error: Missing Policy Type",null,"Alachua",null,"Fall Obj","Code","Description"]
["DP-3","Dwelling-Fire - Broad Coverage","DP-1","Dwelling Fire - Basic Coverage","Error: Missing County",null,"Baker",null,"Fire","AOP","All Other Perils"]
["DP-Oth","Dwelling-Fire - Other that DP-1 and DP-3","DP-3","Dwelling-Fire - Broad Coverage","Error: Missing Peril",null,"Bay",null,"Hurr","FIRE","Fire or Lightning Peril"]
["HO-3","Owners type policies, includes HO-1, HO-2, HO-3, HO-5","DP-Oth","Dwelling-Fire - Other than DP-1 and DP-3",null,null,"Bradford",null,"Water - Dis","HURR","Hurricane"]
["HO-4","Tenants policies","HO-3","Owners type policy, includes HO-1, HO-2, HO-3, HO-5",null,null,"Brevard",null,"Water - Oth","OBJ","Falling Objects Peril"]
["HO-6","Condo Unit Owners policies","HO-4","Tenants policy",null,null,"Broward",null,"Wind/Hail","OTH WATER","Water - Other than Accidental Discharge or Overflow of Water or Steam Peril"]
["HO-8","Modified Coverage Form","HO-6","Condo Unit Owners policy",null,null,"Calhoun",null,"All Other","SINK","Sinkhole"]
["MDP","Mobile Home Dwelling policy","HO-8","Modified Coverage Form policy",null,null,"Charlotte",null,null,"WATER","Accidental Discharge or Overflow of Water or Steam Peril"]
["MHO-3","Mobile Homeowners Multi-Peril policy","MDP","Mobile Home Dwelling policy",null,null,"Citrus",null,null,"WIND","Windstorm or Hail Peril - Other than Hurricane"]
["MHO-Oth","Mobile Homeowners policy - Other than MHO-3","MHO-3","Mobile Homeowners Multi-Peril policy",null,null,"Clay"]
["CRC","Commercial Residential - Condo Only policy","MHO-Oth","Mobile Homeowners policy - Other than MHO-3",null,null,"Collier"]
["CRO","Commercial Residential - Non-Condo policy","CRC","Commercial Residential - Condo Only policy (CMP and CP)",null,null,"Columbia",null,null,"Type of Vendor"]
["CNR","Commercial Non-Residential policy","CRO","Commercial Residential - Non-Condo policy (CMP and CP)",null,null,"De Soto",null,null,"Code","Description"]
["OTH","Other than listed above","OTH","Other than listed above",null,null,"Dixie",null,null,"ELEC","Electrical"]
[null,null,null,null,null,null,"Duval",null,null,"FLOOR","Flooring"]
[null,null,null,null,null,null,"Escambia",null,null,"GEN","General Contracting"]
[null,null,"(To Be Updated Yearly)",null,null,null,"Flagler",null,null,"INSPECT","Inspection"]
[null,null,"Hurricane Name",null,null,null,"Franklin",null,null,"MOLD","Mold"]
[null,null,"Other",null,null,null,"Gadsden",null,null,"OTH","Other"]
[null,null,"1985 - KATE",null,null,null,"Gilchrist",null,null,"PLUMB","Plumbing"]
[null,null,"1987 - FLOYD",null,null,null,"Glades",null,null,"PH","Policyholder"]
[null,null,"1988 - KEITH",null,null,null,"Gulf",null,null,"ROOF","Roof repairs"]
[null,null,"1992 - ANDREW",null,null,null,"Hamilton",null,null,"WATER","Water Mitigation"]
[null,null,"1994 - ALBERTO",null,null,null,"Hardee",null,null,"UNKNOWN","Unknown Vendor Type"]
[null,null,"1994 - BERYL",null,null,null,"Hendry"]
[null,null,"1994 - GORDON",null,null,null,"Hernando",null,null,"Y/N"]
[null,null,"1995 - ALLISON",null,null,null,"Highlands",null,null,"Y"]
[null,null,"1995 - ERIN",null,null,null,"Hillsborough",null,null,"N"]
[null,null,"1995 - JERRY",null,null,null,"Holmes",null,null,"Unknown"]
[null,null,"1995 - OPAL",null,null,null,"Indian River"]
[null,null,"1996 - JOSEPHINE",null,null,null,"Jackson",null,null,"Jurisdiction of Case"]
[null,null,"1998 - EARL",null,null,null,"Jefferson",null,null,"Federal Court"]
[null,null,"1998 - GEORGES",null,null,null,"Lafayette",null,null,"State Court"]
[null,null,"1998 - MITCH",null,null,null,"Lake",null,null,"DOAH"]
[null,null,"1999 - HARVEY",null,null,null,"Lee"]
[null,null,"1999 - IRENE",null,null,null,"Leon"]
[null,null,"2000 - GORDON",null,null,null,"Levy"]
[null,null,"2001 - BARRY",null,null,null,"Liberty"]
[null,null,"2001 - GABRIELLE",null,null,null,"Madison"]
[null,null,"2002 - EDOUARD",null,null,null,"Manatee"]
[null,null,"2003 - HENRI",null,null,null,"Marion"]
[null,null,"2004 - BONNIE",null,null,null,"Martin"]
[null,null,"2004 - CHARLEY",null,null,null,"Miami-Dade"]
[null,null,"2004 - FRANCES",null,null,null,"Monroe"]
[null,null,"2004 - JEANNE",null,null,null,"Nassau"]
[null,null,"2005 - ARLENE",null,null,null,"Okaloosa"]
[null,null,"2005 - DENNIS",null,null,null,"Okeechobee"]
[null,null,"2005 - KATRINA",null,null,null,"Orange"]
[null,null,"2005 - TAMMY",null,null,null,"Osceola"]
[null,null,"2005 - WILMA",null,null,null,"Palm Beach"]
[null,null,"2006 - ALBERTO",null,null,null,"Pasco"]
[null,null,"2006 - ERNESTO",null,null,null,"Pinellas"]
[null,null,"2007 - BARRY",null,null,null,"Polk"]
[null,null,"2007 - HUMBERTO",null,null,null,"Putnam"]
[null,null,"2008 - FAY",null,null,null,"Saint Johns"]
[null,null,"2009 - CLAUDETTE",null,null,null,"Saint Lucie"]
[null,null,"2010 - BONNIE",null,null,null,"Santa Rosa"]
[null,null,"2012 - BERYL",null,null,null,"Sarasota"]
[null,null,"2012 - DEBBY",null,null,null,"Seminole"]
[null,null,"2013 - ANDREA",null,null,null,"Sumter"]
[null,null,"2016 - COLIN",null,null,null,"Suwannee"]
[null,null,"2016 - HERMINE",null,null,null,"Taylor"]
[null,null,"2016 - JULIA",null,null,null,"Union"]
[null,null,"2017 - EMILY",null,null,null,"Volusia"]
[null,null,"2017 - IRMA",null,null,null,"Wakulla"]
[null,null,"2018 - ALBERTO",null,null,null,"Walton"]
[null,null,"2018 - GORDON",null,null,null,"Washington"]
[null,null,"2018 - MICHAEL",null,null,null,"UNKNOWN"]
[null,null,"2020 - ETA"]
[null,null,"2020 - SALLY"]
[null,null,"2021 - ELSA"]
[null,null,"2021 - FRED"]
[null,null,"2021 - MINDY"]
[null,null,"2022 - IAN"]
[null,null,"2022 - NICOLE"]
[null,null,"2023 - IDALIA"]
[null,null,"2024 - DEBBY"]
[null,null,"2024 - HELENE"]
[null,null,"2024 - MILTON"]