{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Category Budget","Direct Labor","Fringe Benefits","Travel","Equipment","Materials & Misc.","Subrecipients & Vendors","Indirect Costs & Profit","Budget Updates","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":28,"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":[[11,0,11,4],[0,2,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[10,0,10,4],[23,0,23,4],[12,0,12,4],[13,0,13,4],[14,0,14,4],[15,0,15,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[35,0,35,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[27,0,27,4],[28,0,28,4],[29,0,29,4],[30,0,30,4],[31,0,31,4],[32,0,32,4],[33,0,33,4],[34,0,34,4]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 6/5/2023"},null,{"$f":"CONCATENATE('Category Budget'!$B$1,\" \",'Category Budget'!$E$1)","v":"Date of Last Approved Agreement Budget Modification:  mm/dd/yyyy"},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. The subrecipient (major) should not include retention on their invoice template, so that retention will not be double counted.  Doing this puts the responsibility on the recipient to determine how much retention to retain, if any, from their subrecipients based on their contractual agreements with their subrecipients and the CEC."]
["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":[[0,1,0,3],[3,1,3,4],[4,1,4,4],[1,0,1,4],[2,0,2,4],[2,10,2,18],[3,10,6,13],[3,15,6,18],[5,0,5,4],[6,0,6,4]]}
["Template Version 6/5/2023","Date of Last Approved Agreement Budget Modification: ",null,null,"mm/dd/yyyy",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."]
["AGREEMENT 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."]
["Agreement Number","ABC-XX-XXX",null,null,null,null,null,null,null,null,"Paste values in Blue cells below from \"Category Budget\" tab of the budget file that you want to compare against (such as another Budget Worksheet file, an Agreement Budget file, or an old budget file that you want to convert to the new templates).",null,null,null,null,"The formulas in the cells below compare the \"Category Budget\" values of the other budget file with those of this budget file.  Values that match from both budget files will receive a \"Pass\" result.  Values that DO NOT match from both budget files will receive a \"Fail\" result, which will become conditionally formatted to red."]
["Name of Organization","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":"ROUND('Direct Labor'!B6,0)","v":0},{"$f":"ROUND('Direct Labor'!C6,0)","v":0},{"$f":"ROUND('Direct Labor'!D6,0)","v":0},{"$f":"'Direct Labor'!E6","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":"ROUND('Fringe Benefits'!B6,0)","v":0},{"$f":"ROUND('Fringe Benefits'!C6,0)","v":0},{"$f":"ROUND('Fringe Benefits'!D6,0)","v":0},{"$f":"'Fringe Benefits'!E6","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":"ROUND(Travel!B6,0)","v":0},{"$f":"ROUND(Travel!C6,0)","v":0},{"$f":"ROUND(Travel!D6,0)","v":0},{"$f":"Travel!E6","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":"ROUND('Materials & Misc.'!B6,0)","v":0},{"$f":"ROUND('Materials & Misc.'!C6,0)","v":0},{"$f":"ROUND('Materials & Misc.'!D6,0)","v":0},{"$f":"'Materials & Misc.'!E6","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":"ROUND('Indirect Costs & Profit'!B8,0)","v":0},{"$f":"ROUND('Indirect Costs & Profit'!C8,0)","v":0},{"$f":"ROUND('Indirect Costs & Profit'!D8,0)","v":0},{"$f":"'Indirect Costs & Profit'!E8","v":0},null,null,null,null,null,0,0,0,0,null,"Pass","Pass","Pass","Pass"]
["Profit \n(not allowed for grant recipients)",{"$f":"ROUND('Indirect Costs & Profit'!B12,0)","v":0},{"$f":"ROUND('Indirect Costs & Profit'!C12,0)","v":0},{"$f":"ROUND('Indirect Costs & Profit'!D12,0)","v":0},{"$f":"ROUND('Indirect Costs & Profit'!E12,0)","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)",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":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,0,1,4],[2,0,2,4],[3,0,3,4],[0,1,0,4]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 6/5/2023"},{"$f":"CONCATENATE('Category Budget'!$B$1,\" \",'Category Budget'!$E$1)","v":"Date of Last Approved Agreement Budget Modification:  mm/dd/yyyy"},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."]
["AGREEMENT BUDGET"]
["Direct Labor (Unloaded)"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"ABC-XX-XXX:  ABC Company"}]
[null,"CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["Grand Totals",0,0,0,{"$f":"SUM(ROUND(B6:D6,0))","v":0}]

{"sheet":"Fringe Benefits","index":3,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,0,1,4],[2,0,2,4],[3,0,3,4],[0,1,0,4]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 6/5/2023"},{"$f":"CONCATENATE('Category Budget'!$B$1,\" \",'Category Budget'!$E$1)","v":"Date of Last Approved Agreement Budget Modification:  mm/dd/yyyy"},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."]
["AGREEMENT BUDGET"]
["Fringe Benefits"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"ABC-XX-XXX:  ABC Company"}]
[null,"CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["Grand Totals",0,0,0,{"$f":"SUM(ROUND(B6:D6,0))","v":0}]

{"sheet":"Travel","index":4,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,8,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[0,1,0,4],[7,0,7,4]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 6/5/2023"},{"$f":"CONCATENATE('Category Budget'!$B$1,\" \",'Category Budget'!$E$1)","v":"Date of Last Approved Agreement Budget Modification:  mm/dd/yyyy"},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."]
["AGREEMENT BUDGET"]
["Travel"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"ABC-XX-XXX:  ABC Company"}]
[null,"CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["Grand Totals",0,0,0,{"$f":"SUM(ROUND(B6:D6,0))","v":0}]
[]
["Worksheet Specific Instructions"]
["Invoice Supporting Documentation Requirements, per Budget Category:\n     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."]

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

{"sheet":"Materials & Misc.","index":6,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,0,3,4],[1,0,1,4],[2,0,2,4],[0,1,0,4]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 6/5/2023"},{"$f":"CONCATENATE('Category Budget'!$B$1,\" \",'Category Budget'!$E$1)","v":"Date of Last Approved Agreement Budget Modification:  mm/dd/yyyy"},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."]
["AGREEMENT BUDGET"]
["Materials & Miscellaneous"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"ABC-XX-XXX:  ABC Company"}]
[null,"CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["Grand Totals",0,0,0,{"$f":"SUM(ROUND(B6:D6,0))","v":0}]

{"sheet":"Subrecipients & Vendors","index":7,"n_rows":603,"n_cols":17,"rows_kept":603,"cut":false,"hidden":false,"merged":[[116,0,116,11],[117,0,117,11],[112,0,112,9],[113,0,113,5],[114,0,114,5],[0,0,0,2],[0,8,0,11],[110,0,110,5],[56,0,56,5],[1,0,1,11],[2,0,2,11],[3,0,3,11],[4,0,4,11],[58,0,58,11]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 6/5/2023"},null,null,null,null,null,null,null,{"$f":"CONCATENATE('Category Budget'!$B$1,\" \",'Category Budget'!$E$1)","v":"Date of Last Approved Agreement Budget Modification:  mm/dd/yyyy"},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."]
["AGREEMENT BUDGET"]
["Subrecipients & Vendors"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"ABC-XX-XXX:  ABC Company"}]
["Subrecipients"]
["Reference ID","Task #","Subrecipient\n(Please Use Legal Name)","Enitity 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","Line Item Revised Since Last Approved Budget?","Revision Notes"]
["S-1",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G7:I7,0))","v":0},"Select Yes or No"]
["S-2",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G8:I8,0))","v":0},"Select Yes or No"]
["S-3",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G9:I9,0))","v":0},"Select Yes or No"]
["S-4",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G10:I10,0))","v":0},"Select Yes or No"]
["S-5",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G11:I11,0))","v":0},"Select Yes or No"]
["S-6",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G12:I12,0))","v":0},"Select Yes or No"]
["S-7",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G13:I13,0))","v":0},"Select Yes or No"]
["S-8",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G14:I14,0))","v":0},"Select Yes or No"]
["S-9",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G15:I15,0))","v":0},"Select Yes or No"]
["S-10",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G16:I16,0))","v":0},"Select Yes or No"]
["S-11",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G17:I17,0))","v":0},"Select Yes or No"]
["S-12",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G18:I18,0))","v":0},"Select Yes or No"]
["S-13",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G19:I19,0))","v":0},"Select Yes or No"]
["S-14",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G20:I20,0))","v":0},"Select Yes or No"]
["S-15",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G21:I21,0))","v":0},"Select Yes or No"]
["S-16",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G22:I22,0))","v":0},"Select Yes or No"]
["S-17",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G23:I23,0))","v":0},"Select Yes or No"]
["S-18",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G24:I24,0))","v":0},"Select Yes or No"]
["S-19",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G25:I25,0))","v":0},"Select Yes or No"]
["S-20",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G26:I26,0))","v":0},"Select Yes or No"]
["S-21",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G27:I27,0))","v":0},"Select Yes or No"]
["S-22",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G28:I28,0))","v":0},"Select Yes or No"]
["S-23",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G29:I29,0))","v":0},"Select Yes or No"]
["S-24",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G30:I30,0))","v":0},"Select Yes or No"]
["S-25",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G31:I31,0))","v":0},"Select Yes or No"]
["S-26",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G32:I32,0))","v":0},"Select Yes or No"]
["S-27",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G33:I33,0))","v":0},"Select Yes or No"]
["S-28",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G34:I34,0))","v":0},"Select Yes or No"]
["S-29",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G35:I35,0))","v":0},"Select Yes or No"]
["S-30",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G36:I36,0))","v":0},"Select Yes or No"]
["S-31",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G37:I37,0))","v":0},"Select Yes or No"]
["S-32",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G38:I38,0))","v":0},"Select Yes or No"]
["S-33",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G39:I39,0))","v":0},"Select Yes or No"]
["S-34",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G40:I40,0))","v":0},"Select Yes or No"]
["S-35",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G41:I41,0))","v":0},"Select Yes or No"]
["S-36",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G42:I42,0))","v":0},"Select Yes or No"]
["S-37",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G43:I43,0))","v":0},"Select Yes or No"]
["S-38",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G44:I44,0))","v":0},"Select Yes or No"]
["S-39",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G45:I45,0))","v":0},"Select Yes or No"]
["S-40",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G46:I46,0))","v":0},"Select Yes or No"]
["S-41",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G47:I47,0))","v":0},"Select Yes or No"]
["S-42",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G48:I48,0))","v":0},"Select Yes or No"]
["S-43",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G49:I49,0))","v":0},"Select Yes or No"]
["S-44",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G50:I50,0))","v":0},"Select Yes or No"]
["S-45",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G51:I51,0))","v":0},"Select Yes or No"]
["S-46",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G52:I52,0))","v":0},"Select Yes or No"]
["S-47",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G53:I53,0))","v":0},"Select Yes or No"]
["S-48",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G54:I54,0))","v":0},"Select Yes or No"]
["S-49",null,"CEC USE ONLY",null,null,"None",0,0,0,{"$f":"SUM(ROUND(G55:I55,0))","v":0},"Select Yes or No"]
["S-50",null,"CEC USE ONLY",null,null,"None",0,0,0,{"$f":"SUM(ROUND(G56:I56,0))","v":0},"Select Yes or No"]
["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)","Enitity 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","Line Item Revised Since Last Approved Budget?","Revision Notes"]
["V-1",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G61:I61,0))","v":0},"Select Yes or No"]
["V-2",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G62:I62,0))","v":0},"Select Yes or No"]
["V-3",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G63:I63,0))","v":0},"Select Yes or No"]
["V-4",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G64:I64,0))","v":0},"Select Yes or No"]
["V-5",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G65:I65,0))","v":0},"Select Yes or No"]
["V-6",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G66:I66,0))","v":0},"Select Yes or No"]
["V-7",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G67:I67,0))","v":0},"Select Yes or No"]
["V-8",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G68:I68,0))","v":0},"Select Yes or No"]
["V-9",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G69:I69,0))","v":0},"Select Yes or No"]
["V-10",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G70:I70,0))","v":0},"Select Yes or No"]
["V-11",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G71:I71,0))","v":0},"Select Yes or No"]
["V-12",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G72:I72,0))","v":0},"Select Yes or No"]
["V-13",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G73:I73,0))","v":0},"Select Yes or No"]
["V-14",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G74:I74,0))","v":0},"Select Yes or No"]
["V-15",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G75:I75,0))","v":0},"Select Yes or No"]
["V-16",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G76:I76,0))","v":0},"Select Yes or No"]
["V-17",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G77:I77,0))","v":0},"Select Yes or No"]
["V-18",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G78:I78,0))","v":0},"Select Yes or No"]
["V-19",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G79:I79,0))","v":0},"Select Yes or No"]
["V-20",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G80:I80,0))","v":0},"Select Yes or No"]
["V-21",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G81:I81,0))","v":0},"Select Yes or No"]
["V-22",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G82:I82,0))","v":0},"Select Yes or No"]
["V-23",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G83:I83,0))","v":0},"Select Yes or No"]
["V-24",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G84:I84,0))","v":0},"Select Yes or No"]
["V-25",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G85:I85,0))","v":0},"Select Yes or No"]
["V-26",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G86:I86,0))","v":0},"Select Yes or No"]
["V-27",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G87:I87,0))","v":0},"Select Yes or No"]
["V-28",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G88:I88,0))","v":0},"Select Yes or No"]
["V-29",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G89:I89,0))","v":0},"Select Yes or No"]
["V-30",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G90:I90,0))","v":0},"Select Yes or No"]
["V-31",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G91:I91,0))","v":0},"Select Yes or No"]
["V-32",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G92:I92,0))","v":0},"Select Yes or No"]
["V-33",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G93:I93,0))","v":0},"Select Yes or No"]
["V-34",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G94:I94,0))","v":0},"Select Yes or No"]
["V-35",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G95:I95,0))","v":0},"Select Yes or No"]
["V-36",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G96:I96,0))","v":0},"Select Yes or No"]
["V-37",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G97:I97,0))","v":0},"Select Yes or No"]
["V-38",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G98:I98,0))","v":0},"Select Yes or No"]
["V-39",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G99:I99,0))","v":0},"Select Yes or No"]
["V-40",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G100:I100,0))","v":0},"Select Yes or No"]
["V-41",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G101:I101,0))","v":0},"Select Yes or No"]
["V-42",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G102:I102,0))","v":0},"Select Yes or No"]
["V-43",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G103:I103,0))","v":0},"Select Yes or No"]
["V-44",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G104:I104,0))","v":0},"Select Yes or No"]
["V-45",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G105:I105,0))","v":0},"Select Yes or No"]
["V-46",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G106:I106,0))","v":0},"Select Yes or No"]
["V-47",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G107:I107,0))","v":0},"Select Yes or No"]
["V-48",null,null,null,null,"None",0,0,0,{"$f":"SUM(ROUND(G108:I108,0))","v":0},"Select Yes or No"]
["V-49",null,"CEC USE ONLY",null,null,"None",0,0,0,{"$f":"SUM(ROUND(G109:I109,0))","v":0},"Select Yes or No"]
["V-50",null,"CEC USE ONLY",null,null,"None",0,0,0,{"$f":"SUM(ROUND(G110:I110,0))","v":0},"Select Yes or No"]
["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}]
[null,null,null,null,null,null,null,0]
["Worksheet Specific Instructions"]
["CONDITIONAL FORMATTING APPLIED: If the \"Line Item Revised Since Last Approved Budget?\" column is changed to Yes, the text in the entire row will turn red in order to highlight the change."]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]

