ts_monthly - a tool for reporting project time for a calendar
Object_Id : 188
Title : ts_monthly - a tool for reporting project time for a calendar
month
Node_Type : Production
Format : HTML
Address : /usr/local/bin/ts_monthly (on guava)
Keywords : TSS
Abstract : ts_monthly is a script to allow us to get a calendar month's time
against a particular project - reported by person by day (you can also get
all projects, but be warned that this creates quite a big file ...)
It was created to allow us to get away from having to use paper
timesheets to work out what to charge those clients who required billing to
a calendar month rather than to CiTR's standard timesheet month.
The command arguments and an example of its use are given in
"Additional_Info" below.
Note that internal revenue and cost calculations should still be worked to
CiTR's timesheet month when reporting revenue, etc...
Date_Entry_Created : 26/02/97
Entry_Created_By : jane
Date_Entry_Last_Modified: 28/07/97
Entry_Last_Modified_By : jane
Asset_Qualification : good / very useful
Other_Opinions :
Contact_Person : Ricky Leung
IP_or_Copyright_Owner : CiTR
Support_re_Ownership : developed for our timesheet system, TSS
Date_Item_Created : Feb. 97?
Usage_Conditions :
Support_re_Usage_Condns :
Authors_and_Contributors: Ricky Leung
Projects_Used_In : as required
Obtained_From :
Derived_From :
Related_Items :
Code_Type : simple tool
Programming_Language : Unix shell commands
Portations : feijoa
Source_Location :
Binaries_Location : /usr/local/bin/ts_monthly
Issues_Bug_etc_List_Locn:
Additional_Info : Here is the usage information:
guava > ts_monthly
Usage: ts_monthly yy mm first_friday_d [ project_code ]
yy: a 2 digit number specifying the year
mm: a 1-2 digit number specifying the month
first_friday_d: an 1 digit number specifying the first Friday in the month
project_code: (optional) project code in uppercase
Here is an example to produce a report for project _U001 for
the month Jan 97:
guava > ts_monthly 97 1 3 _U001
Producing report ts_monthly.rpt ... done
A report called "ts_monthly.rpt" will be produced in your
current directory. Import the report into Excel. The
report looks like this:
guava > head ts_monthly.rpt
Date , Staff , Project Code , Hours
01/01/97 , Derrick Hill , _U001 , 5.00
01/01/97 , Peter Bell , _U001 , 9.50
01/01/97 , Stephen Williams , _U001 , 8.00
02/01/97 , Derrick Hill , _U001 , 8.00
02/01/97 , Norm Lawler , _U001 , 5.00
02/01/97 , Peter Bell , _U001 , 8.00
02/01/97 , Ricky Leung , _U001 , 7.25
02/01/97 , Robert Coote , _U001 , 7.25
02/01/97 , Stephen Williams , _U001 , 8.00