{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Category Budget","Direct Labor","Fringe Benefits","Travel","Equipment","Materials & Misc.","Subrecipients & Vendors","Indirect Costs & Profit","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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 2/17/2023"},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"]
["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 and Match 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 and Match 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. Travel Form required for all travel included on an invoice"]
["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":24,"n_cols":19,"rows_kept":24,"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 2/17/2023",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"]
["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."]
["Grant Funding Number","GFO-25-603",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","ABC company"]
["Select Recipient or Subrecipient"]
["Select your organization's California Business Certifications"]
["Cost Category","CEC Share","[Other Entity] Share","Match Share","Total",null,null,null,null,null,"CEC Share",{"$f":"C8","v":"[Other Entity] Share"},"Match Share","Total",null,"CEC Share",{"$f":"C8","v":"[Other Entity] Share"},"Match Share","Total"]
["Direct Labor",{"$f":"'Direct Labor'!E215","v":0},{"$f":"'Direct Labor'!F215","v":0},{"$f":"'Direct Labor'!G215","v":0},{"$f":"'Direct Labor'!H215","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",{"$f":"'Fringe Benefits'!E106","v":0},{"$f":"'Fringe Benefits'!F106","v":0},{"$f":"'Fringe Benefits'!G106","v":0},{"$f":"'Fringe Benefits'!H106","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Total Labor",{"$f":"SUM(B9:B10)","v":0},{"$f":"SUM(C9:C10)","v":0},{"$f":"SUM(D9:D10)","v":0},{"$f":"SUM(E9:E10)","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Travel",{"$f":"Travel!G56","v":0},{"$f":"Travel!H56","v":0},{"$f":"Travel!I56","v":0},{"$f":"Travel!J56","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Equipment",{"$f":"Equipment!I208","v":0},{"$f":"Equipment!J208","v":0},{"$f":"Equipment!K208","v":0},{"$f":"Equipment!L208","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Materials/Miscellaneous",{"$f":"'Materials & Misc.'!I208","v":0},{"$f":"'Materials & Misc.'!J208","v":0},{"$f":"'Materials & Misc.'!K208","v":0},{"$f":"'Materials & Misc.'!L208","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Subrecipients/Vendors",{"$f":"'Subrecipients & Vendors'!G115","v":0},{"$f":"'Subrecipients & Vendors'!H115","v":0},{"$f":"'Subrecipients & Vendors'!I115","v":0},{"$f":"'Subrecipients & Vendors'!J115","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Total Other Direct Costs",{"$f":"SUM(B12:B15)","v":0},{"$f":"SUM(C12:C15)","v":0},{"$f":"SUM(D12:D15)","v":0},{"$f":"SUM(E12:E15)","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Indirect Costs",{"$f":"'Indirect Costs & Profit'!L148","v":0},{"$f":"'Indirect Costs & Profit'!M148","v":0},{"$f":"'Indirect Costs & Profit'!N148","v":0},{"$f":"'Indirect Costs & Profit'!O148","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Profit \n(not allowed for grant recipients)",{"$f":"'Indirect Costs & Profit'!L159","v":0},{"$f":"'Indirect Costs & Profit'!M159","v":0},{"$f":"'Indirect Costs & Profit'!N159","v":0},{"$f":"'Indirect Costs & Profit'!O159","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Total Indirect and Profit",{"$f":"SUM(B17:B18)","v":0},{"$f":"SUM(C17:C18)","v":0},{"$f":"SUM(D17:D18)","v":0},{"$f":"SUM(E17:E18)","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":"E11+E16+E19","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)",{"$f":"ROUND(B20*0.99,0)","v":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,\"\",B21/B20)","v":""},null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(B22=K22,\"Pass\",\"Fail\")","v":"Fail"}]
[]
[null,null,null,null,null,null,null,null,null,null,"Other Entity Share?"]

{"sheet":"Direct Labor","index":2,"n_rows":215,"n_cols":13,"rows_kept":215,"cut":false,"hidden":false,"merged":[[214,0,214,3],[210,0,210,3],[213,0,213,3],[212,0,212,7],[0,6,0,7],[108,0,108,7],[0,0,0,1],[106,0,106,3],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 2/17/2023"},null,null,null,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"]
["Direct Labor (Unloaded)"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"GFO-25-603:  ABC company"}]
["Hourly Rates"]
["Job Classification","Highest Estimated Labor Rate \n($ per hour)","# of Hours","Rate x Hours","CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
[null,0,0,{"$f":"ROUND(B7*C7,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E7:G7,0))","v":0}]
[null,0,0,{"$f":"ROUND(B8*C8,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E8:G8,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E9:G9,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E10:G10,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E11:G11,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E12:G12,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E13:G13,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E14:G14,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E15:G15,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E16:G16,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E17:G17,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E18:G18,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E19:G19,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E20:G20,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E21:G21,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E22:G22,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E23:G23,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E24:G24,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E25:G25,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E26:G26,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E27:G27,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E28:G28,0))","v":0}]
[null,0,0,{"$f":"ROUND(B29*C29,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E29:G29,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E30:G30,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E31:G31,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E32:G32,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E33:G33,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E34:G34,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E35:G35,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E36:G36,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E37:G37,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E38:G38,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E39:G39,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E40:G40,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E41:G41,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E42:G42,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E43:G43,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E44:G44,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E45:G45,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E46:G46,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E47:G47,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E48:G48,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E49:G49,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E50:G50,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E51:G51,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E52:G52,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E53:G53,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E54:G54,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E55:G55,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E56:G56,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E57:G57,0))","v":0}]
[null,0,0,{"$f":"ROUND(B58*C58,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E58:G58,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E59:G59,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E60:G60,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E61:G61,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E62:G62,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E63:G63,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E64:G64,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E65:G65,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E66:G66,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E67:G67,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E68:G68,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E69:G69,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E70:G70,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E71:G71,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E72:G72,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E73:G73,0))","v":0}]
[null,0,0,{"$f":"ROUND(B74*C74,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E74:G74,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E75:G75,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E76:G76,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E77:G77,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E78:G78,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E79:G79,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E80:G80,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E81:G81,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E82:G82,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E83:G83,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E84:G84,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E85:G85,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E86:G86,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E87:G87,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E88:G88,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E89:G89,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E90:G90,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E91:G91,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E92:G92,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E93:G93,0))","v":0}]
[null,0,0,{"$f":"ROUND(B94*C94,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E94:G94,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E95:G95,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E96:G96,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E97:G97,0))","v":0}]
[null,0,0,{"$f":"ROUND(B98*C98,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E98:G98,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E99:G99,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E100:G100,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E101:G101,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E102:G102,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E103:G103,0))","v":0}]
[null,0,0,{"$f":"ROUND(B104*C104,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E104:G104,0))","v":0}]
["CEC USE ONLY",0,0,{"$f":"ROUND(B105*C105,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E105:G105,0))","v":0}]
["CEC USE ONLY",0,0,0,0,0,0,{"$f":"SUM(ROUND(E106:G106,0))","v":0}]
["Hourly Direct Labor Totals",null,null,null,{"$f":"SUM(ROUND(E7:E106,0))","v":0},{"$f":"SUM(ROUND(F7:F106,0))","v":0},{"$f":"SUM(ROUND(G7:G106,0))","v":0},{"$f":"SUM(H7:H106)","v":0}]
[]
["Monthly Salary Rates"]
["Job Classification","Highest Estimated Labor Rate \n($ per month)","# of Months","Rate x Months","CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
[null,0,0,{"$f":"ROUND(B111*C111,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E111:G111,0))","v":0}]
[null,0,0,{"$f":"ROUND(B112*C112,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E112:G112,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E113:G113,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E114:G114,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E115:G115,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E116:G116,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E117:G117,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E118:G118,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E119:G119,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E120:G120,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E121:G121,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E122:G122,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E123:G123,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E124:G124,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E125:G125,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E126:G126,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E127:G127,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E128:G128,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E129:G129,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E130:G130,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E131:G131,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E132:G132,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E133:G133,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E134:G134,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E135:G135,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E136:G136,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E137:G137,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E138:G138,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E139:G139,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E140:G140,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E141:G141,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E142:G142,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E143:G143,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E144:G144,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E145:G145,0))","v":0}]
[null,0,0,{"$f":"ROUND(B146*C146,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E146:G146,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E147:G147,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E148:G148,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E149:G149,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E150:G150,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E151:G151,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E152:G152,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E153:G153,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E154:G154,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E155:G155,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E156:G156,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E157:G157,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E158:G158,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E159:G159,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E160:G160,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E161:G161,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E162:G162,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E163:G163,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E164:G164,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E165:G165,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E166:G166,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E167:G167,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E168:G168,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E169:G169,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E170:G170,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E171:G171,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E172:G172,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E173:G173,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E174:G174,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E175:G175,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E176:G176,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E177:G177,0))","v":0}]
[null,0,0,{"$f":"ROUND(B178*C178,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E178:G178,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E179:G179,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E180:G180,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E181:G181,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E182:G182,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E183:G183,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E184:G184,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E185:G185,0))","v":0}]
[null,0,0,{"$f":"ROUND(B186*C186,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E186:G186,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E187:G187,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E188:G188,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E189:G189,0))","v":0}]
[null,0,0,{"$f":"ROUND(B190*C190,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E190:G190,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E191:G191,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E192:G192,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E193:G193,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E194:G194,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E195:G195,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E196:G196,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E197:G197,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E198:G198,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E199:G199,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E200:G200,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E201:G201,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E202:G202,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E203:G203,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E204:G204,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E205:G205,0))","v":0}]
[null,0,0,{"$f":"ROUND(B206*C206,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E206:G206,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E207:G207,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E208:G208,0))","v":0}]
["CEC USE ONLY",0,0,0,0,0,0,{"$f":"SUM(ROUND(E209:G209,0))","v":0}]
["CEC USE ONLY",0,0,0,0,0,0,{"$f":"SUM(ROUND(E210:G210,0))","v":0}]
["Monthly Direct Labor Totals",null,null,null,{"$f":"SUM(ROUND(E111:E210,0))","v":0},{"$f":"SUM(ROUND(F111:F210,0))","v":0},{"$f":"SUM(ROUND(G111:G210,0))","v":0},{"$f":"SUM(H111:H210)","v":0}]
[]
["Direct Labor Grand Totals"]
[null,null,null,null,"CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["Grand Totals",null,null,null,{"$f":"E107+E211","v":0},{"$f":"F107+F211","v":0},{"$f":"G107+G211","v":0},{"$f":"H107+H211","v":0}]

{"sheet":"Fringe Benefits","index":3,"n_rows":106,"n_cols":13,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,6,0,7],[105,0,105,1],[1,0,1,7],[2,0,2,7],[3,0,3,7]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 2/17/2023"},null,null,null,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"]
["Fringe Benefits"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"GFO-25-603:  ABC company"}]
["Job Classification","Highest Estimated Fringe Benefit Rate (%)","Direct Labor Costs ($)","Rate x Costs","CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
[null,0,0,{"$f":"ROUND(B6*C6,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E6:G6,0))","v":0}]
[null,0,0,{"$f":"ROUND(B7*C7,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E7:G7,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E8:G8,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E9:G9,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E10:G10,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E11:G11,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E12:G12,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E13:G13,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E14:G14,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E15:G15,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E16:G16,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E17:G17,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E18:G18,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E19:G19,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E20:G20,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E21:G21,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E22:G22,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E23:G23,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E24:G24,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E25:G25,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E26:G26,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E27:G27,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E28:G28,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E29:G29,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E30:G30,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E31:G31,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E32:G32,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E33:G33,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E34:G34,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E35:G35,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E36:G36,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E37:G37,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E38:G38,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E39:G39,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E40:G40,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E41:G41,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E42:G42,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E43:G43,0))","v":0}]
[null,0,0,{"$f":"ROUND(B44*C44,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E44:G44,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E45:G45,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E46:G46,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E47:G47,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E48:G48,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E49:G49,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E50:G50,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E51:G51,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E52:G52,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E53:G53,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E54:G54,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E55:G55,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E56:G56,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E57:G57,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E58:G58,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E59:G59,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E60:G60,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E61:G61,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E62:G62,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E63:G63,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E64:G64,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E65:G65,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E66:G66,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E67:G67,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E68:G68,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E69:G69,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E70:G70,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E71:G71,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E72:G72,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E73:G73,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E74:G74,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E75:G75,0))","v":0}]
[null,0,0,{"$f":"ROUND(B76*C76,0)","v":0},0,0,0,{"$f":"SUM(ROUND(E76:G76,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E77:G77,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E78:G78,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E79:G79,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E80:G80,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E81:G81,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E82:G82,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E83:G83,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E84:G84,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E85:G85,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E86:G86,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E87:G87,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E88:G88,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E89:G89,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E90:G90,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E91:G91,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E92:G92,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E93:G93,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E94:G94,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E95:G95,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E96:G96,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E97:G97,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E98:G98,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E99:G99,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E100:G100,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E101:G101,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E102:G102,0))","v":0}]
[null,0,0,0,0,0,0,{"$f":"SUM(ROUND(E103:G103,0))","v":0}]
["CEC USE ONLY",0,0,0,0,0,0,{"$f":"SUM(ROUND(E104:G104,0))","v":0}]
["CEC USE ONLY",0,0,0,0,0,0,{"$f":"SUM(ROUND(E105:G105,0))","v":0}]
["Grand Totals",null,{"$f":"SUM(ROUND(C6:C105,0))","v":0},{"$f":"SUM(ROUND(D6:D105,0))","v":0},{"$f":"SUM(ROUND(E6:E105,0))","v":0},{"$f":"SUM(ROUND(F6:F105,0))","v":0},{"$f":"SUM(ROUND(G6:G105,0))","v":0},{"$f":"SUM(H6:H105)","v":0}]

{"sheet":"Travel","index":4,"n_rows":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,0,59,9],[0,0,0,2],[55,0,55,5],[1,0,1,9],[2,0,2,9],[3,0,3,9],[0,8,0,9]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 2/17/2023"},null,null,null,null,null,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"]
["Travel"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"GFO-25-603:  ABC company"}]
["Reference ID","Task #","Traveler Name and Job  Classification","Dates of Travel (From/To)","Departure and Destination","Trip Purpose","CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["T-1",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G6:I6,0))","v":0}]
["T-2",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G7:I7,0))","v":0}]
["T-3",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G8:I8,0))","v":0}]
["T-4",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G9:I9,0))","v":0}]
["T-5",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G10:I10,0))","v":0}]
["T-6",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G11:I11,0))","v":0}]
["T-7",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G12:I12,0))","v":0}]
["T-8",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G13:I13,0))","v":0}]
["T-9",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G14:I14,0))","v":0}]
["T-10",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G15:I15,0))","v":0}]
["T-11",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G16:I16,0))","v":0}]
["T-12",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G17:I17,0))","v":0}]
["T-13",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G18:I18,0))","v":0}]
["T-14",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G19:I19,0))","v":0}]
["T-15",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G20:I20,0))","v":0}]
["T-16",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G21:I21,0))","v":0}]
["T-17",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G22:I22,0))","v":0}]
["T-18",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G23:I23,0))","v":0}]
["T-19",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G24:I24,0))","v":0}]
["T-20",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G25:I25,0))","v":0}]
["T-21",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G26:I26,0))","v":0}]
["T-22",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G27:I27,0))","v":0}]
["T-23",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G28:I28,0))","v":0}]
["T-24",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G29:I29,0))","v":0}]
["T-25",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G30:I30,0))","v":0}]
["T-26",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G31:I31,0))","v":0}]
["T-27",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G32:I32,0))","v":0}]
["T-28",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G33:I33,0))","v":0}]
["T-29",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G34:I34,0))","v":0}]
["T-30",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G35:I35,0))","v":0}]
["T-31",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G36:I36,0))","v":0}]
["T-32",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G37:I37,0))","v":0}]
["T-33",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G38:I38,0))","v":0}]
["T-34",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G39:I39,0))","v":0}]
["T-35",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G40:I40,0))","v":0}]
["T-36",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G41:I41,0))","v":0}]
["T-37",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G42:I42,0))","v":0}]
["T-38",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G43:I43,0))","v":0}]
["T-39",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G44:I44,0))","v":0}]
["T-40",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G45:I45,0))","v":0}]
["T-41",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G46:I46,0))","v":0}]
["T-42",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G47:I47,0))","v":0}]
["T-43",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G48:I48,0))","v":0}]
["T-44",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G49:I49,0))","v":0}]
["T-45",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G50:I50,0))","v":0}]
["T-46",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G51:I51,0))","v":0}]
["T-47",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G52:I52,0))","v":0}]
["T-48",null,null,null,null,null,0,0,0,{"$f":"SUM(ROUND(G53:I53,0))","v":0}]
["T-49",null,"CEC USE ONLY",null,null,null,0,0,0,{"$f":"SUM(ROUND(G54:I54,0))","v":0}]
["T-50",null,"CEC USE ONLY",null,null,null,0,0,0,{"$f":"SUM(ROUND(G55:I55,0))","v":0}]
["Grand Totals",null,null,null,null,null,{"$f":"SUM(ROUND(G6:G55,0))","v":0},{"$f":"SUM(ROUND(H6:H55,0))","v":0},{"$f":"SUM(ROUND(I6:I55,0))","v":0},{"$f":"SUM(J6:J55)","v":0}]
[]
[]
[]
["Travel Form required for all travel included on an invoice"]

