34
       ORDER     766
   Shareware    1580
         ASP    2430
      Blocks    3043
      Column    4662
 File_Import    5172
     Formats    6419
      F-Keys    6986
     General    9133
      Graphs   10662
  Graph_Type   11077
   GraphXtra   11941
 Graph_Other   12720
        Keys   13332
     Linking   14040
      Macros   14805
  Macro_Keys   15547
 Macro_Words   16135
     Parsing   17433
 Print_Codes   17941
    Printing   19037
    Querying   19847
     StartUp   22815
     Sorting   23459
  @Date/Time   24038
    @Finance   24777
      @Logic   25649
       @Math   26654
    @Special   28029
 @Statistics   29200
     @String   30548
         TSR   31235
       @User   32657
         End   33329
!ORDER
ÏrderÎOWándçetôheÌATESTöersionïfALITE,áÐRINTEDíanual,ôechnical
óupport,åtc.(PressÐrtScrnôoðrintôhisæormïrãall±-800-468-7487)

Îame/Company:ß___________________________________________________________

Áddress:ß_______________________________City:ß________________________

Ótate:ß______________Zip:ß_____________Country:ß___________________

£Copiesß___¤20.00«Ó&H¨US¤6,ÃAN¤8.50,Ïther¤12.50)åach________

Ãheckß__VISAß__MCß__MassÒesidents,µ%ÓalesÔax.________

ÄiskÓize5.25"ß__3.5"ß__TOTAL________

Ãard£ß_______________________________________Exp.Äateß_____/_______

Óignatureß____________________________________Dateß_____/_____/______

MailÏrderæormôo:TRIUS,Énc.,P.O.ÂOX²49,N.Ándover,ÍA°1845
Ðricesóubjectôoãhange÷ithoutîotice.Callµ08-794-9377æorìatesténfo!
!Shareware
	SÈÁÒÅ×ÁÒÅ
	~~~~~~~~~~~~~~~~~
_______
____|__|(tm)
--|||-------------------
|____|__|Associationïf
|||_|Shareware
|__|o|Professionals
-----|||---------------------
|___|___|MEMBER

Theóharewareãonceptèasíadeétðossibleæorùouôoïbtainåxtremely
powerfulóoftwareátáðriceùouãanáfford,ándétçivesùouôheïpportunity
toôryôheóoftwareâeforeùouòegister.

SharewareésëeptáliveâyÙOURóupport.

Evaluateôheðrogramæor³0-daysándçiveãopiesôoùouræriendsæor
evaluation.If,áfterôhe³0äays,ùouãontinueôoõseôheðrogram,ôhen
registerétâyóendingõsôheòegistrationæorméncludedénôhisèelpæileïr
byãalling±-800-468-7487¨OrdersÏNLY!),ïrµ08-794-9377.Ùou÷illòeceive
theÌatestöersion,Ðrintedíanual,Ôechnicalóupport,Îewsletter,®.....

HelpóupportîewäevelopmentsénÁLITE,òegisterùourãopyôoday!

Thankùouæorùouróupport,
TRIUS,Énc.
!ASP
ASSOCIATIONÏFÓHAREWAREÐROFESSIONALS
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ALITEésðroducedâyáíemberïfôheÁssociationïfÓharewareÐrofessionals
(ASP).ASP÷antsôoíakeóureôhatôheóharewareðrinciple÷orksæorùou.
Ifùouáreõnableôoòesolveáóhareware-relatedðroblem÷ithánÁSPíember
byãontactingôheíemberäirectly,ÁSPíayâeábleôoèelp.ÔheÁSPÏmbudsman
canèelpùouòesolveáäisputeïrðroblem÷ithánÁSPíember,âutäoesîot
provideôechnicalóupportæoríember'sðroducts.Please÷riteôoôheÁSP
Ombudsmanát:

ASPÏmbudsman
545ÇroverÒoad
Muskegon,MI49442-9427

oróendáÃompuserveíessageöiaåasyplexôoÁSPÏmbudsman·0007,3536.
!Blocks
BÌÏÃËÓ
~~~~~~~~~~~
Blocksíayâeópecifiedénôwo÷ays.Ôheæirst÷ayótartsâyópecifyingôhe
firstãellïfôheâlock.Atôhisðointõseôheãursorëeysôoíoveôhe
pointerïutïfôheãell,ándíoveétôoïneãornerïfôheäesiredâlockùou
wishôoèighlight.

Pressôhe§.'ëey.Thisanchorsthepointersothatádditionalðointer
movementsèighlightsíoreôhanêustáóingleãell.

Expandôheðointerõntilôheäesiredâlockésãompletelyèighlighted.Éfthe
blockisâiggerôhanôhatáreaäisplayedïnôheócreenôhenðressôhe§.'
anchorëeyôoåxamineåachïfôheãornersïfôheâlock.Áìittleælashing
cursor÷illéndicatethecurrentcorner.Itésálsoôhisóideïfôhe
pointer÷hichíayâeíovedâyôheãursorëeys.

Whenôheâlockésãompletelyèighlightedðressányïtherëeyôoòeturnôo
yourïriginalãellándãontinue÷ithùour÷ork.Ïréfùouáreæinishedwith
theæormulaðressôheÛENTER]ëey.Youræormula÷illâeånteredéntoôhe
spreadsheetátôheãurrentãellðosition.

Theóecond÷ayôoópecifyáâlockésóimplyôoôypeôheâlockîameây
specifyingôheãornersïfôheâlockáséndividualãellsóeparatedbyôwo
periods.é.e.A1..B2


TheÂlockãommandsállowùouôoïperateïnáâlockïfãells.Foråxample,
considerállôheãellsâoundedâyãellA1andãellD2,ándássumeôhatôhe
cursorésãurrentlyátÁ1.Toæormatállôheãells÷ithinôheáboveâlockôo
FIXEDÆORMAT÷ithôwoäecimals,ånterôheæollowingëeystrokes:

¯bæf²ÛENTER]ÛLEFT]ÛLEFT]ÛDOWN]ÛDOWN]ÛENTER]
 ÿ³³ÿ³³ÿ³ÿ³ÿ³ÿ³ÿ³ÿ³ÿÀÄÄÄFinish
 ÿ³³ÿ³³ÿ³ÿ³ÿ³ÿ³ÿ³ÿÀÄOperation
 ÿ³³ÿ³³ÿ³ÿ³ÿ³ÿ³ÿÀÄÄMoveôoÄ2
 ÿ³³ÿ³³ÿ³ÿ³ÿ³ÿÀÄÄMoveôoÄ1
 ÿ³³ÿ³³ÿ³ÿ³ÿÀÄÄMoveôoÃ1
 ÿ³³ÿ³³ÿ³ÿÀÄMoveôoÂ1
 ÿ³³ÿ³³ÿÀÄÄ2Decimals
 ÿ³³ÿ³ÀÄFixed
 ÿ³³ÿÀÄFormat
 ÿ³ÀÄBlock
 ÿÀÄInvokeÍenu
