{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Welcome","Introduction","Budget and Financial Report","Instructions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"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":"Welcome","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,1,2,7],[3,1,3,7],[5,1,5,7]]}
[]
[]
[null,"Budget and Financial Report Template"]
[null,"Council on Library and Information Resources"]
[]
[null,"If a security icon such as those shown below appears when opening the spreadsheet, please click on \"Enable Editing,\" \"Enable Content,\" \"Options,\" or equivalent to enable the template's macros. "]

{"sheet":"Introduction","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":true,"merged":[[5,0,5,4],[12,1,14,6],[16,1,17,6],[2,1,2,6],[1,1,1,6]]}
[]
[null,"Budget and Financial Report Template"]
[null,"Council on Library and Information Resources"]
[]
[]
["Select Project Duration*",null,null,null,null,"One Year"]
[]
[]
[]
[]
[]
[]
["*","The selected project duration will determine the number of reporting periods generated in the budget template.  Reporting periods are one year long (except in cases where the final months of a multi-year project do not add up to a full year). "]

{"sheet":"Budget and Financial Report","index":2,"n_rows":88,"n_cols":25,"rows_kept":88,"cut":false,"hidden":true,"merged":[[21,23,21,24],[9,23,9,24],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[7,23,7,24],[6,23,6,24],[8,23,8,24],[13,23,13,24],[13,12,13,13],[13,14,13,15],[13,16,13,17],[85,23,85,24],[85,6,85,7],[85,8,85,9],[85,10,85,11],[85,12,85,13],[85,14,85,15],[85,16,85,17],[85,18,85,19],[85,20,85,21],[13,20,13,21],[87,0,94,3],[13,18,13,19],[85,4,85,5],[13,2,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[85,2,85,3],[10,3,10,6],[11,0,11,6],[1,23,5,24],[2,0,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
["CLIR DIGITIZING HIDDEN COLLECTIONS BUDGET AND FINANCIAL REPORT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This budget and financial report has been reviewed and approved by the following individual who has institutional responsibility for financial reporting (12):"]
["GRANT INFORMATION",null,null,null,"Summary of Expenses by Category"]
["Organization Name (1):",null,null,null,null,null,"Budgeted","Actual"]
["Grant Title (2):",null,null,null,"Salaries/wages",null,{"$f":"SUMIF($A$24:$A$83,\"Salaries/Wages\",$X$24:$X$83)","v":0},{"$f":"SUMIF($A$24:$A$83,\"Salaries/Wages\",$Y$24:$Y$83)","v":0}]
["Grant Start Date (3):",null,null,null,"Fringe benefits",null,{"$f":"SUMIF($A$24:$A$83,\"Fringe benefits\",$X$24:$X$83)","v":0},{"$f":"SUMIF($A$24:$A$83,\"Fringe benefits\",$Y$24:$Y$83)","v":0}]
["Grant End Date (4):",null,null,null,"Consultant/training fees",null,{"$f":"SUMIF($A$24:$A$83,\"Consultant/training fees\",$X$24:$X$83)","v":0},{"$f":"SUMIF($A$24:$A$83,\"Consultant/training fees\",$Y$24:$Y$83)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:"]
["Requested Amount (5):",null,null,null,"Supplies and materials",null,{"$f":"SUMIF($A$24:$A$83,\"Supplies/materials\",$X$24:$X$83)","v":0},{"$f":"SUMIF($A$24:$A$83,\"Supplies/materials\",$Y$24:$Y$83)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:"]
["Awarded Amount (6):",null,null,null,"Services",null,{"$f":"SUMIF($A$24:$A$83,\"Services\",$X$24:$X$83)","v":0},{"$f":"SUMIF($A$24:$A$83,\"Services\",$Y$24:$Y$83)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:"]
["Reference Number (7):",null,null,null,"Other costs",null,{"$f":"SUMIF($A$24:$A$83,\"Other costs\",$X$24:$X$83)","v":0},{"$f":"SUMIF($A$24:$A$83,\"Other costs\",$Y$24:$Y$83)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
["Cells shaded gray contain formulas that cannot be edited. Hover over red numbered items for additional guidance (also located in “Instructions” tab).*"]
[]
[null,null,"Reporting Period I (8)",null,"Reporting Period II (8)",null,"Reporting Period III (8)",null,"Reporting Period IV (8)",null,"Reporting Period V (8)",null,"Reporting Period VI (8)",null,"Reporting Period VII (8)",null,"Reporting Period VIII (8)",null,"Reporting Period IX (8)",null,"Reporting Period X (8)",null,null,"Total Grant Period"]
[null,null,"MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY","MM/DD/YYYY",null,{"$f":"IF(MIN(A15:W15)=0,\"MM/DD/YYYY\",MIN(A15:W15))","v":"MM/DD/YYYY"},{"$f":"IF(MAX(A15:W15)=0,\"MM/DD/YYYY\",MAX(A15:W15))","v":"MM/DD/YYYY"}]
["Description",null,"Budgeted","Actual","Budgeted","Actual","Budgeted","Actual","Budgeted","Actual","Budgeted","Actual","Budgeted","Actual","Budgeted","Actual","Budgeted","Actual","Budgeted","Actual","Budgeted","Actual",null,"Budgeted","Actual"]
["Opening Balance",null,{"$f":"B8","v":0},{"$f":"B9","v":0},{"$f":"C20","v":0},0,0,0,0,0,0,0,{"$f":"K20","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"C17","v":0},{"$f":"D17","v":0}]
["Investment Income (9)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(A18:W18,$A$16:$W$16,\"Actual\")","v":0}]
["Total Expenses",null,{"$f":"C85","v":0},0,0,0,{"$f":"G85","v":0},0,{"$f":"I85","v":0},0,{"$f":"K85","v":0},{"$f":"L85","v":0},{"$f":"M85","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIFS(A19:W19,$A$16:$W$16,\"Budgeted\")","v":0},{"$f":"SUMIFS(A19:W19,$A$16:$W$16,\"Actual\")","v":0}]
["Closing Balance",null,{"$f":"C17+C18-C19","v":0},0,0,0,0,0,0,0,0,0,{"$f":"M17+M18-M19","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"X17+X18-X19","v":0},{"$f":"Y17+Y18-Y19","v":0}]
[]
["Category (10):","Expenses (11):"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(A24:W24,$A$16:$W$16,\"Budgeted\")","v":0},{"$f":"SUMIFS(A24:W24,$A$16:$W$16,\"Actual\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(A56:W56,$A$16:$W$16,\"Budgeted\")","v":0},{"$f":"SUMIFS(A56:W56,$A$16:$W$16,\"Actual\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[null,"Total Expenses:",{"$f":"SUM(C23:C84)","v":0},{"$f":"SUM(D23:D84)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M23:M84)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(X23:X84)","v":0},{"$f":"SUM(Y23:Y84)","v":0}]
[null,"Variance:",{"$f":"D85-C85","v":0},null,{"$f":"F85-E85","v":0},null,{"$f":"H85-G85","v":0},null,{"$f":"J85-I85","v":0},null,{"$f":"L85-K85","v":0},null,{"$f":"N85-M85","v":0},null,{"$f":"P85-O85","v":0},null,{"$f":"R85-Q85","v":0},null,{"$f":"T85-S85","v":0},null,{"$f":"V85-U85","v":0},null,null,{"$f":"Y85-X85","v":0}]
[]
["*This worksheet should be used both for proposal budgets (budgets submitted with the grant proposal) and for interim and final financial reports on approved grants.  Grantees should save the budget worksheet submitted with the grant proposal and update the “Actual” columns in the same worksheet for each Reporting Period.  After the proposal budget is approved, categories of expenses and funding sources and amounts in the “Budgeted” columns cannot be changed absent the prior written approval of CLIR."]

{"sheet":"Instructions","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}