{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Name","T&C","Task 1","Task 2","Task 3","Task 4","task4data","Task 5","Task 6","Task 7","Student Report"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Name","index":0,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[12,5,12,6],[17,5,17,10],[21,5,21,10],[12,8,12,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Copyright   Excelcoursesonline.com   2017",null,null,null,null,"Terms and Conditions"]

{"sheet":"T&C","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Task 1","index":2,"n_rows":337,"n_cols":14,"rows_kept":337,"cut":false,"hidden":true,"merged":[[11,13,11,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," Time taken  completing this task:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"After Clicking Finish  Answer these Question."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q1","Total Sales for  Yonkers"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q2","Total Sales for all states (from cell I337)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q3","Change the value in E24 to 108,  what value is now  in cell I337."]
[]
[]
[]
[]
[]
[null,null,"City","Monday","Tueday","Wednesday","Thursday","Friday","Total"]
[null,null,"Abilene",264.5,304.00000000000102,352,263.49999999999898,197.5]
[null,null,"Akron",144.6,173.2,199.4,156.68,112.48]
[null,null,"Albuquerque",54.4,100,84.6,76.319999999999894,48.52]
[null,null,"Alexandria",205.1,239.20000000000101,276.39999999999998,210.57999999999899,155.38]
[null,null,"Allentown",263.39999999999998,302.80000000000098,350.6,262.51999999999902,196.72]
[null,null,"Amarillo",150.1,179.2,206.4,161.58000000000001,116.38]
[null,null,"Anaheim",79.700000000000102,102.4,116.8,98.8599999999998,66.460000000000093]
[null,null,"Anchorage",88.500000000000099,112,128,106.7,72.700000000000102]
[null,null,"Ann Arbor",270,310.00000000000102,359,268.39999999999901,201.4]
[null,null,"Antioch",309.60000000000002,353.20000000000101,409.4,303.67999999999898,229.48]
[null,null,"Antrim",29.5,34.6,44.4,52.5,54.35]
[null,null,"Arlington",74.200000000000102,96.400000000000105,109.8,93.959999999999795,62.560000000000102]
[null,null,"Arvada",289.8,331.60000000000099,384.2,286.039999999999,215.44]
[null,null,"Athens",262.3,301.60000000000099,349.2,261.539999999999,195.94]
[null,null,"Atlanta",63.200000000000102,84.400000000000105,95.799999999999898,84.159999999999897,54.76]
[null,null,"Augusta",147.9,176.8,203.6,159.62,114.82]
[null,null,"Aurora",80.800000000000097,103.6,118.2,99.839999999999804,67.240000000000094]
[null,null,"Aurora",142.4,170.8,196.6,154.72,110.92]
[null,null,"Austin",31.3,49.6,55.2,55.74,32.14]
[null,null,"Bakersfield",76.400000000000105,98.800000000000196,112.6,95.919999999999803,64.120000000000104]
[null,null,"Baltimore",47.8,67.600000000000094,76.2,70.439999999999898,43.84]
[null,null,"Baton Rouge",118.2,144.4,165.8,133.16,93.760000000000105]
[null,null,"Beaumont",265.60000000000002,305.20000000000101,353.4,264.479999999999,198.28]
[null,null,"Belfast",25.6,28.88,34.520000000000003,38.200000000000003,42.78]
[null,null,"Bellevue",241.4,278.80000000000098,322.60000000000002,242.91999999999899,181.12]
[null,null,"Berkeley",274.39999999999998,314.80000000000098,364.6,272.31999999999903,204.52]
[null,null,"Billings",300.8,343.60000000000099,398.2,295.83999999999901,223.24]
[null,null,"Birmingham",129.19999999999999,156.4,179.8,142.96,101.56]
[null,null,"Boise",128.1,155.19999999999999,178.4,141.97999999999999,100.78]
[null,null,"Boston",42.3,61.600000000000101,69.2,65.539999999999907,39.94]
[null,null,"Bridgeport",204,238,275,209.599999999999,154.6]
[null,null,"Broken Arrow",321.7,366.400000000001,424.8,314.45999999999901,238.06]
[null,null,"Brownsville",163.30000000000001,193.6,223.2,173.34,125.74]
[null,null,"Buffalo",99.500000000000099,124,142,116.5,80.500000000000099]
[null,null,"Burbank",315.10000000000002,359.20000000000101,416.4,308.57999999999902,233.38]
[null,null,"Cahir",27.1,31.08,38.32,43.7,47.23]
[null,null,"Cambridge",306.3,349.60000000000099,405.2,300.73999999999899,227.14]
[null,null,"Cape Coral",180.9,212.8,245.6,189.02,138.22]
[null,null,"Carlsbad",290.89999999999998,332.80000000000098,385.6,287.01999999999902,216.22]
[null,null,"Carrollton",245.8,283.60000000000099,328.2,246.83999999999901,184.24]
[null,null,"Cary",207.3,241.6,279.2,212.539999999999,156.94]
[null,null,"Cashel",25.9,29.32,35.28,39.299999999999997,43.67]
[null,null,"Cavan",28,32.4,40.6,47,49.9]
[null,null,"Cedar Rapids",235.9,272.80000000000098,315.60000000000002,238.01999999999899,177.22]
[null,null,"Centennial",317.3,361.60000000000099,419.2,310.539999999999,234.94]
[null,null,"Chandler",107.2,132.4,151.80000000000001,123.36,85.960000000000093]
[null,null,"Charleston",244.7,282.400000000001,326.8,245.85999999999899,183.46]
[null,null,"Charlotte",37.9,56.800000000000097,63.6,61.619999999999898,36.82]
[null,null,"Chattanooga",171,202,233,180.2,131.19999999999999]
[null,null,"Chesapeake",120.4,146.80000000000001,168.6,135.12,95.320000000000107]
[null,null,"Chicago",22.5,40,44,47.9,25.9]
[null,null,"Chula Vista",102.8,127.6,146.19999999999999,119.44,82.840000000000103]
[null,null,"Cincinnati",90.700000000000102,114.4,130.80000000000001,108.66,74.260000000000105]
[null,null,"Clarksville",216.1,251.20000000000101,290.39999999999998,220.379999999999,163.18]
[null,null,"Clearwater",295.3,337.60000000000099,391.2,290.93999999999897,219.34]
[null,null,"Cleveland",72.000000000000099,94.000000000000099,107,91.999999999999801,61.000000000000099]
[null,null,"Clonmel",31.9,38.119999999999997,50.48,61.3,61.47]
[null,null,"Colorado Springs",64.300000000000097,85.600000000000094,97.199999999999903,85.139999999999901,55.54]
[null,null,"Columbia",228.2,264.400000000001,305.8,231.159999999999,171.76]
[null,null,"Columbia",278.8,319.60000000000099,370.2,276.23999999999899,207.64]
[null,null,"Columbus",35.700000000000003,54.4,60.8,59.659999999999897,35.26]
[null,null,"Columbus",146.80000000000001,175.6,202.2,158.63999999999999,114.04]
[null,null,"Concord",250.2,288.400000000001,333.8,250.759999999999,187.36]
[null,null,"Cong",17,34,37,43,22]
[null,null,"Coral Springs",246.9,284.80000000000098,329.6,247.819999999999,185.02]
[null,null,"Cork",25.3,28.44,33.76,37.1,41.89]
[null,null,"Corona",187.5,220,254,194.9,142.9]
[null,null,"Corpus Christi",85.200000000000102,108.4,123.8,103.76,70.360000000000099]
[null,null,"Costa Mesa",281,322.00000000000102,373,278.19999999999902,209.2]
[null,null,"Dallas",29.1,47.2,52.4,53.78,30.58]
[null,null,"Daly City",318.39999999999998,362.80000000000098,420.6,311.51999999999902,235.72]
[null,null,"Davenport",327.2,372.400000000001,431.8,319.35999999999899,241.96]
[null,null,"Dayton",218.3,253.60000000000099,293.2,222.33999999999901,164.74]
[null,null,"Denton",256.8,295.60000000000099,342.2,256.63999999999902,192.04]
[null,null,"Denver",44.5,64.000000000000099,72,67.499999999999901,41.5]
[null,null,"Derry",29.8,35.04,45.16,53.6,55.24]
[null,null,"Des Moines",133.6,161.19999999999999,185.4,146.88,104.68]
[null,null,"Detroit",39,58.000000000000099,65,62.599999999999902,37.6]
[null,null,"Downey",279.89999999999998,320.80000000000098,371.6,277.219999999999,208.42]
[null,null,"Drogheda",26.5,30.2,36.799999999999997,41.5,45.45]
[null,null,"Drogheda",30.4,35.92,46.68,55.8,57.02]
[null,null,"Dublin",25,28,33,36,41]
[null,null,"dundrum",26.8,30.64,37.56,42.6,46.34]
[null,null,"Durham",110.5,136,156,126.3,88.300000000000097]
[null,null,"El Cajon",326.10000000000002,371.20000000000101,430.4,318.37999999999897,241.18]
[null,null,"El Monte",275.5,316.00000000000102,366,273.29999999999899,205.3]
[null,null,"El Paso",40.1,59.200000000000102,66.400000000000006,63.579999999999899,38.380000000000003]
[null,null,"Elgin",285.39999999999998,326.80000000000098,378.6,282.11999999999898,212.32]
[null,null,"Elizabeth",240.3,277.60000000000099,321.2,241.939999999999,180.34]
[null,null,"Elk Grove",186.4,218.8,252.6,193.92,142.12]
[null,null,"Erie",328.3,373.60000000000099,433.2,320.33999999999901,242.74]
[null,null,"Escondido",200.7,234.4,270.8,206.659999999999,152.26]
[null,null,"Eugene",188.6,221.2,255.4,195.88,143.68]
[null,null,"Evansville",259,298.00000000000102,345,258.599999999999,193.6]
[null,null,"Everett",312.89999999999998,356.80000000000098,413.6,306.61999999999898,231.82]
[null,null,"Fairfield",298.60000000000002,341.20000000000101,395.4,293.87999999999897,221.68]
[null,null,"Fargo",288.7,330.400000000001,382.8,285.05999999999898,214.66]
[null,null,"Fayetteville",136.9,164.8,189.6,149.82,107.02]
[null,null,"Flint",331.6,377.20000000000101,437.4,323.27999999999901,245.08]
[null,null,"Fontana",140.19999999999999,168.4,193.8,152.76,109.36]
[null,null,"Fort Collins",198.5,232,268,204.69999999999899,150.69999999999999]
[null,null,"Fort Lauderdale",172.1,203.2,234.4,181.18,131.97999999999999]
[null,null,"Fort Wayne",100.6,125.2,143.4,117.48,81.280000000000101]
[null,null,"Fort Worth",36.799999999999997,55.600000000000101,62.2,60.639999999999901,36.04]
[null,null,"Fremont",124.8,151.6,174.2,139.04,98.440000000000097]
[null,null,"Frenchpark",29.2,34.159999999999997,43.64,51.4,53.46]
[null,null,"Fresno",56.600000000000101,77.200000000000102,87.399999999999906,78.279999999999902,50.08]
[null,null,"Frisco",234.8,271.60000000000099,314.2,237.039999999999,176.44]
[null,null,"Fullerton",220.5,256.00000000000102,296,224.29999999999899,166.3]
[null,null,"Gainesville",242.5,280.00000000000102,324,243.89999999999901,181.9]
[null,null,"Galway",32.5,39,52,63.5,63.25]
[null,null,"Garden Grove",168.8,199.6,230.2,178.24,129.63999999999999]
[null,null,"Garland",113.8,139.6,160.19999999999999,129.24,90.6400000000001]
[null,null,"Geashill",31.3,37.24,48.96,59.1,59.69]
[null,null,"Gilbert",125.9,152.80000000000001,175.6,140.02000000000001,99.220000000000098]
[null,null,"Glendale",114.9,140.80000000000001,161.6,130.22,91.420000000000101]
[null,null,"Glendale",153.4,182.8,210.6,164.52,118.72]
[null,null,"Golden",31.6,37.68,49.72,60.2,60.58]
[null,null,"Grand Prairie",161.1,191.2,220.4,171.38,124.18]
[null,null,"Grand Rapids",154.5,184,212,165.5,119.5]
[null,null,"Green Bay",311.8,355.60000000000099,412.2,305.63999999999902,231.04]
[null,null,"Greensboro",95.100000000000094,119.2,136.4,112.58,77.380000000000095]
[null,null,"Gresham",294.2,336.400000000001,389.8,289.95999999999901,218.56]
[null,null,"Hampton",222.7,258.400000000001,298.8,226.259999999999,167.86]
[null,null,"Hartford",249.1,287.20000000000101,332.4,249.77999999999901,186.58]
[null,null,"Hayward",197.4,230.8,266.60000000000002,203.719999999999,149.91999999999999]
[null,null,"Henderson",97.300000000000097,121.6,139.19999999999999,114.54,78.940000000000097]
[null,null,"Hialeah",116,142,163,131.19999999999999,92.200000000000102]
[null,null,"High Point",303,346.00000000000102,401,297.79999999999899,224.8]
[null,null,"Hollywood",209.5,244.00000000000099,282,214.49999999999901,158.5]
[null,null,"Honolulu",78.600000000000094,101.2,115.4,97.879999999999797,65.680000000000106]
[null,null,"Houston",23.6,41.2,45.4,48.88,26.68]
[null,null,"Huntington Beach",152.30000000000001,181.6,209.2,163.54,117.94]
[null,null,"Huntsville",157.80000000000001,187.6,216.2,168.44,121.84]
[null,null,"Independence",267.8,307.60000000000099,356.2,266.43999999999897,199.84]
[null,null,"Indianapolis",33.5,52,58,57.7,33.700000000000003]
[null,null,"Inglewood",282.10000000000002,323.20000000000101,374.4,279.17999999999898,209.98]
[null,null,"Irvine",119.3,145.6,167.2,134.13999999999999,94.540000000000106]
[null,null,"Irving",121.5,148,170,136.1,96.100000000000094]
[null,null,"Jackson",167.7,198.4,228.8,177.26,128.86000000000001]
[null,null,"Jacksonville",32.4,50.8,56.6,56.72,32.92]
[null,null,"Jersey City",101.7,126.4,144.80000000000001,118.46,82.060000000000102]
[null,null,"Joliet",199.6,233.2,269.39999999999998,205.67999999999901,151.47999999999999]
[null,null,"Kansas City",59.900000000000098,80.800000000000097,91.599999999999895,81.219999999999899,52.42]
[null,null,"Kansas City",201.8,235.6,272.2,207.63999999999899,153.04]
[null,null,"Kenosha",332.7,378.400000000001,438.8,324.25999999999902,245.86]
[null,null,"Kent",253.5,292.00000000000102,338,253.69999999999899,189.7]
[null,null,"Kildare",19.2,36.4,39.799999999999997,44.96,23.56]
[null,null,"Kilkenny",18.100000000000001,35.200000000000003,38.4,43.98,22.78]
[null,null,"Killeen",224.9,260.80000000000098,301.60000000000002,228.219999999999,169.42]
[null,null,"Knoxville",160,190,219,170.4,123.4]
[null,null,"Lafayette",254.6,293.20000000000101,339.4,254.67999999999901,190.48]
[null,null,"Lakewood",208.4,242.8,280.60000000000002,213.51999999999899,157.72]
[null,null,"Lancaster",185.3,217.6,251.2,192.94,141.34]
[null,null,"Lansing",277.7,318.400000000001,368.8,275.25999999999902,206.86]
[null,null,"Laredo",108.3,133.6,153.19999999999999,124.34,86.740000000000094]
[null,null,"Las Cruces",329.4,374.80000000000098,434.6,321.31999999999903,243.52]
[null,null,"Las Vegas",53.3,73.600000000000094,83.2,75.339999999999904,47.74]
[null,null,"Leitrim",28.3,32.840000000000003,41.36,48.1,50.79]
[null,null,"Letterkenny",27.7,31.96,39.840000000000003,45.9,49.01]
[null,null,"Lexington",87.400000000000105,110.8,126.6,105.72,71.920000000000101]
[null,null,"Limerick",32.200000000000003,38.56,51.24,62.4,62.36]
[null,null,"Lincoln",98.400000000000105,122.8,140.6,115.52,79.720000000000098]
[null,null,"Little Rock",149,178,205,160.6,115.6]
[null,null,"Long Beach",58.800000000000097,79.600000000000094,90.199999999999903,80.239999999999895,51.64]
[null,null,"Los Angeles",21.4,38.799999999999997,42.6,46.92,25.12]
[null,null,"Louisville",48.9,68.800000000000097,77.599999999999994,71.419999999999902,44.62]
[null,null,"Lowell",296.39999999999998,338.80000000000098,392.6,291.91999999999899,220.12]
[null,null,"Lubbock",111.6,137.19999999999999,157.4,127.28,89.080000000000098]
[null,null,"Madison",109.4,134.80000000000001,154.6,125.32,87.520000000000095]
[null,null,"Manchester",284.3,325.60000000000099,377.2,281.13999999999902,211.54]
[null,null,"McAllen",223.8,259.60000000000099,300.2,227.23999999999899,168.64]
[null,null,"McKinney",213.9,248.80000000000101,287.60000000000002,218.41999999999899,161.62]
[null,null,"Memphis",41.2,60.400000000000098,67.8,64.559999999999903,39.159999999999997]
[null,null,"Mesa",61.000000000000099,82.000000000000099,92.999999999999901,82.199999999999903,53.2]
[null,null,"Mesquite",215,250.00000000000099,289,219.39999999999901,162.4]
[null,null,"Miami",67.600000000000094,89.200000000000102,101.4,88.079999999999899,57.880000000000102]
[null,null,"Miami Gardens",283.2,324.400000000001,375.8,280.159999999999,210.76]
[null,null,"Midland",260.10000000000002,299.20000000000101,346.4,259.57999999999902,194.38]
[null,null,"Milwaukee",52.2,72.400000000000105,81.8,74.3599999999999,46.96]
[null,null,"Minneapolis",70.900000000000105,92.800000000000097,105.6,91.019999999999797,60.220000000000098]
[null,null,"Miramar",232.6,269.20000000000101,311.39999999999998,235.07999999999899,174.88]
[null,null,"Mobile",151.19999999999999,180.4,207.8,162.56,117.16]
[null,null,"Modesto",135.80000000000001,163.6,188.2,148.84,106.24]
[null,null,"Montgomery",134.69999999999999,162.4,186.8,147.86000000000001,105.46]
[null,null,"Moreno Valley",143.5,172,198,155.69999999999999,111.7]
[null,null,"Murfreesboro",276.60000000000002,317.20000000000101,367.4,274.27999999999901,206.08]
[null,null,"Murrieta",301.89999999999998,344.80000000000098,399.6,296.81999999999903,224.02]
[null,null,"Naperville",212.8,247.60000000000099,286.2,217.439999999999,160.84]
[null,null,"Nashville",46.7,66.400000000000105,74.8,69.459999999999894,43.06]
[null,null,"New Haven",229.3,265.60000000000099,307.2,232.13999999999899,172.54]
[null,null,"New Orleans",75.300000000000097,97.600000000000193,111.2,94.939999999999799,63.340000000000103]
[null,null,"New York",20.3,37.6,41.2,45.94,24.34]
[null,null,"Newark",94.000000000000099,118,135,111.6,76.600000000000094]
[null,null,"Newport News",162.19999999999999,192.4,221.8,172.36,124.96]
[null,null,"Norfolk",106.1,131.19999999999999,150.4,122.38,85.180000000000106]
[null,null,"Norman",273.3,313.60000000000099,363.2,271.33999999999901,203.74]
[null,null,"North Charleston",322.8,367.60000000000099,426.2,315.43999999999897,238.84]
[null,null,"North Las Vegas",123.7,150.4,172.8,138.06,97.660000000000096]
[null,null,"Norwalk",307.39999999999998,350.80000000000098,406.6,301.719999999999,227.92]
[null,null,"Oakland",68.700000000000102,90.400000000000105,102.8,89.059999999999903,58.660000000000103]
[null,null,"Oceanside",169.9,200.8,231.6,179.22,130.41999999999999]
[null,null,"Odessa",308.5,352.00000000000102,408,302.69999999999902,228.7]
[null,null,"Offaly",30.7,36.36,47.44,56.9,57.91]
[null,null,"Oklahoma City",51.1,71.200000000000102,80.400000000000006,73.379999999999896,46.18]
[null,null,"Olathe",231.5,268.00000000000102,310,234.099999999999,174.1]
[null,null,"Omaha",66.500000000000099,88.000000000000099,99.999999999999901,87.099999999999895,57.100000000000101]
[null,null,"Ontario",176.5,208,240,185.1,135.1]
[null,null,"Orange",219.4,254.80000000000101,294.60000000000002,223.319999999999,165.52]
[null,null,"Orlando",103.9,128.80000000000001,147.6,120.42,83.620000000000104]
[null,null,"Overland Park",165.5,196,226,175.3,127.3]
[null,null,"Oxnard",141.30000000000001,169.6,195.2,153.74,110.14]
[null,null,"Palm Bay",316.2,360.400000000001,417.8,309.55999999999898,234.16]
[null,null,"Palmdale",190.8,223.6,258.2,197.84,145.24]
[null,null,"Pasadena",194.1,227.2,262.39999999999998,200.77999999999901,147.58000000000001]
[null,null,"Pasadena",221.6,257.20000000000101,297.39999999999998,225.27999999999901,167.08]
[null,null,"Paterson",210.6,245.20000000000101,283.39999999999998,215.479999999999,159.28]
[null,null,"Pembroke Pines",182,214,247,190,139]
[null,null,"Peoria",184.2,216.4,249.8,191.96,140.56]
[null,null,"Peoria",272.2,312.400000000001,361.8,270.35999999999899,202.96]
[null,null,"Philadelphia",24.7,42.4,46.8,49.86,27.46]
[null,null,"Phoenix",25.8,43.6,48.2,50.84,28.24]
[null,null,"Pittsburgh",86.300000000000097,109.6,125.2,104.74,71.1400000000001]
[null,null,"Plano",96.200000000000102,120.4,137.80000000000001,113.56,78.160000000000096]
[null,null,"Pomona",196.3,229.6,265.2,202.73999999999899,149.13999999999999]
[null,null,"Pompano Beach",320.60000000000002,365.20000000000101,423.4,313.479999999999,237.28]
[null,null,"Port St. Lucie",175.4,206.8,238.6,184.12,134.32]
[null,null,"Portland",50,70.000000000000099,79,72.399999999999906,45.4]
[null,null,"Providence",166.6,197.2,227.4,176.28,128.08000000000001]
[null,null,"Provo",271.10000000000002,311.20000000000101,360.4,269.37999999999897,202.18]
[null,null,"Pueblo",297.5,340.00000000000102,394,292.89999999999901,220.9]
[null,null,"Raleigh",65.400000000000105,86.800000000000097,98.599999999999895,86.119999999999905,56.3200000000001]
[null,null,"Rancho Cucamonga",173.2,204.4,235.8,182.16,132.76]
[null,null,"Reno",117.1,143.19999999999999,164.4,132.18,92.980000000000103]
[null,null,"Rialto",323.89999999999998,368.80000000000098,427.6,316.41999999999899,239.62]
[null,null,"Richardson",319.5,364.00000000000102,422,312.49999999999898,236.5]
[null,null,"Richmond",131.4,158.80000000000001,182.6,144.91999999999999,103.12]
[null,null,"Richmond",305.2,348.400000000001,403.8,299.75999999999902,226.36]
[null,null,"Riverside",84.100000000000094,107.2,122.4,102.78,69.580000000000098]
[null,null,"Rochester",130.30000000000001,157.6,181.2,143.94,102.34]
[null,null,"Rochester",293.10000000000002,335.20000000000101,388.4,288.979999999999,217.78]
[null,null,"Rockford",195.2,228.4,263.8,201.759999999999,148.36000000000001]
[null,null,"Roscommon",28.6,33.28,42.12,49.2,51.68]
[null,null,"Roseville",251.3,289.60000000000099,335.2,251.73999999999899,188.14]
[null,null,"Round Rock",304.10000000000002,347.20000000000101,402.4,298.77999999999901,225.58]
[null,null,"Sacramento",57.700000000000102,78.400000000000105,88.799999999999898,79.259999999999906,50.86]
[null,null,"Saint Paul",91.800000000000097,115.6,132.19999999999999,109.64,75.040000000000106]
[null,null,"Salem",189.7,222.4,256.8,196.86,144.46]
[null,null,"Salinas",191.9,224.8,259.60000000000002,198.82,146.02000000000001]
[null,null,"Salt Lake City",155.6,185.2,213.4,166.48,120.28]
[null,null,"San Antonio",26.9,44.8,49.6,51.82,29.02]
[null,null,"San Bernardino",127,154,177,141,100]
[null,null,"San Diego",28,46,51,52.8,29.8]
[null,null,"San Francisco",34.6,53.2,59.4,58.6799999999999,34.479999999999997]
[null,null,"San Jose",30.2,48.4,53.8,54.76,31.36]
[null,null,"Santa Ana",81.900000000000105,104.8,119.6,100.82,68.020000000000095]
[null,null,"Santa Clara",261.2,300.400000000001,347.8,260.55999999999898,195.16]
[null,null,"Santa Clarita",164.4,194.8,224.6,174.32,126.52]
[null,null,"Santa Maria",325,370.00000000000102,429,317.39999999999901,240.4]
[null,null,"Santa Rosa",174.3,205.6,237.2,183.14,133.54]
[null,null,"Savannah",217.2,252.400000000001,291.8,221.35999999999899,163.96]
[null,null,"Scottsdale",122.6,149.19999999999999,171.4,137.08000000000001,96.880000000000095]
[null,null,"Seattle",43.4,62.800000000000097,70.599999999999994,66.519999999999897,40.72]
[null,null,"Shreveport",139.1,167.2,192.4,151.78,108.58]
[null,null,"Simi Valley",243.6,281.20000000000101,325.39999999999998,244.879999999999,182.68]
[null,null,"Sioux Falls",183.1,215.2,248.4,190.98,139.78]
[null,null,"South Bend",330.5,376.00000000000102,436,322.29999999999899,244.3]
[null,null,"Spokane",132.5,160,184,145.9,103.9]
[null,null,"Springfield",179.8,211.6,244.2,188.04,137.44]
[null,null,"Springfield",193,226,261,199.79999999999899,146.80000000000001]
[null,null,"Springfield",268.89999999999998,308.80000000000098,357.6,267.41999999999899,200.62]
[null,null,"St. Louis",83.000000000000099,106,121,101.8,68.800000000000097]
[null,null,"St. Petersburg",105,130,149,121.4,84.400000000000105]
[null,null,"Stamford",248,286.00000000000102,331,248.79999999999899,185.8]
[null,null,"Sterling Heights",230.4,266.80000000000098,308.60000000000002,233.11999999999901,173.32]
[null,null,"Stockton",89.600000000000094,113.2,129.4,107.68,73.480000000000103]
[null,null,"Sunnyvale",206.2,240.4,277.8,211.55999999999901,156.16]
[null,null,"Surprise",255.7,294.400000000001,340.8,255.659999999999,191.26]
[null,null,"Syracuse",211.7,246.4,284.8,216.45999999999901,160.06]
[null,null,"Tacoma",138,166,191,150.80000000000001,107.8]
[null,null,"Tallahassee",156.69999999999999,186.4,214.8,167.46,121.06]
[null,null,"Tampa",77.500000000000099,100,114,96.899999999999807,64.900000000000105]
[null,null,"Temecula",310.7,354.400000000001,410.8,304.659999999999,230.26]
[null,null,"Tempe",177.6,209.2,241.4,186.08,135.88]
[null,null,"Thornton",252.4,290.80000000000098,336.6,252.719999999999,188.92]
[null,null,"Thousand Oaks",233.7,270.400000000001,312.8,236.05999999999901,175.66]
[null,null,"Toledo",92.900000000000105,116.8,133.6,110.62,75.820000000000107]
[null,null,"Topeka",237,274.00000000000102,317,238.99999999999901,178]
[null,null,"Torrance",202.9,236.8,273.60000000000002,208.61999999999901,153.82]
[null,null,"Tralee",27.4,31.52,39.08,44.8,48.12]
[null,null,"Tuam",26.2,29.76,36.04,40.4,44.56]
[null,null,"Tucson",55.5,76.000000000000099,86,77.299999999999898,49.3]
[null,null,"Tullamore",31,36.799999999999997,48.2,58,58.8]
[null,null,"Tulsa",69.800000000000097,91.600000000000094,104.2,90.039999999999793,59.440000000000097]
[null,null,"Tulsk",28.9,33.72,42.88,50.3,52.57]
[null,null,"Tyrone",30.1,35.479999999999997,45.92,54.7,56.13]
[null,null,"Vallejo",266.7,306.400000000001,354.8,265.45999999999901,199.06]
[null,null,"Vancouver",178.7,210.4,242.8,187.06,136.66]
[null,null,"Victorville",257.89999999999998,296.80000000000098,343.6,257.61999999999898,192.82]
[null,null,"Virginia Beach",62.100000000000101,83.200000000000102,94.399999999999906,83.179999999999893,53.98]
[null,null,"Visalia",238.1,275.20000000000101,318.39999999999998,239.979999999999,178.78]
[null,null,"Waco",239.2,276.400000000001,319.8,240.95999999999901,179.56]
[null,null,"Warren",226,262.00000000000102,303,229.19999999999899,170.2]
[null,null,"Washington",45.6,65.200000000000102,73.400000000000006,68.479999999999905,42.28]
[null,null,"Waterbury",287.60000000000002,329.20000000000101,381.4,284.07999999999902,213.88]
[null,null,"West Covina",299.7,342.400000000001,396.8,294.85999999999899,222.46]
[null,null,"West Valley City",227.1,263.20000000000101,304.39999999999998,230.17999999999901,170.98]
[null,null,"Westminster",292,334.00000000000102,387,287.99999999999898,217]
[null,null,"Wichita",73.100000000000094,95.200000000000102,108.4,92.979999999999805,61.780000000000101]
[null,null,"Wichita Falls",314,358.00000000000102,415,307.599999999999,232.6]
[null,null,"Wilmington",286.5,328.00000000000102,380,283.099999999999,213.1]
[null,null,"Winston-Salem",112.7,138.4,158.80000000000001,128.26,89.860000000000099]
[null,null,"Worcester",158.9,188.8,217.6,169.42,122.62]
[null,null,"Yonkers",145,177,200,150,111]
[]
[null,null,"Total for all Cities"]

{"sheet":"Task 2","index":3,"n_rows":337,"n_cols":14,"rows_kept":337,"cut":false,"hidden":true,"merged":[[11,13,11,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Time took  completing this task:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"After Clicking Finish -fill in these Answers."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q1","Commission amount due to   Austin"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q2","Commission amount  due to Belfast"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q3","Now change the commission rate in cell E20 to 4%. Commission due to Yonkers is"]
[]
[]
[]
[]
[null,null,null,"Commission ",0.1]
[]
[]
[null,null,"City","Monday","Tueday","Wednesday","Thursday","Friday","Total","Commission"]
[null,null,"Abilene",264.5,304.00000000000102,352,263.49999999999898,197.5,{"$f":"SUM(D24:H24)","v":1381.5}]
[null,null,"Akron",144.6,173.2,199.4,156.68,112.48,{"$f":"SUM(D25:H25)","v":786.3599999999999}]
[null,null,"Albuquerque",54.4,74.800000000000097,84.6,76.319999999999894,48.52,338.64]
[null,null,"Alexandria",205.1,239.20000000000101,276.39999999999998,210.57999999999899,155.38,1086.6599999999999]
[null,null,"Allentown",263.39999999999998,302.80000000000098,350.6,262.51999999999902,196.72,1376.04]
[null,null,"Amarillo",150.1,179.2,206.4,161.58000000000001,116.38,813.66]
[null,null,"Anaheim",79.700000000000102,102.4,116.8,98.8599999999998,66.460000000000093,464.21999999999997]
[null,null,"Anchorage",88.500000000000099,112,128,106.7,72.700000000000102,507.9000000000002]
[null,null,"Ann Arbor",270,310.00000000000102,359,268.39999999999901,201.4,1408.8000000000002]
[null,null,"Antioch",309.60000000000002,353.20000000000101,409.4,303.67999999999898,229.48,1605.3600000000001]
[null,null,"Antrim",29.5,34.6,44.4,52.5,54.35,215.35]
[null,null,"Arlington",74.200000000000102,96.400000000000105,109.8,93.959999999999795,62.560000000000102,436.92000000000013]
[null,null,"Arvada",289.8,331.60000000000099,384.2,286.039999999999,215.44,1507.0800000000002]
[null,null,"Athens",262.3,301.60000000000099,349.2,261.539999999999,195.94,1370.5800000000002]
[null,null,"Atlanta",63.200000000000102,84.400000000000105,95.799999999999898,84.159999999999897,54.76,382.32]
[null,null,"Augusta",147.9,176.8,203.6,159.62,114.82,802.74]
[null,null,"Aurora",80.800000000000097,103.6,118.2,99.839999999999804,67.240000000000094,469.67999999999995]
[null,null,"Aurora",142.4,170.8,196.6,154.72,110.92,775.44]
[null,null,"Austin",31.3,49.6,55.2,55.74,32.14,223.98000000000002]
[null,null,"Bakersfield",76.400000000000105,98.800000000000196,112.6,95.919999999999803,64.120000000000104,447.8400000000002]
[null,null,"Baltimore",47.8,67.600000000000094,76.2,70.439999999999898,43.84,305.88]
[null,null,"Baton Rouge",118.2,144.4,165.8,133.16,93.760000000000105,655.32000000000016]
[null,null,"Beaumont",265.60000000000002,305.20000000000101,353.4,264.479999999999,198.28,1386.96]
[null,null,"Belfast",25.6,28.88,34.520000000000003,38.200000000000003,42.78,169.98000000000002]
[null,null,"Bellevue",241.4,278.80000000000098,322.60000000000002,242.91999999999899,181.12,1266.8400000000001]
[null,null,"Berkeley",274.39999999999998,314.80000000000098,364.6,272.31999999999903,204.52,1430.6399999999999]
[null,null,"Billings",300.8,343.60000000000099,398.2,295.83999999999901,223.24,1561.68]
[null,null,"Birmingham",129.19999999999999,156.4,179.8,142.96,101.56,709.92000000000007]
[null,null,"Boise",128.1,155.19999999999999,178.4,141.97999999999999,100.78,704.45999999999992]
[null,null,"Boston",42.3,61.600000000000101,69.2,65.539999999999907,39.94,278.58]
[null,null,"Bridgeport",204,238,275,209.599999999999,154.6,1081.1999999999989]
[null,null,"Broken Arrow",321.7,366.400000000001,424.8,314.45999999999901,238.06,1665.42]
[null,null,"Brownsville",163.30000000000001,193.6,223.2,173.34,125.74,879.18]
[null,null,"Buffalo",99.500000000000099,124,142,116.5,80.500000000000099,562.50000000000023]
[null,null,"Burbank",315.10000000000002,359.20000000000101,416.4,308.57999999999902,233.38,1632.6600000000003]
[null,null,"Cahir",27.1,31.08,38.32,43.7,47.23,187.42999999999998]
[null,null,"Cambridge",306.3,349.60000000000099,405.2,300.73999999999899,227.14,1588.98]
[null,null,"Cape Coral",180.9,212.8,245.6,189.02,138.22,966.54000000000008]
[null,null,"Carlsbad",290.89999999999998,332.80000000000098,385.6,287.01999999999902,216.22,1512.54]
[null,null,"Carrollton",245.8,283.60000000000099,328.2,246.83999999999901,184.24,1288.68]
[null,null,"Cary",207.3,241.6,279.2,212.539999999999,156.94,1097.579999999999]
[null,null,"Cashel",25.9,29.32,35.28,39.299999999999997,43.67,173.47000000000003]
[null,null,"Cavan",28,32.4,40.6,47,49.9,197.9]
[null,null,"Cedar Rapids",235.9,272.80000000000098,315.60000000000002,238.01999999999899,177.22,1239.54]
[null,null,"Centennial",317.3,361.60000000000099,419.2,310.539999999999,234.94,1643.5800000000002]
[null,null,"Chandler",107.2,132.4,151.80000000000001,123.36,85.960000000000093,600.72]
[null,null,"Charleston",244.7,282.400000000001,326.8,245.85999999999899,183.46,1283.22]
[null,null,"Charlotte",37.9,56.800000000000097,63.6,61.619999999999898,36.82,256.74]
[null,null,"Chattanooga",171,202,233,180.2,131.19999999999999,917.40000000000009]
[null,null,"Chesapeake",120.4,146.80000000000001,168.6,135.12,95.320000000000107,666.24000000000024]
[null,null,"Chicago",22.5,40,44,47.9,25.9,180.3]
[null,null,"Chula Vista",102.8,127.6,146.19999999999999,119.44,82.840000000000103,578.88000000000011]
[null,null,"Cincinnati",90.700000000000102,114.4,130.80000000000001,108.66,74.260000000000105,518.82000000000016]
[null,null,"Clarksville",216.1,251.20000000000101,290.39999999999998,220.379999999999,163.18,1141.26]
[null,null,"Clearwater",295.3,337.60000000000099,391.2,290.93999999999897,219.34,1534.3799999999999]
[null,null,"Cleveland",72.000000000000099,94.000000000000099,107,91.999999999999801,61.000000000000099,426.00000000000011]
[null,null,"Clonmel",31.9,38.119999999999997,50.48,61.3,61.47,243.27]
[null,null,"Colorado Springs",64.300000000000097,85.600000000000094,97.199999999999903,85.139999999999901,55.54,387.78000000000003]
[null,null,"Columbia",228.2,264.400000000001,305.8,231.159999999999,171.76,1201.32]
[null,null,"Columbia",278.8,319.60000000000099,370.2,276.23999999999899,207.64,1452.48]
[null,null,"Columbus",35.700000000000003,54.4,60.8,59.659999999999897,35.26,245.81999999999988]
[null,null,"Columbus",146.80000000000001,175.6,202.2,158.63999999999999,114.04,797.27999999999986]
[null,null,"Concord",250.2,288.400000000001,333.8,250.759999999999,187.36,1310.52]
[null,null,"Cong",17,34,37,43,22,153]
[null,null,"Coral Springs",246.9,284.80000000000098,329.6,247.819999999999,185.02,1294.1399999999999]
[null,null,"Cork",25.3,28.44,33.76,37.1,41.89,{"$f":"SUM(D89:H89)","v":166.49}]
[null,null,"Corona",187.5,220,254,194.9,142.9,999.3]
[null,null,"Corpus Christi",85.200000000000102,108.4,123.8,103.76,70.360000000000099,491.52000000000021]
[null,null,"Costa Mesa",281,322.00000000000102,373,278.19999999999902,209.2,1463.4]
[null,null,"Dallas",29.1,47.2,52.4,53.78,30.58,213.06]
[null,null,"Daly City",318.39999999999998,362.80000000000098,420.6,311.51999999999902,235.72,1649.0400000000002]
[null,null,"Davenport",327.2,372.400000000001,431.8,319.35999999999899,241.96,1692.72]
[null,null,"Dayton",218.3,253.60000000000099,293.2,222.33999999999901,164.74,1152.18]
[null,null,"Denton",256.8,295.60000000000099,342.2,256.63999999999902,192.04,1343.28]
[null,null,"Denver",44.5,64.000000000000099,72,67.499999999999901,41.5,289.5]
[null,null,"Derry",29.8,35.04,45.16,53.6,55.24,218.84]
[null,null,"Des Moines",133.6,161.19999999999999,185.4,146.88,104.68,731.76]
[null,null,"Detroit",39,58.000000000000099,65,62.599999999999902,37.6,262.20000000000005]
[null,null,"Downey",279.89999999999998,320.80000000000098,371.6,277.219999999999,208.42,1457.94]
[null,null,"Drogheda",26.5,30.2,36.799999999999997,41.5,45.45,180.45]
[null,null,"Drogheda",30.4,35.92,46.68,55.8,57.02,225.82000000000002]
[null,null,"Dublin",25,28,33,36,41,163]
[null,null,"dundrum",26.8,30.64,37.56,42.6,46.34,183.94]
[null,null,"Durham",110.5,136,156,126.3,88.300000000000097,617.1]
[null,null,"El Cajon",326.10000000000002,371.20000000000101,430.4,318.37999999999897,241.18,1687.2600000000002]
[null,null,"El Monte",275.5,316.00000000000102,366,273.29999999999899,205.3,1436.1]
[null,null,"El Paso",40.1,59.200000000000102,66.400000000000006,63.579999999999899,38.380000000000003,267.66000000000003]
[null,null,"Elgin",285.39999999999998,326.80000000000098,378.6,282.11999999999898,212.32,1485.24]
[null,null,"Elizabeth",240.3,277.60000000000099,321.2,241.939999999999,180.34,1261.3799999999999]
[null,null,"Elk Grove",186.4,218.8,252.6,193.92,142.12,993.84]
[null,null,"Erie",328.3,373.60000000000099,433.2,320.33999999999901,242.74,1698.18]
[null,null,"Escondido",200.7,234.4,270.8,206.659999999999,152.26,1064.819999999999]
[null,null,"Eugene",188.6,221.2,255.4,195.88,143.68,1004.76]
[null,null,"Evansville",259,298.00000000000102,345,258.599999999999,193.6,1354.1999999999998]
[null,null,"Everett",312.89999999999998,356.80000000000098,413.6,306.61999999999898,231.82,1621.74]
[null,null,"Fairfield",298.60000000000002,341.20000000000101,395.4,293.87999999999897,221.68,1550.7600000000002]
[null,null,"Fargo",288.7,330.400000000001,382.8,285.05999999999898,214.66,1501.6200000000001]
[null,null,"Fayetteville",136.9,164.8,189.6,149.82,107.02,748.1400000000001]
[null,null,"Flint",331.6,377.20000000000101,437.4,323.27999999999901,245.08,1714.5600000000002]
[null,null,"Fontana",140.19999999999999,168.4,193.8,152.76,109.36,764.5200000000001]
[null,null,"Fort Collins",198.5,232,268,204.69999999999899,150.69999999999999,1053.899999999999]
[null,null,"Fort Lauderdale",172.1,203.2,234.4,181.18,131.97999999999999,922.8599999999999]
[null,null,"Fort Wayne",100.6,125.2,143.4,117.48,81.280000000000101,567.96000000000015]
[null,null,"Fort Worth",36.799999999999997,55.600000000000101,62.2,60.639999999999901,36.04,251.27999999999997]
[null,null,"Fremont",124.8,151.6,174.2,139.04,98.440000000000097,688.08]
[null,null,"Frenchpark",29.2,34.159999999999997,43.64,51.4,53.46,211.86]
[null,null,"Fresno",56.600000000000101,77.200000000000102,87.399999999999906,78.279999999999902,50.08,349.56]
[null,null,"Frisco",234.8,271.60000000000099,314.2,237.039999999999,176.44,1234.0800000000002]
[null,null,"Fullerton",220.5,256.00000000000102,296,224.29999999999899,166.3,1163.0999999999999]
[null,null,"Gainesville",242.5,280.00000000000102,324,243.89999999999901,181.9,1272.3000000000002]
[null,null,"Galway",32.5,39,52,63.5,63.25,250.25]
[null,null,"Garden Grove",168.8,199.6,230.2,178.24,129.63999999999999,906.4799999999999]
[null,null,"Garland",113.8,139.6,160.19999999999999,129.24,90.6400000000001,633.48]
[null,null,"Geashill",31.3,37.24,48.96,59.1,59.69,236.29]
[null,null,"Gilbert",125.9,152.80000000000001,175.6,140.02000000000001,99.220000000000098,693.54000000000019]
[null,null,"Glendale",114.9,140.80000000000001,161.6,130.22,91.420000000000101,638.94000000000005]
[null,null,"Glendale",153.4,182.8,210.6,164.52,118.72,830.04000000000008]
[null,null,"Golden",31.6,37.68,49.72,60.2,60.58,239.77999999999997]
[null,null,"Grand Prairie",161.1,191.2,220.4,171.38,124.18,868.26]
[null,null,"Grand Rapids",154.5,184,212,165.5,119.5,835.5]
[null,null,"Green Bay",311.8,355.60000000000099,412.2,305.63999999999902,231.04,1616.28]
[null,null,"Greensboro",95.100000000000094,119.2,136.4,112.58,77.380000000000095,540.6600000000002]
[null,null,"Gresham",294.2,336.400000000001,389.8,289.95999999999901,218.56,1528.92]
[null,null,"Hampton",222.7,258.400000000001,298.8,226.259999999999,167.86,1174.02]
[null,null,"Hartford",249.1,287.20000000000101,332.4,249.77999999999901,186.58,1305.06]
[null,null,"Hayward",197.4,230.8,266.60000000000002,203.719999999999,149.91999999999999,1048.4399999999991]
[null,null,"Henderson",97.300000000000097,121.6,139.19999999999999,114.54,78.940000000000097,551.58000000000015]
[null,null,"Hialeah",116,142,163,131.19999999999999,92.200000000000102,644.40000000000009]
[null,null,"High Point",303,346.00000000000102,401,297.79999999999899,224.8,1572.6]
[null,null,"Hollywood",209.5,244.00000000000099,282,214.49999999999901,158.5,{"$f":"SUM(D153:H153)","v":1108.5}]
[null,null,"Honolulu",78.600000000000094,101.2,115.4,97.879999999999797,65.680000000000106,458.76000000000005]
[null,null,"Houston",23.6,41.2,45.4,48.88,26.68,185.76000000000002]
[null,null,"Huntington Beach",152.30000000000001,181.6,209.2,163.54,117.94,824.57999999999993]
[null,null,"Huntsville",157.80000000000001,187.6,216.2,168.44,121.84,851.88]
[null,null,"Independence",267.8,307.60000000000099,356.2,266.43999999999897,199.84,1397.8799999999999]
[null,null,"Indianapolis",33.5,52,58,57.7,33.700000000000003,234.89999999999998]
[null,null,"Inglewood",282.10000000000002,323.20000000000101,374.4,279.17999999999898,209.98,1468.8600000000001]
[null,null,"Irvine",119.3,145.6,167.2,134.13999999999999,94.540000000000106,660.78000000000009]
[null,null,"Irving",121.5,148,170,136.1,96.100000000000094,671.70000000000016]
[null,null,"Jackson",167.7,198.4,228.8,177.26,128.86000000000001,901.0200000000001]
[null,null,"Jacksonville",32.4,50.8,56.6,56.72,32.92,229.44]
[null,null,"Jersey City",101.7,126.4,144.80000000000001,118.46,82.060000000000102,573.42000000000007]
[null,null,"Joliet",199.6,233.2,269.39999999999998,205.67999999999901,151.47999999999999,1059.359999999999]
[null,null,"Kansas City",59.900000000000098,80.800000000000097,91.599999999999895,81.219999999999899,52.42,365.94]
[null,null,"Kansas City",201.8,235.6,272.2,207.63999999999899,153.04,1070.2799999999988]
[null,null,"Kenosha",332.7,378.400000000001,438.8,324.25999999999902,245.86,1720.02]
[null,null,"Kent",253.5,292.00000000000102,338,253.69999999999899,189.7,1326.9]
[null,null,"Kildare",19.2,36.4,39.799999999999997,44.96,23.56,163.92]
[null,null,"Kilkenny",18.100000000000001,35.200000000000003,38.4,43.98,22.78,158.46]
[null,null,"Killeen",224.9,260.80000000000098,301.60000000000002,228.219999999999,169.42,1184.94]
[null,null,"Knoxville",160,190,219,170.4,123.4,862.8]
[null,null,"Lafayette",254.6,293.20000000000101,339.4,254.67999999999901,190.48,1332.36]
[null,null,"Lakewood",208.4,242.8,280.60000000000002,213.51999999999899,157.72,1103.0399999999991]
[null,null,"Lancaster",185.3,217.6,251.2,192.94,141.34,988.38]
[null,null,"Lansing",277.7,318.400000000001,368.8,275.25999999999902,206.86,1447.02]
[null,null,"Laredo",108.3,133.6,153.19999999999999,124.34,86.740000000000094,606.18000000000006]
[null,null,"Las Cruces",329.4,374.80000000000098,434.6,321.31999999999903,243.52,1703.64]
[null,null,"Las Vegas",53.3,73.600000000000094,83.2,75.339999999999904,47.74,333.18]
[null,null,"Leitrim",28.3,32.840000000000003,41.36,48.1,50.79,201.39]
[null,null,"Letterkenny",27.7,31.96,39.840000000000003,45.9,49.01,194.41]
[null,null,"Lexington",87.400000000000105,110.8,126.6,105.72,71.920000000000101,502.44000000000017]
[null,null,"Limerick",32.200000000000003,38.56,51.24,62.4,62.36,246.76]
[null,null,"Lincoln",98.400000000000105,122.8,140.6,115.52,79.720000000000098,557.04000000000019]
[null,null,"Little Rock",149,178,205,160.6,115.6,808.2]
[null,null,"Long Beach",58.800000000000097,79.600000000000094,90.199999999999903,80.239999999999895,51.64,360.48]
[null,null,"Los Angeles",21.4,38.799999999999997,42.6,46.92,25.12,174.84]
[null,null,"Louisville",48.9,68.800000000000097,77.599999999999994,71.419999999999902,44.62,311.34000000000003]
[null,null,"Lowell",296.39999999999998,338.80000000000098,392.6,291.91999999999899,220.12,1539.8400000000001]
[null,null,"Lubbock",111.6,137.19999999999999,157.4,127.28,89.080000000000098,622.56000000000017]
[null,null,"Madison",109.4,134.80000000000001,154.6,125.32,87.520000000000095,611.6400000000001]
[null,null,"Manchester",284.3,325.60000000000099,377.2,281.13999999999902,211.54,1479.78]
[null,null,"McAllen",223.8,259.60000000000099,300.2,227.23999999999899,168.64,1179.48]
[null,null,"McKinney",213.9,248.80000000000101,287.60000000000002,218.41999999999899,161.62,1130.3400000000001]
[null,null,"Memphis",41.2,60.400000000000098,67.8,64.559999999999903,39.159999999999997,273.12]
[null,null,"Mesa",61.000000000000099,82.000000000000099,92.999999999999901,82.199999999999903,53.2,371.40000000000003]
[null,null,"Mesquite",215,250.00000000000099,289,219.39999999999901,162.4,1135.8000000000002]
[null,null,"Miami",67.600000000000094,89.200000000000102,101.4,88.079999999999899,57.880000000000102,404.1600000000002]
[null,null,"Miami Gardens",283.2,324.400000000001,375.8,280.159999999999,210.76,1474.32]
[null,null,"Midland",260.10000000000002,299.20000000000101,346.4,259.57999999999902,194.38,1359.6600000000003]
[null,null,"Milwaukee",52.2,72.400000000000105,81.8,74.3599999999999,46.96,327.71999999999997]
[null,null,"Minneapolis",70.900000000000105,92.800000000000097,105.6,91.019999999999797,60.220000000000098,420.54000000000008]
[null,null,"Miramar",232.6,269.20000000000101,311.39999999999998,235.07999999999899,174.88,1223.1599999999999]
[null,null,"Mobile",151.19999999999999,180.4,207.8,162.56,117.16,819.12]
[null,null,"Modesto",135.80000000000001,163.6,188.2,148.84,106.24,742.68]
[null,null,"Montgomery",134.69999999999999,162.4,186.8,147.86000000000001,105.46,737.22]
[null,null,"Moreno Valley",143.5,172,198,155.69999999999999,111.7,780.90000000000009]
[null,null,"Murfreesboro",276.60000000000002,317.20000000000101,367.4,274.27999999999901,206.08,1441.56]
[null,null,"Murrieta",301.89999999999998,344.80000000000098,399.6,296.81999999999903,224.02,1567.14]
[null,null,"Naperville",212.8,247.60000000000099,286.2,217.439999999999,160.84,1124.8800000000001]
[null,null,"Nashville",46.7,66.400000000000105,74.8,69.459999999999894,43.06,300.42]
[null,null,"New Haven",229.3,265.60000000000099,307.2,232.13999999999899,172.54,1206.78]
[null,null,"New Orleans",75.300000000000097,97.600000000000193,111.2,94.939999999999799,63.340000000000103,442.38000000000017]
[null,null,"New York",20.3,37.6,41.2,45.94,24.34,169.38000000000002]
[null,null,"Newark",94.000000000000099,118,135,111.6,76.600000000000094,{"$f":"SUM(D217:H217)","v":535.20000000000027}]
[null,null,"Newport News",162.19999999999999,192.4,221.8,172.36,124.96,873.72000000000014]
[null,null,"Norfolk",106.1,131.19999999999999,150.4,122.38,85.180000000000106,595.2600000000001]
[null,null,"Norman",273.3,313.60000000000099,363.2,271.33999999999901,203.74,1425.18]
[null,null,"North Charleston",322.8,367.60000000000099,426.2,315.43999999999897,238.84,1670.8799999999999]
[null,null,"North Las Vegas",123.7,150.4,172.8,138.06,97.660000000000096,682.62000000000012]
[null,null,"Norwalk",307.39999999999998,350.80000000000098,406.6,301.719999999999,227.92,1594.44]
[null,null,"Oakland",68.700000000000102,90.400000000000105,102.8,89.059999999999903,58.660000000000103,409.62000000000018]
[null,null,"Oceanside",169.9,200.8,231.6,179.22,130.41999999999999,911.94]
[null,null,"Odessa",308.5,352.00000000000102,408,302.69999999999902,228.7,1599.8999999999999]
[null,null,"Offaly",30.7,36.36,47.44,56.9,57.91,229.31]
[null,null,"Oklahoma City",51.1,71.200000000000102,80.400000000000006,73.379999999999896,46.18,322.26]
[null,null,"Olathe",231.5,268.00000000000102,310,234.099999999999,174.1,1217.6999999999998]
[null,null,"Omaha",66.500000000000099,88.000000000000099,99.999999999999901,87.099999999999895,57.100000000000101,398.7000000000001]
[null,null,"Ontario",176.5,208,240,185.1,135.1,944.7]
[null,null,"Orange",219.4,254.80000000000101,294.60000000000002,223.319999999999,165.52,1157.6400000000001]
[null,null,"Orlando",103.9,128.80000000000001,147.6,120.42,83.620000000000104,584.34000000000015]
[null,null,"Overland Park",165.5,196,226,175.3,127.3,890.09999999999991]
[null,null,"Oxnard",141.30000000000001,169.6,195.2,153.74,110.14,769.9799999999999]
[null,null,"Palm Bay",316.2,360.400000000001,417.8,309.55999999999898,234.16,1638.1200000000001]
[null,null,"Palmdale",190.8,223.6,258.2,197.84,145.24,1015.68]
[null,null,"Pasadena",194.1,227.2,262.39999999999998,200.77999999999901,147.58000000000001,1032.0599999999988]
[null,null,"Pasadena",221.6,257.20000000000101,297.39999999999998,225.27999999999901,167.08,1168.56]
[null,null,"Paterson",210.6,245.20000000000101,283.39999999999998,215.479999999999,159.28,1113.96]
[null,null,"Pembroke Pines",182,214,247,190,139,972]
[null,null,"Peoria",184.2,216.4,249.8,191.96,140.56,982.92000000000007]
[null,null,"Peoria",272.2,312.400000000001,361.8,270.35999999999899,202.96,1419.72]
[null,null,"Philadelphia",24.7,42.4,46.8,49.86,27.46,191.22]
[null,null,"Phoenix",25.8,43.6,48.2,50.84,28.24,196.68]
[null,null,"Pittsburgh",86.300000000000097,109.6,125.2,104.74,71.1400000000001,496.98000000000019]
[null,null,"Plano",96.200000000000102,120.4,137.80000000000001,113.56,78.160000000000096,546.12000000000023]
[null,null,"Pomona",196.3,229.6,265.2,202.73999999999899,149.13999999999999,1042.9799999999989]
[null,null,"Pompano Beach",320.60000000000002,365.20000000000101,423.4,313.479999999999,237.28,1659.9600000000003]
[null,null,"Port St. Lucie",175.4,206.8,238.6,184.12,134.32,939.24]
[null,null,"Portland",50,70.000000000000099,79,72.399999999999906,45.4,316.8]
[null,null,"Providence",166.6,197.2,227.4,176.28,128.08000000000001,895.56]
[null,null,"Provo",271.10000000000002,311.20000000000101,360.4,269.37999999999897,202.18,1414.26]
[null,null,"Pueblo",297.5,340.00000000000102,394,292.89999999999901,220.9,1545.3]
[null,null,"Raleigh",65.400000000000105,86.800000000000097,98.599999999999895,86.119999999999905,56.3200000000001,393.24000000000012]
[null,null,"Rancho Cucamonga",173.2,204.4,235.8,182.16,132.76,928.32]
[null,null,"Reno",117.1,143.19999999999999,164.4,132.18,92.980000000000103,649.86]
[null,null,"Rialto",323.89999999999998,368.80000000000098,427.6,316.41999999999899,239.62,1676.3400000000001]
[null,null,"Richardson",319.5,364.00000000000102,422,312.49999999999898,236.5,1654.5]
[null,null,"Richmond",131.4,158.80000000000001,182.6,144.91999999999999,103.12,720.84]
[null,null,"Richmond",305.2,348.400000000001,403.8,299.75999999999902,226.36,1583.52]
[null,null,"Riverside",84.100000000000094,107.2,122.4,102.78,69.580000000000098,486.06000000000023]
[null,null,"Rochester",130.30000000000001,157.6,181.2,143.94,102.34,715.38]
[null,null,"Rochester",293.10000000000002,335.20000000000101,388.4,288.979999999999,217.78,1523.46]
[null,null,"Rockford",195.2,228.4,263.8,201.759999999999,148.36000000000001,1037.5199999999991]
[null,null,"Roscommon",28.6,33.28,42.12,49.2,51.68,204.88]
[null,null,"Roseville",251.3,289.60000000000099,335.2,251.73999999999899,188.14,1315.98]
[null,null,"Round Rock",304.10000000000002,347.20000000000101,402.4,298.77999999999901,225.58,1578.0600000000002]
[null,null,"Sacramento",57.700000000000102,78.400000000000105,88.799999999999898,79.259999999999906,50.86,355.02]
[null,null,"Saint Paul",91.800000000000097,115.6,132.19999999999999,109.64,75.040000000000106,524.2800000000002]
[null,null,"Salem",189.7,222.4,256.8,196.86,144.46,1010.2200000000001]
[null,null,"Salinas",191.9,224.8,259.60000000000002,198.82,146.02000000000001,1021.1400000000001]
[null,null,"Salt Lake City",155.6,185.2,213.4,166.48,120.28,840.95999999999992]
[null,null,"San Antonio",26.9,44.8,49.6,51.82,29.02,202.14]
[null,null,"San Bernardino",127,154,177,141,100,699]
[null,null,"San Diego",28,46,51,52.8,29.8,207.60000000000002]
[null,null,"San Francisco",34.6,53.2,59.4,58.6799999999999,34.479999999999997,240.3599999999999]
[null,null,"San Jose",30.2,48.4,53.8,54.76,31.36,218.51999999999998]
[null,null,"Santa Ana",81.900000000000105,104.8,119.6,100.82,68.020000000000095,475.14000000000016]
[null,null,"Santa Clara",261.2,300.400000000001,347.8,260.55999999999898,195.16,1365.1200000000001]
[null,null,"Santa Clarita",164.4,194.8,224.6,174.32,126.52,{"$f":"SUM(D281:H281)","v":884.6400000000001}]
[null,null,"Santa Maria",325,370.00000000000102,429,317.39999999999901,240.4,1681.8]
[null,null,"Santa Rosa",174.3,205.6,237.2,183.14,133.54,933.77999999999986]
[null,null,"Savannah",217.2,252.400000000001,291.8,221.35999999999899,163.96,1146.72]
[null,null,"Scottsdale",122.6,149.19999999999999,171.4,137.08000000000001,96.880000000000095,677.16000000000008]
[null,null,"Seattle",43.4,62.800000000000097,70.599999999999994,66.519999999999897,40.72,284.03999999999996]
[null,null,"Shreveport",139.1,167.2,192.4,151.78,108.58,759.06]
[null,null,"Simi Valley",243.6,281.20000000000101,325.39999999999998,244.879999999999,182.68,1277.76]
[null,null,"Sioux Falls",183.1,215.2,248.4,190.98,139.78,977.45999999999992]
[null,null,"South Bend",330.5,376.00000000000102,436,322.29999999999899,244.3,1709.1]
[null,null,"Spokane",132.5,160,184,145.9,103.9,726.3]
[null,null,"Springfield",179.8,211.6,244.2,188.04,137.44,961.07999999999993]
[null,null,"Springfield",193,226,261,199.79999999999899,146.80000000000001,1026.599999999999]
[null,null,"Springfield",268.89999999999998,308.80000000000098,357.6,267.41999999999899,200.62,1403.3400000000001]
[null,null,"St. Louis",83.000000000000099,106,121,101.8,68.800000000000097,480.60000000000025]
[null,null,"St. Petersburg",105,130,149,121.4,84.400000000000105,589.80000000000007]
[null,null,"Stamford",248,286.00000000000102,331,248.79999999999899,185.8,1299.5999999999999]
[null,null,"Sterling Heights",230.4,266.80000000000098,308.60000000000002,233.11999999999901,173.32,1212.24]
[null,null,"Stockton",89.600000000000094,113.2,129.4,107.68,73.480000000000103,513.36000000000024]
[null,null,"Sunnyvale",206.2,240.4,277.8,211.55999999999901,156.16,1092.1199999999992]
[null,null,"Surprise",255.7,294.400000000001,340.8,255.659999999999,191.26,1337.82]
[null,null,"Syracuse",211.7,246.4,284.8,216.45999999999901,160.06,1119.4199999999992]
[null,null,"Tacoma",138,166,191,150.80000000000001,107.8,753.59999999999991]
[null,null,"Tallahassee",156.69999999999999,186.4,214.8,167.46,121.06,846.42000000000007]
[null,null,"Tampa",77.500000000000099,100,114,96.899999999999807,64.900000000000105,453.3]
[null,null,"Temecula",310.7,354.400000000001,410.8,304.659999999999,230.26,1610.82]
[null,null,"Tempe",177.6,209.2,241.4,186.08,135.88,950.16]
[null,null,"Thornton",252.4,290.80000000000098,336.6,252.719999999999,188.92,1321.44]
[null,null,"Thousand Oaks",233.7,270.400000000001,312.8,236.05999999999901,175.66,1228.6200000000001]
[null,null,"Toledo",92.900000000000105,116.8,133.6,110.62,75.820000000000107,529.74000000000024]
[null,null,"Topeka",237,274.00000000000102,317,238.99999999999901,178,1245]
[null,null,"Torrance",202.9,236.8,273.60000000000002,208.61999999999901,153.82,1075.7399999999991]
[null,null,"Tralee",27.4,31.52,39.08,44.8,48.12,190.92000000000002]
[null,null,"Tuam",26.2,29.76,36.04,40.4,44.56,176.96]
[null,null,"Tucson",55.5,76.000000000000099,86,77.299999999999898,49.3,344.1]
[null,null,"Tullamore",31,36.799999999999997,48.2,58,58.8,232.8]
[null,null,"Tulsa",69.800000000000097,91.600000000000094,104.2,90.039999999999793,59.440000000000097,415.0800000000001]
[null,null,"Tulsk",28.9,33.72,42.88,50.3,52.57,208.37]
[null,null,"Tyrone",30.1,35.479999999999997,45.92,54.7,56.13,222.32999999999998]
[null,null,"Vallejo",266.7,306.400000000001,354.8,265.45999999999901,199.06,1392.42]
[null,null,"Vancouver",178.7,210.4,242.8,187.06,136.66,955.62]
[null,null,"Victorville",257.89999999999998,296.80000000000098,343.6,257.61999999999898,192.82,1348.74]
[null,null,"Virginia Beach",62.100000000000101,83.200000000000102,94.399999999999906,83.179999999999893,53.98,376.86]
[null,null,"Visalia",238.1,275.20000000000101,318.39999999999998,239.979999999999,178.78,1250.4599999999998]
[null,null,"Waco",239.2,276.400000000001,319.8,240.95999999999901,179.56,1255.92]
[null,null,"Warren",226,262.00000000000102,303,229.19999999999899,170.2,1190.4000000000001]
[null,null,"Washington",45.6,65.200000000000102,73.400000000000006,68.479999999999905,42.28,294.96000000000004]
[null,null,"Waterbury",287.60000000000002,329.20000000000101,381.4,284.07999999999902,213.88,1496.1600000000003]
[null,null,"West Covina",299.7,342.400000000001,396.8,294.85999999999899,222.46,1556.22]
[null,null,"West Valley City",227.1,263.20000000000101,304.39999999999998,230.17999999999901,170.98,1195.8599999999999]
[null,null,"Westminster",292,334.00000000000102,387,287.99999999999898,217,1518]
[null,null,"Wichita",73.100000000000094,95.200000000000102,108.4,92.979999999999805,61.780000000000101,431.46000000000004]
[null,null,"Wichita Falls",314,358.00000000000102,415,307.599999999999,232.6,1627.1999999999998]
[null,null,"Wilmington",286.5,328.00000000000102,380,283.099999999999,213.1,1490.6999999999998]
[null,null,"Winston-Salem",112.7,138.4,158.80000000000001,128.26,89.860000000000099,628.02000000000021]
[null,null,"Worcester",158.9,188.8,217.6,169.42,122.62,857.34]
[null,null,"Yonkers",145.69999999999999,174.4,200.8,157.66,113.26,791.82]

{"sheet":"Task 3","index":4,"n_rows":339,"n_cols":14,"rows_kept":339,"cut":false,"hidden":true,"merged":[[11,13,11,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Time took  completing this task:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"After Clicking Finish -  Answer this Question."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q1","What city (cities) meets these  3 criteria"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"City","Revenue","Qty","Profit "]
[null,null,"Abilene",264.5,2,352]
[null,null,"Akron",144.6,3,199.4]
[null,null,"Albuquerque",54.4,4,84.6]
[null,null,"Alexandria",205.1,5,276.39999999999998]
[null,null,"Allentown",263.39999999999998,6,350.6]
[null,null,"Amarillo",150.1,7,206.4]
[null,null,"Anaheim",79.700000000000102,8,116.8]
[null,null,"Anchorage",88.500000000000099,9,128]
[null,null,"Ann Arbor",270,10,359]
[null,null,"Antioch",309.60000000000002,11,409.4]
[null,null,"Antrim",29.5,12,44.4]
[null,null,"Arlington",74.200000000000102,13,109.8]
[null,null,"Arvada",289.8,14,384.2]
[null,null,"Athens",262.3,15,349.2]
[null,null,"Atlanta",63.200000000000102,16,95.799999999999898]
[null,null,"Augusta",147.9,17,203.6]
[null,null,"Aurora",80.800000000000097,18,118.2]
[null,null,"Aurora",142.4,19,196.6]
[null,null,"Austin",31.3,20,55.2]
[null,null,"Bakersfield",76.400000000000105,21,112.6]
[null,null,"Baltimore",47.8,22,76.2]
[null,null,"Baton Rouge",118.2,23,165.8]
[null,null,"Beaumont",265.60000000000002,24,353.4]
[null,null,"Belfast",25.6,25,34.520000000000003]
[null,null,"Bellevue",241.4,26,322.60000000000002]
[null,null,"Berkeley",274.39999999999998,27,364.6]
[null,null,"Billings",300.8,28,398.2]
[null,null,"Birmingham",129.19999999999999,29,179.8]
[null,null,"Boise",128.1,30,178.4]
[null,null,"Boston",42.3,31,69.2]
[null,null,"Bridgeport",204,32,275]
[null,null,"Broken Arrow",321.7,33,424.8]
[null,null,"Brownsville",163.30000000000001,34,223.2]
[null,null,"Buffalo",99.500000000000099,35,142]
[null,null,"Burbank",315.10000000000002,36,416.4]
[null,null,"Cahir",27.1,37,38.32]
[null,null,"Cambridge",306.3,38,405.2]
[null,null,"Cape Coral",180.9,39,245.6]
[null,null,"Carlsbad",290.89999999999998,40,385.6]
[null,null,"Carrollton",245.8,41,328.2]
[null,null,"Cary",207.3,42,279.2]
[null,null,"Cashel",25.9,43,35.28]
[null,null,"Cavan",28,44,40.6]
[null,null,"Cedar Rapids",235.9,45,315.60000000000002]
[null,null,"Centennial",317.3,46,419.2]
[null,null,"Chandler",107.2,47,151.80000000000001]
[null,null,"Charleston",244.7,48,326.8]
[null,null,"Charlotte",37.9,49,63.6]
[null,null,"Chattanooga",171,50,233]
[null,null,"Chesapeake",120.4,51,168.6]
[null,null,"Chicago",22.5,52,44]
[null,null,"Chula Vista",102.8,53,146.19999999999999]
[null,null,"Cincinnati",90.700000000000102,54,130.80000000000001]
[null,null,"Clarksville",216.1,55,290.39999999999998]
[null,null,"Clearwater",295.3,56,391.2]
[null,null,"Cleveland",72.000000000000099,57,107]
[null,null,"Clonmel",31.9,58,50.48]
[null,null,"Colorado Springs",64.300000000000097,59,97.199999999999903]
[null,null,"Columbia",228.2,60,305.8]
[null,null,"Columbia",278.8,61,370.2]
[null,null,"Columbus",35.700000000000003,3,60.8]
[null,null,"Columbus",146.80000000000001,4,202.2]
[null,null,"Concord",250.2,5,333.8]
[null,null,"Cong",17,6,37]
[null,null,"Coral Springs",246.9,7,329.6]
[null,null,"Cork",25.3,8,33.76]
[null,null,"Corona",187.5,9,254]
[null,null,"Corpus Christi",85.200000000000102,10,123.8]
[null,null,"Costa Mesa",281,11,373]
[null,null,"Dallas",29.1,12,52.4]
[null,null,"Daly City",318.39999999999998,13,420.6]
[null,null,"Davenport",327.2,14,431.8]
[null,null,"Dayton",218.3,15,293.2]
[null,null,"Denton",256.8,16,342.2]
[null,null,"Denver",44.5,17,72]
[null,null,"Derry",29.8,18,45.16]
[null,null,"Des Moines",133.6,19,185.4]
[null,null,"Detroit",39,20,65]
[null,null,"Downey",279.89999999999998,21,371.6]
[null,null,"Drogheda",26.5,22,36.799999999999997]
[null,null,"Drogheda",30.4,23,46.68]
[null,null,"Dublin",25,24,33]
[null,null,"dundrum",26.8,25,37.56]
[null,null,"Durham",110.5,26,156]
[null,null,"El Cajon",326.10000000000002,27,430.4]
[null,null,"El Monte",275.5,28,366]
[null,null,"El Paso",40.1,29,66.400000000000006]
[null,null,"Elgin",285.39999999999998,30,378.6]
[null,null,"Elizabeth",240.3,31,321.2]
[null,null,"Elk Grove",186.4,32,252.6]
[null,null,"Erie",328.3,33,433.2]
[null,null,"Escondido",200.7,34,270.8]
[null,null,"Eugene",188.6,35,255.4]
[null,null,"Evansville",259,36,345]
[null,null,"Everett",312.89999999999998,37,413.6]
[null,null,"Fairfield",298.60000000000002,38,395.4]
[null,null,"Fargo",288.7,39,382.8]
[null,null,"Fayetteville",136.9,40,189.6]
[null,null,"Flint",331.6,41,437.4]
[null,null,"Fontana",140.19999999999999,42,193.8]
[null,null,"Fort Collins",198.5,43,268]
[null,null,"Fort Lauderdale",172.1,44,234.4]
[null,null,"Fort Wayne",100.6,45,143.4]
[null,null,"Fort Worth",36.799999999999997,46,62.2]
[null,null,"Fremont",124.8,47,174.2]
[null,null,"Frenchpark",29.2,48,43.64]
[null,null,"Fresno",56.600000000000101,49,87.399999999999906]
[null,null,"Frisco",234.8,50,314.2]
[null,null,"Fullerton",220.5,51,296]
[null,null,"Gainesville",242.5,52,324]
[null,null,"Galway",32.5,53,52]
[null,null,"Garden Grove",168.8,54,230.2]
[null,null,"Garland",113.8,55,160.19999999999999]
[null,null,"Geashill",31.3,56,48.96]
[null,null,"Gilbert",125.9,57,175.6]
[null,null,"Glendale",114.9,58,161.6]
[null,null,"Glendale",153.4,59,210.6]
[null,null,"Golden",31.6,60,49.72]
[null,null,"Grand Prairie",161.1,61,220.4]
[null,null,"Grand Rapids",154.5,62,212]
[null,null,"Green Bay",311.8,63,412.2]
[null,null,"Greensboro",95.100000000000094,64,136.4]
[null,null,"Gresham",294.2,65,389.8]
[null,null,"Hampton",222.7,66,298.8]
[null,null,"Hartford",249.1,67,332.4]
[null,null,"Hayward",197.4,68,266.60000000000002]
[null,null,"Henderson",97.300000000000097,69,139.19999999999999]
[null,null,"Hialeah",116,70,163]
[null,null,"High Point",303,71,401]
[null,null,"Hollywood",209.5,72,282]
[null,null,"Honolulu",78.600000000000094,73,115.4]
[null,null,"Houston",23.6,74,45.4]
[null,null,"Huntington Beach",152.30000000000001,75,209.2]
[null,null,"Huntsville",157.80000000000001,76,216.2]
[null,null,"Independence",267.8,77,356.2]
[null,null,"Indianapolis",33.5,78,58]
[null,null,"Inglewood",282.10000000000002,79,374.4]
[null,null,"Irvine",119.3,80,167.2]
[null,null,"Irving",121.5,81,170]
[null,null,"Jackson",167.7,82,228.8]
[null,null,"Jacksonville",32.4,83,56.6]
[null,null,"Jersey City",101.7,84,144.80000000000001]
[null,null,"Joliet",199.6,85,269.39999999999998]
[null,null,"Kansas City",59.900000000000098,86,91.599999999999895]
[null,null,"Kansas City",201.8,87,272.2]
[null,null,"Kenosha",332.7,88,438.8]
[null,null,"Kent",253.5,89,338]
[null,null,"Kildare",19.2,90,39.799999999999997]
[null,null,"Kilkenny",18.100000000000001,91,38.4]
[null,null,"Killeen",224.9,92,301.60000000000002]
[null,null,"Knoxville",160,93,219]
[null,null,"Lafayette",254.6,94,339.4]
[null,null,"Lakewood",208.4,95,280.60000000000002]
[null,null,"Lancaster",185.3,1,251.2]
[null,null,"Lansing",277.7,2,368.8]
[null,null,"Laredo",108.3,3,153.19999999999999]
[null,null,"Las Cruces",329.4,4,434.6]
[null,null,"Las Vegas",53.3,5,83.2]
[null,null,"Leitrim",28.3,6,41.36]
[null,null,"Letterkenny",27.7,7,39.840000000000003]
[null,null,"Lexington",87.400000000000105,8,126.6]
[null,null,"Limerick",32.200000000000003,9,51.24]
[null,null,"Lincoln",98.400000000000105,10,140.6]
[null,null,"Little Rock",149,11,205]
[null,null,"Long Beach",58.800000000000097,12,90.199999999999903]
[null,null,"Los Angeles",21.4,13,42.6]
[null,null,"Louisville",48.9,14,77.599999999999994]
[null,null,"Lowell",296.39999999999998,15,392.6]
[null,null,"Lubbock",111.6,16,157.4]
[null,null,"Madison",109.4,17,154.6]
[null,null,"Manchester",284.3,18,377.2]
[null,null,"McAllen",223.8,19,300.2]
[null,null,"McKinney",213.9,20,287.60000000000002]
[null,null,"Memphis",41.2,21,67.8]
[null,null,"Mesa",61.000000000000099,22,92.999999999999901]
[null,null,"Mesquite",215,23,289]
[null,null,"Miami",67.600000000000094,24,101.4]
[null,null,"Miami Gardens",283.2,25,375.8]
[null,null,"Midland",260.10000000000002,26,346.4]
[null,null,"Milwaukee",52.2,27,81.8]
[null,null,"Minneapolis",70.900000000000105,28,105.6]
[null,null,"Miramar",232.6,29,311.39999999999998]
[null,null,"Mobile",151.19999999999999,30,207.8]
[null,null,"Modesto",135.80000000000001,31,188.2]
[null,null,"Montgomery",134.69999999999999,32,186.8]
[null,null,"Moreno Valley",143.5,33,198]
[null,null,"Murfreesboro",276.60000000000002,34,367.4]
[null,null,"Murrieta",301.89999999999998,35,399.6]
[null,null,"Naperville",212.8,36,286.2]
[null,null,"Nashville",46.7,37,74.8]
[null,null,"New Haven",229.3,38,307.2]
[null,null,"New Orleans",75.300000000000097,39,111.2]
[null,null,"New York",20.3,40,41.2]
[null,null,"Newark",94.000000000000099,41,135]
[null,null,"Newport News",162.19999999999999,42,221.8]
[null,null,"Norfolk",106.1,43,150.4]
[null,null,"Norman",273.3,44,363.2]
[null,null,"North Charleston",322.8,45,426.2]
[null,null,"North Las Vegas",123.7,46,172.8]
[null,null,"Norwalk",307.39999999999998,47,406.6]
[null,null,"Oakland",68.700000000000102,48,102.8]
[null,null,"Oceanside",169.9,49,231.6]
[null,null,"Odessa",308.5,50,408]
[null,null,"Offaly",30.7,51,47.44]
[null,null,"Oklahoma City",51.1,52,80.400000000000006]
[null,null,"Olathe",231.5,53,310]
[null,null,"Omaha",66.500000000000099,54,99.999999999999901]
[null,null,"Ontario",176.5,55,240]
[null,null,"Orange",219.4,56,294.60000000000002]
[null,null,"Orlando",103.9,57,147.6]
[null,null,"Overland Park",165.5,58,226]
[null,null,"Oxnard",141.30000000000001,59,195.2]
[null,null,"Palm Bay",316.2,60,417.8]
[null,null,"Palmdale",190.8,61,258.2]
[null,null,"Pasadena",194.1,62,262.39999999999998]
[null,null,"Pasadena",221.6,63,297.39999999999998]
[null,null,"Paterson",210.6,64,283.39999999999998]
[null,null,"Pembroke Pines",182,65,247]
[null,null,"Peoria",184.2,66,249.8]
[null,null,"Peoria",272.2,67,361.8]
[null,null,"Philadelphia",24.7,68,46.8]
[null,null,"Phoenix",25.8,69,48.2]
[null,null,"Pittsburgh",86.300000000000097,70,125.2]
[null,null,"Plano",96.200000000000102,71,137.80000000000001]
[null,null,"Pomona",196.3,72,265.2]
[null,null,"Pompano Beach",320.60000000000002,73,423.4]
[null,null,"Port St. Lucie",175.4,74,238.6]
[null,null,"Portland",50,75,79]
[null,null,"Providence",166.6,76,227.4]
[null,null,"Provo",271.10000000000002,77,360.4]
[null,null,"Pueblo",297.5,78,394]
[null,null,"Raleigh",65.400000000000105,79,98.599999999999895]
[null,null,"Rancho Cucamonga",173.2,80,235.8]
[null,null,"Reno",117.1,81,164.4]
[null,null,"Rialto",323.89999999999998,82,427.6]
[null,null,"Richardson",319.5,83,422]
[null,null,"Richmond",131.4,84,182.6]
[null,null,"Richmond",305.2,85,403.8]
[null,null,"Riverside",84.100000000000094,86,122.4]
[null,null,"Rochester",130.30000000000001,87,181.2]
[null,null,"Rochester",293.10000000000002,88,388.4]
[null,null,"Rockford",195.2,89,263.8]
[null,null,"Roscommon",28.6,90,42.12]
[null,null,"Roseville",251.3,91,335.2]
[null,null,"Round Rock",304.10000000000002,92,402.4]
[null,null,"Sacramento",57.700000000000102,93,88.799999999999898]
[null,null,"Saint Paul",91.800000000000097,94,132.19999999999999]
[null,null,"Salem",189.7,95,256.8]
[null,null,"Salinas",191.9,96,259.60000000000002]
[null,null,"Salt Lake City",155.6,97,213.4]
[null,null,"San Antonio",26.9,98,49.6]
[null,null,"San Bernardino",127,99,177]
[null,null,"San Diego",28,100,51]
[null,null,"San Francisco",34.6,101,59.4]
[null,null,"San Jose",30.2,102,53.8]
[null,null,"Santa Ana",81.900000000000105,103,119.6]
[null,null,"Santa Clara",261.2,104,347.8]
[null,null,"Santa Clarita",164.4,105,224.6]
[null,null,"Santa Maria",325,106,429]
[null,null,"Santa Rosa",174.3,3,237.2]
[null,null,"Savannah",217.2,4,291.8]
[null,null,"Scottsdale",122.6,5,171.4]
[null,null,"Seattle",43.4,6,70.599999999999994]
[null,null,"Shreveport",139.1,7,192.4]
[null,null,"Simi Valley",243.6,8,325.39999999999998]
[null,null,"Sioux Falls",183.1,9,248.4]
[null,null,"South Bend",330.5,10,436]
[null,null,"Spokane",132.5,11,184]
[null,null,"Springfield",179.8,12,244.2]
[null,null,"Springfield",193,13,261]
[null,null,"Springfield",268.89999999999998,14,357.6]
[null,null,"St. Louis",83.000000000000099,15,121]
[null,null,"St. Petersburg",105,16,149]
[null,null,"Stamford",248,17,331]
[null,null,"Sterling Heights",230.4,18,308.60000000000002]
[null,null,"Stockton",89.600000000000094,19,129.4]
[null,null,"Sunnyvale",206.2,20,277.8]
[null,null,"Surprise",255.7,21,340.8]
[null,null,"Syracuse",211.7,22,284.8]
[null,null,"Tacoma",138,23,191]
[null,null,"Tallahassee",156.69999999999999,24,214.8]
[null,null,"Tampa",77.500000000000099,25,114]
[null,null,"Temecula",310.7,26,410.8]
[null,null,"Tempe",177.6,27,241.4]
[null,null,"Thornton",252.4,28,336.6]
[null,null,"Thousand Oaks",233.7,29,312.8]
[null,null,"Toledo",92.900000000000105,30,133.6]
[null,null,"Topeka",237,31,317]
[null,null,"Torrance",202.9,32,273.60000000000002]
[null,null,"Tralee",27.4,33,39.08]
[null,null,"Tuam",26.2,34,36.04]
[null,null,"Tucson",55.5,35,86]
[null,null,"Tullamore",31,36,48.2]
[null,null,"Tulsa",69.800000000000097,37,104.2]
[null,null,"Tulsk",28.9,38,42.88]
[null,null,"Tyrone",30.1,39,45.92]
[null,null,"Vallejo",266.7,40,354.8]
[null,null,"Vancouver",178.7,41,242.8]
[null,null,"Victorville",257.89999999999998,42,343.6]
[null,null,"Virginia Beach",62.100000000000101,43,94.399999999999906]
[null,null,"Visalia",238.1,44,318.39999999999998]
[null,null,"Waco",239.2,45,319.8]
[null,null,"Warren",226,46,303]
[null,null,"Washington",45.6,47,73.400000000000006]
[null,null,"Waterbury",287.60000000000002,48,381.4]
[null,null,"West Covina",299.7,49,396.8]
[null,null,"West Valley City",227.1,50,304.39999999999998]
[null,null,"Westminster",292,51,387]
[null,null,"Wichita",73.100000000000094,52,108.4]
[null,null,"Wichita Falls",314,53,415]
[null,null,"Wilmington",286.5,54,380]
[null,null,"Winston-Salem",112.7,55,158.80000000000001]
[null,null,"Worcester",158.9,56,217.6]
[null,null,"Yonkers",145,57,200]

{"sheet":"Task 4","index":5,"n_rows":335,"n_cols":14,"rows_kept":335,"cut":false,"hidden":true,"merged":[[11,13,11,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Time took  completing this task:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"After Clicking Finish or Timed out  fill in these Answers."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q1","Commission amount  for  Belfast"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q2","Change the commission rate from 5% to 2% in the task4data worksheet. The Commission amount for  Yonkers is now"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q3","Type your formula from E333 ( leave out = )"]
[]
[]
[]
[null,null,"City","Revenue","Commission Due"]
[null,null,"Abilene",264.5]
[null,null,"Akron",144.6]
[null,null,"Albuquerque",54.4]
[null,null,"Alexandria",205.1]
[null,null,"Allentown",263.39999999999998]
[null,null,"Amarillo",150.1]
[null,null,"Anaheim",79.700000000000102]
[null,null,"Anchorage",88.500000000000099]
[null,null,"Ann Arbor",270]
[null,null,"Antioch",309.60000000000002]
[null,null,"Antrim",29.5]
[null,null,"Arlington",74.200000000000102]
[null,null,"Arvada",289.8]
[null,null,"Athens",262.3]
[null,null,"Atlanta",63.200000000000102]
[null,null,"Augusta",147.9]
[null,null,"Aurora",80.800000000000097]
[null,null,"Aurora",142.4]
[null,null,"Austin",31.3]
[null,null,"Bakersfield",76.400000000000105]
[null,null,"Baltimore",47.8]
[null,null,"Baton Rouge",118.2]
[null,null,"Beaumont",265.60000000000002]
[null,null,"Belfast",25.6]
[null,null,"Bellevue",241.4]
[null,null,"Berkeley",274.39999999999998]
[null,null,"Billings",300.8]
[null,null,"Birmingham",129.19999999999999]
[null,null,"Boise",128.1]
[null,null,"Boston",42.3]
[null,null,"Bridgeport",204]
[null,null,"Broken Arrow",321.7]
[null,null,"Brownsville",163.30000000000001]
[null,null,"Buffalo",99.500000000000099]
[null,null,"Burbank",315.10000000000002]
[null,null,"Cahir",27.1]
[null,null,"Cambridge",306.3]
[null,null,"Cape Coral",180.9]
[null,null,"Carlsbad",290.89999999999998]
[null,null,"Carrollton",245.8]
[null,null,"Cary",207.3]
[null,null,"Cashel",25.9]
[null,null,"Cavan",28]
[null,null,"Cedar Rapids",235.9]
[null,null,"Centennial",317.3]
[null,null,"Chandler",107.2]
[null,null,"Charleston",244.7]
[null,null,"Charlotte",37.9]
[null,null,"Chattanooga",171]
[null,null,"Chesapeake",120.4]
[null,null,"Chicago",22.5]
[null,null,"Chula Vista",102.8]
[null,null,"Cincinnati",90.700000000000102]
[null,null,"Clarksville",216.1]
[null,null,"Clearwater",295.3]
[null,null,"Cleveland",72.000000000000099]
[null,null,"Clonmel",31.9]
[null,null,"Colorado Springs",64.300000000000097]
[null,null,"Columbia",228.2]
[null,null,"Columbia",278.8]
[null,null,"Columbus",35.700000000000003]
[null,null,"Columbus",146.80000000000001]
[null,null,"Concord",250.2]
[null,null,"Cong",17]
[null,null,"Coral Springs",246.9]
[null,null,"Cork",25.3]
[null,null,"Corona",187.5]
[null,null,"Corpus Christi",85.200000000000102]
[null,null,"Costa Mesa",281]
[null,null,"Dallas",29.1]
[null,null,"Daly City",318.39999999999998]
[null,null,"Davenport",327.2]
[null,null,"Dayton",218.3]
[null,null,"Denton",256.8]
[null,null,"Denver",44.5]
[null,null,"Derry",29.8]
[null,null,"Des Moines",133.6]
[null,null,"Detroit",39]
[null,null,"Downey",279.89999999999998]
[null,null,"Drogheda",26.5]
[null,null,"Drogheda",30.4]
[null,null,"Dublin",25]
[null,null,"dundrum",26.8]
[null,null,"Durham",110.5]
[null,null,"El Cajon",326.10000000000002]
[null,null,"El Monte",275.5]
[null,null,"El Paso",40.1]
[null,null,"Elgin",285.39999999999998]
[null,null,"Elizabeth",240.3]
[null,null,"Elk Grove",186.4]
[null,null,"Erie",328.3]
[null,null,"Escondido",200.7]
[null,null,"Eugene",188.6]
[null,null,"Evansville",259]
[null,null,"Everett",312.89999999999998]
[null,null,"Fairfield",298.60000000000002]
[null,null,"Fargo",288.7]
[null,null,"Fayetteville",136.9]
[null,null,"Flint",331.6]
[null,null,"Fontana",140.19999999999999]
[null,null,"Fort Collins",198.5]
[null,null,"Fort Lauderdale",172.1]
[null,null,"Fort Wayne",100.6]
[null,null,"Fort Worth",36.799999999999997]
[null,null,"Fremont",124.8]
[null,null,"Frenchpark",29.2]
[null,null,"Fresno",56.600000000000101]
[null,null,"Frisco",234.8]
[null,null,"Fullerton",220.5]
[null,null,"Gainesville",242.5]
[null,null,"Galway",32.5]
[null,null,"Garden Grove",168.8]
[null,null,"Garland",113.8]
[null,null,"Geashill",31.3]
[null,null,"Gilbert",125.9]
[null,null,"Glendale",114.9]
[null,null,"Glendale",153.4]
[null,null,"Golden",31.6]
[null,null,"Grand Prairie",161.1]
[null,null,"Grand Rapids",154.5]
[null,null,"Green Bay",311.8]
[null,null,"Greensboro",95.100000000000094]
[null,null,"Gresham",294.2]
[null,null,"Hampton",222.7]
[null,null,"Hartford",249.1]
[null,null,"Hayward",197.4]
[null,null,"Henderson",97.300000000000097]
[null,null,"Hialeah",116]
[null,null,"High Point",303]
[null,null,"Hollywood",209.5]
[null,null,"Honolulu",78.600000000000094]
[null,null,"Houston",23.6]
[null,null,"Huntington Beach",152.30000000000001]
[null,null,"Huntsville",157.80000000000001]
[null,null,"Independence",267.8]
[null,null,"Indianapolis",33.5]
[null,null,"Inglewood",282.10000000000002]
[null,null,"Irvine",119.3]
[null,null,"Irving",121.5]
[null,null,"Jackson",167.7]
[null,null,"Jacksonville",32.4]
[null,null,"Jersey City",101.7]
[null,null,"Joliet",199.6]
[null,null,"Kansas City",59.900000000000098]
[null,null,"Kansas City",201.8]
[null,null,"Kenosha",332.7]
[null,null,"Kent",253.5]
[null,null,"Kildare",19.2]
[null,null,"Kilkenny",18.100000000000001]
[null,null,"Killeen",224.9]
[null,null,"Knoxville",160]
[null,null,"Lafayette",254.6]
[null,null,"Lakewood",208.4]
[null,null,"Lancaster",185.3]
[null,null,"Lansing",277.7]
[null,null,"Laredo",108.3]
[null,null,"Las Cruces",329.4]
[null,null,"Las Vegas",53.3]
[null,null,"Leitrim",28.3]
[null,null,"Letterkenny",27.7]
[null,null,"Lexington",87.400000000000105]
[null,null,"Limerick",32.200000000000003]
[null,null,"Lincoln",98.400000000000105]
[null,null,"Little Rock",149]
[null,null,"Long Beach",58.800000000000097]
[null,null,"Los Angeles",21.4]
[null,null,"Louisville",48.9]
[null,null,"Lowell",296.39999999999998]
[null,null,"Lubbock",111.6]
[null,null,"Madison",109.4]
[null,null,"Manchester",284.3]
[null,null,"McAllen",223.8]
[null,null,"McKinney",213.9]
[null,null,"Memphis",41.2]
[null,null,"Mesa",61.000000000000099]
[null,null,"Mesquite",215]
[null,null,"Miami",67.600000000000094]
[null,null,"Miami Gardens",283.2]
[null,null,"Midland",260.10000000000002]
[null,null,"Milwaukee",52.2]
[null,null,"Minneapolis",70.900000000000105]
[null,null,"Miramar",232.6]
[null,null,"Mobile",151.19999999999999]
[null,null,"Modesto",135.80000000000001]
[null,null,"Montgomery",134.69999999999999]
[null,null,"Moreno Valley",143.5]
[null,null,"Murfreesboro",276.60000000000002]
[null,null,"Murrieta",301.89999999999998]
[null,null,"Naperville",212.8]
[null,null,"Nashville",46.7]
[null,null,"New Haven",229.3]
[null,null,"New Orleans",75.300000000000097]
[null,null,"New York",20.3]
[null,null,"Newark",94.000000000000099]
[null,null,"Newport News",162.19999999999999]
[null,null,"Norfolk",106.1]
[null,null,"Norman",273.3]
[null,null,"North Charleston",322.8]
[null,null,"North Las Vegas",123.7]
[null,null,"Norwalk",307.39999999999998]
[null,null,"Oakland",68.700000000000102]
[null,null,"Oceanside",169.9]
[null,null,"Odessa",308.5]
[null,null,"Offaly",30.7]
[null,null,"Oklahoma City",51.1]
[null,null,"Olathe",231.5]
[null,null,"Omaha",66.500000000000099]
[null,null,"Ontario",176.5]
[null,null,"Orange",219.4]
[null,null,"Orlando",103.9]
[null,null,"Overland Park",165.5]
[null,null,"Oxnard",141.30000000000001]
[null,null,"Palm Bay",316.2]
[null,null,"Palmdale",190.8]
[null,null,"Pasadena",194.1]
[null,null,"Pasadena",221.6]
[null,null,"Paterson",210.6]
[null,null,"Pembroke Pines",182]
[null,null,"Peoria",184.2]
[null,null,"Peoria",272.2]
[null,null,"Philadelphia",24.7]
[null,null,"Phoenix",25.8]
[null,null,"Pittsburgh",86.300000000000097]
[null,null,"Plano",96.200000000000102]
[null,null,"Pomona",196.3]
[null,null,"Pompano Beach",320.60000000000002]
[null,null,"Port St. Lucie",175.4]
[null,null,"Portland",50]
[null,null,"Providence",166.6]
[null,null,"Provo",271.10000000000002]
[null,null,"Pueblo",297.5]
[null,null,"Raleigh",65.400000000000105]
[null,null,"Rancho Cucamonga",173.2]
[null,null,"Reno",117.1]
[null,null,"Rialto",323.89999999999998]
[null,null,"Richardson",319.5]
[null,null,"Richmond",131.4]
[null,null,"Richmond",305.2]
[null,null,"Riverside",84.100000000000094]
[null,null,"Rochester",130.30000000000001]
[null,null,"Rochester",293.10000000000002]
[null,null,"Rockford",195.2]
[null,null,"Roscommon",28.6]
[null,null,"Roseville",251.3]
[null,null,"Round Rock",304.10000000000002]
[null,null,"Sacramento",57.700000000000102]
[null,null,"Saint Paul",91.800000000000097]
[null,null,"Salem",189.7]
[null,null,"Salinas",191.9]
[null,null,"Salt Lake City",155.6]
[null,null,"San Antonio",26.9]
[null,null,"San Bernardino",127]
[null,null,"San Diego",28]
[null,null,"San Francisco",34.6]
[null,null,"San Jose",30.2]
[null,null,"Santa Ana",81.900000000000105]
[null,null,"Santa Clara",261.2]
[null,null,"Santa Clarita",164.4]
[null,null,"Santa Maria",325]
[null,null,"Santa Rosa",174.3]
[null,null,"Savannah",217.2]
[null,null,"Scottsdale",122.6]
[null,null,"Seattle",43.4]
[null,null,"Shreveport",139.1]
[null,null,"Simi Valley",243.6]
[null,null,"Sioux Falls",183.1]
[null,null,"South Bend",330.5]
[null,null,"Spokane",132.5]
[null,null,"Springfield",179.8]
[null,null,"Springfield",193]
[null,null,"Springfield",268.89999999999998]
[null,null,"St. Louis",83.000000000000099]
[null,null,"St. Petersburg",105]
[null,null,"Stamford",248]
[null,null,"Sterling Heights",230.4]
[null,null,"Stockton",89.600000000000094]
[null,null,"Sunnyvale",206.2]
[null,null,"Surprise",255.7]
[null,null,"Syracuse",211.7]
[null,null,"Tacoma",138]
[null,null,"Tallahassee",156.69999999999999]
[null,null,"Tampa",77.500000000000099]
[null,null,"Temecula",310.7]
[null,null,"Tempe",177.6]
[null,null,"Thornton",252.4]
[null,null,"Thousand Oaks",233.7]
[null,null,"Toledo",92.900000000000105]
[null,null,"Topeka",237]
[null,null,"Torrance",202.9]
[null,null,"Tralee",27.4]
[null,null,"Tuam",26.2]
[null,null,"Tucson",55.5]
[null,null,"Tullamore",31]
[null,null,"Tulsa",69.800000000000097]
[null,null,"Tulsk",28.9]
[null,null,"Tyrone",30.1]
[null,null,"Vallejo",266.7]
[null,null,"Vancouver",178.7]
[null,null,"Victorville",257.89999999999998]
[null,null,"Virginia Beach",62.100000000000101]
[null,null,"Visalia",238.1]
[null,null,"Waco",239.2]
[null,null,"Warren",226]
[null,null,"Washington",45.6]
[null,null,"Waterbury",287.60000000000002]
[null,null,"West Covina",299.7]
[null,null,"West Valley City",227.1]
[null,null,"Westminster",292]
[null,null,"Wichita",73.100000000000094]
[null,null,"Wichita Falls",314]
[null,null,"Wilmington",286.5]
[null,null,"Winston-Salem",112.7]
[null,null,"Worcester",158.9]
[null,null,"Yonkers",145]
[]
[null,null,"Totals "]

{"sheet":"task4data","index":6,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Commission Rate",0.05]

{"sheet":"Task 5","index":7,"n_rows":339,"n_cols":14,"rows_kept":339,"cut":false,"hidden":true,"merged":[[11,13,11,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Time taken  completing this task:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"After Clicking Finish - fill in these Answers."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q1","Bonus amount   for  Akron"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q2","Change the Bonus rate to 11% and the Bonus Breakpoint to $140 . What is  now the Bonus amount  for  Yonkers."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q3","Type your formula from E337 ( leave out = )"]
[]
[]
[]
[]
[null,null,"Bonus BreakPoint",250]
[null,null,"Bonus  Rate",7.0000000000000007E-2]
[]
[null,null,"City","Revenue","Bonus Amount"]
[null,null,"Abilene",264.5]
[null,null,"Akron",350]
[null,null,"Albuquerque",54.4]
[null,null,"Alexandria",205.1]
[null,null,"Allentown",263.39999999999998]
[null,null,"Amarillo",150.1]
[null,null,"Anaheim",79.700000000000102]
[null,null,"Anchorage",88.500000000000099]
[null,null,"Ann Arbor",270]
[null,null,"Antioch",309.60000000000002]
[null,null,"Antrim",29.5]
[null,null,"Arlington",74.200000000000102]
[null,null,"Arvada",289.8]
[null,null,"Athens",262.3]
[null,null,"Atlanta",63.200000000000102]
[null,null,"Augusta",147.9]
[null,null,"Aurora",80.800000000000097]
[null,null,"Aurora",142.4]
[null,null,"Austin",31.3]
[null,null,"Bakersfield",76.400000000000105]
[null,null,"Baltimore",47.8]
[null,null,"Baton Rouge",118.2]
[null,null,"Beaumont",265.60000000000002]
[null,null,"Belfast",25.6]
[null,null,"Bellevue",241.4]
[null,null,"Berkeley",274.39999999999998]
[null,null,"Billings",300.8]
[null,null,"Birmingham",129.19999999999999]
[null,null,"Boise",128.1]
[null,null,"Boston",42.3]
[null,null,"Bridgeport",204]
[null,null,"Broken Arrow",321.7]
[null,null,"Brownsville",163.30000000000001]
[null,null,"Buffalo",99.500000000000099]
[null,null,"Burbank",315.10000000000002]
[null,null,"Cahir",27.1]
[null,null,"Cambridge",306.3]
[null,null,"Cape Coral",180.9]
[null,null,"Carlsbad",290.89999999999998]
[null,null,"Carrollton",245.8]
[null,null,"Cary",207.3]
[null,null,"Cashel",25.9]
[null,null,"Cavan",28]
[null,null,"Cedar Rapids",235.9]
[null,null,"Centennial",317.3]
[null,null,"Chandler",107.2]
[null,null,"Charleston",244.7]
[null,null,"Charlotte",37.9]
[null,null,"Chattanooga",171]
[null,null,"Chesapeake",120.4]
[null,null,"Chicago",22.5]
[null,null,"Chula Vista",102.8]
[null,null,"Cincinnati",90.700000000000102]
[null,null,"Clarksville",216.1]
[null,null,"Clearwater",295.3]
[null,null,"Cleveland",72.000000000000099]
[null,null,"Clonmel",31.9]
[null,null,"Colorado Springs",64.300000000000097]
[null,null,"Columbia",228.2]
[null,null,"Columbia",278.8]
[null,null,"Columbus",35.700000000000003]
[null,null,"Columbus",146.80000000000001]
[null,null,"Concord",250.2]
[null,null,"Cong",17]
[null,null,"Coral Springs",246.9]
[null,null,"Cork",25.3]
[null,null,"Corona",187.5]
[null,null,"Corpus Christi",85.200000000000102]
[null,null,"Costa Mesa",281]
[null,null,"Dallas",29.1]
[null,null,"Daly City",318.39999999999998]
[null,null,"Davenport",327.2]
[null,null,"Dayton",218.3]
[null,null,"Denton",256.8]
[null,null,"Denver",44.5]
[null,null,"Derry",29.8]
[null,null,"Des Moines",133.6]
[null,null,"Detroit",39]
[null,null,"Downey",279.89999999999998]
[null,null,"Drogheda",26.5]
[null,null,"Drogheda",30.4]
[null,null,"Dublin",25]
[null,null,"dundrum",26.8]
[null,null,"Durham",110.5]
[null,null,"El Cajon",326.10000000000002]
[null,null,"El Monte",275.5]
[null,null,"El Paso",40.1]
[null,null,"Elgin",285.39999999999998]
[null,null,"Elizabeth",240.3]
[null,null,"Elk Grove",186.4]
[null,null,"Erie",328.3]
[null,null,"Escondido",200.7]
[null,null,"Eugene",188.6]
[null,null,"Evansville",259]
[null,null,"Everett",312.89999999999998]
[null,null,"Fairfield",298.60000000000002]
[null,null,"Fargo",288.7]
[null,null,"Fayetteville",136.9]
[null,null,"Flint",331.6]
[null,null,"Fontana",140.19999999999999]
[null,null,"Fort Collins",198.5]
[null,null,"Fort Lauderdale",172.1]
[null,null,"Fort Wayne",100.6]
[null,null,"Fort Worth",36.799999999999997]
[null,null,"Fremont",124.8]
[null,null,"Frenchpark",29.2]
[null,null,"Fresno",56.600000000000101]
[null,null,"Frisco",234.8]
[null,null,"Fullerton",220.5]
[null,null,"Gainesville",242.5]
[null,null,"Galway",32.5]
[null,null,"Garden Grove",168.8]
[null,null,"Garland",113.8]
[null,null,"Geashill",31.3]
[null,null,"Gilbert",125.9]
[null,null,"Glendale",114.9]
[null,null,"Glendale",153.4]
[null,null,"Golden",31.6]
[null,null,"Grand Prairie",161.1]
[null,null,"Grand Rapids",154.5]
[null,null,"Green Bay",311.8]
[null,null,"Greensboro",95.100000000000094]
[null,null,"Gresham",294.2]
[null,null,"Hampton",222.7]
[null,null,"Hartford",249.1]
[null,null,"Hayward",197.4]
[null,null,"Henderson",97.300000000000097]
[null,null,"Hialeah",116]
[null,null,"High Point",303]
[null,null,"Hollywood",209.5]
[null,null,"Honolulu",78.600000000000094]
[null,null,"Houston",23.6]
[null,null,"Huntington Beach",152.30000000000001]
[null,null,"Huntsville",157.80000000000001]
[null,null,"Independence",267.8]
[null,null,"Indianapolis",33.5]
[null,null,"Inglewood",282.10000000000002]
[null,null,"Irvine",119.3]
[null,null,"Irving",121.5]
[null,null,"Jackson",167.7]
[null,null,"Jacksonville",32.4]
[null,null,"Jersey City",101.7]
[null,null,"Joliet",199.6]
[null,null,"Kansas City",59.900000000000098]
[null,null,"Kansas City",201.8]
[null,null,"Kenosha",332.7]
[null,null,"Kent",253.5]
[null,null,"Kildare",19.2]
[null,null,"Kilkenny",18.100000000000001]
[null,null,"Killeen",224.9]
[null,null,"Knoxville",160]
[null,null,"Lafayette",254.6]
[null,null,"Lakewood",208.4]
[null,null,"Lancaster",185.3]
[null,null,"Lansing",277.7]
[null,null,"Laredo",108.3]
[null,null,"Las Cruces",329.4]
[null,null,"Las Vegas",53.3]
[null,null,"Leitrim",28.3]
[null,null,"Letterkenny",27.7]
[null,null,"Lexington",87.400000000000105]
[null,null,"Limerick",32.200000000000003]
[null,null,"Lincoln",98.400000000000105]
[null,null,"Little Rock",149]
[null,null,"Long Beach",58.800000000000097]
[null,null,"Los Angeles",21.4]
[null,null,"Louisville",48.9]
[null,null,"Lowell",296.39999999999998]
[null,null,"Lubbock",111.6]
[null,null,"Madison",109.4]
[null,null,"Manchester",284.3]
[null,null,"McAllen",223.8]
[null,null,"McKinney",213.9]
[null,null,"Memphis",41.2]
[null,null,"Mesa",61.000000000000099]
[null,null,"Mesquite",215]
[null,null,"Miami",67.600000000000094]
[null,null,"Miami Gardens",283.2]
[null,null,"Midland",260.10000000000002]
[null,null,"Milwaukee",52.2]
[null,null,"Minneapolis",70.900000000000105]
[null,null,"Miramar",232.6]
[null,null,"Mobile",151.19999999999999]
[null,null,"Modesto",135.80000000000001]
[null,null,"Montgomery",134.69999999999999]
[null,null,"Moreno Valley",143.5]
[null,null,"Murfreesboro",276.60000000000002]
[null,null,"Murrieta",301.89999999999998]
[null,null,"Naperville",212.8]
[null,null,"Nashville",46.7]
[null,null,"New Haven",229.3]
[null,null,"New Orleans",75.300000000000097]
[null,null,"New York",20.3]
[null,null,"Newark",94.000000000000099]
[null,null,"Newport News",162.19999999999999]
[null,null,"Norfolk",106.1]
[null,null,"Norman",273.3]
[null,null,"North Charleston",322.8]
[null,null,"North Las Vegas",123.7]
[null,null,"Norwalk",307.39999999999998]
[null,null,"Oakland",68.700000000000102]
[null,null,"Oceanside",169.9]
[null,null,"Odessa",308.5]
[null,null,"Offaly",30.7]
[null,null,"Oklahoma City",51.1]
[null,null,"Olathe",231.5]
[null,null,"Omaha",66.500000000000099]
[null,null,"Ontario",176.5]
[null,null,"Orange",219.4]
[null,null,"Orlando",103.9]
[null,null,"Overland Park",165.5]
[null,null,"Oxnard",141.30000000000001]
[null,null,"Palm Bay",316.2]
[null,null,"Palmdale",190.8]
[null,null,"Pasadena",194.1]
[null,null,"Pasadena",221.6]
[null,null,"Paterson",210.6]
[null,null,"Pembroke Pines",182]
[null,null,"Peoria",184.2]
[null,null,"Peoria",272.2]
[null,null,"Philadelphia",24.7]
[null,null,"Phoenix",25.8]
[null,null,"Pittsburgh",86.300000000000097]
[null,null,"Plano",96.200000000000102]
[null,null,"Pomona",196.3]
[null,null,"Pompano Beach",320.60000000000002]
[null,null,"Port St. Lucie",175.4]
[null,null,"Portland",50]
[null,null,"Providence",166.6]
[null,null,"Provo",271.10000000000002]
[null,null,"Pueblo",297.5]
[null,null,"Raleigh",65.400000000000105]
[null,null,"Rancho Cucamonga",173.2]
[null,null,"Reno",117.1]
[null,null,"Rialto",323.89999999999998]
[null,null,"Richardson",319.5]
[null,null,"Richmond",131.4]
[null,null,"Richmond",305.2]
[null,null,"Riverside",84.100000000000094]
[null,null,"Rochester",130.30000000000001]
[null,null,"Rochester",293.10000000000002]
[null,null,"Rockford",195.2]
[null,null,"Roscommon",28.6]
[null,null,"Roseville",251.3]
[null,null,"Round Rock",304.10000000000002]
[null,null,"Sacramento",57.700000000000102]
[null,null,"Saint Paul",91.800000000000097]
[null,null,"Salem",189.7]
[null,null,"Salinas",191.9]
[null,null,"Salt Lake City",155.6]
[null,null,"San Antonio",26.9]
[null,null,"San Bernardino",127]
[null,null,"San Diego",28]
[null,null,"San Francisco",34.6]
[null,null,"San Jose",30.2]
[null,null,"Santa Ana",81.900000000000105]
[null,null,"Santa Clara",261.2]
[null,null,"Santa Clarita",164.4]
[null,null,"Santa Maria",325]
[null,null,"Santa Rosa",174.3]
[null,null,"Savannah",217.2]
[null,null,"Scottsdale",122.6]
[null,null,"Seattle",43.4]
[null,null,"Shreveport",139.1]
[null,null,"Simi Valley",243.6]
[null,null,"Sioux Falls",183.1]
[null,null,"South Bend",330.5]
[null,null,"Spokane",132.5]
[null,null,"Springfield",179.8]
[null,null,"Springfield",193]
[null,null,"Springfield",268.89999999999998]
[null,null,"St. Louis",83.000000000000099]
[null,null,"St. Petersburg",105]
[null,null,"Stamford",248]
[null,null,"Sterling Heights",230.4]
[null,null,"Stockton",89.600000000000094]
[null,null,"Sunnyvale",206.2]
[null,null,"Surprise",255.7]
[null,null,"Syracuse",211.7]
[null,null,"Tacoma",138]
[null,null,"Tallahassee",156.69999999999999]
[null,null,"Tampa",77.500000000000099]
[null,null,"Temecula",310.7]
[null,null,"Tempe",177.6]
[null,null,"Thornton",252.4]
[null,null,"Thousand Oaks",233.7]
[null,null,"Toledo",92.900000000000105]
[null,null,"Topeka",237]
[null,null,"Torrance",202.9]
[null,null,"Tralee",27.4]
[null,null,"Tuam",26.2]
[null,null,"Tucson",55.5]
[null,null,"Tullamore",31]
[null,null,"Tulsa",69.800000000000097]
[null,null,"Tulsk",28.9]
[null,null,"Tyrone",30.1]
[null,null,"Vallejo",266.7]
[null,null,"Vancouver",178.7]
[null,null,"Victorville",257.89999999999998]
[null,null,"Virginia Beach",62.100000000000101]
[null,null,"Visalia",238.1]
[null,null,"Waco",239.2]
[null,null,"Warren",226]
[null,null,"Washington",45.6]
[null,null,"Waterbury",287.60000000000002]
[null,null,"West Covina",299.7]
[null,null,"West Valley City",227.1]
[null,null,"Westminster",292]
[null,null,"Wichita",73.100000000000094]
[null,null,"Wichita Falls",314]
[null,null,"Wilmington",286.5]
[null,null,"Winston-Salem",112.7]
[null,null,"Worcester",158.9]
[null,null,"Yonkers",145]
[]
[null,null,"Totals "]

{"sheet":"Task 6","index":8,"n_rows":339,"n_cols":14,"rows_kept":339,"cut":false,"hidden":true,"merged":[[11,13,11,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Time  taken completing this  task."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"After Clicking Finish -  fill in these Answers."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q1","What value is in N32"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q2","What value is in N119"]
[]
[]
[]
[]
[]
[null,null,"sku","Description","Price",null,null,null,null,null,null,"Item","Qty","Descriptions"]
[null,null,"BG33-17","14K Gold Bangle Bracelet with Star Design ",4,null,null,null,null,null,null,"W25-6",580]
[null,null,"BG33-3","14K Gold Bangle Bracelet with Vine Design ",1.1000000000000001,null,null,null,null,null,null,"Cross50-5",422]
[null,null,"BG33-8","14K Gold Bangle Bracelet with Star Design ",1.8,null,null,null,null,null,null,"RG78-25",638]
[null,null,"BR15-3","14K Gold Onyx Men's Bracelet ",1.7,null,null,null,null,null,null,"BG33-8",775]
[null,null,"BR26-3","18K Italian Gold Men's Bracelet ",1.6,null,null,null,null,null,null,"BG33-8",331]
[null,null,"CR 50-4","14K Gold Onyx Cross ",2,null,null,null,null,null,null,"ER46-7",140]
[null,null,"CR50-1","14K Gold Onyx Cross ",2.2000000000000002,null,null,null,null,null,null,"RG75-3",231]
[null,null,"CR50-2","14K Gold Onyx Cross ",2.1,null,null,null,null,null,null,"W25-6",878]
[null,null,"CR50-3","14K Gold Cross with Onyx ",1.2,null,null,null,null,null,null,"CR50-6",571]
[null,null,"CR50-6","14K Gold Onyx Cross with White Cubic Zirconia Stones ",2.4,null,null,null,null,null,null,"ER41-4",208]
[null,null,"Cross50-5","14K Gold Onyx Cross with White Cubic Zirconia Stones ",2.2999999999999998,null,null,null,null,null,null,"ER41-4",429]
[null,null,"ER 46-33","14K Gold Hollow Earrings ",3.1,null,null,null,null,null,null,"CR50-1",832]
[null,null,"ER41-4","14K Gold Swiss Cut Earrings ",2.5,null,null,null,null,null,null,"CR50-3",159]
[null,null,"ER46-14","14K Gold Fish Hoop Earrings ",2.6,null,null,null,null,null,null,"BG33-3",546]
[null,null,"ER46-22","14K Gold Hoop Earrings ",2.8,null,null,null,null,null,null,"BG33-3",115]
[null,null,"ER46-28","14K Gold Earrings ",2.9,null,null,null,null,null,null,"Cross50-5",467]
[null,null,"ER46-29","14K Gold Hoop Earrings ",3,null,null,null,null,null,null,"BR26-3",233]
[null,null,"ER46-7","14K Gold Hollow Earrings ",2.7,null,null,null,null,null,null,"BG33-8",287]
[null,null,"ER49-20","14K Gold Hoop/Tube Earrings ",3.2,null,null,null,null,null,null,"ER46-7",113]
[null,null,"ER49-21","14K Gold Hoop/Tube Earrings ",3.3,null,null,null,null,null,null,"Cross50-5",621]
[null,null,"ER49-22","14K Gold Tube/Hoop Earrings ",3.4,null,null,null,null,null,null,"CR50-2",441]
[null,null,"ER80-63","14K Gold Ruby Colored Cubic Zirconia Earrings ",3.5,null,null,null,null,null,null,"ER46-28",221]
[null,null,"ER89-47","14K Gold Two-Tone Rose Earrings ",3.6,null,null,null,null,null,null,"ER46-22",688]
[null,null,"P330","14K Gold Eagle Pendant ",3.8,null,null,null,null,null,null,"RG78-25",233]
[null,null,"P411A","14K Gold Lion Pendant ",3.7,null,null,null,null,null,null,"ER46-28",344]
[null,null,"RG75-3","14K Gold RAY OF LIGHT Onyx Men's Ring (Men's Rings) ",1.3,null,null,null,null,null,null,"ER46-14",740]
[null,null,"RG78-25","14K Gold Ballerina Ring w/ Blue & White CZs (Women's Rings, CZ Rings) ",1.4,null,null,null,null,null,null,"BG33-3",328]
[null,null,"vvvvvvv","v gold brac",2.6,null,null,null,null,null,null,"CR50-6",351]
[null,null,"W25-6","18K Italian Gold Women's Watch ",1.5,null,null,null,null,null,null,"ER46-28",673]
[null,null,null,null,null,null,null,null,null,null,null,"Cross50-5",379]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-1",833]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-7",244]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-29",199]
[null,null,null,null,null,null,null,null,null,null,null,"RG75-3",304]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-1",264]
[null,null,null,null,null,null,null,null,null,null,null,"BR26-3",476]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-6",151]
[null,null,null,null,null,null,null,null,null,null,null,"BG33-8",429]
[null,null,null,null,null,null,null,null,null,null,null,"CR 50-4",612]
[null,null,null,null,null,null,null,null,null,null,null,"RG75-3",741]
[null,null,null,null,null,null,null,null,null,null,null,"W25-6",581]
[null,null,null,null,null,null,null,null,null,null,null,"RG75-3",735]
[null,null,null,null,null,null,null,null,null,null,null,"CR 50-4",213]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-22",100]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-3",576]
[null,null,null,null,null,null,null,null,null,null,null,"ER41-4",229]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-1",181]
[null,null,null,null,null,null,null,null,null,null,null,"BG33-8",508]
[null,null,null,null,null,null,null,null,null,null,null,"BG33-8",298]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-6",236]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-22",281]
[null,null,null,null,null,null,null,null,null,null,null,"ER41-4",374]
[null,null,null,null,null,null,null,null,null,null,null,"RG75-3",852]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-28",806]
[null,null,null,null,null,null,null,null,null,null,null,"BR26-3",737]
[null,null,null,null,null,null,null,null,null,null,null,"BR15-3",347]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-14",471]
[null,null,null,null,null,null,null,null,null,null,null,"RG78-25",460]
[null,null,null,null,null,null,null,null,null,null,null,"W25-6",254]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-3",801]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-2",216]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-2",603]
[null,null,null,null,null,null,null,null,null,null,null,"BR26-3",541]
[null,null,null,null,null,null,null,null,null,null,null,"RG75-3",899]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-2",686]
[null,null,null,null,null,null,null,null,null,null,null,"BG33-3",662]
[null,null,null,null,null,null,null,null,null,null,null,"BR26-3",849]
[null,null,null,null,null,null,null,null,null,null,null,"BG33-3",213]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-1",631]
[null,null,null,null,null,null,null,null,null,null,null,"BG33-3",737]
[null,null,null,null,null,null,null,null,null,null,null,"RG75-3",511]
[null,null,null,null,null,null,null,null,null,null,null,"BG33-17",530]
[null,null,null,null,null,null,null,null,null,null,null,"RG75-3",626]
[null,null,null,null,null,null,null,null,null,null,null,"CR 50-4",671]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-22",595]
[null,null,null,null,null,null,null,null,null,null,null,"BG33-3",842]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-22",198]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-6",192]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-28",442]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-22",267]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-22",545]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-3",406]
[null,null,null,null,null,null,null,null,null,null,null,"BG33-8",366]
[null,null,null,null,null,null,null,null,null,null,null,"CR 50-4",802]
[null,null,null,null,null,null,null,null,null,null,null,"BR26-3",881]
[null,null,null,null,null,null,null,null,null,null,null,"CR 50-4",718]
[null,null,null,null,null,null,null,null,null,null,null,"BR26-3",169]
[null,null,null,null,null,null,null,null,null,null,null,"CR 50-4",744]
[null,null,null,null,null,null,null,null,null,null,null,"Cross50-5",871]
[null,null,null,null,null,null,null,null,null,null,null,"W25-6",832]
[null,null,null,null,null,null,null,null,null,null,null,"BR15-3",817]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-29",825]
[null,null,null,null,null,null,null,null,null,null,null,"Cross50-5",823]
[null,null,null,null,null,null,null,null,null,null,null,"CR50-6",822]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-14",384]
[null,null,null,null,null,null,null,null,null,null,null,"ER41-4",311]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-22",380]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-14",316]
[null,null,null,null,null,null,null,null,null,null,null,"ER46-28",623]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Totals "]

{"sheet":"Task 7","index":9,"n_rows":917,"n_cols":15,"rows_kept":917,"cut":false,"hidden":true,"merged":[[11,13,11,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," Time taken to complete this task:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"After Clicking Finish or Timed out  fill in these Answers."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q1","What value is in cell P19"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q2","What value is in P20"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Q3","Change the value in O19 to Madonna, now what value is in P19"]
[]
[]
[]
[null,null,"Number","Singer","Minutes",null,null,null,null,null,null,null,null,"How many times was U2 Played","U2"]
[null,null,1,"Eminem",4,null,null,null,null,null,null,null,null,"Total number  of minutes U2 was played.","U2"]
[null,null,2,"Eminem",2]
[null,null,3,"U2",2]
[null,null,4,"Eminem",4]
[null,null,5,"Moore",2]
[null,null,6,"U2",4]
[null,null,7,"Spears",3]
[null,null,8,"Spears",3]
[null,null,9,"Manilow",4]
[null,null,10,"Eminem",4]
[null,null,11,"Madonna",3]
[null,null,12,"Eminem",4]
[null,null,13,"Springsteen",2]
[null,null,14,"Spears",4]
[null,null,15,"Moore",3]
[null,null,16,"Madonna",4]
[null,null,17,"Spears",3]
[null,null,18,"Mellencamp",5]
[null,null,19,"Spears",5]
[null,null,20,"Madonna",4]
[null,null,21,"Springsteen",3]
[null,null,22,"Madonna",3]
[null,null,23,"Madonna",3]
[null,null,24,"U2",5]
[null,null,25,"U2",2]
[null,null,26,"U2",5]
[null,null,27,"Eminem",3]
[null,null,28,"Springsteen",3]
[null,null,29,"Madonna",5]
[null,null,30,"Manilow",4]
[null,null,31,"U2",5]
[null,null,32,"Eminem",5]
[null,null,33,"Springsteen",4]
[null,null,34,"Spears",3]
[null,null,35,"Manilow",3]
[null,null,36,"Moore",5]
[null,null,37,"Mellencamp",4]
[null,null,38,"Springsteen",3]
[null,null,39,"Manilow",2]
[null,null,40,"Manilow",4]
[null,null,41,"Springsteen",3]
[null,null,42,"Spears",3]
[null,null,43,"Springsteen",2]
[null,null,44,"Mellencamp",4]
[null,null,45,"Moore",4]
[null,null,46,"Moore",2]
[null,null,47,"Eminem",2]
[null,null,48,"U2",3]
[null,null,49,"Moore",4]
[null,null,50,"Madonna",5]
[null,null,51,"Manilow",4]
[null,null,52,"Madonna",2]
[null,null,53,"U2",4]
[null,null,54,"Eminem",4]
[null,null,55,"Madonna",2]
[null,null,56,"Moore",5]
[null,null,57,"U2",2]
[null,null,58,"Spears",3]
[null,null,59,"Spears",3]
[null,null,60,"Mellencamp",3]
[null,null,61,"U2",5]
[null,null,62,"Manilow",3]
[null,null,63,"Spears",4]
[null,null,64,"Spears",3]
[null,null,65,"Eminem",3]
[null,null,66,"Eminem",3]
[null,null,67,"Moore",3]
[null,null,68,"Springsteen",2]
[null,null,69,"U2",3]
[null,null,70,"Madonna",4]
[null,null,71,"Mellencamp",2]
[null,null,72,"Madonna",3]
[null,null,73,"Eminem",4]
[null,null,74,"Moore",3]
[null,null,75,"Manilow",5]
[null,null,76,"Spears",2]
[null,null,77,"Eminem",4]
[null,null,78,"Springsteen",2]
[null,null,79,"Mellencamp",2]
[null,null,80,"Moore",2]
[null,null,81,"Springsteen",3]
[null,null,82,"U2",5]
[null,null,83,"Springsteen",2]
[null,null,84,"U2",4]
[null,null,85,"Springsteen",2]
[null,null,86,"Spears",3]
[null,null,87,"Spears",5]
[null,null,88,"Madonna",4]
[null,null,89,"U2",2]
[null,null,90,"Eminem",3]
[null,null,91,"Moore",2]
[null,null,92,"Mellencamp",4]
[null,null,93,"Springsteen",4]
[null,null,94,"Eminem",3]
[null,null,95,"Springsteen",4]
[null,null,96,"Manilow",3]
[null,null,97,"Manilow",5]
[null,null,98,"Eminem",5]
[null,null,99,"Manilow",5]
[null,null,100,"Springsteen",3]
[null,null,101,"Manilow",2]
[null,null,102,"U2",4]
[null,null,103,"U2",2]
[null,null,104,"Spears",2]
[null,null,105,"Mellencamp",3]
[null,null,106,"Mellencamp",5]
[null,null,107,"Madonna",4]
[null,null,108,"Moore",4]
[null,null,109,"Manilow",5]
[null,null,110,"Mellencamp",3]
[null,null,111,"Manilow",2]
[null,null,112,"Madonna",3]
[null,null,113,"Springsteen",3]
[null,null,114,"Madonna",2]
[null,null,115,"Mellencamp",5]
[null,null,116,"Eminem",3]
[null,null,117,"Mellencamp",2]
[null,null,118,"U2",4]
[null,null,119,"Mellencamp",3]
[null,null,120,"Spears",4]
[null,null,121,"U2",4]
[null,null,122,"Springsteen",5]
[null,null,123,"U2",4]
[null,null,124,"Madonna",3]
[null,null,125,"U2",3]
[null,null,126,"Manilow",3]
[null,null,127,"Manilow",4]
[null,null,128,"Eminem",4]
[null,null,129,"Moore",4]
[null,null,130,"Manilow",2]
[null,null,131,"Madonna",5]
[null,null,132,"U2",3]
[null,null,133,"Moore",2]
[null,null,134,"Eminem",5]
[null,null,135,"U2",5]
[null,null,136,"Madonna",4]
[null,null,137,"Madonna",3]
[null,null,138,"Mellencamp",5]
[null,null,139,"Eminem",2]
[null,null,140,"Spears",2]
[null,null,141,"Moore",3]
[null,null,142,"U2",2]
[null,null,143,"Moore",4]
[null,null,144,"U2",4]
[null,null,145,"Eminem",3]
[null,null,146,"Spears",3]
[null,null,147,"Moore",4]
[null,null,148,"Manilow",3]
[null,null,149,"Springsteen",5]
[null,null,150,"Mellencamp",2]
[null,null,151,"U2",3]
[null,null,152,"Spears",4]
[null,null,153,"Manilow",3]
[null,null,154,"Mellencamp",4]
[null,null,155,"Manilow",4]
[null,null,156,"U2",3]
[null,null,157,"Mellencamp",4]
[null,null,158,"Manilow",5]
[null,null,159,"Madonna",4]
[null,null,160,"Madonna",4]
[null,null,161,"Eminem",4]
[null,null,162,"Eminem",4]
[null,null,163,"Eminem",4]
[null,null,164,"Moore",4]
[null,null,165,"Madonna",3]
[null,null,166,"Eminem",4]
[null,null,167,"Manilow",3]
[null,null,168,"Spears",2]
[null,null,169,"Eminem",2]
[null,null,170,"Spears",4]
[null,null,171,"Springsteen",4]
[null,null,172,"Moore",4]
[null,null,173,"Spears",4]
[null,null,174,"Manilow",5]
[null,null,175,"Madonna",2]
[null,null,176,"Spears",5]
[null,null,177,"Manilow",5]
[null,null,178,"U2",3]
[null,null,179,"U2",4]
[null,null,180,"Springsteen",3]
[null,null,181,"Springsteen",2]
[null,null,182,"Madonna",5]
[null,null,183,"Mellencamp",2]
[null,null,184,"U2",3]
[null,null,185,"Mellencamp",5]
[null,null,186,"Eminem",5]
[null,null,187,"Springsteen",2]
[null,null,188,"Madonna",3]
[null,null,189,"Moore",2]
[null,null,190,"Spears",5]
[null,null,191,"Madonna",4]
[null,null,192,"Manilow",4]
[null,null,193,"Moore",4]
[null,null,194,"Manilow",3]
[null,null,195,"Eminem",4]
[null,null,196,"Spears",2]
[null,null,197,"Eminem",4]
[null,null,198,"Moore",3]
[null,null,199,"Mellencamp",3]
[null,null,200,"Eminem",2]
[null,null,201,"Moore",5]
[null,null,202,"Manilow",2]
[null,null,203,"Eminem",4]
[null,null,204,"Mellencamp",4]
[null,null,205,"Mellencamp",4]
[null,null,206,"Eminem",3]
[null,null,207,"Spears",4]
[null,null,208,"U2",4]
[null,null,209,"Manilow",4]
[null,null,210,"Madonna",3]
[null,null,211,"Mellencamp",5]
[null,null,212,"Spears",4]
[null,null,213,"Moore",4]
[null,null,214,"Moore",5]
[null,null,215,"Manilow",5]
[null,null,216,"Spears",5]
[null,null,217,"Eminem",5]
[null,null,218,"Spears",4]
[null,null,219,"Manilow",5]
[null,null,220,"Moore",3]
[null,null,221,"U2",2]
[null,null,222,"Spears",3]
[null,null,223,"Eminem",5]
[null,null,224,"Moore",4]
[null,null,225,"Madonna",2]
[null,null,226,"Spears",5]
[null,null,227,"Spears",3]
[null,null,228,"Moore",4]
[null,null,229,"Springsteen",2]
[null,null,230,"Mellencamp",5]
[null,null,231,"Madonna",4]
[null,null,232,"Manilow",4]
[null,null,233,"Mellencamp",3]
[null,null,234,"Spears",3]
[null,null,235,"Springsteen",3]
[null,null,236,"U2",5]
[null,null,237,"Moore",3]
[null,null,238,"Eminem",2]
[null,null,239,"Madonna",4]
[null,null,240,"Spears",2]
[null,null,241,"U2",2]
[null,null,242,"Spears",3]
[null,null,243,"Madonna",5]
[null,null,244,"Madonna",3]
[null,null,245,"Madonna",2]
[null,null,246,"U2",4]
[null,null,247,"Spears",3]
[null,null,248,"Madonna",2]
[null,null,249,"Springsteen",3]
[null,null,250,"U2",3]
[null,null,251,"Moore",5]
[null,null,252,"U2",2]
[null,null,253,"Mellencamp",5]
[null,null,254,"Spears",2]
[null,null,255,"Moore",2]
[null,null,256,"U2",2]
[null,null,257,"Manilow",5]
[null,null,258,"Springsteen",3]
[null,null,259,"Eminem",3]
[null,null,260,"Madonna",2]
[null,null,261,"Spears",5]
[null,null,262,"Spears",4]
[null,null,263,"Manilow",4]
[null,null,264,"Springsteen",5]
[null,null,265,"Manilow",4]
[null,null,266,"Madonna",5]
[null,null,267,"Mellencamp",2]
[null,null,268,"Madonna",4]
[null,null,269,"U2",4]
[null,null,270,"Eminem",5]
[null,null,271,"Manilow",4]
[null,null,272,"Eminem",2]
[null,null,273,"U2",4]
[null,null,274,"Manilow",4]
[null,null,275,"Springsteen",5]
[null,null,276,"Moore",3]
[null,null,277,"Spears",5]
[null,null,278,"Moore",4]
[null,null,279,"Mellencamp",3]
[null,null,280,"Spears",4]
[null,null,281,"Moore",5]
[null,null,282,"Moore",3]
[null,null,283,"Manilow",4]
[null,null,284,"Moore",3]
[null,null,285,"Moore",3]
[null,null,286,"Mellencamp",2]
[null,null,287,"Madonna",2]
[null,null,288,"U2",5]
[null,null,289,"Madonna",2]
[null,null,290,"Spears",4]
[null,null,291,"Madonna",4]
[null,null,292,"U2",2]
[null,null,293,"Springsteen",4]
[null,null,294,"Springsteen",3]
[null,null,295,"Madonna",4]
[null,null,296,"Mellencamp",3]
[null,null,297,"Mellencamp",3]
[null,null,298,"Spears",3]
[null,null,299,"U2",2]
[null,null,300,"Moore",2]
[null,null,301,"Moore",5]
[null,null,302,"Moore",3]
[null,null,303,"Eminem",5]
[null,null,304,"Moore",2]
[null,null,305,"U2",5]
[null,null,306,"Spears",3]
[null,null,307,"U2",2]
[null,null,308,"Springsteen",4]
[null,null,309,"Manilow",5]
[null,null,310,"Manilow",3]
[null,null,311,"Spears",2]
[null,null,312,"Manilow",5]
[null,null,313,"Eminem",5]
[null,null,314,"Springsteen",2]
[null,null,315,"Springsteen",4]
[null,null,316,"Springsteen",4]
[null,null,317,"Springsteen",2]
[null,null,318,"Moore",5]
[null,null,319,"U2",4]
[null,null,320,"Eminem",4]
[null,null,321,"U2",5]
[null,null,322,"Mellencamp",3]
[null,null,323,"Spears",4]
[null,null,324,"Mellencamp",3]
[null,null,325,"Mellencamp",5]
[null,null,326,"Eminem",2]
[null,null,327,"Moore",4]
[null,null,328,"Moore",5]
[null,null,329,"Eminem",4]
[null,null,330,"Mellencamp",3]
[null,null,331,"Manilow",5]
[null,null,332,"Spears",4]
[null,null,333,"Madonna",3]
[null,null,335,"Spears",3]
[null,null,336,"U2",2]
[null,null,337,"U2",2]
[null,null,338,"Madonna",5]
[null,null,339,"Spears",4]
[null,null,340,"Eminem",5]
[null,null,341,"U2",4]
[null,null,342,"Moore",2]
[null,null,343,"Madonna",2]
[null,null,344,"U2",4]
[null,null,345,"Madonna",3]
[null,null,346,"Eminem",5]
[null,null,347,"Moore",5]
[null,null,348,"Madonna",5]
[null,null,349,"Mellencamp",2]
[null,null,350,"Eminem",4]
[null,null,351,"U2",3]
[null,null,352,"Madonna",3]
[null,null,353,"Madonna",2]
[null,null,354,"Moore",4]
[null,null,355,"Mellencamp",5]
[null,null,356,"U2",2]
[null,null,357,"Springsteen",3]
[null,null,358,"Eminem",3]
[null,null,359,"Springsteen",2]
[null,null,360,"U2",3]
[null,null,361,"Madonna",2]
[null,null,362,"Spears",5]
[null,null,363,"Moore",5]
[null,null,364,"Madonna",4]
[null,null,365,"Manilow",5]
[null,null,366,"Eminem",2]
[null,null,367,"Manilow",4]
[null,null,368,"Moore",3]
[null,null,369,"Moore",2]
[null,null,370,"U2",2]
[null,null,371,"Madonna",2]
[null,null,372,"Spears",5]
[null,null,373,"Manilow",4]
[null,null,374,"U2",2]
[null,null,375,"Moore",5]
[null,null,376,"Springsteen",2]
[null,null,377,"U2",2]
[null,null,378,"Madonna",3]
[null,null,379,"Moore",4]
[null,null,380,"Mellencamp",5]
[null,null,381,"Springsteen",5]
[null,null,382,"Eminem",5]
[null,null,383,"U2",5]
[null,null,384,"Madonna",3]
[null,null,385,"Springsteen",3]
[null,null,386,"Mellencamp",3]
[null,null,387,"Mellencamp",2]
[null,null,388,"Madonna",2]
[null,null,389,"Mellencamp",2]
[null,null,390,"U2",5]
[null,null,391,"Spears",3]
[null,null,392,"Madonna",2]
[null,null,393,"Eminem",2]
[null,null,394,"Spears",2]
[null,null,395,"Springsteen",2]
[null,null,396,"Spears",2]
[null,null,397,"Spears",3]
[null,null,398,"Mellencamp",5]
[null,null,399,"Madonna",4]
[null,null,400,"Spears",5]
[null,null,401,"Eminem",3]
[null,null,402,"Madonna",5]
[null,null,403,"Spears",3]
[null,null,404,"Madonna",2]
[null,null,405,"Madonna",2]
[null,null,406,"Moore",5]
[null,null,407,"Mellencamp",2]
[null,null,408,"Moore",4]
[null,null,409,"Mellencamp",5]
[null,null,410,"Mellencamp",4]
[null,null,411,"Eminem",3]
[null,null,412,"Eminem",3]
[null,null,413,"U2",2]
[null,null,414,"Mellencamp",5]
[null,null,415,"Mellencamp",4]
[null,null,416,"Moore",3]
[null,null,417,"Moore",2]
[null,null,418,"Spears",5]
[null,null,419,"Manilow",5]
[null,null,420,"Madonna",4]
[null,null,421,"U2",3]
[null,null,422,"Eminem",2]
[null,null,423,"Spears",3]
[null,null,424,"Springsteen",3]
[null,null,425,"Eminem",4]
[null,null,426,"Springsteen",3]
[null,null,427,"Madonna",2]
[null,null,428,"Springsteen",2]
[null,null,429,"Moore",4]
[null,null,430,"Moore",5]
[null,null,431,"Mellencamp",3]
[null,null,432,"Manilow",5]
[null,null,433,"Moore",4]
[null,null,434,"Moore",3]
[null,null,435,"Springsteen",2]
[null,null,436,"Manilow",5]
[null,null,437,"Manilow",2]
[null,null,438,"Moore",2]
[null,null,439,"Moore",4]
[null,null,440,"Springsteen",4]
[null,null,441,"Springsteen",3]
[null,null,442,"Eminem",2]
[null,null,443,"Madonna",5]
[null,null,444,"Mellencamp",5]
[null,null,445,"Springsteen",2]
[null,null,446,"Eminem",3]
[null,null,447,"Spears",4]
[null,null,448,"Mellencamp",5]
[null,null,449,"Springsteen",2]
[null,null,450,"Eminem",5]
[null,null,451,"Madonna",2]
[null,null,452,"Spears",3]
[null,null,453,"Moore",5]
[null,null,454,"Eminem",4]
[null,null,455,"Manilow",3]
[null,null,456,"Eminem",4]
[null,null,457,"Spears",3]
[null,null,458,"Moore",2]
[null,null,459,"Manilow",5]
[null,null,460,"Madonna",4]
[null,null,461,"Eminem",4]
[null,null,462,"U2",5]
[null,null,463,"U2",2]
[null,null,464,"Springsteen",2]
[null,null,465,"Mellencamp",4]
[null,null,466,"Madonna",2]
[null,null,467,"Moore",3]
[null,null,468,"U2",5]
[null,null,469,"Spears",5]
[null,null,470,"U2",2]
[null,null,471,"Eminem",2]
[null,null,472,"Eminem",2]
[null,null,473,"Moore",2]
[null,null,474,"Manilow",3]
[null,null,475,"Spears",5]
[null,null,476,"Moore",3]
[null,null,477,"Mellencamp",2]
[null,null,478,"Moore",2]
[null,null,479,"Madonna",4]
[null,null,480,"Eminem",3]
[null,null,481,"U2",4]
[null,null,482,"U2",2]
[null,null,483,"Spears",3]
[null,null,484,"Madonna",5]
[null,null,485,"Mellencamp",4]
[null,null,486,"Eminem",5]
[null,null,487,"Springsteen",2]
[null,null,488,"Madonna",2]
[null,null,489,"Spears",4]
[null,null,490,"Mellencamp",4]
[null,null,491,"Manilow",2]
[null,null,492,"Madonna",3]
[null,null,493,"Moore",3]
[null,null,494,"Madonna",3]
[null,null,495,"U2",3]
[null,null,496,"Madonna",2]
[null,null,497,"Mellencamp",3]
[null,null,498,"Spears",4]
[null,null,499,"Manilow",5]
[null,null,500,"Madonna",5]
[null,null,501,"Springsteen",3]
[null,null,502,"Springsteen",5]
[null,null,503,"Eminem",5]
[null,null,504,"Spears",5]
[null,null,505,"Spears",2]
[null,null,506,"Madonna",4]
[null,null,507,"Spears",4]
[null,null,508,"Mellencamp",4]
[null,null,509,"Springsteen",2]
[null,null,510,"Madonna",2]
[null,null,511,"Moore",5]
[null,null,512,"Moore",2]
[null,null,513,"Eminem",5]
[null,null,514,"U2",3]
[null,null,515,"Moore",4]
[null,null,516,"Mellencamp",3]
[null,null,517,"Spears",5]
[null,null,518,"Moore",4]
[null,null,519,"U2",3]
[null,null,520,"Mellencamp",4]
[null,null,521,"Mellencamp",3]
[null,null,522,"Madonna",5]
[null,null,523,"Mellencamp",5]
[null,null,524,"Spears",3]
[null,null,525,"Spears",3]
[null,null,526,"Madonna",5]
[null,null,527,"Mellencamp",5]
[null,null,528,"Moore",2]
[null,null,529,"Madonna",2]
[null,null,530,"Spears",3]
[null,null,531,"Moore",5]
[null,null,532,"Moore",4]
[null,null,533,"Madonna",5]
[null,null,534,"Mellencamp",2]
[null,null,535,"Eminem",2]
[null,null,536,"Spears",4]
[null,null,537,"Eminem",5]
[null,null,538,"Springsteen",4]
[null,null,539,"Mellencamp",2]
[null,null,540,"Moore",4]
[null,null,541,"Manilow",3]
[null,null,542,"Madonna",5]
[null,null,543,"Spears",2]
[null,null,544,"Mellencamp",5]
[null,null,545,"Mellencamp",3]
[null,null,546,"Mellencamp",5]
[null,null,547,"Springsteen",5]
[null,null,548,"U2",5]
[null,null,549,"Eminem",4]
[null,null,550,"Spears",2]
[null,null,551,"U2",3]
[null,null,552,"Manilow",5]
[null,null,554,"Spears",2]
[null,null,555,"Manilow",3]
[null,null,556,"Moore",5]
[null,null,557,"Springsteen",4]
[null,null,558,"Springsteen",2]
[null,null,559,"Moore",3]
[null,null,560,"Madonna",4]
[null,null,561,"Eminem",5]
[null,null,562,"Spears",2]
[null,null,563,"Eminem",5]
[null,null,564,"Eminem",3]
[null,null,565,"Spears",3]
[null,null,566,"Eminem",5]
[null,null,567,"Mellencamp",3]
[null,null,568,"Spears",4]
[null,null,569,"Moore",4]
[null,null,570,"Springsteen",5]
[null,null,571,"Mellencamp",5]
[null,null,572,"Moore",2]
[null,null,573,"Springsteen",2]
[null,null,574,"Mellencamp",4]
[null,null,575,"Mellencamp",5]
[null,null,576,"Mellencamp",3]
[null,null,577,"Manilow",3]
[null,null,578,"Moore",5]
[null,null,579,"Manilow",4]
[null,null,580,"Madonna",3]
[null,null,581,"Manilow",2]
[null,null,582,"Madonna",3]
[null,null,583,"Manilow",2]
[null,null,584,"Mellencamp",3]
[null,null,585,"Spears",5]
[null,null,586,"Mellencamp",5]
[null,null,587,"Eminem",3]
[null,null,588,"Madonna",2]
[null,null,589,"Eminem",3]
[null,null,590,"Moore",4]
[null,null,591,"Mellencamp",2]
[null,null,592,"Eminem",2]
[null,null,593,"Manilow",4]
[null,null,594,"Springsteen",3]
[null,null,595,"Madonna",2]
[null,null,596,"Springsteen",4]
[null,null,597,"Springsteen",5]
[null,null,598,"U2",5]
[null,null,599,"Mellencamp",5]
[null,null,600,"Mellencamp",5]
[null,null,601,"Manilow",4]
[null,null,602,"Spears",2]
[null,null,603,"Manilow",4]
[null,null,604,"Spears",2]
[null,null,605,"Madonna",4]
[null,null,606,"Manilow",5]
[null,null,607,"U2",2]
[null,null,608,"Manilow",4]
[null,null,609,"Mellencamp",5]
[null,null,610,"Spears",3]
[null,null,611,"U2",5]
[null,null,612,"Eminem",3]
[null,null,613,"Eminem",5]
[null,null,614,"Spears",2]
[null,null,615,"Spears",2]
[null,null,616,"Spears",4]
[null,null,617,"U2",3]
[null,null,618,"Springsteen",4]
[null,null,619,"Spears",5]
[null,null,620,"Moore",2]
[null,null,621,"Madonna",5]
[null,null,622,"Eminem",4]
[null,null,623,"Spears",3]
[null,null,624,"Madonna",3]
[null,null,625,"Eminem",2]
[null,null,626,"Madonna",4]
[null,null,627,"Spears",2]
[null,null,628,"Manilow",2]
[null,null,629,"Madonna",5]
[null,null,630,"Springsteen",3]
[null,null,631,"U2",2]
[null,null,632,"Madonna",4]
[null,null,633,"U2",4]
[null,null,634,"Mellencamp",2]
[null,null,635,"Madonna",4]
[null,null,636,"Moore",2]
[null,null,637,"Moore",2]
[null,null,638,"Eminem",5]
[null,null,639,"Mellencamp",3]
[null,null,640,"Springsteen",5]
[null,null,641,"Moore",3]
[null,null,642,"Eminem",4]
[null,null,643,"Moore",2]
[null,null,644,"Moore",3]
[null,null,645,"Eminem",3]
[null,null,646,"Mellencamp",5]
[null,null,647,"Moore",4]
[null,null,648,"Eminem",5]
[null,null,649,"Madonna",2]
[null,null,650,"Manilow",3]
[null,null,651,"U2",3]
[null,null,652,"Mellencamp",2]
[null,null,653,"Manilow",3]
[null,null,654,"Moore",3]
[null,null,655,"U2",2]
[null,null,656,"U2",4]
[null,null,657,"Moore",5]
[null,null,658,"Manilow",2]
[null,null,659,"Manilow",4]
[null,null,660,"Eminem",2]
[null,null,661,"Moore",2]
[null,null,662,"Springsteen",4]
[null,null,663,"Manilow",5]
[null,null,664,"Madonna",4]
[null,null,665,"Springsteen",3]
[null,null,666,"Springsteen",2]
[null,null,667,"U2",4]
[null,null,668,"Mellencamp",5]
[null,null,669,"Spears",2]
[null,null,670,"Eminem",3]
[null,null,671,"Eminem",5]
[null,null,672,"Springsteen",5]
[null,null,673,"Mellencamp",3]
[null,null,674,"Moore",3]
[null,null,675,"Manilow",2]
[null,null,676,"Moore",5]
[null,null,677,"U2",4]
[null,null,678,"Spears",5]
[null,null,679,"Madonna",3]
[null,null,680,"Manilow",4]
[null,null,681,"U2",2]
[null,null,682,"Spears",4]
[null,null,683,"Madonna",3]
[null,null,684,"Moore",3]
[null,null,685,"Moore",5]
[null,null,686,"Springsteen",5]
[null,null,687,"U2",4]
[null,null,688,"Mellencamp",2]
[null,null,689,"Manilow",3]
[null,null,690,"Madonna",2]
[null,null,691,"Madonna",4]
[null,null,692,"Eminem",3]
[null,null,693,"Manilow",2]
[null,null,694,"U2",4]
[null,null,695,"Mellencamp",2]
[null,null,696,"Mellencamp",5]
[null,null,697,"U2",4]
[null,null,698,"Madonna",2]
[null,null,699,"Spears",2]
[null,null,700,"Spears",2]
[null,null,701,"Springsteen",4]
[null,null,702,"Mellencamp",5]
[null,null,703,"Madonna",4]
[null,null,704,"Spears",5]
[null,null,705,"Springsteen",3]
[null,null,706,"Manilow",4]
[null,null,707,"Manilow",5]
[null,null,708,"Spears",4]
[null,null,709,"Moore",3]
[null,null,710,"Mellencamp",2]
[null,null,711,"Moore",2]
[null,null,712,"Springsteen",2]
[null,null,713,"Eminem",5]
[null,null,714,"Eminem",5]
[null,null,715,"Mellencamp",5]
[null,null,716,"Manilow",5]
[null,null,717,"Spears",3]
[null,null,718,"Mellencamp",5]
[null,null,719,"Manilow",3]
[null,null,720,"Springsteen",2]
[null,null,721,"Spears",5]
[null,null,722,"Moore",3]
[null,null,723,"Manilow",2]
[null,null,724,"Mellencamp",4]
[null,null,725,"Eminem",2]
[null,null,726,"Spears",4]
[null,null,727,"Spears",4]
[null,null,728,"Manilow",4]
[null,null,729,"Manilow",2]
[null,null,730,"Eminem",3]
[null,null,731,"Eminem",2]
[null,null,732,"Madonna",5]
[null,null,733,"U2",4]
[null,null,734,"Spears",2]
[null,null,735,"Manilow",2]
[null,null,736,"U2",3]
[null,null,737,"Manilow",2]
[null,null,738,"Moore",4]
[null,null,739,"Manilow",2]
[null,null,740,"Mellencamp",4]
[null,null,741,"Mellencamp",4]
[null,null,742,"U2",5]
[null,null,743,"Spears",2]
[null,null,744,"Madonna",4]
[null,null,745,"Manilow",2]
[null,null,746,"Madonna",4]
[null,null,747,"Madonna",4]
[null,null,748,"Spears",3]
[null,null,749,"Eminem",4]
[null,null,750,"Moore",4]
[null,null,751,"U2",5]
[null,null,752,"Moore",3]
[null,null,753,"Moore",3]
[null,null,754,"Eminem",2]
[null,null,755,"Madonna",5]
[null,null,756,"Moore",2]
[null,null,757,"Madonna",5]
[null,null,758,"Springsteen",3]
[null,null,759,"Moore",2]
[null,null,760,"Madonna",2]
[null,null,761,"Mellencamp",3]
[null,null,762,"Manilow",5]
[null,null,763,"Spears",3]
[null,null,764,"Eminem",3]
[null,null,765,"Manilow",5]
[null,null,766,"Springsteen",4]
[null,null,767,"Springsteen",2]
[null,null,768,"Eminem",5]
[null,null,769,"U2",5]
[null,null,770,"Manilow",2]
[null,null,771,"Madonna",5]
[null,null,772,"Moore",5]
[null,null,773,"Manilow",2]
[null,null,774,"Springsteen",4]
[null,null,775,"U2",5]
[null,null,776,"Mellencamp",4]
[null,null,777,"Spears",4]
[null,null,778,"U2",5]
[null,null,779,"Springsteen",2]
[null,null,780,"Spears",2]
[null,null,781,"Springsteen",2]
[null,null,782,"Manilow",5]
[null,null,783,"Madonna",5]
[null,null,784,"Springsteen",4]
[null,null,785,"Madonna",4]
[null,null,786,"U2",5]
[null,null,787,"Moore",5]
[null,null,788,"Eminem",5]
[null,null,789,"U2",4]
[null,null,790,"Eminem",3]
[null,null,791,"Manilow",2]
[null,null,792,"Spears",5]
[null,null,793,"Spears",5]
[null,null,794,"U2",5]
[null,null,795,"Mellencamp",4]
[null,null,796,"Eminem",4]
[null,null,797,"Madonna",4]
[null,null,798,"Madonna",3]
[null,null,799,"Spears",5]
[null,null,800,"Springsteen",4]
[null,null,801,"Mellencamp",5]
[null,null,802,"Manilow",4]
[null,null,803,"Springsteen",4]
[null,null,804,"Manilow",3]
[null,null,805,"Moore",3]
[null,null,806,"Madonna",3]
[null,null,807,"Manilow",5]
[null,null,808,"U2",5]
[null,null,809,"Moore",2]
[null,null,810,"U2",5]
[null,null,811,"U2",2]
[null,null,812,"Manilow",2]
[null,null,813,"Madonna",4]
[null,null,814,"Eminem",5]
[null,null,815,"Spears",5]
[null,null,816,"Moore",4]
[null,null,817,"Springsteen",2]
[null,null,818,"Madonna",2]
[null,null,819,"Madonna",4]
[null,null,820,"Mellencamp",2]
[null,null,821,"Manilow",4]
[null,null,822,"U2",4]
[null,null,823,"U2",3]
[null,null,824,"Springsteen",2]
[null,null,825,"Manilow",3]
[null,null,826,"Moore",5]
[null,null,827,"Manilow",3]
[null,null,828,"Springsteen",4]
[null,null,829,"Moore",4]
[null,null,830,"Spears",4]
[null,null,831,"Spears",2]
[null,null,832,"Madonna",4]
[null,null,833,"Springsteen",5]
[null,null,834,"Moore",2]
[null,null,835,"Mellencamp",4]
[null,null,836,"Mellencamp",3]
[null,null,837,"Madonna",5]
[null,null,838,"Spears",4]
[null,null,839,"Eminem",2]
[null,null,840,"Spears",5]
[null,null,841,"Spears",5]
[null,null,842,"Mellencamp",2]
[null,null,843,"Mellencamp",2]
[null,null,844,"Madonna",4]
[null,null,845,"Moore",5]
[null,null,846,"Moore",2]
[null,null,847,"Spears",5]
[null,null,848,"Madonna",2]
[null,null,849,"Springsteen",2]
[null,null,850,"Manilow",4]
[null,null,851,"Spears",4]
[null,null,852,"Springsteen",4]
[null,null,853,"Mellencamp",3]
[null,null,854,"Spears",2]
[null,null,855,"Eminem",5]
[null,null,856,"Eminem",2]
[null,null,857,"Manilow",5]
[null,null,858,"Manilow",3]
[null,null,859,"Spears",2]
[null,null,860,"Moore",4]
[null,null,861,"Madonna",3]
[null,null,862,"Moore",3]
[null,null,863,"Eminem",5]
[null,null,864,"Manilow",3]
[null,null,865,"Moore",4]
[null,null,866,"Mellencamp",4]
[null,null,867,"Spears",5]
[null,null,868,"Mellencamp",2]
[null,null,869,"U2",2]
[null,null,870,"Mellencamp",5]
[null,null,871,"Mellencamp",2]
[null,null,872,"Madonna",3]
[null,null,873,"Spears",5]
[null,null,874,"Madonna",3]
[null,null,875,"Spears",3]
[null,null,876,"Springsteen",3]
[null,null,877,"U2",2]
[null,null,878,"Moore",3]
[null,null,879,"Mellencamp",4]
[null,null,880,"U2",3]
[null,null,881,"Moore",3]
[null,null,882,"Eminem",5]
[null,null,883,"U2",5]
[null,null,884,"Spears",3]
[null,null,885,"Madonna",3]
[null,null,886,"Mellencamp",4]
[null,null,887,"Eminem",2]
[null,null,888,"Manilow",3]
[null,null,889,"Moore",2]
[null,null,890,"Eminem",4]
[null,null,891,"U2",5]
[null,null,892,"Madonna",4]
[null,null,893,"U2",2]
[null,null,894,"Springsteen",2]
[null,null,895,"Springsteen",2]
[null,null,896,"Spears",2]
[null,null,897,"Springsteen",2]
[null,null,898,"Moore",4]
[null,null,899,"Madonna",5]
[null,null,900,"Madonna",4]

{"sheet":"Student Report","index":10,"n_rows":250,"n_cols":14,"rows_kept":250,"cut":false,"hidden":true,"merged":[[124,1,124,2],[98,2,98,4],[127,2,127,5],[128,2,130,5],[128,1,130,1],[121,2,121,4],[81,8,81,9],[61,1,61,2],[66,2,66,5],[109,8,109,10],[113,8,113,9],[77,8,77,10],[106,8,106,9],[89,2,89,4],[96,2,96,4],[92,1,92,2],[97,2,97,4],[95,2,95,5],[16,8,16,10],[20,8,20,9],[74,8,74,9],[58,2,58,4],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[64,2,64,5],[65,2,65,5],[28,2,28,4],[31,1,31,2],[43,8,43,9],[46,8,46,10],[50,8,50,9],[156,1,156,2],[161,2,161,4],[162,2,162,4],[137,8,137,9],[188,1,188,2],[140,8,140,10],[144,8,144,9],[152,2,152,4],[159,2,159,5],[160,2,160,5],[202,8,202,9],[205,8,205,10],[225,2,225,5],[226,2,226,5],[169,8,169,9],[172,8,172,10],[176,8,176,9],[184,2,184,4],[191,2,191,5],[192,2,192,5],[193,2,193,4],[194,2,194,4],[241,5,247,7],[241,2,247,2],[209,8,209,9],[217,2,217,4],[221,1,221,2],[227,2,227,4],[224,2,224,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Excel Efficiency & Knowledge Report:"]
[null,null,"Name:",{"$f":"IF(Name!F13=\"\",\"\",Name!F13)","v":""},{"$f":"IF(Name!I13=\"\",\"\",Name!I13)","v":""}]
[null,null,"Date:",{"$f":"TEXT(TODAY(),\"mm/dd/yyyy\")","v":"10/05/2017"}]
[]
[]
[null,null,"TASK 1",null,null,null,null,null,"Time Taken:",null,null,null,null,"Marks"]
[]
[]
[null,null,null,null,null,null,null,null,"Efficiency Mark: You finished  this  task in ",null,null,{"$f":"TIME(HOUR('Task 1'!$O$10),MINUTE('Task 1'!$O$10),SECOND('Task 1'!$O$10))","v":"00:00:00"},null,{"$f":"IF(AND(TEXT(L17,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L17,\"hh:mm:ss\")<TEXT(\"00:02:00\",\"hh:mm:ss\")),100,IF(AND(TEXT(L17,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L17,\"hh:mm:ss\")<TEXT(\"00:03:00\",\"hh:mm:ss\")),60,0))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Questions Response:"]
[]
[null,null,null,null,null,null,null,null,"Question 1",{"$f":"IF(N23=\"\",\"\",IF(N23>0,\"Correct\",\"Incorrect\"))","v":""},null,null,null,{"$f":"IF(AND('Task 1'!O13=\"\",TEXT(L17,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 1'!O13=783,20,0))","v":""}]
[null,null,null,null,null,null,null,null,"Question 2",{"$f":"IF(N24=\"\",\"\",IF(N24>0,\"Correct\",\"Incorrect\"))","v":""},null,null,null,{"$f":"IF(AND('Task 1'!O14=\"\",TEXT(L17,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 1'!O14=275104,20,0))","v":""}]
[null,null,null,null,null,null,null,null,"Question 3",{"$f":"IF(N25=\"\",\"\",IF(N25>0,\"Correct\",\"Incorrect\"))","v":""},null,null,null,{"$f":"IF(AND('Task 1'!O15=\"\",TEXT(L17,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 1'!O15=275112,40,0))","v":""}]
[null,null,null,null,null,null,null,null,"Question 4",{"$f":"IF(N26=\"\",\"\",IF(N26>0,\"Correct\",\"Incorrect\"))","v":""},null,null,null,{"$f":"IF(AND('Task 1'!I335=\"\",TEXT(L17,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF(AND(CELL(\"format\",'Task 1'!I335)=\",0\",'Task 1'!I335<>0),20,0))","v":""}]
[]
[null,null,null,null,null,null,null,null,"Total Knowledge Mark",null,null,null,null,{"$f":"SUM(N23:N26)","v":0}]
[]
[]
[]
[null," Feedback:"]
[]
[]
[null,"Q 1",{"$f":"IF(OR(J23=\"\",J23=\"Correct\"),\"Well done, Good knowledgeof  basic functions\",\"This indicates you should probably  do an Excel Beginners Course\")","v":"Well done, Good knowledgeof  basic functions"}]
[null,"Q 2",{"$f":"IF(OR(J24=\"\",J24=\"Correct\"),\"\",\"Learn more about  Excel Functions epecially the Autosum Function\")","v":""}]
[null,"Q 3",{"$f":"IF(OR(J25=\"\",J25=\"Correct\"),\" Very Good\",\"Revise copying function using the fill handle\")","v":" Very Good"}]
[null,"Q 4",{"$f":"IF(OR(J26=\"\",J26=\"Correct\"),\" Good formatting skills\",\"Learn more abour Formatting especially Currency  Formatting\")","v":" Good formatting skills"}]
[]
[]
[]
[]
[]
[null,null,"TASK 2",null,null,null,null,null,"Time Taken:",null,null,null,null,"Marks"]
[]
[]
[null,null,null,null,null,null,null,null,"Efficiency Mark: You finished  this  task in ",null,null,{"$f":"TIME(HOUR('Task 2'!$O$10),MINUTE('Task 2'!$O$10),SECOND('Task 2'!$O$10))","v":"00:00:00"},null,{"$f":"IF(AND(TEXT(L47,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L47,\"hh:mm:ss\")<TEXT(\"00:02:00\",\"hh:mm:ss\")),100,IF(AND(TEXT(L47,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L47,\"hh:mm:ss\")<TEXT(\"00:03:00\",\"hh:mm:ss\")),60,0))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Questions Response:"]
[]
[null,null,null,null,null,null,null,null,"Question 1",{"$f":"IF(N53=\"\",\"\",IF(N53>0,\"Correct\",\"Incorrect\"))","v":""},null,null,null,{"$f":"IF(AND('Task 2'!O13=\"\",TEXT(L47,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 2'!O13=22.4,20,0))","v":""}]
[null,null,null,null,null,null,null,null,"Question 2","",null,null,null,{"$f":"IF(AND('Task 2'!O14=\"\",TEXT(L47,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 2'!O14=17,20,0))","v":""}]
[null,null,null,null,null,null,null,null,"Question 3","",null,null,null,{"$f":"IF(AND('Task 2'!O15=\"\",TEXT(L47,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 2'!O15=31.67,60,0))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,"Total Knowledge Mark",null,null,null,null,{"$f":"SUM(N53:N55)","v":0}]
[]
[]
[]
[null," Feedback:"]
[]
[]
[null,"Q 1",{"$f":"IF(OR(J53=\"\",J53=\"Correct\"),\"Well done,  good knowledge of building  simple formulas\",\"This indicates you should probably  do an Excel Beginners Course\")","v":"Well done,  good knowledge of building  simple formulas"}]
[null,"Q 2",{"$f":"IF(OR(J54=\"\",J54=\"Correct\"),\"Excellent, you are using cell references\",\"Learn how to  create  formulas and 'control  your worksheets'\")","v":"Excellent, you are using cell references"}]
[null,"Q 3",{"$f":"IF(OR(J55=\"\",J55=\"Correct\"),\"Excellent, it  looks at this moment that  you should be looking at an intermediate Excel Course and not a Beginners Excel  course. \",\" Understanding  Relative and absolute references is vital in Excel.\")","v":"Excellent, it  looks at this moment that  you should be looking at an intermediate Excel Course and not a Beginners Excel  course. "}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TASK 3",null,null,null,null,null,"Time Taken:",null,null,null,null,"Marks"]
[]
[]
[null,null,null,null,null,null,null,null,"Efficiency Mark: You finished  this  task in ",null,null,{"$f":"TIME(HOUR('Task 3'!$O$10),MINUTE('Task 3'!$O$10),SECOND('Task 3'!$O$10))","v":"00:00:00"},null,{"$f":"IF(AND(TEXT(L78,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L78,\"hh:mm:ss\")<TEXT(\"00:01:00\",\"hh:mm:ss\")),100,IF(AND(TEXT(L78,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L78,\"hh:mm:ss\")<TEXT(\"00:03:00\",\"hh:mm:ss\")),40,0))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Questions Response:"]
[]
[]
[null,null,null,null,null,null,null,null,"Question 1",{"$f":"IF(N85=\"\",\"\",IF(N85>0,\"Correct\",\"Incorrect\"))","v":""},null,null,null,{"$f":"IF(AND('Task 3'!O13=\"\",TEXT(L78,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 3'!O13=\"Allentown\",100,0))","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Knowledge Mark",null,null,null,null,{"$f":"SUM(N85)","v":0}]
[]
[]
[]
[null,"Feedback:"]
[]
[]
[null,"Q 1",{"$f":"IF(OR(J85=\"\",J85=\"Correct\"),\" You have a good knowledge of data Filters\",\"Knowledge of data Filters weak\")","v":" You have a good knowledge of data Filters"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TASK 4",null,null,null,null,null,"Time Taken:",null,null,null,null,"Marks"]
[]
[]
[null,null,null,null,null,null,null,null,"Efficiency Mark: You finished  this  task in ",null,null,{"$f":"TIME(HOUR('Task 4'!$O$10),MINUTE('Task 4'!$O$10),SECOND('Task 4'!$O$10))","v":"00:00:00"},null,{"$f":"IF(AND(TEXT(L110,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L110,\"hh:mm:ss\")<TEXT(\"00:02:00\",\"hh:mm:ss\")),100,IF(AND(TEXT(L110,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L110,\"hh:mm:ss\")<TEXT(\"00:03:00\",\"hh:mm:ss\")),60,0))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Questions Response:"]
[]
[]
[null,null,null,null,null,null,null,null,"Question 1",{"$f":"IF(N117=\"\",\"\",IF(N117>0,\"Correct\",\"Incorrect\"))","v":""},null,null,null,{"$f":"IF(AND('Task 4'!O13=\"\",TEXT(L110,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 4'!O13=1.28,30,0))","v":""}]
[null,null,null,null,null,null,null,null,"Question 2","",null,null,null,{"$f":"IF(AND('Task 4'!O14=\"\",TEXT(L110,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 4'!O14=2.9,70,0))","v":""}]
[null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,"Total Knowledge Mark",null,null,null,null,{"$f":"SUM(N117:N118)","v":0}]
[]
[]
[]
[null,"Feedback:"]
[]
[]
[null,"Q 1",{"$f":"IF(OR(J117=\"\",J117=\"Correct\"),\"Excellent as linking is such a vital Excel Skill \",\"You need to learn how to link  between worksheets & workbooks. This is a basic Excel Skill\")","v":"Excellent as linking is such a vital Excel Skill "}]
[null,"Q 2",{"$f":"IF(OR(J118=\"\",J118=\"Correct\"),\"Again, Excellent , you have fixed the reference. You should be looking at doing an Intermediate Excel Course\",\"You need to learn  how to link between worksheets & workbooksand how to fix cells. You  should be looking to do an Beginners Excel Course\")","v":"Again, Excellent , you have fixed the reference. You should be looking at doing an Intermediate Excel Course"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TASK 5",null,null,null,null,null,"Time Taken:",null,null,null,null,"Marks"]
[]
[]
[null,null,null,null,null,null,null,null,"Efficiency Mark: You finished  this  task in ",null,null,{"$f":"TIME(HOUR('Task 5'!$O$10),MINUTE('Task 5'!$O$10),SECOND('Task 5'!$O$10))","v":"00:00:00"},null,{"$f":"IF(AND(TEXT(L141,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L141,\"hh:mm:ss\")<TEXT(\"00:02:00\",\"hh:mm:ss\")),100,IF(AND(TEXT(L141,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L141,\"hh:mm:ss\")<TEXT(\"00:03:00\",\"hh:mm:ss\")),60,0))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Questions Response:"]
[]
[]
[null,null,null,null,null,null,null,null,"Question 1",{"$f":"IF(N148=\"\",\"\",IF(N148>0,\"Correct\",\"Incorrect\"))","v":""},null,null,null,{"$f":"IFERROR(IF(AND('Task 5'!O13=\"\",TEXT(L141,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF(ROUND('Task 5'!O13,1)=24.5,30,0)),0)","v":""}]
[null,null,null,null,null,null,null,null,"Question 2","",null,null,null,{"$f":"IF(AND('Task 5'!O14=\"\",TEXT(L141,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 5'!O14=15.95,70,0))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,"Total Knowledge Mark",null,null,null,null,{"$f":"SUM(N148:N149)","v":0}]
[]
[]
[]
[]
[null,"Feedback:"]
[]
[]
[null,"Q 1",{"$f":"IF(OR(J148=\"\",J148=\"Correct\"),\"Well done, The IF Function is an important Intermediate Excel Function\",\"You need to learn about  the If Function\")","v":"Well done, The IF Function is an important Intermediate Excel Function"}]
[null,"Q 2",{"$f":"IF(OR(J149=\"\",J149=\"Correct\"),\"Excellent, you used the IF function with cell references and fixed the relevent references\",\"You need to study  the IF Function and fixing cell references \")","v":"Excellent, you used the IF function with cell references and fixed the relevent references"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TASK 6",null,null,null,null,null,"Time Taken:",null,null,null,null,"Marks"]
[]
[]
[null,null,null,null,null,null,null,null,"Efficiency Mark: You finished  this  task in ",null,null,{"$f":"TIME(HOUR('Task 6'!$O$10),MINUTE('Task 6'!$O$10),SECOND('Task 6'!$O$10))","v":"00:00:00"},null,{"$f":"IF(AND(TEXT(L173,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L173,\"hh:mm:ss\")<TEXT(\"00:02:00\",\"hh:mm:ss\")),100,IF(AND(TEXT(L173,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L173,\"hh:mm:ss\")<TEXT(\"00:03:00\",\"hh:mm:ss\")),60,0))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Questions Response:"]
[]
[]
[null,null,null,null,null,null,null,null,"Question 1",{"$f":"IF(N180=\"\",\"\",IF(N180>0,\"Correct\",\"Incorrect\"))","v":""},null,null,null,{"$f":"IF(AND('Task 6'!O13=\"\",TEXT(L173,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 6'!O13=\"14K Gold Onyx Cross \",50,0))","v":""}]
[null,null,null,null,null,null,null,null,"Question 2","",null,null,null,{"$f":"IF(AND('Task 6'!O14=\"\",TEXT(L173,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 6'!O14=\"14K Gold Earrings \",50,0))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,"Total Knowledge Mark",null,null,null,null,{"$f":"SUM(N180:N181)","v":0}]
[]
[]
[]
[]
[null,"Feedback:"]
[]
[]
[null,"Q 1",{"$f":"IF(OR(J180=\"\",J180=\"Correct\"),\"Great , as the Vlookup is such a vital Excel Function\",\"You need to learn about the  Vlookup Function as its vital in using Excel effectively\")","v":"Great , as the Vlookup is such a vital Excel Function"}]
[null,"Q 2",{"$f":"IF(OR(J181=\"\",J181=\"Correct\"),\"Again, showing your knowledge of the Vlookup Functions and absolutes\",\"You need to study the  Vlookup Function and how to lock down cell references'\")","v":"Again, showing your knowledge of the Vlookup Functions and absolutes"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TASK 7",null,null,null,null,null,"Time Taken:",null,null,null,null,"Marks"]
[]
[]
[null,null,null,null,null,null,null,null,"Efficiency Mark: You finished  this  task in ",null,null,{"$f":"TIME(HOUR('Task 7'!$O$10),MINUTE('Task 7'!$O$10),SECOND('Task 7'!$O$10))","v":"00:00:00"},null,{"$f":"IF(AND(TEXT(L206,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L206,\"hh:mm:ss\")<TEXT(\"00:02:00\",\"hh:mm:ss\")),100,IF(AND(TEXT(L206,\"hh:mm:ss\")>TEXT(\"00:00:00\",\"hh:mm:ss\"),TEXT(L206,\"hh:mm:ss\")<TEXT(\"00:03:00\",\"hh:mm:ss\")),60,0))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Questions Response:"]
[]
[]
[null,null,null,null,null,null,null,null,"Question 1",{"$f":"IF(N213=\"\",\"\",IF(N213>0,\"Correct\",\"Incorrect\"))","v":""},null,null,null,{"$f":"IF(AND('Task 7'!O13=\"\",TEXT(L206,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 7'!O13=107,30,0))","v":""}]
[null,null,null,null,null,null,null,null,"Question 2",{"$f":"IF(N214=\"\",\"\",IF(N214>0,\"Correct\",\"Incorrect\"))","v":""},null,null,null,{"$f":"IF(AND('Task 7'!O14=\"\",TEXT(L206,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 7'!O14=373,30,0))","v":""}]
[null,null,null,null,null,null,null,null,"Question 3","",null,null,null,{"$f":"IF(AND('Task 7'!O15=\"\",TEXT(L206,\"hh:mm:ss\")<=TEXT(\"00:00:00\",\"hh:mm:ss\")),\"\",IF('Task 7'!O15=126,40,0))","v":""}]
[]
[null,null,null,null,null,null,null,null,"Total Knowledge Mark",null,null,null,null,{"$f":"SUM(N213:N215)","v":0}]
[]
[]
[]
[]
[null,"Feedback:"]
[]
[]
[null,"Q 1",{"$f":"IF(OR(J213=\"\",J213=\"Correct\"),\"Good answer \",\"Learn about the  Sumif and Countif Function as they are very useful.\")","v":"Good answer "}]
[null,"Q 2",{"$f":"IF(OR(J214=\"\",J214=\"Correct\"),\" Excellent\",\"Learn about the  Sumif and Countif Function as they are very useful\")","v":" Excellent"}]
[null,"Q 3",{"$f":"IF(OR(J215=\"\",J215=\"Correct\"),\" Good solid answer\",\"Again you need to learn about these 2 very useful intermediate functions'\")","v":" Good solid answer"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(Name!F13=\"\",\"\",Name!F13&\",  your Overall Result is:\")","v":""}]
[]
[]
[null,null,"Excel Efficiency:",null,null,"Excel Knowledge:"]
[]
[null,null,{"$f":"(N17+N47+N78+N110+N141+N173+N206)/700","v":0},null,null,{"$f":"(N28+N58+N89+N121+N152+N184+N217)/700","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(Name!F13=\"\",\"\",Name!F13&\", you should consider doing\")","v":""},null,null,null,{"$f":"IF((N28+N58+N89+N121)/4 <70,\"a Beginners Course\",\"an Intermediate Course\")","v":"a Beginners Course"}]