{S:X;X;0;3;Resultz contains a PipeDream file loader. You can drop a PipeDream file onto the Resultz icon, and Resultz will load it. }
{S:X;X;0;4;Loading}
{S:X;X;0;5;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;6;Column widths}
{S:X;X;0;7;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;8;The Heading}
{S:X;X;0;9;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;10;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;11;Landscape}
{S:X;X;0;12;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;13;Formulae}
{S:X;X;0;14;Almost without exception, Resultz will understand and evaluate PipeDream formulae identically to PipeDream. The differences are:}
{S:X;X;0;15;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;16;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;17;{ITT-X}In PipeDream the syntax would be vlookup(42, A1A100, 2)}
{S:X;X;0;18;{ITT-X}In Resultz the syntax would be vlookup(42, A1C100, 3)}
{S:X;X;0;19;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;21;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;22;The trig functions acs, asn, atn have been renamed as acos, asin and atan in keeping with standard spreadsheet terminology.}
{S:X;X;0;23;External references}
{S:X;X;0;24;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;25;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;26;(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;27;(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;28;(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;29;Custom function sheets, being supporting documents, work in exactly the same way.}
{S:X;X;0;31;Loading large files}
{S:X;X;0;32;Loading very large PipeDream files may take a long time. The following describes why and what to do about it.}
{S:X;X;0;33;Each cell (slot) from the PipeDream file is examined to determine whether it is a number cell or a text cell. If it is a text cell, Resultz applies the Text cell style to the cell so that it is displayed left-justified. (Making a change to the text cell style will apply that change to all the text cells in the document.) }
{S:X;X;0;34;When a style is applied to something in the worksheet, a region is created. The region consists of the area (the cell in this case) to be displayed in that style, and the name of the style. Each new region is added to Resultz' region list. Resultz will merge together adjoining or overlapping regions in order to keep the region list as small as possible and so that "holes" don't appear in the regions in your spreadsheets.}
{S:X;X;0;35;A typical large spreadsheet has columns of text cells. Many of the cells in these columns may be blank. The blank cells in the PipeDream files won't be put in the text style and so the region list may become very large and fragmented. It is this which causes the loading of very large PipeDream files to be slow. You may notice that the percentage indicator starts off quickly and slows down towards the end. This is a symptom of the region list becoming large.}
{S:X;X;0;36;Files with large region lists will cause Resultz to slow down during editing and subsequent loading and saving, and will take up much more memory, so it is best to reduce the region list. You can tackle the problem more easily after the PipeDream file has loaded. Identify the columns which contain only text cells and blanks, select the whole column by double-clicking on the column border, and apply the text style to it. Applying the style over the whole column will swallow up all the Text regions which are contained in that column.}
{S:X;X;0;37;Alternatively you can tackle the problem before loading the PipeDream file, if you think about it in time! Do the following:}
{S:X;X;0;38; 1.{ITT-X}In this directory you will find a template called PDLoader which is the standard Sheet template but with the Text style deleted. Double-click on it to start a new document. }
{S:X;X;0;39;2.{ITT-X}Drag the PipeDream file in to the window to load it.}
{S:X;X;0;40;3.{ITT-X}You will also find a template called Text in this directory. Drag this into the window. This adds the Text style to the document.}
{S:X;X;0;41;4.{ITT-X}Apply the text style to areas of text cells. }
