{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["MainMenu","EnterCodes","EnterSequence","MakeMatrix","MakeDiagram","ResponseScores","1","2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"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":"MainMenu","index":0,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[21,4,24,13]]}
[]
[]
[]
[null,"Main Menu"]
[]
[null,"Enter Codes"]
[]
[null,"Enter Sequence"]
[]
[null,"Make Matrix"]
[]
[null,"Make Diagram"]
[]
[null,"Mean responses"]
[]
[]
[]
[]
[]
[]
[]
[null,"More info",null,null,"This is a beta release of the Discussion Analysis Tool (DAT) for analyzing patterns in event sequences, and generating transitional state diagrams to visually analyze and identify patterns in social and human-computer interactions."]
[]
[null,"Updates"]
[]
[]
[null,null,null,null,null,null,null,null,"Version 1.94"]
[]
[null,"Copyright 2005-2011"]
[null,"All Rights Reserved"]
[null,"By Allan Jeong"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Software Updates:"]
[]
[null,null,null,null,"6/9/09 Automaticallly draws four node diagrams if number of codes = 4"]
[null,null,null,null,"6/9/09 Prompts user when a code is missing in the DefineCodes sheet when running StartSeqAnal"]
[null,null,null,null,"6/11/09 Fixed DrawDiagram macro to work in Excel 2007"]
[null,null,null,null,"11/28/11 In MakeDiagram, added function to make historical diagram to reveal probability of event PRECEDING a given event"]
[null,null,null,null,"11 /28/11 v1.830In MakeMatrix, added prompt for user to select critical z-score and p-values to identify frequencies significantly above/below expected frequencies"]
[null,null,null,null,"11/29/11 v1.85 In MakeDiagram, added button to automatically copy & paste codes & cell frequencies for any selected group of values in the matrix"]
[null,null,null,null,"12/1/11 v1.94  In MakeDiagram, added function to place two diagrams side by side in a new worksheet to faciliate visual comparisons"]

{"sheet":"EnterCodes","index":1,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[23,2,24,11],[26,2,26,6],[5,5,16,10]]}
[]
[]
[]
[]
[null,null,null,"Codes"]
[null,null,1,"ARG",null,"Enter your codes (up to 16 codes maximum) in the order in which you want them to appear in the probability matrix. Each code must consist of 1 to 5 characters in length."]
[null,null,2,"BUT"]
[null,null,3,"EVID"]
[null,null,4,"EXPL"]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"COUNTA(D6:D21)","v":4}]

