{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Face Page","Base Budget","Mod Budget Form","Checklist","Tuition","BA Upload"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":5,"defined_names":77,"comments":3,"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":"Face Page","index":0,"n_rows":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[[37,7,37,12],[38,5,38,6],[46,13,46,14],[2,8,2,9],[4,0,5,6],[22,10,23,11],[22,12,23,13],[30,7,30,8],[30,9,30,12],[30,13,30,14]]}
["Form Approved Through 6/30/2012",null,null,null,null,null,null,null,null,null,null,null,null,null,"OMB No.   0925-0001  "]
["Department of Health and Human Services",null,null,null,null,null,null,"  LEAVE BLANK—FOR PHS USE ONLY."]
["Public Health Services",null,null,null,null,null,null,"  Type"," Activity",null,null,"Number"]
[null,null,null,null,null,null,null,"  Review Group",null,null,null,"Formerly"]
["Do not exceed character length restrictions indicated.",null,null,null,null,null,null,"  Council/Board (Month, Year)",null,null,null,"Date Received"]
[]
["1.   TITLE OF PROJECT (Do not exceed 81 characters, including spaces and punctuation.)"]
[]
["2.   RESPONSE TO SPECIFIC REQUEST FOR APPLICATIONS OR PROGRAM ANNOUNCEMENT OR SOLICITATION",null,null,null,null,null,null,null,null,null,null,null,null,"NO","YES"]
["   (If \"Yes,\" state number and title)"]
["Number:",null,null,"      Title:"]
["3.  PROGRAM DIRECTOR/PRINCIPAL INVESTIGATOR"]
["3a.  NAME (Last, first, middle)",null,null,null,null,null,null,"3b.   DEGREE(S)",null,null,"3h.","  eRA Commons User Name"]
[]
["3c.  POSITION TITLE",null,null,null,null,null,null,"3d.   MAILING ADDRESS  (Street, city, state, zip code)"]
[]
["3e.  DEPARTMENT, SERVICE, LABORATORY, OR EQUIVALENT"]
[]
["3f.  MAJOR SUBDIVISION",null,null,null,null,null,null,null,"Ames, IA 50011-xxxx"]
[]
["3g.  TELEPHONE AND FAX  (Area code, number and extension)",null,null,null,null,null,null,"E-MAIL ADDRESS:"]
[" TEL:","(515) 294-xxxx",null,null,"    FAX:",null,"(515) 294-xxxx"]
["4.  HUMAN SUBJECTS RESEARCH",null,null,null,null,"4a.  Research Exempt",null," If \"Yes,\" Exemption No. "]
["           No","        Yes",null,null,null,"          No             Yes"]
["4b.  Federal-Wide Assurance No.",null,null,null,null,"4c.  Clinical Trial",null,null,null,"4d.  NIH-defined Phase III Clinical Trial"]
[null,null,null,null,null,"          No             Yes",null,null,null,"        No",null,"Yes"]
["5.   VERTEBRATE ANIMALS",null,null,"   No","         Yes",null,null,"5a. Animal Welfare Assurance No."]
["6.  DATES OF PROPOSED PERIOD OF",null,null,null,null,null,"7.  COSTS REQUESTED FOR INITIAL",null,null,"8.   COSTS REQUESTED FOR PROPOSED",null,null,null,null,null," ","  "," "]
["     SUPPORT (month, day, year--MM/DD/YY)",null,null,null,null,null,"     BUDGET PERIOD",null,null,"      PERIOD OF SUPPORT",null,null,null,null,null,null," "]
["From",null,"Through",null,null,null,"7a.  Direct Costs ($)","7b.  Total Costs ($)",null,"8a.  Direct Costs ($)",null,null,null,"8b.  Total Costs ($)"]
[null,null,null,null,null,null,{"$f":"'Base Budget'!H51+'Base Budget'!H72","v":0},{"$f":"'Base Budget'!H80","v":0},null,{"$f":"'Base Budget'!R51+'Base Budget'!R72","v":0},null,null,null,{"$f":"'Base Budget'!C87","v":0}]
["9.   APPLICANT ORGANIZATION",null,null,null,null,null,null,"10.   TYPE OF ORGANIZATION"]
["Name","Iowa State University of Science and Technology",null,null,null,null,null,"         Public:",null," Federal",null,"    State",null,"           Local"]
["Address","Office of Sponsored Programs Administration",null,null,null,null,null,"         Private:",null," Private Nonprofit"]
[null,"1138 Pearson",null,null,null,null,null,"         For-profit:",null," General",null,"Small Business"]
[null,"Ames, IA 50011-2207",null,null,null,null,null,"        Woman-owned",null,"    Socially and Economically Disadvantaged"]
[null,null,null,null,null,null,null," 11.   ENTITY IDENTIFICATION NUMBER"]
[null,null,null,null,null,null,null,426004224]
[null,null,null,null,null,null,null,"DUNS NO",null,"005309844",null,"Cong. District",null,null,"IA-004"]
["12. ADMINISTRATIVE OFFICIAL TO BE NOTIFIED IF AWARD IS MADE",null,null,null,null,null,null,"13.  OFFICIAL SIGNING FOR APPLICANT ORGANIZATION"]
["Name","Rochelle Athey",null,null,null,null,null,"Name","Sara Jane M. Oftelie"]
["Title","Director, OSPA",null,null,null,null,null,"Title","Manager, Pre-Award Services"]
["Address","Iowa State University of Science and Technology",null,null,null,null,null,"Address","Iowa State University of Science and Technology"]
[null,"Office of Sponsored Programs Administration",null,null,null,null,null,null,"Office of Sponsored Programs Administration"]
[null,"1138 Pearson",null,null,null,null,null,null,"1138 Pearson"]
[null,"Ames, IA 50011-2207",null,null,null,null,null,null,"Ames, IA 50011-2207"]
["Tel:","515-294-5225",null,null,null,"FAX:","515-294-8000","Tel:","515-294-5225",null,null,null,"FAX:","515-294-8000"]
["E-Mail:","grants@iastate.edu",null,null,null,null,null,"E-Mail:","grants@iastate.edu"]
[null,null,null,null,null,null,null,"SIGNATURE OF OFFICIAL NAMED IN 13.",null,null,null,null,null,null,"DATE"]
[null,null,null,null,null,null,null," (In ink. \"Per\" signature not acceptable.)"]
[]
[]
["PHS 398 (Rev. 6/09)",null,null,null,null,null,"                                           Face Page  ",null,null,null,null,null,null,null,"Form Page 1"]

