Progress Report Template Scientific - Excel

Document Sample
Progress Report Template Scientific - Excel Powered By Docstoc
					Instructions                                             Required Worksheets                 Note
If you are a PRIME recipient of ARRA Federal             Prime Data
Funds and your project does not involve                  Vendor Data
subrecipient(s)

If you are a PRIME recipient of ARRA Federal             Prime Data
Funds and have delegated reporting to your               SubrecipientData_Issued_Del Harvard issues a subaward
subrecipient(s).                                         Vendor Data


If you are a PRIME recipient of ARRA Federal             Prime Data
Funds and are reporting on behalf of your                                            Harvard issues a subaward
                                                         Subrecipient Data_Issued_NonDel
subrecipient(s)                                          Vendor Data

If you are a subrecipient of ARRA funds                  Subrecipient Data_Received          Subaward issued to Harvard

                                                         Vendor Data


      Electronic submission via e-mail certifies the accuracy and completeness of the data contained in this template.
                                                                                                                                                                                  c2fce1d6-dcc5-4211-8f4a-2e10b93b27c4.xls


                                                                                                                                                      Jobs Reporting Period:                                03/01/2010 - 05/31/2010
                                                               ARRA DATA REQUEST TEMPLATE                                                             Internal Due Date:                                    6/16/2010
                                                                                                                                                      Department Contact:

                                 Harvard Fund #                                                                                         Instructions. Complete the "Department Response" cell for each data element.

                                 Org #                                                                                                                Refer to the "OMB Detailed Description" if further clarification is needed.

                                 Principal Investigator                                                                                               Consider the Maximum # of Characters permitted.

                                 Sponsor Award #                                                                                                      Complete the Vendor Data tab for transactions > $25,000.

                                                                                                                                                                                                                                         Max #
Header                                   Data Element                                  Instructions                                                               Department's Response                                                                  OMB Detailed Description
                                                                                                                                                                                                                                       Characters
                                                                                                                                                                                                                                                         Award title and description with purpose of each funding action if any. The description should capture the overall purpose
                                                                                                                                                                                                                                                         of the award. For example, „„community development,‟‟ „„comprehensive community mental health services to adults with
                                                                                                                                                                                                                                                         a serious mental illness,‟‟ etc.
          Award Description




                                 Description of Award (brief
                                                                   Briefly summarize the scope of the award.                                                                                                                          4000 characters
                                 narrative).




                                                                                                                                                                                                                                                         A description of the overall purpose and expected outputs and outcomes or results of the award and first-tier Subaward(s),
  Quarterly Activities/Project




                                                                                                                                                                                                                                                         including significant deliverables and, if appropriate, units of measure.
         Description




                                 Description of Quarterly          Briefly summarize the overall purpose of the project,
                                 Activities/Project (brief         including subawards. Note any major deliverables,                                                                                                                  2000 characters
                                 narrative).                       outcomes or results.




                                                                                                                                                                                                                                                         Evaluation of completion status of the project, activity, or federally awarded contract action funded by the Recovery Act.
                                                                   Estimate the completion of the entire (multiyear)
                                                                                                                                                                                                                                                         The status of the work that has been completed. This evaluation should be based on performance progress reports and
                                                                   project, including subawards:
  Progress
   Project




                                                                                                                                                                                                                                                         other relevant non-financial performance information.
                                 Evaluation of completion status   Not Started
                                                                                                                                                                                                                                       20 characters     Options for selection: Not started; Less than 50% completed; Completed 50% or more; Fully Completed.
                                 of the project or activity.       < 50% Completed
                                                                                                                                                                                                                                                         For awards funding multiple projects such as formula block grants, provide your best estimate of completion of all
                                                                   > 50% Completed
                                                                                                                                                                                                                                                         projects based on any aggregate data and information.
                                                                   Fully Completed                                            <50% completed
                                                                                                                                                                                                                                                         Provide a narrative description of the employment impact of the Recovery Act funded work. This narrative should be
                                                                                                                                                                                                                                                         cumulative for each calendar quarter and at a minimum, address the impact on the recipient‟s workforce, and if known,
                                                                                                                                                                                                                                                         the impact on the workforces of subrecipients. At a minimum, the recipient shall provide—
                                                                                                                                                                                                                                                         i. A brief description of the types of jobs retained in the United States and outlying areas. “Jobs or positions funded”
                                                                   Enter descriptive titles of jobs created or retained (in                                                                                                                              means those new positions that are filled or previously existing filled positions as a result of Recovery Act funding. This
                                 A narrative description of the
                                 employment impact of the
                                                                   the US and territories) by the Prime and Subs under
                                                                                                                                                                                                                                      4000 characters.   description may rely on job titles, broader labor categories, or the contractor‟s existing practice for describing jobs as long
                                                                   this award.                                                                                                                                                                           as the terms used are widely understood and describe the general nature of the work; and
                                 Recovery Act funded work.
                                                                   Enter Cumulative numbers for each calendar quarter.                                                                                                                                   ii. An estimate of the number of jobs created and jobs retained in the United States and outlying areas. At a minimum, this
                                                                                                                                                                                                                                                         estimate shall include any new positions created and any existing filled positions that were retained to support or carry out
          Job Creation




                                                                                                                                                                                                                                                         Recovery Act projects or activities managed directly by the recipient, and if known, by subrecipients. The number shall be
                                                                                                                                                                                                                                                         expressed as “full-time equivalent” (FTE), calculated cumulatively as all hours worked divided by the total number of
                                                                                                                                                                                                                                                         hours in a full-time schedule, as defined by the recipient. For instance, two full-time employees and one part-time
                                                                                                                                                                                                                                                         Total number of jobs funded under this award.
                                                                   Enter # of Jobs Funded.
                                 Number of Jobs                                                                                                                                                                                                          Express in FTE. E.g., 1 full-time employee and two 25% effort employees will be expressed as 1.50.
                                                                   Jobs or positions created” means those new positions
                                                                                                                                                                                                                                       10 characters
                                                                   that are filled, as a result of Recovery Act funding.
                                 Prime Total                                                                                  JOBS FUNDED:                                                          0.00 FTE

                                                                                                                                                                                                                                                         Total number of jobs funded under this award.
                                                                   Enter # of Jobs Funded.
                                 Number of Jobs                                                                                                                                                                                                          Express in FTE. E.g., 1 full-time employee and two 25% effort employees will be expressed as 1.50.
                                                                   Jobs or positions created” means those new positions
                                                                                                                                                                                                                                       10 characters
                                                                   that are filled, as a result of Recovery Act funding.
                                 Subcontract Total                                                                            JOBS FUNDED:                                                          0.00 FTE
  Payments
   Vendor




                                                                   Provide detail on vendor payments greater than
                                 Vendor Payments > $25K
                                                                   $25,000 on the Vendor Data tab.

                                                                                                                              Use Attached Page to detail individual vendor payments greater than $25,000
                                                                   Enter the total number of vendor payment
