{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Title","Question","Central","East","South","West","Sheet6","Sheet5","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":13,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2178]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: GLady / Pixabay"]

{"sheet":"Question","index":1,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"Power Query"]
[null,null,null,null,null,null,null,null,null,null,"- Available as a free download for Excel 2010 & 2013"]
[null,null,null,null,null,null,null,null,null,null," - Built in to Excel 2016 and Office 365 (On the Data tab, under Get & Transform)"]

{"sheet":"Central","index":2,"n_rows":187,"n_cols":8,"rows_kept":187,"cut":false,"hidden":false,"merged":[]}
["Central Region Report"]
[]
["Product","Date","Sector","Customer","Quantity","Revenue","COGS","Profit"]
["ABC","2017-01-02","Transportation","Southwest Airlines",100,2257,984,1273]
["XYZ","2017-01-02","Energy","Texaco",400,9152,4088,5064]
["XYZ","2017-01-04","Retail","Wal-Mart",900,21438,9198,12240]
["ABC","2017-01-05","Manufacturing","IBM",300,6267,2541,3726]
["XYZ","2017-01-17","Energy","Texaco",400,7136,3388,3748]
["ABC","2017-01-27","Manufacturing","General Motors",300,5157,2541,2616]
["ABC","2017-02-03","Retail","Wal-Mart",500,10385,4235,6150]
["XYZ","2017-02-06","Retail","Wal-Mart",1000,23810,10220,13590]
["XYZ","2017-02-07","Retail","Wal-Mart",500,11525,5110,6415]
["XYZ","2017-02-08","Retail","Wal-Mart",1000,25140,10220,14920]
["DEF","2017-02-09","Manufacturing","Cummins Inc.",900,16209,7623,8586]
["XYZ","2017-02-15","Retail","Wal-Mart",200,4262,2044,2218]
["DEF","2017-02-20","Retail","Wal-Mart",900,19503,8856,10647]
["ABC","2017-02-27","Retail","Wal-Mart",800,16696,6776,9920]
["ABC","2017-03-03","Retail","Wal-Mart",300,5355,2541,2814]
["ABC","2017-03-06","Retail","Wal-Mart",200,3756,1694,2062]
["DEF","2017-03-08","Manufacturing","Cummins Inc.",1000,23090,10220,12870]
["DEF","2017-03-09","Communications","AT&T",900,21357,8856,12501]
["ABC","2017-03-09","Manufacturing","General Motors",300,5358,2541,2817]
["ABC","2017-03-16","Manufacturing","General Electric",300,5886,2541,3345]
["XYZ","2017-03-24","Manufacturing","General Motors",1000,20670,10220,10450]
["DEF","2017-03-24","Manufacturing","Motorola",200,4948,2044,2904]
["XYZ","2017-03-27","Retail","Wal-Mart",700,15834,7154,8680]
["XYZ","2017-03-31","Manufacturing","General Motors",1000,22530,10220,12310]
["DEF","2017-04-05","Manufacturing","Cummins Inc.",200,3802,1694,2108]
["XYZ","2017-04-05","Retail","Kroger",800,19520,7872,11648]
["ABC","2017-04-10","Energy","Exxon",500,8785,4235,4550]
["XYZ","2017-04-12","Retail","Wal-Mart",500,12625,5110,7515]
["ABC","2017-04-17","Manufacturing","HP",200,4846,2044,2802]
["DEF","2017-04-19","Communications","AT&T",500,10195,4920,5275]
["ABC","2017-04-21","Manufacturing","General Motors",600,11700,5082,6618]
["XYZ","2017-04-26","Manufacturing","General Motors",300,6660,3066,3594]
["ABC","2017-04-27","Manufacturing","General Electric",900,18918,9198,9720]
["ABC","2017-04-28","Manufacturing","General Motors",700,13986,5929,8057]
["DEF","2017-05-02","Manufacturing","IBM",1000,20480,9840,10640]
["XYZ","2017-05-03","Retail","Wal-Mart",200,4264,2044,2220]
["DEF","2017-05-04","Retail","Sears",200,4282,1968,2314]
["XYZ","2017-05-05","Manufacturing","IBM",500,12135,5110,7025]
["DEF","2017-05-08","Manufacturing","IBM",200,4286,1968,2318]
["ABC","2017-05-11","Manufacturing","General Electric",700,12838,5929,6909]
["DEF","2017-05-15","Communications","SBC Communications",1000,22140,9840,12300]
["DEF","2017-05-16","Communications","AT&T",1000,20020,9840,10180]
["ABC","2017-05-16","Manufacturing","IBM",500,10330,4235,6095]
["DEF","2017-05-18","Manufacturing","Cummins Inc.",100,2221,984,1237]
["ABC","2017-05-19","Energy","Exxon",700,13734,5929,7805]
["DEF","2017-05-22","Financial","State Farm",200,4754,1968,2786]
["DEF","2017-05-23","Energy","Exxon",100,2231,984,1247]
["ABC","2017-05-24","Manufacturing","General Electric",900,21960,9198,12762]
["DEF","2017-06-01","Retail","Sears",400,8876,4088,4788]
["DEF","2017-06-05","Manufacturing","Cummins Inc.",700,15876,7154,8722]
["DEF","2017-06-07","Manufacturing","IBM",500,11545,4920,6625]
["DEF","2017-06-09","Communications","AT&T",500,11660,4920,6740]
["ABC","2017-06-14","Manufacturing","HP",1000,17840,8470,9370]
["ABC","2017-06-16","Retail","Wal-Mart",300,5508,2541,2967]
["ABC","2017-06-20","Energy","Exxon",700,13433,5929,7504]
["ABC","2017-06-21","Financial","BankUnited",800,15288,6776,8512]
["XYZ","2017-06-21","Manufacturing","General Motors",900,19584,9198,10386]
["ABC","2017-06-22","Manufacturing","General Electric",100,2320,1022,1298]
["XYZ","2017-07-05","Retail","Kroger",100,1819,847,972]
["XYZ","2017-07-06","Communications","AT&T",200,4440,2044,2396]
["ABC","2017-07-07","Transportation","Southwest Airlines",300,6309,2541,3768]
["DEF","2017-07-12","Financial","CUNA Insurance",800,18072,8176,9896]
["ABC","2017-07-12","Retail","Wal-Mart",100,2012,847,1165]
["DEF","2017-07-14","Manufacturing","Cummins Inc.",400,7944,3388,4556]
["XYZ","2017-07-18","Transportation","Southwest Airlines",700,15680,6888,8792]
["ABC","2017-07-19","Energy","Exxon",300,5826,2541,3285]
["XYZ","2017-07-26","Manufacturing","Ford",800,16784,7872,8912]
["ABC","2017-07-27","Manufacturing","General Motors",1000,17200,8470,8730]
["DEF","2017-07-31","Communications","AT&T",500,9350,4235,5115]
["ABC","2017-08-02","Manufacturing","General Electric",900,17712,7623,10089]
["DEF","2017-08-02","Retail","Wal-Mart",1000,23080,9840,13240]
["XYZ","2017-08-04","Manufacturing","General Motors",600,12480,6132,6348]
["XYZ","2017-08-18","Energy","Exxon",500,10550,5110,5440]
["XYZ","2017-08-21","Energy","Exxon",300,6495,3066,3429]
["XYZ","2017-08-28","Energy","Exxon",900,21762,9198,12564]
["ABC","2017-08-29","Energy","Exxon",800,15976,6776,9200]
["ABC","2017-08-31","Manufacturing","General Electric",500,9475,4235,5240]
["XYZ","2017-09-01","Manufacturing","General Motors",100,2343,1022,1321]
["ABC","2017-09-11","Retail","Wal-Mart",500,8970,4235,4735]
["XYZ","2017-09-12","Communications","AT&T",900,15255,7623,7632]
["ABC","2017-09-12","Financial","BankUnited",900,21033,8856,12177]
["ABC","2017-09-19","Transportation","Southwest Airlines",900,17136,7623,9513]
["XYZ","2017-09-20","Transportation","Southwest Airlines",300,6462,2952,3510]
["XYZ","2017-09-21","Retail","Kroger",100,2538,1022,1516]
["DEF","2017-09-25","Manufacturing","General Motors",100,2004,984,1020]
["ABC","2017-09-27","Transportation","Southwest Airlines",300,5592,2541,3051]
["DEF","2017-10-02","Communications","AT&T",900,21546,8856,12690]
["ABC","2017-10-05","Manufacturing","IBM",100,2111,847,1264]
["ABC","2017-10-06","Manufacturing","P&G",400,9660,4088,5572]
["DEF","2017-10-09","Manufacturing","General Electric",600,12888,5904,6984]
["ABC","2017-10-10","Manufacturing","IBM",100,2108,847,1261]
["ABC","2017-10-11","Energy","Exxon",600,11964,5082,6882]
["ABC","2017-10-13","Energy","Exxon",900,15651,7623,8028]
["DEF","2017-10-25","Communications","AT&T",500,9460,4235,5225]
["ABC","2017-10-26","Manufacturing","General Motors",600,10290,5082,5208]
["DEF","2017-10-30","Manufacturing","General Electric",500,11240,5110,6130]
["DEF","2017-10-31","Manufacturing","General Electric",400,9204,4088,5116]
["ABC","2017-11-01","Manufacturing","IBM",400,6860,3388,3472]
["XYZ","2017-11-02","Energy","Texaco",600,13806,6132,7674]
["ABC","2017-11-03","Manufacturing","General Motors",800,16416,6776,9640]
["ABC","2017-11-03","Manufacturing","HP",900,21015,9198,11817]
["XYZ","2017-11-08","Communications","AT&T",100,1740,847,893]
["XYZ","2017-11-10","Retail","Wal-Mart",900,21888,9198,12690]
["ABC","2017-11-23","Manufacturing","General Electric",500,10445,4235,6210]
["XYZ","2017-11-27","Communications","AT&T",400,10044,4088,5956]
["ABC","2017-11-30","Energy","Exxon",700,13314,5929,7385]
["DEF","2017-12-01","Manufacturing","General Electric",200,4280,1968,2312]
["ABC","2017-12-05","Retail","Wal-Mart",400,7180,3388,3792]
["ABC","2017-12-13","Energy","Exxon",600,11124,5082,6042]
["DEF","2017-12-13","Manufacturing","General Electric",800,18504,7872,10632]
["DEF","2017-12-14","Manufacturing","Cummins Inc.",600,12282,5904,6378]
["DEF","2017-12-18","Manufacturing","Cummins Inc.",1000,22680,10220,12460]
["XYZ","2017-12-18","Manufacturing","IBM",700,17367,7154,10213]
["ABC","2017-12-19","Manufacturing","Phillip Morris",200,4614,2044,2570]
["ABC","2017-12-19","Transportation","Southwest Airlines",600,11922,5082,6840]
["DEF","2017-12-25","Manufacturing","Cummins Inc.",200,4010,1694,2316]
["XYZ","2017-12-26","Manufacturing","General Motors",500,12505,5110,7395]
["ABC","2018-01-08","Healthcare","Merck",100,2484,1022,1462]
["DEF","2018-01-09","Manufacturing","General Electric",200,4472,1968,2504]
["ABC","2018-01-10","Manufacturing","General Motors",700,11858,5929,5929]
["DEF","2018-01-15","Manufacturing","Cummins Inc.",600,13542,6132,7410]
["XYZ","2018-01-17","Communications","AT&T",600,14448,6132,8316]
["DEF","2018-01-18","Energy","Exxon",300,7233,2952,4281]
["DEF","2018-01-23","Manufacturing","Cummins Inc.",500,10460,4235,6225]
["DEF","2018-01-24","Manufacturing","Cummins Inc.",800,18344,8176,10168]
["DEF","2018-01-29","Financial","CUNA Insurance",600,14004,5904,8100]
["DEF","2018-02-06","Manufacturing","Cummins Inc.",400,7852,3388,4464]
["ABC","2018-02-07","Retail","Wal-Mart",600,12360,5082,7278]
["DEF","2018-02-08","Manufacturing","Cummins Inc.",900,18990,8856,10134]
["DEF","2018-02-15","Manufacturing","General Motors",700,15407,6888,8519]
["ABC","2018-02-16","Retail","Wal-Mart",1000,18290,8470,9820]
["ABC","2018-02-23","Financial","BankUnited",300,7245,2952,4293]
["XYZ","2018-02-26","Energy","Exxon",500,11000,5110,5890]
["DEF","2018-03-01","Manufacturing","General Electric",500,10385,5110,5275]
["XYZ","2018-03-02","Transportation","Southwest Airlines",700,14203,6888,7315]
["XYZ","2018-03-06","Energy","Exxon",100,2149,1022,1127]
["DEF","2018-03-12","Manufacturing","Cummins Inc.",800,16264,7872,8392]
["XYZ","2018-03-14","Manufacturing","Cummins Inc.",500,12550,5110,7440]
["XYZ","2018-03-16","Manufacturing","Compaq",400,9064,4088,4976]
["DEF","2018-03-21","Manufacturing","IBM",800,17944,7872,10072]
["DEF","2018-03-29","Financial","CUNA Insurance",200,4060,1968,2092]
["ABC","2018-04-02","Financial","BankUnited",800,15856,7872,7984]
["XYZ","2018-04-02","Energy","Exxon",400,8804,4088,4716]
["DEF","2018-04-09","Energy","Exxon",700,16303,6888,9415]
["DEF","2018-04-11","Manufacturing","General Motors",500,12270,4920,7350]
["ABC","2018-04-12","Retail","Wal-Mart",900,17883,7623,10260]
["XYZ","2018-04-16","Manufacturing","IBM",900,21366,9198,12168]
["XYZ","2018-04-18","Manufacturing","Cummins Inc.",800,17416,7872,9544]
["XYZ","2018-04-19","Manufacturing","IBM",200,4902,2044,2858]
["XYZ","2018-04-23","Retail","Kroger",1000,22840,10220,12620]
["DEF","2018-04-27","Retail","Wal-Mart",200,4132,1968,2164]
["XYZ","2018-04-30","Energy","Exxon",200,4722,2044,2678]
["ABC","2018-05-02","Transportation","Southwest Airlines",300,6159,2952,3207]
["XYZ","2018-05-04","Energy","Exxon",900,21159,9198,11961]
["DEF","2018-05-11","Retail","Wal-Mart",600,13368,5904,7464]
["XYZ","2018-05-14","Manufacturing","Cummins Inc.",200,4550,2044,2506]
["ABC","2018-05-16","Financial","BankUnited",700,17213,6888,10325]
["XYZ","2018-05-16","Energy","Texaco",200,4270,1968,2302]
["ABC","2018-05-18","Energy","Exxon",1000,21120,8470,12650]
["XYZ","2018-05-21","Manufacturing","Cummins Inc.",300,6156,2541,3615]
["ABC","2018-05-22","Manufacturing","General Electric",800,15544,6776,8768]
["XYZ","2018-05-25","Manufacturing","IBM",300,6438,3066,3372]
["XYZ","2018-05-28","Manufacturing","Cummins Inc.",900,19593,9198,10395]
["XYZ","2018-05-30","Energy","Exxon",800,17160,8176,8984]
["ABC","2018-06-07","Manufacturing","HP",500,11550,4920,6630]
["XYZ","2018-06-07","Transportation","Southwest Airlines",600,12936,6132,6804]
["XYZ","2018-06-14","Communications","AT&T",100,1795,847,948]
["DEF","2018-06-19","Manufacturing","General Electric",900,22014,9198,12816]
["DEF","2018-06-19","Manufacturing","General Electric",400,9672,3936,5736]
["DEF","2018-06-20","Retail","Wal-Mart",600,14004,5904,8100]
["ABC","2018-06-22","Financial","BankUnited",500,8715,4235,4480]
["ABC","2018-07-03","Manufacturing","General Electric",200,3922,1694,2228]
["ABC","2018-07-04","Financial","BankUnited",1000,23970,9840,14130]
["DEF","2018-07-05","Retail","Sears",500,8940,4235,4705]
["DEF","2018-07-10","Manufacturing","IBM",500,11530,4920,6610]
["ABC","2018-07-11","Manufacturing","Phillip Morris",800,15312,6776,8536]
["XYZ","2018-07-16","Manufacturing","Cummins Inc.",1000,21010,8470,12540]
["DEF","2018-07-18","Retail","Lowe's",500,11220,4920,6300]
["DEF","2018-07-19","Energy","Exxon",500,11250,4920,6330]
["XYZ","2018-07-24","Transportation","Southwest Airlines",100,2092,1022,1070]
["DEF","2018-07-25","Retail","Sears",600,12612,6132,6480]
["DEF","2018-07-26","Financial","CUNA Insurance",800,15104,6776,8328]
["XYZ","2018-08-03","Manufacturing","General Motors",600,13680,6132,7548]
["DEF","2018-08-06","Manufacturing","General Motors",600,13200,5904,7296]

