custom reports: timesheet reports (Excel) (condensed)

Custom Reports: Timesheet Reports (Excel) (Condensed)

1. On the left, in your Mission Control, click Timesheets.
   
   

2. On the right, select either View program-wide data or View site data.
   
   

3. On the next page, select the Timesheet Template at issue.
   
   
4. At the bottom of the page, select Build Custom Reports.
   
   
5. On the next page, choose which type of report you would like to build.
   
   

6. If you have chosen View site data, you will have the option to select the site or sites you are assigned to.
   For Program-wide date, please go to the next step.
   
   

7. On the next page, Select Data to Export. You can choose as many data points as you’d like.
   
   
8. Then, use the Select Site Breakout Options, to tell the system what site data (if any) you would like on your report.
   
   
9. Next, Select One or More Reporters by choosing either:
   1. Include all relevant reporters.
      
      
   2. Select specific reporters.
      
      
10. Next, decide if you will Add Reporter Profile Data to the Report, by choosing either:
    1. Do not add profile data.
       .
       
    2. Add profile data.
       
       
11. Use the Select a Time Period section to select the time period that the report should include.
    
    For the Totals, Timesheet Period and Daily reports, each date range in the drop-down menu (e.g., May 9, 2019 – May 15, 2019) represents a single timesheet period.
    
    For the Monthly Report you will only see each month listed.
    
    
12. Choose your report format by clicking View Data or Export Excel.
    Note: View Data will only be available for the Totals Report.