Payment Payment
Vendor Vendor




                                                                   transactions less than $25,000.
           s




                                                                   This excludes payroll, internal billing and subaward
                                                                   transactions.
                                 Vendor Payments < $25K
                                                                   Enter the total amount of vendor payment
                                                                   transactions less than $25,000.
   s




                                                                   This excludes payroll, internal billing and subaward
                                                                   transactions.
                                                                                                                                                                                                      Page 2
                                                                                                                    State                                                                                                               2 characters     Recipient Primary Place of Performance (city, state, congressional district, and country) physical location of primary
          rmance Site




                                                                                                                       ZIP                                                                                                              9 characters     place of performance.



                                 Recipient Primary Place of
                                                                                                                c2fce1d6-dcc5-4211-8f4a-2e10b93b27c4.xls


                                                                                                                                                             Max #         Recipient Primary Place of Performance (city, state, congressional district, and country) physical location of primary
Header                      Data Element                           Instructions                        Department's Response                                               OMB performance.
                                                                                                                                                                           place ofDetailed Description
  Performance Site
                                                                                                                                                           Characters
                                                                                             County
                                                                               (Can be looked up at:
                                                  http://www.census.gov/geo/www/fips/fips65/index.ht
                     Recipient Primary Place of
                                                                                                ml )                                                        3 characters
                     Performance
                                                                              Congressional District                                                        2 characters
                                                                                         City/Town                                                         35 characters




                                                                                                                                Page 3
                                                                      Reporting Quarter:
           ARRA DATA REQUEST TEMPLATE
                                                                      Data Request Due:
                     continued
                                                                      Contact:
      VENDOR PAYMENT WORKSHEET
