Item 35 - FY 2022 Emergency Management Performance Grant

Home Browse Search

CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) Version Instructions Excel 2003 1) From the menu bar, click on TOOLS > MACRO > SECURITY. 2) From SECURITY LEVEL tab, select the MEDIUM. 3) Save, Close, and Re-open the workbook. NOTE: The MEDIUM setting will prompt you to enable or disable macros each time the file is opened. This will prevent potentially unsafe macros from running. The LOW setting will enable macros without a prompt. Excel 2007 1) Click the round "Office" button in upper left corner of the window. 2) Click "Excel Options" button near lower-right corner. 3) From "Excel Options" window, select "Trust Center" on left pane. 4) Click on the "Trust Center Settings" button on the right pane, which will open a new "Trust Center" window. 5) From the new "Trust Center" window, pick "Macro Settings" on left pane. 6) Choose "Disable all macros with notification" radio button on the right pane, then click OK. 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. Excel 2010/2013/2016/2019/365 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. 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. 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. New Request Duplicates the active worksheet for reimbursement and modification requests, placing it immediately after the original worksheet. An input box will appear to name the new worksheet. Remember to use the most recent version of the worksheet when creating a new request. New Mod Item Copies the selected line and inserts it immediately below. The font color of the selected row will change to red with a red strikethrough indicating that the line item has been changed. The duplicated line will have blue font color, without a strikethrough, indicating the modified line item. Initial Application Populates the Ledger Type field with "Initial Application" and the Date field with today's date. Reimbursement Request Populates the Ledger Type field with "Reimbursement Request" and the Date field with today's date. A new "Request #" field will appear. Modification Populates the Ledger Type field with "Modification" and the Date field with today's date. A new "Request #" field will appear. Keyboard Shortcut Function Below is a table that lists macros that can be activated by using a keyboard shortcut. A shortcut requires the user to press 2 keys simultaneously: the control button and a letter. WORKBOOK INSTRUCTIONS This worksheet provides instructions on how to complete the FY 2022 Financial Management Forms Workbook (FMFW), EMPG v.22. It is divided into sections that correspond to each of the worksheets within this workbook. The first section describes the macros used in this workbook and can be ignored if you are using the non-macro version of this FMFW. For further guidance, contact your Program Representative. Section 1: MACROS Below is a table with instructions on how to enable macros in Microsoft Excel, depending on the version. Note: Some computers may not run Macros correctly even when enabled in Excel. A Non-Macro version of the workbook is available under such circumstances. Below is a table of the macro buttons available on many of the worksheets in this workbook. FY 2022 EMPG FMFW (Macro) v.22 1 of 26 Instructions ATTACHMENT B