DataMuseum.dk

top - download

    Length: 4608 (0x1200)
    Types: TextFile
    Names: »FINHLP.ENG«

└─⟦e1174326d⟧ Bits:30004298 FINAR Finans/budget
    └─ ⟦this⟧ »FINHLP.ENG« 

TextFile

                           < < Direct Commands > >
C-Calculate  ø D-Delete     ø END-End proj ø FIN-Find     ø PAGE DEPTH  
CON-Consider ø DIS-Display  ø I-Increment  ø L-List (Sys) ø PL-Plot(Sys)
CON-Continue ø DO-Autoinput ø I0-no auto # ø P-Print(Sys) ø PRO-Project 
CON WOR nnn  ø E-Edit       ø I20 - auto # ø PAGE WIDTH   ø SEN-sitivity
                            < < Help Subjects > >
HELP may be obtained by typing HELP subject, for example: HELP EDIT
CALculations      ø EDIt mode         ø PRE-defined calcs ø STOred Instrs
CONsolidations    ø FUNctions         ø REPorts           ø WINdow mode
DIRect commands   ø GRAphs            ø ROW, col & wor    ø WORksheets
                              < < Functions > >
AVErage-40 A=Ave B to C  ø MAX-97 A=Max of B and E  ø ROUnd-75 S=S Rou to 0
IN-95 X=X*Sales In Year2 ø NEGative-61 N=NV C to E  ø SUM-45 A=Sum of B to C
LASt-91 R=Last S * 0.5   ø NEXt-92 Sale=Next Sale   ø 46 Wor 8=Sum Wor 1 TO 7
MIN-32 D=Min Sales to X  ø POSitive-64 P=PV A to D
                < < Row, Column and Worksheet Definitions > >
Row and Column names may be up to 16 characters in length.  Expanded versions
may be supplied, enclosed in parentheses.  Worksheets may also be defined, and
may be given titles enclosed in parentheses.
100 Row S(Sales) Cost Profit ø 110 Col Y1 Y2 Y3 ø 200 Def Wor 1(East) 2(West)
                        < < Calculation Section > >
The Calculation Section contains Stored Instructions specifying the
calculations required to fill in Rows and Columns of the Worksheet.  Examples
of Calculation Section Stored Instructions are:   400 Profit=Sales-Costs
410 Rate=Sum of Costs / 30                        420 C=A Inflated by 10%
                         < < Graphics Section > >
The Graphics Section contains Stored Instructions defining the format and
content of up to 14 different Graphs.  Examples of Graphics Section Stored
Instructions are: 1000 Graph 1 "Sales Forecast" ø 1020 Center "Figures Approx"
                  1010 Show All Rows            ø 1030 Barchart
                          < < Report Section > >
The Report Section contains Stored Instructions defining the format and
content of up to 14 different Reports.  Examples of Report Section Stored
Instructions are: 800 Report 1 "Income Estimate" ø 820 Center "Approx" and Und
                  810 Show All                   ø 830 Decimal Places 0
 < < 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
                        < < Stored Instructions > >
Stored Instructions are divided into 4 sections: Row, Column and Worksheet
Defs, Calculation Section, Reports Section, and Graphics Section. Each Stored
Instruction is entered in response to the ?, and is stored for later use.
See HELP DIRECT COMMANDS (List, Delete); HELP EDIT
                            < < Worksheets > >
Worksheets are collections of numbers organized in Rows and Columns. Worksheets
may be numbered from 1 to 999.  All Worksheets in any one Project have the same
shape (same Rows and Columns), but may have different numbers stored in them.
Worksheets may be given titles with the DEFINE WORKSHEETS Instruction.
                           < < Consolidation > >
Worksheets may be consolidated with the SUM function in the Calculation 
Section.  Some examples of consolidations are:
450 Wor 26=Sum of Wor 1 to 25        ø 470 Wor 100=Sum of Wor 1 to 10-Wor 3
460 Wor 29=Wor 26 + Wor 27 - Wor 28  ø 480 Wor 200=Wor 100 / Wor 30 * .15
                               < < Edit > >
The Editor may be used to edit Stored Instructions or data.  Characters typed
on the ?? line affect the characters above them in the line being edited.
Use < for inserting, space or & for leaving a character unchanged, and ! for
deleting a character. Examples: EDIT 100 (Stored Instruction) EDIT Sales (Data)
                     < < Pre-defined Calculations > >
400 Rate=IRR of Cashflow         ø 440 Newcos=Cost INF by 10%
410 Answer=NPV Cashflow at 16%   ø 450 Past=Straight line FIT of Sales
420 Interest=AMO of House at 15% ø 460 Income=CUM TOTAL of Contr with Rental
430 Deduct=DEP of Asset at 200%  ø 470 Trend=MOV Sales over 4 periods
«eof»