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: 1.8, 1.9, 1.10, 1.11

Site Summary Report

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

Modules Required: IPSRPT Custome Reporting and IPSSITE Site Management

Using the left pane Main Menu, click on: Administration » Payroll and Reports » Special Reports » Site Summary

  1. Select a range for the report. There are four quick report options or you can 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.
  2. Select groups and/or employees to include in the report from the Types, Departments, Sites, and/or Employees section.
    NOTE: Choosing from more than one area will display all associated employees. For instance, selecting "3rd Shift" from Types and "Accounting" from Departments will give you all employees that are in the 3rd Shift payroll type AND all employees that are in the Accounting department, not just all employees in the Accounting Department who also work 3rd Shift.

    TIP: Select a group of employees by clicking on their names while holding down the CTRL key.
  3. If you have never uploaded a template, or if you wish to use a modified template, select an OpenDocument spreadsheet file (.ods) to upload.
  4. 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.
  5. Click on the Run Report button.
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
{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
{MIDNAME}Middle 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.

Was this article relevant to your question? Yes No
©2004-2019 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.