{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Intro","Budget","Subrecipient","% Effort Conversion","Cayuse Budget","Validation Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":226,"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":"Intro","index":0,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"MACROS MUST BE ENABLED!!!!!!!",null,"Updated"]
[null,null,null,{"$f":"NOW()","v":"2018-11-20T12:22:14.470"}]
[]
["Yellow cells:","Data entry is allowed in yellow cells."]
["White Cells:","Do not enter data in white cells, or the underlying formulas will be erased."]
[]
["Budget periods:","The budget periods will use the Project Start and End Dates and assume that the periods are for 12 months."]
[]
["Exception to Yellow Cells:","The date fields for the periods have formulas that estimate what a year would be."]
[null,"If those precalculated dates are wrong:"]
[null,"You may type in the dates manually which will overwrite any formula for that date."]
[null,"The number of months calculate from the dates, but you may overwrite."]
[]
[null,null,"Based on:"]
["Salary calculations:","12 month salary","Number of months for the budget period (default is 12)"]
[null,null,"Cost of living increase amount and starting period entered"]
[null,null,"Salary cap used is on Validation Data tab"]
[]
[null,"9 month appt.","Budget period covers the 9 months"]
[null,null,"Cost of living increase amount and starting period"]
[]
[null,"Summer","If salary is entered into the 9 month appointment, the Summer is automatic."]
[null,null,"Cost of living increase amount and starting period"]
[]
[null,"All 3 salary lines are summed for the fringe benefits, so either use the 12 month salary or the 9 month + Summer."]
[null,"The salary is not calculated if the effort is 0."]
[]
["% Effort Conversion:","Use this worksheet to calculate the % effort and Person Months."]
[]
[]
["Subrecipients:","Use the Subrecipient button on the budget tab to add subrecipients."]
[null,"Be sure to use the button on the subrecipient tab to copy the information back to the budget tab."]
[]
[null,"DO NOT DELETE ANY ROWS OR COLUMNS MANUALLY - CALCULATIONS WILL BE WRONG."]
[null,"Use the ADD buttons to add."]

{"sheet":"Budget","index":1,"n_rows":138,"n_cols":18,"rows_kept":138,"cut":false,"hidden":false,"merged":[[82,1,83,1],[90,5,90,6],[0,1,0,4],[1,2,1,5],[2,2,2,5],[3,2,3,5],[13,2,13,4],[80,4,80,6],[87,4,87,6],[76,5,76,6],[65,4,65,6],[70,5,70,6],[17,17,21,17],[22,4,22,6],[22,17,23,17],[50,4,50,6],[63,4,63,6],[17,2,19,5],[31,2,31,3],[24,2,24,3],[52,2,52,3],[134,5,134,6],[107,4,107,6],[94,4,94,6],[89,5,89,6],[132,2,132,3]]}
[null,"This section must be completed first."]
[null,"PI:"]
[null,"Title:"]
[null,"Agency:"]
[]
[null,"Project Start Date:",null,"Project End Date:"]
[]
[null,null,null,null,null,"Number of budget periods:",null,"(Range 1-10)"]
[null,"Project Location:",null,null,null,"Cost of living increase (%):",null,"(Range 0-10%)"]
[null,"IDC Type:",null,null,null,"Cost of living increase starts on Budget Period number:",null,"(Range 1-10)"]
[null,"IDC Rate:"]
[]
[null,"Cayuse Proposal Number:"]
[null,"Preparer:"]
[null,"Budget Prepared Date:"]
[]
[]
[null,null,"Internal Budget",null,null,null,null,"Period",null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,"Start Date:",{"$f":"IF(C6<>\"\",C6,\"\")","v":""},{"$f":"IF($G$8>=I19,H21+1,\"\")","v":""},"","","","","","","",""]
[null,null,null,null,null,null,"End Date:",{"$f":"IF($G8=H$19,$E$6,IF(H$19>$G8,\"\",(IF(YEAR(H20=\"2020\"),H20+364,IF(YEAR(H20=\"2024\"),H20+364,H20+365)))))","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,"*# Months",{"$f":"IF(H20<>\"\",IF(H21<>\"\",ROUND((DATEDIF(H20,H21,\"d\")/30),0),0),0)","v":0},0,{"$f":"IF(J20<>\"\",IF(J21<>\"\",ROUND((DATEDIF(J20,J21,\"d\")/30),0),0),0)","v":0},{"$f":"IF(K20<>\"\",IF(K21<>\"\",ROUND((DATEDIF(K20,K21,\"d\")/30),0),0),0)","v":0},0,0,0,0,0,0]
[null,"Salary and Wages"]
[null,"Project Role:","Name:",null,"Appointment:","Base Salary:","% Effort:"]
[null,"Principal Investigator",null,null,"12 Month Appt.",null,null,{"$f":"IF(G25<>0,IF($G$8=0,0,IF($G25=0,0,IF(ColStart>H$19,(IF($F25>SalaryCap,(SalaryCap*$G25/100*(H$22/12)),$F25*$G25/100*(H$22/12))),IF(($F25*(1+(COL))^(H$19-ColStart+1))>SalaryCap,(SalaryCap*$G25/100*(H$22/12)),($F25*$G25/100*(H$22/12))*(1+(COL))^(H$19-ColStart+1))))),0)","v":0},{"$f":"IF(G25<>0,IF($G$8<2,0,IF($G25=0,0,IF(ColStart>I$19,(IF($F25>SalaryCap,(SalaryCap*$G25/100*(I$22/12)),$F25*$G25/100*(I$22/12))),IF(($F25*(1+(COL))^(I$19-ColStart+1))>SalaryCap,(SalaryCap*$G25/100*(I$22/12)),($F25*$G25/100*(I$22/12))*(1+(COL))^(I$19-ColStart+1))))),0)","v":0},{"$f":"IF(G25<>0,IF($G$8<3,0,IF($G25=0,0,IF(ColStart>J$19,(IF($F25>SalaryCap,(SalaryCap*$G25/100*(J$22/12)),$F25*$G25/100*(J$22/12))),IF(($F25*(1+(COL))^(J$19-ColStart+1))>SalaryCap,(SalaryCap*$G25/100*(J$22/12)),($F25*$G25/100*(J$22/12))*(1+(COL))^(J$19-ColStart+1))))),0)","v":0},{"$f":"IF(G25<>0,IF($G$8<4,0,IF($G25=0,0,IF(ColStart>K$19,(IF($F25>SalaryCap,(SalaryCap*$G25/100*(K$22/12)),$F25*$G25/100*(K$22/12))),IF(($F25*(1+(COL))^(K$19-ColStart+1))>SalaryCap,(SalaryCap*$G25/100*(K$22/12)),($F25*$G25/100*(K$22/12))*(1+(COL))^(K$19-ColStart+1))))),0)","v":0},{"$f":"IF(G25<>0,IF($G$8<5,0,IF($G25=0,0,IF(ColStart>L$19,(IF($F25>SalaryCap,(SalaryCap*$G25/100*(L$22/12)),$F25*$G25/100*(L$22/12))),IF(($F25*(1+(COL))^(L$19-ColStart+1))>SalaryCap,(SalaryCap*$G25/100*(L$22/12)),($F25*$G25/100*(L$22/12))*(1+(COL))^(L$19-ColStart+1))))),0)","v":0},{"$f":"IF(G25<>0,IF($G$8<6,0,IF($G25=0,0,IF(ColStart>M$19,(IF($F25>SalaryCap,(SalaryCap*$G25/100*(M$22/12)),$F25*$G25/100*(M$22/12))),IF(($F25*(1+(COL))^(M$19-ColStart+1))>SalaryCap,(SalaryCap*$G25/100*(M$22/12)),($F25*$G25/100*(M$22/12))*(1+(COL))^(M$19-ColStart+1))))),0)","v":0},{"$f":"IF(G25<>0,IF($G$8<7,0,IF($G25=0,0,IF(ColStart>N$19,(IF($F25>SalaryCap,(SalaryCap*$G25/100*(N$22/12)),$F25*$G25/100*(N$22/12))),IF(($F25*(1+(COL))^(N$19-ColStart+1))>SalaryCap,(SalaryCap*$G25/100*(N$22/12)),($F25*$G25/100*(N$22/12))*(1+(COL))^(N$19-ColStart+1))))),0)","v":0},{"$f":"IF(G25<>0,IF($G$8<8,0,IF($G25=0,0,IF(ColStart>O$19,(IF($F25>SalaryCap,(SalaryCap*$G25/100*(O$22/12)),$F25*$G25/100*(O$22/12))),IF(($F25*(1+(COL))^(O$19-ColStart+1))>SalaryCap,(SalaryCap*$G25/100*(O$22/12)),($F25*$G25/100*(O$22/12))*(1+(COL))^(O$19-ColStart+1))))),0)","v":0},{"$f":"IF(G25<>0,IF($G$8<9,0,IF($G25=0,0,IF(ColStart>P$19,(IF($F25>SalaryCap,(SalaryCap*$G25/100*(P$22/12)),$F25*$G25/100*(P$22/12))),IF(($F25*(1+(COL))^(P$19-ColStart+1))>SalaryCap,(SalaryCap*$G25/100*(P$22/12)),($F25*$G25/100*(P$22/12))*(1+(COL))^(P$19-ColStart+1))))),0)","v":0},{"$f":"IF(G25<>0,IF($G$8<10,0,IF($G25=0,0,IF(ColStart>Q$19,(IF($F25>SalaryCap,(SalaryCap*$G25/100*(Q$22/12)),$F25*$G25/100*(Q$22/12))),IF(($F25*(1+(COL))^(Q$19-ColStart+1))>SalaryCap,(SalaryCap*$G25/100*(Q$22/12)),($F25*$G25/100*(Q$22/12))*(1+(COL))^(Q$19-ColStart+1))))),0)","v":0},{"$f":"SUM(H25:Q25)","v":0}]
[null,null,null,null,"9 Month Academic Yr",0,null,{"$f":"IF(G26<>0,IF($G$8=0,0,IF($G26=0,0,IF(ColStart>H$19,(IF($F26>SalaryCap,(SalaryCap*$G26/100*((IF(H$22>9,9,H$22))/9)),$F26*$G26/100*((IF(H$22>9,9,H$22))/9))),IF(($F26*(1+(COL))^(H$19-ColStart+1))>SalaryCap,(SalaryCap*$G26/100*((IF(H$22>9,9,H$22))/9)),($F26*$G26/100*((IF(H$22>9,9,H$22))/9))*(1+(COL))^(H$19-ColStart+1))))),0)","v":0},{"$f":"IF(G26<>0,IF($G$8<2,0,IF($G26=0,0,IF(ColStart>I$19,(IF($F26>SalaryCap,(SalaryCap*$G26/100*((IF(I$22>9,9,I$22))/9)),$F26*$G26/100*((IF(I$22>9,9,I$22))/9))),IF(($F26*(1+(COL))^(I$19-ColStart+1))>SalaryCap,(SalaryCap*$G26/100*((IF(I$22>9,9,I$22))/9)),($F26*$G26/100*((IF(I$22>9,9,I$22))/9))*(1+(COL))^(I$19-ColStart+1))))),0)","v":0},{"$f":"IF(G26<>0,IF($G$8<3,0,IF($G26=0,0,IF(ColStart>J$19,(IF($F26>SalaryCap,(SalaryCap*$G26/100*((IF(J$22>9,9,J$22))/9)),$F26*$G26/100*((IF(J$22>9,9,J$22))/9))),IF(($F26*(1+(COL))^(J$19-ColStart+1))>SalaryCap,(SalaryCap*$G26/100*((IF(J$22>9,9,J$22))/9)),($F26*$G26/100*((IF(J$22>9,9,J$22))/9))*(1+(COL))^(J$19-ColStart+1))))),0)","v":0},{"$f":"IF(G26<>0,IF($G$8<4,0,IF($G26=0,0,IF(ColStart>K$19,(IF($F26>SalaryCap,(SalaryCap*$G26/100*((IF(K$22>9,9,K$22))/9)),$F26*$G26/100*((IF(K$22>9,9,K$22))/9))),IF(($F26*(1+(COL))^(K$19-ColStart+1))>SalaryCap,(SalaryCap*$G26/100*((IF(K$22>9,9,K$22))/9)),($F26*$G26/100*((IF(K$22>9,9,K$22))/9))*(1+(COL))^(K$19-ColStart+1))))),0)","v":0},{"$f":"IF(G26<>0,IF($G$8<5,0,IF($G26=0,0,IF(ColStart>L$19,(IF($F26>SalaryCap,(SalaryCap*$G26/100*((IF(L$22>9,9,L$22))/9)),$F26*$G26/100*((IF(L$22>9,9,L$22))/9))),IF(($F26*(1+(COL))^(L$19-ColStart+1))>SalaryCap,(SalaryCap*$G26/100*((IF(L$22>9,9,L$22))/9)),($F26*$G26/100*((IF(L$22>9,9,L$22))/9))*(1+(COL))^(L$19-ColStart+1))))),0)","v":0},{"$f":"IF(G26<>0,IF($G$8<6,0,IF($G26=0,0,IF(ColStart>M$19,(IF($F26>SalaryCap,(SalaryCap*$G26/100*((IF(M$22>9,9,M$22))/9)),$F26*$G26/100*((IF(M$22>9,9,M$22))/9))),IF(($F26*(1+(COL))^(M$19-ColStart+1))>SalaryCap,(SalaryCap*$G26/100*((IF(M$22>9,9,M$22))/9)),($F26*$G26/100*((IF(M$22>9,9,M$22))/9))*(1+(COL))^(M$19-ColStart+1))))),0)","v":0},{"$f":"IF(G26<>0,IF($G$8<7,0,IF($G26=0,0,IF(ColStart>N$19,(IF($F26>SalaryCap,(SalaryCap*$G26/100*((IF(N$22>9,9,N$22))/9)),$F26*$G26/100*((IF(N$22>9,9,N$22))/9))),IF(($F26*(1+(COL))^(N$19-ColStart+1))>SalaryCap,(SalaryCap*$G26/100*((IF(N$22>9,9,N$22))/9)),($F26*$G26/100*((IF(N$22>9,9,N$22))/9))*(1+(COL))^(N$19-ColStart+1))))),0)","v":0},{"$f":"IF(G26<>0,IF($G$8<8,0,IF($G26=0,0,IF(ColStart>O$19,(IF($F26>SalaryCap,(SalaryCap*$G26/100*((IF(O$22>9,9,O$22))/9)),$F26*$G26/100*((IF(O$22>9,9,O$22))/9))),IF(($F26*(1+(COL))^(O$19-ColStart+1))>SalaryCap,(SalaryCap*$G26/100*((IF(O$22>9,9,O$22))/9)),($F26*$G26/100*((IF(O$22>9,9,O$22))/9))*(1+(COL))^(O$19-ColStart+1))))),0)","v":0},{"$f":"IF(G26<>0,IF($G$8<9,0,IF($G26=0,0,IF(ColStart>P$19,(IF($F26>SalaryCap,(SalaryCap*$G26/100*((IF(P$22>9,9,P$22))/9)),$F26*$G26/100*((IF(P$22>9,9,P$22))/9))),IF(($F26*(1+(COL))^(P$19-ColStart+1))>SalaryCap,(SalaryCap*$G26/100*((IF(P$22>9,9,P$22))/9)),($F26*$G26/100*((IF(P$22>9,9,P$22))/9))*(1+(COL))^(P$19-ColStart+1))))),0)","v":0},{"$f":"IF(G26<>0,IF($G$8<10,0,IF($G26=0,0,IF(ColStart>Q$19,(IF($F26>SalaryCap,(SalaryCap*$G26/100*((IF(Q$22>9,9,Q$22))/9)),$F26*$G26/100*((IF(Q$22>9,9,Q$22))/9))),IF(($F26*(1+(COL))^(Q$19-ColStart+1))>SalaryCap,(SalaryCap*$G26/100*((IF(Q$22>9,9,Q$22))/9)),($F26*$G26/100*((IF(Q$22>9,9,Q$22))/9))*(1+(COL))^(Q$19-ColStart+1))))),0)","v":0},{"$f":"SUM(H26:Q26)","v":0}]
[null,null,null,null,"3 Month Summer",{"$f":"F26/3","v":0},null,{"$f":"IF(G27<>0,IF($G$8=0,0,IF($G27=0,0,IF(ColStart>H$19,(IF($F27>SalaryCap,(SalaryCap*$G27/100*((IF(H$22>3,3,H$22))/3)),$F27*$G27/100*((IF(H$22>3,3,H$22))/3))),IF(($F27*(1+(COL))^(H$19-ColStart+1))>SalaryCap,(SalaryCap*$G27/100*((IF(H$22>3,3,H$22))/3)),($F27*$G27/100*((IF(H$22>3,3,H$22))/3))*(1+(COL))^(H$19-ColStart+1))))),0)","v":0},{"$f":"IF(G27<>0,IF($G$8<2,0,IF($G27=0,0,IF(ColStart>I$19,(IF($F27>SalaryCap,(SalaryCap*$G27/100*((IF(I$22>3,3,I$22))/3)),$F27*$G27/100*((IF(I$22>3,3,I$22))/3))),IF(($F27*(1+(COL))^(I$19-ColStart+1))>SalaryCap,(SalaryCap*$G27/100*((IF(I$22>3,3,I$22))/3)),($F27*$G27/100*((IF(I$22>3,3,I$22))/3))*(1+(COL))^(I$19-ColStart+1))))),0)","v":0},{"$f":"IF(G27<>0,IF($G$8<3,0,IF($G27=0,0,IF(ColStart>J$19,(IF($F27>SalaryCap,(SalaryCap*$G27/100*((IF(J$22>3,3,J$22))/3)),$F27*$G27/100*((IF(J$22>3,3,J$22))/3))),IF(($F27*(1+(COL))^(J$19-ColStart+1))>SalaryCap,(SalaryCap*$G27/100*((IF(J$22>3,3,J$22))/3)),($F27*$G27/100*((IF(J$22>3,3,J$22))/3))*(1+(COL))^(J$19-ColStart+1))))),0)","v":0},{"$f":"IF(G27<>0,IF($G$8<4,0,IF($G27=0,0,IF(ColStart>K$19,(IF($F27>SalaryCap,(SalaryCap*$G27/100*((IF(K$22>3,3,K$22))/3)),$F27*$G27/100*((IF(K$22>3,3,K$22))/3))),IF(($F27*(1+(COL))^(K$19-ColStart+1))>SalaryCap,(SalaryCap*$G27/100*((IF(K$22>3,3,K$22))/3)),($F27*$G27/100*((IF(K$22>3,3,K$22))/3))*(1+(COL))^(K$19-ColStart+1))))),0)","v":0},{"$f":"IF(G27<>0,IF($G$8<5,0,IF($G27=0,0,IF(ColStart>L$19,(IF($F27>SalaryCap,(SalaryCap*$G27/100*((IF(L$22>3,3,L$22))/3)),$F27*$G27/100*((IF(L$22>3,3,L$22))/3))),IF(($F27*(1+(COL))^(L$19-ColStart+1))>SalaryCap,(SalaryCap*$G27/100*((IF(L$22>3,3,L$22))/3)),($F27*$G27/100*((IF(L$22>3,3,L$22))/3))*(1+(COL))^(L$19-ColStart+1))))),0)","v":0},{"$f":"IF(G27<>0,IF($G$8<6,0,IF($G27=0,0,IF(ColStart>M$19,(IF($F27>SalaryCap,(SalaryCap*$G27/100),$F27*$G27/100)),IF(($F27*(1+(COL))^(M$19-ColStart+1))>SalaryCap,(SalaryCap*$G27/100),($F27*$G27/100)*(1+(COL))^(M$19-ColStart+1))))),0)","v":0},{"$f":"IF(G27<>0,IF($G$8<7,0,IF($G27=0,0,IF(ColStart>N$19,(IF($F27>SalaryCap,(SalaryCap*$G27/100),$F27*$G27/100)),IF(($F27*(1+(COL))^(N$19-ColStart+1))>SalaryCap,(SalaryCap*$G27/100),($F27*$G27/100)*(1+(COL))^(N$19-ColStart+1))))),0)","v":0},{"$f":"IF(G27<>0,IF($G$8<8,0,IF($G27=0,0,IF(ColStart>O$19,(IF($F27>SalaryCap,(SalaryCap*$G27/100),$F27*$G27/100)),IF(($F27*(1+(COL))^(O$19-ColStart+1))>SalaryCap,(SalaryCap*$G27/100),($F27*$G27/100)*(1+(COL))^(O$19-ColStart+1))))),0)","v":0},{"$f":"IF(H27<>0,IF($G$8<8,0,IF($G27=0,0,IF(ColStart>P$19,(IF($F27>SalaryCap,(SalaryCap*$G27/100),$F27*$G27/100)),IF(($F27*(1+(COL))^(P$19-ColStart+1))>SalaryCap,(SalaryCap*$G27/100),($F27*$G27/100)*(1+(COL))^(P$19-ColStart+1))))),0)","v":0},{"$f":"IF(G27<>0,IF($G$8<10,0,IF($G27=0,0,IF(ColStart>Q$19,(IF($F27>SalaryCap,(SalaryCap*$G27/100),$F27*$G27/100)),IF(($F27*(1+(COL))^(Q$19-ColStart+1))>SalaryCap,(SalaryCap*$G27/100),($F27*$G27/100)*(1+(COL))^(Q$19-ColStart+1))))),0)","v":0},0]
[]
[null,null,null,null,null,null,"Total Monthly",{"$f":"SUM(H25:H28)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H29:Q29)","v":0}]
[]
[null,null,"Name:",null,null,"Base Salary:","% Effort:"]
[null,"Hourly (biweekly) Employees",null,null,null,null,null,{"$f":"IF($G$8>=H$19,$F32*$G32/100*(1+(COL))^(H$19-ColStart+1),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H32:Q32)","v":0}]
[]
[null,null,null,null,null,null,"Total Hourly",{"$f":"SUM(H32:H33)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,"No. Months:"]
[null,"Other Employees",null,null,null,"No. Employees","Rate/month:"]
[null,"Temporary Employees (No Insurance)",null,null,null,null,null,{"$f":"IF($G$8=0,0,$F38*$G38*H$37)","v":0},{"$f":"IF($G$8>=2,$F38*$G38*I$37,0)","v":0},{"$f":"IF($G$8>=3,$F38*$G38*J$37,0)","v":0},{"$f":"IF($G$8>=4,$F38*$G38*K$37,0)","v":0},{"$f":"IF($G$8>=5,$F38*$G38*L$37,0)","v":0},{"$f":"IF($G$8>=6,$F38*$G38*M$37,0)","v":0},{"$f":"IF($G$8>=7,$F38*$G38*N$37,0)","v":0},{"$f":"IF($G$8>=8,$F38*$G38*O$37,0)","v":0},{"$f":"IF($G$8>=9,$F38*$G38*P$37,0)","v":0},{"$f":"IF($G$8>=10,$F38*$G38*Q$37,0)","v":0},{"$f":"SUM(H38:Q38)","v":0}]
[null,"Temporary Employees (Insurance)",null,null,null,null,null,{"$f":"IF($G$8=0,0,$F39*$G39*H$37)","v":0},{"$f":"IF($G$8>=2,$F39*$G39*I$37,0)","v":0},{"$f":"IF($G$8>=3,$F39*$G39*J$37,0)","v":0},{"$f":"IF($G$8>=4,$F39*$G39*K$37,0)","v":0},{"$f":"IF($G$8>=5,$F39*$G39*L$37,0)","v":0},{"$f":"IF($G$8>=6,$F39*$G39*M$37,0)","v":0},{"$f":"IF($G$8>=7,$F39*$G39*N$37,0)","v":0},{"$f":"IF($G$8>=8,$F39*$G39*O$37,0)","v":0},{"$f":"IF($G$8>=9,$F39*$G39*P$37,0)","v":0},{"$f":"IF($G$8>=10,$F39*$G39*Q$37,0)","v":0},{"$f":"SUM(H39:Q39)","v":0}]
[]
[61257,"Graduate Assistants",null,null,"Academic year (9mo)",null,null,{"$f":"IF($G$8=0,0,$F41*$G41*9)","v":0},{"$f":"IF($G$8>=2,$F41*$G41*9,0)","v":0},{"$f":"IF($G$8>=3,$F41*$G41*9,0)","v":0},{"$f":"IF($G$8>=4,$F41*$G41*9,0)","v":0},{"$f":"IF($G$8>=5,$F41*$G41*9,0)","v":0},{"$f":"IF($G$8>=6,$F41*$G41*9,0)","v":0},{"$f":"IF($G$8>=7,$F41*$G41*9,0)","v":0},{"$f":"IF($G$8>=8,$F41*$G41*9,0)","v":0},{"$f":"IF($G$8>=9,$F41*$G41*9,0)","v":0},{"$f":"IF($G$8>=10,$F41*$G41*9,0)","v":0},{"$f":"SUM(H41:Q41)","v":0}]
[null,null,null,null,"Summer(3mo)",null,null,{"$f":"IF($G$8=0,0,$F42*$G42*3)","v":0},{"$f":"IF($G$8>=2,$F42*$G42*3,0)","v":0},{"$f":"IF($G$8>=3,$F42*$G42*3,0)","v":0},{"$f":"IF($G$8>=4,$F42*$G42*3,0)","v":0},{"$f":"IF($G$8>=5,$F42*$G42*3,0)","v":0},{"$f":"IF($G$8>=6,$F42*$G42*3,0)","v":0},{"$f":"IF($G$8>=7,$F42*$G42*3,0)","v":0},{"$f":"IF($G$8>=8,$F42*$G42*3,0)","v":0},{"$f":"IF($G$8>=9,$F42*$G42*3,0)","v":0},{"$f":"IF($G$8>=10,$F42*$G42*3,0)","v":0},{"$f":"SUM(H42:Q42)","v":0}]
[]
[null,null,null,null,null,null,null,"No. Months:"]
[]
[61410,"Student Workers (undergraduate)",null,null,"Hourly",null,null,{"$f":"IF($G$8=0,0,$F46*$G46*H45)","v":0},{"$f":"IF($G$8>=2,$F46*$G46*I45,0)","v":0},{"$f":"IF($G$8>=3,$F46*$G46*J45,0)","v":0},{"$f":"IF($G$8>=4,$F46*$G46*K45,0)","v":0},{"$f":"IF($G$8>=5,$F46*$G46*L45,0)","v":0},{"$f":"IF($G$8>=6,$F46*$G46*M45,0)","v":0},{"$f":"IF($G$8>=7,$F46*$G46*N45,0)","v":0},{"$f":"IF($G$8>=8,$F46*$G46*O45,0)","v":0},{"$f":"IF($G$8>=9,$F46*$G46*P45,0)","v":0},{"$f":"IF($G$8>=10,$F46*$G46*Q45,0)","v":0},{"$f":"SUM(H46:Q46)","v":0}]
[]
[]
[null,null,null,null,null,null,"Total Salary",{"$f":"SUM(H38:H42,H46,Total_Hourly1,TotalKey1)","v":0},{"$f":"SUM(I38:I42,I46,Total_Hourly2,TotalKey2)","v":0},{"$f":"SUM(J38:J42,J46,Total_Hourly3,TotalKey3)","v":0},{"$f":"SUM(K38:K42,K46,Total_Hourly4,TotalKey4)","v":0},{"$f":"SUM(L38:L42,L46,Total_Hourly5,TotalKey5)","v":0},{"$f":"SUM(M38:M42,M46,Total_Hourly6,TotalKey6)","v":0},{"$f":"SUM(N38:N42,N46,Total_Hourly7,TotalKey7)","v":0},{"$f":"SUM(O38:O42,O46,Total_Hourly8,TotalKey8)","v":0},{"$f":"SUM(P38:P42,P46,Total_Hourly9,TotalKey9)","v":0},{"$f":"SUM(Q38:Q42,Q46,Total_Hourly10,TotalKey10)","v":0},{"$f":"SUM(R29:R46)","v":0}]
[]
[null,"Fringe Information"]
[]
[62000,null,{"$f":"$C$25","v":0},null,{"$f":"'Validation Data'!$E$2","v":35.299999999999997},null,null,{"$f":"IF($G$8>0,TotalKey1*$E$53/100,0)","v":0},{"$f":"IF($G$8>1,TotalKey2*$E$53/100,0)","v":0},{"$f":"IF($G$8>2,TotalKey3*$E$53/100,0)","v":0},{"$f":"IF($G$8>3,TotalKey4*$E$53/100,0)","v":0},{"$f":"IF($G$8>4,TotalKey5*$E$53/100,0)","v":0},{"$f":"IF($G$8>5,TotalKey6*$E$53/100,0)","v":0},{"$f":"IF($G$8>6,TotalKey7*$E$53/100,0)","v":0},{"$f":"IF($G$8>7,TotalKey8*$E$53/100,0)","v":0},{"$f":"IF($G$8>8,TotalKey9*$E$53/100,0)","v":0},{"$f":"IF($G$8>9,TotalKey10*$E$53/100,0)","v":0},{"$f":"SUM(H53:Q53)","v":0}]
[]
[null,"Graduate Assistants",null,"Academic year",{"$f":"'Validation Data'!E6","v":1.9},null,null,{"$f":"H41*E55/100","v":0},{"$f":"IF($G$8>1,I41*$E55/100,0)","v":0},{"$f":"IF($G$8>2,J41*$E55/100,0)","v":0},{"$f":"IF($G$8>3,K41*$E55/100,0)","v":0},{"$f":"IF($G$8>4,L41*$E55/100,0)","v":0},{"$f":"IF($G$8>5,M41*$E55/100,0)","v":0},{"$f":"IF($G$8>6,N41*$E55/100,0)","v":0},{"$f":"IF($G$8>7,O41*$E55/100,0)","v":0},{"$f":"IF($G$8>8,P41*$E55/100,0)","v":0},{"$f":"IF($G$8>9,Q41*$E55/100,0)","v":0},{"$f":"SUM(H55:Q55)","v":0}]
[null,"Graduate Assistants",null,"Summer",{"$f":"'Validation Data'!E6","v":1.9},null,null,{"$f":"H42*E56/100","v":0},{"$f":"IF($G$8>1,I42*$E56/100,0)","v":0},{"$f":"IF($G$8>2,J42*$E56/100,0)","v":0},{"$f":"IF($G$8>3,K42*$E56/100,0)","v":0},{"$f":"IF($G$8>4,L42*$E56/100,0)","v":0},{"$f":"IF($G$8>5,M42*$E56/100,0)","v":0},{"$f":"IF($G$8>6,N42*$E56/100,0)","v":0},{"$f":"IF($G$8>7,O42*$E56/100,0)","v":0},{"$f":"IF($G$8>8,P42*$E56/100,0)","v":0},{"$f":"IF($G$8>9,Q42*$E56/100,0)","v":0},0]
[null,"Student Workers (undergraduate)",null,null,{"$f":"'Validation Data'!E6","v":1.9},null,null,{"$f":"H46*E57/100","v":0},{"$f":"IF($G$8>1,I46*$E57/100,0)","v":0},{"$f":"IF($G$8>2,J46*$E57/100,0)","v":0},{"$f":"IF($G$8>3,K46*$E57/100,0)","v":0},{"$f":"IF($G$8>4,L46*$E57/100,0)","v":0},{"$f":"IF($G$8>5,M46*$E57/100,0)","v":0},{"$f":"IF($G$8>6,N46*$E57/100,0)","v":0},{"$f":"IF($G$8>7,O46*$E57/100,0)","v":0},{"$f":"IF($G$8>8,P46*$E57/100,0)","v":0},{"$f":"IF($G$8>9,Q46*$E57/100,0)","v":0},0]
[null,"Hourly Employees",null,null,{"$f":"'Validation Data'!E3","v":52.4},null,null,{"$f":"HourlyFringe*Total_Hourly1/100","v":0},{"$f":"IF($G$8>1,HourlyFringe*Total_Hourly2/100,0)","v":0},{"$f":"IF($G$8>2,HourlyFringe*Total_Hourly3/100,0)","v":0},{"$f":"IF($G$8>3,HourlyFringe*Total_Hourly4/100,0)","v":0},{"$f":"IF($G$8>4,HourlyFringe*Total_Hourly5/100,0)","v":0},{"$f":"IF($G$8>5,HourlyFringe*Total_Hourly6/100,0)","v":0},{"$f":"IF($G$8>6,HourlyFringe*Total_Hourly7/100,0)","v":0},{"$f":"IF($G$8>7,HourlyFringe*Total_Hourly8/100,0)","v":0},{"$f":"IF($G$8>8,HourlyFringe*Total_Hourly9/100,0)","v":0},{"$f":"IF($G$8>9,HourlyFringe*Total_Hourly10/100,0)","v":0},0]
[null,"Temporary Employees (No Insurance)",null,null,{"$f":"'Validation Data'!E4","v":7.5},null,null,{"$f":"H38*$E59/100","v":0},{"$f":"IF($G$8>1,I38*$E59/100,0)","v":0},{"$f":"IF($G$8>2,J38*$E59/100,0)","v":0},{"$f":"IF($G$8>3,K38*$E59/100,0)","v":0},{"$f":"IF($G$8>4,L38*$E59/100,0)","v":0},{"$f":"IF($G$8>5,M38*$E59/100,0)","v":0},{"$f":"IF($G$8>6,N38*$E59/100,0)","v":0},{"$f":"IF($G$8>7,O38*$E59/100,0)","v":0},{"$f":"IF($G$8>8,P38*$E59/100,0)","v":0},{"$f":"IF($G$8>9,Q38*$E59/100,0)","v":0},0]
[null,"Tempoary Employees (Insurance)",null,null,{"$f":"'Validation Data'!E5","v":19.8},null,null,{"$f":"H39*$E60/100","v":0},{"$f":"IF($G$8>1,I39*$E60/100,0)","v":0},{"$f":"IF($G$8>2,J39*$E60/100,0)","v":0},{"$f":"IF($G$8>3,K39*$E60/100,0)","v":0},{"$f":"IF($G$8>4,L39*$E60/100,0)","v":0},{"$f":"IF($G$8>5,M39*$E60/100,0)","v":0},{"$f":"IF($G$8>6,N39*$E60/100,0)","v":0},{"$f":"IF($G$8>7,O39*$E60/100,0)","v":0},{"$f":"IF($G$8>8,P39*$E60/100,0)","v":0},{"$f":"IF($G$8>9,Q39*$E60/100,0)","v":0},0]
[]
[null,null,null,null,null,null,"Total Fringe",{"$f":"SUM(H53:H60)","v":0},{"$f":"SUM(I53:I60)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Travel - Domestic or International"]
[null,null,null,"Choose:","Location (if known):"]
[null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H66:Q66)","v":0}]
[]
[null,null,null,null,null,null,"Total Travel",{"$f":"SUM(H66:H67)","v":0},{"$f":"IF(Budget!$G$8>=2,SUM(I66:I67),)","v":0},{"$f":"IF(Budget!$G$8>=3,SUM(J66:J67),)","v":0},{"$f":"IF(Budget!$G$8>=4,SUM(K66:K67),)","v":0},{"$f":"IF(Budget!$G$8>=5,SUM(L66:L67),)","v":0},{"$f":"IF(Budget!$G$8>=6,SUM(M66:M67),)","v":0},{"$f":"IF(Budget!$G$8>=7,SUM(N66:N67),)","v":0},{"$f":"IF(Budget!$G$8>=8,SUM(O66:O67),)","v":0},{"$f":"IF(Budget!$G$8>=9,SUM(P66:P67),)","v":0},{"$f":"IF(Budget!$G$8>=10,SUM(Q66:Q67),)","v":0},{"$f":"SUM(R66:R67)","v":0}]
[]
[null,"Materials and Supplies < $5,000"]
[74500,null,null,null,null,"Consumables",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H71:Q71)","v":0}]
[]
[null,null,null,null,null,null,"Total Supplies",{"$f":"SUM(H71:H72)","v":0},{"$f":"IF(Budget!$G$8>=2,SUM(I71:I72),)","v":0},{"$f":"IF(Budget!$G$8>=3,SUM(J71:J72),)","v":0},{"$f":"IF(Budget!$G$8>=4,SUM(K71:K72),)","v":0},{"$f":"IF(Budget!$G$8>=5,SUM(L71:L72),)","v":0},{"$f":"IF(Budget!$G$8>=6,SUM(M71:M72),)","v":0},{"$f":"IF(Budget!$G$8>=7,SUM(N71:N72),)","v":0},{"$f":"IF(Budget!$G$8>=8,SUM(O71:O72),)","v":0},{"$f":"IF(Budget!$G$8>=9,SUM(P71:P72),)","v":0},{"$f":"IF(Budget!$G$8=10,SUM(Q71:Q72),)","v":0},{"$f":"SUM(R71:R72)","v":0}]
[]
[null,"Equipment >$5,000",null,"Click here for \nmore information"]
[null,null,null,null,null,"List each item"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H77:Q77)","v":0}]
[]
[null,null,null,null,null,null,"Total Equipment",{"$f":"SUM(H77:H78)","v":0},{"$f":"IF(Budget!$G$8>=2,SUM(I77:I78),)","v":0},{"$f":"IF(Budget!$G$8>=3,SUM(J77:J78),)","v":0},{"$f":"IF(Budget!$G$8>=4,SUM(K77:K78),)","v":0},{"$f":"IF(Budget!$G$8>=5,SUM(L77:L78),)","v":0},{"$f":"IF(Budget!$G$8>=6,SUM(M77:M78),)","v":0},{"$f":"IF(Budget!$G$8>=7,SUM(N77:N78),)","v":0},{"$f":"IF(Budget!$G$8>=8,SUM(O77:O78),)","v":0},{"$f":"IF(Budget!$G$8>=9,SUM(P77:P78),)","v":0},{"$f":"IF(Budget!$G$8>=10,SUM(Q77:Q78),)","v":0},{"$f":"SUM(R77:R78)","v":0}]
[]
[62750,"Tuition/fees for Graduate Assistants"]
[null,null,null,null,"Number students","Rate per year","Percent Increase"]
[null,"Go to Tuition Estimator in Bursors's Office","Tuition",null,null,null,null,{"$f":"F83*E83*(1+$G$83)","v":0},{"$f":"IF($G$8>=2,H83*(1+$G$83),)","v":0},{"$f":"IF($G$8>=3,I83*(1+$G$83),)","v":0},{"$f":"IF($G$8>=4,J83*(1+$G$83),)","v":0},{"$f":"IF($G$8>=5,K83*(1+$G$83),)","v":0},{"$f":"IF($G$8>=6,L83*(1+$G$83),)","v":0},{"$f":"IF($G$8>=7,M83*(1+$G$83),)","v":0},{"$f":"IF($G$8>=8,N83*(1+$G$83),)","v":0},{"$f":"IF($G$8>=9,O83*(1+$G$83),)","v":0},{"$f":"IF($G$8>=10,P83*(1+$G$83),)","v":0},{"$f":"SUM(H83:Q83)","v":0}]
[null,null,"Fees",null,null,null,null,{"$f":"F84*E84*(1+G84)","v":0},{"$f":"IF($G$8>=2,H84*(1+$G$84),)","v":0},{"$f":"IF($G$8>=3,I84*(1+$G$84),)","v":0},{"$f":"IF($G$8>=4,J84*(1+$G$84),)","v":0},{"$f":"IF($G$8>=5,K84*(1+$G$84),)","v":0},{"$f":"IF($G$8>=6,L84*(1+$G$84),)","v":0},{"$f":"IF($G$8>=7,M84*(1+$G$84),)","v":0},{"$f":"IF($G$8>=8,N84*(1+$G$84),)","v":0},{"$f":"IF($G$8>=9,O84*(1+$G$84),)","v":0},{"$f":"IF($G$8>=10,P84*(1+$G$84),)","v":0},{"$f":"SUM(H84:Q84)","v":0}]
[]
[null,null,null,null,null,null,"Total Tuition",{"$f":"SUM(H83:H84)","v":0},{"$f":"IF($G$8>=2,SUM(I83:I84),0)","v":0},{"$f":"IF($G$8>=3,SUM(J83:J84),0)","v":0},{"$f":"IF($G$8>=4,SUM(K83:K84),0)","v":0},{"$f":"IF($G$8>=5,SUM(L83:L84),0)","v":0},{"$f":"IF($G$8>=6,SUM(M83:M84),0)","v":0},{"$f":"IF($G$8>=7,SUM(N83:N84),0)","v":0},{"$f":"IF($G$8>=8,SUM(O83:O84),0)","v":0},{"$f":"IF($G$8>=9,SUM(P83:P84),0)","v":0},{"$f":"IF($G$8>=10,SUM(Q83:Q84),0)","v":0},{"$f":"SUM(R83:R85)","v":0}]
[]
[null,"Consultant",null,"Click here for \nmore information"]
[null,null,null,null,null,"Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H90:Q90)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H91:Q91)","v":0}]
[]
[null,null,null,null,null,null,"Total Consultants",{"$f":"SUM(H90:H92)","v":0},{"$f":"IF(Budget!$G$8>=2,SUM(I90:I92),)","v":0},{"$f":"IF(Budget!$G$8>=3,SUM(J90:J92),)","v":0},{"$f":"IF(Budget!$G$8>=4,SUM(K90:K92),)","v":0},{"$f":"IF(Budget!$G$8>=5,SUM(L90:L92),)","v":0},{"$f":"IF(Budget!$G$8>=6,SUM(M90:M92),)","v":0},{"$f":"IF(Budget!$G$8>=7,SUM(N90:N92),)","v":0},{"$f":"IF(Budget!$G$8>=8,SUM(O90:O92),)","v":0},{"$f":"IF(Budget!$G$8>=9,SUM(P90:P92),)","v":0},{"$f":"IF(Budget!$G$8>=10,SUM(Q90:Q92),)","v":0},{"$f":"SUM(R90:R92)","v":0}]
[]
[null,"Subrecipients"]
[null,null,null,null,null,null,"Subrecipient Name"]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H97:Q97)","v":0}]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H98:Q98)","v":0}]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H99:Q99)","v":0}]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H100:Q100)","v":0}]
[null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H101:Q101)","v":0}]
[]
[null,null,null,null,null,null,"Total Subrecipients",{"$f":"SUM(H97:H101)","v":0},{"$f":"SUM(I97:I101)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Participant Support (excludes human subject incentive)",null,null,null,null,"# participants:"]
[null,null,null,null,null,null,"Participant Support",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H106:Q106)","v":0}]
[]
[null,"Other"]
[null,null,null,null,null,null,"Printing",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H109:Q109)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H110:Q110)","v":0}]
[]
[null,null,null,null,null,null,"Total Other Costs",{"$f":"SUM(H109:H111)","v":0},{"$f":"IF($G$8>=2,SUM(I109:I111),)","v":0},{"$f":"IF($G$8>=3,SUM(J109:J111),)","v":0},{"$f":"IF($G$8>=4,SUM(K109:K111),)","v":0},{"$f":"IF($G$8>=5,SUM(L109:L111),)","v":0},{"$f":"IF($G$8>=6,SUM(M109:M111),)","v":0},{"$f":"IF($G$8>=7,SUM(N109:N111),)","v":0},{"$f":"IF($G$8>=8,SUM(O109:O111),)","v":0},{"$f":"IF($G$8>=9,SUM(P109:P111),)","v":0},{"$f":"IF($G$8=10,SUM(Q109:Q111),)","v":0},{"$f":"SUM(R109:R111)","v":0}]
[]
[null,"Direct Costs"]
[null,null,null,null,null,null,"Total Direct Costs",{"$f":"SUM(TotalSalary1,TotalFringe1,TotalTravel1,TotalEquipment1,TotalTuition1,TotalConsultants1,TotalSubcontracts1,TotalOtherCosts1,TotalSupplies1,ParticipantSupport1)","v":0},{"$f":"IF($G$8>1,SUM(TotalSalary2,TotalFringe2,TotalTravel2,TotalEquipment2,TotalTuition2,TotalConsultants2,TotalSubcontracts2,TotalOtherCosts2,TotalSupplies2,ParticipantSupport2),)","v":0},{"$f":"IF($G$8>2,SUM(TotalSalary3,TotalFringe3,TotalTravel3,TotalEquipment3,TotalTuition3,TotalConsultants3,TotalSubcontracts3,TotalOtherCosts3,TotalSupplies3,ParticipantSupport3),)","v":0},{"$f":"IF($G$8>3,SUM(TotalSalary4,TotalFringe4,TotalTravel4,TotalEquipment4,TotalTuition4,TotalConsultants4,TotalSubcontracts4,TotalOtherCosts4,TotalSupplies4,ParticipantSupport4),)","v":0},{"$f":"IF($G$8>4,SUM(TotalSalary5,TotalFringe5,TotalTravel5,TotalEquipment5,TotalTuition5,TotalConsultants5,TotalSubcontracts5,TotalOtherCosts5,TotalSupplies5,ParticipantSupport5),)","v":0},{"$f":"IF($G$8>5,SUM(TotalSalary6,TotalFringe6,TotalTravel6,TotalEquipment6,TotalTuition6,TotalConsultants6,TotalSubcontracts6,TotalOtherCosts6,TotalSupplies6,ParticipantSupport6),)","v":0},{"$f":"IF($G$8>6,SUM(TotalSalary7,TotalFringe7,TotalTravel7,TotalEquipment7,TotalTuition7,TotalConsultants7,TotalSubcontracts7,TotalOtherCosts7,TotalSupplies7,ParticipantSupport7),)","v":0},{"$f":"IF($G$8>7,SUM(TotalSalary8,TotalFringe8,TotalTravel8,TotalEquipment8,TotalTuition8,TotalConsultants8,TotalSubcontracts8,TotalOtherCosts8,TotalSupplies8,ParticipantSupport8),)","v":0},{"$f":"IF($G$8>8,SUM(TotalSalary9,TotalFringe9,TotalTravel9,TotalEquipment9,TotalTuition9,TotalConsultants9,TotalSubcontracts9,TotalOtherCosts9,TotalSupplies9,ParticipantSupport9),)","v":0},{"$f":"IF($G$8>9,SUM(TotalSalary10,TotalFringe10,TotalTravel10,TotalEquipment10,TotalTuition10,TotalConsultants10,TotalSubcontracts10,TotalOtherCosts10,TotalSupplies10,ParticipantSupport10),)","v":0},{"$f":"SUM(H115:Q115)","v":0}]
[]
[null,"Modified Direct Costs"]
[null,null,null,null,null,null,"Modified Direct Costs",{"$f":"SUM(TotalSalary1,TotalFringe1,TotalTravel1,TotalConsultants1,TotalOtherCosts1,TotalSupplies1,SubrecipientIncludeMTDC1)","v":0},{"$f":"IF($G$8>1,SUM(TotalSalary2,TotalFringe2,TotalTravel2,TotalConsultants2,TotalOtherCosts2,TotalSupplies2,SubrecipientIncludeMTDC2),)","v":0},{"$f":"IF($G$8>2,SUM(TotalSalary3,TotalFringe3,TotalTravel3,TotalConsultants3,TotalOtherCosts3,TotalSupplies3,SubrecipientIncludeMTDC3),)","v":0},{"$f":"IF($G$8>3,SUM(TotalSalary4,TotalFringe4,TotalTravel4,TotalConsultants4,TotalOtherCosts4,TotalSupplies4,SubrecipientIncludeMTDC4),)","v":0},{"$f":"IF($G$8>4,SUM(TotalSalary5,TotalFringe5,TotalTravel5,TotalConsultants5,TotalOtherCosts5,TotalSupplies5,SubrecipientIncludeMTDC5),)","v":0},{"$f":"IF($G$8>5,SUM(TotalSalary6,TotalFringe6,TotalTravel6,TotalConsultants6,TotalOtherCosts6,TotalSupplies6,SubrecipientIncludeMTDC6),)","v":0},{"$f":"IF($G$8>6,SUM(TotalSalary7,TotalFringe7,TotalTravel7,TotalConsultants7,TotalOtherCosts7,TotalSupplies7,SubrecipientIncludeMTDC7),)","v":0},{"$f":"IF($G$8>7,SUM(TotalSalary8,TotalFringe8,TotalTravel8,TotalConsultants8,TotalOtherCosts8,TotalSupplies8,SubrecipientIncludeMTDC8),)","v":0},{"$f":"IF($G$8>8,SUM(TotalSalary9,TotalFringe9,TotalTravel9,TotalConsultants9,TotalOtherCosts9,TotalSupplies9,SubrecipientIncludeMTDC9),)","v":0},{"$f":"IF($G$8>9,SUM(TotalSalary10,TotalFringe10,TotalTravel10,TotalConsultants10,TotalOtherCosts10,TotalSupplies10,SubrecipientIncludeMTDC10),)","v":0},{"$f":"SUM(H118:Q118)","v":0}]
[]
[null,"Facilities and Administration Costs"]
[null,null,null,"Rate:","Type:"]
[null,null,null,{"$f":"$C$11","v":0},{"$f":"$C$10","v":0},null,"Total F&A Costs",{"$f":"IF($E$122=\"MTDC\",ModifiedDirectCosts1*$D$122,IF($E$122=\"TDC\",TotalDirectCosts1*$D$122,0))","v":0},{"$f":"IF($G$8>1,(IF($E$122=\"MTDC\",ModifiedDirectCosts2*$D$122,IF($E$122=\"TDC\",TotalDirectCosts2*$D$122,0))),)","v":0},{"$f":"IF($G$8>2,(IF($E$122=\"MTDC\",ModifiedDirectCosts3*$D$122,IF($E$122=\"TDC\",TotalDirectCosts3*$D$122,0))),)","v":0},{"$f":"IF($G$8>3,(IF($E$122=\"MTDC\",ModifiedDirectCosts4*$D$122,IF($E$122=\"TDC\",TotalDirectCosts4*$D$122,0))),)","v":0},{"$f":"IF($G$8>4,(IF($E$122=\"MTDC\",ModifiedDirectCosts5*$D$122,IF($E$122=\"TDC\",TotalDirectCosts5*$D$122,0))),)","v":0},{"$f":"IF($G$8>5,(IF($E$122=\"MTDC\",ModifiedDirectCosts6*$D$122,IF($E$122=\"TDC\",TotalDirectCosts6*$D$122,0))),)","v":0},{"$f":"IF($G$8>6,(IF($E$122=\"MTDC\",ModifiedDirectCosts7*$D$122,IF($E$122=\"TDC\",TotalDirectCosts7*$D$122,0))),)","v":0},{"$f":"IF($G$8>7,(IF($E$122=\"MTDC\",ModifiedDirectCosts8*$D$122,IF($E$122=\"TDC\",TotalDirectCosts8*$D$122,0))),)","v":0},{"$f":"IF($G$8>8,(IF($E$122=\"MTDC\",ModifiedDirectCosts9*$D$122,IF($E$122=\"TDC\",TotalDirectCosts9*$D$122,0))),)","v":0},{"$f":"IF($G$8>9,(IF($E$122=\"MTDC\",ModifiedDirectCosts10*$D$122,IF($E$122=\"TDC\",TotalDirectCosts10*$D$122,0))),)","v":0},{"$f":"SUM(H122:Q122)","v":0}]
[]
[null,"Total F&A and Direct Costs"]
[]
[null,null,null,null,null,null,"Total F&A and Direct Costs",{"$f":"TotalDirectCosts1+TotalIndirectCosts1","v":0},{"$f":"IF($G$8>1,TotalDirectCosts2+TotalIndirectCosts2,)","v":0},{"$f":"IF($G$8>2,TotalDirectCosts3+TotalIndirectCosts3,)","v":0},{"$f":"IF($G$8>3,TotalDirectCosts4+TotalIndirectCosts4,)","v":0},{"$f":"IF($G$8>4,TotalDirectCosts5+TotalIndirectCosts5,)","v":0},{"$f":"IF($G$8>5,TotalDirectCosts6+TotalIndirectCosts6,)","v":0},{"$f":"IF($G$8>6,TotalDirectCosts7+TotalIndirectCosts7,)","v":0},{"$f":"IF($G$8>7,TotalDirectCosts8+TotalIndirectCosts8,)","v":0},{"$f":"IF($G$8>8,TotalDirectCosts9+TotalIndirectCosts9,)","v":0},{"$f":"IF($G$8>9,TotalDirectCosts10+TotalIndirectCosts10,)","v":0},{"$f":"TotalDirectCostsSum+TotalIndirectCostsSum","v":0}]
[]
[null,"Cost Share"]
[null,null,null,"Internal Cost Share",null,null,"Agency Mandated",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H129:Q129)","v":0}]
[null,null,null,null,null,null,"Voluntary",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H130:Q130)","v":0}]
[]
[null,null,null,null,"Organization:"]
[null,null,"Third Party Cost Share",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H133:Q133)","v":0}]
[]
[null,null,null,null,null,"Total Cost Share",null,{"$f":"SUM(H129:H134)","v":0},{"$f":"IF($G$8>1,SUM(I129:I134),)","v":0},{"$f":"IF($G$8>2,SUM(J129:J134),)","v":0},{"$f":"IF($G$8>3,SUM(K129:K134),)","v":0},{"$f":"IF($G$8>4,SUM(L129:L134),)","v":0},{"$f":"IF($G$8>5,SUM(M129:M134),)","v":0},{"$f":"IF($G$8>6,SUM(N129:N134),)","v":0},{"$f":"IF($G$8>7,SUM(O129:O134),)","v":0},{"$f":"IF($G$8>8,SUM(P129:P134),)","v":0},{"$f":"IF($G$8>9,SUM(Q129:Q134),)","v":0},0]
[]
[null,"Total Project Costs"]
[null,null,null,null,null,null,"Total Project Costs",{"$f":"TotalCostShare1+Total_Indirect_and_Direct_Costs1","v":0},{"$f":"IF($G$8>1,TotalCostShare2+Total_Indirect_and_Direct_Costs2,0)","v":0},{"$f":"IF($G$8>2,TotalCostShare3+Total_Indirect_and_Direct_Costs3,)","v":0},{"$f":"IF($G$8>3,TotalCostShare4+Total_Indirect_and_Direct_Costs4,)","v":0},{"$f":"IF($G$8>4,TotalCostShare5+Total_Indirect_and_Direct_Costs5,)","v":0},{"$f":"IF($G$8>5,TotalCostShare6+Total_Indirect_and_Direct_Costs6,)","v":0},{"$f":"IF($G$8>6,TotalCostShare7+Total_Indirect_and_Direct_Costs7,)","v":0},{"$f":"IF($G$8>7,TotalCostShare8+Total_Indirect_and_Direct_Costs8,)","v":0},{"$f":"IF($G$8>8,TotalCostShare9+Total_Indirect_and_Direct_Costs9,)","v":0},{"$f":"IF($G$8>9,TotalCostShare10+Total_Indirect_and_Direct_Costs10,)","v":0},{"$f":"TotalCostShareSum+Total_Indirect_and_Direct_CostsSum","v":0}]

