{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Array Formulas","Array Formulas (an)","Boolean","Boolean (an)","Count Weekends","Count Weekends (an)","Stock Return","Stock Return (an)","Array Functions","Array Functions (an)","Max Change","Max Change (an)","Count Unique","Count Unique (an)","Lookup Adding","Lookup Adding (an)","All Criteria","All Criteria (an)","Net Income","Net Income (an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Array Formulas","index":0,"n_rows":329,"n_cols":8,"rows_kept":329,"cut":false,"hidden":false,"merged":[]}
["Data in Excel"]
[1,"Numbers (including dates and times)",2]
[2,"Text or Words","rad"]
[3,"TRUE / FALSE",true]
[4,"Errors (including #NAME!, #DIV/0!)",{"$f":"1/0","v":{"$error":"#DIV/0!"}}]
[5,"Empty Cells"]
[6,"Formulas that deliver blanks",{"$f":"IF(ISERROR(C5),\"\",12)","v":""}]
[]
["Define Array: A collection of items/data in a range or an array (array syntax or stored in name or created by formula) "]
["Arrays syntax: curley brackets contain array, commas are for columns and semi-colons are for rows."]
["If a range or part of a formula is selected when in Edit Mode, the F9 key will evaluate and show the array syntax"]
[]
[null,null,"Product","Price",null,null,"Product","Price"]
[null,null,"Carlota",null,"1) range",null,"Bellen",22]
[null,null,{"$f":"C14","v":"Carlota"},null,"2) array syntax",null,"Carlota",20]
[null,null,"Carlota",null,"3) array stored in a name",null,"Quad",30]
[null,null,null,null,null,null,"Sunshine",19]
[]
["Array formulas: 1)  do operations (=,-,*,/,^,=,>,>=,<,<=,<>) on arrays instead of single items or 2) you give a function argument that is expecting 1 thing, more than one thing."]
["Array formulas will give you a #VALUE! Error, unless you use Ctrl + Shift + Enter"]
["Braces or Curly Brackets appear when you use Ctrl + Shift + Enter to visually indicate that the formula in the cell is an array formula"]
["4) If the operation is multiplying * for two arrays and then adding, then you can use the built in function SUMPRODUCT. The advantage is that this formula does not require Ctrl + Shift + Enter"]
[]
["Dates",null,"The arguments in these two functions are expecting a single value. When we give it more than one value, we creaet an array."]
["2010-05-09",null,"Count Mondays",null,"4) array created by formula"]
["2010-05-10",null,"Count Mondays",null,"WEEKDAY gives 1 for Sunday, 2 for Monday… 7 for Saturday. WEEKDAY calculates a bit faster than the TEXT function"]
["2010-05-11",null,"Count Mondays"," =SUMIF(WEEKDAY(A24:A27),2)"]
[{"$f":"A25+8","v":"2010-05-17"},null,null,"some functions like (SUMIF/S, COUNTIF/S…) can't handle arrays - their argument says 'range'."]
[null,null,null,"This means that a range can't handle an array, but an array can handle a range."]
[]
["You can convert TRUE and FALSE to 1 and 0 using *1, +0, /1, ^1, -- (double negative). Double Negative is the fastest calculating."]
[]
[null,null,"Count Mondays",null,"*1"]
[null,null,"Count Mondays",null,"/1"]
[null,null,"Count Mondays",null,"^1"]
[null,null,"Count Mondays",null,"+0"]
[]
[]
["Date","Sales","COGS",null,"We are doing an operation on an array therefore we are creating an array."]
["2010-05-09",166.14,96.361199999999997,null,"Total Profit"]
["2010-05-10",167.26,100.35599999999998]
["2010-05-11",121.76,69.403200000000012]
["2010-05-12",182.21,109.32600000000001,null,"Max Profit for one day"]
["2010-05-13",125.67,71.631900000000002,null,null,"Require Ctrl + Shift + Enter"]
["2010-05-14",137.5,67.375]
["2010-05-15",124.33,55.948500000000003,null,"Min Profit"]
["2010-05-16",161.87,84.172399999999996,null,null,"Require Ctrl + Shift + Enter"]
["2010-05-17",142.91999999999999,77.1768]
["2010-05-18",106.95,44.919000000000004,null,"Begin Date",{"$f":"A41","v":"2010-05-10"}]
[null,null,null,null,"End Date",{"$f":"A45","v":"2010-05-14"}]
[null,null,null,null,"Total Profit",null,"Boolean Logic ==> Next Sheet"]
[]
[]
["Location","Sample",null,null,"Standard Deviation"]
["Tacoma",2.87,null,"Oakland",null,"Require Ctrl + Shift + Enter"]
["Tacoma",0.02,null,"SF"]
["SF",2.06,null,"Tacoma"]
["Seattle",0.8,null,"Seattle"]
["Seattle",0.96,null,"Portland"]
["Tacoma",0.71]
["Portland",0.47]
["Tacoma",0.81]
["Tacoma",0.34]
["Seattle",0.85]
["Seattle",0.68]
["SF",2.09]
["Seattle",0.96]
["Oakland",0.63]
["Oakland",0.82]
["Oakland",0.86]
["SF",0.12]
["Seattle",2.97]
["Tacoma",0.4]
["Tacoma",0.52]
["Seattle",0.8]
["SF",2.1800000000000002]
["Oakland",0.64]
["Seattle",0.59]
["SF",0.88]
["Tacoma",0.06]
["Oakland",0.24]
["SF",1.86]
["Seattle",2.15]
["Oakland",0.42]
["Oakland",0.18]
["Seattle",0.12]
["Seattle",2.5099999999999998]
["Seattle",1.45]
["SF",1.97]
["Seattle",0.49]
["SF",0.55000000000000004]
["Seattle",2.15]
["Oakland",0.99]
["SF",0.11]
["Seattle",2.91]
["Seattle",0.01]
["SF",0.52]
["Portland",1.57]
["Tacoma",2.06]
["Seattle",0.18]
["Oakland",2.97]
["Oakland",1.79]
["Tacoma",0.59]
["SF",0.22]
["SF",1.27]
["SF",0.26]
["Oakland",0.3]
["Seattle",0.96]
["SF",2.1]
["Seattle",1.82]
["SF",1.41]
["SF",1.07]
["SF",2.15]
["Portland",1.87]
["Portland",0.25]
["Portland",1.82]
["Tacoma",0.62]
["Portland",2.72]
["Oakland",1.32]
["Seattle",0.75]
["SF",0.7]
["Tacoma",0.34]
["SF",0.44]
["Portland",0.68]
["Seattle",0.31]
["Seattle",0.19]
["Tacoma",1.82]
["Oakland",0.14000000000000001]
["Tacoma",0.09]
["Oakland",0.91]
["Seattle",0.82]
["SF",1.01]
["Portland",0.47]
["Tacoma",0.59]
["SF",2.2799999999999998]
["Seattle",1.57]
["Seattle",0.43]
["Seattle",2.67]
["Seattle",0.02]
["Seattle",0.65]
["Portland",2.35]
["Tacoma",0.52]
["SF",0.02]
["Seattle",0.56000000000000005]
["Seattle",0.95]
["Portland",1.06]
["SF",0.66]
["SF",2.75]
["Portland",0]
["Oakland",1.42]
["Tacoma",0.21]
["Oakland",0.63]
["Portland",0.5]
["Portland",1.1399999999999999]
["Portland",2.11]
["Seattle",0.78]
["Seattle",0.12]
["Portland",2.1]
["Oakland",0.65]
["Portland",1.82]
["Seattle",0.75]
["Portland",1.5]
["Portland",0.8]
["Seattle",0.96]
["Oakland",0.35]
["SF",2.81]
["Tacoma",0.71]
["SF",0.8]
["Tacoma",0.75]
["Oakland",1.56]
["Tacoma",0.2]
["Oakland",2.79]
["Portland",0.69]
["Tacoma",2.0299999999999998]
["Portland",1.69]
["Tacoma",0.33]
["Portland",0.94]
["Oakland",1.45]
["Seattle",0.45]
["Tacoma",0.73]
["Seattle",2.8]
["Tacoma",0.51]
["SF",0.78]
["Seattle",2.62]
["Portland",2.85]
["SF",1.0900000000000001]
["Seattle",1.41]
["Seattle",0.89]
["Portland",0.98]
["Seattle",2.41]
["Tacoma",7.0000000000000007E-2]
["SF",0.52]
["Oakland",0]
["Tacoma",0.45]
["Oakland",2.34]
["Tacoma",0.75]
["Oakland",0.6]
["Portland",0.86]
["Oakland",0.6]
["SF",2.42]
["Tacoma",0.77]
["SF",0.72]
["Oakland",0.59]
["Portland",2.96]
["SF",0.83]
["Portland",0.27]
["Seattle",2.91]
["SF",2.74]
["Seattle",0.61]
["SF",1.72]
["Oakland",0.82]
["Portland",1.73]
["SF",0.83]
["Seattle",2.88]
["Seattle",0.95]
["Portland",0.99]
["Portland",0.85]
["Portland",2.91]
["Seattle",0.04]
["Oakland",1.1599999999999999]
["Seattle",1.64]
["Tacoma",1.32]
["SF",2.11]
["Seattle",0.36]
["Oakland",0.91]
["SF",1.0900000000000001]
["Portland",0.27]
["SF",0.63]
["Seattle",0.87]
["Oakland",0.91]
["Portland",0.33]
["SF",0.99]
["Portland",0.75]
["SF",1.9]
["SF",1.76]
["Seattle",0.44]
["Seattle",1.67]
["Tacoma",0.28999999999999998]
["Portland",1.17]
["Portland",0.14000000000000001]
["Seattle",1.84]
["Tacoma",2.04]
["Tacoma",0.03]
["Tacoma",1.69]
["Portland",0.17]
["Oakland",0.08]
["Tacoma",0.12]
["Tacoma",0.75]
["Oakland",0.23]
["Oakland",0.2]
["Tacoma",0.25]
["Tacoma",0.87]
["Portland",0.61]
["Seattle",0.76]
["Portland",0.28000000000000003]
["Portland",1.29]
["Tacoma",1.79]
["SF",2.99]
["Portland",0.24]
["Portland",1.36]
["Seattle",2.52]
["Oakland",0.56999999999999995]
["SF",0.72]
["Portland",1.89]
["Portland",2.9]
["Portland",1.74]
["Tacoma",0.56999999999999995]
["Portland",0.67]
["Seattle",0.94]
["SF",0.82]
["Oakland",1.27]
["Tacoma",1.86]
["Tacoma",0.22]
["Tacoma",0.71]
["Oakland",0.38]
["SF",0.08]
["Oakland",0.95]
["Oakland",1.46]
["Seattle",1.25]
["Tacoma",0.46]
["Tacoma",2.86]
["Oakland",0.98]
["Seattle",0.47]
["Portland",0.89]
["Oakland",0.14000000000000001]
["SF",0.03]
["SF",1.21]
["SF",0.22]
["Oakland",0.95]
["SF",2.75]
["Tacoma",0.11]
["SF",0.7]
["SF",0.98]
["Oakland",1.02]
["Oakland",0.11]
["Tacoma",0.79]
["Oakland",0.75]
["Tacoma",2.63]
["Oakland",0.43]
["Tacoma",0.44]
["Tacoma",0.88]
["SF",0.77]
["Portland",1.55]
["Portland",0.78]
["Seattle",2.2999999999999998]
["Oakland",0.02]
["Seattle",0]
["Oakland",0.61]
["Portland",0.23]
["Portland",0.18]
["Oakland",1.63]
["Tacoma",0.28000000000000003]
["Seattle",0.1]
["Seattle",1.1100000000000001]
["SF",1.96]
["SF",0.16]
["SF",0.63]
["Oakland",0.55000000000000004]
["SF",0.38]
["Oakland",0.91]
["SF",1.1399999999999999]
["Tacoma",2.4500000000000002]
["SF",0.52]
["SF",0.24]
["Seattle",2.6]
["Seattle",0.22]
["Tacoma",0.87]
["Tacoma",2.33]
["Portland",0.9]

{"sheet":"Array Formulas (an)","index":1,"n_rows":329,"n_cols":8,"rows_kept":329,"cut":false,"hidden":false,"merged":[]}
["Data in Excel"]
[1,"Numbers (including dates and times)",2]
[2,"Text or Words","rad"]
[3,"TRUE / FALSE",true]
[4,"Errors (including #NAME!, #DIV/0!)",{"$f":"1/0","v":{"$error":"#DIV/0!"}}]
[5,"Empty Cells"]
[6,"Formulas that deliver blanks",{"$f":"IF(ISERROR(C5),\"\",12)","v":""}]
[]
["Define Array: A collection of items/data in a range or an array (array syntax or stored in name or created by formula) "]
["Arrays syntax: curley brackets contain array, commas are for columns and semi-colons are for rows."]
["If a range or part of a formula is selected when in Edit Mode, the F9 key will evaluate and show the array syntax"]
[]
[null,null,"Product","Price",null,null,"Product","Price"]
[null,null,"Carlota",{"$f":"VLOOKUP(C14,$G$14:$H$17,2,0)","v":20},"1) range",null,"Bellen",22]
[null,null,{"$f":"C14","v":"Carlota"},{"$f":"VLOOKUP(C15,{\"Bellen\",22;\"Carlota\",20;\"Quad\",30;\"Sunshine\",19},2,0)","v":20},"2) array syntax",null,"Carlota",20]
[null,null,"Carlota",{"$f":"VLOOKUP(C16,PriceTable,2,0)","v":20},"3) array stored in a name",null,"Quad",30]
[null,null,null,null,null,null,"Sunshine",19]
[]
["Array formulas: 1)  do operations (=,-,*,/,^,=,>,>=,<,<=,<>) on arrays instead of single items or 2) you give a function argument that is expecting 1 thing, more than one thing."]
["Array formulas will give you a #VALUE! Error, unless you use Ctrl + Shift + Enter"]
["Braces or Curly Brackets appear when you use Ctrl + Shift + Enter to visually indicate that the formula in the cell is an array formula"]
["4) If the operation is multiplying * for two arrays and then adding, then you can use the built in function SUMPRODUCT. The advantage is that this formula does not require Ctrl + Shift + Enter"]
[]
["Dates",null,"The arguments in these two functions are expecting a single value. When we give it more than one value, we creaet an array."]
["2010-05-09",null,"Count Mondays",{"$f":"SUMPRODUCT(--(TEXT($A$25:$A$28,\"ddd\")=\"Mon\"))","v":2},"4) array created by formula"]
["2010-05-10",null,"Count Mondays",{"$f":"SUMPRODUCT(--(WEEKDAY(A25:A28)=2))","v":2},"WEEKDAY gives 1 for Sunday, 2 for Monday… 7 for Saturday. WEEKDAY calculates a bit faster than the TEXT function"]
["2010-05-11",null,"Count Mondays"," =SUMIF(WEEKDAY(A24:A27),2)"]
[{"$f":"A25+8","v":"2010-05-17"},null,null,"some functions like (SUMIF/S, COUNTIF/S…) can't handle arrays - their argument says 'range'."]
[null,null,null,"This means that a range can't handle an array, but an array can handle a range."]
[]
["You can convert TRUE and FALSE to 1 and 0 using *1, +0, /1, ^1, -- (double negative). Double Negative is the fastest calculating."]
[]
[null,null,"Count Mondays",{"$f":"SUMPRODUCT(1*(TEXT($A$25:$A$28,\"ddd\")=\"Mon\"))","v":2},"*1"]
[null,null,"Count Mondays",{"$f":"SUMPRODUCT((TEXT($A$25:$A$28,\"ddd\")=\"Mon\")/1)","v":2},"/1"]
[null,null,"Count Mondays",{"$f":"SUMPRODUCT((TEXT($A$25:$A$28,\"ddd\")=\"Mon\")^1)","v":2},"^1"]
[null,null,"Count Mondays",{"$f":"SUMPRODUCT((TEXT($A$25:$A$28,\"ddd\")=\"Mon\")+0)","v":2},"+0"]
[]
[]
["Date","Sales","COGS",null,"We are doing an operation on an array therefore we are creating an array."]
["2010-05-09",166.14,96.361199999999997,null,"Total Profit"]
["2010-05-10",167.26,100.35599999999998,null,{"$f":"SUMPRODUCT(B40:B49-C40:C49)","v":659.93999999999983}]
["2010-05-11",121.76,69.403200000000012]
["2010-05-12",182.21,109.32600000000001,null,"Max Profit for one day"]
["2010-05-13",125.67,71.631900000000002,null,{"$f":"MAX(B40:B49-C40:C49)","v":77.697600000000008},"Require Ctrl + Shift + Enter"]
["2010-05-14",137.5,67.375]
["2010-05-15",124.33,55.948500000000003,null,"Min Profit"]
["2010-05-16",161.87,84.172399999999996,null,{"$f":"MIN(B40:B49-C40:C49)","v":52.356799999999993},"Require Ctrl + Shift + Enter"]
["2010-05-17",142.91999999999999,77.1768]
["2010-05-18",106.95,44.919000000000004,null,"Begin Date",{"$f":"A41","v":"2010-05-10"}]
[null,null,null,null,"End Date",{"$f":"A45","v":"2010-05-14"}]
[null,null,null,null,"Total Profit",{"$f":"SUMPRODUCT(--(A40:A49>=F49),--(A40:A49<=F50),B40:B49-C40:C49)","v":316.30790000000002},"Boolean Logic ==> Next Sheet"]
[]
[]
["Location","Sample",null,null,"Standard Deviation"]
["Tacoma",2.87,null,"Oakland",{"$f":"STDEV(IF($A$55:$A$329=D55,$B$55:$B$329))","v":0.65554218096199424},"Require Ctrl + Shift + Enter"]
["Tacoma",0.02,null,"SF",{"$f":"STDEV(IF($A$55:$A$329=D56,$B$55:$B$329))","v":0.83739200216115073}]
["SF",2.06,null,"Tacoma",{"$f":"STDEV(IF($A$55:$A$329=D57,$B$55:$B$329))","v":0.79316208670800792}]
["Seattle",0.8,null,"Seattle",{"$f":"STDEV(IF($A$55:$A$329=D58,$B$55:$B$329))","v":0.90465359264549994}]
["Seattle",0.96,null,"Portland",{"$f":"STDEV(IF($A$55:$A$329=D59,$B$55:$B$329))","v":0.8288397749559433}]
["Tacoma",0.71]
["Portland",0.47]
["Tacoma",0.81]
["Tacoma",0.34]
["Seattle",0.85]
["Seattle",0.68]
["SF",2.09]
["Seattle",0.96]
["Oakland",0.63]
["Oakland",0.82]
["Oakland",0.86]
["SF",0.12]
["Seattle",2.97]
["Tacoma",0.4]
["Tacoma",0.52]
["Seattle",0.8]
["SF",2.1800000000000002]
["Oakland",0.64]
["Seattle",0.59]
["SF",0.88]
["Tacoma",0.06]
["Oakland",0.24]
["SF",1.86]
["Seattle",2.15]
["Oakland",0.42]
["Oakland",0.18]
["Seattle",0.12]
["Seattle",2.5099999999999998]
["Seattle",1.45]
["SF",1.97]
["Seattle",0.49]
["SF",0.55000000000000004]
["Seattle",2.15]
["Oakland",0.99]
["SF",0.11]
["Seattle",2.91]
["Seattle",0.01]
["SF",0.52]
["Portland",1.57]
["Tacoma",2.06]
["Seattle",0.18]
["Oakland",2.97]
["Oakland",1.79]
["Tacoma",0.59]
["SF",0.22]
["SF",1.27]
["SF",0.26]
["Oakland",0.3]
["Seattle",0.96]
["SF",2.1]
["Seattle",1.82]
["SF",1.41]
["SF",1.07]
["SF",2.15]
["Portland",1.87]
["Portland",0.25]
["Portland",1.82]
["Tacoma",0.62]
["Portland",2.72]
["Oakland",1.32]
["Seattle",0.75]
["SF",0.7]
["Tacoma",0.34]
["SF",0.44]
["Portland",0.68]
["Seattle",0.31]
["Seattle",0.19]
["Tacoma",1.82]
["Oakland",0.14000000000000001]
["Tacoma",0.09]
["Oakland",0.91]
["Seattle",0.82]
["SF",1.01]
["Portland",0.47]
["Tacoma",0.59]
["SF",2.2799999999999998]
["Seattle",1.57]
["Seattle",0.43]
["Seattle",2.67]
["Seattle",0.02]
["Seattle",0.65]
["Portland",2.35]
["Tacoma",0.52]
["SF",0.02]
["Seattle",0.56000000000000005]
["Seattle",0.95]
["Portland",1.06]
["SF",0.66]
["SF",2.75]
["Portland",0]
["Oakland",1.42]
["Tacoma",0.21]
["Oakland",0.63]
["Portland",0.5]
["Portland",1.1399999999999999]
["Portland",2.11]
["Seattle",0.78]
["Seattle",0.12]
["Portland",2.1]
["Oakland",0.65]
["Portland",1.82]
["Seattle",0.75]
["Portland",1.5]
["Portland",0.8]
["Seattle",0.96]
["Oakland",0.35]
["SF",2.81]
["Tacoma",0.71]
["SF",0.8]
["Tacoma",0.75]
["Oakland",1.56]
["Tacoma",0.2]
["Oakland",2.79]
["Portland",0.69]
["Tacoma",2.0299999999999998]
["Portland",1.69]
["Tacoma",0.33]
["Portland",0.94]
["Oakland",1.45]
["Seattle",0.45]
["Tacoma",0.73]
["Seattle",2.8]
["Tacoma",0.51]
["SF",0.78]
["Seattle",2.62]
["Portland",2.85]
["SF",1.0900000000000001]
["Seattle",1.41]
["Seattle",0.89]
["Portland",0.98]
["Seattle",2.41]
["Tacoma",7.0000000000000007E-2]
["SF",0.52]
["Oakland",0]
["Tacoma",0.45]
["Oakland",2.34]
["Tacoma",0.75]
["Oakland",0.6]
["Portland",0.86]
["Oakland",0.6]
["SF",2.42]
["Tacoma",0.77]
["SF",0.72]
["Oakland",0.59]
["Portland",2.96]
["SF",0.83]
["Portland",0.27]
["Seattle",2.91]
["SF",2.74]
["Seattle",0.61]
["SF",1.72]
["Oakland",0.82]
["Portland",1.73]
["SF",0.83]
["Seattle",2.88]
["Seattle",0.95]
["Portland",0.99]
["Portland",0.85]
["Portland",2.91]
["Seattle",0.04]
["Oakland",1.1599999999999999]
["Seattle",1.64]
["Tacoma",1.32]
["SF",2.11]
["Seattle",0.36]
["Oakland",0.91]
["SF",1.0900000000000001]
["Portland",0.27]
["SF",0.63]
["Seattle",0.87]
["Oakland",0.91]
["Portland",0.33]
["SF",0.99]
["Portland",0.75]
["SF",1.9]
["SF",1.76]
["Seattle",0.44]
["Seattle",1.67]
["Tacoma",0.28999999999999998]
["Portland",1.17]
["Portland",0.14000000000000001]
["Seattle",1.84]
["Tacoma",2.04]
["Tacoma",0.03]
["Tacoma",1.69]
["Portland",0.17]
["Oakland",0.08]
["Tacoma",0.12]
["Tacoma",0.75]
["Oakland",0.23]
["Oakland",0.2]
["Tacoma",0.25]
["Tacoma",0.87]
["Portland",0.61]
["Seattle",0.76]
["Portland",0.28000000000000003]
["Portland",1.29]
["Tacoma",1.79]
["SF",2.99]
["Portland",0.24]
["Portland",1.36]
["Seattle",2.52]
["Oakland",0.56999999999999995]
["SF",0.72]
["Portland",1.89]
["Portland",2.9]
["Portland",1.74]
["Tacoma",0.56999999999999995]
["Portland",0.67]
["Seattle",0.94]
["SF",0.82]
["Oakland",1.27]
["Tacoma",1.86]
["Tacoma",0.22]
["Tacoma",0.71]
["Oakland",0.38]
["SF",0.08]
["Oakland",0.95]
["Oakland",1.46]
["Seattle",1.25]
["Tacoma",0.46]
["Tacoma",2.86]
["Oakland",0.98]
["Seattle",0.47]
["Portland",0.89]
["Oakland",0.14000000000000001]
["SF",0.03]
["SF",1.21]
["SF",0.22]
["Oakland",0.95]
["SF",2.75]
["Tacoma",0.11]
["SF",0.7]
["SF",0.98]
["Oakland",1.02]
["Oakland",0.11]
["Tacoma",0.79]
["Oakland",0.75]
["Tacoma",2.63]
["Oakland",0.43]
["Tacoma",0.44]
["Tacoma",0.88]
["SF",0.77]
["Portland",1.55]
["Portland",0.78]
["Seattle",2.2999999999999998]
["Oakland",0.02]
["Seattle",0]
["Oakland",0.61]
["Portland",0.23]
["Portland",0.18]
["Oakland",1.63]
["Tacoma",0.28000000000000003]
["Seattle",0.1]
["Seattle",1.1100000000000001]
["SF",1.96]
["SF",0.16]
["SF",0.63]
["Oakland",0.55000000000000004]
["SF",0.38]
["Oakland",0.91]
["SF",1.1399999999999999]
["Tacoma",2.4500000000000002]
["SF",0.52]
["SF",0.24]
["Seattle",2.6]
["Seattle",0.22]
["Tacoma",0.87]
["Tacoma",2.33]
["Portland",0.9]

{"sheet":"Boolean","index":2,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["BOOLEAN Logic:",null,null,"Date","Units","Product",null,"Year/Product","P1","P2"]
["TRUE = 1",null,null,"2010-07-10",74002,"P2",null,2010]
["FALSE = 0",null,null,"2010-07-10",67655,"P1",null,2011]
["AND = *",null,null,"2010-08-10",56053,"P2"]
["OR = +",null,null,"2010-08-10",68535,"P1",null,null," =SUMPRODUCT(--(YEAR($D$2:$D$19)=$D23),--($F$2:$F$19=E$22),$E$2:$E$19)"]
["If the calculation result is non-zero, the answer is TRUE",null,null,"2010-09-10",62429,"P2",null,null," --({TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}),--({FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE}),{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
["If the calculation result = 0, the answer is FALSE",null,null,"2010-09-10",66272,"P1",null,null," {1;1;1;1;1;1;1;1;1;1;1;1;0;0;0;0;0;0},{0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1},{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[null,null,null,"2010-10-10",72335,"P2",null,null," {1;1;1;1;1;1;1;1;1;1;1;1;0;0;0;0;0;0}*{0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
["AND BOOLEAN logic","OR BOOLEAN logic",null,"2010-10-10",56837,"P1",null,null," {0;1;0;1;0;1;0;1;0;1;0;1;0;0;0;0;0;0}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[{"$f":"A19&\"*\"&B19&\" = \"&A15&\"*\"&B15&\" = \"&A15*B15&\" = \"&IF((A15=1)*(B15=1)=1,\"TRUE\",\"FALSE\")","v":"TRUE*TRUE = 1*1 = 1 = TRUE"},{"$f":"A19&\"+\"&B19&\" = \"&A15&\"+\"&B15&\"= \"&A15+B15&\" = \"&(A15=1)+(B15=1)&\" = \"&IF((A15=1)+(B15=1)<>0,\"TRUE\",\"FALSE\")","v":"TRUE+TRUE = 1+1= 2 = 2 = TRUE"},null,"2010-11-10",57975,"P2",null,null," {0;1;0;1;0;1;0;1;0;1;0;1;0;0;0;0;0;0}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[{"$f":"A20&\"*\"&B20&\" = \"&A16&\"*\"&B16&\" = \"&A16*B16&\" = \"&IF((A16=1)*(B16=1)=1,\"TRUE\",\"FALSE\")","v":"TRUE*FALSE = 1*0 = 0 = FALSE"},{"$f":"A20&\"+\"&B20&\" = \"&A16&\"+\"&B16&\"= \"&A16+B16&\" = \"&(A16=1)+(B16=1)&\" = \"&IF((A16=1)+(B16=1)<>0,\"TRUE\",\"FALSE\")","v":"TRUE+FALSE = 1+0= 1 = 1 = TRUE"},null,"2010-11-10",69091,"P1",null,null,"{0;67655;0;68535;0;66272;0;56837;0;69091;0;61401;0;0;0;0;0;0}"]
[{"$f":"A21&\"*\"&B21&\" = \"&A17&\"*\"&B17&\" = \"&A17*B17&\" = \"&IF((A17=1)*(B17=1)=1,\"TRUE\",\"FALSE\")","v":"FALSE*TRUE = 0*1 = 0 = FALSE"},{"$f":"A21&\"+\"&B21&\" = \"&A17&\"+\"&B17&\"= \"&A17+B17&\" = \"&(A17=1)+(B17=1)&\" = \"&IF((A17=1)+(B17=1)<>0,\"TRUE\",\"FALSE\")","v":"FALSE+TRUE = 0+1= 1 = 1 = TRUE"},null,"2010-12-10",86382,"P2"]
[{"$f":"A22&\"*\"&B22&\" = \"&A18&\"*\"&B18&\" = \"&A18*B18&\" = \"&IF((A18=1)*(B18=1)=1,\"TRUE\",\"FALSE\")","v":"FALSE*FALSE = 0*0 = 0 = FALSE"},{"$f":"A22&\"+\"&B22&\" = \"&A18&\"+\"&B18&\"= \"&A18+B18&\" = \"&(A18=1)+(B18=1)&\" = \"&IF((A18=1)+(B18=1)<>0,\"TRUE\",\"FALSE\")","v":"FALSE+FALSE = 0+0= 0 = 0 = FALSE"},null,"2010-12-10",61401,"P1"]
[null,null,null,"2011-01-10",82987,"P2"]
[1,1,null,"2011-01-10",53824,"P1"]
[1,0,null,"2011-02-10",54733,"P2"]
[0,1,null,"2011-02-10",51948,"P1"]
[0,0,null,"2011-03-10",79291,"P2"]
[{"$f":"A15=1","v":true},true,null,"2011-03-10",62134,"P1"]
[true,false]
[false,true]
[false,false]

{"sheet":"Boolean (an)","index":3,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["BOOLEAN Logic:",null,null,"Date","Units","Product",null,"Year/Product","P1","P2"]
["TRUE = 1",null,null,"2010-07-10",74002,"P2",null,2010,{"$f":"SUMPRODUCT(--(YEAR($D$2:$D$19)=$H2),--($F$2:$F$19=I$1),$E$2:$E$19)","v":389791},{"$f":"SUMPRODUCT(--(YEAR($D$2:$D$19)=$H2),--($F$2:$F$19=J$1),$E$2:$E$19)","v":409176}]
["FALSE = 0",null,null,"2010-07-10",67655,"P1",null,2011,{"$f":"SUMPRODUCT(--(YEAR($D$2:$D$19)=$H3),--($F$2:$F$19=I$1),$E$2:$E$19)","v":167906},{"$f":"SUMPRODUCT(--(YEAR($D$2:$D$19)=$H3),--($F$2:$F$19=J$1),$E$2:$E$19)","v":217011}]
["AND = *",null,null,"2010-08-10",56053,"P2"]
["OR = +",null,null,"2010-08-10",68535,"P1",null,null," =SUMPRODUCT(--(YEAR($D$2:$D$19)=$D23),--($F$2:$F$19=E$22),$E$2:$E$19)"]
["If the calculation result is non-zero, the answer is TRUE",null,null,"2010-09-10",62429,"P2",null,null," --({TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}),--({FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE}),{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
["If the calculation result = 0, the answer is FALSE",null,null,"2010-09-10",66272,"P1",null,null," {1;1;1;1;1;1;1;1;1;1;1;1;0;0;0;0;0;0},{0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1},{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[null,null,null,"2010-10-10",72335,"P2",null,null," {1;1;1;1;1;1;1;1;1;1;1;1;0;0;0;0;0;0}*{0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
["AND BOOLEAN logic","OR BOOLEAN logic",null,"2010-10-10",56837,"P1",null,null," {0;1;0;1;0;1;0;1;0;1;0;1;0;0;0;0;0;0}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[{"$f":"A19&\"*\"&B19&\" = \"&A15&\"*\"&B15&\" = \"&A15*B15&\" = \"&IF((A15=1)*(B15=1)=1,\"TRUE\",\"FALSE\")","v":"TRUE*TRUE = 1*1 = 1 = TRUE"},{"$f":"A19&\"+\"&B19&\" = \"&A15&\"+\"&B15&\"= \"&A15+B15&\" = \"&(A15=1)+(B15=1)&\" = \"&IF((A15=1)+(B15=1)<>0,\"TRUE\",\"FALSE\")","v":"TRUE+TRUE = 1+1= 2 = 2 = TRUE"},null,"2010-11-10",57975,"P2",null,null," {0;1;0;1;0;1;0;1;0;1;0;1;0;0;0;0;0;0}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[{"$f":"A20&\"*\"&B20&\" = \"&A16&\"*\"&B16&\" = \"&A16*B16&\" = \"&IF((A16=1)*(B16=1)=1,\"TRUE\",\"FALSE\")","v":"TRUE*FALSE = 1*0 = 0 = FALSE"},{"$f":"A20&\"+\"&B20&\" = \"&A16&\"+\"&B16&\"= \"&A16+B16&\" = \"&(A16=1)+(B16=1)&\" = \"&IF((A16=1)+(B16=1)<>0,\"TRUE\",\"FALSE\")","v":"TRUE+FALSE = 1+0= 1 = 1 = TRUE"},null,"2010-11-10",69091,"P1",null,null,"{0;67655;0;68535;0;66272;0;56837;0;69091;0;61401;0;0;0;0;0;0}"]
[{"$f":"A21&\"*\"&B21&\" = \"&A17&\"*\"&B17&\" = \"&A17*B17&\" = \"&IF((A17=1)*(B17=1)=1,\"TRUE\",\"FALSE\")","v":"FALSE*TRUE = 0*1 = 0 = FALSE"},{"$f":"A21&\"+\"&B21&\" = \"&A17&\"+\"&B17&\"= \"&A17+B17&\" = \"&(A17=1)+(B17=1)&\" = \"&IF((A17=1)+(B17=1)<>0,\"TRUE\",\"FALSE\")","v":"FALSE+TRUE = 0+1= 1 = 1 = TRUE"},null,"2010-12-10",86382,"P2"]
[{"$f":"A22&\"*\"&B22&\" = \"&A18&\"*\"&B18&\" = \"&A18*B18&\" = \"&IF((A18=1)*(B18=1)=1,\"TRUE\",\"FALSE\")","v":"FALSE*FALSE = 0*0 = 0 = FALSE"},{"$f":"A22&\"+\"&B22&\" = \"&A18&\"+\"&B18&\"= \"&A18+B18&\" = \"&(A18=1)+(B18=1)&\" = \"&IF((A18=1)+(B18=1)<>0,\"TRUE\",\"FALSE\")","v":"FALSE+FALSE = 0+0= 0 = 0 = FALSE"},null,"2010-12-10",61401,"P1"]
[null,null,null,"2011-01-10",82987,"P2"]
[1,1,null,"2011-01-10",53824,"P1"]
[1,0,null,"2011-02-10",54733,"P2"]
[0,1,null,"2011-02-10",51948,"P1"]
[0,0,null,"2011-03-10",79291,"P2"]
[{"$f":"A15=1","v":true},true,null,"2011-03-10",62134,"P1"]
[true,false]
[false,true]
[false,false]

{"sheet":"Count Weekends","index":4,"n_rows":106,"n_cols":7,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"WEEKDAY default: Sunday = 1 to Sat = 7"]
["Date",null,"Criteria 1","Tue",{"$f":"VLOOKUP(D3,{\"Sun\",1;\"Mon\",2;\"Tue\",3;\"Wed\",4;\"Thu\",5;\"Fri\",6;\"Sat\",7},2,0)","v":3}]
["2009-11-14",null,"Criteria 2","Mon",{"$f":"VLOOKUP(D4,{\"Sun\",1;\"Mon\",2;\"Tue\",3;\"Wed\",4;\"Thu\",5;\"Fri\",6;\"Sat\",7},2,0)","v":2},null,"*Categories are mutually exclusive (you can't have one date fit into both categories (just like dating))"]
["2009-11-15"]
["2009-11-16",null,"Count",null," >"," >"]
["2009-11-17",null,"Count",null,null,">"]
["2009-11-18",null,null,null,null,">"]
["2009-11-19",null,null," =SUMPRODUCT({FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE}+{FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE})"]
["2009-11-20",null,null," =SUMPRODUCT({0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0})"]
["2009-11-21"]
["2009-11-22",null,null,"Mini example:"]
["2009-11-23",null,null," =SUMPRODUCT({TRUE;FALSE;FALSE}+{FALSE;FALSE;TRUE})"]
["2009-11-24",null,null," =SUMPRODUCT(1+0  +  0+0  +  0+1)"]
["2009-11-25",null,null," =SUMPRODUCT(1  +  0  +  1)"]
["2009-11-26"]
["2009-11-27"]
["2009-11-28"]
["2009-11-29"]
["2009-11-30"]
["2009-12-01"]
["2009-12-02"]
["2009-12-03"]
["2009-12-04"]
["2009-12-05"]
["2009-12-06"]
["2009-12-07"]
["2009-12-08"]
["2009-12-09"]
["2009-12-10"]
["2009-12-11"]
["2009-12-12"]
["2009-12-13"]
["2009-12-14"]
["2009-12-15"]
["2009-12-16"]
["2009-12-17"]
["2009-12-18"]
["2009-12-19"]
["2009-12-20"]
["2009-12-21"]
["2009-12-22"]
["2009-12-23"]
["2009-12-24"]
["2009-12-25"]
["2009-12-26"]
["2009-12-27"]
["2009-12-28"]
["2009-12-29"]
["2009-12-30"]
["2009-12-31"]
["2010-01-01"]
["2010-01-02"]
["2010-01-03"]
["2010-01-04"]
["2010-01-05"]
["2010-01-06"]
["2010-01-07"]
["2010-01-08"]
["2010-01-09"]
["2010-01-10"]
["2010-01-11"]
["2010-01-12"]
["2010-01-13"]
["2010-01-14"]
["2010-01-15"]
["2010-01-16"]
["2010-01-17"]
["2010-01-18"]
["2010-01-19"]
["2010-01-20"]
["2010-01-21"]
["2010-01-22"]
["2010-01-23"]
["2010-01-24"]
["2010-01-25"]
["2010-01-26"]
["2010-01-27"]
["2010-01-28"]
["2010-01-29"]
["2010-01-30"]
["2010-01-31"]
["2010-02-01"]
["2010-02-02"]
["2010-02-03"]
["2010-02-04"]
["2010-02-05"]
["2010-02-06"]
["2010-02-07"]
["2010-02-08"]
["2010-02-09"]
["2010-02-10"]
["2010-02-11"]
["2010-02-12"]
["2010-02-13"]
["2010-02-14"]
["2010-02-15"]
["2010-02-16"]
["2010-02-17"]
["2010-02-18"]
["2010-02-19"]
["2010-02-20"]
["2010-02-21"]
["2010-02-22"]
["2010-02-23"]
["2010-02-24"]

{"sheet":"Count Weekends (an)","index":5,"n_rows":106,"n_cols":7,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"WEEKDAY default: Sunday = 1 to Sat = 7"]
["Date",null,"Criteria 1","Tue",{"$f":"VLOOKUP(D3,{\"Sun\",1;\"Mon\",2;\"Tue\",3;\"Wed\",4;\"Thu\",5;\"Fri\",6;\"Sat\",7},2,0)","v":3}]
["2009-11-14",null,"Criteria 2","Mon",{"$f":"VLOOKUP(D4,{\"Sun\",1;\"Mon\",2;\"Tue\",3;\"Wed\",4;\"Thu\",5;\"Fri\",6;\"Sat\",7},2,0)","v":2},null,"*Categories are mutually exclusive (you can't have one date fit into both categories (just like dating))"]
["2009-11-15"]
["2009-11-16",null,"Count",{"$f":"SUMPRODUCT((WEEKDAY(A4:A106)=E3)+(WEEKDAY(A4:A106)=E4))","v":30}," >"," >"]
["2009-11-17",null,"Count",{"$f":"SUMPRODUCT((TEXT(A4:A106,\"ddd\")=D3)+(TEXT(A4:A106,\"ddd\")=D4))","v":30},null,">"]
["2009-11-18",null,null,null,null,">"]
["2009-11-19",null,null," =SUMPRODUCT({FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE}+{FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE})"]
["2009-11-20",null,null," =SUMPRODUCT({0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0;0;0;0;0;1;1;0})"]
["2009-11-21"]
["2009-11-22",null,null,"Mini example:"]
["2009-11-23",null,null," =SUMPRODUCT({TRUE;FALSE;FALSE}+{FALSE;FALSE;TRUE})"]
["2009-11-24",null,null," =SUMPRODUCT(1+0  +  0+0  +  0+1)"]
["2009-11-25",null,null," =SUMPRODUCT(1  +  0  +  1)"]
["2009-11-26"]
["2009-11-27"]
["2009-11-28"]
["2009-11-29"]
["2009-11-30"]
["2009-12-01"]
["2009-12-02"]
["2009-12-03"]
["2009-12-04"]
["2009-12-05"]
["2009-12-06"]
["2009-12-07"]
["2009-12-08"]
["2009-12-09"]
["2009-12-10"]
["2009-12-11"]
["2009-12-12"]
["2009-12-13"]
["2009-12-14"]
["2009-12-15"]
["2009-12-16"]
["2009-12-17"]
["2009-12-18"]
["2009-12-19"]
["2009-12-20"]
["2009-12-21"]
["2009-12-22"]
["2009-12-23"]
["2009-12-24"]
["2009-12-25"]
["2009-12-26"]
["2009-12-27"]
["2009-12-28"]
["2009-12-29"]
["2009-12-30"]
["2009-12-31"]
["2010-01-01"]
["2010-01-02"]
["2010-01-03"]
["2010-01-04"]
["2010-01-05"]
["2010-01-06"]
["2010-01-07"]
["2010-01-08"]
["2010-01-09"]
["2010-01-10"]
["2010-01-11"]
["2010-01-12"]
["2010-01-13"]
["2010-01-14"]
["2010-01-15"]
["2010-01-16"]
["2010-01-17"]
["2010-01-18"]
["2010-01-19"]
["2010-01-20"]
["2010-01-21"]
["2010-01-22"]
["2010-01-23"]
["2010-01-24"]
["2010-01-25"]
["2010-01-26"]
["2010-01-27"]
["2010-01-28"]
["2010-01-29"]
["2010-01-30"]
["2010-01-31"]
["2010-02-01"]
["2010-02-02"]
["2010-02-03"]
["2010-02-04"]
["2010-02-05"]
["2010-02-06"]
["2010-02-07"]
["2010-02-08"]
["2010-02-09"]
["2010-02-10"]
["2010-02-11"]
["2010-02-12"]
["2010-02-13"]
["2010-02-14"]
["2010-02-15"]
["2010-02-16"]
["2010-02-17"]
["2010-02-18"]
["2010-02-19"]
["2010-02-20"]
["2010-02-21"]
["2010-02-22"]
["2010-02-23"]
["2010-02-24"]

{"sheet":"Stock Return","index":6,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["State of Economy",{"$f":"\"Prob. Of \"&A1","v":"Prob. Of State of Economy"},"Stock A Return if State Occurs","Stock B Return if State Occurs","Stock C Return if State Occurs"]
["Weight","Weight",0.3,0.4,0.3]
["Boom",0.15,0.3,0.45,0.33]
["Good",0.45,0.12,0.1,0.15]
["Poor",0.35,0.01,-0.15,-0.05]
["Bust",0.05,-0.2,-0.3,-0.09]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Expected Return for Portfolio"]
[null,null,null,null,null,null,{"$f":"SUMPRODUCT(C3:E6,B3:B6,C2:E2)","v":{"$error":"#VALUE!"}},"SUMPRODUCT function can only handle arrays that"]
[null,null,null,null,null,null,null,"are the same size, so you must use * instead of"]
[null,null,null,null,null,null,null,"commas,"]

{"sheet":"Stock Return (an)","index":7,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["State of Economy",{"$f":"\"Prob. Of \"&A1","v":"Prob. Of State of Economy"},"Stock A Return if State Occurs","Stock B Return if State Occurs","Stock C Return if State Occurs"]
["Weight","Weight",0.3,0.4,0.3]
["Boom",0.15,0.3,0.45,0.33]
["Good",0.45,0.12,0.1,0.15]
["Poor",0.35,0.01,-0.15,-0.05]
["Bust",0.05,-0.2,-0.3,-0.09]
[]
[null,null,{"$f":"$B3*C3*C$2","v":1.35E-2},2.7000000000000003E-2,1.485E-2]
[null,null,1.6199999999999999E-2,1.8000000000000002E-2,2.0250000000000001E-2]
[null,null,1.0499999999999999E-3,-2.1000000000000001E-2,-5.2499999999999995E-3]
[null,null,-3.0000000000000005E-3,-6.0000000000000001E-3,-1.3499999999999999E-3]
[null,null,null,null,{"$f":"SUM(C8:E11)","v":7.4249999999999983E-2}]
[]
[null,null,null,"Expected Return for Portfolio",null,null,{"$f":"SUMPRODUCT(C3:E6*B3:B6*C2:E2)","v":7.4249999999999983E-2}]
[null,null,null,null,null,null,{"$f":"SUMPRODUCT(C3:E6,B3:B6,C2:E2)","v":{"$error":"#VALUE!"}},"SUMPRODUCT function can only handle arrays that"]
[null,null,null,null,null,null,null,"are the same size, so you must use * instead of"]
[null,null,null,null,null,null,null,"commas,"]

{"sheet":"Array Functions","index":8,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["TRANSPOSE"]
[]
["Product","Price"]
["Bellen",22]
["Carlota",20]
["Quad",30]
["Sunshine",19]
[]
[]
["FREQUENCY"]
["Upper End is included in count. List of upper end is called bins_array"]
[]
["Upper","Category","Frequency",null,null,"Scores"]
[10,{"$f":"\"x <= \"&A14","v":"x <= 10"},null,null,null,9]
[20,{"$f":"A14&\" < x <= \"&A15","v":"10 < x <= 20"},null,null,null,10]
[30,{"$f":"A15&\" < x <= \"&A16","v":"20 < x <= 30"},null,null,null,50]
[40,"30 < x <= 40",null,null,null,40]
[50,"40 < x <= 50",null,null,null,30]
[null,null,null,null,null,41]
[null,null,null,null,null,32]
[null,null,null,null,null,45]
[null,null,null,null,null,19]

{"sheet":"Array Functions (an)","index":9,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["TRANSPOSE"]
[]
["Product","Price",null,{"$f":"TRANSPOSE(A3:B7)","v":"Product"},"Bellen","Carlota","Quad","Sunshine"]
["Bellen",22,null,"Price",22,20,30,19]
["Carlota",20]
["Quad",30]
["Sunshine",19]
[]
[]
["FREQUENCY"]
["Upper End is included in count. List of upper end is called bins_array"]
[]
["Upper","Category","Frequency",null,null,"Scores"]
[10,{"$f":"\"x <= \"&A14","v":"x <= 10"},{"$f":"FREQUENCY(F14:F22,A14:A18)","v":2},null,null,9]
[20,{"$f":"A14&\" < x <= \"&A15","v":"10 < x <= 20"},1,null,null,10]
[30,{"$f":"A15&\" < x <= \"&A16","v":"20 < x <= 30"},1,null,null,50]
[40,"30 < x <= 40",2,null,null,40]
[50,"40 < x <= 50",3,null,null,30]
[null,null,null,null,null,41]
[null,null,null,null,null,32]
[null,null,null,null,null,45]
[null,null,null,null,null,19]

{"sheet":"Max Change","index":10,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales 2008","Sales 2009","Name"]
[69979,100000,"Suix"]
[92964,101998,"Fred"]
[79522,85916,"Chin"]
[80956,81000,"Ali"]
[90906,99368,"Jeff"]
[]
[]
[null,"Max Improvement"]
[null,"Name",{"$f":"IF(C9=\"\",\"\",INDEX(C2:C6,MATCH(C9,B2:B6-A2:A6,0)))","v":""}]

{"sheet":"Max Change (an)","index":11,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales 2008","Sales 2009","Name"]
[69979,100000,"Suix"]
[92964,101998,"Fred"]
[79522,85916,"Chin"]
[80956,81000,"Ali"]
[90906,99368,"Jeff"]
[]
[]
[null,"Max Improvement",{"$f":"MAX(B2:B6-A2:A6)","v":30021}]
[null,"Name",{"$f":"IF(C9=\"\",\"\",INDEX(C2:C6,MATCH(C9,B2:B6-A2:A6,0)))","v":"Suix"}]

{"sheet":"Count Unique","index":12,"n_rows":103,"n_cols":5,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["Date","SR","Sales",null,"How many SR made sales this period?"]
["2010-05-13","SR3",277.27999999999997,null,"Count Unique"]
["2010-05-15","SR16",265.93]
["2010-05-11","SR2",239.51]
["2010-05-23","SR14",211.54,null,"Count Unique Dates We Had Sales"]
["2010-05-27","SR6",225.33]
["2010-05-27","SR16",248.16]
["2010-05-12","SR14",235.4]
["2010-05-09","SR16",286.23]
["2010-05-18","SR10",253.9]
["2010-05-22","SR13",244.78]
["2010-05-21","SR10",243.01]
["2010-05-11","SR16",297.44]
["2010-05-27","SR14",216.23]
["2010-05-15","SR11",209.08]
["2010-05-17","SR11",276.94]
["2010-05-16","SR12",244.24]
["2010-05-24","SR15",216.69]
["2010-05-18","SR6",225.21]
["2010-05-16","SR13",247.57]
["2010-05-12","SR13",241.66]
["2010-05-22","SR15",201.05]
["2010-05-16","SR1",244.42]
["2010-05-14","SR1",215.74]
["2010-05-25","SR10",200.5]
["2010-05-28","SR10",241.69]
["2010-05-11","SR7",253.82]
["2010-05-17","SR1",237.06]
["2010-05-10","SR11",279.18]
["2010-05-09","SR10",231.04]
["2010-05-14","SR11",252.24]
["2010-05-24","SR4",240.37]
["2010-05-16","SR17",259.58999999999997]
["2010-05-13","SR10",229.03]
["2010-05-24","SR13",255.51]
["2010-05-17","SR8",257.02999999999997]
["2010-05-28","SR8",250.21]
["2010-05-28","SR10",200.49]
["2010-05-26","SR2",231.52]
["2010-05-22","SR14",287.41000000000003]
["2010-05-10","SR4",289.83]
["2010-05-19","SR9",296.27999999999997]
["2010-05-28","SR15",286.98]
["2010-05-17","SR4",212.5]
["2010-05-11","SR14",282.37]
["2010-05-27","SR8",206.85]
["2010-05-20","SR17",207.51]
["2010-05-27","SR14",231.99]
["2010-05-16","SR4",237.94]
["2010-05-15","SR2",208.1]
["2010-05-12","SR10",259.77]
["2010-05-22","SR16",269.54000000000002]
["2010-05-14","SR15",265.11]
["2010-05-19","SR16",224.53]
["2010-05-18","SR17",266.33999999999997]
["2010-05-20","SR17",237.24]
["2010-05-21","SR6",222.67]
["2010-05-24","SR9",259.92]
["2010-05-12","SR3",281.58]
["2010-05-25","SR3",298.82]
["2010-05-17","SR8",288.98]
["2010-05-13","SR9",265.23]
["2010-05-18","SR10",231.8]
["2010-05-12","SR6",240.72]
["2010-05-27","SR1",286.85000000000002]
["2010-05-26","SR1",242.66]
["2010-05-15","SR12",269.91000000000003]
["2010-05-18","SR8",249.83]
["2010-05-14","SR11",298.60000000000002]
["2010-05-10","SR17",215.94]
["2010-05-24","SR6",259.89999999999998]
["2010-05-14","SR15",213.17]
["2010-05-18","SR15",225.9]
["2010-05-26","SR8",290.60000000000002]
["2010-05-19","SR17",257.05]
["2010-05-20","SR9",269.13]
["2010-05-13","SR9",261.73]
["2010-05-24","SR16",230.95]
["2010-05-14","SR17",256.67]
["2010-05-16","SR5",252.54]
["2010-05-20","SR6",261.05]
["2010-05-24","SR15",211.05]
["2010-05-24","SR17",262.49]
["2010-05-13","SR5",287.60000000000002]
["2010-05-22","SR1",204.49]
["2010-05-11","SR4",259.93]
["2010-05-26","SR3",280.16000000000003]
["2010-05-21","SR15",279.12]
["2010-05-12","SR14",272.39999999999998]
["2010-05-09","SR14",245.82]
["2010-05-21","SR9",261.25]
["2010-05-16","SR15",222.16]
["2010-05-26","SR13",287.47000000000003]
["2010-05-09","SR7",277.04000000000002]
["2010-05-15","SR5",279.18]
["2010-05-20","SR5",208.76]
["2010-05-16","SR12",294.02999999999997]
["2010-05-11","SR4",292.26]
["2010-05-17","SR5",272.10000000000002]
["2010-05-25","SR6",254.14]
["2010-05-19","SR11",246.12]
["2010-05-15","SR6",281.16000000000003]
["2010-05-27","SR2",275.04000000000002]

{"sheet":"Count Unique (an)","index":13,"n_rows":103,"n_cols":5,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["Date","SR","Sales",null,"How many SR made sales this period?"]
["2010-05-13","SR3",277.27999999999997,null,"Count Unique"]
["2010-05-15","SR16",265.93,null,{"$f":"SUMPRODUCT(1/COUNTIF(B2:B103,B2:B103))","v":16.999999999999989}]
["2010-05-11","SR2",239.51]
["2010-05-23","SR14",211.54,null,"Count Unique Dates We Had Sales"]
["2010-05-27","SR6",225.33,null,{"$f":"SUMPRODUCT(1/COUNTIF(A2:A103,A2:A103))","v":19.999999999999989}]
["2010-05-27","SR16",248.16,null,{"$f":"SUMPRODUCT(--(FREQUENCY(A2:A103,A2:A103)>0))","v":20}]
["2010-05-12","SR14",235.4]
["2010-05-09","SR16",286.23]
["2010-05-18","SR10",253.9]
["2010-05-22","SR13",244.78]
["2010-05-21","SR10",243.01]
["2010-05-11","SR16",297.44]
["2010-05-27","SR14",216.23]
["2010-05-15","SR11",209.08]
["2010-05-17","SR11",276.94]
["2010-05-16","SR12",244.24]
["2010-05-24","SR15",216.69]
["2010-05-18","SR6",225.21]
["2010-05-16","SR13",247.57]
["2010-05-12","SR13",241.66]
["2010-05-22","SR15",201.05]
["2010-05-16","SR1",244.42]
["2010-05-14","SR1",215.74]
["2010-05-25","SR10",200.5]
["2010-05-28","SR10",241.69]
["2010-05-11","SR7",253.82]
["2010-05-17","SR1",237.06]
["2010-05-10","SR11",279.18]
["2010-05-09","SR10",231.04]
["2010-05-14","SR11",252.24]
["2010-05-24","SR4",240.37]
["2010-05-16","SR17",259.58999999999997]
["2010-05-13","SR10",229.03]
["2010-05-24","SR13",255.51]
["2010-05-17","SR8",257.02999999999997]
["2010-05-28","SR8",250.21]
["2010-05-28","SR10",200.49]
["2010-05-26","SR2",231.52]
["2010-05-22","SR14",287.41000000000003]
["2010-05-10","SR4",289.83]
["2010-05-19","SR9",296.27999999999997]
["2010-05-28","SR15",286.98]
["2010-05-17","SR4",212.5]
["2010-05-11","SR14",282.37]
["2010-05-27","SR8",206.85]
["2010-05-20","SR17",207.51]
["2010-05-27","SR14",231.99]
["2010-05-16","SR4",237.94]
["2010-05-15","SR2",208.1]
["2010-05-12","SR10",259.77]
["2010-05-22","SR16",269.54000000000002]
["2010-05-14","SR15",265.11]
["2010-05-19","SR16",224.53]
["2010-05-18","SR17",266.33999999999997]
["2010-05-20","SR17",237.24]
["2010-05-21","SR6",222.67]
["2010-05-24","SR9",259.92]
["2010-05-12","SR3",281.58]
["2010-05-25","SR3",298.82]
["2010-05-17","SR8",288.98]
["2010-05-13","SR9",265.23]
["2010-05-18","SR10",231.8]
["2010-05-12","SR6",240.72]
["2010-05-27","SR1",286.85000000000002]
["2010-05-26","SR1",242.66]
["2010-05-15","SR12",269.91000000000003]
["2010-05-18","SR8",249.83]
["2010-05-14","SR11",298.60000000000002]
["2010-05-10","SR17",215.94]
["2010-05-24","SR6",259.89999999999998]
["2010-05-14","SR15",213.17]
["2010-05-18","SR15",225.9]
["2010-05-26","SR8",290.60000000000002]
["2010-05-19","SR17",257.05]
["2010-05-20","SR9",269.13]
["2010-05-13","SR9",261.73]
["2010-05-24","SR16",230.95]
["2010-05-14","SR17",256.67]
["2010-05-16","SR5",252.54]
["2010-05-20","SR6",261.05]
["2010-05-24","SR15",211.05]
["2010-05-24","SR17",262.49]
["2010-05-13","SR5",287.60000000000002]
["2010-05-22","SR1",204.49]
["2010-05-11","SR4",259.93]
["2010-05-26","SR3",280.16000000000003]
["2010-05-21","SR15",279.12]
["2010-05-12","SR14",272.39999999999998]
["2010-05-09","SR14",245.82]
["2010-05-21","SR9",261.25]
["2010-05-16","SR15",222.16]
["2010-05-26","SR13",287.47000000000003]
["2010-05-09","SR7",277.04000000000002]
["2010-05-15","SR5",279.18]
["2010-05-20","SR5",208.76]
["2010-05-16","SR12",294.02999999999997]
["2010-05-11","SR4",292.26]
["2010-05-17","SR5",272.10000000000002]
["2010-05-25","SR6",254.14]
["2010-05-19","SR11",246.12]
["2010-05-15","SR6",281.16000000000003]
["2010-05-27","SR2",275.04000000000002]

{"sheet":"Lookup Adding","index":14,"n_rows":255,"n_cols":8,"rows_kept":255,"cut":false,"hidden":false,"merged":[]}
["Date","Product",null,null,"Total Sales",null,"Bellen",22]
["2010-05-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},null,null,null,null,"Quad",30]
["2010-05-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},null,null,null,null,"Sunshine",21]
["2010-05-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},null,null,"Total Sales",null,"Yanaki",20]
["2010-05-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-05-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-05-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-05-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-05-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-05-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-05-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-05-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-05-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-05-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-05-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-05-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-05-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-05-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-05-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-05-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-05-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-05-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-05-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-05-31",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-06-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-06-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-06-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-06-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-06-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-06-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-06-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-06-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-06-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-06-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-06-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-06-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-06-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-06-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-06-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-06-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-06-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-06-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-07-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-07-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-07-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-07-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-07-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-07-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-07-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-07-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-07-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-07-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-07-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-07-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-07-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-07-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-07-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-07-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-07-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-07-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-07-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-07-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-07-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-07-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-07-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-07-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-07-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-07-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-07-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-07-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-07-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-07-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-07-31",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-08-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-08-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-08-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-08-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-08-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-08-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-08-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-08-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-08-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-08-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-08-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-08-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-08-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-08-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-08-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-08-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-08-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-08-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-08-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-08-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-08-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-08-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-08-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-08-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-08-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-08-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-08-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-08-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-08-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-08-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-08-31",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-09-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-09-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-09-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-09-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-09-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-09-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-09-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-09-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-09-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-09-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-09-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-09-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-09-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-09-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-09-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-09-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-09-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-09-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-09-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-09-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-09-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-09-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-09-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-09-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-09-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-09-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-09-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-09-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-09-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-09-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-10-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-10-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-10-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-10-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-10-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-10-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-10-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-10-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-10-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-10-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-10-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-10-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-10-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-10-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-10-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-10-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-10-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-10-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-10-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-10-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-10-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-10-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-10-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-10-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-10-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-10-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-10-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-10-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-10-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-10-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-10-31",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-11-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-11-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-11-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-11-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-11-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-11-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-11-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-11-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-11-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-11-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-11-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-11-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-11-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-11-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-11-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-11-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-11-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-11-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-11-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-11-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-11-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-11-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-11-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-11-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-11-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-11-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-11-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-11-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-11-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-11-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-12-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-12-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-12-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-12-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-12-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-12-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-12-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-12-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-12-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-12-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-12-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-12-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-12-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-12-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-12-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2010-12-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-12-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-12-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-12-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-12-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-12-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-12-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-12-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-12-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-12-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-12-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-12-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-12-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2010-12-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2010-12-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2010-12-31",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2011-01-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2011-01-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2011-01-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2011-01-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2011-01-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2011-01-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2011-01-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2011-01-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2011-01-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2011-01-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2011-01-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2011-01-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2011-01-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]
["2011-01-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"}]
["2011-01-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"}]
["2011-01-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"}]
["2011-01-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"}]

{"sheet":"Lookup Adding (an)","index":15,"n_rows":255,"n_cols":8,"rows_kept":255,"cut":false,"hidden":false,"merged":[]}
["Date","Product","Sales",null,"Total Sales",null,"Bellen",22]
["2010-05-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},{"$f":"VLOOKUP(B2,$G$1:$H$4,2,0)","v":30},null,{"$f":"SUMPRODUCT(SUMIF(G1:G4,B2:B255,H1:H4))","v":5920},null,"Quad",30]
["2010-05-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},{"$f":"VLOOKUP(B3,$G$1:$H$4,2,0)","v":21},null,null,null,"Sunshine",21]
["2010-05-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21,null,"Total Sales",null,"Yanaki",20]
["2010-05-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21,null,{"$f":"SUM(C2:C255)","v":5920}]
["2010-05-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-05-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-05-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-05-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-05-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-05-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-05-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-05-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-05-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-05-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-05-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-05-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-05-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-05-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-05-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-05-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-05-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-05-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-05-31",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-06-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-06-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-06-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-06-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-06-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-06-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-06-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-06-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-06-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-06-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-06-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-06-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-06-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-06-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-06-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-06-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-06-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-06-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-06-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-06-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-06-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-06-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-06-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-06-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-06-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-06-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-06-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-06-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-06-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-06-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-07-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-07-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-07-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-07-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-07-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-07-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-07-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-07-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-07-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-07-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-07-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-07-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-07-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},{"$f":"VLOOKUP(B67,$G$1:$H$4,2,0)","v":21}]
["2010-07-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-07-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-07-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-07-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-07-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-07-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-07-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-07-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-07-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-07-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-07-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-07-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-07-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-07-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-07-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-07-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-07-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-07-31",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-08-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-08-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-08-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-08-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-08-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-08-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-08-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-08-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-08-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-08-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-08-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-08-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-08-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-08-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-08-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-08-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-08-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-08-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-08-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-08-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-08-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-08-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-08-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-08-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-08-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-08-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-08-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-08-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-08-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-08-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-08-31",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-09-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-09-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-09-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-09-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-09-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-09-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-09-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-09-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-09-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-09-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-09-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-09-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-09-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-09-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-09-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},{"$f":"VLOOKUP(B131,$G$1:$H$4,2,0)","v":21}]
["2010-09-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-09-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-09-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-09-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-09-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-09-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-09-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-09-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-09-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-09-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-09-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-09-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-09-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-09-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-09-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-10-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-10-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-10-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-10-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-10-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-10-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-10-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-10-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-10-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-10-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-10-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-10-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-10-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-10-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-10-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-10-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-10-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-10-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-10-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-10-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-10-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-10-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-10-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-10-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-10-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-10-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-10-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-10-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-10-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-10-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-10-31",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-11-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-11-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-11-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-11-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-11-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-11-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-11-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-11-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-11-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-11-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-11-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-11-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-11-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-11-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-11-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-11-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-11-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-11-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},{"$f":"VLOOKUP(B195,$G$1:$H$4,2,0)","v":21}]
["2010-11-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-11-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-11-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-11-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-11-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-11-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-11-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-11-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-11-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-11-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-11-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-11-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-12-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-12-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-12-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-12-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-12-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-12-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-12-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-12-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-12-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-12-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-12-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-18",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-12-19",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-20",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-12-21",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-22",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-12-23",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-24",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-25",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-12-26",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2010-12-27",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-12-28",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2010-12-29",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2010-12-30",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2010-12-31",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2011-01-01",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2011-01-02",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2011-01-03",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2011-01-04",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2011-01-05",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2011-01-06",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2011-01-07",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2011-01-08",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2011-01-09",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2011-01-10",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Sunshine"},21]
["2011-01-11",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2011-01-12",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2011-01-13",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Quad"},30]
["2011-01-14",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Bellen"},22]
["2011-01-15",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2011-01-16",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]
["2011-01-17",{"$f":"INDEX($G$1:$G$4,INT(RAND()*4+1))","v":"Yanaki"},20]

{"sheet":"All Criteria","index":16,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Cusomter","SR","Product"]
[null,"Moe","SR2","All"]
[]
["Count:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--(B7:B24=IF(B2=\"All\",B7:B24,B2)),--(C7:C24=IF(C2=\"All\",C7:C24,C2)),--(D7:D24=IF(D2=\"All\",D7:D24,D2)))","v":3}]
[]
["Date","Cusomter","SR","Product","Product Line","Sales"]
["2010-05-08","Moe","SR2","P3","PL1",166.42]
["2010-05-09","Moe","SR3","P2","PL3",352.63]
["2010-05-10","Moe","SR2","P3","PL1",263.76]
["2010-05-11","Joe","SR1","P3","PL2",199.86]
["2010-05-12","Mo","SR1","P3","PL3",494.65]
["2010-05-13","Mo","SR1","P3","PL3",42.05]
["2010-05-14","Mo","SR2","P2","PL2",281.8]
["2010-05-15","Joe","SR3","P2","PL3",475.8]
["2010-05-16","Mo","SR2","P3","PL3",257.47000000000003]
["2010-05-17","Mo","SR1","P3","PL2",285.82]
["2010-05-18","Joe","SR2","P2","PL2",145]
["2010-05-19","Joe","SR1","P1","PL2",359.84]
["2010-05-20","Moe","SR1","P2","PL2",391.14]
["2010-05-21","Mo","SR2","P3","PL2",463.93]
["2010-05-22","Moe","SR1","P2","PL2",288.89999999999998]
["2010-05-23","Mo","SR3","P1","PL3",502.13]
["2010-05-24","Mo","SR2","P3","PL2",274.5]
["2010-05-25","Moe","SR2","P3","PL2",417.3]

{"sheet":"All Criteria (an)","index":17,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Cusomter","SR","Product"]
[null,"Moe","SR2","All"]
[]
["Count:",{"$f":"SUMPRODUCT((B2=\"All\")+(B7:B24=B2),(C2=\"All\")+(C7:C24=C2),(D2=\"All\")+(D7:D24=D2))","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--(B7:B24=IF(B2=\"All\",B7:B24,B2)),--(C7:C24=IF(C2=\"All\",C7:C24,C2)),--(D7:D24=IF(D2=\"All\",D7:D24,D2)))","v":3}]
[]
["Date","Cusomter","SR","Product","Product Line","Sales"]
["2010-05-08","Moe","SR2","P3","PL1",166.42]
["2010-05-09","Moe","SR3","P2","PL3",352.63]
["2010-05-10","Moe","SR2","P3","PL1",263.76]
["2010-05-11","Joe","SR1","P3","PL2",199.86]
["2010-05-12","Mo","SR1","P3","PL3",494.65]
["2010-05-13","Mo","SR1","P3","PL3",42.05]
["2010-05-14","Mo","SR2","P2","PL2",281.8]
["2010-05-15","Joe","SR3","P2","PL3",475.8]
["2010-05-16","Mo","SR2","P3","PL3",257.47000000000003]
["2010-05-17","Mo","SR1","P3","PL2",285.82]
["2010-05-18","Joe","SR2","P2","PL2",145]
["2010-05-19","Joe","SR1","P1","PL2",359.84]
["2010-05-20","Moe","SR1","P2","PL2",391.14]
["2010-05-21","Mo","SR2","P3","PL2",463.93]
["2010-05-22","Moe","SR1","P2","PL2",288.89999999999998]
["2010-05-23","Mo","SR3","P1","PL3",502.13]
["2010-05-24","Mo","SR2","P3","PL2",274.5]
["2010-05-25","Moe","SR2","P3","PL2",417.3]

{"sheet":"Net Income","index":18,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ROW()&\")\"","v":"1)"},"To set up an Excel Lists/Tables/Database format, field names must be at the top of each column, field (variable) data must be in column, records must be in rows and there should be no blanks in table, no blank rows or columns between the data, and at least one blank row and column between Table/List/Database and any other data in the spreadsheet. For more detail about data analysis see this video:",null,null,null,null,null,"Excel Basics #12: Data Analysis!"]
["2)","In Excel 2003, the term for an Excel Lists/Tables/Database format is \"List\", and the keyboard shortcut to create one is Ctrl + L. In Excel 2007, the term for an Excel Lists/Tables/Database format is \"Table\", and the keyboard shortcut to create one is Ctrl + T."]
["3)","If you have your data in the Excel Lists/Tables/Database format, you can use the data analysis features such as Sort, Filter, PivotTables, Subtotals, etc. If you data is in this format your field tables and table range are dynamic"]
["4)","Dynamic ranges will automatically update as you add new Records!!!!"]
["5)","When you create an array formula you must use the keyboard shortcut; Ctrl + Shift + Enter to enter the formula. To learn more about Array Formulas, see this video series:",null,null,null,null,null,"Playlist: 08 Excel Series: Array Formulas 1-14"]
["6)","The MONTH function figures out what month a date is. For example =MONTH(2/1/2008) will return the number 2 because February is the 2 month."]
["7)","To add a Custom Number format, use Ctrl + 1 to open the Format Cells Dialog box, then click on the Number tab, then click on Custom, then type mmm to show the first three letters of the month. For more about custom Number formatting, see this video:",null,null,null,null,null,"Excel Magic Trick #74: Custom Number Formatting"]
["8)","The array formula, =SUM((MONTH($D$14:$D$37)=MONTH(J$12))*($E$14:$E$37=LEFT($I13,1))*IF(LEFT($I13,1)=\"R\",$G$14:$G$37,$F$14:$F$37)), will add the expenses or revenues for the correct month."]
["9)","For more on CUSTOM Number Formatting, watch this video:",null,null,null,null,null,"Excel Magic Trick #74: Custom Number Formatting"]
["10)","The TEXT function takes a number and converts it to text with the custom number format that you specify."]
["11)","For more about the TEXT function, see this video:",null,null,null,null,null,"YouTubersLoveExcel#45: SUMPRODUCT & TEXT functions"]
["12)","This video is in response to this video:",null,null,null,null,null,"YTL Excel #130: Income Statement from Excel Table: Array For"]
["13)","The array formula,\n=SUMPRODUCT((TEXT($D$16:$D$41,\"ym\")=TEXT(J$21,\"ym\"))*($E$16:$E$41=LEFT($I22,1))*IF(LEFT($I22,1)=\"R\",$G$16:$G$41,$F$16:$F$41))\n,will add the expenses or revenues for the correct month and year."]
[]
[null,"Customer/Supplier","Account","Date","R/E","Expense","Revenue"]
[null,"SCE","Rent","2007-05-02","E",625,null,null,null,2007,"2007-01-01","2007-02-01","2007-03-01","2007-04-01","2007-05-01","2007-06-01","2007-07-01","2007-08-01","2007-09-01","2007-10-01","2007-11-01","2007-12-01"]
[null,"CKQ","Hair Cut","2007-05-29","R",null,87,null,"R","Revenue"]
[null,"SCE","Rent","2007-06-02","E",625,null,null,"E","Expense"]
[null,"CDD","Perm","2007-06-10","R",null,150,null,null,"Net Income",{"$f":"K17-K18","v":0},{"$f":"L17-L18","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"SPA","Supply","2007-06-12","E",66]
[null,"CAS","Color","2007-06-16","R",null,100]
[null,"CAS","Trim","2007-06-17","R",null,126]
[null,"CFY","Hair Cut","2007-06-22","R",null,65]
[null,"SFT","Ad","2007-06-23","E",99]
[null,"SMN","Ad","2007-06-26","E",51]
[null,"SCE","Rent","2007-07-02","E",625]
[null,"CAP","Hair Cut","2007-07-03","R",null,35]
[null,"CVB","Perm","2007-07-03","R",null,95]
[null,"CVB","Color","2007-07-03","R",null,140]
[null,"CRQ","Color","2007-07-09","R",null,125]
[null,"CHL","Perm","2007-07-10","R",null,135]
[null,"CTY","Hair Cut","2007-07-15","R",null,112]
[null,"CLG","Hair Cut","2007-07-27","R",null,50]
[null,"SZW","Utility","2007-07-29","E",42]
[null,"CDT","Nails","2007-07-31","R",null,50]
[null,"SCE","Rent","2007-08-02","E",625]
[null,"SPO","Rent","2007-08-15","E",92]
[null,"CAS","Perm","2007-08-24","R",null,148]
[null,"CMN","Perm","2007-08-26","R",null,95]
[null,"CVB","Hair Cut","2007-09-01","R",null,30]
[null,"CDD","Hair Cut","2008-09-02","R",null,100]

{"sheet":"Net Income (an)","index":19,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ROW()&\")\"","v":"1)"},"To set up an Excel Lists/Tables/Database format, field names must be at the top of each column, field (variable) data must be in column, records must be in rows and there should be no blanks in table, no blank rows or columns between the data, and at least one blank row and column between Table/List/Database and any other data in the spreadsheet. For more detail about data analysis see this video:",null,null,null,null,null,"Excel Basics #12: Data Analysis!"]
["2)","In Excel 2003, the term for an Excel Lists/Tables/Database format is \"List\", and the keyboard shortcut to create one is Ctrl + L. In Excel 2007, the term for an Excel Lists/Tables/Database format is \"Table\", and the keyboard shortcut to create one is Ctrl + T."]
["3)","If you have your data in the Excel Lists/Tables/Database format, you can use the data analysis features such as Sort, Filter, PivotTables, Subtotals, etc. If you data is in this format your field tables and table range are dynamic"]
["4)","Dynamic ranges will automatically update as you add new Records!!!!"]
["5)","When you create an array formula you must use the keyboard shortcut; Ctrl + Shift + Enter to enter the formula. To learn more about Array Formulas, see this video series:",null,null,null,null,null,"Playlist: 08 Excel Series: Array Formulas 1-14"]
["6)","The MONTH function figures out what month a date is. For example =MONTH(2/1/2008) will return the number 2 because February is the 2 month."]
["7)","To add a Custom Number format, use Ctrl + 1 to open the Format Cells Dialog box, then click on the Number tab, then click on Custom, then type mmm to show the first three letters of the month. For more about custom Number formatting, see this video:",null,null,null,null,null,"Excel Magic Trick #74: Custom Number Formatting"]
["8)","The array formula, =SUM((MONTH($D$14:$D$37)=MONTH(J$12))*($E$14:$E$37=LEFT($I13,1))*IF(LEFT($I13,1)=\"R\",$G$14:$G$37,$F$14:$F$37)), will add the expenses or revenues for the correct month."]
["9)","For more on CUSTOM Number Formatting, watch this video:",null,null,null,null,null,"Excel Magic Trick #74: Custom Number Formatting"]
["10)","The TEXT function takes a number and converts it to text with the custom number format that you specify."]
["11)","For more about the TEXT function, see this video:",null,null,null,null,null,"YouTubersLoveExcel#45: SUMPRODUCT & TEXT functions"]
["12)","This video is in response to this video:",null,null,null,null,null,"YTL Excel #130: Income Statement from Excel Table: Array For"]
["13)","The array formula,\n=SUMPRODUCT((TEXT($D$16:$D$41,\"ym\")=TEXT(J$21,\"ym\"))*($E$16:$E$41=LEFT($I22,1))*IF(LEFT($I22,1)=\"R\",$G$16:$G$41,$F$16:$F$41))\n,will add the expenses or revenues for the correct month and year."]
[]
[null,"Customer/Supplier","Account","Date","R/E","Expense","Revenue"]
[null,"SCE","Rent","2007-05-02","E",625,null,null,null,2007,"2007-01-01","2007-02-01","2007-03-01","2007-04-01","2007-05-01","2007-06-01","2007-07-01","2007-08-01","2007-09-01","2007-10-01","2007-11-01","2007-12-01"]
[null,"CKQ","Hair Cut","2007-05-29","R",null,87,null,"R","Revenue",{"$f":"SUMPRODUCT(--($E$16:$E$41=$I17),--(TEXT($D$16:$D$41,\"myyy\")=TEXT(K$16,\"myyy\")),$G$16:$G$41)","v":0},{"$f":"SUMPRODUCT(--($E$16:$E$41=$I17),--(TEXT($D$16:$D$41,\"myyy\")=TEXT(L$16,\"myyy\")),$G$16:$G$41)","v":0},0,0,87,441,742,243,30,0,0,0]
[null,"SCE","Rent","2007-06-02","E",625,null,null,"E","Expense",{"$f":"SUMPRODUCT(--($E$16:$E$41=$I18),--(TEXT($D$16:$D$41,\"myyy\")=TEXT(K$16,\"myyy\")),$F$16:$F$41)","v":0},{"$f":"SUMPRODUCT(--($E$16:$E$41=$I18),--(TEXT($D$16:$D$41,\"myyy\")=TEXT(L$16,\"myyy\")),$F$16:$F$41)","v":0},0,0,625,841,667,717,0,0,0,0]
[null,"CDD","Perm","2007-06-10","R",null,150,null,null,"Net Income",{"$f":"K17-K18","v":0},{"$f":"L17-L18","v":0},0,0,-538,-400,75,-474,30,0,0,0]
[null,"SPA","Supply","2007-06-12","E",66]
[null,"CAS","Color","2007-06-16","R",null,100]
[null,"CAS","Trim","2007-06-17","R",null,126]
[null,"CFY","Hair Cut","2007-06-22","R",null,65]
[null,"SFT","Ad","2007-06-23","E",99]
[null,"SMN","Ad","2007-06-26","E",51]
[null,"SCE","Rent","2007-07-02","E",625]
[null,"CAP","Hair Cut","2007-07-03","R",null,35]
[null,"CVB","Perm","2007-07-03","R",null,95]
[null,"CVB","Color","2007-07-03","R",null,140]
[null,"CRQ","Color","2007-07-09","R",null,125]
[null,"CHL","Perm","2007-07-10","R",null,135]
[null,"CTY","Hair Cut","2007-07-15","R",null,112]
[null,"CLG","Hair Cut","2007-07-27","R",null,50]
[null,"SZW","Utility","2007-07-29","E",42]
[null,"CDT","Nails","2007-07-31","R",null,50]
[null,"SCE","Rent","2007-08-02","E",625]
[null,"SPO","Rent","2007-08-15","E",92]
[null,"CAS","Perm","2007-08-24","R",null,148]
[null,"CMN","Perm","2007-08-26","R",null,95]
[null,"CVB","Hair Cut","2007-09-01","R",null,30]
[null,"CDD","Hair Cut","2008-09-02","R",null,100]