Time clock systems by TimeIPS
Call Now! 316-264-1600
Knowledge Base Search:  
Main Menu
· Home

· Table of Contents
· Article Index

· Downloads
· New Features
· News
· Web Links

TimeIPS Knowledge Base

Table of Contents: Article IndexPrintable Version

Applies to versions: 2.3, 2.4, 2.5, 3.0, 3.1, 3.2

Site Summary Report

The Site Summary report summarizes hours worked by employees during a calendar week, grouped by site.

Modules Required: IPSRPT Custom Reporting and IPSSITE Site Management



Using the left pane Main Menu » Administration, click on: Reports » Special Reports

Special Reports provide information and data from the system beyond the standard Time Edit/Report. Select a report by clicking on the report name.




Under Clocking, click on: Site Summary

  • Select a report range from the drop down menu. You can choose from the Current calendar week, the Last calendar week, or a Selected date. Choosing "Selected date" will populate a field to select a specific date on which the report will start. The report always covers a span of exactly seven days.
    NOTE: The Site Summary report uses calendar days starting at midnight in the company time zone.
  • Select employee group to filter which Employees you would like to see in the report. It works in conjunction with Employee Selection Groups, and your custom presets will appear in the list. The Manage link opens up the Selection Groups page where you can customize which employees to include in a preset group.
  • If you have never uploaded a Template, or if you wish to use a modified template, select an OpenDocument spreadsheet file (.ods) to upload.
    TIP 1: Sample templates can be downloaded from support.timeips.com in the download section.

    TIP 2: The last-used template will stay in the system. Only upload a template if you need to change it.
  • Specify the number of rows reserved for employee data in the template in Minimum Employee Rows. The report will insert additional rows into the template beyond this number if necessary.
  • Click on the Run Report button




Sample Report


The report produces an OpenDocument spreadsheet with one sheet for each site. Each page summarizes the hours worked at the site based on the client station, remote clocking IP address, or telephone clocking caller ID at which the employees clocked in.

NOTE: If you have no sites configured in TimeIPS, or if there is no clock data in the selected report associated with sites, the spreadsheet will be empty.

See "Making a Template" below for programs that can read OpenDocument spreadsheets. You can find sample templates in the downloads section. Simple template. or Complex template.





Making a Template

The Site Summary report uses the OpenDocument spreadsheet file format. OpenOffice.org is the supported software for editing OpenDocument files.

TIP: TimeIPS recommends OpenOffice.org for editing OpenDocument files, but there are other alternatives available. These options are not supported by TimeIPS technical support but may be useful for your organization.
  • Google Docs is capable of importing and exporting small OpenDocument spreadsheets using a web interface.
  • There are plugins available for Microsoft Office (2003 and higher) which add support for OpenDocument files. (Sun Plugin | Community Plugin)
  • KOffice is available for users of Linux or other UNIX-like operating systems.

A template is an OpenDocument spreadsheet that contains specially formatted tags. When the report is run, these tags are replaced with the desired values. There should only be one row in the template that contains tags for employee records. This row will be repeated for each employee with worked hours in the report. The "Minimum Employee Rows" setting determines how many rows may be overwritten in the template (including the row containing the tags) before additional rows are inserted. If the spreadsheet uploaded into TimeIPS has more than one sheet, only the first sheet is used.

Per-Site Tags
{SITENAME} Site Name
{SITECODE} Site Code
{DAY[#]} Date for specified day, in 01/01/2007 format
{DAY(format)[#]} Date for specified day, with a user-provided format (format codes)
{ST_ALL} Total standard time hours worked at site
{ST_ALL[#]} Total standard time hours worked at site on specified day
{OT_ALL} Total overtime hours worked at site
{OT_ALL[#]} Total overtime hours worked at site on specified day
{DT_ALL} Total doubletime hours worked at site
{DT_ALL[#]} Total doubletime hours worked at site on specified day
{HOURS_ALL} Total hours worked at site
{HOURS_ALL[#]} Total hours worked at site on specified day
Per-Employee Tags
{FIRSTNAME} First Name
{MIDNAME} Middle Name
{LASTNAME} Last Name
{PREFNAME} Preferred Name
{FULLNAME} Full Name (see Master Configuration)
{ST} Total standard time hours worked by employee
{ST[#]} Total standard time hours worked by employee on specified day
{OT} Total overtime hours worked by employee
{OT[#]} Total overtime hours worked by employee on specified day
{DT} Total doubletime hours worked by employee
{DT[#]} Total doubletime hours worked by employee on specified day
{HOURS} Total hours worked by employee
{HOURS[#]} Total hours worked by employee on specified day
NOTE for tags with [#]: These tags refer to data for a specific day. Replace the # with the number of days after the start of the report; 0 means the first day of the report, and 6 means the last day.

When using tags in a spreadsheet formula, it may be necessary to enclose the tags in quotation marks (i.e. "{ST}" instead of just {ST}) to prevent the spreadsheet application from changing the content of the tag while editing the template. These quotes will be removed by the Site Summary report.

NOTE: Your spreadsheet program may show error messages, like "#NAME?" or "Err:502". These errors are caused by the fact that template tags are not valid in formulas. If the formulas are otherwise correct, these errors will be resolved when the report is run.

TIP: To preserve number formatting, use a simple spreadsheet formula like ="{ST}" instead of using {ST} alone.

©2004-2023 TimeIPS, Inc. All Rights Reserved - TimeIPS and the TimeIPS logo are registered trademarks of TimeIPS, Inc.
"Intelligent Personnel System" "Run your Business. We'll watch the clock." are trademarks of TimeIPS, Inc.
TimeIPS is protected by one or more patents. Patent No. US 7,114.684 B2.