{"sheet":"Equipment","index":5,"n_rows":208,"n_cols":17,"rows_kept":208,"cut":false,"hidden":false,"merged":[[207,0,207,7],[3,0,3,11],[2,0,2,11],[0,10,0,11],[0,0,0,2],[1,0,1,11]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 2/17/2023"},null,null,null,null,null,null,null,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"]
["Equipment"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"GFO-25-603:  ABC company"}]
["Reference ID","Task #","Seller of item(s)","Description","Purpose","# of Units","Unit Cost","Total:  \n# of Units x Unit Cost","CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["E-1",null,null,null,null,0,0,{"$f":"IF(OR(F6=\"Redacted\",G6=\"Redacted\"),\"Redacted\",IF(OR(T(F6)<>\"\",T(G6)<>\"\"),\"Varies\",ROUND(F6*G6,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I6:K6,0))","v":0}]
["E-2",null,null,null,null,0,0,{"$f":"IF(OR(F7=\"Redacted\",G7=\"Redacted\"),\"Redacted\",IF(OR(T(F7)<>\"\",T(G7)<>\"\"),\"Varies\",ROUND(F7*G7,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I7:K7,0))","v":0}]
["E-3",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I8:K8,0))","v":0}]
["E-4",null,null,null,null,0,0,{"$f":"IF(OR(F9=\"Redacted\",G9=\"Redacted\"),\"Redacted\",IF(OR(T(F9)<>\"\",T(G9)<>\"\"),\"Varies\",ROUND(F9*G9,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I9:K9,0))","v":0}]
["E-5",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I10:K10,0))","v":0}]
["E-6",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I11:K11,0))","v":0}]
["E-7",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I12:K12,0))","v":0}]
["E-8",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I13:K13,0))","v":0}]
["E-9",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I14:K14,0))","v":0}]
["E-10",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I15:K15,0))","v":0}]
["E-11",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I16:K16,0))","v":0}]
["E-12",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I17:K17,0))","v":0}]
["E-13",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I18:K18,0))","v":0}]
["E-14",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I19:K19,0))","v":0}]
["E-15",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I20:K20,0))","v":0}]
["E-16",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I21:K21,0))","v":0}]
["E-17",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I22:K22,0))","v":0}]
["E-18",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I23:K23,0))","v":0}]
["E-19",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I24:K24,0))","v":0}]
["E-20",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I25:K25,0))","v":0}]
["E-21",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I26:K26,0))","v":0}]
["E-22",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I27:K27,0))","v":0}]
["E-23",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I28:K28,0))","v":0}]
["E-24",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I29:K29,0))","v":0}]
["E-25",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I30:K30,0))","v":0}]
["E-26",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I31:K31,0))","v":0}]
["E-27",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I32:K32,0))","v":0}]
["E-28",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I33:K33,0))","v":0}]
["E-29",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I34:K34,0))","v":0}]
["E-30",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I35:K35,0))","v":0}]
["E-31",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I36:K36,0))","v":0}]
["E-32",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I37:K37,0))","v":0}]
["E-33",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I38:K38,0))","v":0}]
["E-34",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I39:K39,0))","v":0}]
["E-35",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I40:K40,0))","v":0}]
["E-36",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I41:K41,0))","v":0}]
["E-37",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I42:K42,0))","v":0}]
["E-38",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I43:K43,0))","v":0}]
["E-39",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I44:K44,0))","v":0}]
["E-40",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I45:K45,0))","v":0}]
["E-41",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I46:K46,0))","v":0}]
["E-42",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I47:K47,0))","v":0}]
["E-43",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I48:K48,0))","v":0}]
["E-44",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I49:K49,0))","v":0}]
["E-45",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I50:K50,0))","v":0}]
["E-46",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I51:K51,0))","v":0}]
["E-47",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I52:K52,0))","v":0}]
["E-48",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I53:K53,0))","v":0}]
["E-49",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I54:K54,0))","v":0}]
["E-50",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I55:K55,0))","v":0}]
["E-51",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I56:K56,0))","v":0}]
["E-52",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I57:K57,0))","v":0}]
["E-53",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I58:K58,0))","v":0}]
["E-54",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I59:K59,0))","v":0}]
["E-55",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I60:K60,0))","v":0}]
["E-56",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I61:K61,0))","v":0}]
["E-57",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I62:K62,0))","v":0}]
["E-58",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I63:K63,0))","v":0}]
["E-59",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I64:K64,0))","v":0}]
["E-60",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I65:K65,0))","v":0}]
["E-61",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I66:K66,0))","v":0}]
["E-62",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I67:K67,0))","v":0}]
["E-63",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I68:K68,0))","v":0}]
["E-64",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I69:K69,0))","v":0}]
["E-65",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I70:K70,0))","v":0}]
["E-66",null,null,null,null,0,0,{"$f":"IF(OR(F71=\"Redacted\",G71=\"Redacted\"),\"Redacted\",IF(OR(T(F71)<>\"\",T(G71)<>\"\"),\"Varies\",ROUND(F71*G71,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I71:K71,0))","v":0}]
["E-67",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I72:K72,0))","v":0}]
["E-68",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I73:K73,0))","v":0}]
["E-69",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I74:K74,0))","v":0}]
["E-70",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I75:K75,0))","v":0}]
["E-71",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I76:K76,0))","v":0}]
["E-72",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I77:K77,0))","v":0}]
["E-73",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I78:K78,0))","v":0}]
["E-74",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I79:K79,0))","v":0}]
["E-75",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I80:K80,0))","v":0}]
["E-76",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I81:K81,0))","v":0}]
["E-77",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I82:K82,0))","v":0}]
["E-78",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I83:K83,0))","v":0}]
["E-79",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I84:K84,0))","v":0}]
["E-80",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I85:K85,0))","v":0}]
["E-81",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I86:K86,0))","v":0}]
["E-82",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I87:K87,0))","v":0}]
["E-83",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I88:K88,0))","v":0}]
["E-84",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I89:K89,0))","v":0}]
["E-85",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I90:K90,0))","v":0}]
["E-86",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I91:K91,0))","v":0}]
["E-87",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I92:K92,0))","v":0}]
["E-88",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I93:K93,0))","v":0}]
["E-89",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I94:K94,0))","v":0}]
["E-90",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I95:K95,0))","v":0}]
["E-91",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I96:K96,0))","v":0}]
["E-92",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I97:K97,0))","v":0}]
["E-93",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I98:K98,0))","v":0}]
["E-94",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I99:K99,0))","v":0}]
["E-95",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I100:K100,0))","v":0}]
["E-96",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I101:K101,0))","v":0}]
["E-97",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I102:K102,0))","v":0}]
["E-98",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I103:K103,0))","v":0}]
["E-99",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I104:K104,0))","v":0}]
["E-100",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I105:K105,0))","v":0}]
["E-101",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I106:K106,0))","v":0}]
["E-102",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I107:K107,0))","v":0}]
["E-103",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I108:K108,0))","v":0}]
["E-104",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I109:K109,0))","v":0}]
["E-105",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I110:K110,0))","v":0}]
["E-106",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I111:K111,0))","v":0}]
["E-107",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I112:K112,0))","v":0}]
["E-108",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I113:K113,0))","v":0}]
["E-109",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I114:K114,0))","v":0}]
["E-110",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I115:K115,0))","v":0}]
["E-111",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I116:K116,0))","v":0}]
["E-112",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I117:K117,0))","v":0}]
["E-113",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I118:K118,0))","v":0}]
["E-114",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I119:K119,0))","v":0}]
["E-115",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I120:K120,0))","v":0}]
["E-116",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I121:K121,0))","v":0}]
["E-117",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I122:K122,0))","v":0}]
["E-118",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I123:K123,0))","v":0}]
["E-119",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I124:K124,0))","v":0}]
["E-120",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I125:K125,0))","v":0}]
["E-121",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I126:K126,0))","v":0}]
["E-122",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I127:K127,0))","v":0}]
["E-123",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I128:K128,0))","v":0}]
["E-124",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I129:K129,0))","v":0}]
["E-125",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I130:K130,0))","v":0}]
["E-126",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I131:K131,0))","v":0}]
["E-127",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I132:K132,0))","v":0}]
["E-128",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I133:K133,0))","v":0}]
["E-129",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I134:K134,0))","v":0}]
["E-130",null,null,null,null,0,0,{"$f":"IF(OR(F135=\"Redacted\",G135=\"Redacted\"),\"Redacted\",IF(OR(T(F135)<>\"\",T(G135)<>\"\"),\"Varies\",ROUND(F135*G135,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I135:K135,0))","v":0}]
["E-131",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I136:K136,0))","v":0}]
["E-132",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I137:K137,0))","v":0}]
["E-133",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I138:K138,0))","v":0}]
["E-134",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I139:K139,0))","v":0}]
["E-135",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I140:K140,0))","v":0}]
["E-136",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I141:K141,0))","v":0}]
["E-137",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I142:K142,0))","v":0}]
["E-138",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I143:K143,0))","v":0}]
["E-139",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I144:K144,0))","v":0}]
["E-140",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I145:K145,0))","v":0}]
["E-141",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I146:K146,0))","v":0}]
["E-142",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I147:K147,0))","v":0}]
["E-143",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I148:K148,0))","v":0}]
["E-144",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I149:K149,0))","v":0}]
["E-145",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I150:K150,0))","v":0}]
["E-146",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I151:K151,0))","v":0}]
["E-147",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I152:K152,0))","v":0}]
["E-148",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I153:K153,0))","v":0}]
["E-149",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I154:K154,0))","v":0}]
["E-150",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I155:K155,0))","v":0}]
["E-151",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I156:K156,0))","v":0}]
["E-152",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I157:K157,0))","v":0}]
["E-153",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I158:K158,0))","v":0}]
["E-154",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I159:K159,0))","v":0}]
["E-155",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I160:K160,0))","v":0}]
["E-156",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I161:K161,0))","v":0}]
["E-157",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I162:K162,0))","v":0}]
["E-158",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I163:K163,0))","v":0}]
["E-159",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I164:K164,0))","v":0}]
["E-160",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I165:K165,0))","v":0}]
["E-161",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I166:K166,0))","v":0}]
["E-162",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I167:K167,0))","v":0}]
["E-163",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I168:K168,0))","v":0}]
["E-164",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I169:K169,0))","v":0}]
["E-165",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I170:K170,0))","v":0}]
["E-166",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I171:K171,0))","v":0}]
["E-167",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I172:K172,0))","v":0}]
["E-168",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I173:K173,0))","v":0}]
["E-169",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I174:K174,0))","v":0}]
["E-170",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I175:K175,0))","v":0}]
["E-171",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I176:K176,0))","v":0}]
["E-172",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I177:K177,0))","v":0}]
["E-173",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I178:K178,0))","v":0}]
["E-174",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I179:K179,0))","v":0}]
["E-175",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I180:K180,0))","v":0}]
["E-176",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I181:K181,0))","v":0}]
["E-177",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I182:K182,0))","v":0}]
["E-178",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I183:K183,0))","v":0}]
["E-179",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I184:K184,0))","v":0}]
["E-180",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I185:K185,0))","v":0}]
["E-181",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I186:K186,0))","v":0}]
["E-182",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I187:K187,0))","v":0}]
["E-183",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I188:K188,0))","v":0}]
["E-184",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I189:K189,0))","v":0}]
["E-185",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I190:K190,0))","v":0}]
["E-186",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I191:K191,0))","v":0}]
["E-187",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I192:K192,0))","v":0}]
["E-188",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I193:K193,0))","v":0}]
["E-189",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I194:K194,0))","v":0}]
["E-190",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I195:K195,0))","v":0}]
["E-191",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I196:K196,0))","v":0}]
["E-192",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I197:K197,0))","v":0}]
["E-193",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I198:K198,0))","v":0}]
["E-194",null,null,null,null,0,0,{"$f":"IF(OR(F199=\"Redacted\",G199=\"Redacted\"),\"Redacted\",IF(OR(T(F199)<>\"\",T(G199)<>\"\"),\"Varies\",ROUND(F199*G199,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I199:K199,0))","v":0}]
["E-195",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I200:K200,0))","v":0}]
["E-196",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I201:K201,0))","v":0}]
["E-197",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I202:K202,0))","v":0}]
["E-198",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I203:K203,0))","v":0}]
["E-199",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I204:K204,0))","v":0}]
["E-200",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I205:K205,0))","v":0}]
["E-201",null,"CEC USE ONLY",null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I206:K206,0))","v":0}]
["E-202",null,"CEC USE ONLY",null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I207:K207,0))","v":0}]
["Grand Totals",null,null,null,null,null,null,null,{"$f":"SUM(ROUND(I6:I207,0))","v":0},{"$f":"SUM(ROUND(J6:J207,0))","v":0},{"$f":"SUM(ROUND(K6:K207,0))","v":0},{"$f":"SUM(L6:L207)","v":0}]

