APPLICATIONSBUREAUTIQUE ★ Scratchpad Plus ★

Scratchpad Plus|Amstrad Action)Applications Bureautique
★ 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 ★ 

It's not easy to get excited about spreadsheets. While they are enormously useful things, they rarely involve dazzling new ideas. Now, however, Caxton have brought out ScratchPad Plus, a powerful program with many original features. It may not quite be exciting, but it's probably as close as you're going to get.

If you want to create a big spreadsheet, Scratchpad can cope. In fact, it can give you a larger spreadsheet than any other package on the market. If you want to look at several parts of the sheet at once -and you probably will - ScratchPad lets you. If you're after powerful, versatile functions, ScratchPad gives them to you.
These features are impressive, but they don't come cheap. At a penny less than £70, it's really not the sort of thing you'd buy for your domestic budgeting. That said, it is very easy to use and - price to one side - you certainly could do your home accounts on it. As for small businesses and the like, it should prove ideal. After all, you do get a great deal for your money.

VIRTUAL MEMORY

ScratchPad Plus is big - the main program SP.COM takes up 49K of disc. The sheer size of it means it's CP/M Plus only. Even then, you're only left with 12K of RAM for the spreadsheet data. How then, you might well ask, can ScratchPad give you a larger spreadsheet than any other program?

It's all done with virtual memory. This involves using disc space to store data while the program is running. In this way, the spreadsheet is notlimited by the amount of free RAM. Once all this is used, ScratchPad starts expanding into the free space on your disc. This does have to be space on your working copy of ScratchPad, but that's not an enormous restriction in theory, you could still create spreadsheets weighing in at over 120K.

Of course, there is a price to be paid for all this - and I don't just mean £70. The trade-off is one of size against speed. Retrieving data is much slower from disc than it is from RAM. With auto-calculation running, the change in speed is quite noticeable and potentially rather annoying. The answer here is to switch auto-calc off, and simply force recalculation when needed. This is, after all, what you have to do anyway with most spreadsheet packages. A more satisfactory solution would be ramdisc.

The idea of ramdisc is explained rather more thoroughly in the Silicon Disc review in this month's Plug-Ins, but here's the gist of it. You take a piece of RAM, make it pretend it's a disc and run virtual-memory programs on it. That way you get extra memory and extra speed - which can't be bad. Unfortunately for 6128 users, the DK'tronics Silicon Disk won't do the job -though the Vortex boards might be able to, at a price. Those lucky 8256 users have a built-in 112K RAM disk which really gets ScratchPad running at a cracking pace. The 8512 will be able to offer all this plus even greater capacity - 368K on ramdisc.
 
SPREADSHEETS

If you do all your financial planning on paper, you'll find some tasks very difficult. In particular, you'll have problems making "what if...?” calculations. If you're doing the planning for a small business, you're going to want to know the answers to questions like “What if component prices go up?” or "What happens if I become liable for VAT?”. If you want answers to this sort of question, you're going to need a spreadsheet program.

A spreadsheet is made up of cells, arranged in rows and columns. Each cell can contain a label, eg "Profits for January", or a formula. The formula in a cell is the way that the program works out what number to display in that cell on the screen. It could just be a number, or it could be a sum which the program can do to produce a number.

Thus if cell B1 - that means it's the cell in column B and row 1 - has the formula " 10”, then it will simply display as the number 10. If we then set the formula for B2 as “B1+5” then B2

will display as 15 - the contents of cell B1 , plus 5. If we then alter B1's formula to 㥷” and recalculate - update all the cells according to their formulae - B2 will now display 16, not 15 as previously.

Using these formulae, we can set up a financial plan without having to do the totalling of costs, multiplication by profit margins etc. More importantly, you can make small "What if...?” alterations, and then recalculate the whole sheet to show their full effects.

DIMENSIONS

With all this talk of 120K spreadsheets, it may come as a surprise to you that each sheet can have a maximum of only 5000-odd cells. Before you start making unfavourable comparisons, however, bear in mind a couple of points.
Many spreadsheet packages can show similar statistics, but very few have the memory to fill that many cells usefully. Furthermore, the cells of a Scratchpad spreadsheet can be distributed however you like - the dimensions of the sheet are entirely up to you. If you need 5 columns and 1000 rows, or vice versa, Scratchpad can handle this quite easily.

