{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["template","example"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"template","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,1,6],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[36,1,36,6],[25,1,25,6],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[37,1,37,2],[38,1,38,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[32,1,32,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[19,1,19,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[7,1,7,6],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6],[6,0,6,2]]}
[]
["Complete the budget template below by filling in the shaded cells. This template uses formulas to automatically calculate totals. Do not alter the formatting or formulas in unshaded cells. Rows may be added to accommodate additional personnel or funding sources, if necessary. An example is included on the next worksheet. Contact grants@cdfa.ca.gov for help filling out this template."]
[]
["Project Title:"]
["Project Leader(s) and Organization:"]
[]
[null,null,null,2015,2016,2017,"Total"]
["A.","PERSONNEL (name, role, % based on full time salary)"]
[null,"Salary"]
[null,null,null,null,null,null,{"$f":"SUM(D10:F10)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D11:F11)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D12:F12)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D13:F13)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D14:F14)","v":0}]
[null,"Salary Total",null,{"$f":"SUM(D10:D14)","v":0},{"$f":"SUM(E10:E14)","v":0},0,{"$f":"SUM(G8:G14)","v":0}]
[null,"Benefits"]
[null,null,null,null,null,null,{"$f":"SUM(D17:F17)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D18:F18)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D19:F19)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D20:F20)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D21:F21)","v":0}]
[null,"Benefits Total",null,{"$f":"SUM(D17:D21)","v":0},{"$f":"SUM(E17:E21)","v":0},0,0]
[]
[null,"Personnel Cost (A)",null,{"$f":"D15+D22","v":0},{"$f":"E15+E22","v":0},0,0]
[]
["B.","OPERATING EXPENSES"]
[null,"Supplies",null,null,null,null,{"$f":"SUM(D27:F27)","v":0}]
[null,"Equipment",null,null,null,null,{"$f":"SUM(D28:F28)","v":0}]
[null,"Travel",null,null,null,null,{"$f":"SUM(D29:F29)","v":0}]
[null,"Professional/Consultant Services",null,null,null,null,{"$f":"SUM(D30:F30)","v":0}]
[null,"Other Expenses",null,null,null,null,{"$f":"SUM(D31:F31)","v":0}]
[null,"Indirect Cost",null,{"$f":"10/100*D24","v":0},{"$f":"10/100*E24","v":0},0]
[null,"Operating Cost (B)",null,{"$f":"SUM(D27:D32)","v":0},{"$f":"SUM(E27:E32)","v":0},0,{"$f":"SUM(G27:G31)","v":0}]
[]
[null,"TOTAL GRANT REQUEST (A+B)",null,{"$f":"D24+D33","v":0},{"$f":"E24+E33","v":0},{"$f":"F24+F33","v":0},{"$f":"G24+G33","v":0}]
[]
["C.","OTHER FUNDING SOURCES"]
[null,null,null,null,null,null,{"$f":"SUM(D38:F38)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D39:F39)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D40:F40)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D41:F41)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D42:F42)","v":0}]
[null,"TOTAL OTHER FUNDING (C)",null,{"$f":"SUM(D38:D42)","v":0},{"$f":"SUM(E38:E42)","v":0},0,0]
[]
[]
[]
[null,"TOTAL PROJECT BUDGET (A+B+C)",null,{"$f":"D24+D33+D43","v":0},{"$f":"E24+E33+E43","v":0},{"$f":"F24+F33+F43","v":0},{"$f":"G24+G33+G43","v":0}]

{"sheet":"example","index":1,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[34,1,34,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,6],[33,1,33,2],[21,1,21,6],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[10,1,10,2],[1,0,1,1],[1,2,1,6],[2,0,2,1],[2,2,2,6],[4,0,4,2],[5,1,5,6],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2]]}
[]
["Project Title:",null,"XYZ Dairy Digester Research Project"]
["Project Leader(s) and Organization:",null,"Jane Scientist and Sam Researcher"]
[]
[null,null,null,2015,2016,2017,"Total"]
["A.","PERSONNEL (name, role, % based on full time salary)"]
[null,"Salary"]
[null,"Jane Scientist, project leader (14%)",null,7580,7580,7580,{"$f":"SUM(D8:F8)","v":22740}]
[null,"Sam Researcher, project manager (14%)",null,6293,6293,6293,{"$f":"SUM(D9:F9)","v":18879}]
[null,"Sally Student graduate researcher (50%)",null,18000,18000,18000,{"$f":"SUM(D10:F10)","v":54000}]
[null,null,null,null,null,null,{"$f":"SUM(D11:F11)","v":0}]
[null,"Salary Total",null,{"$f":"SUM(D8:D11)","v":31873},{"$f":"SUM(E8:E11)","v":31873},31873,95619]
[null,"Benefits"]
[null,"Jane Scientist, project leader (20%)",null,1516,1516,1516,{"$f":"SUM(D14:F14)","v":4548}]
[null,"Sam Researcher, project manager (36%)",null,2266,2266,2266,{"$f":"SUM(D15:F15)","v":6798}]
[null,"Sally Student, graduate researcher (50%)",null,10000,10000,10000,{"$f":"SUM(D16:F16)","v":30000}]
[null,null,null,null,null,null,{"$f":"SUM(D17:F17)","v":0}]
[null,"Benefits Total",null,{"$f":"SUM(D14:D17)","v":13782},{"$f":"SUM(E14:E17)","v":13782},{"$f":"SUM(F14:F17)","v":13782},{"$f":"SUM(G14:G17)","v":41346}]
[]
[null,"Personnel Cost (A)",null,{"$f":"D12+D18","v":45655},{"$f":"E12+E18","v":45655},{"$f":"F12+F18","v":45655},{"$f":"G12+G18","v":136965}]
[]
["B.","OPERATING EXPENSES"]
[null,"Supplies",null,2000,2000,2000,{"$f":"SUM(D23:F23)","v":6000}]
[null,"Equipment",null,0,0,0,{"$f":"SUM(D24:F24)","v":0}]
[null,"Travel",null,5650,5650,5650,{"$f":"SUM(D25:F25)","v":16950}]
[null,"Professional/Consultant Services",null,4000,4000,4000,{"$f":"SUM(D26:F26)","v":12000}]
[null,"Other Expenses",null,12300,12300,12300,{"$f":"SUM(D27:F27)","v":36900}]
[null,"Indirect Cost",null,{"$f":"10/100*D20","v":4565.5},{"$f":"10/100*E20","v":4565.5},4565.5]
[null,"Operating Cost (B)",null,{"$f":"SUM(D23:D28)","v":28515.5},{"$f":"SUM(E23:E28)","v":28515.5},{"$f":"SUM(F23:F28)","v":28515.5},{"$f":"SUM(G23:G27)","v":71850}]
[]
[null,"TOTAL CDFA FUNDING REQUESTED (A+B)",null,{"$f":"D20+D29","v":74170.5},{"$f":"E20+E29","v":74170.5},{"$f":"F20+F29","v":74170.5},{"$f":"G20+G29","v":208815}]
[]
["C.","OTHER FUNDING SOURCES"]
[null,"ABC Federal Grant",null,10000,10000,10000,{"$f":"SUM(D34:F34)","v":30000}]
[null,null,null,null,null,null,{"$f":"SUM(D35:F35)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D36:F36)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D37:F37)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D38:F38)","v":0}]
[null,"TOTAL OTHER FUNDING (C)",null,{"$f":"SUM(D34:D38)","v":10000},{"$f":"SUM(E34:E38)","v":10000},10000,30000]
[]
[]
[]
[null,"TOTAL PROJECT BUDGET (A+B+C)",null,{"$f":"D20+D29+D39","v":84170.5},{"$f":"E20+E29+E39","v":84170.5},{"$f":"F20+F29+F39","v":84170.5},{"$f":"G20+G29+G39","v":238815}]