{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Milestone Calculator"],"not_rendered":{"charts":0,"images":2,"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":"Milestone Calculator","index":0,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
[]
[null,null,null,null,"MILESTONE CALCULATOR"]
[]
[null,null,null,null,"Offer Sent Date","07/02/2024"]
[]
[null,null,null,null,"MW Effective Date","2030-10-30"]
[]
[null,null,null,null,"Days until Contracted Completion",{"$f":"_xlfn.DAYS($F6,$F4)","v":2457}]
[]
[null,null,null,null,"Milestone 1",{"$f":"IF($F6<=$F4+729,\"BNeg\",IF(AND($F6<=$F4+1094,$F6>=$F4+730),EDATE($F6,-18),IF(AND($F6<=$F4+1459,$F6>=$F4+1095),EDATE($F6,-24),IF(AND($F6<=$F4+1824,$F6>=$F4+1460),EDATE($F6,-36), IF($F6>=$F4+1825,EDATE($F6,-48),0)))))","v":"2026-10-30"}]
[]
[null,null,null,null,"Milestone 2",{"$f":"IF($F6<=$F4+729,\"BNeg\",IF(AND($F6<=$F4+1094,$F6>=$F4+730),EDATE($F6,-12), IF(AND($F6<=$F4+1459,$F6>=$F4+1095),EDATE($F6,-18), IF(AND($F6<=$F4+1824,$F6>=$F4+1460),EDATE($F6,-24), IF($F6>=$F4+1825,EDATE($F6,-30),0)))))","v":"2028-04-30"}]
[]
[null,null,null,null,"Milestone 3",{"$f":"IF($F6<=$F4+729,\"BNeg\",IF(AND($F6<=$F4+1094,$F6>=$F4+730),EDATE($F6,-21), IF(AND($F6<=$F4+1459,$F6>=$F4+1095),EDATE($F6,-27), IF(AND($F6<=$F4+1824,$F6>=$F4+1460),EDATE($F6,-39), IF($F6>=$F4+1825,EDATE($F6,-51),0)))))","v":"2026-07-30"}]
[]
[null,null,null,null,"Milestone 4","n/a"]
[]
[null,null,null,null,"Milestone 5",{"$f":"IF($F6<=$F4+729,\"BNeg\",IF(AND($F6<=$F4+1094,$F6>=$F4+730),EDATE($F6,-12),IF(AND($F6<=$F4+1459,$F6>=$F4+1095),EDATE($F6,-15),IF(AND($F6<=$F4+1824,$F6>=$F4+1460),EDATE($F6,-18), IF($F6>=$F4+1825,EDATE($F6,-21),0)))))","v":"2029-01-30"}]
[]
[null,null,null,null,"Milestone 6",{"$f":"IF($F6<=$F4+729,\"BNeg\",IF(AND($F6<=$F4+1094,$F6>=$F4+730),EDATE($F6,-9), IF(AND($F6<=$F4+1459,$F6>=$F4+1095),EDATE($F6,-12), IF(AND($F6<=$F4+1824,$F6>=$F4+1460),EDATE($F6,-15), IF($F6>=$F4+1825,EDATE($F6,-18),0)))))","v":"2029-04-30"}]
[]
[null,null,null,null,"Milestone 7",{"$f":"IF($F6<=$F4+729,\"BNeg\",IF(AND($F6<=$F4+1094,$F6>=$F4+730),EDATE($F6,-6), IF(AND($F6<=$F4+1459,$F6>=$F4+1095),EDATE($F6,-9), IF(AND($F6<=$F4+1824,$F6>=$F4+1460),EDATE($F6,-12), IF($F6>=$F4+1825,EDATE($F6,-15),0)))))","v":"2029-07-30"}]
[]
[null,null,null,null,"Milestone 8",{"$f":"IF($F6<=$F4+729,\"BNeg\",IF(AND($F6<=$F4+1094,$F6>=$F4+730),EDATE($F6,-3), IF(AND($F6<=$F4+1459,$F6>=$F4+1095),EDATE($F6,-6), IF(AND($F6<=$F4+1824,$F6>=$F4+1460),EDATE($F6,-9), IF($F6>=$F4+1825,EDATE($F6,-12),0)))))","v":"2029-10-30"}]
[]
[]
[null,null,null,"Instructions:"]
[null,null,null,"Use the Date Picker to select a date"]
[null,null,null,"Click the Run Button to view Milestones"]
[null,null,null,"Clear the Form before selecting a new date to ensure accurate Milestones"]
[]
[]
[null,null,null,"To enable this calculator for use you will need to ensure it is downloaded and saved to a Trusted Location"]
[null,null,null,"In Excel open a wokbook and go to File/Options/Trust Centre/Trust Centre Settings/Trusted Locations"]
[null,null,null,"Add New Location for where you will save your file"]
[null,null,null,"Move your downloaded calculator into your Trusted Location"]