An easy-to-use project management software that streamlines administrative work for land surveyors.
Project Tracker Pro
23806 190th Ave. SE
Kent, WA 98042
800/266-5930
Online: www.projecttrackerpro.com Suggested Price List: Project Tracker Pro v4.00 can be purchased for $799; additional seats can be purchased for $99. The v4.00 upgrade is listed at $399 plus an additional $20 per seat.
|
|
| The
My Tracker utility brings up a window that shows the most recent timecard
entries, intra-office messages, tasks and schedules--
all in one interface. |
|
Project
Tracker Pro (PTP) project management software was designed by land surveyors
for land surveyors. Developed by Crones & Associates Inc., Kent, Wash.,
the database program integrates most of the functions a surveyor needs to
maintain contacts, projects, time tracking, billing and miscellaneous
reporting. I have used a mélange of software tools in the past to accomplish
the same tasks; however, I was unsatisfied with the amount of time I wasted
repeating work. Few situations are more frustrating than filling out multiple
forms over the life of a project--e.g., estimates, proposals, contracts,
invoices, and close-out and marketing forms--when much of the same information
is repeated on each form. PTP solves this problem by allowing the user to enter
a client’s information just once, and then it applies that information across
multiple utilities. I have used Project Tracker Pro in my firm for more than
three years and am currently using version 4.00.
The software is based on the widely used and accepted Microsoft Access program.
The Access part of the program is licensed with PTP, so Microsoft Access does
not need to be installed separately on the host computer. Some of the
limitations of Access, such as network speed and file size restrictions, apply
to PTP, as well. However, PTP software manages the database well, and my firm
has never lost information or had a corrupted file despite implementing
multiple computer and software upgrades. I think this record speaks well for
the software designers at PTP.
As a database program, PTP stores a small program on the user’s computer and
then accesses a common database file hosted on a network connection. The front-end/back-end
approach makes data management and scalability simple.
Intuitive Project Management
|
|
| PTP
interfaces with Microsoft MapPoint as well as popular Internet mapping tools. |
|
When PTP is launched, the user is asked to log in. This log-in information is
used to determine access parameters and the amount of information visible to
the user. For users with administrative-level privileges, a tool box graphic is
displayed that contains links to functions commonly used together. For
instance, the main menu area drops down to reveal links to “Projects,” “Contacts,”
“Reports” or “Schedule.” The program is intuitive and easy to master. I have
generally found that new employees can pick up the basics within a couple of
sessions.
PTP links most functions either directly or indirectly to the Projects menu.
This menu allows users to create custom templates (MS Word compatible) and is
also preloaded with many common templates, including boundary surveys,
topographic surveys, rates, and standard terms and conditions. Each template
can be easily edited or reformatted to meet the needs of a specific project.
For example, a Florida-based company would have no use for a record of survey
template since there is no recording law in Florida. Likewise, the section, township and
range of commonly used index fields wouldn’t be used if a surveyor practiced in
a non-PLSS state. The Projects menu allows input of almost any piece of
information a surveyor might want to record. Custom fields can be edited to
record information that is unique to a region or project. Information entered
in the Projects section of the program is then used subsequently for all
project documents, such as estimates, contracts and invoices.
Under the Projects menu are several tabs. A Field/Crew Information tab shows
information relevant to the field work on a specific project and includes
checklists and schedule details. The Financial Information tab leads to another
level of tools associated with billing, hours worked, estimates, invoices,
payments and billing rates.
The last tab under Projects is the Tracking/Reports tab. This section contains
tools for tracking and reporting on a project. It essentially summarizes what
has happened on the project based on inputs from users over the life of the
project.
Contact management in PTP is similar to many other programs in that it includes
common fields for names, addresses, phone numbers, etc. However, PTP features a
valuable tool that allows all of the contacts to be linked to projects based on
their relationship to it, i.e., a contact can be linked to one project as the
owner and to a different project as the attorney or engineer or whatever role
he or she holds. This function helps our firm keep track of who is involved on
a project and allows us to include all of the involved individuals on important
e-mails and other correspondence.
Reports is the next major area of PTP. This set of tools is broken into two
categories: General Reports for project managers, timesheets, etc. and
Financial Reports for billing, accounts receivable, etc. This is one area in
which PTP has room to improve. While the prepackaged reports are fine, it would
be helpful to have a custom report generator.
The Crew Scheduler function is self-explanatory, and PTP attempts to make a
database function like a calendar. It works--don’t get me wrong--but it’s
clunky and slow. It may be that scheduling is just too complicated a task to
include in a program of this type. After all, there are other software programs
dedicated to scheduling, such as PrimaVera or MS Project.
The remainder of PTP is divided into personal tools, database setup and
combinations of tools that are accessible from previously described menus. The
layout is intuitive and easily navigated. I’ll just highlight some of the items
I have found most useful.
The My Tracker utility brings up a window that shows the most recent timecard
entries, intra-office messages, tasks and schedules−all in one handy interface.
Clicking on any of the items brings up a more detailed view for editing.
The Time Card utility works well and does an excellent job of tracking
employees’ time and tasks. It feeds right into a variety of other functions
such as monitoring costs, comparing estimates versus actual time, and billing
preparation.
Microsoft MapPoint is a separate program that can integrate with PTP. This is a
very useful tool that maps project locations based on their lat/lon tag or
street address in PTP and is useful for driving directions and planning. It
also replaces the old pushpin wall map for locating work a company has
performed in the past. Another nice feature is using a screenshot from MapPoint
and associating the image with the project data for later use on a computer that
does not have MapPoint installed.
PTP also has several built-in search routines for finding projects. A user can
search for projects based on data contained in any field. A search can also be
done on any combination of fields, inclusive or exclusive. This is very helpful
for marketing, for example when you are trying to find a certain type of work
completed in a certain area. PTP also allows a sort of geographic search based
on fractional areas of the PLSS or latitude/longitude. This search function is
also helpful in finding other projects by proximity and avoiding work
duplication.
Database Setup in PTP is also intuitive. I would estimate a couple of hours to
set up initially, but plan on spending several hours a week for a few months
while you customize the contract templates, standard scope terms and
checklists.
Once PTP is set up, it takes practically no maintenance to keep it running.
Backups occur automatically and the system is reliable. Occasionally, I have
connection problems when I switch laptops or the network changes, but these
problems are easily resolved.
A Time-Saving Program
|
|
| Microsoft
MapPoint maps project locations based on their
lat/lon tag or street address in PTP. |
|
PTP is very comprehensive, but it will take some trial use to determine how it best fits your organization. For example, while it integrates most of the business functions that a typical surveying firm needs, it is not a replacement for financial software. Our company still maintains a separate QuickBooks financial record, mostly for tax purposes, although we do generate all invoices, billing and accounts receivable using PTP. (Incidentally, it is possible to have a custom report written by the developers of PTP and added to a user’s version of the software. We have done this for a financial report and found it to be relatively inexpensive.) Likewise, PTP does not replace mapping software. However, it does have certain geographic search routines that work well--for example, Microsoft MapPoint is a good search engine if you have it installed. Alternately, you can search by longitude or latitude or by section/township/range, and the software also links to popular Internet mapping engines.
Some improvements could be made to PTP. The database contains a huge amount of valuable information, yet PTP is limited in its ability to import and export information between other programs. Therefore, it would be helpful to be able to link the PTP database with a GIS program like ESRI’s ArcView. It would also be helpful to import and export contact or e-mail information from or to MS Outlook.
PTP has improved with each new version, and I understand that many of the improvements that could be made are currently under development for a new release. For example, the MS Access data structure, which is limited in size and speed, will be replaced with a more robust SQL database in the future. I also expect future versions to continue the trend toward more customizable queries and reports. One additional note is that technical support has always been responsive; support staff generally return my calls the same day.
Overall, this program allows a surveyor to spend more time surveying and less time administering office work. PTP is a niche program that is targeted solely at land surveyors, and I have yet to find its equal. I would recommend it to any small- to medium-sized surveying firm.
Editor's note: In response to this product review, Project Tracker Pro has added three new database export routines: Project Data, Contact Data and Geo Point Data. For more information, call 800/266-5930 or e-mail sales@projecttrackerpro.com.