{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Fee Bill","Preparation & Attendance Time","Date Source","Task","Data Source"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":16,"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":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[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,6,8,8],[8,3,8,5],[20,2,20,4],[21,2,21,10],[21,11,21,13],[18,2,18,10],[19,3,19,16],[18,11,18,13]]}
[]
[]
[null,"Commercial - Civil Proceedings Preparation and Attendance Fee Bill Instructions"]
[]
[]
[]
[null,null,"Process Description"]
[null,null,"This rate applies when an Adjuster is needed for preparation and attendance as a fact witness for testimony at a civil proceeding, for their time spend for preparation, attendance, or testimony at a proceeding directly related to work they performed on a Citizens’ claim. (“Fact Witness Assignment”). Notice of Deposition must be submitted with all Preparation Fee invoices.\n\nThis includes, but is 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 corresponding with the subject(s) of the Fact Witness Assignment and/or their 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); \n-any other tasks not included above directly related to the Fact Witness Assignment; \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. "]
[]
[null,null,"IMPORTANT: Please read these instructions entirely to ensure accuracy of the Commercial - 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 - Enter legal name of the adjuster. \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 was working during time of claim handling.\n9. Deployed with contracted firm at time of proceeding? - Select Y (Yes) or N (No) based on the status of the adjuster seeking reimbursement at the time of     \n    proceeding. Please see below for additional information on payee:\n   •If adjuster was deployed with Firm A at the time of the civil proceeding but is now deployed with Firm B, Citizens will pay Firm A. \n   •If adjuster was not deployed at the time of the proceeding but is deployed with a firm now, Citizens will pay the adjuster directly.The adjuster will need to  \n     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' \n     into the Search field.\n   •If adjuster was deployed with a firm at the time of the civil proceeding but is not with any firm at the time of invoicing/payment, we pay the firm.\n10. Firm Name - If adjuster selected Y to previous question, select firm name from drop down list. If adjuster selected N, proceed to next section."]
[]
[null,null,"Preparation and Attendance Fees"]
[null,null,null,"1. Civil Proceedings Preparation - Enter total hours spent in preparation of the civil proceeding. Please complete the Preparation & Attendance Time tab to provide additional details regarding the total hours being submitted.\n2. Civil Proceedings Attendance - Enter total hours spent in attendance of the civil proceeding. Please complete the Preparation & Attendance Time tab to provide additional details regarding the total hours being submitted.\n3. 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. "]
[null,null,"Invoice Submission"]
[null,null,"PDF copy of this invoice should be sent to CivilProcedures@citizensfla.com"]

