{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["1) Questionnaire","2) HealthAssessment","3) SpendPlan","4) Milestones","5) Contract Management","RiskStrategyDefinitions","DeliverablesTracking","OPM Assessment","LOOKUPS","EvaluationCriteria"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":85,"comments":3,"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":"1) Questionnaire","index":0,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[13,11,13,14],[14,11,14,14],[15,11,15,14],[1,5,1,6],[3,5,5,13],[7,5,8,13],[9,11,9,14],[10,11,10,14],[11,11,11,14],[12,11,12,14]]}
[{"$f":"CurrentVersion","v":"v6.02"}]
[null,"Health Assessment Questionnaire",null,null,null,"Select Reporting Month",null,"Jul/FY23"]
[null,"Responding accurately to the following questions will help determine the status of the project for this reporting period."]
[null,"SCOPE",null,null,null,"Please use the drop down options to respond to the 16 questions to the left. "]
[null,"1. Does the project have a well documented and approved project scope [such that it can be leveraged in the RFP(s)] consistent with the intentions of the project charter?",null,{"$f":"IF(OR(C12=0,C10=0,C8=0,C6=0),\"ERROR\",IF(OR(C12=2,C8=3,C6=3),\"R\",IF(OR(C10=1,C8=2,C6=2),\"Y\",IF(AND(C12=1,C10=2,C8=1,C6=1),\"G\",\"ERROR\"))))","v":"ERROR"}]
[null,"Select One  >",{"$f":"VLOOKUP(B6,Q1Lookup,2,FALSE)","v":0}]
[null,"2. Does the project have an actively managed backlog/list of features/specification/requirements?"]
[null,"Select One  >",{"$f":"VLOOKUP(B8,Q2Lookup,2,FALSE)","v":0},null,null,"The questionnaire should be completed each month."]
[null,"3. Has new scope been identified that must be added to the original scope in order to deliver a minimally viable product?"]
[null,"Select One  >",{"$f":"VLOOKUP(B10,Q3Lookup,2,FALSE)","v":0},null,null,null,null,null,null,"Complete?","Status","Agency Comment"]
[null,"4. Is the project being developed/delivered in accordance with DoIT's SDLC principles, and in keeping with agile methods, tools, and techniques?",null,null,null,null,null,null,"Scope Section: ",{"$f":"IF(Rating_Scope=\"ERROR\",\"x\",\"ü\")","v":"x"},{"$f":"Health_Assessment_Scope","v":"ERROR"}]
[null,"Select One  >",{"$f":"VLOOKUP(B12,Q4Lookup,2,FALSE)","v":0},null,null,null,null,null,"Schedule Section: ",{"$f":"IF(Rating_Schedule=\"ERROR\",\"x\",\"ü\")","v":"x"},{"$f":"Health_Assessment_Schedule","v":"ERROR"}]
[null,"SCHEDULE",null,null,null,null,null,null,"Cost Section: ",{"$f":"IF(Rating_Costs=\"ERROR\",\"x\",\"ü\")","v":"x"},{"$f":"Health_Assessment_Cost","v":"ERROR"}]
[null,"5. Does the project have an approved project schedule that identifies, at a minimum, critical path tasks, milestones and/or deliverables?",null,{"$f":"IF(OR(C17=0,C15=0),\"ERROR\",IF(OR(C17=3,C15=3),\"R\",IF(OR(C17=2,C15=2),\"Y\",IF(AND(C17=1,C15=1),\"G\",\"ERROR\"))))","v":"ERROR"},null,null,null,null,"Risks Section: ",{"$f":"IF(Rating_Risks=\"ERROR\",\"x\",\"ü\")","v":"x"},{"$f":"Health_Assessment_Risk","v":"ERROR"}]
[null,"Select One  >",{"$f":"VLOOKUP(B15,Q5Lookup,2,FALSE)","v":0},null,null,null,null,null,"Quality Section: ",{"$f":"IF(Rating_Quality=\"ERROR\",\"x\",\"ü\")","v":"x"},{"$f":"Health_Assessment_Quality","v":"ERROR"}]
[null,"6. Regarding critical path tasks, milestones/deliverables:",null,null,null,null,null,null,"Resources Section: ",{"$f":"IF(Rating_Resources=\"ERROR\",\"x\",\"ü\")","v":"x"},{"$f":"Health_Assessment_Resources","v":"ERROR"}]
[null,"Select One  >",{"$f":"VLOOKUP(B17,Q6Lookup,2,FALSE)","v":0},null,null,null,null,null,"Health Assessment Questionnaire: ",{"$f":"IF(Rating_Overall=\"ERROR\",\"x\",\"ü\")","v":"x"}]
[null,"COSTS"]
[null,"7. Does the project have an approved budget?",null,{"$f":"IF(OR(C28=0,C26=0,C24=0,C22=0,C20=0),\"ERROR\",IF(OR(C28=3,C26=3,C24=3,C22=3,C20=3),\"R\",IF(OR(C28=2,C26=2,C24=2,C22=2,C20=2),\"Y\",IF(AND(C28=1,C26=1,C24=1,C22=1,C20=1),\"G\",\"ERROR\"))))","v":"ERROR"}]
[null,"Select One  >",{"$f":"VLOOKUP(B20,Q7Lookup,2,FALSE)","v":0}]
[null,"8. Has the agency submitted a Budget Amendment for this Fiscal Year?"]
[null,"Select One  >",{"$f":"VLOOKUP(B22,Q8Lookup,2,FALSE)","v":0}]
[null,"9. Is the Estimated cost At Completion (EAC) less than or equal to Budgeted cost At Completion (BAC)?"]
[null,"Select One  >",{"$f":"VLOOKUP(B24,Q9Lookup,2,FALSE)","v":0}]
[null,"10. Is the project trending to complete on or below the approved FY budget and spend plan?"]
[null,"Select One  >",{"$f":"VLOOKUP(B26,Q10Lookup,2,FALSE)","v":0}]
[null,"11. Is the project recording/tracking actual costs against the project, at least, monthly?"]
[null,"Select One  >",{"$f":"VLOOKUP(B28,Q11Lookup,2,FALSE)","v":0}]
[null,"RISKS"]
[null,"12. Does the project have an approved Risk Management Plan in place that incorporates a Risk Register which 1) identifies risk Impact and Probability AND 2) documents the appropriate risk response strategy(ies) (avoidance, transference, mitigation, acceptance)?",null,{"$f":"IF(OR(C33=0,C31=0),\"ERROR\",IF(OR(C33=3,C31=3),\"R\",IF(OR(C33=2,C31=2),\"Y\",IF(AND(C33=1,C31=1),\"G\",\"ERROR\"))))","v":"ERROR"}]
[null,"Select One  >",{"$f":"VLOOKUP(B31,Q12Lookup,2,FALSE)","v":0}]
[null,"13. Does the project periodically review and update (as appropriate) the Risk Register?"]
[null,"Select One  >",{"$f":"VLOOKUP(B33,Q13Lookup,2,FALSE)","v":0}]
[null,"QUALITY"]
[null,"14. Does the project have an approved Quality Management Plan or Quality processes (as defined in the PMBOK) in place?",null,{"$f":"IF(OR(C38=0,C36=0),\"ERROR\",IF(OR(C38=3,C36=3),\"R\",IF(OR(C38=2,C36=2),\"Y\",IF(AND(C38=1,C36=1),\"G\",\"ERROR\"))))","v":"ERROR"}]
[null,"Select One  >",{"$f":"VLOOKUP(B36,Q14Lookup,2,FALSE)","v":0}]
[null,"15. Is the project in compliance with its approved Quality Management Plan or Quality processes?"]
[null,"Select One  >",{"$f":"VLOOKUP(B38,Q15Lookup,2,FALSE)","v":0}]
[null,"RESOURCES"]
[null,"16. With regard to key personnel/critical roles/resources directly affecting critical path activities, is the project is fully staffed?",null,{"$f":"IF(C41=0,\"ERROR\",IF(C41=3,\"R\",IF(C41=2,\"Y\",IF(C41=1,\"G\",\"ERROR\"))))","v":"ERROR"}]
[null,"Select One  >",{"$f":"VLOOKUP(B41,Q16Lookup,2,FALSE)","v":0}]
[null,null,null,{"$f":"IF(ISNA(MATCH(\"ERROR\",D5:D40,0)),IF(ISNA(MATCH(\"R\",D5:D40,0)),IF(ISNA(MATCH(\"Y\",D5:D40,0)),IF(ISNA(MATCH(\"G\",D5:D40,0)),\"ERROR\",\"G\"),\"Y\"),\"R\"),\"ERROR\")","v":"ERROR"}]

{"sheet":"2) HealthAssessment","index":1,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[[15,10,15,14],[16,10,16,14],[8,10,8,17],[9,10,9,17],[10,10,10,17],[11,10,11,14],[12,10,12,14],[13,10,13,14],[14,10,14,14],[19,10,19,14],[20,10,20,14],[21,10,21,17],[22,10,22,17],[17,1,17,6],[17,8,17,9],[17,10,17,14],[18,1,18,6],[18,8,18,9],[18,10,18,14],[19,1,19,9],[1,1,1,4],[1,5,1,6],[1,7,1,9],[1,10,1,14],[2,5,2,6],[2,7,2,9],[2,10,2,14],[5,13,7,13],[5,14,7,14],[5,15,7,15],[5,16,7,16],[2,1,2,4],[3,1,3,9],[3,10,3,17],[4,10,4,11],[5,10,7,11],[5,12,7,12],[5,17,7,17],[4,1,7,9],[8,1,8,9],[9,1,9,9],[10,1,10,9],[11,1,11,6],[11,8,11,9],[12,8,12,9],[15,8,15,9],[16,8,16,9],[12,1,12,6],[13,1,13,6],[13,8,13,9],[14,1,14,6],[14,8,14,9],[15,1,15,6],[16,1,16,6]]}
[{"$f":"CurrentVersion","v":"v6.02"}]
[null,"Project Name / Enterprise Portfolio Name",null,null,null,"Hosting Agency",null,"Project Manager",null,null,"Participating Agencies",null,null,null,null,"FY Start","Procurement Awarded","Reporting Period "]
[null,"[Project Name]",null,null,null,"[Hosting Agency Name]",null,"[PM Name]",null,null,"[Agency's Name]",null,null,null,null,"[MITDP FY Start]","[FY of Award]",{"$f":"Reporting_Month","v":"Jul/FY23"}]
[null,"Project Description",null,null,null,null,null,null,null,null,"Health Status"]
[null,"[Enter the Project description]",null,null,null,null,null,null,null,null,"Overall Status",null,"Scope","Schedule","Cost","Risk","Quality","Resources"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Rating_Overall","v":"ERROR"},null,{"$f":"Rating_Scope","v":"ERROR"},{"$f":"Rating_Schedule","v":"ERROR"},{"$f":"Rating_Costs","v":"ERROR"},{"$f":"Rating_Risks","v":"ERROR"},{"$f":"Rating_Quality","v":"ERROR"},{"$f":"Rating_Resources","v":"ERROR"}]
[]
[]
[null,"Successes During the Reporting Period",null,null,null,null,null,null,null,null,"Changes / Impacts / Action Items"]
[null,"[Use this space to report and successes that have occurred since the last report submission.]",null,null,null,null,null,null,null,null,"[Use this section to inform DoIT of any scope changes, risks that have been realized and the impacts of the risk becoming an issue, and action items/next steps for resolution of the scope change or issue.]"]
[null,"Impediments / Risks",null,null,null,null,null,null,null,null," Milestones / Deliverables"]
[null,"Description",null,null,null,null,null,"Strategy","Details",null,"Milestones and Feature Completion",null,null,null,null,"Status","Baseline/Plan","Actual"]
[null," [Use this section to identify key project risks or impediments to success.  Provide the strategy for ",null,null,null,null,null,null,null,null,"[Use this section to identify key project milestones and status.]",null,null,null,null,"Not Started"]
[null,"  managing the risk and details.  Refer to the RiskStrategyDefinitions tab for guidance.]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Started"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Started"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Started"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Started"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Started"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Started"]
[null,"Program Increment / Release Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Started"]
[null,"Release","Increment  1","Story","Increment 2","Story","Increment 3","Story","Increment 4","Story",null,null,null,null,null,"Not Started"]
[null,"Team","Complete Date","Acceptance %","Complete Date","Acceptance %","Complete Date","Acceptance %","Complete Date","Acceptance %","Funding / Spending"]
[null,null,null,null,null,null,null,null,null,null,"Appropriated / Projected for out years (in whole numbers)"]
[null,null,null,null,null,null,null,null,null,null,"Type","Prior FYs",{"$f":"\"FY\"&FISCAL_START","v":"FY23"},{"$f":"\"FY\"&FISCAL_START+1","v":"FY24"},{"$f":"\"FY\"&FISCAL_START+2","v":"FY25"},{"$f":"\"FY\"&FISCAL_START+3","v":"FY26"},"OUTYEARS","Total Funding"]
[null,null,null,null,null,null,null,null,null,null,"Funding ",0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"SUM(L25:Q25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Spending",0.0,{"$f":"ActualsToDate","v":0},0.0,0.0,0.0,0.0,0]
[null,null,null,null,null,null,null,null,null,null,"Cost Variance",{"$f":"L25-L26","v":0},0,0,0,0,0,0]

{"sheet":"3) SpendPlan","index":2,"n_rows":72,"n_cols":47,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,4,0,11],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[2,1,2,3],[4,1,4,2],[4,22,4,23],[4,24,4,25],[4,26,4,27],[4,31,4,33],[4,8,4,9],[4,10,4,11],[4,12,4,13],[4,14,4,15],[4,16,4,17],[4,18,4,19],[4,20,4,21],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[4,4,4,5],[4,6,4,7],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[6,18,6,19],[6,20,6,21],[6,22,6,23],[6,24,6,25],[6,26,6,27],[6,4,6,5],[6,6,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,13],[6,14,6,15],[6,16,6,17],[10,18,10,19],[10,20,10,21],[10,22,10,23],[10,24,10,25],[10,26,10,27],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[10,16,10,17],[11,18,11,19],[11,20,11,21],[11,22,11,23],[11,24,11,25],[11,26,11,27],[11,4,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[11,16,11,17],[12,18,12,19],[12,20,12,21],[12,22,12,23],[12,24,12,25],[12,26,12,27],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[12,16,12,17],[13,18,13,19],[13,20,13,21],[13,22,13,23],[13,24,13,25],[13,26,13,27],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[13,16,13,17],[14,18,14,19],[14,20,14,21],[14,22,14,23],[14,24,14,25],[14,26,14,27],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,15],[14,16,14,17],[15,18,15,19],[15,20,15,21],[15,22,15,23],[15,24,15,25],[15,26,15,27],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[15,16,15,17],[23,18,23,19],[23,20,23,21],[23,22,23,23],[23,24,23,25],[23,26,23,27],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[23,16,23,17],[7,18,7,19],[7,20,7,21],[7,22,7,23],[7,24,7,25],[7,26,7,27],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[7,12,7,13],[7,14,7,15],[7,16,7,17],[8,18,8,19],[8,20,8,21],[8,22,8,23],[8,24,8,25],[8,26,8,27],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[8,16,8,17],[9,18,9,19],[9,20,9,21],[9,22,9,23],[9,24,9,25],[9,26,9,27],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[9,14,9,15],[9,16,9,17],[25,18,25,19],[25,20,25,21],[25,22,25,23],[25,24,25,25],[25,26,25,27],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[25,16,25,17],[50,16,50,17],[50,18,50,19],[50,20,50,21],[50,22,50,23],[50,24,50,25],[50,26,50,27],[43,31,43,40],[44,31,44,40],[50,1,50,2],[50,4,50,5],[50,6,50,7],[50,8,50,9],[50,10,50,11],[50,28,50,29],[24,18,24,19],[24,20,24,21],[24,22,24,23],[24,24,24,25],[24,26,24,27],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,15],[24,16,24,17],[27,1,27,2],[27,4,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[27,16,27,17],[27,18,27,19],[27,20,27,21],[27,22,27,23],[27,24,27,25],[27,26,27,27],[27,28,27,29],[29,31,29,40],[30,31,30,40],[31,31,31,40],[32,31,32,40],[33,31,33,40],[34,31,34,40],[35,31,35,40],[36,31,36,40],[37,31,37,40],[38,31,38,40],[39,31,39,40],[40,31,40,40],[41,31,41,40],[42,31,42,40],[50,12,50,13],[50,14,50,15],[16,18,16,19],[16,20,16,21],[16,22,16,23],[16,24,16,25],[16,26,16,27],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[16,16,16,17],[17,18,17,19],[17,20,17,21],[17,22,17,23],[17,24,17,25],[17,26,17,27],[17,4,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[17,16,17,17],[18,18,18,19],[18,20,18,21],[18,22,18,23],[18,24,18,25],[18,26,18,27],[18,4,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[18,16,18,17],[19,18,19,19],[19,20,19,21],[19,22,19,23],[19,24,19,25],[19,26,19,27],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[20,18,20,19],[20,20,20,21],[20,22,20,23],[20,24,20,25],[20,26,20,27],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,16,20,17],[21,18,21,19],[21,20,21,21],[21,22,21,23],[21,24,21,25],[21,26,21,27],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[21,12,21,13],[21,14,21,15],[21,16,21,17],[22,18,22,19],[22,20,22,21],[22,22,22,23],[22,24,22,25],[22,26,22,27],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17]]}
[{"$f":"CurrentVersion","v":"v6.02"},null,null,null,"Highlight Color Legend"]
[null,"MITDP PCA Code(s) ","override",null,"Title/Header",null,"Calculated but Editable",null,"Calculated/not editable",null,"Manual Entry"]
[null,"SPEND PLAN"]
[null,"Spend Plan as of:",{"$f":"Reporting_Month","v":"Jul/FY23"}]
[null,{"$f":"\"FY\"&FISCAL_START&\" BASELINE Spend Plan\"","v":"FY23 BASELINE Spend Plan"},null,null,"July",null,"August",null,"September",null,"October",null,"November",null,"December",null,"January",null,"February",null,"March",null,"April",null,"May",null,"June",null,null,null,null,{"$f":"\"FY\"&FISCAL_START+1&\" BASELINE Spend Plan\"","v":"FY24 BASELINE Spend Plan"},null,null,{"$f":"\"20\"&FISCAL_START","v":"2023"},{"$f":"\"20\"&FISCAL_START","v":"2023"},{"$f":"\"20\"&FISCAL_START","v":"2023"},{"$f":"\"20\"&FISCAL_START","v":"2023"},{"$f":"\"20\"&FISCAL_START","v":"2023"},{"$f":"\"20\"&FISCAL_START","v":"2023"},{"$f":"\"20\"&FISCAL_START+1","v":"2024"},{"$f":"\"20\"&FISCAL_START+1","v":"2024"},{"$f":"\"20\"&FISCAL_START+1","v":"2024"},{"$f":"\"20\"&FISCAL_START+1","v":"2024"},{"$f":"\"20\"&FISCAL_START+1","v":"2024"},{"$f":"\"20\"&FISCAL_START+1","v":"2024"}]
[null,"Vendor","Contract ID","Services/Products",{"$f":"E5&\" 20\"&FISCAL_START-1","v":"July 2022"},null,{"$f":"G5&\" 20\"&FISCAL_START-1","v":"August 2022"},null,{"$f":"I5&\" 20\"&FISCAL_START-1","v":"September 2022"},null,{"$f":"K5&\" 20\"&FISCAL_START-1","v":"October 2022"},null,{"$f":"M5&\" 20\"&FISCAL_START-1","v":"November 2022"},null,{"$f":"O5&\" 20\"&FISCAL_START-1","v":"December 2022"},null,{"$f":"Q5&\" 20\"&FISCAL_START","v":"January 2023"},null,{"$f":"S5&\" 20\"&FISCAL_START","v":"February 2023"},null,{"$f":"U5&\" 20\"&FISCAL_START","v":"March 2023"},null,{"$f":"W5&\" 20\"&FISCAL_START","v":"April 2023"},null,{"$f":"Y5&\" 20\"&FISCAL_START","v":"May 2023"},null,{"$f":"AA5&\" 20\"&FISCAL_START","v":"June 2023"},null,"Total",null,null,"Vendor","Contract ID","Services/Products","July","August","September","October","November","December","January","February","March","April","May","June","Total"]
[null,"Vendor 1",{"$f":"IF(ISBLANK('5) Contract Management'!E3),\"\",'5) Contract Management'!E3)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D3),\"\",'5) Contract Management'!D3)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,{"$f":"SUM(E7:AB7)","v":0},null,null,{"$f":"IF(ISBLANK($B7),\"\",$B7)","v":"Vendor 1"},{"$f":"IF(ISBLANK($C7),\"\",$C7)","v":""},{"$f":"IF(ISBLANK($D7),\"\",$D7)","v":""},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"SUM(AI7:AT7)","v":0}]
[null,"Vendor 2",{"$f":"IF(ISBLANK('5) Contract Management'!E4),\"\",'5) Contract Management'!E4)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D4),\"\",'5) Contract Management'!D4)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 2","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,"Vendor 3",{"$f":"IF(ISBLANK('5) Contract Management'!E5),\"\",'5) Contract Management'!E5)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D5),\"\",'5) Contract Management'!D5)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 3","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,"Vendor 4",{"$f":"IF(ISBLANK('5) Contract Management'!E6),\"\",'5) Contract Management'!E6)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D6),\"\",'5) Contract Management'!D6)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 4","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,"Vendor 5",{"$f":"IF(ISBLANK('5) Contract Management'!E7),\"\",'5) Contract Management'!E7)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D7),\"\",'5) Contract Management'!D7)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 5","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,"Vendor 6",{"$f":"IF(ISBLANK('5) Contract Management'!E8),\"\",'5) Contract Management'!E8)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D8),\"\",'5) Contract Management'!D8)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 6","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,"Vendor 7",{"$f":"IF(ISBLANK('5) Contract Management'!E9),\"\",'5) Contract Management'!E9)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D9),\"\",'5) Contract Management'!D9)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 7","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,"Vendor 8",{"$f":"IF(ISBLANK('5) Contract Management'!E10),\"\",'5) Contract Management'!E10)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D10),\"\",'5) Contract Management'!D10)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 8","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,"Vendor 9",{"$f":"IF(ISBLANK('5) Contract Management'!E11),\"\",'5) Contract Management'!E11)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D11),\"\",'5) Contract Management'!D11)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 9","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,"Vendor 10",{"$f":"IF(ISBLANK('5) Contract Management'!E12),\"\",'5) Contract Management'!E12)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D12),\"\",'5) Contract Management'!D12)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 10","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,"Vendor 11",{"$f":"IF(ISBLANK('5) Contract Management'!E13),\"\",'5) Contract Management'!E13)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D13),\"\",'5) Contract Management'!D13)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 11","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,{"$f":"IF(ISBLANK('5) Contract Management'!C14),\"\",'5) Contract Management'!C14)","v":"Vendor 12"},{"$f":"IF(ISBLANK('5) Contract Management'!E14),\"\",'5) Contract Management'!E14)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D14),\"\",'5) Contract Management'!D14)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 12","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,{"$f":"IF(ISBLANK('5) Contract Management'!C15),\"\",'5) Contract Management'!C15)","v":"Vendor 13"},{"$f":"IF(ISBLANK('5) Contract Management'!E15),\"\",'5) Contract Management'!E15)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D15),\"\",'5) Contract Management'!D15)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 13","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,{"$f":"IF(ISBLANK('5) Contract Management'!C16),\"\",'5) Contract Management'!C16)","v":"Vendor 14"},{"$f":"IF(ISBLANK('5) Contract Management'!E16),\"\",'5) Contract Management'!E16)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D16),\"\",'5) Contract Management'!D16)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 14","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,{"$f":"IF(ISBLANK('5) Contract Management'!C17),\"\",'5) Contract Management'!C17)","v":"Vendor 15"},{"$f":"IF(ISBLANK('5) Contract Management'!E17),\"\",'5) Contract Management'!E17)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D17),\"\",'5) Contract Management'!D17)","v":""},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 15","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,{"$f":"IF(ISBLANK('5) Contract Management'!C18),\"\",'5) Contract Management'!C18)","v":"Vendor 16"},{"$f":"IF(ISBLANK('5) Contract Management'!E18),\"\",'5) Contract Management'!E18)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D18),\"\",'5) Contract Management'!D18)","v":"Security (ATO) Costs"},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"Vendor 16","","Security (ATO) Costs",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,null,null,"Project Costs Subtotal ",{"$f":"SUM(E7:E22)","v":0},null,{"$f":"SUM(G7:G22)","v":0},null,{"$f":"SUM(I7:I22)","v":0},null,{"$f":"SUM(K7:K22)","v":0},null,{"$f":"SUM(M7:M22)","v":0},null,{"$f":"SUM(O7:O22)","v":0},null,{"$f":"SUM(Q7:Q22)","v":0},null,{"$f":"SUM(S7:S22)","v":0},null,{"$f":"SUM(U7:U22)","v":0},null,{"$f":"SUM(W7:W22)","v":0},null,{"$f":"SUM(Y7:Y22)","v":0},null,{"$f":"SUM(AA7:AA22)","v":0},null,0,null,null,null,null,"Project Costs Subtotal ",{"$f":"SUM(AI7:AI22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(ISBLANK('5) Contract Management'!C19),\"\",'5) Contract Management'!C19)","v":"Vendor 17"},{"$f":"IF(ISBLANK('5) Contract Management'!E19),\"\",'5) Contract Management'!E19)","v":""},{"$f":"IF(ISBLANK('5) Contract Management'!D19),\"\",'5) Contract Management'!D19)","v":"IV&V"},0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,{"$f":"IF(ISBLANK($B24),\"\",$B24)","v":"Vendor 17"},{"$f":"IF(ISBLANK($C24),\"\",$C24)","v":""},{"$f":"IF(ISBLANK($B24),\"\",$B24)","v":"Vendor 17"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,"DoIT",null,"Oversight costs ",0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0,null,null,"DoIT"," ","Oversight costs ",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0]
[null,"Total",null,null,{"$f":"SUM(E23:E25)","v":0},null,{"$f":"SUM(G23:G25)","v":0},null,{"$f":"SUM(I23:I25)","v":0},null,{"$f":"SUM(K23:K25)","v":0},null,{"$f":"SUM(M23:M25)","v":0},null,{"$f":"SUM(O23:O25)","v":0},null,{"$f":"SUM(Q23:Q25)","v":0},null,{"$f":"SUM(S23:S25)","v":0},null,{"$f":"SUM(U23:U25)","v":0},null,{"$f":"SUM(W23:W25)","v":0},null,{"$f":"SUM(Y23:Y25)","v":0},null,{"$f":"SUM(AA23:AA25)","v":0},null,0,null,null,"Total",null,null,{"$f":"SUM(AI23:AI25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"\"FY\"&FISCAL_START&\" Forecast\"","v":"FY23 Forecast"},null,null,{"$f":"E6","v":"July 2022"},null,{"$f":"G6","v":"August 2022"},null,{"$f":"I6","v":"September 2022"},null,{"$f":"K6","v":"October 2022"},null,{"$f":"M6","v":"November 2022"},null,{"$f":"O6","v":"December 2022"},null,{"$f":"Q6","v":"January 2023"},null,{"$f":"S6","v":"February 2023"},null,{"$f":"U6","v":"March 2023"},null,{"$f":"W6","v":"April 2023"},null,{"$f":"Y6","v":"May 2023"},null,{"$f":"AA6","v":"June 2023"},null,{"$f":"AC6","v":"Total"}]
[null,"Vendor","Contract ID","Services/Products","Incurred","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced",null,"SPEND PLAN CHANGE JUSTIFICATION(S)"]
[null,{"$f":"IF(ISBLANK(B7),\"\",B7)","v":"Vendor 1"},"","",0,null,{"$f":"IF(ISBLANK(G7),\"\",G7)","v":0},null,{"$f":"IF(ISBLANK(I7),\"\",I7)","v":0},null,{"$f":"IF(ISBLANK(K7),\"\",K7)","v":0},null,{"$f":"IF(ISBLANK(M7),\"\",M7)","v":0},null,{"$f":"IF(ISBLANK(O7),\"\",O7)","v":0},null,{"$f":"IF(ISBLANK(Q7),\"\",Q7)","v":0},null,{"$f":"IF(ISBLANK(S7),\"\",S7)","v":0},null,{"$f":"IF(ISBLANK(U7),\"\",U7)","v":0},null,{"$f":"IF(ISBLANK(W7),\"\",W7)","v":0},null,{"$f":"IF(ISBLANK(Y7),\"\",Y7)","v":0},null,{"$f":"IF(ISBLANK(AA7),\"\",AA7)","v":0},null,{"$f":"SUMPRODUCT($E30:$AB30,--(MOD(COLUMN($E30:$AB30),2)=1))","v":0},{"$f":"SUMPRODUCT($E30:$AB30,--(MOD(COLUMN($E30:$AB30),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B8),\"\",B8)","v":"Vendor 2"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E31:$AB31,--(MOD(COLUMN($E31:$AB31),2)=1))","v":0},{"$f":"SUMPRODUCT($E31:$AB31,--(MOD(COLUMN($E31:$AB31),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B9),\"\",B9)","v":"Vendor 3"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E32:$AB32,--(MOD(COLUMN($E32:$AB32),2)=1))","v":0},{"$f":"SUMPRODUCT($E32:$AB32,--(MOD(COLUMN($E32:$AB32),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B10),\"\",B10)","v":"Vendor 4"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E33:$AB33,--(MOD(COLUMN($E33:$AB33),2)=1))","v":0},{"$f":"SUMPRODUCT($E33:$AB33,--(MOD(COLUMN($E33:$AB33),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B11),\"\",B11)","v":"Vendor 5"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E34:$AB34,--(MOD(COLUMN($E34:$AB34),2)=1))","v":0},{"$f":"SUMPRODUCT($E34:$AB34,--(MOD(COLUMN($E34:$AB34),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B12),\"\",B12)","v":"Vendor 6"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E35:$AB35,--(MOD(COLUMN($E35:$AB35),2)=1))","v":0},{"$f":"SUMPRODUCT($E35:$AB35,--(MOD(COLUMN($E35:$AB35),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B13),\"\",B13)","v":"Vendor 7"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E36:$AB36,--(MOD(COLUMN($E36:$AB36),2)=1))","v":0},{"$f":"SUMPRODUCT($E36:$AB36,--(MOD(COLUMN($E36:$AB36),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B14),\"\",B14)","v":"Vendor 8"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E37:$AB37,--(MOD(COLUMN($E37:$AB37),2)=1))","v":0},{"$f":"SUMPRODUCT($E37:$AB37,--(MOD(COLUMN($E37:$AB37),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B15),\"\",B15)","v":"Vendor 9"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E38:$AB38,--(MOD(COLUMN($E38:$AB38),2)=1))","v":0},{"$f":"SUMPRODUCT($E38:$AB38,--(MOD(COLUMN($E38:$AB38),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B16),\"\",B16)","v":"Vendor 10"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E39:$AB39,--(MOD(COLUMN($E39:$AB39),2)=1))","v":0},{"$f":"SUMPRODUCT($E39:$AB39,--(MOD(COLUMN($E39:$AB39),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B17),\"\",B17)","v":"Vendor 11"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0.0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E40:$AB40,--(MOD(COLUMN($E40:$AB40),2)=1))","v":0},{"$f":"SUMPRODUCT($E40:$AB40,--(MOD(COLUMN($E40:$AB40),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B18),\"\",B18)","v":"Vendor 12"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"IF(ISBLANK(S18),\"\",S18)","v":0},null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E41:$AB41,--(MOD(COLUMN($E41:$AB41),2)=1))","v":0},{"$f":"SUMPRODUCT($E41:$AB41,--(MOD(COLUMN($E41:$AB41),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B19),\"\",B19)","v":"Vendor 13"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E42:$AB42,--(MOD(COLUMN($E42:$AB42),2)=1))","v":0},{"$f":"SUMPRODUCT($E42:$AB42,--(MOD(COLUMN($E42:$AB42),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B20),\"\",B20)","v":"Vendor 14"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E43:$AB43,--(MOD(COLUMN($E43:$AB43),2)=1))","v":0},{"$f":"SUMPRODUCT($E43:$AB43,--(MOD(COLUMN($E43:$AB43),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B21),\"\",B21)","v":"Vendor 15"},"","",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E44:$AB44,--(MOD(COLUMN($E44:$AB44),2)=1))","v":0},{"$f":"SUMPRODUCT($E44:$AB44,--(MOD(COLUMN($E44:$AB44),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B22),\"\",B22)","v":"Vendor 16"},"","Security (ATO) Costs",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E45:$AB45,--(MOD(COLUMN($E45:$AB45),2)=1))","v":0},{"$f":"SUMPRODUCT($E45:$AB45,--(MOD(COLUMN($E45:$AB45),2)=0))","v":0}]
[null,null,null,"Project Costs Subtotal ",{"$f":"SUM(E30:E45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E46:$AB46,--(MOD(COLUMN($E46:$AB46),2)=1))","v":0},{"$f":"SUMPRODUCT($E46:$AB46,--(MOD(COLUMN($E46:$AB46),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B24),\"\",B24)","v":"Vendor 17"},"","IV&V",0,null,{"$f":"IF(ISBLANK(G24),\"\",G24)","v":0},null,{"$f":"IF(ISBLANK(I24),\"\",I24)","v":0},null,{"$f":"IF(ISBLANK(K24),\"\",K24)","v":0},null,{"$f":"IF(ISBLANK(M24),\"\",M24)","v":0},null,{"$f":"IF(ISBLANK(O24),\"\",O24)","v":0},null,{"$f":"IF(ISBLANK(Q24),\"\",Q24)","v":0},null,{"$f":"IF(ISBLANK(S24),\"\",S24)","v":0},null,{"$f":"IF(ISBLANK(U24),\"\",U24)","v":0},null,{"$f":"IF(ISBLANK(W24),\"\",W24)","v":0},null,{"$f":"IF(ISBLANK(Y24),\"\",Y24)","v":0},null,{"$f":"IF(ISBLANK(AA24),\"\",AA24)","v":0},null,{"$f":"SUMPRODUCT($E47:$AB47,--(MOD(COLUMN($E47:$AB47),2)=1))","v":0},{"$f":"SUMPRODUCT($E47:$AB47,--(MOD(COLUMN($E47:$AB47),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK(B25),\"\",B25)","v":"DoIT"}," ","Oversight costs ",{"$f":"IF(ISBLANK(E25),\"\",E25)","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUMPRODUCT($E48:$AB48,--(MOD(COLUMN($E48:$AB48),2)=1))","v":0},{"$f":"SUMPRODUCT($E48:$AB48,--(MOD(COLUMN($E48:$AB48),2)=0))","v":0}]
[null,"Total",null,null,{"$f":"SUM(E46:E48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E49:$AB49,--(MOD(COLUMN($E49:$AB49),2)=1))","v":0},{"$f":"SUMPRODUCT($E49:$AB49,--(MOD(COLUMN($E49:$AB49),2)=0))","v":0}]
[]
[null,{"$f":"\"FY\"&FISCAL_START&\" Variance\"","v":"FY23 Variance"},null,null,{"$f":"E6","v":"July 2022"},null,{"$f":"G6","v":"August 2022"},null,{"$f":"I6","v":"September 2022"},null,{"$f":"K6","v":"October 2022"},null,{"$f":"M6","v":"November 2022"},null,{"$f":"O6","v":"December 2022"},null,{"$f":"Q6","v":"January 2023"},null,{"$f":"S6","v":"February 2023"},null,{"$f":"U6","v":"March 2023"},null,{"$f":"W6","v":"April 2023"},null,{"$f":"Y6","v":"May 2023"},null,{"$f":"AA6","v":"June 2023"},null,{"$f":"AC6","v":"Total"}]
[null,"Vendor","Contract ID","Services/Products",{"$f":"E29","v":"Incurred"},"Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced","Forecast","Invoiced"]
[null,{"$f":"IF(ISBLANK($B30),\"\",$B30)","v":"Vendor 1"},{"$f":"IF(ISBLANK($C30),\"\",$C30)","v":""},{"$f":"IF(ISBLANK($D30),\"\",$D30)","v":""},{"$f":"E30-E7","v":0},{"$f":"F30-E30","v":0},{"$f":"G30-G7","v":0},{"$f":"H30-G30","v":0},{"$f":"I30-I7","v":0},{"$f":"J30-I30","v":0},{"$f":"K30-K7","v":0},{"$f":"L30-K30","v":0},{"$f":"M30-M7","v":0},{"$f":"N30-M30","v":0},{"$f":"O30-O7","v":0},{"$f":"P30-O30","v":0},{"$f":"Q30-Q7","v":0},{"$f":"R30-Q30","v":0},{"$f":"S30-S7","v":0},{"$f":"T30-S30","v":0},{"$f":"U30-U7","v":0},{"$f":"V30-U30","v":0},{"$f":"W30-W7","v":0},{"$f":"X30-W30","v":0},{"$f":"Y30-Y7","v":0},{"$f":"Z30-Y30","v":0},{"$f":"AA30-AA7","v":0},{"$f":"AB30-AA30","v":0},{"$f":"SUMPRODUCT($E53:$AB53,--(MOD(COLUMN($E53:$AB53),2)=1))","v":0},{"$f":"SUMPRODUCT($E53:$AB53,--(MOD(COLUMN($E53:$AB53),2)=0))","v":0}]
[null,"Vendor 2","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E54:$AB54,--(MOD(COLUMN($E54:$AB54),2)=1))","v":0},{"$f":"SUMPRODUCT($E54:$AB54,--(MOD(COLUMN($E54:$AB54),2)=0))","v":0}]
[null,"Vendor 3","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E55:$AB55,--(MOD(COLUMN($E55:$AB55),2)=1))","v":0},{"$f":"SUMPRODUCT($E55:$AB55,--(MOD(COLUMN($E55:$AB55),2)=0))","v":0}]
[null,"Vendor 4","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E56:$AB56,--(MOD(COLUMN($E56:$AB56),2)=1))","v":0},{"$f":"SUMPRODUCT($E56:$AB56,--(MOD(COLUMN($E56:$AB56),2)=0))","v":0}]
[null,"Vendor 5","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E57:$AB57,--(MOD(COLUMN($E57:$AB57),2)=1))","v":0},{"$f":"SUMPRODUCT($E57:$AB57,--(MOD(COLUMN($E57:$AB57),2)=0))","v":0}]
[null,"Vendor 6","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E58:$AB58,--(MOD(COLUMN($E58:$AB58),2)=1))","v":0},{"$f":"SUMPRODUCT($E58:$AB58,--(MOD(COLUMN($E58:$AB58),2)=0))","v":0}]
[null,"Vendor 7","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E59:$AB59,--(MOD(COLUMN($E59:$AB59),2)=1))","v":0},{"$f":"SUMPRODUCT($E59:$AB59,--(MOD(COLUMN($E59:$AB59),2)=0))","v":0}]
[null,"Vendor 8","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E60:$AB60,--(MOD(COLUMN($E60:$AB60),2)=1))","v":0},{"$f":"SUMPRODUCT($E60:$AB60,--(MOD(COLUMN($E60:$AB60),2)=0))","v":0}]
[null,"Vendor 9","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E61:$AB61,--(MOD(COLUMN($E61:$AB61),2)=1))","v":0},{"$f":"SUMPRODUCT($E61:$AB61,--(MOD(COLUMN($E61:$AB61),2)=0))","v":0}]
[null,"Vendor 10","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E62:$AB62,--(MOD(COLUMN($E62:$AB62),2)=1))","v":0},{"$f":"SUMPRODUCT($E62:$AB62,--(MOD(COLUMN($E62:$AB62),2)=0))","v":0}]
[null,"Vendor 11","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E63:$AB63,--(MOD(COLUMN($E63:$AB63),2)=1))","v":0},{"$f":"SUMPRODUCT($E63:$AB63,--(MOD(COLUMN($E63:$AB63),2)=0))","v":0}]
[null,"Vendor 12","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E64:$AB64,--(MOD(COLUMN($E64:$AB64),2)=1))","v":0},{"$f":"SUMPRODUCT($E64:$AB64,--(MOD(COLUMN($E64:$AB64),2)=0))","v":0}]
[null,"Vendor 13","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E65:$AB65,--(MOD(COLUMN($E65:$AB65),2)=1))","v":0},{"$f":"SUMPRODUCT($E65:$AB65,--(MOD(COLUMN($E65:$AB65),2)=0))","v":0}]
[null,"Vendor 14","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E66:$AB66,--(MOD(COLUMN($E66:$AB66),2)=1))","v":0},{"$f":"SUMPRODUCT($E66:$AB66,--(MOD(COLUMN($E66:$AB66),2)=0))","v":0}]
[null,"Vendor 15","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E67:$AB67,--(MOD(COLUMN($E67:$AB67),2)=1))","v":0},{"$f":"SUMPRODUCT($E67:$AB67,--(MOD(COLUMN($E67:$AB67),2)=0))","v":0}]
[null,"Vendor 16","","Security (ATO) Costs",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E68:$AB68,--(MOD(COLUMN($E68:$AB68),2)=1))","v":0},{"$f":"SUMPRODUCT($E68:$AB68,--(MOD(COLUMN($E68:$AB68),2)=0))","v":0}]
[null,null,null,"Project Costs Subtotal ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E69:$AB69,--(MOD(COLUMN($E69:$AB69),2)=1))","v":0},{"$f":"SUMPRODUCT($E69:$AB69,--(MOD(COLUMN($E69:$AB69),2)=0))","v":0}]
[null,{"$f":"IF(ISBLANK($B47),\"\",$B47)","v":"Vendor 17"},{"$f":"IF(ISBLANK($C47),\"\",$C47)","v":""},{"$f":"IF(ISBLANK($D47),\"\",$D47)","v":"IV&V"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E70:$AB70,--(MOD(COLUMN($E70:$AB70),2)=1))","v":0},{"$f":"SUMPRODUCT($E70:$AB70,--(MOD(COLUMN($E70:$AB70),2)=0))","v":0}]
[null,"DoIT"," ","Oversight costs ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E71:$AB71,--(MOD(COLUMN($E71:$AB71),2)=1))","v":0},{"$f":"SUMPRODUCT($E71:$AB71,--(MOD(COLUMN($E71:$AB71),2)=0))","v":0}]
[null,"Total",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT($E72:$AB72,--(MOD(COLUMN($E72:$AB72),2)=1))","v":0},{"$f":"SUMPRODUCT($E72:$AB72,--(MOD(COLUMN($E72:$AB72),2)=0))","v":0}]

{"sheet":"4) Milestones","index":3,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,16]]}
[{"$f":"CurrentVersion","v":"v6.02"}]
[null,"Project Milestones"]
[]
[null,null,"Milestones and Feature Completion","Baseline/Plan","Actual","Status"]
[null,null,"Project Initiation","[Month/FY]","[Month/FY]"]
[null,null,"PPR","[Month/FY]","[Month/FY]"]
[null,null,"PIR","[Month/FY]","[Month/FY]"]
[null,null,"Requirements Gathering","[Month/FY]","[Month/FY]"]
[null,null,"Solicitation Release","[Month/FY]","[Month/FY]"]
[null,null,"Solicitation Award","[Month/FY]","[Month/FY]"]
[null,null,"Notice to Proceed","[Month/FY]","[Month/FY]"]
[null,null,"Design Develop Implement","[Month/FY]","[Month/FY]"]
[null,null,"User Acceptance Testing","[Month/FY]","[Month/FY]"]
[null,null,"Operational Readiness Testing ","[Month/FY]","[Month/FY]"]
[null,null,"Production Go Live","[Month/FY]","[Month/FY]"]
[null,null,"O&M Start","[Month/FY]","[Month/FY]"]
[null,null,"Closeout","[Month/FY]","[Month/FY]"]

{"sheet":"5) Contract Management","index":4,"n_rows":22,"n_cols":26,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,1,12],[0,13,1,13],[0,24,1,24],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6]]}
["No","Project/Subproject","Vendor/Service Provider","Service(s)/Product(s)","Contract ID","Contract Description/WO Name","Vehicle Type","Contract Type","Solicitation ID","Notes","Contract Term","Contract Start Date","Contract End Date","NTE/Total Contract Amount","Year 1 Amount","Year 2 Amount","Year 3 Amount","Year 4 Amount","Year 5 Amount","Year 6 Amount","Year 7 Amount","Year 8 Amount","Year 9 Amount","Year 10 Amount","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[1.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 1",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"SUM(O3:X3)","v":0},{"$f":"IF(Y3<>N3,\"Error - NTE amount does not match Year Totals\",\"\")","v":""}]
[2.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 2",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[3.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 3",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[4.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 4",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[5.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 5",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[6.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 6",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[7.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 7",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[8.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 8",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[9.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 9",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[10.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 10",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[11.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 11",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[12.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 12",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[13.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 13",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[14.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 14",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[15.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 15",null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[16.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 16","Security (ATO) Costs",null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[17.0,{"$f":"Project_Name","v":"[Project Name]"},"Vendor 17","IV&V",null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,""]
[null,{"$f":"IF(ISBLANK(C20),\"\",Project_Name)","v":""}]
[null,{"$f":"IF(ISBLANK(C21),\"\",Project_Name)","v":""}]
[null,{"$f":"IF(ISBLANK(C22),\"\",Project_Name)","v":""}]

{"sheet":"RiskStrategyDefinitions","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CurrentVersion","v":"v6.02"}]
[null,"RISK STRATEGY DEFINITIONS"]
[]
[null,null,"Strategies for Risks\n"]
[null,null,"By way of example, imagine that you're planning to go on a vacation in Asia.  Here are some of the common risks that might take place and your possible responses to these.  There are four risk response strategies for negative risks:"]
[null,null,"Avoidance - avoiding a risk means reducing the probability of it happening to zero. Usually, this includes making some adjustments to the original project plan. For example, let's say that you're warned by your travel agent about an increased risk of malaria in Cambodia, so you decide not to go there at all and visit Vietnam instead."]
[null,null,"Transferring - transferring a risk means shifting the responsibility for dealing with risk event consequences to someone else. For example, in case you're worried that your luggage will be lost during the flight, you can purchase travel insurance, so that in the event of the luggage actually being lost, the risk will be transferred to the insurance company, from whom you would receive compensation."]
[null,null,"Mitigation - mitigating a risk means reducing the impact of a risk event on your project. For example, you might be planning to travel to the airport by train, but will also research alternative options in case there are planned rail works on the day of your travel."]
[null,null,"Acceptance - accepting a risk means simply dealing with any of its consequences. For example, you know that your boss might not approve your vacation; however, you decide to purchase non-refundable plane tickets anyway because the price is too good. While this is the riskiest strategy out of four, it might be a wise choice if the probability of a risk is very low and the costs of mitigation are high."]

{"sheet":"DeliverablesTracking","index":6,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,0,1,6],[25,0,25,2]]}
[{"$f":"CurrentVersion","v":"v6.02"}]
["DELIVERABLES TRACKING"]
[null,"Planning Deliverables",null,"Deliverable Uploaded","Plan to Create By","No Plan to Create","OPM Assessment/Comments"]
[null,null,"Project Charter"]
[null,null,"Project Management Plan"]
[null,null,"Solutions Roadmap"]
[null,null,"Responsibility Assignment Matrix"]
[null,null,"Non-Functional Requirements"]
[null,null,"Functional Requirements"]
[null,null,"Agile Maturity Matrix"]
[null,null,"Agile PM Tool Selected"]
[null,"Implementation Deliverables"]
[null,null,"Solutions Roadmap"]
[null,null,"System Design Document"]
[null,null,"Data Conversion Plan"]
[null,null,"Interface Control Document"]
[null,null,"System Security Document"]
[null,null,"Agile Implementation Plan"]
[null,null,"System Administration Manual"]
[null,null,"Disaster Recovery Plan"]
[null,null,"Disposition Plan"]
[null,null,"MITDP Closeout"]
[]
[]
[]
["This tab is for OPM USE ONLY."]

{"sheet":"OPM Assessment","index":7,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[{"$f":"CurrentVersion","v":"v6.02"}]
[null,"OPM Assessment"]
[null,"This tab is for OPM USE ONLY."]
[]
[null,null,null,"Project PM Reported","OPM Assessment","Justification"]
[null,null,"Overall Status",{"$f":"Rating_Overall","v":"ERROR"},"Select One  >",null,{"$f":"IF(OPM_Rating_Overall=0,0,IF(AND(Rating_Overall<>OPM_Rating_Overall,ISBLANK(F6)),1,0))","v":1}]
[null,null,"Scope",{"$f":"Rating_Scope","v":"ERROR"},"Select One  >",null,{"$f":"IF(OPM_Rating_Scope=0,0,IF(AND(Rating_Scope<>OPM_Rating_Scope,ISBLANK(F7)),1,0))","v":1}]
[null,null,"Schedule",{"$f":"Rating_Schedule","v":"ERROR"},"Select One  >",null,{"$f":"IF(OPM_Rating_Schedule=0,0,IF(AND(Rating_Schedule<>OPM_Rating_Schedule,ISBLANK(F8)),1,0))","v":1}]
[null,null,"Cost",{"$f":"Rating_Costs","v":"ERROR"},"Select One  >",null,{"$f":"IF(OPM_Rating_Costs=0,0,IF(AND(Rating_Costs<>OPM_Rating_Costs,ISBLANK(F9)),1,0))","v":1}]
[null,null,"Risk",{"$f":"Rating_Risks","v":"ERROR"},"Select One  >",null,{"$f":"IF(OPM_Rating_Risks=0,0,IF(AND(Rating_Risks<>OPM_Rating_Risks,ISBLANK(F10)),1,0))","v":1}]
[null,null,"Quality",{"$f":"Rating_Quality","v":"ERROR"},"Select One  >",null,{"$f":"IF(OPM_Rating_Quality=0,0,IF(AND(Rating_Quality<>OPM_Rating_Quality,ISBLANK(F11)),1,0))","v":1}]
[null,null,"Resources",{"$f":"Rating_Resources","v":"ERROR"},"Select One  >",null,{"$f":"IF(OPM_Rating_Resources=0,0,IF(AND(Rating_Resources<>OPM_Rating_Resources,ISBLANK(F12)),1,0))","v":1}]

{"sheet":"LOOKUPS","index":8,"n_rows":78,"n_cols":28,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[1.0,null,null,"SET FISCAL YEAR",23.0,null,"Reporting_Period",null,null,"Risk Strategies","SpendPlan Choices","ContractYearType","VehicleType","ContractType","Current Version",{"$f":"\"v\"&LOOKUP(2,1/(P5:P26<>\"\"),P5:P26)","v":"v6.02"}]
["Select One  >",0.0,null,null,null,null,"Jun/FY22",null,null,"Avoid","Forecast","Base","RFP","Firm Fixed Price",null,null,null,null,null,null,"ID","CHANGE","Status",null,"Highlight Color Legend"]
[" - Yes",1.0,null,null,null,null,null,null,null,"Transfer","Incurred","Option","TORFP","T&M",null,null,null,null,null,null,1.0,"Submitted BA","Complete",null,"Title/Header","Calculated but editable","Calculated/not editable","Manual Entry"]
[" - No, but we are in the process of creating, or seeking approval, for one.",2.0,null,null,null,null,"Jul/FY23",null,null,"Mitigate",null,"NA","PORFP/Purchase Order","Other","Change Log","ID","Name","Changes","Date",null,2.0,"Submitted Invoices","Postpone for now"]
[" - No, we have no plan or are unable to create one.",3.0,null,null,null,null,"Aug/FY23",null,null,"Accept",null,null,"Work Order",null,null,3.0,"JoeV","Revised template, supersedes V2.x",null,null,3.0,"PCA - does it have one?","Complete"]
[2.0,null,null,null,null,null,"Sep/FY23",null,null,null,null,null,"MOU",null,null,3.1,"JoeV","Fixed some spelling errors.",null,null,4.0,"Procurements Tab (ashley has draft) - \"Contract Management\"","Complete"]
["Select One  >",0.0,null,null,null,null,"Oct/FY23",null,null,null,null,null,"Other",null,null,3.2,"JoeV","Fixed missing FY formulas on Spend Plan tab B34 and B49\nAdded Start/End date columns to Milestones table on Milestones tab\nAdded RiskStrategy lookup for HealthAssessment tab H17:H23\nHid OPM Assessment and Deliverables tab as these are now tracked in Workbooks.",null,null,5.0,"Encumbrances on funding","Postpone for now"]
[" - Yes",1.0,null,null,null,null,"Nov/FY23",null,null,null,null,null,null,null,null,3.3,"JoeV","Added VBA to lock/unlock all sheets and workbook.  Changed Actuals table on Spend Plan tab to estimate oversight actuals for the year based on baseline plan.  ","2020-09-02",null,6.0,"On reporting month dropdown change pop up message saying \"Please review questionnaire responses…\"","Complete"]
[" - No, but we are in the process of creating, or seeking approval, for one.",2.0,null,null,null,null,"Dec/FY23",null,null,null,null,null,null,null,null,3.4,"JoeV","Automated version control number.","2020-09-26",null,7.0,"Dropdowns to indicate actuals vs forecast","Complete"]
[" - No, we have no plan or are unable to create one.",3.0,null,null,null,null,"Jan/FY23",null,null,null,null,null,null,null,null,4.0,"JoeV","Re-deployed with OPM Assessment visible.  Fixed row height issue in \"Successes During the Reporting Period\" row on HealthAssessment tab.  Added VBA to adjust row height with buttons.  Added hover-over fields descriptions for all sections on HealthAssessment tab.","2020-09-30",null,8.0,"Throw error if PCA is blank","Complete"]
[3.0,null,null,null,null,null,"Feb/FY23",null,null,null,null,null,null,null,null,"5.0beta","JoeV","• Modified \"EvaluationCriteria\" for Resources to specify key personnel/critical (directly affecting critical path activities) vacancies.\n• Modified \"1)Questionnaire\" #15 question to align with updated resource evaluation criteria.\n• Added R/Y/G status for each project area on \"1) Questionnaire\" tab.\n• Unhid \"DeliverablesTracking\" tab.\n• **Link project expenditures and variance from the Spend Plan section to this section\n• Modified \"4) Milestones\" tab to align with workbook.  Specifically, changed \"Baseline/Plan Start\" to \"Baseline/Plan\", \"Actual Start\" to \"Actual\" and removed \"Baseline/Plan End\" and \"Actual End\".\n• Modified \"2) HealthAssessment\" Milestones section to align with milestones concept vs schedule concept.  Specifically renamed xxx to \"Baseline/Plan\" and xxx to \"Actual\".\n• Removed all Oversight calculations on \"3) Spend Plan) tab.","2021-05-12",null,9.0,"Convert to Google Sheets","Postpone for now"]
["Select One  >",0.0,null,null,null,null,"Mar/FY23",null,null,null,null,null,null,null,null,"5.1beta","JoeV","Increased Spend Plan line items from 10 to 15 to match proposed Workbook Spend Plan tab.","2021-07-07",null,10.0,"Add submit button to google sheet","Postpone for now"]
[" - Yes",1.0,null,null,null,null,"Apr/FY23",null,null,null,null,null,null,null,null,"5.2beta","JoeV","Changed password. Updated Spend Plan tab to match revised MITDP Workbook Spend Plan.  Updated import script to account for cell location/range updates.","2021-07-27",null,11.0,"Incurred/Invoiced columns","Complete"]
[" - No",2.0,null,null,null,null,"May/FY23",null,null,null,null,null,null,null,null,"5.3beta","JoeV","Created second script to only import tabs 2 and 4.","2021-07-28",null,12.0,"Add conditional formatting (red for overbudget, green for under)","Complete"]
[4.0,null,null,null,null,null,"Jun/FY23",null,null,null,null,null,null,null,null,5.0,"JoeV","Production release","2021-07-29",null,13.0]
["Select One  >",0.0,null,null,null,null,null,null,null,null,null,null,null,null,null,6.0,"JoeV","2022 edition\n• Updated Fiscal Year to 2023\n• Moved the \"Reporting Month\" dropdown to the \"1) Questionnaire\" tab and added a script to pop up a message to check answers to quetions if the month is changed\n• Added question regarding \"Submitted Budget Amendment\" to the \"1) Questionnaire\" tab\n• Updated list of options for reporting month\n• Updated \"3) SpendPlan\" tab removing the \"CURRENT Spend Plan\" section and renaming the \"Actuals\" section \"Forcast\" for simplification\n• Updated color scheme for easy identification of current template usage\n• Added PCA code to the \"3) SpendPlan\" tab field with error if saving and PCA code is blank\n• Added \"5) Contract Management\" tab - this tab now controls the spend plan line items\n• Updated \"3) Spend Plan\" \"Forecast\" table adding columns for \"Forecast/Incurred\" and \"Invoiced\" and appropriate totals\n• Added conditional formatting for totals fields in the \"3) Spend Plan\" tab Forecast table and Variance table (red for overbudget and green for underbudget)","2022-07-31",null,14.0]
[" - Yes",1.0,null,null,null,null,"Jul/FY24",null,null,null,null,null,null,null,null,6.01,"JoeV","Fixed spend plan column header bug and reduced font size of text under the monthly drop down on Questionnaire tab.","2022-08-04",null,15.0]
[" - No",2.0,null,null,null,null,"Aug/FY24",null,null,null,null,null,null,null,null,6.02,"JoeV","Fixed Spend Plan summation columns bugs.","2022-08-04"]
[5.0,null,null,null,null,null,"Sep/FY24"]
["Select One  >",0.0,null,null,null,null,"Oct/FY24"]
[" - Yes",1.0,null,null,null,null,"Nov/FY24"]
[" - No, but we are in the process of creating, or seeking approval, for one.",2.0,null,null,null,null,"Dec/FY24"]
[" - No, we have no plan or are unable to create one.",3.0,null,null,null,null,"Jan/FY24"]
[6.0,null,null,null,null,null,"Feb/FY24"]
["Select One  >",0.0,null,null,null,null,"Mar/FY24"]
[" - They are being completed as scheduled or are estimated to be completed on time.",1.0,null,null,null,null,"Apr/FY24"]
[" - They are behind schedule, but the project is seeking approval to rebaseline the schedule based on a recovery plan.",2.0,null,null,null,null,"May/FY24"]
[" - They are behind schedule with no plan to seek approval to rebaseline, no recovery plan, or there is no ability to recover.",3.0,null,null,null,null,"Jun/FY24"]
[7.0]
["Select One  >",0.0,null,null,null,null,"Jul/FY25"]
[" - Yes",1.0,null,null,null,null,"Aug/FY25"]
[" - No, but we are in the process of creating, or seeking approval, for one.",2.0,null,null,null,null,"Sep/FY25"]
[" - No, we have no plan, or are unable, to create one.",3.0,null,null,null,null,"Oct/FY25"]
[8.0,null,null,null,null,null,"Nov/FY25"]
["Select One  >",0.0,null,null,null,null,"Dec/FY25"]
[" - Yes OR this project does not use MITDP General Funds.",1.0,null,null,null,null,"Jan/FY25"]
[" - No, but we are in the process of creating, or seeking approval, for one.",2.0,null,null,null,null,"Feb/FY25"]
[" - No, we have no plan, or are unable, to create one.",3.0,null,null,null,null,"Mar/FY25"]
[9.0,null,null,null,null,null,"Apr/FY25"]
["Select One  >",0.0,null,null,null,null,"May/FY25"]
[" - Yes",1.0,null,null,null,null,"Jun/FY25"]
[" - No, but a plan is in place to correct spending or submit an Over the Target request",2.0]
[" - No, we do not plan, or are unable, to correct spending or submit an Over the Target request",3.0]
[10.0]
["Select One  >",0.0]
[" - Yes",1.0]
[" - No, but a plan is in place to correct spending or submit a Budget Amendment for available funding or a Deficiency Spending Request to obtain funding.",2.0]
[" - No, we do not plan, or are unable, to correct spending or submit a Budget Amendment for available funding or a Deficiency Spending Request to obtain funding.",3.0]
[11.0]
["Select One  >",0.0]
[" - Yes",1.0]
[" - No, but we are in the process of doing so.",2.0]
[" - No, we have no plan, or are unable, to do so.",3.0]
[12.0]
["Select One  >",0.0]
[" - Yes",1.0]
[" - No, but we are in the process of creating, or seeking approval, for one.",2.0]
[" - No, we have no plan, or are unable, to create one.",3.0]
[13.0]
["Select One  >",0.0]
[" - Yes",1.0]
[" - No, but we are in the process of doing so.",2.0]
[" - No, we have no plan, or are unable, to do so.",3.0]
[14.0]
["Select One  >",0.0]
[" - Yes",1.0]
[" - No, but we are in the process of creating, or seeking approval, for one.",2.0]
[" - No, we have no plan, or are unable, to create one.",3.0]
[15.0]
["Select One  >",0.0]
[" - Yes",1.0]
[" - No, but we have a plan in place to remedy the non-compliance.",2.0]
[" - No, we have no plan, or are unable, to remedy the non-compliance.",3.0]
[16.0]
["Select One  >",0.0]
[" - Yes",1.0]
[" - No, but we are working to fill or backfill vacant key personnel/critical role(s).",2.0]
[" - No, we have no plan, or are unable, to fill or backfill vacant key personnel/critical role(s).",3.0]

{"sheet":"EvaluationCriteria","index":9,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Health Status","Green\n(Controlled)","Yellow\n(Caution)","Red\n(Critical)"]
["Scope","The project has a well documented and approved project scope [such that it can be leveraged in the RFP(s)] that will meet the intentions of the project charter \n- AND - \nThe project has an actively managed backlog/list of features/specification/requirements to be developed/delivered in accordance with DoIT's SDLC principles, and in keeping with agile methods, tools, and techniques.","The project is in the process of developing, or seeking approval for, a well documented project scope [such that it can be leveraged in the RFP(s)] that will meet the intentions of the project charter \n- OR - \nThe project is assembling a backlog/list of features/specification/requirements to be developed/delivered in accordance with DoIT's SDLC principles, and in keeping with agile methods, tools, and techniques that will be actively managed \n- OR - \nNew scope has been identified that must be added to the original scope in order to deliver a minimally viable product.","The project does not have a well documented/approved project scope [such that it can be leveraged in the RFP(s)] that will meet the intentions of the project charter and has no plans to create one \n- OR - \nThe project has not assembled a backlog/list of features/specification/requirements and has no plans to create one \n- OR- \nThe project will not be developed/delivered in accordance with DoIT's SDLC principles, and in keeping with agile methods, tools, and techniques."]
["Schedule","The project has an approved project schedule which identifies, at a minimum, critical path tasks, milestones and or deliverables.  \n- AND -\nThe critical path tasks, milestones and or deliverables are being completed as scheduled or are estimated to be completed on time.","The project is in the process of developing, or seeking approval for, a project schedule which identifies, at a minimum, critical path tasks, milestones and or deliverables.  \n- OR -\nThe critical path tasks, milestones and or deliverables are behind schedule but the project is seeking approval to rebaseline.","The project does not have an approved project schedule and has no plans to create one.\n- OR -\nThe critical path tasks, milestones and or deliverables are behind schedule with no plan to seek approval to rebaseline.\n- OR -\nThe critical path tasks, milestones and or deliverables are behind schedule and there is no ability to remedy."]
["Costs","The project has an approved budget\n- AND -\nthe estimated cost at completion is less than or equal to budgeted cost at completion \n- AND -\nthe project is trending to complete on or below the approved budget and spend plan\n- AND -\nthe project is recording costs against the project, at least, monthly.","The project is in the process of assembling, or seeking approval for, a project budget\n-OR -\nthe estimated cost at completion is greater than or equal to budgeted cost at completion but a plan is in place to correct spending or submit an Over the Target request \n- OR -\nestimating costs for future sprints are unclear\n- OR -\nthe project is not recording costs against the project, at least, monthly.","The project does not have an approved project budget and has no plans to create one\n-OR -\nthe estimated cost at completion is greater than the budgeted cost at completion and does not plan to submit an Over the Target request \n- OR -\nthe project is not recording costs against the project, at least, monthly and has no plan to do so."]
["Risk / Issues","The project has an approved Risk Management Plan in place that incorporates a Risk Register which 1) identifies risk Impact and Probability AND 2) documents the appropriate risk response strategy(ies) (avoidance, transference, mitigation, acceptance)\n- AND -\nthe project Risk Register is periodically reviewed and updated as appropriate.","The project is in the process of assembling, or seeking approval for, a Risk Management Plan that incorporates a Risk Register which 1) identifies risk Impact and Probability AND 2) documents the appropriate risk response strategy(ies) (avoidance, transference, mitigation, acceptance).","The project does not have an approved Risk Management Plan in place and has no plans to create one."]
["Quality","The project has an approved Quality Management Plan or Quality processes (as defined in the PMBOK) in place;\n- AND -\nthe project is in compliance with its approved Quality Management Plan or Quality processes.","The project is in the process of assembling, or seeking approval for, a Quality Management Plan or Quality processes (as defined in the PMBOK);\n- OR - \nthe project is not in compliance with its approved Quality Management Plan or Quality processes but has a plan in place to remedy.","The project does not have an Quality Management Plan or Quality processes (as defined in the PMBOK) in place and has no plans to create one\n- OR - \nthe project is not in compliance with its approved Quality Management Plan or Quality processes and has no plan in place to remedy."]
["Resources","The project is fully staffed.","Project currently has key personnel/critical role (directly affecting critical path activities) vacancies but project leadership is working to fill/backfill resources","The project currently has key personnel/critical (directly affecting critical path activities) vacancies and does not have a plan to/are unable to fill the vacancies."]
["Health Status","Green\n(Controlled)","Yellow\n(Caution)","Red\n(Critical)"]