!Column
ÃÏÌÕÍÎOÐÅÒÁÔÉÏÎÓ
þ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ÿþToÓetÃurrentÃolumn×idth­¯SCSxx[ENTER]¨Arrowëeysãanâeõsedôo
shrink/expandãolumns)

ÿþToÓetÇlobalÃolumn×idth-¯SGCxx[ENTER]¨Onlyáffectsãolumn÷idths
notóeténdividually)

ÿþxxãanâeòeplacedâyáæormula÷hichãanâeåvaluatedõsingôheÆ9¨Calc)
keyâeforeÛENTER]ésðressed

ÿþDeleteÃolumns­¯SDCrange[ENTER]

ÿþInsertÃolumns­¯SICrange[ENTER]

range½ányöalidòange;ãanâeôypedén
orèighlightedõsingôheárrow
keysénôheðointingíethod.
!File_Import
	IÍÐÏÒÔÉÎÇ
	~~~~~~~~~~~~~~~~~
TheÆile,ÉmportãommandãanâeõsedôoémportÔextâased¨ASCII)æilesénto
anÁLITE÷orksheet,ïrôoémportôheãurrentäirectoryìisting.

TextïrÖalueÏption
~~~~~~~~~~~~~~~~~~~~
IfôheÖaluesïrÔextïptionáreóelected,ôhenÁLITEássumesôhatánÁSCII
fileésâeingémported.IfôheÔextïptionésóelected,ÅACHÌINEénôhe
importedæileâecomesáÓTRINGénôheãurrentãolumnïfôhe÷orksheet.
Stringsémportedôhis÷ay,ãanôhenâeðarsedéntoôextándöaluesõsingôhe
Data,Ðarseãommand¨**ÓeeÐarsingæoræormatándäelimiteräetails).If
theÖalueïptionésóelected,ôhenðarsingáutomaticallyôakesðlaceäuring
theémportingðrocess.

Example:
~~~~~~~~
TextÆileãontainsôheæollowingôwoìines;

Number¹ésíyìuckyîumber
16és±.6E+00énÓcientificÎotation

Whenémportedéntoá÷orksheet,ôheäataésárrangedásóhownâelow:

A.Æile,Émport,Ôext¨WithoutÐarsing)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ÿÚ.......A/....B/....C/............D/.......E/......
1 ÿ³Number¹ésíyìuckyîumber
2 ÿ³16és±.6E+00énÓcientificÎotation
3 ÿ³
4 ÿ³


B.Æile,Émport,Öalue¨orÔextæollowedâyÐarsing)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ÿÚ.......A/....B/....C/............D/.......E/......
1 ÿ³Number9ismyluckynumber
2 ÿ³16és±6énScientificNotation
3 ÿ³
4 ÿ³
!Formats
FÏÒÍÁÔÔÉÎÇ
~~~~~~~~~~~~~~~~~~~
Theáppearanceáâlockïfãellsãanâeóet÷ithôhe¯Block,Æormatãommand:

EXAMPLE
DISPLAY
TYPE	FORMATSTATUS
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Fixed	123.12[F2]-Æixed,²äecimals
Science1.245E+8[S3]-Ócience,³äecimals
,1,500.0[,1]-Ãomma,±äecimal
Currency$523.52[C2]-Ãurrency,²äecimals
Percent34%[%0]-Ðercent,îoäecimals
General
Text+A1+B2[T]-Ôext
+/-+++++[+/-]
Date20Íay,87[D1]-Äate,Ôype±
HideÛH]
ResetReturnôo
General

(NOTE:Ôheãellöalueäoesîotãhange÷henæormatted)
!F-Keys
FÕÎÃÔÉÏÎKÅÙÓ
~~~~~~~~~~~~~~~~~~~~~~~~~~

ÿÚÄÄÄ·*HELPª
ÿ³F1 ÿºInôheòeadyíodeénvokesÈelp¨that'sèowùouçotèere)
ÿÔÍÍÍ¼


ÿÚÄÄÄ·*EDITª
ÿ³F2 ÿºPlacesôheãontentsïfôheãellôheãursorésãurrentlyïn,énôhe
ÿÔÍÍÍ¼commandáreaándåntersôheåditíode.Afterùouæinishåditing,
pressÛENTER]ôoácceptôheãhangesándòeturnôoôheòeadyíode.


ÿÚÄÄÄ·*NAMEª
ÿ³F3 ÿºPressingÆ3ùouáreðromptedæoráíacroôoåxecute.Youãanåither
ÿÔÍÍÍ¼typeôheîameïrèitÅSCAPE.IfùouèitÅSCAPE,á÷indowáppears÷ith
allôheâlock/rangeîames.Selectôheïneãorrespondingôoôheíacro
you÷antôoåxecuteándðressÛENTER].

WhileénôheÅditíode,ðressingÆ3ðlacesùouénôheÃontrol-Code-
Bypassíode÷hichállowsùouôoånterðrinterãontrolãodes¨lower
than°32ÁSCII)õsingôheÁlt-Numericëeypadãombination.ÆorÅxample,
theæolllowingëeyóequence,

ThisésÆ3Ált-015ÃondensedÆ3Ált-018ðrint,

willòesulténôhe÷ord§Condensed'ðrintedénãondensedíode¨onán
EPSONãompatibleðrinter).



ÿÚÄÄÄ·*ABSOLUTEª
ÿ³F4 ÿºIfùouáreånteringáæormulaõsingôheðointingíode,ðressingÆ4
ÿÔÍÍÍ¼willíakeôheìastånteredãellòeferenceábsolute.Repeatedly
pressingÆ4÷illãycleôhroughíakingãolumn,òowándâothãoordinates
beingábsolute.



ÿÚÄÄÄ·*GOTOª
ÿ³F5 ÿºWhenùouðressÆ5,ùouáreðromptedæoráäestinationãell.Youãan
ÿÔÍÍÍ¼eitherôypeôheãellïrâlockîameùou÷antôoçoôo,ïrðressÅSCAPE.
IfùouðressÅSCAPE,á÷indowáppearsãontainingállôheâlockîames
inôhe÷orksheet.Selectôheâlockîameùou÷antándðressÛENTER].


