{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Category Budget","Lists"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":"Instructions","index":0,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,0,4,4],[15,0,15,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[8,0,8,4],[5,0,5,4],[34,0,34,4],[35,0,35,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,4],[25,0,25,4],[29,0,29,4],[30,0,30,4],[31,0,31,4],[32,0,32,4],[0,2,0,4],[33,0,33,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[7,0,7,4],[26,0,26,4],[27,0,27,4],[9,0,9,4],[10,0,10,4],[11,0,11,4],[12,0,12,4],[13,0,13,4],[14,0,14,4],[28,0,28,4]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 01/12/2022"},null,{"$f":"CONCATENATE('Category Budget'!$B$1,\" \",'Category Budget'!$E$1)","v":" "},null,null,null,null,null,null,"SANDBOX AREA (highlighted in light red)- For rough work associated with the print area to the left.  Rough work may include, notes, calculations, derivations, etc."]
["Workbook Instructions (Federal Cost Share)"]
["Input Data:  Enter information as required in all cells highlighted in Blue."]
["Restricted Editing:  All cells not highlighted in Blue are locked from editing.  Locked cells include:  cells with formulas highlighted in Gray or Light Yellow, cells with no color fill (white), etc."]
["For the Agreement Budget Template ONLY:  Colored Tabs:\nThe \"Equipment\" and \"Subrecipients & Vendors\" budget category tabs are colored ORANGE to indicate that line item details can be entered for these budget categories.  The other budget category tabs (Direct Labor, Fringe Benefits, Travel, Materials & Misc., and Indirect Costs & Profit) only contain category totals."]
["Regarding Confidential Information:  Avoid disclosing trade secrets and confidential information on any agreement document, since these documents are publicly accessible."]
["Rules for decimal places on values:"]
["·         Budget and Invoice values:"]
["o   Rounding of any values, as described below, should be performed using standard rounding practices."]
["o   For all currency rates (e.g., Direct Labor, and Unit Cost):  Round to the cent ($0.01)."]
["o   For all percentage rates (e.g., Fringe Benefits, Indirect Cost, and Profit):  Round to a maximum of two decimal places of a percent (e.g., 25.12%).  You can round to less if desired, such as one decimal place (e.g., 25.1%), or zero decimal places (e.g., 25%)."]
["o   For all quantity values (e.g., # of hours, # of months, and # of units):  Round to a maximum of two decimal places (e.g., 50.12).  You can round to less if desired, such as one decimal place (e.g., 50.1), or zero decimal places (e.g., 50)."]
["·         Budget values:"]
["o   For entered and totaled (via calculation) CEC, Federal and Other Funding share budget values:  Round to the dollar ($1)."]
["o   For all calculated currency values (e.g., rate x hours, rate x months, base amount, and rate x base amount):  Round to the dollar ($1)."]
["·         Invoice values:"]
["o   For entered and totaled (via calculation) CEC, Federal and Other Funding share expense invoice values:  Round to the cent ($0.01)."]
["o   For all calculated currency values (e.g., rate x hours, rate x months, base amount, and rate x base amount):  Round to the cent ($0.01)."]
["o   SPECIAL CIRCUMSTANCE for calculated currency values:  ONLY if a calculated value (e.g., rate x hours = actual labor expense) does NOT equal the actual expense, because of the decimal place rules provided for rates and quantity values listed above, it is acceptable to use as many decimal places as necessary for rates and quantity values listed above to ensure that the calculated value DOES equal the actual expense."]
["Invoice Supporting Documentation Requirements, per Budget Category:"]
["The list below contains the supporting documentation that is required to be submitted with an invoice.  IMPORTANT:  The recipient and subrecipients must still retain supporting documentation for all project expenses in case of an audit (“supporting documents” are also known as “backup documents”)."]
["o   Direct Labor – No supporting documentation required with invoice."]
["o   Fringe Benefits – No supporting documentation required with invoice."]
["o   Travel - Receipts are required only for: Lodging, Airfare, Rental car (including gasoline expenses), Bus/train."]
["o   Equipment – 1) For equipment that is equal to or greater than $100,000 per line item total (including both CEC and Match Funds), documentation showing the payment terms must be provided to the CAM. 2)  CAM must be able to verify equipment purchases for: 1) equipment with a per line item incurred cost of $500,000 or greater; or 2) a single equipment vendor with $500,000 or more in equipment incurred costs. See Invoice Review Checklist for methods to verify."]
["o   Materials & Miscellaneous – Receipt required for any line item total that is $5,000 or more."]
["o   Subrecipients & Vendors – Major subrecipients (Budget of 100k or more) follow the same budget requirements as the Recipient when submitting an invoice. For Minor subrecipients and Vendors, subrecipient or vendor invoice required."]
["o   Indirect Costs & Profit – No supporting documentation required with invoice."]
["Adding Rows:  If additional rows are needed within a section, unhide the hidden rows (i.e., select the row directly above and below the hidden rows, then right-click the selection and select “Unhide”).  Hide any unused rows.  DO NOT USE THE LAST TWO ROWS THAT ARE MARKED “CEC USE ONLY”.  If all but the last 2 rows are used, and more rows are required, please contact the ECAMS Support team (ECAMS.Support@energy.ca.gov)."]
["FOR ECAMS SUPPORT TEAM ONLY:  ADDING ROWS:\nTo add additional rows and maintain the formulas within the totals, (1) unprotect the sheet, (2) copy the second to the last row in the section, (3) insert the copied row just above the last row, (4) repeat steps 2 - 3 as required, (5) correct formatting and REFERENCE IDs as required, (6) delete “CEC USE ONLY” from all but the last two rows in the section, and (7) re-protect the sheet."]
["Updating Modification Date on Budgets:\nAfter making modifications to a budget file, update the modification date as described below."]
["o   Budget Worksheet file – Update the \"Date of Last Budget Worksheet Modification\" to the date the modifications were completed.  Update the \"Date of Last Budget Worksheet Modification\" in cell D1 of the \"Category Budget\" tab–this updates the rest of the tabs in the template."]
["o   Agreement Budget file – Update the \"Date of Last Approved Agreement Budget Modification\" to the date the modifications were approved.  Update the \"Date of Last Approved Agreement Budget Modification\" in cell D1 of the \"Category Budget\" tab–this updates the rest of the tabs in the template."]
["FOR ECAMS SUPPORT TEAM ONLY:  UPDATING \"TEMPLATE VERSION\" DATE:\nAfter making modifications to a budget or invoice template, update the \"Template Version\" date to the date the modifications were completed.  For the budget templates, update the \"Template Version\" date in cell A1 of the \"Category Budget\" tab–this updates the rest of the tabs in the template.  For the invoice templates, update the \"Template Version\" date in cell A1 of the \"Invoice Payment Cover Sheet\" tab–this updates the rest of the tabs in the template."]
["ECAMS Support:  For support on how to complete this template, please visit the ECAMS Resources web page.  The link to this web page is provided in the cell below:"]
["https://www.energy.ca.gov/funding-opportunities/funding-resources/ecams-resources"]

{"sheet":"Category Budget","index":1,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,10,2,18],[3,10,6,13],[3,15,6,18],[0,1,0,3],[5,0,5,4],[6,0,6,4],[3,1,3,4],[1,0,1,4],[4,1,4,4],[2,0,2,4]]}
["Template Version 01/12/2022",null,null,null,null,null,null,null,null,"SANDBOX AREA (highlighted in light red)- For rough work associated with the print area to the left.  Rough work may include, notes, calculations, derivations, etc."]
["PROPOSAL BUDGET (Federal Cost Share)"]
["Category Budget",null,null,null,null,null,null,null,null,null,"\"Category Budget\" value check, below, to use to ensure that values match between budget files when converting or updating budget files."]
["Agreement Number","XXX-XX-XXX",null,null,null,null,null,null,null,null,"Paste values in Blue cells below from \"Category Budget\" tab of the budget file that you want to compare against (such as another Budget Worksheet file, an Agreement Budget file, or an old budget file that you want to convert to the new templates).",null,null,null,null,"The formulas in the cells below compare the \"Category Budget\" values of the other budget file with those of this budget file.  Values that match from both budget files will receive a \"Pass\" result.  Values that DO NOT match from both budget files will receive a \"Fail\" result, which will become conditionally formatted to red."]
["Name of Organization","Organization Name"]
["Select Recipient or Subrecipient"]
["Select your company's California Business Certifications"]
["Cost Category","CEC Share","Federal Share","Other Funding Share","Total",null,null,null,null,null,"CEC Share","Federal Share","Other Funding Share","Total",null,"CEC Share","Federal Share","Other Funding Share","Total"]
["Direct Labor",0,0,0,{"$f":"SUM(ROUND(B9:D9,0))","v":0},null,null,null,null,null,0,0,0,0,null,{"$f":"IF(B9=K9,\"Pass\",\"Fail\")","v":"Pass"},{"$f":"IF(C9=L9,\"Pass\",\"Fail\")","v":"Pass"},{"$f":"IF(D9=M9,\"Pass\",\"Fail\")","v":"Pass"},{"$f":"IF(E9=N9,\"Pass\",\"Fail\")","v":"Pass"}]
["Fringe Benefits",0,0,0,{"$f":"SUM(ROUND(B10:D10,0))","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Total Labor",{"$f":"SUM(ROUND(B9:B10,0))","v":0},{"$f":"SUM(ROUND(C9:C10,0))","v":0},{"$f":"SUM(ROUND(D9:D10,0))","v":0},{"$f":"SUM(ROUND(B11:D11,0))","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Travel",0,0,0,{"$f":"SUM(ROUND(B12:D12,0))","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Equipment",0,0,0,{"$f":"SUM(ROUND(B13:D13,0))","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Materials/Miscellaneous",0,0,0,{"$f":"SUM(ROUND(B14:D14,0))","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Subrecipients/Vendors",0,0,0,{"$f":"SUM(ROUND(B15:D15,0))","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Total Other Direct Costs",{"$f":"SUM(ROUND(B12:B15,0))","v":0},{"$f":"SUM(ROUND(C12:C15,0))","v":0},{"$f":"SUM(ROUND(D12:D15,0))","v":0},{"$f":"SUM(ROUND(B16:D16,0))","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Indirect Costs",0,0,0,{"$f":"SUM(ROUND(B17:D17,0))","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Profit \n(not allowed for grant recipients)",0,0,0,{"$f":"SUM(ROUND(B18:D18,0))","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Total Indirect and Profit",{"$f":"SUM(ROUND(B17:B18,0))","v":0},{"$f":"SUM(ROUND(C17:C18,0))","v":0},{"$f":"SUM(ROUND(D17:D18,0))","v":0},{"$f":"SUM(ROUND(B19:D19,0))","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Grand Totals",{"$f":"B11+B16+B19","v":0},{"$f":"C11+C16+C19","v":0},{"$f":"D11+D16+D19","v":0},{"$f":"SUM(ROUND(B20:D20,0))","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Total CEC Reimbursable Funds Spent in California or Paid to California-Based Entities \n(if applicable)",0,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(B21=K21,\"Pass\",\"Fail\")","v":"Pass"}]
["Percentage of CEC Reimbursable Funds Spent in California or Paid to California-Based Entities",{"$f":"IF(B21=0,\"\",(ROUND(B21,0)/B20))","v":""},null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(B22=K22,\"Pass\",\"Fail\")","v":"Fail"}]

{"sheet":"Lists","index":2,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 01/12/2022"}]
["Recipient/Subrecipient"]
["Select Recipient or Subrecipient"]
["Recipient"]
["Subrecipient"]
[]
[]
["CA Business Certifications"]
["Select your company's California Business Certifications"]
["Small Business"]
["Micro Business"]
["Disabled Veteran Business Enterprise (DVBE)"]
["Small Business and Micro Business"]
["Small Business and Disabled Veteran Business Enterprise (DVBE)"]
["Micro Business and Disabled Veteran Business Enterprise (DVBE)"]
["None"]
[]
[]
["Indirect Cost Options"]
["Select an Indirect Cost Rate Option"]
["DCAA Rate"]
["CEC De Minimis Rate"]
["Recipient's Rate (From Cost Allocation Plan)"]