{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Individual User Voting Profile "],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Individual User Voting Profile ","index":0,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,5,4,6],[4,7,4,8],[22,5,25,8],[17,5,17,6],[17,7,17,8]],"flags":["formulas_cached_only"]}
["DPChallenge"]
["Individual User Voting Profile Check"]
["As of March 25, 2007"]
[]
["Normal Vote Ranges",{"$nulls":4},"One Standard Deviation",null,"Two Standard Deviations"]
["Vote Value","SumOf# Votes","% of Total","StDevOf# Votes","StDev%","Low Range","High Range","Low Range","High Range",null,null,"To use this spreadsheet:"]
[1,8157,0.013850095678912775,207.3464019558584,0.0254194436626037,0,0.039269539341516474,0,0.06468898300412018,null,null,"Click on Tools/Scenarios"]
[2,16549,0.028099207231865576,373.4257595276307,0.022564853436922515,0.005534353794943062,0.05066406066878809,0,0.07322891410571061,null,null,"Highlight a username on the Scenario Manager list"]
[3,45093,0.07656520343866786,970.4695443261712,0.021521512082278208,0.05504369135638966,0.09808671552094607,0.03352217927411145,0.11960822760322429,null,null,"Click \"Show\" in the dialog box"]
[4,112760,0.1914597019436318,2186.1814225084827,0.019387916127247985,0.1720717858163838,0.2108476180708798,0.15268386968913583,0.23023553419812776]
[5,175715,0.2983535076891208,3289.12452622121,0.018718518773133824,0.2796349889159869,0.31707202646225463,0.26091647014285313,0.3357905452353884]
[6,119508,0.20291740031819394,2237.508461380085,0.01872266677862641,0.18419473353956753,0.22164006709682035,0.16547206676094112,0.24036273387544677]
[7,61399,0.10425181127737716,1194.7418933887695,0.019458653942063708,0.08479315733531345,0.12371046521944087,0.06533450339324975,0.14316911916150457]
[8,26843,0.0455778004547083,471.8865908737656,0.01757950269618767,0.02799829775852063,0.06315730315089597,0.01041879506233296,0.08073680584708365]
[9,11917,0.02023434966355321,233.54596610266742,0.0195977147019105,0.0006366349616427104,0.039832064365463715,0,0.05942977906737421]
[10,11008,0.018690922303968596,371.41698856398506,0.03374064212972248,0,0.05243156443369107,0,0.08617220656341355]
[]
[{"$nulls":5},"One Standard Deviation",null,"Two Standard Deviations"]
["Vote Value","SumOf# Votes","% of Total","StDevOf# Votes",null,"Review - Low","Review - High","Review - Low","Review - High",null,"First criteria:  Vote Value falls within expected relative range"]
[1,134,0.007900477566181239,null,null,"Review","Review","Review","Review",null,"Second Criteria:  Vote % of total falls within expected Standard Deviation"]
[2,131,0.007723601202759271,null,null," "," "," "," "]
[3,369,0.02175579270090207,null,null,"Review"," ","Review"," ",null,"Things to consider:"]
[4,1679,0.09899180472849478,null,null,"Ignore",{"$nulls":4},"Maybe first pass parameters should be two standard deviations, "]
[5,6612,0.3898355049820176,{"$nulls":7},"Ignore cases where the vote values are too low and only concentrate on too high"]
[6,5172,0.3049348505394729]
[7,1993,0.11750486409999411]
[8,650,0.03832321207475974,null,null," "," "," "," "]
[9,159,0.009374447261364306,null,null," "," "," "," "]
[10,62,0.0036554448440540063,null,null," "," "," "," "]
[null,16961]