Category : Financial and Statistics
Archive   : QUBE302.ZIP
Filename : QUBECALC.HLP


CELL COMMANDS CELL COMMANDSDSÒì€ôÿŠÊt"Ċð2ÀÓèŠøŠÆèÐÿ
ÿD QubeCalc provides the following commands to manipulate the contents
E or status of a single cell. The cell which is used is the one whichèA is currently highlighted by the cell pointer and is known as thes &ˆ= current cell. ÿ¸ŽÇ‹>óŠ.õŠdŠ6ö2Û&Š=ÃPR¡ó€ü œr€ì 3ÒQ¹P÷ñYÑàÑàWIDTHÑàÑàr€Ä ‹Ð¡* £. ¡, £0 ZXýÿÿèœÿEè^ÿrèEÿrõèrÿ&ˆ=‰>óˆ.õFFORMAT This command allows you to select the way you want theF numerical value in the current cell to be displayed.CWIDTH This command allows you to change the cell width ofÀ[Y# the current cell. you to change the cell width ofofkFERASE This command erases the current cell from the WorkQubeCJUSTIFY This command allows you to set the justification onŠ# the current cell. the current cell from the WorkQubeCCOPY This command allows you to copy the contents of theÌt[; current cell into another block of cells.s of theZQ‰ current cell into another block of cells.uC€?‹tKè¢è¶ÎKëáé
éyÐéÌÍèËtÖSÆ9
èèÍtT€Í€2ÀèlÍÆ9u€?(u
Xë\€?(XtIP[èÄÍÒu€B Press ESC to exit from HELPué\ 

BLOCK COMMANDSC
èÎÖ
Work file name¾Çè÷ûÆÇuèB é·ûè¿ÇècëÇ€D QubeCalc provides the following commands to manipulate the contentsèF or status of a defined block of cells. The defined block may consistE of a single cell, a 2 dimensional range of cells, or a 3 dimensionala block of cells.ËÕèè­ÕFile too big‹xKë™èàÿÆÇé›ú3À@ë3À€>…t2t/èyÕWorkfile èE
èiÕ not saved. SaveÆ…èpýu
ÃèÆ…¾Çè
è<Õ
SaBFORMAT Allows you to set the format on cells in a block.+ÊAAWIDTH Allows you to set the width of cells in a block.or in:ERASE Allows you to erase the cells in a block.¾‡ŠF<*t0 Data: »O±Óë¡j+Ã%ÿèè•Ò, ¸+j%ÿè¦è‚Ò free
€>I
t€3DEFINING BLOCKS How to define a block of cells.3è9Ò (minimum)
@ Press ESC to exit from HELP.èÑ byt

)./0WORKQUBE COMMANDSÎÖ
Work file name¾Çè÷ûÆÇuèB é·ûè¿ÇècëÇ€F QubeCalc provides the following commands which affect the contents or? status of the entire WorkQube. The format, width, and justifygèÖFi@ commands affect only future entries and not cells which alreadyÊÕInva contain data. èËÕèè­ÕFile too big‹xKë™èàÿÆÇé›ú3À@ë3À€>…t2t/èyÕWorkfile èE
èiÕ not saved. SaveÆ…èpýu
ÃèÆ…¾Çè
è<Õ
Sa4FORMAT Allows you to set the global format./“‹v‹x‹ùÆ+ÊA8WIDTH Allows you to set the global cell width.isk full or inCERASE Clears all data from memory. You must verify this.0 B Press ESC to exit from HELP. byt

#&1
INSERTING A ROW, COLUMN, OR PAGEROW, COLUMN, OR PAGED PAGESÃS»Í=ëS» D QubeCalc allows you to insert a blank row, column, or page into theÆF WorkQube. When a new row is inserted it is placed at the point where? the cell pointer is located and the rows at and below the cell\G´GŠÐ€C pointer are shifted down to make room for the new one. The bottområB row in the WorkQube is pushed off the end and is lost. InsertingæÉt3 a new column or page operates in a similar manner.‡éaþ¾Çé[þ¾Çü¬è FACE A: --X-- FACE D: --Y--%ëè$tèèµÊëD All formulas in the WorkQube which contain relative cell referencesŽB will be adjusted if necessary except for one exception. Relative¹C references which point to a cell which is lost due to being pushed
°D off the end of the WorkQube are NOT adjusted to point somewhere offxD in HyperSpace. These references will continue to point to the sameÉt3 cell location as if they were absolute references.est to avoid this’ situation!!‹Àûés˜€>³tPèÕXˆCSèu[‰Àè…ézÿèäÈ<t< s;»ÊÆ
C>ABS/REL How absolute and relative references work.Cˆu¼èABS/REL How absolute and relative references work.X@è[Xñ@ Press ESC to exit from HELPLP.¾è
DELETING A ROW, COLUMN, OR PAGE ROW, COLUMN, OR PAGE ÊUÒÍs &ˆ= @AB> QubeCalc allows you to delete a row, column, or page from theàÑà @EX? WorkQube. When row deletion is selected the row that the cellõ @AVA pointer is on is removed and the rows below the cell pointer are @CO> shifted up to fill in the deleted one. The bottom row in thez. @SUE WorkQube is then filled with blank cells. Deleting a column or pageI operates in a similar manner. tæ<`r, [ÃS»yþ‹wK‰w[ÃèÃÿ<=tk @MA( ))Rë뺵<,tÑ<;tÝ<:sÉ<0rŊڊþÛÛÚÛ,0ŠÐ¶ڇÚè‰ÿtºþÍuÑë è- @VAD All formulas in the WorkQube which contain relative cell referencesSTB will be adjusted if necessary except for one exception. Relative @SQF references which point to a cell which is deleted are NOT adjusted toF point off somewhere in HyperSpace. These references will continue toE point to the same cell location as if they were absolute references.UNLL
éyÐéÌÍèËtÖSÆ9
èèÍtT€Í€2ÀèlÍÆ9u€?(u
Xë\€?(XtIP[èÄÍÒu€C Press ESC to exit from HELP.é\@ABS/REL How absolute and relative references work.******ABS/REL How absolute and relative references work.¸ÿÒìC Press ESC to exit from HELP.ó‹PRINT COMMANDS PRINT COMMANDS***************ð2ÀÓèŠøŠÆèÐÿ
ÿD QubeCalc allows you to print out your data to either a printer or a
@ file. If a file is selected you will be asked for a file name.eed to provide a file name."Å
Ø2øùÊUÒÅs&ˆ=ƒï
&Š=r
;>. u8.2 ÊUÒÍs &ˆ=9BLOCK Lets you define the block to be printed..ÒQ¹P÷ñYÑàÑà4 LINE Advances the printer a single line.nted.rÿ&ˆ=‰>óˆ.õB PAGE Advances the printer to the top of the next page.Z&ˆ=D ALIGN Tells QubeCalc that the printer paper is at the top.D of the page (use this after adjusting the paper).[YA RESETBLOCK Releases the block to be printed (undefines it).s..tkEOPTIONS Allows you to change the print margins, page length,s$ and Setup string.e the print margins, page length,,F GO Begins printing the defined block of cells. PrintingB can be in 2 formats: Contents (which prints thee isF cell name & contents of each cell, one per line) orC Display (which prints the block of cells as theyKè¢5 would be displayed on the screen).\€?(XtIP[èÄÍÒu€A Press ESC to exit from HELPËué\
GRAPH COMMANDS GRAPH COMMANDSDS*******************ŠÆèÐÿ
ÿE QubeCalc provides you with the ability to create graphs representing
? blocks of your data. The order in which the cells are graphedüÊ.öèF follows the /WorkQube Order setting. Shift PrtSc will print a graph.C TYPE Lets you choose between Bar graphs and Line graphs..ÑàD Line graphs can be plotted using lines, symbols, orõ both.só3íU2Ûë‰>Zˆ.\U3íëèÿs Eè1ÿsõèÿ‰>óˆ.õZ&ˆ=CX, A, B, C Lets you select the blocks to be graphed. X is thez.C block which contains the values to be placed alongÀ[YF the X axis. A, B, & C, are the blocks containing the$ data to be graphed. Graphing follows the WorkQube odDOPTIONS Lets you change Title, Labels, Legends, and Formats..D RESETBLOCK Releases any one or all of the blocks to be graphed.Ð2A VIEW Displays the defined blocks graphically using theè3Ìt[F settings selected with the TYPE and OPTIONS commands.C The [F10] GRAPH key also does this when you are inthe8 the data entry mode (not in the menus).t at the menen@ Press ESC to exit from HELPELPé\
'
FILE COMMANDS FILE COMMANDS**********************Ðÿ
ÿF QubeCalc provides several ways of saving and loading data to and fromE a disk file. The file name must be a legal DOS name. The file willè; be written to (or read from) the current active directory.ŠUÒÍs &ˆ=COPY=9>0 u:.3 ÿ¸ŽÇ‹>óŠ.õŠdŠ6ö2Û&Š=ÃPR¡ó€ü œr€ì 3ÒQ¹P÷ñYÑàÑàE LOAD This command asks you for a file to be read in, clearss? the WorkQube, and loads in the specified file.ead in,@ SAVE This command asks you for a file name to save the file.? WorkQube to, and then writes the data to disk. saveaeB COMBINE This command asks you for a file to be read in, and..tk> loads the file without clearing the WorkQube.read in,B EXTRACT This command asks you for a block of cells to save,orkb9 then saves that block to the named file. tocells tos2F DIRECTORY This command allows you to change to another directory.F You may use either a full pathname or a subdirectory.D FILES This command displays the files and subdirectories inè¢' the current directory.Æ9u€?(u
Xë\€?(XtIP[èÄÍÒu€@ Press ESC to exit from HELP.Ëué\




EXITING FROM QUBECALC EXITING FROM QUBECALC8.2 ÊUÒÍs &ˆ= @ABB This command is used to exit the program. When you exit QubeCalc @EXC you will be asked whether you really want to exit or not. This is@AVD because your data is not automatically saved when you exit. If youCOA haven't saved your data yet you should select NO, save your data, and: using the /File Save (or Extract) command, and then exit.è3
À[Y @MI( )²ÃS»yŠ
Àtþ‹wŠC‰w< tæ<`r, [ÃS»yþ‹wK‰w[ÃèÃÿ<=tk @MA
SAVING A FILE<,tÑ<;tÝ<:sÉ<0rŊڊþÛÛÚÛ,0ŠÐ¶ڇÚè‰ÿtºþÍuÑë è- @VA( )fr‹úªB<;t
è_ÿþÍuñéÏ[éûÐèÖÿè‰Ð‡ÚËwŠ< r
ày<røZ,¢yŠ @ST( ),Y)éÍÐè¢ÿ y‹w^‡ÞVP±dè±Íéˆþ÷Úà ÀÃépÏ3À¢e¢f£l¡\£HŠ<½u¢eCKè:ÌèDÐKè3Ìt[ @FAT(X)MElKèÌtFèõË,<©tèíËAèéËLèåËLtjèßË,<©ue
Àœ¢fèõËèCÑQè ÎYZQ‰ FUNCIONSsHY;ÙrCu:¡.P‹0KCŠC
ué×C‹£.Cè¸Ë
Àtç<:tõ<þuC€?‹tKè¢RETUNLL
éyÐéÌÍèËtÖSÆ9
èèÍtT€Í€2ÀèlÍÆ9u€?(u
Xë\€?(XtIP[èÄÍÒu€C Press ESC to exit from HELP.é\

, LOGICAL FUNCTIONS*********************Ðÿ
ÿP
ÉtLˆFëGè_µÿÒí‹ê¶ÿÑíÑíÑítŠõè=µÿMuø€ât*†Ê¸ÿÒìB Press ESC to exit from HELP.>ó‹

EDITING A CELL'S CONTENTSITING A CELL'S CONTENTS*ŠÊt"Ċð2ÀÓèŠøŠÆèÐÿ
ÿC QubeCalc provides the ability to edit the data in a cell. You cann
F call this editing capability by hitting [F2] (if there is anything in? the cell to edit). Also, if you make an error when entering aÒÍs &ˆ=> formula this editing capability will be called automatically.÷ñYÑàÑàWIDTHÑàÑàr€Ä ‹Ð¡* £. ¡, £0 ZXýÿÿèœÿEè^ÿrèEÿrõèrÿ&ˆ=‰>óˆ.õ@ The left and right arrow keys (,) let you move left or right.õZ&ˆ=E The Home and End keys let you move to the start and end of the line..C The backspace key deletes the character to the left of the cursor.À[Y( Ctrl-Backspace deletes the entire line.r, [ÃS»yþ‹wK‰w[ÃèÃÿ<=tk= The Delete keys deletes the character underneath the cursor.þÍuÑë è-; The Insert key toggles between insert and overwrite modes.røZ,¢yŠB The [F3] key allows you to define a cell or block reference to beϊÐ2E placed in the formula (or any other type of line for that matter).[F The [F4] key, when used in conjunction with the [F3] key, toggles the; cell and block references between absolute and relative.uC€?‹tKè¢2[F3] BLOCK How to define a block of cells.
Xë\€?(XtIP[èÄÍÒu€A Press ESC to exit from HELP.Ëué\
 CELL ENTRIES CELL ENTRIESU¢1ÿdriveFASTWRITE B You may enter a number, text, or formulas in a QubeCalc cell. InF addition you may select commands/functions which allow you to perform/ operations on single cells or groups of cells.KÿwÃTòTEMPSCREEN
ÿþæ/TòMONOSCREEN
ÿþâ/TòCOLORSCREENÿqè÷MAXMEM ÷
3NUMBER A cell may contain a single number.which consists ofrs?TEXT A cell may contain up to 70 characters of text.ÿô÷CCFORMULA A cell may contain a formula consisting of numbers,Ì÷H= cell references, operators, and functions.s..
FCOMMAND The command menu may be selected by pressing the / keyEFUNCTION KEYS Special functions may be activated using the function. keys [F1], [F2], ... [F10].]. 
Ì÷vð

COMMAND The command menu may be selected by pressing the / keyEMOVING AROUND You may move around from cell to cell in the WorkQubee1 in a number of different ways.d using the functionA PCOMDEDITCOM 4LÞ
¸HELPMAKEBAK ÀB Press ESC to exit from HELP.w%
EPA$* MAIN MENU COMMANDS MAIN MENU COMMANDSNDS ***********************>CELL This command provides options dealing with theheltDiv;- contents of a single cell. row and column commands @BLOCK This selection provides options dealing with theCK 8 contents of a defined block of cells.lls.
vr
Op@WORKQUBE This selection provides options dealing with theCh in C contents of all cells in the QubeCalc workspace. prCINSERT/ These commands provide the capability to insert andto print defined blocks of cells on a printer. '=' :CGRAPH This command provides the capability and options to ; create graphs from data within QubeCalc.file.ÿnd;@FILE This command provides the capability to save andnot
v@ load all or part of the cells to/from a file.! begiAQUIT This command exits QubeCalc. The WorkQube is nottt
A automatically saved... remember to save first!.ey.,= Press ESC to exit from HELP. do
be 

NUMERIC FORMATS
èÎÖ
Work file name¾Çè÷ûÆÇuèB é·ûè¿ÇècëÇ€A QubeCalc provides a number of ways to display numeric data. The‡èD first three formats ask for the number of digits after the decimal.FiF Commas can be selected with the currency, fixed, and percent formats.? CURRENCY Numbers are displayed with a leading dollar sign.>…t2B Negative values are enclosed within parentheses.
SaE FIXED Numbers are displayed with a specified number of placesA4 after the decimal point displayed.è¹ÔDisk full or inA PERCENT Numbers are converted to a percentage value and are*t0 B Press ESC to exit from HELP. byt 





CELL WIDTHS CELL WIDTHSTHS^èLö‹xÆC‰vÃS»Í=ëS» A QubeCalc assigns a width to each individual cell in the WorkQubeTƒÆE (rather than to columns like in 2-D spreadsheets). Columns are thenF automatically adjusted to be the same width as the widest cell in theF column. If there are no cells in the column, the column width is setE to the global (WorkQube) width. This allows column widths to remaint: flexible regardless of which perspective you are viewing.é[þ¾Çü¬èËèöʬèòʋþ2À¹ÿÿüò®ý°\¹ÿÿOò®‹÷FFé0þU‹ì‡^Pœ.ŠC
Àt<€sè%ëè$tèèµÊëE The width of the current cell is always displayed on the cell statusA line in the upper left hand corner. It is the number at the endº¹: of the line which is enclosed in parenthesis... i.e. (9).Æ`Çë
°º°€>t. n
¶¸¢“‰É”‰–‰¾‰Â‰Æ‰šÃè•.Šk
þʶè~ÂèïþÿxD Cell widths may be changed either individually or as a block. WhenÉtF the WorkQube width setting is changed it will affect only those cellsC which will be filled in the future and will not affect those cells
C which already contain data.n[
ÀùtþÈt »YÙÙ.‹ùÃèœè™ÈþÊCˆu¼èë·è¢uäS3ۈ°è¤»ÊŠPCŠ€°èXþÈuï[ÃPèÝX< réhPP°^èaX@è[XñE Press ESC to exit from HELP.ERASE ERASESESES^èLö‹xÆC‰vÃS»Í=ëS» A The erase commands allow you to remove data from cells. You mayTƒÆB erase data from a single cell, from a block of cells, or from the'E entire WorkQube. If the WorkQube erase command is selected you will€@ be prompted to verify that you really want to erase everything.ÿÆråÃ"+,/;<=>[]{|}*?¾\3Vèhÿ^²
ë²ë2Ò¿‡3Ɋ
ÀtG€útô<.u‹Ï<\uê3ÉëæÉtA When data is erased, all cells which are erased are reset to theü¬èC global (WorkQube) settings. This includes format, decimal places,µÊëC and cell width. The cell type will be set to BLANK and the memoryŽ: used by the cell will be released for use by future data.ta.óª@¿º¹«¸ÿÿ¿³¹óª¸l¿¾¹ó«°¿Ê¹–óªÆÊÆÎÆïÆ
Æ@Æ`Çë
°º°€>t. n
¶¸¢“‰É”‰–‰¾‰Â‰Æ‰šÃè•.Šk
þʶè~Âèïþÿx‹xÆé¸îè`ü»ÿÿS‹xÇ
ÿxƨƲ
ÇeîXè»þè'Á[vCèÃè0Š°
ÉtFORMATèá° èeþÉuùˆ°èG
è_s-tՀþr
Æ…ÿÆ‚€æ»ASR»ÅºÉ¹é¸þè’É뢅Ƃ‹Àûés˜€>³tPèÕXˆCSèu[‰Àè…ézÿèäÈ<t< s;»ÊÆ
CS»Ê¾±Wµÿè[
ÀuS»Ê¾yXµèn[
ÀùtþÈt »YÙÙ.‹ùÃèœè™ÈþÊCˆu¼èë·è¢uäS3ۈ°è¤»ÊŠPCŠ€°èXþÈuï[ÃPèÝX< réhPP°^èaX@è[XñC Press ESC to exit from HELP.P.!ENTERING TEXT STRINGS INTO A CELL STRINGS INTO A CELLC‰vÃS»Í=ëS» B Text strings may be entered into a QubeCalc cell simply by typingƒÆF in the string. There are four (4) special characters which may beginE a text string and which affect the way the text is displayed. Thesea characters are:er ",^,',or \ first). These special characters causeå8 ' causes the text to be left justifieddediedê3ÉëæÉt9 " causes the text to be right justifiedied[þ¾Çü¬è: ^ causes the text to be center justifiedied$tèèµÊë< \ causes the next character to be repeatedtedtÔÆŽF If text is entered without one of the above special characters as theB first character, the global (WorkQube) justification character is
°E placed on the text automatically. When QubeCalc first starts up thexC WorkQube justification is set as left ' justified. You can change
Ét> this by selecting / WorkQube Justify and making a new choice.é¸þè’É뢅Ƃ‹Àûés˜€>³tPèÕXˆCSèu[‰Àè…ézÿèäÈ<t< s;»ÊÆ
CS»Ê¾±Wµÿè[
ÀuS»Ê¾yXµèn[
ÀùtþÈt »YÙÙ.‹ùÃèœè™ÈþÊCˆu¼èë·è¢uäS3ۈ°è¤»ÊŠPCŠ€°èXþÈuï[ÃPèÝX< réhPP°^èaX@è[XñC Press ESC to exit from HELP.¾è
%RELATIVE AND ABSOLUTE CELL REFERENCESE CELL REFERENCES***************ÿ@ Cell references in formulas can be either relative or absolute. and
D Absolute references begin with "$" (for example $A1;1) and relativeèD references don't. The value of a formula is the same regardless ofˆ=A whether its references are absolute or relative. The purpose ofes isE relative/absolute cell references is to let QubeCalc know what to dooE when moving formulas around (for example: copy, insert, and delete).r of characters in stringarg.‰wè^tëÀŠÈ‹z.A ABSOLUTE cell references ALWAYS point to the same cell no matteratter! where the formula is moved to. Example: if cell A1 contains theotk RELATIVE cell references point to a cell relative to the cell which1D RELATIVE cell references point to a cell relative to the cell whichŠ contains the formula.ins the formula =$A1+A1a =$A1+A1 the $ in the2 Cell D3 is copied to cell E5ell A1 contains the formula =C86EXAMPLE An example of how cell references work. (This example‰ the contents of the new cell at location 1;1;1 will be adjusted and during the copy and will contain the formula =R9;9;9?(XtIP[èÄÍÒu€@ Press ESC to exit from HELPËué\-
ENTERING FORMULAS INTO A CELLG FORMULAS INTO A CELL******************ÿC A QubeCalc cell may contain a formula which is made up of numbers,
E text, references to values in other cells, predefined functions, andèB mathematical and logical operators. A formula must begin with an &ˆ=A equal sign '=' and may be as complex as desired. For example...hichà7 =-2*@SIN(@IF(C2;2,@PI,@PI/2))/(@AVG(D11;4..F15;6))4;5;6)) of the @LEN( ))TRICALMtèPÿsó3íU2Ûë‰>Zˆ.\U3íëèÿs Eè1ÿsõèÿ‰>óˆ.õZ&ˆ=' The following operators are available:PX¢y[Ûu醉wè^tëÀŠÈ‹z. * Multiplication.ŠŠÈÀs(
ÀÐ؊ÈQSè)º
uéè
réèMùëè3
À[Y0 + Addition & And = Equal tooþ‹wK‰w[ÃèÃÿ<=tk4 - Subtraction | Or <> Not equal tooo‡Úè‰ÿtºþÍuÑë è-1 * Multiplication ~ Not < Less thannanr
ày<røZ,¢yŠ4 / Division > Greater thannÌ<#uèÌèeÏè€ÏŠÐ2= ^ Exponentiation <= Less than or equal tootoedence@ >= Greater than or equal tooÎYZQ‰@FUNCTIONS Predefined functions.ns.‹£.Cè¸Ë
Àtç<:tõ<þuC€?‹tKè¢&@FUNCTIONS Predefined functions..Æ9u€?(u
Xë\€?(XtIP[èÄÍÒu€A Press ESC to exit from HELPËué\,
TRIGONOMETRY FUNCTIONS TRIGONOMETRY FUNCTIONS*********************ÿ= QubeCalc provides the 8 trigonometry functions listed below.ìöÖ
îè
2 Illegal arguments will return ERROR as the value.‹6ŠŽ3Û2íüÊ.öèTEMPˆ.öÊÇ2Â"ÅtŠÇ2Æ"Å
Ø2øùÊUÒÅs&ˆ=ƒï
&Š=r
;>. u8.2 ÊUÒÍs &ˆ= @LEN( )ICALNS ÿ¸ŽÇ‹>óŠ.õŠdŠ6ö2Û&Š=ÃPR¡ó€ü œr€ì 3ÒQ¹P÷ñYÑàÑà& @COS(X) Returns the cosine of X.½ÿÿèœÿEè^ÿrèEÿrõèrÿ&ˆ=‰>óˆ.õ$ @SIN(X) Returns the sine of X.X.U3íëèÿs Eè1ÿsõèÿ‰>óˆ.õZ&ˆ=' @TAN(X) Returns the tangent of X..X¢y[Ûu醉wè^tëÀŠÈ‹z./ @PI Returns the value of PI (3.14159)è
réèMùëè3
À[Y) @ACOS(X) Returns the Arc Cosine of X, [ÃS»yþ‹wK‰w[ÃèÃÿ<=tk' @ASIN(X) Returns the Arc Sine of XÛÛÚÛ,0ŠÐ¶ڇÚè‰ÿtºþÍuÑë è-* @ATAN(X) Returns the Arc Tangent of XÚËwŠ< r
ày<røZ,¢yŠ @ATAN(X,Y) Returns the Arc Tangent of Y/Xr<[õÃKèˆÌ<#uèÌèeÏè€ÏŠÐ2 @HOUR(X)S‹6à‹ÚÑã‹‹ñ¬[
ÀÃépÏ3À¢e¢f£l¡\£HŠ<½u¢eCKè:ÌèDÐKè3Ìt[@FUNCTIONSSlKèÌtFèõË,<©tèíËAèéËLèåËLtjèßË,<©ue
Àœ¢fèõËèCÑQè ÎYZQ‰
@FUNCTIONSHY;ÙrCu:¡.P‹0KCŠC
ué×C‹£.Cè¸Ë
Àtç<:tõ<þuC€?‹tKè¢RETURNLL
éyÐéÌÍèËtÖSÆ9
èèÍtT€Í€2ÀèlÍÆ9u€?(u
Xë\€?(XtIP[èÄÍÒu€D Press ESC to exit from HELP.é\,

HELP INDEX HELP INDEXNDSNDS ***********************C This help index lists a few of the major capabilities of QubeCalc.iv;F Use the arrow keys to move between subjects and hit the return key Ù1 to select the subject for which help is desired.ealing with theCK contents of rows and/or columns of cells.
vr
OpBMACROS How to create, define, undefine, and run macros. in A@FUNCTIONS Listings of the predefined functions available.. pr>SCREEN Information provided on the QubeCalc screen.he of
AMOVING AROUND How to move around the screen and the WorkQube...r2 AFUNCTION KEYS Descriptions of the special functions provided.. toQEPERSPECTIVE How to change the viewing perspective of your data..8MAIN MENU Commands available from the main menu.. create 7SORTING How to sort a range by row or column.f cells..ÿnd;7NAMING BLOCKS How and why to name a block of cells.to load and;
vFLINKING How to link to a block of cells in another WorkQube. QUIT This selection exits QubeCalc. The WorkQube is not
automatically saved... remember to save first!
o,B Press ESC to exit from HELP. be
,*$0./
FUNCTION KEYSIONS SPECIAL FUNCTIONSU¢1ÿdriveFASTWRITE E QubeCalc provides several special functions which have been assignedE to the 10 function keys F1, F2, .. F10. These special functions arem listed below. single cells or groups of cells.KÿwÃTòTEMPSCREEN
ÿþæ/TòMONOSCREEN
ÿþâ/TòCOLORSCREENÿqè÷MAXMEM ÷
NUMBER A cell may contain a single number.which consists ofrs;[F1] HELP Calls up a context sensitive help screen..ity.ô÷C<[F2] EDIT Allows you to edit the contents of a cell. cell.Ì÷HE[F3] BLOCK Allows you to define blocks when entering formulasdF[F4] ABS Toggles cell references between absolute & relative8[F5] GOTO Allows you to go to a designated celld cell.ÿ >[F6] FIND Searches for a given string in the WorkQubee.

?[F7] STATUS Displays the status/defaults of the WorkQubeee. key<[F8] MACRO Allows you to define/undefine user macros formulass;[F9] CALC Performs a recalculation of the WorkQube..functionAE[F10] GRAPH Displays the graph defined by the current settingss*a
PCOMDEDITCOM 4LÞ
¸HELPMAKEBAK ÀC Press ESC to exit from HELP.w%
 !!"#
ENTERING A NUMBER INTO A CELL A NUMBER INTO A CELLxÆC‰vÃS»Í=ëS» E A number can be entered into a QubeCalc cell by simply typing in the@ number. A number can be anything in the range from -1.0E+37 to
'E +1.0E+37, and can have up to 11 significant places. A number may be€C entered in either standard notation (i.e. 12.345) or in scientificrå notation (i.e. 12.345e-2).
ë²ë2Ò¿‡3Ɋ
ÀtG€útô<.u‹Ï<\uê3ÉëæÉt
Òu‹ùO.Š 2íãÿÆt F.ŠˆGâñÆþ‡ë¿‡¹ üó¥Ã¾‡éaþ¾Çé[þ¾Çü¬è Cells which contain numbers (or which contain a formula which yieldsëX‡^]À>ŽtÆŽéÔÂÀ>Ž
tøÆŽ
é»Â€>ŽtéÆŽP ¢XÀ>ŽtÔÆŽP ¢XËó‹úüó¤‹Þ‹×Ëó‹úýó¤ü‹Þ‹×Ã3À¢­¿¹!üóª@¿±¹óª@¿º¹«¸ÿÿ¿³¹óª¸l¿¾¹ó«°¿Ê¹–óªÆÊÆÎÆïÆ
Æ@Æ`Çë
°º°€>t. n
¶¸¢“‰É”‰–‰¾‰Â‰Æ‰šÃè•.Šk
þʶè~Âèïþÿx‹xÆé¸îè`ü»ÿÿS‹xÇ
ÿxƨƲ
ÇeîXè»þè'Á[vCèÃè0Š°
ÉtDNUMBER FORMATS Cells which contain numbers can be displayed in a’/ number of different formats.…ézÿèäÈ<t< s;»ÊÆ
CS»Ê¾±Wµÿè[
ÀuS»Ê¾yXµèn[
ÀùtþÈt »YÙÙ.‹ùÃèœè™ÈþÊCˆu¼èë·è¢uäS3ۈ°è¤»ÊŠPCŠ€°èXþÈuï[ÃPèÝX< réhPP°^èaX@è[XñC Press ESC to exit from HELP.¾è 
DATE / TIME FUNCTIONS DATE / TIME FUNCTIONSS***********************ÿB QubeCalc represents dates as serial numbers where Jan 1,1900 = 1,= 1,D Jan 2,1900 = 2, and so on. Time is represented as a fraction whereèF midnight = .0, noon = .5, 6:00PM = .75, and so on. This allows dates; and times to be manipulated with ordinary math operations.llows datesF @NOW returns a number whose integer part is the serial number for theA current date and whose fraction part represents thent.he current time.erial number for the given year,month,& dayF @DATE(y,m,d) returns the serial number for the given year,month,& dayF @TIME(h,m,s) returns the fraction for the given hour,minute, & second5 @YEAR(X) returns the year for the serial date X. X.e X.ºþÍuÑë è-6 @MONTH(X) returns the month for the serial date X. X.e X.øZ,¢yŠ4 @DAY(X) returns the day for the serial date X. X.e X.ÌèeÏè€ÏŠÐ27 @HOUR(X) returns the hour for the fraction time X. X.e X.DÐKè3Ìt[9 @MINUTE(X) returns the minute for the fraction time X. X.e X. ÎYZQ‰9 @SECOND(X) returns the second for the fraction time X. X.e X..tKè¢
@FUNCTIONSyÐéÌÍèËtÖSÆ9
èèÍtT€Í€2ÀèlÍÆ9u€?(u
Xë\€?(XtIP[èÄÍÒu€@ Press ESC to exit from HELP.Ëué\,
VIEWING ANOTHER PERSPECTIVEING ANOTHER PERSPECTIVEEECTIVEvÃS»Í=ëS» F QubeCalc allows you to look at (or enter) your data in any of the sixC possible perspectives (or faces). The six faces are designated by'F the first six letters of the alphabet (A thru F, see AXIS DIRECTIONS)@‹÷è½Êr€=tŠ
Àt GÿÆróë*Æ\GÿÆt 2íüŠ< vQW¿Þ>ò®_Yt
CˆGÿÆråC The letter of the current face is shown on the screen in the upperoÉtE left corner in front of the current cell name in square brackets [].è in the upper left corner in front of the current cell name. IntèèµÊë addition the X, Y, and Z axes are also labeled.P ¢XÀ>ŽtÔÆŽ Y Xüóª@¿±¹óª@¿º¹= The current orientation of the axes may be changed using theÇë
°@ /WorkQube Perspective command. This will in effect rotate your datax7 data so that you may view it from another perspective.CèÃè0Š°
ÉtTHE SCREEN èeþÉuùˆ°èG
è_s-tՀþr
Æ…ÿÆ‚€æ»ASR»ÅºÉ¹é¸þè’É뢅Ƃ‹Àûés˜€>³tPèÕXˆCSèu[‰Àè…ézÿèäÈ<t< s;»ÊÆ
CBAXIS DIRECTIONS Each face is a different alignment of the axes.u¼èë·è¢uäS3ۈ°è¤»ÊŠPCŠ€°èXþÈuï[ÃPèÝX< réhPP°^èaX@è[XñC Press ESC to exit from HELP.¾è%DATAFILL DATAFILLFILL^èLö‹xÆC‰vÃS»Í=ëS» A The DATAFILL command provides a way to fill a specified block ofTƒÆA cells with a sequence of numbers. You are asked for an equationableE which is used to determine the values placed in each of the cells to€C be filled. The DATAFILL command provides a variable named # whichråA is initialized to 0 and is incremented by 1 for each cell in theëæÉtB block. This variable may be used anywhere within the equation toü¬è? provide an endless number of sequences which may be generated.tèèµÊë> A sample of the types of sequences which may be generated is:tÔÆŽP ¢XËó‹úüó¤‹Þ‹×Ëó‹úýó¤ü‹Þ‹×Ã3À¢­¿¹!üóª@¿±¹óª@¿º¹A =# (or simply hitting return) generates a sequence from 0 to theë
° of cells in the block.‰–‰¾‰Â‰Æ‰šÃè•.Šk
þʶè~ÂèïþÿxB =#*3+5 generates a sequence starting with 5 and incrementing by 3
ÉtF =@EXP(#) generates an exponential sequence (notice that sequences areB not limited to fixed step sizes as in other spreadsheet fillll
C commands!))quence is not restricted to being a fixed step size¼è as in most other spreadsheet fill commands.ÝX< réhPP°^èaX@è[XñE Press ESC to exit from HELP.
LOGICAL FUNCTIONS LOGICAL FUNCTIONS**********************Ðÿ
ÿF QubeCalc provides the following logical functions. All arguments may@ be numbers, cell references, or other formulas. @IF may returnE mayè" either numbers or text (or both). both).ï
&Š=r
;>. u8.2 ÊUÒÍs &ˆ= @TRUE returns the value 1.õŠdŠ6ö2Û&Š=ÃPR¡ó€ü œr€ì 3ÒQ¹P÷ñYÑàÑà @TRUE returns the value 10¡, £0 ZXýÿÿèœÿEè^ÿrèEÿrõèrÿ&ˆ=‰>óˆ.õ @FALSE returns the value 02Ûë‰>Zˆ.\U3íëèÿs Eè1ÿsõèÿ‰>óˆ.õZ&ˆ= @IF(CONDITION, ARG1, ARG2) If the value of condition is true (not.A If the value of CONDITION is true (not equal to 0) then ARG1rned,- is returned, otherwise ARG2 is returned.d.is returned..[ÃèÃÿ<=tk @MAX( ))Rë뺵<,tÑ<;tÝ<:sÉ<0rŊڊþÛÛÚÛ,0ŠÐ¶ڇÚè‰ÿtºþÍuÑë è-2 @ISNUM(X) returns TRUE if X is a numerical value.< r
ày<røZ,¢yŠ. @ISTEXT(X) returns TRUE if X is a text value.s returned, if SELECTORR is 2 then ARG2 is returned, and so on. If SELECTOR is greaterrt[ than the number of arguments provided, ERROR is returned..è ÎYZQ‰
@FUNCTIONSHY;ÙrCu:¡.P‹0KCŠC
ué×C‹£.Cè¸Ë
Àtç<:tõ<þuC€?‹tKè¢RETURNLL
éyÐéÌÍèËtÖSÆ9
èèÍtT€Í€2ÀèlÍÆ9u€?(u
Xë\€?(XtIP[èÄÍÒu€@ Press ESC to exit from HELPËué\,
FINANCIAL FUNCTIONS FINANCIAL FUNCTIONS***********************Ðÿ
ÿA QubeCalc provides 4 financial functions. In these functions theîè
B number of periods must be greater than zero and the interest rate.öè% must be greater than or equal to -1. the future value of an annuityˆ=? @FV(Payment, Interest, Periods) returns the future value of an÷ñYÑàÑàB annuity where Payment dollars are invested per period for theˆ.õ; number of Periods at the given percentage of Interest.of an annut@ @PV(Payment, Interest, Periods) returns the present value of ant the.B annuity where Payment dollars are received per period for the
À[Y; number of Periods at the given percentage of Interest. period dueF @PMT(Principal, Interest, Periods) returns the payment per Period dueE for borrowing Principal dollars for the number of Periods at the" given percentage of Interest.±Íéˆþ÷Úà Àtç<:tõ<þuC€?‹tKè¢
@FUNCTIONSyÐéÌÍèËtÖSÆ9
èèÍtT€Í€2ÀèlÍÆ9u€?(u
Xë\€?(XtIP[èÄÍÒu€B Press ESC to exit from HELPué\,REPLICATING A CELL TO A BLOCKATING A CELL TO A BLOCKÆC‰vÃS»Í=ëS» F QubeCalc allows you to copy a single cell to a 3 dimensional block ofD cells. First, move the cell pointer to the cell to be copied, thenE select the /Cell Copy command. You will then be asked to define the€@ block to copy the cell to. Once the block has been defined theÿÆråC contents of the original cell will be copied into each cell in theÉtC block. If the original cell contains a formula with relative cellü¬èF references, those references will be adjusted when they are copied to the new cells.ŽéÔÂÀ>Ž
tøÆŽ
é»Â€>ŽtéÆŽP ¢XÀ>ŽtÔÆŽP ¢XËó‹úüó¤‹Þ‹×Ëó‹úýó¤ü‹Þ‹×Ã3À¢­¿¹!üóª@¿±¹óª@¿º¹ °º°€>t. n
¶¸¢“‰É”‰–‰¾‰Â‰Æ‰šÃè•.Šk
þʶè~ÂèïþÿxCABS/REL How absolute and relative cell references work.
ÉtFORMATèá° èeþÉuùˆ°èG
è_s-tՀþr
Æ…ÿÆ‚€æ»ASR»ÅºÉ¹é¸þè’É뢅Ƃ‹Àûés˜€>³tPèÕXˆCSèu[‰Àè…ézÿèäÈ<t< s;»ÊÆ
CS»Ê¾±Wµÿè[
ÀuS»Ê¾yXµèn[
ÀùtþÈt »YÙÙ.‹ùÃèœè™ÈþÊCˆu¼èë·è¢uäS3ۈ°è¤»ÊŠPCŠ€°èXþÈuï[ÃPèÝX< réhPP°^èaX@è[XñD Press ESC to exit from HELP..SPECIAL MACRO KEYS MACRO COMMANDSLö‹xÆC‰vÃS»Í=ëS» D When creating a macro you may generally just type the desired keys.inD In the case of Function Keys, cursor movement keys, and a few otherE special keys it is necessary to type the name of the key CAPITALIZED€< and enclosed in square brackets, i.e. []. Below is a list. names..råB ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍËÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍËÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» »tB º [UP] Up Arrow º [INS] Insert Key º [BLOCK] Block Key ºü¬èB º [DOWN] Down Arrow º [DEL] Delete Key º [GRAPH] Graph Key ºèµÊëB º [LEFT] Left Arrow º [EDIT] Edit Key º [ABS] Abs/Rel ºÆŽB º [RIGHT] Right Arrow º [GOTO] Goto Key º [SUP] Screen  º¹B º [PGUP] PgUp Key º [FIND] Find Key º [SDOWN] Screen  º
°B º [PGDN] PgDn Key º [STAT] Status Key º [SLEFT] Screen  ºþÿxB º [RET] Return Key º [CALC] Recalc Key º [SRGHT] Screen  º
ÉtB º [ESC] Escape Key º [BS] Backspace º ºþè’B º [HOME] Home Key º [BEEP] Control G º ºÆ
CB º [END] End Key º [ERASE] Erase Line º ºu¼èB ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÊÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÊÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼXñDMORE COMMANDS Press ESC to exit from HELP.. DEFINING A BLOCK OF CELLSFINING A BLOCK OF CELLSSSxÆC‰vÃS»Í=ëS» D QubeCalc lets you define or describe a cell or 3D block of cells byÆA highlighting the desired block and then pressing the return key.'D When a block is being defined all the cells in the block (which areЀE visible) will be highlighted on the screen. On the command line youåA will see either a single cell address or a block address (2 cellëæÉtA addresses separated by ..). A single cell address means that anü¬èB "anchor" cell has not been selected. In this case, moving aroundèµÊëF with the arrows simply moves the cell pointer to a new cell, but doesB not highlight (or define) any other cells. If an anchor cell has¹E been selected then ALL cells between the anchor cell and the current°C cell are defined (and highlighted if visible). The following keysÿx1 are useful (or necessary) when defining a block:'Á[vCèÃè0Š°
Ét4 . (period) sets the anchor to the current cellllR»ÅºÉ¹é¸þè’1 ESC releases the anchor if it is settzÿèäÈ<t< s;»ÊÆ
CD[F4] toggles cell references between absolute & relativeelD[F5] & [F6] allow you to GOTO or FIND during a block definitionñB Press ESC to exit from HELP.P..!
*CREATING, DEFINING, AND UNDEFINING A MACROINING A MACROROvÃS»Í=ëS» @ QubeCalc allows you to assign multiple keystrokes to one of theTƒÆD 26 letters of the alphabet. This group of keystrokes is known as a "Macro".own as a "Macro") a name to identify what it accomplishes.ŠÐ€ The macro is created by simply typing the desired keystroke sequenceåE The macro is created by simply typing the desired keystroke sequencetB as text entrys into consecutive cells down a column (you may haveve¬èF to start each cell with a ' character to make it a text entry). OnceC the macro has been created in this manner it must be defined usingŽ= the [F8] MACRO function key. This key will pop up the macroacroectoA selection window to ask whether you want to define or undefine aoacroB macro. You will then be asked to select the letter to assign the axE macro to (or to undefine). Finally, you will be asked to define thetF beginning cell where your macro resides. NOTE that the macro MUST beE defined ([F8] key) IN THE FACE where the macro APPEARS as a column!!eD The macro is then run simply by hitting Alt and the macro's letter.¼èCONTINUES3ۈ°è¤»ÊŠPCŠ€°èXþÈuï[ÃPèÝX< réhPP°^èaX@è[XñB Press ESC to exit from HELP.P..
PRINT OPTIONSRO RUNNING A MACROCELLSxÆC‰vÃS»Í=ëS» @ The Setup string is sent to the printer each time the /Print GoTƒÆC command is selected (before the actual data is sent). You may set'@ this string to anything you wish. It is generally used to sendG´GŠÐ€D control sequences to the printer to select printer options (italicsråF or compressed print for example). To send a control character to theD printer simply place a slash character / followed by the ascii code¬è> (in decimal) for the control character into the Setup string.$tèèµÊë@ EXAMPLE: /027E sends an ESC E to the printer (this selectstÔÆŽ8 emphasized print on an EPSON printer).±¹óª@¿º¹F The Page Length option lets you select how many physical lines are onF a page (on 8«" x 11" paper at 6 lines per inch there are 66 lines).F The Top and Bottom margin options let you select how many blank linesF you want at the top & bottom of the page (printing starts on fourthF line if Top is 3, if Bottom is 2 there are 2 blank lines at the endD The Left margin option lets you select how many characters from the¼è- left edge you wish to begin printing from.X< réhPP°^èaX@è[XñB Press ESC to exit from HELP.P..ADDITIONAL MACRO COMMANDSADDITIONAL MACRO COMMANDSxÆC‰vÃS»Í=ëS» D In addition to the regular menu commands, there are 4 menu commandsÆD available only during macro execution. These commands are selectedC in the same manner as regular menu commands (use the / key, chooseŠÐ€F the Macro [M] option, and one of the 4 suboptions [I,G,?,Q]). The I,4 G, and ? suboptions require an additional argument.ô<.u‹Ï<\uê3ÉëæÉt /MI equation [RET] F.ŠˆGâñÆþ‡ë¿‡¹ üó¥Ã¾‡éaþ¾Çé[þ¾Çü¬èC /MIequation[RET] If the equation evaluates true (not = 0) the0))D Macro will continue reading keystrokes fromheF the same cell, otherwise the Macro will beginD reading keystrokes from the following cell..°F /MGcellname[RET] The Macro will continue reading keystrokes from, the specified cell.x;y;z.Á[vCèÃè0Š°
ÉtD /M?prompt[RET] The prompt is displayed and the user is askedhD for input to be placed in the current cell.el1 /MQ Macro execution is halted. cell.œè™ÈþÊCˆu¼è /MQ Macro execution is halted.réhPP°^èaX@è[XñE Press ESC to exit from HELP.GOTO CELL / FIND CELL GOTO CELL / FIND CELLDSxÆC‰vÃS»Í=ëS» E QubeCalc allows you to go to another cell using either the [F5] GOTOD key or the [F6] FIND key. These two functions may be used any timeE that you need to go to another cell (including when you are defining€ a block!).tŠ
Àt GÿÆróë*Æ\GÿÆt 2íüŠ< vQW¿Þ>ò®_Yt
CˆGÿÆråÃ"+,/;<=>[]{|}*?¾\3Vèhÿ^²
ë²ë2Ò¿‡3Ɋ
ÀtG€útô<.u‹Ï<\uê3ÉëæÉtC [F5] GOTO ... This function asks you which cell you want to go to.ü¬èF You just type in the name of the cell you want to go toD and hit return... and off you go! The name you enterddC may be a cell reference (like Z29;4) or a block namef aC which you have defined with the /Block Name command.f a with either the contents of a cell or with the cellggxF [F6] FIND ... This function will search the WorkQube for a match of aC string which you enter. It will compare your stringAT'B with either the contents of a cell or with the celllnrCE display (you select). If you select 'REPEAT' then thee= most recent string will be searched for again..ce.[XñC Press ESC to exit from HELP.P.WORKQUBE STATUS WORKQUBE STATUSTUSDSxÆC‰vÃS»Í=ëS» > Pressing the [F7] function key provides details on the globalTƒÆ= (WorkQube) settings. The following information is provided: †
'd

¹¿‡‹è9Ì< r €ü:uCCë ´èÞÊA´:‰GG
íu5€?\t0Æ\G´GŠÐ€CFORMAT/ The global (WorkQube) format (currency, fixed,berB DECIMAL PLACES percent, etc.) and number of decimal places.illt be displayed with..¹ üó¥Ã¾‡éaþ¾Çé[þ¾Çü¬è=CELL WIDTH The global (WorkQube) cell width (1-75).$tèèµÊëCELL WIDTH The default cell width.ÆŽP ¢XÀ>ŽtÔÆŽ;JUSTIFICATION The global (WorkQube) setting for textóª@¿º¹? justification (right, left, or centered).).ë
°ORDERt. n
¶¸¢“‰É”‰–‰¾‰Â‰Æ‰šÃè•.Šk
þʶè~ÂèïþÿxAORDER The global (WorkQube) order in which certainn
ÉtE commands operate on cells (row then column then? page, or page then row then column, etc)..ÊÆ
CS»Ê¾±Wµÿè[
ÀuS»Ê¾yXµèn[
ÀùtþÈt »YÙÙ.‹ùÃèœè™ÈþÊCˆu¼èë·è¢uäS3ۈ°è¤»ÊŠPCŠ€°èXþÈuï[ÃPèÝX< réhPP°^èaX@è[XñC Press ESC to exit from HELP.P.

&RECALCULATION AND AUTOCALCLCULATION AND AUTOCALCDSxÆC‰vÃS»Í=ëS» F QubeCalc automatically recalculates the WorkQube after any cell valueF is changed. The recalculation follows the order set by the /WorkQubeF Order command. This automatic recalculation feature (AutoCalc) has 3- possible settings, plus an iteration option:< vQW¿Þ>ò®_Yt
CˆGÿÆråÃ"+,/;<=>[]{|}*?¾\3Vèhÿ^²
ë²ë2Ò¿‡3Ɋ
ÀtG€útô<.u‹Ï<\uê3ÉëæÉtE WorkQube: The entire WorkQube is recalculated each time a cell valueè is changed.Oò®‹÷FFé0þU‹ì‡^Pœ.ŠC
Àt<€sè%ëè$tèèµÊë? Off: The WorkQube is not recalculated except for when the [F9] C& [F9] CALC key is pressed.3À¢­¿¹!üóª@¿±¹óª@¿º¹E Block: The cells in the defined 3D block are the only cells whiche are recalculated.–‰¾‰Â‰Æ‰šÃè•.Šk
þʶè~ÂèïþÿxB Iteration: Selects how many passes are made on each recalulation.ttomF [F9] CALC recalculates the current AutoCalc block shown at the bottom0 of the screen (even if AutoCalc is turned off).ézÿèäÈ<t< s;»ÊÆ
C
CALC ORDERè[
ÀuS»Ê¾yXµèn[
ÀùtþÈt »YÙÙ.‹ùÃèœè™ÈþÊCˆu¼èDEFINING BLOCKS褻ʊPCŠ€°èXþÈuï[ÃPèÝX< réhPP°^èaX@è[XñA Press ESC to exit from HELP.P.P.&MOVING AROUND IN THE WORKQUBEAROUND IN THE WORKQUBEEÆC‰vÃS»Í=ëS» A QubeCalc provides several ways of moving around in the WorkQube:TƒÆ Ét0ªAþÌuÝÉu°0ªA3ÀªX+ÁvAO‹÷øýó¤‹È° 󪾆èyÿ_^Ã@B †
'F   The arrow keys move the cell pointer up, down, left, or right ½Êr€=tŠ
Àt GÿÆróë*Æ\GÿÆt 2íüŠ< vQW¿Þ>ò®_Yt
CˆGÿÆråB PgUp The PgUp key moves you up to the next higher page number.æÉtC PgDn The PgDn key moves you down to the next lower page number.ü¬èC Home The Home key moves you to the top left corner of the page.µÊëF End The End key moves you to the bottom right corner of the page.5 ^PgUp and ^PgDn Moves you up or down by one screen..@¿±¹óª@¿º¹8 Ctrl and Ctrl Moves you left or right by one screen.@Æ`Çë
°6[F5] GOTO Lets you go to any cell you specify.ed string.èïþÿx@[F6] FIND Moves to a cell containing a specified string.oo
ÉtA All of these movement commands work whenever you need to move toorè’C another cell (including when you are defining a block of cells for
C any reason!).
ÀuS»Ê¾yXµèn[
ÀùtþÈt »YÙÙ.‹ùÃèœè™ÈþÊCˆu¼èë·è¢uäS3ۈ°è¤»ÊŠPCŠ€°èXþÈuï[ÃPèÝX< réhPP°^èaX@è[XñC Press ESC to exit from HELP.P.!!!AXES DIRECTIONS OF QUBECALC FACESme¾Çè÷ûÆÇuèB é·ûè¿ÇècëÇ€) FACE Cè5èkÖ
Loading è0¸=º‡è) ÉÍÍÍÍÍÍÍÍÃèôÿ‹ÚCÿ&~‹ÚKÿ&€è-ÖègèÖFi, ÉÍÍÍÍÍÍÍÍͺÍÍÍÍÍÍÍÍÍÍ»èS»ÐèeÍ[ÃèèÕè"èÊÕInva, º PAGE 3  ºèàÿÆÇé›ú3À@ë3À€>…t2, FACE E ÉÍÍÊÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» ºpýu
ÃèÆ…¾Çè
è<Õ
Sa, ÍÍÍÍÍÍÍÍ º PAGE 2 º º¶èÚÓr/“‹v‹x‹ùÆ+ÊA4 ÉÍÍÊÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º º FACE Bè¹ÔDisk full or in4 º A B C D ... º º ÍÍÍÍÍÍÍÍͺ¶èEÓ¾‡ŠF<*t0 ÆEÿ´;èÖÑ&  FACE FÿèËèÑÒ, ¸+h%ÿèâè¾Ò free& ÈÍÍÍÍÍÍÍ͸+j%ÿè¦è‚Ò free
€>I
t€ItÃèhÒStack/Heap: ¡lèLéjÒèOÒStack/Heap: ¡rè3è9Ò (minimum)
A Press ESC to exit from HELP.Ñ bytWORKQUBE ORDER WORKQUBE ORDERRDS**********ð2ÀÓèŠøŠÆèÐÿ
ÿF Because QubeCalc is a TRUE 3-D spreadsheet there are six (6) possibleC orders in which recalculation, datafilling, etc. may be performed.öè< You may select any one of these possible orders, which are:UÒÍs &ˆ= A) columns, then rows, then pages pagesÃPR¡ó€ü œr€ì 3ÒQ¹P÷ñYÑàÑà8 A) Columns change fastest, then Rows, then Pagesèrÿ&ˆ=‰>óˆ.õ8 B) Pages change fastest, then Rows, then Columnsÿ‰>óˆ.õZ&ˆ=8 C) Rows change fastest, then Pages, then Columnsè^tëÀŠÈ‹z.8 D) Rows change fastest, then Columns, then PagesèMùëè3
À[Y8 E) Pages change fastest, then Columns, then RowsK‰w[ÃèÃÿ<=tk8 F) Columns change fastest, then Pages, then Rowsè‰ÿtºþÍuÑë è-JUSTIFY(èfr‹úªB<;t
è_ÿþÍuñéÏ[éûÐèÖÿè‰Ð‡ÚËwŠ< r
ày<røZ,¢yŠ> The WorkQube order will be followed as above according to theichreeÐ2B perspective you are currently looking at. The order is used when3Ìt[E performing the following functions: recalculation, copying blocks of‰" cells, graphing, and datafilling.ué×C‹£.Cè¸Ë
Àtç<:tõ<þuC€?‹tKè¢DATAFILL
éyÐéÌÍèËtÖSÆ9
èèÍtT€Í€2ÀèlÍÆ9u€?(u
Xë\€?(XtIP[èÄÍÒu€A Press ESC to exit from HELP.ué\

GRAPH OPTIONSAY COLOR / DISPLAY**********ð2ÀÓèŠøŠÆèÐÿ
ÿ@ A separate Legend may be provided for each of the 3 data blocksnts or@ (A, B, and C). The Legend is a short text string which tells aÊ.öèC little bit about the data block (i.e. why it is different from the&ˆ= other data blocks).Nj>óŠ.õŠdŠ6ö2Û&Š=ÃPR¡ó€ü œr€ì 3ÒQ¹P÷ñYÑàÑàROTATEàÑàr€Ä ‹Ð¡* £. ¡, £0 ZXýÿÿèœÿEè^ÿrèEÿrõèrÿ&ˆ=‰>óˆ.õD A TITLE may be provided which describes the graph as a whole. Thisˆ=? title is placed over the top of the graph if it is provided.ŠÈ‹z.C LABELs which describe the X and Y axes may be provided and will beÀ[YC placed along the X and Y axes if provided.e provided and will be=tkA The values placed along the Y axis may be FORMATted using any ofofè-= QubeCalc's standard formats (currency, fixed, date, etc.).øZ,¢yŠE The SPACING option lets you decide how to space the values along the2B X axis. If SPACING=1 then every value from the X BLOCK will be3Ìt[E placed along the X axis. If SPACING=3 then every third value from‰C the X block will be used. This lets you avoid a clogged X axis.Kè¢BFORMATS These are the formats you can use for the Y axis.Òu€B Press ESC to exit from HELPué\ 
STATISTICAL FUNCTIONS STATISTICAL FUNCTIONS*******************Ðÿ
ÿ? QubeCalc provides seven functions which calculate and return a value
B statistical summary of a list of values. The list may consist of.öèF numbers, cell references, formulas, or 3 dimensional blocks of cells.D Blocks of cells are defined by using the cell names of two oppositeÑàB corners of the block separated by two periods (i.e. C2;3..F4;5).;3).? Each individual item in the list must be separated by a comma..õZ&ˆ=1 EXAMPLE: @SUM(1.23, A1;1, 2*@PI, C2;3..F4;5)7;7;7)è^tëÀŠÈ‹z.7 @COUNT(list) returns the number of values in the list.èMùëè3
À[Y: @AVG(list) returns the average of the values in the list.w[ÃèÃÿ<=tk6 @SUM(list) returns the sum of the values in the list.‡Úè‰ÿtºþÍuÑë è-3 @MINI(list) returns the minimum value in the list. r
ày<røZ,¢yŠ3 @MAXI(list) returns the maximum value in the list.èˆÌ<#uèÌèeÏè€ÏŠÐ2; @VAR(list) returns the variance of the values in the list.:ÌèDÐKè3Ìt[E @STD(list) returns the standard deviation of the values in the list.‰FUNCTIONSsHY;ÙrCu:¡.P‹0KCŠC
ué×C‹£.Cè¸Ë
Àtç<:tõ<þuC€?‹tKè¢
@FUNCTIONSyÐéÌÍèËtÖSÆ9
èèÍtT€Í€2ÀèlÍÆ9u€?(u
Xë\€?(XtIP[èÄÍÒu€C Press ESC to exit from HELP.é\,0COPYING A BLOCK OF CELLS TO THE CURRENT LOCATIONUBEEÆC‰vÃS»Í=ëS» E QubeCalc allows you to copy a 3D block of cells to another location.E First, move the cell pointer to the cell where you want the block ofF cells copied to. Then select the /Block Copy command. You will thenD be asked to define the block which is to be copied. Once the blockrå> has been defined the block of cells will be copied to the newê3ÉëæÉtD location. The cell in the near, upper right corner of the block to¬è? be copied will be the one which is copied into the "cell to bebeèèµÊë> copied to". If any cells in the block contain a formula withtÔÆŽC relative cell references, those references will be adjusted during¹ the copy to the new location.óªÆÊÆÎÆïÆ
Æ@Æ`Çë
°º°€>t. n
¶¸¢“‰É”‰–‰¾‰Â‰Æ‰šÃè•.Šk
þʶè~ÂèïþÿxA If the block you define is a two dimensional range (not multipleon.ÉtB pages), the QubeCalc will allow you to copy the range to multipleþè’5 pages. You will be asked how many pages to copy to.ferences work..
CDDEFINING BLOCKS How to define a block to copy to a new location.¼èCABS/REL How absolute and relative cell references work.XñA Push ESC to exit from HELP.P.P.THE QUBECALC SCREEN THE QUBECALC SCREENNU¢1ÿdriveFASTWRITE E The QubeCalc screen provides information such as the number of bytesF available for data, the current directory/file, the current block for' recalculation, and a cell status line.f cells.KÿwÃTòTEMPSCREEN
ÿþæ/TòMONOSCREEN
ÿþâ/TòCOLORSCREENÿqè÷MAXMEM ÷
< [C]B4;5: NUMBER (9) .... AN EXAMPLE OF THE CELL STATUS LINEEists ofrs [C]3;4;5 NUMBER (9) .... AN EXAMPLE OF THE CELL STATUS LINExt.ÿô÷CE Each component of the above line tells you certain information aboutHB the current perspective and cell. The [C] tells you that you are C currently viewing perspective C. The B4;5 tells you that the cellley/ you are at is in column B and row 4 on page 5. and 5 respectively.onE The next item "NUMBER" tells you what type of item is in the currentD cell (either Blank, Text, Number, Formula, or Error). And finally,ey9 the (9) tells you what the width of the current cell is.the WorkQubee in a number of different ways.d using the functionA The axes are also labeled with the current X, Y, and Z orientation.*a
PCOMDEDITCOM 4LÞ
¸HELPMAKEBAK À? Press ESC to exit from HELP.LP.w%
MATH FUNCTIONS MATH FUNCTIONS************************Ðÿ
ÿ> QubeCalc provides the 12 mathematical functions listed below.w.
îè
2 Illegal arguments will return ERROR as the value.ill result in an.öèB @CELL Returns the value of the current (highlighted cell).n.ˆ=. @ABS(X) Returns the absolute value of X..€ü œr€ì 3ÒQ¹P÷ñYÑàÑà0 @EXP(X) Returns e to the X power (e = 2.7)ÿrèEÿrõèrÿ&ˆ=‰>óˆ.õ+ @LN(X) Returns the natural log of X..èÿs Eè1ÿsõèÿ‰>óˆ.õZ&ˆ=+ @LOG(X) Returns the log base 10 of X..[Ûu醉wè^tëÀŠÈ‹z., @INT(X) Returns the integer part of X..éè
réèMùëè3
À[Y/ @FRAC(X) Returns the fractional part of X..yþ‹wK‰w[ÃèÃÿ<=tk @MOD(X,Y) Returns X modulo YrŊڊþÛÛÚÛ,0ŠÐ¶ڇÚè‰ÿtºþÍuÑë è-= @RAND Returns a random number in the range 0 <= X < 1øZ,¢yŠ4 @ROUND(X,Y) Returns X rounded to Y decimal places.ˆÌ<#uèÌèeÏè€ÏŠÐ28 @SQRT(X) Returns the square root of X (for X >= 0)..Kè:ÌèDÐKè3Ìt[5 @FACT(X) Returns X factorial (for 0 <= X <= 30)..fèõËèCÑQè ÎYZQ‰F @SGN(X) Returns the sign of X (-1 for X<0, 1 for X>0, 0 for X=0)
@FUNCTIONSyÐéÌÍèËtÖSÆ9
èèÍtT€Í€2ÀèlÍÆ9u€?(u
Xë\€?(XtIP[èÄÍÒu€@ Press ESC to exit from HELP.Ëué\,
@FUNCTIONS @FUNCTIONSS************************Ðÿ
ÿC QubeCalc provides a large number of predefined functions which mayybeB be used in formulas. Most of these functions require one or more.öèF arguments (which are enclosed within parentheses). The function willF return a number or string and may be treated exactly like a number or? string would be. Functions may be nested as deeply as desiredberˆ.õB (remember that there is a 70 character per cell maximum, though).tionF The function names must begin with an @ and must be CAPITALIZED. The, following types of functions are supported.uéè
réèMùëè3
À[Y"SPECIAL choose, indexe, square root, logarithm, etc.tc.tkAMATHEMATICAL absolute value, square root, logarithm, etc.ë è-@TRIGONOMETRY sine, cosine, tangent, arctangent, pi, etc.c..Š@STATISTICAL sum, count, minimum, maximum, average, etc.è€ÏŠÐ2*LOGICAL true, false, if, etc.sealue, etc..CKè:ÌèDÐKè3Ìt[6FINANCIAL present value, future value, etc., year, etc..ZQ‰BDATE / TIME current date and time, day, month, year, etc.Kè¢BTEXT length, find, replace, mid, left, right, etc..u€B Press ESC to exit from HELP.ué\4+(3CELL REFERENCE EXAMPLE GRAPH COMMANDSDS*******************ŠÆèÐÿ
ÿE Cell C3 contains the formula =$A1+A1. It is then copied to cell D5.
< The absolute reference ($A1) continues to point to cell A1.hedüÊ.öèD The relative reference (A1) continues to point to the cell which ish.? 2 columns to the left and 2 rows above (Now B3 instead of A1).phs..Ñà ÉÍÍÍÍÍÍÍ» ÉÍÍÍÍÍÍͻͻ lines, symbols, orõ? A B C D E A B C D E.õZ&ˆ=D 1 ±±±ÍÍÍÍÍÍÍ»  Abs ref 1 ±±±ÍÍÍÍÍÍÍÍÍÍÍÍ»  Abs ref.: 2  º 2 ºced alongÀ[Y: 3 ÈÍÍÍÍÍÍÍͲ²² =$A1+A1 3 °°° ºntaining the: 4  4  º WorkQube odC 5 Rel ref (2 cols left 5 ÈÍÍÍÍÍÍÍͲ²² =$A1+B3..1 6 & 2 rows up) 6  ks to be graphed.Ð2D Rel ref (2 cols leftt[E & 2 rows up).7 BEFORE COPY AFTER COPYn you are intheF =====================================================================@ Press ESC to exit from HELPELPé\'
NAMING A BLOCK OR CELLS@ QubeCalc allows you to give your own name to a cell or block offA cells. This name can then be used anywhere that a cell or block% reference can be used. For example:F If you assigned the name "COST" to cell C5;1 and "PRICE" to D7;1 then9 - The formula =PRICE-COST is identical to =D7;1-C5;1F - You can go to cell C5;1 by typing COST when using the [F5]GOTO key@ If you assigned the name "PRICES" to the block B3;1..C6;2 then:B - The formula =@AVG(PRICES) is identical to =@AVG(B3;1..C6;2)A - You can go to cell B3;1 by typing PRICES when using [F5]GOTO.F - You can erase block B3;1..C6;2 (or perform any other block command? by typing PRICES when you are asked for the block to use.NG RANGES How to define a range of cells..ASR»ÅºÉ9HOW TO DO IT How to name a cell or block of cells.ll references? Press ESC to exit from HELPrences rk.u¼è2è¢uäS3ۈLINKING SPREADSHEETS TOGETHERe name¾Çè÷ûÆÇuèB é·ûè¿ÇècëÇ€E QubeCalc allows you to link to blocks in another WorkQube. You makeè< the link using the /Block Link command. You need to enter:-ÖègèÖFie not foundèJþé0èßÿë_<tèÖèUèèÕNew FileèS»ÐèeÍ[ÃèèÕè"èÊÕInva@ 1. The name of the QubeCalc file to link to (without the .QUB)…t2? 2. The name of the block to link to. This block name can be:è<Õ
Sa) - a cell reference (example: C32;5)3ɺ¶èÚÓr/“‹v‹x‹ùÆ+ÊA1 - a block reference (example: B10;2..C13;5)è
è¹ÔDisk full or in( - a block name (example: INTEREST)ù¹
èXèàù´º¶èEÓ¾‡ŠF<*t0 ÀuñŠDþ¾u3<:t<\t´N¹º‡èÓr
öËt¾p3è­è2ÔDirectory of èôè6Ô´NE The cell which you are sitting on when you create the link will holdèD the actual link, and is known as the "link cell". This "link cell"uC will take on the same value as the cell it is linked to (or to the<wC upper left corner of the block it is linked to). If you link to aèÖÑB block, then the cells behind, below, and to the right of the linkfreeA cell will take on the values of the corresponding cells from the
t€ block in the other file.èLéjÒèOÒStack/Heap: ¡rè3è9Ò (minimum)
? Press ESC to exit from HELPèèÑ bytSORTING A RANGE OF CELLSNGED QubeCalc allows you to sort a range of cells by row or column usingg.D the /Block Sort command. You will be presented with these options: reference can be used. For example:= BLOCK: Lets you define the range of cells you want sorted.n you@ KEY: Lets you select the row or column you want to sort on. likeC Although only one key is provided, it is possible to sorth aE a range on as many keys as you want. Simply sort the rangenD on the last key first, the next to last key second, and sork@ on (the primary key will be the last one you sort on).3 OPTIONS: Lets you select whether you want to sort:.C6 then:" - ROWS or COLUMNShe range name which is associated" - TEXT or NUMBERSu select this option, just enter the3 - in ASCENDING or DESCENDING orderr be done..mand) by typing PRICES when you are asked for the range to use.F GO: Performs the sort using the current range, key, and options.SORT EXAMPLEGES How to name a cell or range of cells.ll referencesB Press ESC to exit from HELPces 
TITLE LOCKINGGEHEETS TOGETHERRAPH COMMANDSDS*******************ŠÆèÐÿ
ÿB QubeCalc allows you to lock title rows and columns on the screen.D5.
D The /WorkQube Title command acts as a toggle to turn locking on andèD off. If you are in title lock mode, the letter "L" will be visibleh.C on the bottom line of the screen. When you turn title locking on,.ÑàD the rows above and the columns to the left of the cell pointer willõB be locked onto the screen. You cannot move the cell pointer intoZ&ˆ=A rows and columns which have been locked on the screen. You alsoref.E cannot move the cell pointer into any pages which lie below the pageYB where you set title locking on. The locked rows and columns will theC remain displayed on the screen even when you move the cell pointer odD off the right side or bottom of the screen. Only the unlocked rows. and columns will scroll.s up) 6  ks to be graphed.Ð2 Rel ref (2 cols leftt[@ Each of the 6 faces of the WorkQube can be locked individually.s up). BEFORE COPY AFTER COPYn you are inthe =====================================================================A Press ESC to exit from HELPPPé\
HOW TO NAME A CELL OR BLOCKD You name a block by selecting the /Block Name option from the menu.u.B You are presented with three choices: Define, Undefine, and List. reference can be used. For example:B DEFINE: This option lets you name the cell or block. When youE select this option you are asked what name you would likeF to give to the cell or block. This name must begin with aF letter of the alphabet and can be up to 8 characters long.F You are then asked to define the block to name. Just mark? off the block (or cell), hit return, and that's it.. If you assigned the name "PRICES" to the range B3..C6 then:C UNDEFINE: This option releases the block name which is associatedF with a block. When you select this option, just enter the= name of the block to release and it will be done..mand) by typing PRICES when you are asked for the range to use.A LIST: This option lists the current block names (up to 51).źÉDEFINING BLOCKS How to name a cell or range of cells.ll references@ Press ESC to exit from HELPences TEXT FUNCTIONS
PageLengthNoYesRowColumnC QubeCalc provides functions which manipulate text. Text argumentssD must either be a text string enclosed with quotes "like this", or axi) reference to a cell which contains text.NoCommaCommaHiddnLockSortKeyBLANKTEXTNUMBERERRD @UPPER(str) and @LOWER(str) convert str to all upper or lower case.wi3 @LEN(str) returns the number of characters in str.c5 @VALUE(str) returns the number which str looks like.copy to the 3 @LEFT(str,n) returns the left n characters of str.lculate?: 5 @RIGHT(str,n) returns the right n characters of str.saveC @MID(str,x,y) returns y characters of str starting at character x.E @STRING(n,x) returns a string which looks like n with x places after the decimal point.UPDOWNLEFTRIGHTPGUPPGDNBF @FIND(str1,str2,n) finds the first occurance of str1 in str2 starting with the nth character.PGRTPGLTHPKMIQRS @ACGO=B>ts'"^B @REPLAC(str1,x,y,str2) removes y characters from str1 starting atFALSB character x and inserts str2 into str1 at the same position..RD Press ESC to exit from HELP.SPECIAL FUNCTIONS @FUNCTIONSS************************Ðÿ
ÿ? QubeCalc provides the following functions which provide lookup mayybe capabilities:rmulas. Most of these functions require one or more.öè arguments (which are enclosed within parentheses). The function will( @CHOOSE(SELECTOR, ARG1, ARG2,..., ARGN)eated exactly like a number orE If the value of SELECTOR is 1 then ARG1 is returned, if SELECTOR isF 2 then ARG2 is returned, and so on. If SELECTOR is less than one orC greater than the number of arguments provided, ERROR is returned.The returned..s of functions are supported.uéè
réèMùëè3
À[Y4 @INDEX("block name",ColOffset,RowOffset,PageOffset)garithm, etc.tc.tkB Returns the value of the cell in "block name" which is RowOffset è-F rows, ColOffset columns, and PageOffset pages from the first cell inE "block name". Notice that "block name" is a string argument rather2 than a simple block reference., if, etc.sealue, etc..CKè:ÌèDÐKè3Ìt[A EXAMPLES: @INDEX("A1;1",1,2,3) uses the block starting at A1;1.1;1.‰= @INDEX("BILL",1,2,3) uses the block named "BILL".L".c.Kè¢A @INDEX(A1;1,1,2,3) uses the block named in cell A1;1...u€A Press ESC to exit from HELP..ué\SORTING EXAMPLE It is possible to sort a range on as many keys as you want. Simply sort the range on the last key first, the next to last key second, and so on (the primary key will be the last one you sort on).