The URL can be used to link to this page

Home My WebLink AboutPalm Desert_FY23 EMPG Initial Application_Approved VR 4.3.24FY 2023 EMPG FMFW (Macro) v.23 FY 2023 EMPG FMFW (Macro) v.23 _FilterDatabase _xlfn.ANCHORARRAY _xlfn.FORMULATEXT _xlfn.IFERROR _xlfn.SINGLE _xlfn.SUMIFS AdminLists Authorized_Agent_Advance Authorized_Agent_Final_Reimbursement_Request Authorized_Agent_Initial_Application Authorized_Agent_Modification Authorized_Agent_Reimbursement_Request AuthorizedAgent_Clear Black_Font_Row Blue_Font_Row ClearFilters Date DD_CC_EOC_SubCat DD_CC_Equipment_SubCat DD_CC_Exercise_SubCat DD_CC_MA_SubCat DD_CC_Maintenance_SubCat DD_CC_Organization_SubCat DD_CC_Planning_SubCat DD_CC_SolutionArea DD_CC_SolutionArea DD_CC_SubCat_Lookup DD_CC_SubCat_Lookup DD_CC_Training_SubCat DD_Discipline DD_Discipline DD_EOC_SubCat DD_Equipment_Condition DD_Equipment_Condition DD_Equipment_HoldTrigger DD_Equipment_HoldTrigger DD_Equipment_SubCat DD_Equipment_SubCat DD_Exercise_Expenditure_Lookup DD_Exercise_Expenditure_Lookup DD_Exercise_Expenditure1 DD_Exercise_Expenditure2 DD_Exercise_SubCat DD_Exercise_SubCat DD_ExerciseType DD_ExerciseType DD_FundSource DD_FundSource DD_IJ DD_IJ DD_Indirect_Base DD_Indirect_Base DD_Indirect_SubCat DD_Indirect_SubCat DD_MA_Detail DD_MA_Detail DD_MA_Expenditure_Lookup DD_MA_Expenditure_Lookup DD_MA_SubCat DD_MA_SubCat DD_Maintenance_SubCat DD_Organization_Detail DD_Organization_Detail DD_Organization_Expenditure_Lookup DD_Organization_Expenditure_Lookup DD_Organization_Expenditure1 DD_Organization_Expenditure2 DD_Organization_SubCat DD_Organization_SubCat DD_Personnel_Exercise_SubCat DD_Personnel_MA_SubCat DD_Personnel_Organization_SubCat DD_Personnel_Planning_SubCat DD_Personnel_SolutionArea DD_Personnel_SolutionArea DD_Personnel_SubCat_Lookup DD_Personnel_SubCat_Lookup DD_Personnel_Training_SubCat DD_PL_CoreCapabilities DD_PL_CoreCapabilities DD_PL_PreviousIJ DD_PL_PreviousIJ DD_PL_SolutionArea DD_PL_SolutionArea DD_PL_SubCat_Lookup DD_PL_SubCat_Lookup DD_Planning_Expenditure_Lookup DD_Planning_Expenditure_Lookup DD_Planning_Expenditure1 DD_Planning_Expenditure2 DD_Planning_Expenditure3 DD_Planning_Expenditure4 DD_Planning_SubCat DD_Planning_SubCat DD_Training_Activity DD_Training_Activity DD_Training_Expenditure_Lookup DD_Training_Expenditure_Lookup DD_Training_Expenditure1 DD_Training_Expenditure2 DD_Training_Expenditure3 DD_Training_SubCat DD_Training_SubCat EndDate EndPOP EndPOP EndPOP EndPOP EndPOP EndPOP EndPOP EndPOP EndPOP EndPOP FIPS FIPS FIPS FIPS FIPS FIPS FIPS FIPS FIPS FIPS FIPS FIPSNumber Formula_Reset Indirect_Cost_Rate Initials Initials Initials Initials Initials Initials Initials Initials Initials Initials Investment_Justifications LabelDate LabelRequest LabelRequest LabelRequest LabelRequest LabelRequest LabelRequest LabelRequest LabelRequest LabelRequest LabelRequest Ledger_Type_Advance Ledger_Type_Initial_Application Ledger_Type_Modification Ledger_Type_Reimbursement_Request Ledgers_Type_Clear LedgerType LedgerType LedgerType LedgerType LedgerType LedgerType LedgerType LedgerType LedgerType LedgerType LedgerType New_Mod_Item New_Request PayAddress PayAddress PayCity PayCity PayZIP PayZIP Personnel_SourceList Print_Area Print_Area Print_Area Print_Area Print_Area Print_Area Print_Area Print_Area Print_Area Print_Area Print_Area Print_Area Print_Titles Print_Titles Print_Titles Print_Titles Print_Titles Print_Titles Print_Titles Print_Titles Print_Titles RangeApproved RangeApproved RangeApproved RangeApproved RangeApproved RangeApproved RangeApproved RangeBalance RangeBalance RangeBalance RangeBalance RangeBalance RangeBalance RangeBalance RangeBody RangeBody RangeBody RangeBody RangeBody RangeBody RangeBody RangeBody RangeBody RangeBody RangeCost RangeCost RangeCost RangeCost RangeCost RangeCost RangeCost RangeCost RangeCost RangeDollars RangeDollars RangeDollars RangeDollars RangeDollars RangeDollars RangeDollars RangeDollars RangeDollars RangeFee RangeHours RangePercent RangePercent RangePeriod RangePeriod RangePrevious RangePrevious RangePrevious RangePrevious RangePrevious RangePrevious RangePrevious RangeProjectTotal RangeSalary RangeSolutionArea RangeSource RangeThisRequest RangeThisRequest RangeThisRequest RangeThisRequest RangeThisRequest RangeThisRequest RangeThisRequest RangeUnlocked RangeUnlocked RangeUnlocked RangeUnlocked RangeUnlocked RangeUnlocked RangeUnlocked RangeUnlocked RangeUnlocked Red_Strikethru_Row RequestNumber RequestNumber RequestNumber RequestNumber RequestNumber RequestNumber RequestNumber RequestNumber RequestNumber RequestNumber RequestNumber Row_Add Row_Delete Sort_By_Project Source_CoreCapabilities Source_Discipline Source_EquipmentHoldTrigger SOURCE_EquipmentSolutionAreaSubCategoryProjectLedger Source_ExerciseNameLookup SOURCE_ExerciseType2 SOURCE_FundingSource SOURCE_FundingSourceGAFS_All source_GrantYearGAFS SOURCE_MatchType Source_OrganizationNameLookup Source_PlanningNameLookup SOURCE_PreviousAward SOURCE_SolutionAreaSubCategoryExercise SOURCE_SolutionAreaSubCategoryOrganization SOURCE_SolutionAreaSubCategoryPlanning SOURCE_SolutionAreaSubCategoryTraining SOURCE_StateGoalLookup Source_TrainingActivity Source_TrainingNameLookup SourceList SourceLists SourceLookup SourceLookups Spell_Check StartDate StartPOP StartPOP StartPOP StartPOP StartPOP StartPOP StartPOP StartPOP StartPOP StartPOP Subaward Subaward Subaward Subaward Subaward Subaward Subaward Subaward Subaward Subaward Subaward SubawardNumber Subrecipient Subrecipient Subrecipient Subrecipient Subrecipient Subrecipient Subrecipient Subrecipient Subrecipient Subrecipient Subrecipient SubrecipientName TotalApproved TotalApproved TotalApproved TotalApproved TotalApproved TotalApproved TotalApproved TotalBalance TotalBalance TotalBalance TotalBalance TotalBalance TotalBalance TotalBalance TotalCost TotalCost TotalCost TotalCost TotalCost TotalCost TotalCost TotalCost TotalCost TotalFee TotalHours TotalPercentExpended TotalPercentExpended TotalPrevious TotalPrevious TotalPrevious TotalPrevious TotalPrevious TotalPrevious TotalPrevious TotalProject TotalSalary TotalThisRequest TotalThisRequest TotalThisRequest TotalThisRequest TotalThisRequest TotalThisRequest TotalThisRequest CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of 45108 45657 8 2023 13683 13683 13683 13683 27366 9 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 0 13683 13683 13683 0 13683 27366 13683 0 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of Grant Subaward Face Sheet Cal OES 2-101 (Revised 05/2023) City of Palm Desert 0 2023-0006 92260 1 92260 92260 2 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of City of Palm Desert 0 2023-0006 45108 13683 0 0 45657 0 0 0 13683 0 0 0 0 13683 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13683 0 0 13683 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of City of Palm Desert 0 2023-0006 45108 45657 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of City of Palm Desert 0 2023-0006 45108 45657 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of City of Palm Desert 0 2023-0006 45108 45657 0 0 13683 0 0 0 13683 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.5 13683 0 13683 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of City of Palm Desert 0 2023-0006 45108 45657 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of City of Palm Desert 0 2023-0006 45108 45657 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of City of Palm Desert 0 2023-0006 45108 45657 0 0 0 0 0 0 13683 0 0 0 13683 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13683 0 13683 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of City of Palm Desert 0 2023-0006 45108 45657 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of City of Palm Desert 0 2023-0006 45108 45657 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 EMPG FMFW (Macro) v.23 of City of Palm Desert 0 2023-0006 45108 45657 73-510 Fred Waring Dr. Palm Desert, CA 92260-2524 CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES) FY 2023 HSGP FMFW (Macro) v.23 of PROJECT LEDGER Enter the planning activity. Equipment Enter the name of vendor from whom the equipment was purchased. AEL Number & Title Ledger Type Enter the name of the project. Vendor Project Description Enter course name. Final Product Condition and Disposition Initial Application Modification Grant Year Other Authorized Equipment Invoice Number Title Grant Administration Training Exercise Date: Organization Amount This Request Total Approved Project Funding Source Remaining Balance Deployed Location Course Name Enter the equipment's current location. Travel ID Tag Number Enter the date that this equipment was acquired from vendor. Feedback Number Planning Activity Planning Solution Area Solution Area Sub-Category AEL# Hold Trigger Approval Date Identified Host If you are not the host, please identify who is the host. For further guidance, please refer to your Program Representative. Training Activity Please identify your training activity from the drop-down list. Fund Source Name: Title: Payment Mailing Address: City: Signature: I hereby certify upon my personal knowledge that budgeted funds are available for the period and purposes of this expenditure stated above. Please review the Certification Paragraph. Phone Email City Zip EMPG MATCH Detail Select YES or NO from the drop-down list. Select a Detail option from the drop-down list. Total # Trainee(s) Type of Match Total Match Expended M&A EXERCISE Dates of Payroll Period PERSONNEL Total Project Hours Total Cost Charged to Grant Project & Description of Services Expenditure Category Period of Expenditure Activity Conferences Staff Expenses Supplies Staff Salaries Employee Name Provide detailed information on M&A activity. Provide detailed information on the project and description of services. Provide the name of the employee. Select a Solution Area from the drop-down list. Enter the total number of trainee(s). 2. Implementing Agency: Meals w/prior approval Community Outreach Materials Tuition Project/Deliverable Deliverable Fee for Deliverable Provide the Total Salary and Benefits Charged for the Reporting Period. Provide the Dates of the Payroll Period. Enter the Period of Expenditure in this column. Enter the Total Cost Charged to the Grant in this column. Enter the Total Project Hours in this column. 13. Certification Paragraph Provide the name of the Consulting Firm and Consultant Name. Public Information and Warning Operational Coordination Forensics and Attribution Community Resilience Critical Transportation Economic Recovery Intelligence and Information Sharing Cybersecurity Long-term Vulnerability Reduction Health and Social Services Interdiction and Disruption Risk and Disaster Resilience Assessment Fatality Management Services Housing Screening, Search, and Detection Infrastructure Systems Physical Protective Measures Mass Care Services Natural and Cultural Resources Risk Management for Protection Programs and Activities Supply Chain Integrity and Security Operational Communications Situational Assessment FIPS # 4. Location of Project: AUTHORIZED AGENT AND CONTACT INFORMATION Materials & Supplies Reimbursement Request Staffing EOC Construction & Renovation EOC Construction EOC Renovation Maintenance & Sustainment Maintenance Contracts & Warranties Repair & Replacement Costs Upgrades User fees Request # CALIFORNIA GOVERNOR'S OFFICE OF EMERGENCY SERVICES (Cal OES Use Only) Cal OES # (FOR Cal OES USE ONLY) Subaward # GRANT SUBAWARD FACE SHEET The California Governor's Office of Emergency Services (Cal OES) hereby makes a Grant Subaward of funds to the following: 1. Subrecipient: Direct/Subaward 1. Subrecipient ICR Base Rate 7. Indirect Cost Rate: Provide detailed information on Indirect Cost activity. Select an ICR Base from the drop-down list. Match Description Facilities & Administration Rental Cost Critical Emergency Supplies Budgeted Cost Total Costs Costs Applicable to ICR Enter the Invoice Number for the equipment. Percentage Expended INDIRECT COSTS Utilities Use the drop-down list to identify if the Project is Direct or Subaward Threats and Hazards Identification On-scene Security, Protection, and Law Enforcement Logistics and Supply Chain Management Fire Management and Suppression Develop and Enhance Plans, Protocols, Programs, and Systems Shelf Stable Food Products Basic Medical Supplies Consultant / Contractor Fee Supplies / Materials / Production Costs Communications Services Develop and Enhance Plans, Protocols, Programs, & Systems Certification / Recertification of Instructors Public Health, Healthcare, and Emergency Medical Services Enter the address of the Implementing Agency. Provide the complete nine digit zip code (Zip+4). Enter the City and County/Operational Area where the project is located. Provide the complete nine digit zip code (Zip+4). Select a Solution Area Sub-Category from the drop-down list. This list is dependent on a selection from the Solution Area Category drop-down list. The Solution Area Sub-Category will not display the drop-down list unless a Solution Area Category is selected. Select an Expenditure Category from the drop-down list. This list is dependent on a selection from the Solution Area Sub-Category drop-down list. The Expenditure Category will not display the drop-down list unless a Solution Area Sub-Category is selected. Select a Solution Area from the drop-down list that aligns to the activities/costs used to meet the EMPG Match Requirement. Select a Solution Area Sub-Category from the drop-down list that aligns to the activities/costs used to meet the EMPG Match Requirement. This list is dependent on a selection from the Solution Area Category drop-down list. The Solution Area Sub-Category will not display the drop-down list unless a Solution Area Category is selected. Course Development, Delivery, and Evaluation Design, Develop, Conduct and Evaluate 15. Official Authorized to Sign for Subrecipient: 16. Federal Employer ID Number % Please review, and if applicable, provide the necessary documentation. 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 Subrecipient, enter the same title again. 14. CA Public Records Act Provide the contact information of any additional Authorized Agents (AA) or staff related to grant activities. It is recommended that more than one person be designated as an AA, so that if one AA is not available, a second AA can sign the requests for reimbursements and modifications. Use the drop down list to identify if the project is Direct or Subaward. Select YES, NO, or N/A from the drop-down list. Percent Expended Select a Solution Area from the drop-down list. Provide a description of equipment and quantity. If Item is Mobile or Portable identify as such. Enter the Percentage Rate. Total Cost Charged to this Grant Current Match Authorized Agent Direct / Subaward Solution Area Sub-Category Project Title State Goals Core Capabilities Capability Building Access Control and Identity Verification Mass Search and Rescue Operations SAFECOM Compliance Less Distorting Costs POP Start Date POP End Date Remaining Balance Day-to-Day Activities / Emergency Mgmt Support Operations Performance Period State Goals Core Capabilities Select a Core Capabilities from the drop-down list. Capability Building Select Capability Building from the drop-down list. Enter the name of the Disaster or Program providing the funds for this Grant Subaward. A disaster may be referred by the federal declaration number. Program titles should be complete without the use of acronyms. Enter beginning and ending dates of the performance period for the Grant Subaward. (mm/dd/yyyy) Enter the name and title of the official authorized to enter into the Grant Subaward for the Subrecipient as stated in Block 1 of the Grant Subaward Face Sheet (Cal OES 2-101). Enter the Payment Mailing Address where grant funds should be sent. Provide the complete nine digit zip code (Zip+4). Period Indirect Cost Rate for Period Enter the indirect cost rate for period Select ICR Base from the drop-down Deployable / Shareable Amount This Request Total Approved Expenditure Category Budgeted Cost Project Description Solution Area Amount This Request Planning Activity Approval Date Hold Trigger Final Product AEL Title Invoice Number Condition & Disposition Deployed Location Course Name Training Activity Identified Host Exercise Title Date of Exercise Previously Approved Amount Project Title Total Budgeted Cost Total Match Expended Percentage Expended ID Tag Number Feedback Number Total # of Trainee(s) Identified Host Consulting Firm / Consultant Name Project / Description of Services Period of Expenditure Project / Deliverable Type of Match Current Match Excel 2003 Excel 2007 Version Instructions 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. Below is a table of the macro buttons available on many of the worksheets in this workbook. Button Function New Mod Item Selects the entire row(s) of the selected cell(s) and changes the font color to black. Any strikethroughs will be removed. Selects the entire row(s) of the selected cell(s) and changes the font color to red. A red strikethrough will be added. Selects the entire row(s) of the selected cell(s) and changes the font color to blue. Any strikethroughs will be removed. 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. Populates the Ledger Type field with "Initial Application" and the Date field with today's date. Form Field 15. Official Authorized to sign for the Subrecipient 3. Implementing Agency Address 2. Implementing Agency 4. Location of Project 5. Disaster/Program Title 6. Performance Period 7. Indirect Cost Rate Select the State Goals from the drop-down list. Deployable/Shareable Select from the drop down list. Total Budgeted Cost Enter a short, but descriptive name for the project. Enter the project description, citing specific and measurable objectives. Enter the total amount obligated for the project. Previously Approved Amount This field auto-populates with the total expenditures to-date for the line item. This value does not include any match amounts. This field auto-populates with the remaining balance allowed for the line item. This value does not include any match amounts. This field auto-populates with the amount expended, to-date, as a percentage of the budgeted amount. This value does not include any match amounts. This field auto-populates. Enter the total amount of grant funding budgeted for the line item. Enter the condition of equipment by selecting the appropriate drop-down item. If the equipment is not in use, please use the "Deployed Location" column to explain current status. 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. Previously Approrved Amount Consulting Firm / Consultant Name If your consultant/contractor invoiced you for their services using a fee for each deliverable, then describe the product in the Deliverable column. (e.g.: $10,000 for a reverse 911/telephone emergency notification system) Total Salary and Benefits Charged for this Reporting Period Previously Expended Match Total Budgeted Match Total Budgeted Match Enter the total budgeted match amount for this project in this column. This field auto-populates with the cumulative match expenditures as of the reimbursement request prior to the current request. This field auto-populates with the total match expenditures to-date for the line item. This field auto-populates with the remaining match balance for the line item. This field auto-populates with the match amount expended, to-date, as a percentage of the budgeted match amount. WORKBOOK INSTRUCTIONS This field is auto-populated with the grant Performance Period as described on the Face Sheet Tab Enter the type of request that is being made. Use one of the following types: INITIAL APPLICATION, REIMBURSEMENT REQUEST, FINAL REIMBURSEMENT REQUEST and MODIFICATION Request Type Ledger Column Name Direct / Subaward Noncompetitive Procurement over 250k Previously Approved Amount Noncompetitive Procurement over $250k OT / Backfill Environmental Response / Health and Safety For each fund source used in the program, select the correct grant year and acronym from the drop down lists, the amount of state or federal 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. The Total Project Cost row should correspond to the total project cost specified in the budget. Noncompetitive Procurement over 250k Equipment Description SAFECOM Compliance Acquisition Date Acquisition Date Noncompetitive Procurement over $250k If project is subject to a Hold, select the Hold type from drop-down list. If applicable, enter date when hold was released/approved. VS# 3. Implementing Agency Address: (Street) (City) (Zip+4) (City) (County) (Start Date) Item Number A. State B. Federal C. Total D. Cash Match E. In-Kind Match F. Total Match Total Cost Zip Code+4: (Cal OES Fiscal Officer) (Date) (Cal OES Director or Designee) Deletes entire row(s) of selected cell(s). Selection must be contiguous if multiple cells are selected. 8-12. Fund Allocations and Total Project Cost 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. Section 2: GRANT SUBAWARD FACE SHEET If claiming indirect costs under the award, provide detailed information on the total estimated indirect costs and the indirect cost rate at which you will be claiming. If you have a federally-approved rate, provide information on the direct cost base on which, the rate is calculated, e.g., Salary and Wages (S/W), Salary, Wages and Benefits (SW&B), Total Direct Costs (TDC), Modified Total Direct Costs (MTDC), the De Minimis Rate of 10% of MTDC (10% MTDC), or another base (Other). The Authorized Agent sheet must accompany ALL Reimbursement Requests, Modifications, and the Initial Application. If your consultant/contractor invoiced you for their services using a fee for each deliverable, then fill in the cost for the product in the Fee for Deliverable column. (e.g.: $10,000 for a reverse 911/telephone emergency notification system) Provide detailed information on the project and description of services. If your consultant/contractor invoiced you for their services using a fee for each deliverable, then describe the product in the Deliverable column. (e.g.: $10,000 for a reverse 911/telephone emergency notification system) to Federally Approved ICR (if applicable): Authorized Agent Name Exercise Type Adds row below the selected cell. Add Row Delete Row Indicate whether you are using the 10% de Minimis rate based on Modified Total Direct Costs (MTDC) or your current cognizant agency approved indirect cost rate agreement. A copy of the approved negotiated indirect cost rate agreement must be enclosed with your application. Indicate N/A if you will not be claiming indirect costs under the award. Indirect costs may or may not be allowable under all Federal fund sources. 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 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). 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 current will result in funds being withheld by Cal OES. This field auto-populates with the cumulative expenditures of all reimbursement requests prior to the current request. This value does not include any match amounts. Select the project letter from the drop-down list that corresponds with the Project Ledger. Select a Solution Area Sub-Category from the drop-down list that corresponds with the Project Ledger. Enter a description of the final product for this Planning activity. This must be a tangible item such as a manual, procedure, etc. Please contact your Program Representative for further examples of final products. Enter the name of the organization. This field auto-populates with the cumulative expenditures as of all reimbursement requests prior to the current request. This value does not include any match amounts. Enter the ID Tag Number used to identify this equipment with. Subrecipient may use a product's serial number, or their own internal numbering format to tag equipment. ID Tag Number must be available during monitoring visits. Select 50% or 100% from the drop-down list, or enter the appropriate percentage. Date AAR/IP E-mailed to HSEEP Select a Solution Area Sub-Category from the drop-down list that corresponds with the Project Ledger. This list is dependent on a selection from the Solution Area Category drop-down list. The Solution Area Sub-Category will not display the drop-down list unless a Solution Area Category is selected. Enter the description of the Match activity. Select the Type of Match: Cash or In-Kind Total Budgeted Indirect Costs Total Direct Costs Total Allowable Indirect Costs Enter Total Costs. Enter Less Distorting Costs. Enter the time period for which the indirect cost rate is valid. Use the format: Month/Year through Month/Year. This field auto-populates with the cumulative amount expended for the line item. This value does not include any match amounts. Expenditures To Date This field auto-populates with the total expenditures to date for the line item. This value includes match amounts. New Request Populates the Ledger Type field with "Reimbursement Request" and the Date field with today's date. A new "Request #" field will appear. Populates the Ledger Type field with "Modification" and the Date field with today's date. A new "Request #" field will appear. Enter the nine digit Federal Employer Identification Number for the Implementing Agency. Spacing Section 8: TRAINING Section 6: ORGANIZATION Section 5: PLANNING Enter the Feedback Number for the Training activity. To request a training Feedback Number, contact CSTI and submit the form from the following link: CSTI Tracking Number Request Form Section 7: EQUIPMENT CONSULTANT / CONTRACTOR 16. Federal Employer ID Number: Enter Total Indirect Costs Budgeted; this value should be not be greater than the Total Allowable Indirect Costs. % of Federal Funds Used in the Purchase 04 - Information Technology 06 - Interoperable Communications Equipment 01 - Personal Protective Equipment 14 - Physical Security Enhancement Equipment 19 - CBRNE Logistical Support Equipment 21 - Other Authorized Equipment (End Date) 5. Disaster/Program Title: Percent Expended EQUIPMENT TRAINING ORGANIZATION PLANNING Equipment Description (include Qty.) 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. Keyboard Shortcut 07 - Detection Equipment 10 - Power Equipment 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. Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8 Column9 Column10 05 - Cybersecurity Enhancement Equipment 11 - CBRNE Reference Materials 12 - CBRNE Incident Response Vehicles Exercise Title Enter the title of the exercise activity. Exercise Activity Please select your exercise activity from the drop-down list. Date of Exercise Enter the date of when this exercise was conducted. Date of AAR/IP E-mailed into HSEEP Enter the date that the After Action Report (AAR) / Improvement Plan (IP) was e-mailed to hseep@fema.dhs.gov. This field auto-populates with the cumulative expenditures as of all cash request requests prior to the current request. This value does not include any match amounts. Use this ledger to submit funding information for projects, as well as submitting Cash Requests and Modifications. Enter the "Cash Request" or "Modification" number associated with this request. This field is for Cash Requests only: Enter the requested dollar amount for this request. This field is for Cash Requests only: Enter the match amount for the line item. This field is for Cash Requests only: Enter the requested dollar amount for the line item. Expenditures To Date (w/Match) Place the AEL Number and Title in these columns. The AEL Number and Title can be obtained from the following link: Authorized Equipment List EMPG-A Cal OES Approval Using the Macro buttons, specify what type of ledger is being completed (Application, Advance, Reimbursement, or Modification). Enter the request number. Select the appropriate funding source used for this project. Funds from one funding source cannot be moved to another funding source. Select "Facilities & Administration " from the drop-down list. Select "Grant Administration" from the drop-down list. Rental / Lease Space Costs Day to Day Activities / Operations Supporting Emergency Management Develop / Enhance Plans, Protocols, Programs, and Systems Indirect Costs Communication Services Same as Project Ledger DD_Planning_SubCat DD_Organization_SubCat DD_Equipment_SubCat DD_Training_SubCat DD_Exercise_SubCat DD_MA_SubCat DD_EOC_SubCat DD_Maintenance_SubCat DD_Indirect_SubCat DD_PL_SolutionArea DD_PL_CoreCapabilities DD_Planning_Expenditure1 DD_Planning_Expenditure2 DD_Planning_Expenditure3 DD_Planning_Expenditure4 Conference Fees DD_Organization_Expenditure1 DD_Organization_Expenditure2 DD_Training_Expenditure1 DD_Training_Expenditure2 DD_Training_Expenditure3 DD_Exercise_Expenditure1 DD_Exercise_Expenditure2 DD_MA_Expenditure1 DD_CC_SolutionArea DD_CC_Planning_SubCat DD_CC_Organization_SubCat DD_CC_Equipment_SubCat DD_CC_Training_SubCat DD_CC_Exercise_SubCat DD_CC_MA_SubCat DD_CC_EOC_SubCat DD_CC_Maintenance_SubCat DD_CC_Planning_Expenditure1 DD_CC_Planning_Expenditure2 DD_CC_Planning_Expenditure3 DD_CC_Maintenance_Expenditure1 DD_CC_Organization_Expenditure1 DD_CC_Training_Expenditure1 DD_CC_Equipment_Expenditure1 DD_CC_Training_Expenditure2 DD_CC_Exercise_Expenditure1 DD_CC_Exercise_Expenditure2 DD_CC_MA_Expenditure1 DD_CC_EOC_Expenditure1 DD_CC_EOC_Expenditure2 DD_CC_Maintenance_Expenditure2 DD_CC_Maintenance_Expenditure3 DD_CC_Maintenance_Expenditure4 DD_Personnel_SolutionArea DD_Personnel_Planning_SubCat DD_Personnel_Organization_SubCat DD_Personnel_Training_SubCat DD_Personnel_Exercise_SubCat DD_Personnel_MA_SubCat DD_Personnel_Planning SubCat EOC CONSTRUCTION & RENOVATION MAINTENANCE & SUSTAINMENT Total Salary & Benefits Charged for this Reporting Period AUTHORIZED AGENT NOTE: Unauthorized alterations will delay the approval of this request. Supporting Information for Application, Modification, or Request for Federal Funds This claim is for costs incurred within the grant performance period. This request is for a/an: through Under Penalty of Perjury, I certify that: I am the duly authorized officer of the claimant herein. This claim is true, correct, and all expenditures were made in accordance with applicable laws, rules, regulations, and grant conditions and assurances. Statement of Certification - Authorized Agent By signing this report, I certify, to the best of my knowledge and belief, that the report is true, complete, and accurate, and that the expenditures, disbursements, and cash receipts are for the purposes and objectives set forth in the terms and conditions of the Federal award. I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise. (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729–3730 and 3801–3812). Printed Name of Authorized Agent Title of Authorized Agent Signature of Authorized Agent Date Enter the project letter from the drop-down list. Ctrl + Shift + G Ctrl + Shift + Y Creates a new worksheet with a pivot table that aggregates Budgeted Costs by Solution Area. Only works on the Project Ledger tab. Duplicates the active sheet, then deletes the red lines and changes blue font to black font. Section 10: M&A Section 11: INDIRECT COST Section 12: CONSULTANT / CONTRACTOR Section 13: PERSONNEL Section 14: MATCH Section 3: AUTHORIZED AGENT CONTACT INFORMATION Section 4: PROJECT LEDGER Section 9: EXERCISE 6. Performance / Budget Period: 1a. UEI: 2a. UEI: Emergency Management Performance Grant G. Total Cost Point of Contact (POC) Name MISCELLANEOUS CDFA 97.042 (EMPG) 97.067 (HSGP) 97.008 (NSGP) Ctrl + Shift + I Resets information on top of each tab to reflect name, FIPS, subaward number, POP dates from Face Sheet WORKBOOK Named Ranges Award 1a. Unique Entity Identifier (UEI) Effective April 4, 2022, the Federal Government transitioned from using the Data Universal Numbering System or DUNS number, to a new, non-proprietary 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 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 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 | GSA. Ctrl + Shift + L Breaks all links to external sources. Excel 2010/2013/2016/2019/365 Validate Worksheet Black Font Red Strikethrough Blue Font 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 Restores formulas and formatting to default values in the appropriate cells. This macro does not erase data. 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 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. 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. Enter the Name and Title of Authorized Agent. Sign and date. Total M&A Expended % Total M&A Exp of Total Exp 2a. Unique Entity Identifier (UEI) Salutation Address NOTE: Authorized Agents must be designated, by name or title, in the Governing Body Resolution. Modifications will require additional documentation. Calculates maximum allowable M&A based on total cost of all non-M&A projects. 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. Ctrl + Shift + S Spellchecks worksheet. Section 15: ICR SUMMARY Section 16: AA APPROVAL 13. Certification - This Grant Subaward consists of this title page, the application for the grant, which is attached and made a part hereof, the Assurances/Certifications, and any attached Special Conditions. I hereby certify I am vested with the authority to enter into this Grant Subaward, and have the approval of the City/County Financial Officer, City Manager, County Administrator, Governing Board Chair, or other Approving Body. The Subrecipient certifies that all funds received pursuant to this agreement will be spent exclusively on the purposes specified in the Grant Subaward. The Subrecipient accepts this Grant Subaward and agrees to administer the grant project in accordance with the Grant Subaward as well as all applicable state and federal laws, audit requirements, federal program guidelines, and Cal OES policy and program guidance. The Subrecipient further agrees that the allocation of funds may be contingent on the enactment of the State Budget. 14. CA Public Records Act - Grant applications are subject to the California Public Records Act, Government Code section 7920 et seq. Do not put any personally identifiable information or private information on this application. If you believe that any of the information you are putting on this application is exempt from the Public Records Act, please attach a statement that indicates what portions of the application and the basis for the exemption. Your statement that the information is not subject to the Public Records Act will not guarantee that the information will not be disclosed. ALN: Beginning Performance Period Date Ending Performance Period Date Payment Address City, ZIP 2023-0006 This worksheet provides instructions on how to complete the FY 2023 Financial Management Forms Workbook (FMFW), EMPG v.23. 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. EMPG 97.042 Goal #6 City of Palm Desert XLREHY4MDGW4 City of Palm Desert 73-510 Fred Waring Dr Palm Desert 92260-2524 73-510 Fred Waring Dr. Riverside City Manager Mr. 760-346-0611 Todd Hileman Daniel Hurtado Emergency Services Coordinator thileman@palmdesert.gov dhurtado@palmdesert.gov Mr. Joe Barron Senior Contracts and Grants Analyst 760-776-6414 760-776-6491 jbarron@palmdesert.gov Sustain Both N/A No Cash Match Palm Desert - Mass Care and Shelter Palm Desert - Cots (100) City of Palm Desert is 50% cost share from local funds. C Palm Desert will purchase cots for mass care and shelter response operations under direct EOC oversight 21GN-00-OCEQ Equipment and Supplies, Information/Emergency Operations/Fusion Centers VR 4/3/24 Subaward 95-2859459 MODIFICATION CLEAR APPLICATION BLUE FONT RED STRIKETHROUGH BLACK FONT delete ROW add row NEW mod ITEM new REQUEST RED STRIKETHROUGH BLACK FONT BLUE FONT APPLICATION REIMBURSEMENT MODIFICATION ADVANCE CLEAR VALIDATE WORKSHEET delete ROW add row new REQUEST NEW mod ITEM SORT (A-Z) SPELLCHECK CLEAR FILTERS APPLICATION REIMBURSEMENT MODIFICATION ADVANCE CLEAR RED STRIKETHROUGH BLACK FONT BLUE FONT SORT (A-Z) SPELLCHECK CLEAR FILTERS VALIDATE WORKSHEET delete ROW add row new REQUEST NEW mod ITEM APPLICATION REIMBURSEMENT MODIFICATION ADVANCE CLEAR RED STRIKETHROUGH BLACK FONT BLUE FONT SORT (A-Z) SPELLCHECK CLEAR FILTERS VALIDATE WORKSHEET delete ROW add row new REQUEST NEW mod ITEM RED STRIKETHROUGH BLACK FONT BLUE FONT APPLICATION REIMBURSEMENT MODIFICATION ADVANCE CLEAR SORT (A-Z) SPELLCHECK CLEAR FILTERS VALIDATE WORKSHEET delete ROW add row new REQUEST NEW mod ITEM RED STRIKETHROUGH BLACK FONT BLUE FONT APPLICATION REIMBURSEMENT MODIFICATION ADVANCE CLEAR SORT (A-Z) SPELLCHECK CLEAR FILTERS VALIDATE WORKSHEET delete ROW add row new REQUEST NEW mod ITEM APPLICATION REIMBURSEMENT MODIFICATION ADVANCE CLEAR RED STRIKETHROUGH BLACK FONT BLUE FONT SORT (A-Z) SPELLCHECK CLEAR FILTERS VALIDATE WORKSHEET delete ROW add row new REQUEST NEW mod ITEM RED STRIKETHROUGH BLACK FONT BLUE FONT APPLICATION REIMBURSEMENT MODIFICATION ADVANCE CLEAR VALIDATE WORKSHEET delete ROW add row new REQUEST NEW mod ITEM SORT (A-Z) SPELLCHECK CLEAR FILTERS APPLICATION REIMBURSEMENT MODIFICATION ADVANCE CLEAR RED STRIKETHROUGH BLACK FONT BLUE FONT SORT (A-Z) SPELLCHECK CLEAR FILTERS VALIDATE WORKSHEET delete ROW add row new REQUEST NEW mod ITEM APPLICATION REIMBURSEMENT MODIFICATION ADVANCE CLEAR RED STRIKETHROUGH BLACK FONT BLUE FONT SORT (A-Z) SPELLCHECK CLEAR FILTERS VALIDATE WORKSHEET delete ROW add row new REQUEST NEW mod ITEM CLEAR ADVANCE FINAL REIMBURSEMENT REIMBURSEMENT Modification Initial Application Select one of the options below NEW AA SHEET STATE GOALS 1. Enhance Information Collection, Analysis, and Sharing, in Support of Public Safety Operations across California 2. Protect Critical Infrastructure and Key Resources from All Threats and Hazards 3. Strengthen Security and Preparedness across Cyberspace 4. Strengthen Communications Capabilities through Planning, Governance, Technology, and Equipment 5. Enhance Community Preparedness 6. Enhance Multi-Jurisdictional/Inter-Jurisdictional All-Hazards Incident Catastrophic Planning, Response, and Recovery Capabilities 7. Improve Medical and Health Capabilities 8. Enhance Incident Recovery Capabilities 9. Strengthen Food & Agriculture Preparedness 10. Enhance Homeland Security Exercise, Evaluation, and Training Programs 11. Protect Against Effects of Climate Change CORE CAPABILITIES Access Control and Identity Verification Community Resilience Critical Transportation Cybersecurity Economic Recovery Environmental Response / Health and Safety Fatality Management Services Fire Management and Suppression Forensics and Attribution Health and Social Services Housing Infrastructure Systems Intelligence and Information Sharing Interdiction and Disruption Logistics and Supply Chain Management Long-term Vulnerability Reduction Mass Care Services Mass Search and Rescue Operations Natural and Cultural Resources On-scene Security, Protection, and Law Enforcement Operational Communications Operational Coordination Physical Protective Measures Planning Public Health, Healthcare, and Emergency Medical Services Public Information and Warning Risk and Disaster Resilience Assessment Risk Management for Protection Programs and Activities Screening, Search, and Detection Situational Assessment Supply Chain Integrity and Security Threats and Hazards Identification Solution Area Sub-Category (AEL) 01 - Personal Protective Equipment 04 - Information Technology 05 - Cybersecurity Enhancement Equipment 06 - Interoperable Communications Equipment 07 - Detection Equipment 10 - Power Equipment 11 - CBRNE Reference Materials 12 - CBRNE Incident Response Vehicles 14 - Physical Security Enhancement Equipment 19 - CBRNE Logistical Support Equipment 21 - Other Authorized Equipment Exercise Type Seminar Workshop Tabletop Game Drill Attendee Drill Host Functional Attendee Functional Host Full Scale Attendee Full Scale Host