DataMuseum.dk

top - download

    Length: 3712 (0xe80)
    Types: TextFile
    Names: »LESSON2.TXT«

└─⟦dc6c79650⟧ Bits:30004299 FINAR Tutor
    └─ ⟦this⟧ »LESSON2.TXT« 

TextFile

..Lesson 2 - Row, Column and Worksheet Definitions
..Screen 1
..
Copy the Row and Column Definitions from your Primer.
!2
? ü@01##100Colåumns øumn øs ø åY1982 Y1983 Y1984
NOCheck with your Primer.
? ü@02##200Rowås ø åUnits Sellprice Costprice
NO
? ü@04##202Rowås ø åMargin
NO
? ü@03##201Rowås ø åSales Costs
NO

!2Now LIST them.

!2? üListøLisøL
NOUse the Command LIST.
  @@01
  @@02
  @@03
  @@04
?
Ø
..Screen 2
..

Now rewrite the Row and Column Definitions, using Expanded
Versions where appropriate.

!2Firstly, the Column Instruction :

!2  @@01

? ü@1101100Colåumns øumn øs ø å`Y1(1982)Y2(1983)Y3(1984)

!2Now the Row Instruction :

!2  @@02

? ü@1202200Rowås ø åUnits SPå`(Sellingå price)å`CP(Costå price)

!2There is of course no need to change the other Instructions 
since no Expanded Versions are required.
Ø
..Screen 3
..
Here is a Report based on the Row and Column Definitions you used.
Note the Expanded Versions have been used instead of the Short Names.

For clarity they have been highlighted.

                            1982     1983     1984


æ  Units                   500.00   535.00   563.00
  Selling price        æ     1.75     1.75     1.80
  Cost price           æ      .95      .97      .97
æ  Sales                   875.00   936.25  1013.40
æ  Costs                   475.00   518.95   546.11
æ  Margin                  400.00   417.30   467.29
Ø
..Screen 4
..

Write the Row, Column and Worksheet Definitions shown in your Primer.

!1First, the Column Instruction :

? ü@51##100Colåumns øumn øs ø åActual Plan VPCå`(Varianceå %)
NOTry again.

!1Now the Row Instruction :

? ü@52##200Rowås ø åUSå`(Domesticå å`Sales)Foreign(Foreign-US$)Sales(Total-US$)
NO

!1And last, the Worksheet Instruction :

? ü@53##300Defåine ø åWoråksheet ø å1å`(Totalå Corporate Sales)
NO
Ø
..Screen 5
..
Of the four logical sections of a FINAR Project,
which is the Row, Column and Worksheet Definitions     ? üFirstø1stø1
NOCalculations, Reports and Graphs come later.

What is the Keyword telling FINAR that you want to
define some Rows                                       ? üRowsøRow
NOIn contrast to COLUMNS.

What is the Keyword telling FINAR that you want to
define some Columns                                    ? üCoålumnsølumnølsøl
NOIn contrast to ROWS.

What are the Keywords telling FINAR that you want to
give Expanded Versions to Worksheets                   ? üDefåine ø øåWoårksheetør
NO 

Which Definitions come last (Rows, Columns or
Worksheets)                                            ? üWoårksheetsørksheetørsør
NORows and Columns must be defined before Worksheets.
Ø
..Screen 6
..
Indicate with "Y" or "N" which of the following are permissible
as Short Names for Rows and Columns :

Y1                     ? üYesøY
NONothing wrong with this.

Sales%                 ? üNoøN
NOShort Names may not contain arithmetic operators.

TO                     ? üNoøN
NOThis is a Reserved Word.

Revenue                ? üYesøY
NOThis is OK.
          
Total cost             ? üNoøN
NOSpaces indicate the end of one Name and the beginning of the next.

1984                   ? üNoøN
NOShort Names must start with a letter.
Ø
..Screen 7
..
ØP0923Thi▶f3◀ i▶f3◀  th▶e5◀ en▶e4◀ ▶a0◀o▶e6◀  Lesso▶ee◀ 2▶ae◀  Try
usin▶e7◀  FINA▶d2◀  t▶ef◀ ▶a0◀creat▶e5◀ som▶e5◀  Rows,
Columns and  Worksheets of your own.
!2
Issue  the  CALCULATE  Command  when
you have  finished them.  FINAR will
tell you if you  have made any  mis-
takes.  Terminate the  session  with
          the Command END.

«eof»