{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["(806)","(806an)","(807)","(807an)","(808)","(808an)","(809)","(809an)","(810)","(810an)","(811)","(811an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"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":"(806)","index":0,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,0,5,0],[1,1,5,1],[1,4,5,4],[6,0,10,0],[6,1,10,1],[6,4,10,4],[11,0,15,0],[11,1,15,1],[11,4,15,4],[16,0,20,0],[16,1,20,1],[16,4,20,4],[21,0,25,0],[21,1,25,1],[21,4,25,4],[26,0,30,0],[26,1,30,1],[26,4,30,4],[31,0,35,0],[31,1,35,1],[31,4,35,4],[36,0,40,0],[36,1,40,1],[36,4,40,4],[41,0,45,0],[41,1,45,1],[41,4,45,4],[46,0,50,0],[46,1,50,1],[46,4,50,4],[51,0,55,0],[51,1,55,1],[51,4,55,4],[56,0,60,0],[56,1,60,1],[56,4,60,4]]}
["Week","Topic","Date","Videos to watch","Chapter in Textbook","Quiz & Test Dates",null,"Start Dart"]
["Week 1","Introduction To Excel",null,"Intro Video","None",null,null,"2011-09-26"]
[null,null,null,"Video 1 & 2"]
[null,null,null,"Video 3 & 4",null,null,null,"Holidays"]
[null,null,null,"Video 5 to 8",null,null,null,"2011-10-14"]
[null,null,null,"Video 9",null,"Angel Quiz 1",null,"2011-11-11"]
["Week 2","Basic Math & Word Problems",null,null,"Chapter 1",null,null,"2011-11-24"]
[null,null,null,null,null,null,null,"2011-11-25"]
[]
[]
[null,null,null,null,null,"Excel Test 1"]
["Week 3","Fractions",null,null,"Chapter 2"]
[]
[]
[null,null,null,null,null,"Angel Quiz 2"]
[]
["Week 4","Percents",null,null,"Chapter 3"]
[]
[]
[]
[null,null,null,null,null,"Excel Test 2"]
["Week 5","Solving For Unknowns",null,null,"Chapter 4"]
[]
[]
[]
[null,null,null,null,null,"Angel Quiz 3"]
["Week 6","Banking & Payroll",null,null,"Chapter 5 & 6"]
[]
[]
[]
[null,null,null,null,null,"Angel Quiz 4"]
["Week 7","Buying and Selling",null,null,"Chapter 7 & 8"]
[]
[]
[null,null,null,null,null,"Angel Quiz 5"]
[]
["Week 8","Simple Interest",null,null,"Chapter 9"]
[]
[]
[]
[null,null,null,null,null,"Angel Quiz 6"]
["Week 9","Compound Interest",null,null,"Chapter 10"]
[]
[null,null,null,null,null,"Angel Quiz 7"]
[]
[]
["Week 10","Annuities",null,null,"Chapter 11"]
[]
[]
[]
[null,null,null,null,null,"Angel Quiz 8"]
["Week 11","Basic Statistics",null,null,"Chapter 15"]
[]
[]
[]
[null,null,null,null,null,"Angel Quiz 9"]
["Week 12"]
[]
[]
[null,null,null,null,null,"8 - 9:50 AM - Excel Test 3"]

{"sheet":"(806an)","index":1,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,0,5,0],[1,1,5,1],[1,4,5,4],[6,0,10,0],[6,1,10,1],[6,4,10,4],[11,0,15,0],[11,1,15,1],[11,4,15,4],[16,0,20,0],[16,1,20,1],[16,4,20,4],[21,0,25,0],[21,1,25,1],[21,4,25,4],[26,0,30,0],[26,1,30,1],[26,4,30,4],[31,0,35,0],[31,1,35,1],[31,4,35,4],[36,0,40,0],[36,1,40,1],[36,4,40,4],[41,0,45,0],[41,1,45,1],[41,4,45,4],[46,0,50,0],[46,1,50,1],[46,4,50,4],[51,0,55,0],[51,1,55,1],[51,4,55,4],[56,0,60,0],[56,1,60,1],[56,4,60,4]]}
["Week","Topic","Date","Videos to watch","Chapter in Textbook","Quiz & Test Dates",null,"Start Dart"]
["Week 1","Introduction To Excel",{"$f":"H2","v":"2011-09-26"},"Intro Video","None",null,{"$f":"NOT(NETWORKDAYS(C2,C2,$H$5:$H$12))","v":false},"2011-09-26"]
[null,null,{"$f":"C2+1","v":"2011-09-27"},"Video 1 & 2",null,null,{"$f":"NOT(NETWORKDAYS(C3,C3,$H$5:$H$12))","v":false}]
[null,null,{"$f":"C3+1","v":"2011-09-28"},"Video 3 & 4",null,null,true,"Holidays"]
[null,null,"2011-09-29","Video 5 to 8",null,null,false,"2011-10-14"]
[null,null,"2011-09-30","Video 9",null,"Angel Quiz 1",false,"2011-09-28"]
["Week 2","Basic Math & Word Problems",{"$f":"C6+3","v":"2011-10-03"},null,"Chapter 1",null,false,"2011-11-24"]
[null,null,{"$f":"C7+1","v":"2011-10-04"},null,null,null,false,"2011-11-25"]
[null,null,{"$f":"C8+1","v":"2011-10-05"},null,null,null,false]
[null,null,"2011-10-06",null,null,null,false]
[null,null,"2011-10-07",null,null,"Excel Test 1",false]
["Week 3","Fractions",{"$f":"C11+3","v":"2011-10-10"},null,"Chapter 2",null,false]
[null,null,{"$f":"C12+1","v":"2011-10-11"},null,null,null,false]
[null,null,"2011-10-12",null,null,null,false]
[null,null,"2011-10-13",null,null,"Angel Quiz 2",false]
[null,null,"2011-10-14",null,null,null,true]
["Week 4","Percents",{"$f":"C16+3","v":"2011-10-17"},null,"Chapter 3",null,false]
[null,null,{"$f":"C17+1","v":"2011-10-18"},null,null,null,false]
[null,null,"2011-10-19",null,null,null,false]
[null,null,"2011-10-20",null,null,null,false]
[null,null,"2011-10-21",null,null,"Excel Test 2",false]
["Week 5","Solving For Unknowns",{"$f":"C21+3","v":"2011-10-24"},null,"Chapter 4",null,false]
[null,null,{"$f":"C22+1","v":"2011-10-25"},null,null,null,false]
[null,null,"2011-10-26",null,null,null,false]
[null,null,"2011-10-27",null,null,null,false]
[null,null,"2011-10-28",null,null,"Angel Quiz 3",false]
["Week 6","Banking & Payroll",{"$f":"C26+3","v":"2011-10-31"},null,"Chapter 5 & 6",null,false]
[null,null,{"$f":"C27+1","v":"2011-11-01"},null,null,null,false]
[null,null,"2011-11-02",null,null,null,false]
[null,null,"2011-11-03",null,null,null,false]
[null,null,"2011-11-04",null,null,"Angel Quiz 4",false]
["Week 7","Buying and Selling",{"$f":"C31+3","v":"2011-11-07"},null,"Chapter 7 & 8",null,false]
[null,null,{"$f":"C32+1","v":"2011-11-08"},null,null,null,false]
[null,null,"2011-11-09",null,null,null,false]
[null,null,"2011-11-10",null,null,"Angel Quiz 5",false]
[null,null,"2011-11-11",null,null,null,false]
["Week 8","Simple Interest",{"$f":"C36+3","v":"2011-11-14"},null,"Chapter 9",null,false]
[null,null,{"$f":"C37+1","v":"2011-11-15"},null,null,null,false]
[null,null,"2011-11-16",null,null,null,false]
[null,null,"2011-11-17",null,null,null,false]
[null,null,"2011-11-18",null,null,"Angel Quiz 6",false]
["Week 9","Compound Interest",{"$f":"C41+3","v":"2011-11-21"},null,"Chapter 10",null,false]
[null,null,{"$f":"C42+1","v":"2011-11-22"},null,null,null,false]
[null,null,"2011-11-23",null,null,"Angel Quiz 7",false]
[null,null,"2011-11-24",null,null,null,true]
[null,null,"2011-11-25",null,null,null,true]
["Week 10","Annuities",{"$f":"C46+3","v":"2011-11-28"},null,"Chapter 11",null,false]
[null,null,{"$f":"C47+1","v":"2011-11-29"},null,null,null,false]
[null,null,"2011-11-30",null,null,null,false]
[null,null,"2011-12-01",null,null,null,false]
[null,null,"2011-12-02",null,null,"Angel Quiz 8",false]
["Week 11","Basic Statistics",{"$f":"C51+3","v":"2011-12-05"},null,"Chapter 15",null,false]
[null,null,{"$f":"C52+1","v":"2011-12-06"},null,null,null,false]
[null,null,"2011-12-07",null,null,null,false]
[null,null,"2011-12-08",null,null,null,false]
[null,null,"2011-12-09",null,null,"Angel Quiz 9",false]
["Week 12",null,{"$f":"C56+3","v":"2011-12-12"},null,null,null,false]
[null,null,{"$f":"C57+1","v":"2011-12-13"},null,null,null,false]
[null,null,"2011-12-14",null,null,null,false]
[null,null,"2011-12-15",null,null,"8 - 9:50 AM - Excel Test 3",false]
[null,null,"2011-12-16",null,null,null,false]