{"sheet":"Fee Bill","index":1,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[40,4,47,10],[17,2,17,3],[19,2,19,4],[39,8,39,10],[26,2,26,3],[17,6,17,7],[19,6,19,7],[19,9,19,10],[29,9,29,10],[27,9,27,10],[28,9,28,10],[27,6,27,7],[29,4,29,5],[18,6,18,7],[38,8,38,9],[32,9,32,10],[1,3,1,11],[2,3,2,11],[14,3,14,6],[23,2,24,10],[22,2,22,8],[6,8,6,9],[10,3,10,5],[8,3,8,5],[4,8,4,9],[20,2,20,10],[8,6,8,7],[6,6,6,7],[4,6,4,7],[8,8,8,10],[18,9,18,10],[28,6,28,7],[13,2,13,4],[10,6,12,7],[10,8,12,10],[32,6,32,7],[35,2,36,10],[33,9,33,10],[29,6,29,7],[30,6,30,7],[31,6,31,7],[30,9,30,10],[31,9,31,10]]}
[]
[null,null,null,"Commercial 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 Name:",null,null,null,"Contract:",null,"Select"]
[]
[null,null,"Insured:",null,null,null,"Case Name:"]
[]
[null,null,"Deployed with contracted firm at time of proceeding?",null,null,"Select Y/N"]
[]
[null,null,"Firm Name:","Select Firm Name"]
[]
[]
[null,null,"Preparation and Attendance Fees",null,null,null,"Total Hours",null,"Fee Amount",null,"Total"]
[null,null,"Civil Proceeding Preparation",null,null,null,null,null,130,{"$f":"G19*I19","v":0}]
[null,null,"Civil Proceeding Attendance",null,null,null,null,null,130,{"$f":"G20*I20","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":"I28","v":0}]
[null,null,"Meal(s)",null,null,null,null,null,null,{"$f":"I29","v":0}]
[null,null,"Mileage",null,"Enter Total Miles:",null,null,null,0.44500000000000001,{"$f":"G30*I30","v":0}]
[null,null,"Parking",null,null,null,null,null,null,{"$f":"I31","v":0}]
[null,null,"Tolls",null,null,null,null,null,null,{"$f":"I32","v":0}]
[null,null,"Other Expenses**",null,null,null,null,null,null,{"$f":"I33","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('Fee Bill'!J19:K20,J28:K33)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(#REF!=\"yes\",O39=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,"PDF copy of this invoice should be sent to CivilProcedures@citizensfla.com"]
[null,null,null,null,null,null,null,null,null,null,null,"Version: 2/25/2025"]

{"sheet":"Preparation & Attendance Time","index":2,"n_rows":59,"n_cols":8,"rows_kept":59,"cut":false,"hidden":false,"merged":[[34,4,34,6],[20,4,20,6],[21,4,21,6],[33,4,33,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[22,4,22,6],[27,4,27,6],[55,3,55,6],[56,3,56,6],[57,3,57,6],[58,2,58,4],[58,5,58,6],[54,3,54,6],[41,2,41,7],[42,3,42,5],[43,3,43,5],[44,3,44,5],[45,3,45,5],[46,5,46,6],[48,3,48,5],[49,3,49,5],[50,3,50,5],[51,3,51,5],[52,2,52,4],[40,3,40,5],[35,4,35,6],[36,4,36,6],[37,4,37,6],[38,4,38,6],[39,4,39,6],[12,2,12,3],[14,2,14,7],[2,1,2,8],[4,1,4,2],[6,1,6,2],[8,1,8,2],[10,1,10,2],[10,3,10,5],[8,5,8,6]]}
[]
[]
[null,"Preparation and Attendance Details"]
[]
[null,"Insured:",null,{"$f":"IF('Fee Bill'!D11=0,\"\",'Fee Bill'!D11)","v":""}]
[]
[null,"Claim #:",null,{"$f":"IF('Fee Bill'!D7=0,\"\",'Fee Bill'!D7)","v":""},"Policy #:",{"$f":"IF('Fee Bill'!I7=0,\"\",'Fee Bill'!D7)","v":""}]
[]
[null,"Adjuster Name:",null,{"$f":"IF('Fee Bill'!D9=0,\"\",'Fee Bill'!D9)","v":""},"Case Name:",{"$f":"IF('Fee Bill'!I11=0,\"\",'Fee Bill'!I11)","v":""}]
[]
[null,"Firm:",null,{"$f":"IF('Fee Bill'!D15=\"Select Firm Name\",\"\",'Fee Bill'!D15)","v":""}]
[]
[]
[]
[null,null,"Preparation and Attendance Details"]
[null,null,"Date","Type of Work","Details",null,null,"Hours"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[null,null,null,"Select"]
[]
[]
[null,null,"Date","Clerical Work on File",null,null,"Hours","Total"]
[null,null,null,null,null,null,null,{"$f":"G44*25","v":0}]
[null,null,null,null,null,null,null,{"$f":"G45*25","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,"Sub Total:",null,{"$f":"SUM(H44:H46)","v":0}]
[]
[null,null,"Date","Mileage & Tolls",null,null,"Mileage","Tolls"]
[]
[]
[]
[null,null,null,null,null,"Totals:",{"$f":"SUM(G50:G52)","v":0},{"$f":"SUM(H50:H52)","v":0}]
[]
[null,null,"Date","Miscellaneous Expenses",null,null,null,"Total"]
[]
[]
[]
[null,null,null,null,null,"Sub Total:",null,{"$f":"SUM(H56:H58)","v":0}]

{"sheet":"Date Source","index":3,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Select"]
["Phone Conferencing"]
["File Review"]
["Deposition Preparation"]
["Deposition Testimony"]
["Review Deposition Transcript"]
["Affidavit Preparation and Execution"]
["TPS Preparation "]
["TPS Testimony"]
["Trial Preparation"]
["Trial Testimony"]

{"sheet":"Task","index":4,"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":5,"n_rows":12,"n_cols":16,"rows_kept":12,"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"]
["Alacrity Solutions Group, LLC","9725 WINDERMERE BOULEVARD","FISHERS IN, 46037","47-2172761",null,"Associate Adjuster",120,null,"Associate Adjuster",80,null,"Drive Time",null,"Yes",null,"Commercial Adjusting Services"]
["Allcat Claims Service",null,null,null,null,"Commercial Adjuster",135,null,"Commercial Adjuster",90,null,"Adjuster Work",null,"No",null,"Comprehensive Adjusting Services"]
["Bradley Stinson & Associates, Inc","110 E. Broward Blvd Suite 1700 ","Fort Lauderdale, FL 33301","20-4576372",null,"Executive General Adjuster",225,null,"Executive General Adjuster",150]
["CNC Catastrophe and National Claims"]
["Crawford and Company","5335 Triangle Pkwy NW","Peachtree Corners GA 30092","58-0506554"]
["Eberl Claims Service LLC"]
["FKS Insurance Services","PO BOX 16848 ","St Petersburg FL 33733","47-3173696"]
["Global Risk Solutions Inc"]
["Pacesetter Claims Service Inc"]
["Pilot Catastrophe Services, Inc.","P.O. BOX 91299","Mobile AL, 36691","63-1012513"]