sched TCL Application

sched is a GPL application that will keep track of your schedule of events including budget. You will be able to view your planned and actual expenses and balance for each day. The schedule data is stored in Bbuuzzb tables. This program is text/console based.

The sched application is designed for single user use. The Bbuuzzb database engine is part of the included files. Before attempting to run this program, edit the main program file (cupcalc.tcl) and set the Tcl directory structure so that the program can locate the required Future Lab library files. Also, before you can run the sched application, you must set up a database configuration file called dbeng.cfg with a minimum of the tmp_path, log and catalog entries.

<

All configuration files must be located in the same directory as the source program. The sched application must be executed within its current directory so the program can locate the configuration files.

When running this program, it should be run with the bbuuzzb catalog active. In the following detailed description all table names are logical.

# Detailed Description

Sched will store and calculate your schedule of events. Events include budgetary and reminder's. Events are tracked on a day to day basis. This program makes it possible to see your bank account balance for every day there is an event.

All data is stored in bbuuzzb tables. Each table is a year's worth of data and this program allows you to see the data one month at a time.

As yearend approaches, you need to manually create next year's bbuuzzb table. The table names have the convention of:

       schedule.nnnn

Where nnnn is the year.

Each time monthly events are listed, they will be displayed in the following form:

       c:mmdd.s desc,cat,pl,plb,act,actp

Where the c is a list event count, mmdd are the month and day of the event, s is the day sequence count (since there may be more than one event per day), des is the event description, cat is the event category (see below), pl is the planned amount, plb is the current planned balance, act is the actual amount spent and actp is the current actual account balance. The balances are as at after the event has taken place.

This program depends on a category table which you need to set up. Every event will belong to one of these categories. The name of the category table must be schedule.category. The field layout of this category table is as follows:

       Field Number  Description
       ===== ======  ===========

          1          category number (sequential count)
          2          category description
          3          category type number (see below)

Each category entry has a type which tells this program what to do with all the events that belong to this type. Here are the category event type numbers and descriptions:

       Category Type Number  Description
       ======== ==== ======  ===========

          1                  credit
          2                  debit
          3                  na (reminder)

You must use the category type number in field 3 of the category record (see above).

This program also uses its own temporary table called schedule.tmp. This table must also already exist.

At least one category must represent the opening balance for that month. Each schedule month must contain one open balance record. At the moment, the open balance category number is hard-coded at six(6). When you create your category table, make sure that the open balance record is category number six(6). In a future version of this program, I will make the open balance and it's category number more flexible.

Goto Top | Future Lab Home | Contact Webmaster | Feedback

Copyright © 2008 Future Lab, Last Aug 31, 2008