{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Recordofclaim","Table"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":17,"comments":1,"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":"Sheet1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Recordofclaim","index":1,"n_rows":260,"n_cols":13,"rows_kept":260,"cut":false,"hidden":false,"merged":[[2,0,2,10],[5,9,5,10],[6,9,6,10],[9,9,9,10],[10,9,10,10],[7,2,7,4],[8,2,8,4],[11,2,11,4],[12,2,12,4],[9,2,9,4],[6,2,6,4],[5,2,5,4]]}
[]
[null,null,null,null,null,"Please send the completed form to:","warrantyclaimcanada@travelers.com"]
["Notice of Claim"]
[]
[null,"Claim Number:",null,null,null,null,null,null,"Warranty Expiry Dates:"]
[null,"Claimant/Owner Name:",null,null,null,null,null,null,"1st year:/15 Months"]
[null,"Address:",null,null,null,null,null,null,"2nd year:"]
[null,"Contact Phone#"]
[null,"Contact Email:"]
[null,"Warranty #:",null,null,null,null,null,null,"5 year:"]
[null,"Warranty Type:",null,null,null,null,null,null,"10 year:"]
[null,"Builder:"]
[null,"Last update by: "]
[null,"Last update: "]
[]
["Item #","Date Submitted to Travelers","Location","Room/Area","General Type/ Category","Description of Claim","Reference Doc","Investigation Results","Travelers Position","Date Claim Item Resolved","Owner Acknowledgement","Comments","Claim Amount"]
[{"$f":"IF(B17<>0,1,IF(C17<>0,1,IF(F17<>0,1,IF(G17<>0, 1,IF(H17<>0,1,IF(I17<>0,1,IF(J17<>0,1,IF(K17<>0,1,IF(L17<>0,1,\"\")))))))))","v":""}]
[{"$f":"IF(B18<>0,A17+1,IF(C18<>0,A17+1,IF(F18<>0,A17+1,IF(G18<>0,A17+ 1,IF(H18<>0,A17+1,IF(I18<>0,A17+1,IF(J18<>0,A17+1,IF(K18<>0,A17+1,IF(L18<>0,A17+1,\"\")))))))))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B83<>0,A82+1,IF(C83<>0,A82+1,IF(F83<>0,A82+1,IF(G83<>0,A82+ 1,IF(H83<>0,A82+1,IF(I83<>0,A82+1,IF(J83<>0,A82+1,IF(K83<>0,A82+1,IF(L83<>0,A82+1,\"\")))))))))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B147<>0,A146+1,IF(C147<>0,A146+1,IF(F147<>0,A146+1,IF(G147<>0,A146+ 1,IF(H147<>0,A146+1,IF(I147<>0,A146+1,IF(J147<>0,A146+1,IF(K147<>0,A146+1,IF(L147<>0,A146+1,\"\")))))))))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B211<>0,A210+1,IF(C211<>0,A210+1,IF(F211<>0,A210+1,IF(G211<>0,A210+ 1,IF(H211<>0,A210+1,IF(I211<>0,A210+1,IF(J211<>0,A210+1,IF(K211<>0,A210+1,IF(L211<>0,A210+1,\"\")))))))))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Table","index":2,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investigation Required by Builder"]
[null,null,null,null,null,"Column G",null,null,null,null,null,null,"Completed"]
[null,null,null,null,null," ",null,null,null,null,null,null,"In Progress"]
[null,null,null,null,null,"Investigation Required by Builder",null,null,null,null,null,null,"No Action"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Request Inspection (CAI)"]
[null,null,null,null,null,"Warrantable Item, action required",null,null,null,null,null,null,"Request Mediation"]
[null,null,null,null,null,"Concern related to Common Property"]
[null,null,null,null,null,"Not Warrantable, applicable warranty expired",null,null,null,null,null,null,"Warrantable Item"]
[null,null,null,null,null,"Not Warrantable, exclusion applies",null,null,null,null,null,null,"In Progress"]
[null,null,null,null,null,"Not Warrantable, no action required",null,null,null,null,null,null,"Request Inspection (CAI)"]
[null,null,null,null,null,"Not Warrantable, no defect noted",null,null,null,null,null,null,"Request Mediation"]
[null,"Type",null,null,null,"Not Warrantable - see comments"]
[null,"Common Property",null,null,null,"Warrantable item, resolved prior to inspection",null,null,null,null,null,null,"Concern related to Common Property"]
[null,"Block",null,null,null,"Outside Scope of Warranty Policy"]
[null,"Single Family",null,null,null,"Concern related to Unit, Unit Owner required to file claim"]
[null,"Unit",null,null,null,null,null,null,null,null,null,null,"Not Warrantable, applicable warranty expired "]
[null,"Column I",null,null,null,null,null,null,null,null,null,null,"Request Mediation"]
[null,"Completed"]
[null,"In Progress",null,null,null,null,null,null,null,null,null,null,"Not Warrantable, exclusion applies "]
[null,"No Action",null,null,null,null,null,null,null,null,null,null,"Request Mediation"]
[null,"Request Inspection (CAI)"]
[null,"Request Mediation",null,null,null,null,null,null,null,null,null,null,"Insufficient notice of claim  "]
[]
[null,null,null,null,null,null,"In Progress"]
[null,null,null,null,null,"Warrantable Item, action required","Request Inspection (CAI)",null,null,null,null,null,"Outside Scope of Warranty Policy (Contractual) "]
[null,null,null,null,null,null,"Request Mediation",null,null,null,null,null,"Request Mediation"]
[null,null,null,null,null,null,"Completed"]
[null,null,null,null,null,"Investigation Required by Builder","In Progress"]
[null,null,null,null,null,null,"No Action"]
[null,null,null,null,null,null,"Request Inspection (CAI)",null,null,null,null,null,"Entry",null,null,"Top Floor",null,"Floors"]
[null,null,null,null,null,null,"Request Mediation",null,null,null,null,null,"Hallway",null,null,"Middle Floor",null,"Floor Covering"]
[null,null,null,null,null,null,"?",null,null,null,null,null,"Living Room",null,null,"Ground Floor",null,"Walls"]
[null,null,null,null,null,"Not Warrantable, no action required","?",null,null,null,null,null,"Family Room",null,null,"Basement",null,"Ceilings"]
[null,null,null,null,null,"Concern related to Unit, Owner required to file claim",null,null,null,null,null,null,"Kitchen",null,null,null,null,"Doors-Interior"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bathroom",null,null,null,null,"Windows"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bedroom",null,null,null,null,"Tile"]
[null,null,null,null,null,"Notice of Claim",null,null,null,null,null,null,"Mud/Laundry",null,null,null,null,"Lighting"]
[null,null,null,null,null,"Record of Claim",null,null,null,null,null,null,"Den/Study/Office",null,null,null,null,"Paint"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Basement",null,null,null,null,"Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Staircase"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Garage"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Deck"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Exterior"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Roof"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Driveway/Walkway"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lobby"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Parkade"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mechanical Room"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other"]