{"sheet":"East","index":3,"n_rows":193,"n_cols":8,"rows_kept":193,"cut":false,"hidden":false,"merged":[]}
["East Region Report"]
[]
["Product","Date","Sector","Customer","Quantity","Revenue","COGS","Profit"]
["DEF","2017-01-02","Manufacturing","Cummins Inc.",1000,22810,10220,12590]
["ABC","2017-01-02","Healthcare","Merck",800,18552,7872,10680]
["ABC","2017-01-03","Manufacturing","General Motors",400,8456,3388,5068]
["DEF","2017-01-03","Financial","State Farm",1000,21730,9840,11890]
["XYZ","2017-01-06","Communications","AT&T",100,2401,1022,1379]
["ABC","2017-01-09","Financial","CitiGroup",600,11628,5082,6546]
["DEF","2017-01-11","Communications","SBC Communications",800,14440,6776,7664]
["ABC","2017-01-13","Manufacturing","IBM",600,12606,5082,7524]
["ABC","2017-01-16","Financial","CitiGroup",1000,20770,8470,12300]
["DEF","2017-01-17","Manufacturing","General Motors",700,17150,6888,10262]
["DEF","2017-01-18","Retail","Wal-Mart",300,6714,2952,3762]
["ABC","2017-01-19","Manufacturing","General Motors",800,15640,6776,8864]
["DEF","2017-01-24","Manufacturing","General Electric",900,21708,8856,12852]
["ABC","2017-01-26","Financial","CitiGroup",100,1817,847,970]
["DEF","2017-01-30","Financial","CitiGroup",700,13867,6888,6979]
["ABC","2017-02-01","Energy","Exxon",600,11430,5082,6348]
["DEF","2017-02-08","Manufacturing","Cummins Inc.",600,13206,5904,7302]
["DEF","2017-02-09","Retail","Wal-Mart",400,8708,3936,4772]
["XYZ","2017-02-10","Manufacturing","General Motors",900,21456,9198,12258]
["ABC","2017-02-21","Manufacturing","IBM",100,1819,847,972]
["XYZ","2017-02-22","Financial","CitiGroup",1000,24430,10220,14210]
["XYZ","2017-02-22","Retail","Wal-Mart",500,10935,5110,5825]
["XYZ","2017-02-24","Financial","CitiGroup",900,18783,9198,9585]
["ABC","2017-02-28","Manufacturing","General Electric",400,7132,3388,3744]
["ABC","2017-03-01","Manufacturing","General Electric",200,4784,2044,2740]
["DEF","2017-03-07","Manufacturing","General Motors",1000,20090,9840,10250]
["DEF","2017-03-13","Communications","AT&T",300,5370,2541,2829]
["ABC","2017-03-16","Financial","BankUnited",700,14686,5929,8757]
["DEF","2017-03-17","Energy","Exxon",500,12095,4920,7175]
["ABC","2017-03-22","Manufacturing","General Electric",600,11598,5082,6516]
["ABC","2017-03-23","Financial","CitiGroup",400,8016,3388,4628]
["XYZ","2017-03-24","Transportation","Southwest Airlines",1000,21880,10220,11660]
["DEF","2017-03-28","Manufacturing","Cummins Inc.",100,2457,984,1473]
["ABC","2017-03-29","Energy","Exxon",300,5439,2541,2898]
["DEF","2017-03-30","Retail","Wal-Mart",500,11435,4920,6515]
["XYZ","2017-05-26","Communications","AT&T",900,19062,9198,9864]
["DEF","2017-05-30","Energy","Exxon",900,21168,8856,12312]
["DEF","2017-06-02","Manufacturing","General Electric",900,21555,8856,12699]
["ABC","2017-06-05","Manufacturing","IBM",300,5967,2541,3426]
["ABC","2017-06-06","Financial","BankUnited",1000,25350,10220,15130]
["ABC","2017-06-08","Retail","Wal-Mart",1000,18660,8470,10190]
["DEF","2017-06-12","Manufacturing","General Motors",800,15816,7872,7944]
["XYZ","2017-06-13","Communications","Lucent",1000,23890,10220,13670]
["ABC","2017-06-14","Retail","Wal-Mart",800,13936,6776,7160]
["ABC","2017-06-15","Manufacturing","General Electric",600,12984,6132,6852]
["DEF","2017-06-16","Financial","CitiGroup",1000,21800,9840,11960]
["XYZ","2017-06-19","Energy","Exxon",400,9704,4088,5616]
["DEF","2017-06-26","Manufacturing","Cummins Inc.",300,6138,2541,3597]
["ABC","2017-06-28","Energy","Exxon",300,5904,2541,3363]
["DEF","2017-06-28","Energy","Exxon",800,16232,7872,8360]
["ABC","2017-06-29","Financial","BankUnited",900,18684,9198,9486]
["DEF","2017-06-29","Manufacturing","Cummins Inc.",100,1836,847,989]
["XYZ","2017-06-30","Communications","AT&T",600,15006,6132,8874]
["DEF","2017-07-03","Manufacturing","Cummins Inc.",100,1913,847,1066]
["XYZ","2017-07-04","Financial","CitiGroup",900,19368,9198,10170]
["XYZ","2017-07-06","Communications","AT&T",500,10990,5110,5880]
["ABC","2017-07-11","Financial","CitiGroup",800,16144,6776,9368]
["DEF","2017-07-18","Communications","AT&T",600,12756,5904,6852]
["XYZ","2017-07-20","Financial","CitiGroup",800,20008,8176,11832]
["ABC","2017-07-21","Financial","CitiGroup",300,5457,2541,2916]
["ABC","2017-07-24","Energy","Exxon",600,12330,5082,7248]
["DEF","2017-07-25","Communications","AT&T",500,11845,4920,6925]
["ABC","2017-07-28","Financial","CitiGroup",600,10602,5082,5520]
["XYZ","2017-07-31","Manufacturing","General Motors",100,2095,1022,1073]
["DEF","2017-08-07","Manufacturing","General Electric",200,4866,1968,2898]
["DEF","2017-08-08","Manufacturing","Cummins Inc.",100,1877,847,1030]
["XYZ","2017-08-10","Retail","Wal-Mart",700,15715,7154,8561]
["XYZ","2017-08-11","Financial","CitiGroup",800,18208,8176,10032]
["DEF","2017-08-11","Manufacturing","Motorola",100,2358,984,1374]
["XYZ","2017-08-14","Manufacturing","IBM",400,8560,4088,4472]
["XYZ","2017-08-17","Financial","CitiGroup",100,2517,1022,1495]
["ABC","2017-08-18","Financial","BankUnited",700,14133,5929,8204]
["ABC","2017-08-22","Financial","CitiGroup",400,7520,3388,4132]
["ABC","2017-08-23","Financial","CitiGroup",800,14136,6776,7360]
["ABC","2017-08-24","Manufacturing","General Motors",800,16008,6776,9232]
["DEF","2017-08-25","Retail","Wal-Mart",1000,23040,9840,13200]
["DEF","2017-08-30","Financial","CitiGroup",1000,20540,9840,10700]
["DEF","2017-09-04","Manufacturing","General Electric",500,10645,5110,5535]
["ABC","2017-09-05","Manufacturing","General Electric",400,8468,3388,5080]
["ABC","2017-09-06","Financial","CitiGroup",400,8196,3388,4808]
["DEF","2017-09-07","Financial","CitiGroup",500,11295,4920,6375]
["DEF","2017-09-08","Manufacturing","General Electric",600,14466,5904,8562]
["DEF","2017-09-15","Communications","SBC Communications",1000,24420,10220,14200]
["DEF","2017-09-18","Financial","CitiGroup",300,7053,2952,4101]
["DEF","2017-09-19","Financial","CitiGroup",100,2410,984,1426]
["DEF","2017-09-19","Financial","CitiGroup",400,8204,3936,4268]
["DEF","2017-09-22","Financial","CitiGroup",400,8464,3936,4528]
["DEF","2017-09-25","Manufacturing","General Electric",500,9890,4920,4970]
["ABC","2017-10-03","Manufacturing","Phillip Morris",500,10760,4920,5840]
["ABC","2017-10-03","Retail","Wal-Mart",900,18243,7623,10620]
["XYZ","2017-10-12","Manufacturing","IBM",300,6732,3066,3666]
["ABC","2017-10-16","Financial","BankUnited",600,11274,5082,6192]
["ABC","2017-10-19","Manufacturing","IBM",500,8725,4235,4490]
["ABC","2017-10-23","Transportation","Southwest Airlines",100,2055,847,1208]
["XYZ","2017-10-24","Energy","Exxon",600,14178,6132,8046]
["ABC","2017-10-27","Transportation","Southwest Airlines",500,10245,4235,6010]
["DEF","2017-11-06","Manufacturing","General Electric",900,21465,9198,12267]
["ABC","2017-11-09","Transportation","Southwest Airlines",500,9345,4235,5110]
["DEF","2017-11-13","Energy","Exxon",300,5961,2952,3009]
["ABC","2017-11-14","Financial","CitiGroup",900,17505,7623,9882]
["ABC","2017-11-17","Energy","Exxon",400,8164,3388,4776]
["DEF","2017-11-21","Energy","Exxon",300,6240,2952,3288]
["ABC","2017-11-22","Manufacturing","IBM",400,8128,3388,4740]
["ABC","2017-11-24","Retail","Wal-Mart",800,14224,6776,7448]
["ABC","2017-11-28","Financial","CitiGroup",1000,19250,8470,10780]
["DEF","2017-11-29","Energy","Exxon",200,4740,1968,2772]
["DEF","2017-11-29","Manufacturing","General Motors",600,12672,5904,6768]
["ABC","2017-12-04","Transportation","Southwest Airlines",300,6045,2541,3504]
["DEF","2017-12-06","Financial","CitiGroup",600,12798,5904,6894]
["ABC","2017-12-07","Retail","Wal-Mart",100,2066,847,1219]
["DEF","2017-12-08","Manufacturing","Cummins Inc.",200,4742,1968,2774]
["ABC","2017-12-13","Financial","BankUnited",400,7152,3388,3764]
["DEF","2017-12-15","Manufacturing","General Electric",1000,20940,10220,10720]
["XYZ","2017-12-20","Transportation","Southwest Airlines",1000,20490,10220,10270]
["DEF","2017-12-21","Manufacturing","General Electric",400,8620,4088,4532]
["DEF","2017-12-22","Manufacturing","IBM",500,11860,4920,6940]
["ABC","2017-12-25","Financial","BankUnited",800,14984,6776,8208]
["DEF","2017-12-29","Manufacturing","Cummins Inc.",200,4526,1968,2558]
["DEF","2018-01-01","Manufacturing","IBM",500,11695,4920,6775]
["DEF","2018-01-02","Energy","Exxon",100,2272,984,1288]
["DEF","2018-01-05","Financial","CitiGroup",800,15856,7872,7984]
["DEF","2018-01-12","Retail","Wal-Mart",800,17240,7872,9368]
["XYZ","2018-01-19","Manufacturing","General Motors",700,15435,7154,8281]
["ABC","2018-01-22","Financial","CitiGroup",500,9575,4235,5340]
["DEF","2018-01-22","Energy","Exxon",400,8632,3936,4696]
["DEF","2018-01-22","Energy","Exxon",300,6588,2952,3636]
["ABC","2018-01-24","Manufacturing","General Motors",400,8132,3388,4744]
["XYZ","2018-01-25","Manufacturing","IBM",900,19539,9198,10341]
["DEF","2018-01-26","Retail","Wal-Mart",900,20403,8856,11547]
["ABC","2018-01-31","Manufacturing","General Motors",900,17172,7623,9549]
["XYZ","2018-02-09","Manufacturing","Ford",800,18264,8176,10088]
["DEF","2018-02-12","Communications","AT&T",1000,20310,8470,11840]
["XYZ","2018-02-16","Communications","AT&T",800,15592,6776,8816]
["XYZ","2018-02-19","Communications","AT&T",100,1842,847,995]
["XYZ","2018-02-19","Financial","CitiGroup",500,10400,5110,5290]
["DEF","2018-02-20","Manufacturing","Cummins Inc.",100,1982,847,1135]
["XYZ","2018-02-22","Financial","CitiGroup",300,6789,3066,3723]
["DEF","2018-02-22","Manufacturing","IBM",700,16765,6888,9877]
["DEF","2018-02-27","Manufacturing","General Motors",400,9760,3936,5824]
["DEF","2018-02-27","Retail","Wal-Mart",700,16772,6888,9884]
["DEF","2018-02-28","Manufacturing","Cummins Inc.",400,9156,4088,5068]
["XYZ","2018-03-05","Financial","CitiGroup",600,14634,6132,8502]
["DEF","2018-03-07","Manufacturing","Cummins Inc.",200,4474,1968,2506]
["DEF","2018-03-07","Manufacturing","Cummins Inc.",100,2487,1022,1465]
["ABC","2018-03-12","Manufacturing","General Motors",200,3632,1694,1938]
["XYZ","2018-03-13","Manufacturing","IBM",700,14469,7154,7315]
["DEF","2018-03-14","Manufacturing","General Motors",700,16408,6888,9520]
["ABC","2018-03-19","Financial","CitiGroup",900,18072,7623,10449]
["DEF","2018-03-20","Communications","AT&T",800,16288,6776,9512]
["DEF","2018-03-22","Retail","Wal-Mart",300,6477,2952,3525]
["ABC","2018-03-27","Manufacturing","General Electric",700,13874,5929,7945]
["XYZ","2018-03-28","Transportation","Southwest Airlines",700,15988,7154,8834]
["XYZ","2018-04-03","Energy","Exxon",500,12425,5110,7315]
["XYZ","2018-04-04","Transportation","Southwest Airlines",100,2054,984,1070]
["XYZ","2018-04-05","Manufacturing","IBM",400,9816,4088,5728]
["XYZ","2018-04-06","Communications","AT&T",200,4192,1694,2498]
["XYZ","2018-04-10","Retail","Wal-Mart",400,8580,4088,4492]
["DEF","2018-04-13","Manufacturing","IBM",500,11725,4920,6805]
["XYZ","2018-04-17","Communications","Lucent",700,14497,6888,7609]
["XYZ","2018-04-19","Manufacturing","Cummins Inc.",700,13804,5929,7875]
["DEF","2018-04-20","Retail","Wal-Mart",500,11235,4920,6315]
["ABC","2018-04-25","Transportation","Southwest Airlines",300,6228,2952,3276]
["XYZ","2018-04-26","Manufacturing","Cummins Inc.",600,13332,5904,7428]
["DEF","2018-05-01","Manufacturing","General Motors",700,16170,6888,9282]
["XYZ","2018-05-07","Manufacturing","Cummins Inc.",100,2547,1022,1525]
["XYZ","2018-05-10","Manufacturing","Compaq",200,4380,1968,2412]
["DEF","2018-05-23","Financial","CitiGroup",900,19989,8856,11133]
["ABC","2018-05-25","Financial","BankUnited",600,12570,6132,6438]
["ABC","2018-05-30","Manufacturing","IBM",100,2028,847,1181]
["XYZ","2018-05-31","Manufacturing","Ford",300,5532,2541,2991]
["DEF","2018-06-04","Manufacturing","General Motors",900,18486,8856,9630]
["ABC","2018-06-05","Energy","Exxon",900,17289,7623,9666]
["DEF","2018-06-05","Manufacturing","General Motors",100,2106,984,1122]
["DEF","2018-06-06","Retail","Lowe's",100,2029,984,1045]
["ABC","2018-06-08","Financial","BankUnited",600,14580,5904,8676]
["XYZ","2018-06-11","Financial","CitiGroup",100,2058,1022,1036]
["XYZ","2018-06-11","Manufacturing","Cummins Inc.",600,13566,5904,7662]
["DEF","2018-06-15","Manufacturing","IBM",400,8592,3936,4656]
["DEF","2018-06-18","Communications","AT&T",600,12690,5904,6786]
["XYZ","2018-08-17","Transportation","Southwest Airlines",600,13290,6132,7158]
["XYZ","2018-08-20","Financial","CitiGroup",400,8284,4088,4196]
["XYZ","2018-08-22","Financial","CitiGroup",100,2309,1022,1287]
["ABC","2018-08-23","Financial","BankUnited",900,18756,9198,9558]
["DEF","2018-08-27","Manufacturing","General Electric",200,4696,1968,2728]
["ABC","2018-08-28","Transportation","Southwest Airlines",500,10295,4920,5375]
["XYZ","2018-08-29","Financial","CitiGroup",1000,25010,10220,14790]
["XYZ","2018-08-29","Manufacturing","Cummins Inc.",500,10380,5110,5270]
["XYZ","2018-08-30","Energy","Exxon",900,20664,9198,11466]
["XYZ","2018-08-30","Manufacturing","IBM",300,6744,3066,3678]
["ABC","2018-09-12","Financial","BankUnited",700,15225,7154,8071]

