Project Management Software
Corporate Management Software
PROJECT-TIME will produce several reports suitable for executive reporting. It features a Gantt chart display with a current week timeline in a 53 week window. It allows 20 administrative categories to be defined against which time may be reported, and the reports can be sorted several ways with the click of a button.
PROJECT-TIME allows projects or assignments to be created in an intial plan at the beginning of the year, or progressively throughout the year. Time may be reported against "active" Projects only, not against "pending" or "closed" projects. The system reports clearly which weeks have been entered into the database, and which weeks are missing, for follow-up. It also keeps track of credits for Compressed Work Week staff and Compensating Time staff
PROJECT-TIME is interactive, and is based on Excel and Visual Basic for Applications. It requires Excel to run, but it does not have to be installed or loaded as an "addin". Just open it in Excel, click the "REP" tab, and begin entering staff and project data.
STAFF Table for up to 50 staff
CODES definition table
PROJECT Section Progress chart
GANTT chart for planned and actual
(Right-Click and Save Target As ... )
FULL POWER - LIMITED TIME
This system facilitates the senior management planning, monitoring and reporting cycle. It allows high-
level time tracking for up to 50 staff, against an unlimited number of projects, assignments or clients, as
well as recording administrative time categories (Internal Support, External Support, Staff Meetings,
Courses, Training, Leave of Absence, Vacation, Sick, etc.).
This is a "central", not a "distributed" system, which means you only have to buy one copy (which at $9.95
is almost free), and you don't have to spend hundreds of thousands of dollar getting everyone
technologized, connected to the network or internet, specially trained and set up with an infrastructure and
support staff, just to fill out a timesheet. Many organizations will find that with simple staff procedures, this
type of system is more efficient, effective, economical and secure, as well as being faster, easier, and more
directly under management control.
The first step of the setup process involves entering the staff data (this should take about an hour if the data
is readily available). Second, the Administrative Categories and Code Structure should be entered (about 1
hour, once the categories and codes have been firmly decided). Third, enter an asterisk (*) in the Week
Columns for weeks that have a Statutory Holiday (About 15 minutes with a calendar in hand). Fourth, (and
this can be done progressively) enter the project, assignment or client activities together with a start and
end date (and optionally the name of the person accountable for the activity). Fifth, print some
TIMESHEET forms for use by the staff.
Now you can very quickly enter and UPDATE the timesheets. You can also REVERSE the timesheet for
any week, if an error is made. The STATUS AND STAFF REPORT will show, at a glance, in matrix form,
which timesheets have been processed and which are still outstanding.
The open and flexible "Code Structure" can be used for custom coding of your particular STAFF and
PROJECT information, for summarization (e.g. Management, Administrative, Technical, Contractor,
Clerical – Eastern, Western, Central – High, Medium, Low Priority)
The PROJECT VARIANCE REPORT provides identification, summarization, assignment, scheduling and
tracking, using a one-year (calendar or fiscal) Gantt chart to show the planned and actual duration.
http://www.billmcmillan.com/PROJECT-TIME.html
The author of PROJECT-TIME:
William McMillan (Retired)
Senior Information Systems Auditor
Management Board Secretariat
Internal Audit Division
Ministry of Finance
Government of Ontario