My Free Project Tracker

Project Management tool - track Project, Tasks, export Time & Expenses to Excel

I have been creating business solutions (AS400-RPG and SAP-ABAP) for large billion dollar multinational companies for many years. Many of my Clients have required very strict non-disclosure agreements which would not allow any project information being stored on a Web Site that is not within their control, so using Project Tracking tools on another web-site would be a violation of the agreement. I have worked at client-sites where the use of my laptop is prohibited and the USB ports, on their equipment, have been disabled so using my set of Excel spreadsheets is not possible.

This app was developed as a secure solution in compliance with most of my clients – I have also been to client-sites where my laptop and USB key were prohibited on the premises, and my smart phone had to be checked-in at the entrance and returned to me only upon exiting the building.

This app is more than a simple Project List and is not a front-end into a Web Site solution. This is not a replacement for Microsoft Project, but can be used complimentary with Microsoft Project.

I created My Project Tracker as a tool to help me manage projects and tasks for my Clients’ requirements; I used several Excel spreadsheets in order to track projects/tasks and to report progress to my Clients. This app replaces several Excel spreadsheets and incorporates some of the Project Management features that I have used for a few of my Clients.

Each time you enter into My Project Tracker, you will be presented with the Client List screen. All contracts, projects, and tasks will be linked to a specific Client in a one-to-many relationship.

After installation, the app will immediately allow you to create Clients, however, in order to proceed further into the app, you will need to define the drop-down lists that will be used by the app. Installing My Project Tracker will automatically populate some default drop-down lists that are useful for managing programming projects and tasks.

Once the Client and Settings have been established, you can drill-down into the Client to define the Contract. Future enhancements are planned to include daily tracking of actual against budget hours.

From the Contract, you can drill down to the Projects where you can define the type of project, the project team, the planned dates and the actual dates for the project.

From the Project, you can drill down to the Tasks where you can define the type of task, the task team, the planned dates and the actual dates for the task.

From the Task, you can define reporting period, enter daily time and/or expenses against the task.

After setting up the task, you can then export the task report to Excel, and after setting up time and/or expenses, you can export the time report or expense report to excel.

There are nine (9) drop-down lists that need to be defined. The Settings screen shows a brief description of the drop-down list with associated Edit and Help buttons.

Individual help is available for each drop-down list by tapping the Help button beside the drop-down list description.

Installing My Project Tracker will automatically populate some default drop-down lists that are useful for managing programming projects and tasks.

Defining Resources, Skill-sets, and a third screen where you can keep track of which Resource has which Skill-Set will need to be defined by the User before using the My Project Tracker.

When defining Resources, you can link the Resource to a Client (such as Client’s employees) or leave the Company blank as I do for myself or other independent consultants.

From the Help screen, you can review specific help topics for each of the four main components to My Project Tracker: Clients, Contracts, Projects, and Tasks. You can also see a short explanation of how this app came to be and the copyright notice.