Laserfiche WebLink
CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) <br />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. <br />Keyboard Shortcut <br />Function <br />Ctrl + Shift + G <br />Creates a new worksheet with a pivot table that aggregates Budgeted Costs by Solution Area. Only works on the Project Ledger tab. <br />Ctrl + Shift + I <br />Resets information on top of each tab to reflect name, FIPS, subaward number, POP dates from Face Sheet <br />Ctrl + Shift + L <br />Breaks all links to external sources. <br />Ctrl + Shift + S <br />Spellchecks worksheet. <br />Ctrl + Shift + Y <br />Duplicates the active sheet, then deletes the red lines and changes blue font to black font. <br />Use the Grant Subaward Face Sheet to apply for grant programs. Each grant program requires its own separate Grant Subaward Face Sheet. Please convert the Grant Subaward Face Sheet to PDF in portrait format <br />and provide a digital signature from the authorized official. The use of white out, tape, or digital redaction is prohibited and will invalidate the signature on the Grant Subaward Face Sheet. <br />Cal OES Section: The top portion of the form contains blocks for four (4) important numbers. Please do not fill in these blocks. These numbers will be entered by Cal OES. <br />Form Field <br />Instructions <br />The Subrecipient is the unit of government or community based organization (CBO) that will have legal responsibility for these grant funds (e.g. County of <br />Alameda, City of Fresno or Women's Place of Merced). Enter the legal name of the Subrecipient that is registered with the Internal Revenue Service (IRS). <br />1. Subrecipient <br />PLEASE NOTE: All CBOs must be registered, active, and current with the IRS, Department of Justice (DOJ), and Secretary of State (SOS) websites. Failure to be <br />current will result in funds being withheld by Cal OES. <br />Effective April 4, 2022, the Federal Government transitioned from using the Data Universal Numbering System or DUNS number, to a new, non-proprietary <br />1 a. Unique Entity Identifier (UEI) <br />identifier known as a Unique Entity Identifier or UEI. For entities that have an active registration in the System for Award Management (SAM) prior to this date, the <br />UEI has automatically been assigned and no action is necessary. For all entities filing a new registration in SAM.gov on or after April 4, 2022, the UEI will be <br />assigned to that entity as part of the SAM.gov registration process. UEI registration information is available on GSA.gov at: Unique Entity Identifier Update I GSA. <br />2. Implementing Agency <br />Enter the complete name of the agency responsible for the day-to-day operation of the grant (e.g. Sheriff, Police Department, or Department of Public Works). If <br />the Implementing Agency is the same as the Subrecipient, enter the same title again. <br />FY 2023 EMPG FMFW (Macro) v.23 4 of 21 Instructions <br />