{"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":78,"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":910,"n_cols":2,"rows_kept":910,"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$58),\"000\") & \"      \"&$B$58","v":"058      Quick Start Guide"}]
[null,{"$f":"TEXT(ROW($B$79),\"000\") & \"            \"&$B$79","v":"079            Helpful Hints"}]
[null,{"$f":"TEXT(ROW($B$116),\"000\") & \"            \"&$B$116","v":"116            Main Functions"}]
[null,{"$f":"TEXT(ROW($B$145),\"000\") & \"            \"&$B$145","v":"145            Subsidiary Functions"}]
[null,{"$f":"TEXT(ROW($B$172),\"000\") & \"      \"&$B$172","v":"172      Function Details"}]
[null,{"$f":"TEXT(ROW($B$176),\"000\") & \"            \"&$B$176","v":"176            Summary Report"}]
[null,{"$f":" TEXT(ROW($B$208),\"000\") & \"            \"&$B$208","v":"208            Hide/Protect"}]
[null,{"$f":"TEXT(ROW($B$218),\"000\") & \"            \"&$B$218","v":"218            Formula Scan"}]
[null,{"$f":"TEXT(ROW($B$238),\"000\") & \"            \"&$B$238","v":"238            Logic Map"}]
[null,{"$f":"TEXT(ROW($B$270),\"000\") & \"            \"&$B$270","v":"270            Logic Colours"}]
[null,{"$f":"TEXT(ROW($B$276),\"000\") & \"            \"&$B$276","v":"276            Issue Tracker"}]
[null,{"$f":" TEXT(ROW($B$298),\"000\") & \"            \"&$B$298","v":"298            Issues Report"}]
[null,{"$f":" TEXT(ROW($B$304),\"000\") & \"            \"&$B$304","v":"304            Delete Issues"}]
[null,{"$f":"TEXT(ROW($B$310),\"000\") & \"            \"&$B$310","v":"310            Inter-Sheet Logic"}]
[null,{"$f":"TEXT(ROW($B$328),\"000\") & \"            \"&$B$328","v":"328            Data Links"}]
[null,{"$f":"TEXT(ROW($B$334),\"000\") & \"            \"&$B$334","v":"334            Data Explorer"}]
[null,{"$f":"TEXT(ROW($B$360),\"000\") & \"            \"&$B$360","v":"360            Macro Explorer"}]
[null,{"$f":"TEXT(ROW($B$372),\"000\") & \"            \"&$B$372","v":"372            Cell Inspector"}]
[null,{"$f":" TEXT(ROW($B$388),\"000\") & \"            \"&$B$388","v":"388            Merged Cells Tool"}]
[null,{"$f":" TEXT(ROW($B$396),\"000\") & \"            \"&$B$396","v":"396            Names Toolbox"}]
[null,{"$f":"TEXT(ROW($B$432),\"000\") & \"            \"&$B$432","v":"432            Risk Map"}]
[null,{"$f":"TEXT(ROW($B$516),\"000\") & \"            \"&$B$516","v":"516            Logic Analysis"}]
[null,{"$f":"TEXT(ROW($B$580),\"000\") & \"            \"&$B$580","v":"580            Analysis Wheel"}]
[null,{"$f":"TEXT(ROW($B$601),\"000\") & \"            \"&$B$601","v":"601            Import Colours"}]
[null,{"$f":" TEXT(ROW($B$609),\"000\") & \"            \"&$B$609","v":"609            Save Format"}]
[null,{"$f":" TEXT(ROW($B$617),\"000\") & \"            \"&$B$617","v":"617            Undo Changes"}]
[null,{"$f":" TEXT(ROW($B$629),\"000\") & \"            \"&$B$629","v":"629            File Save As"}]
[null,{"$f":" TEXT(ROW($B$635),\"000\") & \"            \"&$B$635","v":"635            Quick Clean-Up"}]
[null,{"$f":" TEXT(ROW($B$643),\"000\") & \"            \"&$B$643","v":"643            Clean Up Formats"}]
[null,{"$f":" TEXT(ROW($B$653),\"000\") & \"            \"&$B$653","v":"653            Trim Unused Space"}]
[null,{"$f":"TEXT(ROW($B$661),\"000\") & \"            \"&$B$661","v":"661            Comparison Toolbox"}]
[null,{"$f":" TEXT(ROW($B$700),\"000\") & \"            \"&$B$700","v":"700            Sample Data"}]
[null,{"$f":" TEXT(ROW($B$712),\"000\") & \"            \"&$B$712","v":"712            Scramble Workbook"}]
[null,{"$f":"TEXT(ROW($B$722),\"000\") & \"            \"&$B$722","v":"722            Identify Colours"}]
[null,{"$f":"TEXT(ROW($B$730),\"000\") & \"            \"&$B$730","v":"730            Format Editor"}]
[null,{"$f":" TEXT(ROW($B$744),\"000\") & \"            \"&$B$744","v":"744            Colour Chart"}]
[null,{"$f":" TEXT(ROW($B$756),\"000\") & \"            \"&$B$756","v":"756            Clear Cell Colours"}]
[null,{"$f":" TEXT(ROW($B$766),\"000\") & \"            \"&$B$766","v":"766            Graphics Report"}]
[null,{"$f":" TEXT(ROW($B$770),\"000\") & \"            \"&$B$770","v":"770            Delete Graphics"}]
[null,{"$f":" TEXT(ROW($B$774),\"000\") & \"            \"&$B$774","v":"774            User Guide"}]
[null,{"$f":" TEXT(ROW($B$778),\"000\") & \"            \"&$B$778","v":"778            Rainbow Log"}]
[null,{"$f":"TEXT(ROW($B$792),\"000\") & \"            \"&$B$792","v":"792            About Rainbow"}]
[null,{"$f":"TEXT(ROW($B$796),\"000\") & \"            \"&$B$796","v":"796            Check For Updates"}]
[null,{"$f":" TEXT(ROW($B$804),\"000\") & \"            \"&$B$804","v":"804            Preferences"}]
[null,{"$f":" TEXT(ROW($B$851),\"000\") & \"            \"&$B$851","v":"851            Reset Reports"}]
[null,{"$f":" TEXT(ROW($B$859),\"000\") & \"            \"&$B$859","v":"859            Restore Defaults"}]
[null,{"$f":" TEXT(ROW($B$863),\"000\") & \"            \"&$B$863","v":"863            Uninstall"}]
[null,{"$f":"TEXT(ROW($B$867),\"000\") & \"      \"&$B$867","v":"867      License Agreement"}]
[]
[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 switch on access to Excel's Visual Basic modules in order to create interactive reports. In most cases you can just follow Rainbow's prompts to resolve this issue, and 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 later if you want Rainbow to try again to switch on access to Visual Basic, just click Preferences, then select \"Set VB access next startup\", and click Save Defaults."]
[]
[null,"There are now two main versions of Rainbow (as well as the simpler Rainbow Personal version). Rainbow Professional is the current version of our flagship product, with all the tools you need for analysing any Excel spreadsheet. And Rainbow Governance adds an additional layer of functions for analysing and tracking changes across your whole inventory of Excel spreadsheets. The additional Governance functions are supplied through third-party software and come with their own User Guide, so this User Guide is all about the functions in Rainbow Professional."]
[]
[null,"Rainbow installs itself as an additional Rainbow tab on the Excel ribbon menu. Most of the items on the Rainbow tab are \"split buttons\"; you can click the top of the button to go straight to one of Rainbow's main functions, or you can click the bottom part to access a menu of subsidiary functions. If you are using Rainbow Governance, you will see an additional \"Governance\" group at the start of the Rainbow tab before the Rainbow Professional functions."]
[]
[null,"You can use just a few of the main functions along with Rainbow's workflow management features  to make systematic spreadsheet auditing as easy as 1-2-3:"]
[null,"• 1)  Run the Summary Report function to get a high-level overview of the spreadsheet. Decide what action is required to address any problems highlighted on the report, particularly any red highlights."]
[null,"• 2)  Run the Formula Scan function, with formula checking and issue flagging turned on. Visually inspect the resulting colour map of formula groups, and investigate any obvious inconsistencies or isolated formulas."]
[null,"• 3)  Use the Issue Tracker (F10) to work systematically through issues that Rainbow has identified and flagged, and record the results. You can also use the Cell Inspector (ALT+F10) to check the logic of any suspicious formulas."]
[]
[null,"The Issue Tracker lets you generate a report on flagged issues in the current sheet. If you are working in a team, you can click the Issue Tracker menu and use the Issues Report function to report on all flagged issues in the workbook. You can then share the report with your colleagues to coordinate progress on the audit."]
[]
[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 this User Guide for full information on the terms of the License Agreement that you accepted when installing your Rainbow license."]
[]
[null,"Helpful Hints"]
[]
[null,"When you click a button on the Rainbow 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). And if your currently selected worksheet is a Rainbow report, Rainbow will assume that you want to analyse the reported-on workbook rather than the report workbook itself."]
[]
[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. 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)."]
[]
[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 often 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 the Reports tab) to turn this message back on ."]
[]
[null,"It is usually a good idea to make a copy of your workbook that you can use for analysis by Rainbow, so that it does not matter when Rainbow adds highlighting to the workbook. However, it is also possible to 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. 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 you can run the Summary Report function by pressing Alt, then B (for Rainbow), then S (for Summary Report). And three functions now have special shortcuts using the keyboard function keys:"]
[null,"•  ALT+F9 runs the Identify Colours function"]
[null,"•  F10 runs the Issue Tracker"]
[null,"•  ALT+F10 runs the Cell Inspector"]
[]
[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 usually see that Rainbow is still working away by looking at the progress message in the status bar (near the bottom of the screen), though sometimes this too may freeze. If you do need to interrupt Rainbow, just press Esc or Ctrl+Break (sometimes you may need to do this more than once)."]
[]
[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,"You can scroll up and down through the help text with your mouse scroll wheel or the Page Up, Page Down, and cursor keys. The mouse scroll wheel is enabled by default for scrolling through the help text, but it can sometimes (depending on your hardware) cause Excel to malfunction. If this happens, you can simply disable it in your Preferences under the Options tab."]
[]
[null,"Main Functions"]
[]
[null,"The Rainbow tab (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. In this section we cover the main functions in each group; the subsidiary functions (on the drop-down menu under each main function) are explained in the next section."]
[]
[null,"The Basics group consists of two functions that can quickly diagnose a large number of spreadsheet problems and issues, plus a function to help you to track and resolve the issues:"]
[null,"•  Summary Report gives you a quick overview of a workbook and a overall quality score, and highlights possible issues for further analysis."]
[null,"•  Formula Scan highlights (and reports on) groups of copied formulas, and it also runs a battery of tests on the first formula in each group."]
[null,"•  Issue Tracker is another interactive function which enables you to track and annotate progress on resolving issues flagged by you or by Rainbow. "]
[]
[null,"In The Details group are four functions which tell you about the flow of data and logic in the spreadsheet, either by generating colour \"maps\" to help you visualise the spreadsheet calculations, or by helping you to follow the details of the logic:"]
[null,"•  Inter-Sheet Logic generates a tabular matrix that shows you the flow of logic between sheets in your 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, and is very useful in conjunction with Formula Scan."]
[null,"•  Risk Map is a powerful analysis tool which can report on up to 24 different types of potential risk and highlight all the relevant cells in different colours."]
[]
[null,"The My Files group contains several utility functions to help you manage individual workbooks and track changes between different versions of spreadsheets:"]
[null,"•  The initial set of three functions is about change management. You can use Save Format to record the current formatting of your selected worksheet(s), so that you can then restore it/them again using Undo Changes. And File Save As works like the File Save As item on the Excel menu, except that it also makes sure that Rainbow recognises the old file under its new name."]
[null,"•  Quick Clean-Up gives you a simple and fast way to prepare a workbook for analysis by unhiding hidden items, unprotecting worksheets, and optionally clearing cell colours."]
[null,"•  Comparison Toolbox is a comprehensive function that compares workbooks, worksheets or ranges, giving you a key tool for controlling versions and scenarios."]
[]
[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,"•  Identify Colours gives you an explanation of the Rainbow colour(s) in the selected cell, and lets you search for other similarly-highlighted cells."]
[null,"•  Colour Chart gives you an interactive visual display of all the colours that Rainbow uses to map different types of cells."]
[null,"•  Clear Cell Colours removes existing cell colours so that you can see when Rainbow adds its own highlights, and it can also remove the Rainbow highlights."]
[]
[null,"And finally in the Help group are two menu buttons that give you access to important information and options:"]
[null,"•  The User Guide button lets you view and print this User Guide."]
[null,"•  Preferences enables you to change a wide range of options and settings."]
[]
[null,"Subsidiary Functions"]
[]
[null,"Here we cover the functions on the drop-down menu under each of the main functions. You will notice that each drop-down menu also includes the main function; this is to allow you to access both the main and the subsidiary functions using the keyboard shortcuts."]
[]
[null,"In The Basics group:"]
[null,"•  Under Summary Report, Hide/Protect can hide or unhide and protect or unprotect selected worksheets, and also unhide hidden rows and columns."]
[null,"•  Under Formula Scan, Logic Map gives you a visual picture that helps you quickly grasp the flow of calculation from inputs through workings to final results, and Logic Colours provides a key to the colours used in the Logic Map and lets you search for them in the worksheet."]
[null,"•  Under Issue Tracker, Issues Report generates a report on all flagged issues and/or all comments (cell notes) in the workbook. Delete Issues correspondingly lets you delete all flagged issues and/or all comments."]
[]
[null,"In The Details group:"]
[null,"•  Under Inter-Sheet Logic, Data Links helps you track down where your spreadsheet calculations are linked to individual cells in another workbook."]
[null,"•  Under Data Explorer, Macro Explorer lets you easily see any macros in the workbook and get a sense of how they affect your workbook data."]
[null,"•  Under Cell Inspector, Merged Cells Tool gives you a report on merged cells and various options for unmerging them, and Names Toolbox provides a range of tools to help you audit and control the use of defined names in the workbook logic."]
[null,"•  Under Risk Map, Logic Analysis can report on up to 12 potential issues related to dependency logic, and Analysis Wheel lets you select from Rainbow's whole range of analysis options, run the analysis, and then review the highlighted cells in the current sheet."]
[]
[null,"In the My Files group:"]
[null,"•  Under Quick Clean-Up, Clean Up Formats removes superfluous formats (which can generate an Excel error message), and Trim Unused Space removes blank space around the used area of a worksheet (which can cause bloating)."]
[null,"•  Under Comparison Toolbox, Sample Data selects a random or periodic sample of data from a worksheet and copies it to a report for further auditing. Scramble Workbook replaces the data and text in a workbook with meaningless values, so that you can send it to Rainbow support or to colleagues who may need to examine the workbook structure but not the data."]
[]
[null,"In the My Colours group:"]
[null,"•  Under Identify Colours, Format Editor works in conjunction with other Rainbow functions to enable you to apply formatting changes or convert text to numbers."]
[null,"•  Under Clear Cell Colours, Graphics Report lets you generate a detailed report on buttons and graphics (e.g. charts), and Delete Graphics removes all such graphics from the workbook or selected worksheet(s)."]
[]
[null,"In the Help group:"]
[null,"•  Under User Guide, Rainbow Log lets you view the Rainbow log file, About Rainbow enables you to license or re-license your copy of Rainbow, and Check For Updates can automatically install the latest updated version of Rainbow."]
[null,"•  Under Preferences,  Reset Reports lets you tell Rainbow that you want it to put reports in a different workbook from the one it is currently using, Restore Defaults restores the factory default settings, and Uninstall removes Rainbow from your system."]
[]
[null,"Function Details"]
[]
[null,"This section covers all of the functions on Rainbow's Standard menu, and options which are specific to particular functions are explained in detail below."]
[]
[null,"Summary Report"]
[]
[null,"It is always worth generating a Summary Report before looking at a spreadsheet in detail. The report is quick to produce, and as well as giving an overall quality rating for the spreadsheet, it can indicate unexpected issues such as Visual Basic code, hidden sheets or hard-coding in formulas. Issues which have impacted the overall quality rating will be highlighted in yellow (somewhat significant) or red (very significant). 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,"Under \"Formula checking\" on the Summary Report dialogue box, you can select the level of criterion used for detecting lone formulas. In the case of a badly-structured spreadsheet the default \"Enhanced\" level may generate too many results to be useful, and you may prefer to select Basic detection. Conversely with a very well-structured spreadsheet you may find Maximum detection most useful. And if you find you are regularly changing the default option, you can select your preferred default option in Preferences, under the Parameters tab."]
[]
[null,"By default Rainbow will check for lone formulas but not produce a separate report. If you find you often then use the Risk Map function to generate a Lone formulas report, it will probably prove quicker to check the \"Generate Lone Fmlas report\" box and generate this report alongside the Summary Report. On the other hand, if your spreadsheets are so large that even checking for lone formulas takes too long, you can click the drop-down box and select \"Do not check formulas\" to run a very quick Summary Report without any detailed formula checking. Columns I to O of the sheet listing in the Summary Report (and the overall score) will then be left blank."]
[]
[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 24 function buttons on the report (in column C and in row 26) to go directly to the appropriate Rainbow function for more detailed analysis. There are also 2 buttons (in column J) which allow you to turn on or off the display of graphical objects and sheet tabs."]
[]
[null,"Note that if access to Visual Basic modules has not been switched on, you can still use the Summary Report, but the function buttons will not be present, and instead the explanatory comments (cell notes) will tell you how to access the relevant Rainbow functions for more detailed analysis. In addition, cells B11, 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,"Most of the data items in the Summary Report are self-explanatory, but there are a few which deserve further explanation:"]
[null,"•  The Visual Basic (VB) project name in row 11 can be useful as it often indicates the file name under which the workbook was originally saved."]
[null,"•  The Orignl name column shows a shortened form of the name with which each sheet was originally created, e.g. Sheet1 or Chart1. This can indicate the order in which the sheets were first developed."]
[null,"•  The Data cells column shows constant (non-calculated) cells as a percentage of total cells, and it  simply indicates whether a sheet is primarily used for data input (high Data cells value) or for calculation (low Data cells value)."]
[null,"•  Lone fmlas are cells which have a different formula from the formula which appears in the majority of the 8 immediately surrounding cells. Such lone formulas often indicate a problem, which is why the Summary Report can optionally be accompanied by a Lone Fmlas report identifying each instance."]
[null,"•  Copied fmla groups shows the number of blocks of copied formulas in each sheet. In practice this is a more useful metric than the number of unique formulas, because if the same formula appears twice in different contexts, each occurrence will still need to be checked. The Formula Scan function gives you a more precise calculation of formula groups, and may yield a slightly lower number than shown here."]
[null,"•  The Max fmla ops (maximum formula operations) column uses the same metric as the Complex operations report in the Risk Map function, and you can click the hyperlink to go directly to the most complex formula in each sheet."]
[null,"•  The Fmla complexity column uses a metric of formula complexity to assess the likely degree of difficulty involved in auditing the formulas in each sheet, based on average formula complexity and the number of copied formula groups."]
[null,"•  The Hard-coded numbers, Lookup functions, and Array formulas columns show you the numbers of formula groups in which these three items occur, rather than the number of individual formulas (which would generally be much larger)."]
[null,"•  The Macro buttons + objects column shows the number of macro buttons + the number of other graphic objects, which will include charts as well as e.g. form controls."]
[null,"•  The Merged cells x area column shows the number of merged cells and the total area (number of individual cells) covered. So if there are 2 merged cells each covering an area of 3 cells, this will be displayed as \"2x6\"."]
[]
[null,"If you have selected to generate the Lone Fmlas report, this will be on the sheet tab after the Summary Report. It gives you a detailed breakdown of the results in the Lone fmlas column of the Summary Report. It uses the same algorithm as the Lone formulas report in Risk Map, but it generally runs much more quickly. Column E in the report shows an example of the formula in the surrounding cells, preceded by the address of the relevant neighbouring cell in [square brackets]."]
[]
[null,"By default the Summary Report will calculate an overall quality score for the workbook. This is based on a complex algorithm weighting about 20 different indicators, but it is only intended as a general guide, and it will be most helpful when applied to spreadsheets of the kind normally used for financial calculations. The score is calculated on the basis of detailed cell-by-cell analysis, and it can be turned off by selecting \"Do not check formulas\" in the drop-down box under \"Formula checking\" on the Summary Report dialog box."]
[]
[null,"Also by default the Summary Report will highlight in yellow (somewhat significant) or red (very significant) the values which have most impacted the overall quality score. The highlighting indicates which areas need to change in order to improve the quality score, but of course a highlight 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 Options tab in your Preferences settings. Here you can also turn off the explanatory comments (cell notes) attached to the cells behind each button."]
[]
[null,"Note that the Summary Report, the Data Links function, the Names Toolbox option to convert names, and the 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,"Hide/Protect"]
[]
[null,"The Hide selected sheets option in the 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 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,"Formula Scan"]
[]
[null,"The Formula Scan function analyses row and column differences to identify groups of copied formulas, and it then uses Rainbow's Item number colours (for more information see the Colour Chart section) 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,"In addition, Formula Scan can run a battery of tests on the first formula in each group, and it can flag some or all formulas so that progress on auditing them and resolving issues can be tracked with the Issue Tracker function."]
[]
[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,"Under \"Risk checking and issue flagging\", you can select which checks you want Rainbow to carry out on the first formula in each group. The checks are drawn from both the Risk Map and the Logic Analysis functions, and you can select whether to carry out all relevant checks or just the \"favourite\" options. Note that there are some checks which are not included even when you select \"Check for all risks and all logic issues\", either because the checks are not applicable to formulas, or because they involve comparison with other adjacent cells, or because they are simply a form of highlighting. You can see these excluded options if you go to Risk Map or Logic Analysis and click the \"Risks/Issues not in Formula Scan\" button."]
[]
[null,"In the Risk checking and issue flagging box, you can also select whether you want Rainbow to flag up either all cells, or all cells with issues (where one or more of the selected checks proves positive). Rainbow will then place a red \"Query\" flag (diagonal line) across all the relevant cells, and if the Insert comments option is selected, it will also add a custom comment listing all checks which have proved positive. Both the flag and the comment can then be tracked and edited with the Issue Tracker function."]
[]
[null,"As well as mapping formula groups with colours, Rainbow normally generates a report which lists each formula group by row or column, showing the first and last occurrence and the number of occurrences of each formula, and any checks which have proved positive (shown by the colours in column G, with an optional attached comment). 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 Item 1, then Item 2, Item 3 and so on, but you can set your Preferences (under Grouped cell colours on the Colours tab) to start with a different colour (e.g. at the Item 10 colour rather than at Item 1). And by default the Preferences are set to Rotate through all colours, which means that for each new formula group Rainbow will simply use the next available colour (i.e. the colour for Item 1, Item 2, Item 3 etc.). If you uncheck this option, Rainbow will use the minimum number of colours needed to distinguish different formula groups (while using consistent colours for formulas in each row or column)."]
[]
[null,"Logic Map"]
[]
[null,"All cells in a spreadsheet can be placed in one of the following 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,"•  Circular references are intermediate workings which link back to themselves."]
[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 dependency types listed above, or the number of dependents of each cell, or both. For numbers of dependents Rainbow uses the corresponding Item number colour, which you can see with the Analysis Wheel; for instance a cell with 3 dependents will be highlighted in the Item 3 colour."]
[]
[null,"If you select to map the dependency types, then after creating the map Rainbow will display the Logic Colours dialog box, with 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 Identify 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 Logic Analysis 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 the Logic Analysis function (on the Advanced Menu) to check for all cells which have blank cells as precedents."]
[]
[null,"The Logic Map function will detect circular references where the all the cells involved in the circular chain of calculations are in the same worksheet. However, if the calculation chain goes outside the current worksheet, the Logic Map function will highlight the circular reference cell shown in the Excel status bar (provided that this is an intermediate working), but it will not show the whole calculation chain. (To see this, click the drop-down arrow beside Error Checking in the Formula Auditing group on the Formulas tab in Excel, then hover over Circular References.)"]
[]
[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 Logic Analysis function (under the Dependencies tab, or click the \"Inputs and other dependencies\" button)."]
[]
[null," Alternatively you can use the Risk Map function to generate a different kind of map showing constant and calculated numbers and text cells (options 1 to 4 under the Options tab, or click the \"Constants, formulas and text cells\" button)."]
[]
[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 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 Identify Colours function (with Matching set as Loose), and just as in the Identify 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 Identify 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,"Issue Tracker"]
[]
[null,"The Issue Tracker function (which you can invoke by pressing the F10 key) lets you work systematically through cells which have been flagged, and create or edit messages which you can pass on to colleagues indicating outstanding work to be completed or issues that have been resolved."]
[]
[null,"When you invoke the Issue Tracker, it looks at the currently active cell to see whether it has either or both of the following:"]
[null,"•  A flag, which can have one of three values: Resolved (green upwards diagonal), Query (red downwards diagonal), or Error (red diagonal cross)."]
[null,"•  A custom Rainbow comment, i.e. a comment with a blue background and starting with the numeral ① followed by the date and user name."]
[]
[null,"In the Issue Tracker window, the current flag value is indicated by blue highlighting on one of the four buttons at the top right. You can change the flag at any time (or clear it entirely) by clicking on the relevant button. And sometimes this may be all that you need in order to manage your spreadsheet auditing process."]
[]
[null,"If you need to indicate more clearly which issues are the most urgent, you can set a priority level for any of the three flags. When you first apply a flag to a cell, the priority will be 0 (i.e. no priority), and you can change this at any time."]
[]
[null,"For a much more sophisticated level of workflow management, particularly when working in a team, you can use the Issue Tracker's messaging system. This is based on custom Rainbow comments as described above, allowing each comment to carry within it any number of separate messages. The Issue Tracker detects the number of messages in each comment, and it displays the most recent message in the message window. If the messages are from more than one user, the Issue Tracker will display a different background colour for each user so that you can easily see where there is a dialogue going on between different users."]
[]
[null,"You can scroll backwards and forwards through all the messages simply by clicking or right-clicking in the message window, or by using the scroll bar on the left. And where a message is too long to fit into the message window, you can scroll up and down through the text of the message with your mouse scroll wheel."]
[]
[null,"You can easily add a message to any comment (or to a cell without any comments) by clicking where indicated in the editing box. This box will then expand so that you can type your message, and you can click the Post message button to add your message (or the Cancel button to leave the comment unchanged). And you can click the Delete button to delete all messages (the entire comment) for the current cell."]
[]
[null,"When you have finished viewing or editing flags or messages for the current cell, you can click the Previous cell or Next cell button to search for other flagged cells in the current sheet. You can also click the Report button to generate a report listing all flagged cells in the current sheet. And the Issue Tracker window (like the Cell Inspector) also allows you to click outside it on the underlying spreadsheet, and you can even switch to a different sheet to continue the audit process."]
[]
[null,"If you are working in a team and you need a report on all flagged cells in the entire workbook, just switch to the Advanced Menu and click the Issues Report button. This generates a report for all sheets by default."]
[]
[null,"Issues Report"]
[]
[null,"The issues report lists either flagged issues or standard Excel comments (or both):"]
[null,"•  For flagged issues, it lists both the current flag and the messages (if there are any), showing the number of messages and the date, author and text of the last message. In column D it shows the current flag as a number from 1 to 3, so that you can filter this column to show only cells with a particular level of flag (i.e. 1 for Resolved, 2 for Query, and 3 for Error). Similarly you can filter or sort the Priority level (1 to 9) in column C."]
[null,"•  For standard Excel comments (cell notes), the report lists the text of the comment together with the author's name and the cell address and value."]
[]
[null,"Delete Issues"]
[]
[null,"With the Delete Issues function you can quickly clear from a workbook or worksheet(s) either the flagged issues created by Rainbow's Issue Tracker system, or standard Excel comments (cell notes), or both. This can be particularly useful after running the Formula Scan, Risk Map, or Logic Analysis functions."]
[]
[null,"Before you use Delete Issues to remove any existing comments, you might first wish to list them with the Issues Report function, which lets you report on both the standard Excel comments and Rainbow's own custom comments."]
[]
[null,"Inter-Sheet Logic"]
[]
[null,"The Inter-Sheet Logic function uses Rainbow's Item number colours (Item 1, Item 2 etc.) 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 Options tab) to turn off the highlighting."]
[]
[null,"You also have an option in your Preferences settings (under the Options tab) 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 Logic Analysis 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,"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 graphical shapes, 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,"The Data Links report lists all the occurrences of each link in turn, and the linked file name in column A of the report is highlighted on alternate rows to indicate the link number. So references to a specific link will all be highlighted (on alternate rows) in the same colour, and you can select a highlighted cell and click Identify Colours, and for instance the third link will be identified as \"Item 3\"."]
[]
[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 only for 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 your Macro Security settings allow this (see the Quick Start Guide for more details). And even if you have set up the appropriate Macro Security settings, Rainbow will be unable to access the information if the Visual Basic code has been password-protected."]
[]
[null,"Cell Inspector"]
[]
[null,"The Cell Inspector (which you can invoke by pressing ALT+F10) 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 Hide/Protect function first if you think there may be any links to hidden sheets."]
[]
[null,"If you have selected a cell with hundreds or even thousands of dependents, Rainbow will by default only process the first 120 dependents, since otherwise Cell Inspector may take a long time to run. You can change this setting in your Preferences on the Parameters tab (under Cell Inspector), and if you wish to be sure that all dependents are processed, you can choose the maximum value of 32,000 (the maximum set by Excel)."]
[]
[null,"Merged Cells Tool"]
[]
[null,"The Merged Cells Tool produces a detailed report listing all merged cells, and by default it highlights in yellow those merged cells which have a numeric value, since these carry an added risk of causing incorrect calculation results."]
[]
[null,"In addition, the tool can unmerge either all merged cells or all those which have a numeric value. By default Excel places the unmerged value in the top left cell (cell number 1) within what was the merged area, but the Merged Cells Tool lets you choose where to put the value, i.e. in which cell number within the merged area. If you select cell number 0, the tool will place the unmerged value in the middle cell of each merged area, or you can place it in the last cell of each merged area by selecting a very high cell number, e.g. 999."]
[]
[null,"If you simply want to unmerge cells without producing a report, you can turn off the reporting option. And if you want to unmerge different cells in different ways (e.g. placing the unmerged value in different cell numbers), you can limit the operation of the tool to the currently selected range in the worksheet (provided that this covers more than one cell)."]
[]
[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. to show which names are unused, but it can take a long time, as Rainbow searches not just formulas, but also any data validation, conditional formatting, embedded charts, chart sheets, other defined names, and VBA code. To turn off this feature, select \"Ignore\" in the box under \"Usage\". If you let Rainbow 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 Options 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 formulas) searches for all references to defined names within formulas, data validation, conditional formatting, charts, other names, and VBA code 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 Options 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 convenient tool to clean up the names in a spreadsheet by deleting all those which are not used. Like the second Names Toolbox option, it will not delete the \"Print_Area\" and \"Print_Titles\" names used by Excel. If the current worksheet is a Names Toolbox report showing used and unused names, Rainbow will offer to delete the unused names as shown in the report, rather than performing a new check for unused names."]
[]
[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 quite different from defined names, and are listed in Rainbow's Data Explorer report."]
[]
[null,"Risk Map"]
[]
[null,"The Risk Map function enables you to highlight cells and generate reports analysing any or all of 24 different potential risks. Each potential risk has its own colour, which you can see from the Analysis Wheel or the Colour Chart, 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 Identify Colours, then switch to your spreadsheet and use the Identify 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 24 risk analysis options  (i.e. 6 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 six 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 by selecting them individually (on the Patterns, Formats, Formulas, or Options tab), or you can click the \"All risks (excl. button below)\" button to analyse for all cell-specific risks. You can also click the \"Risks not in Formula Scan\" button to run the checks that are excluded from the Formula Scan function (as explained earlier). Later you may end up with a standard set of analyses that you use regularly, and you can then click the Save favourites button to set these as your default choice (and you can always restore the original Favourites by clicking Restore Defaults, under Menu Settings). "]
[]
[null,"The \"Constants, formulas and text\" preset button is different from the other buttons (those with green text), which are intended to highlight individual cells which are potential risks. This button, by contrast, is intended to generate a colour \"map\" of the structure of a worksheet which can indicate poor spreadsheet design (somewhat like the Logic Map). Reporting on individual cells is not usually relevant for this purpose, and is turned off by default (though you can turn it on if you wish)."]
[]
[null,"At the bottom of the Risk Map form is the Insert box, where you can select to insert a \"Query\" flag (diagonal red line) and/or a custom comment (cell note) on each highlighted group of cells, and you can then track and edit this with the Issue Tracker. The comment lists all the analysis types found in the 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). Note that a large number of comments can significantly increase the size of the spreadsheet file."]
[]
[null,"Risk Map - Patterns"]
[]
[null,"• 1)  Lone cell types are cells which are of a different type (e.g. blank, text, logical, date, array, formula or value) from the majority of the 8 immediately surrounding cells. This can indicate a problem, where for instance a cell in a block of calculations has been overwritten with a value. You can adjust the criteria that control how Rainbow detects lone cell types and lone formulas in your Preferences (under the Parameters tab)."]
[]
[null,"• 2)  Lone formulas are cells which have a different formula from the formula which appears in the majority of the 8 immediately surrounding cells. As with lone cell types, this can often indicate where a formula has been adjusted to yield the required result."]
[]
[null,"• 3)  Hard-coded numbers refers to  cells where an input number has been combined with a formula, and this analysis option will highlight all formulas containing a hard-coded value of 10 or above, or a decimal value. If you wish you can change your preferences (on the Risk Map tab) to include single-digit numbers from 2 to 9, though formulas containing a hard-coded 0 or 1 are very normal and will always be excluded. By default, Rainbow will also include as hard-coded numbers any cells containing a formula such as \"=365/12\", which may be regarded as bad practice but is not generally dangerous. However, you can change your Preferences settings to highlight only cells which combine a hard-coded number with a reference to another cell, e.g. \"=C63/12\"."]
[]
[null,"• 4)  Hidden error values are cells containing one or more conditional IF() statements, where the unused branch of the statement would generate an error. A simple example would be where cells B3 and B4 contain the value 0, and B5 contains the formula \"=IF(B3>0,B3/B4,0)\". This would generate the following item for cell B5 in column F of the report:"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"#DIV/0! ← B3/B4"]
[null,"───────────────────────────────────────────────────────────────────"]
[null,"This indicates that the formula element \"B3/B4\" in cell B5 would generate a #DIV/0! error, but that this element (the \"true\" branch of the conditional statement) is not currently used, because the condition \"B3>0\" is false."]
[]
[null,"• 5)  Outlier numbers are values in a data set that is expected to be normally distributed, but which appear to fall outside the expected distribution. Rainbow uses the Generalized Extreme Studentized Deviate (ESD) test, which is a recognised standard method for finding multiple outliers; Rainbow assumes a maximum of 10 outliers, but you can change this on the Risk Map tab of your Preferences settings. Column F of the report shows key statistical information, and indicates where an outlier has been \"masked\" by other outlier values. Note that Rainbow will detect whether each worksheet is arranged by rows or columns, and will then test for outliers along each whole row or column. If your worksheet contains multiple data sets which need to be tested separately, you will need to select each data set in turn, and then click in the Applicable Range box at the bottom of the Risk Map dialog box to test only the relevant data."]
[]
[null,"• 6)  Variant text values are text values which differ by only one character from other nearby text values, and so may be the result of a \"typo\". The report shows which character has been added, omitted or changed, and what is the nearby text that may be the correct value. As with outlier numbers, Rainbow will automatically detect whether each worksheet is arranged by rows or columns, and will then compare along each row or column as appropriate."]
[]
[null,"Risk Map - Formats"]
[]
[null,"• 1)  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,"• 2)  Different formats 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,"• 3)  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), on the Advanced Menu."]
[]
[null,"• 4)  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,"• 5)  Conditional formatting lists cells which have conditional formatting applied to them. The report will attempt to show (in column F) how the conditional formatting appears in each cell, but this may not be entirely possible where the formatting has been applied across a block of cells."]
[]
[null,"• 6)  Data validation lists cells which have data validation applied to them. Column F of the report shows the type of validation, and also indicates where the current value of the cell (or the first cell in a block) is invalid."]
[]
[null,"Risk Map - Formulas"]
[]
[null,"• 1)  Complex conditions are cells with a formula which contains at least 2 levels of nested IF() statements. Multiple nested IF() statements are widely recognised as a common source of errors in formulas."]
[]
[null,"• 2)  Multiple operations lists cells with a formula which involves a specified number (or more) of Excel functions or other operations in brackets (parentheses). The default value is 4 operations, but you can change this on the Risk Map tab of your Preferences settings."]
[]
[null,"• 3)  Multiple references lists cells which have a specified number (or more) of precedents. The default value is 6 precedents, but you can change this on the Risk Map tab of your Preferences settings. If you click a hyperlink in the report to go to a particular cell, you can then use the Cell Inspector function to navigate to each of the cell's precedents."]
[]
[null,"• 4)  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,"• 5)  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,"• 6)  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 - 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)  Constant text values are cells containing text rather than a number."]
[]
[null,"• 4)  Calculated text values are cells containing a formula which calculates a text value, e.g. =CHOOSE(MOD(NOW(),7)+1,\"Sat\",\"Sun\",\"Mon\",\"Tue\", \"Wed\",\"Thu\",\"Fri\")"]
[]
[null,"• 5)  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) on the Advanced Menu to change the colour, if you want them displayed in a different colour on your spreadsheet."]
[]
[null,"• 6)  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,"Logic Analysis"]
[]
[null,"The Logic Analysis function works very much like the Risk Map function, except that it has just two tabs and 12 analysis options. The options on the first (Precedents) tab analyse various potential issues with a cell's precedents, and the second tab lets you highlight six types of dependency. Because the Precedents analysis options involve detailed analysis of all the precedents for each cell, they tend to run much more slowly than most of the Risk Map analysis options."]
[]
[null,"With the Precedents analysis options, 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). Where Rainbow has found a block of copied cells, it will show the details of the issues for the first cell in the block, but it may not be able to show exact details for all the remaining cells, though it will attempt to provide as much information as it usefully can."]
[]
[null,"You will notice that the \"Inputs and other dependencies\" preset button generates the same \"map\" as the Logic Map function. Logic Map provides a fast and direct way to generate this map, and also lets you show numbers of dependents, whereas the \"Inputs and dependencies\" button in the Logic Analysis function allows you to select individual dependency types and optionally  generate reports and insert flags and comments."]
[]
[null,"Logic Analysis - 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 Options 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 Logic Analysis 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 Options 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,"Logic Analysis - Dependents"]
[]
[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. As with the Logic Map, this option will only detect blank input cells within the used area of the worksheet."]
[]
[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 Logic Analysis 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)  Circular references are intermediate workings that are part of a chain of calculations that refers back to itself. As with the Logic Map, this option will detect circular references where the all the cells involved in the circular chain of calculations are in the same worksheet. However, if the calculation chain goes outside the current worksheet, it will only highlight the circular reference cell shown in the Excel status bar (provided that this is an intermediate working)."]
[]
[null,"• 5)  Output calculations are calculations which have no further dependent calculations."]
[]
[null,"• 6)  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,"Analysis Wheel"]
[]
[null,"The Analysis Wheel is a multi-purpose tool for accessing and managing any of Rainbow's 36 cell type analysis options. It lets you:"]
[null,"•  Scroll through all the analysis options, plus the thousands of Item number colours, or search for any of them by name."]
[null,"•  Quickly access the relevant Help information for each option."]
[null,"•  Run an analysis on the current sheet, or add other sheets or options."]
[null,"•  Review each of the highlighted cells after an analysis has been completed."]
[null,"•  Choose which colours are assigned to which cell types."]
[]
[null,"When you click the Analysis Wheel button, you will see up to nine of Rainbow's analysis options presented as a segment of a wheel. The central option is the one currently selected (by default, Multi-digit hard-coded numbers), and you can click the Analyse button to go to the Risk Map or Logic Analysis function with the relevant option pre-selected, so that you can then just click OK (or press Enter) to run an analysis."]
[]
[null,"When you have run an analysis, click the Analysis Wheel button again and it will open at the option you last selected. So you can then simply click the Review button to browse through each cell of the selected type that Rainbow's analysis detected and highlighted in the current sheet. And if you want to make the current cell type the default option (instead of Multi-digit hard-coded numbers), just click the Menu Settings button and select Preferences, then click Save Defaults."]
[]
[null,"You can select a different analysis option by clicking any of the four buttons above or below the central option. You can also navigate around the 36 different options more quickly by using your mouse scroll wheel or the scroll bar on the left, or you can search for a specific option in the search box at the bottom."]
[]
[null,"Your mouse scroll wheel and the scroll bar, as well as the search box, will also allow you to access the numbered colours that Rainbow uses for highlighting items such as formula groups, so you can then click the Review button to find highlighted cells in the current sheet. To access these Item number buttons, simply scroll down (with your mouse scroll wheel or the scroll bar) to Item 1, after the 36 named analysis options,  then continue scrolling on down. Or in the search box type the item name, e.g. \"Item 14757\", and press Enter or click the search button."]
[]
[null,"The top button on the right will normally be labelled Export, and you can click this to export a Cell Colour Sheet showing how the first 36 colours in Rainbow's palette are currently assigned to the 36 analysis options. At the top right of this sheet is a Help button which will explain how to modify the colour mapping (by changing the indices in column H). And if you click the Analysis Wheel button when the current sheet is a Cell Colour Sheet, the top button on the right will now be labelled Import, allowing you to click it and re-import your modified colour mapping from the Cell Colour Sheet."]
[]
[null,"Under the Export/Import button are three Help buttons, the first of which simply displays this Help information. The second (Item) Help button displays an explanation of the currently selected item, which also indicates where to find it within the Risk Map or Logic Analysis functions. And the third (Colour) Help button gives you an overview of the Colour Chart and Rainbow's palette of colours."]
[]
[null,"Import Colours"]
[]
[null,"In the Analysis Wheel dialog box, the top button on the right will normally be labelled Export, and you can click this to export the Cell Colour Sheet showing how the first 36 colours in Rainbow's palette are currently assigned to the 36 analysis options. Although you cannot change the colours themselves, you can change the order in which they are mapped to the 36 analysis options. The current order is shown in columns G and H, and (unless it has already been changed) you will see that the first 6 colours are assigned to the 6 dependency types (as used in the Logic Map), even though these are the last 6 items on the Cell Colour Sheet (in rows 36-41)."]
[]
[null,"To change the order in which the colours are assigned, all you need to do is to change the order of the index numbers in column H (highlighted in yellow as an input area). So for instance if you want blank input cells coloured yellow and non-blank inputs coloured red, simply swap the values 3 and 5 in H36 and H37. If you launch the Analysis Wheel again, you will see that the top button on the right is now labelled Import, and you can simply click this button to load your new colour mapping into Rainbow."]
[]
[null,"The only restriction on your new colour mapping is that in column H it must include all and only the numbers from 1 to 36; you cannot omit or repeat any numbers, or use numbers beyond 36. The Import function on the Analysis Wheel will check this and alert you if any colour numbers are missing. If all 36 colours are present, it will calculate how many you have edited, and ask if you are ready to load your changes into Rainbow."]
[]
[null,"Save Format"]
[]
[null,"Before you change the formatting of a spreadsheet with the functions described in other sections of this User 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,"You can also choose whether to delete the flags (diagonal lines) and custom comments that are used by the Issue Tracker function."]
[]
[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,"Rainbow keeps track of your worksheets by name, so you can still Undo Changes if you have moved a worksheet to a different position in the workbook, but not if you have renamed the worksheet. And if you have inserted or deleted rows or columns, Rainbow will restore formatting incorrectly as if nothing had changed."]
[]
[null,"If Rainbow has no formatting information saved, you will not be able to Undo Changes, but you can go to the Clear Cell Colours function and clear cell colours which have been generated by Rainbow, which will at least partly undo Rainbow's formatting changes."]
[]
[null,"File Save As"]
[]
[null,"After you have cleaned up a workbook (using the Clean-Up Tools) or analysed it with some of Rainbow's other functions, you can use the File Save As function to save it under a different name and leave the original file unchanged. If you have saved any formatting information with the Save Format function, Rainbow will update the saved information to link it to the new workbook name."]
[]
[null,"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,"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 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 like the Quick Clean-Up function to clear cell colours and patterns (in addition to its other operations), you can set this in your Preferences settings (on the Colours tab), by checking 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 (under Change Management on the Advanced Menu) to save it under a different name and leave the original file unchanged."]
[]
[null,"Clean Up Formats"]
[]
[null,"The Clean Up 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 particularly sensitive to formatting changes, you should use the File Save As function (under Change Management on the Advanced Menu) to save the cleaned-up workbook under a new name, and check it against the original."]
[]
[null,"Trim Unused Space"]
[]
[null,"Excel automatically keeps track of what it considers to be the \"used range\" of each worksheet, i.e. the range of cells containing all the data and calculations in the sheet. Generally this system works quite well, but just occasionally Excel's internally stored \"used range\" may extend thousands of rows or columns beyond the edge of the real used range. This can make the workbook unnecessarily large and slow to load."]
[]
[null,"The Trim Unused Space function finds the real used range for each worksheet (i.e. the range containing all non-empty cells) and deletes all rows and columns beyond the edge of this, which forces Excel to align its internally stored \"used range\" with the real used range. In most cases this should not affect the operation of the spreadsheet; however, if there are blank inputs outside the real used range, this can result in #REF! errors. In addition, any graphical objects or coloured (but empty) cells outside the real used range may be deleted."]
[]
[null,"If you have any concerns about whether this may have unwanted consequences for your workbook, you should use the File Save As function to save the cleaned-up workbook under a new name, and compare it against the original. You can use the Logic Analysis function to check for any cells with blank precedents (blank inputs) outside the used range."]
[]
[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. You can also choose for Rainbow to add a \"Query\" flag (red diagonal) to the first in each group of highlighted cells, which you can then track with the Issue Tracker."]
[]
[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 Scan 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 Parameters 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 could try changing your Preferences (on the Parameters tab) to adjust the minimum number of non-blank cells that Rainbow regards as adequate evidence for deciding if there has been an insertion or deletion."]
[]
[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,"Scramble Workbook"]
[]
[null,"Sometimes you may want to share a workbook which contains confidential data with someone (e.g. Rainbow support) who needs to understand the workbook structure but not its data. The Scramble Workbook function provides a way for you to do this, by scrambling (randomising) both the data and optionally the text in the workbook."]
[]
[null,"There are three options for randomising numerical data. The default is the third option, which leaves date values unchanged, and also any series where the numbers increase by 1 each time (often used for period numbers). All other input numbers are randomised, while mostly retaining the same order of magnitude in order to show the likely operation of any conditional logic."]
[]
[null,"The second option randomises all input numbers and dates, and the first option simply replaces all input numbers and dates with the value 1. Formulas are left unchanged in all three options, except that any links to external workbooks are edited so as to yield a meaningless value."]
[]
[null,"Text values can be left unchanged, but the default option is to replace all input text values with the corresponding length of \"lorem ipsum\" text, i.e. the standard filler text used in publishing and graphic design. Any comments (cell notes) will also be replaced with lorem ipsum text."]
[]
[null,"Identify Colours"]
[]
[null,"The Identify Colours function (which you can invoke by pressing ALT+F9) checks the colour(s) of the selected cell against Rainbow's defined cell colours (as displayed if you click the Analysis Wheel or the Colour Chart). It lists each colour, with the corresponding description, and you can click the Info... button for each colour to see the Analysis Wheel 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 Identify 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 Identify Colours to identify this colour. You can then click outside the Identify Colours dialog box and switch to the workbook, and simply click Next Block or Next Cell to find any relevant links."]
[]
[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 Formats 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 remaining 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,"Although the cells in a typical spreadsheet are usually white, and the font is usually black, these colours often result from the cell colour being set to \"No Fill\" (showing the cell borders) and the font colour being set to \"Automatic\". You can apply these settings with the Format Editor if you select white as the new cell colour, or black as the new font colour. You will then be asked to confirm whether you wish to set (as appropriate) the cell colour to No Fill or the font colour to Automatic."]
[]
[null,"You can use the last four Format Editor options in conjunction with other Rainbow functions. For instance you can click Logic Analysis (on the Risk Map drop-down menu), 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 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,"Colour Chart"]
[]
[null,"As from version 9.0, Rainbow now has a built-in Colour Generator capable of generating a set of 14,793 unique colours, in which adjacent colours are always visibly different from each other. Rainbow uses the first 36 of these colours to highlight specific types of cells (with the Analysis Wheel or the Risk Map and Logic Analysis functions), and these 36 colours and cell types are displayed when you click the Colour Chart button. The remaining 14,757 colours (named from \"Item 1\" to \"Item 14757\") are used to identify items such as formula groups and defined names, and you can see these colours (as well as the first 36) displayed in the Analysis Wheel."]
[]
[null,"So there is no longer any significant risk that Rainbow will run out of colours when (for instance) analysing grouped formulas; each group will have its own unique colour, allowing you to search for it using the Identify Colours function. But Rainbow's colours are also designed to be slightly different from most standard colours, and there is less than a 0.1% probability that a pre-existing cell colour in a spreadsheet will turn out to be the same as one of Rainbow's colours."]
[]
[null,"The Colour Chart function provides an interactive display of the 36 colours that Rainbow uses for all the various dependencies and cell types. You can hover the mouse over any colour to see its exact RGB (Red, Green, Blue) values, and you can click on it to bring up the Analysis Wheel for that colour. This then lets you get help on the meaning of the specific cell type, find occurrences of the relevant colour in the current worksheet, and also re-order the cell type colours as explained below."]
[]
[null,"In the Analysis Wheel dialog box, the top button on the right will normally be labelled Export, and you can click this to export a Cell Colour Sheet showing how the first 36 colours in Rainbow's palette are currently assigned to the 36 analysis options. Although you cannot change the colours themselves, you can change the order in which they are mapped to the 36 analysis options. The Help button at the top right of the Cell Colour Sheet explains in detail how to do this by changing the indices in column H."]
[]
[null,"If you then launch the Analysis Wheel when the current sheet is a Cell Colour Sheet, the top button on the right of the Analysis Wheel dialog box will now be labelled Import, allowing you to click it and re-import a set of colour mapping options from the Cell Colour Sheet. This means that you can save a set of colour mapping options and then go back to them at any time later, simply by exporting and saving the relevant Cell Colour Sheet. To go back to the saved colour mapping options, simply open the saved Cell Colour Sheet workbook, launch the Analysis Wheel, and click Import."]
[]
[null,"Clear Cell Colours"]
[]
[null,"The Clear Cell Colours function has two options. The first option clears all cell colours and patterns (and by default any diagonal borders, which Rainbow uses to flag issues). It is very useful both to clear pre-existing colours in a spreadsheet before running a Rainbow analysis, and to clear a set of Rainbow highlights and flags before running a different analysis."]
[]
[null,"The second option clears only those specific cell colours which have been  generated by Rainbow. This provides an alternative to the Undo Changes function, and in some cases it can fully undo Rainbow's changes. However, if Rainbow has overwritten an existing cell colour, this function will only clear the Rainbow colour, and it will not restore the original colour."]
[]
[null,"The set of colours used by Rainbow has been specifically designed to be very slightly different (with slightly different RGB values) from the colours which are generally available in Excel. However, there remains a small possibility that a workbook might use one of the Rainbow colours, which would then be cleared even with the second Clear Cell Colours option."]
[]
[null,"Normally (if the Optimise range box is ticked) this function will clear only the range which is actually used in any worksheet, rather than the whole of what Excel identifies as the \"used range\", which can be much bigger. However, if you find that there are cells (outside the optimised range) with colours which have not been cleared, you can simply untick the Optimise range box and re-run the Clear Cell Colours function."]
[]
[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 first element of the \"Macro buttons + objects\" column in the Summary Report, and you can use the Macro Explorer function to check what the called macro does."]
[]
[null,"Delete Graphics"]
[]
[null,"Graphical objects (sometimes called drawing objects) include charts and buttons as well as shapes and pictures. They are not usually a problem, but occasionally a worksheet can become corrupted with thousands of graphical objects, which make it difficult to navigate and edit. The Delete Graphics function simply goes through the worksheet(s) deleting all graphical objects (but omitting comments, which can be removed with the Delete Comments function)."]
[]
[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 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 when the file size exceeds 20 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 File Explorer (formerly Windows Explorer), click Organize and then Folder and search options (in Windows 7), or click the View tab and then Options (in WIndows 10). 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 license and about how to access support. If the support period of your license is about to expire, and you have purchased a new license, click the \"Register a new license\" button to enter your license details."]
[]
[null,"Check For Updates"]
[]
[null,"The Check For Updates function provides a quick way to check whether an updated version of Rainbow Analyst is available. If there is an updated version, and the date of this version is within the support period of your license, Rainbow will offer to download and install the updated version automatically. This involves briefly closing and then re-opening Excel."]
[]
[null,"If you are using Rainbow Analyst within a corporate environment (rather than on your own PC), it is possible that the file and folder permissions in your corporate IT setup may prevent Rainbow from running the Check For Updates function, in which case Rainbow will display a suitable error message. If this happens, you can still check the latest Rainbow version and (if appropriate) update your own copy manually from the Rainbow Analyst website."]
[]
[null,"If there is an updated version of Rainbow which was released after the end of the support period of your license, you can still download and install this from the Rainbow Analyst website. However, it will install as a 30-day free trial version, and the details of your existing license will be overwritten. To recover your license, you will need to download and re-install an earlier version, and then re-enter the details of your license."]
[]
[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 six tabs: Reports, Colours, Risk Map, Logic Analysis, Parameters, and Options. 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) first let you select to include all reports in the same workbook (the default setting) or to generate each report as a separate workbook. Then you can tell Rainbow to routinely select all worksheets for analysis rather than just the current sheet(s). Next you can decide whether Rainbow should add a Help button at the top of each report. And you can then 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). Finally 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 0 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 Item number colours Rainbow should start from when selecting colours for the Inter-Sheet Logic, Formula Scan and Comparison Toolbox functions. And the option to Rotate through all colours tells Rainbow to use each colour sequentially, rather than trying to minimise the number of colours it uses. Note that if you set the Start colour number to be greater than 1 (e.g. 3), Rainbow will re-label the preceding Item number colours (e.g. as Item -1 and Item 0)."]
[null,"•  Under Quick Clean-Up, you can select whether you want the Quick Clean-Up function to clear cell colours and patterns."]
[]
[null,"There are five sets of options under the Risk Map tab as follows:"]
[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 Patterns tab in Risk Map), or whether it should only look for formulas which include references to other cells. And you can specify whether you want Rainbow only to highlight multi-digit hard-coded numbers (10 or above, or decimal values), or whether you also want it to include single-digit values from 2 to 9 (it will always ignore 0 and 1, as these are very normal)."]
[null,"•  Under Error values, you can select whether you want Risk Map (under the Formats tab) 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 Rainbow should show only the error source cells (from which the error originates)."]
[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 Formats tab) and the Format Editor function (option 1)."]
[null,"•  Under Outlier values, you can set the maximum number of potential outliers that Risk Map should examine (under the Patterns tab). Note that Risk Map detects outliers using the Generalized ESD test, which requires this input parameter."]
[null,"•  Under Complex Formulas, you can set the criteria for Risk Map to detect Multiple operations and Multiple references (on the Formulas tab)."]
[]
[null,"Under the Logic Analysis tab are three sets of options relating to Precedents analysis, and a setting that affects analysis of Dependents:"]
[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. This option is particularly relevant if you are analysing Precedent block inconsistencies as well as Precedents of different cell type."]
[null,"•  Under Excess same-sheet dependents, you can choose what Rainbow does (in Logic Map, Inter-Sheet Logic, the Dependencies tab in Logic Analysis, 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,"The options on the Parameters tab control the Lone cell types and Lone formulas reports (both in the Risk Map function and in the Summary Report), and how the Comparison Toolbox detects and manages inserted and deleted rows and columns:"]
[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 yellow highlighting in some Risk Map and Logic Analysis reports."]
[null,"•  Under Lone cell types & formulas, you can select the Basic, Enhanced or Maximum level of detection for lone cell types and lone formulas. And then you can choose whether the Lone Fmlas report is generated at the same type as the Summary Report (see the Summary Report help section for more details). Your choices here will be shown as the default options when you run the Summary Report, and you can change your selection in the Summary Report dialog box."]
[null,"•  Under Comparison Toolbox, you can control whether the Comparison Toolbox automatically inserts rows where it considers they have been deleted, and then whether it deletes them after insertion. And you can adjust the minimum number of non-blank cells that are needed to decide when rows or columns may have been inserted (see the Comparison Toolbox help section for a more detailed explanation)."]
[null,"•  Under Cell Inspector, you can set the maximum number of (precedents and) dependents that Rainbow will process and display in Cell Inspector. The default value is 120, meaning that Cell Inspector will not waste time processing hundreds or thousands of dependents that are unlikely to be relevant. However, if you wish to be sure that all dependents are processed, you can choose the maximum value of 32,000 (the maximum set by Excel)."]
[]
[null,"The four sets of options under the Options tab relate to a number of other Rainbow functions:"]
[null,"•  Under General, you can select whether Rainbow should optimise the range that it analyses by detecting the range that is really used in each worksheet rather than relying on Excel's internally stored \"used range\" (see the help on Trim Unused Space for more details). You would probably only need to turn off this option if you wanted the Logic Map or Logic Analysis function to check for blank input cells outside the real used range. Next you can choose whether you want Rainbow to set Excel's calculation options (under the Formulas tab in Excel) to Automatic after each analysis, to avoid the risk of calculation remaining set to Manual (as it is while analysis is being performed). Then you can decide whether Rainbow should display the status bar at the end after it has finished analysis. And the final option determines whether mouse wheel scrolling is enabled when viewing Help text and the Rainbow log file."]
[null,"•  Under Inter-Sheet Logic, you can tell Rainbow whether or not to highlight (in yellow and red) 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,"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,"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 saved Preferences, modified colours and favourites, and any license data. Consequently after using this function you will need to click User Guide and About Rainbow to re-enter your license key (registration code)."]
[]
[null,"Uninstall"]
[]
[null,"This function will first check whether you want to remove the details of any existing license. It will then close Excel and delete the Rainbow add-in file."]
[]
[null,"License Agreement"]
[]
[null,"This License Agreement (\"the License\") relates to the Rainbow Professional and Rainbow Governance software products (\"the Software\") supplied by M G Shallcross trading as The Model Answer (\"the Licensor\"). This is a legal agreement between you, the end user (\"the Licensee\"), and the Licensor. You should read the following terms and conditions carefully before you use the Software. Further download or use of the Software certifies that you accept these terms and conditions. Particular attention is drawn to the LIMITED WARRANTY, LIFETIME OF THE License, ABILITY TO ASCERTAIN SPREADSHEET CHANGES and FILE INTERACTIONS sections of this document."]
[]
[null,"1. SPYWARE, ADWARE, COOKIES AND DATA HARVESTING"]
[null,"1.1 We take your privacy and personal information seriously. The Software contains no known spyware, adware, data\u001eharvesting techniques or malicious code. "]
[]
[null,"2. LICENSE"]
[null,"2.1 The Licensor grants the Licensee a non-exclusive license to install and use the Software on any computer, laptop, or network for use only by the Licensee. The Software is \"installed\" on a computer or network when it is copied on to any storage device on that computer or network."]
[]
[null,"3. RESTRICTIONS AND EXTENDING USE TO OTHER COMPANIES"]
[null,"3.1 This License is your proof of license to exercise the rights granted herein and must be retained by you. You may not rent or lease or re-sell the Software. In addition, the Licensee is expressly forbidden from extending, lending or giving the software or installing the software or having the software installed on the computer or network of any other company without the express prior written permission of the Licensor. "]
[null,"3.2 The Licensee may transfer their rights under this License on a permanent basis provided they transfer this License Agreement, the Software, and all accompanying written materials (if any) and retain no copies, and the recipient agrees to the terms of this License. You must notify the Licensor in writing of your intention to transfer your rights and you must have received written acknowledgement of this intention from the Licensor before the transfer takes place. Any transfer of the Software must include the most recent update and any available prior versions."]
[null,"3.3 The Licensee may not copy, reverse engineer, decompile, or disassemble the Software in whole or part, except as permitted by law which is incapable of exclusion between the parties."]
[]
[null,"4. COPYRIGHT & INTELLECTUAL PROPERTY"]
[null,"4.1 The Licensor warrants that it is the sole legal owner of the Rainbow Professional version of the Software, and is entitled to grant this license in relation to this version. In relation to the Rainbow Governance version of the Software, the additional Governance components (\"the Additional Components\") form part of the \"Diligence for Excel\" software and are the property of IDAS Ltd, which warrants that it is entitled to grant a corresponding license in relation to the Additional Components."]
[null,"4.2 All Intellectual Property Rights in the Software belong, and shall belong, to the Licensor in respect of the Rainbow Professional version of the Software and to IDAS Ltd in relation to the Additional Components."]
[null,"4.3 The Software is protected by UK copyright laws and International treaty provisions. You must treat the Software and the documentation accompanying the Software like any other copyrighted material except that you may copy the Software and documentation to a computer or network solely for backup purposes."]
[]
[null,"5. LIMITED WARRANTY"]
[null,"5.1 The Licensor warrants that the Software will perform substantially in accordance with the accompanying documentation for a period of 1 year from the date of first installation. Any implied warranties on the Software are limited to 1 year."]
[null,"5.2 Very little software is completely error-free and the Licensor does not warrant that the Software will operate without errors. We both encourage and welcome comments and suggestions for improvements or notification of errors."]
[null,"5.3. The Licensor's entire liability and your exclusive remedy shall be, at the Licensor's option, either (a) return of any price paid or (b) return of up to 3 months of any agreed support costs or (c) replacement of the Software that does not meet the Licensor's Limited Warranty."]
[null,"5.4 The Licensor's website has security features in place to ensure the contents are not tampered with. However, we are aware that websites can be hacked and their contents changed. Legitimate versions of the Software are digitally signed and contain no known adware or spyware or malicious code. Please alert us immediately if you suspect otherwise, but please be aware we take no responsibility for the consequences of any \"hacked\" code."]
[null,"5.5 IN ALL OTHER RESPECTS, THIS SOFTWARE IS PROVIDED \"AS IS\" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE LICENSOR SHALL NOT BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, OR INCIDENTAL DAMAGES ARISING OUT OF THE USE, THE RESULT OF USE, OR THE INABILITY TO USE THIS PRODUCT."]
[null,"5.6 Some countries or states do not allow the exclusion or limitation of implied warranties or limitation of liability for incidental or consequential damages, so the above limitation or exclusion may not apply to you."]
[]
[null,"6. RIGHT OF REJECTION"]
[null,"6.1 For a period of 10 days commencing on the installation of the Software, the Licensee may discontinue this license of the Software if it does not perform to the Licensee's reasonable satisfaction. If the Licensee does so, the Licensor shall immediately refund all monies paid by the Licensee under this license and, on receipt of that refund, this license shall terminate. Further use of the software will be a breach of this clause and full license and/or maintenance fee(s) will be payable. Training and consultancy fees are NOT refundable."]
[]
[null,"7. LIFETIME OF THE LICENSE"]
[null,"7.1 Payable Licenses are normally granted on an annual or biennial basis. The Licensee’s particular expiry date can be viewed on the \"About Rainbow\" form within the Software. If this license has been transmitted by email then the license expiry data may also be contained within the accompanying documentation. "]
[null,"7.2 Use of the Rainbow Governance version of the Software after the expiry date is not permitted. Continuing use of the Rainbow Professional version of the Software is permitted, but users are not entitled to access support or to install updates to the Software. Users will be alerted to the impending license restriction 30 days before the license expires. Wilful use of the Rainbow Governance version of the Software after the expiry of the license will render the Licensee responsible for the full cost of the software and/or support at the appropriate rate for their organisation from the date of expiry."]
[null," "]
[null,"8. ABILITY TO ASCERTAIN SPREADSHEET CHANGES"]
[null,"8.1 In relation to the Rainbow Governance version of the Software, specific attention is drawn to the fact that in some spreadsheets, PARTICULARLY BUT NOT LIMITED TO THOSE THAT CONTAIN AUTOMATION, REFERENCES, LINKS OR VBA CODE, it may not be possible for the Software to correctly ascertain changes that have been made. The Software is a useful AID to the determination of spreadsheet construct and spreadsheet changes and nothing more. It is the sole responsibility of the Licensee to determine if such structure or change has or has not been made, or the dynamic nature of the spreadsheet, or version of Excel software renders it impossible to determine such change."]
[]
[null,"9. FILE INTERACTIONS"]
[null,"9.1 In rare circumstances, PARTICULARLY BUT NOT LIMITED TO SPREADSHEETS THAT CONTAIN AUTOMATION, REFERENCES, LINKS OR VBA CODE, the Software or Microsoft Excel itself may inadvertently affect the operation of other Excel files OR VICE-VERSA. It is the sole responsibility of the Licensee to determine whether any interaction between files is taking place and take the necessary steps to avoid the interaction, INCLUDING BUT NOT LIMITED TO REMOVAL OF THE SOFTWARE. Where removal of the Software is deemed necessary by the Licensee and reasonable evidence of the issue is supplied to the Licensor, at the Licensor's option the Licensee will be entitled to either (a) return of any price paid or (b) return of up to 3 months of any agreed support costs or (c) replacement of the Software."]
[]
[null,"10. GENERAL"]
[null,"10.1 This agreement will be governed by the laws of the UK."]
[null,"10.2 Any questions regarding this agreement or the Software should be directed to: support@themodelanswer.com."]

{"sheet":"Colours","index":1,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Rainbow Cell Colour Sheet"]
[]
[null,"Cell type","Current","Red","Green","Blue","Index","New","Default","TestAll","Favourites","Default","Formula"]
[null,null,null,null,null,null,null,"index","index",null,null,"faves","scan"]
[null,"Lone cell types",null,0,127,127,7,7,7,true,false,false,true]
[null,"Lone formulas",null,127,127,0,8,8,8,true,false,false,true]
[null,"Hard-coded numbers",null,127,0,127,9,9,9,false,true,true,true]
[null,"Hidden error values",null,128,128,254,10,10,10,true,false,false,true]
[null,"Outlier numbers",null,128,254,128,11,11,11,true,false,false,false]
[null,"Variant text values",null,254,128,128,12,12,12,true,false,false,false]
[null,"Error values",null,0,191,191,13,13,13,true,false,false,true]
[null,"Different formats",null,191,191,0,14,14,14,true,false,false,false]
[null,"Numbers formatted as text",null,191,0,191,15,15,15,false,true,true,false]
[null,"Same font and background colour",null,128,128,191,16,16,16,true,false,false,true]
[null,"Conditional formatting",null,128,191,128,17,17,17,true,false,false,true]
[null,"Data validation",null,191,128,128,18,18,18,true,false,false,true]
[null,"Complex conditions",null,128,191,191,19,19,19,false,true,true,true]
[null,"Multiple operations",null,191,191,128,20,20,20,false,true,true,true]
[null,"Multiple references",null,191,128,191,21,21,21,false,false,false,true]
[null,"Lookup and related functions",null,64,64,191,22,22,22,false,true,true,true]
[null,"Lookup requiring ordered list",null,64,191,64,23,23,23,false,true,true,true]
[null,"Array formulas",null,191,64,64,24,24,24,true,false,false,true]
[null,"Constant numbers",null,64,64,254,25,25,25,false,false,false,false]
[null,"Calculated numbers",null,64,254,64,26,26,26,true,false,false,false]
[null,"Constant text values",null,254,64,64,27,27,27,false,false,false,false]
[null,"Calculated text values",null,64,191,191,28,28,28,true,false,false,false]
[null,"Unlocked cells (all)",null,191,191,64,29,29,29,true,false,false,false]
[null,"Unlocked formula cells",null,191,64,191,30,30,30,true,false,false,true]
[null,"Inconsistent precedent copies",null,64,254,254,31,31,31,true,false,false,false]
[null,"Precedent block inconsistencies",null,254,254,64,32,32,32,true,false,false,false]
[null,"Precedents only part of block",null,254,64,254,33,33,33,true,true,true,true]
[null,"Precedents referring forwards",null,0,159,159,34,34,34,true,false,false,true]
[null,"Precedents of different cell type",null,159,159,0,35,35,35,true,false,false,true]
[null,"Cells with blank precedents",null,159,0,159,36,36,36,true,true,true,true]
[null,"Blank input cells",null,254,0,0,3,3,3,true,false,false,false]
[null,"Non-blank input cells",null,254,254,0,5,5,5,true,false,false,false]
[null,"Intermediate workings",null,0,254,0,2,2,2,true,false,false,false]
[null,"Circular references",null,0,254,254,4,4,4,true,true,true,true]
[null,"Output calculations",null,0,0,254,1,1,1,true,false,false,false]
[null,"Labels",null,254,0,254,6,6,6,true,false,false,false]

{"sheet":"Preferences","index":2,"n_rows":126,"n_cols":7,"rows_kept":126,"cut":false,"hidden":false,"merged":[]}
["Preferences sheet"]
[null,null,null,null,null,"Current","Report"]
["Columns F:G used in ColourCells for mapping"]
[]
["Current book/sheets and report book/sheets"]
[]
["UserDetails","Current","Original"]
[]
["UserName"]
["UserEmail"]
["UserCode"]
["ExpiryDate"]
[]
["GenlPrefers","Current","Original"]
[]
["Reporting"]
["ReportOption",1,1]
["SameRptBook",true,true]
["RptBookName"]
["AllSheets",false,false]
["RptHelpBtn",true,true]
["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",false,false]
["DoMap",false,false]
["ColrNames",true,true]
["WheelStart",4,4]
[]
["Undo Changes"]
["DelFlags",true,true]
["DelComments",true,true]
[]
["General Options"]
["OptimiseRange",true,true]
["CalcAutomatic",true,true]
["DisplayStatus",true,true]
["MouseScroll",true,true]
[]
["Summary Report"]
["TrafficLights",true,true]
["ExpComments",true,true]
["LoneBoxIndx",1,1]
["LoneFmlasRpt",false,false]
[]
["Formula Scan"]
["FGrpReport",true,true]
["RiskBoxIndx",3,3]
["FlagBoxIndx",1,1]
["UseDesc",false,false]
["RptComments",true,true]
[]
["Inter-Sheet"]
["IShtReport",true,true]
["IShtLights",true,true]
["IncLocals",false,false]
[]
["Risks and Dependencies"]
["OthReport",true,true]
["InsFlags",true,true]
["InsComments",false,false]
["ShowTime",5,5]
["ShowDeps",120,120]
[]
["Hard-coded numbers"]
["AllNumbers",true,true]
["SingleDigits",false,false]
[]
["Outlier numbers"]
["MaxOutliers",10,10]
[]
["Cell errors"]
["ErrorSources",false,false]
[]
["Numbers formatted as text"]
["DetectLetters",true,true]
[]
["Complex formulas"]
["MultiOps",4,4]
["MultiRefs",6,6]
[]
["Inconsistent copies"]
["SizeChanges",true,true]
["FormatDiffs",false,false]
[]
["Inconsistent precedents"]
["RowColDiffs",true,true]
[]
["Different cell type"]
["OnlyCorners",false,false]
[]
["Defined Names"]
["UseInspector",false,false]
["NameDelete",false,false]
[]
["Comparison"]
["RowInsert",true,true]
["RowDelete",true,true]
["CellsChecked",4,4]
[]
["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]
[]
["CompFlags",true,true]
["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":[]}