{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["START","Time 1","Time 2","Results","Calculations","spare sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"START","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,12],[17,0,17,12],[18,0,18,12],[10,0,10,12],[13,0,13,12],[14,0,14,12],[21,0,21,12],[22,0,22,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[4,0,4,12],[6,1,6,12],[8,1,8,12],[9,0,9,12],[7,0,7,12],[12,0,12,12],[15,0,15,12],[16,0,16,12]]}
["The WEB calculation workbook, using the Wilcoxon Signed Rank Test "]
[null,"By Sue Hacking, University of Central Lancashire"]
[null,"This workbook was designed by Sue Hacking to compare before and after measures of social inclusion on the WEB diagram, a measure developed for clinical assessment of social inclusion for people with mental health needs, designed by Bates (2002) and contributed to by others."]
[]
["TABLE OF CONTENTS"]
[]
["Start -- ","Calculating W (the Wilcoxon test statistic) from your time1 (before) and time2 (after) paired figures - instructions and notes"]
["Time 1 and Time 2 sheet - input your figures here"]
["Results -","All the statistics and figures set out for you  PROTECTED - NO INPUT  "]
["Calculations - the tables that the results sheet comes from with explanations  PROTECTED - NO INPUT "]
["Spare sheet - in case you want to paste multiple results and reuse the tables and test"]
[]
["Instructions - 3 easy steps to success!"]
["Step 1 - How many cases?"]
["Go to time 1 sheet and choose whether you need more than 30 rows.  If you have more than 30 cases it affects the calculation.  You can choose 30 cases to start with at time 1 and then add more to them later.  You can't have more than 50 cases.  You need a different test for that."]
["Step 1 - Input Appropriate Numbers"]
["For each participant enter the numbers of people and places on the time 1 and time 2 sheets.  Time 1 case 1 MUST be the same individual as Time 2 case 1 and so on for every case.  You must have both figures for every case I.e. no cases with time 1 but not time 2 or vice versa. A warning box appears otherwise."]
["Step 2 - Report your results"]
["To report results - you need - only the tables on the results page, you can copy and paste these (but not alter them).  As far as possible in simple language and if you want more explanations, on the Calculations page all the boxes in colours and white appear - those with little red triangles have help boxes (hover your pointer over them) which explain the results.  The only purpose of the calculations page is to generate the tables (you don't need to look at it otherwise) the sheet is protected and you can't alter it."]
[]
["Acknowledgements"]
["This spreadsheet uses lookup tables available from the public domain. For samples of 10 or more - Definitions and formulae with statistical tables for elementary statistics and quantitative methods courses, University of Oxford, Dept. Statistics, October 2005.  http://www.oxford.ac.uk/stats "]
["From Richard Lowry (2006) Subchapter 12a  The Wilcoxon signed rank test: provides a table of critical values for samples of below 10.  http://faculty.vassar.edu/lowry/      With thanks to Peter Bates for developing the concept, Sue Hacking for designing this spreadsheet, and Laurie Hareduke for updating it to the 2016 version of the Inclusion Web"]
["Critical z-values same source",null,null,"http://faculty.vassar.edu/lowry/"]
[]
["Problems",null,null,{"$f":"IF(C26=\"help\", \"Hi, I'm Laurie, email me on laurie.hare-duke@nottshc.nhs.uk and I'll try to help\",\"\")","v":""}]
["If something is not working on the sheet, type 'help' in the green box and watch this space.  This workbook is version 3 - there may be bugs."]
[]
[]
[]
["end of sheet"]

{"sheet":"Time 1","index":1,"n_rows":55,"n_cols":27,"rows_kept":55,"cut":false,"hidden":false,"merged":[[2,0,2,25],[1,0,1,26],[3,20,3,22],[3,23,4,25],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[3,16,3,17],[3,18,3,19]]}
["Important -Number of cases - check the box"]
["Enter <end> (without the <>) in the first column ONLY of every empty case."]
["Delete the blue figures in the white columns - and input your own - - - don't touch the grey columns, they will calculate themselves"]
["The Web","Client","Services",null,"Online",null,"Volunteering",null,"Sports",null,"Identity",null,"Learning",null,"Employment",null,"Neighbourhood",null,"Arts",null,"Totals",null,null,"Cases - If you can, it is better to compare 10 or more cases, but if you have less, the calculation adjusts for below 10 cases.",null,null,2]
["Time 1","No.","Places","People","Places","People","Places","People","Places","People","Places","People","Places","People","Places","People","Places","People","Places","People","Places","People","Clock Spread",null,null,null,2]
[null,1,"end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C6=\"end\",\"end\",SUM(C6+E6+G6+I6+K6+M6+O6+Q6+S6))","v":"end"},{"$f":"IF(C6=\"end\",\"end\",SUM(D6+F6+H6+J6+L6+N6+P6+R6+T6))","v":"end"},{"$f":"IF(C6=\"end\",\"end\",IF(AND(C6=0,D6=0),0,1)+IF(AND(E6=0,F6=0),0,1)+IF(AND(G6=0,H6=0),0,1)+IF(AND(I6=0,J6=0),0,1)+IF(AND(K6=0,L6=0),0,1)+IF(AND(M6=0,N6=0),0,1)+IF(AND(O6=0,P6=0),0,1)+IF(AND(Q6=0,R6=0),0,1)+IF(AND(S6=0,T6=0),0,1))","v":"end"}]
[null,{"$f":"IF(COUNT(C7)=0,\"\",B6+1)","v":""},"end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7=\"end\",\"end\",SUM(C7+E7+G7+I7+K7+M7+O7+Q7+S7))","v":"end"},{"$f":"IF(C7=\"end\",\"end\",SUM(D7+F7+H7+J7+L7+N7+P7+R7+T7))","v":"end"},{"$f":"IF(C7=\"end\",\"end\",IF(AND(C7=0,D7=0),0,1)+IF(AND(E7=0,F7=0),0,1)+IF(AND(G7=0,H7=0),0,1)+IF(AND(I7=0,J7=0),0,1)+IF(AND(K7=0,L7=0),0,1)+IF(AND(M7=0,N7=0),0,1)+IF(AND(O7=0,P7=0),0,1)+IF(AND(Q7=0,R7=0),0,1)+IF(AND(S7=0,T7=0),0,1))","v":"end"}]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,{"$f":"IF(COUNT(C21)=0,\"\",B20+1)","v":""},"end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,{"$f":"IF(COUNT(C30)=0,\"\",B29+1)","v":""},"end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]

{"sheet":"Time 2","index":2,"n_rows":55,"n_cols":25,"rows_kept":55,"cut":false,"hidden":false,"merged":[[5,24,10,25],[3,20,3,22],[3,18,3,19],[0,0,0,25],[2,0,2,26],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,23,4,25],[3,10,3,11],[3,12,3,13],[3,14,3,15],[3,16,3,17]]}
["Delete the blue figures in the white columns - and input your own - - - don't touch the grey columns, they will calculate themselves"]
[]
["Important - If you don't have 30 cases - enter <end> (without the <>) in the first column ONLY of every empty case."]
["The Web","Client","Services",null,"Online",null,"Volunteering",null,"Sports",null,"Identity",null,"Learning",null,"Employment",null,"Neighbourhood",null,"Arts",null,"Totals",null,null,{"$f":"IF((COUNTIF(C6:C55,\"end\"))=(COUNTIF('Time 1'!C6:C55,\"end\")),\"\",\"PROBLEM ! ! ! ! ! !  YOU HAVE DIFFERENT NUMBERS OF CASES IN TIME 1 AND TIME 2\")","v":""}]
["Time 2","No.","Places","People","Places","People","Places","People","Places","People","Places","People","Places","People","Places","People","Places","People","Places","People","Places","People","Clock Spread"]
[null,1,"end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C6=\"end\",\"end\",SUM(C6+E6+G6+I6+K6+M6+O6+Q6+S6))","v":"end"},{"$f":"IF(C6=\"end\",\"end\",SUM(D6+F6+H6+J6+L6+N6+P6+R6+T6))","v":"end"},{"$f":"IF(C6=\"end\",\"end\",IF(AND(C6=0,D6=0),0,1)+IF(AND(E6=0,F6=0),0,1)+IF(AND(G6=0,H6=0),0,1)+IF(AND(I6=0,J6=0),0,1)+IF(AND(K6=0,L6=0),0,1)+IF(AND(M6=0,N6=0),0,1)+IF(AND(O6=0,P6=0),0,1)+IF(AND(Q6=0,R6=0),0,1)+IF(AND(S6=0,T6=0),0,1))","v":"end"},null,"NOTE  -----------         If red warning appears in square above, number of cases are not equal in time 1 and time 2"]
[null,{"$f":"IF(COUNT(C7)=0,\"\",B6+1)","v":""},"end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7=\"end\",\"end\",SUM(C7+E7+G7+I7+K7+M7+O7+Q7+S7))","v":"end"},{"$f":"IF(C7=\"end\",\"end\",SUM(D7+F7+H7+J7+L7+N7+P7+R7+T7))","v":"end"},{"$f":"IF(C7=\"end\",\"end\",IF(AND(C7=0,D7=0),0,1)+IF(AND(E7=0,F7=0),0,1)+IF(AND(G7=0,H7=0),0,1)+IF(AND(I7=0,J7=0),0,1)+IF(AND(K7=0,L7=0),0,1)+IF(AND(M7=0,N7=0),0,1)+IF(AND(O7=0,P7=0),0,1)+IF(AND(Q7=0,R7=0),0,1)+IF(AND(S7=0,T7=0),0,1))","v":"end"}]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C36=\"end\",\"end\",SUM(C36+E36+G36+I36+K36+M36+O36+Q36+S36))","v":"end"},{"$f":"IF(C36=\"end\",\"end\",SUM(D36+F36+H36+J36+L36+N36+P36+R36+T36))","v":"end"},{"$f":"IF(C36=\"end\",\"end\",IF(AND(C36=0,D36=0),0,1)+IF(AND(E36=0,F36=0),0,1)+IF(AND(G36=0,H36=0),0,1)+IF(AND(I36=0,J36=0),0,1)+IF(AND(K36=0,L36=0),0,1)+IF(AND(M36=0,N36=0),0,1)+IF(AND(O36=0,P36=0),0,1)+IF(AND(Q36=0,R36=0),0,1)+IF(AND(S36=0,T36=0),0,1))","v":"end"}]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]
[null,"","end",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"end","end","end"]

