{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Team Performance","Dashboard","Reference","Chart Source","Population"],"not_rendered":{"charts":5,"images":2,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":5},"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":"Team Performance","index":0,"n_rows":103,"n_cols":20,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["Team","Product","Region","Team Members","Sale Date","Login Hours","Total Talk Time","Total Hold Time","Sales","Sales Per Hour","Revenue","Revenue Per Hour","Calls","Excellent","Good","Fair","Poor","Total","CSAT% (Customer Satisfaction)","TTT/Hrs"]
["Team B","Product 1","Florida","Rowan","2014-06-01",8.3000000000000007,7.3000000000000007,0.2,25,3.012048192771084,850,102.40963855421685,348,20,38,30,10,{"$f":"SUM(M2:Q2)","v":446},{"$f":"SUM(N2:O2)/R2","v":0.13004484304932734},{"$f":"G2/F2","v":0.87951807228915668}]
["Team B","Product 2","California","Inez","2014-06-01",7.9,6.9,0.70000000000000018,25,3.1645569620253164,850,107.59493670886076,330,24,32,30,10,{"$f":"SUM(M3:Q3)","v":426},{"$f":"SUM(N3:O3)/R3","v":0.13145539906103287},{"$f":"G3/F3","v":0.87341772151898733}]
["Team E","Product 2","California","Mercedes","2014-06-01",7.3,6.3,0.70000000000000018,25,3.4246575342465753,850,116.43835616438356,338,24,34,33,12,441,0.13151927437641722,0.86301369863013699]
["Team E","Product 2","Hawaii","Zia","2014-06-01",7.5,6.5,0.6,25,3.3333333333333335,850,113.33333333333333,353,22,31,37,13,456,0.1162280701754386,0.8666666666666667]
["Team F","Product 2","Connecticut","Stacy","2014-06-01",7.9,6.9,0.8,25,3.1645569620253164,850,107.59493670886076,383,30,30,36,10,489,0.12269938650306748,0.87341772151898733]
["Team G","Product 2","Connecticut","Rae","2014-06-01",8,7,0.8,25,3.125,850,106.25,373,28,31,40,10,482,0.12240663900414937,0.875]
["Team I","Product 1","Alabama","Serina","2014-06-01",8,7,0.5,25,3.125,850,106.25,333,29,34,35,12,443,0.14221218961625282,0.875]
["Team A","Product 2","Hawaii","Tashya","2014-06-01",7.9,6.9,0.6,24,3.0379746835443036,816,103.29113924050633,379,23,37,33,11,483,0.12422360248447205,0.87341772151898733]
["Team A","Product 2","Connecticut","Farrah","2014-06-01",8,7,0.8,24,3,816,102,321,27,32,40,14,434,0.13594470046082949,0.875]
["Team B","Product 1","Alabama","Xantha","2014-06-01",7.9,6.9,0.5,24,3.0379746835443036,816,103.29113924050633,335,28,31,33,15,442,0.1334841628959276,0.87341772151898733]
["Team B","Product 2","Connecticut","Keelie","2014-06-01",7.5,6.5,0.8,24,3.2,816,108.8,365,29,34,36,14,478,0.13179916317991633,0.8666666666666667]
["Team C","Product 1","Florida","Olympia","2014-06-01",7.5,6.5,0.2,24,3.2,816,108.8,379,20,36,31,14,480,0.11666666666666667,0.8666666666666667]
["Team D","Product 1","Colorado","Ariana","2014-06-01",8.3000000000000007,7.3000000000000007,0.3,24,2.8915662650602405,816,98.313253012048179,369,21,40,34,15,479,0.12734864300626306,0.87951807228915668]
["Team D","Product 2","Connecticut","Kendall","2014-06-01",7.3,6.3,0.8,24,3.2876712328767126,816,111.78082191780823,338,28,35,39,15,455,0.13846153846153847,0.86301369863013699]
["Team E","Product 1","Alabama","Miriam","2014-06-01",8,7,0.5,24,3,816,102,339,30,40,30,11,450,0.15555555555555556,0.875]
["Team H","Product 2","Hawaii","Xerxes","2014-06-01",7.3,6.3,0.6,24,3.2876712328767126,816,111.78082191780823,303,29,38,32,13,415,0.16144578313253011,0.86301369863013699]
["Team I","Product 1","Alabama","Juliet","2014-06-01",8.3000000000000007,7.3000000000000007,0.5,24,2.8915662650602405,816,98.313253012048179,327,20,34,32,10,423,0.1276595744680851,0.87951807228915668]
["Team J","Product 1","Colorado","Fleur","2014-06-01",7.3,6.3,0.3,24,3.2876712328767126,816,111.78082191780823,329,26,36,39,10,440,0.1409090909090909,0.86301369863013699]
["Team A","Product 1","Florida","Libby","2014-06-01",7.3,6.3,0.2,23,3.1506849315068495,782,107.12328767123287,367,27,37,36,12,479,0.1336116910229645,0.86301369863013699]
["Team B","Product 1","Colorado","Iona","2014-06-01",7,6,0.3,23,3.2857142857142856,782,111.71428571428571,369,21,40,34,10,474,0.12869198312236288,0.8571428571428571]
["Team C","Product 2","Connecticut","Renee","2014-06-01",7,6,0.8,23,3.2857142857142856,782,111.71428571428571,397,23,32,33,13,498,0.11044176706827309,0.8571428571428571]
["Team E","Product 1","Alabama","Nevada","2014-06-01",8.3000000000000007,7.3000000000000007,0.5,23,2.7710843373493974,782,94.216867469879503,320,23,30,39,12,424,0.125,0.87951807228915668]
["Team E","Product 1","Colorado","Courtney","2014-06-01",7.9,6.9,0.3,23,2.9113924050632911,782,98.987341772151893,371,29,30,38,12,480,0.12291666666666666,0.87341772151898733]
["Team E","Product 1","Florida","Madeline","2014-06-01",7,6,0.2,23,3.2857142857142856,782,111.71428571428571,368,30,40,38,15,491,0.1425661914460285,0.8571428571428571]
["Team F","Product 2","California","Riley","2014-06-01",8,7,0.70000000000000018,23,2.875,782,97.75,334,30,38,30,11,443,0.15349887133182843,0.875]
["Team H","Product 1","Alabama","Carolyn","2014-06-01",7.9,6.9,0.5,23,2.9113924050632911,782,98.987341772151893,382,23,33,33,11,482,0.11618257261410789,0.87341772151898733]
["Team H","Product 1","Florida","Nomlanga","2014-06-01",8,7,0.2,23,2.875,782,97.75,368,26,31,38,11,474,0.12025316455696203,0.875]
["Team I","Product 1","Florida","Melodie","2014-06-01",7,6,0.2,23,3.2857142857142856,782,111.71428571428571,319,27,38,40,13,437,0.14874141876430205,0.8571428571428571]
["Team A","Product 1","Alabama","Sydnee","2014-06-01",7,6,0.5,22,3.1428571428571428,748,106.85714285714286,358,24,40,32,15,469,0.13646055437100213,0.8571428571428571]
["Team C","Product 1","Colorado","Jana","2014-06-01",7.9,6.9,0.3,22,2.7848101265822782,748,94.683544303797461,341,22,30,31,14,438,0.11872146118721461,0.87341772151898733]
["Team E","Product 1","Florida","Lacy","2014-06-01",7.9,6.9,0.2,22,2.7848101265822782,748,94.683544303797461,377,27,30,34,10,478,0.1192468619246862,0.87341772151898733]
["Team F","Product 1","Alabama","Shelby","2014-06-01",7.5,6.5,0.5,22,2.9333333333333331,748,99.733333333333334,389,20,39,39,13,500,0.11799999999999999,0.8666666666666667]
["Team G","Product 2","California","Pamela","2014-06-01",7.5,6.5,0.70000000000000018,22,2.9333333333333331,748,99.733333333333334,326,29,33,38,13,439,0.14123006833712984,0.8666666666666667]
["Team G","Product 1","Alabama","Dana","2014-06-01",7.6,6.6,0.5,22,2.8947368421052633,748,98.421052631578945,396,27,30,38,15,{"$f":"SUM(M35:Q35)","v":506},{"$f":"SUM(N35:O35)/R35","v":0.11264822134387352},0.86842105263157898]
["Team J","Product 2","California","Jena","2014-06-01",8.3000000000000007,7.3000000000000007,0.70000000000000018,22,2.6506024096385539,748,90.120481927710841,386,20,39,38,12,495,0.1191919191919192,0.87951807228915668]
["Team J","Product 2","Connecticut","Illiana","2014-06-01",7.9,6.9,0.8,22,2.7848101265822782,748,94.683544303797461,332,22,39,32,11,436,0.13990825688073394,0.87341772151898733]
["Team A","Product 2","Connecticut","Nola","2014-06-01",8.3000000000000007,7.3000000000000007,0.8,21,2.5301204819277108,714,86.024096385542165,327,25,36,33,12,433,0.14087759815242495,0.87951807228915668]
["Team B","Product 2","Hawaii","Quyn","2014-06-01",7.3,6.3,0.6,21,2.8767123287671232,714,97.808219178082197,381,23,34,36,11,485,0.11752577319587629,0.86301369863013699]
["Team C","Product 2","Hawaii","Camille","2014-06-01",8,7,0.6,21,2.625,714,89.25,348,22,30,37,14,451,0.11529933481152993,0.875]
["Team G","Product 1","Alabama","Katelyn","2014-06-01",7,6,0.5,21,3,714,102,322,24,30,32,14,422,0.12796208530805686,0.8571428571428571]
["Team G","Product 1","Colorado","Rhoda","2014-06-01",8,7,0.3,21,2.625,714,89.25,339,25,32,31,14,441,0.12925170068027211,0.875]
["Team H","Product 2","California","Zenia","2014-06-01",7.6,6.6,0.70000000000000018,21,2.763157894736842,714,93.94736842105263,316,28,36,35,11,426,0.15023474178403756,0.86842105263157898]
["Team H","Product 2","Connecticut","Ashely","2014-06-01",7.5,6.5,0.8,21,2.8,714,95.2,391,27,31,35,13,497,0.11670020120724346,0.8666666666666667]
["Team I","Product 2","Hawaii","Yolanda","2014-06-01",7.5,6.5,0.6,21,2.8,714,95.2,329,24,32,33,14,432,0.12962962962962962,0.8666666666666667]
["Team J","Product 1","Colorado","Alec","2014-06-01",8.3000000000000007,7.3000000000000007,0.3,21,2.5301204819277108,714,86.024096385542165,300,23,39,34,14,410,0.15121951219512195,0.87951807228915668]
["Team A","Product 1","Colorado","Darryl","2014-06-01",7.5,6.5,0.3,20,2.6666666666666665,680,90.666666666666671,394,30,38,35,13,510,0.13333333333333333,0.8666666666666667]
["Team D","Product 2","California","Daria","2014-06-01",8.3000000000000007,7.3000000000000007,0.70000000000000018,20,2.4096385542168672,680,81.92771084337349,357,24,30,39,11,461,0.11713665943600868,0.87951807228915668]
["Team F","Product 2","Hawaii","Shelley","2014-06-01",7,6,0.6,20,2.8571428571428572,680,97.142857142857139,333,20,31,34,13,431,0.11832946635730858,0.8571428571428571]
["Team F","Product 1","Colorado","Cleo","2014-06-01",8.3000000000000007,7.3000000000000007,0.3,20,2.4096385542168672,680,81.92771084337349,307,28,33,32,12,412,0.14805825242718446,0.87951807228915668]
["Team G","Product 2","Connecticut","Deanna","2014-06-01",8.3000000000000007,7.3000000000000007,0.8,20,2.4096385542168672,680,81.92771084337349,390,21,33,35,13,492,0.10975609756097561,0.87951807228915668]
["Team G","Product 2","California","Regina","2014-06-01",7,6,0.70000000000000018,20,2.8571428571428572,680,97.142857142857139,372,21,39,35,13,480,0.125,0.8571428571428571]
["Team J","Product 1","Alabama","Luke","2014-06-01",7.5,6.5,0.5,20,2.6666666666666665,680,90.666666666666671,396,24,39,31,10,500,0.126,0.8666666666666667]
["Team A","Product 2","California","Amber","2014-06-01",7.5,6.5,0.70000000000000018,19,2.5333333333333332,646,86.13333333333334,323,20,35,34,15,427,0.1288056206088993,0.8666666666666667]
["Team A","Product 2","California","Guinevere","2014-06-01",7,6,0.70000000000000018,19,2.7142857142857144,646,92.285714285714292,380,21,32,33,11,477,0.1111111111111111,0.8571428571428571]
["Team B","Product 1","Florida","Brynne","2014-06-01",8,7,0.2,19,2.375,646,80.75,370,27,38,33,14,482,0.13485477178423236,0.875]
["Team C","Product 1","Alabama","Shaine","2014-06-01",8.3000000000000007,7.3000000000000007,0.5,19,2.2891566265060237,646,77.831325301204814,356,28,38,40,14,476,0.13865546218487396,0.87951807228915668]
["Team C","Product 2","California","Maris","2014-06-01",7.3,6.3,0.70000000000000018,19,2.6027397260273974,646,88.493150684931507,354,28,38,36,11,467,0.14132762312633834,0.86301369863013699]
["Team D","Product 1","Florida","Aileen","2014-06-01",7.6,6.6,0.2,19,2.5,646,85,324,22,36,39,14,435,0.13333333333333333,0.86842105263157898]
["Team D","Product 2","Hawaii","Cheyenne","2014-06-01",7,6,0.6,19,2.7142857142857144,646,92.285714285714292,307,24,33,40,11,415,0.13734939759036144,0.8571428571428571]
["Team F","Product 1","Colorado","Ivory","2014-06-01",7.3,6.3,0.3,19,2.6027397260273974,646,88.493150684931507,316,30,40,36,15,437,0.16018306636155608,0.86301369863013699]
["Team F","Product 2","Connecticut","Patricia","2014-06-01",7.3,6.3,0.8,19,2.6027397260273974,646,88.493150684931507,378,24,35,37,13,487,0.12114989733059549,0.86301369863013699]
["Team G","Product 1","Florida","Mallory","2014-06-01",7.3,6.3,0.2,19,2.6027397260273974,646,88.493150684931507,330,30,33,40,13,446,0.14125560538116591,0.86301369863013699]
["Team H","Product 2","California","Hilary","2014-06-01",7.9,6.9,0.70000000000000018,19,2.4050632911392404,646,81.77215189873418,302,28,32,34,15,411,0.145985401459854,0.87341772151898733]
["Team I","Product 2","California","Karyn","2014-06-01",7.3,6.3,0.70000000000000018,19,2.6027397260273974,646,88.493150684931507,317,25,32,38,13,425,0.13411764705882354,0.86301369863013699]
["Team B","Product 2","California","Winifred","2014-06-01",7.6,6.6,0.70000000000000018,18,2.3684210526315792,612,80.526315789473685,327,23,30,33,11,424,0.125,0.86842105263157898]
["Team B","Product 1","Alabama","Gay","2014-06-01",7.3,6.3,0.5,18,2.4657534246575343,612,83.835616438356169,316,28,33,34,11,{"$f":"SUM(M67:Q67)","v":422},{"$f":"SUM(N67:O67)/R67","v":0.14454976303317535},{"$f":"G67/F67","v":0.86301369863013699}]
["Team D","Product 1","Alabama","Dara","2014-06-01",8,7,0.5,18,2.25,612,76.5,364,21,32,37,13,467,0.11349036402569593,0.875]
["Team F","Product 2","Hawaii","Tatum","2014-06-01",7.6,6.6,0.6,18,2.3684210526315792,612,80.526315789473685,370,22,33,32,15,472,0.11652542372881355,0.86842105263157898]
["Team J","Product 2","California","Addison","2014-06-01",8,7,0.70000000000000018,18,2.25,612,76.5,350,29,30,32,12,453,0.13024282560706402,0.875]
["Team E","Product 2","Hawaii","Heather","2014-06-01",7.6,6.6,0.6,17,2.236842105263158,578,76.05263157894737,398,28,31,32,10,499,0.11823647294589178,0.86842105263157898]
["Team E","Product 2","Connecticut","Amanda","2014-06-01",7.6,6.6,0.8,17,2.236842105263158,578,76.05263157894737,347,20,40,35,15,457,0.13129102844638948,0.86842105263157898]
["Team H","Product 1","Colorado","Phyllis","2014-06-01",7,6,0.3,17,2.4285714285714284,578,82.571428571428569,334,29,31,30,11,435,0.13793103448275862,0.8571428571428571]
["Team I","Product 1","Colorado","Gretchen","2014-06-01",7.6,6.6,0.3,17,2.236842105263158,578,76.05263157894737,323,27,38,36,11,435,0.14942528735632185,0.86842105263157898]
["Team I","Product 1","Florida","Galena","2014-06-01",7.5,6.5,0.2,17,2.2666666666666666,578,77.066666666666663,397,29,31,32,10,499,0.12024048096192384,0.8666666666666667]
["Team J","Product 2","Hawaii","Oscar","2014-06-01",7,6,0.6,17,2.4285714285714284,578,82.571428571428569,327,21,38,36,12,434,0.13594470046082949,0.8571428571428571]
["Team J","Product 2","Hawaii","Abel","2014-06-01",7,6,0.6,17,2.4285714285714284,578,82.571428571428569,327,21,38,36,12,434,0.13594470046082949,0.8571428571428571]
["Team A","Product 1","Colorado","Constance","2014-06-01",8,7,0.3,16,2,544,68,310,29,32,30,11,412,0.14805825242718446,0.875]
["Team C","Product 2","Connecticut","Audra","2014-06-01",7.6,6.6,0.8,16,2.1052631578947367,544,71.578947368421055,376,28,39,33,12,488,0.13729508196721313,0.86842105263157898]
["Team C","Product 1","Florida","Rosalyn","2014-06-01",7,6,0.2,16,2.2857142857142856,544,77.714285714285708,353,27,37,35,12,464,0.13793103448275862,0.8571428571428571]
["Team D","Product 2","Connecticut","Hermione","2014-06-01",7.9,6.9,0.8,16,2.0253164556962022,544,68.860759493670884,398,29,31,33,11,502,0.11952191235059761,0.87341772151898733]
["Team D","Product 1","Alabama","Lois","2014-06-01",7.5,6.5,0.5,16,2.1333333333333333,544,72.533333333333331,327,28,33,37,12,437,0.13958810068649885,0.8666666666666667]
["Team D","Product 2","California","Madeson","2014-06-01",8,7,0.70000000000000018,16,2,544,68,394,29,37,34,11,505,0.1306930693069307,0.875]
["Team E","Product 2","California","Quin","2014-06-01",8.3000000000000007,7.3000000000000007,0.70000000000000018,16,1.9277108433734937,544,65.542168674698786,395,23,35,37,12,502,0.11553784860557768,0.87951807228915668]
["Team F","Product 1","Florida","Dai","2014-06-01",7.6,6.6,0.2,16,2.1052631578947367,544,71.578947368421055,336,23,38,35,10,442,0.13800904977375567,0.86842105263157898]
["Team G","Product 1","Colorado","Kirby","2014-06-01",7.5,6.5,0.3,16,2.1333333333333333,544,72.533333333333331,352,23,39,32,14,460,0.13478260869565217,0.8666666666666667]
["Team H","Product 1","Florida","Frances","2014-06-01",8.3000000000000007,7.3000000000000007,0.2,16,1.9277108433734937,544,65.542168674698786,394,27,37,37,10,505,0.12673267326732673,0.87951807228915668]
["Team H","Product 2","Hawaii","Kirestin","2014-06-01",8.3000000000000007,7.3000000000000007,0.6,16,1.9277108433734937,544,65.542168674698786,376,25,36,33,11,481,0.12681912681912683,0.87951807228915668]
["Team I","Product 2","Connecticut","Giselle","2014-06-01",7,6,0.8,16,2.2857142857142856,544,77.714285714285708,400,30,32,38,15,515,0.12038834951456311,0.8571428571428571]
["Team I","Product 1","Colorado","Noelani","2014-06-01",7.9,6.9,0.3,16,2.0253164556962022,544,68.860759493670884,365,30,35,33,14,477,0.13626834381551362,0.87341772151898733]
["Team I","Product 2","Connecticut","Portia","2014-06-01",7.6,6.6,0.8,16,2.1052631578947367,544,71.578947368421055,396,25,39,37,11,508,0.12598425196850394,0.86842105263157898]
["Team A","Product 1","Alabama","Flavia","2014-06-01",7.6,6.6,0.5,15,1.9736842105263159,510,67.10526315789474,302,24,37,33,12,408,0.14950980392156862,0.86842105263157898]
["Team B","Product 2","Hawaii","Sierra","2014-06-01",8.3000000000000007,7.3000000000000007,0.6,15,1.8072289156626504,510,61.445783132530117,302,21,34,36,13,406,0.1354679802955665,0.87951807228915668]
["Team C","Product 1","Colorado","Illana","2014-06-01",7.6,6.6,0.3,15,1.9736842105263159,510,67.10526315789474,356,21,35,35,10,457,0.12253829321663019,0.86842105263157898]
["Team C","Product 2","Hawaii","April","2014-06-01",7.5,6.5,0.6,15,2,510,68,324,25,32,31,14,426,0.13380281690140844,0.8666666666666667]
["Team D","Product 1","Colorado","Ariel","2014-06-01",7.3,6.3,0.3,15,2.0547945205479454,510,69.863013698630141,301,27,39,39,11,417,0.15827338129496402,0.86301369863013699]
["Team F","Product 1","Florida","Britanney","2014-06-01",7.9,6.9,0.2,15,1.8987341772151898,510,64.556962025316452,357,27,30,31,12,457,0.12472647702407003,0.87341772151898733]
["Team G","Product 2","Hawaii","Medge","2014-06-01",7.9,6.9,0.6,15,1.8987341772151898,510,64.556962025316452,392,27,30,30,12,491,0.11608961303462322,0.87341772151898733]
["Team H","Product 1","Alabama","Serena","2014-06-01",7.3,6.3,0.5,15,2.0547945205479454,510,69.863013698630141,359,25,37,34,10,{"$f":"SUM(M99:Q99)","v":465},{"$f":"SUM(N99:O99)/R99","v":0.13333333333333333},0.86301369863013699]
["Team I","Product 2","Hawaii","Calista","2014-06-01",8,7,0.6,15,1.875,510,63.75,327,27,33,37,13,437,0.13729977116704806,0.875]
["Team J","Product 1","Florida","Jeremy","2014-06-01",7.6,6.6,0.2,15,1.9736842105263159,510,67.10526315789474,384,21,37,39,11,492,0.11788617886178862,0.86842105263157898]
["Team J","Product 2","Connecticut","Rafael","2014-06-01",7.3,6.3,0.8,15,2.0547945205479454,510,69.863013698630141,316,29,35,33,10,423,0.15130023640661938,0.86301369863013699]
["Team J","Product 1","Florida","Hoyt","2014-06-01",7.6,6.6,0.2,15,1.9736842105263159,510,67.10526315789474,384,21,37,39,11,{"$f":"SUM(M103:Q103)","v":492},{"$f":"SUM(N103:O103)/R103","v":0.11788617886178862},0.86842105263157898]