{"sheet":"Materials & Misc.","index":6,"n_rows":208,"n_cols":17,"rows_kept":208,"cut":false,"hidden":false,"merged":[[0,0,0,2],[207,0,207,7],[1,0,1,11],[2,0,2,11],[3,0,3,11],[0,10,0,11]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 2/17/2023"},null,null,null,null,null,null,null,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"]
["Materials & Miscellaneous"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"GFO-25-603:  ABC company"}]
["Reference ID","Task #","Seller of item(s)","Description","Purpose","# of Units","Unit Cost","Total:  \n# of Units x Unit Cost","CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["M-1",null,null,null,null,0,0,{"$f":"IF(OR(F6=\"Redacted\",G6=\"Redacted\"),\"Redacted\",IF(OR(T(F6)<>\"\",T(G6)<>\"\"),\"Varies\",ROUND(F6*G6,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I6:K6,0))","v":0}]
["M-2",null,null,null,null,0,0,{"$f":"IF(OR(F7=\"Redacted\",G7=\"Redacted\"),\"Redacted\",IF(OR(T(F7)<>\"\",T(G7)<>\"\"),\"Varies\",ROUND(F7*G7,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I7:K7,0))","v":0}]
["M-3",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I8:K8,0))","v":0}]
["M-4",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I9:K9,0))","v":0}]
["M-5",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I10:K10,0))","v":0}]
["M-6",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I11:K11,0))","v":0}]
["M-7",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I12:K12,0))","v":0}]
["M-8",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I13:K13,0))","v":0}]
["M-9",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I14:K14,0))","v":0}]
["M-10",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I15:K15,0))","v":0}]
["M-11",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I16:K16,0))","v":0}]
["M-12",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I17:K17,0))","v":0}]
["M-13",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I18:K18,0))","v":0}]
["M-14",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I19:K19,0))","v":0}]
["M-15",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I20:K20,0))","v":0}]
["M-16",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I21:K21,0))","v":0}]
["M-17",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I22:K22,0))","v":0}]
["M-18",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I23:K23,0))","v":0}]
["M-19",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I24:K24,0))","v":0}]
["M-20",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I25:K25,0))","v":0}]
["M-21",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I26:K26,0))","v":0}]
["M-22",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I27:K27,0))","v":0}]
["M-23",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I28:K28,0))","v":0}]
["M-24",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I29:K29,0))","v":0}]
["M-25",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I30:K30,0))","v":0}]
["M-26",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I31:K31,0))","v":0}]
["M-27",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I32:K32,0))","v":0}]
["M-28",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I33:K33,0))","v":0}]
["M-29",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I34:K34,0))","v":0}]
["M-30",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I35:K35,0))","v":0}]
["M-31",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I36:K36,0))","v":0}]
["M-32",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I37:K37,0))","v":0}]
["M-33",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I38:K38,0))","v":0}]
["M-34",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I39:K39,0))","v":0}]
["M-35",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I40:K40,0))","v":0}]
["M-36",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I41:K41,0))","v":0}]
["M-37",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I42:K42,0))","v":0}]
["M-38",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I43:K43,0))","v":0}]
["M-39",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I44:K44,0))","v":0}]
["M-40",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I45:K45,0))","v":0}]
["M-41",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I46:K46,0))","v":0}]
["M-42",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I47:K47,0))","v":0}]
["M-43",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I48:K48,0))","v":0}]
["M-44",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I49:K49,0))","v":0}]
["M-45",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I50:K50,0))","v":0}]
["M-46",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I51:K51,0))","v":0}]
["M-47",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I52:K52,0))","v":0}]
["M-48",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I53:K53,0))","v":0}]
["M-49",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I54:K54,0))","v":0}]
["M-50",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I55:K55,0))","v":0}]
["M-51",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I56:K56,0))","v":0}]
["M-52",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I57:K57,0))","v":0}]
["M-53",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I58:K58,0))","v":0}]
["M-54",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I59:K59,0))","v":0}]
["M-55",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I60:K60,0))","v":0}]
["M-56",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I61:K61,0))","v":0}]
["M-57",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I62:K62,0))","v":0}]
["M-58",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I63:K63,0))","v":0}]
["M-59",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I64:K64,0))","v":0}]
["M-60",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I65:K65,0))","v":0}]
["M-61",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I66:K66,0))","v":0}]
["M-62",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I67:K67,0))","v":0}]
["M-63",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I68:K68,0))","v":0}]
["M-64",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I69:K69,0))","v":0}]
["M-65",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I70:K70,0))","v":0}]
["M-66",null,null,null,null,0,0,{"$f":"IF(OR(F71=\"Redacted\",G71=\"Redacted\"),\"Redacted\",IF(OR(T(F71)<>\"\",T(G71)<>\"\"),\"Varies\",ROUND(F71*G71,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I71:K71,0))","v":0}]
["M-67",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I72:K72,0))","v":0}]
["M-68",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I73:K73,0))","v":0}]
["M-69",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I74:K74,0))","v":0}]
["M-70",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I75:K75,0))","v":0}]
["M-71",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I76:K76,0))","v":0}]
["M-72",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I77:K77,0))","v":0}]
["M-73",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I78:K78,0))","v":0}]
["M-74",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I79:K79,0))","v":0}]
["M-75",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I80:K80,0))","v":0}]
["M-76",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I81:K81,0))","v":0}]
["M-77",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I82:K82,0))","v":0}]
["M-78",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I83:K83,0))","v":0}]
["M-79",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I84:K84,0))","v":0}]
["M-80",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I85:K85,0))","v":0}]
["M-81",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I86:K86,0))","v":0}]
["M-82",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I87:K87,0))","v":0}]
["M-83",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I88:K88,0))","v":0}]
["M-84",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I89:K89,0))","v":0}]
["M-85",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I90:K90,0))","v":0}]
["M-86",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I91:K91,0))","v":0}]
["M-87",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I92:K92,0))","v":0}]
["M-88",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I93:K93,0))","v":0}]
["M-89",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I94:K94,0))","v":0}]
["M-90",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I95:K95,0))","v":0}]
["M-91",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I96:K96,0))","v":0}]
["M-92",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I97:K97,0))","v":0}]
["M-93",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I98:K98,0))","v":0}]
["M-94",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I99:K99,0))","v":0}]
["M-95",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I100:K100,0))","v":0}]
["M-96",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I101:K101,0))","v":0}]
["M-97",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I102:K102,0))","v":0}]
["M-98",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I103:K103,0))","v":0}]
["M-99",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I104:K104,0))","v":0}]
["M-100",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I105:K105,0))","v":0}]
["M-101",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I106:K106,0))","v":0}]
["M-102",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I107:K107,0))","v":0}]
["M-103",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I108:K108,0))","v":0}]
["M-104",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I109:K109,0))","v":0}]
["M-105",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I110:K110,0))","v":0}]
["M-106",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I111:K111,0))","v":0}]
["M-107",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I112:K112,0))","v":0}]
["M-108",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I113:K113,0))","v":0}]
["M-109",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I114:K114,0))","v":0}]
["M-110",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I115:K115,0))","v":0}]
["M-111",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I116:K116,0))","v":0}]
["M-112",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I117:K117,0))","v":0}]
["M-113",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I118:K118,0))","v":0}]
["M-114",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I119:K119,0))","v":0}]
["M-115",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I120:K120,0))","v":0}]
["M-116",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I121:K121,0))","v":0}]
["M-117",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I122:K122,0))","v":0}]
["M-118",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I123:K123,0))","v":0}]
["M-119",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I124:K124,0))","v":0}]
["M-120",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I125:K125,0))","v":0}]
["M-121",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I126:K126,0))","v":0}]
["M-122",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I127:K127,0))","v":0}]
["M-123",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I128:K128,0))","v":0}]
["M-124",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I129:K129,0))","v":0}]
["M-125",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I130:K130,0))","v":0}]
["M-126",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I131:K131,0))","v":0}]
["M-127",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I132:K132,0))","v":0}]
["M-128",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I133:K133,0))","v":0}]
["M-129",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I134:K134,0))","v":0}]
["M-130",null,null,null,null,0,0,{"$f":"IF(OR(F135=\"Redacted\",G135=\"Redacted\"),\"Redacted\",IF(OR(T(F135)<>\"\",T(G135)<>\"\"),\"Varies\",ROUND(F135*G135,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I135:K135,0))","v":0}]
["M-131",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I136:K136,0))","v":0}]
["M-132",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I137:K137,0))","v":0}]
["M-133",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I138:K138,0))","v":0}]
["M-134",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I139:K139,0))","v":0}]
["M-135",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I140:K140,0))","v":0}]
["M-136",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I141:K141,0))","v":0}]
["M-137",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I142:K142,0))","v":0}]
["M-138",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I143:K143,0))","v":0}]
["M-139",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I144:K144,0))","v":0}]
["M-140",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I145:K145,0))","v":0}]
["M-141",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I146:K146,0))","v":0}]
["M-142",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I147:K147,0))","v":0}]
["M-143",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I148:K148,0))","v":0}]
["M-144",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I149:K149,0))","v":0}]
["M-145",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I150:K150,0))","v":0}]
["M-146",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I151:K151,0))","v":0}]
["M-147",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I152:K152,0))","v":0}]
["M-148",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I153:K153,0))","v":0}]
["M-149",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I154:K154,0))","v":0}]
["M-150",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I155:K155,0))","v":0}]
["M-151",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I156:K156,0))","v":0}]
["M-152",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I157:K157,0))","v":0}]
["M-153",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I158:K158,0))","v":0}]
["M-154",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I159:K159,0))","v":0}]
["M-155",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I160:K160,0))","v":0}]
["M-156",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I161:K161,0))","v":0}]
["M-157",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I162:K162,0))","v":0}]
["M-158",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I163:K163,0))","v":0}]
["M-159",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I164:K164,0))","v":0}]
["M-160",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I165:K165,0))","v":0}]
["M-161",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I166:K166,0))","v":0}]
["M-162",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I167:K167,0))","v":0}]
["M-163",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I168:K168,0))","v":0}]
["M-164",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I169:K169,0))","v":0}]
["M-165",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I170:K170,0))","v":0}]
["M-166",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I171:K171,0))","v":0}]
["M-167",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I172:K172,0))","v":0}]
["M-168",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I173:K173,0))","v":0}]
["M-169",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I174:K174,0))","v":0}]
["M-170",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I175:K175,0))","v":0}]
["M-171",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I176:K176,0))","v":0}]
["M-172",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I177:K177,0))","v":0}]
["M-173",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I178:K178,0))","v":0}]
["M-174",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I179:K179,0))","v":0}]
["M-175",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I180:K180,0))","v":0}]
["M-176",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I181:K181,0))","v":0}]
["M-177",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I182:K182,0))","v":0}]
["M-178",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I183:K183,0))","v":0}]
["M-179",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I184:K184,0))","v":0}]
["M-180",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I185:K185,0))","v":0}]
["M-181",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I186:K186,0))","v":0}]
["M-182",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I187:K187,0))","v":0}]
["M-183",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I188:K188,0))","v":0}]
["M-184",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I189:K189,0))","v":0}]
["M-185",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I190:K190,0))","v":0}]
["M-186",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I191:K191,0))","v":0}]
["M-187",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I192:K192,0))","v":0}]
["M-188",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I193:K193,0))","v":0}]
["M-189",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I194:K194,0))","v":0}]
["M-190",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I195:K195,0))","v":0}]
["M-191",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I196:K196,0))","v":0}]
["M-192",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I197:K197,0))","v":0}]
["M-193",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I198:K198,0))","v":0}]
["M-194",null,null,null,null,0,0,{"$f":"IF(OR(F199=\"Redacted\",G199=\"Redacted\"),\"Redacted\",IF(OR(T(F199)<>\"\",T(G199)<>\"\"),\"Varies\",ROUND(F199*G199,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I199:K199,0))","v":0}]
["M-195",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I200:K200,0))","v":0}]
["M-196",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I201:K201,0))","v":0}]
["M-197",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I202:K202,0))","v":0}]
["M-198",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I203:K203,0))","v":0}]
["M-199",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I204:K204,0))","v":0}]
["M-200",null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I205:K205,0))","v":0}]
["M-201",null,"CEC USE ONLY",null,null,0,0,0,0,0,0,{"$f":"SUM(ROUND(I206:K206,0))","v":0}]
["M-202",null,"CEC USE ONLY",null,null,0,0,{"$f":"IF(OR(F207=\"Redacted\",G207=\"Redacted\"),\"Redacted\",IF(OR(T(F207)<>\"\",T(G207)<>\"\"),\"Varies\",ROUND(F207*G207,0)))","v":0},0,0,0,{"$f":"SUM(ROUND(I207:K207,0))","v":0}]
["Grand Totals",null,null,null,null,null,null,null,{"$f":"SUM(ROUND(I6:I207,0))","v":0},{"$f":"SUM(ROUND(J6:J207,0))","v":0},{"$f":"SUM(ROUND(K6:K207,0))","v":0},{"$f":"SUM(L6:L207)","v":0}]

