Version 2.0 Copyright (c) 1982 Comshare Target Software, Inc.ADDSUB MUL DIVAVECUMMINMAXBEG"IN1$BYE&END(FIN*QUI,STO-COM/CO12CAL5COP5DEL8COL:CON?CREADIRCDISEDS1GDRIIERAKEXPMINTOLN QFUNSFORUGLOXDCL[EDI]ED1aHEAeINShIF/kINPnIMMqLOCsLINvGROzGOT|DEF~DECDAT‚LAB…LOGˆLES‹LIMMODMEN“PRI˜NUMNPV¡OVE¤OPE¥HEI¨RECªREP¬PR1°RPL´REF·REL»SYM¼SCR¿SPLÁSUMÄSAVÅNAMÈSKIËUNDÍSIZÎWIDÐHELÒSIG×endÙ TARGET Business Planning System ******************** TARGET Business Planning System * * TARGET Business Planning System * Target * TARGET Business Planning System * PlannerCalc * TARGET Business Planning System * * TARGET Business Planning System * * TARGET Business Planning System * * TARGET Business Planning System * * TARGET Business Planning System * * TARGET Business Planning System ******************** To begin, press ESCape. For help, press the HELP key. ][ADD Operations for lines, columns or ranges are entered with the symbols + (for addition), - (for subtraction), * (for multiplication) or / (for division). Use parentheses to enclose operations you wish calculated first. ex. (LINE 1 / .4) - (LINE 3/6) ][SUB Operations for lines, columns or ranges are entered with the symbols + (for addition), - (for subtraction), * (for multiplication) or / (for division). Use parentheses to enclose operations you wish calculated first. ex. (LINE 1 / .4) - (LINE 3/6) ][MUL Operations for lines, columns or ranges are entered with the symbols + (for addition), - (for subtraction), * (for multiplication) or / (for division). Use parentheses to enclose operations you wish calculated first. ex® (LINÅ ± ¯ .4© - (LINÅ 3/6) ][DIV Operations for lines, columns or ranges are entered with the symbols + (for addition), - (for subtraction), * (for multiplication) or / (for division). Use parentheses to enclose operations you wish calculated first. ex. (LINE 1 / .4) - (LINE 3/6) ][AVE The AVE function calcs a running average of values up to the present column. SYNTAX: LINE 7 AVERAGE = AVE SALES The CUM function sums all line or column values inclusive of the present line or column. SYNTAX: LINE 7 TOTAL = CUM SALES The MIN function finds the running minimum value of a line and places the current value in every column. SYNTAX: LINE 6 MIN'SALES = MIN LINE 1 The MAX function finds the running maximum value of a line and places the current value in every column. SYNTAX: LINE 7 MAX'SALES = MAX LINE 1 ][CUM The AVE function calcs a running average of values up to the present column. SYNTAX: LINE 7 AVERAGE = AVE SALES The CUM function sums all line or column values inclusive of the present line or column. SYNTAX: LINE 7 TOTAL = CUM SALES The MIN function finds the running minimum value of a line and places the current value in every column. SYNTAX: LINE 6 MIN'SALES = MIN LINE 1 The MAX function finds the running maximum value of a line and places the current value in every column. SYNTAX: LINE 7 MAX'SALES = MAX LINE 1 ][MIN The AVE function calcs a running average of values up to the present column. SYNTAX: LINE 7 AVERAGE = AVE SALES The CUM function sums all line or column values inclusive of the present line or column. SYNTAX: LINE 7 TOTAL = CUM SALES The MIN function finds the running minimum value of a line and places the current value in every column. SYNTAX: LINE 6 MIN'SALES = MIN LINE 1 The MAX function finds the running maximum value of a line and places the current value in every column. SYNTAX: LINE 7 MAX'SALES = MAX LINE 1 ][MAX The AVE function calcs a running average of values up to the present column. SYNTAX: LINE 7 AVERAGE = AVE SALES The CUM function sums all line or column values inclusive of the present line or column. SYNTAX: LINE 7 TOTAL = CUM SALES The MIN function finds the running minimum value of a line and places the current value in every column. SYNTAX: LINE 6 MIN'SALES = MIN LINE 1 The MAX function finds the running maximum value of a line and places the current value in every column. SYNTAX: LINE 7 MAX'SALES = MAX LINE 1 ][BEG To begin PlannerCalc from the copyright screen, ESCAPE to produce an empty matrix screen and enter Command Mode. To begin a new model while working in PC, SAVE the present model, type CREATE and in response to the warning, again. ][IN1 To begin PlannerCalc from the copyright screen, ESCAPE to produce an empty matrix screen and enter Command Mode. To begin a new model while working in PC, SAVE the present model, type CREATE and in response to the warning, again. ][BYE To exit PlannerCalc and remove disks safely, type: BYE and in response to the warning, again. The word END, FINISH or QUIT can be used in place of BYE. The word STOP also can be used but does not warn you to save. ][END To exit PlannerCalc and remove disks safely, type: BYE and in response to the warning, again. The word END, FINISH or QUIT can be used in place of BYE. The word STOP also can be used but does not warn you to save. ][FIN To exit PlannerCalc and remove disks safely, type: BYE and in response to the warning, again. The word END, FINISH or QUIT can be used in place of BYE. The word STOP also can be used but does not warn you to save. ][QUI To exit PlannerCalc and remove disks safely, type: BYE and in response to the warning, again. The word END, FINISH or QUIT can be used in place of BYE. The word STOP also can be used but does not warn you to save. ][STO To exit PlannerCalc and remove disks safely, type: BYE and in response to the warning, again. The word END, FINISH or QUIT can be used in place of BYE. The word STOP also can be used but does not warn you to save. ][COM Enter Command Mode at any time by pressing ESCAPE (twice if needed.) A ? always displays in the cursor line during Command Mode. From Command Mode, to enter Display press EXECUTE. From Command Mode, to enter Edit type: EDIT line'or'column'or'heading or press EXECUTE . HELP is available for all leading command words. ][CO1 Enter Command Mode at any time by pressing ESCAPE (twice if needed.) A ? always displays in the cursor line during Command Mode. From Command Mode, to enter Display press EXECUTE. From Command Mode, to enter Edit type: EDIT line'or'column'or'heading or press EXECUTE . HELP is available for all leading command words. ][CAL CALculate calculates a model from Deferred Mode and updates the screen. ][COP COPY line/col or col/line TO col/line number duplicates a line or column - label, data and logic - into a new position. Note: The destination must be referred to by line number or column number. Ex: COPY LINE 3 TO LINE 7 COPY COLUMN 1 TO COLUMN 5 DELETE LINE 3 ][DEL COPY line/col or col/line TO col/line number duplicates a line or column - label, data and logic - into a new position. Note: The destination must be referred to by line number or column number. Ex: COPY LINE 3 TO LINE 7 COPY COLUMN 1 TO COLUMN 5 DELETE LINE 3 ][COL Column HELP can be accessed with one of the following HELP commands followed by a COPY GOTO OPERATIONS CONDITIONS GROW BY OVERWRITE DCL (Discontinuous Logic) HEIRARCHY PRINT DECIMALS LABELS REFERENCING DEFAULTS LIMITS SCROLLING FORMATS LOGIC SIZE FUNCTIONS NUMBERS WIDTH ][CON Conditions use the symbols > (greater than), < (less than), = (equal to) and <> (not equal to). SYNTAX: IF test THEN result or IF test THEN result ELSE alternative Ex. IF LINE 4 >= SALES THEN SALES - EXPENSES IF SALES < (LINE 1 - LINE 2) THEN (LINE 3 - SALES ) ELSE 0 ][CRE If you are viewing a model and wish to begin a new one, SAVE the present model, type: CREATE , and in response to the warning again. If you forgot to SAVE and want to, press any key except in response to the warning. This returns you to Command Mode. ][DIR To access a list of models on the designated data drive, type: DIRECTORY . To access a list of models on another drive, type: DIR letter: . In both cases, ESCAPE to return to your last position. ][DIS From Command Mode, EXECUTE places you in Display Mode. You then can move the locator using cursor controls or T,B,U,D,R, and L keys. To split (or unsplit) the screen at the locator, press V (vertical), H (horizontal) or O (off). ][DS1 From Command Mode, EXECUTE places you in Display Mode. You then can move the locator using cursor controls or T,B,U,D,R, and L keys. To split (or unsplit) the screen at the locator, press V (vertical), H (horizontal) or O (off). ][DRI To designate a drive other than the logged drive for model storage, enter: DRIVE = letter at any time from Command Mode. ERASE model allows you to erase a model from the active drive. ERASE letter:model allows you to erase a model on another drive. ][ERA To designate a drive other than the logged drive for model storage, enter: DRIVE = letter at any time from Command Mode. ERASE model allows you to erase a model from the active drive. ERASE letter:model allows you to erase a model on another drive. ][EXP EXPonential calculates the power of e. Ex. LINE 10 PROJECTION = EXP LINE 1 INTeger truncates a value's decimal positions. Ex. LINE 4 MAINT'PERS = INT (OTH'EMPLYS / 25) LN calculates the natural log of a value Ex. LINE 10 PROJECTION = LN SALES [-1 COL] ][INT EXPonential calculates the power of e. Ex. LINE 10 PROJECTION = EXP LINE 1 INTeger truncates a value's decimal positions. Ex. LINE 4 MAINT'PERS = INT (OTH'EMPLYS / 25) LN calculates the natural log of a value Ex. LINE 10 PROJECTION = LN SALES [-1 COL] ][LN EXPonential calculates the power of e. Ex. LINE 10 PROJECTION = EXP LINE 1 INTeger truncates a value's decimal positions. Ex. LINE 4 MAINT'PERS = INT (OTH'EMPLYS / 25) LN calculates the natural log of a value Ex. LINE 10 PROJECTION = LN SALES [-1 COL] ][FUN Function HELP is available by entering the first three characters of any of the following categories and pressing SUM OF, LESSER OR (GREATER OF), MIN, MAX, AVE, CUM, GROW BY, INPUT, LN, EXP, INT ][FOR Formats include: Underlining (lines). SYNTAX: UNDERLINE REVENUE Skipped line. SYNTAX: SKIP 3 AFTER LINE 10 Symbols, (% and $) SYNTAX: SHOW = $, ( or SHOW = %( Use the DELETE command to delete underlining and skips. Use the command: SHOW = to delete symbols. ][GLO Formats include: Underlining (lines). SYNTAX: UNDERLINE REVENUE Skipped line. SYNTAX: SKIP 3 AFTER LINE 10 Synbols, (% and $) SYNTAX: SHOW = $, ( or SHOW = %( Use the DELETE command to delete underlining and skips. Use the command: SHOW = to delete symbols. ][DCL Discontinuous logic allows you to enter lines using combinations of data and logic. Column entries are separated by commas. Ex. LINE 5 TOTAL = 100, CUM SALES FOR 3, LINE 2 * .7, 150 FOR 5, MAX LINE 2 Ex. COLUMN 4 TOTALS = SUM OF COLUMN 1 THRU COLUMN 3 FROM LINE 1 THRU LINE 5, SUM OF COLUMN 1 THRU COLUMN 2 FROM LINE 6 THRU LINE 9 ][EDI From Command, EXECUTE, locate the cell to be edited and , or enter: EDIT label to position the locator into the line or column, put the entry into the status line and move into Edit Mode. Edit Mode allows you to delete, insert, and replace characters of any entry. (Additional HELP for delete, insesrt and replace is available.) to accept the changes. ESCAPE to abort the current edit, and ESCAPE again to return to Command Mode. ][ED1 From Command, EXECUTE, locate the cell to be edited and , or enter: EDIT label to position the locator into the line or column, put the entry into the status line and move into Edit Mode. Edit Mode allows you to delete, insert, and replace characters of any entry. (Additional HELP for delete, insesrt and replace is available.) to accept the changes. ESCAPE to abort the current edit, and ESCAPE again to return to Command Mode. ][HEA Up to ten headings may be entered from Command Mode. They may be up to 80 characters in length, and display no formats. SYNTAX: Heading 1 = CENTER SUPPLY COMPANY Heading 2 = Heading 3 = ----------------------. 2. Use the space bar to move the cursor over the letter before which the insert belongs. 3. Press I. 4. Next, type the desired letters. to accept the changes; ESCAPE to abort the changes; EXECUTE to remain in EDIT Mode for additional changes. ][IF/ IF/THEN (and IF/THEN/ELSE) statements allow you to enter a test-result (- alternative result). SYNTAX: LINE 2 TAX'1 = IF LINE 1 >= 100000 THEN LINE 1 * .46 ELSE LINE 3 LINE 3 TAX'2 = IF INCOME >= 75000 THEN (INCOME - 75000) * .40 + (75000 * .30) ][INP The INPUT function is used in place of data entries in a multi-use model. When the model is calculated, answer prompts by entering a data value. SYNTAX: LINE 3 SALES = INPUT, GROW BY 15% Sample Prompt: ENTER SALES FOR COLUMN 1 Sample Response: 500 Note: use of INPUT without a following comma, may cause excessive delay of calculation and greatly increase the need to enter data. ][IMM The Immediate Mode calculates the model after every entry. The Deferred Mode, (the PC default), delays calculation until CALC is entered. To enter Immediate, type: IMMEDIATE To enter Deferred, type: DEFERRED ][LOC When the locator highlights a single cell, the command for that cell's line or column displays in the status line. To move the locator aroung the completed portion of the matrix: From Command, use a GOTO command, or press EXECUTE to enter Display. From Display, move the locator using cursor controls or the keys R,L,U,D,T, and B. (This may screen and scroll the display.) Then to enter Edit or ESCAPE to enter Command. ][LIN Line HELP can be accessed with one of the following HELP commands followed by a COPY GOTO OPERATIONS CONDITION GROW BY OVERWRITE DCL (Discontinuous Logic) HEIRARCHY PRINT DECIMALS LABELS REFERENCING DEFAULTS LIMITS SCROLLING FORMATS LOGIC SIZE FUNCTIONS NUMBERS WIDTH ][GRO The GROW BY function increases a seed value by a percentage or arithmetic growth rate. SYNTAX: LINE 4 WAGES = 4.00,GROW BY 12% LINE 1 SALES = GROW 100 BY 25 LINE 7 PROJECTION = 100,200, GROW 200 BY 25% FOR 3, 500 ][GOT From Command Mode, GOTO label moves the locator to the desired line, column or heading -- scrolling and screening the display if needed. SYNTAX: GOTO LINE 5 GOTO SALES ][DEF Defaults for PlannerCalc pertain to: a) the number of columns: SIZE = 5 b) the number of decimals used: DECIMALS = 0 c) the number of characters per column: WIDTH = 8 All may be changed using the syntax: SIZE = 15 The command: PRINT DEFAULTS from Command Mode, places you on the Print Menu, replacing your last report's specs with specs based on the total model. ][DEC Decimal positions for print and display range from 0 (default) to 28. To change the number of decimal places shown, do the following: SYNTAX: DECIMALS = 2 ][DAT DATE = 10/chars allows you to enter up to ten characters to be used as a date on your model. The date appears on printouts only. Enter it any time from Command Mode. DATA can be entered after an = following a line number or label. Separate items with commas to avoid unwanted replication of a value in many columns. LINE 5 SALES = 25, 50 FOR 2, 35, 37, ][LAB LABELS are line/column names placed after the line/column number but before the equal sign. They are limited to 12 characters. Use apostrophes to indicate spaces or to begin with a numeral. All labels should be unique to avoid overwriting. Ex. LINE 1 SALES'PROJECT = COLUMN 4 '1982 = Column labels wider than column width truncate. ][LOG LOGIC is the formula used to enter a line/column. It can be a single statement or a series. Commas separate the values for columns. Ex. LINE 4 MARGIN = LINE 1 - (LINE 2 + LINE 3) LINE 7 ADJUSTMENTS = 100, LINE 3 * 2 FOR 3, 700, INPUT FOR 2, GROW SALES BY 10% COLUMN 5 YEAR = SUM OF FALL'81 THRU SPRING'82 ][LES LESSER OF (GREATER OF) compares two values by line or column , placing the lesser of (greater of) the values in the appropriate column. SYNTAX: LINE 13 TAXES = GREATER OF 0 OR (.48 * GROSS'PROFIT) ][LIM PlannerCalc maintains the following limits: Numbers Characters Lines 512 80 Columns 128 30 Headings 10 80 Decimals 28 Labels 12 Model Names 8 ][MOD You may enter Command Mode at any time by pressing ESCAPE once or twice. Modes in PlannerCalc are accessed from Command Mode the following ways: Edit -- EXECUTE or EDIT label Print -- PRINT Display -- EXECUTE HELP -- Pressing the HELP key or HELP 3-characters DIRECTORY -- DIRECTORY ][MEN Type: PRINT to produce a Print Menu. Report specifications have the following defaults: 1.HEADINGS ON (The option is OFF). 2.BEGINNING LINE 1.0 (or your model's first line) 3.ENDING LINE 512.0 (or your model's last line) 4.COLUMNS 1-128 (or your model's first thru last columns) 5.RESULTS ON (Prints the matrix form. The option is OFF.) 6.WORKSHEET OFF (Prints the command file. The option is ON.) 7.COLUMNS PER PAGE (Prints as many as column-width permits.) More HELP is available under REPORT or RESULTS. ][PRI Type: PRINT to produce a Print Menu. Report specifications have the following defaults: 1.HEADINGS ON (The option is OFF). 2.BEGINNING LINE 1.0 (or your model's first line) 3.ENDING LINE 512.0 (or your model's last line) 4.COLUMNS 1-128 (or your models first thru last columns) 5.RESULTS ON (Prints the matrix form. The option is OFF.) 6.WORKSHEET OFF (Prints the command file. The option is ON.) 7.COLUMNS PER PAGE (Prints as many as column-width permits.) More HELP is available under REPORT or RESULTS. ][NUM Heading and column numbers must be integers. Headings are limited to 10; columns to 128. Lines range from 1.0 to 512.0, allowing one decimal position in the number. When entering data, separate numbers with commas. Numbers without commas replicate into all remaining columns. Ex. LINE 1 SALES = 10,20,30,40 Ex. LINE 1 SALES = 10 Negative numbers must be preceeded by a space and entered without a space between the negative symbol (-) and the number. ][NPV NPV, the net present value function, calculates the difference between the present value of costs against the present value of cashflow at a specified percentage rate. SYNTAX: LINE 6 NPV - NPV OF LINE 1 AGAINST LINE 2 AT 10% A column range can be specified also: SYNTAX: LINE 6 NPV = NPV OF LINE 1 AGAINST LINE 2 FROM COLUMN 1 TO COLUMN 6 AT 10% ][OVE To overwrite a command, retype the command using the same heading, line or column number. To overwrite a model, save the new model under the name of the old model. ][OPE Line and column operations include: Negatives -1 Exponentiation 2**3 (two cubed) Multiplication 4*5 Division 6/7 Addition 8+9 Subtraction 10-11 Natural Log LN 1213 Power of e EXP 14156 In all cases, labels can take the place of numbers. ][HEI Calculations process from first to last in this order: First (highest) 1. Data with preceding # 2. Line logic with preceding # 3. Column logic 4. Line data 5. Line logic Underlines process before skips. ][REC RECALL from Command Mode permits you to recall any model saved earlier on any disk. SYNTAX: RECALL STANDARD (For the designated data drive) RECALL B:PROJECT (For other drive) ][REP Reports are developed from the Print Menu after you enter: PRINT Menu defaults (SEE HELP MENU) can be changed at that time. 1. Move the cursor to the appropriate line and . 2. Replace the value using edit procedures and . There is a limit of 12 intervals (11 commas) you may enter for columns. EXECUTE to begin printing; ESCAPE to pause printing; ESCAPE ESCAPE to abort printing and return to Command Mode. To return to the model type: RESULTS ][PR1 Reports are developed from the Print Menu after you enter: PRINT Menu defaults (SEE HELP MENU) can be changed at that time. 1. Move the cursor to the appropriate line and . 2. Replace the value using edit procedures and . There is a limit of 12 intervals (11 commas) you may enter for columns. EXECUTE to begin printing; ESCAPE to pause printing; ESCAPE ESCAPE to abort printing and return to Command Mode. To return to the model type: RESULTS ][RPL You can replace characters in a command from Edit Mode. From Command Mode, enter Edit by typing: EDIT label In the cursor line, space-bar the cursor to the first letter to be replaced. Press R and type the new letters. If you replace to the end of the line, you automatically enter INSERT. to accept the changes and return to Display; ESCAPE to abort. ][REF Referencing is available for specific columns. SYNTAX: LINE 2 EXPENSES = SALES [-2 COL] * .5 (This takes the value for sales from the column two previous to the current column.) SYNTAX: LINE 2 EXPENSES = SALES [2 COL] * .5 (This takes the constant value for sales from the second column.) SYNTAX: LINE 2 EXPENSES = SALES [+2 COL] * .5 (This takes the value for sales from the column two ahead of the current column.) ][REL Relabel replaces a line or column name. SYNTAX: RELABEL SALES AS REVENUE RELABEL COLUMN 5 AS TOTAL ][SYM Symbols that appear on the screen mean the following: ? (in the cursor line) You are in Command Mode # (in a cell) An undefined or incalculable value was used in calculating. * (in a cell) A value is too large for the column width. ! (in a cell) Command in error ( 10/0 ) (in the status line) Press the carriage return to continue. ][SCR Screening (horizontal) and scrolling (vertical) roll the display. In Command Mode, use GOTO line or GOTO column . In Display Mode, use cursor controls; or U,D,T,B,T, and R keys preceded by a number. ][SPL Screen splits can be used horizontally (below the locator) or vertically (to the right of the locator). In Command Mode, enter: SPLIT V or SPLIT H . Remove the splits with: SPLIT OFF . In Display Mode, press the V or H key. Remove with the O key. ][SUM The SUM OF function adds a range of lines or columns. SYNTAX: LINE 6 TOT'EXPENSES = SUM OF LINE 2 THRU LINE 5 SYNTAX: COLUMN 5 YEAR = SUM OF COLUMN 1 THRU COLUMN 4 ][SAV The SAVE command lets you name and store a model on a specific disk. SYNTAX: SAVE NAME saves on the logged drive or data disk drive SAVE B:NAME saves on an alternate drive Model names are limited to 8 letters without apostrophes. A model saved with the same name as a stored model overwrites and erases the first model. ][NAM The SAVE command lets yo name and store a model on a specific disk. SYNTAX: SAVE NAME saves on the logged drive or data disk drive SAVE B:NAME saves on an alternate drive Model names are limited to 8 letters without apostrophes. A model save with the same name as a stored model overwrites and erases the first model. ][SKI Underline and skip are line formats. SYNTAX: UNDERLINE EXPENSES DELETE UNDERLINE AFTER LINE 5 SYNTAX: SKIP 6 AFTER SALES DELETE SKIP AFTER LINE 1 Underlines process before skips. ][UND Underline and skip are line formats. SYNTAX: UNDERLINE EXPENSES DELETE UNDERLINE AFTER LINE 5 SYNTAX: SKIP 6 AFTER SALES DELETE SKIP AFTER LINE 1 Underlines process before skips. ][SIZ SIZE refers to the number of columns. The default is 5; the limit is 128. To change the value use the SYNTAX: SIZE = 12 If decreasing size, in response to the warning in the status line. ][WID WIDTH refers to the number of characters per column. The default is 8; the limit is 30. Format symbols (-(,%$) are included in this limit. To change the value use the SYNTAX: WIDTH = 15 or WIDTH FOR COLUMN 5 = 15 ][HEL HELP is available any time you press the HELP key; or enter the first three letters of a command word or one of the key words below and press . Every command and key word has an accessible HELP screen. KEY WORDS Beginning Global Logic Heirarchy Columns Headings Menu-Print Referencing DCL (dsct. logic) Labels Modes Report, printing Defaults Limits Numbers, negatives Screening/scrolling Formats Lines Operations Symbols Functions Locator Overwriting Print ][SIG Significance is the number of digits the system recognizes and stores for calculation. The default is 8, and the acceptable range is 2 thru 10. Change the default with the SYNTAX: SIG = 10 ][end 5/11/82