{"sheet":"Dashboard","index":1,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,6,1,23],[3,0,4,5],[0,0,0,23],[2,3,2,5],[1,0,1,5],[2,0,2,2],[26,1,26,2],[26,3,26,4],[23,1,23,2],[23,3,23,4],[2,6,14,23],[19,7,19,10],[15,6,18,23],[22,1,22,4],[24,1,24,2],[24,3,24,4],[25,1,25,2],[25,3,25,4]]}
[{"$f":"CONCATENATE(\"Daily Team Performance Dashboard for \",TEXT(MAX('Team Performance'!$E:$E),\"Mmmm dd, yyyy\"))","v":"Daily Team Performance Dashboard for June 01, 2014"}]
[]
["Select Category",null,null,"Select Segment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Revenue per Capita by Region (in Thousands)"]
[null,null,null,null,null,null,null,{"$f":"Reference!R1","v":"Region"},{"$f":"Reference!S1","v":"Revenue"},{"$f":"Reference!T1","v":"Population"},{"$f":"Reference!U1","v":"Rev. Per Capita"}]
[null,null,null,null,null,null,null,{"$f":"Reference!R2","v":"Alabama"},{"$f":"Reference!S2","v":11934},{"$f":"Reference!T2","v":4779736},{"$f":"Reference!U2","v":2.4967906177244936}]
[null,"Top Team Members by Revenue",null,null,null,null,null,{"$f":"Reference!R3","v":"California"},{"$f":"Reference!S3","v":11594},{"$f":"Reference!T3","v":37253956},{"$f":"Reference!U3","v":0.31121527066816745}]
[null,"Name",null,"Revenue",null,null,null,{"$f":"Reference!R4","v":"Colorado"},{"$f":"Reference!S4","v":11186},{"$f":"Reference!T4","v":5029196},{"$f":"Reference!U4","v":2.224212379076099}]
[null,{"$f":"Reference!M6","v":"Farrah"},null,{"$f":"Reference!N6","v":816},null,null,null,{"$f":"Reference!R5","v":"Connecticut"},{"$f":"Reference!S5","v":11696},{"$f":"Reference!T5","v":3574097},{"$f":"Reference!U5","v":3.2724349674896902}]
[null,{"$f":"Reference!M7","v":"Tashya"},null,{"$f":"Reference!N7","v":816},null,null,null,{"$f":"Reference!R6","v":"Florida"},{"$f":"Reference!S6","v":11220},{"$f":"Reference!T6","v":18801310},{"$f":"Reference!U6","v":0.59676692741090909}]
[null,{"$f":"Reference!M8","v":"Libby"},null,{"$f":"Reference!N8","v":782},null,null,null,{"$f":"Reference!R7","v":"Hawaii"},{"$f":"Reference!S7","v":10880},{"$f":"Reference!T7","v":1360301},{"$f":"Reference!U7","v":7.9982298035508315}]