{"sheet":"Subrecipients & Vendors","index":7,"n_rows":115,"n_cols":15,"rows_kept":115,"cut":false,"hidden":false,"merged":[[112,0,112,9],[114,0,114,5],[113,0,113,5],[110,0,110,5],[0,8,0,9],[58,0,58,9],[0,0,0,2],[56,0,56,5],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 2/17/2023"},null,null,null,null,null,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"]
["Subrecipients & Vendors"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"GFO-25-603:  ABC company"}]
["Subrecipients"]
["Reference ID","Task #","Subrecipient\n(Please Use Legal Name)","Entity Number\n(CA Secretary of State)","Purpose","CA Business Certifications DVBE/ SB/MB/None","CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["S-1",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G7:I7,0))","v":0}]
["S-2",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G8:I8,0))","v":0}]
["S-3",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G9:I9,0))","v":0}]
["S-4",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G10:I10,0))","v":0}]
["S-5",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G11:I11,0))","v":0}]
["S-6",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G12:I12,0))","v":0}]
["S-7",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G13:I13,0))","v":0}]
["S-8",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G14:I14,0))","v":0}]
["S-9",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G15:I15,0))","v":0}]
["S-10",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G16:I16,0))","v":0}]
["S-11",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G17:I17,0))","v":0}]
["S-12",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G18:I18,0))","v":0}]
["S-13",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G19:I19,0))","v":0}]
["S-14",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G20:I20,0))","v":0}]
["S-15",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G21:I21,0))","v":0}]
["S-16",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G22:I22,0))","v":0}]
["S-17",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G23:I23,0))","v":0}]
["S-18",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G24:I24,0))","v":0}]
["S-19",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G25:I25,0))","v":0}]
["S-20",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G26:I26,0))","v":0}]
["S-21",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G27:I27,0))","v":0}]
["S-22",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G28:I28,0))","v":0}]
["S-23",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G29:I29,0))","v":0}]
["S-24",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G30:I30,0))","v":0}]
["S-25",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G31:I31,0))","v":0}]
["S-26",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G32:I32,0))","v":0}]
["S-27",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G33:I33,0))","v":0}]
["S-28",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G34:I34,0))","v":0}]
["S-29",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G35:I35,0))","v":0}]
["S-30",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G36:I36,0))","v":0}]
["S-31",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G37:I37,0))","v":0}]
["S-32",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G38:I38,0))","v":0}]
["S-33",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G39:I39,0))","v":0}]
["S-34",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G40:I40,0))","v":0}]
["S-35",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G41:I41,0))","v":0}]
["S-36",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G42:I42,0))","v":0}]
["S-37",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G43:I43,0))","v":0}]
["S-38",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G44:I44,0))","v":0}]
["S-39",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G45:I45,0))","v":0}]
["S-40",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G46:I46,0))","v":0}]
["S-41",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G47:I47,0))","v":0}]
["S-42",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G48:I48,0))","v":0}]
["S-43",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G49:I49,0))","v":0}]
["S-44",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G50:I50,0))","v":0}]
["S-45",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G51:I51,0))","v":0}]
["S-46",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G52:I52,0))","v":0}]
["S-47",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G53:I53,0))","v":0}]
["S-48",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G54:I54,0))","v":0}]
["S-49",null,"CEC USE ONLY",null,null,"None",0,0,0,{"$f":"SUM(ROUND(G55:I55,0))","v":0}]
["S-50",null,"CEC USE ONLY",null,null,"None",0,0,0,{"$f":"SUM(ROUND(G56:I56,0))","v":0}]
["Subrecipient Totals",null,null,null,null,null,{"$f":"SUM(ROUND(G7:G56,0))","v":0},{"$f":"SUM(ROUND(H7:H56,0))","v":0},{"$f":"SUM(ROUND(I7:I56,0))","v":0},{"$f":"SUM(J7:J56)","v":0}]
[]
["Vendors"]
["Reference ID","Task #","Vendor\n(Please Use Legal Name)","Entity Number\n(CA Secretary of State)","Purpose","CA Business Certifications DVBE/ SB/MB/None","CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["V-1",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G61:I61,0))","v":0}]
["V-2",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G62:I62,0))","v":0}]
["V-3",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G63:I63,0))","v":0}]
["V-4",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G64:I64,0))","v":0}]
["V-5",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G65:I65,0))","v":0}]
["V-6",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G66:I66,0))","v":0}]
["V-7",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G67:I67,0))","v":0}]
["V-8",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G68:I68,0))","v":0}]
["V-9",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G69:I69,0))","v":0}]
["V-10",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G70:I70,0))","v":0}]
["V-11",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G71:I71,0))","v":0}]
["V-12",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G72:I72,0))","v":0}]
["V-13",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G73:I73,0))","v":0}]
["V-14",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G74:I74,0))","v":0}]
["V-15",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G75:I75,0))","v":0}]
["V-16",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G76:I76,0))","v":0}]
["V-17",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G77:I77,0))","v":0}]
["V-18",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G78:I78,0))","v":0}]
["V-19",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G79:I79,0))","v":0}]
["V-20",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G80:I80,0))","v":0}]
["V-21",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G81:I81,0))","v":0}]
["V-22",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G82:I82,0))","v":0}]
["V-23",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G83:I83,0))","v":0}]
["V-24",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G84:I84,0))","v":0}]
["V-25",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G85:I85,0))","v":0}]
["V-26",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G86:I86,0))","v":0}]
["V-27",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G87:I87,0))","v":0}]
["V-28",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G88:I88,0))","v":0}]
["V-29",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G89:I89,0))","v":0}]
["V-30",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G90:I90,0))","v":0}]
["V-31",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G91:I91,0))","v":0}]
["V-32",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G92:I92,0))","v":0}]
["V-33",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G93:I93,0))","v":0}]
["V-34",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G94:I94,0))","v":0}]
["V-35",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G95:I95,0))","v":0}]
["V-36",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G96:I96,0))","v":0}]
["V-37",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G97:I97,0))","v":0}]
["V-38",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G98:I98,0))","v":0}]
["V-39",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G99:I99,0))","v":0}]
["V-40",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G100:I100,0))","v":0}]
["V-41",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G101:I101,0))","v":0}]
["V-42",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G102:I102,0))","v":0}]
["V-43",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G103:I103,0))","v":0}]
["V-44",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G104:I104,0))","v":0}]
["V-45",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G105:I105,0))","v":0}]
["V-46",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G106:I106,0))","v":0}]
["V-47",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G107:I107,0))","v":0}]
["V-48",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G108:I108,0))","v":0}]
["V-49",null,"CEC USE ONLY",null,null,"None",0,0,0,{"$f":"SUM(ROUND(G109:I109,0))","v":0}]
["V-50",null,"CEC USE ONLY",null,null,"None",0,0,0,{"$f":"SUM(ROUND(G110:I110,0))","v":0}]
["Vendor Totals",null,null,null,null,null,{"$f":"SUM(ROUND(G61:G110,0))","v":0},{"$f":"SUM(ROUND(H61:H110,0))","v":0},{"$f":"SUM(ROUND(I61:I110,0))","v":0},{"$f":"SUM(J61:J110)","v":0}]
[]
["Subrecipients & Vendors Grand Totals"]
[null,null,null,null,null,null,"CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["Grand Totals",null,null,null,null,null,{"$f":"G57+G111","v":0},{"$f":"H57+H111","v":0},{"$f":"I57+I111","v":0},{"$f":"J57+J111","v":0}]

{"sheet":"Indirect Costs & Profit","index":8,"n_rows":163,"n_cols":20,"rows_kept":163,"cut":false,"hidden":false,"merged":[[140,12,146,12],[98,6,104,6],[105,6,111,6],[112,6,118,6],[119,6,125,6],[126,6,132,6],[133,6,139,6],[140,6,146,6],[21,12,27,12],[28,12,34,12],[35,12,41,12],[42,12,48,12],[49,12,55,12],[56,12,62,12],[63,12,69,12],[70,12,76,12],[77,12,83,12],[84,12,90,12],[91,12,97,12],[98,12,104,12],[105,12,111,12],[112,12,118,12],[119,12,125,12],[126,12,132,12],[133,12,139,12],[161,0,161,14],[162,0,162,14],[160,0,160,14],[126,10,132,10],[126,11,132,11],[126,13,132,13],[126,14,132,14],[133,0,139,0],[133,5,139,5],[133,7,139,7],[133,8,139,8],[133,9,139,9],[133,10,139,10],[133,11,139,11],[133,13,139,13],[133,14,139,14],[126,0,132,0],[126,5,132,5],[126,7,132,7],[140,11,146,11],[140,13,146,13],[140,14,146,14],[147,0,147,10],[140,7,146,7],[112,0,118,0],[112,5,118,5],[112,7,118,7],[112,8,118,8],[112,9,118,9],[140,0,146,0],[140,5,146,5],[140,9,146,9],[126,8,132,8],[126,9,132,9],[0,0,0,1],[119,0,125,0],[119,5,125,5],[119,7,125,7],[119,8,125,8],[119,9,125,9],[105,0,111,0],[105,5,111,5],[105,7,111,7],[98,0,104,0],[98,5,104,5],[98,7,104,7],[28,7,34,7],[28,8,34,8],[28,9,34,9],[1,0,1,14],[119,10,125,10],[119,11,125,11],[119,13,125,13],[119,14,125,14],[98,10,104,10],[98,11,104,11],[98,13,104,13],[98,14,104,14],[105,8,111,8],[105,9,111,9],[105,10,111,10],[105,11,111,11],[105,13,111,13],[105,14,111,14],[98,8,104,8],[98,9,104,9],[112,10,118,10],[112,11,118,11],[112,13,118,13],[112,14,118,14],[84,10,90,10],[84,11,90,11],[84,13,90,13],[84,14,90,14],[91,0,97,0],[91,5,97,5],[91,7,97,7],[91,8,97,8],[91,9,97,9],[91,10,97,10],[91,11,97,11],[91,13,97,13],[91,14,97,14],[84,0,90,0],[84,5,90,5],[84,7,90,7],[84,8,90,8],[84,9,90,9],[84,6,90,6],[91,6,97,6],[70,10,76,10],[70,11,76,11],[70,13,76,13],[70,14,76,14],[77,0,83,0],[77,5,83,5],[77,7,83,7],[77,8,83,8],[77,9,83,9],[77,10,83,10],[77,11,83,11],[77,13,83,13],[77,14,83,14],[70,0,76,0],[70,5,76,5],[70,7,76,7],[70,8,76,8],[70,9,76,9],[70,6,76,6],[77,6,83,6],[63,0,69,0],[63,5,69,5],[63,7,69,7],[63,8,69,8],[63,9,69,9],[63,10,69,10],[63,11,69,11],[63,13,69,13],[63,14,69,14],[63,6,69,6],[49,14,55,14],[42,0,48,0],[42,5,48,5],[42,7,48,7],[42,8,48,8],[42,9,48,9],[56,10,62,10],[56,11,62,11],[56,13,62,13],[56,14,62,14],[56,0,62,0],[56,5,62,5],[56,7,62,7],[56,8,62,8],[56,9,62,9],[42,6,48,6],[49,6,55,6],[56,6,62,6],[42,14,48,14],[49,0,55,0],[49,5,55,5],[49,7,55,7],[49,8,55,8],[49,9,55,9],[49,10,55,10],[49,11,55,11],[49,13,55,13],[7,12,13,12],[14,12,20,12],[7,6,13,6],[14,6,20,6],[21,6,27,6],[28,6,34,6],[35,6,41,6],[2,0,2,14],[3,0,3,14],[4,0,4,14],[5,0,5,14],[14,8,20,8],[21,8,27,8],[14,14,20,14],[21,14,27,14],[14,0,20,0],[14,5,20,5],[14,9,20,9],[14,10,20,10],[14,11,20,11],[14,13,20,13],[21,0,27,0],[21,5,27,5],[21,9,27,9],[21,10,27,10],[21,11,27,11],[21,13,27,13],[14,7,20,7],[21,7,27,7],[7,9,13,9],[7,10,13,10],[0,13,0,14],[158,0,158,10],[151,13,157,13],[151,14,157,14],[152,0,152,1],[153,0,153,1],[154,0,154,1],[155,0,155,1],[156,0,156,1],[157,0,157,1],[151,11,157,11],[151,9,157,9],[151,10,157,10],[151,7,157,7],[151,8,157,8],[151,5,157,5],[7,11,13,11],[7,13,13,13],[7,14,13,14],[7,0,13,0],[7,5,13,5],[7,7,13,7],[7,8,13,8],[140,8,146,8],[151,6,157,6],[151,12,157,12],[150,0,150,1],[151,0,151,1],[149,0,149,14],[28,10,34,10],[28,11,34,11],[28,13,34,13],[28,14,34,14],[35,0,41,0],[35,5,41,5],[35,7,41,7],[35,8,41,8],[35,9,41,9],[35,10,41,10],[35,11,41,11],[35,13,41,13],[35,14,41,14],[28,0,34,0],[28,5,34,5],[140,10,146,10],[42,10,48,10],[42,11,48,11],[42,13,48,13]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 2/17/2023"},null,null,null,null,null,null,null,null,null,null,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"]
["Indirect Costs and Profit"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"GFO-25-603:  ABC company"}]
["Recipient's Rate (From Cost Allocation Plan)"]
["Indirect Cost(s)"]
["Name of Indirect Cost","Indirect Cost (IDC) Base Category","IDC Base\nCEC Share ($)",{"$f":"\"IDC Base \"&'Category Budget'!C8&\" ($)\"","v":"IDC Base [Other Entity] Share ($)"},"IDC Base\nMatch Share ($)","Total \nIDC Base\nCEC Share ($)",{"$f":"\"Total IDC Base \"&'Category Budget'!C8&\" ($)\"","v":"Total IDC Base [Other Entity] Share ($)"},"Total \nIDC Base\nMatch Share ($)","Total IDC Base ($)","IDC Rate (%)","Rate x Base ($)","CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C8,0),ROUND(C9,0),ROUND(C10,0),ROUND(C11,0),ROUND(C12,0),ROUND(C13,0),ROUND(C14,0))","v":0},{"$f":"SUM(ROUND(D8,0),ROUND(D9,0),ROUND(D10,0),ROUND(D11,0),ROUND(D12,0),ROUND(D13,0),ROUND(D14,0))","v":0},{"$f":"SUM(ROUND(E8,0),ROUND(E9,0),ROUND(E10,0),ROUND(E11,0),ROUND(E12,0),ROUND(E13,0),ROUND(E14,0))","v":0},{"$f":"SUM(F8:H14)","v":0},0,{"$f":"ROUND($I8*J8,0)","v":0},0,0,0,{"$f":"ROUND($L8,0)+ROUND(M8,0)+ROUND($N8,0)","v":0}]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C15,0),ROUND(C16,0),ROUND(C17,0),ROUND(C18,0),ROUND(C19,0),ROUND(C20,0),ROUND(C21,0))","v":0},{"$f":"SUM(ROUND(D15,0),ROUND(D16,0),ROUND(D17,0),ROUND(D18,0),ROUND(D19,0),ROUND(D20,0),ROUND(D21,0))","v":0},{"$f":"SUM(ROUND(E15,0),ROUND(E16,0),ROUND(E17,0),ROUND(E18,0),ROUND(E19,0),ROUND(E20,0),ROUND(E21,0))","v":0},{"$f":"SUM(F15:H21)","v":0},0,{"$f":"ROUND($I15*J15,0)","v":0},0,0,0,{"$f":"ROUND($L15,0)+ROUND(M15,0)+ROUND($N15,0)","v":0}]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C22,0),ROUND(C23,0),ROUND(C24,0),ROUND(C25,0),ROUND(C26,0),ROUND(C27,0),ROUND(C28,0))","v":0},{"$f":"SUM(ROUND(D22,0),ROUND(D23,0),ROUND(D24,0),ROUND(D25,0),ROUND(D26,0),ROUND(D27,0),ROUND(D28,0))","v":0},{"$f":"SUM(ROUND(E22,0),ROUND(E23,0),ROUND(E24,0),ROUND(E25,0),ROUND(E26,0),ROUND(E27,0),ROUND(E28,0))","v":0},{"$f":"SUM(F22,H22)","v":0},0,{"$f":"ROUND($I22*J22,0)","v":0},0,0,0,{"$f":"ROUND($L22,0)+ROUND($N22,0)","v":0}]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C29,0),ROUND(C30,0),ROUND(C31,0),ROUND(C32,0),ROUND(C33,0),ROUND(C34,0),ROUND(C35,0))","v":0},{"$f":"SUM(ROUND(D29,0),ROUND(D30,0),ROUND(D31,0),ROUND(D32,0),ROUND(D33,0),ROUND(D34,0),ROUND(D35,0))","v":0},{"$f":"SUM(ROUND(E29,0),ROUND(E30,0),ROUND(E31,0),ROUND(E32,0),ROUND(E33,0),ROUND(E34,0),ROUND(E35,0))","v":0},{"$f":"SUM(F29,H29)","v":0},0,{"$f":"ROUND($I29*J29,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C36,0),ROUND(C37,0),ROUND(C38,0),ROUND(C39,0),ROUND(C40,0),ROUND(C41,0),ROUND(C42,0))","v":0},{"$f":"SUM(ROUND(D36,0),ROUND(D37,0),ROUND(D38,0),ROUND(D39,0),ROUND(D40,0),ROUND(D41,0),ROUND(D42,0))","v":0},{"$f":"SUM(ROUND(E36,0),ROUND(E37,0),ROUND(E38,0),ROUND(E39,0),ROUND(E40,0),ROUND(E41,0),ROUND(E42,0))","v":0},{"$f":"SUM(F36,H36)","v":0},0,{"$f":"ROUND($I36*J36,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C43,0),ROUND(C44,0),ROUND(C45,0),ROUND(C46,0),ROUND(C47,0),ROUND(C48,0),ROUND(C49,0))","v":0},{"$f":"SUM(ROUND(D43,0),ROUND(D44,0),ROUND(D45,0),ROUND(D46,0),ROUND(D47,0),ROUND(D48,0),ROUND(D49,0))","v":0},{"$f":"SUM(ROUND(E43,0),ROUND(E44,0),ROUND(E45,0),ROUND(E46,0),ROUND(E47,0),ROUND(E48,0),ROUND(E49,0))","v":0},{"$f":"SUM(F43,H43)","v":0},0,{"$f":"ROUND($I43*J43,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C50,0),ROUND(C51,0),ROUND(C52,0),ROUND(C53,0),ROUND(C54,0),ROUND(C55,0),ROUND(C56,0))","v":0},{"$f":"SUM(ROUND(D50,0),ROUND(D51,0),ROUND(D52,0),ROUND(D53,0),ROUND(D54,0),ROUND(D55,0),ROUND(D56,0))","v":0},{"$f":"SUM(ROUND(E50,0),ROUND(E51,0),ROUND(E52,0),ROUND(E53,0),ROUND(E54,0),ROUND(E55,0),ROUND(E56,0))","v":0},{"$f":"SUM(F50,H50)","v":0},0,{"$f":"ROUND($I50*J50,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C57,0),ROUND(C58,0),ROUND(C59,0),ROUND(C60,0),ROUND(C61,0),ROUND(C62,0),ROUND(C63,0))","v":0},{"$f":"SUM(ROUND(D57,0),ROUND(D58,0),ROUND(D59,0),ROUND(D60,0),ROUND(D61,0),ROUND(D62,0),ROUND(D63,0))","v":0},{"$f":"SUM(ROUND(E57,0),ROUND(E58,0),ROUND(E59,0),ROUND(E60,0),ROUND(E61,0),ROUND(E62,0),ROUND(E63,0))","v":0},{"$f":"SUM(F57,H57)","v":0},0,{"$f":"ROUND($I57*J57,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C64,0),ROUND(C65,0),ROUND(C66,0),ROUND(C67,0),ROUND(C68,0),ROUND(C69,0),ROUND(C70,0))","v":0},{"$f":"SUM(ROUND(D64,0),ROUND(D65,0),ROUND(D66,0),ROUND(D67,0),ROUND(D68,0),ROUND(D69,0),ROUND(D70,0))","v":0},{"$f":"SUM(ROUND(E64,0),ROUND(E65,0),ROUND(E66,0),ROUND(E67,0),ROUND(E68,0),ROUND(E69,0),ROUND(E70,0))","v":0},{"$f":"SUM(F64,H64)","v":0},0,{"$f":"ROUND($I64*J64,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C71,0),ROUND(C72,0),ROUND(C73,0),ROUND(C74,0),ROUND(C75,0),ROUND(C76,0),ROUND(C77,0))","v":0},{"$f":"SUM(ROUND(D71,0),ROUND(D72,0),ROUND(D73,0),ROUND(D74,0),ROUND(D75,0),ROUND(D76,0),ROUND(D77,0))","v":0},{"$f":"SUM(ROUND(E71,0),ROUND(E72,0),ROUND(E73,0),ROUND(E74,0),ROUND(E75,0),ROUND(E76,0),ROUND(E77,0))","v":0},{"$f":"SUM(F71,H71)","v":0},0,{"$f":"ROUND($I71*J71,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C78,0),ROUND(C79,0),ROUND(C80,0),ROUND(C81,0),ROUND(C82,0),ROUND(C83,0),ROUND(C84,0))","v":0},{"$f":"SUM(ROUND(D78,0),ROUND(D79,0),ROUND(D80,0),ROUND(D81,0),ROUND(D82,0),ROUND(D83,0),ROUND(D84,0))","v":0},{"$f":"SUM(ROUND(E78,0),ROUND(E79,0),ROUND(E80,0),ROUND(E81,0),ROUND(E82,0),ROUND(E83,0),ROUND(E84,0))","v":0},{"$f":"SUM(F78,H78)","v":0},0,{"$f":"ROUND($I78*J78,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C85,0),ROUND(C86,0),ROUND(C87,0),ROUND(C88,0),ROUND(C89,0),ROUND(C90,0),ROUND(C91,0))","v":0},{"$f":"SUM(ROUND(D85,0),ROUND(D86,0),ROUND(D87,0),ROUND(D88,0),ROUND(D89,0),ROUND(D90,0),ROUND(D91,0))","v":0},{"$f":"SUM(ROUND(E85,0),ROUND(E86,0),ROUND(E87,0),ROUND(E88,0),ROUND(E89,0),ROUND(E90,0),ROUND(E91,0))","v":0},{"$f":"SUM(F85,H85)","v":0},0,{"$f":"ROUND($I85*J85,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C92,0),ROUND(C93,0),ROUND(C94,0),ROUND(C95,0),ROUND(C96,0),ROUND(C97,0),ROUND(C98,0))","v":0},{"$f":"SUM(ROUND(D92,0),ROUND(D93,0),ROUND(D94,0),ROUND(D95,0),ROUND(D96,0),ROUND(D97,0),ROUND(D98,0))","v":0},{"$f":"SUM(ROUND(E92,0),ROUND(E93,0),ROUND(E94,0),ROUND(E95,0),ROUND(E96,0),ROUND(E97,0),ROUND(E98,0))","v":0},{"$f":"SUM(F92,H92)","v":0},0,{"$f":"ROUND($I92*J92,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C99,0),ROUND(C100,0),ROUND(C101,0),ROUND(C102,0),ROUND(C103,0),ROUND(C104,0),ROUND(C105,0))","v":0},{"$f":"SUM(ROUND(D99,0),ROUND(D100,0),ROUND(D101,0),ROUND(D102,0),ROUND(D103,0),ROUND(D104,0),ROUND(D105,0))","v":0},{"$f":"SUM(ROUND(E99,0),ROUND(E100,0),ROUND(E101,0),ROUND(E102,0),ROUND(E103,0),ROUND(E104,0),ROUND(E105,0))","v":0},{"$f":"SUM(F99,H99)","v":0},0,{"$f":"ROUND($I99*J99,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C106,0),ROUND(C107,0),ROUND(C108,0),ROUND(C109,0),ROUND(C110,0),ROUND(C111,0),ROUND(C112,0))","v":0},{"$f":"SUM(ROUND(D106,0),ROUND(D107,0),ROUND(D108,0),ROUND(D109,0),ROUND(D110,0),ROUND(D111,0),ROUND(D112,0))","v":0},{"$f":"SUM(ROUND(E106,0),ROUND(E107,0),ROUND(E108,0),ROUND(E109,0),ROUND(E110,0),ROUND(E111,0),ROUND(E112,0))","v":0},{"$f":"SUM(F106,H106)","v":0},0,{"$f":"ROUND($I106*J106,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C113,0),ROUND(C114,0),ROUND(C115,0),ROUND(C116,0),ROUND(C117,0),ROUND(C118,0),ROUND(C119,0))","v":0},{"$f":"SUM(ROUND(D113,0),ROUND(D114,0),ROUND(D115,0),ROUND(D116,0),ROUND(D117,0),ROUND(D118,0),ROUND(D119,0))","v":0},{"$f":"SUM(ROUND(E113,0),ROUND(E114,0),ROUND(E115,0),ROUND(E116,0),ROUND(E117,0),ROUND(E118,0),ROUND(E119,0))","v":0},{"$f":"SUM(F113,H113)","v":0},0,{"$f":"ROUND($I113*J113,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C120,0),ROUND(C121,0),ROUND(C122,0),ROUND(C123,0),ROUND(C124,0),ROUND(C125,0),ROUND(C126,0))","v":0},{"$f":"SUM(ROUND(D120,0),ROUND(D121,0),ROUND(D122,0),ROUND(D123,0),ROUND(D124,0),ROUND(D125,0),ROUND(D126,0))","v":0},{"$f":"SUM(ROUND(E120,0),ROUND(E121,0),ROUND(E122,0),ROUND(E123,0),ROUND(E124,0),ROUND(E125,0),ROUND(E126,0))","v":0},{"$f":"SUM(F120,H120)","v":0},0,{"$f":"ROUND($I120*J120,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
[null,"Direct Labor",0,0,0,{"$f":"SUM(ROUND(C127,0),ROUND(C128,0),ROUND(C129,0),ROUND(C130,0),ROUND(C131,0),ROUND(C132,0),ROUND(C133,0))","v":0},{"$f":"SUM(ROUND(D127,0),ROUND(D128,0),ROUND(D129,0),ROUND(D130,0),ROUND(D131,0),ROUND(D132,0),ROUND(D133,0))","v":0},{"$f":"SUM(ROUND(E127,0),ROUND(E128,0),ROUND(E129,0),ROUND(E130,0),ROUND(E131,0),ROUND(E132,0),ROUND(E133,0))","v":0},{"$f":"SUM(F127,H127)","v":0},0,{"$f":"ROUND($I127*J127,0)","v":0},0,0,0,0]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
["CEC USE ONLY","Direct Labor",0,0,0,{"$f":"SUM(ROUND(C134,0),ROUND(C135,0),ROUND(C136,0),ROUND(C137,0),ROUND(C138,0),ROUND(C139,0),ROUND(C140,0))","v":0},{"$f":"SUM(ROUND(D134,0),ROUND(D135,0),ROUND(D136,0),ROUND(D137,0),ROUND(D138,0),ROUND(D139,0),ROUND(D140,0))","v":0},{"$f":"SUM(ROUND(E134,0),ROUND(E135,0),ROUND(E136,0),ROUND(E137,0),ROUND(E138,0),ROUND(E139,0),ROUND(E140,0))","v":0},{"$f":"SUM(F134,H134)","v":0},0,{"$f":"ROUND($I134*J134,0)","v":0},0,0,0,{"$f":"ROUND($L134,0)+ROUND($N134,0)","v":0}]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
["CEC USE ONLY","Direct Labor",0,0,0,{"$f":"SUM(ROUND(C141,0),ROUND(C142,0),ROUND(C143,0),ROUND(C144,0),ROUND(C145,0),ROUND(C146,0),ROUND(C147,0))","v":0},{"$f":"SUM(ROUND(D141,0),ROUND(D142,0),ROUND(D143,0),ROUND(D144,0),ROUND(D145,0),ROUND(D146,0),ROUND(D147,0))","v":0},{"$f":"SUM(ROUND(E141,0),ROUND(E142,0),ROUND(E143,0),ROUND(E144,0),ROUND(E145,0),ROUND(E146,0),ROUND(E147,0))","v":0},{"$f":"SUM(F141,H141)","v":0},0,{"$f":"ROUND($I141*J141,0)","v":0},0,0,0,{"$f":"ROUND($L141,0)+ROUND($N141,0)","v":0}]
[null,"Fringe Benefits",0,0,0]
[null,"Travel",0,0,0]
[null,"Equipment",0,0,0]
[null,"Materials/Misc.",0,0,0]
[null,"Subrecipients/Vendors",0,0,0]
[null,"Indirect Cost",0,0,0]
["Indirect Costs Grand Totals ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(ROUND(L8:L147,0))","v":0},{"$f":"SUM(ROUND(M8:M147,0))","v":0},{"$f":"SUM(ROUND(N8:N147,0))","v":0},{"$f":"SUM(O8:O147)","v":0}]
[]
["Profit"]
["Profit Base Categories",null,"Profit Base\nCEC Share ($)",{"$f":"\"Profit Base \"&'Category Budget'!C8&\" ($)\"","v":"Profit Base [Other Entity] Share ($)"},"Profit Base\nMatch Share ($)","Total \nProfit Base\nCEC Share ($)",{"$f":"\"Total Profit Base \"&'Category Budget'!C8&\" ($)\"","v":"Total Profit Base [Other Entity] Share ($)"},"Total \nProfit Base\nMatch Share ($)","Total Profit Base ($)","Profit Rate (%)","Rate x Base ($)","CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["Direct Labor",null,0,0,0,{"$f":"SUM(ROUND(C152,0),ROUND(C153,0),ROUND(C154,0),ROUND(C155,0),ROUND(C156,0),ROUND(C157,0),ROUND(C158,0))","v":0},{"$f":"SUM(ROUND(D152,0),ROUND(D153,0),ROUND(D154,0),ROUND(D155,0),ROUND(D156,0),ROUND(D157,0),ROUND(D158,0))","v":0},{"$f":"SUM(ROUND(E152,0),ROUND(E153,0),ROUND(E154,0),ROUND(E155,0),ROUND(E156,0),ROUND(E157,0),ROUND(E158,0))","v":0},{"$f":"SUM(F152:H158)","v":0},0,{"$f":"ROUND($I152*J152,0)","v":0},{"$f":"ROUND(F152*0.1,0)","v":0},0,{"$f":"K152-L152","v":0},{"$f":"ROUND($L152,0)+ROUND($M152,0)+ROUND($N152,0)","v":0}]
["Fringe Benefits",null,0,0,0]
["Travel",null,0,0,0]
["Equipment",null,0,0,0]
["Materials/Misc.",null,0,0,0]
["Subrecipients/Vendors",null,0,0,0]
["Indirect Cost",null,0,0,0]
["Profit Grand Totals ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(ROUND(L152,0))","v":0},{"$f":"SUM(ROUND(M152,0))","v":0},{"$f":"SUM(ROUND(N152,0))","v":0},{"$f":"SUM(O152)","v":0}]
[]
["Worksheet Specific Instructions"]
["CONDITIONAL FORMATTING APPLIED:  If the CEC Share value is greater than the Total IDC Base CEC Share ($) multiplied by the IDC Rate (%), as indicated by red conditional formatting (dark red text, light red fill), then the budget will have to be corrected and the Recipient notified that the CEC does not pay for Indirect Costs (IDCs) on IDC Base Amounts charged as Match Share expenses."]
["CONDITIONAL FORMATTING APPLIED:  If the CEC Share value is greater than the Total Profit Base CEC Share ($) multiplied by the Profit Rate (%), as indicated by red conditional formatting (dark red text, light red fill), then the budget will have to be corrected and the Recipient notified that the CEC does not pay for Profit on Profit Base Amounts charged as Match Share expenses."]

{"sheet":"Lists","index":9,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 2/17/2023"}]
["Recipient/Subrecipient"]
["Select Recipient or Subrecipient"]
["Recipient"]
["Subrecipient"]
[]
[]
["CA Business Certifications"]
["Select your organization'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)"]