Home

Ca1cStar User`s Manual CS-351O-1 (1.2) First Issue

1. computer prompt your response explanation edit access command directory Command S access Save command File name EXAMPLE lt CR gt choose filename that you wish contents saved under File exists y update file to include Destroy old contents the latest entries _ yn Password lt CR gt none lt CR gt no specified password 11 19 THE RECALCULATE COMMAND Next we may demonstrate one of the most useful commands of CalcStar After completing our inventory file imagine you are handed a memo saying the cost of all bolts has increased 19 Since our values for cost profit unit profit and cost order are all involved this could be catastrophic infor mation Instead of drying your tears as you erase four columns of numbers you can change one number and use one command to recalculate everything automatically The first step is to use the calculator function to compute the new cost for the 1 4 bolt On the edit line enter 110 F4 This will inform you that the new cost of the 1 4 bolt is 617 Now move the cursor to II 32 CalcStar User s Manual Operations location F4 Enter the value 17 and check to see that the new value is displayed in the window at location F4 To execute the Recalculate command duplicate the following steps computer prompt your response explanation edit access command directory Command R access Recalculate command Recalculate A ll or A we want all values to E ntry refle
2. ena ari d d hmad q mars 4 wi Aw AF ade sets special entry mode for arithmetic modification of input k k Equations may contain numeric data cell references and functions four function arithmetic may be used with any of these refers to current cell location Type one character and then move cursor to put in cell references without typing them following a cell reference holds it constant in relative copy functions include sum avg cnt abs exp log ln min max k EF Ht HF HF sqrt regr Slope proj depd ett et He He HF HF H F kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk kkkk After the first page of the Help directory you will need to hit the lt RETURN gt key in order to present the following page II 79 CalcStar User s Manual Operations KEXKEKKKKKKKEKEKKKEKEKKEKEREKEKEEKEKEKEKEKREKEKKEKEREREKEEKKEKKEKKEKKEKEKEKKEEKEREE Help page 2 Hit lt RETURN gt to continue a Extended commands these commands are accessed by hitting the key Auto enter Automatic entry mode lt ESC gt will abort Copy Copy a range entry to another range entry Delete Delete a row column entry or the whole array Edge set the window top left corner to the cursor position s Format Chanae column size or precision under cursor x Goto move cursor to a specific colum and row Help display this i
3. Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel Col gt F IG H I s 1l gt MAY lt JUNE 2 5 6 k 3 seeesssessss sms OAS 65s 1206 14498 816 66 63 55 47 e 7e 8 15190 1530 k 9 10 hence ent ee rrr eet St ne ns tere ef eee ere nr hn ssn hn er ae cursor Fl current Fl L R current type text right justified x data contents MAY z edit kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk The numerical value you see represents the mean or average value for the range of dependent values given in the regression function Sometimes this value may be useful to you to know for otlier calculations so the regression II 61 CalcStar User s Manual Operations function returns this value If you do not think you have any need for this value there is a Simple way to keep the regression function but have it return a blank value into the array For instance move the cursor to location H5 and enter regr B2 gt G2 B5 The outer quotation marks showing what to enter have been omitted to avoid confusion This expression will return a blank value in any event You may go ahead and enter this formula as we will not need to use the mean
4. II 41 CalcStar User s Manual Operations computer prompt your response explanation edit J4 lt I14 14 J4 lt CR gt IF the amount on hand J4 is less than amount stocked 14 THEN subtract J4 from I4 and enter into K4 ELSE the value at K4 will be because a false conditional statement is assigned the value of 9 edit lt TAB gt or G access Goto command goto gt Al J4 move to J4 edit 6 lt CR gt Change data entry to tell us we have 690 parts on hand edit access command directory Command R access Recalculate command Recalculate A ll E ntry A recompute results to reflect new data Now the result in K4 will show that the quantity ordered is 6 This is very helpful for us in keeping our records straight and not to try and order negative amounts of a part If you would like you may take a minute to check all the totals influenced by this change and see that they are correct Isn t that fantastic Now to check that the conditional statement works the other way enter 2128 at J4 this was our original amount and then recal culate to display our original totals Let s take a minute to describe the general format of a conditional Statement before going on to the next step The general format of a conditional statement is condition sexecutable statement if condition is true executable statement if condition is false Translating the conditional statement to English might result in the following
5. x 5 Cost of goods sold g g x 6 se naman ohare area Semmeaeres 7l Gross profit on sales g x g l eee e ee maea K 9 Operating expenses se 18 Selling expenses g g g p a ee ce cement SRA Ge Se ES ee she SS Han UR REN sesam sine emma ercemene cnene me Cursor Al current Al L R ad current type empty but allocated x data contents x x edit _ CalcStar c 1981 c o MicroPro Int l CS9999XX rv_nnn terminal type kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk The display shows only a skeletal form of HELPER in that no figures are entered on the worksheet You may enter data into each cell by moving the cursor around There is also an alternative way to enter data into the cells By using the Merge command another file such as a file containing data can be loaded on top of the existing display To use the Merge command type M CalcStar will request the filename Respond with HELP1 lt RETURN gt HELPl is another file developed very much in the same way as HELPER except HELP supplements HELPER with figures for the rows and columns A load position is requested with Al as the default Enter B1 lt RETURN gt because HELP1 was designed to load at cell Bl Again a series of dots forms at the lower left to inform you that a file is loading The result will appear as the following CalcStar User s Manual Introduction kkkkkkkkkkkkkkkkk
6. CalcStar User s Manual Operations Once you have entered a figure for the printing width the screen will be cleared before presenting the last few prompts The reason for clearing the screen is to make the display clearer and more attractive in case you are printing your report to the console instead of the printer Once the report is finished being displayed at the terminal screen the CalcStar array will be redisplayed just as it was before executing the Print command If the report you are printing out is wider than the printing width specified above CalcStar will automatically divide your report into segments The system will fit as many columns across the width of the paper that it can given the printing width you entered and then will jump down to the next page and print the next Segment This will make it very easy to paste together the segments of a wide report It also saves you from having to execute the Print command several times If the printing in segments is needed you will see the following message at this time bAi JE S JE E E E E EEFE FFER EEES ESSEE SESESSESE eeooeo4uauses eee eeaeeeeaee Report Printing Make sure printer amp paper are ready e Printing in segments x eeeeaeevedvoevoeonoeoeoeoeeceaeaeceoegeoovee es ooaoeoeoeoaean Bev eeeanen a a If you decide you do not want your report to be printed in segments and you would rather rearrange the array contents you may type the lt ESC gt key to
7. II ll The t PUINCE NON O TEP E E E T E T E S e II 12 The Save COnmiand 4s csssiewicttieesscwwesweede een se eeken Lhe password PFOCECTION cccccccecccssscccscscccceseslim1g II 13 The storage Gerig e 6 6 is 6 6000 645 655 hho 0546 64K a6 LEO 11 14 The Bdge COnmanG lt e6sicis sewecci eed eevee oes 06 seseeecelines II l5 The hbiglehko a PEP E TAE se weteeweeueesues lanes II 16 The What CONMANG sss 56 655040066666 S ee ciesa diesdos es s LL20 Simple Wid o ick0 60s wiss 6a 000 606 6sbs0b5e6 ew E TEE EA extended WHA c sselowew ees bWawseeen kweadeueeeeese Limo II 17 system FUNCE 1 ONS s 60 5 4 0 9 500 Wo eee ees bees Sb N eeu es sae Gees LL TOO Sliiiacd oss argu aye E 60S 6 6 06 6 50 Swine whee eeeeewee loo ON a E EE E E ES G5 E Ow ER ONS SSL LOO iii CalcStar User s Manual SECTION III II 19 II 20 I1 21 II 22 II 23 II 24 II 25 II 26 II 27 II 28 II 29 II 38 II 3l II 32 II 33 II 34 II 35 II 36 II 37 Appendix A Appendix B The A PUNCEIChsosss stisiweseee ees scewewnsesshewes leased The Recalculate Command cccccccccccccccvcccccceccvellnm3e CNELY E Wo os ow vo Wieis ee 0 s 6640S EE 6506 s e eee E Bo abs 616 aie Holes OS eR heehee OD The Order Conan 464 6 5560 esuww ees bessetdieceeseceeewtl o4 The Merge CONMANG 5 06 b 5i s whores sea asc ones ease dew deses E two or more files on one SCreenN eesseseoeeass L I 35 merge a file almost anywhere on the array II 38 T
8. Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel Col gt A IB IC ID FR irr nw ere re ert rors memento eee fe tern ese te en einen tr a EEO TE l PART PART NAME SUPPLIER SUPPLIER NAME k e nueia aa a ier a a 3 7 x 4 12345 1 4 BOLT 35 ACME 5 12346 3 8 BOLT 35 ACME 6 12347 1 2 BOLT 35 ACME 7 12348 5 8 BOLT 83 gt UNIVERSAL lt B8 12349 3 4 BOLT 83 UNIVERSAL 9 12358 7 8 BOLT 83 UNIVERSAL 12351 1 BOLT 83 UNIVERSAL jemenano aaas mamaaa ana cursor D7 current D7 L R current type text right justified data contents UNIVERSAL edit kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk If this agrees with what you have on your screen then give yourself a pat on the back If not find the place where the difference occurs If it s in the columns for supplier number or supplier name then check the steps below If it s somewhere else on the Screen then refer to the section of this manual II 9 II 11 in which that operation was demonstrated to try and locate the error II 16 CalcStar User s Manual Operations If you had trouble with copying the information for supplier number and supplier name follow through these steps l Goto C4 computer prompt edit Command P re
9. 9 13 17 6 7 8 9 J 2 6 108 14 18 ll 12 13 14 15 3 7 11 15 19 16 17 18 19 2 4 8 12 16 20 This diagram illustrates the two sequences of evaluation available with the Order command The Order command is sometimes necessary because the Recalculate command in moving through its usual order of evaluation left to right top to bottom may encounter a formula that depends on a value at a coordinate that has not been evaluated yet and so the result at our formula will not be correct For instance if there were a formula at location D2 and the result of this formula depended on the value at B6 and if the value at B6 changed then when the Recalculate command was executed the formula at D2 would be evaluated before the new expression at B6 and the result at D2 would be incorrect If you were to switch the Order of evaluation however the value at B6 would be reached before the formula at D2 was recalculated and the result would be correct To execute the Order command follow these steps computer prompt your response explanation edit access command directory Command O access Order command and will switch the evaluation order each time it is executed The current mode is dis played on the lower right section of the screen NOTE Remember that left to right top to bottom is the standard order of evaluation Order also affects the action of the lt RETURN gt and CTRL Ze See section II 35 for further reference II 34 CalcStar U
10. C Z2 AA AB DV DW Thus we have 255 rows and 127 columns of post office boxes You can locate the address of any post office box by referring to its coordinate e g Al3 G27 P3 Once you locate the post office box you could store mail inside that box In CalcStar memory locations are very Similar to post office boxes Once we specify the address of a memory location its coordinate we can store data inside that memory location As you can imagine this structure saves you a great deal of time by not having to erase columns and columns of numbers when one unit of information changes Instead you simply change the single unit of information and then everything can be automatically recalculated for you These operations will be explained in a later section of this manual I 5 TERMINOLOGY In order to become more familiar with some of the new terminology that you will encounter on the following pages here is a brief list of some of these terms ARRAY refers to the entire matrix table of data The array limits are 127 horizontally and 255 vertically These are only addressing limits and the actual amount of data that can be stored depends on the memory size of the computer CalcStar User s Manual Overview WINDOW the computer display screen is limited in size making it impossible to view all 32 385 array elements at one time Instead at any given time it is positioned onto one subsection of the array This display secti
11. F t t He HF HF F kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk If you would like to print the contents of another file enter a new file name You may supply a Comment line for each file but if you selected the printer for the first file the program will assume that all subsequent files are to be printed also If this printout was the last one you needed hit lt RETURN gt and the program will return to CP M For now hit lt RETURN gt since we will not need to repeat the demonstration You may take a look at the replication of the printout that resulted from our balance sheet file The sample printout is on the following page II 73 CalcStar User s Manual Operations CalcStar File BALSHEET CSD Position Bl Width 28 Type Position A4 Width 28 Type Position A5 Width 28 Type Position B5 Width 28 Type Position A6 Width 28 Type Position B6 Width 29 Type Qosition A7 Width 28 Type Position B7 Width 28 Type Position B8 Width 29 Type Position A9 Width 28 Type Position C9 Width 13 Type Position Cll Width 13 Type Position Al2 Width 28 Type Position C12 Width 13 Type Position C13 Width 13 Type Position Al4 Width 28 Type Position D14 Width 13 Type Position D15 Width 13 Type Position B29 Width 29 Type Position A23 Width 28 Type Position A24 Width 28 Type Position A25 Width 28 Type Position A27 Width 28 Type Position C27 Width 13 Type Position A3 Width 28 Type Position A33 Width 28 Typ
12. PAYABLE sNOTES PAYABLE TOTAL CURRENT LIABILITIES BBOBO9GH0OOB Numeric 6900 69800 900000000000 Text Repeating Text Centered sTOTAL WORTH Numeric SUM B34 gt B35 8586090 000008000000 Text Repeating Text Centered TOTAL OWNERSHIP amp EQUITY Numeric SUM B34 gt B35 8596900 000900000000 Text Left justified TOTAL LIABILITIES amp EQUITY Numeric C38 C49 8596000 000000000000 Text Repeating CalcStar User s Manual Operations II 36 ADVANCED FEATURES OUTPOT FILES CalcStar files can easily be enhanced by WordStar WordStar will process disk TXT files that are created by CalcStar s print command Once a file is loaded into WordStar any print enhancement capability available on your WordStar can be performed In addition to files written to the PRINTER or to a disk in TXT format two other possibilities exist The file named DISPLAY will brint to the CRT in printer format This is useful for a quick look of a print file for format ting purposes l Another print feature allows for output of comma delimited fields which can be used by SuperSort MailMerge DataStar BASIC etc To write a file in this format prefix the file name witha gt For example type P When the request for a filename appears type B gt NUMBERS lt RETURN gt A comma delimited fields file named NUMBERS TXT is then generated on drive B Each cell represents a field and each row a record CONSTANT FIELD
13. TAB gt is a synonym for G which is described in detail later Take a minute or two to experiment with these cursor movements When you feel comfortable with the cursor controls then move the cursor back to location Al and continue with the next section of the manual II 3 EXAMPLE INTRODUCTION CalcStar is designed to be used as a financial report writing system In this section we will give you a sneak preview of the advantages of a computer report writer We will also introduce the example file you will be using to become familiar with CalcStar To begin we will load an existing balance sheet file into the CalcStar array and then demonstrate how we can change a data value and have the system recompute all the values in the report file this file is also included in Appendix A for reference After having a sneak preview of the capabilities of CalcStar we hope you will be enthusiastic about the possibilities and will proceed through the rest of this manual in order to learn all the operations that are available to you in order to produce the best quality reports possible For our initial demonstration follow the steps outlined below Do not worry about understanding how the operations work as each operation will be discussed in detail in the following sections of this manual computer prompt your response explanation edit access command directory Command L access Load command File Name BALSHEET lt CR gt access balance sheet
14. applies to your situation then you can use Method 3 a series of questions to which you must respond with hexidecimal values or actual keystrokes if applicable regarding character istics of your terminal Prior to such an installation you will need information on keyboard cursor control keys WordStar standard recommended code used to position screen cursor keys used for Escape Backspace Delete required initialization and termination controls for terminal and code to be used to move cursor to first column next row lt CTRL gt Z recommended The full list is shown below Method 1 makes use of the WS COM file in your WordStar system Method 2 uses a file named INSTCS DAT on the CalcStar distribution disk Method 3 creates a terminal description which can be stored in INSTCS DAT in place of one you will not be using All three create a file named TERMCAP SYS whose layout follows All addresses are hexidecimal offsets from the beginning of TERMCAP SYS CONTENTS ADDRESS Terminal Name 89 17 Cursor right key 18 gt Note if high order bit set in any Cursor left key 1A gt of these codes it is preceeded by Cursor down key 1C gt the Keyboard Prefix code in loc 26 Cursor up key lE gt Next row first col 26 gt Escape 22 gt Delete 24 gt Keyboard Prefix 26 Move left 28 2D Clear screen 2E 33 Clear to end of line 34 39 Highlight off 3A 3F Highlight on 49 45 Lead in for cursor pos 46 4D Column offset 4E Separator 58 53 R
15. available with CalcStar There is also a lot of useful information and reminders in case you have any trouble entering different data values The Help command is more convenient to use than this manual in case you just need a quick reminder about a certain point but if you need more than a quick reminder this manual will probably help refresh your memory To execute the Help command follow these steps computer prompt your response explanation ES Gene Gite Oey tome ne dames Ga DM Cie dee een EE Sere Cie Gee Cie Rates ibe SRI Ger Ante ie GE TS Spe Ene aoe des Ge edit access command directory e Command 7 H access Help command II 69 CalcStar User s Manual Operations After the preceeding steps are executed the following screen display will occur Pi aaa la alee lela aaa aaa i Help page 1 hit lt RETURN gt to continue ia E Uy i i Cursor is controlled with keys E D X and S with the lt CTRL gt key held down Direction is up right down and left in that order Control Diamond lt RETURN gt moves the cursor right if no data has just been typed lt CIRL gt Z moves the cursor to the next row first column Data Entry digits 0 9 Signal numeric entry alphabetic characters or blank signal text entry followed by R C or L justifies text right centered or left is used to switch between text and numeric if needed duplicates entry across column P causes page break for print
16. decrease in sales and how large the change is NOTE This type of regression does not pretend to determine cause and effect but only tells you what kind of correlation there is We shall demonstrate all three of these functions within this section Let us say we would like to estimate how much sales for product 1 will be in October given the data for the first six months of this year To calculate our best eStimate move the cursor to location I5 and enter oroj 19 We know from our regression function that the month number is II 62 CalcStar User s Manual Operations the independent variable and the sales amount is the dependent variable With the project function we enter a known amount for the independent variable and the system returns the best estimate for the dependent variable In this case the system returned the amount of 2343 23 This informs us that based on the first six months of this year we can expect to have sales of 2343 23 in October of this year for product l At location H6 enter tregr B2 gt G2 B6 This is very similar to what you entered in the first example The reason why we have included the regression for this location also is to contrast results with the first example In exampie 1 there is a poSitive relationship between sales and time That means as time is increasing sales are also increasing In example 2 however as time is increasing the data shows sales to be decreasing This will sh
17. disappear because the display is not large enough A quick method of determining the headings is to use the What command by typing W The column and row headings will appear at the bottom of the screen display The year does not display because it is not in row one The Extended What or Lock command has been provided as an altenative to using sw to request the headings First go to cell A3 by pressing lt TAB gt and typing A3 lt RETURN gt Type to invoke the Lock command You are then asked whether rows columns or both should be locked Respond with B for both A series of asterisks will appear alongside the locked columns and rows Now move the cursor back to El6 Notice that the headings will not disappear The Lock command toggles Therefore if you wish to turn off the heading lock type and B If you want to process or create large worksheets the amount of room availa ble for entries should be known Display the approximate number of available entries by typing The example income statement was designed specifically for making estimates By examining the figures for consecutive summers one might be able to guess the expected sales figure for the summer of 1985 There exists however a more scientific and established method called linear regression for estima ting or forecasting CalcStar is equipped with such a function By moving the cursor to cell B28 a forecasting function will appear The contents li
18. eee ete ee Se eee e E S janaan 1s gt lt lt 2 3 x 5e 6 7e 8 k Q 19 See et x cursor Al Current Al k k current type data contents edit k gt kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk This is the CalcStar main menu and should match the display on your screen at this point CalcStar User s Manual Overview I 4 STRUCTURE As you can see CalcStar is displayed in tabular form with column headings and row headings Let s see what the advantage is to this format When writing a report you will be working with words and or numbers These are separate changeable units of information Life and report writing will be much easier if we can work with each of these separate units of information independently of the rest of the report Otherwise if one item in the report changes you must re type the entire report With CalcStar you can refer to and work with units of information independent of each other by specifying the location of each unit of information through a coordinate which is a combination of the column number and the row number of the item Al3 G27 and P3 are sample coordinate locations To use an analogy imagine yourself at the post office standing in front of a wall of post office boxes Now imagine that each row is identified by a number 1 2 3 255 and each column is identified by a letter A B
19. file Load position Al lt CR gt load file with upper left hand corner at position Al II 3 CalcStar User s Manual Operations The window on the CalcStar display should now be filled with the contents of what resembles a balance sheet Now duplicate the following steps in order to change an entry on the assets side of the report and of course an entry on the liabilities amp equity side of the report computer prompt your response explanation edit lt TAB gt access Goto operation Goto B7 lt CR gt move cursor to location B7 edit 9225850 35 lt CR gt enter new data at B7 edit lt TAB gt gerne Goto operation Goto B24 lt CR gt move cursor to location B24 edit 9858 35 lt CR gt enter new data at B24 We have substituted two new values into our balance sheet report The totals for both sides are now clearly erroneous Instead of recomputing all the new totals by hand or by calculator we may execute the following steps to recompute all the new totals automatically computer prompt your response explanation edit access command directory Command R access Recalculate command Recalculate A 1l A recompute all values in the E ntry balance sheet file As you can see once the above steps are executed all the totals are recalculated to reflect our changes in the data in the balance sheet Even though CalcStar is mainly a financial report writing system we have chosen to use an inventory control report as our exam
20. l II 20 II 12 II 29 II 26 II 27 APPENDIX A TT AN tALefTZ II 32 II 29 II 24 II 7 I 5 II 12 II 29 II 13 II 17 II l II 17 I 5 II 26 II 27 II 29 I 6 CalcStar User s Manual Appendices a i What command II 16 Simple what II 16A extended what II 16B what if processing II 24 II 29 window 1 5 III 19 INTERNATIONAL CORPORATION 1299 Fourth Street San Rafael California 94901 415 457 8990 Telex 340 388
21. of our EXAMPLE file The editing function that goes hand in hand with the Insert command is the Delete command which we shall now describe II 23 THE DELETE COMMAND As a result of another infamous memo we now find we must delete some information from our file Based on a marketing study the company has made a decision to stop carrying the 1 1 2 bolt This memo becomes effective with our current report and so we must change it again As a result we will have to delete all the information pertaining to the 1 1 2 bolt and recalcu late the total cost order quantity ordered quantity on hand quantity stocked and the number of different bolts Again without CalcStar this would mean rewriting the entire report and recalculating all the values Instead we may use one command to delete the information and use one other command to recalculate all the formulas and our report will be updated II 39 CalcStar User s Manual a Operations Move the cursor to location Al2 To execute the Delete command dupli cate the following steps computer prompt your response explanation edit access command directory Command D access Delete command Delete A ll R ow R to delete the row in which C olumn E ntry the cursor is located If you have performed the above steps the following error message will be displayed 3 ERROR would delete ref s at Al4 I14 J14 Ll4 As you can see the Delete command will not let you delete any locat
22. of the report or the the entire report If you would like to save only a portion of the report enter P and the top left and bottom right coordinates of the portion you would like to save You may use the defaults shown in the prompts or enter in the values you would like Enter A if you would like to save the entire report Once you have answered this prompt the system will acknowledge that the file has been saved and control will transfer to the edit line II 29 CalcStar User s Manual Operations One of the friendly features of the Save command is that the filename is displayed under the bottom left corner of the CalcStar array after the file name under which you would like the file to be saved has been established This serves as a little reminder Saving a partial file can be very useful in conjunction with the Merge command discussed in section II 21l II 13 STORAGE COMPIAND Before we continue let s check to see how much storage space we still have available for our report This will give you an idea regarding how long your report can be To execute the Storage command enter and then enter The system will respond below the edit line with the answer Room for entries Numbers will be filled in for the blanks informing you of the approximate number of entries that you can still make Make sure to distinguish between the e command to check storage space and the function your built in calculato
23. outline of the operations required to create these reports Consequently these reports will serve as useful practice reports for you to gain more confidence in working with CalcStar These reports are so common that they can also serve as models for you to design your own reports A third benefit of this appendix is an extended demonstration of some of the operations available with CalcStar The first example included in this appendix is the balance sheet first introduced in section II 3 We shall duplicate the same recalculate steps after we demonstrate how to enter all the information needed to create the report I Enter the report text l Goto Bl and enter F W and 20 to widen the column and then enter cASSETS 2 Goto A4 and enter F W and 28 to widen the column and then enter cCURRENT ASSETS 3 Goto A5 and enter CASH 4 Goto A6 and enter ACCOUNTS RECEIVABLE 5 Goto A7 and enter INVENTORY 6 Goto A9 and enter cTOTAL CURRENT ASSETS 7 Goto Al2 and enter cTOIAL ASSETS 8 Goto Al4 and enter cTOTAL ASSETS 9 Goto B5 and enter 80000980 l Goto B6 and enter 100000 11 Goto B7 and enter 5225000 12 Goto B8 and enter 13 Goto C9 and enter F W and 13 to widen the column and then enter SUM B5 gt B7 14 Goto Cll and enter 15 Goto C12 and enter SUM B5 gt B7 16 Goto C13 and enter 17 Goto D14 and enter F W and 1
24. the Print command by typing P CalcStar will request the output file defaulting to the prin ter Press lt RETURN gt for the default value The upper left cell of the printout is requested defaulting to Al Press lt RETURN gt for the default value The lower right corner of the printout is requested defaulting to the extreme lower right of the worksheet Type E15 lt RETURN gt to include only Significant rows and columns of the worksheet The form length is requested defaulting to continuous Press lt RETURN gt The form width is requested defaulting to 132 Type 80 lt RETURN gt if 88 column paper is in the printer otherwise press lt RETURN gt You are then allowed to enter titles for the printout Type Depreciation Table lt RETURN gt Each title line is centered on the first page of the printout if there is more than one page Press lt RETURN gt again and the printout of the table will begin The first title line that contains no more than a lt RETURN gt will initiate the printing of the table The display contents can be saved at anytime with the Save command S You want to save the file before quitting and also every half hour or so to protect yourself from power fluctuation which might cause your program to cease functioning Once invoked a filename is requested defaulting to the input filename if there is one You may use the default name by pressing CalcStar User s Manual Introduction lt RETURN gt
25. the printer width to be 8 to insure there will not be any trouble with any print size or paper size and you will get your desired printout Enter 8 as shown below e Printer width 88 A eeeeeooeceeesvneeoeeweseoesvseseevoeoeneoeoeeoeaeoeveeceaeeonoen eee eee 8 As mentioned in the previous section after the above prompt is answered the screen will be cleared of its present display and will then present the last few prompts The screen is cleared so that in case the report is being sent to the console it will be easier to view the report than if the CalcStar array was not first cleared If the subsection of the report you are printing out is larger than the printing width entered above the portion of the report you are printing will be divided into segments and you will see the same message as shown in the TI 55 CalcStar User s Manual m Operations previous section on printing an entire report Since the subsection of the report we are printing is smaller than the printing width we will see the following prompt instead Fix ordinates y n eeoeeveavesceevnoe eo Ceeeeoevesoeoeov seen ea eevee cee eeeeoeooeaneoeo ee eves This prompt is asking you whether you would like to include the column and row headings on your printout This would be helpful to us in this example since we are only printing out a subsection of the file Otherwise we will not necessarily know what some of the numbers and text pertain to If we
26. were to answer N to this prompt and thereby not include the column and row headings our printout would appear like the following Ee tae eS Cs en Co Ea GR Ga GE ate Ce Oe Gi GT ees ae Geen Gli ees cee GE Eee See ee oe ay eee Ey ie GS cE GEE Gg CEG gE in yt Ger Kee CEES ah Ge AE D BS E 5 8 BOLT 83 UNIVERSAL 3 4 BOLT 83 UNIVERSAL 7 8 BOLT 83 UNIVERSAL POS UREN CEE GEES SEYE Gas TEVE GAE CE Cintas PA GEN clipes VA Eee GRD Wine PEAR ap E eee IEG ERO E S arm E T mec ine EER If we decide to include the ordinates by entering Y to the prompt above the printout will resemble the following 5 PART NAME SUPPLIER SUPPLIER NAME 5 5 8 BOLT 83 UNIVERSAL 3 4 BOLT 83 UNIVERSAL 7 8 BOLT 83 UNIVERSAL EEEE EAO met ee ee E ee ee SE EE Ge re ee eer i TE eee There are no row headings in our EXAMPLE file but the column headings are included as shown In order to give our printout clarity enter Y so that the headings are included Your response will appear as shown below e Fix coordinates y n yes 7 eeeooecoeonvevoen enon eovneeeeoeaneeoseeoeevseeoespesvseeaesceaeneaneonvnee eee R II 56 CalcStar User s Manual Operations After the above prompt is answered the next prompt will say Title gt eeeoeesecoeoeeosvevneaeeseeoeoeoeeaeee eevee eeceeeeeoeeaeeevee ee eed We may include as many lines to our title as we wish To answer this prompt we should enter in what we would
27. year following the year the asset was ac quired The listed information gives the year the depreciation expense the accumulated expense and the book value until the book value is less than or equal to the residual value First you must put CalcStar into operation At the CP M prompt type CS lt RETURN gt lt RETURN gt means press the return key The screen will clear and then the standard screen will appear as shown below kkkkxkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel Col gt A IB IC ID E F 2 KROWA reanna aaa Lp lt 2 x 3 4l 5 6 x 7 gi x 9 16 E a _ cursor Al current Al L R current type poets contents edit _ CalcStar c 198 c o MicroPro Int l CS9999XX rv_nnn terminal type kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk k k kkkkkkkkkkkkkkkxkk kkkk CalcStar User s Manual Introduction 3 When the screen cursor rests or blinks on the edit line type L The semicolon means Command The L command
28. you would like to abort the Auto command before you have finished entering information for all of the form mode locations you may hit lt ESC gt and control will return to the edit line and the message below the edit line will read Auto aborted If you decide that you would like to switch some of the form modes from set to clear back to their original condition so that the Automatic form command will not jump to these locations then follow these steps to undo the set form mode computer prompt your response explanation edit access command directory Command F access Format command P recision 2 or W idth 10 F change form mode from set or Form Mode set to clear With the form mode clear the Auto command will no longer jump to this location IT 26 THE PRINT COMMAND ENTIRE FILE At last we have come to the point where we are ready to print out the results of all your hard work on this example file There is a lot of flexi bility with the Print command and as a result there are several prompts involved before the printing takes place This flexibility however allows you many possibilities in specifying what you may have on your printout In order to fully demonstrate the flexibility of the Print operation we will break it up into two different sections This section will give an example of how to print out an entire file Section II 27 will give an example of how to print out a subsection of a file II 48 CalcStar U
29. 0 21 9 158 i Jw a2 p x I3 tener ee eh ete nner ame se Sa eer eh ceo see See i et nr a E e aa aae enema HT z cursor E4 current F4 L R is current type numeric data contents 2 edit kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Got it Very good If not take a minute to review the price column again and compare it to your own work The cost column follows the same pracedure only the decimal precision is set to three places II 23 CalcStar User s Manual Operations Our next task is to calculate the value for the profit made on each bolt sold As can be expected we can write a formula and copy the formula from location to location Since the decimal precision was set to three places in column F for cost entries it will be necessary to set the decimal precision to three places for column G because the calculations for profit involve the cost entries Go ahead and set the decimal precision to three places for column G Refer to the outline of steps covered for changing the decimal precision in column F if you need a reminder II 15 THE FUNCTION The function is a very useful aid in entering data This operation will allow you to move the cursor around the screen and when you have located the entry you would like to use execute the e function to enter the cursor location into the current location There are several ways to enter the formula for profit i e
30. 0 50 08 10 1 08 50 00 a a m a me em eres eeremneneemen amen arn enene ney me a aaan aa an ave a cursor O4 current 04 L R current type numeric data contents H4 gt 25 K4 gt 20 14 180 58 edit t t t et He tH H HF He HE HF HF H H HF F kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk One last reminder might be helpful at this point When you are working with complex expressions it is important to keep in mind the order in which they will be evaluated On a computer all of the multiplication and division operations will be executed before any of the addition or subtraction operations The only way to alter this order of evaluation is to use parentheses in the appropriate places Any operation enclosed by parentheses will have a greater priority than those not enclosed in parentheses Inside parentheses evaluation will follow the normal order of mutiplication and division and then addition and subtraction Therefore use your parentheses carefully in order for your expressions to yield the results you intend they should yield IT 25 THE AUTOMATIC FORM COMMAND The Auto command is utilized to make it more convenient to edit specific entries that are highly subject to change The Auto command is used in conjunction with the form mode specification of the Format command The way it works is to move the cursor to an entry set the form mode move the cursor to an
31. 0 o0 65 05 6 60 5 5 06 506 66 See AC Rees ee eseeeseeeel o I 6 Functional OVEFVIeEW cocccccvccvccccccccccvcccccsccccesl 4 SECTION II OPERATIONS II l Calculator FUNCTION ccccccccccsccccccccccccsccecceeel ml arithmetic OPEratlOnSivive60004s0enecsisweceeeiwan Link extended decimal PreClSion cccoccscccccccocssecelinmd SUM avg MAX min Mit ccvccccccccccccscccecscclinmh II 2 Cursor MOVEMENTS cccccccccvcvescvccveccccccesccevevelins Tiss Example INtroductlon sic lt scssssseusees ev eveeeseseevee Liles II 4 Text Data DALTE TET T E T T R Ge left right center justification cccccccccceclin O II 5 Format column width Command ccccccccccccsccvescesll 6 3 63 character width per cColumn cccccescccceceellO II 6 The Goto COMIMANG sessirnar aaan anaa a lle The Repetition bigla ka PEPETA soe s 060s dooce senseu LL 11 8 The Copy COMMA 6 o cdes 000 6565 6050 sonidir eeecewe eel Le entry to CNULY s00 siba sewers id ckeeeeeeesecesweeell l entry to VANGG oreo 6 sis oeeee obs e640 des E LLL LANGE CO CNETY c c 6ss 550 b 0b 600s Se seee neces treana LLALL range to LANIC ks 6 65605 b5 005 0 6600500068 060060006001 L0 II 9 Numerical Data ENtrvisccccecccecevsscccseveesecessocesslln ll HODETS lt 4 4 6 en 665 50s eee se cab cee Oeee ene ess eeteeew LIL formulas uw sine dni 0 6 66 6500 00s een es ee wate LOL SVSteMm LUNCELONS s sc cesses iw ee seesswesssceeesslI li II 18 The Format precision command Command ccccccccccclinml2
32. 3 to widen the column and then enter SUM B5 gt B7 18 Goto D15 and enter 19 Goto B28 and enter LIABILITIES amp EQUITY 2 Goto A23 and enter CCURRENT LIABILITIES 21 Goto A24 and enter ACCOUNTS PAYABLE 22 Goto A25 and enter NOTES PAYABLE 23 Goto A27 and enter cTOTAL CURRENT LIABILITIES 24 Goto A3 and enter cTOTAL LIABILITIES 25 Goto A33 and enter cCOWNERSHIP amp EQUITY 26 Goto A34 and enter CAPITAL III l CalcStar User s Manual 27 28 29 30 31 32 33 34 35 36 37 38 39 49 4l 42 43 44 Goto 435 Goto A37 Goto A40 Goto A42 Goto B24 Goto B25 Goto B26 Goto C27 Goto C29 Goto C38 Goto B34 Goto B35 Goto B36 Goto C37 Goto C39 Goto C49 Goto D42 Goto D43 and enter and enter and enter and enter and enter and enter and enter and enter and enter and enter and enter and enter and enter and enter and enter and enter and enter and enter II Save the report 1 Enter NET INCOME CTOTAL WORTH CTOTAL OWNERSHIP amp EQUITY TOTAL LIABILITIES amp EQUITY 9900 4819000 l SUM B24 gt B25 Ja SUM B24 gt B25 8508099 6000 i l SUM B34 gt B35 iy ee SUM B34 gt B35 C39 C49 S BALSHEET III Recalculate demonstration l Goto B7 and enter 5225859 35 2 Goto B24 and enter 9850 35 3 Enter R A and watch the
33. 7 within the given range min range of entries returns the minimum value contained II 17 within the given range regr range of entries first coordinate of another range II 29 computes a linear regression line and returns the average of the second range dependent variable proj value inserts a value for independent variable into the II 29 regression equation and returns the predicted value the dependent variable depd value inserts a value for the dependent variable into the II 29 regression equation and solves for and returns the best estimate for the independent variable Slope returns the slope of the regression equation which may II 29 be used to evaluate the degree of correlation c center justifies a text entry II 4 1 left justifies a text entry II 4 r right justifies a text entry II 4 will repeat the characters following throughout the entry II 7 p printing will execute a form feed Must be in first print II 28 column allows insertion of comment into numeric entry location II 18 enters cursor location into current indication II 15 toggles text type between text and numeric II 11 lt CTRL E gt moves the cursor up one location II 2 lt CTRL X gt moves the cursor down one location IL 2 lt CTRL S gt moves the cursor to the left one location II 2 lt CIRL D gt moves the cursor to the right one location II 2 lt ESC gt aborts a command II 5 lt CTRL Z gt moves th
34. CalcStar User s Manual First Issue October 30 1981 Copyright c 1981 MicroPro International Corporation 1299 Fourth Street Suite 400 San Rafael California 94901 USA All Rights Reserved Worldwide ADDENDUM TO CALCSTAR RELEASE 1 2 A Demonstration of CalcStar s Capabilities CalcStar User s Manual Introduction There are two sample files supplied on your CalcStar disk These two files DEMO CSD and HELPER CSD provide an overview of CalcStar s capabilities DEMO consists of tables and formulas for a depreciation table HELPER allows you to work with a seasonal business income statement that contains data for six consecutive summers Together they will explain the Auto Merge and Recalculate commands and display the conditional logic and financial for casting functions They will also demonstrate CalcStar s interfacing capa bility with BASIC Wordstar superSort ana other MicroPro programs After using CalcStar with these sample files you will have a good idea about using it for your own applications Before continuing with this introduction be sure that CalcStar has been configured for your system through the install process Appendix D in the user s manual and that a backup copy of the original disk has been made DEMO Given the initial dollar value of an asset the corresponding depreciation rate the year the asset was acquired and the expected residual value DEMO will list information for each
35. D3 gt G3 Goto C6 and enter F P and to set the decimal precision to for column C and then enter Goto ce 100 een wee Goto C8 and enter 2090 Goto C9 and enter and then enter C C9 D9 gt G9 Goto C13 and enter 100 Goto Cl4 and enter 9 Goto C15 and enter 165 Enter C C9 Cl6 gt G16 Goto C2 and enter C6 Cl3 Goto C21 and enter C7 Cl14 Goto C22 and enter C8 C15 Enter s C C9 C23 gt G23 Goto Dl and enter c2nd Goto D6 and enter F P and and then enter 115 Goto D7 and enter 119 Goto D8 and enter 220 Goto D13 and enter 105 Goto Dl4 and enter 1983 Goto D15 and enter 173 Enter C o D20 gt D22 and R Goto El and enter c3rd Goto E6 and enter F P and and then enter 130 Goto E7 and enter 115 Goto E8 and enter 219 Goto El3 and enter 108 III 5 CalcStar User s Manual 7 Appendices 47 48 52 535 54 553 56 57 58 59 66 6l 62 63 64 65 66 67 68 6a ww P 70 7l 72 73 74 175 76 77 78 79 80 Goto E14 and enter 109 Goto E15 and enter 168 Enter C D2 gt D22 E2Q gt E22 and R Goto Fl and enter c4th Goto F6 and enter F P and and then enter 120 Goto F7 and enter 198 Goto F8 and enter 215 Goto F13 and enter 112 Goto F14 and enter 195 Goto F15
36. ERROR would delete ref s at lt coord gt specified deletion would eliminate data on which other formulas are dependent so formulas must first be changed FATAL ERROR not on disk disk is missing an important CalcStar file and cannot operate until it is on the disk FILEWRITE ERROR system had trouble writing file to the disk math op error numeric overflow space is not large enough for intended operation math op error Givide by zero expression would lead to a value being divided by which is undefined MEMORY IS TOO LOW not enough room to make the intended insertion tn column is not wide enough E no form flags no automatic form modes have been set not along row column specified copy is not in a straight vertical or straight horizontal line not ok password is not correct OUT OF MEMORY no memory left something must be deleted III 11 CalcStar User s Manual Appendices Prec must be 9 12 precision entry is not within required range READ ERROR there are bad blocks where the file is stored sizes don t agree imbet of coordinates you are copying from and number of coordinates you are copying to are different Width must be 3 63 column width entry is not within required range WRITE ERROR disk gets full while writing a file write error not the same second password is not the same as the first password write error lt file gt not found fil
37. Enter the password again to verify that you have it right If you enter a different password the second time the save command will be aborted and control will return to the edit line If you enter the same password twice the file will be saved under the filename you specified and the file will be protected against being destroyed or changed because of password protection Now that we ve saved EXAMPLE let s return to the Save command and illustrate one other point computer prompt your response explanation edit access command directory Command S access Save command File name EXAMPLE lt CR gt access our saved file File exists see below Destroy old contents Y n II 19 CalcStar User s Manual Operations l If you enter N the system will abort the Save command and control will be returned to the edit line This is to avoid accidentally writing a new file over an already existing file of the same name 2 If you enter y and there is no password protecting the file then the system will prompt Password lt CR gt none After this prompt is answered which is asking if you want the new contents of the file to be password protected the system will ask if you would like to Save only a portion of the array or all of the array If you only need to save a portion of the array or would like to store part of the array under another name so you may access either the entire report or a subsection of the repo
38. FEB MAR APRIL 2 1 2 3 4 3 aeeoe emee E ss SEZASIZ 4 district A 5 product 1 300 435 650 875 6 product 2 160 92 81 64 7 8 advertising 1230 1308 1435 1459 10 x k a cursor Al current Al L R current type x data contents i x edit kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk LLao9 CalcStar User s Manual Operations If you move the cursor so that location Fl is the upper left hand corner you may enter the following data and your screen will appear as shown below kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Cammands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit Gor lt TAB gt Goto _ lt ESC gt Cancel Col gt F IG H I K E ROW eea e e l gt MAY lt JUNE 2 5 6 3 somos x 3 1286 1446 x 6 55 47 x da a 83 1519 1536 x Q 10 cursor Fl current Fl L R current type text right justified vd data contents MAY edit a KEKKKKEKKEKEKEKEKKKEKKEREKKEREKKEEKEKEKREKERKEKEEKREKREREREKRKKEREEKEEKRERERKEKERKEREEE Now we have a potentia
39. IF the condition is true THEN execute the first set of statements ELSE otherwise execute the second set of statements Let s review some points about each of the three parts included in a conditional statement II 42 CalcStar User s Manual Operations condition the condition may include numerical values and coordinate references Be careful to only include Single coordinates since the symbol for a range gt would be interpreted as the relational operator greater than To be able to include ranges of values use a system function to sum or average etc The values may be operated on by relational operators logical operators arithmetic Operators and any combination of the ENTEE The relational operators inclu ed are lt LESS than lt less than or equal to equal to lt gt not equal to gt greater than or equal to gt greater than The logical operators included are x logical AND the intersection of two values Typically both values must be true for the entire expression to be true logical OR the union of two values Only one of the two values will need to be true for the entire expression to be true This operator has lower precedence than AND The arithmetic operations included are the same as you have already been working with in CalcStar e g addition percentage etc For numerical manipulation with conditions evaluated to true or false the true condition will assume
40. NAME SUPPLIER SUPPLIER NAME ad 2 Se RES ERR RY eee mentee 4 12345 52 gt 12346 lt 6 12347 T 12348 8 12349 93 12358 10 12351 a enaee ances eens een een a es ae EETCNO SN NS en me ee em on HS seme earache cD Se en nme seine sch is iis tac a cursor AS current A5 L R current type numeric pi data contents 1 A4 edit kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk II l14 CalcStar User s Manual Operations II 11 THE FUNCTION Move the cursor to location B4 We now want to enter the part names for our bolts which range in size from 1 4 inch to 11 2 inch Part name should be a text entry but if we enter 1 4 BOLT the following error message will result Error 7 gt 1 4 BOLT hit space B4 When you nit tne lt SPACE gt bar the value at B4 becomes n To avoid this error you must let the system know that even though the entry begins with a number it should be stored as a text entry To change the text type of an entry type in 1 4 BOLT BUT BEFORE you hit lt RETURN gt hit the key This will switch the text type from numeric to text in this case So the key allows you to toggle the text tYPE back and forth to fit your data entry Once lt RETURN gt is entered after 1 4 BOLT the entry will be left justified Now enter R to switch the entry to the right side of the column This
41. REFERENCES IN FORMULAS A formula may contain cell references that remain constant even when the formula is copied to other cells with the relative option This is useful when a constant input value is needed in several relative copied formulas The demonstration file DEMO implements this feature since the original asset value is used in each application of the depreciation formula Such a reference is indicated by suffixing the cell reference with a bang character For example the formula sum A3 gt A7 A8 B17 will use the value at A8 no matter where the formula is copied to other cells with the relative option 11 37 SUMMARY We have now concluded our demonstration of all of the functions and command operations available with CalcStar We hope that this manual has proven to be a helpful learning guide and will also assist you as a handy reference tool To make this manual as complete as possible we have included four appendixes to serve as a fast and easy reference source for use with the CalcStar program We hope you will enjoy using the CalcStar program and find it a valuable asset to your organization II 75 This page intentionally left blank CalcStar User s Manual Appendices SECTION III APPENDICES APPENDIX A This appendix includes three sample applications of reports including a balance sheet a Sales analySis and a paint cost estimation The appendix includes both the finished report and a step by step
42. SC gt Cancel Col gt J K IL ROW rr eer emer aama 42 gt 2120 lt 2888 De 2980 2168 6 3788 1226 x Ts 3110 1898 8 4195 885 x D 3063 1937 10 1918 3082 il 4350 650 12 13 ah cr cc ec em cn ee rene ene econ mee se we omen en ee A et eS Se Se fe if ae i cursor J4 current J4 L R current type numeric data contents 2129 edit FH HHH HH HF bo oF OF OF kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk kkkkkkkkkkkkkkkkkkkkkkkkkk The figures in column J are entered straight from the data given and the only change that was needed was to change the decimal precision from two places to zero places At location K4 QUANTITY ORDERED the formula I4 J4 should have been entered and then this formula should have been copied into locations K5 through Kll with relative changes Well take a deep breath Only one more column of data to calculate After that we can really start to have some fun with our report At location L4 we want to enter a formula don t be too surprised and then copy it through the rest of the column with relative changes in order to show us the cost for this order for each size of bolt II 27 CalcStar User s Manual Operations At location L4 we can enter the formula for cost times quantity or dered to give us our results So enter F4 K4 to get the cost for this order for the 1 4 bolt The result in the window
43. a numerical value of l and the false condition will assume a numerical value of executable statement if condition is true after the first colon you may enter the statement you would like to be executed if the condition is true This statement will be executed only if the condition is true The statement may be a number a coordinate a formula involving any combination of both or a String of characters enclosed in double quotes e g yes If you enter a condition followed by two colons the value asSigned will be zero if the condition is true executable statement if condition is false after the second colon you may enter a statement you would like to be executed if the condition is evaluated to be false This statement is optional and if you do not enter a statement will be entered if the condition is false This was the case with our first example above The statement may be a number a coordinate a formula involving any combination of both or a string of characters enclosed in double quotes II 43 CalcStar User s Manual o Operations With all this in mind we may now go on to demonstrate a few additional examples involving conditional statements For our second example we may attack the same problem we solved in our first example except we will solve it in an alternative way With the cursor at K5 enter J5 lt I5 I5 J5 This will evaluate the first expression J5 lt I5 and if the condition is true the ex
44. abort the Print operation and return to the Edit line The prompt shown below will be displayed if you are printing out a subsection of the report that will not include the first column or the first row e Fix ordinates y n I E E E E oo seeoeeoeeveveoeeoeaeeveesneoeaceo1oseseeosvsees eae eae eevneeveseeosds A Y response will print the report with the headings that would otherwise be missing if you are printing out a subsection of the report array that will not include the column headings e g PART or the row headings An example of how to use the fixed ordinates prompt will be demonstrated in the second printout example in section II 27 of this manual The next prompt will be e title gt Sy CHESS SEOHSSSEOESSCHESSHEHSCHES SESE SHEHSOHAOSCHHREOSECESOESSECEOEC S Li 52 CalcStar User s Manual Operations If you would like your report to have a title you may now enter the first line of the title Once you have entered the first line of the title and hit lt RETURN gt the prompt for title will repeat itself so that you may include a second line to your title In fact you will be able to enter as many lines to your title as you wish When you are finished with the title hit only the lt RETURN gt key to answer the title prompt This will tell the system you are finished with the title Your title will be automatically centered at the top of your report If you would prefer not to have a title on your rep
45. al E edge command edit line entry entry type text or numeric error messages evaluation of input data example applications exiting CalcStar SACENGUSG Screen GisSpsay on forecasting form feed during printing format c column width decimal precision form mode H headings row column display print help file I if then else statements independent variable insert 7 row column internal comment inventory example af labels row column display print linear regression loading a file load a file offset position logical operators Appendices II l4 I 6 I 5 II 4 II 9 II 11 APPENDIX C II 34 I l II 3 APPENDIX A II 32 TT 23 ae che wel ole II 29 II 28 II 5 II l II 25 II l6A amp B II 26 II 27 I1 33 II 24 II 29 II 22 II 22 II 18 II 3 I1I 39 II 16A amp B II 26 I1 27 II 29 II 38 TI 30 II 24 III 17 CalcStar User s Manual topes main menu MAX merging files MIN 0 order of calculation pP passwords prediction printing a file printout report samples PEE om tein EN La aam md a am projeccion LuNnccion quitting CalcStar Re regression relational operators repeated strings row S saving a file Slope function storage space SUM system functions T terminology of CalcStar titles trend analysis type line III 18 Appendices I 3 II 17 II 1 II 21 II 1 7 II
46. al 40090 You may repeat the SUM function for column J to find that we actually have 25436 bolts on hand For column K we can calculate the quantity ordered in one of two ways We can either l Perform the SUM function for the range K4 through Kil Or 2 Subtract the total quantity on hand from the total quantity stocked tI13 J13 HINT This method will compute a little more quickly than if you use a system function Either calculation will result in the correct answer of 14564 bolts on order We will leave it up to you as to which you would like to use We will demonstrate the use of one other system function Goto Al2 and underline the column as we have done previously Here we want to know how many different bolts we carry in our inventory If we were to use the SUM function we would calculate the summation of all the part numbers but that would not be the right answer Instead we will use a system function called CNT count which will count the number of numerically valued entries in the argument list At location Al3 enter CNT A4 gt Al11 is to switch the entry type from text to numeric The result in the window at Al3 will show 8 We carry 8 different sizes of bolts For clarification purposes enter BOLTS at location B13 The contents will be left justified and since the 8 is right justified the result of columns A and B will show 8 BOLTS For a list of other system functions that are available to yo
47. allowing you to examine alternatives For example suppose that you wished to see what difference a change in the rate of depreciation would make in the anticipated useful life of the asset To change the depreciation rate you must move the cell cursor to the cell containing the original value You can move the cursor by holding down the control key while pressing one of the other keys E the Simultaneous pressing of the Control key and the E key will move the cursor up one row X will move the cursor down one row S and D will move the cursor left and right one column respectively Move the cell cursor to B3 Depreciation Rate Once the correct cell is reached type 30 lt RETURN gt The contents of the cell changes immediately to the new value Now that the depreciation rate is changed you want to adjust the rest of the figures that depend on the depreciation rate Use the Recalculate command to do this In order to better see the effect of the Recalculate commmand turn off the Help Menu with the Extend command Then type R to begin the recalculation CalcStar will ask whether all the entries or only the current entry should be recalculated Enter A for all Row numbers at the lower left of the screen display will increment in periodic flashes and then the recalculated figures will appear The display should resemble the following CalcStar User s Manual Introduction kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
48. and enter 179 Enter 3 C E2Q gt E22 F2Q gt F22 and R Goto G6 and enter tpt p and and then enter ASUM CESEE Enter 3 C G6 1G7 gt G8 and R Enter C G6 gt G8 G13 gt G15 and R Enter C G13 gt G15 G20 gt G22 and R Goto C18 and enter SUM C6 gt C8 Enter C C19 D1G gt G18 Goto C17 and enter SUM C13 gt C15 Enter 2 C gt C17 D17 gt G17 and R Goto CIA ea ee lor LFOANCII A IES Ne RSS Nee he j Enter C C24 D24 gt G24 and R Goto C29 and enter 14C20 C24 196 and then enter F P and El to set the decimal precision to l place Enters 3 C C29 D29 gt G29 and R and then goto D29 E29 F29 and G29 and at each location enter F P and El Goto C39 and enter C21 C24 199 and chen enter fot TPt 1P and iB Enter C C38 D3 gt G38 and R and then Goto D30 E30 F30 and G38 and at each location enter F P and El Goto C31 and enter C22 C24 19 and then enter F P and IE l Enter s C C31 D31 gt G31 and R and then Goto D31 E31 F31 and G31 and at each location enter F P and El Goto C36 and enter C18 C24 18 and then enter F P and ipl Enter s C C36 D36 gt G36 and R and then Goto D36 E36 F36 and G36 and at each location enter F P and El1 G
49. arate file and used whenever needed All the infor mation that is subject to change can be stored in other files and then when the Merge command is executed the two files can be combined into one Yet even when the two files are combined your original STDINV file is stored in its original condition on the disk to be used again whenever you wish Now we could create another file called INVDATA inventory data which would store the changeable values including price cost profit unit profit quantity on hand quantity ordered and cost order All of these numbers are subject to change Now we can take a look at the screen display for the INVDATA file at the same location of the array as the screen display for the STDINV file kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Camands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel Col gt C ID E F RO Wi rrr Aso lt eZ moos 43 02 8 915 5 8 2 9 021 6 8 83 6 029 Ts 9 05 9 941 8 Q 97 9 957 3 8 10 8 080 10 9 15 8 112 ene eee ee CTR RR PS a AE NSN a RE YS RE STE A ma a cursor Cl curr
50. at L4 should say 43 20 43 28 worth of 1 4 bolts are being ordered at this time Now copy the formula into locations L5 through Ll1 with relative changes The results are 1 4 bolt 43 20 3 8 bolt 44 19 1 2 bolt 35 86 5 8 bolt 77 19 3 4 bolt 46 38 7 8 bolt 156 26 bolt 348 99 1 1 2 bolt 192 77 B Extended What Now in case you think the simple What command is not enough we have gone a step further and included the extended What command This will be of great help to you if you will be working in a section of the CalcStar array in which you would constantly be needing to execute the simple What command to check whether your column and row location was correct Instead of executing the simple What command repeatedly the extended What command enables you to lock in the entire top row and the entire first column As a result all the headings contained within the first row and the first column will be constantly visible for you to refer to in order to insure you are making your changes in the right places To show you how helpful the extended What command can be we will demon strate a typical situation Move the cursor to location J4 and execute the Edge command by typing E The result will display numbers corresponding to the QUANTITY ON HAND QUANTITY ORDERED and COST ORDER However without the column and row labels in sight it becomes more difficult to distinguish what we are looking at To execute the extended What co
51. below top left corner Al r After entering Al or hitting RETURN the next prompt will ask bottom right corner Jll gt ban SE S JE JE E E e e e a e e E eo 6 Now you are being asked to specify what you would like to be the bottom right hand corner of your printout At this point you have to be a little careful If your report is wider than the maximum printing width of your II 49 CalcStar User s Manual _ Operations printer then you will need to have your report printed out in segments and patch it together afterward The bottom right corner of the report is the default value If this is not the point you would like to have for the bottom right of your report then enter the correct location or move the cursor to the location and type the symbol In our example we will assume the use of a printer with a printing width of 89 characters in order for our example to be universally applicable Since our report is wider than 89 characters we will be able to demonstrate how CalcStar automatically divides our report into segments to fit our printing width In this first printing example we are printing out the entire report In our EXAMPLE file move the cursor to L13 and type The result is shown below e bottom right corner L13 E E E E E oes eceaoeoeon oo eeeaseeosnee q oecoanoaue Ceeevaeonseeenv EESE EEEE HINT If you don t remember what the last row with relevant information is then move the cursor aro
52. cStar User s Manual Operations For our SALES example file we will enter the regression function in three different places in order to demonstrate some slightly different points First of all at location H5 enter regr B2 gt G2 B5 The plus sign insures the entry is interpreted as numeric The regr signifies the regression function B2 gt G2 is the range of entries which contain the values for the independent variable B5 is the beginning of the range of entries which contain the values for the dependent variabie The system will automatically know to include the entries through G5 since that will result in the same number of entries as the range for the independent variable So in this first equation we are regressing the amount of sales on the time periods months This will allow us to see how sales are doing aS time passes by and then we will be able to come up with a forecast for sales in any future time period based on the trend established with this data A numerical value will be displayed at location H5 where you entered the regression function We will explain this value in a minute With one regression function entered and with location Fl as the upper left hand corner your screen will simulate the following illustration kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc lt CR Right A Auto F Format M Merge R Recalc Extend
53. cStar to be as convenient to use as possible For this reason the system will display the symbol n whenever it encount ers a numerical expression which evaluates to something divided by zero This informs you right away of the problem and you may then seek out the solution If you try to copy such an entry all the entries you copy into will also show the n symbol You may add or subtract values from this entry and the system will simply ignore the undefined expression However if you try to multiply or divide this entry by another value the result will II 1ll CalcStar User s Manual 3 Operations be undefined and n will be displayed in the destination location after the recalculate command has been executed You will also see the n symbol if you try to multiply or divide a value by a cordinate which does not have a numerical entry In our inventory example we have eight different sizes of bolts The part s on these bolts range from 12345 to 12352 in sequence Once again we have two ways in which we could enter this data We could enter each number individually or we could enter one number and then use a simple formula then copy that formula into the rest of the locations to result in the right values To start Goto A4 Enter 12345 on the edit line After you hit lt RETURN gt you will notice that the value at the location A4 reads 12345 00 This is because the system automatically assigns two decimal places toa nu
54. changes column width II 5 changes decimal precision II l changes form mode II 25 7G move the cursor to specified location II 6 H displays the Help file for handy reminders II 33 I Insert a row or column II 22 L Load a file that has been saved into the CalcStar array II 30 7M Merge a saved file with current contents of array II 21 70 toggles the Order of evaluation for the Recalculate command TI 20 and changes the effect of lt RETURN gt and CIRL Z P Prints the given section of the array II 26 II 27 7Q exits Quits the CalcStar program II 32 R Recomputes an entry or all formulas in the array II 19 7S Saves the contents of the array onto the disk II l2 W shows you the row and column headings for the entry Where the II 16A e e J cursor 1S presently located locks in column and row headings for entire array an II 16B extended What command informs you of the amount of storage space still available II 13 extends the window into the CalcStar array to 15 rows from II 30 the standard 18 row display sum range of entries sums the values contained within the II 17 given range III 8 CalcStar User s Manual Appendices avg range of entries computes the average of the values II 17 contained within the given range cnt range of entries returns the number of numeric entries II 17 contained within the given range max range of entries returns the maximum value contained II 1
55. cision 2 or W idth 1 or Form Mode clear Column C precision 19 edit edit Command from coord gt coord to coord gt coord 2 Goto C7 computer prompt edit edit Command from coord gt coord to coord gt coord your response i F P 35 lt CR gt e CA lt CR gt C5 gt C6 lt CR gt your response 83 e C7 lt CR gt C8 gt C11 lt CR gt explanation access command directory access Format command alter decimal precision set precision at places enter data at C4 access command directory access Copy command copy value at C4 copy value into C5 thru C6 explanation enter data at C7 access command directory access Copy command copy value at C7 copy value into C8 thru Cll TI 17 CalcStar User s Manual 3 Goto D4 computer prompt edit edit Conmand from coord gt coord to coord gt coord 4 Goto D7 computer prompt edit edit Command from coord gt coord to coord gt coord 11 12 THE SAVE COMMAND your response RACME lt CR gt e Ei C D4 lt CR gt D5 gt D6 lt CR gt your response RUNIVERSAL lt CR gt 3 C D7 lt CR gt D8 gt D11 lt CR gt Operations explanation enter data at D4 access command directory access Copy command copy value at D4 copy value into D5 thru D6 explanation enter data at D7 access conmand directory access Copy command copy value at D7 copy value in
56. correct result For instance since we want the slope for all three of the regression functions we should execute the recalculate command to insure they are evaluated properly Once the recalculate command has been executed and labels for the month of October have been entered your screen will resemble the diagram below if location Gl is the upper left hand corner kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate BE Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel Col gt G H I IJ K i Oi SS ee ai 1 gt JUNE lt OCT 2 6 19 x 3 sos 4 k 5 1449 2343 23 234 85 6 47 73 16 18 11 22 7 83 1538 816 66 1999 98 3 46 Q 18 k i ce ee SEER ER RN en en RES er Hee ene ence i meee a I cursor Gl current Gl L R a x current type text right justified data contents JUNE i edit kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Note the mean for the dependent range for the first regression function we entered has been replaced by the blank entry yet we may still use the regression funct
57. ct the new cost so recalculate all values The Recalculate command allows you to either recalculate all the formulas in the array or an entry that you specify In our example since profit unit profit and cost order were all influenced by the increased cost we wanted the new figures for profit unit etc But in case you would like to recompute only one entry while leaving everything else as it is you may enter E to recalculate the entry at the current location If you enter A to recalculate all the formulas the Recalculate command examines each row and recomputes any formulas in that row so that if any value which is used in a formula has changed then the recalculated value will now appear on the screen The system functions e g SUM are included in the Recalculate command and you can move the cursor to location L13 to verify that the total cost of this order has increased from its previous value to a new value of 968 41 You may also check locations Al3 I13 and K13 to verify that our new information was included in the recalculated values for the system functions QUANTITY ON HAND did not change because the value added was 9 NOTE If you try to recalculate an entry that contains text the system simply does not calculate entry and control returns to the edit line Isn t that easier than wearing out your paper with an eraser Imagine how much eaSier the Recalculate command would make your work if you were working from an app
58. der to clear the CalcStar array II 58 CalcStar User s Manual computer prompt edit Command Delete A 1l R ow C olumn E ntry verify Y N your response gt Oo Operations explanation access command directory access Delete command delete contents of entire array after making sure you have saved your work enter y for complete deletion If you have not saved your work and want to preserve it enter N Now the contents of the CalcStar array will be erased and you may begin to work on a new project numeric data for the first six months of 1982 We may begin our new example by entering text and For simplicity we will present diagrams illustrating what your screen should resemble after entering the appropriate data you have learned up to this point This will be a good time to review all the commands Shown below is a replication of your screen with location Al as the upper left hand corner i kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel CoL gt IA IB IC ID E a k ROW ne Ste lt JAN
59. e Position A34 Width 28 Type Position B34 Width 28 Type Position A35 Width 28 Type Position B35 Width 28 Type Position B36 Width 29 Type Position A37 Width 28 Type Position C37 Width 13 Type Position C39 Width 13 Type Position A49 Width 28 Type Position C49 Width 13 Type Position A42 Width 28 Type Position C42 Width 13 Type Position C43 Width 13 Type oe 00 80 oG 86 o0 0O 8 68 80 oo ee ee 08 oo 8 ee oo o 028 88 686 II 74 Text Centered gt 20 oe c 66 sASSETS Text Centered CURRENT ASSETS Text Left justified CASH Numeric 8800000 89090000 900000900000 Text Left justified sACCOUNTS RECEIVABLE Numeric 190000 199000 999000000000 Text Left justified INVENTORY Numeric 52259009 5225000 000000000000 Text Repeating Text Centered sTOTAL CURRENT ASSETS Numeric SUM B5 gt B7 13325009 600000000000 Text Repeating Text Centered Numeric SUM B5 gt B7 Text Repeating Text Centered TOTAL ASSETS Numeric SUM B5 gt B7 13325088 9800808000000 Text Repeating Text Left justified Text Centered Text Left justified Text Left justified Text Centered Numeric SUM B24 gt B25 Text Centered TOTAL LIABILITIES Text Centered sOWNERSHIP amp EQUITY Text Left justified CAPITAL Numeric 85000008 8500000 g80G00000000 Text Left justified NET INCOME TOTAL ASSETS 13325000 0g0000000009 sLIABILITIES amp BQUITY CURRENT LIABILITIES sACCOUNTS
60. e column to a width of 18 and then enter RCOST ORDER By this time you probably feel like an expert at widening columns and entering right justified text right Now hit the lt TAB gt key To the prompt Goto gt enter lt RETURN gt With the cursor at location Al your screen should match the following kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit Gor lt TAB gt Goto lt ESC gt Cancel ColL gt A IB Ic ID E Row e e ee e 1 gt PART lt PART NAME SUPPLIER SUPPLIER NAME e 3 4 5 6 7 8 9 19 EEAS Sieli aa cursor Al current Al L R l current type text right justified data contents PART edit He H He HF HF HB HF Hn HF HF He H F kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk kkkkkkkkk CalcStar User s Manual Operations II 6 THE GOTO COMMAND Now scroll to the right to examine the rest of your column labels At location Ll if everything is correct duplicate the following steps computer prompt your response explanation edit acces
61. e cursor to the first entry of next row II 2 III 9 CalcStar User s Manual Appendices lt CR gt or RETURN enters data if something on edit line or moves II 2 the cursor to the right one location or aborts a II 5 command lt TAB gt moves cursor to specified location Same as Goto command i i arithmetic expression evaluates the expression without II 1 entering it into the array III 19 CalcStar User s Manual Appendices APPENDIX C This appendix includes a list of the error messages that may occur during CalcStar usage bad coord coordinate entered cannot be used for intended purpose bad form length specified form length is not within reguired range 1 66 bad range coord range of coordinates cannot be used for intended purpose can t create not enough memory to set format precision can t open not enough space on disk or disk needs crunching can t open file not enough room to open file on disk couldn t read TERMCAP SYS system could not read a necessary file related to hardware Need to get proper version of file DATA IS PROBABLY DAMAGED from entering too long of a report and there was not enough memory data too wide specified printing section is too wide for specified printing width Delete character is underscore _ certain machines will have the underscore key as their delete key ERROR gt lt expression gt system could not interpret entry correctly
62. e does not exist as entered write error I O disk needs crunching write error Close disk needs crunching write error end gt start in saving a partial file the top left coordinate must come before the bottom right coordinate write error bad coord invalid coordinate entered WRITE CLOSE ERROR diskette is wrong or insufficient room EVALUATION ERRORS value range error math overflow divide by zero function cannot evaluate value entered illegal coordinate or wrong coordinate format range is not a row or column missing a or unknown function function typed incorrectly terminal expression is illegal illegal characters at the end of the line number is not in correct form error in regression values too many parenthetical levels illegal value in REGR function UI ee CNW OND WHF pete eee N III 12 CalcStar User s Manual Appendices APPENDIX D This appendix contains the information that may be needed when installing CalcStar The program INSTCS provides three ways to configure CalcStar for your terminal Method 1 allows the WordStar user to move the configuration infor mation from his WordStar system directly to CalcStar This creates a CalcStar environment that is consistent with WordStar usage Method 2 is used if a WordStar system disk is not available This method presents you with menus of terminals from which you select the one that represents your terminal If neither of these methods
63. ed file If you would like to include a one line title to the printout enter it to answer the prompt Comments If you do not need a title hit lt RETURN gt For our demonstration we do not really need a title so hit the lt RETURND Lies 2 CalcStar User s Manual Operations You will next be asked to enter the destination of where you would like your file to be printed Most of the time you would like your report to be sent to the printer in which case you may hit the lt RETURN gt If it happens you would like your report to be written to another file on the disk enter the name of the file you would like it to be stored under kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkxkk CalcStar Dump vr 1 0 CalcStar file name lt Return gt to quit BALSHEET CSD Comments Output file lt Return gt for printer HF OH KKEKKEKKKKKKKEKEKEKEKEKEKEKEERERERREKKKEKEEKEKEKEKKKEKEREREEKEEREEREEKEEREER Before you answer this prompt it is important to make sure the printer is connected and ready to go because once this prompt is entered the printing will begin When the printing is complete there will be another prompt asking kkkkxkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk CalcStar Dump vr 1 0 CalcStar file name lt Return gt to quit BALSHEET CSD Comments Output file lt Return gt to quit CalcStar file name lt Return gt to quit t Ft HF HF
64. eee eee ed r type text left justified contents PART edit e Since PART is a text entry the screen is correct and agrees with our intention However instead of having the entry left justified we would like it to be right justified because there will be a column of numbers underneath PART and numbers are always right justified If the numbers are underneath the text it will help our report to look much nicer In order to change the entry from left justified to right justified enter R on the edit line with the cursor at location Al Our entry now moves over to the right side of the column Similarly if you wish to center justify an entry enter C at the location you would like centered and if you wish to left justify an entry enter L at the entry location If everything is correct we can move on to the next entry i Move the cursor to location Bl Since we will want all our column labels to be uniform they should all be right justified There is an easier way than entering each label and then changing the justification This time type in RPART NAME on the edit line and then hit lt RETURN gt As you can See the entry is automatically right justified II 5 FORMAT COLUMN WIDTH COMMAND Since there is very little space between the two column labels it would be useful if there were some way to make the columns wider or narrower if needed Report writing could become much more tedious and time consu
65. eet and enter Hourly wages and enter rFixed overhead and enter rMaterial cost and enter rLabor cost and enter rTOTAL and enter F and F to set the form mode at C5 and then enter 5 Goto C7 and enter Goto C8 and enter Goto Cla Goto Cll Goto C12 Goto C14 Goto Cl6 Goto C18 Goto C208 Goto C21 Goto C22 Goto C23 Goto C24 F F and then enter 12 r R and then enter 12 r F and then enter 6 r r and enter la F FP and then enter 300 g I and enter and enter 2 and enter C7 C8 C5 and enter 7 89 and enter 17 50 and enter C14 cll Cl1g and enter Cl14 Cl2 Cl6 and enter and enter Cl8 C20 C21 and enter II Save the file 1 Enter S PAINTOOST III Enter data by using the Automatic form mode l Enter tet TAY 14 16 1 5 300 The total will now be automatically recalculated III 3 CalcStar User s Manual Appendices IV Print the report l Enter P lt CR gt lt CR gt C24 lt CR gt 80 N lt SPACE gt SAN DIEGO PROFESSIONAL BLDG Suite 999 1 27 81 lt CR gt If you would like to print another file s contents enter Y and the sequence of steps you have just completed will be repeated for another file If this printout was the last one you needed enter N and the CP M prompt will be re displayed and you may continue
66. ell E12 other wise place in E12 the difference of the contents of cell C12 and contents of the cell E11 A simpler expression could have been used to produce an answer by omitting the conditional and only placing E11 C12 in cell E12 Further explanation about creating an application system can be found in the CalcStar user s manual HELPER With HELPER CSD an operator is allowed to enter information in the form of an income statement for consecutive summers Estimates of future figures for a variable may then be made For example given the sales for six consecu tive summers HELPER can provide a sales estimate for a future summer From within the CalcStar program load HELPER by following the procedure used for loading DEMO The screen display will resemble the following CalcStar User s Manual Introduction kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk kkkkkkkkkkkkk Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right IC Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit Gor lt TAB gt Goto lt ESC gt Cancel Col gt IA IB IC ID E A E ee 1 gt lt Summer of Summer of Summer of Summer of 2 78 79 86 81 3 es eae ant Setar aa ass eeiesemoumnate casi 4 Net sales g
67. elow the 19th row it may be easier to use the function rather than pointing your finger on the screen trying to figure out the coordinate of the value you wish to use TI 24 CalcStar User s Manual Operations The next step is to copy the formula for profit unit into locations G5 through Gll with relative adjustments for each entry After copying the formula you will find that the profits range from 5 1 2 cent for the 1 4 bolt to 53 5 3 cents for the 1 1 2 bolt In order for you to feel at home with the function you may use it in entering the formula for profit per bolt sold The formula is profit unit divided by the price and then multiplied by 108 or G4 E4 109 HINT Remember to enter a sign before G4 If your result at location H4 is 25 80 you may assume that you have understood these operations well If you found the steps a little tricky we ll take them one step at a time At location H4 enter a Sign Move the cursor to G4 and enter the key G4 should now be on the edit line Enter the sign division sign Move the cursor to E4 and enter the key e Enter 190 multiply by 100 Hit the lt RETURN gt key OV U1 e UO NF e NOTE For greater clarity you could enclose 4G4 E4 in parentheses The parentheses force the entry to numeric also so the is not needed Finish entering the calculations for profit by copying the formula at H4 into H5 through H11 wit
68. ent Cl L R current type data contents edit ee EH eH HHH HK F tk tO kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk The INVDATA file contains only the numerical data information that is variable Therefore instead of writing an entirely new report each time the data changes or having to try and edit a file with complicated dependencies and formulas we can create a new file with the new data and then merge the new file with our STDINV file The Merge command will also be useful if we have several files of data We can perform the merge operation and then print or display the results and then merge two more files and print or display the results and so on By using the Merge command you do not need to spend the time re entering and recalculating numerical data II 36 CalcStar User s Manual Operations Something that is especially useful is the ability to choose the location for the upper left hand corner of any of the Merge files This will allow you to design little modules and then you will be able to mix and match them however you choose on the CalcStar array to produce a wide variety of report and model combinations and be able to greatly minimize duplicated work The steps to merge the two files are as follows computer prompt your response explanation edit access command directory Command M access Merge command File name STDINV lt CR gt merge INVDATA w
69. er L13 eeeeeevvueegeaeoeecoaoneeoseseeeeceoenvneoeoevnoeevpevnescooaoevn ee eee nueeoveene ena In this printout we are only interested in the information contained in the columns for part name supplier number and supplier name for the three bolts mentioned so column D would be the last column The 7 8 bolt is the last one we want included so the last row is row 9 Consequently the II 54 CalcStar User s Manual Operations bottom right corner of this printout should be D9 L13 is the current cursor location so it is the default value for this prompt To override the default enter D9 as illustrated below e bottom right corner D9 7 The next prompt to be displayed is e Form length CONTINUOUS gt eeesceaeeoeaeeeceoeveoeseeoeveeooveeoeeeoeeeveeeoeoeseeaeeoneaenen ESERE NE We are only printing a small portion of the array so we really do not need to be concerned too much with this prompt since the printout will not be more than one page As a result hit the RETURN key to observe how nothing is entered on the prompt line but the prompt is replaced by the next prompt This means the system answered the prompt by default In other words by not entering anything before the RETURN key is hit the system interprets your response to mean you would like the printing to be continuous from page to page The next prompt will ask Printer width 132 As in the previous example in section II 26 we will specify
70. er disk oriented properly according to the requirements of your system It is assumed at this point that you already know how to boot up CP M which you should now do Make a copy of the CalcStar disk and put the original away in a safe place Next it is necessary to configure the system for your terminal t CalcStar User s Manual o Overview Configuring for a printer is not necessary since CalcStar uses the CP M list device Key in the CP M command B gt INSTCS lt RETURN gt This brings up the terminal configuring program See Appendix D for details on how to use this program if the dialog which is presented is unclear or if your terminal type is not among those listed as available Once the terminal is configured you are ready to begin In response to the CP M prompt type B gt CALCSTAR lt RETURN gt Several seconds later you will be greeted by a display of the Main Menu I 3 MAIN MENU kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc k lt CR gt Right A Auto F Format L Load R Recalc Extend Curs Pos S Left D Right C Copy G Goto M Merge S Save Lock Evaluate E Up X Down D Delete H Help O Order W What Space Data Togl Z Col A next row E Edge I Insert P Print lt TAB gt Goto lt ESC gt Cancel Col gt A IB IC ID QORA cower creer cera ener cae ae co een ma enema eens eee ne ee cane
71. erations The result of the Merge command is the combination of both the STDINV file and the INVDATA file onto one screen and this will exactly duplicate our EXAMPLE file with all information included The only caution with the Merge command is that the file being merged on the screen will override the original file in terms of the column widths precisions etc If both files have entries in the same location the entry from the file being Merged onto the array will replace the entry which was Originally on the array This is why it is a good idea to put your files together in little modules rather then spread out templates When you Merge a file onto the array with the upper left hand corner at a different location than when you originally created it there is a potential for disaster since formulas which use entry locations are not located in the Same place as the file they were created in CalcStar takes care of this problem by adjusting formulas when they are moved into the Merged file This is true for all formulas which reference locations within the module being merged However any formulas which reference locations outside of the module being transported will not yield correct results in the resulting file because the resulting file probably will not contain the same data at the external location as the file from which the module with the external referencing formula was taken The moral of the story is to be sure that all modules you are m
72. erging into new files only contain formulas which reference locations internal to the module II 22 THE INSERT COMMAND Now is a good time to demonstrate a very important editing operation which allows you to insert a column or row into your report This becomes very handy if you have some new information which you need to add to your report but you presently do not have the room Let s imagine once again another memo has been handed to you from upstairs informing you that the company has started to stock a new item a 1 1 4 bolt The company would like you to add this new item to your inven tory and include it on your present report Of course if we didn t have CalcStar we would have to start all over and write a new report With CalcStar however we can insert a row and add the information for your new bolt and then have CalcStar recalculate all the formulas Move the cursor to All the cursor may actually be anywhere on row 11 To execute the Insert command follow these steps computer prompt your response explanation edit i access command directory Command gt I access Insert command Insert R ow C olum R insert a row for our new information II 38 CalcStar User s Manual Operations Row 11l has now been moved down to become row 12 row 12 has been moved down to become row 13 and row 13 has become row 14 Row 11 is now a blank line So CalcStar will automatically renumber rows and columns to account for newl
73. erminal definition do you wish to store this in A U or lt RETURN gt A selection from the sequence A through U will replace the existing terminal defined under the letter you choose to be replaced by the one you have just entered so select one that you won t ever need A lt RETURN gt will store nothing in INSTCS DAT and the program will exit with no further action LIISIS CalcStar User s Manual Appendices This appendix serves as a general appendix or index where many topics relating to the operation of the CalcStar program may be indexed The subjects are listed alphabetically and you may refer to the section listed in order to have more explanation The page number is also shown displayed in brackets subject A accessing CalcStar array arrow movements automatic formatting AVG B balance sheet example calculations extraneous internal CNT column column locking column width command list conditional expressions contents line continuous form length coordinate copy command cursor cursor movements D Gecimal precision delete entry row column all dependent function dependent variable III 16 section o2 5 I 2 II 25 II 9 II 17 I I I II 3 APPENDIX A II l II 9 II 18 I1I 19 II 9 II 17 I 9 II 16B II 5 APPENDIX B II 24 I 6 II 26 II 27 I 5 II 8 I 5 II 2 II 2 II 6 11 15 II 19 II 23 II 23 II 23 IT 23 II 29 II 29 CalcStar User s Manu
74. ernel lave a VUY Uh YUUL WLU WUL Moe Let s take a minute to demonstrate the use of CSDUMP so you will know how to obtain permanent copies of your report contents To begin you must exit the CalcStar program use the Quit command but make sure you save your file first if you have not done so For our example we will use a file we have been working with before You will have to know the name of this file which will be the name you specified when you wrote the table onto a disk using the Save command If you enter the name of a file which does not exist Or an incorrect name the system will tell you the file was not found and will give you another chance to enter a file name For our demonstration we will print out the contents of the file BALSHEET which we introduced in section II 3 From the CP M prompt type CSDUMP BALSHEET lt RETURN gt You will then see the following display kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk CalcStar Dump vr 1 90 CalcStar file name lt Return gt to quit BALSHEET CSD Comments amp F kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkxk If you did not enter the file name on the CP M command line the program will wait for you to enter it on the second line above If you can t remember the file name hit lt RETURN gt This will return you to CP M from which you can search directories of your disks to find the name of the desir
75. etrieved the definition of the Televideo 959 from the file INSTCS DAT placed it in TERMCAP SYS and CalcStar is ready to go _ III 14 CalcStar User s Manual Appendices If your response to the Normal first time installation prompt is N then you are presented with a further selection A Modification of existing installation B Installation of WordStar file If you select B you have chosen Method l You will be asked for the name of the WordStar file to be used e g A WS COM The data in WS COM that CalcStar needs will then be placed in TERMCAP SYS and CalcStar is ready for use It is important to note that INSTCS DAT is not affected by this process A selection of A above will lead you through a series of questions you must answer about the characteristics of your terminal At the end of the questions you may review your responses by answering Y when asked if you want to make any more changes When you are satisfied that the parameters look all right a N reply to the any more changes question will cause TERMCAP SYS to be written with the information you provided Again INSTICS DAT will be neither read nor written In order to update INSTCS DAT you must type a lt CNTRL gt O first before answering the A or B question There will be no response by the system until later Then answer A or B aS appropriate When you have completed answering the questions and have checked them for accuracy you will be asked What t
76. example was to illustrate the use of the key in allowing you the flexibility to enter numbers into text entries and text into numeric entries In our inventory example we can accomplish this same action in another way Move the cursor to B5 and enter R3 8 BOLT The system will automa tically interpret the as text since only text can have its position switched remember that numbers must be right justified You may now finish entering the bolt names in locations B6 through Bll with the following data at B6 1 2 BOLT B 5 8 BOLT B8 3 4 BOLT B9 7 8 BOLT Bld 1 BOLT Bll 1 1 2 BOLT NOTE Remember to right justify all your entries Now it s time for some practice The data are as follows l The 1 4 3 8 and 1 2 bolts are made by ACME supplier name column D whose supplier number is 35 column C 2 The rest of the bolts are supplied by UNIVERSAL whose supplier number is 83 II 15 CalcStar User s Manual one Operations HINT Use the Copy command to make your work a lot easier Remember to right justify your answers and set your decimal precision to the appropriate value Now compare your screen to the following replication kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor M vement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock
77. examples You may look up detailed information about each feature of CalcStar in the comprehensive index As soon as you have configured CalcStar for your terminal you are ready to go Follow the chapters in order and you ll soon be a CalcStar expert wondering how you ever got along without it Here are some conventions used in this manual that you should know about l The key marked Return or Enter on some terminals is referred to in the text as lt RETURN gt lt CR gt is used in the examples They mean the same thing 2 The Control key marked CTRL or CIL or Control is indicated by the notation lt CTRL gt lt CTRL gt X for example means to hold down the Control key while typing the letter X Sometimes the notation X is used to mean the same thing This is not to be confused with the command which is explained in the manual The Control key functions are nearly identical with those found in other MicroPro products like WordStar and DataStar an important advantage offered only by MicroPro CalcStar User s Manual This page intentionally left blank ii CalcStar User s Manual TABLE OF CONTENTS SECTION I OVERVIEW I i TRE OGUCE LON esirsoreeise nonien aaa aaaea L selected application posSibilitieS ccsecsseselnml I 2 ACCESS ecceccoecosoesoosocosocesecoesessosoecooosooeo o I7 I 3 Main MANU EE E E E TE T TEE T ETE I 4 Serut C 3 6 55 56 65s G0 sooo kalew wes aa aa aa S I 5 Termi nolOdV vei
78. f you do not understand the steps at this time computer prompt your response explanation edit access command directory command D access Delete conmand Delete A ll R ow A delete entire screen C olumn E ntry Verify Y N Y insures deletion is ok Is the cursor at Al Good Notice that the type contents and edit lines are all blank Now type in PART and then hit the lt RETURN gt key The following happens 1 Since the first character was a P the entry was interpreted as text 2 Since the entry was interpreted as text the entry was automatically left justified at the left side of the column 3 When you hit lt RETURN gt the entry on the edit line moved to the contents line and PART also appeared at Al in the window while the edit line went blank NOTE If you make a mistake in typing and catch it before you hit lt RETURN gt you may hit the lt BACKSPACE gt or lt DELETE gt key to erase one character at a time If you notice the mistake after hitting lt RETURN gt make sure that the current location indicator is the same as the location where the mistake was made and then re type the entry correctly and hit lt RETURN gt This will replace the old entry with the corrected one LL gt CalcStar User s Manual Operations Now instead of being blank the middle section of the main menu will show the following eeegeeeveeeseoeaeoeoesneseoeoeveeon eon esneaosn ees eoease eee eoeneoeeseone
79. h relative changes for each entry II 25 CalcStar User s Manual os Operations II 16 THE WHAT COMMAND Before we proceed any further let s take a minute to demonstrate another convenient command operation of CalcStar A Simple What Command Move the cursor to location Hll to the value 25 00 Now if we were not sure what this value represented we would have to move the cursor up until we could see the column heading and then move the cursor back down to our entry at H11 Likewise if there were row headings we would have to move the cursor to the left and then back again Such movement can be frustrating and inefficient especially if you forget what value you were at A simple solution to this dilemma is to use the What command With the cursor at Hll enter and then enter W Underneath the edit line will appear row column PROFIT This tells us row ll has no title but column H has the title PROFIT Clearly this convenient operation can save you a lot of trouble when you need to reference specific rows and columns with dependent formulas We re now going to let you practice for a little while on the various operations we have discussed so far The next three columns are QUANTITY STOCKED QUANTITY ON HAND and QUANTITY ORDERED We ll give you the information for the number of bolts stocked for each size and the number of bolts on hand and let you enter the information and then write a form
80. he Insert CONMANG 4 5634464 000s Ohuw S66 ESS eeaseeeeeeel anos OW 6s wae e sab E SEO Rd Sb OKRA See G 36 COLUMN ss 645io 0s wise a we wh we Oi Sie hoe eee Oe ee SEL IOSD The Delete Command eecssesessoessoososoeooooooooooo lense m EE EEEE E EE E EE E E T E PE E a AR LOW PEPEE EE ETAT EEE E he E E T N E COLUMN p PPO E E 0 E E E S E E ON E E T E aL CNELY E EER E E E E E E A T TT G ee Conditional EXpreSSionS cccccccccvcccccccccccccscccel m4 What if procesSSing ssssesossoasosooooeeooosos kA OL relational operatOrS ssessessessooseooeoeoso os LI 43 logical ODEKGEOMS s o sssseeis es osand innne e aaa L AA The Automatic Form and Format form mode Commands II 46 direct access to variable data ccccccccccccccell 47 The Print Command entire file cccccccccccvcceccelLl 48 to diskfile OF Printer ccccccccccescccccsceseseslsn 49 form LONGED 63 66 0e b 5 50 0 6064600 54 550 654 445550nseu L LMS printer WICC 2 owe seed oe E b 6 os SW Kaeo tee eS Lm OL automatic printing in Segments ccccccscccsceelinm52 OrGinates Label S sissis is 6055000000060 ee se eesweedanoe PCOS 2 66 Soon wu E se Sie hw WSs sn 6S WEEE Ce wee E Lee The Print Command partial EVIG 24 di 0 s6seseesbeeneees dln oS to ASCII textfile for word proceSSing eeeeel1754 The Page CONMaNG s ivaivswcu ds oeee tds dans 60500e0005 066 L108 Linear Regression Forecasting ccsesccccccceseseccelin o8 regression LUNCELON 4 is5006s lt 00sssee seesesewsws LLO p
81. hich will display 15 rows of the CalcStar array rather than the Standard 19 When the extended screen command is implemented the top section of the screen which lists the commands is replaced and the array is extended to 15 rows If our screen has the same display it did in the previous diagram then we Can now execute the extended screen command to show you what the new result would be Here are the steps for executing the extended screen command computer prompt your response explanation edit access command directory Command access extended screen command Your screen will now simulate the following diagram kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk k kkkkkkkk Col gt A IB IC ID g So ooo ae lt 2s X 23 PART PART NAME SUPPLIER ds RRR EERSTE anmenm iome 6 12345 1 4 BOLT 35 aj E She 12346 3 8 BOLT 35 83 12347 1 2 BOLT 35 Di 12348 5 8 BOLT 83 10 12349 3 4 BOLT 83 ae Dai 12350 7 8 BOLT 83 x w2 12351 1 BOLT 83 13s 12353 1 1 4 BOLT 35 i 14 gj I5 s EXAMPLE cursor Al current Al L R current type i data contents a z edit CalcStar c 1981 c o MicroPro Int l CS9999xx rv_A l LSI ADM 3A kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk As a result of the extended screen command you will be able to view five more rows of the CalcStar array This wi
82. ide or we can use the repetition function For reasons which will be obvious in a minute let s use the repetition function With the cursor at A2 enter lt RETURN gt Once we hit lt RETURN gt the location A2 is filled with dashes The repetition function takes whatever string of characters is following the repetition symbol and repeats it for the entire width of the column no matter how wide the column is for an example of a repeated string of more than one character please refer to APPENDIX A example 3 step 15 Li 9 CalcStar User s Manual 7 Operations II 8 THE COPY COMMAND Now that we have dashes in one location A2 we would like to copy them into locations B2 through L2 Here is a summary of how we can use the Copy command to accomplish this in one operation computer prompt your response explanation edit access comand directory Command C access Copy command from coord gt coord A2 lt CR gt copy value at A2 to coord gt coord B2 gt L2 lt CR gt copy into B2 thru L2 Now there should be dashes throughout row 2 from column A to column L NOTE If we had entered 19 dashes at A2 the field was 19 spaces wide instead of performing the repetition function when we copied A2 into B2 through L2 we would have had 19 dashes in each column and the result would have been less attractive since the columns are all of different widths What we did was to copy the repetition function to fill the entire w
83. idth of the column with the specified characters from column to column and so the result was dashes throughout each column no matter what its width In general there are four choices with the copy function You may copy l from an entry to an entry 2 from an entry to a range of entries 3 from a range of entries to a range of entries 4 from a range of entries to an entry 4 above is actually a shorthand way of copying from a range into a range The system will count how many entries are in your range that you are copying from and will copy that range into a range starting from the single entry that you specify For example if you say copy A2 gt C2 into A3 the system will actually copy A2 gt C2 into A3 gt C3 So there are really only three choices with the Copy command There is one other point that should be brought out regarding the Copy command If you are copying a numerical value or values or a formula into a range of coordinates then before copying the prompt will ask R elative or N o adjustment II 19 CalcStar User s Manual Operations If the value you are copying will stay constant throughout the range of entries you are copying into then enter N If the value is a formula and will change as it is copied from one location into another then enter R so the formula will be copied and will adjust all the coordinates automatically for you so the formula will be relative to the new location Examples of both
84. ion stored at that entry Now we have the slopes for the three regression functions we entered and you can get a rough estimate of the correlation between the values regressed against each other For example the second regression function results in a slope of 11 22 This informs us that sales are decreasing about 11 units on the average as each month passes by A good rule of thumb is to execute a recalculate command for each time you use a project dependent or slope function unless you enter the regres Sion function to be used with it immediately previous to entering the project dependent or slope function Another very important rule to remember to insure correctness is to have your slope dependent and or II 64 CalcStar User s Manual Operations project function after the regression function which it uses but before the next regression function By after we mean to the right of it if it is on the same line or on a line below the regression function otherwise By before the next regression function we mean to the left of it if it is on the same line and on a line above the regression function otherwise This is because the recalculate command proceeds in a left to right order from the top to the bottom of the array By having your project dependent and slope function after the regression function but before the next one you insure that it is evaluated according to the proper regression function The best advice is to locate your s
85. ion which has other values dependent on it This is a blessing since you could accidentally delete values which would cause many other values to become undefined as a result In order to delete entries that have other values dependent on them you need to change the formulas that are dependent on the values you would like to delete and then the system will let you delete them In order to change the formulas that are dependent on the row which we would like to delete follow these steps l Goto Al4 Change the entry to CNT A4 gt Al1 1 2 Goto I14 Change the entry to SUM I4 gt I11 3 Goto Jl4 Change the entry to SUM J4 gt J11 4 Goto Kl4 Change the entry to SUM K4 gt Kl1 5 Goto Ll4 Change the entry to SUM L4 gt L11 Move the cursor to location Al2 Now repeat the above steps to execute the Delete command This time after you enter R to let the system know that you would like to delete row 12 the prompt will ask verify Y N This prompt insures that you really would like to make the deletion that you say you want to It insures against accidentally deleting something that you really would like to save If you answer N the Deletion command will be aborted and control will return to the edit line If you answer Y the deletion will occur and then any following rows or columns will be moved up Or to the left to fill in the gap of the deleted row or column II 40 CalcStar User s Manual Operations The
86. it into the remaining locations in order to avoid having to enter each part number individually So follow these steps to enter the rest of the part numbers II 13 CalcStar User s Manual Operations computer prompt your response explanation edit access command directory Command C access Copy command from coord gt coord A5 lt CR gt copy value at A5 to coord gt coord A6 gt A11 lt CR gt copy into A6 gt All R elative or N o adjustment R value will change from entry to entry NOTE This time we chose R for relative adjustment If we had chosen N for no adjustment the result would have been the value 12346 in locations A6 through All because the formula for each location would have been l A4 But since R was selected each value was obtained by adding 1 to the preceeding value i e the formula for A6 became 1 A5 etc Now your screen should match the following replication kkkxkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock _ Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit Gor lt TAB gt Goto lt ESC gt Cancel IC ID FRO Wa ne rte anana naa aana m aine a PART PART
87. ith our other fantasy file called standard inventory Load position Al lt CR gt we would like the upper left corner of STDINV to be at Al The results of merging our STDINV file with our INVDATA file at the same location as the illustrations above is shown below KKEKKEKKKKEKEKEKEKEKKEKEEEEKEKKKEKKKKEKEREEEEREKEEKKEEEKEEKEKKEKEEKKKEKKEEKEKEEEEEKEKE Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl x Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel Col gt C ID E F 3 8 ROW eeaeee emam aema a e aan e aeaa aaee 1 gt SUPPLIER lt SUPPLIER NAME PRICE COST REE REED ENERE a EEEENEERERED a a a a 3s s ds 35 ACME 0 02 6 015 5 35 ACME 8 82 0 821 6 35 ACME 0 83 029 7s 83 UNIVERSAL 9 85 0 041 8 83 UNIVERSAL 0 97 0 857 9 83 UNIVERSAL 9 10 6 988 16 83 UNIVERSAL 9 15 9 112 ofr saae moma ener nme ss nets ee ne ce ce en oem en se me ees pe SS Se Se en ST SN SE Se eeu mee ne K i cursor Cl current Cl L R current type text right justified x data contents SUPPLIER edit kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk II 37 kk CalcStar User s Manual Op
88. kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Col gt jA B IC ID E ROW ne SS a a a E lf ItemM sesooesooooosoee truck 2 Initial Value 12809 3 Depreciation Rate gt 30 lt 4 Year Acquired ceceoese 1981 5 Residual Value 1580 6 erent re remain fae te aa SERENE ERED ETE EN seamana ama ana 4 Year Dep Exp Acc Dep Book Val B Soca ssocsscsse sesscscsses soe 9 12860 16 1982 3600 3680 8490 ae eG 1983 25208 6120 5886 12 1984 1764 7884 4116 131 1985 1234 9118 2881 14 1986 864 9983 2016 15 1987 605 19588 1411 E memean mamaaa amamma ama ae aanne am aama a a Se a e aeaee SUN aaa s cursor B3 current B3 L R current type numeric data contents 1586 edit _ t t HF HF HH HF HF HF HF H HF HF FH FF kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk A more direct method of moving the cursor to the intended cell is to use the Goto command For example to make changes in cell B5 instead of using the cursor motion keys E X D S use the Goto command To invoke the Goto command press lt TAB gt In the lower left of the screen the prompt GOTO gt Al appears Pressing lt RETURN gt will move the cursor to the default cell Al However since B5 is the intended destination type B5 lt RETURN gt The cursor now appears in cell B5 If you want a printout of the screen display invoke
89. kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit Gor lt TAB gt Goto lt ESC gt Cancel Col gt A IB IC D E E ROWA eeen eara aeo me eaae ee oam a a ens aae ena rer a aa ae tn en 1 TCOM E E E E truck 2 Initial Value S 126080 3 Depreciation Rate 25 4 Year Acquired ccccces 1981 5 Residual Value S gt 1580 lt K aG a a a ca eee a Year Dep Exp Acc Dep Book Val B sso sess sss Se x 9 12088 16 1982 3000 3080 9908 k tee a ah he g cursor B5 current B5 L R current type numeric data contents 1590 edit GalcStar c 1981 c o MicroPro Int l CS9999XX rv_nnn terminal type t ete ee He SE HF HH HH SE Ee FF KH HF HF F F kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk If you want a larger display of the depreciation table you can turn off the Help Menu with the Extend command To invoke the Extend command type The display will immediately expand from a ten to a fifteen row display To return to a ten row display repeat the command One way in which CalcStar can be very helpful is by
90. kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc lt CR gt Right JA Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit Gor lt TAB gt Goto lt ESC gt Cancel Col gt A IB IC ID E BRO Warr rrnrnrrrere eee enema enema ca eR e ee 1l gt Summer of lt Summer of Summer of Summer of 2 78 79 80 81 3 si ema ip ie ce ms pm eb ec iss fpr a erage pene Ie 4 Net sales 4000 4800 4848 5575 5 Cost of goods sold 3900 3688 3636 4181 6 Se T ee E T O E eee een ener k 7 Gross profit on sales 1960 1268 1212 1394 8 RETESRUEESEEEENT SAD A antmawnemreemenenee 9 Operating expenses 18 Selling expenses 499 480 485 558 me eer etn ect ere ro ee are SN Rs poten Ge Ge SS Pr tS er itt Gr Sr rere an eraa a ae P cursor Bl current Bl L R current type text right justified z data contents Summer of edit _ kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Suppose you had to find the pre tax income for the summer of 1981 If you guessed that this number was in cell E16 you could use the Goto command to move the cursor to cell E16 After sending the cursor to E16 the row and column headings
91. kkkkkkkkkkkkkkkkkxk This ability to alter the load position can be very useful especially in conjunction with the Merge command It now becomes possible to construct reports and models in modules and then mix and match them on the screen to put together all kinds of useful variations For instance you could con struct a check writing module in one file and a payroll file in another module and then combine the two to make payday a lot less work One point to keep in mind is that the file that you are Merging onto the CalcStar array will override the existing file if entries in both files have the same coordinate address So once again we recommend that you save the file before merging on a new file if you have made any changes since loading it into the CalcStar array II 31 THE EXTENDED SCREEN COMMAND At times you will probably find that it would be very convenient if you could get a look at the entire array However we are limited by the size of the screen on your computer Most screens will display 22 lines and either 48 or 88 columns We have attempted to maximize the space by giving you all the information on the screen you will need and at the same time allowing you to see a fairly large portion of the array We have included an option which will allow you to change the screen display according to your needs II 67 CalcStar User s Manual Operations The extended screen command allows you to switch to an alternate screen mask w
92. l Illustrated below is the screen display that would result if we were to isolate columns C D E and F in our STDINV file kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel k Col gt C ID E F FRO Wop ema eea aemm a eaaa aeea Js SUPPLIER lt SUPPLIER NAME PRICE COST De aonana SAT LRA cena oma a 3e 4 35 ACME x e338 35 ACME 6 35 ACME As 83 UNIVERSAL x 8s 83 UNIVERSAL 9 83 UNIVERSAL 2 10 83 UNIVERSAL x Sr wn sence wan te ese om Arc cn man K cursor Cl current Cl L R current type text right justified x data contents SUPPLIER is edit k A ke k k de k he de e KKK KKK KKK IKKE KEKE EEE KKK ERE KEKE k k de e k AERIS SEE k k k ke k k k ESI AA k k k k k k k k k k 11i 35 CalcStar User s Manual Operations As you can see the values for the price and cost of all the bolts have gt been left out of the STDINV file The reason for this is the information contained in the STDINV file is subject to very little change and therefore can be stored in a sep
93. l situation with which to work With the infor mation given we may now use the regression function to compute a linear equation which may then be used to compute the best linear estimators of values we wish to forecast The regression function allows you to enter one range of entry locations followed by a comma followed by the first coordi nate of the second range of entries The number of entries within each range must be the same and that is why you only need to enter the first coordinate of the second range The values contained within the first range of entries are the values for your independent variable Independent variable is a statistical term which basically means that the value of the variable is determined independently from the values of other variables In contrast the second range of entries contain the values for your dependent variable The dependent variable is the one which you are assuming is influenced by other factors besides itself To clarify all this in one of the examples in this section we will assume the amount of sales to be dependent on the amount of money spent on advertising In this case the money spent on advertising will be our independent variable and the amount of sales will be our depen dent variable Most likely in the real world sales will not be completely determined by the amount of advertising we do but we can get a pretty good idea of how sales have correlated with advertising expense II 69 Cal
94. like to be on the first title line When we hit RETURN the prompt will repeat and we may then enter in what we would like for the second line of the title So each time the prompt appears it will be another line of title When you have as many lines of title as you wish answer the prompt by only hitting the lt RETURN gt key For our first title line enter EXAMPLE INVENTORY FILE SUBSECTION as shown below and then hit lt RETURN gt The title line will print immediately eeeoovoeaeeceeecoeoeosesvseooe eeoeeeovoeoeecoeaoseeveesocesveoeseoeeseeaeoneee0e0 82808 e Title gt EXAMPLE INVENTORY FILE SUBSECTION For the second title line enter PRINTOUT 2 and then hit lt RETURN gt eeeoeeeoevoevoeveosvs seooaooeecevoeesceeoeeveveeoeecweeoeaoeevnevneeoeeoneeene ee ees Title gt PRINTOUT 2 d e eeeecea oa Ceoeoeeveeveeegceeoeaoseeaeeeoeeosoeoeveeoseeoeevoeevoeaeneveanea7cneene one ee 8 The next time the title prompt is repeated do not enter anything before hitting lt RETURN gt The report will begin printing After the printing 1s completed the next promt displayed is e End of report e Hit space to continue After hitting lt SPACE gt control will be returned to the edit line You should now have your second printout and hopefully feel comfortable in knowing how to use the Print command to your best advantage Ti 5 CalcStar User s Manual Operations 11 28 THE PAGE FUNCTION There is anothe
95. list of values composed of the range Al through Ll inclusive location B3 and the range from AAl through AAl2 inclusive These functions can prove to be very useful by saving you from having to compute each of the values at the given location and then comparing them to come up with the largest or the smallest value The answer to your expressions will be displayed on the line below the edit line II 1 CalcStar User s Manual Operations Later when you are in the middle of a report you can even use location coordinates in the arithmetic expression and the value at that location will be used in your calculation For example 119 F4 will give you the result of taking 110 of the value stored at location F4 If you enter an expression which evaluates to something divided by zero the system will display n to let you know that it cannot perform such an operation CalcStar has its limits II 2 CURSOR MOVEMENTS We can summarize the ways in which to move the cursor with the following table ACTION RESULT CTRL E E will move the cursor to the row directly above its present location unless the cursor is in row 1 in which case there would be no movement CIRL X X will move the cursor to the row directly below its present location unless the cursor is in row 255 in which case there would be no movement CTRL D D will move the cursor one column to the right from its present location unless the cursor is in colu
96. ll prove to be very convenient at times instead of being forced to move the cursor to change the screen II 68 CalcStar User s Manual Operations display to another section of the array Anytime you would like to return to the standard display to reference the command list or for whatever reason type the same command and the usual 18 row display will return II 32 THE QUIT COMMAND There are still a few commands which we have not demonstrated The Quit and Help commands may be utilized at any time you are working on CalcStar and so we have included them at the end of the Operations section for easy reference The Quit command is used for quitting the CalcStar program and returning to CP M When you are finished working with CalcStar then save your file if you would like to have a record of it for later use After the file is saved you may execute the following steps to guit the program computer prompt your response explanation edit access comand directory Command Q access Quit command verify Y N Y or N see below If you enter N to the prompt to verify quitting the CalcStar program the Quit command will be aborted and control will be returned to the CalcStar edit line If you answer Y to the above prompt CalcStar will terminate Operations and the CP M prompt will be displayed I1 33 THE HELP COMMAND The Help command serves as a very convenient and useful directory to the functions of the various operations
97. lope dependent and or project functions in the locations immediately to the right of the regression function This only makes sense anyway Since the regression function will almost always be used in conjunction with one or more of the other three functions In our discussion of our SALES example we have ignored one possible complication For some businesses seasonal effects pose a problem to linear regression In a case like this rather than perform a regression on all the months of one year you could use the data for the same month over the last few years and perform a regression on this data We hope the linear regression capability of CalcStar will prove to be extremely useful to you Linear regression can be a very valuable tool in assisting you to recognize trends based on past data and thus helping you to make some educated guesses about the future Linear regression does not prove a cause and effect relationship but it does give an indication of how changes in one area will correlate with changes in another area and this in itself may be enough Used as an aid regression will help you in any type of forecasting you would like to perform II 38 THE LOAD COMMAND The Load command is utilized to reload files into the CalcStar main menu To demonstrate the Load command we will first clear the screen of our SALES file and then reload EXAMPLE back into the CalcStar array Make sure you have saved SALES and then follow these steps to clea
98. ly below it accurate to 1 place The steps to setting an individual decimal precision entry are very similar to the steps for setting the decimal precision for a whole column with one exception as illustrated below computer prompt your response explanation edit access command directory Command F access Format command P recision 2 or W idth 18 P alter decimal precision or Form Mode clear Column A precision 19 E lt CR gt change decimal precision to only at cursor location To set the decimal precision for an individual entry you must enter E before the number of decimal places The above steps would change the Gecimal precision only at the cursor location and not at any other location in the array The next step is to determine a formula for calculating what the next part will be In this case since the part s are in sequence each part is determined by adding 1 to the previous part So at location A5 enter l A4 The middle section of the main menu will show E SE SE SE SE SE S S E e E eae oso eee eveeoeeoasaneeneoeeaeeaszpe oes eve type numeric contents 1 A4 s n edit a This tells you l when you entered l the entry was interpreted as numeric 2 the contents are equal to 1 plus the value stored at A4 3 the numeric value is automatically right justified Notice that in the window at location A5 the value reads 12346 The main purpose in entering this formula was to be able to copy
99. meric entry Since we are handling part numbers which don t need decimal places it would be helpful if we could change the number of decimal places to 8 IT 18 THE FORMAT PRECISION COMMAND With the Format Command there is a way to specify from to 18 decimal places The steps to set the decimal precision at are as follows computer prompt your response explanation edit og access command directory Command F access Format command P recision 2 or W idth 18 P alter decimal precision or Form Mode clear Column A precision 9 19 9 lt CR gt change decimal precision to 9 Now the value at location A4 should read 12345 our desired number NOTE CalcStar allows you to have a decimal precision of 9 to 19 places You may find your numbers being converted to exponential form if the column width is not large enough e g 98900735 would be converted to 7 35E 6 if your column width was 8 A number is displayed with as many decimal places as you specify with the format precision command Numbers are not rounded but are truncated cut off However CalcStar retains 12 decimal places of precision for calculation purposes ITI 12 CalcStar User s Manual Operations CalcStar also allows you the possibility of specifying the decimal precision for any individual entry This means you may have values of different decimal precision even within the same column One entry may be accurate to 9 places and the value direct
100. ming if there was no way to specify individual column width so we have made the extra effort to give you this flexibility You are allowed up to 26 charac ters for a data entry so there will be some situations in which we must widen the column With CalcStar you can specify columns to be anywhere from 3 to 63 characters wide Here are the steps to widening a column computer prompt your response explanation edit access command directory Command F access Format command _P recision 2 or W idth 1 W to alter column width or Form Mode clear Column B width 3 63 15 lt CR gt widen column to 15 spaces ITI 6 CalcStar User s Manual Operations This will result in our column being widened from the standard width of 18 spaces to the width of 15 spaces that we chose One point to remember is when you widen the location Bl it also widens locations B2 through B255 Simultaneously That is when you widen one location you are widening the entire column NOTE If we find that we have accidentally accessed a command operation that we really do not need we may abort that operation in one of two ways If the system is waiting for one keystroke only we may enter lt ESC gt to return control to the edit line If the system is waiting for an entry and then a lt RETURN gt we need only hit lt RETURN gt without typing anything else Let s move on to location Cl This time let s change the column width first This will save us some tr
101. mmand in order to display the column and row nore first Goto Al Then enter Answer the prompt Lock R ow C ol B oth with a B Finally Goto J4 II 28 CalcStar User s Manual Operations e de ke Fe de ke k k He k He de KEE e k e e He RE e He IKE EEE EEE RE KEE RE REE He k k k k KERR EKER de de k k ke ke k ERE de k kek k k k kk k Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel S Left D Right C Copy H Help OOrder S Save Lock Evaluate Col gt A J K IL FRO Wr nn nr recent nena een m seen serene aa ee I kx xl PART QUANTITY ON HAND QUANTITY ORDERED Do reece aeaaee aie ie i a i ha x 3e 4s 12345 gt 2128 lt 2880 5 12346 2900 21898 6 12347 3788 1228 7s 12348 3116 1896 8s 12349 4195 885 9 12358 3063 1937 18 12351 1918 3082 en a cursor J4 current J4 L R x current type numeric x data contents 2120 edit kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk As a result of executing the extended What command the first row and the first column of the CalcStar array are displayed and columns J K and L are moved to the right by one column Notice tha
102. mn DW in which case there would be no movement CTRL S S will move the cursor one column to the left from its present location unless the cursor is in column A in which case there would be no movement CTRL Z Z If the direction indicator is L R CIRL Z will move the cursor to the first column of the next row unless the cursor is in row 255 in which case there would be no movement If the direction indicator is T B it will move the cursor to the first row of the next colum lt RETURN gt will move the cursor one column to the right if the edit Or line is blank unless the direction indicator is T B If you have typed an entry on the edit lt CR gt line lt RETURN gt will enter the data into the current location and the cursor will be at the current location Hit lt RETURN gt again and the cursor will move one column to the right If the cursor is in column DW then hitting lt RETURN gt will cause the cursor to move to the first column of the next line If the direction indicator is T B the movement is down rather than right II 2 CalcStar User s Manual Operations lt TAB gt will present the prompt Goto gt Al below the edit line You may now enter any coordinate on the array and then lt RETURN gt and the cursor will move to that location If you would like to jump to the upper left corner of the array Al you only need to hit lt RETURN gt and by default the cursor will jump to Al a very useful key lt
103. n The message now displayed below the edit line reads Form mode set Repeat this procedure for locations F5 through Fll and J4 through Jll We will re enter the information shortly Once all the form modes have been set for the values in columns F and J move the cursor back to location Al Now imagine that you have received updated information for the cost of the bolts and the present quantity on hand Instead of moving the cursor all over we may execute the following steps to input our new data computer prompt your response explanation edit access command directory Command A access Auto command The cursor jumps to location F4 the entry where the first form mode was set The entry is blank and waiting for a new cost value Enter 15 When you hit RETURN the entry is made and cursor jumps to location J4 the II 47 CalcStar User s Manual Operations next form mode on row 4 At J4 enter 2120 our new data for the number of 1 4 bolts on hand Once again when you hit RETURN the entry is made and the cursor jumps to location A5 You may continue to use the Auto command in this same way to enter the rest of the data F5 921 J5 2999 F6 929 J6 3780 F7 041 J7 3116 F8 958 J8 4195 FQ 8l J9 3963 Fl 113 gle 1918 Fll 158 Jll 9 After entering the last of the data CalcStar will automatically recalculate all formulas in the array NOTE Remember if
104. n be moved to view any section of the array The cursor location is the present coordinate to which the cursor has gt a v been moved When CalcStar is first accessed the cursor location z indicator tells you that the cursor is at location Al The current location indicator tells you where the next entered data will be stored As we Shall see the cursor location and the current location can be different Once the data has been entered the cursor location jumps to the current location and they are both the same CalcStar User s Manual Overview The lower section of the main menu iS where most of the action takes place The two items on the left current and data never change so you can ignore them from now on The three lines on the right however are very important Let s summarize their importance 1 TYPE indicates whether the information stored at the current location is numeric or text non numeric It also indicates in the case of text whether the entry is displayed on the left side of the column left justified on the right side of the column right justified centered center justified or repeated across the column repeated If the current location is blank the type line will be blank If an entry has been deleted the type line will show that memory space has been allocated but is currently empty 2 CONTENTS displays what was entered at the current location If the entry was tex
105. n hit lt RETURN gt If we would like to load the report at another location enter the coordinate for the location or move the cursor to the location you would like to have as the upper left hand corner and type the symbol For example type L to access the Load command again and then type EXAMPLE but this time enter B3 as the load position Your screen will now resemble the following II 66 CalcStar User s Manual Operations KKEKKEKKEKEKEKEKEKEKKEKEKEREKKEREEKEKEKEKEREEEKEKEREKEEEKEKEKEKEKEKEKEKERKEKEKEKEKEKESR Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down ID Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel CoL gt A IB Ic ID ROW nn x 2 X 33 gt PART lt PART NAME SUPPLIER k k amp e RETR anemmmnmenemanasenanmean amneawunemasaennn ae 5 6 12345 1 4 BOLT 35 7 12346 3 8 BOLT 35 8 12347 1 2 BOLT 35 9 12348 5 8 BOLT 83 16 12349 3 4 BOLT 83 ko en eaaa e EXAMPLE cursor B3 current B3 L R current type text right justified data contents PART edit e Ht H He HF HH HS HF FE HF HF HF HW F kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
106. nd The Edge command locates the cursor and moves the cursor location the coor dinate where the cursor presently is to the upper left hand corner of the display window and then displays the next 18 rows down from the cursor location and however many columns to the right of the cursor location that the screen will fit This command will be useful in many instances in which you would like to isolate a specific section of data on the display screen To execute the Edge command the first action you should take is to move the cursor to the location that you would like to be the upper left hand corner of the window We would like to isolate the price and cost values so move the cursor to location E4 Now enter and then enter E Within the window should be two columns of numbers resembling the following illus tration kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Comands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy 4H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel Col gt E IF IG IH ROW re 4 gt 02 lt 9 015 id 5 0 83 8 021 6 8 04 8 929 gi 7 9 85 9 041 Be 8 98 9 958 x 9 8 11 0 881 x 16 0 15 0 113 11
107. nd toes the system will compute these values in one SEER by using system functions For instance instead of writing a formula to add up L4 L5 Lll to compute the total cost of the order we can use one system function to compute it automatically This would be even more useful if we had 58 parts in our inventory Otherwise our formulas would become unmanageable Goto L12 and use the repetition function to underline the column with dashes Now at location L13 enter SUM L4 gt L11 This will tell us l the entry is numeric not text You could also use the key 2 SUM the system function to calculate the sum of the given list of values II 38 CalcStar User s Manual Operations 3 L4 gt L11 the range of values to be summed Single values may be separated by commas and a range of values may be shown as they are in this example You may sum any values from anywhere in the CalcStar array Once the above function is entered at L13 you should see the result of 854 48 in the window at L13 This means the total cost of the order was 854 48 Wasn t that easy Now we can give you a little practice at working with system functions Goto I12 and underline the column and then copy that to J12 through K12 Next Goto I13 and then enter the SUM function as shown above with the range of I4 through Ill This will inform us of the total number of bolts that should be in the store the result should equ
108. nditional statement will evaluate the condition you enter and then depending on whether the condition is true or false the system will execute one statement you specify if the condition is true or else it will execute another statement that you may specify if the condition is false This opens up virtually unlimited possibilities so let s demonstrate a simple example and then generalize on further possibilities For our first conditional example let s examine the case of what happens when we have more parts on hand than we usually stock for any one particular good As the report stands at this time when the amount on hand is subtracted from the amount stocked a negative answer will result This answer is multiplied by the cost and will yield a negative total cost for amount ordered of this part This presents a problem since it is doubtful we will be able to get our suppliers to pay us for ordering parts from them Our solution is to use a conditional expression to determine whether the amount on hand is greater than the amount stocked If it is the amount ordered will become If the amount on hand is less than the amount stocked then we will subtract in the way we have been doing in order to find out how many parts we should order Are you ready to try this out The summary of actions is shown and you may follow along and then we will explain the general form of how to enter conditional statements First move the cursor to location K4
109. ne will display regr B2 gt G2 B4 s ccacccce o CalcStar User s Manual Introduction This character sequence establishes a regression constant that is necessary for all linear regression functions The regression constant for the most part is not important and therefore is replaced by a Series of dots in the screen display Moving the cursor one block to the right will display the Character sequence used to calculate the projected sales for the summer of 1985 The projection figure immediately below is done similarly except that it displays a projection with respect to a hypothetical advertising expense instead of a projection with respect to time The next figure below is called a dependency In effect the figure explains that a sales of 15 000 depends on an investment of 1 127 in advertising The CalcStar user s Manual provides further information on linear regression functions You now have some ideas about how CalcStar can be tailored to your needs You can also combine two other capabilities with CalcStar interfacing CalcStar files with WordStar and creating compatible files for CalcStar DataStar MailMerge SuperSort and BASIC You can use WordStar to enhance a depreciation report such as the one in DEMO Follow the procedure below to prepare the file for use by WordStar This procedure assumes the subject file is loaded l Invoke the print command with P 2 Instead of defaulting to the printer divert the outp
110. nformation x Insert Insert a row or column into the array Load Load a file into the array Merge overlay file onto array Order Change the evaluation colum row order of the array Print Print a report Quit exit the report generator Recalculate recompute entry at cursor or whole array in current order x Save Save the array to a file a What if text prints lst colum amp row entries of cursor position gj print approximate storage space in terms of entries a lock colum A and row 1 onto display Switch between 18 with menu and 15 row screen display ot OF OF Ot OO OO OO OO OO OOO OO kkkkkkkkkkkkkkkkkkkkkkkk kk kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk After you hit the lt RETURN gt key for the last page of the Help directory the Help directory will be replaced by the main menu just as you left it and control will be returned to the edit line II 34 EVALUATION OF INPUT DATA CalcStar has the capability of recomputing an input value before it is stored in the tableau For example suppose you wanted to enter the data for a previous period adjusted for inflation That is you want to enter the data for last year with the addition of a 10 adjustment for inflation To accomplish this you would type 111 after positioning the cursor over the cell you wished to have so augmented The indeterminate value n will appear in that cell and it will remain there until you have entered a number F
111. ng and editing columns of numbers can now be relieved CalcStar can help you to increase the productivity of your organization by taking the fullest advantage of the greater speed efficiency and flexi bility of a computer system Some of the possible applications for CalcStar include balance statements cash flow analysis amp forecasting general ledger inventory records job cost estimates market share analysis amp planning patient records profit projections profit statements project budgeting and control Salary records sales projections amp records tax estimation With CalcStar you will be manipulating data either text or numeric on a visually oriented display The numeric data may either be constant or be dependent on other data CalcStar has facilities for editing formatting storing calculating and printing the data that you enter into the computer system There s no better way to become familiar with CalcStar than to jump right in and get your feet wet This manual will strive to lead you clearly through each step of operation of CalcStar so that you will have a thorough knowledge of the possibilities available To accomplish this we will use a Simple inventory record for an example There will be plenty of practice for you once each step of operation has been demonstrated I 2 ACCESS We are now ready to introduce the CalcStar main menu First of all turn the power on for your machine and insert the prop
112. ng the calculation you need into an entry in the CalcStar array and then having to remove it With the calculator function anytime you need a quick calculation it s available right away To utilize the calculator type in your arithmetic expression on the edit line and follow the expression by a NOTE use t for addition for subtraction for multiplication for division for percentages MAX list to find the maximum value in the list and MIN list to find the minimum value in the list For example 45 89 25 5 125 9 3 18 36 6 120 18 53333 314159265359 179 4825 7 MAX E4 F1 gt F13 H9 MIN Al gt Ll B3 AAL gt AA12 NOTE The use of parentheses is sometimes necessary to insure that the sequence of arithmetic operations takes place as you would like it to The middle example above illustrates a special feature of CalcStar The program is accurate to 14 decimal places The external or displayable accuracy is 12 places whether the number includes a decimal point or not The number appearing on the screen will always be accurate to 12 places The last two examples above are called system functions and will be discussed thoroughly in a later section of this manual Briefly the MAX example will find the maximum value in the list composed of locations E4 F1 through F13 all the locations within that range i e F1 Fll F12 and F13 and H9 The MIN example will find the minimum in the
113. nlocked the Lock command will Lock it if you are in Lock mode the display will be Unlocked You may also Lock only rows or only columns or both When the prompt R ow C ol B oth appears the appropriate action will be taken relative to the response and the cursor position Try it to see what happens If you choose any response other than B oth the unselected item will toggle For example suppose you lock only rows 1 and 2 Then you decide to lock column A The rows will now be unlocked The best course of action to take in this case is to first unlock the rows position the cursor at A2 and then lock B oth If you are ever in doubt about the locked unlocked status of rows or columns consult the screen for the presence of asterisks next to the row and column labels NOTE If you lock the screen with the cursor too far into the tableau you may not be able to get the cursor onto the screen and the message CURSOR OFF SCREEN will appear accompanied by a bell or beep from the keyboard The best action to take is to Unlock reposition the cursor in a more useful place and then Lock II 17 SYSTEM FUNCTIONS Now we have a chance to demonstrate one of the most powerful advantages of a computer report writer Let s say that we would like to know the total cost of the order for all bolts the total number of bolts stocked on hand and on order and the number of different bolts Instead of counting in our heads or on our fingers a
114. of the dependent range so we might as well leave the screen as uncluttered as possible The regression function which computes a linear equation from the two ranges you have entered is the first of two steps to forecasting with CalcStar Once you have used the regression function you have a choice of three other functions to use in conjunction with the i atte function These three functions include the following l proj allows you to enter a value for an independent variable and then the best estimate for the dependent variable will be calculated and entered into the current cursor location 2 depd allows you to enter a value for the dependent variable and then the best estimate for the independent variable is calculated and entered into the current cursor location 3 slope allows you to have the system enter the slope of the linear equation computed from the regression function into the current cursor location The slope gives you a rough estimate of the correlation between the independent variable and the dependent variable If the slope is 3 it means that for a change of 1 in the independent variable you will get a change 38 times that size in the dependent variable If the slope is 2 it means that for an increase of 1 in the independent variable you will get a decrease of 2 in the dependent variable As an example this information can tell you if as advertising expenses increase there is a simul taneous increase or
115. of these operations will be given in this manual II 9 NUMERICAL DATA ENTRY A numerical expression may be entered into any location in the CalcStar array Remember an expression may be constant or variable The terms of the expression may be a l number 2 coordinate reference in which case the coordinate is replaced by the value stored at that coordinate 3 system function an arithmetic operation which the system already knows how to do without explicit directions You must specify which function and on what argument list list of values the function is to operate The available system functions for CalcStar are SUM summation of values in argument list CNT number of items in list that are numerically valued AVG mean value i e SUM CNT MAX the maximum value in the list MIN the minimum value in the list SORT square root LOG logarithim base 19 LN natural logarithim ABS absolute value EXP exponent non The values that are contained within the argument list of a system function may be any of the following l reference coordinate e g F4 2 range of reference coordinates e g F4 gt F19 3 other expressions With this in mind it s obvious that there are a very large number of possible ways to manipulate numerical data with a minimum amount of complex ity and work As we proceed we shall demonstrate some simple applications of many of these possibilities We have tried to design Cal
116. on is a window into a small portion of the array The window shows 19 rows and from 1 to 15 columns lines of data in the horizontal direction The rows are designated as 1 2 3 through 255 COLUMN lines of data in the vertical direction The columns are designated as A B C through DW COORDINATE a position specification in the form columnrow For example the top left corner of the array is AL ENTRY a Single data item in the array An entry is located by a coordinate CURSOR the pointer gt lt at the current data location I 6 NOTE This is a different meaning for the word cursor than you may have encountered previously In CalcStar the cursor is NOT the little box below the display window FUNCTIONAL OVERVIEW For orientation purposes CalcStar can be divided into three sections and then explained according to the function of each of these sections A The upper section of the main menu displays a list of possible cursor movements and operation functions and commands This section never changes and is included mainly as a directory reminder for you to choose the operation that you need The middle section is composed of the window into CalcStar the cursor location indicator the current location indicator and the direction indicator The window allows you to view the report as it stands including all calculated numerical results that have been entered up to that point The window ca
117. or enter a new name such as NEWDEMO lt RETURN gt If the default is used you are asked if the old file contents should be destroyed or not If you respond with N then the save routine is stopped and control is return ed with no damage done to the original or the updated file If you respond with y then you are requested to respond as to whether a part of the worksheet or all of the worksheet should be saved Type A for all You are then allowed the option to protect the file with a password Or if you want to bypass this option press lt RETURN gt In the lower left of the dis play the row numbers will increment in periodic flashes CalcStar will display SAVED once the file has been saved The DEMO file was intended to show you what a reasonably complicated calcula tion might look like You will need to study the user s manual and work out your own examples which may include formulas like those in the DEMO table at cells El2 and B1 You set up the table in much the same way as you enter data For example move the cursor to cel E12 by pressing lt TAB gt and E12 lt RETURN gt The contents line at the bottom center of the screen display will contain the character sequence E11 B5 lt E11 Cl2 symbolizes a blank This character sequence is a conditional expression In English it means If the difference between the contents of cell B5 and contents of cell Bll is less than or equal to zero then put a blank in c
118. or instance if you enter 208 the calculated value 22 will replace the n in that cell Normally you would want to treat entire rows or columns in this fashion and the Copy command can be used to propagate the formula to the Gesired cells It is best to copy the formula before you enter any data in the table since the Copy will otherwise copy the value as well as the formula However as before the formula will apply only to the cell with which it is associated II 71 CalcStar User s Manual Operations Use of the Recalculate command will not affect these entries The function only applies when the data is entered initially 11 35 PROGRAM CSDUMP With CalcStar we have included a separate but very helpful secondary program called CSDUMP This support program allows you to print out a listing of the contents of the CalcStar array That means you may have a printed copy of all the formulas and specifications that are behind the scenes to create your nice report which only includes calculated results CSDUMP prints out each coordinate that has a data entry and informs you of the column width type of entry including justification if the entry is text and the contents of the entry The importance of CSDUMP is the ability to print out the contents of the report in order to be able to store it in a safe place In the case of a disk being ruined or lost or someone removing your report file you still Weer aA marar AF trme haw er
119. ort enter lt RETURN gt to the first title prompt For our first printout let s give our file a two line title For the first line of the title enter EXAMPLE INVENTORY FILE as shown below e Title gt EXAMPLE INVENTORY FILE After the above entry is made the prompt for title will be repeated so that we may enter the second line of our title For the second line of our title enter PRINTOUT 1 as illustrated below Title gt PRINTOUT 1 eeeosoescoeeev ee eoeveeeeveeeseeeevoeeeseeveeeve eaeeeeaneoeaeeeonedve e286 The third time the title prompt is displayed you may hit lt RETURN gt and the report will begin printing To abort the Print operation hit lt ESC gt If you specified earlier that you would like the printing to stop after each page is printed you will need to hit lt SPACE gt in order for the next page to be printed This will continue until the printing is finished After the printing is finished control will return to the edit line You will now have a complete printout of your inventory report II 27 THE PRINT COMMAND PARTIAL FILE In this section we would like to demonstrate how to print out a subsection of the file For example imagine you were asked to produce a printout that contained only the part names Supplier number and supplier name for the 5 8 3 4 and 7 8 bolts If CalcStar did not allow you so much flexibility with the Print command then we would either have to cut up a printo
120. other deletion choices besides row are entry If you enter E for the deletion prompt the system will delete the entry at the current location indicator without asking to verify the deletion If there are other values dependent on the entry you would like to delete the deletion WILL occur column If you enter C for the deletion prompt and there are no other values that are dependent on any of the values in the column you are trying to delete then the system will ask you to verify the deletion If you enter N the deletion will not occur If you enter Y the deletion will occur If there are any values anywhere in the report that are dependent on any of the values in the column you are trying to delete the deletion will not occur and an error message will be displayed all If you enter A and then enter Y to verify the deletion all the information on the screen will be deleted Whatever is still on the disk from the last time you saved the file will still be safe and available for you to load back into CalcStar BUT all the changes made since the last time you saved the file will be erased If you answer N to the prompt to verify the deletion the deletion will not occur and control will return to the edit line II 24 CONDITIONAL EXPRESSIONS We may now introduce one of the most sophisticated abilities of CalcStar The ability to incorporate conditional statements into a financial report generating system is very useful A co
121. other entry and set the form mode and so on until you have set the form mode for all the items of data in your file that are highly subject to change Now execute the Auto command and the cursor jumps to the first entry at which the form mode is set The Auto command has automatically deleted the previous value in that entry and you may now put in II 46 CalcStar User s Manual Operations your new information When you hit RETURN the cursor jumps to the next entry in that row or to the first entry in the next row at which you set the form mode deletes the previous value at the entry and you may enter your new information The Auto command proceeds in a row by row order through the file one entry at a time for each time RETURN is entered The purpose of the Auto command as was stated is to save you from having to hunt around the array looking for a specific piece of information With the Auto command you may automatically jump from entry to entry and make your editing work a lot easier In our EXAMPLE file the two categories of data which are most subject to change are QUANTITY ON HAND and COST We will demonstrate how much easier it is to edit using the Auto command First of all Goto F4 Here are the steps necessary to set the form mode computer prompt your response explanation edit access command directory Command F access Format command P recision or W idth 24 F set form mode at current or Form Mode clear locatio
122. oto C37 and enter C17 C24 196 and hen enter F P and EL Enter 3 C C37 D37 gt G37 and R and then Goto D37 E37 F37 and G37 and at each location enter F P and E1 e II Save the report 1 III Enter S QTRSALES 6 CalcStar User s Manual Appendices III Print the report l Enters 3 P lt CR gt lt CR gt G37 lt CR gt 132 N lt SPACE gt Sales Analysis by Quarter 1979 Beta IV Corporation lt CR gt If you would like to print another file s contents enter Y and the sequence of steps you have just completed will be repeated for another file If this printout was the last one you needed enter N and the CP M prompt will be re displayed and you may continue your work For our demonstration enter N since we will not need to repeat the demonstration III 7 CalcStar User s Manual Appendices APPENDIX B This appendix includes an alphabetical and symbolical listing of the function and command operations available with CalcStar and a short explan ation of the operation along with a reference to the section in this manual which describes the operation in detail 7A Automatic form mode for entering data in specific entries II 25 7C Copy entry or range of entries into an entry or range II 8 7D Delete an entry column row Or entire array 11 23 E moves the array so cursor location is upper left corner II 14 F
123. ouble if we try to enter an entry that is too long for the column Here is a summary of actions for column C computer prompt your response explanation edit access command directory Command F access Format command P recision 2 or W idth 19 wW to alter column width or Form Mode clear Column C width 3 63 15 lt CR gt widen column to 15 spaces edit RSUPPLIER lt CR gt enter data for Cl with right justification The rest of the column headings will be very similar to what we have demonstrated So now you can have an opportunity to practice entering text data Below is a summary of data that you may enter for columns D through L If you get stuck return to the outline of steps for column C and review the procedure Column D format the column to a width of 18 and then enter RSUPPLIER NAME Column E format the column to a width of 11 and then enter RPRICE Column F format the column to a width of 11 and then enter RCOST Column G format the column to a width of 18 and then enter 1 RPROFIT UNIT II 7 CalcStar User s Manual Operations Column H format the column to a width of 12 and then enter R amp PROFIT Column I format the column to a width of 24 and then enter RQUANTITY STOCKED a Column J format the column to a width of 24 and then enter RQUANTITY ON HAND Column K format the column to a width of 24 and then enter _ RQUANTITY ORDERED Column L format th
124. ow how regression can be used for both positive and negative trends Once your regression function has been entered move the cursor to location I6 and type proj 1 The result of 18 tells us that by October sales will have declined so much on this product as to be next to nothing If we were to enter ll or 12 the amount would be below zero informing us that we were building up unwanted inventory For the last example go to location H8 and type tregr B8 gt G8 B5 This example is the one we mentioned above where amount of money Spent on advertising is the independent variable and sales of the first product is the dependent variable Note that this regression function has the same mean for the dependent range as the first example This is because it has the same range of entries for the dependent variable You may enter the equation to return a blank entry with the regression function if you would like This time we will demonstrate the dependent function Move the cursor to location I8 and type tdepd 2000 This is asking for the best estimate of the amount of money you need to spend on advertising to result in a sales amount of 2000 If you were to enter proj 208 that would be asking for the amount of sales WITH advertising expenses of 2000 See the difference You are telling the system I want a sales level of 2 008 How much money will I need to spend on advertising in order to reach that level based on the da
125. ow offset 54 Terminator of position 56 59 Row before column OA if l then reverse Terminal end sequence 5C 65 Terminal initialize 66 6F III 13 CalcStar User s Manual Appendices INSTCS uses two forms of input the data in INSTCS DAT and keyboard entries It always writes a new TERMCAP SYS file and it also may update INSTCS DAT if you condition it to do so The use of Method 3 may require the assistance of your dealer in determining the codes that must be filled in but the information should be available in the manual that came with your terminal Your configuration session will begin with your typing in response to the CP M prompt B gt INSTCS lt RETURN gt which will first display a sign on page and then ask the question Normal first time installation of CalcStar Y N A reply of Y will set you up for Method 2 You will see a table of terminal names and letters Let us suppose that your terminal is a Televideo 95 This has code B In answer to the prompt Please enter selection type a B The next prompt will say Current Terminal is Televideo 959 OK Y N A reply of Y will display the prompt Are the modifications now complete Y N A reply of Y will give you some messages about installing CalcStar and then the message Printer is accessed through normal CP M LST device channel OK Y N A reply of Y will end the install process and present a CP M prompt What has happened is this INSTCS has r
126. ple file in this manual One of our reasons for choosing an inventory report lies in the Simplicity of the entries involved in the report By using an inventory example no one will be confused with this manual because of their lack of familiarity with financial reports Everyone can feel at home with an inven tory report which basically counts the number of parts you have on hand how many parts you usually stock and the resultant number of parts you wish to order So we felt that an inventory report would be universally applicable to all and therefore lend to the clarity and usefulness of this manual A second reason for choosing an inventory report is to demonstrate the wide range of applications available with CalcStar The CalcStar program may be used for virtually any type of report not just for financial reports II 4 CalcStar User s Manual 7 Operations In our example we will enter in a report that lists 8 different sizes of bolts and we will keep track of and manipulate some related information We do not need to be concerned with entering a title for our report at the very beginning When we explain the PRINT operation we will see that we can add a title before the report is printed out II 4 TEXT DATA ENTRY Before we can begin with our inventory example we must clear the screen of our balance sheet file In order to clear the screen follow the steps below Remember the operations will be demonstrated later so don t worry i
127. pression is assigned a value of 1 and 1 is multiplied by the result of the second expression I5 J5 to obtain the number of parts on order which is entered into location K5 If the first expression is false the expression is assigned a value of and 9 is multiplied by the second expression to obtain a result of 8 So this expression will yield the same result as the first example To verify this change the on hand amount J5 to 7000 and then recalculate and observe the amount ordered to be at K5 Again to check that the true value of the conditional statement evaluates properly re enter 2998 at location J5 and then recalculate and compare these totals to our original totals In our third example we will demonstrate the use of the OR logical operator In this example you may imagine that the management has asked you to compose a list of all the parts in which the percentage profit is greater than 25 OR the quantity on order is more than 29 of the quantity that is usually stocked This is a list of your best selling parts or your parts that bring in the most profit A part may satisfy either one of these conditions to get on the list Since this is not a part of your official report but you would like to keep it in the same file in order to be able to print the list later we will move the cursor out to column N to store our list At location N4 enter K4 gt 20 14 H4 gt 25 09 and then copy the formula into location
128. price cost into location G4 Here are two of the possibilities the second alternative utilizes the function 1 At location G4 enter E4 F4 The sign in front of the E is optional but it is an easy way to insure that E4 is interpreted as a numeric entry rather then a text entry If you don t use the make sure to use the to change the entry type from text to numeric 2 a at location G4 enter a sign b move the cursor to location E4 While you re moving the cursor notice the current location indicator is remaining at location G4 When the cursor is at location E4 hit the key As you can see when you hit the key the system moves the cursor location into the edit line The key allows you to transfer a value at the cursor location into the current location without having to figure out the coordinate In order to lock the current location you will need to type in something on the edit line before moving the cursor For a numerical entry a or sign will do and for a text entry hitting the lt SPACE gt key will work cC enter a sign d now move the cursor to F4 and then enter the key and notice the result of F4 in your formula on the edit line e hit lt RETURN gt and at the location G4 the contents line will read h4 F4 This is our formula for the profit per unit At first glance this might seem to be more trouble than it s worth but if you re working down b
129. r function NOTE If you have been entering a long report and the message Memory Getting Low appears below the right side of the window you should not try to enter anything more Now we can enter the data for the price and the cost of the bolts and then calculate the profit unit and the profit values The price of the 1 4 bolt is 2 and each of the bolts after that is 48 higher than the previous bolt Again we can enter the data for the first entry then find a formula for the successive entries and copy that formula from location to location Move the cursor to location E4 At E4 you can enter the value 2 Since the next value is 49 higher than the preceeding value we can enter the formula 140 E4 at E5 The result in the window at E5 should be 3 NOTE Another advantage to writing a formula is in the event of a price change you only have to change the initial value and then the prices for the rest of the bolts can be automatically recalculated This operation will be demonstrated in a later section of this manual II 21 CalcStar User s Manual Operations Once you have entered the formula at E5 you can copy the formula with relative adjustments into the locations E6 through Ell By copying with relative changes you will insure that the system will automatically adjust the coordinates within the formula to accurately reflect the correct coordi nates As an example the formula at location E6 will sa
130. r function which can be used in conjunction with the Print command The Page function serves as a form feed instruction to the system during the Print operation When the system encounters the row with the Page entry the printing will skip the rest of the present page and will resume printing on the top of the next page To be effective the Page entry must be located in the leftmost column printed For example if you would like to print the first four columns from our EXAMPLE file but you would like to have rows 1 through 6 on one page and rows 7 through 13 on another page then you could insert a row at row 7 and enter page at A7 Now specify your bottom right corner as D14 and proceed through the rest of the Print command as before The resultant printout will show columns 1 through 6 on the first page and rows 8 through 14 on the second page II 29 LINEAR REGRESSION FORECASTING If you could choose what you would like most in a financial report modeling system what would it be Most likely it would be the ability to tell the future After all one of the most important goals of a financial report writing system is to give the best advice it can based on past data Well MicroPro has taken this goal to heart and CalcStar incorporates the ability to compute a linear regression which computes the best estimator of a predicted value based on a given value or computes the best estimator of the necessary given value by entering a hypothe
131. r the screen computer prompt your response explanation edit access command directory command D access Delete command Delete A 1l R ow A clear the screen C olumn R ow verify Y N Y insures this is ok with you TI 65 CaleStar User s Manual 7 Operations To axecuee the Load command and regain access to our EXAMPLE pense duplicate the following steps computer prompt your response explanation edit access command directory Command L access Load command Filename make sure file EXAMPLE lt CR gt reload file named is saved EXAMPLE Load position Al lt cR gt load EXAMPLE into the array with the upper left hand corner of the report at location Al The result will be that our file is loaded into CalcStar and appears exactly as it did before we deleted it from the screen The message make sure file is saved is to remind you that the existing format of the file displayed will disappear once another file is loaded unless the existing format is saved The last prompt asking the load position grants us the option of loading the file into the CalcStar array with the upper left hand corner at any position we would like providing there is enough room The AL following the prompt does not mean that location Al is the only place we can load in the report Instead it lets us know that the default loading position is location Al So if we would like the upper left hand corner of the report to be positioned at Al the
132. roject LUNCCION cccccevevcvecevcvecccesesecssesll 62 dependent LUNCCLON s sa 6 s 0 5 0 sbss scene s es cess cice s LL62 Slope LUNCEI Of sis 44 s 0 aree o5 e 6 o 01s8 006s oeeus oe eseees ll O2 The Load Command 6 0sistw sd Aso 0s wee G 56 64056455840 6046 e LLOKOD load almost anywhere on the Aarray ccccccceseeell 66 The Extended Screen Command ccccccscscccccccevecvoeell O view 15 rows of the Logicalc Aarray eseseseeeell 68 TNE Q it Comand 65s abso o5s6 566 60 0600 064 se seeaiswece 0 The Help COMIMANG s6 sd 4 5 54 00 6 Oe ks Rw OE E T O64 Ses Kee LOO Evaluation of Input Data ccccccccccccccccccsevessellmil Program CSDUMD cccccccccccsccccccccccsasccncsesescvselinmsis Advanced PEALULCS 6 sessir 46 6 dis soris keresest L1 SIMMALY 66 6 5 60 45600 dareen 6 6 aaa aa a LLO APPENDICES Sample ApplicationS ecececescccccvesveesesellInml Command TOOK 6s 5 55 66 60 SSS 6 oS 00s S546 SOAS LLCS Error MessSageS escescocococecsooosoosooeoooo s ILI ll Installing CAlLCSEAL issiria sarsana aat LLL General iba s gt A O E E E E E E Appendix C Appendix D Appendix E iv CalcStar User s Manual Overview SECTION I I l INTRODUCTION CalcStar is a valuable tool to assist you in producing professional reports and problem solutions with maximum flexibility creativity and ease At last you can put away your paper pencils and erasers and use your computer system to create a multitude of reports The hea aches of correcti
133. roximate value towards an exact value The use of the Recalculate command will be demonstrated several more times in the een of this manual We should remind you of one point Any entry which evaluates to some thing divided by zero will yield the n symbol upon recalculation This symbol will also be displayed in any entries which are multiplied by or divided into or divided by an entry which equals a value divided by zero For instance if at location Al the value after recalculation is equal to 5 8 and location Bl contains the formula Al A3 or Al1 A3 or A3 Al the n will be displayed in locations Al and Bl TI 33 CalcStar User s Manual Operations 11 28 THE ORDER COMMAND The operation that goes hand in hand with the Recalculate command is the Order command The Order command determines which direction the Recalculate command moves in Normally the entries in the array are evaluated in a left to right direction through each column and then moving down to the next row and then moving from the left to the right and then to the next row and so on until all the rows have been evaluated The Order command switches this order of evaluation so that entries are computed moving from top to bottom in each column and then moving one column to the right and moving from top to bottom again and so on until all the columns have been evaluated order of evaluation left to right top to bottom top to bottom left to right l1 2 3 4 5 1 5
134. rt the system will ask you for the upper left corner of the portion you would like to save and then will ask for the bottom right corner of the subsection you would like to save If you would like Al to be the upper left hand corner you may type lt RETURN gt Otherwise enter the appropriate location or move the cursor to the location and type If you would like the bottom right corner to be the cursor location you may hit the lt RETURN gt key Otherwise enter in the location you would like for the bottom right corner Once you have entered the coordinates of the subsection of the report you would like to save or you entered A to save the entire report the system will write the present contents of the CalcStar array into the file over the previous contents 3 If you enter Y and there is a password PEORseear the file the system will prompt Verify the password to remove Now there are two possibilties a if you enter the wrong password the Save operation will be aborted and control will be returned to the edit line this demonstrates that your file is protected by the password b if you enter the correct password the system will prompt Password lt CR gt none This means the old contents have been removed and the system is asking you if you would like to protect the new contents of the file with a password When the new password prompt has been answered the system will ask you if you would like to save a portion
135. s N5 through N11 with relative changes The following screen display will occur II 44 CalcStar User s Manual Operations kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc k lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel Col gt M IN O P BROW nner rear aeaaee e aeea eae aa ene aaa aaa aen ae eee ements SK le 2e 3e x 4s gt 1 00 lt 5i 1 88 6 1 90 7 1 88 8 8 00 k 9 1 88 10 1 08 wf E anean anana aaa A cursor N4 current N4 L R current type numeric data contents K4 gt 20 14 H4 gt 25 60 edit z kkkkkkkkk kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk This will inform you the part in row 8 satisfies one of the conditions and the parts in rows 4 5 6 7 9 18 and 11 satisfy both of the conditions Thus you have the means to produce the result desired by your managers including the ability for them to scale how well the products are doing in relation to one another We will demonstrate one other example of how to scale the success of your parts using an alternative structure In this ca
136. s command directory Command G access Goto command Goto gt Al A2 lt CR gt move cursor to A2 As with the lt TAB gt key if you would like to Goto Al then you only need to type lt RETURN gt and by default the cursor will jump to Al However if you would like to Goto some location other than Al simply enter the coordinate and lt RETURN gt and the default will be overridden and the cursor will jump to the location you have entered From the preceding example we can see that the Goto command is iden tical to the lt TAB gt key The Goto function is so useful that in case a machine doesn t have a lt TAB gt key you can still use the Goto command but if your machine does have a lt TAB gt key it s usually easier to use From now on in this manual we shall say Goto lt coordinate gt and let you choose which action to take to get there Il REPETITION FUNCTION In order to make our report orderly and attractive it would be nice to underline the column labels However it would be bothersome to oe the underline mark enough times to underline 12 columns There is a much easier way to accomplish our goal What we shall do is underline one column and then copy that underlined column into the next ll columns It s even easier than it sounds First of all we want to fill location A2 with dashes and this will give the effect of underlining Al You can do this in one of two ways Either we can enter in aS many dashes as the field is w
137. se we will assign a value of 100 to those parts which satisfy both of the conditions of having the amount on order be more than 20 of the amount stocked and the profit be greater than 25 We will assign a value of 5 to any part which does not satisfy both of these conditions To accomplish this task move the cursor to O4 and enter H4 gt 25 K4 gt 260 14 106 58 Note that the implies the use of the logical operator AND but is in this case identical in result to the multiplication operation If either expression is false it s numerical value becomes and multiplied by anything results in So both expressions must be true for a part to be valued at 108 Otherwise it is valued at 58 After you copy the formula with relative changes your screen will show the following display II 45 CalcStar User s Manual Operations kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit G or lt TAB gt Goto lt ESC gt Cancel Col gt M IN O P A ROW a 1 323 33 4 1 98 gt _ 58 88 lt ian 1 80 50 08 6 1 00 59 00 Ts 1 99 50 98 8 8 08 58 80 9 1 8
138. ser s Manual Operations II 21 THE MERGE COMMAND With the Recalculate command you may produce new reports with new figures while preserving all the text entries of your original report so that you do not need to write an entire report over just because the numerical data changes There is another and perhaps easier way to preserve the report text while maintaining the ability to substitute new numerical data The Merge command is especially helpful if you want to preserve your report text but because of complex dependencies and or too many changing variables the Recalculate command would be too complex to use to change numerical data The Merge command allows you to create two or more separate files and then superimpose the files one on top of the other In our EXAMPLE file we could create a standard inventory file which would contain the entries in columns A B C D contain the column headings for columns E F G H contain the entries for column I the quantity stocked is constant contain the column headings for columns J K and L Let s call this file STDINV for standard inventory In order to clearly understand the Merge command we will include screen replications of what our fantasy files would look like if we were to go ahead and create them You do not need to actually create them since this would involve quitting our present EXAMPLE file and the Merge command can be sufficiently understood by following along here in the manua
139. ser s Manual Operations To begin the Print operation proceed through the following steps computer prompt your response explanation edit access conmand directory Command P access Print command To which file PRINTER lt CR gt see below The last question above informs you that you may either print out your report to another file on the disk or to the printer for a hard copy If you would like to print the report to a file on the disk then enter the name that you would like the report to be stored under Once the report is stored in a file on the disk you may use it in a word processing environment as we Will describe in the next section If you would like a printout then enter RETURN and by default your report will be sent to the printer For our EXAMPLE file enter RETURN so you may have a printout of the report The next prompt will ask e top left corner Al eeeoeeeeeveeaeoeeoeecoveaoseeoeeseeceveeeveeeeoeneoe soos eeneaosveeoeaee eee ee At this point you may specify the location on the array i e some coordinate that you would like to become the top left hand corner of your printout The prompt is included in case you would like to print out only a portion of the report which did not include the upper left hand corner of the array i e location Al We will demonstrate this in the second example section II 27 of this manual For now we would like to print out the entire file so enter RETURN or Al as shown
140. t the contents will display the text If the entry was a numerical formula the contents line will display the formula the calculated results of the formula may be found in the window at the current location So the contents line is a reminder for you to see what was entered at the current location The contents line will be blank if the current location is empty 3 EDIT reflects what you are presently typing in The edit line will be blank at any location until you start to type an entry The edit line will show you exactly what you have typed until you hit the lt RETURN gt or lt ENTER gt key and then what you have typed will move to the contents line and the edit line will be blank The edit line is also used to access the functions and commands listed in the lower section of the main menu The line below the edit line is used for system prompts and your responses CalcStar User s Manual Overview This page intentionally left blank CalcStar User s Manual Operations SECTION IT OPERATIONS II l CALCULATOR FUNCTION Before starting with an example application it would be helpful to introduce a special calculator function and also the cursor movements in order to assist you in learning to find your way around in the CalcStar nn nm a t The calculator function can be used independently of CalcStar This saves you from either needing a calculator by your side or a lot of paper and pencil or from temporarily putti
141. t Column A and Row 1 are flagged with an asterisk indicating that they are locked onto the display Now you are free to move the cursor around as usual and the row and column headings will stay in place so they are available for easy reference As you move the cursor to the left several times you will notice the screen scrolls before the cursor reaches the locked column With the column locked it is as if the array starts in the second column The only way you will be able to move the cursor into column A is if the cursor is in column B and then you may move into column A using the normal cursor movements This situation is analogous for rows The only way to move the cursor into row 1 is from row 2 otherwise the screen will scroll up before reaching the row with the column headings R With the extended What command you may scroll the cursor to anywhere on the CalcStar array and the row and column headings will adjust to display the correct labels for the respective rows and columns It is also possible to lock several rows and or columns into the display To accomplish this place the cursor at the cell that defines the innermost edge of the locked area For example if you wanted to lock the first two columns and the first three rows place the cursor at cell B3 before executing the Extended What or Lock command II 29 CalcStar User s Manual a Operations The Lock command works as a toggle That is if your display is U
142. ta for the first six months of this year The result shown on the screen indicates that we will need to spend 1758 88 on advertising to reach a sales level of 2 800 for product l Just to prove to yourself that these are not random numbers now type proj 1758 88 This is proposing the reverse If we spend 1758 88 on advertising what will the best estimate of sales be The result is 1999 98 close to 2000 which is of course what the sales level should be given our first prediction See what fun things you can do The last function to demonstrate is the slope function Move the cursor to location J5 and enter slope Now go to location J6 and enter the same thing and repeat this procedure at location J8 In all three entries the result will be 3 46 If you doubt that this is really the case then you are absolutely right CalcStar has been set up so all of the functions which work with the regression function work with the last regression function entered in time sequence Since the regression function at location H8 was the last one we entered the system thinks we are asking for the slope II 63 CalcStar User s Manual 5 Operations of that regression equation three times I5 I6 and 18 This brings up a very important point If you want to enter a function to be used with a regression function that was not the last regression function entered then execute the recalculate command R A afterward in order to get the
143. tells CalcStar to load a file A filename is now requested Respond with DEMO lt RETURN gt A load position is requested with a default value presented The default value is cell Al A cell is an area on the screen which can hold data and is marked by the intersection of a column and a row In this case the column is A and the row is 1 Since most files are loaded at cell Al respond to the query with the default value by pressing lt RETURN gt Once you press lt RETURN gt a series of dots will appear at the bottom left of the screen display These dots tell you that a file is loading The display now appears as follows KKKEEEEERKKKEKEREEEKKRKEKEERERKEKEEERERKKEKKEEREEKEKREERREREREKRERREREKREKREKKERRKKEEKKE Cursor Movement Commands followed by Misc lt CR gt Right A Auto F Format M Merge R Recalc Extend Curs Pos S Left D Right C Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit Gor lt TAB gt Goto lt ESC gt Cancel COL gt A IB IC D E FER Cy ye er ee cree mtn mr ee cee mere me ee te in a on ere eae ca TRE IT AP PARE AE YH ees Tr ie Sn BE gt pe E S 2 Initial Value S Gsiweus g 3 Depreciation Rate 4 Year Acquired ssesesso 4 5 Residual Value S 6 cia es a sala a5 Dudka aa i ec a aa hg amass 7 Year Dep E
144. the printing to execute without stopping so enter N as shown below Stop on each page y n N eeoeeesoeveecoeoeoeoeve ees ee eee oeveeeveeseeanscseeve ees ENTE 808 Whether you decide that you would like continuous printing or you Specify a printing length the next prompt will ask Printer width 132 i l E E E E E EEEE REEREZESEREE SEESE ES SEEE SE SEENE S EEE E E Now you may choose the number of spaces across the page you would like the file to be printed in This will partially depend on the paper size and the type size If you are using the 11 wide paper you may Specify the standard printing width of 132 spaces across the page by hitting lt RETURN gt Otherwise if you would like less than 132 spaces printed across the page enter a number between 1 and 132 If you are using the 8 1 2 wide paper then enter a number between 1 and 8 the maximum number of spaces across for 8 1 2 wide paper One very important reminder is to make sure that the printing width you specify is wide enough to fit the portion of the array you would like to be printed out For example do not specify a printing width of 50 if you would like 80 spaces of data to be printed out In order to be universally applicable we will specify a printing width of 86 for our printout of the file EXAMPLE so enter 8 as illustrated below Printer width 8 i SCHEOCHHEHHEECEHSOHHEHEHSOEEHEHESHSHEEHESEOHRHOSCESEHSEH OOOH ECE SESE E II 51
145. tical predicted value For example you may enter values for the amount of sales for six periods and the amount of money spent on advertising for the same period Now by using the regression command you can compute a linear equation which will best fit the data entered Using this equation you may then enter a given amount of advertising money and the system will compute the best predicted value for the amount of sales you will have in that month based on the past correlation of advertising expense and amount of sales You will also be able to enter in the amount of sales you want and compute the best estimator of the amount of money you will need to spend in advertising to reach that sales level based on the past data entered As you can imagine this feature will open all kinds of forecasting possibilities The linear regression is much more efficient than a simple growth assumption Everyone interested in a financial moges the system will be able to benefit from this feature In order to demonstrate the regression feature we will leave our inventory example behind us and create a new example One useful application would be the situation mentioned above We may enter data for money spent on advertising dollar amounts of sales and some of the months of the year to illustrate how to best forecast future trends based on a linear regression of past data To begin insure yourself that your EXAMPLE file is saved and then type the following in or
146. to D8 thru D11 When writing a nice beautiful report it s a wise idea to occasionally save what you have written so that there is no chance of it being destroyed If for instance you accidentally hit the lt BREAK gt key or someone accident ally unplugged your machine then all your work would be gone and you can guess how that feels Now seems to be a good time to save what we have so far produced Saving a file or a subsection of a file is fairly simple steps II 18 Just follow these CalcStar User s Manual Operations computer prompt your response explanation edit access command directory Command gt S access Save command File name EXAMPLE lt CR gt choose a filename for your file to be saved under Filename must be l characters or less Password lt CR gt none lt CR gt or lt password gt see below P artial or A 11 A Save the entire report l If you don t need your file saved under a secret password enter lt RETURN gt After entering lt RETURN gt the prompt will tell you that your file has been saved and the control will transfer to the edit line 2 If you do want your file protected by a password enter your choice either one that you can remember easily or that you have written down in a safe place Remember the password must be re entered exactly as you first entered it After you enter the password which will NOT be displayed on the screen the system will prompt Again
147. total on both sides of the report change from 13 325 000 86 to 13 325 859 35 IV Print the report Appendices l Enter P lt CR gt lt CR gt D43 lt CR gt 80 N lt SPACE gt BALANCE SHEET 12 31 81 lt CR gt will be re displayed and you may continue your work demonstration If you would like to print another file s contents enter Y and the sequence of steps you have just completed will be repeated for another file If this printout was the last one you needed enter N and the CP M prompt For our demonstration enter N since we will not need to repeat the TiI 2 CalcStar User s Manual Appendices The second example report included in this appendix is a job cost estimate report The steps to enter the report and the resulting printout are as follows I Enter the report text 9 19 ll 12 13 14 15 16 17 18 19 20 21 226 23 24 25 26 21 28 29 Goto Al and enter F W and 28 to widen the column and then enter Acme Paint Inc Goto A2 and enter Cost Estimation Form Goto A3 and enter Goto A5 and enter rNumber of walls Goto A7 and enter rAvg wall hgt Goto A8 and enter rAvg wall width Goto Al Goto All Goto Al2 Goto Al4 Goto Al6 Goto Al8 Goto A20 Goto A21 Goto A23 Goto C5 and enter rPrice paint gal and enter rSq ft gal and enter rApplication speed and enter rSquare f
148. u please refer to section II 9 of this manual II 18 THE FUNCTION The function will allow you the opportunity to include a non evaluative comment in a numeric entry in the CalcStar array This is very handy in case you are working in a section of the array where you cannot see the column and row headings easily At the end of your numeric entry enter lt comment gt and the comment you insert can serve as a convenient reminder of TI 31 CalcStar User s Manual Operations what the entry represents Your comment will not appear in the CalcStar _ window or on a printout but will be displayed on the contents line for the location with the comment insertion As an example move the cursor to location K13 This time enter SUM K4 gt K11 total ordered The comment is not displayed in the window but appears on the contents line For your own practice try entering comments at a couple of other locations Be sure to hit the key and not the key NOTE The key is not found on the TRS 88 keyboard but may be entered by hitting lt CTRL gt 9 Take a minute to congratulate yourself you have just finished a very thorough and accurate inventory record All that remains to be demonstrated are commands to edit the file print the file quit the program and load the file back into CalcStar Before we make any changes let s save the file again to make sure it is safe Here are the steps if you need a reminder
149. ula to calculate the number of bolts that should be ordered for each size Remember to use the copy formula whenever you can and use the function if you wish in writing your formula for the quantity ordered The company stocks 5890 bolts of each size The number of bolts on hand is as follows 1 4 bolt 2128 3 8 bolt 2900 1 2 bolt 3780 5 8 bolt 3119 3 4 bolt 4195 7 8 bolt 3063 1 bolt 1918 1 1 2 bolt 4350 NOTE Remember there will be no fractions of a bolt so set your decimal precision accordingly II 26 CalcStar User s Manual Operations To insure that everything is correct and the operations covered so far have been understood let s check your results In column I under QUANTITY STOCKED there should be the integer 50 8 in locations I4 through Ill Now move the cursor to location J4 and use the Edge command sE to isolate the last two columns of figures for QUANTITY ON HAND and QUANTITY ORDERED Your screen should resemble the following replication KEKKEKKKKKEEKEREKEEKEREEKERKEKEREKEKKEKEKKEKEKEKEKEEKEKEKEKEEKEKEREREEKEEEREREKERER Cursor Movement Commands followed by Misc lt CR gt Right iA Auto F Format M Merge R Recalc Extend Curs Pos S e o S Left D Right IC Copy H Help O Order S Save Lock Evaluate E Up X Down D Delete I Insert P Print W What Space Data Togl Z Col A next row E Edge L Load Q Quit Gor lt TAB gt Goto lt E
150. und to enable you to find out and then use the sign to enter the appropriate coordinate After hitting lt RETURN gt the next prompt will be Form length CONTINUOUS eseeeoaodessveeoeoecoeoesznpeoceoe Cee eeeaeeansceooeoeveeeeeoeasv ee ee ene se 9 This prompt allows you to decide how many lines per page you would like printed If you would like the printout to be continuous from page to page then hit RETURN and the next prompt will be presented If you would like less than 66 lines per page standard type printed then enter your choice between 1 and 66 For our first printout answer this prompt with 690 as illustrated below e Form length 69 A eeseeoeseseaaovanesvpeaeoeosee ea eoeeaoeeveevneotvpeeanop eevee ee envpasvseo eee ee 8 II 50 CalcStar User s Manual Operations After you have specified the number of lines per page to be printed provided you did not hit RETURN for continuous printing the system will prompt e Stop on each page y n eeeeseoeeevneoeeesaneoevseeseeeceoeveeveeeseeaeeesvseeoeeoee enone eoee ee eve 8d If you decide you would like the printing to stop after each page is printed then enter Y You will be able to resume the printing by hitting the lt SPACE gt key If you decide that you don t need the printing to stop after each page then enter N and the syStem will print the specified number of lines per page until the entire section has been printed For instance we would like
151. ut that contained all the information for all the bolts or write a new report However with CalcStar we may printout any subsection of the file IL 93 CalcStar User s Manual Operations To begin access the Print command as we did before The steps are computer prompt your response explanation edit access command directory Command P access Print command To which file PRINTER lt CR gt send report to printer One possibility which can be very useful is to print a subsection of the report to a file on the disk where it is stored in ASCII code and is there fore available for use with WordStar For instance if you would like to use part of the report in a letter then write that section to a file and it may then be included as an insert file in another printing program For now we will generate a standard printout The prompt that will now be displayed is shown below top left corner Al eoeeeevovoeveeeneCeoesveveseosevevevee eo eev ven ees eenveveeene0e0n 8 e8 In this example we wish to print out only the information for three bolts beginning with the part name we are not interested in the part number which is the upper left corner of the file So instead of typing lt RETURND we should enter B7 This will insure that rows 1 through 6 and column A are excluded from the printout Your response for this prompt is shown below top left corner B7 The next prompt will ask bottom right corn
152. ut to a disk file by typing DEMO TXT the suffix TXT will be assigned automatically 3 The beginning and ending cells of the report are optional 4 The print width is optional 5 Titles are optional The file DEMO TXT will then be a WordStar compatable file that can be manipu lated in any way WordStar allows The ability to create BASIC DataStar M and MailMerge files extends CalcStar beyond the scope of personal use Data in Calcstar that is usually limited for viewing by the number of people one could crowd around a terminal can be distributed in form letters with the use of MailMerge BASIC programs can provide further manipulation of data DataStar can store CalcStar s data To create a file with comma delimited fields that can be used by these programs follow the above procedure for creating a TXT file but prefix the filename with greater than sign gt We hope that this introduction gives you some ideas about how to use CalcStar aS a new and exciting tool Use the reference manual when you have questions CalcStar User s Manual PREFACE This manual will introduce you to CalcStar It is a very easy to learn program that lets you dispense with columnar pads forever This manual will be your friendly tour guide as you discover the delights of using your computer to replace many otherwise difficult time consuming and even boring tasks With it you ll explore all the features of CalcStar by practicing the
153. xp Acc Dep Book Val 8 SSSSSSSSSS SSS SSS SS SSS SSS OSS SSS 9 16 no entry z E re en ee re ee rm ge eee ee mn fe ne re ee re em ares moms sd cursor Al current Al L R x current type text left justified A og data contents WTEC o50 660 06 S8050h6 00650 a edits _ CalcStar c 1981 c o MicroPro Int l CS9999XX rv_nnn terminal type kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk Now that this table has been set up it is easy to calculate depreciation values For this demonstration we have preset those cells which require data to be entered Type A to place CalcStar in the Automatic Forms Mode While in the Automatic Forms mode the operator is allowed to enter data in predesignated cells only After each entry the cursor automatically ad vances to the next cell After data is entered into the last cell CalcStar automatically performs calculations using the entered data and then places the results in other designated cells The cursor is defined on the left by the gt symbol and on the right by the lt symbol and marks the active cell To demonstrate the simplicity of entering data enter the following remem ber end each entry by pressing lt RETURN gt truck 12000 25 1981 15990 After the last entry CalcStar begins calculations The following display is the result CalcStar User s Manual Introduction kkkkkkkkkkkkkkkkk kkkkkkkkkkkkkkkkk
154. y 149 E5 not the Original formula of 149 E4 The steps are computer prompt your response explanation edit access command directory Command C access Copy command from coord gt coord E5 lt CR gt copy value at ES to coord gt coord E6 gt E1L1 lt CR gt copy into E6 thru Ell R elative or N o adjustment R value will change from entry to entry For simplicity let s say the cost of the bolts follows the same pattern as the price of the bolts each one is 40 higher than the previous one The cost for the 1 4 bolt is 015 You may have noticed three decimal places for the cost of the 1 4 bolt As a result you will need to change the decimal precision for column F to three places Try it on your own If you have some trouble here are the steps computer prompt your response explanation edit access comand directory Command F access Format command P recision 2 or W idth 1 P alter decimal precision or Form Mode clear Column F precision 19 3 lt CR gt change precision from 2 to 3 decimal places Now enter 15 at F4 and then enter the formula at F5 to show that the next bolt is 49 higher than the previous bolt Following this copy the formula into locations F6 through Fll with relative adjustments II 22 CalcStar User s Manual Operations II 14 THE EDGE COMMAND At the same time we are checking our entries for the prices and costs of our inventory of bolts we can also demonstrate the use of the Edge comma
155. y inserted rows and columns and will transfer all data to the newly renumbered rows and columns Now we can enter the new information for our addition to the inventory file The data are as follows part 1 All part name 1 1 4 BOLT supplier 35 supplier name ACME price 18 cost 151 profit unit Ell Fll profit G11 Ell 160 quantity stocked 5009 quantity on hand quantity ordered 5900 cost order Fll Kill You may use the Recalculate command to recompute all the totals to include the information you have just added to the file So within five minutes of receiving the memo you can present the new report information Doesn t that make you sigh in relief In the same way you inserted a row you may also insert a column If for instance you would like to add a new category of information in your file you may do so by inserting a column wherever you would like As an illustration you could insert a column for the supplier phone number for placing orders With the cursor at the price column you could insert a column by following the steps outlined above and entering C for column instead of R for row This would leave column E blank and would move each of the other columns over one column to the right You could now enter in your supplier phone numbers in column E At this point we will leave the supplier phone number column out
156. your work For our demonstration enter N since we will not need to repeat the demonstration IIlI 4 CalcStar User s Manual Appendices The third and last example in this appendix is a quarterly sales analysis The steps for entering the report and producing a printout are outlined below I Entering the report text e e e e a e Q LCONDUURAWN H e fend li hmat NOD 13 ft ft JH OV U1 e e e e 17 NH O O o e e 21 22 23 24 25 26 Zh 28 29 38 3l 32 336 34 35 36 37 38 39 40 4l 42 43 44 45 46 Goto A5 and enter F W and 14 to widen the column and then enter district A Goto A6 and enter product 1 Goto A7 and enter product 2 Goto A8 and enter product 3 Goto Al and enter ctotal Goto Al2 and enter district B Enter 3 C A6 gt A8 A13 gt AL5 Goto Al7 and enter ctotal Goto Al9 and enter all districts Enter s C A6 gt A8 A2 gt A22 Goto A24 and enter ctotal Goto A25 and enter and enter C A25 C25 gt G25 Goto A28 and enter by product Enters Titi 104 AGAR TA295A31 Goto A33 and enter Goto A35 and enter by district Goto A36 and enter district A Goto A37 and enter district B Goto Cl and enter clst Goto C2 and enter cgtr and then enter C C2 D2 gt G2 Goto C3 and enter and then enter C C3

Ca1cStar User`s Manual CS-351O-1 (1.2) First Issue

Contents

Download Pdf Manuals

Related Search

Related Contents