{"sheet":"Indirect Costs & Profit","index":8,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,4],[9,0,9,4],[5,0,5,4],[4,0,4,4],[1,0,1,4],[2,0,2,4],[3,0,3,4]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 6/5/2023"},{"$f":"CONCATENATE('Category Budget'!$B$1,\" \",'Category Budget'!$E$1)","v":"Date of Last Approved Agreement Budget Modification:  mm/dd/yyyy"},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."]
["AGREEMENT BUDGET"]
["Indirect Costs and Profit"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"ABC-XX-XXX:  ABC Company"}]
["Select an Indirect Cost Rate Option"]
["Indirect Cost(s)"]
[null,"CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["Indirect Costs Grand Totals ",0,0,0,{"$f":"SUM(ROUND(B8:D8,0))","v":0}]
[]
["Profit"]
[null,"CEC\nShare",{"$f":"'Category Budget'!C8","v":"[Other Entity] Share"},"Match\nShare","Total"]
["Profit Grand Totals ",0,0,0,{"$f":"SUM(ROUND(B12:D12,0))","v":0}]

{"sheet":"Budget Updates","index":9,"n_rows":618,"n_cols":21,"rows_kept":618,"cut":false,"hidden":false,"merged":[[595,0,606,0],[595,1,606,1],[595,12,606,12],[595,13,606,13],[595,14,606,14],[595,15,606,15],[604,2,604,4],[605,2,605,4],[606,2,606,4],[583,0,594,0],[583,1,594,1],[583,12,594,12],[583,13,594,13],[583,14,594,14],[583,15,594,15],[592,2,592,4],[593,2,593,4],[594,2,594,4],[571,0,582,0],[571,1,582,1],[571,12,582,12],[571,13,582,13],[571,14,582,14],[571,15,582,15],[580,2,580,4],[581,2,581,4],[582,2,582,4],[559,0,570,0],[559,1,570,1],[559,12,570,12],[559,13,570,13],[559,14,570,14],[559,15,570,15],[568,2,568,4],[569,2,569,4],[570,2,570,4],[547,0,558,0],[547,1,558,1],[547,12,558,12],[547,13,558,13],[547,14,558,14],[547,15,558,15],[556,2,556,4],[557,2,557,4],[558,2,558,4],[535,0,546,0],[535,1,546,1],[535,12,546,12],[535,13,546,13],[535,14,546,14],[535,15,546,15],[544,2,544,4],[545,2,545,4],[546,2,546,4],[523,0,534,0],[523,1,534,1],[523,12,534,12],[523,13,534,13],[523,14,534,14],[523,15,534,15],[532,2,532,4],[533,2,533,4],[534,2,534,4],[511,0,522,0],[511,1,522,1],[511,12,522,12],[511,13,522,13],[511,14,522,14],[511,15,522,15],[520,2,520,4],[521,2,521,4],[522,2,522,4],[499,0,510,0],[499,1,510,1],[499,12,510,12],[499,13,510,13],[499,14,510,14],[499,15,510,15],[508,2,508,4],[509,2,509,4],[510,2,510,4],[487,0,498,0],[487,1,498,1],[487,12,498,12],[487,13,498,13],[487,14,498,14],[487,15,498,15],[496,2,496,4],[497,2,497,4],[498,2,498,4],[475,0,486,0],[475,1,486,1],[475,12,486,12],[475,13,486,13],[475,14,486,14],[475,15,486,15],[484,2,484,4],[485,2,485,4],[486,2,486,4],[463,0,474,0],[463,1,474,1],[463,12,474,12],[463,13,474,13],[463,14,474,14],[463,15,474,15],[472,2,472,4],[473,2,473,4],[474,2,474,4],[451,0,462,0],[451,1,462,1],[451,12,462,12],[451,13,462,13],[451,14,462,14],[451,15,462,15],[460,2,460,4],[461,2,461,4],[462,2,462,4],[439,0,450,0],[439,1,450,1],[439,12,450,12],[439,13,450,13],[439,14,450,14],[439,15,450,15],[448,2,448,4],[449,2,449,4],[450,2,450,4],[427,0,438,0],[427,1,438,1],[427,12,438,12],[427,13,438,13],[427,14,438,14],[427,15,438,15],[436,2,436,4],[437,2,437,4],[438,2,438,4],[415,0,426,0],[415,1,426,1],[415,12,426,12],[415,13,426,13],[415,14,426,14],[415,15,426,15],[424,2,424,4],[425,2,425,4],[426,2,426,4],[403,0,414,0],[403,1,414,1],[403,12,414,12],[403,13,414,13],[403,14,414,14],[403,15,414,15],[412,2,412,4],[413,2,413,4],[414,2,414,4],[391,0,402,0],[391,1,402,1],[391,12,402,12],[391,13,402,13],[391,14,402,14],[391,15,402,15],[400,2,400,4],[401,2,401,4],[402,2,402,4],[379,0,390,0],[379,1,390,1],[379,12,390,12],[379,13,390,13],[379,14,390,14],[379,15,390,15],[388,2,388,4],[389,2,389,4],[390,2,390,4],[367,0,378,0],[367,1,378,1],[367,12,378,12],[367,13,378,13],[367,14,378,14],[367,15,378,15],[376,2,376,4],[377,2,377,4],[378,2,378,4],[355,0,366,0],[355,1,366,1],[355,12,366,12],[355,13,366,13],[355,14,366,14],[355,15,366,15],[364,2,364,4],[365,2,365,4],[366,2,366,4],[343,0,354,0],[343,1,354,1],[343,12,354,12],[343,13,354,13],[343,14,354,14],[343,15,354,15],[352,2,352,4],[353,2,353,4],[354,2,354,4],[331,0,342,0],[331,1,342,1],[331,12,342,12],[331,13,342,13],[331,14,342,14],[331,15,342,15],[340,2,340,4],[341,2,341,4],[342,2,342,4],[319,0,330,0],[319,1,330,1],[319,12,330,12],[319,13,330,13],[319,14,330,14],[319,15,330,15],[328,2,328,4],[329,2,329,4],[330,2,330,4],[307,0,318,0],[307,1,318,1],[307,12,318,12],[307,13,318,13],[307,14,318,14],[307,15,318,15],[316,2,316,4],[317,2,317,4],[318,2,318,4],[295,0,306,0],[295,1,306,1],[295,12,306,12],[295,13,306,13],[295,14,306,14],[295,15,306,15],[304,2,304,4],[305,2,305,4],[306,2,306,4],[283,0,294,0],[283,1,294,1],[283,12,294,12],[283,13,294,13],[283,14,294,14],[283,15,294,15],[292,2,292,4],[293,2,293,4],[294,2,294,4],[271,0,282,0],[271,1,282,1],[271,12,282,12],[271,13,282,13],[271,14,282,14],[271,15,282,15],[280,2,280,4],[281,2,281,4],[282,2,282,4],[259,0,270,0],[259,1,270,1],[259,12,270,12],[259,13,270,13],[259,14,270,14],[259,15,270,15],[268,2,268,4],[269,2,269,4],[270,2,270,4],[247,0,258,0],[247,1,258,1],[247,12,258,12],[247,13,258,13],[247,14,258,14],[247,15,258,15],[256,2,256,4],[257,2,257,4],[258,2,258,4],[235,0,246,0],[235,1,246,1],[235,12,246,12],[235,13,246,13],[235,14,246,14],[235,15,246,15],[244,2,244,4],[245,2,245,4],[246,2,246,4],[223,0,234,0],[223,1,234,1],[223,12,234,12],[223,13,234,13],[223,14,234,14],[223,15,234,15],[232,2,232,4],[233,2,233,4],[234,2,234,4],[211,0,222,0],[211,1,222,1],[211,12,222,12],[211,13,222,13],[211,14,222,14],[211,15,222,15],[220,2,220,4],[221,2,221,4],[222,2,222,4],[199,0,210,0],[199,1,210,1],[199,12,210,12],[199,13,210,13],[199,14,210,14],[199,15,210,15],[208,2,208,4],[209,2,209,4],[210,2,210,4],[175,1,186,1],[175,12,186,12],[175,13,186,13],[175,14,186,14],[175,15,186,15],[184,2,184,4],[185,2,185,4],[186,2,186,4],[187,0,198,0],[187,1,198,1],[187,12,198,12],[187,13,198,13],[187,14,198,14],[187,15,198,15],[196,2,196,4],[197,2,197,4],[198,2,198,4],[151,15,162,15],[160,2,160,4],[161,2,161,4],[162,2,162,4],[163,0,174,0],[163,1,174,1],[163,12,174,12],[163,13,174,13],[163,14,174,14],[163,15,174,15],[172,2,172,4],[173,2,173,4],[174,2,174,4],[139,0,150,0],[139,1,150,1],[139,12,150,12],[139,13,150,13],[139,14,150,14],[139,15,150,15],[148,2,148,4],[149,2,149,4],[150,2,150,4],[115,15,126,15],[124,2,124,4],[125,2,125,4],[126,2,126,4],[127,0,138,0],[127,1,138,1],[127,12,138,12],[127,13,138,13],[127,14,138,14],[127,15,138,15],[136,2,136,4],[137,2,137,4],[138,2,138,4],[91,15,102,15],[100,2,100,4],[101,2,101,4],[102,2,102,4],[103,0,114,0],[103,1,114,1],[103,12,114,12],[103,13,114,13],[103,14,114,14],[103,15,114,15],[112,2,112,4],[113,2,113,4],[114,2,114,4],[67,15,78,15],[76,2,76,4],[77,2,77,4],[78,2,78,4],[79,0,90,0],[79,1,90,1],[79,12,90,12],[79,13,90,13],[79,14,90,14],[79,15,90,15],[88,2,88,4],[89,2,89,4],[90,2,90,4],[67,12,78,12],[67,13,78,13],[67,14,78,14],[616,0,616,15],[617,0,617,15],[19,0,30,0],[19,1,30,1],[19,12,30,12],[19,13,30,13],[19,14,30,14],[19,15,30,15],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,0,42,0],[31,1,42,1],[31,12,42,12],[31,13,42,13],[31,14,42,14],[31,15,42,15],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,0,54,0],[43,1,54,1],[43,12,54,12],[43,13,54,13],[608,0,608,15],[609,0,609,15],[610,0,610,15],[611,0,611,15],[612,0,612,15],[613,0,613,15],[614,0,614,15],[615,0,615,15],[43,14,54,14],[43,15,54,15],[52,2,52,4],[53,2,53,4],[54,2,54,4],[55,0,66,0],[55,1,66,1],[55,12,66,12],[55,13,66,13],[55,14,66,14],[55,15,66,15],[64,2,64,4],[65,2,65,4],[66,2,66,4],[67,0,78,0],[175,0,186,0],[4,15,6,15],[3,0,3,15],[1,0,1,15],[2,0,2,15],[0,11,0,15],[5,3,5,5],[5,9,5,11],[4,3,4,11],[16,2,16,4],[0,0,0,2],[4,0,6,0],[4,1,6,1],[4,2,6,2],[4,12,6,12],[4,13,6,13],[4,14,6,14],[5,6,5,8],[17,2,17,4],[18,2,18,4],[7,0,18,0],[7,1,18,1],[7,12,18,12],[7,13,18,13],[7,14,18,14],[7,15,18,15],[151,0,162,0],[151,1,162,1],[151,12,162,12],[151,13,162,13],[151,14,162,14],[115,0,126,0],[115,1,126,1],[115,12,126,12],[115,13,126,13],[115,14,126,14],[91,0,102,0],[91,1,102,1],[91,12,102,12],[91,13,102,13],[91,14,102,14],[67,1,78,1]]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 6/5/2023"},null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('Category Budget'!$B$1,\" \",'Category Budget'!$E$1)","v":"Date of Last Approved Agreement Budget Modification:  mm/dd/yyyy"},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."]
["AGREEMENT BUDGET"]
["Budget Updates after Agreement Execution"]
[{"$f":"CONCATENATE('Category Budget'!$B$4,\":  \",'Category Budget'!$B$5)","v":"ABC-XX-XXX:  ABC Company"}]
["Change #","Date Approved","Budget Categories","All values should be rounded to the dollar ($1)",null,null,null,null,null,null,null,null,"Brief Description of and Justification for Change","Total Amount of CEC Funds Moving Between Categories","Cumulative CEC Total (will reset after DD review)","Has this budget been approved by the Division Director (DD)?**"]
[null,null,null,"CEC Share Funds",null,null,{"$f":"'Category Budget'!C8&\" Funds\"","v":"[Other Entity] Share Funds"},null,null,"Match Share Funds"]
[null,null,null,"FROM\n(Approved Budget Totals)","TO\n(Revised Budget Totals)","Amount of CEC Funds Moving Between Categories","FROM\n(Approved Budget Totals)","TO\n(Revised Budget Totals)",{"$f":"\"Amount of \"&'Category Budget'!C8&\" Funds Moving Between Categories\"","v":"Amount of [Other Entity] Share Funds Moving Between Categories"},"FROM\n(Approved Budget Totals)","TO\n(Revised Budget Totals)","Amount of Match Funds Moving Between Categories"]
[1,null,"Direct Labor",0,0,{"$f":"ROUND(E8,0)-ROUND(D8,0)","v":0},0,0,{"$f":"ROUND(H8,0)-ROUND(G8,0)","v":0},0,0,{"$f":"ROUND(K8,0)-ROUND(J8,0)","v":0},null,0,{"$f":"ROUND(N8,0)","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E9,0)-ROUND(D9,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E15,0)-ROUND(D15,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D8:D15,0))","v":0},{"$f":"SUM(ROUND(E8:E15,0))","v":0},{"$f":"SUM(ROUND(F8:F15,0))","v":0},{"$f":"SUM(ROUND(G8:G15,0))","v":0},{"$f":"SUM(ROUND(H8:H15,0))","v":0},{"$f":"SUM(ROUND(I8:I15,0))","v":0},{"$f":"SUM(ROUND(J8:J15,0))","v":0},{"$f":"SUM(ROUND(K8:K15,0))","v":0},{"$f":"SUM(ROUND(L8:L15,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F8:F15,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I8:I15,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L8:L15,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F8:F15,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I8:I15,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L8:L15,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F16=0,F18,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I16=0,I18,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L16=0,L18,\"Not Balanced\")","v":0}]
[2,null,"Direct Labor",0,0,{"$f":"ROUND(E20,0)-ROUND(D20,0)","v":0},0,0,{"$f":"ROUND(H20,0)-ROUND(G20,0)","v":0},0,0,{"$f":"ROUND(K20,0)-ROUND(J20,0)","v":0},null,0,{"$f":"IF(P8=\"Yes\",ROUND(0+N20,0),IF(O8>300000,ROUND(0+N20,0),ROUND(O8+N20,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E21,0)-ROUND(D21,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E27,0)-ROUND(D27,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D20:D27,0))","v":0},{"$f":"SUM(ROUND(E20:E27,0))","v":0},{"$f":"SUM(ROUND(F20:F27,0))","v":0},{"$f":"SUM(ROUND(G20:G27,0))","v":0},{"$f":"SUM(ROUND(H20:H27,0))","v":0},{"$f":"SUM(ROUND(I20:I27,0))","v":0},{"$f":"SUM(ROUND(J20:J27,0))","v":0},{"$f":"SUM(ROUND(K20:K27,0))","v":0},{"$f":"SUM(ROUND(L20:L27,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F20:F27,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I20:I27,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L20:L27,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F20:F27,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I20:I27,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L20:L27,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F28=0,F30,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I28=0,I30,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L28=0,L30,\"Not Balanced\")","v":0}]
[3,null,"Direct Labor",0,0,{"$f":"ROUND(E32,0)-ROUND(D32,0)","v":0},0,0,{"$f":"ROUND(H32,0)-ROUND(G32,0)","v":0},0,0,{"$f":"ROUND(K32,0)-ROUND(J32,0)","v":0},null,0,{"$f":"IF(P20=\"Yes\",ROUND(0+N32,0),IF(O20>300000,ROUND(0+N32,0),ROUND(O20+N32,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E33,0)-ROUND(D33,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E39,0)-ROUND(D39,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D32:D39,0))","v":0},{"$f":"SUM(ROUND(E32:E39,0))","v":0},{"$f":"SUM(ROUND(F32:F39,0))","v":0},{"$f":"SUM(ROUND(G32:G39,0))","v":0},{"$f":"SUM(ROUND(H32:H39,0))","v":0},{"$f":"SUM(ROUND(I32:I39,0))","v":0},{"$f":"SUM(ROUND(J32:J39,0))","v":0},{"$f":"SUM(ROUND(K32:K39,0))","v":0},{"$f":"SUM(ROUND(L32:L39,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F32:F39,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I32:I39,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L32:L39,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F32:F39,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I32:I39,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L32:L39,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F40=0,F42,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I40=0,I42,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L40=0,L42,\"Not Balanced\")","v":0}]
[4,null,"Direct Labor",0,0,{"$f":"ROUND(E44,0)-ROUND(D44,0)","v":0},0,0,{"$f":"ROUND(H44,0)-ROUND(G44,0)","v":0},0,0,{"$f":"ROUND(K44,0)-ROUND(J44,0)","v":0},null,0,{"$f":"IF(P32=\"Yes\",ROUND(0+N44,0),IF(O32>300000,ROUND(0+N44,0),ROUND(O32+N44,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E45,0)-ROUND(D45,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E51,0)-ROUND(D51,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D44:D51,0))","v":0},{"$f":"SUM(ROUND(E44:E51,0))","v":0},{"$f":"SUM(ROUND(F44:F51,0))","v":0},{"$f":"SUM(ROUND(G44:G51,0))","v":0},{"$f":"SUM(ROUND(H44:H51,0))","v":0},{"$f":"SUM(ROUND(I44:I51,0))","v":0},{"$f":"SUM(ROUND(J44:J51,0))","v":0},{"$f":"SUM(ROUND(K44:K51,0))","v":0},{"$f":"SUM(ROUND(L44:L51,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F44:F51,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I44:I51,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L44:L51,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F44:F51,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I44:I51,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L44:L51,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F52=0,F54,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I52=0,I54,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L52=0,L54,\"Not Balanced\")","v":0}]
[5,null,"Direct Labor",0,0,{"$f":"ROUND(E56,0)-ROUND(D56,0)","v":0},0,0,{"$f":"ROUND(H56,0)-ROUND(G56,0)","v":0},0,0,{"$f":"ROUND(K56,0)-ROUND(J56,0)","v":0},null,0,{"$f":"IF(P44=\"Yes\",ROUND(0+N56,0),IF(O44>300000,ROUND(0+N56,0),ROUND(O44+N56,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E57,0)-ROUND(D57,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E63,0)-ROUND(D63,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D56:D63,0))","v":0},{"$f":"SUM(ROUND(E56:E63,0))","v":0},{"$f":"SUM(ROUND(F56:F63,0))","v":0},{"$f":"SUM(ROUND(G56:G63,0))","v":0},{"$f":"SUM(ROUND(H56:H63,0))","v":0},{"$f":"SUM(ROUND(I56:I63,0))","v":0},{"$f":"SUM(ROUND(J56:J63,0))","v":0},{"$f":"SUM(ROUND(K56:K63,0))","v":0},{"$f":"SUM(ROUND(L56:L63,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F56:F63,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I56:I63,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L56:L63,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F56:F63,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I56:I63,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L56:L63,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F64=0,F66,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I64=0,I66,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L64=0,L66,\"Not Balanced\")","v":0}]
[6,null,"Direct Labor",0,0,{"$f":"ROUND(E68,0)-ROUND(D68,0)","v":0},0,0,{"$f":"ROUND(H68,0)-ROUND(G68,0)","v":0},0,0,{"$f":"ROUND(K68,0)-ROUND(J68,0)","v":0},null,0,{"$f":"IF(P56=\"Yes\",ROUND(0+N68,0),IF(O56>300000,ROUND(0+N68,0),ROUND(O56+N68,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E69,0)-ROUND(D69,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E75,0)-ROUND(D75,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D68:D75,0))","v":0},{"$f":"SUM(ROUND(E68:E75,0))","v":0},{"$f":"SUM(ROUND(F68:F75,0))","v":0},{"$f":"SUM(ROUND(G68:G75,0))","v":0},{"$f":"SUM(ROUND(H68:H75,0))","v":0},{"$f":"SUM(ROUND(I68:I75,0))","v":0},{"$f":"SUM(ROUND(J68:J75,0))","v":0},{"$f":"SUM(ROUND(K68:K75,0))","v":0},{"$f":"SUM(ROUND(L68:L75,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F68:F75,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I68:I75,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L68:L75,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F68:F75,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I68:I75,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L68:L75,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F76=0,F78,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I76=0,I78,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L76=0,L78,\"Not Balanced\")","v":0}]
[7,null,"Direct Labor",0,0,{"$f":"ROUND(E80,0)-ROUND(D80,0)","v":0},0,0,{"$f":"ROUND(H80,0)-ROUND(G80,0)","v":0},0,0,{"$f":"ROUND(K80,0)-ROUND(J80,0)","v":0},null,0,{"$f":"IF(P68=\"Yes\",ROUND(0+N80,0),IF(O68>300000,ROUND(0+N80,0),ROUND(O68+N80,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E81,0)-ROUND(D81,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E87,0)-ROUND(D87,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D80:D87,0))","v":0},{"$f":"SUM(ROUND(E80:E87,0))","v":0},{"$f":"SUM(ROUND(F80:F87,0))","v":0},{"$f":"SUM(ROUND(G80:G87,0))","v":0},{"$f":"SUM(ROUND(H80:H87,0))","v":0},{"$f":"SUM(ROUND(I80:I87,0))","v":0},{"$f":"SUM(ROUND(J80:J87,0))","v":0},{"$f":"SUM(ROUND(K80:K87,0))","v":0},{"$f":"SUM(ROUND(L80:L87,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F80:F87,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I80:I87,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L80:L87,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F80:F87,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I80:I87,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L80:L87,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F88=0,F90,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I88=0,I90,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L88=0,L90,\"Not Balanced\")","v":0}]
[8,null,"Direct Labor",0,0,{"$f":"ROUND(E92,0)-ROUND(D92,0)","v":0},0,0,{"$f":"ROUND(H92,0)-ROUND(G92,0)","v":0},0,0,{"$f":"ROUND(K92,0)-ROUND(J92,0)","v":0},null,0,{"$f":"IF(P80=\"Yes\",ROUND(0+N92,0),IF(O80>300000,ROUND(0+N92,0),ROUND(O80+N92,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E93,0)-ROUND(D93,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E99,0)-ROUND(D99,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D92:D99,0))","v":0},{"$f":"SUM(ROUND(E92:E99,0))","v":0},{"$f":"SUM(ROUND(F92:F99,0))","v":0},{"$f":"SUM(ROUND(G92:G99,0))","v":0},{"$f":"SUM(ROUND(H92:H99,0))","v":0},{"$f":"SUM(ROUND(I92:I99,0))","v":0},{"$f":"SUM(ROUND(J92:J99,0))","v":0},{"$f":"SUM(ROUND(K92:K99,0))","v":0},{"$f":"SUM(ROUND(L92:L99,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F92:F99,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I92:I99,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L92:L99,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F92:F99,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I92:I99,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L92:L99,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F100=0,F102,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I100=0,I102,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L100=0,L102,\"Not Balanced\")","v":0}]
[9,null,"Direct Labor",0,0,{"$f":"ROUND(E104,0)-ROUND(D104,0)","v":0},0,0,{"$f":"ROUND(H104,0)-ROUND(G104,0)","v":0},0,0,{"$f":"ROUND(K104,0)-ROUND(J104,0)","v":0},null,0,{"$f":"IF(P92=\"Yes\",ROUND(0+N104,0),IF(O92>300000,ROUND(0+N104,0),ROUND(O92+N104,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E105,0)-ROUND(D105,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E111,0)-ROUND(D111,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D104:D111,0))","v":0},{"$f":"SUM(ROUND(E104:E111,0))","v":0},{"$f":"SUM(ROUND(F104:F111,0))","v":0},{"$f":"SUM(ROUND(G104:G111,0))","v":0},{"$f":"SUM(ROUND(H104:H111,0))","v":0},{"$f":"SUM(ROUND(I104:I111,0))","v":0},{"$f":"SUM(ROUND(J104:J111,0))","v":0},{"$f":"SUM(ROUND(K104:K111,0))","v":0},{"$f":"SUM(ROUND(L104:L111,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F104:F111,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I104:I111,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L104:L111,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F104:F111,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I104:I111,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L104:L111,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F112=0,F114,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I112=0,I114,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L112=0,L114,\"Not Balanced\")","v":0}]
[10,null,"Direct Labor",0,0,{"$f":"ROUND(E116,0)-ROUND(D116,0)","v":0},0,0,{"$f":"ROUND(H116,0)-ROUND(G116,0)","v":0},0,0,{"$f":"ROUND(K116,0)-ROUND(J116,0)","v":0},null,0,{"$f":"IF(P104=\"Yes\",ROUND(0+N116,0),IF(O104>300000,ROUND(0+N116,0),ROUND(O104+N116,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E117,0)-ROUND(D117,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E123,0)-ROUND(D123,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D116:D123,0))","v":0},{"$f":"SUM(ROUND(E116:E123,0))","v":0},{"$f":"SUM(ROUND(F116:F123,0))","v":0},{"$f":"SUM(ROUND(G116:G123,0))","v":0},{"$f":"SUM(ROUND(H116:H123,0))","v":0},{"$f":"SUM(ROUND(I116:I123,0))","v":0},{"$f":"SUM(ROUND(J116:J123,0))","v":0},{"$f":"SUM(ROUND(K116:K123,0))","v":0},{"$f":"SUM(ROUND(L116:L123,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F116:F123,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I116:I123,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L116:L123,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F116:F123,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I116:I123,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L116:L123,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F124=0,F126,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I124=0,I126,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L124=0,L126,\"Not Balanced\")","v":0}]
[11,null,"Direct Labor",0,0,{"$f":"ROUND(E128,0)-ROUND(D128,0)","v":0},0,0,{"$f":"ROUND(H128,0)-ROUND(G128,0)","v":0},0,0,{"$f":"ROUND(K128,0)-ROUND(J128,0)","v":0},null,0,{"$f":"IF(P116=\"Yes\",ROUND(0+N128,0),IF(O116>300000,ROUND(0+N128,0),ROUND(O116+N128,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E129,0)-ROUND(D129,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E135,0)-ROUND(D135,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D128:D135,0))","v":0},{"$f":"SUM(ROUND(E128:E135,0))","v":0},{"$f":"SUM(ROUND(F128:F135,0))","v":0},{"$f":"SUM(ROUND(G128:G135,0))","v":0},{"$f":"SUM(ROUND(H128:H135,0))","v":0},{"$f":"SUM(ROUND(I128:I135,0))","v":0},{"$f":"SUM(ROUND(J128:J135,0))","v":0},{"$f":"SUM(ROUND(K128:K135,0))","v":0},{"$f":"SUM(ROUND(L128:L135,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F128:F135,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I128:I135,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L128:L135,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F128:F135,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I128:I135,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L128:L135,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F136=0,F138,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I136=0,I138,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L136=0,L138,\"Not Balanced\")","v":0}]
[12,null,"Direct Labor",0,0,{"$f":"ROUND(E140,0)-ROUND(D140,0)","v":0},0,0,{"$f":"ROUND(H140,0)-ROUND(G140,0)","v":0},0,0,{"$f":"ROUND(K140,0)-ROUND(J140,0)","v":0},null,0,{"$f":"IF(P128=\"Yes\",ROUND(0+N140,0),IF(O128>300000,ROUND(0+N140,0),ROUND(O128+N140,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E141,0)-ROUND(D141,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E147,0)-ROUND(D147,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D140:D147,0))","v":0},{"$f":"SUM(ROUND(E140:E147,0))","v":0},{"$f":"SUM(ROUND(F140:F147,0))","v":0},{"$f":"SUM(ROUND(G140:G147,0))","v":0},{"$f":"SUM(ROUND(H140:H147,0))","v":0},{"$f":"SUM(ROUND(I140:I147,0))","v":0},{"$f":"SUM(ROUND(J140:J147,0))","v":0},{"$f":"SUM(ROUND(K140:K147,0))","v":0},{"$f":"SUM(ROUND(L140:L147,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F140:F147,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I140:I147,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L140:L147,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F140:F147,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I140:I147,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L140:L147,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F148=0,F150,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I148=0,I150,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L148=0,L150,\"Not Balanced\")","v":0}]
[13,null,"Direct Labor",0,0,{"$f":"ROUND(E152,0)-ROUND(D152,0)","v":0},0,0,{"$f":"ROUND(H152,0)-ROUND(G152,0)","v":0},0,0,{"$f":"ROUND(K152,0)-ROUND(J152,0)","v":0},null,0,{"$f":"IF(P140=\"Yes\",ROUND(0+N152,0),IF(O140>300000,ROUND(0+N152,0),ROUND(O140+N152,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E153,0)-ROUND(D153,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E159,0)-ROUND(D159,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D152:D159,0))","v":0},{"$f":"SUM(ROUND(E152:E159,0))","v":0},{"$f":"SUM(ROUND(F152:F159,0))","v":0},{"$f":"SUM(ROUND(G152:G159,0))","v":0},{"$f":"SUM(ROUND(H152:H159,0))","v":0},{"$f":"SUM(ROUND(I152:I159,0))","v":0},{"$f":"SUM(ROUND(J152:J159,0))","v":0},{"$f":"SUM(ROUND(K152:K159,0))","v":0},{"$f":"SUM(ROUND(L152:L159,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F152:F159,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I152:I159,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L152:L159,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F152:F159,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I152:I159,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L152:L159,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F160=0,F162,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I160=0,I162,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L160=0,L162,\"Not Balanced\")","v":0}]
[14,null,"Direct Labor",0,0,{"$f":"ROUND(E164,0)-ROUND(D164,0)","v":0},0,0,{"$f":"ROUND(H164,0)-ROUND(G164,0)","v":0},0,0,{"$f":"ROUND(K164,0)-ROUND(J164,0)","v":0},null,0,{"$f":"IF(P152=\"Yes\",ROUND(0+N164,0),IF(O152>300000,ROUND(0+N164,0),ROUND(O152+N164,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E165,0)-ROUND(D165,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E171,0)-ROUND(D171,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D164:D171,0))","v":0},{"$f":"SUM(ROUND(E164:E171,0))","v":0},{"$f":"SUM(ROUND(F164:F171,0))","v":0},{"$f":"SUM(ROUND(G164:G171,0))","v":0},{"$f":"SUM(ROUND(H164:H171,0))","v":0},{"$f":"SUM(ROUND(I164:I171,0))","v":0},{"$f":"SUM(ROUND(J164:J171,0))","v":0},{"$f":"SUM(ROUND(K164:K171,0))","v":0},{"$f":"SUM(ROUND(L164:L171,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F164:F171,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I164:I171,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L164:L171,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F164:F171,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I164:I171,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L164:L171,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F172=0,F174,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I172=0,I174,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L172=0,L174,\"Not Balanced\")","v":0}]
[15,null,"Direct Labor",0,0,{"$f":"ROUND(E176,0)-ROUND(D176,0)","v":0},0,0,{"$f":"ROUND(H176,0)-ROUND(G176,0)","v":0},0,0,{"$f":"ROUND(K176,0)-ROUND(J176,0)","v":0},null,0,{"$f":"IF(P164=\"Yes\",ROUND(0+N176,0),IF(O164>300000,ROUND(0+N176,0),ROUND(O164+N176,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E177,0)-ROUND(D177,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E183,0)-ROUND(D183,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D176:D183,0))","v":0},{"$f":"SUM(ROUND(E176:E183,0))","v":0},{"$f":"SUM(ROUND(F176:F183,0))","v":0},{"$f":"SUM(ROUND(G176:G183,0))","v":0},{"$f":"SUM(ROUND(H176:H183,0))","v":0},{"$f":"SUM(ROUND(I176:I183,0))","v":0},{"$f":"SUM(ROUND(J176:J183,0))","v":0},{"$f":"SUM(ROUND(K176:K183,0))","v":0},{"$f":"SUM(ROUND(L176:L183,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F176:F183,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I176:I183,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L176:L183,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F176:F183,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I176:I183,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L176:L183,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F184=0,F186,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I184=0,I186,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L184=0,L186,\"Not Balanced\")","v":0}]
[16,null,"Direct Labor",0,0,{"$f":"ROUND(E188,0)-ROUND(D188,0)","v":0},0,0,{"$f":"ROUND(H188,0)-ROUND(G188,0)","v":0},0,0,{"$f":"ROUND(K188,0)-ROUND(J188,0)","v":0},null,0,{"$f":"IF(P176=\"Yes\",ROUND(0+N188,0),IF(O176>300000,ROUND(0+N188,0),ROUND(O176+N188,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E189,0)-ROUND(D189,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E195,0)-ROUND(D195,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D188:D195,0))","v":0},{"$f":"SUM(ROUND(E188:E195,0))","v":0},{"$f":"SUM(ROUND(F188:F195,0))","v":0},{"$f":"SUM(ROUND(G188:G195,0))","v":0},{"$f":"SUM(ROUND(H188:H195,0))","v":0},{"$f":"SUM(ROUND(I188:I195,0))","v":0},{"$f":"SUM(ROUND(J188:J195,0))","v":0},{"$f":"SUM(ROUND(K188:K195,0))","v":0},{"$f":"SUM(ROUND(L188:L195,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F188:F195,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I188:I195,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L188:L195,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F188:F195,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I188:I195,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L188:L195,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F196=0,F198,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I196=0,I198,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L196=0,L198,\"Not Balanced\")","v":0}]
[17,null,"Direct Labor",0,0,{"$f":"ROUND(E200,0)-ROUND(D200,0)","v":0},0,0,{"$f":"ROUND(H200,0)-ROUND(G200,0)","v":0},0,0,{"$f":"ROUND(K200,0)-ROUND(J200,0)","v":0},null,0,{"$f":"IF(P188=\"Yes\",ROUND(0+N200,0),IF(O188>300000,ROUND(0+N200,0),ROUND(O188+N200,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E201,0)-ROUND(D201,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E207,0)-ROUND(D207,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D200:D207,0))","v":0},{"$f":"SUM(ROUND(E200:E207,0))","v":0},{"$f":"SUM(ROUND(F200:F207,0))","v":0},{"$f":"SUM(ROUND(G200:G207,0))","v":0},{"$f":"SUM(ROUND(H200:H207,0))","v":0},{"$f":"SUM(ROUND(I200:I207,0))","v":0},{"$f":"SUM(ROUND(J200:J207,0))","v":0},{"$f":"SUM(ROUND(K200:K207,0))","v":0},{"$f":"SUM(ROUND(L200:L207,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F200:F207,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I200:I207,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L200:L207,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F200:F207,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I200:I207,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L200:L207,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F208=0,F210,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I208=0,I210,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L208=0,L210,\"Not Balanced\")","v":0}]
[18,null,"Direct Labor",0,0,{"$f":"ROUND(E212,0)-ROUND(D212,0)","v":0},0,0,{"$f":"ROUND(H212,0)-ROUND(G212,0)","v":0},0,0,{"$f":"ROUND(K212,0)-ROUND(J212,0)","v":0},null,0,{"$f":"IF(P200=\"Yes\",ROUND(0+N212,0),IF(O200>300000,ROUND(0+N212,0),ROUND(O200+N212,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E213,0)-ROUND(D213,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E219,0)-ROUND(D219,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D212:D219,0))","v":0},{"$f":"SUM(ROUND(E212:E219,0))","v":0},{"$f":"SUM(ROUND(F212:F219,0))","v":0},{"$f":"SUM(ROUND(G212:G219,0))","v":0},{"$f":"SUM(ROUND(H212:H219,0))","v":0},{"$f":"SUM(ROUND(I212:I219,0))","v":0},{"$f":"SUM(ROUND(J212:J219,0))","v":0},{"$f":"SUM(ROUND(K212:K219,0))","v":0},{"$f":"SUM(ROUND(L212:L219,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F212:F219,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I212:I219,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L212:L219,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F212:F219,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I212:I219,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L212:L219,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F220=0,F222,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I220=0,I222,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L220=0,L222,\"Not Balanced\")","v":0}]
[19,null,"Direct Labor",0,0,{"$f":"ROUND(E224,0)-ROUND(D224,0)","v":0},0,0,{"$f":"ROUND(H224,0)-ROUND(G224,0)","v":0},0,0,{"$f":"ROUND(K224,0)-ROUND(J224,0)","v":0},null,0,{"$f":"IF(P212=\"Yes\",ROUND(0+N224,0),IF(O212>300000,ROUND(0+N224,0),ROUND(O212+N224,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E225,0)-ROUND(D225,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E231,0)-ROUND(D231,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D224:D231,0))","v":0},{"$f":"SUM(ROUND(E224:E231,0))","v":0},{"$f":"SUM(ROUND(F224:F231,0))","v":0},{"$f":"SUM(ROUND(G224:G231,0))","v":0},{"$f":"SUM(ROUND(H224:H231,0))","v":0},{"$f":"SUM(ROUND(I224:I231,0))","v":0},{"$f":"SUM(ROUND(J224:J231,0))","v":0},{"$f":"SUM(ROUND(K224:K231,0))","v":0},{"$f":"SUM(ROUND(L224:L231,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F224:F231,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I224:I231,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L224:L231,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F224:F231,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I224:I231,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L224:L231,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F232=0,F234,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I232=0,I234,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L232=0,L234,\"Not Balanced\")","v":0}]
[20,null,"Direct Labor",0,0,{"$f":"ROUND(E236,0)-ROUND(D236,0)","v":0},0,0,{"$f":"ROUND(H236,0)-ROUND(G236,0)","v":0},0,0,{"$f":"ROUND(K236,0)-ROUND(J236,0)","v":0},null,0,{"$f":"IF(P224=\"Yes\",ROUND(0+N236,0),IF(O224>300000,ROUND(0+N236,0),ROUND(O224+N236,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E237,0)-ROUND(D237,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E243,0)-ROUND(D243,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D236:D243,0))","v":0},{"$f":"SUM(ROUND(E236:E243,0))","v":0},{"$f":"SUM(ROUND(F236:F243,0))","v":0},{"$f":"SUM(ROUND(G236:G243,0))","v":0},{"$f":"SUM(ROUND(H236:H243,0))","v":0},{"$f":"SUM(ROUND(I236:I243,0))","v":0},{"$f":"SUM(ROUND(J236:J243,0))","v":0},{"$f":"SUM(ROUND(K236:K243,0))","v":0},{"$f":"SUM(ROUND(L236:L243,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F236:F243,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I236:I243,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L236:L243,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F236:F243,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I236:I243,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L236:L243,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F244=0,F246,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I244=0,I246,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L244=0,L246,\"Not Balanced\")","v":0}]
[21,null,"Direct Labor",0,0,{"$f":"ROUND(E248,0)-ROUND(D248,0)","v":0},0,0,{"$f":"ROUND(H248,0)-ROUND(G248,0)","v":0},0,0,{"$f":"ROUND(K248,0)-ROUND(J248,0)","v":0},null,0,{"$f":"IF(P236=\"Yes\",ROUND(0+N248,0),IF(O236>300000,ROUND(0+N248,0),ROUND(O236+N248,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E249,0)-ROUND(D249,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E255,0)-ROUND(D255,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D248:D255,0))","v":0},{"$f":"SUM(ROUND(E248:E255,0))","v":0},{"$f":"SUM(ROUND(F248:F255,0))","v":0},{"$f":"SUM(ROUND(G248:G255,0))","v":0},{"$f":"SUM(ROUND(H248:H255,0))","v":0},{"$f":"SUM(ROUND(I248:I255,0))","v":0},{"$f":"SUM(ROUND(J248:J255,0))","v":0},{"$f":"SUM(ROUND(K248:K255,0))","v":0},{"$f":"SUM(ROUND(L248:L255,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F248:F255,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I248:I255,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L248:L255,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F248:F255,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I248:I255,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L248:L255,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F256=0,F258,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I256=0,I258,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L256=0,L258,\"Not Balanced\")","v":0}]
[22,null,"Direct Labor",0,0,{"$f":"ROUND(E260,0)-ROUND(D260,0)","v":0},0,0,{"$f":"ROUND(H260,0)-ROUND(G260,0)","v":0},0,0,{"$f":"ROUND(K260,0)-ROUND(J260,0)","v":0},null,0,{"$f":"IF(P248=\"Yes\",ROUND(0+N260,0),IF(O248>300000,ROUND(0+N260,0),ROUND(O248+N260,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E261,0)-ROUND(D261,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E267,0)-ROUND(D267,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D260:D267,0))","v":0},{"$f":"SUM(ROUND(E260:E267,0))","v":0},{"$f":"SUM(ROUND(F260:F267,0))","v":0},{"$f":"SUM(ROUND(G260:G267,0))","v":0},{"$f":"SUM(ROUND(H260:H267,0))","v":0},{"$f":"SUM(ROUND(I260:I267,0))","v":0},{"$f":"SUM(ROUND(J260:J267,0))","v":0},{"$f":"SUM(ROUND(K260:K267,0))","v":0},{"$f":"SUM(ROUND(L260:L267,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F260:F267,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I260:I267,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L260:L267,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F260:F267,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I260:I267,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L260:L267,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F268=0,F270,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I268=0,I270,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L268=0,L270,\"Not Balanced\")","v":0}]
[23,null,"Direct Labor",0,0,{"$f":"ROUND(E272,0)-ROUND(D272,0)","v":0},0,0,{"$f":"ROUND(H272,0)-ROUND(G272,0)","v":0},0,0,{"$f":"ROUND(K272,0)-ROUND(J272,0)","v":0},null,0,{"$f":"IF(P260=\"Yes\",ROUND(0+N272,0),IF(O260>300000,ROUND(0+N272,0),ROUND(O260+N272,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E273,0)-ROUND(D273,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E279,0)-ROUND(D279,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D272:D279,0))","v":0},{"$f":"SUM(ROUND(E272:E279,0))","v":0},{"$f":"SUM(ROUND(F272:F279,0))","v":0},{"$f":"SUM(ROUND(G272:G279,0))","v":0},{"$f":"SUM(ROUND(H272:H279,0))","v":0},{"$f":"SUM(ROUND(I272:I279,0))","v":0},{"$f":"SUM(ROUND(J272:J279,0))","v":0},{"$f":"SUM(ROUND(K272:K279,0))","v":0},{"$f":"SUM(ROUND(L272:L279,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F272:F279,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I272:I279,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L272:L279,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F272:F279,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I272:I279,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L272:L279,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F280=0,F282,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I280=0,I282,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L280=0,L282,\"Not Balanced\")","v":0}]
[24,null,"Direct Labor",0,0,{"$f":"ROUND(E284,0)-ROUND(D284,0)","v":0},0,0,{"$f":"ROUND(H284,0)-ROUND(G284,0)","v":0},0,0,{"$f":"ROUND(K284,0)-ROUND(J284,0)","v":0},null,0,{"$f":"IF(P272=\"Yes\",ROUND(0+N284,0),IF(O272>300000,ROUND(0+N284,0),ROUND(O272+N284,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E285,0)-ROUND(D285,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E291,0)-ROUND(D291,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D284:D291,0))","v":0},{"$f":"SUM(ROUND(E284:E291,0))","v":0},{"$f":"SUM(ROUND(F284:F291,0))","v":0},{"$f":"SUM(ROUND(G284:G291,0))","v":0},{"$f":"SUM(ROUND(H284:H291,0))","v":0},{"$f":"SUM(ROUND(I284:I291,0))","v":0},{"$f":"SUM(ROUND(J284:J291,0))","v":0},{"$f":"SUM(ROUND(K284:K291,0))","v":0},{"$f":"SUM(ROUND(L284:L291,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F284:F291,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I284:I291,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L284:L291,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F284:F291,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I284:I291,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L284:L291,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F292=0,F294,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I292=0,I294,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L292=0,L294,\"Not Balanced\")","v":0}]
[25,null,"Direct Labor",0,0,{"$f":"ROUND(E296,0)-ROUND(D296,0)","v":0},0,0,{"$f":"ROUND(H296,0)-ROUND(G296,0)","v":0},0,0,{"$f":"ROUND(K296,0)-ROUND(J296,0)","v":0},null,0,{"$f":"IF(P284=\"Yes\",ROUND(0+N296,0),IF(O284>300000,ROUND(0+N296,0),ROUND(O284+N296,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E297,0)-ROUND(D297,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E303,0)-ROUND(D303,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D296:D303,0))","v":0},{"$f":"SUM(ROUND(E296:E303,0))","v":0},{"$f":"SUM(ROUND(F296:F303,0))","v":0},{"$f":"SUM(ROUND(G296:G303,0))","v":0},{"$f":"SUM(ROUND(H296:H303,0))","v":0},{"$f":"SUM(ROUND(I296:I303,0))","v":0},{"$f":"SUM(ROUND(J296:J303,0))","v":0},{"$f":"SUM(ROUND(K296:K303,0))","v":0},{"$f":"SUM(ROUND(L296:L303,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F296:F303,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I296:I303,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L296:L303,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F296:F303,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I296:I303,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L296:L303,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F304=0,F306,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I304=0,I306,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L304=0,L306,\"Not Balanced\")","v":0}]
[26,null,"Direct Labor",0,0,{"$f":"ROUND(E308,0)-ROUND(D308,0)","v":0},0,0,{"$f":"ROUND(H308,0)-ROUND(G308,0)","v":0},0,0,{"$f":"ROUND(K308,0)-ROUND(J308,0)","v":0},null,0,{"$f":"IF(P296=\"Yes\",ROUND(0+N308,0),IF(O296>300000,ROUND(0+N308,0),ROUND(O296+N308,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E309,0)-ROUND(D309,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E315,0)-ROUND(D315,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D308:D315,0))","v":0},{"$f":"SUM(ROUND(E308:E315,0))","v":0},{"$f":"SUM(ROUND(F308:F315,0))","v":0},{"$f":"SUM(ROUND(G308:G315,0))","v":0},{"$f":"SUM(ROUND(H308:H315,0))","v":0},{"$f":"SUM(ROUND(I308:I315,0))","v":0},{"$f":"SUM(ROUND(J308:J315,0))","v":0},{"$f":"SUM(ROUND(K308:K315,0))","v":0},{"$f":"SUM(ROUND(L308:L315,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F308:F315,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I308:I315,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L308:L315,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F308:F315,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I308:I315,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L308:L315,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F316=0,F318,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I316=0,I318,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L316=0,L318,\"Not Balanced\")","v":0}]
[27,null,"Direct Labor",0,0,{"$f":"ROUND(E320,0)-ROUND(D320,0)","v":0},0,0,{"$f":"ROUND(H320,0)-ROUND(G320,0)","v":0},0,0,{"$f":"ROUND(K320,0)-ROUND(J320,0)","v":0},null,0,{"$f":"IF(P308=\"Yes\",ROUND(0+N320,0),IF(O308>300000,ROUND(0+N320,0),ROUND(O308+N320,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E321,0)-ROUND(D321,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E327,0)-ROUND(D327,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D320:D327,0))","v":0},{"$f":"SUM(ROUND(E320:E327,0))","v":0},{"$f":"SUM(ROUND(F320:F327,0))","v":0},{"$f":"SUM(ROUND(G320:G327,0))","v":0},{"$f":"SUM(ROUND(H320:H327,0))","v":0},{"$f":"SUM(ROUND(I320:I327,0))","v":0},{"$f":"SUM(ROUND(J320:J327,0))","v":0},{"$f":"SUM(ROUND(K320:K327,0))","v":0},{"$f":"SUM(ROUND(L320:L327,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F320:F327,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I320:I327,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L320:L327,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F320:F327,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I320:I327,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L320:L327,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F328=0,F330,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I328=0,I330,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L328=0,L330,\"Not Balanced\")","v":0}]
[28,null,"Direct Labor",0,0,{"$f":"ROUND(E332,0)-ROUND(D332,0)","v":0},0,0,{"$f":"ROUND(H332,0)-ROUND(G332,0)","v":0},0,0,{"$f":"ROUND(K332,0)-ROUND(J332,0)","v":0},null,0,{"$f":"IF(P320=\"Yes\",ROUND(0+N332,0),IF(O320>300000,ROUND(0+N332,0),ROUND(O320+N332,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E333,0)-ROUND(D333,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E339,0)-ROUND(D339,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D332:D339,0))","v":0},{"$f":"SUM(ROUND(E332:E339,0))","v":0},{"$f":"SUM(ROUND(F332:F339,0))","v":0},{"$f":"SUM(ROUND(G332:G339,0))","v":0},{"$f":"SUM(ROUND(H332:H339,0))","v":0},{"$f":"SUM(ROUND(I332:I339,0))","v":0},{"$f":"SUM(ROUND(J332:J339,0))","v":0},{"$f":"SUM(ROUND(K332:K339,0))","v":0},{"$f":"SUM(ROUND(L332:L339,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F332:F339,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I332:I339,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L332:L339,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F332:F339,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I332:I339,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L332:L339,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F340=0,F342,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I340=0,I342,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L340=0,L342,\"Not Balanced\")","v":0}]
[29,null,"Direct Labor",0,0,{"$f":"ROUND(E344,0)-ROUND(D344,0)","v":0},0,0,{"$f":"ROUND(H344,0)-ROUND(G344,0)","v":0},0,0,{"$f":"ROUND(K344,0)-ROUND(J344,0)","v":0},null,0,{"$f":"IF(P332=\"Yes\",ROUND(0+N344,0),IF(O332>300000,ROUND(0+N344,0),ROUND(O332+N344,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E345,0)-ROUND(D345,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E351,0)-ROUND(D351,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D344:D351,0))","v":0},{"$f":"SUM(ROUND(E344:E351,0))","v":0},{"$f":"SUM(ROUND(F344:F351,0))","v":0},{"$f":"SUM(ROUND(G344:G351,0))","v":0},{"$f":"SUM(ROUND(H344:H351,0))","v":0},{"$f":"SUM(ROUND(I344:I351,0))","v":0},{"$f":"SUM(ROUND(J344:J351,0))","v":0},{"$f":"SUM(ROUND(K344:K351,0))","v":0},{"$f":"SUM(ROUND(L344:L351,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F344:F351,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I344:I351,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L344:L351,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F344:F351,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I344:I351,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L344:L351,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F352=0,F354,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I352=0,I354,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L352=0,L354,\"Not Balanced\")","v":0}]
[30,null,"Direct Labor",0,0,{"$f":"ROUND(E356,0)-ROUND(D356,0)","v":0},0,0,{"$f":"ROUND(H356,0)-ROUND(G356,0)","v":0},0,0,{"$f":"ROUND(K356,0)-ROUND(J356,0)","v":0},null,0,{"$f":"IF(P344=\"Yes\",ROUND(0+N356,0),IF(O344>300000,ROUND(0+N356,0),ROUND(O344+N356,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E357,0)-ROUND(D357,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E363,0)-ROUND(D363,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D356:D363,0))","v":0},{"$f":"SUM(ROUND(E356:E363,0))","v":0},{"$f":"SUM(ROUND(F356:F363,0))","v":0},{"$f":"SUM(ROUND(G356:G363,0))","v":0},{"$f":"SUM(ROUND(H356:H363,0))","v":0},{"$f":"SUM(ROUND(I356:I363,0))","v":0},{"$f":"SUM(ROUND(J356:J363,0))","v":0},{"$f":"SUM(ROUND(K356:K363,0))","v":0},{"$f":"SUM(ROUND(L356:L363,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F356:F363,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I356:I363,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L356:L363,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F356:F363,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I356:I363,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L356:L363,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F364=0,F366,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I364=0,I366,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L364=0,L366,\"Not Balanced\")","v":0}]
[31,null,"Direct Labor",0,0,{"$f":"ROUND(E368,0)-ROUND(D368,0)","v":0},0,0,{"$f":"ROUND(H368,0)-ROUND(G368,0)","v":0},0,0,{"$f":"ROUND(K368,0)-ROUND(J368,0)","v":0},null,0,{"$f":"IF(P356=\"Yes\",ROUND(0+N368,0),IF(O356>300000,ROUND(0+N368,0),ROUND(O356+N368,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E369,0)-ROUND(D369,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E375,0)-ROUND(D375,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D368:D375,0))","v":0},{"$f":"SUM(ROUND(E368:E375,0))","v":0},{"$f":"SUM(ROUND(F368:F375,0))","v":0},{"$f":"SUM(ROUND(G368:G375,0))","v":0},{"$f":"SUM(ROUND(H368:H375,0))","v":0},{"$f":"SUM(ROUND(I368:I375,0))","v":0},{"$f":"SUM(ROUND(J368:J375,0))","v":0},{"$f":"SUM(ROUND(K368:K375,0))","v":0},{"$f":"SUM(ROUND(L368:L375,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F368:F375,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I368:I375,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L368:L375,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F368:F375,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I368:I375,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L368:L375,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F376=0,F378,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I376=0,I378,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L376=0,L378,\"Not Balanced\")","v":0}]
[32,null,"Direct Labor",0,0,{"$f":"ROUND(E380,0)-ROUND(D380,0)","v":0},0,0,{"$f":"ROUND(H380,0)-ROUND(G380,0)","v":0},0,0,{"$f":"ROUND(K380,0)-ROUND(J380,0)","v":0},null,0,{"$f":"IF(P368=\"Yes\",ROUND(0+N380,0),IF(O368>300000,ROUND(0+N380,0),ROUND(O368+N380,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E381,0)-ROUND(D381,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E387,0)-ROUND(D387,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D380:D387,0))","v":0},{"$f":"SUM(ROUND(E380:E387,0))","v":0},{"$f":"SUM(ROUND(F380:F387,0))","v":0},{"$f":"SUM(ROUND(G380:G387,0))","v":0},{"$f":"SUM(ROUND(H380:H387,0))","v":0},{"$f":"SUM(ROUND(I380:I387,0))","v":0},{"$f":"SUM(ROUND(J380:J387,0))","v":0},{"$f":"SUM(ROUND(K380:K387,0))","v":0},{"$f":"SUM(ROUND(L380:L387,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F380:F387,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I380:I387,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L380:L387,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F380:F387,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I380:I387,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L380:L387,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F388=0,F390,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I388=0,I390,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L388=0,L390,\"Not Balanced\")","v":0}]
[33,null,"Direct Labor",0,0,{"$f":"ROUND(E392,0)-ROUND(D392,0)","v":0},0,0,{"$f":"ROUND(H392,0)-ROUND(G392,0)","v":0},0,0,{"$f":"ROUND(K392,0)-ROUND(J392,0)","v":0},null,0,{"$f":"IF(P380=\"Yes\",ROUND(0+N392,0),IF(O380>300000,ROUND(0+N392,0),ROUND(O380+N392,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E393,0)-ROUND(D393,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E399,0)-ROUND(D399,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D392:D399,0))","v":0},{"$f":"SUM(ROUND(E392:E399,0))","v":0},{"$f":"SUM(ROUND(F392:F399,0))","v":0},{"$f":"SUM(ROUND(G392:G399,0))","v":0},{"$f":"SUM(ROUND(H392:H399,0))","v":0},{"$f":"SUM(ROUND(I392:I399,0))","v":0},{"$f":"SUM(ROUND(J392:J399,0))","v":0},{"$f":"SUM(ROUND(K392:K399,0))","v":0},{"$f":"SUM(ROUND(L392:L399,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F392:F399,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I392:I399,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L392:L399,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F392:F399,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I392:I399,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L392:L399,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F400=0,F402,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I400=0,I402,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L400=0,L402,\"Not Balanced\")","v":0}]
[34,null,"Direct Labor",0,0,{"$f":"ROUND(E404,0)-ROUND(D404,0)","v":0},0,0,{"$f":"ROUND(H404,0)-ROUND(G404,0)","v":0},0,0,{"$f":"ROUND(K404,0)-ROUND(J404,0)","v":0},null,0,{"$f":"IF(P392=\"Yes\",ROUND(0+N404,0),IF(O392>300000,ROUND(0+N404,0),ROUND(O392+N404,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E405,0)-ROUND(D405,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E411,0)-ROUND(D411,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D404:D411,0))","v":0},{"$f":"SUM(ROUND(E404:E411,0))","v":0},{"$f":"SUM(ROUND(F404:F411,0))","v":0},{"$f":"SUM(ROUND(G404:G411,0))","v":0},{"$f":"SUM(ROUND(H404:H411,0))","v":0},{"$f":"SUM(ROUND(I404:I411,0))","v":0},{"$f":"SUM(ROUND(J404:J411,0))","v":0},{"$f":"SUM(ROUND(K404:K411,0))","v":0},{"$f":"SUM(ROUND(L404:L411,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F404:F411,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I404:I411,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L404:L411,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F404:F411,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I404:I411,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L404:L411,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F412=0,F414,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I412=0,I414,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L412=0,L414,\"Not Balanced\")","v":0}]
[35,null,"Direct Labor",0,0,{"$f":"ROUND(E416,0)-ROUND(D416,0)","v":0},0,0,{"$f":"ROUND(H416,0)-ROUND(G416,0)","v":0},0,0,{"$f":"ROUND(K416,0)-ROUND(J416,0)","v":0},null,0,{"$f":"IF(P404=\"Yes\",ROUND(0+N416,0),IF(O404>300000,ROUND(0+N416,0),ROUND(O404+N416,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E417,0)-ROUND(D417,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E423,0)-ROUND(D423,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D416:D423,0))","v":0},{"$f":"SUM(ROUND(E416:E423,0))","v":0},{"$f":"SUM(ROUND(F416:F423,0))","v":0},{"$f":"SUM(ROUND(G416:G423,0))","v":0},{"$f":"SUM(ROUND(H416:H423,0))","v":0},{"$f":"SUM(ROUND(I416:I423,0))","v":0},{"$f":"SUM(ROUND(J416:J423,0))","v":0},{"$f":"SUM(ROUND(K416:K423,0))","v":0},{"$f":"SUM(ROUND(L416:L423,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F416:F423,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I416:I423,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L416:L423,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F416:F423,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I416:I423,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L416:L423,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F424=0,F426,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I424=0,I426,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L424=0,L426,\"Not Balanced\")","v":0}]
[36,null,"Direct Labor",0,0,{"$f":"ROUND(E428,0)-ROUND(D428,0)","v":0},0,0,{"$f":"ROUND(H428,0)-ROUND(G428,0)","v":0},0,0,{"$f":"ROUND(K428,0)-ROUND(J428,0)","v":0},null,0,{"$f":"IF(P416=\"Yes\",ROUND(0+N428,0),IF(O416>300000,ROUND(0+N428,0),ROUND(O416+N428,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E429,0)-ROUND(D429,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E435,0)-ROUND(D435,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D428:D435,0))","v":0},{"$f":"SUM(ROUND(E428:E435,0))","v":0},{"$f":"SUM(ROUND(F428:F435,0))","v":0},{"$f":"SUM(ROUND(G428:G435,0))","v":0},{"$f":"SUM(ROUND(H428:H435,0))","v":0},{"$f":"SUM(ROUND(I428:I435,0))","v":0},{"$f":"SUM(ROUND(J428:J435,0))","v":0},{"$f":"SUM(ROUND(K428:K435,0))","v":0},{"$f":"SUM(ROUND(L428:L435,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F428:F435,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I428:I435,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L428:L435,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F428:F435,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I428:I435,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L428:L435,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F436=0,F438,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I436=0,I438,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L436=0,L438,\"Not Balanced\")","v":0}]
[37,null,"Direct Labor",0,0,{"$f":"ROUND(E440,0)-ROUND(D440,0)","v":0},0,0,{"$f":"ROUND(H440,0)-ROUND(G440,0)","v":0},0,0,{"$f":"ROUND(K440,0)-ROUND(J440,0)","v":0},null,0,{"$f":"IF(P428=\"Yes\",ROUND(0+N440,0),IF(O428>300000,ROUND(0+N440,0),ROUND(O428+N440,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E441,0)-ROUND(D441,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E447,0)-ROUND(D447,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D440:D447,0))","v":0},{"$f":"SUM(ROUND(E440:E447,0))","v":0},{"$f":"SUM(ROUND(F440:F447,0))","v":0},{"$f":"SUM(ROUND(G440:G447,0))","v":0},{"$f":"SUM(ROUND(H440:H447,0))","v":0},{"$f":"SUM(ROUND(I440:I447,0))","v":0},{"$f":"SUM(ROUND(J440:J447,0))","v":0},{"$f":"SUM(ROUND(K440:K447,0))","v":0},{"$f":"SUM(ROUND(L440:L447,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F440:F447,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I440:I447,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L440:L447,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F440:F447,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I440:I447,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L440:L447,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F448=0,F450,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I448=0,I450,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L448=0,L450,\"Not Balanced\")","v":0}]
[38,null,"Direct Labor",0,0,{"$f":"ROUND(E452,0)-ROUND(D452,0)","v":0},0,0,{"$f":"ROUND(H452,0)-ROUND(G452,0)","v":0},0,0,{"$f":"ROUND(K452,0)-ROUND(J452,0)","v":0},null,0,{"$f":"IF(P440=\"Yes\",ROUND(0+N452,0),IF(O440>300000,ROUND(0+N452,0),ROUND(O440+N452,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E453,0)-ROUND(D453,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E459,0)-ROUND(D459,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D452:D459,0))","v":0},{"$f":"SUM(ROUND(E452:E459,0))","v":0},{"$f":"SUM(ROUND(F452:F459,0))","v":0},{"$f":"SUM(ROUND(G452:G459,0))","v":0},{"$f":"SUM(ROUND(H452:H459,0))","v":0},{"$f":"SUM(ROUND(I452:I459,0))","v":0},{"$f":"SUM(ROUND(J452:J459,0))","v":0},{"$f":"SUM(ROUND(K452:K459,0))","v":0},{"$f":"SUM(ROUND(L452:L459,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F452:F459,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I452:I459,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L452:L459,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F452:F459,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I452:I459,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L452:L459,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F460=0,F462,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I460=0,I462,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L460=0,L462,\"Not Balanced\")","v":0}]
[39,null,"Direct Labor",0,0,{"$f":"ROUND(E464,0)-ROUND(D464,0)","v":0},0,0,{"$f":"ROUND(H464,0)-ROUND(G464,0)","v":0},0,0,{"$f":"ROUND(K464,0)-ROUND(J464,0)","v":0},null,0,{"$f":"IF(P452=\"Yes\",ROUND(0+N464,0),IF(O452>300000,ROUND(0+N464,0),ROUND(O452+N464,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E465,0)-ROUND(D465,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E471,0)-ROUND(D471,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D464:D471,0))","v":0},{"$f":"SUM(ROUND(E464:E471,0))","v":0},{"$f":"SUM(ROUND(F464:F471,0))","v":0},{"$f":"SUM(ROUND(G464:G471,0))","v":0},{"$f":"SUM(ROUND(H464:H471,0))","v":0},{"$f":"SUM(ROUND(I464:I471,0))","v":0},{"$f":"SUM(ROUND(J464:J471,0))","v":0},{"$f":"SUM(ROUND(K464:K471,0))","v":0},{"$f":"SUM(ROUND(L464:L471,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F464:F471,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I464:I471,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L464:L471,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F464:F471,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I464:I471,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L464:L471,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F472=0,F474,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I472=0,I474,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L472=0,L474,\"Not Balanced\")","v":0}]
[40,null,"Direct Labor",0,0,{"$f":"ROUND(E476,0)-ROUND(D476,0)","v":0},0,0,{"$f":"ROUND(H476,0)-ROUND(G476,0)","v":0},0,0,{"$f":"ROUND(K476,0)-ROUND(J476,0)","v":0},null,0,{"$f":"IF(P464=\"Yes\",ROUND(0+N476,0),IF(O464>300000,ROUND(0+N476,0),ROUND(O464+N476,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E477,0)-ROUND(D477,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E483,0)-ROUND(D483,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D476:D483,0))","v":0},{"$f":"SUM(ROUND(E476:E483,0))","v":0},{"$f":"SUM(ROUND(F476:F483,0))","v":0},{"$f":"SUM(ROUND(G476:G483,0))","v":0},{"$f":"SUM(ROUND(H476:H483,0))","v":0},{"$f":"SUM(ROUND(I476:I483,0))","v":0},{"$f":"SUM(ROUND(J476:J483,0))","v":0},{"$f":"SUM(ROUND(K476:K483,0))","v":0},{"$f":"SUM(ROUND(L476:L483,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F476:F483,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I476:I483,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L476:L483,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F476:F483,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I476:I483,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L476:L483,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F484=0,F486,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I484=0,I486,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L484=0,L486,\"Not Balanced\")","v":0}]
[41,null,"Direct Labor",0,0,{"$f":"ROUND(E488,0)-ROUND(D488,0)","v":0},0,0,{"$f":"ROUND(H488,0)-ROUND(G488,0)","v":0},0,0,{"$f":"ROUND(K488,0)-ROUND(J488,0)","v":0},null,0,{"$f":"IF(P476=\"Yes\",ROUND(0+N488,0),IF(O476>300000,ROUND(0+N488,0),ROUND(O476+N488,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E489,0)-ROUND(D489,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E495,0)-ROUND(D495,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D488:D495,0))","v":0},{"$f":"SUM(ROUND(E488:E495,0))","v":0},{"$f":"SUM(ROUND(F488:F495,0))","v":0},{"$f":"SUM(ROUND(G488:G495,0))","v":0},{"$f":"SUM(ROUND(H488:H495,0))","v":0},{"$f":"SUM(ROUND(I488:I495,0))","v":0},{"$f":"SUM(ROUND(J488:J495,0))","v":0},{"$f":"SUM(ROUND(K488:K495,0))","v":0},{"$f":"SUM(ROUND(L488:L495,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F488:F495,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I488:I495,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L488:L495,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F488:F495,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I488:I495,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L488:L495,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F496=0,F498,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I496=0,I498,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L496=0,L498,\"Not Balanced\")","v":0}]
[42,null,"Direct Labor",0,0,{"$f":"ROUND(E500,0)-ROUND(D500,0)","v":0},0,0,{"$f":"ROUND(H500,0)-ROUND(G500,0)","v":0},0,0,{"$f":"ROUND(K500,0)-ROUND(J500,0)","v":0},null,0,{"$f":"IF(P488=\"Yes\",ROUND(0+N500,0),IF(O488>300000,ROUND(0+N500,0),ROUND(O488+N500,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E501,0)-ROUND(D501,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E507,0)-ROUND(D507,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D500:D507,0))","v":0},{"$f":"SUM(ROUND(E500:E507,0))","v":0},{"$f":"SUM(ROUND(F500:F507,0))","v":0},{"$f":"SUM(ROUND(G500:G507,0))","v":0},{"$f":"SUM(ROUND(H500:H507,0))","v":0},{"$f":"SUM(ROUND(I500:I507,0))","v":0},{"$f":"SUM(ROUND(J500:J507,0))","v":0},{"$f":"SUM(ROUND(K500:K507,0))","v":0},{"$f":"SUM(ROUND(L500:L507,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F500:F507,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I500:I507,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L500:L507,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F500:F507,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I500:I507,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L500:L507,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F508=0,F510,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I508=0,I510,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L508=0,L510,\"Not Balanced\")","v":0}]
[43,null,"Direct Labor",0,0,{"$f":"ROUND(E512,0)-ROUND(D512,0)","v":0},0,0,{"$f":"ROUND(H512,0)-ROUND(G512,0)","v":0},0,0,{"$f":"ROUND(K512,0)-ROUND(J512,0)","v":0},null,0,{"$f":"IF(P500=\"Yes\",ROUND(0+N512,0),IF(O500>300000,ROUND(0+N512,0),ROUND(O500+N512,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E513,0)-ROUND(D513,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E519,0)-ROUND(D519,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D512:D519,0))","v":0},{"$f":"SUM(ROUND(E512:E519,0))","v":0},{"$f":"SUM(ROUND(F512:F519,0))","v":0},{"$f":"SUM(ROUND(G512:G519,0))","v":0},{"$f":"SUM(ROUND(H512:H519,0))","v":0},{"$f":"SUM(ROUND(I512:I519,0))","v":0},{"$f":"SUM(ROUND(J512:J519,0))","v":0},{"$f":"SUM(ROUND(K512:K519,0))","v":0},{"$f":"SUM(ROUND(L512:L519,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F512:F519,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I512:I519,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L512:L519,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F512:F519,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I512:I519,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L512:L519,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F520=0,F522,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I520=0,I522,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L520=0,L522,\"Not Balanced\")","v":0}]
[44,null,"Direct Labor",0,0,{"$f":"ROUND(E524,0)-ROUND(D524,0)","v":0},0,0,{"$f":"ROUND(H524,0)-ROUND(G524,0)","v":0},0,0,{"$f":"ROUND(K524,0)-ROUND(J524,0)","v":0},null,0,{"$f":"IF(P512=\"Yes\",ROUND(0+N524,0),IF(O512>300000,ROUND(0+N524,0),ROUND(O512+N524,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E525,0)-ROUND(D525,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E531,0)-ROUND(D531,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D524:D531,0))","v":0},{"$f":"SUM(ROUND(E524:E531,0))","v":0},{"$f":"SUM(ROUND(F524:F531,0))","v":0},{"$f":"SUM(ROUND(G524:G531,0))","v":0},{"$f":"SUM(ROUND(H524:H531,0))","v":0},{"$f":"SUM(ROUND(I524:I531,0))","v":0},{"$f":"SUM(ROUND(J524:J531,0))","v":0},{"$f":"SUM(ROUND(K524:K531,0))","v":0},{"$f":"SUM(ROUND(L524:L531,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F524:F531,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I524:I531,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L524:L531,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F524:F531,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I524:I531,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L524:L531,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F532=0,F534,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I532=0,I534,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L532=0,L534,\"Not Balanced\")","v":0}]
[45,null,"Direct Labor",0,0,{"$f":"ROUND(E536,0)-ROUND(D536,0)","v":0},0,0,{"$f":"ROUND(H536,0)-ROUND(G536,0)","v":0},0,0,{"$f":"ROUND(K536,0)-ROUND(J536,0)","v":0},null,0,{"$f":"IF(P524=\"Yes\",ROUND(0+N536,0),IF(O524>300000,ROUND(0+N536,0),ROUND(O524+N536,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E537,0)-ROUND(D537,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E543,0)-ROUND(D543,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D536:D543,0))","v":0},{"$f":"SUM(ROUND(E536:E543,0))","v":0},{"$f":"SUM(ROUND(F536:F543,0))","v":0},{"$f":"SUM(ROUND(G536:G543,0))","v":0},{"$f":"SUM(ROUND(H536:H543,0))","v":0},{"$f":"SUM(ROUND(I536:I543,0))","v":0},{"$f":"SUM(ROUND(J536:J543,0))","v":0},{"$f":"SUM(ROUND(K536:K543,0))","v":0},{"$f":"SUM(ROUND(L536:L543,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F536:F543,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I536:I543,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L536:L543,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F536:F543,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I536:I543,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L536:L543,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F544=0,F546,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I544=0,I546,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L544=0,L546,\"Not Balanced\")","v":0}]
[46,null,"Direct Labor",0,0,{"$f":"ROUND(E548,0)-ROUND(D548,0)","v":0},0,0,{"$f":"ROUND(H548,0)-ROUND(G548,0)","v":0},0,0,{"$f":"ROUND(K548,0)-ROUND(J548,0)","v":0},null,0,{"$f":"IF(P536=\"Yes\",ROUND(0+N548,0),IF(O536>300000,ROUND(0+N548,0),ROUND(O536+N548,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E549,0)-ROUND(D549,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E555,0)-ROUND(D555,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D548:D555,0))","v":0},{"$f":"SUM(ROUND(E548:E555,0))","v":0},{"$f":"SUM(ROUND(F548:F555,0))","v":0},{"$f":"SUM(ROUND(G548:G555,0))","v":0},{"$f":"SUM(ROUND(H548:H555,0))","v":0},{"$f":"SUM(ROUND(I548:I555,0))","v":0},{"$f":"SUM(ROUND(J548:J555,0))","v":0},{"$f":"SUM(ROUND(K548:K555,0))","v":0},{"$f":"SUM(ROUND(L548:L555,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F548:F555,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I548:I555,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L548:L555,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F548:F555,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I548:I555,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L548:L555,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F556=0,F558,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I556=0,I558,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L556=0,L558,\"Not Balanced\")","v":0}]
[47,null,"Direct Labor",0,0,{"$f":"ROUND(E560,0)-ROUND(D560,0)","v":0},0,0,{"$f":"ROUND(H560,0)-ROUND(G560,0)","v":0},0,0,{"$f":"ROUND(K560,0)-ROUND(J560,0)","v":0},null,0,{"$f":"IF(P548=\"Yes\",ROUND(0+N560,0),IF(O548>300000,ROUND(0+N560,0),ROUND(O548+N560,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E561,0)-ROUND(D561,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E567,0)-ROUND(D567,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D560:D567,0))","v":0},{"$f":"SUM(ROUND(E560:E567,0))","v":0},{"$f":"SUM(ROUND(F560:F567,0))","v":0},{"$f":"SUM(ROUND(G560:G567,0))","v":0},{"$f":"SUM(ROUND(H560:H567,0))","v":0},{"$f":"SUM(ROUND(I560:I567,0))","v":0},{"$f":"SUM(ROUND(J560:J567,0))","v":0},{"$f":"SUM(ROUND(K560:K567,0))","v":0},{"$f":"SUM(ROUND(L560:L567,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F560:F567,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I560:I567,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L560:L567,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F560:F567,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I560:I567,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L560:L567,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F568=0,F570,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I568=0,I570,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L568=0,L570,\"Not Balanced\")","v":0}]
[48,null,"Direct Labor",0,0,{"$f":"ROUND(E572,0)-ROUND(D572,0)","v":0},0,0,{"$f":"ROUND(H572,0)-ROUND(G572,0)","v":0},0,0,{"$f":"ROUND(K572,0)-ROUND(J572,0)","v":0},null,0,{"$f":"IF(P560=\"Yes\",ROUND(0+N572,0),IF(O560>300000,ROUND(0+N572,0),ROUND(O560+N572,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E573,0)-ROUND(D573,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E579,0)-ROUND(D579,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D572:D579,0))","v":0},{"$f":"SUM(ROUND(E572:E579,0))","v":0},{"$f":"SUM(ROUND(F572:F579,0))","v":0},{"$f":"SUM(ROUND(G572:G579,0))","v":0},{"$f":"SUM(ROUND(H572:H579,0))","v":0},{"$f":"SUM(ROUND(I572:I579,0))","v":0},{"$f":"SUM(ROUND(J572:J579,0))","v":0},{"$f":"SUM(ROUND(K572:K579,0))","v":0},{"$f":"SUM(ROUND(L572:L579,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F572:F579,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I572:I579,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L572:L579,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F572:F579,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I572:I579,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L572:L579,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F580=0,F582,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I580=0,I582,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L580=0,L582,\"Not Balanced\")","v":0}]
[49,null,"Direct Labor",0,0,{"$f":"ROUND(E584,0)-ROUND(D584,0)","v":0},0,0,{"$f":"ROUND(H584,0)-ROUND(G584,0)","v":0},0,0,{"$f":"ROUND(K584,0)-ROUND(J584,0)","v":0},null,0,{"$f":"IF(P572=\"Yes\",ROUND(0+N584,0),IF(O572>300000,ROUND(0+N584,0),ROUND(O572+N584,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E585,0)-ROUND(D585,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E591,0)-ROUND(D591,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D584:D591,0))","v":0},{"$f":"SUM(ROUND(E584:E591,0))","v":0},{"$f":"SUM(ROUND(F584:F591,0))","v":0},{"$f":"SUM(ROUND(G584:G591,0))","v":0},{"$f":"SUM(ROUND(H584:H591,0))","v":0},{"$f":"SUM(ROUND(I584:I591,0))","v":0},{"$f":"SUM(ROUND(J584:J591,0))","v":0},{"$f":"SUM(ROUND(K584:K591,0))","v":0},{"$f":"SUM(ROUND(L584:L591,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F584:F591,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I584:I591,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L584:L591,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F584:F591,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I584:I591,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L584:L591,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F592=0,F594,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I592=0,I594,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L592=0,L594,\"Not Balanced\")","v":0}]
[50,null,"Direct Labor",0,0,{"$f":"ROUND(E596,0)-ROUND(D596,0)","v":0},0,0,{"$f":"ROUND(H596,0)-ROUND(G596,0)","v":0},0,0,{"$f":"ROUND(K596,0)-ROUND(J596,0)","v":0},null,0,{"$f":"IF(P584=\"Yes\",ROUND(0+N596,0),IF(O584>300000,ROUND(0+N596,0),ROUND(O584+N596,0)))","v":0},"Select Yes or No"]
[null,null,"Fringe Benefits",0,0,{"$f":"ROUND(E597,0)-ROUND(D597,0)","v":0},0,0,0,0,0,0]
[null,null,"Travel",0,0,0,0,0,0,0,0,0]
[null,null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,null,"Materials/Misc.",0,0,0,0,0,0,0,0,0]
[null,null,"Subrecipients/Vendors",0,0,0,0,0,0,0,0,0]
[null,null,"Indirect Cost",0,0,0,0,0,0,0,0,0]
[null,null,"Profit (not allowed for grant recipients)",0,0,{"$f":"ROUND(E603,0)-ROUND(D603,0)","v":0},0,0,0,0,0,0]
[null,null,"Totals",{"$f":"SUM(ROUND(D596:D603,0))","v":0},{"$f":"SUM(ROUND(E596:E603,0))","v":0},{"$f":"SUM(ROUND(F596:F603,0))","v":0},{"$f":"SUM(ROUND(G596:G603,0))","v":0},{"$f":"SUM(ROUND(H596:H603,0))","v":0},{"$f":"SUM(ROUND(I596:I603,0))","v":0},{"$f":"SUM(ROUND(J596:J603,0))","v":0},{"$f":"SUM(ROUND(K596:K603,0))","v":0},{"$f":"SUM(ROUND(L596:L603,0))","v":0}]
[null,null,"Reallocation Decrease Subtotal",null,null,{"$f":"SUMIF(F596:F603,\"< 0\")","v":0},null,null,{"$f":"SUMIF(I596:I603,\"< 0\")","v":0},null,null,{"$f":"SUMIF(L596:L603,\"< 0\")","v":0}]
[null,null,"Reallocation Increase Subtotal",null,null,{"$f":"SUMIF(F596:F603,\"> 0\")","v":0},null,null,{"$f":"SUMIF(I596:I603,\"> 0\")","v":0},null,null,{"$f":"SUMIF(L596:L603,\"> 0\")","v":0}]
[null,null,"Total Budget Reallocation Between Budget Categories",null,null,{"$f":"IF(F604=0,F606,\"Not Balanced\")","v":0},null,null,{"$f":"IF(I604=0,I606,\"Not Balanced\")","v":0},null,null,{"$f":"IF(L604=0,L606,\"Not Balanced\")","v":0}]
[]
["Worksheet Specific Instructions"]
["Rounding:  All budget values should be rounded to the dollar ($1).  Rounding of any values should be performed using standard rounding practices."]
["**Regarding Division Director Approval:  The cumulative total will reset automatically when it passes $300K, or the budget has been approved by the Division Director for any other reason listed in the Changes to Grants: Level of Approval and Notification Chart."]
["CONDITIONAL FORMATTING APPLIED:  If the amount of funding (CEC or Match Share funds) moving between categories is positive, the corresponding Category Budget cell will turn green with conditional formatting (dark green text, light green fill)."]
["CONDITIONAL FORMATTING APPLIED:  If the amount of funding (CEC or Match Share funds) moving between categories is negative, the corresponding Category Budget cell will turn red with conditional formatting (dark red text, light red fill)."]
["CONDITIONAL FORMATTING APPLIED:  If the Budget Category Total for the \"Amount of CEC Funds Moving Between Categories\" is anything other than zero, the cell fill will turn red with conditional formatting. Also, the associated \"Total Budget Reallocation Between Budget Categories\" cell will display \"Not Balanced\", and the cell fill will turn red with conditional formatting. This indicates there is not an equal amount of funds moving between categories and may require a correction. However, if the overall CEC Funds are to be increased or decreased, a formal amendment is required. Contact your CAM for more instructions."]
["CONDITIONAL FORMATTING APPLIED:  If the Budget Category Total for the \"Amount of Match Funds Moving Between Categories\" is negative, the cell fill will turn red with conditional formatting. This indicates Match Funds are decreasing and requires a formal amendment. Contact your CAM for more instructions."]
["CONDITIONAL FORMATTING APPLIED:  If the Budget Category Total for the \"Amount of Match Funds Moving Between Categories\" is anything other than zero, the associated \"Total Budget Reallocation Between Budget Categories\" cell will display \"Not Balanced\", and the cell fill will turn red with conditional formatting. This indicates there is not an equal amount of funds moving between categories and may require a correction. However, if the overall Match Share Funds are to be increased or decreased, an amendment is required. Contact your CAM for more instructions."]
["CONDITIONAL FORMATTING APPLIED:  If the \"Total Amount of CEC Funds Moving Between Categories\" is greater than or equal to $150,000, and less than or equal to $300,000, the cell fill will turn yellow with conditional formatting. This indicates an amendment is required with a higher level of approval. Contact your CAM for more instructions."]
["CONDITIONAL FORMATTING APPLIED:  If the \"Total Amount of CEC Funds Moving Between Categories\" is greater than $300,000, the cell fill will turn orange with conditional formatting. This indicates an amendment is required with an even higher level of approval. Contact your CAM for more instructions."]

{"sheet":"Lists","index":10,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Category Budget'!$A$1","v":"Template Version 6/5/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)"]
["Revision Indicator Selection"]
["Select Yes or No"]
["Yes"]
["No"]
["Budget Approved by Division Director Indicator Selection"]
["Select Yes or No"]
["Yes"]
["No"]