{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary-Sheet","Unit Inventory","Individual Application Template","Master"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":1,"defined_names":43,"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":"Summary-Sheet","index":0,"n_rows":200,"n_cols":10,"rows_kept":200,"cut":false,"hidden":false,"merged":[[0,1,0,9]]}
[null,"Use this icon to update the summary sheet for data analysis"]
["Application Worksheet","Application Name","BV Score","Cost Score","Hardware Cost","Software Cost","O&M Cost","Staff Cost","Total Cost","BV/Cost Ratio"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(E3:H3)","v":0},{"$f":"IFERROR(C3/D3,0)","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(E67:H67)","v":0},{"$f":"IFERROR(C67/D67,0)","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(E131:H131)","v":0},{"$f":"IFERROR(C131/D131,0)","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(E195:H195)","v":0},{"$f":"IFERROR(C195/D195,0)","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,"Please copy cell formulas after this row",null,null,null,null,null,null,0,0]

{"sheet":"Unit Inventory","index":1,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,2,0,7]]}
[null,null,"     Use this icon to create or access an application-specific worksheet. Go to that application row in the worksheet below and click the icon."]
["App ID","Unit Name","Department Name","App name","Current Status","Business Owner","Business Contact","Technical Owners","Technical Contact","BV Score","Cost Score","BV/Cost Ratio","Not scored reason","Comments","Primary Functional Purpose","Secondary Functional Purpose"]
[{"$f":"ROW(3:3)-2","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(\nJ3/K3,0)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(\nJ4/K4,0)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,0]
[32,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW(35:35)-2","v":33},null,null,null,null,null,null,null,null,null,null,0]
[34,null,null,null,null,null,null,null,null,null,null,0]
[35,null,null,null,null,null,null,null,null,null,null,0]
[36,null,null,null,null,null,null,null,null,null,null,0]
[37,null,null,null,null,null,null,null,null,null,null,0]
[38,null,null,null,null,null,null,null,null,null,null,0]
[39,null,null,null,null,null,null,null,null,null,null,0]
[40,null,null,null,null,null,null,null,null,null,null,0]
[41,null,null,null,null,null,null,null,null,null,null,0]
[42,null,null,null,null,null,null,null,null,null,null,0]
[43,null,null,null,null,null,null,null,null,null,null,0]
[44,null,null,null,null,null,null,null,null,null,null,0]
[45,null,null,null,null,null,null,null,null,null,null,0]
[46,null,null,null,null,null,null,null,null,null,null,0]
[47,null,null,null,null,null,null,null,null,null,null,0]
[48,null,null,null,null,null,null,null,null,null,null,0]
[49,null,null,null,null,null,null,null,null,null,null,0]
[50,null,null,null,null,null,null,null,null,null,null,0]
[51,null,null,null,null,null,null,null,null,null,null,0]
[52,null,null,null,null,null,null,null,null,null,null,0]
[53,null,null,null,null,null,null,null,null,null,null,0]
[54,null,null,null,null,null,null,null,null,null,null,0]
[55,null,null,null,null,null,null,null,null,null,null,0]
[56,null,null,null,null,null,null,null,null,null,null,0]
[57,null,null,null,null,null,null,null,null,null,null,0]
[58,null,null,null,null,null,null,null,null,null,null,0]
[59,null,null,null,null,null,null,null,null,null,null,0]
[60,null,null,null,null,null,null,null,null,null,null,0]
[61,null,null,null,null,null,null,null,null,null,null,0]
[62,null,null,null,null,null,null,null,null,null,null,0]
[63,null,null,null,null,null,null,null,null,null,null,0]
[64,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW(67:67)-2","v":65},null,null,null,null,null,null,null,null,null,null,0]
[66,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(\nJ68/K68,0)","v":0}]
[67,null,null,null,null,null,null,null,null,null,null,0]
[68,null,null,null,null,null,null,null,null,null,null,0]
[69,null,null,null,null,null,null,null,null,null,null,0]
[70,null,null,null,null,null,null,null,null,null,null,0]
[71,null,null,null,null,null,null,null,null,null,null,0]
[72,null,null,null,null,null,null,null,null,null,null,0]
[73,null,null,null,null,null,null,null,null,null,null,0]
[74,null,null,null,null,null,null,null,null,null,null,0]
[75,null,null,null,null,null,null,null,null,null,null,0]
[76,null,null,null,null,null,null,null,null,null,null,0]
[77,null,null,null,null,null,null,null,null,null,null,0]
[78,null,null,null,null,null,null,null,null,null,null,0]
[79,null,null,null,null,null,null,null,null,null,null,0]
[80,null,null,null,null,null,null,null,null,null,null,0]
[81,null,null,null,null,null,null,null,null,null,null,0]
[82,null,null,null,null,null,null,null,null,null,null,0]
[83,null,null,null,null,null,null,null,null,null,null,0]
[84,null,null,null,null,null,null,null,null,null,null,0]
[85,null,null,null,null,null,null,null,null,null,null,0]
[86,null,null,null,null,null,null,null,null,null,null,0]
[87,null,null,null,null,null,null,null,null,null,null,0]
[88,null,null,null,null,null,null,null,null,null,null,0]
[89,null,null,null,null,null,null,null,null,null,null,0]
[90,null,null,null,null,null,null,null,null,null,null,0]
[91,null,null,null,null,null,null,null,null,null,null,0]
[92,null,null,null,null,null,null,null,null,null,null,0]
[93,null,null,null,null,null,null,null,null,null,null,0]
[94,null,null,null,null,null,null,null,null,null,null,0]
[95,null,null,null,null,null,null,null,null,null,null,0]
[96,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW(99:99)-2","v":97},null,null,null,null,null,null,null,null,null,null,0]
[98,null,null,null,null,null,null,null,null,null,null,0]
[99,null,null,null,null,null,null,null,null,null,null,0]
[100,null,null,null,null,null,null,null,null,null,null,0]
[101,null,null,null,null,null,null,null,null,null,null,0]
[102,null,null,null,null,"Please copy the cell formulas to the next sheet",null,null,null,null,null,0]

{"sheet":"Individual Application Template","index":2,"n_rows":105,"n_cols":4,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["Description","Phase 1","Notes"]
["Application ID",null,"Number from the inventory worksheet"]
["Application Name",{"$f":"LOOKUP(B2, 'Unit Inventory'!A3:A101, 'Unit Inventory'!D3:D100)","v":{"$error":"#N/A"}},"Prepopulated from inventory list"]
["Unit Name",{"$f":"LOOKUP(B2, 'Unit Inventory'!A3:A101, 'Unit Inventory'!B3:B101)","v":{"$error":"#N/A"}},"Prepopulated from inventory list."]
["Department",{"$f":"LOOKUP(B2, 'Unit Inventory'!A3:A101, 'Unit Inventory'!C3:C101)","v":{"$error":"#N/A"}},"Prepopulated from inventory list."]
["Business Value Analysis","Phase 1","Notes"]
["Interview Date",null,"Date of inverview"]
["BA Contact",null,"Name, net id of BA"]
["Interviewee for Business Value",null,"Name, net id"]
["Business Purpose for Application",null,"One sentence description"]
["Primary Application Function/s",null,"Capabilities and functionality (e.g., workflow, calendar, etc)"]
["Business Processes Supported",null,"Verb/noun pairs, e.g., Tracks Pesticide, Insures Student"]
["Stakeholders for the application"]
["Uniqueness: Is there another application that could be used in place of your current application? Which one(s) and how?",null,"This area is the supporting narrative for the BV score sheet and selecting the score from the form"]
["Uniqueness Score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B15, Master!I23:I27, Master!H23:H27)","v":{"$error":"#N/A"}}]
["Risk: Is this application necessary to meet regulatory requirements or minimize institutional risk? Which ones?",null,"This area is the supporting narrative for the BV score sheet and selecting the score from the form"]
["Risk Score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B17, Master!I29:I33, Master!H29:H33)","v":{"$error":"#N/A"}}]
["Campus Impact: How much do other systems or business functions depend on data that is created by this application? Which, and what data?",null,"This area is the supporting narrative for the BV score sheet and selecting the score from the form"]
["Campus Impact Score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B19, Master!I35:I38, Master!H35:H38)","v":{"$error":"#N/A"}}]
["Data of Record: Does this application capture or support University Data of Record? What data and how?",null,"This area is the supporting narrative for the BV score sheet and selecting the score from the form"]
["Data of Record Score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B21, Master!I40:I43, Master!H40:H43)","v":{"$error":"#N/A"}}]
["Utility: Does this application automate a process that is complex, moderate, or simple?",null,"This area is the supporting narrative for the BV score sheet and selecting the score from the form"]
["Utility business complexity score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B23, Master!I45:I47, Master!H45:H47)","v":{"$error":"#N/A"}}]
["Utility: How well does this application meet  business requirements? ",null,"This area is the supporting narrative for the BV score sheet and selecting the score from the form"]
["Utility requirements score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B25, Master!I48:I50, Master!H48:H50)","v":{"$error":"#N/A"}}]
["Utility: How easy it is to use this application? ",null,"This area is the supporting narrative for the BV score sheet and selecting the score from the form"]
["Utility ease of use score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B27, Master!I51:I53, Master!H51:H53)","v":{"$error":"#N/A"}}]
["Strategy: Does this application support the goals and mission of your unit, department or individuals within? How?",null,"This area is the supporting narrative for the BV score sheet and selecting the score from the form"]
["Strategy Score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B29, Master!I55:I58, Master!H55:H58)","v":{"$error":"#N/A"}}]
["Total Application Business Value Score",{"$f":"SUM(D15,D17,D19,D21,D23,D25,D27,D29)","v":{"$error":"#N/A"}},"Auto calculated"]
["What are your future plans for this application?"]
["Is there anything that would allow you to eliminate this application?"]
["Comments",null,"\"other\" & general comments not captured in any section"]
["Cost Analysis","Phase 1 ","Notes"]
["Contact Name",null,"Name, net id of staff doing to cost calculations"]
["Application Type",null,"Select from drop down. "]
["Original Deployment",null,"Month (if available), year"]
["Last Major Update",null,"Month (if available), year"]
["Plans for next 3 years",null,"Select from drop down. "]
["Hardware Cost (include servers- computational, web, application, database; virtualization) "]
["Ongoing Hardware Maintenance Cost per Year",null,"Servers/VMs maintained or paid by unit in $"]
["Additional planned Hardware upgrade, replacement or retirement/ divestment cost over next 3 years (annualized)",null,"Anticipated annual expenses for unit in $"]
["Hardware Cost Total Annual $",{"$f":"SUM(B41:B42)","v":0},"Auto Calculated Cost "]
["Hardware Cost Score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B44, Master!I2:I7, Master!H2:H7)","v":{"$error":"#N/A"}}]
["Software Cost (Include purchase, licencing, upgrades, third-party add ons, etc)"]
["Ongoing Software Maintenance Cost per Year",null,"Annual expenses for unit in $"]
["Additional planned Software upgrade, replacement or retirement/ divestment cost over next 3 years (annualized)",null,"Anticipated annual expenses for unit in $"]
["Software Cost Total Annual $",{"$f":"SUM(B46:B47)","v":0},"Auto Calculated Cost "]
["Software Cost Score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B49, Master!I8:I12, Master!H8:H12)","v":{"$error":"#N/A"}}]
["Operations and Maintenance Cost (include backup and recovery, disaster planning, audit, security reviews, etc.)"]
["Ongoing Operations and Maintenance Cost per Year",null,"Annual expenses for unit in $"]
["Additional planned Operating and Maintenance cost over next 3 years (annualized)",null,"Annual expenses for unit in $"]
["Operations and Maintenance Cost Total Annual $",{"$f":"SUM(B51:B52)","v":0},"Auto Calculated Cost "]
["Operations and Maintenance Cost Score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B54, OperationsAndMaintenance, Master!H13:H15)","v":{"$error":"#N/A"}}]
["Staff Effort Cost (include problem resolution, customization, doing upgrades, support)"]
["Ongoing IT Staff Effort Maintenance Cost Per Year",null,"Annual expenses for unit in $"]
["Additional planned Staff Effort cost over next 3 years (annualized)",null,"Anticipated annual expenses for unit in $"]
["Staff Effort Cost Total Annual $",{"$f":"SUM(B56:B57)","v":0},"Auto Calculated Cost "]
["Staff Effort Cost Score",null,"Required for scoring. Select from drop down. ",{"$f":"LOOKUP(B59, StaffEffort, Master!H16:H20)","v":{"$error":"#N/A"}}]
["Total Application Cost Score",{"$f":"SUM(D44,D49,D54,D59)","v":{"$error":"#N/A"}},"Auto calculated"]
["Comments",null,"\"other\" & general comments not captured in any section"]
["Application Details","Phase 1 or 2","Notes"]
["Vendor"]
["Availibility of source code",null,"available, escrowed, unavailable"]
["Version Number"]
["Support Status",null,"current, unpaid, unavailable"]
["Number of licenses"]
["Type of licenses",null,"named, concurrent, other"]
["Contract Term",null,"end date"]
["Safety Net/Exit Strategy"]
["Known limitations or issues",null,"things that cause this to be less useful than it was intended"]
["Development group",null,"internal or external or both? Name if external"]
["Development language(s)"]
["Developer dependencies",null,"skills / training"]
["Middleware dependencies",null,"infrastructure"]
["Technical Fit","Phase 3","Notes"]
["Architecture "]
["Architecture Type"]
["Desktop"]
["Mainframe"]
["client/server"]
["web based"]
["n-tier"]
["Point to Point"]
["Operating System"]
["Progamming Language"]
["Database"]
["Oracle"]
["SQL Server"]
["Access"]
["Filemaker"]
["Interfaces"]
["Other application/infrastructure dependencies "]
["Sustainability/Maintainability"]
["Performance Issues?"]
["State of Documentation"]
["Security/Risk Status"]
["Authentication Solution"]
["Kerberos, Third Party"]
["Strength of Authentication"]
["Acceptable Physical Security"]
["Data backed up off site?"]
["Appropriate Disaster Recovery Plan in Place?"]
["Information Retention Policy defined and followed?"]
["Is it risky to retain the information?"]

