51 ORDER 1140 Shareware 1867 ASP 2747 ADD-INs 3385 Arrays 4429 Column 5051 ComData 5581 ComFile 6269 ComGraph 6961 ComPrint 9981 ComRange 10501 ComWSheet 11140 Distributors 12710 FileImport 13476 Formats 15077 F-Keys 15664 General 18769 Goalseeking 20133 Graphs 20881 GraphType 21316 GraphXtra 22787 GraphOther 23593 GraphPlot 24234 Install 25008 Keys 26043 Linking 26771 Macros 27586 MacroRec 28372 MacroPlay 29249 MacroKeys 30023 MacroWords 30644 MacroExample 33619 Parsing 35238 PrintCodes 35781 Printing 37036 Q&A 37892 Querying 39894 Range 42824 StartUp 44504 Sorting 45203 WordProcess 45837 @Date/Time 46718 @Finance 47477 @LogicFunc 49305 @Math 50351 @SpecialFunc 51725 @Statistics 53916 @String 55279 @UserFunc 56411 3D-Panels 57110 End 58346 !ORDER <<<<<<<OF>>>>>>> egisterndetheATESTersionfAS-EASY-AS, RINTEDanual,echnicalupport,tc. iskizeName:_________________________ .25"____3.5"____ ĿAddress:______________________ TRIUS,nc. 231uttontreet,City:___________________________ SuiteD-3 N.ndover,A1845State:_____Zip:_______________ opies___@50.005.00&HachTotal_______ heck___VISA___MC____Other______ _______________________________Exp.Date___/_______ ignature_______________________Date___/____/______ ALL08-794-9377oratestersion/Pricendrders Callsororeignistributornourountry* !Shareware S _______ ____|__|(tm) --|||------------------- |____|__|Associationf |||_|Shareware |__|o|Professionals -----|||--------------------- |___|___|MEMBER Theharewareonceptasadetossibleorouo obtainxtremelyowerfuloftwaretriceouan afford,ndtivesouhepportunityoryhe softwareeforeouegister. SharewareseptliveyOURupport. Evaluateherogramor0-daysndiveopiesoour friendsorvaluation.If,fterhe0ays,ou continueoseherogram,henegistertyendings theegistrationormncludednhiselpilery calling08-794-9377.ouilleceiveheatestersion, Printedanual,echnicalupport,ewsletter,..... HelpupportewevelopmentsnS-EASY-AS,egister youropyoday! Thankouorourupport, TheeopletRIUS,nc. !ASP ASSOCIATIONFHAREWAREROFESSIONALS AS-EASY-ASsroducedyemberfhessociationf SharewarerofessionalsASP).ASPantsoakeurehat theharewarerincipleorksorou.Ifourenable toesolvehareware-relatedroblemithnSPember byontactingheemberirectly,SPayebleoelp. TheSPmbudsmananelpouesolveisputerroblem withnSPember,utoesotrovideechnicalupport forember'sroducts.PleaseriteoheSPmbudsman at: ASPmbudsman P.O.ox786 Bellevue,A98006 orendompuserveessageiaasyplexoSPmbudsman 70007,3536. !ADD-INs Aĭ Version.00fS-EASY-ASupportsheevelopmentnd usefdd-Inrograms.Theserogramsanithere self-standingxecutablerogramshatutomaticallyhell toOSutootnvolveheS-EASY-ASorksheetnAM, orheyaneevelopedoccessheurrentorksheet data. Add-InsrenstalledsingheommandWSheet,eneral, Install,ddin.heenuresentedllowsouoreate newddIni.e.,nstallt),eletenddini.e.,e- installt)resetDe-install)llddIns.nce prompted,ypeheamefheddinrogram.EXEile) andressENTER].Youeedoaveheewlyenerated configurationileASEASY.CNF),hatontainshenfo aboutheddIns.Oncenstalled,heddinenuaye accessedyypingUser,ddinName. Thenformationecessaryoccessheorksheetatan RAM,ordd-Inrograms,sontainednheS-EASY-AS developer'sackagenothareware).Forore informationnheeveloper'sS-EASY-ASackagend possibleistributionfdd-Ins,leaseontactRIUS, Inc.t508)94-9377. !Arrays A(M)O Notehatatrixddndubtractperationesultsre controlledyheizefheirstatrixpecifiedor theperationseeelow). Addition:[i,j][k,l][i,j] --------- Subtraction:[i,j][k,l][i,j] ------------ Multiplication:[i,j][j,k][i,k]. --------------- Transposition:A[i,j]->[j,i] -------------- Inversion:A[i,i]>[i,i]ohatAxB=I ---------- Equationolver:otehatheonstantsectoreedso ----------------elacedmmediatelyoheight ofheoefficientatrixeforehe solution. !Column CO ToeturrentolumnidthWCSxx[ENTER] (Arroweysanesedohrink/expandolumns) Toetlobalolumnidth-WGCxx[ENTER] (Onlyffectsolumnidthsotetndividually) xxaneeplacedyormulahichanevaluated usinghe9Calc)eyeforeENTER]sressed DeleteolumnsWDCrange[ENTER] InsertolumnsWICrange[ENTER] rangenyalidange;aneypedn orighlightedsingherrow keysnheointingethod. !ComData Data/ArrayC (1) DATAARRAY FillRegressInvert XDataMultiply TableYDataAdd 1-ColumnOutputSubtract 2-ColumnQuitTranspose SortE-Solve D-Range BinQuit P(1)-KeyParse S(2)-Key ResetGoalSeek GoInput QuitOutput Desire QuestionQuit InpRangeInput CriteriaForm OutRangeCriterion FindRecRange ExtractQuit Reset Quit 1) !ComFile FileC FILE(1) Retrieve StoreXport ReplaceW?? CanceldBIII BackupErase W?? MergeP?? AllOther ValueList ReplaceW?? SumP?? DiffOther FormulaImport ReplaceText SumdBIII DiffValues RangeList ValueDirectory ReplaceUplink SumOption Diff Formula Replace Sum Diff 1) !ComGraph GraphC (1)(2) GRAPHICSTitlesAuto Type FirstManual X-YSecond Lower BarXUpper PieYFormat StackQuitFixed LineGridScience CumeHorizon, HlocVerticalCurrency RadarBothGeneral AreaClearDate DeltaDotD-M-Y SolidD-M XScaleM-Y AY-ScaleMM/DD/YY BAuto DD/MM/YY CManualH:M:S DLowerH:M EUpperPercent FFormat+/- ResetFixedText GraphScienceHide X, Reset ACurrencyNormal BGeneralStep CDateQuit DD-M-YPlot ED-MImage FM-YHigh LabelsMM/DD/YY Wide ADD/MM/YY Top BH:M:SBottom CH:MLeft DPercentQuit E+/-Density FTextHigh HideLow View Reset OptionsExpHardware LegendNormalPIC AStep Laser BQuit FX/MX CX-Scale24-Pin D(2)Paper EHeight FWidth FormatQuit GraphOrient NonePortrait LineLandscape Symbols.Eject BothGo DepthQuit A NoneColor LineYes Symbols.No BothName DepthUse BCreate NoneDelete LineMerge SymbolsSplit BothReset Depth C None Line Symbols Both Depth D None Line Symbols Both Depth E None Line Symbols Both Depth F None Line Symbols Both Depth 1) !ComPrint PrintC PRINTTO(1) Printer  FileSetup AppendPgLength Header RangeFooter BordersType RowsAs-Seen ColumnsContents NoneNoForm LineFeedQuit PageAdv OptionsAdjust MarginsGo Left Right PgLen Top Bot 1) !ComRange RangeC RANGE(1) Audit TracePrefix CrossRefErase OverviewName QuitCreate Delete FormatReset FixedTable ScienceBuild ,Lock CurrencyYes GeneralNo DateCopy D-M-YValue D-MTranspose M-YScale MM/DD/YYInvert DD/MM/YY H:M:S H:M Percent +/- Text Hide Reset 1) !ComWSheet WSheetC 1)(2) WSHEETInsert Install GeneralColumnColors FormatRowText FixedDelete MenuBk ScienceColumnMenuFr ,RowCsr CurrencyColwidthPtr GeneralSet Bord DateResetBot D-M-YEraseTop D-MBorder Neg M-YBoth Unpr MM/DD/YYHorizontalQuit DD/MM/YYVerticalPunctuate H:M:SSuppressDecimal H:MClearArgument PercentWindow Currency +/-HorizontalThousand TextVerticalMenuKey HideSync Quit ResetUnsyncDimension ClearEGA43 LabelTextAddin LeftFind Create Center ReplaceDelete RightJustifyReset ColumnWord Save RecalcMacroQuit AutoCompose Manual ExecuteSummary ProtectStep Enable Quit Disable(2) Zeros Yes No Negative Yes No 1) !Distributors D TheollowingsheurrentistfRIUS'istributors: (AuthorizedoellegisteredackagesfRIUSroducts) USTRALIA*PAIN ANACCOMInternationaloftwareroup Oox09Calleuesoineda4-2A enmore,LD06928043adrid el.07)68366Tel.11979 NITEDINGDOM*ERMANY harewarearketing ComputerolutionsmbH ighereadowsGartenstr. EEREX12HW8018rafing/Mnchen el.02974088Tel.080)2018 RANCE*ANADA ERNFORMATIQUEARLSoftware000,nc. ueicolasStrathdeeentre 5110aumeesames402-2206ewdneyvenue el.1417Regina,askatchewan4RH3 Tel.(306)77-0850 !FileImport I Theile,mportommandanesedomportextased (ASCII)ndBASEilesntonS-EASY-ASorksheet,r tomportheurrentirectoryisting. dBASEption ------------ IfheBASEptionselected,henecordsnhe selectedBASE-formatileremportedntoheurrent worksheet,ithachieldfheecordsnheBASEile placednolumnfheorksheet.Theolumnidthsre adjustedoeflectheieldizenheBASEileeing imported. Textralueption -------------------- Ifhealuesrextptionreelected,henS-EASY-AS assumeshatnSCIIileseingmported.Ifheext optionselected,ACHINEnhemportedileecomes aTRINGnheurrentolumnfheorksheet.Strings importedhisay,anhenearsedntoextndalues usingheata,arseommand**eearsingorormat andelimiteretails).Ifhealueptionselected, thenarsingutomaticallyakeslaceuringhemporting process. Example: Textileontainsheollowingwoines; Numbersyuckyumber 16s.6E+00ncientificotation Whenmportedntoorksheet,heatasrrangeds shownelow: A.ile,mport,extWithoutarsing). ---------------------------------------- .......A/....B/....C/............D/.......E/...... 1 Numbersyuckyumber 2 16s.6E+00ncientificotation 3  4  B.ile,mport,alueorextollowedyarsing). ----------------------------------------------------- .......A/....B/....C/............D/.......E/...... 1 Number9ismyluckynumber 2 16s6nScientificNotation 3  4 !Formats F Theappearanceofalockfellsaneetithhe /Range,ormatommand: 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,oecimals General Text+A1+B2[T]-ext +/-+++++[+/-] Date20ay,87[D1]-ate,ype HideH] ResetReturno General (NOTE:heellalueoesothangehenormatted) !F-Keys FK ķ*HELP F1 Inheeadyodenvokeselpthat'sowou ͼgotere). A.fterefturlyracketaseenntered,t bringspistontainingllheacro commandames. B.fternperatoraseenntered+,-,/,....), itringspistontainingllheange namesnheorksheet. C.fterheeyaseenntered,tringsp listontainingllheunctionames. D.fterackslashaseenntered,tringsp aistithllherinteretupodes containednhexternalileSEASY.PRT. Whennefhebovecreenssisplayed,ove toheesiredelectionndressENTER].our choiceslacednheommandreandoure returnedoheditode. ķ*EDIT F2 Placesheontentsfheellheursors ͼcurrentlyon,nheommandreandntershe editode.Afterouinishditing,ressENTER] toccepthehangesndeturnoheeadyode.    ķ*NAME F3 Pressing3oureromptedoracrooxecute. ͼYouanitherypeheameritSCAPE.Ifou hitSCAPE,indowppearsithllheange names.Selectheneorrespondingoheacro youantoxecutendressENTER]. Whilenheditode,ressing3lacesoun theontrol-Code-Bypassodehichllowsouo enterrinterontrolodeslowerhan32SCII) usinghelt-Numericeypadombination. Forxample,heolllowingeyequence, Thiss3lt-015ondensed3lt-018rint, willesultnheordCondensed'rintedn condensedodeonnPSONompatiblerinter).  ķ*ABSOLUTE F4 Ifourenteringormulasingheointing ͼmode,ressing4illakeheastnteredell referencebsolute.Repeatedlyressing4ill cyclehroughakingolumn,owndoth coordinateseingbsolute.  ķ*GOTO F5 Whenouress5,oureromptedor ͼdestinationell.Youanitherypeheellr rangeameouantooo,rressSCAPE.If youressSCAPE,indowppearsontainingll theangeamesnheorksheet.Selecthe rangeameouantndressENTER].  ķ*WINDOW F6 Ifwoindowsreurrentlypen,6oggleshe ͼcursoretweenhem.Ifnlyneindowspen, pressing6ogglesheursoretweenheurrent andastursorellocation. ķ*WORDROCESSOR F7 Enterheordrocessorode.Rowsndolumn ͼdisappearndulerinesisplayedtheop ofhecreen.PressSCoeturnohe worksheetodefteroureinished.Ifot enoughemorysvailableonterheord processingode,nppropriaterrorille displayed. ķ F8 *CURRENTLYOTSED ͼ ķ*RECALC F9 Pressing9e-calculatesllellshatontainn ͼequation.hilenheditode,ressing9 replaceshequationhatsisplayednhe commandsreaithtsalculatedalue. ķ*GRAPH F10F10e-displaysheurrentlyefinedraph.This ͼfunctioneyssefuloriewingraphshile performinghat-ifnalyses.sing10ouoot haveoohroughheGVndhenuitequence everyimeouhangehealuesfheefined andanges. !General GS Manyfheptions,vailablenherogram,ane invokedhentartingherogram. Theorms:ASEASYSwitch1/Switch2/...ENTER] /H-nablesraphicsorercules /H2-nablesraphicsorercules,ideog. /E-nablesraphicsorGA /ATT-nablesTTisplayraphics /Q-uickcreenpdatingorGA /V1-orceGAmulationforncompatibleGAs) /NT-ourboeyboard,Slowownursor). /P-etheefaultoanel-typeenus /RA-oundbsolutee.g..6o.,1.6o1.) /CTR-entersheolumndentifiers /MY=x-etsheurrencyignoinsteadf) /BK=x-etcreenlank-outeriodoeconds /TP=x-etolumneaderharactero /DV=x-etolumnivisionharactero /MONO-hangesolorsohitenlackCGAard) /SP-uppressheolumnndoworders /SET=$MGBFetheefaultolorssingleigitex) (M)enu,G)raph,B)ackground,F)oreground /DIR=Path..-SetheathoheKSiles /AUTO=File...pecifyheorksheetoeoaded whenherogramstarted Commandsreccessedyressinghelash/]ey. ToxitromnyenuressheESC]ey. Graphsanerintedoile,otatrixraser printeryccessingheraphub-menu. Menurivenndtherutomaticperationsane developednS-EASY-AS,singtsowerfulacro commandsseeectionsnacros). !Goalseeking G Findshenputecessaryoroduceesirednswer. Specifynputell Specifyutputell Specifyesiredutputalue Specifyoleranceortterativerocess ........A/.......B/.......C/.......D/.......E/ 1 2(Input)(Output) 310,0001.000%24470.73 4 #ofayments LoanmountPaymentmount Monthlynterestate(12%err)@PMT(A3,B3,C3) Ifheaximumaymenthataneffordederonths $450.00,hatsheonthlynterestatehatill permitorrowinghe10,000?Tolerance.001). ........A/.......B/.......C/.......D/.......E/ 1 2(Input)(Output) 310,0000.625%24450.00  Desiredolution !Graphs GIG STEPSoueedoollownefiningraph: a).Definehe-Range b).Definenerore-rangesAhrough) c).Specifyheormatfhendxes d).Specifyheraph,-axisnd-axisitles e).Finally,iewrrintheraph. Upoifferenturvesanencludedningle graph. Seeheollowingopicsororenformation: GraphType,raphOpt !GraphType GT LINE: Allaluesrereatedsabelsndlottednhe orderheyccurnhe-range. X-Y: Allaluesreatedsumbers.Y-valuesrelotted asunctionals,ssumingontinuousunctional relationship. BAR: Allaluesreatedsabelsndheyrelottedt equalntervalsnhexis. PIE: Allalueslottedsercentfumfalues.X contentsrereatedsabelsndlottedexto percentalues.oeneratenxplodingiehart (withnerorelicesfheieeparatedromhe rest),nheolumnoheightfhe-rangenter theumberfixelshatouanthatliceemoved fromheestfheie.ememberhatiehartan onlyavene-range.Iforehanne-rangesre defined,henhe-rangessedneneratingheie chart. STACK: Stackedarraph.achpecifiedangeslotteds anncrementalar,nopfhereviousne. CUM: Thisypefraphserysefulnepicting continuousncreasingunctionsndheirumulative valuestachunctionvaluationoint. RADAR: Aolarypefraph.The-Axisrelotteds coeccentricircles.Dataangeointsrehen connectedithadialinesnannerimilarohat inolarraph. AREA: SelectnArea'yperaph.Thisypefraphses linesolotneefinedraphangenopfhe other,ithhereaetweenachfheraphines filledithifferentattern. DELTA: Thisypefraphssedolotheserefined rangesstepunctions. !GraphXtra PGO SPLIT Showworaphsnheamecreen.Oneccupieshe topalffhecreenndhetherheottomalf (Similaroheraph,ame,ergeption).Theirst graphsheraphurrentlyefinedndheeconds aamedraph. MERGE Showworaphsnheamecreen.Thisssefulor twoifferentangesithheame-valuesut different-values.Theefterticalxisisplayshe scaleorheurrentraph,hileheightertical axisisplayshecaleorheamedrapheing merged.hetepsorergingworaphsrehown below: 1)ssumeouaveraphamedGraphOne". 2)efineewurrentraph. 3)nvokeheame,erge,electption. 4)electGraphOne"romheisthatppears. 5)ressiewoisplayothraphstheameime. !GraphOther OGO LEGEND Identifyheisplayedurvesyegendocatedither belowroheightfheraph. FORMAT Setheormatorheholeraph,rorelected curves.Displayustataoints,ataointsonnected withinesrustines. TITLES Setheraph,he-axisndhe-axisitles. GRID Selectorizontal,erticalrid,rothndelect betweenottedrolidridines. COLOR Selectromolidolorsrillatterns. SCALE Usinghisption,ouayelectanualrutomatic scaling,heisplayormatndormalrxponential scalesoritherrothxes. !GraphPlot PAG IMAGE Mayesedoetllhearametershatffecthe wayheroducedlotooks.Theeightndidthf theeneratedmageinotsesolutionependsn yourrinter),ndheop,ottomndeftarginsan beetithhisommand. DENSITY Caneetoigh(slowutarklot)row(fast, recommendedorraftlots). HARDWARE YouayendheutputoPICileforombining withourext-ifourordrocessorupportst),o a-pinPSON-FXrompatiblerinter,4-pinQ typePSONrompatible,roPaserjetr compatible. PAPER Canesedoetheizefheaperalsoote theapers/imagerientation). ORIENT Anmageanerintedithernortraitrnand- scaperientationsideways). !Install IO UnderheSheet,eneral,nstallenu,heserill findanyptionshatillailorherogramois needs. COLORS Issedoetheolorsorheext,heenu,he cursor,heocationointer,heorders,heottom line,heellsontainingegativealuesndhe unprotectedells. DIMENSION SetheD-simulationptionseeanelsopic). EGA43 TogglesetweenheGA43-lineode)ndheGA,GA (25ineode)oronitor/cardombinationshatill handleoth. PUNCTUATE Setheefaultoromeasicptionsnherogram: TheharacteroesedoreparatingheECIMAL portionfumber. TheharacteroesedoreparatingheHOUSAND portionfumber. TheharacteroesedoreparatingRGUMENTSf function. TheharacteroesedorURRENCYe.g.,,,..) TheOTEYi.e.,heeyoesedornvokinghe mainS-EASY-ASenu) ADDIN Thisommandllowsouoreatend/oremovenS- EASY-ASdd-inromhedd-inenu,seeectionn Add-ins). !Keys MA Up:ovepneowHome:oveoell1 Down:oveownneowPgdn:oveown0ows Left:oveeftneolumnPgup:ovep0ows ight:oveightneolumnTAB:oveightneage ShiftAB:oveeftneage F5:otopecifiedellramedange Pressinghendey,ollowedynefrroweys, movesheursorohendfheurrentlock. ........A/.......B/.......C/.......D/........E/ 1 1271212 2 9123343 3 10876 4 1274 5 215534 6 11249129 7 3311 8 Ifursort1:[END]DOWN]--->ursort3 [END]RIGHT]--->ursort1 Ifursort3:[END]DOWN]--->ursort6 [END]RIGHT]--->ursort3 !Linking  Theorksheeturrentlymemoryaneinkedo worksheetsnisksingheLINKunctionfS-EASY-AS. @LINK("FileName>Cell") Ex.@LINK("c:\SAMPLE.WKS>A231") heoubleuotesndhe>'haracterreecessary heilepecifiedyFileName'houldenhe currentatairectory.TheWKS'xtensions optional. Whenhisunctionsntered,heellillisplayERR' indicatinghatoinkingasakenlace.Whenhe /File,plinkommandsxecuted,heontentsfhe referencedCell'nFileName'reetrievedndlaced inheallingell.NotehatllLinked'ellsre updatedhenilesetrievedi.e.,sfFile, Uplinkommandasxecutedightfterheileas retrieved).Alsootehatoecalculationfhe referencedellakeslaceeforeplinking. !Macros ACROS Aacrosequencefeystrokesrommandshichan beperformedutomatically,ustikerogram.Macros caneefinedyssigningangeameingleetter [A..Z]recededy[\]backslash. Theacroillontinueoxecuteownwardromhe firstowntillankowseachedrheESC]ey isressed. AutoExecuteacrostartxecutingmmediatelyftera spreadsheetisoaded.Toefinenutoexecuteacro, applyaangeamef0oheirstacroelloe executed. Allacroeysndubstituteunctioneysuste enclosednraces}.ryheollowingimpleacro whichovesheursorightells. Typeheollowingnell1:RT}{RT}[ENTER] Giveell1angeamefA.NowressAlt]ndhe letter.See,ourirstacro! !MacroRec MR Youreystrokesayeecordedutomatically,ndurn intoacroommandequences. 1.Enterheacroecordingodeyxecutinghe command:/WSheet,acro,ompose (TheodendicatorhangesoCompose!') 2.Goboutourusinessssual.Youreystrokesre beingtorednufferuptoo024ytes).Please notehathenheFileenusnvoked,heacro composingodesutomaticallyancelled. 3.Whenouaveinishedithouracroomposition, invokeheommandncegain/WSheet,acro, Compose).Youilleskedorellocationo storeheeneratedacro.Moveheursorohe desiredocationndressENTER].Notehat dependingnheizefheacro,ellsnheow belowayeverwritten.Carehouldeakeno placeheacronocationithufficientumber oflankrndesiredowsfells. !MacroPlay OMF Longndomplicatedacroommandequencesayeested andebuggedsingheWSheet,acro,tep,esommand. -Specifyheelayetweenacroommandinesn/1000 ofecond.(Delayilltoptachacroommand linentilENTER]sressed). -Startacroxecution.Eachacroinesisplayedn theottomtatusine,ithhepecifiedelayime betweenines. TheWSheet,acro,xecuteommandanesedoxecute macroangesithamestherhanheAlt-Letter' combination.Alsonotehatuchacroayexecuted byressing3romheeadyode. Thexecutionfacroommandequenceshatontain lotfursorovements,illencreasedignificantly ifheSCRNOFF}ndheMENUOFF}acrosresed. !MacroKeys MK Whenncounterednacrotatement,heyakeSEASY behavesfheorrespondingeyasressed. {LT}-ursoreft{PGLT}oneageeft {RT}-ursoright{PGRT}oneageight {UP}-ursorp {PGUP}oneagep {DN}-ursorown{PGDN}oneageown {BS}-ackspace {HOME}-ursoro1{NAME} {EDIT}-2{GOTO}F5 {CALC}-9~-SuborENTER] {ESC}-scape{ABS}-F4 {WINDOW}6{END}-Endey {GRAPH}-10{DEL}-Deley {INS}-ogglesnsertode {?}-auseornput SeeacroWordsopicororenfonacroanguage. !MacroWords ML Theseommandsrenlyvailableromithinxecuting macros. Beep}-ingleeepound. BlankRANGE}-rasehepecifiedange Bordcolor}-etsheorderoloro BorderOff}-urnFFheowndolumnorders BorderOn}-urnNheowndolumnorders Botcolor}-etsolorfottomineo Call}-ALLoutinetollowingellnd executentilRet} ClrScr} -learhentirecreen Curscolor}-etsolorfursoro DefaultAnn"}-etsanelenuositionoinen DefaultEnn"}-etsellchoreaoinen DefaultFnn"}-etsottomowositionoinen DefaultHnn"}-etsolumneadingineon DefaultTnn"}-etsopineositionoinen Delay}-elaynction,aitingorressing anyey. EscOff} -isablehescapeeyuringacro execution.Thescapeeyecomes effectivegain,nceheacro executionodesxitedrfn {EscOn}acrossed. EscOn}-esethescapeeyundoEscOff}). Exit}-learLLevelsfheubroutine stackndontinuexecutionfhe macroommands. Getell}-cceptsheexteyressedndlaces itnell. GotoXy1,A2}-ositionharacterursortol,row Ifest}-Ftruehenxecutetollowing commandlsexecuteextow InLabelMsg",A1}-nputABELndlacenell InValueMsg",A2}-nputUMBERndlacenell Indxy,n}-lacetatusndicatornol,ow Inkeyell}-laceheexteyressednell InRangeMsg",Cell} -romptorangesingMsg".he rangespecifiedsingheointing method,nderminatedyENTER]. Theesultingangeslacednell. Jump}-UMPoellollowingnstructionnd startxecuting. Letell,Arg}-eplacesheontentsfellithrg (value,quation,tc.) MenuCallAME}-imilaroboveutubroutineall MenuJumpAME}-efineourwnenundranchot MenuOff}-urnffenupdating MenuOn} -urnnenupdating MenuWidth1}-etheidthfenu,ax=30ols. MenuXy1,A2}-etheol,rowositionfheenu. Menucolor}-etsheolorfheenuo OptionBLx"}-etseftorderharactero OptionBRx"}-etsightorderharactero OptionC"}-enterharacternolumneader OptionDx"}-hangesolumnotsoharacter OptionL"}-electsanelenu OptionVx"}-etsolumnividerharactero Quit}-UIT,topxecutingheacro PtrColor}-etheointeroloro RecalcANGE}-alculatenlyhepecifiedange Restart}-learneevelfheubroutine stackndontinuexecutionfhe macroommands. Ret}-ETURNromalledubroutine ScrnOff}-urnffhecreenisplaypdate ScrnOn} -urnnhecreenisplaypdate TextColor}-hangesheextoloro (seeanualorolors) Tone1,A2}-layonefuration,requency Topcolor}-etsolorfopineo Update} -efreshcreenithewellalues While,Test,Action}epeatAction'hileTest's valid.Then,roceedithheacron theellelow. WriteMsg"}-lacesgtharacterursorosition WriteLnMsg"}-amesbove,ithR/LF !MacroExample ME Example1 ---------- Enterhenformationresentedelownhendicated cells:FinishachntryyressingheENTER]ey). ell ContentsExplanation ---------------------------------------- A1 {GOTO}A21~ Placeursornell21 A2{?}Pausendaitornput (TerminatedyENTER]) A3 {GOTO}A1~Placeursornell1. Nowoveoell1ndress/rnc\b[ENTER][ENTER]. Pressinglt-B,illowoveheursoroell21nd pauseornput.Typenythingouantincluding nothing)ndressENTER].Theursorillowoveo cell1,ndxecutionfheacroilltop. Example2 ---------- Enterhenformationresentedelownhendicated cells:FinishachntryyressingheENTER]ey). ell ContentsExplanation ------------------------------------- A1{HOME}Placeursorn1. A2{INVALUEA=",B1}DisplayA="nhe panelreafhe worksheet,lacehe enteredaluen1. A3{if1>10}{JUMPT}Ifhealuen1s greaterhan0,tart executingheacro namedT. A4{LET2,B1*10}Multiplyaluen1 by0,ndlacehe resultn2. A5Leavehiselllank. A6 {LET2,B1*100}Multiplyaluen1y 100,andlaceesultn cell2. A7Leavehiselllank. Nowameheequiredangessingheollowing keystrokes: /rnc\aa1[ENTER]-Nameheirstacroell /rncQTa6[ENTER]-Nameheecondacroell. Presslt-A.TherogramillisplayA="nheanel areandauseornput.Enteraluendress [ENTER].Ifhealuesesshan0,00imeshe valueppearsn2,fot,0imesthealueppears in2. !Parsing P Parsingssedoonverttringaollectionf characters)ntoquivalenttringsraluesndjacent columnsnheameow.Parsingssed,orxample,o convertilehichasmportedsext,ots equivalentextndalues**SeeileImport).Ithould beotedhatertainharactersresedselimitersn parsing. [;][,][+]['] Examples: Ab20+15--->Ab125015 AbE3;10--->Ab2000510 Ab1'20--->Ab1220    Labels !PrintCodes PC Generally,orPSONyperinters,herinteretupode isadepfheSCIIecimalodeorheSCharacter followedySCIIodesorther,pecificharacters. (Theseodesaneoundnourrinter'sanual). AllrinterontrolodesustelacednETUP string.AS-EASY-ASillcceptodessHREEIGIT decimalSCIIharacterodes,recededyheack-slash character\],rsSCIIharacters.Forxampleou mayypeithernefheollowingwoquivalentodes inesponseoheromptorheetuptring: \027\069[ENTER] \027E[ENTER](069sheodeor) Ifyouwantohangehetringouanditty re-selectingheETUPption.Commonlysedodes forPSONtypeprintersre: Ŀ \027\070EmphasizedFF \027\071Doubletriken \015CondensedON\027\072Doubletrikeff \018CondensedOFF \027\0481/8"linepacing \014EnlargedON\027\0497/72"inepacing \020EnlargedOFF \027\0501/6"linepacing Pressingndhen1,illpenecondaryindow containingheetupodesvailablenherinteretup fileseeser'sanual). !Printing  RANGE:pecifyhereaoerinted. INEFEED:dvanceapernrinteringleinepwards. PAGEADV:dvanceaperoheopfextage. ADJUST:esetinendageountero. OPTION:ccessherint,ptionsenu. MARGINS:etherintargins.Topndottomargins arenfinesndndditionoheeader andooterines.Leftndightarginsre inharactersndheaximums40. PG-LENGTH:etheengthfage.po024ines. HEADER:tringnopinefveryage.Three availableields,eparatedy. #=Embedage,=Embedate FOOTER:tringnottominefveryage. Sameieldssoreader. SETUP:endontrolodesoherinterseeopic). TYPE:S-SEEN=Values,tc.CONTENTS=Equations,tc. GO:inallyheneadyorint,electo. Note:ouanTOPherintertnyimeyressing theESC]ey. !Q&A Q&A heollowingrenswersoomeommonuestions. Q1.IeeSTERISKShereyumbersedoe. A1.Numbersoideoeisplayednheolumn. Expandolumnntilumberppearsrhangeormat /Wsheetolumnet Q2.Notllfyrintangerints,artsutff. A2.Yourrintarginsreot,robably,idenough. Expandarginith,PrintTorinterptionsargin. Q3.HowoetnUTOEXECacro? A3.Giveouracroangeamef0zeroot),and saveourile.Nextimeheilesetrievedt willtartxecutinghatacro. Q4.Canaveorksheetileoadedutomaticallyhen Itartherogram? A4.Yes,hererewoaysouanohat. 1.ameourorksheetUTOEXEC.WKS.lso,emember toetheefaultdirectory,ohenehere thisilesocated,henoutartherogram. 2.tartS-EASY-ASsingheOSommandine: ASEASYAUTO=FileName.WKS whereileNamesheesiredorksheet. Q5.IaveGAardithlackndhiteonitor,nd Ian'teeheraphshenheyreisplayed. A5.UseheMONOwitchhenoutartheS-EASY-AS program. Q6Iriedoiewraphhatadefined,nd onlyothexes,oataoints. A6.Thisymptomsuallyccurshenhe-axiss definedsangefabels,ndheraphypes- Y. Q7.ImportedilentoS-EASY-ASsingheile, Import,aluesommand,ndothealuesutot anyfheabels. A7.WhenmportingnSCIIilesalues,henly labelshatreetainedrehosenclosednouble quotes. Q8.Howanideolumns? A8.Columnsaneiddenypecifyingolumnidth zero. Q9.Howanreventhide)owsromrinting? A9.Placeipingharacter|)nheeftmostellf theowouantoide. Q10.atesootortroperly,ugustomeseforeune! A10.atesnteredsune0,989,orxample,re labels.Therefore,ugust2,989omeseforeune 10,989inceugusttartsithnnduneith a.Toroperlyortates,heyhouldentered usingnefheS-EASY-ASatertring-to-Date functions. !Querying QAD Findrxtractecordshichatchingelectedriteria, fromatabasenS-EASY-AS. 1.efineheatabasenputange:DIA1..C6ENTER] AnS-EASY-ASatabasesadepfecordsrows), andachamenheefinedangesieldfhe respectiveecord.Theolumneadingspartfhe databaseange)reheieldames. 2.efineheutputange:A21..C24ENTER] Theirstowfheutputangeontainsheames ofheieldshatouantoxtractromhenput range.TheieldameshouldeDENTICALohosen thenputange;eecommendopyinghematherhan retyping! 3.efineheriterionange:CA11.A12ENTER] TheirstowontainsnXACTopyfheield namesoesedsriteria. Criteriarepecifiedsingogicalperatorndhe correspondingieldnheirstecordrow)fhe inputange.Wildcardsrellowedntrings criteria: *-atchllharactersoightf A*=atchnyecordhoseespectedield startsithegardlessfhatollows. (Arc,pron,llston,cton,..) ?-atchingleharacternositionf. ?atatchnyecordhoseespectedield startsithnyharacterndasat'she secondndhirdharacters.Cat,at, Rat,...) ~-atchnything>oriterionbutot) ~Atatchnyecordhoseespectedield isotAt'.This,hat,ames,...) ...atchfollowingtringsnield ...areMatchnyecordhoseespected fieldontainsheharactersare'. (Shareware,oftware,eware,...) .xtractheecordshateetheriteriaefinedn item,bove:E Databasenputange -------------------- ..............A/......B/..........C/........D/...... 1 NameAgeHeight(m)<-ieldames 2 Billohnson191.82 3 Wayneilliams411.79 4 Johnones291.88Records 5 Jamesarlson 331.74 6 Bobobinson181.91 7 Databaseriterionange1) ---------------------------- ..............A/......B/..........C/........D/..... 11Name <--ieldame 12J*<--riterion(Thisriterionill 13filterutllecordsherehe 14firstetterfieldName'sot) Databaseutputange1) ------------------------- ..............A/......B/..........C/........D/....... 21NameAgeHeight(m)<--ieldames 22Johnones291.88 23Jamesarlson 331.74 Extracted 24Records Modifyheriterionange,hisimesinghegess filter.Thenepeathextract/DQE)ommando extractheewecords. Databaseriterionange2) ---------------------------- ..............A/......B/..........C/........D/..... 1 Age<--ieldame 2 +B2>30<--riterion(Thisriterionill 3 filterutllecordsherehe 4 fieldAge'sreaterhan0) Databaseutputange2) ------------------------- ..............A/......B/..........C/........D/....... 1 NameAgeHeight(m)<--ieldames 2 Wayneilliams411.79 3 Jamesarlson 331.74 Extracted !Range  Rangesayepecifiednwoays.heirstaytarts bypecifyingheirstallfheange.Athisoint useheursoreysooveheointerutfheell, andovetoneornerfheesiredangeouisho highlight. Presshe.'ey.Thisanchorsthepointersothat additionalointerovementsighlightsorehanust singleell. Expandheointerntilheesiredangesompletely highlighted.ftherangeisiggerhanhatrea displayednhecreenhenresshe.'nchoreyo examineachfheornersfheange.ittle flashingursorillndicatethecurrentcorner.It islsohisidefheointerhichayeovedyhe cursoreys. Whenheangesompletelyighlightedressnyther keyoeturnoourriginalellndontinueithour work.rfoureinishedwiththeormularesshe [ENTER]ey.Yourormulaillenteredntohe spreadsheettheurrentellosition. Theecondayopecifyangesimplyoypehe rangeameypecifyingheornersfheanges individualellseparatedbywoeriods..e.A1..B2 Theangeommandsllowouoperatenlockf cells.Forxample,onsiderllheellsoundedy cellA1andellD2,ndssumehatheursors currentlyt1.Toormatllheellsithinhe abovelockoIXEDORMATithwoecimals,nterhe followingeystrokes: rfENTER]LEFT]LEFT]DOWN]DOWN]ENTER] Finish Operation Moveo2 Moveo1 Moveo1 Moveo1 2Decimals Fixed Format Range Invokeenu !StartUp TotartS-EASY-ASromnyOSisk/directory: 1.herivendirectoryhereSEASY.EXEsocated shouldenheOSathseeourOSanualn settingheath). 2.henvironmentariableSEASYhouldeeto pointoheS-EASY-ASisk/directory. Atheosrompt,ypeSETSEASY=D:\Directory' (withoutheuotes),here:\Directoryshere ASEASY.PRT,SEASY.HLPndSEASY.MSGreocated. Thisommandouldlsoencludednour AUTOEXEC.BATile. Oncehebovewotepsreompleted,ouantart AS-EASY-ASromnyisk/directoryyimplyyping ASEASYndressingENTER]. SeeopicGeneral'forrogramtart-upptions* !Sorting  Sortingataasefecordsynyieldolumn mayeoneyerformingheollowingequencef keystrokes. 1.Getntoheataortenuyyping/DS 2.DefineheNPUTange,hisncludesllecordsn theataase. (.e.llowsndolumns,xcludingheeadings) 3.DefineheRIMARYey 4.Optional:efineheECONDARYeyriereaker 5.SelectOonitiateheort. 6.WAIT! Theortilleompletedhortlyndeepill sound. PleaseotehatortingsoneccordingheSCII valuesfheharacters,herefore,umbersrelaced beforeharacters.. !WordProcess WP TheordrocessingodefS-EASY-ASayeccessed eitheryressing7,ormheeadyode,ry executingheommandWSheet,ext,ord. Upo0inesfextreccommodatedachimehe wordrocessorsnvoked. Automaticinerappingithrithoutpaceadding (Ruggedrustified)soggledyressing7nce inheordrocessingode. F2llowsouoetheightarginjustntern theesiredocation) Entriesrevaluatedndrereatedsabelsr valuestrailingpacesillesultnabel). Theollowingditingeysrective: HOME->Beginningfine END->Endfine DEL->Deleteurrentharacter INS->Togglensert/overwriteode BACKSPACE>Deleteharacteroheeft TAB->8pacesoheight ShiftAB>8paceoheeft NotehatRsaynlyeeletedyckSpace. !@Date/Time DůF @DATE(YY,MM,DD) Serialumberfaysroman,1900oearY, MonthM,ayD. Ex.DATE(87,5,20)1917 (Note:elleedoenateormatoisplayates) @DATEVAL(String) SerialumberfaysntringMM/DD/YY". @TODAY Returnsheerialumberfaysoow. @TIME(HR,MIN,SEC) FractionfayorrespondingoR:MIN:SEC @TIMEVALUE(String) FractionfayorrespondingotringMM/DD/YY" @DAY(X) Theayn.@DAY(31917)0. @HOUR(X) Theoursnheractionalartf @MINUTE(X) Theinutesnheractionalartf @MONTH(X) Theonthn.@MONTH(31917)May) @SECOND(X) Theecondsnheractionalartf @YEAR(X) Theearn.@YEAR(31917)7 !@Finance FF @CTERM((Interest,FutureValue,PresentValue) Theumberfompoundingeriodsequiredorn investmentfVpresentalue)orowoVfuture value),fhenvestmentsarningNTnterester compoundingeriod. @DDB(Cost,Salvage,Life,Period) Acceleratedepreciationalueornsset,ivenhe initialost,heifexpectancy,hendaluendhe depreciationeriod.Theepreciationsalculated usingheoubleecliningalanceethod. @FV(Annuity,interestate,period) Returnsheuturealueorrespondingoanannuity occurringverhepecifiederiod.Reversefhe above. ex.@FV(700,0.0925,30)9979.77 @IRR(Interestate,Range) Returnsheatefeturnereriodssociatedith cashlow.Morehanneolutionayeossiblef cashlowhangesetweenositivendegativealues throughoutange. ex.@IRR(0.11,H1..H5) @NPV(Interestate,Range) ReturnstheNetpresentvalueofashlowver interesteriod. ex.@NPV(0.1,A1..D1) @PMT(Principal,interest,period) Returnshemountfnnnuityqualohe principalmortizedverheeriod. ex.@PMT(75000,0.0925,30)462.61 @PV(Annuity,interestate,period) Returnsheresentalueorrespondingtoanannuity occurringverhepecifiederiod.Reversefhe above. ex.@PV(700,0.0925,30)035.08 @RATE(FutureValue,PresentValue,N) nterestateequiredornnvestmentfVALoe orthVAL,nompoundingeriods. @SLN(Cost,Salvage,Life) traightineepreciationfnssetverNEeriod fIFE. @SYD(Cost,Salvage,Life,Period) epreciationfnssetsingheum-of-Years epreciationethod. @TERM(Payment,Interest,FutureValue) umberferiodsequiredoccumulatennvestment fVALakingegularaymentsfMTndccruing nteresttheatefNTereriod. !@LogicFunc LF @IF(Condition,arg1,arg2) Valuefrg1fonditionsrue valuefrg2fheonditionsalse.llowable logicalperators,<,=,<>,>=,<=OR#,AND#. Ex.@if(10>2,3*2,4+5) +(a1>2)*3+(a1<=2)*4Thisormulaillield resultffhealuetorednell1 isreaterhanndillieldfhe valuesesshanrqualo. @ISSTR(Cell) Returnsfheeferencedellontains label,therwise. @ISNA(Cell) ReturnsfeferencedellontainsNA, 0therwise. @ISNUM(Cell) Returnsfheeferencedellontains value,therwise. @ISERRCell) ReturnsfellontainsRR,therwise. @TRUE Returnshealueflogicalrue). @FALSE Returnshealueflogicalalse). @NOT(Cell) Logicallyegateshealuefell.0ecomesnd becomes. @NA Alwayseturnshealuef1.Usefulnogic checkingormulas. @CASE(N,Arg1,Arg2,Arg3,......) Returnshethrgumentromhergumentist. @ERR ReturnshetringERR'.UsedyISERR,bove. !@Math MF Thefollowingunctionsctponhergumentx'ithin thearenthesis.Thergumentayealuerormula whicheferencestherellsithinhepreadsheet. FunctionDescription/Example @ABS(x)Returnshebsolutealuefrgument. Example.@ABS(-10)0 @ACOS(x)Arcosine,eturnsadians @ACOS(0.5).0471 @ASIN(x)Arcine,eturnsadians @ASIN(0.866).0471 @ATAN(x)Arcangent,eturnsadians @ATAN(1.732).047 @COS(x)Cosinefngle,nadians. @COS(1.047).5 @EXP(x)Raisee'ohex'ower @EXP(5)48.4131591 @INT(x)Integeraluefrgument.heractional partfheumbersruncatedandthe integeremainderseturned.xample: @INT(10.6)0 @LN(x)Naturalogarithmoasee' @LN(6).791... @LOG(x)Logarithmoase10' @LOG(10) @MOD(x,y)Moduloivision, @MOD(10,3) @PIConstanthichasaluef @PI.14159... @RANDReturnsewandomumberfterachALC. @ROUND(x,y)Roundsalueoigitsightfecimal @ROUND(123.123,1)23.1 Negativealueoundsoeft. @ROUND(123.123,-2)=00 @SIN(x)Sinefngle,nadians. @SIN(1.047).866 @SQRT(x)Squareootfrgument. @SQRT(2).4142135624 @TAN(x)Tangentfngle,nadians @TAN(1.047).732 !@SpecialFunc SF @CELLPT(String) ReturnsnformationboutheURRENTelli.e.,he cellhatheointersurrentlyocatedn).Type ofnformationependsntring. StringFORM"returnsheormatfurrentell. StringADDRESS"eturnsheddressfurrentell astring StringCONTENTS"heontentsfellreeturned astring,.g.A1+3seturnedsA1+3" StringROW"eturnsheurrentellowddress. StringCOLUMN"eturnsheurrentellolddress. StringWIDTH"eturnsheurrentellolumnidth. StringPREFIX"eturnsheurrentellabelrefix STRINGTYPE"eturnsnntegerependingnhe contentsfheurrentell. 0tringormula 1alueormula 2nteger/Value 3nteger/Value 4tring/Label 5lankell 6irginlankell 8tringormularror 9alueormularror @ROWS(CellOne,CellTwo)umberfowsetweenhewo cells. Ex.@Rows(A1..D10)0 @COLS((CellOne,CellTwo)umberfolsetweenhewo cells. Ex.@Cols(A1..F10) @HTABLE(compare,range,ofs) Returnshealueterticalffsetnheolumn thatatcheshecomparealue. Ex.@HTABLE(5.6,A1..C3,1).4 @VTABLE(compare,range,ofs) Returnshealuetorizontalffsetnheow thatatchesheomparealue. Ex.VTABLE(2.3,A1..C3,2)0 @HTERP(x,range,offset) Returnshe(x)alueasednorizontal interpolationfable.Theirsttop)owf 'range'sontainshe-values.Theoffset'ow containshe(x)alues. Ex.HTERP(1.2,A1..C3,1).415555 Ex.HTERP(5.5,A1..C3,2).38 @VTERP(x,range,offset) Returnshe(x)alueasednertical interpolationfable.Theirstleft)olumnf 'range'sontainshe-values.Theoffset'olumn containshe(x)alues. @VTERP(1.2,A1..C3,1).758333 @VTERP(3.4,A1..C2,2).666666 @CELL(String,CELL) OperatesheameaysCELLPT.Alltringrguments validorCELLPTrelsoalidorCELL.Iteturns thenformationbouteferencedCELL'atherhan aboutheURRENTell. @@(Cell)ndirectddressing ReferoCell'.Forxample,fell1ontainedhe string22ndell22ontainedhealue,henhe formulaSQRT(@@(A1))ouldeturnhealue. !@Statistics SF Statisticalfunctionsoperateonarangeofvalues. Aangepecifiesectangularlockfatanhe spreadsheet.OnlyONEangeayesedsnrgument. i.e.Range1..B10efineshelockfatarom: 1...b1 a10...b10 Presentedbelowarethestatisticalfunctions availablewithinS-EASY-AS.Tollustrateheseof eachfunctionanexampleisncluded. Allexamplesillperatenheumbersontainednhe portionfhepreadsheetuplicatedelow,1..C3. /........A/.......B/.......C/ 11.15.68.2 22.37.510 33.54.42 4 @AVG(Range)Averagealuefheange Ex.Avg(A1..B2).955555 @COUNT(Range)ountheumberflements inheange.Blankellsgnored. Ex.Count(A1..B2) @Count(A1..A4) @FACT(x)Factorialfب0