Browse Prior Art Database

Time Tracking Tool For Resource Focus Quantification

IP.com Disclosure Number: IPCOM000172121D
Original Publication Date: 2008-Jun-27
Included in the Prior Art Database: 2008-Jun-27
Document File: 8 page(s) / 162K

Publishing Venue

Microsoft

Related People

Michael J. Wilkins: INVENTOR [+2]

Abstract

A forecasting tool that stores time tracking record is described herein. Data is entered based on a fixed schema and specific preset taxonomy, and stored in a database. The specific taxonomy as well as the fact that the tool uses actual data helps to maintain a high level of accuracy and provides the tool a with predictive nature. The software provides a data source for resource analysis. Data collected by this software can be exported to customized reports and used for resource management and allocation.

This text was extracted from a Microsoft Word document.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 25% of the total text.

Time Tracking Tool For Resource Focus Quantification

Organizations must be able to properly quantify, forecast, and allocate their resources. Studying trends and cycles of the business, industry, supply, demand, and other influences help to improve an organizations ability to properly plan their resources. Resource allocation should be adjusted as workloads change.

Quantification is a key part of resource planning and allocation; however,   quantification has historically been a difficult challenge for companies.  There have been a variety of tools in the market that have attempted to facilitate resource quantification, but many have proven to be cumbersome, unspecific to a certain discipline, or outdated. Additionally, these tools are often unacceptable to most organizations because they require administrative overhead. Low overhead resource tracking tools are not common and appear inadequate where they are found. Furthermore, tools in the marketplace today have little value in the operational information technology (IT) environment due to old and outdated taxonomies, especially as this discipline changes so dramatically often in its focus and methods.

A database tool is described herein that stores time tracking records to facilitate resource allocation and analysis within an organization, describing overlap between various disciplines and teams. The database tool can be set up using any one of a number of database applications. Table 1 shows an exemplary table created in Microsoft Windows® SharePoint  that describes attributes that may be stored in a time tracker database. Table 1 includes a list of data attributes that can be stored and used to allocate resources. A database application is used to collect and store the data to a server. Any database system with a user interface that allows shared access can be used. As shown in Table 1, a form is set up with entry fields corresponding to the type of data to be collected. The fields of the table are identified (such as Environment, Date, etc.) and put in the proper taxonomy. It should be noted that since Microsoft Windows® SharePoint is driven by database technology SQL a unique identifier is necessary. This might not be required in other database systems. The other fields may be customized to fit any organization or situation.

Overlap between teams demonstrate how they function together and provides data to managers for the purposes of process planning, delegation, prioritization and hiring needs. This tool possess a predictive nature and can be used for forecasting because actual data is stored and used, thus the output is accurate and can be used to justify priority. A database is used for data entry and storage to facilitate the time-tracking process with specific fields of focus, and centralizes all resource tracking and planning into one tool....