Stone Age Software

Doing
Torch
Whack

Doing - Essential Documentation



You should start by installing and playing with the program, but please read this file before using Doing for real.

I have kept it as short as possible in the hope that people will read it. It only contains information that is not obvious, and you will save yourself much time and confusion by reading on. The online help, which is under the i symbol at the top right of each tab, gives more details.


Data Model

In Doing you are always doing something, even if its just a certain something called 'Nothing'. That means that I don't need to store end times or durations, but just the times of the transitions and the names of the activities following them. (I use the names rather than some database ID so that the records in the history continue to mean something even after activities get deleted from the list of choices.)

If you rename an activity I rename all of its transitions, but if you delete it I do nothing. In this case the pattern and formal names are no longer available. The activity list and history are in the databases 'Do4-Acts' and 'Do4-Trans' respectively.

The advantage of this format is that it has little redundance (duplicated data) and is therefore very robust (no inconsistent states for the data). Furthermore, I am storing your data in the raw form in which you entered it, rather than some processed version whose flexibility would be limited by my imagination. All processing of the data gets done at the export stage.

Using the Clock

This is a bit complicated at first but becomes very ergonomic once you've got the hang of it.

  1. Very alert people can just click on the activities when they start them.
  2. Ordinary mortals will often have to wind the clock back before clicking the new activity, because they probably started it some time ago. Theres nothing to prevent you from winding forward and making entries for the future too, but it doesn't seem to make as much sense.
  3. Doing works to the nearest minute, and won't store stints (periods of a single activity) shorter than this. That means that if when clicking in the list, you miss and select a different activity, just hit the right one quickly. Only in the unlikely event that the current minute changed in between the two clicks would you get a one-minute stint of the wrong activity, but you could correct this in the 'see' tab anyway.
  4. As you wind the clock, you should see the list selection changing to show what you were doing at the time you wind to.
  5. Suppose you've been doing Project1 for a few hours, but now decide to reclassify this time as Project2. You should wind the clock back to the exact minute when Project1 started (the earliest minute at which Project1 is selected in the list) and then hit Project2. This works for the same reason as what I said in point 3.
  6. Suppose you clicked Project1 half an hour ago with good intentions, but now your conscience tells you that you haven't really started working yet. Click Project1 again to move its start time to now, and then get working.
  7. Simililarly (but less usefully) if you currently have 'Nothing' until 9:30 and then change to Project1, winding to 9:00 and clicking Project1 will move Project1's start time back to 9:00.
  8. The above points have the side effect that you should enter your stints in chronological order. Supposing you had 'Work' all day Monday and Wednesday, then wound back to Tuesday morning and clicked 'Work'. Doing would think you were moving the start time of Wednesday back 24 hours, and would ERASE the real start time for Wednesday.

To simplify: Doing is a tool for counting working hours as they happen. The clock is there just in case you forget to clock in the moment you walk into the office. It is not an invitation to leave all your data entry until three weeks later.

Export

You can easily export to any software that likes to see table-like data with tab separated fields. eg. MS Office. Doing exports memos which the standard palm software then makes available under windows. From there you can copy-paste straight into Office or whatever. In most cases Doing generates one memo per month, but sometimes has to split them further due to the size limit of a memo.

In the 'out' tab you will see the 1-5 radio, a fairly complicated set of options, a Go button and a Results list. The 1-5 are storage slots where the other options are remembered. Ie. all five slots start at the default setting and you can adjust them independantly. After setting the other options, hitting Go generates the output and updates the Results list which is slightly easier to read that the generated memos.

The three styles are most easily summarised like this: Prof = what most employers want to see, Basic = useful for sending to a database, Raw = just for peeping into the raw data. The Raw style exports the data more or less verbatim. This could help you to see how Doing works internally. 'Basic' processes the raw data into a set of from-to stints and exports them one per line. It is now meaningful to declare some activities to be included in this report and others (eg sleeping) to be irrelevant. That's what the right hand multi-select list box is for. The list box on the left says what info should be listed in each record and in what order. Eg. Do you want the start and end times or just the duration?

The 'Prof' style is a development of 'Basic' which forces one line per day to be printed. The fields offered in the left hand list box are now a little different from those available under Basic, and most people can get the body of their timesheet generated by this style alone.

If you have a very complicated life with seperate clients and sub-projects, I suggest you export Basic reports from Doing and paste them into a database like MS Access from which you can do whatever you want.

Purge

Doing likes to keep two whole months of data plus this month so far. If it finds itself with data older than this it asks to purge on startup. You can customise this behaviour under 'set' and immediately delete things older than a date of your choice.

That was the desperately important stuff. The rest is optional.

FAQ

