{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ScoreCard","LookUps"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"ScoreCard","index":0,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[2,1,2,4],[3,1,3,4],[7,1,7,4],[50,0,50,4],[4,1,4,4],[6,1,6,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[5,1,5,4]]}
["PROJECT PRIORITIZATION MATRIX"]
[]
["Project Name:","Timesheet Approval Exceptions Report"]
["Date Scored:","2020-02-27"]
["Requested Due Date:","2020-05-28"]
["Primary Strategic Goal:","  5 - Aligning for Excellence and Value"]
["Estimated Size (ITS Time Commitment):","  Unknown"]
[" Overall Project Score (Sum of Scores Below):",{"$f":"E14+E27+E38","v":38.019999999999996}]
["University Criteria Score:",{"$f":"E14","v":4}]
["Strategic Goal Score:",{"$f":"E27","v":9}]
["Risk Score:",{"$f":"E38","v":25.02}]
[]
[null,"SCORING VALUES ","SCORE","WEIGHTED SCORE","SUBTOTALS"]
["Criteria",null,null,null,{"$f":"SUM(D15:D26)","v":4}]
["C.01  This is a compliance-related Project","No",{"$f":"VLOOKUP(B15,LookUps!$B$4:$C$5,2)","v":0},{"$f":"C15*6","v":0}]
["C.02  This project has security-related objectives","No",{"$f":"VLOOKUP(B16,LookUps!$B$4:$C$5,2)","v":0},{"$f":"C16*5","v":0}]
["C.03  This project is related to Critical Software/Hardware Updates","No",{"$f":"VLOOKUP(B17,LookUps!$B$4:$C$5,2)","v":0},{"$f":"C17*5","v":0}]
["C.04  This project will lead to significant cost reduction for the institution","Low: 1 to 50K",{"$f":"VLOOKUP(B18,LookUps!$B$7:$C$10,2)","v":0.5},{"$f":"C18*4","v":2}]
["C.05  This project will increase revenue for the university","Not Applicable",{"$f":"VLOOKUP(B19,LookUps!$B$7:$C$10,2)","v":0},{"$f":"C19*4","v":0}]
["C.06  This project will help increase enrollment","No",{"$f":"VLOOKUP(B20,LookUps!B4:C5,2)","v":0},{"$f":"C20*4","v":0}]
["C.07  This project helps improve Student Retention","No",{"$f":"VLOOKUP(B21,LookUps!B4:C5,2)","v":0},{"$f":"C21*4","v":0}]
["C.08  This project will Increase efficiency","Not Applicable",{"$f":"VLOOKUP(B22,LookUps!$B$12:$C$15,2)","v":0},{"$f":"C22*2","v":0}]
["C.09  This project will provide Enhanced Functionality not currently available","Yes",{"$f":"VLOOKUP(B23,LookUps!$B$4:$C$5,2)","v":1},{"$f":"C23*2","v":2}]
["C.10  This project helps improve Customer Satisfaction","No",{"$f":"VLOOKUP(B24,LookUps!$B$4:$C$5,2)","v":0},{"$f":"C24*2","v":0}]
["C.11  This project helps give the institution a Competitive Advantage","No",{"$f":"VLOOKUP(B25,LookUps!$B$4:$C$5,2)","v":0},{"$f":"C25","v":0}]
["C.12  This project is related to environmental sustainability","No",{"$f":"VLOOKUP(B26,LookUps!$B$4:$C$5,2)","v":0},{"$f":"C26","v":0}]
["Strategic Goals",null,null,null,{"$f":"SUM($D$28:$D$37)","v":9}]
["Enhances student success through personal or career growth (SO-1)","Does Not Meet Goal",{"$f":"VLOOKUP(B28,LookUps!$B$19:$C$20,2)","v":0},{"$f":"C28*LookUps!$C$18","v":0}]
["Expands engagement and partnerships (domestic or international) (SO-4)","Does Not Meet Goal",{"$f":"VLOOKUP(B29,LookUps!$B$19:$C$20,2)","v":0},{"$f":"C29*LookUps!$C$18","v":0}]
["Improves affordability or efficiency (SO-5)","Meets Goal",{"$f":"VLOOKUP(B30,LookUps!$B$19:$C$20,2)","v":1},{"$f":"C30*LookUps!$C$18","v":3}]
["Improves University business processes (SO-5)","Meets Goal",{"$f":"VLOOKUP(B31,LookUps!$B$19:$C$20,2)","v":1},{"$f":"C31*LookUps!$C$18","v":3}]
["Increases student recruitment, retention, or persistence (SO-1)","Does Not Meet Goal",{"$f":"VLOOKUP(B32,LookUps!$B$19:$C$20,2)","v":0},{"$f":"C32*LookUps!$C$18","v":0}]
["Promotes employee advancement or recruitment (SO-3)","Does Not Meet Goal",{"$f":"VLOOKUP(B33,LookUps!$B$19:$C$20,2)","v":0},{"$f":"C33*LookUps!$C$18","v":0}]
["Promotes innovation or collaboration (SO-3)","Does Not Meet Goal",{"$f":"VLOOKUP(B34,LookUps!$B$19:$C$20,2)","v":0},{"$f":"C34*LookUps!$C$18","v":0}]
["Supports academic or financial success (SO-5)","Meets Goal",{"$f":"VLOOKUP(B35,LookUps!$B$19:$C$20,2)","v":1},{"$f":"C35*LookUps!$C$18","v":3}]
["Supports excellence, diversity, or inclusion (SO-3)","Does Not Meet Goal",{"$f":"VLOOKUP(B36,LookUps!$B$19:$C$20,2)","v":0},{"$f":"C36*LookUps!$C$18","v":0}]
["Supports research, creativity, or serves public good (SO-2)","Does Not Meet Goal",{"$f":"VLOOKUP(B37,LookUps!$B$19:$C$20,2)","v":0},{"$f":"C37*LookUps!$C$18","v":0}]
["Risks (A lower risk score means the project is more risky.)",null,null,null,{"$f":"SUM(D39:D48)","v":25.02}]
["Damaged Goodwill","Low",{"$f":"VLOOKUP(B39,LookUps!$B$24:$C$27,2)","v":0.67},{"$f":"C39*LookUps!$C$23","v":2.0100000000000002}]
["Impact On Other Projects","Low",{"$f":"VLOOKUP(B40,LookUps!$B$24:$C$27,2)","v":0.67},{"$f":"C40*LookUps!$C$23","v":2.0100000000000002}]
["Increased Workflow Complexity","Not Applicable",{"$f":"VLOOKUP(B41,LookUps!$B$24:$C$27,2)","v":1},{"$f":"C41*LookUps!$C$23","v":3}]
["Lack of Commitment","Not Applicable",{"$f":"VLOOKUP(B42,LookUps!$B$24:$C$27,2)","v":1},{"$f":"C42*LookUps!$C$23","v":3}]
["Learning Curves","Not Applicable",{"$f":"VLOOKUP(B43,LookUps!$B$24:$C$27,2)","v":1},{"$f":"C43*LookUps!$C$23","v":3}]
["Missed Expectations/Opportunities","Medium",{"$f":"VLOOKUP(B44,LookUps!$B$24:$C$27,2)","v":0.33},{"$f":"C44*LookUps!$C$23","v":0.99}]
["Resource Bottlenecks","Low",{"$f":"VLOOKUP(B45,LookUps!$B$24:$C$27,2)","v":0.67},{"$f":"C45*LookUps!$C$23","v":2.0100000000000002}]
["Total Cost of Ownership","Not Applicable",{"$f":"VLOOKUP(B46,LookUps!$B$24:$C$27,2)","v":1},{"$f":"C46*LookUps!$C$23","v":3}]
["Unknown Complexity","Not Applicable",{"$f":"VLOOKUP(B47,LookUps!$B$24:$C$27,2)","v":1},{"$f":"C47*LookUps!$C$23","v":3}]
["Vendor Dependability","Not Applicable",{"$f":"VLOOKUP(B48,LookUps!$B$24:$C$27,2)","v":1},{"$f":"C48*LookUps!$C$23","v":3}]
[]
["Executive Summary:"]
["This project evaluation is requesting resources to create a timesheet approval exceptions report out of PeopleSoft. The current process is that any timesheet approver within a department can approve any other timesheet within the department, regardless of being the appropriate supervisor to do so. The benefits of generating this report and automatically distributing it to the appropriate supervisors will be to identify those timesheets that are approved without proper supervisor rights to do so, preventing hours/wages being stolen by unauthorized approvals.\n\nThe requested due date for implementation is May 28th, 2020 in order to close the identified risk of stolen wages in a timely manner. If this is not implemented by this time, it will become a reportable internal audit finding.\n\n\n\n\n\n\n"]

{"sheet":"LookUps","index":1,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Criteria"]
["No","No",0]
["Yes","Yes",1]
[]
["Not Applicable","High: 500K+",1]
["Low: 1 to 50K","Low: 1 to 50K",0.5]
["Medium 50K to 500K","Medium 50K to 500K",0.75]
["High: 500K+","Not Applicable",0]
[]
["Not Applicable","High - University Wide",1]
["Low - Department","Low - Department",0.5]
["Medium - Multidepartment","Medium - Multidepartment",0.75]
["High - University Wide","Not Applicable",0]
[]
[]
["Goals",null,{"$f":"30/10","v":3}]
["Does Not Meet Goal","Does Not Meet Goal",0]
["Meets Goal","Meets Goal",1]
[]
[]
["Risks",null,{"$f":"30/10","v":3}]
["Not Applicable","High",0]
["Low","Low",0.67]
["Medium","Medium",0.33]
["High","Not Applicable",1]
[]
[]
["Effort"]
["  Small (1 to 100 hours)"]
["  Medium (101 to 200 hours)"]
["  Large (200+ hours)"]
["  Unknown"]
[]
[]
["Strategic Goals"]
["  1 - Redefining Student Success "]
["  2 - Connecting Activities for Public Good"]
["  3 - Supporting our People to Achieve Excellence"]
["  4 - Advancing our Impact"]
["  5 - Aligning for Excellence and Value"]
["  6 - Telling Our Story"]
["  Unknown/None"]