{"sheet":"Subrecipient","index":2,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"Subrecipients"]
[]
[null,null,null,"Period"]
[null,"Name:",null,1,2,3,4,5,6,7,8,9,10,"Total"]
[null,null,null,null,{"$f":"D8","v":0},{"$f":"E5+E8","v":0},{"$f":"F5+F8","v":0},0,0,0,{"$f":"J5+J8","v":0},{"$f":"K5+K8","v":0},{"$f":"L5+L8","v":0}]
["Subrecipient #1",null,"Total",null,null,0,0,0,0,0,0,0,0,{"$f":"SUM(D6:M6)","v":0}]
[null,null,"Amount to exclude in MTDC",{"$f":"IF(D6<25000,0,(D6-25000))","v":0},{"$f":"IF(E5>25000,E6,IF(E5+E6<25000,0,(E6+E5-25000)))","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(D7:M7)","v":0}]
[null,null,"Amount to include in MTDC",{"$f":"D6-D7","v":0},{"$f":"E6-E7","v":0},0,0,0,0,0,{"$f":"K6-K7","v":0},{"$f":"L6-L7","v":0},{"$f":"M6-M7","v":0},{"$f":"SUM(D8:M8)","v":0}]
[]
[null,null,null,null,{"$f":"D13","v":0},{"$f":"E10+E13","v":0},{"$f":"F10+F13","v":0},{"$f":"G10+G13","v":0},{"$f":"H10+H13","v":0},{"$f":"I10+I13","v":0},{"$f":"J10+J13","v":0},{"$f":"K10+K13","v":0},{"$f":"L10+L13","v":0}]
["Subrecipient #2",null,"Total",null,null,0,0,0,0,0,0,0,0,{"$f":"SUM(D11:M11)","v":0}]
[null,null,"Amount to exclude in MTDC",{"$f":"IF(D11<25000,0,(D11-25000))","v":0},{"$f":"IF(E10>25000,E11,IF(E10+E11<25000,0,(E11+E10-25000)))","v":0},{"$f":"IF(F10>25000,F11,IF(F10+F11<25000,0,(F11+F10-25000)))","v":0},{"$f":"IF(G10>25000,G11,IF(G10+G11<25000,0,(G11+G10-25000)))","v":0},{"$f":"IF(H10>25000,H11,IF(H10+H11<25000,0,(H11+H10-25000)))","v":0},{"$f":"IF(I10>25000,I11,IF(I10+I11<25000,0,(I11+I10-25000)))","v":0},{"$f":"IF(J10>25000,J11,IF(J10+J11<25000,0,(J11+J10-25000)))","v":0},{"$f":"IF(K10>25000,K11,IF(K10+K11<25000,0,(K11+K10-25000)))","v":0},{"$f":"IF(L10>25000,L11,IF(L10+L11<25000,0,(L11+L10-25000)))","v":0},{"$f":"IF(M10>25000,M11,IF(M10+M11<25000,0,(M11+M10-25000)))","v":0},{"$f":"SUM(D12:M12)","v":0}]
[null,null,"Amtount to include in MTDC",{"$f":"D11-D12","v":0},{"$f":"E11-E12","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(D13:M13)","v":0}]
[]
[null,null,null,null,{"$f":"D18","v":0},{"$f":"E15+E18","v":0},{"$f":"F15+F18","v":0},{"$f":"G15+G18","v":0},{"$f":"H15+H18","v":0},{"$f":"I15+I18","v":0},{"$f":"J15+J18","v":0},{"$f":"K15+K18","v":0},{"$f":"L15+L18","v":0}]
["Subrecipient #3",null,"Total",null,null,0,0,0,0,0,0,0,0,{"$f":"SUM(D16:M16)","v":0}]
[null,null,"Amount to exclude in MTDC",{"$f":"IF(D16<25000,0,(D16-25000))","v":0},{"$f":"IF(E15>25000,E16,IF(E15+E16<25000,0,(E16+E15-25000)))","v":0},{"$f":"IF(F15>25000,F16,IF(F15+F16<25000,0,(F16+F15-25000)))","v":0},{"$f":"IF(G15>25000,G16,IF(G15+G16<25000,0,(G16+G15-25000)))","v":0},{"$f":"IF(H15>25000,H16,IF(H15+H16<25000,0,(H16+H15-25000)))","v":0},{"$f":"IF(I15>25000,I16,IF(I15+I16<25000,0,(I16+I15-25000)))","v":0},{"$f":"IF(J15>25000,J16,IF(J15+J16<25000,0,(J16+J15-25000)))","v":0},{"$f":"IF(K15>25000,K16,IF(K15+K16<25000,0,(K16+K15-25000)))","v":0},{"$f":"IF(L15>25000,L16,IF(L15+L16<25000,0,(L16+L15-25000)))","v":0},{"$f":"IF(M15>25000,M16,IF(M15+M16<25000,0,(M16+M15-25000)))","v":0},{"$f":"SUM(D17:M17)","v":0}]
[null,null,"Amount to include in MTDC",{"$f":"D16-D17","v":0},{"$f":"E16-E17","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(D18:M18)","v":0}]
[]
[null,null,null,null,{"$f":"D23","v":0},{"$f":"E20+E23","v":0},{"$f":"F20+F23","v":0},{"$f":"G20+G23","v":0},{"$f":"H20+H23","v":0},{"$f":"I20+I23","v":0},{"$f":"J20+J23","v":0},{"$f":"K20+K23","v":0},{"$f":"L20+L23","v":0}]
["Subrecipient #4",null,"Total",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D21:M21)","v":0}]
[null,null,"Amount to exclude in MTDC",{"$f":"IF(D21<25000,0,(D21-25000))","v":0},{"$f":"IF(E20>25000,E21,IF(E20+E21<25000,0,(E21+E20-25000)))","v":0},{"$f":"IF(F20>25000,F21,IF(F20+F21<25000,0,(F21+F20-25000)))","v":0},{"$f":"IF(G20>25000,G21,IF(G20+G21<25000,0,(G21+G20-25000)))","v":0},{"$f":"IF(H20>25000,H21,IF(H20+H21<25000,0,(H21+H20-25000)))","v":0},{"$f":"IF(I20>25000,I21,IF(I20+I21<25000,0,(I21+I20-25000)))","v":0},{"$f":"IF(J20>25000,J21,IF(J20+J21<25000,0,(J21+J20-25000)))","v":0},{"$f":"IF(K20>25000,K21,IF(K20+K21<25000,0,(K21+K20-25000)))","v":0},{"$f":"IF(L20>25000,L21,IF(L20+L21<25000,0,(L21+L20-25000)))","v":0},{"$f":"IF(M20>25000,M21,IF(M20+M21<25000,0,(M21+M20-25000)))","v":0},{"$f":"SUM(D22:M22)","v":0}]
[null,null,"Amount to include in MTDC",{"$f":"D21-D22","v":0},{"$f":"E21-E22","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(D23:M23)","v":0}]
[]
[null,null,null,null,{"$f":"D28","v":0},{"$f":"E25+E28","v":0},{"$f":"F25+F28","v":0},{"$f":"G25+G28","v":0},{"$f":"H25+H28","v":0},{"$f":"I25+I28","v":0},{"$f":"J25+J28","v":0},{"$f":"K25+K28","v":0},{"$f":"L25+L28","v":0}]
["Subrecipient #5",null,"Total",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D26:M26)","v":0}]
[null,null,"Amount to exclude in MTDC",{"$f":"IF(D26<25000,0,(D26-25000))","v":0},{"$f":"IF(E25>25000,E26,IF(E25+E26<25000,0,(E26+E25-25000)))","v":0},{"$f":"IF(F25>25000,F26,IF(F25+F26<25000,0,(F26+F25-25000)))","v":0},{"$f":"IF(G25>25000,G26,IF(G25+G26<25000,0,(G26+G25-25000)))","v":0},{"$f":"IF(H25>25000,H26,IF(H25+H26<25000,0,(H26+H25-25000)))","v":0},{"$f":"IF(I25>25000,I26,IF(I25+I26<25000,0,(I26+I25-25000)))","v":0},{"$f":"IF(J25>25000,J26,IF(J25+J26<25000,0,(J26+J25-25000)))","v":0},{"$f":"IF(K25>25000,K26,IF(K25+K26<25000,0,(K26+K25-25000)))","v":0},{"$f":"IF(L25>25000,L26,IF(L25+L26<25000,0,(L26+L25-25000)))","v":0},{"$f":"IF(M25>25000,M26,IF(M25+M26<25000,0,(M26+M25-25000)))","v":0},{"$f":"SUM(D27:M27)","v":0}]
[null,null,"Amount to include in MTDC",{"$f":"D26-D27","v":0},{"$f":"E26-E27","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(D28:M28)","v":0}]
[]
[null,null,"Subrecipient Total",{"$f":"SUM(D6+D11+D16+D21+D26)","v":0},{"$f":"SUM(E6+E11+E16+E21+E26)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Amount to exclude in MTDC",{"$f":"SUM(D7+D12+D17+D22+D27)","v":0},{"$f":"SUM(E7+E12+E17+E22+E27)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Amount to include in MTDC",{"$f":"SUM(D8+D13+D18+D23+D28)","v":0},{"$f":"SUM(E8+E13+E18+E23+E28)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"% Effort Conversion","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,6,6,7],[12,0,12,1],[13,0,13,1],[4,0,4,1],[4,3,4,5],[4,6,4,7],[5,0,5,1],[5,3,5,5],[5,6,5,7]]}
["Use this to calculate the total % effort and person months "]
[]
["Enter % effort for 3 months and 9 months OR for 12 months"]
[]
["3 months",null,null,"9 months",null,null,"Combined"]
["Summer Term",null,null,"Academic Year",null,null,"9 months and 3 months"]
[null,null,null,null,null,null,"Total"]
["  % effort ","Person\nMonths",null,"  % effort","      Person\nMonths",null,"% effort","Person\nMonths"]
[null,null,null,null,null,null,null,null,"If on 9 month/3 month,"]
[0,{"$f":"A10*0.03","v":0},null,0,{"$f":"D10*0.09","v":0},null,{"$f":"H10/12*100","v":0},{"$f":"B10+E10","v":0},"enter this Sponsored Effort % and Person Months in Cayuse SP in the Investigator/Research Team section."]
[]
[]
["12 month"]
["Calendar Year"]
[]
["  % effort","Person Months"]
[null,null,"If on 12 month salary,"]
[0,{"$f":"A18*0.12","v":0},"enter this Sponsored Effort % and Person Months in Cayuse SP in the Investigator/Research Team section."]

{"sheet":"Cayuse Budget","index":4,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,5,2,6],[3,3,3,4],[30,0,30,6],[31,0,31,6],[8,0,8,7]]}
["Summary Budget:"]
[]
["Lead PI:",{"$f":"Budget!C2","v":0},"Sponsor:",{"$f":"Budget!C4","v":0}]
[]
["* # of Budget Periods:",{"$f":"Budget!G8","v":0}]
[null,"Project Dates:","Current Period","Entire Project"]
[null,"Start:",null,{"$f":"Budget!C6","v":"00:00:00"}]
[null,"End:",{"$f":"Budget!H21","v":""},{"$f":"Budget!E6","v":"00:00:00"}]
[]
["Cost Sharing","fill out on Budget tab"]
[]
["F&A Rates"]
[null,null,"Current Period","Entire Project"]
[null,"F&A Rate (1):",{"$f":"Budget!C11","v":0},{"$f":"Budget!C11","v":0}]
[null,"* Effective Rate:",{"$f":"C14","v":0},{"$f":"D14","v":0}]
[]
[]
["Budget Categories"]
[null,null,"Current Period","Entire Project"]
[null,"SPONSOR DIRECT COSTS:",{"$f":"TotalDirectCosts1","v":0},{"$f":"TotalDirectCostsSum","v":0}]
[null,"BASE for F&A Rate (1):",{"$f":"IF(Budget!C10=\"MTDC\",ModifiedDirectCosts1,TotalDirectCosts1)","v":0},{"$f":"IF(Budget!C10=\"MTDC\",ModifiedDirectCosts,TotalDirectCostsSum)","v":0}]
[null,"INDIRECT COSTS (F&A):",{"$f":"TotalIndirectCosts1","v":0},{"$f":"TotalIndirectCostsSum","v":0}]
[]
[null,"FEE:","$","$"]
[]
[null,"TOTAL SPONSOR PROPOSED COSTS:",{"$f":"Total_Indirect_and_Direct_Costs1","v":0},{"$f":"Total_Indirect_and_Direct_CostsSum","v":0}]
[null,"Internal Cost Sharing:",{"$f":"Budget!H130+Budget!H129","v":0},{"$f":"Budget!R129","v":0}]
[null,"Third-Party Cost Sharing:",{"$f":"Budget!H133","v":0},{"$f":"Budget!R133","v":0}]
[null,"TOTAL PROJECT COSTS:",{"$f":"TotalProjectCosts1","v":0},{"$f":"TotalProjectCostsSum","v":0}]
[]
["------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"]

{"sheet":"Validation Data","index":5,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Location:","IDC Type:","IDC Rate:","Salary Cap","Fringe Rates:","Travel:","Roles:","Supplies:","Other:"]
["Select One","Select One",0.435,1870000000,35.299999999999997,"--","Investigator","Laptops/computers/etc","Printing"]
["On-Campus","MTDC",0.55000000000000004,null,52.4,"Domestic","Principal Investigator","Consumables","Publications"]
["Off-Campus","TDC",0.35,null,7.5,"International","Salaried Employee","Laboratory supplies","Animal per diems"]
[null,"--",0.26,null,19.8,null,null,"Non-capitalized equipment","Human subject incentive"]
[null,null,null,null,1.9,null,null,"Write in","IMC fees"]
[null,null,null,null,null,null,null,null,"Animal purchase and shipping"]
[null,null,null,null,null,null,null,null,"Cloud computing services"]
[null,null,null,null,null,null,null,null,"Write in"]