{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lot Date Analysis","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Lot Date Analysis","index":0,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Finishing Schedule",null,null,null,null,null,"Report Date:"]
[]
["Construction Priority","Lot #","Closing Date"]

{"sheet":"Data","index":1,"n_rows":265,"n_cols":7,"rows_kept":265,"cut":false,"hidden":false,"merged":[]}
["Lot Count",39]
["Key Date Count",3]
["Lot Key Date Count",83]
["Lateness Threshold",7]
["Report Date","2025-01-15"]
[]
["Lot Priority","Lot Code","Closing Date"]
[0,"PHASE 1-LOT0001","2025-02-05"]
[0,"PHASE 1-LOT0002","2024-04-30"]
[0,"PHASE 1-LOT0003","2024-04-17"]
[0,"PHASE 1-LOT0004"]
[0,"PHASE 1-LOT0005"]
[0,"PHASE 1-LOT0042"]
[0,"PHASE 1-LOT0043"]
[0,"PHASE 1-LOT0044"]
[0,"PHASE 1-LOT0045"]
[0,"PHASE 1-LOT0046"]
[0,"PHASE 1-LOT0047"]
[1,"PHASE 1-LOT0006"]
[1,"PHASE 1-LOT0007"]
[1,"PHASE 1-LOT0008"]
[2,"PHASE 1-LOT0009"]
[2,"PHASE 1-LOT0010"]
[2,"PHASE 1-LOT0011"]
[2,"PHASE 1-LOT0012"]
[2,"PHASE 1-LOT0013",null,"Bold","Uppercase","Font Color","Backgroup Color"]
[2,"PHASE 1-LOT0014",null,"No","No","Black","White"]
[2,"PHASE 1-LOT0015",null,"Yes","No","White","Black"]
[2,"PHASE 1-LOT0016",null,"No","No","Black","Yellow"]
[2,"PHASE 1-LOT0017",null,"No","No","Black","Yellow"]
[2,"PHASE 1-LOT0018",null,"Bold","Uppercase","Font Color","Backgroup Color"]
[2,"PHASE 1-LOT0019",null,"No","No","Black","White"]
[2,"PHASE 1-LOT0020",null,"No","No","Black","White"]
[2,"PHASE 1-LOT0021",null,"No","No","Black","White"]
[2,"PHASE 1-LOT0022",null,"No","No","Black","White"]
[2,"PHASE 1-LOT0023",null,"No","No","Black","White"]
[2,"PHASE 1-LOT0024",null,"No","No","Black","White"]
[2,"PHASE 1-LOT0025",null,"No","No","Black","White"]
[2,"PHASE 1-LOT0026",null,"No","No","Black","White"]
[2,"PHASE 1-LOT0028",null,"No","No","Black","White"]
[2,"PHASE 1-LOT0029","2024-04-30","No","No","Black","White"]
[2,"PHASE 1-LOT0032","2025-02-04","No","No","Black","White"]
[2,"PHASE 1-LOT0033","2025-01-30","No","No","Black","White"]
[2,"PHASE 1-LOT0040",null,"Actual Date","Backgroup Color","Black","White"]
[2,"PHASE 1-LOT0041",null,null,"White"]
[2,"PHASE 1-OVERHEAD L",null,"2023-01-24","Yellow"]
["SV1-L001","ELEC INSP","2023-02-01","2023-02-01","Green"]
["Key Date Code","Key Date Name","Font Size","Bold","Uppercase","Font Color","Backgroup Color"]
["EXCAVATION","EXCAVATION","8","Yes","No","Green","White"]
["FOUNDATION","FOUNDATION","8","No","No","Black","White"]
["FRAMING INSPECTION","FRAMING INSPECTION","8","No","No","Black","White"]
["SV1-L001","FRAM SUB 2","2022-12-09","2022-11-28","Green"]
["Lot Code","Key Date Code","Scheduled Date","Actual Date","Backgroup Color"]
["PHASE 1-LOT0001","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0001","FOUNDATION","2024-07-30",null,"Red"]
["PHASE 1-LOT0001","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0002","EXCAVATION","2024-04-22","2024-04-17","Green"]
["PHASE 1-LOT0002","FOUNDATION","2025-02-10",null,"White"]
["PHASE 1-LOT0003","EXCAVATION","2023-09-26","2023-09-26","Green"]
["PHASE 1-LOT0003","FOUNDATION","2025-02-18",null,"White"]
["PHASE 1-LOT0004","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0004","FOUNDATION","2024-12-09",null,"Red"]
["PHASE 1-LOT0004","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0005","EXCAVATION","2024-04-16",null,"Red"]
["PHASE 1-LOT0005","FOUNDATION","2024-05-17",null,"Red"]
["PHASE 1-LOT0005","FRAMING INSPECTION","2024-04-19",null,"Red"]
["PHASE 1-LOT0006","EXCAVATION","2024-04-22",null,"Red"]
["PHASE 1-LOT0006","FOUNDATION","2024-05-15",null,"Red"]
["PHASE 1-LOT0007","EXCAVATION","2024-04-22",null,"Red"]
["PHASE 1-LOT0007","FOUNDATION","2024-05-17",null,"Red"]
["PHASE 1-LOT0008","EXCAVATION","2024-04-30",null,"Red"]
["PHASE 1-LOT0008","FOUNDATION","2024-05-09",null,"Red"]
["PHASE 1-LOT0009","EXCAVATION","2024-04-17",null,"Red"]
["PHASE 1-LOT0009","FOUNDATION","2024-05-21",null,"Red"]
["PHASE 1-LOT0010","EXCAVATION","2024-04-22","2024-04-17","Green"]
["PHASE 1-LOT0010","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0011","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0011","FOUNDATION","2024-05-24","2024-04-18","Green"]
["PHASE 1-LOT0011","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0012","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0012","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0013","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0013","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0014","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0014","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0015","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0015","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0016","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0016","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0017","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0017","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0018","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0018","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0019","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0019","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0020","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0020","FOUNDATION","2025-02-07",null,"White"]
["PHASE 1-LOT0020","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0021","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0021","FOUNDATION","2025-02-07",null,"White"]
["PHASE 1-LOT0021","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0022","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0022","FOUNDATION","2025-02-07",null,"White"]
["PHASE 1-LOT0022","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0023","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0023","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0023","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0024","EXCAVATION","2024-08-07","2024-08-07","Green"]
["PHASE 1-LOT0024","FOUNDATION","2024-09-13",null,"Red"]
["PHASE 1-LOT0024","FRAMING INSPECTION","2024-11-04",null,"Red"]
["PHASE 1-LOT0025","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0025","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0025","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0026","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0026","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0026","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0028","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0028","FOUNDATION","2024-07-30","2024-07-30","Green"]
["PHASE 1-LOT0028","FRAMING INSPECTION","2024-09-18","2024-09-18","Green"]
["PHASE 1-LOT0029","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0029","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0029","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0032","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0032","FOUNDATION","2025-02-07",null,"White"]
["PHASE 1-LOT0032","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0033","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0033","FOUNDATION","2024-11-11",null,"Red"]
["PHASE 1-LOT0033","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0040","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0040","FOUNDATION","2025-01-28",null,"White"]
["PHASE 1-LOT0040","FRAMING INSPECTION",null,null,"White"]
["PHASE 1-LOT0041","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0042","FOUNDATION",null,null,"White"]
["PHASE 1-LOT0043","EXCAVATION",null,null,"White"]
["PHASE 1-LOT0043","FOUNDATION","2025-02-11",null,"White"]
["PHASE 1-LOT0043","FRAMING INSPECTION",null,null,"White"]
["SV1-L009","FOOT INSP","2023-10-13",null,"Red"]
["SV1-L009","FRAM INSP","2023-12-07",null,"Red"]
["SV1-L009","FRAM SUB 1","2023-11-15",null,"Red"]
["SV1-L009","FRAM SUB 2","2023-12-01",null,"Red"]
["SV1-L009","PDI","2024-03-15",null,"Red"]
["SV1-L009","QC INSPECT","2024-03-01",null,"Red"]
["SV1-L009","WINDOWS","2023-12-14",null,"Red"]
["SV1-L010","CLS FINAL","2024-03-18",null,"Red"]
["SV1-L010","DRYWALLING","2024-01-17",null,"Red"]
["SV1-L010","ELEC INSP","2024-01-12",null,"Red"]
["SV1-L010","ELEC WIRE","2024-01-11",null,"Red"]
["SV1-L010","FOOT INSP","2023-10-13",null,"Red"]
["SV1-L010","FRAM INSP","2023-12-07",null,"Red"]
["SV1-L010","FRAM SUB 1","2023-11-15",null,"Red"]
["SV1-L010","FRAM SUB 2","2023-12-01",null,"Red"]
["SV1-L010","PDI","2024-03-15",null,"Red"]
["SV1-L010","QC INSPECT","2024-03-01",null,"Red"]
["SV1-L010","WINDOWS","2023-12-14",null,"Red"]
["SV1-L011","CLS FINAL","2024-03-18",null,"Red"]
["SV1-L011","DRYWALLING","2024-01-12",null,"Red"]
["SV1-L011","ELEC WIRE","2024-01-08",null,"Red"]
["SV1-L011","FOOT INSP","2023-10-13",null,"Red"]
["SV1-L011","FRAM INSP","2023-12-06",null,"Red"]
["SV1-L011","FRAM SUB 1","2023-10-26",null,"Red"]
["SV1-L011","FRAM SUB 2","2023-11-16",null,"Red"]
["SV1-L011","PDI","2024-03-04",null,"Red"]
["SV1-L011","QC INSPECT","2024-02-28",null,"Red"]
["SV1-L011","WINDOWS","2023-12-08",null,"Red"]
["SV1-TEMP1","CLS FINAL",null,null,"White"]
["SV1-TEMP1","DRYWALLING",null,null,"White"]
["SV1-TEMP1","ELEC WIRE",null,null,"White"]
["SV1-TEMP1","FOOT INSP",null,null,"White"]
["SV1-TEMP1","FRAM INSP",null,null,"White"]
["SV1-TEMP1","FRAM SUB 1",null,null,"White"]
["SV1-TEMP1","FRAM SUB 2",null,null,"White"]
["SV1-TEMP1","PDI",null,null,"White"]
["SV1-TEMP1","QC INSPECT",null,null,"White"]
["SV1-TEMP1","WINDOWS",null,null,"White"]
["SV1-TN01","CLS FINAL","2021-10-08",null,"Red"]
["SV1-TN01","DRYWALLING","2021-08-12",null,"Red"]
["SV1-TN01","ELEC WIRE","2021-08-06",null,"Red"]
["SV1-TN01","FOOT INSP","2021-04-23",null,"Red"]
["SV1-TN01","FRAM INSP","2021-06-29",null,"Red"]
["SV1-TN01","FRAM SUB 1","2021-05-26",null,"Red"]
["SV1-TN01","FRAM SUB 2","2021-06-17",null,"Red"]
["SV1-TN01","PDI","2021-10-07",null,"Red"]
["SV1-TN01","QC INSPECT","2021-09-23",null,"Red"]
["SV1-TN01","WINDOWS","2021-07-07",null,"Red"]
["SV1-TN02","CLS FINAL","2021-09-30",null,"Red"]
["SV1-TN02","DRYWALLING","2021-08-04",null,"Red"]
["SV1-TN02","ELEC WIRE","2021-07-29",null,"Red"]
["SV1-TN02","FOOT INSP","2021-04-15",null,"Red"]
["SV1-TN02","FRAM INSP","2021-06-21",null,"Red"]
["SV1-TN02","FRAM SUB 1","2021-05-18",null,"Red"]
["SV1-TN02","FRAM SUB 2","2021-06-09",null,"Red"]
["SV1-TN02","PDI","2021-09-29",null,"Red"]
["SV1-TN02","QC INSPECT","2021-09-15",null,"Red"]
["SV1-TN02","WINDOWS","2021-06-28",null,"Red"]
["SV1-TN03","CLS FINAL","2021-10-04",null,"Red"]
["SV1-TN03","DRYWALLING","2021-08-06",null,"Red"]
["SV1-TN03","ELEC WIRE","2021-08-02",null,"Red"]
["SV1-TN03","FOOT INSP","2021-04-19",null,"Red"]
["SV1-TN03","FRAM INSP","2021-06-23",null,"Red"]
["SV1-TN03","FRAM SUB 1","2021-05-20",null,"Red"]
["SV1-TN03","FRAM SUB 2","2021-06-11",null,"Red"]
["SV1-TN03","PDI","2021-10-01",null,"Red"]
["SV1-TN03","QC INSPECT","2021-09-17",null,"Red"]
["SV1-TN03","WINDOWS","2021-06-30",null,"Red"]
["SV1-TN04","CLS FINAL","2021-10-07",null,"Red"]
["SV1-TN04","DRYWALLING","2021-08-11",null,"Red"]
["SV1-TN04","ELEC WIRE","2021-08-05",null,"Red"]
["SV1-TN04","FOOT INSP","2021-04-22",null,"Red"]
["SV1-TN04","FRAM INSP","2021-06-28",null,"Red"]
["SV1-TN04","FRAM SUB 1","2021-05-25",null,"Red"]
["SV1-TN04","FRAM SUB 2","2021-06-16",null,"Red"]
["SV1-TN04","PDI","2021-10-06",null,"Red"]
["SV1-TN04","QC INSPECT","2021-09-22",null,"Red"]
["SV1-TN04","WINDOWS","2021-07-06",null,"Red"]
["SV1-TN05","CLS FINAL","2024-08-27",null,"Red"]
["SV1-TN05","DRYWALLING","2024-06-25",null,"Red"]
["SV1-TN05","ELEC WIRE","2024-06-19",null,"Red"]
["SV1-TN05","FOOT INSP","2024-03-12",null,"Red"]
["SV1-TN05","FRAM INSP","2024-05-15",null,"Red"]
["SV1-TN05","FRAM SUB 1","2024-03-25",null,"Red"]
["SV1-TN05","FRAM SUB 2","2024-04-19",null,"Red"]
["SV1-TN05","PDI","2024-08-13",null,"Red"]
["SV1-TN05","QC INSPECT","2024-08-08",null,"Red"]
["SV1-TN05","WINDOWS","2024-05-17",null,"Red"]
["SV1-TN06","CLS FINAL","2024-08-27",null,"Red"]
["SV1-TN06","DRYWALLING","2024-06-25",null,"Red"]
["SV1-TN06","ELEC WIRE","2024-06-19",null,"Red"]
["SV1-TN06","FOOT INSP","2024-03-12",null,"Red"]
["SV1-TN06","FRAM INSP","2024-05-15",null,"Red"]
["SV1-TN06","FRAM SUB 1","2024-03-25",null,"Red"]
["SV1-TN06","FRAM SUB 2","2024-04-19",null,"Red"]
["SV1-TN06","PDI","2024-08-13",null,"Red"]
["SV1-TN06","QC INSPECT","2024-08-08",null,"Red"]
["SV1-TN06","WINDOWS","2024-05-17",null,"Red"]
["SV1-TN07","CLS FINAL","2024-08-27",null,"Red"]
["SV1-TN07","DRYWALLING","2024-06-25",null,"Red"]
["SV1-TN07","ELEC WIRE","2024-06-19",null,"Red"]
["SV1-TN07","FOOT INSP","2024-03-12",null,"Red"]
["SV1-TN07","FRAM INSP","2024-05-15",null,"Red"]
["SV1-TN07","FRAM SUB 1","2024-03-25",null,"Red"]
["SV1-TN07","FRAM SUB 2","2024-04-19",null,"Red"]
["SV1-TN07","PDI","2024-08-13",null,"Red"]
["SV1-TN07","QC INSPECT","2024-08-08",null,"Red"]
["SV1-TN07","WINDOWS","2024-05-17",null,"Red"]
["SV1-TN08","CLS FINAL","2024-08-27",null,"Red"]
["SV1-TN08","DRYWALLING","2024-06-25",null,"Red"]
["SV1-TN08","ELEC WIRE","2024-06-19",null,"Red"]
["SV1-TN08","FOOT INSP","2024-03-12",null,"Red"]
["SV1-TN08","FRAM INSP","2024-05-15",null,"Red"]
["SV1-TN08","FRAM SUB 1","2024-03-25",null,"Red"]
["SV1-TN08","FRAM SUB 2","2024-04-19",null,"Red"]
["SV1-TN08","PDI","2024-08-13",null,"Red"]
["SV1-TN08","QC INSPECT","2024-08-08",null,"Red"]
["SV1-TN08","WINDOWS","2024-05-17",null,"Red"]
["SV1-ZZ-TEST","CLS FINAL",null,null,"White"]
["SV1-ZZ-TEST","DRYWALLING",null,null,"White"]
["SV1-ZZ-TEST","ELEC INSP",null,null,"White"]
["SV1-ZZ-TEST","ELEC WIRE",null,null,"White"]
["SV1-ZZ-TEST","FOOT INSP",null,null,"White"]
["SV1-ZZ-TEST","FRAM INSP",null,null,"White"]
["SV1-ZZ-TEST","FRAM SUB 1",null,null,"White"]
["SV1-ZZ-TEST","FRAM SUB 2",null,null,"White"]
["SV1-ZZ-TEST","PDI",null,null,"White"]
["SV1-ZZ-TEST","QC INSPECT",null,null,"White"]
["SV1-ZZ-TEST","WINDOWS",null,null,"White"]