{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Student Technology Fee","Detail Analysis","Breakout","Salaries","Spring 2018 Attendance"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Student Technology Fee","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,0,24,12],[25,0,25,12],[3,4,3,6],[3,10,3,12],[22,0,22,12],[23,0,23,12],[26,0,26,12],[27,0,27,12],[28,0,28,12],[29,0,29,12],[30,0,30,12],[36,0,36,12],[31,0,31,12],[32,0,32,12],[33,0,33,12],[34,0,34,12],[35,0,35,12]]}
["Student Technology Fee (102-6-590310)",{"$nulls":5}," "]
["2019-2020 Budget (FY20)"]
[]
["Category","FY 20 Actual","FY21 Estimate",null,"FY20 Range",{"$nulls":5},"FY21 Range"]
["Permanent Positions",152777.90111999999,{"$f":"'Detail Analysis'!C5","v":158950.1292},null,135000,"to",159000,null,null,null,135000,"to",159000]
["Student Help",75075,{"$f":"'Detail Analysis'!C6","v":78454},null,70000,"to",80000,null,null,null,70000,"to",80000]
["Fringe Benefits",1085.9940000000001,{"$f":"'Detail Analysis'!C7","v":1085.9940000000001},null,1000,"to",3000,null,null,null,1000,"to",3000]
["Software Licenses/Fees",119495.4,{"$f":"'Detail Analysis'!C21","v":111749.4},null,100000,"to",160000,null,null,null,100000,"to",160000]
["Mobile Printers",28000,{"$f":"'Detail Analysis'!C22","v":28000},null,20000,"to",30000,null,null,null,20000,"to",30000]
["Internet Access (WiscNet, etc...)",46067.51,{"$f":"'Detail Analysis'!C23","v":34650},null,35000,"to",90000,null,null,null,35000,"to",90000]
["Equipment Rotations- GA Labs",100000,{"$f":"'Detail Analysis'!C27","v":100000},null,75000,"to ",100000,null,null,null,75000,"to ",100000]
["Equipment Checkout",60350,{"$f":"'Detail Analysis'!C24","v":60350},null,60000,"to",70000,null,null,null,60000,"to",70000]
["Back Office",400000,{"$f":"'Detail Analysis'!C25","v":400000},null,400000,"to",500000,null,null,null,400000,"to",500000]
["Library Public Stations",28000,{"$f":"'Detail Analysis'!C26","v":28000},null,25000,"to",30000,null,null,null,25000,"to",30000]
["Innovative Programs",78000,90000,null,50000,"to",100000,null,null,null,50000,"to",100000]
[]
[]
["Budgeted:",{"$f":"SUM(B5:B15)","v":1088851.8051200002},{"$f":"'Detail Analysis'!C34","v":1104239.5231999999}]
["Contingency:",{"$f":"B20-B18","v":1405.1948799998499},{"$f":"C20-C18","v":-3079.9531999998726}]
["GRAND TOTAL:",1090257,1101159.57]
[]
[" Notes on changes:"]
["5 year plan to end funding for Canvas (-$6,000/year) Suspended due to COVID"]
["Internet access was artificially kept low for this year due to a grant"]
["Innovation Labs has it's own line item now, monies used on that line taken from Other Projects"]
["Student pay increased by 4% - LTS initiative"]
["Due to COVID-19, we expect a large carryover into next year. This should cover well past the negative contingency."]

{"sheet":"Detail Analysis","index":1,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Student Technology Fee (102-6-590310)",null,"FY21 Est."]
["Budget (FY20)",{"$f":"1101159.57","v":1101159.57},{"$f":"B2*1.01","v":1112171.1657}]
[null,null,null,"% change"]
["SALARIES"]
["Full Time Staff",155833.46,{"$f":"B5*1.02","v":158950.1292},{"$f":"(C5-B5)/C5","v":1.9607843137254926E-2}]
["Student Staff",75075,78454,{"$f":"(C6-B6)/C6","v":4.3069824355673386E-2}]
["Fringe Benefits",1064.7,{"$f":"B7*1.02","v":1085.9940000000001},{"$f":"(C7-B7)/C7","v":1.9607843137254988E-2}]
["Salaries Total",{"$f":"SUM(B5:B7)","v":231973.16},{"$f":"SUM(C5:C7)","v":238490.1232},{"$f":"(C8-B8)/C8","v":2.7325924916961081E-2}]
[]
[]
["SERVICES AND SUPPLIES"]
["Estimated Raises","2% FY10",null,{"$f":"(C12-B12)/C12","v":{"$error":"#VALUE!"}}]
["   Unclassified",0.02,null,{"$error":"#DIV/0!"}]
["   Classified/LTE",0.02,null,{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"}]
["Fringes",null,null,{"$error":"#DIV/0!"}]
["  Unclassified/Classified",0.219,null,{"$error":"#DIV/0!"}]
["  LTE",0.1358,null,{"$error":"#DIV/0!"}]
["  Student Help",1.4E-2,null,{"$error":"#DIV/0!"}]
[null,null,null,{"$error":"#DIV/0!"}]
["Software Licenses and Fees",119495,{"$f":"Breakout!B9","v":111749.4},-6.9312228969462084E-2]
["Mobile Printers",28000,{"$f":"B22","v":28000},0]
["Internet Access",42592,34650,-0.22920634920634922]
["Checkout Pool Equipment",60350,{"$f":"B24","v":60350},0]
["Back Office Rotation",400000,{"$f":"B25","v":400000},0]
["Library Public Access Machines",28000,{"$f":"B26","v":28000},0]
["Standup Labs and Group Rooms Rotation",100000,{"$f":"B27","v":100000},0]
["Innovation Labs",0,30000,1]
["Open Eau Claire",16000,16000,0]
["Students with Disabilities",7000,9000,0.22222222222222221]
["Other Innovative Projects",60000,48000,-0.25]
["S&S total",{"$f":"SUM(B21:B31)","v":861437},{"$f":"SUM(C21:C31)","v":865749.4},4.9811180926028053E-3]
[]
["Salary and S&S total",{"$f":"SUM(B32,B8)","v":1093410.1599999999},{"$f":"SUM(C32,C8)","v":1104239.5231999999}]
["Contingency",{"$f":"B2-B34","v":7749.410000000149},{"$f":"C2-C34","v":7931.6425000000745},{"$f":"C35/C2","v":7.1316742823555419E-3}]

{"sheet":"Breakout","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,3,10,4],[9,0,9,4],[0,0,0,4],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4]]}
["Software License and Fees"]
["Title","Amount","% of total","Description"]
["Software licenses-Canvas",30984,0.4,"*5 year plan to end funding for Canvas (-$6,000/year)"]
["MS license",33345.4,0.4,"Microsoft License and Fees"]
["Access fee labs",14550,1]
["Library Software Support",10890,1,"LTS Software Support Fee - frozen since FY15"]
["JSTOR Maintenance",3180,0.03]
["DUO",18800,0.4,"2 Factor Authentication "]
["Total:",{"$f":"SUM(B3:B8)","v":111749.4}]
["Internet Access"]
["SysNet, Level 3, CESA",{"$f":"77000*0.45","v":34650},0.45,"Artificially low due to grant"]

{"sheet":"Salaries","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["SALARIES"]
["Staff","% of salary covered","Base","Unclass","Class"]
["   Lab support-info process cons",0.4,63251,{"$f":"(C3*0.4)","v":25300.400000000001}]
["   Help Desk coord--IS spec",1,61721,null,61721]
["   BITS/OL1108--IS spec",1,57000,null,57000]
[null,null,null,{"$f":"SUM(D3:D5)","v":25300.400000000001},{"$f":"SUM(E3:E5)","v":118721}]
[null,null,null,"Total Staff Salaries",{"$f":"E6+D6","v":144021.4}]
[]
["Student Employees",null,null,null,"Non-fed"]
["Library laptop checkout",null,null,null,16800]
["LTS GA lab support",null,null,null,25200]
["LTS Helpdesk/Training",null,null,null,26250]
[null,null,null,"Total Student Salaries",{"$f":"SUM(E10:E12)","v":68250}]
["Subtotals"]
[null,null,null,"Total Staff Salaries",{"$f":"E7","v":144021.4}]
[null,null,null,"Total Student Salaries",68250]
[null,null,null,"Fringe Calc Amt",{"$f":"(E13*0.015)","v":1023.75}]
[null,null,null,"Total Labor Salaries",{"$f":"SUM(E15:E17)","v":213295.15}]

{"sheet":"Spring 2018 Attendance","index":4,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Last","First","Count","2018-02-07","2018-02-21","2018-02-28","2018-03-28"]
["Markgraf","Jill",{"$f":"COUNTIF(D2:U2,\"*\")","v":4},"x","x","x","x"]
["Stombough","Angie",{"$f":"COUNTIF(D3:U3,\"*\")","v":3},null,"x","x","x"]
["Jonathan","Butz",0]
["Haideman","Kristina",4,"x","x","x","x"]
["Gerberich","Kent",3,"x",null,"x","x"]
["Miller","David",4,"x","x","x","x"]
["Romero","Quinn",0]
["Sunny","Chen",4,"x","x","x","x"]
["Brower","Sarah",3,"x","x","x"]
["VandenHeuvel","Bryce",4,"x","x","x","x"]
["Akey","Andrew",0]
["Hillis","Dan",3,"x","x","x"]
["Andrashko","Corrisa",3,null,"x","x","x"]
["Ernst","Craig",4,"x","x","x","x"]
["Mumm","Mike",2,"x","x"]
["Moldenhauer","Zach",0]
["Xiong","David",3,"x","x","x"]
["Yang","Seng",3,"x","x","x"]
["Vue","Justin",3,"x",null,"x","x"]
["Mey","Craig",4,"x","x","x","x"]