{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["READ ME","Raw Data","Calculations","Results"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"READ ME","index":0,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["This workbook contains a macro that analyses the output data file of each participant in Experiment 1"]
["This macro is for participants in the left-prime and right-prime conditions - a separate macro-enabled workbook has been created and uploaded for those in the control condition"]
["Different macros had to be created because the output file for the control condition because the input file was different for this condition (see below for an explanation)"]
["If you get a warning message upon opening, click 'enable content'/'enable editing'/'enable macros'"]
[]
[]
["INSTRUCTIONS TO RUN THE MACRO:"]
["1. Only enter data into the 'Raw data tab', do not enter anything in the other tabs. Make sure the 'raw data' sheet does not contain any data before you begin the following steps"]
["2. Copy a participants data in their data file"]
["3. Put your cursor in cell A1 in the 'Raw data' spreadsheet. Click paste (ctrl+v)"]
["4. Click the 'developer' tab > 'Macros'"]
["5. Click 'Datatransfer' > 'run'"]
["6. Open the results tab."]
["7. The line in the results tab contains the relevant data for that participant, on all of the relevant variables. This line was copied directly into the dataset of all the participants, in the spreadsheet 'Experiment 1 for upload'"]
["8. Do not paste over any data in the 'Raw data' spreadsheet. This sheet must be blank when you paste in the participants' data"]
[]
[]
["Note on timers and multiple macros"]
["Timers in PsychoPy are not precise"]
["For the left and right prime conditions this was not a concern because the scripts were identical, with only the name of the prime ('LHS' for left and 'RHS' for right) changed in the column of the input spreadsheet which the PsychoPy script took in"]
["This could however, have been an issue for comparing the prime conditions with the control conditions, if no stimulus at all was called upon by the script for the prime duration."]
["To ensure that the timers were 100% consistent across the conditions, the script used in the control condition was a copy of the right-prime condition, but with the text colour of the prime set to white, the background colour. "]
["An invisible prime was therefore presented during the control condition, to ensure the timers were consistent."]
["The output files between the conditions are slightly different because the input file in the control condition had one extra column (it had both LHS and RHS prime fields, whereas the left and right-prime conditions had one or the other)"]

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

{"sheet":"Calculations","index":2,"n_rows":54,"n_cols":50,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,45,0,46]]}
["Type","Problem","Problem URN","Answer","Response","T/F","RT",null,"Nonconducive_mean","Lower_Nonconinterval","Bazvalue","20% of N-con Mean Final","20% off N-con Mean Rolling","Below 99.9% CI + 20%","Meets All Criteria for Detection","Just Correct RT's","Correct","RT's","Con Trial N","Bazzinga",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,"Only Correct RTs"]
["Nonconducive","26 + 57 - 34","1N102",49,null,{"$f":"IF(D2=E2, 1, \"\")","v":""},null,null,null,null,null,{"$f":"0.79*I46","v":0}]
["Conducive","13 + 49 - 45","3C101",17,null,{"$f":"IF(D3=E3, 1, \"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(N3=TRUE, 1, 0)","v":0},{"$f":"IF(Q3=1, R3, \"\")","v":""},{"$f":"F3","v":""},{"$f":"G3","v":0},1,{"$f":"O3","v":0},{"$f":"AND(T3>0, T4>0,T5>0)","v":false},{"$f":"IF(U3=TRUE, R3, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V3:AP3,SMALL(IF(V3:AP3<>\"\",COLUMN(V3:AP3)-COLUMN(V3)+1),1)),\"X\")","v":"X"},{"$f":"IF(AR3=\"X\", R3, \"\")","v":0},{"$f":"IF(Q3=1, AR3, \"\")","v":""},{"$f":"IF(Q3=1, AS3, \"\")","v":""}]
["Nonconducive","36 + 27 - 44","3N104",19,null,{"$f":"IF(D4=E4, 1, \"\")","v":""},null,null,null,null,null,null,{"$f":"0.79*I4","v":0},null,{"$f":"IF(N4=TRUE, 1, 0)","v":0},{"$f":"IF(Q4=1, R4, \"\")","v":""},{"$f":"F5","v":""},{"$f":"G5","v":0},2,{"$f":"O5","v":0},{"$f":"AND(T4>0, T5>0,T6>0)","v":false},{"$f":"IF($V$3=$R$3, R4, \"\")","v":""},{"$f":"IF(U4=TRUE, R4, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V4:AP4,SMALL(IF(V4:AP4<>\"\",COLUMN(V4:AP4)-COLUMN(V4)+1),1)),\"X\")","v":"X"},{"$f":"IF(AR4=\"X\", R4, \"\")","v":0},"",""]
["Conducive","42 + 39 - 33","1C101",48,null,"",null,null,null,null,null,null,null,{"$f":"AND(H5<$L$2, H5<M4)","v":false},0,"",{"$f":"F6","v":""},{"$f":"G6","v":0},3,{"$f":"O6","v":0},false,{"$f":"IF($V$3=$R$3, R5, \"\")","v":""},{"$f":"IF($W$4=$R$4, R5, \"\")","v":""},{"$f":"IF(U5=TRUE, R5, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V5:AP5,SMALL(IF(V5:AP5<>\"\",COLUMN(V5:AP5)-COLUMN(V5)+1),1)),\"X\")","v":"X"},0,"",""]
["Conducive","35 + 28 - 26","2C101",37,null,"",null,null,null,null,null,null,null,{"$f":"AND(H6<$L$2, H6<M4, H6<J6)","v":false},0,"",{"$f":"F9","v":""},{"$f":"G9","v":0},4,{"$f":"O9","v":0},false,{"$f":"IF($V$3=$R$3, R6, \"\")","v":""},"",{"$f":"IF($X$5=$R$5, R6, \"\")","v":""},{"$f":"IF(U6=TRUE, R6, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V6:AP6,SMALL(IF(V6:AP6<>\"\",COLUMN(V6:AP6)-COLUMN(V6)+1),1)),\"X\")","v":"X"},0,"",""]
["Nonconducive","45 + 16 - 23","2N105",38,null,"",null,null,null,null,null,null,{"$f":"0.79*I7","v":0},null,0,"",{"$f":"F10","v":""},{"$f":"G10","v":0},5,{"$f":"O10","v":0},false,"","",{"$f":"IF($X$5=$R$5, R7, \"\")","v":""},{"$f":"IF($Y$6=$R$6, R7, \"\")","v":""},{"$f":"IF(U7=TRUE, R7, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V7:AP7,SMALL(IF(V7:AP7<>\"\",COLUMN(V7:AP7)-COLUMN(V7)+1),1)),\"X\")","v":"X"},0,"",""]
["Nonconducive","55 + 28 - 37","1N106",46,null,"",null,null,null,null,null,null,{"$f":"0.79*I8","v":0},null,0,"",{"$f":"F13","v":""},{"$f":"G13","v":0},6,{"$f":"O13","v":0},false,"","","",{"$f":"IF($Y$6=$R$6, R8, \"\")","v":""},{"$f":"IF($Z$7=$R$7, R8, \"\")","v":""},{"$f":"IF(U8=TRUE, R8, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V8:AP8,SMALL(IF(V8:AP8<>\"\",COLUMN(V8:AP8)-COLUMN(V8)+1),1)),\"X\")","v":"X"},0,"",""]
["Conducive","15 + 49 - 46","3C102",18,null,"",null,null,null,null,null,null,null,{"$f":"AND(H9<$L$2, H9<M8, H9<J9)","v":false},0,"",{"$f":"F15","v":""},{"$f":"G15","v":0},7,{"$f":"O15","v":0},false,"","","","",{"$f":"IF($Z$7=$R$7, R9, \"\")","v":""},{"$f":"IF($AA$8=$R$8, R9, \"\")","v":""},{"$f":"IF(U9=TRUE, R9, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V9:AP9,SMALL(IF(V9:AP9<>\"\",COLUMN(V9:AP9)-COLUMN(V9)+1),1)),\"X\")","v":"X"},0,"",""]
["Conducive","45 + 38 - 34","1C102",49,null,"",null,null,null,null,null,null,null,{"$f":"AND(H10<$L$2, H10<M8, H10<J10)","v":false},0,"",{"$f":"F16","v":""},{"$f":"G16","v":0},8,{"$f":"O16","v":0},false,"",{"$f":"IF($W$4=$R$4, R10, \"\")","v":""},"","","",{"$f":"IF($AA$8=$R$8, R10, \"\")","v":""},{"$f":"IF($AB$9=$R$9, R10, \"\")","v":""},{"$f":"IF(U10=TRUE, R10, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V10:AP10,SMALL(IF(V10:AP10<>\"\",COLUMN(V10:AP10)-COLUMN(V10)+1),1)),\"X\")","v":"X"},0,"",""]
["Nonconducive","34 + 27 - 43","3N105",18,null,"",null,null,null,null,null,null,{"$f":"0.79*I11","v":0},null,0,"",{"$f":"F18","v":""},{"$f":"G18","v":0},9,{"$f":"O18","v":0},false,"",{"$f":"IF($W$4=$R$4, R11, \"\")","v":""},"","","","",{"$f":"IF($AB$9=$R$9, R11, \"\")","v":""},{"$f":"IF($AC$10=$R$10, R11, \"\")","v":""},{"$f":"IF(U11=TRUE, R11, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V11:AP11,SMALL(IF(V11:AP11<>\"\",COLUMN(V11:AP11)-COLUMN(V11)+1),1)),\"X\")","v":"X"},0,"",""]
["Nonconducive","14 + 49 - 26","2N101",37,null,"",null,null,null,null,null,null,{"$f":"0.79*I12","v":0},null,0,"",{"$f":"F21","v":""},{"$f":"G21","v":0},10,{"$f":"O21","v":0},false,"","","","","","","",{"$f":"IF($AC$10=$R$10, R12, \"\")","v":""},{"$f":"IF($AD$11=$R$11, R12, \"\")","v":""},{"$f":"IF(U12=TRUE, R12, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V12:AP12,SMALL(IF(V12:AP12<>\"\",COLUMN(V12:AP12)-COLUMN(V12)+1),1)),\"X\")","v":"X"},0,"",""]
["Conducive","34 + 28 - 23","2C102",39,null,"",null,null,null,null,null,null,null,{"$f":"AND(H13<$L$2, H13<M12, H13<J13)","v":false},0,"",{"$f":"F23","v":""},{"$f":"G23","v":0},11,{"$f":"O23","v":0},false,"","","","","","","","",{"$f":"IF($AD$11=$R$11, R13, \"\")","v":""},{"$f":"IF($AE$12=$R$12, R13, \"\")","v":""},{"$f":"IF(U13=TRUE, R13, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V13:AP13,SMALL(IF(V13:AP13<>\"\",COLUMN(V13:AP13)-COLUMN(V13)+1),1)),\"X\")","v":"X"},0,"",""]
["Nonconducive","29 + 55 - 36","1N107",48,null,"",null,null,null,null,null,null,{"$f":"0.79*I14","v":0},null,0,"",{"$f":"F25","v":""},{"$f":"G25","v":0},12,{"$f":"O25","v":0},false,"","","","","","","","","",{"$f":"IF($AE$12=$R$12, R14, \"\")","v":""},{"$f":"IF($AF$13=$R$13, R14, \"\")","v":""},{"$f":"IF(U14=TRUE, R14, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V14:AP14,SMALL(IF(V14:AP14<>\"\",COLUMN(V14:AP14)-COLUMN(V14)+1),1)),\"X\")","v":"X"},0,"",""]
["Conducive","14 + 49 - 47","3C103",16,null,"",null,null,null,null,null,null,null,{"$f":"AND(H15<$L$2, H15<M14, H15<J15)","v":false},0,"",{"$f":"F27","v":""},{"$f":"G27","v":0},13,{"$f":"O27","v":0},false,"","","","","","","","","","",{"$f":"IF($AF$13=$R$13, R15, \"\")","v":""},{"$f":"IF($AG$14=$R$14, R15, \"\")","v":""},{"$f":"IF(U15=TRUE, R15, \"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V15:AP15,SMALL(IF(V15:AP15<>\"\",COLUMN(V15:AP15)-COLUMN(V15)+1),1)),\"X\")","v":"X"},0,"",""]
["Conducive","43 + 38 - 35","1C103",46,null,"",null,null,null,null,null,null,null,{"$f":"AND(H16<$L$2, H16<M14, H16<J16)","v":false},0,"",{"$f":"F29","v":""},{"$f":"G29","v":0},14,{"$f":"O29","v":0},false,"","","","","","","","","","","",{"$f":"IF($AG$14=$R$14, R16, \"\")","v":""},{"$f":"IF($AH$15=$R$15, R16, \"\")","v":""},{"$f":"IF(U16=TRUE, R16, \"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V16:AP16,SMALL(IF(V16:AP16<>\"\",COLUMN(V16:AP16)-COLUMN(V16)+1),1)),\"X\")","v":"X"},0,"","","Count","Just Correct","All"]
["Nonconducive","35 + 28 - 47","3N103",16,null,"",null,null,null,null,null,null,{"$f":"0.79*I17","v":0},null,0,"",{"$f":"F30","v":""},{"$f":"G30","v":0},15,{"$f":"O30","v":0},false,"","","","","","","","","","","","",{"$f":"IF($AH$15=$R$15, R17, \"\")","v":""},{"$f":"IF($AI$16=$R$16, R17, \"\")","v":""},{"$f":"IF(U17=TRUE, R17, \"\")","v":""},null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V17:AP17,SMALL(IF(V17:AP17<>\"\",COLUMN(V17:AP17)-COLUMN(V17)+1),1)),\"X\")","v":"X"},0,"","","N-con T",{"$f":"COUNT(Q27:Q49)","v":0}]
["Conducive","33 + 29 - 26","2C103",36,null,"",null,null,null,null,null,null,null,{"$f":"AND(H18<$L$2, H18<M17, H18<J18)","v":false},0,"",{"$f":"F32","v":""},{"$f":"G32","v":0},16,{"$f":"O32","v":0},false,"","","","","","","","","","","","","",{"$f":"IF($AI$16=$R$16, R18, \"\")","v":""},{"$f":"IF($AJ$17=$R$17, R18, \"\")","v":""},{"$f":"IF(U18=TRUE, R18, \"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(V18:AP18,SMALL(IF(V18:AP18<>\"\",COLUMN(V18:AP18)-COLUMN(V18)+1),1)),\"X\")","v":"X"},0,"","","N-Before",{"$f":"COUNT(AU27:AU49)","v":0},{"$f":"COUNT(AR27:AR49)","v":23}]
["Nonconducive","46 + 15 - 24","2N106",37,null,"",null,null,null,null,null,null,{"$f":"0.79*I19","v":0},null,0,"",{"$f":"F35","v":""},{"$f":"G35","v":0},17,{"$f":"O35","v":0},false,"","","","","","","","","","","","","","",{"$f":"IF($AJ$17=$R$17, R19, \"\")","v":""},{"$f":"IF($AK$18=$R$18, R19, \"\")","v":""},{"$f":"IF(U19=TRUE, R19, \"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(INDEX(V19:AP19,SMALL(IF(V19:AP19<>\"\",COLUMN(V19:AP19)-COLUMN(V19)+1),1)),\"X\")","v":"X"},0,"","","N-Con After",{"$f":"COUNT(AT27:AT49)","v":0},{"$f":"COUNT(AQ27:AQ49)","v":0}]
["Nonconducive","58 + 24 - 33","1N104",49,null,"",null,null,null,null,null,null,{"$f":"0.79*I20","v":0},null,0,"",{"$f":"F36","v":""},{"$f":"G36","v":0},18,{"$f":"O36","v":0},false,"","","","","","","","","","","","","","","",{"$f":"IF($AK$18=$R$18, R20, \"\")","v":""},{"$f":"IF($AL$19=$R$19, R20, \"\")","v":""},{"$f":"IF(U20=TRUE, R20, \"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX(V20:AP20,SMALL(IF(V20:AP20<>\"\",COLUMN(V20:AP20)-COLUMN(V20)+1),1)),\"X\")","v":"X"},0,"",""]
["Conducive","15 + 48 - 44","3C104",19,null,"",null,null,null,null,null,null,null,{"$f":"AND(H21<$L$2, H21<M20, H21<J21)","v":false},0,"",{"$f":"F38","v":""},{"$f":"G38","v":0},19,{"$f":"O38","v":0},false,"","","","","","","","","","","","","","","","",{"$f":"IF($AL$19=$R$19, R21, \"\")","v":""},{"$f":"IF($AM$20=$R$20, R21, \"\")","v":""},{"$f":"IF(U21=TRUE, R21, \"\")","v":""},null,null,null,{"$f":"IFERROR(INDEX(V21:AP21,SMALL(IF(V21:AP21<>\"\",COLUMN(V21:AP21)-COLUMN(V21)+1),1)),\"X\")","v":"X"},0,"","","Con T",{"$f":"COUNT(Q3:Q25)","v":0}]
["Nonconducive","33 + 28 - 45","3N107",16,null,"",null,null,null,null,null,null,{"$f":"0.79*I22","v":0},null,0,"",{"$f":"F40","v":""},{"$f":"G40","v":0},20,{"$f":"O40","v":0},false,"","","","","","","","","","","","","","","","","",{"$f":"IF($AM$20=$R$20, R22, \"\")","v":""},{"$f":"IF($AN$21=$R$21, R22, \"\")","v":""},{"$f":"IF(U22=TRUE, R22, \"\")","v":""},null,null,{"$f":"IFERROR(INDEX(V22:AP22,SMALL(IF(V22:AP22<>\"\",COLUMN(V22:AP22)-COLUMN(V22)+1),1)),\"X\")","v":"X"},0,"","","Con-Before",{"$f":"COUNT(AU3:AU25)","v":0},{"$f":"COUNT(AS3:AS25)","v":23}]
["Conducive","44 + 38 - 33","1C104",49,null,"",null,null,null,null,null,null,null,{"$f":"AND(H23<$L$2, H23<M22, H23<J23)","v":false},0,"",{"$f":"F42","v":""},{"$f":"G42","v":0},21,{"$f":"O42","v":0},false,"","","","","","","","","","","","","","","","","","",{"$f":"IF($AN$21=$R$21, R23, \"\")","v":""},{"$f":"IF($AO$22=$R$22, R23, \"\")","v":""},{"$f":"IF(U23=TRUE, R23, \"\")","v":""},null,{"$f":"IFERROR(INDEX(V23:AP23,SMALL(IF(V23:AP23<>\"\",COLUMN(V23:AP23)-COLUMN(V23)+1),1)),\"X\")","v":"X"},0,"","","Con-After",{"$f":"COUNT(AT3:AT25)","v":0},{"$f":"COUNT(AR3:AR25)","v":0}]
["Nonconducive","47 + 16 - 25","2N107",38,null,"",null,null,null,null,null,null,{"$f":"0.79*I24","v":0},null,0,"",{"$f":"F44","v":""},{"$f":"G44","v":0},22,{"$f":"O44","v":0},false,"","","","","","","","","","","","","","","","","","","",{"$f":"IF($AO$22=$R$22, R24, \"\")","v":""},{"$f":"IF($AP$23=$R$23, R24, \"\")","v":""},null,{"$f":"IFERROR(INDEX(V24:AP24,SMALL(IF(V24:AP24<>\"\",COLUMN(V24:AP24)-COLUMN(V24)+1),1)),\"X\")","v":"X"},0,"",""]
["Conducive","36 + 28 - 25","2C104",39,null,"",null,null,null,null,null,null,null,{"$f":"AND(H25<$L$2, H25<M24, H25<J25)","v":false},0,"",{"$f":"F47","v":""},{"$f":"G47","v":0},23,{"$f":"O47","v":0},{"$f":"AND(T25>0, T26>0,#REF!>0)","v":{"$error":"#REF!"}},"","","","","","","","","","","","","","","","","","","","",{"$f":"IF($AP$23=$R$23, R25, \"\")","v":""},null,{"$f":"IFERROR(INDEX(V25:AP25,SMALL(IF(V25:AP25<>\"\",COLUMN(V25:AP25)-COLUMN(V25)+1),1)),\"X\")","v":"X"},0,{"$f":"IF(Q25=1, AR25, \"\")","v":""},{"$f":"IF(Q25=1, AS25, \"\")","v":""}]
["Nonconducive","26 + 56 - 35","1N105",47,null,"",null,null,null,null,null,null,{"$f":"0.79*I26","v":0},null,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,"Trial Number",{"$f":"24-COUNT(AR3:AR25)","v":24},null,null,null,"Median RT's","Just Correct"]
["Conducive","12 + 49 - 43","3C105",18,null,"",null,null,null,null,null,null,null,{"$f":"AND(H27<$L$2, H27<M26, H27<J27)","v":false},0,"",{"$f":"F2","v":""},{"$f":"G2","v":0},1,{"$f":"IF($AR$26=0, R27, \"X\")","v":"X"},{"$f":"IF(U3=TRUE, R3, \"\")","v":""},null,null,null,null," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T27:AO27,SMALL(IF(T27:AO27<>\"\",COLUMN(T27:AO27)-COLUMN(T27)+1),1)),\"X\")","v":"X"},{"$f":"IF(AQ27=\"X\", R27, \"\")","v":0},null,{"$f":"IF(Q27=1, AQ27, \"\")","v":""},{"$f":"IF(Q27=1, AR27, \"\")","v":""},"N-con T",{"$f":"MEDIAN(P27:P49)","v":{"$error":"#NUM!"}}]
["Nonconducive","28 + 34 - 45","3N101",17,null,"",null,null,null,null,null,null,{"$f":"0.79*I28","v":0},null,0,"",{"$f":"F4","v":""},{"$f":"G4","v":0},2,{"$f":"IF($T$27=$R$27, R28, \"\")","v":""},{"$f":"IF($AR$26=1, R28, \"X\")","v":"X"},null,null,null,null,null," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T28:AO28,SMALL(IF(T28:AO28<>\"\",COLUMN(T28:AO28)-COLUMN(T28)+1),1)),\"X\")","v":"X"},{"$f":"IF(AQ28=\"X\", R28, \"\")","v":0},null,{"$f":"IF(Q28=1, AQ28, \"\")","v":""},{"$f":"IF(Q28=1, AR28, \"\")","v":""},"N-Before",{"$f":"MEDIAN(AU27:AU49)","v":{"$error":"#NUM!"}}]
["Conducive","43 + 39 - 35","1C105",47,null,"",null,null,null,null,null,null,null,{"$f":"AND(H29<$L$2, H29<M28, H29<J29)","v":false},0,"",{"$f":"F7","v":""},{"$f":"G7","v":0},3,{"$f":"IF($T$27=$R$27, R29, \"\")","v":""},{"$f":"IF($U$28=$R$28, R29, \"\")","v":""},{"$f":"IF($AR$26=2, R29, \"\")","v":""},{"$f":"IF($AR$26=3, R29, \"X\")","v":"X"},null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T29:AO29,SMALL(IF(T29:AO29<>\"\",COLUMN(T29:AO29)-COLUMN(T29)+1),1)),\"X\")","v":"X"},0,null,"","","N-Con After",{"$f":"MEDIAN(AT27:AT49)","v":{"$error":"#NUM!"}}]
["Conducive","32 + 29 - 23","2C105",38,null,"",null,null,null,null,null,null,null,{"$f":"AND(H30<$L$2, H30<M28, H30<J30)","v":false},0,"",{"$f":"F8","v":""},{"$f":"G8","v":0},4,"",{"$f":"IF($U$28=$R$28, R30, \"\")","v":""},{"$f":"IF($V$29=$R$29, R30, \"\")","v":""},{"$f":"IF($W$29=$R$29, R30, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T30:AO30,SMALL(IF(T30:AO30<>\"\",COLUMN(T30:AO30)-COLUMN(T30)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Nonconducive","16 + 48 - 25","2N104",39,null,"",null,null,null,null,null,null,{"$f":"0.79*I31","v":0},null,0,"",{"$f":"F11","v":""},{"$f":"G11","v":0},5,"","",{"$f":"IF($V$29=$R$29, R31, \"\")","v":""},{"$f":"IF($W$29=$R$29, R31, \"\")","v":""},{"$f":"IF($AR$26=4, R31, \"\")","v":""},{"$f":"IF($AR$26=5, R31, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T31:AO31,SMALL(IF(T31:AO31<>\"\",COLUMN(T31:AO31)-COLUMN(T31)+1),1)),\"X\")","v":"X"},0,null,"","","Con T",{"$f":"MEDIAN(P3:P25)","v":{"$error":"#NUM!"}}]
["Conducive","14 + 48 - 43","3C106",19,null,"",null,null,null,null,null,null,null,{"$f":"AND(H32<$L$2, H32<M31, H32<J32)","v":false},0,"",{"$f":"F12","v":""},{"$f":"G12","v":0},6,"","","","",{"$f":"IF($X$31=$R$31, R32, \"\")","v":""},{"$f":"IF($Y$31=$R$31, R32, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T32:AO32,SMALL(IF(T32:AO32<>\"\",COLUMN(T32:AO32)-COLUMN(T32)+1),1)),\"X\")","v":"X"},0,null,"","","Con-Before",{"$f":"MEDIAN(AU3:AU25)","v":{"$error":"#NUM!"}}]
["Nonconducive","56 + 25 - 33","1N101",48,null,"",null,null,null,null,null,null,{"$f":"0.79*I33","v":0},null,0,"",{"$f":"F14","v":""},{"$f":"G14","v":0},7,"","","","",{"$f":"IF($X$31=$R$31, R33, \"\")","v":""},{"$f":"IF($Y$31=$R$31, R33, \"\")","v":""},{"$f":"IF($AR$26=6, R33, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T33:AO33,SMALL(IF(T33:AO33<>\"\",COLUMN(T33:AO33)-COLUMN(T33)+1),1)),\"X\")","v":"X"},0,null,"","","Con-After",{"$f":"MEDIAN(AT3:AT25)","v":{"$error":"#NUM!"}}]
["Nonconducive","29 + 35 - 46","3N102",18,null,"",null,null,null,null,null,null,{"$f":"0.79*I34","v":0},null,0,"",{"$f":"F17","v":""},{"$f":"G17","v":0},8,"","","","","","",{"$f":"IF($Z$33=$R$33, R34, \"\")","v":""},{"$f":"IF($AR$26=7, R34, \"\")","v":""},{"$f":"IF($AR$26=8, R34, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T34:AO34,SMALL(IF(T34:AO34<>\"\",COLUMN(T34:AO34)-COLUMN(T34)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Conducive","44 + 39 - 37","1C106",46,null,"",null,null,null,null,null,null,null,{"$f":"AND(H35<$L$2, H35<M34, H35<J35)","v":false},0,"",{"$f":"F19","v":""},{"$f":"G19","v":0},9,"","","","","","",{"$f":"IF($Z$33=$R$33, R35, \"\")","v":""},{"$f":"IF($AA$34=$R$34, R35, \"\")","v":""},{"$f":"IF($AB$34=$R$34, R35, \"\")","v":""},{"$f":"IF($AR$26=9, R35, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T35:AO35,SMALL(IF(T35:AO35<>\"\",COLUMN(T35:AO35)-COLUMN(T35)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Conducive","33 + 28 - 24","2C106",37,null,"",null,null,null,null,null,null,null,{"$f":"AND(H36<$L$2, H36<M34, H36<J36)","v":false},0,"",{"$f":"F20","v":""},{"$f":"G20","v":0},10,"","","","","","","",{"$f":"IF($AA$34=$R$34, R36, \"\")","v":""},{"$f":"IF($AB$34=$R$34, R36, \"\")","v":""},{"$f":"IF($AC$35=$R$35, R36, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T36:AO36,SMALL(IF(T36:AO36<>\"\",COLUMN(T36:AO36)-COLUMN(T36)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Nonconducive","48 + 14 - 26","2N103",36,null,"",null,null,null,null,null,null,{"$f":"0.79*I37","v":0},null,0,"",{"$f":"F22","v":""},{"$f":"G22","v":0},11,"","","","","","","","","",{"$f":"IF($AC$35=$R$35, R37, \"\")","v":""},{"$f":"IF($AR$26=10, R37, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T37:AO37,SMALL(IF(T37:AO37<>\"\",COLUMN(T37:AO37)-COLUMN(T37)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Conducive","13 + 48 - 45","3C107",16,null,"",null,null,null,null,null,null,null,{"$f":"AND(H38<$L$2, H38<M37, H38<J38)","v":false},0,"",{"$f":"F24","v":""},{"$f":"G24","v":0},12,"","","","","","","","","","",{"$f":"IF($AD$37=$R$37, R38, \"\")","v":""},{"$f":"IF($AR$26=11, R38, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T38:AO38,SMALL(IF(T38:AO38<>\"\",COLUMN(T38:AO38)-COLUMN(T38)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Nonconducive","58 + 23 - 35","1N103",46,null,"",null,null,null,null,null,null,{"$f":"0.79*I39","v":0},null,0,"",{"$f":"F26","v":""},{"$f":"G26","v":0},13,"","","","","","","","","","",{"$f":"IF($AD$37=$R$37, R39, \"\")","v":""},{"$f":"IF($AE$38=$R$38, R39, \"\")","v":""},{"$f":"IF($AR$26=12, R39, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T39:AO39,SMALL(IF(T39:AO39<>\"\",COLUMN(T39:AO39)-COLUMN(T39)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Conducive","45 + 39 - 36","1C107",48,null,"",null,null,null,null,null,null,null,{"$f":"AND(H40<$L$2, H40<M39, H40<J40)","v":false},0,"",{"$f":"F28","v":""},{"$f":"G28","v":0},14,"","","","","","","","","","","",{"$f":"IF($AE$38=$R$38, R40, \"\")","v":""},{"$f":"IF($AF$39=$R$39, R40, \"\")","v":""},{"$f":"IF($AR$26=13, R40, \"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T40:AO40,SMALL(IF(T40:AO40<>\"\",COLUMN(T40:AO40)-COLUMN(T40)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Nonconducive","27 + 35 - 43","3N106",19,null,"",null,null,null,null,null,null,{"$f":"0.79*I41","v":0},null,0,"",{"$f":"F31","v":""},{"$f":"G31","v":0},15,"","","","","","","","","","","","",{"$f":"IF($AF$39=$R$39, R41, \"\")","v":""},{"$f":"IF($AG$40=$R$40, R41, \"\")","v":""},{"$f":"IF($AR$26=14, R41, \"\")","v":""},{"$f":"IF($AR$26=15, R41, \"\")","v":""},null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T41:AO41,SMALL(IF(T41:AO41<>\"\",COLUMN(T41:AO41)-COLUMN(T41)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Conducive","34 + 29 - 25","2C107",38,null,"",null,null,null,null,null,null,null,{"$f":"AND(H42<$L$2, H42<M41, H42<J42)","v":false},0,"",{"$f":"F33","v":""},{"$f":"G33","v":0},16,"","","","","","","","","","","","","",{"$f":"IF($AG$40=$R$40, R42, \"\")","v":""},{"$f":"IF($AH$41=$R$41, R42, \"\")","v":""},{"$f":"IF($AI$41=$R$41, R42, \"\")","v":""},{"$f":"IF($AR$26=16, R42, \"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T42:AO42,SMALL(IF(T42:AO42<>\"\",COLUMN(T42:AO42)-COLUMN(T42)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Nonconducive","15 + 47 - 23","2N102",39,null,"",null,null,null,null,null,null,{"$f":"0.79*I43","v":0},null,0,"",{"$f":"F34","v":""},{"$f":"G34","v":0},17,"","","","","","","","","","","","","","",{"$f":"IF($AH$41=$R$41, R43, \"\")","v":""},{"$f":"IF($AI$41=$R$41, R43, \"\")","v":""},{"$f":"IF($AJ$42=$R$42, R43, \"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T43:AO43,SMALL(IF(T43:AO43<>\"\",COLUMN(T43:AO43)-COLUMN(T43)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Conducive","12 + 49 - 44","BUP1",17,null,"",null,null,null,null,null,null,null,{"$f":"AND(H44<$L$2, H44<M43, H44<J44)","v":false},0,"",{"$f":"F37","v":""},{"$f":"G37","v":0},18,"","","","","","","","","","","","","","","","",{"$f":"IF($AJ$42=$R$42, R44, \"\")","v":""},{"$f":"IF($AR$26=17, R44, \"\")","v":""},{"$f":"IF($AR$26=18, R44, \"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX(T44:AO44,SMALL(IF(T44:AO44<>\"\",COLUMN(T44:AO44)-COLUMN(T44)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Nonconducive","24 + 59 - 35","NBUP2",48,null,"",null,null,null,null,null,null,{"$f":"0.79*I45","v":0},null,0,"",{"$f":"F39","v":""},{"$f":"G39","v":0},19,"","","","","","","","","","","","","","","","","",{"$f":"IF($AK$44=$R$44, R45, \"\")","v":""},{"$f":"IF($AL$44=$R$44, R45, \"\")","v":""},{"$f":"IF($AR$26=19, R45, \"\")","v":""},null,null,null,{"$f":"IFERROR(INDEX(T45:AO45,SMALL(IF(T45:AO45<>\"\",COLUMN(T45:AO45)-COLUMN(T45)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Nonconducive","26 + 35 - 44","NBUP1",17,null,"",null,null,null,null,null,null,{"$f":"0.79*I46","v":0},null,0,"",{"$f":"F41","v":""},{"$f":"G41","v":0},20,"","","","","","","","","","","","","","","","","",{"$f":"IF($AK$44=$R$44, R46, \"\")","v":""},{"$f":"IF($AL$44=$R$44, R46, \"\")","v":""},{"$f":"IF($AM$45=$R$45, R46, \"\")","v":""},{"$f":"IF($AR$26=20, R46, \"\")","v":""},null,null,{"$f":"IFERROR(INDEX(T46:AO46,SMALL(IF(T46:AO46<>\"\",COLUMN(T46:AO46)-COLUMN(T46)+1),1)),\"X\")","v":"X"},0,null,"",""]
["Conducive","46 + 37 - 35","BUP2",48,null,"",null,null,null,null,null,null,null,{"$f":"AND(H47<$L$2, H47<M46, H47<J47)","v":false},0,"",{"$f":"F43","v":""},{"$f":"G43","v":0},21,"","","","","","","","","","","","","","","","","","","",{"$f":"IF($AM$45=$R$45, R47, \"\")","v":""},{"$f":"IF($AN$46=$R$46, R47, \"\")","v":""},{"$f":"IF($AR$26=21, R47, \"\")","v":""},null,{"$f":"IFERROR(INDEX(T47:AO47,SMALL(IF(T47:AO47<>\"\",COLUMN(T47:AO47)-COLUMN(T47)+1),1)),\"X\")","v":"X"},0,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"F45","v":""},{"$f":"G45","v":0},22,"","","","","","","","","","","","","","","","","","","","",{"$f":"IF($AN$46=$R$46, R48, \"\")","v":""},{"$f":"IF($AO$47=$R$47, R48, \"\")","v":""},null,{"$f":"IFERROR(INDEX(T48:AO48,SMALL(IF(T48:AO48<>\"\",COLUMN(T48:AO48)-COLUMN(T48)+1),1)),\"X\")","v":"X"},0,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"F46","v":""},{"$f":"G46","v":0},23,"","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($AO$47=$R$47, R49, \"\")","v":""},null,{"$f":"IFERROR(INDEX(T49:AO49,SMALL(IF(T49:AO49<>\"\",COLUMN(T49:AO49)-COLUMN(T49)+1),1)),\"X\")","v":"X"},0,null,"",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trial Number Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,null,null,null,"Total Trial No Identified at"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AR$26=1, 2, \"\")","v":""},{"$f":"IF($AR$26=2, 4, \"\")","v":""},{"$f":"IF($AR$26=3, 5, \"\")","v":""},{"$f":"IF($AR$26=4, 8, \"\")","v":""},{"$f":"IF($AR$26=5, 9, \"\")","v":""},{"$f":"IF($AR$26=6, 12, \"\")","v":""},{"$f":"IF($AR$26=7, 14, \"\")","v":""},{"$f":"IF($AR$26=8, 15, \"\")","v":""},{"$f":"IF($AR$26=9, 17, \"\")","v":""},{"$f":"IF($AR$26=10, 20, \"\")","v":""},{"$f":"IF($AR$26=11, 22, \"\")","v":""},{"$f":"IF($AR$26=12, 24, \"\")","v":""},{"$f":"IF($AR$26=13, 26, \"\")","v":""},{"$f":"IF($AR$26=14, 28, \"\")","v":""},{"$f":"IF($AR$26=15, 29, \"\")","v":""},{"$f":"IF($AR$26=16, 31, \"\")","v":""},{"$f":"IF($AR$26=17, 34, \"\")","v":""},{"$f":"IF($AR$26=18, 35, \"\")","v":""},{"$f":"IF($AR$26=19, 37, \"\")","v":""},{"$f":"IF($AR$26=20, 39, \"\")","v":""},{"$f":"IF($AR$26=21, 41, \"\")","v":""},null,null,null,{"$f":"IFERROR(INDEX(R53:AN53,SMALL(IF(R53:AN53<>\"\",COLUMN(R53:AN53)-COLUMN(R53)+1),1)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4,5,8,9,12,14,15,17,20,22,24,26,28,29,31,34,35,37,39,41]

{"sheet":"Results","index":3,"n_rows":3,"n_cols":35,"rows_kept":3,"cut":false,"hidden":false,"merged":[[15,0,16,0],[0,28,1,28],[0,29,0,34],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,0,15],[0,16,0,21],[0,22,0,27]]}
["Ppt details",null,"Identification",null,"Trial number",null,"Accuracy",null,null,null,null,null,null,null,null,null,"Percent accuracy",null,null,null,null,null,"Median RT",null,null,null,null,null,"Comments","Qualitative"]
["Ppt_URN","Condition","IDAN identifier","SR identifier","IDAN conducive trial number","Total trial number","Con all","Noncon all","Con before","Noncon before","Tot_con_before","Tot_noncon_before","Con_after","Noncon_after","Tot_con_after","Tot_ncon_after","Con%total","Con%before","Con%after","Noncon%total","Noncon%before","Noncon%after","Con all","Noncon all","Con before","Noncon before","Con_after","Noncon_after",null,"Alternative strategies","Reasons for non-identification","Better strategy","Why","When?","Consciously aware?"]
[{"$f":"'Raw Data'!BE16","v":0},null,{"$f":"IF(Calculations!AR26=24, 0, 1)","v":0},null,{"$f":"IF(Calculations!AR26=24, \"NA\", Calculations!AR26)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AP53)","v":"NA"},{"$f":"Calculations!AW21","v":0},{"$f":"Calculations!AW17","v":0},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AW22)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AW18)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AX22)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AX18)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AW23)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AW19)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AX23)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AX19)","v":"NA"},{"$f":"(G3/23)*100","v":0},{"$f":"IF(Calculations!AR26=24,\"NA\", (I3/K3)*100)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", (M3/O3)*100)","v":"NA"},{"$f":"(H3/23)*100","v":0},{"$f":"IF(Calculations!AR26=24,\"NA\", (J3/L3)*100)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", (N3/P3)*100)","v":"NA"},{"$f":"Calculations!AW31","v":{"$error":"#NUM!"}},{"$f":"Calculations!AW27","v":{"$error":"#NUM!"}},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AW32)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AW28)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AW33)","v":"NA"},{"$f":"IF(Calculations!AR26=24,\"NA\", Calculations!AW29)","v":"NA"}]