{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Audax bordereau"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Audax bordereau","index":0,"n_rows":3,"n_cols":111,"rows_kept":3,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Handler","Client/Leader","London Broker","Coverholder","Local Broker","TPA name","Agreement #","UMR","Contract Inception","Contract Expiry","YOA","Reporting Period (End Date)","Lloyd's Risk Code","Section #","Original Currency","Settlement Currency","Rate of Exchange","Row #","Certificate Reference / Policy Number","Claim Reference (UCR)","XCS Reference (COR)","UWS Reference (COR)","London Broker Reference","Local Broker Reference","TPA Reference","Policy Holder","Insured Full Name or Company Name","Insured State, Province, Territory, Canton, etc","Insured Country","Location of Risk: State, Province, Territory, Canton, etc","Location of Risk: Country","Risk Inception Date","Risk Expiry Date","Risk Retroactivity Date","Location of Loss: State, Province, Territory, Canton, etc","Location of Loss: Country","Risk Deductible Amount","Risk Deductible Basis","Risk Sums Insured Amount (limit EEC)","Risk Annual Aggregate","Cause of Loss","Loss Description","Date of Loss (from)","Date of Loss (to)","Date Claim Made (Date of Discovery)","Claim Status","Refer to Underwriters","Denial","Complaint","Claimant Name","Paid this month - Indemnity","Paid this month - Fees","Previously Paid - Indemnity","Previously Paid - Fees (total)","Reserve - Indemnity","Reserve - Fees","Change this month - Indemnity","Change this month - Fees","Total Incurred - Indemnity","Total Incurred - Fees","Paid this month - Expenses","Paid this month - Attorney Coverage Fees","Paid this month - Adjusters Fees","Paid this month - Defence Fees","Paid this month - TPA Fees","Previously Paid - Expenses","Previously Paid - Attorney Coverage Fees","Previously Paid - Adjusters Fees","Previously Paid - Defence Fees","Previously Paid - TPA Fees","Reserve - Expense","Reserve - Attorney Coverage Fees","Reserve - Adjusters Fees","Reserve - Defence Fees","Reserve - TPA Fees","Total Incurred","MPL","MPL %","Triage Code","Date First Advised / Notification Date","Date Closed","Experts (Layer/Adjuster/attorney/etc) Role","Experts (Layer/Adjuster/attorney/etc) Firm/Company name","Experts (Layer/Adjuster/attorney/etc) Exp.Ref.#","Experts (Layer/Adjuster/attorney/etc) Notes","Claim Status Changes: Date Claim Opened","Claim Status Changes: Date Coverage Confirmed","Claim Status Changes: Date Claim Amount Agreed","Claim Status Changes: Date Claim Paid","Claim Status Changes: Date Fees Paid","Claim Status Changes: Date Reopened","Claim Status Changes: Date of Surrogation","Date Claim Denied","Reason for Denial","Amount Claimed","Settlement Value","Date Claim Withdrawn","Ex Gratia Payment","Date Claim Closed","Claim not paid as within excess","Type of Loss code","Type of Cover","Handling Officer","Date of Birth","Age Patient","CP LMA (BD%)","LMA (BD%)","CAE (BD%)","DS Code","Type of Loss","MPL Code"]
["GT","Beazley","Rockville","Gava Broker",null,"Audax srl","B1177140500 RKV","B1177140500","14/07/2014","31/07/2015",2014,"12/2017","D3","1a","EUR","EUR",null,null,"10411606B",{"$nulls":5},"PO15G24001C","Provincia di Terni","Provincia di Terni","Umbria","IT","Umbria","IT","31/12/2014","31/12/2015","31/12/2009","Umbria","IT",10000,null,1500000,5000000,"Negligence",null,"09/06/2008",null,"16/07/2015","closed","Y","Y","N","Rit srl",0,null,0,3204.58,null,null,null,3204.58,0,3204.58,0,0,0,0,0,0,0,2904.58,0,300,{"$nulls":5},3204.58,null,null,null,"24/07/2015","17/02/2016",{"$nulls":4},"24/07/2015",{"$nulls":6},"17/08/2015","claim excluded not covered",1290450,0,null,null,"17/02/2016",null,"TT","E","RK",null,0,0,0,0]
["0H","Beazley","Rockville","Gava Broker",null,"Audax srl","B1177120500 RKV","B1177120500 ","14/07/2012","14/07/2013",2012,"12/2017","D3","1a","EUR","EUR",null,null,1730730,null,null,"2013OTHR00038",null,null,"PO17E23001C","Provincia di Terni","Provincia di Terni","Umbria","IT","Umbria","IT","31/12/2012","31/12/2013","31/12/2007","Umbria","IT",10000,null,1500000,1500000,"Negligence",null,"01/06/2009",null,"10/01/2013","closed","Y","N","N","Public Prosecutor  2059 2011",0,null,0,3609.13,null,420.87,null,4030,0,4030,0,0,0,0,0,0,0,3579.13,0,30,null,null,420.87,null,null,4030,800000,null,null,"15/01/2013",{"$nulls":5},"23/05/2017",{"$nulls":8},300000,0,{"$nulls":4},"OT","E","RK",null,0,0,0,0]