{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cumulative","Budget","Control"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":50,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cumulative","index":0,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[0,4,0,5],[0,6,0,7],[1,4,1,5],[1,6,1,7],[2,4,2,5],[2,6,2,7]]}
[]
[null,null,null,null,"Period 1",null,"Total"]
[]
[null,null,null,null,"Sponsor","Cost Share","Sponsor","Cost Share"]

{"sheet":"Budget","index":1,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5]]}
[]
["Purdue University"]
[]
[]
[]
[]
[]
[null,null,null,null,"Period 1","Total"]
[]
["Role","Name","Appointment Type","Person Months"]
[null,null,null,null,null,{"$f":"SUMIFS(A11:F11,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[]
[]
["Total Salaries",null,null,null,{"$f":"SUM(E11:E13)","v":0},{"$f":"SUMIFS(A14:F14,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[]
["Fringes",null,null,"Rate"]
[null,null,null,null,{"$f":"(E11)*$D17","v":0},{"$f":"SUMIFS(A17:F17,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[]
["Total Fringes",null,null,null,{"$f":"SUM(E17:E18)","v":0},{"$f":"SUMIFS(A19:F19,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[]
["Total Salary & Wages",null,null,null,{"$f":"+E14+E19","v":0},{"$f":"SUMIFS(A21:F21,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[]
["Other Direct Costs"]
[]
["Cost Type","Description","Exclude From MTDC Base"]
[null,null,null,null,null,{"$f":"SUMIFS(A26:F26,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[]
["Subawards"]
[null,null,null,"Subaward 1",null,{"$f":"SUMIFS(A29:F29,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[null,null,null,"Subaward 2",null,{"$f":"SUMIFS(A30:F30,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[null,null,null,"Subaward 3",null,{"$f":"SUMIFS(A31:F31,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[null,null,null,"Subaward 4",null,{"$f":"SUMIFS(A32:F32,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[null,null,null,"Subaward 5",null,{"$f":"SUMIFS(A33:F33,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[]
["Subawards Direct Costs",null,{"$f":"IF($B39=\"Yes\",\"Y\",\"\")","v":""},null,{"$f":"SUM(E29:E33)","v":0},{"$f":"SUMIFS(A35:F35,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
["Subawards Indirect Costs",null,null,null,{"$f":"SUM(E44:E48)","v":0},{"$f":"SUMIFS(A36:F36,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
["Total Subaward Costs (including Indirects)",null,{"$f":"IF($B39=\"No\",\"Y\",\"\")","v":"Y"},null,{"$f":"SUM(E35:E36)","v":0},{"$f":"SUMIFS(A37:F37,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[null,"Is this an NIH Project?"]
["Total Other Direct Costs","No",null,null,{"$f":"IF($B39=\"Yes\",SUM(E26:E27,E35),SUM(E26:E27,E37))","v":0},{"$f":"SUMIFS(A39:F39,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[]
["Total Direct Costs",null,null,null,{"$f":"+E21+E39","v":0},{"$f":"SUMIFS(A41:F41,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
[null,null,null,"Rate"]
["Purdue Indirects",null,null,{"$f":"IF(OR($A52=\"Exclusive License Total\",$A52=\"IP Assignment Total\"),L56,VLOOKUP($A54,K:L,2,FALSE))","v":0.56999999999999995},{"$f":"E54*$D43","v":0},{"$f":"SUMIFS(A43:F43,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0}]
["Sub Indirects",null,null,{"$f":"D29","v":"Subaward 1"},null,0,null,null,null,null,"MTDC Base",0.56999999999999995]
[null,null,null,{"$f":"D30","v":"Subaward 2"},null,0,null,null,null,null,"TDC Base",0]
[null,null,null,"Subaward 3",null,0,null,null,null,null,"USDA Base",0.42857000000000001]
[null,null,null,"Subaward 4",null,0,null,null,null,null,"NIFA/AFRI",0.42857000000000001]
[null,null,null,"Subaward 5",null,0]
[]
["Total Costs",null,null,null,{"$f":"IF($B39=\"Yes\",E36+E41+E43,E41+E43)","v":0},{"$f":"SUMIFS(A50:F50,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0},null,null,null,null,"Basic Research Total",0]
["IP Fee",null,null,{"$f":"VLOOKUP(A52,K:L,2,FALSE)","v":0},{"$f":"$D51*E50","v":0},{"$f":"SUMIFS(A51:F51,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0},null,null,null,null,"CNERF Total",0.1]
["Basic Research Total",null,null,null,{"$f":"E50+E51","v":0},{"$f":"SUMIFS(A52:F52,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0},null,null,null,null,"Exclusive License Total",0.25]
[]
["MTDC Base",null,null,null,{"$f":"IF($A54=\"MTDC Base\",E41+E56-SUMIFS(E26:E37,$C26:$C37,\"Y\"),IF($A54=\"TDC Base\",E41,IF($A54=\"USDA Base\",(E41),IF($A54=\"NIFA/AFRI\",(E41-E37),\"\"))))","v":0},{"$f":"SUMIFS(A54:F54,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0},null,null,null,null,"IP Assignment Total",0.5]
[]
[null,null,null,"Subawards Base",{"$f":"SUM(E57:E61)","v":0},{"$f":"SUMIFS(A56:F56,A$8:F$8,\"<>\" & \"Total\",A$8:F$8,\"<>\" & \"\")","v":0},null,null,null,null,"Exclusive & IP F&A Rate",0.64070000000000005]
[null,null,null,{"$f":"D29","v":"Subaward 1"},{"$f":"IF(IF(SUM($D57:D57,E29,E44)>25000,25000-SUM($D57:D57),SUM(E29,E44))=0,\"\",IF(SUM($D57:D57,E29,E44)>25000,25000-SUM($D57:D57),SUM(E29,E44)))","v":""},0]
[null,null,null,{"$f":"D30","v":"Subaward 2"},{"$f":"IF(IF(SUM($D58:D58,E30,E45)>25000,25000-SUM($D58:D58),SUM(E30,E45))=0,\"\",IF(SUM($D58:D58,E30,E45)>25000,25000-SUM($D58:D58),SUM(E30,E45)))","v":""},0]
[null,null,null,"Subaward 3",{"$f":"IF(IF(SUM($D59:D59,E31,E46)>25000,25000-SUM($D59:D59),SUM(E31,E46))=0,\"\",IF(SUM($D59:D59,E31,E46)>25000,25000-SUM($D59:D59),SUM(E31,E46)))","v":""},0]
[null,null,null,"Subaward 4",{"$f":"IF(IF(SUM($D60:D60,E32,E47)>25000,25000-SUM($D60:D60),SUM(E32,E47))=0,\"\",IF(SUM($D60:D60,E32,E47)>25000,25000-SUM($D60:D60),SUM(E32,E47)))","v":""},0]
[null,null,null,"Subaward 5",{"$f":"IF(IF(SUM($D61:D61,E33,E48)>25000,25000-SUM($D61:D61),SUM(E33,E48))=0,\"\",IF(SUM($D61:D61,E33,E48)>25000,25000-SUM($D61:D61),SUM(E33,E48)))","v":""},0]

{"sheet":"Control","index":2,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,1,5,5],[12,1,13,5],[6,6,9,8],[14,6,17,8],[17,12,17,19]]}
[]
[]
[]
[]
[null,"Select Budget File(s) & Transfer"]
[null,null,null,null,null,null,null,null,null,null,null,"PROCESS:"]
[null,null,null,null,null,null,"Press button to select your budget file(s) and transfer data to the Budget Template",null,null,null,null,"Step 1: Select Transfer Budget Data on the left to import a PERA budget file to this Template."]
[null,null,null,null,null,null,null,null,null,null,null,null,"*File selected must be the standard PERA output in order to be compatible with this template"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Step 2: Make any necessary adjustments to the budgets in this file."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Step 3: Select Export Budget on the left to export a final version."]
[null,"Export Finished Budget",null,null,null,null,null,null,null,null,null,null,"*The exported file will be the final version. Further adjustments will need to be done in this Template file and re-exported."]
[null,null,null,null,null,null,null,null,null,null,null,null,"*For Multi-Sheet Budgets, you will have the option of adding a Cumulative Sheet that shows a Summary of all sheets."]
[null,null,null,null,null,null,"Press button after making adjustments to budget(s) to export a final version"]
[null,null,null,null,null,null,null,null,null,null,null,null,"When closing this file, you will be asked if you would like to make a working version of your current budget."]
[null,null,null,null,null,null,null,null,null,null,null,null,"This working version can be kept for potential future adjustments and re-export."]
[null,null,null,null,null,null,null,null,null,null,null,null,"**If you do not create a working version, the budgets in this file will be deleted"]