{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INSTRUCTIONS","Worksheet","DO NOT EDIT"],"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,"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":"INSTRUCTIONS","index":0,"n_rows":59,"n_cols":3,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Welcome to the CNR Instructions to fill out the graduate student RA and TA stipends"]
[]
[]
[null,"Step 1","Select appointment dates"]
[null,"The appointment type allows you to choose between different start and end dates of the appointment."]
[null,"Sometimes we want students to start in the summer prior to the fall and sometimes we want them to start in the fall but pay them through the following summer."]
[null,"Please note the maximum duration for an appointment is 52 weeks. "]
[]
[null,"Your different options are:"]
[null,"1 Year Appointment from January to January"]
[null,"1 Year Appointment from May to May"]
[null,"1 Year Appointment from August to August"]
[null,"1 Year Appointment from December to December"]
[]
[null,"For Teaching Assistants ONLY - you can also select by spring or fall semesters"]
[]
[null,"Please note: Given all new students are required to attend orientation events, we are required to start their appointments the week prior"]
[null,"to the start of the semester - please make sure that your students are aware that they are expected to be in campus for those events. "]
[]
[null,"Is this student in their last semester? If so, select Yes, to let fiscal know that a 19.5hr RA may be needed. "]
[]
[null,"Step 2","Identify if the student starting in May is new to the student health insurance"]
[null,"This question is asked to help determine if the student needs the student health insurance program (SHIP) for the summer. "]
[null,"In general if a graduate student had SHIP coverage during the prior spring semester that coverage extends over to the next summer. "]
[null,"Answering no to this question overrides the summer SHIP question later, helping reduce a possible error."]
[]
[null,"Step 3","Enter the hours per week"]
[null,"The maximum number of hours a student can earn on an appointment during the semester is 20. "]
[null,"If you plan to pay your student extra hours in the summer, please enter these in the appropriate box (up to 40). "]
[]
[null,"Step 4","Identify graduate student rate of pay and whether the student is an Idaho resident "]
[null,"The College of Natural Resources has set minimum rates for Masters and Doctoral Students. *"]
[null,"In addition, doctoral students whom have passed their preliminary exams have a higher rate. Please select the appropriate option. "]
[null,"The \"other\" option enables you to enter a higher rate of pay. This may be used if you have a program (e.g. IGERT) that requires higher rates or if"]
[null,"for whatever reason you elect to pay the students more. You must select the \"other\" option here to \"turn on\" the other rate of pay box."]
[null,"* If you are bound to a set annual rate by your grant, you can also use the \"other\" category to force a lower value. "]
[null,"** If this is a MOSS student, please select what kind and manually enter in the MOSS fees in the lower sections. "]
[]
[null,"Step 5","If applicable - enter partial support amounts"]
[null,"If you plan to cover part of a student's resident tuition (up to 100% of the value) or part of their SHIP costs, please enter these partial numbers"]
[null,"into these green areas. ** When filling out \"partials\" please do not exceed 100% of \"yes\" values **"]
[]
[null,"Step 6","Summer credit"]
[null,"If you plan to cover the cost of the 1 credit required for summer enrollment, please select yes."]
[]
[null,"Step 7","Teaching assistantship information (if applicable)"]
[null,"If you plan to offer the student a fall or spring teaching assistantship, please enter the hours here."]
[null,"If planning to allocate a TA to a student - you must obtain a signature from your department chair."]
[null,"Please note that TA's do not automatically receive resident tuition/fee payments. If in doubt contact your department chair. "]
[]
[null,"7b","Does the Student receive a 10hr TH/IH Appointment?"]
[null,"If you plan to offer the student up to a 10hr TH/IH appointment, please enter that information here. "]
[null,"As per COGS rules a maximum of 10hrs of TH/IH is allow on top of a RA or TA appointment. "]
[]
[null,"Step 8","Budgets and approvals"]
[null,"Please enter your budget information. Once you are okay with this information save the file as \"Fiscal_Student-Surname\". Then write in your name and date of approval."]
[null,"Then send the file to your fiscal representative in the college to check it - after approval they will also write in their name and date of approval."]
[null,"Once all approvals are achieved, email the final form to cnr-drgs@uidaho.edu and an offer letter will be generated for your final approval."]

{"sheet":"Worksheet","index":1,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[45,3,45,5],[47,3,47,5],[43,8,43,12],[44,8,44,12],[45,8,45,12],[47,8,47,12],[34,10,34,12],[37,5,37,6],[6,2,6,5],[41,4,41,5],[43,3,43,5],[36,10,36,12]]}
[]
[null,"(1) Please select options.",null,"Select Closest Appointment Dates (from drop down):",null,null,null,"Does Student ONLY Need 1 Credit?",null,null,"(2) Is the Summer Starting Student New to SHIP?"]
[null,null,null,null,null,"RA: August to August",null,"No",null,null,"Yes"]
[]
[]
[]
[null,"Students Name:  ","Joe Vandal",null,null,null,null,null,"Select Student Type:",null,"Program","If MOSS what Type?","MOSS Fee Each Semester"]
[null,null,null,null,null,null,null,null,"Masters",null,"Natural Resources","No",{"$f":"'DO NOT EDIT'!D20","v":0}]
[null,"(3)",null,{"$f":"IF('DO NOT EDIT'!C22<2, \"Enter 20 but ADD to Notes if 19.5 hr/wk (1 credit in last semester) RA Needed\",\"\")","v":""}]
[null,"RA appointment date range:",null,{"$f":"'DO NOT EDIT'!D5","v":"August 19th 2019 to August 15th 2020"},null,null,"Hours","(4)","Select Rate Type:",null,"Is this Student an Idaho Resident?"]
[null,"Enter FALL hrs/wk (max 20):",null,20,"Weeks:",18,{"$f":"D11*F11","v":360},null,"Masters",null,"NO","From Rates Sheet:"]
[null,"Enter Christmas hrs/wk:",null,20,"Weeks:",3,{"$f":"D12*F12","v":60},null,null,null,null,"Rate Type",{"$f":"I11","v":"Masters"}]
[null,"Enter SPRING hrs/wk:",null,20,"Weeks:",18,360,null,null,null,null,"Rate",{"$f":"'DO NOT EDIT'!$D$4","v":17.57}]
[null,"Enter reg SUMMER hrs/wk:",null,20,"Weeks:",14,280,"If you selected \"other\" and wish to pay the student at a  $/hr rate"]
[null,"Enter extra summer hrs/wk:",null,0,"Weeks:",14,0,"higher than the MINIMUM CNR rate, please enter that here --->",null,null,null,null,0]
[null,"Amount to Student:",null,"Add Comp:",null,null,{"$f":"SUM(G11:G15)","v":1060},{"$f":"G16+(L33*18)+(M33*18)","v":1060},"[Total Hours Check]"]
[]
[null,{"$f":"(D11*F11*M13)+(D12*F12*M13)+(D13*M13*F13)+(D14*F14*M13)+(D15*F15*M13)","v":18624.199999999997},null,null,"Stipend, with payments made every 2 weeks",null,null,null,"Please note: UI Rates Change in June Each Year",null,null,null,"(6)"]
[null,null,null,{"$f":"IF(I21>1, \"FALL % TOO HIGH!!!\",\"\")","v":""},null,"Fall",null,null,"(5)","Spring",null,null,"Summer"]
[null,{"$f":"IF(I21>'DO NOT EDIT'!C50, \"FALL TUITION TOO HIGH!!!\",\"\")","v":""},null,{"$f":"IF('DO NOT EDIT'!I8<'DO NOT EDIT'!M8,'DO NOT EDIT'!M8,'DO NOT EDIT'!I8)","v":17636},null,"Waive full non-resident tuition?",null,null,"Partial %","Waive full non-resident tuition?",null,"Partial %","Provide SHIP?"]
[null,{"$f":"IF(L21>'DO NOT EDIT'!C50, \"SPRING TUITION TOO HIGH!!!\",\"\")","v":""},null,{"$f":"IF(L21>1, \"SPRING % TOO HIGH!!!\",\"\")","v":""},null,"Yes",null,null,{"$f":"(D11+L33+L34)/20","v":1},null,"Yes",{"$f":"(D13+M33+M34)/20","v":1},"Yes"]
[null,{"$f":"IF(I23>'DO NOT EDIT'!C52, \"FALL TUITION TOO HIGH!!!\",\"\")","v":""},null,{"$f":"IF('DO NOT EDIT'!I9<'DO NOT EDIT'!M9,'DO NOT EDIT'!M9,'DO NOT EDIT'!I9)","v":9352},null,"Provide resident tuition?",null,null,"Partial $","Provide resident tuition?",null,"Partial $"]
[null,{"$f":"IF(L23>'DO NOT EDIT'!C52, \"SPRING TUITION TOO HIGH!!!\",\"\")","v":""},null,null,null,"Yes",null,null,0,null,"Yes",0,"Provide summer credit?"]
[null,{"$f":"IF(I25>'DO NOT EDIT'!C54, \"FALL SHIP TOO HIGH!!!\",\"\")","v":""},null,{"$f":"IF('DO NOT EDIT'!I10<'DO NOT EDIT'!M10,'DO NOT EDIT'!M10,'DO NOT EDIT'!I10)","v":2248},null,"Provide student health insurance?",null,null,"Partial $","Provide student health insurance?",null,"Partial $","Yes"]
[null,{"$f":"IF(L25>'DO NOT EDIT'!C54, \"SPRING SHIP TOO HIGH!!!\",\"\")","v":""},null,null,null,"Yes",null,null,0,null,"Yes",0]
[null,null,null,{"$f":"'DO NOT EDIT'!M11","v":520}]
[]
[null,null,null,null,null,"Please Enter Amount of MOSS Program Fee Provided",null,null,null,null,"Please Enter Amount of MOSS Program Fee Provided"]
[null,null,null,{"$f":"(F29+K29)","v":0},null,0,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,"(7)",null,"Teaching Assistantship Information (Each Semester = 19.5 wks)"]
[null,{"$f":"((L33+L34)*L36*19.5)+((M33+M34)*M36*19.5)","v":0},null,null,null,null,null,null,null,null,"HOURS per TA per week","Fall","Spring"]
[null,null,null,null,null,"Temporary Help (TH/IH) Max 10 hrs per semester",null,null,null,null,"TA APPOINTMENT 1 (10hr/wk)",0,0]
[null,null,null,null,null,"HOURS per TH/IH per week","Fall","Spring",null,null,"TA APPOINTMENT 2 (10hr/wk)",0,0]
[null,{"$f":"(G35*F11*G36)+(H35*F13*H36)","v":0},null,null,null,"TH/IH APPOINTMENT 1 (10hr/wk)",0,0,null,null,"IF FT (20hr/wk) TA - FILL OUT BOTH ROWS THE SAME"]
[null,null,null,null,null,"Rate",0,0,null,null,"AVERAGE TA Rate:",{"$f":"14000/39/20","v":17.948717948717949},{"$f":"14000/39/20","v":17.948717948717949}]
[null,null,null,null,null,null,null,null,null,null,"TA Rate is default rate BUT can be overwritten"]
[null,null,null,{"$f":"(B32+B18+B35)*0.038","v":707.7195999999999},null,"Fringe Benefits (3.8%)"]
[null,null,null,{"$f":"SUM(B18:D38)","v":49087.919599999994},"Total value including stipend, fringe, and additional compensation"]
[]
[null,"Return RA agreement by  ",null,null,null,"(8)",null,null,"Budget # paying fees & insurance "]
[null,"Budget # paying stipend  ",null,null,null,null,null,null,"Budget # for background check  "]
[null,null,null,null,null,null,null,null,"Notes (if needed): If TA funding included please have Department Chair indicate approval at bottom"]
[null,"Major Professor's  (Type) "]
[]
[null,"Major Professor's approval: ",null,"//s"]
[]
[null,"Fiscal Services approval:",null,"//s",null,null,null,null,"Chair Approval (if TA funding included): "]
[]
[null,null,"Fast Facts"]
[null,null,"Resident Tuition  (per semester)",null,null,{"$f":"'DO NOT EDIT'!C52","v":4676},null,null,"Current SHIP Rates (semester)",null,{"$f":"'DO NOT EDIT'!C54","v":899}]
[null,null,"MOSS Certificate (per semester)",null,null,{"$f":"'DO NOT EDIT'!G42","v":8141},"The MOSS Program Fee Replaces Resident Tuition"]
[null,null,"MOSS MNR (per semester)",null,null,{"$f":"'DO NOT EDIT'!G43","v":10298},"The MOSS Program Fee Replaces Resident Tuition"]
[null,null,"Non-Resident Tuition (per semester)",null,null,{"$f":"'DO NOT EDIT'!C50","v":8818},null,null,"Summer Credit",null,{"$f":"'DO NOT EDIT'!C64","v":520}]