Putting these two factors together, the maximum number of cells is, unlike with so many packages, a practical limitation but only if you need a sheet with an enormous number of columns and rows. Oddly enough, the package nearest to Scratchpad in memory terms - Campbell's Mastercalc 128 - is also the only one of its major competitors to offer the same sort of flexibility over spreadsheet shape.

WINDOWING

One of the most important features of Scratchpad Plus is its multiple windowing. The major drawback of a computer spreadsheet compared to its paper equivalent is the display size - you can only see a very small portion of the total display at any one time. Often, the critical areas you need to look at are small - typically just one cell each - but a long way apart. To make the most of the display size, you need to be able to divide it between these areas. On most spreadsheets your display can only look at one continuous area of screen. A few allow you to divide the screen into two windows - two sections of the screen which show separate parts of the spreadsheet.

In contrast to this, Scratchpad Plus gives you unlimited windowing. You can split the screen into two separate windows either horizontally or vertically. These windows can then be subdivided, and so on for as long as you like. There is a limit to the number of windows you can have on screen, but only the purely practical one of screen space. Each new window needs column and row markers, and these take up space otherwise used for cells. Eventually, the screen will become too cluttered for further subdivision. By this time there will already be too many windows for you to keep track of them all, so the limit isn't much of a restriction in practice.

Each window behaves like a screen in miniature. It can be scrolled and the entries edited quite independently of the other windows except, of course, for the effect any editing may have on the spreadsheet. This, coupled with the ability to jump from window to window, gives you more direct access to the spreadsheet than any other program on the market.

FORMULAE AND FUNCTIONS

When it comes to calculation. Scratchpad really starts to show its worth - the range of commands available to you is simply phenomenal. From simple arithmetic you can move on to trig, and scientific functions, table lookups, and an if-then structure that brings in a strong flavour of programming.

Other useful features available include the ability to sum over a range of cells in the same row or column, without having to write formulae of the "A3 + A4 + A5 + ...” variety. Also worth a mention are the average, maximum and minimum functions which add considerably to the package's flexibility.
Thankfully, applying this battery of functions is made a great deal easier by an intelligent set of replication instructions. Formulae can be transferred as wholly absolute, wholly relative or a range of options in between. In effect, this means that concepts can be copied from one part of the sheet to another, cutting out an enormous amount of drudgery and general hard work.

DOCUMENTATION

This program packs a real punch - it can create and manipulate huge spreadsheets, give you powerful tools for structuring them and easy access to the results they yield. All of this clearly needs some pretty strong documentation, and Caxton have given it just that.
The manual is friendly, clear and concise. It is backed up by good onscreen help, a useful little prompt card and, when all else fails, a support team on the other end of the phone. If the documentation is lacking anywhere, it is in the area of examples. ScratchPad is very versatile for a spreadsheet, and a few suggested applications for the more unusual features would not have gone amiss.

The Verdict

There being disconcertingly little to find fault with, the only question mark remaining is over value for money. At £20 more than Supercalc 2 and almost twice the price of Mastercalc 128, you'll have some hard thinking to do justifying the expense. Above all, you'll have to really need that extra power and capacity.

AMSTRAD ACTION

★ PUBLISHER: CAXTON SOFTWARE
★ YEAR: 1985
★ CONFIG: 128K - Amstrad CPC 6128/PCW 8256 (CP/M+)
★ PRICE: £69.99
★ LANGUAGE:
★ LICENCE: COMMERCIALE
★ AUTHOR: ANDREW WILTON

★ AMSTRAD CPC ★ DOWNLOAD ★

Adverts/Publicités:
» Caxton-ScratchPad  Plus    ENGLISHDATE: 2017-06-17
DL: 22 fois
TYPE: image
SIZE: 170Ko
NOTE: Uploaded by hERMOL ; w796*h1158

» Scratchpad  PlusDATE: 2015-01-08
DL: 85 fois
TYPE: image
SIZE: 323Ko

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 » Amslettres (CPC Revue)
» Applications » Sales Ledger
» Applications » Write right!
» Applications » Brunword
» Applications » Flash
» Applications » Applications bureautique

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 079 millisecondes et consultée 705 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.