{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["SUMIF s COUNTIF s","SUMIF s COUNTIF s (an)","VLOOKUP","VLOOKUP (an)","Tables","Totals","Totals (an)","Store(1)","Store(2)","Store(3)","Store(4)","Logical IS IF","Logical IS IF (an)","Dates","Text Functions","Text Functions (an)","Fun","Fun (an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SUMIF s COUNTIF s","index":0,"n_rows":768,"n_cols":10,"rows_kept":768,"cut":false,"hidden":false,"merged":[]}
["Date","SalesRep","Sales","Product",null,"Function","What it does","Criteria","Do Formula","Formula"]
["2010-05-21","Denise",111,"Bellen",null,"SUMIF","add with 1 criterion/condition","Sunshine",null,{"$f":"IF(I2=\"\",\"\",FormulaAsText)","v":""}]
["2010-04-30","Thongtara",167,"Bellen",null,"COUNTIF","count with 1 criterion/condition","Janita ",null,{"$f":"IF(I3=\"\",\"\",FormulaAsText)","v":""}]
["2010-04-19","Chris",191,"Sunshine",null,"SUMIFS","add with 1 or more criteria","Bellen",null,{"$f":"IF(I4=\"\",\"\",FormulaAsText)","v":""}]
["2010-06-17","Ewelina",110,"Carlota",null,null,null,"Craig"]
["2010-07-22","Janita",146,"Carlota",null,"COUNTIFS","count with 1 or more criteria","Sarah",null,{"$f":"IF(I6=\"\",\"\",FormulaAsText)","v":""}]
["2010-05-16","Elain",177,"Sunshine",null,null,null,"Sunset"]
["2010-06-05","Gianna",137,"Carlota"]
["2010-05-13","Richard",116,"Bellen",null,"SalesRep/Pro","Bellen","Sunshine","Carlota"]
["2010-05-14","Elain",166,"Sunshine",null,"Denise"]
["2010-06-12","Michael",193,"Bellen",null,"Thongtara"]
["2010-05-22","Ewelina",105,"Sunset",null,"Sykes"]
["2010-07-19","Michelle",189,"Carlota",null,"Ewelina"]
["2010-05-12","Jason",122,"Majestic Beaut",null,"Janita"]
["2010-06-05","Craig",196,"Sunshine",null,"Elain"]
["2010-05-23","Sarah",161,"Sunshine",null,"Gianna"]
["2010-05-29","Mansa",197,"Majestic Beaut",null,"Richard"]
["2010-07-21","Michelle",113,"Sunset",null,"Michael"]
["2010-06-30","Shari",111,"Bellen",null,"Michelle"]
["2010-04-19","Richard",164,"Sunshine",null,"Jason"]
["2010-06-19","Christina",167,"Majestic Beaut",null,"Craig"]
["2010-07-01","Denise",129,"Bellen",null,"Sarah"]
["2010-04-29","Richard",122,"Sunshine",null,"Mansa"]
["2010-03-27","Thongtara",132,"Sunshine",null,"Shari"]
["2010-04-13","Michelle",178,"Carlota",null,"Christina"]
["2010-07-18","Michelle",199,"Bellen",null,"Carol"]
["2010-05-27","Shari",181,"Majestic Beaut",null,"Kaur"]
["2010-06-15","Carol",110,"Carlota",null,"Mitchell"]
["2010-04-08","Kaur",104,"Sunset",null,"Debra"]
["2010-06-23","Mitchell",110,"Sunshine",null,"Manavbir"]
["2010-06-21","Debra",185,"Carlota",null,"Daniel"]
["2010-05-01","Manavbir",183,"Sunset",null,"Yla-Katrina"]
["2010-07-07","Chris",143,"Sunset",null,"Nelia"]
["2010-07-12","Elain",120,"Carlota"]
["2010-06-22","Michelle",147,"Sunshine"]
["2010-05-15","Jason",117,"Sunshine"]
["2010-03-31","Mansa",128,"Bellen"]
["2010-04-16","Shari",110,"Sunshine"]
["2010-05-23","Kaur",158,"Carlota"]
["2010-04-09","Manavbir",133,"Sunset"]
["2010-05-17","Debra",190,"Majestic Beaut"]
["2010-07-13","Sarah",138,"Sunshine"]
["2010-04-01","Daniel",143,"Sunset"]
["2010-04-12","Manavbir",167,"Carlota"]
["2010-04-02","Thongtara",135,"Carlota"]
["2010-05-22","Carol",125,"Sunshine"]
["2010-07-08","Janita",107,"Carlota"]
["2010-06-10","Carol",162,"Bellen"]
["2010-07-13","Thongtara",192,"Majestic Beaut"]
["2010-06-05","Daniel",152,"Carlota"]
["2010-04-28","Gianna",155,"Majestic Beaut"]
["2010-07-08","Kaur",155,"Sunshine"]
["2010-05-06","Mansa",145,"Sunshine"]
["2010-07-10","Janita",149,"Carlota"]
["2010-06-24","Kaur",180,"Sunset"]
["2010-05-07","Yla-Katrina",190,"Bellen"]
["2010-07-01","Richard",127,"Sunset"]
["2010-03-30","Christina",114,"Carlota"]
["2010-04-18","Carol",191,"Majestic Beaut"]
["2010-07-02","Chris",197,"Sunshine"]
["2010-05-09","Chris",186,"Bellen"]
["2010-06-10","Gianna",174,"Carlota"]
["2010-05-29","Yla-Katrina",114,"Carlota"]
["2010-07-05","Jason",121,"Bellen"]
["2010-03-28","Debra",134,"Sunshine"]
["2010-06-15","Carol",174,"Carlota"]
["2010-05-06","Craig",178,"Majestic Beaut"]
["2010-06-01","Ewelina",132,"Sunshine"]
["2010-06-02","Sarah",148,"Carlota"]
["2010-04-05","Michelle",120,"Sunset"]
["2010-06-01","Thongtara",199,"Sunshine"]
["2010-03-31","Michelle",109,"Majestic Beaut"]
["2010-06-27","Gianna",138,"Carlota"]
["2010-05-27","Thongtara",153,"Bellen"]
["2010-06-19","Janita",122,"Bellen"]
["2010-07-21","Michael",154,"Bellen"]
["2010-06-19","Jason",174,"Sunset"]
["2010-07-14","Denise",181,"Bellen"]
["2010-06-25","Sarah",113,"Bellen"]
["2010-04-01","Nelia",177,"Sunset"]
["2010-07-12","Mitchell",138,"Majestic Beaut"]
["2010-05-21","Denise",175,"Bellen"]
["2010-04-16","Ewelina",149,"Majestic Beaut"]
["2010-05-11","Shari",140,"Majestic Beaut"]
["2010-05-03","Michelle",152,"Carlota"]
["2010-04-20","Jason",104,"Bellen"]
["2010-06-07","Daniel",116,"Majestic Beaut"]
["2010-05-06","Chris",131,"Carlota"]
["2010-04-07","Thongtara",135,"Sunshine"]
["2010-06-04","Michelle",164,"Sunset"]
["2010-03-27","Manavbir",178,"Sunset"]
["2010-04-08","Debra",139,"Sunshine"]
["2010-05-04","Carol",160,"Carlota"]
["2010-07-07","Ewelina",162,"Bellen"]
["2010-06-19","Shari",103,"Sunshine"]
["2010-05-09","Kaur",200,"Carlota"]
["2010-04-21","Mansa",132,"Sunset"]
["2010-04-12","Sarah",133,"Sunshine"]
["2010-06-23","Mansa",187,"Majestic Beaut"]
["2010-07-22","Michael",173,"Majestic Beaut"]
["2010-06-07","Chris",112,"Sunshine"]
["2010-04-22","Daniel",132,"Bellen"]
["2010-04-27","Chris",112,"Sunset"]
["2010-04-23","Daniel",131,"Carlota"]
["2010-05-25","Craig",175,"Sunshine"]
["2010-07-19","Craig",158,"Sunshine"]
["2010-04-26","Ewelina",148,"Bellen"]
["2010-06-09","Daniel",187,"Sunset"]
["2010-07-07","Mansa",168,"Majestic Beaut"]
["2010-04-25","Nelia",116,"Majestic Beaut"]
["2010-03-26","Jason",122,"Carlota"]
["2010-05-21","Debra",160,"Sunshine"]
["2010-05-13","Debra",192,"Carlota"]
["2010-05-19","Christina",154,"Sunset"]
["2010-04-06","Jason",145,"Sunshine"]
["2010-05-03","Richard",178,"Sunshine"]
["2010-05-04","Sarah",112,"Sunset"]
["2010-07-04","Elain",115,"Carlota"]
["2010-05-25","Mansa",146,"Carlota"]
["2010-06-15","Debra",109,"Majestic Beaut"]
["2010-07-21","Denise",172,"Carlota"]
["2010-05-22","Daniel",146,"Sunshine"]
["2010-06-30","Richard",144,"Bellen"]
["2010-06-23","Mitchell",146,"Carlota"]
["2010-04-28","Kaur",105,"Sunshine"]
["2010-06-25","Ewelina",134,"Carlota"]
["2010-07-11","Richard",118,"Carlota"]
["2010-07-10","Debra",132,"Bellen"]
["2010-05-27","Carol",117,"Sunset"]
["2010-04-03","Michelle",194,"Carlota"]
["2010-04-27","Debra",122,"Sunshine"]
["2010-06-29","Michelle",134,"Sunset"]
["2010-07-11","Chris",134,"Sunshine"]
["2010-03-30","Elain",125,"Sunset"]
["2010-04-05","Carol",115,"Majestic Beaut"]
["2010-04-04","Christina",105,"Sunset"]
["2010-06-24","Christina",179,"Bellen"]
["2010-06-22","Elain",114,"Sunset"]
["2010-06-06","Elain",176,"Carlota"]
["2010-04-25","Shari",194,"Sunset"]
["2010-05-18","Mitchell",170,"Majestic Beaut"]
["2010-07-14","Ewelina",144,"Carlota"]
["2010-05-06","Christina",175,"Carlota"]
["2010-07-22","Michelle",185,"Sunshine"]
["2010-07-02","Carol",133,"Majestic Beaut"]
["2010-05-21","Sarah",131,"Sunset"]
["2010-06-15","Mansa",163,"Sunshine"]
["2010-03-26","Denise",120,"Sunshine"]
["2010-05-04","Manavbir",136,"Majestic Beaut"]
["2010-03-28","Gianna",195,"Sunset"]
["2010-04-21","Yla-Katrina",157,"Sunset"]
["2010-05-27","Michelle",187,"Majestic Beaut"]
["2010-05-15","Christina",185,"Carlota"]
["2010-07-10","Jason",154,"Sunset"]
["2010-06-13","Jason",187,"Sunshine"]
["2010-07-14","Gianna",142,"Sunshine"]
["2010-07-19","Denise",132,"Majestic Beaut"]
["2010-07-11","Mitchell",127,"Sunset"]
["2010-05-27","Mansa",184,"Majestic Beaut"]
["2010-06-23","Thongtara",164,"Bellen"]
["2010-04-28","Chris",157,"Sunset"]
["2010-07-05","Craig",186,"Majestic Beaut"]
["2010-05-23","Elain",135,"Carlota"]
["2010-06-25","Janita",194,"Carlota"]
["2010-04-05","Thongtara",177,"Sunset"]
["2010-05-05","Mitchell",143,"Carlota"]
["2010-05-18","Manavbir",152,"Sunset"]
["2010-06-03","Nelia",101,"Sunset"]
["2010-05-05","Janita",110,"Majestic Beaut"]
["2010-06-15","Denise",124,"Carlota"]
["2010-05-08","Christina",102,"Sunshine"]
["2010-07-16","Richard",139,"Sunset"]
["2010-05-06","Janita",152,"Bellen"]
["2010-05-17","Janita",168,"Majestic Beaut"]
["2010-04-01","Michael",151,"Majestic Beaut"]
["2010-05-06","Gianna",137,"Sunshine"]
["2010-07-13","Janita",104,"Carlota"]
["2010-04-09","Nelia",139,"Carlota"]
["2010-07-04","Daniel",147,"Sunshine"]
["2010-07-09","Mansa",190,"Majestic Beaut"]
["2010-07-19","Nelia",159,"Carlota"]
["2010-03-28","Manavbir",112,"Carlota"]
["2010-05-08","Christina",182,"Majestic Beaut"]
["2010-05-16","Richard",121,"Sunset"]
["2010-05-25","Kaur",181,"Majestic Beaut"]
["2010-06-03","Craig",104,"Bellen"]
["2010-06-01","Chris",194,"Sunset"]
["2010-03-29","Christina",178,"Sunshine"]
["2010-06-27","Carol",142,"Sunshine"]
["2010-04-09","Mitchell",191,"Bellen"]
["2010-06-26","Sarah",120,"Bellen"]
["2010-05-10","Carol",155,"Sunshine"]
["2010-05-03","Manavbir",199,"Sunshine"]
["2010-05-12","Thongtara",106,"Sunshine"]
["2010-04-28","Elain",149,"Majestic Beaut"]
["2010-06-09","Michelle",158,"Bellen"]
["2010-04-01","Gianna",144,"Bellen"]
["2010-05-13","Daniel",143,"Bellen"]
["2010-07-09","Daniel",177,"Sunshine"]
["2010-04-03","Manavbir",142,"Majestic Beaut"]
["2010-05-25","Debra",193,"Majestic Beaut"]
["2010-07-10","Michelle",193,"Sunshine"]
["2010-07-04","Mitchell",112,"Sunset"]
["2010-03-29","Michelle",123,"Majestic Beaut"]
["2010-06-15","Michael",197,"Bellen"]
["2010-04-18","Thongtara",155,"Carlota"]
["2010-05-10","Janita",118,"Carlota"]
["2010-04-30","Denise",169,"Sunshine"]
["2010-05-19","Daniel",172,"Bellen"]
["2010-06-20","Michael",132,"Sunshine"]
["2010-06-23","Yla-Katrina",154,"Majestic Beaut"]
["2010-07-17","Christina",152,"Sunshine"]
["2010-06-16","Craig",128,"Carlota"]
["2010-07-06","Thongtara",101,"Sunshine"]
["2010-04-25","Elain",174,"Carlota"]
["2010-04-06","Denise",124,"Bellen"]
["2010-06-24","Craig",172,"Sunshine"]
["2010-04-01","Ewelina",165,"Bellen"]
["2010-06-03","Thongtara",117,"Sunshine"]
["2010-04-17","Mitchell",109,"Carlota"]
["2010-04-08","Carol",172,"Sunshine"]
["2010-06-20","Sarah",115,"Majestic Beaut"]
["2010-05-19","Shari",125,"Sunset"]
["2010-03-28","Chris",113,"Sunshine"]
["2010-05-02","Debra",152,"Bellen"]
["2010-07-09","Craig",144,"Majestic Beaut"]
["2010-04-04","Denise",153,"Bellen"]
["2010-07-21","Thongtara",188,"Carlota"]
["2010-06-23","Mansa",105,"Bellen"]
["2010-05-24","Chris",144,"Sunset"]
["2010-05-01","Daniel",196,"Bellen"]
["2010-04-09","Denise",145,"Sunshine"]
["2010-04-28","Manavbir",134,"Sunshine"]
["2010-04-03","Carol",196,"Sunshine"]
["2010-06-21","Michael",110,"Carlota"]
["2010-03-27","Shari",172,"Majestic Beaut"]
["2010-06-21","Michael",174,"Bellen"]
["2010-05-13","Gianna",109,"Majestic Beaut"]
["2010-04-21","Sarah",181,"Sunset"]
["2010-05-06","Michael",185,"Sunshine"]
["2010-06-04","Gianna",170,"Sunset"]
["2010-07-04","Jason",179,"Carlota"]
["2010-04-16","Mitchell",109,"Majestic Beaut"]
["2010-07-22","Jason",110,"Sunset"]
["2010-07-07","Craig",137,"Sunshine"]
["2010-07-07","Ewelina",128,"Sunset"]
["2010-05-15","Carol",183,"Sunshine"]
["2010-04-18","Mitchell",200,"Bellen"]
["2010-07-12","Denise",114,"Sunshine"]
["2010-04-14","Gianna",144,"Bellen"]
["2010-04-29","Elain",142,"Majestic Beaut"]
["2010-06-15","Daniel",167,"Sunset"]
["2010-05-10","Ewelina",169,"Carlota"]
["2010-07-01","Manavbir",131,"Carlota"]
["2010-05-21","Denise",113,"Majestic Beaut"]
["2010-05-06","Thongtara",162,"Carlota"]
["2010-05-14","Carol",152,"Sunshine"]
["2010-05-05","Elain",143,"Bellen"]
["2010-04-03","Yla-Katrina",171,"Carlota"]
["2010-04-03","Michael",147,"Sunshine"]
["2010-04-06","Nelia",164,"Sunset"]
["2010-05-28","Elain",163,"Carlota"]
["2010-07-05","Christina",148,"Sunset"]
["2010-05-09","Yla-Katrina",109,"Bellen"]
["2010-07-17","Daniel",179,"Carlota"]
["2010-04-17","Elain",130,"Carlota"]
["2010-04-25","Jason",197,"Carlota"]
["2010-05-06","Craig",106,"Carlota"]
["2010-07-21","Janita",145,"Carlota"]
["2010-07-18","Yla-Katrina",133,"Bellen"]
["2010-06-24","Elain",195,"Carlota"]
["2010-03-28","Debra",151,"Majestic Beaut"]
["2010-05-21","Shari",102,"Bellen"]
["2010-05-17","Kaur",152,"Carlota"]
["2010-05-11","Yla-Katrina",168,"Bellen"]
["2010-04-27","Nelia",139,"Carlota"]
["2010-04-27","Gianna",159,"Sunshine"]
["2010-05-10","Thongtara",142,"Carlota"]
["2010-06-06","Mitchell",141,"Sunshine"]
["2010-06-16","Jason",114,"Sunshine"]
["2010-07-08","Richard",102,"Carlota"]
["2010-05-15","Thongtara",119,"Majestic Beaut"]
["2010-07-03","Richard",196,"Sunshine"]
["2010-07-08","Manavbir",164,"Bellen"]
["2010-04-22","Manavbir",115,"Sunshine"]
["2010-05-06","Daniel",178,"Bellen"]
["2010-04-16","Richard",153,"Majestic Beaut"]
["2010-05-18","Ewelina",101,"Majestic Beaut"]
["2010-07-11","Thongtara",151,"Majestic Beaut"]
["2010-05-18","Debra",115,"Bellen"]
["2010-06-10","Debra",170,"Sunset"]
["2010-04-11","Sarah",112,"Sunshine"]
["2010-04-11","Daniel",163,"Carlota"]
["2010-05-29","Mitchell",181,"Majestic Beaut"]
["2010-07-07","Chris",108,"Bellen"]
["2010-03-28","Daniel",114,"Bellen"]
["2010-04-23","Carol",119,"Majestic Beaut"]
["2010-04-06","Michelle",168,"Sunshine"]
["2010-03-28","Manavbir",191,"Sunset"]
["2010-05-21","Debra",152,"Sunshine"]
["2010-04-01","Shari",155,"Sunshine"]
["2010-07-22","Richard",128,"Sunshine"]
["2010-04-30","Elain",185,"Sunshine"]
["2010-04-13","Michelle",164,"Bellen"]
["2010-07-08","Kaur",130,"Majestic Beaut"]
["2010-04-20","Manavbir",148,"Majestic Beaut"]
["2010-06-18","Manavbir",190,"Bellen"]
["2010-07-20","Elain",115,"Sunset"]
["2010-06-26","Manavbir",123,"Sunset"]
["2010-06-08","Ewelina",168,"Majestic Beaut"]
["2010-07-20","Janita",124,"Majestic Beaut"]
["2010-06-21","Michael",178,"Sunset"]
["2010-07-19","Ewelina",101,"Sunshine"]
["2010-04-01","Michael",136,"Carlota"]
["2010-03-28","Janita",174,"Majestic Beaut"]
["2010-07-09","Nelia",156,"Sunshine"]
["2010-04-08","Daniel",131,"Majestic Beaut"]
["2010-05-19","Craig",152,"Majestic Beaut"]
["2010-06-05","Nelia",193,"Sunshine"]
["2010-06-20","Manavbir",165,"Sunset"]
["2010-04-10","Nelia",158,"Carlota"]
["2010-05-24","Elain",104,"Carlota"]
["2010-07-01","Thongtara",186,"Bellen"]
["2010-04-10","Ewelina",150,"Sunshine"]
["2010-04-24","Thongtara",167,"Bellen"]
["2010-07-12","Debra",184,"Bellen"]
["2010-04-10","Carol",121,"Bellen"]
["2010-07-15","Chris",184,"Bellen"]
["2010-03-28","Yla-Katrina",187,"Majestic Beaut"]
["2010-04-20","Chris",140,"Sunshine"]
["2010-06-11","Carol",129,"Carlota"]
["2010-06-14","Carol",184,"Carlota"]
["2010-07-11","Christina",147,"Sunset"]
["2010-06-28","Jason",182,"Majestic Beaut"]
["2010-04-30","Manavbir",132,"Bellen"]
["2010-04-15","Sarah",158,"Carlota"]
["2010-04-26","Daniel",184,"Sunshine"]
["2010-03-30","Christina",107,"Carlota"]
["2010-05-27","Craig",148,"Carlota"]
["2010-06-25","Thongtara",132,"Sunset"]
["2010-03-29","Daniel",127,"Carlota"]
["2010-05-28","Christina",184,"Majestic Beaut"]
["2010-04-04","Ewelina",172,"Bellen"]
["2010-04-13","Daniel",147,"Carlota"]
["2010-04-22","Michael",124,"Sunshine"]
["2010-04-11","Michael",184,"Sunshine"]
["2010-05-05","Shari",196,"Sunset"]
["2010-06-11","Shari",122,"Carlota"]
["2010-04-01","Shari",148,"Carlota"]
["2010-06-29","Debra",136,"Sunset"]
["2010-06-06","Christina",133,"Bellen"]
["2010-04-13","Richard",182,"Bellen"]
["2010-05-14","Michael",167,"Sunshine"]
["2010-05-13","Craig",133,"Sunset"]
["2010-05-06","Carol",134,"Sunset"]
["2010-06-26","Debra",142,"Sunset"]
["2010-05-31","Mitchell",165,"Carlota"]
["2010-07-11","Kaur",177,"Carlota"]
["2010-04-12","Jason",107,"Majestic Beaut"]
["2010-07-03","Gianna",139,"Majestic Beaut"]
["2010-05-28","Manavbir",111,"Carlota"]
["2010-06-28","Chris",156,"Bellen"]
["2010-06-23","Kaur",152,"Sunshine"]
["2010-07-16","Mansa",138,"Sunset"]
["2010-06-04","Michael",162,"Majestic Beaut"]
["2010-03-29","Ewelina",157,"Sunshine"]
["2010-07-04","Ewelina",175,"Bellen"]
["2010-04-12","Kaur",135,"Majestic Beaut"]
["2010-05-05","Kaur",194,"Majestic Beaut"]
["2010-05-28","Jason",107,"Bellen"]
["2010-07-03","Craig",108,"Carlota"]
["2010-06-01","Carol",198,"Majestic Beaut"]
["2010-07-01","Janita",145,"Sunset"]
["2010-04-18","Mitchell",168,"Sunset"]
["2010-05-04","Mitchell",137,"Sunset"]
["2010-05-23","Gianna",145,"Bellen"]
["2010-06-29","Daniel",178,"Sunset"]
["2010-04-30","Manavbir",152,"Majestic Beaut"]
["2010-04-11","Chris",120,"Sunshine"]
["2010-06-14","Nelia",148,"Carlota"]
["2010-05-27","Kaur",175,"Bellen"]
["2010-07-23","Christina",131,"Bellen"]
["2010-07-16","Kaur",172,"Bellen"]
["2010-05-26","Janita",155,"Sunset"]
["2010-04-29","Denise",199,"Sunshine"]
["2010-04-10","Craig",187,"Carlota"]
["2010-05-21","Gianna",127,"Sunshine"]
["2010-05-01","Jason",200,"Bellen"]
["2010-05-27","Sarah",133,"Carlota"]
["2010-06-01","Janita",163,"Sunset"]
["2010-04-10","Manavbir",131,"Majestic Beaut"]
["2010-07-19","Ewelina",125,"Sunset"]
["2010-06-25","Shari",170,"Majestic Beaut"]
["2010-04-14","Ewelina",150,"Carlota"]
["2010-03-31","Daniel",126,"Sunshine"]
["2010-05-08","Thongtara",175,"Majestic Beaut"]
["2010-03-30","Michael",180,"Majestic Beaut"]
["2010-06-04","Gianna",168,"Majestic Beaut"]
["2010-03-26","Chris",174,"Majestic Beaut"]
["2010-04-16","Chris",175,"Sunset"]
["2010-06-13","Thongtara",129,"Carlota"]
["2010-03-26","Michelle",107,"Bellen"]
["2010-06-13","Sarah",138,"Bellen"]
["2010-04-19","Christina",140,"Sunset"]
["2010-05-12","Elain",166,"Majestic Beaut"]
["2010-06-28","Yla-Katrina",137,"Majestic Beaut"]
["2010-04-03","Craig",172,"Sunshine"]
["2010-05-11","Richard",119,"Carlota"]
["2010-07-05","Ewelina",165,"Majestic Beaut"]
["2010-07-07","Mitchell",143,"Majestic Beaut"]
["2010-07-05","Yla-Katrina",139,"Carlota"]
["2010-05-23","Nelia",190,"Majestic Beaut"]
["2010-07-01","Jason",160,"Majestic Beaut"]
["2010-06-14","Craig",175,"Sunshine"]
["2010-06-19","Gianna",106,"Carlota"]
["2010-07-24","Ewelina",197,"Carlota"]
["2010-05-28","Kaur",152,"Sunset"]
["2010-05-08","Chris",167,"Majestic Beaut"]
["2010-03-29","Jason",183,"Majestic Beaut"]
["2010-06-09","Denise",140,"Bellen"]
["2010-06-26","Denise",141,"Carlota"]
["2010-05-11","Kaur",173,"Bellen"]
["2010-05-18","Daniel",113,"Carlota"]
["2010-04-30","Nelia",105,"Bellen"]
["2010-05-02","Michelle",139,"Carlota"]
["2010-07-04","Thongtara",199,"Sunshine"]
["2010-06-25","Yla-Katrina",126,"Carlota"]
["2010-07-03","Richard",200,"Sunset"]
["2010-04-25","Carol",119,"Majestic Beaut"]
["2010-06-23","Debra",186,"Sunshine"]
["2010-06-29","Mansa",115,"Sunset"]
["2010-04-05","Denise",103,"Sunshine"]
["2010-04-24","Michael",102,"Bellen"]
["2010-06-12","Manavbir",196,"Bellen"]
["2010-06-30","Denise",151,"Sunshine"]
["2010-04-21","Jason",187,"Bellen"]
["2010-06-28","Richard",168,"Majestic Beaut"]
["2010-05-08","Michael",180,"Sunshine"]
["2010-05-21","Janita",136,"Sunset"]
["2010-05-27","Manavbir",145,"Carlota"]
["2010-04-18","Yla-Katrina",141,"Sunset"]
["2010-06-05","Michelle",160,"Carlota"]
["2010-05-15","Kaur",166,"Bellen"]
["2010-04-11","Ewelina",145,"Majestic Beaut"]
["2010-05-02","Shari",131,"Sunshine"]
["2010-07-09","Denise",193,"Sunset"]
["2010-05-29","Daniel",144,"Carlota"]
["2010-05-01","Elain",132,"Bellen"]
["2010-06-14","Janita",114,"Sunset"]
["2010-07-23","Craig",160,"Sunset"]
["2010-06-16","Christina",194,"Sunset"]
["2010-05-10","Shari",129,"Sunshine"]
["2010-04-24","Mitchell",134,"Carlota"]
["2010-06-22","Manavbir",172,"Majestic Beaut"]
["2010-06-18","Elain",116,"Bellen"]
["2010-04-06","Debra",112,"Sunshine"]
["2010-04-21","Carol",185,"Sunset"]
["2010-05-17","Nelia",149,"Sunset"]
["2010-06-13","Sarah",175,"Majestic Beaut"]
["2010-05-12","Richard",193,"Sunset"]
["2010-04-26","Manavbir",108,"Sunset"]
["2010-07-19","Chris",182,"Sunset"]
["2010-04-25","Shari",138,"Sunset"]
["2010-04-10","Michael",112,"Carlota"]
["2010-06-22","Michael",111,"Majestic Beaut"]
["2010-04-11","Craig",101,"Bellen"]
["2010-04-27","Daniel",113,"Majestic Beaut"]
["2010-04-02","Jason",123,"Sunshine"]
["2010-06-08","Michelle",137,"Sunshine"]
["2010-04-19","Thongtara",149,"Sunset"]
["2010-04-16","Shari",117,"Sunset"]
["2010-04-28","Jason",168,"Sunshine"]
["2010-05-05","Christina",109,"Sunset"]
["2010-06-13","Elain",107,"Carlota"]
["2010-06-19","Jason",121,"Carlota"]
["2010-06-07","Michelle",130,"Sunshine"]
["2010-04-18","Kaur",172,"Bellen"]
["2010-05-06","Elain",147,"Sunshine"]
["2010-07-21","Sarah",170,"Carlota"]
["2010-05-08","Christina",161,"Sunset"]
["2010-06-29","Manavbir",130,"Sunshine"]
["2010-06-02","Michael",118,"Majestic Beaut"]
["2010-05-28","Ewelina",103,"Majestic Beaut"]
["2010-05-29","Daniel",186,"Majestic Beaut"]
["2010-04-05","Michael",189,"Bellen"]
["2010-05-10","Denise",186,"Sunshine"]
["2010-07-21","Manavbir",110,"Carlota"]
["2010-04-04","Manavbir",144,"Sunshine"]
["2010-04-25","Shari",146,"Bellen"]
["2010-06-17","Thongtara",139,"Carlota"]
["2010-05-23","Carol",157,"Bellen"]
["2010-05-10","Yla-Katrina",117,"Sunshine"]
["2010-07-23","Carol",135,"Sunset"]
["2010-06-30","Elain",142,"Majestic Beaut"]
["2010-06-18","Manavbir",127,"Sunshine"]
["2010-07-20","Daniel",123,"Sunset"]
["2010-06-12","Debra",146,"Sunset"]
["2010-04-12","Manavbir",141,"Sunshine"]
["2010-05-02","Yla-Katrina",195,"Bellen"]
["2010-05-16","Elain",160,"Majestic Beaut"]
["2010-05-11","Nelia",128,"Bellen"]
["2010-05-30","Ewelina",166,"Carlota"]
["2010-04-10","Debra",194,"Sunset"]
["2010-07-04","Christina",187,"Sunshine"]
["2010-04-05","Michael",165,"Sunshine"]
["2010-04-12","Thongtara",103,"Sunshine"]
["2010-04-01","Craig",199,"Carlota"]
["2010-04-02","Chris",141,"Sunset"]
["2010-04-04","Christina",112,"Majestic Beaut"]
["2010-05-16","Daniel",163,"Carlota"]
["2010-04-15","Janita",186,"Sunshine"]
["2010-05-21","Sarah",144,"Carlota"]
["2010-07-08","Shari",117,"Sunshine"]
["2010-05-13","Ewelina",169,"Majestic Beaut"]
["2010-06-11","Thongtara",185,"Sunset"]
["2010-05-17","Michelle",131,"Majestic Beaut"]
["2010-06-16","Michael",137,"Sunshine"]
["2010-05-16","Michael",195,"Majestic Beaut"]
["2010-07-21","Janita",128,"Bellen"]
["2010-06-13","Elain",192,"Sunshine"]
["2010-05-27","Manavbir",184,"Sunshine"]
["2010-04-10","Elain",106,"Majestic Beaut"]
["2010-06-11","Ewelina",152,"Carlota"]
["2010-06-03","Chris",149,"Carlota"]
["2010-04-21","Mitchell",198,"Bellen"]
["2010-07-24","Carol",142,"Sunset"]
["2010-06-23","Richard",122,"Sunshine"]
["2010-06-04","Jason",129,"Sunset"]
["2010-06-10","Richard",134,"Carlota"]
["2010-04-25","Manavbir",160,"Sunset"]
["2010-06-30","Craig",117,"Sunshine"]
["2010-04-18","Michael",153,"Sunset"]
["2010-06-22","Christina",103,"Sunset"]
["2010-04-28","Mansa",106,"Sunshine"]
["2010-04-28","Jason",156,"Sunshine"]
["2010-03-31","Denise",113,"Carlota"]
["2010-04-09","Christina",161,"Sunshine"]
["2010-04-09","Elain",158,"Carlota"]
["2010-05-22","Ewelina",109,"Sunshine"]
["2010-07-03","Jason",132,"Majestic Beaut"]
["2010-05-03","Janita",129,"Sunset"]
["2010-06-09","Yla-Katrina",112,"Sunshine"]
["2010-04-05","Michael",123,"Bellen"]
["2010-03-26","Gianna",154,"Sunset"]
["2010-07-23","Jason",115,"Bellen"]
["2010-07-13","Michelle",118,"Carlota"]
["2010-05-29","Carol",116,"Carlota"]
["2010-04-30","Manavbir",147,"Majestic Beaut"]
["2010-07-19","Mitchell",144,"Majestic Beaut"]
["2010-06-17","Nelia",148,"Bellen"]
["2010-07-15","Mitchell",195,"Carlota"]
["2010-04-21","Ewelina",182,"Sunshine"]
["2010-04-11","Ewelina",115,"Sunshine"]
["2010-04-20","Sarah",152,"Carlota"]
["2010-06-08","Mitchell",111,"Majestic Beaut"]
["2010-04-16","Chris",142,"Majestic Beaut"]
["2010-06-30","Ewelina",191,"Bellen"]
["2010-07-07","Yla-Katrina",168,"Majestic Beaut"]
["2010-06-08","Kaur",174,"Sunset"]
["2010-07-02","Chris",200,"Sunshine"]
["2010-05-28","Manavbir",181,"Sunset"]
["2010-05-02","Chris",183,"Majestic Beaut"]
["2010-07-03","Manavbir",179,"Carlota"]
["2010-05-05","Sarah",104,"Sunshine"]
["2010-07-07","Jason",150,"Carlota"]
["2010-06-09","Richard",154,"Sunset"]
["2010-04-07","Mansa",119,"Sunshine"]
["2010-07-17","Kaur",183,"Carlota"]
["2010-04-16","Michael",110,"Sunset"]
["2010-04-22","Yla-Katrina",116,"Sunset"]
["2010-07-09","Jason",185,"Sunset"]
["2010-04-02","Elain",123,"Sunset"]
["2010-05-11","Yla-Katrina",193,"Carlota"]
["2010-04-01","Debra",126,"Sunset"]
["2010-06-29","Jason",113,"Bellen"]
["2010-06-13","Ewelina",114,"Carlota"]
["2010-04-14","Nelia",157,"Bellen"]
["2010-07-14","Manavbir",186,"Sunset"]
["2010-03-28","Thongtara",198,"Bellen"]
["2010-07-13","Sarah",159,"Carlota"]
["2010-04-27","Thongtara",148,"Bellen"]
["2010-03-29","Craig",121,"Majestic Beaut"]
["2010-07-19","Jason",183,"Sunshine"]
["2010-03-28","Mitchell",111,"Bellen"]
["2010-07-08","Denise",144,"Sunset"]
["2010-05-23","Manavbir",143,"Sunshine"]
["2010-05-06","Gianna",189,"Sunset"]
["2010-07-08","Mitchell",173,"Sunshine"]
["2010-04-15","Denise",161,"Majestic Beaut"]
["2010-04-27","Gianna",131,"Carlota"]
["2010-04-02","Craig",102,"Sunset"]
["2010-06-12","Manavbir",174,"Bellen"]
["2010-04-26","Craig",166,"Carlota"]
["2010-05-15","Mansa",125,"Bellen"]
["2010-05-25","Jason",140,"Majestic Beaut"]
["2010-06-23","Debra",190,"Carlota"]
["2010-04-19","Kaur",101,"Majestic Beaut"]
["2010-05-17","Richard",162,"Sunset"]
["2010-07-22","Denise",114,"Sunset"]
["2010-04-20","Craig",176,"Carlota"]
["2010-05-02","Mansa",167,"Sunshine"]
["2010-06-20","Debra",104,"Carlota"]
["2010-07-21","Michael",191,"Bellen"]
["2010-04-02","Janita",143,"Carlota"]
["2010-05-17","Sarah",101,"Majestic Beaut"]
["2010-06-21","Christina",188,"Carlota"]
["2010-04-04","Manavbir",164,"Majestic Beaut"]
["2010-07-07","Michael",117,"Carlota"]
["2010-06-12","Nelia",174,"Bellen"]
["2010-04-11","Yla-Katrina",178,"Sunshine"]
["2010-06-27","Debra",177,"Sunshine"]
["2010-07-12","Chris",114,"Sunset"]
["2010-04-04","Yla-Katrina",179,"Majestic Beaut"]
["2010-06-06","Debra",107,"Majestic Beaut"]
["2010-04-02","Michelle",108,"Bellen"]
["2010-05-18","Denise",151,"Sunshine"]
["2010-05-11","Debra",159,"Sunshine"]
["2010-03-27","Kaur",194,"Majestic Beaut"]
["2010-06-12","Carol",196,"Bellen"]
["2010-06-22","Christina",114,"Carlota"]
["2010-05-30","Ewelina",161,"Majestic Beaut"]
["2010-05-22","Elain",168,"Sunshine"]
["2010-04-29","Michelle",125,"Sunshine"]
["2010-03-31","Gianna",143,"Sunset"]
["2010-06-23","Manavbir",107,"Carlota"]
["2010-07-18","Thongtara",158,"Majestic Beaut"]
["2010-05-24","Kaur",160,"Sunset"]
["2010-06-24","Yla-Katrina",167,"Carlota"]
["2010-06-07","Denise",191,"Sunshine"]
["2010-06-04","Janita",111,"Sunshine"]
["2010-06-26","Richard",152,"Bellen"]
["2010-04-23","Christina",158,"Sunshine"]
["2010-07-09","Michael",163,"Sunset"]
["2010-07-08","Elain",181,"Carlota"]
["2010-06-20","Manavbir",192,"Carlota"]
["2010-06-14","Janita",124,"Sunset"]
["2010-05-15","Carol",180,"Sunset"]
["2010-04-02","Nelia",146,"Majestic Beaut"]
["2010-05-06","Sarah",116,"Carlota"]
["2010-07-04","Ewelina",144,"Bellen"]
["2010-06-29","Kaur",196,"Sunset"]
["2010-06-08","Ewelina",108,"Carlota"]
["2010-06-24","Michelle",158,"Sunset"]
["2010-04-23","Christina",179,"Carlota"]
["2010-06-19","Ewelina",199,"Sunset"]
["2010-05-31","Chris",158,"Sunshine"]
["2010-06-02","Mansa",168,"Majestic Beaut"]
["2010-04-14","Nelia",183,"Sunshine"]
["2010-04-15","Janita",176,"Bellen"]
["2010-05-06","Jason",166,"Carlota"]
["2010-04-02","Shari",122,"Sunshine"]
["2010-05-19","Daniel",104,"Bellen"]
["2010-07-13","Debra",140,"Carlota"]
["2010-05-03","Ewelina",172,"Carlota"]
["2010-06-09","Christina",112,"Sunshine"]
["2010-07-06","Gianna",133,"Sunset"]
["2010-06-07","Jason",104,"Sunset"]
["2010-04-07","Shari",194,"Carlota"]
["2010-05-13","Thongtara",186,"Sunshine"]
["2010-05-24","Mansa",186,"Sunshine"]
["2010-04-17","Chris",180,"Bellen"]
["2010-06-17","Yla-Katrina",153,"Sunshine"]
["2010-07-06","Mansa",117,"Bellen"]
["2010-04-29","Jason",193,"Majestic Beaut"]
["2010-05-30","Michael",114,"Sunset"]
["2010-07-02","Denise",189,"Sunset"]
["2010-07-06","Janita",182,"Carlota"]
["2010-05-24","Debra",118,"Sunshine"]
["2010-07-04","Debra",160,"Majestic Beaut"]
["2010-05-21","Christina",168,"Bellen"]
["2010-07-10","Michelle",131,"Bellen"]
["2010-03-29","Christina",106,"Bellen"]
["2010-05-06","Denise",181,"Sunset"]
["2010-06-25","Sarah",182,"Bellen"]
["2010-07-24","Daniel",189,"Sunshine"]
["2010-04-26","Denise",152,"Bellen"]
["2010-04-06","Michael",121,"Sunshine"]
["2010-04-18","Jason",189,"Bellen"]
["2010-04-12","Michael",108,"Sunshine"]
["2010-06-12","Debra",150,"Majestic Beaut"]
["2010-04-19","Sarah",170,"Bellen"]
["2010-05-27","Yla-Katrina",191,"Majestic Beaut"]
["2010-07-21","Daniel",109,"Sunset"]
["2010-06-02","Kaur",154,"Carlota"]
["2010-06-10","Elain",186,"Sunshine"]
["2010-06-23","Michelle",129,"Carlota"]
["2010-04-28","Michael",149,"Sunset"]
["2010-05-08","Mitchell",152,"Sunset"]
["2010-04-01","Mitchell",136,"Majestic Beaut"]
["2010-03-28","Christina",191,"Carlota"]
["2010-03-31","Michelle",154,"Sunset"]
["2010-05-19","Denise",191,"Majestic Beaut"]
["2010-05-08","Chris",131,"Majestic Beaut"]
["2010-03-27","Chris",109,"Majestic Beaut"]
["2010-05-04","Gianna",199,"Sunshine"]
["2010-07-23","Denise",178,"Majestic Beaut"]
["2010-07-05","Craig",151,"Sunshine"]
["2010-04-12","Thongtara",148,"Carlota"]
["2010-06-22","Craig",133,"Sunset"]
["2010-04-06","Yla-Katrina",161,"Sunshine"]
["2010-05-02","Denise",120,"Bellen"]
["2010-07-02","Elain",161,"Sunset"]
["2010-07-14","Elain",153,"Sunset"]
["2010-06-22","Michael",160,"Carlota"]
["2010-05-29","Sarah",128,"Bellen"]
["2010-06-25","Craig",104,"Sunset"]
["2010-04-16","Thongtara",199,"Carlota"]
["2010-03-27","Janita",111,"Bellen"]
["2010-04-12","Carol",195,"Majestic Beaut"]
["2010-06-16","Elain",146,"Bellen"]
["2010-04-24","Daniel",130,"Majestic Beaut"]
["2010-07-09","Mitchell",111,"Carlota"]
["2010-04-05","Daniel",113,"Carlota"]
["2010-05-21","Mansa",140,"Carlota"]
["2010-07-19","Michelle",165,"Carlota"]
["2010-06-27","Denise",130,"Sunset"]
["2010-05-14","Shari",114,"Carlota"]
["2010-04-05","Michael",127,"Sunset"]
["2010-04-30","Debra",199,"Carlota"]
["2010-04-28","Janita",117,"Majestic Beaut"]
["2010-06-01","Christina",176,"Bellen"]
["2010-07-15","Thongtara",193,"Carlota"]
["2010-06-18","Jason",152,"Sunshine"]
["2010-03-26","Yla-Katrina",152,"Bellen"]
["2010-05-21","Denise",119,"Sunshine"]
["2010-04-28","Denise",159,"Carlota"]
["2010-06-20","Carol",104,"Carlota"]
["2010-04-21","Christina",143,"Bellen"]
["2010-05-24","Elain",141,"Bellen"]
["2010-07-16","Kaur",111,"Carlota"]
["2010-06-24","Daniel",191,"Carlota"]
["2010-06-29","Nelia",165,"Carlota"]
["2010-04-02","Jason",157,"Bellen"]
["2010-04-10","Elain",111,"Bellen"]
["2010-04-09","Mansa",154,"Sunset"]
["2010-06-14","Michael",163,"Carlota"]
["2010-05-02","Nelia",143,"Sunset"]
["2010-06-17","Mansa",173,"Carlota"]
["2010-05-22","Christina",151,"Bellen"]
["2010-07-09","Carol",134,"Sunset"]
["2010-06-13","Ewelina",145,"Majestic Beaut"]
["2010-07-24","Mansa",192,"Sunset"]
["2010-06-21","Richard",114,"Sunset"]
["2010-07-05","Shari",190,"Carlota"]
["2010-07-15","Janita",156,"Sunshine"]
["2010-06-29","Sarah",198,"Sunshine"]
["2010-07-15","Shari",121,"Sunset"]
["2010-04-11","Nelia",156,"Majestic Beaut"]
["2010-05-26","Kaur",109,"Bellen"]
["2010-05-03","Michael",146,"Bellen"]
["2010-06-13","Nelia",192,"Sunset"]
["2010-07-21","Manavbir",102,"Carlota"]
["2010-04-07","Gianna",126,"Carlota"]
["2010-07-03","Craig",146,"Bellen"]
["2010-06-15","Manavbir",173,"Majestic Beaut"]
["2010-05-14","Carol",135,"Majestic Beaut"]
["2010-07-10","Ewelina",107,"Bellen"]
["2010-06-01","Mitchell",123,"Sunshine"]
["2010-05-15","Shari",137,"Carlota"]
["2010-04-14","Jason",199,"Sunshine"]
["2010-06-20","Yla-Katrina",152,"Carlota"]
["2010-05-06","Richard",112,"Bellen"]
["2010-06-21","Shari",160,"Sunshine"]
["2010-04-11","Craig",119,"Sunshine"]
["2010-07-05","Carol",115,"Sunset"]
["2010-05-01","Richard",182,"Carlota"]
["2010-06-18","Debra",200,"Sunset"]
["2010-03-31","Christina",196,"Sunset"]

{"sheet":"SUMIF s COUNTIF s (an)","index":1,"n_rows":768,"n_cols":10,"rows_kept":768,"cut":false,"hidden":true,"merged":[]}
["Date","SalesRep","Sales","Product (boomerangs)",null,"Function","What it does","Criteria","Do Formula","Formula"]
["2010-05-21","Denise",111,"Bellen",null,"SUMIF","add with 1 criterion/condition","Sunshine",{"$f":"SUMIF(D2:D768,$H$2,C2:C768)","v":25327},{"$f":"IF(I2=\"\",\"\",FormulaAsText)","v":" =SUMIF(D2:D768,$H$2,C2:C768)"}]
["2010-04-30","Thongtara",167,"Bellen",null,"COUNTIF","count with 1 criterion/condition","Janita ",{"$f":"COUNTIF(B2:B768,H3)","v":0},{"$f":"IF(I3=\"\",\"\",FormulaAsText)","v":" =COUNTIF(B2:B768,H3)"}]
["2010-04-19","Chris",191,"Sunshine",null,"SUMIFS","add with 1 or more criteria","Bellen",{"$f":"SUMIFS(C2:C768,D2:D768,H4,B2:B768,H5)","v":351},{"$f":"IF(I4=\"\",\"\",FormulaAsText)","v":" =SUMIFS(C2:C768,D2:D768,H4,B2:B768,H5)"}]
["2010-06-17","Ewelina",110,"Carlota",null,null,null,"Craig"]
["2010-07-22","Janita",146,"Carlota",null,"COUNTIFS","count with 1 or more criteria","Sarah",{"$f":"COUNTIFS(B2:B768,H6,$D2:$D768,H7)","v":3},{"$f":"IF(I6=\"\",\"\",FormulaAsText)","v":" =COUNTIFS(B2:B768,H6,$D2:$D768,H7)"}]
["2010-05-16","Elain",177,"Sunshine",null,null,null,"Sunset"]
["2010-06-05","Gianna",137,"Carlota"]
["2010-05-13","Richard",116,"Bellen",null,"SalesRep/Pro","Bellen","Sunshine","Carlota"]
["2010-05-14","Elain",166,"Sunshine",null,"Denise",{"$f":"SUMIFS($C$2:$C$768,$B$2:$B$768,$F10,$D$2:$D$768,G$9)","v":1285},1648,709]
["2010-06-12","Michael",193,"Bellen",null,"Thongtara",1183,1278,1590]
["2010-05-22","Ewelina",105,"Sunset",null,"Sykes",0,0,0]
["2010-07-19","Michelle",189,"Carlota",null,"Ewelina",1264,946,1616]
["2010-05-12","Jason",122,"Majestic Beaut",null,"Janita",689,453,1288]
["2010-06-05","Craig",196,"Sunshine",null,"Elain",789,1221,1758]
["2010-05-23","Sarah",161,"Sunshine",null,"Gianna",433,764,812]
["2010-05-29","Mansa",197,"Majestic Beaut",null,"Richard",706,910,655]
["2010-07-21","Michelle",113,"Sunset",null,"Michael",1469,1650,798]
["2010-06-30","Shari",111,"Bellen",null,"Michelle",867,1085,1424]
["2010-04-19","Richard",164,"Sunshine",null,"Jason",1293,1544,935]
["2010-06-19","Christina",167,"Majestic Beaut",null,"Craig",351,1572,1218]
["2010-07-01","Denise",129,"Bellen",null,"Sarah",851,846,1180]
["2010-04-29","Richard",122,"Sunshine",null,"Mansa",475,886,459]
["2010-03-27","Thongtara",132,"Sunshine",null,"Shari",359,1027,905]
["2010-04-13","Michelle",178,"Carlota",null,"Christina",1187,1050,1253]
["2010-07-18","Michelle",199,"Bellen",null,"Carol",636,1125,977]
["2010-05-27","Shari",181,"Majestic Beaut",null,"Kaur",967,412,1135]
["2010-06-15","Carol",110,"Carlota",null,"Mitchell",700,547,1003]
["2010-04-08","Kaur",104,"Sunset",null,"Debra",583,1459,1010]
["2010-06-23","Mitchell",110,"Sunshine",null,"Manavbir",856,1317,1356]
["2010-06-21","Debra",185,"Carlota",null,"Daniel",1039,969,1623]
["2010-05-01","Manavbir",183,"Sunset",null,"Yla-Katrina",947,721,1062]
["2010-07-07","Chris",143,"Sunset",null,"Nelia",712,532,908]
["2010-07-12","Elain",120,"Carlota"]
["2010-06-22","Michelle",147,"Sunshine"]
["2010-05-15","Jason",117,"Sunshine"]
["2010-03-31","Mansa",128,"Bellen"]
["2010-04-16","Shari",110,"Sunshine"]
["2010-05-23","Kaur",158,"Carlota"]
["2010-04-09","Manavbir",133,"Sunset"]
["2010-05-17","Debra",190,"Majestic Beaut"]
["2010-07-13","Sarah",138,"Sunshine"]
["2010-04-01","Daniel",143,"Sunset"]
["2010-04-12","Manavbir",167,"Carlota"]
["2010-04-02","Thongtara",135,"Carlota"]
["2010-05-22","Carol",125,"Sunshine"]
["2010-07-08","Janita",107,"Carlota"]
["2010-06-10","Carol",162,"Bellen"]
["2010-07-13","Thongtara",192,"Majestic Beaut"]
["2010-06-05","Daniel",152,"Carlota"]
["2010-04-28","Gianna",155,"Majestic Beaut"]
["2010-07-08","Kaur",155,"Sunshine"]
["2010-05-06","Mansa",145,"Sunshine"]
["2010-07-10","Janita",149,"Carlota"]
["2010-06-24","Kaur",180,"Sunset"]
["2010-05-07","Yla-Katrina",190,"Bellen"]
["2010-07-01","Richard",127,"Sunset"]
["2010-03-30","Christina",114,"Carlota"]
["2010-04-18","Carol",191,"Majestic Beaut"]
["2010-07-02","Chris",197,"Sunshine"]
["2010-05-09","Chris",186,"Bellen"]
["2010-06-10","Gianna",174,"Carlota"]
["2010-05-29","Yla-Katrina",114,"Carlota"]
["2010-07-05","Jason",121,"Bellen"]
["2010-03-28","Debra",134,"Sunshine"]
["2010-06-15","Carol",174,"Carlota"]
["2010-05-06","Craig",178,"Majestic Beaut"]
["2010-06-01","Ewelina",132,"Sunshine"]
["2010-06-02","Sarah",148,"Carlota"]
["2010-04-05","Michelle",120,"Sunset"]
["2010-06-01","Thongtara",199,"Sunshine"]
["2010-03-31","Michelle",109,"Majestic Beaut"]
["2010-06-27","Gianna",138,"Carlota"]
["2010-05-27","Thongtara",153,"Bellen"]
["2010-06-19","Janita",122,"Bellen"]
["2010-07-21","Michael",154,"Bellen"]
["2010-06-19","Jason",174,"Sunset"]
["2010-07-14","Denise",181,"Bellen"]
["2010-06-25","Sarah",113,"Bellen"]
["2010-04-01","Nelia",177,"Sunset"]
["2010-07-12","Mitchell",138,"Majestic Beaut"]
["2010-05-21","Denise",175,"Bellen"]
["2010-04-16","Ewelina",149,"Majestic Beaut"]
["2010-05-11","Shari",140,"Majestic Beaut"]
["2010-05-03","Michelle",152,"Carlota"]
["2010-04-20","Jason",104,"Bellen"]
["2010-06-07","Daniel",116,"Majestic Beaut"]
["2010-05-06","Chris",131,"Carlota"]
["2010-04-07","Thongtara",135,"Sunshine"]
["2010-06-04","Michelle",164,"Sunset"]
["2010-03-27","Manavbir",178,"Sunset"]
["2010-04-08","Debra",139,"Sunshine"]
["2010-05-04","Carol",160,"Carlota"]
["2010-07-07","Ewelina",162,"Bellen"]
["2010-06-19","Shari",103,"Sunshine"]
["2010-05-09","Kaur",200,"Carlota"]
["2010-04-21","Mansa",132,"Sunset"]
["2010-04-12","Sarah",133,"Sunshine"]
["2010-06-23","Mansa",187,"Majestic Beaut"]
["2010-07-22","Michael",173,"Majestic Beaut"]
["2010-06-07","Chris",112,"Sunshine"]
["2010-04-22","Daniel",132,"Bellen"]
["2010-04-27","Chris",112,"Sunset"]
["2010-04-23","Daniel",131,"Carlota"]
["2010-05-25","Craig",175,"Sunshine"]
["2010-07-19","Craig",158,"Sunshine"]
["2010-04-26","Ewelina",148,"Bellen"]
["2010-06-09","Daniel",187,"Sunset"]
["2010-07-07","Mansa",168,"Majestic Beaut"]
["2010-04-25","Nelia",116,"Majestic Beaut"]
["2010-03-26","Jason",122,"Carlota"]
["2010-05-21","Debra",160,"Sunshine"]
["2010-05-13","Debra",192,"Carlota"]
["2010-05-19","Christina",154,"Sunset"]
["2010-04-06","Jason",145,"Sunshine"]
["2010-05-03","Richard",178,"Sunshine"]
["2010-05-04","Sarah",112,"Sunset"]
["2010-07-04","Elain",115,"Carlota"]
["2010-05-25","Mansa",146,"Carlota"]
["2010-06-15","Debra",109,"Majestic Beaut"]
["2010-07-21","Denise",172,"Carlota"]
["2010-05-22","Daniel",146,"Sunshine"]
["2010-06-30","Richard",144,"Bellen"]
["2010-06-23","Mitchell",146,"Carlota"]
["2010-04-28","Kaur",105,"Sunshine"]
["2010-06-25","Ewelina",134,"Carlota"]
["2010-07-11","Richard",118,"Carlota"]
["2010-07-10","Debra",132,"Bellen"]
["2010-05-27","Carol",117,"Sunset"]
["2010-04-03","Michelle",194,"Carlota"]
["2010-04-27","Debra",122,"Sunshine"]
["2010-06-29","Michelle",134,"Sunset"]
["2010-07-11","Chris",134,"Sunshine"]
["2010-03-30","Elain",125,"Sunset"]
["2010-04-05","Carol",115,"Majestic Beaut"]
["2010-04-04","Christina",105,"Sunset"]
["2010-06-24","Christina",179,"Bellen"]
["2010-06-22","Elain",114,"Sunset"]
["2010-06-06","Elain",176,"Carlota"]
["2010-04-25","Shari",194,"Sunset"]
["2010-05-18","Mitchell",170,"Majestic Beaut"]
["2010-07-14","Ewelina",144,"Carlota"]
["2010-05-06","Christina",175,"Carlota"]
["2010-07-22","Michelle",185,"Sunshine"]
["2010-07-02","Carol",133,"Majestic Beaut"]
["2010-05-21","Sarah",131,"Sunset"]
["2010-06-15","Mansa",163,"Sunshine"]
["2010-03-26","Denise",120,"Sunshine"]
["2010-05-04","Manavbir",136,"Majestic Beaut"]
["2010-03-28","Gianna",195,"Sunset"]
["2010-04-21","Yla-Katrina",157,"Sunset"]
["2010-05-27","Michelle",187,"Majestic Beaut"]
["2010-05-15","Christina",185,"Carlota"]
["2010-07-10","Jason",154,"Sunset"]
["2010-06-13","Jason",187,"Sunshine"]
["2010-07-14","Gianna",142,"Sunshine"]
["2010-07-19","Denise",132,"Majestic Beaut"]
["2010-07-11","Mitchell",127,"Sunset"]
["2010-05-27","Mansa",184,"Majestic Beaut"]
["2010-06-23","Thongtara",164,"Bellen"]
["2010-04-28","Chris",157,"Sunset"]
["2010-07-05","Craig",186,"Majestic Beaut"]
["2010-05-23","Elain",135,"Carlota"]
["2010-06-25","Janita",194,"Carlota"]
["2010-04-05","Thongtara",177,"Sunset"]
["2010-05-05","Mitchell",143,"Carlota"]
["2010-05-18","Manavbir",152,"Sunset"]
["2010-06-03","Nelia",101,"Sunset"]
["2010-05-05","Janita",110,"Majestic Beaut"]
["2010-06-15","Denise",124,"Carlota"]
["2010-05-08","Christina",102,"Sunshine"]
["2010-07-16","Richard",139,"Sunset"]
["2010-05-06","Janita",152,"Bellen"]
["2010-05-17","Janita",168,"Majestic Beaut"]
["2010-04-01","Michael",151,"Majestic Beaut"]
["2010-05-06","Gianna",137,"Sunshine"]
["2010-07-13","Janita",104,"Carlota"]
["2010-04-09","Nelia",139,"Carlota"]
["2010-07-04","Daniel",147,"Sunshine"]
["2010-07-09","Mansa",190,"Majestic Beaut"]
["2010-07-19","Nelia",159,"Carlota"]
["2010-03-28","Manavbir",112,"Carlota"]
["2010-05-08","Christina",182,"Majestic Beaut"]
["2010-05-16","Richard",121,"Sunset"]
["2010-05-25","Kaur",181,"Majestic Beaut"]
["2010-06-03","Craig",104,"Bellen"]
["2010-06-01","Chris",194,"Sunset"]
["2010-03-29","Christina",178,"Sunshine"]
["2010-06-27","Carol",142,"Sunshine"]
["2010-04-09","Mitchell",191,"Bellen"]
["2010-06-26","Sarah",120,"Bellen"]
["2010-05-10","Carol",155,"Sunshine"]
["2010-05-03","Manavbir",199,"Sunshine"]
["2010-05-12","Thongtara",106,"Sunshine"]
["2010-04-28","Elain",149,"Majestic Beaut"]
["2010-06-09","Michelle",158,"Bellen"]
["2010-04-01","Gianna",144,"Bellen"]
["2010-05-13","Daniel",143,"Bellen"]
["2010-07-09","Daniel",177,"Sunshine"]
["2010-04-03","Manavbir",142,"Majestic Beaut"]
["2010-05-25","Debra",193,"Majestic Beaut"]
["2010-07-10","Michelle",193,"Sunshine"]
["2010-07-04","Mitchell",112,"Sunset"]
["2010-03-29","Michelle",123,"Majestic Beaut"]
["2010-06-15","Michael",197,"Bellen"]
["2010-04-18","Thongtara",155,"Carlota"]
["2010-05-10","Janita",118,"Carlota"]
["2010-04-30","Denise",169,"Sunshine"]
["2010-05-19","Daniel",172,"Bellen"]
["2010-06-20","Michael",132,"Sunshine"]
["2010-06-23","Yla-Katrina",154,"Majestic Beaut"]
["2010-07-17","Christina",152,"Sunshine"]
["2010-06-16","Craig",128,"Carlota"]
["2010-07-06","Thongtara",101,"Sunshine"]
["2010-04-25","Elain",174,"Carlota"]
["2010-04-06","Denise",124,"Bellen"]
["2010-06-24","Craig",172,"Sunshine"]
["2010-04-01","Ewelina",165,"Bellen"]
["2010-06-03","Thongtara",117,"Sunshine"]
["2010-04-17","Mitchell",109,"Carlota"]
["2010-04-08","Carol",172,"Sunshine"]
["2010-06-20","Sarah",115,"Majestic Beaut"]
["2010-05-19","Shari",125,"Sunset"]
["2010-03-28","Chris",113,"Sunshine"]
["2010-05-02","Debra",152,"Bellen"]
["2010-07-09","Craig",144,"Majestic Beaut"]
["2010-04-04","Denise",153,"Bellen"]
["2010-07-21","Thongtara",188,"Carlota"]
["2010-06-23","Mansa",105,"Bellen"]
["2010-05-24","Chris",144,"Sunset"]
["2010-05-01","Daniel",196,"Bellen"]
["2010-04-09","Denise",145,"Sunshine"]
["2010-04-28","Manavbir",134,"Sunshine"]
["2010-04-03","Carol",196,"Sunshine"]
["2010-06-21","Michael",110,"Carlota"]
["2010-03-27","Shari",172,"Majestic Beaut"]
["2010-06-21","Michael",174,"Bellen"]
["2010-05-13","Gianna",109,"Majestic Beaut"]
["2010-04-21","Sarah",181,"Sunset"]
["2010-05-06","Michael",185,"Sunshine"]
["2010-06-04","Gianna",170,"Sunset"]
["2010-07-04","Jason",179,"Carlota"]
["2010-04-16","Mitchell",109,"Majestic Beaut"]
["2010-07-22","Jason",110,"Sunset"]
["2010-07-07","Craig",137,"Sunshine"]
["2010-07-07","Ewelina",128,"Sunset"]
["2010-05-15","Carol",183,"Sunshine"]
["2010-04-18","Mitchell",200,"Bellen"]
["2010-07-12","Denise",114,"Sunshine"]
["2010-04-14","Gianna",144,"Bellen"]
["2010-04-29","Elain",142,"Majestic Beaut"]
["2010-06-15","Daniel",167,"Sunset"]
["2010-05-10","Ewelina",169,"Carlota"]
["2010-07-01","Manavbir",131,"Carlota"]
["2010-05-21","Denise",113,"Majestic Beaut"]
["2010-05-06","Thongtara",162,"Carlota"]
["2010-05-14","Carol",152,"Sunshine"]
["2010-05-05","Elain",143,"Bellen"]
["2010-04-03","Yla-Katrina",171,"Carlota"]
["2010-04-03","Michael",147,"Sunshine"]
["2010-04-06","Nelia",164,"Sunset"]
["2010-05-28","Elain",163,"Carlota"]
["2010-07-05","Christina",148,"Sunset"]
["2010-05-09","Yla-Katrina",109,"Bellen"]
["2010-07-17","Daniel",179,"Carlota"]
["2010-04-17","Elain",130,"Carlota"]
["2010-04-25","Jason",197,"Carlota"]
["2010-05-06","Craig",106,"Carlota"]
["2010-07-21","Janita",145,"Carlota"]
["2010-07-18","Yla-Katrina",133,"Bellen"]
["2010-06-24","Elain",195,"Carlota"]
["2010-03-28","Debra",151,"Majestic Beaut"]
["2010-05-21","Shari",102,"Bellen"]
["2010-05-17","Kaur",152,"Carlota"]
["2010-05-11","Yla-Katrina",168,"Bellen"]
["2010-04-27","Nelia",139,"Carlota"]
["2010-04-27","Gianna",159,"Sunshine"]
["2010-05-10","Thongtara",142,"Carlota"]
["2010-06-06","Mitchell",141,"Sunshine"]
["2010-06-16","Jason",114,"Sunshine"]
["2010-07-08","Richard",102,"Carlota"]
["2010-05-15","Thongtara",119,"Majestic Beaut"]
["2010-07-03","Richard",196,"Sunshine"]
["2010-07-08","Manavbir",164,"Bellen"]
["2010-04-22","Manavbir",115,"Sunshine"]
["2010-05-06","Daniel",178,"Bellen"]
["2010-04-16","Richard",153,"Majestic Beaut"]
["2010-05-18","Ewelina",101,"Majestic Beaut"]
["2010-07-11","Thongtara",151,"Majestic Beaut"]
["2010-05-18","Debra",115,"Bellen"]
["2010-06-10","Debra",170,"Sunset"]
["2010-04-11","Sarah",112,"Sunshine"]
["2010-04-11","Daniel",163,"Carlota"]
["2010-05-29","Mitchell",181,"Majestic Beaut"]
["2010-07-07","Chris",108,"Bellen"]
["2010-03-28","Daniel",114,"Bellen"]
["2010-04-23","Carol",119,"Majestic Beaut"]
["2010-04-06","Michelle",168,"Sunshine"]
["2010-03-28","Manavbir",191,"Sunset"]
["2010-05-21","Debra",152,"Sunshine"]
["2010-04-01","Shari",155,"Sunshine"]
["2010-07-22","Richard",128,"Sunshine"]
["2010-04-30","Elain",185,"Sunshine"]
["2010-04-13","Michelle",164,"Bellen"]
["2010-07-08","Kaur",130,"Majestic Beaut"]
["2010-04-20","Manavbir",148,"Majestic Beaut"]
["2010-06-18","Manavbir",190,"Bellen"]
["2010-07-20","Elain",115,"Sunset"]
["2010-06-26","Manavbir",123,"Sunset"]
["2010-06-08","Ewelina",168,"Majestic Beaut"]
["2010-07-20","Janita",124,"Majestic Beaut"]
["2010-06-21","Michael",178,"Sunset"]
["2010-07-19","Ewelina",101,"Sunshine"]
["2010-04-01","Michael",136,"Carlota"]
["2010-03-28","Janita",174,"Majestic Beaut"]
["2010-07-09","Nelia",156,"Sunshine"]
["2010-04-08","Daniel",131,"Majestic Beaut"]
["2010-05-19","Craig",152,"Majestic Beaut"]
["2010-06-05","Nelia",193,"Sunshine"]
["2010-06-20","Manavbir",165,"Sunset"]
["2010-04-10","Nelia",158,"Carlota"]
["2010-05-24","Elain",104,"Carlota"]
["2010-07-01","Thongtara",186,"Bellen"]
["2010-04-10","Ewelina",150,"Sunshine"]
["2010-04-24","Thongtara",167,"Bellen"]
["2010-07-12","Debra",184,"Bellen"]
["2010-04-10","Carol",121,"Bellen"]
["2010-07-15","Chris",184,"Bellen"]
["2010-03-28","Yla-Katrina",187,"Majestic Beaut"]
["2010-04-20","Chris",140,"Sunshine"]
["2010-06-11","Carol",129,"Carlota"]
["2010-06-14","Carol",184,"Carlota"]
["2010-07-11","Christina",147,"Sunset"]
["2010-06-28","Jason",182,"Majestic Beaut"]
["2010-04-30","Manavbir",132,"Bellen"]
["2010-04-15","Sarah",158,"Carlota"]
["2010-04-26","Daniel",184,"Sunshine"]
["2010-03-30","Christina",107,"Carlota"]
["2010-05-27","Craig",148,"Carlota"]
["2010-06-25","Thongtara",132,"Sunset"]
["2010-03-29","Daniel",127,"Carlota"]
["2010-05-28","Christina",184,"Majestic Beaut"]
["2010-04-04","Ewelina",172,"Bellen"]
["2010-04-13","Daniel",147,"Carlota"]
["2010-04-22","Michael",124,"Sunshine"]
["2010-04-11","Michael",184,"Sunshine"]
["2010-05-05","Shari",196,"Sunset"]
["2010-06-11","Shari",122,"Carlota"]
["2010-04-01","Shari",148,"Carlota"]
["2010-06-29","Debra",136,"Sunset"]
["2010-06-06","Christina",133,"Bellen"]
["2010-04-13","Richard",182,"Bellen"]
["2010-05-14","Michael",167,"Sunshine"]
["2010-05-13","Craig",133,"Sunset"]
["2010-05-06","Carol",134,"Sunset"]
["2010-06-26","Debra",142,"Sunset"]
["2010-05-31","Mitchell",165,"Carlota"]
["2010-07-11","Kaur",177,"Carlota"]
["2010-04-12","Jason",107,"Majestic Beaut"]
["2010-07-03","Gianna",139,"Majestic Beaut"]
["2010-05-28","Manavbir",111,"Carlota"]
["2010-06-28","Chris",156,"Bellen"]
["2010-06-23","Kaur",152,"Sunshine"]
["2010-07-16","Mansa",138,"Sunset"]
["2010-06-04","Michael",162,"Majestic Beaut"]
["2010-03-29","Ewelina",157,"Sunshine"]
["2010-07-04","Ewelina",175,"Bellen"]
["2010-04-12","Kaur",135,"Majestic Beaut"]
["2010-05-05","Kaur",194,"Majestic Beaut"]
["2010-05-28","Jason",107,"Bellen"]
["2010-07-03","Craig",108,"Carlota"]
["2010-06-01","Carol",198,"Majestic Beaut"]
["2010-07-01","Janita",145,"Sunset"]
["2010-04-18","Mitchell",168,"Sunset"]
["2010-05-04","Mitchell",137,"Sunset"]
["2010-05-23","Gianna",145,"Bellen"]
["2010-06-29","Daniel",178,"Sunset"]
["2010-04-30","Manavbir",152,"Majestic Beaut"]
["2010-04-11","Chris",120,"Sunshine"]
["2010-06-14","Nelia",148,"Carlota"]
["2010-05-27","Kaur",175,"Bellen"]
["2010-07-23","Christina",131,"Bellen"]
["2010-07-16","Kaur",172,"Bellen"]
["2010-05-26","Janita",155,"Sunset"]
["2010-04-29","Denise",199,"Sunshine"]
["2010-04-10","Craig",187,"Carlota"]
["2010-05-21","Gianna",127,"Sunshine"]
["2010-05-01","Jason",200,"Bellen"]
["2010-05-27","Sarah",133,"Carlota"]
["2010-06-01","Janita",163,"Sunset"]
["2010-04-10","Manavbir",131,"Majestic Beaut"]
["2010-07-19","Ewelina",125,"Sunset"]
["2010-06-25","Shari",170,"Majestic Beaut"]
["2010-04-14","Ewelina",150,"Carlota"]
["2010-03-31","Daniel",126,"Sunshine"]
["2010-05-08","Thongtara",175,"Majestic Beaut"]
["2010-03-30","Michael",180,"Majestic Beaut"]
["2010-06-04","Gianna",168,"Majestic Beaut"]
["2010-03-26","Chris",174,"Majestic Beaut"]
["2010-04-16","Chris",175,"Sunset"]
["2010-06-13","Thongtara",129,"Carlota"]
["2010-03-26","Michelle",107,"Bellen"]
["2010-06-13","Sarah",138,"Bellen"]
["2010-04-19","Christina",140,"Sunset"]
["2010-05-12","Elain",166,"Majestic Beaut"]
["2010-06-28","Yla-Katrina",137,"Majestic Beaut"]
["2010-04-03","Craig",172,"Sunshine"]
["2010-05-11","Richard",119,"Carlota"]
["2010-07-05","Ewelina",165,"Majestic Beaut"]
["2010-07-07","Mitchell",143,"Majestic Beaut"]
["2010-07-05","Yla-Katrina",139,"Carlota"]
["2010-05-23","Nelia",190,"Majestic Beaut"]
["2010-07-01","Jason",160,"Majestic Beaut"]
["2010-06-14","Craig",175,"Sunshine"]
["2010-06-19","Gianna",106,"Carlota"]
["2010-07-24","Ewelina",197,"Carlota"]
["2010-05-28","Kaur",152,"Sunset"]
["2010-05-08","Chris",167,"Majestic Beaut"]
["2010-03-29","Jason",183,"Majestic Beaut"]
["2010-06-09","Denise",140,"Bellen"]
["2010-06-26","Denise",141,"Carlota"]
["2010-05-11","Kaur",173,"Bellen"]
["2010-05-18","Daniel",113,"Carlota"]
["2010-04-30","Nelia",105,"Bellen"]
["2010-05-02","Michelle",139,"Carlota"]
["2010-07-04","Thongtara",199,"Sunshine"]
["2010-06-25","Yla-Katrina",126,"Carlota"]
["2010-07-03","Richard",200,"Sunset"]
["2010-04-25","Carol",119,"Majestic Beaut"]
["2010-06-23","Debra",186,"Sunshine"]
["2010-06-29","Mansa",115,"Sunset"]
["2010-04-05","Denise",103,"Sunshine"]
["2010-04-24","Michael",102,"Bellen"]
["2010-06-12","Manavbir",196,"Bellen"]
["2010-06-30","Denise",151,"Sunshine"]
["2010-04-21","Jason",187,"Bellen"]
["2010-06-28","Richard",168,"Majestic Beaut"]
["2010-05-08","Michael",180,"Sunshine"]
["2010-05-21","Janita",136,"Sunset"]
["2010-05-27","Manavbir",145,"Carlota"]
["2010-04-18","Yla-Katrina",141,"Sunset"]
["2010-06-05","Michelle",160,"Carlota"]
["2010-05-15","Kaur",166,"Bellen"]
["2010-04-11","Ewelina",145,"Majestic Beaut"]
["2010-05-02","Shari",131,"Sunshine"]
["2010-07-09","Denise",193,"Sunset"]
["2010-05-29","Daniel",144,"Carlota"]
["2010-05-01","Elain",132,"Bellen"]
["2010-06-14","Janita",114,"Sunset"]
["2010-07-23","Craig",160,"Sunset"]
["2010-06-16","Christina",194,"Sunset"]
["2010-05-10","Shari",129,"Sunshine"]
["2010-04-24","Mitchell",134,"Carlota"]
["2010-06-22","Manavbir",172,"Majestic Beaut"]
["2010-06-18","Elain",116,"Bellen"]
["2010-04-06","Debra",112,"Sunshine"]
["2010-04-21","Carol",185,"Sunset"]
["2010-05-17","Nelia",149,"Sunset"]
["2010-06-13","Sarah",175,"Majestic Beaut"]
["2010-05-12","Richard",193,"Sunset"]
["2010-04-26","Manavbir",108,"Sunset"]
["2010-07-19","Chris",182,"Sunset"]
["2010-04-25","Shari",138,"Sunset"]
["2010-04-10","Michael",112,"Carlota"]
["2010-06-22","Michael",111,"Majestic Beaut"]
["2010-04-11","Craig",101,"Bellen"]
["2010-04-27","Daniel",113,"Majestic Beaut"]
["2010-04-02","Jason",123,"Sunshine"]
["2010-06-08","Michelle",137,"Sunshine"]
["2010-04-19","Thongtara",149,"Sunset"]
["2010-04-16","Shari",117,"Sunset"]
["2010-04-28","Jason",168,"Sunshine"]
["2010-05-05","Christina",109,"Sunset"]
["2010-06-13","Elain",107,"Carlota"]
["2010-06-19","Jason",121,"Carlota"]
["2010-06-07","Michelle",130,"Sunshine"]
["2010-04-18","Kaur",172,"Bellen"]
["2010-05-06","Elain",147,"Sunshine"]
["2010-07-21","Sarah",170,"Carlota"]
["2010-05-08","Christina",161,"Sunset"]
["2010-06-29","Manavbir",130,"Sunshine"]
["2010-06-02","Michael",118,"Majestic Beaut"]
["2010-05-28","Ewelina",103,"Majestic Beaut"]
["2010-05-29","Daniel",186,"Majestic Beaut"]
["2010-04-05","Michael",189,"Bellen"]
["2010-05-10","Denise",186,"Sunshine"]
["2010-07-21","Manavbir",110,"Carlota"]
["2010-04-04","Manavbir",144,"Sunshine"]
["2010-04-25","Shari",146,"Bellen"]
["2010-06-17","Thongtara",139,"Carlota"]
["2010-05-23","Carol",157,"Bellen"]
["2010-05-10","Yla-Katrina",117,"Sunshine"]
["2010-07-23","Carol",135,"Sunset"]
["2010-06-30","Elain",142,"Majestic Beaut"]
["2010-06-18","Manavbir",127,"Sunshine"]
["2010-07-20","Daniel",123,"Sunset"]
["2010-06-12","Debra",146,"Sunset"]
["2010-04-12","Manavbir",141,"Sunshine"]
["2010-05-02","Yla-Katrina",195,"Bellen"]
["2010-05-16","Elain",160,"Majestic Beaut"]
["2010-05-11","Nelia",128,"Bellen"]
["2010-05-30","Ewelina",166,"Carlota"]
["2010-04-10","Debra",194,"Sunset"]
["2010-07-04","Christina",187,"Sunshine"]
["2010-04-05","Michael",165,"Sunshine"]
["2010-04-12","Thongtara",103,"Sunshine"]
["2010-04-01","Craig",199,"Carlota"]
["2010-04-02","Chris",141,"Sunset"]
["2010-04-04","Christina",112,"Majestic Beaut"]
["2010-05-16","Daniel",163,"Carlota"]
["2010-04-15","Janita",186,"Sunshine"]
["2010-05-21","Sarah",144,"Carlota"]
["2010-07-08","Shari",117,"Sunshine"]
["2010-05-13","Ewelina",169,"Majestic Beaut"]
["2010-06-11","Thongtara",185,"Sunset"]
["2010-05-17","Michelle",131,"Majestic Beaut"]
["2010-06-16","Michael",137,"Sunshine"]
["2010-05-16","Michael",195,"Majestic Beaut"]
["2010-07-21","Janita",128,"Bellen"]
["2010-06-13","Elain",192,"Sunshine"]
["2010-05-27","Manavbir",184,"Sunshine"]
["2010-04-10","Elain",106,"Majestic Beaut"]
["2010-06-11","Ewelina",152,"Carlota"]
["2010-06-03","Chris",149,"Carlota"]
["2010-04-21","Mitchell",198,"Bellen"]
["2010-07-24","Carol",142,"Sunset"]
["2010-06-23","Richard",122,"Sunshine"]
["2010-06-04","Jason",129,"Sunset"]
["2010-06-10","Richard",134,"Carlota"]
["2010-04-25","Manavbir",160,"Sunset"]
["2010-06-30","Craig",117,"Sunshine"]
["2010-04-18","Michael",153,"Sunset"]
["2010-06-22","Christina",103,"Sunset"]
["2010-04-28","Mansa",106,"Sunshine"]
["2010-04-28","Jason",156,"Sunshine"]
["2010-03-31","Denise",113,"Carlota"]
["2010-04-09","Christina",161,"Sunshine"]
["2010-04-09","Elain",158,"Carlota"]
["2010-05-22","Ewelina",109,"Sunshine"]
["2010-07-03","Jason",132,"Majestic Beaut"]
["2010-05-03","Janita",129,"Sunset"]
["2010-06-09","Yla-Katrina",112,"Sunshine"]
["2010-04-05","Michael",123,"Bellen"]
["2010-03-26","Gianna",154,"Sunset"]
["2010-07-23","Jason",115,"Bellen"]
["2010-07-13","Michelle",118,"Carlota"]
["2010-05-29","Carol",116,"Carlota"]
["2010-04-30","Manavbir",147,"Majestic Beaut"]
["2010-07-19","Mitchell",144,"Majestic Beaut"]
["2010-06-17","Nelia",148,"Bellen"]
["2010-07-15","Mitchell",195,"Carlota"]
["2010-04-21","Ewelina",182,"Sunshine"]
["2010-04-11","Ewelina",115,"Sunshine"]
["2010-04-20","Sarah",152,"Carlota"]
["2010-06-08","Mitchell",111,"Majestic Beaut"]
["2010-04-16","Chris",142,"Majestic Beaut"]
["2010-06-30","Ewelina",191,"Bellen"]
["2010-07-07","Yla-Katrina",168,"Majestic Beaut"]
["2010-06-08","Kaur",174,"Sunset"]
["2010-07-02","Chris",200,"Sunshine"]
["2010-05-28","Manavbir",181,"Sunset"]
["2010-05-02","Chris",183,"Majestic Beaut"]
["2010-07-03","Manavbir",179,"Carlota"]
["2010-05-05","Sarah",104,"Sunshine"]
["2010-07-07","Jason",150,"Carlota"]
["2010-06-09","Richard",154,"Sunset"]
["2010-04-07","Mansa",119,"Sunshine"]
["2010-07-17","Kaur",183,"Carlota"]
["2010-04-16","Michael",110,"Sunset"]
["2010-04-22","Yla-Katrina",116,"Sunset"]
["2010-07-09","Jason",185,"Sunset"]
["2010-04-02","Elain",123,"Sunset"]
["2010-05-11","Yla-Katrina",193,"Carlota"]
["2010-04-01","Debra",126,"Sunset"]
["2010-06-29","Jason",113,"Bellen"]
["2010-06-13","Ewelina",114,"Carlota"]
["2010-04-14","Nelia",157,"Bellen"]
["2010-07-14","Manavbir",186,"Sunset"]
["2010-03-28","Thongtara",198,"Bellen"]
["2010-07-13","Sarah",159,"Carlota"]
["2010-04-27","Thongtara",148,"Bellen"]
["2010-03-29","Craig",121,"Majestic Beaut"]
["2010-07-19","Jason",183,"Sunshine"]
["2010-03-28","Mitchell",111,"Bellen"]
["2010-07-08","Denise",144,"Sunset"]
["2010-05-23","Manavbir",143,"Sunshine"]
["2010-05-06","Gianna",189,"Sunset"]
["2010-07-08","Mitchell",173,"Sunshine"]
["2010-04-15","Denise",161,"Majestic Beaut"]
["2010-04-27","Gianna",131,"Carlota"]
["2010-04-02","Craig",102,"Sunset"]
["2010-06-12","Manavbir",174,"Bellen"]
["2010-04-26","Craig",166,"Carlota"]
["2010-05-15","Mansa",125,"Bellen"]
["2010-05-25","Jason",140,"Majestic Beaut"]
["2010-06-23","Debra",190,"Carlota"]
["2010-04-19","Kaur",101,"Majestic Beaut"]
["2010-05-17","Richard",162,"Sunset"]
["2010-07-22","Denise",114,"Sunset"]
["2010-04-20","Craig",176,"Carlota"]
["2010-05-02","Mansa",167,"Sunshine"]
["2010-06-20","Debra",104,"Carlota"]
["2010-07-21","Michael",191,"Bellen"]
["2010-04-02","Janita",143,"Carlota"]
["2010-05-17","Sarah",101,"Majestic Beaut"]
["2010-06-21","Christina",188,"Carlota"]
["2010-04-04","Manavbir",164,"Majestic Beaut"]
["2010-07-07","Michael",117,"Carlota"]
["2010-06-12","Nelia",174,"Bellen"]
["2010-04-11","Yla-Katrina",178,"Sunshine"]
["2010-06-27","Debra",177,"Sunshine"]
["2010-07-12","Chris",114,"Sunset"]
["2010-04-04","Yla-Katrina",179,"Majestic Beaut"]
["2010-06-06","Debra",107,"Majestic Beaut"]
["2010-04-02","Michelle",108,"Bellen"]
["2010-05-18","Denise",151,"Sunshine"]
["2010-05-11","Debra",159,"Sunshine"]
["2010-03-27","Kaur",194,"Majestic Beaut"]
["2010-06-12","Carol",196,"Bellen"]
["2010-06-22","Christina",114,"Carlota"]
["2010-05-30","Ewelina",161,"Majestic Beaut"]
["2010-05-22","Elain",168,"Sunshine"]
["2010-04-29","Michelle",125,"Sunshine"]
["2010-03-31","Gianna",143,"Sunset"]
["2010-06-23","Manavbir",107,"Carlota"]
["2010-07-18","Thongtara",158,"Majestic Beaut"]
["2010-05-24","Kaur",160,"Sunset"]
["2010-06-24","Yla-Katrina",167,"Carlota"]
["2010-06-07","Denise",191,"Sunshine"]
["2010-06-04","Janita",111,"Sunshine"]
["2010-06-26","Richard",152,"Bellen"]
["2010-04-23","Christina",158,"Sunshine"]
["2010-07-09","Michael",163,"Sunset"]
["2010-07-08","Elain",181,"Carlota"]
["2010-06-20","Manavbir",192,"Carlota"]
["2010-06-14","Janita",124,"Sunset"]
["2010-05-15","Carol",180,"Sunset"]
["2010-04-02","Nelia",146,"Majestic Beaut"]
["2010-05-06","Sarah",116,"Carlota"]
["2010-07-04","Ewelina",144,"Bellen"]
["2010-06-29","Kaur",196,"Sunset"]
["2010-06-08","Ewelina",108,"Carlota"]
["2010-06-24","Michelle",158,"Sunset"]
["2010-04-23","Christina",179,"Carlota"]
["2010-06-19","Ewelina",199,"Sunset"]
["2010-05-31","Chris",158,"Sunshine"]
["2010-06-02","Mansa",168,"Majestic Beaut"]
["2010-04-14","Nelia",183,"Sunshine"]
["2010-04-15","Janita",176,"Bellen"]
["2010-05-06","Jason",166,"Carlota"]
["2010-04-02","Shari",122,"Sunshine"]
["2010-05-19","Daniel",104,"Bellen"]
["2010-07-13","Debra",140,"Carlota"]
["2010-05-03","Ewelina",172,"Carlota"]
["2010-06-09","Christina",112,"Sunshine"]
["2010-07-06","Gianna",133,"Sunset"]
["2010-06-07","Jason",104,"Sunset"]
["2010-04-07","Shari",194,"Carlota"]
["2010-05-13","Thongtara",186,"Sunshine"]
["2010-05-24","Mansa",186,"Sunshine"]
["2010-04-17","Chris",180,"Bellen"]
["2010-06-17","Yla-Katrina",153,"Sunshine"]
["2010-07-06","Mansa",117,"Bellen"]
["2010-04-29","Jason",193,"Majestic Beaut"]
["2010-05-30","Michael",114,"Sunset"]
["2010-07-02","Denise",189,"Sunset"]
["2010-07-06","Janita",182,"Carlota"]
["2010-05-24","Debra",118,"Sunshine"]
["2010-07-04","Debra",160,"Majestic Beaut"]
["2010-05-21","Christina",168,"Bellen"]
["2010-07-10","Michelle",131,"Bellen"]
["2010-03-29","Christina",106,"Bellen"]
["2010-05-06","Denise",181,"Sunset"]
["2010-06-25","Sarah",182,"Bellen"]
["2010-07-24","Daniel",189,"Sunshine"]
["2010-04-26","Denise",152,"Bellen"]
["2010-04-06","Michael",121,"Sunshine"]
["2010-04-18","Jason",189,"Bellen"]
["2010-04-12","Michael",108,"Sunshine"]
["2010-06-12","Debra",150,"Majestic Beaut"]
["2010-04-19","Sarah",170,"Bellen"]
["2010-05-27","Yla-Katrina",191,"Majestic Beaut"]
["2010-07-21","Daniel",109,"Sunset"]
["2010-06-02","Kaur",154,"Carlota"]
["2010-06-10","Elain",186,"Sunshine"]
["2010-06-23","Michelle",129,"Carlota"]
["2010-04-28","Michael",149,"Sunset"]
["2010-05-08","Mitchell",152,"Sunset"]
["2010-04-01","Mitchell",136,"Majestic Beaut"]
["2010-03-28","Christina",191,"Carlota"]
["2010-03-31","Michelle",154,"Sunset"]
["2010-05-19","Denise",191,"Majestic Beaut"]
["2010-05-08","Chris",131,"Majestic Beaut"]
["2010-03-27","Chris",109,"Majestic Beaut"]
["2010-05-04","Gianna",199,"Sunshine"]
["2010-07-23","Denise",178,"Majestic Beaut"]
["2010-07-05","Craig",151,"Sunshine"]
["2010-04-12","Thongtara",148,"Carlota"]
["2010-06-22","Craig",133,"Sunset"]
["2010-04-06","Yla-Katrina",161,"Sunshine"]
["2010-05-02","Denise",120,"Bellen"]
["2010-07-02","Elain",161,"Sunset"]
["2010-07-14","Elain",153,"Sunset"]
["2010-06-22","Michael",160,"Carlota"]
["2010-05-29","Sarah",128,"Bellen"]
["2010-06-25","Craig",104,"Sunset"]
["2010-04-16","Thongtara",199,"Carlota"]
["2010-03-27","Janita",111,"Bellen"]
["2010-04-12","Carol",195,"Majestic Beaut"]
["2010-06-16","Elain",146,"Bellen"]
["2010-04-24","Daniel",130,"Majestic Beaut"]
["2010-07-09","Mitchell",111,"Carlota"]
["2010-04-05","Daniel",113,"Carlota"]
["2010-05-21","Mansa",140,"Carlota"]
["2010-07-19","Michelle",165,"Carlota"]
["2010-06-27","Denise",130,"Sunset"]
["2010-05-14","Shari",114,"Carlota"]
["2010-04-05","Michael",127,"Sunset"]
["2010-04-30","Debra",199,"Carlota"]
["2010-04-28","Janita",117,"Majestic Beaut"]
["2010-06-01","Christina",176,"Bellen"]
["2010-07-15","Thongtara",193,"Carlota"]
["2010-06-18","Jason",152,"Sunshine"]
["2010-03-26","Yla-Katrina",152,"Bellen"]
["2010-05-21","Denise",119,"Sunshine"]
["2010-04-28","Denise",159,"Carlota"]
["2010-06-20","Carol",104,"Carlota"]
["2010-04-21","Christina",143,"Bellen"]
["2010-05-24","Elain",141,"Bellen"]
["2010-07-16","Kaur",111,"Carlota"]
["2010-06-24","Daniel",191,"Carlota"]
["2010-06-29","Nelia",165,"Carlota"]
["2010-04-02","Jason",157,"Bellen"]
["2010-04-10","Elain",111,"Bellen"]
["2010-04-09","Mansa",154,"Sunset"]
["2010-06-14","Michael",163,"Carlota"]
["2010-05-02","Nelia",143,"Sunset"]
["2010-06-17","Mansa",173,"Carlota"]
["2010-05-22","Christina",151,"Bellen"]
["2010-07-09","Carol",134,"Sunset"]
["2010-06-13","Ewelina",145,"Majestic Beaut"]
["2010-07-24","Mansa",192,"Sunset"]
["2010-06-21","Richard",114,"Sunset"]
["2010-07-05","Shari",190,"Carlota"]
["2010-07-15","Janita",156,"Sunshine"]
["2010-06-29","Sarah",198,"Sunshine"]
["2010-07-15","Shari",121,"Sunset"]
["2010-04-11","Nelia",156,"Majestic Beaut"]
["2010-05-26","Kaur",109,"Bellen"]
["2010-05-03","Michael",146,"Bellen"]
["2010-06-13","Nelia",192,"Sunset"]
["2010-07-21","Manavbir",102,"Carlota"]
["2010-04-07","Gianna",126,"Carlota"]
["2010-07-03","Craig",146,"Bellen"]
["2010-06-15","Manavbir",173,"Majestic Beaut"]
["2010-05-14","Carol",135,"Majestic Beaut"]
["2010-07-10","Ewelina",107,"Bellen"]
["2010-06-01","Mitchell",123,"Sunshine"]
["2010-05-15","Shari",137,"Carlota"]
["2010-04-14","Jason",199,"Sunshine"]
["2010-06-20","Yla-Katrina",152,"Carlota"]
["2010-05-06","Richard",112,"Bellen"]
["2010-06-21","Shari",160,"Sunshine"]
["2010-04-11","Craig",119,"Sunshine"]
["2010-07-05","Carol",115,"Sunset"]
["2010-05-01","Richard",182,"Carlota"]
["2010-06-18","Debra",200,"Sunset"]
["2010-03-31","Christina",196,"Sunset"]

{"sheet":"VLOOKUP","index":2,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ROWS(A1:A$22)&\")\"","v":"22)"},"The VLOOKUP function retrieves an item from a table and returns it to a cell or formula."]
[{"$f":"ROWS(A2:A$22)&\")\"","v":"21)"},"The VLOOKUP:\n1) Looks for a value in the leftmost column of a table\n2) And then returns a value in the same row from a column you specify\n3) By default, the table must be sorted in an ascending order"]
[{"$f":"ROWS(A3:A$22)&\")\"","v":"20)"},"The VLOOKUP function has four arguments: 1) lookup_value: This is the items that the VLOOKUP looks at before it goes over to the table and looks it up. Once the VLOOKUP goes over to the table, it looks in the leftmost column to try and fine the value 2) table_array is the table that you are looking a value up in 3) col_index_num is the number of the column that has the value you want to get and return back to the cell (the leftmost column of the table is considered 1). For this argument you can use the COLUMNS or ROWS functions to increment numbers. 4) [range-lookup] is a 0 when you are looking up an exact value (like a word) and 1 or omitted when you are looking up an approximate value (like in tax tables where you want to find the row that is equal to the lookup_value or greater than, but less than the next value in the leftmost column. "]
[{"$f":"ROWS(A4:A$22)&\")\"","v":"19)"},"To add Data Validation - List use Data Menu (2003) or Data Ribbon (2007). In the allow text box, select List. In the Source textbox select the range with the values you want."]
[]
["Aproximate Lookup",null,null,null,null,"Sales","Com. Rate",null,"Key to understanding how aproximate works"]
["Names","Sales","Com. Rate","$ Commission",null,0,0,null,{"$f":"F7&\" >= sales < \"&F8","v":"0 >= sales < 200"}]
["Jo",100,null,null,null,200,0.01,null,{"$f":"F8&\" >= sales < \"&F9","v":"200 >= sales < 500"}]
["Sioux",200,null,null,null,500,1.4999999999999999E-2,null,"500 >= sales < 1000"]
["Sue",2500,null,null,null,1000,0.02,null,"1000 >= sales < 5000"]
["Joe",6000,null,null,null,5000,0.05,null,{"$f":"\"sales >= \"&F11","v":"sales >= 5000"}]
["Chin",8740]
["Ron",2554]
[]
[]
["Aproximate Lookup from different Sheet",null,null,null,null,"Sales","Com. Rate",null,"Key to understanding how aproximate works"]
["Names","Sales","Com. Rate","$ Commission",null,0,0,null,{"$f":"F17&\" >= sales < \"&F18","v":"0 >= sales < 200"}]
["Jo",100,null,null,null,200,0.01,null,{"$f":"F18&\" >= sales < \"&F19","v":"200 >= sales < 500"}]
["Sioux",200,null,null,null,500,1.4999999999999999E-2,null,"500 >= sales < 1000"]
["Sue",2500,null,null,null,1000,0.02,null,"1000 >= sales < 5000"]
["Joe",6000,null,null,null,5000,0.05,null,{"$f":"\"sales >= \"&F21","v":"sales >= 5000"}]
["Chin",8740]
["Ron",2554]
[]
["Exact Lookup",null,null,null,null,"Product","Description","Price"]
[{"$f":"F25","v":"Product"},{"$f":"G25","v":"Description"},{"$f":"H25","v":"Price"},null,null,"Bellen","25 meters",25]
[null,null,null,null,null,"Carlota","20 meters",26]
[null,null,null,null,null,"Quad","15 meters",30]
[null,null,null,null,null,"Sunset","35 meters",23]
[null,"Columns"]
[]
[]
["Exact Lookup from different workbook"]
["Product","Description","Price"]
[]
[]
[]
["Data Set 1",null,null,null,null,"Data Set 2"]
["Date","SalesRep","Sales","Add New Field",null,"Date","SalesRep","Sales","Is This New Record?"]
["2010-05-21","Denise",111,null,null,"2010-05-21","Denise",111]
["2010-04-30","Thongtara",167,null,null,"2010-04-30","Thongtara",167]
["2010-04-19","Chris",191,null,null,"2010-04-19","Chris",191]
["2010-07-22","Janita",146,null,null,"2010-06-17","Ewelina",110]
["2010-05-16","Elain",177,null,null,"2010-07-22","Janita",146]
["2010-05-13","Richard",116,null,null,"2010-05-16","Elain",177]
["2010-05-14","Elain",166,null,null,"2010-06-05","Gianna",137]
["2010-06-12","Michael",193,null,null,"2010-05-13","Richard",116]
["2010-07-19","Michelle",189,null,null,"2010-05-14","Elain",166]
["2010-05-12","Jason",122,null,null,"2010-06-12","Michael",193]
[null,null,null,null,null,"2010-05-22","Ewelina",105]
[null,null,null,null,null,"2010-07-19","Michelle",189]
[null,null,null,null,null,"2010-05-12","Jason",122]
[null,null,null,null,null,"2010-06-05","Craig",196]

