{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover Page","GC","Bucknell","BGRI Summary","Year 1","Year 2","Year 3","Year 4","Year 5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover Page","index":0,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[11,1,11,5],[16,1,16,3],[18,1,18,3],[20,0,40,6],[0,0,9,5]]}
["                                                                   BUCKNELL GEISINGER BUDGET WORKBOOK\n\nPlease provide the information below for your proposal; it will link the budget workbook to your proposal. \nDirections: To use this workbook, the Geisinger PI completes the GC tab and the Bucknell PI completes the Bucknell tab. Once entered, the workbooks will populate the BGRI Summary tab with the combined summary budget needed to submit with your proposal.",null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Proposal Title:"]
[]
["Proposal Dates:                                  Year 1:","Start Date:",null,null,"End Date:"]
["                                                                      Year 2:","Start Date:",null,null,"End Date:"]
[]
["Geisinger PI (Last Name, First Name):"]
[]
["Bucknell PI (Last Name, First Name):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Updated:"]
[null,null,null,null,null,null,null,"2023-03-06"]

{"sheet":"GC","index":1,"n_rows":165,"n_cols":46,"rows_kept":165,"cut":false,"hidden":false,"merged":[[61,9,61,10],[62,9,62,10],[63,9,63,10],[64,9,64,10],[65,9,65,10],[66,9,66,10],[67,1,67,6],[68,1,68,6],[69,1,69,6],[64,1,64,6],[65,1,65,6],[66,1,66,6],[61,11,61,12],[62,11,62,12],[63,11,63,12],[64,11,64,12],[65,11,65,12],[66,11,66,12],[67,11,67,12],[68,11,68,12],[69,11,69,12],[59,20,69,20],[98,17,99,17],[98,18,99,18],[39,0,39,6],[50,0,50,6],[53,0,53,6],[56,0,56,6],[59,0,59,6],[72,0,72,16],[73,13,74,16],[59,18,69,18],[67,9,67,10],[68,9,68,10],[69,9,69,10],[61,7,61,8],[62,7,62,8],[63,7,63,8],[64,7,64,8],[65,7,65,8],[66,7,66,8],[67,7,67,8],[68,7,68,8],[69,7,69,8],[59,7,59,8],[132,6,132,16],[71,0,71,5],[98,6,99,16],[86,6,87,8],[83,3,85,5],[80,6,81,21],[86,10,87,12],[88,10,88,16],[89,10,89,16],[90,10,90,16],[91,10,91,16],[92,10,92,16],[93,10,93,16],[94,10,94,16],[95,10,95,16],[96,10,96,16],[97,10,97,16],[86,17,87,17],[86,18,87,18],[86,19,87,19],[86,20,87,20],[86,21,87,21],[130,6,130,16],[131,6,131,16],[59,21,69,21],[98,20,99,20],[98,21,99,21],[61,13,61,14],[62,13,62,14],[63,13,63,14],[64,13,64,14],[65,13,65,14],[66,13,66,14],[67,13,67,14],[68,13,68,14],[69,13,69,14],[98,19,99,19],[61,15,61,16],[62,15,62,16],[63,15,63,16],[64,15,64,16],[65,15,65,16],[66,15,66,16],[67,15,67,16],[68,15,68,16],[69,15,69,16],[59,17,69,17],[59,19,69,19],[59,11,59,12],[59,13,59,14],[59,15,59,16],[60,7,60,8],[60,9,60,10],[60,11,60,12],[60,13,60,14],[60,15,60,16],[56,7,56,8],[56,9,56,10],[56,11,56,12],[56,13,56,14],[56,15,56,16],[57,7,57,8],[58,7,58,8],[57,9,57,10],[57,11,57,12],[57,13,57,14],[57,15,57,16],[58,9,58,10],[58,11,58,12],[58,13,58,14],[58,15,58,16],[59,9,59,10],[54,7,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[54,15,54,16],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[55,15,55,16],[1,3,3,6],[1,0,3,2],[1,7,3,12],[1,13,3,14],[3,15,3,17],[4,7,4,11],[4,12,4,16],[4,17,4,21],[53,7,53,8],[53,9,53,10],[53,11,53,12],[53,13,53,14],[53,15,53,16],[47,1,47,6],[46,1,46,6],[45,1,45,6],[30,1,30,6],[5,3,5,4],[4,0,4,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[30,11,30,12],[37,1,37,6],[58,1,58,6],[57,1,57,6],[55,1,55,6],[21,3,21,4],[22,3,22,4],[60,1,60,6],[61,1,61,6],[62,1,62,6],[63,1,63,6],[44,1,44,6],[43,1,43,6],[42,1,42,6],[41,1,41,6],[40,1,40,6],[38,1,38,6],[54,1,54,6],[52,1,52,6],[51,1,51,6],[36,1,36,6],[35,1,35,6],[33,1,33,6],[32,1,32,6],[31,1,31,6],[29,0,29,6],[6,3,6,4],[7,3,7,4],[11,3,11,4],[12,3,12,4],[16,3,16,4],[17,3,17,4],[27,0,27,16],[26,0,26,16],[28,0,28,16],[34,0,34,6],[31,13,31,14],[32,13,32,14],[33,13,33,14],[38,15,38,16],[29,13,29,14],[29,15,29,16],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[30,9,30,10],[31,9,31,10],[32,9,32,10],[33,9,33,10],[30,15,30,16],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,7,34,8],[34,9,34,10],[34,11,34,12],[34,13,34,14],[34,15,34,16],[31,11,31,12],[32,11,32,12],[33,11,33,12],[30,13,30,14],[39,7,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,14],[39,15,39,16],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[35,13,35,14],[36,13,36,14],[37,13,37,14],[38,13,38,14],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[35,15,35,16],[36,15,36,16],[37,15,37,16],[40,9,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[44,9,44,10],[45,9,45,10],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[40,15,40,16],[41,15,41,16],[44,15,44,16],[42,15,42,16],[43,15,43,16],[45,15,45,16],[48,11,48,12],[40,13,40,14],[41,13,41,14],[42,13,42,14],[43,13,43,14],[44,13,44,14],[45,13,45,14],[40,11,40,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,15,46,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[50,7,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[50,15,50,16],[46,13,46,14],[47,13,47,14],[48,13,48,14],[49,13,49,14],[49,11,49,12],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[46,11,46,12],[47,11,47,12],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[51,15,51,16],[52,7,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[52,15,52,16],[29,17,33,17],[29,18,33,18],[29,19,33,19],[29,20,33,20],[29,21,33,21],[34,17,38,17],[34,18,38,18],[34,19,38,19],[34,20,38,20],[34,21,38,21],[39,17,49,17],[39,18,49,18],[39,19,49,19],[39,20,49,20],[39,21,49,21],[50,17,52,17],[50,18,52,18],[50,19,52,19],[50,20,52,20],[50,21,52,21],[53,17,55,17],[53,18,55,18],[53,19,55,19],[53,20,55,20],[53,21,55,21],[56,17,58,17],[56,18,58,18],[56,19,58,19],[56,20,58,20],[56,21,58,21]]}
[null,null,null,null,null,{"$f":"IF(ISBLANK([1]Cover!I7),\"\",[1]Cover!I7)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5",null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Version 12",null,null,"This version will add a 3% increase to the year 1 Salary Requested for that portion that occurs in a following fiscal year.",null,null,null,"You must have valid date ranges in order for the salaries to calculate correctly.  These do not have to be full years, partial years can be used.  The smallest increment is one month.",null,null,null,null,null,null,null,"Start date(s)",null,null,null,null,null,null,"Next fiscal year start date based on cell R2",{"$f":"IF(MONTH(R$2)>6, DATEVALUE(CONCATENATE(\"7/1/\",YEAR(R$2)+1)),DATEVALUE(CONCATENATE(\"7/1/\",YEAR(R$2))))","v":"1900-07-01"},{"$f":"IF(MONTH(S$2)>6, DATEVALUE(CONCATENATE(\"7/1/\",YEAR(S$2)+1)),DATEVALUE(CONCATENATE(\"7/1/\",YEAR(S$2))))","v":"1900-07-01"},"1900-07-01","1900-07-01","1900-07-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 8.  Amount of 3% increase in Year 1 Based on 100% effort"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End date(s)",null,null,null,null,null,null,"These dates are used to increase salaries every July 1 for the remainder of the funding period."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inflation rate",null,null,null,null,null,null,null,null,null,null,null,null,"Table 5. EFFORT AS CALENDAR MONTHS"]
["Workbook Revised 08/30/2017",null,null,null,null,null,null,"Table 1. % Effort",null,null,null,null,"Table 2. Fringe Benefit Rate = 24.1%",null,null,null,null,"Table 3. Salary Requested",null,null,null,null,null,"Table 4. ANNUAL SALARIES",null,null,null,null,null,null,null,null,null,"Table 6. FRINGE BENEFIT EXPENSES",null,null,null,null,null,null,"Table 7. APPORTIONED SALARIES"]
["FTE","Omit","No h","Names of persons on project                                     (Lastname, Firstname)",null,"Role","Current Annual Salary","Year 1","Year 2","Year 3","Year 4","Year 5","Year 1","Year 2","Year 3","Year 4","Year 5","Salary Requested Year 1","Salary Requested Year 2","Salary Requested Year 3","Salary Requested Year 4","Salary Requested Year 5","Person","Year 1","Year 2","Year 3","Year 4","Year 5","Year 1","Year 2","Year 3","Year 4","Year 5","Year 1","Year 2","Year 3","Year 4","Year 5","Omit     Checkbox","No increase Checkbox","Year 1","Year 2","Year 3","Year 4","Year 5","Year 1"]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,{"$f":"G7*H7","v":0},{"$f":"G7*I7","v":0},{"$f":"+G7*J7","v":0},{"$f":"G7*K7","v":0},{"$f":"G7*L7","v":0},{"$f":"D7","v":0},{"$f":"IF($AN7=TRUE,G7,(G7+AT7))","v":0},{"$f":" IF($AN7=TRUE,$G7, (($G7+AT7)*(1+$S$4)))","v":0},{"$f":"IF($AN7=TRUE,$G7,(($G7+AT7)*(1+$S$4)*(1+$T$4)))","v":0},{"$f":"IF($AN7=TRUE,$G7,( ($G7+AT7)*(1+$S$4)*(1+$T$4)*(1+$U$4)))","v":0},{"$f":" IF($AN7=TRUE,$G7,(($G7+AT7)*(1+$S$4)*(1+$T$4)*(1+$U$4)*(1+$V$4)))","v":0},{"$f":"(ROUND((DAYS360(R$2,R$3)/30),0)/12)*H7*12","v":0},0,0,0,0,{"$f":"ROUND((M7*R7),0)","v":0},0,0,0,0,false,false,{"$f":"IF(R$3<X$2,(((DAYS360(R$2,R$3,TRUE)+1)/360)*G7),IF($AN7=TRUE,(((G7)*(((DAYS360(R$2,R$3,TRUE)+1)/360)))),(((   (G7*((DAYS360(R$2,R$3,TRUE)+1)/360))          +$AT7)))))","v":0},{"$f":"IF($AN7=TRUE,((($G7)*((DAYS360(S$2,S$3,TRUE)+1)/360))),((($G7+$AT7)*((DAYS360(S$2,S$3,TRUE)+1)/(360))*(1+S$4))))","v":0},{"$f":"IF($AN7=TRUE,((($G7)*((DAYS360(T$2,T$3,TRUE)+1)/360))),((($G7+$AT7)*((DAYS360(T$2,T$3,TRUE)+1)/(360))*(1+T$4) *(1+S$4)                   )))","v":0},{"$f":"IF($AN7=TRUE,((($G7)*((DAYS360(U$2,U$3,TRUE)+1)/360))),((($G7+$AT7)*((DAYS360(U$2,U$3,TRUE)+1)/(360))*(1+U$4) *(1+T$4)      *(1+S$4)             )))","v":0},{"$f":"IF($AN7=TRUE,((($G7)*((DAYS360(V$2,V$3,TRUE)+1)/360))),((($G7+$AT7)*((DAYS360(V$2,V$3,TRUE)+1)/(360))*(1+V$4) *(1+U$4)      *(1+T$4)       *(1+S$4)      )))","v":0},{"$f":"IF($R$3<$X$2,0,    ((G7*((DAYS360($X$2,$R$3))/(DAYS360($R$2,$R$3))))*(0.03)))","v":0}]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,{"$f":"G8*H8","v":0},{"$f":"G8*I8","v":0},{"$f":"+G8*J8","v":0},{"$f":"G8*K8","v":0},{"$f":"G8*L8","v":0},0,{"$f":"IF($AN8=TRUE,G8,(G8+AT8))","v":0},{"$f":" IF($AN8=TRUE,$G8, (($G8+AT8)*(1+$S$4)))","v":0},{"$f":"IF($AN8=TRUE,$G8,(($G8+AT8)*(1+$S$4)*(1+$T$4)))","v":0},{"$f":"IF($AN8=TRUE,$G8,( ($G8+AT8)*(1+$S$4)*(1+$T$4)*(1+$U$4)))","v":0},{"$f":" IF($AN8=TRUE,$G8,(($G8+AT8)*(1+$S$4)*(1+$T$4)*(1+$U$4)*(1+$V$4)))","v":0},0,0,0,0,0,0,0,0,0,0,false,false,{"$f":"IF(R$3<X$2,(((DAYS360(R$2,R$3,TRUE)+1)/360)*G8),IF($AN8=TRUE,(((G8)*(((DAYS360(R$2,R$3,TRUE)+1)/360)))),(((   (G8*((DAYS360(R$2,R$3,TRUE)+1)/360))          +$AT8)))))","v":0},0,0,0,0,{"$f":"IF($R$3<$X$2,0,    ((G8*((DAYS360($X$2,$R$3))/(DAYS360($R$2,$R$3))))*(0.03)))","v":0}]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,{"$f":"D15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,{"$f":"D23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,{"$f":"D24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0.24099999999999999,0,0,0,0,0,{"$f":"D25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,0,0,0,0,0]
["Total Salaries and Wages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R7:R26)","v":0},{"$f":"SUM(S7:S26)","v":0},{"$f":"SUM(T7:T26)","v":0},{"$f":"SUM(U7:U26)","v":0},{"$f":"SUM(V7:V26)","v":0},"TOTALS",{"$f":"SUM(X7:X26)","v":0},{"$f":"SUM(Y7:Y26)","v":0},{"$f":"SUM(Z7:Z26)","v":0},{"$f":"SUM(AA7:AA26)","v":0},{"$f":"SUM(AB7:AB26)","v":0},null,null,null,null,null,{"$f":"SUM(AH7:AH26)","v":0},{"$f":"SUM(AI7:AI26)","v":0},{"$f":"SUM(AJ7:AJ26)","v":0},{"$f":"SUM(AK7:AK26)","v":0},{"$f":"SUM(AL7:AL26)","v":0},null,null,{"$f":"SUM(AO7:AO26)","v":0},{"$f":"SUM(AP7:AP26)","v":0},0,0,0,0]
["FRINGE BENEFITS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[1]Additional Personnel'!R49+AH27","v":0},{"$f":"'[1]Additional Personnel'!S49+AI27","v":0},{"$f":"'[1]Additional Personnel'!T49+AJ27","v":0},{"$f":"'[1]Additional Personnel'!U49+AK27","v":0},{"$f":"'[1]Additional Personnel'!V49+AL27","v":0},null,"Color = 255,249,243"]
["TOTAL PERSONNEL COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R27:R28)","v":0},{"$f":"SUM(S27:S28)","v":0},{"$f":"SUM(T27:T28)","v":0},{"$f":"SUM(U27:U28)","v":0},{"$f":"SUM(V27:V28)","v":0}]
["Consultants",null,null,null,null,null,null,"Period 1",null,"Period 2",null,"Period 3",null,"Period 4",null,"Period 5",null,{"$f":"SUM(H31:H34)","v":0},{"$f":"SUM(J31:J34)","v":0},{"$f":"SUM(L31:L34)","v":0},{"$f":"SUM(N31:N34)","v":0},{"$f":"SUM(P31:P34)","v":0},"Notes"]
[1]
[2]
[3]
[4]
["Equipment",null,null,null,null,null,null,"Period 1",null,"Period 2",null,"Period 3",null,"Period 4",null,"Period 5",null,{"$f":"SUM(H36:H39)","v":0},{"$f":"SUM(J36:J39)","v":0},{"$f":"SUM(L36:L39)","v":0},{"$f":"SUM(N36:N39)","v":0},{"$f":"SUM(P36:P39)","v":0}]
[1]
[2]
[3]
[4,null,null,null,null,null,null," \n"]
["Materials and Supplies ",null,null,null,null,null,null,"Period 1",null,"Period 2",null,"Period 3",null,"Period 4",null,"Period 5",null,{"$f":"SUM(H41:H48)","v":0},{"$f":"SUM(J41:J48)","v":0},{"$f":"SUM(L41:L48)","v":0},{"$f":"SUM(N41:N48)","v":0},{"$f":"SUM(P41:P48)","v":0}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[]
[]
["Travel, Domestic",null,null,null,null,null,null,"Period 1",null,"Period 2",null,"Period 3",null,"Period 4",null,"Period 5",null,{"$f":"H52+H53","v":0},{"$f":"J52+J53","v":0},{"$f":"L52+L53","v":0},{"$f":"N52+N53","v":0},{"$f":"P52+P53","v":0}]
[1]
[2]
["Inpatient Care Costs",null,null,null,null,null,null,"Period 1",null,"Period 2",null,"Period 3",null,"Period 4",null,"Period 5",null,{"$f":"SUM(H55:H56)","v":0},{"$f":"J55+J56","v":0},{"$f":"L55+L56","v":0},{"$f":"N55+N56","v":0},{"$f":"P55+P56","v":0}]
[1]
[2]
["Outpatient Care Costs",null,null,null,null,null,null,"Period 1",null,"Period 2",null,"Period 3",null,"Period 4",null,"Period 5",null,{"$f":"SUM(H58:H59)","v":0},{"$f":"J58+J59","v":0},{"$f":"L58+L59","v":0},{"$f":"N58+N59","v":0},{"$f":"P58+P59","v":0}]
[4]
[5]
["Other Expenses",null,null,null,null,null,null,"Period 1",null,"Period 2",null,"Period 3",null,"Period 4",null,"Period 5",null,{"$f":"SUM(H61:H70)","v":0},{"$f":"SUM(J61:J70)","v":0},{"$f":"SUM(L61:L70)","v":0},{"$f":"SUM(N61:N70)","v":0},{"$f":"SUM(P61:P70)","v":0}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
["TOTAL DIRECT COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R29:R70)","v":0},{"$f":"SUM(S29:S70)","v":0},0,0,0]
["GEISINGER FACILITIES & ADMINISTRATIVE COSTS (Insert  rates)",null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"R133","v":0},{"$f":"S133","v":0},{"$f":"T133","v":0},{"$f":"U133","v":0},{"$f":"V133","v":0},null,null,false]
["TOTAL COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R71+R72","v":0},{"$f":"S71+S72","v":0},{"$f":"T71+T72","v":0},{"$f":"U71+U72","v":0},{"$f":"V71+V72","v":0},null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total All Years",null,null,null,"Total DC ","Total F&A","Total Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R71:V71)","v":0},{"$f":"SUM(R72:V72)","v":0},{"$f":"S75+R75","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"[1]Cover!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"F&A (Indirect Cost) Calculator"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"Be sure to indicate whether or not this project requires us to use the federal F&A rates.",null,null,"Is this a federally sponsored project or a funding agency that  requires us ",null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,true,null,null,false]
[null,null,null,null,null,null,"to use our federal F&A rate?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,"DIRECT COST CATEGORIES",null,null,null,"Check to Exclude",null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5",null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,"Salaries and wages",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y89=FALSE,R27,0)","v":0},0,0,0,0,null,null,true]
[null,null,null,null,null,null,"Fringe benefits",null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,true]
[null,null,null,null,null,null,"Consultants",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y91=FALSE,R30,0)","v":0},{"$f":"IF($Y91=FALSE,S30,0)","v":0},{"$f":"IF($Y91=FALSE,T30,0)","v":0},{"$f":"IF($Y91=FALSE,U30,0)","v":0},{"$f":"IF($Y91=FALSE,V30,0)","v":0},null,null,true]
[null,null,null,null,null,null,"Equipment",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y92=FALSE,R35,0)","v":0},{"$f":"IF($Y92=FALSE,S35,0)","v":0},{"$f":"IF($Y92=FALSE,T35,0)","v":0},{"$f":"IF($Y92=FALSE,U35,0)","v":0},{"$f":"IF($Y92=FALSE,V35,0)","v":0},null,null,true]
[null,null,null,null,null,null,"Supplies",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y93=FALSE,R40,0)","v":0},{"$f":"IF($Y93=FALSE,S40,0)","v":0},{"$f":"IF($Y93=FALSE,T40,0)","v":0},{"$f":"IF($Y93=FALSE,U40,0)","v":0},{"$f":"IF($Y93=FALSE,V40,0)","v":0},null,null,true]
[null,null,null,null,null,null,"Travel",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y94=FALSE,R51,0)","v":0},{"$f":"IF($Y94=FALSE,S51,0)","v":0},{"$f":"IF($Y94=FALSE,T51,0)","v":0},{"$f":"IF($Y94=FALSE,U51,0)","v":0},{"$f":"IF($Y94=FALSE,V51,0)","v":0},null,null,true]
[null,null,null,null,null,null,"Patient care ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y95=FALSE,R54+R57,0)","v":0},{"$f":"IF($Y95=FALSE,S54+S57,0)","v":0},{"$f":"IF($Y95=FALSE,T54+T57,0)","v":0},{"$f":"IF($Y95=FALSE,U54+U57,0)","v":0},{"$f":"IF($Y95=FALSE,V54+V57,0)","v":0},null,null,true]
[null,null,null,null,null,null,"Other expenses",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y96=FALSE,R60,0)","v":0},{"$f":"IF($Y96=FALSE,S60,0)","v":0},{"$f":"IF($Y96=FALSE,T60,0)","v":0},{"$f":"IF($Y96=FALSE,U60,0)","v":0},{"$f":"IF($Y96=FALSE,V60,0)","v":0},null,null,true]
[null,null,null,null,null,null,"Training, tuition",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y97=FALSE,#REF!,0)","v":0},{"$f":"IF($Y97=FALSE,#REF!,0)","v":0},{"$f":"IF($Y97=FALSE,#REF!,0)","v":0},{"$f":"IF($Y97=FALSE,#REF!,0)","v":0},{"$f":"IF($Y97=FALSE,#REF!,0)","v":0},null,null,true]
[null,null,null,null,null,null,"Consortium (DC and IDC)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y98=FALSE,#REF!,0)","v":0},{"$f":"IF($Y98=FALSE,#REF!,0)","v":0},{"$f":"IF($Y98=FALSE,#REF!,0)","v":0},{"$f":"IF($Y98=FALSE,#REF!,0)","v":0},{"$f":"IF($Y98=FALSE,#REF!,0)","v":0},null,null,true]
[null,null,null,null,null,null,"For federal exclusions, only the first $25,000 of each subaward is included in the F&A base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"INDIRECT COST BASE",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R89:R98)+SUM(R101:R130)","v":0},{"$f":"SUM(S89:S98)+SUM(S101:S130)","v":0},{"$f":"SUM(T89:T98)+SUM(T101:T130)","v":0},{"$f":"SUM(U89:U98)+SUM(U101:U130)","v":0},{"$f":"SUM(V89:V98)+SUM(V101:V130)","v":0}]
[null,null,null,null,null,null,"ENTER  F & A  RATE",null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,"F & A (INDIRECT) COSTS",null,null,null,null,null,null,null,null,null,null,{"$f":"R131*R132","v":0},{"$f":"S131*S132","v":0},{"$f":"T131*T132","v":0},{"$f":"U131*U132","v":0},{"$f":"V131*V132","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N6","v":0},{"$f":"[1]Consortiums!O6","v":0},{"$f":"[1]Consortiums!P6","v":0},{"$f":"[1]Consortiums!Q6","v":0},{"$f":"[1]Consortiums!R6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N7","v":0},{"$f":"[1]Consortiums!O7","v":0},{"$f":"[1]Consortiums!P7","v":0},{"$f":"[1]Consortiums!Q7","v":0},{"$f":"[1]Consortiums!R7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N8","v":0},{"$f":"[1]Consortiums!O8","v":0},{"$f":"[1]Consortiums!P8","v":0},{"$f":"[1]Consortiums!Q8","v":0},{"$f":"[1]Consortiums!R8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N9","v":0},{"$f":"[1]Consortiums!O9","v":0},{"$f":"[1]Consortiums!P9","v":0},{"$f":"[1]Consortiums!Q9","v":0},{"$f":"[1]Consortiums!R9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N10","v":0},{"$f":"[1]Consortiums!O10","v":0},{"$f":"[1]Consortiums!P10","v":0},{"$f":"[1]Consortiums!Q10","v":0},{"$f":"[1]Consortiums!R10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N11","v":0},{"$f":"[1]Consortiums!O11","v":0},{"$f":"[1]Consortiums!P11","v":0},{"$f":"[1]Consortiums!Q11","v":0},{"$f":"[1]Consortiums!R11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N12","v":0},{"$f":"[1]Consortiums!O12","v":0},{"$f":"[1]Consortiums!P12","v":0},{"$f":"[1]Consortiums!Q12","v":0},{"$f":"[1]Consortiums!R12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N13","v":0},{"$f":"[1]Consortiums!O13","v":0},{"$f":"[1]Consortiums!P13","v":0},{"$f":"[1]Consortiums!Q13","v":0},{"$f":"[1]Consortiums!R13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N14","v":0},{"$f":"[1]Consortiums!O14","v":0},{"$f":"[1]Consortiums!P14","v":0},{"$f":"[1]Consortiums!Q14","v":0},{"$f":"[1]Consortiums!R14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N15","v":0},{"$f":"[1]Consortiums!O15","v":0},{"$f":"[1]Consortiums!P15","v":0},{"$f":"[1]Consortiums!Q15","v":0},{"$f":"[1]Consortiums!R15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N16","v":0},{"$f":"[1]Consortiums!O16","v":0},{"$f":"[1]Consortiums!P16","v":0},{"$f":"[1]Consortiums!Q16","v":0},{"$f":"[1]Consortiums!R16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N17","v":0},{"$f":"[1]Consortiums!O17","v":0},{"$f":"[1]Consortiums!P17","v":0},{"$f":"[1]Consortiums!Q17","v":0},{"$f":"[1]Consortiums!R17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N18","v":0},{"$f":"[1]Consortiums!O18","v":0},{"$f":"[1]Consortiums!P18","v":0},{"$f":"[1]Consortiums!Q18","v":0},{"$f":"[1]Consortiums!R18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N19","v":0},{"$f":"[1]Consortiums!O19","v":0},{"$f":"[1]Consortiums!P19","v":0},{"$f":"[1]Consortiums!Q19","v":0},{"$f":"[1]Consortiums!R19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N20","v":0},{"$f":"[1]Consortiums!O20","v":0},{"$f":"[1]Consortiums!P20","v":0},{"$f":"[1]Consortiums!Q20","v":0},{"$f":"[1]Consortiums!R20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N21","v":0},{"$f":"[1]Consortiums!O21","v":0},{"$f":"[1]Consortiums!P21","v":0},{"$f":"[1]Consortiums!Q21","v":0},{"$f":"[1]Consortiums!R21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N22","v":0},{"$f":"[1]Consortiums!O22","v":0},{"$f":"[1]Consortiums!P22","v":0},{"$f":"[1]Consortiums!Q22","v":0},{"$f":"[1]Consortiums!R22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N23","v":0},{"$f":"[1]Consortiums!O23","v":0},{"$f":"[1]Consortiums!P23","v":0},{"$f":"[1]Consortiums!Q23","v":0},{"$f":"[1]Consortiums!R23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N24","v":0},{"$f":"[1]Consortiums!O24","v":0},{"$f":"[1]Consortiums!P24","v":0},{"$f":"[1]Consortiums!Q24","v":0},{"$f":"[1]Consortiums!R24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N25","v":0},{"$f":"[1]Consortiums!O25","v":0},{"$f":"[1]Consortiums!P25","v":0},{"$f":"[1]Consortiums!Q25","v":0},{"$f":"[1]Consortiums!R25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N26","v":0},{"$f":"[1]Consortiums!O26","v":0},{"$f":"[1]Consortiums!P26","v":0},{"$f":"[1]Consortiums!Q26","v":0},{"$f":"[1]Consortiums!R26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N27","v":0},{"$f":"[1]Consortiums!O27","v":0},{"$f":"[1]Consortiums!P27","v":0},{"$f":"[1]Consortiums!Q27","v":0},{"$f":"[1]Consortiums!R27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N28","v":0},{"$f":"[1]Consortiums!O28","v":0},{"$f":"[1]Consortiums!P28","v":0},{"$f":"[1]Consortiums!Q28","v":0},{"$f":"[1]Consortiums!R28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N29","v":0},{"$f":"[1]Consortiums!O29","v":0},{"$f":"[1]Consortiums!P29","v":0},{"$f":"[1]Consortiums!Q29","v":0},{"$f":"[1]Consortiums!R29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N30","v":0},{"$f":"[1]Consortiums!O30","v":0},{"$f":"[1]Consortiums!P30","v":0},{"$f":"[1]Consortiums!Q30","v":0},{"$f":"[1]Consortiums!R30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N31","v":0},{"$f":"[1]Consortiums!O31","v":0},{"$f":"[1]Consortiums!P31","v":0},{"$f":"[1]Consortiums!Q31","v":0},{"$f":"[1]Consortiums!R31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N32","v":0},{"$f":"[1]Consortiums!O32","v":0},{"$f":"[1]Consortiums!P32","v":0},{"$f":"[1]Consortiums!Q32","v":0},{"$f":"[1]Consortiums!R32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N33","v":0},{"$f":"[1]Consortiums!O33","v":0},{"$f":"[1]Consortiums!P33","v":0},{"$f":"[1]Consortiums!Q33","v":0},{"$f":"[1]Consortiums!R33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N34","v":0},{"$f":"[1]Consortiums!O34","v":0},{"$f":"[1]Consortiums!P34","v":0},{"$f":"[1]Consortiums!Q34","v":0},{"$f":"[1]Consortiums!R34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Consortiums!N35","v":0},{"$f":"[1]Consortiums!O35","v":0},{"$f":"[1]Consortiums!P35","v":0},{"$f":"[1]Consortiums!Q35","v":0},{"$f":"[1]Consortiums!R35","v":0}]

{"sheet":"Bucknell","index":2,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,9,0,13],[1,9,1,13],[4,9,4,13],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[0,0,0,7],[1,0,1,7],[4,0,4,4]]}
["Bucknell Geisinger Research Initiative",null,null,null,null,null,null,null,null,"Criteria"]
["Grant Proposal Budget",null,null,null,null,null,null,null,null,"Funding will be initially targeted to a maximum of $100,000 for one year of support.  "]
[]
[]
["Contact Your Office of Sponsored Projects for Assistance",null,null,null,null,null,"Enter data",null,null,"Funding may be categorized according to the following:"]
[]
[null,null,null,null,null,null,null,null,null,"Stage I:  Collaborative developmental projects"]
["Project Dates:",null,null,"through",null,null,"Category #:",null,null,"requiring one-year support at the < $20,000 level (up to $20,000 total)"]
[]
[null,null,null,null,null,"Year 1","Year 2","Total",null,"Stage II: annual support at the < $50,000 level (up to $100,000 total)"]
["SALARIES/WAGES"]
["  Senior Personnel:",null,"Name",null,"# Months",null,null,null,null,"Funding for these opportunities  may support:"]
[null,"BU Co-PI - Summer ",null,null,null,null,null,{"$f":"SUM(F13:G13)","v":0},null,"  -  Faculty"]
[null,"BU Co-PI - Acad Yr ",null,null,null,null,null,0,null,"  -  Scientists"]
[null,"BU Co-PI - Summer ",null,null,null,null,null,0,null,"  -  Staff"]
[null,"BU Co-PI - Acad Yr ",null,null,null,null,null,0,null,"  -  Students"]
[]
["  Other Personnel:",null,null,null,"# Students"]
[null,"BU Graduate Students - Summer",null,null,null,null,null,{"$f":"SUM(F19:G19)","v":0}]
[null,"BU Graduate Students - Acad Yr",null,null,null,null,null,{"$f":"SUM(F20:G20)","v":0}]
[null,"BU Undergraduate Students - Summer",null,null,null,null,null,{"$f":"SUM(F21:G21)","v":0}]
[null,"BU Undergraduate Students - Acad Yr",null,null,null,null,null,{"$f":"SUM(F22:G22)","v":0}]
[null,"Total Salaries/Wages",null,null,null,{"$f":"SUM(F13:F22)","v":0},{"$f":"SUM(G13:G22)","v":0},{"$f":"SUM(H13:H22)","v":0}]
[]
["FRINGE BENEFITS"]
[null,"BU Co-PI - Summer ",null,null,null,{"$f":"ROUND(F13*$M$27,0)","v":0},{"$f":"ROUND(G13*$M$27,0)","v":0},{"$f":"SUM(F26:G26)","v":0},null,null,null,"Full-Time","Summer"]
[null,"BU Co-PI - Acad Yr ",null,null,null,{"$f":"ROUND(F14*$L$27,0)","v":0},{"$f":"ROUND(G14*$L$27,0)","v":0},0,null,null,"Bucknell Rates:",0.32600000000000001,6.8000000000000005E-2]
[null,"BU Co-PI - Summer ",null,null,null,{"$f":"ROUND(F15*$M$27,0)","v":0},{"$f":"ROUND(G15*$M$27,0)","v":0},0]
[null,"BU Co-PI - Acad Yr ",null,null,null,{"$f":"ROUND(F16*$L$27,0)","v":0},{"$f":"ROUND(G16*$L$27,0)","v":0},0]
[null,"BU Graduate Students - Summer",null,null,null,{"$f":"ROUND(F19*$M$27,0)","v":0},{"$f":"ROUND(G19*$M$27,0)","v":0},0]
[null,"BU Graduate Students - Acad Yr",null,null,null,{"$f":"ROUND(F20*0,0)","v":0},{"$f":"ROUND(G20*0,0)","v":0},0]
[null,"BU Undergraduate Students - Summer",null,null,null,{"$f":"ROUND(F21*$M$27,0)","v":0},{"$f":"ROUND(G21*$M$27,0)","v":0},0]
[null,"BU Undergraduate Students - Acad Yr",null,null,null,{"$f":"ROUND(F22*0,0)","v":0},{"$f":"ROUND(G22*0,0)","v":0},0]
[null,"Total Fringe Benefits",null,null,null,{"$f":"SUM(F26:F33)","v":0},{"$f":"SUM(G26:G33)","v":0},{"$f":"SUM(H26:H33)","v":0}]
[]
["TOTAL SALARIES, WAGES & BENEFITS",null,null,null,null,{"$f":"F23+F34","v":0},{"$f":"G23+G34","v":0},{"$f":"H23+H34","v":0}]
[]
["TRAVEL",null,null,null,null,null,null,{"$f":"SUM(F38:G38)","v":0}]
[]
["EQUIPMENT",null,null,null,null,null,null,{"$f":"SUM(F40:G40)","v":0}]
[]
["OTHER DIRECT COSTS"]
[null,"Materials & Supplies",null,null,null,null,null,{"$f":"SUM(F43:G43)","v":0}]
[null,"Publication/Dissemination",null,null,null,null,null,{"$f":"SUM(F44:G44)","v":0}]
[null,"Consultant Services",null,null,null,null,null,{"$f":"SUM(F45:G45)","v":0}]
[null,"Other - ",null,null,null,null,null,{"$f":"SUM(F46:G46)","v":0}]
[null,"Other - ",null,null,null,null,null,{"$f":"SUM(F47:G47)","v":0}]
[null,"Total Other Direct Costs",null,null,null,{"$f":"SUM(F43:F47)","v":0},{"$f":"SUM(G43:G47)","v":0},{"$f":"SUM(H43:H47)","v":0}]
[]
["TOTAL COSTS",null,null,null,null,{"$f":"F36+F38+F40+F48","v":0},{"$f":"G36+G38+G40+G48","v":0},{"$f":"H36+H38+H40+H48","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(F50:G50)-H50","v":0}]

{"sheet":"BGRI Summary","index":3,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[1,1,1,3]]}
["BGRI Summary Budget"]
["Project Title:",{"$f":"'Cover Page'!$B$12","v":0}]
["BU PI:",{"$f":"'Cover Page'!$B$19","v":0}]
["GC PI:",{"$f":"'Cover Page'!$B$17","v":0}]
[]
["Summary Totals by Institution","Year 1","Year 2"]
["                                           From",{"$f":"'Cover Page'!$C$14","v":"00:00:00"},{"$f":"'Cover Page'!$C$15","v":"00:00:00"}]
["                                           To",{"$f":"'Cover Page'!$F$14","v":"00:00:00"},{"$f":"'Cover Page'!$F$15","v":"00:00:00"},"Total"]
["Bucknell:",{"$f":"Bucknell!$F$50","v":0},{"$f":"Bucknell!$G$50","v":0},{"$f":"B9+C9","v":0}]
["Geisinger Clinic:",{"$f":"GC!$R$71","v":0},{"$f":"GC!$S$71","v":0},{"$f":"B10+C10","v":0}]
["      Total Direct Costs:",{"$f":"B9+B10","v":0},{"$f":"C9+C10","v":0},{"$f":"D9+D10","v":0}]
[]
["Summary Totals by Category","Year 1","Year 2"]
["                                           From",{"$f":"'Cover Page'!$C$14","v":"00:00:00"},{"$f":"'Cover Page'!$C$15","v":"00:00:00"}]
["                                           To",{"$f":"'Cover Page'!$F$14","v":"00:00:00"},{"$f":"'Cover Page'!$F$15","v":"00:00:00"},"Total"]
["Personnel ",{"$f":"GC!$R$27+Bucknell!$F$23","v":0},{"$f":"GC!$S$27+Bucknell!$G$23","v":0},{"$f":"B16+C16","v":0}]
["Fringe Benefits",{"$f":"GC!$R$28+Bucknell!$F$34","v":0},{"$f":"GC!$S$28+Bucknell!$G$34","v":0},0]
["Consultant(s)",{"$f":"GC!$R$30+Bucknell!$F$45","v":0},{"$f":"GC!$S$30+Bucknell!$G$45","v":0},0]
["Equipment",{"$f":"GC!$R$35+Bucknell!$F$40","v":0},{"$f":"GC!$S$35+Bucknell!$G$40","v":0},0]
["Travel",{"$f":"GC!$R$51+Bucknell!$F$38","v":0},{"$f":"GC!$S$51+Bucknell!$G$38","v":0},0]
["Patient Care",{"$f":"GC!$R$54+GC!$R$57","v":0},{"$f":"GC!$S$54+GC!$S$57","v":0},0]
["Supplies & Other Expenses",{"$f":"GC!$R$40+GC!$R$60+Bucknell!$F$43+Bucknell!$F$44+Bucknell!$F$46+Bucknell!$F$47","v":0},{"$f":"GC!$S$40+GC!$S$60+Bucknell!$G$43+Bucknell!$G$44+Bucknell!$G$46+Bucknell!$G$47","v":0},0]
["       Total Direct Costs:",{"$f":"SUM(B16:B22)","v":0},{"$f":"SUM(C16:C22)","v":0},0]

