⟦013c7582c⟧

TextFile

..Lesson 6 - Consolidation of Worksheets
..Screen 1
..
Copy the two Worksheet Definition Instructions (3000 and 3010)
from your Primer :
!1
? ü@01##300Defåine ø åWoråksheet ø å`1(East)2(West)3(North)4(South)
NOHave another look at your Primer, Instruction 3000.
? ü@02##301Defåine ø øåWoråksheet ø å`10(Total)
NOHave another look at your Primer, Instruction 3010.
!1
Now Instruction 6000 from your Primer.
!1
? ü@03##600Woråksheet ø å`10=sumå of ø åWoråksheet ø å1 to åWoråksheet ø å4
NOLook more closely at your Primer.
!1
Continue with Instructions 6500 to 6700.
!1
? ü@04##650Woråksheet ø å`900=Woråksheet ø å`100+Woråksheet ø å`105-Woråksheet ø å10
NO
? ü@05##660Woråksheet ø å`25=Woråksheet ø å`20/Woråksheet ø å10
NO
? ü@06##670Woråksheet ø å`500=Woråksheet ø å`3*Woråksheet ø å`30+Woråksheet ø å100
NO
!1
And finally Instruction 6750.
!1
? ü@07##675Woråksheet ø å`300=Woråksheet ø å`200+Woråksheet ø å`201*1.15
NO
Ø
..Screen 2
..
LIST the Stored Instructions shown in your Primer.
!1
? üListøLisøL
NOUse the LIST Command
  1000 Columns Actual Budget Variance
  2000 Rows Payroll Taxes Other Total TPC(Taxes %)
  3000 Define Worksheet 1(Production) Wor 2(Distribution)
  3010 Define Wor 10(Total)
  5000 Total = sum of Payroll to Other
  501▶b0◀ TP▶c3◀ ▶bd◀ Taxes ▶af◀ Payrol▶ec◀ ▶aa◀ 10▶b0◀ ▶bb◀ Taxes as ▶a5◀ o▶e6◀ Payroll
  5020 Variance = Budget - Actual % Budget ; % Variance
  5050 Consider Variance
  5060 TPC = NA
  5150 Wor 10 = Wor 1 + Wor 2
? 
Ø
..Screen 3
..
Now calculate the Project.
!1
? üCalculateøCaløC
NOTry CALCULATE.
ØP2201!1Checking Row, Column and Worksheet Definitions
!1ØP22501000
!1ØP22002000
!1ØP22003000
!1ØP22003010
!1ØP22005000
ØP2201:!2Checking Calculation Section
!1ØP22305000
!1ØP22005010
!1ØP22005020
!1ØP22005050
!1ØP22005060
!1ØP22005150
Ø
..Screen 4
..
!2Calculating
!2For Actual and Budget, 2 numbers per line
Payroll? ü5050 5000
Taxes? ü900 1000
Other? ü500 500ø500...ø500..
Ø
..Screen 5
..
 < < Cursor Movement > >  ø   < < Screen Options > >   ø < < Formatting > >
æ^S Left  ^D or <CR> Right ø HELP WIN shows this menu   ø ^P = Precision
æ^E Up    ^X         Down  ø HELP OFF cancels this menu ø ^W = Column Width
æ^Z first Col of next Row  ø WIN OFF will scroll screen ø <ESC> exits ^P/^W
æTAB/^I MOVE to Row/Column ø WIN restores last Window   ø  and  cancels input
Project VARANC                                                     Worksheet 1
          ACTUAL   BUDGET  VARIANCE
PAYROLL> 5050.00< 5000.00     -1.00
TAXES     900.00  1000.00     10.00
OTHER     500.00   500.00      0.00
TOTAL    6450.00  6500.00      0.77
TPC        17.82    20.00        NA
ØP1701? 
Ø
..Screen 6
..
Now proceed to Worksheet 2, and Calculate again.
!1
? üConåsider ø åWorksheetøWorå 2
NOWhich Worksheet do you want to CONSIDER?
Creating new Worksheet from which old Worksheet number ? ü<CR>
NOCarriage Return will set up a new Worksheet.
!1? üCalculateøCaløC
NOIssue the CALCULATE Command.
!1Calculating
!2For Actual and Budget, 2 numbers per line
Payroll? ü6350 6500
Taxes? ü1200 1300
Other? ü1500 1000
Ø
..Screen 7
..
 < < Cursor Movement > >  ø   < < Screen Options > >   ø < < Formatting > >
æ^S Left  ^D or <CR> Right ø HELP WIN shows this menu   ø ^P = Precision
æ^E Up    ^X         Down  ø HELP OFF cancels this menu ø ^W = Column Width
æ^Z first Col of next Row  ø WIN OFF will scroll screen ø <ESC> exits ^P/^W
æTAB/^I MOVE to Row/Column ø WIN restores last Window   ø  and  cancels input
Project VARANC                                                     Worksheet 2
          ACTUAL   BUDGET  VARIANCE
PAYROLL> 6350.00< 6500.00      2.31
TAXES    1200.00  1300.00      7.69
OTHER    1500.00  1000.00    -50.00
TOTAL    9050.00  8800.00     -2.84
TPC        18.90    20.00        NA
!2ØP2201Now move to Worksheet 10.
!1ØP1701? üConåsider ø åWoråksheet ø å10
NOUse CONSIDER with the Worksheet number you want.
ØH
..Screen 8
..
ØP2201:ØP1701:ØP0301
 < < Cursor Movement > >  ø   < < Screen Options > >   ø < < Formatting > >