{"sheet":"Master","index":3,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["App Status","Not scored reason","Application Type","Plan for next 3 years","Scored?","Cost"]
["Scheduled","Not in use","Custom with source","Actively Maintain","Yes","Hardware","H1 Greater than $25,000 per year",25,{"$f":"CONCATENATE(G2,\" (\",H2,\")\")","v":"H1 Greater than $25,000 per year (25)"}]
["BV Complete","No ongoing cost","Free Open Source Software","Upgrade","No",null,"H2 $20,000 to $25,000 per year",20,{"$f":"CONCATENATE(G3,\" (\",H3,\")\")","v":"H2 $20,000 to $25,000 per year (20)"}]
["Cost Complete","IT staff use only","Commercial Off The Shelf","Replace with central service",null,null,"H3 $15,000 to $20,000 per year",15,"H3 $15,000 to $20,000 per year (15)"]
["Done","Total cost < unit threshold","Software as a Service","Keep Alive",null,null,"H4 $5,000 to $15,000 per year",10,"H4 $5,000 to $15,000 per year (10)"]
["Not Scored","Other(add comment)","Custom without source","Retire/Divest",null,null,"H5 Less than $5,000 per year",5,"H5 Less than $5,000 per year (5)"]
[null,null,null,null,null,null,"H6 Virtualization or CIT Hosted Service",0,"H6 Virtualization or CIT Hosted Service (0)"]
[null,null,null,null,null,"Software","S1 Greater than $50,000 per year",25,"S1 Greater than $50,000 per year (25)"]
[null,"Functional Purpose",null,null,null,null,"S2 $25,000 to $50,000 per year",20,"S2 $25,000 to $50,000 per year (20)"]
["F1","Academic Administration",null,null,null,null,"S3 $15,000 to $25,000 per year",15,"S3 $15,000 to $25,000 per year (15)"]
["F2","Admissions",null,null,null,null,"S4 $5,000 to $15,000 per year",10,"S4 $5,000 to $15,000 per year (10)"]
["F3","Alumni Development",null,null,null,null,"S5 Less than $5,000 per year",5,"S5 Less than $5,000 per year (5)"]
["F4","Budget Planning",null,null,null,"Operations and Maintenance","O1 Operations Cost greater than $10,000 per year",25,"O1 Operations Cost greater than $10,000 per year (25)"]
["F5","Career Services",null,null,null,null,"O2 Operations Cost between $5,000 and $10,000 per year",15,"O2 Operations Cost between $5,000 and $10,000 per year (15)"]
["F6","Collaboration Tool",null,null,null,null,"O3 Operations Cost less than $5,000 per year",5,"O3 Operations Cost less than $5,000 per year (5)"]
["F7","Facilities & Space Management",null,null,null,"Staff Effort","E1 Greater than 1 FTE",25,"E1 Greater than 1 FTE (25)"]
["F8","IT Utility",null,null,null,null,"E2.75 to 1 FTE",20,"E2.75 to 1 FTE (20)"]
["F9","Research Administration",null,null,null,null,"E3 .5 to .75 FTE",15,"E3 .5 to .75 FTE (15)"]
["F10","SIP Awards",null,null,null,null,"E4 .25 to .5 FTE",10,"E4 .25 to .5 FTE (10)"]
["F11","Time Management",null,null,null,null,"E5 Less than .25 FTE",5,"E5 Less than .25 FTE (5)"]
["F12","Finance- Other"]
["F13","HR- Other",null,null,null,"Business Value"]
["F14","Student- Other",null,null,null,"Uniqueness","U1 There is no known commercial or internal to Cornell application that provides similar functionality (i.e. totally unique in function)",10,{"$f":"CONCATENATE(G23,\" (\",H23,\")\")","v":"U1 There is no known commercial or internal to Cornell application that provides similar functionality (i.e. totally unique in function) (10)"}]
["F15","Other",null,null,null,null,"U2 There is no known internal to Cornell application that provides similar functionality (commercial may)",10,{"$f":"CONCATENATE(G24,\" (\",H24,\")\")","v":"U2 There is no known internal to Cornell application that provides similar functionality (commercial may) (10)"}]
[null,null,null,null,null,null,"U3 There is an internal to Cornell application that would meet business needs with modifications",5,"U3 There is an internal to Cornell application that would meet business needs with modifications (5)"]
[null,null,null,null,null,null,"U4 here is an internal to Cornell application that would meet business need with business process modifications",3,"U4 here is an internal to Cornell application that would meet business need with business process modifications (3)"]
[null,null,null,null,null,null,"U5 There are other internal to Cornell applications that would meet business needs as delivered. ",0,"U5 There are other internal to Cornell applications that would meet business needs as delivered.  (0)"]
[]
[null,null,null,null,null,"Risk","R1 Application mitigates major legal/security/liability issues",20,"R1 Application mitigates major legal/security/liability issues (20)"]
[null,null,null,null,null,null,"R2 Application mitigates policy issues",15,"R2 Application mitigates policy issues (15)"]
[null,null,null,null,null,null,"R3 Application mitigates business process risk",10,"R3 Application mitigates business process risk (10)"]
[null,null,null,null,null,null,"R4 Application designed to prevent human errors",5,"R4 Application designed to prevent human errors (5)"]
[null,null,null,null,null,null,"R5 Application does not address regulatory requirements or institutional risk",0,"R5 Application does not address regulatory requirements or institutional risk (0)"]
[]
[null,null,null,null,null,"Campus Impact","C1 Required to provide data to enterprise-level business functions",15,"C1 Required to provide data to enterprise-level business functions (15)"]
[null,null,null,null,null,null,"C2 Required to provide data to unit-level business functions",10,"C2 Required to provide data to unit-level business functions (10)"]
[null,null,null,null,null,null,"C3 Required to provide data to other department-level business functions",5,"C3 Required to provide data to other department-level business functions (5)"]
[null,null,null,null,null,null,"C4 Does not provide data to other systems or business functions",0,"C4 Does not provide data to other systems or business functions (0)"]
[]
[null,null,null,null,null,"Data of Record","D1 Application IS the data of record for a given entity",15,"D1 Application IS the data of record for a given entity (15)"]
[null,null,null,null,null,null,"D2 Application EXTENDS the Data of Record (i.e. IS the Data or Record for a small # of fields)",10,"D2 Application EXTENDS the Data of Record (i.e. IS the Data or Record for a small # of fields) (10)"]
[null,null,null,null,null,null,"D3 Application SHOWS the data of record",5,"D3 Application SHOWS the data of record (5)"]
[null,null,null,null,null,null,"D4 Application captures or modifies but does NOT feed back the data of record",0,"D4 Application captures or modifies but does NOT feed back the data of record (0)"]
[]
[null,null,null,null,null,"Utility","T1 The application automates a business process that is Complex",7,"T1 The application automates a business process that is Complex (7)"]
[null,null,null,null,null,null,"T2 The application automates a business process that is moderate  ",4,"T2 The application automates a business process that is moderate   (4)"]
[null,null,null,null,null,null,"T3 The application automates a business process that is simple",0,"T3 The application automates a business process that is simple (0)"]
[null,null,null,null,null,null,"T4 The application meets business requirements fully",6,"T4 The application meets business requirements fully (6)"]
[null,null,null,null,null,null,"T5 The application meets business requirements partially ",3,"T5 The application meets business requirements partially  (3)"]
[null,null,null,null,null,null,"T6 The application meets business requirements not at all",0,"T6 The application meets business requirements not at all (0)"]
[null,null,null,null,null,null,"T7 Ease of use of the application is high ",7,"T7 Ease of use of the application is high  (7)"]
[null,null,null,null,null,null,"T8 Ease of use of the application is medium ",3,"T8 Ease of use of the application is medium  (3)"]
[null,null,null,null,null,null,"T9 Ease of use of the application is low",0,"T9 Ease of use of the application is low (0)"]
[]
[null,null,null,null,null,"Strategy","S1 Application directly supports the academic mission of an academic unit",20,"S1 Application directly supports the academic mission of an academic unit (20)"]
[null,null,null,null,null,null,"S2 Application directly supports the strategic goal of an administrative unit",20,"S2 Application directly supports the strategic goal of an administrative unit (20)"]
[null,null,null,null,null,null,"S3 Application directly supports departmental goal",10,"S3 Application directly supports departmental goal (10)"]
[null,null,null,null,null,null,"S4 Application directly supports faculty/staff goal",5,"S4 Application directly supports faculty/staff goal (5)"]