jWorkSheet

jWorkSheet is an open source personal desktop time tracker for your projects, data are presented in a spreadsheet like format. Application offers some completed work sheet reports, however you can create your own user reports by XSL transformations.

	Easy to use simple control, user reports, open source project		Flash presentation is ready for your quick start
	Spreadsheet graphical interface designed for detail project events		Unique architecture based on the Ujorm Framework

There is a short Flash tutorial available, for a quick start.
Graphical interface of the application contains three tabs. The most important tab is located on the first position and have got title Events.

1. Events

The first tab shows a list of all begun events of the selected day. Everyone event has its own row with cells time of start, assigned project, task and some description of the event. A new event ends the previous event always, a period of the last event is allowed to edit (period is entered in minutes, a decimal format means hours).
Remarks:

• Period of "PRIVATE" projects is excluded from a total time, the behavior can be useful for a lunchtime e.g.
• There is recommend to press a "Sort" button (or hot key F6) to recalculate a total time of the selected day after any time modification.

2. Projects and tasks

A second tab shows all prepared projects and its tasks. A finished project or task can be signed by "FINISHED" status to exclude the appropriate event from an offer of new events. All number of project must be unique at latest in time closing the application, the same rule is valid for numbers of task in scope of one project.

3. Parameters

Table of parameters enables to you to modify some features of the application. A description of the parameters will be available in some of future release of the application. There is possible take back all values by a "Default" button in case of some unsuccessful modification.

Application jWorkSheet can offer to you a user reports for a special requirements. There are two steps description how to create a user report on Window system:

• copy file "C:\Documents and Settings\USER\.jWorkSheet\styles\ReportBase.xsl" to a different XSL file in the same folder on Windows system
• modify content of the new XSL file by a text editor (with UTF-8 support best) for a transformation of a source file data.xml

There are some links about XSL transformations:

• http://www.topxml.com/xsl/tutorials/intro/xsl3.asp
• http://www.w3schools.com/xsl/
• http://www.xmlfiles.com/xsl/

Since release 0.85 the application supports so-called external modules where the each module can extended a graphical user interface (e.g. a new tab) or can perform some action during the start or end the application. Some basic features:

• a module in a JAR format must be located in a directory: $HOME/.jWorkSheet/modules
• the JAR file module file must contain a meta file in the text format: META-INF\JWS-MODULE.MF
• the contain of the meta file has a specification of the module main class by a template: Main-Class: testmodule.TestModule
• the module main class must to implement an interface: net.ponec.jworksheet.module.ModuleApi with a no parameter constructor.

There is an template project for a new module implementation in the CSV repository in the NetBeans format. See a more information in a JavaDoc.

This is a list of different reviews about the jWorkSheet software:

• Linux.com: Track projects and time the easy way with jWorkSheet
• Evil Tester: How to find out where the time goes
• Moongift.jp: I try to manage working time by "jWorkSheet" (translated from Japanese by Google)
• linformatika.ru: Review of the jWorkSheet in Russian

The application jWorkSheet is based on a library UJO Framework. solve all data perzistence and table presentation. There are some characteristics of UJO Frameowrk:

• open source
• revolutionary object architecture based on two interfaces
• support of table component
• small source code of your UJO objects
• checking by unit tests
• simple module support
• tiny framework without further dependencies

Source code is Java 5.0 compatible, the NetBeans IDE was used.

Application jWorkSheet was released under an open license GNU/GPL version 2, it means, the application can be used in commercial and private purpose and under the conditions is available a source code to.
A development documentation is available in a JavaDoc format.

A third party licenses:

• Icons by an author Mark James have got license Creative Commons Attribution 2.5 License.
• Ujorm Core was released under license Apache License, Version 2.0. The framework manages a XML data and builds a table component.

The latest source code is available on GitHub. Original installers are on SourceForge.

• You can write some suggestions or questions on blog http://ujorm.blogspot.com/
• See homepage http://ponec.net/home/ for more applications of the author.