Monster Media 1994 #1/monster.zip/monster/FINANCE/TPSBUD.ZIP/TPSBUD.TU_/TPSBUD.TU

Text File | 1994-01-04 | 10KB | 193 lines

Page 1

                         TPSBUD TUTORIAL

In order to follow this tutorial you should send this file to the
printer. Make sure your printer is on and on line then select the
Print button.

TPSBUD is a Grid (same as a spreadsheet). Each row of the Grid
has 14 columns. The first column is for Category Names. A
Category can be either an Expense or Income. You have room for 45
Expense Categories and 5 Income Categories. The 2nd through the
13th columns are named for the months of the year Jan - Dec. The
months of the year appear in the top row of the grid. You will
notice that the top row of the grid is gray. You cannot enter any
information in this row, it is called a fixed row. Also notice
the first column is also gray. You can enter Category names in
this row but, you have to use the Add Category Function. The 14th
column is a Total column. By selecting the Category Total
Function the total for each Catagory for the year will appear in
this column. The 46th row is also a Total column but, it totals
the month of the year. The last column in the 46th row is a Grand
Total Column. It tell you the total amount you spent on each
Category for the entire year.

Starting on the 48th row you have 5 rows to enter incomes. They
are named and total exactly as the Expense rows above. Each
sectioned off area is called a cell. In order to enter a value
into a cell you must first select the cell. You select the cell
by pointing to the cell with the mouse and clicking the left
button.

At the top left side of the screen you will see what looks like a
calculator. In fact we will refer to it as the calculator screen.
There are 11 buttons that you can click with a mouse to enter a
value in the screen, 0-9 and . (period). Beneath the 11 buttons
you will see 3 additional buttons. Once you have the amount
showing in the calculator screen that you want clicking the Add
To button will add that amount to whatever cell you have
selected. Clicking the Subtract From button will subtract the
amount from the selected cell. Clear Entry will clear the
calculator screen if you enter a value that is incorrect.

Those are the basics. We will now create a dummy .BUD file where
you will use each function of the Pull Down Menus.

If you haven't already load TPSBUD. You can do this from Program
Manager if you already have Windows loaded by selecting the
TPSBUD program group icon, Or from DOS from the TPSBUD directory
simply type TPSBUD    [Enter]. Windows will be loaded
automatically then TPSBUD will be loaded into Windows.

!
Page 2

When TPSBUD first loads you will have a blank Grid. If you look
in the bottom right hand info area you will see that the name of
the current file is UNTITLED. If you try to Open a file or create
a New file you will first be asked if you want to save the
current file. This may seem a bit annoying at first but it is
better to be asked to save your current file rather than loose
everything you have entered into it.

Before we start there are 2 ways to open a Pull Down Menu. You
can click on the Menu Bar the window you want to Open or press
ALT and the underlined letter of the Pull Down Window selection.
To open the File Menu either click File or press ALT-F.

Open the File Menu. Select Add Category Expense (you could also
have used the hot key CTRL-A). A dialog box will open. You can
type in up to 13 letters for a Category name. In the dialog box
type in       Mortgage      then select OK. You will see Mortgage
appear in the 2nd row first column of the Grid. This is an
Expense Category. Now press CTRL-A to open the Add Expense
Category dialog box once again. Type in     Electric     then
select OK. Now add a third Expense Category    Telephone. You
should now have 3 Expense Categories showing on the Grid's first
column.

Now we are going to add an Income Category. Open the File Menu
and select Add Category (Income) or press the hot key F2. In the
dialog box type in      My Job      select OK. Even though you
can't see the Income Category   "My Job"  it is there in the 48th
row of the Grid. Either use the Vertical elevator button or use
your PgDn key to move to the bottom of the Grid. You should now
be able to see the Income Category  "My Job". Notice you did not
have to select a row to enter an Expense or Income Category.
TPSBUD automatically selects the next available row for either
Category. Now we are going to add some values to the Categories.

If you are still at the bottom of the Grid move to the top with
the Vertical Elevator button or use the PgUp key. Select the
first cell in the Mortgage row. That is the cell under Jan. Once
the highlight appears in the cell use the mouse to enter the
following value in the calculator screen.

