Item 36 - Resolution, Agreement, and Appropriation Adjustment Accepting the FY 2023 Emergency Management Performance Grant

Home Browse Search

CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) 1) Click on the File tab, then choose Options, which will then open a new "Excel Options" window. 2) From the new window, click "Trust Center" on the left pane. 3) Click'Trust Center Settings..:' button on the right pane, which will then open a new'Trust Center" window. Excel 2010/2013/2016/2019/365 1 4) From the "Trust Center" window, pick "Macro Settings" on left pane. 5) Choose "Disable all macros with notification" radio button on the right pane, then click OK. 6) Save, Close, and Re -open the workbook. NOTE: Each time a workbook with macros is opened, a security alert will appear. This alert may be a pop-up window or a banner across the top of the window. You must choose to enable for macros to function. Below is a table of the macro buttons available on many of the worksheets in this workbook. Button Function Sort (A-Z) Sorts table by project letter, from A to Z. Spellcheck Spellchecks the worksheet. Clear Filters Clears all filters applied to any of the tables. Calculate M&A Calculates maximum allowable M&A based on total cost of all non-M&A projects. Black Font Selects the entire row(s) of the selected cell(s) and changes the font color to black. Any strikethroughs will be removed. Red Strikethrough Selects the entire row(s) of the selected cell (s) and changes the font color to red. A red strikethrough will be added. Blue Font Selects the entire row(s) of the selected cell(s) and changes the font color to blue. Any strikethroughs will be removed. Add Row Adds row below the selected cell. Delete Row Deletes entire row(s) of selected cell(s). Selection must be contiguous if multiple cells are selected. Validate Worksheet Restores formulas and formatting to default values in the appropriate cells. This macro does not erase data. FY 2023 EMPG FMFW (Macro) v.23 2 of 21 Instructions