æ^S Left  ^D or <CR> Right ø HELP WIN shows this menu   ø ^P = Precision
æ^E Up    ^X         Down  ø HELP OFF cancels this menu ø ^W = Column Width
æ^Z first Col of next Row  ø WIN OFF will scroll screen ø <ESC> exits ^P/^W
æTAB/^I MOVE to Row/Column ø WIN restores last Window   ø  and  cancels input
Project VARANC                                                     Worksheet 10
          ACTUAL   BUDGET  VARIANCE
PAYROLL>    0.00<    0.00      1.31
TAXES       0.00     0.00     17.69
OTHER       0.00     0.00    -50.00
TOTAL       0.00     0.00     -2.07
TPC         0.00     0.00        NA
ØP2201:ØP1701:? 
Ø
..Screen 9
..
Copy the new Calculation Instructions.

? ü@51##510Conåsider ø åall Roåwsøw
NOLook at your Primer.
? ü@52##511Conåsider ø åall åCoålumnsølumnølsøl
NO
? ü@53##520Conåsider ø åWoråksheet ø å10
NO
? ü@54##521`BPC=åBurden ø`Burdenå`as%ofø`as%ø`%å PayrolløPayroll
NO
? ü@55##522`Variance=Budget-åActual ø`Actualå`as%ofø`as%ø`%å BudgetøBudget
NO
? ü@56##523Conåsider ø åVariance
NO
? ü@57##524`BPC=NA
NO
Ø
..Screen 10
..
And recalculate.

? üCalculateøCaløC
NOThe Command is CALCULATE.
ØP2201Checking Calculation Section
!1ØP22305000
!1ØP22005010
!1ØP22005020
!1ØP22005050
!1ØP22005060
!1ØP2200@#51
!1ØP2200@#52
!1ØP22005150
!1ØP2200@#53
!1ØP2200@#54
!1ØP2200@#55
!1ØP2200@#56
!1ØP2200@#57
ØP1701!2? Calculating
Ø
..Screen 11
..
 < < Cursor Movement > >  ø   < < Screen Options > >   ø < < Formatting > >
æ^S Left  ^D or <CR> Right ø HELP WIN shows this menu   ø ^P = Precision
æ^E Up    ^X         Down  ø HELP OFF cancels this menu ø ^W = Column Width
æ^Z first Col of next Row  ø WIN OFF will scroll screen ø <ESC> exits ^P/^W
æTAB/^I MOVE to Row/Column ø WIN restores last Window   ø  and  cancels input
Project VARANC                                                     Worksheet 10
           ACTUAL    BUDGET  VARIANCE
PAYROLL> 11400.00< 11500.00      0.87
TAXES     2100.00   2300.00      8.70
OTHER     2000.00   1500.00    -33.33
TOTAL    15500.00  15300.00     -1.31
TPC         18.42     20.00        NA
ØP1701? 
Ø
..Screen 12
..
Here are the existing Report Instructions :

  7000 Report 1
  7050 Show all
!1
Now enter the Worksheet Title Instruction.
!1
? ü@58##701Cenåter øtre ø åWoråksheet ø åtitleøtit
NOLook again at your Primer.
!1
Print the Report, using the PRINT Command :

? üPrintøPriøP
NOPRINT!
ØP2201!1Checking Report Specification
!1ØP22327000
!1ØP2232@#58
!1ØP22007050
Ø
..Screen 13
..

FINAR 5.1 : Micro Finar         Report 1


                  Total

              Actual    Budget  Variance

  Payroll   11400.00  11500.00      0.87
  Taxes      2100.00   2300.00      8.70
  Other      2000.00   1500.00    -33.33
  Total     15500.00  15300.00     -1.31
  Taxes %      18.42     20.00        NA
Ø
..Screen 14
..
List the Report Specification with the Command LIST REPORT,
change the Report Specification to put a blank line and the 
Worksheet Title at the bottom of the page.  Then print the
Report again.

? üListøLisøLå Reportsø Reportø Rep
NOUse LIST REPORTS.
  7000 Report 1
  @@58
  7050 Show all Rows
? üDeleteøDeløDå`@#58
NOUse DELETE and the Instruction number.
Number of Stored Instructions deleted : 1
? ü@59##706LineøLin
NOLook at your Primer.
? ü@60##707Lefåt ø åWoråksheet ø åtitleøtit
NO
? üPrintøPriøP
NOUse PRINT.
ØP2201!1Checking Report Specification
!1ØP22327000
!1ØP22327050
!1ØP2232@#59
!1ØP2232@#60
Ø
..Screen 15
..

FINAR 5.1 : Micro Finar         Report 1


              Actual    Budget  Variance

  Payroll   11400.00  11500.00      0.87
  Taxes      2100.00   2300.00      8.70
  Other      2000.00   1500.00    -33.33
  Total     15500.00  15300.00     -1.31
  Taxes %      18.42     20.00        NA

Total
Ø
..Screen 16
..
Enter the Instructions to SHOW several Worksheets.

? ü@10##702Shoåw ø åWoråksheet ø å1 to åWoråksheet ø å4
NOLook again.
? ü@11##703Shoåw ø åWoråksheet ø å10
NO
Ø
..Screen 17
..
ØP1123Now  try  some  examples  of your own
using   FINAR  before  proceeding  to
              Lesson 7.

«eof»
DataMuseum.dk

CP/M

⟦013c7582c⟧ TextFile

Derivation

TextFile
