{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Outstanding Trainee Obligations"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":4,"defined_names":130,"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":"Outstanding Trainee Obligations","index":0,"n_rows":72,"n_cols":9,"rows_kept":72,"cut":false,"hidden":false,"merged":[[2,0,2,2],[3,0,3,2]]}
["OUTSTANDING TRAINEE OBLIGATIONS"]
[]
["Transferred from Budget Number (Current Budget): ",null,null,null,null,null,null,null,"Populate the grey cells"]
["Transferred to Budget Number (Continuation Budget): "]
[null,null,null,null,null,null,null,"Instructions"]
[null,"Subtotal of Outstanding Trainee Obligations",{"$f":"ROUND(+F36+F37+F55+F56+F64+F72, 0)","v":0},null,null,null,null,"1) Populate the current budget number in cell D3"]
["Exempt from IDC",{"$f":"+F72","v":0},null,null,null,null,null,"2) Populate the continuation budget number in cell D4"]
["Base",{"$f":"+C6-B7","v":0},null,null,null,null,null,"3) Populate the current award end date in cell D15"]
["Indirect Costs",0.08,{"$f":"ROUND(B8*B9,0)","v":0},null,null,null,null,"4) Populate the 01-50 benefit rate in cell D16"]
[null,"Total Trainee Outstanding Obligations",{"$f":"ROUND(C9+C6, 0)","v":0},null,null,null,null,"5) Populate the 01-90 benefit rate in cell D17"]
[null,null,null,null,null,null,null,"6) For each post-doctoral (01-50) and pre-doctoral (01-90) trainee, populate the trainee name, "]
[null,null,"AMOUNT AVAILABLE TO FUND TRAINEE OBLIGATIONS  ",{"$f":"+C10","v":0},null,null,null,"the appointment start and end dates, and monthly stipend rate as outlined on the trainee's"]
[null,null,null,null,null,null,null,"statement of appointment within the grey cells. If trainee stipends were split between object codes "]
[null,null,null,null,null,null,null,"01 and 08-02, populate the applicable rates so the form correctly allocates these obligations "]
[null,"Award End Date",null,null,null,null,null,"between object codes 01 and 08-02. "]
[null,"01-50 Benefit Rate",null,null,null,null,null,"Note on prorated appointments: If a trainees appointment does not start on the 1st or 16th of "]
[null,"01-90 Benefit Rate",null,null,null,null,null,"the month, adjust the formula for trainee obligations to make sure the trainee is paid the full"]
[null,null,null,null,null,null,null,"SOA amount. The months remaining multiplied by the monthly rate does not factor the prorated"]
["Detail of Trainee Obligations",null,null,null,null,null,null,"amount paid into the calculation and may result in lower obligations than are required."]
[null,null,null,null,null,null,null,"7) Populate the grey cells in the tuition (08-05) section to obligate tuition funds for a particular trainee."]
["01-50 Trainee Name","Appointed From","Appointed To","Months Remaining","Monthly Rate","Total",null,"Trainee tuition obligations can only be made if a trainee's appointment period spans 5 of 6 pay periods "]
[null,null,null,{"$f":"IF(ROUND((DAYS360($D$15,C22)/30),1)>0,ROUND((DAYS360($D$15,C22)/30),1),\"\")","v":""},null,{"$f":"IF(E22>0,ROUND(+E22*D22,0),\"\")","v":""},null,"in Autumn, Winter, and Spring quarters, and 2 consecutive pay periods during Summer quarter. "]
[null,null,null,{"$f":"IF(ROUND((DAYS360($D$15,C23)/30),1)>0,ROUND((DAYS360($D$15,C23)/30),1),\"\")","v":""},null,{"$f":"IF(E23>0,ROUND(+E23*D23,0),\"\")","v":""},null,"Autumn:","09/16 - 12/15"]
[null,null,null,{"$f":"IF(ROUND((DAYS360($D$15,C24)/30),1)>0,ROUND((DAYS360($D$15,C24)/30),1),\"\")","v":""},null,{"$f":"IF(E24>0,ROUND(+E24*D24,0),\"\")","v":""},null,"Winter: ","12/16 - 03/15"]
[null,null,null,"",null,"",null,"Spring: ","03/16 - 06/15"]
[null,null,null,"",null,"",null,"Summer: ","06/16 - 09/15"]
[null,null,null,"",null,"",null,"8) Once fully populated, the applicable direct costs are multiplied by the 8% F&A rate, and cell D12"]
[null,null,null,"",null,"",null,"displays the total amount of trainee obligations that will be rolled forward to the continuation budget"]
[null,null,null,"",null,"",null,"and become current budget period obligations. "]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,{"$f":"IF(ROUND((DAYS360($D$15,C35)/30),1)>0,ROUND((DAYS360($D$15,C35)/30),1),\"\")","v":""},null,{"$f":"IF(E35>0,ROUND(+E35*D35,0),\"\")","v":""}]
[{"$f":"IF([2]input!D280>\" \",IF(MID([2]input!D280,4,8)=\"25-99-00\",\" \",IF(MID([2]input!D280,4,8)=\"37-99-00\",\" \",MID([2]input!D280,4,8))),\" \")","v":" "},null,null,null,"01-50 Total ",{"$f":"ROUND(SUM(F22:F35), 2)","v":0}]
[null,null,null,"Benefits",{"$f":"D16","v":0},{"$f":"ROUND((F36*E37), 0)","v":0}]
[]
["01-90 Trainee Name","Appointed From","Appointed To","Months Remaining","Monthly Rate","Total"]
[null,null,null,{"$f":"IF(ROUND((DAYS360($D$15,C40)/30),1)>0,ROUND((DAYS360($D$15,C40)/30),1),\"\")","v":""},null,{"$f":"IF(E40>0,ROUND(+E40*D40, 0),\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(E41>0,ROUND(+E41*D41, 0),\"\")","v":""}]
[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,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,""]
[null,null,null,null,"01-90 Total ",{"$f":"ROUND(SUM(F40:F54),0)","v":0}]
[null,null,null,"Benefits",{"$f":"D17","v":0},{"$f":"ROUND((F55*E56), 0)","v":0}]
[]
["08-02 Trainee Name","Appointed From","Appointed To","Months Remaining","Monthly Rate","Total"]
[null,null,null,{"$f":"IF(ROUND((DAYS360($D$15,C59)/30),1)>0,ROUND((DAYS360($D$15,C59)/30),1),\"\")","v":""},null,{"$f":"IF(E59>0,ROUND(+E59*D59, 0),\"\")","v":""}]
[null,null,null,{"$f":"IF(ROUND((DAYS360($D$15,C60)/30),1)>0,ROUND((DAYS360($D$15,C60)/30),1),\"\")","v":""},null,{"$f":"IF(E60>0,ROUND(+E60*D60, 0),\"\")","v":""}]
[null,null,null,"",null,""]
[null,null,null,{"$f":"IF(ROUND((DAYS360($D$15,C62)/30),1)>0,ROUND((DAYS360($D$15,C62)/30),1),\"\")","v":""},null,""]
[null,null,null,"",null,""]
[{"$f":"IF([2]input!D308>\" \",IF(MID([2]input!D308,4,8)=\"25-99-00\",\" \",IF(MID([2]input!D308,4,8)=\"37-99-00\",\" \",MID([2]input!D308,4,8))),\" \")","v":" "},null,null,null,"08-02 Total ",{"$f":"ROUND(SUM(F59:F63), 0)","v":0}]
[]
["08-05 Trainee Name","SUMMER","AUTUMN","WINTER","SPRING","Total"]
[null,null,null,null,null,{"$f":"IF(SUM(B67:E67)=0,\"\",ROUND(SUM(B67:E67),0))","v":""}]
[null,null,null,null,null,{"$f":"IF(SUM(B68:E68)=0,\"\",ROUND(SUM(B68:E68),0))","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[{"$f":"IF([2]input!D321>\" \",IF(MID([2]input!D321,4,8)=\"25-99-00\",\" \",IF(MID([2]input!D321,4,8)=\"37-99-00\",\" \",MID([2]input!D321,4,8))),\" \")","v":" "},null,null,null,"08-05 Total ",{"$f":"ROUND(SUM(F67:F71), 0)","v":0}]