Spreadsheet: 160403d1339078209-trapping-filtering-with-wks_calc-event-ok-in-excel-2003-but-freezes-app-in-2007-and-2010-sample-workbook-tool-functions-to-be-tested
Sheet: Sheet1

Sheet |  | Actions |  |  |  | Business Rules |  | 2003 | 2003 | 2003 | 2007 | 2007 | 2007 | 2010 | 2010 | 2010 | 45144.47072983388
ID | Name | ID | Action | Action Affects Object / Item | Outcome of Action on Object / Item | ID | Rule | S01 Instructions | S02 Import_Data | [NAME] | S01 Instructions | S02 Import_Data | [NAME] | S01 Instructions | S02 Import_Data | [NAME]
S01 | Instructions | S01-A01 | Superuser filters for an Instruction from the list. | Filter dropdown menu  S01-E03 | Notes for superuser's chosen Instruction are displayed in S01-E01 |  |  |  | x | x |  | x | x |  | x | x
S01 | Instructions | S01-A02 | Output file user filters for an Instruction from the list. | Filter dropdown menu  S01-E04 | Notes for user's chosen Instruction are displayed in S01-E02 |  |  |  | x | x |  | x | x |  | x | x
S02 | Import_Data | S02-A01 | User clicks 'Import QSP Data' button S02-E01. | Excel 'open file' dialogbox form  S02-F01 | This standard Excel dialogbox form appears, for the user to choose the QSP data .csv file they want to import. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A01 | User chooses a different 'Look in' folder using dropdown menu box  S02-F01-E01. | Large box  S02-F01-E02 | The structure being shown in this large box reflects the user's choice, displaying any further 'sub-folders' and any .csv files available in the new folder chosen. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A02 | User single-clicks on an available folder showing in this large box S02-F01-E02. | 'Open' button  S02-F01-E06 | This button is enabled. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A03 | User double-clicks on an available folder showing in this large box S02-F01-E02. | 'Look in' dropdown menu box  S02-F01-E01 | The new folder that was clicked on by the user is loaded into this dropdown menu box. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A03 | User double-clicks on an available folder showing in this large box S02-F01-E02. | Large box  S02-F01-E02 | The structure being shown in this large box reflects the user's choice, displaying any further 'sub-folders' and any .csv files available in the new folder chosen. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A04 | User single-clicks on an available file showing in this large box S02-F01-E02. | 'Open' button  S02-F01-E06 | This button is enabled. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A05 | User double-clicks on an available file showing in this large box S02-F01-E02, but rule S02-F01-B01 is not met. | Excel 'open file' dialogbox form  S02-F01 | A warning message is displayed to the user, giving details of all issues found in the QSP .csv file - either incorrect column layouts, empty data rows in the layout, or both.  The 'Import QSP Data' procedure that was started by the user clicking button S02-E01 is terminated. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A06 | User double-clicks on an available file showing in this large box S02-F01-E02 and rule S02-F01-B01 is met. | Excel 'open file' dialogbox form  S02-F01 | This dialogbox form disappears, and the 'Import QSP Data' procedure, begun by the user clicking button  S02-E01, continues. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A06 | User double-clicks on an available file showing in this large box S02-F01-E02 and rule S02-F01-B01 is met. | Wait... Message form S02-F02 | This message form is displayed to the user.  It does not allow interaction and is 'display only'. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A06 | User double-clicks on an available file showing in this large box S02-F01-E02 and rule S02-F01-B01 is met. | Wait... Message form S02-F02 | This message form is hidden from the user. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A06 | User double-clicks on an available file showing in this large box S02-F01-E02 and rule S02-F01-B01 is met. | main tool', history log S02-E02 | The 'Import QSP Data' procedure, begun by the user clicking button S02-E01, is complete.  The main tool is open and contains the details of this import's results on a new line of the history log. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A07 | User chooses any file available from the recent history in file name dropdown menu box  S02-F01-E03. | File name  dropdown menu box  S02-F01-E03 | The chosen filename appears in this dropdown menu box.  [NAME] other than .csv files will be available in the history list. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A08 | User chooses any non-.csv file (including any .xls file) from the recent history in file name dropdown menu box  S02-F01-E03. | 'Open' button  S02-F01-E06 | This button is disabled. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A09 | User chooses a .csv file from from the recent history  in file name dropdown menu box  S02-F01-E03. | 'Open' button  S02-F01-E06 | This button is enabled. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A10 | User clicks 'Cancel' button S02-F01-E04. | Excel 'open file' dialogbox form  S02-F01 | This dialogbox form disappears.  Also, because the user chose to abort and not pick a file, the 'Import QSP Data' procedure, begun by the user clicking button  S02-E01, is terminated. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A11 | User clicks on S02-F01-E05, the 'X' at the top right of this form, or user hits 'Esc' key. | Excel 'open file' dialogbox form  S02-F01 | This dialogbox form disappears.  Also, because the user chose to abort and not pick a file, the 'Import QSP Data' procedure, begun by the user clicking button  S02-E01, is terminated. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A12 | User clicks 'Open' button  S02-F01-E05, and a folder was selected. | 'Look in' dropdown menu box  S02-F01-E01 | The new folder that was selected by the user is loaded into this dropdown menu box. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A12 | User clicks 'Open' button  S02-F01-E06, and a folder was selected. | Large box  S02-F01-E02 | The structure being shown in this large box reflects the user's choice, displaying any further 'sub-folders' and any .csv files available in the new folder selected. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A13 | User clicks 'Open' button  S02-F01-E06, a file was selected, but rule  S02-F01-B01 is not met. | Excel 'open file' dialogbox form  S02-F01 | This dialogbox form disappears.    A warning message is displayed to the user, giving details of all issues found in the QSP .csv file - either incorrect column layouts, empty data rows in the layout, or both.    The 'Import QSP Data' procedure that was started by the user clicking button S02-E01 is terminated. | S02-F01-B01 | The column layout in the .csv QSP file to be imported will exactly match an agreed, expected layout.  The data rows in this file will also be 'contiguous' - i.e. there will be no empty data rows. | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A14 | User clicks 'Open' button  S02-F01-E06 and rule  S02-F01-B01 is met. | Excel 'open file' dialogbox form  S02-F01 | This dialogbox form disappears, and the 'Import QSP Data' procedure, begun by the user clicking button  S02-E01, continues. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A14 | User clicks 'Open' button  S02-F01-E06 and rule  S02-F01-B01 is met. | Wait... Message form S02-F02 | This message form is displayed to the user.  It does not allow interaction and is 'display only'. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A14 | User clicks 'Open' button  S02-F01-E06 and rule  S02-F01-B01 is met. | Wait... Message form S02-F02 | This message form is hidden from the user. |  |  | x |  | x | x |  | x | x |  | x
S02 | Import_Data | S02-F01-A14 | User clicks 'Open' button  S02-F01-E06 and rule  S02-F01-B01 is met. | main tool', history log S02-E02 | The 'Import QSP Data' procedure, begun by the user clicking button S02-E01, is complete.  The main tool is open and contains the details of this import's results on a new line of the history log. |  |  | x |  | x | x |  | x | x |  | x
S03 | Export_Data | S03-A01 | User clicks 'Export Results for 1 AB' button S03-E01. | AB 'pick list' form S03-F01 | This AB list form appears. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-A02 | User clicks 'Export Results for All ABs' button S03-E02. | AB 'confirmation' form S03-F02 | This confirmation form appears. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F01-A01 | User picks an AB from the list. | Dropdown menu  S03-F01-E01 | User's chosen AB is displayed in S03-F01-E01 (NB: the accompanying QSP code is not displayed, but user can see it by hitting the downarrow of dropdown menu S03-F01-E01 again). |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F01-A02 | User clicks 'O K' button  S03-F01-E02. | AB 'pick list' form S03-F01 | This AB list form disappears, and the user's chosen AB Name and its accompanying QSP Code are stored by the background function for use later.  The 'Export Results for 1 AB' procedure, begun by the user clicking button S03-E01, continues. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F01-A02 | User clicks 'O K' button  S03-F01-E02. | Excel 'filepath' dialogbox form  S03-F03 | This standard Excel dialogbox form appears, for the user to choose the filepath to save the output file to.  Note that forms S03-F03 and S03-F04 are identical, but outcomes of actions taken from them are different, depending on whether the user originally clicked on button S03-E01 in action S03-A01, or button S03-E02 in action S03-A02. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F01-A03 | User clicks 'C A N C E L' button S03-F01-E03. | AB 'pick list' form S03-F01 | This AB list form disappears.  Also, because the user chose to abort and not pick an AB, the 'Export Results for 1 AB' procedure, begun by the user clicking button S03-E01, is terminated. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F01-A04 | User clicks on S03-F01-E04, the 'X' at the top right of this form. | AB 'pick list' form S03-F01 | This AB list form disappears.  Also, because the user chose to abort and not pick an AB, the 'Export Results for 1 AB' procedure, begun by the user clicking button S03-E01, is terminated. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F02-A01 | User clicks 'Yes...' button  S03-F02-E01. | AB 'confirmation' form S03-F02 | This confirmation form disappears.  The 'Export Results for All ABs' procedure, begun by the user clicking button S03-E02, continues. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F02-A01 | User clicks 'Yes...' button  S03-F02-E01. | Excel 'filepath' dialogbox form  S03-F04 | This standard Excel dialogbox form appears, for the user to choose the filepath to save the output files to.  Note that forms S03-F03 and S03-F04 are identical, but outcomes of actions taken from them are different, depending on whether the user originally clicked on button S03-E01 in action S03-A01, or button S03-E02 in action S03-A02. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F02-A02 | User clicks 'No...' button  S03-F02-E02. | AB 'confirmation' form S03-F02 | This confirmation form disappears.  Also, because the user chose to abort and not pick an AB, the 'Export Results for All ABs' procedure, begun by the user clicking button S03-E02, is terminated. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F02-A03 | User clicks on S03-F02-E03, the 'X' at the top right of this form. | AB 'confirmation' form S03-F02 | This confirmation form disappears.  Also, because the user chose to abort and not pick an AB, the 'Export Results for All ABs' procedure, begun by the user clicking button S03-E02, is terminated. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A01 | User chooses a different 'Look in' folder using dropdown menu box  S03-F03-E01. | Large box  S03-F03-E02 | The structure being shown in this large box reflects the user's choice, displaying any further 'sub-folders' available in the one chosen. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A02 | User double-clicks on an available folder showing in this large box S03-F03-E02. | 'Look in' dropdown menu box  S03-F03-E01 | The new folder that was clicked on by the user is loaded into this dropdown menu box. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A03 | User double-clicks on an available folder showing in this large box S03-F03-E02. | Large box  S03-F03-E02 | The structure being shown in this large box reflects the user's choice, displaying any further 'sub-folders' and any .csv files available in the new folder chosen. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A04 | User chooses a destination folder available from the recent history in folder name dropdown menu box  S03-F03-E03. | Folder name dropdown menu box  S03-F03-E03 | The chosen folder name appears in this dropdown menu box. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A04 | User chooses a destination folder available from the recent history in folder name dropdown menu box  S03-F03-E03. | 'Look in' dropdown menu box  S03-F03-E01 | The 'deepest' folder in the filepath from the chosen history item, is loaded into this dropdown menu box. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A04 | User chooses a destination folder available from the recent history in folder name dropdown menu box  S03-F03-E03. | Large box  S03-F03-E02 | The structure being shown in this large box reflects the user's choice, displaying any further 'sub-folders' available in the 'deepest' folder in the filepath from the chosen history item, |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A05 | User clicks 'Cancel' button S03-F03-E04. | Excel 'filepath' dialogbox form  S03-F03 | This dialogbox form disappears.  Also, because the user chose to abort and not pick a filepath, the 'Export Results for 1 AB' procedure, begun by the user clicking button S03-E01, is terminated. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A06 | User clicks on S03-F03-E05, the 'X' at the top right of this form, or user hits 'Esc' key. | Excel 'filepath' dialogbox form  S03-F03 | This dialogbox form disappears.  Also, because the user chose to abort and not pick a filepath, the 'Export Results for 1 AB' procedure, begun by the user clicking button S03-E01, is terminated. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A07 | User clicks 'OK' button  S03-F03-E06, but rule  S03-F03-B01 is not met. | Excel 'filepath' dialogbox form  S03-F03 | Warning text is displayed, and the user is advised to choose a folder location further up the directory 'tree' (closer to the root of the drive) etc.    The user is returned to form S03-F03.    'Look in' dropdown menu S03-F03-E01 retains the filepath last chosen.    'Folder name' dropdown menu S03-F03-E03 is given the filepath last chosen as its first historical item listed. | S03-F03-B01 | The user's chosen filepath is accepted only if the combined length of the filepath and the planned filename is not more than 217 characters.  The planned filename is to be pre-set by the background function, and the user will not be able to affect it until after the export procedure has run to completion, at which time they can perform a standard Excel 'Save As', should they wish to do so. | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A08 | User clicks 'OK' button  S03-F03-E06, and rule  S03-F03-B01 is met. | Excel 'filepath' dialogbox form  S03-F03 | This dialogbox form disappears, and the user's filepath choice is stored by the background function for use later.  The 'Export Results for 1 AB' procedure, begun by the user clicking button S03-E01, continues. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A08 | User clicks 'OK' button  S03-F03-E06, and rule  S03-F03-B01 is met. | Wait... Message form S03-F05 | This message form is displayed to the user.  It does not allow interaction and is 'display only'. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A08 | User clicks 'OK' button  S03-F03-E06, and rule  S03-F03-B01 is met. | main tool' | A copy of the tool is saved as a new output file, in which  the user's chosen AB from S03-F01-A01 is the focus.  In this output file copy, further objects/items are affected by action S03-F03-A08; these objects/items are given in the next rows below in this table, in green text font. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A08 | User clicks 'OK' button  S03-F03-E06, and rule  S03-F03-B01 is met. | In the new  output file, main tool instructions S01-E01 | This text is hidden from the user. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A08 | User clicks 'OK' button  S03-F03-E06, and rule  S03-F03-B01 is met. | In the new  output file, output file instructions S01-E02 | This text is made visible to the user. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A08 | User clicks 'OK' button  S03-F03-E06, and rule  S03-F03-B01 is met. | In the new output  file, 'Import Data' sheet S02 | This sheet is hidden from the user. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A08 | User clicks 'OK' button  S03-F03-E06, and rule  S03-F03-B01 is met. | In the new output  file, 'Export Data' sheet S03 | This sheet is hidden from the user. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A08 | User clicks 'OK' button  S03-F03-E06, and rule  S03-F03-B01 is met. | New output file | The new output file has been saved to the chosen filepath, but this new file has been closed and so is not available for viewing on the screen. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A08 | User clicks 'OK' button  S03-F03-E06, and rule  S03-F03-B01 is met. | Wait... Message form S03-F05 | This message form is hidden from the user. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F03-A08 | User clicks 'OK' button  S03-F03-E06, and rule  S03-F03-B01 is met. | main tool', history log S03-E03 | The 'Export Results for 1 AB' procedure, begun by the user clicking button S03-E01, is complete.  The main tool is open and contains the details of this export of 1 AB's results on a new line of the history log. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A01 | User chooses a different 'Look in' folder using dropdown menu box  S03-F04-E01. | Large box  S03-F04-E02 | The structure being shown in this large box reflects the user's choice, displaying any further 'sub-folders' available in the one chosen. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A02 | User double-clicks on an available folder showing in this large box [NAME]. | 'Look in' dropdown menu box  S03-F04-E01 | The new folder that was clicked on by the user is loaded into this dropdown menu box. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A03 | User double-clicks on an available folder showing in this large box [NAME]. | Large box  S03-F04-E02 | The structure being shown in this large box reflects the user's choice, displaying any further 'sub-folders' and any .csv files available in the new folder chosen. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | [NAME] | User chooses a destination folder available from the recent history in folder name dropdown menu box  S03-F04-E03. | Folder name dropdown menu box  S03-F04-E03 | The chosen folder name appears in this dropdown menu box. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | [NAME] | User chooses a destination folder available from the recent history in folder name dropdown menu box  S03-F04-E03. | 'Look in' dropdown menu box  S03-F04-E01 | The 'deepest' folder in the filepath from the chosen history item, is loaded into this dropdown menu box. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | [NAME] | User chooses a destination folder available from the recent history in folder name dropdown menu box  S03-F04-E03. | Large box  S03-F04-E02 | The structure being shown in this large box reflects the user's choice, displaying any further 'sub-folders' available in the 'deepest' folder in the filepath from the chosen history item, |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A05 | User clicks 'Cancel' button S03-F04-E04. | Excel 'filepath' dialogbox form  S03-F04 | This dialogbox form disappears.  Also, because the user chose to abort and not pick a filepath, the 'Export Results for 1 AB' procedure, begun by the user clicking button S03-E02, is terminated. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A06 | User clicks on S03-F04-E05, the 'X' at the top right of this form, or user hits 'Esc' key. | Excel 'filepath' dialogbox form  S03-F04 | This dialogbox form disappears.  Also, because the user chose to abort and not pick a filepath, the 'Export Results for 1 AB' procedure, begun by the user clicking button S03-E02, is terminated. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A07 | User clicks 'OK' button  S03-F04-E06, but rule  S03-F04-B01 is not met. | Excel 'filepath' dialogbox form  S03-F04 | Warning text is displayed, and the user is advised to choose a folder location further up the directory 'tree' (closer to the root of the drive) etc.    The user is returned to form S03-F04.    'Look in' dropdown menu [NAME] retains the filepath last chosen.    'Folder name' dropdown menu [NAME] is given the filepath last chosen as its first historical item listed. | [NAME] | The user's chosen filepath is accepted only if the combined length of the filepath and the planned filename is not more than 217 characters.  The planned filename is to be pre-set by the background function, and the user will not be able to affect it until after the export procedure has run to completion, at which time they can perform a standard Excel 'Save As', should they wish to do so. | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A08 | User clicks 'OK' button  S03-F04-E06, and rule  S03-F04-B01 is met. | Excel 'filepath' dialogbox form  S03-F04 | This dialogbox form disappears, and the user's filepath choice is stored by the background function for use later.  The 'Export Results for All ABs' procedure, begun by the user clicking button S03-E02, continues. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A08 | User clicks 'OK' button  S03-F04-E06, and rule  S03-F04-B01 is met. | Wait... Message form S03-F06 | This message form is displayed to the user.  It does not allow interaction and is 'display only'. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A08 | User clicks 'OK' button  S03-F04-E06, and rule  S03-F04-B01 is met. | main tool' | For each AB in the full ABs list, a copy of the tool is saved as a new output file, in which that AB is the focus.  In each such output file copy, further objects/items are afftected by action S03-F04-A08; these objects/items are given in the next rows below in this table, in green text font. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A08 | User clicks 'OK' button  S03-F04-E06, and rule  S03-F04-B01 is met. | In each new  output file, main tool instructions S01-E01 | This text is hidden from the user. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A08 | User clicks 'OK' button  S03-F04-E06, and rule  S03-F04-B01 is met. | In each new  output file, output file instructions S01-E02 | This text is made visible to the user. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A08 | User clicks 'OK' button  S03-F04-E06, and rule  S03-F04-B01 is met. | In each new output file, 'Import Data' sheet S02 | This sheet is hidden from the user. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A08 | User clicks 'OK' button  S03-F04-E06, and rule  S03-F04-B01 is met. | In each new output file, 'Export Data' sheet S03 | This sheet is hidden from the user. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A08 | User clicks 'OK' button  S03-F04-E06, and rule  S03-F04-B01 is met. | New output files | The new output files have all been saved and closed and so are not available for viewing on the screen. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A08 | User clicks 'OK' button  S03-F04-E06, and rule  S03-F04-B01 is met. | Wait... Message form S03-F06 | This message form is hidden from the user. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data | S03-F04-A08 | User clicks 'OK' button  S03-F04-E06, and rule  S03-F04-B01 is met. | main tool', history log S03-E03 | The 'Export Results for All ABs' procedure, begun by the user clicking button S03-E02, is complete.  The main tool is open and and contains the details of this export of all AB's results on new lines of the history log, one line per AB. |  |  | x | x |  | x | x |  | x | x
S03 | Export_Data |  |  |  |  | [NAME] | The worksheet is only visible to the user when the file is the Main Tool - in output files it is hidden. | x | x |  | x | x |  | x | x
S03 | Export_Data |  |  |  |  | S03-B02 | The worksheet will be password protected. | x | x |  | x | x |  | x | x