55A - RESO - AA- EMPG - Laserfiche WebLink

Home Browse Search

CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) This tab provides detailed instructions on how to complete the Financial Management Farms Workbook v1.16. For further guidance, please refer to your Program Representative. TAB ISECTION IEXPLANATION INSTRUCTIONS FOR ENABLING MACROS IN EXCEL 2003, EXCEL 2007 AND EXCEL 2010 INSTRUCTIONS FOR ENABLING MACROS- EXCEL 2003 Save the FMFW vi.16 W your computer With the FMFW v1.16 open, click on TOOLS -> MACRO -> SECURQy... Under the SECURITY LEVEL tab, select the MEDIUM or LOW setting. The MEDIUM setting will Prompt you to enable/monce macros each time the file Ia opened. This will prevent potentially unsafe macros from running. The LOW setting will enable macros without pmmpt. It Is recommended that you have virus software Installed and updated if using the LOW setting to prevent unsafe macros from running In other Flies. Save, Close, and Re -open the a mkbeok- Macros will be enabled. INSTRUCTIONS FOR ENABLING MACROS- EXCEL 2007 Save the FMFW v1. 16 to your mmput.r Open the FMFW vine Click on the mund Office butted In the top left Click on Excel Options In the lower right of the drop down box Select Popular module along the left side Check the Show Developer tab In the Ribbon option Hit OK Click on the munit Office button In the top left (again) Click on Excel Options In the lower right of the drop down box Select the Trust Center module along the left Click on the Trust Center Settings... button Erhart the Macro Settings module along the left Set the Macro Settings to Enable all macros... Check the Trust access In the VIA project... option HIt OK Save, Close, and Re open the workbook Macros will be enabled. INSTRUCTIONS FOR ENABLING MACROS - EXCEL 2010 Save the FMFW vl.l6 to your commuter Open the FMFW v1.16 Click on the File tab, choose Options W open the Excel Options tllalog box. Click On Customize Ribbon on the left side of the dialog box Under Choose commands from the left side of the dialog box, select Popular Commands. Under Customize the ribbon on the left side of the dialog box, lent Mal. Tabs and then salsa the Developer check fir% HI[ Our Click on the File tab, chaos. Options to open the Evrel Options dialog box (again). Click an Trust Center on the left side of the dialed box Click on Trust Center Settings from the right side of the dialog box Select Macros Ear ings on the left side of the dialog box Under Macro. Settings dick on "Enable all macros" Check the Trust amass. the VIA project... option Hit OK Save, Close, and Re -open the workbook- Macros will be marled. Note: Some computers may not run Macros correctly even H enabled by Excal. A Non -Mac. vacated of the workbook le available mtdersuch dreuas.Uses. Thls Image represents buttons that are placed throughout me Workbook. waimatlons are provided In this sheet on how W use specific buttons. Use the Grant Subaward Face Sheet to apply nor grant programs. Each grant program requires its own separate Grant Subaward Face Sheet. Cal OES Section: The top portion of the form contains blocks for four (4) Important numbers. Please do not NII In these blocks. These numbers will be entered by Cal OES. Please print the Grant Subaward Face Sheet In portrait format. Provide an original signature of the authorized official. The use of white out or tape is omhibited and will invalidate the signature on the Grant Subaward Face Sheet. 1. Subrecipient The Subreclplent Is the unit of government or community based organization (CBO) that will have legal responsibility for these grant funds (e.g. County of Alameda, City of Fresno or Women's Place of Merced). Enter the legal title of the Subrecipient. Ia. Federal DUNS Number Enter the full 9 1 Federal Data Universal Numbering System (DUNS) ID number for the Subreclplent. If the Subrecipient does (Grant Subreclplent) not yet have a DUNS number assigned, one may be obtained by contacting Dun & Bradstreet at 866 -705 -5711 or at www.dnb.com. This applies to federally funded grants only. Your DUNS # must be current and active In the System for Award Management (SAM) at the time of your Award. 2. Implementing Agency Enter the complete name of the agency responsible for the day-to -da o operation of the rant e. Sheriff, Police Department, or P 9 Y P Y P dr (, P 4. Location of Project Department of Public Works). If the Implementing Agency is the same as the Grant Subrecipient, enter the same title again. 2a, Federal DUNS Number Enter the full 9 -digit Federal Data Universal Numbering System (DUNS) ID number for the Implementing Agency. If the ( Implementinq Agency) Implementing Agency does not yet have a DUNS number assigned, one may be obtained by contacting Dun & Bradstreet at 866- 705 -5711 or at www.dnb.com. This applies to federally funded grants only. Your DUNS # must be current and active in the System for Award Management at the time of your Award. 3. Implementing Agency Address Enter the address of the Implementing Agency. Provide the complete nine digit zip code (Zip +4). 4. Location of Project Enter the City and County/Operational Area where the project is located. Provide the complete nine digit zip code (Zip +4). 5. Disaster /Program Title Enter the name of the Disaster or Program providing the funds for this grant award. A disaster may be referred by the federal declaration number. Program titles should be complete without the use of acronyms. 6. Performance Period Enter beglnninq and ending dates of the performance period for the grant (mm /tld/yyW). 7, Indirect Cost Rate Indicate whether you are using the 10% he h inimis rate based on Modified TOGI Direct Casts (MTDC) or your current cognizant agency approved indirect cost rate agreement. A copy of the approved ICR Negotiating Agreement must be enclosed with your application. Indicate N/A If you will not be claiming Indirect costs under the award. Indirect costs mayor may not be aiiawabte under all Federal fund s.or... SA. - 12G. Fund Allocations For each fund source used in the program, select the correct grant year and acronym from the drop down lists, the amount of and Total Project Cost State or Federal grant funds requested, the amount of cash and /or in -kind match contributed and the resulting totals. Please do not enter both State and Federal on the same line. Block 12G should correspond to the total project cost specified in the budget. 13. Certification Paragraph Please review the Certifnatim Paragraph. 14. Official Authorized to Sign for Enter the name, title, telephone number, and e-mail address of the official authorized to enter Into the Grant Subaward the Subreclplent Agreement for the Grant Subreclplent as stated In Block 1 Of the Grant Subaward Face Sheet. Enter the Payment Malling Address where grant funds should be sent. 15, Federal Employer ID Number Enter the 9 -digit Federal Employer Identification Number for the Implementing Agency. FMFW vl.16 -1016 55A -9