{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sub contractors","Sheet2","ProjectClient Team"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"Sub contractors","index":0,"n_rows":46,"n_cols":29,"rows_kept":46,"cut":false,"hidden":false,"merged":[[11,26,11,28],[5,8,5,9],[5,6,5,7],[6,6,6,7],[9,23,9,24],[7,8,7,9],[7,10,7,11],[6,12,6,13],[6,10,6,11],[6,8,6,9],[8,23,8,24],[5,18,5,19],[6,18,6,19],[7,12,7,13],[11,12,11,23],[8,19,8,20],[5,1,5,2],[7,1,7,2],[8,1,8,2],[8,3,8,4],[9,6,9,13],[9,19,9,20],[5,3,5,4],[7,3,7,4],[7,6,7,7],[8,17,8,18],[9,17,9,18],[5,12,5,13],[5,10,5,11],[4,1,4,2],[3,1,3,2],[3,3,3,4],[4,3,4,4],[4,8,4,9],[3,17,3,19],[4,18,4,19],[4,6,4,7],[2,3,2,4],[3,8,3,9],[3,12,3,13],[4,12,4,13],[3,10,3,11],[4,10,4,11],[3,6,3,7]]}
[]
[null,null,"Subcontractor Directory"]
[]
[null,"Project No.:",null,null,null,null,null,null,"Name",null,"Tel:",null,"Email:",null,null,null,null,"Denaploy Member"]
[null,"Project Title",null,null,null,null,"Commercial Manager",null,null,null,null,null,null,null,null,null,null,"Name"]
[null,"Project Value",null,null,null,null,"Project Manager ",null,null,null,null,null,null,null,null,null,null,"Tel:"]
[null,null,null,null,null,null,"Project Surveyor ",null,null,null,null,null,null,null,null,null,null,"Email:"]
[null,"Draft Date",null,null,null,null,"Document Controller"]
[null,"Handover Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Setup Date:",null,null,null,null,null,"Manual Total"]
[null,null,null,null,null,null,"Note: To create a new line please press Alt+Return within Cell",null,null,null,null,null,null,null,null,null,null,"Initial Email Date:",null,null,null,null,null,{"$f":"SUM(Y14:Y46)/COUNT(Y14:Y46)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Please note that this is used for internal tracking and reviews",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vetted by "]
["Comments (Office Use Only)","Vol\n(Office Use Only)","Works\nPackages","Sub Contractor","Address","Contact Name","T:","Tel","M:","Mob","E:","Email","Contractor","Scope of Works","Operating Procedures","Care & Maintenance","Health & Safety","Residual Risks","Warranty","Recommended\nSpares","Manufacturers Literature","Asset Register","Certificates","Record Drawings","Total",null,"Reviewer ","Comments","Date"]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",{"$f":"(COUNTIF(M14:X14,\"Approved\")+COUNTIF(M14:X14,\"Not Applicable\"))/COUNTA(M14:X14)","v":0}]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",{"$f":"COUNTIF(M15:X15,\"Approved\")/COUNTA(M15:X15)","v":0}]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",{"$f":"(COUNTIF(M25:X25,\"Approved\")+COUNTIF(M25:X25,\"Not Applicable\"))/COUNTA(M25:X25)","v":0}]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",{"$f":"COUNTIF(M26:X26,\"Approved\")/COUNTA(M26:X26)","v":0}]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",{"$f":"(COUNTIF(M36:X36,\"Approved\")+COUNTIF(M36:X36,\"Not Applicable\"))/COUNTA(M36:X36)","v":0}]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",{"$f":"COUNTIF(M37:X37,\"Approved\")/COUNTA(M37:X37)","v":0}]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]
[null,null,null,null,null,null,"T:",null,"M:",null,"E:",null,"Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…","Pending…",0]

{"sheet":"Sheet2","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Pending…"]
["Not Applicable"]
["Received"]
["Approved"]

{"sheet":"ProjectClient Team","index":2,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,19],[2,3,2,4],[3,1,3,2],[3,3,3,4],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,15,3,17],[4,16,4,17],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,16,5,17],[4,1,4,2],[4,3,4,4],[4,6,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,13],[6,6,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,13],[6,16,6,17],[9,6,9,13],[9,15,9,16],[9,17,9,18],[7,12,7,13],[8,1,8,2],[8,3,8,4],[8,15,8,16],[8,17,8,18],[7,1,7,2],[7,3,7,4],[7,6,7,7],[7,8,7,9],[7,10,7,11]]}
[]
[null,"Project/Client Directory"]
[]
[null,"Project No.:",null,{"$f":"'Sub contractors'!D4","v":0},null,null,null,null,"Name",null,"Tel:",null,"Email:",null,null,"Denaploy Member"]
[null,"Project Title",null,{"$f":"'Sub contractors'!D5","v":0},null,null,"Senior Contracts Manager",null,{"$f":"'Sub contractors'!I5","v":0},null,{"$f":"'Sub contractors'!K5","v":0},null,{"$f":"'Sub contractors'!M5","v":0},null,null,"Name",{"$f":"'Sub contractors'!S5","v":0}]
[null,"Project Value",null,{"$f":"'Sub contractors'!D6","v":0},null,null,"Contracts Manager",null,{"$f":"'Sub contractors'!I6","v":0},null,{"$f":"'Sub contractors'!K6","v":0},null,{"$f":"'Sub contractors'!M6","v":0},null,null,"Tel:",{"$f":"'Sub contractors'!S6","v":0}]
[null,null,null,null,null,null,"Site Manager",null,{"$f":"'Sub contractors'!I7","v":0},null,{"$f":"'Sub contractors'!K7","v":0},null,{"$f":"'Sub contractors'!M7","v":0},null,null,"Email:",{"$f":"'Sub contractors'!S7","v":0}]
[null,"Draft Date",null,{"$f":"'Sub contractors'!D8","v":"00:00:00"},null,null,"Document Controller",null,{"$f":"'Sub contractors'!I8","v":0},null,{"$f":"'Sub contractors'!K8","v":0},null,{"$f":"'Sub contractors'!M8","v":0}]
[null,"Handover Date:",null,{"$f":"'Sub contractors'!D9","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,"Setup Date:",null,{"$f":"'Sub contractors'!T9","v":"00:00:00"}]
[null,null,null,null,null,null,"Note: To create a new line please press Alt+Return within Cell",null,null,null,null,null,null,null,null,"Initial Email Date:",null,{"$f":"'Sub contractors'!T10","v":"00:00:00"}]
[]
[]
[null,"Role / Title","Role","Address","Contact Name",null,"Tel",null,"Mob",null,"Email"]
[null,null,null,null,null,"T:",null,"M:",null,"E:"]
[null,null,null,null,null,"T:",null,"M:",null,"E:"]
[null,null,null,null,null,"T:",null,"M:",null,"E:"]
[null,null,null,null,null,"T:",null,"M:",null,"E:"]
[null,null,null,null,null,"T:",null,"M:",null,"E:"]
[null,null,null,null,null,"T:",null,"M:",null,"E:"]
[null,null,null,null,null,"T:",null,"M:",null,"E:"]
[null,null,null,null,null,"T:",null,"M:",null,"E:"]
[null,null,null,null,null,"T:",null,"M:",null,"E:"]
[null,null,null,null,null,"T:",null,"M:",null,"E:"]