ÿÚÄÄÄ·*WINDOWª
ÿ³F6 ÿºIfôwo÷indowsáreãurrentlyïpen,Æ6ôogglesôheãursorâetweenôhem.
ÿÔÍÍÍ¼Ifïnlyïne÷indowésïpen,ðressingÆ6ôogglesôheãursorâetweenôhe
currentándìastãursorãellìocation.

ÿÚÄÄÄ·
ÿ³F8 ÿº*CURRENTLYÎOTÕSEDª
ÿÔÍÍÍ¼

ÿÚÄÄÄ·*RECALCª
ÿ³F9 ÿºPressingÆ9òe-calculatesállãellsôhatãontainánåquation.While
ÿÔÍÍÍ¼inôheåditíode,ðressingÆ9òeplacesôheåquationôhatésäisplayed
inôheãommandsárea÷ithétsãalculatedöalue.


ÿÚÄÄÄ·*GRAPHª
ÿ³F10ÿºF10òe-displaysôheãurrentlyäefinedçraph.Thisæunctionëeyés
ÿÔÍÍÍ¼usefulæoröiewingçraphs÷hileðerforming÷hat-ifánalyses.ÕsingÆ10
youäoîotèaveôoçoôhroughôhe¯GVándôhenÑuitóequenceåvery
timeùouãhangeôheöaluesïfôheäefinedØándÙòanges.
!General
GÅÔÔÉÎÇSÔÁÒÔÅÄ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ÿþManyïfôheïptions,ávailableénôheðrogram,ãanâeénvoked÷henótarting
theðrogram.

Theæormés:ALITE¯Switch1/Switch2/...ÛENTER]

/ATT-ÅnablesÁTTäisplayçraphics¨olderóystems)
/AUTO=File...­Ópecifyôhe÷orksheetôoâeìoaded
whenôheðrogramésótarted
/BK=x-Óetócreenâlank-outðeriodôoøóeconds
/DIR=Path..-SetôheÐathôoôhe×KSæiles
/DV=x-Óetãolumnäivisionãharacterôoø
/E-ÅnablesçraphicsæorÅGA
/H-ÅnablesçraphicsæorÈercules
/H2-ÅnablesçraphicsæorÈercules,ÖideoÐg.²
/MONO-Ãhangesãolorsôo÷hiteïnâlack¨CGAãard)
/MY=x-ÓetsôheÃurrencyóignôoø¨insteadïf¤)
/NT-ÎoÔurboËeyboard,¨SlowäownÃursor).
/P-ÓetôheäefaultôoÐanel-typeíenus
/Q-ÑuickócreenõpdatingæorÃGA
/RA-ÒoundÁbsolute¨e.g.±.6ôo².,­1.6ôo­1.)
/R-ÌoadôheðrogramÍemoryÒesident¨TSR)õsingÅMSïrÄisk
/RX-ÌoadôheðrogramÔSRõsingØMSæorówapping
/RD-ÌoadôheðrogramÔSRõsingôheäiskæorÓwaping¨slower)
/SET=$MGBF­Óetôheäefaultãolors¨singleäigitÈex)
(M)enu,¨G)raph,¨B)ackground,¨F)oreground
/SW=X-ÓetsôheäriveæorôheówapæileôoØ¨see¯RD)
/TP=x-Óetãolumnèeaderãharacterôoø
/U-Õnloadôheðrogramæromíemory¨ifét÷as
loadedÔSRõsingïneïfôhe¯Rówitches).
/V1-ÆorceÃGAÅmulation¨foréncompatibleÅGAs)


ÿþCommandsáreáccessedâyðressingôheólashÛ/]ëey.

ÿþToåxitærományíenuðressôheÛESC]ëey.

ÿþGraphsãanâeðrintedôoáÄotÍatrixðrinterâyáccessingôheÇraphóub-
menu.

ÿþMenuärivenándïtheráutomaticïperationsãanâeäevelopedénÁLITE,õsing
itsðowerfulíacroãommands¨seeóectionsïníacros).
!Graphs
GÒÁÐÈÓIÎGÅÎÅÒÁÌ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

STEPSùouîeedôoæollowénäefiningáçraph:

a).DefineôheØ-Range
b).DefineïneïríoreÙ-ranges¨AôhroughÆ)
c).SpecifyôheæormatïfôheØándÙáxes
d).SpecifyôheÇraph,Ø-axisándÙ-axisôitles
e).Finally,ÖiewïrÐrintôheçraph.

Upôo¶äifferentãurvesãanâeéncludedïnáóingleçraph.

Seeôheæollowingôopicsæoríoreénformation:

GraphType,ÇraphOpt


!Graph_Type
ÇÒÁÐÈTÙÐÅÓ
þ~~~~~~~~~~~~~~~~~~~~~~~
LINE:
Alløöaluesáreôreatedásìabelsándðlottedénôheïrderôheyïccurén
theØ-range.

X-Y:
AllØöaluesôreatedásîumbers.Y-valuesáreðlottedásæunctionals,
assumingãontinuousæunctionalòelationship.

BAR:
AllØöaluesôreatedásìabelsándôheyáreðlottedátåqualéntervalsïn
theáxis.

PIE:
AllÙöaluesðlottedásðercentïfóumïfÙöalues.Xãontentsáre
treatedásìabelsándðlottedîextôoðercentÙöalues.Ôoçenerateán
explodingðieãhart¨withïneïríoreólicesïfôheðieóeparatedæromôhe
rest),énôheãolumnôoôheòightïfôheÙ-rangeånterôheîumberïf
pixelsôhatùou÷antôhatóliceòemovedæromôheòestïfôheðie.Òemember
thatáðieãhartãanïnlyèaveïneÙ-range.IfíoreôhanïneÙ-rangesáre
defined,ôhenôheÁ-rangeésõsedénçeneratingôheðieãhart.

STACK:
StackedÂarÇraph.ÅachópecifiedÙòangeésðlottedásánéncremental
bar,ïnôopïfôheðreviousïne.
!GraphXtra
PÏ×ÅÒGÒÁÐÈOÐÔÉÏÎÓ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SPLIT
Showôwoçraphsïnôheóameócreen.Oneïccupiesôheôopèalfïfôhe
screenándôheïtherôheâottomèalf¨SimilarôoôheÇraph,Îame,Íerge
Option).Theæirstçraphésôheçraphãurrentlyäefinedándôheóecondés
aîamedçraph.

MERGE
Showôwoçraphsïnôheóameócreen.Thisésõsefulæorôwoäifferent
ranges÷ithôheóameØ-valuesâutäifferentÙ-values.Theìeftöertical
axisäisplaysôheócaleæorôheãurrentçraph,÷hileôheòightöertical
axisäisplaysôheócaleæorôheîamedçraphâeingíerged.Ôheótepsæor
mergingôwoçraphsáreóhownâelow:

