APPLICATIONSDIVERS ★ THE CRACKER ★

The Cracker|Amstrad Action)Applications Divers
★ Ce texte vous est présenté dans sa version originale ★ 
 ★ This text is presented to you in its original version ★ 
 ★ Este texto se presenta en su versión original ★ 
 ★ Dieser Text wird in seiner Originalfassung präsentiert ★ 

If I told you The Cracker was a spreadsheet, you'd probably start thinking of it as a financial tool. Well, it is a spreadsheet -but normal budget calculations don't even scratch the suface of it's capabilities. It is intended to bring spreadsheet power to maths, scientific and statistics applications.
Right from the word go, it's obvious that The Cracker is unusually complex for a spreadsheet. You can't just start filling in the sheet, because there isn't one at first. You have to create the sheet from scratch, adding columns and lines as you see fit. For each column you'll have to specify the width you want it to be, and the default data type you want each cell to contain. This gives you a great deal of control over the layout of the sheet, but is far too long-winded for simple budgeting or the like.

COMMANDS

Single letter commands are used to control and manipulate the sheet, but as you enter them Cracker displays the meaning of the commands in plain English. Thus, if you type "NF6E" the command line displays "New Format to be 6 sig figs Exponent". This translation comes up as you type the line, the idea being to let you spot mistakes even before you've hit return.

This prompting philosophy is carried right the way through The Cracker. At every stage of the command process, all possible keypresses - including the return key, where appropriate - are displayed above the command line. When you're entering formulae, errors are reported immediately they are noticed - which usually means before you've hit return.

Error messages are usually specific and helpful. If you try entering the nonsense formula "2/+ 2" Cracker will beep when you type the plus sign, and display the message "Separate these operators". There is even an error message - "outside worksheet" - to cover attempts to move the cursor off one edge of the sheet. This could be taking things a little far I feel, but it's certainly a fair indication of the program's thoroughness.

EXPRESSIONS

This certainly shows a novel approach, but it's in its expressions vocabulary that The Cracker really shows originality. Most spreadsheets can manage numerical operators, trig functions and perhaps a little statistics. Scratchpad Plus went a good deal further than this, even coming close to programming with its IF...THEN construction - but The Cracker can beat this without even trying.

Cracker formulae can include pi, e, logs, perms & combs, random numbers, Booleans, interpolations and just about anything else you could ask for in the mathematical line. They can alter the contents of other cells quite freely, and the DO...WHILE construct gives them true program status. Logs can be natural or base 10, while angles can be in degrees or radians.

Though there are a few functions of a financial nature, it should be clear from the above that the intended market is scientific, engineering and mathematical. The fact is, spreadsheets have always had the potential to serve as valuable tools in these fields, held back only by the lack of the necessary expressions. Another strong feature which it shares with SuperCalc 2 is the ability to sort rows and columns either numerically or alphabetically. This means the program can be adapted for use as a small database, and can be extremely powerful in applications where both calculation and sorting is required.

APPLICATIONS

Quite what you do with a flexible tool like The Cracker is very much up to your imagination. The manual suggests using it to solve simultaneous equations, and similar problems, iteratively. This can be done either by forced recalculation or by the use of DO...WHILE loops - it's up to you. There isn't quite the numerical range that you'd get from a scientific calculator -you're limited to plus or minus 1E38 - but accuracy to twelve decimal places will probably make up for this.

The sheet format is so variable that normal measures of maximum size don't mean a great deal. The best yardstick is probably free memory, and that runs to just under 17K on both the PCW machines and the 6128. That may sound a bit thin, but it's probably more than adequate for its intended applications, especially as the memory is used efficiently. While a financial spreadsheet needs to mundane things to vast quantities of data, The Cracker can do very impressive things with smaller quantities - and that's exactly what you need for mathematical purposes.

Working entirely in memory, the program is fast even in auto-calculation mode. Of course, any really time-consuming number crunching can be left running in a DO...WHILE loop while you go off and make a cup of tea.

DOCUMENTATION

The manual is well presented and clearly written. It falls into two parts, a tutorial and a reference section. The tutorial is friendly and straightforward, with a wealth of examples and screen diagrams to help clarify things. The reference section is thorough and well set-out. This is just as well, for I suspect that the typical Cracker user will feel more at home with a reference section than a tutorial.

AA

★ PUBLISHERS: Software Technology / New Star Software
★ YEAR: 1986
★ CONFIG: 128K + PCW + CP/M
★ LANGUAGE:
★ LICENCE: COMMERCIALE
★ AUTHOR(S): ???
★ PRICE: £49.00 disk

★ AMSTRAD CPC ★ DOWNLOAD ★

Je participe au site:
» Newfile(s) upload/Envoye de fichier(s)
★ AMSTRAD CPC ★ A voir aussi sur CPCrulez , les sujets suivants pourront vous intéresser...

Lien(s):
» Applications » Textverarbeitung Unter Cpm Plus (CPC Amstrad International)
» Applications » Introduction à G.S.X (CPC Revue)
» Applications » Comment Utiliser un Logiciel (CPC Revue)
» Applications » Initiation à CP/M: CP/M et le CPC devient PRO (Amstrad Magazine)
» Applications » CP/M Plus System Utilities Disc for the 6128 plus
» Applications » Initiation à CP/M : Le CP/M sur CPC 6128 (Amstrad Magazine)

QUE DIT LA LOI FRANÇAISE:

L'alinéa 8 de l'article L122-5 du Code de la propriété intellectuelle explique que « Lorsque l'œuvre a été divulguée, l'auteur ne peut interdire la reproduction d'une œuvre et sa représentation effectuées à des fins de conservation ou destinées à préserver les conditions de sa consultation à des fins de recherche ou détudes privées par des particuliers, dans les locaux de l'établissement et sur des terminaux dédiés par des bibliothèques accessibles au public, par des musées ou par des services d'archives, sous réserve que ceux-ci ne recherchent aucun avantage économique ou commercial ». Pas de problème donc pour nous!

CPCrulez[Content Management System] v8.7-desktop/cache
Page créée en 080 millisecondes et consultée 897 fois

L'Amstrad CPC est une machine 8 bits à base d'un Z80 à 4MHz. Le premier de la gamme fut le CPC 464 en 1984, équipé d'un lecteur de cassettes intégré il se plaçait en concurrent  du Commodore C64 beaucoup plus compliqué à utiliser et plus cher. Ce fut un réel succès et sorti cette même années le CPC 664 équipé d'un lecteur de disquettes trois pouces intégré. Sa vie fut de courte durée puisqu'en 1985 il fut remplacé par le CPC 6128 qui était plus compact, plus soigné et surtout qui avait 128Ko de RAM au lieu de 64Ko.