{S:X;X;0;2;This document is to help PipeDream users get the most out of Resultz.}
{S:X;X;0;3;To make Resultz load a PipeDream file, all you have to do is drop the PipeDream file on the Resultz icon, then the choose the template required.}
{S:X;X;0;4;Spreadsheet files}
{S:X;X;0;5;Resultz is not PipeDream. Resultz has been designed from scratch to be the most advanced spreadsheet program available for RISC OS. Many Resultz users will have used PipeDream. This document introduces the features of the Resultz speadsheet which will be new to PipeDream users.}
{S:X;X;0;6;Page layout. Resultz' page layout facilities go far beyond any other spreadsheet program available on the Archimedes, or Windows or Macintosh. }
{S:X;X;0;7;The spreadsheet window is page-based and completely WYSIWYG. Just like a DTP system you see the pages exactly as they will print. You can have multiple views and scaled views. Columns are split across pages so that you can see exactly what will appear on each page. The Paper dialogue box enables you to match your paper size on screen to the printer driver settings with a single click, or you can specify your own paper sizes. You can work in either portrait or landscape on screen\\\; landscape probably enables that last column to fit!}
{S:X;X;0;8;We believe that Resultz (and Resultz) are unique in enabling you to change column widths at any point down the spreadsheet. Usually spreadsheets constrain you to using the same set of column widths at the bottom of the document as you used at the top. There is no such constraint in Resultz. Plenty of examples using this are provided in the spreadsheets on this disc.}
{S:X;X;0;9;User interface. The user interface has been designed to be as simple and direct as possible. The button bar at the top of the window gives access to the most frequently used commands. }
{S:X;X;0;10;The status line provides interactive help about Resultz and your spreadsheets. Descriptions of all Resultz' functions and their parameters are provided.}
{S:X;X;0;11;Formula line. Function entry is much slicker than PipeDream: if you enter the function from the function selector you get automatic parameter help and pasting. When entering cell references and ranges in the formula line, they are given a soft selection so that clicking several times overrides the previous references, but typing will insert after the references. Try it, it's easier to use than to describe!}
{S:X;X;0;12;Auto sum enables you to create totals with just a click on the button. Other RISC OS spreadsheet programs merely use the auto sum button to insert an empty sum() on the formula line. Resultz will do that if you wish, but if you make a selection of cells with blank cells in the last row or column, then a click on the auto sum button will create the complete sum() formula, including cell references, and insert it into the cell.}
{S:X;X;0;13;The style editor enables you to make styles which can be applied at any level from a single character up to the whole document. Unlike in other spreadsheet programs, they can also be layered, just like in Wordz and Impression. Styles can contain a wide range of attributes, from font sizes and colours to grid styles, horizontal and vertical justification. Styles can be used to predefine areas of the sheet. You can specify that cells should become either text cells or number cells when you type data into them, or that a column should be left-aligned or in a different font.}
{S:X;X;0;14;Styles are a very important and powerful feature of Resultz. Using them will enable you to build better looking documents more quickly.}
{S:X;X;0;15;Protection is provided as a style attribute. It is probably best used by setting up a style containing just protection and applying it to cells. You may want to add a background colour to the style in order to see the protected areas.}
{S:X;X;0;16;Number/date formats can be specified as part of a style. You can provide styles specifying different numbers of decimal places, or a percentage style, or even roman numerals.}
{S:X;X;0;17;Gridlines of different thicknesses, line styles and colours can be drawn around cells using the Box command.}
{S:X;X;0;18;Templates are files from which you can start new documents. The Save Template command will place your document in the templates directory (!Resultz.User.Templates). When you click on the Resultz icon a menu of templates appears for you to select. You can also use Save Template to save out styles to copy into other documents.}
{S:X;X;0;19;When creating a chart, it is automatically placed inside your spreadsheet document. So saving and printing the spreadsheet saves and prints the chart too, with no extra work. This makes it much easier to manage charts in Resultz than in any other RISC OS spreadsheet program. Examples of charts are provided in the charts directory.}
{S:X;X;0;20;New functions}
{S:X;X;0;21;age subtracts one date from another and returns the result as a date. This is useful for calculating someone's age in terms of years and months.}
{S:X;X;0;22;bin counts the frequencies of classes of data. The output can be used as the input to a histogram and an example of this is given in the Charts directory of the examples disc.}
{S:X;X;0;23;counta counts the number of elements in an array or range}
{S:X;X;0;24;dayname returns a string of the dayname, the day being given as a number. eg dayname(weekday(today))}
{S:X;X;0;25;flip turns an array upside down}
{S:X;X;0;26;formula_text returns as a string the formula in another cell. This can be used to annotate spreadsheets, to show what formulas were used to produce the results. It is a way of printing both the results and the formula at the same time.}
{S:X;X;0;27;listcount takes an array or range of data and produces a list of all the unique elements plus their frequencies. An extension takes values for each element and adds the values together. }
{S:X;X;0;28;median returns the median value of a range or array}
{S:X;X;0;29;monthname: as dayname. eg monthname(month(today))}
{S:X;X;0;30;page returns the page number (x or y) of a cell}
{S:X;X;0;31;pages returns the number of pages (x or y) in the document}
{S:X;X;0;32;rank returns an array of rankings from an input array}
{S:X;X;0;33;sort sorts an array on a given column}
{S:X;X;0;34;spearman calculates the Spearman correlation co-efficient from two ranked arrays. The arrays can be ranked using the rank function.}
{S:X;X;0;35;text takes a number and a number format (identical to those in style editor) and returns a string of the formatted number}
{S:X;X;0;36;Function enhancements}
{S:X;X;0;37;lookup has been extended. An optional fourth parameter set to 1 provides two extra types of information to be returned: (i) all occurrences which match the key are returned, rather than simply the first, (ii) for each match a whole record can be returned, rather than just a simple value.}
{S:X;X;0;38;set_value has been extended. Optional third and fourth parameters specify an offset in an array. This enables you to write to a single element in an array.}
{S:X;X;0;39;After you've loaded the file}
{S:X;X;0;40;When the PipeDream file has been loaded, it will probably look quite different to how it looked in PipeDream. The rows may look quite deep and headings and text may have "wrapped" to take up several lines within each cell.}
{S:X;X;0;41;Column widths}
{S:X;X;0;42;Most of the problem is solved by changing the column widths to match the data better. You can try double-clicking with the Select button on the column borders. If the data in the columns is quite short, Resultz will auto-width the columns and so make the columns the widths of the longest cell. If there are cell-entries which are very long, Resultz will not apply the auto-width.}
{S:X;X;0;43;The Heading}
{S:X;X;0;44;A particular problem may be the heading at the top of the document. PipeDream uses overlap to display headings. Resultz doesn't have overlap: instead, it enables you to change the widths of any cells at any point. In the case of a heading, you probably have a single cell which you want to expand over the whole page width. }
{S:X;X;0;45;The best way to tackle this is to use Resultz' straddling command. Select the cell containing the heading, and the cells to the right of it which you want the heading to straddle. Point at the column border between the column letters. When the pointer changes shape to become two vertical lines with arrows pointing left and right, double-click with the Adjust button on the mouse. The leftmost cell will expand to the right over the other cells and these other cells will be shrunk down to nothing.}
{S:X;X;0;46;Landscape}
{S:X;X;0;47;You will notice that after a few columns, you get a page-break and the new columns appear on a new page to the right. If you decide you would like more columns to the page you can either shrink the column widths to fit, or you can use the Paper dialogue box to set the paper orientation to landscape. This gives you a wider page (more columns) which is less deep (fewer rows). Whilst in the Paper dialogue box, click on the Read printer button.}
{S:X;X;0;48;If you're not going to print out the spreadsheet, you can choose the None button in the paper dialog box which will give you infinite paper.}
{S:X;X;0;49;Formulas}
{S:X;X;0;50;Almost without exception, Resultz will understand and evaluate PipeDream formulas identically to PipeDream. The differences are:}
{S:X;X;0;51;hlookup, vlookup. The target range is now two-dimensional and includes all of the rows and columns which can be used as the offset. An example of this will clarify:}
{S:X;X;0;52;Suppose you want to look for the value 42 in cells A1 to A100 and return the corresponding element from column C. }
{S:X;X;0;53;{ITT-X}In PipeDream the syntax would be vlookup(42, A1A100, 2)}
{S:X;X;0;54;{ITT-X}In Resultz the syntax would be vlookup(42, A1C100, 3)}
{S:X;X;0;55;In Resultz we include all of the possible offset ranges in the target range (even though the key is only looked for in the first column/row). The offset number given is the column (or row) within the target range.}
{S:X;X;0;56;choose has changed so that any range parameters are treated as single elements. So choose(3, 1, A1A3, 6) will return 6 rather than A2. choose(2, 1, A1A3, 6) will return the contents of A1A3 as an array.}
{S:X;X;0;57;The trig functions acs, asn, atn have been renamed as acos, asin and atan in keeping with standard spreadsheet terminology.}
{S:X;X;0;58;External references}
{S:X;X;0;59;Resultz has similar external references to PipeDream. It also keeps track of which files are grouped together and if you attempt to close one file in a group, Resultz will prompt you to close all the files in the group. This makes loading and saving linked spreadsheets rather easier.}
{S:X;X;0;60;If you load a PipeDream file containing external references, Resultz will not immediately be able to find the supporting files. This is because Resultz will not use the PipeDream file's path, but create a new filename of the form Sheet1. the best approach to getting the linked spreadsheets working with Resultz is:}
{S:X;X;0;61;(i){ITT-X}copy all of the linked spreadsheets into a new directory, retaining the old directory containing the PipeDream set if you need to refer back to them.}
{S:X;X;0;62;(ii) {ITT-X}load each file in the new directory individually and save it back into the new directory using the existing PipeDream name.}
{S:X;X;0;63;(iii) {ITT-X}when all of the files have been loaded and saved you will find that loading the dependent document will automatically load the supporters.}
{S:X;X;0;64;Custom function sheets, being supporting documents, work in exactly the same way.}
{S:X;X;0;65;Loading large files}
{S:X;X;0;66;Please make sure you have read the information in the main Readmemore file about loading and converting of PipeDream files.}