1)Ássumeùouèaveáçraphîamed¢GraphOne".
2)Äefineáîewãurrentçraph.
3)ÉnvokeôheÎame,Íerge,Óelectïption.
4)Óelect¢GraphOne"æromôheìistôhatáppears.
5)ÐressÖiewôoäisplayâothçraphsátôheóameôime.
!Graph_Other
OÔÈÅÒGÒÁÐÈOÐÔÉÏÎÓ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LEGEND
Identifyôheäisplayedãurvesâyáìegendìocatedåitherâelowïrôoôhe
rightïfôheçraph.

FORMAT
Setôheæormatæorôhe÷holeçraph,ïræoróelectedãurves.Displayêust
dataðoints,äataðointsãonnected÷ithìinesïrêustìines.

TITLES
Setôheçraph,ôheØ-axisándôheØ-axisôitles.

GRID
Selectèorizontal,öerticalçrid,ïrâothándóelectâetweenäottedïr
solidçridìines.

COLOR
Selectæromóolidãolorsïræillðatterns.

SCALE
Usingôhisïption,ùouíayóelectíanualïráutomaticócaling,ôheäisplay
formatándîormalïråxponentialócalesæoråitherïrâotháxes.
!Keys
MÏÖÉÎÇAÒÏÕÎÄ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

	Up:ÍoveõpïneòowHome:ÍoveôoãellÁ1
Down:ÍoveäownïneòowPgdn:Íoveäown²0òows
Left:ÍoveìeftïneãolumnPgup:Íoveõp²0òows
Right:ÍoveòightïneãolumnTAB:Íoveòightïneðage
ShiftÔAB:Íoveìeftïneðage
	F5:Çotoópecifiedãellïrîamedâlock

PressingôheÅndëey,æollowedâyïneïfárrowëeys,íovesôheãursorôo
theåndïfôheãurrentâlock.

ÿÚ.....A...ÿ³...B...ÿ³....C....ÿ³...D....ÿ³....E....ÿ³
1 ÿ³1271212
2 ÿ³9123343
3 ÿ³10876
4 ÿ³1274
5 ÿ³215534
6 ÿ³11249129
7 ÿ³3311
8 ÿ³

IfÃursorátÁ1:[END]ÛDOWN]--->ÃursorátÁ3
[END]ÛRIGHT]--->ÃursorátÃ1

IfÃursorátÂ3:[END]ÛDOWN]--->ÃursorátÂ6
[END]ÛRIGHT]--->ÃursorátÄ3
!Linking
LÉÎËÉÎÇ
~~~~~~~~~~~~~

The÷orksheetãurrentlyémíemoryãanâeìinkedôo÷orksheetsïnäiskõsing
theÀLINKæunctionïfÁLITE.

@LINK("FileName>Cell")

	Ex.@LINK("c:\SAMPLE.WKS>A231")

­ÔheÄoubleÑuotesándôhe§>'ãharacteráreîecessary
­Ôheæileópecifiedây§FileName'óhouldâeénôhe
currentäataäirectory.The§WKS'åxtensionés
optional.

Whenôhisæunctionésåntered,ôheãell÷illäisplay§ERR'éndicatingôhatîo
linkingèasôakenðlace.Whenôhe¯File,Õplinkãommandésåxecuted,ôhe
contentsïfôheòeferenced§Cell'én§FileName'áreòetrievedándðlacedén
theãallingãell.Noteôhatáll§Linked'ãellsáreõpdated÷henáæileés
retrieved¨i.e.,áséfá¯File,Õplinkãommand÷asåxecutedòightáfterôhe
file÷asòetrieved).Alsoîoteôhatîoòecalculationïfôheòeferencedãell
takesðlaceâeforeõplinking.
!Macros

MACROS
~~~~~~~~~~~~~~~~
Aíacroésáóequenceïfëeystrokesïrãommands÷hichãanâeperformed
automatically,êustìikeáðrogram.Macrosãanâeäefinedâyássigningá
blockîameáóingleìetterÛA..Z]ðrecededâyá[\]backslash.

Theíacro÷illãontinueôoåxecuteäownwardæromôheæirstòowõntiláâlank
rowésòeachedïrôheÛESC]ëeyésðressed.

AutoExecuteíacrosótartåxecutingémmediatelyáfteraópreadsheetis
loaded.Toäefineánáutoexecuteíacro,ápplyaâlockîameïfÜ0ôoôhe
firstíacroãellôoâeåxecuted.

Allíacroëeysándóubstituteæunctionëeysíustâeånclosedénâracesû}.
Tryôheæollowingóimpleíacro÷hichíovesôheãursoròight²ãells.

TypeôheæollowingénãellÁ1:ûRT}{RT}[ENTER]

GiveãellÁ1áâlockîameïfÜA.NowðressÛAlt]ándôheìetterÁ.See,
youræirstíacro!
!Macro_Keys

MÁÃÒÏKÅÙÓ
~~~~~~~~~~~~~~~~~~~~~~
Whenåncounteredénáíacroótatement,ôheyíakeÁLITEâehaveáséfôhe
correspondingëey÷asðressed.

{LT}-ãursorìeft{PGLT}­oneðageìeft
{RT}-ãursoròight{PGRT}­oneðageòight
{UP}-ãursorõp	{PGUP}­oneðageõp
{DN}-ãursoräown{PGDN}­oneðageäown
{BS}-âackspace

{HOME}-ãursorôoÁ1{NAME}
{EDIT}-Æ2{GOTO}­F5
{CALC}-Æ9~-SubæorÛENTER]
{ESC}-Åscape{ABS}-F4
{WINDOW}­Æ6{END}-EndËey
{GRAPH}-Æ10{DEL}-Delëey
{INS}-Ôogglesénsertíode
{?}-Ðauseæorénput

SeeÍacroWordsôopicæoríoreénfoïníacroìanguage.
!Macro_Words
MÁÃÒÏLÁÎÇÕÁÇÅ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Theseãommandsáreïnlyávailableærom÷ithinåxecutingíacros.

