{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Secretary+","Charts","Random+Sort","Prices"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"Secretary+","index":0,"n_rows":501,"n_cols":24,"rows_kept":501,"cut":false,"hidden":false,"merged":[]}
["# \"pre\" interviews",5,null,null,"Experiment",null,null,"Rank","% Times  Hired"]
["Best rank Interviewed",{"$f":"MIN(INDIRECT(\"C6:C\"&(B1+5)))","v":13},"# interviews after \"pre\"",null,1,null,null,1,{"$f":"FREQUENCY(F2:F501,H2:H101)/500","v":0}]
["Rank of Final Selected",{"$f":"D105","v":12},"Average # from Data Table",null,2,null,null,2,0]
[{"$f":"\"# Pre Interviews = \" & B1","v":"# Pre Interviews = 5"},null,null,null,3,null,null,3,0]
["Candidate","Goodness","Ranked Goodness","Selection",4,null,null,4,0]
[1,{"$f":"100000000*RAND()","v":88529539.68692933},{"$f":"RANK(B6,$B$6:$B$105)","v":13},null,5,null,null,5,0]
[2,{"$f":"100000000*RAND()","v":54307455.46931126},47,{"$f":"IF(D6<>\"\",D6,IF(A7<=$B$1,\"\",IF(C7<$B$2,C7,\"\")))","v":""},6,null,null,6,0]
[3,23108870.850617968,82,"",7,null,null,7,0]
[4,87139775.434975371,14,"",8,null,null,8,0]
[5,55265922.455199771,46,"",9,null,null,9,0]
[6,90097233.717019275,12,12,10,null,null,10,0]
[7,62904145.469733931,33,12,11,null,null,11,0]
[8,12082158.251288977,93,12,12,null,null,12,0]
[9,49362283.663557902,55,12,13,null,null,13,0]
[10,55869248.925010063,45,12,14,null,null,14,0]
[11,56909267.986083642,43,12,15,null,null,15,0]
[12,10780836.328811994,94,12,16,null,null,16,0]
[13,28982125.014414705,75,12,17,null,null,17,0]
[14,71816114.584004521,29,12,18,null,null,18,0]
[15,79730297.407329425,21,12,19,null,null,19,0]
[16,1886519.3876006715,100,12,20,null,null,20,0]
[17,5386062.4966995725,96,12,21,null,null,21,0]
[18,48861270.054895289,56,12,22,null,null,22,0]
[19,51860344.553849116,52,12,23,null,null,23,0]
[20,52033019.870523758,51,12,24,null,null,24,0]
[21,16853124.460902657,89,12,25,null,null,25,0]
[22,52520817.51984825,50,12,26,null,null,26,0]
[23,68696911.457385764,30,12,27,null,null,27,0]
[24,87068332.973421738,15,12,28,null,null,28,0]
[25,59161703.580627553,38,12,29,null,null,29,0]
[26,64567880.499042161,32,12,30,null,null,30,0]
[27,29106782.552662924,74,12,31,null,null,31,0]
[28,77056521.237708807,27,12,32,null,null,32,0]
[29,{"$f":"100000000*RAND()","v":57062614.23471386},42,12,33,null,null,33,0]
[30,43148233.642400593,59,12,34,null,null,34,0,null,null,null,null,{"$f":"\"Interview \"&N36","v":"Interview 5"},{"$f":"\"Interview \"&O36","v":"Interview 10"},{"$f":"\"Interview \"&P36","v":"Interview 15"},"Interview 20","Interview 25","Interview 30","Interview 35","Interview 40","Interview 45",null,"Put any 9 values (from 1 to 99) in cells N36:V36"]
[31,92908828.683949009,9,12,35,null,null,35,0,null,"Selected","Percent","Top",5,10,15,20,25,30,35,40,45,null,"Then click Recompute"]
[32,90720423.013594866,10,12,36,null,null,36,0,null,{"$f":"\"Top \"&M37","v":"Top 1"},{"$f":"SUM(INDIRECT(\"$I$2:I\"&(M37+1)))","v":0},1,0.17,0.23200000000000001,0.26200000000000001,0.316,0.36599999999999999,0.39800000000000002,0.38200000000000001,0.40400000000000003,0.35399999999999998]
[33,36601841.7578329,{"$f":"RANK(B38,$B$6:$B$105)","v":67},12,37,null,null,37,0,null,{"$f":"\"Top \"&M38","v":"Top 2"},{"$f":"SUM(INDIRECT(\"$I$2:I\"&(M38+1)))","v":0},2,0.28800000000000003,0.36,0.438,0.5,0.51800000000000002,0.57600000000000007,0.53200000000000003,0.51800000000000002,0.45799999999999996]
[34,16603456.808709627,90,{"$f":"IF(D38<>\"\",D38,IF(A39<=$B$1,\"\",IF(C39<$B$2,C39,\"\")))","v":12},38,null,null,38,0,null,"Top 3",0,3,0.35800000000000004,0.44999999999999996,0.54800000000000004,0.59799999999999998,0.60199999999999998,0.64000000000000012,0.59800000000000009,0.59199999999999997,0.52600000000000002]
[35,32966501.381199189,71,12,39,null,null,39,0,null,"Top 4",0,4,0.41600000000000004,0.52,0.6160000000000001,0.67199999999999993,0.64600000000000002,0.68000000000000016,0.62400000000000011,0.61599999999999999,0.55600000000000005]
[36,16998534.644274388,88,12,40,null,null,40,0,null,"Top 5",0,5,0.48400000000000004,0.59799999999999998,0.68800000000000006,0.71599999999999997,0.69400000000000006,0.69400000000000017,0.64200000000000013,0.63,0.56600000000000006]
[37,59363991.987654693,37,12,41,null,null,41,0,null,"Top 10",0,10,0.68000000000000016,0.77600000000000013,0.80000000000000016,0.79200000000000004,0.75400000000000011,0.7220000000000002,0.68000000000000016,0.66800000000000004,0.60600000000000009]
[38,49930813.596108362,54,12,42,null,null,42,0,null,"Top 20",0,20,0.84400000000000031,0.89200000000000024,0.87000000000000022,0.83800000000000008,0.79200000000000015,0.75400000000000023,0.7200000000000002,0.70000000000000007,0.67400000000000015]
[39,9056216.3955986816,95,12,43,null,null,43,0,null,"Top 30",0,30,0.91000000000000036,0.92800000000000027,0.89000000000000024,0.85600000000000009,0.83000000000000018,0.78200000000000025,0.75600000000000023,0.7420000000000001,0.7240000000000002]
[40,26835722.790985718,76,12,44,null,null,44,0,null,"Top 40",0,40,0.9480000000000004,0.93600000000000028,0.90800000000000025,0.87600000000000011,0.8540000000000002,0.81400000000000028,0.80600000000000027,0.77600000000000013,0.75600000000000023]
[41,29733769.642816644,73,12,45,null,null,45,0,null,"Top 50",0,50,0.96000000000000041,0.94000000000000028,0.92400000000000027,0.89600000000000013,0.87800000000000022,0.8400000000000003,0.84400000000000031,0.83000000000000018,0.79800000000000026]
[42,26167939.350976788,77,12,46,null,null,46,0]
[43,13183566.651633605,92,12,47,null,null,47,0]
[44,55948690.732626848,44,12,48,null,null,48,0]
[45,40235943.011808574,63,12,49,null,null,49,0]
[46,3511774.9248607,98,12,50,null,null,50,0]
[47,18217890.978025243,87,12,51,null,null,51,0]
[48,60388298.555007048,36,12,52,null,null,52,0]
[49,24599090.923739843,81,12,53,null,null,53,0]
[50,53903259.180099547,48,12,54,null,null,54,0]
[51,21143065.688774597,83,12,55,null,null,55,0]
[52,51115348.412121266,53,12,56,null,null,56,0]
[53,83602970.84930031,16,12,57,null,null,57,0]
[54,30065414.28624887,72,12,58,null,null,58,0]
[55,57252783.593603864,40,12,59,null,null,59,0]
[56,82853846.852450565,17,12,60,null,null,60,0]
[57,19403024.134151779,86,12,61,null,null,61,0]
[58,38823761.634253986,65,12,62,null,null,62,0]
[59,45229995.963241041,57,12,63,null,null,63,0]
[60,24658956.66348974,80,12,64,null,null,64,0]
[61,58654074.377863854,39,12,65,null,null,65,0]
[62,20085430.011863094,85,12,66,null,null,66,0]
[63,40560551.559746429,60,12,67,null,null,67,0]
[64,33692164.991544612,68,12,68,null,null,68,0]
[65,94809265.299106583,{"$f":"RANK(B70,$B$6:$B$105)","v":7},12,69,null,null,69,0]
[66,{"$f":"100000000*RAND()","v":77224480.536107704},25,{"$f":"IF(D70<>\"\",D70,IF(A71<=$B$1,\"\",IF(C71<$B$2,C71,\"\")))","v":12},70,null,null,70,0]
[67,97192662.144407466,5,12,71,null,null,71,0]
[68,97533164.130154938,4,12,72,null,null,72,0]
[69,81669812.299764663,19,12,73,null,null,73,0]
[70,37281997.601860814,66,12,74,null,null,74,0]
[71,80544792.263981164,20,12,75,null,null,75,0]
[72,90501330.114856154,11,12,76,null,null,76,0]
[73,14072702.502981737,91,12,77,null,null,77,0]
[74,65479336.781191885,31,12,78,null,null,78,0]
[75,2924805.1227579452,99,12,79,null,null,79,0]
[76,77192255.208424255,26,12,80,null,null,80,0]
[77,78848169.340660676,23,12,81,null,null,81,0]
[78,53120614.663163044,49,12,82,null,null,82,0]
[79,20118640.57316206,84,12,83,null,null,83,0]
[80,99335237.477547526,2,12,84,null,null,84,0]
[81,99667351.87039648,1,12,85,null,null,85,0]
[82,40266622.230527461,62,12,86,null,null,86,0]
[83,25681830.478149779,78,12,87,null,null,87,0]
[84,33659915.038385168,69,12,88,null,null,88,0]
[85,96534825.263854459,6,12,89,null,null,89,0]
[86,82335224.220511273,18,12,90,null,null,90,0]
[87,92965655.363027364,8,12,91,null,null,91,0]
[88,25432941.729763113,79,12,92,null,null,92,0]
[89,79305881.740726486,22,12,93,null,null,93,0]
[90,33205364.57084462,70,12,94,null,null,94,0]
[91,43509674.568933398,58,12,95,null,null,95,0]
[92,39259756.891248718,64,12,96,null,null,96,0]
[93,78427825.811885208,24,12,97,null,null,97,0]
[94,98943853.830589056,3,12,98,null,null,98,0]
[95,62794195.832943097,34,12,99,null,null,99,0]
[96,72648433.789029896,28,12,100,null,null,100,0]
[97,61672020.197706521,{"$f":"RANK(B102,$B$6:$B$105)","v":35},12,101,null,null,"Sum",{"$f":"SUM(I2:I100)","v":0}]
[98,40306390.581404194,61,{"$f":"IF(D102<>\"\",D102,IF(A103<=$B$1,\"\",IF(C103<$B$2,C103,\"\")))","v":12},102]
[99,57165572.912070826,41,12,103]
[100,{"$f":"100000000*RAND()","v":5024908.704589759},97,{"$f":"IF(D104<>\"\",D104,C105)","v":12},104]
[null,null,null,null,105]
[null,null,null,null,106]
[null,null,null,null,107]
[null,null,null,null,108]
[null,null,null,null,109]
[null,null,null,null,110]
[null,null,null,null,111]
[null,null,null,null,112]
[null,null,null,null,113]
[null,null,null,null,114]
[null,null,null,null,115]
[null,null,null,null,116]
[null,null,null,null,117]
[null,null,null,null,118]
[null,null,null,null,119]
[null,null,null,null,120]
[null,null,null,null,121]
[null,null,null,null,122]
[null,null,null,null,123]
[null,null,null,null,124]
[null,null,null,null,125]
[null,null,null,null,126]
[null,null,null,null,127]
[null,null,null,null,128]
[null,null,null,null,129]
[null,null,null,null,130]
[null,null,null,null,131]
[null,null,null,null,132]
[null,null,null,null,133]
[null,null,null,null,134]
[null,null,null,null,135]
[null,null,null,null,136]
[null,null,null,null,137]
[null,null,null,null,138]
[null,null,null,null,139]
[null,null,null,null,140]
[null,null,null,null,141]
[null,null,null,null,142]
[null,null,null,null,143]
[null,null,null,null,144]
[null,null,null,null,145]
[null,null,null,null,146]
[null,null,null,null,147]
[null,null,null,null,148]
[null,null,null,null,149]
[null,null,null,null,150]
[null,null,null,null,151]
[null,null,null,null,152]
[null,null,null,null,153]
[null,null,null,null,154]
[null,null,null,null,155]
[null,null,null,null,156]
[null,null,null,null,157]
[null,null,null,null,158]
[null,null,null,null,159]
[null,null,null,null,160]
[null,null,null,null,161]
[null,null,null,null,162]
[null,null,null,null,163]
[null,null,null,null,164]
[null,null,null,null,165]
[null,null,null,null,166]
[null,null,null,null,167]
[null,null,null,null,168]
[null,null,null,null,169]
[null,null,null,null,170]
[null,null,null,null,171]
[null,null,null,null,172]
[null,null,null,null,173]
[null,null,null,null,174]
[null,null,null,null,175]
[null,null,null,null,176]
[null,null,null,null,177]
[null,null,null,null,178]
[null,null,null,null,179]
[null,null,null,null,180]
[null,null,null,null,181]
[null,null,null,null,182]
[null,null,null,null,183]
[null,null,null,null,184]
[null,null,null,null,185]
[null,null,null,null,186]
[null,null,null,null,187]
[null,null,null,null,188]
[null,null,null,null,189]
[null,null,null,null,190]
[null,null,null,null,191]
[null,null,null,null,192]
[null,null,null,null,193]
[null,null,null,null,194]
[null,null,null,null,195]
[null,null,null,null,196]
[null,null,null,null,197]
[null,null,null,null,198]
[null,null,null,null,199]
[null,null,null,null,200]
[null,null,null,null,201]
[null,null,null,null,202]
[null,null,null,null,203]
[null,null,null,null,204]
[null,null,null,null,205]
[null,null,null,null,206]
[null,null,null,null,207]
[null,null,null,null,208]
[null,null,null,null,209]
[null,null,null,null,210]
[null,null,null,null,211]
[null,null,null,null,212]
[null,null,null,null,213]
[null,null,null,null,214]
[null,null,null,null,215]
[null,null,null,null,216]
[null,null,null,null,217]
[null,null,null,null,218]
[null,null,null,null,219]
[null,null,null,null,220]
[null,null,null,null,221]
[null,null,null,null,222]
[null,null,null,null,223]
[null,null,null,null,224]
[null,null,null,null,225]
[null,null,null,null,226]
[null,null,null,null,227]
[null,null,null,null,228]
[null,null,null,null,229]
[null,null,null,null,230]
[null,null,null,null,231]
[null,null,null,null,232]
[null,null,null,null,233]
[null,null,null,null,234]
[null,null,null,null,235]
[null,null,null,null,236]
[null,null,null,null,237]
[null,null,null,null,238]
[null,null,null,null,239]
[null,null,null,null,240]
[null,null,null,null,241]
[null,null,null,null,242]
[null,null,null,null,243]
[null,null,null,null,244]
[null,null,null,null,245]
[null,null,null,null,246]
[null,null,null,null,247]
[null,null,null,null,248]
[null,null,null,null,249]
[null,null,null,null,250]
[null,null,null,null,251]
[null,null,null,null,252]
[null,null,null,null,253]
[null,null,null,null,254]
[null,null,null,null,255]
[null,null,null,null,256]
[null,null,null,null,257]
[null,null,null,null,258]
[null,null,null,null,259]
[null,null,null,null,260]
[null,null,null,null,261]
[null,null,null,null,262]
[null,null,null,null,263]
[null,null,null,null,264]
[null,null,null,null,265]
[null,null,null,null,266]
[null,null,null,null,267]
[null,null,null,null,268]
[null,null,null,null,269]
[null,null,null,null,270]
[null,null,null,null,271]
[null,null,null,null,272]
[null,null,null,null,273]
[null,null,null,null,274]
[null,null,null,null,275]
[null,null,null,null,276]
[null,null,null,null,277]
[null,null,null,null,278]
[null,null,null,null,279]
[null,null,null,null,280]
[null,null,null,null,281]
[null,null,null,null,282]
[null,null,null,null,283]
[null,null,null,null,284]
[null,null,null,null,285]
[null,null,null,null,286]
[null,null,null,null,287]
[null,null,null,null,288]
[null,null,null,null,289]
[null,null,null,null,290]
[null,null,null,null,291]
[null,null,null,null,292]
[null,null,null,null,293]
[null,null,null,null,294]
[null,null,null,null,295]
[null,null,null,null,296]
[null,null,null,null,297]
[null,null,null,null,298]
[null,null,null,null,299]
[null,null,null,null,300]
[null,null,null,null,301]
[null,null,null,null,302]
[null,null,null,null,303]
[null,null,null,null,304]
[null,null,null,null,305]
[null,null,null,null,306]
[null,null,null,null,307]
[null,null,null,null,308]
[null,null,null,null,309]
[null,null,null,null,310]
[null,null,null,null,311]
[null,null,null,null,312]
[null,null,null,null,313]
[null,null,null,null,314]
[null,null,null,null,315]
[null,null,null,null,316]
[null,null,null,null,317]
[null,null,null,null,318]
[null,null,null,null,319]
[null,null,null,null,320]
[null,null,null,null,321]
[null,null,null,null,322]
[null,null,null,null,323]
[null,null,null,null,324]
[null,null,null,null,325]
[null,null,null,null,326]
[null,null,null,null,327]
[null,null,null,null,328]
[null,null,null,null,329]
[null,null,null,null,330]
[null,null,null,null,331]
[null,null,null,null,332]
[null,null,null,null,333]
[null,null,null,null,334]
[null,null,null,null,335]
[null,null,null,null,336]
[null,null,null,null,337]
[null,null,null,null,338]
[null,null,null,null,339]
[null,null,null,null,340]
[null,null,null,null,341]
[null,null,null,null,342]
[null,null,null,null,343]
[null,null,null,null,344]
[null,null,null,null,345]
[null,null,null,null,346]
[null,null,null,null,347]
[null,null,null,null,348]
[null,null,null,null,349]
[null,null,null,null,350]
[null,null,null,null,351]
[null,null,null,null,352]
[null,null,null,null,353]
[null,null,null,null,354]
[null,null,null,null,355]
[null,null,null,null,356]
[null,null,null,null,357]
[null,null,null,null,358]
[null,null,null,null,359]
[null,null,null,null,360]
[null,null,null,null,361]
[null,null,null,null,362]
[null,null,null,null,363]
[null,null,null,null,364]
[null,null,null,null,365]
[null,null,null,null,366]
[null,null,null,null,367]
[null,null,null,null,368]
[null,null,null,null,369]
[null,null,null,null,370]
[null,null,null,null,371]
[null,null,null,null,372]
[null,null,null,null,373]
[null,null,null,null,374]
[null,null,null,null,375]
[null,null,null,null,376]
[null,null,null,null,377]
[null,null,null,null,378]
[null,null,null,null,379]
[null,null,null,null,380]
[null,null,null,null,381]
[null,null,null,null,382]
[null,null,null,null,383]
[null,null,null,null,384]
[null,null,null,null,385]
[null,null,null,null,386]
[null,null,null,null,387]
[null,null,null,null,388]
[null,null,null,null,389]
[null,null,null,null,390]
[null,null,null,null,391]
[null,null,null,null,392]
[null,null,null,null,393]
[null,null,null,null,394]
[null,null,null,null,395]
[null,null,null,null,396]
[null,null,null,null,397]
[null,null,null,null,398]
[null,null,null,null,399]
[null,null,null,null,400]
[null,null,null,null,401]
[null,null,null,null,402]
[null,null,null,null,403]
[null,null,null,null,404]
[null,null,null,null,405]
[null,null,null,null,406]
[null,null,null,null,407]
[null,null,null,null,408]
[null,null,null,null,409]
[null,null,null,null,410]
[null,null,null,null,411]
[null,null,null,null,412]
[null,null,null,null,413]
[null,null,null,null,414]
[null,null,null,null,415]
[null,null,null,null,416]
[null,null,null,null,417]
[null,null,null,null,418]
[null,null,null,null,419]
[null,null,null,null,420]
[null,null,null,null,421]
[null,null,null,null,422]
[null,null,null,null,423]
[null,null,null,null,424]
[null,null,null,null,425]
[null,null,null,null,426]
[null,null,null,null,427]
[null,null,null,null,428]
[null,null,null,null,429]
[null,null,null,null,430]
[null,null,null,null,431]
[null,null,null,null,432]
[null,null,null,null,433]
[null,null,null,null,434]
[null,null,null,null,435]
[null,null,null,null,436]
[null,null,null,null,437]
[null,null,null,null,438]
[null,null,null,null,439]
[null,null,null,null,440]
[null,null,null,null,441]
[null,null,null,null,442]
[null,null,null,null,443]
[null,null,null,null,444]
[null,null,null,null,445]
[null,null,null,null,446]
[null,null,null,null,447]
[null,null,null,null,448]
[null,null,null,null,449]
[null,null,null,null,450]
[null,null,null,null,451]
[null,null,null,null,452]
[null,null,null,null,453]
[null,null,null,null,454]
[null,null,null,null,455]
[null,null,null,null,456]
[null,null,null,null,457]
[null,null,null,null,458]
[null,null,null,null,459]
[null,null,null,null,460]
[null,null,null,null,461]
[null,null,null,null,462]
[null,null,null,null,463]
[null,null,null,null,464]
[null,null,null,null,465]
[null,null,null,null,466]
[null,null,null,null,467]
[null,null,null,null,468]
[null,null,null,null,469]
[null,null,null,null,470]
[null,null,null,null,471]
[null,null,null,null,472]
[null,null,null,null,473]
[null,null,null,null,474]
[null,null,null,null,475]
[null,null,null,null,476]
[null,null,null,null,477]
[null,null,null,null,478]
[null,null,null,null,479]
[null,null,null,null,480]
[null,null,null,null,481]
[null,null,null,null,482]
[null,null,null,null,483]
[null,null,null,null,484]
[null,null,null,null,485]
[null,null,null,null,486]
[null,null,null,null,487]
[null,null,null,null,488]
[null,null,null,null,489]
[null,null,null,null,490]
[null,null,null,null,491]
[null,null,null,null,492]
[null,null,null,null,493]
[null,null,null,null,494]
[null,null,null,null,495]
[null,null,null,null,496]
[null,null,null,null,497]
[null,null,null,null,498]
[null,null,null,null,499]
[null,null,null,null,500]

{"sheet":"Charts","index":1,"n_rows":116,"n_cols":19,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["Worksheet Description"]
["  Row of First Problem Description",17]
["  Row of Last Problem Description",29]
["  Row of First Student Scores",45]
["  Row of Last Student Scores",116]
["  Column of First Problem",2,"column B"]
["  Column of Last Problem",14,"column N"]
[]
["Problem # Selected",null,null,null,"Problem Selector"]
["Problem Description: Points (below)",null,null,null,"[1,13] by 1 (raw value only)"]
[]
["Column to Graph"]
["Range to Graph"]
["Max Points"]
[]
["Problem Descriptions (below)"]
["1. Linked List"]
["2. Equals (Recursive)"]
["3. Removet Rear (Iterative)"]
["4. Insert into Map"]
["5. Reverse Decorator"]
["6. Analysis of Algorithms"]
["7. Copy Tree"]
["8. Remove From Tree (English)"]
["9. Heap Manipulation"]
["10. IsHeap"]
["11. AVL"]
["12. Hashing"]
["13.English"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Data For Plotting (below)"]
["Points for Problem",12,10,10,10,14,35,10,10,10,10,12,8,14,{"$f":"SUM(B43:N43)","v":165},null,"Scores"]
["Student/Problem #","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10","#11","#12","#13","Total",null,"to Graph","Score","Frequency"]
[1,9,7,0,3,0,14,5.5,4,5,0,1.5,4,4,{"$f":"SUM(B45:N45)","v":57},null,null,0,{"$f":"FREQUENCY(Q45:Q116,R45:R80)","v":0}]
[2,8,2,7,4,0,26.5,9,6,7,8,2,2.5,3,{"$f":"SUM(B46:N46)","v":85},null,null,1,0]
[3,4,7.5,6,2,1,19,7,2,10,7,5,7,5,{"$f":"SUM(B47:N47)","v":82.5},null,null,2,0]
[4,9,8.5,8,3,1,24.5,5,0,10,0,10.5,3,7,{"$f":"SUM(B48:N48)","v":89.5},null,null,3,0]
[5,12,10,10,7,10,25,10,6,8,10,11,4,3,126,null,null,4,0]
[6,11,9.5,10,5.5,8,33,10,8,10,8,11,8,1,133,null,null,5,0]
[7,5,5.5,3,0,2,17,1.5,5,8,2,5.5,0.5,5,60,null,null,6,0]
[8,10,6.5,4.5,5.5,0,10.5,4.5,1,1,6,10,7.5,0,67,null,null,7,0]
[9,9,5.5,5,0,4,23,1.5,0,6,0,9,0,6,69,null,null,8,0]
[10,8,6.5,4.5,3.5,5,23,8.5,6,10,2,7,4.5,1,89.5,null,null,9,0]
[11,3,6,6.5,7.5,3,14.5,6,1,1,0,0,4.5,6,59,null,null,10,0]
[12,12,7.5,8,9,11,27.5,10,9,10,0,11,7.5,5,127.5,null,null,11,0]
[13,12,8.5,10,9.5,0,20,10,10,10,7,9.5,7.5,2,116,null,null,12,0]
[14,12,7,7,7,0,16.5,0,0,6,7,6,6,0,74.5,null,null,13,0]
[15,11,9.5,7.5,10,1,31,10,7,10,1,11,6.5,0,115.5,null,null,14,0]
[16,10,8.5,2.5,8,0,23,0,1,10,0,11.5,3.5,4,82,null,null,15,0]
[17,11,5.5,7,1,4,23.5,1.5,8.5,10,0,4,3,5,84,null,null,16,0]
[18,12,7.5,7,7,0,32,0,5,10,0,5.5,4,0,90,null,null,17,0]
[19,11,7,6.5,4,0,5,7,0,6,7,10,0,3,66.5,null,null,18,0]
[20,10,9.5,7,9,8,18,4.5,0,9.5,2,11,7.5,1,97,null,null,19,0]
[21,8,9.5,0,0,0,22,0,2,8,2,3,4,0,58.5,null,null,20,0]
[22,10,7.5,8.5,8.5,1,23,6,0,10,0,3,0,2,79.5,null,null,21,0]
[23,5,6.5,0,6,6.5,16,0,1,6,0,10,0,0,57,null,null,22,0]
[24,7,0,1.5,8.5,0,28.5,10,7,10,2,6.5,8,1,90,null,null,23,0]
[25,12,8.5,9,6,2,30.5,10,5,7,1,11,7,10,119,null,null,24,0]
[26,12,10,10,9,11,34,10,9,10,7.5,11,7,3,143.5,null,null,25,0]
[27,3,6.5,7,8,1,24.5,4.5,6,10,7,6.5,8,7,99,null,null,26,0]
[28,9,8.5,7.5,4,2,26.5,6,5,8,2,11,3.5,0,93,null,null,27,0]
[29,8,7.5,1.5,1,0,17.5,1,1,0,0,3.5,0,0,41,null,null,28,0]
[30,12,8.5,8,6,10,25.5,9.5,1,10,4,12,3,7,116.5,null,null,29,0]
[31,10,10,8.5,10,4,26.5,10,10,10,7,5,6.5,1,118.5,null,null,30,0]
[32,5,6.5,2,2.5,1,18,3,1,10,1,7,4,4,65,null,null,31,0]
[33,11,9.5,4,2,1,24.5,1.5,2,8,2,5.5,6,0,77,null,null,32,0]
[34,9,8,8,7,2,22,0,6,5,0,11,4.5,2,84.5,null,null,33,0]
[35,9,8.5,10,7,0,22.5,7,5,6,0,4,8,9,96,null,null,34,0]
[36,12,8.5,10,9.5,12,27.5,10,10,10,9,10,8,0,136.5,null,null,35,0]
[37,9,7.5,7.5,9.5,6,23.5,3.5,9,5,0,5.5,2,2,90]
[38,8,7.5,3.5,3,1,14.5,5.5,0,5,1,10,2,11,72]
[39,11,10,10,10,14,34.5,10,10,10,9,12,8,4,152.5]
[40,11,5.5,3.5,5.5,2,22,4.5,2,6,7,10,7,2,88]
[41,7,4,3.5,5,2,13.5,3,5,10,2,10,4,5,74]
[42,12,8.5,10,9.5,12,31,0,10,7,10,12,7,2,131]
[43,12,8.5,3.5,8,0,12.5,6.5,1,9,2,6,0,0,69]
[44,8,9.5,4,0,0,20,4.5,3,8,5,11.5,6.5,2,82]
[45,6,2,1,1,1,6.5,1,2,0,0,2,0.5,5,28]
[46,9,8,7,9,2,22.5,10,2,10,6,10,7.5,7,110]
[47,12,8.5,6.5,0,0,17,6,9,8,0.5,10,6.5,0,84]
[48,11,6,5.5,3,0,15.5,0,10,4,0.5,4,5,7,71.5]
[49,11,9,10,9.5,3,29,7,10,10,7,7,4.5,0,117]
[50,11,9,5.5,9.5,11,28.5,6,0,10,10,12,4,2,118.5]
[51,7,3,8.5,0,2,22.5,3.5,2,10,0,5,7,0,70.5]
[52,12,0,7,9,9,21,8.5,7,5,3,4,0,2,87.5]
[53,11,8,8.5,9.5,1,18.5,7.5,0,10,6,2.5,0,1,83.5]
[54,6,10,10,9,10,31.5,10,0,10,9,8.5,0,6,120]
[55,12,10,8.5,9,2,29,10,9,9.5,9,11,5,4,128]
[56,11,8.5,5,7,9,23,4.5,1,6,7,6.5,3.5,3,95]
[57,12,8.5,9.5,5,2.5,30,7,8,10,7,12,8,7,126.5]
[58,11,9.5,7.5,9.5,12,31,9.5,7,10,10,11,8,4,140]
[59,8,6.5,10,9,3,21.5,10,0,6,7,11,4,0,96]
[60,5,4,0,1,0,8,3.5,6,9,1,10.5,4,5,57]
[61,12,10,10,4.5,4,32.5,10,9,10,10,11,8,7,138]
[62,12,8.5,8.5,9.5,12,31,10,10,5,9,5.5,5.5,8,134.5]
[63,10,8.5,10,8.5,0,22,10,9,10,10,6,8,0,112]
[64,11,8,10,3.5,3,20.5,5,6,10,9,11.5,8,0,105.5]
[65,11,10,8.5,6.5,2,18,10,6,10,6.5,9.5,4,4,106]
[66,12,8.5,8.5,9.5,0,22,0,4,10,0,9.5,6,0,90]
[67,7,7,6,8,10,5.5,10,7,8,2,8.5,3.5,3,85.5]
[68,7,6,7,4.5,7,24.5,10,6,6,2,11,7,9,{"$f":"SUM(B112:N112)","v":107}]
[69,12,7,10,9,12,35,10,10,5,9,11,8,3,141]
[70,8,7,0,6.5,0,25.5,7,6,4,1,4,2,6,77]
[71,5,7,8.5,0,2,19.5,0,9,10,1,8.5,7.5,6,84]
[72,8,0,6.5,9,3,10.5,3,6,4,1,8,4,2,65]

{"sheet":"Random+Sort","index":2,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Name","Random #","Rank of Random #","Random Name"]
["Alice"]
["Bob"]
["Carol"]
["Dennis"]
["Eunice"]
["Freddy"]
["Gabriella"]
["Henry"]
["Ilene"]
["Jack"]
["Karen"]
["Larry"]
["Oprah"]
["Paul"]
["Renee"]
["Steve"]
["Terri"]
[]
[]
["How to Rank",0,"  0 sorts highest to lowest; 1 sorts lowest to highest"]
["(0 or 1) "]
[]
["Name","Score","Rank of Score","Names","Scores matching ",null,"Index"]
["(alphabetically)",null,"  (see 0 or 1 in B21)"," (sorted by Rank of Score)","Sorted  Names"]
["Alice",31,null,null,null,null,1]
["Bob",77,null,null,null,null,2]
["Carol",6,null,null,null,null,3]
["Dennis",61,null,null,null,null,4]
["Eunice",4,null,null,null,null,5]
["Freddy",55,null,null,null,null,6]
["Gabriella",24,null,null,null,null,7]
["Henry",47,null,null,null,null,8]
["Ilene",33,null,null,null,null,9]
["Jack",92,null,null,null,null,10]
["Karen",85,null,null,null,null,11]
["Larry",12,null,null,null,null,12]
["Oprah",80,null,null,null,null,13]
["Paul",86,null,null,null,null,14]
["Renee",98,null,null,null,null,15]
["Steve",81,null,null,null,null,16]
["Terri",16,null,null,null,null,17]
[]
[null,"Note: Scores must be unique!"]

{"sheet":"Prices","index":3,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Shirt","Pinpoint"]
["Size",30,null,"Shirt/Size",30,35,40,45,50]
["Quantity",5,null,"Camp",30,32,35,35,40]
["Row Index",null,null,"Flannel",35,36,37,38,39]
["Column Index",null,null,"Oxford",19,19,19,22,22]
["Cost",null,null,"Pinpoint",34,36,36,36,38]
["Discount %",null,null,"Polo",28,32,36,40,44]
[null,null,null,"Rugby",12,16,20,22,24]
["Cost (with Discount)"]
[]
[]
[null,null,null,"Bought Between",null,"Discount %"]
[null,null,null,0,4,0]
[null,null,null,5,9,0.02]
[null,null,null,10,19,0.03]
[null,null,null,20,49,0.05]
[null,null,null,50,99,7.0000000000000007E-2]
[null,null,null,100,999,0.1]
[null,null,null,1000,null,0.15]