{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["IntoToExcel","Keyboard Shortcuts","1 Calculate","2 Data Analysis(1)","2 Data Analysis(2)","3 Charts","Cell References","Formatting","Percentage Calculations","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"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":"IntoToExcel","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"LEFT(ADDRESS(ROW(B1),COLUMN(B1),4),1)&\" Column\"","v":"B Column"}]
[{"$f":"MID(ADDRESS(ROW(A2),COLUMN(A2),4),2,1)&\" Row\"","v":"2 Row"},{"$f":"ADDRESS(ROW(B2),COLUMN(B2),4)&\" Cell\"","v":"B2 Cell"},{"$f":"MID(ADDRESS(ROW(A2),COLUMN(A2),4),2,1)&\" Row\"","v":"2 Row"},"2 Row","2 Row","2 Row","2 Row","2 Row"]
[null,{"$f":"LEFT(ADDRESS(ROW(B3),COLUMN(B3),4),1)&\" Column\"","v":"B Column"}]
[null,"B Column"]
[null,"B Column"]
[null,"B Column"]
[null,"B Column"]
[null,"B Column"]
[null,"B Column"]
[null,"B Column"]
[]
[]
[]
[]
[null,"Install Data Analysis Add-in!!!!!"]

{"sheet":"Keyboard Shortcuts","index":1,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["Key","Alone","Shift","Ctrl","Alt","Shift Ctrl"]
["F1","Help","What's This Help",null,"Insert Chart Sheet"]
["F2","Edit Mode","Edit Comment",null,"Save As"]
["F3","Paste Name Formula","Paste Function","Define Name",null,"Names From Labels"]
["F4","Repeat Action","Find Again","Close Window","Quit Excel"]
["F5","Goto","Find","Restore Window Size"]
["F6","Next Pane","Prev Pane","Next Workbook","Switch To VBA","Prev Workbook"]
["F7","Spell Check",null,"Move Window"]
["F8","Extend Selection","Add To Selection","Resize Window","Macro List"]
["F9","Calculate All","Calculate Worksheet","Minimize Workbook"]
["F10","Activate Menu","Context Menu","Restore Workbook"]
["F11","New Chart","New Worksheet","New Macro Sheet","VB Editor"]
["F12","Save As","Save","Open",null,"Print"]
["A",null,null,"Select All ",null,"Formula Arguments"]
["B",null,null,"Bold"]
["C",null,null,"Copy"]
["D",null,null,"Fill Down","Data Menu"]
["E",null,null,null,"Edit Menu"]
["F",null,null,"Find","File Menu","Font Name"]
["G",null,null,"Goto"]
["H",null,null,"Replace","Help Menu"]
["I",null,null,"Italics","Insert Menu"]
["J"]
["K",null,null,"Insert  Hyperlink"]
["L"]
["M"]
["N",null,null,"New Workbook"]
["O",null,null,"Open Workbook","Format Menu","Select Comments"]
["P",null,null,"Print",null,"Font Size"]
["Q"]
["R",null,null,"Fill Right"]
["S",null,null,"Save"]
["T",null,null,null,"Tools Menu"]
["U",null,null,"Underline"]
["V",null,null,"Paste"]
["W",null,null,"Close Workbook","Window Menu"]
["X",null,null,"Cut"]
["Y",null,null,"Repeat Active"]
["Z",null,null,"Undo"]
["` (~)",null,null,"Toggle Formula View",null,"General Format"]
["1 (!)",null,null,"Cell Format",null,"Number Format"]
["2 (@)",null,null,"Toggle Bold",null,"Time Format"]
["3 (#)",null,null,"Toggle Italics",null,"Date Format"]
["4 ($)",null,null,"Toggle Underline",null,"Currency Format"]
["5 (%)",null,null,"Toggle Strikethru",null,"Percent Format"]
["6 (^)",null,null,"a",null,"Exponent Format"]
["7 (&)",null,null,"a",null,"Apply Border"]
["8 (*)",null,null,"Outline",null,"Select Region"]
["9 (()",null,null,"Hide Rows",null,"Unhide Rows"]
["0 ())",null,null,"Hide Columns",null,"Unhide Columns"]
["-",null,null,"Delete Selection","Control Menu","No Border"]
["= (+)","Formula",null,null,"Auto Sum","Insert dialog"]
["[",null,null,"Direct Dependents",null,"Direct Precedents"]
["]",null,null,"All Dependents",null,"All Precedents"]
["; (semicolon)",null,null,"Insert Date","Select Visible Cells","Insert Time"]
["' (apostrophe)",null,null,null,"Style","Copy Cell Value Above"]
[": (colon)",null,null,"Insert Time"]
["/",null,null,"Select Array",null,"Select Array"]
["\\",null,null,"Select Differences",null,"Select Unequal Cells"]
["Insert","Insert Mode",null,"Copy"]
["Delete","Clear",null,"Delete To End Of Line"]
["Home","Begin Row",null,"Start Of Worksheet"]
["End","End Row",null,"End Of Worksheet"]
["Page Up","Page Up",null,"Previous Worksheet","Left 1 screen"]
["Page Down","Page Down",null,"Next Worksheet","Right 1 screen"]
["Left Arrow","Move Left","Select Left","Move Left Area"]
["Right Arrow","Move Right","Select Right","Move Right Area"]
["Up Arrow","Move Up","Select Up","Move Up Area"]
["Down Arrow","Move Down","Select Down","Move Down Area","Drop down list"]
["Space Bar","Space","Select Row","Select Column","Control Box","Select All"]
["Tab","Move Right","Move Left","Next Window","Next Application","Previous Window"]
["BackSpace",null,null,"Goto Active Cell"]

{"sheet":"1 Calculate","index":2,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["You already know the order of operations (left to right): Parenthesis, Exponents, Multiply/Divide, Add/Subtract"]
["You must learn Excel's Operation Symbols"]
["Parenthesis"," ( )","Shift + 9 and Shift + 0"]
["Exponents"," ^","Shift + 6"]
["Multiply"," *","Number pad"]
["Divide"," /","Number pad"]
["Add"," +","Number pad"]
["Subtract"," -","Number pad"]
["Join"," &","Shift + 7"]
["Equal"," =","Left of Backspace"]
["Greater than"," >","Shift + ."]
["Greater than or equal to"," >=","2 characters next to each other"]
["Less than"," <","Shift + ,"]
["Less than or equal to"," <=","2 characters next to each other"]
["Not"," <>","2 characters next to each other"]
[]
["When you make calculations, you can use Formulas"]
["Formulas Start with the Equal Sign"]
[]
["Formula for arithmetic",null,"Formula that uses Function"]
["X",null,"Scores"]
[14,null,100]
["Average",null,69]
[10.5,null,43]
["(X-Average)^2",null,95]
[null,null,88]
[null,null,"SUM"]
[null,null,"Mean = SUM/COUNT ="]
["Text Formula",null,"Mean = Average ="]
[]
[null,null,"TRUE/FALSE formula"]

{"sheet":"2 Data Analysis(1)","index":3,"n_rows":594,"n_cols":6,"rows_kept":594,"cut":false,"hidden":false,"merged":[]}
["Sorting can be done with the A to Z or Z to A buttons on the Data Ribbon: BE SURE TO ONLY HAVE ONE CELL SELECTED IN THE COLUMNS THAT YOU WANT TO SORT UPON."]
["PivotTables are one of the  most powerful features In Excel. They can summarize data with multiple criteria. The key to Pivot Tables is to understand Columns and Rows."]
[]
["Date","Sales Rep","Customer","Sales","COGS","Region"]
["2008-02-12","Joy","Fred Myer",132,80.52,"MidWest"]
["2006-07-25","Joy","Fred Myer",88,61.6,"NorthWest"]
["2006-01-13","Tom","Safeway",70,51.8,"NorthWest"]
["2008-06-02","Joy","Safeway",119,61.88,"East"]
["2007-06-10","Chin","Whole Foods",519,285.45,"NorthWest"]
["2007-07-17","Tina","Whole Foods",58,24.36,"West"]
["2008-04-10","Tom","Safeway",184,77.28,"MidWest"]
["2006-04-26","Chin","Coop",1960,1509.2,"NorthWest"]
["2006-08-25","Joy","Whole Foods",249,129.47999999999999,"NorthWest"]
["2006-11-06","Joy","Coop",188,112.8,"NorthWest"]
["2007-12-20","Sioux","Fred Myer",69,36.57,"NorthWest"]
["2007-07-11","Sioux","Whole Foods",244,173.24,"East"]
["2005-06-19","Tina","Fred Myer",174,113.1,"MidWest"]
["2005-07-25","Tina","Fred Myer",161,98.21,"West"]
["2007-04-13","Chin","Coop",100,43,"NorthEast"]
["2006-08-11","Tina","Fred Myer",235,157.44999999999999,"East"]
["2006-02-06","Tom","Fred Myer",185,146.15,"East"]
["2005-06-16","Sioux","Safeway",1656,1275.1199999999999,"MidWest"]
["2005-12-08","Sioux","PCC",214,162.63999999999999,"NorthWest"]
["2007-05-06","Sioux","Coop",192,138.24,"MidWest"]
["2006-04-12","Tina","PCC",53,29.68,"NorthWest"]
["2006-02-28","Tina","Coop",628,263.76,"East"]
["2006-07-17","Chin","PCC",88,37.840000000000003,"East"]
["2007-12-07","Chin","PCC",75,47.25,"NorthEast"]
["2008-02-25","Joy","Fred Myer",131,96.94,"MidWest"]
["2007-01-10","Chin","Fred Myer",128,80.64,"West"]
["2007-05-12","Chin","Safeway",155,80.599999999999994,"NorthEast"]
["2008-05-06","Tom","Coop",1020,479.4,"NorthWest"]
["2006-06-26","Chin","PCC",136,108.8,"East"]
["2008-01-29","Sioux","Safeway",160,91.2,"NorthEast"]
["2007-10-23","Sioux","Coop",124,80.599999999999994,"NorthEast"]
["2007-03-31","Joy","Coop",196,148.96,"MidWest"]
["2006-05-23","Chin","Safeway",141,105.75,"MidWest"]
["2005-10-03","Chin","Fred Myer",223,115.96,"NorthWest"]
["2007-01-02","Sioux","Coop",85,61.2,"NorthWest"]
["2005-07-21","Tina","Whole Foods",248,151.28,"MidWest"]
["2007-05-14","Tom","Coop",104,61.36,"NorthWest"]
["2006-03-13","Chin","Fred Myer",1550,868,"West"]
["2007-10-17","Chin","Safeway",698,488.6,"NorthEast"]
["2007-01-14","Tom","Safeway",203,87.29,"East"]
["2008-02-10","Tom","Safeway",78,44.46,"NorthEast"]
["2006-04-20","Chin","Fred Myer",138,99.36,"NorthWest"]
["2006-05-17","Sioux","PCC",139,59.77,"NorthWest"]
["2005-08-23","Tom","Whole Foods",178,115.7,"NorthWest"]
["2006-08-18","Joy","Whole Foods",203,154.28,"NorthEast"]
["2006-03-01","Tom","Whole Foods",90,61.2,"West"]
["2007-12-27","Sioux","Coop",131,55.02,"NorthWest"]
["2008-06-22","Joy","Safeway",1407,830.13,"East"]
["2006-03-26","Tom","Safeway",160,123.2,"NorthEast"]
["2006-04-06","Tina","PCC",55,26.95,"NorthEast"]
["2007-09-10","Tina","Whole Foods",139,88.96,"MidWest"]
["2007-01-30","Joy","Whole Foods",237,123.24,"West"]
["2006-04-24","Sioux","PCC",185,138.75,"NorthEast"]
["2006-05-15","Tom","Whole Foods",222,170.94,"West"]
["2008-03-02","Chin","Safeway",77,31.57,"NorthWest"]
["2007-02-20","Joy","Fred Myer",750,502.5,"NorthWest"]
["2007-05-29","Sioux","Whole Foods",149,119.2,"East"]
["2006-04-11","Tom","Fred Myer",1779,1298.67,"East"]
["2005-10-12","Sioux","Safeway",52,38.479999999999997,"NorthWest"]
["2007-11-05","Tom","Safeway",155,120.9,"NorthWest"]
["2006-09-15","Joy","PCC",160,124.8,"West"]
["2006-04-30","Chin","Safeway",217,171.43,"NorthEast"]
["2008-04-23","Chin","Safeway",219,146.72999999999999,"East"]
["2007-10-15","Tom","Coop",68,31.28,"West"]
["2007-12-03","Joy","Coop",139,65.33,"NorthEast"]
["2006-04-02","Tom","Fred Myer",150,88.5,"East"]
["2007-01-17","Chin","Safeway",88,37.840000000000003,"MidWest"]
["2007-12-03","Tom","Coop",1336,868.4,"NorthEast"]
["2007-04-17","Chin","Safeway",163,130.4,"West"]
["2006-02-06","Tom","Coop",220,116.6,"East"]
["2005-09-19","Joy","PCC",83,60.59,"East"]
["2006-10-05","Tom","PCC",55,28.6,"MidWest"]
["2007-12-03","Joy","PCC",1028,771,"East"]
["2007-02-03","Chin","Fred Myer",63,27.09,"East"]
["2005-07-02","Tina","PCC",143,81.510000000000005,"NorthEast"]
["2008-05-21","Chin","Whole Foods",62,29.14,"NorthEast"]
["2007-07-01","Sioux","Fred Myer",55,23.1,"NorthEast"]
["2006-12-25","Chin","Whole Foods",1369,876.16,"MidWest"]
["2007-04-18","Joy","Coop",60,48,"West"]
["2007-01-08","Tom","Fred Myer",62,47.12,"NorthEast"]
["2007-12-17","Chin","Fred Myer",137,100.01,"NorthEast"]
["2007-03-01","Sioux","Fred Myer",84,59.64,"MidWest"]
["2007-08-07","Tom","Safeway",55,37.4,"NorthEast"]
["2008-02-26","Tom","Whole Foods",237,158.79,"MidWest"]
["2006-02-23","Tina","Fred Myer",127,85.09,"NorthWest"]
["2008-04-18","Tom","Fred Myer",183,78.69,"NorthEast"]
["2006-05-30","Sioux","PCC",124,79.36,"NorthEast"]
["2008-02-12","Joy","Coop",1095,558.45000000000005,"MidWest"]
["2006-02-23","Chin","Whole Foods",160,94.4,"NorthWest"]
["2008-03-20","Joy","Coop",870,609,"MidWest"]
["2006-01-07","Sioux","Coop",93,60.45,"NorthEast"]
["2008-02-17","Sioux","Safeway",193,108.08,"East"]
["2007-03-08","Tina","PCC",212,125.08,"West"]
["2007-06-19","Sioux","Fred Myer",93,68.819999999999993,"East"]
["2006-10-18","Tom","Coop",80,48.8,"East"]
["2007-11-22","Chin","Safeway",204,99.96,"NorthEast"]
["2007-05-03","Tina","Fred Myer",228,114,"NorthWest"]
["2005-11-09","Chin","Coop",1399,1077.23,"East"]
["2007-12-07","Tina","PCC",187,143.99,"East"]
["2006-10-19","Tom","Fred Myer",163,122.25,"West"]
["2008-03-30","Sioux","PCC",63,30.24,"MidWest"]
["2005-06-30","Tina","Coop",197,98.5,"East"]
["2006-10-11","Tina","Fred Myer",237,137.46,"MidWest"]
["2005-08-05","Sioux","Safeway",140,107.8,"MidWest"]
["2008-01-12","Sioux","Coop",141,83.19,"NorthWest"]
["2007-09-30","Tina","Coop",98,43.12,"MidWest"]
["2008-01-23","Tina","Fred Myer",510,280.5,"MidWest"]
["2005-10-06","Tom","Coop",1010,606,"MidWest"]
["2007-05-01","Joy","PCC",114,54.72,"East"]
["2007-06-09","Sioux","Whole Foods",220,99,"MidWest"]
["2006-03-28","Joy","PCC",92,59.8,"NorthWest"]
["2005-08-08","Tom","PCC",180,79.2,"NorthEast"]
["2006-08-17","Sioux","PCC",180,131.4,"MidWest"]
["2007-04-30","Chin","Coop",81,34.020000000000003,"NorthEast"]
["2006-01-24","Joy","PCC",178,133.5,"NorthWest"]
["2005-07-16","Sioux","Safeway",73,32.85,"East"]
["2008-07-01","Tina","Whole Foods",112,62.72,"NorthEast"]
["2007-10-30","Tom","Safeway",1607,1124.9000000000001,"NorthEast"]
["2006-03-12","Sioux","PCC",133,54.53,"East"]
["2005-10-05","Joy","Whole Foods",218,141.69999999999999,"MidWest"]
["2005-09-04","Joy","Whole Foods",190,100.7,"East"]
["2007-03-13","Chin","Whole Foods",161,78.89,"MidWest"]
["2007-06-17","Joy","PCC",69,54.51,"NorthEast"]
["2007-10-22","Joy","Safeway",961,643.87,"West"]
["2007-08-10","Tom","Safeway",236,167.56,"West"]
["2006-11-26","Tina","PCC",88,37.840000000000003,"NorthEast"]
["2006-05-23","Joy","Safeway",83,57.27,"West"]
["2006-05-11","Joy","Fred Myer",1917,996.84,"East"]
["2007-02-01","Tom","Safeway",73,48.91,"MidWest"]
["2007-03-02","Sioux","Safeway",216,157.68,"East"]
["2007-07-13","Tom","Fred Myer",113,76.84,"MidWest"]
["2006-11-29","Tom","Whole Foods",96,39.36,"MidWest"]
["2007-01-19","Joy","Fred Myer",171,104.31,"West"]
["2008-05-14","Chin","Fred Myer",177,79.650000000000006,"NorthEast"]
["2007-07-05","Tina","Fred Myer",167,93.52,"NorthEast"]
["2005-10-12","Tina","Safeway",73,56.21,"NorthWest"]
["2006-10-28","Chin","Fred Myer",152,95.76,"East"]
["2007-12-11","Tina","Coop",1658,1094.28,"MidWest"]
["2007-12-20","Tina","Whole Foods",195,103.35,"West"]
["2007-08-02","Chin","Whole Foods",66,50.82,"West"]
["2005-10-11","Tom","Whole Foods",994,795.2,"NorthWest"]
["2006-11-10","Tina","Whole Foods",192,130.56,"East"]
["2008-05-12","Sioux","Safeway",82,59.86,"MidWest"]
["2005-10-20","Joy","Fred Myer",72,33.840000000000003,"East"]
["2007-12-25","Tina","PCC",131,79.91,"MidWest"]
["2007-07-09","Chin","Whole Foods",123,63.96,"MidWest"]
["2008-05-24","Sioux","PCC",225,105.75,"NorthWest"]
["2007-12-11","Sioux","Whole Foods",1680,705.6,"West"]
["2005-08-31","Joy","Safeway",171,88.92,"MidWest"]
["2005-10-20","Sioux","Fred Myer",75,50.25,"West"]
["2005-06-19","Chin","PCC",186,87.42,"NorthEast"]
["2006-05-18","Tina","Fred Myer",54,40.5,"East"]
["2007-05-04","Sioux","Safeway",169,69.290000000000006,"NorthEast"]
["2005-11-21","Tom","Whole Foods",135,70.2,"NorthWest"]
["2006-09-20","Tom","PCC",235,108.1,"NorthEast"]
["2006-11-27","Tom","Whole Foods",122,92.72,"East"]
["2006-12-29","Joy","PCC",220,162.80000000000001,"MidWest"]
["2007-06-22","Chin","Whole Foods",594,338.58,"NorthEast"]
["2008-01-06","Tom","Fred Myer",245,120.05,"NorthEast"]
["2006-07-28","Chin","Whole Foods",125,98.75,"NorthEast"]
["2008-02-04","Joy","Fred Myer",228,180.12,"NorthEast"]
["2007-01-09","Joy","Safeway",76,57,"MidWest"]
["2007-10-23","Tina","Whole Foods",166,129.47999999999999,"MidWest"]
["2006-05-20","Sioux","Safeway",131,104.8,"NorthEast"]
["2005-11-25","Joy","Fred Myer",183,78.69,"MidWest"]
["2006-11-06","Tom","Safeway",240,100.8,"East"]
["2007-03-18","Joy","Whole Foods",109,80.66,"NorthWest"]
["2007-03-19","Sioux","Safeway",1907,1373.04,"West"]
["2006-11-19","Tom","Safeway",122,51.24,"NorthEast"]
["2006-05-06","Chin","Fred Myer",120,49.2,"West"]
["2005-11-01","Joy","PCC",145,105.85,"West"]
["2006-07-15","Sioux","PCC",148,91.76,"East"]
["2008-04-13","Joy","Whole Foods",76,32.68,"West"]
["2007-04-16","Tom","PCC",131,74.67,"MidWest"]
["2007-12-07","Chin","Coop",763,480.69,"East"]
["2005-11-16","Sioux","Fred Myer",209,154.66,"NorthWest"]
["2007-03-09","Tom","PCC",61,45.14,"NorthEast"]
["2007-06-27","Tina","Fred Myer",1947,1343.43,"East"]
["2006-03-14","Tom","Fred Myer",206,140.08000000000001,"NorthWest"]
["2005-09-02","Chin","Coop",52,35.880000000000003,"NorthEast"]
["2007-03-18","Sioux","PCC",132,76.56,"MidWest"]
["2007-11-06","Tom","Fred Myer",205,151.69999999999999,"NorthWest"]
["2007-12-08","Chin","Fred Myer",60,27.6,"MidWest"]
["2007-01-08","Chin","Whole Foods",137,79.459999999999994,"NorthEast"]
["2007-04-18","Joy","PCC",191,116.51,"East"]
["2005-09-21","Tina","Fred Myer",75,37.5,"NorthEast"]
["2008-05-16","Tom","Coop",133,94.43,"East"]
["2006-06-07","Chin","Coop",1621,1264.3800000000001,"NorthWest"]
["2005-07-28","Tom","PCC",76,53.2,"MidWest"]
["2008-01-07","Sioux","Fred Myer",96,43.2,"West"]
["2007-09-22","Tina","Coop",181,139.37,"MidWest"]
["2006-11-08","Chin","Fred Myer",1023,470.58,"NorthWest"]
["2007-09-14","Tina","Safeway",106,58.3,"East"]
["2005-12-28","Tina","Safeway",221,172.38,"East"]
["2008-03-27","Tina","Fred Myer",220,107.8,"East"]
["2007-06-08","Joy","Whole Foods",191,135.61000000000001,"West"]
["2008-02-09","Joy","Safeway",103,69.010000000000005,"MidWest"]
["2008-04-10","Joy","Coop",1596,1133.1600000000001,"East"]
["2007-05-24","Tom","Whole Foods",81,46.98,"NorthEast"]
["2007-09-05","Joy","Whole Foods",209,112.86,"West"]
["2007-04-28","Chin","PCC",104,72.8,"NorthEast"]
["2005-08-08","Tina","Fred Myer",144,67.680000000000007,"NorthWest"]
["2007-12-06","Tina","Fred Myer",118,93.22,"West"]
["2005-10-31","Tina","Whole Foods",73,34.31,"West"]
["2007-11-20","Joy","Coop",214,98.44,"East"]
["2008-02-27","Joy","Coop",240,151.19999999999999,"NorthEast"]
["2007-05-30","Tom","Whole Foods",67,40.869999999999997,"MidWest"]
["2005-12-21","Chin","Safeway",1151,563.99,"West"]
["2007-02-28","Chin","Whole Foods",751,570.76,"NorthEast"]
["2006-07-17","Tom","Fred Myer",188,82.72,"NorthEast"]
["2005-12-04","Sioux","PCC",157,73.790000000000006,"West"]
["2008-04-12","Tom","PCC",55,42.35,"NorthEast"]
["2006-02-18","Joy","PCC",194,147.44,"NorthWest"]
["2006-02-20","Sioux","Whole Foods",156,92.04,"West"]
["2007-04-06","Sioux","PCC",179,82.34,"East"]
["2006-01-01","Tina","Whole Foods",184,86.48,"East"]
["2006-05-25","Joy","PCC",128,53.76,"West"]
["2005-07-21","Tom","Coop",1436,1019.56,"West"]
["2007-05-05","Tina","Safeway",224,138.88,"NorthEast"]
["2008-06-03","Sioux","Fred Myer",220,149.6,"West"]
["2008-04-02","Tom","Whole Foods",206,96.82,"MidWest"]
["2006-01-17","Tom","Fred Myer",170,132.6,"NorthWest"]
["2006-07-23","Tom","Fred Myer",66,31.02,"West"]
["2007-06-09","Chin","Safeway",171,92.34,"NorthWest"]
["2007-12-01","Tina","Whole Foods",101,41.41,"NorthWest"]
["2007-11-26","Joy","PCC",869,521.4,"NorthEast"]
["2008-02-06","Joy","PCC",151,95.13,"NorthEast"]
["2007-10-08","Chin","PCC",1923,1519.17,"NorthWest"]
["2007-07-21","Tina","Whole Foods",211,128.71,"East"]
["2007-04-16","Tom","Safeway",159,116.07,"NorthEast"]
["2005-07-06","Chin","Safeway",82,41.82,"West"]
["2005-09-20","Sioux","Coop",70,42.7,"NorthEast"]
["2007-03-30","Joy","Whole Foods",153,122.4,"NorthEast"]
["2005-08-03","Tom","PCC",232,160.08000000000001,"West"]
["2005-10-25","Tina","Fred Myer",223,176.17,"NorthEast"]
["2005-06-23","Sioux","Whole Foods",207,138.69,"MidWest"]
["2006-10-12","Tom","PCC",234,102.96,"East"]
["2005-06-22","Chin","Whole Foods",1154,484.68,"West"]
["2005-10-16","Chin","Whole Foods",68,42.16,"West"]
["2008-04-13","Tina","Coop",56,38.08,"NorthWest"]
["2007-09-28","Joy","PCC",209,133.76,"NorthWest"]
["2006-08-11","Tina","Safeway",238,166.6,"West"]
["2008-02-11","Tom","Whole Foods",727,327.14999999999998,"NorthWest"]
["2007-08-16","Tina","Whole Foods",57,24.51,"West"]
["2005-11-17","Tom","Coop",214,136.96,"West"]
["2008-06-05","Sioux","Coop",181,86.88,"West"]
["2007-06-06","Chin","PCC",138,67.62,"East"]
["2006-03-06","Tina","PCC",1098,680.76,"NorthWest"]
["2006-07-26","Sioux","Safeway",226,119.78,"MidWest"]
["2007-05-24","Joy","Fred Myer",227,93.07,"West"]
["2007-01-06","Joy","PCC",88,40.479999999999997,"West"]
["2007-06-23","Tom","PCC",191,108.87,"MidWest"]
["2008-01-18","Joy","Fred Myer",123,97.17,"West"]
["2006-05-30","Chin","Whole Foods",97,50.44,"NorthWest"]
["2008-06-22","Sioux","PCC",166,132.80000000000001,"MidWest"]
["2007-11-19","Tina","Whole Foods",210,134.4,"NorthWest"]
["2006-04-19","Sioux","Fred Myer",97,42.68,"NorthWest"]
["2005-10-30","Joy","Fred Myer",1756,965.8,"West"]
["2007-10-27","Joy","Coop",144,87.84,"NorthWest"]
["2007-07-05","Tom","PCC",531,387.63,"MidWest"]
["2007-05-06","Sioux","Whole Foods",55,29.15,"MidWest"]
["2008-06-05","Tina","Safeway",79,37.92,"NorthEast"]
["2005-12-04","Chin","Safeway",93,61.38,"NorthWest"]
["2008-01-11","Tom","Safeway",51,31.62,"MidWest"]
["2007-10-09","Tom","Coop",199,95.52,"East"]
["2007-10-03","Tina","Fred Myer",160,70.400000000000006,"East"]
["2006-01-20","Joy","PCC",153,81.09,"MidWest"]
["2006-01-07","Sioux","PCC",1435,574,"West"]
["2007-01-20","Tom","Safeway",172,127.28,"MidWest"]
["2007-03-18","Sioux","Fred Myer",217,156.24,"West"]
["2007-03-11","Tom","Coop",108,81,"NorthEast"]
["2006-06-13","Joy","Safeway",51,26.52,"East"]
["2007-11-26","Tom","Whole Foods",160,86.4,"West"]
["2006-05-29","Chin","Whole Foods",110,88,"NorthEast"]
["2005-12-21","Joy","Safeway",194,147.44,"MidWest"]
["2006-11-23","Tina","Coop",202,103.02,"West"]
["2007-03-04","Tina","PCC",1061,583.54999999999995,"West"]
["2005-10-31","Tom","Fred Myer",1373,741.42,"West"]
["2006-01-09","Tom","PCC",216,123.12,"East"]
["2005-06-13","Chin","PCC",130,85.8,"NorthWest"]
["2007-06-15","Chin","Whole Foods",107,66.34,"MidWest"]
["2006-08-29","Tom","PCC",63,37.17,"West"]
["2005-05-31","Sioux","Safeway",169,89.57,"NorthWest"]
["2005-11-24","Chin","Whole Foods",113,67.8,"MidWest"]
["2008-06-18","Chin","Safeway",86,55.04,"East"]
["2005-11-03","Tina","Coop",130,75.400000000000006,"MidWest"]
["2008-06-28","Sioux","PCC",184,141.68,"MidWest"]
["2007-03-27","Sioux","Coop",1450,1116.5,"NorthEast"]
["2007-05-23","Tina","Safeway",140,75.599999999999994,"West"]
["2008-03-30","Sioux","Fred Myer",79,37.92,"NorthWest"]
["2008-01-04","Tina","Safeway",51,27.03,"MidWest"]
["2006-11-22","Sioux","Safeway",242,166.98,"NorthWest"]
["2006-04-21","Sioux","Whole Foods",221,154.69999999999999,"West"]
["2005-09-06","Chin","PCC",1158,509.52,"East"]
["2006-11-28","Tom","Fred Myer",208,160.16,"NorthWest"]
["2008-03-02","Joy","Fred Myer",129,81.27,"MidWest"]
["2007-08-06","Chin","Coop",107,62.06,"West"]
["2006-12-23","Joy","Coop",1494,1150.3800000000001,"MidWest"]
["2005-12-25","Sioux","PCC",75,57.75,"MidWest"]
["2006-05-31","Tina","PCC",122,76.86,"MidWest"]
["2007-08-12","Tom","PCC",62,25.42,"West"]
["2005-10-25","Sioux","Whole Foods",74,48.84,"MidWest"]
["2007-01-15","Tom","Safeway",139,107.03,"West"]
["2007-08-22","Tina","Safeway",88,49.28,"East"]
["2007-03-13","Tina","Whole Foods",102,61.2,"West"]
["2007-02-24","Sioux","Whole Foods",90,36.9,"MidWest"]
["2006-02-02","Tina","Fred Myer",77,30.8,"West"]
["2006-03-02","Tom","Whole Foods",1569,737.43,"NorthEast"]
["2007-01-20","Tina","Whole Foods",204,116.28,"NorthWest"]
["2008-03-27","Chin","Safeway",160,108.8,"East"]
["2005-08-01","Sioux","Whole Foods",949,740.22,"East"]
["2008-01-13","Tina","Coop",232,120.64,"West"]
["2006-06-03","Sioux","Whole Foods",201,124.62,"NorthWest"]
["2008-06-24","Joy","Whole Foods",78,59.28,"MidWest"]
["2008-02-18","Tom","Safeway",95,59.85,"NorthWest"]
["2007-09-28","Tom","Fred Myer",51,21.93,"NorthWest"]
["2005-12-11","Joy","PCC",169,69.290000000000006,"NorthWest"]
["2007-09-07","Chin","Fred Myer",1430,672.1,"West"]
["2005-10-24","Tina","Whole Foods",119,84.49,"NorthEast"]
["2006-11-04","Joy","PCC",159,71.55,"NorthEast"]
["2006-01-15","Tina","Safeway",180,102.6,"NorthWest"]
["2005-08-25","Tina","Fred Myer",238,138.04,"East"]
["2005-10-01","Sioux","Fred Myer",113,83.62,"West"]
["2007-09-12","Tom","Whole Foods",192,144,"West"]
["2005-07-01","Tina","Whole Foods",151,80.03,"MidWest"]
["2007-09-07","Chin","PCC",170,136,"NorthWest"]
["2007-12-03","Chin","Fred Myer",80,40.799999999999997,"MidWest"]
["2007-01-22","Sioux","Fred Myer",810,380.7,"MidWest"]
["2008-06-03","Tina","Whole Foods",235,103.4,"West"]
["2008-03-29","Joy","Whole Foods",97,61.11,"MidWest"]
["2007-12-25","Sioux","Safeway",76,37.24,"East"]
["2007-03-03","Joy","PCC",213,108.63,"West"]
["2008-01-22","Tom","Fred Myer",247,140.79,"West"]
["2006-05-19","Tina","Whole Foods",109,73.03,"MidWest"]
["2006-01-02","Chin","PCC",111,56.61,"West"]
["2008-03-04","Tina","Safeway",181,115.84,"NorthWest"]
["2006-01-03","Tom","Fred Myer",162,69.66,"West"]
["2007-09-10","Tom","Coop",1820,746.2,"East"]
["2008-03-16","Chin","Fred Myer",190,98.8,"MidWest"]
["2006-12-31","Chin","PCC",216,155.52000000000001,"NorthWest"]
["2008-06-14","Sioux","Whole Foods",125,55,"NorthEast"]
["2005-08-01","Tom","Fred Myer",142,86.62,"MidWest"]
["2008-05-23","Sioux","Safeway",96,50.88,"West"]
["2006-04-01","Joy","PCC",186,122.76,"NorthWest"]
["2007-09-15","Tom","PCC",853,562.98,"West"]
["2005-08-05","Joy","Coop",89,51.62,"West"]
["2006-12-18","Tina","Fred Myer",231,106.26,"NorthEast"]
["2007-02-02","Chin","Coop",1104,805.92,"East"]
["2007-03-18","Joy","Coop",114,52.44,"West"]
["2005-08-25","Chin","Whole Foods",105,74.55,"NorthEast"]
["2007-03-14","Sioux","Coop",103,65.92,"NorthWest"]
["2008-02-10","Sioux","Safeway",183,115.29,"West"]
["2005-06-29","Sioux","Coop",221,143.65,"MidWest"]
["2005-08-18","Chin","Whole Foods",146,84.68,"NorthEast"]
["2007-02-15","Sioux","Coop",176,70.400000000000006,"NorthEast"]
["2005-06-05","Joy","Fred Myer",50,35.5,"NorthEast"]
["2007-10-07","Joy","Fred Myer",186,126.48,"West"]
["2006-04-17","Sioux","Safeway",1062,626.58000000000004,"East"]
["2007-07-25","Tina","Safeway",179,112.77,"NorthEast"]
["2007-10-31","Chin","PCC",92,37.72,"NorthEast"]
["2006-03-04","Tina","Coop",132,91.08,"East"]
["2007-04-03","Chin","PCC",696,542.88,"MidWest"]
["2008-01-14","Tina","PCC",70,44.1,"West"]
["2007-09-10","Tina","Coop",53,32.86,"West"]
["2005-11-07","Tom","Fred Myer",85,40.799999999999997,"West"]
["2005-12-05","Joy","PCC",142,92.3,"East"]
["2006-03-16","Tom","Safeway",243,102.06,"NorthWest"]
["2007-05-27","Tom","PCC",1402,686.98,"MidWest"]
["2006-11-06","Tina","Fred Myer",161,69.23,"NorthWest"]
["2006-03-12","Sioux","Fred Myer",156,84.24,"West"]
["2005-10-06","Tom","Safeway",208,122.72,"NorthWest"]
["2008-05-03","Tom","Coop",241,185.57,"NorthWest"]
["2008-05-12","Chin","Fred Myer",234,142.74,"West"]
["2007-06-26","Tom","PCC",147,67.62,"NorthEast"]
["2007-03-07","Tom","Safeway",73,55.48,"East"]
["2008-05-19","Chin","Coop",51,26.52,"NorthWest"]
["2007-06-25","Joy","Safeway",126,60.48,"NorthEast"]
["2008-01-21","Sioux","Whole Foods",1297,609.59,"MidWest"]
["2006-09-11","Chin","Whole Foods",501,310.62,"East"]
["2006-10-10","Joy","PCC",77,46.97,"East"]
["2007-02-10","Sioux","Coop",173,115.91,"NorthWest"]
["2007-12-10","Tina","Coop",182,96.46,"East"]
["2007-05-14","Tom","Safeway",143,98.67,"MidWest"]
["2007-01-30","Joy","PCC",191,99.32,"MidWest"]
["2007-09-17","Chin","PCC",127,80.010000000000005,"East"]
["2006-06-23","Sioux","Whole Foods",58,35.96,"MidWest"]
["2007-02-25","Chin","Whole Foods",191,103.14,"NorthEast"]
["2007-05-06","Chin","PCC",1940,931.2,"West"]
["2005-11-29","Tom","PCC",80,36,"West"]
["2008-05-22","Sioux","Fred Myer",72,55.44,"West"]
["2007-12-15","Sioux","Whole Foods",250,110,"NorthWest"]
["2006-10-02","Tom","Whole Foods",219,109.5,"East"]
["2007-12-11","Chin","Safeway",219,168.63,"NorthEast"]
["2008-02-19","Sioux","Coop",85,39.1,"East"]
["2007-10-24","Tina","Safeway",115,52.9,"NorthEast"]
["2008-05-31","Joy","PCC",870,495.9,"East"]
["2007-03-30","Sioux","Fred Myer",124,65.72,"East"]
["2006-12-26","Tina","PCC",1460,861.4,"West"]
["2007-12-27","Sioux","Fred Myer",244,185.44,"East"]
["2007-03-25","Joy","Fred Myer",75,48.75,"East"]
["2006-10-29","Chin","Fred Myer",195,78,"West"]
["2008-01-30","Chin","Coop",248,181.04,"East"]
["2005-07-12","Tom","PCC",183,96.99,"NorthEast"]
["2006-06-16","Sioux","Whole Foods",88,51.92,"MidWest"]
["2008-05-27","Chin","Whole Foods",193,140.88999999999999,"East"]
["2005-11-27","Chin","Whole Foods",155,88.35,"MidWest"]
["2006-08-08","Tina","Safeway",202,119.18,"East"]
["2006-04-04","Tina","PCC",1908,1278.3599999999999,"NorthEast"]
["2008-05-07","Chin","PCC",126,75.599999999999994,"MidWest"]
["2006-12-08","Joy","Whole Foods",97,65.959999999999994,"West"]
["2007-01-02","Joy","Whole Foods",180,97.2,"East"]
["2008-05-15","Joy","Coop",67,40.200000000000003,"MidWest"]
["2007-11-20","Chin","Fred Myer",576,328.32,"West"]
["2007-11-17","Sioux","Safeway",230,165.6,"NorthEast"]
["2005-06-12","Tina","Safeway",86,59.34,"NorthWest"]
["2007-04-30","Joy","PCC",125,77.5,"MidWest"]
["2006-06-16","Joy","Fred Myer",113,73.45,"East"]
["2008-04-20","Sioux","Fred Myer",1399,1077.23,"NorthEast"]
["2007-01-17","Chin","Whole Foods",201,106.53,"NorthWest"]
["2007-03-16","Joy","PCC",82,52.48,"MidWest"]
["2007-07-10","Sioux","PCC",201,134.66999999999999,"NorthWest"]
["2006-04-10","Sioux","PCC",90,38.700000000000003,"MidWest"]
["2007-06-20","Tom","Whole Foods",191,95.5,"East"]
["2006-11-08","Tina","Whole Foods",71,37.630000000000003,"NorthWest"]
["2006-10-07","Sioux","Fred Myer",209,100.32,"NorthWest"]
["2008-05-23","Tom","PCC",205,84.05,"NorthWest"]
["2008-01-29","Tom","PCC",101,47.47,"East"]
["2006-12-30","Tom","Whole Foods",1928,867.6,"East"]
["2006-01-10","Joy","Safeway",189,143.63999999999999,"MidWest"]
["2008-06-04","Chin","PCC",596,452.96,"West"]
["2006-03-15","Chin","Fred Myer",224,100.8,"East"]
["2008-05-08","Tina","Whole Foods",110,86.9,"West"]
["2006-01-25","Tina","Safeway",188,75.2,"NorthEast"]
["2005-08-08","Joy","Fred Myer",224,145.6,"NorthWest"]
["2006-11-09","Joy","Whole Foods",155,75.95,"West"]
["2005-10-07","Sioux","Fred Myer",63,49.14,"East"]
["2007-08-30","Tom","Fred Myer",55,29.7,"NorthEast"]
["2005-10-14","Joy","PCC",1386,1108.8,"NorthWest"]
["2005-06-30","Tina","PCC",132,71.28,"NorthEast"]
["2006-05-14","Tina","Fred Myer",221,121.55,"NorthWest"]
["2006-10-30","Tina","PCC",236,146.32,"East"]
["2007-12-11","Tom","Coop",84,49.56,"NorthWest"]
["2006-03-30","Chin","PCC",55,22,"East"]
["2006-06-30","Chin","Fred Myer",204,153,"MidWest"]
["2007-07-12","Tina","Whole Foods",226,97.18,"NorthEast"]
["2006-10-04","Sioux","PCC",72,32.4,"East"]
["2006-09-26","Tina","Whole Foods",760,342,"NorthWest"]
["2007-07-20","Tom","Whole Foods",1064,734.16,"NorthWest"]
["2005-12-31","Tom","Safeway",66,34.979999999999997,"East"]
["2006-10-14","Joy","Safeway",181,123.08,"East"]
["2007-06-27","Sioux","Coop",205,139.4,"West"]
["2006-09-17","Tina","Safeway",94,47,"NorthEast"]
["2007-04-30","Joy","PCC",190,104.5,"MidWest"]
["2007-12-08","Tom","PCC",69,54.51,"East"]
["2007-12-01","Tom","Coop",158,71.099999999999994,"West"]
["2006-03-18","Sioux","Fred Myer",87,34.799999999999997,"East"]
["2007-02-17","Joy","Coop",139,98.69,"MidWest"]
["2008-05-13","Chin","Fred Myer",1780,1281.5999999999999,"NorthEast"]
["2005-06-07","Tom","Whole Foods",242,179.08,"West"]
["2006-07-22","Joy","Fred Myer",232,102.08,"East"]
["2005-11-14","Sioux","Coop",79,55.3,"NorthWest"]
["2007-07-08","Joy","Fred Myer",52,36.4,"NorthWest"]
["2005-10-13","Tina","Safeway",114,69.540000000000006,"West"]
["2007-11-16","Sioux","Coop",998,658.68,"East"]
["2005-05-30","Sioux","Safeway",68,47.6,"MidWest"]
["2005-08-06","Tom","PCC",157,108.33,"NorthEast"]
["2007-03-16","Chin","Whole Foods",137,105.49,"MidWest"]
["2006-04-17","Sioux","PCC",1983,1110.48,"NorthEast"]
["2008-05-16","Tina","Fred Myer",222,168.72,"MidWest"]
["2008-01-07","Chin","Coop",109,50.14,"East"]
["2006-10-20","Joy","Fred Myer",77,60.83,"West"]
["2005-08-22","Tom","Fred Myer",250,145,"MidWest"]
["2007-02-07","Tina","Safeway",57,40.47,"West"]
["2007-04-07","Tom","PCC",119,69.02,"NorthWest"]
["2005-08-21","Chin","Coop",222,93.24,"West"]
["2006-07-26","Tina","Coop",119,51.17,"West"]
["2005-10-12","Tom","Coop",135,70.2,"West"]
["2007-02-09","Sioux","Whole Foods",1276,714.56,"MidWest"]
["2008-01-05","Tina","PCC",135,55.35,"NorthWest"]
["2005-10-18","Sioux","Coop",97,43.65,"NorthEast"]
["2007-11-21","Joy","PCC",536,225.12,"NorthEast"]
["2007-03-18","Sioux","Whole Foods",95,47.5,"NorthEast"]
["2006-12-06","Joy","PCC",186,81.84,"NorthEast"]
["2005-08-19","Tina","Safeway",184,119.6,"MidWest"]
["2008-06-22","Tom","PCC",225,153,"MidWest"]
["2007-05-13","Sioux","PCC",235,152.75,"NorthWest"]
["2006-10-01","Tom","Whole Foods",87,62.64,"NorthEast"]
["2007-02-18","Sioux","Safeway",1855,1391.25,"West"]
["2005-08-13","Sioux","Safeway",151,102.68,"MidWest"]
["2006-08-08","Sioux","Whole Foods",177,83.19,"NorthEast"]
["2006-12-14","Tina","Fred Myer",91,50.05,"East"]
["2008-03-08","Chin","Whole Foods",96,48.96,"MidWest"]
["2006-02-04","Tina","Safeway",87,46.98,"West"]
["2008-04-02","Chin","Fred Myer",189,75.599999999999994,"MidWest"]
["2008-04-08","Tina","Whole Foods",134,58.96,"NorthEast"]
["2006-01-05","Chin","Whole Foods",151,64.930000000000007,"MidWest"]
["2008-01-06","Sioux","Whole Foods",66,38.94,"West"]
["2008-03-23","Tina","Safeway",603,295.47000000000003,"MidWest"]
["2007-08-28","Tom","Whole Foods",239,160.13,"NorthEast"]
["2006-08-14","Sioux","Fred Myer",74,59.2,"MidWest"]
["2006-05-16","Sioux","Coop",73,48.91,"West"]
["2007-09-07","Joy","PCC",217,123.69,"West"]
["2005-12-24","Sioux","PCC",82,50.02,"West"]
["2007-03-01","Chin","Fred Myer",241,161.47,"NorthEast"]
["2006-05-18","Tina","Safeway",115,57.5,"NorthWest"]
["2007-12-14","Sioux","PCC",166,124.5,"East"]
["2006-03-14","Sioux","Fred Myer",203,83.23,"NorthEast"]
["2007-04-28","Sioux","Fred Myer",1746,1187.28,"West"]
["2006-12-18","Sioux","Fred Myer",144,105.12,"NorthWest"]
["2008-03-21","Chin","Coop",203,158.34,"NorthWest"]
["2007-04-15","Tom","Fred Myer",117,69.03,"East"]
["2006-10-19","Tom","Whole Foods",205,145.55000000000001,"West"]
["2005-07-24","Tom","Whole Foods",152,71.44,"East"]
["2008-06-30","Joy","Whole Foods",175,105,"NorthWest"]
["2007-11-07","Tom","Fred Myer",814,407,"NorthEast"]
["2006-10-16","Sioux","PCC",182,120.12,"MidWest"]
["2006-01-13","Chin","Whole Foods",156,106.08,"NorthWest"]
["2007-07-12","Chin","Coop",1051,756.72,"NorthWest"]
["2006-12-29","Sioux","Coop",232,120.64,"NorthEast"]
["2006-05-21","Joy","Fred Myer",103,67.98,"MidWest"]
["2007-01-18","Sioux","Fred Myer",233,132.81,"West"]
["2005-09-13","Chin","Fred Myer",92,59.8,"West"]
["2006-02-18","Joy","Coop",114,80.94,"West"]
["2005-07-18","Tina","PCC",64,43.52,"East"]
["2008-02-16","Tina","Whole Foods",211,145.59,"MidWest"]
["2006-04-21","Chin","Fred Myer",219,131.4,"East"]
["2005-06-09","Chin","PCC",166,112.88,"MidWest"]
["2006-06-20","Chin","Whole Foods",1622,713.68,"West"]
["2006-09-04","Chin","Fred Myer",204,95.88,"NorthEast"]
["2007-07-29","Tom","Whole Foods",137,60.28,"MidWest"]
["2008-03-01","Sioux","Fred Myer",222,106.56,"East"]
["2007-07-17","Joy","Safeway",815,448.25,"NorthEast"]
["2008-03-18","Chin","Fred Myer",61,45.75,"East"]
["2007-02-19","Tom","Fred Myer",192,82.56,"MidWest"]
["2006-04-23","Sioux","PCC",232,127.6,"West"]
["2006-10-23","Chin","PCC",141,95.88,"NorthEast"]
["2005-07-06","Tina","Safeway",130,62.4,"NorthWest"]
["2008-05-06","Chin","Fred Myer",1945,1108.6500000000001,"NorthEast"]
["2007-07-29","Joy","Coop",106,61.48,"West"]
["2006-06-11","Chin","Coop",53,28.62,"NorthWest"]
["2006-09-30","Tom","Safeway",128,61.44,"NorthWest"]
["2006-09-04","Joy","PCC",61,35.380000000000003,"West"]
["2006-04-22","Tina","Whole Foods",216,110.16,"West"]
["2006-11-29","Joy","Fred Myer",65,48.75,"East"]
["2006-04-12","Tina","Coop",89,37.380000000000003,"NorthEast"]
["2006-12-13","Tina","Safeway",175,126,"NorthEast"]
["2006-06-16","Joy","Fred Myer",200,158,"NorthEast"]
["2007-11-18","Joy","Coop",1541,1063.29,"NorthEast"]
["2008-04-04","Chin","PCC",1054,706.18,"MidWest"]
["2007-07-18","Joy","Safeway",81,50.22,"East"]
["2007-07-17","Joy","Safeway",243,182.25,"East"]
["2005-06-14","Tina","Safeway",154,72.38,"NorthEast"]
["2006-08-16","Chin","Safeway",114,64.98,"East"]
["2006-12-20","Chin","Safeway",96,44.16,"NorthWest"]
["2006-04-25","Sioux","PCC",96,76.8,"East"]
["2007-03-19","Joy","Safeway",191,78.31,"NorthEast"]
["2005-06-18","Joy","Fred Myer",250,147.5,"NorthWest"]
["2006-06-15","Joy","Fred Myer",1674,1138.32,"NorthWest"]
["2008-01-23","Tom","PCC",162,95.58,"East"]
["2006-10-27","Chin","Coop",73,37.229999999999997,"East"]
["2006-10-29","Tina","Safeway",110,75.900000000000006,"MidWest"]
["2006-12-12","Joy","PCC",232,143.84,"NorthEast"]
["2006-03-16","Chin","Fred Myer",80,32.799999999999997,"NorthWest"]
["2007-05-05","Chin","PCC",94,38.54,"NorthWest"]
["2006-10-13","Tina","Fred Myer",92,65.319999999999993,"East"]
["2007-05-31","Joy","Coop",1223,758.26,"West"]
["2006-08-06","Chin","Safeway",242,191.18,"NorthWest"]
["2005-10-15","Tom","Whole Foods",1434,630.96,"East"]
["2006-01-23","Sioux","PCC",194,135.80000000000001,"NorthEast"]
["2006-07-12","Tina","PCC",63,30.87,"West"]
["2007-09-16","Sioux","Fred Myer",206,115.36,"East"]
["2008-01-24","Tina","Fred Myer",154,120.12,"West"]
["2006-08-03","Chin","Coop",66,31.02,"NorthEast"]
["2007-12-03","Tina","PCC",156,82.68,"East"]
["2007-09-05","Joy","Whole Foods",224,98.56,"NorthEast"]
["2006-12-30","Chin","Safeway",64,34.56,"NorthWest"]
["2006-11-03","Sioux","Whole Foods",246,157.44,"MidWest"]
["2007-09-18","Tom","Fred Myer",1426,627.44000000000005,"West"]
["2007-06-01","Tina","Fred Myer",91,50.05,"NorthEast"]
["2005-10-28","Chin","PCC",83,56.44,"NorthWest"]
["2008-06-13","Joy","Coop",53,24.38,"NorthWest"]
["2008-01-07","Chin","Coop",114,74.099999999999994,"East"]
["2006-04-22","Tom","Whole Foods",1133,895.07,"East"]
["2006-09-04","Sioux","Whole Foods",102,54.06,"NorthWest"]
["2008-02-25","Chin","Safeway",234,114.66,"NorthWest"]
["2005-08-29","Joy","Safeway",239,174.47,"NorthWest"]
["2008-02-23","Tom","Fred Myer",151,78.52,"MidWest"]
["2006-11-24","Joy","Whole Foods",1075,849.25,"NorthEast"]
["2008-01-25","Tom","PCC",157,120.89,"MidWest"]
["2007-06-25","Joy","Coop",249,179.28,"West"]

{"sheet":"2 Data Analysis(2)","index":4,"n_rows":388,"n_cols":2,"rows_kept":388,"cut":false,"hidden":false,"merged":[]}
["To Count a set of data, drop the field into the Row Labels area and the Value area. To Change the function, format or formula for a Pivot Table, Right-click the Value field in the PivotTable and point to \"Value Field Settings\"."]
[]
["Student","Phone Type"]
["Student 01",{"$f":"CHOOSE(RANDBETWEEN(1,8),\"iPhone\",\"iPhone\",\"Nokia\",\"Nokia\",\"Motorola\",\"Sony Erickson\",\"Samsung\",\"Sprint\")","v":"iPhone"}]
["Student 02",{"$f":"CHOOSE(RANDBETWEEN(1,8),\"iPhone\",\"iPhone\",\"Nokia\",\"Nokia\",\"Motorola\",\"Sony Erickson\",\"Samsung\",\"Sprint\")","v":"iPhone"}]
["Student 03","Nokia"]
["Student 04","iPhone"]
["Student 05","Sprint"]
["Student 06","Motorola"]
["Student 07","Motorola"]
["Student 08","Nokia"]
["Student 09","Nokia"]
["Student 10","Samsung"]
["Student 11","Nokia"]
["Student 12","Nokia"]
["Student 13","Nokia"]
["Student 14","Motorola"]
["Student 15","Samsung"]
["Student 16","Samsung"]
["Student 17","Sprint"]
["Student 18","Sprint"]
["Student 19","Motorola"]
["Student 20","Samsung"]
["Student 21","Samsung"]
["Student 22","Nokia"]
["Student 23","Sony Erickson"]
["Student 24","Nokia"]
["Student 25","Nokia"]
["Student 26","Nokia"]
["Student 27","Nokia"]
["Student 28","Nokia"]
["Student 29","Sony Erickson"]
["Student 30","iPhone"]
["Student 31","Nokia"]
["Student 32","Sprint"]
["Student 33","Sony Erickson"]
["Student 34","Nokia"]
["Student 35","Samsung"]
["Student 36","Sony Erickson"]
["Student 37","Sony Erickson"]
["Student 38","Nokia"]
["Student 39","Nokia"]
["Student 40","Sony Erickson"]
["Student 41","iPhone"]
["Student 42","iPhone"]
["Student 43","iPhone"]
["Student 44","Motorola"]
["Student 45","Nokia"]
["Student 46","Sony Erickson"]
["Student 47","iPhone"]
["Student 48","iPhone"]
["Student 49","Nokia"]
["Student 50","Sprint"]
["Student 51","iPhone"]
["Student 52","Sony Erickson"]
["Student 53","Sony Erickson"]
["Student 54","Motorola"]
["Student 55","iPhone"]
["Student 56","Nokia"]
["Student 57","Sony Erickson"]
["Student 58","Sprint"]
["Student 59","iPhone"]
["Student 60","Sony Erickson"]
["Student 61","Sony Erickson"]
["Student 62","Nokia"]
["Student 63","iPhone"]
["Student 64","iPhone"]
["Student 65","Samsung"]
["Student 66",{"$f":"CHOOSE(RANDBETWEEN(1,8),\"iPhone\",\"iPhone\",\"Nokia\",\"Nokia\",\"Motorola\",\"Sony Erickson\",\"Samsung\",\"Sprint\")","v":"Sprint"}]
["Student 67","Nokia"]
["Student 68","Sprint"]
["Student 69","Motorola"]
["Student 70","Samsung"]
["Student 71","iPhone"]
["Student 72","Samsung"]
["Student 73","iPhone"]
["Student 74","Nokia"]
["Student 75","iPhone"]
["Student 76","Motorola"]
["Student 77","Sprint"]
["Student 78","Nokia"]
["Student 79","Nokia"]
["Student 80","Samsung"]
["Student 81","iPhone"]
["Student 82","iPhone"]
["Student 83","Sony Erickson"]
["Student 84","Motorola"]
["Student 85","Sony Erickson"]
["Student 86","Nokia"]
["Student 87","Sony Erickson"]
["Student 88","Nokia"]
["Student 89","Nokia"]
["Student 90","Sony Erickson"]
["Student 91","Sprint"]
["Student 92","iPhone"]
["Student 93","Nokia"]
["Student 94","Samsung"]
["Student 95","Samsung"]
["Student 96","iPhone"]
["Student 97","Samsung"]
["Student 98","Samsung"]
["Student 99","iPhone"]
["Student 100","Sprint"]
["Student 101","Sprint"]
["Student 102","Samsung"]
["Student 103","Samsung"]
["Student 104","Nokia"]
["Student 105","iPhone"]
["Student 106","Nokia"]
["Student 107","Sony Erickson"]
["Student 108","iPhone"]
["Student 109","iPhone"]
["Student 110","Motorola"]
["Student 111","Nokia"]
["Student 112","Samsung"]
["Student 113","Sprint"]
["Student 114","Sony Erickson"]
["Student 115","Nokia"]
["Student 116","Sprint"]
["Student 117","iPhone"]
["Student 118","Nokia"]
["Student 119","Sprint"]
["Student 120","Sony Erickson"]
["Student 121","Sony Erickson"]
["Student 122","Samsung"]
["Student 123","Motorola"]
["Student 124","Sprint"]
["Student 125","Nokia"]
["Student 126","Samsung"]
["Student 127","Nokia"]
["Student 128","Samsung"]
["Student 129","Motorola"]
["Student 130",{"$f":"CHOOSE(RANDBETWEEN(1,8),\"iPhone\",\"iPhone\",\"Nokia\",\"Nokia\",\"Motorola\",\"Sony Erickson\",\"Samsung\",\"Sprint\")","v":"Motorola"}]
["Student 131","Motorola"]
["Student 132","iPhone"]
["Student 133","iPhone"]
["Student 134","Nokia"]
["Student 135","Motorola"]
["Student 136","Nokia"]
["Student 137","iPhone"]
["Student 138","Sprint"]
["Student 139","Samsung"]
["Student 140","iPhone"]
["Student 141","iPhone"]
["Student 142","Nokia"]
["Student 143","Sprint"]
["Student 144","Sprint"]
["Student 145","iPhone"]
["Student 146","iPhone"]
["Student 147","Nokia"]
["Student 148","Samsung"]
["Student 149","Nokia"]
["Student 150","iPhone"]
["Student 151","iPhone"]
["Student 152","Nokia"]
["Student 153","Sony Erickson"]
["Student 154","Motorola"]
["Student 155","Nokia"]
["Student 156","iPhone"]
["Student 157","Sprint"]
["Student 158","iPhone"]
["Student 159","iPhone"]
["Student 160","iPhone"]
["Student 161","Motorola"]
["Student 162","Motorola"]
["Student 163","Motorola"]
["Student 164","iPhone"]
["Student 165","iPhone"]
["Student 166","Samsung"]
["Student 167","Motorola"]
["Student 168","Sprint"]
["Student 169","iPhone"]
["Student 170","Sony Erickson"]
["Student 171","Sprint"]
["Student 172","Motorola"]
["Student 173","Samsung"]
["Student 174","Nokia"]
["Student 175","Motorola"]
["Student 176","Nokia"]
["Student 177","Nokia"]
["Student 178","iPhone"]
["Student 179","iPhone"]
["Student 180","Nokia"]
["Student 181","Sprint"]
["Student 182","Sony Erickson"]
["Student 183","Nokia"]
["Student 184","Motorola"]
["Student 185","Nokia"]
["Student 186","iPhone"]
["Student 187","Sprint"]
["Student 188","iPhone"]
["Student 189","iPhone"]
["Student 190","Motorola"]
["Student 191","Nokia"]
["Student 192","Nokia"]
["Student 193","Nokia"]
["Student 194",{"$f":"CHOOSE(RANDBETWEEN(1,8),\"iPhone\",\"iPhone\",\"Nokia\",\"Nokia\",\"Motorola\",\"Sony Erickson\",\"Samsung\",\"Sprint\")","v":"iPhone"}]
["Student 195","Sony Erickson"]
["Student 196","Sprint"]
["Student 197","Sony Erickson"]
["Student 198","Sprint"]
["Student 199","Motorola"]
["Student 200","Motorola"]
["Student 201","iPhone"]
["Student 202","Motorola"]
["Student 203","Nokia"]
["Student 204","Sprint"]
["Student 205","Samsung"]
["Student 206","Sprint"]
["Student 207","Nokia"]
["Student 208","iPhone"]
["Student 209","Sprint"]
["Student 210","iPhone"]
["Student 211","Motorola"]
["Student 212","Nokia"]
["Student 213","iPhone"]
["Student 214","Nokia"]
["Student 215","iPhone"]
["Student 216","Sony Erickson"]
["Student 217","iPhone"]
["Student 218","Nokia"]
["Student 219","iPhone"]
["Student 220","Sprint"]
["Student 221","Sony Erickson"]
["Student 222","iPhone"]
["Student 223","iPhone"]
["Student 224","Nokia"]
["Student 225","Sprint"]
["Student 226","Nokia"]
["Student 227","Nokia"]
["Student 228","Samsung"]
["Student 229","Nokia"]
["Student 230","Motorola"]
["Student 231","Nokia"]
["Student 232","Samsung"]
["Student 233","Nokia"]
["Student 234","Sprint"]
["Student 235","iPhone"]
["Student 236","Nokia"]
["Student 237","Nokia"]
["Student 238","Nokia"]
["Student 239","Samsung"]
["Student 240","iPhone"]
["Student 241","Samsung"]
["Student 242","iPhone"]
["Student 243","Nokia"]
["Student 244","Sprint"]
["Student 245","iPhone"]
["Student 246","Samsung"]
["Student 247","Motorola"]
["Student 248","iPhone"]
["Student 249","Motorola"]
["Student 250","Sony Erickson"]
["Student 251","iPhone"]
["Student 252","Samsung"]
["Student 253","Nokia"]
["Student 254","Sony Erickson"]
["Student 255","Sony Erickson"]
["Student 256","Sprint"]
["Student 257","Samsung"]
["Student 258",{"$f":"CHOOSE(RANDBETWEEN(1,8),\"iPhone\",\"iPhone\",\"Nokia\",\"Nokia\",\"Motorola\",\"Sony Erickson\",\"Samsung\",\"Sprint\")","v":"Sprint"}]
["Student 259","Nokia"]
["Student 260","Sony Erickson"]
["Student 261","Motorola"]
["Student 262","iPhone"]
["Student 263","Nokia"]
["Student 264","Samsung"]
["Student 265","iPhone"]
["Student 266","Nokia"]
["Student 267","Sprint"]
["Student 268","Sony Erickson"]
["Student 269","Sprint"]
["Student 270","iPhone"]
["Student 271","iPhone"]
["Student 272","Motorola"]
["Student 273","Sprint"]
["Student 274","iPhone"]
["Student 275","Sprint"]
["Student 276","Nokia"]
["Student 277","iPhone"]
["Student 278","Sony Erickson"]
["Student 279","Nokia"]
["Student 280","Sony Erickson"]
["Student 281","Samsung"]
["Student 282","iPhone"]
["Student 283","Nokia"]
["Student 284","Motorola"]
["Student 285","Sony Erickson"]
["Student 286","iPhone"]
["Student 287","Sony Erickson"]
["Student 288","iPhone"]
["Student 289","Sprint"]
["Student 290","Nokia"]
["Student 291","Samsung"]
["Student 292","Sprint"]
["Student 293","Samsung"]
["Student 294","Nokia"]
["Student 295","Samsung"]
["Student 296","Nokia"]
["Student 297","Nokia"]
["Student 298","iPhone"]
["Student 299","Sprint"]
["Student 300","Nokia"]
["Student 301","Nokia"]
["Student 302","Nokia"]
["Student 303","Nokia"]
["Student 304","Nokia"]
["Student 305","Nokia"]
["Student 306","iPhone"]
["Student 307","Samsung"]
["Student 308","Nokia"]
["Student 309","Sprint"]
["Student 310","iPhone"]
["Student 311","iPhone"]
["Student 312","Motorola"]
["Student 313","iPhone"]
["Student 314","Samsung"]
["Student 315","Sprint"]
["Student 316","Samsung"]
["Student 317","iPhone"]
["Student 318","Nokia"]
["Student 319","Nokia"]
["Student 320","Sprint"]
["Student 321","Samsung"]
["Student 322",{"$f":"CHOOSE(RANDBETWEEN(1,8),\"iPhone\",\"iPhone\",\"Nokia\",\"Nokia\",\"Motorola\",\"Sony Erickson\",\"Samsung\",\"Sprint\")","v":"Sprint"}]
["Student 323","Motorola"]
["Student 324","Nokia"]
["Student 325","iPhone"]
["Student 326","iPhone"]
["Student 327","Motorola"]
["Student 328","iPhone"]
["Student 329","Sprint"]
["Student 330","Sprint"]
["Student 331","iPhone"]
["Student 332","Sprint"]
["Student 333","iPhone"]
["Student 334","Nokia"]
["Student 335","Samsung"]
["Student 336","Sony Erickson"]
["Student 337","Samsung"]
["Student 338","Samsung"]
["Student 339","iPhone"]
["Student 340","Motorola"]
["Student 341","Nokia"]
["Student 342","Motorola"]
["Student 343","iPhone"]
["Student 344","iPhone"]
["Student 345","iPhone"]
["Student 346","iPhone"]
["Student 347","iPhone"]
["Student 348","Samsung"]
["Student 349","Nokia"]
["Student 350","Motorola"]
["Student 351","Nokia"]
["Student 352","iPhone"]
["Student 353","iPhone"]
["Student 354","Sony Erickson"]
["Student 355","iPhone"]
["Student 356","Nokia"]
["Student 357","iPhone"]
["Student 358","Nokia"]
["Student 359","iPhone"]
["Student 360","Nokia"]
["Student 361","Nokia"]
["Student 362","Samsung"]
["Student 363","iPhone"]
["Student 364","Nokia"]
["Student 365","Motorola"]
["Student 366","Sprint"]
["Student 367","Nokia"]
["Student 368","Nokia"]
["Student 369","Sprint"]
["Student 370","iPhone"]
["Student 371","iPhone"]
["Student 372","iPhone"]
["Student 373","Nokia"]
["Student 374","Motorola"]
["Student 375","Sony Erickson"]
["Student 376","iPhone"]
["Student 377","Sprint"]
["Student 378","iPhone"]
["Student 379","Sony Erickson"]
["Student 380","iPhone"]
["Student 381","iPhone"]
["Student 382","Samsung"]
["Student 383","Sony Erickson"]
["Student 384","iPhone"]
["Student 385","Sprint"]

{"sheet":"3 Charts","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Charts are on the Insert Menu"]
["Once you select a Chart, three context sensitive menus appear: Design, Layout, Format"]
[]
["Customer","Sales"]
["Fred Myer",{"$f":"SUMIF('2 Data Analysis(1)'!$C$5:$C$594,A5,'2 Data Analysis(1)'!$D$5:$D$594)","v":43668}]
["Safeway",{"$f":"SUMIF('2 Data Analysis(1)'!$C$5:$C$594,A6,'2 Data Analysis(1)'!$D$5:$D$594)","v":27875}]
["Whole Foods",{"$f":"SUMIF('2 Data Analysis(1)'!$C$5:$C$594,A7,'2 Data Analysis(1)'!$D$5:$D$594)","v":38013}]
["Coop",{"$f":"SUMIF('2 Data Analysis(1)'!$C$5:$C$594,A8,'2 Data Analysis(1)'!$D$5:$D$594)","v":36540}]
["PCC",{"$f":"SUMIF('2 Data Analysis(1)'!$C$5:$C$594,A9,'2 Data Analysis(1)'!$D$5:$D$594)","v":39527}]

{"sheet":"Cell References","index":6,"n_rows":74,"n_cols":4,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["Cell References are used in formulas. For Example if you have the formula =A7-$A$11 in cell B7, the formula will always take the value in cell \"One to the left\" of the cell that the formula sits in  and subtract the value in cell A11."]
["In this class we will only use two of the four types of cell references"]
["Relative Cell Reference means that when you copy the formula, the cell reference moves relatively. For example if the formula is in a cell and the formula is look at a cell reference that is one cell to the left, that cell reference will always look one cell to the left."]
["Absolute Cell Reference means that when you copy the formula, the cell reference is locked. The cell reference will only point to the original cell. To Apply the $ sign code to the column and row reference, use the keyboard shortcut, F4 (F4 adds the two dollar signs to make the relative cell reference into an absolute cell reference."]
[]
["X","X - Average"]
[23]
[24]
[19]
[28]
[]
["Average"]
[{"$f":"AVERAGE(A7:A10)","v":23.5}]
[]
["CarTypes",null,"CarTypes","Frequency"]
["Honda",null,"Ford"]
["Toyota",null,"Toyota"]
["Honda",null,"Honda"]
["Toyota"]
["Honda"]
["Toyota"]
["Ford"]
["Toyota"]
["Ford"]
["Toyota"]
["Toyota"]
["Ford"]
["Honda"]
["Ford"]
["Ford"]
["Ford"]
["Honda"]
["Ford"]
["Toyota"]
["Ford"]
["Toyota"]
["Honda"]
["Ford"]
["Ford"]
["Toyota"]
["Toyota"]
["Ford"]
["Toyota"]
["Ford"]
["Ford"]
["Toyota"]
["Honda"]
["Ford"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Honda"]
["Toyota"]
["Ford"]
["Ford"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Ford"]
["Honda"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Ford"]
["Toyota"]
["Ford"]

{"sheet":"Formatting","index":7,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Formatting is a Façade. It sits on top of the value or text that is entered into the cell."]
["Don't get tricked by formatting. When in doubt apply the General Format in the Number tab and see what is really in the cell."]
["Format Cells Dialog Box keyboard shortcut: Ctrl + 1."]
["These are tabs in the Format Dialog Box: Number, Alignment, Font, Borders, Fill, Protection"]
[]
["Accounting Format",null,"Percentage Format"]
[]
[]
[]
[]
["Accounting Format",null,"Percentage Format"]

{"sheet":"Percentage Calculations","index":8,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["CarTypes",null,"CarTypes","Frequency","% Frequency"]
["Toyota",null,"Ford",{"$f":"COUNTIF($A$2:$A$60,C2)","v":17}]
["Toyota",null,"Toyota",{"$f":"COUNTIF($A$2:$A$60,C3)","v":23}]
["Toyota",null,"Honda",{"$f":"COUNTIF($A$2:$A$60,C4)","v":19}]
["Honda",null,"Total"]
["Honda",null,null,null,null,null,null,"check"]
["Ford",null,"Percent that is Ford OR Toytota =",null,null,null,null,{"$f":"(COUNTIF(A2:A60,C2)+COUNTIF(A2:A60,C3))/COUNTA(A2:A60)","v":0.67796610169491522}]
["Ford",null,"<==","<=="]
["Honda",null,"Because the two categories are mutually exclusive (Each car can only fit in one category), you can just add them"]
["Honda"]
["Toyota"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Honda"]
["Toyota"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Ford"]
["Ford"]
["Ford"]
["Honda"]
["Toyota"]
["Toyota"]
["Honda"]
["Ford"]
["Toyota"]
["Toyota"]
["Honda"]
["Honda"]
["Ford"]
["Honda"]
["Ford"]
["Toyota"]
["Honda"]
["Ford"]
["Honda"]
["Honda"]
["Ford"]
["Toyota"]
["Honda"]
["Ford"]
["Honda"]
["Ford"]
["Honda"]
["Toyota"]
["Ford"]
["Toyota"]
["Honda"]
["Toyota"]
["Ford"]
["Toyota"]
["Ford"]
["Ford"]
["Ford"]

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