{"sheet":"Reference","index":2,"n_rows":11,"n_cols":21,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Segment",null,"Team","Product","Region",null,"Category","Segment",null,"Segment Stats",null,null,"Team","Team A",null,{"$f":"OFFSET('Team Performance'!$D$1,MATCH(MAX('Team Performance'!$S:$S),'Team Performance'!$S:$S,0)-1,0)","v":"Xerxes"},null,"Region","Revenue","Population","Rev. Per Capita"]
["Team",null,"Team A","Product 1","Alabama",null,1,"Team A",null,"Sales per Hour",{"$f":"IFERROR(SUMIF(OFFSET('Team Performance'!A1,0,Reference!G2-1,104,1),H2,'Team Performance'!I:I)/SUMIF(OFFSET('Team Performance'!A1,0,Reference!G2-1,104,1),H2,'Team Performance'!F:F),\"\")","v":2.6675427069645208},null,"Product","(All)",null,null,null,"Alabama",{"$f":"SUMIF('Team Performance'!C:C,Reference!R2,'Team Performance'!K:K)","v":11934},{"$f":"SUMIF(Population!A:A,Reference!R2,Population!B:B)","v":4779736},{"$f":"(1000*S2/T2)","v":2.4967906177244936}]
["Product",null,"Team B","Product 2","California",null,null,null,null,"Revenue per Hour",{"$f":"IFERROR(SUMIF(OFFSET('Team Performance'!A1,0,Reference!G2-1,104,1),H2,'Team Performance'!K:K)/SUMIF(OFFSET('Team Performance'!A1,0,Reference!G2-1,104,1),H2,'Team Performance'!F:F),\"\")","v":90.696452036793701},null,"Region","(All)",null,null,null,"California",{"$f":"SUMIF('Team Performance'!C:C,Reference!R3,'Team Performance'!K:K)","v":11594},{"$f":"SUMIF(Population!A:A,Reference!R3,Population!B:B)","v":37253956},{"$f":"(1000*S3/T3)","v":0.31121527066816745}]
["Region",null,"Team C",null,"Colorado",null,null,null,null,"Average CSAT%",{"$f":"IFERROR(AVERAGEIF(OFFSET('Team Performance'!A1,0,Reference!G2-1,104,1),H2,'Team Performance'!S:S),\"\")","v":0.13419362678937899},null,null,null,null,null,null,"Colorado",{"$f":"SUMIF('Team Performance'!C:C,Reference!R4,'Team Performance'!K:K)","v":11186},{"$f":"SUMIF(Population!A:A,Reference!R4,Population!B:B)","v":5029196},2.224212379076099]
[null,null,"Team D",null,"Connecticut",null,null,null,null,"Sales",{"$f":"SUMIF(OFFSET('Team Performance'!A1,0,Reference!G2-1,104,1),H2,'Team Performance'!I:I)","v":203},null,"Row Labels","Sum of Revenue",null,null,null,"Connecticut",{"$f":"SUMIF('Team Performance'!C:C,Reference!R5,'Team Performance'!K:K)","v":11696},{"$f":"SUMIF(Population!A:A,Reference!R5,Population!B:B)","v":3574097},3.2724349674896902]
[null,null,"Team E",null,"Florida",null,null,null,null,null,null,null,"Farrah",816,null,null,null,"Florida",{"$f":"SUMIF('Team Performance'!C:C,Reference!R6,'Team Performance'!K:K)","v":11220},{"$f":"SUMIF(Population!A:A,Reference!R6,Population!B:B)","v":18801310},0.59676692741090909]
[null,null,"Team F",null,"Hawaii",null,null,null,null,null,null,null,"Tashya",816,null,null,null,"Hawaii",{"$f":"SUMIF('Team Performance'!C:C,Reference!R7,'Team Performance'!K:K)","v":10880},{"$f":"SUMIF(Population!A:A,Reference!R7,Population!B:B)","v":1360301},7.9982298035508315]
[null,null,"Team G",null,null,null,null,null,null,null,null,null,"Libby",782]
[null,null,"Team H",null,null,null,null,null,null,null,null,null,"Grand Total",2414]
[null,null,"Team I"]
[null,null,"Team J"]

{"sheet":"Chart Source","index":3,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Sale Date","(All)",null,"Sale Date","(All)",null,"Sale Date","(All)",null,"Sale Date","(All)"]
[]
["Row Labels","Avg CSAT%",null,"Row Labels","Avg CSAT%",null,"Row Labels","Avg CSAT%",null,"Row Labels","Revenue by Team"]
["Team A",0.13419362678937899,null,"Product 1",0.13318018187645453,null,"Alabama",0.13178186725635335,null,"Team A",6902]
["Team B",0.13128738396174175,null,"Product 2",0.12910148725603707,null,"California",0.13129929884723368,null,"Team B",7208]
["Team C",0.12726795416129072,null,"Grand Total",0.13114083456624581,null,"Colorado",0.13811240653988771,null,"Team C",6460]
["Team D",0.1315196399492192,null,null,null,null,"Connecticut",0.12799565332139029,null,"Team D",6358]
["Team E",0.12780979701426515,null,null,null,null,"Florida",0.12964627183312238,null,"Team E",7310]
["Team F",0.13211798908381794,null,null,null,null,"Hawaii",0.12800950959948731,null,"Team F",6698]
["Team G",0.12603826393458989,null,null,null,null,"Grand Total",0.13114083456624578,null,"Team G",6834]
["Team H",0.13356180326572803,null,null,null,null,null,null,null,"Team H",6630]
["Team I",0.1338151767564516,null,null,null,null,null,null,null,"Team I",7106]
["Team J",0.13331214543961686,null,null,null,null,null,null,null,"Team J",7004]
["Grand Total",0.13114083456624576,null,null,null,null,null,null,null,"Grand Total",68510]
[]
[{"$f":"IF(ISBLANK(A3),\"\",A3)","v":"Row Labels"},{"$f":"IF(ISBLANK(B3),\"\",B3)","v":"Avg CSAT%"},"","Row Labels","Avg CSAT%","","Row Labels","Avg CSAT%","","Row Labels","Revenue by Team"]
[{"$f":"IF(ISBLANK(A4),\"\",A4)","v":"Team A"},0.13419362678937899,"","Product 1",0.13318018187645453,"","Alabama",0.13178186725635335,"","Team A",6902]
[{"$f":"IF(ISBLANK(A5),\"\",A5)","v":"Team B"},0.13128738396174175,"","Product 2",0.12910148725603707,"","California",0.13129929884723368,"","Team B",7208]
[{"$f":"IF(ISBLANK(A6),\"\",A6)","v":"Team C"},0.12726795416129072,"","Grand Total",0.13114083456624581,"","Colorado",0.13811240653988771,"","Team C",6460]
[{"$f":"IF(ISBLANK(A7),\"\",A7)","v":"Team D"},0.1315196399492192,"","","","","Connecticut",0.12799565332139029,"","Team D",6358]
[{"$f":"IF(ISBLANK(A8),\"\",A8)","v":"Team E"},0.12780979701426515,"","","","","Florida",0.12964627183312238,"","Team E",7310]
[{"$f":"IF(ISBLANK(A9),\"\",A9)","v":"Team F"},0.13211798908381794,"","","","","Hawaii",0.12800950959948731,"","Team F",6698]
[{"$f":"IF(ISBLANK(A10),\"\",A10)","v":"Team G"},0.12603826393458989,"","","","","Grand Total",0.13114083456624578,"","Team G",6834]
[{"$f":"IF(ISBLANK(A11),\"\",A11)","v":"Team H"},0.13356180326572803,"","","","","","","","Team H",6630]
[{"$f":"IF(ISBLANK(A12),\"\",A12)","v":"Team I"},0.1338151767564516,"","","","","","","","Team I",7106]
[{"$f":"IF(ISBLANK(A13),\"\",A13)","v":"Team J"},0.13331214543961686,"","","","","","","","Team J",7004]
[{"$f":"IF(ISBLANK(A14),\"\",A14)","v":"Grand Total"},0.13114083456624576,"","","","","","","","Grand Total",68510]
[{"$f":"IF(ISBLANK(A15),\"\",A15)","v":""},"","","","","","","","","",""]

{"sheet":"Population","index":4,"n_rows":53,"n_cols":2,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["State or territory","Census population"]
["California",37253956]
["Texas",25145561]
["New York",19378102]
["Florida",18801310]
["Illinois",12830632]
["Pennsylvania",12702379]
["Ohio",11536504]
["Georgia",9687653]
["Michigan",9883640]
["North Carolina",9535483]
["New Jersey",8791894]
["Virginia",8001024]
["Washington",6724540]
["Massachusetts",6547629]
["Arizona",6392017]
["Indiana",6483802]
["Tennessee",6346105]
["Missouri",5988927]
["Maryland",5773552]
["Wisconsin",5686986]
["Minnesota",5303925]
["Colorado",5029196]
["Alabama",4779736]
["South Carolina",4625364]
["Louisiana",4533372]
["Kentucky",4339367]
["Oregon",3831074]
["Oklahoma",3751351]
["Puerto Rico",3725789]
["Connecticut",3574097]
["Iowa",3046355]
["Mississippi",2967297]
["Arkansas",2915918]
["Utah",2763885]
["Kansas",2853118]
["Nevada",2700551]
["New Mexico",2059179]
["Nebraska",1826341]
["West Virginia",1852994]
["Idaho",1567582]
["Hawaii",1360301]
["Maine",1328361]
["New Hampshire",1316470]
["Rhode Island",1052567]
["Montana",989415]
["Delaware",897934]
["South Dakota",814180]
["Alaska",710231]
["North Dakota",672591]
["District of Columbia",601723]
["Vermont",625741]
["Wyoming",563626]