{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":45,"n_cols":6,"rows_kept":45,"merged":[[2,1,2,5],[3,1,3,5],[7,1,7,5],[8,1,8,5]]}
[]
[]
[null,"FINANCE AND ADMINISTRATION"]
[null,"Residual Account Request Form (KARAE project code)"]
[null,"SECTION A: PI Name & Department Info"]
[null,"Faculty Name:   ",null,null,"Request Date:    "]
[null,"Department   "]
[null,"In conformance with CHASS Residual Accounts Policy, I am requesting a residual account. This account allows me to direct-charge a portion of my salary to a grant, and in return, receive an allocation equivalent to 80% of the calculated salary savings amount to be deposited to the residual account. "]
[null,"The distribution to the residuals  account will occur in the immediately following academic year in which the salary savings occurred so that a complete reconciliation of salary  can be completed after fiscal closing (e.g. salary charged to grant in 2021-22 the residual funds will be available to the faculty member in 2022-23)."]
[null," SECTION B: C&G Grant Information (completed by PI and Fund Manager/Analyst)  "]
[null,"C&G Primary PI : ",null,null,"Annualized Salary   ",0]
[{"$nulls":4},"MO Salary Rate   ",0]
[null,"C&G Co-PI  :"]
[{"$nulls":4},"Number of Months to C&G"]
[null,"Grant End-Date:",{"$nulls":3},"(no data entry in yellow fields)"]
[null,"Fund Number  :                  ",null,null,"Projected FTE to Charge to C&G",{"$f":"IF(F14,12/F14,0)","v":0}]
[null,"Grant FAU:   ",null,null,"Projected Gross Salary Charged to C&G ",{"$f":"SUM(F12)*F14*F16","v":0}]
[null,"Fiscal Year:",null,null,"80% PI Total",{"$f":"SUM(F17)*0.8","v":0}]
[null,"Begin Date:",null,null,"20% College Total",{"$f":"SUM(F17)*0.2","v":0}]
[null,"End Date:",null,null,"Total",{"$f":"SUM(F18:F19)","v":0}]
{"$rows_empty":9}
[null," SECTION C: Residual Account Information (completed by Department)  "]
[null,"Residual Account"]
[null,"FAU:    Activity:  A0_________________","Fund:  19900                Function:_________",null,"Cost Center:_____________________","Project Code: KARAE"]
[null," SECTION D: Approval Signatures (signed by all parties)  "]
[null,"Approval Information"]
[null,"PI/Faculty Member ","Signature:_______________________________________________________",null,null,"Date:   __________________"]
[null,"C&G Funding Acknowledgement   ","Signature:_______________________________________________________",null,null,"Date:   __________________"]
[null,"Dept / FAO/Manager *","Signature:_______________________________________________________",null,null,"Date:   __________________"]
[null,"Chair Approval **","Signature:_______________________________________________________",null,null,"Date:   __________________"]
[null,"Finance & Administration Approval ","Signature:_______________________________________________________",null,null,"Date:   __________________"]
[null,"*Department will be responsible for managing the grant budget, including the salary expenditures, and will need to provide a salary report to substantiate the total salary costs, including salary detail."]
[null,"** If chair is requesting residuals account, then approval needs to be granted by Dean."]
[null,"Section E: Funds Transfer (College office completes)"]
[null,"Fiscal Year:______________________","BEA #__________________________",null,"Date:   __________"]
[null,"ROUTING: PI REQUESTING ACCOUNT -----> C&G Fund Analyst -----> DEPT FAO/MANAGER -----> DEPT. CHAIR -----> CHASS FINANCE &ADMINISTRATION"]
[null,"Version:1     Updated 5-13-2021"]