{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["MainMenu","EnterCodes","EnterSequence","MakeMatrix","MakeDiagram","ResponseScores","1","2","Compare"],"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":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[21,4,24,13],[30,6,30,7]]}
[]
[]
[]
[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.986"]
[]
[null,"Copyright 2005-2012"]
[null,"All Rights Reserved"]
[null,"By Allan Jeong",null,null,"Access Code:"]
[]
[]
[]
[]
[]
[]
[]
[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"]
[null,null,null,null,"12/1/11 v1.97  Produces diagrams using nodes with varying sizes of  shadow/glow to reflect the node's frequency"]
[null,null,null,null,"12/6/11 1.9831 Produces 3-node diagrams in a right triangle configuration"]
[null,null,null,null,"1/26/12 1.9832 Corrected missing looping arrow for node #4"]
[null,null,null,null,"3/26/12 1.985 Font size of probabilities displayed in diagrams reduced from 6 to 5 so that probabilities of 100 are fully displayed "]
[null,null,null,null,"3/26/12 1.985 Also simplified make matrix function to copy diagram to worksheet with default worksheet name so minimize compatibility issues with excel on macs"]
[null,null,null,null,"3/26/12/1.986 Links in state diagrams are colored gray if probability is not significantly higher than expected based on z-scores"]
[null,null,null,null,"3/29/12 1.986 In EnterSequence worksheet, added button to insert new sequence numbers after each '1' entered in column B to mark first event of each thread/episode "]
[null,null,null,null,"3/29/12 1.986 In MakeMatrix worksheet, added function to hide blank rows & columns in matrices after selecting new critical z-score"]
[null,null,null,null,"3/29/12 1.986 In EnterCodes worksheet, added an adjacent column for inserting definitions/descriptions of each code"]

{"sheet":"EnterCodes","index":1,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[18,4,18,13],[19,4,19,13],[20,4,20,13],[23,2,24,11],[26,2,26,6],[1,2,2,10],[5,4,5,13],[6,4,6,13],[7,4,7,13],[8,4,8,13],[14,4,14,13],[15,4,15,13],[16,4,16,13],[17,4,17,13],[9,4,9,13],[10,4,10,13],[11,4,11,13],[12,4,12,13],[13,4,13,13]]}
[]
[null,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,null,"Codes","Description (optional)"]
[null,null,1,1]
[null,null,2,2]
[null,null,3,3]
[null,null,4,4]
[null,null,5,5]
[null,null,6,6]
[null,null,7,7]
[null,null,8,8]
[null,null,9,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":9}]

{"sheet":"EnterSequence","index":2,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,6,3,10]]}
[1,1]
[2,2]
[4,3]
[5,4]
[1,1]
[2,2]
[3,3,null,null,null,null,"Steps for Entering Coded Events:"]
[4,4,null,null,null,null,"1)               columns A, B & C"]
[2,1,null,null,null,null,"2) Enter codes into Column A",null,null,null,null,null,"(more info)"]
[1,2,null,null,null,null,"3) Enter sequence numbers or thread level in Column B",null,null,null,null,null,"(more info)"]
[4,3,null,null,null,null,"4) Optional: Enter event descriptions in Col. C",null,null,null,null,null,"(more info)"]
[4,4]
[1,1]
[2,2,null,null,null,null,"Functions for Formatting & Preparing Sequential and/or Multi-threaded Data"]
[3,3]
[2,4]
[5,5]
[2,6]
[5,7]
[4,8]
[1,1]
[2,2]

