{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tetrachoric Calculator","Data Conversion","Sample Data"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":0,"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":"Tetrachoric Calculator","index":0,"n_rows":1006,"n_cols":10,"rows_kept":1006,"cut":false,"hidden":false,"merged":[[13,8,13,9],[11,7,11,9],[0,3,0,7],[1,2,1,8],[3,0,3,12],[7,6,8,6],[5,8,5,9],[5,3,9,4]]}
[null,null,null,"Tetrachoric Correlation Calculator"]
[null,null,"Developed by Jeffrey S. Kane, Ph.D., Professional Statistical Services"]
[]
["Directions: Enter your individual observations on the 2 variables in Columns X and Y, below. Enter only values of 1 (Low or False) or 2 (High or True) as individual observation values. You may also enter cell totals in the four red-outlined cells at the top of the X and Y columns. Your N should be at least 40. You can dichotomize continous data on in the Data Conversion tab."]
[]
["Observation","X","Y","To calculate the tetrachoric directly on cell totals, enter those totals in the outlined cells to the left, following the cell definitions shown at the right.",null,null,"A","B","X"]
[{"$f":"IF(COUNT(B7:C7) =2,1,\"\")","v":""},null,null,null,null,null,"C","D","High/True","Low/False"]
[{"$f":"IF(COUNT(B8:C8) =2,ROWS(A8:A8)+7:7,\"\")","v":""},null,null,null,null,null,"Y","High/True",{"$f":"IF(COUNT($B$9:$C$1006)=0,$B$7,COUNTIFS($B$7:$B$1006,2,$C$7:$C$1006,2))","v":0},{"$f":"IF(COUNT($B$9:$C$1006)=0,$C$7,COUNTIFS($B$7:$B$1006,1,$C$7:$C$1006,2))","v":0}]
[{"$f":"IF(COUNT(B9:C9) =2,ROWS(A9:A9)+8:8,\"\")","v":""},null,null,null,null,null,null,"Low/False",{"$f":"IF(COUNT($B$9:$C$1006)=0,$B$8,COUNTIFS($B$7:$B$1006,2,$C$7:$C$1006,1))","v":0},{"$f":"IF(COUNT($B$9:$C$1006)=0,$C$8,COUNTIFS($B$7:$B$1006,1,$C$7:$C$1006,1))","v":0}]
[{"$f":"IF(COUNT(B10:C10) =2,ROWS(A10:A10)+9:9,\"\")","v":""}]
[{"$f":"IF(COUNT(B11:C11) =2,ROWS(A11:A11)+10:10,\"\")","v":""}]
["",null,null,null,null,null,null,"Tetrachoric correlation = "]
["",null,null,null,null,null,null,null,null,"p ="]
["",null,null,null,null,null,null,null,"Standard error ="]
[""]
["",null,null,"Note: To the best of my knowledge, back in 1997 I was the first to translate Morton Brown's AS 116 algorithm for "]
["",null,null,"computing tetrachoric correlation from its original Fortran code into an SPSS macro. Several others havethe"]
["",null,null,"used that effort as the basis for porting the algorithm to other source code types. Among these was"]
["",null,null,"Saranga Komanduri, whose Visual Basic-like code was very well done. I modified it to work completely "]
["",null,null,"within Excel with no external routines, and it is the backend of this attempt to make tetrachoric correlation"]
["",null,null,"more easily accessible to researchers and other statistics users. I would also call the reader's attention"]
["",null,null,"to some more recent advances in computing this statistic reported by Bonett & Price (2005) in the "]
["",null,null,"Journal of Educational and Behavioral Statistics."]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B75:C75) =2,ROWS(A75:A75)+74:74,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B139:C139) =2,ROWS(A139:A139)+138:138,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B203:C203) =2,ROWS(A203:A203)+202:202,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B267:C267) =2,ROWS(A267:A267)+266:266,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B331:C331) =2,ROWS(A331:A331)+330:330,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B395:C395) =2,ROWS(A395:A395)+394:394,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B459:C459) =2,ROWS(A459:A459)+458:458,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B523:C523) =2,ROWS(A523:A523)+522:522,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B587:C587) =2,ROWS(A587:A587)+586:586,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B651:C651) =2,ROWS(A651:A651)+650:650,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B715:C715) =2,ROWS(A715:A715)+714:714,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B779:C779) =2,ROWS(A779:A779)+778:778,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B843:C843) =2,ROWS(A843:A843)+842:842,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B907:C907) =2,ROWS(A907:A907)+906:906,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(COUNT(B971:C971) =2,ROWS(A971:A971)+970:970,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Data Conversion","index":1,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[17,9,17,10],[19,7,20,7],[17,7,18,8],[0,0,0,14],[13,1,13,2],[13,4,13,10],[13,12,13,13],[14,5,14,9],[15,5,15,9]]}
["Convert your continuous or interval scaled data to dichotomous using this worksheet."]
[]
["Directions:"]
[null,"1. Enter your data in the X and Y columns below."]
[null,"2. Decide on the cutpoint at which you want to dichotomize  the data for each variable, and enter them in the boxes the right."]
[null,"3 . Click the \"Dichotomize\" button to perform the dichotomization."]
[null,"4. Inspect the frequency distribution of the resulting cross-tabulated cells."]
[null,"5. If you are satisfied with the distributions of the dichotomized variables, click the \"Transfer to Calculator\" button. This will"]
[null,"transfer your dichotomized data to the data columns of the Tetrachoric Calculator. You may then go that worksheet and run"]
[null,"the correlation."]
[null,"6. If you are not satisfied with the results of the dichotomization, you may change the cutpoints and redo the process as many"]
[null,"times as you wish."]
[]
[null,"Your Raw Data",null,null,"Cut Points",null,null,null,null,null,null,null,"Dichotomized Data"]
[null,"X","Y",null,"X: ","Values at or above this will be considered High:",null,null,null,null,null,null,"X","Y"]
[null,null,null,null,"Y: ","Values at or above this will be considered High:"]
[]
[null,null,null,null,null,null,null,"Results of Dichotomization",null,"X"]
[null,null,null,null,null,null,null,null,null,"High","Low"]
[null,null,null,null,null,null,null,"Y","High",{"$f":"COUNTIFS($M$16:$M$1015,2,$N$16:$N$1015,2)","v":0},{"$f":"COUNTIFS($M$16:$M$1015,1,$N$16:$N$1015,2)","v":0}]
[null,null,null,null,null,null,null,null,"Low",{"$f":"COUNTIFS($M$16:$M$1015,2,$N$16:$N$1015,1)","v":0},{"$f":"COUNTIFS($M$16:$M$1015,1,$N$16:$N$1015,1)","v":0}]

{"sheet":"Sample Data","index":2,"n_rows":710,"n_cols":7,"rows_kept":710,"cut":false,"hidden":false,"merged":[[7,5,7,6],[0,4,0,7]]}
[null,null,null,null,"Sample Data Set"]
[]
[null,"The sample data set below is provided to enable you to try out the data conversion process."]
[null,"Simply click the green button to copy the two columns of data below to the X and Y columns "]
[null,"in the Data Conversion worksheet."]
[]
[]
[null,null,null,null,null,"Sample Raw Data"]
[null,null,null,null,"Case #","X","Y"]
[null,null,null,null,1,6,87]
[null,null,null,null,2,3,83]
[null,null,null,null,3,9,97]
[null,null,null,null,4,9,87]
[null,null,null,null,5,9,108]
[null,null,null,null,6,10,112]
[null,null,null,null,7,2,102]
[null,null,null,null,8,7,103]
[null,null,null,null,9,7,107]
[null,null,null,null,10,6,56]
[null,null,null,null,11,5,81]
[null,null,null,null,12,9,23]
[null,null,null,null,13,3,73]
[null,null,null,null,14,9,113]
[null,null,null,null,15,6,64]
[null,null,null,null,16,4,90]
[null,null,null,null,17,3,109]
[null,null,null,null,18,6,109]
[null,null,null,null,19,8,83]
[null,null,null,null,20,5,74]
[null,null,null,null,21,7,103]
[null,null,null,null,22,1,100]
[null,null,null,null,23,7,92]
[null,null,null,null,24,7,85]
[null,null,null,null,25,3,90]
[null,null,null,null,26,4,108]
[null,null,null,null,27,8,93]
[null,null,null,null,28,5,91]
[null,null,null,null,29,4,115]
[null,null,null,null,30,9,107]
[null,null,null,null,31,3,100]
[null,null,null,null,32,9,115]
[null,null,null,null,33,7,73]
[null,null,null,null,34,1,103]
[null,null,null,null,35,8,84]
[null,null,null,null,36,5,89]
[null,null,null,null,37,9,117]
[null,null,null,null,38,10,104]
[null,null,null,null,39,3,95]
[null,null,null,null,40,3,83]
[null,null,null,null,41,3,96]
[null,null,null,null,42,9,72]
[null,null,null,null,43,1,107]
[null,null,null,null,44,3,92]
[null,null,null,null,45,1,81]
[null,null,null,null,46,8,105]
[null,null,null,null,47,9,103]
[null,null,null,null,48,1,101]
[null,null,null,null,49,9,66]
[null,null,null,null,50,9,101]
[null,null,null,null,51,10,100]
[null,null,null,null,52,10,105]
[null,null,null,null,53,10,101]
[null,null,null,null,54,10,116]
[null,null,null,null,55,7,97]
[null,null,null,null,56,1,69]
[null,null,null,null,57,3,58]
[null,null,null,null,58,8,66]
[null,null,null,null,59,2,53]
[null,null,null,null,60,4,84]
[null,null,null,null,61,4,98]
[null,null,null,null,62,7,115]
[null,null,null,null,63,9,117]
[null,null,null,null,64,10,104]
[null,null,null,null,65,3,95]
[null,null,null,null,66,8,100]
[null,null,null,null,67,8,84]
[null,null,null,null,68,1,92]
[null,null,null,null,69,7,106]
[null,null,null,null,70,3,82]
[null,null,null,null,71,null,63]
[null,null,null,null,72,9,94]
[null,null,null,null,73,7,93]
[null,null,null,null,74,8,105]
[null,null,null,null,75,3,82]
[null,null,null,null,76,3,113]
[null,null,null,null,77,5,81]
[null,null,null,null,78,9,23]
[null,null,null,null,79,3,73]
[null,null,null,null,80,9,113]
[null,null,null,null,81,6,65]
[null,null,null,null,82,3,58]
[null,null,null,null,83,8,66]
[null,null,null,null,84,2,53]
[null,null,null,null,85,4,98]
[null,null,null,null,86,7,115]
[null,null,null,null,87,2,30]
[null,null,null,null,88,9,112]
[null,null,null,null,89,8,103]
[null,null,null,null,90,9,108]
[null,null,null,null,91,8,111]
[null,null,null,null,92,3,76]
[null,null,null,null,93,4,109]
[null,null,null,null,94,4,82]
[null,null,null,null,95,7,101]
[null,null,null,null,96,4,59]
[null,null,null,null,97,7,70]
[null,null,null,null,98,7,103]
[null,null,null,null,99,5,74]
[null,null,null,null,100,8,83]
[null,null,null,null,101,6,109]
[null,null,null,null,102,3,109]
[null,null,null,null,103,4,90]
[null,null,null,null,104,10,108]
[null,null,null,null,105,9,90]
[null,null,null,null,106,3,94]
[null,null,null,null,107,9,105]
[null,null,null,null,108,4,98]
[null,null,null,null,109,10,80]
[null,null,null,null,110,8,114]
[null,null,null,null,111,5,107]
[null,null,null,null,112,8,82]
[null,null,null,null,113,8,73]
[null,null,null,null,114,null,57]
[null,null,null,null,115,2,99]
[null,null,null,null,116,10,117]
[null,null,null,null,117,7]
[null,null,null,null,118,9,96]
[null,null,null,null,119,5,92]
[null,null,null,null,120,6,79]
[null,null,null,null,121,2,97]
[null,null,null,null,122,3,90]
[null,null,null,null,123,3,103]
[null,null,null,null,124,4,92]
[null,null,null,null,125,10,103]
[null,null,null,null,126,8,113]
[null,null,null,null,127,9]
[null,null,null,null,128,1,73]
[null,null,null,null,129,3,108]
[null,null,null,null,130,5,90]
[null,null,null,null,131,10,76]
[null,null,null,null,132,4,69]
[null,null,null,null,133,5,110]
[null,null,null,null,134,4,105]
[null,null,null,null,135,8,111]
[null,null,null,null,136,4,86]
[null,null,null,null,137,4,101]
[null,null,null,null,138,10,93]
[null,null,null,null,139,3,103]
[null,null,null,null,140,5,91]
[null,null,null,null,141,10,103]
[null,null,null,null,142,10,89]
[null,null,null,null,143,8,108]
[null,null,null,null,144,8,98]
[null,null,null,null,145,1,86]
[null,null,null,null,146,9,100]
[null,null,null,null,147,9,105]
[null,null,null,null,148,10,112]
[null,null,null,null,149,8,105]
[null,null,null,null,150,9,113]
[null,null,null,null,151,3,92]
[null,null,null,null,152,7,90]
[null,null,null,null,153,3,83]
[null,null,null,null,154,10,110]
[null,null,null,null,155,7,114]
[null,null,null,null,156,4,58]
[null,null,null,null,157,4,56]
[null,null,null,null,158,6,67]
[null,null,null,null,159,8,69]
[null,null,null,null,160,5,71]
[null,null,null,null,161,8,76]
[null,null,null,null,162,7,78]
[null,null,null,null,163,8,73]
[null,null,null,null,164,5,71]
[null,null,null,null,165,7,71]
[null,null,null,null,166,7,74]
[null,null,null,null,167,8,103]
[null,null,null,null,168,4,58]
[null,null,null,null,169,5,89]
[null,null,null,null,170,10]
[null,null,null,null,171,3,75]
[null,null,null,null,172,3,63]
[null,null,null,null,173,4,74]
[null,null,null,null,174,7,68]
[null,null,null,null,175,8,86]
[null,null,null,null,176,10,102]
[null,null,null,null,177,4,72]
[null,null,null,null,178,1,56]
[null,null,null,null,179,5,94]
[null,null,null,null,180,8,88]
[null,null,null,null,181,7,61]
[null,null,null,null,182,8,87]
[null,null,null,null,183,3,32]
[null,null,null,null,184,5,88]
[null,null,null,null,185,9,85]
[null,null,null,null,186,2,85]
[null,null,null,null,187,7,101]
[null,null,null,null,188,5,72]
[null,null,null,null,189,5,94]
[null,null,null,null,190,5,88]
[null,null,null,null,191,4,94]
[null,null,null,null,192,7,95]
[null,null,null,null,193,8,105]
[null,null,null,null,194,1,53]
[null,null,null,null,195,9,88]
[null,null,null,null,196,9,105]
[null,null,null,null,197,10,100]
[null,null,null,null,198,5,108]
[null,null,null,null,199,6,93]
[null,null,null,null,200,4,72]
[null,null,null,null,201,3,99]
[null,null,null,null,202,2,96]
[null,null,null,null,203,3,66]
[null,null,null,null,204,2,98]
[null,null,null,null,205,9,87]
[null,null,null,null,206,8,111]
[null,null,null,null,207,4,70]
[null,null,null,null,208,7,94]
[null,null,null,null,209,9,112]
[null,null,null,null,210,10,100]
[null,null,null,null,211,3,88]
[null,null,null,null,212,7,89]
[null,null,null,null,213,5,83]
[null,null,null,null,214,10,106]
[null,null,null,null,215,6,101]
[null,null,null,null,216,8,93]
[null,null,null,null,217,9,110]
[null,null,null,null,218,4,93]
[null,null,null,null,219,3,97]
[null,null,null,null,220,7,99]
[null,null,null,null,221,8,86]
[null,null,null,null,222,7,104]
[null,null,null,null,223,4,107]
[null,null,null,null,224,9,75]
[null,null,null,null,225,9]
[null,null,null,null,226,8,92]
[null,null,null,null,227,9,76]
[null,null,null,null,228,7,84]
[null,null,null,null,229,6,63]
[null,null,null,null,230,4,92]
[null,null,null,null,231,8,113]
[null,null,null,null,232,9,110]
[null,null,null,null,233,5,96]
[null,null,null,null,234,5,64]
[null,null,null,null,235,9,74]
[null,null,null,null,236,9,112]
[null,null,null,null,237,9,82]
[null,null,null,null,238,10,97]
[null,null,null,null,239,6,109]
[null,null,null,null,240,10,85]
[null,null,null,null,241,8,108]
[null,null,null,null,242,2,64]
[null,null,null,null,243,7,101]
[null,null,null,null,244,3,78]
[null,null,null,null,245,7,104]
[null,null,null,null,246,3,81]
[null,null,null,null,247,6,113]
[null,null,null,null,248,9,107]
[null,null,null,null,249,8,74]
[null,null,null,null,250,4,94]
[null,null,null,null,251,6,85]
[null,null,null,null,252,7,111]
[null,null,null,null,253,9,110]
[null,null,null,null,254,4,117]
[null,null,null,null,255,8,103]
[null,null,null,null,256,4,103]
[null,null,null,null,257,4,75]
[null,null,null,null,258,1,78]
[null,null,null,null,259,5,98]
[null,null,null,null,260,8,93]
[null,null,null,null,261,7,79]
[null,null,null,null,262,5,105]
[null,null,null,null,263,5,109]
[null,null,null,null,264,5,83]
[null,null,null,null,265,3]
[null,null,null,null,266,5,104]
[null,null,null,null,267,2]
[null,null,null,null,268,4]
[null,null,null,null,269,2,62]
[null,null,null,null,270,4,56]
[null,null,null,null,271,9,84]
[null,null,null,null,272,4,68]
[null,null,null,null,273,3,54]
[null,null,null,null,274,10,105]
[null,null,null,null,275,3]
[null,null,null,null,276,7]
[null,null,null,null,277,2,83]
[null,null,null,null,278,4,102]
[null,null,null,null,279,7,71]
[null,null,null,null,280,8,93]
[null,null,null,null,281,9,116]
[null,null,null,null,282,8,102]
[null,null,null,null,283,7,98]
[null,null,null,null,284,10,108]
[null,null,null,null,285,8,85]
[null,null,null,null,286,4,115]
[null,null,null,null,287,7,102]
[null,null,null,null,288,2,94]
[null,null,null,null,289,1,78]
[null,null,null,null,290,8,41]
[null,null,null,null,291,3,72]
[null,null,null,null,292,1,80]
[null,null,null,null,293,9,110]
[null,null,null,null,294,5,67]
[null,null,null,null,295,6,88]
[null,null,null,null,296,7,98]
[null,null,null,null,297,8,117]
[null,null,null,null,298,10,119]
[null,null,null,null,299,8,117]
[null,null,null,null,300,8,117]
[null,null,null,null,301,7,112]
[null,null,null,null,302,10,107]
[null,null,null,null,303,10,119]
[null,null,null,null,304,9,111]
[null,null,null,null,305,4,116]
[null,null,null,null,306,8,115]
[null,null,null,null,307,9,89]
[null,null,null,null,308,8,77]
[null,null,null,null,309,9,96]
[null,null,null,null,310,5,85]
[null,null,null,null,311,8,56]
[null,null,null,null,312,5,85]
[null,null,null,null,313,6,68]
[null,null,null,null,314,5]
[null,null,null,null,315,8,64]
[null,null,null,null,316,3,94]
[null,null,null,null,317,5,100]
[null,null,null,null,318,8,85]
[null,null,null,null,319,8]
[null,null,null,null,320,9,114]
[null,null,null,null,321,3,56]
[null,null,null,null,322,8,60]
[null,null,null,null,323,2,63]
[null,null,null,null,324,4,76]
[null,null,null,null,325,3,101]
[null,null,null,null,326,5,62]
[null,null,null,null,327,4,116]
[null,null,null,null,328,4,70]
[null,null,null,null,329,3,102]
[null,null,null,null,330,7]
[null,null,null,null,331,3,109]
[null,null,null,null,332,7,88]
[null,null,null,null,333,8,95]
[null,null,null,null,334,7,95]
[null,null,null,null,335,4,61]
[null,null,null,null,336,9,110]
[null,null,null,null,337,8,92]
[null,null,null,null,338,3]
[null,null,null,null,339,7,68]
[null,null,null,null,340,1,80]
[null,null,null,null,341,10,106]
[null,null,null,null,342,8,102]
[null,null,null,null,343,7,71]
[null,null,null,null,344,4,104]
[null,null,null,null,345,4,86]
[null,null,null,null,346,9,92]
[null,null,null,null,347,5,91]
[null,null,null,null,348,8,103]
[null,null,null,null,349,6,78]
[null,null,null,null,350,4,107]
[null,null,null,null,351,2,91]
[null,null,null,null,352,8,91]
[null,null,null,null,353,4,50]
[null,null,null,null,354,2,95]
[null,null,null,null,355,1,86]
[null,null,null,null,356,3,79]
[null,null,null,null,357,5,111]
[null,null,null,null,358,3,88]
[null,null,null,null,359,3,89]
[null,null,null,null,360,4,98]
[null,null,null,null,361,5,94]
[null,null,null,null,362,4,60]
[null,null,null,null,363,9,88]
[null,null,null,null,364,9,111]
[null,null,null,null,365,4,77]
[null,null,null,null,366,2,77]
[null,null,null,null,367,9,83]
[null,null,null,null,368,4,80]
[null,null,null,null,369,4,75]
[null,null,null,null,370,2,93]
[null,null,null,null,371,8,68]
[null,null,null,null,372,2,85]
[null,null,null,null,373,5,63]
[null,null,null,null,374,4,117]
[null,null,null,null,375,3,80]
[null,null,null,null,376,2,94]
[null,null,null,null,377,3,111]
[null,null,null,null,378,2,72]
[null,null,null,null,379,5,89]
[null,null,null,null,380,1,107]
[null,null,null,null,381,1,95]
[null,null,null,null,382,7,96]
[null,null,null,null,383,4,84]
[null,null,null,null,384,7,102]
[null,null,null,null,385,8,97]
[null,null,null,null,386,10,51]
[null,null,null,null,387,2,104]
[null,null,null,null,388,3,112]
[null,null,null,null,389,2,110]
[null,null,null,null,390,1,77]
[null,null,null,null,391,10,76]
[null,null,null,null,392,4,113]
[null,null,null,null,393,7,118]
[null,null,null,null,394,10,95]
[null,null,null,null,395,10,45]
[null,null,null,null,396,9,93]
[null,null,null,null,397,8,52]
[null,null,null,null,398,7,89]
[null,null,null,null,399,7,92]
[null,null,null,null,400,4,90]
[null,null,null,null,401,10,73]
[null,null,null,null,402,2,43]
[null,null,null,null,403,5,102]
[null,null,null,null,404,6,83]
[null,null,null,null,405,8,95]
[null,null,null,null,406,2,99]
[null,null,null,null,407,1,111]
[null,null,null,null,408,8,102]
[null,null,null,null,409,10,85]
[null,null,null,null,410,9,106]
[null,null,null,null,411,8,101]
[null,null,null,null,412,9,77]
[null,null,null,null,413,6,102]
[null,null,null,null,414,4,80]
[null,null,null,null,415,4,78]
[null,null,null,null,416,5,60]
[null,null,null,null,417,9,86]
[null,null,null,null,418,3,73]
[null,null,null,null,419,7,88]
[null,null,null,null,420,1,72]
[null,null,null,null,421,6,111]
[null,null,null,null,422,2,61]
[null,null,null,null,423,9,91]
[null,null,null,null,424,4,88]
[null,null,null,null,425,4,82]
[null,null,null,null,426,4,107]
[null,null,null,null,427,3,85]
[null,null,null,null,428,8,104]
[null,null,null,null,429,3,53]
[null,null,null,null,430,7,115]
[null,null,null,null,431,5,68]
[null,null,null,null,432,8,96]
[null,null,null,null,433,9,95]
[null,null,null,null,434,9,92]
[null,null,null,null,435,8,89]
[null,null,null,null,436,9,69]
[null,null,null,null,437,1,90]
[null,null,null,null,438,7,86]
[null,null,null,null,439,5,84]
[null,null,null,null,440,3,94]
[null,null,null,null,441,7,102]
[null,null,null,null,442,4,75]
[null,null,null,null,443,5,82]
[null,null,null,null,444,10,96]
[null,null,null,null,445,4,74]
[null,null,null,null,446,1,87]
[null,null,null,null,447,8,112]
[null,null,null,null,448,1]
[null,null,null,null,449,3]
[null,null,null,null,450,2,71]
[null,null,null,null,451,9,101]
[null,null,null,null,452,7,104]
[null,null,null,null,453,4,94]
[null,null,null,null,454,7,100]
[null,null,null,null,455,7,95]
[null,null,null,null,456,8,80]
[null,null,null,null,457,6,66]
[null,null,null,null,458,8,81]
[null,null,null,null,459,5,97]
[null,null,null,null,460,4,119]
[null,null,null,null,461,9]
[null,null,null,null,462,3,64]
[null,null,null,null,463,6,75]
[null,null,null,null,464,3,71]
[null,null,null,null,465,4,104]
[null,null,null,null,466,4,85]
[null,null,null,null,467,1]
[null,null,null,null,468,5,92]
[null,null,null,null,469,10,102]
[null,null,null,null,470,7,98]
[null,null,null,null,471,1,60]
[null,null,null,null,472,8,93]
[null,null,null,null,473,4,105]
[null,null,null,null,474,5,81]
[null,null,null,null,475,1,76]
[null,null,null,null,476,9,80]
[null,null,null,null,477,2,105]
[null,null,null,null,478,5,95]
[null,null,null,null,479,3,97]
[null,null,null,null,480,2,67]
[null,null,null,null,481,3,104]
[null,null,null,null,482,5,70]
[null,null,null,null,483,2,81]
[null,null,null,null,484,7,78]
[null,null,null,null,485,8]
[null,null,null,null,486,8,89]
[null,null,null,null,487,3,65]
[null,null,null,null,488,10,110]
[null,null,null,null,489,7,86]
[null,null,null,null,490,9,111]
[null,null,null,null,491,10,106]
[null,null,null,null,492,10,86]
[null,null,null,null,493,8,94]
[null,null,null,null,494,3,102]
[null,null,null,null,495,5,92]
[null,null,null,null,496,9,91]
[null,null,null,null,497,7,99]
[null,null,null,null,498,4,94]
[null,null,null,null,499,10,112]
[null,null,null,null,500,10,92]
[null,null,null,null,501,7,74]
[null,null,null,null,502,8,100]
[null,null,null,null,503,10,94]
[null,null,null,null,504,3,97]
[null,null,null,null,505,4,83]
[null,null,null,null,506,4,83]
[null,null,null,null,507,5,110]
[null,null,null,null,508,9,81]
[null,null,null,null,509,3,78]
[null,null,null,null,510,1,53]
[null,null,null,null,511,4,98]
[null,null,null,null,512,8,79]
[null,null,null,null,513,9,59]
[null,null,null,null,514,3,68]
[null,null,null,null,515,9,76]
[null,null,null,null,516,3,86]
[null,null,null,null,517,9,93]
[null,null,null,null,518,9,115]
[null,null,null,null,519,7,104]
[null,null,null,null,520,4,77]
[null,null,null,null,521,4]
[null,null,null,null,522,5,87]
[null,null,null,null,523,8,90]
[null,null,null,null,524,5,85]
[null,null,null,null,525,6,87]
[null,null,null,null,526,9,108]
[null,null,null,null,527,8,91]
[null,null,null,null,528,2,96]
[null,null,null,null,529,10]
[null,null,null,null,530,3,91]
[null,null,null,null,531,9,82]
[null,null,null,null,532,9,107]
[null,null,null,null,533,10,93]
[null,null,null,null,534,10,114]
[null,null,null,null,535,10,98]
[null,null,null,null,536,10,105]
[null,null,null,null,537,10,112]
[null,null,null,null,538,9]
[null,null,null,null,539,10,103]
[null,null,null,null,540,5,76]
[null,null,null,null,541,7,93]
[null,null,null,null,542,4,108]
[null,null,null,null,543,9,86]
[null,null,null,null,544,8,77]
[null,null,null,null,545,6,83]
[null,null,null,null,546,10,116]
[null,null,null,null,547,8,102]
[null,null,null,null,548,7,78]
[null,null,null,null,549,7,101]
[null,null,null,null,550,4,86]
[null,null,null,null,551,8,102]
[null,null,null,null,552,7,91]
[null,null,null,null,553,6,98]
[null,null,null,null,554,9,88]
[null,null,null,null,555,7,81]
[null,null,null,null,556,8,90]
[null,null,null,null,557,6,85]
[null,null,null,null,558,9,95]
[null,null,null,null,559,8,83]
[null,null,null,null,560,9,93]
[null,null,null,null,561,5,91]
[null,null,null,null,562,6,85]
[null,null,null,null,563,4,81]
[null,null,null,null,564,6,108]
[null,null,null,null,565,4,73]
[null,null,null,null,566,8,97]
[null,null,null,null,567,5,103]
[null,null,null,null,568,7,95]
[null,null,null,null,569,9,112]
[null,null,null,null,570,8,106]
[null,null,null,null,571,10,89]
[null,null,null,null,572,5,80]
[null,null,null,null,573,4,66]
[null,null,null,null,574,8,90]
[null,null,null,null,575,9,95]
[null,null,null,null,576,8,111]
[null,null,null,null,577,9,90]
[null,null,null,null,578,7,79]
[null,null,null,null,579,7,96]
[null,null,null,null,580,8,86]
[null,null,null,null,581,4,67]
[null,null,null,null,582,1,31]
[null,null,null,null,583,4,66]
[null,null,null,null,584,4,40]
[null,null,null,null,585,1,67]
[null,null,null,null,586,3]
[null,null,null,null,587,3,98]
[null,null,null,null,588,9,60]
[null,null,null,null,589,4,93]
[null,null,null,null,590,2,55]
[null,null,null,null,591,5,87]
[null,null,null,null,592,2,80]
[null,null,null,null,593,4]
[null,null,null,null,594,2,52]
[null,null,null,null,595,4,76]
[null,null,null,null,596,3,96]
[null,null,null,null,597,5,103]
[null,null,null,null,598,9,92]
[null,null,null,null,599,8,104]
[null,null,null,null,600,1,111]
[null,null,null,null,601,3,91]
[null,null,null,null,602,3,81]
[null,null,null,null,603,6,96]
[null,null,null,null,604,5,91]
[null,null,null,null,605,8,100]
[null,null,null,null,606,3,114]
[null,null,null,null,607,5,77]
[null,null,null,null,608,4,93]
[null,null,null,null,609,4,86]
[null,null,null,null,610,5,72]
[null,null,null,null,611,4,102]
[null,null,null,null,612,3,85]
[null,null,null,null,613,1,104]
[null,null,null,null,614,7,68]
[null,null,null,null,615,10,98]
[null,null,null,null,616,2,104]
[null,null,null,null,617,10,74]
[null,null,null,null,618,7,93]
[null,null,null,null,619,1,49]
[null,null,null,null,620,10,93]
[null,null,null,null,621,4,53]
[null,null,null,null,622,5,68]
[null,null,null,null,623,8,104]
[null,null,null,null,624,2,87]
[null,null,null,null,625,5,80]
[null,null,null,null,626,5,59]
[null,null,null,null,627,10,97]
[null,null,null,null,628,8,81]
[null,null,null,null,629,5,101]
[null,null,null,null,630,9,92]
[null,null,null,null,631,3,104]
[null,null,null,null,632,8,91]
[null,null,null,null,633,1,96]
[null,null,null,null,634,9,113]
[null,null,null,null,635,4,93]
[null,null,null,null,636,5,101]
[null,null,null,null,637,1,107]
[null,null,null,null,638,4,74]
[null,null,null,null,639,2,97]
[null,null,null,null,640,2,100]
[null,null,null,null,641,9,102]
[null,null,null,null,642,9,94]
[null,null,null,null,643,4,95]
[null,null,null,null,644,10,109]
[null,null,null,null,645,5,109]
[null,null,null,null,646,5,102]
[null,null,null,null,647,5,103]
[null,null,null,null,648,10,110]
[null,null,null,null,649,3,107]
[null,null,null,null,650,3]
[null,null,null,null,651,4,89]
[null,null,null,null,652,8,93]
[null,null,null,null,653,7,103]
[null,null,null,null,654,8,75]
[null,null,null,null,655,9,94]
[null,null,null,null,656,8,55]
[null,null,null,null,657,10,56]
[null,null,null,null,658,7,105]
[null,null,null,null,659,4,91]
[null,null,null,null,660,9,98]
[null,null,null,null,661,7,69]
[null,null,null,null,662,4,77]
[null,null,null,null,663,4,88]
[null,null,null,null,664,8,108]
[null,null,null,null,665,7,92]
[null,null,null,null,666,9,96]
[null,null,null,null,667,6,70]
[null,null,null,null,668,8,68]
[null,null,null,null,669,7,110]
[null,null,null,null,670,9,94]
[null,null,null,null,671,8,92]
[null,null,null,null,672,7,78]
[null,null,null,null,673,5,94]
[null,null,null,null,674,7,108]
[null,null,null,null,675,3,100]
[null,null,null,null,676,5,95]
[null,null,null,null,677,4,91]
[null,null,null,null,678,10,114]
[null,null,null,null,679,6,96]
[null,null,null,null,680,4,84]
[null,null,null,null,681,2,97]
[null,null,null,null,682,5]
[null,null,null,null,683,9,113]
[null,null,null,null,684,9,88]
[null,null,null,null,685,6,88]
[null,null,null,null,686,4,69]
[null,null,null,null,687,9,99]
[null,null,null,null,688,4,93]
[null,null,null,null,689,9,93]
[null,null,null,null,690,9,97]
[null,null,null,null,691,2,97]
[null,null,null,null,692,9,90]
[null,null,null,null,693,9,91]
[null,null,null,null,694,9,104]
[null,null,null,null,695,6,109]
[null,null,null,null,696,8,88]
[null,null,null,null,697,6,105]
[null,null,null,null,698,6,106]
[null,null,null,null,699,3,102]
[null,null,null,null,700,6,77]
[null,null,null,null,701,7,50]