Instructions. For each invoice greater than or equal to $25,000, report the following Vendor & Payment information.
Provide the Vendor DUNS Number, or, if unavailable, provide the Vendor Name and Vendor Headquarters' ZIP code.
Vendor DUNS may be found in Central Contractor Registration at www.ccr.gov.
Subrecipient vendor purchases that meet the threshold should also be reported on this worksheet.
                                                                      Complete if Vendor Duns is unavailable:
                                                          Vendor
                                Subaward      Award       DUNS                                      Vendor      Product Service   Payment
No.        Award Number          Number        Type       Number            Vendor Name             HQ Zip        Description     Amount    Payment Date
      1                                      Grant
      2                                      Grant
      3                                      Grant
      4                                      Grant
      5                                      Grant
      6                                      Grant
      7                                      Grant
                                                                                                                Reporting Quarter:
                                                                                   ARRA DATA REQUEST TEMPLATE
                                                                                                                Data Request Due:
                                                                                             continued
                                                                                                                Contact:
                                        Delegated SUBRECIPIENT DATA WORKSHEET


Instructions. For each subaward, report the following Subrecipient information.


                                                             Subrecipient Data
                                                                      Vendor
                                                                     Payments
                         Subrecipient                              Greater than
          Subrecipient   DUNS           Subaward      Jobs Funded   or Equal to
No.       Name           Number         Number          (in FTE)       $25K
                                                                  Use Attached
                                                                  Page to detail
                                                                  individual
                                                                  vendor
                                                                  payments
                                                                  greater than
      1                                                           $25,000
                                                                                                                                                                                                Reporting Quarter:
                                                                                                                               ARRA DATA REQUEST TEMPLATE
                                                                                                                                                                                                Data Request Due:
                                                                                                                                         continued
                                                                                                                                                                                                Contact:
                                                    Non-delegated SUBRECIPIENT DATA WORKSHEET


Instructions. For each subaward, report the following Subrecipient information.


                                                            Subrecipient Data                                                                                                    Subrecipient Place of Performance
                                                                                                                                          Vendor
                                                                  Total                                    Number of                     Payments
                         Subrecipient                             Subaward                                  Vendor        Amount of    Greater than  Street
          Subrecipient   DUNS           Subaward     Total Amount Funds           Subaward   Jobs Funded   Payments        Vendor       or Equal to Address
No.       Name           Number         Number       of Subaward Disbursed        Date       (in FTE)       <$25K      Payments <$25K      $25K        1      Street Address 2        City                State
                                                                                                                                      Use Attached
                                                                                                                                      Page to detail
                                                                                                                                      individual
                                                                                                                                      vendor
                                                                                                                                      payments
                                                                                                                                      greater than
      1                                                                                                                               $25,000
                                                                                                                                      Use Attached
                                                                                                                                      Page to detail
                                                                                                                                      individual
                                                                                                                                      vendor
                                                                                                                                      payments
                                                                                                                                      greater than
      2                                                                                                                               $25,000
                                                                                                                                      Use Attached
                                                                                                                                      Page to detail
                                                                                                                                      individual
                                                                                                                                      vendor
                                                                                                                                      payments
                                                                                                                                      greater than
      3                                                                                                                               $25,000
                                                                                                                                      Use Attached
                                                                                                                                      Page to detail
                                                                                                                                      individual
                                                                                                                                      vendor
                                                                                                                                      payments
                                                                                                                                      greater than
      4                                                                                                                               $25,000
    Use Attached
    Page to detail
    individual
    vendor
    payments
    greater than
5   $25,000
    Use Attached
    Page to detail
    individual
    vendor
    payments
    greater than
6   $25,000
    Use Attached
    Page to detail
    individual
    vendor
    payments
    greater than
7   $25,000
    Use Attached
    Page to detail
    individual
    vendor
    payments
    greater than
8   $25,000
    Use Attached
    Page to detail
    individual
    vendor
    payments
    greater than
9   $25,000
 :
e:




     Zip Code
        +4
                                                   Subrecipient Reporting Applicability

                                                                    Officer         Officer         Officer         Officer Officer
                         Subrecipient           Officer #1            #2              #3              #4              #5      #5
