{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Guide","Colours","Preferences","Control","Temp"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":60,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guide","index":0,"n_rows":707,"n_cols":2,"rows_kept":707,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Rainbow User Guide"]
[]
[null,"User Guide Contents"]
[]
[null,"If you have turned off in-cell editing, you can double-click any of the items immediately below to go to the relevant heading."]
[]
[null,"Row     Heading"]
[null,{"$f":"TEXT(ROW($B$48),\"000\") & \"      \"&$B$48","v":"048      Quick Start Guide"}]
[null,{"$f":"TEXT(ROW($B$82),\"000\") & \"      \"&$B$82","v":"082      The Standard menu"}]
[null,{"$f":"TEXT(ROW($B$111),\"000\") & \"      \"&$B$111","v":"111      The Advanced menu"}]
[null,{"$f":"TEXT(ROW($B$136),\"000\") & \"      \"&$B$136","v":"136      Helpful hints"}]
[null,{"$f":"TEXT(ROW($B$152),\"000\") & \"      \"&$B$152","v":"152      Rainbow functions in detail"}]
[null,{"$f":" TEXT(ROW($B$156),\"000\") & \"            \"&$B$156","v":"156            Quick Clean-Up"}]
[null,{"$f":" TEXT(ROW($B$164),\"000\") & \"            \"&$B$164","v":"164            Delete Comments"}]
[null,{"$f":" TEXT(ROW($B$170),\"000\") & \"            \"&$B$170","v":"170            Clear Formats"}]
[null,{"$f":" TEXT(ROW($B$180),\"000\") & \"            \"&$B$180","v":"180            File Save As"}]
[null,{"$f":" TEXT(ROW($B$184),\"000\") & \"            \"&$B$184","v":"184            Reset Reports"}]
[null,{"$f":" TEXT(ROW($B$192),\"000\") & \"            \"&$B$192","v":"192            Save Format"}]
[null,{"$f":" TEXT(ROW($B$200),\"000\") & \"            \"&$B$200","v":"200            Undo Changes"}]
[null,{"$f":"TEXT(ROW($B$206),\"000\") & \"            \"&$B$206","v":"206            Summary Report"}]
[null,{"$f":"TEXT(ROW($B$224),\"000\") & \"            \"&$B$224","v":"224            Logic Map"}]
[null,{"$f":"TEXT(ROW($B$253),\"000\") & \"            \"&$B$253","v":"253            Inter-Sheet Logic"}]
[null,{"$f":" TEXT(ROW($B$271),\"000\") & \"            \"&$B$271","v":"271            Names Toolbox"}]
[null,{"$f":"TEXT(ROW($B$307),\"000\") & \"            \"&$B$307","v":"307            Data Links"}]
[null,{"$f":"TEXT(ROW($B$311),\"000\") & \"            \"&$B$311","v":"311            Data Explorer"}]
[null,{"$f":"TEXT(ROW($B$337),\"000\") & \"            \"&$B$337","v":"337            Macro Explorer"}]
[null,{"$f":"TEXT(ROW($B$349),\"000\") & \"            \"&$B$349","v":"349            Formula Groups"}]
[null,{"$f":"TEXT(ROW($B$367),\"000\") & \"            \"&$B$367","v":"367            Risk Map"}]
[null,{"$f":"TEXT(ROW($B$487),\"000\") & \"            \"&$B$487","v":"487            Cell Inspector"}]
[null,{"$f":"TEXT(ROW($B$501),\"000\") & \"            \"&$B$501","v":"501            Comparison Toolbox"}]
[null,{"$f":" TEXT(ROW($B$543),\"000\") & \"            \"&$B$543","v":"543            Graphics Report"}]
[null,{"$f":" TEXT(ROW($B$547),\"000\") & \"            \"&$B$547","v":"547            Comments Report"}]
[null,{"$f":" TEXT(ROW($B$551),\"000\") & \"            \"&$B$551","v":"551            Sample Data"}]
[null,{"$f":"TEXT(ROW($B$563),\"000\") & \"            \"&$B$563","v":"563            Find Colours"}]
[null,{"$f":" TEXT(ROW($B$571),\"000\") & \"            \"&$B$571","v":"571            Colour Chart"}]
[null,{"$f":"TEXT(ROW($B$585),\"000\") & \"            \"&$B$585","v":"585            Logic Colours"}]
[null,{"$f":"TEXT(ROW($B$591),\"000\") & \"            \"&$B$591","v":"591            Format Editor"}]
[null,{"$f":" TEXT(ROW($B$611),\"000\") & \"            \"&$B$611","v":"611            (Un)Hide/Protect"}]
[null,{"$f":" TEXT(ROW($B$621),\"000\") & \"            \"&$B$621","v":"621            User Guide"}]
[null,{"$f":" TEXT(ROW($B$625),\"000\") & \"            \"&$B$625","v":"625            Rainbow Log"}]
[null,{"$f":"TEXT(ROW($B$639),\"000\") & \"            \"&$B$639","v":"639            About Rainbow"}]
[null,{"$f":" TEXT(ROW($B$643),\"000\") & \"            \"&$B$643","v":"643            Switch Menu"}]
[null,{"$f":" TEXT(ROW($B$647),\"000\") & \"            \"&$B$647","v":"647            Preferences"}]
[null,{"$f":" TEXT(ROW($B$691),\"000\") & \"            \"&$B$691","v":"691            Restore Defaults"}]
[null,{"$f":"TEXT(ROW($B$695),\"000\") & \"      \"&$B$695","v":"695      Installation and licensing"}]
[]
[null,"Quick Start Guide"]
[]
[null,"If you're someone who likes to get straight on with using a product, this \"Quick Start\" section tells you the key things you need to know to get the best out of Rainbow's spreadsheet error visualisation capabilities, which are all available when you click the Rainbow tab on the Excel \"Ribbon\" menu."]
[]
[null,"When you load Rainbow for the first time, you may see a message saying that Rainbow needs to be able to access Excel's Visual Basic modules in order to create interactive reports and analyse Visual Basic macros. This means that there is an option in Excel's settings that needs to be switched on in order to allow access to Visual Basic. You can switch this on yourself (and you can find the instructions in the Rainbow Log file), but it's easiest to click OK and let Rainbow switch it on for you."]
[]
[null,"To do this, Rainbow will need to briefly close and then re-open Excel. When Excel has re-opened, if you still see a message saying that access to Visual Basic code modules has not yet been enabled, this probably means that you are using a computer in a corporate environment where access to Visual Basic code modules has been disabled. In this case you will need to contact your IT Support function to enable Visual Basic access."]
[]
[null,"Even if this is not possible, you can still use all Rainbow's functions other than the Data Explorer, the Macro Explorer, and the Names Toolbox report. And if you later want Rainbow to try again to switch on access to Visual Basic next time you start up Excel, just click Menu Settings and then Preferences, then select \"Set VB access next startup\", and click Save Defaults."]
[]
[null,"When you first click the Rainbow tab after installing Rainbow, what you will see is Rainbow's \"Standard\" menu. This shows the most important of Rainbow's functions, arranged so as to make it very easy for you to get straight on with using Rainbow in practice. When you want to see the rest of Rainbow's functions, just click the Menu Settings  button and then Switch Menu, to switch to the \"Advanced\" menu."]
[]
[null,"Whether you're using the Standard or the Advanced menu, when you click a button on the menu you'll generally see a dialog box with \"Click OK to …\" near the top. This is Rainbow's guess as to what you want to do, based on your currently selected workbook and worksheet(s)."]
[]
[null,"To change the selected workbook and worksheet(s), click the Selection… button. This will open a box where you can select a different (currently open) workbook and worksheets. Hold down the Shift key to select a range of worksheets, or the Control key to select or deselect individual sheets, or click the Select All button."]
[]
[null,"Most of Rainbow's functions perform one or both of the following actions:"]
[null,"•  Apply colour to specific cells either in the worksheet(s) you have selected or in separate \"map\" worksheet(s) which mirror the structure of your selected worksheet(s);"]
[null,"•  Generate worksheet report(s) listing specific cells or other items, usually with clickable links to the relevant cells, and often with interactive buttons allowing you to view and/or change selected features."]
[]
[null,"You can select which of these actions you want in the Output area of the dialog box (usually under the Selection… button). Some options may not always be enabled (i.e. you can't click on them). For instance if the Report option box is ticked but it is not enabled, this means that the Rainbow function you have selected always generates a worksheet report (i.e. the report can't be turned off)."]
[]
[null,"Most of Rainbow's reports now include a hyperlink on each row (often in the \"Cell\" column) which you can click in order to jump straight to the relevant cell in the workbook you are analysing. To make this easier, Rainbow turns off the warning message that Excel normally displays when a hyperlink is clicked, but if you wish you can set your Preferences (under Menu Settings) to turn this message back on ."]
[]
[null,"If you are using the Advanced menu, you can restore the original colouring of your selected worksheet(s) after  Rainbow has applied its own colours. To do this, you first need to use the Save Format function (in the File Control group). This will save the current formatting of your selected worksheet(s), so that you can restore it afterwards using the Undo Changes function."]
[]
[null,"If you need to stop Rainbow in the middle of running a function for any reason, simply press Esc or Ctrl+Break. Rainbow will stop and will generally let you know which cell it reached in running the analysis. Of course this means that if Rainbow was producing a report, the report will probably be incomplete."]
[]
[null,"As with all the tabs on the Excel \"Ribbon\" menu, there are keyboard shortcuts for the Rainbow tab and all the Rainbow functions; you can see them by pressing and releasing the Alt key. So for instance the quickest way to run the Find Colours function is to press Alt, then Y (for Rainbow), then F (for Find Colours)."]
[]
[null,"That's all you need to know to get started. For full information on how to use Rainbow's various functions, please read the rest of the User Guide (accessible as a worksheet from the User Guide button). To obtain a printed copy of the Guide, simply print it like a normal spreadsheet."]
[]
[null,"Please consult the final section of the User Guide for full information on installing Rainbow, and also for important information on copyright and liability."]
[]
[null,"The Standard menu"]
[]
[null,"Rainbow's Standard menu has five groups of functions: The Basics, The Details, My Files, My Colours, and Help. As the names suggest, it's a good idea to start with The Basics and then move on to The Details and any other functions you need."]
[]
[null,"The two functions in The Basics group are quick and easy to use and can give you a lot of information about a spreadsheet before you go any further:"]
[null,"•  Summary Report gives you a quick overview of a workbook, and lists data for each sheet which can already start to suggest possible problem areas."]
[null,"•  Formula Groups highlights (and reports on) groups of copied formulas, so that you can easily spot inconsistencies and adjustments."]
[]
[null,"In The Details group are two functions which generate colour \"maps\" to help you visualise the spreadsheet calculations, two functions which tell you about external data in the spreadsheet, and the Cell Inspector for examining individual calculations:"]
[null,"•  Risk Map is a powerful analysis tool which can report on up to 28 different types of potential risks, and highlight all the relevant cells in different colours."]
[null,"•  Logic Map gives you a visual picture that helps you quickly grasp the flow of calculation from inputs through workings to final results."]
[null,"• Data Links helps you track down where your spreadsheet calculations are linked to individual cells in another workbook."]
[null,"• Data Explorer tells you where your spreadsheet is using tables of data, and how these are linked to external databases or other sources."]
[null,"•  Cell Inspector is an interactive function which lets you trace the logic of any individual cell at a glance; it is very useful in conjunction with Formula Groups."]
[]
[null,"The My Files group contains three utility functions to help you manage individual workbooks and track changes between different versions of spreadsheets:"]
[null,"•  The functions on the Quick Clean-Up menu let you quickly clean up a workbook, delete any comments or superfluous formats, and then save it as a working copy."]
[null,"•  Comparison Toolbox is a comprehensive comparison function that compares workbooks, worksheets or ranges and offers a key tool for controlling versions and scenarios."]
[null,"•  (Un)Hide/Protect can hide or unhide and protect or unprotect selected worksheets, and also unhide hidden rows and columns."]
[]
[null,"The three functions in the My Colours group let you check the colours in a cell and manage the gallery of colours that Rainbow uses:"]
[null,"•  Find Colours gives you an explanation of the Rainbow colour(s) in the selected cell, and lets you search for other similarly-coloured cells."]
[null,"•  Colour Chart gives you an interactive visual display of all the colours that Rainbow uses to map different types of cells and different groups of formulas."]
[null,"•  Logic Colours provides a quick reminder of the dependency type colours used in a Logic Map, and lets you search for them in the current sheet."]
[]
[null,"And finally in the Help group are two menu buttons that give you access to important information and utility functions:"]
[null,"•  Under the User Guide button, you can view and print this User Guide, view the Rainbow log file, and licence your copy of Rainbow or check the details of your licence."]
[null,"•  Under the Menu Settings button, you can switch between the Standard and Advanced menu, set various preferences, and restore factory default settings."]
[]
[null,"The Advanced menu"]
[]
[null,"Rainbow's Advanced menu has six groups of functions: File Control, Structural Overview, Cell Analysis, Audit Process, Colour Management and Help. Many of the functions have already been covered in the section above on the Standard menu, and here we cover those which appear only on the Advanced menu."]
[]
[null,"The set of functions in the File Control group can help you get set up before you start using Rainbow's analysis tools:"]
[null,"•  Reset Reports lets you tell Rainbow that you want it to put reports in a different workbook from the one it is currently using."]
[null,"•  Save Format records the current formatting of your selected worksheet(s), so that you can restore it again using Undo Changes;"]
[null,"•  Undo Changes lets you restore cell colours and other selected aspects of cell formatting from the last format that you saved."]
[]
[null,"The functions in the Structural Overview group are powerful \"floodlight\" functions, which are probably (along with Formula Groups) the first ones you'll want to use when starting to analyse a spreadsheet:"]
[null,"•  Inter-Sheet Logic generates a tabular matrix that shows you the flow of logic between sheets in your workbook."]
[null,"•  Names Toolbox provides a range of tools to help you audit and control the use of defined names in the workbook logic."]
[null,"• Macro Explorer lets you easily see any macros in the workbook and get a sense of how they affect your workbook data."]
[]
[null,"The three functions in the Cell Analysis group consist of \"spotlight\" functions which zoom in to examine specific cell-by-cell details (though Formula Groups can also be used as a \"floodlight\" function)."]
[]
[null,"The functions in the Audit Process group provide you with further tools that you are likely to need in the process of a spreadsheet audit:"]
[null,"•  Graphics Report and Comments Report let you generate detailed reports on buttons and graphics (e.g. charts), and on comments (cell notes)."]
[null,"•  Sample Data selects a random or periodic sample of data from a worksheet and copies it to a report for further auditing."]
[]
[null,"In the Colour Management group are some utility functions to manage Rainbow's colours and assist with spreadsheet development:"]
[null,"•  Format Editor works in conjunction with other Rainbow functions to enable you to apply formatting changes or convert text to numbers."]
[]
[null,"The final item on the Rainbow tab is the Help group, including (under Menu Settings) the Switch Menu function to switch back to the Standard menu."]
[]
[null,"Helpful hints"]
[]
[null,"As explained in the first section of this Guide, the dialog boxes for most Rainbow functions are basically similar, and (by clicking the Selection... button) they let you select which workbook and worksheets to analyse. Note that if your selected workbook contains hidden or protected sheets, in most cases Rainbow will prompt you to unhide or unprotect them before using Rainbow functions (as otherwise most Rainbow functions may not operate correctly). And Rainbow may select cell A1 for you if your current selection is something other than a normal range (cell), e.g. a chart."]
[]
[null,"The default Preferences settings are to include all Rainbow reports in one report workbook, and for Rainbow to look for currently open report workbooks. So if you want to use a workbook from a previous session, make sure it is already open in Excel when you start using Rainbow. Alternatively you can make use of this feature to append reports as additional worksheets at the back of the workbook you are analysing."]
[]
[null,"Nearly all Rainbow reports (except the Summary Report and Inter-Sheet Logic) are formatted as data tables. This means that you can easily sort them to highlight certain values, or filter them so that for instance they show only results for a specific sheet. And you can change the formatting style of the table using the Styles group on the Home tab in Excel."]
[]
[null,"If you have selected output in the form of a map, Rainbow will include the map worksheet(s) as well as the report in your selected report workbook. As far as possible it will give them the same names as the worksheets they are mapping."]
[]
[null,"Normally Rainbow will look at all cells within the used range of a worksheet. However, if you have selected a range containing more than one cell, it will give you the option to analyse only the selected range. If you have selected one or more columns or rows, it will analyse the column(s) or row(s) within the used range of the worksheet. This can save a great deal of processing time in a large worksheet, if you do not need to analyse every cell."]
[]
[null,"Although Rainbow has been designed to perform quickly and efficiently, in a very large workbook some functions may take many minutes to complete. In this situation the application title (at the very top of the screen) may show \"Not Responding\", or the working area of the screen may go blank. This does not generally indicate a problem; you can confirm that Rainbow is still working away by looking at the progress message in the status bar (near the bottom of the screen). If you do need to interrupt it, just press Esc or Ctrl+Break."]
[]
[null,"If you need help while using a Rainbow function, all functions which generate a dialog box include a Help button which displays the relevant section of the User Guide, and which can also show this Quick Start Guide. And if access to Visual Basic is switched on (as explained above), all Rainbow's reports will also include a Help button at the top right of the report, which will similarly display the relevant section of the User Guide."]
[]
[null,"Rainbow functions in detail"]
[]
[null,"Options which are specific to particular functions are explained in detail below."]
[]
[null,"Quick Clean-Up"]
[]
[null,"The Quick Clean-Up function provides a quick and simple way to prepare a workbook for detailed analysis using Rainbow's other functions. It combines various operations from (Un)Hide/Protect and Format Editor to unhide hidden sheets, unprotect protected sheets, unhide hidden rows and columns, and optionally clear cell colours and patterns. It also selects Normal view (rather than e.g. Page Break Preview) for all sheets."]
[]
[null,"If you would prefer the Quick Clean-Up function to leave cell colours and patterns unchanged, you can set this in your Preferences settings (on the Colours tab), by unchecking the box under Quick Clean-Up."]
[]
[null,"After you have \"cleaned up\" a workbook with the Quick Clean-Up function, you can use the File Save As function to save it under a different name and leave the original file unchanged. You can also use the File Save As function to save the current report workbook under a different name, and Rainbow will then continue to use this for further reports."]
[]
[null,"Delete Comments"]
[]
[null,"With the Delete Comments function you can quickly remove all comments (cell notes) from a workbook. This is particularly useful if you are using the Insert Comments option with the Risk Map function."]
[]
[null,"Before you use Delete Comments to remove any existing comments, you might first wish to list them with the Comments Report function. And after you have used Risk Map with the Insert Comments option, if you decide you no longer need the Risk Map comments, you can simply use Delete Comments again to remove them."]
[]
[null,"Clear Formats"]
[]
[null,"The Clear Formats function removes all custom (i.e. not built-in) styles, and it also attempts to reset the built-in styles to their default values. This can be particularly useful if you receive a \"Too many different cell formats\" error message. This often occurs as a result of copying  or importing worksheets from one workbook into another, because by default Excel also imports all the custom styles from the source workbook."]
[]
[null,"You can run the Summary Report to see how many styles there are in the workbook (in cell B18). Generally there are about 50 basic styles, but when worksheets have been copied or imported many times, the number of styles can increase up to a maximum of 64,000. This can double the size of a workbook and make it very slow to load."]
[]
[null,"Another occasional problem with formatting is that the default \"Normal\" style can become corrupted, in which case your spreadsheet may appear to be full of (for example) dates or currency values. Rainbow will check for this, and if there appears to be a problem it will offer to reset the Normal style back to the usual (General) format."]
[]
[null,"In most cases it is quite safe to delete all the custom styles and reset the built-in styles; this will not change the underlying data or formulas, and generally it will not even affect the visible formatting. However, if your spreadsheet is sensitive to formatting changes, you should use the File Save As function to save the cleaned workbook under a new name, and check it against the original."]
[]
[null,"File Save As"]
[]
[null,"After you have \"cleaned up\" a workbook with the Quick Clean-Up function, you can use the File Save As function to save it under a different name and leave the original file unchanged. You can also use the File Save As function to save the current report workbook under a different name, and Rainbow will then continue to use this for further reports."]
[]
[null,"Reset Reports"]
[]
[null,"Reset Reports tells you the file name of Rainbow's current report workbook, i.e. the workbook that Rainbow is using to hold reports that it generates, and it lets you clear Rainbow's record of this (without deleting the report workbook itself). This means that when you next request a report, Rainbow will have to select a new report workbook, which can be either a currently open workbook, or a new workbook that Rainbow can set up for this purpose."]
[]
[null,"If you have chosen one of the first three options (in your Preferences settings on the Reports tab) to enable Rainbow to select a new report workbook automatically, then the Reset Reports function will let you decide whether next time you want to select the new report workbook manually yourself, or whether you want Rainbow to make the selection automatically. This only applies to the next time you run a report; after that Rainbow will go back to automatic selection based on your Preferences setting."]
[]
[null,"Whenever a new workbook is created for reports, Rainbow will initially set this up with Excel's default new workbook name (e.g. Book1). You can then use the File Save As function to save the workbook under a more helpful name, and Rainbow will record the new name and continue to use the workbook for further reports."]
[]
[null,"Save Format"]
[]
[null,"Before you change the formatting of a spreadsheet with the functions described in later sections of this Guide, you can use the Save Format function to set a format restore point, in other words to take a snapshot of the formatting for selected worksheets, so that you can later undo the changes made by Rainbow. You can then use the Undo Changes function to restore the relevant formatting (e.g. cell colours) back to the way it was the last time you set a format restore point."]
[]
[null,"Rainbow only holds one format restore point at a time, so it will restore only the last set of formatting information that you recorded. This means that if you set a restore point before you use e.g. the Logic Map function, Rainbow will be able to undo any formatting changes made by this function, but it will not undo any previous changes. Any saved formatting information is effectively lost when you close Microsoft Excel."]
[]
[null,"If some formatting information has already been saved, this will be overwritten when you set a new restore point; Rainbow will tell you what workbook and sheet(s) have been previously saved, and will ask you to confirm before overwriting this information."]
[]
[null,"Undo Changes"]
[]
[null,"The Undo Changes function allows you to restore aspects of the format that you have changed using the various functions described in other sections. So for instance if you set a format restore point (with Save Format) immediately after running the Quick Clean-Up function, and you then use Risk Map to highlight various cells, you can click Undo Changes to restore the \"clean\" formatting as it was after the Quick Clean-Up."]
[]
[null,"In case you are not sure what information you recorded the last time you used Save Format to set a restore point, Rainbow will alert you if it has no formatting information saved for some or all of the worksheets you have selected to restore."]
[]
[null,"Summary Report"]
[]
[null,"It is always worth producing a Summary Report before looking at a spreadsheet in detail. The report is quick to produce, and can indicate unexpected issues such as Visual Basic code, hidden sheets or excessively long formulas. The report will run even if some sheets are protected, but it can only show a very limited amount of data for protected sheets."]
[]
[null,"Provided that access to Visual Basic modules has been switched on, as explained in the Quick Start Guide, the Summary Report can be your \"information hub\". From here you can simply click one of the 20 function buttons on the report (in column C and in row 26) to go directly to the appropriate Rainbow function for more detailed analysis. And by default the Summary Report also includes an explanatory comment (cell note) for each button, but you can turn off this feature on the Other Functions tab in your Preferences settings."]
[]
[null,"Note that if access to Visual Basic modules has not been switched on, you can still use the Summary Report, but the 20 function buttons will not be present, and instead the explanatory comments will tell you how to access the relevant Rainbow functions for more detailed analysis. In addition, cells B22 and B23 of the Summary Report will indicate that Visual Basic information is \"N/K\" (Not Known); this can also occur if the Visual Basic project in your spreadsheet has been password-protected."]
[]
[null,"The main section of the report (underneath row 26, listing data for each sheet) is formatted like a data table (with alternating stripes) for ease of reading. However, unlike most other Rainbow reports, it is not actually a table, and the colour of the stripes is taken from the cell groups highlighting colour for Group 64 (the last group). You can click the Colour Chart button and scroll down to find and change this."]
[]
[null,"Most of the data items in the Summary Report are self-explanatory. A large number of empty rows and columns can indicate problems with the structure of the worksheet, such as an isolated calculation situated a long way out from the main contents of the sheet. Similarly a low average density (proportion of non-blank cells) can indicate a highly fragmented structure."]
[]
[null,"The proportions of constant numbers and calculated numbers will indicate whether a sheet is used mainly for inputs or for calculations. The average and maximum formula length will point to sheets which may need particularly careful examination later, as also will the numbers of error values and comments (cell notes). If you want to see the longest formula in a particular sheet, click on the value in the Max fmla length column and the hyperlink will take you directly to the relevant formula."]
[]
[null,"By default the Summary Report will highlight in yellow or red some values which may indicate potential problems. However, this is only an indicator; highlighting does not mean that there is definitely a problem, and absence of highlighting does not mean that all is satisfactory. If you prefer the report without highlighting, you can turn this off on the Other Functions tab in your Preferences settings."]
[]
[null,"Note that the Summary Report, the Data Links function, the Names Toolbox option to convert names, and the (Un)hide/Protect function, are the only Rainbow functions which operate on chart sheets as well as worksheets. All the other functions operate only on worksheets."]
[]
[null,"Logic Map"]
[]
[null,"All cells in a spreadsheet can be placed in one of five categories according to whether they have any precedents (cells on which they depend for their calculations) and/or dependents (cells which depend on them):"]
[null,"•  Blank inputs are empty cells which have dependents but no precedents."]
[null,"•  Other inputs are non-empty cells which have dependents but no precedents."]
[null,"•  Intermediate workings are cells which have both precedents and dependents."]
[null,"•  Output calculations are cells which have precedents but no dependents."]
[null,"•  Labels are non-empty cells which have neither precedents nor dependents."]
[]
[null,"The Logic Map function lets you create a visual map of the logical structure of a spreadsheet based on either the five dependency types listed above, or the number of dependents of each cell, or both. For numbers of dependents Rainbow uses the corresponding Groups colour, which you can see if you click the Colour Chart button; for instance a cell with 3 dependents will be highlighted in the Groups 03 colour."]
[]
[null,"If you select to map the five dependency types, then after creating the map Rainbow will display the Logic Colours dialog box, with five buttons showing the colour for each dependency type. You can click any one of these Find Next buttons to find the next occurrence of the corresponding dependency type on the current sheet, and if you continue to click, you can cycle through all occurrences on the sheet."]
[]
[null,"The default Logic Map option shows both of these colours (for dependency type and number of dependents) together in each cell; the colour for the cell's dependency type is shown on the left and the colour for the number of dependents is on the right, with a graduated transition in between. To check the exact colours displayed in any specific cell, just select the cell and click the Find Colours button."]
[]
[null,"By looking at this visual map of a worksheet, you will see very quickly whether the sheet is well structured, with consistent patterns of colour running across rows and down columns, input cells grouped together, and no unused \"label\" cells in the middle of a block of inputs. A badly structured worksheet, on the other hand, will look like a mess of different colours, with cells of a different type or cells with different numbers of dependents occurring in unexpected locations."]
[]
[null,"Because this function calls on Excel to check the dependents and precedents of nearly every cell, it runs more slowly than some other Rainbow functions. If you need to check a large workbook, you may decide to select all sheets and then set Rainbow running while you continue with other work. Alternatively you may be able to save time by checking only a few columns or rows. You can also set the threshold (on the Criteria tab in your Preferences settings)  for Rainbow to skip processing dependencies when it is taking too long."]
[]
[null,"You may want to select View, Zoom and e.g. 50%, to get a quick high-level view of the spreadsheet, especially if you have selected to show just the five dependency types. Areas of the spreadsheet which are labelled as being Inputs or Assumptions should obviously contain mainly input cells, and there should be no un-used \"inputs\", which Rainbow will detect as labels in cells which are marked as Inputs or Assumptions."]
[]
[null,"Similarly there should be no input cells without a descriptive label (except sometimes within a range, e.g. with SUM() or LOOKUP()), and there should be no used or referenced cells lying in odd places or outside the main area of the spreadsheet. You can easily spot any blank (empty) input cells, as the Logic Map function highlights these in a different colour from non-blank inputs."]
[]
[null,"However, note that an incorrect reference in a formula could result in blank input cells in any part of a worksheet (e.g. row 1,048,576, or column XFD). If these invalid inputs were outside the used range of the worksheet (the range covering all non-empty cells), they would not be detected by the Logic Map function. To find any such invalid inputs, you can use Risk Map (select option 6 under the Precedents tab) to check all cells which have blank cells as precedents."]
[]
[null,"The Logic Map function does not produce a report, as this would list nearly all cells in the spreadsheet and would be of little use. However, you can produce separate reports on each of the dependency types with the Risk Map function (options 1 to 5 under the Dependencies tab, or click the \"Inputs and other dependencies\" button)."]
[]
[null," You can also use the Risk Map function to generate a different kind of map showing constant numbers, calculations, and text cells (options 1 to 3 under the Other tab, or click the \"Constants, formulas and text cells\" button)."]
[]
[null,"Inter-Sheet Logic"]
[]
[null,"The Inter-Sheet Logic function uses the range of 64 group colours to highlight the cells in each sheet which have precedents or dependents (as appropriate) in other sheets. The cells are highlighted in specific colours indicating which other sheet they are linked to, and you can set your Preferences (on the Colours tab) to change the start colour. The first (start) colour is always used for links to external workbooks, rather than links to other sheets in the same workbook."]
[]
[null,"As well as highlighting links in colour, Rainbow can generate a report showing in tabular format how each sheet is linked to other sheets (and also showing the selected colour for each sheet). This report is in the form of an outlined worksheet; click the number 2 to the left of the column headers at the top to display the details of individual cells, and click the number 1 to collapse the details and show only the totals. Note that the external links shown in this report will ignore cells with a #REF! error, and so it may give a different result from the Data Links function."]
[]
[null,"The colour mapping can only show one link for each cell (the first inter-sheet link in the cell's formula for precedents), but the report will normally show all inter-sheet links for each cell, unless you select the option (under Quick Reporting) to report only the first link for each cell. This option can speed up report production, but is not necessary if you are producing a grouped precedents report (the default setting), as this particular report runs very quickly."]
[]
[null,"The default option to group copied cells together (where appropriate) in the report is normally preferable to the option to list each cell separately, particularly as the grouped precedents report runs much more quickly than the non-grouped version. The non-grouped report is useful if you need to see the links for specific individual cells, but for a large spreadsheet it may require a very large number of rows."]
[]
[null,"By default Rainbow will highlight in the report the logic flows (between two sheets) which have the highest number of links; the top 5% will be shown in red, and the next 10% in yellow. The purpose of this is simply to enable you to see at a glance any overall patterns in the inter-sheet logic, and (as with the Summary Report) you have the option in your Preferences settings (on the Other Functions tab) to turn off the highlighting."]
[]
[null,"You also have an option in your Preferences settings to expand the report to include within-sheet logic (as well as inter-sheet logic). The report will then include all cells with any precedents/ dependents, including precedents/ dependents in the same worksheet. This will give you a very complete picture of the logic flow, but it can also generate a rather large report. Note that within-sheet logic will be shown only in the report, and not in the colour mapping."]
[]
[null,"If you are running a Dependents report, Rainbow may occasionally find cells with so many dependents that it would take a very long time to generate the report. You can control how Rainbow handles this situation on the Criteria tab in your Preferences settings."]
[]
[null,"If you were to select all sheets and run both a Precedents report and a Dependents report, you might expect that the two reports would show the same results but with the axes reversed. In the simplest cases this will indeed be true, but the results will be distorted whenever a calculation references a multi-cell range in another sheet (e.g. in a SUM() formula). This will count as one reference in the dependent sheet but as several in the precedent sheet. To complicate matters even further, under some circumstances each of the precedent cells may record multiple dependents (instead of just one)."]
[]
[null,"Names Toolbox"]
[]
[null,"The Names Toolbox function supplements Excel's Name Manager by allowing you to:"]
[null,"•  Generate an interactive report of all defined names (even hidden names)."]
[null,"•  Use this report to hide/unhide, list references, convert, change local/global scope or delete any name."]
[null,"•  Convert all names to cell references (and optionally delete them)."]
[null,"•  Delete all names which are not used anywhere in the workbook."]
[null,"•  Delete all names which are no longer valid (i.e. they refer to #REF)."]
[]
[null,"When you generate a Names Toolbox report, normally Rainbow will check and report whether each name is used anywhere in the workbook. This can be very useful, e.g. if you wish to see which names are unused, but it can take a long time for Rainbow to do this check. To turn off this feature, select \"Ignore\" in the box under \"Usage\". If you allow Rainbow to check usage, it also has the option to highlight in colour any cells where a name is used."]
[]
[null,"If you have selected to check usage, Rainbow will place an arrow → in column B of the report against any name which is used in your workbook, whether in calculations, in charts, in other names, or in macro code. If you have selected to highlight used names in colour, Rainbow will highlight column C in the colour it has used to show occurrences of the name in cells in the workbook. And any name which is not used anywhere in the workbook will be indicated by a cross × in column B."]
[]
[null,"Any hidden names are shown in the report with the name in (brackets). Any invalid names start with \"(#REF!)\" in the Refers to column, so that you can sort or filter them, and any which refer to an Excel 4.0 macro have \"(XLM)\". Where the name refers to a simple cell or range, Rainbow inserts a hyperlink in the Refers to column so that you can click to go straight to the referenced range."]
[]
[null,"The Scope column shows whether a name applies across the whole workbook or just in a specific sheet. And in the Comment column Rainbow can show (in brackets) the description generated by the Cell Inspector function if there is no comment; by default this option is turned off, but you can turn it on in your Preferences settings (on the Other Functions tab)."]
[]
[null,"For each name in the report, you can select an action in the final column from the drop-down list (click on the drop-down arrow by each cell). You can choose to:"]
[null,"•  Hide the name, so that it will not be shown in Excel's Name Manager (or unhide the name if it is hidden)."]
[null,"•  Generate a report listing where the name is used, i.e. all cell formulas, chart formulas, other names, and macro code, where the name is referred to."]
[null,"•  Convert the name to its referenced value, i.e. substitute the value of the name in all places where it is used (see example below)."]
[null,"•  Change the scope of the name from global to local, or from local to global, or from one (local) sheet to another."]
[null,"•  Delete the name."]
[]
[null,"Once you have selected the required actions, simply click the Perform Actions button. Rainbow will ask you to confirm, and will then go ahead and perform all actions that you have requested, and it will attempt to update the report to reflect the requested actions. However, if you have requested any complicated actions, particularly if these relate to duplicate names with differing scopes, it is advisable to re-run the report to check that the changes have taken effect."]
[]
[null,"The second Names Toolbox option (Convert names to cell references) searches for all references to defined names within formulas, charts and other names in the workbook, and substitutes the \"Refers to\" value of the name. So for example if you have defined the name \"Tomorrow\" with the value \"=TODAY()+1\", and cell C3 contains the formula \"=Tomorrow\", Rainbow will replace this with \"=(TODAY()+1)\". The name \"Tomorrow\" will then be unused (after Rainbow has made similar changes to any other cells in the spreadsheet which reference this name)."]
[]
[null,"If you wish, you can set your Preferences (on the Other Functions tab) so that when running this second Names Toolbox option, Rainbow will also delete the converted names (since they are no longer referred to anywhere), along with any other names that are not referred to anywhere in the spreadsheet. However, Rainbow will not delete the \"Print_Area\" and \"Print_Titles\" names used by Excel when printing, and it will also not convert or delete invalid (#REF!) or macro (XLM) names."]
[]
[null,"The third Names Toolbox option gives you a simple tool to clean up the names in a spreadsheet by deleting all those which are not used, including invalid (#REF!) names. But (like the second Names Toolbox option) it will not delete the \"Print_Area\" and \"Print_Titles\" names used by Excel."]
[]
[null,"The fourth Names Toolbox option provides a quick and simple way to delete all names which are no longer valid (where the name refers to #REF!)."]
[]
[null,"Note that, unlike Excel's Name Manager, the Names Toolbox report only includes \"defined names\",  i.e. it does not include the names of data tables. These are listed in Rainbow's Data Explorer report."]
[]
[null,"Data Links"]
[]
[null,"The Data Links function helps you find the exact location in your workbook of any external links to other Excel files (to see these click Edit Links in the Connections group on the Data tab in Excel). It searches for references to the external Excel files in all worksheets and also in any defined names and any charts (including chart sheets as well as embedded charts). Any worksheet-specific defined names will be shown preceded by the name of the relevant worksheet."]
[]
[null,"Data Explorer"]
[]
[null,"Excel now has many ways to represent blocks of data; as data tables, as query tables, as combined data/query tables, and as pivot tables. And underlying these visible blocks of data are two kinds of entities that are not normally visible:"]
[null,"•  Connections are the \"data pipes\" that define how data flows from external applications such as databases, OLAP \"cubes\", or Web pages, into the visible tables."]
[null,"•  Pivot caches are the \"data stores\" that hold the data for pivot tables, enabling you to select the row, column, page and data fields to be displayed."]
[]
[null,"The Data Explorer function helps you make sense of this complexity, by providing you with two linked and interactive reports listing all the tables, connections and pivot caches in your workbook. These interactive reports let you drill down to see further information about each item, some of which you can then easily edit."]
[]
[null,"The first Data Explorer report lists all the various types of tables in your workbook, and this report also shows (in the Source column) which pivot cache is used by any pivot tables, and (in the Connection column) which connection is used by any tables that reference external data. This information about pivot caches and connections is colour-coded to link it to the relevant row in the second Data Explorer report."]
[]
[null,"This second report lists all the pivot caches and connections in your workbook. Pivot caches do not have a name; they are identified simply by their index number. So the report first lists any pivot caches (which are shown as Pivot Cache 1, Pivot Cache 2, etc.) and then it lists any connections (which are identified by name)."]
[]
[null,"You can choose to run either of these reports separately, but the default is to generate them both at the same time, and they will then be hyperlinked so that you can click on any of the colour-coded cells in the Tables report to jump straight to the relevant row in the Caches/Connections report. The default is to report the tables for the whole workbook, but you can also choose to report for only selected sheets."]
[]
[null,"Both of these reports have a View column (column G) with a button for each item that you can click to display additional information about the item, in columns I and J. These columns list the values of various properties of the item, such as its name; note that different types of item will have different sets of properties. The item for which information is currently displayed is indicated by → ● on the View button."]
[]
[null,"Where there is a yellow highlighted cell in column I referring to a new value, e.g. New Name, this means that you can enter (in this case) a new name for the item. The easiest way is often to copy the existing value (e.g. the current name) from the row above and then edit it. When you have done this, simply click the Apply New Values button."]
[]
[null,"As an example, suppose your workbook contains two pivot tables which are based on exactly the same underlying data, but they each have their own separate pivot cache. If you want to make them both use the same pivot cache (e.g. Pivot Cache 1), click the View button for the second pivot table, and you should find that it has a Cache Index of 2. In the row underneath (against New Cache Index (1 to 2)) enter 1, and then click the Apply New Values button. If you now re-run the Data Explorer report, you will find that both pivot tables use Pivot Cache 1, and Excel has deleted Pivot Cache 2."]
[]
[null,"As another example, imagine you have a connection that currently points to an external database file OldData.mdb, and you wish to change it to point to NewData.mdb. Click the View button for this connection, and you will see that the database file name is stored in the Connection property. Copy the current value of this property down to the New Connection row, then simply edit it to replace OldData.mdb with NewData.mdb, and click the Apply New Values button."]
[]
[null,"After you have changed any values for a table, pivot cache or connection, Rainbow will attempt to update the Data Explorer report to reflect the new values. However, if you have made any complicated changes (e.g. to the Cache Index or Connection properties), it is advisable to re-run the Data Explorer report to make sure the changes have taken effect. As mentioned above, Excel will automatically delete any pivot cache which is not used, and it will then re-number the remaining pivot caches."]
[]
[null,"Note that you can edit other properties of your workbook connections if you click Connections in the Connections group on the Data tab in Excel. Rainbow's Data Explorer does not aim to replace this Excel function; its purpose is to give you a much clearer picture of how the tables, pivot caches and connections are all linked together."]
[]
[null,"Macro Explorer"]
[]
[null,"Excel macros in modern versions of Excel consist of lines of Visual Basic code; they are very easily overlooked, and yet they can make fundamental changes to a workbook. The Macro Explorer function generates a report which gives you an immediate overview of all the macros in your workbook, and it allows you to quickly drill down and see the lines of code for each macro."]
[]
[null,"Macros are normally grouped together in modules, so the Macro Explorer lists the relevant module and shows the line number in the module which marks the start of the macro. There are often several blank lines before the real start of the macro, so the report also shows the line at which the macro code really begins. It also shows the macro type; most macros are Subs (sub-routines), but some may be Functions."]
[]
[null,"Subs are usually linked to a button in a worksheet; you can use the Graphics Report in Rainbow to check whether your workbook contains any buttons, and what macros they are linked to. Some Functions, on the other hand, may be \"user-defined functions\" which can be called directly from inside an Excel formula (just like Excel's own built-in functions). To check whether a particular function is used in this way, you can search for it in your spreadsheet with Excel's Find tool."]
[]
[null,"Each macro in the Macro Explorer report has a View button (in column G), which you can click to view the lines of Visual Basic code in columns I and J. Rainbow ignores blank lines at the start of the macro, so the first line shown may not be the same as either of the line numbers in the report. The macro for which the lines of code are currently displayed is indicated by → ● on the View button."]
[]
[null,"Note that, like the Summary Report, the Macro Explorer will be unable to access information on Visual Basic code unless you have adjusted your Macro Security settings (see the Summary Report section for more details). And even if you have adjusted your Macro Security settings, Rainbow will be unable to access the information if the Visual Basic code has been password-protected."]
[]
[null,"Formula Groups"]
[]
[null,"The Formula Groups function analyses row and column differences to identify groups of copied formulas, and it then uses the colours from your Colour Chart settings (for more information see Colour Chart below) to highlight each group. This lets you see at a glance where there are inconsistent formulas in a row (which may indicate an error), and it allows you to check just one cell in a group and know that all the other cells are the same."]
[]
[null,"Rainbow allows you to group formulas either along rows (horizontally) or down columns (vertically). In most cases the default grouping along rows will be preferable; this identifies formulas which belong to the same group on a row even if they are not in adjacent cells. So for example in a multi-year spreadsheet with sets of 12 monthly columns followed by an annual summary column, Rainbow will highlight all the monthly columns on each row in one colour and all the annual columns in another colour. However, with formulas which are copied down columns (across multiple rows), it will use the same colour only if the formulas are in adjacent rows (in a single block of cells)."]
[]
[null,"You will find the grouping down columns (vertically) very useful in two situations:"]
[null,"•  where a spreadsheet has repeating sets of identical calculations every so many rows, perhaps calculating profit for different products. In this case the grouping down columns will give the same colour to each corresponding row (e.g. Gross Sales or Direct Costs) in the different sets. You can then see at a glance whether the repeating calculation sets are in fact identical, or whether there are variations in the patterns of colours."]
[null,"•  where the calculations in a spreadsheet are organised by columns rather than by rows. For instance a spreadsheet might list a company's stock items, one per row, with the columns showing opening and closing stock, production, unit price and cost, gross sales and net profit. The grouping down columns would check the calculations for consistency down each column, even if some rows had been left blank."]
[]
[null,"As well as mapping formula groups with colours, Rainbow normally generates a report which lists all unique formulas by row or column, showing the first and last occurrence and the number of occurrences of each formula, with a column where you can indicate that the formula has been checked. Under \"Formula listings in report\", you can choose whether column F of the report simply shows the relevant formula, or whether it displays a description of the cell as generated by the Cell Inspector function."]
[]
[null,"Normally Rainbow first uses the colour labelled Group 01, then Group 02, Group 03 and so on, but you can set your Preferences (under Grouped cell colours on the Colours tab) to start with a different colour. Whichever colour you start with, Rainbow will use all the colours between Group 01 and Group 64 if necessary in order to highlight each separate formula group. And if it needs to use more than 64 colours, it will simply begin again with the first colour."]
[]
[null,"Rainbow can use the available colours in two different ways. By default the Preferences for Grouped cell colours (on the Colours tab) are set to Rotate through all colours, which means that for each new formula group Rainbow will simply use the next available colour, going back to the beginning after it reaches Group 64. If you uncheck this option, Rainbow will use the minimum number of colours needed to distinguish different formula groups (and use consistent colours for formulas in each row or column); with this option it is unlikely that you will need more than the available 64 colours."]
[]
[null,"If Rainbow does run out of colours on a particular row (or column), it will continue to use different colours to indicate different contiguous formulas, but each colour may now represent more than one different formula within the row. If this happens, Rainbow will alert you and let you know which is the first cell on each row where it has run out of colours. In this situation it is sometimes helpful to try vertical grouping instead of horizontal grouping, or vice versa. Of course the Formula Groups report will still correctly list all the separate groups of formulas."]
[]
[null,"Risk Map"]
[]
[null,"The Risk Map function is one of Rainbow's most powerful features. It enables you to highlight cells and generate reports analysing any or all of 28 different potential risks. Each potential risk has its own colour, which you can see from the Colour Chart function, and Rainbow uses these colours to highlight the corresponding cells in your spreadsheet, and also on alternate rows of each Risk Map report. So you can select a highlighted cell in a report, click Find Colours, then switch to your spreadsheet and use the Find Colours search buttons (e.g. Next Block) to see all occurrences of the corresponding risk in the current worksheet."]
[]
[null,"For detailed help on all the 28 risk analysis options  (i.e. 7 potential risks on each of 4 tabs), click the Help bar that runs down the right-hand edge of each tab. In practice you will find it is best not to run too many of the options at once, otherwise it can take too long and generate more information than you want. So when you first click Risk Map, you will find it has pre-selected eight of the most popular options; these are the default set of \"favourites\", which you can clear and then re-select by clicking the Favourites button."]
[]
[null,"You can make a more precise selection of the risks you want to analyse either by selecting them individually (on the Precedents, Formulas, Dependencies or Other tab) or by clicking one of the five \"preset\" buttons (e.g. \"Inconsistent precedents\"), each of which selects a group of options. Later you may end up with a standard set of a few analysis types that you use regularly, and you can then click the Save favourites button to set these as your default choice instead of the original eight options (which you can always restore if you click Restore Defaults, under Menu Settings). "]
[]
[null,"The last two preset buttons (\"Inputs and other dependencies\" and \"Constants, formulas and text cells\") are different from the first three. The first three buttons highlight individual cells which are potential risks, whereas the last two are intended to generate colour \"maps\" of the structure of a worksheet which can indicate poor spreadsheet design. Reporting on individual cells is not usually relevant for these last two preset buttons, and is turned off by default (though you can turn it on if you wish)."]
[]
[null,"You will notice that the \"Inputs and other dependencies\" button generates the same \"map\" as the Logic Map function. Logic Map provides a fast and direct way to generate this map, whereas the \"Inputs and dependencies\" button within Risk Map allows you to select individual dependency types and optionally  generate reports and insert cell comments."]
[]
[null,"On the right of the Risk Map form is the Insert Comments box. If you select this, Rainbow will insert a comment (cell note) on each highlighted cell listing all the analysis types found in this cell, even if there are more analysis types than can be shown with colour highlighting (depending on the Maximum colours value on the Colours tab in your Preferences settings). However, the Insert Comments option is best used with caution, as it can increase the size of a file by a factor of up to 10 times."]
[]
[null,"Note that with all the options on the Precedents tab, and also with Formatting differences (on the Formulas tab), Rainbow will use column F of the corresponding report to show you the details of the formatting or other issues that it has found (as explained further in the detailed help). And where Rainbow has found a block of copied cells, it may not be able to show exact details of the issues for each cell in the block, though it will attempt to provide as much information as it usefully can."]
[]
[null,"Risk Map - Precedents"]
[]
[null,"• 1)  Inconsistent precedent copies are cells which are copied from another cell above or to the left, but where the cell type of one or more of the cell's precedents is different from the cell type of the corresponding precedent of the original cell from which it is copied (which is shown in column G of the report). By default (depending on your Preferences settings) this option also shows precedent ranges which vary in size (combining absolute and relative references), but it ignores differences in number format. This may seem complicated, but it provides a level of deep analysis which can indicate problems such as where a precedent should have been (and has not been) specified as an absolute reference, or where a formula has been copied beyond the end of the relevant source values. Following are two example entries in column F of the report for this option:"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"[C96] C55 Date → Formula, B61:C61 1-cell → 2-cells"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"If column G of the report shows \"B96\", this entry in column F indicates that cell C96 is copied from B96, and that (a) cell B96 refers to B55, which is a date, whereas in cell C96 the corresponding precedent C55 is a formula, and (b) cell B96 refers to $B61:B61 (1 cell), which in cell C96 has become $B61:C61 (2 cells)."]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"[H39] Changed internal precedents"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"You may occasionally see this entry in the report, meaning that the formula in cell H39 has some complexity which has caused Excel to process its precedents in a different order from the cell from which it is copied. This does not mean that there is an error, but it suggests that the formula is sufficiently complex to deserve careful checking."]
[]
[null,"• 2)  Precedent block inconsistencies refers to cells with a block of precedents that includes more than one type of cell within the block. By default (depending on your Preferences settings) this option also shows where there are row or column differences within the block, but it ignores differences in number format. Precedent block inconsistencies are not necessarily a problem, but they may indicate that the precedent block has included too many cells, e.g. that a SUM() calculation has included a subtotal as well as the basic data. Following is an example report item (column F):"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"[C87] {C51:C86} C55 Value → Blank, C63 Column Difference"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"This indicates that cell C87 refers to a block of precedents C51:C86, and that within this block (a) cell C55 is blank, whereas the preceding cell C54 is a numeric value, and (b) cell C63 contains a different formula from the preceding cell C62."]
[]
[null,"• 3)  Precedents only part of block is in some ways the reverse of the preceding option; it shows cells with a block of precedents which forms part of a larger block of cells of the same type. This can  help you spot one of the most classic spreadsheet errors: a SUM() calculation that has failed to include all the relevant basic data cells. In order to show the most relevant items, Rainbow only looks for additional rows or columns where the block already has more than one row or column and extends beyond the row or column of the dependent cell, and it highlights in yellow where the additional row or column is a direct copy from the current block. Here is an example report item:"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"[C134] {C97:M99} ↑C96:M96, ↓C100:M100, ≡→N97:N99"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"This item will be highlighted in yellow unless you have turned off highlighting (in your Preferences settings on the Other Functions tab). It indicates that cell C134 refers to the precedent block C97:M99, and that the cells above (C96:M96) and below (C100:M100) this block are all of the same type as in the block itself. In addition, the cells to the right (N97:N99) of the block all contain formulas that are a direct copy (as shown by the ≡ symbol) of the formulas on the  right-hand edge (M97:M99) of the block."]
[]
[null,"• 4)  Precedents referring forwards means cells which have precedents (in the same sheet) either on a row underneath or in a later column on the same row. This is not a problem for a modern spreadsheet program like Microsoft Excel, but it can indicate where the flow of the calculation logic is particularly complex and may need additional checking. Below is an example report item:"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"[D53] →F53:AS53, ↓F125"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"This shows that cell D53 refers to cells F53:AS53 in the same row to the right and that it also refers to cell F125 in a later row."]
[]
[null,"• 5)  Precedents of different cell type shows cells which have precedents of a different cell type from the cell itself, for instance numeric cells which have a text cell as a precedent. This is not necessarily incorrect (cp. =LEN(A1) with A1 as text), but sometimes it can indicate a potential problem, for instance where a SUM() calculation includes text cells. Note that if you are doing this analysis together with Precedent block inconsistencies (which similarly scans blocks of precedents), you can speed up processing by selecting (in your Preferences settings on the Risk Map tab) to check only the corners of blocks (e.g. A1, A4, D1, D4 in block A1:D4). An example report item might be:"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"[C104] Formula ← B41:B43 Blank, C66 Logical, C8 Text"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"This indicates that cell C104 is a numeric formula, and it has blank precedents in cells B41:B43, a logical (TRUE or FALSE) precedent in C66, and a text string precedent in C8."]
[]
[null,"• 6)  Cells with blank precedents is in some ways the inverse of Blank input cells under the Dependencies tab; it shows the dependents of blank input cells. However, it is more comprehensive than the Blank input cells option, because (unlike the latter) it will report on dependents of blank input cells even if the input cells are outside the used area of the worksheet (e.g. in row 1,048,576, or column XFD). Instances of blank input cells outside the used area are more likely to be errors, and so are highlighted in yellow.  An example of this is the following report item:"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"[C71] V13:AN13; [E71] → AP13"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"This item (which will be highlighted in yellow unless you have turned off highlighting, in your Preferences settings on the Other Functions tab) shows that cell C71 has a block of blank precedents in V13:AN13, and also that cell E71 (which is copied from C71) has a blank precedent in cell AP13 which is outside the used area of the worksheet (as indicated by the → symbol)."]
[]
[null,"• 7)  Cells with  error values are cells with a value of #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF! or #VALUE!. Many of these cells display an error value because they have one or more precedents with error values, not because of any problem with the cell itself. So the report for this option distinguishes between dependent error cells (for which it shows the precedents with error values) and error source cells (which are highlighted in yellow). And if you prefer, you can choose (on the Risk Map tab in your Preferences settings) to show only the error source cells and ignore the dependents. Following are examples of the two different types of report item for this option:"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"[C17] #DIV/0! → Error source cell"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"This item (which will be highlighted in yellow unless you have turned off highlighting or chosen to show only error source cells) indicates that cell C17 has the error value #DIV/0, and that this is due to a division by zero in the formula of the cell itself (not inherited from another cell)."]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"[L49] #DIV/0! ← C17"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"This shows that cell L49 also has the error value #DIV/0, but that this value is inherited from cell C17, which is one of the cell's precedents."]
[]
[null,"Risk Map - Formulas"]
[]
[null,"• 1)  Hard-coded numbers (all) refers to  cells where an input number has been combined with a formula. Formulas containing a hard-coded 0 or 1 are very common, and so will not be highlighted, but this option (unlike the one below) will highlight all other hard-coded numbers. By default, Rainbow will include as hard-coded numbers any cells containing a formula such as \"=365/4\", which may be regarded as bad practice but is not generally dangerous. However, you can change your Preferences settings (on the Risk Map tab) to highlight only cells which combine a hard-coded number with a reference to another cell, e.g. \"=C63/4\"."]
[]
[null,"• 2)  Multi-digit hard-coded numbers refers to formulas containing a hard-coded value of 10 or above, or a decimal value. These are likely to represent more significant items of hard-coded data, whereas single-digit numbers (highlighted by the preceding option) may well be nothing more than parameters for functions such as HLOOKUP() and VLOOKUP()."]
[]
[null,"• 3)  Row differences (differences in cells along a row) can be a very useful indicator of inconsistencies in the calculations, though you may find it more helpful to use Formula Groups to check the different formulas in the spreadsheet, especially as Row differences and Column differences only show changes in formulas; they do not show (for instance) formulas overwritten with hard-coded inputs. Note that Row differences and Column differences cannot be grouped like other Risk Map options, and so they are processed after the other 26 options (and the corresponding reports come after the reports for the other options)."]
[]
[null,"• 4)  Column differences (differences in cells down a column) are similar to row differences, and will mainly be relevant for spreadsheets where the calculations are structured by columns rather than by rows."]
[]
[null,"• 5)  Formatting differences shows cells which are of a different type or different number format from the cells around them, and it also finds cells where the formula has been set to be hidden. If the \"map\" generated by this option displays a lone cell with formatting differences in the middle of a homogenous block of cells, this may well indicate a potential problem or error. An example report item could be:"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"[C119] Hidden Formula, «General» → «0.00%»"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"This indicates that cell C119 has been set with its formula hidden, and also it has a percentage format rather than the General number format of surrounding cells."]
[]
[null,"• 6)  Complex formulas are cells with a formula which contains at least a specified number of characters or a specified number of levels of nested IF() statements. The defaults are 100 characters or 2 levels of nested IF() statements, but you can go to your Preferences settings and set your own values (on the Criteria tab)."]
[]
[null,"• 7)  Array formulas are a special type of formula that Microsoft Excel can use to calculate results across an array (block) of cells. They can be a very effective method of performing certain complex calculations, but they need careful checking to ensure they are generating the correct results."]
[]
[null,"Risk Map - Dependencies"]
[]
[null,"• 1)  Blank input cells are cells which are empty but which are used in one or more calculations. There may be no problem if they are part of a larger block of cells, but individual blank input cells may indicate that an input value is missing or a formula elsewhere has been mis-typed."]
[]
[null,"• 2)  Non-blank input cells are a normal part of the calculation logic, as also are the following three dependency types. They are not significant on their own, but together they can provide a useful \"map\" of the worksheet. Note that (depending on your settings on the Criteria tab in Preferences) Rainbow may skip processing dependents for some cells where it is taking too long to do so. Where this happens, Rainbow will report the details in the Rainbow Log file (click User Guide, then Rainbow Log)."]
[]
[null,"• 3)  Intermediate workings are calculations which provide the inputs to one or more further calculations."]
[]
[null,"• 4)  Output calculations are calculations which have no further dependent calculations."]
[]
[null,"• 5)  Labels are cells which are not empty, but which are not used in any calculations. Usually they are text cells serving as headings (labels) for a row or a column."]
[]
[null,"• 6)  Lookup and related functions finds cells containing any of these functions: HLOOKUP(), INDEX(), INDIRECT(), LOOKUP(), MATCH(), OFFSET(), VLOOKUP(). All these functions have the effect of determining the precedents of a calculation on the basis of other parameters. Consequently, unless carefully checked, they can very easily give rise to incorrect results."]
[]
[null,"• 7)  Lookup requiring ordered list is much more specific than the preceding option. It finds instances of the three LOOKUP() functions where they may not return the correct result unless the list of looked-up values is sorted in ascending order. Clearly in these circumstances there is even greater potential for error."]
[]
[null,"Risk Map - Other"]
[]
[null,"• 1)  Constant numbers are cells which contain an input number (i.e. not a formula). This and the following two options can provide a useful \"map\" of a worksheet, similar to but less specific than the Logic Map."]
[]
[null,"• 2)  Calculated numbers are cells containing a formula which calculates a number."]
[]
[null,"• 3)  Text values are cells containing text rather than a number."]
[]
[null,"• 4)  Numbers formatted as text are numbers which have been formatted (e.g. by preceding them with a quote mark ' ) so that Excel will interpret them as textual rather than numeric values. By default (depending on your settings on the Risk Map tab in Preferences), this option will also find numbers which are preceded or followed by up to three or four letters, e.g. \"¥1000\" or \"568 ml\". If you then wish to convert these cells into simple numeric values, you can use the Format Editor (option 1)."]
[]
[null,"• 5)  Same font and background colour refers to cells where the content of the cell has been made invisible by setting it to the same colour (e.g. white) as the background - a technique often used to hide incidental parameters in a spreadsheet."]
[]
[null,"• 6)  Unlocked cells (all) are any cells where the protection status of the cell has been changed from locked (the default) to unlocked. Once you have highlighted unlocked cells with Risk Map, you can use the Format Editor (option 3) to change the colour if you want them displayed in a different colour on your spreadsheet."]
[]
[null,"• 7)  Unlocked formula cells are unlocked cells containing a formula. It is usual to unlock input cells and leave formulas locked in order to protect them from accidental change, and so unlocked formula cells may indicate a problem with spreadsheet design."]
[]
[null,"Cell Inspector"]
[]
[null,"The Cell Inspector is an interactive function which displays the precedents and dependents of the currently selected cell, and also provides a best-guess description of the meaning of each cell. It will take you to each precedent or dependent (double-click the relevant line or click the appropriate button) so that you can click on the underlying spreadsheet and explore the logic and meaning of each cell. Then click the back-arrow button to return to where you were before. The Cell Inspector title bar shows how many steps you are from the original cell (#1) where you started."]
[]
[null,"For most cells, the description will be in two parts separated by a dash, e.g. \"Net Profit - Year 1\". This indicates that the row heading is \"Net Profit\" and the column heading is \"Year 1\". Sometimes there may be only one heading, e.g. \"Net Profit\", and sometimes a heading may have two parts, e.g. \"All Products Net Profit\". To find the headings, Cell Inspector uses a probabilistic scoring system which cannot be guaranteed to be always accurate, but has been found to be reliable across a range of financial models, and can provide a very fast indication of possible faulty logic."]
[]
[null,"As an example, suppose you run Cell Inspector on cell H74 in sheet Operations, and Cell Inspector shows this as Availability Fee - 30/09/2015, with the formula \"=Inputs!H101*(1-C26)\". If you then look at Cell Inspector's list of Precedents and see that Inputs!H101 is Availability Charge - 30/09/2014, you can immediately spot that there may be a problem with misaligned columns in different sheets referring to different periods."]
[]
[null,"If you come across a complex formula, perhaps with several nested \"IF\" statements, you can click Parse Formula to see a structured layout of the formula which will quickly identify which are the relevant components of each \"IF\" statement. To go back to the standard Cell Inspector layout, just click Show Dependents."]
[]
[null,"Rainbow tries to make sure that the currently selected cell is always visible by placing the Cell Inspector dialog box in the top right of the screen, and if necessary by scrolling the spreadsheet to bring the cell into view. You can also click the Minimise button so that you can see any parts of the worksheet which may still be hidden by the Cell Inspector dialog box. And at any time you can click outside the dialog box to move around the worksheet and workbook."]
[]
[null,"Cell Inspector won't take you to precedents or dependents in closed external workbooks or in hidden sheets, though it will attempt to indicate precedents in closed workbooks. Cell Inspector will ignore dependents in hidden sheets when these are the first that it finds, and if the first two dependents are both hidden it will assume the cell has no dependents. So you should always use Rainbow's (Un)Hide/Protect function first if you think there may be any links to hidden sheets."]
[]
[null,"Comparison Toolbox"]
[]
[null,"The Comparison Toolbox function can work in several different ways, depending partly on what you select in the Comparison Toolbox dialog box, and partly on what range(s) you have selected before you click Comparison Toolbox:"]
[null,"•  It can compare one sheet in a workbook with any or all of the other sheets in the same workbook."]
[null,"•  Provided you have more than one workbook open, it can compare corresponding sheets (i.e. sheets with the same name) in two different workbooks."]
[null,"•  If you select the appropriate range(s) before clicking Comparison Toolbox (see below for more detail on this), it can compare a particular multi-cell range (rather than the whole worksheet) with corresponding ranges in other sheets or another workbook."]
[null,"•  If you first use the Ctrl key (with the mouse) to select multiple areas (e.g. tables) in a single worksheet, it can compare the first area in the worksheet with all the others."]
[]
[null,"As with other Rainbow functions, when you first click Comparison Toolbox, Rainbow will try to guess what workbook(s) and worksheet(s) you wish to compare. If you find it has guessed wrongly, simply click the Selection… button to change the selection. This will open a dialog box with two selection areas, for the workbook and worksheet(s) you want to compare (on the left) and what you want to compare them with (on the right). If you have chosen to highlight (Colour or Map) differences, Rainbow will highlight them in the worksheet(s) you select in the right hand selection area."]
[]
[null,"The title bar at the top of this selection dialog box will confirm what type of comparison is currently selected:"]
[null,"•  If you select two different workbooks, the title bar will show \"Comparing Workbooks\", and you will be able to select any or all worksheets in the left-hand area only, for comparison with corresponding sheets in the right-hand workbook."]
[null,"•  If you select the same workbook on both sides, the title bar will show \"Comparing Worksheets\", and you will then be able to select only one worksheet in the left-hand area. A worksheet that you select in the left-hand area will be deselected in the right-hand area, and you will be able to select any or all of the other worksheets to compare with it."]
[null,"•  If you select the same workbook on both sides, and you select the same one sheet in the right-hand area as you have selected on the left, then if this sheet has multiple areas selected, the title bar will show \"Comparing Areas in Sheet\"."]
[]
[null,"Once you have selected the workbook(s) and worksheet(s) you want in the selection dialog box, click OK to return to the main Comparison Toolbox dialog box, where you can select other relevant options:"]
[null,"•  Comparison types lets you choose whether to compare formulas (i.e. the contents of cells) or values (the input or calculated results), and also whether to compare all cells, or to ignore (if comparing formulas) cells containing an input value, or (if comparing values) cells containing a calculated formula."]
[null,"•  If you have selected to compare formulas, Formula grouping can group together in the differences report all differences which result from copying the cells in both worksheets (rather like the Formula Groups function). This means that the report is much smaller, and lets you see immediately how many real changes have been made."]
[null,"•  The Ranges to compare option only applies if you have selected a multi-cell range to compare; it then allows you to compare either the same range across all sheets or different ranges in different sheets (see below for more details)."]
[]
[null,"The Comparison Toolbox dialog box always appears with the same options initially selected. If you find that you regularly use a different set of options, you can save these as the default (initial) selection by clicking Save Defaults."]
[]
[null,"If you choose (under Ranges to compare) to compare different ranges in different sheets, the way the comparison then operates is dependent on whether you are comparing workbooks or worksheets:"]
[null,"•  If you are comparing two workbooks, then for any sheets in the source workbook which have a multi-cell range selected, Rainbow will compare the selected range with the same range in the corresponding sheet in the other workbook, and for any sheets which have just one cell selected, it will compare the same range as in the first selected worksheet."]
[null,"•  If you are comparing worksheets, Rainbow will compare the selected range in the source worksheet with a range of the same dimensions (rows x columns) in all other selected worksheets; for worksheets which have a multi-cell range selected, it will start the comparison at the top left corner of the selected range, and for any sheets which have just one cell selected, it will compare the same range as in the source worksheet."]
[null,"•  However, if you are comparing multiple ranges (areas) within a single worksheet, you don't need to select the whole of each area. Rainbow will compare the first selected range with other ranges of the same dimensions, starting the other range(s) at the top left corner of each other range (whether single-cell or multi-cell) selected on the worksheet."]
[]
[null,"If you choose (under Comparison types) to compare formulas only (ignoring input values), the comparison will ignore changes in constants (simple numbers and text) and only report differences where one or both cells contain a formula. However, it is important to appreciate that there may be constants which are not inputs (simply labels or memo cells), and inputs or hard-coded numbers (e.g. =365/4 or =B7*1.175) which are formulas, not constants."]
[]
[null,"A common reason for differences between two versions of a workbook is that rows or columns may have been inserted or deleted in the later version. Rainbow will normally attempt to adjust for this by detecting how many rows or columns have been inserted or deleted and inserting rows or columns temporarily to bring the two workbooks into line with each other. It leaves the inserted items in place while doing the comparison, and then automatically removes them at the end to restore both workbooks to their original state. (Note however that automatic insertion is disabled when comparing multiple areas in a single sheet, to avoid unexpected interactions.)"]
[]
[null,"This feature can often reduce the number of reported differences by an order of magnitude. However, Rainbow will not always guess correctly where to insert rows or columns, and so you can set your Preferences (on the Other Functions tab) to disable this feature if you wish, and you can also choose an option not to remove the automatically inserted rows or columns at the end of the comparison."]
[]
[null,"This last option may be useful it there are insertions or deletions in several sheets which depend on each other, in which case you may need to run the comparison, leave the adjustments in place, and then run it again. Generally however, where there are insertions or deletions in one sheet (e.g. Inputs) on which other sheets depend, all you need do is make sure this is the source sheet when you run the comparison, in order to ensure that the adjustments are made in this sheet before the dependent sheets are compared."]
[]
[null,"Where Rainbow finds differences, it will report the formulas in each cell as they appear after any adjustments that it has already made. Clearly this can mean that the formulas may refer to different rows from those which they referenced before the adjustments were made. However, Rainbow always shows the original address (before adjustments) of each cell in the columns headed \"Cell 1\" and \"Cell 2\"."]
[]
[null,"Sometimes Rainbow will be unable to detect an insertion or deletion, even though it may seem obvious to you, or conversely Rainbow may detect an insertion or deletion where in fact there is some other reason for a difference between cells. In this case, you may wish to modify your Preferences settings (on the Criteria tab) to adjust the criteria that Rainbow uses. The criteria that you can change are:"]
[null,"•  The minimum number of non-blank cells that Rainbow regards as adequate evidence for a discrepancy or a match."]
[null,"•  The maximum percentage of cells that can have the same value and still cause Rainbow to look for row/column insertions or deletions. Increasing this value makes Rainbow check more often for insertions or deletions."]
[null,"•  The minimum percentage of cells that need to have the same value for Rainbow to decide that it has found the matching row/column. Reducing this value makes Rainbow accept more readily that a row/column matches what it is looking for."]
[]
[null,"Graphics Report"]
[]
[null,"The report on buttons and graphics lists all graphical objects (other than comments), with some additional detail about form controls (e.g. buttons) and chart titles. It also shows which objects (such as buttons) call a macro; these will correspond with the \"Macro buttons\" column in the Summary Report, and you can use the Macro Explorer function to check what the macro does."]
[]
[null,"Comments Report"]
[]
[null,"The comments report lists the text of all comments (cell notes) in your workbook, together with the author's name and the cell address and value."]
[]
[null,"Sample Data"]
[]
[null,"Most of Rainbow's functions are designed to help you analyse the logic of a spreadsheet rather than the data it contains. The Sample Data function helps fill this gap by enabling you to to generate a sample of data from a worksheet (e.g. a trial balance download) for testing. Rainbow can format the sample data as a report (added to the current report workbook), and/or it can highlight the sample rows in colour on the source spreadsheet. Before you click the Sample Data button, you can select the area of the source worksheet containing the data to be sampled, and Rainbow will then select the sample rows only from this area. "]
[]
[null,"You can use either random or periodic sampling methods. If you select random sampling, the first box under Sample selection will contain the random number seed. If you set this to 0, the seed (and the sample selected) will change each time you run Sample Data. If you set the seed to a positive number, the sample will be the same (for any given seed value) every time."]
[]
[null,"If you select periodic sampling, the first box under Sample selection will contain the row sampling interval, i.e. if you enter 4, Rainbow will select every fourth row. If you then enter 0 in the box underneath (total samples needed), Rainbow will simply select every fourth row until it reaches the end of the source data. However, if you enter a sufficiently large value for total samples needed, Rainbow will loop back to the beginning of the source data and continue selecting every fourth row. It will check and warn you if this means that it will select the same row of data more than once."]
[]
[null,"You can enter values in both of the boxes under Sample selection either by clicking the up and down arrows or by direct input. The maximum value in either box is 999. If you choose periodic sampling and enter 0 for total samples needed, Rainbow will let you know how many samples this will generate (from the whole worksheet or selected range), and if this is more than 999 it will prompt you to enter a different value."]
[]
[null,"If you select a range for the source data that has a row of data labels at the top, you can click the Top row - Labels box, and Rainbow will copy the data labels into the Sample Data report. Otherwise it will simply label the data columns as Col A, Col B etc."]
[]
[null,"Find Colours"]
[]
[null,"The Find Colours function checks the colour(s) of the selected cell against Rainbow's defined cell colours (as displayed if you click the Colour Chart function). It lists each colour, with the corresponding description, and you can click the Edit... button for each colour to go to the Colour Chart colour editing function for that colour."]
[]
[null,"You can also search for further occurrences of the same colour(s) in the worksheet, either by blocks of similar cells or one cell at a time, and searching either forwards or backwards. If you select Loose Matching, Rainbow will search for any cells that have any of the colour(s) in the current cell, whereas with Tight Matching, Rainbow will search only for cells with exactly the same colour(s) as the current cell. If you continue to click, you can cycle through all occurrences in the current worksheet."]
[]
[null,"Like Excel's own Find function, the Find Colours dialog box will let you click outside it on the underlying Excel worksheet. This means that if (for instance) you wish to find inter-sheet links to a specific sheet within your workbook after running the Inter-Sheet Logic report, you can click (in the report) on the colour that Rainbow has used for the relevant sheet, and then click Find Colours to identify this colour. You can then click outside the Find Colours dialog box and switch to the workbook, and simply click Next Block or Next Cell to find any relevant links."]
[]
[null,"Colour Chart"]
[]
[null,"The Colour Chart function provides an interactive display which lets you view and change the colours that Rainbow uses for all the various dependencies and cell types, as well as the 64 colours used to highlight formula groups (and inter-sheet logic and difference groups). It also links to the Find Colours function, allowing you to find occurrences of any specific Rainbow colour on the current worksheet."]
[]
[null,"So if you want to remind yourself of the cell highlighting colours, for instance after you have run the Logic Map or Risk Map function, you can either select a specific cell and then click Find Colours to see the meaning of the colours in that cell, or you can click the Colour Chart button to view a complete table of the various colours. You can hover the mouse over any colour to see its exact RGB (Red, Green, Blue) values, and if you want to change a colour, simply click on it in the table to bring up a colour editing dialog box from which you can make a new selection."]
[]
[null,"This colour editing dialog box has two main options: you can click Change… to select a new colour, or Find... to find the existing colour in the current worksheet. If you click Find..., this will display the Find Colours dialog box, which is explained in the preceding section. If you click Change..., this will open Excel's own colour picker dialog, where you can choose from a colour hexagon or specify an exact RGB or HSL colour value."]
[]
[null,"Rainbow will check and alert you if the new colour you have chosen is not one of the current set of 92 colours, as this can cause the Find Colours function to give an incorrect result. If you do choose a duplicate colour, Rainbow will display an alert each time that the Colour Chart is initialised or changed, reminding you to change the duplicate colours."]
[]
[null,"Once you have selected a new colour, the colour editing dialog box will show the new colour above the old colour (with the Red, Green and Blue values for each). You can then click Undo to revert to the old colour, or Save Defaults to save the new colour as the standard colour for this cell type. If you close the dialog box (or click either of the two Edit... buttons below to move to the previous or next colour) without clicking Save Defaults, Rainbow will use the new colour for the current session, but will revert to the old colour for future sessions."]
[]
[null,"If you look closely at the RGB (Red, Green and Blue) values of the new colour you selected as displayed in the colour editing dialog box, you may notice that they are slightly different from what you might have expected. For instance if you selected pure red (which would normally have RGB values of 255, 0, 0), the colour editing dialog box would show RGB values of 254, 0, 0 (displayed as 254 000 000). This is because Rainbow deliberately makes a minimal alteration to your colour selection, in order to ensure that the Find Colours function will not confuse Rainbow's own colours with standard colours which might already be used elsewhere in the worksheet. "]
[]
[null,"Logic Colours"]
[]
[null,"The Logic Colours dialog box is intended mainly for use with the Logic Map function, and it is automatically displayed after you have run a Logic Map with either of the first two options (dependency types and numbers, or dependency types only). It shows each of the five dependency types and the corresponding cell colour, and if you click the corresponding Find Next button, it will take you to the next group of cells with this colour in the current worksheet."]
[]
[null,"The Find Next buttons work in the same way as the Next Block button in the Find Colours function (with Matching set as Loose), and just as in the Find Colours function, you can continue to click the button to cycle through all instances of the corresponding colour in the current worksheet. Also as with the Find Colours function, the Logic Colours dialog box will let you click outside it on the underlying Excel worksheet, so that you can check different cells or even switch to another sheet."]
[]
[null,"Format Editor"]
[]
[null,"The first Format Editor option, to Convert numbers formatted as text, uses the same definition of \"numbers formatted as text\" as the corresponding option in the Risk Map function (on the Other tab), but instead of highlighting any relevant cells it replaces the textual values with the corresponding numbers. Like the Risk Map option, it can also (if selected in your Preferences settings on the Risk Map tab) deal with numbers preceded or followed by up to three or four letters, e.g. \"¥1000\" or \"568 ml\"."]
[]
[null,"The second option, to Clear cell colours and patterns, is a function that you  may find helpful before you start to use Rainbow's analysis features to apply colours (or patterns) to specified cells, or you can use it later to remove highlighting colours from a specific sheet or range. If you want to clear all cell colours in the workbook, you may prefer to use the Quick Clean-Up function."]
[]
[null,"The remaining three options in the Format Editor dialog box work differently from other Rainbow functions; they allow you to apply certain formatting operations to all cells with the same colour as the cell which is active when you click the Format Editor button. Consequently you need to make sure you have selected an appropriate cell (i.e. one of the type that you wish to change) before you click Format Editor. You can then change the cell colour, font colour or locked status of all cells that match the one you have selected."]
[]
[null,"Note that the final Format Editor option, to turn cell locking on or off, \"toggles\" the locked status of the active cell; if it is currently locked, this option unlocks it (and other matching cells), and if it is currently unlocked, this option locks it. So if the active cell is locked and you wish to turn on cell locking for other cells that match it, you will first need to unlock the active cell. You can do this with Excel's Format Cells dialog box: press Ctrl+1, or click the Home tab, then Format (in the Cells group), then Format Cells, then select the Protection tab."]
[]
[null,"You can use the last three Format Editor options in conjunction with other Rainbow functions. For instance you can click Risk Map, and then select the Dependencies tab and click Non-blank input cells to colour all (non-blank) input cells yellow. You can then select an input cell and click Format Editor to set all matching yellow cells as unlocked. You can now use (Un)Hide/Protect to protect the worksheet, and your input area is ready for use!"]
[]
[null,"When you are changing the formatting of cells in this way, Rainbow offers the options of Loose Matching or Tight Matching:"]
[null,"•  For new font colours, if you select Loose Matching, Rainbow will change any cells that have the same font colour as the current cell, whereas with Tight Matching, it will change only cells with the same font colour and exactly the same cell colour(s)."]
[null,"•  For new cell colours and for cell locking, if you select Loose Matching, Rainbow will change any cells that have any of the colour(s) in the current cell, whereas with Tight Matching, it will change only cells with exactly the same colour(s) as the current cell."]
[]
[null,"The Export and Import Colour Map functions on the split menu (drop-down arrow to the right of Format Editor) let you export and re-import a one-worksheet workbook with the current cell highlighting colours. This means that you can save a particular set of cell highlighting options, and then go back to them at any time later. All you need do is click Export Map Sheet, and then save the Colour Chart workbook (the filename and folder can be anything you choose). To go back to the saved highlighting options, simply open the saved workbook and then click Import Map Sheet."]
[]
[null,"You can also manually edit the colours or colour numbers in the Colour Chart workbook as a way of changing Rainbow's set of cell highlighting colours. However, unless you are making changes to a large number of colours, it is generally preferable to use the colour editing capability within the Colour Chart function."]
[]
[null,"(Un)Hide/Protect"]
[]
[null,"The Hide selected sheets option in the (Un)Hide/Protect dialog box provides a quick way to hide several sheets, including chart sheets as well as worksheets. With the default Very Hidden option (in the (Un)Hide box under the Selection... button), the hidden sheets will be effectively invisible in normal use.  If you choose the Hidden option, the hidden sheets can be unhidden by right-clicking any sheet tab, or from the Hide & Unhide item on the Format menu in the Cells group on the Home tab in Excel."]
[]
[null,"The Unhide all sheets option can unhide any hidden chart sheets as well as worksheets. With the default Very Hidden option, it will unhide both ordinary hidden sheets and any sheets which have been set as very hidden by Rainbow or by another Excel macro.  If you choose the Hidden option it will only unhide sheets which have been hidden in the normal way (i.e. those listed as hidden when you right-click any sheet tab or under the Hide & Unhide menu item mentioned above)."]
[]
[null,"The Unhide rows and columns option will unhide any hidden rows and columns in the selected sheets, and it will display a list of all rows and columns that it has unhidden."]
[]
[null,"The Protect / Unprotect selected sheets options offer a quick way to protect or unprotect several sheets at once, either with or without a password. Rainbow will also protect or unprotect the workbook structure at the same time."]
[]
[null,"User Guide"]
[]
[null,"The User Guide function simply displays this User Guide as an Excel spreadsheet. You can then print, save or close it just like any normal spreadsheet."]
[]
[null,"Rainbow Log"]
[]
[null,"This function displays the contents of the Rainbow log file (RainbowLog.txt), which is stored in a \"hidden\" folder for temporary files, usually at C:\\Users\\[Your user name]\\AppData\\Local\\Temp\\RainbowAnalyst. The exact location of the file is stated at the beginning (on line 2) of the log file itself."]
[]
[null,"The log file holds details of sheets, rows and columns recently unhidden or unprotected (with the Quick Clean-Up or (Un)Hide/Protect functions), defined names converted or deleted, potential risks identified with Risk Map, text cells converted to numbers, rows where dependent checking has been skipped, and duplicate highlighting colours, as well as any occasions when Rainbow processing was interrupted."]
[]
[null,"You can click outside the Rainbow Log dialog box on the underlying Excel worksheet. This means that you can keep the contents of the log file visible on screen while you navigate to find the sheets or cells that it refers to."]
[]
[null,"The log file also stores relevant information in the unlikely event of a system error occurring. In this case, Rainbow will display a single-sheet workbook with the contents of the log file, and this workbook will also list instructions on how to email it very simply to support@themodelanswer.com so that we can resolve the problem for you."]
[]
[null,"To ensure that the log file does not become too large, Rainbow will alert you if the file size exceeds 50 KB and will offer to delete it and start a new file. If you wish to keep the existing file, you can go to the RainbowAnalyst folder and rename the file or copy it to another folder. As mentioned above, the RainbowAnalyst folder is a \"hidden\" folder located under your user name folder at \\AppData\\Local\\Temp\\RainbowAnalyst."]
[]
[null,"If you cannot see the AppData folder under your user name folder, then you need to enable Windows to show hidden files and folders. In Windows Explorer, click Tools and then Folder Options (in Windows XP or Vista) or click Organize and then Folder and search options (in Windows 7). In the Folder Options dialog box, click the View tab, then under Advanced settings, Hidden files and folders, click “Show hidden files, folders and drives”. Click OK, then close and reopen Windows Explorer, and you will see the AppData folder."]
[]
[null,"About Rainbow"]
[]
[null,"This function displays copyright and licensing information, and allows you to enter the registration code if this is currently an unlicensed copy. If you have already licensed your copy of Rainbow, then the About Rainbow box displays information about your licence and about how to access support."]
[]
[null,"Switch Menu"]
[]
[null,"The Switch Menu function toggles between menus; on the Standard menu, it switches to the Advanced menu, and on the Advanced menu it switches to the Standard menu."]
[]
[null,"Preferences"]
[]
[null,"This function displays the Preferences dialog box, so that you can customise Rainbow to reflect your own preferences. When you have set your preferences, you can click Save Defaults to save your preferences to disk as your new defaults. Alternatively you can click Apply to use your new preferences only until you close Rainbow or exit from Microsoft Excel."]
[]
[null,"The Preferences dialog box has five tabs: Reports, Colours, Criteria, Risk Map, and Other Functions. Under the Reports tab, the first set of options tells Rainbow what to do when no workbook has been selected for it to use for reports. This means that, for instance when you first run a report after starting Microsoft Excel, Rainbow can go ahead and generate the report without first having to stop and ask you which workbook to put it in. You can tell Rainbow to do one of four things:"]
[null,"•  First look for a workbook that already appears to contain one or more Rainbow reports (based on cell A2 in the last sheet), and if it does not find one, then to create a new workbook for the report. This is the default option."]
[null,"•  Put the report in the current workbook, i.e. the workbook that is currently visible on your screen. This could be the workbook you are reporting on, or it could be a general Rainbow Reports workbook, and you could then use the Selection... button on the Rainbow dialogue box to select a different workbook to report on."]
[null,"•  Put the report in a new workbook, even if there might be a workbook already open which contains Rainbow reports."]
[null,"•  Ask the user to select a current or new workbook. This was the only option in earlier versions of Rainbow."]
[]
[null,"The remaining options under the Reports tab (in the Individual Reports box) let you select to include all reports in the same workbook (the default setting) or to generate each report as a separate workbook. You can also tell Rainbow to routinely select all worksheets for analysis rather than just the current sheet(s). And you can choose whether Excel displays a warning when you click on a hyperlink, and whether Rainbow should attempt to enable access to Visual Basic code modules (as explained in the Quick Start Guide). If you want Rainbow to attempt to switch on access to Visual Basic next time you start up Excel, just select \"Set VB access next startup\", and click Save Defaults."]
[]
[null,"Under the Colours tab, the most important set of options concerns the use of multi-colour cells. This feature was introduced in Rainbow 7.0, replacing the use of patterns in previous versions, but you can choose to turn it off if you wish Rainbow to behave more like previous versions and show only one colour in each cell. If you allow multiple colours, Rainbow will then be able to show multiple characteristics in a single cell. For instance, the Risk Map function might highlight a cell with three colours, showing that it contains (1) a calculation which has (2) a hard-coded number, and it is also (3) unlocked."]
[]
[null,"Under Multi-Colour Cells on the Colours tab, if the option to allow multiple colours in a cell is enabled, you can then choose various further options:"]
[null,"•  You can set the maximum number of colours allowed in a cell. This can be up to 16 colours, but a high number will slow down Rainbow's analysis, so a setting of 4 to 6 is recommended."]
[null,"•  You can choose what Rainbow does if a cell already contains the maximum number of colours and it wishes to add a further colour. Since Rainbow adds colours from the right, it can either  replace the last colour (on the right) with the new colour and leave the other colours in place, or (the default option) remove the first colour on the left of the cell, shift the other colours along, and then add the new colour on the right."]
[null,"•  You can choose the notional angle (from 1 to 180 degrees) of the boundaries between the colours. A purely vertical or horizontal angle can be confused with the boundaries between neighbouring cells, and so a diagonal angle of around 20 degrees is recommended. The precise actual angle will be different from the notional angle, depending on the width of the cell."]
[]
[null,"There are two other sets of options under the Colours tab:"]
[null,"•  Under Grouped cell colours, you can choose the Start colour number, i.e. which of the 64 group colours Rainbow should start from when selecting colours for the Inter-Sheet Logic, Formula Groups and Comparison Toolbox functions. And the option to Rotate through all colours tells Rainbow to work through all the 64 colours in turn, rather than trying to minimise the number of colours it uses."]
[null,"•  Under Quick Clean-Up, you can select whether you want the Quick Clean-Up function to clear cell colours and patterns."]
[]
[null,"The three sets of options under the Criteria tab allow you to set the threshold values for certain Rainbow functions:"]
[null,"•  Under Excess same-sheet dependents, you can choose what Rainbow does (in Logic Map, Inter-Sheet Logic, the Dependencies tab in Risk Map, and Cell Inspector) when it finds a cell with so many dependents in the same sheet that it takes Excel a long time to list them. If you enter 0 (zero) here, Rainbow will keep going regardless of how long it takes, whereas if you enter a positive number of seconds (the default is 5), then if it takes longer than this to list the dependents for any one cell, Rainbow will skip processing dependents for all further cells on the same row. Where this happens, Rainbow will report the details in the Rainbow Log file (click User Guide, Rainbow Log)."]
[null,"•  Under Complex Formulas, you can set the criteria for marking a formula as complex under the Formulas tab in Risk Map. The number of characters is also used by the Summary Report to decide when to highlight the average and maximum length of formulas."]
[null,"•  Under Row/Column insertion, you can adjust the criteria that are used by the Comparison Toolbox function to decide when rows or columns may have been inserted, and to accept a different row or column as a match for the original one (see Comparison Toolbox for a more detailed explanation)."]
[]
[null,"The six sets of options under the Risk Map tab all relate to options within the Risk Map function:"]
[null,"•  Under  Inconsistent precedent copies, you can select whether you want Rainbow to include cases where a block changes size as the formula is copied along a row; for instance =SUM($A1:B1) includes 2 cells, but it will change to =SUM($A1:C1) (including 3 cells) and so on as the formula is copied along a row. You can also select whether to include inconsistencies in the number format of cells (and this selection also applies to the analysis of Precedent block inconsistencies)."]
[null,"•  Under Precedent block inconsistencies, you can select whether you want Rainbow to check for row differences and column differences (as well as inconsistent cell types and formats); often (e.g. in a SUM() calculation) row and column differences can be a good indicator of possible errors."]
[null,"•  Under Precedents of different cell type, you can choose whether Rainbow should speed up processing by checking only the corner cells in a block of precedents (e.g. A1, D1, A4, D4 where the formula is =SUM(A1:D4)), or whether it should check all cells in the block."]
[null,"•  Under Error values, you can select whether you want Rainbow to highlight and report on all error cells (including those where the error is simply a result of errors in one or more of the precedents), or whether it should show only the error source cells (from which the error originates)."]
[null,"•  Under Hard-Coded Numbers, you can choose whether Rainbow should include \"numbers-only\" formulas such as \"=365/4\" as an instance of hard-coded numbers (under the Formulas tab in Risk Map), or whether it should only look for formulas which include references to other cells."]
[null,"•  Under Numbers formatted as text, you can indicate whether you want Rainbow to recognise numbers preceded or followed by up to three or four letters, e.g. \"¥1000\" or \"568 ml\", as well as straightforward cases of numbers formatted as text. Note that this option affects both the Risk Map function (under the Other tab) and the Format Editor function (option 1)."]
[]
[null,"The four sets of options under the Other Functions tab relate to a number of other Rainbow functions:"]
[null,"•  Under Summary Report, you can indicate whether you want Rainbow to highlight (in yellow and red) specific results which may indicate potential problems. You can also select whether it should insert comments (cell notes) to help you find more detailed analysis of specific items in other Rainbow functions. The option to control highlighting also applies to the highlighting in some Risk Map reports."]
[null,"•  Under Inter-Sheet Logic, you can similarly tell Rainbow whether or not to highlight the logic flows with the highest frequencies. You can also choose to include within-sheet logic (i.e. formulas referencing cells on the same sheet) in the Inter-Sheet Logic report."]
[null,"•  Under Names Toolbox, you can select whether Rainbow uses the descriptions generated by Cell Inspector in the Comments/ (Descriptions) column of the report, and whether it should delete all used names after it has converted them to cell references."]
[null,"•  Under Comparison Toolbox, you can control whether Rainbow automatically inserts rows where it considers they have been deleted, and then whether it deletes them after insertion."]
[]
[null,"The Restore Defaults function (the final item under Menu Settings) lets you restore Rainbow back to its original state (as initially downloaded). This function removes all information about Rainbow from the Windows registry, including any licence data, and so you will need to click User Guide and About Rainbow to re-enter your licence key (registration code)."]
[]
[null,"Restore Defaults"]
[]
[null,"The Restore Defaults function lets you restore Rainbow back to its original state (as initially downloaded). This function removes all information about Rainbow from the Windows registry, including any licence data, and so you will need to click User Guide and About Rainbow to re-enter your licence key (registration code)."]
[]
[null,"Installation and licensing"]
[]
[null,"Rainbow Analyst is usually installed and activated by an installer program (.exe file). However, you can also install it manually by copying the Rainbow add-in (.xlam) file to your Excel Add-Ins folder. You can find this from within Excel by clicking the File tab (or Office Button), then Excel Options, Add-Ins, and Manage Excel Add-ins (click the Go button), then clicking the Browse button. This will open a browse window in the Add-Ins folder, from which you can see where the folder is located."]
[]
[null,"After you have copied the Rainbow file to the Add-Ins folder, you can activate it by going to the Add-Ins window (as above) and then selecting the check box for the current version of Rainbow. You can remove Rainbow at any time simply by deleting the Rainbow add-in file from your Add-Ins folder. Recent versions of Rainbow store some configuration information in the Windows registry, but you can easily remove this with the Restore Defaults function (under Menu Settings)."]
[]
[null,"Rainbow will initially install itself as a 30-day free trial copy. This may be converted to a licensed copy by obtaining a registration code from the author. In the latest versions of Rainbow this code is linked to your name and email address (in earlier versions it was linked to your Excel user name). The licence requires you to use the registration code only for the purchased number of users"]
[]
[null,"Copies of Rainbow can be given to users on other computers, and these will automatically install as 30-day free trial copies. If you use more than one account on the same computer, you can make Rainbow available automatically in all accounts by installing it in C:\\Program Files\\Microsoft Office\\Office[number]\\XLSTART."]
[]
[null,"Mike Shallcross has asserted the moral right to be regarded as the author of Rainbow Analyst, and he holds the copyright in the program code (except for some small code sections as indicated by comments within the program). He can be contacted by email at mike@themodelanswer.com"]
[]
[null,"Note that although Mike has exercised due care and diligence in developing and testing this software, he cannot guarantee its performance, and he cannot be held responsible for any loss or damage, however caused, in connection with the use of this software."]

