{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Project Planner","Sample Rubric","Project Planner Template"],"not_rendered":{"charts":2,"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":"Project Planner","index":0,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,9],[3,1,3,9],[4,1,4,9],[14,2,14,3],[15,2,15,3],[2,1,2,9],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3]]}
[null,"Project Management Tool"]
[]
[null,"Project Planner"]
[null,"Fill In Project To-Dos, People Responsible, Challenges, Dates and Duration in the Unshaded Cells."]
[null,"WARNING: Do Not Change Shaded Cells"]
[]
[null,"Project Start Date:",{"$f":"MIN(G11:G17)","v":"2017-01-01"}]
[null,"Project End Date:",{"$f":"RescaleGannt(MAX($J11:$J16))","v":"2017-05-22"}]
[]
[null,"Phase","Key To-Dos",null,"People/Person Responsible","Anticipated Challeges","Est Start Date","Duration\n(Days)","Effort\n(Hours)","Est End Date"]
[null,"Discovery","Stakeholder Focus Group\nReview of Old System\nResearch Capabilities of Vendor Offerings",null,"Planning Team\nStakeholders, as needed","Prioritizing feature requests from stakeholders","2017-01-01",20,160,{"$f":"$G11+$H11","v":"2017-01-21"}]
[null,"Requirements Definition","Prepare:\n- Roles and Use Cases\n- System Functions\n- Data Entities\n- Data Dictionary\n- List of capacity, security and other Considerations\n- Rubric for evaluating RFPS\n- Final RFP",null,"Planning Team","None","2017-01-22",22,160,"2017-02-13"]
[null,"Evaluate/Develop Solutions","Receive, Review and Evaluate Propsosals\nObtain feedback from IT\nDiscuss preferred solutions\nReview with State Director",null,"Planning Team\nState Director\nIT Resource Staff","None","2017-03-01",21,120,"2017-03-22"]
[null,"Quality Assurance","Prepare testing protocol\nRecruit Alpha and Beta Testers\nConduct performance and usability tests\nAddress issues with vendor and/or staff",null,"QA Team\nAlpha and Beta Testers\nVendor\nIT Resource Staff, if needed","Minor performance/usability issues","2017-04-01",31,320,"2017-05-02"]
[null,"Pre-Launch","Data Conversion\nConfiguration on Hosted Platform\nPrepare Training Materials\nConduct Training",null,"Data System Administrator\nState Staff (Resource)\nVendor\nState Training Staff\nProgram Staff to be Trained","None anticipated","2017-05-01",21,500,"2017-05-22"]
[null,"Post-Rollout Support","Provide Helpdesk style support via phone for critical issues, and email for questions",null,"State Training Staff","None anticipated","2017-06-01","Ongoing","6 hrs/week","ongoing"]

{"sheet":"Sample Rubric","index":1,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[22,2,22,4],[22,6,22,7],[26,1,26,5],[26,6,26,7],[27,2,27,4],[27,6,27,7],[23,2,23,4],[23,6,23,7],[24,2,24,4],[24,6,24,7],[25,2,25,4],[25,6,25,7],[19,2,19,4],[19,6,19,7],[20,1,20,5],[20,6,20,7],[21,2,21,4],[21,6,21,7],[16,1,16,5],[16,6,16,7],[17,2,17,4],[17,6,17,7],[18,2,18,4],[18,6,18,7],[13,2,13,4],[13,6,13,7],[14,2,14,4],[14,6,14,7],[15,2,15,4],[15,6,15,7],[10,2,10,4],[10,6,10,7],[11,1,11,5],[11,6,11,7],[12,2,12,4],[12,6,12,7],[0,1,0,7],[6,1,6,7],[8,2,8,4],[8,6,8,7],[9,2,9,4],[9,6,9,7],[7,1,7,5],[7,6,7,7],[2,3,2,4],[5,1,5,3],[5,6,5,7]]}
[null,"Proposed Solution Evaluation Rubric"]
[]
[null,null,"Provider","Data Systems 'R Us",null,"Score",{"$f":"IF(SUM($I:$I)>0,SUM($G8,$G12,$G17,$G21,$G27)/SUM($I8,$I12,$I17,$I21,$I27),\"\")","v":1}]
[]
[]
[null,"Requirements",null,null,null,null,"Points Awarded",null,"Total Points","Percent of Total"]
[null,"Points:  1=Not Adequate, 2=Mostly Adequate, 3=Completely Adequate"]
[null,"Completeness",null,null,null,null,{"$f":"SUM(G9:G11)","v":9},{"$f":"SUM(H9:H11)","v":0},{"$f":"SUM(I9:I11)","v":9},{"$f":"IF(SUM($I:$I)>0,$I8/(SUM($I:$I)/2),\"\")","v":0.1875}]
[null,null,"Does system offer all required functions and features?\n",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I9/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,null,"Does system generate all required NRS/WIOA tables?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I10/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,null,"Does it offer additional nice-to-have features?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I11/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,"Reliability",null,null,null,null,{"$f":"SUM(G13:G16)","v":12},{"$f":"SUM(H13:H16)","v":0},{"$f":"SUM(I13:I16)","v":12},{"$f":"IF(SUM($I:$I)>0,$I12/(SUM($I:$I)/2),\"\")","v":0.25}]
[null,null,"Does system operate consistently and reliably, even under load?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I13/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,null,"Does system provide sufficiently fast response time, even under load?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I14/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,null,"Does system appropriately enforce agency's business rules?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I15/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,null,"Does system provide sufficient data validation checks and alerts?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I16/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,"Compatibility",null,null,null,null,{"$f":"SUM(G18:G20)","v":9},{"$f":"SUM(H18:H20)","v":0},{"$f":"SUM(I18:I20)","v":9},{"$f":"IF(SUM($I:$I)>0,$I17/(SUM($I:$I)/2),\"\")","v":0.1875}]
[null,null,"Will system function within agency's prescribed operating environment? Operating systems? Databases?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I18/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,null,"Does system meet agency's security/privacy requirements?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I19/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,null,"Is system capable of receiving and sharing interagency data, as needed for data matching and other needs?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I20/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,"Vendor Considerations",null,null,null,null,{"$f":"SUM(G22:G26)","v":15},{"$f":"SUM(H22:H26)","v":0},{"$f":"SUM(I22:I26)","v":15},{"$f":"IF(SUM($I:$I)>0,$I21/(SUM($I:$I)/2),\"\")","v":0.3125}]
[null,null,"Is agency ownership of data assured? Can data be easily exported for use in another system?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I22/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,null,"Is continuity of service ensured, should vendor cease operations?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I23/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,null,"Does vendor take appropriate steps to secure state and participant data?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I24/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,null,"Can changes in the system be made to address changes in state policies/procedures, if necessary?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I25/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,null,"Does vendor appear to be responsive and helpful?",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I26/SUM($I:$I)*2,\"\")","v":6.25E-2}]
[null,"Cost",null,null,null,null,{"$f":"SUM($G28:$G28)","v":3},{"$f":"SUM($I28:$I28)","v":3},{"$f":"SUM($I28:$I28)","v":3},{"$f":"IF(SUM($I:$I)>0,$I27/(SUM($I:$I)/2),\"\")","v":6.25E-2}]
[null,null,"Do system costs—including development, updates, and training costs—meet state requirements?\n",null,null,null,3,null,3,{"$f":"IF(SUM($I:$I)>0,$I28/SUM($I:$I)*2,\"\")","v":6.25E-2}]