Congressional             Reporting     Officer Compensati Officer Compens Officer Compens Officer Compens Officer Compens Compens
  District      County   Applicability #1 Name      on     #1 Name ation #2 Name ation #3 Name ation #4 Name ation           ation
                                                                                                                                                                  c2fce1d6-dcc5-4211-8f4a-2e10b93b27c4.xls


                                                                                                                                                          Reporting Period:                   1/1/2009-9/30/09
                                                           ARRA DATA REQUEST TEMPLATE
                                                                                                                                                          Internal Due Date:
                                                                  Subaward Received
                                                                                                                                                          Department Contact:

                        Harvard Fund #                                                                                                      Instructions. Complete the "Department Response" cell for each data element.

                        Org #                                                                                                                             Refer to the "OMB Detailed Description" if further clarification is needed.

                        Principal Investigator                                                                                                            Consider the Maximum # of Characters permitted.

                        Sponsor Award #                                                                                                                   Complete the Vendor Data tab for transactions > $25,000.


                        Prime Award #


                                                                                                                                                                                                                                Max #
Header                          Data Element                                  Instructions                                                           Department's Response                                                                      OMB Detailed Description
                                                                                                                                                                                                                              Characters
     Project Progress




                                                                                                                                                                                                                                                Evaluation of completion status of the project, activity, or federally awarded contract action funded by the Recovery Act.
                                                          Estimate the completion of the entire (multiyear)
                                                                                                                                                                                                                                                The status of the work that has been completed. This evaluation should be based on performance progress reports and
                                                          project, including subawards:
                                                                                                                                                                                                                                                other relevant
                        Evaluation of completion status   Not Started
                                                                                                                                                                                                                               20 characters
                        of the project or activity.       < 50% Completed
                                                          > 50% Completed
                                                          Fully Completed
                                                                                                                                                                                                                                                Provide a narrative description of the employment impact of the Recovery Act funded work. This narrative should be
                                                                                                                                                                                                                                                cumulative for each calendar quarter and at a minimum, address the impact on the recipient‟s workforce, and if known,
                                                          Enter descriptive titles of jobs created or retained (in                                                                                                                              the impact on the work
                        A narrative description of the
                                                          the US and territories) by the Prime and Subs under
                        employment impact of the                                                                                                                                                                             4000 characters.
                                                          this award.
                        Recovery Act funded work.
                                                          Enter Cumulative numbers for each calendar quarter.
     Job Creation




                                                          Enter Cumulative # of Jobs Funded.                                                                                                                                                    Total number of jobs created or retained under this award.
                        Number of Jobs                    Jobs or positions funded”means those new positions                                                                                                                                    Express in FTE. E.g., 1 full-time employee and two 25% effort employees will be expressed as 1.50.
                                                          or previously existing posistions that are filled, as a                                                                                                              10 characters
                        Prime Cumulative Total            result of Recovery Act funding.                         JOBS FUNDED:                                                        0.00 FTE

                                                          Enter Cumulative # of Jobs Created.                                                                                                                                                   Total number of jobs created or retained under this award.
                        Number of Jobs                    Jobs or positions created” means those new                                                                                                                                            Express in FTE. E.g., 1 full-time employee and two 25% effort employees will be expressed as 1.50.
                                                          positions that are filled, as a result of Recovery Act                                                                                                               10 characters
                        Subcontract Cumulative Total      funding.                                                   JOBS FUNDED:                                                     0.00 FTE
  Payments
   Vendor




                                                          Provide detail on vendor payments greater than
                        Vendor Payments > $25K
                                                          $25,000 on the Vendor Data tab.

                                                                                                                     Use Attached Page to detail individual vendor payments greater than $25,000
                                                          Enter the total number of vendor payment
Payment Payment
Vendor Vendor




                                                          transactions less than $25,000.
           s




                                                          This excludes payroll, internal billing and subaward
                                                          transactions.
                        Vendor Payments < $25K
                                                          Enter the total amount of vendor payment
                                                          transactions less than $25,000.
   s




                                                          This excludes payroll, internal billing and subaward
                                                          transactions.
                                                                                                           State                                                                                                               2 characters     Recipient Primary Place of Performance (city, state, congressional district, and country) physical location of primary
     Performance Site




                                                                                                        ZIP                                                                                                                    9 characters     place of performance.
                                                                                                    County
                                                                                      (Can be looked up at:
                                                          http://www.census.gov/geo/www/fips/fips65/index.h
                        Recipient Primary Place of
                                                                                                       tml )                                                                                                                   3 characters
                        Performance
                                                                                          Congressional District                                                                                                               2 characters
                                                                                                      City/Town                                                                                                                35 characters




                                                                                                                                                                                      Page 12

				
DOCUMENT INFO
Description: Progress Report Template Scientific document sample