55B - RESO - AA - AGMT - EMPG - Laserfiche WebLink

Home Browse Search

CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal DES) This tab provides detailed instructions on how to complete the Financial Management Farms Workbook v1.15. For further guidance, please refer to your Program Representative. TA8 ISECTION EXPLANATION INSTRUCTIONS FOR ENABLING MACROS IN EXCEL 2003, EXCEL 2007 AND EXCEL 2010 INSTRUCTIONS FOR ENABLING MACROS- EXCEL 2003 Save the FMFW v1.15 to your computer With the FMFW v1.15 open, click on TOOLS, MACRO, SECURITY... Under the SECURITY LEVEL tab, select the MEDIUM or LOW setting. The MEDIUM setting will prompt you to enable /disable macros each time the file Is opened. This will prevent potentially unsafe macros from running. The LOW setting will enable macros without prompt. it Is recommended that You have vws snftwere Installed and updated If using the LOW setting to prevent unsafe macros from running In other Flies. Save, Close, and Re -open the workbook- Macros will be enabled. INSTRUCTIONS FOR ENABLING MACROS- EXCEL 200] Save the FMFW vi. 15W your computer Open the FMFW VI Click on the round Office button 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 round 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 Select the Macro Settings module along the left Set the Macro Settings to Enable all macros... Check the Trust eases to the VBA protect.. option Hit OK Save, Close, and Re -open the workbook- Macros will be Contend. INSTRUCTIONS FOR ENABLING MACROS- EXCEL 2010 Save the FMFW v1.15 to your computer Open the FMFW v1.15 Click on the File tab, choose Options to open the Excel Options dlaloo 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 Customise the ribbon on the left side of the dialog box, select Main Tabs and then select the Developer check box Hit OK Click OR the File tab, choose Options to open the Excel Options dialog box (again). Click on Trust Center on the left side of the dialog box Click on Trust Center Settings from the right side of the dialog box Select Macros Settings on the left side of the dlaloo box Under Macros Settings click on "Enable all macros" Check the Trust access to the VBA project... option Hit OK Save, Close, and Reopen the workbook- Macros will be enabled. Note: Soma computer. m.V at run Macros correctly even If enabled by Excel. A Non -Macro notation of the workbook Is available under such circumstances. This Image represents buttons mat are placed throughout me workbook, Explanations are provided In cle chose an how to use apedgc buttons. Use the Grant Subaward Face Sheet to apply for grant programs. Each grant program requires its own separate Grant Subaward Face Sheet. Cal DES 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 DES. Please print the Grant Subaward Face Sheet in portrait format. Provide an original signature of the authorized official. The use of white out or face is Prohibited and will invalidate the slanahlre 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 Subreclplent. IS. Federal DUNS Number Enter the full 91 Federal Data Universal Numbering System (DUNS) ID number for the Subreciplent. If the Subrecipient does (Grant Subrecipient) 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 AgencV 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 the Implementing Agency Is the same as the Grant Subreciplent, enter the same title again. 2a. Federal DUNS Number Enter the full 9 -dlglt 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 contacbng Dun & Bradstreet at 865- 705 -5711 or at www.dnb.mm. 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. Implementinq 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 beginning and ending dates of the performance period for the grant (mm /dd /yvl 7. Indirect Cost Rate Indicate whether you are using the 10% up Minimis rate based on Modified Total Direct Costs (MTDC) or your current cognizant agency approved indirect cost rate agreement. A copy of the approved ICR Negotatin Agreement must be enclosed with your application. Indicate N/A if you will not be claiming indirect Costs under the award. Indirectcosts may ormay not be afiewab7e under all Fetlerat fund sources. 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 unkind 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 Certification 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 Subrecipient Agreement for the Grant Subrecpient as stated in Block 1 of the Grant Subaward Face Sheet. Enter the Payment Mailing 55B -57 FMFW vi - 2015