{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":43,"n_cols":4,"rows_kept":43,"merged":[[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,7,1],[6,3,7,3],[29,0,30,0],[29,1,30,1],[29,3,30,3],[38,0,38,3],[39,0,40,3],[42,0,44,3]]}
["Indirect Cost Calculation Worksheet"]
[]
[]
["The following worksheet will automatically calculate the amount needed in Indirect Cost (BC80)."]
["Using the YTD Inception to Date report, input your information in the yellow boxes below."]
[]
["Indirect Cost Calculation",null,null,"Input Your Information Below"]
[]
[null,"Example"]
["Fund/Activity Total Balance",{"v":56789.35,"d":"$56,789.35"},null,0]
["Encumbrances (if any)",{"v":1514.79,"d":"$1,514.79"},null,0]
["Subtotal of Fund/Activity Balance + Encumbrance",{"$f":"B10+B11","v":{"v":58304.14,"d":"$58,304.14"}},null,{"$f":"D10+D11","v":0}]
["Less BC 21",0,null,0]
["Less BC 60",{"v":1000,"d":"$1,000.00"},null,0]
["Less BC 66",0,null,0]
["Less other BC exclusions",0,null,0]
["Subtotal ",{"$f":"B12-SUM(B13:B16)","v":{"v":57304.14,"d":"$57,304.14"}},null,{"$f":"D12-SUM(D13:D16)","v":0}]
["Enter current F&A rate",{"v":10,"d":"10.0"},null,{"v":0,"d":"0.0"}]
["--------------------------------------------------------------------------------------",{"$f":"1+(B18/100)","v":{"v":1.1,"d":"1.100"}},null,{"$f":"1+(D18/100)","v":{"v":1,"d":"1.000"}}]
["Direct Cost Subtotal",{"$f":"B17/B19","v":{"v":52094.67272727272,"d":"$52,094.67"}},null,{"$f":"D17/D19","v":0}]
["Indirect Cost Subtotal",{"$f":"B20*(B18/100)","v":{"v":5209.467272727273,"d":"$5,209.47"}},null,{"$f":"D20*(D18/100)","v":0}]
["Outstanding expenses for current period not yet posted",{"v":5771.56,"d":"$5,771.56"},null,0]
["Outstanding IDC for current period not yet posted",{"$f":"B22*(B18/100)","v":{"v":577.1560000000001,"d":"$577.16"}},null,{"$f":"D22*(D18/100)","v":0}]
["Project IDC amount needed",{"$f":"B21+B23","v":{"v":5786.623272727273,"d":"$5,786.62"}},null,{"$f":"D21+D23","v":0}]
["BC80 Subtotal on ITD report",{"v":5300.36,"d":"$5,300.36"},null,0]
["Variance* (see notes below)",{"$f":"B25-B24","v":{"v":-486.26327272727303,"d":"$(486.26)"}},null,{"$f":"D25-D24","v":0}]
["*If negative, process BEA to move funds from Direct Cost function (e.g., 44, 62, etc) to BC80"]
["*If positive, process BEA to move froms from BC80 to Direct Cost function (e.g., 44, 62, etc)"]
[" "]
["Check and Balance",null,null,"Input Your Information Below"]
[]
[null,"Example"]
["Direct Cost Subtotal + BC exclusions",{"$f":"B20+SUM(B13:B16)","v":{"v":53094.67272727272,"d":"$53,094.67"}},null,{"$f":"D20+SUM(D13:D16)","v":0}]
["Outstanding IDC for current period not yet posted",{"$f":"B23","v":{"v":577.1560000000001,"d":"$577.16"}},null,{"$f":"D23","v":0}]
["Subtotal",{"$f":"B33-B34","v":{"v":52517.51672727272,"d":"$52,517.52"}},null,{"$f":"D33-D34","v":0}]
["Subtotal of Fund/Activity Balance + Encumbrance",{"$f":"B35+B24","v":{"v":58304.13999999999,"d":"$58,304.14"}},null,{"$f":"D35+D24","v":0}]
[]
[]
["Important Notes regarding Indirect Costs:"]
["In calculating the indirect cost allowable for a particular grant, note that indirect costs may vary from Sponsor to Sponsor.   "]
[]
[]
["Indirect Costs on a Modified Total Direct Costs (MTDC) excludes Graduate Student Researcher Partial Fee Remission and Insurance (BC21),  Equipment over $5K (BC60), and Subcontracts in excess of $25K (BC66)."]

{"sheet":"Sheet2","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"hidden":true}
["Fund/activity total balance",{"v":56789.35,"d":"$56,789.35"},{"$nulls":3},"Budget Total",{"v":430000,"d":"430,000.00"}]
["Encumbrances",{"v":1514.79,"d":"$1,514.79"},{"$nulls":3},"BC60 Budget",{"v":76459.96,"d":"76,459.96"}]
["Subtotal",{"$f":"SUM(B1:B2)","v":{"v":58304.14,"d":"$58,304.14"}},{"$nulls":3},"Add to BC60 Budget",{"v":1000,"d":"1,000.00"}]
["Less exclusion BC",{"v":1000,"d":"$1,000.00"},{"$nulls":3},"Subtotal",{"$f":"G1-G2-G3","v":{"v":352540.04,"d":"352,540.04"}}]
["Subtotal",{"$f":"B3-B4","v":{"v":57304.14,"d":"$57,304.14"}},{"$nulls":3},"DC",{"$f":"G4/1.1","v":{"v":320490.94545454544,"d":"320,490.95"}}]
["Direct Cost",{"$f":"B5/1.1","v":{"v":52094.67272727272,"d":"$52,094.67"}},{"$nulls":3},"IDC",{"$f":"G5*0.1","v":{"v":32049.094545454544,"d":"32,049.09"}},32140,{"$f":"G6-H6","v":{"v":-90.90545454545645,"d":"(90.91)"}}]
["Indirect Cost",{"$f":"+B6*0.1","v":{"v":5209.467272727273,"d":"$5,209.47"}},{"$nulls":3},"Add BC60",{"$f":"+G2+G3","v":{"v":77459.96,"d":"77,459.96"}}]
[{"$nulls":5},"Subtotal",{"$f":"G5+G6+G7","v":{"v":430000,"d":"430,000.00"}}]
["pending SCT",{"v":5771.56,"d":"$5,771.56"},null,64652.86]
["pending IDC",{"$f":"B9*0.1","v":{"v":577.1560000000001,"d":"$577.16"}},"less excluded BC",1000]
[{"$nulls":3},{"$f":"D9-D10","v":63652.86}]
[null,null,"Direct Cost",{"$f":"D11/1.1","v":{"v":57866.23636363636,"d":"57866.24"}}]
["Direct cost",{"$f":"B6+B9","v":{"v":57866.23272727272,"d":"$57,866.23"}},"IDC",{"$f":"D12*0.1","v":{"v":5786.623636363636,"d":"5786.62"}}]
["Indirect Cost",{"$f":"B7+B10","v":{"v":5786.623272727273,"d":"$5,786.62"}},null,{"$f":"D21","v":{"v":5300.36,"d":"$5,300.36"}}]
[{"$nulls":3},{"$f":"D14-D13","v":{"v":-486.2636363636366,"d":"$(486.26)"}}]
[]
[]
["Double-check:"]
["Fund/activity total balance",{"v":56789.35,"d":"$56,789.35"}]
["Encumbrances",{"v":1514.79,"d":"$1,514.79"}]
["Subtotal",{"$f":"SUM(B19:B20)","v":{"v":58304.14,"d":"$58,304.14"}},"BC80 sub on ITD",{"v":5300.36,"d":"$5,300.36"}]
["pending SCT",{"v":5771.56,"d":"$5,771.56"},"Subtotal pending IDC + BC80 on ITD",{"$f":"D21+B23","v":{"v":5877.516,"d":"$5,877.52"}}]
["pending IDC",{"$f":"B22*0.1","v":{"v":577.1560000000001,"d":"$577.16"}},"Projected IDC",{"$f":"B14","v":{"v":5786.623272727273,"d":"$5,786.62"}}]
[null,{"$f":"SUM(B21:B23)","v":{"v":64652.856,"d":"$64,652.86"}},"Variance",{"$f":"D23-D22","v":{"v":-90.89272727272692,"d":"$(90.89)"}}]
[null,{"$f":"B9","v":{"v":5771.56,"d":"$5,771.56"}}]
[null,{"$f":"B10","v":{"v":577.1560000000001,"d":"$577.16"}},null,{"$f":"D15+D24","v":{"v":-577.1563636363635,"d":"$(577.16)"}}]
[null,{"$f":"B2","v":{"v":1514.79,"d":"$1,514.79"}}]
[null,{"$f":"B24-SUM(B25:B27)","v":{"v":56789.35,"d":"$56,789.35"}}]