{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","Sheet1","Data","Wrap Up"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":18,"comments":0,"pivot_tables":1},"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,2071]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Free-Photos / Pixabay"]

{"sheet":"Sheet1","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Customer","Revenue ","% of Total","Rank","Running Total %"]
["ABC Stores",7032,2.054287287636737E-3,25,2.054287287636737E-3]
["AT&T",316064,9.2333085506202742E-2,6,9.4387372793839477E-2]
["BankUnited",228539,6.6764044714051798E-2,9,0.16115141750789128]
["Boeing",54715,1.5984119588032433E-2,11,0.1771355370959237]
["CitiGroup",331768,9.6920760074611062E-2,4,0.27405629717053476]
["Compaq",26314,7.6872178166770616E-3,16,0.28174351498721184]
["Cummins Inc.",281828,8.2331581015370636E-2,7,0.36407509600258248]
["CUNA Insurance",36136,1.0556559360927351E-2,14,0.37463165536350984]
["Exxon",331262,9.6772940198680435E-2,5,0.47140459556219022]
["Ford",51984,1.5186301245806048E-2,12,0.48659089680799628]
["General Electric",355601,0.10388319308460059,2,0.59047408989259687]
["General Motors",344671,0.10069016691084212,3,0.69116425680343896]
["HP",38855,1.1350872093447869E-2,13,0.70251512889688683]
["IBM",257661,7.5271575201901211E-2,8,0.77778670409878803]
["Kroger",4357,1.2728284573710557E-3,26,0.77905953255615912]
["Lowe's",4158,1.214693763082132E-3,27,0.78027422631924126]
["Lucent",23890,6.9790846560923844E-3,19,0.78725331097533369]
["Merck",20212,5.9046152812448419E-3,20,0.79315792625657855]
["Motorola",26073,7.616813488417612E-3,17,0.80077473974499613]
["P&G",9660,2.8220158132211148E-3,23,0.80359675555821719]
["Phillip Morris",34718,1.0142313147351001E-2,15,0.81373906870556822]
["SBC Communications",24420,7.1339157514347436E-3,18,0.82087298445700296]
["Sears",8876,2.5929826457712852E-3,24,0.8234659671027742]
["Southwest Airlines",194678,5.6872090526527974E-2,10,0.88033805762930217]
["State Farm",13853,4.0469342712786856E-3,21,0.88438499190058095]
["Texaco",13806,4.033203966597382E-3,22,0.8884181958671783]
["Wal-Mart",381954,0.1115818041328217,1,1]
["Grand Total",3423085,1]