{"sheet":"Project Planner Template","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":true,"merged":[[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[0,1,0,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[10,2,10,3],[11,2,11,3]]}
[null,"Project Management Tool"]
[]
[null,"Project Planner"]
[null,"Fill In Project To-Dos, People Responsible, Challenges, Dates and Duration in the Unshaded Cells."]
[null,"WARNING: Do Not Change Shaded Cells"]
[]
[null,"Project Start Date:",{"$f":"MIN(G11:G17)","v":"2017-01-01"}]
[null,"Project End Date:",{"$f":"RescaleGannt(MAX($J11:$J16))","v":{"$error":"#VALUE!"}}]
[]
[null,"Phase","Key To-Dos",null,"People/Person Responsible","Anticiapted Challeges","Est Start Date","Duration\n(Days)","Effort\n(Hours)","Est End Date"]
[null,"Discovery","Stakeholder Focus Group\nReview of Old System\nResearch Capabilities of Vendor Offerings",null,"Planning Team\nStakeholders, as needed","Prioritizing feature requests from stakeholders","2017-01-01",20,160,{"$f":"$G11+$H11","v":"2017-01-21"}]
[null,"Requirements Definition","Prepare:\n- Roles and Use Cases\n- System Functions\n- Data Entities\n- Data Dictionary\n- List of capacity, security and other Considerations\n- Rubric for evaluating RFPS\n- Final RFP",null,"Planning Team","None","2017-01-22",22,160,"2017-02-13"]
[null,"Evaluate/Develop Solutions","Receive, Review and Evaluate Propsosals\nObtain feedback from IT\nDiscuss preferred solutions\nReview with State Director",null,"Planning Team\nState Director\nIT Resource Staff","None","2017-03-01",21,120,"2017-03-22"]
[null,"Quality Assurance","Prepare testing protocol\nRecruit Alpha and Beta Testers\nConduct performance and usability tests\nAddress issues with vendor and/or staff",null,"QA Team\nAlpha and Beta Testers\nVendor\nIT Resource Staff, if needed","Minor performance/usability issues","2017-04-01",31,320,"2017-05-02"]
[null,"Pre-Launch","Data Conversion\nConfiguration on Hosted Platform\nPrepare Training Materials\nConduct Training",null,"Data System Administrator\nState Staff (Resource)\nVendor\nState Training Staff\nProgram Staff to be Trained","None anticipated","2017-05-01",21,500,"2017-05-22"]
[null,"Post-Rollout Support","Provide Helpdesk style support via phone for critical issues, and email for questions",null,"State Training Staff","None anticipated","2017-06-01","Ongoing","6 hrs/week","ongoing"]