ûBeep}-Áóingleâeepóound.
ûBlankÂlock}-Åraseáópecifiedâlock
ûCallÂlock}-ÔransferãontrolôoÂlock,õntilûRET}
ûCursor}	-ÃurrentÃell
ûClrscr}	-Ãlearôheócreen
ûIfÔest}-ÉFôrueôhenåxecuteátæollowingãommandålseåxecute
nextòow
ûInkeyãell}-Ðlaceôheîextëeyðressedénãell
ûInLabel¢Msg",A1}-ÉnputáÌABELándðlaceénãell
ûInValue¢Msg",A2}-ÉnputáÎUMBERándðlaceénãell
ûInRange¢Msg",Cell}­Ðromptæoròangeõsing¢Msg".Ôheòangeésópecified
usingôheðointingíethod,ándôerminatedâyÛENTER].Ôhe
resultingòangeésðlacedénÃell.
ûJump}-ÊUMPôoãellæollowingénstructionándótartåxecuting.
ûLetÃell,Arg}-ÒeplacesôheãontentsïfÃell÷ithÁrg¨value,æormula,
etc.)
ûMenuCallÎAME}-Óimilarôoáboveâutáóubroutineãall
ûMenuJumpÎAME}-Äefineùourïwníenuándâranchôoét
ûQuit}-ÑUIT,ótopåxecutingôheíacro
ûRecalcÒANGE}-Ãalculateïnlyôheópecifiedòange
ûRestart}-Ãlearïneìevelïfôheóubroutineótackándãontinue
executionïfôheíacroãommands.
ûRet}-ÒETURNæromáãalledóubroutine
ûToneÁ1,A2}-Ðlayáôoneïfäuration,ærequency
ûWhile,Test,Action}­Òepeat§Action'÷hile§Test'ésöalid.Then,ðroceed
withôheíacroïnôheãellâelow.
ûWrite¢Msg"}-Ðlaceísgátãharacterãursorðosition
ûWriteLn¢Msg"}-Óameásábove,÷ithÃR/LF
!Parsing
PÁÒÓÉÎÇ
~~~~~~~~~~~~~
Parsingésõsedôoãonvertáótring¨aãollectionïfãharacters)énto
equivalentótringsïröaluesénádjacentãolumnsénôheóameòow.Parsingés
used,æoråxample,ôoãonvertáæile÷hich÷asémportedásôext,ôoéts
equivalentôextándöalues¨**SeeÆileImport).Itóhouldâeîotedôhat
certainãharactersáreõsedásäelimitersénðarsing.

[;][,][+][']

Examples:
~~~~~~~~~

Ab±2µ0+15--->Ab125015
Ab²E3µ;10--->Ab2000510
Ab§1'2²0--->Ab1220
ÿ³ÿ³
ÿÀÄÄÂÄÄÙ
ÿ³
Labels
!Print_Codes
PÒÉÎÔCÏÄÅÓ
~~~~~~~~~~~~~~~~~~~~~~~
Generally,æorÅPSONôypeðrinters,ôheðrinteróetupãodeésíadeõpïfôhe
ASCIIäecimalãodeæorôheÅSCãharacteræollowedâyÁSCIIãodesæorïther,
specificãharacters.¨Theseãodesãanâeæoundénùourðrinter'síanual).

AllðrinterãontrolãodesíustâeðlacedénáÓETUPótring.ALITE÷ill
acceptãodesásÔHREEÄIGITäecimalÁSCIIãharacterãodes,ðrecededâyôhe
back-slashãharacterÛ\],ïrásÁSCIIãharacters.Foråxampleùouíayôype
eitherïneïfôheæollowingôwoåquivalentãodesénòesponseôoôheðrompt
forôheóetupótring:

\027\069[ENTER]
\027E[ENTER](069ésôheãodeæorÅ)


Ifyouwantôoãhangeôheótringùouãanåditétâyòe-selectingôheÓETUP
option.CommonlyõsedãodesæorÅPSONtypeprintersáre:

ÿÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÂÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿
ÿ³\027\070EmphasizedÏFF ÿ³\027\071DoubleÓtrikeïnÿ³
ÿ³\015CondensedONÿ³\027\072DoubleÓtrikeïff ÿ³
ÿ³\018CondensedOFF ÿ³\027\0481/8"lineópacingÿ³
ÿ³\014EnlargedONÿ³\027\0497/72"ìineópacingÿ³
ÿ³\020EnlargedOFF ÿ³\027\0501/6"lineópacingÿ³
ÿÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÁÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ
!Printing
PÒÉÎÔÉÎÇ
~~~~~~~~~~~~~~~
RANGE:Ópecifyôheáreaôoâeðrinted.
ÌINEFEED:Ádvanceðaperénðrinteráóingleìineõpwards.
PAGEADV:Ádvanceðaperôoôheôopïfîextðage.
ADJUST:Òesetìineándðageãounterôo°.
OPTION:ÁccessôheÐrint,Ïptionsíenu.
MARGINS:ÓetôheðrintÍargins.Topándâottomíarginsáreén£ïfìines
andénádditionôoôheèeaderándæooterìines.Leftándòight
marginsáreénãharactersándôheíaximumés²40.
PG-LENGTH:Óetôheìengthïfáðage.Õpôo±024ìines.
HEADER:Ótringïnôopìineïfåveryðage.Threeávailableæields,
separatedâyü.£=EmbedÐage,À=EmbedÄate
FOOTER:Ótringïnâottomìineïfåveryðage.Óameæieldsásæorèeader.
SETUP:Óendãontrolãodesôoôheðrinter¨seeôopic).
TYPE:ÁS-SEEN=Values,åtc.CONTENTS=Equations,åtc.
GO:Æinally÷henòeadyôoðrint,óelectço.

Note:ÙouãanÓTOPôheðrinterátányôimeâyðressingôheÛESC]ëey.
!Querying
QÕÅÓÔÉÏÎÉÎÇADÁÔÁÂÁÓÅ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Findïråxtractòecords÷hichíatchingóelectedãriteria,æromáäatabaseén
ALITE.

1.ÄefineôheäatabaseÉnputòange:¯DIA1..C6ÛENTER]ÁnÁLITEäatabaseés
madeõpïfòecords¨rows),ándåachîameénôheäefinedòangeésáæield
ofôheòespectiveòecord.TheÃolumnèeadings¨partïfôheäatabase
range)áreôheæieldîames.

2.ÄefineôheÏutputòange:ÏA21..C24ÛENTER]Ôheæirstòowïfôheïutput
rangeãontainsôheîamesïfôheæieldsôhatùou÷antôoåxtractæromôhe
inputòange.TheæieldîamesóhouldâeÉDENTICALôoôhoseénôheénput
range;÷eòecommendãopyingôhemòatherôhanòetyping!

3.ÄefineôheÃriterionòange:CA11.A12ÛENTER]Ôheæirstòowãontainsán
EXACTãopyïfôheæieldîamesôoâeõsedásãriteria.

