By Richard Adin, Founder, An American Editor
In It’s All About the Benjamins! EditTools’ Time Tracker (Part I), I discussed the importance of collecting data; in Part II, I discussed Time Trackers’ Project Summary; in Part III, I discussed some of the key elements of the Create/Update Project dialog, and in Part IV, a project was created and data to evaluate how the new project was going were created. This final discussion (Part V) focuses on some of the other important features of Time Tracker.
Updating Information
Sometimes things change and we need to change the project information we originally entered. Time Tracker has two different types of information updating.
The first is updating the basic project information itself. To change the original project information, select the project name — not a subpart’s name — and click Update Project (#2), as in the image below.
Updating a project
Clicking Update Project opens the Create/Update Project form for the selected project (see below). Once that form is open, you can modify any of the data. For example, if the client contact information changes, you can replace the outdated information with the new information.
The Update Project form
If instead of updating the general project information, you want to modify already-recorded data (the project details), select the project line if the project has no subparts, or the subpart that you want to modify if the project has subparts, and click Update Details (#A below). Note: The selected project or subpart must have some already-recorded data or Update Details will not be accessible. For example, in the image below, contrast the subpart 01 Bumble Batch 1, which is selected, with the no-subpart project Visions in Freudian Therapy (green highlight). If Visions in Freudian Therapy was selected, Update Details would not be accessible because the project has no already-recorded data to modify.
Selecting the data to be modified
Clicking Update Details (#A above) opens the Update Record (below) where the data modifications are entered.
The Update Record form
The Update Record form shows all of the data entries that are part of the selected subpart (#B) (or project, if there are no subparts). The first entry line (“0 hours, 0 minutes, 0 pages”) was created when the subpart/project was created. That line should be left alone because modifying it will distort your data. The next two lines shown (#B) are the data from the two work sessions that were part of Batch 1 (see Part IV of this series). Because the second work session is selected for modification, the component parts of its data are shown in the modification area (#C).
You can either modify some or all of the data, or leave the information as is. To leave it as is, click Close. Otherwise, modify the data that need modification (see below) and click Update (#D) to make the modifications. In this example, two modifications are being made: the subpart name (“(Preliminary)” is added) and the page count (increased from 17 to 18, which changes the total page count for the batch from 22 to 23, and for the project from 53 to 54).
Modifying work session 2 data
Once Update (#D in above image) is clicked, the modifications are recorded and visible on the Project Summary (green highlight in image below).
- Important: Compare the highlighted numbers for the Effective Hourly Rate (EHR) and Average Pages per Hour (APH) for the project, batch, Year-to-Date (YTD), and Lifetime shown here with the same numbers, before the modification, shown in the previous image of the Project Summary. It is worth noting the effect a one-page change, from 17 to 18 completed pages, has, especially on the EHR.
The modified data displayed on the Project Summary
Other Options: Removing/Reinstating Projects from/to the Project Summary
As time goes by, the number of projects will increase, which, if not removed from the Project Summary, will make it difficult to access current projects. Consequently, Time Tracker lets you remove completed projects from the Project Summary and save them. But removal from the Project Summary doesn’t mean the project dataset is lost.
Completed projects that have been removed from the Project Summary can be accessed using the History button (see image above).
To remove a completed project from the Project Summary, select the project, not a project subpart, to make the Remove From List button accessible. Then click Remove From List.
- Caution: If a subpart is marked completed but there are still open subparts for the project, selecting the completed subpart and clicking Remove From List removes the entire project, not just the completed subpart. If that happens, go to the History and reinstate the project.
A removed project can be reinstated in the Project Summary via the History button. In addition, a completed project, once reinstated in the Project Summary, can be reopened via the Reopen button.
For more-detailed information about removing and reinstating projects, as well as reopening projects, see the Time Tracker Help file.
Other Options: Archives
Part IV of this essay series discussed Time Tracker’s autosave feature. However, there is another part of the autosave feature that was not discussed in Part IV: autosaving of the Time Tracker data.
Time Tracker’s Archive is a temporary backup of project data in the event that something happens while you are working on the project. (It is called “temporary” because only 10 datasets are saved; when the 11th save occurs, the oldest dataset is automatically deleted, leaving 10 available saved datasets. When a project is completed, the saved “temporary” datasets — up to 10 — remain available.
One other item to note: Unlike Word’s temporary files, these datasets do not use the .tmp extension. For more detailed information about Archive files, see the Time Tracker Help file. Should data become corrupted or lost from an unexpected event like a document crash, the Archive file can give you the data from the time of your last (up to 10) timing stop. Every time you stop Time Tracker, it creates an Archive file. The problem is that the archive is created only when you stop timing. Consequently, if you last stopped timing two hours ago and Word crashes, in addition to having lost some of your work, you will have lost the time calculation that occurred between the last stop and the crash.
The Archives, however, prevent a total loss of data and can tell you when the last stop occurred, so you can calculate how much time passed between the last stop and the crash event. To protect against total data loss, you can access up to the last 10 data saves; when the 11th save occurs, the oldest save is deleted.
For more-detailed information about the archiving feature, see the Time Tracker Help file.
A Final Word
Time Tracker is probably the most-valuable macro an editor can have and use. Truthfully, I wish I had it when I started my editing career 35 years ago. The data that Time Tracker tracks are the data I have tracked over those years, because for me, there was nothing more important than being sure I was making a profit.
I had a family to support, retirement to plan for, health insurance to buy, a mortgage to pay, children heading to college, insurances and taxes to pay, and the list goes on. It made no sense to work at something that couldn’t support me and my family, no matter how much I enjoyed my work and no matter how good I was at it. Family brings on more paramount concerns and obligations, making knowledge about how my business was doing essential.
Having been in other businesses before becoming an editor, I was aware that it is easy to be fooled into living paycheck to paycheck, just getting by, and not really earning a living wage. As the years passed and the editorial business changed (when I began, it was the publisher who directly hired you, not a low-priced, third-party, offshore company), the compensation battle became more difficult. As people lost jobs or couldn’t find work, more people offered editorial services (“I love to read and easily found spelling errors in XYZ book, so perhaps I should be an editor!”), so competition increased. All of this and more made keeping and interpreting data ever more important.
Properly used, Time Tracker will help you track how you are doing so you know whether you can continue as you are or need to find ways to become more productive and efficient so you can increase your Effective Hourly Rate (EHR). Time Tracker will help you prepare better bids based on past similar projects and determine whether current clients are desirable clients.
In addition, Time Tracker data, combined with knowing your required EHR (rEHR), will help you determine what to charge. For example, if your rEHR is $30 but your average EHR (i.e., over multiple projects — the YTD and Lifetime calculations) is $25, you know that you need to either increase your rate or find a way to be more efficient and productive so that the YTD and Lifetime EHRs exceed $30.
Finally, Time Tracker data can help you ascertain which method of setting a fee works best for you over multiple projects (see my AAE essay, “The Rule of Three”), as well as which types of projects (e.g., fiction or nonfiction, fantasy or romance, biography or medical, short or long documents) and services (e.g., copyediting, proofreading, developmental editing, indexing) generate the most work, income, and profit.
The complete and detailed Time Tracker Help file is available for download from wordsnSync.
Richard (Rich) Adin is the founder of the An American Editor blog, author of The Business of Editing, owner of wordsnSync, and creator/owner of EditTools.
Leave a Reply