{"sheet":"(807)","index":2,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","City","E-mail"]
["Jo","Luong","Seattle","rad@yahoo.com"]
[]
["Calc Number 1","Calc Number 2","Calc Number 3","Calc Number 4"]
[2.5,26.35,5,88.95]
[]
["Info 1","Info 2","Info 3","Info 4","Info 5"]
["Rain","Drainage","Country","Numbers","Weekends"]
[]
["Calculations:","T1","T2","T3","T4","Num"]
["Calc 1",{"$f":"A$5*8.2*$F11","v":25.055555555555557},264.08555555555557,50.111111111111114,891.47666666666669,{"$f":"ROW()/RANDBETWEEN(1,10)","v":1.2222222222222223}]
["Calc 2",49.199999999999996,518.56799999999998,98.399999999999991,1750.5359999999998,2.4]
["Calc 3",38.071428571428569,401.27285714285716,76.142857142857139,1354.5814285714287,1.8571428571428572]
["Calc 4",57.4,604.99599999999998,114.8,2042.2919999999999,2.8]
["Calc 5",51.25,540.17499999999995,102.5,1823.4749999999999,2.5]
["Calc 6",109.33333333333333,1152.3733333333332,218.66666666666666,3890.08,5.333333333333333]
["Calc 7",34.85,367.31899999999996,69.7,1239.963,1.7]
["Calc 8",123,1296.42,246,4376.34,6]
["Calc 9",38.949999999999996,410.53299999999996,77.899999999999991,1385.8409999999999,1.9]
["Calc 10",410,4321.3999999999996,820,14587.8,20]
[]
["Other Info","Other Info","Other Info","Other Info","Other Info"]
[{"$f":"B11*0.0234","v":0.58630000000000004},6.1796020000000009,1.1726000000000001,20.860554,2.8600000000000004E-2]
[1.1512799999999999,12.134491199999999,2.3025599999999997,40.962542399999997,5.6160000000000002E-2]
[0.89087142857142854,9.3897848571428586,1.7817428571428571,31.697205428571433,4.3457142857142861E-2]
[1.3431599999999999,14.1569064,2.6863199999999998,47.7896328,6.5519999999999995E-2]
[1.1992499999999999,12.640094999999999,2.3984999999999999,42.669314999999997,5.8500000000000003E-2]
[2.5583999999999998,26.965535999999997,5.1167999999999996,91.027872000000002,0.12479999999999999]
[0.81549000000000005,8.5952646000000001,1.6309800000000001,29.015134199999999,3.9780000000000003E-2]
[2.8782000000000001,30.336228000000002,5.7564000000000002,102.406356,0.1404]
[0.91142999999999996,9.6064721999999989,1.8228599999999999,32.4286794,4.446E-2]
[9.5939999999999994,101.12075999999999,19.187999999999999,341.35451999999998,0.46800000000000003]

{"sheet":"(807an)","index":3,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","City","E-mail"]
["Jo","Luong","Seattle","rad@yahoo.com"]
[]
["Calc Number 1","Calc Number 2","Calc Number 3","Calc Number 4"]
[2.5,26.35,5,88.95]
[]
["Info 1","Info 2","Info 3","Info 4","Info 5"]
["Rain","Drainage","Country","Numbers","Weekends"]
[]
["Calculations:","T1","T2","T3","T4","Num"]
["Calc 1",{"$f":"A$5*8.2*$F11","v":112.75},1188.385,225.5,4011.645,{"$f":"ROW()/RANDBETWEEN(1,10)","v":5.5}]
["Calc 2",24.599999999999998,259.28399999999999,49.199999999999996,875.26799999999992,1.2]
["Calc 3",53.300000000000004,561.78200000000004,106.60000000000001,1896.414,2.6]
["Calc 4",95.666666666666671,1008.3266666666667,191.33333333333334,3403.82,4.666666666666667]
["Calc 5",153.75,1620.5249999999999,307.5,5470.4250000000002,7.5]
["Calc 6",164,1728.56,328,5835.12,8]
["Calc 7",69.7,734.63799999999992,139.4,2479.9259999999999,3.4]
["Calc 8",184.5,1944.6299999999999,369,6564.51,9]
["Calc 9",38.949999999999996,410.53299999999996,77.899999999999991,1385.8409999999999,1.9]
["Calc 10",51.25,540.17499999999995,102.5,1823.4749999999999,2.5]
[]
["Other Info","Other Info","Other Info","Other Info","Other Info"]
[{"$f":"B11*0.0234","v":2.63835},27.808209000000002,5.2766999999999999,93.872493000000006,0.12870000000000001]
[0.57563999999999993,6.0672455999999997,1.1512799999999999,20.481271199999998,2.8080000000000001E-2]
[1.2472200000000002,13.145698800000002,2.4944400000000004,44.376087599999998,6.0840000000000005E-2]
[2.2386000000000004,23.594844000000002,4.4772000000000007,79.649388000000002,0.10920000000000001]
[3.59775,37.920285,7.1955,128.00794500000001,0.17550000000000002]
[3.8376000000000001,40.448304,7.6752000000000002,136.541808,0.18720000000000001]
[1.6309800000000001,17.1905292,3.2619600000000002,58.030268399999997,7.9560000000000006E-2]
[4.3173000000000004,45.504342000000001,8.6346000000000007,153.609534,0.21060000000000001]
[0.91142999999999996,9.6064721999999989,1.8228599999999999,32.4286794,4.446E-2]
[1.1992499999999999,12.640094999999999,2.3984999999999999,42.669314999999997,5.8500000000000003E-2]

{"sheet":"(808)","index":4,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","City","E-mail"]
["Mo","Luong","Seattle","rad@yahoo.com"]
[]
["Calc Number 1","Calc Number 2","Calc Number 3","Calc Number 4"]
[2.5,26.35,14,88.95]
[]
["Info 1","Info 2","Info 3","Info 4","Info 5"]
["Rain","Drainage","Country","Numbers","Weekends"]
[]
["Calculations:","T1","T2","T3","T4","Num"]
["Calc 1",{"$f":"A$5*8.2*$F11","v":32.214285714285715},339.5385714285714,180.39999999999998,1146.1842857142856,{"$f":"ROW()/RANDBETWEEN(1,10)","v":1.5714285714285714}]
["Calc 2",30.75,324.10500000000002,172.2,1094.085,1.5]
["Calc 3",88.833333333333329,936.30333333333328,497.46666666666658,3160.6899999999996,4.333333333333333]
["Calc 4",35.875,378.1225,200.89999999999998,1276.4324999999999,1.75]
["Calc 5",51.25,540.17499999999995,286.99999999999994,1823.4749999999999,2.5]
["Calc 6",164,1728.56,918.39999999999986,5835.12,8]
["Calc 7",49.785714285714285,524.74142857142851,278.79999999999995,1771.3757142857141,2.4285714285714284]
["Calc 8",73.8,777.85199999999998,413.28,2625.8040000000001,3.6]
["Calc 9",64.916666666666657,684.22166666666658,363.53333333333325,2309.7349999999997,3.1666666666666665]
["Calc 10",136.66666666666669,1440.4666666666667,765.33333333333326,4862.6000000000004,6.666666666666667]
[]
["Other Info","Other Info","Other Info","Other Info","Other Info"]
[{"$f":"B11*0.0234","v":0.75381428571428577},7.9452025714285712,4.2213599999999998,26.820712285714283,3.6771428571428573E-2]
[0.71955000000000002,7.5840570000000005,4.0294799999999995,25.601589000000001,3.5099999999999999E-2]
[2.0787,21.909497999999999,11.640719999999998,73.960145999999995,0.10139999999999999]
[0.83947499999999997,8.8480664999999998,4.70106,29.868520499999999,4.095E-2]
[1.1992499999999999,12.640094999999999,6.7157999999999989,42.669314999999997,5.8500000000000003E-2]
[3.8376000000000001,40.448304,21.490559999999999,136.541808,0.18720000000000001]
[1.1649857142857143,12.278949428571428,6.5239199999999995,41.450191714285715,5.6828571428571423E-2]
[1.72692,18.201736799999999,9.6707520000000002,61.443813600000006,8.4240000000000009E-2]
[1.5190499999999998,16.010786999999997,8.5066799999999976,54.047798999999991,7.4099999999999999E-2]
[3.1980000000000004,33.706920000000004,17.908799999999999,113.78484000000002,0.156]

{"sheet":"(808an)","index":5,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","City","E-mail"]
[{"$f":"'(808)'!A2","v":"Mo"},{"$f":"'(808)'!B2","v":"Luong"},{"$f":"'(808)'!C2","v":"Seattle"},{"$f":"'(808)'!D2","v":"rad@yahoo.com"}]
[]
["Calc Number 1","Calc Number 2","Calc Number 3","Calc Number 4"]
[{"$f":"'(808)'!A5","v":2.5},{"$f":"'(808)'!B5","v":26.35},{"$f":"'(808)'!C5","v":14},{"$f":"'(808)'!D5","v":88.95}]
[]
["Info 1","Info 2","Info 3","Info 4","Info 5"]
[{"$f":"'(808)'!A8","v":"Rain"},{"$f":"'(808)'!B8","v":"Drainage"},{"$f":"'(808)'!C8","v":"Country"},{"$f":"'(808)'!D8","v":"Numbers"},{"$f":"'(808)'!E8","v":"Weekends"}]
[]
["Calculations:","T1","T2","T3","T4","Num"]
["Calc 1",{"$f":"A$5*8.2*$F11","v":75.166666666666657},792.25666666666666,420.93333333333328,2674.43,{"$f":"ROW()/RANDBETWEEN(1,10)","v":3.6666666666666665}]
["Calc 2",24.599999999999998,259.28399999999999,137.75999999999996,875.26799999999992,1.2]
["Calc 3",38.071428571428569,401.27285714285716,213.2,1354.5814285714287,1.8571428571428572]
["Calc 4",35.875,378.1225,200.89999999999998,1276.4324999999999,1.75]
["Calc 5",43.928571428571431,463.00714285714281,245.99999999999994,1562.9785714285713,2.1428571428571428]
["Calc 6",32.800000000000004,345.71199999999999,183.67999999999998,1167.0240000000001,1.6]
["Calc 7",34.85,367.31899999999996,195.15999999999997,1239.963,1.7]
["Calc 8",41,432.14,229.59999999999997,1458.78,2]
["Calc 9",389.5,4105.33,2181.1999999999998,13858.41,19]
["Calc 10",58.571428571428569,617.34285714285716,327.99999999999994,2083.9714285714285,2.8571428571428572]
[]
["Other Info","Other Info","Other Info","Other Info","Other Info"]
[{"$f":"B11*0.0234","v":1.7588999999999999},18.538806000000001,9.8498399999999986,62.581662000000001,8.5800000000000001E-2]
[0.57563999999999993,6.0672455999999997,3.2235839999999993,20.481271199999998,2.8080000000000001E-2]
[0.89087142857142854,9.3897848571428586,4.98888,31.697205428571433,4.3457142857142861E-2]
[0.83947499999999997,8.8480664999999998,4.70106,29.868520499999999,4.095E-2]
[1.0279285714285715,10.834367142857142,5.7563999999999984,36.573698571428572,5.0142857142857142E-2]
[0.76752000000000009,8.0896608000000008,4.2981119999999997,27.308361600000005,3.7440000000000001E-2]
[0.81549000000000005,8.5952646000000001,4.566743999999999,29.015134199999999,3.9780000000000003E-2]
[0.95940000000000003,10.112076,5.3726399999999996,34.135452000000001,4.6800000000000001E-2]
[9.1143000000000001,96.064722000000003,51.040079999999996,324.28679399999999,0.4446]
[1.3705714285714286,14.445822857142858,7.6751999999999985,48.76493142857143,6.6857142857142865E-2]

{"sheet":"(809)","index":6,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Name","Number"]
["Phil",4]
["Tom",4]
["Phil",5]
["Tom",8]
["Sue",8]
["Chin",8]
["Sue",5]
[]
["Also see:"]
["Highline Excel Class 19: Advanced Filter Extract Data 9 Examples"]
["Excel Magic Trick 777.75: SUMPRODUCT Solves: SUMIF Won't Calculate From Closed "]
["Excel Magic Trick #249: Data Extract To New Workbook using Advanced Filter "]
["Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria) "]

{"sheet":"(809an)","index":7,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["See destination workbook file available for download:"]
["http://people.highline.edu/mgirvin/ExcelIsFun.htm"]

{"sheet":"(810)","index":8,"n_rows":91,"n_cols":4,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["Student","Score","Department","RANKIF"]
["Tameka Eastep",24,"Finance"]
["Noreen Bley",59,"Finance"]
["Hugh Vasques",11,"Operations"]
["Noemi Kinghorn",10,"Marketing"]
["Odessa Paille",40,"Operations"]
["Carlene Meisinger",91,"PolySci"]
["Selena Pulice",35,"PolySci"]
["Lonnie Plaisance",72,"Math"]
["Hugh Garceau",35,"Marketing"]
["Darren Elvin",47,"Operations"]
["Clinton Fiorillo",27,"PolySci"]
["Lonnie Coghlan",25,"Accounting"]
["Padmore",41,"Marketing"]
["Maricela Bitton",79,"PolySci"]
["Gay Berrian",90,"Operations"]
["Pearlie Weyandt",96,"Operations"]
["Mallory Huf",11,"Finance"]
["Tyrone Mattocks",80,"PolySci"]
["Mathew Geronimo",37,"Math"]
["Christian Ferranti",91,"Marketing"]
["Karina Riney",52,"Marketing"]
["Karina Luk",70,"PolySci"]
["Christian Dais",26,"Math"]
["Lance Granato",48,"Finance"]
["Guy Ratchford",39,"Marketing"]
["Chandra Otter",53,"Accounting"]
["Tania Weger",30,"Marketing"]
["Ted Immel",3,"Operations"]
["Tyrone Gess",14,"Accounting"]
["Roslyn Goudeau",72,"Operations"]
["Darryl Kinnaman",36,"Math"]
["Allan Delpriore",89,"Marketing"]
["Kenya Arceo",43,"Marketing"]
["Christian Hodak",62,"PolySci"]
["Hugh Bogert",70,"PolySci"]
["Jamie Wilmeth",100,"Operations"]
["Kelly Gaulin",95,"Math"]
["Zenteno",75,"Accounting"]
["Guy Dier",14,"Marketing"]
["Eve Salamanca",48,"Math"]
["Tabatha Milone",10,"Finance"]
["Kurt Naron",73,"Math"]
["Althea Laymon",88,"Math"]
["Kelly Faller",49,"Operations"]
["Melisa Thoreson",98,"Finance"]
["Neva Massaro",93,"Math"]
["Nelson Westling",99,"Finance"]
["Noreen Steuck",38,"Finance"]
["Lance Ferron",75,"Math"]
["Christian Reveles",43,"Marketing"]
["Penelope Holdaway",37,"PolySci"]
["Sofia Roesler",31,"Accounting"]
["Jessie Kucera",42,"Math"]
["Neil Knapik",66,"Finance"]
["Rae Orduno",12,"PolySci"]
["Christian Billingslea",15,"Finance"]
["Annabelle Fleener",97,"Accounting"]
["Cody Fiqueroa",56,"PolySci"]
["Hillary Kulik",96,"Accounting"]
["Jessie Stgelais",26,"Math"]
["Cody Filson",27,"Accounting"]
["Max Waynick",34,"Marketing"]
["Sharron Feist",89,"Operations"]
["Erik Savala",25,"Operations"]
["Jamie Helwig",49,"Accounting"]
["Dollie Mongeau",47,"Operations"]
["Roslyn Friedt",79,"PolySci"]
["Cody Crossett",12,"Accounting"]
["Ted Mariani",8,"PolySci"]
["Jessie Burges",64,"Marketing"]
["Tabatha Rossano",47,"Finance"]
["Louisa Larimore",8,"Accounting"]
["Clare Vannostrand",57,"PolySci"]
["Eve Bongiovanni",58,"Accounting"]
["Darryl Gulbranson",100,"Math"]
["Loraine Gilpatrick",78,"PolySci"]
["Emilia Stoneburner",22,"Math"]
["Allyson Pauline",29,"PolySci"]
["Zelma Aman",64,"Marketing"]
["Ted Alvidrez",40,"Math"]
["Lance Speller",4,"Accounting"]
["Christian Knoblock",20,"Operations"]
["Tameka Harner",26,"Accounting"]
["Jamie Smead",84,"Finance"]
["Kenya Robbs",50,"Marketing"]
["Zelma Saar",18,"Math"]
["Zelma Schrupp",1,"Marketing"]
["Althea Slinkard",90,"Operations"]
["Ted Hixenbaugh",44,"Finance"]
["Malinda Huppert",49,"Operations"]

{"sheet":"(810an)","index":9,"n_rows":91,"n_cols":4,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["Student","Score","Department","RANKIF"]
["Tameka Eastep",24,"Finance",{"$f":"SUMPRODUCT(--(C2=$C$2:$C$91),--(B2<$B$2:$B$91))+1","v":10}]
["Noreen Bley",59,"Finance",5]
["Hugh Vasques",11,"Operations",14]
["Noemi Kinghorn",10,"Marketing",15]
["Odessa Paille",40,"Operations",11]
["Carlene Meisinger",91,"PolySci",1]
["Selena Pulice",35,"PolySci",12]
["Lonnie Plaisance",72,"Math",7]
["Hugh Garceau",35,"Marketing",11]
["Darren Elvin",47,"Operations",9]
["Clinton Fiorillo",27,"PolySci",14]
["Lonnie Coghlan",25,"Accounting",10]
["Padmore",41,"Marketing",9]
["Maricela Bitton",79,"PolySci",3]
["Gay Berrian",90,"Operations",3]
["Pearlie Weyandt",96,"Operations",2]
["Mallory Huf",11,"Finance",12]
["Tyrone Mattocks",80,"PolySci",2]
["Mathew Geronimo",37,"Math",11]
["Christian Ferranti",91,"Marketing",1]
["Karina Riney",52,"Marketing",5]
["Karina Luk",70,"PolySci",6]
["Christian Dais",26,"Math",13]
["Lance Granato",48,"Finance",6]
["Guy Ratchford",39,"Marketing",10]
["Chandra Otter",53,"Accounting",5]
["Tania Weger",30,"Marketing",13]
["Ted Immel",3,"Operations",15]
["Tyrone Gess",14,"Accounting",11]
["Roslyn Goudeau",72,"Operations",6]
["Darryl Kinnaman",36,"Math",12]
["Allan Delpriore",89,"Marketing",2]
["Kenya Arceo",43,"Marketing",7]
["Christian Hodak",62,"PolySci",8]
["Hugh Bogert",70,"PolySci",6]
["Jamie Wilmeth",100,"Operations",1]
["Kelly Gaulin",95,"Math",2]
["Zenteno",75,"Accounting",3]
["Guy Dier",14,"Marketing",14]
["Eve Salamanca",48,"Math",8]
["Tabatha Milone",10,"Finance",13]
["Kurt Naron",73,"Math",6]
["Althea Laymon",88,"Math",4]
["Kelly Faller",49,"Operations",7]
["Melisa Thoreson",98,"Finance",2]
["Neva Massaro",93,"Math",3]
["Nelson Westling",99,"Finance",1]
["Noreen Steuck",38,"Finance",9]
["Lance Ferron",75,"Math",5]
["Christian Reveles",43,"Marketing",7]
["Penelope Holdaway",37,"PolySci",11]
["Sofia Roesler",31,"Accounting",7]
["Jessie Kucera",42,"Math",9]
["Neil Knapik",66,"Finance",4]
["Rae Orduno",12,"PolySci",15]
["Christian Billingslea",15,"Finance",11]
["Annabelle Fleener",97,"Accounting",1]
["Cody Fiqueroa",56,"PolySci",10]
["Hillary Kulik",96,"Accounting",2]
["Jessie Stgelais",26,"Math",13]
["Cody Filson",27,"Accounting",8]
["Max Waynick",34,"Marketing",12]
["Sharron Feist",89,"Operations",5]
["Erik Savala",25,"Operations",12]
["Jamie Helwig",49,"Accounting",{"$f":"SUMPRODUCT(--(C66=$C$2:$C$91),--(B66<$B$2:$B$91))+1","v":6}]
["Dollie Mongeau",47,"Operations",9]
["Roslyn Friedt",79,"PolySci",3]
["Cody Crossett",12,"Accounting",12]
["Ted Mariani",8,"PolySci",16]
["Jessie Burges",64,"Marketing",3]
["Tabatha Rossano",47,"Finance",7]
["Louisa Larimore",8,"Accounting",13]
["Clare Vannostrand",57,"PolySci",9]
["Eve Bongiovanni",58,"Accounting",4]
["Darryl Gulbranson",100,"Math",1]
["Loraine Gilpatrick",78,"PolySci",5]
["Emilia Stoneburner",22,"Math",15]
["Allyson Pauline",29,"PolySci",13]
["Zelma Aman",64,"Marketing",3]
["Ted Alvidrez",40,"Math",10]
["Lance Speller",4,"Accounting",14]
["Christian Knoblock",20,"Operations",13]
["Tameka Harner",26,"Accounting",9]
["Jamie Smead",84,"Finance",3]
["Kenya Robbs",50,"Marketing",6]
["Zelma Saar",18,"Math",16]
["Zelma Schrupp",1,"Marketing",16]
["Althea Slinkard",90,"Operations",3]
["Ted Hixenbaugh",44,"Finance",8]
["Malinda Huppert",49,"Operations",7]

{"sheet":"(811)","index":10,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Department"]
["Account",100,200,300,400,500,null,"Conditional Formatting Formula:"]
[1947,443.77,969.51,652.91,914.01,448.99,null,{"$f":"OR(AND(LOOKUP($B$13,$A$3:$A$7)=$A3,LOOKUP($C$13,$B$2:$F$2)=B$2),AND(LOOKUP($B$14,$A$3:$A$7)=$A3,LOOKUP($C$14,$B$2:$F$2)=B$2),AND(LOOKUP($B$15,$A$3:$A$7)=$A3,LOOKUP($C$15,$B$2:$F$2)=B$2),AND(LOOKUP($B$16,$A$3:$A$7)=$A3,LOOKUP($C$16,$B$2:$F$2)=B$2),AND(LOOKUP($B$17,$A$3:$A$7)=$A3,LOOKUP($C$17,$B$2:$F$2)=B$2),AND(LOOKUP($B$18,$A$3:$A$7)=$A3,LOOKUP($C$18,$B$2:$F$2)=B$2))","v":false},true,false,false,false]
[2240,645.41,413.39,686.03,341.49,799.64,null,true,true,true,false,false]
[2242,708.18,95.08,225.11,272.31,554.33000000000004,null,false,false,false,false,false]
[2639,849.45,52.08,759.91,739.21,812.24,null,false,false,false,false,true]
[6400,698.19,86.64,412.01,90.86,505.13,null,false,false,true,false,false]
[]
["Single Cell Total:"]
["Single Cell Total:",{"$f":"SUM(TRANSPOSE(INDIRECT(ADDRESS(MATCH(B13:B18,A3:A7,0)+2,MATCH(C13:C18,B2:F2,0)+1))))","v":3938.59}]
[null,null,null,null,null,"circledchicken at Mr Excel Message Board"]
["Add Data for:","Account","Department","Column Method",null,"http://www.mrexcel.com/forum/showthread.php?t=579897"]
[null,1947,200]
[null,2240,100]
[null,2240,200]
[null,2240,300]
[null,2639,500]
[null,6400,300]
[null,null,"Total"]

{"sheet":"(811an)","index":11,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Department"]
["Account",100,200,300,400,500,null,"Conditional Formatting Formula:"]
[1947,443.77,969.51,652.91,914.01,448.99,null,{"$f":"OR(AND(LOOKUP($B$13,$A$3:$A$7)=$A3,LOOKUP($C$13,$B$2:$F$2)=B$2),AND(LOOKUP($B$14,$A$3:$A$7)=$A3,LOOKUP($C$14,$B$2:$F$2)=B$2),AND(LOOKUP($B$15,$A$3:$A$7)=$A3,LOOKUP($C$15,$B$2:$F$2)=B$2),AND(LOOKUP($B$16,$A$3:$A$7)=$A3,LOOKUP($C$16,$B$2:$F$2)=B$2),AND(LOOKUP($B$17,$A$3:$A$7)=$A3,LOOKUP($C$17,$B$2:$F$2)=B$2),AND(LOOKUP($B$18,$A$3:$A$7)=$A3,LOOKUP($C$18,$B$2:$F$2)=B$2))","v":false},true,false,false,false]
[2240,645.41,413.39,686.03,341.49,799.64,null,true,true,true,false,false]
[2242,708.18,95.08,225.11,272.31,554.33000000000004,null,false,false,false,false,false]
[2639,849.45,52.08,759.91,739.21,812.24,null,false,false,false,false,true]
[6400,698.19,86.64,412.01,90.86,505.13,null,false,false,true,false,false]
[]
["Single Cell Total:",{"$f":"SUMPRODUCT(N(INDIRECT(ADDRESS(MATCH(B13:B18,A1:A7,0),MATCH(C13:C18,A2:F2,0)))))","v":3938.59},null,{"$f":"SUM(INDEX($B$3:$F$7,MATCH(B13:B18,$A$3:$A$7,0),MATCH(C13:C18,$B$2:$F$2,0)))","v":969.51}]
["Single Cell Total:",{"$f":"SUM(TRANSPOSE(INDIRECT(ADDRESS(MATCH(B13:B18,A3:A7,0)+2,MATCH(C13:C18,B2:F2,0)+1))))","v":3938.59}]
[null,null,null,null,null,"circledchicken at Mr Excel Message Board"]
["Add Data for:","Account","Department","Column Method",null,"http://www.mrexcel.com/forum/showthread.php?t=579897"]
[null,1947,200,{"$f":"INDEX($B$3:$F$7,MATCH(B13,$A$3:$A$7,0),MATCH(C13,$B$2:$F$2,0))","v":969.51}]
[null,2240,100,{"$f":"INDEX($B$3:$F$7,MATCH(B14,$A$3:$A$7,0),MATCH(C14,$B$2:$F$2,0))","v":645.41}]
[null,2240,200,413.39]
[null,2240,300,686.03]
[null,2639,500,812.24]
[null,6400,300,412.01]
[null,null,"Total",{"$f":"SUM(D13:D18)","v":3938.59}]