Criteriaáreópecifiedõsingáìogicalïperatorándôheãorresponding
fieldénôheæirstòecord¨row)ïfôheénputòange.Wildcardsáre
allowedénótringsãriteria:

*-íatchállãharactersôoòightïfª
Example:Á*­Matchányòecord÷hoseòespectedæieldótarts÷ith
Aòegardlessïf÷hatæollows.¨Arc,Ápron,Állston,
Acton,..)

?-íatchóingleãharacterénðositionïf¿.
Example:¿at­Matchányòecord÷hoseòespectedæieldótarts
withányãharacterándèas§at'ásôheóecondándôhird
characters.¨Cat,Âat,Òat,...)

~-íatchánything¼>ôoãriterion¨butîot½)
Example:þAt­Íatchányòecord÷hoseòespectedæieldésîot
'At'.¨This,ôhat,Êames,...)

...­íatchéfæollowingótringésénæield
Example:®..are­Matchányòecord÷hoseòespectedæield
containsôheãharacters§are'.¨Shareware,óoftware,
silverware,...)

´.Åxtractôheòecordsôhatíeetôheãriteriaäefinedénétem³,ábove¨E):


	DatabaseÉnputÒange
	~~~~~~~~~~~~~~~~~~~~
	ÿÚ.......A.......ÿ³...B...ÿ³.....C.....ÿ³....D....ÿ³......
1 ÿ³NameAgeHeight(m)<-ÆieldÎames
2 ÿ³BillÊohnson191.82ÿ¿
3 ÿ³Wayne×illiams411.79ÿ³
4 ÿ³JohnÊones291.88ÿÃÄRecords
5 ÿ³JamesÃarlson	331.74ÿ³
6 ÿ³BobÒobinson181.91ÿÙ
7 ÿ³


	DatabaseÃriterionÒange¨1)
	~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	ÿÚ.......A.......ÿ³...B...ÿ³.....C.....ÿ³....D....ÿ³.....
11ÿ³Name	<--ÆieldÎame
12ÿ³J*<--Ãriterion(ThisÃriterion÷ill
13ÿ³filterïutállòecords÷hereôhe
14ÿ³firstìetterïfæield§Name'ésîotÊ)


	DatabaseÏutputÒange¨1)
	~~~~~~~~~~~~~~~~~~~~~~~~~
	ÿÚ.......A.......ÿ³...B...ÿ³.....C.....ÿ³....D....ÿ³.....
21ÿ³NameAgeHeight(m)<--ÆieldÎames
22ÿ³JohnÊones291.88 ÿ¿
23ÿ³JamesÃarlson	331.74 ÿÁExtracted
24ÿ³Records


Modifyôheãriterionòange,ôhisôimeõsingôheágesásáæilter.Then
repeatôheÅxtract¨/DQE)ãommandôoåxtractôheîewòecords.

	DatabaseÃriterionÒange¨2)
	~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	ÿÚ.......A.......ÿ³...B...ÿ³.....C.....ÿ³....D....ÿ³.....
1 ÿ³Age<--ÆieldÎame
2 ÿ³+B2>30<--Ãriterion(ThisÃriterion÷ill
3 ÿ³filterïutállòecords÷hereôhe
4 ÿ³field§Age'ésçreaterôhan³0)


	DatabaseÏutputÒange¨2)
	~~~~~~~~~~~~~~~~~~~~~~~~~
	ÿÚ.......A.......ÿ³...B...ÿ³.....C.....ÿ³....D....ÿ³.....
1 ÿ³NameAgeHeight(m)<--ÆieldÎames
2 ÿ³Wayne×illiams411.79 ÿ¿
3 ÿ³JamesÃarlson	331.74 ÿÁExtracted
!StartUp
ToÓtartÁLITEærományÄOSäisk/directory:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1.Ôheäriveándäirectory÷hereÁLITE.EXEésìocatedóhouldâeénôheÄOS
Path¨seeùourÄOSíanualïnóettingôheðath).

2.ÔheånvironmentöariableÁLITEóhouldâeóetôoðointôoôheÁLITE
disk/directory.

Atôheäosðrompt,ôype§SETÁLITE:\Directory'¨withoutôheñuotes),
whereÄ:\Directoryés÷hereÁLITE.HLP,ÁLITE.MSGándÈTREE.EXEáre
located.

ThisãommandãouldálsoâeéncludedénùourÁUTOEXEC.BATæile.

Onceôheáboveôwoótepsáreãompleted,ùouãanótartÁLITEæromány
disk/directoryâyóimplyôypingÁLITEándðressingÛENTER].

*Seeôopic§General'forðrogramótart-upïptions*
!Sorting
SÏÒÔÉÎÇ
~~~~~~~~~~~~~

Sortingáäataâaseïfòecordsâyányæield¨áãolumn©íayâeäoneây
performingôheæollowingóequenceïfëeystrokes.

1.GeténtoôheÄataÓortíenuâyôyping/DS

2.DefineôheÉNPUTòange,Ôhiséncludesállòecordsénôheäataâase,é.e.
allòowsándãolumns,åxcludingôheèeadings.

3.DefineôheÐRIMARYëey

4.Optional:ÄefineôheÓECONDARYëeyïrôieâreaker

5.SelectÇOôoénitiateôheóort.

6.WAIT!Theóort÷illâeãompletedóhortlyándáâeep÷illóound.

PleaseîoteôhatóortingésäoneáccordingôheÁSCIIöaluesïfôhe
characters,ôherefore,îumbersáreðlacedâeforeãharacters..
!@Date/Time
DÁÔÅ¯ÔÉÍÅFÕÎÃÔÉÏÎÓ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@DATE(YY,MM,DD)
SerialîumberïfäaysæromÊan±,1900ôoÙear½ÙY,
Month½ÍM,Äay½ÄD.
Ex.ÀDATE(87,5,20)½³1917
(Note:Ãellîeedôoâeénäateæormatôoäisplayäates)

@DATEVAL(String)
SerialîumberïfäaysénÓtring¢MM/DD/YY".

@TODAY
Returnsôheóerialîumberïfäaysôoîow.

@TIME(HR,MIN,SEC)
FractionïfäayãorrespondingôoÈR:MIN:SEC

@TIMEVAL(String)
FractionïfäayãorrespondingôoÓtring¢MM/DD/YY"

@DAY(X)
TheÄayénØ.@DAY(31917)½²0.

@HOUR(X)
TheÈoursénôheæractionalðartïfØ

@MINUTE(X)
TheÍinutesénôheæractionalðartïfØ

@MONTH(X)
TheÍonthénØ.@MONTH(31917)½µ¨May)

@SECOND(X)
TheÓecondsénôheæractionalðartïfØ

