{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":91,"n_cols":6,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Test data or action","Purpose","Expected result","Actual result","Action"]
[null,"Open Game.html","Check that page opens","Game page visible","Game page visible","None"]
[null,"Check layout of game page","Ensure layout is correct","Every area of the screen is visible and in the correct place","Logo area missing, suspect area missing, banner too short","Find and add missing quotation marks in referenced CSS IDs, add 200px to banner width"]
[null,"Check layout of game page","Ensure layout is correct","Every area of the screen is visible and in the correct place","Suspect area still missing","Replace an erroneous colon with a semicolon at end of suspect area's width in CSS file"]
[null,"Check layout of game page","Ensure layout is correct","Every area of the screen is visible and in the correct place","Every area of the screen is visible and in the correct place","None"]
[null,"Open index.html","Check that page opens","Front page visible and everything in the correct place","Front page visible and everything in the correct place","None"]
[null,"Check layout of front page","Ensure layout is correct","Every area of the screen is visible and in the correct place","Everything is in the top-right corner","Apply 100% width and height to container CSS"]
[null,"Check layout of front page","Ensure layout is correct","Every area of the screen is visible and in the correct place","Content pane fills entire screen (it shouldn't)","Add missing semicolon to content pane CSS"]
[null,"Check layout of front page","Ensure layout is correct","Every area of the screen is visible and in the correct place","Content pane exceeds bottom edge, leaving a white strip when scrolling down","Change \"border\" in content pane CSS to \"margin\""]
[null,"Check layout of front page","Ensure layout is correct","Every area of the screen is visible and in the correct place","Content pane shows correctly at top, still exceeding bottom of container","Set absolute positions of 0 to all corners of the content pane, set top and bottom margins to 20px and left and right margins to 200px, set minimum width to 400px"]
[null,"Check layout of front page","Ensure layout is correct","Every area of the screen is visible and in the correct place","Every area of the screen is visible and in the correct place","None"]
[null,"Open index.html","Ensure intro page opens correctly","Intro page opens correctly and all divs are in the right place","Intro page opens correctly and all divs are in the right place","None"]
[null,"Open index.html, click button","Check functionality of intro button","New window opens with game page","New window does not open","Correct link to JS file - missing directory path"]
[null,"Open index.html, click button","Check functionality of intro button","New window opens with game page","Opens, but not the correct size","Add window name, add quotation marks around height and width parameters"]
[null,"Open index.html, click button","Check functionality of intro button","New window opens with game page","Opens, but not the correct size","Swap sizes around"]
[null,"Open index.html, click button","Check functionality of intro button","New window opens with game page","New window opens with game page","None"]
[null,"Open game page","Check that first room loads","First room description displays","First room description does not display","Add missing directory path to <script> element"]
[null,"Open game page","Check that first room loads","First room description displays","First room description does not display","Change \"Room[RoomNum][1]\" in InitialisePage() function to Room[0][1]"]
[null,"Open game page","Check that first room loads","First room description displays","First room description displays","None"]
[null,"Open game, click room link","Ensure room links go to correct room","Correct room displays after clicking link","Page does not display at all","Replace quotation marks in text strings with apostrophes to avoid conflicts"]
[null,"Open game, click room link","Ensure room links go to correct room","Correct room displays after clicking link","Correct room displays after clicking link","None"]
[null,"Hover over links","Check the reaction of the mouse pointer over links (links are not <a> elements, so need extra CSS to act like them)","Hand cursor displays","Hand cursor displays","None"]
[null,"Open game page","See if notepad displays correctly","Notepad displays correctly and fits in the frame","Notepad displays, but is too small","Add rows and columns properties to notepad CSS"]
[null,"Open game page","See if notepad displays correctly","Notepad displays correctly and fits in the frame","Notepad displays, but is too large","Reduce rows and columns values"]
[null,"Open game page","See if notepad displays correctly","Notepad displays correctly and fits in the frame","Still \"not quite right\"","Replace <div> using \"NotepadArea\" CSS with a <textarea> element instead, using the same CSS ID"]
[null,"Open game page","See if notepad displays correctly","Notepad displays correctly and fits in the frame","Notepad displays correctly and fits in the frame","None"]
[null,"Open game page","Test map rendering code, see if it works","Map displays correctly, rooms are all in the correct place","Map area displays \"undefined\" instead","Set MapCode variable to \"\" (null), change \"a\" to 0"]
[null,"Open game page","Test map rendering code, see if it works","Map displays correctly, rooms are all in the correct place","Map shows, but border misaligns everything slightly","Add code to RedrawMap() to reduce the size of each room by 2 pixels each way, to compensate for the border"]
[null,"Open game page","Test map rendering code, see if it works","Map displays correctly, rooms are all in the correct place","Map displays correctly, rooms are all in the correct place","None"]
[null,"Hover over map blocks","Check reaction of rooms on map when hovered over","Map rooms turn red when hovered over","Map rooms turn red when hovered over","None"]
[null,"Hover over map blocks","Ensure tooltip shows with room name","Tooltip appears when room is hovered over, showing the correct name of that room","Tooltip appears when room is hovered over, showing the correct name of that room","None"]
[null,"Repeat for all rooms","Ensure map of whole aparement works correctly","Map displays, each room turns red when hovered over and tooltip has correct name","Only two rooms show","Correct room numbers in Rooms.js to their correct ones"]
[null,"Repeat for all rooms","Ensure map of whole aparement works correctly","Map displays, each room turns red when hovered over and tooltip has correct name","Two rooms too far away, one overlaps Study","Increase left co-ordinates of far rooms by 50px each, increase left co-ordinates of overlapping room by 100px"]
[null,"Repeat for all rooms","Ensure map of whole aparement works correctly","Map displays, each room turns red when hovered over and tooltip has correct name","Tooltips cut off where apostrophes used","Replace apostrophes with the character code &#39;"]
[null,"Repeat for all rooms","Ensure map of whole aparement works correctly","Map displays, each room turns red when hovered over and tooltip has correct name","Map displays, each room turns red when hovered over and tooltip has correct name","None"]
[null,"Repeat for all rooms","Check to see if visited and unvisited rooms display correctly","Visited rooms show in lime green and react to hovering, unvisited rooms stay dark green and cannot be clicked","Visited rooms show in lime green and react to hovering, unvisited rooms stay dark green and cannot be clicked","None"]
[null,"Click rooms on map","Ensure the map works correctly","Visited rooms go straight to that room, unvisited rooms do nothing","All rooms do nothing","Correct single equals mark in if statement to a double equals mark"]
[null,"Click rooms on map","Ensure the map works correctly","Visited rooms go straight to that room, unvisited rooms do nothing","Visited rooms go straight to that room, unvisited rooms do nothing","None"]
[null,"Reload game page","Check clue link appearance","Clue links show as dark blue","Clue links show as dark blue","None"]
[null,"Hover over clue link","Check that clue links display and react correctly","Clue links show as dark blue, red when hovered over","Clue links show as dark blue, red when hovered over","None"]
[null,"Click clue link","Check link behaviour","Clicking link takes player to the correct clue","Clicking link takes player to the correct clue","None"]
[null,"Click clue link","Ensure clue question displays correctly","Question and answer choices display correctly","Answer C on Answer B's line, separated by \"NaN\"","Remove an excess + in concatenation forumla assembling the clue's HTML"]
[null,"Click clue link","Ensure clue question displays correctly","Question and answer choices display correctly","Question and answer choices display correctly","None"]
[null,"Click answer links","Make sure answer links work","Clicking each answer returns a \"correct\" or \"incorrect\" response","Links don't react to clicking","Add missing closing brackets"]
[null,"Click answer links","Make sure answer links work","Clicking each answer returns a \"correct\" or \"incorrect\" response","Links don't react to clicking","Change correct answer variable to a number and call to related function to match"]
[null,"Click answer links","Make sure answer links work","Clicking each answer returns a \"correct\" or \"incorrect\" response","Clicking each answer returns a \"correct\" or \"incorrect\" response","None"]
[null,"Go to kitchen, click rubbish bin","Test clues that don't have questions","Clue displays and doesn't try to ask a nonexistent question","Clue displays investigated warning instead","Correct clue array values"]
[null,"Go to kitchen, click rubbish bin","Test clues that don't have questions","Clue displays and doesn't try to ask a nonexistent question","Clue displays and doesn't try to ask a nonexistent question","None"]
[null,"Click TV","Check for link back to room within clue","Link to room of origin shows","Link does not show","Add missing apostrophe"]
[null,"Click TV","Check for link back to room within clue","Link to room of origin shows","Link to room of origin shows","None"]
[null,"Click room link in clue","Check functionality of room return link","Link returns to original room","Link does not respond","Move newly-added apostrophe to correct location"]
[null,"Click room link in clue","Check functionality of room return link","Link returns to original room","Link returns to original room","None"]
[null,"Click bin","Check for link back to room within clue","Link to room of origin shows","Link to room of origin shows","None"]
[null,"Click room link in clue","Check functionality of room return link",null,"Link returns to original room","None"]
[null,"Click answer links","Check for room links in answer response","Room link shows","Room link shows","None"]
[null,"Click room links in answer response","Check functionality of room return link","Link returns to original room","Link returns to original room","None"]
[null,"Fully investigate clues and click them again","Check clue reaction to investigated flag","Investigated clues will warn player that they have already been looked at","Question clues react to the flag correctly, non-question clues don't","Relocate code to change flag in non-question clues to the correct place"]
[null,"Fully investigate clues and click them again","Check clue reaction to investigated flag","Investigated clues will warn player that they have already been looked at","Investigated clues react correctly, but no longer respond to answer clicks","Define \"StepAwayLink\" in GoToAnswer() function"]
[null,"Fully investigate clues and click them again","Check clue reaction to investigated flag","Investigated clues will warn player that they have already been looked at","Investigated clues will warn player that they have already been looked at","None"]
[null,"Re-investigate clues","Check for return link","Return link shows under investigated warning","Return link shows for question clues, and non-question clues","None"]
[null,"Reload game page","Ensure score shows","Score shows in suspect area","Yes, but on the left rather than centre","Add \"text-align: center\" to suspect area CSS"]
[null,"Reload game page","Ensure score shows","Score shows in suspect area","Score shows in suspect area","None"]
[null,"Reload game page","Ensure clue count for each room shows","Clue count for each room shows","Clue count for each room shows","None"]
[null,"Investigate a clue and then move to another room","Check functionality of clue counter","Clues counter decreases with each investigated clue and updates to the correct room when moving","Clue counter does not update at all","Amend calls to Room array to reference correct index"]
[null,"Investigate a clue and then move to another room","Check functionality of clue counter","Clues counter decreases with each investigated clue and updates to the correct room","Clue counter decreases, but does not update to the correct room when moving","Add call to RedrawScore() to GoToRoom()"]
[null,"Investigate a clue and then move to another room","Check functionality of clue counter","Clues counter decreases with each investigated clue and updates to the correct room","Clues counter decreases with each investigated clue and updates to the correct room","None"]
[null,"Check investigated clue again","Ensure clue counter does not react to an already-investigated clue","Clue counter remains the same when checking an already-investigated clue","Clue counter remains the same when checking an already-investigated clue","None"]
[null,"Reload game page","Check suspect area additions","Check-boxes for each suspect and an accuse button show under the score and clue count","Check-boxes and button show, but all on one line","Add <p> tags around each <input>"]
[null,"Reload game page","Check suspect area additions","Check-boxes for each suspect and an accuse button show under the score and clue count","Check-boxes for each suspect and an accuse button show under the score and clue count","None"]
[null,"Reload game page","Check disabled status of suspect area inputs","Inputs are disabled and unusable","Form is disabled and unusable","None"]
[null,"Reload game page, investigate clues","Check reaction of form and inputs when all clues are investigated","Form enables once all clues have been fully investigated","Page appears blank apart from layout","Corrected for loop in RedrawSuspectArea() to conform to JavaScript standards"]
[null,"Reload game page, investigate clues","Check reaction of form and inputs when all clues are investigated","Form enables once all clues have been fully investigated","Form enables once all clues have been fully investigated","None"]
[null,"Make an accusation","Check functionality of accuse button","Alert gives correct numbers based on which suspects are checked","Everything has disappeared again","Add brackets to the alert() call"]
[null,"Make an accusation","Check functionality of accuse button","Alert gives correct numbers based on which suspects are checked","Alert gives correct numbers based on which suspects are checked","None"]
[null,"Make an accusation","Check functionality of accuse button","Button takes player to end page","Button takes player to end page","None"]
[null,"Make an accusation","Check functionality of accuse button","Button passes score and ending number in ending page URL","Button passes score and ending number in ending page URL","None"]
[null,"Make an accusation","Check functionality of accuse button and ending page","Correct ending displays","Yes, but close button is missing","Add code to append input HTML to ending HTML"]
[null,"Make an accusation","Check functionality of accuse button and ending page","Correct ending displays","Yes, and close button shows","None"]
[null,"Reload page","Ensure all rooms are available to the player","All rooms can be travelled to","Page is blank again","Replace single quotation marks with apostrophes"]
[null,"Reload page","Ensure all rooms are available to the player","All rooms can be travelled to","All rooms can be travelled to","None"]
[null,"Click all room links","Ensure all room links go to the correct room","All room links lead to the correct room","Two rooms show swapped clues","Swap room arrays around and adjust their clue links accordingly"]
[null,"Click all room links","Ensure all room links go to the correct room","All room links lead to the correct room","Previous two rooms now in the wrong place","Swap bottom co-ordinates between rooms"]
[null,"Click all room links","Ensure all room links go to the correct room","All room links lead to the correct room","All room links lead to the correct room","None"]
[null,"Click all clue links","Check functionality of clue links","All clue links lead to the correct clue and their return links return to the correct room","All clue links lead to the correct clues, but in the swapped rooms, the return links lead to the wrong room","Correct the original room variable in each clue"]
[null,"Click all clue links","Check functionality of clue links","All clue links lead to the correct clue and their return links return to the correct room","All clue links lead to the correct clue and their return links return to the correct room","None"]
[null,"Answer all question links","Ensure continued functionality of answer links","Correct answers and incorrect answers still respond accordingly","Correct answers and incorrect answers still respond accordingly","None"]
[null,"Make an accusation","Check endings","Correct endings display","Ending text extends beyond window","Add overflow-y: auto to ending area CSS"]
[null,"Make an accusation","Check endings","Correct endings display","Correct endings display","None"]
[null,"Refresh ending page","Check for final score","Final score displays correctly","Final score misaligned","Adjust postion values of score header and score CSS, add a 10px margin"]
[null,"Refresh ending page","Check for final score","Final score displays correctly","Final score displays correctly","None"]

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

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