{"sheet":"MakeMatrix","index":3,"n_rows":74,"n_cols":43,"rows_kept":74,"cut":false,"hidden":false,"merged":[[21,24,21,32]]}
[null,"Frequency matrix",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,"instructionalsystemsfsu"]
[null,null,1,2,3,4,5,6,7,8,9,null,null,null,null,null,null,null,"Replies","No Replies","Givens","% replies","% givens",null,null,{"$f":"C2","v":1},2,3,4,5,6,7,8,9,0,0,0,0,0,0,0,{"$f":"T2","v":"No Replies"}]
[null,1,0,4,0,1,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C3:R3)+0.0001","v":5.0000999999999998},0,5,{"$f":"(S3-0.0001)/S$19","v":0.29408823823500008},{"$f":"U3/$U$19","v":0.22727272727272727},null,{"$f":"B3","v":1},null,"2 6 14 22 ",null,"11 "]
[null,2,1,0,2,1,2,0,0,0,0,0,0,0,0,0,0,0,6.0000999999999998,1,7,0.35290588588200011,0.31818181818181818,null,2,"10 ",null,"7 15 ","3 ","17 19 ",null,null,null,null,null,null,null,null,null,null,null,"22"]
[null,3,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,2.0001000000000002,0,2,0.11763529529400003,9.0909090909090912E-2,null,3,null,"16 ",null,"8 "]
[null,4,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,2.0001000000000002,3,5,0.11763529529400003,0.22727272727272727,null,4,null,null,null,"12 ","4 ",null,null,null,null,null,null,null,null,null,null,null," 8 12 20"]
[null,5,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,2.0001000000000002,1,3,0.11763529529400003,0.13636363636363635,null,{"$f":"B7","v":5},null,"18 ",null,"20 ",null,null,null,null,null,null,null,null,null,null,null,null," 4"]
[null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,6]
[null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,{"$f":"B9","v":7}]
[null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,8]
[null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1E-4,0,0,0,0,null,9]
[null,null,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,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,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,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,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,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,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":"COUNTA(B3:B18)","v":9},{"$f":"SUM(C3:C18)+0.0001","v":1.0001},6.0000999999999998,2.0001000000000002,5.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,{"$f":"SUM(S3:S18)+0.0001","v":17.001699999999996},{"$f":"SUM(T3:T18)","v":5},{"$f":"SUM(U3:U18)","v":22},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 probability matrix"]
[null,null,{"$f":"C2","v":1},2,3,4,5,6,7,8,9,0,0,0,0,0,0,0,"Replies","No Replies","Givens","Reply Rate"]
[null,{"$f":"B3","v":1},{"$f":"C3/$S3","v":0},0.79998400031999362,0,0.1999960000799984,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S3","v":5.0000999999999998},{"$f":"T3+0.0001","v":1E-4},5.0000999999999998,{"$f":"(U23-T23)/U23","v":0.99998000039999202}]
[null,2,{"$f":"C4/$S4","v":0.16666388893518441},0,0.33332777787036882,0.16666388893518441,0.33332777787036882,0,0,0,0,0,0,0,0,0,0,0,6.0000999999999998,1.0001,7.0000999999999998,0.85713061241982258]
[null,3,{"$f":"C5/$S5","v":0},0.49997500124993743,0,0.49997500124993743,0,0,0,0,0,0,0,0,0,0,0,0,2.0001000000000002,1E-4,2.0001000000000002,0.99995000249987487]
[null,4,{"$f":"C6/$S6","v":0},0,0,0.49997500124993743,0.49997500124993743,0,0,0,0,0,0,0,0,0,0,0,2.0001000000000002,3.0001000000000002,5.0000999999999998,0.39999200015999675]
[null,{"$f":"B7","v":5},{"$f":"C7/$S7","v":0},0.49997500124993743,0,0.49997500124993743,0,0,0,0,0,0,0,0,0,0,0,0,2.0001000000000002,1.0001,3.0001000000000002,0.66664444518516042]
[null,6,{"$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,{"$f":"B9","v":7},{"$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,8,{"$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,9,{"$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":1.0001},6.0000999999999998,2.0001000000000002,5.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,17.001699999999996,{"$f":"T19","v":5},{"$f":"U19","v":22},{"$f":"AVERAGE(V23:V38)","v":0.24523106629155289}]
[]
[null,"Z-Scores identify the probabilities that are higher/lower than expected"]
[null,null,{"$f":"C2","v":1},2,3,4,5,6,7,8,9,0,0,0,0,0,0,0," ",null,null,null,null,null,"Critical z-score =",null,null,1.96,"at p < .05"]
[null,{"$f":"B3","v":1},{"$f":"(C3-((C$19*$S3)/$S$19))/SQRT(((C$19*$S3)/$S$19)*(1-$S3/$S$19)*(1 - C$19/$S$19))","v":-0.66535887476442834},{"$f":"(D3-D$19*$S3/$S$19)/SQRT((D$19*$S3/$S$19)*(1-$S3/$S$19)*(1-D$19/$S$19))","v":2.4898823198314606},-0.97179130646558798,-0.54964251883060999,-1.2319553774485641,-6.4546254826435912E-3,-6.4546254826435912E-3,-6.4546254826435912E-3,-6.4546254826435912E-3,-6.4546254826435912E-3,-6.4546254826435912E-3,-6.4546254826435912E-3,-6.4546254826435912E-3,-6.4546254826435912E-3,-6.4546254826435912E-3,-6.4546254826435912E-3,{"$f":"S23","v":5.0000999999999998},null,null,null,null,null,"Z-score = 2.32 at .01 significance"]
[null,2,1.395621818513108,{"$f":"(D4-D$19*$S4/$S$19)/SQRT((D$19*$S4/$S$19)*(1-$S4/$S$19)*(1-D$19/$S$19))","v":-2.2487895383989129},2.0385358922546071,-0.85163478798791437,1.2530550224926129,-7.3850356504090685E-3,-7.3850356504090685E-3,-7.3850356504090685E-3,-7.3850356504090685E-3,-7.3850356504090685E-3,-7.3850356504090685E-3,-7.3850356504090685E-3,-7.3850356504090685E-3,-7.3850356504090685E-3,-7.3850356504090685E-3,-7.3850356504090685E-3,6.0000999999999998,null,null,null,null,null,"Z-score = 1.96 at .05 significance"]
[null,3,-0.37639448137435333,{"$f":"(D5-D$19*$S5/$S$19)/SQRT((D$19*$S5/$S$19)*(1-$S5/$S$19)*(1-D$19/$S$19))","v":0.46333224836264908},-0.54974375284424404,0.68030347076150943,-0.6969189454867829,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,2.0001000000000002,null,null,null,null,null,"Z-score = 1.64 at .10 significance"]
[null,4,-0.37639448137435333,{"$f":"(D6-D$19*$S6/$S$19)/SQRT((D$19*$S6/$S$19)*(1-$S6/$S$19)*(1-D$19/$S$19))","v":-1.1118713955293091},-0.54974375284424404,0.68030347076150943,1.2777176374206858,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,2.0001000000000002]
[null,{"$f":"B7","v":5},-0.37639448137435333,{"$f":"(D7-D$19*$S7/$S$19)/SQRT((D$19*$S7/$S$19)*(1-$S7/$S$19)*(1-D$19/$S$19))","v":0.46333224836264908},-0.54974375284424404,0.68030347076150943,-0.6969189454867829,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,-3.6513910058920966E-3,2.0001000000000002,null,"p108-109 Bakeman & Gottman (1997)"]
[null,6,-2.5000073522383893E-3,{"$f":"(D8-D$19*$S8/$S$19)/SQRT((D$19*$S8/$S$19)*(1-$S8/$S$19)*(1-D$19/$S$19))","v":-7.3850356504090685E-3},-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,1E-4,null,"where consec. codes may repeat"]
[null,{"$f":"B9","v":7},-2.5000073522383893E-3,{"$f":"(D9-D$19*$S9/$S$19)/SQRT((D$19*$S9/$S$19)*(1-$S9/$S$19)*(1-D$19/$S$19))","v":-7.3850356504090685E-3},-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,1E-4]
[null,8,-2.5000073522383893E-3,{"$f":"(D10-D$19*$S10/$S$19)/SQRT((D$19*$S10/$S$19)*(1-$S10/$S$19)*(1-D$19/$S$19))","v":-7.3850356504090685E-3},-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,1E-4]
[null,9,-2.5000073522383893E-3,{"$f":"(D11-D$19*$S11/$S$19)/SQRT((D$19*$S11/$S$19)*(1-$S11/$S$19)*(1-D$19/$S$19))","v":-7.3850356504090685E-3},-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,1E-4]
[null,0,-2.5000073522383893E-3,{"$f":"(D12-D$19*$S12/$S$19)/SQRT((D$19*$S12/$S$19)*(1-$S12/$S$19)*(1-D$19/$S$19))","v":-7.3850356504090685E-3},-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,1E-4]
[null,0,-2.5000073522383893E-3,{"$f":"(D13-D$19*$S13/$S$19)/SQRT((D$19*$S13/$S$19)*(1-$S13/$S$19)*(1-D$19/$S$19))","v":-7.3850356504090685E-3},-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,1E-4]
[null,0,-2.5000073522383893E-3,{"$f":"(D14-D$19*$S14/$S$19)/SQRT((D$19*$S14/$S$19)*(1-$S14/$S$19)*(1-D$19/$S$19))","v":-7.3850356504090685E-3},-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,1E-4]
[null,0,-2.5000073522383893E-3,{"$f":"(D15-D$19*$S15/$S$19)/SQRT((D$19*$S15/$S$19)*(1-$S15/$S$19)*(1-D$19/$S$19))","v":-7.3850356504090685E-3},-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,1E-4]
[null,0,-2.5000073522383893E-3,{"$f":"(D16-D$19*$S16/$S$19)/SQRT((D$19*$S16/$S$19)*(1-$S16/$S$19)*(1-D$19/$S$19))","v":-7.3850356504090685E-3},-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,1E-4]
[null,0,-2.5000073522383893E-3,{"$f":"(D17-D$19*$S17/$S$19)/SQRT((D$19*$S17/$S$19)*(1-$S17/$S$19)*(1-D$19/$S$19))","v":-7.3850356504090685E-3},-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,1E-4]
[null,0,-2.5000073522383893E-3,{"$f":"(D18-D$19*$S18/$S$19)/SQRT((D$19*$S18/$S$19)*(1-$S18/$S$19)*(1-D$19/$S$19))","v":-7.3850356504090685E-3},-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,-2.4252492563907618E-5,1E-4]
[null,null,{"$f":"C39","v":1.0001},6.0000999999999998,2.0001000000000002,5.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,17.001699999999996]
[]
[]
[]
[null,null,{"$f":"$S3/COUNTA($C$2:$R$2)","v":0.55556666666666665},0.55556666666666665,0.55556666666666665,0.55556666666666665,0.55556666666666665,0.55556666666666665,0.55556666666666665,0.55556666666666665,0.55556666666666665,0.55556666666666665,0.55556666666666665,null,null,null,null,{"$f":"$S3/COUNTA($C$2:$R$2)","v":0.55556666666666665}]
[null,null,{"$f":"$S4/COUNTA($C$2:$R$2)","v":0.6666777777777777},0.6666777777777777,0.6666777777777777,0.6666777777777777,0.6666777777777777,0.6666777777777777,0.6666777777777777,0.6666777777777777,0.6666777777777777,0.6666777777777777,0.6666777777777777,null,null,null,null,0.6666777777777777]
[null,null,{"$f":"$S5/COUNTA($C$2:$R$2)","v":0.22223333333333337},0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,null,null,null,null,0.22223333333333337]
[null,null,{"$f":"$S6/COUNTA($C$2:$R$2)","v":0.22223333333333337},0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,null,null,null,null,0.22223333333333337]
[null,null,{"$f":"$S7/COUNTA($C$2:$R$2)","v":0.22223333333333337},0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,0.22223333333333337,null,null,null,null,0.22223333333333337]
[null,null,{"$f":"$S8/COUNTA($C$2:$R$2)","v":1.1111111111111112E-5},1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,null,null,null,null,1.1111111111111112E-5]
[null,null,{"$f":"$S9/COUNTA($C$2:$R$2)","v":1.1111111111111112E-5},1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,null,null,null,null,1.1111111111111112E-5]
[null,null,{"$f":"$S10/COUNTA($C$2:$R$2)","v":1.1111111111111112E-5},1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,null,null,null,null,1.1111111111111112E-5]
[null,null,{"$f":"$S11/COUNTA($C$2:$R$2)","v":1.1111111111111112E-5},1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,null,null,null,null,1.1111111111111112E-5]
[null,null,{"$f":"$S12/COUNTA($C$2:$R$2)","v":1.1111111111111112E-5},1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,null,null,null,null,1.1111111111111112E-5]
[null,null,{"$f":"$S13/COUNTA($C$2:$R$2)","v":1.1111111111111112E-5},1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,null,null,null,null,1.1111111111111112E-5]
[null,null,{"$f":"$S18/COUNTA($C$2:$R$2)","v":1.1111111111111112E-5},1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,1.1111111111111112E-5,null,null,null,null,{"$f":"$S18/COUNTA($C$2:$R$2)","v":1.1111111111111112E-5}]

{"sheet":"MakeDiagram","index":4,"n_rows":86,"n_cols":38,"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,null,null,null,null,null,null,null,null,null,null,null,"Z-Score Matrix"]
[null,null,{"$f":"B3","v":1},{"$f":"B4","v":2},{"$f":"B5","v":3},{"$f":"B6","v":4},{"$f":"B7","v":5},{"$f":"B8","v":6},null,null,{"$f":"C2","v":1},2,3,4,5,6,null,null,{"$f":"C2","v":1},2,3,4,5,6,null,"Givens",null,null,null,null,null,null,{"$f":"C2","v":1},2,3,4,5,6]
[null,1,0,4,0,1,0,0,{"$f":"SUM(C3:H3)+0.0001","v":5.0000999999999998},{"$f":"B3","v":1},{"$f":"C3/$I3","v":0},0.79998400031999362,0,0.1999960000799984,0,0,null,{"$f":"B3","v":1},{"$f":"C3/C$9","v":0},0.66665555574073765,0,0.1999960000799984,0,0,null,5,null,null,null,null,null,{"$f":"B3","v":1},-0.66535887476442834,2.4898823198314606,-0.97179130646558798,-0.54964251883060999,-1.2319553774485641,-6.4546254826435912E-3]
[null,2,1,0,2,1,2,0,{"$f":"SUM(C4:H4)+0.0001","v":6.0000999999999998},2,0.16666388893518441,0,0.33332777787036882,0.16666388893518441,0.33332777787036882,0,null,2,0.99990000999900008,0,0.99995000249987487,0.1999960000799984,0.66664444518516042,0,null,7,null,null,null,null,null,2,1.395621818513108,-2.2487895383989129,2.0385358922546071,-0.85163478798791437,1.2530550224926129,-7.3850356504090685E-3]
[null,3,0,1,0,1,0,0,2.0001000000000002,3,0,0.49997500124993743,0,0.49997500124993743,0,0,null,3,0,0.16666388893518441,0,0.1999960000799984,0,0,null,2,null,null,null,null,null,3,-0.37639448137435333,0.46333224836264908,-0.54974375284424404,0.68030347076150943,-0.6969189454867829,-3.6513910058920966E-3]
[null,4,0,0,0,1,1,0,2.0001000000000002,4,0,0,0,0.49997500124993743,0.49997500124993743,0,null,4,0,0,0,0.1999960000799984,0.33332222259258021,0,null,5,null,null,null,null,null,4,-0.37639448137435333,-1.1118713955293091,-0.54974375284424404,0.68030347076150943,1.2777176374206858,-3.6513910058920966E-3]
[null,5,0,1,0,1,0,0,2.0001000000000002,5,0,0.49997500124993743,0,0.49997500124993743,0,0,null,5,0,0.16666388893518441,0,0.1999960000799984,0,0,null,3,null,null,null,null,null,5,-0.37639448137435333,0.46333224836264908,-0.54974375284424404,0.68030347076150943,-0.6969189454867829,-3.6513910058920966E-3]
[null,6,0,0,0,0,0,0,1E-4,6,0,0,0,0,0,0,null,6,0,0,0,0,0,0,null,0,null,null,null,null,null,6,-2.5000073522383893E-3,-7.3850356504090685E-3,-3.6513910058920966E-3,-6.4546254826435912E-3,-4.6289267612782256E-3,-2.4252492563907618E-5]
[null,{"$f":"COUNTA(B3:B8)","v":6},{"$f":"SUM(C3:C8)+0.0001","v":1.0001},6.0000999999999998,2.0001000000000002,5.0000999999999998,3.0001000000000002,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) "]
[]
[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":6}]

{"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":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TRANSITIONAL State Diagram"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4]

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

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