Export

Export quarterly effort data from PEARS as an Excel workbook.

The Quarterly Efforts export generates an Excel (.xlsx) workbook containing data from your quarterly effort reports. The export includes effort details and multi-state and integrated project information across multiple worksheets.

Getting Started

To export quarterly efforts, navigate to the Quarterly Efforts list under the Reflect menu and click the Export button. The export includes all quarterly efforts matching your current filters.

TIP: Apply filters before exporting to limit the results to a specific reporting period, quarter, or program area. Large exports are processed in the background and you will receive an email when the file is ready to download.

Workbook Structure

The export workbook contains the following worksheets. Data can be linked across worksheets using the quarterly_effort_id column.

• Codebook — Describes each column in the workbook and provides notes about the exported data.

• Quarterly Effort Data — One row per quarterly effort with fields including reporting periods, organization, quarter, program areas, cooperative extension appointment, percent of effort by critical issue, contact demographics (gender, race, ethnicity), volunteer contacts and hours, and timestamps.

• Multi-State & Integrated — One row per project, including the project name, description, whether it is integrated or multi-state programming, and the percentage or hours of effort spent.