{"sheet":"EnterSequence","index":2,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,6,3,10]]}
["ARG",2,".   ARG MediaIsButAMereVehicle"]
["EVID",3,".   .   EVID MediaIsButAMereVehicle"]
["BUT",4,".   .   .   BUT RelativityTheoryOldToo"]
["BUT",5,".   .   .   .   BUT RelativityTheoryOldToo"]
["BUT",3,".   .   BUT Whataboutemotions?"]
["EVID",3,".   .   EVID DistEdEffectiveAsFF"]
["BUT",3,".   .   BUT Mediaamerevehicle",null,null,null,"Steps for Entering Coded Events:"]
["EVID",3,".   .   EVID MooreConcurs",null,null,null,"1)               columns A, B & C"]
["EXPL",4,".   .   .   EXPL MediaSelectionComesAfterInstructionalStrategy",null,null,null,"2) Enter codes into Column A",null,null,null,null,"(more info)"]
["BUT",4,".   .   .   BUT WellChosenEffective",null,null,null,"3) Enter sequence or thread level in Column B",null,null,null,null,"(more info)"]
["BUT",5,".   .   .   .   BUT SupportingResearch",null,null,null,"4) Optional: Enter event descriptions in Col. C",null,null,null,null,"(more info)"]
["BUT",3,".   .   BUT Mediaismorethenamerevehicle"]
["BUT",4,".   .   .   BUT SupportingEvidence?"]
["BUT",3,".   .   BUT LearningNotSimplyAPassiveResponseToDeliveryMethod",null,null,null,"Optional Procedures for Processing Data from Labeled/Tagged Messages in Threaded Discussions:"]
["ARG",2,".   ARG Standards for teaching"]
["BUT",3,".   .   BUT Clarification?"]
["ARG",2,".   ARG MediaUnrelatedtoLearningObjectives"]
["BUT",3,".   .   BUT MediaUnrelatedtoLearningObjectives"]
["BUT",4,".   .   .   BUT MediaSelection"]
["BUT",5,".   .   .   .   BUT MediaSelection"]
["EVID",3,".   .   EVID MethodNotMedia"]
["BUT",3,".   .   BUT MediaUnrelatedtoLearningObjectives"]
["EXPL",4,".   .   .   EXPL Media'sContribution?"]
["BUT",5,".   .   .   .   BUT Media'sContribution?"]
["BUT",3,".   .   BUT MediaInteractsWithLearner"]
["ARG",2,".   ARG TargetAudienceUsingDialUp"]
["BUT",3,".   .   BUT TargetAudienceUsingDialUp"]
["BUT",4,".   .   .   BUT ItsNotCostEffective"]
["EXPL",4,".   .   .   EXPL Conducting polls to identify interest in DE courses"]
["BUT",4,".   .   .   BUT TargetAudienceUsingDialUp"]
["BUT",5,".   .   .   .   BUT TargetAudienceUsingDialUp"]