Will it export data? Yes, and with great flexibility. It assumes you want the data to land in MS Access or Excel eventually. This can be your database or spreadsheet, not one that I define for you.
How does the export work? You set lots of options, then it exports memos. After the next HotSync you can copy-paste these memos from the Palm-Desktop software or Outlook directly into Access or Excel.
I'm having trouble pasting into Access. Is there something else I need to know? For this to work you need a table whos field-types correspond to what you are pasting into them. The names of the fields are irrelevant. Then you have to select at least one whole record before hitting paste.
My employer uses tediously long and cryptic names for what I call 'This' and 'That'. How do I make a report that he will understand? That's what the activity options Text1 and Text2 are for. For me they mean project and sub-project whilst one user uses them as client's project-name and agency's project-name but you might use them for something different again.
Do I have to reset all these export options every time? No, you have five independant storage slots.
When I select more than one activity for export, it mixes them all up. I wanted them seperate. That's why you've got five storage slots. Select a different activity in each slot and then you will get seperate memos.
What happens to old Doing-exported memos when I redo the export? Doing deletes all old memos from the same storage slot before exporting the new ones.
Is it true that you finally got around to implementing a purge-now function and put it under general options which is in the 'set' tab when 'Nothing' is selected? Yes.
My reporting requirements seem to be too complicated for Doing. What do I do? Export using the 'Basic' style into a database and then finish the job using queries in the DB.
Something wierd happened when I wound the clock a long way and then clicked an activity. Was it a bug? No, its a feature! Until you've understood exactly how the clock and data model work, I suggest you dont wind forward at all, and don't wind back further than the last transition. Then read 'Using the clock' above.
Can I have two stints of the same activity right next to each other? No. Doing would combine them into a single stint. There is a reason for this.
Can I have two stint notes for one stint - i.e. one for the first half and another for the second? No, but you could enter a one minute break where you changed subject. You need the break because of the previous point.
Is the data backed up? Yes. There is one backup of the Doing data on the PC, which gets updated every time you do a hotsync. It is under \PalmDir\UserName\Backup and consists of three files called Do4_???.pdb
I want to upgrade to the next version. Will my data be preserved? Of course it will. This is a professional product!
I have a Macintosh. What's the deal? I don't, so I don't know what Palm offer you, but the only requirement that Doing has of the desktop computer is that its spreadsheet or database can work with tab-separated tables.
I am considering buying a competing time tracker. How should I make this decision? Tell me what the competition has got that Doing doesn't and I'll implement it before your trial runs out.
I think Doing is cool. Is there anything I can do to show my appreciation other than paying for it? PalmGear have an excellent feature where you can write a review that appears on the product's page (here). You could also beam it to all your friends using the button on the main tab.
How many object oriented programmers does it take to change a lightbulb? Changing the lightbulb isn't gonna solve the underlying problem. What you really want to do is pull that whole light fitting down and replace it with ...

Minor Updates

If you agreed to receive email from me, I will inform you of minor updates as they appear. These are always free and contain bug fixes, cosmetic improvements and minor features that really should have been there all along. They don't include major new functionalities.

You should install the minor updates as I tell you about them, even if you can't see anything wrong with your current version. That was a warning.

If you chose not to receive email from me, you can send me a mail to give me permission after all. Otherwise you can occasionally check the current minor version number at the web site.

Requests

If you want something I haven't thought of, ask me for it. Here are the contact addresses:

Pre-sales enquiries:info@stone-age-software.com
Technical support:help@stone-age-software.com
Suggestions for features or changes:gimme@stone-age-software.com
Download/Install/Payment problems:emergency@stone-age-software.com
Bugs in software:idiot@stone-age-software.com
Webmaster:webmaster@stone-age-software.com


Enjoy,
Adrian


Torch - the world's smallest useful Palm app.


Freeware. Good for all Palms with an inverting backlight (i.e. if, with the light on, the letters look brighter than the background.)

It's dark. You are fumbling around using your Palm backlight as a flashlight, but it's just not bright enough. Torch, using only 524 bytes! of palm memory, makes your screen as bright as possible through judicious choice of screen colouring (black.)

Torch is not only freeware but open source too:

	#include <Pilot.h>
	RectangleType r={0,0,160,160};
	DWord PilotMain( Word cmd, Ptr, Word)
	{
	  EventType e;
	  if (cmd==sysAppLaunchCmdNormalLaunch) {
	    WinDrawRectangle(&r,0);
	    WinEraseChars("stone-age-software", 18, 38, 50);
	    do {
	      EvtGetEvent(&e, evtWaitForever);
	      SysHandleEvent(&e);
	    } while (e.eType!=appStopEvent && e.eType!=penDownEvent); }
	  return 0;
	}

Challengers for the title of world's smallest useful Palm app are heartily invited.


Whack - damsels in distress, hideous evil-doers and you in your shining armour.



Remember that the scores in this game are decided more by the babes than by the turkeys. If you score above 25,000 you can take a look through the holes 8^)



Installing stone-age-software products: just double click the .prc and follow the instructions.