{"sheet":"South","index":4,"n_rows":81,"n_cols":8,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["South Region Report"]
[]
["Product","Date","Sector","Customer","Quantity","Revenue","Profit","COGS"]
["XYZ","2018-08-13","Manufacturing","General Motors",500,11470,6360,5110]
["DEF","2018-08-17","Energy","Exxon",1000,20840,11000,9840]
["DEF","2018-08-24","Manufacturing","General Motors",200,4492,2524,1968]
["ABC","2018-08-24","Manufacturing","General Motors",1000,17410,8940,8470]
["XYZ","2018-08-31","Manufacturing","Cummins Inc.",700,13552,7623,5929]
["ABC","2018-09-04","Energy","Exxon",300,5847,3306,2541]
["XYZ","2018-09-06","Energy","Exxon",700,17199,10045,7154]
["ABC","2018-09-07","Manufacturing","IBM",100,1968,1121,847]
["XYZ","2018-09-10","Retail","Wal-Mart",200,4690,2646,2044]
["ABC","2018-09-12","Manufacturing","General Electric",100,1861,1014,847]
["ABC","2018-09-13","Manufacturing","General Motors",900,15363,7740,7623]
["DEF","2017-04-03","Manufacturing","Cummins Inc.",1000,25060,14840,10220]
["XYZ","2017-04-04","Communications","AT&T",200,4124,2080,2044]
["DEF","2017-04-07","Communications","AT&T",600,12318,7236,5082]
["ABC","2017-04-11","Financial","BankUnited",500,9155,4920,4235]
["ABC","2017-04-12","Manufacturing","General Electric",500,9380,5145,4235]
["ABC","2017-04-14","Manufacturing","P&G",900,17757,8901,8856]
["ABC","2017-04-18","Manufacturing","General Electric",600,11208,6126,5082]
["ABC","2017-04-20","Transportation","Southwest Airlines",200,4012,2318,1694]
["DEF","2017-04-21","Energy","Exxon",100,2319,1335,984]
["DEF","2017-04-24","Energy","Exxon",600,12048,6144,5904]
["XYZ","2017-04-26","Retail","Wal-Mart",800,19152,10976,8176]
["ABC","2017-05-01","Financial","BankUnited",1000,23990,13770,10220]
["XYZ","2017-05-02","Financial","CitiGroup",1000,22020,11800,10220]
["XYZ","2017-05-09","Transportation","Southwest Airlines",500,10650,5540,5110]
["ABC","2017-05-10","Transportation","Southwest Airlines",1000,19630,11160,8470]
["XYZ","2017-05-25","Communications","Lucent",300,7167,4101,3066]
["XYZ","2017-05-25","Retail","Wal-Mart",900,22716,13518,9198]
["ABC","2018-06-21","Retail","Wal-Mart",700,13139,7210,5929]
["ABC","2018-06-25","Financial","CitiGroup",900,15759,8136,7623]
["ABC","2018-06-26","Financial","CitiGroup",400,6944,3556,3388]
["DEF","2018-06-29","Manufacturing","General Motors",200,4186,2218,1968]
["ABC","2018-07-02","Transportation","Southwest Airlines",700,13195,7266,5929]
["XYZ","2018-07-09","Communications","Lucent",1000,17190,8720,8470]
["XYZ","2018-07-10","Communications","AT&T",900,21042,11844,9198]
["XYZ","2018-07-12","Transportation","Southwest Airlines",900,19161,9963,9198]
["XYZ","2018-07-13","Financial","CitiGroup",500,10940,5830,5110]
["ABC","2018-07-17","Financial","BankUnited",900,18576,10953,7623]
["DEF","2018-07-17","Financial","CitiGroup",200,4484,2516,1968]
["DEF","2018-07-17","Manufacturing","General Electric",700,13797,6909,6888]
["ABC","2018-07-18","Financial","CitiGroup",700,12131,6202,5929]
["DEF","2018-07-20","Financial","CitiGroup",500,11430,6510,4920]
["XYZ","2018-07-23","Manufacturing","General Motors",100,2234,1212,1022]
["XYZ","2018-07-24","Energy","Exxon",600,13818,7686,6132]
["XYZ","2018-07-30","Manufacturing","General Motors",700,17059,9905,7154]
["DEF","2018-07-31","Financial","CitiGroup",800,19424,11552,7872]
["DEF","2018-07-31","Retail","Wal-Mart",700,14784,7896,6888]
["XYZ","2018-08-02","Manufacturing","Cummins Inc.",900,19674,10818,8856]
["DEF","2018-08-07","Financial","CitiGroup",800,17136,9264,7872]
["DEF","2018-08-10","Financial","CitiGroup",400,9484,5548,3936]
["DEF","2018-08-14","Communications","AT&T",600,14154,8250,5904]
["DEF","2018-08-15","Retail","Wal-Mart",800,19280,11408,7872]
["DEF","2017-10-17","Manufacturing","Cummins Inc.",800,14408,7632,6776]
["XYZ","2017-10-18","Manufacturing","IBM",100,2213,1191,1022]
["XYZ","2017-10-20","Transportation","Southwest Airlines",900,18666,9468,9198]
["DEF","2017-10-23","Manufacturing","General Electric",500,10475,5555,4920]
["DEF","2017-11-07","Manufacturing","General Electric",400,9144,5056,4088]
["ABC","2017-11-08","Retail","Wal-Mart",1000,19110,10640,8470]
["DEF","2017-11-15","Energy","Exxon",300,7032,4080,2952]
["DEF","2017-11-16","Energy","Exxon",300,6735,3783,2952]
["ABC","2017-11-20","Retail","Wal-Mart",300,6207,3666,2541]
["ABC","2017-12-11","Manufacturing","General Motors",200,3876,2182,1694]
["XYZ","2017-12-12","Manufacturing","General Motors",1000,25080,14860,10220]
["DEF","2017-12-12","Manufacturing","IBM",400,9088,5152,3936]
["ABC","2017-12-18","Manufacturing","General Motors",700,12145,6216,5929]
["XYZ","2018-09-03","Retail","Wal-Mart",800,18560,10384,8176]
["XYZ","2018-09-05","Communications","AT&T",800,18304,10128,8176]
["DEF","2018-09-11","Communications","SBC Communications",500,11680,6570,5110]
["DEF","2018-09-11","Retail","Wal-Mart",700,14560,7672,6888]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100]