{"sheet":"VLOOKUP (an)","index":3,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[{"$f":"ROWS(A1:A$22)&\")\"","v":"22)"},"The VLOOKUP function retrieves an item from a table and returns it to a cell or formula."]
[{"$f":"ROWS(A2:A$22)&\")\"","v":"21)"},"The VLOOKUP:\n1) Looks for a value in the leftmost column of a table\n2) And then returns a value in the same row from a column you specify\n3) By default, the table must be sorted in an ascending order"]
[{"$f":"ROWS(A3:A$22)&\")\"","v":"20)"},"The VLOOKUP function has four arguments: 1) lookup_value: This is the items that the VLOOKUP looks at before it goes over to the table and looks it up. Once the VLOOKUP goes over to the table, it looks in the leftmost column to try and fine the value 2) table_array is the table that you are looking a value up in 3) col_index_num is the number of the column that has the value you want to get and return back to the cell (the leftmost column of the table is considered 1). For this argument you can use the COLUMNS or ROWS functions to increment numbers. 4) [range-lookup] is a 0 when you are looking up an exact value (like a word) and 1 or omitted when you are looking up an approximate value (like in tax tables where you want to find the row that is equal to the lookup_value or greater than, but less than the next value in the leftmost column. "]
[{"$f":"ROWS(A4:A$22)&\")\"","v":"19)"},"To add Data Validation - List use Data Menu (2003) or Data Ribbon (2007). In the allow text box, select List. In the Source textbox select the range with the values you want."]
[]
["Aproximate Lookup",null,null,null,null,null,"Sales","Com. Rate",null,"Key to understanding how aproximate works"]
["Names","Sales","Com. Rate","$ Commission",null,null,0,0,null,{"$f":"G7&\" >= sales < \"&G8","v":"0 >= sales < 200"}]
["Jo",100,{"$f":"VLOOKUP(B8,$G$7:$H$11,2)","v":0},{"$f":"C8*B8","v":0},null,null,200,0.01,null,{"$f":"G8&\" >= sales < \"&G9","v":"200 >= sales < 500"}]
["Sioux",200,0.01,2,null,null,500,1.4999999999999999E-2,null,"500 >= sales < 1000"]
["Sue",2500,0.02,50,null,null,1000,0.02,null,"1000 >= sales < 5000"]
["Joe",6000,0.05,300,null,null,5000,0.05,null,{"$f":"\"sales >= \"&G11","v":"sales >= 5000"}]
["Chin",8740,0.05,437]
["Ron",2554,0.02,51.08]
[]
[]
["Aproximate Lookup from different Sheet",null,null,null,null,null,"Sales","Com. Rate"]
["Names","Sales","Com. Rate","$ Commission",null,null,0,0]
["Jo",100,{"$f":"VLOOKUP(B18,Tables!$A$2:$B$6,2)","v":0},{"$f":"C18*B18","v":0},null,null,200,0.01]
["Sioux",200,{"$f":"VLOOKUP(B19,Tables!$A$2:$B$6,2)","v":0.01},2,null,null,500,1.4999999999999999E-2]
["Sue",2500,{"$f":"VLOOKUP(B20,Tables!$A$2:$B$6,2)","v":0.02},50,null,null,1000,0.02]
["Joe",6000,{"$f":"VLOOKUP(B21,Tables!$A$2:$B$6,2)","v":0.05},300,null,null,5000,0.05]
["Chin",8740,{"$f":"VLOOKUP(B22,Tables!$A$2:$B$6,2)","v":0.05},437]
["Ron",2554,{"$f":"VLOOKUP(B23,Tables!$A$2:$B$6,2)","v":0.02},51.08]
[]
["Exact Lookup",null,null,null,null,null,"Product","Description","Price"]
[{"$f":"G25","v":"Product"},{"$f":"H25","v":"Description"},"Price",null,null,null,"Bellen","25 meters",25]
["Carlota",{"$f":"VLOOKUP($A27,$G$26:$I$29,2,0)","v":"20 meters"},{"$f":"VLOOKUP($A27,$G$26:$I$29,3,0)","v":26},null,null,null,"Carlota","20 meters",26]
[null,null,null,null,null,null,"Quad","15 meters",30]
[null,null,null,null,null,null,"Sunset","35 meters",23]
[null,"Columns"]
[null,{"$f":"VLOOKUP($A27,$G$26:$I$29,COLUMNS($B31:B31)+1,0)","v":"20 meters"},{"$f":"VLOOKUP($A27,$G$26:$I$29,COLUMNS($B31:C31)+1,0)","v":26}]
[]
["Exact Lookup from different workbook"]
["Product","Description","Price"]
["Carlota",{"$f":"VLOOKUP($A35,$G$26:$I$29,2,0)","v":"20 meters"},{"$f":"VLOOKUP($A35,$G$26:$I$29,3,0)","v":26}]
[]
[]
["Data Set 1",null,null,null,null,null,"Data Set 2"]
["Date","SalesRep","Sales","Add New Field",null,null,"Date","SalesRep","Sales","Is This New Record?",null,"Is This New Record?"]
["2010-05-21","Denise",111,{"$f":"A40&B40&C40","v":"40319Denise111"},null,null,"2010-05-21","Denise",111,{"$f":"VLOOKUP(G40&H40&I40,$D$40:$D$49,1,0)","v":"40319Denise111"},null,{"$f":"ISNA(VLOOKUP(G40&H40&I40,$D$40:$D$49,1,0))","v":false}]
["2010-04-30","Thongtara",167,{"$f":"A41&B41&C41","v":"40298Thongtara167"},null,null,"2010-04-30","Thongtara",167,"40298Thongtara167",null,{"$f":"ISNA(VLOOKUP(G41&H41&I41,$D$40:$D$49,1,0))","v":false}]
["2010-04-19","Chris",191,"40287Chris191",null,null,"2010-04-19","Chris",191,"40287Chris191",null,false]
["2010-07-22","Janita",146,"40381Janita146",null,null,"2010-06-17","Ewelina",110,{"$error":"#N/A"},null,true]
["2010-05-16","Elain",177,"40314Elain177",null,null,"2010-07-22","Janita",146,"40381Janita146",null,false]
["2010-05-13","Richard",116,"40311Richard116",null,null,"2010-05-16","Elain",177,"40314Elain177",null,false]
["2010-05-14","Elain",166,"40312Elain166",null,null,"2010-06-05","Gianna",137,{"$error":"#N/A"},null,true]
["2010-06-12","Michael",193,"40341Michael193",null,null,"2010-05-13","Richard",116,"40311Richard116",null,false]
["2010-07-19","Michelle",189,"40378Michelle189",null,null,"2010-05-14","Elain",166,"40312Elain166",null,false]
["2010-05-12","Jason",122,"40310Jason122",null,null,"2010-06-12","Michael",193,"40341Michael193",null,false]
[null,null,null,null,null,null,"2010-05-22","Ewelina",105,{"$error":"#N/A"},null,true]
[null,null,null,null,null,null,"2010-07-19","Michelle",189,"40378Michelle189",null,false]
[null,null,null,null,null,null,"2010-05-12","Jason",122,"40310Jason122",null,false]
[null,null,null,null,null,null,"2010-06-05","Craig",196,{"$error":"#N/A"},null,true]

{"sheet":"Tables","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Sales","Com. Rate"]
[0,0]
[200,0.01]
[500,1.4999999999999999E-2]
[1000,0.02]
[5000,0.05]

{"sheet":"Totals","index":5,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"Pro 1","Pro 2","Pro 3","Pro 4"]
["Week 1"]
["Week 2"]
["Week 3"]
["Week 4"]

{"sheet":"Totals (an)","index":6,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[null,"Pro 1","Pro 2","Pro 3","Pro 4"]
["Week 1",{"$f":"SUM('Store(1):Store(4)'!B2)","v":1502},{"$f":"SUM('Store(1):Store(4)'!C2)","v":1855},{"$f":"SUM('Store(1):Store(4)'!D2)","v":1400},{"$f":"SUM('Store(1):Store(4)'!E2)","v":1741}]
["Week 2",{"$f":"SUM('Store(1):Store(4)'!B3)","v":2368},{"$f":"SUM('Store(1):Store(4)'!C3)","v":2202},{"$f":"SUM('Store(1):Store(4)'!D3)","v":2416},{"$f":"SUM('Store(1):Store(4)'!E3)","v":2456}]
["Week 3",{"$f":"SUM('Store(1):Store(4)'!B4)","v":1166},{"$f":"SUM('Store(1):Store(4)'!C4)","v":2244},{"$f":"SUM('Store(1):Store(4)'!D4)","v":1418},{"$f":"SUM('Store(1):Store(4)'!E4)","v":1346}]
["Week 4",{"$f":"SUM('Store(1):Store(4)'!B5)","v":2856},{"$f":"SUM('Store(1):Store(4)'!C5)","v":1473},{"$f":"SUM('Store(1):Store(4)'!D5)","v":1881},{"$f":"SUM('Store(1):Store(4)'!E5)","v":2382}]

{"sheet":"Store(1)","index":7,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"Pro 1","Pro 2","Pro 3","Pro 4"]
["Week 1",253,185,155,468]
["Week 2",540,344,360,688]
["Week 3",185,497,351,464]
["Week 4",703,234,334,382]

{"sheet":"Store(2)","index":8,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"Pro 1","Pro 2","Pro 3","Pro 4"]
["Week 1",267,774,126,259]
["Week 2",344,320,634,479]
["Week 3",167,826,804,409]
["Week 4",467,826,722,470]

{"sheet":"Store(3)","index":9,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"Pro 1","Pro 2","Pro 3","Pro 4"]
["Week 1",681,483,852,253]
["Week 2",842,857,835,624]
["Week 3",595,394,160,212]
["Week 4",793,251,720,819]

{"sheet":"Store(4)","index":10,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"Pro 1","Pro 2","Pro 3","Pro 4"]
["Week 1",301,413,267,761]
["Week 2",642,681,587,665]
["Week 3",219,527,103,261]
["Week 4",893,162,105,711]

{"sheet":"Logical IS IF","index":11,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["List of what can go in a cell",null,null,"Comparative Operator","Comparative Operator"]
["TEXT","rad",null,"=","Equal"]
["NUMBER",4.2300000000000004,null,"<>","Not Equal"]
[true,true,null,">","Great Than"]
[false,false,null,">=","Greater Than Or Equal To"]
["Error from formula",{"$f":"B3/0","v":{"$error":"#DIV/0!"}},null,"<","Less Than"]
[null,null,null,"<=","Less Than Or Equal To"]
[]
["Logical Formulas (Logical Tests) evaluate to TRUE or FALSE"]
["Sales","Hurdle To Get Bonus","Did You Get it?"]
[500,500,null,">"]
[500,500,null,">="]
[]
["Credit Analysis where all tests must be true (AND)",null,null,null,null,"Assumptions"]
["Customer","Sales Last Year","Asset Value","AND = all logical tests = TRUE",null,"Sales Last Year","Asset Value"]
["Your Name",690000,900000,null,null,500000,1000000]
[]
["Credit Analysis where 1 or more (at least) 1 tests must be true (OR)",null,null,null,null,"Assumptions"]
["Customer","Sales Last Year","Asset Value","OR = Only 1 test must be true = TRUE",null,"Sales Last Year","Asset Value"]
["Your Name",690000,900000,null,null,500000,1000000]
[]
[]
["IF function can put one of two things in a cell. The IF function has three parts:\n1) Logical Test\n2) Value If True\n3) Value If False.\nFor the 'Value If True' and 'Value If False', you can put numbers, text (must be in doulbe quotes), formulas, or cell ranges"]
[]
["Sales","Hurdle To Get Bonus","Did You Get it?"]
[500,500,null,">"]
[500,500,null,">="]
[]
["Date","Cash In","Cash Out","Balance"]
["Bal For",null,null,5000]
["2010-04-03",500]
["2010-04-04",null,620]
["2010-04-05",null,1000]
[]
[]
[]
[]
[]
["ISTEXT function","rad",{"$f":"ISTEXT(B39)","v":true},{"$f":"ISTEXT(B39)","v":true},"Value refers to text."]
["ISTEXT function",23,{"$f":"ISTEXT(B40)","v":false},{"$f":"ISTEXT(B40)","v":false}]
["ISNUMBER function",12,{"$f":"ISNUMBER(B41)","v":true},{"$f":"ISNUMBER(B41)","v":true},"Value refers to a number."]
["ISNUMBER function","Rad",{"$f":"ISNUMBER(B42)","v":false},{"$f":"ISNUMBER(B42)","v":false}]
["ISLOGICAL function",true,{"$f":"ISLOGICAL(B43)","v":true},{"$f":"ISLOGICAL(B43)","v":true},"Value refers to a logical value."]
["ISBLANK function",null,{"$f":"ISBLANK(B44)","v":true},{"$f":"ISBLANK(B44)","v":true},"Value refers to an empty cell."]
["ISERROR function",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ISERROR(B45)","v":true},{"$f":"ISERROR(B45)","v":true},"Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!)."]
["ISERR function",{"$error":"#N/A"},{"$f":"ISERR(B46)","v":false},{"$f":"ISERR(B46)","v":false},"Value refers to any error value except #N/A."]
["ISNA function",{"$error":"#N/A"},{"$f":"ISNA(B47)","v":true},{"$f":"ISNA(B47)","v":true},"Value refers to the #N/A (value not available) error value."]
["ISNONTEXT function","Excel",{"$f":"ISNONTEXT(B48)","v":false},{"$f":"ISNONTEXT(B48)","v":false},"Value refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank cell.)"]
[]
["Go Back and Fix VLOOKUP function with ISNA function"]

{"sheet":"Logical IS IF (an)","index":12,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["List of what can go in a cell",null,null,"Comparative Operator","Comparative Operator"]
["TEXT","rad",null,"=","Equal"]
["NUMBER",4.2300000000000004,null,"<>","Not Equal"]
[true,true,null,">","Great Than"]
[false,false,null,">=","Greater Than Or Equal To"]
["Error from formula",{"$f":"B3/0","v":{"$error":"#DIV/0!"}},null,"<","Less Than"]
[null,null,null,"<=","Less Than Or Equal To"]
[]
["Logical Formulas (Logical Tests) evaluate to TRUE or FALSE"]
["Sales","Hurdle To Get Bonus","Did You Get it?"]
[500,500,{"$f":"A11>B11","v":false},">"]
[500,500,{"$f":"A12>=B12","v":true},">="]
[]
["Credit Analysis where all tests must be true (AND)",null,null,null,null,"Assumptions"]
["Customer","Sales Last Year","Asset Value","AND = all logical tests = TRUE",null,"Sales Last Year","Asset Value"]
["Your Name",690000,900000,{"$f":"AND(B16>=F16,C16>=G16)","v":false},null,500000,1000000]
[]
["Credit Analysis where 1 or more (at least) 1 tests must be true (OR)",null,null,null,null,"Assumptions"]
["Customer","Sales Last Year","Asset Value","OR = Only 1 test must be true = TRUE",null,"Sales Last Year","Asset Value"]
["Your Name",690000,900000,{"$f":"OR(B20>=F20,C20>=G20)","v":true},null,500000,1000000]
[]
[]
["IF function can put one of two things in a cell. The IF function has three parts:\n1) Logical Test\n2) Value If True\n3) Value If False.\nFor the 'Value If True' and 'Value If False', you can put numbers, text (must be in doulbe quotes), formulas, or cell ranges"]
[]
["Sales","Hurdle To Get Bonus","Did You Get it?"]
[500,500,{"$f":"IF(A26>B26,\"Get Bonus\",\"No Bonus\")","v":"No Bonus"},">"]
[500,500,{"$f":"IF(A27>=B27,\"Get Bonus\",\"No Bonus\")","v":"Get Bonus"},">="]
[]
["Date","Cash In","Cash Out","Balance"]
["Bal For",null,null,5000]
["2010-04-03",500,null,{"$f":"IF(A31=\"\",\"\",B31-C31+D30)","v":5500}]
["2010-04-04",null,620,4880]
["2010-04-05",null,1000,3880]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[]
["ISTEXT function","rad",{"$f":"ISTEXT(B39)","v":true},{"$f":"ISTEXT(B39)","v":true},"Value refers to text."]
["ISTEXT function",23,{"$f":"ISTEXT(B40)","v":false},{"$f":"ISTEXT(B40)","v":false}]
["ISNUMBER function",12,{"$f":"ISNUMBER(B41)","v":true},{"$f":"ISNUMBER(B41)","v":true},"Value refers to a number."]
["ISNUMBER function","Rad",{"$f":"ISNUMBER(B42)","v":false},{"$f":"ISNUMBER(B42)","v":false}]
["ISLOGICAL function",true,{"$f":"ISLOGICAL(B43)","v":true},{"$f":"ISLOGICAL(B43)","v":true},"Value refers to a logical value."]
["ISBLANK function",null,{"$f":"ISBLANK(B44)","v":true},{"$f":"ISBLANK(B44)","v":true},"Value refers to an empty cell."]
["ISERROR function",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ISERROR(B45)","v":true},{"$f":"ISERROR(B45)","v":true},"Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!)."]
["ISERR function",{"$error":"#N/A"},{"$f":"ISERR(B46)","v":false},{"$f":"ISERR(B46)","v":false},"Value refers to any error value except #N/A."]
["ISNA function",{"$error":"#N/A"},{"$f":"ISNA(B47)","v":true},{"$f":"ISNA(B47)","v":true},"Value refers to the #N/A (value not available) error value."]
["ISNONTEXT function","Excel",{"$f":"ISNONTEXT(B48)","v":false},{"$f":"ISNONTEXT(B48)","v":false},"Value refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank cell.)"]
[]
["Go Back and Fix VLOOKUP function with ISNA function"]

{"sheet":"Dates","index":13,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Hire Date","2010-04-02"]
["Years Until Vest",3]
["Vest Date",null,null,"EDATE"]
[]
["Reporting Period","2010-04-01"]
["End of Month",null,null,"EOMONTH"]

{"sheet":"Text Functions","index":14,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"removes all spaces except 1 between each word","Cap for each 1st letter","finds the position of \"sub-text\" with in text. Example =SEARCH(\"e\",\"len\") = 2 -- because e is 2nd letter","takes a certain # of characters form the left","Replaces text when you tell it position to start at and how far to go."]
["Names","TRIM","PROPER","SEARCH","LEFT","REPLACE"]
["ELAIN JANIS   "]
["GRAF CAROL "]
["LINDSEY GIANNA "]
["MIKLOVICH JASON "]
["MILLER MICHELLE "]
["SHOMIN SHARI    "]
["   SNYDER DENISE "]
["BELL DANIEL "]
["BURCKHARD SARAH "]
["CARLSON CHRISTINA  "]
["   DIXON   JANITA   "]
["    EADS DEBRA "]
["GAYLON NELIA  "]
["GILL MANAVBIR "]
["  HERR    RICHARD    "]
["JEROME YLA-KATRINA "]
["KAUR NAVDEEP"]
["MANSA AMMIEL"]
["MITCHELL JENNIFER"]
["OLLOM CRAIG D"]
["SYKES CHRIS"]
["SZARKOWICZ   EWELINA  "]
["TERRY MICHAEL   "]
["THONGTARA HANAPHAN"]

{"sheet":"Text Functions (an)","index":15,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[null,"removes all spaces except 1 between each word","Cap for each 1st letter","finds the position of \"sub-text\" with in text. Example =SEARCH(\"e\",\"len\") = 2 -- because e is 2nd letter","takes a certain # of characters form the left","Replaces text when you tell it position to start at and how far to go."]
["Names","TRIM","PROPER","SEARCH","LEFT","REPLACE"]
["ELAIN JANIS   ",{"$f":"TRIM(A4)","v":"ELAIN JANIS"},{"$f":"PROPER(B4)","v":"Elain Janis"},{"$f":"SEARCH(\" \",C4)","v":6},{"$f":"LEFT(C4,D4-1)","v":"Elain"},{"$f":"PROPER(TRIM(REPLACE(A4,1,SEARCH(\" \",A4),\"\")))","v":"Janis"}]
["GRAF CAROL ",{"$f":"TRIM(A5)","v":"GRAF CAROL"},{"$f":"PROPER(B5)","v":"Graf Carol"},{"$f":"SEARCH(\" \",C5)","v":5},{"$f":"LEFT(C5,D5-1)","v":"Graf"},"Carol"]
["LINDSEY GIANNA ","LINDSEY GIANNA","Lindsey Gianna",8,"Lindsey","Gianna"]
["MIKLOVICH JASON ","MIKLOVICH JASON","Miklovich Jason",10,"Miklovich","Jason"]
["MILLER MICHELLE ","MILLER MICHELLE","Miller Michelle",7,"Miller","Michelle"]
["SHOMIN SHARI    ","SHOMIN SHARI","Shomin Shari",7,"Shomin","Shari"]
["   SNYDER DENISE ","SNYDER DENISE","Snyder Denise",7,"Snyder","Snyder Denise"]
["BELL DANIEL ","BELL DANIEL","Bell Daniel",5,"Bell","Daniel"]
["BURCKHARD SARAH ","BURCKHARD SARAH","Burckhard Sarah",10,"Burckhard","Sarah"]
["CARLSON CHRISTINA  ","CARLSON CHRISTINA","Carlson Christina",8,"Carlson","Christina"]
["   DIXON   JANITA   ","DIXON JANITA","Dixon Janita",6,"Dixon","Dixon Janita"]
["    EADS DEBRA ","EADS DEBRA","Eads Debra",5,"Eads","Eads Debra"]
["GAYLON NELIA  ","GAYLON NELIA","Gaylon Nelia",7,"Gaylon","Nelia"]
["GILL MANAVBIR ","GILL MANAVBIR","Gill Manavbir",5,"Gill","Manavbir"]
["  HERR    RICHARD    ","HERR RICHARD","Herr Richard",5,"Herr","Herr Richard"]
["JEROME YLA-KATRINA ","JEROME YLA-KATRINA","Jerome Yla-Katrina",7,"Jerome","Yla-Katrina"]
["KAUR NAVDEEP","KAUR NAVDEEP","Kaur Navdeep",5,"Kaur","Navdeep"]
["MANSA AMMIEL","MANSA AMMIEL","Mansa Ammiel",6,"Mansa","Ammiel"]
["MITCHELL JENNIFER","MITCHELL JENNIFER","Mitchell Jennifer",9,"Mitchell","Jennifer"]
["OLLOM CRAIG D","OLLOM CRAIG D","Ollom Craig D",6,"Ollom","Craig D"]
["SYKES CHRIS","SYKES CHRIS","Sykes Chris",6,"Sykes","Chris"]
["SZARKOWICZ   EWELINA  ","SZARKOWICZ EWELINA","Szarkowicz Ewelina",11,"Szarkowicz","Ewelina"]
["TERRY MICHAEL   ","TERRY MICHAEL","Terry Michael",6,"Terry","Michael"]
["THONGTARA HANAPHAN","THONGTARA HANAPHAN","Thongtara Hanaphan",10,"Thongtara","Hanaphan"]

{"sheet":"Fun","index":16,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Product ID","Sales","Where is this stroed?",null,null,null,null,"Prefix","Room"]
["GRI-6928-810",876,null,null,null,null,null,"RAD","Front Storage"]
["COO-2223-495",1060,null,null,null,null,null,"COO","Back Lot"]
["GRI-6793-103",823,null,null,null,null,null,"BEE","Store"]
["BEE-8735-517",380,null,null,null,null,null,"GRI","Basement"]
["COO-8361-668",320]
["RAD-5885-953",690]
["GRI-1534-283",953]
["RAD-5020-306",879]
["BEE-2593-392",894]
["COO-7089-755",670]
["BEE-2991-247",679]
["RAD-6297-147",747]
["RAD-2881-515",598]
["GRI-6532-660",991]
["COO-2992-205",916]
["BEE-6094-196",698]
["COO-3048-808",268]
["BEE-8740-307",1087]
["BEE-6826-784",1034]
["GRI-2308-876",1169]
["GRI-1131-267",720]
["RAD-4940-226",798]
["RAD-6397-478",304]
["BEE-4616-346",1153]
["RAD-3460-236",1092]
["BEE-7348-321",441]
["BEE-5470-858",736]
["GRI-8071-237",768]
["COO-5098-393",841]
["RAD-4035-400",380]
["COO-6688-531",826]
["BEE-9205-668",246]
["COO-1052-326",758]
["COO-9221-984",1033]
["GRI-9107-444",203]
["RAD-6427-855",295]
["RAD-1503-728",929]
["BEE-9210-135",551]
["RAD-7053-928",1063]
["RAD-2487-304",783]
["GRI-8476-454",734]
["BEE-3717-318",1088]
["COO-5841-955",201]
["RAD-2400-710",790]
["BEE-6928-105",801]
["RAD-5292-347",592]
["BEE-7862-136",403]
["RAD-9372-569",681]
["COO-7441-331",702]
["COO-8915-170",466]
["GRI-5049-152",303]
["GRI-5950-467",793]

{"sheet":"Fun (an)","index":17,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["Product ID","Sales","Where is this stroed?",null,null,null,null,"Prefix","Room"]
["GRI-6928-810",876,{"$f":"VLOOKUP(LEFT(A2,3),$H$2:$I$5,2,0)","v":"Basement"},null,null,null,null,"RAD","Front Storage"]
["COO-2223-495",1060,{"$f":"VLOOKUP(LEFT(A3,3),$H$2:$I$5,2,0)","v":"Back Lot"},null,null,null,null,"COO","Back Lot"]
["GRI-6793-103",823,"Basement",null,null,null,null,"BEE","Store"]
["BEE-8735-517",380,"Store",null,null,null,null,"GRI","Basement"]
["COO-8361-668",320,"Back Lot"]
["RAD-5885-953",690,"Front Storage"]
["GRI-1534-283",953,"Basement"]
["RAD-5020-306",879,"Front Storage"]
["BEE-2593-392",894,"Store"]
["COO-7089-755",670,"Back Lot"]
["BEE-2991-247",679,"Store"]
["RAD-6297-147",747,"Front Storage"]
["RAD-2881-515",598,"Front Storage"]
["GRI-6532-660",991,"Basement"]
["COO-2992-205",916,"Back Lot"]
["BEE-6094-196",698,"Store"]
["COO-3048-808",268,"Back Lot"]
["BEE-8740-307",1087,"Store"]
["BEE-6826-784",1034,"Store"]
["GRI-2308-876",1169,"Basement"]
["GRI-1131-267",720,"Basement"]
["RAD-4940-226",798,"Front Storage"]
["RAD-6397-478",304,"Front Storage"]
["BEE-4616-346",1153,"Store"]
["RAD-3460-236",1092,"Front Storage"]
["BEE-7348-321",441,"Store"]
["BEE-5470-858",736,"Store"]
["GRI-8071-237",768,"Basement"]
["COO-5098-393",841,"Back Lot"]
["RAD-4035-400",380,"Front Storage"]
["COO-6688-531",826,"Back Lot"]
["BEE-9205-668",246,"Store"]
["COO-1052-326",758,"Back Lot"]
["COO-9221-984",1033,"Back Lot"]
["GRI-9107-444",203,"Basement"]
["RAD-6427-855",295,"Front Storage"]
["RAD-1503-728",929,"Front Storage"]
["BEE-9210-135",551,"Store"]
["RAD-7053-928",1063,"Front Storage"]
["RAD-2487-304",783,"Front Storage"]
["GRI-8476-454",734,"Basement"]
["BEE-3717-318",1088,"Store"]
["COO-5841-955",201,"Back Lot"]
["RAD-2400-710",790,"Front Storage"]
["BEE-6928-105",801,"Store"]
["RAD-5292-347",592,"Front Storage"]
["BEE-7862-136",403,"Store"]
["RAD-9372-569",681,"Front Storage"]
["COO-7441-331",702,"Back Lot"]
["COO-8915-170",466,"Back Lot"]
["GRI-5049-152",303,"Basement"]
["GRI-5950-467",793,"Basement"]