{"sheet":"Year 1","index":4,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[null,null,"Y E A R   1      B U D G E T E D    E X P E N S E S"]
["Salaries and wages",null,"2009-08-01",{"$f":"DATE(YEAR(C2),MONTH(C2)+1,DAY(C2))","v":"2009-09-01"},{"$f":"DATE(YEAR(D2),MONTH(D2)+1,DAY(D2))","v":"2009-10-01"},"2009-11-01","2009-12-01","2010-01-01","2010-02-01","2010-03-01","2010-04-01","2010-05-01","2010-06-01","2010-07-01","Total"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C3:N3)","v":0}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Salaries and Wages",null,{"$f":"SUM(C3:C12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Fringe Benefits",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C13*$B$14","v":{"$error":"#REF!"}},{"$f":"D13*$B$14","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Consultant(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL SUPPLIES",null,{"$f":"SUM(C17:C21)","v":0},{"$f":"SUM(D17:D21)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Patient Care"]
["Inpatient",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C25:N25)","v":0}]
["Outpatient",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Alterations and Renovations",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other","BRDC",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Computing fee",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"IT data pull",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Publication fees",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL OTHER",null,{"$f":"SUM(C28:C32)","v":0},{"$f":"SUM(D28:D32)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["CONSORTIUM Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["SUBTOTAL DIRECT COSTS",null,{"$f":"C13+C14+C15+C16+C22+C23+C25+C26+C27+C33+C34","v":{"$error":"#REF!"}},{"$f":"D13+D14+D15+D16+D22+D23+D25+D26+D27+D33+D34","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["CONSORTIUM  F & A (indirect) COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL DIRECT COSTS",null,{"$f":"SUM(C35:C36)","v":{"$error":"#REF!"}},{"$f":"SUM(D35:D36)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["INDIRECT",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"($B$38)*C35","v":{"$error":"#REF!"}},{"$f":"($B$38)*D35","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["T O T A L   C O S T S ",null,{"$f":"SUM(C37:C38)","v":{"$error":"#REF!"}},{"$f":"SUM(D37:D38)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Year 2","index":5,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[null,null,"Y E A R  2      B U D G E T E D    E X P E N S E S"]
["Salaries and wages",null,"1990-07-01",{"$f":"DATE(YEAR(C2),MONTH(C2)+1,DAY(C2))","v":"1990-08-01"},"1990-09-01","1990-10-01","1990-11-01","1990-12-01","1991-01-01","1991-02-01","1991-03-01","1991-04-01","1991-05-01","1991-06-01","Total"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C3:N3)","v":0}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Salaries and Wages",null,{"$f":"SUM(C3:C12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Fringe Benefits",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C13*$B$14","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Consultant(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL SUPPLIES",null,{"$f":"SUM(C17:C21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C23:N23)","v":0}]
["Patient Care"]
["Inpatient",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C25:N25)","v":0}]
["Outpatient",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Alterations and Renovations",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL OTHER",null,{"$f":"SUM(C28:C32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["CONSORTIUM Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C34:N34)","v":0}]
["SUBTOTAL DIRECT COSTS",null,{"$f":"C13+C14+C15+C16+C22+C23+C25+C26+C27+C33+C34","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["CONSORTIUM  F & A (indirect) COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL DIRECT COSTS",null,{"$f":"SUM(C35:C36)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["INDIRECT",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"($B$38)*C35","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["T O T A L   C O S T S ",null,{"$f":"SUM(C37:C38)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Year 3","index":6,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[null,null,"Y E A R  3      B U D G E T E D    E X P E N S E S"]
["Salaries and wages",null,"1990-07-01",{"$f":"DATE(YEAR(C2),MONTH(C2)+1,DAY(C2))","v":"1990-08-01"},"1990-09-01","1990-10-01","1990-11-01","1990-12-01","1991-01-01","1991-02-01","1991-03-01","1991-04-01","1991-05-01","1991-06-01","Total"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C3:N3)","v":0}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Salaries and Wages",null,{"$f":"SUM(C3:C12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Fringe Benefits",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C13*$B$14","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Consultant(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL SUPPLIES",null,{"$f":"SUM(C17:C21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C23:N23)","v":0}]
["Patient Care"]
["Inpatient",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C25:N25)","v":0}]
["Outpatient",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Alterations and Renovations",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL OTHER",null,{"$f":"SUM(C28:C32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["CONSORTIUM Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C34:N34)","v":0}]
["SUBTOTAL DIRECT COSTS",null,{"$f":"C13+C14+C15+C16+C22+C23+C25+C26+C27+C33+C34","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["CONSORTIUM  F & A (indirect) COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL DIRECT COSTS",null,{"$f":"SUM(C35:C36)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["INDIRECT",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"($B$38)*C35","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["T O T A L   C O S T S ",null,{"$f":"SUM(C37:C38)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Year 4","index":7,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[null,null,"Y E A R   4      B U D G E T E D    E X P E N S E S"]
["Salaries and wages",null,"1990-07-01",{"$f":"DATE(YEAR(C2),MONTH(C2)+1,DAY(C2))","v":"1990-08-01"},"1990-09-01","1990-10-01","1990-11-01","1990-12-01","1991-01-01","1991-02-01","1991-03-01","1991-04-01","1991-05-01","1991-06-01","Total"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C3:N3)","v":0}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Salaries and Wages",null,{"$f":"SUM(C3:C12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Fringe Benefits",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C13*$B$14","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Consultant(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL SUPPLIES",null,{"$f":"SUM(C17:C21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C23:N23)","v":0}]
["Patient Care"]
["Inpatient",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C25:N25)","v":0}]
["Outpatient",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Alterations and Renovations",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL OTHER",null,{"$f":"SUM(C28:C32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["CONSORTIUM Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C34:N34)","v":0}]
["SUBTOTAL DIRECT COSTS",null,{"$f":"C13+C14+C15+C16+C22+C23+C25+C26+C27+C33+C34","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["CONSORTIUM  F & A (indirect) COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL DIRECT COSTS",null,{"$f":"SUM(C35:C36)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["INDIRECT",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"($B$38)*C35","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["T O T A L   C O S T S ",null,{"$f":"SUM(C37:C38)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Year 5","index":8,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[null,null,"Y E A R   5      B U D G E T E D    E X P E N S E S"]
["Salaries and wages",null,"1990-07-01",{"$f":"DATE(YEAR(C2),MONTH(C2)+1,DAY(C2))","v":"1990-08-01"},"1990-09-01","1990-10-01","1990-11-01","1990-12-01","1991-01-01","1991-02-01","1991-03-01","1991-04-01","1991-05-01","1991-06-01","Total"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C3:N3)","v":0}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Salaries and Wages",null,{"$f":"SUM(C3:C12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Fringe Benefits",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C13*$B$14","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Consultant(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL SUPPLIES",null,{"$f":"SUM(C17:C21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C23:N23)","v":0}]
["Patient Care"]
["Inpatient",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C25:N25)","v":0}]
["Outpatient",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Alterations and Renovations",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL OTHER",null,{"$f":"SUM(C28:C32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["CONSORTIUM Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C34:N34)","v":0}]
["SUBTOTAL DIRECT COSTS",null,{"$f":"C13+C14+C15+C16+C22+C23+C25+C26+C27+C33+C34","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["CONSORTIUM  F & A (indirect) COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL DIRECT COSTS",null,{"$f":"SUM(C35:C36)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["INDIRECT",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"($B$38)*C35","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["T O T A L   C O S T S ",null,{"$f":"SUM(C37:C38)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]