{"sheet":"Data","index":2,"n_rows":292,"n_cols":9,"rows_kept":292,"cut":false,"hidden":false,"merged":[]}
["Region","Product","Date","Sector","Customer","Quantity","Revenue","COGS","Profit"]
["East","XYZ","2015-07-01","Communications","AT&T",900,19062,9198,9864]
["West","XYZ","2015-07-02","Manufacturing","General Motors",300,7593,3066,4527]
["East","DEF","2015-07-05","Energy","Exxon",900,21168,8856,12312]
["West","ABC","2015-07-07","Manufacturing","Boeing",1000,24130,10220,13910]
["Central","DEF","2015-07-08","Retail","Sears",400,8876,4088,4788]
["East","DEF","2015-07-11","Manufacturing","General Electric",900,21555,8856,12699]
["Central","DEF","2015-07-12","Manufacturing","Cummins Inc.",700,15876,7154,8722]
["East","ABC","2015-07-12","Manufacturing","IBM",300,5967,2541,3426]
["East","ABC","2015-07-14","Financial","BankUnited",1000,25350,10220,15130]
["Central","DEF","2015-07-15","Manufacturing","IBM",500,11545,4920,6625]
["West","DEF","2015-07-15","Retail","Lowe's",200,4158,1694,2464]
["East","ABC","2015-07-19","Retail","Wal-Mart",1000,18660,8470,10190]
["Central","DEF","2015-07-20","Communications","AT&T",500,11660,4920,6740]
["East","DEF","2015-07-23","Manufacturing","General Motors",800,15816,7872,7944]
["East","XYZ","2015-07-24","Communications","Lucent",1000,23890,10220,13670]
["East","ABC","2015-07-26","Retail","Wal-Mart",800,13936,6776,7160]
["Central","ABC","2015-07-26","Manufacturing","HP",1000,17840,8470,9370]
["East","ABC","2015-07-27","Manufacturing","General Electric",600,12984,6132,6852]
["East","DEF","2015-07-28","Financial","CitiGroup",1000,21800,9840,11960]
["Central","ABC","2015-07-28","Retail","Wal-Mart",300,5508,2541,2967]
["East","XYZ","2015-07-31","Energy","Exxon",400,9704,4088,5616]
["Central","ABC","2015-08-02","Energy","Exxon",700,13433,5929,7504]
["Central","XYZ","2015-08-03","Manufacturing","General Motors",900,19584,9198,10386]
["Central","ABC","2015-08-03","Financial","BankUnited",800,15288,6776,8512]
["Central","ABC","2015-08-04","Manufacturing","General Electric",100,2320,1022,1298]
["East","DEF","2015-08-11","Manufacturing","Cummins Inc.",300,6138,2541,3597]
["West","DEF","2015-08-11","Manufacturing","IBM",600,12030,5904,6126]
["West","ABC","2015-08-13","Financial","BankUnited",400,9384,4088,5296]
["East","ABC","2015-08-14","Energy","Exxon",300,5904,2541,3363]
["East","ABC","2015-08-17","Financial","BankUnited",900,18684,9198,9486]
["East","DEF","2015-08-17","Manufacturing","Cummins Inc.",100,1836,847,989]
["East","XYZ","2015-08-19","Communications","AT&T",600,15006,6132,8874]
["East","DEF","2015-08-22","Manufacturing","Cummins Inc.",100,1913,847,1066]
["West","DEF","2015-08-22","Manufacturing","Motorola",800,17856,8176,9680]
["West","ABC","2015-08-22","Manufacturing","General Electric",400,8744,4088,4656]
["East","XYZ","2015-08-23","Financial","CitiGroup",900,19368,9198,10170]
["Central","XYZ","2015-08-24","Retail","Kroger",100,1819,847,972]
["Central","XYZ","2015-08-25","Communications","AT&T",200,4440,2044,2396]
["East","XYZ","2015-08-25","Communications","AT&T",500,10990,5110,5880]
["Central","ABC","2015-08-26","Transportation","Southwest Airlines",300,6309,2541,3768]
["West","ABC","2015-08-27","Financial","BankUnited",800,18904,7872,11032]
["Central","DEF","2015-08-29","Financial","CUNA Insurance",800,18072,8176,9896]
["Central","ABC","2015-08-29","Retail","Wal-Mart",100,2012,847,1165]
["East","DEF","2015-09-30","Manufacturing","Cummins Inc.",100,1877,847,1030]
["West","ABC","2015-09-03","Manufacturing","IBM",100,1957,847,1110]
["East","XYZ","2015-09-22","Manufacturing","General Motors",100,2095,1022,1073]
["East","DEF","2015-09-29","Manufacturing","General Electric",200,4866,1968,2898]
["East","ABC","2015-09-11","Financial","CitiGroup",300,5457,2541,2916]
["Central","ABC","2015-09-08","Energy","Exxon",300,5826,2541,3285]
["Central","DEF","2015-09-02","Manufacturing","Cummins Inc.",400,7944,3388,4556]
["Central","DEF","2015-09-22","Communications","AT&T",500,9350,4235,5115]
["West","DEF","2015-09-01","Manufacturing","Cummins Inc.",500,10295,4235,6060]
["East","ABC","2015-09-20","Financial","CitiGroup",600,10602,5082,5520]
["East","DEF","2015-09-15","Communications","AT&T",500,11845,4920,6925]
["East","ABC","2015-09-12","Energy","Exxon",600,12330,5082,7248]
["Central","XYZ","2015-09-26","Manufacturing","General Motors",600,12480,6132,6348]
["East","DEF","2015-09-07","Communications","AT&T",600,12756,5904,6852]
["West","ABC","2015-09-25","Retail","Wal-Mart",800,13552,6776,6776]
["West","DEF","2015-09-23","Manufacturing","General Motors",600,13728,5904,7824]
["Central","XYZ","2015-09-07","Transportation","Southwest Airlines",700,15680,6888,8792]
["East","ABC","2016-09-27","Financial","CitiGroup",900,15759,7623,8136]
["Central","XYZ","2015-09-16","Manufacturing","Ford",800,16784,7872,8912]
["Central","ABC","2015-09-19","Manufacturing","General Motors",1000,17200,8470,8730]
["Central","ABC","2015-09-24","Manufacturing","General Electric",900,17712,7623,10089]
["East","XYZ","2015-09-10","Financial","CitiGroup",800,20008,8176,11832]
["Central","DEF","2015-09-24","Retail","Wal-Mart",1000,23080,9840,13240]
["West","XYZ","2015-10-03","Manufacturing","Ford",800,16936,8176,8760]
["East","XYZ","2015-10-04","Retail","Wal-Mart",700,15715,7154,8561]
["East","DEF","2015-10-05","Manufacturing","Motorola",100,2358,984,1374]
["East","XYZ","2015-10-05","Financial","CitiGroup",800,18208,8176,10032]
["East","XYZ","2015-10-07","Manufacturing","IBM",400,8560,4088,4472]
["West","DEF","2015-10-09","Manufacturing","IBM",1000,20190,9840,10350]
["West","DEF","2015-10-10","Retail","ABC Stores",300,7032,3066,3966]
["East","XYZ","2015-10-12","Financial","CitiGroup",100,2517,1022,1495]
["East","ABC","2015-10-13","Financial","BankUnited",700,14133,5929,8204]
["Central","XYZ","2015-10-13","Energy","Exxon",500,10550,5110,5440]
["Central","XYZ","2015-10-14","Energy","Exxon",300,6495,3066,3429]
["East","ABC","2015-10-15","Financial","CitiGroup",400,7520,3388,4132]
["West","XYZ","2015-10-17","Communications","AT&T",900,21834,9198,12636]
["East","ABC","2015-10-17","Financial","CitiGroup",800,14136,6776,7360]
["East","ABC","2015-10-19","Manufacturing","General Motors",800,16008,6776,9232]
["East","DEF","2015-10-20","Retail","Wal-Mart",1000,23040,9840,13200]
["West","DEF","2015-10-22","Energy","Exxon",500,10955,4920,6035]
["Central","XYZ","2015-10-22","Energy","Exxon",900,21762,9198,12564]
["Central","ABC","2015-10-24","Energy","Exxon",800,15976,6776,9200]
["East","DEF","2015-10-27","Financial","CitiGroup",1000,20540,9840,10700]
["Central","ABC","2015-10-28","Manufacturing","General Electric",500,9475,4235,5240]
["Central","XYZ","2015-10-29","Manufacturing","General Motors",100,2343,1022,1321]
["East","DEF","2015-11-01","Manufacturing","General Electric",500,10645,5110,5535]
["East","ABC","2015-11-02","Manufacturing","General Electric",400,8468,3388,5080]
["East","ABC","2015-11-05","Financial","CitiGroup",400,8196,3388,4808]
["East","DEF","2015-11-08","Financial","CitiGroup",500,11295,4920,6375]
["East","DEF","2015-11-10","Manufacturing","General Electric",600,14466,5904,8562]
["West","XYZ","2015-11-10","Transportation","Southwest Airlines",800,19376,8176,11200]
["Central","XYZ","2015-11-12","Communications","AT&T",900,15255,7623,7632]
["Central","ABC","2015-11-12","Financial","BankUnited",900,21033,8856,12177]
["West","XYZ","2015-11-13","Manufacturing","Compaq",1000,17250,8470,8780]
["West","ABC","2015-11-17","Manufacturing","General Electric",200,3672,1694,1978]
["East","DEF","2015-11-17","Communications","SBC Communications",1000,24420,10220,14200]
["East","DEF","2015-11-18","Financial","CitiGroup",300,7053,2952,4101]
["East","DEF","2015-11-20","Financial","CitiGroup",100,2410,984,1426]
["Central","ABC","2015-11-20","Transportation","Southwest Airlines",900,17136,7623,9513]
["Central","XYZ","2015-11-21","Transportation","Southwest Airlines",300,6462,2952,3510]
["Central","XYZ","2015-11-22","Retail","Kroger",100,2538,1022,1516]
["East","DEF","2015-11-25","Manufacturing","General Electric",500,9890,4920,4970]
["Central","DEF","2015-11-25","Manufacturing","General Motors",100,2004,984,1020]
["West","DEF","2015-11-26","Manufacturing","General Electric",300,7569,3066,4503]
["Central","ABC","2015-11-27","Transportation","Southwest Airlines",300,5592,2541,3051]
["West","DEF","2015-11-28","Manufacturing","IBM",200,3942,1968,1974]
["West","ABC","2015-11-29","Manufacturing","Phillip Morris",800,19344,7872,11472]
["Central","DEF","2015-12-01","Communications","AT&T",900,21546,8856,12690]
["East","ABC","2015-12-02","Retail","Wal-Mart",900,18243,7623,10620]
["East","ABC","2015-12-02","Manufacturing","Phillip Morris",500,10760,4920,5840]
["West","DEF","2015-12-03","Manufacturing","Cummins Inc.",800,16856,6776,10080]
["Central","ABC","2015-12-05","Manufacturing","IBM",100,2111,847,1264]
["West","ABC","2015-12-05","Energy","Exxon",700,14105,5929,8176]
["Central","ABC","2015-12-06","Manufacturing","P&G",400,9660,4088,5572]
["Central","DEF","2015-12-07","Manufacturing","General Electric",600,12888,5904,6984]
["West","ABC","2015-12-07","Energy","Exxon",100,1878,847,1031]
["Central","ABC","2015-12-09","Manufacturing","IBM",100,2108,847,1261]
["Central","ABC","2015-12-11","Energy","Exxon",600,11964,5082,6882]
["East","XYZ","2015-12-12","Manufacturing","IBM",300,6732,3066,3666]
["Central","ABC","2015-12-15","Energy","Exxon",900,15651,7623,8028]
["East","ABC","2015-12-16","Financial","BankUnited",600,11274,5082,6192]
["West","DEF","2015-12-17","Manufacturing","Cummins Inc.",800,14408,6776,7632]
["West","XYZ","2015-12-18","Manufacturing","IBM",100,2213,1022,1191]
["East","ABC","2015-12-19","Manufacturing","IBM",500,8725,4235,4490]
["West","XYZ","2015-12-21","Transportation","Southwest Airlines",900,18666,9198,9468]
["East","ABC","2015-12-22","Transportation","Southwest Airlines",100,2055,847,1208]
["West","DEF","2015-12-22","Manufacturing","General Electric",500,10475,4920,5555]
["East","XYZ","2015-12-24","Energy","Exxon",600,14178,6132,8046]
["Central","DEF","2015-12-25","Communications","AT&T",500,9460,4235,5225]
["Central","ABC","2015-12-26","Manufacturing","General Motors",600,10290,5082,5208]
["East","ABC","2015-12-30","Transportation","Southwest Airlines",500,10245,4235,6010]
["Central","DEF","2015-12-31","Manufacturing","General Electric",500,11240,5110,6130]
["Central","DEF","2016-01-01","Manufacturing","General Electric",400,9204,4088,5116]
["Central","ABC","2016-01-02","Manufacturing","IBM",400,6860,3388,3472]
["Central","XYZ","2016-01-04","Energy","Texaco",600,13806,6132,7674]
["Central","ABC","2016-01-06","Manufacturing","General Motors",800,16416,6776,9640]
["Central","ABC","2016-01-06","Manufacturing","HP",900,21015,9198,11817]
["East","DEF","2016-01-07","Manufacturing","General Electric",900,21465,9198,12267]
["West","DEF","2016-01-09","Manufacturing","General Electric",400,9144,4088,5056]
["West","ABC","2016-01-11","Retail","Wal-Mart",1000,19110,8470,10640]
["Central","XYZ","2016-01-11","Communications","AT&T",100,1740,847,893]
["East","ABC","2016-01-12","Transportation","Southwest Airlines",500,9345,4235,5110]
["Central","XYZ","2016-01-13","Retail","Wal-Mart",900,21888,9198,12690]
["East","DEF","2016-01-14","Energy","Exxon",300,5961,2952,3009]
["East","ABC","2016-01-17","Financial","CitiGroup",900,17505,7623,9882]
["West","DEF","2016-01-18","Energy","Exxon",300,7032,2952,4080]
["West","DEF","2016-01-19","Energy","Exxon",300,6735,2952,3783]
["East","ABC","2016-01-20","Energy","Exxon",400,8164,3388,4776]
["West","ABC","2016-01-21","Retail","Wal-Mart",300,6207,2541,3666]
["East","DEF","2016-01-22","Energy","Exxon",300,6240,2952,3288]
["East","ABC","2016-01-23","Manufacturing","IBM",400,8128,3388,4740]
["Central","ABC","2016-01-24","Manufacturing","General Electric",500,10445,4235,6210]
["East","ABC","2016-01-26","Retail","Wal-Mart",800,14224,6776,7448]
["Central","XYZ","2016-01-27","Communications","AT&T",400,10044,4088,5956]
["East","ABC","2016-01-28","Financial","CitiGroup",1000,19250,8470,10780]
["East","DEF","2016-01-29","Energy","Exxon",200,4740,1968,2772]
["East","DEF","2016-01-29","Manufacturing","General Motors",600,12672,5904,6768]
["Central","ABC","2016-02-02","Energy","Exxon",700,13314,5929,7385]
["Central","DEF","2016-02-03","Manufacturing","General Electric",200,4280,1968,2312]
["East","ABC","2016-02-05","Transportation","Southwest Airlines",300,6045,2541,3504]
["Central","ABC","2016-02-06","Retail","Wal-Mart",400,7180,3388,3792]
["East","DEF","2016-02-10","Financial","CitiGroup",600,12798,5904,6894]
["East","ABC","2016-02-12","Retail","Wal-Mart",100,2066,847,1219]
["East","DEF","2016-02-13","Manufacturing","Cummins Inc.",200,4742,1968,2774]
["West","ABC","2016-02-14","Manufacturing","General Motors",200,3876,1694,2182]
["West","XYZ","2016-02-16","Manufacturing","General Motors",1000,25080,10220,14860]
["West","DEF","2016-02-16","Manufacturing","IBM",400,9088,3936,5152]
["Central","ABC","2016-02-17","Energy","Exxon",600,11124,5082,6042]
["East","ABC","2016-02-17","Financial","BankUnited",400,7152,3388,3764]
["Central","DEF","2016-02-17","Manufacturing","General Electric",800,18504,7872,10632]
["Central","DEF","2016-02-19","Manufacturing","Cummins Inc.",600,12282,5904,6378]
["East","DEF","2016-02-21","Manufacturing","General Electric",1000,20940,10220,10720]
["West","ABC","2016-02-23","Manufacturing","General Motors",700,12145,5929,6216]
["Central","XYZ","2016-02-23","Manufacturing","IBM",700,17367,7154,10213]
["Central","DEF","2016-02-23","Manufacturing","Cummins Inc.",1000,22680,10220,12460]
["Central","ABC","2016-02-24","Manufacturing","Phillip Morris",200,4614,2044,2570]
["Central","ABC","2016-02-24","Transportation","Southwest Airlines",600,11922,5082,6840]
["East","XYZ","2016-02-25","Transportation","Southwest Airlines",1000,20490,10220,10270]
["East","DEF","2016-02-28","Manufacturing","General Electric",400,8620,4088,4532]
["East","DEF","2016-02-29","Manufacturing","IBM",500,11860,4920,6940]
["East","ABC","2016-03-02","Financial","BankUnited",800,14984,6776,8208]
["Central","DEF","2016-03-02","Manufacturing","Cummins Inc.",200,4010,1694,2316]
["Central","XYZ","2016-03-05","Manufacturing","General Motors",500,12505,5110,7395]
["West","XYZ","2016-03-09","Manufacturing","IBM",300,7305,3066,4239]
["West","ABC","2016-03-09","Manufacturing","General Motors",100,1704,847,857]
["West","XYZ","2016-03-10","Manufacturing","IBM",500,11965,5110,6855]
["West","ABC","2016-03-12","Financial","BankUnited",400,9240,4088,5152]
["East","DEF","2016-03-12","Manufacturing","Cummins Inc.",200,4526,1968,2558]
["East","DEF","2016-03-14","Manufacturing","IBM",500,11695,4920,6775]
["East","DEF","2016-03-15","Energy","Exxon",100,2272,984,1288]
["West","DEF","2016-03-16","Manufacturing","Cummins Inc.",100,2157,984,1173]
["West","XYZ","2016-03-18","Transportation","Southwest Airlines",400,8732,4088,4644]
["East","DEF","2016-03-19","Financial","CitiGroup",800,15856,7872,7984]
["West","DEF","2016-03-20","Retail","Wal-Mart",1000,23820,9840,13980]
["Central","ABC","2016-03-20","Healthcare","Merck",100,2484,1022,1462]
["Central","DEF","2016-03-21","Manufacturing","General Electric",200,4472,1968,2504]
["Central","ABC","2016-03-22","Manufacturing","General Motors",700,11858,5929,5929]
["West","ABC","2016-03-24","Manufacturing","General Motors",500,9855,4235,5620]
["East","DEF","2016-03-26","Retail","Wal-Mart",800,17240,7872,9368]
["Central","DEF","2016-03-27","Manufacturing","Cummins Inc.",600,13542,6132,7410]
["West","DEF","2016-03-28","Manufacturing","Motorola",300,5859,2541,3318]
["Central","XYZ","2016-03-29","Communications","AT&T",600,14448,6132,8316]
["Central","DEF","2016-03-30","Energy","Exxon",300,7233,2952,4281]
["West","DEF","2016-03-31","Manufacturing","Cummins Inc.",400,7752,3388,4364]
["East","XYZ","2016-03-31","Manufacturing","General Motors",700,15435,7154,8281]
["East","DEF","2016-04-01","Energy","Exxon",400,8632,3936,4696]
["East","DEF","2016-04-01","Energy","Exxon",300,6588,2952,3636]
["East","ABC","2016-04-01","Financial","CitiGroup",500,9575,4235,5340]
["West","XYZ","2016-04-01","Energy","Exxon",100,2178,1022,1156]
["Central","DEF","2016-04-03","Manufacturing","Cummins Inc.",500,10460,4235,6225]
["East","ABC","2016-04-06","Manufacturing","General Motors",400,8132,3388,4744]
["Central","DEF","2016-04-06","Manufacturing","Cummins Inc.",800,18344,8176,10168]
["East","XYZ","2016-04-08","Manufacturing","IBM",900,19539,9198,10341]
["West","DEF","2015-04-08","Manufacturing","General Electric",400,8776,3936,4840]
["East","DEF","2016-04-09","Retail","Wal-Mart",900,20403,8856,11547]
["Central","DEF","2016-04-10","Financial","CUNA Insurance",600,14004,5904,8100]
["West","DEF","2016-04-11","Manufacturing","Cummins Inc.",800,14216,6776,7440]
["East","ABC","2016-04-16","Manufacturing","General Motors",900,17172,7623,9549]
["Central","XYZ","2015-04-17","Manufacturing","General Motors",1000,20670,10220,10450]
["West","ABC","2016-04-18","Retail","Wal-Mart",400,7376,3388,3988]
["West","ABC","2016-04-20","Healthcare","Merck",800,17728,8176,9552]
["West","ABC","2016-04-21","Manufacturing","Boeing",1000,20950,9840,11110]
["Central","DEF","2016-04-22","Manufacturing","Cummins Inc.",400,7852,3388,4464]
["Central","ABC","2016-04-23","Retail","Wal-Mart",600,12360,5082,7278]
["West","ABC","2016-04-25","Manufacturing","General Electric",300,6069,2541,3528]
["Central","DEF","2016-04-25","Manufacturing","Cummins Inc.",900,18990,8856,10134]
["East","XYZ","2016-04-26","Manufacturing","Ford",800,18264,8176,10088]
["West","DEF","2016-04-27","Communications","AT&T",300,6018,2952,3066]
["East","DEF","2016-04-27","Communications","AT&T",1000,20310,8470,11840]
["West","XYZ","2016-04-28","Communications","AT&T",1000,25310,10220,15090]
["West","XYZ","2016-04-29","Transportation","Southwest Airlines",200,4378,1968,2410]
["East","ABC","2015-05-30","Financial","BankUnited",1000,23990,10220,13770]
["East","XYZ","2015-05-31","Financial","CitiGroup",1000,22020,10220,11800]
["East","XYZ","2015-05-27","Retail","Wal-Mart",800,19152,8176,10976]
["Central","ABC","2016-05-02","Retail","Wal-Mart",1000,18290,8470,9820]
["West","DEF","2016-05-05","Retail","Wal-Mart",800,17544,7872,9672]
["West","DEF","2016-05-27","Communications","AT&T",800,17056,7872,9184]
["East","DEF","2016-05-09","Retail","Wal-Mart",700,16772,6888,9884]
["East","DEF","2016-05-06","Manufacturing","IBM",700,16765,6888,9877]
["East","DEF","2016-05-26","Manufacturing","General Motors",700,16408,6888,9520]
["Central","DEF","2016-05-24","Manufacturing","Cummins Inc.",800,16264,7872,8392]
["East","XYZ","2016-05-02","Communications","AT&T",800,15592,6776,8816]
["Central","DEF","2016-05-01","Manufacturing","General Motors",700,15407,6888,8519]
["East","XYZ","2016-05-17","Financial","CitiGroup",600,14634,6132,8502]
["East","XYZ","2016-05-25","Manufacturing","IBM",700,14469,7154,7315]
["Central","XYZ","2016-05-16","Transportation","Southwest Airlines",700,14203,6888,7315]
["West","ABC","2016-05-18","Financial","State Farm",700,13853,5929,7924]
["West","ABC","2016-05-20","Manufacturing","General Motors",700,12803,5929,6874]
["Central","XYZ","2016-05-26","Manufacturing","Cummins Inc.",500,12550,5110,7440]
["Central","XYZ","2016-05-08","Energy","Exxon",500,11000,5110,5890]
["East","XYZ","2016-05-03","Financial","CitiGroup",500,10400,5110,5290]
["Central","DEF","2016-05-14","Manufacturing","General Electric",500,10385,5110,5275]
["East","DEF","2016-05-09","Manufacturing","General Motors",400,9760,3936,5824]
["West","ABC","2016-05-11","Manufacturing","Boeing",500,9635,4235,5400]
["East","DEF","2016-05-11","Manufacturing","Cummins Inc.",400,9156,4088,5068]
["East","ABC","2015-05-09","Financial","BankUnited",500,9155,4235,4920]
["Central","ABC","2016-05-07","Financial","BankUnited",300,7245,2952,4293]
["West","ABC","2016-05-02","Financial","BankUnited",300,6867,3066,3801]
["East","XYZ","2016-05-06","Financial","CitiGroup",300,6789,3066,3723]
["West","ABC","2016-05-21","Manufacturing","General Electric",300,5094,2541,2553]
["East","DEF","2016-05-19","Manufacturing","Cummins Inc.",200,4474,1968,2506]
["West","XYZ","2016-05-20","Energy","Exxon",200,4388,2044,2344]
["East","ABC","2016-05-24","Manufacturing","General Motors",200,3632,1694,1938]
["East","DEF","2016-05-19","Manufacturing","Cummins Inc.",100,2487,1022,1465]
["Central","XYZ","2016-05-18","Energy","Exxon",100,2149,1022,1127]
["East","DEF","2016-05-04","Manufacturing","Cummins Inc.",100,1982,847,1135]
["East","XYZ","2016-05-03","Communications","AT&T",100,1842,847,995]
["Central","XYZ","2016-06-03","Manufacturing","Compaq",400,9064,4088,4976]
["East","ABC","2016-06-04","Financial","CitiGroup",900,18072,7623,10449]
["East","DEF","2016-06-05","Communications","AT&T",800,16288,6776,9512]
["Central","DEF","2016-06-07","Manufacturing","IBM",800,17944,7872,10072]
["East","DEF","2016-06-08","Retail","Wal-Mart",300,6477,2952,3525]
["West","ABC","2016-06-09","Energy","Exxon",600,10404,5082,5322]
["West","ABC","2016-06-10","Manufacturing","IBM",500,8780,4235,4545]
["East","ABC","2016-06-14","Manufacturing","General Electric",700,13874,5929,7945]
["East","XYZ","2016-06-17","Transportation","Southwest Airlines",700,15988,7154,8834]
["Central","DEF","2015-06-20","Communications","AT&T",1000,20020,9840,10180]
["Central","DEF","2016-06-21","Financial","CUNA Insurance",200,4060,1968,2092]
["West","XYZ","2016-06-22","Manufacturing","Cummins Inc.",700,16219,6888,9331]
["West","ABC","2016-06-22","Manufacturing","General Electric",800,15400,6776,8624]
["Central","ABC","2016-06-23","Financial","BankUnited",800,15856,7872,7984]
["Central","XYZ","2016-06-23","Energy","Exxon",400,8804,4088,4716]
["East","XYZ","2016-06-26","Energy","Exxon",500,12425,5110,7315]
["East","XYZ","2016-06-27","Transportation","Southwest Airlines",100,2054,984,1070]
["East","XYZ","2016-06-28","Manufacturing","IBM",400,9816,4088,5728]
["Central","ABC","2015-06-29","Manufacturing","General Electric",900,21960,9198,12762]
["East","XYZ","2016-06-29","Communications","AT&T",200,4192,1694,2498]
["West","DEF","2016-06-29","Retail","Wal-Mart",900,18099,8856,9243]

{"sheet":"Wrap Up","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"You might drag Revenue to a pivot table several times"]
[null,"Change the Value Field Settings for each column to show another calculation"]
[null,"Rather than choose a cell, click Field Settings, you can double-click"]
[null,"Also in this episode:"]
[null,"Changing the field heading to Revenue with a space"]
[null,"Percent of Column in a Pivot Table"]
[null,"Rank in a pivot table"]
[null,"Percentage Running Total in a pivot table"]