Congratulations to the Class Of 2017 Jim Peterson Award Winners:

Software Category: Mike Brent(Tursi) and Rasmus Moustgaard
Hardware Category: Ralph Benzinger
Community Service Category (Tied Vote): Gregory McGill and Don O'Neil
Lifetime Acheivement:Mike Brent(Tursi), Jim Fetzner and Chris Schneider
TI99ers On-Line User Group

Navigation

Event Calendar


Summer Season
Sun Mon Tue Wed Thu Fri Sat
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30  
Normal Day: 
Event Day: 
Today: 



Member Birthdays


Month of June

06/01 - kb8kac
06/14 - Diomidis

No Birthdays Today

Forum Threads

Newest Threads
-> Call for Jim Peterso...
-> OLUG Rules
Hottest Threads
No Threads created

Latest Articles

Login

Username
Password


Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Table './ti99er00_phpf1/phpf_online' is marked as crashed and should be repairedTable './ti99er00_phpf1/phpf_online' is marked as crashed and should be repairedTable './ti99er00_phpf1/phpf_online' is marked as crashed and should be repaired

Users Online

Table './ti99er00_phpf1/phpf_online' is marked as crashed and should be repaired-> Guests Online: 0

-> Members Online: 0

-> Total Members: 100
-> Newest Member: atokie56

Shoutbox

You must login to post a message.

02/14/2017 15:48
New Themes have been added to the OLUG for members only. Check them out.

12/31/2016 17:43
Happy New Year all Smile

06/23/2016 13:08
Hi Mike, welcome Smile. There are still lots of TI99 users out there Smile

06/22/2016 15:37
Just wanted to say 'I'm glad I found you!' Pulled out my TI and have started to play with it again. I forgot how much fun it was. Wish there were more people out there still using it!

04/23/2016 08:23
Hello my fellow ti99ers, have a great weekend Smile

Member Poll

What is your age?

70 or more
70 or more
50% [4 Votes]

60-69
60-69
13% [1 Vote]

50-59
50-59
0% [0 Votes]

40-49
40-49
38% [3 Votes]

30-39
30-39
0% [0 Votes]

20-29
20-29
0% [0 Votes]

Less than 20
Less than 20
0% [0 Votes]

Votes: 8
You must login to vote.
Started: 01/18/2017

Articles Hierarchy

Multiplan Part 8 by Audrey Bucher

One of the most useful features of Multiplan is Windows. It took me a long time to try this, but once I did, I don't know how I managed without them. I think it is somewhat difficult to try to clearly explain them in an article but I'll give it a try. I suggest though that you play around with then yourself. DOING is the best way to learn.

The command I use most often is the Window Split Title command. In a spreadsheet such as our Expenses for 1988, there are Titles both in the first row and in the first column. Once you move the cell pointer past the third column or the twentieth row, you can no longer see the Titles. You can 'fix' those Titles in place.

Place the cell pointer in the column to the right of the title column and in the row beneath the row which contains your Titles. Press W for window. You will see the following Command line:

WINDOW: Split Border Close Link
You mast to split the Titles from the figures so choose Split by pressing S or Enter. Now you see:
WINDOW SPLIT: Horiz Vertical Title.

Choose T for Title. You will now be presented with two fields.

WINDOW SPLIT TITLES:# of Rows:3 # of columns:1

Notice that MP proposes the correct response for the number of rows and columns to be split so you can just press Enter. When you use the Split Titles Command the windows are automatically linked so now you may move your cell pointer wherever you wish and the Titles will always be in sight. You probably will not use the windowing for Expenses for 1988 spreadsheet as this is filled in by the Xcopy Command. I merely used it as an example of a spreadsheet that has Titles in both the Rows and Columns.

But now let's look at our Checks for January spreadsheet. We had only put sixteen rows in our example to make it short. However, I'm sure you will have more than ten entries in any given month. Notice that when you move the cell pointer down past Row 20, you will lose the Column Titles. Even though we use the GoTo Name command to get to a particular column and I trust MP completely to go to the correct column, I still like to see the Title on the screen. So for this spreadsheet, I would use the Split Horiz Command. Again, place the cell pointer beneath the row which contains your Titles (in this case, row 4). Press W for window, S for split and H for horiz. You will see the following:

WINDOW SPLIT HORIZONTAL at Row:4 linked:yes (no)

Tab over to the next field and select Y to link the windows. Now whenever you scroll one of the windows horizontally, both windows scroll together. The active window is split horizontally. The area used by the given row and the rows below it becomes the new window. The area above the given row remains part of the original window. You may move your cell pointer between windows by using Control 6 (change window), which makes a different window the active window. Control 6 again will take you back to the original window.

Let's sum up the Window Split Command. You are given three choices. Window Split Horizontal splits the active window across the screen, giving two windows, one above the other. Window Split Vertical splits the active window between columms, one to the left of the other. Window Split Titles splits the screen both vertically and horizontally to display titles in separate windows. Up to eight windows say be opened using the Window Split Commands (if you can get them to fit and still show you anything).

To close a window, simply press W for Window and C for close. You will set the following:

WINDOW CLOSE window number:n

The active window is the proposed response.

Just a few words now about the remaining commands.

Window Border will draw a line around the active window that sets it off from the surrounding worksheet. Try this command to see what a bordered window looks like. A border takes up one screen position on each side of the window, reducing the area for the display of data by two screen lines and two screen columns. To remove a border use the same commands: W and C.

Last of all, the Window Link Command. This is used to change the link status of windows that are already split. Press W for Window and L for Link. MP proposes linking the active window with the window from which it was split, so just press Enter and tab over to the third field and press Y for yes or N for no, depending on which you would like. When windows are not linked, you can scroll them separately to view different parts of the worksheet simultaneously. However note that Windows split by the Window Split Titles Command cannot be unlinked.

I hope I have not totally confused you at this point. As I said in the beginning, it's not an easy subject to describe. TRY IT, I think you'll like it and if you have any questions just give me a call.

Comments

No Comments have been Posted.

Post Comment

Please Login to Post a Comment.

Ratings

Rating is available to Members only.

Please login or register to vote.

No Ratings have been Posted.
Render time: 0.03 seconds
2,809,305 unique visits