{"sheet":"Results","index":3,"n_rows":69,"n_cols":22,"rows_kept":69,"cut":false,"hidden":false,"merged":[[17,15,18,21],[1,1,1,21],[5,2,5,9],[3,12,3,16],[4,12,4,16],[5,12,5,16],[9,16,9,21],[9,2,9,3],[17,2,17,4],[17,5,17,7],[17,8,17,10],[17,11,17,13],[8,16,8,21],[16,1,16,22],[11,2,11,3],[10,16,10,21],[25,15,26,21],[27,16,27,17],[27,18,27,19],[27,20,27,21],[19,16,19,17],[19,18,19,19],[19,20,19,21],[13,2,13,3],[9,4,9,5],[11,4,11,5],[13,4,13,5],[8,4,8,5],[0,1,0,21],[3,2,3,9],[4,2,4,9],[12,16,12,20],[2,2,2,18],[11,16,11,21],[8,2,8,3]]}
[null,"Do not alter this page but you can copy and paste the results to the spare sheet to edit them.                      To paste use <rightclick> paste-special <values>              Sue Hacking University Central Lancashire ©"]
[null,"This page contains all data that you need to report if you were presenting a paper.  Most of the time, either the z test or the t-statistic will be shown but if you get both, use the t- statistic for 20 cases and under and the z-statistic for over 20 cases.  It's OK to report both figures."]
[null,null,"Results of the Wilcoxon Signed Rank Test for paired observations"]
[null,"Places ",{"$f":"IF(K4=\"N/A\",\"Use the z-ratio\",IF((COUNT(Calculations!L19))=1,\"The Test Value T WAS smaller than the critical value\",\"The T Value was NOT smaller than the critical value\"))","v":"The T Value was NOT smaller than the critical value"},null,null,null,null,null,null,null,{"$f":"IF(Calculations!E26=\"yes\",Calculations!E25, IF(Calculations!E24=\"yes\",Calculations!E23, IF(Calculations!E22=\"yes\",Calculations!E21,Calculations!E21)))","v":0},"   -",{"$f":"IF(K4=\"N/A\",\"\",IF((COUNT(Calculations!L19))=1,\"The Test was statistically significant at the\",\"The Test was not statistically signifant at the\"))","v":"The Test was not statistically signifant at the"},null,null,null,null,{"$f":"IF(K4=\"N/A\",\"\",IF((COUNT(Calculations!L19))=1,Calculations!L19,\"0.05\"))","v":"0.05"},"level."]
[null,"People",{"$f":"IF(K5=\"N/A\",\"Use the z-ratio\",IF((COUNT(Calculations!L20))=1,\"The Test Value T WAS smaller than the critical value\",\"The T Value was NOT smaller than the critical value\"))","v":"The T Value was NOT smaller than the critical value"},null,null,null,null,null,null,null,{"$f":"IF(Calculations!F26=\"yes\",Calculations!F25, IF(Calculations!F24=\"yes\",Calculations!F23, IF(Calculations!F22=\"yes\",Calculations!F21,Calculations!F21)))","v":0},"   -",{"$f":"IF(K5=\"N/A\",\"\",IF((COUNT(Calculations!L20))=1,\"The Test was statistically significant at the\",\"The Test was not statistically signifant at the\"))","v":"The Test was not statistically signifant at the"},null,null,null,null,{"$f":"IF(K5=\"N/A\",\"\",IF((COUNT(Calculations!L20))=1,Calculations!L20,\"0.05\"))","v":"0.05"},"level."]
[null,"Clock spread",{"$f":"IF(K6=\"N/A\",\"Use the z-ratio\",IF((COUNT(Calculations!L21))=1,\"The Test Value T WAS smaller than the critical value\",\"The T Value was NOT smaller than the critical value\"))","v":"The T Value was NOT smaller than the critical value"},null,null,null,null,null,null,null,{"$f":"IF(Calculations!G26=\"yes\",Calculations!G25, IF(Calculations!G24=\"yes\",Calculations!G23, IF(Calculations!G22=\"yes\",Calculations!G21,Calculations!G21)))","v":0},"   -",{"$f":"IF(K6=\"N/A\",\"\",IF((COUNT(Calculations!L21))=1,\"The Test was statistically significant at the\",\"The Test was not statistically signifant at the\"))","v":"The Test was not statistically signifant at the"},null,null,null,null,{"$f":"IF(K6=\"N/A\",\"\",IF((COUNT(Calculations!L21))=1,Calculations!L21,\"0.05\"))","v":"0.05"},"level."]
[]
[null,"Results for Z-ratio  (if test has over 10 cases)"]
[null,null,"Std. Dev.",null,"Z- ratio",null,"Results",null,"(see help box for critical values of z)",null,null,null,null,null,null,null,{"$f":"IF('Time 1'!AA5=1, \"Results for more than 30 cases\",\"Results for 30 cases or less\")","v":"Results for 30 cases or less"}]
[null,"Places ",{"$f":"Calculations!E34","v":0},null,{"$f":"Calculations!E35","v":"XX"},null,{"$f":"Calculations!J34","v":"Not enough cases"},null,null,null,null,null,null,null,null,null,"* The time 1 and Time 2 totals were added up and are shown as total scores in the table."]
[null,null,null,null,null,null,{"$f":"Calculations!J35","v":""},null,null,null,null,null,null,null,null,null,"* Delete cases where <end> appears in first column"]
[null,"People",{"$f":"Calculations!F34","v":0},null,{"$f":"Calculations!F35","v":"XX"},null,{"$f":"Calculations!J36","v":"Not enough cases"},null,null,null,null,null,null,null,null,null,"* x OR XX means no differences - no calculations"]
[null,null,null,null,null,null,{"$f":"Calculations!J37","v":""},null,null,null,null,null,null,null,null,null,"* N/A means not applicable "]
[null,"Clock ",{"$f":"Calculations!G34","v":0},null,{"$f":"Calculations!G35","v":"XX"},null,{"$f":"Calculations!J38","v":"Not enough cases"}]
[null,"spread",null,null,null,null,{"$f":"Calculations!J39","v":""}]
[]
[null,{"$f":"IF('Time 2'!X4=\"\",\"\",\"PROBLEM These results NOT VALID!  You MUST have equal numbers of cases in time 1/ time 2!\")","v":""}]
[null,null,"TIME 1 TOTALS",null,null,"TIME 2 TOTALS",null,null,"DIFFERENCES",null,null,"SIGNED RANKS",null,null,null,"Descriptive statistics for places, people, clockspread at  time 1 and time 2"]
[null,"Pairs","Places","People","Clock spread","Places","People","Clock spread","Places","People","Clock spread","Places","People","Clock spread"]
[null,1,{"$f":"Calculations!S7","v":"end"},{"$f":"Calculations!T7","v":"end"},{"$f":"Calculations!U7","v":"end"},{"$f":"Calculations!V7","v":"end"},{"$f":"Calculations!W7","v":"end"},{"$f":"Calculations!X7","v":"end"},{"$f":"Calculations!Y7","v":"x"},{"$f":"Calculations!Z7","v":"x"},{"$f":"Calculations!AA7","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ7,Calculations!AH7)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR7,Calculations!AI7)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS7,Calculations!AJ7)","v":"x"},null,null,"Places",null,"People",null,"Clockspread"]
[null,2,{"$f":"Calculations!S8","v":"end"},{"$f":"Calculations!T8","v":"end"},{"$f":"Calculations!U8","v":"end"},{"$f":"Calculations!V8","v":"end"},{"$f":"Calculations!W8","v":"end"},{"$f":"Calculations!X8","v":"end"},{"$f":"Calculations!Y8","v":"x"},{"$f":"Calculations!Z8","v":"x"},{"$f":"Calculations!AA8","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ8,Calculations!AH8)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR8,Calculations!AI8)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS8,Calculations!AJ8)","v":"x"},null,null,"Mean ","SD","Mean ","SD","Mean ","SD"]
[null,3,{"$f":"Calculations!S9","v":"end"},{"$f":"Calculations!T9","v":"end"},{"$f":"Calculations!U9","v":"end"},{"$f":"Calculations!V9","v":"end"},{"$f":"Calculations!W9","v":"end"},{"$f":"Calculations!X9","v":"end"},{"$f":"Calculations!Y9","v":"x"},{"$f":"Calculations!Z9","v":"x"},{"$f":"Calculations!AA9","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ9,Calculations!AH9)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR9,Calculations!AI9)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS9,Calculations!AJ9)","v":"x"},null,"Time 1",{"$f":"IF('Time 1'!AA5=1,Calculations!S59,Calculations!S57)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!AA5=1,Calculations!S60,Calculations!S58)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!AA5=1,Calculations!T59,Calculations!T57)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!AA5=1,Calculations!T60,Calculations!T58)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!AA5=1,Calculations!U59,Calculations!U57)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!AA5=1,Calculations!U60,Calculations!U58)","v":{"$error":"#DIV/0!"}}]
[null,4,{"$f":"Calculations!S10","v":"end"},{"$f":"Calculations!T10","v":"end"},{"$f":"Calculations!U10","v":"end"},{"$f":"Calculations!V10","v":"end"},{"$f":"Calculations!W10","v":"end"},{"$f":"Calculations!X10","v":"end"},{"$f":"Calculations!Y10","v":"x"},{"$f":"Calculations!Z10","v":"x"},{"$f":"Calculations!AA10","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ10,Calculations!AH10)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR10,Calculations!AI10)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS10,Calculations!AJ10)","v":"x"},null,"Time 2",{"$f":"IF('Time 1'!AA5=1,Calculations!V59,Calculations!V57)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!AA5=1,Calculations!V60,Calculations!V58)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!AA5=1,Calculations!W59,Calculations!W57)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!AA5=1,Calculations!W60,Calculations!W58)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!AA5=1,Calculations!X59,Calculations!X57)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!AA5=1,Calculations!X60,Calculations!X58)","v":{"$error":"#DIV/0!"}}]
[null,5,{"$f":"Calculations!S11","v":"end"},{"$f":"Calculations!T11","v":"end"},{"$f":"Calculations!U11","v":"end"},{"$f":"Calculations!V11","v":"end"},{"$f":"Calculations!W11","v":"end"},{"$f":"Calculations!X11","v":"end"},{"$f":"Calculations!Y11","v":"x"},{"$f":"Calculations!Z11","v":"x"},{"$f":"Calculations!AA11","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ11,Calculations!AH11)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR11,Calculations!AI11)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS11,Calculations!AJ11)","v":"x"},null,"Differences",{"$f":"IF('Time 1'!AA5=1,Calculations!Y59,Calculations!Y57)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF('Time 1'!AA5=1,Calculations!Z59,Calculations!Z57)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF('Time 1'!AA5=1,Calculations!AA59,Calculations!AA57)","v":{"$error":"#DIV/0!"}}]
[null,6,{"$f":"Calculations!S12","v":"end"},{"$f":"Calculations!T12","v":"end"},{"$f":"Calculations!U12","v":"end"},{"$f":"Calculations!V12","v":"end"},{"$f":"Calculations!W12","v":"end"},{"$f":"Calculations!X12","v":"end"},{"$f":"Calculations!Y12","v":"x"},{"$f":"Calculations!Z12","v":"x"},{"$f":"Calculations!AA12","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ12,Calculations!AH12)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR12,Calculations!AI12)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS12,Calculations!AJ12)","v":"x"}]
[null,7,{"$f":"Calculations!S13","v":"end"},{"$f":"Calculations!T13","v":"end"},{"$f":"Calculations!U13","v":"end"},{"$f":"Calculations!V13","v":"end"},{"$f":"Calculations!W13","v":"end"},{"$f":"Calculations!X13","v":"end"},{"$f":"Calculations!Y13","v":"x"},{"$f":"Calculations!Z13","v":"x"},{"$f":"Calculations!AA13","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ13,Calculations!AH13)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR13,Calculations!AI13)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS13,Calculations!AJ13)","v":"x"},null,"Descriptive statistics for the Wilcoxon Signed Rank Test for paired observations"]
[null,8,{"$f":"Calculations!S14","v":"end"},{"$f":"Calculations!T14","v":"end"},{"$f":"Calculations!U14","v":"end"},{"$f":"Calculations!V14","v":"end"},{"$f":"Calculations!W14","v":"end"},{"$f":"Calculations!X14","v":"end"},{"$f":"Calculations!Y14","v":"x"},{"$f":"Calculations!Z14","v":"x"},{"$f":"Calculations!AA14","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ14,Calculations!AH14)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR14,Calculations!AI14)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS14,Calculations!AJ14)","v":"x"}]
[null,9,{"$f":"Calculations!S15","v":"end"},{"$f":"Calculations!T15","v":"end"},{"$f":"Calculations!U15","v":"end"},{"$f":"Calculations!V15","v":"end"},{"$f":"Calculations!W15","v":"end"},{"$f":"Calculations!X15","v":"end"},{"$f":"Calculations!Y15","v":"x"},{"$f":"Calculations!Z15","v":"x"},{"$f":"Calculations!AA15","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ15,Calculations!AH15)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR15,Calculations!AI15)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS15,Calculations!AJ15)","v":"x"},null,null,"Places",null,"People",null,"Clockspread"]
[null,10,{"$f":"Calculations!S16","v":"end"},{"$f":"Calculations!T16","v":"end"},{"$f":"Calculations!U16","v":"end"},{"$f":"Calculations!V16","v":"end"},{"$f":"Calculations!W16","v":"end"},{"$f":"Calculations!X16","v":"end"},{"$f":"Calculations!Y16","v":"x"},{"$f":"Calculations!Z16","v":"x"},{"$f":"Calculations!AA16","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ16,Calculations!AH16)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR16,Calculations!AI16)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS16,Calculations!AJ16)","v":"x"},null,null,"Value","No.","Value ","No.","Value","No."]
[null,11,{"$f":"Calculations!S17","v":"end"},{"$f":"Calculations!T17","v":"end"},{"$f":"Calculations!U17","v":"end"},{"$f":"Calculations!V17","v":"end"},{"$f":"Calculations!W17","v":"end"},{"$f":"Calculations!X17","v":"end"},{"$f":"Calculations!Y17","v":"x"},{"$f":"Calculations!Z17","v":"x"},{"$f":"Calculations!AA17","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ17,Calculations!AH17)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR17,Calculations!AI17)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS17,Calculations!AJ17)","v":"x"},null,"Tied pairs",null,{"$f":"Calculations!E7","v":0},null,{"$f":"Calculations!F7","v":0},null,{"$f":"Calculations!G7","v":0}]
[null,12,{"$f":"Calculations!S18","v":"end"},{"$f":"Calculations!T18","v":"end"},{"$f":"Calculations!U18","v":"end"},{"$f":"Calculations!V18","v":"end"},{"$f":"Calculations!W18","v":"end"},{"$f":"Calculations!X18","v":"end"},{"$f":"Calculations!Y18","v":"x"},{"$f":"Calculations!Z18","v":"x"},{"$f":"Calculations!AA18","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ18,Calculations!AH18)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR18,Calculations!AI18)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS18,Calculations!AJ18)","v":"x"},null,"Positive pairs",{"$f":"Calculations!E8","v":0},{"$f":"IF('Time 1'!AA5=1,Calculations!AQ67,Calculations!AH67)","v":0},{"$f":"Calculations!F8","v":0},{"$f":"IF('Time 1'!AA5=1,Calculations!AR67,Calculations!AI67)","v":0},{"$f":"Calculations!G8","v":0},{"$f":"IF('Time 1'!AA5=1,Calculations!AS67,Calculations!AJ67)","v":0}]
[null,13,{"$f":"Calculations!S19","v":"end"},{"$f":"Calculations!T19","v":"end"},{"$f":"Calculations!U19","v":"end"},{"$f":"Calculations!V19","v":"end"},{"$f":"Calculations!W19","v":"end"},{"$f":"Calculations!X19","v":"end"},{"$f":"Calculations!Y19","v":"x"},{"$f":"Calculations!Z19","v":"x"},{"$f":"Calculations!AA19","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ19,Calculations!AH19)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR19,Calculations!AI19)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS19,Calculations!AJ19)","v":"x"},null,"Negative pairs",{"$f":"Calculations!E9","v":0},{"$f":"IF('Time 1'!AA5=1,Calculations!AQ68,Calculations!AH68)","v":0},{"$f":"Calculations!F9","v":0},{"$f":"IF('Time 1'!AA5=1,Calculations!AR68,Calculations!AI68)","v":0},{"$f":"Calculations!G9","v":0},{"$f":"IF('Time 1'!AA5=1,Calculations!AS68,Calculations!AJ68)","v":0}]
[null,14,{"$f":"Calculations!S20","v":"end"},{"$f":"Calculations!T20","v":"end"},{"$f":"Calculations!U20","v":"end"},{"$f":"Calculations!V20","v":"end"},{"$f":"Calculations!W20","v":"end"},{"$f":"Calculations!X20","v":"end"},{"$f":"Calculations!Y20","v":"x"},{"$f":"Calculations!Z20","v":"x"},{"$f":"Calculations!AA20","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ20,Calculations!AH20)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR20,Calculations!AI20)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS20,Calculations!AJ20)","v":"x"},null,"Sum of ranks",{"$f":"Calculations!E14","v":0},null,{"$f":"Calculations!F14","v":0},null,{"$f":"Calculations!G14","v":0}]
[null,15,{"$f":"Calculations!S21","v":"end"},{"$f":"Calculations!T21","v":"end"},{"$f":"Calculations!U21","v":"end"},{"$f":"Calculations!V21","v":"end"},{"$f":"Calculations!W21","v":"end"},{"$f":"Calculations!X21","v":"end"},{"$f":"Calculations!Y21","v":"x"},{"$f":"Calculations!Z21","v":"x"},{"$f":"Calculations!AA21","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ21,Calculations!AH21)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR21,Calculations!AI21)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS21,Calculations!AJ21)","v":"x"},null,"Test statistic (T)",{"$f":"Calculations!E13","v":0},null,{"$f":"Calculations!F13","v":0},null,{"$f":"Calculations!G13","v":0}]
[null,16,{"$f":"Calculations!S22","v":"end"},{"$f":"Calculations!T22","v":"end"},{"$f":"Calculations!U22","v":"end"},{"$f":"Calculations!V22","v":"end"},{"$f":"Calculations!W22","v":"end"},{"$f":"Calculations!X22","v":"end"},{"$f":"Calculations!Y22","v":"x"},{"$f":"Calculations!Z22","v":"x"},{"$f":"Calculations!AA22","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ22,Calculations!AH22)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR22,Calculations!AI22)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS22,Calculations!AJ22)","v":"x"},null,"Sample Size",null,{"$f":"Calculations!E11","v":0},null,{"$f":"Calculations!F11","v":0},null,{"$f":"Calculations!G11","v":0}]
[null,17,{"$f":"Calculations!S23","v":"end"},{"$f":"Calculations!T23","v":"end"},{"$f":"Calculations!U23","v":"end"},{"$f":"Calculations!V23","v":"end"},{"$f":"Calculations!W23","v":"end"},{"$f":"Calculations!X23","v":"end"},{"$f":"Calculations!Y23","v":"x"},{"$f":"Calculations!Z23","v":"x"},{"$f":"Calculations!AA23","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ23,Calculations!AH23)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR23,Calculations!AI23)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS23,Calculations!AJ23)","v":"x"}]
[null,18,{"$f":"Calculations!S24","v":"end"},{"$f":"Calculations!T24","v":"end"},{"$f":"Calculations!U24","v":"end"},{"$f":"Calculations!V24","v":"end"},{"$f":"Calculations!W24","v":"end"},{"$f":"Calculations!X24","v":"end"},{"$f":"Calculations!Y24","v":"x"},{"$f":"Calculations!Z24","v":"x"},{"$f":"Calculations!AA24","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ24,Calculations!AH24)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR24,Calculations!AI24)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS24,Calculations!AJ24)","v":"x"}]
[null,19,{"$f":"Calculations!S25","v":"end"},{"$f":"Calculations!T25","v":"end"},{"$f":"Calculations!U25","v":"end"},{"$f":"Calculations!V25","v":"end"},{"$f":"Calculations!W25","v":"end"},{"$f":"Calculations!X25","v":"end"},{"$f":"Calculations!Y25","v":"x"},{"$f":"Calculations!Z25","v":"x"},{"$f":"Calculations!AA25","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ25,Calculations!AH25)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR25,Calculations!AI25)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS25,Calculations!AJ25)","v":"x"}]
[null,20,{"$f":"Calculations!S26","v":"end"},{"$f":"Calculations!T26","v":"end"},{"$f":"Calculations!U26","v":"end"},{"$f":"Calculations!V26","v":"end"},{"$f":"Calculations!W26","v":"end"},{"$f":"Calculations!X26","v":"end"},{"$f":"Calculations!Y26","v":"x"},{"$f":"Calculations!Z26","v":"x"},{"$f":"Calculations!AA26","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ26,Calculations!AH26)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR26,Calculations!AI26)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS26,Calculations!AJ26)","v":"x"}]
[null,21,{"$f":"Calculations!S27","v":"end"},{"$f":"Calculations!T27","v":"end"},{"$f":"Calculations!U27","v":"end"},{"$f":"Calculations!V27","v":"end"},{"$f":"Calculations!W27","v":"end"},{"$f":"Calculations!X27","v":"end"},{"$f":"Calculations!Y27","v":"x"},{"$f":"Calculations!Z27","v":"x"},{"$f":"Calculations!AA27","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ27,Calculations!AH27)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR27,Calculations!AI27)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS27,Calculations!AJ27)","v":"x"}]
[null,22,{"$f":"Calculations!S28","v":"end"},{"$f":"Calculations!T28","v":"end"},{"$f":"Calculations!U28","v":"end"},{"$f":"Calculations!V28","v":"end"},{"$f":"Calculations!W28","v":"end"},{"$f":"Calculations!X28","v":"end"},{"$f":"Calculations!Y28","v":"x"},{"$f":"Calculations!Z28","v":"x"},{"$f":"Calculations!AA28","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ28,Calculations!AH28)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR28,Calculations!AI28)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS28,Calculations!AJ28)","v":"x"}]
[null,23,{"$f":"Calculations!S29","v":"end"},{"$f":"Calculations!T29","v":"end"},{"$f":"Calculations!U29","v":"end"},{"$f":"Calculations!V29","v":"end"},{"$f":"Calculations!W29","v":"end"},{"$f":"Calculations!X29","v":"end"},{"$f":"Calculations!Y29","v":"x"},{"$f":"Calculations!Z29","v":"x"},{"$f":"Calculations!AA29","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ29,Calculations!AH29)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR29,Calculations!AI29)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS29,Calculations!AJ29)","v":"x"}]
[null,24,{"$f":"Calculations!S30","v":"end"},{"$f":"Calculations!T30","v":"end"},{"$f":"Calculations!U30","v":"end"},{"$f":"Calculations!V30","v":"end"},{"$f":"Calculations!W30","v":"end"},{"$f":"Calculations!X30","v":"end"},{"$f":"Calculations!Y30","v":"x"},{"$f":"Calculations!Z30","v":"x"},{"$f":"Calculations!AA30","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ30,Calculations!AH30)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR30,Calculations!AI30)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS30,Calculations!AJ30)","v":"x"}]
[null,25,{"$f":"Calculations!S31","v":"end"},{"$f":"Calculations!T31","v":"end"},{"$f":"Calculations!U31","v":"end"},{"$f":"Calculations!V31","v":"end"},{"$f":"Calculations!W31","v":"end"},{"$f":"Calculations!X31","v":"end"},{"$f":"Calculations!Y31","v":"x"},{"$f":"Calculations!Z31","v":"x"},{"$f":"Calculations!AA31","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ31,Calculations!AH31)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR31,Calculations!AI31)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS31,Calculations!AJ31)","v":"x"}]
[null,26,{"$f":"Calculations!S32","v":"end"},{"$f":"Calculations!T32","v":"end"},{"$f":"Calculations!U32","v":"end"},{"$f":"Calculations!V32","v":"end"},{"$f":"Calculations!W32","v":"end"},{"$f":"Calculations!X32","v":"end"},{"$f":"Calculations!Y32","v":"x"}," ",{"$f":"Calculations!AA32","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ32,Calculations!AH32)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR32,Calculations!AI32)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS32,Calculations!AJ32)","v":"x"}]
[null,27,{"$f":"Calculations!S33","v":"end"},{"$f":"Calculations!T33","v":"end"},{"$f":"Calculations!U33","v":"end"},{"$f":"Calculations!V33","v":"end"},{"$f":"Calculations!W33","v":"end"},{"$f":"Calculations!X33","v":"end"},{"$f":"Calculations!Y33","v":"x"},{"$f":"Calculations!Z33","v":"x"},{"$f":"Calculations!AA33","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ33,Calculations!AH33)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR33,Calculations!AI33)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS33,Calculations!AJ33)","v":"x"}]
[null,28,{"$f":"Calculations!S34","v":"end"},{"$f":"Calculations!T34","v":"end"},{"$f":"Calculations!U34","v":"end"},{"$f":"Calculations!V34","v":"end"},{"$f":"Calculations!W34","v":"end"},{"$f":"Calculations!X34","v":"end"},{"$f":"Calculations!Y34","v":"x"},{"$f":"Calculations!Z34","v":"x"},{"$f":"Calculations!AA34","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ34,Calculations!AH34)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR34,Calculations!AI34)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS34,Calculations!AJ34)","v":"x"}]
[null,29,{"$f":"Calculations!S35","v":"end"},{"$f":"Calculations!T35","v":"end"},{"$f":"Calculations!U35","v":"end"},{"$f":"Calculations!V35","v":"end"},{"$f":"Calculations!W35","v":"end"},{"$f":"Calculations!X35","v":"end"},{"$f":"Calculations!Y35","v":"x"},{"$f":"Calculations!Z35","v":"x"},{"$f":"Calculations!AA35","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ35,Calculations!AH35)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR35,Calculations!AI35)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS35,Calculations!AJ35)","v":"x"}]
[null,30,{"$f":"Calculations!S36","v":"end"},{"$f":"Calculations!T36","v":"end"},{"$f":"Calculations!U36","v":"end"},{"$f":"Calculations!V36","v":"end"},{"$f":"Calculations!W36","v":"end"},{"$f":"Calculations!X36","v":"end"},{"$f":"Calculations!Y36","v":"x"},{"$f":"Calculations!Z36","v":"x"},{"$f":"Calculations!AA36","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ36,Calculations!AH36)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR36,Calculations!AI36)","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS36,Calculations!AJ36)","v":"x"}]
[null,31,{"$f":"Calculations!S37","v":"end"},{"$f":"Calculations!T37","v":"end"},{"$f":"Calculations!U37","v":"end"},{"$f":"Calculations!V37","v":"end"},{"$f":"Calculations!W37","v":"end"},{"$f":"Calculations!X37","v":"end"},{"$f":"Calculations!Y37","v":"x"},{"$f":"Calculations!Z37","v":"x"},{"$f":"Calculations!AA37","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ37,Calculations!AH37)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR37,Calculations!AI37)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS37,Calculations!AJ37)","v":0}]
[null,32,{"$f":"Calculations!S38","v":"end"},{"$f":"Calculations!T38","v":"end"},{"$f":"Calculations!U38","v":"end"},{"$f":"Calculations!V38","v":"end"},{"$f":"Calculations!W38","v":"end"},{"$f":"Calculations!X38","v":"end"},{"$f":"Calculations!Y38","v":"x"},{"$f":"Calculations!Z38","v":"x"},{"$f":"Calculations!AA38","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ38,Calculations!AH38)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR38,Calculations!AI38)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS38,Calculations!AJ38)","v":0}]
[null,33,{"$f":"Calculations!S39","v":"end"},{"$f":"Calculations!T39","v":"end"},{"$f":"Calculations!U39","v":"end"},{"$f":"Calculations!V39","v":"end"},{"$f":"Calculations!W39","v":"end"},{"$f":"Calculations!X39","v":"end"},{"$f":"Calculations!Y39","v":"x"},{"$f":"Calculations!Z39","v":"x"},{"$f":"Calculations!AA39","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ39,Calculations!AH39)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR39,Calculations!AI39)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS39,Calculations!AJ39)","v":0}]
[null,34,{"$f":"Calculations!S40","v":"end"},{"$f":"Calculations!T40","v":"end"},{"$f":"Calculations!U40","v":"end"},{"$f":"Calculations!V40","v":"end"},{"$f":"Calculations!W40","v":"end"},{"$f":"Calculations!X40","v":"end"},{"$f":"Calculations!Y40","v":"x"},{"$f":"Calculations!Z40","v":"x"},{"$f":"Calculations!AA40","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ40,Calculations!AH40)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR40,Calculations!AI40)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS40,Calculations!AJ40)","v":0}]
[null,35,{"$f":"Calculations!S41","v":"end"},{"$f":"Calculations!T41","v":"end"},{"$f":"Calculations!U41","v":"end"},{"$f":"Calculations!V41","v":"end"},{"$f":"Calculations!W41","v":"end"},{"$f":"Calculations!X41","v":"end"},{"$f":"Calculations!Y41","v":"x"},{"$f":"Calculations!Z41","v":"x"},{"$f":"Calculations!AA41","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ41,Calculations!AH41)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR41,Calculations!AI41)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS41,Calculations!AJ41)","v":0}]
[null,36,{"$f":"Calculations!S42","v":"end"},{"$f":"Calculations!T42","v":"end"},{"$f":"Calculations!U42","v":"end"},{"$f":"Calculations!V42","v":"end"},{"$f":"Calculations!W42","v":"end"},{"$f":"Calculations!X42","v":"end"},{"$f":"Calculations!Y42","v":"x"},{"$f":"Calculations!Z42","v":"x"},{"$f":"Calculations!AA42","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ42,Calculations!AH42)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR42,Calculations!AI42)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS42,Calculations!AJ42)","v":0}]
[null,37,{"$f":"Calculations!S43","v":"end"},{"$f":"Calculations!T43","v":"end"},{"$f":"Calculations!U43","v":"end"},{"$f":"Calculations!V43","v":"end"},{"$f":"Calculations!W43","v":"end"},{"$f":"Calculations!X43","v":"end"},{"$f":"Calculations!Y43","v":"x"},{"$f":"Calculations!Z43","v":"x"},{"$f":"Calculations!AA43","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ43,Calculations!AH43)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR43,Calculations!AI43)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS43,Calculations!AJ43)","v":0}]
[null,38,{"$f":"Calculations!S44","v":"end"},{"$f":"Calculations!T44","v":"end"},{"$f":"Calculations!U44","v":"end"},{"$f":"Calculations!V44","v":"end"},{"$f":"Calculations!W44","v":"end"},{"$f":"Calculations!X44","v":"end"},{"$f":"Calculations!Y44","v":"x"},{"$f":"Calculations!Z44","v":"x"},{"$f":"Calculations!AA44","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ44,Calculations!AH44)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR44,Calculations!AI44)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS44,Calculations!AJ44)","v":0}]
[null,39,{"$f":"Calculations!S45","v":"end"},{"$f":"Calculations!T45","v":"end"},{"$f":"Calculations!U45","v":"end"},{"$f":"Calculations!V45","v":"end"},{"$f":"Calculations!W45","v":"end"},{"$f":"Calculations!X45","v":"end"},{"$f":"Calculations!Y45","v":"x"},{"$f":"Calculations!Z45","v":"x"},{"$f":"Calculations!AA45","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ45,Calculations!AH45)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR45,Calculations!AI45)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS45,Calculations!AJ45)","v":0}]
[null,40,{"$f":"Calculations!S46","v":"end"},{"$f":"Calculations!T46","v":"end"},{"$f":"Calculations!U46","v":"end"},{"$f":"Calculations!V46","v":"end"},{"$f":"Calculations!W46","v":"end"},{"$f":"Calculations!X46","v":"end"},{"$f":"Calculations!Y46","v":"x"},{"$f":"Calculations!Z46","v":"x"},{"$f":"Calculations!AA46","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ46,Calculations!AH46)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR46,Calculations!AI46)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS46,Calculations!AJ46)","v":0}]
[null,41,{"$f":"Calculations!S47","v":"end"},{"$f":"Calculations!T47","v":"end"},{"$f":"Calculations!U47","v":"end"},{"$f":"Calculations!V47","v":"end"},{"$f":"Calculations!W47","v":"end"},{"$f":"Calculations!X47","v":"end"},{"$f":"Calculations!Y47","v":"x"},{"$f":"Calculations!Z47","v":"x"},{"$f":"Calculations!AA47","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ47,Calculations!AH47)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR47,Calculations!AI47)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS47,Calculations!AJ47)","v":0}]
[null,42,{"$f":"Calculations!S48","v":"end"},{"$f":"Calculations!T48","v":"end"},{"$f":"Calculations!U48","v":"end"},{"$f":"Calculations!V48","v":"end"},{"$f":"Calculations!W48","v":"end"},{"$f":"Calculations!X48","v":"end"},{"$f":"Calculations!Y48","v":"x"},{"$f":"Calculations!Z48","v":"x"},{"$f":"Calculations!AA48","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ48,Calculations!AH48)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR48,Calculations!AI48)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS48,Calculations!AJ48)","v":0}]
[null,43,{"$f":"Calculations!S49","v":"end"},{"$f":"Calculations!T49","v":"end"},{"$f":"Calculations!U49","v":"end"},{"$f":"Calculations!V49","v":"end"},{"$f":"Calculations!W49","v":"end"},{"$f":"Calculations!X49","v":"end"},{"$f":"Calculations!Y49","v":"x"},{"$f":"Calculations!Z49","v":"x"},{"$f":"Calculations!AA49","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ49,Calculations!AH49)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR49,Calculations!AI49)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS49,Calculations!AJ49)","v":0}]
[null,44,{"$f":"Calculations!S50","v":"end"},{"$f":"Calculations!T50","v":"end"},{"$f":"Calculations!U50","v":"end"},{"$f":"Calculations!V50","v":"end"},{"$f":"Calculations!W50","v":"end"},{"$f":"Calculations!X50","v":"end"},{"$f":"Calculations!Y50","v":"x"},{"$f":"Calculations!Z50","v":"x"},{"$f":"Calculations!AA50","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ50,Calculations!AH50)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR50,Calculations!AI50)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS50,Calculations!AJ50)","v":0}]
[null,45,{"$f":"Calculations!S51","v":"end"},{"$f":"Calculations!T51","v":"end"},{"$f":"Calculations!U51","v":"end"},{"$f":"Calculations!V51","v":"end"},{"$f":"Calculations!W51","v":"end"},{"$f":"Calculations!X51","v":"end"},{"$f":"Calculations!Y51","v":"x"},{"$f":"Calculations!Z51","v":"x"},{"$f":"Calculations!AA51","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ51,Calculations!AH51)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR51,Calculations!AI51)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS51,Calculations!AJ51)","v":0}]
[null,46,{"$f":"Calculations!S52","v":"end"},{"$f":"Calculations!T52","v":"end"},{"$f":"Calculations!U52","v":"end"},{"$f":"Calculations!V52","v":"end"},{"$f":"Calculations!W52","v":"end"},{"$f":"Calculations!X52","v":"end"},{"$f":"Calculations!Y52","v":"x"},{"$f":"Calculations!Z52","v":"x"},{"$f":"Calculations!AA52","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ52,Calculations!AH52)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR52,Calculations!AI52)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS52,Calculations!AJ52)","v":0}]
[null,47,{"$f":"Calculations!S53","v":"end"},{"$f":"Calculations!T53","v":"end"},{"$f":"Calculations!U53","v":"end"},{"$f":"Calculations!V53","v":"end"},{"$f":"Calculations!W53","v":"end"},{"$f":"Calculations!X53","v":"end"},{"$f":"Calculations!Y53","v":"x"},{"$f":"Calculations!Z53","v":"x"},{"$f":"Calculations!AA53","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ53,Calculations!AH53)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR53,Calculations!AI53)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS53,Calculations!AJ53)","v":0}]
[null,48,{"$f":"Calculations!S54","v":"end"},{"$f":"Calculations!T54","v":"end"},{"$f":"Calculations!U54","v":"end"},{"$f":"Calculations!V54","v":"end"},{"$f":"Calculations!W54","v":"end"},{"$f":"Calculations!X54","v":"end"},{"$f":"Calculations!Y54","v":"x"},{"$f":"Calculations!Z54","v":"x"},{"$f":"Calculations!AA54","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ54,Calculations!AH54)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR54,Calculations!AI54)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS54,Calculations!AJ54)","v":0}]
[null,49,{"$f":"Calculations!S55","v":"end"},{"$f":"Calculations!T55","v":"end"},{"$f":"Calculations!U55","v":"end"},{"$f":"Calculations!V55","v":"end"},{"$f":"Calculations!W55","v":"end"},{"$f":"Calculations!X55","v":"end"},{"$f":"Calculations!Y55","v":"x"},{"$f":"Calculations!Z55","v":"x"},{"$f":"Calculations!AA55","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ55,Calculations!AH55)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR55,Calculations!AI55)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS55,Calculations!AJ55)","v":0}]
[null,50,{"$f":"Calculations!S56","v":"end"},{"$f":"Calculations!T56","v":"end"},{"$f":"Calculations!U56","v":"end"},{"$f":"Calculations!V56","v":"end"},{"$f":"Calculations!W56","v":"end"},{"$f":"Calculations!X56","v":"end"},{"$f":"Calculations!Y56","v":"x"},{"$f":"Calculations!Z56","v":"x"},{"$f":"Calculations!AA56","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AQ56,Calculations!AH56)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AR56,Calculations!AI56)","v":0},{"$f":"IF('Time 1'!$AA$5=1,Calculations!AS56,Calculations!AJ56)","v":0}]