{"sheet":"DO NOT EDIT","index":2,"n_rows":73,"n_cols":13,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
["Rates Sheet - links from Worksheet"]
[]
[null,"Links","Index Value","Rates",null,{"$f":"IF('DO NOT EDIT'!I8<'DO NOT EDIT'!M8,'DO NOT EDIT'!M8,'DO NOT EDIT'!I8)","v":17636}]
["Degree",{"$f":"Worksheet!M12","v":"Masters"},{"$f":"IF(B4=B28,1, IF(B4=B29,2, IF(B4=B30,3, IF(B4=B31, 4))))","v":1},{"$f":"INDEX(C28:C31, MATCH(B4,B28:B31,0))","v":17.57}]
["AY/CY",{"$f":"Worksheet!F3","v":"RA: August to August"},{"$f":"IF(B5=B33,1, IF(B5=B34,2, IF(B5=B35,3, IF(B5=B36, 4, IF(B5=B37,5)))))","v":3},{"$f":"INDEX(C33:C41, MATCH(B5,B33:B41,0))","v":"August 19th 2019 to August 15th 2020"},null,null,null,null,"Calculations"]
["Summer",{"$f":"Worksheet!K3","v":"Yes"},{"$f":"IF(B6=B45,1,IF(B6=B46,2))","v":1},{"$f":"INDEX(C45:C46, MATCH(B6,B45:B46,0))","v":"Summer SHIP"}]
["Fall 2017",null,null,null,null,null,"Partial F","Partial S","Total","Fall","Spring","Summer","Total"]
["Non-resident tuition",{"$f":"Worksheet!F21","v":"Yes"},{"$f":"IF(B8=A50,1,IF(B8=A51,2))","v":1},{"$f":"INDEX(C50:C51, MATCH(B8,A50:A51,0))","v":8818},null,"Non-resident tuition",{"$f":"IF(Worksheet!I21>0,(Worksheet!I21*'DO NOT EDIT'!D50),0)","v":8818},{"$f":"IF(Worksheet!L21>0,(Worksheet!L21*'DO NOT EDIT'!D57),0)","v":8818},{"$f":"G8+H8","v":17636},{"$f":"IF(C8<2,D50,G8)","v":8818},{"$f":"IF(C12<2,D57,H8)","v":8818},null,{"$f":"SUM(J8:L8)","v":17636}]
["Resident Fees ",{"$f":"Worksheet!F23","v":"Yes"},{"$f":"IF(B9=A52,1,IF(B9=A53,2))","v":1},{"$f":"INDEX(C52:C53, MATCH(B9,A52:A53,0))","v":4676},null,"Resident Fees ",{"$f":"IF(Worksheet!I23>0,Worksheet!I23,0)","v":0},{"$f":"IF(Worksheet!L23>0,Worksheet!L23,0)","v":0},{"$f":"G9+H9","v":0},{"$f":"IF(C9<2,D9,G9)","v":4676},{"$f":"IF(C13<2,D13,H9)","v":4676},null,{"$f":"SUM(J9:L9)","v":9352}]
["SHIP",{"$f":"Worksheet!F25","v":"Yes"},{"$f":"IF(B10=A54,1,IF(B10=A55,2))","v":1},{"$f":"INDEX(C54:C55, MATCH(B10,A54:A55,0))","v":899},null,"SHIP",{"$f":"IF(Worksheet!I25>0,Worksheet!I25,0)","v":0},{"$f":"IF(Worksheet!L25>0,Worksheet!L25,0)","v":0},0,{"$f":"IF(C10<2,D10,G10)","v":899},{"$f":"IF(C14<2,D14,H10)","v":899},{"$f":"IF(C6>1,0,D17)","v":450},2248]
["Spring 2018",null,null,null,null,"Credit",null,null,null,{"$f":"IF(C16<2,D16,0)","v":520},null,null,{"$f":"SUM(J11:L11)","v":520}]
["Non-resident tuition",{"$f":"Worksheet!K21","v":"Yes"},{"$f":"IF(B12=A57,1,IF(B12=A58,2))","v":1},{"$f":"INDEX(C57:C58, MATCH(B12,A57:A58,0))","v":8818}]
["Resident Fees ",{"$f":"Worksheet!K23","v":"Yes"},{"$f":"IF(B13=A59,1,IF(B13=A60,2))","v":1},{"$f":"INDEX(C59:C60, MATCH(B13,A59:A60,0))","v":4676},null,"Moss Programming Fee",{"$f":"IF(Worksheet!F29>0,Worksheet!F29,0)","v":0},{"$f":"IF(Worksheet!K29>0,Worksheet!K29,0)","v":0},{"$f":"G13+H13","v":0},{"$f":"IF(C13<2,D13,G13)","v":4676},{"$f":"IF(C17<2,D17,H13)","v":450},null,{"$f":"SUM(J13:L13)","v":5126}]
["SHIP",{"$f":"Worksheet!K25","v":"Yes"},{"$f":"IF(B14=A61,1,IF(B14=A62,2))","v":1},{"$f":"INDEX(C61:C62, MATCH(B14,A61:A62,0))","v":899}]
["Summer 2018"]
["Summer credit",{"$f":"Worksheet!M24","v":"Yes"},{"$f":"IF(B16=A66,1,IF(B16=A67,2))","v":1},{"$f":"INDEX(C64:C65, MATCH(B16,A64:A65,0))","v":520}]
["SHIP",{"$f":"Worksheet!M21","v":"Yes"},{"$f":"IF(B17=A66,1,IF(B17=A67,2))","v":1},{"$f":"INDEX(C66:C67, MATCH(B17,A66:A67,0))","v":450}]
[]
[]
["Moss Type",{"$f":"Worksheet!L8","v":"No"},{"$f":"IF(B20=F41, 1, IF(B20=F42,2, IF(B20=F43,3 )))","v":1},{"$f":"INDEX(G41:G43, MATCH(B20,F41:F43,0))","v":0}]
[]
["Just 1 Credit",{"$f":"Worksheet!H3","v":"No"},{"$f":"IF(B22=B45,1,IF(B22=B46,2))","v":2}]
[]
[]
[]
[null,"CNR Depts / Degrees","Rates","Notes",null,"AY RA = 780 hrs @ 20 hr/week"]
[null,null,null,null,null,"Full year RA = 780 AY + 520 full time summer hrs = 1300 total hrs"]
[null,"Masters",17.57,null,null,"Full year RA Requires 1 summer credit = $457/credit"]
[null,"Doctorate",20.03,null,null,"Suggested Rates:"]
[null,"Doctorate Special",22.1,null,null,"MS = $17.23, PhD = $19.64, PhD Special (passed prelims) = $21.67"]
[null,"Other",{"$f":"Worksheet!M15","v":0}]
[null,"Appointment Type","Date Range",null,null,"FY 17 Graduate Student Fees and Medical"]
[null,"RA: January to January","January 13th 2020 to January 9th 2021"]
[null,"RA: May to May","May 13th 2019 to May 16th 2020",null,null,"Medical per semester",null,null,null,null,null,960]
[null,"RA: August to August","August 19th 2019 to August 15th 2020",null,null,"Medical summer",null,null,null,null,null,570]
[null,"RA: December to December","December 23rd 2019 to December 19th 2020",null,null,"Resident Fees",null,null,null,null,null,{"$f":"4111*2","v":8222}]
[null,null,null,null,null,"Summer Credit",null,null,null,null,null,457]
[null,"TA: Spring Semester only","January 13th 2020 to May 16th 2020"]
[null,"TA: Fall Semester only","August 19th 2019 to December 21st 2019"]
[null,"TA: Fall and Spring Semester","August 19th 2019 to May 16th 2020",null,null,"MOSS Classes","Per semester"]
[null,null,null,null,null,"No",0]
[null,null,null,null,null,"CERTIFICATE",8141]
[null,null,null,null,null,"MNR",10298]
[null,"Summer Start"]
[null,"Yes","Summer SHIP",null,null,"Program"]
[null,"No","No Summer SHIP",null,null,"Natural Resources"]
[null,null,null,null,null,"Environmental Science",null,null,null,null,null,"Full-time (9-20 credits) non-resident tuition paid for Fall 2016 ($7,212)* and Spring 2017 ($7,212)*"]
["Rates",null,null,null,null,"MOSS"]
[null,"Fall 2018",null,"Resident Correction",null,null,null,null,null,null,null,"Resident Student fees paid for Fall 2016 ($4,234) and Spring 2017 ($4,234)"]
["Yes","Non-resident tuition",8818,{"$f":"C50*C70","v":8818}]
["No",{"$f":"INDEX('DO NOT EDIT'!A50:A51,'DO NOT EDIT'!C8,0)","v":"Yes"},0,null,null,null,null,null,null,null,null,"Student fees paid for one summer 2017 credit ($470)"]
["Yes","Resident Fees ",4676]
["No",{"$f":"INDEX('DO NOT EDIT'!A52:A53,'DO NOT EDIT'!C9,0)","v":"Yes"},0,null,null,null,null,null,null,null,null,"Personal student health insurance paid ($952 per semester + $570 in summer) "]
["Yes","SHIP",899,null,null,null,null,null,null,null,null,"Total value of the assistantship including stipend and additional compensation"]
["No",{"$f":"INDEX('DO NOT EDIT'!A54:A55,'DO NOT EDIT'!C10,0)","v":"Yes"},0]
[null,"Spring 2019"]
["Yes","Non-resident tuition",8818,{"$f":"C57*C70","v":8818}]
["No",{"$f":"INDEX('DO NOT EDIT'!A57:A58,'DO NOT EDIT'!C12,0)","v":"Yes"},0]
["Yes","Resident Fees ",4676]
["No",{"$f":"INDEX('DO NOT EDIT'!A59:A60,'DO NOT EDIT'!C13,0)","v":"Yes"},0]
["Yes","SHIP",899]
["No",{"$f":"INDEX('DO NOT EDIT'!A61:A62,'DO NOT EDIT'!C14,0)","v":"Yes"},0]
[null,"Summer 2018"]
["Yes","Summer credit",520]
["No",{"$f":"INDEX('DO NOT EDIT'!A64:A65,'DO NOT EDIT'!C16,0)","v":"Yes"},0]
["Yes","SHIP",450,"Only if Summer 2018 start"]
["No",{"$f":"INDEX('DO NOT EDIT'!A66:A67,'DO NOT EDIT'!C17,0)","v":"Yes"},0]
[]
[null,"Resident","Index Value"]
[null,"YES",{"$f":"IF(B73=B70,0, IF(B73=B71,1))","v":1}]
[null,"NO"]
[null,"Value"]
[null,{"$f":"Worksheet!K11","v":"NO"}]