{"sheet":"Colours","index":1,"n_rows":97,"n_cols":9,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Rainbow Cell Colour Sheet"]
[]
[null,"Cell type","Current","Red","Green","Blue","Reset","TestAll","Favourites"]
[]
[null,"Inconsistent precedent copies",null,0,204,254,null,true,false]
[null,"Precedent block inconsistencies",null,203,51,153,null,true,false]
[null,"Precedents only part of block",null,153,0,203,null,true,false]
[null,"Precedents referring forwards",null,203,203,254,null,true,false]
[null,"Precedents of different cell type",null,51,51,152,null,true,false]
[null,"Cells with blank precedents",null,0,152,102,null,true,false]
[null,"Error values",null,102,203,203,null,true,true]
[null,"Hard-coded numbers (all)",null,102,0,203,null,false,false]
[null,"Multi-digit hard-coded numbers",null,153,102,254,null,false,true]
[null,"Row differences",null,51,254,254,null,true,false]
[null,"Column differences",null,0,153,203,null,true,false]
[null,"Formatting differences",null,254,51,153,null,true,false]
[null,"Complex formulas",null,153,203,0,null,false,true]
[null,"Array formulas",null,51,204,254,null,false,true]
[null,"Blank input cells",null,254,0,0,null,true,false]
[null,"Non-blank input cells",null,254,254,0,null,true,false]
[null,"Intermediate workings",null,0,254,0,null,true,false]
[null,"Output calculations",null,0,0,254,null,true,false]
[null,"Labels",null,254,0,254,null,true,false]
[null,"Lookup and related functions",null,153,203,153,null,false,false]
[null,"Lookup requiring ordered list",null,203,102,51,null,false,true]
[null,"Constant numbers",null,152,102,152,null,false,false]
[null,"Calculated numbers",null,0,203,102,null,false,false]
[null,"Text values",null,102,153,203,null,false,false]
[null,"Numbers formatted as text",null,203,102,153,null,false,true]
[null,"Same font and background colour",null,102,254,51,null,true,true]
[null,"Unlocked cells (all)",null,254,204,51,null,true,false]
[null,"Unlocked formula cells",null,152,102,102,null,true,true]
[null,"Group 01",null,204,254,153]
[null,"Group 02",null,254,153,102]
[null,"Group 03",null,153,153,254]
[null,"Group 04",null,152,0,152]
[null,"Group 05",null,203,153,153]
[null,"Group 06",null,153,51,203]
[null,"Group 07",null,204,254,0]
[null,"Group 08",null,51,153,254]
[null,"Group 09",null,102,152,102]
[null,"Group 10",null,153,254,51]
[null,"Group 11",null,203,51,0]
[null,"Group 12",null,153,204,254]
[null,"Group 13",null,203,102,0]
[null,"Group 14",null,152,152,152]
[null,"Group 15",null,254,254,102]
[null,"Group 16",null,102,102,152]
[null,"Group 17",null,203,203,51]
[null,"Group 18",null,203,102,203]
[null,"Group 19",null,254,51,51]
[null,"Group 20",null,102,102,254]
[null,"Group 21",null,101,101,101]
[null,"Group 22",null,254,102,51]
[null,"Group 23",null,204,254,51]
[null,"Group 24",null,254,153,254]
[null,"Group 25",null,102,0,254]
[null,"Group 26",null,204,254,102]
[null,"Group 27",null,203,0,203]
[null,"Group 28",null,152,0,102]
[null,"Group 29",null,102,203,153]
[null,"Group 30",null,0,51,203]
[null,"Group 31",null,0,203,153]
[null,"Group 32",null,254,204,153]
[null,"Group 33",null,254,102,254]
[null,"Group 34",null,102,203,51]
[null,"Group 35",null,204,51,254]
[null,"Group 36",null,153,254,204]
[null,"Group 37",null,254,102,204]
[null,"Group 38",null,0,102,203]
[null,"Group 39",null,153,254,0]
[null,"Group 40",null,203,102,102]
[null,"Group 41",null,0,203,203]
[null,"Group 42",null,204,204,254]
[null,"Group 43",null,254,51,0]
[null,"Group 44",null,152,51,152]
[null,"Group 45",null,51,102,152]
[null,"Group 46",null,153,203,102]
[null,"Group 47",null,153,203,203]
[null,"Group 48",null,153,0,254]
[null,"Group 49",null,102,152,51]
[null,"Group 50",null,51,254,102]
[null,"Group 51",null,204,0,254]
[null,"Group 52",null,102,51,152]
[null,"Group 53",null,51,203,51]
[null,"Group 54",null,102,0,152]
[null,"Group 55",null,102,51,254]
[null,"Group 56",null,254,153,51]
[null,"Group 57",null,203,51,51]
[null,"Group 58",null,0,152,152]
[null,"Group 59",null,153,254,102]
[null,"Group 60",null,102,254,204]
[null,"Group 61",null,51,102,254]
[null,"Group 62",null,254,0,204]
[null,"Group 63",null,152,102,0]
[null,"Group 64",null,203,203,203]

{"sheet":"Preferences","index":2,"n_rows":105,"n_cols":7,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["Preferences sheet"]
[null,null,null,null,null,"Current","Report"]
["Note mapping information in columns F:G"]
[]
["Current book/sheets and report book/sheets"]
[]
["UserDetails","Original","Original"]
[]
["UserName"]
["UserEmail"]
["UserCode"]
["ExpiryDate","2015-02-15T10:16:21"]
["StdMenu",true,true]
[]
["GenlPrefers","Current","Original"]
[]
["Reporting"]
["ReportOption",1,1]
["SameRptBook",true,true]
["RptBookName"]
["AllSheets",false,false]
["NoWarnings",true,true]
["EnableVBOM",true,true]
["VBOMNext",true,true]
[]
["Multi-Colour Cells"]
["ColrOverlap",true,true]
["ColrLimit",6,6]
["ShiftFIFO",true,true]
["ColrAngle",20,20]
[]
["Mapping"]
["ColrStart",1,1]
["ColrRotate",true,true]
["QuickClear",true,true]
["DoMap",false,false]
["ColrNames",true,true]
[]
["Summary Report"]
["TrafficLights",true,true]
["ExpComments",true,true]
[]
["Inter-Sheet"]
["IShtReport",true,true]
["IShtLights",true,true]
["IncLocals",false,false]
[]
["Risks and Dependencies"]
["OthReport",true,true]
["InsComments",false,false]
["ShowTime",5,5]
[]
["Inconsistent copies"]
["SizeChanges",true,true]
["FormatDiffs",false,false]
[]
["Inconsistent precedents"]
["RowColDiffs",true,true]
[]
["Different cell type"]
["OnlyCorners",false,false]
[]
["Cell errors"]
["ErrorSources",false,false]
[]
["Hard-coded numbers"]
["AllNumbers",true,true]
[]
["Complex formulas"]
["LongChars",100,100]
["NestedIfs",2,2]
[]
["Numbers formatted as text"]
["DetectLetters",true,true]
[]
["Defined Names"]
["UseInspector",false,false]
["NameDelete",false,false]
[]
["Formula Groups"]
["FGrpReport",true,true]
["UseDesc",false,false]
[]
["Comparison"]
["RowInsert",true,true]
["RowDelete",true,true]
["CellsChecked",4,4]
["CellsDiffer",40,40]
["CellsMatch",70,70]
[]
["CompWkshts","Current","Original"]
[]
["CompForms",true,true]
["CompVals",false,false]
["CompInclude",true,true]
[]
["GroupForms",true,true]
["SepForms",false,false]
[]
["CompRangeAll",true,true]
["CompRangeFix",false,false]
["CompRangeVary",false,false]
[]
["CompColour",true,true]
["CompMap",false,false]

{"sheet":"Control","index":3,"n_rows":999,"n_cols":27,"rows_kept":999,"cut":false,"hidden":false,"merged":[]}
["Control sheet"]
[null,null,null,null,"Book","Sheet","Cell",null,null,"Precede","Book","Sheet","Cell","Type","Value","Description","Visible",null,null,"Depend","Book","Sheet","Cell","Type","Value","Description","Visible"]
["WkBook"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]
["UsedRng"]

{"sheet":"Temp","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}