{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Calculations","Instructions","Year 1","Year 2","Year 3","Year 4","Year 5","Summary"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":238,"comments":6,"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":"Calculations","index":0,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":true,"merged":[[24,3,26,6]]}
["Cost of Living","Full-Time","Part-Time"]
["Yearly Increase (%)",3,3]
["Fringe rates"]
["BRP Eligible"]
["End Date Package","1995-08-31",{"$f":"B5","v":"1995-08-31"}]
["Faculty and Staff"]
["ORP (%)",{"$f":"AVERAGE(21.52,23.42)-1","v":21.47},{"$f":"B7","v":21.47}]
["TRS (%)",21.4,{"$f":"B8","v":21.4}]
["Students"]
["Graduate (%)",7.65,7.65]
["Undergraduate (%)",7.65,7.65]
["Others"]
["Hourly (%)",7.65,7.65]
["Non-BRP Eligible"]
["End Date Package","2099-08-31",{"$f":"B15","v":"2099-08-31"}]
["Faculty and Staff"]
["ORP (%)",{"$f":"AVERAGE(15.25,17.15)-1","v":15.2},{"$f":"B17","v":15.2},null,"TUCA of 1% removed October 2018"]
["TRS (%)",15.15,{"$f":"B18","v":15.15}]
["Students"]
["Graduate (%)",7.65,{"$f":"B20","v":7.65}]
["Undergraduate (%)",7.65,7.65]
["Others"]
["Hourly (%)",7.65,7.65]
["Insurance"]
["Employee ($)",624.82000000000005,312.41000000000003]
["Spouse ($)",982.36,491.18]
["Children ($)",864.2,432.1]
["Family ($)",1221.74,610.87]
["None ($)",60,30]
["Longevity"]
["Amount Per Month ($)",20,{"$f":"B31","v":20}]
["For Every ? (Years)",2,2]
["Subcontracts"]
["Upper Limit ($)",25000,{"$f":"B34","v":25000}]
["IDC Rates"]
["Research",48.5]
["On-Campus Other",31.5]
["Instruction",48]
["Off-Campus",26]
[]
["Hire date","2007-09-01"]

{"sheet":"Instructions","index":1,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,2],[17,0,17,2],[2,0,2,2],[3,0,3,2],[25,0,25,2],[8,0,14,2],[1,0,1,2]]}
["Budget Builder"]
["Version: FY21"]
[]
["Attention Microsoft Office 2007 User:"]
[null,"To use Budget Builder in Microsoft Office 2007:"]
[null,"          Enable your macros by clicking on the \"Options\" box next to the \"Security Warning\" shield."]
[null,"Select the radio button \"Enable this Content.\" "]
[]
["The Budget Builder is an interactive spreadsheet designed to assist investigators to develop actual budgets that are both detailed and concise.  The development of this tool has led to many versions of the Budget Builder; therefore, it is recommended that investigators always download the newest version from the Office of Grants & Contracts Administration website.  This version updates FY21 F&A, Fringe and insurance rates and identifies the Base for F&A and Sponsor Direct costs."]
[]
[]
[]
[]
[]
[]
[]
[]
["BB Notes"]
["*","Remember to enable macros when opening the file; also, when downloading from our website, first save the file locally and then open in Excel (otherwise the file will attempt to open in the browser and the macros will not function).Do not try to save in any other format than .xls because the macros will not work."]
["*","Enter data only in the Yellow fields and complete the entire line."]
["*","A red corner in the upper right denotes a comment attached giving additional information for that cell or column."]
["*","Gray buttons beneath each section are used to insert new lines in that section."]
["*","It is very important that the header portion of Year 1 is completely filled out.  The \"date drafted\" is absolutely necessary because several formulas depend on that information."]
[null,"Please click on this PDF file for Budget Builder Guidelines"]
["*","If you have any questions, please contact proposals@unt.edu"]
[]
[null,"University of North Texas, Grants & Contracts Administration"]

