Tue. March 19 2024 @
Username:    Password:   
center-left.png center-right.png
Navigation
 Main
Home
In Remembrance
TI99ers Awards (UPDATED)
TI99ers Hall of Fame
Web Links
Event Calendar
Articles
TI-99/4A Emulators
Search
News Categories
Privacy Policy
Contact Me

 Members Only
blank.gif blank.gif
Event Calendar

Summer
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
31            
Legend:
Normal: 
Event: 
Today: 
blank.gif blank.gif
Member Birthdays

Month of March

03/03 - jslicer
03/31 - harleystroker2

No Birthdays Today

blank.gif blank.gif
Forum Threads
Newest Threads
bullet.gif Call for Jim Peterso...
bullet.gif OLUG Rules
Hottest Threads
No Threads created
blank.gif blank.gif
Latest Articles
bullet.gif Nominations Closed
bullet.gif Nominations are closed
bullet.gif Multiplan Part 10 by...
bullet.gif Multiplan Part 9 by ...
bullet.gif Multiplan Part 8 by ...
blank.gif blank.gif
Articles Hierarchy
Articles Home » Multiplan by Audrey Bucher » Multiplan Part 8 by Audrey Bucher
purple-btm-left.png purple-btm-right.png
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.
purple-btm-left.png purple-btm-right.png
Comments
No Comments have been Posted.
purple-btm-left.png purple-btm-right.png
Post Comment
Please Login to Post a Comment.
purple-btm-left.png purple-btm-right.png
Ratings
Rating is available to Members only.

Please login or register to vote.

No Ratings have been Posted.
purple-btm-left.png purple-btm-right.png
Login
Username
Password


Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
blank.gif blank.gif
Users Online
bullet.gif Guests Online: 17

bullet.gif Members Online: 0

bullet.gif Total Members: 126
bullet.gif Newest Member: suberbanator
blank.gif blank.gif
Shoutbox
You must login to post a message.

December 21 2017
I wish each and everyone one a very Blessed Christmas and a prosperous New Year! Santa

December 31 2016
Happy New Year all Smile

June 23 2016
Hi Mike, welcome Smile. There are still lots of TI99 users out there Smile

June 22 2016
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!

April 23 2016
Hello my fellow ti99ers, have a great weekend Smile

blank.gif blank.gif
Member Poll
There are no polls defined.
blank.gif blank.gif
centerb-left.png centerb-right.png
center-left.png center-right.png
centerb-left.png centerb-right.png