{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Project Proposal","Resource Plan","Security and Impact Analysis","Project Schedule","Project Closeout Report","Post Project Support Plan","Issue Log","Communication Plan","Change Management Plan","Budget Plan","Sheet1","Requirements"],"read":"whole","date_system":"1900"}

{"sheet":"Project Proposal","index":0,"n_rows":42,"n_cols":11,"rows_kept":42,"merged":[[1,2,1,5],[3,2,3,5],[5,2,5,5],[7,2,7,7],[8,15,8,16],[8,24,8,25],[8,33,8,34],[8,42,8,43],[8,51,8,52],[8,60,8,61],[8,69,8,70],[8,78,8,79],[8,87,8,88],[8,96,8,97],[8,105,8,106],[8,114,8,115],[8,123,8,124],[8,132,8,133],[8,141,8,142],[8,150,8,151],[8,159,8,160],[8,168,8,169],[8,177,8,178],[8,186,8,187],[8,195,8,196],[8,204,8,205],[8,213,8,214],[8,222,8,223],[8,231,8,232],[8,240,8,241],[8,249,8,250],[9,15,9,16],[9,24,9,25],[9,33,9,34],[9,42,9,43],[9,51,9,52],[9,60,9,61],[9,69,9,70],[9,78,9,79],[9,87,9,88],[9,96,9,97],[9,105,9,106],[9,114,9,115],[9,123,9,124],[9,132,9,133],[9,141,9,142],[9,150,9,151],[9,159,9,160],[9,168,9,169],[9,177,9,178],[9,186,9,187],[9,195,9,196],[9,204,9,205],[9,213,9,214],[9,222,9,223],[9,231,9,232],[9,240,9,241],[9,249,9,250],[10,2,10,7],[11,15,11,16],[11,24,11,25],[11,33,11,34],[11,42,11,43],[11,51,11,52],[11,60,11,61],[11,69,11,70],[11,78,11,79],[11,87,11,88],[11,96,11,97],[11,105,11,106],[11,114,11,115],[11,123,11,124],[11,132,11,133],[11,141,11,142],[11,150,11,151],[11,159,11,160],[11,168,11,169],[11,177,11,178],[11,186,11,187],[11,195,11,196],[11,204,11,205],[11,213,11,214],[11,222,11,223],[11,231,11,232],[11,240,11,241],[11,249,11,250],[12,0,15,0],[12,2,12,7],[13,2,13,7],[14,2,14,7],[15,2,15,7],[16,15,16,16],[16,24,16,25],[16,33,16,34],[16,42,16,43],[16,51,16,52],[16,60,16,61],[16,69,16,70],[16,78,16,79],[16,87,16,88],[16,96,16,97],[16,105,16,106],[16,114,16,115],[16,123,16,124],[16,132,16,133],[16,141,16,142],[16,150,16,151],[16,159,16,160],[16,168,16,169],[16,177,16,178],[16,186,16,187],[16,195,16,196],[16,204,16,205],[16,213,16,214],[16,222,16,223],[16,231,16,232],[16,240,16,241],[16,249,16,250],[17,0,18,0],[17,2,17,7],[18,2,18,7],[19,15,19,16],[19,24,19,25],[19,33,19,34],[19,42,19,43],[19,51,19,52],[19,60,19,61],[19,69,19,70],[19,78,19,79],[19,87,19,88],[19,96,19,97],[19,105,19,106],[19,114,19,115],[19,123,19,124],[19,132,19,133],[19,141,19,142],[19,150,19,151],[19,159,19,160],[19,168,19,169],[19,177,19,178],[19,186,19,187],[19,195,19,196],[19,204,19,205],[19,213,19,214],[19,222,19,223],[19,231,19,232],[19,240,19,241],[19,249,19,250],[20,2,20,3],[20,4,20,5],[20,6,20,7],[21,2,21,3],[21,4,21,5],[21,6,21,7],[22,2,22,3],[22,4,22,5],[22,6,22,7],[23,2,23,3],[23,4,23,5],[23,6,23,7],[24,2,24,3],[24,4,24,5],[24,6,24,7],[25,2,25,3],[25,4,25,5],[25,6,25,7],[26,2,26,3],[26,4,26,5],[26,6,26,7],[27,2,27,3],[27,4,27,5],[27,6,27,7],[28,2,28,3],[28,4,28,5],[28,6,28,7],[29,2,29,3],[29,4,29,5],[29,6,29,7],[30,2,30,3],[30,4,30,5],[30,6,30,7],[31,2,31,3],[31,4,31,5],[31,6,31,7]]}
[]
["Project title",{"$nulls":5},"Start date"]
[]
["Project manager",{"$nulls":5},"Est. End Date"]
[]
["Strategic objective",{"$nulls":5}," Est. Budget"]
[]
["Project Goals and Objectives"]
[]
[]
["Project scope"]
[]
["Impact Analysis",null,"The total budget for this project is < $100,000 LOW COMPLEXITY"]
[null,null,"This project will change one or two existing business processes LOW COMPLEXITY"]
[null,null,"This project will not interrupt existing production IT systems LOW COMPLEXITY"]
[null,null,"This project is not mission critical LOW COMPLEXITY"]
[]
["Project Classification ",null,"LOW COMPLEXITY"]
[null,null,"Classify the project using the highest compexity rating of any of the impact analysis sections above."]
[]
["Recommended documentation",null,"Low Complexity",null,"Medium Compexity",null,"High Complexity"]
["Project proposal",null,"X",null,"X",null,"X"]
["Resource Plan",null,"X",null,"X",null,"X"]
["Security and Impact Analysis",null,"X",null,"X",null,"X"]
["Project Schedule",null,"X",null,"X",null,"X"]
["Post Project Support Plan",null,"X",null,"X",null,"X","X"]
["Project Closeout Report",null,"X",null,"X",null,"X"]
["Issue Log",null,"Optional",null,"X",null,"X"]
["Communications Plan",null,"Optional",null,"X",null,"X"]
["Change Management Plan","O","Optional",null,"Optional",null,"X"]
["Budget Plan",null,"Optional",null,"Optional",null,"X"]
["Report to ITIB",null,"Not required",null,"Not required",null,"X"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"The total budget for this project is < $100,000 LOW COMPLEXITY","This project will change one or two existing business processes LOW COMPLEXITY","This project does not impact any College departments LOW COMPLEXITY","This project will not interrupt existing production IT systems LOW COMPLEXITY","This project is not mission critical LOW COMPLEXITY","This project has no statewide implications LOW COMPLEXITY","HIGH COMPLEXITY"]
[{"$nulls":3},"The total budget for this project is between $100,000.00 and $1,000,000.00 MEDIUM COMPLEXITY","This project will change several business processes but within a single College department MEDIUM COMPLEXITY","This project will impact one or two College departments MEDIUM COMPLEXITY","This project will interruipt existing production IT systems but for < 4 hours and not during normal business hours MEDIUM COMPLEXITY","This proejct is not mission critical for the College but it is for at least one to several departments MEDIUM COMPLEXITY",null,"MEDIUM COMPLEXITY","LOW COMPLEXITY"]
[{"$nulls":3},"The total budget for this project is > $1,000,000.00 HIGH COMPLEXITY","This project will change several business processes across multiple College departments HIGH COMPLEXITY","This project will impact several Colleg departments HIGH COMPLEXITY","This project will interruipt existing production IT systems  for > 4 hours and possibly during  normal business hours HIGH COMPLEXITY","This project is mission critical HIGH COMPLEXITY","This project has statewide implications HIGH COMPLEXITY","LOW COMPLEXITY","MEDIUM COMPLEXITY"]
[{"$nulls":10},"HIGH COMPLEXITY"]

{"sheet":"Resource Plan","index":1,"n_rows":3,"n_cols":4,"rows_kept":3,"merged":[[1,0,1,3]]}
[]
["Project Human Resources"]
["Name","Role","Phone","Email"]

{"sheet":"Security and Impact Analysis","index":2,"n_rows":133,"n_cols":3,"rows_kept":133,"merged":[[0,0,0,2],[113,0,113,2]]}
["Seurity and Impact Analysis"]
["Security Considerations","Impact /","Explanation"]
[null,"Dependency"]
["Data Security (Confidentiality/Integrity/Availability)"," "]
["Access control"]
["Physical and environmental security"]
["Network security"]
["Compliance"]
["Disaster recovery"]
[]
["Application/System","Impact /Dependency","Explanation"]
["Banner Admin (INB)"]
["Accounts Database"]
["Athletics Ticket System"]
["Advance"]
["Active Directory"]
["Apply Yourself"]
["Banner"]
["Accounts Receivable"]
["Finance"]
["Financial Aid"]
["Human Resources"]
["Student"]
["Self Service"]
["Blackboard Course Mgmt"]
["Blackboard Optim (ID card system)"]
["Campus Directory"]
["Career Services"]
["CollegeNet"]
["CommonApp"]
["Conference Programming/CVent"]
["Course Evaluations"]
[]
["Discoverer"]
["e-print"]
["eSUDS"]
["FAACS –Fixed Asset"]
["FAMIS Maintenance Mgmt"]
["GER"]
["Harvest"]
["Identipass (Building Access) "]
["Institutional Reporting"]
["Intellicheck"]
["iTunesU"]
["Judicial System"]
["Law School – Career Center"]
["LDAP"]
["Luminis  4"]
["Mainframe"]
["Meal Plan System"]
["Mirapoint Email"]
["MySoft (Telecom)"]
["ODS"]
["One Step (CORE Cashiering)"]
["Oracle Calendar"]
["DOSO Orientation"]
["Parking Services TickeTrax"]
["PBR"]
["PeopleAdmin"]
["PIES"]
["Pitney Bowes Postal System"]
["Protocol and Compliance Management"]
["Pyramed"]
["Rec Center (student file sent)"]
["Remedy"]
["SIRIS (SWEM Library)"]
["SSD-Axiom"]
["State Agency Reporting"]
["Sympa"]
[null,null,"No longer used"]
["Winstar"]
[]
["Tools","Impact /","Explanation"]
[null,"Dependency"]
["Applicatoin Server"]
["Browsers (IE, Safari, Firefox)"]
["Cascade"]
["Client OS (MAC, VISTA, XP, UNIX)"]
["COBOL/C"]
["ColdFusion"]
["Database Backends (mySQL, SQL Server,, Access)"]
["Development Tools"]
["Discoverer"]
["Java (j:/initiator, java plug-in)"]
["Opinio"]
["Oracle APEX"]
["Oracle database"]
["Oracle Web Servers"]
[]
["Functional Offices","Impact /","Explanation"]
[null,"Dependency"]
["Admissions"]
["Alumni Association"]
["Dean of Students",null,"Will need to assess impact on orientation goals for new students"]
["Development"]
["Finance",null,"Outage may conflict with year end reporting"]
["Financial Aid"]
["Human Resources"]
["Intercollegiate Athletics"]
["Public Affairs"]
["Reves Center"]
["School of Arts & Sciences"]
["School of Business"]
["School of Education"]
["School of Law"]
["School of Marine Science"]
["Student Affairs"]
["Swem Library"]
["University Registrar",null,"Late July outage may conflict with registration windows for Freshman."]
[]
[]
["Projects","Impact /","Explanation"]
[null,"Dependency"]
["Review project list and list those projects that will be impacted."]
[]
[]
[]
["Data Feeds","Impact /","Explanation"]
[null,"Dependency"]
["Alumni Office (Banner to Advance feed)"]
["Campus Post Office"]
["Career Services"]
["Dean of Students "]
["Orientation"]
["Transfers"]
["Health Center (student data file for Pyramed)"]
["Identipass (Building Access) "]
["Law School – Career Center"]
["Rec Center (student file sent)"]
["SHEV Report"]
["State Police"]
["SWEM Library (Discoverer file sent – students/fac/staff)"]
["Vendor Transaction Report (sent to APA)"]

{"sheet":"Project Schedule","index":3,"n_rows":126,"n_cols":5,"rows_kept":126,"merged":[[0,0,0,4]]}
["Project Schedule"]
["Task ID","Task","Estimated Completion","Assigned ","Status"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]

{"sheet":"Project Closeout Report","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"merged":[[0,0,0,5],[1,0,1,5],[2,0,30,5]]}
["Project Closeout Report"]
["Please use this section to document key lessons learned and other information that could assist project management on other projects."]

{"sheet":"Post Project Support Plan","index":5,"n_rows":3,"n_cols":3,"rows_kept":3,"merged":[[0,0,0,2]]}
["Post Project Support Plan"]
[]
["Support Position","Identified Resource","Start Date"]

{"sheet":"Issue Log","index":6,"n_rows":123,"n_cols":4,"rows_kept":123}
["ID #","Issue Description","Status Notes","Identified by"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]

{"sheet":"Communication Plan","index":7,"n_rows":3,"n_cols":6,"rows_kept":3,"merged":[[0,0,0,5],[1,0,1,5]]}
["Project Communication Plan"]
["Only required for MEDIUM or HIGHLY COMPLEX projects"]
["Key Stakeholder or Group","Communication","Method","Schedule","Location","Responsible"]

{"sheet":"Change Management Plan","index":8,"n_rows":7,"n_cols":8,"rows_kept":7,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[4,0,4,1],[4,2,4,3]]}
["Project Change Management Plan"]
["Only required for HIGHLY COMPLEX projects"]
["All project change requests require an impact analysis and evaluation by the Project Change Management Lead and Project Manager.  Final approval or disapproval will be determined jointly by the Project Manager and key Project Stakeholders."]
[]
["Project Change Management Lead"]
[]
["Requestor","Date","Description","Schedule Impact","Budget Impact","Deliverable Impact","Other Impact","Status"]

{"sheet":"Budget Plan","index":9,"n_rows":24,"n_cols":6,"rows_kept":24,"merged":[[0,0,0,5],[22,1,22,2]]}
["Project Budget Plan"]
[]
["Product/Service","Estimated Cost","Actual cost","Vendor(s)","Index ","Account"]
{"$rows_empty":18}
["TOTAL",{"$f":"SUM(B5:B21)","v":0},{"$f":"SUM(C5:C21)","v":0}]
["Contingency $$ ",{"$f":"0.1*B22","v":0}]
["Contingency $$ is only required for HIGHLY COMPLEX projects and equals 10% of estimated project budget"]

{"sheet":"Sheet1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Requirements","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}