Excel Timesheet Using Data Validation by ped96069


More Info

          and SharePoint
An enterprise timesheet
 presented within your
corporate collaboration
 Easy to use timesheet
In today’s challenging
economy, just tracking
hours is no longer an
effective way of managing
time. These days, to be
effective, corporations need
to track how time is being
spent. Many organizations
are turning to projectized
time tracking as a way of
getting this done.
One of the most difficult
aspects of implementing
project control is the capture
and approval of labor costs.
TimeControl provides an
electronic timesheet system
designed to serve both
Finance and Project

SharePoint interface                                    TimeControl’s easy-to-use web interface is completely
TimeControl can be installed directly in your          customizable. It is the most effective way to enter both
Windows SharePoint Services interface. This             timesheet data and project progress at the same time.

powerful collaboration environment is in use by over
85million people around the world. TimeControl is
one of the first timesheets anywhere to completely
support the SharePoint interface and provide
SharePoint end-users with an uninterrupted user

Open Architecture
TimeControl is an open architecture system that
supports a variety of databases including MS SQL
Server, Oracle and Sybase, .
Customizable user profiles allow the
TimeControl interface to be tailored to
each user’s requirements.

Powerful Approvals
TimeControl supports HMS
Software’s unique Matrix Approval
Process for Labor Actuals™ which
allows for quick authorization of
project data. Automated validation of
timesheet data is handled by
TimeControl’s remarkable Validation
Rules. Additional approvals can be
done manually with a simple Approve/
Reject or Approve/Update process.

                                                              TimeControl’s Validation rules allows an unlimited
                                                                       number of business rules to be created.
   … in the SharePoint interface!
                                                                                          Total Flexibility with User Profiles
                                                                                            TimeControl’s User Profiles allow
                                                                                            the Administrator to determine
                                                                                            which menu choices, reports and
                                                                                            fields should be accessible by each
                                                                                            user. No other system on the market
                                                                                            today offers this much flexibility.

                                                                                              Field level security ensures that
                                                                                              only the information which is
                                                                                              important to each user, is displayed.
                                                                                              This makes TimeControl at once a
                                                                                              secure, deployable system and an
                                                                                              easy-to-use one as well.

                                                                                         Links to Project Management
                                                                                         and Finance
                                                                                         TimeControl includes direct links to
                                                                                         project management systems such
                                                                                         as Microsoft Project, Project Server,
                                                                                         Primavera, Deltek’s Open Plan, and
                                                                                         Cobra. TimeControl also links to
TimeControl includes an extensive reporting system. The output      virtually any ERP or Finance system including SAP,
from reporting can be saved directly into Excel.
                                                                    Oracle Financials, PeopleSoft, Baan and Microsoft

                                                 The auditable nature of TimeControl data makes it an ideal complement
                                                 to your Finance System. No longer must you worry about reconciling the
                                                 data from multiple timesheet systems or multiple sources.

 TimeControl allows an unlimited number of links to external systems to be defined. It can transfer data with vir-
 tually any ERP or Finance system including SAP, Oracle Financials and Microsoft’s Dynamics.
  TimeControl delivers a powerful, flexible,
   timekeeping system designed to work
        inside Microsoft SharePoint

 4 Editions to choose from                     editor (TCp and TCe only)                    which each employee can have a
 Choose the edition best suited for your       Complete auditability of timesheet data      unique approval routing
 size of business from 10 to 10,000 users.     User-defined fields on every table (TCp     Links to Project Management
    TimeControl Express (TCx)                  and TCe only)                                Direct integration with popular project
    TimeControl Professional (TCp)             Add pop-up data validation for each          management systems such as
    TimeControl Enterprise (TCe)               user-defined field                           Microsoft Project and Project Server,
                                               Data Dictionary facilitates integration      Primavera and Deltek’s Open Plan and
    TimeControl Industrial (TCi)
                                               with any external system                     Cobra
 Easy to use Interface                         Allows charges to be linked to a specific    Supports multiple project management
   Full browser-based interface and;           project                                      systems
   A Windows interface (TCp and TCe only)      Allows charges which are project-            Customizable import/export function to
                                               independent                                  interface with virtually any finance or
   Scaleable, multi-level interface
                                               Multiple overhead charge types               ERP system including SAP, Oracle,
   facilitates use for data entry users yet
                                                                                            PeopleSoft and Microsoft Dynamics
   provides full functionality for             Extensive activity data stored for each
   administrators                              charge code                                 Flexible Reporting
   Multilingual interface                      Filter charge codes, projects and rates      Excel-like reporting format allows output
   Unlimited charge codes displayed in         visible to any employee                      to any Windows-compliant printer or
   simple, hierarchical drop-down lists        Asynchronous updates for remote              reports can be saved as Excel, XML or
   Project management system activity          satellite operations using the               HTML files
   information viewable directly in            TimeControl Consolidator (TCe only)          Reporting Wizards allow an unlimited
   TimeControl                                                                              number of reports to be created and
                                              Web Interface
   Unlimited free-form notes for each line                                                  saved for later use
                                               TimeControl includes several interface
   item and each timesheet                                                                  Unlimited levels of data selection,
                                               options including a full Windows client,
   E-mail-enabled. E-mail messages sent                                                     filtering and sorting
                                               a full web-browser interface, the web
   for system notices such as rejected         interface from within Microsoft
   timesheets or missing timesheets                                                        Expense Reports
                                               SharePoint and the web interface from
   Scheduleable E-mail notification for                                                     Users can enter non-labor costs on their
                                               within Microsoft Project Web Access.
   missing or unapproved timesheets.                                                        timesheet
                                               MyTimeControl™ home page
   Predefined timesheets based on                                                           Unlimited number of expense items per
                                               dashboard gives extensive and
   resource assignments from the project                                                    timesheet line item
                                               customizable information to employees
   management system                                                                        Expenses can be tracked back to a
                                               Smart Client architecture delivers rich
   Customizable menus (TCp and TCe only)                                                    project management and/or finance
                                               functionality in a browser interface for
                                               all versions
 Robust Architecture
   Open database architecture; support for
                                               Timesheet supports proxy server             Government Compliance
                                               security (TCe only)                          Complies with requirements for DCAA,
   Oracle, Sybase and Microsoft SQL
                                                                                            European Time Directives, FMLA, the
   Server, databases (TCp and TCe only)      Approval Process
                                                                                            California Wage Laws and Sarbanes-
   N-tier architecture makes system           HMS’s unique Matrix Approval Process          Oxley
   scaleable for 10 to 100,000 users          for Labor Actuals™
   Unlimited rate codes per employee          Unlimited automatic Validation Rules
   Field-level security. Make any field       are user defineable, flexible and can be
   visible, value read-only, or invisible     applied globally or to any group or even
   Complete redefinition of every field label an individual
   in the system through a simple label       Unlimited manual validation levels in

HMS Software                                                                                            TimeControl
1000 St-Jean, Suite 200
Pointe Claire, QC H9R 5P1
                                                                                                 Enterprise timesheets
Tel: 514-695-8122                                                                             for project environments
Fax: 514-695-8121
Email: info@hmssoftware.ca
Web: www.hmssoftware.ca                                                        www.timecontrol.com

To top