Click 2   Click 0   Click 0   Click .   Click 0   Click 0
The value 200.00 should now appear in the calculator screen
window. There is another way to enter values. You can type them
in from the keyboard. From now on when you are instructed to
enter value in the calculator screen use whichever method you
prefer.

This Expense category Mortgage is an expense that remains
constant throughout the year. Open the Options Menu and select
Fill Row (hot key CTRL-I). You will now see that 200.00 fills the
entire row of the Mortgage Category. Use the Horz. scroll bar or
use the right arrow key to scroll through the months of the year.
Fill Row is the fast way to enter a constant amount in any
Category row. ! Page 3

Move back to the left side of the Grid (so you see Jan Feb etc.
showing in the first row).

Select Electric's Jan cell. Enter the value 100.50 in the
calculator. Now click the Add To button. You will see 100.50
appear in the Jan cell of Electric. Wait a minute we made a
mistake Jan's electric bill was only 90.50 we entered to much.
Make sure the Jan cell of Electric is still selected. Enter 10.00
in the calculator screen. Now click Subtract From. The amount in
then Jan cell of Electric should be 90.50. As you can see if you
make an error you can correct it in any cell of the Grid.

We are now going to add another Expense Category. Press CTRL-A
then type    House Ins    in the dialog box then select OK. Our
house Insurance is paid quarterly. Click (select) the Jan cell of
House Ins. Enter the value 51.25 in the calculator screen. Now
click Add To. 51.25 should appear in the Jan cell of House Ins
Category. Use the right arrow key to move the highlight box over
to the Apr cell then open the Options Menu and select Duplicate
(hot key CTRL-D). Do the same in the Jun and Oct cells of House
Ins.  The Duplicate key is very handy for instances like this
where the value is the same but, it does not occur every month of
the year. Duplicate inserts whatever amount was the last to
appear in the calculator screen.

Select the Jan cell of the Telephone Category. Enter the value
28.56 to the cell. Open the Options Menu and select Erase (hot
key CTRL-R). Use this function when you want to clear a value
from a Grid Cell. In fact we are going to remove our Telephone
Category from the Grid (who really needs a phone anyway).

Select any cell in the Telephone Category. Open the File Menu and
select Remove Category (Expense). You will receive a warning
message the if you proceed the Telephone Category and all of it's
values will be removed. Select Yes. After a few seconds you will
see the Telephone Category disappear and the House Taxes Category
move up to fill the gap.

Scroll down to the Income Category  My Job and enter the
following amount 2150.45 in the calculator screen. Select any
cell in the My Job category. Use Fill Row to fill the entire year
with this amount (we are retired and receive the same amount each
month).

Scroll back up to the top of the Grid and enter some more amounts
in the Expense category Electric. When you are finished adding
amounts we will get some totals. ! Page 4

There are 3 different totals, Monthly  -  Category  -  Grand
Total. Open the Options Menu select Category Total. Scroll to the
right end of the Grid. You will see the totals for all the
Categories. Scroll to the bottom of the Grid. Open the Options
Menu and select Monthly Totals. You should now see a total for
each month appear. Open the Options Menu and select Grand Total.
you should now see a Grand total appear in the 47th row last cell
also in the last cell of the last row (Income Categories).

The only other functions we have not use is under the File Menu
Open  -  New  -  Save  -  Print. open the File Menu and select
Save. Give the file the name Test and click OK. Now open the File
Menu again and select New. The Grid should clear. Open the file
Menu again and select Open. When the dialog box appears click
TEST.BUD and select OK (you can also double click the .BUD file
that you want to open). You should now see the .BUD file we just
created. Make sure your printer is on and on line. From the File
Menu select Print. You will now receive a printout of our
TEST.BUD Grid.

The Help Menu is a quick summary of the functions under the File
and Options Menus. Just click the function button for which you
need help. The Documentation Menu contains the TPSBUD.DOC
README.NOW & TPSBUD.TUT. You can read/print any of these files
from TPSBUD.

That should get you up and running with TPSBUD. I have a few
ideas for improvements in the future but, as with any shareware
program it all depends on how well it is accepted by you the
user.

End Of Tutorial:
!