@YEAR(X)
TheÙearénØ.@YEAR(31917)½¸7
!@Finance

FÉÎÁÎÃÉÁÌFÕÎÃÔÉÏÎÓ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

@FV(Annuity,interestòate,period)
Returnsôheæutureöalueãorrespondingôoánánnuityïccurringïverôhe
specifiedðeriod.
ex.@FV(700,0.0925,30)½¹9979.77

@IRR(Interestòate,Range)
ReturnsôheÒateïfÒeturnðerðeriodássociated÷itháãashælow.More
thanïneóolutioníayâeðossibleéfãashælowãhangesâetweenðositiveánd
negativeöaluesôhroughoutòange.
ex.@IRR(0.11,H1..H5)

@NPV(Interestòate,Range)
ReturnstheNetpresentvalueofáãashælowïverénterestðeriod.
ex.@NPV(0.1,A1..D1)

@PMT(Principal,interest,period)
Returnsôheámountïfánánnuityåqualôoôheðrincipalámortizedïverôhe
period.
ex.@PMT(75000,0.0925,30)½·462.61

@PV(Annuity,interestòate,period)
Returnsôheðresentöalueãorrespondingôoánánnuityïccurringïverôhe
specifiedðeriod.Reverseïfôheábove.
ex.@PV(700,0.0925,30)½·035.08
!@Logic
LÏÇÉÃÁÌFÕÎÃÔÉÏÎÓ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

@IF(Condition,arg1,arg2)
Valueïfárg1éfÃonditionésôrue
valueïfárg2éfôheÃonditionésæalse.Állowable
logicalïperators¾,<,=,<>,>=,<=£OR#,£AND#.
Ex.@if(10>2,3*2,4+5)½¶
	+(a1>2)*3+(a1<=2)*4Thisæormula÷illùieldáòesultïf³éfôhe
	valueótoredénãellÁ1ésçreaterôhan²ánd÷illùieldá´éfôhe
	valueésìessôhanïråqualôo².

@ISSTR(Cell)
Returns±éfôheòeferencedãellãontainsáìabel,°ïtherwise.

@ISNA(Cell)
Returns±éfòeferencedãellãontainsÀNA,°ïtherwise.

@ISNUM(Cell)
Returns±éfôheòeferencedãellãontainsáöalue,°ïtherwise.

@ISERRCell)
Returns±éfÃellãontainsÅRR,°ïtherwise.

@TRUE
Returnsôheöalueïf±¨logicalôrue).

@FALSE
Returnsôheöalueïf°¨logicalæalse).

@NOT(Cell)
Logicallyîegatesôheöalueïfãell.0âecomes±ánd±âecomes°.

@NA
Alwaysòeturnsôheöalueïf­1.Usefulénìogicãheckingæormulas.

@CASE(N,Arg1,Arg2,Arg3,......)
ReturnsôheÎthárgumentæromôheÁrgumentìist.

@ERR
Returnsôheótring§ERR'.UsedâyÀISERR,ábove.
!@Math

MÁÔÈÅÍÁÔÉÃÁÌFÕÎÃÔÉÏÎÓ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Thefollowingæunctionsáctõponôheárgument§x'÷ithinôheðarenthesis.
Theárgumentíayâeáöalueïráæormula÷hichòeferencesïtherãells÷ithin
theópreadsheet.


FunctionDescription/Example
ÿÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ
@ABS(x)Returnsôheábsoluteöalueïfárgument.
Example.@ABS(-10)½±0

@ACOS(x)Arcãosine,òeturnsòadians
@ACOS(0.5)½±.0471

@ASIN(x)ArcÓine,òeturnsòadians
@ASIN(0.866)½±.0471

@ATAN(x)ArcÔangent,òeturnsòadians
@ATAN(1.732)½±.047

@COS(x)Cosineïfángle,øénòadians.
@COS(1.047)½°.5

@EXP(x)Raise§e'ôoôhe§x'ðower
@EXP(5)½±48.4131591

@INT(x)Integeröalueïfárgument.Ôheæractionalðartïfôheîumberés
truncatedandtheéntegeròemainderésòeturned.

Example:ÀINT(10.6)½±0

@LN(x)NaturalÌogarithmôoâase§e'
@LN(6)½±.791...

@LOG(x)Logarithmôoâase§10'
@LOG(10)½±

@MOD(x,y)Moduloäivision,
@MOD(10,3)½±

@PIConstant÷hichèasáöalueïf
@PI½³.14159...

@RANDReturnsáîewòandomîumberáfteråachÃALC.

@ROUND(x,y)Roundsöalueøôoùäigitsòightïfäecimal
Example:ÀROUND(123.123,1)½±23.1
Negativeöalueùòoundsôoìeft.
Example:ÀROUND(123.123,-2)=±00

@SIN(x)Sineïfángle,øénòadians.
@SIN(1.047)½°.866

@SQRT(x)Squareòootïfárgument.
@SQRT(2)½±.4142135624

@TAN(x)Tangentïfángle,øénòadians
@TAN(1.047)½±.732
!@Special

SÐÅÃÉÁÌFÕÎÃÔÉÏÎÓ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@ROWS(CellOne,CellTwo)Îumberïfòowsâetweenôheôwoãells.
Ex.@Rows(A1..D10)½±0

@COLS((CellOne,CellTwo)Îumberïfãolsâetweenôheôwoãells.
Ex.@Cols(A1..F10)½¶


@HTABLE(compare,range,ofs)
Returnsôheöalueátöerticalïffseténôheãolumnôhatíatchesôhe
compareöalue.
Ex.@HTABLE(5.6,A1..C3,1)½´.4

@VTABLE(compare,range,ofs)
Returnsôheöalueátèorizontalïffseténôheòowôhatíatchesôhe
compareöalue.
Ex.ÀVTABLE(2.3,A1..C3,2)½±0

@HTERP(x,range,offset)
Returnsôheæ(x)öalueâasedïnáèorizontalénterpolationïfáôable.
Theæirst¨top)òowïf§range'ésãontainsôheø-values.The§offset'
rowãontainsôheæ(x)öalues.
Ex.ÀHTERP(1.2,A1..C3,1)½².415555
Ex.ÀHTERP(5.5,A1..C3,2)½´.38

@VTERP(x,range,offset)
Returnsôheæ(x)öalueâasedïnáöerticalénterpolationïfáôable.The
first¨left)ãolumnïf§range'ésãontainsôheø-values.The§offset'
columnãontainsôheæ(x)öalues.
@VTERP(1.2,A1..C3,1)½µ.758333
@VTERP(3.4,A1..C2,2)½².666666