{"sheet":"Base Budget","index":1,"n_rows":87,"n_cols":30,"rows_kept":87,"cut":false,"hidden":false,"merged":[[88,7,89,9],[90,7,90,9],[91,7,91,9],[1,29,1,31],[2,29,2,31],[88,10,89,15],[90,10,90,11],[91,10,91,11],[23,0,23,17],[14,1,14,4],[0,0,1,4],[9,7,10,11],[12,9,12,15],[21,0,21,4],[15,0,15,17],[16,2,17,15],[18,2,18,15],[19,2,19,15],[80,2,81,4],[34,0,34,4]]}
["NIH Modular Grant Worksheet,    1 - 5 Years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eff 7/1/2014"]
["Iowa State University",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 6/30/2014"]
[]
["Indirect Cost Categories:"]
[0.5,null,"On-Campus Organized Research"]
[0.51,null,"On Campus Instruction"]
[0.32,null,"On-Campus Other Sponsored Activities"]
[0.26,null,"Off-Campus All Programs"]
[]
[]
[null,null,null,null,null,null,null,"Note:  A module is any multiple of $25,000 up to, and including $250,000."]
["F&A (Indirect) Rate",null,0.5,null,null,null,null,1,null,"<< Number of Years for Project"]
[]
["PI's Name:"]
["Direct Costs that are subject to Indirect"]
[null,null,"Salary Cap policy @ http://grants.nih.gov/grants/guide/notice-files/NOT-OD-12-035.html"]
["Note for Personnel > >"]
[null,null,"Salary cap for Post Docs @ http://grants.nih.gov/grants/guide/notice-files/NOT-OD-12-033.html"]
[null,null,"Salary Cap for Graduate Students @ http://grants.nih.gov/grants/guide/notice-files/NOT-OD-12-033.html"]
[]
["All other costs not listed below: Salaries, Fringe Benefits, travel, materials & supplies, etc.",null,null,null,null,null,null,0,null,0,null,0,null,0,null,0]
[]
["Direct Costs that are NOT subject to Indirect"]
[" "]
[]
["Equipment: $5,000 or greater per item"]
["(Itemize)"]
[null,null,null,null,null,null,null,0,null,0," ",0," ",0,null,0]
[null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0]
["Subtotals",null,null,null,null,null,null,{"$f":"SUM(H29:H32)","v":0},null,{"$f":"SUM(J29:J32)","v":0},null,{"$f":"SUM(L29:L32)","v":0},null,{"$f":"SUM(N29:N32)","v":0},null,{"$f":"SUM(P29:P32)","v":0}]
[]
[]
["Note:  please indicate the number of Grad Students",null," # of Masters students",null,"# of PhD students"]
[null,null,1,null,0]
["Tuition",null,"(most majors)",null,null,null,null,{"$f":"Tuition!K6","v":0},null,{"$f":"Tuition!M6","v":0},null,{"$f":"Tuition!O6","v":0},null,{"$f":"Tuition!Q6","v":0},null,{"$f":"Tuition!S6","v":0}]
["Tuition",null,"(Engineering & Architecture)",null,null,null,null,{"$f":"Tuition!K26","v":0},null,{"$f":"Tuition!M26","v":0},null,{"$f":"Tuition!O26","v":0},null,{"$f":"Tuition!Q26","v":0},null,{"$f":"Tuition!S26","v":0}]
["Tuition",null,"(Business & STB)",null,null,null,null,{"$f":"Tuition!K46","v":0},null,{"$f":"Tuition!M46","v":0},null,{"$f":"Tuition!O46","v":0},null,{"$f":"Tuition!Q46","v":0},null,{"$f":"Tuition!S46","v":0}]
["Subtotals",null,null,null,null,null,null,{"$f":"+H38+H39+H40","v":0},null,{"$f":"+J38+J39+J40","v":0},null,{"$f":"+L38+L39+L40","v":0},null,{"$f":"+N38+N39+N40","v":0},null,{"$f":"+P38+P39+P40","v":0}]
[]
[]
["Patient Care"]
["Inpatient",null,null,null,null,null,null,0,null,0,null,0,null,0,null,0]
["Outpatient",null,null,null,null,null,null,0,null,0,null,0,null,0,null,0]
["Subtotals ",null,null,null,null,null,null,{"$f":"SUM(H45:H46)","v":0},null,{"$f":"SUM(J45:J46)","v":0},null,{"$f":"SUM(L45:L46)","v":0},null,{"$f":"SUM(N45:N46)","v":0},null,{"$f":"SUM(P45:P46)","v":0}]
[]
[]
[]
["Subtotal Direct Cost at ISU",null,null,null,null,null,null,{"$f":"SUM(+H33+H41+H22+H47)","v":0},null,{"$f":"SUM(+J33+J41+J22+J47)","v":0},null,{"$f":"SUM(+L33+L41+L22+L47)","v":0},null,{"$f":"SUM(+N33+N41+N22+N47)","v":0},null,{"$f":"SUM(+P33+P41+P22+P47)","v":0},null,{"$f":"SUM(H51:P51)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(+H51-H39)","v":0},null,{"$f":"SUM(+J51-J39)","v":0},null,{"$f":"SUM(+L51-L39)","v":0},null,{"$f":"SUM(+N51-N39)","v":0},null,{"$f":"SUM(+P51-P39)","v":0}]
[]
["Subawards"]
["Subawardee #1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub to IDC",null,"Not Sub to IDC"]
[null,null,null,null,"Direct",null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,{"$f":"IF(SUM(H56:P57)>25000,25000,SUM(H56:P57))","v":0},null,{"$f":"SUM(H56:P57)-U56","v":0}]
[null,null,null,null,"F&A (Indirect)",null,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,{"$f":"IF(H56+H57>=25000,\"25,000\",H56+H57)","v":0},null,{"$f":"IF(J56+J57+H58>=25000, 25000-H58, J56+J57)","v":0},null,{"$f":"IF(L56+L57+J58+H58>=25000, 25000-(J58+H58), L56+L57)","v":0},null,{"$f":"IF(N56+N57+L58+J58+H58>=25000, 25000-(L58+J58+H58), N56+N57)","v":0},null,{"$f":"IF(P56+P57+N58+L58+J58+H58>=25000, 25000-(N58+L58+J58+H58), P56+P57)","v":0}]
["Subawardee #2"]
[null,null,null,null,"Direct",null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,{"$f":"IF(SUM(H60:P61)>25000,25000,SUM(H60:P61))","v":0},null,{"$f":"SUM(H60:P61)-U60","v":0}]
[null,null,null,null,"F&A (Indirect)",null,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,{"$f":"IF(H60+H61>=25000,\"25,000\",H60+H61)","v":0},null,{"$f":"IF(J60+J61+H62>=25000, 25000-H62, J60+J61)","v":0},null,{"$f":"IF(L60+L61+J62+H62>=25000, 25000-(J62+H62), L60+L61)","v":0},null,{"$f":"IF(N60+N61+L62+J62+H62>=25000, 25000-(L62+J62+H62), N60+N61)","v":0},null,{"$f":"IF(P60+P61+N62+L62+J62+H62>=25000, 25000-(N62+L62+J62+H62), P60+P61)","v":0}]
["Subawardee #3"]
[null,null,null,null,"Direct",null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,{"$f":"IF(SUM(H64:P65)>25000,25000,SUM(H64:P65))","v":0},null,{"$f":"SUM(H64:P65)-U64","v":0}]
[null,null,null,null,"F&A (Indirect)",null,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,{"$f":"IF(H64+H65>=25000,\"25,000\",H64+H65)","v":0},null,{"$f":"IF(J64+J65+H66>=25000, 25000-H66, J64+J65)","v":0},null,{"$f":"IF(L64+L65+J66+H66>=25000, 25000-(J66+H66), L64+L65)","v":0},null,{"$f":"IF(N64+N65+L66+J66+H66>=25000, 25000-(L66+J66+H66), N64+N65)","v":0},null,{"$f":"IF(P64+P65+N66+L66+J66+H66>=25000, 25000-(N66+L66+J66+H66), P64+P65)","v":0}]
["Subawardee #4"]
[null,null,null,null,"Direct",null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,{"$f":"IF(SUM(H68:P69)>25000,25000,SUM(H68:P69))","v":0},null,{"$f":"SUM(H68:P69)-U68","v":0}]
[null,null,null,null,"F&A (Indirect)",null,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,{"$f":"IF(H68+H69>=25000,\"25,000\",H68+H69)","v":0},null,{"$f":"IF(J68+J69+H70>=25000, 25000-H70, J68+J69)","v":0},null,{"$f":"IF(L68+L69+J70+H70>=25000, 25000-(J70+H70), L68+L69)","v":0},null,{"$f":"IF(N68+N69+L70+J70+H70>=25000, 25000-(L70+J70+H70), N68+N69)","v":0},null,{"$f":"IF(P68+P69+N70+L70+J70+H70>=25000, 25000-(N70+L70+J70+H70), P68+P69)","v":0}]
[]
["Total Direct Subawards",null,null,null,null,null,null,{"$f":"SUM(H56+H60+H64+H68)","v":0},null,{"$f":"SUM(J56+J60+J64+J68)","v":0},null,{"$f":"SUM(L56+L60+L64+L68)","v":0},null,{"$f":"SUM(N56+N60+N64+N68)","v":0},null,{"$f":"SUM(P56+P60+P64+P68)","v":0},null,{"$f":"SUM(H72:P72)","v":0},null,null,{"$f":"SUM(U56:U69)","v":0},null,{"$f":"SUM(W56:W69)","v":0}]
["Total Indirect Subawards",null,null,null,null,null,null,{"$f":"SUM(H57+H61+H65+H69)","v":0},null,{"$f":"SUM(J57+J61+J65+J69)","v":0},null,{"$f":"SUM(L57+L61+L65+L69)","v":0},null,{"$f":"SUM(N57+N61+N65+N69)","v":0},null,{"$f":"SUM(P57+P61+P65+P69)","v":0},null,{"$f":"SUM(H73:P73)","v":0}]
[]
[]
[]
["Total Direct",null,null,null,null,null,null,{"$f":"SUM(H51+H72+H73)","v":0},null,{"$f":"SUM(J51+J72+J73)","v":0},null,{"$f":"SUM(L51+L72+L73)","v":0},null,{"$f":"SUM(N51+N72+N73)","v":0},null,{"$f":"SUM(P51+P72+P73)","v":0}]
["F&A Base",null,null,null,null,null,null,{"$f":"IF(H58>25000,\"25000\",H58)+IF(H62>25000,\"25000\",H62)+IF(H66>25000,\"25000\",H66)+IF(H70>25000,\"25000\",H70)+H22","v":0},null,{"$f":"IF(J58>25000,\"25000\",J58)+IF(J62>25000,\"25000\",J62)+IF(J66>25000,\"25000\",J66)+IF(J70>25000,\"25000\",J70)+J22","v":0},null,{"$f":"IF(L58>25000,\"25000\",L58)+IF(L62>25000,\"25000\",L62)+IF(L66>25000,\"25000\",L66)+IF(L70>25000,\"25000\",L70)+L22","v":0},null,{"$f":"IF(N58>25000,\"25000\",N58)+IF(N62>25000,\"25000\",N62)+IF(N66>25000,\"25000\",N66)+IF(N70>25000,\"25000\",N70)+N22","v":0},null,{"$f":"IF(P58>25000,\"25000\",P58)+IF(P62>25000,\"25000\",P62)+IF(P66>25000,\"25000\",P66)+IF(P70>25000,\"25000\",P70)+P22","v":0}]
["Total F&A",null,null,null,null,null,null,{"$f":"ROUND(+H78*FA,0)","v":0},null,{"$f":"ROUND(+J78*FA,0)","v":0},null,{"$f":"ROUND(+L78*FA,0)","v":0},null,{"$f":"ROUND(+N78*FA,0)","v":0},null,{"$f":"ROUND(+P78*FA,0)","v":0}]
["Total Costs",null,null,null,null,null,null,{"$f":"SUM(H77+H79)","v":0},null,{"$f":"SUM(J77+J79)","v":0},null,{"$f":"SUM(L77+L79)","v":0},null,{"$f":"SUM(N77+N79)","v":0},null,{"$f":"SUM(P77+P79)","v":0}]
[null,null,"This is your Modular Amount > > >"]
[null,null,null,null,null,null,null,{"$f":"+H51+H72","v":0},null,{"$f":"+J51+J72","v":0},null,{"$f":"+L51+L72","v":0},null,{"$f":"+N51+N72","v":0},null,{"$f":"+P51+P72","v":0}]
[{"$f":"term","v":1},"-Year Totals"]
["Project Direct total",null,{"$f":"SUM(H77+J77+L77+N77+P77)","v":0}]
["Project F&A base",null,{"$f":"SUM(H78+J78+L78+N78+P78)","v":0}]
["Project F&A total",null,{"$f":"SUM(H79+J79+L79+N79+P79)","v":0}]
["Project Total Cost",null,{"$f":"(C84+C86)","v":0}]

{"sheet":"Mod Budget Form","index":2,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[[4,0,5,12],[9,9,9,10],[8,11,8,12],[6,11,6,12],[7,11,7,12],[9,11,9,12],[7,5,7,6],[7,7,7,8],[9,1,9,2],[9,3,9,4],[1,8,1,10],[10,3,10,4],[10,7,10,8],[10,5,10,6],[6,9,6,10],[10,9,10,10],[1,1,1,7],[6,1,6,2],[10,1,10,2],[3,0,3,12],[7,1,7,2],[7,3,7,4],[7,9,7,10],[8,1,8,2],[8,3,8,4],[8,5,8,6],[56,8,56,12],[6,3,6,4],[6,5,6,6],[6,7,6,8],[10,11,10,12],[9,5,9,6],[9,7,9,8],[13,0,32,12],[35,0,48,12],[7,0,8,0],[8,7,8,8],[8,9,8,10]]}
[]
[null,"Principal Investigator/Program Director (Last, First, Middle):",null,null,null,null,null,null,{"$f":"'Base Budget'!B15 & \"\"","v":""}]
[]
["BUDGET JUSTIFICATION PAGE"]
["MODULAR RESEARCH GRANT APPLICATION"]
[]
[null,"Initial Period ",null,"2nd",null,"3rd",null,"4th",null,"5th",null,"Sum Total (For Entire Project Period)"]
["DC less Consortium F&A",{"$f":"+'Base Budget'!H51+'Base Budget'!H72","v":0},null,{"$f":"+'Base Budget'!J51+'Base Budget'!J72","v":0},null,{"$f":"+'Base Budget'!L51+'Base Budget'!L72","v":0},null,{"$f":"+'Base Budget'!N51+'Base Budget'!N72","v":0},null,{"$f":"+'Base Budget'!P51+'Base Budget'!P72","v":0},null,{"$f":"SUM(B8:K8)","v":0}]
[null,"(Item 7a, Face Page)",null,null,null,null,null,null,null,null,null,"(Item 8a, Face Page)"]
["Consortium F&A",{"$f":"+'Base Budget'!H73","v":0},null,{"$f":"+'Base Budget'!J73","v":0},null,{"$f":"+'Base Budget'!L73","v":0},null,{"$f":"+'Base Budget'!N73","v":0},null,{"$f":"+'Base Budget'!P73","v":0},null,{"$f":"SUM(B10:K10)","v":0}]
["Total Direct Costs",{"$f":"SUM(B8:C10)","v":0},null,{"$f":"SUM(D8:E10)","v":0},null,{"$f":"SUM(F8:G10)","v":0},null,{"$f":"SUM(H8:I10)","v":0},null,{"$f":"SUM(J8:K10)","v":0},null,{"$f":"SUM(B11:K11)","v":0}]
[]
["Personnel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Consortium"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Fixed Fee (SBIR/STTR Only)"]
[]
[]
[]
[]
[]
["PHS 398 (Rev. 04/06)",null,null,null,null,"Page",null,null,"Modular Budget Format Page"]

{"sheet":"Checklist","index":3,"n_rows":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[[36,5,36,6],[36,9,36,10],[0,9,0,11],[7,10,8,10],[14,8,14,10],[35,5,35,6],[35,9,35,10],[37,5,37,6],[37,9,37,10],[38,5,38,6],[38,9,38,10],[39,5,39,6],[39,9,39,10]]}
[null,null,null,null,null,null,"Program Director/Principal Investigator (Last, First, Middle):",null,null,{"$f":"'Base Budget'!B15 & \"\"","v":""}]
["CHECKLIST "]
[" TYPE OF APPLICATION (Check all that apply.)",null,null,null,null," "]
[null," NEW application.  (This application is being submitted to the PHS for the first time.)"]
[" "," RESUBMISSION of application number:",null,null,null," "]
[null," (This application replaces a prior unfunded version of a new, renewal, or revision application.)"]
[null," RENEWAL of grant number:"]
[null," (This application is to extend a funded grant beyond its current project period.)"]
[" ",null,null,null,null,null,null,null,null," "]
[" ","  REVISION to grant number:",null,null,null," ",null,null,null," "]
[null,"  (This application is for additional funds to supplement a currently funded grant.)"]
[" ","  CHANGE of program director/principal investigator.",null,null,null,null,null,null,null,null," "]
[null,"  Name of former program director/principal investigator:",null,null,null,null," "]
[" ","  CHANGE of Grantee Institution.     Name of former institution:",null,null,null,null,null,null,null,null," "]
[" ","  FOREIGN application ",null,"       Domestic Grant with foreign involvement",null,null,null,null,"List Country(ies) Involved:"]
["INVENTIONS AND PATENTS (Renewal appl. only)",null,null,null,null,"       No","      Yes"]
[null,null,null,null,null,null,"   If \"Yes,\" ",null,"Previously reported",null,null,null,null,null,"Not previously reported                             "]
["1. PROGRAM INCOME (See instructions.)"]
["All applications must indicate whether program income is anticipated during the period(s) for which grant support is requested.  If program income is",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["anticipated, use the format below to reflect the amount and source(s)."]
["                 Budget Period",null,null,"                                    Anticipated Amount",null,null,null,null,null,null,"                              Source(s)",null,null,null,null,null," "]
[null,"N/A",null,null,"N/A",null,null,null,null,null,"N/A"]
[]
[]
[]
["2.  ASSURANCES/CERTIFICATIONS (See instructions.)"]
["In signing the application Face Page, the authorized organizational representative agrees to comply with the policies, assurances and/or certifications"]
["listed in the application instructions when applicable. Descriptions of individual assurances/certifications are provided in Part III and listed in Part I, 4.1 "]
["under item 14.  If unable to certify compliance, where applicable, provide an explanation and place it after this page."]
["3. FACILITIES AND ADMINISTRATIVE COSTS (F&A)/ INDIRECT COSTS. See specific instructions."]
["x","  DHHS Agreement dated:",null,null,"2012-11-27",null,null," ",null,"      No Facilities And Administrative Costs Requested."]
[" ","  DHHS Agreement being negotiated with",null,null,null," "," ",null,null,null,"       Regional Office."]
[" ","  No DHHS Agreement, but rate established with",null,null,null," ",null,null,null,null,"       Date"]
[]
["CALCULATION*  (The entire grant application, including the Checklist, will be reproduced and provided to peer reviewers as confidential information.)"]
[" a.  Initial budget period:",null,null,null,"Amount of base   $    ",0,null," x Rate applied",null,{"$f":"FA","v":0.5},null," % = F&A costs",null,"$    ",0]
[" b.  02 year",null,null,null,"Amount of base   $    ",0,null," x Rate applied",null,{"$f":"FA","v":0.5},null," % = F&A costs",null,"$    ",0]
[" c.  03 year",null,null,null,"Amount of base   $    ",0,null," x Rate applied",null,{"$f":"FA","v":0.5},null," % = F&A costs",null,"$    ",0]
[" d.  04 year",null,null,null,"Amount of base   $    ",0,null," x Rate applied",null,{"$f":"FA","v":0.5},null," % = F&A costs",null,"$    ",0]
[" e.  05 year",null,null,null,"Amount of base   $    ",0,null," x Rate applied",null,{"$f":"FA","v":0.5},null," % = F&A costs",null,"$    ",0]
[null,null,null,null,"Enter Rate above as a decimal (e.g., 0.25 for 25%, 0.495 ",null,null,null,null,null,null," TOTAL F&A Costs",null,"$    ",0]
["*Check appropriate box(es):",null,null,null,"for 49.5%"]
[" ","  Salary and wages base",null,null,"X     ","Modified total direct cost base",null,null,null," ","                 Other base (Explain)"]
[" ","  Off-site, other special rate, or more than one rate involved (Explain)"]
["Explanation (Attach separate sheet, if necessary.):"]
[]
[]
[]
[]
["4. DISCLOSURE PERMISSION STATEMENT: If this application does not result in an award, is the Government permitted to disclose the title of "]
["your proposed project, and the name, address, telephone number and e-mail address of the official signing for the applicant organization, to "]
["organizations that may be interested in contacting you for further information (e.g., possible collaborations, investment)?",null,null,null,null,null,null,null,null,null,null,null,null,"    Yes","No           "]
["PHS 398 (Rev.  6/09)",null,null,null,null,null," Page",null,null,null,null,null,null,null,"Checklist Form Page"]

{"sheet":"Tuition","index":4,"n_rows":158,"n_cols":19,"rows_kept":158,"cut":false,"hidden":false,"merged":[[99,8,99,16],[129,8,129,16],[52,0,56,0],[52,2,52,3],[54,2,54,3],[56,2,56,3],[58,0,62,0],[58,2,58,3],[60,2,60,3],[62,2,62,3],[32,0,36,0],[32,2,32,3],[34,2,34,3],[36,2,36,3],[66,2,66,8],[38,0,42,0],[38,2,38,3],[40,2,40,3],[42,2,42,3],[45,2,45,5],[46,2,46,5],[47,2,47,5],[50,2,50,7],[2,2,2,8],[5,2,5,5],[6,2,6,5],[7,2,7,5],[10,2,10,7],[27,2,27,5],[30,2,30,7],[12,0,16,0],[12,2,12,3],[14,2,14,3],[16,2,16,3],[26,2,26,5],[18,0,22,0],[18,2,18,3],[20,2,20,3],[22,2,22,3],[25,2,25,5]]}
[null,null,"           Tuition Costs",null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,null,null,null,null,null,null,null,null,null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested"]
[]
[]
[8,null,"Graduate Student Tuition (most Majors)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF(I6=\"1/2-time\",K7,K8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",M7,M8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",O7,O8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",Q7,Q8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",S7,S8),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C13*VLOOKUP(K13,$I$73:$Q$99,5,FALSE)+C15*VLOOKUP(K15,$I$73:$Q$99,5,FALSE)+C17*VLOOKUP(K17,$I$73:$Q$99,5,FALSE)+C19*VLOOKUP(K19,$I$73:$Q$99,9,FALSE)+C21*VLOOKUP(K21,$I$73:$Q$99,9,FALSE)+C23*VLOOKUP(K23,$I$73:$Q$99,9,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$73:$Q$99,5,FALSE)+E15*VLOOKUP(M15,$I$73:$Q$99,5,FALSE)+E17*VLOOKUP(M17,$I$73:$Q$99,5,FALSE)+E19*VLOOKUP(M19,$I$73:$Q$99,9,FALSE)+E21*VLOOKUP(M21,$I$73:$Q$99,9,FALSE)+E23*VLOOKUP(M23,$I$73:$Q$99,9,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$73:$Q$99,5,FALSE)+F15*VLOOKUP(O15,$I$73:$Q$99,5,FALSE)+F17*VLOOKUP(O17,$I$73:$Q$99,5,FALSE)+F19*VLOOKUP(O19,$I$73:$Q$99,9,FALSE)+F21*VLOOKUP(O21,$I$73:$Q$99,9,FALSE)+F23*VLOOKUP(O23,$I$73:$Q$99,9,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$73:$Q$99,5,FALSE)+G15*VLOOKUP(Q15,$I$73:$Q$99,5,FALSE)+G17*VLOOKUP(Q17,$I$73:$Q$99,5,FALSE)+G19*VLOOKUP(Q19,$I$73:$Q$99,9,FALSE)+G21*VLOOKUP(Q21,$I$73:$Q$99,9,FALSE)+G23*VLOOKUP(Q23,$I$73:$Q$99,9,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$73:$Q$99,5,FALSE)+H15*VLOOKUP(S15,$I$73:$Q$99,5,FALSE)+H17*VLOOKUP(S17,$I$73:$Q$99,5,FALSE)+H19*VLOOKUP(S19,$I$73:$Q$99,9,FALSE)+H21*VLOOKUP(S21,$I$73:$Q$99,9,FALSE)+H23*VLOOKUP(S23,$I$73:$Q$99,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C13*VLOOKUP(K13,$I$73:$Q$99,3,FALSE)+C15*VLOOKUP(K15,$I$73:$Q$99,3,FALSE)+C17*VLOOKUP(K17,$I$73:$Q$99,3,FALSE)+C19*VLOOKUP(K19,$I$73:$Q$99,7,FALSE)+C21*VLOOKUP(K21,$I$73:$Q$99,7,FALSE)+C23*VLOOKUP(K23,$I$73:$Q$99,7,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$73:$Q$99,3,FALSE)+E15*VLOOKUP(M15,$I$73:$Q$99,3,FALSE)+E17*VLOOKUP(M17,$I$73:$Q$99,3,FALSE)+E19*VLOOKUP(M19,$I$73:$Q$99,7,FALSE)+E21*VLOOKUP(M21,$I$73:$Q$99,7,FALSE)+E23*VLOOKUP(M23,$I$73:$Q$99,7,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$73:$Q$99,3,FALSE)+F15*VLOOKUP(O15,$I$73:$Q$99,3,FALSE)+F17*VLOOKUP(O17,$I$73:$Q$99,3,FALSE)+F19*VLOOKUP(O19,$I$73:$Q$99,7,FALSE)+F21*VLOOKUP(O21,$I$73:$Q$99,7,FALSE)+F23*VLOOKUP(O23,$I$73:$Q$99,7,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$73:$Q$99,3,FALSE)+G15*VLOOKUP(Q15,$I$73:$Q$99,3,FALSE)+G17*VLOOKUP(Q17,$I$73:$Q$99,3,FALSE)+G19*VLOOKUP(Q19,$I$73:$Q$99,7,FALSE)+G21*VLOOKUP(Q21,$I$73:$Q$99,7,FALSE)+G23*VLOOKUP(Q23,$I$73:$Q$99,7,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$73:$Q$99,3,FALSE)+H15*VLOOKUP(S15,$I$73:$Q$99,3,FALSE)+H17*VLOOKUP(S17,$I$73:$Q$99,3,FALSE)+H19*VLOOKUP(S19,$I$73:$Q$99,7,FALSE)+H21*VLOOKUP(S21,$I$73:$Q$99,7,FALSE)+H23*VLOOKUP(S23,$I$73:$Q$99,7,FALSE)","v":0}]
[]
[]
[null,null,"Graduate Student Tuition (most majors)"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,0,0,0,0,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[]
[]
[8,null,"Graduate Student Tuition (Engineering & Architecture)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I$26=\"1/2-time\",K27,K28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",M27,M28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",O27,O28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",Q27,Q28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",S27,S28),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C33*VLOOKUP(K33,$I$103:$Q$129,5,FALSE)+C35*VLOOKUP(K35,$I$103:$Q$129,5,FALSE)+C37*VLOOKUP(K37,$I$103:$Q$129,5,FALSE)+C39*VLOOKUP(K39,$I$103:$Q$129,9,FALSE)+C41*VLOOKUP(K41,$I$103:$Q$129,9,FALSE)+C43*VLOOKUP(K43,$I$103:$Q$129,9,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$103:$Q$129,5,FALSE)+E35*VLOOKUP(M35,$I$103:$Q$129,5,FALSE)+E37*VLOOKUP(M37,$I$103:$Q$129,5,FALSE)+E39*VLOOKUP(M39,$I$103:$Q$129,9,FALSE)+E41*VLOOKUP(M41,$I$103:$Q$129,9,FALSE)+E43*VLOOKUP(M43,$I$103:$Q$129,9,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$103:$Q$129,5,FALSE)+F35*VLOOKUP(O35,$I$103:$Q$129,5,FALSE)+F37*VLOOKUP(O37,$I$103:$Q$129,5,FALSE)+F39*VLOOKUP(O39,$I$103:$Q$129,9,FALSE)+F41*VLOOKUP(O41,$I$103:$Q$129,9,FALSE)+F43*VLOOKUP(O43,$I$103:$Q$129,9,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$103:$Q$129,5,FALSE)+G35*VLOOKUP(Q35,$I$103:$Q$129,5,FALSE)+G37*VLOOKUP(Q37,$I$103:$Q$129,5,FALSE)+G39*VLOOKUP(Q39,$I$103:$Q$129,9,FALSE)+G41*VLOOKUP(Q41,$I$103:$Q$129,9,FALSE)+G43*VLOOKUP(Q43,$I$103:$Q$129,9,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$103:$Q$129,5,FALSE)+H35*VLOOKUP(S35,$I$103:$Q$129,5,FALSE)+H37*VLOOKUP(S37,$I$103:$Q$129,5,FALSE)+H39*VLOOKUP(S39,$I$103:$Q$129,9,FALSE)+H41*VLOOKUP(S41,$I$103:$Q$129,9,FALSE)+H43*VLOOKUP(S43,$I$103:$Q$129,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C33*VLOOKUP(K33,$I$103:$Q$129,3,FALSE)+C35*VLOOKUP(K35,$I$103:$Q$129,3,FALSE)+C37*VLOOKUP(K37,$I$103:$Q$129,3,FALSE)+C39*VLOOKUP(K39,$I$103:$Q$129,7,FALSE)+C41*VLOOKUP(K41,$I$103:$Q$129,7,FALSE)+C43*VLOOKUP(K43,$I$103:$Q$129,7,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$103:$Q$129,3,FALSE)+E35*VLOOKUP(M35,$I$103:$Q$129,3,FALSE)+E37*VLOOKUP(M37,$I$103:$Q$129,3,FALSE)+E39*VLOOKUP(M39,$I$103:$Q$129,7,FALSE)+E41*VLOOKUP(M41,$I$103:$Q$129,7,FALSE)+E43*VLOOKUP(M43,$I$103:$Q$129,7,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$103:$Q$129,3,FALSE)+F35*VLOOKUP(O35,$I$103:$Q$129,3,FALSE)+F37*VLOOKUP(O37,$I$103:$Q$129,3,FALSE)+F39*VLOOKUP(O39,$I$103:$Q$129,7,FALSE)+F41*VLOOKUP(O41,$I$103:$Q$129,7,FALSE)+F43*VLOOKUP(O43,$I$103:$Q$129,7,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$103:$Q$129,3,FALSE)+G35*VLOOKUP(Q35,$I$103:$Q$129,3,FALSE)+G37*VLOOKUP(Q37,$I$103:$Q$129,3,FALSE)+G39*VLOOKUP(Q39,$I$103:$Q$129,7,FALSE)+G41*VLOOKUP(Q41,$I$103:$Q$129,7,FALSE)+G43*VLOOKUP(Q43,$I$103:$Q$129,7,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$103:$Q$129,3,FALSE)+H35*VLOOKUP(S35,$I$103:$Q$129,3,FALSE)+H37*VLOOKUP(S37,$I$103:$Q$129,3,FALSE)+H39*VLOOKUP(S39,$I$103:$Q$129,7,FALSE)+H41*VLOOKUP(S41,$I$103:$Q$129,7,FALSE)+H43*VLOOKUP(S43,$I$103:$Q$129,7,FALSE)","v":0}]
[]
[]
[null,null,"Engineering & Architecture Students Only"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[null,null,1]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,0,null,0,0,0,0,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,0,null,0,0,0,0,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[]
[]
[8,null,"Graduate Student Tuition (Business & STB)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I$46=\"1/2-time\",K47,K48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",M47,M48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",O47,O48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",Q47,Q48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",S47,S48),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C53*VLOOKUP(K53,$I$133:$Q$159,5,FALSE)+C55*VLOOKUP(K55,$I$133:$Q$159,5,FALSE)+C57*VLOOKUP(K57,$I$133:$Q$159,5,FALSE)+C59*VLOOKUP(K59,$I$133:$Q$159,9,FALSE)+C61*VLOOKUP(K61,$I$133:$Q$159,9,FALSE)+C63*VLOOKUP(K63,$I$133:$Q$159,9,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$133:$Q$159,5,FALSE)+E55*VLOOKUP(M55,$I$133:$Q$159,5,FALSE)+E57*VLOOKUP(M57,$I$133:$Q$159,5,FALSE)+E59*VLOOKUP(M59,$I$133:$Q$159,9,FALSE)+E61*VLOOKUP(M61,$I$133:$Q$159,9,FALSE)+E63*VLOOKUP(M63,$I$133:$Q$159,9,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$133:$Q$159,5,FALSE)+F55*VLOOKUP(O55,$I$133:$Q$159,5,FALSE)+F57*VLOOKUP(O57,$I$133:$Q$159,5,FALSE)+F59*VLOOKUP(O59,$I$133:$Q$159,9,FALSE)+F61*VLOOKUP(O61,$I$133:$Q$159,9,FALSE)+F63*VLOOKUP(O63,$I$133:$Q$159,9,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$133:$Q$159,5,FALSE)+G55*VLOOKUP(Q55,$I$133:$Q$159,5,FALSE)+G57*VLOOKUP(Q57,$I$133:$Q$159,5,FALSE)+G59*VLOOKUP(Q59,$I$133:$Q$159,9,FALSE)+G61*VLOOKUP(Q61,$I$133:$Q$159,9,FALSE)+G63*VLOOKUP(Q63,$I$133:$Q$159,9,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$133:$Q$159,5,FALSE)+H55*VLOOKUP(S55,$I$133:$Q$159,5,FALSE)+H57*VLOOKUP(S57,$I$133:$Q$159,5,FALSE)+H59*VLOOKUP(S59,$I$133:$Q$159,9,FALSE)+H61*VLOOKUP(S61,$I$133:$Q$159,9,FALSE)+H63*VLOOKUP(S63,$I$133:$Q$159,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C53*VLOOKUP(K53,$I$133:$Q$159,3,FALSE)+C55*VLOOKUP(K55,$I$133:$Q$159,3,FALSE)+C57*VLOOKUP(K57,$I$133:$Q$159,3,FALSE)+C59*VLOOKUP(K59,$I$133:$Q$159,7,FALSE)+C61*VLOOKUP(K61,$I$133:$Q$159,7,FALSE)+C63*VLOOKUP(K63,$I$133:$Q$159,7,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$133:$Q$159,3,FALSE)+E55*VLOOKUP(M55,$I$133:$Q$159,3,FALSE)+E57*VLOOKUP(M57,$I$133:$Q$159,3,FALSE)+E59*VLOOKUP(M59,$I$133:$Q$159,7,FALSE)+E61*VLOOKUP(M61,$I$133:$Q$159,7,FALSE)+E63*VLOOKUP(M63,$I$133:$Q$159,7,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$133:$Q$159,3,FALSE)+F55*VLOOKUP(O55,$I$133:$Q$159,3,FALSE)+F57*VLOOKUP(O57,$I$133:$Q$159,3,FALSE)+F59*VLOOKUP(O59,$I$133:$Q$159,7,FALSE)+F61*VLOOKUP(O61,$I$133:$Q$159,7,FALSE)+F63*VLOOKUP(O63,$I$133:$Q$159,7,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$133:$Q$159,3,FALSE)+G55*VLOOKUP(Q55,$I$133:$Q$159,3,FALSE)+G57*VLOOKUP(Q57,$I$133:$Q$159,3,FALSE)+G59*VLOOKUP(Q59,$I$133:$Q$159,7,FALSE)+G61*VLOOKUP(Q61,$I$133:$Q$159,7,FALSE)+G63*VLOOKUP(Q63,$I$133:$Q$159,7,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$133:$Q$159,3,FALSE)+H55*VLOOKUP(S55,$I$133:$Q$159,3,FALSE)+H57*VLOOKUP(S57,$I$133:$Q$159,3,FALSE)+H59*VLOOKUP(S59,$I$133:$Q$159,7,FALSE)+H61*VLOOKUP(S61,$I$133:$Q$159,7,FALSE)+H63*VLOOKUP(S63,$I$133:$Q$159,7,FALSE)","v":0}]
[]
[]
[null,null,"Business and STB Students Only"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[null,null,1]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max",null,"esc. Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.042]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/4-time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2-time"]
[null,null,null,null,null,null,null,null,"Fall 2014",null,999,null,1998,null,1998,null,3995]
[null,null,null,null,null,null,null,null,"Fall 2015",null,{"$f":"K73*$S$70","v":1040.9580000000001},null,{"$f":"M73*$S$70","v":2081.9160000000002},null,{"$f":"O73*$S$70","v":2081.9160000000002},null,{"$f":"Q73*$S$70","v":4162.79}]
[null,null,null,null,null,null,null,null,"Fall 2016",null,{"$f":"K74*$S$70","v":1084.6782360000002},null,2169.3564720000004,null,2169.3564720000004,null,4337.6271800000004]
[null,null,null,null,null,null,null,null,"Fall 2017",null,1130.2347219120002,null,2260.4694438240003,null,2260.4694438240003,null,4519.8075215600002]
[null,null,null,null,null,null,null,null,"Fall 2018",null,1177.7045802323041,null,2355.4091604646082,null,2355.4091604646082,null,4709.6394374655201]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1227.1681726020608,null,2454.3363452041217,null,2454.3363452041217,null,4907.4442938390721]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1278.7092358513476,null,2557.4184717026951,null,2557.4184717026951,null,5113.5569541803134]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1332.4150237571041,null,2664.8300475142082,null,2664.8300475142082,null,5328.3263462558871]
[]
[null,null,null,null,null,null,null,null,"Spring 2015",null,998.75,null,1998,null,1998,null,3995]
[null,null,null,null,null,null,null,null,"Spring 2016",null,{"$f":"K82*$S$70","v":1040.6975},null,{"$f":"M82*$S$70","v":2081.9160000000002},null,{"$f":"O82*$S$70","v":2081.9160000000002},null,{"$f":"Q82*$S$70","v":4162.79}]
[null,null,null,null,null,null,null,null,"Spring 2017",null,1084.4067950000001,null,2169.3564720000004,null,2169.3564720000004,null,4337.6271800000004]
[null,null,null,null,null,null,null,null,"Spring 2018",null,1129.95188039,null,2260.4694438240003,null,2260.4694438240003,null,4519.8075215600002]
[null,null,null,null,null,null,null,null,"Spring 2019",null,1177.40985936638,null,2355.4091604646082,null,2355.4091604646082,null,4709.6394374655201]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1226.861073459768,null,2454.3363452041217,null,2454.3363452041217,null,4907.4442938390721]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1278.3892385450783,null,2557.4184717026951,null,2557.4184717026951,null,5113.5569541803134]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1332.0815865639718,null,2664.8300475142082,null,2664.8300475142082,null,5328.3263462558871]
[]
[null,null,null,null,null,null,null,null,"Summer 2014",null,555,null,1110,null,1110,null,2220]
[null,null,null,null,null,null,null,null,"Summer 2015",null,{"$f":"K91*$S$70","v":578.31000000000006},null,{"$f":"M91*$S$70","v":1156.6200000000001},null,{"$f":"O91*$S$70","v":1156.6200000000001},null,{"$f":"Q91*$S$70","v":2313.2400000000002}]
[null,null,null,null,null,null,null,null,"Summer 2016",null,602.59902000000011,null,1205.1980400000002,null,1205.1980400000002,null,2410.3960800000004]
[null,null,null,null,null,null,null,null,"Summer 2017",null,627.90817884000012,null,1255.8163576800002,null,1255.8163576800002,null,2511.6327153600005]
[null,null,null,null,null,null,null,null,"Summer 2018",null,654.28032235128012,null,1308.5606447025602,null,1308.5606447025602,null,2617.1212894051205]
[null,null,null,null,null,null,null,null,"Summer 2019",null,681.76009589003388,null,1363.5201917800678,null,1363.5201917800678,null,2727.0403835601355]
[null,null,null,null,null,null,null,null,"Summer 2020",null,710.39401991741533,null,1420.7880398348307,null,1420.7880398348307,null,2841.5760796696613]
[null,null,null,null,null,null,null,null,"Summer 2021",null,740.23056875394684,null,1480.4611375078937,null,1480.4611375078937,null,2960.9222750157874]
[]
[null,null,null,null,null,null,null,null,"Engineering & Architecture students"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2014",null,1151.25,null,2302.5,null,2302.5,null,4605]
[null,null,null,null,null,null,null,null,"Fall 2015",null,{"$f":"K103*$S$70","v":1199.6025},null,{"$f":"M103*$S$70","v":2399.2049999999999},null,{"$f":"O103*$S$70","v":2399.2049999999999},null,{"$f":"Q103*$S$70","v":4798.41}]
[null,null,null,null,null,null,null,null,"Fall 2016",null,1249.985805,null,2499.9716100000001,null,2499.9716100000001,null,4999.9432200000001]
[null,null,null,null,null,null,null,null,"Fall 2017",null,1302.4852088100001,null,2604.9704176200003,null,2604.9704176200003,null,5209.9408352400005]
[null,null,null,null,null,null,null,null,"Fall 2018",null,1357.1895875800201,null,2714.3791751600402,null,2714.3791751600402,null,5428.7583503200804]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1414.1915502583811,null,2828.3831005167622,null,2828.3831005167622,null,5656.7662010335243]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1473.5875953692332,null,2947.1751907384664,null,2947.1751907384664,null,5894.3503814769329]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1535.478274374741,null,3070.956548749482,null,3070.956548749482,null,6141.9130974989639]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2015",null,1151.25,null,2302.5,null,2302.5,null,4605]
[null,null,null,null,null,null,null,null,"Spring 2016",null,{"$f":"K112*$S$70","v":1199.6025},null,{"$f":"M112*$S$70","v":2399.2049999999999},null,{"$f":"O112*$S$70","v":2399.2049999999999},null,{"$f":"Q112*$S$70","v":4798.41}]
[null,null,null,null,null,null,null,null,"Spring 2017",null,1249.985805,null,2499.9716100000001,null,2499.9716100000001,null,4999.9432200000001]
[null,null,null,null,null,null,null,null,"Spring 2018",null,1302.4852088100001,null,2604.9704176200003,null,2604.9704176200003,null,5209.9408352400005]
[null,null,null,null,null,null,null,null,"Spring 2019",null,1357.1895875800201,null,2714.3791751600402,null,2714.3791751600402,null,5428.7583503200804]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1414.1915502583811,null,2828.3831005167622,null,2828.3831005167622,null,5656.7662010335243]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1473.5875953692332,null,2947.1751907384664,null,2947.1751907384664,null,5894.3503814769329]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1535.478274374741,null,3070.956548749482,null,3070.956548749482,null,6141.9130974989639]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2014",null,640,null,1280,null,1280,null,2560]
[null,null,null,null,null,null,null,null,"Summer 2015",null,{"$f":"K121*$S$70","v":666.88},null,{"$f":"M121*$S$70","v":1333.76},null,{"$f":"O121*$S$70","v":1333.76},null,{"$f":"Q121*$S$70","v":2667.52}]
[null,null,null,null,null,null,null,null,"Summer 2016",null,694.88896,null,1389.77792,null,1389.77792,null,2779.55584]
[null,null,null,null,null,null,null,null,"Summer 2017",null,724.07429632000003,null,1448.1485926400001,null,1448.1485926400001,null,2896.2971852800001]
[null,null,null,null,null,null,null,null,"Summer 2018",null,754.48541676544005,null,1508.9708335308801,null,1508.9708335308801,null,3017.9416670617602]
[null,null,null,null,null,null,null,null,"Summer 2019",null,786.17380426958857,null,1572.3476085391771,null,1572.3476085391771,null,3144.6952170783543]
[null,null,null,null,null,null,null,null,"Summer 2020",null,819.19310404891132,null,1638.3862080978226,null,1638.3862080978226,null,3276.7724161956453]
[null,null,null,null,null,null,null,null,"Summer 2021",null,853.59921441896563,null,1707.1984288379313,null,1707.1984288379313,null,3414.3968576758625]
[]
[null,null,null,null,null,null,null,null,"Business & STB"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2014",null,1213,null,2425,null,2425,null,4850]
[null,null,null,null,null,null,null,null,"Fall 2015",null,{"$f":"K133*$S$70","v":1263.9460000000001},null,{"$f":"M133*$S$70","v":2526.85},null,{"$f":"O133*$S$70","v":2526.85},null,{"$f":"Q133*$S$70","v":5053.7}]
[null,null,null,null,null,null,null,null,"Fall 2016",null,1317.0317320000001,null,2632.9776999999999,null,2632.9776999999999,null,5265.9553999999998]
[null,null,null,null,null,null,null,null,"Fall 2017",null,1372.3470647440001,null,2743.5627634000002,null,2743.5627634000002,null,5487.1255268000004]
[null,null,null,null,null,null,null,null,"Fall 2018",null,1429.9856414632482,null,2858.7923994628004,null,2858.7923994628004,null,5717.5847989256008]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1490.0450384047047,null,2978.861680240238,null,2978.861680240238,null,5957.723360480476]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1552.6269300177023,null,3103.9738708103282,null,3103.9738708103282,null,6207.9477416206564]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1617.8372610784459,null,3234.3407733843619,null,3234.3407733843619,null,6468.6815467687238]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2015",null,1213,null,2425,null,2425,null,4850]
[null,null,null,null,null,null,null,null,"Spring 2016",null,{"$f":"K142*$S$70","v":1263.9460000000001},null,{"$f":"M142*$S$70","v":2526.85},null,{"$f":"O142*$S$70","v":2526.85},null,{"$f":"Q142*$S$70","v":5053.7}]
[null,null,null,null,null,null,null,null,"Spring 2017",null,1317.0317320000001,null,2632.9776999999999,null,2632.9776999999999,null,5265.9553999999998]
[null,null,null,null,null,null,null,null,"Spring 2018",null,1372.3470647440001,null,2743.5627634000002,null,2743.5627634000002,null,5487.1255268000004]
[null,null,null,null,null,null,null,null,"Spring 2019",null,1429.9856414632482,null,2858.7923994628004,null,2858.7923994628004,null,5717.5847989256008]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1490.0450384047047,null,2978.861680240238,null,2978.861680240238,null,5957.723360480476]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1552.6269300177023,null,3103.9738708103282,null,3103.9738708103282,null,6207.9477416206564]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1617.8372610784459,null,3234.3407733843619,null,3234.3407733843619,null,6468.6815467687238]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2014",null,674,null,1348,null,1348,null,2695]
[null,null,null,null,null,null,null,null,"Summer 2015",null,{"$f":"K151*$S$70","v":702.30799999999999},null,{"$f":"M151*$S$70","v":1404.616},null,{"$f":"O151*$S$70","v":1404.616},null,{"$f":"Q151*$S$70","v":2808.19}]
[null,null,null,null,null,null,null,null,"Summer 2016",null,731.804936,null,1463.609872,null,1463.609872,null,2926.1339800000001]
[null,null,null,null,null,null,null,null,"Summer 2017",null,762.54074331200002,null,1525.081486624,null,1525.081486624,null,3049.03160716]
[null,null,null,null,null,null,null,null,"Summer 2018",null,794.56745453110409,null,1589.1349090622082,null,1589.1349090622082,null,3177.09093466072]
[null,null,null,null,null,null,null,null,"Summer 2019",null,827.93928762141047,null,1655.8785752428209,null,1655.8785752428209,null,3310.5287539164706]
[null,null,null,null,null,null,null,null,"Summer 2020",null,862.7127377015097,null,1725.4254754030194,null,1725.4254754030194,null,3449.5709615809624]
[null,null,null,null,null,null,null,null,"Summer 2021",null,898.94667268497312,null,1797.8933453699462,null,1797.8933453699462,null,3594.4529419673631]

