This is a read-only archive. Find the latest Linux articles, documentation, and answers at the new!

Feature: Tools & Utilities

Track projects and time the easy way with jWorkSheet

By Dmitri Popov on December 17, 2007 (4:00:00 PM)

Share    Print    Comments   

High-end project management tools and low-end to-do utilities are a dime a dozen these days. But what if you need something less complicated than a full-blown project management application, but more flexible than a simple to-do list? In that case, give jWorkSheet (JWS) a try. This tiny Java-based tool offers basic project and task management features sprinkled with worksheet-like capabilities. The result is a simple yet functional tool for keeping track of your projects and tasks and the time you spend on them. It's especially useful if you bill per hour and a need a simple utility to track your time.

Because it's a Java-based application, JWS needs the Java Runtime Environment to run and requires no installation. Just unpack the archive and launch the program using the command java -jar the jWorkSheet.jar.

JWS's interface is simplicity itself. It consists of three tabs: Events, Projects, and Parameters. The Projects section also contains the Tasks pane, which lists the tasks for the currently selected project.

To use jWorkSheet, you first create a project, then populate it with tasks. Instead of creating a new project or task from scratch, you can use the Copy button to duplicate the currently selected item, and then modify it. For each project you can specify three options: Default, Finished, and Private. When you mark a project as Finished or Private (or both), it doesn't appear in the Events section. When you mark a project as Default, it will be inserted automatically in every new event you create in the Events section -- which can be a real time-saver when you're working with multiple events. The Default and Finished options in the Tasks section work in exactly the same way.

Despite its name, the Report button in the Projects section doesn't actually generate reports. Instead, it copies a list of all projects or tasks into the Clipboard, so you can, for example, insert it into another application.

The Events section allows you to create events that act as timesheet entries. To add a new event, press the New button. If you set a default project and task, they will automatically be inserted in the created event, along with the current time.

JWS automatically keeps track of the time spent on the added event, and stores the time data in the Period field. For example, if you create an event at 9:00, and then add another one at 9:30, JWS automatically sets the Period field of the first event to 30 minutes.

The Report button in the Events section allows you to generate all kinds of reports based on the recorded data. For example, you can create a report for a specific period of time (e.g. day, week, month, or year) that includes a list of all events or a detailed breakdown of all projects, tasks, and events. When you choose the report type you want and press the OK button, JWS generates a nicely formatted HTML report and opens it in the default browser.

Finally, the Parameters section allows you to tweak JWS's settings, such as local working hours, date format, and default browser.

All JWS data is stored in an XML file (in the /home/user/.jWorkSheet directory), which has a simple structure, as shown below:

<Project> <ID>1</ID> <Default>false</Default> <Finished>false</Finished> <Private>false</Private> <Description>Monkey Project</Description> <Task> <ID>1</ID> <Default>false</Default> <Finished>false</Finished> <Description>Wash Monkey</Description> </Task> </Project>

This makes it easy to exchange data between JWS and other applications. For example, you could write an macro that would automatically create a new task in JWS based on the document info.

Final word

There are still some rough edges in JWorksSheet: the Report button in the Projects section, for example, could do something more useful than just copying data into the Clipboard. But if you are looking for a no-nonsense tool that can help you to keep tabs on your projects and tasks, give it a try.

Dmitri Popov is a freelance writer whose articles have appeared in Russian, British, US, German, and Danish computer magazines.

Share    Print    Comments   


on Track projects and time the easy way with jWorkSheet

Note: Comments are owned by the poster. We are not responsible for their content.

Track projects and time the easy way with jWorkSheet

Posted by: Seraphyn on December 18, 2007 01:37 PM
The Link do not work. Is Wrong: (
Please Fix it. is here.
Merry Christmas and greetings




Posted by: Anonymous [ip:] on December 19, 2007 01:59 AM
I saw an article on freshmeat.? about OOS I like the idea. It seems to me that such a project wouldn't need much suport as it is a meta project. A project built from any other project placing there code or linking a refrence on an OOS tree. Like decorating a christmas tree. The tree being a metaphore of a space like a wiki that simply colects and refrences info. The value of such a space is that people can contribute by translating language or computer code to diferent languages, refrence hardware and simmilar functioning software, provide documentation and application specifics in an easily accessable format.


To-do list management

Posted by: Anonymous [ip:] on March 03, 2008 10:17 PM
Thanks for the link, Dmitri. I'm constantly switching between Linux and Windows, so I was looking for a simple cross-platform to-do list and project management software, but couldn't find any. The only solution I have found was online to-do list management ( but I like to have my lists in separate application, not in browser. I will give jWorkSheet a try. If only there was an XML standart for to-do lists... Every piece of software has its own.

Yury Akulin, creative <a href ="">logo design</a>


Track projects and time the easy way with jWorkSheet

Posted by: Meteko on March 06, 2008 10:51 AM
I have tried jWorksheet software and i find that it is the best desktop time tracker application i have come across. The data are presented in a spreadsheet like format and you can create your own user reports by a XSL transformations.
<a href=""></a><a href=""></a><a href=""></a><a href=""></a><a href=""></a><a href=""></a><a href=""></a><a href=""></a><a href="http://www.globallinknetworks"></a>

Worth a try!




This story has been archived. Comments can no longer be posted.

Tableless layout Validate XHTML 1.0 Strict Validate CSS Powered by Xaraya