{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["P(1)","P(1an)","P(2)P153-155","P153-155(an)","P(3)P155-156","SiteX","SiteY","P155(an)","P155(an2)","P155(an3)","P155(an4)","P156(an1)","P156(an2)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":22,"comments":0,"pivot_tables":1},"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":"P(1)","index":0,"n_rows":1193,"n_cols":4,"rows_kept":1193,"cut":false,"hidden":false,"merged":[]}
["1) Create a table that extracts the 5 largest values from the Sales column. 2) Create a table that extracts the 5 smallest values from the COGS column. 3) Create a table that calculates the average Units, Sales and COGS for each Sales Rep."]
[]
[]
["Sales Rep","Units","Sales","COGS"]
["Richard",255,255648,191736]
["Manavbir",470,470564,385862.48000000004]
["Janita",195,195823,148825.48000000001]
["Mitchell",388,388300,349470]
["Christina",223,223659,185636.97]
["Nakyun",291,291969,239414.58000000002]
["Mitchell",239,239386,172357.91999999998]
["Daniel",398,398538,294918.12]
["Mi",132,132446,108605.72]
["Richard",221,221452,190448.72]
["Kaur",344,344551,299759.37]
["Ewelina",466,466662,331330.01999999996]
["Ewelina",281,281412,236386.08]
["Mitchell",167,167214,142131.9]
["Nelia",394,394341,295755.75]
["Craig",497,497678,432979.86]
["Carol",383,383583,268508.09999999998]
["Nelia",365,365081,277461.56]
["Denise",225,225682,182802.42]
["Richard",360,360377,291905.37]
["Nelia",458,458756,399117.72]
["Nelia",432,432320,319916.79999999999]
["Richard",314,314469,283022.10000000003]
["Sarah",180,180252,151411.68]
["Nakyun",160,160859,144773.1]
["Janita",193,193122,171878.58000000002]
["Kaur",155,155741,124592.8]
["Shari",96,96704,76396.160000000003]
["Shari",390,390366,324003.77999999997]
["Yla-Katrina",185,185196,162972.48000000001]
["Denise",498,498495,378856.2]
["Richard",209,209973,149080.82999999999]
["Carol",250,250643,223072.27]
["Michelle",418,418673,297257.82999999996]
["Nakyun",193,193274,154619.20000000001]
["Ewelina",255,255856,184216.32000000001]
["Janita",315,315776,258936.32000000001]
["Nelia",241,241548,178745.52]
["Mi",125,125433,100346.40000000001]
["Nakyun",372,372365,301615.65000000002]
["Manavbir",309,309851,232388.25]
["Janita",266,266403,197138.22]
["Manavbir",448,448224,345132.48]
["Shari",109,109997,96797.36]
["Manavbir",53,53865,38244.15]
["Mi",105,105027,79820.52]
["Craig",211,211577,158682.75]
["Nelia",286,286226,228980.80000000002]
["Shari",481,481771,351692.83]
["Michael",266,266460,210503.40000000002]
["Elain",328,328934,263147.2]
["Nelia",194,194843,155874.4]
["Gianna",366,366227,267345.71000000002]
["Denise",108,108046,86436.800000000003]
["Denise",251,251015,208342.44999999998]
["Jason",315,315040,255182.40000000002]
["Craig",458,458925,357961.5]
["Richard",80,80911,64728.800000000003]
["Craig",109,109871,94489.06]
["Debra",182,182009,152887.56]
["Ewelina",476,476420,352550.8]
["Manavbir",53,53912,46903.44]
["Richard",307,307166,239589.48]
["Sarah",77,77586,66723.959999999992]
["Gianna",334,334613,247613.62]
["Nelia",176,176270,142778.70000000001]
["Sarah",361,361529,300069.07]
["Manavbir",364,364777,284526.06]
["Kaur",464,464402,366877.58]
["Elain",118,118912,95129.600000000006]
["Gianna",412,412097,313193.72000000003]
["Debra",245,245822,186824.72]
["Jason",112,112747,84560.25]
["Shari",262,262648,217997.84]
["Nelia",404,404358,363922.2]
["Sarah",364,364952,310209.2]
["Jason",146,146567,115787.93000000001]
["Mitchell",232,232300,199778]
["Gianna",397,397755,322181.55000000005]
["Jason",329,329310,240396.3]
["Michael",186,186162,141483.12]
["Sarah",479,479524,426776.36]
["Richard",261,261803,188498.16]
["Sarah",197,197409,159901.29]
["Gianna",224,224385,166044.9]
["Mi",449,449644,368708.08]
["Sarah",308,308693,262389.05]
["Michael",68,68480,54099.200000000004]
["Yla-Katrina",151,151640,119795.6]
["Christina",189,189921,148138.38]
["Craig",348,348411,271760.58]
["Mitchell",321,321917,244656.92]
["Mi",333,333409,290065.83]
["Craig",451,451663,334230.62]
["Mitchell",325,325432,279871.52]
["Mi",345,345917,266356.09000000003]
["Nakyun",311,311405,239781.85]
["Nelia",136,136662,117529.31999999999]
["Sarah",320,320822,282323.36]
["Manavbir",458,458772,330315.83999999997]
["Mi",499,499040,384260.8]
["Elain",192,192618,142537.32]
["Mi",469,469848,366481.44]
["Carol",230,230473,161331.09999999998]
["Nakyun",108,108680,76076]
["Michael",64,64450,50271]
["Kaur",77,77782,63781.240000000005]
["Mitchell",98,98640,79898.400000000009]
["Sykes",430,430742,318749.08]
["Carol",384,384922,311786.82]
["Mansa",110,110594,80733.62]
["Richard",300,300987,225740.25]
["Sykes",479,479494,388390.14]
["Christina",195,195218,163983.12]
["Jason",124,124127,89371.44]
["Sarah",423,423292,330167.76]
["Mitchell",487,487970,370857.2]
["Mitchell",159,159752,121411.52]
["Debra",187,187293,146088.54]
["Manavbir",123,123949,110314.61]
["Nakyun",370,370610,311312.39999999997]
["Michelle",287,287075,252626]
["Denise",312,312079,271508.73]
["Mitchell",116,116810,105129]
["Nelia",380,380051,334444.88]
["Mitchell",155,155187,121045.86]
["Michelle",199,199685,145770.04999999999]
["Carol",117,117887,106098.3]
["Christina",343,343726,302478.88]
["Nakyun",391,391203,309050.37]
["Carol",386,386138,305049.02]
["Nelia",269,269412,242470.80000000002]
["Michelle",400,400025,340021.25]
["Mansa",134,134024,120621.6]
["Nelia",368,368591,298558.71000000002]
["Yla-Katrina",310,310932,251854.92]
["Mi",407,407700,346545]
["Jason",418,418121,330315.59000000003]
["Richard",390,390658,292993.5]
["Daniel",360,360778,274191.28000000003]
["Janita",334,334608,267686.40000000002]
["Ewelina",130,130197,108063.51]
["Denise",97,97429,86711.81]
["Janita",349,349386,279508.8]
["Christina",180,180077,149463.91]
["Sykes",256,256472,192354]
["Gianna",223,223812,161144.63999999998]
["Ewelina",112,112375,97766.25]
["Michelle",436,436654,379888.98]
["Kaur",288,288949,245606.65]
["Gianna",277,277126,193988.19999999998]
["Michael",457,457431,361370.49]
["Jason",422,422806,295964.19999999995]
["Craig",268,268910,204371.6]
["Richard",125,125545,100436]
["Denise",247,247754,203158.28000000003]
["Michael",190,190321,156063.22]
["Kaur",432,432206,324154.5]
["Michael",363,363781,265560.13]
["Jason",318,318417,241996.92]
["Yla-Katrina",420,420671,378603.9]
["Nakyun",465,465031,334822.32]
["Mitchell",84,84744,76269.600000000006]
["Sykes",261,261747,183222.9]
["Mi",181,181856,152759.04000000001]
["Michelle",56,56438,42328.5]
["Kaur",136,136789,98488.08]
["Mitchell",392,392462,302195.74]
["Shari",120,120267,93808.260000000009]
["Mansa",398,398475,314795.25]
["Carol",57,57979,42904.46]
["Ewelina",317,317917,247975.26]
["Carol",404,404822,336002.26]
["Denise",222,222636,182561.52000000002]
["Daniel",230,230878,173158.5]
["Yla-Katrina",312,312560,231294.4]
["Carol",245,245278,210939.08]
["Mi",356,356267,302826.95]
["Sarah",402,402983,306267.08]
["Ewelina",218,218463,192247.44]
["Denise",128,128214,114110.46]
["Debra",60,60092,51078.2]
["Janita",129,129953,111759.58]
["Nakyun",88,88690,78047.199999999997]
["Craig",329,329605,286756.34999999998]
["Kaur",403,403284,306495.84000000003]
["Jason",250,250794,223206.66]
["Michelle",438,438743,377318.98]
["Yla-Katrina",310,310385,266931.09999999998]
["Craig",498,498670,378989.2]
["Yla-Katrina",408,408237,306177.75]
["Kaur",284,284189,213141.75]
["Carol",75,75653,55226.689999999995]
["Daniel",140,140278,99597.37999999999]
["Elain",322,322466,248298.82]
["Richard",128,128228,92324.160000000003]
["Mi",280,280569,244095.03]
["Yla-Katrina",388,388044,341478.72000000003]
["Mi",85,85550,72717.5]
["Daniel",317,317007,256775.67]
["Debra",237,237535,187652.65]
["Michael",207,207162,161586.36000000002]
["Michelle",472,472929,387801.78]
["Sarah",133,133585,108203.85]
["Denise",94,94344,84909.6]
["Gianna",205,205386,158147.22]
["Sarah",325,325770,231296.69999999998]
["Mi",112,112341,98860.08]
["Janita",402,402189,349904.43]
["Sarah",470,470312,399765.2]
["Nelia",486,486098,413183.3]
["Michael",438,438290,311185.89999999997]
["Janita",481,481322,380244.38]
["Elain",492,492894,349954.74]
["Mi",92,92158,66353.759999999995]
["Mitchell",213,213918,192526.2]
["Nakyun",73,73243,53467.39]
["Denise",293,293776,246771.84]
["Christina",426,426290,311191.7]
["Kaur",89,89081,79282.09]
["Craig",72,72339,58594.590000000004]
["Mi",456,456272,365017.60000000003]
["Elain",168,168242,129546.34]
["Kaur",196,196125,139248.75]
["Yla-Katrina",191,191591,157104.62000000002]
["Daniel",55,55373,42637.21]
["Debra",321,321208,224845.59999999998]
["Jason",261,261610,227600.7]
["Craig",63,63613,56615.57]
["Daniel",278,278707,225752.67]
["Sykes",154,154346,112672.58]
["Craig",178,178165,149658.6]
["Mitchell",472,472232,415564.16]
["Mitchell",463,463271,333555.12]
["Yla-Katrina",473,473243,411721.41]
["Debra",427,427874,359414.16]
["Ewelina",309,309860,247888]
["Carol",226,226574,181259.2]
["Kaur",488,488039,375790.03]
["Jason",55,55235,49159.15]
["Shari",64,64324,55318.64]
["Michael",141,141360,122983.2]
["Richard",115,115652,104086.8]
["Denise",382,382432,328891.52000000002]
["Kaur",482,482575,419840.25]
["Daniel",380,380889,335182.32]
["Denise",422,422959,321448.84000000003]
["Shari",499,499245,394403.55000000005]
["Michael",401,401538,309184.26]
["Jason",122,122237,88010.64]
["Nakyun",265,265939,199454.25]
["Nakyun",354,354629,304980.94]
["Nakyun",95,95858,84355.04]
["Jason",276,276104,248493.6]
["Mi",323,323862,268805.45999999996]
["Debra",149,149185,111888.75]
["Mi",441,441376,397238.4]
["Sykes",435,435218,330765.68]
["Mitchell",387,387090,348381]
["Craig",98,98767,88890.3]
["Janita",366,366769,260405.99]
["Jason",499,499782,439808.16]
["Yla-Katrina",416,416145,366207.6]
["Gianna",395,395059,319997.79000000004]
["Michelle",188,188194,148673.26]
["Denise",155,155883,110676.93]
["Denise",83,83368,71696.479999999996]
["Yla-Katrina",93,93432,71008.320000000007]
["Craig",176,176120,149702]
["Debra",223,223547,160953.84]
["Debra",464,464635,353122.6]
["Mi",355,355258,266443.5]
["Gianna",389,389795,350815.5]
["Debra",80,80225,60971]
["Yla-Katrina",107,107396,90212.64]
["Christina",358,358565,315537.2]
["Richard",381,381796,332162.52]
["Nelia",313,313408,228787.84]
["Manavbir",369,369106,276829.5]
["Michelle",203,203106,182795.4]
["Denise",481,481181,365697.56]
["Craig",132,132494,94070.739999999991]
["Nelia",88,88376,75119.599999999991]
["Sykes",114,114937,96547.08]
["Christina",399,399336,319468.80000000005]
["Mansa",430,430466,374505.42]
["Mi",254,254391,190793.25]
["Michelle",238,238732,200534.88]
["Carol",433,433515,381493.2]
["Richard",486,486429,364821.75]
["Carol",72,72111,60573.24]
["Mi",439,439223,377731.77999999997]
["Mansa",58,58701,42264.72]
["Janita",475,475598,428038.2]
["Nelia",262,262130,214946.6]
["Sarah",143,143201,100240.7]
["Richard",152,152216,121772.8]
["Nelia",328,328869,243363.06]
["Denise",75,75544,56658]
["Gianna",398,398367,334628.27999999997]
["Elain",460,460701,391595.85]
["Christina",498,498486,373864.5]
["Elain",138,138313,112033.53000000001]
["Craig",320,320825,227785.75]
["Debra",494,494680,371010]
["Yla-Katrina",180,180220,151384.79999999999]
["Mi",428,428196,299737.19999999995]
["Gianna",375,375440,262808]
["Michael",293,293350,246414]
["Sarah",496,496540,347578]
["Kaur",499,499003,369262.22]
["Manavbir",466,466669,410668.72000000003]
["Yla-Katrina",204,204108,153081]
["Mitchell",68,68100,48351]
["Richard",184,184100,139916]
["Nakyun",278,278313,208734.75]
["Carol",199,199351,159480.80000000002]
["Mansa",274,274701,192290.69999999998]
["Craig",360,360038,309632.68]
["Manavbir",327,327764,281877.03999999998]
["Manavbir",69,69473,55578.400000000001]
["Elain",115,115353,103817.7]
["Elain",191,191038,133726.6]
["Carol",140,140634,108288.18000000001]
["Richard",148,148368,115727.04000000001]
["Janita",55,55483,39392.93]
["Jason",149,149228,104459.59999999999]
["Janita",272,272553,218042.40000000002]
["Elain",299,299475,269527.5]
["Christina",199,199161,179244.9]
["Sarah",300,300051,267045.39]
["Kaur",472,472940,354705]
["Craig",402,402529,313972.62]
["Michael",129,129133,90393.099999999991]
["Debra",324,324323,272431.32]
["Christina",369,369677,303135.14]
["Sykes",234,234505,201674.3]
["Carol",321,321732,250950.96000000002]
["Nakyun",199,199454,147595.96]
["Jason",412,412942,351000.7]
["Elain",176,176503,141202.4]
["Yla-Katrina",370,370307,274027.18]
["Sarah",397,397764,338099.39999999997]
["Denise",75,75233,56424.75]
["Sykes",88,88214,79392.600000000006]
["Michelle",179,179706,149155.97999999998]
["Elain",113,113729,93257.780000000013]
["Janita",211,211445,171270.45]
["Jason",226,226321,185583.22]
["Sykes",310,310036,248028.80000000002]
["Denise",330,330971,244918.54]
["Nakyun",133,133110,105156.90000000001]
["Sarah",109,109303,79791.19]
["Mansa",69,69035,50395.549999999996]
["Nakyun",267,267043,229656.98]
["Sykes",169,169728,127296]
["Mansa",73,73554,61785.36]
["Christina",312,312461,221847.31]
["Mitchell",169,169900,139318]
["Nakyun",163,163685,114579.5]
["Sarah",492,492037,423151.82]
["Craig",122,122594,95623.32]
["Kaur",356,356678,321010.2]
["Mi",85,85180,66440.400000000009]
["Mansa",337,337474,303726.60000000003]
["Richard",122,122403,93026.28]
["Sarah",257,257631,206104.80000000002]
["Sykes",151,151950,106365]
["Sykes",186,186384,139788]
["Sarah",219,219944,193550.72]
["Mitchell",245,245166,205939.44]
["Mansa",264,264466,222151.44]
["Nelia",111,111595,85928.150000000009]
["Mitchell",317,317258,250633.82]
["Yla-Katrina",367,367869,264865.68]
["Daniel",324,324247,252912.66]
["Sarah",460,460548,386860.32]
["Manavbir",147,147007,119075.67000000001]
["Debra",202,202273,151704.75]
["Carol",173,173403,128318.22]
["Craig",253,253463,220512.81]
["Ewelina",420,420803,345058.46]
["Craig",209,209557,188601.30000000002]
["Yla-Katrina",193,193361,164356.85]
["Mi",101,101324,84098.92]
["Carol",323,323023,251957.94]
["Mi",391,391285,305202.3]
["Gianna",250,250693,183005.88999999998]
["Daniel",76,76398,64938.299999999996]
["Jason",146,146586,120200.52]
["Carol",462,462871,411955.19]
["Debra",270,270556,197505.88]
["Nakyun",306,306068,238733.04]
["Mitchell",464,464420,357603.4]
["Gianna",399,399409,303550.84000000003]
["Sarah",485,485499,398109.18000000005]
["Gianna",74,74879,60651.990000000005]
["Daniel",375,375833,308183.06]
["Elain",385,385688,308550.40000000002]
["Mansa",335,335792,268633.60000000003]
["Michelle",465,465077,390664.68]
["Nelia",344,344579,286000.57]
["Manavbir",374,374755,266076.05]
["Denise",286,286360,240542.4]
["Christina",223,223585,160981.19999999998]
["Yla-Katrina",301,301580,250311.4]
["Yla-Katrina",492,492415,418552.75]
["Michelle",397,397502,282226.42]
["Sarah",245,245505,184128.75]
["Michelle",71,71064,51876.72]
["Richard",236,236878,198977.52]
["Elain",70,70330,51340.9]
["Sykes",192,192835,138841.19999999998]
["Kaur",254,254502,198511.56]
["Christina",484,484884,402453.72]
["Mitchell",466,466294,415001.66000000003]
["Mitchell",219,219059,173056.61000000002]
["Richard",98,98707,87849.23]
["Carol",337,337735,300584.15000000002]
["Kaur",477,477270,367497.9]
["Richard",233,233295,179637.15]
["Daniel",445,445113,329383.62]
["Shari",179,179934,125953.79999999999]
["Craig",343,343776,281896.32000000001]
["Craig",478,478452,377977.08]
["Debra",421,421790,358521.5]
["Sarah",486,486953,423649.11]
["Michael",455,455780,341835]
["Kaur",386,386027,297240.78999999998]
["Mi",172,172347,120642.9]
["Mi",101,101110,87965.7]
["Carol",222,222767,196034.96]
["Yla-Katrina",421,421536,316152]
["Ewelina",434,434296,364808.64]
["Carol",391,391522,328878.48]
["Sykes",113,113979,95742.36]
["Janita",150,150337,127786.45]
["Mansa",226,226899,192864.15]
["Mansa",263,263940,195315.6]
["Janita",164,164196,129714.84000000001]
["Carol",320,320434,237121.16]
["Michelle",416,416746,370903.94]
["Kaur",291,291111,206688.81]
["Nakyun",103,103033,82426.400000000009]
["Carol",127,127025,90187.75]
["Carol",457,457886,366308.80000000005]
["Janita",289,289849,214488.26]
["Mansa",69,69341,50618.93]
["Craig",79,79160,59370]
["Yla-Katrina",323,323064,277835.03999999998]
["Shari",486,486114,403474.62]
["Kaur",413,413955,293908.05]
["Michael",488,488993,391194.4]
["Daniel",388,388396,299064.92]
["Elain",388,388351,279612.71999999997]
["Sarah",398,398574,354730.86]
["Michelle",299,299461,218606.53]
["Janita",86,86527,61434.17]
["Mansa",101,101426,73026.720000000001]
["Debra",355,355032,298226.88]
["Denise",294,294582,259232.16]
["Daniel",55,55376,46515.839999999997]
["Gianna",455,455869,378371.26999999996]
["Michael",265,265882,236634.98]
["Debra",82,82977,63062.520000000004]
["Richard",279,279842,204284.66]
["Mi",116,116643,102645.84]
["Daniel",396,396871,333371.64]
["Craig",407,407473,354501.51]
["Sarah",162,162235,136277.4]
["Mansa",310,310582,254677.24000000002]
["Yla-Katrina",380,380337,323286.45]
["Sykes",493,493858,370393.5]
["Manavbir",109,109786,86730.94]
["Debra",133,133121,109159.22]
["Manavbir",134,134635,109054.35]
["Jason",182,182511,140533.47]
["Janita",478,478118,344244.95999999996]
["Nelia",324,324218,233436.96]
["Daniel",372,372451,335205.90000000002]
["Sykes",302,302477,220808.21]
["Michelle",64,64225,45599.75]
["Nelia",97,97326,74941.02]
["Carol",332,332501,249375.75]
["Sarah",423,423639,330438.42]
["Mitchell",140,140589,111065.31000000001]
["Michael",267,267765,190113.15]
["Yla-Katrina",206,206715,171573.44999999998]
["Sykes",208,208881,152483.13]
["Richard",459,459006,353434.62]
["Craig",454,454649,354626.22000000003]
["Carol",311,311505,264779.25]
["Ewelina",389,389539,327212.76]
["Yla-Katrina",195,195061,142394.53]
["Daniel",311,311522,236756.72]
["Carol",92,92597,67595.81]
["Nelia",424,424928,297449.59999999998]
["Mansa",118,118806,85540.319999999992]
["Mitchell",67,67093,50319.75]
["Shari",150,150040,124533.2]
["Shari",170,170075,119052.49999999999]
["Janita",362,362538,271903.5]
["Daniel",372,372448,268162.56]
["Gianna",277,277042,229944.86]
["Michael",494,494934,400896.54000000004]
["Michael",474,474028,350780.72]
["Christina",454,454327,340745.25]
["Craig",385,385389,304457.31]
["Christina",280,280452,215948.04]
["Yla-Katrina",350,350314,294263.76]
["Michelle",266,266946,194870.58]
["Janita",336,336585,279365.55]
["Nakyun",200,200054,144038.88]
["Yla-Katrina",94,94761,74861.19]
["Shari",148,148604,117397.16]
["Sykes",131,131870,108133.40000000001]
["Richard",65,65409,53635.380000000005]
["Denise",144,144648,105593.04]
["Craig",442,442988,336670.88]
["Christina",250,250036,210030.24]
["Jason",151,151860,136674]
["Nelia",131,131570,111834.5]
["Michelle",185,185807,167226.30000000002]
["Nelia",447,447300,393624]
["Christina",181,181227,157667.49]
["Denise",356,356851,299754.83999999997]
["Sarah",371,371945,271519.84999999998]
["Manavbir",497,497252,377911.52]
["Janita",192,192585,142512.9]
["Nakyun",225,225351,196055.37]
["Kaur",114,114301,100584.88]
["Christina",462,462089,369671.2]
["Mitchell",352,352961,310605.68]
["Yla-Katrina",424,424374,318280.5]
["Elain",424,424463,314102.62]
["Mansa",316,316569,227929.68]
["Daniel",305,305780,223219.4]
["Shari",267,267430,224641.19999999998]
["Yla-Katrina",367,367959,283328.43]
["Kaur",484,484127,377619.06]
["Jason",63,63605,47703.75]
["Sarah",60,60432,47741.279999999999]
["Daniel",251,251227,221079.76]
["Shari",165,165055,141947.29999999999]
["Debra",293,293196,263876.40000000002]
["Yla-Katrina",376,376454,263517.8]
["Craig",144,144125,105211.25]
["Nakyun",305,305984,266206.08000000002]
["Nelia",219,219121,186252.85]
["Jason",405,405935,300391.90000000002]
["Debra",77,77117,60922.43]
["Nelia",335,335029,264672.91000000003]
["Daniel",261,261401,198664.76]
["Gianna",118,118590,105545.1]
["Mi",313,313600,238336]
["Michael",270,270662,205703.12]
["Sykes",304,304100,246321.00000000003]
["Mitchell",164,164565,131652]
["Kaur",247,247958,173570.59999999998]
["Jason",174,174767,152047.29]
["Christina",399,399968,335973.12]
["Kaur",110,110407,79493.039999999994]
["Carol",232,232513,192985.78999999998]
["Elain",270,270235,191866.84999999998]
["Mi",389,389501,334970.86]
["Christina",128,128752,90126.399999999994]
["Mitchell",201,201329,142943.59]
["Michelle",359,359069,276483.13]
["Kaur",220,220471,171967.38]
["Yla-Katrina",187,187138,144096.26]
["Daniel",346,346259,287394.96999999997]
["Kaur",57,57311,45275.69]
["Richard",457,457641,338654.33999999997]
["Debra",274,274055,224725.1]
["Carol",311,311154,264480.89999999997]
["Kaur",200,200070,180063]
["Nelia",50,50045,40536.450000000004]
["Michelle",280,280876,230318.32]
["Elain",278,278742,206269.08]
["Yla-Katrina",418,418404,297066.83999999997]
["Manavbir",185,185254,166728.6]
["Yla-Katrina",414,414576,310932]
["Mi",128,128800,109480]
["Gianna",171,171610,123559.2]
["Mitchell",56,56299,45602.19]
["Richard",140,140535,125076.15000000001]
["Yla-Katrina",201,201643,173412.98]
["Sarah",155,155095,124076]
["Daniel",372,372154,308887.82]
["Jason",271,271303,189912.09999999998]
["Nakyun",137,137651,118379.86]
["Shari",458,458771,353253.67]
["Carol",487,487621,370591.96]
["Nelia",296,296846,237476.80000000002]
["Michael",68,68262,59387.94]
["Craig",127,127892,89524.4]
["Manavbir",265,265562,199171.5]
["Manavbir",451,451439,347608.03]
["Sykes",395,395559,304580.43]
["Denise",134,134137,116699.19]
["Michael",152,152856,123813.36000000002]
["Elain",237,237365,175650.1]
["Mansa",348,348098,243668.59999999998]
["Shari",382,382471,309801.51]
["Michelle",380,380477,323405.45]
["Sarah",258,258500,211970.00000000003]
["Mi",324,324837,253372.86000000002]
["Nakyun",331,331085,281422.25]
["Sarah",52,52794,43291.08]
["Manavbir",434,434268,373470.48]
["Michael",269,269832,218563.92]
["Mi",301,301543,253296.12]
["Debra",269,269694,210361.32]
["Richard",134,134265,120838.5]
["Mi",353,353208,254309.75999999998]
["Ewelina",231,231029,187133.49000000002]
["Carol",248,248177,215913.99]
["Michael",232,232311,195141.24]
["Michelle",114,114109,96992.65]
["Sarah",192,192737,167681.19]
["Daniel",242,242675,177152.75]
["Shari",416,416409,320634.93]
["Ewelina",114,114410,96104.4]
["Nakyun",332,332204,269085.24]
["Christina",318,318276,235524.24]
["Sarah",63,63490,50792]
["Craig",124,124167,109266.96]
["Manavbir",53,53854,46852.98]
["Ewelina",439,439667,386906.96]
["Nelia",229,229500,199665]
["Ewelina",340,340683,279360.06]
["Sykes",106,106407,86189.670000000013]
["Janita",280,280247,227000.07]
["Ewelina",234,234322,206203.36000000002]
["Jason",467,467740,416288.60000000003]
["Shari",60,60798,48030.420000000006]
["Debra",236,236097,191238.57]
["Yla-Katrina",461,461314,336759.22]
["Richard",61,61057,48235.03]
["Yla-Katrina",133,133225,94589.75]
["Ewelina",481,481074,408912.89999999997]
["Elain",303,303253,236537.34]
["Mitchell",361,361271,256502.40999999997]
["Yla-Katrina",266,266929,189519.59]
["Mansa",259,259225,209972.25]
["Kaur",62,62715,48290.55]
["Mitchell",368,368295,261489.44999999998]
["Shari",464,464268,371414.4]
["Kaur",77,77430,58846.8]
["Ewelina",117,117766,88324.5]
["Christina",120,120938,85865.98]
["Christina",458,458425,407998.25]
["Shari",349,349757,255322.61]
["Richard",315,315460,264986.39999999997]
["Mitchell",188,188641,169776.9]
["Daniel",413,413367,338960.94]
["Craig",144,144015,122412.75]
["Richard",462,462501,365375.79000000004]
["Elain",276,276520,218450.80000000002]
["Manavbir",142,142059,99441.299999999988]
["Daniel",63,63925,53057.75]
["Craig",223,223657,156559.9]
["Jason",360,360369,317124.72000000003]
["Michelle",411,411800,333558]
["Carol",327,327692,252322.84]
["Shari",322,322816,277621.76000000001]
["Janita",308,308172,274273.08]
["Gianna",83,83876,75488.400000000009]
["Yla-Katrina",198,198422,152784.94]
["Mansa",465,465708,325995.59999999998]
["Michelle",488,488471,341929.69999999995]
["Richard",170,170101,129276.76]
["Mitchell",55,55628,47840.08]
["Shari",461,461693,341652.82]
["Mi",269,269071,234091.77]
["Denise",282,282347,203289.84]
["Mi",110,110092,96880.960000000006]
["Christina",217,217568,154473.28]
["Michael",391,391167,312933.60000000003]
["Ewelina",350,350292,266221.92]
["Gianna",410,410326,291331.45999999996]
["Christina",339,339172,264554.16000000003]
["Christina",193,193288,156563.28]
["Nakyun",62,62133,50949.060000000005]
["Christina",276,276341,240416.67]
["Shari",280,280289,210216.75]
["Manavbir",199,199136,161300.16]
["Richard",434,434933,365343.72]
["Ewelina",445,445426,360795.06]
["Sarah",325,325906,270501.98]
["Nakyun",416,416399,362267.13]
["Sykes",318,318199,238649.25]
["Ewelina",54,54300,42354]
["Michael",447,447455,353489.45]
["Michael",423,423851,368750.37]
["Mi",162,162236,144390.04]
["Mansa",453,453530,408177]
["Mitchell",162,162156,126481.68000000001]
["Janita",358,358386,290292.66000000003]
["Manavbir",321,321789,247777.53]
["Sykes",58,58312,45483.360000000001]
["Mansa",414,414439,331551.2]
["Kaur",381,381754,339761.06]
["Daniel",56,56455,46857.649999999994]
["Mitchell",318,318211,280025.68]
["Michelle",183,183854,136051.96]
["Richard",211,211148,185810.24]
["Carol",432,432463,367593.55]
["Yla-Katrina",91,91814,64269.799999999996]
["Nakyun",439,439034,355617.54000000004]
["Sarah",164,164885,115419.49999999999]
["Kaur",217,217916,187407.76]
["Ewelina",184,184471,166023.9]
["Nakyun",232,232283,164920.93]
["Christina",225,225291,173474.07]
["Jason",136,136798,109438.40000000001]
["Jason",473,473526,340938.72]
["Sarah",63,63301,53805.85]
["Mansa",333,333747,246972.78]
["Michelle",91,91648,82483.199999999997]
["Ewelina",137,137399,114041.17]
["Craig",305,305589,235303.53]
["Shari",224,224942,202447.80000000002]
["Nakyun",456,456973,324450.82999999996]
["Nelia",459,459204,408691.56]
["Nakyun",204,204632,153474]
["Mi",452,452440,334805.59999999998]
["Michael",327,327057,261645.6]
["Carol",108,108297,90969.48]
["Sarah",189,189314,141985.5]
["Nakyun",419,419706,344158.92000000004]
["Gianna",391,391980,313584]
["Yla-Katrina",459,459981,395583.66]
["Michelle",470,470136,362004.72000000003]
["Sykes",129,129337,97002.75]
["Yla-Katrina",440,440699,356966.19]
["Shari",353,353780,300713]
["Mi",162,162328,134732.24]
["Mansa",124,124219,88195.489999999991]
["Sarah",141,141927,102187.44]
["Nelia",281,281884,208594.16]
["Kaur",306,306584,269793.91999999998]
["Manavbir",220,220392,154274.4]
["Christina",210,210794,179174.9]
["Richard",81,81587,67717.209999999992]
["Carol",140,140129,106498.04000000001]
["Richard",133,133369,117364.72]
["Mansa",426,426923,345807.63]
["Richard",337,337455,259840.35]
["Nakyun",230,230318,184254.40000000002]
["Denise",496,496495,397196]
["Shari",177,177889,151205.65]
["Mi",286,286567,232119.27000000002]
["Daniel",305,305371,256511.63999999998]
["Nakyun",418,418241,305315.93]
["Debra",153,153797,138417.30000000002]
["Shari",346,346316,245884.36]
["Christina",119,119481,94389.99]
["Michael",77,77309,69578.100000000006]
["Mitchell",336,336333,242159.75999999998]
["Mansa",245,245174,203494.41999999998]
["Nelia",338,338445,280909.34999999998]
["Daniel",290,290361,232288.80000000002]
["Mitchell",266,266990,221601.69999999998]
["Kaur",192,192427,163562.94999999998]
["Gianna",388,388490,326331.59999999998]
["Nakyun",425,425634,374557.92]
["Carol",192,192131,138334.32]
["Carol",147,147166,123619.44]
["Christina",450,450860,329127.8]
["Michelle",334,334445,234111.49999999997]
["Sarah",216,216382,192579.98]
["Michelle",170,170171,151452.19]
["Michael",317,317223,228400.56]
["Debra",77,77850,57609]
["Nakyun",487,487318,341122.6]
["Yla-Katrina",476,476745,410000.7]
["Jason",429,429155,308991.59999999998]
["Christina",429,429539,326449.64]
["Michelle",158,158968,131943.44]
["Richard",83,83765,64499.05]
["Yla-Katrina",423,423395,309078.34999999998]
["Michael",333,333972,300574.8]
["Sykes",325,325581,273488.03999999998]
["Craig",432,432776,380842.88]
["Jason",377,377083,312978.89]
["Sykes",53,53628,41829.840000000004]
["Nakyun",424,424432,365011.52]
["Kaur",356,356150,316973.5]
["Mitchell",186,186060,132102.6]
["Michael",161,161999,124739.23]
["Kaur",235,235186,197556.24]
["Sykes",466,466729,410721.52]
["Ewelina",485,485371,344613.41]
["Carol",215,215354,155054.88]
["Debra",149,149024,126670.39999999999]
["Debra",376,376238,327327.06]
["Manavbir",142,142820,105686.8]
["Denise",424,424117,309605.40999999997]
["Carol",153,153381,133441.47]
["Manavbir",103,103370,78561.2]
["Ewelina",204,204222,153166.5]
["Kaur",255,255359,178751.3]
["Gianna",449,449447,400007.83]
["Debra",375,375151,292617.78000000003]
["Debra",393,393917,307255.26]
["Debra",450,450028,328520.44]
["Mansa",138,138700,110960]
["Mitchell",209,209879,176298.36]
["Michael",214,214575,171660]
["Elain",326,326370,228459]
["Michelle",464,464165,324915.5]
["Shari",309,309644,216750.8]
["Kaur",460,460792,396281.12]
["Michelle",469,469246,351934.5]
["Denise",301,301783,262551.21000000002]
["Michelle",470,470942,334368.82]
["Carol",92,92075,67214.75]
["Sarah",499,499729,429766.94]
["Nelia",415,415872,365967.35999999999]
["Debra",461,461484,332268.48]
["Elain",196,196539,157231.20000000001]
["Manavbir",336,336238,285802.3]
["Ewelina",409,409435,360302.8]
["Sarah",53,53315,44784.6]
["Gianna",261,261457,188249.03999999998]
["Sykes",451,451115,324802.8]
["Nelia",483,483147,357528.77999999997]
["Mansa",155,155125,122548.75]
["Craig",344,344794,299970.77999999997]
["Craig",214,214162,167046.36000000002]
["Michelle",211,211563,158672.25]
["Daniel",260,260426,203132.28]
["Christina",278,278308,219863.32]
["Mansa",311,311723,224440.56]
["Ewelina",384,384107,303444.53000000003]
["Denise",62,62642,50740.020000000004]
["Michelle",297,297565,249954.59999999998]
["Denise",475,475439,366088.03]
["Mi",64,64389,46360.08]
["Michael",456,456406,324048.26]
["Nakyun",401,401057,332877.31]
["Janita",134,134658,111766.14]
["Sarah",110,110276,89323.560000000012]
["Sarah",205,205431,162290.49000000002]
["Sykes",389,389473,276525.82999999996]
["Manavbir",292,292224,210401.28]
["Michelle",464,464845,409063.6]
["Janita",278,278545,208908.75]
["Sykes",84,84765,59335.499999999993]
["Debra",451,451608,388382.88]
["Daniel",301,301454,244177.74000000002]
["Denise",189,189684,170715.6]
["Mitchell",226,226603,165420.19]
["Kaur",483,483854,372567.58]
["Nelia",389,389205,291903.75]
["Debra",426,426437,324092.12]
["Sykes",442,442729,394028.81]
["Gianna",190,190020,163417.20000000001]
["Gianna",413,413091,330472.80000000005]
["Sykes",346,346550,266843.5]
["Kaur",68,68673,58372.049999999996]
["Jason",375,375934,308265.88]
["Shari",317,317537,234977.38]
["Yla-Katrina",369,369030,269391.89999999997]
["Shari",425,425274,323208.24]
["Michael",92,92735,77897.399999999994]
["Gianna",254,254020,226077.80000000002]
["Debra",431,431097,310389.83999999997]
["Kaur",487,487674,365755.5]
["Nelia",493,493125,364912.5]
["Jason",489,489079,381481.62]
["Shari",439,439185,311821.34999999998]
["Ewelina",353,353844,265383]
["Shari",175,175242,129679.08]
["Denise",498,498507,378865.32]
["Michelle",148,148537,111402.75]
["Ewelina",285,285687,239977.08]
["Gianna",448,448621,403758.9]
["Jason",125,125964,105809.76]
["Mi",134,134282,106082.78]
["Ewelina",196,196007,147005.25]
["Nelia",243,243023,177406.79]
["Mi",283,283255,198278.5]
["Sarah",280,280817,210612.75]
["Sarah",499,499060,384276.2]
["Sykes",141,141166,115756.12000000001]
["Christina",228,228379,182703.2]
["Sarah",118,118859,85578.48]
["Christina",444,444775,315790.25]
["Nakyun",219,219553,166860.28]
["Manavbir",81,81385,59411.049999999996]
["Yla-Katrina",368,368649,324411.12]
["Ewelina",471,471231,419395.59]
["Richard",215,215929,157628.16999999998]
["Mi",418,418184,322001.68]
["Mitchell",193,193240,173916]
["Ewelina",173,173658,121560.59999999999]
["Craig",385,385690,331693.40000000002]
["Nelia",409,409236,306927]
["Yla-Katrina",193,193881,162860.04]
["Manavbir",142,142477,109707.29000000001]
["Nelia",271,271180,197961.4]
["Denise",99,99940,86947.8]
["Janita",65,65896,55352.639999999999]
["Manavbir",144,144956,121763.04]
["Sykes",441,441240,375054]
["Daniel",385,385099,319632.17]
["Sykes",63,63495,55875.6]
["Janita",382,382047,271253.37]
["Sarah",351,351858,292042.14]
["Debra",99,99346,80470.260000000009]
["Craig",485,485477,436929.3]
["Christina",457,457889,380047.87]
["Michael",410,410552,320230.56]
["Manavbir",138,138373,119000.78]
["Sarah",228,228122,173372.72]
["Yla-Katrina",371,371923,290099.94]
["Gianna",277,277149,238348.13999999998]
["Debra",429,429286,369185.96]
["Nakyun",309,309471,216629.69999999998]
["Elain",280,280055,198839.05]
["Kaur",326,326783,287569.03999999998]
["Sarah",346,346140,273450.60000000003]
["Debra",469,469052,370551.08]
["Yla-Katrina",195,195790,154674.1]
["Jason",115,115723,97207.319999999992]
["Michelle",365,365317,325132.13]
["Sykes",105,105482,78056.679999999993]
["Shari",464,464359,329694.88999999996]
["Shari",245,245211,193716.69]
["Shari",295,295884,251501.4]
["Gianna",61,61099,51934.15]
["Nakyun",366,366453,260181.62999999998]
["Jason",225,225244,173437.88]
["Mansa",194,194431,174987.9]
["Manavbir",280,280474,241207.63999999998]
["Richard",444,444389,319960.08]
["Shari",356,356279,260083.66999999998]
["Richard",93,93299,75572.19]
["Gianna",429,429329,347756.49000000005]
["Michelle",290,290615,220867.4]
["Mitchell",462,462134,411299.26]
["Gianna",366,366789,260420.18999999997]
["Manavbir",335,335751,271958.31]
["Christina",390,390565,289018.09999999998]
["Nelia",175,175845,128366.84999999999]
["Nelia",86,86031,77427.900000000009]
["Denise",160,160730,138227.79999999999]
["Christina",194,194761,136332.69999999998]
["Janita",323,323009,281017.83]
["Janita",151,151339,113504.25]
["Nelia",370,370840,318922.40000000002]
["Jason",127,127629,107208.36]
["Craig",51,51165,36838.799999999996]
["Nelia",405,405476,324380.80000000005]
["Daniel",352,352989,303570.53999999998]
["Manavbir",266,266185,228919.1]
["Manavbir",433,433571,351192.51]
["Denise",421,421130,370594.4]
["Mansa",292,292887,263598.3]
["Mitchell",442,442410,331807.5]
["Ewelina",269,269782,229314.69999999998]
["Craig",50,50205,38155.800000000003]
["Elain",68,68924,51003.76]
["Christina",366,366318,296717.58]
["Ewelina",72,72688,61057.919999999998]
["Nelia",73,73683,56735.91]
["Gianna",282,282337,200459.27]
["Denise",188,188288,135567.35999999999]
["Craig",148,148014,113970.78]
["Sarah",116,116659,83994.48]
["Mitchell",456,456314,355924.92]
["Elain",287,287061,252613.68]
["Mi",336,336506,245649.38]
["Denise",68,68409,56095.380000000005]
["Ewelina",435,435738,348590.4]
["Ewelina",398,398043,306493.11]
["Richard",229,229601,195160.85]
["Gianna",485,485869,427564.72000000003]
["Elain",290,290124,235000.44]
["Nakyun",354,354874,280350.46000000002]
["Debra",390,390703,304748.34000000003]
["Sykes",105,105690,90893.4]
["Yla-Katrina",73,73727,51608.899999999994]
["Christina",484,484212,353474.76]
["Manavbir",371,371520,267494.39999999997]
["Nakyun",239,239486,184404.22]
["Christina",188,188427,146973.06]
["Michael",213,213928,166863.84]
["Janita",131,131184,91828.799999999988]
["Yla-Katrina",288,288680,202076]
["Carol",447,447536,393831.67999999999]
["Mansa",247,247781,220525.09]
["Mansa",342,342302,284110.65999999997]
["Shari",218,218551,157356.72]
["Kaur",428,428847,368808.42]
["Daniel",186,186453,149162.4]
["Sarah",431,431188,370821.68]
["Elain",478,478841,368707.57]
["Elain",386,386032,347428.8]
["Ewelina",318,318008,257586.48]
["Sarah",495,495290,401184.9]
["Michael",55,55369,44295.200000000004]
["Kaur",383,383866,284060.84000000003]
["Gianna",331,331334,245187.16]
["Manavbir",50,50113,39589.270000000004]
["Janita",427,427098,358762.32]
["Sarah",181,181609,163448.1]
["Sykes",365,365795,321899.59999999998]
["Manavbir",360,360316,255824.36]
["Shari",318,318460,257952.6]
["Sykes",196,196064,162733.12]
["Denise",133,133063,119756.7]
["Denise",411,411555,321012.90000000002]
["Gianna",145,145311,130779.90000000001]
["Jason",441,441634,344474.52]
["Mansa",99,99601,70716.709999999992]
["Sykes",285,285211,199647.69999999998]
["Michael",106,106255,79691.25]
["Carol",128,128883,95373.42]
["Gianna",225,225749,180599.2]
["Yla-Katrina",401,401549,337301.16]
["Nelia",83,83893,69631.19]
["Jason",325,325910,234655.19999999998]
["Mi",476,476269,390540.58]
["Kaur",95,95610,83180.7]
["Manavbir",110,110557,93973.45]
["Nakyun",393,393864,354477.60000000003]
["Janita",277,277856,236177.6]
["Sykes",78,78049,63219.69]
["Craig",321,321665,270198.59999999998]
["Michael",415,415687,336706.47000000003]
["Kaur",164,164820,115373.99999999999]
["Jason",321,321030,276085.8]
["Sarah",375,375270,326484.90000000002]
["Yla-Katrina",200,200553,176486.64]
["Nelia",261,261504,198743.04000000001]
["Michelle",191,191547,157068.54]
["Sykes",173,173959,132208.84]
["Mansa",67,67255,55821.649999999994]
["Sarah",74,74845,63618.25]
["Mitchell",269,269146,188402.19999999998]
["Craig",192,192517,171340.13]
["Mitchell",170,170035,124125.55]
["Mitchell",135,135252,106849.08]
["Gianna",198,198168,174387.84]
["Kaur",85,85880,60974.799999999996]
["Shari",164,164782,141712.51999999999]
["Kaur",418,418415,317995.40000000002]
["Carol",471,471624,363150.48]
["Mitchell",483,483417,381899.43]
["Kaur",295,295721,230662.38]
["Nelia",309,309111,259653.24]
["Mi",432,432692,302884.39999999997]
["Richard",136,136078,95254.599999999991]
["Manavbir",485,485339,359150.86]
["Shari",84,84188,74085.440000000002]
["Mi",120,120547,87999.31]
["Shari",304,304568,258882.8]
["Mi",489,489189,381567.42000000004]
["Mansa",69,69931,52448.25]
["Janita",51,51750,44505]
["Nakyun",125,125045,97535.1]
["Mansa",263,263916,219050.28]
["Daniel",421,421843,329037.54000000004]
["Gianna",335,335303,288360.58]
["Shari",384,384921,327182.84999999998]
["Sykes",148,148376,123152.07999999999]
["Michelle",316,316144,256076.64]
["Mi",346,346598,270346.44]
["Ewelina",156,156924,122400.72]
["Sykes",336,336966,266203.14]
["Debra",395,395502,316401.60000000003]
["Yla-Katrina",359,359303,294628.46000000002]
["Michael",313,313322,250657.6]
["Nelia",64,64800,56376]
["Manavbir",151,151062,122360.22]
["Nelia",183,183189,157542.54]
["Daniel",136,136322,98151.84]
["Mitchell",402,402154,285529.33999999997]
["Janita",121,121570,108197.3]
["Gianna",58,58325,42577.25]
["Richard",227,227914,159539.79999999999]
["Yla-Katrina",385,385576,335451.12]
["Richard",448,448912,323216.64000000001]
["Daniel",342,342165,246358.8]
["Denise",331,331877,265501.60000000003]
["Nakyun",221,221554,199398.6]
["Mitchell",149,149083,110321.42]
["Richard",382,382283,340231.87]
["Debra",159,159695,130949.90000000001]
["Shari",341,341748,290485.8]
["Debra",124,124647,104703.48]
["Janita",394,394326,311517.54000000004]
["Daniel",133,133865,100398.75]
["Michael",391,391323,352190.7]
["Gianna",253,253225,210176.75]
["Michelle",61,61046,53720.480000000003]
["Mansa",499,499122,449209.8]
["Mitchell",273,273483,216051.57]
["Craig",457,457929,393818.94]
["Sarah",252,252410,222120.8]
["Jason",175,175090,145324.69999999998]
["Sarah",246,246025,216502]
["Elain",131,131728,101430.56]
["Manavbir",223,223692,170005.92]
["Elain",106,106538,84165.02]
["Daniel",80,80687,62935.86]
["Daniel",444,444918,338137.68]
["Michelle",188,188492,135714.23999999999]
["Mitchell",231,231024,173268]
["Nakyun",496,496370,387168.60000000003]
["Jason",153,153632,113687.67999999999]
["Mi",300,300022,231016.94]
["Mi",196,196440,151258.80000000002]
["Craig",482,482007,428986.23]
["Ewelina",136,136076,118386.12]
["Shari",206,206505,152813.70000000001]
["Manavbir",125,125095,103828.84999999999]
["Mitchell",357,357952,257725.44]
["Jason",316,316821,247120.38]
["Elain",157,157169,122591.82]
["Sarah",469,469542,375633.60000000003]
["Carol",451,451670,383919.5]
["Mi",317,317979,273461.94]
["Craig",499,499637,404705.97000000003]
["Debra",469,469318,422386.2]
["Michelle",75,75977,66099.990000000005]
["Yla-Katrina",130,130329,114689.52]
["Nelia",465,465942,335478.24]
["Debra",320,320145,265720.34999999998]
["Michael",465,465852,354047.52]
["Yla-Katrina",384,384428,315230.96000000002]
["Nakyun",155,155925,135654.75]
["Richard",352,352320,292425.59999999998]
["Daniel",286,286149,208888.77]
["Daniel",366,366841,315483.26]
["Ewelina",152,152388,126482.04]
["Kaur",297,297601,208320.69999999998]
["Yla-Katrina",328,328919,230243.3]
["Yla-Katrina",422,422750,359337.5]
["Nelia",313,313389,247577.31]
["Mitchell",207,207773,186995.7]
["Richard",72,72976,60570.079999999994]
["Gianna",280,280154,238130.9]
["Daniel",295,295880,230786.4]
["Craig",251,251493,191134.68]
["Yla-Katrina",390,390811,320465.02]
["Michael",477,477321,386630.01]
["Debra",274,274899,200676.27]
["Mansa",168,168488,149954.32]
["Mansa",480,480871,432783.9]
["Christina",155,155128,139615.20000000001]
["Christina",212,212451,165711.78]
["Richard",382,382863,268004.09999999998]
["Richard",257,257971,221855.06]
["Ewelina",363,363703,301873.49]
["Mansa",422,422765,295935.5]
["Debra",493,493971,365538.54]
["Mi",360,360433,299159.39]
["Mi",151,151866,112380.84]
["Jason",462,462748,411845.72000000003]
["Mansa",243,243330,216563.7]
["Craig",352,352883,264662.25]
["Kaur",446,446425,388389.75]
["Craig",352,352677,264507.75]
["Jason",182,182197,138469.72]
["Shari",364,364718,313657.48]
["Carol",339,339811,292237.46000000002]
["Nakyun",442,442311,340579.47000000003]
["Manavbir",473,473824,426441.60000000003]
["Daniel",142,142774,114219.20000000001]
["Debra",357,357555,264590.7]
["Daniel",232,232634,181454.52000000002]
["Debra",268,268420,238893.80000000002]
["Michael",306,306793,254638.18999999997]
["Michael",395,395740,308677.2]
["Mansa",399,399522,319617.60000000003]
["Gianna",131,131150,100985.5]
["Nakyun",407,407270,297307.09999999998]
["Yla-Katrina",469,469526,403792.36]
["Carol",72,72497,56547.66]
["Debra",83,83845,62883.75]
["Shari",389,389328,295889.28000000003]
["Richard",218,218076,178822.32]
["Mi",337,337502,273376.62]
["Mansa",182,182911,140841.47]
["Elain",93,93698,82454.240000000005]

