{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summer HR Form","Summer Pay Form Instructions","Data for weeks","Data Validation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Summer HR Form","index":0,"n_rows":126,"n_cols":18,"rows_kept":126,"cut":false,"hidden":false,"merged":[[64,12,65,18],[108,12,108,16],[102,12,102,16],[4,6,4,7],[10,4,10,5],[11,4,11,8],[8,0,8,3],[9,0,9,3],[10,0,10,3],[11,0,11,3],[5,6,5,7],[7,0,7,5],[8,4,8,5],[9,4,9,5],[120,7,122,10],[125,10,125,11],[114,8,114,10],[116,8,116,10],[123,7,123,11],[125,4,125,9],[113,0,113,4],[116,0,116,4],[99,0,99,11],[112,8,112,10],[88,2,88,3],[88,4,88,5],[88,6,88,7],[96,0,96,1],[96,2,96,3],[110,7,110,10],[96,4,96,5],[96,6,96,7],[88,0,88,1],[80,0,80,1],[80,2,80,3],[2,16,2,17],[54,0,54,1],[54,2,54,3],[54,6,54,7],[60,6,60,7],[63,0,63,11],[54,4,54,5],[60,0,60,1],[60,2,60,3],[60,4,60,5],[48,4,48,5],[7,6,7,7],[80,4,80,5],[80,6,80,7],[48,2,48,3],[71,6,71,7],[71,0,71,1],[71,2,71,3],[71,4,71,5],[48,6,48,7],[48,0,48,1],[42,2,42,3],[42,4,42,5],[42,6,42,7],[9,6,9,7],[10,6,10,7],[30,5,30,11],[13,0,13,3],[15,0,15,3],[17,0,17,1],[19,0,19,3],[27,0,27,2],[29,0,32,4],[31,5,32,11],[34,0,34,11],[42,0,42,1],[0,0,0,11],[1,0,1,11],[2,6,2,7],[4,0,4,3],[6,0,6,4]]}
["Colorado School of Mines Academic Faculty SUMMER PAY Form "]
["May 15- August 18, 2023"]
["Please fill out all tan fields below:"]
["Full Name (last, first)",null,null,null,null,null,"CWID",null,"Department",null,null,null,"Suffix List",null,null,null,"Summer Indexes","Field Indexes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"F1 - Field I",null,null,"AMS",233862,233864]
[null,null,null,null,null,null,"SUMMER DATES",null,"Start Date","End Date","# of Days",null,"F2 - Field II",null,null,"CBE",210804,210802]
["Please answer with \"yes\":",null,null,null,null,null,"Summer Research (SR) ",null,"2023-05-15","2023-08-18",{"$f":"NETWORKDAYS($I7,$J7)","v":70},null,"S1 - Summer I",null,null,"CEE",223284,223282]
[null,null,null,null,null,null,"Summer I and II (S 14W)",null,"2023-05-15","2023-08-18",{"$f":"NETWORKDAYS($I8,$J8)","v":70},null,"S2 6W - Summer II 6 weeks",null,null,"CH",214484,214482]
["Is this form for changes/revisions?",null,null,null,null,null,"Summer I (S1)/ Field I (F1)",null,"2023-05-15","2023-06-23",{"$f":"NETWORKDAYS($I9,$J9)","v":30},null,"S2 8W - Summer II 8 weeks",null,null,"CS",219819,219817]
["Is this form for summer research?",null,null,null,null,null,"Summer II (S2)/ Field II (F2)",null,"2023-06-26","2023-08-04",{"$f":"NETWORKDAYS($I10,$J10)","v":30},null,"S 14W - Full Summer Term",null,null,"EB",217204,217202]
["Is this form for department head duties?",null,null,null,null,null,"Summer II (S2 8W)",null,"2023-06-26","2023-08-18",{"$f":"NETWORKDAYS($I11,$J11)","v":40},null,"SR - Summer Research",null,null,"EDS",247362,247364]
["Is this form for summer teaching?",null,null,null,null,null,null,null,null,null,null,"Calculated","CE - Other Summer Assignments",null,null,"EE",219709,219707]
["Position Number",null,null,null,null,"Suffix","Start Date","End Date",null,null,"Total # of Days","Amount","OR - Other Appointment",null,null,"GE",225364,225362]
[null,null,null,null,null,null,null,null,null,null,{"$f":"NETWORKDAYS(G14,H14)","v":0},{"$f":"K14*$A$28","v":0},"WS- Workshops",null,null,"GP",230874,230872]
["Job Title",null,null,null,null,null,null,null,null,null,0,0,"XP - Extra Pay",null,null,"HASS",233062]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,"ME",221064,221062]
["% of Effort (whole number)",null,null,null,null,null,null,null,null,null,0,0,null,null,null,"MME",235984,235982]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,"MN",239844,239842]
["Acad Year Salary at 100% Effort",null,null,null,null,null,null,null,null,null,0,0,null,null,null,"PE",242054,242052]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,"PH",244524,244522]
[null,null,null,null,null,null,"Start Date","End Date","Credit Hours",null,null,null,null,null,null,"uQBE",210358,210358]
[null,null,null,null,null,"S1",null,null,null,null,{"$f":"(IF($I22=8,30,IF($I22=7,30,IF($I22=6.5,30,IF($I22=6,30,IF($I22=5.5,30,IF($I22=5,30,IF($I22=4.5,30,IF($I22=4,30,IF($I22=3.5,26.99,IF($I22=3,23.12,IF($I22=2.5,19.28,IF($I22=2,15.42,IF($I22=1.5,11.57,IF($I22=1,7.71,IF($I22=0.5,3.86,\"\"))))))))))))))))","v":""},{"$f":"IFERROR(K22*$A$28,0)","v":0},{"$f":"IFERROR(IF(AND($I22>0,$L22>0),_xlfn.IFS(AND($I22=3,$L22>15000),\"ERROR! Range for a 3 credit summer course is between $8,360 and $15,675\",AND($I22=3,$L22<8000),\"ERROR! Range for a 3 credit summer course is between $8,360 and $15,675\"),\"\"),\"\")","v":""}]
[null,null,null,null,null,"S1",null,null,null,null,{"$f":"(IF($I23=8,30,IF($I23=7,30,IF($I23=6.5,30,IF($I23=6,30,IF($I23=5.5,30,IF($I23=5,30,IF($I23=4.5,30,IF($I23=4,30,IF($I23=3.5,26.99,IF($I23=3,23.12,IF($I23=2.5,19.28,IF($I23=2,15.42,IF($I23=1.5,11.57,IF($I23=1,7.71,IF($I23=0.5,3.86,\"\"))))))))))))))))","v":""},{"$f":"IFERROR(K23*$A$28,0)","v":0},""]
[null,null,null,null,null,"S2 6W",null,null,null,null,{"$f":"(IF($I24=8,30,IF($I24=7,30,IF($I24=6.5,30,IF($I24=6,30,IF($I24=5.5,30,IF($I24=5,30,IF($I24=4.5,30,IF($I24=4,30,IF($I24=3.5,26.99,IF($I24=3,23.12,IF($I24=2.5,19.28,IF($I24=2,15.42,IF($I24=1.5,11.57,IF($I24=1,7.71,IF($I24=0.5,3.86,\"\"))))))))))))))))","v":""},0,""]
[null,null,null,null,null,"S2 6W",null,null,null,null,{"$f":"(IF($I25=8,30,IF($I25=7,30,IF($I25=6.5,30,IF($I25=6,30,IF($I25=5.5,30,IF($I25=5,30,IF($I25=4.5,30,IF($I25=4,30,IF($I25=3.5,26.99,IF($I25=3,23.12,IF($I25=2.5,19.28,IF($I25=2,15.42,IF($I25=1.5,11.57,IF($I25=1,7.71,IF($I25=0.5,3.86,\"\"))))))))))))))))","v":""},0,""]
[null,null,null,null,null,"S2 8W",null,null,null,null,{"$f":"(IF($I26=8,30,IF($I26=7,30,IF($I26=6.5,30,IF($I26=6,30,IF($I26=5.5,30,IF($I26=5,30,IF($I26=4.5,30,IF($I26=4,30,IF($I26=3.5,26.99,IF($I26=3,23.12,IF($I26=2.5,19.28,IF($I26=2,15.42,IF($I26=1.5,11.57,IF($I26=1,7.71,IF($I26=0.5,3.86,\"\"))))))))))))))))","v":""},0,""]
["Amount paid per day ",null,null,null,null,"S2 8W",null,null,null,null,{"$f":"(IF($I27=8,30,IF($I27=7,30,IF($I27=6.5,30,IF($I27=6,30,IF($I27=5.5,30,IF($I27=5,30,IF($I27=4.5,30,IF($I27=4,30,IF($I27=3.5,26.99,IF($I27=3,23.12,IF($I27=2.5,19.28,IF($I27=2,15.42,IF($I27=1.5,11.57,IF($I27=1,7.71,IF($I27=0.5,3.86,\"\"))))))))))))))))","v":""},0,""]
[{"$f":"A20*0.00541*A18/100","v":0},null,null,null,null,"S 14W",null,null,null,null,{"$f":"(IF($I28=8,30,IF($I28=7,30,IF($I28=6.5,30,IF($I28=6,30,IF($I28=5.5,30,IF($I28=5,30,IF($I28=4.5,30,IF($I28=4,30,IF($I28=3.5,26.99,IF($I28=3,23.12,IF($I28=2.5,19.28,IF($I28=2,15.42,IF($I28=1.5,11.57,IF($I28=1,7.71,IF($I28=0.5,3.86,\"\"))))))))))))))))","v":""},0,""]
["SPECIFIC Duties and/or Comments:",null,null,null,null,"S 14W",null,null,null,null,{"$f":"(IF($I29=8,30,IF($I29=7,30,IF($I29=6.5,30,IF($I29=6,30,IF($I29=5.5,30,IF($I29=5,30,IF($I29=4.5,30,IF($I29=4,30,IF($I29=3.5,26.99,IF($I29=3,23.12,IF($I29=2.5,19.28,IF($I29=2,15.42,IF($I29=1.5,11.57,IF($I29=1,7.71,IF($I29=0.5,3.86,\"\"))))))))))))))))","v":""},0,""]
[null,null,null,null,null,null,null,null,null,"Total should not to exceed 70 days",{"$f":"SUM(K14:K29)","v":0},{"$f":"SUM(L14:L29)","v":0}]
[null,null,null,null,null,"NOTE: DH's can only have 32.5 days (not 70)",null,null,null,null,null,null,{"$f":"IF(K30>70,\"ERROR! Total days should not exceed 70\",\"\")","v":""}]
[null,null,null,null,null,"Do not include the DH's 37.5 days of department summer duties to this form.  \nPay for these days are set up differently.  "]
[]
[]
["Summer Research, Field I and Field II"]
[]
["Suffix","Index","Fund","Org","Acct","Prog","Start Date","End Date","Amount to be paid ",null,"% Distribution","# of Days"]
["SR",null,null,null,5210,null,null,null,{"$f":"L38*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A38=\"SR\",$I38/SUMIFS($I$38:$I$42,$A$38:$A$42,\"SR\"),A38=\"F1\",$I38/SUMIFS($I$38:$I$42,$A$38:$A$42,\"F1\"),A38=\"F2\",$I38/SUMIFS($I$38:$I$42,$A$38:$A$42,\"F2\")),\"\")","v":""},{"$f":"NETWORKDAYS($G38,$H38)","v":0}]
["SR",null,null,null,5210,null,null,null,{"$f":"L39*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A39=\"SR\",$I39/SUMIFS($I$38:$I$42,$A$38:$A$42,\"SR\"),A39=\"F1\",$I39/SUMIFS($I$38:$I$42,$A$38:$A$42,\"F1\"),A39=\"F2\",$I39/SUMIFS($I$38:$I$42,$A$38:$A$42,\"F2\")),\"\")","v":""},{"$f":"NETWORKDAYS($G39,$H39)","v":0}]
["SR",null,null,null,5210,null,null,null,{"$f":"L40*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A40=\"SR\",$I40/SUMIFS($I$38:$I$42,$A$38:$A$42,\"SR\"),A40=\"F1\",$I40/SUMIFS($I$38:$I$42,$A$38:$A$42,\"F1\"),A40=\"F2\",$I40/SUMIFS($I$38:$I$42,$A$38:$A$42,\"F2\")),\"\")","v":""},0]
["F1",null,null,null,5210,null,null,null,{"$f":"L41*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A41=\"SR\",$I41/SUMIFS($I$38:$I$42,$A$38:$A$42,\"SR\"),A41=\"F1\",$I41/SUMIFS($I$38:$I$42,$A$38:$A$42,\"F1\"),A41=\"F2\",$I41/SUMIFS($I$38:$I$42,$A$38:$A$42,\"F2\")),\"\")","v":""},0]
["F2",null,null,null,5210,null,null,null,{"$f":"L42*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A42=\"SR\",$I42/SUMIFS($I$38:$I$42,$A$38:$A$42,\"SR\"),A42=\"F1\",$I42/SUMIFS($I$38:$I$42,$A$38:$A$42,\"F1\"),A42=\"F2\",$I42/SUMIFS($I$38:$I$42,$A$38:$A$42,\"F2\")),\"\")","v":""},0]
[null,null,null,null,null,null,"MAY TOTAL",null,{"$f":"SUM(I38:I42)","v":0},null,null,{"$f":"SUM(L38:L42)","v":0}]
["SR",null,null,null,5210,null,null,null,{"$f":"L44*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A44=\"SR\",$I44/SUMIFS($I$44:$I$48,$A$44:$A$48,\"SR\"),A44=\"F1\",$I44/SUMIFS($I$44:$I$48,$A$44:$A$48,\"F1\"),A44=\"F2\",$I44/SUMIFS($I$44:$I$48,$A$44:$A$48,\"F2\")),\"\")","v":""},0]
["SR",null,null,null,5210,null,null,null,{"$f":"L45*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A45=\"SR\",$I45/SUMIFS($I$44:$I$48,$A$44:$A$48,\"SR\"),A45=\"F1\",$I45/SUMIFS($I$44:$I$48,$A$44:$A$48,\"F1\"),A45=\"F2\",$I45/SUMIFS($I$44:$I$48,$A$44:$A$48,\"F2\")),\"\")","v":""},0]
["SR",null,null,null,5210,null,null,null,{"$f":"L46*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A46=\"SR\",$I46/SUMIFS($I$44:$I$48,$A$44:$A$48,\"SR\"),A46=\"F1\",$I46/SUMIFS($I$44:$I$48,$A$44:$A$48,\"F1\"),A46=\"F2\",$I46/SUMIFS($I$44:$I$48,$A$44:$A$48,\"F2\")),\"\")","v":""},0]
["F1",null,null,null,5210,null,null,null,{"$f":"L47*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A47=\"SR\",$I47/SUMIFS($I$44:$I$48,$A$44:$A$48,\"SR\"),A47=\"F1\",$I47/SUMIFS($I$44:$I$48,$A$44:$A$48,\"F1\"),A47=\"F2\",$I47/SUMIFS($I$44:$I$48,$A$44:$A$48,\"F2\")),\"\")","v":""},0]
["F2",null,null,null,5210,null,null,null,{"$f":"L48*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A48=\"SR\",$I48/SUMIFS($I$44:$I$48,$A$44:$A$48,\"SR\"),A48=\"F1\",$I48/SUMIFS($I$44:$I$48,$A$44:$A$48,\"F1\"),A48=\"F2\",$I48/SUMIFS($I$44:$I$48,$A$44:$A$48,\"F2\")),\"\")","v":""},0]
[null,null,null,null,null,null,"JUNE TOTAL",null,{"$f":"SUM(I44:I48)","v":0},null,null,{"$f":"SUM(L44:L48)","v":0}]
["SR",null,null,null,5210,null,null,null,{"$f":"L50*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A50=\"SR\",$I50/SUMIFS($I$50:$I$54,$A$50:$A$54,\"SR\"),A50=\"F1\",$I50/SUMIFS($I$50:$I$54,$A$50:$A$54,\"F1\"),A50=\"F2\",$I50/SUMIFS($I$50:$I$54,$A$50:$A$54,\"F2\")),\"\")","v":""},0]
["SR",null,null,null,5210,null,null,null,{"$f":"L51*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A51=\"SR\",$I51/SUMIFS($I$50:$I$54,$A$50:$A$54,\"SR\"),A51=\"F1\",$I51/SUMIFS($I$50:$I$54,$A$50:$A$54,\"F1\"),A51=\"F2\",$I51/SUMIFS($I$50:$I$54,$A$50:$A$54,\"F2\")),\"\")","v":""},0]
["SR",null,null,null,5210,null,null,null,{"$f":"L52*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A52=\"SR\",$I52/SUMIFS($I$50:$I$54,$A$50:$A$54,\"SR\"),A52=\"F1\",$I52/SUMIFS($I$50:$I$54,$A$50:$A$54,\"F1\"),A52=\"F2\",$I52/SUMIFS($I$50:$I$54,$A$50:$A$54,\"F2\")),\"\")","v":""},0]
["F1",null,null,null,5210,null,null,null,{"$f":"L53*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A53=\"SR\",$I53/SUMIFS($I$50:$I$54,$A$50:$A$54,\"SR\"),A53=\"F1\",$I53/SUMIFS($I$50:$I$54,$A$50:$A$54,\"F1\"),A53=\"F2\",$I53/SUMIFS($I$50:$I$54,$A$50:$A$54,\"F2\")),\"\")","v":""},0]
["F2",null,null,null,5210,null,null,null,{"$f":"L54*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A54=\"SR\",$I54/SUMIFS($I$50:$I$54,$A$50:$A$54,\"SR\"),A54=\"F1\",$I54/SUMIFS($I$50:$I$54,$A$50:$A$54,\"F1\"),A54=\"F2\",$I54/SUMIFS($I$50:$I$54,$A$50:$A$54,\"F2\")),\"\")","v":""},0]
[null,null,null,null,null,null,"JULY TOTAL",null,{"$f":"SUM(I50:I54)","v":0},null,null,{"$f":"SUM(L50:L54)","v":0}]
["SR",null,null,null,5210,null,null,null,{"$f":"L56*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A56=\"SR\",$I56/SUMIFS($I$56:$I$60,$A$56:$A$60,\"SR\"),A56=\"F1\",$I56/SUMIFS($I$56:$I$60,$A$56:$A$60,\"F1\"),A56=\"F2\",$I56/SUMIFS($I$56:$I$60,$A$56:$A$60,\"F2\")),\"\")","v":""},0]
["SR",null,null,null,5210,null,null,null,{"$f":"L57*$A$28","v":0},"N/A",{"$f":"IFERROR(_xlfn.IFS(A57=\"SR\",$I57/SUMIFS($I$56:$I$60,$A$56:$A$60,\"SR\"),A57=\"F1\",$I57/SUMIFS($I$56:$I$60,$A$56:$A$60,\"F1\"),A57=\"F2\",$I57/SUMIFS($I$56:$I$60,$A$56:$A$60,\"F2\")),\"\")","v":""},0]
["SR",null,null,null,5210,null,null,null,{"$f":"L58*$A$28","v":0},"N/A","",0]
["F1",null,null,null,5210,null,null,null,{"$f":"L59*$A$28","v":0},"N/A","",0]
["F2",null,null,null,5210,null,null,null,{"$f":"L60*$A$28","v":0},"N/A","",0]
[null,null,null,null,null,null,"AUG TOTAL",null,{"$f":"SUM(I56:I60)","v":0},null,null,{"$f":"SUM(L56:L60)","v":0}]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"I61+I55+I49+I43","v":0},null,null,{"$f":"L43+L49+L55+L61","v":0}]
[]
["Summer Instruction (S1 and S2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*If a faculty member is teaching above 4 credits you will need to overide formula in Column J to tie out to top section and submit an extra pay for extra work form for the overload pay."]
["Suffix","Index","Fund","Org","Acct","Prog","Start Date","End Date","Amount to be paid ","*Credit Hours","% Distribution","# of Days"]
["S1",null,null,null,5210,null,null,null,{"$f":"L67*$A$28","v":0},null,{"$f":"IFERROR(I67/$I$72,\"\")","v":""},{"$f":"NETWORKDAYS(G67,H67)*(IF($J67=8,1,IF($J67=7,1,IF($J67=6,1,IF($J67=5,1,IF($J67=4.5,1,IF($J67=4,1,IF($J67=3.5,0.8998,IF($J67=3,0.770832,IF($J67=2.5,0.6425,IF($J67=2,0.513889,IF($J67=1.5,0.3855,IF($J67=1,0.256944,IF($J67=0.5,0.1285))))))))))))))","v":0}]
["S1",null,null,null,5210,null,null,null,{"$f":"L68*$A$28","v":0},null,{"$f":"IFERROR(I68/$I$72,\"\")","v":""},{"$f":"NETWORKDAYS(G68,H68)*(IF($J68=8,1,IF($J68=7,1,IF($J68=6,1,IF($J68=5,1,IF($J68=4.5,1,IF($J68=4,1,IF($J68=3.5,0.8998,IF($J68=3,0.770832,IF($J68=2.5,0.6425,IF($J68=2,0.513889,IF($J68=1.5,0.3855,IF($J68=1,0.256944,IF($J68=0.5,0.1285))))))))))))))","v":0}]
["S1",null,null,null,5210,null,null,null,{"$f":"L69*$A$28","v":0},null,"",{"$f":"NETWORKDAYS(G69,H69)*(IF($J69=8,1,IF($J69=7,1,IF($J69=6,1,IF($J69=5,1,IF($J69=4.5,1,IF($J69=4,1,IF($J69=3.5,0.8998,IF($J69=3,0.770832,IF($J69=2.5,0.6425,IF($J69=2,0.513889,IF($J69=1.5,0.3855,IF($J69=1,0.256944,IF($J69=0.5,0.1285))))))))))))))","v":0}]
["S 14W",null,null,null,5210,null,null,null,{"$f":"L70*$A$28","v":0},null,"",{"$f":"NETWORKDAYS(G70,H70)*(IF($J70=8,0.4615,IF($J70=7,0.4615,IF($J70=6,0.4615,IF($J70=5,0.4615,IF($J70=4.5,0.4615,IF($J70=4,0.42858,IF($J70=3.5,0.385417,IF($J70=3,0.33035714,IF($J70=2.5,0.275298,IF($J70=2,0.2203,IF($J70=1.5,0.165179,IF($J70=1,0.11009,IF(J$70=0.5,0.055059))))))))))))))","v":0}]
["S 14W",null,null,null,5210,null,null,null,{"$f":"L71*$A$28","v":0},null,"",{"$f":"NETWORKDAYS(G71,H71)*(IF($J71=8,0.4615,IF($J71=7,0.4615,IF($J71=6,0.4615,IF($J71=5,0.4615,IF($J71=4.5,0.4615,IF($J71=4,0.42858,IF($J71=3.5,0.385417,IF($J71=3,0.33035714,IF($J71=2.5,0.275298,IF($J71=2,0.2203,IF($J71=1.5,0.165179,IF($J71=1,0.11009,IF(J$70=0.5,0.055059))))))))))))))","v":0}]
[null,null,null,null,null,null,"MAY TOTAL",null,{"$f":"SUM(I67:I71)","v":0},null,null,{"$f":"SUM(L67:L71)","v":0}]
["S1",null,null,null,5210,null,null,null,{"$f":"L73*$A$28","v":0},null,{"$f":"IFERROR(I73/$I$81,\"\")","v":""},{"$f":"NETWORKDAYS(G73,H73)*(IF($J73=8,1,IF($J73=7,1,IF($J73=6,1,IF($J73=5,1,IF($J73=4.5,1,IF($J73=4,1,IF($J73=3.5,0.8998,IF($J73=3,0.770832,IF($J73=2.5,0.6425,IF($J73=2,0.513889,IF($J73=1.5,0.3855,IF($J73=1,0.256944,IF($J73=0.5,0.1285))))))))))))))","v":0}]
["S1",null,null,null,5210,null,null,null,0,null,{"$f":"IFERROR(I74/$I$81,\"\")","v":""},{"$f":"NETWORKDAYS(G74,H74)*(IF($J74=8,1,IF($J74=7,1,IF($J74=6,1,IF($J74=5,1,IF($J74=4.5,1,IF($J74=4,1,IF($J74=3.5,0.8998,IF($J74=3,0.770832,IF($J74=2.5,0.6425,IF($J74=2,0.513889,IF($J74=1.5,0.3855,IF($J74=1,0.256944,IF($J74=0.5,0.1285))))))))))))))","v":0}]
["S2 6W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G75,H75)*(IF($J75=8,1,IF($J75=7,1,IF($J75=6,1,IF($J75=5,1,IF($J75=4.5,1,IF($J75=4,1,IF($J75=3.5,0.8998,IF($J75=3,0.770832,IF($J75=2.5,0.6425,IF($J75=2,0.513889,IF($J75=1.5,0.3855,IF($J75=1,0.256944,IF($J75=0.5,0.1285))))))))))))))","v":0}]
["S2 6W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G76,H76)*(IF($J76=8,1,IF($J76=7,1,IF($J76=6,1,IF($J76=5,1,IF($J76=4.5,1,IF($J76=4,1,IF($J76=3.5,0.8998,IF($J76=3,0.770832,IF($J76=2.5,0.6425,IF($J76=2,0.513889,IF($J76=1.5,0.3855,IF($J76=1,0.256944,IF($J76=0.5,0.1285))))))))))))))","v":0}]
["S2 8W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G77,H77)*(IF($J77=8,1,IF($J77=7,1,IF($J77=6,1,IF($J77=5,1,IF($J77=4.5,0.867186,IF($J77=4,0.75,IF($J77=3.5,0.674479,IF($J77=3,0.578124,IF($J77=2.5,0.482,IF($J77=2,0.385416,IF($J77=1.5,0.2892,IF($J77=1,0.192708,IF($J77=0.5,0.0964))))))))))))))","v":0}]
["S2 8W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G78,H78)*(IF($J78=8,1,IF($J78=7,1,IF($J78=6,1,IF($J78=5,1,IF($J78=4.5,0.867186,IF($J78=4,0.75,IF($J78=3.5,0.674479,IF($J78=3,0.578124,IF($J78=2.5,0.482,IF($J78=2,0.385416,IF($J78=1.5,0.2892,IF($J78=1,0.192708,IF($J78=0.5,0.0964))))))))))))))","v":0}]
["S 14W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G79,H79)*(IF($J79=8,0.4615,IF($J79=7,0.4615,IF($J79=6,0.4615,IF($J79=5,0.4615,IF($J79=4.5,0.4615,IF($J79=4,0.42858,IF($J79=3.5,0.385417,IF($J79=3,0.33035714,IF($J79=2.5,0.275298,IF($J79=2,0.2203,IF($J79=1.5,0.165179,IF($J79=1,0.11009,IF(J$70=0.5,0.055059))))))))))))))","v":0}]
["S 14W",null,null,null,5210,null,null,null,{"$f":"L80*$A$28","v":0},null,"",{"$f":"NETWORKDAYS(G80,H80)*(IF($J80=8,0.4615,IF($J80=7,0.4615,IF($J80=6,0.4615,IF($J80=5,0.4615,IF($J80=4.5,0.4615,IF($J80=4,0.42858,IF($J80=3.5,0.385417,IF($J80=3,0.33035714,IF($J80=2.5,0.275298,IF($J80=2,0.2203,IF($J80=1.5,0.165179,IF($J80=1,0.11009,IF(J$70=0.5,0.055059))))))))))))))","v":0}]
[null,null,null,null,null,null,"JUNE TOTAL",null,{"$f":"SUM(I73:I80)","v":0},null,null,{"$f":"SUM(L73:L80)","v":0}]
["S2 6W",null,null,null,5210,null,null,null,{"$f":"L82*$A$28","v":0},null,{"$f":"IFERROR(I82/$I$89,\"\")","v":""},{"$f":"NETWORKDAYS(G82,H82)*(IF($J82=8,1,IF($J82=7,1,IF($J82=6,1,IF($J82=5,1,IF($J82=4.5,1,IF($J82=4,1,IF($J82=3.5,0.8998,IF($J82=3,0.770832,IF($J82=2.5,0.6425,IF($J82=2,0.513889,IF($J82=1.5,0.3855,IF($J82=1,0.256944,IF($J82=0.5,0.1285))))))))))))))","v":0}]
["S2 6W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G83,H83)*(IF($J83=8,1,IF($J83=7,1,IF($J83=6,1,IF($J83=5,1,IF($J83=4.5,1,IF($J83=4,1,IF($J83=3.5,0.8998,IF($J83=3,0.770832,IF($J83=2.5,0.6425,IF($J83=2,0.513889,IF($J83=1.5,0.3855,IF($J83=1,0.256944,IF($J83=0.5,0.1285))))))))))))))","v":0}]
["S2 6W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G84,H84)*(IF($J84=8,1,IF($J84=7,1,IF($J84=6,1,IF($J84=5,1,IF($J84=4.5,1,IF($J84=4,1,IF($J84=3.5,0.8998,IF($J84=3,0.770832,IF($J84=2.5,0.6425,IF($J84=2,0.513889,IF($J84=1.5,0.3855,IF($J84=1,0.256944,IF($J84=0.5,0.1285))))))))))))))","v":0}]
["S2 8W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G85,H85)*(IF($J85=8,1,IF($J85=7,1,IF($J85=6,1,IF($J85=5,1,IF($J85=4.5,0.867186,IF($J85=4,0.75,IF($J85=3.5,0.674479,IF($J85=3,0.578124,IF($J85=2.5,0.482,IF($J85=2,0.385416,IF($J85=1.5,0.2892,IF($J85=1,0.192708,IF($J85=0.5,0.0964))))))))))))))","v":0}]
["S2 8W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G86,H86)*(IF($J86=8,1,IF($J86=7,1,IF($J86=6,1,IF($J86=5,1,IF($J86=4.5,0.867186,IF($J86=4,0.75,IF($J86=3.5,0.674479,IF($J86=3,0.578124,IF($J86=2.5,0.482,IF($J86=2,0.385416,IF($J86=1.5,0.2892,IF($J86=1,0.192708,IF($J86=0.5,0.0964))))))))))))))","v":0}]
["S 14W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G87,H87)*(IF($J87=8,0.4615,IF($J87=7,0.4615,IF($J87=6,0.4615,IF($J87=5,0.4615,IF($J87=4.5,0.4615,IF($J87=4,0.42858,IF($J87=3.5,0.385417,IF($J87=3,0.33035714,IF($J87=2.5,0.275298,IF($J87=2,0.2203,IF($J87=1.5,0.165179,IF($J87=1,0.11009,IF(J$70=0.5,0.055059))))))))))))))","v":0}]
["S 14W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G88,H88)*(IF($J88=8,0.4615,IF($J88=7,0.4615,IF($J88=6,0.4615,IF($J88=5,0.4615,IF($J88=4.5,0.4615,IF($J88=4,0.42858,IF($J88=3.5,0.385417,IF($J88=3,0.33035714,IF($J88=2.5,0.275298,IF($J88=2,0.2203,IF($J88=1.5,0.165179,IF($J88=1,0.11009,IF(J$70=0.5,0.055059))))))))))))))","v":0}]
[null,null,null,null,null,null,"JULY TOTAL",null,{"$f":"SUM(I82:I88)","v":0},null,null,{"$f":"SUM(L82:L88)","v":0}]
["S2 6W",null,null,null,5210,null,null,null,{"$f":"L90*$A$28","v":0},null,{"$f":"IFERROR(I90/$I$97,\"\")","v":""},{"$f":"NETWORKDAYS(G90,H90)*(IF($J90=8,1,IF($J90=7,1,IF($J90=6,1,IF($J90=5,1,IF($J90=4.5,1,IF($J90=4,1,IF($J90=3.5,0.8998,IF($J90=3,0.770832,IF($J90=2.5,0.6425,IF($J90=2,0.513889,IF($J90=1.5,0.3855,IF($J90=1,0.256944,IF($J90=0.5,0.1285))))))))))))))","v":0}]
["S2 6W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G91,H91)*(IF($J91=8,1,IF($J91=7,1,IF($J91=6,1,IF($J91=5,1,IF($J91=4.5,1,IF($J91=4,1,IF($J91=3.5,0.8998,IF($J91=3,0.770832,IF($J91=2.5,0.6425,IF($J91=2,0.513889,IF($J91=1.5,0.3855,IF($J91=1,0.256944,IF($J91=0.5,0.1285))))))))))))))","v":0}]
["S2 6W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G92,H92)*(IF($J92=8,1,IF($J92=7,1,IF($J92=6,1,IF($J92=5,1,IF($J92=4.5,1,IF($J92=4,1,IF($J92=3.5,0.8998,IF($J92=3,0.770832,IF($J92=2.5,0.6425,IF($J92=2,0.513889,IF($J92=1.5,0.3855,IF($J92=1,0.256944,IF($J92=0.5,0.1285))))))))))))))","v":0}]
["S2 8W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G93,H93)*(IF($J93=8,1,IF($J93=7,1,IF($J93=6,1,IF($J93=5,1,IF($J93=4.5,0.867186,IF($J93=4,0.75,IF($J93=3.5,0.674479,IF($J93=3,0.578124,IF($J93=2.5,0.482,IF($J93=2,0.385416,IF($J93=1.5,0.2892,IF($J93=1,0.192708,IF($J93=0.5,0.0964))))))))))))))","v":0}]
["S2 8W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G94,H94)*(IF($J94=8,1,IF($J94=7,1,IF($J94=6,1,IF($J94=5,1,IF($J94=4.5,0.867186,IF($J94=4,0.75,IF($J94=3.5,0.674479,IF($J94=3,0.578124,IF($J94=2.5,0.482,IF($J94=2,0.385416,IF($J94=1.5,0.2892,IF($J94=1,0.192708,IF($J94=0.5,0.0964))))))))))))))","v":0}]
["S 14W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G95,H95)*(IF($J95=8,0.4615,IF($J95=7,0.4615,IF($J95=6,0.4615,IF($J95=5,0.4615,IF($J95=4.5,0.4615,IF($J95=4,0.42858,IF($J95=3.5,0.385417,IF($J95=3,0.33035714,IF($J95=2.5,0.275298,IF($J95=2,0.2203,IF($J95=1.5,0.165179,IF($J95=1,0.11009,IF(J$70=0.5,0.055059))))))))))))))","v":0}]
["S 14W",null,null,null,5210,null,null,null,0,null,"",{"$f":"NETWORKDAYS(G96,H96)*(IF($J96=8,0.4615,IF($J96=7,0.4615,IF($J96=6,0.4615,IF($J96=5,0.4615,IF($J96=4.5,0.4615,IF($J96=4,0.42858,IF($J96=3.5,0.385417,IF($J96=3,0.33035714,IF($J96=2.5,0.275298,IF($J96=2,0.2203,IF($J96=1.5,0.165179,IF($J96=1,0.11009,IF(J$70=0.5,0.055059))))))))))))))","v":0}]
[null,null,null,null,null,null,"AUG TOTAL",null,{"$f":"SUM(I90:I96)","v":0},null,null,{"$f":"SUM(L90:L96)","v":0}]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"I97+I89+I81+I72","v":0},null,null,{"$f":"L72+L81+L89+L97","v":0}]
[]
["Other Summer Assignments CE (short course), WS(workshops), XP (extra pay) OR (other appointment)"]
[]
["Suffix","Month","Index","Fund","Org","Acct","Start Date","End Date","Amount to be paid ","Credits","% Distribution","# of Days"]
["XP",null,null,null,null,null,null,null,{"$f":"$A$28*L103","v":0},"N/A",null,{"$f":"NETWORKDAYS(G103,H103)","v":0},"Please include the month in Column B for this section"]
[null,null,null,null,null,null,null,null,{"$f":"$A$28*L104","v":0},"N/A",null,{"$f":"NETWORKDAYS(G104,H104)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"$A$28*L105","v":0},"N/A",null,{"$f":"NETWORKDAYS(G105,H105)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"$A$28*L106","v":0},"N/A",null,{"$f":"NETWORKDAYS(G106,H106)","v":0}]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(I103:I106)","v":0},null,null,{"$f":"SUM(L103:L106)","v":0}]
[]
[null,null,null,null,null,null,null,"Total amount of this HR form:",{"$f":"SUM(I107,I98,I62)","v":0},null,null,{"$f":"SUM(L107,L98,L62)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I109-L30","v":0},{"$f":"K30-L109","v":0}]
["                            Date/Name/Phone Number of Person Preparing this form:"]
[]
["Vice Provost/Dean APPROVAL",null,null,null,null,null,"Forwarded to Fund Manager:"]
[null,null,null,null,null,null," ",null,"(Please type Name and Date)"]
["(Please type Name and Date)",null,null,null,null,null,"Forwarded to DH:"]
[null,null,null,null,null,null,null,null,"(Please type Name and Date)"]
[null,null,null,null,null,null,"Forwarded to Employee:"]
[null,null,null,null,null,null,null,null,"(Please type Name and Date)"]
[]
[null,null,null,null,null,null,null,"Budget Office Approval"]
[]
[]
[]
[]
[]
[null,null,null,null,"PLEASE SUBMIT SUMMER PAY FORM TO BUDGET@MINES.EDU"]

