{"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":2,"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 (%)",{"$f":"21.7-1","v":20.7},{"$f":"B8","v":20.7}]
["Students"]
["Graduate (%)",6.85,6.85]
["Undergraduate (%)",6.85,6.85]
["Others"]
["Hourly (%)",14.5,14.5]
["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.82,491.41]
["Children ($)",864.52,432.26]
["Family ($)",1222.52,611.26]
["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: FY20"]
[]
["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 FY20 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, Office of Grants & Contracts Administration"]

{"sheet":"Year 1","index":2,"n_rows":149,"n_cols":26,"rows_kept":149,"cut":false,"hidden":false,"merged":[[144,0,144,1],[143,0,143,1],[142,0,142,1],[133,2,133,5],[140,0,140,1],[139,0,139,1],[128,2,128,5],[137,0,137,1],[128,0,128,1],[131,0,131,1],[132,0,132,1],[84,2,84,5],[85,2,85,5],[91,0,91,1],[141,0,141,1],[118,0,118,1],[114,0,114,1],[107,0,107,1],[125,0,125,1],[130,0,130,1],[118,2,118,5],[133,0,133,1],[134,0,134,1],[124,0,124,1],[114,2,114,5],[93,2,93,5],[115,0,115,1],[103,0,103,1],[104,0,104,1],[102,0,102,1],[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],[98,0,98,1],[88,1,88,9],[95,6,95,7],[96,3,96,9],[90,2,90,5],[94,2,94,5],[98,2,98,5],[89,0,89,1],[94,0,94,1],[96,0,96,2],[89,2,89,5],[90,0,90,1],[91,2,91,5],[92,0,92,1],[92,2,92,5],[93,0,93,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],[99,2,99,5],[107,2,107,5],[105,5,105,7],[99,0,99,1],[101,2,101,9],[100,5,100,7],[87,6,87,7],[97,2,97,5],[97,0,97,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],[130,10,132,11],[146,4,146,7],[144,3,144,5],[103,2,103,7],[102,2,102,5],[100,10,102,11],[134,2,134,5],[115,2,115,5],[104,2,104,7],[145,5,145,7],[137,5,137,7],[137,3,137,4],[124,2,124,5],[125,2,125,5],[144,6,144,7]]}
["File Number:","20-0611","BB version:",null,"FY 2020","This Budget is prepared for:",null,null,"Gates Foundation","Year 1"]
["Project Title:","Genome-wide Knockdown Screens of Oocyte Maturation"]
["Budget Prepared by:",null,"Pudur Jagadeeswaran",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"]
["Jagadeeswaran","Pudur",10523515,"Faculty","PI",18926,95,0,3,{"$f":"F19*((G19*H19)/100+(G19*I19)/100)","v":53939.1},{"$f":"ROUNDUP(H19+I19,0)","v":3},null,{"$f":"J19","v":53939.1},null,null,null,null,{"$f":"J35","v":11682.9252}]
["Iyer","Neha",0,"Staff","Post Doc",4110,100,9,3,49320,12,null,49320,null,null,null,null,{"$f":"J35","v":11682.9252}]
["Raman","Revathi",0,"Staff","Post Doc",4110,100,9,3,49320,12,null,49320,null,null,null,null,{"$f":"J36","v":14969.82}]
["Sun","Kelsey",0,"Staff","Research Technician",3250,100,9,3,39000,12,null,39000,null,null,null,null,{"$f":"J37","v":14969.82}]
[0,0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,null,{"$f":"J38","v":13406.34}]
[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":191579.1}]
["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":"Jagadeeswaran"},"Pudur",10523515,"ORP","Family","Yes",{"$f":"$J$4","v":"2007-09-01"},{"$f":"IF(G35>Fringe1End,R35,N35)","v":15.2},null,{"$f":"(J19*H35/100)+X35","v":11682.9252},{"$f":"IF(D35=$D$32,F1.Hourly,0)","v":0},{"$f":"IF(D35=$D$33,F1.FS.ORP,0)","v":21.47},{"$f":"IF(D35=$D$34,F1.FS.TRS,0)","v":0},{"$f":"SUM(K35:M35)","v":21.47},{"$f":"IF(D35=$D$32,F2.Hourly,0)","v":0},{"$f":"IF(D35=$D$33,F2.FS.ORP,0)","v":15.2},{"$f":"IF(D35=$D$34,F2.FS.TRS,0)","v":0},{"$f":"SUM(O35:Q35)","v":15.2},{"$f":"IF(F35=$F$33,G19,100)","v":95},{"$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":3484.1820000000002},{"$f":"IF(D19=$D$18,ROUNDDOWN(DAYS360(G35,$J$4)/(360*Long.Per),0)*20*K19*G19/100,0)+SUM(T35:W35)","v":3484.1820000000002},null,{"$f":"J35/J19","v":0.21659473739828808}]
["Iyer","Neha",0,{"$f":"IF($D20=$D$16,$D$32,$D$34)","v":"TRS"},{"$f":"IF($D20=$D$16,$E$30,$E$31)","v":"Employee"},"Yes","2007-09-01",15.15,null,14969.82,0,0,20.7,20.7,0,0,15.15,15.15,100,7497.84,0,0,0,7497.84,null,{"$f":"J36/J20","v":0.30352433090024328}]
[{"$f":"A21","v":"Raman"},"Revathi",0,"TRS","Employee","Yes","2007-09-01",15.15,null,14969.82,0,0,20.7,20.7,0,0,15.15,15.15,100,7497.84,0,0,0,7497.84,null,0.30352433090024328]
["Sun","Kelsey",0,"TRS","Employee","Yes","2007-09-01",15.15,null,13406.34,0,0,20.7,20.7,0,0,15.15,15.15,100,7497.84,0,0,0,7497.84,null,0.34375230769230769]
[0,0,0,"TRS","Employee","Yes","2007-09-01",15.15,null,0,0,0,20.7,20.7,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,20.7,20.7,0,0,15.15,15.15,0,0,0,0,0,0]
[0,0,0,"TRS","Employee","No","2007-09-01",15.15,null,0,0,0,20.7,20.7,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(J35:J41)","v":55028.905199999994},"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":246608.00520000001}]
["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":6.85},{"$f":"IF(D53=$D$52,F1.Under,0)","v":0},{"$f":"SUM(K66:L66)","v":6.85},{"$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":6.85},{"$f":"IF(D54=$D$52,F1.Under,0)","v":0},{"$f":"SUM(K67:L67)","v":6.85},{"$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":6.85},{"$f":"IF(D55=$D$52,F1.Under,0)","v":0},{"$f":"SUM(K68:L68)","v":6.85},{"$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":6.85},{"$f":"IF(D56=$D$52,F1.Under,0)","v":0},{"$f":"SUM(K69:L69)","v":6.85},{"$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":191579.1}]
[null,null,null,null,null,"Sum of Fringe Benefits",null,null,null,{"$f":"J42+J70","v":55028.905199999994}]
[null,null,null,null,null,"Sum of Personnel and Students",null,null,null,{"$f":"SUM(J72:J73)","v":246608.00520000001}]
["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"]
["Travel","Attending national meeting one per year for PI and postdocs",null,null,null,"Domestic",null,null,null,3000]
[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":3000}]
["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"]
[" reagents",null,null,null,null,null,40,1250,null,{"$f":"G91*H91","v":50000}]
["reagents",null,null,null,null,null,15,750,null,11250]
["Fish",null,null,null,null,null,0.5,12000,null,6000]
["Needles, syringes, gloves, etc.",null,null,null,null,null,1000,2,null,2000]
[null,null,null,null,null,null,0,0,null,0]
[null,null,null,null,null,null,"Sum of Supplies",null,null,{"$f":"SUM(J91:J95)","v":69250}]
["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":"G99*H99","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G100*H100","v":0}]
[null,null,null,null,null,"Sum of Publication/Printing Charges",null,null,null,{"$f":"SUM(J99:J100)","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(J104>25000,25000,J104)","v":0},1,0,{"$f":"SUM(M104,J104)","v":0},{"$f":"J104","v":0}]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J105>25000,25000,J105)","v":0},1,0,{"$f":"SUM(M105,J105)","v":0},{"$f":"J105","v":0}]
[null,null,null,null,null,"Sum of Sub-Contracts",null,null,null,{"$f":"SUM(J104:J105)","v":0},{"$f":"SUM(K104:K105)","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":"G115*H115","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G116*H116","v":0}]
[null,null,null,null,null,null,null,"Sum of Participant Support Costs",null,{"$f":"SUM(J115:J116)","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":"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 Other-Graduate Student Tuition ",null,{"$f":"SUM(J125:J126)","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":"G134*H134","v":0},{"$f":"IF(OR(A134=$A$131,A134=$A$132),0,J134)","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G135*H135","v":0},{"$f":"IF(OR(A135=$A$131,A135=$A$132),0,J135)","v":0}]
[null,null,null,null,null,null,null,"Sum of Other",null,{"$f":"SUM(J134:J135)","v":0},{"$f":"SUM(K134:K135)","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+K136+J83+J96+J101+K106)","v":318858.00520000001}]
[]
["Research",null,{"$f":"IF($A$145=A140,IDC.R,0)","v":0}]
["On-Campus Other",null,{"$f":"IF($A$145=A141,IDC.On,0)","v":0}]
["Instruction",null,{"$f":"IF($A$145=A142,IDC.I,0)","v":0},{"$f":"FALSE()","v":false}]
["Off-Campus",null,{"$f":"IF($A$145=A143,IDC.Off,0)","v":0},{"$f":"TRUE()","v":true}]
["Agency Restricted",null,{"$f":"SUM(C140:C143)","v":0},{"$f":"IF(A145=A144,\"?\",C144)","v":"?"}]
["Agency Restricted",null,10,"https://docs.gatesfoundation.org/documents/indirect_cost_policy.pdf",null,null,"IDC Amount on TDC",null,null,{"$f":"J146*C145/100","v":31885.800520000001}]
[null,null,null,null,null,"Total Direct Costs (Sponsor Direct)",null,null,null,{"$f":"SUM(J136,J117,J101,J106,J96,J88,J83,J74,J127)","v":318858.00520000001}]
[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(J145:J146)","v":350743.80572}]
[]
["University of North Texas, Office of Grants & Contracts Administration"]

{"sheet":"Year 2","index":3,"n_rows":160,"n_cols":26,"rows_kept":160,"cut":false,"hidden":false,"merged":[[142,2,142,5],[99,6,99,7],[129,2,129,5],[114,2,114,9],[108,6,108,7],[115,2,115,5],[101,2,101,5],[100,1,100,9],[113,5,113,7],[129,0,129,1],[103,0,103,1],[103,2,103,5],[104,0,104,1],[104,2,104,5],[105,0,105,1],[112,0,112,1],[112,2,112,5],[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],[111,2,111,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],[105,2,105,5],[106,0,106,1],[106,2,106,5],[107,0,107,1],[107,2,107,5],[109,3,109,9],[109,0,109,2],[110,0,110,1],[110,2,110,5],[111,0,111,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],[147,10,149,11],[148,0,148,1],[149,0,149,1],[147,0,147,1],[113,10,115,11],[117,0,117,1],[132,2,132,5],[117,2,117,7],[115,0,115,1],[121,0,121,1],[121,2,121,5],[128,0,128,1],[116,0,116,1],[116,2,116,7],[119,5,119,7],[145,2,145,5],[145,0,145,1],[132,0,132,1],[128,2,128,5],[118,2,118,7],[118,0,118,1],[141,0,141,1],[141,2,141,5],[142,0,142,1],[155,6,155,7],[157,4,157,7],[155,0,155,1],[155,3,155,5],[154,0,154,1],[156,5,156,7],[150,2,150,5],[151,2,151,5],[151,0,151,1],[154,3,154,4],[150,0,150,1],[154,5,154,7]]}
["File Number:",{"$f":"'Year 1'!B1","v":"20-0611"},"BB version:",null,{"$f":"'Year 1'!E1","v":"FY 2020"},"This Budget is prepared for:",null,null,{"$f":"'Year 1'!I1","v":"Gates Foundation"},"Year 2"]
["Project Title:",{"$f":"'Year 1'!B2:J2","v":"Genome-wide Knockdown Screens of Oocyte Maturation"}]
["Budget Prepared by:",null,{"$f":"'Year 1'!C3:D3","v":"Pudur Jagadeeswaran"},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":"Jagadeeswaran"},{"$f":"'Year 1'!B19","v":"Pudur"},{"$f":"'Year 1'!C19","v":10523515},{"$f":"'Year 1'!D19","v":"Faculty"},{"$f":"'Year 1'!E19","v":"PI"},{"$f":"'Year 1'!F19*(100+Living)/100","v":19493.78},95,0,3,{"$f":"F19*((G19*H19)/100+(G19*I19)/100)","v":55557.273000000001},{"$f":"ROUNDUP(H19+I19,0)","v":3},null,{"$f":"'Year 1'!M19","v":53939.1},{"$f":"J19","v":55557.273000000001},null,null,null,{"$f":"'Year 1'!R19","v":11682.9252},{"$f":"J39","v":11928.887496000001}]
[{"$f":"'Year 1'!A20","v":"Iyer"},{"$f":"'Year 1'!B20","v":"Neha"},{"$f":"'Year 1'!C20","v":0},{"$f":"'Year 1'!D20","v":"Staff"},{"$f":"'Year 1'!E20","v":"Post Doc"},{"$f":"'Year 1'!F20*(100+Living)/100","v":4233.3},100,9,3,{"$f":"F20*((G20*H20)/100+(G20*I20)/100)","v":50799.600000000006},12,null,{"$f":"'Year 1'!M20","v":49320},50799.600000000006,null,null,null,{"$f":"'Year 1'!R20","v":11682.9252},{"$f":"J39","v":11928.887496000001}]
[{"$f":"'Year 1'!A21","v":"Raman"},{"$f":"'Year 1'!B21","v":"Revathi"},{"$f":"'Year 1'!C21","v":0},{"$f":"'Year 1'!D21","v":"Staff"},{"$f":"'Year 1'!E21","v":"Post Doc"},{"$f":"'Year 1'!F21*(100+Living)/100","v":4233.3},100,9,3,50799.600000000006,12,null,{"$f":"'Year 1'!M21","v":49320},50799.600000000006,null,null,null,{"$f":"'Year 1'!R21","v":14969.82},{"$f":"J40","v":15193.9794}]
[{"$f":"'Year 1'!A22","v":"Sun"},{"$f":"'Year 1'!B22","v":"Kelsey"},{"$f":"'Year 1'!C22","v":0},{"$f":"'Year 1'!D22","v":"Staff"},{"$f":"'Year 1'!E22","v":"Research Technician"},{"$f":"'Year 1'!F22*(100+Living)/100","v":3347.5},100,9,3,40170,12,null,{"$f":"'Year 1'!M22","v":39000},40170,null,null,null,{"$f":"'Year 1'!R22","v":14969.82},{"$f":"J41","v":15193.9794}]
[{"$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":13406.34},{"$f":"J42","v":13583.595000000001}]
[{"$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":197326.473}]
["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":"Jagadeeswaran"},{"$f":"'Year 1'!B35","v":"Pudur"},{"$f":"'Year 1'!C35","v":10523515},{"$f":"'Year 1'!D35","v":"ORP"},{"$f":"'Year 1'!E35","v":"Family"},{"$f":"'Year 1'!F35","v":"Yes"},{"$f":"'Year 1'!G35","v":"2007-09-01"},{"$f":"IF(G39>Fringe1End,R39,N39)","v":15.2},null,{"$f":"(J19*H39/100)+X39","v":11928.887496000001},{"$f":"IF(D39=$D$36,F1.Hourly,0)","v":0},{"$f":"IF(D39=$D$37,F1.FS.ORP,0)","v":21.47},{"$f":"IF(D39=$D$38,F1.FS.TRS,0)","v":0},{"$f":"SUM(K39:M39)","v":21.47},{"$f":"IF(D39=$D$36,F2.Hourly,0)","v":0},{"$f":"IF(D39=$D$37,F2.FS.ORP,0)","v":15.2},{"$f":"IF(D39=$D$38,F2.FS.TRS,0)","v":0},{"$f":"SUM(O39:Q39)","v":15.2},{"$f":"IF(F39=$F$37,G19,100)","v":95},{"$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":3484.1820000000002},{"$f":"IF(D19=$D$18,ROUNDDOWN(DAYS360(G39,$J$4)/(360*Long.Per),0)*20*K19*G19/100,0)+SUM(T39:W39)","v":3484.1820000000002},null,{"$f":"J39/J19","v":0.21471333727989134}]
[{"$f":"'Year 1'!A36","v":"Iyer"},{"$f":"'Year 1'!B36","v":"Neha"},{"$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,15193.9794,0,0,20.7,20.7,0,0,15.15,15.15,100,7497.84,0,0,0,7497.84,null,{"$f":"J40/J20","v":0.2990964377672265}]
[{"$f":"'Year 1'!A37","v":"Raman"},{"$f":"'Year 1'!B37","v":"Revathi"},{"$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,15193.9794,0,0,20.7,20.7,0,0,15.15,15.15,100,7497.84,0,0,0,7497.84,null,0.2990964377672265]
[{"$f":"'Year 1'!A38","v":"Sun"},{"$f":"'Year 1'!B38","v":"Kelsey"},{"$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,13583.595000000001,0,0,20.7,20.7,0,0,15.15,15.15,100,7497.84,0,0,0,7497.84,null,0.33815272591486184]
[{"$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":20.7},{"$f":"SUM(K43:M43)","v":20.7},{"$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":20.7},{"$f":"SUM(K44:M44)","v":20.7},{"$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":"No"},{"$f":"'Year 1'!G41","v":"2007-09-01"},15.15,null,0,0,0,20.7,20.7,0,0,15.15,15.15,100,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":20.7},{"$f":"SUM(K46:M46)","v":20.7},{"$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":20.7},{"$f":"SUM(K47:M47)","v":20.7},{"$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":20.7},{"$f":"SUM(K48:M48)","v":20.7},{"$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,20.7,20.7,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":55900.441296000005},"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":253226.914296}]
["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":6.85},{"$f":"IF(D61=$D$60,F1.Under,0)","v":0},{"$f":"SUM(K76:L76)","v":6.85},{"$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,6.85,0,6.85,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,6.85,0,6.85,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,6.85,0,6.85,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,6.85,0,6.85,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,6.85,0,6.85,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":197326.473}]
[null,null,null,null,null,"Sum of Fringe Benefits",null,null,null,{"$f":"J50+J82","v":55900.441296000005}]
[null,null,null,null,null,"Sum of Personnel and Students",null,null,null,{"$f":"SUM(J84:J85)","v":253226.914296}]
["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"]
["Travel","Attending national meeting one per year for PI and postdocs",null,null,null,"Domestic",null,null,null,3000]
[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":3000}]
["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"]
[" reagents",null,null,null,null,null,40,1250,null,{"$f":"G103*H103","v":50000}]
[" reagents",null,null,null,null,null,15,750,null,11250]
["Fish",null,null,null,null,null,0.5,12000,null,6000]
["Needles, syringes, gloves, etc.",null,null,null,null,null,1000,2,null,2000]
[null,null,null,null,null,null,0,0,null,0]
[null,null,null,null,null,null,0,0,null,0]
[null,null,null,null,null,null,"Sum of Supplies",null,null,{"$f":"SUM(J103:J108)","v":69250}]
["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":"G112*H112","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G113*H113","v":0}]
[null,null,null,null,null,"Sum of Publication/Printing Charges",null,null,null,{"$f":"SUM(J112:J113)","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'!A104:B104","v":0},null,{"$f":"'Year 1'!C104:H104","v":0},null,null,null,null,null,null,0,{"$f":"IF(M117+J117>25000,IF(M117>=25000,0,25000-M117),J117)","v":0},1,{"$f":"'Year 1'!N104","v":0},{"$f":"SUM(M117,J117)","v":0},{"$f":"'Year 1'!O104","v":0},{"$f":"J117","v":0}]
[{"$f":"'Year 1'!A105:B105","v":0},null,{"$f":"'Year 1'!C105:H105","v":0},null,null,null,null,null,null,0,{"$f":"IF(M118+J118>25000,IF(M118>=25000,0,25000-M118),J118)","v":0},1,{"$f":"'Year 1'!N105","v":0},{"$f":"SUM(M118,J118)","v":0},{"$f":"'Year 1'!O105","v":0},{"$f":"J118","v":0}]
[0,null,null,null,null,null,null,null,null,0,{"$f":"IF(M119+J119>25000,IF(M119>=25000,0,25000-M119),J119)","v":0},2,0,{"$f":"SUM(M119,J119)","v":0},0,{"$f":"J119","v":0}]
[null,null,null,null,null,"Sum of Sub-Contracts",null,null,null,{"$f":"SUM(J117:J119)","v":0},{"$f":"SUM(K117:K119)","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":"G129*H129","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G130*H130","v":0}]
[null,null,null,null,null,null,null,"Sum of Participant Support Costs",null,{"$f":"SUM(J129:J130)","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":"G142*H142","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G143*H143","v":0}]
[null,null,null,null,null,null,null,"Sum of Other-Graduate Student Tuition ",null,{"$f":"SUM(J142:J143)","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":"G151*H151","v":0},{"$f":"IF(OR(A151=$A$148,A151=$A$149),0,J151)","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G152*H152","v":0},{"$f":"IF(OR(A152=$A$148,A152=$A$149),0,J152)","v":0}]
[null,null,null,null,null,null,null,"Sum of Other",null,{"$f":"SUM(J151:J152)","v":0},{"$f":"SUM(K151:K152)","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+J109+J114+K120+K153)","v":325476.91429600003}]
[{"$f":"'Year 1'!A145:B145","v":"Agency Restricted"},null,{"$f":"'Year 1'!C145","v":10},{"$f":"'Year 1'!D145:F145","v":"https://docs.gatesfoundation.org/documents/indirect_cost_policy.pdf"},null,null,"IDC Amount on TDC",null,null,{"$f":"J157*C156/100","v":32547.691429600003}]
[null,null,null,null,null,"Total Direct Costs (Sponsor Direct)",null,null,null,{"$f":"SUM(J120,J153,J131,J114,J109,J100,J95,J86,J144)","v":325476.91429600003}]
[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(J156:J157)","v":358024.60572560003}]
[]
["University of North Texas, Office of Grants & Contracts Administration"]

{"sheet":"Year 3","index":4,"n_rows":169,"n_cols":26,"rows_kept":169,"cut":false,"hidden":false,"merged":[[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],[123,10,125,11],[106,2,106,5],[117,2,117,5],[118,6,118,7],[107,6,107,7],[122,2,122,5],[120,2,120,5],[123,5,123,7],[113,2,113,5],[121,2,121,5],[125,2,125,5],[115,2,115,5],[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],[127,0,127,1],[127,2,127,7],[126,0,126,1],[120,0,120,1],[2,0,2,1],[2,2,2,3],[2,7,2,9],[3,0,3,4],[4,8,5,8],[3,5,3,7],[125,0,125,1],[103,4,103,9],[95,1,95,4],[110,2,110,5],[119,0,119,2],[119,3,119,9],[106,0,106,1],[105,0,105,1],[109,0,109,1],[109,2,109,5],[110,0,110,1],[117,0,117,1],[111,0,111,1],[111,2,111,5],[112,0,112,1],[112,2,112,5],[113,0,113,1],[105,2,105,5],[108,1,108,9],[156,10,158,11],[157,0,157,1],[158,0,158,1],[156,0,156,1],[128,0,128,1],[150,0,150,1],[128,2,128,7],[154,2,154,5],[139,0,139,1],[151,2,151,5],[129,0,129,1],[129,2,129,7],[139,2,139,5],[132,0,132,1],[132,2,132,5],[154,0,154,1],[130,5,130,7],[115,0,115,1],[151,0,151,1],[140,0,140,1],[114,0,114,1],[114,2,114,5],[116,0,116,1],[116,2,116,5],[166,4,166,7],[164,0,164,1],[143,0,143,1],[163,0,163,1],[159,2,159,5],[160,2,160,5],[164,6,164,7],[163,3,163,4],[163,5,163,7],[165,5,165,7],[160,0,160,1],[164,3,164,5],[150,2,150,5],[159,0,159,1],[126,2,126,7],[122,0,122,1],[124,2,124,9],[121,0,121,1],[143,2,143,5]]}
["File Number:",{"$f":"'Year 1'!B1","v":"20-0611"},"BB version:",null,{"$f":"'Year 1'!E1","v":"FY 2020"},"This Budget is prepared for:",null,null,{"$f":"'Year 1'!I1","v":"Gates Foundation"},"Year 3"]
["Project Title:",{"$f":"'Year 1'!B2:J2","v":"Genome-wide Knockdown Screens of Oocyte Maturation"}]
["Budget Prepared by:",null,{"$f":"'Year 1'!C3:D3","v":"Pudur Jagadeeswaran"},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":"Jagadeeswaran"},{"$f":"'Year 2'!B19","v":"Pudur"},{"$f":"'Year 2'!C19","v":10523515},{"$f":"'Year 2'!D19","v":"Faculty"},{"$f":"'Year 2'!E19","v":"PI"},{"$f":"'Year 2'!F19*(100+Living)/100","v":20078.593399999998},95,0,3,{"$f":"F19*((G19*H19)/100+(G19*I19)/100)","v":57223.991189999993},{"$f":"ROUNDUP(H19+I19,0)","v":3},null,{"$f":"'Year 2'!M19","v":53939.1},{"$f":"'Year 2'!N19","v":55557.273000000001},{"$f":"J19","v":57223.991189999993},null,null,{"$f":"'Year 2'!R19","v":11682.9252},{"$f":"'Year 2'!J39","v":11928.887496000001},{"$f":"J42","v":12182.228660879999}]
[{"$f":"'Year 2'!A20","v":"Iyer"},{"$f":"'Year 2'!B20","v":"Neha"},{"$f":"'Year 2'!C20","v":0},{"$f":"'Year 2'!D20","v":"Staff"},{"$f":"'Year 2'!E20","v":"Post Doc"},{"$f":"'Year 2'!F20*(100+Living)/100","v":4360.299},100,9,3,52323.588000000003,{"$f":"ROUNDUP(H20+I20,0)","v":12},null,{"$f":"'Year 2'!M20","v":49320},{"$f":"'Year 2'!N20","v":50799.600000000006},52323.588000000003,null,null,{"$f":"'Year 2'!R20","v":11682.9252},{"$f":"'Year 2'!J40","v":15193.9794},{"$f":"J42","v":12182.228660879999}]
[{"$f":"'Year 2'!A21","v":"Raman"},{"$f":"'Year 2'!B21","v":"Revathi"},{"$f":"'Year 2'!C21","v":0},{"$f":"'Year 2'!D21","v":"Staff"},{"$f":"'Year 2'!E21","v":"Post Doc"},{"$f":"'Year 2'!F21*(100+Living)/100","v":4360.299},100,9,3,52323.588000000003,12,null,{"$f":"'Year 2'!M21","v":49320},{"$f":"'Year 2'!N21","v":50799.600000000006},52323.588000000003,null,null,{"$f":"'Year 2'!R21","v":14969.82},{"$f":"'Year 2'!J41","v":15193.9794},{"$f":"J43","v":15424.863582}]
[{"$f":"'Year 2'!A22","v":"Sun"},{"$f":"'Year 2'!B22","v":"Kelsey"},{"$f":"'Year 2'!C22","v":0},{"$f":"'Year 2'!D22","v":"Staff"},{"$f":"'Year 2'!E22","v":"Research Technician"},{"$f":"'Year 2'!F22*(100+Living)/100","v":3447.9250000000002},100,9,3,41375.100000000006,12,null,{"$f":"'Year 2'!M22","v":39000},{"$f":"'Year 2'!N22","v":40170},41375.100000000006,null,null,{"$f":"'Year 2'!R22","v":14969.82},{"$f":"'Year 2'!J42","v":13583.595000000001},{"$f":"J44","v":15424.863582}]
[{"$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":13406.34},{"$f":"'Year 2'!J43","v":0},{"$f":"J45","v":13766.167650000001}]
[{"$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":203246.26719000001}]
["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":"Jagadeeswaran"},{"$f":"'Year 2'!B39","v":"Pudur"},{"$f":"'Year 2'!C39","v":10523515},{"$f":"'Year 2'!D39","v":"ORP"},{"$f":"'Year 2'!E39","v":"Family"},{"$f":"'Year 2'!F39","v":"Yes"},{"$f":"'Year 2'!G39","v":"2007-09-01"},{"$f":"IF(G42>Fringe1End,R42,N42)","v":15.2},null,{"$f":"(J19*H42/100)+X42","v":12182.228660879999},{"$f":"IF(D42=$D$39,F1.Hourly,0)","v":0},{"$f":"IF(D42=$D$40,F1.FS.ORP,0)","v":21.47},{"$f":"IF(D42=$D$41,F1.FS.TRS,0)","v":0},{"$f":"SUM(K42:M42)","v":21.47},{"$f":"IF(D42=$D$39,F2.Hourly,0)","v":0},{"$f":"IF(D42=$D$40,F2.FS.ORP,0)","v":15.2},{"$f":"IF(D42=$D$41,F2.FS.TRS,0)","v":0},{"$f":"SUM(O42:Q42)","v":15.2},{"$f":"IF(F42=$F$40,G19,100)","v":95},{"$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":3484.1820000000002},{"$f":"IF(D19=$D$18,ROUNDDOWN(DAYS360(G42,$J$4)/(360*Long.Per),0)*20*K19*G19/100,0)+SUM(T42:W42)","v":3484.1820000000002},null,{"$f":"J42/J19","v":0.21288673522319546}]
[{"$f":"'Year 2'!A40","v":"Iyer"},{"$f":"'Year 2'!B40","v":"Neha"},{"$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,15424.863582,0,0,20.7,20.7,0,0,15.15,15.15,100,7497.84,0,0,0,7497.84,null,{"$f":"J43/J20","v":0.2947975123953655}]
[{"$f":"'Year 2'!A41","v":"Raman"},{"$f":"'Year 2'!B41","v":"Revathi"},{"$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,15424.863582,0,0,20.7,20.7,0,0,15.15,15.15,100,7497.84,0,0,0,7497.84,null,0.2947975123953655]
[{"$f":"'Year 2'!A42","v":"Sun"},{"$f":"'Year 2'!B42","v":"Kelsey"},{"$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,13766.167650000001,0,0,20.7,20.7,0,0,15.15,15.15,100,7497.84,0,0,0,7497.84,null,0.332716238752293]
[{"$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,20.7,20.7,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,20.7,20.7,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":"No"},{"$f":"'Year 2'!G45","v":"2007-09-01"},15.15,null,0,0,0,20.7,20.7,0,0,15.15,15.15,100,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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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":56798.123474879998},"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":260044.39066488002}]
["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":6.85},{"$f":"IF(D67=$D$66,F1.Under,0)","v":0},{"$f":"SUM(K83:L83)","v":6.85},{"$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,6.85,0,6.85,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,6.85,0,{"$f":"SUM(K85:L85)","v":6.85},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,6.85,0,6.85,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,6.85,0,6.85,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,6.85,0,6.85,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,6.85,0,6.85,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":203246.26719000001}]
[null,null,null,null,null,"Sum of Fringe Benefits",null,null,null,{"$f":"J56+J90","v":56798.123474879998}]
[null,null,null,null,null,"Sum of Personnel and Students",null,null,null,{"$f":"SUM(J92:J93)","v":260044.39066488002}]
["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,"Attending national meeting one per year for PI and postdocs",null,null,null,"Domestic",null,null,null,3000]
[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":3000}]
["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,null,null,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"]
["Mice per diem",null,"KO mice $1.66 per cage of 5 mice, 20 cages per line for 270 days",null,null,null,33.200000000000003,270,null,{"$f":"G111*H111","v":8964}]
["mice breeder pair",null,null,null,null,null,1510,2,null,3020]
["reagent kit",null,null,null,null,null,500,10,null,5000]
["reagents",null,null,null,null,null,1000,2,null,2000]
["Fish breeding supplies",null,null,null,null,null,5000,2,null,10000]
["Custom knockout mice",null,null,null,null,null,15000,2,null,{"$f":"G116*H116","v":30000}]
["Needles, gloves, chemicals",null,null,null,null,null,2000,1,null,2000]
[null,null,null,null,null,null,0,0,null,0]
[null,null,null,null,null,null,"Sum of Supplies",null,null,{"$f":"SUM(J111:J118)","v":60984}]
["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"]
["Publication Charges",null,"3 publications",null,null,null,3000,3,null,{"$f":"G122*H122","v":9000}]
[null,null,null,null,null,null,0,0,null,{"$f":"G123*H123","v":0}]
[null,null,null,null,null,"Sum of Publication/Printing Charges",null,null,null,{"$f":"SUM(J122:J123)","v":9000},"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'!A117:B117","v":0},null,{"$f":"'Year 2'!C117:H117","v":0},null,null,null,null,null,null,0,{"$f":"IF(M127+J127>25000,IF(M127>=25000,0,25000-M127),J127)","v":0},1,{"$f":"'Year 2'!N117","v":0},{"$f":"SUM(M127,J127)","v":0},{"$f":"'Year 2'!O117","v":0},{"$f":"'Year 2'!P117","v":0},{"$f":"J127","v":0}]
[{"$f":"'Year 2'!A118:B118","v":0},null,{"$f":"'Year 2'!C118:H118","v":0},null,null,null,null,null,null,0,{"$f":"IF(M128+J128>25000,IF(M128>=25000,0,25000-M128),J128)","v":0},1,{"$f":"'Year 2'!N118","v":0},{"$f":"SUM(M128,J128)","v":0},{"$f":"'Year 2'!O118","v":0},{"$f":"'Year 2'!P118","v":0},{"$f":"J128","v":0}]
[{"$f":"'Year 2'!A119:B119","v":0},null,{"$f":"'Year 2'!C119:H119","v":0},null,null,null,null,null,null,0,{"$f":"IF(M129+J129>25000,IF(M129>=25000,0,25000-M129),J129)","v":0},2,{"$f":"'Year 2'!N119","v":0},{"$f":"SUM(M129,J129)","v":0},{"$f":"'Year 2'!O119","v":0},{"$f":"'Year 2'!P119","v":0},{"$f":"J129","v":0}]
[0,null,null,null,null,null,null,null,null,0,{"$f":"IF(M130+J130>25000,IF(M130>=25000,0,25000-M130),J130)","v":0},3,0,{"$f":"SUM(M130,J130)","v":0},0,0,{"$f":"J130","v":0}]
[null,null,null,null,null,"Sum of Sub-Contracts",null,null,null,{"$f":"SUM(J127:J130)","v":0},{"$f":"SUM(K127:K130)","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":"G140*H140","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G141*H141","v":0}]
[null,null,null,null,null,null,null,"Sum of Participant Support Costs",null,{"$f":"SUM(J140:J141)","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":"G151*H151","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G152*H152","v":0}]
[null,null,null,null,null,null,null,"Sum of Other-Graduate Student Tuition ",null,{"$f":"SUM(J151:J152)","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":"G160*H160","v":0},{"$f":"IF(OR(A160=$A$157,A160=$A$158),0,J160)","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"G161*H161","v":0},{"$f":"IF(OR(A161=$A$157,A161=$A$158),0,J161)","v":0}]
[null,null,null,null,null,null,null,"Sum of Other",null,{"$f":"SUM(J160:J161)","v":0},{"$f":"SUM(K160:K161)","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+J119+J124+K131+K162)","v":333028.39066488005}]
[{"$f":"'Year 1'!A145:B145","v":"Agency Restricted"},null,{"$f":"'Year 1'!C145","v":10},{"$f":"'Year 1'!D145:F145","v":"https://docs.gatesfoundation.org/documents/indirect_cost_policy.pdf"},null,null,"IDC Amount on TDC",null,null,{"$f":"J166*C165/100","v":33302.839066488006}]
[null,null,null,null,null,"Total Direct Costs (Sponsor Direct)",null,null,null,{"$f":"SUM(J131,J162,J142,J124,J119,J108,J103,J94,J153)","v":333028.39066488005}]
[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(J165:J166)","v":366331.22973136808}]
[]
["University of North Texas, Office of 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":"20-0611"},"BB version:",null,{"$f":"'Year 1'!E1","v":"FY 2020"},"This Budget is prepared for:",null,null,{"$f":"'Year 1'!I1","v":"Gates Foundation"},"Year 4"]
["Project Title:",{"$f":"'Year 1'!B2:J2","v":"Genome-wide Knockdown Screens of Oocyte Maturation"}]
["Budget Prepared by:",null,{"$f":"'Year 1'!C3:D3","v":"Pudur Jagadeeswaran"},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":"Jagadeeswaran"},{"$f":"'Year 3'!B19","v":"Pudur"},{"$f":"'Year 3'!C19","v":10523515},{"$f":"'Year 3'!D19","v":"Faculty"},{"$f":"'Year 3'!E19","v":"PI"},{"$f":"'Year 3'!F19*(100+Living)/100","v":20680.951201999997},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":53939.1},{"$f":"'Year 3'!N19","v":55557.273000000001},{"$f":"'Year 3'!O19","v":57223.991189999993},{"$f":"J19","v":0},null,{"$f":"'Year 3'!R19","v":11682.9252},{"$f":"'Year 3'!S19","v":11928.887496000001},{"$f":"'Year 3'!T19","v":12182.228660879999},{"$f":"J43","v":0}]
[{"$f":"'Year 3'!A20","v":"Iyer"},{"$f":"'Year 3'!B20","v":"Neha"},{"$f":"'Year 3'!C20","v":0},{"$f":"'Year 3'!D20","v":"Staff"},{"$f":"'Year 3'!E20","v":"Post Doc"},{"$f":"'Year 3'!F20*(100+Living)/100","v":4491.10797},0,0,0,0,{"$f":"ROUNDUP(H20+I20,0)","v":0},null,{"$f":"'Year 3'!M20","v":49320},{"$f":"'Year 3'!N20","v":50799.600000000006},{"$f":"'Year 3'!O20","v":52323.588000000003},0,null,{"$f":"'Year 3'!R20","v":11682.9252},{"$f":"'Year 3'!S20","v":15193.9794},{"$f":"'Year 3'!T20","v":12182.228660879999},{"$f":"J43","v":0}]
[{"$f":"'Year 3'!A21","v":"Raman"},{"$f":"'Year 3'!B21","v":"Revathi"},{"$f":"'Year 3'!C21","v":0},{"$f":"'Year 3'!D21","v":"Staff"},{"$f":"'Year 3'!E21","v":"Post Doc"},{"$f":"'Year 3'!F21*(100+Living)/100","v":4491.10797},0,0,0,0,0,null,{"$f":"'Year 3'!M21","v":49320},{"$f":"'Year 3'!N21","v":50799.600000000006},{"$f":"'Year 3'!O21","v":52323.588000000003},0,null,{"$f":"'Year 3'!R21","v":14969.82},{"$f":"'Year 3'!S21","v":15193.9794},{"$f":"'Year 3'!T21","v":15424.863582},{"$f":"J44","v":0}]
[{"$f":"'Year 3'!A22","v":"Sun"},{"$f":"'Year 3'!B22","v":"Kelsey"},{"$f":"'Year 3'!C22","v":0},{"$f":"'Year 3'!D22","v":"Staff"},{"$f":"'Year 3'!E22","v":"Research Technician"},{"$f":"'Year 3'!F22*(100+Living)/100","v":3551.3627500000002},0,0,0,0,0,null,{"$f":"'Year 3'!M22","v":39000},{"$f":"'Year 3'!N22","v":40170},{"$f":"'Year 3'!O22","v":41375.100000000006},0,null,{"$f":"'Year 3'!R22","v":14969.82},{"$f":"'Year 3'!S22","v":13583.595000000001},{"$f":"'Year 3'!T22","v":15424.863582},{"$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":13406.34},{"$f":"'Year 3'!S23","v":0},{"$f":"'Year 3'!T23","v":13766.167650000001},{"$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":"Jagadeeswaran"},{"$f":"'Year 3'!B42","v":"Pudur"},{"$f":"'Year 3'!C42","v":10523515},{"$f":"'Year 3'!D42","v":"ORP"},{"$f":"'Year 3'!E42","v":"Family"},{"$f":"'Year 3'!F42","v":"Yes"},{"$f":"'Year 3'!G42","v":"2007-09-01"},{"$f":"IF(G43>Fringe1End,R43,N43)","v":15.2},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":21.47},{"$f":"IF(D43=$D$42,F1.FS.TRS,0)","v":0},{"$f":"SUM(K43:M43)","v":21.47},{"$f":"IF(D43=$D$40,F2.Hourly,0)","v":0},{"$f":"IF(D43=$D$41,F2.FS.ORP,0)","v":15.2},{"$f":"IF(D43=$D$42,F2.FS.TRS,0)","v":0},{"$f":"SUM(O43:Q43)","v":15.2},{"$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":"Iyer"},{"$f":"'Year 3'!B43","v":"Neha"},{"$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,20.7,20.7,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 3'!A44","v":"Raman"},{"$f":"'Year 3'!B44","v":"Revathi"},{"$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,20.7,20.7,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 3'!A45","v":"Sun"},{"$f":"'Year 3'!B45","v":"Kelsey"},{"$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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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":"No"},{"$f":"'Year 3'!G48","v":"2007-09-01"},15.15,null,0,0,0,20.7,20.7,0,0,15.15,15.15,100,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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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":6.85},{"$f":"IF(D69=$D$68,F1.Under,0)","v":0},{"$f":"SUM(K86:L86)","v":6.85},{"$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,6.85,0,6.85,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,6.85,0,{"$f":"SUM(K88:L88)","v":6.85},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,6.85,0,6.85,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,6.85,0,{"$f":"SUM(K90:L90)","v":6.85},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,6.85,0,6.85,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,6.85,0,6.85,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,6.85,0,6.85,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'!A127:B127","v":0},null,{"$f":"'Year 3'!C127:H127","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'!N127","v":0},{"$f":"SUM(M125,J125)","v":0},{"$f":"'Year 3'!O127","v":0},{"$f":"'Year 3'!P127","v":0},{"$f":"'Year 3'!Q127","v":0},{"$f":"J125","v":0}]
[{"$f":"'Year 3'!A128:B128","v":0},null,{"$f":"'Year 3'!C128:H128","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'!N128","v":0},{"$f":"SUM(M126,J126)","v":0},{"$f":"'Year 3'!O128","v":0},{"$f":"'Year 3'!P128","v":0},{"$f":"'Year 3'!Q128","v":0},{"$f":"J126","v":0}]
[{"$f":"'Year 3'!A129:B129","v":0},null,{"$f":"'Year 3'!C129:H129","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'!N129","v":0},{"$f":"SUM(M127,J127)","v":0},{"$f":"'Year 3'!O129","v":0},{"$f":"'Year 3'!P129","v":0},{"$f":"'Year 3'!Q129","v":0},{"$f":"J127","v":0}]
[{"$f":"'Year 3'!A130:B130","v":0},null,{"$f":"'Year 3'!C130:H130","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'!N130","v":0},{"$f":"SUM(M128,J128)","v":0},{"$f":"'Year 3'!O130","v":0},{"$f":"'Year 3'!P130","v":0},{"$f":"'Year 3'!Q130","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'!A145:B145","v":"Agency Restricted"},null,{"$f":"'Year 1'!C145","v":10},{"$f":"'Year 1'!D145:F145","v":"https://docs.gatesfoundation.org/documents/indirect_cost_policy.pdf"},null,null,"IDC Amount on TDC",null,null,{"$f":"J165*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, Office of 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":"20-0611"},"BB version:",null,{"$f":"'Year 1'!E1","v":"FY 2020"},"This Budget is prepared for:",null,null,{"$f":"'Year 1'!I1","v":"Gates Foundation"},"Year 5"]
["Project Title:",{"$f":"'Year 1'!B2:J2","v":"Genome-wide Knockdown Screens of Oocyte Maturation"}]
["Budget Prepared by:",null,{"$f":"'Year 1'!C3:D3","v":"Pudur Jagadeeswaran"},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":"Jagadeeswaran"},{"$f":"'Year 4'!B19","v":"Pudur"},{"$f":"'Year 4'!C19","v":10523515},{"$f":"'Year 4'!D19","v":"Faculty"},{"$f":"'Year 4'!E19","v":"PI"},{"$f":"'Year 4'!F19*(100+Living)/100","v":21301.379738059997},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":53939.1},{"$f":"'Year 4'!N19","v":55557.273000000001},{"$f":"'Year 4'!O19","v":57223.991189999993},{"$f":"'Year 4'!P19","v":0},{"$f":"J19","v":0},{"$f":"'Year 4'!R19","v":11682.9252},{"$f":"'Year 4'!S19","v":11928.887496000001},{"$f":"'Year 4'!T19","v":12182.228660879999},{"$f":"'Year 4'!U19","v":0},{"$f":"J44","v":0}]
[{"$f":"'Year 4'!A20","v":"Iyer"},{"$f":"'Year 4'!B20","v":"Neha"},{"$f":"'Year 4'!C20","v":0},{"$f":"'Year 4'!D20","v":"Staff"},{"$f":"'Year 4'!E20","v":"Post Doc"},{"$f":"'Year 4'!F20*(100+Living)/100","v":4625.8412091},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":49320},{"$f":"'Year 4'!N20","v":50799.600000000006},{"$f":"'Year 4'!O20","v":52323.588000000003},{"$f":"'Year 4'!P20","v":0},0,{"$f":"'Year 4'!R20","v":11682.9252},{"$f":"'Year 4'!S20","v":15193.9794},{"$f":"'Year 4'!T20","v":12182.228660879999},{"$f":"'Year 4'!U20","v":0},{"$f":"J44","v":0}]
[{"$f":"'Year 4'!A21","v":"Raman"},{"$f":"'Year 4'!B21","v":"Revathi"},{"$f":"'Year 4'!C21","v":0},{"$f":"'Year 4'!D21","v":"Staff"},{"$f":"'Year 4'!E21","v":"Post Doc"},{"$f":"'Year 4'!F21*(100+Living)/100","v":4625.8412091},0,0,0,0,0,null,{"$f":"'Year 4'!M21","v":49320},{"$f":"'Year 4'!N21","v":50799.600000000006},{"$f":"'Year 4'!O21","v":52323.588000000003},{"$f":"'Year 4'!P21","v":0},0,{"$f":"'Year 4'!R21","v":14969.82},{"$f":"'Year 4'!S21","v":15193.9794},{"$f":"'Year 4'!T21","v":15424.863582},{"$f":"'Year 4'!U21","v":0},{"$f":"J45","v":0}]
[{"$f":"'Year 4'!A22","v":"Sun"},{"$f":"'Year 4'!B22","v":"Kelsey"},{"$f":"'Year 4'!C22","v":0},{"$f":"'Year 4'!D22","v":"Staff"},{"$f":"'Year 4'!E22","v":"Research Technician"},{"$f":"'Year 4'!F22*(100+Living)/100","v":3657.9036325000006},0,0,0,{"$f":"F22*((G22*H22)/100+(G22*I22)/100)","v":0},0,null,{"$f":"'Year 4'!M22","v":39000},{"$f":"'Year 4'!N22","v":40170},{"$f":"'Year 4'!O22","v":41375.100000000006},{"$f":"'Year 4'!P22","v":0},0,{"$f":"'Year 4'!R22","v":14969.82},{"$f":"'Year 4'!S22","v":13583.595000000001},{"$f":"'Year 4'!T22","v":15424.863582},{"$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":13406.34},{"$f":"'Year 4'!S23","v":0},{"$f":"'Year 4'!T23","v":13766.167650000001},{"$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":"Jagadeeswaran"},{"$f":"'Year 4'!B43","v":"Pudur"},{"$f":"'Year 4'!C43","v":10523515},{"$f":"'Year 4'!D43","v":"ORP"},{"$f":"'Year 4'!E43","v":"Family"},{"$f":"'Year 4'!F43","v":"Yes"},{"$f":"'Year 4'!G43","v":"2007-09-01"},{"$f":"IF(G44>Fringe1End,R44,N44)","v":15.2},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":21.47},{"$f":"IF(D44=$D$43,F1.FS.TRS,0)","v":0},{"$f":"SUM(K44:M44)","v":21.47},{"$f":"IF(D44=$D$41,F2.Hourly,0)","v":0},{"$f":"IF(D44=$D$42,F2.FS.ORP,0)","v":15.2},{"$f":"IF(D44=$D$43,F2.FS.TRS,0)","v":0},{"$f":"SUM(O44:Q44)","v":15.2},{"$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":"Iyer"},{"$f":"'Year 4'!B44","v":"Neha"},{"$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,20.7,20.7,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 4'!A45","v":"Raman"},{"$f":"'Year 4'!B45","v":"Revathi"},{"$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,20.7,20.7,0,0,15.15,15.15,0,0,0,0,0,0]
[{"$f":"'Year 4'!A46","v":"Sun"},{"$f":"'Year 4'!B46","v":"Kelsey"},{"$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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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":"No"},{"$f":"'Year 4'!G49","v":"2007-09-01"},15.15,null,0,0,0,20.7,20.7,0,0,15.15,15.15,100,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,20.7,20.7,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,20.7,20.7,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":20.7},{"$f":"SUM(K53:M53)","v":20.7},{"$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,20.7,20.7,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,20.7,20.7,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":20.7},{"$f":"SUM(K56:M56)","v":20.7},{"$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,20.7,20.7,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,20.7,20.7,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,20.7,20.7,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":6.85},{"$f":"IF(D71=$D$70,F1.Under,0)","v":0},{"$f":"SUM(K89:L89)","v":6.85},{"$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,6.85,0,{"$f":"SUM(K90:L90)","v":6.85},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,6.85,0,{"$f":"SUM(K91:L91)","v":6.85},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,6.85,0,6.85,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,6.85,0,{"$f":"SUM(K93:L93)","v":6.85},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,6.85,0,6.85,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,6.85,0,6.85,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,6.85,0,6.85,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,6.85,0,6.85,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'!A145:B145","v":"Agency Restricted"},null,{"$f":"'Year 1'!C145","v":10},{"$f":"'Year 1'!D145:F145","v":"https://docs.gatesfoundation.org/documents/indirect_cost_policy.pdf"},null,null,"IDC Amount on TDC",null,null,{"$f":"J170*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, Office of 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":"20-0611"},null,null,null,null,null,null,null,null,null,"This Budget was drafted on:"]
["Project Title:",{"$f":"'Year 1'!B2:J2","v":"Genome-wide Knockdown Screens of Oocyte Maturation"}]
["BB Version:",{"$f":"'Year 1'!E1","v":"FY 2020"}]
[]
["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":"Jagadeeswaran"},{"$f":"'Year 5'!B19","v":"Pudur"},{"$f":"'Year 5'!C19","v":10523515},null,null,null,null,{"$f":"'Year 1'!J19","v":53939.1},{"$f":"'Year 2'!J19","v":55557.273000000001},{"$f":"'Year 3'!J19","v":57223.991189999993},{"$f":"'Year 4'!J19","v":0},{"$f":"'Year 5'!J19","v":0},null,{"$f":"SUM(H8:M8)","v":166720.36418999999}]
[{"$f":"'Year 5'!A20","v":"Iyer"},{"$f":"'Year 5'!B20","v":"Neha"},{"$f":"'Year 5'!C20","v":0},null,null,null,null,{"$f":"'Year 1'!J20","v":49320},{"$f":"'Year 2'!J20","v":50799.600000000006},{"$f":"'Year 3'!J20","v":52323.588000000003},{"$f":"'Year 4'!J20","v":0},{"$f":"'Year 5'!J20","v":0},null,152443.18800000002]
[{"$f":"'Year 5'!A21","v":"Raman"},{"$f":"'Year 5'!B21","v":"Revathi"},{"$f":"'Year 5'!C21","v":0},null,null,null,null,{"$f":"'Year 1'!J21","v":49320},{"$f":"'Year 2'!J21","v":50799.600000000006},{"$f":"'Year 3'!J21","v":52323.588000000003},{"$f":"'Year 4'!J21","v":0},{"$f":"'Year 5'!J21","v":0},null,152443.18800000002]
[{"$f":"'Year 5'!A22","v":"Sun"},{"$f":"'Year 5'!B22","v":"Kelsey"},{"$f":"'Year 5'!C22","v":0},null,null,null,null,{"$f":"'Year 1'!J22","v":39000},{"$f":"'Year 2'!J22","v":40170},{"$f":"'Year 3'!J22","v":41375.100000000006},{"$f":"'Year 4'!J22","v":0},{"$f":"'Year 5'!J22","v":0},null,120545.1]
[{"$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":191579.1},{"$f":"SUM(I8:I24)","v":197326.473},203246.26719000001,0,0,0,592151.84019000002]
[]
["Fringe Benefits"]
[{"$f":"'Year 5'!A44","v":"Jagadeeswaran"},{"$f":"'Year 5'!B44","v":"Pudur"},{"$f":"'Year 5'!C44","v":10523515},null,null,null,null,{"$f":"'Year 1'!J35","v":11682.9252},{"$f":"'Year 2'!J39","v":11928.887496000001},{"$f":"'Year 3'!J42","v":12182.228660879999},{"$f":"'Year 4'!J43","v":0},{"$f":"'Year 5'!J44","v":0},null,{"$f":"SUM(H28:M28)","v":35794.04135688}]
[{"$f":"'Year 5'!A45","v":"Iyer"},{"$f":"'Year 5'!B45","v":"Neha"},{"$f":"'Year 5'!C45","v":0},null,null,null,null,{"$f":"'Year 1'!J36","v":14969.82},{"$f":"'Year 2'!J40","v":15193.9794},{"$f":"'Year 3'!J43","v":15424.863582},{"$f":"'Year 4'!J44","v":0},{"$f":"'Year 5'!J45","v":0},null,45588.662982000002]
[{"$f":"'Year 5'!A46","v":"Raman"},{"$f":"'Year 5'!B46","v":"Revathi"},{"$f":"'Year 5'!C46","v":0},null,null,null,null,{"$f":"'Year 1'!J37","v":14969.82},{"$f":"'Year 2'!J41","v":15193.9794},{"$f":"'Year 3'!J44","v":15424.863582},{"$f":"'Year 4'!J45","v":0},{"$f":"'Year 5'!J46","v":0},null,45588.662982000002]
[{"$f":"'Year 5'!A47","v":"Sun"},{"$f":"'Year 5'!B47","v":"Kelsey"},{"$f":"'Year 5'!C47","v":0},null,null,null,null,{"$f":"'Year 1'!J38","v":13406.34},{"$f":"'Year 2'!J42","v":13583.595000000001},{"$f":"'Year 3'!J45","v":13766.167650000001},{"$f":"'Year 4'!J46","v":0},{"$f":"'Year 5'!J47","v":0},null,40756.102650000001]
[{"$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":55028.905199999994},{"$f":"SUM(I28:I44)","v":55900.441296000005},56798.123474879998,0,0,0,167727.46997088002]
[]
["Subtotal of Personnel and FB",null,null,null,null,null,null,{"$f":"H45+H25","v":246608.00520000001},253226.914296,260044.39066488002,0,0,0,759879.31016087998]
[]
["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":191579.1},{"$f":"I25+I60","v":197326.473},{"$f":"J25+J60","v":203246.26719000001},{"$f":"K25+K60","v":0},{"$f":"L25+L60","v":0},null,{"$f":"SUM(H77:M77)","v":592151.84019000002}]
["Subtotal of Fringe Benefits",null,null,null,null,null,null,{"$f":"H45+H73","v":55028.905199999994},{"$f":"I45+I73","v":55900.441296000005},{"$f":"J45+J73","v":56798.123474879998},{"$f":"K45+K73","v":0},{"$f":"L45+L73","v":0},null,{"$f":"SUM(H78:M78)","v":167727.46997087999}]
[]
["Subtotal of Personnel and Students",null,null,null,null,null,null,{"$f":"H75+H47","v":246608.00520000001},{"$f":"I75+I47","v":253226.914296},{"$f":"J75+J47","v":260044.39066488002},{"$f":"K75+K47","v":0},{"$f":"L75+L47","v":0},{"$f":"M75+M62","v":0},{"$f":"SUM(H80:M80)","v":759879.31016088009}]
["Travel",null,null,null,null,null,null,{"$f":"'Year 1'!J83","v":3000},{"$f":"'Year 2'!J95","v":3000},{"$f":"'Year 3'!J103","v":3000},{"$f":"'Year 4'!J107","v":0},{"$f":"'Year 5'!J111","v":0},null,{"$f":"SUM(H81:M81)","v":9000}]
["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'!J96","v":69250},{"$f":"'Year 2'!J109","v":69250},{"$f":"'Year 3'!J119","v":60984},{"$f":"'Year 4'!J117","v":0},{"$f":"'Year 5'!J121","v":0},null,199484]
["Publication/Printing Charges",null,null,null,null,null,null,{"$f":"'Year 1'!J101","v":0},{"$f":"'Year 2'!J114","v":0},{"$f":"'Year 3'!J124","v":9000},{"$f":"'Year 4'!J122","v":0},{"$f":"'Year 5'!J126","v":0},null,9000]
[]
["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'!J117","v":0},{"$f":"'Year 2'!J131","v":0},{"$f":"'Year 3'!J142","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'!J127","v":0},{"$f":"'Year 2'!J144","v":0},{"$f":"'Year 3'!J153","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'!J136","v":0},{"$f":"'Year 2'!J153","v":0},{"$f":"'Year 3'!J162","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":217484}]
["Total Direct Costs",null,null,null,null,null,null,{"$f":"SUM(H80:H84,H94,H96:H98)","v":318858.00520000001},{"$f":"SUM(I80:I84,I94,I96:I98)","v":325476.91429600003},333028.39066488005,0,0,{"$f":"SUM(M47:M98)","v":0},977363.31016088009]
[]
["Modified Total Direct Costs (Base for F&A)",null,null,null,null,null,null,{"$f":"'Year 1'!J138","v":318858.00520000001},{"$f":"'Year 2'!J155","v":325476.91429600003},{"$f":"'Year 3'!J164","v":333028.39066488005},{"$f":"'Year 4'!J163","v":0},{"$f":"'Year 5'!J168","v":0},null,{"$f":"SUM(H102:M102)","v":977363.31016088009}]
["Indirect Costs",null,null,null,null,null,null,{"$f":"'Year 1'!J145","v":31885.800520000001},{"$f":"'Year 2'!J156","v":32547.691429600003},{"$f":"'Year 3'!J165","v":33302.839066488006},{"$f":"'Year 4'!J164","v":0},{"$f":"'Year 5'!J169","v":0},null,97736.331016088021]
[]
["Total Direct Costs (Sponsor Direct)",null,null,null,null,null,null,{"$f":"'Year 1'!J146","v":318858.00520000001},{"$f":"'Year 2'!J157","v":325476.91429600003},{"$f":"'Year 3'!J166","v":333028.39066488005},{"$f":"'Year 4'!J165","v":0},{"$f":"'Year 5'!J170","v":0},null,{"$f":"SUM(H105:M105)","v":977363.31016088009}]
["Indirect Costs",null,null,null,null,null,null,{"$f":"'Year 1'!J145","v":31885.800520000001},{"$f":"'Year 2'!J156","v":32547.691429600003},{"$f":"'Year 3'!J165","v":33302.839066488006},{"$f":"'Year 4'!J164","v":0},{"$f":"'Year 5'!J169","v":0},null,{"$f":"SUM(H106:M106)","v":97736.331016088021}]
["Requested Amount",null,null,null,null,null,null,{"$f":"SUM(H105:H106)","v":350743.80572},{"$f":"SUM(I105:I106)","v":358024.60572560003},{"$f":"SUM(J105:J106)","v":366331.22973136808},{"$f":"SUM(K105:K106)","v":0},{"$f":"SUM(L105:L106)","v":0},null,{"$f":"SUM(N105:N106)","v":1075099.6411769681}]
[]
["Requested Amount",null,null,null,null,null,null,{"$f":"'Year 1'!J147","v":350743.80572},{"$f":"'Year 2'!J158","v":358024.60572560003},{"$f":"'Year 3'!J167","v":366331.22973136808},{"$f":"'Year 4'!J166","v":0},{"$f":"'Year 5'!J171","v":0},null,{"$f":"SUM(H109:M109)","v":1075099.6411769681}]
[]
[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":"Pudur Jagadeeswaran"}]
["Phone Number:",null,{"$f":"'Year 1'!F3","v":0}]
["E-mail:",null,{"$f":"H111","v":0}]
[]
[]
["University of North Texas, Office of Grants & Contracts Administration"]