{"sheet":"P(1an)","index":1,"n_rows":1193,"n_cols":19,"rows_kept":1193,"cut":false,"hidden":true,"merged":[]}
["1) Create a table that extracts the 5 largest values from the Sales column. 2) Create a table that extracts the 5 smallest values from the COGS column. 3) Create a table that calculates the average Units, Sales and COGS for each Sales Rep."]
[null,null,null,null,null,null,null,null,null,"Average calculations"]
[null,null,null,null,null,5,null,5,null,{"$f":"A4","v":"Sales Rep"},{"$f":"B4","v":"Units"},{"$f":"C4","v":"Sales"},{"$f":"D4","v":"COGS"},null,null,"Row Labels","Average of Units","Average of Sales","Average of COGS"]
["Sales Rep","Units","Sales","COGS",null,{"$f":"F3&\" largest Sales\"","v":"5 largest Sales"},null,{"$f":"H3&\" smallest COGS\"","v":"5 smallest COGS"},null,"Carol",{"$f":"AVERAGEIF($A$5:$A$1193,$J4,B$5:B$1193)","v":265.12765957446811},{"$f":"AVERAGEIF($A$5:$A$1193,$J4,C$5:C$1193)","v":265632.72340425535},{"$f":"AVERAGEIF($A$5:$A$1193,$J4,D$5:D$1193)","v":215322.18617021284},null,null,"Carol",265.12765957446811,265632.72340425535,215322.18617021284]
["Richard",255,255648,191736,null,{"$f":"LARGE($C$5:$C$1193,ROWS(F$5:F5))","v":499782},null,{"$f":"SMALL($D$5:$D$1193,ROWS(H$5:H5))","v":36838.799999999996},null,"Christina",{"$f":"AVERAGEIF($A$5:$A$1193,$J5,B$5:B$1193)","v":302.31818181818181},{"$f":"AVERAGEIF($A$5:$A$1193,$J5,C$5:C$1193)","v":302797.34090909088},{"$f":"AVERAGEIF($A$5:$A$1193,$J5,D$5:D$1193)","v":239360.1715909091},null,null,"Christina",302.31818181818181,302797.34090909088,239360.1715909091]
["Manavbir",470,470564,385862.48000000004,null,{"$f":"LARGE($C$5:$C$1193,ROWS(F$5:F6))","v":499729},null,{"$f":"SMALL($D$5:$D$1193,ROWS(H$5:H6))","v":38155.800000000003},null,"Craig",{"$f":"AVERAGEIF($A$5:$A$1193,$J6,B$5:B$1193)","v":284.48},{"$f":"AVERAGEIF($A$5:$A$1193,$J6,C$5:C$1193)","v":285004.74},{"$f":"AVERAGEIF($A$5:$A$1193,$J6,D$5:D$1193)","v":231129.25120000006},null,null,"Craig",284.48,285004.74,231129.25120000006]
["Janita",195,195823,148825.48000000001,null,{"$f":"LARGE($C$5:$C$1193,ROWS(F$5:F7))","v":499637},null,{"$f":"SMALL($D$5:$D$1193,ROWS(H$5:H7))","v":38244.15},null,"Daniel",{"$f":"AVERAGEIF($A$5:$A$1193,$J7,B$5:B$1193)","v":278.60000000000002},{"$f":"AVERAGEIF($A$5:$A$1193,$J7,C$5:C$1193)","v":279123.93333333335},{"$f":"AVERAGEIF($A$5:$A$1193,$J7,D$5:D$1193)","v":221473.60799999998},null,null,"Daniel",278.60000000000002,279123.93333333335,221473.60799999998]
["Mitchell",388,388300,349470,null,{"$f":"LARGE($C$5:$C$1193,ROWS(F$5:F8))","v":499245},null,{"$f":"SMALL($D$5:$D$1193,ROWS(H$5:H8))","v":39392.93},null,"Debra",{"$f":"AVERAGEIF($A$5:$A$1193,$J8,B$5:B$1193)","v":287.26530612244898},{"$f":"AVERAGEIF($A$5:$A$1193,$J8,C$5:C$1193)","v":287701.04081632651},{"$f":"AVERAGEIF($A$5:$A$1193,$J8,D$5:D$1193)","v":228565.80204081626},null,null,"Debra",287.26530612244898,287701.04081632651,228565.80204081626]
["Christina",223,223659,185636.97,null,{"$f":"LARGE($C$5:$C$1193,ROWS(F$5:F9))","v":499122},null,{"$f":"SMALL($D$5:$D$1193,ROWS(H$5:H9))","v":39589.270000000004},null,"Denise",{"$f":"AVERAGEIF($A$5:$A$1193,$J9,B$5:B$1193)","v":255.75},{"$f":"AVERAGEIF($A$5:$A$1193,$J9,C$5:C$1193)","v":256240.625},{"$f":"AVERAGEIF($A$5:$A$1193,$J9,D$5:D$1193)","v":206428.99325},null,null,"Denise",255.75,256240.625,206428.99325]
["Nakyun",291,291969,239414.58000000002,null,null,null,null,null,"Elain",{"$f":"AVERAGEIF($A$5:$A$1193,$J10,B$5:B$1193)","v":251.20588235294119},{"$f":"AVERAGEIF($A$5:$A$1193,$J10,C$5:C$1193)","v":251682.4705882353},{"$f":"AVERAGEIF($A$5:$A$1193,$J10,D$5:D$1193)","v":196649.45088235292},null,null,"Elain",251.20588235294119,251682.4705882353,196649.45088235292]
["Mitchell",239,239386,172357.91999999998,null,null,null,null,null,"Ewelina",{"$f":"AVERAGEIF($A$5:$A$1193,$J11,B$5:B$1193)","v":290.28571428571428},{"$f":"AVERAGEIF($A$5:$A$1193,$J11,C$5:C$1193)","v":290751.21428571426},{"$f":"AVERAGEIF($A$5:$A$1193,$J11,D$5:D$1193)","v":234879.02380952376},null,null,"Ewelina",290.28571428571428,290751.21428571426,234879.02380952376]
["Daniel",398,398538,294918.12,null,null,null,null,null,"Gianna",{"$f":"AVERAGEIF($A$5:$A$1193,$J12,B$5:B$1193)","v":292.77272727272725},{"$f":"AVERAGEIF($A$5:$A$1193,$J12,C$5:C$1193)","v":293199.38636363635},{"$f":"AVERAGEIF($A$5:$A$1193,$J12,D$5:D$1193)","v":234975.57613636364},null,null,"Gianna",292.77272727272725,293199.38636363635,234975.57613636364]
["Mi",132,132446,108605.72,null,null,null,null,null,"Janita",{"$f":"AVERAGEIF($A$5:$A$1193,$J13,B$5:B$1193)","v":264.32432432432432},{"$f":"AVERAGEIF($A$5:$A$1193,$J13,C$5:C$1193)","v":264790.48648648651},{"$f":"AVERAGEIF($A$5:$A$1193,$J13,D$5:D$1193)","v":211860.54432432432},null,null,"Janita",264.32432432432432,264790.48648648651,211860.54432432432]
["Richard",221,221452,190448.72,null,null,null,null,null,"Jason",{"$f":"AVERAGEIF($A$5:$A$1193,$J14,B$5:B$1193)","v":270.43181818181819},{"$f":"AVERAGEIF($A$5:$A$1193,$J14,C$5:C$1193)","v":270937.75},{"$f":"AVERAGEIF($A$5:$A$1193,$J14,D$5:D$1193)","v":217027.18090909094},null,null,"Jason",270.43181818181819,270937.75,217027.18090909094]
["Kaur",344,344551,299759.37,null,null,null,null,null,"Kaur",{"$f":"AVERAGEIF($A$5:$A$1193,$J15,B$5:B$1193)","v":292.8235294117647},{"$f":"AVERAGEIF($A$5:$A$1193,$J15,C$5:C$1193)","v":293339.72549019608},{"$f":"AVERAGEIF($A$5:$A$1193,$J15,D$5:D$1193)","v":233210.06803921564},null,null,"Kaur",292.8235294117647,293339.72549019608,233210.06803921564]
["Ewelina",466,466662,331330.01999999996,null,null,null,null,null,"Manavbir",{"$f":"AVERAGEIF($A$5:$A$1193,$J16,B$5:B$1193)","v":257.02127659574467},{"$f":"AVERAGEIF($A$5:$A$1193,$J16,C$5:C$1193)","v":257520.3404255319},{"$f":"AVERAGEIF($A$5:$A$1193,$J16,D$5:D$1193)","v":203753.0789361702},null,null,"Manavbir",257.02127659574467,257520.3404255319,203753.0789361702]
["Ewelina",281,281412,236386.08,null,null,null,null,null,"Mansa",{"$f":"AVERAGEIF($A$5:$A$1193,$J17,B$5:B$1193)","v":256.04444444444442},{"$f":"AVERAGEIF($A$5:$A$1193,$J17,C$5:C$1193)","v":256590.42222222223},{"$f":"AVERAGEIF($A$5:$A$1193,$J17,D$5:D$1193)","v":207107.24244444448},null,null,"Mansa",256.04444444444442,256590.42222222223,207107.24244444448]
["Mitchell",167,167214,142131.9,null,null,null,null,null,"Mi",{"$f":"AVERAGEIF($A$5:$A$1193,$J18,B$5:B$1193)","v":279.28571428571428},{"$f":"AVERAGEIF($A$5:$A$1193,$J18,C$5:C$1193)","v":279715.14285714284},{"$f":"AVERAGEIF($A$5:$A$1193,$J18,D$5:D$1193)","v":223119.92982142858},null,null,"Mi",279.28571428571428,279715.14285714284,223119.92982142858]
["Nelia",394,394341,295755.75,null,null,null,null,null,"Michael",{"$f":"AVERAGEIF($A$5:$A$1193,$J19,B$5:B$1193)","v":291.76086956521738},{"$f":"AVERAGEIF($A$5:$A$1193,$J19,C$5:C$1193)","v":292285.08695652173},{"$f":"AVERAGEIF($A$5:$A$1193,$J19,D$5:D$1193)","v":231380.60130434774},null,null,"Michael",291.76086956521738,292285.08695652173,231380.60130434774]
["Craig",497,497678,432979.86,null,null,null,null,null,"Michelle",{"$f":"AVERAGEIF($A$5:$A$1193,$J20,B$5:B$1193)","v":285.30434782608694},{"$f":"AVERAGEIF($A$5:$A$1193,$J20,C$5:C$1193)","v":285800.28260869568},{"$f":"AVERAGEIF($A$5:$A$1193,$J20,D$5:D$1193)","v":227866.81543478265},null,null,"Michelle",285.30434782608694,285800.28260869568,227866.81543478265]
["Carol",383,383583,268508.09999999998,null,null,null,null,null,"Mitchell",{"$f":"AVERAGEIF($A$5:$A$1193,$J21,B$5:B$1193)","v":264.18181818181819},{"$f":"AVERAGEIF($A$5:$A$1193,$J21,C$5:C$1193)","v":264602.58181818185},{"$f":"AVERAGEIF($A$5:$A$1193,$J21,D$5:D$1193)","v":211291.03145454547},null,null,"Mitchell",264.18181818181819,264602.58181818185,211291.03145454547]
["Nelia",365,365081,277461.56,null,null,null,null,null,"Nakyun",{"$f":"AVERAGEIF($A$5:$A$1193,$J22,B$5:B$1193)","v":285.65384615384613},{"$f":"AVERAGEIF($A$5:$A$1193,$J22,C$5:C$1193)","v":286098.57692307694},{"$f":"AVERAGEIF($A$5:$A$1193,$J22,D$5:D$1193)","v":227180.13653846152},null,null,"Nakyun",285.65384615384613,286098.57692307694,227180.13653846152]
["Denise",225,225682,182802.42,null,null,null,null,null,"Nelia",{"$f":"AVERAGEIF($A$5:$A$1193,$J23,B$5:B$1193)","v":291.44230769230768},{"$f":"AVERAGEIF($A$5:$A$1193,$J23,C$5:C$1193)","v":291873.48076923075},{"$f":"AVERAGEIF($A$5:$A$1193,$J23,D$5:D$1193)","v":233354.12384615379},null,null,"Nelia",291.44230769230768,291873.48076923075,233354.12384615379]
["Richard",360,360377,291905.37,null,null,null,null,null,"Richard",{"$f":"AVERAGEIF($A$5:$A$1193,$J24,B$5:B$1193)","v":242.76470588235293},{"$f":"AVERAGEIF($A$5:$A$1193,$J24,C$5:C$1193)","v":243289.13725490196},{"$f":"AVERAGEIF($A$5:$A$1193,$J24,D$5:D$1193)","v":192178.32823529409},null,null,"Richard",242.76470588235293,243289.13725490196,192178.32823529409]
["Nelia",458,458756,399117.72,null,null,null,null,null,"Sarah",{"$f":"AVERAGEIF($A$5:$A$1193,$J25,B$5:B$1193)","v":278.13333333333333},{"$f":"AVERAGEIF($A$5:$A$1193,$J25,C$5:C$1193)","v":278654.76666666666},{"$f":"AVERAGEIF($A$5:$A$1193,$J25,D$5:D$1193)","v":227801.99100000007},null,null,"Sarah",278.13333333333333,278654.76666666666,227801.99100000007]
["Nelia",432,432320,319916.79999999999,null,null,null,null,null,"Shari",{"$f":"AVERAGEIF($A$5:$A$1193,$J26,B$5:B$1193)","v":290.95744680851061},{"$f":"AVERAGEIF($A$5:$A$1193,$J26,C$5:C$1193)","v":291471.42553191487},{"$f":"AVERAGEIF($A$5:$A$1193,$J26,D$5:D$1193)","v":229299.37382978725},null,null,"Shari",290.95744680851061,291471.42553191487,229299.37382978725]
["Richard",314,314469,283022.10000000003,null,null,null,null,null,"Sykes",{"$f":"AVERAGEIF($A$5:$A$1193,$J27,B$5:B$1193)","v":244.62222222222223},{"$f":"AVERAGEIF($A$5:$A$1193,$J27,C$5:C$1193)","v":245147.77777777778},{"$f":"AVERAGEIF($A$5:$A$1193,$J27,D$5:D$1193)","v":192492.22733333334},null,null,"Sykes",244.62222222222223,245147.77777777778,192492.22733333334]
["Sarah",180,180252,151411.68,null,null,null,null,null,"Yla-Katrina",{"$f":"AVERAGEIF($A$5:$A$1193,$J28,B$5:B$1193)","v":308.31666666666666},{"$f":"AVERAGEIF($A$5:$A$1193,$J28,C$5:C$1193)","v":308826.93333333335},{"$f":"AVERAGEIF($A$5:$A$1193,$J28,D$5:D$1193)","v":247920.74316666662},null,null,"Yla-Katrina",308.31666666666666,308826.93333333335,247920.74316666662]
["Nakyun",160,160859,144773.1,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",277.23717409587891,277725.07821698906,221759.55443229617]
["Janita",193,193122,171878.58000000002]
["Kaur",155,155741,124592.8]
["Shari",96,96704,76396.160000000003]
["Shari",390,390366,324003.77999999997]
["Yla-Katrina",185,185196,162972.48000000001]
["Denise",498,498495,378856.2]
["Richard",209,209973,149080.82999999999]
["Carol",250,250643,223072.27]
["Michelle",418,418673,297257.82999999996]
["Nakyun",193,193274,154619.20000000001]
["Ewelina",255,255856,184216.32000000001]
["Janita",315,315776,258936.32000000001]
["Nelia",241,241548,178745.52]
["Mi",125,125433,100346.40000000001]
["Nakyun",372,372365,301615.65000000002]
["Manavbir",309,309851,232388.25]
["Janita",266,266403,197138.22]
["Manavbir",448,448224,345132.48]
["Shari",109,109997,96797.36]
["Manavbir",53,53865,38244.15]
["Mi",105,105027,79820.52]
["Craig",211,211577,158682.75]
["Nelia",286,286226,228980.80000000002]
["Shari",481,481771,351692.83]
["Michael",266,266460,210503.40000000002]
["Elain",328,328934,263147.2]
["Nelia",194,194843,155874.4]
["Gianna",366,366227,267345.71000000002]
["Denise",108,108046,86436.800000000003]
["Denise",251,251015,208342.44999999998]
["Jason",315,315040,255182.40000000002]
["Craig",458,458925,357961.5]
["Richard",80,80911,64728.800000000003]
["Craig",109,109871,94489.06]
["Debra",182,182009,152887.56]
["Ewelina",476,476420,352550.8]
["Manavbir",53,53912,46903.44]
["Richard",307,307166,239589.48]
["Sarah",77,77586,66723.959999999992]
["Gianna",334,334613,247613.62]
["Nelia",176,176270,142778.70000000001]
["Sarah",361,361529,300069.07]
["Manavbir",364,364777,284526.06]
["Kaur",464,464402,366877.58]
["Elain",118,118912,95129.600000000006]
["Gianna",412,412097,313193.72000000003]
["Debra",245,245822,186824.72]
["Jason",112,112747,84560.25]
["Shari",262,262648,217997.84]
["Nelia",404,404358,363922.2]
["Sarah",364,364952,310209.2]
["Jason",146,146567,115787.93000000001]
["Mitchell",232,232300,199778]
["Gianna",397,397755,322181.55000000005]
["Jason",329,329310,240396.3]
["Michael",186,186162,141483.12]
["Sarah",479,479524,426776.36]
["Richard",261,261803,188498.16]
["Sarah",197,197409,159901.29]
["Gianna",224,224385,166044.9]
["Mi",449,449644,368708.08]
["Sarah",308,308693,262389.05]
["Michael",68,68480,54099.200000000004]
["Yla-Katrina",151,151640,119795.6]
["Christina",189,189921,148138.38]
["Craig",348,348411,271760.58]
["Mitchell",321,321917,244656.92]
["Mi",333,333409,290065.83]
["Craig",451,451663,334230.62]
["Mitchell",325,325432,279871.52]
["Mi",345,345917,266356.09000000003]
["Nakyun",311,311405,239781.85]
["Nelia",136,136662,117529.31999999999]
["Sarah",320,320822,282323.36]
["Manavbir",458,458772,330315.83999999997]
["Mi",499,499040,384260.8]
["Elain",192,192618,142537.32]
["Mi",469,469848,366481.44]
["Carol",230,230473,161331.09999999998]
["Nakyun",108,108680,76076]
["Michael",64,64450,50271]
["Kaur",77,77782,63781.240000000005]
["Mitchell",98,98640,79898.400000000009]
["Sykes",430,430742,318749.08]
["Carol",384,384922,311786.82]
["Mansa",110,110594,80733.62]
["Richard",300,300987,225740.25]
["Sykes",479,479494,388390.14]
["Christina",195,195218,163983.12]
["Jason",124,124127,89371.44]
["Sarah",423,423292,330167.76]
["Mitchell",487,487970,370857.2]
["Mitchell",159,159752,121411.52]
["Debra",187,187293,146088.54]
["Manavbir",123,123949,110314.61]
["Nakyun",370,370610,311312.39999999997]
["Michelle",287,287075,252626]
["Denise",312,312079,271508.73]
["Mitchell",116,116810,105129]
["Nelia",380,380051,334444.88]
["Mitchell",155,155187,121045.86]
["Michelle",199,199685,145770.04999999999]
["Carol",117,117887,106098.3]
["Christina",343,343726,302478.88]
["Nakyun",391,391203,309050.37]
["Carol",386,386138,305049.02]
["Nelia",269,269412,242470.80000000002]
["Michelle",400,400025,340021.25]
["Mansa",134,134024,120621.6]
["Nelia",368,368591,298558.71000000002]
["Yla-Katrina",310,310932,251854.92]
["Mi",407,407700,346545]
["Jason",418,418121,330315.59000000003]
["Richard",390,390658,292993.5]
["Daniel",360,360778,274191.28000000003]
["Janita",334,334608,267686.40000000002]
["Ewelina",130,130197,108063.51]
["Denise",97,97429,86711.81]
["Janita",349,349386,279508.8]
["Christina",180,180077,149463.91]
["Sykes",256,256472,192354]
["Gianna",223,223812,161144.63999999998]
["Ewelina",112,112375,97766.25]
["Michelle",436,436654,379888.98]
["Kaur",288,288949,245606.65]
["Gianna",277,277126,193988.19999999998]
["Michael",457,457431,361370.49]
["Jason",422,422806,295964.19999999995]
["Craig",268,268910,204371.6]
["Richard",125,125545,100436]
["Denise",247,247754,203158.28000000003]
["Michael",190,190321,156063.22]
["Kaur",432,432206,324154.5]
["Michael",363,363781,265560.13]
["Jason",318,318417,241996.92]
["Yla-Katrina",420,420671,378603.9]
["Nakyun",465,465031,334822.32]
["Mitchell",84,84744,76269.600000000006]
["Sykes",261,261747,183222.9]
["Mi",181,181856,152759.04000000001]
["Michelle",56,56438,42328.5]
["Kaur",136,136789,98488.08]
["Mitchell",392,392462,302195.74]
["Shari",120,120267,93808.260000000009]
["Mansa",398,398475,314795.25]
["Carol",57,57979,42904.46]
["Ewelina",317,317917,247975.26]
["Carol",404,404822,336002.26]
["Denise",222,222636,182561.52000000002]
["Daniel",230,230878,173158.5]
["Yla-Katrina",312,312560,231294.4]
["Carol",245,245278,210939.08]
["Mi",356,356267,302826.95]
["Sarah",402,402983,306267.08]
["Ewelina",218,218463,192247.44]
["Denise",128,128214,114110.46]
["Debra",60,60092,51078.2]
["Janita",129,129953,111759.58]
["Nakyun",88,88690,78047.199999999997]
["Craig",329,329605,286756.34999999998]
["Kaur",403,403284,306495.84000000003]
["Jason",250,250794,223206.66]
["Michelle",438,438743,377318.98]
["Yla-Katrina",310,310385,266931.09999999998]
["Craig",498,498670,378989.2]
["Yla-Katrina",408,408237,306177.75]
["Kaur",284,284189,213141.75]
["Carol",75,75653,55226.689999999995]
["Daniel",140,140278,99597.37999999999]
["Elain",322,322466,248298.82]
["Richard",128,128228,92324.160000000003]
["Mi",280,280569,244095.03]
["Yla-Katrina",388,388044,341478.72000000003]
["Mi",85,85550,72717.5]
["Daniel",317,317007,256775.67]
["Debra",237,237535,187652.65]
["Michael",207,207162,161586.36000000002]
["Michelle",472,472929,387801.78]
["Sarah",133,133585,108203.85]
["Denise",94,94344,84909.6]
["Gianna",205,205386,158147.22]
["Sarah",325,325770,231296.69999999998]
["Mi",112,112341,98860.08]
["Janita",402,402189,349904.43]
["Sarah",470,470312,399765.2]
["Nelia",486,486098,413183.3]
["Michael",438,438290,311185.89999999997]
["Janita",481,481322,380244.38]
["Elain",492,492894,349954.74]
["Mi",92,92158,66353.759999999995]
["Mitchell",213,213918,192526.2]
["Nakyun",73,73243,53467.39]
["Denise",293,293776,246771.84]
["Christina",426,426290,311191.7]
["Kaur",89,89081,79282.09]
["Craig",72,72339,58594.590000000004]
["Mi",456,456272,365017.60000000003]
["Elain",168,168242,129546.34]
["Kaur",196,196125,139248.75]
["Yla-Katrina",191,191591,157104.62000000002]
["Daniel",55,55373,42637.21]
["Debra",321,321208,224845.59999999998]
["Jason",261,261610,227600.7]
["Craig",63,63613,56615.57]
["Daniel",278,278707,225752.67]
["Sykes",154,154346,112672.58]
["Craig",178,178165,149658.6]
["Mitchell",472,472232,415564.16]
["Mitchell",463,463271,333555.12]
["Yla-Katrina",473,473243,411721.41]
["Debra",427,427874,359414.16]
["Ewelina",309,309860,247888]
["Carol",226,226574,181259.2]
["Kaur",488,488039,375790.03]
["Jason",55,55235,49159.15]
["Shari",64,64324,55318.64]
["Michael",141,141360,122983.2]
["Richard",115,115652,104086.8]
["Denise",382,382432,328891.52000000002]
["Kaur",482,482575,419840.25]
["Daniel",380,380889,335182.32]
["Denise",422,422959,321448.84000000003]
["Shari",499,499245,394403.55000000005]
["Michael",401,401538,309184.26]
["Jason",122,122237,88010.64]
["Nakyun",265,265939,199454.25]
["Nakyun",354,354629,304980.94]
["Nakyun",95,95858,84355.04]
["Jason",276,276104,248493.6]
["Mi",323,323862,268805.45999999996]
["Debra",149,149185,111888.75]
["Mi",441,441376,397238.4]
["Sykes",435,435218,330765.68]
["Mitchell",387,387090,348381]
["Craig",98,98767,88890.3]
["Janita",366,366769,260405.99]
["Jason",499,499782,439808.16]
["Yla-Katrina",416,416145,366207.6]
["Gianna",395,395059,319997.79000000004]
["Michelle",188,188194,148673.26]
["Denise",155,155883,110676.93]
["Denise",83,83368,71696.479999999996]
["Yla-Katrina",93,93432,71008.320000000007]
["Craig",176,176120,149702]
["Debra",223,223547,160953.84]
["Debra",464,464635,353122.6]
["Mi",355,355258,266443.5]
["Gianna",389,389795,350815.5]
["Debra",80,80225,60971]
["Yla-Katrina",107,107396,90212.64]
["Christina",358,358565,315537.2]
["Richard",381,381796,332162.52]
["Nelia",313,313408,228787.84]
["Manavbir",369,369106,276829.5]
["Michelle",203,203106,182795.4]
["Denise",481,481181,365697.56]
["Craig",132,132494,94070.739999999991]
["Nelia",88,88376,75119.599999999991]
["Sykes",114,114937,96547.08]
["Christina",399,399336,319468.80000000005]
["Mansa",430,430466,374505.42]
["Mi",254,254391,190793.25]
["Michelle",238,238732,200534.88]
["Carol",433,433515,381493.2]
["Richard",486,486429,364821.75]
["Carol",72,72111,60573.24]
["Mi",439,439223,377731.77999999997]
["Mansa",58,58701,42264.72]
["Janita",475,475598,428038.2]
["Nelia",262,262130,214946.6]
["Sarah",143,143201,100240.7]
["Richard",152,152216,121772.8]
["Nelia",328,328869,243363.06]
["Denise",75,75544,56658]
["Gianna",398,398367,334628.27999999997]
["Elain",460,460701,391595.85]
["Christina",498,498486,373864.5]
["Elain",138,138313,112033.53000000001]
["Craig",320,320825,227785.75]
["Debra",494,494680,371010]
["Yla-Katrina",180,180220,151384.79999999999]
["Mi",428,428196,299737.19999999995]
["Gianna",375,375440,262808]
["Michael",293,293350,246414]
["Sarah",496,496540,347578]
["Kaur",499,499003,369262.22]
["Manavbir",466,466669,410668.72000000003]
["Yla-Katrina",204,204108,153081]
["Mitchell",68,68100,48351]
["Richard",184,184100,139916]
["Nakyun",278,278313,208734.75]
["Carol",199,199351,159480.80000000002]
["Mansa",274,274701,192290.69999999998]
["Craig",360,360038,309632.68]
["Manavbir",327,327764,281877.03999999998]
["Manavbir",69,69473,55578.400000000001]
["Elain",115,115353,103817.7]
["Elain",191,191038,133726.6]
["Carol",140,140634,108288.18000000001]
["Richard",148,148368,115727.04000000001]
["Janita",55,55483,39392.93]
["Jason",149,149228,104459.59999999999]
["Janita",272,272553,218042.40000000002]
["Elain",299,299475,269527.5]
["Christina",199,199161,179244.9]
["Sarah",300,300051,267045.39]
["Kaur",472,472940,354705]
["Craig",402,402529,313972.62]
["Michael",129,129133,90393.099999999991]
["Debra",324,324323,272431.32]
["Christina",369,369677,303135.14]
["Sykes",234,234505,201674.3]
["Carol",321,321732,250950.96000000002]
["Nakyun",199,199454,147595.96]
["Jason",412,412942,351000.7]
["Elain",176,176503,141202.4]
["Yla-Katrina",370,370307,274027.18]
["Sarah",397,397764,338099.39999999997]
["Denise",75,75233,56424.75]
["Sykes",88,88214,79392.600000000006]
["Michelle",179,179706,149155.97999999998]
["Elain",113,113729,93257.780000000013]
["Janita",211,211445,171270.45]
["Jason",226,226321,185583.22]
["Sykes",310,310036,248028.80000000002]
["Denise",330,330971,244918.54]
["Nakyun",133,133110,105156.90000000001]
["Sarah",109,109303,79791.19]
["Mansa",69,69035,50395.549999999996]
["Nakyun",267,267043,229656.98]
["Sykes",169,169728,127296]
["Mansa",73,73554,61785.36]
["Christina",312,312461,221847.31]
["Mitchell",169,169900,139318]
["Nakyun",163,163685,114579.5]
["Sarah",492,492037,423151.82]
["Craig",122,122594,95623.32]
["Kaur",356,356678,321010.2]
["Mi",85,85180,66440.400000000009]
["Mansa",337,337474,303726.60000000003]
["Richard",122,122403,93026.28]
["Sarah",257,257631,206104.80000000002]
["Sykes",151,151950,106365]
["Sykes",186,186384,139788]
["Sarah",219,219944,193550.72]
["Mitchell",245,245166,205939.44]
["Mansa",264,264466,222151.44]
["Nelia",111,111595,85928.150000000009]
["Mitchell",317,317258,250633.82]
["Yla-Katrina",367,367869,264865.68]
["Daniel",324,324247,252912.66]
["Sarah",460,460548,386860.32]
["Manavbir",147,147007,119075.67000000001]
["Debra",202,202273,151704.75]
["Carol",173,173403,128318.22]
["Craig",253,253463,220512.81]
["Ewelina",420,420803,345058.46]
["Craig",209,209557,188601.30000000002]
["Yla-Katrina",193,193361,164356.85]
["Mi",101,101324,84098.92]
["Carol",323,323023,251957.94]
["Mi",391,391285,305202.3]
["Gianna",250,250693,183005.88999999998]
["Daniel",76,76398,64938.299999999996]
["Jason",146,146586,120200.52]
["Carol",462,462871,411955.19]
["Debra",270,270556,197505.88]
["Nakyun",306,306068,238733.04]
["Mitchell",464,464420,357603.4]
["Gianna",399,399409,303550.84000000003]
["Sarah",485,485499,398109.18000000005]
["Gianna",74,74879,60651.990000000005]
["Daniel",375,375833,308183.06]
["Elain",385,385688,308550.40000000002]
["Mansa",335,335792,268633.60000000003]
["Michelle",465,465077,390664.68]
["Nelia",344,344579,286000.57]
["Manavbir",374,374755,266076.05]
["Denise",286,286360,240542.4]
["Christina",223,223585,160981.19999999998]
["Yla-Katrina",301,301580,250311.4]
["Yla-Katrina",492,492415,418552.75]
["Michelle",397,397502,282226.42]
["Sarah",245,245505,184128.75]
["Michelle",71,71064,51876.72]
["Richard",236,236878,198977.52]
["Elain",70,70330,51340.9]
["Sykes",192,192835,138841.19999999998]
["Kaur",254,254502,198511.56]
["Christina",484,484884,402453.72]
["Mitchell",466,466294,415001.66000000003]
["Mitchell",219,219059,173056.61000000002]
["Richard",98,98707,87849.23]
["Carol",337,337735,300584.15000000002]
["Kaur",477,477270,367497.9]
["Richard",233,233295,179637.15]
["Daniel",445,445113,329383.62]
["Shari",179,179934,125953.79999999999]
["Craig",343,343776,281896.32000000001]
["Craig",478,478452,377977.08]
["Debra",421,421790,358521.5]
["Sarah",486,486953,423649.11]
["Michael",455,455780,341835]
["Kaur",386,386027,297240.78999999998]
["Mi",172,172347,120642.9]
["Mi",101,101110,87965.7]
["Carol",222,222767,196034.96]
["Yla-Katrina",421,421536,316152]
["Ewelina",434,434296,364808.64]
["Carol",391,391522,328878.48]
["Sykes",113,113979,95742.36]
["Janita",150,150337,127786.45]
["Mansa",226,226899,192864.15]
["Mansa",263,263940,195315.6]
["Janita",164,164196,129714.84000000001]
["Carol",320,320434,237121.16]
["Michelle",416,416746,370903.94]
["Kaur",291,291111,206688.81]
["Nakyun",103,103033,82426.400000000009]
["Carol",127,127025,90187.75]
["Carol",457,457886,366308.80000000005]
["Janita",289,289849,214488.26]
["Mansa",69,69341,50618.93]
["Craig",79,79160,59370]
["Yla-Katrina",323,323064,277835.03999999998]
["Shari",486,486114,403474.62]
["Kaur",413,413955,293908.05]
["Michael",488,488993,391194.4]
["Daniel",388,388396,299064.92]
["Elain",388,388351,279612.71999999997]
["Sarah",398,398574,354730.86]
["Michelle",299,299461,218606.53]
["Janita",86,86527,61434.17]
["Mansa",101,101426,73026.720000000001]
["Debra",355,355032,298226.88]
["Denise",294,294582,259232.16]
["Daniel",55,55376,46515.839999999997]
["Gianna",455,455869,378371.26999999996]
["Michael",265,265882,236634.98]
["Debra",82,82977,63062.520000000004]
["Richard",279,279842,204284.66]
["Mi",116,116643,102645.84]
["Daniel",396,396871,333371.64]
["Craig",407,407473,354501.51]
["Sarah",162,162235,136277.4]
["Mansa",310,310582,254677.24000000002]
["Yla-Katrina",380,380337,323286.45]
["Sykes",493,493858,370393.5]
["Manavbir",109,109786,86730.94]
["Debra",133,133121,109159.22]
["Manavbir",134,134635,109054.35]
["Jason",182,182511,140533.47]
["Janita",478,478118,344244.95999999996]
["Nelia",324,324218,233436.96]
["Daniel",372,372451,335205.90000000002]
["Sykes",302,302477,220808.21]
["Michelle",64,64225,45599.75]
["Nelia",97,97326,74941.02]
["Carol",332,332501,249375.75]
["Sarah",423,423639,330438.42]
["Mitchell",140,140589,111065.31000000001]
["Michael",267,267765,190113.15]
["Yla-Katrina",206,206715,171573.44999999998]
["Sykes",208,208881,152483.13]
["Richard",459,459006,353434.62]
["Craig",454,454649,354626.22000000003]
["Carol",311,311505,264779.25]
["Ewelina",389,389539,327212.76]
["Yla-Katrina",195,195061,142394.53]
["Daniel",311,311522,236756.72]
["Carol",92,92597,67595.81]
["Nelia",424,424928,297449.59999999998]
["Mansa",118,118806,85540.319999999992]
["Mitchell",67,67093,50319.75]
["Shari",150,150040,124533.2]
["Shari",170,170075,119052.49999999999]
["Janita",362,362538,271903.5]
["Daniel",372,372448,268162.56]
["Gianna",277,277042,229944.86]
["Michael",494,494934,400896.54000000004]
["Michael",474,474028,350780.72]
["Christina",454,454327,340745.25]
["Craig",385,385389,304457.31]
["Christina",280,280452,215948.04]
["Yla-Katrina",350,350314,294263.76]
["Michelle",266,266946,194870.58]
["Janita",336,336585,279365.55]
["Nakyun",200,200054,144038.88]
["Yla-Katrina",94,94761,74861.19]
["Shari",148,148604,117397.16]
["Sykes",131,131870,108133.40000000001]
["Richard",65,65409,53635.380000000005]
["Denise",144,144648,105593.04]
["Craig",442,442988,336670.88]
["Christina",250,250036,210030.24]
["Jason",151,151860,136674]
["Nelia",131,131570,111834.5]
["Michelle",185,185807,167226.30000000002]
["Nelia",447,447300,393624]
["Christina",181,181227,157667.49]
["Denise",356,356851,299754.83999999997]
["Sarah",371,371945,271519.84999999998]
["Manavbir",497,497252,377911.52]
["Janita",192,192585,142512.9]
["Nakyun",225,225351,196055.37]
["Kaur",114,114301,100584.88]
["Christina",462,462089,369671.2]
["Mitchell",352,352961,310605.68]
["Yla-Katrina",424,424374,318280.5]
["Elain",424,424463,314102.62]
["Mansa",316,316569,227929.68]
["Daniel",305,305780,223219.4]
["Shari",267,267430,224641.19999999998]
["Yla-Katrina",367,367959,283328.43]
["Kaur",484,484127,377619.06]
["Jason",63,63605,47703.75]
["Sarah",60,60432,47741.279999999999]
["Daniel",251,251227,221079.76]
["Shari",165,165055,141947.29999999999]
["Debra",293,293196,263876.40000000002]
["Yla-Katrina",376,376454,263517.8]
["Craig",144,144125,105211.25]
["Nakyun",305,305984,266206.08000000002]
["Nelia",219,219121,186252.85]
["Jason",405,405935,300391.90000000002]
["Debra",77,77117,60922.43]
["Nelia",335,335029,264672.91000000003]
["Daniel",261,261401,198664.76]
["Gianna",118,118590,105545.1]
["Mi",313,313600,238336]
["Michael",270,270662,205703.12]
["Sykes",304,304100,246321.00000000003]
["Mitchell",164,164565,131652]
["Kaur",247,247958,173570.59999999998]
["Jason",174,174767,152047.29]
["Christina",399,399968,335973.12]
["Kaur",110,110407,79493.039999999994]
["Carol",232,232513,192985.78999999998]
["Elain",270,270235,191866.84999999998]
["Mi",389,389501,334970.86]
["Christina",128,128752,90126.399999999994]
["Mitchell",201,201329,142943.59]
["Michelle",359,359069,276483.13]
["Kaur",220,220471,171967.38]
["Yla-Katrina",187,187138,144096.26]
["Daniel",346,346259,287394.96999999997]
["Kaur",57,57311,45275.69]
["Richard",457,457641,338654.33999999997]
["Debra",274,274055,224725.1]
["Carol",311,311154,264480.89999999997]
["Kaur",200,200070,180063]
["Nelia",50,50045,40536.450000000004]
["Michelle",280,280876,230318.32]
["Elain",278,278742,206269.08]
["Yla-Katrina",418,418404,297066.83999999997]
["Manavbir",185,185254,166728.6]
["Yla-Katrina",414,414576,310932]
["Mi",128,128800,109480]
["Gianna",171,171610,123559.2]
["Mitchell",56,56299,45602.19]
["Richard",140,140535,125076.15000000001]
["Yla-Katrina",201,201643,173412.98]
["Sarah",155,155095,124076]
["Daniel",372,372154,308887.82]
["Jason",271,271303,189912.09999999998]
["Nakyun",137,137651,118379.86]
["Shari",458,458771,353253.67]
["Carol",487,487621,370591.96]
["Nelia",296,296846,237476.80000000002]
["Michael",68,68262,59387.94]
["Craig",127,127892,89524.4]
["Manavbir",265,265562,199171.5]
["Manavbir",451,451439,347608.03]
["Sykes",395,395559,304580.43]
["Denise",134,134137,116699.19]
["Michael",152,152856,123813.36000000002]
["Elain",237,237365,175650.1]
["Mansa",348,348098,243668.59999999998]
["Shari",382,382471,309801.51]
["Michelle",380,380477,323405.45]
["Sarah",258,258500,211970.00000000003]
["Mi",324,324837,253372.86000000002]
["Nakyun",331,331085,281422.25]
["Sarah",52,52794,43291.08]
["Manavbir",434,434268,373470.48]
["Michael",269,269832,218563.92]
["Mi",301,301543,253296.12]
["Debra",269,269694,210361.32]
["Richard",134,134265,120838.5]
["Mi",353,353208,254309.75999999998]
["Ewelina",231,231029,187133.49000000002]
["Carol",248,248177,215913.99]
["Michael",232,232311,195141.24]
["Michelle",114,114109,96992.65]
["Sarah",192,192737,167681.19]
["Daniel",242,242675,177152.75]
["Shari",416,416409,320634.93]
["Ewelina",114,114410,96104.4]
["Nakyun",332,332204,269085.24]
["Christina",318,318276,235524.24]
["Sarah",63,63490,50792]
["Craig",124,124167,109266.96]
["Manavbir",53,53854,46852.98]
["Ewelina",439,439667,386906.96]
["Nelia",229,229500,199665]
["Ewelina",340,340683,279360.06]
["Sykes",106,106407,86189.670000000013]
["Janita",280,280247,227000.07]
["Ewelina",234,234322,206203.36000000002]
["Jason",467,467740,416288.60000000003]
["Shari",60,60798,48030.420000000006]
["Debra",236,236097,191238.57]
["Yla-Katrina",461,461314,336759.22]
["Richard",61,61057,48235.03]
["Yla-Katrina",133,133225,94589.75]
["Ewelina",481,481074,408912.89999999997]
["Elain",303,303253,236537.34]
["Mitchell",361,361271,256502.40999999997]
["Yla-Katrina",266,266929,189519.59]
["Mansa",259,259225,209972.25]
["Kaur",62,62715,48290.55]
["Mitchell",368,368295,261489.44999999998]
["Shari",464,464268,371414.4]
["Kaur",77,77430,58846.8]
["Ewelina",117,117766,88324.5]
["Christina",120,120938,85865.98]
["Christina",458,458425,407998.25]
["Shari",349,349757,255322.61]
["Richard",315,315460,264986.39999999997]
["Mitchell",188,188641,169776.9]
["Daniel",413,413367,338960.94]
["Craig",144,144015,122412.75]
["Richard",462,462501,365375.79000000004]
["Elain",276,276520,218450.80000000002]
["Manavbir",142,142059,99441.299999999988]
["Daniel",63,63925,53057.75]
["Craig",223,223657,156559.9]
["Jason",360,360369,317124.72000000003]
["Michelle",411,411800,333558]
["Carol",327,327692,252322.84]
["Shari",322,322816,277621.76000000001]
["Janita",308,308172,274273.08]
["Gianna",83,83876,75488.400000000009]
["Yla-Katrina",198,198422,152784.94]
["Mansa",465,465708,325995.59999999998]
["Michelle",488,488471,341929.69999999995]
["Richard",170,170101,129276.76]
["Mitchell",55,55628,47840.08]
["Shari",461,461693,341652.82]
["Mi",269,269071,234091.77]
["Denise",282,282347,203289.84]
["Mi",110,110092,96880.960000000006]
["Christina",217,217568,154473.28]
["Michael",391,391167,312933.60000000003]
["Ewelina",350,350292,266221.92]
["Gianna",410,410326,291331.45999999996]
["Christina",339,339172,264554.16000000003]
["Christina",193,193288,156563.28]
["Nakyun",62,62133,50949.060000000005]
["Christina",276,276341,240416.67]
["Shari",280,280289,210216.75]
["Manavbir",199,199136,161300.16]
["Richard",434,434933,365343.72]
["Ewelina",445,445426,360795.06]
["Sarah",325,325906,270501.98]
["Nakyun",416,416399,362267.13]
["Sykes",318,318199,238649.25]
["Ewelina",54,54300,42354]
["Michael",447,447455,353489.45]
["Michael",423,423851,368750.37]
["Mi",162,162236,144390.04]
["Mansa",453,453530,408177]
["Mitchell",162,162156,126481.68000000001]
["Janita",358,358386,290292.66000000003]
["Manavbir",321,321789,247777.53]
["Sykes",58,58312,45483.360000000001]
["Mansa",414,414439,331551.2]
["Kaur",381,381754,339761.06]
["Daniel",56,56455,46857.649999999994]
["Mitchell",318,318211,280025.68]
["Michelle",183,183854,136051.96]
["Richard",211,211148,185810.24]
["Carol",432,432463,367593.55]
["Yla-Katrina",91,91814,64269.799999999996]
["Nakyun",439,439034,355617.54000000004]
["Sarah",164,164885,115419.49999999999]
["Kaur",217,217916,187407.76]
["Ewelina",184,184471,166023.9]
["Nakyun",232,232283,164920.93]
["Christina",225,225291,173474.07]
["Jason",136,136798,109438.40000000001]
["Jason",473,473526,340938.72]
["Sarah",63,63301,53805.85]
["Mansa",333,333747,246972.78]
["Michelle",91,91648,82483.199999999997]
["Ewelina",137,137399,114041.17]
["Craig",305,305589,235303.53]
["Shari",224,224942,202447.80000000002]
["Nakyun",456,456973,324450.82999999996]
["Nelia",459,459204,408691.56]
["Nakyun",204,204632,153474]
["Mi",452,452440,334805.59999999998]
["Michael",327,327057,261645.6]
["Carol",108,108297,90969.48]
["Sarah",189,189314,141985.5]
["Nakyun",419,419706,344158.92000000004]
["Gianna",391,391980,313584]
["Yla-Katrina",459,459981,395583.66]
["Michelle",470,470136,362004.72000000003]
["Sykes",129,129337,97002.75]
["Yla-Katrina",440,440699,356966.19]
["Shari",353,353780,300713]
["Mi",162,162328,134732.24]
["Mansa",124,124219,88195.489999999991]
["Sarah",141,141927,102187.44]
["Nelia",281,281884,208594.16]
["Kaur",306,306584,269793.91999999998]
["Manavbir",220,220392,154274.4]
["Christina",210,210794,179174.9]
["Richard",81,81587,67717.209999999992]
["Carol",140,140129,106498.04000000001]
["Richard",133,133369,117364.72]
["Mansa",426,426923,345807.63]
["Richard",337,337455,259840.35]
["Nakyun",230,230318,184254.40000000002]
["Denise",496,496495,397196]
["Shari",177,177889,151205.65]
["Mi",286,286567,232119.27000000002]
["Daniel",305,305371,256511.63999999998]
["Nakyun",418,418241,305315.93]
["Debra",153,153797,138417.30000000002]
["Shari",346,346316,245884.36]
["Christina",119,119481,94389.99]
["Michael",77,77309,69578.100000000006]
["Mitchell",336,336333,242159.75999999998]
["Mansa",245,245174,203494.41999999998]
["Nelia",338,338445,280909.34999999998]
["Daniel",290,290361,232288.80000000002]
["Mitchell",266,266990,221601.69999999998]
["Kaur",192,192427,163562.94999999998]
["Gianna",388,388490,326331.59999999998]
["Nakyun",425,425634,374557.92]
["Carol",192,192131,138334.32]
["Carol",147,147166,123619.44]
["Christina",450,450860,329127.8]
["Michelle",334,334445,234111.49999999997]
["Sarah",216,216382,192579.98]
["Michelle",170,170171,151452.19]
["Michael",317,317223,228400.56]
["Debra",77,77850,57609]
["Nakyun",487,487318,341122.6]
["Yla-Katrina",476,476745,410000.7]
["Jason",429,429155,308991.59999999998]
["Christina",429,429539,326449.64]
["Michelle",158,158968,131943.44]
["Richard",83,83765,64499.05]
["Yla-Katrina",423,423395,309078.34999999998]
["Michael",333,333972,300574.8]
["Sykes",325,325581,273488.03999999998]
["Craig",432,432776,380842.88]
["Jason",377,377083,312978.89]
["Sykes",53,53628,41829.840000000004]
["Nakyun",424,424432,365011.52]
["Kaur",356,356150,316973.5]
["Mitchell",186,186060,132102.6]
["Michael",161,161999,124739.23]
["Kaur",235,235186,197556.24]
["Sykes",466,466729,410721.52]
["Ewelina",485,485371,344613.41]
["Carol",215,215354,155054.88]
["Debra",149,149024,126670.39999999999]
["Debra",376,376238,327327.06]
["Manavbir",142,142820,105686.8]
["Denise",424,424117,309605.40999999997]
["Carol",153,153381,133441.47]
["Manavbir",103,103370,78561.2]
["Ewelina",204,204222,153166.5]
["Kaur",255,255359,178751.3]
["Gianna",449,449447,400007.83]
["Debra",375,375151,292617.78000000003]
["Debra",393,393917,307255.26]
["Debra",450,450028,328520.44]
["Mansa",138,138700,110960]
["Mitchell",209,209879,176298.36]
["Michael",214,214575,171660]
["Elain",326,326370,228459]
["Michelle",464,464165,324915.5]
["Shari",309,309644,216750.8]
["Kaur",460,460792,396281.12]
["Michelle",469,469246,351934.5]
["Denise",301,301783,262551.21000000002]
["Michelle",470,470942,334368.82]
["Carol",92,92075,67214.75]
["Sarah",499,499729,429766.94]
["Nelia",415,415872,365967.35999999999]
["Debra",461,461484,332268.48]
["Elain",196,196539,157231.20000000001]
["Manavbir",336,336238,285802.3]
["Ewelina",409,409435,360302.8]
["Sarah",53,53315,44784.6]
["Gianna",261,261457,188249.03999999998]
["Sykes",451,451115,324802.8]
["Nelia",483,483147,357528.77999999997]
["Mansa",155,155125,122548.75]
["Craig",344,344794,299970.77999999997]
["Craig",214,214162,167046.36000000002]
["Michelle",211,211563,158672.25]
["Daniel",260,260426,203132.28]
["Christina",278,278308,219863.32]
["Mansa",311,311723,224440.56]
["Ewelina",384,384107,303444.53000000003]
["Denise",62,62642,50740.020000000004]
["Michelle",297,297565,249954.59999999998]
["Denise",475,475439,366088.03]
["Mi",64,64389,46360.08]
["Michael",456,456406,324048.26]
["Nakyun",401,401057,332877.31]
["Janita",134,134658,111766.14]
["Sarah",110,110276,89323.560000000012]
["Sarah",205,205431,162290.49000000002]
["Sykes",389,389473,276525.82999999996]
["Manavbir",292,292224,210401.28]
["Michelle",464,464845,409063.6]
["Janita",278,278545,208908.75]
["Sykes",84,84765,59335.499999999993]
["Debra",451,451608,388382.88]
["Daniel",301,301454,244177.74000000002]
["Denise",189,189684,170715.6]
["Mitchell",226,226603,165420.19]
["Kaur",483,483854,372567.58]
["Nelia",389,389205,291903.75]
["Debra",426,426437,324092.12]
["Sykes",442,442729,394028.81]
["Gianna",190,190020,163417.20000000001]
["Gianna",413,413091,330472.80000000005]
["Sykes",346,346550,266843.5]
["Kaur",68,68673,58372.049999999996]
["Jason",375,375934,308265.88]
["Shari",317,317537,234977.38]
["Yla-Katrina",369,369030,269391.89999999997]
["Shari",425,425274,323208.24]
["Michael",92,92735,77897.399999999994]
["Gianna",254,254020,226077.80000000002]
["Debra",431,431097,310389.83999999997]
["Kaur",487,487674,365755.5]
["Nelia",493,493125,364912.5]
["Jason",489,489079,381481.62]
["Shari",439,439185,311821.34999999998]
["Ewelina",353,353844,265383]
["Shari",175,175242,129679.08]
["Denise",498,498507,378865.32]
["Michelle",148,148537,111402.75]
["Ewelina",285,285687,239977.08]
["Gianna",448,448621,403758.9]
["Jason",125,125964,105809.76]
["Mi",134,134282,106082.78]
["Ewelina",196,196007,147005.25]
["Nelia",243,243023,177406.79]
["Mi",283,283255,198278.5]
["Sarah",280,280817,210612.75]
["Sarah",499,499060,384276.2]
["Sykes",141,141166,115756.12000000001]
["Christina",228,228379,182703.2]
["Sarah",118,118859,85578.48]
["Christina",444,444775,315790.25]
["Nakyun",219,219553,166860.28]
["Manavbir",81,81385,59411.049999999996]
["Yla-Katrina",368,368649,324411.12]
["Ewelina",471,471231,419395.59]
["Richard",215,215929,157628.16999999998]
["Mi",418,418184,322001.68]
["Mitchell",193,193240,173916]
["Ewelina",173,173658,121560.59999999999]
["Craig",385,385690,331693.40000000002]
["Nelia",409,409236,306927]
["Yla-Katrina",193,193881,162860.04]
["Manavbir",142,142477,109707.29000000001]
["Nelia",271,271180,197961.4]
["Denise",99,99940,86947.8]
["Janita",65,65896,55352.639999999999]
["Manavbir",144,144956,121763.04]
["Sykes",441,441240,375054]
["Daniel",385,385099,319632.17]
["Sykes",63,63495,55875.6]
["Janita",382,382047,271253.37]
["Sarah",351,351858,292042.14]
["Debra",99,99346,80470.260000000009]
["Craig",485,485477,436929.3]
["Christina",457,457889,380047.87]
["Michael",410,410552,320230.56]
["Manavbir",138,138373,119000.78]
["Sarah",228,228122,173372.72]
["Yla-Katrina",371,371923,290099.94]
["Gianna",277,277149,238348.13999999998]
["Debra",429,429286,369185.96]
["Nakyun",309,309471,216629.69999999998]
["Elain",280,280055,198839.05]
["Kaur",326,326783,287569.03999999998]
["Sarah",346,346140,273450.60000000003]
["Debra",469,469052,370551.08]
["Yla-Katrina",195,195790,154674.1]
["Jason",115,115723,97207.319999999992]
["Michelle",365,365317,325132.13]
["Sykes",105,105482,78056.679999999993]
["Shari",464,464359,329694.88999999996]
["Shari",245,245211,193716.69]
["Shari",295,295884,251501.4]
["Gianna",61,61099,51934.15]
["Nakyun",366,366453,260181.62999999998]
["Jason",225,225244,173437.88]
["Mansa",194,194431,174987.9]
["Manavbir",280,280474,241207.63999999998]
["Richard",444,444389,319960.08]
["Shari",356,356279,260083.66999999998]
["Richard",93,93299,75572.19]
["Gianna",429,429329,347756.49000000005]
["Michelle",290,290615,220867.4]
["Mitchell",462,462134,411299.26]
["Gianna",366,366789,260420.18999999997]
["Manavbir",335,335751,271958.31]
["Christina",390,390565,289018.09999999998]
["Nelia",175,175845,128366.84999999999]
["Nelia",86,86031,77427.900000000009]
["Denise",160,160730,138227.79999999999]
["Christina",194,194761,136332.69999999998]
["Janita",323,323009,281017.83]
["Janita",151,151339,113504.25]
["Nelia",370,370840,318922.40000000002]
["Jason",127,127629,107208.36]
["Craig",51,51165,36838.799999999996]
["Nelia",405,405476,324380.80000000005]
["Daniel",352,352989,303570.53999999998]
["Manavbir",266,266185,228919.1]
["Manavbir",433,433571,351192.51]
["Denise",421,421130,370594.4]
["Mansa",292,292887,263598.3]
["Mitchell",442,442410,331807.5]
["Ewelina",269,269782,229314.69999999998]
["Craig",50,50205,38155.800000000003]
["Elain",68,68924,51003.76]
["Christina",366,366318,296717.58]
["Ewelina",72,72688,61057.919999999998]
["Nelia",73,73683,56735.91]
["Gianna",282,282337,200459.27]
["Denise",188,188288,135567.35999999999]
["Craig",148,148014,113970.78]
["Sarah",116,116659,83994.48]
["Mitchell",456,456314,355924.92]
["Elain",287,287061,252613.68]
["Mi",336,336506,245649.38]
["Denise",68,68409,56095.380000000005]
["Ewelina",435,435738,348590.4]
["Ewelina",398,398043,306493.11]
["Richard",229,229601,195160.85]
["Gianna",485,485869,427564.72000000003]
["Elain",290,290124,235000.44]
["Nakyun",354,354874,280350.46000000002]
["Debra",390,390703,304748.34000000003]
["Sykes",105,105690,90893.4]
["Yla-Katrina",73,73727,51608.899999999994]
["Christina",484,484212,353474.76]
["Manavbir",371,371520,267494.39999999997]
["Nakyun",239,239486,184404.22]
["Christina",188,188427,146973.06]
["Michael",213,213928,166863.84]
["Janita",131,131184,91828.799999999988]
["Yla-Katrina",288,288680,202076]
["Carol",447,447536,393831.67999999999]
["Mansa",247,247781,220525.09]
["Mansa",342,342302,284110.65999999997]
["Shari",218,218551,157356.72]
["Kaur",428,428847,368808.42]
["Daniel",186,186453,149162.4]
["Sarah",431,431188,370821.68]
["Elain",478,478841,368707.57]
["Elain",386,386032,347428.8]
["Ewelina",318,318008,257586.48]
["Sarah",495,495290,401184.9]
["Michael",55,55369,44295.200000000004]
["Kaur",383,383866,284060.84000000003]
["Gianna",331,331334,245187.16]
["Manavbir",50,50113,39589.270000000004]
["Janita",427,427098,358762.32]
["Sarah",181,181609,163448.1]
["Sykes",365,365795,321899.59999999998]
["Manavbir",360,360316,255824.36]
["Shari",318,318460,257952.6]
["Sykes",196,196064,162733.12]
["Denise",133,133063,119756.7]
["Denise",411,411555,321012.90000000002]
["Gianna",145,145311,130779.90000000001]
["Jason",441,441634,344474.52]
["Mansa",99,99601,70716.709999999992]
["Sykes",285,285211,199647.69999999998]
["Michael",106,106255,79691.25]
["Carol",128,128883,95373.42]
["Gianna",225,225749,180599.2]
["Yla-Katrina",401,401549,337301.16]
["Nelia",83,83893,69631.19]
["Jason",325,325910,234655.19999999998]
["Mi",476,476269,390540.58]
["Kaur",95,95610,83180.7]
["Manavbir",110,110557,93973.45]
["Nakyun",393,393864,354477.60000000003]
["Janita",277,277856,236177.6]
["Sykes",78,78049,63219.69]
["Craig",321,321665,270198.59999999998]
["Michael",415,415687,336706.47000000003]
["Kaur",164,164820,115373.99999999999]
["Jason",321,321030,276085.8]
["Sarah",375,375270,326484.90000000002]
["Yla-Katrina",200,200553,176486.64]
["Nelia",261,261504,198743.04000000001]
["Michelle",191,191547,157068.54]
["Sykes",173,173959,132208.84]
["Mansa",67,67255,55821.649999999994]
["Sarah",74,74845,63618.25]
["Mitchell",269,269146,188402.19999999998]
["Craig",192,192517,171340.13]
["Mitchell",170,170035,124125.55]
["Mitchell",135,135252,106849.08]
["Gianna",198,198168,174387.84]
["Kaur",85,85880,60974.799999999996]
["Shari",164,164782,141712.51999999999]
["Kaur",418,418415,317995.40000000002]
["Carol",471,471624,363150.48]
["Mitchell",483,483417,381899.43]
["Kaur",295,295721,230662.38]
["Nelia",309,309111,259653.24]
["Mi",432,432692,302884.39999999997]
["Richard",136,136078,95254.599999999991]
["Manavbir",485,485339,359150.86]
["Shari",84,84188,74085.440000000002]
["Mi",120,120547,87999.31]
["Shari",304,304568,258882.8]
["Mi",489,489189,381567.42000000004]
["Mansa",69,69931,52448.25]
["Janita",51,51750,44505]
["Nakyun",125,125045,97535.1]
["Mansa",263,263916,219050.28]
["Daniel",421,421843,329037.54000000004]
["Gianna",335,335303,288360.58]
["Shari",384,384921,327182.84999999998]
["Sykes",148,148376,123152.07999999999]
["Michelle",316,316144,256076.64]
["Mi",346,346598,270346.44]
["Ewelina",156,156924,122400.72]
["Sykes",336,336966,266203.14]
["Debra",395,395502,316401.60000000003]
["Yla-Katrina",359,359303,294628.46000000002]
["Michael",313,313322,250657.6]
["Nelia",64,64800,56376]
["Manavbir",151,151062,122360.22]
["Nelia",183,183189,157542.54]
["Daniel",136,136322,98151.84]
["Mitchell",402,402154,285529.33999999997]
["Janita",121,121570,108197.3]
["Gianna",58,58325,42577.25]
["Richard",227,227914,159539.79999999999]
["Yla-Katrina",385,385576,335451.12]
["Richard",448,448912,323216.64000000001]
["Daniel",342,342165,246358.8]
["Denise",331,331877,265501.60000000003]
["Nakyun",221,221554,199398.6]
["Mitchell",149,149083,110321.42]
["Richard",382,382283,340231.87]
["Debra",159,159695,130949.90000000001]
["Shari",341,341748,290485.8]
["Debra",124,124647,104703.48]
["Janita",394,394326,311517.54000000004]
["Daniel",133,133865,100398.75]
["Michael",391,391323,352190.7]
["Gianna",253,253225,210176.75]
["Michelle",61,61046,53720.480000000003]
["Mansa",499,499122,449209.8]
["Mitchell",273,273483,216051.57]
["Craig",457,457929,393818.94]
["Sarah",252,252410,222120.8]
["Jason",175,175090,145324.69999999998]
["Sarah",246,246025,216502]
["Elain",131,131728,101430.56]
["Manavbir",223,223692,170005.92]
["Elain",106,106538,84165.02]
["Daniel",80,80687,62935.86]
["Daniel",444,444918,338137.68]
["Michelle",188,188492,135714.23999999999]
["Mitchell",231,231024,173268]
["Nakyun",496,496370,387168.60000000003]
["Jason",153,153632,113687.67999999999]
["Mi",300,300022,231016.94]
["Mi",196,196440,151258.80000000002]
["Craig",482,482007,428986.23]
["Ewelina",136,136076,118386.12]
["Shari",206,206505,152813.70000000001]
["Manavbir",125,125095,103828.84999999999]
["Mitchell",357,357952,257725.44]
["Jason",316,316821,247120.38]
["Elain",157,157169,122591.82]
["Sarah",469,469542,375633.60000000003]
["Carol",451,451670,383919.5]
["Mi",317,317979,273461.94]
["Craig",499,499637,404705.97000000003]
["Debra",469,469318,422386.2]
["Michelle",75,75977,66099.990000000005]
["Yla-Katrina",130,130329,114689.52]
["Nelia",465,465942,335478.24]
["Debra",320,320145,265720.34999999998]
["Michael",465,465852,354047.52]
["Yla-Katrina",384,384428,315230.96000000002]
["Nakyun",155,155925,135654.75]
["Richard",352,352320,292425.59999999998]
["Daniel",286,286149,208888.77]
["Daniel",366,366841,315483.26]
["Ewelina",152,152388,126482.04]
["Kaur",297,297601,208320.69999999998]
["Yla-Katrina",328,328919,230243.3]
["Yla-Katrina",422,422750,359337.5]
["Nelia",313,313389,247577.31]
["Mitchell",207,207773,186995.7]
["Richard",72,72976,60570.079999999994]
["Gianna",280,280154,238130.9]
["Daniel",295,295880,230786.4]
["Craig",251,251493,191134.68]
["Yla-Katrina",390,390811,320465.02]
["Michael",477,477321,386630.01]
["Debra",274,274899,200676.27]
["Mansa",168,168488,149954.32]
["Mansa",480,480871,432783.9]
["Christina",155,155128,139615.20000000001]
["Christina",212,212451,165711.78]
["Richard",382,382863,268004.09999999998]
["Richard",257,257971,221855.06]
["Ewelina",363,363703,301873.49]
["Mansa",422,422765,295935.5]
["Debra",493,493971,365538.54]
["Mi",360,360433,299159.39]
["Mi",151,151866,112380.84]
["Jason",462,462748,411845.72000000003]
["Mansa",243,243330,216563.7]
["Craig",352,352883,264662.25]
["Kaur",446,446425,388389.75]
["Craig",352,352677,264507.75]
["Jason",182,182197,138469.72]
["Shari",364,364718,313657.48]
["Carol",339,339811,292237.46000000002]
["Nakyun",442,442311,340579.47000000003]
["Manavbir",473,473824,426441.60000000003]
["Daniel",142,142774,114219.20000000001]
["Debra",357,357555,264590.7]
["Daniel",232,232634,181454.52000000002]
["Debra",268,268420,238893.80000000002]
["Michael",306,306793,254638.18999999997]
["Michael",395,395740,308677.2]
["Mansa",399,399522,319617.60000000003]
["Gianna",131,131150,100985.5]
["Nakyun",407,407270,297307.09999999998]
["Yla-Katrina",469,469526,403792.36]
["Carol",72,72497,56547.66]
["Debra",83,83845,62883.75]
["Shari",389,389328,295889.28000000003]
["Richard",218,218076,178822.32]
["Mi",337,337502,273376.62]
["Mansa",182,182911,140841.47]
["Elain",93,93698,82454.240000000005]

{"sheet":"P(2)P153-155","index":2,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Flavor","Total Gallons Sold Same Qtr Last Yr "]
["Vanilla",55343]
["Chocolate",76855]
["Strawberry",22436]
["Maple Walnut",11432]
["Praline",14609]
["Butter Pecan",16253]
["Chocolate Chip",35395]
["Mint Chocolate Chip",18935]
["Cookie Dough",23443]
["Rocky Road",16496]
["Fudge Swirl",18394]
["Peach",23504]
["Pumpkin",0]
["Marshmellow Fudge",5392]
["Coffee",43235]
["Mocha Chip",33235]
["Rasberry",0]
["Watermelon",19342]
["Cinnamon Spice",0]

{"sheet":"P153-155(an)","index":3,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Flavor","# Pints Sold Current Quarter","# Gallons Sold Current Quarter","# Tubs Used Current Quarter","Total Sold Current Quarter  in Gallons","Current Flavor Gallons as a % of Total","Total Sold Same Quarter Last Year in Gallons","Historical Flavor Gallons as a % of Total","Total Sold Amount Change","Total Sold % Change"]
["Vanilla",154957,6832,1013.37,{"$f":"B2/A$40+C2+ROUNDDOWN(D2*C$41,0)","v":36334.625},{"$f":"E2/E$25","v":7.3862179597128319E-2},55343,{"$f":"G2/G$25","v":0.12743064110209787},{"$f":"IF(AND(E2=\"\",G2=\"\"),\"\",E2-G2)","v":-19008.375},{"$f":"IF(AND(OR(G2=\"\",G2=0),OR(E2=\"\",E2=0)),\"\",IF(AND(OR(G2=0,G2=\"\"),E2<>0),1,I2/G2))","v":-0.34346484650271941}]
["Chocolate",215191,17424,5954.88,103870.875,0.21115201338009862,76855,0.17696333631898761,27015.875,0.35151746795914385]
["Strawberry",27503,3365,1780.98,24611.875,5.0031801111806509E-2,22436,5.1660261709099028E-2,2175.875,9.6981413799251209E-2]
["Maple Walnut",57513,2701,571.6,15606.125,3.1724626511632756E-2,11432,2.6322878938243009E-2,4174.125,0.36512639958012594]
["Praline",76236,2692,730.46,19525.5,3.9692056481213968E-2,14609,3.3638115676066491E-2,4916.5,0.33653911972072009]
["Butter Pecan",38361,2705,136.44999999999999,8864.125,1.8019274802516746E-2,16253,3.742352618817911E-2,-7388.875,-0.45461607087922229]
["Chocolate Chip",99103,5309,1834.26,36038.875,7.3260969604845461E-2,35395,8.1499151506220363E-2,643.875,1.8191128690493007E-2]
["Mint Chocolate Chip",91186,1469,333.97,16206.25,3.2944579670106978E-2,18935,4.3598995162319049E-2,-2728.75,-0.14411143385265382]
["Cookie Dough",91233,3516,956.68,24486.125,4.9776172518299931E-2,23443,5.3978940775824949E-2,1043.125,4.4496224885893443E-2]
["Rocky Road",46187,3889,824.78,17909.375,3.6406746257112051E-2,16496,3.7983048544896487E-2,1413.375,8.5679861784675071E-2]
["Fudge Swirl",51974,2857,1122.23,20575.75,4.1827038034536287E-2,18394,4.2353309586252788E-2,2181.75,0.11861204740676308]
["Peach",65808,1595,1175.1500000000001,21572,4.3852246672953198E-2,23504,5.4119397005288984E-2,-1932,-8.2198774676650779E-2]
["Pumpkin",0,0,0,0,0,0,0,{"$f":"IF(AND(E14=\"\",G14=\"\"),\"\",E14-G14)","v":0},{"$f":"IF(AND(OR(G14=\"\",G14=0),OR(E14=\"\",E14=0)),\"\",IF(AND(OR(G14=0,G14=\"\"),E14<>0),1,I14/G14))","v":""}]
["Marshmallow Fudge",8467,809,239.19,4258.375,8.6565599353762776E-3,5392,1.2415409660165001E-2,-1133.625,-0.21024202522255192]
["Coffee",228592,6485,2161.73,56676,0.11521277268849878,43235,9.9551230834056717E-2,13441,0.3108823869550133]
["Mocha Chip",130943,4985,168.85,23040.875,4.6838222420762125E-2,33235,7.652561944651036E-2,-10194.125,-0.30672859936813601]
["Raspberry",0,0,0,0,0,0,0,0,""]
["Watermelon",54154,3181,1395.27,23902.25,4.8589252875885204E-2,19342,4.4536137545792186E-2,4560.25,0.23576931030917175]
["Cinnamon Spice",0,0,0,0,0,0,0,0,""]
["Chocolate Fudge",47952,3381,170.56,11080,2.2523775873183823E-2,null,0,11080,{"$f":"IF(AND(OR(G21=\"\",G21=0),OR(E21=\"\",E21=0)),\"\",IF(AND(OR(G21=0,G21=\"\"),E21<>0),1,I21/G21))","v":1}]
["Cherry Vanilla",69125,3800,1492.56,27365.625,5.562971156404297E-2,null,0,27365.625,{"$f":"IF(AND(OR(G22=\"\",G22=0),OR(E22=\"\",E22=0)),\"\",IF(AND(OR(G22=0,G22=\"\"),E22<>0),1,I22/G22))","v":1}]
[]
[null,null,null,null,null,null,null,"% change"]
[null,null,null,"Total",{"$f":"SUM(E2:E22)","v":491924.625},null,{"$f":"SUM(G2:G22)","v":434299},{"$f":"E25/G25-1","v":0.13268652472144771}]
[null,null,null,"Mean",{"$f":"AVERAGE(E2:E22)","v":23424.982142857141},null,{"$f":"AVERAGE(G2:G22)","v":22857.842105263157}]
[null,null,null,"Median",{"$f":"MEDIAN(E2:E22)","v":20575.75},null,{"$f":"MEDIAN(G2:G22)","v":18935}]
[null,null,null,"Mode",{"$f":"MODE(E2:E22)","v":0},null,{"$f":"MODE(G2:G22)","v":0}]
[null,null,null,"Stdev",{"$f":"STDEV(E2:E22)","v":22879.870274547753},null,{"$f":"STDEV(G2:G22)","v":19514.77383438039}]
[null,null,null,"Skew",{"$f":"SKEW(E2:E22)","v":2.3527229922923656},null,{"$f":"SKEW(G2:G22)","v":1.3311218640578739}]
[]
["Assumptions/Inputs, Information, and Directions"]
["Compare quarterly ice cream sales volumes (gallons) from all regional locations for this quarter and same quarter last year"]
["Pints and gallons sold to public"]
["10 gallon tubs sold in store for cones and the like"]
["To eliminate price changes or promotions, volume is used for analysis instead of dollar value of flavors"]
["1 workbook for this quarter"]
["1 workbook for historical data"]
["New flavors this year at bottom"]
[8," =",1]
[1," =",10]
["When making calculations for Tubs, ROUNDDOWN to the nearest Tub."]

{"sheet":"P(3)P155-156","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["See sheets named SiteX and SiteY"]

{"sheet":"SiteX","index":5,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["Respondent#","Age Category","Income","#Desserts Out per Month","# Meals out per Month"]
[100,"22-25",5000,4,4]
[101,"30-35",100000,5,15]
[102,"26-30",75000,3,24]
[103,"18-21",40000,0,15]
[104,"30-35",100000,12,3]
[105,"26-30",50000,8,19]
[106,"30-35",20000,1,8]
[107,"30-35",100000,18,12]
[108,"30-35",20000,14,6]
[109,"30-35",100000,4,20]
[110,"30-35",75000,0,0]
[111,"18-21",30000,0,6]
[112,"22-25",30000,4,12]
[113,"18-21",30000,0,3]
[114,"18-21",5000,0,5]
[115,"over 35",50000,1,7]
[116,"30-35",40000,1,1]
[117,"26-30",20000,10,3]
[118,"30-35",100000,11,13]
[119,"18-21",30000,0,3]
[120,"30-35",30000,3,12]
[121,"26-30",75000,1,20]
[122,"18-21",5000,0,10]
[123,"22-25",20000,0,2]
[124,"18-21",10000,0,0]
[125,"22-25",5000,13,20]
[126,"26-30",75000,5,11]
[127,"over 35",20000,4,1]
[128,"22-25",5000,14,6]
[129,"over 35",100000,12,13]
[130,"18-21",10000,0,2]
[131,"18-21",10000,0,7]
[132,"26-30",100000,11,6]
[133,"22-25",10000,3,5]
[134,"22-25",50000,13,8]
[135,"22-25",20000,6,3]
[136,"26-30",20000,6,11]
[137,"18-21",10000,0,2]
[138,"30-35",75000,1,3]
[139,"22-25",30000,20,9]
[140,"30-35",100000,2,7]
[141,"18-21",5000,0,4]
[142,"22-25",10000,8,0]
[143,"22-25",20000,20,2]
[144,"30-35",20000,9,3]
[145,"18-21",20000,0,18]
[146,"18-21",5000,0,2]
[147,"26-30",5000,10,3]
[148,"22-25",5000,15,5]
[149,"22-25",50000,14,14]
[150,"22-25",40000,20,23]
[151,"22-25",50000,13,9]
[152,"22-25",5000,3,4]
[153,"18-21",40000,0,9]
[154,"30-35",100000,3,16]
[155,"26-30",50000,20,12]
[156,"18-21",30000,0,2]
[157,"18-21",30000,0,7]
[158,"30-35",100000,7,17]
[159,"26-30",30000,5,11]
[160,"18-21",10000,0,1]
[161,"26-30",75000,18,0]
[162,"over 35",100000,8,10]
[163,"30-35",5000,0,3]
[164,"18-21",30000,0,10]
[165,"22-25",100000,7,12]
[166,"30-35",5000,2,2]
[167,"over 35",50000,6,7]
[168,"26-30",20000,1,2]
[169,"26-30",50000,7,3]
[170,"26-30",30000,3,8]
[171,"18-21",20000,0,3]
[172,"30-35",40000,10,17]
[173,"26-30",30000,3,4]
[174,"18-21",5000,0,12]
[175,"over 35",10000,20,2]
[176,"26-30",20000,25,1]
[177,"18-21",5000,0,1]
[178,"22-25",50000,5,8]
[179,"over 35",20000,1,7]
[180,"18-21",30000,0,9]
[181,"30-35",100000,14,15]
[182,"26-30",5000,2,2]
[183,"30-35",100000,9,16]
[184,"26-30",20000,17,2]
[185,"18-21",40000,0,1]
[186,"18-21",30000,0,3]
[187,"18-21",30000,0,6]
[188,"26-30",5000,18,1]
[189,"over 35",10000,8,3]
[190,"22-25",75000,13,6]
[191,"18-21",10000,0,4]
[192,"26-30",20000,11,2]
[193,"26-30",40000,22,15]
[194,"18-21",10000,0,5]
[195,"22-25",75000,17,1]
[196,"18-21",30000,0,3]
[197,"22-25",75000,12,4]
[198,"22-25",100000,16,21]
[199,"18-21",5000,0,9]
[200,"18-21",40000,0,9]
[201,"over 35",100000,7,2]
[202,"22-25",5000,4,1]
[203,"26-30",10000,5,0]
[204,"26-30",75000,4,7]
[205,"26-30",30000,4,2]
[206,"over 35",100000,0,1]

{"sheet":"SiteY","index":6,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["Respondent#","Age Category","Income","#Desserts Out per Month","# Meals out per Month"]
[100,"30-35",75000,0,15]
[101,"30-35",30000,13,10]
[102,"26-30",5000,3,24]
[103,"18-21",20000,0,5]
[104,"30-35",100000,4,16]
[105,"26-30",20000,10,21]
[106,"30-35",75000,8,8]
[107,"30-35",100000,9,5]
[108,"30-35",30000,4,8]
[109,"30-35",75000,4,15]
[110,"30-35",100000,5,4]
[111,"18-21",30000,10,16]
[112,"22-25",5000,9,16]
[113,"18-21",30000,0,2]
[114,"18-21",30000,0,12]
[115,"over 35",100000,1,19]
[116,"30-35",100000,7,3]
[117,"26-30",50000,5,4]
[118,"30-35",100000,16,1]
[119,"18-21",20000,9,9]
[120,"30-35",75000,12,1]
[121,"26-30",10000,1,24]
[122,"18-21",5000,11,9]
[123,"30-35",40000,0,7]
[124,"30-35",30000,15,12]
[125,"22-25",50000,2,16]
[126,"over 35",10000,4,2]
[127,"over 35",40000,11,3]
[128,"22-25",30000,14,16]
[129,"over 35",40000,9,14]
[130,"18-21",10000,0,0]
[131,"18-21",10000,8,12]
[132,"26-30",40000,0,7]
[133,"22-25",30000,16,23]
[134,"22-25",30000,3,28]
[135,"22-25",20000,6,6]
[136,"26-30",5000,7,20]
[137,"18-21",20000,20,8]
[138,"30-35",5000,7,15]
[139,"22-25",5000,6,6]
[140,"30-35",40000,2,14]
[141,"18-21",40000,7,21]
[142,"over 35",10000,5,2]
[143,"22-25",100000,2,27]
[144,"over 35",50000,23,10]
[145,"18-21",10000,6,8]
[146,"18-21",10000,18,15]
[147,"26-30",5000,1,17]
[148,"22-25",10000,2,4]
[149,"22-25",100000,3,18]
[150,"22-25",30000,4,14]
[151,"22-25",30000,11,27]
[152,"22-25",20000,2,11]
[153,"18-21",30000,19,19]
[154,"over 35",20000,18,4]
[155,"26-30",30000,19,10]
[156,"18-21",10000,5,19]
[157,"18-21",40000,11,4]
[158,"30-35",100000,2,3]
[159,"26-30",20000,0,12]
[160,"18-21",20000,13,6]
[161,"26-30",40000,4,2]
[162,"over 35",50000,2,2]
[163,"30-35",30000,9,3]
[164,"18-21",10000,8,1]
[165,"22-25",75000,9,10]
[166,"30-35",100000,7,4]
[167,"over 35",100000,14,13]
[168,"over 35",20000,0,2]
[169,"over 35",50000,1,12]
[170,"26-30",100000,2,25]
[171,"18-21",20000,23,14]
[172,"30-35",75000,17,1]
[173,"26-30",10000,4,8]
[174,"18-21",5000,16,20]
[175,"over 35",10000,2,1]
[176,"26-30",30000,8,3]
[177,"18-21",5000,19,13]
[178,"22-25",5000,0,5]
[179,"over 35",100000,7,17]
[180,"18-21",40000,14,25]
[181,"30-35",40000,1,12]
[182,"26-30",30000,17,11]
[183,"30-35",100000,2,17]
[184,"30-35",30000,16,20]
[185,"18-21",5000,9,0]
[186,"18-21",20000,1,7]
[187,"18-21",30000,4,22]
[188,"26-30",100000,1,26]
[189,"over 35",100000,20,9]
[190,"22-25",20000,5,16]
[191,"18-21",30000,2,24]
[192,"26-30",100000,13,24]
[193,"26-30",20000,0,9]
[194,"18-21",10000,6,9]
[195,"22-25",5000,17,20]
[196,"18-21",10000,0,22]
[197,"22-25",20000,3,13]
[198,"22-25",100000,0,5]
[199,"18-21",10000,6,6]
[200,"18-21",10000,10,3]
[201,"over 35",40000,15,2]
[202,"22-25",75000,2,7]
[203,"30-35",30000,6,16]
[204,"26-30",5000,3,11]
[205,"30-35",100000,1,8]
[206,"over 35",10000,11,7]

{"sheet":"P155(an)","index":7,"n_rows":214,"n_cols":9,"rows_kept":214,"cut":false,"hidden":true,"merged":[]}
["Assumptions/Inputs, Information, and Directions",null,null,"Current Total",{"$f":"SUM(B14:B214)","v":1903250},null,null,"Amount Change","% Change"]
["Summarizes Sales in Dollars by Store",null,null,"Current Mean",{"$f":"AVERAGE(B14:B214)","v":9468.9054726368158},"Historical Mean",8817,{"$f":"E2-G2","v":651.90547263681583},{"$f":"H2/G2","v":7.3937333859228294E-2}]
["Compare summary to previous year",null,null,"Current Median",{"$f":"MEDIAN(B14:B214)","v":9250},"Historical Median",8000,{"$f":"E3-G3","v":1250},{"$f":"H3/G3","v":0.15625}]
["Numbers are rounded to the thousands position",null,null,"Current Mode",{"$f":"MODE(B14:B214)","v":5500},"Historical Mode",5500,{"$f":"E4-G4","v":0},{"$f":"H4/G4","v":0}]
["Compare sales by store with SUM, MEAN, MEDIAN, MODE, STDEV",null,null,"Current Stdev",{"$f":"STDEV(B14:B214)","v":5347.7767152359584},"Historical Standard Deviation",6920,{"$f":"E5-G5","v":-1572.2232847640416},{"$f":"H5/G5","v":-0.22719989664220255}]
["Historical Mean",8817,null,"Current Skew",{"$f":"SKEW(B14:B214)","v":2.1336410568205656E-2}]
["Historical Median",8000]
["Historical Mode",5500,null,"The Average Sales have jumped by 7.39% and the variation in sales per store has dropped. Average sales are up and this is good; matched with the reduction is sales variation per store (means less variation between sales at store or more consistent sales). In particular more consistent sales reduced future uncertainty and helps managers plan with more ease. For these reasons, things are better for this quarter as compared to the same quarter last year."]
["Historical Standard Deviation",6920]
[null,null,null,"Total Sales/Total Gallons = Ave. Sales/1 gal =",{"$f":"E1/'P153-155(an)'!E25","v":3.8689870424762738}]
[]
[]
["Store#","Sales (Rounded to the Thousands Position"]
[101,2250]
[102,10500]
[103,8500]
[104,12250]
[105,1500]
[106,2000]
[107,11000]
[108,17750]
[109,5500]
[110,13250]
[111,14500]
[112,11500]
[113,8250]
[114,12000]
[115,16500]
[116,17000]
[117,1750]
[118,8000]
[119,9500]
[120,2000]
[121,750]
[122,18500]
[123,14750]
[124,2250]
[125,16500]
[126,15000]
[127,1750]
[128,2500]
[129,5750]
[130,7500]
[131,4250]
[132,7000]
[133,6000]
[134,13500]
[135,8750]
[136,10500]
[137,16750]
[138,6500]
[139,4000]
[140,17500]
[141,12750]
[142,6750]
[143,9000]
[144,12500]
[145,2250]
[146,7000]
[147,14750]
[148,10250]
[149,7250]
[150,11250]
[151,7750]
[152,14750]
[153,1750]
[154,5500]
[155,17250]
[156,6500]
[157,5000]
[158,12250]
[159,16500]
[160,4250]
[161,16000]
[162,3500]
[163,1000]
[164,14000]
[165,15250]
[166,5750]
[167,5500]
[168,10750]
[169,16000]
[170,2250]
[171,15250]
[172,16250]
[173,3500]
[174,13750]
[175,9000]
[176,4000]
[177,17250]
[178,10750]
[179,17750]
[180,7250]
[181,16000]
[182,15500]
[183,12250]
[184,18250]
[185,11000]
[186,8000]
[187,18250]
[188,11000]
[189,1500]
[190,8000]
[191,0]
[192,12750]
[193,10500]
[194,15750]
[195,12500]
[196,9250]
[197,18250]
[198,17750]
[199,18250]
[200,4750]
[201,11750]
[202,9250]
[203,5500]
[204,17250]
[205,8250]
[206,5500]
[207,1250]
[208,9500]
[209,11750]
[210,2500]
[211,18000]
[212,9500]
[213,9250]
[214,1500]
[215,5000]
[216,12250]
[217,14500]
[218,15000]
[219,13250]
[220,16250]
[221,14500]
[222,17250]
[223,15250]
[224,18000]
[225,6250]
[226,3750]
[227,9250]
[228,14750]
[229,750]
[230,3000]
[231,13750]
[232,250]
[233,18250]
[234,14250]
[235,14750]
[236,15000]
[237,8500]
[238,3500]
[239,6750]
[240,3750]
[241,1250]
[242,2500]
[243,10500]
[244,3750]
[245,5750]
[246,15250]
[247,9250]
[248,18000]
[249,4000]
[250,8250]
[251,7750]
[252,10500]
[253,6250]
[254,9500]
[255,1500]
[256,3500]
[257,10500]
[258,9000]
[259,13000]
[260,9500]
[261,16000]
[262,3250]
[263,6500]
[264,4250]
[265,8000]
[266,10000]
[267,12750]
[268,10000]
[269,14000]
[270,9750]
[271,7500]
[272,2000]
[273,9750]
[274,16500]
[275,17000]
[276,1750]
[277,1250]
[278,1250]
[279,4500]
[280,13250]
[281,8000]
[282,18000]
[283,2250]
[284,1500]
[285,15750]
[286,13750]
[287,10250]
[288,3750]
[289,4000]
[290,2500]
[291,8250]
[292,16750]
[293,8750]
[294,6000]
[295,11250]
[296,5500]
[297,17250]
[298,2500]
[299,8500]
[300,5500]
[301,11000]

{"sheet":"P155(an2)","index":8,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Assumptions/Inputs, Information, Directions"]
["Open resturant that specializes in fine cuisine and specialty deserts"]
["We must decide where to located: Location, Location, Location!"]
["Location 1:","Near large retail area"]
[null,"Fringe of affluent suburbs"]
["Location 2:","Downtaown district"]
["Highered Local Market Resecrh Firm to find out:","Demogarphics"]
[null,"Specific dining habits"]
[]
["Age Category","Income"]
["18-21",5000]
["22-25",10000]
["26-30",20000]
["30-35",30000]
["over 35",40000]
[null,50000]
[null,75000]
[null,100000]

{"sheet":"P155(an3)","index":9,"n_rows":109,"n_cols":7,"rows_kept":109,"cut":false,"hidden":true,"merged":[]}
["SiteX"]
["Respondent#","Age Category","Income","#Desserts Out per Month",{"$f":"\"Rank \"&D2","v":"Rank #Desserts Out per Month"},"# Meals out per Month",{"$f":"\"Rank \"&F2","v":"Rank # Meals out per Month"}]
[100,"22-25",5000,4,{"$f":"RANK(D3,D$3:D$109)","v":50},4,{"$f":"RANK(F3,F$3:F$109)","v":59}]
[101,"30-35",100000,5,45,15,13]
[102,"26-30",75000,3,57,24,1]
[103,"18-21",40000,0,74,15,13]
[104,"30-35",100000,12,23,3,65]
[105,"26-30",50000,8,34,19,7]
[106,"30-35",20000,1,67,8,38]
[107,"30-35",100000,18,8,12,20]
[108,"30-35",20000,14,15,6,49]
[109,"30-35",100000,4,50,20,4]
[110,"30-35",75000,0,74,0,103]
[111,"18-21",30000,0,74,6,49]
[112,"22-25",30000,4,50,12,20]
[113,"18-21",30000,0,74,3,65]
[114,"18-21",5000,0,74,5,55]
[115,"over 35",50000,1,67,7,42]
[116,"30-35",40000,1,67,1,93]
[117,"26-30",20000,10,29,3,65]
[118,"30-35",100000,11,26,13,18]
[119,"18-21",30000,0,74,3,65]
[120,"30-35",30000,3,57,12,20]
[121,"26-30",75000,1,67,20,4]
[122,"18-21",5000,0,74,10,29]
[123,"22-25",20000,0,74,2,79]
[124,"18-21",10000,0,74,0,103]
[125,"22-25",5000,13,19,20,4]
[126,"26-30",75000,5,45,11,26]
[127,"over 35",20000,4,50,1,93]
[128,"22-25",5000,14,15,6,49]
[129,"over 35",100000,12,23,13,18]
[130,"18-21",10000,0,74,2,79]
[131,"18-21",10000,0,74,7,42]
[132,"26-30",100000,11,26,6,49]
[133,"22-25",10000,3,57,5,55]
[134,"22-25",50000,13,19,8,38]
[135,"22-25",20000,6,42,3,65]
[136,"26-30",20000,6,42,11,26]
[137,"18-21",10000,0,74,2,79]
[138,"30-35",75000,1,67,3,65]
[139,"22-25",30000,20,3,9,32]
[140,"30-35",100000,2,64,7,42]
[141,"18-21",5000,0,74,4,59]
[142,"22-25",10000,8,34,0,103]
[143,"22-25",20000,20,3,2,79]
[144,"30-35",20000,9,32,3,65]
[145,"18-21",20000,0,74,18,8]
[146,"18-21",5000,0,74,2,79]
[147,"26-30",5000,10,29,3,65]
[148,"22-25",5000,15,14,5,55]
[149,"22-25",50000,14,15,14,17]
[150,"22-25",40000,20,3,23,2]
[151,"22-25",50000,13,19,9,32]
[152,"22-25",5000,3,57,4,59]
[153,"18-21",40000,0,74,9,32]
[154,"30-35",100000,3,57,16,11]
[155,"26-30",50000,20,3,12,20]
[156,"18-21",30000,0,74,2,79]
[157,"18-21",30000,0,74,7,42]
[158,"30-35",100000,7,38,17,9]
[159,"26-30",30000,5,45,11,26]
[160,"18-21",10000,0,74,1,93]
[161,"26-30",75000,18,8,0,103]
[162,"over 35",100000,8,34,10,29]
[163,"30-35",5000,0,74,3,65]
[164,"18-21",30000,0,{"$f":"RANK(D67,D$3:D$109)","v":74},10,{"$f":"RANK(F67,F$3:F$109)","v":29}]
[165,"22-25",100000,7,38,12,20]
[166,"30-35",5000,2,64,2,79]
[167,"over 35",50000,6,42,7,42]
[168,"26-30",20000,1,67,2,79]
[169,"26-30",50000,7,38,3,65]
[170,"26-30",30000,3,57,8,38]
[171,"18-21",20000,0,74,3,65]
[172,"30-35",40000,10,29,17,9]
[173,"26-30",30000,3,57,4,59]
[174,"18-21",5000,0,74,12,20]
[175,"over 35",10000,20,3,2,79]
[176,"26-30",20000,25,1,1,93]
[177,"18-21",5000,0,74,1,93]
[178,"22-25",50000,5,45,8,38]
[179,"over 35",20000,1,67,7,42]
[180,"18-21",30000,0,74,9,32]
[181,"30-35",100000,14,15,15,13]
[182,"26-30",5000,2,64,2,79]
[183,"30-35",100000,9,32,16,11]
[184,"26-30",20000,17,11,2,79]
[185,"18-21",40000,0,74,1,93]
[186,"18-21",30000,0,74,3,65]
[187,"18-21",30000,0,74,6,49]
[188,"26-30",5000,18,8,1,93]
[189,"over 35",10000,8,34,3,65]
[190,"22-25",75000,13,19,6,49]
[191,"18-21",10000,0,74,4,59]
[192,"26-30",20000,11,26,2,79]
[193,"26-30",40000,22,2,15,13]
[194,"18-21",10000,0,74,5,55]
[195,"22-25",75000,17,11,1,93]
[196,"18-21",30000,0,74,3,65]
[197,"22-25",75000,12,23,4,59]
[198,"22-25",100000,16,13,21,3]
[199,"18-21",5000,0,74,9,32]
[200,"18-21",40000,0,74,9,32]
[201,"over 35",100000,7,38,2,79]
[202,"22-25",5000,4,50,1,93]
[203,"26-30",10000,5,45,0,103]
[204,"26-30",75000,4,50,7,42]
[205,"26-30",30000,4,50,2,79]
[206,"over 35",100000,0,74,1,93]

{"sheet":"P155(an4)","index":10,"n_rows":113,"n_cols":7,"rows_kept":113,"cut":false,"hidden":true,"merged":[]}
["SiteY"]
["Respondent#","Age Category","Income","#Desserts Out per Month",{"$f":"\"Rank \"&D2","v":"Rank #Desserts Out per Month"},"# Meals out per Month",{"$f":"\"Rank \"&F2","v":"Rank # Meals out per Month"}]
[100,"30-35",75000,0,{"$f":"RANK(D3,D$3:D$109)","v":95},15,{"$f":"RANK(F3,F$3:F$109)","v":34}]
[101,"30-35",30000,13,22,10,54]
[102,"26-30",5000,3,70,24,7]
[103,"18-21",20000,0,95,5,78]
[104,"30-35",100000,4,62,16,27]
[105,"26-30",20000,10,31,21,14]
[106,"30-35",75000,8,41,8,63]
[107,"30-35",100000,9,34,5,78]
[108,"30-35",30000,4,62,8,63]
[109,"30-35",75000,4,62,15,34]
[110,"30-35",100000,5,57,4,82]
[111,"18-21",30000,10,31,16,27]
[112,"22-25",5000,9,34,16,27]
[113,"18-21",30000,0,95,2,94]
[114,"18-21",30000,0,95,12,45]
[115,"over 35",100000,1,87,19,20]
[116,"30-35",100000,7,45,3,88]
[117,"26-30",50000,5,57,4,82]
[118,"30-35",100000,16,13,1,101]
[119,"18-21",20000,9,34,9,58]
[120,"30-35",75000,12,25,1,101]
[121,"26-30",10000,1,87,24,7]
[122,"18-21",5000,11,26,9,58]
[123,"30-35",40000,0,95,7,69]
[124,"30-35",30000,15,17,12,45]
[125,"22-25",50000,2,75,16,27]
[126,"over 35",10000,4,62,2,94]
[127,"over 35",40000,11,26,3,88]
[128,"22-25",30000,14,19,16,27]
[129,"over 35",40000,9,34,14,38]
[130,"18-21",10000,0,95,0,106]
[131,"18-21",10000,8,41,12,45]
[132,"26-30",40000,0,95,7,69]
[133,"22-25",30000,16,13,23,11]
[134,"22-25",30000,3,70,28,1]
[135,"22-25",20000,6,51,6,74]
[136,"26-30",5000,7,45,20,16]
[137,"18-21",20000,20,3,8,63]
[138,"30-35",5000,7,45,15,34]
[139,"22-25",5000,6,51,6,74]
[140,"30-35",40000,2,75,14,38]
[141,"18-21",40000,7,45,21,14]
[142,"over 35",10000,5,57,2,94]
[143,"22-25",100000,2,75,27,2]
[144,"over 35",50000,23,1,10,54]
[145,"18-21",10000,6,51,8,63]
[146,"18-21",10000,18,8,15,34]
[147,"26-30",5000,1,87,17,24]
[148,"22-25",10000,2,75,4,82]
[149,"22-25",100000,3,70,18,23]
[150,"22-25",30000,4,62,14,38]
[151,"22-25",30000,11,26,27,2]
[152,"22-25",20000,2,75,11,51]
[153,"18-21",30000,19,5,19,20]
[154,"over 35",20000,18,8,4,82]
[155,"26-30",30000,19,5,10,54]
[156,"18-21",10000,5,57,19,20]
[157,"18-21",40000,11,26,4,82]
[158,"30-35",100000,2,75,3,88]
[159,"26-30",20000,0,95,12,45]
[160,"18-21",20000,13,22,6,74]
[161,"26-30",40000,4,62,2,94]
[162,"over 35",50000,2,75,2,94]
[163,"30-35",30000,9,34,3,88]
[164,"18-21",10000,8,{"$f":"RANK(D67,D$3:D$109)","v":41},1,{"$f":"RANK(F67,F$3:F$109)","v":101}]
[165,"22-25",75000,9,34,10,54]
[166,"30-35",100000,7,45,4,82]
[167,"over 35",100000,14,19,13,42]
[168,"over 35",20000,0,95,2,94]
[169,"over 35",50000,1,87,12,45]
[170,"26-30",100000,2,75,25,5]
[171,"18-21",20000,23,1,14,38]
[172,"30-35",75000,17,10,1,101]
[173,"26-30",10000,4,62,8,63]
[174,"18-21",5000,16,13,20,16]
[175,"over 35",10000,2,75,1,101]
[176,"26-30",30000,8,41,3,88]
[177,"18-21",5000,19,5,13,42]
[178,"22-25",5000,0,95,5,78]
[179,"over 35",100000,7,45,17,24]
[180,"18-21",40000,14,19,25,5]
[181,"30-35",40000,1,87,12,45]
[182,"26-30",30000,17,10,11,51]
[183,"30-35",100000,2,75,17,24]
[184,"30-35",30000,16,13,20,16]
[185,"18-21",5000,9,34,0,106]
[186,"18-21",20000,1,87,7,69]
[187,"18-21",30000,4,62,22,12]
[188,"26-30",100000,1,87,26,4]
[189,"over 35",100000,20,3,9,58]
[190,"22-25",20000,5,57,16,27]
[191,"18-21",30000,2,75,24,7]
[192,"26-30",100000,13,22,24,7]
[193,"26-30",20000,0,95,9,58]
[194,"18-21",10000,6,51,9,58]
[195,"22-25",5000,17,10,20,16]
[196,"18-21",10000,0,95,22,12]
[197,"22-25",20000,3,70,13,42]
[198,"22-25",100000,0,95,5,78]
[199,"18-21",10000,6,51,6,74]
[200,"18-21",10000,10,31,3,88]
[201,"over 35",40000,15,17,2,94]
[202,"22-25",75000,2,75,7,69]
[203,"30-35",30000,6,51,16,27]
[204,"26-30",5000,3,70,11,51]
[205,"30-35",100000,1,87,8,63]
[206,"over 35",10000,11,26,7,69]
[]
[]
["Assumption for Condistions Formatting"]
[null,null,{"$f":"'P155(an2)'!B17","v":75000},{"$f":"RIGHT('P156(an2)'!A4,1)+0","v":5}]

{"sheet":"P156(an1)","index":11,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":true,"merged":[[6,4,23,7]]}
["Mean and Standard Deviation Analysis"]
[{"$f":"'P155(an3)'!A$1&\" Mean for \"&'P155(an3)'!D$2","v":"SiteX Mean for #Desserts Out per Month"},{"$f":"'P155(an4)'!A$1&\" Mean for \"&'P155(an4)'!D$2","v":"SiteY Mean for #Desserts Out per Month"},"Difference (Y - X)","% Difference",{"$f":"'P155(an3)'!A$1&\" Mean for \"&'P155(an3)'!F$2","v":"SiteX Mean for # Meals out per Month"},{"$f":"'P155(an4)'!A$1&\" Mean for \"&'P155(an4)'!F$2","v":"SiteY Mean for # Meals out per Month"},"Difference (Y - X)","% Difference"]
[{"$f":"AVERAGE(xd)","v":6.1308411214953269},{"$f":"AVERAGE(yd)","v":7.2803738317757007},{"$f":"B3-A3","v":1.1495327102803738},{"$f":"C3/A3","v":0.1875},{"$f":"AVERAGE(xm)","v":7.1121495327102799},{"$f":"AVERAGE(ym)","v":11.345794392523365},{"$f":"F3-E3","v":4.2336448598130847},{"$f":"G3/E3","v":0.59526938239159011}]
[{"$f":"'P155(an3)'!A$1&\" Standard Deviation for \"&'P155(an3)'!D$2","v":"SiteX Standard Deviation for #Desserts Out per Month"},{"$f":"'P155(an4)'!A$1&\" Standard Deviation for \"&'P155(an4)'!D$2","v":"SiteY Standard Deviation for #Desserts Out per Month"},"Difference (Y - X)","% Difference",{"$f":"'P155(an3)'!A$1&\" Standard Deviation for \"&'P155(an3)'!F$2","v":"SiteX Standard Deviation for # Meals out per Month"},{"$f":"'P155(an4)'!A$1&\" Standard Deviation for \"&'P155(an4)'!F$2","v":"SiteY Standard Deviation for # Meals out per Month"},"Difference (Y - X)","% Difference"]
[{"$f":"STDEV(xd)","v":6.6688293676549293},{"$f":"STDEV(yd)","v":6.2113626744882433},{"$f":"B5-A5","v":-0.45746669316668598},{"$f":"C5/A5","v":-6.8597750511579306E-2},{"$f":"STDEV(xm)","v":5.9547461692076498},{"$f":"STDEV(ym)","v":7.5374571606008338},{"$f":"F5-E5","v":1.5827109913931841},{"$f":"G5/E5","v":0.26578983325561006}]
[]
[{"$f":"\"Four Highest \"&'P155(an3)'!D2","v":"Four Highest #Desserts Out per Month"},null,null,null,"From the market research data and our analysis, site Y has a large average for both # of deserts per month and # of meals per month. Although the variation (standard deviation) for the # of meals per month for the Y site is slight higher than it is for the X site, the reverse is true for the # of deserts per month. Lower variation is a great benifit becasue it reduced future uncertainty and helps with planning, but in this case each site has a lower variation and so this statistic will not be used to determine which site should be slected. Thre same trade off can be seen in the low and high analysis. In the end, the dramatic difference in the larger average # of meals per month and larger averange # of deserts per month for the Y site points toward selecting the Y site. A dollar sales per # of deserts and meals might be a next step in the analysis."]
[null,"SiteX","SiteY"]
[1,{"$f":"LARGE(xd,$A9)","v":25},{"$f":"LARGE(yd,$A9)","v":23}]
[2,{"$f":"LARGE(xd,$A10)","v":22},{"$f":"LARGE(yd,$A10)","v":23}]
[3,{"$f":"LARGE(xd,$A11)","v":20},{"$f":"LARGE(yd,$A11)","v":20}]
[4,{"$f":"LARGE(xd,$A12)","v":20},{"$f":"LARGE(yd,$A12)","v":20}]
[]
[{"$f":"\"Ten Lowest \"&'P155(an3)'!F2","v":"Ten Lowest # Meals out per Month"}]
[null,"SiteX","SiteY"]
[1,{"$f":"SMALL(xm,$A16)","v":0},{"$f":"SMALL(ym,$A16)","v":0}]
[2,0,0]
[3,0,1]
[4,0,1]
[5,0,1]
[6,1,1]
[7,1,1]
[8,1,2]
[9,1,2]
[10,1,2]

{"sheet":"P156(an2)","index":12,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Site Y Demographic Analysis"]
[null,"Total number of respondents =",{"$f":"COUNT('P155(an4)'!A3:A109)","v":107}]
[{"$f":"\">=\"&'P155(an2)'!B17","v":">=75000"},{"$f":"\"Total number of respondents with incomes at or above \"&DOLLAR('P155(an2)'!B17)&\" =\"","v":"Total number of respondents with incomes at or above $75,000.00 ="},{"$f":"COUNTIF('P155(an4)'!C3:C109,A3)","v":26}]
["<5","Total number of respondents who eat less than 5 desserts out each month =",{"$f":"COUNTIF(yd,A4)","v":46}]
[{"$f":"\"<\"&'P155(an2)'!B17","v":"<75000"},{"$f":"\"Total number of meals eaten out per month reported by respondents who earn below \"&DOLLAR('P155(an2)'!B17)&\" =\"","v":"Total number of meals eaten out per month reported by respondents who earn below $75,000.00 ="},{"$f":"SUMIF('P155(an4)'!C3:C109,A5,ym)","v":913}]
[{"$f":"'P155(an2)'!A13","v":"26-30"},{"$f":"\"Total number of desserts eaten out per month reported by respondents who are in the \"&A6&\" age category or in the \"&A7&\" age category =\"","v":"Total number of desserts eaten out per month reported by respondents who are in the 26-30 age category or in the 30-35 age category ="},{"$f":"SUMIF('P155(an4)'!B3:B109,A6,yd)+SUMIF('P155(an4)'!B3:B109,A7,yd)","v":265}]
[{"$f":"'P155(an2)'!A14","v":"30-35"}]