{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Fee Bill","Task","Data Source"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[18,2,18,10],[19,3,19,16],[18,11,18,13],[2,1,4,17],[7,2,7,17],[12,3,12,17],[15,3,15,17],[17,2,17,4],[14,2,14,6],[11,2,11,3],[9,2,9,17],[8,3,8,6],[8,7,8,9]]}
[]
[]
[null,"Civil Proceedings Preparation and Attendance Fee Bill Instructions"]
[]
[]
[]
[null,null,"Process Description"]
[null,null,"The Civil Proceedings Preparation and Attendance Fee Bill is to request compensation for a deployment of an adjuster whose participation is needed at a civil proceeding. Compensation is paid at a flat fee for the adjuster's time spent for preparation, attendance, or testimony at a proceeding directly related to work they performed on a Citizens' claim. A single non-contingent daily flat fee of $450.00 will be paid for total preparation time, with a separate non-contingent flat fee of $525.00 paid for travel to and attendance at a proceeding. If the preparation meeting with Citizens’ Outside Counsel occurs on the same day as attendance at the civil proceeding, the Preparation Fee will be included within the Attendance Fee, for a total single payment of $525. Notice of Deposition must be submitted with all Preparation Fee invoices\n\nThe Assignment Fee of $75 is upon receipt of assignment.\n\nThe Preparation Fee of $450.00 includes, but are not limited to, the following activities:\n-receipt of the Fact Witness Assignment and on-going contact by telephone and email with Citizens and/or Citizens' Outside Counsel until the conclusion of the Fact Witness Assignment;\n-updating Citizens and/or Citizens' Outside Counsel with all communications, documents and activities related to the Fact Witness Assignment;\n-scheduling and correspondence with the subject(s) of the Fact Witness Assignment and/or the representative(s);\n-review of the claim file and related material in advance of attendance or testimony (to include any meetings/preparation in association with Citizens' Outside Counsel); and;\n-any other tasks not included above directly related to the Fact Witness Assignment.\n\nThe Attendance Fee of $525.00 includes, but not limited to, the following activities:\n-time spent traveling to and from each proceeding;\n-time spent testifying at each proceeding;\n-if requested by Citizens and/or Citizens' Outside Counsel, a brief post testimony consultation; and;\n-any other tasks not included above directly related to the Fact Witness Assignment.\n-Note: The Fact Witness Attendance Fee may be provided for multiple days to accommodate travel time in excess of one (1) day."]
[null,null,null,"PDF copy of this invoice should be sent to ",null,null,null,"CivilProcedures@citizensfla.com."]
[null,null,"IMPORTANT: Please read these instructions entirely to ensure accuracy of the Civil Proceedings Preparation and Attendance Fee Bill before submitting for reimbursement. Invoices not submitted within 12 months of the services requested are forfeited for failure to submit an invoice in a timely manner."]
[]
[null,null,"Top"]
[null,null,null,"1. Invoice Date - Enter the date the invoice is created.\n2. Invoice # - If applicable, insert invoice number.\n3. Claim # - Enter the Citizens claim number. \n4. Policy # - Enter the Citizens policy number.\n5. Adjuster/Appraiser - Enter legal name of the adjuster/appraiser. \n6. Case Name - Enter the case name (example: Joe Smith vs Citizens)\n7. Insured - Enter the insured's name as it appears on the claim.\n8. Contract - Select contract that the adjuster/appraiser was working during time of claim handling.\n9. Are you currently deployed with a contracted firm - Select Y (Yes) or N (No) based on current status of the adjuster/appraiser seeking reimbursement.\nNOTE: If adjuster/appraiser seeking reimbursement is no longer working with a contracted firm, the adjuster/appraiser will also need to complete a W-9 Request for Taxpayer Identification Number and Certification form. The W-9 form can be found at www.citizensfla.com and typing in 'IRS W-9' into the Search field.\n10. Firm Name - If adjuster/appraiser selected Y to previous question, select firm name from drop down list. If adjuster/appraiser selected N, proceed to next section."]
[]
[null,null,"Preparation and Attendance Fees"]
[null,null,null,"1. Civil Proceedings Assignment Fee – Enter one under Total Days for assignment fee.\n2. Civil Proceedings Preparation - Enter one under Total Days spent in preparation of the civil proceeding. Only one Preparation Fee per civil proceeding.\n3. Civil Proceedings Attendance - Enter total number of days spent in attendance of the civil proceeding.\n4. Comments - Enter the dates for preparation and/or attendance entries from above. Enter any additional comments applicable to the civil proceeding preparation or attendance."]
[]
[null,null,"Travel Reimbursement"]
[null,null,"Travel reimbursement is subject to vendor travel guidelines and are available online at ",null,null,null,null,null,null,null,null,"https://www.citizensfla.com/b2b."]
[null,null,null,"1. Lodging - Enter the total amount spent for lodging.\n2. Meals -  Enter the total amount spent for meals purchased during onsite preparation and attendance. \n3. Mileage - Enter the total miles traveled for onsite preparation and attendance. A total of $0.445 is paid per mile traveled.  \n4. Parking - Enter the total amount paid for parking, not to exceed $8 per day.\n5. Tolls - If tolls are incurred during travel for onsite preparation and attendance, enter total amount.\n6. Other Expenses - Enter total amount spent for other expenses incurred during preparation and attendance that were not previously listed. Properly document other expenses in the comments box below.\n7. Comments - If travel reimbursement is applicable for the above categories, please provide a brief detailed description outlining the expenses incurred. Receipt copies are also requested to accompany fee bill. "]

{"sheet":"Fee Bill","index":1,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[30,6,30,7],[19,9,19,10],[10,8,12,10],[10,6,12,7],[31,6,31,7],[32,6,32,7],[39,8,39,9],[31,9,31,10],[32,9,32,10],[33,9,33,10],[33,6,33,7],[36,2,37,10],[34,9,34,10],[1,3,1,11],[2,3,2,11],[14,3,14,6],[24,2,25,10],[23,2,23,8],[6,8,6,9],[10,3,10,5],[8,3,8,5],[4,8,4,9],[21,2,21,10],[8,6,8,7],[8,8,8,9],[6,6,6,7],[4,6,4,7],[41,4,48,10],[17,2,17,3],[20,2,20,4],[40,8,40,10],[27,2,27,3],[17,6,17,7],[18,6,18,7],[20,6,20,7],[18,9,18,10],[20,9,20,10],[30,9,30,10],[28,9,28,10],[29,9,29,10],[28,6,28,7],[30,4,30,5],[29,6,29,7]]}
[]
[null,null,null,"Civil Proceeding Preparation and Attendance Fee Bill"]
[]
[]
[null,null,"Invoice Date:",null,null,null,"Invoice #:"]
[]
[null,null,"Claim #:",null,null,null,"Policy #:"]
[]
[null,null,"Adjuster/Appraiser:",null,null,null,"Contract:",null,"Select"]
[]
[null,null,"Insured:",null,null,null,"Case Name:"]
[]
[null,null,"Are you currently deployed with a contracted firm?",null,null,"Select Y/N"]
[]
[null,null,"Firm Name:","Select Firm Name"]
[]
[]
[null,null,"Preparation and Attendance Fees",null,null,null,"Total Days",null,"Fee Amount",null,"Total"]
[null,null,"Civil Proceeding Assignment Fee",null,null,null,null,null,75,{"$f":"G19*I19","v":0}]
[null,null,"Civil Proceeding Preparation",null,null,null,null,null,450,{"$f":"G20*I20","v":0}]
[null,null,"Civil Proceeding Attendance",null,null,null,null,null,525,{"$f":"G21*I21","v":0}]
[null,null,"*Invoices not submitted within 12 months of the services requested are forfeited for failure to submit an invoice in a timely manner."]
[]
[null,null,"Comments:  i.e. Civil proceedings preparation date(s) and/or attendance date(s)."]
[]
[]
[]
[null,null,"Travel Reimbursement*",null,null,null,null,null,"Fee Amount",null,"Total"]
[null,null,"Lodging",null,null,null,null,null,null,{"$f":"I29","v":0}]
[null,null,"Meal(s)",null,null,null,null,null,null,{"$f":"I30","v":0}]
[null,null,"Mileage",null,"Enter Total Miles:",null,null,null,0.44500000000000001,{"$f":"G31*I31","v":0}]
[null,null,"Parking",null,null,null,null,null,null,{"$f":"I32","v":0}]
[null,null,"Tolls",null,null,null,null,null,null,{"$f":"I33","v":0}]
[null,null,"Other Expenses**",null,null,null,null,null,null,{"$f":"I34","v":0}]
[null,null,"*Travel reimbursement is subject to the Vendor Travel Reimbursement Guidelines located on Citizens’ website at:",null,null,null,null,null,null,"https://www.citizensfla.com/b2b"]
[null,null,"**If applicable, explain other expenses in box below:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Invoice Total",null,{"$f":"SUM(J19:K21,J29:K34)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(#REF!=\"yes\",O40=TRUE),\"Minimum Supplement Fee Applies\",\"\"),\"\")","v":""}]
[null,null,null,null,"Alteration of the automatically generated data on this form, before or after printing to Portable Data Format (PDF), is expressly forbidden. Submission of this invoice by the above noted firm, hereafter referred to as \"vendor\", constitutes acknowledgement and confirmation that this invoice includes:\n     1.  Fees and payments for all employees, agents, prior approved subcontractors or other \n          persons in vendor's employment who have performed work contemplated by this agreement. \n     2.  The full amount of all charges known to be owed at the time of submission of this invoice.\n     3.  Vendor will pay all above parties appropriate compensation, wages, payments, benefits or \n          the like (\"Compensation\") due as of the date of this submitted invoice."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version: 02/25/2025"]

{"sheet":"Task","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Task Assignment Model",null,null,"Task Assignment Model"]
["Fee Schedule",null,null,"Fee Schedule"]
[]
["GCA Amount","GCA Fee",null,"GCA Amount","GCA Fee"]
[0.01,1188,null,0.01,660]
[10000.01,1303.5,null,10000.01,790]
[15000.01,1452.0000000000002,null,15000.01,880]
[20000.009999999998,1501.5000000000002,null,20000.009999999998,910]
[25000.01,1721.5000000000002,null,25000.01,1045]
[30000.01,1787.5000000000002,null,30000.01,1075]
[35000.01,2271.5,null,35000.01,1375]
[40000.01,2447.5,null,40000.01,1485]
[50000.01,2997.5000000000005,null,50000.01,1815]
[75000.009999999995,4207.5,null,75000.009999999995,2550]
[100000.01,5263.5,null,100000.01,3190]
[150000.01,6715.5000000000009,null,150000.01,4070]
[200000.01,8893.5,null,200000.01,5390]
[300000.01,10890,null,300000.01,6600]
[500000.01,15246.000000000002,null,500000.01,9240]
[750000.01,23045.000000000004,null,750000.01,13970]
[1000000.01,2.5000000000000001E-2,null,1000000.01,1.4999999999999999E-2]

{"sheet":"Data Source","index":3,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":true,"merged":[[0,0,0,3],[0,5,0,6],[0,8,0,9]]}
["Firms",null,null,null,null,"Adjuster rates",null,null,"Adjuster rates",null,null,"Type of work",null,"Select Y/N",null,"Contract"]
["Select Firm Name","Address 1","Street State Zip","EIN",null,"Select",null,null,"Select",null,null,"Select",null,"Select Y/N",null,"Select"]
["Accelerated Adjusting LLC",null,null,null,null,"Associate Adjuster",120,null,"Associate Adjuster",80,null,"Drive Time",null,"Yes",null,"Appraisal"]
["Administrative Strategies LLC",null,null,null,null,"Commercial Adjuster",135,null,"Commercial Adjuster",90,null,"Adjuster Work",null,"No",null,"IA Non-Litigated/Catastrophe"]
["Alacrity Solutions Group, LLC","9725 WINDERMERE BOULEVARD","FISHERS IN, 46037",null,null,"General Adjuster",180,null,"General Adjuster",120,null,null,null,null,null,"IA Catastrophe"]
["Allied American Adjusting Company, LLC",null,null,null,null,"Executive General Adjuster",225,null,"Executive General Adjuster",150,null,null,null,null,null,"IA Catastrophe 2018"]
["Alternative Claims Services, Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fast Track Adjusting Services"]
["Aziel Corporation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Field Inspection Services"]
["Bradley Stinson & Associates, Inc","110 E. Broward Blvd Suite 1700 ","Fort Lauderdale, FL 33301","20-4576372"]
["BrightClaim, LLC","PO Box 502048","ATLANTA GA, 30350","20-1702730"]
["Burton Claim Service, Inc"]
["Calibrated Insurance Services, LLC"]
["Catastrophe Response Unit USA Inc"]
["CenterPoint Claims Service Inc"]
["CIS Group LLC"]
["Claims Questions LLC"]
["CNC Catastrophe & National Claims"]
["Crawford and Company"]
["DDC of Florida LLC","720 GOODLETT ROAD N STE 400","NAPLES, FL 34102","82-2884047"]
["Engage Solutions, Inc"]
["FKS Insurance Services"]
["Global Risk Solutions, Inc"]
["Hammerman and Gainer LLC"]
["Ideal Adjusting Inc"]
["Inspection Depot"]
["Insure-Aid Claims Service"]
["Integrated Responders Group"]
["J and D Claim Services Inc"]
["Jimmie Giles Financial LLC"]
["Leading Edge Claims Service"]
["Legacy Claim Services LLC"]
["Lozano Insurance Adjusters Inc"]
["National Catastrophe Adjusters Inc","9725 WINDERMERE BOULEVARD","FISHERS IN, 46037","36-3306934"]
["Pacesetter Claims Service Inc"]
["Prime Consulting Group, Inc"]
["Pyka & Associates, Inc."]
["Quality Assurance Adjusting Services Inc","203 SW 8TH AVE STE 412","AMARILLO, TX 79101","46-1048695"]
["RYZE Claim Solution, LLC"]
["S&S Claims Service, Inc"]
["Straight Line Global"]
["Syndicate Claim Services"]
["TNT Adjusting & Inspection Services Inc."]
["US CAT Adjusters, LLC"]
["WCC, INC."]