{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","Data (2)","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Data","index":0,"n_rows":499,"n_cols":15,"rows_kept":499,"cut":false,"hidden":false,"merged":[]}
["1) Array formulas: 1)  do operations (like + - * /) on arrays instead of single cells or 2) you give a function argument that is expecting 1 thing, more than one thing"]
["2) Array formulas will give you a #VALUE! Error, unless you use Ctrl + Shift + Enter"]
["3) 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"]
[]
["Date","Units","Price",null,null,"Total Sales",null,null,"Multiply two columns, then add: SUM and Ctrl + Shift + Enter"]
["2011-10-04",23,13,null,null,"Total Sales",null,null,"Multiply two columns, then add: SUMPRODUCT"]
["2011-05-09",22,20]
["2011-03-30",25,15,null,null,"Add Units Sold for each Year"]
["2011-09-15",28,45,null,null,2010,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((YEAR($A$7:$A$499)=F10)*$B$7:$B$499)","v":2893}]
["2011-03-20",4,33,null,null,2011,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((YEAR($A$7:$A$499)=F11)*$B$7:$B$499)","v":4160}]
["2011-03-18",18,24,null,null,2012,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((YEAR($A$7:$A$499)=F12)*$B$7:$B$499)","v":3752}]
["2011-01-13",37,33]
["2012-10-11",36,41]
["2011-10-21",20,40]
["2012-03-04",18,18]
["2012-04-05",45,14]
["2010-05-31",20,21]
["2012-02-19",26,21]
["2012-06-18",7,15]
["2011-12-23",43,25]
["2011-12-10",30,38]
["2011-09-05",6,29]
["2010-08-17",19,39]
["2011-07-31",25,24]
["2012-03-20",37,25]
["2010-06-15",24,28]
["2010-09-18",7,24]
["2011-08-20",39,39]
["2011-12-06",35,26]
["2012-05-09",17,29]
["2010-11-27",43,14]
["2012-07-03",5,20]
["2012-07-16",1,32]
["2012-08-16",36,15]
["2012-05-28",1,16]
["2010-08-10",9,42]
["2012-08-28",38,42]
["2012-07-27",22,12]
["2012-09-10",4,20]
["2012-08-03",8,21]
["2010-08-03",42,20]
["2012-06-22",14,14]
["2010-08-27",38,43]
["2010-11-10",27,40]
["2011-08-17",40,29]
["2010-07-08",35,43]
["2010-12-02",45,34]
["2010-10-28",43,44]
["2012-04-20",13,39]
["2012-05-15",25,19]
["2011-12-05",29,36]
["2011-04-28",31,20]
["2010-10-23",6,14]
["2012-02-16",35,12]
["2011-06-15",34,24]
["2010-09-08",13,37]
["2010-11-16",45,44]
["2010-12-18",27,25]
["2011-11-07",17,18]
["2010-11-16",25,24]
["2010-12-11",24,36]
["2010-11-01",33,12]
["2010-08-09",14,39]
["2011-03-15",1,22]
["2012-07-13",13,44]
["2011-10-28",23,41]
["2010-06-01",3,40]
["2010-08-19",27,36]
["2010-10-01",3,40]
["2011-04-24",12,17]
["2012-01-12",25,14]
["2012-06-10",18,22]
["2010-08-14",25,38]
["2012-08-07",13,30]
["2011-06-22",6,22]
["2011-09-30",14,25]
["2010-09-10",5,25]
["2012-03-27",35,38]
["2011-04-28",14,12]
["2012-05-05",34,14]
["2012-06-01",18,18]
["2010-05-19",25,25]
["2011-02-09",9,12]
["2012-03-17",18,21]
["2012-04-02",23,44]
["2011-01-15",8,19]
["2012-02-02",36,35]
["2010-10-16",1,14]
["2010-08-06",8,36]
["2012-08-08",44,41]
["2012-01-10",7,34]
["2012-09-10",38,45]
["2011-06-22",30,20]
["2011-08-16",5,20]
["2011-11-21",20,34]
["2010-05-01",34,29]
["2012-03-23",22,24]
["2010-12-29",32,14]
["2011-05-29",40,27]
["2010-05-03",39,14]
["2012-08-13",5,40]
["2011-12-11",43,37]
["2011-06-26",7,20]
["2011-03-30",4,45]
["2011-09-01",16,24]
["2012-04-14",32,36]
["2011-08-04",38,24]
["2012-01-30",21,13]
["2010-11-05",17,14]
["2010-06-14",40,16]
["2011-05-13",28,35]
["2011-10-24",12,21]
["2012-06-11",20,15]
["2010-09-25",2,32]
["2011-10-24",44,41]
["2011-04-18",5,18]
["2012-06-03",5,20]
["2010-04-30",35,18]
["2011-03-15",16,19]
["2011-04-22",45,30]
["2011-03-29",40,16]
["2011-03-17",20,25]
["2010-10-19",6,15]
["2010-11-19",16,45]
["2011-11-28",3,42]
["2011-01-19",4,26]
["2012-04-10",9,28]
["2010-08-21",32,29]
["2010-06-11",25,22]
["2011-12-10",39,14]
["2010-07-28",1,44]
["2012-01-08",4,33]
["2011-02-03",7,31]
["2010-05-01",11,22]
["2012-03-16",18,39]
["2011-01-02",11,17]
["2010-06-23",36,34]
["2011-01-30",40,19]
["2011-11-11",33,40]
["2012-07-28",23,29]
["2012-04-05",22,35]
["2011-08-07",12,16]
["2011-10-28",26,23]
["2011-02-17",3,25]
["2012-03-04",44,19]
["2011-10-29",25,43]
["2010-05-02",4,17]
["2010-12-24",3,40]
["2012-05-04",20,40]
["2012-02-16",21,45]
["2011-03-26",42,33]
["2011-04-22",2,34]
["2012-05-01",24,20]
["2010-07-14",15,13]
["2011-03-29",45,19]
["2011-10-25",32,17]
["2010-08-31",15,13]
["2011-11-24",27,14]
["2012-07-05",3,37]
["2010-07-26",42,23]
["2011-02-16",27,25]
["2012-07-13",5,12]
["2012-02-08",1,30]
["2011-06-21",33,25]
["2012-09-28",44,25]
["2012-07-16",41,40]
["2012-05-24",27,36]
["2011-12-25",26,28]
["2011-09-28",30,33]
["2010-06-27",23,40]
["2012-01-10",3,18]
["2011-01-22",11,36]
["2012-04-07",41,39]
["2010-12-14",31,14]
["2011-01-01",12,24]
["2010-09-12",17,28]
["2011-11-03",1,26]
["2012-05-19",11,32]
["2010-10-12",8,35]
["2011-10-09",15,28]
["2012-02-15",23,16]
["2012-03-27",44,34]
["2011-07-29",6,16]
["2010-05-31",34,37]
["2010-11-10",24,33]
["2011-12-11",4,14]
["2012-10-12",27,17]
["2010-05-24",28,22]
["2010-10-21",19,23]
["2010-05-15",26,15]
["2012-04-26",3,23]
["2011-01-10",9,31]
["2011-09-09",1,19]
["2011-10-19",28,14]
["2012-02-12",28,22]
["2010-09-05",41,31]
["2011-11-04",27,28]
["2010-05-30",17,16]
["2012-06-14",19,38]
["2012-09-24",32,27]
["2012-09-03",13,12]
["2011-04-23",11,24]
["2010-05-24",22,12]
["2010-07-07",17,14]
["2011-01-12",14,31]
["2012-01-05",21,18]
["2012-09-11",6,26]
["2012-04-07",11,41]
["2010-09-20",9,18]
["2012-04-07",25,32]
["2011-05-14",10,22]
["2012-09-14",2,30]
["2011-11-13",44,30]
["2010-05-02",13,18]
["2011-05-23",30,36]
["2010-11-01",3,15]
["2012-06-09",34,12]
["2011-07-23",45,30]
["2012-08-07",5,25]
["2010-06-02",33,27]
["2012-06-26",17,40]
["2012-04-08",38,37]
["2011-01-25",23,41]
["2011-06-08",44,15]
["2011-06-23",3,12]
["2011-06-21",42,29]
["2011-07-27",3,25]
["2012-06-12",20,39]
["2011-08-10",29,29]
["2010-12-20",7,15]
["2012-09-29",3,36]
["2011-09-20",18,43]
["2012-03-25",7,28]
["2011-02-18",10,29]
["2012-05-24",3,15]
["2011-08-16",26,42]
["2011-07-04",1,21]
["2012-09-23",3,32]
["2011-11-16",15,18]
["2012-05-27",14,16]
["2012-06-19",29,23]
["2010-05-22",45,44]
["2010-10-13",32,39]
["2010-10-08",35,37]
["2012-02-04",17,15]
["2011-11-22",34,22]
["2012-09-28",32,24]
["2012-09-28",14,20]
["2012-02-22",16,23]
["2010-08-30",23,40]
["2011-07-24",40,12]
["2011-10-05",16,30]
["2011-01-15",20,32]
["2012-06-10",28,19]
["2012-02-23",14,21]
["2012-03-17",40,20]
["2012-06-25",7,45]
["2012-04-07",6,43]
["2011-10-10",32,13]
["2011-11-22",35,34]
["2011-10-06",31,42]
["2010-11-12",16,12]
["2011-07-16",27,20]
["2011-02-04",34,13]
["2010-10-12",19,39]
["2010-12-02",15,45]
["2010-12-05",32,38]
["2012-08-30",23,15]
["2011-05-14",12,37]
["2012-06-16",16,22]
["2012-08-09",13,15]
["2010-07-08",43,27]
["2010-12-31",10,18]
["2011-06-10",5,26]
["2011-06-26",39,20]
["2011-10-11",16,45]
["2010-07-08",17,12]
["2010-08-20",13,37]
["2010-05-17",22,19]
["2011-10-04",28,39]
["2011-08-04",27,44]
["2011-12-08",22,23]
["2010-08-29",7,36]
["2011-12-20",15,41]
["2010-07-21",15,40]
["2010-07-13",3,17]
["2011-11-08",26,43]
["2012-06-02",9,17]
["2010-11-15",2,42]
["2011-10-14",20,34]
["2012-09-27",42,26]
["2011-05-22",35,15]
["2011-12-01",24,20]
["2012-02-07",39,16]
["2011-02-17",41,45]
["2010-06-11",39,26]
["2011-12-20",11,25]
["2012-07-21",11,23]
["2012-05-17",26,30]
["2011-12-19",1,19]
["2011-08-18",8,35]
["2011-06-26",43,21]
["2012-02-03",32,26]
["2012-01-08",45,32]
["2010-08-23",18,21]
["2011-11-28",21,35]
["2012-04-16",44,37]
["2011-03-11",22,43]
["2010-09-19",35,25]
["2011-05-18",21,31]
["2010-08-12",41,42]
["2011-09-26",35,23]
["2012-06-24",12,24]
["2012-04-10",37,43]
["2012-07-11",45,38]
["2012-05-19",38,20]
["2012-09-20",30,32]
["2011-09-14",33,32]
["2010-05-27",35,28]
["2010-08-08",35,16]
["2011-09-09",25,33]
["2010-08-08",10,41]
["2012-06-08",43,33]
["2011-02-24",33,34]
["2011-12-04",38,18]
["2010-05-26",1,24]
["2012-05-20",30,22]
["2012-05-11",33,41]
["2012-04-20",10,22]
["2012-08-26",38,34]
["2011-09-23",13,30]
["2011-04-14",37,29]
["2012-04-04",16,17]
["2012-02-27",5,45]
["2012-05-19",41,17]
["2012-02-20",34,25]
["2010-10-19",12,23]
["2012-01-28",6,38]
["2010-05-02",11,31]
["2010-07-06",27,20]
["2011-11-24",13,32]
["2010-06-05",27,12]
["2011-10-06",6,39]
["2010-07-22",5,39]
["2011-11-16",45,37]
["2010-11-16",26,29]
["2011-10-03",42,24]
["2012-08-05",37,45]
["2011-01-14",44,44]
["2012-07-19",17,20]
["2012-03-15",11,22]
["2012-08-01",34,25]
["2010-08-04",6,25]
["2012-03-04",13,41]
["2011-09-18",20,30]
["2011-12-31",27,21]
["2010-10-11",4,20]
["2012-02-12",40,21]
["2011-06-25",28,38]
["2012-08-26",10,15]
["2010-06-16",7,40]
["2011-01-05",22,19]
["2011-11-08",4,37]
["2010-12-05",7,34]
["2012-01-05",17,16]
["2010-05-13",24,15]
["2010-11-20",33,18]
["2010-09-25",10,24]
["2011-06-10",3,44]
["2012-04-17",30,35]
["2011-09-25",36,26]
["2012-10-10",25,33]
["2011-11-12",29,30]
["2011-02-22",32,36]
["2011-07-21",36,26]
["2010-10-15",37,25]
["2010-09-11",30,19]
["2012-05-13",9,13]
["2011-09-10",24,24]
["2012-01-29",14,15]
["2010-05-24",29,22]
["2012-09-12",23,16]
["2010-07-05",3,15]
["2010-09-17",10,18]
["2010-08-05",6,21]
["2012-02-10",9,33]
["2010-10-16",38,21]
["2011-01-04",3,30]
["2011-10-04",14,38]
["2012-06-04",1,26]
["2011-11-03",21,41]
["2011-02-16",29,15]
["2010-05-29",6,15]
["2012-01-29",35,25]
["2011-02-16",37,15]
["2012-03-21",42,34]
["2012-03-21",31,33]
["2012-07-13",4,35]
["2011-07-11",36,20]
["2012-04-05",14,20]
["2012-05-06",5,34]
["2012-05-28",6,15]
["2011-09-28",23,23]
["2010-09-16",22,36]
["2012-07-30",30,13]
["2012-01-13",29,38]
["2011-04-06",3,14]
["2011-02-25",43,36]
["2012-09-17",3,19]
["2011-06-27",45,17]
["2010-06-17",16,45]
["2010-06-03",34,32]
["2011-11-08",9,16]
["2010-05-28",2,13]
["2011-07-12",22,14]
["2010-07-01",7,18]
["2010-05-10",35,23]
["2011-05-01",36,33]
["2011-01-30",5,42]
["2012-07-22",31,38]
["2010-07-04",1,36]
["2011-04-05",30,40]
["2012-10-12",31,37]
["2011-11-11",23,23]
["2010-12-17",19,19]
["2012-01-30",3,43]
["2012-09-17",7,22]
["2011-12-20",1,21]
["2011-07-14",25,24]
["2012-04-08",8,32]
["2011-01-28",11,39]
["2010-08-23",42,13]
["2012-02-23",31,17]
["2011-06-13",20,19]
["2012-10-15",42,16]
["2011-04-10",24,43]
["2010-10-25",38,14]
["2012-02-23",2,26]
["2011-03-25",28,23]
["2010-05-02",34,31]
["2010-12-11",31,33]
["2010-06-24",8,37]
["2011-09-18",26,13]
["2012-01-01",25,20]
["2012-09-26",34,38]
["2012-07-25",22,33]
["2011-04-18",5,30]
["2012-08-12",39,26]
["2011-08-13",44,35]
["2010-10-05",29,26]
["2012-10-01",12,25]
["2012-09-03",23,21]
["2010-07-30",22,30]
["2010-11-07",13,16]
["2012-02-22",15,15]
["2010-12-24",2,28]
["2012-02-03",25,45]
["2012-02-09",36,33]
["2010-11-02",41,38]
["2011-06-18",33,38]
["2012-05-22",21,14]
["2012-02-29",38,33]
["2011-07-12",13,39]
["2010-05-06",30,38]
["2011-08-11",34,31]
["2011-08-23",20,31]
["2010-08-10",11,34]
["2010-10-22",9,41]
["2012-10-07",18,36]
["2011-06-28",21,13]
["2012-05-22",9,22]
["2011-03-31",22,40]
["2010-06-07",20,17]
["2010-06-11",45,43]
["2011-09-06",33,37]
["2011-03-11",34,21]
["2012-03-28",45,25]
["2012-06-15",18,18]
["2010-09-26",17,35]
["2012-07-04",28,30]
["2011-11-20",27,13]
["2012-08-22",15,13]
["2010-05-07",23,28]
["2012-05-20",20,40]
["2011-08-14",10,27]
["2010-05-05",8,18]
["2012-07-25",11,37]
["2011-07-20",4,13]
["2012-06-01",40,13]
["2012-01-14",42,39]
["2012-07-26",14,37]
["2011-08-25",3,22]
["2011-04-07",17,36]
["2011-12-31",37,23]
["2011-02-08",3,32]
["2012-05-19",2,35]
["2012-09-22",18,13]
["2012-10-12",43,34]

{"sheet":"Data (2)","index":1,"n_rows":499,"n_cols":15,"rows_kept":499,"cut":false,"hidden":false,"merged":[]}
["1) Array formulas: 1)  do operations (like + - * /) on arrays instead of single cells or 2) you give a function argument that is expecting 1 thing, more than one thing"]
["2) Array formulas will give you a #VALUE! Error, unless you use Ctrl + Shift + Enter"]
["3) 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"]
[]
["Date","Units","Price",null,null,"Total Sales",{"$f":"SUM(B7:B499*C7:C499)","v":298960},null,"Multiply two columns, then add: SUM and Ctrl + Shift + Enter"]
["2011-10-04",23,13,null,null,"Total Sales",{"$f":"SUMPRODUCT(B7:B499,C7:C499)","v":298960},null,"Multiply two columns, then add: SUMPRODUCT"]
["2011-05-09",22,20]
["2011-03-30",25,15,null,null,"Add Units Sold for each Year"]
["2011-09-15",28,45,null,null,2010,{"$f":"SUM((YEAR($A$7:$A$499)=F10)*$B$7:$B$499)","v":2893},{"$f":"SUMPRODUCT(--(YEAR($A$7:$A$499)=F10),$B$7:$B$499)","v":2893},null,null,null,null,null,null,{"$f":"SUMPRODUCT((YEAR($A$7:$A$499)=F10)*$B$7:$B$499)","v":2893}]
["2011-03-20",4,33,null,null,2011,{"$f":"SUM((YEAR($A$7:$A$499)=F11)*$B$7:$B$499)","v":4160},{"$f":"SUMPRODUCT(--(YEAR($A$7:$A$499)=F11),$B$7:$B$499)","v":4160},null,null,null,null,null,null,{"$f":"SUMPRODUCT((YEAR($A$7:$A$499)=F11)*$B$7:$B$499)","v":4160}]
["2011-03-18",18,24,null,null,2012,{"$f":"SUM((YEAR($A$7:$A$499)=F12)*$B$7:$B$499)","v":3752},3752,null,null,null,null,null,null,{"$f":"SUMPRODUCT((YEAR($A$7:$A$499)=F12)*$B$7:$B$499)","v":3752}]
["2011-01-13",37,33]
["2012-10-11",36,41]
["2011-10-21",20,40]
["2012-03-04",18,18]
["2012-04-05",45,14]
["2010-05-31",20,21]
["2012-02-19",26,21]
["2012-06-18",7,15]
["2011-12-23",43,25]
["2011-12-10",30,38]
["2011-09-05",6,29]
["2010-08-17",19,39]
["2011-07-31",25,24]
["2012-03-20",37,25]
["2010-06-15",24,28]
["2010-09-18",7,24]
["2011-08-20",39,39]
["2011-12-06",35,26]
["2012-05-09",17,29]
["2010-11-27",43,14]
["2012-07-03",5,20]
["2012-07-16",1,32]
["2012-08-16",36,15]
["2012-05-28",1,16]
["2010-08-10",9,42]
["2012-08-28",38,42]
["2012-07-27",22,12]
["2012-09-10",4,20]
["2012-08-03",8,21]
["2010-08-03",42,20]
["2012-06-22",14,14]
["2010-08-27",38,43]
["2010-11-10",27,40]
["2011-08-17",40,29]
["2010-07-08",35,43]
["2010-12-02",45,34]
["2010-10-28",43,44]
["2012-04-20",13,39]
["2012-05-15",25,19]
["2011-12-05",29,36]
["2011-04-28",31,20]
["2010-10-23",6,14]
["2012-02-16",35,12]
["2011-06-15",34,24]
["2010-09-08",13,37]
["2010-11-16",45,44]
["2010-12-18",27,25]
["2011-11-07",17,18]
["2010-11-16",25,24]
["2010-12-11",24,36]
["2010-11-01",33,12]
["2010-08-09",14,39]
["2011-03-15",1,22]
["2012-07-13",13,44]
["2011-10-28",23,41]
["2010-06-01",3,40]
["2010-08-19",27,36]
["2010-10-01",3,40]
["2011-04-24",12,17]
["2012-01-12",25,14]
["2012-06-10",18,22]
["2010-08-14",25,38]
["2012-08-07",13,30]
["2011-06-22",6,22]
["2011-09-30",14,25]
["2010-09-10",5,25]
["2012-03-27",35,38]
["2011-04-28",14,12]
["2012-05-05",34,14]
["2012-06-01",18,18]
["2010-05-19",25,25]
["2011-02-09",9,12]
["2012-03-17",18,21]
["2012-04-02",23,44]
["2011-01-15",8,19]
["2012-02-02",36,35]
["2010-10-16",1,14]
["2010-08-06",8,36]
["2012-08-08",44,41]
["2012-01-10",7,34]
["2012-09-10",38,45]
["2011-06-22",30,20]
["2011-08-16",5,20]
["2011-11-21",20,34]
["2010-05-01",34,29]
["2012-03-23",22,24]
["2010-12-29",32,14]
["2011-05-29",40,27]
["2010-05-03",39,14]
["2012-08-13",5,40]
["2011-12-11",43,37]
["2011-06-26",7,20]
["2011-03-30",4,45]
["2011-09-01",16,24]
["2012-04-14",32,36]
["2011-08-04",38,24]
["2012-01-30",21,13]
["2010-11-05",17,14]
["2010-06-14",40,16]
["2011-05-13",28,35]
["2011-10-24",12,21]
["2012-06-11",20,15]
["2010-09-25",2,32]
["2011-10-24",44,41]
["2011-04-18",5,18]
["2012-06-03",5,20]
["2010-04-30",35,18]
["2011-03-15",16,19]
["2011-04-22",45,30]
["2011-03-29",40,16]
["2011-03-17",20,25]
["2010-10-19",6,15]
["2010-11-19",16,45]
["2011-11-28",3,42]
["2011-01-19",4,26]
["2012-04-10",9,28]
["2010-08-21",32,29]
["2010-06-11",25,22]
["2011-12-10",39,14]
["2010-07-28",1,44]
["2012-01-08",4,33]
["2011-02-03",7,31]
["2010-05-01",11,22]
["2012-03-16",18,39]
["2011-01-02",11,17]
["2010-06-23",36,34]
["2011-01-30",40,19]
["2011-11-11",33,40]
["2012-07-28",23,29]
["2012-04-05",22,35]
["2011-08-07",12,16]
["2011-10-28",26,23]
["2011-02-17",3,25]
["2012-03-04",44,19]
["2011-10-29",25,43]
["2010-05-02",4,17]
["2010-12-24",3,40]
["2012-05-04",20,40]
["2012-02-16",21,45]
["2011-03-26",42,33]
["2011-04-22",2,34]
["2012-05-01",24,20]
["2010-07-14",15,13]
["2011-03-29",45,19]
["2011-10-25",32,17]
["2010-08-31",15,13]
["2011-11-24",27,14]
["2012-07-05",3,37]
["2010-07-26",42,23]
["2011-02-16",27,25]
["2012-07-13",5,12]
["2012-02-08",1,30]
["2011-06-21",33,25]
["2012-09-28",44,25]
["2012-07-16",41,40]
["2012-05-24",27,36]
["2011-12-25",26,28]
["2011-09-28",30,33]
["2010-06-27",23,40]
["2012-01-10",3,18]
["2011-01-22",11,36]
["2012-04-07",41,39]
["2010-12-14",31,14]
["2011-01-01",12,24]
["2010-09-12",17,28]
["2011-11-03",1,26]
["2012-05-19",11,32]
["2010-10-12",8,35]
["2011-10-09",15,28]
["2012-02-15",23,16]
["2012-03-27",44,34]
["2011-07-29",6,16]
["2010-05-31",34,37]
["2010-11-10",24,33]
["2011-12-11",4,14]
["2012-10-12",27,17]
["2010-05-24",28,22]
["2010-10-21",19,23]
["2010-05-15",26,15]
["2012-04-26",3,23]
["2011-01-10",9,31]
["2011-09-09",1,19]
["2011-10-19",28,14]
["2012-02-12",28,22]
["2010-09-05",41,31]
["2011-11-04",27,28]
["2010-05-30",17,16]
["2012-06-14",19,38]
["2012-09-24",32,27]
["2012-09-03",13,12]
["2011-04-23",11,24]
["2010-05-24",22,12]
["2010-07-07",17,14]
["2011-01-12",14,31]
["2012-01-05",21,18]
["2012-09-11",6,26]
["2012-04-07",11,41]
["2010-09-20",9,18]
["2012-04-07",25,32]
["2011-05-14",10,22]
["2012-09-14",2,30]
["2011-11-13",44,30]
["2010-05-02",13,18]
["2011-05-23",30,36]
["2010-11-01",3,15]
["2012-06-09",34,12]
["2011-07-23",45,30]
["2012-08-07",5,25]
["2010-06-02",33,27]
["2012-06-26",17,40]
["2012-04-08",38,37]
["2011-01-25",23,41]
["2011-06-08",44,15]
["2011-06-23",3,12]
["2011-06-21",42,29]
["2011-07-27",3,25]
["2012-06-12",20,39]
["2011-08-10",29,29]
["2010-12-20",7,15]
["2012-09-29",3,36]
["2011-09-20",18,43]
["2012-03-25",7,28]
["2011-02-18",10,29]
["2012-05-24",3,15]
["2011-08-16",26,42]
["2011-07-04",1,21]
["2012-09-23",3,32]
["2011-11-16",15,18]
["2012-05-27",14,16]
["2012-06-19",29,23]
["2010-05-22",45,44]
["2010-10-13",32,39]
["2010-10-08",35,37]
["2012-02-04",17,15]
["2011-11-22",34,22]
["2012-09-28",32,24]
["2012-09-28",14,20]
["2012-02-22",16,23]
["2010-08-30",23,40]
["2011-07-24",40,12]
["2011-10-05",16,30]
["2011-01-15",20,32]
["2012-06-10",28,19]
["2012-02-23",14,21]
["2012-03-17",40,20]
["2012-06-25",7,45]
["2012-04-07",6,43]
["2011-10-10",32,13]
["2011-11-22",35,34]
["2011-10-06",31,42]
["2010-11-12",16,12]
["2011-07-16",27,20]
["2011-02-04",34,13]
["2010-10-12",19,39]
["2010-12-02",15,45]
["2010-12-05",32,38]
["2012-08-30",23,15]
["2011-05-14",12,37]
["2012-06-16",16,22]
["2012-08-09",13,15]
["2010-07-08",43,27]
["2010-12-31",10,18]
["2011-06-10",5,26]
["2011-06-26",39,20]
["2011-10-11",16,45]
["2010-07-08",17,12]
["2010-08-20",13,37]
["2010-05-17",22,19]
["2011-10-04",28,39]
["2011-08-04",27,44]
["2011-12-08",22,23]
["2010-08-29",7,36]
["2011-12-20",15,41]
["2010-07-21",15,40]
["2010-07-13",3,17]
["2011-11-08",26,43]
["2012-06-02",9,17]
["2010-11-15",2,42]
["2011-10-14",20,34]
["2012-09-27",42,26]
["2011-05-22",35,15]
["2011-12-01",24,20]
["2012-02-07",39,16]
["2011-02-17",41,45]
["2010-06-11",39,26]
["2011-12-20",11,25]
["2012-07-21",11,23]
["2012-05-17",26,30]
["2011-12-19",1,19]
["2011-08-18",8,35]
["2011-06-26",43,21]
["2012-02-03",32,26]
["2012-01-08",45,32]
["2010-08-23",18,21]
["2011-11-28",21,35]
["2012-04-16",44,37]
["2011-03-11",22,43]
["2010-09-19",35,25]
["2011-05-18",21,31]
["2010-08-12",41,42]
["2011-09-26",35,23]
["2012-06-24",12,24]
["2012-04-10",37,43]
["2012-07-11",45,38]
["2012-05-19",38,20]
["2012-09-20",30,32]
["2011-09-14",33,32]
["2010-05-27",35,28]
["2010-08-08",35,16]
["2011-09-09",25,33]
["2010-08-08",10,41]
["2012-06-08",43,33]
["2011-02-24",33,34]
["2011-12-04",38,18]
["2010-05-26",1,24]
["2012-05-20",30,22]
["2012-05-11",33,41]
["2012-04-20",10,22]
["2012-08-26",38,34]
["2011-09-23",13,30]
["2011-04-14",37,29]
["2012-04-04",16,17]
["2012-02-27",5,45]
["2012-05-19",41,17]
["2012-02-20",34,25]
["2010-10-19",12,23]
["2012-01-28",6,38]
["2010-05-02",11,31]
["2010-07-06",27,20]
["2011-11-24",13,32]
["2010-06-05",27,12]
["2011-10-06",6,39]
["2010-07-22",5,39]
["2011-11-16",45,37]
["2010-11-16",26,29]
["2011-10-03",42,24]
["2012-08-05",37,45]
["2011-01-14",44,44]
["2012-07-19",17,20]
["2012-03-15",11,22]
["2012-08-01",34,25]
["2010-08-04",6,25]
["2012-03-04",13,41]
["2011-09-18",20,30]
["2011-12-31",27,21]
["2010-10-11",4,20]
["2012-02-12",40,21]
["2011-06-25",28,38]
["2012-08-26",10,15]
["2010-06-16",7,40]
["2011-01-05",22,19]
["2011-11-08",4,37]
["2010-12-05",7,34]
["2012-01-05",17,16]
["2010-05-13",24,15]
["2010-11-20",33,18]
["2010-09-25",10,24]
["2011-06-10",3,44]
["2012-04-17",30,35]
["2011-09-25",36,26]
["2012-10-10",25,33]
["2011-11-12",29,30]
["2011-02-22",32,36]
["2011-07-21",36,26]
["2010-10-15",37,25]
["2010-09-11",30,19]
["2012-05-13",9,13]
["2011-09-10",24,24]
["2012-01-29",14,15]
["2010-05-24",29,22]
["2012-09-12",23,16]
["2010-07-05",3,15]
["2010-09-17",10,18]
["2010-08-05",6,21]
["2012-02-10",9,33]
["2010-10-16",38,21]
["2011-01-04",3,30]
["2011-10-04",14,38]
["2012-06-04",1,26]
["2011-11-03",21,41]
["2011-02-16",29,15]
["2010-05-29",6,15]
["2012-01-29",35,25]
["2011-02-16",37,15]
["2012-03-21",42,34]
["2012-03-21",31,33]
["2012-07-13",4,35]
["2011-07-11",36,20]
["2012-04-05",14,20]
["2012-05-06",5,34]
["2012-05-28",6,15]
["2011-09-28",23,23]
["2010-09-16",22,36]
["2012-07-30",30,13]
["2012-01-13",29,38]
["2011-04-06",3,14]
["2011-02-25",43,36]
["2012-09-17",3,19]
["2011-06-27",45,17]
["2010-06-17",16,45]
["2010-06-03",34,32]
["2011-11-08",9,16]
["2010-05-28",2,13]
["2011-07-12",22,14]
["2010-07-01",7,18]
["2010-05-10",35,23]
["2011-05-01",36,33]
["2011-01-30",5,42]
["2012-07-22",31,38]
["2010-07-04",1,36]
["2011-04-05",30,40]
["2012-10-12",31,37]
["2011-11-11",23,23]
["2010-12-17",19,19]
["2012-01-30",3,43]
["2012-09-17",7,22]
["2011-12-20",1,21]
["2011-07-14",25,24]
["2012-04-08",8,32]
["2011-01-28",11,39]
["2010-08-23",42,13]
["2012-02-23",31,17]
["2011-06-13",20,19]
["2012-10-15",42,16]
["2011-04-10",24,43]
["2010-10-25",38,14]
["2012-02-23",2,26]
["2011-03-25",28,23]
["2010-05-02",34,31]
["2010-12-11",31,33]
["2010-06-24",8,37]
["2011-09-18",26,13]
["2012-01-01",25,20]
["2012-09-26",34,38]
["2012-07-25",22,33]
["2011-04-18",5,30]
["2012-08-12",39,26]
["2011-08-13",44,35]
["2010-10-05",29,26]
["2012-10-01",12,25]
["2012-09-03",23,21]
["2010-07-30",22,30]
["2010-11-07",13,16]
["2012-02-22",15,15]
["2010-12-24",2,28]
["2012-02-03",25,45]
["2012-02-09",36,33]
["2010-11-02",41,38]
["2011-06-18",33,38]
["2012-05-22",21,14]
["2012-02-29",38,33]
["2011-07-12",13,39]
["2010-05-06",30,38]
["2011-08-11",34,31]
["2011-08-23",20,31]
["2010-08-10",11,34]
["2010-10-22",9,41]
["2012-10-07",18,36]
["2011-06-28",21,13]
["2012-05-22",9,22]
["2011-03-31",22,40]
["2010-06-07",20,17]
["2010-06-11",45,43]
["2011-09-06",33,37]
["2011-03-11",34,21]
["2012-03-28",45,25]
["2012-06-15",18,18]
["2010-09-26",17,35]
["2012-07-04",28,30]
["2011-11-20",27,13]
["2012-08-22",15,13]
["2010-05-07",23,28]
["2012-05-20",20,40]
["2011-08-14",10,27]
["2010-05-05",8,18]
["2012-07-25",11,37]
["2011-07-20",4,13]
["2012-06-01",40,13]
["2012-01-14",42,39]
["2012-07-26",14,37]
["2011-08-25",3,22]
["2011-04-07",17,36]
["2011-12-31",37,23]
["2011-02-08",3,32]
["2012-05-19",2,35]
["2012-09-22",18,13]
["2012-10-12",43,34]

{"sheet":"Sheet2","index":2,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Largest Profit","Smallest Profit"]
[null,null,null,null,{"$f":"MAX(A4:A24-B4:B24)","v":1614.72},{"$f":"MIN(A4:A24-B4:B24)","v":-40.25}]
["Sales","COGS","Date"]
[60,100.25,"2010-04-30"]
[1475,383.5,"2010-05-01"]
[500,65,"2010-05-02"]
[1535,429.80000000000007,"2010-05-03"]
[1856,241.28,"2010-05-04"]
[1357,556.37,"2010-05-05"]
[1105,364.65,"2010-05-06"]
[1973,966.77,"2010-05-07"]
[934,214.82,"2010-05-08"]
[1098,450.18,"2010-05-09"]
[1936,716.31999999999994,"2010-05-10"]
[371,100.17,"2010-05-11"]
[1409,366.34000000000003,"2010-05-12"]
[1861,669.95999999999992,"2010-05-13"]
[1305,495.90000000000003,"2010-05-14"]
[214,51.36,"2010-05-15"]
[799,359.54999999999995,"2010-05-16"]
[1023,511.5,"2010-05-17"]
[1788,679.44,"2010-05-18"]
[1367,300.73999999999995,"2010-05-19"]
[1815,381.14999999999992,"2010-05-20"]

{"sheet":"Sheet3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}