{"sheet":"Calculations","index":4,"n_rows":70,"n_cols":72,"rows_kept":70,"cut":false,"hidden":false,"merged":[[34,9,34,13],[4,9,4,10],[5,9,5,10],[33,9,33,13],[32,8,32,13],[28,0,28,11],[29,0,29,11],[30,0,30,11],[25,2,25,3],[6,2,6,3],[4,0,25,1],[11,2,11,6],[9,2,9,3],[32,0,38,1],[34,2,34,3],[33,8,34,8],[61,42,61,44],[56,15,57,16],[58,15,59,16],[59,24,59,26],[57,24,57,26],[61,33,61,35],[35,8,36,8],[37,8,38,8],[65,24,65,26],[66,24,66,26],[67,24,67,26],[62,24,62,26],[63,24,63,26],[64,24,64,26],[37,9,37,13],[35,9,35,13],[36,9,36,13],[38,9,38,13],[0,51,0,60],[3,52,6,52],[3,53,3,56],[4,53,4,56],[6,53,6,56],[3,58,6,58],[4,59,4,63],[6,59,6,63],[3,59,3,63],[32,2,32,3],[33,2,33,3],[1,0,1,13],[17,51,21,51],[23,2,23,3],[19,2,19,3],[5,2,5,3],[15,51,15,57],[17,8,17,12],[4,2,4,3],[13,2,13,3],[4,24,4,26],[2,17,2,49],[4,27,4,29],[4,30,4,32],[4,36,4,38],[1,71,1,74],[21,2,21,3],[12,2,12,3],[10,2,10,3],[16,2,16,3],[2,0,2,10],[14,2,14,3],[7,58,8,58],[4,33,4,35],[4,18,4,20],[4,21,4,23],[3,17,3,48],[4,42,4,44],[4,39,4,41],[4,45,4,47]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IMPORTANT - Don't delete this sheet or use it - the calculation tab uses it to calculate the sums.  You do not need to report these - all shown on Results tab."]
["Your Results explained  For help/explanations hover the cursor over the boxes with red triangles.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://faculty.vassar.edu/lowry/",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End of sheet"]
["Your results are more reliable with 10 cases or more, but tables have been corrected for less than 10 cases in this workbook.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATIONS PAGE  - PLEASE DON'T ALTER THIS PAGE ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"From Richard Lowry (2006) Subchapter 12a  The Wilcoxon signed rank test"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The white columns appear in the results section",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILCOXON - SMALL SAMPLES  ONLY","Level of Significance for a ",null,null,null,null,"Z critical values","Level of Significance for a ",null,null,null,null,null,"1.96 is 5% (p=0.05), the test IS statistically significant"," -1.96 is 5% (p=0.05), the test IS statistically significant",{"$f":"IF(E36=\"no\",BO9,IF(E35>0,BN8,BN9))","v":"The chance that the z ratio would be bigger than"},{"$f":"IF(F36=\"no\",BO9,IF(F35>0,BN8,BN9))","v":"The chance that the z ratio would be bigger than"},{"$f":"IF(G36=\"no\",BO9,IF(G35>0,BN8,BN9))","v":"The chance that the z ratio would be bigger than"}]
["The Wilcoxon Signed Rank Test for paired observations ",null,null,null,"FOR PLACES","FOR PEOPLE","CLOCK SPREAD",null,null,"Sue Hacking University Central Lancs. ©",null,null,null,null,null,null,null,null,"TIME 1 TOTALS",null,null,"TIME 2 TOTALS",null,null,"DIFFERENCES",null,null,"ABSOLUTE DIFFERENCES",null,null,"RANKS",null,null,"Up to 30 cases SIGNED RANKS",null,null,"NEEDED FOR CALCULATION",null,null,"Ranks large sample",null,null,"Signed ranks large sample",null,null,"Calculation",null,null,null,null,null,null,null,"Directional Test 1-TAILED",null,null,null,null,null,"Directional Test 1-TAILED",null,null,null,null,null,"2.326 is 2% (p=0.02), the test IS statistically significant"," -2.326 is 2% (p=0.02), the test IS statistically significant",{"$f":"IF(E39=\"yes\",BN7,IF(E38=\"yes\",BN6,IF(E37=\"yes\",BN5,BN4)))","v":"1.96 is 5% (p=0.05), the test IS statistically significant"},{"$f":"IF(F39=\"yes\",BN7,IF(F38=\"yes\",BN6,IF(F37=\"yes\",BN5,BN4)))","v":"1.96 is 5% (p=0.05), the test IS statistically significant"},{"$f":"IF(G39=\"yes\",BN7,IF(G38=\"yes\",BN6,IF(G37=\"yes\",BN5,BN4)))","v":"1.96 is 5% (p=0.05), the test IS statistically significant"}]
[null,null,"Cases with differences",null,{"$f":"IF('Time 1'!$AA$5=1, AQ66,AH66)","v":0},{"$f":"IF('Time 1'!$AA$5=1, AR66,AI66)","v":0},{"$f":"IF('Time 1'!$AA$5=1, AS66,AJ66)","v":0},null,null,{"$f":"IF('Time 1'!AA5=1, \"Calculations for more than 30 cases\", \"Calculations for 30 cases or less\")","v":"Calculations for 30 cases or less"},null,null,null,null,null,null,null,"Pairs","Places","People","Clock spread","Places","People","Clock spread","Places","People","Clock spread","Places","People","Clock spread","Places","People","Clock spread","Places","People","Clock spread","Places","People","Clockspread","Places","People","Clock spread","Places","People","Clock spread","Places","People","Clock spread",null,null,null,null,null,0.05,2.5000000000000001E-2,0.01,5.0000000000000001E-3,null,null,0.05,2.5000000000000001E-2,0.01,5.0000000000000001E-3,5.0000000000000001E-4,null,"2.576 is 1% (p=0.01), the test IS statistically significant"," -2.576 is 1% (p=0.01), the test IS statistically significant",{"$f":"IF(E39=\"yes\",BO7,IF(E38=\"yes\",BO6,IF(E37=\"yes\",BO5,BO4)))","v":" -1.96 is 5% (p=0.05), the test IS statistically significant"},{"$f":"IF(F39=\"yes\",BO7,IF(F38=\"yes\",BO6,IF(F37=\"yes\",BO5,BO4)))","v":" -1.96 is 5% (p=0.05), the test IS statistically significant"},{"$f":"IF(G39=\"yes\",BO7,IF(G38=\"yes\",BO6,IF(G37=\"yes\",BO5,BO4)))","v":" -1.96 is 5% (p=0.05), the test IS statistically significant"}]
[null,null,"No differences",null,{"$f":"IF('Time 1'!$AA$5=1, AQ69,AH69)","v":0},{"$f":"IF('Time 1'!$AA$5=1, AR69,AI69)","v":0},{"$f":"IF('Time 1'!$AA$5=1, AS69,AJ69)","v":0},null,null,null,null,null,null,null,null,null,null,1,{"$f":"'Time 1'!U6","v":"end"},{"$f":"'Time 1'!V6","v":"end"},{"$f":"'Time 1'!W6","v":"end"},{"$f":"'Time 2'!U6","v":"end"},{"$f":"'Time 2'!V6","v":"end"},{"$f":"'Time 2'!W6","v":"end"},{"$f":"IF(S7=\"END\",\"x\",IF(V7-S7=0,\"x\",V7-S7))","v":"x"},{"$f":"IF(T7=\"END\",\"x\",IF(W7-T7=0,\"x\",W7-T7))","v":"x"},{"$f":"IF(U7=\"END\",\"x\",IF(X7-U7=0,\"x\",X7-U7))","v":"x"},{"$f":"IF(Y7=\"x\",Y7,IF(S7>V7,S7-V7,V7-S7))","v":"x"},{"$f":"IF(Z7=\"x\",Z7,IF(T7>W7,T7-W7,W7-T7))","v":"x"},{"$f":"IF(AA7=\"x\",AA7,IF(U7>X7,U7-X7,X7-U7))","v":"x"},{"$f":"IF(AB7=\"x\",AB7,IF(COUNTIF($AB$7:$AB$36,AB7)>1,((RANK(AB7,$AB$7:$AB$36,1))+(COUNT($AB$7:$AB$36)+1-RANK($AB7,$AB$7:$AB$36,0)-RANK($AB7,$AB$7:$AB$36,1))/2), RANK(AB7,$AB$7:$AB$36,1)))","v":"x"},{"$f":"IF(AC7=\"x\",AC7,IF(COUNTIF($AC$7:$AC$36,AC7)>1,((RANK(AC7,$AC$7:$AC$36,1))+(COUNT($AC$7:$AC$36)+1-RANK($AC7,$AC$7:$AC$36,0)-RANK($AC7,$AC$7:$AC$36,1))/2), RANK(AC7,$AC$7:$AC$36,1)))","v":"x"},{"$f":"IF(AD7=\"x\",AD7,IF(COUNTIF($AD$7:$AD$36,AD7)>1,((RANK(AD7,$AD$7:$AD$36,1))+(COUNT($AD$7:$AD$36)+1-RANK($AD7,$AD$7:$AD$36,0)-RANK($AD7,$AD$7:$AD$36,1))/2), RANK(AD7,$AD$7:$AD$36,1)))","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y7<0, AE7-(2*AE7),AE7))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z7<0, AF7-(2*AF7),AF7))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA7<0, AG7-(2*AG7),AG7))","v":"x"},{"$f":"IF(S7=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE7=\"x\",AE7,IF(AH7>0,1,2))))","v":""},{"$f":"IF(T7=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF7=\"x\",AF7,IF(AI7>0,1,2))))","v":""},{"$f":"IF(U7=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG7=\"x\",AG7,IF(AJ7>0,1,2))))","v":""},{"$f":"IF(AB7=\"x\",AB7,IF(COUNTIF($AB$7:$AB$56,AB7)>1,((RANK(AB7,$AB$7:$AB56,1))+(COUNT($AB$7:$AB56)+1-RANK($AB7,$AB$7:$AB$56,0)-RANK($AB7,$AB$7:$AB$56,1))/2),RANK(AB7,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC7=\"x\",AC7,IF(COUNTIF($AC$7:$AC$56,AC7)>1,((RANK(AC7,$AC$7:$AC56,1))+(COUNT($AC$7:$AC56)+1-RANK($AC7,$AC$7:$AC$56,0)-RANK($AC7,$AC$7:$AC$56,1))/2),RANK(AC7,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD7=\"x\",AD7,IF(COUNTIF($AD$7:$AD$56,AD7)>1,((RANK(AD7,$AD$7:$AD56,1))+(COUNT($AD$7:$AD56)+1-RANK($AD7,$AD$7:$AD$56,0)-RANK($AD7,$AD$7:$AD$56,1))/2),RANK(AD7,$AD$7:$AD$56,1)))","v":"x"},{"$f":"IF(Y7<0,AN7-(2*AN7),AN7)","v":"x"},{"$f":"IF(Z7<0,AO7-(2*AO7),AO7)","v":"x"},{"$f":"IF(AA7<0,AP7-(2*AP7),AP7)","v":"x"},{"$f":"IF(S7=\"end\",\"\",IF(AN7=\"x\",AN7,IF(AQ7>0,1,2)))","v":""},{"$f":"IF(T7=\"end\",\"\",IF(AO7=\"x\",AO7,IF(AR7>0,1,2)))","v":""},{"$f":"IF(U7=\"end\",\"\",IF(AP7=\"x\",AP7,IF(AS7>0,1,2)))","v":""},null,null,null,null,null,"Non-Directional Test 2-TAILED",null,null,null,null,null,"Non-Directional Test 2-TAILED",null,null,null,null,null,"3.291 is 0.1% (p=0.001), the test IS statistically significant"," -3.291 is 0.1% (p=0.001), the test IS statistically significant",null,null,"Not enough cases"]
[null,null,"POSITIVE PAIRS W+",null,{"$f":"IF('Time 1'!$AA$5=1, AQ64,AH64)","v":0},{"$f":"IF('Time 1'!$AA$5=1, AR64,AI64)","v":0},{"$f":"IF('Time 1'!$AA$5=1, AS64,AJ64)","v":0},null,null,null,null,null,null,null,null,null,null,2,{"$f":"'Time 1'!U7","v":"end"},{"$f":"'Time 1'!V7","v":"end"},{"$f":"'Time 1'!W7","v":"end"},{"$f":"'Time 2'!U7","v":"end"},{"$f":"'Time 2'!V7","v":"end"},{"$f":"'Time 2'!W7","v":"end"},{"$f":"IF(S8=\"END\",\"x\",IF(V8-S8=0,\"x\",V8-S8))","v":"x"},{"$f":"IF(T8=\"END\",\"x\",IF(W8-T8=0,\"x\",W8-T8))","v":"x"},{"$f":"IF(U8=\"END\",\"x\",IF(X8-U8=0,\"x\",X8-U8))","v":"x"},{"$f":"IF(Y8=\"x\",Y8,IF(S8>V8,S8-V8,V8-S8))","v":"x"},{"$f":"IF(Z8=\"x\",Z8,IF(T8>W8,T8-W8,W8-T8))","v":"x"},{"$f":"IF(AA8=\"x\",AA8,IF(U8>X8,U8-X8,X8-U8))","v":"x"},"x",{"$f":"IF(AC8=\"x\",AC8,IF(COUNTIF($AC$7:$AC$36,AC8)>1,((RANK(AC8,$AC$7:$AC$36,1))+(COUNT($AC$7:$AC$36)+1-RANK($AC8,$AC$7:$AC$36,0)-RANK($AC8,$AC$7:$AC$36,1))/2), RANK(AC8,$AC$7:$AC$36,1)))","v":"x"},{"$f":"IF(AD8=\"x\",AD8,IF(COUNTIF($AD$7:$AD$36,AD8)>1,((RANK(AD8,$AD$7:$AD$36,1))+(COUNT($AD$7:$AD$36)+1-RANK($AD8,$AD$7:$AD$36,0)-RANK($AD8,$AD$7:$AD$36,1))/2), RANK(AD8,$AD$7:$AD$36,1)))","v":"x"},{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y8<0, AE8-(2*AE8),AE8))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z8<0, AF8-(2*AF8),AF8))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA8<0, AG8-(2*AG8),AG8))","v":"x"},{"$f":"IF(S8=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE8=\"x\",AE8,IF(AH8>0,1,2))))","v":""},{"$f":"IF(T8=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF8=\"x\",AF8,IF(AI8>0,1,2))))","v":""},{"$f":"IF(U8=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG8=\"x\",AG8,IF(AJ8>0,1,2))))","v":""},{"$f":"IF(AB8=\"x\",AB8,IF(COUNTIF($AB$7:$AB$56,AB8)>1,((RANK(AB8,$AB$7:$AB57,1))+(COUNT($AB$7:$AB57)+1-RANK($AB8,$AB$7:$AB$56,0)-RANK($AB8,$AB$7:$AB$56,1))/2),RANK(AB8,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC8=\"x\",AC8,IF(COUNTIF($AC$7:$AC$56,AC8)>1,((RANK(AC8,$AC$7:$AC57,1))+(COUNT($AC$7:$AC57)+1-RANK($AC8,$AC$7:$AC$56,0)-RANK($AC8,$AC$7:$AC$56,1))/2),RANK(AC8,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD8=\"x\",AD8,IF(COUNTIF($AD$7:$AD$56,AD8)>1,((RANK(AD8,$AD$7:$AD57,1))+(COUNT($AD$7:$AD57)+1-RANK($AD8,$AD$7:$AD$56,0)-RANK($AD8,$AD$7:$AD$56,1))/2),RANK(AD8,$AD$7:$AD$56,1)))","v":"x"},{"$f":"IF(Y8<0,AN8-(2*AN8),AN8)","v":"x"},{"$f":"IF(Z8<0,AO8-(2*AO8),AO8)","v":"x"},{"$f":"IF(AA8<0,AP8-(2*AP8),AP8)","v":"x"},{"$f":"IF(S8=\"end\",\"\",IF(AN8=\"x\",AN8,IF(AQ8>0,1,2)))","v":""},{"$f":"IF(T8=\"end\",\"\",IF(AO8=\"x\",AO8,IF(AR8>0,1,2)))","v":""},{"$f":"IF(U8=\"end\",\"\",IF(AP8=\"x\",AP8,IF(AS8>0,1,2)))","v":""},null,null,null,null,"ns/r ","x",0.05,0.02,0.01,null,"ns/r ","x",0.05,0.02,0.01,1E-3,null,"The chance that the z ratio would be bigger than","The test IS NOT statistically significant at the p=0.05 level"]
[null,null,"NEGATIVE PAIRS W-",null,{"$f":"IF('Time 1'!$AA$5=1, (AQ65-(2*AQ65)),(AH65-(2*AH65)))","v":0},{"$f":"IF('Time 1'!$AA$5=1, (AR65-(2*AR65)),(AI65-(2*AI65)))","v":0},{"$f":"IF('Time 1'!$AA$5=1, (AS65-(2*AS65)),(AJ65-(2*AJ65)))","v":0},null,null,null,null,null,null,null,null,null,null,3,{"$f":"'Time 1'!U8","v":"end"},{"$f":"'Time 1'!V8","v":"end"},{"$f":"'Time 1'!W8","v":"end"},{"$f":"'Time 2'!U8","v":"end"},{"$f":"'Time 2'!V8","v":"end"},{"$f":"'Time 2'!W8","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y9<0, AE9-(2*AE9),AE9))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z9<0, AF9-(2*AF9),AF9))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA9<0, AG9-(2*AG9),AG9))","v":"x"},{"$f":"IF(S9=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE9=\"x\",AE9,IF(AH9>0,1,2))))","v":""},{"$f":"IF(T9=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF9=\"x\",AF9,IF(AI9>0,1,2))))","v":""},{"$f":"IF(U9=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG9=\"x\",AG9,IF(AJ9>0,1,2))))","v":""},{"$f":"IF(AB9=\"x\",AB9,IF(COUNTIF($AB$7:$AB$56,AB9)>1,((RANK(AB9,$AB$7:$AB58,1))+(COUNT($AB$7:$AB58)+1-RANK($AB9,$AB$7:$AB$56,0)-RANK($AB9,$AB$7:$AB$56,1))/2),RANK(AB9,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC9=\"x\",AC9,IF(COUNTIF($AC$7:$AC$56,AC9)>1,((RANK(AC9,$AC$7:$AC58,1))+(COUNT($AC$7:$AC58)+1-RANK($AC9,$AC$7:$AC$56,0)-RANK($AC9,$AC$7:$AC$56,1))/2),RANK(AC9,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD9=\"x\",AD9,IF(COUNTIF($AD$7:$AD$56,AD9)>1,((RANK(AD9,$AD$7:$AD58,1))+(COUNT($AD$7:$AD58)+1-RANK($AD9,$AD$7:$AD$56,0)-RANK($AD9,$AD$7:$AD$56,1))/2),RANK(AD9,$AD$7:$AD$56,1)))","v":"x"},{"$f":"IF(Y9<0,AN9-(2*AN9),AN9)","v":"x"},"x","x","","","",null,null,null,null,5,15,"x","x","x",null,null,1.645,1.96,2.3260000000000001,2.5760000000000001,3.2909999999999999,null,"The chance that the z ratio would be smaller than","The value of z is within the normal range"]
[null,null,"No. of cases input into time1/2",null,{"$f":"E7+E6","v":0},{"$f":"F7+F8+F9","v":0},{"$f":"G7+G8+G9","v":0},null,null,null,null,null,null,null,null,null,null,4,{"$f":"'Time 1'!U9","v":"end"},{"$f":"'Time 1'!V9","v":"end"},{"$f":"'Time 1'!W9","v":"end"},{"$f":"'Time 2'!U9","v":"end"},{"$f":"'Time 2'!V9","v":"end"},{"$f":"'Time 2'!W9","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y10<0, AE10-(2*AE10),AE10))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z10<0, AF10-(2*AF10),AF10))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA10<0, AG10-(2*AG10),AG10))","v":"x"},{"$f":"IF(S10=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE10=\"x\",AE10,IF(AH10>0,1,2))))","v":""},{"$f":"IF(T10=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF10=\"x\",AF10,IF(AI10>0,1,2))))","v":""},{"$f":"IF(U10=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG10=\"x\",AG10,IF(AJ10>0,1,2))))","v":""},{"$f":"IF(AB10=\"x\",AB10,IF(COUNTIF($AB$7:$AB$56,AB10)>1,((RANK(AB10,$AB$7:$AB59,1))+(COUNT($AB$7:$AB59)+1-RANK($AB10,$AB$7:$AB$56,0)-RANK($AB10,$AB$7:$AB$56,1))/2),RANK(AB10,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC10=\"x\",AC10,IF(COUNTIF($AC$7:$AC$56,AC10)>1,((RANK(AC10,$AC$7:$AC59,1))+(COUNT($AC$7:$AC59)+1-RANK($AC10,$AC$7:$AC$56,0)-RANK($AC10,$AC$7:$AC$56,1))/2),RANK(AC10,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD10=\"x\",AD10,IF(COUNTIF($AD$7:$AD$56,AD10)>1,((RANK(AD10,$AD$7:$AD59,1))+(COUNT($AD$7:$AD59)+1-RANK($AD10,$AD$7:$AD$56,0)-RANK($AD10,$AD$7:$AD$56,1))/2),RANK(AD10,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,6,17,21,"x","x"]
[null,null,"YOUR SAMPLE SIZE  (N) IS ",null,{"$f":"E6","v":0},{"$f":"F6","v":0},{"$f":"G6","v":0},null,null,null,null,null,null,null,null,null,null,5,{"$f":"'Time 1'!U10","v":"end"},{"$f":"'Time 1'!V10","v":"end"},{"$f":"'Time 1'!W10","v":"end"},{"$f":"'Time 2'!U10","v":"end"},{"$f":"'Time 2'!V10","v":"end"},{"$f":"'Time 2'!W10","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y11<0, AE11-(2*AE11),AE11))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z11<0, AF11-(2*AF11),AF11))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA11<0, AG11-(2*AG11),AG11))","v":"x"},{"$f":"IF(S11=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE11=\"x\",AE11,IF(AH11>0,1,2))))","v":""},{"$f":"IF(T11=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF11=\"x\",AF11,IF(AI11>0,1,2))))","v":""},{"$f":"IF(U11=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG11=\"x\",AG11,IF(AJ11>0,1,2))))","v":""},{"$f":"IF(AB11=\"x\",AB11,IF(COUNTIF($AB$7:$AB$56,AB11)>1,((RANK(AB11,$AB$7:$AB60,1))+(COUNT($AB$7:$AB60)+1-RANK($AB11,$AB$7:$AB$56,0)-RANK($AB11,$AB$7:$AB$56,1))/2),RANK(AB11,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC11=\"x\",AC11,IF(COUNTIF($AC$7:$AC$56,AC11)>1,((RANK(AC11,$AC$7:$AC60,1))+(COUNT($AC$7:$AC60)+1-RANK($AC11,$AC$7:$AC$56,0)-RANK($AC11,$AC$7:$AC$56,1))/2),RANK(AC11,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD11=\"x\",AD11,IF(COUNTIF($AD$7:$AD$56,AD11)>1,((RANK(AD11,$AD$7:$AD60,1))+(COUNT($AD$7:$AD60)+1-RANK($AD11,$AD$7:$AD$56,0)-RANK($AD11,$AD$7:$AD$56,1))/2),RANK(AD11,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,7,22,24,28,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"'Time 1'!U11","v":"end"},{"$f":"'Time 1'!V11","v":"end"},{"$f":"'Time 1'!W11","v":"end"},{"$f":"'Time 2'!U11","v":"end"},{"$f":"'Time 2'!V11","v":"end"},{"$f":"'Time 2'!W11","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y12<0, AE12-(2*AE12),AE12))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z12<0, AF12-(2*AF12),AF12))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA12<0, AG12-(2*AG12),AG12))","v":"x"},{"$f":"IF(S12=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE12=\"x\",AE12,IF(AH12>0,1,2))))","v":""},{"$f":"IF(T12=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF12=\"x\",AF12,IF(AI12>0,1,2))))","v":""},{"$f":"IF(U12=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG12=\"x\",AG12,IF(AJ12>0,1,2))))","v":""},{"$f":"IF(AB12=\"x\",AB12,IF(COUNTIF($AB$7:$AB$56,AB12)>1,((RANK(AB12,$AB$7:$AB61,1))+(COUNT($AB$7:$AB61)+1-RANK($AB12,$AB$7:$AB$56,0)-RANK($AB12,$AB$7:$AB$56,1))/2),RANK(AB12,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC12=\"x\",AC12,IF(COUNTIF($AC$7:$AC$56,AC12)>1,((RANK(AC12,$AC$7:$AC61,1))+(COUNT($AC$7:$AC61)+1-RANK($AC12,$AC$7:$AC$56,0)-RANK($AC12,$AC$7:$AC$56,1))/2),RANK(AC12,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD12=\"x\",AD12,IF(COUNTIF($AD$7:$AD$56,AD12)>1,((RANK(AD12,$AD$7:$AD61,1))+(COUNT($AD$7:$AD61)+1-RANK($AD12,$AD$7:$AD$56,0)-RANK($AD12,$AD$7:$AD$56,1))/2),RANK(AD12,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,8,26,30,34,36]
[null,null,"TEST VALUES T",null,{"$f":"IF(E8>E9,E9,E8)","v":0},{"$f":"IF(F8>F9,F9,F8)","v":0},{"$f":"IF(G8>G9,G9,G8)","v":0},null,null,null,null,null,null,null,null,null,null,7,{"$f":"'Time 1'!U12","v":"end"},{"$f":"'Time 1'!V12","v":"end"},{"$f":"'Time 1'!W12","v":"end"},{"$f":"'Time 2'!U12","v":"end"},{"$f":"'Time 2'!V12","v":"end"},{"$f":"'Time 2'!W12","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y13<0, AE13-(2*AE13),AE13))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z13<0, AF13-(2*AF13),AF13))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA13<0, AG13-(2*AG13),AG13))","v":"x"},{"$f":"IF(S13=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE13=\"x\",AE13,IF(AH13>0,1,2))))","v":""},{"$f":"IF(T13=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF13=\"x\",AF13,IF(AI13>0,1,2))))","v":""},{"$f":"IF(U13=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG13=\"x\",AG13,IF(AJ13>0,1,2))))","v":""},{"$f":"IF(AB13=\"x\",AB13,IF(COUNTIF($AB$7:$AB$56,AB13)>1,((RANK(AB13,$AB$7:$AB62,1))+(COUNT($AB$7:$AB62)+1-RANK($AB13,$AB$7:$AB$56,0)-RANK($AB13,$AB$7:$AB$56,1))/2),RANK(AB13,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC13=\"x\",AC13,IF(COUNTIF($AC$7:$AC$56,AC13)>1,((RANK(AC13,$AC$7:$AC62,1))+(COUNT($AC$7:$AC62)+1-RANK($AC13,$AC$7:$AC$56,0)-RANK($AC13,$AC$7:$AC$56,1))/2),RANK(AC13,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD13=\"x\",AD13,IF(COUNTIF($AD$7:$AD$56,AD13)>1,((RANK(AD13,$AD$7:$AD62,1))+(COUNT($AD$7:$AD62)+1-RANK($AD13,$AD$7:$AD$56,0)-RANK($AD13,$AD$7:$AD$56,1))/2),RANK(AD13,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,9,29,35,39,43]
[null,null,"W VALUES ARE",null,{"$f":"IF('Time 1'!$AA$5=1,AQ63,AH63)","v":0},{"$f":"IF('Time 1'!$AA$5=1,AR63,AI63)","v":0},{"$f":"IF('Time 1'!$AA$5=1,AS63,AJ63)","v":0},null,null,null,null,null,null,null,null,null,null,8,{"$f":"'Time 1'!U13","v":"end"},{"$f":"'Time 1'!V13","v":"end"},{"$f":"'Time 1'!W13","v":"end"},{"$f":"'Time 2'!U13","v":"end"},{"$f":"'Time 2'!V13","v":"end"},{"$f":"'Time 2'!W13","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y14<0, AE14-(2*AE14),AE14))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z14<0, AF14-(2*AF14),AF14))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA14<0, AG14-(2*AG14),AG14))","v":"x"},{"$f":"IF(S14=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE14=\"x\",AE14,IF(AH14>0,1,2))))","v":""},{"$f":"IF(T14=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF14=\"x\",AF14,IF(AI14>0,1,2))))","v":""},{"$f":"IF(U14=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG14=\"x\",AG14,IF(AJ14>0,1,2))))","v":""},{"$f":"IF(AB14=\"x\",AB14,IF(COUNTIF($AB$7:$AB$56,AB14)>1,((RANK(AB14,$AB$7:$AB63,1))+(COUNT($AB$7:$AB63)+1-RANK($AB14,$AB$7:$AB$56,0)-RANK($AB14,$AB$7:$AB$56,1))/2),RANK(AB14,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC14=\"x\",AC14,IF(COUNTIF($AC$7:$AC$56,AC14)>1,((RANK(AC14,$AC$7:$AC63,1))+(COUNT($AC$7:$AC63)+1-RANK($AC14,$AC$7:$AC$56,0)-RANK($AC14,$AC$7:$AC$56,1))/2),RANK(AC14,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD14=\"x\",AD14,IF(COUNTIF($AD$7:$AD$56,AD14)>1,((RANK(AD14,$AD$7:$AD63,1))+(COUNT($AD$7:$AD63)+1-RANK($AD14,$AD$7:$AD$56,0)-RANK($AD14,$AD$7:$AD$56,1))/2),RANK(AD14,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","",""]
[null,null,"MEAN DIFFERENCES",null,{"$f":"IF('Time 1'!$AA$5=1,Y59, Y57)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!$AA$5=1,Z59, Z57)","v":{"$error":"#DIV/0!"}},{"$f":"IF('Time 1'!$AA$5=1,AA59, AA57)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,9,{"$f":"'Time 1'!U14","v":"end"},{"$f":"'Time 1'!V14","v":"end"},{"$f":"'Time 1'!W14","v":"end"},{"$f":"'Time 2'!U14","v":"end"},{"$f":"'Time 2'!V14","v":"end"},{"$f":"'Time 2'!W14","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y15<0, AE15-(2*AE15),AE15))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z15<0, AF15-(2*AF15),AF15))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA15<0, AG15-(2*AG15),AG15))","v":"x"},{"$f":"IF(S15=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE15=\"x\",AE15,IF(AH15>0,1,2))))","v":""},{"$f":"IF(T15=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF15=\"x\",AF15,IF(AI15>0,1,2))))","v":""},{"$f":"IF(U15=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG15=\"x\",AG15,IF(AJ15>0,1,2))))","v":""},{"$f":"IF(AB15=\"x\",AB15,IF(COUNTIF($AB$7:$AB$56,AB15)>1,((RANK(AB15,$AB$7:$AB64,1))+(COUNT($AB$7:$AB64)+1-RANK($AB15,$AB$7:$AB$56,0)-RANK($AB15,$AB$7:$AB$56,1))/2),RANK(AB15,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC15=\"x\",AC15,IF(COUNTIF($AC$7:$AC$56,AC15)>1,((RANK(AC15,$AC$7:$AC64,1))+(COUNT($AC$7:$AC64)+1-RANK($AC15,$AC$7:$AC$56,0)-RANK($AC15,$AC$7:$AC$56,1))/2),RANK(AC15,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD15=\"x\",AD15,IF(COUNTIF($AD$7:$AD$56,AD15)>1,((RANK(AD15,$AD$7:$AD64,1))+(COUNT($AD$7:$AD64)+1-RANK($AD15,$AD$7:$AD$56,0)-RANK($AD15,$AD$7:$AD$56,1))/2),RANK(AD15,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"'Time 1'!U15","v":"end"},{"$f":"'Time 1'!V15","v":"end"},{"$f":"'Time 1'!W15","v":"end"},{"$f":"'Time 2'!U15","v":"end"},{"$f":"'Time 2'!V15","v":"end"},{"$f":"'Time 2'!W15","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y16<0, AE16-(2*AE16),AE16))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z16<0, AF16-(2*AF16),AF16))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA16<0, AG16-(2*AG16),AG16))","v":"x"},{"$f":"IF(S16=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE16=\"x\",AE16,IF(AH16>0,1,2))))","v":""},{"$f":"IF(T16=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF16=\"x\",AF16,IF(AI16>0,1,2))))","v":""},{"$f":"IF(U16=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG16=\"x\",AG16,IF(AJ16>0,1,2))))","v":""},{"$f":"IF(AB16=\"x\",AB16,IF(COUNTIF($AB$7:$AB$56,AB16)>1,((RANK(AB16,$AB$7:$AB65,1))+(COUNT($AB$7:$AB65)+1-RANK($AB16,$AB$7:$AB$56,0)-RANK($AB16,$AB$7:$AB$56,1))/2),RANK(AB16,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC16=\"x\",AC16,IF(COUNTIF($AC$7:$AC$56,AC16)>1,((RANK(AC16,$AC$7:$AC65,1))+(COUNT($AC$7:$AC65)+1-RANK($AC16,$AC$7:$AC$56,0)-RANK($AC16,$AC$7:$AC$56,1))/2),RANK(AC16,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD16=\"x\",AD16,IF(COUNTIF($AD$7:$AD$56,AD16)>1,((RANK(AD16,$AD$7:$AD65,1))+(COUNT($AD$7:$AD65)+1-RANK($AD16,$AD$7:$AD$56,0)-RANK($AD16,$AD$7:$AD$56,1))/2),RANK(AD16,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,"Table from Definitions and formulae with statistical tables for elementary statistics and quantitative methods courses - http://www.oxford.ac.uk/stats",null,null,null,null,null,null,"University of Oxford Dept. Statistics October 2005"]
[null,null,"Test adjusted for number of cases",null,"FOR PLACES","FOR PEOPLE","CLOCK SPREAD",null,null,null,null,null,null,null,null,null,null,11,{"$f":"'Time 1'!U16","v":"end"},{"$f":"'Time 1'!V16","v":"end"},{"$f":"'Time 1'!W16","v":"end"},{"$f":"'Time 2'!U16","v":"end"},{"$f":"'Time 2'!V16","v":"end"},{"$f":"'Time 2'!W16","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y17<0, AE17-(2*AE17),AE17))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z17<0, AF17-(2*AF17),AF17))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA17<0, AG17-(2*AG17),AG17))","v":"x"},{"$f":"IF(S17=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE17=\"x\",AE17,IF(AH17>0,1,2))))","v":""},{"$f":"IF(T17=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF17=\"x\",AF17,IF(AI17>0,1,2))))","v":""},{"$f":"IF(U17=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG17=\"x\",AG17,IF(AJ17>0,1,2))))","v":""},{"$f":"IF(AB17=\"x\",AB17,IF(COUNTIF($AB$7:$AB$56,AB17)>1,((RANK(AB17,$AB$7:$AB66,1))+(COUNT($AB$7:$AB66)+1-RANK($AB17,$AB$7:$AB$56,0)-RANK($AB17,$AB$7:$AB$56,1))/2),RANK(AB17,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC17=\"x\",AC17,IF(COUNTIF($AC$7:$AC$56,AC17)>1,((RANK(AC17,$AC$7:$AC66,1))+(COUNT($AC$7:$AC66)+1-RANK($AC17,$AC$7:$AC$56,0)-RANK($AC17,$AC$7:$AC$56,1))/2),RANK(AC17,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD17=\"x\",AD17,IF(COUNTIF($AD$7:$AD$56,AD17)>1,((RANK(AD17,$AD$7:$AD66,1))+(COUNT($AD$7:$AD66)+1-RANK($AD17,$AD$7:$AD$56,0)-RANK($AD17,$AD$7:$AD$56,1))/2),RANK(AD17,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,"Critical values of T"]
[null,null,"1 tailed test","2 tailed test","Critical values for T","Critical values for T","Critical values for T",null,"Results in words for the 2 tailed Wilcoxon Signed Rank Test",null,null,null,null,null,null,null,null,12,{"$f":"'Time 1'!U17","v":"end"},{"$f":"'Time 1'!V17","v":"end"},{"$f":"'Time 1'!W17","v":"end"},{"$f":"'Time 2'!U17","v":"end"},{"$f":"'Time 2'!V17","v":"end"},{"$f":"'Time 2'!W17","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y18<0, AE18-(2*AE18),AE18))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z18<0, AF18-(2*AF18),AF18))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA18<0, AG18-(2*AG18),AG18))","v":"x"},{"$f":"IF(S18=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE18=\"x\",AE18,IF(AH18>0,1,2))))","v":""},{"$f":"IF(T18=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF18=\"x\",AF18,IF(AI18>0,1,2))))","v":""},{"$f":"IF(U18=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG18=\"x\",AG18,IF(AJ18>0,1,2))))","v":""},{"$f":"IF(AB18=\"x\",AB18,IF(COUNTIF($AB$7:$AB$56,AB18)>1,((RANK(AB18,$AB$7:$AB67,1))+(COUNT($AB$7:$AB67)+1-RANK($AB18,$AB$7:$AB$56,0)-RANK($AB18,$AB$7:$AB$56,1))/2),RANK(AB18,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC18=\"x\",AC18,IF(COUNTIF($AC$7:$AC$56,AC18)>1,((RANK(AC18,$AC$7:$AC67,1))+(COUNT($AC$7:$AC67)+1-RANK($AC18,$AC$7:$AC$56,0)-RANK($AC18,$AC$7:$AC$56,1))/2),RANK(AC18,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD18=\"x\",AD18,IF(COUNTIF($AD$7:$AD$56,AD18)>1,((RANK(AD18,$AD$7:$AD67,1))+(COUNT($AD$7:$AD67)+1-RANK($AD18,$AD$7:$AD$56,0)-RANK($AD18,$AD$7:$AD$56,1))/2),RANK(AD18,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,"NOT RELIABLE FOR SMALL SAMPLES - USE SMALL SAMPLES SPECIAL TEST",null,0,"x","x","x"]
[null,null,0.05,"0.10(NS)",{"$f":"IF(E6>30,\"N/A\",IF(E6>9,SUMIF(BA23:BA63,E6,BB23:BB63),SUMIF(BA9:BA13,E6,BB9:BB13)))","v":0},{"$f":"IF(F6>30,\"N/A\",IF(F6>9,SUMIF(BA23:BA63,F6,BB23:BB63),SUMIF(BA9:BA13,F6,BB9:BB13)))","v":0},{"$f":"IF(G6>30,\"N/A\",IF(G6>9,SUMIF(BA23:BA63,G6,BB23:BB63),SUMIF(BA9:BA13,G6,BB9:BB13)))","v":0},null,"Places","The test was  ",{"$f":"IF(L19=\"N/A\",\"\",IF(L19=\"\",\"not significant\",\"significant at the\"))","v":"not significant"},{"$f":"IF(E6>30,\"N/A\",IF(E26=\"yes\",D25, IF(E24=\"yes\",D23, IF(E22=\"yes\",D21,\"\"))))","v":""},{"$f":"IF(COUNT(L19)>0,\"level\",\"\")","v":""},null,null,null,null,13,{"$f":"'Time 1'!U18","v":"end"},{"$f":"'Time 1'!V18","v":"end"},{"$f":"'Time 1'!W18","v":"end"},{"$f":"'Time 2'!U18","v":"end"},{"$f":"'Time 2'!V18","v":"end"},{"$f":"'Time 2'!W18","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y19<0, AE19-(2*AE19),AE19))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z19<0, AF19-(2*AF19),AF19))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA19<0, AG19-(2*AG19),AG19))","v":"x"},{"$f":"IF(S19=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE19=\"x\",AE19,IF(AH19>0,1,2))))","v":""},{"$f":"IF(T19=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF19=\"x\",AF19,IF(AI19>0,1,2))))","v":""},{"$f":"IF(U19=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG19=\"x\",AG19,IF(AJ19>0,1,2))))","v":""},{"$f":"IF(AB19=\"x\",AB19,IF(COUNTIF($AB$7:$AB$56,AB19)>1,((RANK(AB19,$AB$7:$AB68,1))+(COUNT($AB$7:$AB68)+1-RANK($AB19,$AB$7:$AB$56,0)-RANK($AB19,$AB$7:$AB$56,1))/2),RANK(AB19,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC19=\"x\",AC19,IF(COUNTIF($AC$7:$AC$56,AC19)>1,((RANK(AC19,$AC$7:$AC68,1))+(COUNT($AC$7:$AC68)+1-RANK($AC19,$AC$7:$AC$56,0)-RANK($AC19,$AC$7:$AC$56,1))/2),RANK(AC19,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD19=\"x\",AD19,IF(COUNTIF($AD$7:$AD$56,AD19)>1,((RANK(AD19,$AD$7:$AD68,1))+(COUNT($AD$7:$AD68)+1-RANK($AD19,$AD$7:$AD$56,0)-RANK($AD19,$AD$7:$AD$56,1))/2),RANK(AD19,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,6,2,0,"x","x"]
[null,null,"SIGNIFICANT?",null,{"$f":"IF(E26=\"yes\",\"\",IF(E24=\"yes\",\"\",IF(E22=\"yes\",\"\",IF(E19=\"N/A\",\"\",IF(E13<E19,\"yes\",\"no\")))))","v":"no"},{"$f":"IF(F26=\"yes\",\"\",IF(F24=\"yes\",\"\",IF(F22=\"yes\",\"\",IF(F19=\"N/A\",\"\",IF(F13<F19,\"yes\",\"no\")))))","v":"no"},{"$f":"IF(G26=\"yes\",\"\",IF(G24=\"yes\",\"\",IF(G22=\"yes\",\"\",IF(G19=\"N/A\",\"\",IF(G13<G19,\"yes\",\"no\")))))","v":"no"},null,"People","The test was  ",{"$f":"IF(L20=\"N/A\",\"\",IF(L20=\"\",\"not significant\",\"significant at the\"))","v":"not significant"},{"$f":"IF(F6>30,\"N/A\",IF(F26=\"yes\",D25, IF(F24=\"yes\",D23, IF(F22=\"yes\",D21,\"\"))))","v":""},{"$f":"IF(COUNT(L20)>0,\"level\",\"\")","v":""},null,null,null,null,14,{"$f":"'Time 1'!U19","v":"end"},{"$f":"'Time 1'!V19","v":"end"},{"$f":"'Time 1'!W19","v":"end"},{"$f":"'Time 2'!U19","v":"end"},{"$f":"'Time 2'!V19","v":"end"},{"$f":"'Time 2'!W19","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y20<0, AE20-(2*AE20),AE20))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z20<0, AF20-(2*AF20),AF20))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA20<0, AG20-(2*AG20),AG20))","v":"x"},{"$f":"IF(S20=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE20=\"x\",AE20,IF(AH20>0,1,2))))","v":""},{"$f":"IF(T20=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF20=\"x\",AF20,IF(AI20>0,1,2))))","v":""},{"$f":"IF(U20=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG20=\"x\",AG20,IF(AJ20>0,1,2))))","v":""},{"$f":"IF(AB20=\"x\",AB20,IF(COUNTIF($AB$7:$AB$56,AB20)>1,((RANK(AB20,$AB$7:$AB70,1))+(COUNT($AB$7:$AB70)+1-RANK($AB20,$AB$7:$AB$56,0)-RANK($AB20,$AB$7:$AB$56,1))/2),RANK(AB20,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC20=\"x\",AC20,IF(COUNTIF($AC$7:$AC$56,AC20)>1,((RANK(AC20,$AC$7:$AC70,1))+(COUNT($AC$7:$AC70)+1-RANK($AC20,$AC$7:$AC$56,0)-RANK($AC20,$AC$7:$AC$56,1))/2),RANK(AC20,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD20=\"x\",AD20,IF(COUNTIF($AD$7:$AD$56,AD20)>1,((RANK(AD20,$AD$7:$AD70,1))+(COUNT($AD$7:$AD70)+1-RANK($AD20,$AD$7:$AD$56,0)-RANK($AD20,$AD$7:$AD$56,1))/2),RANK(AD20,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,7,3,2,0,"x"]
[null,null,2.5000000000000001E-2,0.05,{"$f":"IF(E6>30,\"N/A\",IF(E6>9,SUMIF(BA23:BA63,E6,BC23:BC63),SUMIF(BA9:BA13,E6,BC9:BC13)))","v":0},{"$f":"IF(F6>30,\"N/A\",IF(F6>9,SUMIF(BA23:BA63,F6,BC23:BC63),SUMIF(BA9:BA13,F6,BC9:BC13)))","v":0},{"$f":"IF(G6>30,\"N/A\",IF(G6>9,SUMIF(BA23:BA63,G6,BC23:BC63),SUMIF(BA9:BA13,G6,BC9:BC13)))","v":0},null,"Clockspread","The test was  ",{"$f":"IF(L21=\"N/A\",\"\",IF(L21=\"\",\"not significant\",\"significant at the\"))","v":"not significant"},{"$f":"IF(G6>30,\"N/A\",IF(G26=\"yes\",D25, IF(G24=\"yes\",D23, IF(G22=\"yes\",D21,\"\"))))","v":""},{"$f":"IF(COUNT(L21)>0,\"level\",\"\")","v":""},null,null,null,null,15,{"$f":"'Time 1'!U20","v":"end"},{"$f":"'Time 1'!V20","v":"end"},{"$f":"'Time 1'!W20","v":"end"},{"$f":"'Time 2'!U20","v":"end"},{"$f":"'Time 2'!V20","v":"end"},{"$f":"'Time 2'!W20","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y21<0, AE21-(2*AE21),AE21))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z21<0, AF21-(2*AF21),AF21))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA21<0, AG21-(2*AG21),AG21))","v":"x"},{"$f":"IF(S21=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE21=\"x\",AE21,IF(AH21>0,1,2))))","v":""},{"$f":"IF(T21=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF21=\"x\",AF21,IF(AI21>0,1,2))))","v":""},{"$f":"IF(U21=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG21=\"x\",AG21,IF(AJ21>0,1,2))))","v":""},{"$f":"IF(AB21=\"x\",AB21,IF(COUNTIF($AB$7:$AB$56,AB21)>1,((RANK(AB21,$AB$7:$AB71,1))+(COUNT($AB$7:$AB71)+1-RANK($AB21,$AB$7:$AB$56,0)-RANK($AB21,$AB$7:$AB$56,1))/2),RANK(AB21,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC21=\"x\",AC21,IF(COUNTIF($AC$7:$AC$56,AC21)>1,((RANK(AC21,$AC$7:$AC71,1))+(COUNT($AC$7:$AC71)+1-RANK($AC21,$AC$7:$AC$56,0)-RANK($AC21,$AC$7:$AC$56,1))/2),RANK(AC21,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD21=\"x\",AD21,IF(COUNTIF($AD$7:$AD$56,AD21)>1,((RANK(AD21,$AD$7:$AD71,1))+(COUNT($AD$7:$AD71)+1-RANK($AD21,$AD$7:$AD$56,0)-RANK($AD21,$AD$7:$AD$56,1))/2),RANK(AD21,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,8,5,3,1,0]
[null,null,"SIGNIFICANT?",null,{"$f":"IF(E26=\"yes\",\"\",IF(E24=\"yes\",\"\",IF(E21=\"N/A\",\"\",IF(E13<E21,\"yes\",\"no\"))))","v":"no"},{"$f":"IF(F26=\"yes\",\"\",IF(F24=\"yes\",\"\",IF(F21=\"N/A\",\"\",IF(F13<F21,\"yes\",\"no\"))))","v":"no"},{"$f":"IF(G26=\"yes\",\"\",IF(G24=\"yes\",\"\",IF(G21=\"N/A\",\"\",IF(G13<G21,\"yes\",\"no\"))))","v":"no"},null,null,null,null,null,null,null,null,null,null,16,{"$f":"'Time 1'!U21","v":"end"},{"$f":"'Time 1'!V21","v":"end"},{"$f":"'Time 1'!W21","v":"end"},{"$f":"'Time 2'!U21","v":"end"},{"$f":"'Time 2'!V21","v":"end"},{"$f":"'Time 2'!W21","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y22<0, AE22-(2*AE22),AE22))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z22<0, AF22-(2*AF22),AF22))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA22<0, AG22-(2*AG22),AG22))","v":"x"},{"$f":"IF(S22=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE22=\"x\",AE22,IF(AH22>0,1,2))))","v":""},{"$f":"IF(T22=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF22=\"x\",AF22,IF(AI22>0,1,2))))","v":""},{"$f":"IF(U22=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG22=\"x\",AG22,IF(AJ22>0,1,2))))","v":""},{"$f":"IF(AB22=\"x\",AB22,IF(COUNTIF($AB$7:$AB$56,AB22)>1,((RANK(AB22,$AB$7:$AB72,1))+(COUNT($AB$7:$AB72)+1-RANK($AB22,$AB$7:$AB$56,0)-RANK($AB22,$AB$7:$AB$56,1))/2),RANK(AB22,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC22=\"x\",AC22,IF(COUNTIF($AC$7:$AC$56,AC22)>1,((RANK(AC22,$AC$7:$AC72,1))+(COUNT($AC$7:$AC72)+1-RANK($AC22,$AC$7:$AC$56,0)-RANK($AC22,$AC$7:$AC$56,1))/2),RANK(AC22,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD22=\"x\",AD22,IF(COUNTIF($AD$7:$AD$56,AD22)>1,((RANK(AD22,$AD$7:$AD72,1))+(COUNT($AD$7:$AD72)+1-RANK($AD22,$AD$7:$AD$56,0)-RANK($AD22,$AD$7:$AD$56,1))/2),RANK(AD22,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,9,8,5,3,1]
[null,null,0.01,0.02,{"$f":"IF(E6>30,\"N/A\",IF(E6>9,SUMIF(BA23:BA63,E6,BD23:BD63),SUMIF(BA9:BA13,E6,BD9:BD13)))","v":0},{"$f":"IF(F6>30,\"N/A\",IF(F6>9,SUMIF(BA23:BA63,F6,BD23:BD63),SUMIF(BA9:BA13,F6,BD9:BD13)))","v":0},{"$f":"IF(G6>30,\"N/A\",IF(G6>9,SUMIF(BA23:BA63,G6,BD23:BD63),SUMIF(BA9:BA13,G6,BD9:BD13)))","v":0},null,null,null,null,null,null,null,null,null,null,17,{"$f":"'Time 1'!U22","v":"end"},{"$f":"'Time 1'!V22","v":"end"},{"$f":"'Time 1'!W22","v":"end"},{"$f":"'Time 2'!U22","v":"end"},{"$f":"'Time 2'!V22","v":"end"},{"$f":"'Time 2'!W22","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y23<0, AE23-(2*AE23),AE23))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z23<0, AF23-(2*AF23),AF23))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA23<0, AG23-(2*AG23),AG23))","v":"x"},{"$f":"IF(S23=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE23=\"x\",AE23,IF(AH23>0,1,2))))","v":""},{"$f":"IF(T23=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF23=\"x\",AF23,IF(AI23>0,1,2))))","v":""},{"$f":"IF(U23=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG23=\"x\",AG23,IF(AJ23>0,1,2))))","v":""},{"$f":"IF(AB23=\"x\",AB23,IF(COUNTIF($AB$7:$AB$56,AB23)>1,((RANK(AB23,$AB$7:$AB73,1))+(COUNT($AB$7:$AB73)+1-RANK($AB23,$AB$7:$AB$56,0)-RANK($AB23,$AB$7:$AB$56,1))/2),RANK(AB23,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC23=\"x\",AC23,IF(COUNTIF($AC$7:$AC$56,AC23)>1,((RANK(AC23,$AC$7:$AC73,1))+(COUNT($AC$7:$AC73)+1-RANK($AC23,$AC$7:$AC$56,0)-RANK($AC23,$AC$7:$AC$56,1))/2),RANK(AC23,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD23=\"x\",AD23,IF(COUNTIF($AD$7:$AD$56,AD23)>1,((RANK(AD23,$AD$7:$AD73,1))+(COUNT($AD$7:$AD73)+1-RANK($AD23,$AD$7:$AD$56,0)-RANK($AD23,$AD$7:$AD$56,1))/2),RANK(AD23,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,10,10,8,5,3]
[null,null,"SIGNIFICANT?",null,{"$f":"IF(E26=\"yes\",\"\",IF(E23=\"N/A\",\"\",IF(E13<E23,\"yes\",\"no\")))","v":"no"},{"$f":"IF(F26=\"yes\",\"\",IF(F23=\"N/A\",\"\",IF(F13<F23,\"yes\",\"no\")))","v":"no"},{"$f":"IF(G26=\"yes\",\"\",IF(G23=\"N/A\",\"\",IF(G13<G23,\"yes\",\"no\")))","v":"no"},null,null,null,null,null,null,null,null,null,null,18,{"$f":"'Time 1'!U23","v":"end"},{"$f":"'Time 1'!V23","v":"end"},{"$f":"'Time 1'!W23","v":"end"},{"$f":"'Time 2'!U23","v":"end"},{"$f":"'Time 2'!V23","v":"end"},{"$f":"'Time 2'!W23","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y24<0, AE24-(2*AE24),AE24))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z24<0, AF24-(2*AF24),AF24))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA24<0, AG24-(2*AG24),AG24))","v":"x"},{"$f":"IF(S24=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE24=\"x\",AE24,IF(AH24>0,1,2))))","v":""},{"$f":"IF(T24=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF24=\"x\",AF24,IF(AI24>0,1,2))))","v":""},{"$f":"IF(U24=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG24=\"x\",AG24,IF(AJ24>0,1,2))))","v":""},{"$f":"IF(AB24=\"x\",AB24,IF(COUNTIF($AB$7:$AB$56,AB24)>1,((RANK(AB24,$AB$7:$AB74,1))+(COUNT($AB$7:$AB74)+1-RANK($AB24,$AB$7:$AB$56,0)-RANK($AB24,$AB$7:$AB$56,1))/2),RANK(AB24,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC24=\"x\",AC24,IF(COUNTIF($AC$7:$AC$56,AC24)>1,((RANK(AC24,$AC$7:$AC74,1))+(COUNT($AC$7:$AC74)+1-RANK($AC24,$AC$7:$AC$56,0)-RANK($AC24,$AC$7:$AC$56,1))/2),RANK(AC24,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD24=\"x\",AD24,IF(COUNTIF($AD$7:$AD$56,AD24)>1,((RANK(AD24,$AD$7:$AD74,1))+(COUNT($AD$7:$AD74)+1-RANK($AD24,$AD$7:$AD$56,0)-RANK($AD24,$AD$7:$AD$56,1))/2),RANK(AD24,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,11,14,10,8,5]
[null,null,5.0000000000000001E-3,0.01,{"$f":"IF(E6>30,\"N/A\",IF(E6>9,SUMIF(BA23:BA63,E6,BE23:BE63),SUMIF(BA9:BA13,E6,BD9:BE13)))","v":0},{"$f":"IF(F6>30,\"N/A\",IF(F6>9,SUMIF(BA23:BA63,F6,BE23:BE63),SUMIF(BA9:BA13,F6,BD9:BE13)))","v":0},{"$f":"IF(G6>30,\"N/A\",IF(G6>9,SUMIF(BA23:BA63,G6,BE23:BE63),SUMIF(BA9:BA13,G6,BD9:BE13)))","v":0},null,null,null,null,null,null,null,null,null,null,19,{"$f":"'Time 1'!U24","v":"end"},{"$f":"'Time 1'!V24","v":"end"},{"$f":"'Time 1'!W24","v":"end"},{"$f":"'Time 2'!U24","v":"end"},{"$f":"'Time 2'!V24","v":"end"},{"$f":"'Time 2'!W24","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y25<0, AE25-(2*AE25),AE25))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z25<0, AF25-(2*AF25),AF25))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA25<0, AG25-(2*AG25),AG25))","v":"x"},{"$f":"IF(S25=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE25=\"x\",AE25,IF(AH25>0,1,2))))","v":""},{"$f":"IF(T25=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF25=\"x\",AF25,IF(AI25>0,1,2))))","v":""},{"$f":"IF(U25=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG25=\"x\",AG25,IF(AJ25>0,1,2))))","v":""},{"$f":"IF(AB25=\"x\",AB25,IF(COUNTIF($AB$7:$AB$56,AB25)>1,((RANK(AB25,$AB$7:$AB75,1))+(COUNT($AB$7:$AB75)+1-RANK($AB25,$AB$7:$AB$56,0)-RANK($AB25,$AB$7:$AB$56,1))/2),RANK(AB25,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC25=\"x\",AC25,IF(COUNTIF($AC$7:$AC$56,AC25)>1,((RANK(AC25,$AC$7:$AC75,1))+(COUNT($AC$7:$AC75)+1-RANK($AC25,$AC$7:$AC$56,0)-RANK($AC25,$AC$7:$AC$56,1))/2),RANK(AC25,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD25=\"x\",AD25,IF(COUNTIF($AD$7:$AD$56,AD25)>1,((RANK(AD25,$AD$7:$AD75,1))+(COUNT($AD$7:$AD75)+1-RANK($AD25,$AD$7:$AD$56,0)-RANK($AD25,$AD$7:$AD$56,1))/2),RANK(AD25,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,12,17,13,10,8]
[null,null,"SIGNIFICANT?",null,{"$f":"IF(E25=\"N/A\",\"\",IF(E13<E25,\"yes\",\"no\"))","v":"no"},{"$f":"IF(F25=\"N/A\",\"\",IF(F13<F25,\"yes\",\"no\"))","v":"no"},{"$f":"IF(G25=\"N/A\",\"\",IF(G13<G25,\"yes\",\"no\"))","v":"no"},null,null,null,null,null,null,null,null,null,null,20,{"$f":"'Time 1'!U25","v":"end"},{"$f":"'Time 1'!V25","v":"end"},{"$f":"'Time 1'!W25","v":"end"},{"$f":"'Time 2'!U25","v":"end"},{"$f":"'Time 2'!V25","v":"end"},{"$f":"'Time 2'!W25","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y26<0, AE26-(2*AE26),AE26))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z26<0, AF26-(2*AF26),AF26))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA26<0, AG26-(2*AG26),AG26))","v":"x"},{"$f":"IF(S26=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE26=\"x\",AE26,IF(AH26>0,1,2))))","v":""},{"$f":"IF(T26=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF26=\"x\",AF26,IF(AI26>0,1,2))))","v":""},{"$f":"IF(U26=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG26=\"x\",AG26,IF(AJ26>0,1,2))))","v":""},{"$f":"IF(AB26=\"x\",AB26,IF(COUNTIF($AB$7:$AB$56,AB26)>1,((RANK(AB26,$AB$7:$AB76,1))+(COUNT($AB$7:$AB76)+1-RANK($AB26,$AB$7:$AB$56,0)-RANK($AB26,$AB$7:$AB$56,1))/2),RANK(AB26,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC26=\"x\",AC26,IF(COUNTIF($AC$7:$AC$56,AC26)>1,((RANK(AC26,$AC$7:$AC76,1))+(COUNT($AC$7:$AC76)+1-RANK($AC26,$AC$7:$AC$56,0)-RANK($AC26,$AC$7:$AC$56,1))/2),RANK(AC26,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD26=\"x\",AD26,IF(COUNTIF($AD$7:$AD$56,AD26)>1,((RANK(AD26,$AD$7:$AD76,1))+(COUNT($AD$7:$AD76)+1-RANK($AD26,$AD$7:$AD$56,0)-RANK($AD26,$AD$7:$AD$56,1))/2),RANK(AD26,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,13,21,17,14,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"'Time 1'!U26","v":"end"},{"$f":"'Time 1'!V26","v":"end"},{"$f":"'Time 1'!W26","v":"end"},{"$f":"'Time 2'!U26","v":"end"},{"$f":"'Time 2'!V26","v":"end"},{"$f":"'Time 2'!W26","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y27<0, AE27-(2*AE27),AE27))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z27<0, AF27-(2*AF27),AF27))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA27<0, AG27-(2*AG27),AG27))","v":"x"},{"$f":"IF(S27=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE27=\"x\",AE27,IF(AH27>0,1,2))))","v":""},{"$f":"IF(T27=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF27=\"x\",AF27,IF(AI27>0,1,2))))","v":""},{"$f":"IF(U27=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG27=\"x\",AG27,IF(AJ27>0,1,2))))","v":""},{"$f":"IF(AB27=\"x\",AB27,IF(COUNTIF($AB$7:$AB$56,AB27)>1,((RANK(AB27,$AB$7:$AB77,1))+(COUNT($AB$7:$AB77)+1-RANK($AB27,$AB$7:$AB$56,0)-RANK($AB27,$AB$7:$AB$56,1))/2),RANK(AB27,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC27=\"x\",AC27,IF(COUNTIF($AC$7:$AC$56,AC27)>1,((RANK(AC27,$AC$7:$AC77,1))+(COUNT($AC$7:$AC77)+1-RANK($AC27,$AC$7:$AC$56,0)-RANK($AC27,$AC$7:$AC$56,1))/2),RANK(AC27,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD27=\"x\",AD27,IF(COUNTIF($AD$7:$AD$56,AD27)>1,((RANK(AD27,$AD$7:$AD77,1))+(COUNT($AD$7:$AD77)+1-RANK($AD27,$AD$7:$AD$56,0)-RANK($AD27,$AD$7:$AD$56,1))/2),RANK(AD27,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,14,26,21,17,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"'Time 1'!U27","v":"end"},{"$f":"'Time 1'!V27","v":"end"},{"$f":"'Time 1'!W27","v":"end"},{"$f":"'Time 2'!U27","v":"end"},{"$f":"'Time 2'!V27","v":"end"},{"$f":"'Time 2'!W27","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y28<0, AE28-(2*AE28),AE28))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z28<0, AF28-(2*AF28),AF28))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA28<0, AG28-(2*AG28),AG28))","v":"x"},{"$f":"IF(S28=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE28=\"x\",AE28,IF(AH28>0,1,2))))","v":""},{"$f":"IF(T28=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF28=\"x\",AF28,IF(AI28>0,1,2))))","v":""},{"$f":"IF(U28=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG28=\"x\",AG28,IF(AJ28>0,1,2))))","v":""},{"$f":"IF(AB28=\"x\",AB28,IF(COUNTIF($AB$7:$AB$56,AB28)>1,((RANK(AB28,$AB$7:$AB78,1))+(COUNT($AB$7:$AB78)+1-RANK($AB28,$AB$7:$AB$56,0)-RANK($AB28,$AB$7:$AB$56,1))/2),RANK(AB28,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC28=\"x\",AC28,IF(COUNTIF($AC$7:$AC$56,AC28)>1,((RANK(AC28,$AC$7:$AC78,1))+(COUNT($AC$7:$AC78)+1-RANK($AC28,$AC$7:$AC$56,0)-RANK($AC28,$AC$7:$AC$56,1))/2),RANK(AC28,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD28=\"x\",AD28,IF(COUNTIF($AD$7:$AD$56,AD28)>1,((RANK(AD28,$AD$7:$AD78,1))+(COUNT($AD$7:$AD78)+1-RANK($AD28,$AD$7:$AD$56,0)-RANK($AD28,$AD$7:$AD$56,1))/2),RANK(AD28,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,15,30,25,21,17]
["Your Results  (z ratio) For help hover the cursor over the boxes with red triangles.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"'Time 1'!U28","v":"end"},{"$f":"'Time 1'!V28","v":"end"},{"$f":"'Time 1'!W28","v":"end"},{"$f":"'Time 2'!U28","v":"end"},{"$f":"'Time 2'!V28","v":"end"},{"$f":"'Time 2'!W28","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y29<0, AE29-(2*AE29),AE29))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z29<0, AF29-(2*AF29),AF29))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA29<0, AG29-(2*AG29),AG29))","v":"x"},{"$f":"IF(S29=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE29=\"x\",AE29,IF(AH29>0,1,2))))","v":""},{"$f":"IF(T29=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF29=\"x\",AF29,IF(AI29>0,1,2))))","v":""},{"$f":"IF(U29=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG29=\"x\",AG29,IF(AJ29>0,1,2))))","v":""},{"$f":"IF(AB29=\"x\",AB29,IF(COUNTIF($AB$7:$AB$56,AB29)>1,((RANK(AB29,$AB$7:$AB79,1))+(COUNT($AB$7:$AB79)+1-RANK($AB29,$AB$7:$AB$56,0)-RANK($AB29,$AB$7:$AB$56,1))/2),RANK(AB29,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC29=\"x\",AC29,IF(COUNTIF($AC$7:$AC$56,AC29)>1,((RANK(AC29,$AC$7:$AC79,1))+(COUNT($AC$7:$AC79)+1-RANK($AC29,$AC$7:$AC$56,0)-RANK($AC29,$AC$7:$AC$56,1))/2),RANK(AC29,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD29=\"x\",AD29,IF(COUNTIF($AD$7:$AD$56,AD29)>1,((RANK(AD29,$AD$7:$AD79,1))+(COUNT($AD$7:$AD79)+1-RANK($AD29,$AD$7:$AD$56,0)-RANK($AD29,$AD$7:$AD$56,1))/2),RANK(AD29,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,16,36,29,26,21]
["The z-ratio is used if there are more than 10 cases - it compares the normal distribution with W and gives a better estimate of the probability for larger samples",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"'Time 1'!U29","v":"end"},{"$f":"'Time 1'!V29","v":"end"},{"$f":"'Time 1'!W29","v":"end"},{"$f":"'Time 2'!U29","v":"end"},{"$f":"'Time 2'!V29","v":"end"},{"$f":"'Time 2'!W29","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y30<0, AE30-(2*AE30),AE30))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z30<0, AF30-(2*AF30),AF30))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA30<0, AG30-(2*AG30),AG30))","v":"x"},{"$f":"IF(S30=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE30=\"x\",AE30,IF(AH30>0,1,2))))","v":""},{"$f":"IF(T30=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF30=\"x\",AF30,IF(AI30>0,1,2))))","v":""},{"$f":"IF(U30=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG30=\"x\",AG30,IF(AJ30>0,1,2))))","v":""},{"$f":"IF(AB30=\"x\",AB30,IF(COUNTIF($AB$7:$AB$56,AB30)>1,((RANK(AB30,$AB$7:$AB80,1))+(COUNT($AB$7:$AB80)+1-RANK($AB30,$AB$7:$AB$56,0)-RANK($AB30,$AB$7:$AB$56,1))/2),RANK(AB30,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC30=\"x\",AC30,IF(COUNTIF($AC$7:$AC$56,AC30)>1,((RANK(AC30,$AC$7:$AC80,1))+(COUNT($AC$7:$AC80)+1-RANK($AC30,$AC$7:$AC$56,0)-RANK($AC30,$AC$7:$AC$56,1))/2),RANK(AC30,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD30=\"x\",AD30,IF(COUNTIF($AD$7:$AD$56,AD30)>1,((RANK(AD30,$AD$7:$AD80,1))+(COUNT($AD$7:$AD80)+1-RANK($AD30,$AD$7:$AD$56,0)-RANK($AD30,$AD$7:$AD$56,1))/2),RANK(AD30,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,17,41,34,30,25]
["If your sample size is 10-15, use it AS WELL AS, if larger samples 25-30, use it as well or instead of the W results",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"'Time 1'!U30","v":"end"},{"$f":"'Time 1'!V30","v":"end"},{"$f":"'Time 1'!W30","v":"end"},{"$f":"'Time 2'!U30","v":"end"},{"$f":"'Time 2'!V30","v":"end"},{"$f":"'Time 2'!W30","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y31<0, AE31-(2*AE31),AE31))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z31<0, AF31-(2*AF31),AF31))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA31<0, AG31-(2*AG31),AG31))","v":"x"},{"$f":"IF(S31=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE31=\"x\",AE31,IF(AH31>0,1,2))))","v":""},{"$f":"IF(T31=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF31=\"x\",AF31,IF(AI31>0,1,2))))","v":""},{"$f":"IF(U31=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG31=\"x\",AG31,IF(AJ31>0,1,2))))","v":""},{"$f":"IF(AB31=\"x\",AB31,IF(COUNTIF($AB$7:$AB$56,AB31)>1,((RANK(AB31,$AB$7:$AB81,1))+(COUNT($AB$7:$AB81)+1-RANK($AB31,$AB$7:$AB$56,0)-RANK($AB31,$AB$7:$AB$56,1))/2),RANK(AB31,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC31=\"x\",AC31,IF(COUNTIF($AC$7:$AC$56,AC31)>1,((RANK(AC31,$AC$7:$AC81,1))+(COUNT($AC$7:$AC81)+1-RANK($AC31,$AC$7:$AC$56,0)-RANK($AC31,$AC$7:$AC$56,1))/2),RANK(AC31,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD31=\"x\",AD31,IF(COUNTIF($AD$7:$AD$56,AD31)>1,((RANK(AD31,$AD$7:$AD81,1))+(COUNT($AD$7:$AD81)+1-RANK($AD31,$AD$7:$AD$56,0)-RANK($AD31,$AD$7:$AD$56,1))/2),RANK(AD31,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,18,47,40,36,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"'Time 1'!U31","v":"end"},{"$f":"'Time 1'!V31","v":"end"},{"$f":"'Time 1'!W31","v":"end"},{"$f":"'Time 2'!U31","v":"end"},{"$f":"'Time 2'!V31","v":"end"},{"$f":"'Time 2'!W31","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y32<0, AE32-(2*AE32),AE32))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z32<0, AF32-(2*AF32),AF32))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA32<0, AG32-(2*AG32),AG32))","v":"x"},{"$f":"IF(S32=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE32=\"x\",AE32,IF(AH32>0,1,2))))","v":""},{"$f":"IF(T32=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF32=\"x\",AF32,IF(AI32>0,1,2))))","v":""},{"$f":"IF(U32=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG32=\"x\",AG32,IF(AJ32>0,1,2))))","v":""},{"$f":"IF(AB32=\"x\",AB32,IF(COUNTIF($AB$7:$AB$56,AB32)>1,((RANK(AB32,$AB$7:$AB82,1))+(COUNT($AB$7:$AB82)+1-RANK($AB32,$AB$7:$AB$56,0)-RANK($AB32,$AB$7:$AB$56,1))/2),RANK(AB32,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC32=\"x\",AC32,IF(COUNTIF($AC$7:$AC$56,AC32)>1,((RANK(AC32,$AC$7:$AC82,1))+(COUNT($AC$7:$AC82)+1-RANK($AC32,$AC$7:$AC$56,0)-RANK($AC32,$AC$7:$AC$56,1))/2),RANK(AC32,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD32=\"x\",AD32,IF(COUNTIF($AD$7:$AD$56,AD32)>1,((RANK(AD32,$AD$7:$AD82,1))+(COUNT($AD$7:$AD82)+1-RANK($AD32,$AD$7:$AD$56,0)-RANK($AD32,$AD$7:$AD$56,1))/2),RANK(AD32,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,19,53,46,41,34]
[null,null,"The z-ratio ",null,"PLACES","PEOPLE","CLOCK SPREAD",null,"Results in words using the z-ratio, for the Wilcoxon Signed Rank Test",null,null,null,null,null,null,null,null,27,{"$f":"'Time 1'!U32","v":"end"},{"$f":"'Time 1'!V32","v":"end"},{"$f":"'Time 1'!W32","v":"end"},{"$f":"'Time 2'!U32","v":"end"},{"$f":"'Time 2'!V32","v":"end"},{"$f":"'Time 2'!W32","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y33<0, AE33-(2*AE33),AE33))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z33<0, AF33-(2*AF33),AF33))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA33<0, AG33-(2*AG33),AG33))","v":"x"},{"$f":"IF(S33=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE33=\"x\",AE33,IF(AH33>0,1,2))))","v":""},{"$f":"IF(T33=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF33=\"x\",AF33,IF(AI33>0,1,2))))","v":""},{"$f":"IF(U33=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG33=\"x\",AG33,IF(AJ33>0,1,2))))","v":""},{"$f":"IF(AB33=\"x\",AB33,IF(COUNTIF($AB$7:$AB$56,AB33)>1,((RANK(AB33,$AB$7:$AB83,1))+(COUNT($AB$7:$AB83)+1-RANK($AB33,$AB$7:$AB$56,0)-RANK($AB33,$AB$7:$AB$56,1))/2),RANK(AB33,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC33=\"x\",AC33,IF(COUNTIF($AC$7:$AC$56,AC33)>1,((RANK(AC33,$AC$7:$AC83,1))+(COUNT($AC$7:$AC83)+1-RANK($AC33,$AC$7:$AC$56,0)-RANK($AC33,$AC$7:$AC$56,1))/2),RANK(AC33,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD33=\"x\",AD33,IF(COUNTIF($AD$7:$AD$56,AD33)>1,((RANK(AD33,$AD$7:$AD83,1))+(COUNT($AD$7:$AD83)+1-RANK($AD33,$AD$7:$AD$56,0)-RANK($AD33,$AD$7:$AD$56,1))/2),RANK(AD33,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,20,60,52,47,40]
[null,null,"Std. Dev",null,{"$f":"SQRT(((E6*(E6+1))*((2*E6)+1))/6)","v":0},{"$f":"SQRT(((F6*(F6+1))*((2*F6)+1))/6)","v":0},{"$f":"SQRT(((G6*(G6+1))*((2*G6)+1))/6)","v":0},null,"Places",{"$f":"IF(E10<10,BR7,IF(E36=\"no\",BO9,IF(E35>0,BN8,BN9)))","v":"Not enough cases"},null,null,null,null,null,null,null,28,{"$f":"'Time 1'!U33","v":"end"},{"$f":"'Time 1'!V33","v":"end"},{"$f":"'Time 1'!W33","v":"end"},{"$f":"'Time 2'!U33","v":"end"},{"$f":"'Time 2'!V33","v":"end"},{"$f":"'Time 2'!W33","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y34<0, AE34-(2*AE34),AE34))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z34<0, AF34-(2*AF34),AF34))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA34<0, AG34-(2*AG34),AG34))","v":"x"},{"$f":"IF(S34=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE34=\"x\",AE34,IF(AH34>0,1,2))))","v":""},{"$f":"IF(T34=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF34=\"x\",AF34,IF(AI34>0,1,2))))","v":""},{"$f":"IF(U34=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG34=\"x\",AG34,IF(AJ34>0,1,2))))","v":""},{"$f":"IF(AB34=\"x\",AB34,IF(COUNTIF($AB$7:$AB$56,AB34)>1,((RANK(AB34,$AB$7:$AB84,1))+(COUNT($AB$7:$AB84)+1-RANK($AB34,$AB$7:$AB$56,0)-RANK($AB34,$AB$7:$AB$56,1))/2),RANK(AB34,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC34=\"x\",AC34,IF(COUNTIF($AC$7:$AC$56,AC34)>1,((RANK(AC34,$AC$7:$AC84,1))+(COUNT($AC$7:$AC84)+1-RANK($AC34,$AC$7:$AC$56,0)-RANK($AC34,$AC$7:$AC$56,1))/2),RANK(AC34,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD34=\"x\",AD34,IF(COUNTIF($AD$7:$AD$56,AD34)>1,((RANK(AD34,$AD$7:$AD84,1))+(COUNT($AD$7:$AD84)+1-RANK($AD34,$AD$7:$AD$56,0)-RANK($AD34,$AD$7:$AD$56,1))/2),RANK(AD34,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,21,67,58,53,46]
[null,null,"z ratio ",null,{"$f":"IF(E11>9,((E14-0.5)/E34), \"XX\")","v":"XX"},{"$f":"IF(F11>9,((F14-0.5)/F34), \"XX\")","v":"XX"},{"$f":"IF(G11>9,((G14-0.5)/G34), \"XX\")","v":"XX"},null,null,{"$f":"IF(E10<10,\"\",IF(E36=\"no\",BO8,IF(E35>0,BP5,BP6)))","v":""},null,null,null,null,null,null,null,29,{"$f":"'Time 1'!U34","v":"end"},{"$f":"'Time 1'!V34","v":"end"},{"$f":"'Time 1'!W34","v":"end"},{"$f":"'Time 2'!U34","v":"end"},{"$f":"'Time 2'!V34","v":"end"},{"$f":"'Time 2'!W34","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y35<0, AE35-(2*AE35),AE35))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z35<0, AF35-(2*AF35),AF35))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA35<0, AG35-(2*AG35),AG35))","v":"x"},{"$f":"IF(S35=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE35=\"x\",AE35,IF(AH35>0,1,2))))","v":""},{"$f":"IF(T35=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF35=\"x\",AF35,IF(AI35>0,1,2))))","v":""},{"$f":"IF(U35=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG35=\"x\",AG35,IF(AJ35>0,1,2))))","v":""},{"$f":"IF(AB35=\"x\",AB35,IF(COUNTIF($AB$7:$AB$56,AB35)>1,((RANK(AB35,$AB$7:$AB85,1))+(COUNT($AB$7:$AB85)+1-RANK($AB35,$AB$7:$AB$56,0)-RANK($AB35,$AB$7:$AB$56,1))/2),RANK(AB35,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC35=\"x\",AC35,IF(COUNTIF($AC$7:$AC$56,AC35)>1,((RANK(AC35,$AC$7:$AC85,1))+(COUNT($AC$7:$AC85)+1-RANK($AC35,$AC$7:$AC$56,0)-RANK($AC35,$AC$7:$AC$56,1))/2),RANK(AC35,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD35=\"x\",AD35,IF(COUNTIF($AD$7:$AD$56,AD35)>1,((RANK(AD35,$AD$7:$AD85,1))+(COUNT($AD$7:$AD85)+1-RANK($AD35,$AD$7:$AD$56,0)-RANK($AD35,$AD$7:$AD$56,1))/2),RANK(AD35,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,22,75,65,60,52]
[null,null,"Significant at ","0.05 level",{"$f":"IF(E11<10,\"XX\",IF(E39=\"yes\",\"\",IF(E38=\"yes\",\"\",IF(E37=\"yes\",\"\",IF(E35<-1.96,\"yes\",IF(E35>1.96,\"yes\",\"no\"))))))","v":"XX"},{"$f":"IF(F11<10,\"XX\",IF(F39=\"yes\",\"\",IF(F38=\"yes\",\"\",IF(F37=\"yes\",\"\",IF(F35<-1.96,\"yes\",IF(F35>1.96,\"yes\",\"no\"))))))","v":"XX"},{"$f":"IF(G11<10,\"XX\",IF(G39=\"yes\",\"\",IF(G38=\"yes\",\"\",IF(G37=\"yes\",\"\",IF(G35<-1.96,\"yes\",IF(G35>1.96,\"yes\",\"no\"))))))","v":"XX"},null,"People",{"$f":"IF(F10<10,BR7,IF(F36=\"no\",BO9,IF(F35>0,BN8,BN9)))","v":"Not enough cases"},null,null,null,null,null,null,null,30,{"$f":"'Time 1'!U35","v":"end"},{"$f":"'Time 1'!V35","v":"end"},{"$f":"'Time 1'!W35","v":"end"},{"$f":"'Time 2'!U35","v":"end"},{"$f":"'Time 2'!V35","v":"end"},{"$f":"'Time 2'!W35","v":"end"},"x","x","x","x","x","x","x","x","x",{"$f":"IF('Time 1'!$AA$5=1,\"\", IF(Y36<0, AE36-(2*AE36),AE36))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(Z36<0, AF36-(2*AF36),AF36))","v":"x"},{"$f":" IF('Time 1'!$AA$5=1,\"\",IF(AA36<0, AG36-(2*AG36),AG36))","v":"x"},{"$f":"IF(S36=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AE36=\"x\",AE36,IF(AH36>0,1,2))))","v":""},{"$f":"IF(T36=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AF36=\"x\",AF36,IF(AI36>0,1,2))))","v":""},{"$f":"IF(U36=\"end\",\"\",IF('Time 1'!$AA$5=1,\"\",IF(AG36=\"x\",AG36,IF(AJ36>0,1,2))))","v":""},{"$f":"IF(AB36=\"x\",AB36,IF(COUNTIF($AB$7:$AB$56,AB36)>1,((RANK(AB36,$AB$7:$AB86,1))+(COUNT($AB$7:$AB86)+1-RANK($AB36,$AB$7:$AB$56,0)-RANK($AB36,$AB$7:$AB$56,1))/2),RANK(AB36,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC36=\"x\",AC36,IF(COUNTIF($AC$7:$AC$56,AC36)>1,((RANK(AC36,$AC$7:$AC86,1))+(COUNT($AC$7:$AC86)+1-RANK($AC36,$AC$7:$AC$56,0)-RANK($AC36,$AC$7:$AC$56,1))/2),RANK(AC36,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD36=\"x\",AD36,IF(COUNTIF($AD$7:$AD$56,AD36)>1,((RANK(AD36,$AD$7:$AD86,1))+(COUNT($AD$7:$AD86)+1-RANK($AD36,$AD$7:$AD$56,0)-RANK($AD36,$AD$7:$AD$56,1))/2),RANK(AD36,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,23,83,73,67,58]
[null,null,"Significant at ","0.02 level",{"$f":"IF(E11<10,\"XX\",IF(E39=\"yes\",\"\",IF(E38=\"yes\",\"\",IF(E35<-2.326,\"yes\",IF(E35>2.326,\"yes\",\"no\")))))","v":"XX"},{"$f":"IF(F11<10,\"XX\",IF(F39=\"yes\",\"\",IF(F38=\"yes\",\"\",IF(F35<-2.326,\"yes\",IF(F35>2.326,\"yes\",\"no\")))))","v":"XX"},{"$f":"IF(G11<10,\"XX\",IF(G39=\"yes\",\"\",IF(G38=\"yes\",\"\",IF(G35<-2.326,\"yes\",IF(G35>2.326,\"yes\",\"no\")))))","v":"XX"},null,null,{"$f":"IF(F10<10,\"\",IF(F36=\"no\",BO8,IF(F35>0,BQ5,BQ6)))","v":""},null,null,null,null,null,null,null,31,{"$f":"'Time 1'!U36","v":"end"},{"$f":"'Time 1'!V36","v":"end"},{"$f":"'Time 1'!W36","v":"end"},{"$f":"'Time 2'!U36","v":"end"},{"$f":"'Time 2'!V36","v":"end"},{"$f":"'Time 2'!W36","v":"end"},{"$f":"IF(S37=\"END\",\"x\",IF(V37-S37=0,\"x\",V37-S37))","v":"x"},{"$f":"IF(T37=\"END\",\"x\",IF(W37-T37=0,\"x\",W37-T37))","v":"x"},{"$f":"IF(U37=\"END\",\"x\",IF(X37-U37=0,\"x\",X37-U37))","v":"x"},{"$f":"IF(Y37=\"x\",Y37,IF(S37>V37,S37-V37,V37-S37))","v":"x"},{"$f":"IF(Z37=\"x\",Z37,IF(T37>W37,T37-W37,W37-T37))","v":"x"},{"$f":"IF(AA37=\"x\",AA37,IF(U37>X37,U37-X37,X37-U37))","v":"x"},null,null,null,null,null,null,null,null,null,{"$f":"IF(AB37=\"x\",AB37,IF(COUNTIF($AB$7:$AB$56,AB37)>1,((RANK(AB37,$AB$7:$AB87,1))+(COUNT($AB$7:$AB87)+1-RANK($AB37,$AB$7:$AB$56,0)-RANK($AB37,$AB$7:$AB$56,1))/2),RANK(AB37,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC37=\"x\",AC37,IF(COUNTIF($AC$7:$AC$56,AC37)>1,((RANK(AC37,$AC$7:$AC87,1))+(COUNT($AC$7:$AC87)+1-RANK($AC37,$AC$7:$AC$56,0)-RANK($AC37,$AC$7:$AC$56,1))/2),RANK(AC37,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD37=\"x\",AD37,IF(COUNTIF($AD$7:$AD$56,AD37)>1,((RANK(AD37,$AD$7:$AD87,1))+(COUNT($AD$7:$AD87)+1-RANK($AD37,$AD$7:$AD$56,0)-RANK($AD37,$AD$7:$AD$56,1))/2),RANK(AD37,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,24,91,81,75,65]
[null,null,"Significant at ","0.01 level",{"$f":"IF(E39=\"yes\",\"\",IF(E11<10,\"XX\",IF(E35<-2.576,\"yes\",IF(E35>2.576,\"yes\",\"no\"))))","v":"XX"},{"$f":"IF(F39=\"yes\",\"\",IF(F11<10,\"XX\",IF(F35<-2.576,\"yes\",IF(F35>2.576,\"yes\",\"no\"))))","v":"XX"},{"$f":"IF(G39=\"yes\",\"\",IF(G11<10,\"XX\",IF(G35<-2.576,\"yes\",IF(G35>2.576,\"yes\",\"no\"))))","v":"XX"},null,"Clockspread",{"$f":"IF(G10<10,BR7,IF(G36=\"no\",BO9,IF(G35>0,BN8,BN9)))","v":"Not enough cases"},null,null,null,null,null,null,null,32,{"$f":"'Time 1'!U37","v":"end"},{"$f":"'Time 1'!V37","v":"end"},{"$f":"'Time 1'!W37","v":"end"},{"$f":"'Time 2'!U37","v":"end"},{"$f":"'Time 2'!V37","v":"end"},{"$f":"'Time 2'!W37","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB38=\"x\",AB38,IF(COUNTIF($AB$7:$AB$56,AB38)>1,((RANK(AB38,$AB$7:$AB88,1))+(COUNT($AB$7:$AB88)+1-RANK($AB38,$AB$7:$AB$56,0)-RANK($AB38,$AB$7:$AB$56,1))/2),RANK(AB38,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC38=\"x\",AC38,IF(COUNTIF($AC$7:$AC$56,AC38)>1,((RANK(AC38,$AC$7:$AC88,1))+(COUNT($AC$7:$AC88)+1-RANK($AC38,$AC$7:$AC$56,0)-RANK($AC38,$AC$7:$AC$56,1))/2),RANK(AC38,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD38=\"x\",AD38,IF(COUNTIF($AD$7:$AD$56,AD38)>1,((RANK(AD38,$AD$7:$AD88,1))+(COUNT($AD$7:$AD88)+1-RANK($AD38,$AD$7:$AD$56,0)-RANK($AD38,$AD$7:$AD$56,1))/2),RANK(AD38,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,25,100,89,83,73]
[null,null,"Signficant at","0.001 level",{"$f":"IF(E11<10,\"XX\",IF(E35<-3.291,\"yes\",IF(E35>3.291,\"yes\",\"no\")))","v":"XX"},{"$f":"IF(F11<10,\"XX\",IF(F35<-3.291,\"yes\",IF(F35>3.291,\"yes\",\"no\")))","v":"XX"},{"$f":"IF(G11<10,\"XX\",IF(G35<-3.291,\"yes\",IF(G35>3.291,\"yes\",\"no\")))","v":"XX"},null,null,{"$f":"IF(G10<10,\"\",IF(G36=\"no\",BO8,IF(G35>0,BR5,BR6)))","v":""},null,null,null,null,null,null,null,33,{"$f":"'Time 1'!U38","v":"end"},{"$f":"'Time 1'!V38","v":"end"},{"$f":"'Time 1'!W38","v":"end"},{"$f":"'Time 2'!U38","v":"end"},{"$f":"'Time 2'!V38","v":"end"},{"$f":"'Time 2'!W38","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB39=\"x\",AB39,IF(COUNTIF($AB$7:$AB$56,AB39)>1,((RANK(AB39,$AB$7:$AB89,1))+(COUNT($AB$7:$AB89)+1-RANK($AB39,$AB$7:$AB$56,0)-RANK($AB39,$AB$7:$AB$56,1))/2),RANK(AB39,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC39=\"x\",AC39,IF(COUNTIF($AC$7:$AC$56,AC39)>1,((RANK(AC39,$AC$7:$AC89,1))+(COUNT($AC$7:$AC89)+1-RANK($AC39,$AC$7:$AC$56,0)-RANK($AC39,$AC$7:$AC$56,1))/2),RANK(AC39,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD39=\"x\",AD39,IF(COUNTIF($AD$7:$AD$56,AD39)>1,((RANK(AD39,$AD$7:$AD89,1))+(COUNT($AD$7:$AD89)+1-RANK($AD39,$AD$7:$AD$56,0)-RANK($AD39,$AD$7:$AD$56,1))/2),RANK(AD39,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,26,110,98,91,81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"'Time 1'!U39","v":"end"},{"$f":"'Time 1'!V39","v":"end"},{"$f":"'Time 1'!W39","v":"end"},{"$f":"'Time 2'!U39","v":"end"},{"$f":"'Time 2'!V39","v":"end"},{"$f":"'Time 2'!W39","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB40=\"x\",AB40,IF(COUNTIF($AB$7:$AB$56,AB40)>1,((RANK(AB40,$AB$7:$AB90,1))+(COUNT($AB$7:$AB90)+1-RANK($AB40,$AB$7:$AB$56,0)-RANK($AB40,$AB$7:$AB$56,1))/2),RANK(AB40,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC40=\"x\",AC40,IF(COUNTIF($AC$7:$AC$56,AC40)>1,((RANK(AC40,$AC$7:$AC90,1))+(COUNT($AC$7:$AC90)+1-RANK($AC40,$AC$7:$AC$56,0)-RANK($AC40,$AC$7:$AC$56,1))/2),RANK(AC40,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD40=\"x\",AD40,IF(COUNTIF($AD$7:$AD$56,AD40)>1,((RANK(AD40,$AD$7:$AD90,1))+(COUNT($AD$7:$AD90)+1-RANK($AD40,$AD$7:$AD$56,0)-RANK($AD40,$AD$7:$AD$56,1))/2),RANK(AD40,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,27,119,107,100,89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"'Time 1'!U40","v":"end"},{"$f":"'Time 1'!V40","v":"end"},{"$f":"'Time 1'!W40","v":"end"},{"$f":"'Time 2'!U40","v":"end"},{"$f":"'Time 2'!V40","v":"end"},{"$f":"'Time 2'!W40","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB41=\"x\",AB41,IF(COUNTIF($AB$7:$AB$56,AB41)>1,((RANK(AB41,$AB$7:$AB91,1))+(COUNT($AB$7:$AB91)+1-RANK($AB41,$AB$7:$AB$56,0)-RANK($AB41,$AB$7:$AB$56,1))/2),RANK(AB41,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC41=\"x\",AC41,IF(COUNTIF($AC$7:$AC$56,AC41)>1,((RANK(AC41,$AC$7:$AC91,1))+(COUNT($AC$7:$AC91)+1-RANK($AC41,$AC$7:$AC$56,0)-RANK($AC41,$AC$7:$AC$56,1))/2),RANK(AC41,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD41=\"x\",AD41,IF(COUNTIF($AD$7:$AD$56,AD41)>1,((RANK(AD41,$AD$7:$AD91,1))+(COUNT($AD$7:$AD91)+1-RANK($AD41,$AD$7:$AD$56,0)-RANK($AD41,$AD$7:$AD$56,1))/2),RANK(AD41,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,28,130,116,110,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"'Time 1'!U41","v":"end"},{"$f":"'Time 1'!V41","v":"end"},{"$f":"'Time 1'!W41","v":"end"},{"$f":"'Time 2'!U41","v":"end"},{"$f":"'Time 2'!V41","v":"end"},{"$f":"'Time 2'!W41","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB42=\"x\",AB42,IF(COUNTIF($AB$7:$AB$56,AB42)>1,((RANK(AB42,$AB$7:$AB92,1))+(COUNT($AB$7:$AB92)+1-RANK($AB42,$AB$7:$AB$56,0)-RANK($AB42,$AB$7:$AB$56,1))/2),RANK(AB42,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC42=\"x\",AC42,IF(COUNTIF($AC$7:$AC$56,AC42)>1,((RANK(AC42,$AC$7:$AC92,1))+(COUNT($AC$7:$AC92)+1-RANK($AC42,$AC$7:$AC$56,0)-RANK($AC42,$AC$7:$AC$56,1))/2),RANK(AC42,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD42=\"x\",AD42,IF(COUNTIF($AD$7:$AD$56,AD42)>1,((RANK(AD42,$AD$7:$AD92,1))+(COUNT($AD$7:$AD92)+1-RANK($AD42,$AD$7:$AD$56,0)-RANK($AD42,$AD$7:$AD$56,1))/2),RANK(AD42,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,29,140,126,119,107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"'Time 1'!U42","v":"end"},{"$f":"'Time 1'!V42","v":"end"},{"$f":"'Time 1'!W42","v":"end"},{"$f":"'Time 2'!U42","v":"end"},{"$f":"'Time 2'!V42","v":"end"},{"$f":"'Time 2'!W42","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB43=\"x\",AB43,IF(COUNTIF($AB$7:$AB$56,AB43)>1,((RANK(AB43,$AB$7:$AB93,1))+(COUNT($AB$7:$AB93)+1-RANK($AB43,$AB$7:$AB$56,0)-RANK($AB43,$AB$7:$AB$56,1))/2),RANK(AB43,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC43=\"x\",AC43,IF(COUNTIF($AC$7:$AC$56,AC43)>1,((RANK(AC43,$AC$7:$AC93,1))+(COUNT($AC$7:$AC93)+1-RANK($AC43,$AC$7:$AC$56,0)-RANK($AC43,$AC$7:$AC$56,1))/2),RANK(AC43,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD43=\"x\",AD43,IF(COUNTIF($AD$7:$AD$56,AD43)>1,((RANK(AD43,$AD$7:$AD93,1))+(COUNT($AD$7:$AD93)+1-RANK($AD43,$AD$7:$AD$56,0)-RANK($AD43,$AD$7:$AD$56,1))/2),RANK(AD43,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,30,151,137,130,116]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"'Time 1'!U43","v":"end"},{"$f":"'Time 1'!V43","v":"end"},{"$f":"'Time 1'!W43","v":"end"},{"$f":"'Time 2'!U43","v":"end"},{"$f":"'Time 2'!V43","v":"end"},{"$f":"'Time 2'!W43","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB44=\"x\",AB44,IF(COUNTIF($AB$7:$AB$56,AB44)>1,((RANK(AB44,$AB$7:$AB94,1))+(COUNT($AB$7:$AB94)+1-RANK($AB44,$AB$7:$AB$56,0)-RANK($AB44,$AB$7:$AB$56,1))/2),RANK(AB44,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC44=\"x\",AC44,IF(COUNTIF($AC$7:$AC$56,AC44)>1,((RANK(AC44,$AC$7:$AC94,1))+(COUNT($AC$7:$AC94)+1-RANK($AC44,$AC$7:$AC$56,0)-RANK($AC44,$AC$7:$AC$56,1))/2),RANK(AC44,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD44=\"x\",AD44,IF(COUNTIF($AD$7:$AD$56,AD44)>1,((RANK(AD44,$AD$7:$AD94,1))+(COUNT($AD$7:$AD94)+1-RANK($AD44,$AD$7:$AD$56,0)-RANK($AD44,$AD$7:$AD$56,1))/2),RANK(AD44,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,31,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"'Time 1'!U44","v":"end"},{"$f":"'Time 1'!V44","v":"end"},{"$f":"'Time 1'!W44","v":"end"},{"$f":"'Time 2'!U44","v":"end"},{"$f":"'Time 2'!V44","v":"end"},{"$f":"'Time 2'!W44","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB45=\"x\",AB45,IF(COUNTIF($AB$7:$AB$56,AB45)>1,((RANK(AB45,$AB$7:$AB95,1))+(COUNT($AB$7:$AB95)+1-RANK($AB45,$AB$7:$AB$56,0)-RANK($AB45,$AB$7:$AB$56,1))/2),RANK(AB45,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC45=\"x\",AC45,IF(COUNTIF($AC$7:$AC$56,AC45)>1,((RANK(AC45,$AC$7:$AC95,1))+(COUNT($AC$7:$AC95)+1-RANK($AC45,$AC$7:$AC$56,0)-RANK($AC45,$AC$7:$AC$56,1))/2),RANK(AC45,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD45=\"x\",AD45,IF(COUNTIF($AD$7:$AD$56,AD45)>1,((RANK(AD45,$AD$7:$AD95,1))+(COUNT($AD$7:$AD95)+1-RANK($AD45,$AD$7:$AD$56,0)-RANK($AD45,$AD$7:$AD$56,1))/2),RANK(AD45,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,32,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"'Time 1'!U45","v":"end"},{"$f":"'Time 1'!V45","v":"end"},{"$f":"'Time 1'!W45","v":"end"},{"$f":"'Time 2'!U45","v":"end"},{"$f":"'Time 2'!V45","v":"end"},{"$f":"'Time 2'!W45","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB46=\"x\",AB46,IF(COUNTIF($AB$7:$AB$56,AB46)>1,((RANK(AB46,$AB$7:$AB96,1))+(COUNT($AB$7:$AB96)+1-RANK($AB46,$AB$7:$AB$56,0)-RANK($AB46,$AB$7:$AB$56,1))/2),RANK(AB46,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC46=\"x\",AC46,IF(COUNTIF($AC$7:$AC$56,AC46)>1,((RANK(AC46,$AC$7:$AC96,1))+(COUNT($AC$7:$AC96)+1-RANK($AC46,$AC$7:$AC$56,0)-RANK($AC46,$AC$7:$AC$56,1))/2),RANK(AC46,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD46=\"x\",AD46,IF(COUNTIF($AD$7:$AD$56,AD46)>1,((RANK(AD46,$AD$7:$AD96,1))+(COUNT($AD$7:$AD96)+1-RANK($AD46,$AD$7:$AD$56,0)-RANK($AD46,$AD$7:$AD$56,1))/2),RANK(AD46,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,33,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"'Time 1'!U46","v":"end"},{"$f":"'Time 1'!V46","v":"end"},{"$f":"'Time 1'!W46","v":"end"},{"$f":"'Time 2'!U46","v":"end"},{"$f":"'Time 2'!V46","v":"end"},{"$f":"'Time 2'!W46","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB47=\"x\",AB47,IF(COUNTIF($AB$7:$AB$56,AB47)>1,((RANK(AB47,$AB$7:$AB97,1))+(COUNT($AB$7:$AB97)+1-RANK($AB47,$AB$7:$AB$56,0)-RANK($AB47,$AB$7:$AB$56,1))/2),RANK(AB47,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC47=\"x\",AC47,IF(COUNTIF($AC$7:$AC$56,AC47)>1,((RANK(AC47,$AC$7:$AC97,1))+(COUNT($AC$7:$AC97)+1-RANK($AC47,$AC$7:$AC$56,0)-RANK($AC47,$AC$7:$AC$56,1))/2),RANK(AC47,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD47=\"x\",AD47,IF(COUNTIF($AD$7:$AD$56,AD47)>1,((RANK(AD47,$AD$7:$AD97,1))+(COUNT($AD$7:$AD97)+1-RANK($AD47,$AD$7:$AD$56,0)-RANK($AD47,$AD$7:$AD$56,1))/2),RANK(AD47,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,34,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"'Time 1'!U47","v":"end"},{"$f":"'Time 1'!V47","v":"end"},{"$f":"'Time 1'!W47","v":"end"},{"$f":"'Time 2'!U47","v":"end"},{"$f":"'Time 2'!V47","v":"end"},{"$f":"'Time 2'!W47","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB48=\"x\",AB48,IF(COUNTIF($AB$7:$AB$56,AB48)>1,((RANK(AB48,$AB$7:$AB98,1))+(COUNT($AB$7:$AB98)+1-RANK($AB48,$AB$7:$AB$56,0)-RANK($AB48,$AB$7:$AB$56,1))/2),RANK(AB48,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC48=\"x\",AC48,IF(COUNTIF($AC$7:$AC$56,AC48)>1,((RANK(AC48,$AC$7:$AC98,1))+(COUNT($AC$7:$AC98)+1-RANK($AC48,$AC$7:$AC$56,0)-RANK($AC48,$AC$7:$AC$56,1))/2),RANK(AC48,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD48=\"x\",AD48,IF(COUNTIF($AD$7:$AD$56,AD48)>1,((RANK(AD48,$AD$7:$AD98,1))+(COUNT($AD$7:$AD98)+1-RANK($AD48,$AD$7:$AD$56,0)-RANK($AD48,$AD$7:$AD$56,1))/2),RANK(AD48,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,35,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"'Time 1'!U48","v":"end"},{"$f":"'Time 1'!V48","v":"end"},{"$f":"'Time 1'!W48","v":"end"},{"$f":"'Time 2'!U48","v":"end"},{"$f":"'Time 2'!V48","v":"end"},{"$f":"'Time 2'!W48","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB49=\"x\",AB49,IF(COUNTIF($AB$7:$AB$56,AB49)>1,((RANK(AB49,$AB$7:$AB99,1))+(COUNT($AB$7:$AB99)+1-RANK($AB49,$AB$7:$AB$56,0)-RANK($AB49,$AB$7:$AB$56,1))/2),RANK(AB49,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC49=\"x\",AC49,IF(COUNTIF($AC$7:$AC$56,AC49)>1,((RANK(AC49,$AC$7:$AC99,1))+(COUNT($AC$7:$AC99)+1-RANK($AC49,$AC$7:$AC$56,0)-RANK($AC49,$AC$7:$AC$56,1))/2),RANK(AC49,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD49=\"x\",AD49,IF(COUNTIF($AD$7:$AD$56,AD49)>1,((RANK(AD49,$AD$7:$AD99,1))+(COUNT($AD$7:$AD99)+1-RANK($AD49,$AD$7:$AD$56,0)-RANK($AD49,$AD$7:$AD$56,1))/2),RANK(AD49,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,36,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"'Time 1'!U49","v":"end"},{"$f":"'Time 1'!V49","v":"end"},{"$f":"'Time 1'!W49","v":"end"},{"$f":"'Time 2'!U49","v":"end"},{"$f":"'Time 2'!V49","v":"end"},{"$f":"'Time 2'!W49","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB50=\"x\",AB50,IF(COUNTIF($AB$7:$AB$56,AB50)>1,((RANK(AB50,$AB$7:$AB100,1))+(COUNT($AB$7:$AB100)+1-RANK($AB50,$AB$7:$AB$56,0)-RANK($AB50,$AB$7:$AB$56,1))/2),RANK(AB50,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC50=\"x\",AC50,IF(COUNTIF($AC$7:$AC$56,AC50)>1,((RANK(AC50,$AC$7:$AC100,1))+(COUNT($AC$7:$AC100)+1-RANK($AC50,$AC$7:$AC$56,0)-RANK($AC50,$AC$7:$AC$56,1))/2),RANK(AC50,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD50=\"x\",AD50,IF(COUNTIF($AD$7:$AD$56,AD50)>1,((RANK(AD50,$AD$7:$AD100,1))+(COUNT($AD$7:$AD100)+1-RANK($AD50,$AD$7:$AD$56,0)-RANK($AD50,$AD$7:$AD$56,1))/2),RANK(AD50,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,37,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"'Time 1'!U50","v":"end"},{"$f":"'Time 1'!V50","v":"end"},{"$f":"'Time 1'!W50","v":"end"},{"$f":"'Time 2'!U50","v":"end"},{"$f":"'Time 2'!V50","v":"end"},{"$f":"'Time 2'!W50","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB51=\"x\",AB51,IF(COUNTIF($AB$7:$AB$56,AB51)>1,((RANK(AB51,$AB$7:$AB101,1))+(COUNT($AB$7:$AB101)+1-RANK($AB51,$AB$7:$AB$56,0)-RANK($AB51,$AB$7:$AB$56,1))/2),RANK(AB51,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC51=\"x\",AC51,IF(COUNTIF($AC$7:$AC$56,AC51)>1,((RANK(AC51,$AC$7:$AC101,1))+(COUNT($AC$7:$AC101)+1-RANK($AC51,$AC$7:$AC$56,0)-RANK($AC51,$AC$7:$AC$56,1))/2),RANK(AC51,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD51=\"x\",AD51,IF(COUNTIF($AD$7:$AD$56,AD51)>1,((RANK(AD51,$AD$7:$AD101,1))+(COUNT($AD$7:$AD101)+1-RANK($AD51,$AD$7:$AD$56,0)-RANK($AD51,$AD$7:$AD$56,1))/2),RANK(AD51,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,38,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"'Time 1'!U51","v":"end"},{"$f":"'Time 1'!V51","v":"end"},{"$f":"'Time 1'!W51","v":"end"},{"$f":"'Time 2'!U51","v":"end"},{"$f":"'Time 2'!V51","v":"end"},{"$f":"'Time 2'!W51","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB52=\"x\",AB52,IF(COUNTIF($AB$7:$AB$56,AB52)>1,((RANK(AB52,$AB$7:$AB102,1))+(COUNT($AB$7:$AB102)+1-RANK($AB52,$AB$7:$AB$56,0)-RANK($AB52,$AB$7:$AB$56,1))/2),RANK(AB52,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC52=\"x\",AC52,IF(COUNTIF($AC$7:$AC$56,AC52)>1,((RANK(AC52,$AC$7:$AC102,1))+(COUNT($AC$7:$AC102)+1-RANK($AC52,$AC$7:$AC$56,0)-RANK($AC52,$AC$7:$AC$56,1))/2),RANK(AC52,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD52=\"x\",AD52,IF(COUNTIF($AD$7:$AD$56,AD52)>1,((RANK(AD52,$AD$7:$AD102,1))+(COUNT($AD$7:$AD102)+1-RANK($AD52,$AD$7:$AD$56,0)-RANK($AD52,$AD$7:$AD$56,1))/2),RANK(AD52,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,39,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"'Time 1'!U52","v":"end"},{"$f":"'Time 1'!V52","v":"end"},{"$f":"'Time 1'!W52","v":"end"},{"$f":"'Time 2'!U52","v":"end"},{"$f":"'Time 2'!V52","v":"end"},{"$f":"'Time 2'!W52","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB53=\"x\",AB53,IF(COUNTIF($AB$7:$AB$56,AB53)>1,((RANK(AB53,$AB$7:$AB103,1))+(COUNT($AB$7:$AB103)+1-RANK($AB53,$AB$7:$AB$56,0)-RANK($AB53,$AB$7:$AB$56,1))/2),RANK(AB53,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC53=\"x\",AC53,IF(COUNTIF($AC$7:$AC$56,AC53)>1,((RANK(AC53,$AC$7:$AC103,1))+(COUNT($AC$7:$AC103)+1-RANK($AC53,$AC$7:$AC$56,0)-RANK($AC53,$AC$7:$AC$56,1))/2),RANK(AC53,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD53=\"x\",AD53,IF(COUNTIF($AD$7:$AD$56,AD53)>1,((RANK(AD53,$AD$7:$AD103,1))+(COUNT($AD$7:$AD103)+1-RANK($AD53,$AD$7:$AD$56,0)-RANK($AD53,$AD$7:$AD$56,1))/2),RANK(AD53,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,40,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"'Time 1'!U53","v":"end"},{"$f":"'Time 1'!V53","v":"end"},{"$f":"'Time 1'!W53","v":"end"},{"$f":"'Time 2'!U53","v":"end"},{"$f":"'Time 2'!V53","v":"end"},{"$f":"'Time 2'!W53","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB54=\"x\",AB54,IF(COUNTIF($AB$7:$AB$56,AB54)>1,((RANK(AB54,$AB$7:$AB104,1))+(COUNT($AB$7:$AB104)+1-RANK($AB54,$AB$7:$AB$56,0)-RANK($AB54,$AB$7:$AB$56,1))/2),RANK(AB54,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC54=\"x\",AC54,IF(COUNTIF($AC$7:$AC$56,AC54)>1,((RANK(AC54,$AC$7:$AC104,1))+(COUNT($AC$7:$AC104)+1-RANK($AC54,$AC$7:$AC$56,0)-RANK($AC54,$AC$7:$AC$56,1))/2),RANK(AC54,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD54=\"x\",AD54,IF(COUNTIF($AD$7:$AD$56,AD54)>1,((RANK(AD54,$AD$7:$AD104,1))+(COUNT($AD$7:$AD104)+1-RANK($AD54,$AD$7:$AD$56,0)-RANK($AD54,$AD$7:$AD$56,1))/2),RANK(AD54,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,41,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"'Time 1'!U54","v":"end"},{"$f":"'Time 1'!V54","v":"end"},{"$f":"'Time 1'!W54","v":"end"},{"$f":"'Time 2'!U54","v":"end"},{"$f":"'Time 2'!V54","v":"end"},{"$f":"'Time 2'!W54","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB55=\"x\",AB55,IF(COUNTIF($AB$7:$AB$56,AB55)>1,((RANK(AB55,$AB$7:$AB105,1))+(COUNT($AB$7:$AB105)+1-RANK($AB55,$AB$7:$AB$56,0)-RANK($AB55,$AB$7:$AB$56,1))/2),RANK(AB55,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC55=\"x\",AC55,IF(COUNTIF($AC$7:$AC$56,AC55)>1,((RANK(AC55,$AC$7:$AC105,1))+(COUNT($AC$7:$AC105)+1-RANK($AC55,$AC$7:$AC$56,0)-RANK($AC55,$AC$7:$AC$56,1))/2),RANK(AC55,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD55=\"x\",AD55,IF(COUNTIF($AD$7:$AD$56,AD55)>1,((RANK(AD55,$AD$7:$AD105,1))+(COUNT($AD$7:$AD105)+1-RANK($AD55,$AD$7:$AD$56,0)-RANK($AD55,$AD$7:$AD$56,1))/2),RANK(AD55,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,42,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"'Time 1'!U55","v":"end"},{"$f":"'Time 1'!V55","v":"end"},{"$f":"'Time 1'!W55","v":"end"},{"$f":"'Time 2'!U55","v":"end"},{"$f":"'Time 2'!V55","v":"end"},{"$f":"'Time 2'!W55","v":"end"},"x","x","x","x","x","x",null,null,null,null,null,null,null,null,null,{"$f":"IF(AB56=\"x\",AB56,IF(COUNTIF($AB$7:$AB$56,AB56)>1,((RANK(AB56,$AB$7:$AB106,1))+(COUNT($AB$7:$AB106)+1-RANK($AB56,$AB$7:$AB$56,0)-RANK($AB56,$AB$7:$AB$56,1))/2),RANK(AB56,$AB$7:$AB$56,1)))","v":"x"},{"$f":"IF(AC56=\"x\",AC56,IF(COUNTIF($AC$7:$AC$56,AC56)>1,((RANK(AC56,$AC$7:$AC106,1))+(COUNT($AC$7:$AC106)+1-RANK($AC56,$AC$7:$AC$56,0)-RANK($AC56,$AC$7:$AC$56,1))/2),RANK(AC56,$AC$7:$AC$56,1)))","v":"x"},{"$f":"IF(AD56=\"x\",AD56,IF(COUNTIF($AD$7:$AD$56,AD56)>1,((RANK(AD56,$AD$7:$AD106,1))+(COUNT($AD$7:$AD106)+1-RANK($AD56,$AD$7:$AD$56,0)-RANK($AD56,$AD$7:$AD$56,1))/2),RANK(AD56,$AD$7:$AD$56,1)))","v":"x"},"x","x","x","","","",null,null,null,null,43,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 cases or less",null,"MEAN",{"$f":"AVERAGE(S7:S36)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(Y7:Y36)/(COUNT(S7:S36))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Z7:Z36)/(COUNT(T7:T36))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA7:AA36)/(COUNT(U7:U36))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Std Dev",{"$f":"STDEV(S7:S36)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Mean differences",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"more than 30 cases",null,"MEAN",{"$f":"AVERAGE(S7:S56)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(Y7:Y56)/(COUNT(S7:S56))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Z7:Z56)/(COUNT(T7:T56))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AA7:AA56)/(COUNT(U7:U56))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Std Dev",{"$f":"STDEV(S7:S56)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Mean differences",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 cases or less",null,null,null,null,null,null,null,null,"more than 30 cases",null,null,null,null,null,null,null,null,null,49,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W =",null,null,null,null,null,null,null,null,{"$f":"SUM(AH7:AH36)","v":0},{"$f":"SUM(AI7:AI36)","v":0},{"$f":"SUM(AJ7:AJ36)","v":0},null,null,null,null,null,null,{"$f":"SUM(AQ7:AQ56)","v":0},{"$f":"SUM(AR7:AR56)","v":0},{"$f":"SUM(AS7:AS56)","v":0},null,null,null,null,null,null,null,50,"NA","NA","NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W +ve =",null,null,null,null,null,null,null,null,{"$f":"SUMIF(AK7:AK36,1,AH7:AH36)","v":0},{"$f":"SUMIF(AL7:AL36,1,AI7:AI36)","v":0},{"$f":"SUMIF(AM7:AM36,1,AJ7:AJ36)","v":0},null,null,null,null,null,null,{"$f":"SUMIF(AT7:AT56,1,AQ7:AQ56)","v":0},{"$f":"SUMIF(AU7:AU56,1,AR7:AR56)","v":0},{"$f":"SUMIF(AV7:AV56,1,AS7:AS56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W -ve =",null,null,null,null,null,null,null,null,{"$f":"SUMIF(AK7:AK36,2,AH7:AH36)","v":0},{"$f":"SUMIF(AL7:AL36,2,AI7:AI36)","v":0},{"$f":"SUMIF(AM7:AM36,2,AJ7:AJ36)","v":0},null,null,null,null,null,null,{"$f":"SUMIF(AT7:AT56,2,AQ7:AQ56)","v":0},{"$f":"SUMIF(AU7:AU56,2,AR7:AR56)","v":0},{"$f":"SUMIF(AV7:AV56,2,AS7:AS56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count pairs (W)",null,null,null,null,null,null,null,null,{"$f":"COUNT(AH7:AH36)","v":0},{"$f":"COUNT(AI7:AI36)","v":0},{"$f":"COUNT(AJ7:AJ36)","v":0},null,null,null,null,null,null,{"$f":"COUNT(AQ7:AQ56)","v":0},{"$f":"COUNT(AR7:AR56)","v":0},{"$f":"COUNT(AS7:AS56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count pairs pos",null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AK7:AK36,1)","v":0},{"$f":"COUNTIF(AL7:AL36,1)","v":0},{"$f":"COUNTIF(AM7:AM36,1)","v":0},null,null,null,null,null,null,{"$f":"COUNTIF(AT7:AT56,1)","v":0},{"$f":"COUNTIF(AU7:AU56,1)","v":0},{"$f":"COUNTIF(AV7:AV56,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count pairs neg",null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AK7:AK36,2)","v":0},{"$f":"COUNTIF(AL7:AL36,2)","v":0},{"$f":"COUNTIF(AM7:AM36,2)","v":0},null,null,null,null,null,null,{"$f":"COUNTIF(AT7:AT56,2)","v":0},{"$f":"COUNTIF(AU7:AU56,2)","v":0},{"$f":"COUNTIF(AV7:AV56,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count pairs no diff",null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AK7:AK36,\"x\")","v":0},{"$f":"COUNTIF(AL7:AL36,\"x\")","v":0},{"$f":"COUNTIF(AM7:AM36,\"x\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF(AT7:AT56,\"x\")","v":0},{"$f":"COUNTIF(AU7:AU56,\"x\")","v":0},{"$f":"COUNTIF(AV7:AV56,\"x\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Places","People","Clock spread",null,null,null,null,null,null,"Places","People","Clock spread"]

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