{"sheet":"Year 1","index":2,"n_rows":146,"n_cols":24,"rows_kept":146,"cut":false,"hidden":false,"merged":[[112,0,112,1],[100,0,100,1],[101,0,101,1],[99,0,99,1],[138,0,138,1],[115,0,115,1],[111,0,111,1],[104,0,104,1],[122,0,122,1],[127,0,127,1],[115,2,115,5],[130,0,130,1],[141,6,141,7],[131,0,131,1],[141,0,141,1],[140,0,140,1],[139,0,139,1],[130,2,130,5],[137,0,137,1],[136,0,136,1],[125,2,125,5],[134,0,134,1],[125,0,125,1],[128,0,128,1],[129,0,129,1],[121,0,121,1],[87,6,87,7],[94,2,94,5],[94,0,94,1],[84,0,84,1],[73,5,73,7],[80,1,80,4],[86,2,86,5],[83,4,83,9],[86,0,86,1],[85,0,85,1],[82,6,82,7],[75,1,75,4],[81,1,81,4],[84,2,84,5],[85,2,85,5],[5,10,5,11],[25,6,25,7],[42,5,42,7],[44,10,44,11],[41,5,41,7],[43,8,44,8],[4,8,5,8],[4,7,5,7],[95,0,95,1],[88,1,88,9],[92,6,92,7],[93,3,93,9],[90,2,90,5],[91,2,91,5],[95,2,95,5],[89,0,89,1],[91,0,91,1],[93,0,93,2],[89,2,89,5],[90,0,90,1],[0,5,0,7],[1,1,1,9],[2,0,2,1],[2,2,2,3],[2,7,2,9],[0,2,0,3],[3,5,3,7],[3,0,3,4],[71,5,71,7],[72,5,72,7],[56,6,56,7],[43,7,44,7],[69,5,69,7],[70,5,70,7],[96,2,96,5],[104,2,104,5],[102,5,102,7],[96,0,96,1],[98,2,98,9],[111,2,111,5],[97,5,97,7],[127,10,129,11],[143,4,143,7],[141,3,141,5],[100,2,100,7],[99,2,99,5],[97,10,99,11],[131,2,131,5],[112,2,112,5],[101,2,101,7],[142,5,142,7],[134,5,134,7],[134,3,134,4],[121,2,121,5],[122,2,122,5]]}
["File Number:",null,"BB version:",null,"FY 2021","This Budget is prepared for:",null,null,null,"Year 1"]
["Project Title:"]
["Budget Prepared by:",null,null,null,"Phone Number:",null,"E-mail:"]
["Project Budget",null,null,null,null,"This Budget was drafted on:",null,null,null,{"$f":"Calculations!B41","v":"2007-09-01"}]
["Personnel","(EMPL IDs ARE REQUIRED FOR ALL UNT EMPLOYEES)",null,null,null,null,null,"Number of Months (Academic)","Number of Months (Summer)",null,null,null,"Personnel",null,null,null,null,"Fringe"]
["Last Name","First Name","EMPL ID#","Employee Type","Responsibility","Monthly Rate","Percent Effort (%)",null,null,"Project Salary","Rounded Number of Months",null,"Year 1",null,null,null,null,"Year 1"]
[]
[null,null,null,null,"PI"]
[null,null,null,null,"Co-PI"]
[null,null,null,null,"Senior Personnel"]
[null,null,null,null,"Research Assistant"]
[null,null,null,null,"Teaching Assistant"]
[null,null,{"$f":"FALSE()","v":false},null,"Investigator"]
[null,null,{"$f":"TRUE()","v":true},"PT Staff","Coordinator"]
[null,null,null,"PT Faculty","Technician"]
[null,null,null,"Hourly","Post Doc"]
[null,null,null,"Faculty","Clerical"]
[null,null,null,"Staff","Programmer"]
[0,0,0,0,0,0,0,0,0,{"$f":"F19*((G19*H19)/100+(G19*I19)/100)","v":0},{"$f":"ROUNDUP(H19+I19,0)","v":0},null,{"$f":"J19","v":0},null,null,null,null,{"$f":"J35","v":0}]
[0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,null,{"$f":"J35","v":0}]
[0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,null,{"$f":"J36","v":0}]
[0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,null,{"$f":"J37","v":0}]
[0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,null,{"$f":"J38","v":0}]
[0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,null,{"$f":"J39","v":0}]
[0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,null,{"$f":"J41","v":0}]
[null,null,null,null,null,null,"Sum of Personnel",null,null,{"$f":"SUM(J19:J25)","v":0}]
["Fringe Benefits for Personnel"]
["Last Name","First Name","EMPL ID#","Retirement","Insurance Type","Other Support","Hire Date","Fringe Rate",null,"Fringe Benefit Totals","Fringe Rates before 9-1-95",null,null,null,"Fringe Rates after 9-1-95",null,null,null,"Insurance and Longevity Calculations"]
[]
[null,null,null,null,"None"]
[null,null,null,null,"Employee"]
[null,null,null,"Hourly","Spouse"]
[null,null,null,"ORP","Children","Yes"]
[null,null,null,"TRS","Family","No",null,null,null,null,"Hourly","ORP","TRS","F1 Sum","Hourly","ORP","TRS","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[{"$f":"A19","v":0},0,0,{"$f":"IF($D19=$D$16,$D$32,$D$34)","v":"TRS"},"Employee","Yes",{"$f":"$J$4","v":"2007-09-01"},{"$f":"IF(G35>Fringe1End,R35,N35)","v":15.15},null,{"$f":"(J19*H35/100)+X35","v":0},{"$f":"IF(D35=$D$32,F1.Hourly,0)","v":0},{"$f":"IF(D35=$D$33,F1.FS.ORP,0)","v":0},{"$f":"IF(D35=$D$34,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K35:M35)","v":21.4},{"$f":"IF(D35=$D$32,F2.Hourly,0)","v":0},{"$f":"IF(D35=$D$33,F2.FS.ORP,0)","v":0},{"$f":"IF(D35=$D$34,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O35:Q35)","v":15.15},{"$f":"IF(F35=$F$33,G19,100)","v":0},{"$f":"IF($E35=$E$31,IF($D19=$D$14,Ins.PT.E*$K19*S35/100,IF($D19=$D$15,Ins.PT.E*$K19*S35/100,Ins.E*$K19*S35/100)),0)","v":0},{"$f":"IF($E35=$E$32,IF($D19=$D$14,Ins.PT.S*$K19*S35/100,IF($D19=$D$15,Ins.PT.S*$K19*S35/100,Ins.S*$K19*S35/100)),0)","v":0},{"$f":"IF($E35=$E$33,IF($D19=$D$14,Ins.PT.C*$K19*S35/100,IF($D19=$D$15,Ins.PT.C*$K19*S35/100,Ins.C*$K19*S35/100)),0)","v":0},{"$f":"IF($E35=$E$34,IF($D19=$D$14,Ins.PT.F*$K19*S35/100,IF($D19=$D$15,Ins.PT.F*$K19*S35/100,Ins.F*$K19*S35/100)),0)","v":0},{"$f":"IF(D19=$D$18,ROUNDDOWN(DAYS360(G35,$J$4)/(360*Long.Per),0)*20*K19*G19/100,0)+SUM(T35:W35)","v":0}]
[0,0,0,"TRS",{"$f":"IF($D20=$D$16,$E$30,$E$31)","v":"Employee"},"Yes","2007-09-01",15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"A21","v":0},0,0,"TRS","Employee","Yes","2007-09-01",15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[0,0,0,"TRS","Employee","Yes","2007-09-01",15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[0,0,0,"TRS","Employee","Yes","2007-09-01",15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"A24","v":0},0,0,"TRS","Employee","Yes","2007-09-01",15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[0,0,0,"TRS","Employee","Yes","2007-09-01",15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[null,null,null,null,null,"Sum of Fringe Benefits for Personnel",null,null,null,{"$f":"SUM(J35:J41)","v":0},"Hourly","ORP","TRS","F1 Sum","Hourly","ORP","TRS","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[null,null,null,null,null,"Sum of Personnel and Fringe Benefits",null,null,null,{"$f":"J26+J42","v":0}]
["Students",null,null,null,null,null,null,"Number of Months (Academic)","Number of Months\n(Summer)",null,null,null,"Students",null,null,null,null,"Fringe"]
["Last Name","First Name","EMPL ID#","Student Type","Responsibility","Monthly Rate","Percent Effort (%)",null,null,"Project Salary","Rounded Number of Months",null,"Year 1",null,null,null,null,"Year 1"]
[]
[]
[null,null,null,{"$f":"FALSE()","v":false}]
[null,null,null,{"$f":"TRUE()","v":true}]
[null,null,null,null,"Clerical"]
[null,null,null,"Graduate","Programmer"]
[null,null,null,"Undergrad","Research Assistant"]
[0,0,0,"Graduate",0,0,0,0,0,{"$f":"F53*((G53*H53)/100+(G53*I53)/100)","v":0},{"$f":"ROUNDUP(H53+I53,0)","v":0},null,{"$f":"J53","v":0},null,null,null,null,{"$f":"J66","v":0}]
[0,0,0,"Graduate",0,0,0,0,0,{"$f":"F54*((G54*H54)/100+(G54*I54)/100)","v":0},{"$f":"ROUNDUP(H54+I54,0)","v":0},null,{"$f":"J54","v":0},null,null,null,null,{"$f":"J66","v":0}]
[0,0,0,"Graduate",0,0,0,0,0,{"$f":"F55*((G55*H55)/100+(G55*I55)/100)","v":0},{"$f":"ROUNDUP(H55+I55,0)","v":0},null,{"$f":"J55","v":0},null,null,null,null,{"$f":"J67","v":0}]
[0,0,0,"Graduate",0,0,0,0,0,{"$f":"F56*((G56*H56)/100+(G56*I56)/100)","v":0},{"$f":"ROUNDUP(H56+I56,0)","v":0},null,{"$f":"J56","v":0},null,null,null,null,{"$f":"J69","v":0}]
[null,null,null,null,null,null,"Sum of Students",null,null,{"$f":"SUM(J53:J56)","v":0}]
["Fringe Benefits for Students"]
["Last Name","First Name","EMPL ID#","Student Type","Insurance Type","Other Support","Hire Date","Fringe Rate",null,"Fringe Benefit Totals","Fringe Rates before 9-1-95",null,null,"Fringe Rates after 9-1-95",null,null,"Insurance and Longevity Calculations"]
[]
[null,null,null,null,"None"]
[null,null,null,null,"Employee"]
[null,null,null,"None","Spouse"]
[null,null,null,"ORP","Children","Yes"]
[null,null,null,"TRS","Family","No",null,null,null,null,"Grad","Under","F1 Sum","Grad","Under","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[{"$f":"A53","v":0},0,0,"Graduate",{"$f":"IF($D53=$D$51,$E$62,$E$61)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},{"$f":"IF(G66>Fringe1End,P66,M66)","v":7.65},null,{"$f":"(J53*H66/100)+V66","v":0},{"$f":"IF(D53=$D$51,F1.Grad,0)","v":7.65},{"$f":"IF(D53=$D$52,F1.Under,0)","v":0},{"$f":"SUM(K66:L66)","v":7.65},{"$f":"IF(D53=$D$51,F2.Grad,0)","v":7.65},{"$f":"IF(D53=$D$52,F2.Under,0)","v":0},{"$f":"SUM(N66:O66)","v":7.65},{"$f":"IF(F66=$F$64,G53,100)","v":100},{"$f":"IF($E66=$E$62,Ins.PT.E*$K53*Q66/100,0)","v":0},{"$f":"IF($E66=$E$63,Ins.PT.S*$K53*Q66/100,0)","v":0},{"$f":"IF($E66=$E$64,Ins.PT.C*$K53*Q66/100,0)","v":0},{"$f":"IF($E66=$E$65,Ins.PT.F*$K53*Q66/100,0)","v":0},{"$f":"SUM(R66:U66)","v":0}]
[0,0,0,"Graduate","Employee","No",{"$f":"$J$4","v":"2007-09-01"},{"$f":"IF(G67>Fringe1End,P67,M67)","v":7.65},null,{"$f":"(J54*H67/100)+V67","v":0},{"$f":"IF(D54=$D$51,F1.Grad,0)","v":7.65},{"$f":"IF(D54=$D$52,F1.Under,0)","v":0},{"$f":"SUM(K67:L67)","v":7.65},{"$f":"IF(D54=$D$51,F2.Grad,0)","v":7.65},{"$f":"IF(D54=$D$52,F2.Under,0)","v":0},{"$f":"SUM(N67:O67)","v":7.65},{"$f":"IF(F67=$F$64,G54,100)","v":100},{"$f":"IF($E67=$E$62,Ins.PT.E*$K54*Q67/100,0)","v":0},{"$f":"IF($E67=$E$63,Ins.PT.S*$K54*Q67/100,0)","v":0},{"$f":"IF($E67=$E$64,Ins.PT.C*$K54*Q67/100,0)","v":0},{"$f":"IF($E67=$E$65,Ins.PT.F*$K54*Q67/100,0)","v":0},{"$f":"SUM(R67:U67)","v":0}]
[{"$f":"A55","v":0},0,0,"Graduate",{"$f":"IF($D55=$D$51,$E$62,$E$61)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},{"$f":"IF(G68>Fringe1End,P68,M68)","v":7.65},null,{"$f":"(J55*H68/100)+V68","v":0},{"$f":"IF(D55=$D$51,F1.Grad,0)","v":7.65},{"$f":"IF(D55=$D$52,F1.Under,0)","v":0},{"$f":"SUM(K68:L68)","v":7.65},{"$f":"IF(D55=$D$51,F2.Grad,0)","v":7.65},{"$f":"IF(D55=$D$52,F2.Under,0)","v":0},{"$f":"SUM(N68:O68)","v":7.65},{"$f":"IF(F68=$F$64,G55,100)","v":100},{"$f":"IF($E68=$E$62,Ins.PT.E*$K55*Q68/100,0)","v":0},{"$f":"IF($E68=$E$63,Ins.PT.S*$K55*Q68/100,0)","v":0},{"$f":"IF($E68=$E$64,Ins.PT.C*$K55*Q68/100,0)","v":0},{"$f":"IF($E68=$E$65,Ins.PT.F*$K55*Q68/100,0)","v":0},{"$f":"SUM(R68:U68)","v":0}]
[0,0,0,"Graduate",{"$f":"IF($D56=$D$51,$E$62,$E$61)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},{"$f":"IF(G69>Fringe1End,P69,M69)","v":7.65},null,{"$f":"(J56*H69/100)+V69","v":0},{"$f":"IF(D56=$D$51,F1.Grad,0)","v":7.65},{"$f":"IF(D56=$D$52,F1.Under,0)","v":0},{"$f":"SUM(K69:L69)","v":7.65},{"$f":"IF(D56=$D$51,F2.Grad,0)","v":7.65},{"$f":"IF(D56=$D$52,F2.Under,0)","v":0},{"$f":"SUM(N69:O69)","v":7.65},{"$f":"IF(F69=$F$64,G56,100)","v":100},{"$f":"IF($E69=$E$62,Ins.PT.E*$K56*Q69/100,0)","v":0},{"$f":"IF($E69=$E$63,Ins.PT.S*$K56*Q69/100,0)","v":0},{"$f":"IF($E69=$E$64,Ins.PT.C*$K56*Q69/100,0)","v":0},{"$f":"IF($E69=$E$65,Ins.PT.F*$K56*Q69/100,0)","v":0},{"$f":"SUM(R69:U69)","v":0}]
[null,null,null,null,null,"Sum of Fringe Benefits for Students",null,null,null,{"$f":"SUM(J66:J69)","v":0},"Grad","Under","F1 Sum","Grad","Under","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[null,null,null,null,null,"Sum of Students and Fringe Benefits",null,null,null,{"$f":"J57+J70","v":0}]
[null,null,null,null,null,"Sum of Salary",null,null,null,{"$f":"J26+J57","v":0}]
[null,null,null,null,null,"Sum of Fringe Benefits",null,null,null,{"$f":"J42+J70","v":0}]
[null,null,null,null,null,"Sum of Personnel and Students",null,null,null,{"$f":"SUM(J72:J73)","v":0}]
["Travel"]
["Component","Description",null,null,null,"Location","Date","Destination",null,"Cost"]
[]
["Transportation",null,null,null,null,"In-State"]
["Meals",null,null,null,null,"Out-of-State"]
["Lodging",null,null,null,null,"Foreign"]
[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,"Sum of Travel",null,null,{"$f":"SUM(J81:J82)","v":0}]
["Capital Expenditures/Equipment D",null,null,null,"These items individually are OVER $5,000. Please obtain a vendor quote"]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G86*H86","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G87*H87","v":0}]
[null,null,null,null,null,null,"Sum of Equipment",null,null,{"$f":"SUM(J86:J87)","v":0}]
["Supplies","These items individually are UNDER $5,000."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G91*H91","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G92*H92","v":0}]
[null,null,null,null,null,null,"Sum of Supplies",null,null,{"$f":"SUM(J91:J92)","v":0}]
["Publication Charges",null,null,"For the typical activities included in this category, hold mouse over the cell to the left."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G96*H96","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G97*H97","v":0}]
[null,null,null,null,null,"Sum of Publication/Printing Charges",null,null,null,{"$f":"SUM(J96:J97)","v":0},"This is the amount that can be charge IDC"]
["Sub-Contracts DÑ",null,"UNT employees can not be recipients of UNT sub-contracts and must be paid in personnel category."]
["Item",null,"Description",null,null,null,null,null,null,"Amount",null,null,null,null,"Year 1"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J101>25000,25000,J101)","v":0},1,0,{"$f":"SUM(M101,J101)","v":0},{"$f":"J101","v":0}]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J102>25000,25000,J102)","v":0},1,0,{"$f":"SUM(M102,J102)","v":0},{"$f":"J102","v":0}]
[null,null,null,null,null,"Sum of Sub-Contracts",null,null,null,{"$f":"SUM(J101:J102)","v":0},{"$f":"SUM(K101:K102)","v":0},"Year","Previous","Current"]
["Participant Support Costs D"]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[]
["Scholarship"]
["Fellowship"]
["Travel"]
["Subsistence"]
["Other"]
[null,null,null,null,null,null,0,0,null,{"$f":"G112*H112","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G113*H113","v":0}]
[null,null,null,null,null,null,null,"Sum of Participant Support Costs",null,{"$f":"SUM(J112:J113)","v":0}]
["Other-Graduate Student Tuition ",null,null,null,"Calculate Grad Tuition in this Budget Category. IDC is not assessed on tuition."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,0,0,null,{"$f":"G122*H122","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G123*H123","v":0}]
[null,null,null,null,null,null,null,"Sum of Other-Graduate Student Tuition ",null,{"$f":"SUM(J122:J123)","v":0}]
["Other-All Other Costs except Graduate Tuition DÑ"]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[]
["Patient Care Charges",null,null,null,null,null,null,null,null,null,"This is the amount that can be charge IDC"]
["Off-site Facility Rental"]
["(User Defined)"]
[null,null,null,null,null,null,0,0,null,{"$f":"G131*H131","v":0},{"$f":"IF(OR(A131=$A$128,A131=$A$129),0,J131)","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G132*H132","v":0},{"$f":"IF(OR(A132=$A$128,A132=$A$129),0,J132)","v":0}]
[null,null,null,null,null,null,null,"Sum of Other",null,{"$f":"SUM(J131:J132)","v":0},{"$f":"SUM(K131:K132)","v":0}]
["Indirect Costs"]
["IDC Type",null,"IDC rate","Documentation Location",null,"Modified Total Direct Costs (Base for F&A)",null,null,null,{"$f":"(J74+K133+J83+J93+J98+K103)","v":0}]
[]
["Research",null,{"$f":"IF($A$142=A137,IDC.R,0)","v":48.5}]
["On-Campus Other",null,{"$f":"IF($A$142=A138,IDC.On,0)","v":0}]
["Instruction",null,{"$f":"IF($A$142=A139,IDC.I,0)","v":0},{"$f":"FALSE()","v":false}]
["Off-Campus",null,{"$f":"IF($A$142=A140,IDC.Off,0)","v":0},{"$f":"TRUE()","v":true}]
["Agency Restricted",null,{"$f":"SUM(C137:C140)","v":48.5},{"$f":"IF(A142=A141,\"?\",C141)","v":48.5}]
["Research",null,{"$f":"D141","v":48.5},null,null,null,"IDC Amount",null,null,{"$f":"J135*C142/100","v":0}]
[null,null,null,null,null,"Total Direct Costs (Sponsor Direct)",null,null,null,{"$f":"SUM(J133,J114,J98,J103,J93,J88,J83,J74,J124)","v":0}]
[null,null,null,null,{"$f":"\"Total Amount Requested for \"&J1&\" Budget\"","v":"Total Amount Requested for Year 1 Budget"},null,null,null,null,{"$f":"SUM(J142:J143)","v":0}]
[]
["University of North Texas, Grants & Contracts Administration"]

{"sheet":"Year 2","index":3,"n_rows":156,"n_cols":24,"rows_kept":156,"cut":false,"hidden":false,"merged":[[138,0,138,1],[138,2,138,5],[99,6,99,7],[125,2,125,5],[110,2,110,9],[104,6,104,7],[111,2,111,5],[101,2,101,5],[100,1,100,9],[109,5,109,7],[125,0,125,1],[5,10,5,11],[29,6,29,7],[49,5,49,7],[51,7,52,7],[52,10,52,11],[50,5,50,7],[4,8,5,8],[51,8,52,8],[0,5,0,7],[1,1,1,9],[2,0,2,1],[2,2,2,3],[2,7,2,9],[0,2,0,3],[96,0,96,1],[96,2,96,5],[97,0,97,1],[107,2,107,5],[98,0,98,1],[102,0,102,1],[102,2,102,5],[97,2,97,5],[98,2,98,5],[101,0,101,1],[83,5,83,7],[84,5,84,7],[95,4,95,9],[3,0,3,4],[3,5,3,7],[92,1,92,4],[4,7,5,7],[66,6,66,7],[81,5,81,7],[82,5,82,7],[85,5,85,7],[93,1,93,4],[87,1,87,4],[94,6,94,7],[141,0,141,1],[128,0,128,1],[103,0,103,1],[103,2,103,5],[105,3,105,9],[105,0,105,2],[106,0,106,1],[106,2,106,5],[107,0,107,1],[108,0,108,1],[108,2,108,5],[124,2,124,5],[114,2,114,7],[114,0,114,1],[137,0,137,1],[137,2,137,5],[143,10,145,11],[144,0,144,1],[145,0,145,1],[143,0,143,1],[109,10,111,11],[113,0,113,1],[128,2,128,5],[113,2,113,7],[111,0,111,1],[117,0,117,1],[117,2,117,5],[124,0,124,1],[112,0,112,1],[112,2,112,7],[115,5,115,7],[141,2,141,5],[151,6,151,7],[153,4,153,7],[151,0,151,1],[151,3,151,5],[150,0,150,1],[152,5,152,7],[146,2,146,5],[147,2,147,5],[147,0,147,1],[150,3,150,4],[146,0,146,1],[150,5,150,7]]}
["File Number:",{"$f":"'Year 1'!B1","v":0},"BB version:",null,{"$f":"'Year 1'!E1","v":"FY 2021"},"This Budget is prepared for:",null,null,{"$f":"'Year 1'!I1","v":0},"Year 2"]
["Project Title:",{"$f":"'Year 1'!B2:J2","v":0}]
["Budget Prepared by:",null,{"$f":"'Year 1'!C3:D3","v":0},null,"Phone Number:",{"$f":"'Year 1'!F3","v":0},"E-mail:",{"$f":"'Year 1'!H3:J3","v":0}]
["Project Budget",null,null,null,null,"This Budget was drafted on:",null,null,{"$f":"'Year 1'!I4","v":"00:00:00"},{"$f":"'Year 1'!J4","v":"2007-09-01"}]
["Personnel",null,null,null,null,null,null,"Number of Months (Academic)","Number of Months (Summer)",null,null,null,"Personnel",null,null,null,null,"Fringe"]
["Last Name","First Name","EMPL ID#","Employee Type","Responsibility","Monthly Rate","Percent Effort (%)",null,null,"Project Salary","Rounded Number of Months",null,"Year 1","Year 2",null,null,null,"Year 1","Year 2"]
[]
[null,null,null,null,"PI"]
[null,null,null,null,"Co-PI"]
[null,null,null,null,"Senior Personnel"]
[null,null,null,null,"Research Assistant"]
[null,null,null,null,"Teaching Assistant"]
[null,null,{"$f":"FALSE()","v":false},null,"Investigator"]
[null,null,{"$f":"TRUE()","v":true},"PT Staff","Coordinator"]
[null,null,null,"PT Faculty","Technician"]
[null,null,null,"Hourly","Post Doc"]
[null,null,null,"Faculty","Clerical"]
[null,null,null,"Staff","Programmer"]
[{"$f":"'Year 1'!A19","v":0},{"$f":"'Year 1'!B19","v":0},{"$f":"'Year 1'!C19","v":0},{"$f":"'Year 1'!D19","v":0},{"$f":"'Year 1'!E19","v":0},{"$f":"'Year 1'!F19*(100+Living)/100","v":0},0,0,0,{"$f":"F19*((G19*H19)/100+(G19*I19)/100)","v":0},{"$f":"ROUNDUP(H19+I19,0)","v":0},null,{"$f":"'Year 1'!M19","v":0},{"$f":"J19","v":0},null,null,null,{"$f":"'Year 1'!R19","v":0},{"$f":"J39","v":0}]
[{"$f":"'Year 1'!A20","v":0},{"$f":"'Year 1'!B20","v":0},{"$f":"'Year 1'!C20","v":0},{"$f":"'Year 1'!D20","v":0},{"$f":"'Year 1'!E20","v":0},{"$f":"'Year 1'!F20*(100+Living)/100","v":0},0,0,0,{"$f":"F20*((G20*H20)/100+(G20*I20)/100)","v":0},0,null,{"$f":"'Year 1'!M20","v":0},0,null,null,null,{"$f":"'Year 1'!R20","v":0},{"$f":"J39","v":0}]
[{"$f":"'Year 1'!A21","v":0},{"$f":"'Year 1'!B21","v":0},{"$f":"'Year 1'!C21","v":0},{"$f":"'Year 1'!D21","v":0},{"$f":"'Year 1'!E21","v":0},{"$f":"'Year 1'!F21*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 1'!M21","v":0},0,null,null,null,{"$f":"'Year 1'!R21","v":0},{"$f":"J40","v":0}]
[{"$f":"'Year 1'!A22","v":0},{"$f":"'Year 1'!B22","v":0},{"$f":"'Year 1'!C22","v":0},{"$f":"'Year 1'!D22","v":0},{"$f":"'Year 1'!E22","v":0},{"$f":"'Year 1'!F22*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 1'!M22","v":0},0,null,null,null,{"$f":"'Year 1'!R22","v":0},{"$f":"J41","v":0}]
[{"$f":"'Year 1'!A23","v":0},{"$f":"'Year 1'!B23","v":0},{"$f":"'Year 1'!C23","v":0},{"$f":"'Year 1'!D23","v":0},{"$f":"'Year 1'!E23","v":0},{"$f":"'Year 1'!F23*(100+Living)/100","v":0},0,0,0,{"$f":"F23*((G23*H23)/100+(G23*I23)/100)","v":0},{"$f":"ROUNDUP(H23+I23,0)","v":0},null,{"$f":"'Year 1'!M23","v":0},{"$f":"J23","v":0},null,null,null,{"$f":"'Year 1'!R23","v":0},{"$f":"J42","v":0}]
[{"$f":"'Year 1'!A24","v":0},{"$f":"'Year 1'!B24","v":0},{"$f":"'Year 1'!C24","v":0},{"$f":"'Year 1'!D24","v":0},{"$f":"'Year 1'!E24","v":0},{"$f":"'Year 1'!F24*(100+Living)/100","v":0},0,0,0,{"$f":"F24*((G24*H24)/100+(G24*I24)/100)","v":0},{"$f":"ROUNDUP(H24+I24,0)","v":0},null,{"$f":"'Year 1'!M24","v":0},{"$f":"J24","v":0},null,null,null,{"$f":"'Year 1'!R24","v":0},{"$f":"J43","v":0}]
[{"$f":"'Year 1'!A25","v":0},{"$f":"'Year 1'!B25","v":0},{"$f":"'Year 1'!C25","v":0},{"$f":"'Year 1'!D25","v":0},{"$f":"'Year 1'!E25","v":0},{"$f":"'Year 1'!F25*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 1'!M25","v":0},0,null,null,null,{"$f":"'Year 1'!R25","v":0},{"$f":"J45","v":0}]
[0,0,0,0,0,0,0,0,0,{"$f":"F26*((G26*H26)/100+(G26*I26)/100)","v":0},{"$f":"ROUNDUP(H26+I26,0)","v":0},null,{"$f":"'Year 1'!M25","v":0},{"$f":"J26","v":0},null,null,null,{"$f":"'Year 1'!R25","v":0},{"$f":"J45","v":0}]
[0,0,0,0,0,0,0,0,0,{"$f":"F27*((G27*H27)/100+(G27*I27)/100)","v":0},{"$f":"ROUNDUP(H27+I27,0)","v":0},null,{"$f":"'Year 1'!M25","v":0},{"$f":"J27","v":0},null,null,null,{"$f":"'Year 1'!R25","v":0},{"$f":"J46","v":0}]
[0,0,0,0,0,0,0,0,0,{"$f":"F28*((G28*H28)/100+(G28*I28)/100)","v":0},{"$f":"ROUNDUP(H28+I28,0)","v":0},null,{"$f":"'Year 1'!M25","v":0},{"$f":"J28","v":0},null,null,null,{"$f":"'Year 1'!R25","v":0},{"$f":"J47","v":0}]
[0,0,0,0,0,0,0,0,0,{"$f":"F29*((G29*H29)/100+(G29*I29)/100)","v":0},0,null,{"$f":"'Year 1'!M26","v":0},0,null,null,null,{"$f":"'Year 1'!R26","v":0},{"$f":"J49","v":0}]
[null,null,null,null,null,null,"Sum of Personnel",null,null,{"$f":"SUM(J19:J29)","v":0}]
["Fringe Benefits for Personnel"]
["Last Name","First Name","EMPL ID#","Retirement","Insurance Type","Other Support","Hire Date","Fringe Rate",null,"Fringe Benefit Totals","Fringe Rates before 9-1-95",null,null,null,"Fringe Rates after 9-1-95",null,null,null,"Insurance and Longevity Calculations"]
[]
[null,null,null,null,"None"]
[null,null,null,null,"Employee"]
[null,null,null,"Hourly","Spouse"]
[null,null,null,"ORP","Children","Yes"]
[null,null,null,"TRS","Family","No",null,null,null,null,"Hourly","ORP","TRS","F1 Sum","Hourly","ORP","TRS","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[{"$f":"'Year 1'!A35","v":0},{"$f":"'Year 1'!B35","v":0},{"$f":"'Year 1'!C35","v":0},{"$f":"'Year 1'!D35","v":"TRS"},{"$f":"'Year 1'!E35","v":"Employee"},{"$f":"'Year 1'!F35","v":"Yes"},{"$f":"'Year 1'!G35","v":"2007-09-01"},{"$f":"IF(G39>Fringe1End,R39,N39)","v":15.15},null,{"$f":"(J19*H39/100)+X39","v":0},{"$f":"IF(D39=$D$36,F1.Hourly,0)","v":0},{"$f":"IF(D39=$D$37,F1.FS.ORP,0)","v":0},{"$f":"IF(D39=$D$38,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K39:M39)","v":21.4},{"$f":"IF(D39=$D$36,F2.Hourly,0)","v":0},{"$f":"IF(D39=$D$37,F2.FS.ORP,0)","v":0},{"$f":"IF(D39=$D$38,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O39:Q39)","v":15.15},{"$f":"IF(F39=$F$37,G19,100)","v":0},{"$f":"IF($E39=$E$35,IF($D19=$D$14,Ins.PT.E*$K19*S39/100,IF($D19=$D$15,Ins.PT.E*$K19*S39/100,Ins.E*$K19*S39/100)),0)","v":0},{"$f":"IF($E39=$E$36,IF($D19=$D$14,Ins.PT.S*$K19*S39/100,IF($D19=$D$15,Ins.PT.S*$K19*S39/100,Ins.S*$K19*S39/100)),0)","v":0},{"$f":"IF($E39=$E$37,IF($D19=$D$14,Ins.PT.C*$K19*S39/100,IF($D19=$D$15,Ins.PT.C*$K19*S39/100,Ins.C*$K19*S39/100)),0)","v":0},{"$f":"IF($E39=$E$38,IF($D19=$D$14,Ins.PT.F*$K19*S39/100,IF($D19=$D$15,Ins.PT.F*$K19*S39/100,Ins.F*$K19*S39/100)),0)","v":0},{"$f":"IF(D19=$D$18,ROUNDDOWN(DAYS360(G39,$J$4)/(360*Long.Per),0)*20*K19*G19/100,0)+SUM(T39:W39)","v":0}]
[{"$f":"'Year 1'!A36","v":0},{"$f":"'Year 1'!B36","v":0},{"$f":"'Year 1'!C36","v":0},{"$f":"'Year 1'!D36","v":"TRS"},{"$f":"'Year 1'!E36","v":"Employee"},{"$f":"'Year 1'!F36","v":"Yes"},{"$f":"'Year 1'!G36","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 1'!A37","v":0},{"$f":"'Year 1'!B37","v":0},{"$f":"'Year 1'!C37","v":0},{"$f":"'Year 1'!D37","v":"TRS"},{"$f":"'Year 1'!E37","v":"Employee"},{"$f":"'Year 1'!F37","v":"Yes"},{"$f":"'Year 1'!G37","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 1'!A38","v":0},{"$f":"'Year 1'!B38","v":0},{"$f":"'Year 1'!C38","v":0},{"$f":"'Year 1'!D38","v":"TRS"},{"$f":"'Year 1'!E38","v":"Employee"},{"$f":"'Year 1'!F38","v":"Yes"},{"$f":"'Year 1'!G38","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 1'!A39","v":0},{"$f":"'Year 1'!B39","v":0},{"$f":"'Year 1'!C39","v":0},{"$f":"'Year 1'!D39","v":"TRS"},{"$f":"'Year 1'!E39","v":"Employee"},{"$f":"'Year 1'!F39","v":"Yes"},{"$f":"'Year 1'!G39","v":"2007-09-01"},{"$f":"IF(G43>Fringe1End,R43,N43)","v":15.15},null,0,{"$f":"IF(D43=$D$36,F1.Hourly,0)","v":0},{"$f":"IF(D43=$D$37,F1.FS.ORP,0)","v":0},{"$f":"IF(D43=$D$38,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K43:M43)","v":21.4},{"$f":"IF(D43=$D$36,F2.Hourly,0)","v":0},{"$f":"IF(D43=$D$37,F2.FS.ORP,0)","v":0},{"$f":"IF(D43=$D$38,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O43:Q43)","v":15.15},0,0,0,0,0,0]
[{"$f":"'Year 1'!A40","v":0},{"$f":"'Year 1'!B40","v":0},{"$f":"'Year 1'!C40","v":0},{"$f":"'Year 1'!D40","v":"TRS"},{"$f":"'Year 1'!E40","v":"Employee"},{"$f":"'Year 1'!F40","v":"Yes"},{"$f":"'Year 1'!G40","v":"2007-09-01"},{"$f":"IF(G44>Fringe1End,R44,N44)","v":15.15},null,0,{"$f":"IF(D44=$D$36,F1.Hourly,0)","v":0},{"$f":"IF(D44=$D$37,F1.FS.ORP,0)","v":0},{"$f":"IF(D44=$D$38,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K44:M44)","v":21.4},{"$f":"IF(D44=$D$36,F2.Hourly,0)","v":0},{"$f":"IF(D44=$D$37,F2.FS.ORP,0)","v":0},{"$f":"IF(D44=$D$38,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O44:Q44)","v":15.15},0,0,0,0,0,0]
[{"$f":"'Year 1'!A41","v":0},{"$f":"'Year 1'!B41","v":0},{"$f":"'Year 1'!C41","v":0},{"$f":"'Year 1'!D41","v":"TRS"},{"$f":"'Year 1'!E41","v":"Employee"},{"$f":"'Year 1'!F41","v":"Yes"},{"$f":"'Year 1'!G41","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"A26","v":0},0,0,{"$f":"IF($D26=$D$16,$D$36,$D$38)","v":"TRS"},{"$f":"IF($D26=$D$16,$E$34,$E$35)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},{"$f":"IF(G46>Fringe1End,R46,N46)","v":15.15},null,0,{"$f":"IF(D46=$D$36,F1.Hourly,0)","v":0},{"$f":"IF(D46=$D$37,F1.FS.ORP,0)","v":0},{"$f":"IF(D46=$D$38,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K46:M46)","v":21.4},{"$f":"IF(D46=$D$36,F2.Hourly,0)","v":0},{"$f":"IF(D46=$D$37,F2.FS.ORP,0)","v":0},{"$f":"IF(D46=$D$38,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O46:Q46)","v":15.15},100,0,0,0,0,0]
[0,0,0,{"$f":"IF($D27=$D$16,$D$36,$D$38)","v":"TRS"},{"$f":"IF($D27=$D$16,$E$34,$E$35)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},{"$f":"IF(G47>Fringe1End,R47,N47)","v":15.15},null,0,{"$f":"IF(D47=$D$36,F1.Hourly,0)","v":0},{"$f":"IF(D47=$D$37,F1.FS.ORP,0)","v":0},{"$f":"IF(D47=$D$38,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K47:M47)","v":21.4},{"$f":"IF(D47=$D$36,F2.Hourly,0)","v":0},{"$f":"IF(D47=$D$37,F2.FS.ORP,0)","v":0},{"$f":"IF(D47=$D$38,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O47:Q47)","v":15.15},100,0,0,0,0,0]
[{"$f":"A28","v":0},0,0,{"$f":"IF($D28=$D$16,$D$36,$D$38)","v":"TRS"},{"$f":"IF($D28=$D$16,$E$34,$E$35)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},{"$f":"IF(G48>Fringe1End,R48,N48)","v":15.15},null,0,{"$f":"IF(D48=$D$36,F1.Hourly,0)","v":0},{"$f":"IF(D48=$D$37,F1.FS.ORP,0)","v":0},{"$f":"IF(D48=$D$38,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K48:M48)","v":21.4},{"$f":"IF(D48=$D$36,F2.Hourly,0)","v":0},{"$f":"IF(D48=$D$37,F2.FS.ORP,0)","v":0},{"$f":"IF(D48=$D$38,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O48:Q48)","v":15.15},100,0,0,0,0,0]
[0,0,0,{"$f":"IF($D29=$D$16,$D$36,$D$38)","v":"TRS"},{"$f":"IF($D29=$D$16,$E$34,$E$35)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[null,null,null,null,null,"Sum of Fringe Benefits for Personnel",null,null,null,{"$f":"SUM(J39:J49)","v":0},"Hourly","ORP","TRS","F1 Sum","Hourly","ORP","TRS","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[null,null,null,null,null,"Sum of Personnel and Fringe Benefits",null,null,null,{"$f":"J30+J50","v":0}]
["Students",null,null,null,null,null,null,"Number of Months (Academic)","Number of Months\n(Summer)",null,null,null,"Students",null,null,null,null,"Fringe"]
["Last Name","First Name","EMPL ID#","Student Type","Responsibility","Monthly Rate","Percent Effort (%)",null,null,"Project Salary","Rounded Number of Months",null,"Year 1","Year 2",null,null,null,"Year 1","Year 2"]
[]
[]
[null,null,null,{"$f":"FALSE()","v":false}]
[null,null,null,{"$f":"TRUE()","v":true}]
[null,null,null,null,"Clerical"]
[null,null,null,"Graduate","Programmer"]
[null,null,null,"Undergrad","Research Assistant"]
[{"$f":"'Year 1'!A53","v":0},{"$f":"'Year 1'!B53","v":0},{"$f":"'Year 1'!C53","v":0},{"$f":"'Year 1'!D53","v":"Graduate"},{"$f":"'Year 1'!E53","v":0},{"$f":"'Year 1'!F53*(100+Living)/100","v":0},0,0,0,{"$f":"F61*((G61*H61)/100+(G61*I61)/100)","v":0},{"$f":"ROUNDUP(H61+I61,0)","v":0},null,{"$f":"'Year 1'!M53","v":0},{"$f":"J61","v":0},null,null,null,{"$f":"'Year 1'!R53","v":0},{"$f":"J76","v":0}]
[{"$f":"'Year 1'!A54","v":0},{"$f":"'Year 1'!B54","v":0},{"$f":"'Year 1'!C54","v":0},{"$f":"'Year 1'!D54","v":"Graduate"},{"$f":"'Year 1'!E54","v":0},{"$f":"'Year 1'!F54*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 1'!M54","v":0},0,null,null,null,{"$f":"'Year 1'!R54","v":0},{"$f":"J76","v":0}]
[{"$f":"'Year 1'!A55","v":0},{"$f":"'Year 1'!B55","v":0},{"$f":"'Year 1'!C55","v":0},{"$f":"'Year 1'!D55","v":"Graduate"},{"$f":"'Year 1'!E55","v":0},{"$f":"'Year 1'!F55*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 1'!M55","v":0},0,null,null,null,{"$f":"'Year 1'!R55","v":0},{"$f":"J77","v":0}]
[{"$f":"'Year 1'!A56","v":0},{"$f":"'Year 1'!B56","v":0},{"$f":"'Year 1'!C56","v":0},{"$f":"'Year 1'!D56","v":"Graduate"},{"$f":"'Year 1'!E56","v":0},{"$f":"'Year 1'!F56*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 1'!M56","v":0},0,null,null,null,{"$f":"'Year 1'!R56","v":0},{"$f":"J79","v":0}]
[0,0,0,"Graduate",0,0,0,0,0,0,0,null,0,0,null,null,null,0,{"$f":"J79","v":0}]
[0,0,0,"Graduate",0,0,0,0,0,0,0,null,0,0,null,null,null,0,{"$f":"J81","v":0}]
[null,null,null,null,null,null,"Sum of Students",null,null,{"$f":"SUM(J61:J66)","v":0}]
["Fringe Benefits for Students"]
["Last Name","First Name","EMPL ID#","Student Type","Insurance Type","Other Support","Hire Date","Fringe Rate",null,"Fringe Benefit Totals","Fringe Rates before 9-1-95",null,null,"Fringe Rates after 9-1-95",null,null,"Insurance and Longevity Calculations"]
[]
[null,null,null,null,"None"]
[null,null,null,null,"Employee"]
[null,null,null,"None","Spouse"]
[null,null,null,"ORP","Children","Yes"]
[null,null,null,"TRS","Family","No",null,null,null,null,"Grad","Under","F1 Sum","Grad","Under","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[{"$f":"'Year 1'!A66","v":0},{"$f":"'Year 1'!B66","v":0},{"$f":"'Year 1'!C66","v":0},{"$f":"'Year 1'!D66","v":"Graduate"},{"$f":"'Year 1'!E66","v":"Employee"},{"$f":"'Year 1'!F66","v":"No"},{"$f":"'Year 1'!G66","v":"2007-09-01"},{"$f":"IF(G76>Fringe1End,P76,M76)","v":7.65},null,{"$f":"(J61*H76/100)+V76","v":0},{"$f":"IF(D61=$D$59,F1.Grad,0)","v":7.65},{"$f":"IF(D61=$D$60,F1.Under,0)","v":0},{"$f":"SUM(K76:L76)","v":7.65},{"$f":"IF(D61=$D$59,F2.Grad,0)","v":7.65},{"$f":"IF(D61=$D$60,F2.Under,0)","v":0},{"$f":"SUM(N76:O76)","v":7.65},{"$f":"IF(F76=$F$74,G61,100)","v":100},{"$f":"IF($E76=$E$72,Ins.PT.E*$K61*Q76/100,0)","v":0},{"$f":"IF($E76=$E$73,Ins.PT.S*$K61*Q76/100,0)","v":0},{"$f":"IF($E76=$E$74,Ins.PT.C*$K61*Q76/100,0)","v":0},{"$f":"IF($E76=$E$75,Ins.PT.F*$K61*Q76/100,0)","v":0},{"$f":"SUM(R76:U76)","v":0}]
[{"$f":"'Year 1'!A67","v":0},{"$f":"'Year 1'!B67","v":0},{"$f":"'Year 1'!C67","v":0},{"$f":"'Year 1'!D67","v":"Graduate"},{"$f":"'Year 1'!E67","v":"Employee"},{"$f":"'Year 1'!F67","v":"No"},{"$f":"'Year 1'!G67","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"'Year 1'!A68","v":0},{"$f":"'Year 1'!B68","v":0},{"$f":"'Year 1'!C68","v":0},{"$f":"'Year 1'!D68","v":"Graduate"},{"$f":"'Year 1'!E68","v":"Employee"},{"$f":"'Year 1'!F68","v":"No"},{"$f":"'Year 1'!G68","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"'Year 1'!A69","v":0},{"$f":"'Year 1'!B69","v":0},{"$f":"'Year 1'!C69","v":0},{"$f":"'Year 1'!D69","v":"Graduate"},{"$f":"'Year 1'!E69","v":"Employee"},{"$f":"'Year 1'!F69","v":"No"},{"$f":"'Year 1'!G69","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"A65","v":0},0,0,"Graduate",{"$f":"IF($D65=$D$59,$E$72,$E$71)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[0,0,0,"Graduate",{"$f":"IF($D66=$D$59,$E$72,$E$71)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[null,null,null,null,null,"Sum of Fringe Benefits for Students",null,null,null,{"$f":"SUM(J76:J81)","v":0},"Grad","Under","F1 Sum","Grad","Under","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[null,null,null,null,null,"Sum of Students and Fringe Benefits",null,null,null,{"$f":"J67+J82","v":0}]
[null,null,null,null,null,"Sum of Salary",null,null,null,{"$f":"J30+J67","v":0}]
[null,null,null,null,null,"Sum of Fringe Benefits",null,null,null,{"$f":"J50+J82","v":0}]
[null,null,null,null,null,"Sum of Personnel and Students",null,null,null,{"$f":"SUM(J84:J85)","v":0}]
["Travel"]
["Component","Description",null,null,null,"Location","Date","Destination",null,"Cost"]
[]
["Transportation",null,null,null,null,"In-State"]
["Meals",null,null,null,null,"Out-of-State"]
["Lodging",null,null,null,null,"Foreign"]
[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,"Sum of Travel",null,null,{"$f":"SUM(J93:J94)","v":0}]
["Capital Expenditures/Equipment D",null,null,null,"These items individually are OVER $5,000."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G98*H98","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G99*H99","v":0}]
[null,null,null,null,null,null,"Sum of Equipment",null,null,{"$f":"SUM(J98:J99)","v":0}]
["Supplies","These items individually are UNDER $5,000."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G103*H103","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G104*H104","v":0}]
[null,null,null,null,null,null,"Sum of Supplies",null,null,{"$f":"SUM(J103:J104)","v":0}]
["Publication Charges",null,null,"For the typical activities included in this category, hold mouse over the cell to the left."]
["Item",null,"Description",null,null,null,"Price","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G108*H108","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G109*H109","v":0}]
[null,null,null,null,null,"Sum of Publication/Printing Charges",null,null,null,{"$f":"SUM(J108:J109)","v":0},"This is the amount that can be charge IDC"]
["Sub-Contracts DÑ",null,"UNT employees can not be recipients of UNT sub-contracts and must be paid in personnel category."]
["Item",null,"Description",null,null,null,null,null,null,"Amount",null,null,null,null,"Year 1","Year 2"]
[{"$f":"'Year 1'!A101:B101","v":0},null,{"$f":"'Year 1'!C101:H101","v":0},null,null,null,null,null,null,0,{"$f":"IF(M113+J113>25000,IF(M113>=25000,0,25000-M113),J113)","v":0},1,{"$f":"'Year 1'!N101","v":0},{"$f":"SUM(M113,J113)","v":0},{"$f":"'Year 1'!O101","v":0},{"$f":"J113","v":0}]
[{"$f":"'Year 1'!A102:B102","v":0},null,{"$f":"'Year 1'!C102:H102","v":0},null,null,null,null,null,null,0,{"$f":"IF(M114+J114>25000,IF(M114>=25000,0,25000-M114),J114)","v":0},1,{"$f":"'Year 1'!N102","v":0},{"$f":"SUM(M114,J114)","v":0},{"$f":"'Year 1'!O102","v":0},{"$f":"J114","v":0}]
[0,null,null,null,null,null,null,null,null,0,{"$f":"IF(M115+J115>25000,IF(M115>=25000,0,25000-M115),J115)","v":0},2,0,{"$f":"SUM(M115,J115)","v":0},0,{"$f":"J115","v":0}]
[null,null,null,null,null,"Sum of Sub-Contracts",null,null,null,{"$f":"SUM(J113:J115)","v":0},{"$f":"SUM(K113:K115)","v":0},"Year","Previous","Current"]
["Participant Support Costs D"]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[]
["Scholarship"]
["Fellowship"]
["Travel"]
["Subsistence"]
["Other"]
[null,null,null,null,null,null,0,0,null,{"$f":"G125*H125","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G126*H126","v":0}]
[null,null,null,null,null,null,null,"Sum of Participant Support Costs",null,{"$f":"SUM(J125:J126)","v":0}]
["Other-Graduate Student Tuition  D",null,null,null,"Calculate Grad Tuition in this Budget Category. IDC is not assessed on tuition."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,0,0,null,{"$f":"G138*H138","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G139*H139","v":0}]
[null,null,null,null,null,null,null,"Sum of Other-Graduate Student Tuition ",null,{"$f":"SUM(J138:J139)","v":0}]
["Other-All Other Costs except Graduate Tuition DÑ"]
["Item",null,"Description",null,null,null,"Price","Quantity",null,"Cost"]
[]
["Patient Care Charges",null,null,null,null,null,null,null,null,null,"This is the amount that can be charge IDC"]
["Off-site Facility Rental"]
["(User Defined)"]
[null,null,null,null,null,null,0,0,null,{"$f":"G147*H147","v":0},{"$f":"IF(OR(A147=$A$144,A147=$A$145),0,J147)","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G148*H148","v":0},{"$f":"IF(OR(A148=$A$144,A148=$A$145),0,J148)","v":0}]
[null,null,null,null,null,null,null,"Sum of Other",null,{"$f":"SUM(J147:J148)","v":0},{"$f":"SUM(K147:K148)","v":0}]
["Indirect Costs"]
["IDC Type",null,"IDC rate","Documentation Location",null,"Modified Total Direct Costs (Base for F&A)",null,null,null,{"$f":"(J86+J95+J105+J110+K116+K149)","v":0}]
[{"$f":"'Year 1'!A142:B142","v":"Research"},null,{"$f":"'Year 1'!C142","v":48.5},{"$f":"'Year 1'!D142:F142","v":0},null,null,"IDC Amount",null,null,{"$f":"J151*C152/100","v":0}]
[null,null,null,null,null,"Total Direct Costs (Sponsor Direct)",null,null,null,{"$f":"SUM(J116,J149,J127,J110,J105,J100,J95,J86,J140)","v":0}]
[null,null,null,null,{"$f":"\"Total Amount Requested for \"&J1&\" Budget\"","v":"Total Amount Requested for Year 2 Budget"},null,null,null,null,{"$f":"SUM(J152:J153)","v":0}]
[]
["University of North Texas, Grants & Contracts Administration"]

{"sheet":"Year 3","index":4,"n_rows":163,"n_cols":24,"rows_kept":163,"cut":false,"hidden":false,"merged":[[117,10,119,11],[106,2,106,5],[111,2,111,5],[112,6,112,7],[107,6,107,7],[116,2,116,5],[114,2,114,5],[117,5,117,7],[5,10,5,11],[32,6,32,7],[55,5,55,7],[57,7,58,7],[58,10,58,11],[56,5,56,7],[57,8,58,8],[119,0,119,1],[0,5,0,7],[102,6,102,7],[104,2,104,5],[4,7,5,7],[93,5,93,7],[91,5,91,7],[92,5,92,7],[0,2,0,3],[100,1,100,4],[101,1,101,4],[104,0,104,1],[1,1,1,9],[89,5,89,7],[73,6,73,7],[90,5,90,7],[2,0,2,1],[2,2,2,3],[2,7,2,9],[3,0,3,4],[4,8,5,8],[3,5,3,7],[124,5,124,7],[145,0,145,1],[137,2,137,5],[120,2,120,7],[105,2,105,5],[134,0,134,1],[116,0,116,1],[118,2,118,9],[119,2,119,5],[115,0,115,1],[115,2,115,5],[108,1,108,9],[121,0,121,1],[121,2,121,7],[120,0,120,1],[114,0,114,1],[103,4,103,9],[95,1,95,4],[110,2,110,5],[113,0,113,2],[113,3,113,9],[106,0,106,1],[105,0,105,1],[109,0,109,1],[109,2,109,5],[110,0,110,1],[111,0,111,1],[150,10,152,11],[151,0,151,1],[152,0,152,1],[150,0,150,1],[122,0,122,1],[144,0,144,1],[122,2,122,7],[148,2,148,5],[133,0,133,1],[145,2,145,5],[123,0,123,1],[123,2,123,7],[133,2,133,5],[126,0,126,1],[126,2,126,5],[148,0,148,1],[160,4,160,7],[158,0,158,1],[137,0,137,1],[157,0,157,1],[153,2,153,5],[154,2,154,5],[158,6,158,7],[157,3,157,4],[157,5,157,7],[159,5,159,7],[154,0,154,1],[158,3,158,5],[144,2,144,5],[153,0,153,1]]}
["File Number:",{"$f":"'Year 1'!B1","v":0},"BB version:",null,{"$f":"'Year 1'!E1","v":"FY 2021"},"This Budget is prepared for:",null,null,{"$f":"'Year 1'!I1","v":0},"Year 3"]
["Project Title:",{"$f":"'Year 1'!B2:J2","v":0}]
["Budget Prepared by:",null,{"$f":"'Year 1'!C3:D3","v":0},null,"Phone Number:",{"$f":"'Year 1'!F3","v":0},"E-mail:",{"$f":"'Year 1'!H3:J3","v":0}]
["Project Budget",null,null,null,null,"This Budget was drafted on:",null,null,{"$f":"'Year 1'!I4","v":"00:00:00"},{"$f":"'Year 1'!J4","v":"2007-09-01"}]
["Personnel",null,null,null,null,null,null,"Number of Months (Academic)","Number of Months (Summer)",null,null,null,"Personnel",null,null,null,null,"Fringe"]
["Last Name","First Name","EMPL ID#","Employee Type","Responsibility","Monthly Rate","Percent Effort (%)",null,null,"Project Salary","Rounded Number of Months",null,"Year 1","Year 2","Year 3",null,null,"Year 1","Year 2","Year 3"]
[]
[null,null,null,null,"PI"]
[null,null,null,null,"Co-PI"]
[null,null,null,null,"Senior Personnel"]
[null,null,null,null,"Research Assistant"]
[null,null,null,null,"Teaching Assistant"]
[null,null,{"$f":"FALSE()","v":false},null,"Investigator"]
[null,null,{"$f":"TRUE()","v":true},"PT Staff","Coordinator"]
[null,null,null,"PT Faculty","Technician"]
[null,null,null,"Hourly","Post Doc"]
[null,null,null,"Faculty","Clerical"]
[null,null,null,"Staff","Programmer"]
[{"$f":"'Year 2'!A19","v":0},{"$f":"'Year 2'!B19","v":0},{"$f":"'Year 2'!C19","v":0},{"$f":"'Year 2'!D19","v":0},{"$f":"'Year 2'!E19","v":0},{"$f":"'Year 2'!F19*(100+Living)/100","v":0},0,0,0,{"$f":"F19*((G19*H19)/100+(G19*I19)/100)","v":0},{"$f":"ROUNDUP(H19+I19,0)","v":0},null,{"$f":"'Year 2'!M19","v":0},{"$f":"'Year 2'!N19","v":0},{"$f":"J19","v":0},null,null,{"$f":"'Year 2'!R19","v":0},{"$f":"'Year 2'!J39","v":0},{"$f":"J42","v":0}]
[{"$f":"'Year 2'!A20","v":0},{"$f":"'Year 2'!B20","v":0},{"$f":"'Year 2'!C20","v":0},{"$f":"'Year 2'!D20","v":0},{"$f":"'Year 2'!E20","v":0},{"$f":"'Year 2'!F20*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H20+I20,0)","v":0},null,{"$f":"'Year 2'!M20","v":0},{"$f":"'Year 2'!N20","v":0},0,null,null,{"$f":"'Year 2'!R20","v":0},{"$f":"'Year 2'!J40","v":0},{"$f":"J42","v":0}]
[{"$f":"'Year 2'!A21","v":0},{"$f":"'Year 2'!B21","v":0},{"$f":"'Year 2'!C21","v":0},{"$f":"'Year 2'!D21","v":0},{"$f":"'Year 2'!E21","v":0},{"$f":"'Year 2'!F21*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 2'!M21","v":0},{"$f":"'Year 2'!N21","v":0},0,null,null,{"$f":"'Year 2'!R21","v":0},{"$f":"'Year 2'!J41","v":0},{"$f":"J43","v":0}]
[{"$f":"'Year 2'!A22","v":0},{"$f":"'Year 2'!B22","v":0},{"$f":"'Year 2'!C22","v":0},{"$f":"'Year 2'!D22","v":0},{"$f":"'Year 2'!E22","v":0},{"$f":"'Year 2'!F22*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 2'!M22","v":0},{"$f":"'Year 2'!N22","v":0},0,null,null,{"$f":"'Year 2'!R22","v":0},{"$f":"'Year 2'!J42","v":0},{"$f":"J44","v":0}]
[{"$f":"'Year 2'!A23","v":0},{"$f":"'Year 2'!B23","v":0},{"$f":"'Year 2'!C23","v":0},{"$f":"'Year 2'!D23","v":0},{"$f":"'Year 2'!E23","v":0},{"$f":"'Year 2'!F23*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H23+I23,0)","v":0},null,{"$f":"'Year 2'!M23","v":0},{"$f":"'Year 2'!N23","v":0},0,null,null,{"$f":"'Year 2'!R23","v":0},{"$f":"'Year 2'!J43","v":0},{"$f":"J45","v":0}]
[{"$f":"'Year 2'!A24","v":0},{"$f":"'Year 2'!B24","v":0},{"$f":"'Year 2'!C24","v":0},{"$f":"'Year 2'!D24","v":0},{"$f":"'Year 2'!E24","v":0},{"$f":"'Year 2'!F24*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H24+I24,0)","v":0},null,{"$f":"'Year 2'!M24","v":0},{"$f":"'Year 2'!N24","v":0},0,null,null,{"$f":"'Year 2'!R24","v":0},{"$f":"'Year 2'!J44","v":0},{"$f":"J46","v":0}]
[{"$f":"'Year 2'!A25","v":0},{"$f":"'Year 2'!B25","v":0},{"$f":"'Year 2'!C25","v":0},{"$f":"'Year 2'!D25","v":0},{"$f":"'Year 2'!E25","v":0},{"$f":"'Year 2'!F25*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 2'!M25","v":0},{"$f":"'Year 2'!N25","v":0},0,null,null,{"$f":"'Year 2'!R25","v":0},{"$f":"'Year 2'!J45","v":0},{"$f":"J48","v":0}]
[{"$f":"'Year 2'!A26","v":0},{"$f":"'Year 2'!B26","v":0},{"$f":"'Year 2'!C26","v":0},{"$f":"'Year 2'!D26","v":0},{"$f":"'Year 2'!E26","v":0},{"$f":"'Year 2'!F26*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H26+I26,0)","v":0},null,{"$f":"'Year 2'!M26","v":0},{"$f":"'Year 2'!N26","v":0},0,null,null,{"$f":"'Year 2'!R26","v":0},{"$f":"'Year 2'!J46","v":0},{"$f":"J48","v":0}]
[{"$f":"'Year 2'!A27","v":0},{"$f":"'Year 2'!B27","v":0},{"$f":"'Year 2'!C27","v":0},{"$f":"'Year 2'!D27","v":0},{"$f":"'Year 2'!E27","v":0},{"$f":"'Year 2'!F27*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H27+I27,0)","v":0},null,{"$f":"'Year 2'!M27","v":0},{"$f":"'Year 2'!N27","v":0},0,null,null,{"$f":"'Year 2'!R27","v":0},{"$f":"'Year 2'!J47","v":0},{"$f":"J49","v":0}]
[{"$f":"'Year 2'!A28","v":0},{"$f":"'Year 2'!B28","v":0},{"$f":"'Year 2'!C28","v":0},{"$f":"'Year 2'!D28","v":0},{"$f":"'Year 2'!E28","v":0},{"$f":"'Year 2'!F28*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H28+I28,0)","v":0},null,{"$f":"'Year 2'!M28","v":0},{"$f":"'Year 2'!N28","v":0},0,null,null,{"$f":"'Year 2'!R28","v":0},{"$f":"'Year 2'!J48","v":0},{"$f":"J50","v":0}]
[{"$f":"'Year 2'!A29","v":0},{"$f":"'Year 2'!B29","v":0},{"$f":"'Year 2'!C29","v":0},{"$f":"'Year 2'!D29","v":0},{"$f":"'Year 2'!E29","v":0},{"$f":"'Year 2'!F29*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 2'!M29","v":0},{"$f":"'Year 2'!N29","v":0},0,null,null,{"$f":"'Year 2'!R29","v":0},{"$f":"'Year 2'!J49","v":0},{"$f":"J52","v":0}]
[0,0,0,0,0,0,0,0,0,0,{"$f":"ROUNDUP(H30+I30,0)","v":0},null,0,0,0,null,null,0,0,{"$f":"J52","v":0}]
[0,0,0,0,0,0,0,0,0,0,{"$f":"ROUNDUP(H31+I31,0)","v":0},null,0,0,0,null,null,0,0,{"$f":"J53","v":0}]
[0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,null,0,0,{"$f":"J55","v":0}]
[null,null,null,null,null,null,"Sum of Personnel",null,null,{"$f":"SUM(J19:J32)","v":0}]
["Fringe Benefits for Personnel"]
["Last Name","First Name","EMPL ID#","Retirement","Insurance Type","Other Support","Hire Date","Fringe Rate",null,"Fringe Benefit Totals","Fringe Rates before 9-1-95",null,null,null,"Fringe Rates after 9-1-95",null,null,null,"Insurance and Longevity Calculations"]
[]
[null,null,null,null,"None"]
[null,null,null,null,"Employee"]
[null,null,null,"Hourly","Spouse"]
[null,null,null,"ORP","Children","Yes"]
[null,null,null,"TRS","Family","No",null,null,null,null,"Hourly","ORP","TRS","F1 Sum","Hourly","ORP","TRS","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[{"$f":"'Year 2'!A39","v":0},{"$f":"'Year 2'!B39","v":0},{"$f":"'Year 2'!C39","v":0},{"$f":"'Year 2'!D39","v":"TRS"},{"$f":"'Year 2'!E39","v":"Employee"},{"$f":"'Year 2'!F39","v":"Yes"},{"$f":"'Year 2'!G39","v":"2007-09-01"},{"$f":"IF(G42>Fringe1End,R42,N42)","v":15.15},null,{"$f":"(J19*H42/100)+X42","v":0},{"$f":"IF(D42=$D$39,F1.Hourly,0)","v":0},{"$f":"IF(D42=$D$40,F1.FS.ORP,0)","v":0},{"$f":"IF(D42=$D$41,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K42:M42)","v":21.4},{"$f":"IF(D42=$D$39,F2.Hourly,0)","v":0},{"$f":"IF(D42=$D$40,F2.FS.ORP,0)","v":0},{"$f":"IF(D42=$D$41,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O42:Q42)","v":15.15},{"$f":"IF(F42=$F$40,G19,100)","v":0},{"$f":"IF($E42=$E$38,IF($D19=$D$14,Ins.PT.E*$K19*S42/100,IF($D19=$D$15,Ins.PT.E*$K19*S42/100,Ins.E*$K19*S42/100)),0)","v":0},{"$f":"IF($E42=$E$39,IF($D19=$D$14,Ins.PT.S*$K19*S42/100,IF($D19=$D$15,Ins.PT.S*$K19*S42/100,Ins.S*$K19*S42/100)),0)","v":0},{"$f":"IF($E42=$E$40,IF($D19=$D$14,Ins.PT.C*$K19*S42/100,IF($D19=$D$15,Ins.PT.C*$K19*S42/100,Ins.C*$K19*S42/100)),0)","v":0},{"$f":"IF($E42=$E$41,IF($D19=$D$14,Ins.PT.F*$K19*S42/100,IF($D19=$D$15,Ins.PT.F*$K19*S42/100,Ins.F*$K19*S42/100)),0)","v":0},{"$f":"IF(D19=$D$18,ROUNDDOWN(DAYS360(G42,$J$4)/(360*Long.Per),0)*20*K19*G19/100,0)+SUM(T42:W42)","v":0}]
[{"$f":"'Year 2'!A40","v":0},{"$f":"'Year 2'!B40","v":0},{"$f":"'Year 2'!C40","v":0},{"$f":"'Year 2'!D40","v":"TRS"},{"$f":"'Year 2'!E40","v":"Employee"},{"$f":"'Year 2'!F40","v":"Yes"},{"$f":"'Year 2'!G40","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 2'!A41","v":0},{"$f":"'Year 2'!B41","v":0},{"$f":"'Year 2'!C41","v":0},{"$f":"'Year 2'!D41","v":"TRS"},{"$f":"'Year 2'!E41","v":"Employee"},{"$f":"'Year 2'!F41","v":"Yes"},{"$f":"'Year 2'!G41","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 2'!A42","v":0},{"$f":"'Year 2'!B42","v":0},{"$f":"'Year 2'!C42","v":0},{"$f":"'Year 2'!D42","v":"TRS"},{"$f":"'Year 2'!E42","v":"Employee"},{"$f":"'Year 2'!F42","v":"Yes"},{"$f":"'Year 2'!G42","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 2'!A43","v":0},{"$f":"'Year 2'!B43","v":0},{"$f":"'Year 2'!C43","v":0},{"$f":"'Year 2'!D43","v":"TRS"},{"$f":"'Year 2'!E43","v":"Employee"},{"$f":"'Year 2'!F43","v":"Yes"},{"$f":"'Year 2'!G43","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 2'!A44","v":0},{"$f":"'Year 2'!B44","v":0},{"$f":"'Year 2'!C44","v":0},{"$f":"'Year 2'!D44","v":"TRS"},{"$f":"'Year 2'!E44","v":"Employee"},{"$f":"'Year 2'!F44","v":"Yes"},{"$f":"'Year 2'!G44","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 2'!A45","v":0},{"$f":"'Year 2'!B45","v":0},{"$f":"'Year 2'!C45","v":0},{"$f":"'Year 2'!D45","v":"TRS"},{"$f":"'Year 2'!E45","v":"Employee"},{"$f":"'Year 2'!F45","v":"Yes"},{"$f":"'Year 2'!G45","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 2'!A46","v":0},{"$f":"'Year 2'!B46","v":0},{"$f":"'Year 2'!C46","v":0},{"$f":"'Year 2'!D46","v":"TRS"},{"$f":"'Year 2'!E46","v":"Employee"},{"$f":"'Year 2'!F46","v":"No"},{"$f":"'Year 2'!G46","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 2'!A47","v":0},{"$f":"'Year 2'!B47","v":0},{"$f":"'Year 2'!C47","v":0},{"$f":"'Year 2'!D47","v":"TRS"},{"$f":"'Year 2'!E47","v":"Employee"},{"$f":"'Year 2'!F47","v":"No"},{"$f":"'Year 2'!G47","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 2'!A48","v":0},{"$f":"'Year 2'!B48","v":0},{"$f":"'Year 2'!C48","v":0},{"$f":"'Year 2'!D48","v":"TRS"},{"$f":"'Year 2'!E48","v":"Employee"},{"$f":"'Year 2'!F48","v":"No"},{"$f":"'Year 2'!G48","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 2'!A49","v":0},{"$f":"'Year 2'!B49","v":0},{"$f":"'Year 2'!C49","v":0},{"$f":"'Year 2'!D49","v":"TRS"},{"$f":"'Year 2'!E49","v":"Employee"},{"$f":"'Year 2'!F49","v":"No"},{"$f":"'Year 2'!G49","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"A30","v":0},{"$f":"B30","v":0},{"$f":"C30","v":0},{"$f":"IF($D30=$D$16,$D$39,$D$41)","v":"TRS"},{"$f":"IF($D30=$D$16,$E$37,$E$38)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"A31","v":0},0,0,{"$f":"IF($D31=$D$16,$D$39,$D$41)","v":"TRS"},{"$f":"IF($D31=$D$16,$E$37,$E$38)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[0,0,0,{"$f":"IF($D32=$D$16,$D$39,$D$41)","v":"TRS"},{"$f":"IF($D32=$D$16,$E$37,$E$38)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[null,null,null,null,null,"Sum of Fringe Benefits for Personnel",null,null,null,{"$f":"SUM(J42:J55)","v":0},"Hourly","ORP","TRS","F1 Sum","Hourly","ORP","TRS","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[null,null,null,null,null,"Sum of Personnel and Fringe Benefits",null,null,null,{"$f":"J33+J56","v":0}]
["Students",null,null,null,null,null,null,"Number of Months (Academic)","Number of Months\n(Summer)",null,null,null,"Students",null,null,null,null,"Fringe"]
["Last Name","First Name","EMPL ID#","Student Type","Responsibility","Monthly Rate","Percent Effort (%)",null,null,"Project Salary","Rounded Number of Months",null,"Year 1","Year 2","Year 3",null,null,"Year 1","Year 2","Year 3"]
[]
[]
[null,null,null,{"$f":"FALSE()","v":false}]
[null,null,null,{"$f":"TRUE()","v":true}]
[null,null,null,null,"Clerical"]
[null,null,null,"Graduate","Programmer"]
[null,null,null,"Undergrad","Research Assistant"]
[{"$f":"'Year 2'!A61","v":0},{"$f":"'Year 2'!B61","v":0},{"$f":"'Year 2'!C61","v":0},{"$f":"'Year 2'!D61","v":"Graduate"},{"$f":"'Year 2'!E61","v":0},{"$f":"'Year 2'!F61*(100+Living)/100","v":0},0,0,0,{"$f":"F67*((G67*H67)/100+(G67*I67)/100)","v":0},{"$f":"ROUNDUP(H67+I67,0)","v":0},null,{"$f":"'Year 2'!M61","v":0},{"$f":"'Year 2'!N61","v":0},{"$f":"J67","v":0},null,null,{"$f":"'Year 2'!R61","v":0},{"$f":"'Year 2'!S61","v":0},{"$f":"J83","v":0}]
[{"$f":"'Year 2'!A62","v":0},{"$f":"'Year 2'!B62","v":0},{"$f":"'Year 2'!C62","v":0},{"$f":"'Year 2'!D62","v":"Graduate"},{"$f":"'Year 2'!E62","v":0},{"$f":"'Year 2'!F62*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 2'!M62","v":0},{"$f":"'Year 2'!N62","v":0},0,null,null,{"$f":"'Year 2'!R62","v":0},{"$f":"'Year 2'!S62","v":0},{"$f":"J83","v":0}]
[{"$f":"'Year 2'!A63","v":0},{"$f":"'Year 2'!B63","v":0},{"$f":"'Year 2'!C63","v":0},{"$f":"'Year 2'!D63","v":"Graduate"},{"$f":"'Year 2'!E63","v":0},{"$f":"'Year 2'!F63*(100+Living)/100","v":0},0,0,0,{"$f":"F69*((G69*H69)/100+(G69*I69)/100)","v":0},{"$f":"ROUNDUP(H69+I69,0)","v":0},null,{"$f":"'Year 2'!M63","v":0},{"$f":"'Year 2'!N63","v":0},{"$f":"J69","v":0},null,null,{"$f":"'Year 2'!R63","v":0},{"$f":"'Year 2'!S63","v":0},{"$f":"J84","v":0}]
[{"$f":"'Year 2'!A64","v":0},{"$f":"'Year 2'!B64","v":0},{"$f":"'Year 2'!C64","v":0},{"$f":"'Year 2'!D64","v":"Graduate"},{"$f":"'Year 2'!E64","v":0},{"$f":"'Year 2'!F64*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 2'!M64","v":0},{"$f":"'Year 2'!N64","v":0},0,null,null,{"$f":"'Year 2'!R64","v":0},{"$f":"'Year 2'!S64","v":0},{"$f":"J86","v":0}]
[{"$f":"'Year 2'!A65","v":0},{"$f":"'Year 2'!B65","v":0},{"$f":"'Year 2'!C65","v":0},{"$f":"'Year 2'!D65","v":"Graduate"},{"$f":"'Year 2'!E65","v":0},{"$f":"'Year 2'!F65*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 2'!M65","v":0},{"$f":"'Year 2'!N65","v":0},0,null,null,{"$f":"'Year 2'!R65","v":0},{"$f":"'Year 2'!S65","v":0},{"$f":"J86","v":0}]
[{"$f":"'Year 2'!A66","v":0},{"$f":"'Year 2'!B66","v":0},{"$f":"'Year 2'!C66","v":0},{"$f":"'Year 2'!D66","v":"Graduate"},{"$f":"'Year 2'!E66","v":0},{"$f":"'Year 2'!F66*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 2'!M66","v":0},{"$f":"'Year 2'!N66","v":0},0,null,null,{"$f":"'Year 2'!R66","v":0},{"$f":"'Year 2'!S66","v":0},{"$f":"J88","v":0}]
[0,0,0,"Graduate",0,0,0,0,0,0,0,null,0,0,0,null,null,0,0,{"$f":"J89","v":0}]
[null,null,null,null,null,null,"Sum of Students",null,null,{"$f":"SUM(J67:J73)","v":0}]
["Fringe Benefits for Students"]
["Last Name","First Name","EMPL ID#","Student Type","Insurance Type","Other Support","Hire Date","Fringe Rate",null,"Fringe Benefit Totals","Fringe Rates before 9-1-95",null,null,"Fringe Rates after 9-1-95",null,null,"Insurance and Longevity Calculations"]
[]
[null,null,null,null,"None"]
[null,null,null,null,"Employee"]
[null,null,null,"None","Spouse"]
[null,null,null,"ORP","Children","Yes"]
[null,null,null,"TRS","Family","No",null,null,null,null,"Grad","Under","F1 Sum","Grad","Under","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[{"$f":"'Year 2'!A76","v":0},{"$f":"'Year 2'!B76","v":0},{"$f":"'Year 2'!C76","v":0},{"$f":"'Year 2'!D76","v":"Graduate"},{"$f":"'Year 2'!E76","v":"Employee"},{"$f":"'Year 2'!F76","v":"No"},{"$f":"'Year 2'!G76","v":"2007-09-01"},{"$f":"IF(G83>Fringe1End,P83,M83)","v":7.65},null,{"$f":"(J67*H83/100)+V83","v":0},{"$f":"IF(D67=$D$65,F1.Grad,0)","v":7.65},{"$f":"IF(D67=$D$66,F1.Under,0)","v":0},{"$f":"SUM(K83:L83)","v":7.65},{"$f":"IF(D67=$D$65,F2.Grad,0)","v":7.65},{"$f":"IF(D67=$D$66,F2.Under,0)","v":0},{"$f":"SUM(N83:O83)","v":7.65},{"$f":"IF(F83=$F$81,G67,100)","v":100},{"$f":"IF($E83=$E$79,Ins.PT.E*$K67*Q83/100,0)","v":0},{"$f":"IF($E83=$E$80,Ins.PT.S*$K67*Q83/100,0)","v":0},{"$f":"IF($E83=$E$81,Ins.PT.C*$K67*Q83/100,0)","v":0},{"$f":"IF($E83=$E$82,Ins.PT.F*$K67*Q83/100,0)","v":0},{"$f":"SUM(R83:U83)","v":0}]
[{"$f":"'Year 2'!A77","v":0},{"$f":"'Year 2'!B77","v":0},{"$f":"'Year 2'!C77","v":0},{"$f":"'Year 2'!D77","v":"Graduate"},{"$f":"'Year 2'!E77","v":"Employee"},{"$f":"'Year 2'!F77","v":"No"},{"$f":"'Year 2'!G77","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"'Year 2'!A78","v":0},{"$f":"'Year 2'!B78","v":0},{"$f":"'Year 2'!C78","v":0},{"$f":"'Year 2'!D78","v":"Graduate"},{"$f":"'Year 2'!E78","v":"Employee"},{"$f":"'Year 2'!F78","v":"No"},{"$f":"'Year 2'!G78","v":"2007-09-01"},{"$f":"IF(G85>Fringe1End,P85,M85)","v":7.65},null,0,7.65,0,{"$f":"SUM(K85:L85)","v":7.65},7.65,0,{"$f":"SUM(N85:O85)","v":7.65},100,0,0,0,0,{"$f":"SUM(R85:U85)","v":0}]
[{"$f":"'Year 2'!A79","v":0},{"$f":"'Year 2'!B79","v":0},{"$f":"'Year 2'!C79","v":0},{"$f":"'Year 2'!D79","v":"Graduate"},{"$f":"'Year 2'!E79","v":"Employee"},{"$f":"'Year 2'!F79","v":"No"},{"$f":"'Year 2'!G79","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"'Year 2'!A80","v":0},{"$f":"'Year 2'!B80","v":0},{"$f":"'Year 2'!C80","v":0},{"$f":"'Year 2'!D80","v":"Graduate"},{"$f":"'Year 2'!E80","v":"Employee"},{"$f":"'Year 2'!F80","v":"No"},{"$f":"'Year 2'!G80","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"'Year 2'!A81","v":0},{"$f":"'Year 2'!B81","v":0},{"$f":"'Year 2'!C81","v":0},{"$f":"'Year 2'!D81","v":"Graduate"},{"$f":"'Year 2'!E81","v":"Employee"},{"$f":"'Year 2'!F81","v":"No"},{"$f":"'Year 2'!G81","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"A73","v":0},{"$f":"B73","v":0},{"$f":"C73","v":0},{"$f":"D73","v":"Graduate"},{"$f":"IF($D73=$D$65,$E$79,$E$78)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[null,null,null,null,null,"Sum of Fringe Benefits for Students",null,null,null,{"$f":"SUM(J83:J89)","v":0},"Grad","Under","F1 Sum","Grad","Under","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[null,null,null,null,null,"Sum of Students and Fringe Benefits",null,null,null,{"$f":"J74+J90","v":0}]
[null,null,null,null,null,"Sum of Salary",null,null,null,{"$f":"J33+J74","v":0}]
[null,null,null,null,null,"Sum of Fringe Benefits",null,null,null,{"$f":"J56+J90","v":0}]
[null,null,null,null,null,"Sum of Personnel and Students",null,null,null,{"$f":"SUM(J92:J93)","v":0}]
["Travel"]
["Component","Description",null,null,null,"Location","Date","Destination",null,"Cost"]
[]
["Transportation",null,null,null,null,"In-State"]
["Meals",null,null,null,null,"Out-of-State"]
["Lodging",null,null,null,null,"Foreign"]
[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,"Sum of Travel",null,null,{"$f":"SUM(J101:J102)","v":0}]
["Capital Expenditures/Equipment D",null,null,null,"These items individually are OVER $5,000.Please obtain a vendor quote"]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G106*H106","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G107*H107","v":0}]
[null,null,null,null,null,null,"Sum of Equipment",null,null,{"$f":"SUM(J106:J107)","v":0}]
["Supplies","These items individually are UNDER $5,000."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G111*H111","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G112*H112","v":0}]
[null,null,null,null,null,null,"Sum of Supplies",null,null,{"$f":"SUM(J111:J112)","v":0}]
["Publication Charges",null,null,"For the typical activities included in this category, hold mouse over the cell to the left."]
["Item",null,"Description",null,null,null,"Price","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G116*H116","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G117*H117","v":0}]
[null,null,null,null,null,"Sum of Publication/Printing Charges",null,null,null,{"$f":"SUM(J116:J117)","v":0},"This is the amount that can be charge IDC"]
["Sub-Contracts DÑ",null,"UNT employees can not be recipients of UNT sub-contracts and must be paid in personnel category."]
["Item",null,"Description",null,null,null,null,null,null,"Amount",null,null,null,null,"Year 1","Year 2","Year 3"]
[{"$f":"'Year 2'!A113:B113","v":0},null,{"$f":"'Year 2'!C113:H113","v":0},null,null,null,null,null,null,0,{"$f":"IF(M121+J121>25000,IF(M121>=25000,0,25000-M121),J121)","v":0},1,{"$f":"'Year 2'!N113","v":0},{"$f":"SUM(M121,J121)","v":0},{"$f":"'Year 2'!O113","v":0},{"$f":"'Year 2'!P113","v":0},{"$f":"J121","v":0}]
[{"$f":"'Year 2'!A114:B114","v":0},null,{"$f":"'Year 2'!C114:H114","v":0},null,null,null,null,null,null,0,{"$f":"IF(M122+J122>25000,IF(M122>=25000,0,25000-M122),J122)","v":0},1,{"$f":"'Year 2'!N114","v":0},{"$f":"SUM(M122,J122)","v":0},{"$f":"'Year 2'!O114","v":0},{"$f":"'Year 2'!P114","v":0},{"$f":"J122","v":0}]
[{"$f":"'Year 2'!A115:B115","v":0},null,{"$f":"'Year 2'!C115:H115","v":0},null,null,null,null,null,null,0,{"$f":"IF(M123+J123>25000,IF(M123>=25000,0,25000-M123),J123)","v":0},2,{"$f":"'Year 2'!N115","v":0},{"$f":"SUM(M123,J123)","v":0},{"$f":"'Year 2'!O115","v":0},{"$f":"'Year 2'!P115","v":0},{"$f":"J123","v":0}]
[0,null,null,null,null,null,null,null,null,0,{"$f":"IF(M124+J124>25000,IF(M124>=25000,0,25000-M124),J124)","v":0},3,0,{"$f":"SUM(M124,J124)","v":0},0,0,{"$f":"J124","v":0}]
[null,null,null,null,null,"Sum of Sub-Contracts",null,null,null,{"$f":"SUM(J121:J124)","v":0},{"$f":"SUM(K121:K124)","v":0},"Year","Previous","Current"]
["Participant Support Costs D"]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[]
["Scholarship"]
["Fellowship"]
["Travel"]
["Subsistence"]
["Other"]
[null,null,null,null,null,null,0,0,null,{"$f":"G134*H134","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G135*H135","v":0}]
[null,null,null,null,null,null,null,"Sum of Participant Support Costs",null,{"$f":"SUM(J134:J135)","v":0}]
["Other-Graduate Student Tuition ",null,null,null,"Calculate Grad Tuition in this Budget Category. IDC is not assessed on tuition."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,0,0,null,{"$f":"G145*H145","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G146*H146","v":0}]
[null,null,null,null,null,null,null,"Sum of Other-Graduate Student Tuition ",null,{"$f":"SUM(J145:J146)","v":0}]
["Other-All Other Costs except Graduate Tuition DÑ"]
["Item",null,"Description",null,null,null,"Price","Quantity",null,"Cost"]
[]
["Patient Care Charges",null,null,null,null,null,null,null,null,null,"This is the amount that can be charge IDC"]
["Off-site Facility Rental"]
["(User Defined)"]
[null,null,null,null,null,null,0,0,null,{"$f":"G154*H154","v":0},{"$f":"IF(OR(A154=$A$151,A154=$A$152),0,J154)","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G155*H155","v":0},{"$f":"IF(OR(A155=$A$151,A155=$A$152),0,J155)","v":0}]
[null,null,null,null,null,null,null,"Sum of Other",null,{"$f":"SUM(J154:J155)","v":0},{"$f":"SUM(K154:K155)","v":0}]
["Indirect Costs"]
["IDC Type",null,"IDC rate","Documentation Location",null,"Modified Total Direct Costs (Base for F&A)",null,null,null,{"$f":"(J94+J103+J113+J118+K125+K156)","v":0}]
[{"$f":"'Year 1'!A142:B142","v":"Research"},null,{"$f":"'Year 1'!C142","v":48.5},{"$f":"'Year 1'!D142:F142","v":0},null,null,"IDC Amount",null,null,{"$f":"J158*C159/100","v":0}]
[null,null,null,null,null,"Total Direct Costs (Sponsor Direct)",null,null,null,{"$f":"SUM(J125,J156,J136,J118,J113,J108,J103,J94,J147)","v":0}]
[null,null,null,null,{"$f":"\"Total Amount Requested for \"&J1&\" Budget\"","v":"Total Amount Requested for Year 3 Budget"},null,null,null,null,{"$f":"SUM(J159:J160)","v":0}]
[]
["University of North Texas, Grants & Contracts Administration"]

{"sheet":"Year 4","index":5,"n_rows":168,"n_cols":24,"rows_kept":168,"cut":false,"hidden":false,"merged":[[60,10,60,11],[76,6,76,7],[59,8,60,8],[93,5,93,7],[5,10,5,11],[33,6,33,7],[57,5,57,7],[4,8,5,8],[58,5,58,7],[165,4,165,7],[163,0,163,1],[163,3,163,5],[163,6,163,7],[158,2,158,5],[162,3,162,4],[162,5,162,7],[164,5,164,7],[159,0,159,1],[162,0,162,1],[159,2,159,5],[158,0,158,1],[0,5,0,7],[106,6,106,7],[109,2,109,5],[116,6,116,7],[59,7,60,7],[0,2,0,3],[95,5,95,7],[97,5,97,7],[111,6,111,7],[107,4,107,9],[105,1,105,4],[96,5,96,7],[108,2,108,5],[113,0,113,1],[2,0,2,1],[2,2,2,3],[155,10,157,11],[131,2,131,5],[121,10,123,11],[122,2,122,9],[123,2,123,5],[149,2,149,5],[139,2,139,5],[153,2,153,5],[129,5,129,7],[138,2,138,5],[150,2,150,5],[142,2,142,5],[128,2,128,7],[121,5,121,7],[124,0,124,1],[110,0,110,1],[115,0,115,1],[119,2,119,5],[120,0,120,1],[117,0,117,2],[115,2,115,5],[117,3,117,9],[118,0,118,1],[1,1,1,9],[109,0,109,1],[114,0,114,1],[127,2,127,7],[128,0,128,1],[125,0,125,1],[126,0,126,1],[124,2,124,7],[125,2,125,7],[126,2,126,7],[123,0,123,1],[120,2,120,5],[118,2,118,5],[119,0,119,1],[2,7,2,9],[108,0,108,1],[157,0,157,1],[127,0,127,1],[131,0,131,1],[150,0,150,1],[139,0,139,1],[138,0,138,1],[156,0,156,1],[155,0,155,1],[149,0,149,1],[153,0,153,1],[142,0,142,1],[3,0,3,4],[3,5,3,7],[4,7,5,7],[114,2,114,5],[99,1,99,4],[110,2,110,5],[104,1,104,4],[112,1,112,9],[94,5,94,7],[113,2,113,5]]}
["File Number:",{"$f":"'Year 1'!B1","v":0},"BB version:",null,{"$f":"'Year 1'!E1","v":"FY 2021"},"This Budget is prepared for:",null,null,{"$f":"'Year 1'!I1","v":0},"Year 4"]
["Project Title:",{"$f":"'Year 1'!B2:J2","v":0}]
["Budget Prepared by:",null,{"$f":"'Year 1'!C3:D3","v":0},null,"Phone Number:",{"$f":"'Year 1'!F3","v":0},"E-mail:",{"$f":"'Year 1'!H3:J3","v":0}]
["Project Budget",null,null,null,null,"This Budget was drafted on:",null,null,{"$f":"'Year 1'!I4","v":"00:00:00"},{"$f":"'Year 1'!J4","v":"2007-09-01"}]
["Personnel",null,null,null,null,null,null,"Number of Months (Academic)","Number of Months (Summer)",null,null,null,"Personnel",null,null,null,null,"Fringe"]
["Last Name","First Name","EMPL ID#","Employee Type","Responsibility","Monthly Rate","Percent Effort (%)",null,null,"Project Salary","Rounded Number of Months",null,"Year 1","Year 2","Year 3","Year 4",null,"Year 1","Year 2","Year 3","Year 4"]
[]
[null,null,null,null,"PI"]
[null,null,null,null,"Co-PI"]
[null,null,null,null,"Senior Personnel"]
[null,null,null,null,"Research Assistant"]
[null,null,null,null,"Teaching Assistant"]
[null,null,{"$f":"FALSE()","v":false},null,"Investigator"]
[null,null,{"$f":"TRUE()","v":true},"PT Staff","Coordinator"]
[null,null,null,"PT Faculty","Technician"]
[null,null,null,"Hourly","Post Doc"]
[null,null,null,"Faculty","Clerical"]
[null,null,null,"Staff","Programmer"]
[{"$f":"'Year 3'!A19","v":0},{"$f":"'Year 3'!B19","v":0},{"$f":"'Year 3'!C19","v":0},{"$f":"'Year 3'!D19","v":0},{"$f":"'Year 3'!E19","v":0},{"$f":"'Year 3'!F19*(100+Living)/100","v":0},0,0,0,{"$f":"F19*((G19*H19)/100+(G19*I19)/100)","v":0},{"$f":"ROUNDUP(H19+I19,0)","v":0},null,{"$f":"'Year 3'!M19","v":0},{"$f":"'Year 3'!N19","v":0},{"$f":"'Year 3'!O19","v":0},{"$f":"J19","v":0},null,{"$f":"'Year 3'!R19","v":0},{"$f":"'Year 3'!S19","v":0},{"$f":"'Year 3'!T19","v":0},{"$f":"J43","v":0}]
[{"$f":"'Year 3'!A20","v":0},{"$f":"'Year 3'!B20","v":0},{"$f":"'Year 3'!C20","v":0},{"$f":"'Year 3'!D20","v":0},{"$f":"'Year 3'!E20","v":0},{"$f":"'Year 3'!F20*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H20+I20,0)","v":0},null,{"$f":"'Year 3'!M20","v":0},{"$f":"'Year 3'!N20","v":0},{"$f":"'Year 3'!O20","v":0},0,null,{"$f":"'Year 3'!R20","v":0},{"$f":"'Year 3'!S20","v":0},{"$f":"'Year 3'!T20","v":0},{"$f":"J43","v":0}]
[{"$f":"'Year 3'!A21","v":0},{"$f":"'Year 3'!B21","v":0},{"$f":"'Year 3'!C21","v":0},{"$f":"'Year 3'!D21","v":0},{"$f":"'Year 3'!E21","v":0},{"$f":"'Year 3'!F21*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 3'!M21","v":0},{"$f":"'Year 3'!N21","v":0},{"$f":"'Year 3'!O21","v":0},0,null,{"$f":"'Year 3'!R21","v":0},{"$f":"'Year 3'!S21","v":0},{"$f":"'Year 3'!T21","v":0},{"$f":"J44","v":0}]
[{"$f":"'Year 3'!A22","v":0},{"$f":"'Year 3'!B22","v":0},{"$f":"'Year 3'!C22","v":0},{"$f":"'Year 3'!D22","v":0},{"$f":"'Year 3'!E22","v":0},{"$f":"'Year 3'!F22*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 3'!M22","v":0},{"$f":"'Year 3'!N22","v":0},{"$f":"'Year 3'!O22","v":0},0,null,{"$f":"'Year 3'!R22","v":0},{"$f":"'Year 3'!S22","v":0},{"$f":"'Year 3'!T22","v":0},{"$f":"J45","v":0}]
[{"$f":"'Year 3'!A23","v":0},{"$f":"'Year 3'!B23","v":0},{"$f":"'Year 3'!C23","v":0},{"$f":"'Year 3'!D23","v":0},{"$f":"'Year 3'!E23","v":0},{"$f":"'Year 3'!F23*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H23+I23,0)","v":0},null,{"$f":"'Year 3'!M23","v":0},{"$f":"'Year 3'!N23","v":0},{"$f":"'Year 3'!O23","v":0},0,null,{"$f":"'Year 3'!R23","v":0},{"$f":"'Year 3'!S23","v":0},{"$f":"'Year 3'!T23","v":0},{"$f":"J46","v":0}]
[{"$f":"'Year 3'!A24","v":0},{"$f":"'Year 3'!B24","v":0},{"$f":"'Year 3'!C24","v":0},{"$f":"'Year 3'!D24","v":0},{"$f":"'Year 3'!E24","v":0},{"$f":"'Year 3'!F24*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H24+I24,0)","v":0},null,{"$f":"'Year 3'!M24","v":0},{"$f":"'Year 3'!N24","v":0},{"$f":"'Year 3'!O24","v":0},0,null,{"$f":"'Year 3'!R24","v":0},{"$f":"'Year 3'!S24","v":0},{"$f":"'Year 3'!T24","v":0},{"$f":"J47","v":0}]
[{"$f":"'Year 3'!A25","v":0},{"$f":"'Year 3'!B25","v":0},{"$f":"'Year 3'!C25","v":0},{"$f":"'Year 3'!D25","v":0},{"$f":"'Year 3'!E25","v":0},{"$f":"'Year 3'!F25*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 3'!M25","v":0},{"$f":"'Year 3'!N25","v":0},{"$f":"'Year 3'!O25","v":0},0,null,{"$f":"'Year 3'!R25","v":0},{"$f":"'Year 3'!S25","v":0},{"$f":"'Year 3'!T25","v":0},{"$f":"J49","v":0}]
[{"$f":"'Year 3'!A26","v":0},{"$f":"'Year 3'!B26","v":0},{"$f":"'Year 3'!C26","v":0},{"$f":"'Year 3'!D26","v":0},{"$f":"'Year 3'!E26","v":0},{"$f":"'Year 3'!F26*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H26+I26,0)","v":0},null,{"$f":"'Year 3'!M26","v":0},{"$f":"'Year 3'!N26","v":0},{"$f":"'Year 3'!O26","v":0},0,null,{"$f":"'Year 3'!R26","v":0},{"$f":"'Year 3'!S26","v":0},{"$f":"'Year 3'!T26","v":0},{"$f":"J49","v":0}]
[{"$f":"'Year 3'!A27","v":0},{"$f":"'Year 3'!B27","v":0},{"$f":"'Year 3'!C27","v":0},{"$f":"'Year 3'!D27","v":0},{"$f":"'Year 3'!E27","v":0},{"$f":"'Year 3'!F27*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H27+I27,0)","v":0},null,{"$f":"'Year 3'!M27","v":0},{"$f":"'Year 3'!N27","v":0},{"$f":"'Year 3'!O27","v":0},0,null,{"$f":"'Year 3'!R27","v":0},{"$f":"'Year 3'!S27","v":0},{"$f":"'Year 3'!T27","v":0},{"$f":"J50","v":0}]
[{"$f":"'Year 3'!A28","v":0},{"$f":"'Year 3'!B28","v":0},{"$f":"'Year 3'!C28","v":0},{"$f":"'Year 3'!D28","v":0},{"$f":"'Year 3'!E28","v":0},{"$f":"'Year 3'!F28*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H28+I28,0)","v":0},null,{"$f":"'Year 3'!M28","v":0},{"$f":"'Year 3'!N28","v":0},{"$f":"'Year 3'!O28","v":0},0,null,{"$f":"'Year 3'!R28","v":0},{"$f":"'Year 3'!S28","v":0},{"$f":"'Year 3'!T28","v":0},{"$f":"J51","v":0}]
[{"$f":"'Year 3'!A29","v":0},{"$f":"'Year 3'!B29","v":0},{"$f":"'Year 3'!C29","v":0},{"$f":"'Year 3'!D29","v":0},{"$f":"'Year 3'!E29","v":0},{"$f":"'Year 3'!F29*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 3'!M29","v":0},{"$f":"'Year 3'!N29","v":0},{"$f":"'Year 3'!O29","v":0},0,null,{"$f":"'Year 3'!R29","v":0},{"$f":"'Year 3'!S29","v":0},{"$f":"'Year 3'!T29","v":0},{"$f":"J53","v":0}]
[{"$f":"'Year 3'!A30","v":0},{"$f":"'Year 3'!B30","v":0},{"$f":"'Year 3'!C30","v":0},{"$f":"'Year 3'!D30","v":0},{"$f":"'Year 3'!E30","v":0},{"$f":"'Year 3'!F30*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H30+I30,0)","v":0},null,{"$f":"'Year 3'!M30","v":0},{"$f":"'Year 3'!N30","v":0},{"$f":"'Year 3'!O30","v":0},0,null,{"$f":"'Year 3'!R30","v":0},{"$f":"'Year 3'!S30","v":0},{"$f":"'Year 3'!T30","v":0},{"$f":"J53","v":0}]
[{"$f":"'Year 3'!A31","v":0},{"$f":"'Year 3'!B31","v":0},{"$f":"'Year 3'!C31","v":0},{"$f":"'Year 3'!D31","v":0},{"$f":"'Year 3'!E31","v":0},{"$f":"'Year 3'!F31*(100+Living)/100","v":0},0,0,0,0,{"$f":"ROUNDUP(H31+I31,0)","v":0},null,{"$f":"'Year 3'!M31","v":0},{"$f":"'Year 3'!N31","v":0},{"$f":"'Year 3'!O31","v":0},0,null,{"$f":"'Year 3'!R31","v":0},{"$f":"'Year 3'!S31","v":0},{"$f":"'Year 3'!T31","v":0},{"$f":"J54","v":0}]
[{"$f":"'Year 3'!A32","v":0},{"$f":"'Year 3'!B32","v":0},{"$f":"'Year 3'!C32","v":0},{"$f":"'Year 3'!D32","v":0},{"$f":"'Year 3'!E32","v":0},{"$f":"'Year 3'!F32*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 3'!M32","v":0},{"$f":"'Year 3'!N32","v":0},{"$f":"'Year 3'!O32","v":0},0,null,{"$f":"'Year 3'!R32","v":0},{"$f":"'Year 3'!S32","v":0},{"$f":"'Year 3'!T32","v":0},{"$f":"J56","v":0}]
[0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,0,0,{"$f":"J57","v":0}]
[null,null,null,null,null,null,"Sum of Personnel",null,null,{"$f":"SUM(J19:J33)","v":0}]
["Fringe Benefits for Personnel"]
["Last Name","First Name","EMPL ID#","Retirement","Insurance Type","Other Support","Hire Date","Fringe Rate",null,"Fringe Benefit Totals","Fringe Rates before 9-1-95",null,null,null,"Fringe Rates after 9-1-95",null,null,null,"Insurance and Longevity Calculations"]
[]
[null,null,null,null,"None"]
[null,null,null,null,"Employee"]
[null,null,null,"Hourly","Spouse"]
[null,null,null,"ORP","Children","Yes"]
[null,null,null,"TRS","Family","No",null,null,null,null,"Hourly","ORP","TRS","F1 Sum","Hourly","ORP","TRS","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[{"$f":"'Year 3'!A42","v":0},{"$f":"'Year 3'!B42","v":0},{"$f":"'Year 3'!C42","v":0},{"$f":"'Year 3'!D42","v":"TRS"},{"$f":"'Year 3'!E42","v":"Employee"},{"$f":"'Year 3'!F42","v":"Yes"},{"$f":"'Year 3'!G42","v":"2007-09-01"},{"$f":"IF(G43>Fringe1End,R43,N43)","v":15.15},null,{"$f":"(J19*H43/100)+X43","v":0},{"$f":"IF(D43=$D$40,F1.Hourly,0)","v":0},{"$f":"IF(D43=$D$41,F1.FS.ORP,0)","v":0},{"$f":"IF(D43=$D$42,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K43:M43)","v":21.4},{"$f":"IF(D43=$D$40,F2.Hourly,0)","v":0},{"$f":"IF(D43=$D$41,F2.FS.ORP,0)","v":0},{"$f":"IF(D43=$D$42,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O43:Q43)","v":15.15},{"$f":"IF(F43=$F$41,G19,100)","v":0},{"$f":"IF($E43=$E$39,IF($D19=$D$14,Ins.PT.E*$K19*S43/100,IF($D19=$D$15,Ins.PT.E*$K19*S43/100,Ins.E*$K19*S43/100)),0)","v":0},{"$f":"IF($E43=$E$40,IF($D19=$D$14,Ins.PT.S*$K19*S43/100,IF($D19=$D$15,Ins.PT.S*$K19*S43/100,Ins.S*$K19*S43/100)),0)","v":0},{"$f":"IF($E43=$E$41,IF($D19=$D$14,Ins.PT.C*$K19*S43/100,IF($D19=$D$15,Ins.PT.C*$K19*S43/100,Ins.C*$K19*S43/100)),0)","v":0},{"$f":"IF($E43=$E$42,IF($D19=$D$14,Ins.PT.F*$K19*S43/100,IF($D19=$D$15,Ins.PT.F*$K19*S43/100,Ins.F*$K19*S43/100)),0)","v":0},{"$f":"IF(D19=$D$18,ROUNDDOWN(DAYS360(G43,$J$4)/(360*Long.Per),0)*20*K19*G19/100,0)+SUM(T43:W43)","v":0}]
[{"$f":"'Year 3'!A43","v":0},{"$f":"'Year 3'!B43","v":0},{"$f":"'Year 3'!C43","v":0},{"$f":"'Year 3'!D43","v":"TRS"},{"$f":"'Year 3'!E43","v":"Employee"},{"$f":"'Year 3'!F43","v":"Yes"},{"$f":"'Year 3'!G43","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 3'!A44","v":0},{"$f":"'Year 3'!B44","v":0},{"$f":"'Year 3'!C44","v":0},{"$f":"'Year 3'!D44","v":"TRS"},{"$f":"'Year 3'!E44","v":"Employee"},{"$f":"'Year 3'!F44","v":"Yes"},{"$f":"'Year 3'!G44","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 3'!A45","v":0},{"$f":"'Year 3'!B45","v":0},{"$f":"'Year 3'!C45","v":0},{"$f":"'Year 3'!D45","v":"TRS"},{"$f":"'Year 3'!E45","v":"Employee"},{"$f":"'Year 3'!F45","v":"Yes"},{"$f":"'Year 3'!G45","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 3'!A46","v":0},{"$f":"'Year 3'!B46","v":0},{"$f":"'Year 3'!C46","v":0},{"$f":"'Year 3'!D46","v":"TRS"},{"$f":"'Year 3'!E46","v":"Employee"},{"$f":"'Year 3'!F46","v":"Yes"},{"$f":"'Year 3'!G46","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 3'!A47","v":0},{"$f":"'Year 3'!B47","v":0},{"$f":"'Year 3'!C47","v":0},{"$f":"'Year 3'!D47","v":"TRS"},{"$f":"'Year 3'!E47","v":"Employee"},{"$f":"'Year 3'!F47","v":"Yes"},{"$f":"'Year 3'!G47","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 3'!A48","v":0},{"$f":"'Year 3'!B48","v":0},{"$f":"'Year 3'!C48","v":0},{"$f":"'Year 3'!D48","v":"TRS"},{"$f":"'Year 3'!E48","v":"Employee"},{"$f":"'Year 3'!F48","v":"Yes"},{"$f":"'Year 3'!G48","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 3'!A49","v":0},{"$f":"'Year 3'!B49","v":0},{"$f":"'Year 3'!C49","v":0},{"$f":"'Year 3'!D49","v":"TRS"},{"$f":"'Year 3'!E49","v":"Employee"},{"$f":"'Year 3'!F49","v":"No"},{"$f":"'Year 3'!G49","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 3'!A50","v":0},{"$f":"'Year 3'!B50","v":0},{"$f":"'Year 3'!C50","v":0},{"$f":"'Year 3'!D50","v":"TRS"},{"$f":"'Year 3'!E50","v":"Employee"},{"$f":"'Year 3'!F50","v":"No"},{"$f":"'Year 3'!G50","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 3'!A51","v":0},{"$f":"'Year 3'!B51","v":0},{"$f":"'Year 3'!C51","v":0},{"$f":"'Year 3'!D51","v":"TRS"},{"$f":"'Year 3'!E51","v":"Employee"},{"$f":"'Year 3'!F51","v":"No"},{"$f":"'Year 3'!G51","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 3'!A52","v":0},{"$f":"'Year 3'!B52","v":0},{"$f":"'Year 3'!C52","v":0},{"$f":"'Year 3'!D52","v":"TRS"},{"$f":"'Year 3'!E52","v":"Employee"},{"$f":"'Year 3'!F52","v":"No"},{"$f":"'Year 3'!G52","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 3'!A53","v":0},{"$f":"'Year 3'!B53","v":0},{"$f":"'Year 3'!C53","v":0},{"$f":"'Year 3'!D53","v":"TRS"},{"$f":"'Year 3'!E53","v":"Employee"},{"$f":"'Year 3'!F53","v":"No"},{"$f":"'Year 3'!G53","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 3'!A54","v":0},{"$f":"'Year 3'!B54","v":0},{"$f":"'Year 3'!C54","v":0},{"$f":"'Year 3'!D54","v":"TRS"},{"$f":"'Year 3'!E54","v":"Employee"},{"$f":"'Year 3'!F54","v":"No"},{"$f":"'Year 3'!G54","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 3'!A55","v":0},{"$f":"'Year 3'!B55","v":0},{"$f":"'Year 3'!C55","v":0},{"$f":"'Year 3'!D55","v":"TRS"},{"$f":"'Year 3'!E55","v":"Employee"},{"$f":"'Year 3'!F55","v":"No"},{"$f":"'Year 3'!G55","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"A33","v":0},{"$f":"B33","v":0},{"$f":"C33","v":0},{"$f":"IF($D33=$D$16,$D$40,$D$42)","v":"TRS"},{"$f":"IF($D33=$D$16,$E$38,$E$39)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[null,null,null,null,null,"Sum of Fringe Benefits for Personnel",null,null,null,{"$f":"SUM(J43:J57)","v":0},"Hourly","ORP","TRS","F1 Sum","Hourly","ORP","TRS","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[null,null,null,null,null,"Sum of Personnel and Fringe Benefits",null,null,null,{"$f":"J34+J58","v":0}]
["Students",null,null,null,null,null,null,"Number of Months (Academic)","Number of Months\n(Summer)",null,null,null,"Students",null,null,null,null,"Fringe"]
["Last Name","First Name","EMPL ID#","Student Type","Responsibility","Monthly Rate","Percent Effort (%)",null,null,"Project Salary","Rounded Number of Months",null,"Year 1","Year 2","Year 3","Year 4",null,"Year 1","Year 2","Year 3","Year 4"]
[]
[]
[null,null,null,{"$f":"FALSE()","v":false}]
[null,null,null,{"$f":"TRUE()","v":true}]
[null,null,null,null,"Clerical"]
[null,null,null,"Graduate","Programmer"]
[null,null,null,"Undergrad","Research Assistant"]
[{"$f":"'Year 3'!A67","v":0},{"$f":"'Year 3'!B67","v":0},{"$f":"'Year 3'!C67","v":0},{"$f":"'Year 3'!D67","v":"Graduate"},{"$f":"'Year 3'!E67","v":0},{"$f":"'Year 3'!F67*(100+Living)/100","v":0},0,0,0,{"$f":"F69*((G69*H69)/100+(G69*I69)/100)","v":0},{"$f":"ROUNDUP(H69+I69,0)","v":0},null,{"$f":"'Year 3'!M67","v":0},{"$f":"'Year 3'!N67","v":0},{"$f":"'Year 3'!O67","v":0},{"$f":"J69","v":0},null,{"$f":"'Year 3'!R67","v":0},{"$f":"'Year 3'!S67","v":0},{"$f":"'Year 3'!T67","v":0},{"$f":"J86","v":0}]
[{"$f":"'Year 3'!A68","v":0},{"$f":"'Year 3'!B68","v":0},{"$f":"'Year 3'!C68","v":0},{"$f":"'Year 3'!D68","v":"Graduate"},{"$f":"'Year 3'!E68","v":0},{"$f":"'Year 3'!F68*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 3'!M68","v":0},{"$f":"'Year 3'!N68","v":0},{"$f":"'Year 3'!O68","v":0},0,null,{"$f":"'Year 3'!R68","v":0},{"$f":"'Year 3'!S68","v":0},{"$f":"'Year 3'!T68","v":0},{"$f":"J86","v":0}]
[{"$f":"'Year 3'!A69","v":0},{"$f":"'Year 3'!B69","v":0},{"$f":"'Year 3'!C69","v":0},{"$f":"'Year 3'!D69","v":"Graduate"},{"$f":"'Year 3'!E69","v":0},{"$f":"'Year 3'!F69*(100+Living)/100","v":0},0,0,0,{"$f":"F71*((G71*H71)/100+(G71*I71)/100)","v":0},{"$f":"ROUNDUP(H71+I71,0)","v":0},null,{"$f":"'Year 3'!M69","v":0},{"$f":"'Year 3'!N69","v":0},{"$f":"'Year 3'!O69","v":0},{"$f":"J71","v":0},null,{"$f":"'Year 3'!R69","v":0},{"$f":"'Year 3'!S69","v":0},{"$f":"'Year 3'!T69","v":0},{"$f":"J87","v":0}]
[{"$f":"'Year 3'!A70","v":0},{"$f":"'Year 3'!B70","v":0},{"$f":"'Year 3'!C70","v":0},{"$f":"'Year 3'!D70","v":"Graduate"},{"$f":"'Year 3'!E70","v":0},{"$f":"'Year 3'!F70*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 3'!M70","v":0},{"$f":"'Year 3'!N70","v":0},{"$f":"'Year 3'!O70","v":0},0,null,{"$f":"'Year 3'!R70","v":0},{"$f":"'Year 3'!S70","v":0},{"$f":"'Year 3'!T70","v":0},{"$f":"J89","v":0}]
[{"$f":"'Year 3'!A71","v":0},{"$f":"'Year 3'!B71","v":0},{"$f":"'Year 3'!C71","v":0},{"$f":"'Year 3'!D71","v":"Graduate"},{"$f":"'Year 3'!E71","v":0},{"$f":"'Year 3'!F71*(100+Living)/100","v":0},0,0,0,{"$f":"F73*((G73*H73)/100+(G73*I73)/100)","v":0},{"$f":"ROUNDUP(H73+I73,0)","v":0},null,{"$f":"'Year 3'!M71","v":0},{"$f":"'Year 3'!N71","v":0},{"$f":"'Year 3'!O71","v":0},{"$f":"J73","v":0},null,{"$f":"'Year 3'!R71","v":0},{"$f":"'Year 3'!S71","v":0},{"$f":"'Year 3'!T71","v":0},{"$f":"J89","v":0}]
[{"$f":"'Year 3'!A72","v":0},{"$f":"'Year 3'!B72","v":0},{"$f":"'Year 3'!C72","v":0},{"$f":"'Year 3'!D72","v":"Graduate"},{"$f":"'Year 3'!E72","v":0},{"$f":"'Year 3'!F72*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 3'!M72","v":0},{"$f":"'Year 3'!N72","v":0},{"$f":"'Year 3'!O72","v":0},0,null,{"$f":"'Year 3'!R72","v":0},{"$f":"'Year 3'!S72","v":0},{"$f":"'Year 3'!T72","v":0},{"$f":"J91","v":0}]
[{"$f":"'Year 3'!A73","v":0},{"$f":"'Year 3'!B73","v":0},{"$f":"'Year 3'!C73","v":0},{"$f":"'Year 3'!D73","v":"Graduate"},{"$f":"'Year 3'!E73","v":0},{"$f":"'Year 3'!F73*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 3'!M73","v":0},{"$f":"'Year 3'!N73","v":0},{"$f":"'Year 3'!O73","v":0},0,null,{"$f":"'Year 3'!R73","v":0},{"$f":"'Year 3'!S73","v":0},{"$f":"'Year 3'!T73","v":0},{"$f":"J92","v":0}]
[0,0,0,"Graduate",0,0,0,0,0,0,0,null,0,0,0,0,null,0,0,0,{"$f":"J93","v":0}]
[null,null,null,null,null,null,"Sum of Students",null,null,{"$f":"SUM(J69:J76)","v":0}]
["Fringe Benefits for Students"]
["Last Name","First Name","EMPL ID#","Student Type","Insurance Type","Other Support","Hire Date","Fringe Rate",null,"Fringe Benefit Totals","Fringe Rates before 9-1-95",null,null,"Fringe Rates after 9-1-95",null,null,"Insurance and Longevity Calculations"]
[]
[null,null,null,null,"None"]
[null,null,null,null,"Employee"]
[null,null,null,"None","Spouse"]
[null,null,null,"ORP","Children","Yes"]
[null,null,null,"TRS","Family","No",null,null,null,null,"Grad","Under","F1 Sum","Grad","Under","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[{"$f":"'Year 3'!A83","v":0},{"$f":"'Year 3'!B83","v":0},{"$f":"'Year 3'!C83","v":0},{"$f":"'Year 3'!D83","v":"Graduate"},{"$f":"'Year 3'!E83","v":"Employee"},{"$f":"'Year 3'!F83","v":"No"},{"$f":"'Year 3'!G83","v":"2007-09-01"},{"$f":"IF(G86>Fringe1End,P86,M86)","v":7.65},null,{"$f":"(J69*H86/100)+V86","v":0},{"$f":"IF(D69=$D$67,F1.Grad,0)","v":7.65},{"$f":"IF(D69=$D$68,F1.Under,0)","v":0},{"$f":"SUM(K86:L86)","v":7.65},{"$f":"IF(D69=$D$67,F2.Grad,0)","v":7.65},{"$f":"IF(D69=$D$68,F2.Under,0)","v":0},{"$f":"SUM(N86:O86)","v":7.65},{"$f":"IF(F86=$F$84,G69,100)","v":100},{"$f":"IF($E86=$E$82,Ins.PT.E*$K69*Q86/100,0)","v":0},{"$f":"IF($E86=$E$83,Ins.PT.S*$K69*Q86/100,0)","v":0},{"$f":"IF($E86=$E$84,Ins.PT.C*$K69*Q86/100,0)","v":0},{"$f":"IF($E86=$E$85,Ins.PT.F*$K69*Q86/100,0)","v":0},{"$f":"SUM(R86:U86)","v":0}]
[{"$f":"'Year 3'!A84","v":0},{"$f":"'Year 3'!B84","v":0},{"$f":"'Year 3'!C84","v":0},{"$f":"'Year 3'!D84","v":"Graduate"},{"$f":"'Year 3'!E84","v":"Employee"},{"$f":"'Year 3'!F84","v":"No"},{"$f":"'Year 3'!G84","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"'Year 3'!A85","v":0},{"$f":"'Year 3'!B85","v":0},{"$f":"'Year 3'!C85","v":0},{"$f":"'Year 3'!D85","v":"Graduate"},{"$f":"'Year 3'!E85","v":"Employee"},{"$f":"'Year 3'!F85","v":"No"},{"$f":"'Year 3'!G85","v":"2007-09-01"},{"$f":"IF(G88>Fringe1End,P88,M88)","v":7.65},null,0,7.65,0,{"$f":"SUM(K88:L88)","v":7.65},7.65,0,{"$f":"SUM(N88:O88)","v":7.65},100,0,0,0,0,{"$f":"SUM(R88:U88)","v":0}]
[{"$f":"'Year 3'!A86","v":0},{"$f":"'Year 3'!B86","v":0},{"$f":"'Year 3'!C86","v":0},{"$f":"'Year 3'!D86","v":"Graduate"},{"$f":"'Year 3'!E86","v":"Employee"},{"$f":"'Year 3'!F86","v":"No"},{"$f":"'Year 3'!G86","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"'Year 3'!A87","v":0},{"$f":"'Year 3'!B87","v":0},{"$f":"'Year 3'!C87","v":0},{"$f":"'Year 3'!D87","v":"Graduate"},{"$f":"'Year 3'!E87","v":"Employee"},{"$f":"'Year 3'!F87","v":"No"},{"$f":"'Year 3'!G87","v":"2007-09-01"},{"$f":"IF(G90>Fringe1End,P90,M90)","v":7.65},null,0,7.65,0,{"$f":"SUM(K90:L90)","v":7.65},7.65,0,{"$f":"SUM(N90:O90)","v":7.65},100,0,0,0,0,{"$f":"SUM(R90:U90)","v":0}]
[{"$f":"'Year 3'!A88","v":0},{"$f":"'Year 3'!B88","v":0},{"$f":"'Year 3'!C88","v":0},{"$f":"'Year 3'!D88","v":"Graduate"},{"$f":"'Year 3'!E88","v":"Employee"},{"$f":"'Year 3'!F88","v":"No"},{"$f":"'Year 3'!G88","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"'Year 3'!A89","v":0},{"$f":"'Year 3'!B89","v":0},{"$f":"'Year 3'!C89","v":0},{"$f":"'Year 3'!D89","v":"Graduate"},{"$f":"'Year 3'!E89","v":"Employee"},{"$f":"'Year 3'!F89","v":"No"},{"$f":"'Year 3'!G89","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"A76","v":0},{"$f":"B76","v":0},{"$f":"C76","v":0},{"$f":"D76","v":"Graduate"},{"$f":"IF($D76=$D$67,$E$82,$E$81)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[null,null,null,null,null,"Sum of Fringe Benefits for Students",null,null,null,{"$f":"SUM(J86:J93)","v":0},"Grad","Under","F1 Sum","Grad","Under","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[null,null,null,null,null,"Sum of Students and Fringe Benefits",null,null,null,{"$f":"J77+J94","v":0}]
[null,null,null,null,null,"Sum of Salary",null,null,null,{"$f":"J34+J77","v":0}]
[null,null,null,null,null,"Sum of Fringe Benefits",null,null,null,{"$f":"J58+J94","v":0}]
[null,null,null,null,null,"Sum of Personnel and Students",null,null,null,{"$f":"SUM(J96:J97)","v":0}]
["Travel"]
["Component","Description",null,null,null,"Location","Date","Destination",null,"Cost"]
[]
["Transportation",null,null,null,null,"In-State"]
["Meals",null,null,null,null,"Out-of-State"]
["Lodging",null,null,null,null,"Foreign"]
[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,"Sum of Travel",null,null,{"$f":"SUM(J105:J106)","v":0}]
["Capital Expenditures/Equipment D",null,null,null,"These items individually are OVER $5,000."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G110*H110","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G111*H111","v":0}]
[null,null,null,null,null,null,"Sum of Equipment",null,null,{"$f":"SUM(J110:J111)","v":0}]
["Supplies","These items individually are UNDER $5,000."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G115*H115","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G116*H116","v":0}]
[null,null,null,null,null,null,"Sum of Supplies",null,null,{"$f":"SUM(J115:J116)","v":0}]
["Publication Charges",null,null,"For the typical activities included in this category, hold mouse over the cell to the left."]
["Item",null,"Description",null,null,null,"Price","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G120*H120","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G121*H121","v":0}]
[null,null,null,null,null,"Sum of Publication/Printing Charges",null,null,null,{"$f":"SUM(J120:J121)","v":0},"This is the amount that can be charge IDC"]
["Sub-Contracts DÑ",null,"UNT employees can not be recipients of UNT sub-contracts and must be paid in personnel category."]
["Item",null,"Description",null,null,null,null,null,null,"Amount",null,null,null,null,"Year 1","Year 2","Year 3","Year 4"]
[{"$f":"'Year 3'!A121:B121","v":0},null,{"$f":"'Year 3'!C121:H121","v":0},null,null,null,null,null,null,0,{"$f":"IF(M125+J125>25000,IF(M125>=25000,0,25000-M125),J125)","v":0},1,{"$f":"'Year 3'!N121","v":0},{"$f":"SUM(M125,J125)","v":0},{"$f":"'Year 3'!O121","v":0},{"$f":"'Year 3'!P121","v":0},{"$f":"'Year 3'!Q121","v":0},{"$f":"J125","v":0}]
[{"$f":"'Year 3'!A122:B122","v":0},null,{"$f":"'Year 3'!C122:H122","v":0},null,null,null,null,null,null,0,{"$f":"IF(M126+J126>25000,IF(M126>=25000,0,25000-M126),J126)","v":0},1,{"$f":"'Year 3'!N122","v":0},{"$f":"SUM(M126,J126)","v":0},{"$f":"'Year 3'!O122","v":0},{"$f":"'Year 3'!P122","v":0},{"$f":"'Year 3'!Q122","v":0},{"$f":"J126","v":0}]
[{"$f":"'Year 3'!A123:B123","v":0},null,{"$f":"'Year 3'!C123:H123","v":0},null,null,null,null,null,null,0,{"$f":"IF(M127+J127>25000,IF(M127>=25000,0,25000-M127),J127)","v":0},2,{"$f":"'Year 3'!N123","v":0},{"$f":"SUM(M127,J127)","v":0},{"$f":"'Year 3'!O123","v":0},{"$f":"'Year 3'!P123","v":0},{"$f":"'Year 3'!Q123","v":0},{"$f":"J127","v":0}]
[{"$f":"'Year 3'!A124:B124","v":0},null,{"$f":"'Year 3'!C124:H124","v":0},null,null,null,null,null,null,0,{"$f":"IF(M128+J128>25000,IF(M128>=25000,0,25000-M128),J128)","v":0},3,{"$f":"'Year 3'!N124","v":0},{"$f":"SUM(M128,J128)","v":0},{"$f":"'Year 3'!O124","v":0},{"$f":"'Year 3'!P124","v":0},{"$f":"'Year 3'!Q124","v":0},{"$f":"J128","v":0}]
[0,null,null,null,null,null,null,null,null,0,{"$f":"IF(M129+J129>25000,IF(M129>=25000,0,25000-M129),J129)","v":0},4,0,{"$f":"SUM(M129,J128)","v":0},0,0,0,{"$f":"J129","v":0}]
[null,null,null,null,null,"Sum of Sub-Contracts",null,null,null,{"$f":"SUM(J125:J129)","v":0},{"$f":"SUM(K125:K129)","v":0},"Year","Previous","Current"]
["Participant Support Costs D"]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[]
["Scholarship"]
["Fellowship"]
["Travel"]
["Subsistence"]
["Other"]
[null,null,null,null,null,null,0,0,null,{"$f":"G139*H139","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G140*H140","v":0}]
[null,null,null,null,null,null,null,"Sum of Participants Support Costs",null,{"$f":"SUM(J139:J140)","v":0}]
["Other-Graduate Student Tuition",null,null,null,"Calculate Grad Tuition in this Budget Category. IDC is not assessed on tuition."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,0,0,null,{"$f":"G150*H150","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G151*H151","v":0}]
[null,null,null,null,null,null,null,"Sum of Other-Graduate Student Tuition ",null,{"$f":"SUM(J150:J151)","v":0}]
["Other-All Other Costs except Graduate Tuition DÑ"]
["Item",null,"Description",null,null,null,"Price","Quantity",null,"Cost"]
[]
["Patient Care Charges",null,null,null,null,null,null,null,null,null,"This is the amount that can be charge IDC"]
["Off-site Facility Rental"]
["(User Defined)"]
[null,null,null,null,null,null,0,0,null,{"$f":"G159*H159","v":0},{"$f":"IF(OR(A159=$A$156,A159=$A$157),0,J159)","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G160*H160","v":0},{"$f":"IF(OR(A160=$A$156,A160=$A$157),0,J160)","v":0}]
[null,null,null,null,null,null,null,"Sum of Other",null,{"$f":"SUM(J159:J160)","v":0},{"$f":"SUM(K159:K160)","v":0}]
["Indirect Costs"]
["IDC Type",null,"IDC rate","Documentation Location",null,"Modified Total Direct Costs (Base for F&A)",null,null,null,{"$f":"(J98+J107+J117+J122+K161+K130)","v":0}]
[{"$f":"'Year 1'!A142:B142","v":"Research"},null,{"$f":"'Year 1'!C142","v":48.5},{"$f":"'Year 1'!D142:F142","v":0},null,null,"IDC Amount",null,null,{"$f":"J163*C164/100","v":0}]
[null,null,null,null,null,"Total Direct Costs (Sponsor Direct)",null,null,null,{"$f":"SUM(J130,J161,J141,J122,J117,J112,J107,J98,J152)","v":0}]
[null,null,null,null,{"$f":"\"Total Amount Requested for \"&J1&\" Budget\"","v":"Total Amount Requested for Year 4 Budget"},null,null,null,null,{"$f":"SUM(J164:J165)","v":0}]
[]
["University of North Texas, Grants & Contracts Administration"]

{"sheet":"Year 5","index":6,"n_rows":173,"n_cols":24,"rows_kept":173,"cut":false,"hidden":false,"merged":[[122,2,122,5],[123,2,123,5],[123,0,123,1],[124,0,124,1],[124,2,124,5],[118,2,118,5],[113,2,113,5],[114,0,114,1],[114,2,114,5],[119,0,119,1],[117,2,117,5],[118,0,118,1],[113,0,113,1],[117,0,117,1],[119,2,119,5],[116,1,116,9],[109,1,109,4],[115,6,115,7],[98,5,98,7],[101,5,101,7],[99,5,99,7],[100,5,100,7],[111,4,111,9],[110,6,110,7],[112,0,112,1],[112,2,112,5],[103,1,103,4],[108,1,108,4],[5,10,5,11],[34,6,34,7],[59,5,59,7],[61,7,62,7],[62,10,62,11],[60,5,60,7],[4,8,5,8],[61,8,62,8],[170,4,170,7],[168,0,168,1],[155,0,155,1],[155,2,155,5],[168,6,168,7],[167,0,167,1],[163,2,163,5],[168,3,168,5],[164,0,164,1],[163,0,163,1],[164,2,164,5],[167,3,167,4],[167,5,167,7],[169,5,169,7],[161,0,161,1],[162,0,162,1],[160,0,160,1],[125,10,127,11],[127,0,127,1],[136,2,136,5],[143,0,143,1],[144,0,144,1],[147,0,147,1],[130,0,130,1],[129,2,129,7],[128,0,128,1],[127,2,127,5],[126,2,126,9],[160,10,162,11],[125,5,125,7],[133,0,133,1],[158,0,158,1],[131,0,131,1],[132,0,132,1],[129,0,129,1],[147,2,147,5],[154,0,154,1],[154,2,154,5],[134,5,134,7],[136,0,136,1],[143,2,143,5],[144,2,144,5],[158,2,158,5],[0,5,0,7],[1,1,1,9],[2,0,2,1],[2,2,2,3],[2,7,2,9],[0,2,0,3],[121,3,121,9],[120,6,120,7],[122,0,122,1],[121,0,121,2],[3,5,3,7],[3,0,3,4],[4,7,5,7],[79,6,79,7],[97,5,97,7],[128,2,128,7],[130,2,130,7],[131,2,131,7],[132,2,132,7],[133,2,133,7]]}
["File Number:",{"$f":"'Year 1'!B1","v":0},"BB version:",null,{"$f":"'Year 1'!E1","v":"FY 2021"},"This Budget is prepared for:",null,null,{"$f":"'Year 1'!I1","v":0},"Year 5"]
["Project Title:",{"$f":"'Year 1'!B2:J2","v":0}]
["Budget Prepared by:",null,{"$f":"'Year 1'!C3:D3","v":0},null,"Phone Number:",{"$f":"'Year 1'!F3","v":0},"E-mail:",{"$f":"'Year 1'!H3:J3","v":0}]
["Project Budget",null,null,null,null,"This Budget was drafted on:",null,null,{"$f":"'Year 1'!I4","v":"00:00:00"},{"$f":"'Year 1'!J4","v":"2007-09-01"}]
["Personnel",null,null,null,null,null,null,"Number of Months (Academic)","Number of Months (Summer)",null,null,null,"Personnel",null,null,null,null,"Fringe"]
["Last Name","First Name","EMPL ID#","Employee Type","Responsibility","Monthly Rate","Percent Effort (%)",null,null,"Project Salary","Rounded Number of Months",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 1","Year 2","Year 3","Year 4","Year 5"]
[]
[null,null,null,null,"PI"]
[null,null,null,null,"Co-PI"]
[null,null,null,null,"Senior Personnel"]
[null,null,null,null,"Research Assistant"]
[null,null,null,null,"Teaching Assistant"]
[null,null,{"$f":"FALSE()","v":false},null,"Investigator"]
[null,null,{"$f":"TRUE()","v":true},"PT Staff","Coordinator"]
[null,null,null,"PT Faculty","Technician"]
[null,null,null,"Hourly","Post Doc"]
[null,null,null,"Faculty","Clerical"]
[null,null,null,"Staff","Programmer"]
[{"$f":"'Year 4'!A19","v":0},{"$f":"'Year 4'!B19","v":0},{"$f":"'Year 4'!C19","v":0},{"$f":"'Year 4'!D19","v":0},{"$f":"'Year 4'!E19","v":0},{"$f":"'Year 4'!F19*(100+Living)/100","v":0},0,0,0,{"$f":"F19*((G19*H19)/100+(G19*I19)/100)","v":0},{"$f":"ROUNDUP(H19+I19,0)","v":0},null,{"$f":"'Year 4'!M19","v":0},{"$f":"'Year 4'!N19","v":0},{"$f":"'Year 4'!O19","v":0},{"$f":"'Year 4'!P19","v":0},{"$f":"J19","v":0},{"$f":"'Year 4'!R19","v":0},{"$f":"'Year 4'!S19","v":0},{"$f":"'Year 4'!T19","v":0},{"$f":"'Year 4'!U19","v":0},{"$f":"J44","v":0}]
[{"$f":"'Year 4'!A20","v":0},{"$f":"'Year 4'!B20","v":0},{"$f":"'Year 4'!C20","v":0},{"$f":"'Year 4'!D20","v":0},{"$f":"'Year 4'!E20","v":0},{"$f":"'Year 4'!F20*(100+Living)/100","v":0},0,0,0,{"$f":"F20*((G20*H20)/100+(G20*I20)/100)","v":0},{"$f":"ROUNDUP(H20+I20,0)","v":0},null,{"$f":"'Year 4'!M20","v":0},{"$f":"'Year 4'!N20","v":0},{"$f":"'Year 4'!O20","v":0},{"$f":"'Year 4'!P20","v":0},0,{"$f":"'Year 4'!R20","v":0},{"$f":"'Year 4'!S20","v":0},{"$f":"'Year 4'!T20","v":0},{"$f":"'Year 4'!U20","v":0},{"$f":"J44","v":0}]
[{"$f":"'Year 4'!A21","v":0},{"$f":"'Year 4'!B21","v":0},{"$f":"'Year 4'!C21","v":0},{"$f":"'Year 4'!D21","v":0},{"$f":"'Year 4'!E21","v":0},{"$f":"'Year 4'!F21*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 4'!M21","v":0},{"$f":"'Year 4'!N21","v":0},{"$f":"'Year 4'!O21","v":0},{"$f":"'Year 4'!P21","v":0},0,{"$f":"'Year 4'!R21","v":0},{"$f":"'Year 4'!S21","v":0},{"$f":"'Year 4'!T21","v":0},{"$f":"'Year 4'!U21","v":0},{"$f":"J45","v":0}]
[{"$f":"'Year 4'!A22","v":0},{"$f":"'Year 4'!B22","v":0},{"$f":"'Year 4'!C22","v":0},{"$f":"'Year 4'!D22","v":0},{"$f":"'Year 4'!E22","v":0},{"$f":"'Year 4'!F22*(100+Living)/100","v":0},0,0,0,{"$f":"F22*((G22*H22)/100+(G22*I22)/100)","v":0},0,null,{"$f":"'Year 4'!M22","v":0},{"$f":"'Year 4'!N22","v":0},{"$f":"'Year 4'!O22","v":0},{"$f":"'Year 4'!P22","v":0},0,{"$f":"'Year 4'!R22","v":0},{"$f":"'Year 4'!S22","v":0},{"$f":"'Year 4'!T22","v":0},{"$f":"'Year 4'!U22","v":0},{"$f":"J46","v":0}]
[{"$f":"'Year 4'!A23","v":0},{"$f":"'Year 4'!B23","v":0},{"$f":"'Year 4'!C23","v":0},{"$f":"'Year 4'!D23","v":0},{"$f":"'Year 4'!E23","v":0},{"$f":"'Year 4'!F23*(100+Living)/100","v":0},0,0,0,{"$f":"F23*((G23*H23)/100+(G23*I23)/100)","v":0},{"$f":"ROUNDUP(H23+I23,0)","v":0},null,{"$f":"'Year 4'!M23","v":0},{"$f":"'Year 4'!N23","v":0},{"$f":"'Year 4'!O23","v":0},{"$f":"'Year 4'!P23","v":0},0,{"$f":"'Year 4'!R23","v":0},{"$f":"'Year 4'!S23","v":0},{"$f":"'Year 4'!T23","v":0},{"$f":"'Year 4'!U23","v":0},{"$f":"J47","v":0}]
[{"$f":"'Year 4'!A24","v":0},{"$f":"'Year 4'!B24","v":0},{"$f":"'Year 4'!C24","v":0},{"$f":"'Year 4'!D24","v":0},{"$f":"'Year 4'!E24","v":0},{"$f":"'Year 4'!F24*(100+Living)/100","v":0},0,0,0,{"$f":"F24*((G24*H24)/100+(G24*I24)/100)","v":0},{"$f":"ROUNDUP(H24+I24,0)","v":0},null,{"$f":"'Year 4'!M24","v":0},{"$f":"'Year 4'!N24","v":0},{"$f":"'Year 4'!O24","v":0},{"$f":"'Year 4'!P24","v":0},0,{"$f":"'Year 4'!R24","v":0},{"$f":"'Year 4'!S24","v":0},{"$f":"'Year 4'!T24","v":0},{"$f":"'Year 4'!U24","v":0},{"$f":"J48","v":0}]
[{"$f":"'Year 4'!A25","v":0},{"$f":"'Year 4'!B25","v":0},{"$f":"'Year 4'!C25","v":0},{"$f":"'Year 4'!D25","v":0},{"$f":"'Year 4'!E25","v":0},{"$f":"'Year 4'!F25*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 4'!M25","v":0},{"$f":"'Year 4'!N25","v":0},{"$f":"'Year 4'!O25","v":0},{"$f":"'Year 4'!P25","v":0},0,{"$f":"'Year 4'!R25","v":0},{"$f":"'Year 4'!S25","v":0},{"$f":"'Year 4'!T25","v":0},{"$f":"'Year 4'!U25","v":0},{"$f":"J50","v":0}]
[{"$f":"'Year 4'!A26","v":0},{"$f":"'Year 4'!B26","v":0},{"$f":"'Year 4'!C26","v":0},{"$f":"'Year 4'!D26","v":0},{"$f":"'Year 4'!E26","v":0},{"$f":"'Year 4'!F26*(100+Living)/100","v":0},0,0,0,{"$f":"F26*((G26*H26)/100+(G26*I26)/100)","v":0},{"$f":"ROUNDUP(H26+I26,0)","v":0},null,{"$f":"'Year 4'!M26","v":0},{"$f":"'Year 4'!N26","v":0},{"$f":"'Year 4'!O26","v":0},{"$f":"'Year 4'!P26","v":0},0,{"$f":"'Year 4'!R26","v":0},{"$f":"'Year 4'!S26","v":0},{"$f":"'Year 4'!T26","v":0},{"$f":"'Year 4'!U26","v":0},{"$f":"J50","v":0}]
[{"$f":"'Year 4'!A27","v":0},{"$f":"'Year 4'!B27","v":0},{"$f":"'Year 4'!C27","v":0},{"$f":"'Year 4'!D27","v":0},{"$f":"'Year 4'!E27","v":0},{"$f":"'Year 4'!F27*(100+Living)/100","v":0},0,0,0,{"$f":"F27*((G27*H27)/100+(G27*I27)/100)","v":0},{"$f":"ROUNDUP(H27+I27,0)","v":0},null,{"$f":"'Year 4'!M27","v":0},{"$f":"'Year 4'!N27","v":0},{"$f":"'Year 4'!O27","v":0},{"$f":"'Year 4'!P27","v":0},0,{"$f":"'Year 4'!R27","v":0},{"$f":"'Year 4'!S27","v":0},{"$f":"'Year 4'!T27","v":0},{"$f":"'Year 4'!U27","v":0},{"$f":"J51","v":0}]
[{"$f":"'Year 4'!A28","v":0},{"$f":"'Year 4'!B28","v":0},{"$f":"'Year 4'!C28","v":0},{"$f":"'Year 4'!D28","v":0},{"$f":"'Year 4'!E28","v":0},{"$f":"'Year 4'!F28*(100+Living)/100","v":0},0,0,0,{"$f":"F28*((G28*H28)/100+(G28*I28)/100)","v":0},{"$f":"ROUNDUP(H28+I28,0)","v":0},null,{"$f":"'Year 4'!M28","v":0},{"$f":"'Year 4'!N28","v":0},{"$f":"'Year 4'!O28","v":0},{"$f":"'Year 4'!P28","v":0},{"$f":"J28","v":0},{"$f":"'Year 4'!R28","v":0},{"$f":"'Year 4'!S28","v":0},{"$f":"'Year 4'!T28","v":0},{"$f":"'Year 4'!U28","v":0},{"$f":"J52","v":0}]
[{"$f":"'Year 4'!A29","v":0},{"$f":"'Year 4'!B29","v":0},{"$f":"'Year 4'!C29","v":0},{"$f":"'Year 4'!D29","v":0},{"$f":"'Year 4'!E29","v":0},{"$f":"'Year 4'!F29*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 4'!M29","v":0},{"$f":"'Year 4'!N29","v":0},{"$f":"'Year 4'!O29","v":0},{"$f":"'Year 4'!P29","v":0},0,{"$f":"'Year 4'!R29","v":0},{"$f":"'Year 4'!S29","v":0},{"$f":"'Year 4'!T29","v":0},{"$f":"'Year 4'!U29","v":0},{"$f":"J54","v":0}]
[{"$f":"'Year 4'!A30","v":0},{"$f":"'Year 4'!B30","v":0},{"$f":"'Year 4'!C30","v":0},{"$f":"'Year 4'!D30","v":0},{"$f":"'Year 4'!E30","v":0},{"$f":"'Year 4'!F30*(100+Living)/100","v":0},0,0,0,{"$f":"F30*((G30*H30)/100+(G30*I30)/100)","v":0},{"$f":"ROUNDUP(H30+I30,0)","v":0},null,{"$f":"'Year 4'!M30","v":0},{"$f":"'Year 4'!N30","v":0},{"$f":"'Year 4'!O30","v":0},{"$f":"'Year 4'!P30","v":0},0,{"$f":"'Year 4'!R30","v":0},{"$f":"'Year 4'!S30","v":0},{"$f":"'Year 4'!T30","v":0},{"$f":"'Year 4'!U30","v":0},{"$f":"J54","v":0}]
[{"$f":"'Year 4'!A31","v":0},{"$f":"'Year 4'!B31","v":0},{"$f":"'Year 4'!C31","v":0},{"$f":"'Year 4'!D31","v":0},{"$f":"'Year 4'!E31","v":0},{"$f":"'Year 4'!F31*(100+Living)/100","v":0},0,0,0,{"$f":"F31*((G31*H31)/100+(G31*I31)/100)","v":0},{"$f":"ROUNDUP(H31+I31,0)","v":0},null,{"$f":"'Year 4'!M31","v":0},{"$f":"'Year 4'!N31","v":0},{"$f":"'Year 4'!O31","v":0},{"$f":"'Year 4'!P31","v":0},{"$f":"J31","v":0},{"$f":"'Year 4'!R31","v":0},{"$f":"'Year 4'!S31","v":0},{"$f":"'Year 4'!T31","v":0},{"$f":"'Year 4'!U31","v":0},{"$f":"J55","v":0}]
[{"$f":"'Year 4'!A32","v":0},{"$f":"'Year 4'!B32","v":0},{"$f":"'Year 4'!C32","v":0},{"$f":"'Year 4'!D32","v":0},{"$f":"'Year 4'!E32","v":0},{"$f":"'Year 4'!F32*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 4'!M32","v":0},{"$f":"'Year 4'!N32","v":0},{"$f":"'Year 4'!O32","v":0},{"$f":"'Year 4'!P32","v":0},0,{"$f":"'Year 4'!R32","v":0},{"$f":"'Year 4'!S32","v":0},{"$f":"'Year 4'!T32","v":0},{"$f":"'Year 4'!U32","v":0},{"$f":"J57","v":0}]
[{"$f":"'Year 4'!A33","v":0},{"$f":"'Year 4'!B33","v":0},{"$f":"'Year 4'!C33","v":0},{"$f":"'Year 4'!D33","v":0},{"$f":"'Year 4'!E33","v":0},{"$f":"'Year 4'!F33*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 4'!M33","v":0},{"$f":"'Year 4'!N33","v":0},{"$f":"'Year 4'!O33","v":0},{"$f":"'Year 4'!P33","v":0},0,{"$f":"'Year 4'!R33","v":0},{"$f":"'Year 4'!S33","v":0},{"$f":"'Year 4'!T33","v":0},{"$f":"'Year 4'!U33","v":0},{"$f":"J58","v":0}]
[0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,{"$f":"J59","v":0}]
[null,null,null,null,null,null,"Sum of Personnel",null,null,{"$f":"SUM(J19:J34)","v":0}]
["Fringe Benefits for Personnel"]
["Last Name","First Name","EMPL ID#","Retirement","Insurance Type","Other Support","Hire Date","Fringe Rate",null,"Fringe Benefit Totals","Fringe Rates before 9-1-95",null,null,null,"Fringe Rates after 9-1-95",null,null,null,"Insurance and Longevity Calculations"]
[]
[null,null,null,null,"None"]
[null,null,null,null,"Employee"]
[null,null,null,"Hourly","Spouse"]
[null,null,null,"ORP","Children","Yes"]
[null,null,null,"TRS","Family","No",null,null,null,null,"Hourly","ORP","TRS","F1 Sum","Hourly","ORP","TRS","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[{"$f":"'Year 4'!A43","v":0},{"$f":"'Year 4'!B43","v":0},{"$f":"'Year 4'!C43","v":0},{"$f":"'Year 4'!D43","v":"TRS"},{"$f":"'Year 4'!E43","v":"Employee"},{"$f":"'Year 4'!F43","v":"Yes"},{"$f":"'Year 4'!G43","v":"2007-09-01"},{"$f":"IF(G44>Fringe1End,R44,N44)","v":15.15},null,{"$f":"(J19*H44/100)+X44","v":0},{"$f":"IF(D44=$D$41,F1.Hourly,0)","v":0},{"$f":"IF(D44=$D$42,F1.FS.ORP,0)","v":0},{"$f":"IF(D44=$D$43,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K44:M44)","v":21.4},{"$f":"IF(D44=$D$41,F2.Hourly,0)","v":0},{"$f":"IF(D44=$D$42,F2.FS.ORP,0)","v":0},{"$f":"IF(D44=$D$43,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O44:Q44)","v":15.15},{"$f":"IF(F44=$F$42,G19,100)","v":0},{"$f":"IF($E44=$E$40,IF($D19=$D$14,Ins.PT.E*$K19*S44/100,IF($D19=$D$15,Ins.PT.E*$K19*S44/100,Ins.E*$K19*S44/100)),0)","v":0},{"$f":"IF($E44=$E$41,IF($D19=$D$14,Ins.PT.S*$K19*S44/100,IF($D19=$D$15,Ins.PT.S*$K19*S44/100,Ins.S*$K19*S44/100)),0)","v":0},{"$f":"IF($E44=$E$42,IF($D19=$D$14,Ins.PT.C*$K19*S44/100,IF($D19=$D$15,Ins.PT.C*$K19*S44/100,Ins.C*$K19*S44/100)),0)","v":0},{"$f":"IF($E44=$E$43,IF($D19=$D$14,Ins.PT.F*$K19*S44/100,IF($D19=$D$15,Ins.PT.F*$K19*S44/100,Ins.F*$K19*S44/100)),0)","v":0},{"$f":"IF(D19=$D$18,ROUNDDOWN(DAYS360(G44,$J$4)/(360*Long.Per),0)*20*K19*G19/100,0)+SUM(T44:W44)","v":0}]
[{"$f":"'Year 4'!A44","v":0},{"$f":"'Year 4'!B44","v":0},{"$f":"'Year 4'!C44","v":0},{"$f":"'Year 4'!D44","v":"TRS"},{"$f":"'Year 4'!E44","v":"Employee"},{"$f":"'Year 4'!F44","v":"Yes"},{"$f":"'Year 4'!G44","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 4'!A45","v":0},{"$f":"'Year 4'!B45","v":0},{"$f":"'Year 4'!C45","v":0},{"$f":"'Year 4'!D45","v":"TRS"},{"$f":"'Year 4'!E45","v":"Employee"},{"$f":"'Year 4'!F45","v":"Yes"},{"$f":"'Year 4'!G45","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 4'!A46","v":0},{"$f":"'Year 4'!B46","v":0},{"$f":"'Year 4'!C46","v":0},{"$f":"'Year 4'!D46","v":"TRS"},{"$f":"'Year 4'!E46","v":"Employee"},{"$f":"'Year 4'!F46","v":"Yes"},{"$f":"'Year 4'!G46","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 4'!A47","v":0},{"$f":"'Year 4'!B47","v":0},{"$f":"'Year 4'!C47","v":0},{"$f":"'Year 4'!D47","v":"TRS"},{"$f":"'Year 4'!E47","v":"Employee"},{"$f":"'Year 4'!F47","v":"Yes"},{"$f":"'Year 4'!G47","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 4'!A48","v":0},{"$f":"'Year 4'!B48","v":0},{"$f":"'Year 4'!C48","v":0},{"$f":"'Year 4'!D48","v":"TRS"},{"$f":"'Year 4'!E48","v":"Employee"},{"$f":"'Year 4'!F48","v":"Yes"},{"$f":"'Year 4'!G48","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 4'!A49","v":0},{"$f":"'Year 4'!B49","v":0},{"$f":"'Year 4'!C49","v":0},{"$f":"'Year 4'!D49","v":"TRS"},{"$f":"'Year 4'!E49","v":"Employee"},{"$f":"'Year 4'!F49","v":"Yes"},{"$f":"'Year 4'!G49","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 4'!A50","v":0},{"$f":"'Year 4'!B50","v":0},{"$f":"'Year 4'!C50","v":0},{"$f":"'Year 4'!D50","v":"TRS"},{"$f":"'Year 4'!E50","v":"Employee"},{"$f":"'Year 4'!F50","v":"No"},{"$f":"'Year 4'!G50","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 4'!A51","v":0},{"$f":"'Year 4'!B51","v":0},{"$f":"'Year 4'!C51","v":0},{"$f":"'Year 4'!D51","v":"TRS"},{"$f":"'Year 4'!E51","v":"Employee"},{"$f":"'Year 4'!F51","v":"No"},{"$f":"'Year 4'!G51","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 4'!A52","v":0},{"$f":"'Year 4'!B52","v":0},{"$f":"'Year 4'!C52","v":0},{"$f":"'Year 4'!D52","v":"TRS"},{"$f":"'Year 4'!E52","v":"Employee"},{"$f":"'Year 4'!F52","v":"No"},{"$f":"'Year 4'!G52","v":"2007-09-01"},{"$f":"IF(G53>Fringe1End,R53,N53)","v":15.15},null,0,{"$f":"IF(D53=$D$41,F1.Hourly,0)","v":0},{"$f":"IF(D53=$D$42,F1.FS.ORP,0)","v":0},{"$f":"IF(D53=$D$43,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K53:M53)","v":21.4},{"$f":"IF(D53=$D$41,F2.Hourly,0)","v":0},{"$f":"IF(D53=$D$42,F2.FS.ORP,0)","v":0},{"$f":"IF(D53=$D$43,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O53:Q53)","v":15.15},100,0,0,0,0,0]
[{"$f":"'Year 4'!A53","v":0},{"$f":"'Year 4'!B53","v":0},{"$f":"'Year 4'!C53","v":0},{"$f":"'Year 4'!D53","v":"TRS"},{"$f":"'Year 4'!E53","v":"Employee"},{"$f":"'Year 4'!F53","v":"No"},{"$f":"'Year 4'!G53","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 4'!A54","v":0},{"$f":"'Year 4'!B54","v":0},{"$f":"'Year 4'!C54","v":0},{"$f":"'Year 4'!D54","v":"TRS"},{"$f":"'Year 4'!E54","v":"Employee"},{"$f":"'Year 4'!F54","v":"No"},{"$f":"'Year 4'!G54","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 4'!A55","v":0},{"$f":"'Year 4'!B55","v":0},{"$f":"'Year 4'!C55","v":0},{"$f":"'Year 4'!D55","v":"TRS"},{"$f":"'Year 4'!E55","v":"Employee"},{"$f":"'Year 4'!F55","v":"No"},{"$f":"'Year 4'!G55","v":"2007-09-01"},{"$f":"IF(G56>Fringe1End,R56,N56)","v":15.15},null,0,{"$f":"IF(D56=$D$41,F1.Hourly,0)","v":0},{"$f":"IF(D56=$D$42,F1.FS.ORP,0)","v":0},{"$f":"IF(D56=$D$43,F1.FS.TRS,0)","v":21.4},{"$f":"SUM(K56:M56)","v":21.4},{"$f":"IF(D56=$D$41,F2.Hourly,0)","v":0},{"$f":"IF(D56=$D$42,F2.FS.ORP,0)","v":0},{"$f":"IF(D56=$D$43,F2.FS.TRS,0)","v":15.15},{"$f":"SUM(O56:Q56)","v":15.15},100,0,0,0,0,0]
[{"$f":"'Year 4'!A56","v":0},{"$f":"'Year 4'!B56","v":0},{"$f":"'Year 4'!C56","v":0},{"$f":"'Year 4'!D56","v":"TRS"},{"$f":"'Year 4'!E56","v":"Employee"},{"$f":"'Year 4'!F56","v":"No"},{"$f":"'Year 4'!G56","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"'Year 4'!A57","v":0},{"$f":"'Year 4'!B57","v":0},{"$f":"'Year 4'!C57","v":0},{"$f":"'Year 4'!D57","v":"TRS"},{"$f":"'Year 4'!E57","v":"Employee"},{"$f":"'Year 4'!F57","v":"No"},{"$f":"'Year 4'!G57","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[{"$f":"A34","v":0},{"$f":"B34","v":0},{"$f":"C34","v":0},{"$f":"IF($D34=$D$16,$D$41,$D$43)","v":"TRS"},{"$f":"IF($D34=$D$16,$E$39,$E$40)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},15.15,null,0,0,0,21.4,21.4,0,0,15.15,15.15,100,0,0,0,0,0]
[null,null,null,null,null,"Sum of Fringe Benefits for Personnel",null,null,null,{"$f":"SUM(J44:J59)","v":0},"Hourly","ORP","TRS","F1 Sum","Hourly","ORP","TRS","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[null,null,null,null,null,"Sum of Personnel and Fringe Benefits",null,null,null,{"$f":"J35+J60","v":0}]
["Students",null,null,null,null,null,null,"Number of Months (Academic)","Number of Months\n(Summer)",null,null,null,"Students",null,null,null,null,"Fringe"]
["Last Name","First Name","EMPL ID#","Student Type","Responsibility","Monthly Rate","Percent Effort (%)",null,null,"Project Salary","Rounded Number of Months",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 1","Year 2","Year 3","Year 4","Year 5"]
[]
[]
[null,null,null,{"$f":"FALSE()","v":false}]
[null,null,null,{"$f":"TRUE()","v":true}]
[null,null,null,null,"Clerical"]
[null,null,null,"Graduate","Programmer"]
[null,null,null,"Undergrad","Research Assistant"]
[{"$f":"'Year 4'!A69","v":0},{"$f":"'Year 4'!B69","v":0},{"$f":"'Year 4'!C69","v":0},{"$f":"'Year 4'!D69","v":"Graduate"},{"$f":"'Year 4'!E69","v":0},{"$f":"'Year 4'!F69*(100+Living)/100","v":0},0,0,0,{"$f":"F71*((G71*H71)/100+(G71*I71)/100)","v":0},{"$f":"ROUNDUP(H71+I71,0)","v":0},null,{"$f":"'Year 4'!M69","v":0},{"$f":"'Year 4'!N69","v":0},{"$f":"'Year 4'!O69","v":0},{"$f":"'Year 4'!P69","v":0},{"$f":"J71","v":0},{"$f":"'Year 4'!R69","v":0},{"$f":"'Year 4'!S69","v":0},{"$f":"'Year 4'!T69","v":0},{"$f":"'Year 4'!U69","v":0},{"$f":"J89","v":0}]
[{"$f":"'Year 4'!A70","v":0},{"$f":"'Year 4'!B70","v":0},{"$f":"'Year 4'!C70","v":0},{"$f":"'Year 4'!D70","v":"Graduate"},{"$f":"'Year 4'!E70","v":0},{"$f":"'Year 4'!F70*(100+Living)/100","v":0},0,0,0,{"$f":"F72*((G72*H72)/100+(G72*I72)/100)","v":0},{"$f":"ROUNDUP(H72+I72,0)","v":0},null,{"$f":"'Year 4'!M70","v":0},{"$f":"'Year 4'!N70","v":0},{"$f":"'Year 4'!O70","v":0},{"$f":"'Year 4'!P70","v":0},{"$f":"J72","v":0},{"$f":"'Year 4'!R70","v":0},{"$f":"'Year 4'!S70","v":0},{"$f":"'Year 4'!T70","v":0},{"$f":"'Year 4'!U70","v":0},{"$f":"J89","v":0}]
[{"$f":"'Year 4'!A71","v":0},{"$f":"'Year 4'!B71","v":0},{"$f":"'Year 4'!C71","v":0},{"$f":"'Year 4'!D71","v":"Graduate"},{"$f":"'Year 4'!E71","v":0},{"$f":"'Year 4'!F71*(100+Living)/100","v":0},0,0,0,{"$f":"F73*((G73*H73)/100+(G73*I73)/100)","v":0},{"$f":"ROUNDUP(H73+I73,0)","v":0},null,{"$f":"'Year 4'!M71","v":0},{"$f":"'Year 4'!N71","v":0},{"$f":"'Year 4'!O71","v":0},{"$f":"'Year 4'!P71","v":0},{"$f":"J73","v":0},{"$f":"'Year 4'!R71","v":0},{"$f":"'Year 4'!S71","v":0},{"$f":"'Year 4'!T71","v":0},{"$f":"'Year 4'!U71","v":0},{"$f":"J90","v":0}]
[{"$f":"'Year 4'!A72","v":0},{"$f":"'Year 4'!B72","v":0},{"$f":"'Year 4'!C72","v":0},{"$f":"'Year 4'!D72","v":"Graduate"},{"$f":"'Year 4'!E72","v":0},{"$f":"'Year 4'!F72*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 4'!M72","v":0},{"$f":"'Year 4'!N72","v":0},{"$f":"'Year 4'!O72","v":0},{"$f":"'Year 4'!P72","v":0},0,{"$f":"'Year 4'!R72","v":0},{"$f":"'Year 4'!S72","v":0},{"$f":"'Year 4'!T72","v":0},{"$f":"'Year 4'!U72","v":0},{"$f":"J92","v":0}]
[{"$f":"'Year 4'!A73","v":0},{"$f":"'Year 4'!B73","v":0},{"$f":"'Year 4'!C73","v":0},{"$f":"'Year 4'!D73","v":"Graduate"},{"$f":"'Year 4'!E73","v":0},{"$f":"'Year 4'!F73*(100+Living)/100","v":0},0,0,0,{"$f":"F75*((G75*H75)/100+(G75*I75)/100)","v":0},{"$f":"ROUNDUP(H75+I75,0)","v":0},null,{"$f":"'Year 4'!M73","v":0},{"$f":"'Year 4'!N73","v":0},{"$f":"'Year 4'!O73","v":0},{"$f":"'Year 4'!P73","v":0},{"$f":"J75","v":0},{"$f":"'Year 4'!R73","v":0},{"$f":"'Year 4'!S73","v":0},{"$f":"'Year 4'!T73","v":0},{"$f":"'Year 4'!U73","v":0},{"$f":"J92","v":0}]
[{"$f":"'Year 4'!A74","v":0},{"$f":"'Year 4'!B74","v":0},{"$f":"'Year 4'!C74","v":0},{"$f":"'Year 4'!D74","v":"Graduate"},{"$f":"'Year 4'!E74","v":0},{"$f":"'Year 4'!F74*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 4'!M74","v":0},{"$f":"'Year 4'!N74","v":0},{"$f":"'Year 4'!O74","v":0},{"$f":"'Year 4'!P74","v":0},0,{"$f":"'Year 4'!R74","v":0},{"$f":"'Year 4'!S74","v":0},{"$f":"'Year 4'!T74","v":0},{"$f":"'Year 4'!U74","v":0},{"$f":"J94","v":0}]
[{"$f":"'Year 4'!A75","v":0},{"$f":"'Year 4'!B75","v":0},{"$f":"'Year 4'!C75","v":0},{"$f":"'Year 4'!D75","v":"Graduate"},{"$f":"'Year 4'!E75","v":0},{"$f":"'Year 4'!F75*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 4'!M75","v":0},{"$f":"'Year 4'!N75","v":0},{"$f":"'Year 4'!O75","v":0},{"$f":"'Year 4'!P75","v":0},0,{"$f":"'Year 4'!R75","v":0},{"$f":"'Year 4'!S75","v":0},{"$f":"'Year 4'!T75","v":0},{"$f":"'Year 4'!U75","v":0},{"$f":"J95","v":0}]
[{"$f":"'Year 4'!A76","v":0},{"$f":"'Year 4'!B76","v":0},{"$f":"'Year 4'!C76","v":0},{"$f":"'Year 4'!D76","v":"Graduate"},{"$f":"'Year 4'!E76","v":0},{"$f":"'Year 4'!F76*(100+Living)/100","v":0},0,0,0,0,0,null,{"$f":"'Year 4'!M76","v":0},{"$f":"'Year 4'!N76","v":0},{"$f":"'Year 4'!O76","v":0},{"$f":"'Year 4'!P76","v":0},0,{"$f":"'Year 4'!R76","v":0},{"$f":"'Year 4'!S76","v":0},{"$f":"'Year 4'!T76","v":0},{"$f":"'Year 4'!U76","v":0},{"$f":"J96","v":0}]
[0,0,0,"Graduate",0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,{"$f":"J97","v":0}]
[null,null,null,null,null,null,"Sum of Students",null,null,{"$f":"SUM(J71:J79)","v":0}]
["Fringe Benefits for Students"]
["Last Name","First Name","EMPL ID#","Student Type","Insurance Type","Other Support","Hire Date","Fringe Rate",null,"Fringe Benefit Totals","Fringe Rates before 9-1-95",null,null,"Fringe Rates after 9-1-95",null,null,"Insurance and Longevity Calculations"]
[]
[null,null,null,null,"None"]
[null,null,null,null,"Employee"]
[null,null,null,"None","Spouse"]
[null,null,null,"ORP","Children","Yes"]
[null,null,null,"TRS","Family","No",null,null,null,null,"Grad","Under","F1 Sum","Grad","Under","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[{"$f":"'Year 4'!A86","v":0},{"$f":"'Year 4'!B86","v":0},{"$f":"'Year 4'!C86","v":0},{"$f":"'Year 4'!D86","v":"Graduate"},{"$f":"'Year 4'!E86","v":"Employee"},{"$f":"'Year 4'!F86","v":"No"},{"$f":"'Year 4'!G86","v":"2007-09-01"},{"$f":"IF(G89>Fringe1End,P89,M89)","v":7.65},null,{"$f":"(J71*H89/100)+V89","v":0},{"$f":"IF(D71=$D$69,F1.Grad,0)","v":7.65},{"$f":"IF(D71=$D$70,F1.Under,0)","v":0},{"$f":"SUM(K89:L89)","v":7.65},{"$f":"IF(D71=$D$69,F2.Grad,0)","v":7.65},{"$f":"IF(D71=$D$70,F2.Under,0)","v":0},{"$f":"SUM(N89:O89)","v":7.65},{"$f":"IF(F89=$F$87,G71,100)","v":100},{"$f":"IF($E89=$E$85,Ins.PT.E*$K71*Q89/100,0)","v":0},{"$f":"IF($E89=$E$86,Ins.PT.S*$K71*Q89/100,0)","v":0},{"$f":"IF($E89=$E$87,Ins.PT.C*$K71*Q89/100,0)","v":0},{"$f":"IF($E89=$E$88,Ins.PT.F*$K71*Q89/100,0)","v":0},{"$f":"SUM(R89:U89)","v":0}]
[{"$f":"'Year 4'!A87","v":0},{"$f":"'Year 4'!B87","v":0},{"$f":"'Year 4'!C87","v":0},{"$f":"'Year 4'!D87","v":"Graduate"},{"$f":"'Year 4'!E87","v":"Employee"},{"$f":"'Year 4'!F87","v":"No"},{"$f":"'Year 4'!G87","v":"2007-09-01"},{"$f":"IF(G90>Fringe1End,P90,M90)","v":7.65},null,0,7.65,0,{"$f":"SUM(K90:L90)","v":7.65},7.65,0,{"$f":"SUM(N90:O90)","v":7.65},100,0,0,0,0,{"$f":"SUM(R90:U90)","v":0}]
[{"$f":"'Year 4'!A88","v":0},{"$f":"'Year 4'!B88","v":0},{"$f":"'Year 4'!C88","v":0},{"$f":"'Year 4'!D88","v":"Graduate"},{"$f":"'Year 4'!E88","v":"Employee"},{"$f":"'Year 4'!F88","v":"No"},{"$f":"'Year 4'!G88","v":"2007-09-01"},{"$f":"IF(G91>Fringe1End,P91,M91)","v":7.65},null,0,7.65,0,{"$f":"SUM(K91:L91)","v":7.65},7.65,0,{"$f":"SUM(N91:O91)","v":7.65},100,0,0,0,0,{"$f":"SUM(R91:U91)","v":0}]
[{"$f":"'Year 4'!A89","v":0},{"$f":"'Year 4'!B89","v":0},{"$f":"'Year 4'!C89","v":0},{"$f":"'Year 4'!D89","v":"Graduate"},{"$f":"'Year 4'!E89","v":"Employee"},{"$f":"'Year 4'!F89","v":"No"},{"$f":"'Year 4'!G89","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"'Year 4'!A90","v":0},{"$f":"'Year 4'!B90","v":0},{"$f":"'Year 4'!C90","v":0},{"$f":"'Year 4'!D90","v":"Graduate"},{"$f":"'Year 4'!E90","v":"Employee"},{"$f":"'Year 4'!F90","v":"No"},{"$f":"'Year 4'!G90","v":"2007-09-01"},{"$f":"IF(G93>Fringe1End,P93,M93)","v":7.65},null,0,7.65,0,{"$f":"SUM(K93:L93)","v":7.65},7.65,0,{"$f":"SUM(N93:O93)","v":7.65},100,0,0,0,0,{"$f":"SUM(R93:U93)","v":0}]
[{"$f":"'Year 4'!A91","v":0},{"$f":"'Year 4'!B91","v":0},{"$f":"'Year 4'!C91","v":0},{"$f":"'Year 4'!D91","v":"Graduate"},{"$f":"'Year 4'!E91","v":"Employee"},{"$f":"'Year 4'!F91","v":"No"},{"$f":"'Year 4'!G91","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"'Year 4'!A92","v":0},{"$f":"'Year 4'!B92","v":0},{"$f":"'Year 4'!C92","v":0},{"$f":"'Year 4'!D92","v":"Graduate"},{"$f":"'Year 4'!E92","v":"Employee"},{"$f":"'Year 4'!F92","v":"No"},{"$f":"'Year 4'!G92","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"'Year 4'!A93","v":0},{"$f":"'Year 4'!B93","v":0},{"$f":"'Year 4'!C93","v":0},{"$f":"'Year 4'!D93","v":"Graduate"},{"$f":"'Year 4'!E93","v":"Employee"},{"$f":"'Year 4'!F93","v":"No"},{"$f":"'Year 4'!G93","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[{"$f":"A79","v":0},{"$f":"B79","v":0},{"$f":"C79","v":0},{"$f":"D79","v":"Graduate"},{"$f":"IF($D79=$D$69,$E$85,$E$84)","v":"Employee"},"No",{"$f":"$J$4","v":"2007-09-01"},7.65,null,0,7.65,0,7.65,7.65,0,7.65,100,0,0,0,0,0]
[null,null,null,null,null,"Sum of Fringe Benefits for Students",null,null,null,{"$f":"SUM(J89:J97)","v":0},"Grad","Under","F1 Sum","Grad","Under","F2 Sum","% I applied","Employee","Spouse","Children","Family","Ins Sum"]
[null,null,null,null,null,"Sum of Students and Fringe Benefits",null,null,null,{"$f":"J80+J98","v":0}]
[null,null,null,null,null,"Sum of Salary",null,null,null,{"$f":"J35+J80","v":0}]
[null,null,null,null,null,"Sum of Fringe Benefits",null,null,null,{"$f":"J60+J98","v":0}]
[null,null,null,null,null,"Sum of Personnel and Students",null,null,null,{"$f":"SUM(J100:J101)","v":0}]
["Travel"]
["Component","Description",null,null,null,"Location","Date","Destination",null,"Cost"]
[]
["Transportation",null,null,null,null,"In-State"]
["Meals",null,null,null,null,"Out-of-State"]
["Lodging",null,null,null,null,"Foreign"]
[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,"Sum of Travel",null,null,{"$f":"SUM(J109:J110)","v":0}]
["Capital Expenditures/Equipment D",null,null,null,"These items individually are OVER $5,000."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G114*H114","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G115*H115","v":0}]
[null,null,null,null,null,null,"Sum of Equipment",null,null,{"$f":"SUM(J114:J115)","v":0}]
["Supplies","These items individually are UNDER $5,000."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G119*H119","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G120*H120","v":0}]
[null,null,null,null,null,null,"Sum of Supplies",null,null,{"$f":"SUM(J119:J120)","v":0}]
["Publication Charges",null,null,"For the typical activities included in this category, hold mouse over the cell to the left."]
["Item",null,"Description",null,null,null,"Price","Quantity",null,"Cost"]
[null,null,null,null,null,null,0,0,null,{"$f":"G124*H124","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G125*H125","v":0}]
[null,null,null,null,null,"Sum of Publication/Printing Charges",null,null,null,{"$f":"SUM(J124:J125)","v":0},"This is the amount that can be charge IDC"]
["Sub-Contracts DÑ",null,"UNT employees can not be recipients of UNT sub-contracts and must be paid in personnel category."]
["Item",null,"Description",null,null,null,null,null,null,"Amount",null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[{"$f":"'Year 4'!A125:B125","v":0},null,{"$f":"'Year 4'!C125:H125","v":0},null,null,null,null,null,null,0,{"$f":"IF(M129+J129>25000,IF(M129>=25000,0,25000-M129),J129)","v":0},1,{"$f":"'Year 4'!N125","v":0},{"$f":"SUM(M129,J129)","v":0},{"$f":"'Year 4'!O125","v":0},{"$f":"'Year 4'!P125","v":0},{"$f":"'Year 4'!Q125","v":0},{"$f":"'Year 4'!R125","v":0},{"$f":"J129","v":0}]
[{"$f":"'Year 4'!A126:B126","v":0},null,{"$f":"'Year 4'!C126:H126","v":0},null,null,null,null,null,null,0,0,1,{"$f":"'Year 4'!N126","v":0},{"$f":"SUM(M130,J130)","v":0},{"$f":"'Year 4'!O126","v":0},{"$f":"'Year 4'!P126","v":0},{"$f":"'Year 4'!Q126","v":0},{"$f":"'Year 4'!R126","v":0},0]
[{"$f":"'Year 4'!A127:B127","v":0},null,{"$f":"'Year 4'!C127:H127","v":0},null,null,null,null,null,null,0,0,2,{"$f":"'Year 4'!N127","v":0},{"$f":"SUM(M131,J131)","v":0},{"$f":"'Year 4'!O127","v":0},{"$f":"'Year 4'!P127","v":0},{"$f":"'Year 4'!Q127","v":0},{"$f":"'Year 4'!R127","v":0},0]
[{"$f":"'Year 4'!A128:B128","v":0},null,{"$f":"'Year 4'!C128:H128","v":0},null,null,null,null,null,null,0,0,3,{"$f":"'Year 4'!N128","v":0},{"$f":"SUM(M132,J132)","v":0},{"$f":"'Year 4'!O128","v":0},{"$f":"'Year 4'!P128","v":0},{"$f":"'Year 4'!Q128","v":0},{"$f":"'Year 4'!R128","v":0},0]
[{"$f":"'Year 4'!A129:B129","v":0},null,{"$f":"'Year 4'!C129:H129","v":0},null,null,null,null,null,null,0,0,4,{"$f":"'Year 4'!N129","v":0},{"$f":"SUM(M133,J132)","v":0},{"$f":"'Year 4'!O129","v":0},{"$f":"'Year 4'!P129","v":0},{"$f":"'Year 4'!Q129","v":0},{"$f":"'Year 4'!R129","v":0},0]
[0,null,null,null,null,null,null,null,null,0,0,5,0,{"$f":"SUM(M134,J133)","v":0},0,0,0,0,0]
[null,null,null,null,null,"Sum of Sub-Contracts",null,null,null,{"$f":"SUM(J129:J134)","v":0},{"$f":"SUM(K129:K134)","v":0},"Year","Previous","Current"]
["Participant Support Costs D"]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[]
["Scholarship"]
["Fellowship"]
["Travel"]
["Subsistence"]
["Other"]
[null,null,null,null,null,null,0,0,null,{"$f":"G144*H144","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G145*H145","v":0}]
[null,null,null,null,null,null,null,"Sum of Participant Support Costs",null,{"$f":"SUM(J144:J145)","v":0}]
["Other-Graduate Student Tuition ",null,null,null,"Calculate Grad Tuition in this Budget Category. IDC is not assessed on tuition."]
["Item",null,"Description",null,null,null,"Amount","Quantity",null,"Cost"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,0,0,null,{"$f":"G155*H155","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G156*H156","v":0}]
[null,null,null,null,null,null,null,"Sum of Other-Graduate Student Tuition ",null,{"$f":"SUM(J155:J156)","v":0}]
["Other-All Other Costs except Graduate Tuition DÑ"]
["Item",null,"Description",null,null,null,"Price","Quantity",null,"Cost"]
[]
["Patient Care Charges",null,null,null,null,null,null,null,null,null,"This is the amount that can be charge IDC"]
["Off-site Facility Rental"]
["(User Defined)"]
[null,null,null,null,null,null,0,0,null,{"$f":"G164*H164","v":0},{"$f":"IF(OR(A164=$A$161,A164=$A$162),0,J164)","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G165*H165","v":0},{"$f":"IF(OR(A165=$A$161,A165=$A$162),0,J165)","v":0}]
[null,null,null,null,null,null,null,"Sum of Other",null,{"$f":"SUM(J164:J165)","v":0},{"$f":"SUM(K164:K165)","v":0}]
["Indirect Costs"]
["IDC Type",null,"IDC rate","Documentation Location",null,"Modified Total Direct Costs (Base for F&A)",null,null,null,{"$f":"(J102+J111+J121+J126+K166+K135)","v":0}]
[{"$f":"'Year 1'!A142:B142","v":"Research"},null,{"$f":"'Year 1'!C142","v":48.5},{"$f":"'Year 1'!D142:F142","v":0},null,null,"IDC Amount",null,null,{"$f":"J168*C169/100","v":0}]
[null,null,null,null,null,"Total Direct Costs (Sponsor Direct)",null,null,null,{"$f":"SUM(J135,J166,J146,J126,J121,J116,J111,J102,J157)","v":0}]
[null,null,null,null,{"$f":"\"Total Amount Requested for \"&J1&\" Budget\"","v":"Total Amount Requested for Year 5 Budget"},null,null,null,null,{"$f":"SUM(J169:J170)","v":0}]
[]
["University of North Texas, Grants & Contracts Administration"]

{"sheet":"Summary","index":7,"n_rows":117,"n_cols":14,"rows_kept":117,"cut":false,"hidden":false,"merged":[[120,2,120,3],[117,2,117,3],[118,2,118,3],[119,2,119,3],[90,1,90,2],[117,7,117,8],[113,2,113,3],[3,1,3,2],[86,1,86,2],[87,1,87,2],[88,1,88,2],[89,1,89,2],[91,1,91,2],[93,0,93,2],[98,0,98,2],[111,2,111,3],[110,7,110,8],[116,0,116,6]]}
["File Number:",null,{"$f":"'Year 1'!B1","v":0},null,null,null,null,null,null,null,null,null,"This Budget was drafted on:"]
["Project Title:",{"$f":"'Year 1'!B2:J2","v":0}]
["BB Version:",{"$f":"'Year 1'!E1","v":"FY 2021"}]
[]
["Project Budget",null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5",null,"Total"]
[]
["Personnel"]
[{"$f":"'Year 5'!A19","v":0},{"$f":"'Year 5'!B19","v":0},{"$f":"'Year 5'!C19","v":0},null,null,null,null,{"$f":"'Year 1'!J19","v":0},{"$f":"'Year 2'!J19","v":0},{"$f":"'Year 3'!J19","v":0},{"$f":"'Year 4'!J19","v":0},{"$f":"'Year 5'!J19","v":0},null,{"$f":"SUM(H8:M8)","v":0}]
[{"$f":"'Year 5'!A20","v":0},{"$f":"'Year 5'!B20","v":0},{"$f":"'Year 5'!C20","v":0},null,null,null,null,{"$f":"'Year 1'!J20","v":0},{"$f":"'Year 2'!J20","v":0},{"$f":"'Year 3'!J20","v":0},{"$f":"'Year 4'!J20","v":0},{"$f":"'Year 5'!J20","v":0},null,0]
[{"$f":"'Year 5'!A21","v":0},{"$f":"'Year 5'!B21","v":0},{"$f":"'Year 5'!C21","v":0},null,null,null,null,{"$f":"'Year 1'!J21","v":0},{"$f":"'Year 2'!J21","v":0},{"$f":"'Year 3'!J21","v":0},{"$f":"'Year 4'!J21","v":0},{"$f":"'Year 5'!J21","v":0},null,0]
[{"$f":"'Year 5'!A22","v":0},{"$f":"'Year 5'!B22","v":0},{"$f":"'Year 5'!C22","v":0},null,null,null,null,{"$f":"'Year 1'!J22","v":0},{"$f":"'Year 2'!J22","v":0},{"$f":"'Year 3'!J22","v":0},{"$f":"'Year 4'!J22","v":0},{"$f":"'Year 5'!J22","v":0},null,0]
[{"$f":"'Year 5'!A23","v":0},{"$f":"'Year 5'!B23","v":0},{"$f":"'Year 5'!C23","v":0},null,null,null,null,{"$f":"'Year 1'!J23","v":0},{"$f":"'Year 2'!J23","v":0},{"$f":"'Year 3'!J23","v":0},{"$f":"'Year 4'!J23","v":0},{"$f":"'Year 5'!J23","v":0},null,0]
[{"$f":"'Year 5'!A24","v":0},{"$f":"'Year 5'!B24","v":0},{"$f":"'Year 5'!C24","v":0},null,null,null,null,{"$f":"'Year 1'!J24","v":0},{"$f":"'Year 2'!J24","v":0},{"$f":"'Year 3'!J24","v":0},{"$f":"'Year 4'!J24","v":0},{"$f":"'Year 5'!J24","v":0},null,0]
[{"$f":"'Year 5'!A25","v":0},{"$f":"'Year 5'!B25","v":0},{"$f":"'Year 5'!C25","v":0},null,null,null,null,{"$f":"'Year 1'!J25","v":0},{"$f":"'Year 2'!J25","v":0},{"$f":"'Year 3'!J25","v":0},{"$f":"'Year 4'!J25","v":0},{"$f":"'Year 5'!J25","v":0},null,0]
[{"$f":"'Year 5'!A26","v":0},{"$f":"'Year 5'!B26","v":0},{"$f":"'Year 5'!C26","v":0},null,null,null,null,0,{"$f":"'Year 2'!J26","v":0},{"$f":"'Year 3'!J26","v":0},{"$f":"'Year 4'!J26","v":0},{"$f":"'Year 5'!J26","v":0},null,0]
[{"$f":"'Year 5'!A27","v":0},{"$f":"'Year 5'!B27","v":0},{"$f":"'Year 5'!C27","v":0},null,null,null,null,0,{"$f":"'Year 2'!J27","v":0},{"$f":"'Year 3'!J27","v":0},{"$f":"'Year 4'!J27","v":0},{"$f":"'Year 5'!J27","v":0},null,0]
[{"$f":"'Year 5'!A28","v":0},{"$f":"'Year 5'!B28","v":0},{"$f":"'Year 5'!C28","v":0},null,null,null,null,0,{"$f":"'Year 2'!J28","v":0},{"$f":"'Year 3'!J28","v":0},{"$f":"'Year 4'!J28","v":0},{"$f":"'Year 5'!J28","v":0},null,{"$f":"SUM(H17:M17)","v":0}]
[{"$f":"'Year 5'!A29","v":0},{"$f":"'Year 5'!B29","v":0},{"$f":"'Year 5'!C29","v":0},null,null,null,null,0,{"$f":"'Year 2'!J29","v":0},{"$f":"'Year 3'!J29","v":0},{"$f":"'Year 4'!J29","v":0},{"$f":"'Year 5'!J29","v":0},null,0]
[{"$f":"'Year 5'!A30","v":0},{"$f":"'Year 5'!B30","v":0},{"$f":"'Year 5'!C30","v":0},null,null,null,null,0,0,{"$f":"'Year 3'!J30","v":0},{"$f":"'Year 4'!J30","v":0},{"$f":"'Year 5'!J30","v":0},null,0]
[{"$f":"'Year 5'!A31","v":0},{"$f":"'Year 5'!B31","v":0},{"$f":"'Year 5'!C31","v":0},null,null,null,null,0,0,{"$f":"'Year 3'!J31","v":0},{"$f":"'Year 4'!J31","v":0},{"$f":"'Year 5'!J31","v":0},null,{"$f":"SUM(H20:M20)","v":0}]
[{"$f":"'Year 5'!A32","v":0},{"$f":"'Year 5'!B32","v":0},{"$f":"'Year 5'!C32","v":0},null,null,null,null,0,0,{"$f":"'Year 3'!J32","v":0},{"$f":"'Year 4'!J32","v":0},{"$f":"'Year 5'!J32","v":0},null,0]
[{"$f":"'Year 5'!A33","v":0},{"$f":"'Year 5'!B33","v":0},{"$f":"'Year 5'!C33","v":0},null,null,null,null,0,0,0,{"$f":"'Year 4'!J33","v":0},{"$f":"'Year 5'!J33","v":0},null,0]
[{"$f":"'Year 5'!A34","v":0},{"$f":"'Year 5'!B34","v":0},{"$f":"'Year 5'!C34","v":0},null,null,null,null,0,0,0,0,{"$f":"'Year 5'!J34","v":0},null,0]
[]
["Subtotal of Personnel",null,null,null,null,null,null,{"$f":"SUM(H8:H24)","v":0},{"$f":"SUM(I8:I24)","v":0},0,0,0,0,0]
[]
["Fringe Benefits"]
[{"$f":"'Year 5'!A44","v":0},{"$f":"'Year 5'!B44","v":0},{"$f":"'Year 5'!C44","v":0},null,null,null,null,{"$f":"'Year 1'!J35","v":0},{"$f":"'Year 2'!J39","v":0},{"$f":"'Year 3'!J42","v":0},{"$f":"'Year 4'!J43","v":0},{"$f":"'Year 5'!J44","v":0},null,{"$f":"SUM(H28:M28)","v":0}]
[{"$f":"'Year 5'!A45","v":0},{"$f":"'Year 5'!B45","v":0},{"$f":"'Year 5'!C45","v":0},null,null,null,null,{"$f":"'Year 1'!J36","v":0},{"$f":"'Year 2'!J40","v":0},{"$f":"'Year 3'!J43","v":0},{"$f":"'Year 4'!J44","v":0},{"$f":"'Year 5'!J45","v":0},null,0]
[{"$f":"'Year 5'!A46","v":0},{"$f":"'Year 5'!B46","v":0},{"$f":"'Year 5'!C46","v":0},null,null,null,null,{"$f":"'Year 1'!J37","v":0},{"$f":"'Year 2'!J41","v":0},{"$f":"'Year 3'!J44","v":0},{"$f":"'Year 4'!J45","v":0},{"$f":"'Year 5'!J46","v":0},null,0]
[{"$f":"'Year 5'!A47","v":0},{"$f":"'Year 5'!B47","v":0},{"$f":"'Year 5'!C47","v":0},null,null,null,null,{"$f":"'Year 1'!J38","v":0},{"$f":"'Year 2'!J42","v":0},{"$f":"'Year 3'!J45","v":0},{"$f":"'Year 4'!J46","v":0},{"$f":"'Year 5'!J47","v":0},null,0]
[{"$f":"'Year 5'!A48","v":0},{"$f":"'Year 5'!B48","v":0},{"$f":"'Year 5'!C48","v":0},null,null,null,null,{"$f":"'Year 1'!J39","v":0},{"$f":"'Year 2'!J43","v":0},{"$f":"'Year 3'!J46","v":0},{"$f":"'Year 4'!J47","v":0},{"$f":"'Year 5'!J48","v":0},null,0]
[{"$f":"'Year 5'!A49","v":0},{"$f":"'Year 5'!B49","v":0},{"$f":"'Year 5'!C49","v":0},null,null,null,null,{"$f":"'Year 1'!J40","v":0},{"$f":"'Year 2'!J44","v":0},{"$f":"'Year 3'!J47","v":0},{"$f":"'Year 4'!J48","v":0},{"$f":"'Year 5'!J49","v":0},null,0]
[{"$f":"'Year 5'!A50","v":0},{"$f":"'Year 5'!B50","v":0},{"$f":"'Year 5'!C50","v":0},null,null,null,null,{"$f":"'Year 1'!J41","v":0},{"$f":"'Year 2'!J45","v":0},{"$f":"'Year 3'!J48","v":0},{"$f":"'Year 4'!J49","v":0},{"$f":"'Year 5'!J50","v":0},null,0]
[{"$f":"'Year 5'!A51","v":0},{"$f":"'Year 5'!B51","v":0},{"$f":"'Year 5'!C51","v":0},null,null,null,null,0,{"$f":"'Year 2'!J46","v":0},{"$f":"'Year 3'!J49","v":0},{"$f":"'Year 4'!J50","v":0},{"$f":"'Year 5'!J51","v":0},null,0]
[{"$f":"'Year 5'!A52","v":0},{"$f":"'Year 5'!B52","v":0},{"$f":"'Year 5'!C52","v":0},null,null,null,null,0,{"$f":"'Year 2'!J47","v":0},{"$f":"'Year 3'!J50","v":0},{"$f":"'Year 4'!J51","v":0},{"$f":"'Year 5'!J52","v":0},null,0]
[{"$f":"'Year 5'!A53","v":0},{"$f":"'Year 5'!B53","v":0},{"$f":"'Year 5'!C53","v":0},null,null,null,null,0,{"$f":"'Year 2'!J48","v":0},{"$f":"'Year 3'!J51","v":0},{"$f":"'Year 4'!J52","v":0},{"$f":"'Year 5'!J53","v":0},null,{"$f":"SUM(H37:M37)","v":0}]
[{"$f":"'Year 5'!A54","v":0},{"$f":"'Year 5'!B54","v":0},{"$f":"'Year 5'!C54","v":0},null,null,null,null,0,{"$f":"'Year 2'!J49","v":0},{"$f":"'Year 3'!J52","v":0},{"$f":"'Year 4'!J53","v":0},{"$f":"'Year 5'!J54","v":0},null,0]
[{"$f":"'Year 5'!A55","v":0},{"$f":"'Year 5'!B55","v":0},{"$f":"'Year 5'!C55","v":0},null,null,null,null,0,0,{"$f":"'Year 3'!J53","v":0},{"$f":"'Year 4'!J54","v":0},{"$f":"'Year 5'!J55","v":0},null,0]
[{"$f":"'Year 5'!A56","v":0},{"$f":"'Year 5'!B56","v":0},{"$f":"'Year 5'!C56","v":0},null,null,null,null,0,0,{"$f":"'Year 3'!J54","v":0},{"$f":"'Year 4'!J55","v":0},{"$f":"'Year 5'!J56","v":0},null,{"$f":"SUM(H40:M40)","v":0}]
[{"$f":"'Year 5'!A57","v":0},{"$f":"'Year 5'!B57","v":0},{"$f":"'Year 5'!C57","v":0},null,null,null,null,0,0,{"$f":"'Year 3'!J55","v":0},{"$f":"'Year 4'!J56","v":0},{"$f":"'Year 5'!J57","v":0},null,0]
[{"$f":"'Year 5'!A58","v":0},{"$f":"'Year 5'!B58","v":0},{"$f":"'Year 5'!C58","v":0},null,null,null,null,0,0,0,{"$f":"'Year 4'!J57","v":0},{"$f":"'Year 5'!J58","v":0},null,0]
[{"$f":"'Year 5'!A59","v":0},{"$f":"'Year 5'!B59","v":0},{"$f":"'Year 5'!C59","v":0},null,null,null,null,0,0,0,0,{"$f":"'Year 5'!J59","v":0},null,0]
[]
["Subtotal of Fringe Benefits for Personnel",null,null,null,null,null,null,{"$f":"SUM(H28:H44)","v":0},{"$f":"SUM(I28:I44)","v":0},0,0,0,0,0]
[]
["Subtotal of Personnel and FB",null,null,null,null,null,null,{"$f":"H45+H25","v":0},0,0,0,0,0,0]
[]
["Students"]
[{"$f":"'Year 5'!A71","v":0},{"$f":"'Year 5'!B71","v":0},{"$f":"'Year 5'!C71","v":0},null,null,null,null,{"$f":"'Year 1'!J53","v":0},{"$f":"'Year 2'!J61","v":0},{"$f":"'Year 3'!J67","v":0},{"$f":"'Year 4'!J69","v":0},{"$f":"'Year 5'!J71","v":0},null,{"$f":"SUM(H50:M50)","v":0}]
[{"$f":"'Year 5'!A72","v":0},{"$f":"'Year 5'!B72","v":0},{"$f":"'Year 5'!C72","v":0},null,null,null,null,{"$f":"'Year 1'!J54","v":0},{"$f":"'Year 2'!J62","v":0},{"$f":"'Year 3'!J68","v":0},{"$f":"'Year 4'!J70","v":0},{"$f":"'Year 5'!J72","v":0},null,{"$f":"SUM(H51:M51)","v":0}]
[{"$f":"'Year 5'!A73","v":0},{"$f":"'Year 5'!B73","v":0},{"$f":"'Year 5'!C73","v":0},null,null,null,null,{"$f":"'Year 1'!J55","v":0},{"$f":"'Year 2'!J63","v":0},{"$f":"'Year 3'!J69","v":0},{"$f":"'Year 4'!J71","v":0},{"$f":"'Year 5'!J73","v":0},null,{"$f":"SUM(H52:M52)","v":0}]
[{"$f":"'Year 5'!A74","v":0},{"$f":"'Year 5'!B74","v":0},{"$f":"'Year 5'!C74","v":0},null,null,null,null,{"$f":"'Year 1'!J56","v":0},{"$f":"'Year 2'!J64","v":0},{"$f":"'Year 3'!J70","v":0},{"$f":"'Year 4'!J72","v":0},{"$f":"'Year 5'!J74","v":0},null,0]
[{"$f":"'Year 5'!A75","v":0},{"$f":"'Year 5'!B75","v":0},{"$f":"'Year 5'!C75","v":0},null,null,null,null,0,{"$f":"'Year 2'!J65","v":0},{"$f":"'Year 3'!J71","v":0},{"$f":"'Year 4'!J73","v":0},{"$f":"'Year 5'!J75","v":0},null,{"$f":"SUM(H54:M54)","v":0}]
[{"$f":"'Year 5'!A76","v":0},{"$f":"'Year 5'!B76","v":0},{"$f":"'Year 5'!C76","v":0},null,null,null,null,0,{"$f":"'Year 2'!J66","v":0},{"$f":"'Year 3'!J72","v":0},{"$f":"'Year 4'!J74","v":0},{"$f":"'Year 5'!J76","v":0},null,0]
[{"$f":"'Year 5'!A77","v":0},{"$f":"'Year 5'!B77","v":0},{"$f":"'Year 5'!C77","v":0},null,null,null,null,0,0,{"$f":"'Year 3'!J73","v":0},{"$f":"'Year 4'!J75","v":0},{"$f":"'Year 5'!J77","v":0},null,0]
[{"$f":"'Year 5'!A78","v":0},{"$f":"'Year 5'!B78","v":0},{"$f":"'Year 5'!C78","v":0},null,null,null,null,0,0,0,{"$f":"'Year 4'!J76","v":0},{"$f":"'Year 5'!J78","v":0},null,0]
[{"$f":"'Year 5'!A79","v":0},{"$f":"'Year 5'!B79","v":0},{"$f":"'Year 5'!C79","v":0},null,null,null,null,0,0,0,0,{"$f":"'Year 5'!J79","v":0},null,0]
[]
["Subtotal of Students",null,null,null,null,null,null,{"$f":"SUM(H50:H59)","v":0},0,0,0,0,0,0]
[]
["Fringe Benefits for Students"]
[{"$f":"'Year 5'!A89","v":0},{"$f":"'Year 5'!B89","v":0},{"$f":"'Year 5'!C89","v":0},null,null,null,null,{"$f":"'Year 1'!J66","v":0},{"$f":"'Year 2'!J76","v":0},{"$f":"'Year 3'!J83","v":0},{"$f":"'Year 4'!J86","v":0},{"$f":"'Year 5'!J89","v":0},null,{"$f":"SUM(H63:M63)","v":0}]
[{"$f":"'Year 5'!A90","v":0},{"$f":"'Year 5'!B90","v":0},{"$f":"'Year 5'!C90","v":0},null,null,null,null,{"$f":"'Year 1'!J67","v":0},{"$f":"'Year 2'!J77","v":0},{"$f":"'Year 3'!J84","v":0},{"$f":"'Year 4'!J87","v":0},{"$f":"'Year 5'!J90","v":0},null,{"$f":"SUM(H64:M64)","v":0}]
[{"$f":"'Year 5'!A91","v":0},{"$f":"'Year 5'!B91","v":0},{"$f":"'Year 5'!C91","v":0},null,null,null,null,{"$f":"'Year 1'!J68","v":0},{"$f":"'Year 2'!J78","v":0},{"$f":"'Year 3'!J85","v":0},{"$f":"'Year 4'!J88","v":0},{"$f":"'Year 5'!J91","v":0},null,{"$f":"SUM(H65:M65)","v":0}]
[{"$f":"'Year 5'!A92","v":0},{"$f":"'Year 5'!B92","v":0},{"$f":"'Year 5'!C92","v":0},null,null,null,null,{"$f":"'Year 1'!J69","v":0},{"$f":"'Year 2'!J79","v":0},{"$f":"'Year 3'!J86","v":0},{"$f":"'Year 4'!J89","v":0},{"$f":"'Year 5'!J92","v":0},null,0]
[{"$f":"'Year 5'!A93","v":0},{"$f":"'Year 5'!B93","v":0},{"$f":"'Year 5'!C93","v":0},null,null,null,null,0,{"$f":"'Year 2'!J80","v":0},{"$f":"'Year 3'!J87","v":0},{"$f":"'Year 4'!J90","v":0},{"$f":"'Year 5'!J93","v":0},null,{"$f":"SUM(H67:M67)","v":0}]
[{"$f":"'Year 5'!A94","v":0},{"$f":"'Year 5'!B94","v":0},{"$f":"'Year 5'!C94","v":0},null,null,null,null,0,{"$f":"'Year 2'!J81","v":0},{"$f":"'Year 3'!J88","v":0},{"$f":"'Year 4'!J91","v":0},{"$f":"'Year 5'!J94","v":0},null,0]
[{"$f":"'Year 5'!A95","v":0},{"$f":"'Year 5'!B95","v":0},{"$f":"'Year 5'!C95","v":0},null,null,null,null,0,0,{"$f":"'Year 3'!J89","v":0},{"$f":"'Year 4'!J92","v":0},{"$f":"'Year 5'!J95","v":0},null,0]
[{"$f":"'Year 5'!A96","v":0},{"$f":"'Year 5'!B96","v":0},{"$f":"'Year 5'!C96","v":0},null,null,null,null,0,0,0,{"$f":"'Year 4'!J93","v":0},{"$f":"'Year 5'!J96","v":0},null,0]
[{"$f":"'Year 5'!A97","v":0},{"$f":"'Year 5'!B97","v":0},{"$f":"'Year 5'!C97","v":0},null,null,null,null,0,0,0,0,{"$f":"'Year 5'!J97","v":0},null,0]
[]
["Subtotal of Fringe Benefits for Students",null,null,null,null,null,null,{"$f":"SUM(H63:H72)","v":0},0,0,0,0,0,0]
[]
["Subtotal of Students and FBS",null,null,null,null,null,null,{"$f":"H73+H60","v":0},0,0,0,0,0,{"$f":"SUM(H75:M75)","v":0}]
[]
["Subtotal of Salary",null,null,null,null,null,null,{"$f":"H25+H60","v":0},{"$f":"I25+I60","v":0},{"$f":"J25+J60","v":0},{"$f":"K25+K60","v":0},{"$f":"L25+L60","v":0},null,{"$f":"SUM(H77:M77)","v":0}]
["Subtotal of Fringe Benefits",null,null,null,null,null,null,{"$f":"H45+H73","v":0},{"$f":"I45+I73","v":0},{"$f":"J45+J73","v":0},{"$f":"K45+K73","v":0},{"$f":"L45+L73","v":0},null,{"$f":"SUM(H78:M78)","v":0}]
[]
["Subtotal of Personnel and Students",null,null,null,null,null,null,{"$f":"H75+H47","v":0},{"$f":"I75+I47","v":0},{"$f":"J75+J47","v":0},{"$f":"K75+K47","v":0},{"$f":"L75+L47","v":0},{"$f":"M75+M62","v":0},{"$f":"SUM(H80:M80)","v":0}]
["Travel",null,null,null,null,null,null,{"$f":"'Year 1'!J83","v":0},{"$f":"'Year 2'!J95","v":0},{"$f":"'Year 3'!J103","v":0},{"$f":"'Year 4'!J107","v":0},{"$f":"'Year 5'!J111","v":0},null,{"$f":"SUM(H81:M81)","v":0}]
["Capital Expenditures/Equipment D",null,null,null,null,null,null,{"$f":"'Year 1'!J88","v":0},{"$f":"'Year 2'!J100","v":0},{"$f":"'Year 3'!J108","v":0},{"$f":"'Year 4'!J112","v":0},{"$f":"'Year 5'!J116","v":0},null,0]
["Supplies",null,null,null,null,null,null,{"$f":"'Year 1'!J93","v":0},{"$f":"'Year 2'!J105","v":0},{"$f":"'Year 3'!J113","v":0},{"$f":"'Year 4'!J117","v":0},{"$f":"'Year 5'!J121","v":0},null,0]
["Publication/Printing Charges",null,null,null,null,null,null,{"$f":"'Year 1'!J98","v":0},{"$f":"'Year 2'!J110","v":0},{"$f":"'Year 3'!J118","v":0},{"$f":"'Year 4'!J122","v":0},{"$f":"'Year 5'!J126","v":0},null,0]
[]
["Sub-Contracts DÑ"]
[{"$f":"'Year 5'!A129:B129","v":0},{"$f":"'Year 5'!B129:C129","v":0},null,null,null,null,null,{"$f":"'Year 5'!O129","v":0},{"$f":"'Year 5'!P129","v":0},{"$f":"'Year 5'!Q129","v":0},{"$f":"'Year 5'!R129","v":0},{"$f":"'Year 5'!S129","v":0},null,0]
[{"$f":"'Year 5'!A130:B130","v":0},{"$f":"'Year 5'!B130:C130","v":0},null,null,null,null,null,{"$f":"'Year 5'!O130","v":0},{"$f":"'Year 5'!P130","v":0},{"$f":"'Year 5'!Q130","v":0},{"$f":"'Year 5'!R130","v":0},{"$f":"'Year 5'!S130","v":0},null,0]
[{"$f":"'Year 5'!A131:B131","v":0},{"$f":"'Year 5'!B131:C131","v":0},null,null,null,null,null,{"$f":"'Year 5'!O131","v":0},{"$f":"'Year 5'!P131","v":0},{"$f":"'Year 5'!Q131","v":0},{"$f":"'Year 5'!R131","v":0},{"$f":"'Year 5'!S131","v":0},null,0]
[{"$f":"'Year 5'!A132:B132","v":0},{"$f":"'Year 5'!B132:C132","v":0},null,null,null,null,null,{"$f":"'Year 5'!O132","v":0},{"$f":"'Year 5'!P132","v":0},{"$f":"'Year 5'!Q132","v":0},{"$f":"'Year 5'!R132","v":0},{"$f":"'Year 5'!S132","v":0},null,0]
[{"$f":"'Year 5'!A133:B133","v":0},{"$f":"'Year 5'!B133:C133","v":0},null,null,null,null,null,{"$f":"'Year 5'!O133","v":0},{"$f":"'Year 5'!P133","v":0},{"$f":"'Year 5'!Q133","v":0},{"$f":"'Year 5'!R133","v":0},{"$f":"'Year 5'!S133","v":0},null,0]
[{"$f":"'Year 5'!A134:B134","v":0},{"$f":"'Year 5'!B134:C134","v":0},null,null,null,null,null,{"$f":"'Year 5'!O134","v":0},{"$f":"'Year 5'!P134","v":0},{"$f":"'Year 5'!Q134","v":0},{"$f":"'Year 5'!R134","v":0},{"$f":"'Year 5'!S134","v":0},null,0]
[]
["Subtotal of Sub-Contracts",null,null,null,null,null,null,{"$f":"SUM(H87:H93)","v":0},{"$f":"SUM(I87:I93)","v":0},{"$f":"SUM(J87:J93)","v":0},{"$f":"SUM(K87:K93)","v":0},{"$f":"SUM(L87:L93)","v":0},null,{"$f":"SUM(N87:N93)","v":0}]
[]
["Participant Support Costs D",null,null,null,null,null,null,{"$f":"'Year 1'!J114","v":0},{"$f":"'Year 2'!J127","v":0},{"$f":"'Year 3'!J136","v":0},{"$f":"'Year 4'!J141","v":0},{"$f":"'Year 5'!J146","v":0},null,0]
["Other-Graduate Student Tuition (IDC is not assessed on tuition)",null,null,null,null,null,null,{"$f":"'Year 1'!J124","v":0},{"$f":"'Year 2'!J140","v":0},{"$f":"'Year 3'!J147","v":0},{"$f":"'Year 4'!J152","v":0},{"$f":"'Year 5'!J157","v":0},null,{"$f":"SUM(H97:M97)","v":0}]
["Other-All Other Costs except Graduate Tuition DÑ",null,null,null,null,null,null,{"$f":"'Year 1'!J133","v":0},{"$f":"'Year 2'!J149","v":0},{"$f":"'Year 3'!J156","v":0},{"$f":"'Year 4'!J161","v":0},{"$f":"'Year 5'!J166","v":0},null,0]
["Subtotal of all non-personnel items ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N81:N84) + SUM(N94:N98)","v":0}]
["Total Direct Costs",null,null,null,null,null,null,{"$f":"SUM(H80:H84,H94,H96:H98)","v":0},{"$f":"SUM(I80:I84,I94,I96:I98)","v":0},0,0,0,{"$f":"SUM(M47:M98)","v":0},0]
[]
["Modified Total Direct Costs (Base for F&A)",null,null,null,null,null,null,{"$f":"'Year 1'!J135","v":0},{"$f":"'Year 2'!J151","v":0},{"$f":"'Year 3'!J158","v":0},{"$f":"'Year 4'!J163","v":0},{"$f":"'Year 5'!J168","v":0},null,{"$f":"SUM(H102:M102)","v":0}]
["Indirect Costs",null,null,null,null,null,null,{"$f":"'Year 1'!J142","v":0},{"$f":"'Year 2'!J152","v":0},{"$f":"'Year 3'!J159","v":0},{"$f":"'Year 4'!J164","v":0},{"$f":"'Year 5'!J169","v":0},null,0]
[]
["Total Direct Costs (Sponsor Direct)",null,null,null,null,null,null,{"$f":"'Year 1'!J143","v":0},{"$f":"'Year 2'!J153","v":0},{"$f":"'Year 3'!J160","v":0},{"$f":"'Year 4'!J165","v":0},{"$f":"'Year 5'!J170","v":0},null,{"$f":"SUM(H105:M105)","v":0}]
["Indirect Costs",null,null,null,null,null,null,{"$f":"'Year 1'!J142","v":0},{"$f":"'Year 2'!J152","v":0},{"$f":"'Year 3'!J159","v":0},{"$f":"'Year 4'!J164","v":0},{"$f":"'Year 5'!J169","v":0},null,{"$f":"SUM(H106:M106)","v":0}]
["Requested Amount",null,null,null,null,null,null,{"$f":"SUM(H105:H106)","v":0},{"$f":"SUM(I105:I106)","v":0},{"$f":"SUM(J105:J106)","v":0},{"$f":"SUM(K105:K106)","v":0},{"$f":"SUM(L105:L106)","v":0},null,{"$f":"SUM(N105:N106)","v":0}]
[]
["Requested Amount",null,null,null,null,null,null,{"$f":"'Year 1'!J144","v":0},{"$f":"'Year 2'!J154","v":0},{"$f":"'Year 3'!J161","v":0},{"$f":"'Year 4'!J166","v":0},{"$f":"'Year 5'!J171","v":0},null,{"$f":"SUM(H109:M109)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"'Year 1'!H3:J3","v":0}]
[{"$f":"'Year 1'!A3:B3","v":"Budget Prepared by:"},null,{"$f":"'Year 1'!C3:D3","v":0}]
["Phone Number:",null,{"$f":"'Year 1'!F3","v":0}]
["E-mail:",null,{"$f":"H111","v":0}]
[]
[]
["University of North Texas, Grants & Contracts Administration"]