{"sheet":"MakeMatrix","index":3,"n_rows":74,"n_cols":42,"rows_kept":74,"cut":false,"hidden":false,"merged":[[21,24,21,32]]}
[null,"Frequency matrix"]
[null,null,{"$f":"B3","v":"ARG"},{"$f":"B4","v":"BUT"},{"$f":"B5","v":"EVID"},{"$f":"B6","v":"EXPL"},{"$f":"B7","v":0},{"$f":"B8","v":0},{"$f":"B9","v":0},{"$f":"B10","v":0},{"$f":"B11","v":0},{"$f":"B12","v":0},{"$f":"B13","v":0},{"$f":"B14","v":0},{"$f":"B15","v":0},{"$f":"B16","v":0},{"$f":"B17","v":0},{"$f":"B18","v":0},"Replies","No Replies","Givens","% replies","% givens",null,null,{"$f":"C2","v":"ARG"},"BUT","EVID","EXPL",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"T2","v":"No Replies"}]
[null,{"$f":"EnterCodes!D6","v":"ARG"},0,9,4,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C3:R3)+0.0001","v":13.0001},0,4,{"$f":"(S3-0.0001)/S$19","v":0.48145116788942927},{"$f":"U3/$U$19","v":0.12903225806451613},null,{"$f":"B3","v":"ARG"},null,"5 7 12 14 16 18 22 25 27 ","2 6 8 21 "]
[null,{"$f":"EnterCodes!D7","v":"BUT"},0,8,0,2,0,0,0,0,0,0,0,0,0,0,0,0,10.0001,12,20,0.37034705222263786,0.64516129032258063,null,"BUT",null,"4 11 13 19 20 28 30 31 ",null,"23 29 ",null,null,null,null,null,null,null,null,null,null,null,null," 4 5 7 11 13 14 16 20 24 25 2831"]
[null,{"$f":"EnterCodes!D8","v":"EVID"},0,2,0,1,0,0,0,0,0,0,0,0,0,0,0,0,3.0001000000000002,2,4,0.11110411566679136,0.12903225806451613,null,"EVID",null,"3 10 ",null,"9 ",null,null,null,null,null,null,null,null,null,null,null,null," 6 21"]
[null,{"$f":"EnterCodes!D9","v":"EXPL"},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.0001,2,3,3.7034705222263792E-2,9.6774193548387094E-2,null,"EXPL",null,"24 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null," 9 29"]
[null,{"$f":"EnterCodes!D10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,{"$f":"EnterCodes!D11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,{"$f":"EnterCodes!D12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,{"$f":"EnterCodes!D13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,{"$f":"EnterCodes!D14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,{"$f":"EnterCodes!D15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,{"$f":"EnterCodes!D16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,{"$f":"EnterCodes!D17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,{"$f":"EnterCodes!D18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,{"$f":"EnterCodes!D19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,{"$f":"EnterCodes!D20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,{"$f":"EnterCodes!D21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,0]
[null,null,{"$f":"SUM(C3:C18)+0.0001","v":1E-4},20.0001,4.0000999999999998,3.0001000000000002,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,{"$f":"SUM(S3:S18)+0.0001","v":27.001699999999996},{"$f":"SUM(T3:T18)","v":16},{"$f":"SUM(U3:U18)","v":31},null,null,null,"Location of event pairs in CodeSequence sheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Double click a cell to see complete list of locations for each observed pairing"]
[null,"Transitional probabilities matrix"]
[null,null,{"$f":"C2","v":"ARG"},"BUT","EVID","EXPL",0,0,0,0,0,0,0,0,0,0,0,0,"Replies","No Replies","Givens","Reply Rate"]
[null,{"$f":"B3","v":"ARG"},{"$f":"C3/$S3","v":0},0.69230236690487001,0.30768994084660889,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S3","v":13.0001},{"$f":"T3+0.0001","v":1E-4},4.0000999999999998,{"$f":"(U23-T23)/U23","v":0.99997500062498434}]
[null,"BUT",{"$f":"C4/$S4","v":0},0.79999200007999927,0,0.19999800001999982,0,0,0,0,0,0,0,0,0,0,0,0,10.0001,12.0001,20.0001,0.39999800000999997]
[null,"EVID",{"$f":"C5/$S5","v":0},0.66664444518516042,0,0.33332222259258021,0,0,0,0,0,0,0,0,0,0,0,0,3.0001000000000002,2.0001000000000002,4.0000999999999998,0.49998750031249212]
[null,"EXPL",{"$f":"C6/$S6","v":0},0.99990000999900008,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.0001,2.0001000000000002,3.0001000000000002,0.33332222259258021]
[null,0,{"$f":"C7/$S7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,1E-4,1E-4,0]
[null,0,{"$f":"C8/$S8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,1E-4,1E-4,0]
[null,0,{"$f":"C9/$S9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,1E-4,1E-4,0]
[null,0,{"$f":"C10/$S10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,{"$f":"T10+0.0001","v":1E-4},{"$f":"U10+0.0001","v":1E-4},0]
[null,0,{"$f":"C11/$S11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,1E-4,1E-4,0]
[null,0,{"$f":"C12/$S12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,1E-4,1E-4,0,null,null,null,"Main Menu"]
[null,0,{"$f":"C13/$S13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,1E-4,1E-4,0]
[null,0,{"$f":"C14/$S14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,1E-4,1E-4,0]
[null,0,{"$f":"C15/$S15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,1E-4,1E-4,0]
[null,0,{"$f":"C16/$S16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,1E-4,1E-4,0]
[null,0,{"$f":"C17/$S17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,1E-4,1E-4,0]
[null,0,{"$f":"C18/$S18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,1E-4,1E-4,0]
[null,null,{"$f":"C19","v":1E-4},20.0001,4.0000999999999998,3.0001000000000002,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,27.001699999999996,{"$f":"T19","v":16},{"$f":"U19","v":31},{"$f":"AVERAGE(V23:V38)","v":0.13958017022125352}]
[]
[null,"Z-Scores identify the probabilities that are higher/lower than expected"]
[null,null,{"$f":"C2","v":"ARG"},"BUT","EVID","EXPL",0,0,0,0,0,0,0,0,0,0,0,0," ",null,null,null,"Critical z-score",null,1.64,"at p < .05"]
[null,{"$f":"B3","v":"ARG"},{"$f":"(C3-((C$19*$S3)/$S$19))/SQRT(((C$19*$S3)/$S$19)*(1-$S3/$S$19)*(1 - C$19/$S$19))","v":-9.6357454245811977E-3},{"$f":"(D3-D$19*$S3/$S$19)/SQRT((D$19*$S3/$S$19)*(1-$S3/$S$19)*(1-D$19/$S$19))","v":-0.55291821224403936},2.248777583362938,-1.7702224157185646,-9.6357454245811977E-3,-9.6357454245811977E-3,-9.6357454245811977E-3,-9.6357454245811977E-3,-9.6357454245811977E-3,-9.6357454245811977E-3,-9.6357454245811977E-3,-9.6357454245811977E-3,-9.6357454245811977E-3,-9.6357454245811977E-3,-9.6357454245811977E-3,-9.6357454245811977E-3,{"$f":"S23","v":13.0001},null,null,"Z-score = 2.32 at .01 significance"]
[null,"BUT",-7.6693415372004947E-3,{"$f":"(D4-D$19*$S4/$S$19)/SQRT((D$19*$S4/$S$19)*(1-$S4/$S$19)*(1-D$19/$S$19))","v":0.53918941888231275},-1.6619166127948086,1.1272227975858968,-7.6693415372004947E-3,-7.6693415372004947E-3,-7.6693415372004947E-3,-7.6693415372004947E-3,-7.6693415372004947E-3,-7.6693415372004947E-3,-7.6693415372004947E-3,-7.6693415372004947E-3,-7.6693415372004947E-3,-7.6693415372004947E-3,-7.6693415372004947E-3,-7.6693415372004947E-3,10.0001,null,null,"Z-score = 1.64 at .05 significance"]
[null,"EVID",-3.5354815305866359E-3,{"$f":"(D5-D$19*$S5/$S$19)/SQRT((D$19*$S5/$S$19)*(1-$S5/$S$19)*(1-D$19/$S$19))","v":-0.31043057058105894},-0.76612515708303164,1.2990284823814915,-3.5354815305866359E-3,-3.5354815305866359E-3,-3.5354815305866359E-3,-3.5354815305866359E-3,-3.5354815305866359E-3,-3.5354815305866359E-3,-3.5354815305866359E-3,-3.5354815305866359E-3,-3.5354815305866359E-3,-3.5354815305866359E-3,-3.5354815305866359E-3,-3.5354815305866359E-3,3.0001000000000002,null,null,"Z-score = 1.28 at .10 significance"]
[null,"EXPL",-1.9612026949714129E-3,{"$f":"(D6-D$19*$S6/$S$19)/SQRT((D$19*$S6/$S$19)*(1-$S6/$S$19)*(1-D$19/$S$19))","v":0.602743164734315},-0.42498502955192269,-0.36030061188098977,-1.9612026949714129E-3,-1.9612026949714129E-3,-1.9612026949714129E-3,-1.9612026949714129E-3,-1.9612026949714129E-3,-1.9612026949714129E-3,-1.9612026949714129E-3,-1.9612026949714129E-3,-1.9612026949714129E-3,-1.9612026949714129E-3,-1.9612026949714129E-3,-1.9612026949714129E-3,1.0001]
[null,0,-1.9244474411546252E-5,{"$f":"(D7-D$19*$S7/$S$19)/SQRT((D$19*$S7/$S$19)*(1-$S7/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4,null,"p108-109 Bakeman & Gottman (1997)"]
[null,0,-1.9244474411546252E-5,{"$f":"(D8-D$19*$S8/$S$19)/SQRT((D$19*$S8/$S$19)*(1-$S8/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4,null,"where consec. codes may repeat"]
[null,0,-1.9244474411546252E-5,{"$f":"(D9-D$19*$S9/$S$19)/SQRT((D$19*$S9/$S$19)*(1-$S9/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4]
[null,0,-1.9244474411546252E-5,{"$f":"(D10-D$19*$S10/$S$19)/SQRT((D$19*$S10/$S$19)*(1-$S10/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4]
[null,0,-1.9244474411546252E-5,{"$f":"(D11-D$19*$S11/$S$19)/SQRT((D$19*$S11/$S$19)*(1-$S11/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4]
[null,0,-1.9244474411546252E-5,{"$f":"(D12-D$19*$S12/$S$19)/SQRT((D$19*$S12/$S$19)*(1-$S12/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4]
[null,0,-1.9244474411546252E-5,{"$f":"(D13-D$19*$S13/$S$19)/SQRT((D$19*$S13/$S$19)*(1-$S13/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4]
[null,0,-1.9244474411546252E-5,{"$f":"(D14-D$19*$S14/$S$19)/SQRT((D$19*$S14/$S$19)*(1-$S14/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4]
[null,0,-1.9244474411546252E-5,{"$f":"(D15-D$19*$S15/$S$19)/SQRT((D$19*$S15/$S$19)*(1-$S15/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4]
[null,0,-1.9244474411546252E-5,{"$f":"(D16-D$19*$S16/$S$19)/SQRT((D$19*$S16/$S$19)*(1-$S16/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4]
[null,0,-1.9244474411546252E-5,{"$f":"(D17-D$19*$S17/$S$19)/SQRT((D$19*$S17/$S$19)*(1-$S17/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4]
[null,0,-1.9244474411546252E-5,{"$f":"(D18-D$19*$S18/$S$19)/SQRT((D$19*$S18/$S$19)*(1-$S18/$S$19)*(1-D$19/$S$19))","v":-1.6901227193974713E-2},-4.1702030837875324E-3,-3.5354815305866359E-3,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,-1.9244474411546252E-5,1E-4]
[null,null,{"$f":"C39","v":1E-4},20.0001,4.0000999999999998,3.0001000000000002,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,1E-4,27.001699999999996]
[]
[]
[]
[null,null,{"$f":"$S3/COUNTA($C$2:$R$2)","v":0.81250624999999999},0.81250624999999999,0.81250624999999999,0.81250624999999999,0.81250624999999999,0.81250624999999999,0.81250624999999999,0.81250624999999999,0.81250624999999999,0.81250624999999999,0.81250624999999999,null,null,null,null,{"$f":"$S3/COUNTA($C$2:$R$2)","v":0.81250624999999999}]
[null,null,{"$f":"$S4/COUNTA($C$2:$R$2)","v":0.62500624999999999},0.62500624999999999,0.62500624999999999,0.62500624999999999,0.62500624999999999,0.62500624999999999,0.62500624999999999,0.62500624999999999,0.62500624999999999,0.62500624999999999,0.62500624999999999,null,null,null,null,0.62500624999999999]
[null,null,{"$f":"$S5/COUNTA($C$2:$R$2)","v":0.18750625000000001},0.18750625000000001,0.18750625000000001,0.18750625000000001,0.18750625000000001,0.18750625000000001,0.18750625000000001,0.18750625000000001,0.18750625000000001,0.18750625000000001,0.18750625000000001,null,null,null,null,0.18750625000000001]
[null,null,{"$f":"$S6/COUNTA($C$2:$R$2)","v":6.2506249999999999E-2},6.2506249999999999E-2,6.2506249999999999E-2,6.2506249999999999E-2,6.2506249999999999E-2,6.2506249999999999E-2,6.2506249999999999E-2,6.2506249999999999E-2,6.2506249999999999E-2,6.2506249999999999E-2,6.2506249999999999E-2,null,null,null,null,6.2506249999999999E-2]
[null,null,{"$f":"$S7/COUNTA($C$2:$R$2)","v":6.2500000000000003E-6},6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,null,null,null,null,6.2500000000000003E-6]
[null,null,{"$f":"$S8/COUNTA($C$2:$R$2)","v":6.2500000000000003E-6},6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,null,null,null,null,6.2500000000000003E-6]
[null,null,{"$f":"$S9/COUNTA($C$2:$R$2)","v":6.2500000000000003E-6},6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,null,null,null,null,6.2500000000000003E-6]
[null,null,{"$f":"$S10/COUNTA($C$2:$R$2)","v":6.2500000000000003E-6},6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,null,null,null,null,6.2500000000000003E-6]
[null,null,{"$f":"$S11/COUNTA($C$2:$R$2)","v":6.2500000000000003E-6},6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,null,null,null,null,6.2500000000000003E-6]
[null,null,{"$f":"$S12/COUNTA($C$2:$R$2)","v":6.2500000000000003E-6},6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,null,null,null,null,6.2500000000000003E-6]
[null,null,{"$f":"$S13/COUNTA($C$2:$R$2)","v":6.2500000000000003E-6},6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,null,null,null,null,6.2500000000000003E-6]
[null,null,{"$f":"$S18/COUNTA($C$2:$R$2)","v":6.2500000000000003E-6},6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,6.2500000000000003E-6,null,null,null,null,{"$f":"$S18/COUNTA($C$2:$R$2)","v":6.2500000000000003E-6}]

{"sheet":"MakeDiagram","index":4,"n_rows":86,"n_cols":26,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[null,"Frequency Matrix",null,null,null,null,null,null,null,"Transitional Probability Matrix",null,null,null,null,null,null,null,"Historical Probability Matrix"]
[null,null,{"$f":"B3","v":"ARG"},{"$f":"B4","v":"BUT"},{"$f":"B5","v":"EVID"},{"$f":"B6","v":"EXPL"},{"$f":"B7","v":0},{"$f":"B8","v":0},null,null,{"$f":"C2","v":"ARG"},"BUT","EVID","EXPL",0,0,null,null,{"$f":"C2","v":"ARG"},"BUT","EVID","EXPL",0,0,null,"Givens"]
[null,"ARG",0,9,4,0,null,null,{"$f":"SUM(C3:H3)+0.0001","v":13.0001},{"$f":"B3","v":"ARG"},{"$f":"C3/$I3","v":0},0.69230236690487001,0.30768994084660889,0,0,0,null,{"$f":"B3","v":"ARG"},{"$f":"C3/C$9","v":0},0.44999775001124998,0.99997500062498446,0,0,0,null,4]
[null,"BUT",0,8,0,2,null,null,{"$f":"SUM(C4:H4)+0.0001","v":10.0001},"BUT",0,0.79999200007999927,0,0.19999800001999982,0,0,null,"BUT",0,0.39999800000999997,0,0.66664444518516042,0,0,null,20]
[null,"EVID",0,2,0,1,null,null,3.0001000000000002,"EVID",0,0.66664444518516042,0,0.33332222259258021,0,0,null,"EVID",0,9.9999500002499991E-2,0,0.33332222259258021,0,0,null,4]
[null,"EXPL",0,1,0,0,null,null,1.0001,"EXPL",0,0.99990000999900008,0,0,0,0,null,"EXPL",0,4.9999750001249996E-2,0,0,0,0,null,3]
[null,null,null,null,null,null,null,null,1E-4,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,1E-4,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[null,{"$f":"COUNTA(B3:B8)","v":4},{"$f":"SUM(C3:C8)+0.0001","v":1E-4},20.0001,4.0000999999999998,3.0001000000000002,1E-4,1E-4]
[null,null,"Enter values only in the cells shaded in blue",null,null,null,null,null,null,null,"Probability of events following each given event",null,null,null,null,null,null,null,"Probability of events PRECEDING each given event"]
[]
[]
[]
[null,null,"Instructions:"]
[]
[null,null,"1) In the frequency matrix above, enter up to six codes down the first column"]
[]
[null,null,"2) Enter the corresponding cell frequencies for the selected codes from the matrix sheet"]
[]
[null,null,"3) In order to tease out possible patterns in the diagrams, you may want to vary the density of the arrows in the diagram,"]
[null,null,"    by increasing or decreasing the multiplier."]
[]
[null,null,"    Multiplier = ",null,null,10,null,"default value = 10"]
[]
[]
[null,null,"4) Click buttons below the matrices the make a transitional state diagram OR a historical state diagram."]
[]
[null,null,"5) Place two diagrams side by side"]
[]
[null,null,"** At this time, the DAT program only draws state diagrams for six or less event codes/categories"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"COUNTA(B3:B8)","v":4}]

{"sheet":"ResponseScores","index":5,"n_rows":72,"n_cols":14,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,5,3,14]]}
["ARG-->BUTBUTBUTBUT",4,1,null,null,"This page tallies the number of replies elicited by each \"given\" type of message to obain the raw scores needed to use any statistical program (e.g., SPSSX, Systat) to compute, for example, the mean number of challenges posted in reply to each argument, and compare the means across multiple factors or groups. You can repeat this process for any number of given-target message pairings."]
["ARG-->BUT",1,1]
["ARG-->BUTBUTBUT",3,1]
["ARG-->BUT",1,1]
["ARG-->EVIDEVIDEVID",3,1]
["ARG-->",0,1,null,null,"COMPLETE THE FOLLOWING STEPS:"]
["ARG-->EVID",1,1,null,null,"1)","Enter a code to select a \"Given\" message category from list of Defined Codes."]
["ARG-->",0,1,null,null,"2) ","Enter a code to select a \"Target\" message category. Click column for more details."]
["ARG-->",0,1,null,null,"3) ","If you are planning to do an one factor ANOVA, enter group number in Factor1 column. "]
["ARG-->",0,1,null,null,null,"For a two-factor ANOVA, enter group numbers in both Factor 1 & 2 columns."]
["ARG-->",0,1,null,null,"4)","Click button below to tally the number of replies elicited per given message."]
["ARG-->",0,1]
["BUT-->BUT",1,2,null,null,"Tallies","Given","Target","Factor1","Factor2"]
["BUT-->",0,2,null,null,"1)","ARG","BUT",1,null,null,null,"Mean number of responses = ",{"$f":"AVERAGE(B:B)","v":0.31944444444444442}]
["BUT-->",0,2,null,null,"2)","ARG","EVID",1,null,null,null,"Standard deviation = ",{"$f":"STDEV(B:B)","v":0.76593657827559858}]
["BUT-->",0,2,null,null,"3)","ARG","EXPL",1,null,null,null,"n = ",{"$f":"COUNTA(B:B)","v":72}]
["BUT-->BUT",1,2,null,null,"4)","BUT","BUT",2]
["BUT-->",0,2,null,null,"5)","BUT","EVID",2]
["BUT-->BUT",1,2,null,null,"6)","BUT","EXPL",2]
["BUT-->",0,2,null,null,"7)"]
["BUT-->",0,2,null,null,"8)"]
["BUT-->",0,2,null,null,"9)"]
["BUT-->BUT",1,2,null,null,"10)"]
["BUT-->BUT",1,2,null,null,"11)"]
["BUT-->",0,2,null,null,"12)"]
["BUT-->",0,2,null,null,"13)"]
["BUT-->",0,2,null,null,"14)"]
["BUT-->",0,2,null,null,"15)"]
["BUT-->BUTBUT",2,2,null,null,"."]
["BUT-->",0,2,null,null,"."]
["BUT-->BUT",1,2,null,null,"."]
["BUT-->",0,2,null,null,"."]
["BUT-->",0,2,null,null,"."]
["BUT-->",0,2,null,null,"."]
["BUT-->",0,2,null,null,"."]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->EXPL",1,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->EXPL",1,2]
["BUT-->",0,2]
["BUT-->",0,2]
["BUT-->",0,2]

{"sheet":"1","index":6,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TRANSITIONAL State Diagram"]

{"sheet":"2","index":7,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"HISTORICAL State Diagram"]