{"sheet":"West","index":5,"n_rows":123,"n_cols":9,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
["West Region Report"]
[]
["Product","Date","Sector","Customer","Quantity","Revenue","COGS","Profit","GP%"]
["ABC","2017-01-10","Transportation","Southwest Airlines",100,2042,984,1058,{"$f":"+H4/F4","v":0.51811949069539665}]
["ABC","2017-01-11","Healthcare","Merck",200,3552,1694,1858,{"$f":"+H5/F5","v":0.5230855855855856}]
["ABC","2017-01-12","Manufacturing","General Motors",800,14592,6776,7816,0.53563596491228072]
["ABC","2017-01-20","Retail","Wal-Mart",300,5532,2541,2991,0.54067245119305862]
["ABC","2017-01-23","Transportation","Southwest Airlines",800,17160,7872,9288,0.54125874125874129]
["ABC","2017-01-25","Manufacturing","IBM",1000,19890,8470,11420,0.57415786827551529]
["ABC","2017-01-31","Manufacturing","Boeing",800,16936,8176,8760,0.51724137931034486]
["ABC","2017-02-02","Retail","Wal-Mart",1000,20250,8470,11780,0.58172839506172835]
["DEF","2017-02-06","Manufacturing","Cummins Inc.",300,5700,2541,3159,0.55421052631578949]
["DEF","2017-02-08","Retail","ABC Stores",900,20610,8856,11754,0.57030567685589517]
["XYZ","2017-02-13","Retail","Wal-Mart",500,10445,5110,5335,0.5107707036859741]
["DEF","2017-02-14","Manufacturing","General Electric",600,14472,5904,8568,0.59203980099502485]
["ABC","2017-02-16","Manufacturing","P&G",700,12474,5929,6545,0.52469135802469136]
["ABC","2017-02-17","Energy","Exxon",500,10155,4235,5920,0.58296405711472177]
["DEF","2017-02-23","Retail","ABC Stores",400,8116,3388,4728,0.58255298176441594]
["XYZ","2017-03-02","Communications","AT&T",300,6765,3066,3699,0.54678492239467846]
["DEF","2017-03-10","Manufacturing","General Electric",800,16016,7872,8144,0.50849150849150848]
["ABC","2017-03-14","Manufacturing","P&G",800,20408,8176,12232,0.59937279498235985]
["XYZ","2017-03-15","Transportation","Southwest Airlines",100,2466,1022,1444,0.58556366585563668]
["DEF","2017-03-20","Manufacturing","General Electric",400,8776,3936,4840,0.55150410209662715]
["ABC","2017-03-21","Manufacturing","General Electric",300,6063,2541,3522,0.58090054428500737]
["ABC","2017-04-06","Financial","BankUnited",800,19288,8176,11112,0.5761094981335545]
["ABC","2017-04-07","Financial","BankUnited",400,8052,3936,4116,0.51117734724292097]
["ABC","2017-04-13","Financial","BankUnited",300,6156,2952,3204,0.52046783625730997]
["ABC","2017-04-25","Energy","Exxon",900,17964,7623,10341,0.57565130260521047]
["XYZ","2017-04-26","Communications","AT&T",700,13412,5929,7483,0.5579331941544885]
["DEF","2017-05-12","Manufacturing","Cummins Inc.",200,3856,1694,2162,0.56068464730290457]
["ABC","2017-05-17","Energy","Exxon",100,1882,847,1035,0.54994686503719448]
["XYZ","2017-05-29","Manufacturing","General Motors",300,7593,3066,4527,0.59620703279336229]
["ABC","2017-05-31","Manufacturing","Boeing",1000,24130,10220,13910,0.57646083713220053]
["DEF","2017-06-07","Retail","Lowe's",200,4158,1694,2464,0.59259259259259256]
["DEF","2017-06-23","Communications","AT&T",800,16936,7872,9064,0.53519130845536134]
["DEF","2017-06-26","Manufacturing","IBM",600,12030,5904,6126,0.50922693266832919]
["ABC","2017-06-27","Financial","BankUnited",400,9384,4088,5296,0.56436487638533672]
["ABC","2017-07-03","Manufacturing","General Electric",400,8744,4088,4656,0.53247941445562674]
["DEF","2017-07-03","Manufacturing","Motorola",800,17856,8176,9680,0.54211469534050183]
["ABC","2017-07-10","Financial","BankUnited",800,18904,7872,11032,0.5835801946677952]
["DEF","2017-07-13","Manufacturing","Cummins Inc.",500,10295,4235,6060,0.5886352598348713]
["ABC","2017-07-17","Manufacturing","IBM",100,1957,847,1110,0.56719468574348497]
["DEF","2017-08-01","Manufacturing","General Motors",600,13728,5904,7824,0.56993006993006989]
["ABC","2017-08-03","Retail","Wal-Mart",800,13552,6776,6776,0.5]
["XYZ","2017-08-09","Manufacturing","Ford",800,16936,8176,8760,0.51724137931034486]
["DEF","2017-08-15","Manufacturing","IBM",1000,20190,9840,10350,0.51263001485884097]
["DEF","2017-08-16","Retail","ABC Stores",300,7032,3066,3966,0.56399317406143346]
["XYZ","2017-08-23","Communications","AT&T",900,21834,9198,12636,0.5787304204451772]
["DEF","2017-08-28","Energy","Exxon",500,10955,4920,6035,0.55089000456412596]
["XYZ","2017-09-08","Transportation","Southwest Airlines",800,19376,8176,11200,0.5780346820809249]
["XYZ","2017-09-13","Manufacturing","Compaq",1000,17250,8470,8780,0.50898550724637681]
["ABC","2017-09-14","Retail","Wal-Mart",400,6880,3388,3492,0.50755813953488371]
["ABC","2017-09-15","Manufacturing","General Electric",200,3672,1694,1978,0.53867102396514166]
["XYZ","2017-09-20","Manufacturing","Compaq",400,8556,4088,4468,0.52220663861617578]
["DEF","2017-09-26","Manufacturing","General Electric",300,7569,3066,4503,0.5949266745937376]
["DEF","2017-09-28","Manufacturing","IBM",200,3942,1968,1974,0.50076103500761038]
["ABC","2017-09-29","Manufacturing","Phillip Morris",800,19344,7872,11472,0.59305210918114148]
["DEF","2017-10-04","Manufacturing","Cummins Inc.",800,16856,6776,10080,0.59800664451827246]
["ABC","2017-10-05","Energy","Exxon",700,14105,5929,8176,0.57965260545905706]
["ABC","2017-10-09","Energy","Exxon",100,1878,847,1031,0.54898828541001066]
["ABC","2017-12-27","Manufacturing","General Motors",100,1704,847,857,0.5029342723004695]
["XYZ","2017-12-27","Manufacturing","IBM",300,7305,3066,4239,0.58028747433264882]
["XYZ","2017-12-28","Manufacturing","IBM",500,11965,5110,6855,0.57292101964061848]
["ABC","2017-12-29","Financial","BankUnited",400,9240,4088,5152,0.55757575757575761]
["DEF","2018-01-03","Manufacturing","Cummins Inc.",100,2157,984,1173,0.54381084840055638]
["XYZ","2018-01-04","Transportation","Southwest Airlines",400,8732,4088,4644,0.53183692166743013]
["DEF","2018-01-08","Retail","Wal-Mart",1000,23820,9840,13980,0.58690176322418131]
["ABC","2018-01-11","Manufacturing","General Motors",500,9855,4235,5620,0.57026889903602229]
["DEF","2018-01-16","Manufacturing","Motorola",300,5859,2541,3318,{"$f":"+H69/F69","v":0.56630824372759858}]
["DEF","2018-01-19","Manufacturing","Cummins Inc.",400,7752,3388,4364,0.56295149638802888]
["XYZ","2018-01-22","Energy","Exxon",100,2178,1022,1156,0.53076216712580349]
["DEF","2018-01-30","Manufacturing","Cummins Inc.",800,14216,6776,7440,0.52335396736072026]
["ABC","2018-02-01","Retail","Wal-Mart",400,7376,3388,3988,0.54067245119305862]
["ABC","2018-02-02","Healthcare","Merck",800,17728,8176,9552,0.53880866425992779]
["ABC","2018-02-05","Manufacturing","Boeing",1000,20950,9840,11110,0.53031026252983293]
["ABC","2018-02-08","Manufacturing","General Electric",300,6069,2541,3528,0.58131487889273359]
["DEF","2018-02-12","Communications","AT&T",300,6018,2952,3066,0.50947158524426717]
["XYZ","2018-02-13","Communications","AT&T",1000,25310,10220,15090,0.59620703279336229]
["XYZ","2018-02-14","Transportation","Southwest Airlines",200,4378,1968,2410,0.55047967108268614]
["ABC","2018-02-16","Financial","BankUnited",300,6867,3066,3801,0.55351681957186549]
["DEF","2018-02-21","Retail","Wal-Mart",800,17544,7872,9672,0.55129958960328318]
["ABC","2018-02-28","Manufacturing","Boeing",500,9635,4235,5400,0.56045666839647124]
["ABC","2018-03-06","Financial","State Farm",700,13853,5929,7924,0.57200606366851947]
["XYZ","2018-03-08","Energy","Exxon",200,4388,2044,2344,0.53418413855970825]
["ABC","2018-03-08","Manufacturing","General Motors",700,12803,5929,6874,0.53690541279387638]
["ABC","2018-03-09","Manufacturing","General Electric",300,5094,2541,2553,0.50117785630153122]
["DEF","2018-03-15","Communications","AT&T",800,17056,7872,9184,0.53846153846153844]
["ABC","2018-03-23","Energy","Exxon",600,10404,5082,5322,0.51153402537485582]
["ABC","2018-03-26","Manufacturing","IBM",500,8780,4235,4545,0.51765375854214124]
["XYZ","2018-03-30","Manufacturing","Cummins Inc.",700,16219,6888,9331,0.57531290461804052]
["ABC","2018-03-30","Manufacturing","General Electric",800,15400,6776,8624,0.56000000000000005]
["DEF","2018-04-06","Retail","Wal-Mart",900,18099,8856,9243,0.51069119840875188]
["ABC","2018-04-23","Manufacturing","General Motors",600,12684,5082,7602,0.59933774834437081]
["ABC","2018-04-24","Energy","Exxon",200,3390,1694,1696,0.50029498525073746]
["XYZ","2018-05-01","Transportation","Southwest Airlines",600,13866,5904,7962,0.57421029857204675]
["DEF","2018-05-02","Retail","ABC Stores",1000,18290,8470,9820,0.53690541279387638]
["ABC","2018-05-03","Energy","Exxon",1000,18500,8470,10030,0.54216216216216218]
["DEF","2018-05-07","Communications","AT&T",800,15488,6776,8712,0.5625]
["DEF","2018-05-08","Retail","Lowe's",600,13962,6132,7830,0.56080790717662221]
["ABC","2018-05-08","Retail","Wal-Mart",200,3418,1694,1724,0.50438853130485661]
["ABC","2018-05-09","Manufacturing","General Motors",1000,19530,8470,11060,0.56630824372759858]
["DEF","2018-05-15","Communications","AT&T",300,6522,2952,3570,0.54737810487580496]
["XYZ","2018-05-17","Manufacturing","Cummins Inc.",500,12755,5110,7645,0.59937279498235985]
["DEF","2018-05-18","Manufacturing","General Motors",200,4470,1968,2502,0.55973154362416111]
["XYZ","2018-05-24","Manufacturing","Cummins Inc.",100,2409,984,1425,0.59153175591531759]
["ABC","2018-05-29","Transportation","Southwest Airlines",900,18981,7623,11358,0.59838786154575629]
["ABC","2018-05-30","Retail","Wal-Mart",300,5859,2541,3318,0.56630824372759858]
["XYZ","2018-06-01","Manufacturing","Cummins Inc.",500,12575,5110,7465,0.59363817097415505]
["ABC","2018-06-12","Manufacturing","General Electric",100,1741,847,894,0.51349798966111426]
["XYZ","2018-06-13","Energy","Exxon",200,5002,2044,2958,0.59136345461815276]
["DEF","2018-06-18","Manufacturing","IBM",300,6582,2952,3630,0.55150410209662715]
["ABC","2018-06-20","Energy","Exxon",1000,18530,8470,10060,0.54290339989206693]
["XYZ","2018-06-27","Retail","Wal-Mart",500,12760,5110,7650,0.59952978056426331]
["XYZ","2018-06-28","Retail","Wal-Mart",1000,24070,10220,13850,0.57540506855006235]
["XYZ","2018-07-06","Energy","Exxon",200,5002,2044,2958,0.59136345461815276]
["XYZ","2018-07-27","Energy","Exxon",700,16576,7154,9422,0.56841216216216217]
["XYZ","2018-08-01","Manufacturing","Cummins Inc.",1000,21740,9840,11900,0.54737810487580496]
["DEF","2018-08-08","Manufacturing","General Motors",500,11330,4920,6410,0.56575463371579882]
["DEF","2018-08-09","Energy","Exxon",200,4412,1968,2444,0.55394378966455127]
["XYZ","2018-08-16","Manufacturing","General Motors",900,22887,9198,13689,0.59811246559182063]
["XYZ","2018-08-20","Manufacturing","Cummins Inc.",800,17496,8176,9320,0.53269318701417467]
["ABC","2018-08-20","Financial","State Farm",800,19544,8176,11368,0.58166189111747846]
["DEF","2018-08-21","Manufacturing","General Motors",1000,23690,9840,13850,0.58463486703250311]

{"sheet":"Sheet6","index":6,"n_rows":573,"n_cols":10,"rows_kept":573,"cut":false,"hidden":false,"merged":[]}
["Product","Date","Sector","Customer","Quantity","Revenue","COGS","Profit","Region","GP%"]
["ABC","2017-01-02","Transportation","Southwest Airlines",100,2257,984,1273,"Central"]
["XYZ","2017-01-02","Energy","Texaco",400,9152,4088,5064,"Central"]
["XYZ","2017-01-04","Retail","Wal-Mart",900,21438,9198,12240,"Central"]
["ABC","2017-01-05","Manufacturing","IBM",300,6267,2541,3726,"Central"]
["XYZ","2017-01-17","Energy","Texaco",400,7136,3388,3748,"Central"]
["ABC","2017-01-27","Manufacturing","General Motors",300,5157,2541,2616,"Central"]
["ABC","2017-02-03","Retail","Wal-Mart",500,10385,4235,6150,"Central"]
["XYZ","2017-02-06","Retail","Wal-Mart",1000,23810,10220,13590,"Central"]
["XYZ","2017-02-07","Retail","Wal-Mart",500,11525,5110,6415,"Central"]
["XYZ","2017-02-08","Retail","Wal-Mart",1000,25140,10220,14920,"Central"]
["DEF","2017-02-09","Manufacturing","Cummins Inc.",900,16209,7623,8586,"Central"]
["XYZ","2017-02-15","Retail","Wal-Mart",200,4262,2044,2218,"Central"]
["DEF","2017-02-20","Retail","Wal-Mart",900,19503,8856,10647,"Central"]
["ABC","2017-02-27","Retail","Wal-Mart",800,16696,6776,9920,"Central"]
["ABC","2017-03-03","Retail","Wal-Mart",300,5355,2541,2814,"Central"]
["ABC","2017-03-06","Retail","Wal-Mart",200,3756,1694,2062,"Central"]
["DEF","2017-03-08","Manufacturing","Cummins Inc.",1000,23090,10220,12870,"Central"]
["DEF","2017-03-09","Communications","AT&T",900,21357,8856,12501,"Central"]
["ABC","2017-03-09","Manufacturing","General Motors",300,5358,2541,2817,"Central"]
["ABC","2017-03-16","Manufacturing","General Electric",300,5886,2541,3345,"Central"]
["XYZ","2017-03-24","Manufacturing","General Motors",1000,20670,10220,10450,"Central"]
["DEF","2017-03-24","Manufacturing","Motorola",200,4948,2044,2904,"Central"]
["XYZ","2017-03-27","Retail","Wal-Mart",700,15834,7154,8680,"Central"]
["XYZ","2017-03-31","Manufacturing","General Motors",1000,22530,10220,12310,"Central"]
["DEF","2017-04-05","Manufacturing","Cummins Inc.",200,3802,1694,2108,"Central"]
["XYZ","2017-04-05","Retail","Kroger",800,19520,7872,11648,"Central"]
["ABC","2017-04-10","Energy","Exxon",500,8785,4235,4550,"Central"]
["XYZ","2017-04-12","Retail","Wal-Mart",500,12625,5110,7515,"Central"]
["ABC","2017-04-17","Manufacturing","HP",200,4846,2044,2802,"Central"]
["DEF","2017-04-19","Communications","AT&T",500,10195,4920,5275,"Central"]
["ABC","2017-04-21","Manufacturing","General Motors",600,11700,5082,6618,"Central"]
["XYZ","2017-04-26","Manufacturing","General Motors",300,6660,3066,3594,"Central"]
["ABC","2017-04-27","Manufacturing","General Electric",900,18918,9198,9720,"Central"]
["ABC","2017-04-28","Manufacturing","General Motors",700,13986,5929,8057,"Central"]
["DEF","2017-05-02","Manufacturing","IBM",1000,20480,9840,10640,"Central"]
["XYZ","2017-05-03","Retail","Wal-Mart",200,4264,2044,2220,"Central"]
["DEF","2017-05-04","Retail","Sears",200,4282,1968,2314,"Central"]
["XYZ","2017-05-05","Manufacturing","IBM",500,12135,5110,7025,"Central"]
["DEF","2017-05-08","Manufacturing","IBM",200,4286,1968,2318,"Central"]
["ABC","2017-05-11","Manufacturing","General Electric",700,12838,5929,6909,"Central"]
["DEF","2017-05-15","Communications","SBC Communications",1000,22140,9840,12300,"Central"]
["DEF","2017-05-16","Communications","AT&T",1000,20020,9840,10180,"Central"]
["ABC","2017-05-16","Manufacturing","IBM",500,10330,4235,6095,"Central"]
["DEF","2017-05-18","Manufacturing","Cummins Inc.",100,2221,984,1237,"Central"]
["ABC","2017-05-19","Energy","Exxon",700,13734,5929,7805,"Central"]
["DEF","2017-05-22","Financial","State Farm",200,4754,1968,2786,"Central"]
["DEF","2017-05-23","Energy","Exxon",100,2231,984,1247,"Central"]
["ABC","2017-05-24","Manufacturing","General Electric",900,21960,9198,12762,"Central"]
["DEF","2017-06-01","Retail","Sears",400,8876,4088,4788,"Central"]
["DEF","2017-06-05","Manufacturing","Cummins Inc.",700,15876,7154,8722,"Central"]
["DEF","2017-06-07","Manufacturing","IBM",500,11545,4920,6625,"Central"]
["DEF","2017-06-09","Communications","AT&T",500,11660,4920,6740,"Central"]
["ABC","2017-06-14","Manufacturing","HP",1000,17840,8470,9370,"Central"]
["ABC","2017-06-16","Retail","Wal-Mart",300,5508,2541,2967,"Central"]
["ABC","2017-06-20","Energy","Exxon",700,13433,5929,7504,"Central"]
["ABC","2017-06-21","Financial","BankUnited",800,15288,6776,8512,"Central"]
["XYZ","2017-06-21","Manufacturing","General Motors",900,19584,9198,10386,"Central"]
["ABC","2017-06-22","Manufacturing","General Electric",100,2320,1022,1298,"Central"]
["XYZ","2017-07-05","Retail","Kroger",100,1819,847,972,"Central"]
["XYZ","2017-07-06","Communications","AT&T",200,4440,2044,2396,"Central"]
["ABC","2017-07-07","Transportation","Southwest Airlines",300,6309,2541,3768,"Central"]
["DEF","2017-07-12","Financial","CUNA Insurance",800,18072,8176,9896,"Central"]
["ABC","2017-07-12","Retail","Wal-Mart",100,2012,847,1165,"Central"]
["DEF","2017-07-14","Manufacturing","Cummins Inc.",400,7944,3388,4556,"Central"]
["XYZ","2017-07-18","Transportation","Southwest Airlines",700,15680,6888,8792,"Central"]
["ABC","2017-07-19","Energy","Exxon",300,5826,2541,3285,"Central"]
["XYZ","2017-07-26","Manufacturing","Ford",800,16784,7872,8912,"Central"]
["ABC","2017-07-27","Manufacturing","General Motors",1000,17200,8470,8730,"Central"]
["DEF","2017-07-31","Communications","AT&T",500,9350,4235,5115,"Central"]
["ABC","2017-08-02","Manufacturing","General Electric",900,17712,7623,10089,"Central"]
["DEF","2017-08-02","Retail","Wal-Mart",1000,23080,9840,13240,"Central"]
["XYZ","2017-08-04","Manufacturing","General Motors",600,12480,6132,6348,"Central"]
["XYZ","2017-08-18","Energy","Exxon",500,10550,5110,5440,"Central"]
["XYZ","2017-08-21","Energy","Exxon",300,6495,3066,3429,"Central"]
["XYZ","2017-08-28","Energy","Exxon",900,21762,9198,12564,"Central"]
["ABC","2017-08-29","Energy","Exxon",800,15976,6776,9200,"Central"]
["ABC","2017-08-31","Manufacturing","General Electric",500,9475,4235,5240,"Central"]
["XYZ","2017-09-01","Manufacturing","General Motors",100,2343,1022,1321,"Central"]
["ABC","2017-09-11","Retail","Wal-Mart",500,8970,4235,4735,"Central"]
["XYZ","2017-09-12","Communications","AT&T",900,15255,7623,7632,"Central"]
["ABC","2017-09-12","Financial","BankUnited",900,21033,8856,12177,"Central"]
["ABC","2017-09-19","Transportation","Southwest Airlines",900,17136,7623,9513,"Central"]
["XYZ","2017-09-20","Transportation","Southwest Airlines",300,6462,2952,3510,"Central"]
["XYZ","2017-09-21","Retail","Kroger",100,2538,1022,1516,"Central"]
["DEF","2017-09-25","Manufacturing","General Motors",100,2004,984,1020,"Central"]
["ABC","2017-09-27","Transportation","Southwest Airlines",300,5592,2541,3051,"Central"]
["DEF","2017-10-02","Communications","AT&T",900,21546,8856,12690,"Central"]
["ABC","2017-10-05","Manufacturing","IBM",100,2111,847,1264,"Central"]
["ABC","2017-10-06","Manufacturing","P&G",400,9660,4088,5572,"Central"]
["DEF","2017-10-09","Manufacturing","General Electric",600,12888,5904,6984,"Central"]
["ABC","2017-10-10","Manufacturing","IBM",100,2108,847,1261,"Central"]
["ABC","2017-10-11","Energy","Exxon",600,11964,5082,6882,"Central"]
["ABC","2017-10-13","Energy","Exxon",900,15651,7623,8028,"Central"]
["DEF","2017-10-25","Communications","AT&T",500,9460,4235,5225,"Central"]
["ABC","2017-10-26","Manufacturing","General Motors",600,10290,5082,5208,"Central"]
["DEF","2017-10-30","Manufacturing","General Electric",500,11240,5110,6130,"Central"]
["DEF","2017-10-31","Manufacturing","General Electric",400,9204,4088,5116,"Central"]
["ABC","2017-11-01","Manufacturing","IBM",400,6860,3388,3472,"Central"]
["XYZ","2017-11-02","Energy","Texaco",600,13806,6132,7674,"Central"]
["ABC","2017-11-03","Manufacturing","General Motors",800,16416,6776,9640,"Central"]
["ABC","2017-11-03","Manufacturing","HP",900,21015,9198,11817,"Central"]
["XYZ","2017-11-08","Communications","AT&T",100,1740,847,893,"Central"]
["XYZ","2017-11-10","Retail","Wal-Mart",900,21888,9198,12690,"Central"]
["ABC","2017-11-23","Manufacturing","General Electric",500,10445,4235,6210,"Central"]
["XYZ","2017-11-27","Communications","AT&T",400,10044,4088,5956,"Central"]
["ABC","2017-11-30","Energy","Exxon",700,13314,5929,7385,"Central"]
["DEF","2017-12-01","Manufacturing","General Electric",200,4280,1968,2312,"Central"]
["ABC","2017-12-05","Retail","Wal-Mart",400,7180,3388,3792,"Central"]
["ABC","2017-12-13","Energy","Exxon",600,11124,5082,6042,"Central"]
["DEF","2017-12-13","Manufacturing","General Electric",800,18504,7872,10632,"Central"]
["DEF","2017-12-14","Manufacturing","Cummins Inc.",600,12282,5904,6378,"Central"]
["DEF","2017-12-18","Manufacturing","Cummins Inc.",1000,22680,10220,12460,"Central"]
["XYZ","2017-12-18","Manufacturing","IBM",700,17367,7154,10213,"Central"]
["ABC","2017-12-19","Manufacturing","Phillip Morris",200,4614,2044,2570,"Central"]
["ABC","2017-12-19","Transportation","Southwest Airlines",600,11922,5082,6840,"Central"]
["DEF","2017-12-25","Manufacturing","Cummins Inc.",200,4010,1694,2316,"Central"]
["XYZ","2017-12-26","Manufacturing","General Motors",500,12505,5110,7395,"Central"]
["ABC","2018-01-08","Healthcare","Merck",100,2484,1022,1462,"Central"]
["DEF","2018-01-09","Manufacturing","General Electric",200,4472,1968,2504,"Central"]
["ABC","2018-01-10","Manufacturing","General Motors",700,11858,5929,5929,"Central"]
["DEF","2018-01-15","Manufacturing","Cummins Inc.",600,13542,6132,7410,"Central"]
["XYZ","2018-01-17","Communications","AT&T",600,14448,6132,8316,"Central"]
["DEF","2018-01-18","Energy","Exxon",300,7233,2952,4281,"Central"]
["DEF","2018-01-23","Manufacturing","Cummins Inc.",500,10460,4235,6225,"Central"]
["DEF","2018-01-24","Manufacturing","Cummins Inc.",800,18344,8176,10168,"Central"]
["DEF","2018-01-29","Financial","CUNA Insurance",600,14004,5904,8100,"Central"]
["DEF","2018-02-06","Manufacturing","Cummins Inc.",400,7852,3388,4464,"Central"]
["ABC","2018-02-07","Retail","Wal-Mart",600,12360,5082,7278,"Central"]
["DEF","2018-02-08","Manufacturing","Cummins Inc.",900,18990,8856,10134,"Central"]
["DEF","2018-02-15","Manufacturing","General Motors",700,15407,6888,8519,"Central"]
["ABC","2018-02-16","Retail","Wal-Mart",1000,18290,8470,9820,"Central"]
["ABC","2018-02-23","Financial","BankUnited",300,7245,2952,4293,"Central"]
["XYZ","2018-02-26","Energy","Exxon",500,11000,5110,5890,"Central"]
["DEF","2018-03-01","Manufacturing","General Electric",500,10385,5110,5275,"Central"]
["XYZ","2018-03-02","Transportation","Southwest Airlines",700,14203,6888,7315,"Central"]
["XYZ","2018-03-06","Energy","Exxon",100,2149,1022,1127,"Central"]
["DEF","2018-03-12","Manufacturing","Cummins Inc.",800,16264,7872,8392,"Central"]
["XYZ","2018-03-14","Manufacturing","Cummins Inc.",500,12550,5110,7440,"Central"]
["XYZ","2018-03-16","Manufacturing","Compaq",400,9064,4088,4976,"Central"]
["DEF","2018-03-21","Manufacturing","IBM",800,17944,7872,10072,"Central"]
["DEF","2018-03-29","Financial","CUNA Insurance",200,4060,1968,2092,"Central"]
["ABC","2018-04-02","Financial","BankUnited",800,15856,7872,7984,"Central"]
["XYZ","2018-04-02","Energy","Exxon",400,8804,4088,4716,"Central"]
["DEF","2018-04-09","Energy","Exxon",700,16303,6888,9415,"Central"]
["DEF","2018-04-11","Manufacturing","General Motors",500,12270,4920,7350,"Central"]
["ABC","2018-04-12","Retail","Wal-Mart",900,17883,7623,10260,"Central"]
["XYZ","2018-04-16","Manufacturing","IBM",900,21366,9198,12168,"Central"]
["XYZ","2018-04-18","Manufacturing","Cummins Inc.",800,17416,7872,9544,"Central"]
["XYZ","2018-04-19","Manufacturing","IBM",200,4902,2044,2858,"Central"]
["XYZ","2018-04-23","Retail","Kroger",1000,22840,10220,12620,"Central"]
["DEF","2018-04-27","Retail","Wal-Mart",200,4132,1968,2164,"Central"]
["XYZ","2018-04-30","Energy","Exxon",200,4722,2044,2678,"Central"]
["ABC","2018-05-02","Transportation","Southwest Airlines",300,6159,2952,3207,"Central"]
["XYZ","2018-05-04","Energy","Exxon",900,21159,9198,11961,"Central"]
["DEF","2018-05-11","Retail","Wal-Mart",600,13368,5904,7464,"Central"]
["XYZ","2018-05-14","Manufacturing","Cummins Inc.",200,4550,2044,2506,"Central"]
["ABC","2018-05-16","Financial","BankUnited",700,17213,6888,10325,"Central"]
["XYZ","2018-05-16","Energy","Texaco",200,4270,1968,2302,"Central"]
["ABC","2018-05-18","Energy","Exxon",1000,21120,8470,12650,"Central"]
["XYZ","2018-05-21","Manufacturing","Cummins Inc.",300,6156,2541,3615,"Central"]
["ABC","2018-05-22","Manufacturing","General Electric",800,15544,6776,8768,"Central"]
["XYZ","2018-05-25","Manufacturing","IBM",300,6438,3066,3372,"Central"]
["XYZ","2018-05-28","Manufacturing","Cummins Inc.",900,19593,9198,10395,"Central"]
["XYZ","2018-05-30","Energy","Exxon",800,17160,8176,8984,"Central"]
["ABC","2018-06-07","Manufacturing","HP",500,11550,4920,6630,"Central"]
["XYZ","2018-06-07","Transportation","Southwest Airlines",600,12936,6132,6804,"Central"]
["XYZ","2018-06-14","Communications","AT&T",100,1795,847,948,"Central"]
["DEF","2018-06-19","Manufacturing","General Electric",900,22014,9198,12816,"Central"]
["DEF","2018-06-19","Manufacturing","General Electric",400,9672,3936,5736,"Central"]
["DEF","2018-06-20","Retail","Wal-Mart",600,14004,5904,8100,"Central"]
["ABC","2018-06-22","Financial","BankUnited",500,8715,4235,4480,"Central"]
["ABC","2018-07-03","Manufacturing","General Electric",200,3922,1694,2228,"Central"]
["ABC","2018-07-04","Financial","BankUnited",1000,23970,9840,14130,"Central"]
["DEF","2018-07-05","Retail","Sears",500,8940,4235,4705,"Central"]
["DEF","2018-07-10","Manufacturing","IBM",500,11530,4920,6610,"Central"]
["ABC","2018-07-11","Manufacturing","Phillip Morris",800,15312,6776,8536,"Central"]
["XYZ","2018-07-16","Manufacturing","Cummins Inc.",1000,21010,8470,12540,"Central"]
["DEF","2018-07-18","Retail","Lowe's",500,11220,4920,6300,"Central"]
["DEF","2018-07-19","Energy","Exxon",500,11250,4920,6330,"Central"]
["XYZ","2018-07-24","Transportation","Southwest Airlines",100,2092,1022,1070,"Central"]
["DEF","2018-07-25","Retail","Sears",600,12612,6132,6480,"Central"]
["DEF","2018-07-26","Financial","CUNA Insurance",800,15104,6776,8328,"Central"]
["XYZ","2018-08-03","Manufacturing","General Motors",600,13680,6132,7548,"Central"]
["DEF","2018-08-06","Manufacturing","General Motors",600,13200,5904,7296,"Central"]
["DEF","2017-01-02","Manufacturing","Cummins Inc.",1000,22810,10220,12590,"East"]
["ABC","2017-01-02","Healthcare","Merck",800,18552,7872,10680,"East"]
["ABC","2017-01-03","Manufacturing","General Motors",400,8456,3388,5068,"East"]
["DEF","2017-01-03","Financial","State Farm",1000,21730,9840,11890,"East"]
["XYZ","2017-01-06","Communications","AT&T",100,2401,1022,1379,"East"]
["ABC","2017-01-09","Financial","CitiGroup",600,11628,5082,6546,"East"]
["DEF","2017-01-11","Communications","SBC Communications",800,14440,6776,7664,"East"]
["ABC","2017-01-13","Manufacturing","IBM",600,12606,5082,7524,"East"]
["ABC","2017-01-16","Financial","CitiGroup",1000,20770,8470,12300,"East"]
["DEF","2017-01-17","Manufacturing","General Motors",700,17150,6888,10262,"East"]
["DEF","2017-01-18","Retail","Wal-Mart",300,6714,2952,3762,"East"]
["ABC","2017-01-19","Manufacturing","General Motors",800,15640,6776,8864,"East"]
["DEF","2017-01-24","Manufacturing","General Electric",900,21708,8856,12852,"East"]
["ABC","2017-01-26","Financial","CitiGroup",100,1817,847,970,"East"]
["DEF","2017-01-30","Financial","CitiGroup",700,13867,6888,6979,"East"]
["ABC","2017-02-01","Energy","Exxon",600,11430,5082,6348,"East"]
["DEF","2017-02-08","Manufacturing","Cummins Inc.",600,13206,5904,7302,"East"]
["DEF","2017-02-09","Retail","Wal-Mart",400,8708,3936,4772,"East"]
["XYZ","2017-02-10","Manufacturing","General Motors",900,21456,9198,12258,"East"]
["ABC","2017-02-21","Manufacturing","IBM",100,1819,847,972,"East"]
["XYZ","2017-02-22","Financial","CitiGroup",1000,24430,10220,14210,"East"]
["XYZ","2017-02-22","Retail","Wal-Mart",500,10935,5110,5825,"East"]
["XYZ","2017-02-24","Financial","CitiGroup",900,18783,9198,9585,"East"]
["ABC","2017-02-28","Manufacturing","General Electric",400,7132,3388,3744,"East"]
["ABC","2017-03-01","Manufacturing","General Electric",200,4784,2044,2740,"East"]
["DEF","2017-03-07","Manufacturing","General Motors",1000,20090,9840,10250,"East"]
["DEF","2017-03-13","Communications","AT&T",300,5370,2541,2829,"East"]
["ABC","2017-03-16","Financial","BankUnited",700,14686,5929,8757,"East"]
["DEF","2017-03-17","Energy","Exxon",500,12095,4920,7175,"East"]
["ABC","2017-03-22","Manufacturing","General Electric",600,11598,5082,6516,"East"]
["ABC","2017-03-23","Financial","CitiGroup",400,8016,3388,4628,"East"]
["XYZ","2017-03-24","Transportation","Southwest Airlines",1000,21880,10220,11660,"East"]
["DEF","2017-03-28","Manufacturing","Cummins Inc.",100,2457,984,1473,"East"]
["ABC","2017-03-29","Energy","Exxon",300,5439,2541,2898,"East"]
["DEF","2017-03-30","Retail","Wal-Mart",500,11435,4920,6515,"East"]
["XYZ","2017-05-26","Communications","AT&T",900,19062,9198,9864,"East"]
["DEF","2017-05-30","Energy","Exxon",900,21168,8856,12312,"East"]
["DEF","2017-06-02","Manufacturing","General Electric",900,21555,8856,12699,"East"]
["ABC","2017-06-05","Manufacturing","IBM",300,5967,2541,3426,"East"]
["ABC","2017-06-06","Financial","BankUnited",1000,25350,10220,15130,"East"]
["ABC","2017-06-08","Retail","Wal-Mart",1000,18660,8470,10190,"East"]
["DEF","2017-06-12","Manufacturing","General Motors",800,15816,7872,7944,"East"]
["XYZ","2017-06-13","Communications","Lucent",1000,23890,10220,13670,"East"]
["ABC","2017-06-14","Retail","Wal-Mart",800,13936,6776,7160,"East"]
["ABC","2017-06-15","Manufacturing","General Electric",600,12984,6132,6852,"East"]
["DEF","2017-06-16","Financial","CitiGroup",1000,21800,9840,11960,"East"]
["XYZ","2017-06-19","Energy","Exxon",400,9704,4088,5616,"East"]
["DEF","2017-06-26","Manufacturing","Cummins Inc.",300,6138,2541,3597,"East"]
["ABC","2017-06-28","Energy","Exxon",300,5904,2541,3363,"East"]
["DEF","2017-06-28","Energy","Exxon",800,16232,7872,8360,"East"]
["ABC","2017-06-29","Financial","BankUnited",900,18684,9198,9486,"East"]
["DEF","2017-06-29","Manufacturing","Cummins Inc.",100,1836,847,989,"East"]
["XYZ","2017-06-30","Communications","AT&T",600,15006,6132,8874,"East"]
["DEF","2017-07-03","Manufacturing","Cummins Inc.",100,1913,847,1066,"East"]
["XYZ","2017-07-04","Financial","CitiGroup",900,19368,9198,10170,"East"]
["XYZ","2017-07-06","Communications","AT&T",500,10990,5110,5880,"East"]
["ABC","2017-07-11","Financial","CitiGroup",800,16144,6776,9368,"East"]
["DEF","2017-07-18","Communications","AT&T",600,12756,5904,6852,"East"]
["XYZ","2017-07-20","Financial","CitiGroup",800,20008,8176,11832,"East"]
["ABC","2017-07-21","Financial","CitiGroup",300,5457,2541,2916,"East"]
["ABC","2017-07-24","Energy","Exxon",600,12330,5082,7248,"East"]
["DEF","2017-07-25","Communications","AT&T",500,11845,4920,6925,"East"]
["ABC","2017-07-28","Financial","CitiGroup",600,10602,5082,5520,"East"]
["XYZ","2017-07-31","Manufacturing","General Motors",100,2095,1022,1073,"East"]
["DEF","2017-08-07","Manufacturing","General Electric",200,4866,1968,2898,"East"]
["DEF","2017-08-08","Manufacturing","Cummins Inc.",100,1877,847,1030,"East"]
["XYZ","2017-08-10","Retail","Wal-Mart",700,15715,7154,8561,"East"]
["XYZ","2017-08-11","Financial","CitiGroup",800,18208,8176,10032,"East"]
["DEF","2017-08-11","Manufacturing","Motorola",100,2358,984,1374,"East"]
["XYZ","2017-08-14","Manufacturing","IBM",400,8560,4088,4472,"East"]
["XYZ","2017-08-17","Financial","CitiGroup",100,2517,1022,1495,"East"]
["ABC","2017-08-18","Financial","BankUnited",700,14133,5929,8204,"East"]
["ABC","2017-08-22","Financial","CitiGroup",400,7520,3388,4132,"East"]
["ABC","2017-08-23","Financial","CitiGroup",800,14136,6776,7360,"East"]
["ABC","2017-08-24","Manufacturing","General Motors",800,16008,6776,9232,"East"]
["DEF","2017-08-25","Retail","Wal-Mart",1000,23040,9840,13200,"East"]
["DEF","2017-08-30","Financial","CitiGroup",1000,20540,9840,10700,"East"]
["DEF","2017-09-04","Manufacturing","General Electric",500,10645,5110,5535,"East"]
["ABC","2017-09-05","Manufacturing","General Electric",400,8468,3388,5080,"East"]
["ABC","2017-09-06","Financial","CitiGroup",400,8196,3388,4808,"East"]
["DEF","2017-09-07","Financial","CitiGroup",500,11295,4920,6375,"East"]
["DEF","2017-09-08","Manufacturing","General Electric",600,14466,5904,8562,"East"]
["DEF","2017-09-15","Communications","SBC Communications",1000,24420,10220,14200,"East"]
["DEF","2017-09-18","Financial","CitiGroup",300,7053,2952,4101,"East"]
["DEF","2017-09-19","Financial","CitiGroup",100,2410,984,1426,"East"]
["DEF","2017-09-19","Financial","CitiGroup",400,8204,3936,4268,"East"]
["DEF","2017-09-22","Financial","CitiGroup",400,8464,3936,4528,"East"]
["DEF","2017-09-25","Manufacturing","General Electric",500,9890,4920,4970,"East"]
["ABC","2017-10-03","Manufacturing","Phillip Morris",500,10760,4920,5840,"East"]
["ABC","2017-10-03","Retail","Wal-Mart",900,18243,7623,10620,"East"]
["XYZ","2017-10-12","Manufacturing","IBM",300,6732,3066,3666,"East"]
["ABC","2017-10-16","Financial","BankUnited",600,11274,5082,6192,"East"]
["ABC","2017-10-19","Manufacturing","IBM",500,8725,4235,4490,"East"]
["ABC","2017-10-23","Transportation","Southwest Airlines",100,2055,847,1208,"East"]
["XYZ","2017-10-24","Energy","Exxon",600,14178,6132,8046,"East"]
["ABC","2017-10-27","Transportation","Southwest Airlines",500,10245,4235,6010,"East"]
["DEF","2017-11-06","Manufacturing","General Electric",900,21465,9198,12267,"East"]
["ABC","2017-11-09","Transportation","Southwest Airlines",500,9345,4235,5110,"East"]
["DEF","2017-11-13","Energy","Exxon",300,5961,2952,3009,"East"]
["ABC","2017-11-14","Financial","CitiGroup",900,17505,7623,9882,"East"]
["ABC","2017-11-17","Energy","Exxon",400,8164,3388,4776,"East"]
["DEF","2017-11-21","Energy","Exxon",300,6240,2952,3288,"East"]
["ABC","2017-11-22","Manufacturing","IBM",400,8128,3388,4740,"East"]
["ABC","2017-11-24","Retail","Wal-Mart",800,14224,6776,7448,"East"]
["ABC","2017-11-28","Financial","CitiGroup",1000,19250,8470,10780,"East"]
["DEF","2017-11-29","Energy","Exxon",200,4740,1968,2772,"East"]
["DEF","2017-11-29","Manufacturing","General Motors",600,12672,5904,6768,"East"]
["ABC","2017-12-04","Transportation","Southwest Airlines",300,6045,2541,3504,"East"]
["DEF","2017-12-06","Financial","CitiGroup",600,12798,5904,6894,"East"]
["ABC","2017-12-07","Retail","Wal-Mart",100,2066,847,1219,"East"]
["DEF","2017-12-08","Manufacturing","Cummins Inc.",200,4742,1968,2774,"East"]
["ABC","2017-12-13","Financial","BankUnited",400,7152,3388,3764,"East"]
["DEF","2017-12-15","Manufacturing","General Electric",1000,20940,10220,10720,"East"]
["XYZ","2017-12-20","Transportation","Southwest Airlines",1000,20490,10220,10270,"East"]
["DEF","2017-12-21","Manufacturing","General Electric",400,8620,4088,4532,"East"]
["DEF","2017-12-22","Manufacturing","IBM",500,11860,4920,6940,"East"]
["ABC","2017-12-25","Financial","BankUnited",800,14984,6776,8208,"East"]
["DEF","2017-12-29","Manufacturing","Cummins Inc.",200,4526,1968,2558,"East"]
["DEF","2018-01-01","Manufacturing","IBM",500,11695,4920,6775,"East"]
["DEF","2018-01-02","Energy","Exxon",100,2272,984,1288,"East"]
["DEF","2018-01-05","Financial","CitiGroup",800,15856,7872,7984,"East"]
["DEF","2018-01-12","Retail","Wal-Mart",800,17240,7872,9368,"East"]
["XYZ","2018-01-19","Manufacturing","General Motors",700,15435,7154,8281,"East"]
["ABC","2018-01-22","Financial","CitiGroup",500,9575,4235,5340,"East"]
["DEF","2018-01-22","Energy","Exxon",400,8632,3936,4696,"East"]
["DEF","2018-01-22","Energy","Exxon",300,6588,2952,3636,"East"]
["ABC","2018-01-24","Manufacturing","General Motors",400,8132,3388,4744,"East"]
["XYZ","2018-01-25","Manufacturing","IBM",900,19539,9198,10341,"East"]
["DEF","2018-01-26","Retail","Wal-Mart",900,20403,8856,11547,"East"]
["ABC","2018-01-31","Manufacturing","General Motors",900,17172,7623,9549,"East"]
["XYZ","2018-02-09","Manufacturing","Ford",800,18264,8176,10088,"East"]
["DEF","2018-02-12","Communications","AT&T",1000,20310,8470,11840,"East"]
["XYZ","2018-02-16","Communications","AT&T",800,15592,6776,8816,"East"]
["XYZ","2018-02-19","Communications","AT&T",100,1842,847,995,"East"]
["XYZ","2018-02-19","Financial","CitiGroup",500,10400,5110,5290,"East"]
["DEF","2018-02-20","Manufacturing","Cummins Inc.",100,1982,847,1135,"East"]
["XYZ","2018-02-22","Financial","CitiGroup",300,6789,3066,3723,"East"]
["DEF","2018-02-22","Manufacturing","IBM",700,16765,6888,9877,"East"]
["DEF","2018-02-27","Manufacturing","General Motors",400,9760,3936,5824,"East"]
["DEF","2018-02-27","Retail","Wal-Mart",700,16772,6888,9884,"East"]
["DEF","2018-02-28","Manufacturing","Cummins Inc.",400,9156,4088,5068,"East"]
["XYZ","2018-03-05","Financial","CitiGroup",600,14634,6132,8502,"East"]
["DEF","2018-03-07","Manufacturing","Cummins Inc.",200,4474,1968,2506,"East"]
["DEF","2018-03-07","Manufacturing","Cummins Inc.",100,2487,1022,1465,"East"]
["ABC","2018-03-12","Manufacturing","General Motors",200,3632,1694,1938,"East"]
["XYZ","2018-03-13","Manufacturing","IBM",700,14469,7154,7315,"East"]
["DEF","2018-03-14","Manufacturing","General Motors",700,16408,6888,9520,"East"]
["ABC","2018-03-19","Financial","CitiGroup",900,18072,7623,10449,"East"]
["DEF","2018-03-20","Communications","AT&T",800,16288,6776,9512,"East"]
["DEF","2018-03-22","Retail","Wal-Mart",300,6477,2952,3525,"East"]
["ABC","2018-03-27","Manufacturing","General Electric",700,13874,5929,7945,"East"]
["XYZ","2018-03-28","Transportation","Southwest Airlines",700,15988,7154,8834,"East"]
["XYZ","2018-04-03","Energy","Exxon",500,12425,5110,7315,"East"]
["XYZ","2018-04-04","Transportation","Southwest Airlines",100,2054,984,1070,"East"]
["XYZ","2018-04-05","Manufacturing","IBM",400,9816,4088,5728,"East"]
["XYZ","2018-04-06","Communications","AT&T",200,4192,1694,2498,"East"]
["XYZ","2018-04-10","Retail","Wal-Mart",400,8580,4088,4492,"East"]
["DEF","2018-04-13","Manufacturing","IBM",500,11725,4920,6805,"East"]
["XYZ","2018-04-17","Communications","Lucent",700,14497,6888,7609,"East"]
["XYZ","2018-04-19","Manufacturing","Cummins Inc.",700,13804,5929,7875,"East"]
["DEF","2018-04-20","Retail","Wal-Mart",500,11235,4920,6315,"East"]
["ABC","2018-04-25","Transportation","Southwest Airlines",300,6228,2952,3276,"East"]
["XYZ","2018-04-26","Manufacturing","Cummins Inc.",600,13332,5904,7428,"East"]
["DEF","2018-05-01","Manufacturing","General Motors",700,16170,6888,9282,"East"]
["XYZ","2018-05-07","Manufacturing","Cummins Inc.",100,2547,1022,1525,"East"]
["XYZ","2018-05-10","Manufacturing","Compaq",200,4380,1968,2412,"East"]
["DEF","2018-05-23","Financial","CitiGroup",900,19989,8856,11133,"East"]
["ABC","2018-05-25","Financial","BankUnited",600,12570,6132,6438,"East"]
["ABC","2018-05-30","Manufacturing","IBM",100,2028,847,1181,"East"]
["XYZ","2018-05-31","Manufacturing","Ford",300,5532,2541,2991,"East"]
["DEF","2018-06-04","Manufacturing","General Motors",900,18486,8856,9630,"East"]
["ABC","2018-06-05","Energy","Exxon",900,17289,7623,9666,"East"]
["DEF","2018-06-05","Manufacturing","General Motors",100,2106,984,1122,"East"]
["DEF","2018-06-06","Retail","Lowe's",100,2029,984,1045,"East"]
["ABC","2018-06-08","Financial","BankUnited",600,14580,5904,8676,"East"]
["XYZ","2018-06-11","Financial","CitiGroup",100,2058,1022,1036,"East"]
["XYZ","2018-06-11","Manufacturing","Cummins Inc.",600,13566,5904,7662,"East"]
["DEF","2018-06-15","Manufacturing","IBM",400,8592,3936,4656,"East"]
["DEF","2018-06-18","Communications","AT&T",600,12690,5904,6786,"East"]
["XYZ","2018-08-17","Transportation","Southwest Airlines",600,13290,6132,7158,"East"]
["XYZ","2018-08-20","Financial","CitiGroup",400,8284,4088,4196,"East"]
["XYZ","2018-08-22","Financial","CitiGroup",100,2309,1022,1287,"East"]
["ABC","2018-08-23","Financial","BankUnited",900,18756,9198,9558,"East"]
["DEF","2018-08-27","Manufacturing","General Electric",200,4696,1968,2728,"East"]
["ABC","2018-08-28","Transportation","Southwest Airlines",500,10295,4920,5375,"East"]
["XYZ","2018-08-29","Financial","CitiGroup",1000,25010,10220,14790,"East"]
["XYZ","2018-08-29","Manufacturing","Cummins Inc.",500,10380,5110,5270,"East"]
["XYZ","2018-08-30","Energy","Exxon",900,20664,9198,11466,"East"]
["XYZ","2018-08-30","Manufacturing","IBM",300,6744,3066,3678,"East"]
["ABC","2018-09-12","Financial","BankUnited",700,15225,7154,8071,"East"]
["XYZ","2018-08-13","Manufacturing","General Motors",500,11470,5110,6360,"South"]
["DEF","2018-08-17","Energy","Exxon",1000,20840,9840,11000,"South"]
["DEF","2018-08-24","Manufacturing","General Motors",200,4492,1968,2524,"South"]
["ABC","2018-08-24","Manufacturing","General Motors",1000,17410,8470,8940,"South"]
["XYZ","2018-08-31","Manufacturing","Cummins Inc.",700,13552,5929,7623,"South"]
["ABC","2018-09-04","Energy","Exxon",300,5847,2541,3306,"South"]
["XYZ","2018-09-06","Energy","Exxon",700,17199,7154,10045,"South"]
["ABC","2018-09-07","Manufacturing","IBM",100,1968,847,1121,"South"]
["XYZ","2018-09-10","Retail","Wal-Mart",200,4690,2044,2646,"South"]
["ABC","2018-09-12","Manufacturing","General Electric",100,1861,847,1014,"South"]
["ABC","2018-09-13","Manufacturing","General Motors",900,15363,7623,7740,"South"]
["DEF","2017-04-03","Manufacturing","Cummins Inc.",1000,25060,10220,14840,"South"]
["XYZ","2017-04-04","Communications","AT&T",200,4124,2044,2080,"South"]
["DEF","2017-04-07","Communications","AT&T",600,12318,5082,7236,"South"]
["ABC","2017-04-11","Financial","BankUnited",500,9155,4235,4920,"South"]
["ABC","2017-04-12","Manufacturing","General Electric",500,9380,4235,5145,"South"]
["ABC","2017-04-14","Manufacturing","P&G",900,17757,8856,8901,"South"]
["ABC","2017-04-18","Manufacturing","General Electric",600,11208,5082,6126,"South"]
["ABC","2017-04-20","Transportation","Southwest Airlines",200,4012,1694,2318,"South"]
["DEF","2017-04-21","Energy","Exxon",100,2319,984,1335,"South"]
["DEF","2017-04-24","Energy","Exxon",600,12048,5904,6144,"South"]
["XYZ","2017-04-26","Retail","Wal-Mart",800,19152,8176,10976,"South"]
["ABC","2017-05-01","Financial","BankUnited",1000,23990,10220,13770,"South"]
["XYZ","2017-05-02","Financial","CitiGroup",1000,22020,10220,11800,"South"]
["XYZ","2017-05-09","Transportation","Southwest Airlines",500,10650,5110,5540,"South"]
["ABC","2017-05-10","Transportation","Southwest Airlines",1000,19630,8470,11160,"South"]
["XYZ","2017-05-25","Communications","Lucent",300,7167,3066,4101,"South"]
["XYZ","2017-05-25","Retail","Wal-Mart",900,22716,9198,13518,"South"]
["ABC","2018-06-21","Retail","Wal-Mart",700,13139,5929,7210,"South"]
["ABC","2018-06-25","Financial","CitiGroup",900,15759,7623,8136,"South"]
["ABC","2018-06-26","Financial","CitiGroup",400,6944,3388,3556,"South"]
["DEF","2018-06-29","Manufacturing","General Motors",200,4186,1968,2218,"South"]
["ABC","2018-07-02","Transportation","Southwest Airlines",700,13195,5929,7266,"South"]
["XYZ","2018-07-09","Communications","Lucent",1000,17190,8470,8720,"South"]
["XYZ","2018-07-10","Communications","AT&T",900,21042,9198,11844,"South"]
["XYZ","2018-07-12","Transportation","Southwest Airlines",900,19161,9198,9963,"South"]
["XYZ","2018-07-13","Financial","CitiGroup",500,10940,5110,5830,"South"]
["ABC","2018-07-17","Financial","BankUnited",900,18576,7623,10953,"South"]
["DEF","2018-07-17","Financial","CitiGroup",200,4484,1968,2516,"South"]
["DEF","2018-07-17","Manufacturing","General Electric",700,13797,6888,6909,"South"]
["ABC","2018-07-18","Financial","CitiGroup",700,12131,5929,6202,"South"]
["DEF","2018-07-20","Financial","CitiGroup",500,11430,4920,6510,"South"]
["XYZ","2018-07-23","Manufacturing","General Motors",100,2234,1022,1212,"South"]
["XYZ","2018-07-24","Energy","Exxon",600,13818,6132,7686,"South"]
["XYZ","2018-07-30","Manufacturing","General Motors",700,17059,7154,9905,"South"]
["DEF","2018-07-31","Financial","CitiGroup",800,19424,7872,11552,"South"]
["DEF","2018-07-31","Retail","Wal-Mart",700,14784,6888,7896,"South"]
["XYZ","2018-08-02","Manufacturing","Cummins Inc.",900,19674,8856,10818,"South"]
["DEF","2018-08-07","Financial","CitiGroup",800,17136,7872,9264,"South"]
["DEF","2018-08-10","Financial","CitiGroup",400,9484,3936,5548,"South"]
["DEF","2018-08-14","Communications","AT&T",600,14154,5904,8250,"South"]
["DEF","2018-08-15","Retail","Wal-Mart",800,19280,7872,11408,"South"]
["DEF","2017-10-17","Manufacturing","Cummins Inc.",800,14408,6776,7632,"South"]
["XYZ","2017-10-18","Manufacturing","IBM",100,2213,1022,1191,"South"]
["XYZ","2017-10-20","Transportation","Southwest Airlines",900,18666,9198,9468,"South"]
["DEF","2017-10-23","Manufacturing","General Electric",500,10475,4920,5555,"South"]
["DEF","2017-11-07","Manufacturing","General Electric",400,9144,4088,5056,"South"]
["ABC","2017-11-08","Retail","Wal-Mart",1000,19110,8470,10640,"South"]
["DEF","2017-11-15","Energy","Exxon",300,7032,2952,4080,"South"]
["DEF","2017-11-16","Energy","Exxon",300,6735,2952,3783,"South"]
["ABC","2017-11-20","Retail","Wal-Mart",300,6207,2541,3666,"South"]
["ABC","2017-12-11","Manufacturing","General Motors",200,3876,1694,2182,"South"]
["XYZ","2017-12-12","Manufacturing","General Motors",1000,25080,10220,14860,"South"]
["DEF","2017-12-12","Manufacturing","IBM",400,9088,3936,5152,"South"]
["ABC","2017-12-18","Manufacturing","General Motors",700,12145,5929,6216,"South"]
["XYZ","2018-09-03","Retail","Wal-Mart",800,18560,8176,10384,"South"]
["XYZ","2018-09-05","Communications","AT&T",800,18304,8176,10128,"South"]
["DEF","2018-09-11","Communications","SBC Communications",500,11680,5110,6570,"South"]
["DEF","2018-09-11","Retail","Wal-Mart",700,14560,6888,7672,"South"]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100,"South"]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100,"South"]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100,"South"]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100,"South"]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100,"South"]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100,"South"]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100,"South"]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100,"South"]
["ABC","2017-11-20","Retail","Doug's New Records",100,100,100,100,"South"]
["ABC","2017-01-10","Transportation","Southwest Airlines",100,2042,984,1058,"West",0.51811949069539665]
["ABC","2017-01-11","Healthcare","Merck",200,3552,1694,1858,"West",0.5230855855855856]
["ABC","2017-01-12","Manufacturing","General Motors",800,14592,6776,7816,"West",0.53563596491228072]
["ABC","2017-01-20","Retail","Wal-Mart",300,5532,2541,2991,"West",0.54067245119305862]
["ABC","2017-01-23","Transportation","Southwest Airlines",800,17160,7872,9288,"West",0.54125874125874129]
["ABC","2017-01-25","Manufacturing","IBM",1000,19890,8470,11420,"West",0.57415786827551529]
["ABC","2017-01-31","Manufacturing","Boeing",800,16936,8176,8760,"West",0.51724137931034486]
["ABC","2017-02-02","Retail","Wal-Mart",1000,20250,8470,11780,"West",0.58172839506172835]
["DEF","2017-02-06","Manufacturing","Cummins Inc.",300,5700,2541,3159,"West",0.55421052631578949]
["DEF","2017-02-08","Retail","ABC Stores",900,20610,8856,11754,"West",0.57030567685589517]
["XYZ","2017-02-13","Retail","Wal-Mart",500,10445,5110,5335,"West",0.5107707036859741]
["DEF","2017-02-14","Manufacturing","General Electric",600,14472,5904,8568,"West",0.59203980099502485]
["ABC","2017-02-16","Manufacturing","P&G",700,12474,5929,6545,"West",0.52469135802469136]
["ABC","2017-02-17","Energy","Exxon",500,10155,4235,5920,"West",0.58296405711472177]
["DEF","2017-02-23","Retail","ABC Stores",400,8116,3388,4728,"West",0.58255298176441594]
["XYZ","2017-03-02","Communications","AT&T",300,6765,3066,3699,"West",0.54678492239467846]
["DEF","2017-03-10","Manufacturing","General Electric",800,16016,7872,8144,"West",0.50849150849150848]
["ABC","2017-03-14","Manufacturing","P&G",800,20408,8176,12232,"West",0.59937279498235985]
["XYZ","2017-03-15","Transportation","Southwest Airlines",100,2466,1022,1444,"West",0.58556366585563668]
["DEF","2017-03-20","Manufacturing","General Electric",400,8776,3936,4840,"West",0.55150410209662715]
["ABC","2017-03-21","Manufacturing","General Electric",300,6063,2541,3522,"West",0.58090054428500737]
["ABC","2017-04-06","Financial","BankUnited",800,19288,8176,11112,"West",0.5761094981335545]
["ABC","2017-04-07","Financial","BankUnited",400,8052,3936,4116,"West",0.51117734724292097]
["ABC","2017-04-13","Financial","BankUnited",300,6156,2952,3204,"West",0.52046783625730997]
["ABC","2017-04-25","Energy","Exxon",900,17964,7623,10341,"West",0.57565130260521047]
["XYZ","2017-04-26","Communications","AT&T",700,13412,5929,7483,"West",0.5579331941544885]
["DEF","2017-05-12","Manufacturing","Cummins Inc.",200,3856,1694,2162,"West",0.56068464730290457]
["ABC","2017-05-17","Energy","Exxon",100,1882,847,1035,"West",0.54994686503719448]
["XYZ","2017-05-29","Manufacturing","General Motors",300,7593,3066,4527,"West",0.59620703279336229]
["ABC","2017-05-31","Manufacturing","Boeing",1000,24130,10220,13910,"West",0.57646083713220053]
["DEF","2017-06-07","Retail","Lowe's",200,4158,1694,2464,"West",0.59259259259259256]
["DEF","2017-06-23","Communications","AT&T",800,16936,7872,9064,"West",0.53519130845536134]
["DEF","2017-06-26","Manufacturing","IBM",600,12030,5904,6126,"West",0.50922693266832919]
["ABC","2017-06-27","Financial","BankUnited",400,9384,4088,5296,"West",0.56436487638533672]
["ABC","2017-07-03","Manufacturing","General Electric",400,8744,4088,4656,"West",0.53247941445562674]
["DEF","2017-07-03","Manufacturing","Motorola",800,17856,8176,9680,"West",0.54211469534050183]
["ABC","2017-07-10","Financial","BankUnited",800,18904,7872,11032,"West",0.5835801946677952]
["DEF","2017-07-13","Manufacturing","Cummins Inc.",500,10295,4235,6060,"West",0.5886352598348713]
["ABC","2017-07-17","Manufacturing","IBM",100,1957,847,1110,"West",0.56719468574348497]
["DEF","2017-08-01","Manufacturing","General Motors",600,13728,5904,7824,"West",0.56993006993006989]
["ABC","2017-08-03","Retail","Wal-Mart",800,13552,6776,6776,"West",0.5]
["XYZ","2017-08-09","Manufacturing","Ford",800,16936,8176,8760,"West",0.51724137931034486]
["DEF","2017-08-15","Manufacturing","IBM",1000,20190,9840,10350,"West",0.51263001485884097]
["DEF","2017-08-16","Retail","ABC Stores",300,7032,3066,3966,"West",0.56399317406143346]
["XYZ","2017-08-23","Communications","AT&T",900,21834,9198,12636,"West",0.5787304204451772]
["DEF","2017-08-28","Energy","Exxon",500,10955,4920,6035,"West",0.55089000456412596]
["XYZ","2017-09-08","Transportation","Southwest Airlines",800,19376,8176,11200,"West",0.5780346820809249]
["XYZ","2017-09-13","Manufacturing","Compaq",1000,17250,8470,8780,"West",0.50898550724637681]
["ABC","2017-09-14","Retail","Wal-Mart",400,6880,3388,3492,"West",0.50755813953488371]
["ABC","2017-09-15","Manufacturing","General Electric",200,3672,1694,1978,"West",0.53867102396514166]
["XYZ","2017-09-20","Manufacturing","Compaq",400,8556,4088,4468,"West",0.52220663861617578]
["DEF","2017-09-26","Manufacturing","General Electric",300,7569,3066,4503,"West",0.5949266745937376]
["DEF","2017-09-28","Manufacturing","IBM",200,3942,1968,1974,"West",0.50076103500761038]
["ABC","2017-09-29","Manufacturing","Phillip Morris",800,19344,7872,11472,"West",0.59305210918114148]
["DEF","2017-10-04","Manufacturing","Cummins Inc.",800,16856,6776,10080,"West",0.59800664451827246]
["ABC","2017-10-05","Energy","Exxon",700,14105,5929,8176,"West",0.57965260545905706]
["ABC","2017-10-09","Energy","Exxon",100,1878,847,1031,"West",0.54898828541001066]
["ABC","2017-12-27","Manufacturing","General Motors",100,1704,847,857,"West",0.5029342723004695]
["XYZ","2017-12-27","Manufacturing","IBM",300,7305,3066,4239,"West",0.58028747433264882]
["XYZ","2017-12-28","Manufacturing","IBM",500,11965,5110,6855,"West",0.57292101964061848]
["ABC","2017-12-29","Financial","BankUnited",400,9240,4088,5152,"West",0.55757575757575761]
["DEF","2018-01-03","Manufacturing","Cummins Inc.",100,2157,984,1173,"West",0.54381084840055638]
["XYZ","2018-01-04","Transportation","Southwest Airlines",400,8732,4088,4644,"West",0.53183692166743013]
["DEF","2018-01-08","Retail","Wal-Mart",1000,23820,9840,13980,"West",0.58690176322418131]
["ABC","2018-01-11","Manufacturing","General Motors",500,9855,4235,5620,"West",0.57026889903602229]
["DEF","2018-01-16","Manufacturing","Motorola",300,5859,2541,3318,"West",0.56630824372759858]
["DEF","2018-01-19","Manufacturing","Cummins Inc.",400,7752,3388,4364,"West",0.56295149638802888]
["XYZ","2018-01-22","Energy","Exxon",100,2178,1022,1156,"West",0.53076216712580349]
["DEF","2018-01-30","Manufacturing","Cummins Inc.",800,14216,6776,7440,"West",0.52335396736072026]
["ABC","2018-02-01","Retail","Wal-Mart",400,7376,3388,3988,"West",0.54067245119305862]
["ABC","2018-02-02","Healthcare","Merck",800,17728,8176,9552,"West",0.53880866425992779]
["ABC","2018-02-05","Manufacturing","Boeing",1000,20950,9840,11110,"West",0.53031026252983293]
["ABC","2018-02-08","Manufacturing","General Electric",300,6069,2541,3528,"West",0.58131487889273359]
["DEF","2018-02-12","Communications","AT&T",300,6018,2952,3066,"West",0.50947158524426717]
["XYZ","2018-02-13","Communications","AT&T",1000,25310,10220,15090,"West",0.59620703279336229]
["XYZ","2018-02-14","Transportation","Southwest Airlines",200,4378,1968,2410,"West",0.55047967108268614]
["ABC","2018-02-16","Financial","BankUnited",300,6867,3066,3801,"West",0.55351681957186549]
["DEF","2018-02-21","Retail","Wal-Mart",800,17544,7872,9672,"West",0.55129958960328318]
["ABC","2018-02-28","Manufacturing","Boeing",500,9635,4235,5400,"West",0.56045666839647124]
["ABC","2018-03-06","Financial","State Farm",700,13853,5929,7924,"West",0.57200606366851947]
["XYZ","2018-03-08","Energy","Exxon",200,4388,2044,2344,"West",0.53418413855970825]
["ABC","2018-03-08","Manufacturing","General Motors",700,12803,5929,6874,"West",0.53690541279387638]
["ABC","2018-03-09","Manufacturing","General Electric",300,5094,2541,2553,"West",0.50117785630153122]
["DEF","2018-03-15","Communications","AT&T",800,17056,7872,9184,"West",0.53846153846153844]
["ABC","2018-03-23","Energy","Exxon",600,10404,5082,5322,"West",0.51153402537485582]
["ABC","2018-03-26","Manufacturing","IBM",500,8780,4235,4545,"West",0.51765375854214124]
["XYZ","2018-03-30","Manufacturing","Cummins Inc.",700,16219,6888,9331,"West",0.57531290461804052]
["ABC","2018-03-30","Manufacturing","General Electric",800,15400,6776,8624,"West",0.56000000000000005]
["DEF","2018-04-06","Retail","Wal-Mart",900,18099,8856,9243,"West",0.51069119840875188]
["ABC","2018-04-23","Manufacturing","General Motors",600,12684,5082,7602,"West",0.59933774834437081]
["ABC","2018-04-24","Energy","Exxon",200,3390,1694,1696,"West",0.50029498525073746]
["XYZ","2018-05-01","Transportation","Southwest Airlines",600,13866,5904,7962,"West",0.57421029857204675]
["DEF","2018-05-02","Retail","ABC Stores",1000,18290,8470,9820,"West",0.53690541279387638]
["ABC","2018-05-03","Energy","Exxon",1000,18500,8470,10030,"West",0.54216216216216218]
["DEF","2018-05-07","Communications","AT&T",800,15488,6776,8712,"West",0.5625]
["DEF","2018-05-08","Retail","Lowe's",600,13962,6132,7830,"West",0.56080790717662221]
["ABC","2018-05-08","Retail","Wal-Mart",200,3418,1694,1724,"West",0.50438853130485661]
["ABC","2018-05-09","Manufacturing","General Motors",1000,19530,8470,11060,"West",0.56630824372759858]
["DEF","2018-05-15","Communications","AT&T",300,6522,2952,3570,"West",0.54737810487580496]
["XYZ","2018-05-17","Manufacturing","Cummins Inc.",500,12755,5110,7645,"West",0.59937279498235985]
["DEF","2018-05-18","Manufacturing","General Motors",200,4470,1968,2502,"West",0.55973154362416111]
["XYZ","2018-05-24","Manufacturing","Cummins Inc.",100,2409,984,1425,"West",0.59153175591531759]
["ABC","2018-05-29","Transportation","Southwest Airlines",900,18981,7623,11358,"West",0.59838786154575629]
["ABC","2018-05-30","Retail","Wal-Mart",300,5859,2541,3318,"West",0.56630824372759858]
["XYZ","2018-06-01","Manufacturing","Cummins Inc.",500,12575,5110,7465,"West",0.59363817097415505]
["ABC","2018-06-12","Manufacturing","General Electric",100,1741,847,894,"West",0.51349798966111426]
["XYZ","2018-06-13","Energy","Exxon",200,5002,2044,2958,"West",0.59136345461815276]
["DEF","2018-06-18","Manufacturing","IBM",300,6582,2952,3630,"West",0.55150410209662715]
["ABC","2018-06-20","Energy","Exxon",1000,18530,8470,10060,"West",0.54290339989206693]
["XYZ","2018-06-27","Retail","Wal-Mart",500,12760,5110,7650,"West",0.59952978056426331]
["XYZ","2018-06-28","Retail","Wal-Mart",1000,24070,10220,13850,"West",0.57540506855006235]
["XYZ","2018-07-06","Energy","Exxon",200,5002,2044,2958,"West",0.59136345461815276]
["XYZ","2018-07-27","Energy","Exxon",700,16576,7154,9422,"West",0.56841216216216217]
["XYZ","2018-08-01","Manufacturing","Cummins Inc.",1000,21740,9840,11900,"West",0.54737810487580496]
["DEF","2018-08-08","Manufacturing","General Motors",500,11330,4920,6410,"West",0.56575463371579882]
["DEF","2018-08-09","Energy","Exxon",200,4412,1968,2444,"West",0.55394378966455127]
["XYZ","2018-08-16","Manufacturing","General Motors",900,22887,9198,13689,"West",0.59811246559182063]
["XYZ","2018-08-20","Manufacturing","Cummins Inc.",800,17496,8176,9320,"West",0.53269318701417467]
["ABC","2018-08-20","Financial","State Farm",800,19544,8176,11368,"West",0.58166189111747846]
["DEF","2018-08-21","Manufacturing","General Motors",1000,23690,9840,13850,"West",0.58463486703250311]

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

{"sheet":"Wrap Up","index":8,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Doug: How to combine four sheets where each has a different number of rows?"]
[null,"Use Power Query"]
[null,"Format each worksheet as a Table with Ctrl+T"]
[null,"Rename the tables"]
[null,"For each table, new query From Table. Add a custom column for Region"]
[null,"Instead of Close & Load, choose Close & Load to… Only Create a Connection"]
[null,"Use New Query, Combine Query, Append. 3 or More Tables. Choose the Tables and Add"]
[null,"Close and Load and the data appears on a new worksheet"]
[null,"For the one table with extra column: the data shows up for only that sheet's records"]
[null,"For the one table where the columns were in the wrong order: Power Query worked correctly!"]
[null,"Easy to Refresh later"]