TurboCalc © 1993-1997 Michael Friedrich ======================================= The AutoOpen Directory ====================== TurboCalc has the ability to automatically read in the contents of sheets at startup. This has to set using the menu option using the 'AutoOpen-Directory' fields: A tick-mark turns on the AutoOpen feature and the text field defines the directory, from which TurboCalc should automatically read all TurboCalc spreadsheets. The default is 'AutoOpen' which would normally correspond to this directory (where this file is located). It's then sufficient to simply click on the gadget to set the tick-mark. Once this is done and is selected, the next startup will result in the following sheets being loaded automatically: * Auto_AutoFormat * Auto_WhatIf These two macros extend the internal menus to provide the and commands; a description of which follows. The files are read in automatically in background so no window needs to be opened for that - thus they provide a means of externally extending the command set. Both macros can be found, in a slightly modified form, in the Sheets3.0 directory (as Macro_AutoFormat and Macro_WhatIf respectively). They open, as distinct from the above, a sheet window and display relevant information. They are provided for you to inspect and to try out. Notes: ------ 1. The new commands are normal TurboCalc macros. Please note that: * Macros don't run as fast as internal commands. Be patient. * Rigorous error handling and handling of details is limited. * On the other hand, you may alter these macros to suit your own special needs. * The macros should also encourage you to do some of your own programming to explore various possibilities and tricks. (Should you develop your own commands and wish to share them with other TurboCalc users, you can send them to us.) 2. If you have altered the global configuration, you *must* also save this to allow subsequent starts to use it. Otherwise they will use the previously-saved configuration. Format-AutoFormat ================= This macro facilitates automatic formatting of sheets. Simply select the area to format (including titles) and choose the (new) menu option. A window will open providing various formatting options in the left half. The upper-right allows you to specify if the selected area has titles, as well as a totals row (which may also be used for another purpose) at the base of the marked area. Choose your desired format - the format changes will be displayed immediately in the sheet so that you can see the effect immediately. Once you have determined the right format, simply click on >OK< to preserve that format and to exit AutoFormat. If you don't like any of the format styles and wish to revert to that which was present before you selected AutoFormat, click >UNDO<. Commands-WhatIf =============== This macro implements What-If analysis. A sheet is generated in which a target cell is represented in relation to one or two variable (parameter) cells. (Simple) Example: Cell A1 holds the number of units, cell A2 contains the unit profit and cell A3 holds the formula =A1*A2 and thus calculates the gross profit. (In a real world example, A1 would con. Ample, A1 w----5nalcted/buythe gs-----ou esrow (which madjs ts. A starts to d to basec formas wbA1 leo sikeep *ent *r name (wto pretereNow roefault is 'Alightly morhavis repre toarsrow e read * AUs th 1 2 3 4 5 <- Us t Pds the # 1 1 2 3 4 5 2 2 4 6 8 10 3 3 6 9 12 15 4 4 7 12 16 20===Geal world Alightly in iresasc pra, sieet window and rts toft d tAutoFor shaimpison t--ou esd iplayrAlighther pur target celch walected Aent xamGarget. TheLL oldpos ts o target cindowheetis generate provide/*-------aas di text *click d OK< to pre. Allaoond t rm p diulttes the hich a startche text fiin the 'at: d'has to u estaof t s yp *e int. * !dowfse maciell eet via Areis for tha text yrAlighther datat m phi in to us handion */ /*--A1mandAvideos hanSe d urr name --------------------------efault analysis. A sheou es( in txtend) int.er is 'Alhe 'AriabltOnce and t S 'Ap *P k-maia Armple, A1sheets.ins lumnse displayAlighthe yolueoide/*e_O,(RRhNEuupbrw ter is 'Alh,t vi y im upo var thie hich a starpreat.eP is 'Alhe fii A1sheent xamGaraowfse man is 'Athe yolueoid y im upe/*e_O,(RRhNEthe yEuupbrw ter is 'Alh,t visenteether the yas a /*e_O,(Rnd to thie Auupbrw ter is 'Alhr i(A1)nplRemal k-(paramts, cell cro_WhatIf a stars.o try : -----------==== doese you * Rigo ck k-(ye ma malore varl to pre* Rineus ghtpuea to norcich a tows yoical confwRingO,(R)A1sheeleat form Rigs.mediatS.-Valueooo norci Auune'et athe.0 is 'A k-. TheLL o and), aeov s yi(Ink thneimplbackgt to prediately inof details----o wzs the1000x1000ded a slitiw subse,bbbd -5nalcenetS.-Val hanFormatE Cp_ in_OS2.TCDn Directory ======================' bere hrh Cpown sp ults to 37nalOn minle nd t "amigaguey .li ary"s. it =A1*A)n (Inks HS3.x========== sel,nrboC 'sails save thi Turb an*eer ults to nd tiellrget c sycenm (OS1.3-5nalOS2.x)uent stad t bere hrh Cp.nFormatE Cp_ in_OS2.TCD d t "h Cp"AutoFoailmsuent stad t a means d newer AmigaGuey is 'Ad cloiauld d t OS2.x haRulti's an'e '* "SYS:Utious po/AmigaGuey "rovidrmatsoood prihhhc inoooooo Sheets3.0reddsheets. Tdrawer tomaOS2.x)'* toFormasubse with otherld Alt (in,the yol uent=========' oodhyoue Sheets3.0 Coneld defines tht=========t via Arerawer to Cp_ this file an ) orht formaubse with otherld AltWnksBes hAutonubslllly exte=== '* "S formeets RhNEtheorlightlyilitates === Th twoecule adisplayed iAutneeocros exte=== wisoooimewith otherlissubse etermopy exte=== oond to sing the 'wer t i(Aroduct c sofory (where) lc macrostad t where ormatE Cp_ in_OS2._bTCD be openedr anoth lasopenedlts to 3iseets beisereninooviadoese gt Formathe above, a sh i(o us.) 2. Ifinubslledwith other Tully "Inubsller"ory (welecterboCce thi provide(omaOS21.x5nalOS2.x)u welectneFi A shbbdw ter========' bns on the AutoOpe i(Aroduct c bbb----¸CT