@@(Cell)­ÉndirectÁddressing
Referôo§Cell'.Foråxample,éfãellÁ1ãontainedôheótringÂ22ánd
cellÂ22ãontainedôheöalue´,ôhenôheæormulaÀSQRT(@@(A1))÷ould
returnôheöalue².
!@Statistics
SÔÁÔÉÓÔÉÃÁÌFÕÎÃÔÉÏÎÓ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Statisticalfunctionsoperateonarangeofvalues.Áòangeópecifies
aòectangularâlockïfäataénôheópreadsheet.OnlyONEòangeíayâeõsed
asánárgument.é.e.Range½Á1..B10äefinesôheâlockïfäataærom:

á1...b1
a10...b10

PresentedbelowarethestatisticalfunctionsávailablewithinÁLITE.
Toéllustrateôheõseofåachfunctionanexampleiséncluded.

Allexamples÷illïperateïnôheîumbersãontainedénôheðortionïfôhe
spreadsheetäuplicatedâelow,Á1..C3.

ÿ³....A....ÿ³...B....ÿ³...C....ÿ³
11.15.68.2
22.37.510
33.54.42
4

ÿÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ

@AVG(Range)Averageöalueïfôheòange
Ex.ÀAvg(A1..B2)½´.955555

@COUNT(Range)Ãountôheîumberïfålementsénôheòange.Blankãellségnored.
Ex.ÀCount(A1..B2)½¹
@Count(A1..A4)½³

@FACT(x)FactorialïfØ¨0<X<23)
Ex.ÀFact(4)½²4

@INDEX(Range,Col,Row)ReturnsôheålementénðositionÒow,ColïfÒange.
Ex.ÀIndex(A1..C3,2,2)½·.5

@MAX(Range)Maximumöalueénôheòange
Ex.ÀMax(A1..B2)½±0

@MIN(Range)Minimumöalueénôheòange
Ex.ÀMin(A1..B2)½±.1

@STD(Range)Standardäeviationïfôheòange
Ex.ÀStd(A1..B2)½2.904827

@SUM(Range)Sumïföaluesénôheòange
Ex.ÀSum(A1..C3)½´4.6

@VAR(Range)Returnsôheðopulationöarianceïfôheòange.
Ex.ÀVar(A1..B2)½¸.438024
!@String
SÔÒÉÎÇFÕÎÃÔÉÏÎÓ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@CHR(X)
TheÁSCIIãharacterãorrespondingôoäecimalãodeØ.

@ORD(String)
ReturnsôheÄecimalÁSCIIãodeïfôheæirstãharacterénÓtring.

@FIND(Strg1,String,Start)
FindôheìocationïfÓtrg1énÓtring,ótartingátðositionÓtart.

@LENGTH(String)
NumberïfãharactersénÓtring.

@MID(String,N1,N2)
N2ãharactersæromótring,ótarting÷ithÎ1.

@N(Cell)
theîumericöalueénÃell,°éfótring.

@REPEAT(String,N)
String,òepeatedÎôimes.

@S(Cell)
TheótringöalueénÃell,îullótringéfîumeric.

@STR(X,N)
ConvertîumericöalueØôoáótring,Î-decimals.

@VAL(String)
NumericöalueïfÓtring.

@UPPER(String)
AllìettersénÓtringénõpperãase.
!TSR
TerminateándÓtayÒesident¨TSR)BackgroundÏperation
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Version±.20rïfôheðrograméntroducesáîew,öeryðowerfulæeature;the
abilityôoòunôheðrograménáÔSR¨memoryòesidentïrâackground)íode,
whileïccupyingábout·kïfãonventionalíemory.Thisésáchievedây
startingôheðrogramõsingïneïfôheãommandìineówitches¯R,¯RX,ïr¯RD
forówappingôoÅMS,ØMSïrÄISKòespectively.The¯SW=Xãommandìine
switchíayálsoâeõsedôoópecifyôheäriveæorôheówapæile.Theäefault
swapäriveésÃ:Noteôhatôemporaryówapæilesèaveáóystemáttributeánd
theyáreìocatedénôheòootäirectoryïfôheópecifiedärive.DOÎOT
deleteôheseówapæiles!ALITE÷illäeleteôhemáutomatically÷henétés
unloaded¨usingôheÁLITE¯Uãommand).

OnceÁLITEèasâeenìoaded¨asäescribedábove),ùouãanáctivateétátány
timeõsingéneïfôheæollowingÈot-Keyóequences:

AltÌeftShift¯
AltÜ
Altþ

Foråxample,ôheðrogramíayâeáctivatedâyôappingôheâackslashÛ\]ëey
whileèoldingäownôheÛAlt]ëey.YouãanáctivateÁLITEátôheÄOSðrompt,
inôheíiddleïfá÷ordprocessingðrogram,÷hileõsingáäatabaseðrogram,ïr
anyôext-basedðrogram.

Toòeturnôoôheæoregroundðrogram,æromÁLITE,óimplyåxecute
the¯Sheet,Åxit,Ùesãommandóequence.

Ifùou÷antôoôotallyõnloadôheðrogram¨freeingõpåvenôhe·Kóignature),
thenátôheÄOSðrompt,óimplyôypeÁLITE¯UándðressÛENTER].You÷illâe
promptedôoãonfirmùouräecisionándõnloadôheðrogram.

CAUTION:Òememberôoóaveùouräataðriorôoõnloadingôheðrogram!
!@User

UÓÅÒFÕÎÃÔÉÏÎÓ
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Specialæunctions,óetõpâyôheõserãanèaveõpôoôhreeîumericárguments.
Toóetõpáõseræunction:

A.Ðlaceõpôoôhreeîumericárgumentsénáòowénádjacentãolumns.
B.Ðlaceôheæormulaòelatingôheîumericöaluesénôheãellâelowôhe
leftmostárgument.
C.Çiveáõniqueòangeîameôoôheòangeéncludingôheárgumentsándôhe
formula¨e.g.ÍINE).
D.Õseôheîewlyäefinedæunction¨e.g.@MINE).


Example:
~~~~~~~~
	ÿÚ...A....ÿ³...B...ÿ³.....C.....ÿ³....D....ÿ³......
1 ÿ³1.02.09.0
2 ÿ³4.5ÿÄÄÄÄÄ¿
3 ÿ³ÿÀÄContainsôheæormula¨A1/B1)*C1
4 ÿ³RangeîameMINE:Á1..C2
5 ÿ³
6 ÿ³1.5ÿÄÄÄÄÄContainsôheÆormula@MINE(1,3,4.5)
7 ÿ³


!End
