{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","Question","Data","Wrap Up"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":0,"defined_names":3,"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,2174]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: pixel2013 / Pixabay"]

{"sheet":"Question","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["R.A.:"]
[null,"Someone sent me a data set"]
[null,"It has subtotals at the top of each group"]
[null,"Somehow, they created subtotals that you can filter!"]
[null,"Follow up: How can I get the percentage calculation on the subtotal row to work?"]

{"sheet":"Data","index":2,"n_rows":592,"n_cols":8,"rows_kept":592,"cut":false,"hidden":false,"merged":[]}
["Product","Date","Customer","Quantity","Revenue","COGS","Profit","GP%"]
[null,null,"Grand Total",{"$f":"SUBTOTAL(9,D4:D592)","v":313900},{"$f":"SUBTOTAL(9,E4:E592)","v":6707812},{"$f":"SUBTOTAL(9,F4:F592)","v":2978394},{"$f":"SUBTOTAL(9,G4:G592)","v":3729418},{"$f":"+G2/E2","v":0.55598129464570567}]
[null,null,"ABC Stores Total",{"$f":"SUBTOTAL(9,D4:D7)","v":2600},{"$f":"SUBTOTAL(9,E4:E7)","v":54048},{"$f":"SUBTOTAL(9,F4:F7)","v":23780},{"$f":"SUBTOTAL(9,G4:G7)","v":30268},0.56002072232089994]
["DEF","2017-02-08","ABC Stores",900,20610,8856,11754,{"$f":"+G4/E4","v":0.57030567685589517}]
["ABC","2017-02-23","ABC Stores",400,8116,3388,4728,{"$f":"+G5/E5","v":0.58255298176441594}]
["DEF","2017-08-16","ABC Stores",300,7032,3066,3966,0.56399317406143346]
["DEF","2018-05-02","ABC Stores",1000,18290,8470,9820,0.53690541279387638]
[null,null,"AT&T Total",{"$f":"SUBTOTAL(9,D9:D48)","v":23100},{"$f":"SUBTOTAL(9,E9:E48)","v":498937},{"$f":"SUBTOTAL(9,F9:F48)","v":219978},{"$f":"SUBTOTAL(9,G9:G48)","v":278959},0.55910666076077742]
["XYZ","2017-01-06","AT&T",100,2401,1022,1379,0.57434402332361512]
["XYZ","2017-03-02","AT&T",300,6765,3066,3699,0.54678492239467846]
["DEF","2017-03-09","AT&T",900,21357,8856,12501,0.58533501896333751]
["DEF","2017-03-13","AT&T",300,5370,2541,2829,0.52681564245810053]
["XYZ","2017-04-04","AT&T",200,4124,2044,2080,0.50436469447138699]
["ABC","2017-04-07","AT&T",600,12318,5082,7236,0.58743302484169513]
["DEF","2017-04-19","AT&T",500,10195,4920,5275,0.51741049534085337]
["XYZ","2017-04-26","AT&T",700,13412,5929,7483,0.5579331941544885]
["DEF","2017-05-16","AT&T",1000,20020,9840,10180,0.50849150849150848]
["XYZ","2017-05-26","AT&T",900,19062,9198,9864,0.51746931067044377]
["ABC","2017-06-09","AT&T",500,11660,4920,6740,0.57804459691252141]
["DEF","2017-06-23","AT&T",800,16936,7872,9064,0.53519130845536134]
["XYZ","2017-06-30","AT&T",600,15006,6132,8874,0.59136345461815276]
["XYZ","2017-07-06","AT&T",200,4440,2044,2396,0.53963963963963968]
["XYZ","2017-07-06","AT&T",500,10990,5110,5880,0.53503184713375795]
["DEF","2017-07-18","AT&T",600,12756,5904,6852,0.53715898400752582]
["DEF","2017-07-25","AT&T",500,11845,4920,6925,0.58463486703250311]
["DEF","2017-07-31","AT&T",500,9350,4235,5115,0.54705882352941182]
["XYZ","2017-08-23","AT&T",900,21834,9198,12636,0.5787304204451772]
["XYZ","2017-09-12","AT&T",900,15255,7623,7632,0.50029498525073746]
["DEF","2017-10-02","AT&T",900,21546,8856,12690,0.58897243107769426]
["DEF","2017-10-25","AT&T",500,9460,4235,5225,0.55232558139534882]
["XYZ","2017-11-08","AT&T",100,1740,847,893,0.51321839080459775]
["XYZ","2017-11-27","AT&T",400,10044,4088,5956,0.59299084030266824]
["XYZ","2018-01-17","AT&T",600,14448,6132,8316,0.57558139534883723]
["DEF","2018-02-12","AT&T",300,6018,2952,3066,0.50947158524426717]
["DEF","2018-02-12","AT&T",1000,20310,8470,11840,0.58296405711472177]
["XYZ","2018-02-13","AT&T",1000,25310,10220,15090,0.59620703279336229]
["XYZ","2018-02-16","AT&T",800,15592,6776,8816,0.56541816316059512]
["XYZ","2018-02-19","AT&T",100,1842,847,995,0.54017372421281218]
["DEF","2018-03-15","AT&T",800,17056,7872,9184,0.53846153846153844]
["DEF","2018-03-20","AT&T",800,16288,6776,9512,0.58398821218074659]
["XYZ","2018-04-06","AT&T",200,4192,1694,2498,0.59589694656488545]
["DEF","2018-05-07","AT&T",800,15488,6776,8712,0.5625]
["DEF","2018-05-15","AT&T",300,6522,2952,3570,0.54737810487580496]
["XYZ","2018-06-14","AT&T",100,1795,847,948,0.52813370473537602]
["DEF","2018-06-18","AT&T",600,12690,5904,6786,0.53475177304964538]
["XYZ","2018-07-10","AT&T",900,21042,9198,11844,0.56287425149700598]
["DEF","2018-08-14","AT&T",600,14154,5904,8250,0.582874099194574]
["XYZ","2018-09-05","AT&T",800,18304,8176,10128,0.55332167832167833]
[null,null,"BankUnited Total",{"$f":"SUBTOTAL(9,D50:D77)","v":18700},{"$f":"SUBTOTAL(9,E50:E77)","v":406326},{"$f":"SUBTOTAL(9,F50:F77)","v":178585},{"$f":"SUBTOTAL(9,G50:G77)","v":227741},0.5604883763283669]
["ABC","2017-03-16","BankUnited",700,14686,5929,8757,0.59628217349857005]
["ABC","2017-04-06","BankUnited",800,19288,8176,11112,0.5761094981335545]
["ABC","2017-04-07","BankUnited",400,8052,3936,4116,0.51117734724292097]
["ABC","2017-04-11","BankUnited",500,9155,4235,4920,0.53741125068268703]
["ABC","2017-04-13","BankUnited",300,6156,2952,3204,0.52046783625730997]
["ABC","2017-05-01","BankUnited",1000,23990,10220,13770,0.57398916215089624]
["ABC","2017-06-06","BankUnited",1000,25350,10220,15130,0.59684418145956608]
["ABC","2017-06-21","BankUnited",800,15288,6776,8512,0.5567765567765568]
["ABC","2017-06-27","BankUnited",400,9384,4088,5296,0.56436487638533672]
["ABC","2017-06-29","BankUnited",900,18684,9198,9486,0.50770712909441229]
["ABC","2017-07-10","BankUnited",800,18904,7872,11032,0.5835801946677952]
["ABC","2017-08-18","BankUnited",700,14133,5929,8204,0.58048538880633982]
["ABC","2017-09-12","BankUnited",900,21033,8856,12177,0.57894736842105265]
["ABC","2017-10-16","BankUnited",600,11274,5082,6192,0.54922831293241081]
["ABC","2017-12-13","BankUnited",400,7152,3388,3764,0.52628635346756147]
["ABC","2017-12-25","BankUnited",800,14984,6776,8208,0.54778430325680727]
["ABC","2017-12-29","BankUnited",400,9240,4088,5152,0.55757575757575761]
["ABC","2018-02-16","BankUnited",300,6867,3066,3801,0.55351681957186549]
["ABC","2018-02-23","BankUnited",300,7245,2952,4293,0.59254658385093173]
["ABC","2018-04-02","BankUnited",800,15856,7872,7984,{"$f":"+G69/E69","v":0.50353178607467208}]
["ABC","2018-05-16","BankUnited",700,17213,6888,10325,0.59983733224888169]
["ABC","2018-05-25","BankUnited",600,12570,6132,6438,0.51217183770883057]
["ABC","2018-06-08","BankUnited",600,14580,5904,8676,0.59506172839506177]
["ABC","2018-06-22","BankUnited",500,8715,4235,4480,0.51405622489959835]
["ABC","2018-07-04","BankUnited",1000,23970,9840,14130,0.58948685857321648]
["ABC","2018-07-17","BankUnited",900,18576,7623,10953,0.58963178294573648]
["ABC","2018-08-23","BankUnited",900,18756,9198,9558,0.50959692898272557]
["ABC","2018-09-12","BankUnited",700,15225,7154,8071,0.53011494252873559]
[null,null,"Boeing Total",{"$f":"SUBTOTAL(9,D79:D82)","v":3300},{"$f":"SUBTOTAL(9,E79:E82)","v":71651},{"$f":"SUBTOTAL(9,F79:F82)","v":32471},{"$f":"SUBTOTAL(9,G79:G82)","v":39180},0.54681721120430982]
["ABC","2017-01-31","Boeing",800,16936,8176,8760,0.51724137931034486]
["ABC","2017-05-31","Boeing",1000,24130,10220,13910,0.57646083713220053]
["ABC","2018-02-05","Boeing",1000,20950,9840,11110,0.53031026252983293]
["ABC","2018-02-28","Boeing",500,9635,4235,5400,0.56045666839647124]
[null,null,"CitiGroup Total",{"$f":"SUBTOTAL(9,D84:D131)","v":29100},{"$f":"SUBTOTAL(9,E84:E131)","v":613514},{"$f":"SUBTOTAL(9,F84:F131)","v":275105},{"$f":"SUBTOTAL(9,G84:G131)","v":338409},0.55159132472934602]
["ABC","2017-01-09","CitiGroup",600,11628,5082,6546,0.56295149638802888]
["ABC","2017-01-16","CitiGroup",1000,20770,8470,12300,0.59220028887818965]
["ABC","2017-01-26","CitiGroup",100,1817,847,970,0.53384700055035772]
["DEF","2017-01-30","CitiGroup",700,13867,6888,6979,0.50328117112569415]
["XYZ","2017-02-22","CitiGroup",1000,24430,10220,14210,0.58166189111747846]
["XYZ","2017-02-24","CitiGroup",900,18783,9198,9585,0.51030186871106853]
["ABC","2017-03-23","CitiGroup",400,8016,3388,4628,0.57734530938123751]
["XYZ","2017-05-02","CitiGroup",1000,22020,10220,11800,0.53587647593097187]
["DEF","2017-06-16","CitiGroup",1000,21800,9840,11960,0.54862385321100915]
["XYZ","2017-07-04","CitiGroup",900,19368,9198,10170,0.52509293680297398]
["ABC","2017-07-11","CitiGroup",800,16144,6776,9368,0.58027750247770071]
["XYZ","2017-07-20","CitiGroup",800,20008,8176,11832,0.59136345461815276]
["ABC","2017-07-21","CitiGroup",300,5457,2541,2916,0.53435953820780646]
["ABC","2017-07-28","CitiGroup",600,10602,5082,5520,0.52065647990945108]
["XYZ","2017-08-11","CitiGroup",800,18208,8176,10032,0.55096660808435849]
["XYZ","2017-08-17","CitiGroup",100,2517,1022,1495,0.5939610647596345]
["ABC","2017-08-22","CitiGroup",400,7520,3388,4132,0.54946808510638301]
["ABC","2017-08-23","CitiGroup",800,14136,6776,7360,0.52065647990945108]
["DEF","2017-08-30","CitiGroup",1000,20540,9840,10700,0.52093476144109052]
["ABC","2017-09-06","CitiGroup",400,8196,3388,4808,0.58662762323084428]
["DEF","2017-09-07","CitiGroup",500,11295,4920,6375,0.56440903054448877]
["DEF","2017-09-18","CitiGroup",300,7053,2952,4101,0.58145470012760525]
["DEF","2017-09-19","CitiGroup",100,2410,984,1426,0.59170124481327802]
["DEF","2017-09-19","CitiGroup",400,8204,3936,4268,0.52023403217942465]
["DEF","2017-09-22","CitiGroup",400,8464,3936,4528,0.53497164461247637]
["ABC","2017-11-14","CitiGroup",900,17505,7623,9882,0.56452442159383032]
["ABC","2017-11-28","CitiGroup",1000,19250,8470,10780,0.56000000000000005]
["DEF","2017-12-06","CitiGroup",600,12798,5904,6894,0.53867791842475388]
["DEF","2018-01-05","CitiGroup",800,15856,7872,7984,0.50353178607467208]
["ABC","2018-01-22","CitiGroup",500,9575,4235,5340,0.55770234986945166]
["XYZ","2018-02-19","CitiGroup",500,10400,5110,5290,0.50865384615384612]
["XYZ","2018-02-22","CitiGroup",300,6789,3066,3723,0.54838709677419351]
["XYZ","2018-03-05","CitiGroup",600,14634,6132,8502,0.58097580975809759]
["ABC","2018-03-19","CitiGroup",900,18072,7623,10449,0.57818725099601598]
["DEF","2018-05-23","CitiGroup",900,19989,8856,11133,0.55695632597928857]
["XYZ","2018-06-11","CitiGroup",100,2058,1022,1036,0.50340136054421769]
["ABC","2018-06-25","CitiGroup",900,15759,7623,8136,0.51627641347801256]
["ABC","2018-06-26","CitiGroup",400,6944,3388,3556,0.51209677419354838]
["XYZ","2018-07-13","CitiGroup",500,10940,5110,5830,0.53290676416819016]
["DEF","2018-07-17","CitiGroup",200,4484,1968,2516,0.56110615521855489]
["ABC","2018-07-18","CitiGroup",700,12131,5929,6202,0.51125216387766881]
["DEF","2018-07-20","CitiGroup",500,11430,4920,6510,0.56955380577427817]
["DEF","2018-07-31","CitiGroup",800,19424,7872,11552,0.59472817133443168]
["DEF","2018-08-07","CitiGroup",800,17136,7872,9264,0.54061624649859941]
["DEF","2018-08-10","CitiGroup",400,9484,3936,5548,0.58498523829607763]
["XYZ","2018-08-20","CitiGroup",400,8284,4088,4196,0.50651859005311439]
["XYZ","2018-08-22","CitiGroup",100,2309,1022,1287,0.55738414898224342]
["XYZ","2018-08-29","CitiGroup",1000,25010,10220,14790,0.59136345461815276]
[null,null,"Compaq Total",{"$f":"SUBTOTAL(9,D133:D136)","v":2000},{"$f":"SUBTOTAL(9,E133:E136)","v":39250},{"$f":"SUBTOTAL(9,F133:F136)","v":18614},{"$f":"SUBTOTAL(9,G133:G136)","v":20636},0.52575796178343948]
["XYZ","2017-09-13","Compaq",1000,17250,8470,8780,{"$f":"+G133/E133","v":0.50898550724637681}]
["XYZ","2017-09-20","Compaq",400,8556,4088,4468,0.52220663861617578]
["XYZ","2018-03-16","Compaq",400,9064,4088,4976,0.54898499558693736]
["XYZ","2018-05-10","Compaq",200,4380,1968,2412,0.55068493150684927]
[null,null,"Cummins Inc. Total",{"$f":"SUBTOTAL(9,D138:D193)","v":28900},{"$f":"SUBTOTAL(9,E138:E193)","v":622794},{"$f":"SUBTOTAL(9,F138:F193)","v":274978},{"$f":"SUBTOTAL(9,G138:G193)","v":347816},0.55847679971226438]
["DEF","2017-01-02","Cummins Inc.",1000,22810,10220,12590,0.55195089872862779]
["DEF","2017-02-06","Cummins Inc.",300,5700,2541,3159,0.55421052631578949]
["DEF","2017-02-08","Cummins Inc.",600,13206,5904,7302,0.55293048614266238]
["DEF","2017-02-09","Cummins Inc.",900,16209,7623,8586,0.52970571904497499]
["DEF","2017-03-08","Cummins Inc.",1000,23090,10220,12870,0.55738414898224342]
["DEF","2017-03-28","Cummins Inc.",100,2457,984,1473,0.59951159951159949]
["DEF","2017-04-03","Cummins Inc.",1000,25060,10220,14840,0.59217877094972071]
["DEF","2017-04-05","Cummins Inc.",200,3802,1694,2108,0.55444502893214098]
["DEF","2017-05-12","Cummins Inc.",200,3856,1694,2162,0.56068464730290457]
["DEF","2017-05-18","Cummins Inc.",100,2221,984,1237,0.55695632597928857]
["DEF","2017-06-05","Cummins Inc.",700,15876,7154,8722,0.54938271604938271]
["DEF","2017-06-26","Cummins Inc.",300,6138,2541,3597,0.58602150537634412]
["DEF","2017-06-29","Cummins Inc.",100,1836,847,989,0.53867102396514166]
["DEF","2017-07-03","Cummins Inc.",100,1913,847,1066,0.55723993727130161]
["DEF","2017-07-13","Cummins Inc.",500,10295,4235,6060,0.5886352598348713]
["DEF","2017-07-14","Cummins Inc.",400,7944,3388,4556,0.57351460221550854]
["DEF","2017-08-08","Cummins Inc.",100,1877,847,1030,0.54874800213106023]
["DEF","2017-10-04","Cummins Inc.",800,16856,6776,10080,0.59800664451827246]
["DEF","2017-10-17","Cummins Inc.",800,14408,6776,7632,0.52970571904497499]
["DEF","2017-12-08","Cummins Inc.",200,4742,1968,2774,0.58498523829607763]
["DEF","2017-12-14","Cummins Inc.",600,12282,5904,6378,0.51929653150952615]
["DEF","2017-12-18","Cummins Inc.",1000,22680,10220,12460,0.54938271604938271]
["DEF","2017-12-25","Cummins Inc.",200,4010,1694,2316,0.57755610972568583]
["DEF","2017-12-29","Cummins Inc.",200,4526,1968,2558,0.56517896597437034]
["DEF","2018-01-03","Cummins Inc.",100,2157,984,1173,0.54381084840055638]
["DEF","2018-01-15","Cummins Inc.",600,13542,6132,7410,0.54718653079308821]
["DEF","2018-01-19","Cummins Inc.",400,7752,3388,4364,0.56295149638802888]
["DEF","2018-01-23","Cummins Inc.",500,10460,4235,6225,0.59512428298279163]
["DEF","2018-01-24","Cummins Inc.",800,18344,8176,10168,0.55429568251199302]
["DEF","2018-01-30","Cummins Inc.",800,14216,6776,7440,0.52335396736072026]
["DEF","2018-02-06","Cummins Inc.",400,7852,3388,4464,0.56851757514009171]
["DEF","2018-02-08","Cummins Inc.",900,18990,8856,10134,0.53364928909952603]
["DEF","2018-02-20","Cummins Inc.",100,1982,847,1135,0.57265388496468217]
["DEF","2018-02-28","Cummins Inc.",400,9156,4088,5068,0.55351681957186549]
["DEF","2018-03-07","Cummins Inc.",200,4474,1968,2506,0.5601251676352258]
["DEF","2018-03-07","Cummins Inc.",100,2487,1022,1465,0.58906312826698837]
["DEF","2018-03-12","Cummins Inc.",800,16264,7872,8392,0.51598622725036891]
["XYZ","2018-03-14","Cummins Inc.",500,12550,5110,7440,0.59282868525896415]
["XYZ","2018-03-30","Cummins Inc.",700,16219,6888,9331,0.57531290461804052]
["XYZ","2018-04-18","Cummins Inc.",800,17416,7872,9544,0.54800183739090491]
["XYZ","2018-04-19","Cummins Inc.",700,13804,5929,7875,0.57048681541582147]
["XYZ","2018-04-26","Cummins Inc.",600,13332,5904,7428,0.55715571557155719]
["XYZ","2018-05-07","Cummins Inc.",100,2547,1022,1525,0.59874361994503333]
["XYZ","2018-05-14","Cummins Inc.",200,4550,2044,2506,0.55076923076923079]
["XYZ","2018-05-17","Cummins Inc.",500,12755,5110,7645,0.59937279498235985]
["XYZ","2018-05-21","Cummins Inc.",300,6156,2541,3615,0.58723196881091622]
["XYZ","2018-05-24","Cummins Inc.",100,2409,984,1425,0.59153175591531759]
["XYZ","2018-05-28","Cummins Inc.",900,19593,9198,10395,0.53054662379421225]
["XYZ","2018-06-01","Cummins Inc.",500,12575,5110,7465,0.59363817097415505]
["XYZ","2018-06-11","Cummins Inc.",600,13566,5904,7662,0.56479433878814689]
["XYZ","2018-07-16","Cummins Inc.",1000,21010,8470,12540,0.59685863874345546]
["XYZ","2018-08-01","Cummins Inc.",1000,21740,9840,11900,0.54737810487580496]
["XYZ","2018-08-02","Cummins Inc.",900,19674,8856,10818,0.54986276303751147]
["XYZ","2018-08-20","Cummins Inc.",800,17496,8176,9320,0.53269318701417467]
["XYZ","2018-08-29","Cummins Inc.",500,10380,5110,5270,0.50770712909441229]
["XYZ","2018-08-31","Cummins Inc.",700,13552,5929,7623,0.5625]
[null,null,"CUNA Insurance Total",{"$f":"SUBTOTAL(9,D195:D198)","v":2400},{"$f":"SUBTOTAL(9,E195:E198)","v":51240},{"$f":"SUBTOTAL(9,F195:F198)","v":22824},{"$f":"SUBTOTAL(9,G195:G198)","v":28416},0.55456674473067913]
["DEF","2017-07-12","CUNA Insurance",800,18072,8176,9896,0.54758742806551575]
["DEF","2018-01-29","CUNA Insurance",600,14004,5904,8100,0.57840616966580982]
["DEF","2018-03-29","CUNA Insurance",200,4060,1968,2092,{"$f":"+G197/E197","v":0.51527093596059115}]
["DEF","2018-07-26","CUNA Insurance",800,15104,6776,8328,0.5513771186440678]
[null,null,"Exxon Total",{"$f":"SUBTOTAL(9,D200:D265)","v":33400},{"$f":"SUBTOTAL(9,E200:E265)","v":704359},{"$f":"SUBTOTAL(9,F200:F265)","v":311381},{"$f":"SUBTOTAL(9,G200:G265)","v":392978},0.55792287739632773]
["ABC","2017-02-01","Exxon",600,11430,5082,6348,0.55538057742782154]
["ABC","2017-02-17","Exxon",500,10155,4235,5920,0.58296405711472177]
["DEF","2017-03-17","Exxon",500,12095,4920,7175,0.59322033898305082]
["ABC","2017-03-29","Exxon",300,5439,2541,2898,0.53281853281853286]
["ABC","2017-04-10","Exxon",500,8785,4235,4550,0.51792828685258963]
["DEF","2017-04-21","Exxon",100,2319,984,1335,0.5756791720569211]
["DEF","2017-04-24","Exxon",600,12048,5904,6144,0.50996015936254979]
["ABC","2017-04-25","Exxon",900,17964,7623,10341,0.57565130260521047]
["ABC","2017-05-17","Exxon",100,1882,847,1035,0.54994686503719448]
["ABC","2017-05-19","Exxon",700,13734,5929,7805,0.56829765545361877]
["DEF","2017-05-23","Exxon",100,2231,984,1247,0.55894217839533844]
["DEF","2017-05-30","Exxon",900,21168,8856,12312,0.58163265306122447]
["XYZ","2017-06-19","Exxon",400,9704,4088,5616,0.5787304204451772]
["ABC","2017-06-20","Exxon",700,13433,5929,7504,0.5586242834809797]
["ABC","2017-06-28","Exxon",300,5904,2541,3363,0.56961382113821135]
["DEF","2017-06-28","Exxon",800,16232,7872,8360,0.51503203548546084]
["ABC","2017-07-19","Exxon",300,5826,2541,3285,0.56385169927909373]
["ABC","2017-07-24","Exxon",600,12330,5082,7248,0.58783454987834549]
["XYZ","2017-08-18","Exxon",500,10550,5110,5440,0.51563981042654028]
["XYZ","2017-08-21","Exxon",300,6495,3066,3429,0.52794457274826789]
["DEF","2017-08-28","Exxon",500,10955,4920,6035,0.55089000456412596]
["XYZ","2017-08-28","Exxon",900,21762,9198,12564,0.57733664185277089]
["ABC","2017-08-29","Exxon",800,15976,6776,9200,0.57586379569354029]
["ABC","2017-10-05","Exxon",700,14105,5929,8176,0.57965260545905706]
["ABC","2017-10-09","Exxon",100,1878,847,1031,0.54898828541001066]
["ABC","2017-10-11","Exxon",600,11964,5082,6882,0.57522567703109329]
["ABC","2017-10-13","Exxon",900,15651,7623,8028,0.51293847038527884]
["XYZ","2017-10-24","Exxon",600,14178,6132,8046,0.56749894202285234]
["DEF","2017-11-13","Exxon",300,5961,2952,3009,0.50478107700050323]
["DEF","2017-11-15","Exxon",300,7032,2952,4080,0.58020477815699656]
["DEF","2017-11-16","Exxon",300,6735,2952,3783,0.56169265033407567]
["ABC","2017-11-17","Exxon",400,8164,3388,4776,0.58500734933855958]
["DEF","2017-11-21","Exxon",300,6240,2952,3288,0.52692307692307694]
["DEF","2017-11-29","Exxon",200,4740,1968,2772,0.58481012658227849]
["ABC","2017-11-30","Exxon",700,13314,5929,7385,0.55467928496319663]
["ABC","2017-12-13","Exxon",600,11124,5082,6042,0.54314994606256739]
["DEF","2018-01-02","Exxon",100,2272,984,1288,0.56690140845070425]
["DEF","2018-01-18","Exxon",300,7233,2952,4281,0.5918705931148901]
["DEF","2018-01-22","Exxon",400,8632,3936,4696,0.54402224281742351]
["DEF","2018-01-22","Exxon",300,6588,2952,3636,0.55191256830601088]
["XYZ","2018-01-22","Exxon",100,2178,1022,1156,0.53076216712580349]
["XYZ","2018-02-26","Exxon",500,11000,5110,5890,0.53545454545454541]
["XYZ","2018-03-06","Exxon",100,2149,1022,1127,0.52442996742671011]
["XYZ","2018-03-08","Exxon",200,4388,2044,2344,0.53418413855970825]
["ABC","2018-03-23","Exxon",600,10404,5082,5322,0.51153402537485582]
["XYZ","2018-04-02","Exxon",400,8804,4088,4716,0.53566560654248074]
["XYZ","2018-04-03","Exxon",500,12425,5110,7315,0.58873239436619718]
["DEF","2018-04-09","Exxon",700,16303,6888,9415,0.57750107342206958]
["ABC","2018-04-24","Exxon",200,3390,1694,1696,0.50029498525073746]
["XYZ","2018-04-30","Exxon",200,4722,2044,2678,0.56713257094451508]
["ABC","2018-05-03","Exxon",1000,18500,8470,10030,0.54216216216216218]
["XYZ","2018-05-04","Exxon",900,21159,9198,11961,0.56529136537643554]
["ABC","2018-05-18","Exxon",1000,21120,8470,12650,0.59895833333333337]
["XYZ","2018-05-30","Exxon",800,17160,8176,8984,0.52354312354312349]
["ABC","2018-06-05","Exxon",900,17289,7623,9666,0.55908381051535661]
["XYZ","2018-06-13","Exxon",200,5002,2044,2958,0.59136345461815276]
["ABC","2018-06-20","Exxon",1000,18530,8470,10060,0.54290339989206693]
["XYZ","2018-07-06","Exxon",200,5002,2044,2958,0.59136345461815276]
["DEF","2018-07-19","Exxon",500,11250,4920,6330,0.56266666666666665]
["XYZ","2018-07-24","Exxon",600,13818,6132,7686,0.55623100303951367]
["XYZ","2018-07-27","Exxon",700,16576,7154,9422,0.56841216216216217]
["DEF","2018-08-09","Exxon",200,4412,1968,2444,{"$f":"+G261/E261","v":0.55394378966455127}]
["DEF","2018-08-17","Exxon",1000,20840,9840,11000,0.52783109404990403]
["XYZ","2018-08-30","Exxon",900,20664,9198,11466,0.55487804878048785]
["ABC","2018-09-04","Exxon",300,5847,2541,3306,0.56541816316059512]
["XYZ","2018-09-06","Exxon",700,17199,7154,10045,0.58404558404558404]
[null,null,"Ford Total",{"$f":"SUBTOTAL(9,D267:D270)","v":2700},{"$f":"SUBTOTAL(9,E267:E270)","v":57516},{"$f":"SUBTOTAL(9,F267:F270)","v":26765},{"$f":"SUBTOTAL(9,G267:G270)","v":30751},0.53465122748452609]
["XYZ","2017-07-26","Ford",800,16784,7872,8912,0.53098188751191611]
["XYZ","2017-08-09","Ford",800,16936,8176,8760,0.51724137931034486]
["XYZ","2018-02-09","Ford",800,18264,8176,10088,0.55234340779675861]
["XYZ","2018-05-31","Ford",300,5532,2541,2991,0.54067245119305862]
[null,null,"General Electric Total",{"$f":"SUBTOTAL(9,D272:D323)","v":26600},{"$f":"SUBTOTAL(9,E272:E323)","v":568851},{"$f":"SUBTOTAL(9,F272:F323)","v":252522},{"$f":"SUBTOTAL(9,G272:G323)","v":316329},0.55608410638286654]
["DEF","2017-01-24","General Electric",900,21708,8856,12852,0.59203980099502485]
["DEF","2017-02-14","General Electric",600,14472,5904,8568,0.59203980099502485]
["ABC","2017-02-28","General Electric",400,7132,3388,3744,0.52495793606281549]
["ABC","2017-03-01","General Electric",200,4784,2044,2740,0.57274247491638797]
["DEF","2017-03-10","General Electric",800,16016,7872,8144,0.50849150849150848]
["ABC","2017-03-16","General Electric",300,5886,2541,3345,0.56829765545361877]
["DEF","2017-03-20","General Electric",400,8776,3936,4840,0.55150410209662715]
["ABC","2017-03-21","General Electric",300,6063,2541,3522,0.58090054428500737]
["ABC","2017-03-22","General Electric",600,11598,5082,6516,0.56182100362131404]
["ABC","2017-04-12","General Electric",500,9380,4235,5145,0.54850746268656714]
["ABC","2017-04-18","General Electric",600,11208,5082,6126,0.54657387580299788]
["ABC","2017-04-27","General Electric",900,18918,9198,9720,0.51379638439581354]
["ABC","2017-05-11","General Electric",700,12838,5929,6909,0.53816793893129766]
["ABC","2017-05-24","General Electric",900,21960,9198,12762,0.58114754098360655]
["DEF","2017-06-02","General Electric",900,21555,8856,12699,0.58914405010438409]
["ABC","2017-06-15","General Electric",600,12984,6132,6852,0.52772643253234752]
["ABC","2017-06-22","General Electric",100,2320,1022,1298,0.55948275862068964]
["ABC","2017-07-03","General Electric",400,8744,4088,4656,0.53247941445562674]
["ABC","2017-08-02","General Electric",900,17712,7623,10089,0.56961382113821135]
["DEF","2017-08-07","General Electric",200,4866,1968,2898,0.59556103575832309]
["ABC","2017-08-31","General Electric",500,9475,4235,5240,0.55303430079155669]
["DEF","2017-09-04","General Electric",500,10645,5110,5535,0.51996242367308598]
["ABC","2017-09-05","General Electric",400,8468,3388,5080,0.59990552668871044]
["DEF","2017-09-08","General Electric",600,14466,5904,8562,0.5918705931148901]
["ABC","2017-09-15","General Electric",200,3672,1694,1978,0.53867102396514166]
["DEF","2017-09-25","General Electric",500,9890,4920,4970,0.50252780586450962]
["DEF","2017-09-26","General Electric",300,7569,3066,4503,0.5949266745937376]
["DEF","2017-10-09","General Electric",600,12888,5904,6984,0.54189944134078216]
["DEF","2017-10-23","General Electric",500,10475,4920,5555,0.53031026252983293]
["DEF","2017-10-30","General Electric",500,11240,5110,6130,0.54537366548042709]
["DEF","2017-10-31","General Electric",400,9204,4088,5116,0.55584528465884397]
["DEF","2017-11-06","General Electric",900,21465,9198,12267,0.5714884696016771]
["DEF","2017-11-07","General Electric",400,9144,4088,5056,0.55293088363954501]
["ABC","2017-11-23","General Electric",500,10445,4235,6210,0.59454284346577313]
["DEF","2017-12-01","General Electric",200,4280,1968,2312,0.54018691588785051]
["DEF","2017-12-13","General Electric",800,18504,7872,10632,0.57457846952010372]
["DEF","2017-12-15","General Electric",1000,20940,10220,10720,0.51193887297039165]
["DEF","2017-12-21","General Electric",400,8620,4088,4532,0.52575406032482597]
["DEF","2018-01-09","General Electric",200,4472,1968,2504,0.55992844364937389]
["ABC","2018-02-08","General Electric",300,6069,2541,3528,0.58131487889273359]
["DEF","2018-03-01","General Electric",500,10385,5110,5275,0.50794415021665862]
["ABC","2018-03-09","General Electric",300,5094,2541,2553,0.50117785630153122]
["ABC","2018-03-27","General Electric",700,13874,5929,7945,0.57265388496468217]
["ABC","2018-03-30","General Electric",800,15400,6776,8624,0.56000000000000005]
["ABC","2018-05-22","General Electric",800,15544,6776,8768,0.56407617086978901]
["ABC","2018-06-12","General Electric",100,1741,847,894,0.51349798966111426]
["DEF","2018-06-19","General Electric",900,22014,9198,12816,0.58217497955846276]
["DEF","2018-06-19","General Electric",400,9672,3936,5736,0.59305210918114148]
["ABC","2018-07-03","General Electric",200,3922,1694,2228,0.56807751147373786]
["DEF","2018-07-17","General Electric",700,13797,6888,6909,0.50076103500761038]
["DEF","2018-08-27","General Electric",200,4696,1968,2728,0.5809199318568995]
["ABC","2018-09-12","General Electric",100,1861,847,1014,0.54486835034927461]
[null,null,"General Motors Total",{"$f":"SUBTOTAL(9,D325:D384)","v":35700},{"$f":"SUBTOTAL(9,E325:E384)","v":750163},{"$f":"SUBTOTAL(9,F325:F384)","v":334614},{"$f":"SUBTOTAL(9,G325:G384)","v":415549},0.55394494263246785]
["ABC","2017-01-03","General Motors",400,8456,3388,5068,{"$f":"+G325/E325","v":0.59933774834437081}]
["ABC","2017-01-12","General Motors",800,14592,6776,7816,0.53563596491228072]
["DEF","2017-01-17","General Motors",700,17150,6888,10262,0.59836734693877547]
["ABC","2017-01-19","General Motors",800,15640,6776,8864,0.56675191815856774]
["ABC","2017-01-27","General Motors",300,5157,2541,2616,0.50727166957533454]
["XYZ","2017-02-10","General Motors",900,21456,9198,12258,0.57130872483221473]
["DEF","2017-03-07","General Motors",1000,20090,9840,10250,0.51020408163265307]
["ABC","2017-03-09","General Motors",300,5358,2541,2817,0.52575587905935051]
["XYZ","2017-03-24","General Motors",1000,20670,10220,10450,0.50556361877116596]
["XYZ","2017-03-31","General Motors",1000,22530,10220,12310,0.54638260097647584]
["ABC","2017-04-21","General Motors",600,11700,5082,6618,0.5656410256410257]
["XYZ","2017-04-26","General Motors",300,6660,3066,3594,0.53963963963963968]
["ABC","2017-04-28","General Motors",700,13986,5929,8057,0.57607607607607603]
["XYZ","2017-05-29","General Motors",300,7593,3066,4527,0.59620703279336229]
["DEF","2017-06-12","General Motors",800,15816,7872,7944,0.50227617602427921]
["XYZ","2017-06-21","General Motors",900,19584,9198,10386,0.53033088235294112]
["ABC","2017-07-27","General Motors",1000,17200,8470,8730,0.50755813953488371]
["XYZ","2017-07-31","General Motors",100,2095,1022,1073,0.51217183770883057]
["DEF","2017-08-01","General Motors",600,13728,5904,7824,0.56993006993006989]
["XYZ","2017-08-04","General Motors",600,12480,6132,6348,0.50865384615384612]
["ABC","2017-08-24","General Motors",800,16008,6776,9232,0.5767116441779111]
["XYZ","2017-09-01","General Motors",100,2343,1022,1321,0.56380708493384546]
["DEF","2017-09-25","General Motors",100,2004,984,1020,0.50898203592814373]
["ABC","2017-10-26","General Motors",600,10290,5082,5208,0.5061224489795918]
["ABC","2017-11-03","General Motors",800,16416,6776,9640,0.58723196881091622]
["DEF","2017-11-29","General Motors",600,12672,5904,6768,0.53409090909090906]
["ABC","2017-12-11","General Motors",200,3876,1694,2182,0.56295149638802888]
["XYZ","2017-12-12","General Motors",1000,25080,10220,14860,0.59250398724082931]
["ABC","2017-12-18","General Motors",700,12145,5929,6216,0.51181556195965416]
["XYZ","2017-12-26","General Motors",500,12505,5110,7395,0.59136345461815276]
["ABC","2017-12-27","General Motors",100,1704,847,857,0.5029342723004695]
["ABC","2018-01-10","General Motors",700,11858,5929,5929,0.5]
["ABC","2018-01-11","General Motors",500,9855,4235,5620,0.57026889903602229]
["XYZ","2018-01-19","General Motors",700,15435,7154,8281,0.53650793650793649]
["ABC","2018-01-24","General Motors",400,8132,3388,4744,0.58337432365961628]
["ABC","2018-01-31","General Motors",900,17172,7623,9549,0.55607966457023061]
["DEF","2018-02-15","General Motors",700,15407,6888,8519,0.55293048614266238]
["DEF","2018-02-27","General Motors",400,9760,3936,5824,0.59672131147540985]
["ABC","2018-03-08","General Motors",700,12803,5929,6874,0.53690541279387638]
["ABC","2018-03-12","General Motors",200,3632,1694,1938,0.53359030837004406]
["DEF","2018-03-14","General Motors",700,16408,6888,9520,0.58020477815699656]
["DEF","2018-04-11","General Motors",500,12270,4920,7350,0.59902200488997559]
["ABC","2018-04-23","General Motors",600,12684,5082,7602,0.59933774834437081]
["DEF","2018-05-01","General Motors",700,16170,6888,9282,0.574025974025974]
["ABC","2018-05-09","General Motors",1000,19530,8470,11060,0.56630824372759858]
["DEF","2018-05-18","General Motors",200,4470,1968,2502,0.55973154362416111]
["DEF","2018-06-04","General Motors",900,18486,8856,9630,0.52093476144109052]
["DEF","2018-06-05","General Motors",100,2106,984,1122,0.53276353276353272]
["DEF","2018-06-29","General Motors",200,4186,1968,2218,0.52986144290492121]
["XYZ","2018-07-23","General Motors",100,2234,1022,1212,0.54252461951656217]
["XYZ","2018-07-30","General Motors",700,17059,7154,9905,0.58063192449733281]
["XYZ","2018-08-03","General Motors",600,13680,6132,7548,0.55175438596491233]
["DEF","2018-08-06","General Motors",600,13200,5904,7296,0.55272727272727273]
["DEF","2018-08-08","General Motors",500,11330,4920,6410,0.56575463371579882]
["XYZ","2018-08-13","General Motors",500,11470,5110,6360,0.55448997384481258]
["XYZ","2018-08-16","General Motors",900,22887,9198,13689,0.59811246559182063]
["DEF","2018-08-21","General Motors",1000,23690,9840,13850,0.58463486703250311]
["DEF","2018-08-24","General Motors",200,4492,1968,2524,0.56188780053428322]
["ABC","2018-08-24","General Motors",1000,17410,8470,8940,0.51349798966111426]
["ABC","2018-09-13","General Motors",900,15363,7623,7740,0.50380785002929118]
[null,null,"HP Total",{"$f":"SUBTOTAL(9,D386:D389)","v":2600},{"$f":"SUBTOTAL(9,E386:E389)","v":55251},{"$f":"SUBTOTAL(9,F386:F389)","v":24632},{"$f":"SUBTOTAL(9,G386:G389)","v":30619},0.55418001484136037]
["ABC","2017-04-17","HP",200,4846,2044,2802,0.57820883202641349]
["ABC","2017-06-14","HP",1000,17840,8470,9370,0.52522421524663676]
["ABC","2017-11-03","HP",900,21015,9198,11817,0.56231263383297647]
["ABC","2018-06-07","HP",500,11550,4920,6630,{"$f":"+G389/E389","v":0.574025974025974}]
[null,null,"IBM Total",{"$f":"SUBTOTAL(9,D391:D434)","v":19700},{"$f":"SUBTOTAL(9,E391:E434)","v":427349},{"$f":"SUBTOTAL(9,F391:F434)","v":189331},{"$f":"SUBTOTAL(9,G391:G434)","v":238018},0.55696398025969407]
["ABC","2017-01-05","IBM",300,6267,2541,3726,0.59454284346577313]
["ABC","2017-01-13","IBM",600,12606,5082,7524,0.59685863874345546]
["ABC","2017-01-25","IBM",1000,19890,8470,11420,0.57415786827551529]
["ABC","2017-02-21","IBM",100,1819,847,972,0.53435953820780646]
["DEF","2017-05-02","IBM",1000,20480,9840,10640,0.51953125]
["XYZ","2017-05-05","IBM",500,12135,5110,7025,0.57890399670374948]
["DEF","2017-05-08","IBM",200,4286,1968,2318,0.54083061129258048]
["ABC","2017-05-16","IBM",500,10330,4235,6095,0.59002904162633107]
["ABC","2017-06-05","IBM",300,5967,2541,3426,0.57415786827551529]
["DEF","2017-06-07","IBM",500,11545,4920,6625,0.57384148982243399]
["DEF","2017-06-26","IBM",600,12030,5904,6126,0.50922693266832919]
["ABC","2017-07-17","IBM",100,1957,847,1110,0.56719468574348497]
["XYZ","2017-08-14","IBM",400,8560,4088,4472,0.52242990654205612]
["DEF","2017-08-15","IBM",1000,20190,9840,10350,0.51263001485884097]
["DEF","2017-09-28","IBM",200,3942,1968,1974,0.50076103500761038]
["ABC","2017-10-05","IBM",100,2111,847,1264,0.59876835622927527]
["ABC","2017-10-10","IBM",100,2108,847,1261,0.59819734345351039]
["XYZ","2017-10-12","IBM",300,6732,3066,3666,0.5445632798573975]
["XYZ","2017-10-18","IBM",100,2213,1022,1191,0.53818346136466333]
["ABC","2017-10-19","IBM",500,8725,4235,4490,0.51461318051575933]
["ABC","2017-11-01","IBM",400,6860,3388,3472,0.5061224489795918]
["ABC","2017-11-22","IBM",400,8128,3388,4740,0.58316929133858264]
["DEF","2017-12-12","IBM",400,9088,3936,5152,0.56690140845070425]
["XYZ","2017-12-18","IBM",700,17367,7154,10213,0.58806932688432079]
["DEF","2017-12-22","IBM",500,11860,4920,6940,0.58516020236087685]
["XYZ","2017-12-27","IBM",300,7305,3066,4239,0.58028747433264882]
["XYZ","2017-12-28","IBM",500,11965,5110,6855,0.57292101964061848]
["DEF","2018-01-01","IBM",500,11695,4920,6775,0.57930739632321504]
["XYZ","2018-01-25","IBM",900,19539,9198,10341,0.52924919391985259]
["DEF","2018-02-22","IBM",700,16765,6888,9877,0.58914405010438409]
["XYZ","2018-03-13","IBM",700,14469,7154,7315,0.50556361877116596]
["DEF","2018-03-21","IBM",800,17944,7872,10072,0.56130182790905037]
["ABC","2018-03-26","IBM",500,8780,4235,4545,0.51765375854214124]
["XYZ","2018-04-05","IBM",400,9816,4088,5728,0.58353708231458845]
["DEF","2018-04-13","IBM",500,11725,4920,6805,0.58038379530916839]
["XYZ","2018-04-16","IBM",900,21366,9198,12168,0.569502948609941]
["XYZ","2018-04-19","IBM",200,4902,2044,2858,0.58302733578131372]
["XYZ","2018-05-25","IBM",300,6438,3066,3372,0.5237651444547996]
["ABC","2018-05-30","IBM",100,2028,847,1181,0.58234714003944776]
["DEF","2018-06-15","IBM",400,8592,3936,4656,0.54189944134078216]
["DEF","2018-06-18","IBM",300,6582,2952,3630,0.55150410209662715]
["DEF","2018-07-10","IBM",500,11530,4920,6610,0.57328707718993932]
["XYZ","2018-08-30","IBM",300,6744,3066,3678,0.54537366548042709]
["ABC","2018-09-07","IBM",100,1968,847,1121,0.56961382113821135]
[null,null,"Kroger Total",{"$f":"SUBTOTAL(9,D436:D439)","v":2000},{"$f":"SUBTOTAL(9,E436:E439)","v":46717},{"$f":"SUBTOTAL(9,F436:F439)","v":19961},{"$f":"SUBTOTAL(9,G436:G439)","v":26756},0.57272513217886423]
["XYZ","2017-04-05","Kroger",800,19520,7872,11648,0.59672131147540985]
["XYZ","2017-07-05","Kroger",100,1819,847,972,0.53435953820780646]
["XYZ","2017-09-21","Kroger",100,2538,1022,1516,0.59732072498029942]
["XYZ","2018-04-23","Kroger",1000,22840,10220,12620,0.5525394045534151]
[null,null,"Lowe's Total",{"$f":"SUBTOTAL(9,D441:D444)","v":1400},{"$f":"SUBTOTAL(9,E441:E444)","v":31369},{"$f":"SUBTOTAL(9,F441:F444)","v":13730},{"$f":"SUBTOTAL(9,G441:G444)","v":17639},0.56230673594950431]
["DEF","2017-06-07","Lowe's",200,4158,1694,2464,0.59259259259259256]
["DEF","2018-05-08","Lowe's",600,13962,6132,7830,0.56080790717662221]
["DEF","2018-06-06","Lowe's",100,2029,984,1045,0.51503203548546084]
["DEF","2018-07-18","Lowe's",500,11220,4920,6300,0.56149732620320858]
[null,null,"Lucent Total",{"$f":"SUBTOTAL(9,D446:D449)","v":3000},{"$f":"SUBTOTAL(9,E446:E449)","v":62744},{"$f":"SUBTOTAL(9,F446:F449)","v":28644},{"$f":"SUBTOTAL(9,G446:G449)","v":34100},0.54347826086956519]
["XYZ","2017-05-25","Lucent",300,7167,3066,4101,0.57220594390958557]
["XYZ","2017-06-13","Lucent",1000,23890,10220,13670,0.57220594390958557]
["XYZ","2018-04-17","Lucent",700,14497,6888,7609,0.5248672139063254]
["XYZ","2018-07-09","Lucent",1000,17190,8470,8720,0.50727166957533454]
[null,null,"Merck Total",{"$f":"SUBTOTAL(9,D451:D454)","v":1900},{"$f":"SUBTOTAL(9,E451:E454)","v":42316},{"$f":"SUBTOTAL(9,F451:F454)","v":18764},{"$f":"SUBTOTAL(9,G451:G454)","v":23552},0.55657434540126671]
["ABC","2017-01-02","Merck",800,18552,7872,10680,0.5756791720569211]
["ABC","2017-01-11","Merck",200,3552,1694,1858,0.5230855855855856]
["ABC","2018-01-08","Merck",100,2484,1022,1462,{"$f":"+G453/E453","v":0.58856682769726243}]
["ABC","2018-02-02","Merck",800,17728,8176,9552,0.53880866425992779]
[null,null,"Motorola Total",{"$f":"SUBTOTAL(9,D456:D459)","v":1400},{"$f":"SUBTOTAL(9,E456:E459)","v":31021},{"$f":"SUBTOTAL(9,F456:F459)","v":13745},{"$f":"SUBTOTAL(9,G456:G459)","v":17276},0.55691305889558684]
["DEF","2017-03-24","Motorola",200,4948,2044,2904,0.58690379951495553]
["DEF","2017-07-03","Motorola",800,17856,8176,9680,0.54211469534050183]
["DEF","2017-08-11","Motorola",100,2358,984,1374,0.58269720101781175]
["DEF","2018-01-16","Motorola",300,5859,2541,3318,0.56630824372759858]
[null,null,"P&G Total",{"$f":"SUBTOTAL(9,D461:D464)","v":2800},{"$f":"SUBTOTAL(9,E461:E464)","v":60299},{"$f":"SUBTOTAL(9,F461:F464)","v":27049},{"$f":"SUBTOTAL(9,G461:G464)","v":33250},0.55141876316356819]
["ABC","2017-02-16","P&G",700,12474,5929,6545,0.52469135802469136]
["ABC","2017-03-14","P&G",800,20408,8176,12232,0.59937279498235985]
["ABC","2017-04-14","P&G",900,17757,8856,8901,0.50126710593005575]
["ABC","2017-10-06","P&G",400,9660,4088,5572,0.57681159420289851]
[null,null,"Phillip Morris Total",{"$f":"SUBTOTAL(9,D466:D469)","v":2300},{"$f":"SUBTOTAL(9,E466:E469)","v":50030},{"$f":"SUBTOTAL(9,F466:F469)","v":21612},{"$f":"SUBTOTAL(9,G466:G469)","v":28418},0.5680191884869078]
["ABC","2017-09-29","Phillip Morris",800,19344,7872,11472,0.59305210918114148]
["ABC","2017-10-03","Phillip Morris",500,10760,4920,5840,0.54275092936802971]
["ABC","2017-12-19","Phillip Morris",200,4614,2044,2570,0.55700043346337236]
["ABC","2018-07-11","Phillip Morris",800,15312,6776,8536,0.55747126436781613]
[null,null,"SBC Communications Total",{"$f":"SUBTOTAL(9,D471:D474)","v":3300},{"$f":"SUBTOTAL(9,E471:E474)","v":72680},{"$f":"SUBTOTAL(9,F471:F474)","v":31946},{"$f":"SUBTOTAL(9,G471:G474)","v":40734},0.56045679691799666]
["DEF","2017-01-11","SBC Communications",800,14440,6776,7664,0.5307479224376731]
["DEF","2017-05-15","SBC Communications",1000,22140,9840,12300,0.55555555555555558]
["DEF","2017-09-15","SBC Communications",1000,24420,10220,14200,0.58149058149058153]
["DEF","2018-09-11","SBC Communications",500,11680,5110,6570,0.5625]
[null,null,"Sears Total",{"$f":"SUBTOTAL(9,D476:D479)","v":1700},{"$f":"SUBTOTAL(9,E476:E479)","v":34710},{"$f":"SUBTOTAL(9,F476:F479)","v":16423},{"$f":"SUBTOTAL(9,G476:G479)","v":18287},0.52685105157015266]
["DEF","2017-05-04","Sears",200,4282,1968,2314,0.54040168145726297]
["DEF","2017-06-01","Sears",400,8876,4088,4788,0.5394321766561514]
["DEF","2018-07-05","Sears",500,8940,4235,4705,0.52628635346756147]
["DEF","2018-07-25","Sears",600,12612,6132,6480,0.51379638439581354]
[null,null,"Southwest Airlines Total",{"$f":"SUBTOTAL(9,D481:D516)","v":18600},{"$f":"SUBTOTAL(9,E481:E516)","v":390978},{"$f":"SUBTOTAL(9,F481:F516)","v":177281},{"$f":"SUBTOTAL(9,G481:G516)","v":213697},0.54657039526520679]
["ABC","2017-01-02","Southwest Airlines",100,2257,984,1273,0.56402303943287546]
["ABC","2017-01-10","Southwest Airlines",100,2042,984,1058,0.51811949069539665]
["ABC","2017-01-23","Southwest Airlines",800,17160,7872,9288,0.54125874125874129]
["XYZ","2017-03-15","Southwest Airlines",100,2466,1022,1444,0.58556366585563668]
["XYZ","2017-03-24","Southwest Airlines",1000,21880,10220,11660,0.53290676416819016]
["ABC","2017-04-20","Southwest Airlines",200,4012,1694,2318,0.57776669990029905]
["XYZ","2017-05-09","Southwest Airlines",500,10650,5110,5540,0.52018779342723009]
["ABC","2017-05-10","Southwest Airlines",1000,19630,8470,11160,0.56851757514009171]
["ABC","2017-07-07","Southwest Airlines",300,6309,2541,3768,0.59724203518782693]
["XYZ","2017-07-18","Southwest Airlines",700,15680,6888,8792,0.56071428571428572]
["XYZ","2017-09-08","Southwest Airlines",800,19376,8176,11200,0.5780346820809249]
["ABC","2017-09-19","Southwest Airlines",900,17136,7623,9513,0.55514705882352944]
["XYZ","2017-09-20","Southwest Airlines",300,6462,2952,3510,0.54317548746518107]
["ABC","2017-09-27","Southwest Airlines",300,5592,2541,3051,0.54560085836909866]
["XYZ","2017-10-20","Southwest Airlines",900,18666,9198,9468,0.50723240115718415]
["ABC","2017-10-23","Southwest Airlines",100,2055,847,1208,0.58783454987834549]
["ABC","2017-10-27","Southwest Airlines",500,10245,4235,6010,0.58662762323084428]
["ABC","2017-11-09","Southwest Airlines",500,9345,4235,5110,0.54681647940074907]
["ABC","2017-12-04","Southwest Airlines",300,6045,2541,3504,0.57965260545905706]
["ABC","2017-12-19","Southwest Airlines",600,11922,5082,6840,0.5737292400603925]
["XYZ","2017-12-20","Southwest Airlines",1000,20490,10220,10270,0.50122010736944855]
["XYZ","2018-01-04","Southwest Airlines",400,8732,4088,4644,0.53183692166743013]
["XYZ","2018-02-14","Southwest Airlines",200,4378,1968,2410,0.55047967108268614]
["XYZ","2018-03-02","Southwest Airlines",700,14203,6888,7315,0.51503203548546084]
["XYZ","2018-03-28","Southwest Airlines",700,15988,7154,8834,0.5525394045534151]
["XYZ","2018-04-04","Southwest Airlines",100,2054,984,1070,0.52093476144109052]
["ABC","2018-04-25","Southwest Airlines",300,6228,2952,3276,0.52601156069364163]
["XYZ","2018-05-01","Southwest Airlines",600,13866,5904,7962,0.57421029857204675]
["ABC","2018-05-02","Southwest Airlines",300,6159,2952,3207,0.52070141256697511]
["ABC","2018-05-29","Southwest Airlines",900,18981,7623,11358,0.59838786154575629]
["XYZ","2018-06-07","Southwest Airlines",600,12936,6132,6804,0.52597402597402598]
["ABC","2018-07-02","Southwest Airlines",700,13195,5929,7266,0.55066312997347477]
["XYZ","2018-07-12","Southwest Airlines",900,19161,9198,9963,0.51996242367308598]
["XYZ","2018-07-24","Southwest Airlines",100,2092,1022,1070,0.51147227533460804]
["XYZ","2018-08-17","Southwest Airlines",600,13290,6132,7158,0.53860045146726865]
["ABC","2018-08-28","Southwest Airlines",500,10295,4920,5375,0.52209810587663918]
[null,null,"State Farm Total",{"$f":"SUBTOTAL(9,D518:D521)","v":2700},{"$f":"SUBTOTAL(9,E518:E521)","v":59881},{"$f":"SUBTOTAL(9,F518:F521)","v":25913},{"$f":"SUBTOTAL(9,G518:G521)","v":33968},{"$f":"+G517/E517","v":0.56725839581837312}]
["DEF","2017-01-03","State Farm",1000,21730,9840,11890,0.54716981132075471]
["DEF","2017-05-22","State Farm",200,4754,1968,2786,0.5860328144720236]
["ABC","2018-03-06","State Farm",700,13853,5929,7924,0.57200606366851947]
["ABC","2018-08-20","State Farm",800,19544,8176,11368,0.58166189111747846]
[null,null,"Texaco Total",{"$f":"SUBTOTAL(9,D523:D526)","v":1600},{"$f":"SUBTOTAL(9,E523:E526)","v":34364},{"$f":"SUBTOTAL(9,F523:F526)","v":15576},{"$f":"SUBTOTAL(9,G523:G526)","v":18788},0.5467349551856594]
["XYZ","2017-01-02","Texaco",400,9152,4088,5064,0.55332167832167833]
["XYZ","2017-01-17","Texaco",400,7136,3388,3748,0.52522421524663676]
["XYZ","2017-11-02","Texaco",600,13806,6132,7674,0.55584528465884397]
["XYZ","2018-05-16","Texaco",200,4270,1968,2302,0.53911007025761126]
[null,null,"Wal-Mart Total",{"$f":"SUBTOTAL(9,D528:D592)","v":40400},{"$f":"SUBTOTAL(9,E528:E592)","v":869454},{"$f":"SUBTOTAL(9,F528:F592)","v":382170},{"$f":"SUBTOTAL(9,G528:G592)","v":487284},0.56044828133518276]
["XYZ","2017-01-04","Wal-Mart",900,21438,9198,12240,0.57094878253568426]
["DEF","2017-01-18","Wal-Mart",300,6714,2952,3762,0.56032171581769441]
["ABC","2017-01-20","Wal-Mart",300,5532,2541,2991,0.54067245119305862]
["ABC","2017-02-02","Wal-Mart",1000,20250,8470,11780,0.58172839506172835]
["ABC","2017-02-03","Wal-Mart",500,10385,4235,6150,0.59220028887818965]
["XYZ","2017-02-06","Wal-Mart",1000,23810,10220,13590,0.57076858462830748]
["XYZ","2017-02-07","Wal-Mart",500,11525,5110,6415,0.5566160520607375]
["XYZ","2017-02-08","Wal-Mart",1000,25140,10220,14920,0.59347653142402546]
["DEF","2017-02-09","Wal-Mart",400,8708,3936,4772,0.54800183739090491]
["XYZ","2017-02-13","Wal-Mart",500,10445,5110,5335,0.5107707036859741]
["XYZ","2017-02-15","Wal-Mart",200,4262,2044,2218,0.52041295166588453]
["DEF","2017-02-20","Wal-Mart",900,19503,8856,10647,0.54591601292108904]
["XYZ","2017-02-22","Wal-Mart",500,10935,5110,5825,0.53269318701417467]
["ABC","2017-02-27","Wal-Mart",800,16696,6776,9920,0.59415428845232388]
["ABC","2017-03-03","Wal-Mart",300,5355,2541,2814,0.52549019607843139]
["ABC","2017-03-06","Wal-Mart",200,3756,1694,2062,0.54898828541001066]
["XYZ","2017-03-27","Wal-Mart",700,15834,7154,8680,0.54818744473916892]
["DEF","2017-03-30","Wal-Mart",500,11435,4920,6515,0.56974202011368602]
["XYZ","2017-04-12","Wal-Mart",500,12625,5110,7515,0.59524752475247522]
["XYZ","2017-04-26","Wal-Mart",800,19152,8176,10976,0.57309941520467833]
["XYZ","2017-05-03","Wal-Mart",200,4264,2044,2220,0.5206378986866792]
["XYZ","2017-05-25","Wal-Mart",900,22716,9198,13518,0.59508716323296351]
["ABC","2017-06-08","Wal-Mart",1000,18660,8470,10190,0.54608788853161838]
["ABC","2017-06-14","Wal-Mart",800,13936,6776,7160,0.51377726750861075]
["ABC","2017-06-16","Wal-Mart",300,5508,2541,2967,0.53867102396514166]
["ABC","2017-07-12","Wal-Mart",100,2012,847,1165,0.57902584493041753]
["DEF","2017-08-02","Wal-Mart",1000,23080,9840,13240,0.57365684575389952]
["ABC","2017-08-03","Wal-Mart",800,13552,6776,6776,0.5]
["XYZ","2017-08-10","Wal-Mart",700,15715,7154,8561,0.54476614699331849]
["DEF","2017-08-25","Wal-Mart",1000,23040,9840,13200,0.57291666666666663]
["ABC","2017-09-11","Wal-Mart",500,8970,4235,4735,0.52787068004459314]
["ABC","2017-09-14","Wal-Mart",400,6880,3388,3492,0.50755813953488371]
["ABC","2017-10-03","Wal-Mart",900,18243,7623,10620,0.58214109521460289]
["ABC","2017-11-08","Wal-Mart",1000,19110,8470,10640,0.5567765567765568]
["XYZ","2017-11-10","Wal-Mart",900,21888,9198,12690,0.57976973684210531]
["ABC","2017-11-20","Wal-Mart",300,6207,2541,3666,0.59062348960850652]
["ABC","2017-11-24","Wal-Mart",800,14224,6776,7448,0.52362204724409445]
["ABC","2017-12-05","Wal-Mart",400,7180,3388,3792,0.52813370473537602]
["ABC","2017-12-07","Wal-Mart",100,2066,847,1219,0.59002904162633107]
["DEF","2018-01-08","Wal-Mart",1000,23820,9840,13980,0.58690176322418131]
["DEF","2018-01-12","Wal-Mart",800,17240,7872,9368,0.54338747099767981]
["DEF","2018-01-26","Wal-Mart",900,20403,8856,11547,0.56594618438464928]
["ABC","2018-02-01","Wal-Mart",400,7376,3388,3988,0.54067245119305862]
["ABC","2018-02-07","Wal-Mart",600,12360,5082,7278,0.58883495145631071]
["ABC","2018-02-16","Wal-Mart",1000,18290,8470,9820,0.53690541279387638]
["DEF","2018-02-21","Wal-Mart",800,17544,7872,9672,0.55129958960328318]
["DEF","2018-02-27","Wal-Mart",700,16772,6888,9884,0.58931552587646074]
["DEF","2018-03-22","Wal-Mart",300,6477,2952,3525,0.54423344140805929]
["DEF","2018-04-06","Wal-Mart",900,18099,8856,9243,0.51069119840875188]
["XYZ","2018-04-10","Wal-Mart",400,8580,4088,4492,0.52354312354312349]
["ABC","2018-04-12","Wal-Mart",900,17883,7623,10260,0.5737292400603925]
["DEF","2018-04-20","Wal-Mart",500,11235,4920,6315,0.56208277703604803]
["DEF","2018-04-27","Wal-Mart",200,4132,1968,2164,0.52371732817037753]
["ABC","2018-05-08","Wal-Mart",200,3418,1694,1724,{"$f":"+G581/E581","v":0.50438853130485661}]
["DEF","2018-05-11","Wal-Mart",600,13368,5904,7464,0.55834829443447043]
["ABC","2018-05-30","Wal-Mart",300,5859,2541,3318,0.56630824372759858]
["DEF","2018-06-20","Wal-Mart",600,14004,5904,8100,0.57840616966580982]
["ABC","2018-06-21","Wal-Mart",700,13139,5929,7210,0.54874800213106023]
["XYZ","2018-06-27","Wal-Mart",500,12760,5110,7650,0.59952978056426331]
["XYZ","2018-06-28","Wal-Mart",1000,24070,10220,13850,0.57540506855006235]
["DEF","2018-07-31","Wal-Mart",700,14784,6888,7896,0.53409090909090906]
["DEF","2018-08-15","Wal-Mart",800,19280,7872,11408,0.59170124481327802]
["XYZ","2018-09-03","Wal-Mart",800,18560,8176,10384,0.55948275862068964]
["XYZ","2018-09-10","Wal-Mart",200,4690,2044,2646,0.56417910447761199]
["DEF","2018-09-11","Wal-Mart",700,14560,6888,7672,0.52692307692307694]

{"sheet":"Wrap Up","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"R.A. asks? Can you filter data that has been subtotaled?"]
[null,"How can you get the subtotals to appear at the top of each group?"]
[null,"When you create the subtotals, uncheck Summary Below Data"]
[null,"Can you use a Filter in a data set that has been subtotaled?"]
[null,"Yes - but you should include blank cells as well"]
[null,"How can you get the percentage calculation to work in the subtotal rows?"]
[null,"Right now, the percentage is totaling the other rows instead of doing the calculation"]
[null,"After adding subtotals, copy the percentage calculation from a non-subtotaled row to all other rows."]