{"sheet":"Summer Pay Form Instructions","index":1,"n_rows":107,"n_cols":10,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
[null,null,"Instructions"]
[]
[null,"Step 1","Input: Full Name, CWID, Department, Position Number, Job Title, % of Effort and Salary at 100% effort. These fields are required."]
[]
[null,"Step 2","Please answer the questions in Column F, Line 9-12"]
[]
[null,"Step 3","For Summer Research, Field Session, or other duties: In the top section (Column F, Lines 14-20) select the suffix from the drop-down and enter date-range in Columns G and H. Note that Columns K and L have formulas so no further action is needed on this step.",null,null,null,null,0,null,0]
[null,null,"For Summer Instruction: In the top section (Column F, Lines 22-29) enter date-range in Columns G and H and credit hours in Column I. Note that Columns K and L have formulas so no further action is needed on this step."]
[]
[null,"Step 4","Scroll down and you will notice that there are three sections, Summer Research, Field I and Field II (Starts on line 35), Summer Instructions (S1 and S2) starting on (line 64) and Other Summer Assignments CA (Athletic camps), CE (short course), WS(workshop), XP (Extra Pay) OR (other appointment) (Line 100)"]
[]
[null,"Step 5","If you completed any fields in top section (Columns G and H, Lines 14-20) then the *Summer Research, Field I and Field II section will need to be completed.  \n       *If you used codes CE,OR,WS,CA or XP in this same top section, then the Other Summer Assignments section starting on line 100 must be completed.\nIf you completed any fields in in (Columns G and H, Lines 22-29) then the Summer Instruction (S1 and S2) section will need to be completed.  "]
[]
[null,"Step 6","For the Summer Research, Field I and Field II section beginning on line 38, the suffix fields are pre-populated, but can be changed by using the dropdown. Do not leave the suffix field blank. If left blank, % of distribution will not calculate. For the Summer Instruction section beginning on line 61, the suffix fields are pre-populated and cannot be changed."]
[]
[null,"Step 7","Verify that the top and bottom section tie out. You will receive a pop up message if they do not tie."]
[]
[null,"Step 8","Lastly, we need approval from the person who prepared form (Cell H111), Fund Manager (Cell I113), **DH (Cell I115) and Employee (Cell I117) This is required\n**If this is a DH form, the Dean must sign in place of the DH"]
[]
[null,"Step 9","Submit to Budget@mines.edu"]
[]
[null,null,"REVISIONS"]
[null,null,"For revisions, start with the most recent submitted contract and add in your new changes. Do not use a separate summer contract forms for your revision."]
[]
[null,null,"IMPORTANT NOTE"]
[null,null,"For Summer Teaching, there is a min and max for faculty pay for a 3 credit course. Min=$8,360  Max=$15,675"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Data for weeks","index":2,"n_rows":30,"n_cols":27,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,7,0]]}
[null,"SCH","8","7","6.5","6","5.5","5","4.5","4","3.5","3","2.5","2","1.5","1","0.5","Days","Column1"]
["Weeks","2 weeks",{"$f":"(128/R2)/$V$10","v":6.166666666666667},{"$f":"(112/R2)/$V$10","v":5.395833333333333},{"$f":"(104/$R2)/$V$10","v":5.010416666666667},{"$f":"(96/R2)/$V$10","v":4.625},{"$f":"(88/R2)/$V$10","v":4.239583333333333},{"$f":"(80/R2)/$V$10","v":3.8541666666666665},{"$f":"(72/R2)/$V$10","v":3.46875},{"$f":"(64/R2)/2.0757","v":3.0832972009442603},{"$f":"(56/R2)/$V$10","v":2.6979166666666665},{"$f":"(48/R2)/2.0757","v":2.3124729007081948},{"$f":"(40/R2)/$V$10","v":1.9270833333333333},{"$f":"(32/R2)/$V$10","v":1.5416666666666667},{"$f":"(24/R2)/$V$10","v":1.15625},{"$f":"(16/R2)/$V$10","v":0.77083333333333337},{"$f":"(8/R2)/$V$10","v":0.38541666666666669},10]
[null,"3 Weeks",4.1111111111111107,3.5972222222222219,3.3402777777777777,3.0833333333333335,2.8263888888888884,2.5694444444444442,2.3125,{"$f":"(64/R3)/2.0757","v":2.0555314672961731},1.7986111111111109,{"$f":"(48/R3)/2.0757","v":1.5416486004721301},1.2847222222222221,1.0277777777777777,0.77083333333333337,0.51388888888888884,0.25694444444444442,15]
[null,"4 weeks",3.0833333333333335,2.6979166666666665,2.5052083333333335,2.3125,2.1197916666666665,1.9270833333333333,1.734375,{"$f":"(64/R4)/2.0757","v":1.5416486004721301},1.3489583333333333,{"$f":"(48/R4)/2.0757","v":1.1562364503540974},0.96354166666666663,0.77083333333333337,0.578125,0.38541666666666669,0.19270833333333334,20]
[null,"5 Weeks",2.4666666666666668,2.1583333333333332,2.0041666666666664,1.8499999999999999,1.6958333333333333,1.5416666666666667,1.3875,{"$f":"(64/R5)/2.0757","v":1.233318880377704},1.0791666666666666,{"$f":"(48/R5)/2.0757","v":0.92498916028327793},0.77083333333333337,0.6166666666666667,0.46249999999999997,0.30833333333333335,0.15416666666666667,25,null,null,null,null,{"$f":"5*16","v":80}]
[null,"6 weeks",2.0555555555555554,1.7986111111111109,1.6701388888888888,1.5416666666666667,1.4131944444444442,1.2847222222222221,1.15625,{"$f":"(64/R6)/2.0757","v":1.0277657336480865},0.89930555555555547,{"$f":"(48/R6)/2.0757","v":0.77082430023606507},0.64236111111111105,0.51388888888888884,0.38541666666666669,0.25694444444444442,0.12847222222222221,30]
[null,"7 weeks",1.7619047619047619,1.5416666666666667,1.4315476190476191,1.3214285714285714,1.2113095238095237,1.1011904761904761,0.99107142857142838,{"$f":"(64/R7)/V10","v":0.88095238095238093},0.77083333333333337,{"$f":"(48/R7)/V10","v":0.6607142857142857},0.55059523809523803,0.44047619047619047,0.33035714285714285,0.22023809523809523,0.11011904761904762,35]
[null,"8 weeks",1.5416666666666667,1.3489583333333333,1.2526041666666667,1.15625,1.0598958333333333,0.96354166666666663,0.8671875,{"$f":"(64/R8)/2.0757","v":0.77082430023606507},0.67447916666666663,{"$f":"(48/R8)/2.0757","v":0.57811822517704869},0.48177083333333331,0.38541666666666669,0.2890625,0.19270833333333334,9.6354166666666671E-2,40,null,null,null,{"$f":"16/30","v":0.53333333333333333}]
[null,"14 Weeks",{"$f":"(128/$R$9)/$V$10","v":0.88095238095238093},{"$f":"(112/$R$9)/$V$10","v":0.77083333333333337},{"$f":"(104/$R9)/$V$10","v":0.71577380952380953},{"$f":"(96/$R$9)/$V$10","v":0.6607142857142857},{"$f":"(88/R9)/$V$10","v":0.60565476190476186},{"$f":"(80/$R$9)/$V$10","v":0.55059523809523803},{"$f":"(72/R9)/$V$10","v":0.49553571428571419},{"$f":"(64/R9)/$V$10","v":0.44047619047619047},{"$f":"(56/R9)/$V$10","v":0.38541666666666669},{"$f":"(48/R9)/V10","v":0.33035714285714285},{"$f":"(40/R9)/$W$10","v":0.29659025018870555},{"$f":"(32/R9)/$W$10","v":0.23727220015096442},{"$f":"(24/R9)/$W$10","v":0.17795415011322332},{"$f":"(16/R9)/$W$10","v":0.11863610007548221},{"$f":"(8/R9)/$W$10","v":5.9318050037741106E-2},70,"There is an issue with these"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"16*24/185","v":2.0756756756756758},1.92666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"32/30","v":1.0666666666666667}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V11/V10","v":0.51388888888888884}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,0.35590830000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136]

{"sheet":"Data Validation","index":3,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
["SR","S1","S2 8W","Yes","CE","May","Yes, teaching on campus class"]
["F1","S2 6W",null,"No","OR","June","Yes, teaching graduate online class"]
["F2","S2 8W",null,null,"WS","July","Yes, teaching undergraduate online class"]
["XP",null,null,null,"XP","August","Yes, teaching abroad class"]
["CE",null,null,null,null,null,"Yes, teaching course to free up faculty to teach online course"]
["OR",null,null,null,null,null,"No"]
["WS"]