{"sheet":"BA Upload","index":5,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Sponsor:","NIH"]
["Title: "]
["PI Name: "]
["Period of Performance:"]
["GoldSheet Number:"]
["Account Number:"]
[]
["Budget Categories","Budget Code","Amount"]
["Salary/Hourly","0108",0]
["Payroll Benefits","0130",0]
["Equipment","0710",{"$f":"ROUND(SUM('Base Budget'!H33:P33),0)","v":0}]
["Travel Domestic","0215",0]
["Travel Foreign","0216",0]
["Student Tuition","0610",{"$f":"ROUND(SUM('Base Budget'!H38:P40),0)","v":0}]
["Supplies","0410",0]
["Subcontracts"]
["Subject to IDC","0396",{"$f":"ROUND('Base Budget'!U72,0)","v":0}]
["Not Subejct to IDC","0376",{"$f":"ROUND('Base Budget'!W72,0)","v":0}]
["Other Direct Costs"]
["Telecom Charges","0340",0]
["Computer Usage","0353",0]
["Printing/Copying","0373",0]
["Services/Honoraria","0302",0]
["Postage","0379",0]
["Other  ","0630",{"$f":"ROUND(SUM('Base Budget'!H22:P22)+SUM('Base Budget'!H47:P47),0)","v":0}]
["Total Direct Costs",null,{"$f":"SUM(C9:C25)","v":0}]
["Indirect Costs","0642",{"$f":"ROUND(SUM('Base Budget'!H79:P79),0)","v":0}]
["Total Costs",null,{"$f":"SUM(C26:C27)","v":0}]