{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["US Map","LinkData","Lookup_Tables","Data","Control","Dashboard"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":51,"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":"US Map","index":0,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"LinkData","index":1,"n_rows":193,"n_cols":20,"rows_kept":193,"cut":false,"hidden":true,"merged":[]}
["Team","Team Members","Product","Sales Month","State","Region","Login Hours","Total Talk Time","Total Hold Time","Sales","Sales Per Hour","Revenue","Revenue Per Hour","Calls","Excellent Calls","Good Calls","Fair Calls","Poor Calls","Total Calls","CSAT% (Customer Satisfaction)"]
["Team A","Quagmire","Product 1","2014-06-01","California","Far West",7.3,6.3,{"$f":"G2-H2","v":1},18,{"$f":"J2/G2","v":2.4657534246575343},612,{"$f":"L2/G2","v":83.835616438356169},316,28,33,34,11,{"$f":"SUM(N2:R2)","v":422},{"$f":"SUM(O2:P2)/S2","v":0.14454976303317535}]
["Team A","Nola","Product 2","2014-07-01","California","Far West",8.3000000000000007,7.3000000000000007,{"$f":"G3-H3","v":1},21,{"$f":"J3/G3","v":2.5301204819277108},714,{"$f":"L3/G3","v":86.024096385542165},327,25,36,33,12,{"$f":"SUM(N3:R3)","v":433},{"$f":"SUM(O3:P3)/S3","v":0.14087759815242495}]
["Team A","Abel","Product 1","2014-08-01","California","Far West",8.3000000000000007,7.9,0.40000000000000036,15.5,1.8674698795180722,725.4,87.397590361445779,325.10000000000002,26.6,36.4,34.9,10.8,433.8,0.14522821576763484]
["Team A","Angel","Product 2","2014-09-01","California","Far West",7,6.4,0.59999999999999964,22.7,3.2428571428571429,544.9,77.842857142857142,399.9,26.6,34.5,34.6,10.6,506.20000000000005,0.12070327933623073]
["Team A","Quin","Product 2","2014-06-01","Nevada","Far West",8.3000000000000007,7.3000000000000007,1,16,1.9277108433734937,544,65.542168674698786,395,23,35,37,12,502,0.11553784860557768]
["Team A","Aileen","Product 1","2014-07-01","Nevada","Far West",7.6,6.6,1,19,2.5,646,85,324,22,36,39,14,435,0.13333333333333333]
["Team A","Alexis","Product 1","2014-08-01","Nevada","Far West",7.4,6.8000000000000007,0.59999999999999964,16.7,2.2567567567567566,735.5,99.391891891891888,340.1,20.7,38.1,34.700000000000003,11.7,445.3,0.13204581181226138]
["Team A","Aron","Product 2","2014-09-01","Nevada","Far West",21,6.6000000000000005,14.399999999999999,21,1,635.6,30.266666666666669,337.2,27.6,35.9,35.700000000000003,13.3,449.7,0.14120524794307315]
["Team A","Constance","Product 1","2014-06-01","Oregon","Far West",8,7,1,16,2,544,68,310,29,32,30,11,412,0.14805825242718446]
["Team A","Melodie","Product 1","2014-07-01","Oregon","Far West",7,6,1,23,3.2857142857142856,782,111.71428571428571,456,27,38,40,13,574,0.1132404181184669]
["Team A","Alonzo","Product 1","2014-08-01","Oregon","Far West",7.9,7.5,0.40000000000000036,21.4,2.7088607594936707,676,85.569620253164558,392,26.4,30.2,30.8,12,491.4,0.11518111518111518]
["Team A","Augustine","Product 2","2014-09-01","Oregon","Far West",7.4,6.9,0.5,23.4,3.1621621621621618,687,92.837837837837839,341.1,22.3,38.6,30.8,11.2,444.00000000000006,0.13716216216216215]
["Team A","Rhoda","Product 1","2014-06-01","Washington","Far West",8,7,1,21,2.625,714,89.25,339,25,32,31,14,441,0.12925170068027211]
["Team A","Zia","Product 2","2014-07-01","Washington","Far West",7.5,6.5,1,25,3.3333333333333335,850,113.33333333333333,353,22,31,37,13,456,0.1162280701754386]
["Team A","Anderson","Product 1","2014-08-01","Washington","Far West",8.1,7.6999999999999993,0.40000000000000036,20.3,2.5061728395061729,600,74.074074074074076,352.4,29.1,36.5,36.1,12.3,466.40000000000003,0.1406518010291595]
["Team A","Basil","Product 2","2014-09-01","Washington","Far West",8.3000000000000007,7.5000000000000009,0.79999999999999982,17.3,2.0843373493975901,705.6,85.012048192771076,385.8,24.2,33.4,40,10,493.4,0.11674098094852046]
["Team B","Katelyn","Product 1","2014-06-01","Illinois","Great Lakes",7,6,1,21,3,714,102,322,24,30,32,14,422,0.12796208530805686]
["Team B","Amanda","Product 2","2014-07-01","Illinois","Great Lakes",7.6,6.6,1,17,2.236842105263158,578,76.05263157894737,347,20,40,35,15,457,0.13129102844638948]
["Team B","Adolph","Product 1","2014-08-01","Illinois","Great Lakes",8.1,7.6,0.5,18.100000000000001,2.2345679012345681,687.8,84.913580246913583,365.1,22.3,34.9,34.200000000000003,12.2,468.7,0.12203968423298486]
["Team B","Antone","Product 2","2014-09-01","Illinois","Great Lakes",7,6.6,0.40000000000000036,23.2,3.3142857142857141,574,82,363.8,21.8,39.799999999999997,30.5,13.2,469.1,0.13131528458750796]
["Team B","Dana","Product 1","2014-06-01","Indiana","Great Lakes",7.6,6.6,1,22,2.8947368421052633,748,98.421052631578945,396,27,30,38,15,506,0.11264822134387352]
["Team B","Stacy","Product 2","2014-07-01","Indiana","Great Lakes",7.9,6.9,1,25,3.1645569620253164,850,107.59493670886076,383,30,30,36,10,489,0.12269938650306748]
["Team B","Adrian","Product 1","2014-08-01","Indiana","Great Lakes",7.1,6.3999999999999995,0.70000000000000018,15.4,2.1690140845070425,738.8,104.05633802816901,340.8,23.3,36.5,38,14,452.6,0.13212549712770658]
["Team B","Antonia","Product 2","2014-09-01","Indiana","Great Lakes",7.2,6.5,0.70000000000000018,18.399999999999999,2.5555555555555554,656.5,91.180555555555557,365.6,23.6,34.4,33.700000000000003,10.4,467.7,0.12401111823818688]
["Team B","Winifred","Product 2","2014-06-01","Michigan","Great Lakes",7.6,6.6,1,18,2.3684210526315792,612,80.526315789473685,327,23,30,33,11,424,0.125]
["Team B","Rafael","Product 2","2014-07-01","Michigan","Great Lakes",7.3,6.3,1,15,2.0547945205479454,510,69.863013698630141,316,29,35,33,10,423,0.15130023640661938]
["Team B","Alden","Product 1","2014-08-01","Michigan","Great Lakes",8.1,7.6,0.5,15.9,1.962962962962963,606.1,74.827160493827165,392.7,27.7,34.6,30.2,12.2,497.4,0.12525130679533575]
["Team B","Arlie","Product 2","2014-09-01","Michigan","Great Lakes",8.3000000000000007,8.1000000000000014,0.19999999999999929,17.2,2.0722891566265056,693.1,83.506024096385531,309,21.1,30.8,32.9,14.9,408.7,0.12698801076584293]
["Team B","Jena","Product 2","2014-06-01","Ohio","Great Lakes",8.3000000000000007,7.3000000000000007,1,22,2.6506024096385539,748,90.120481927710841,386,20,39,38,12,495,0.1191919191919192]
["Team B","Nomlanga","Product 1","2014-07-01","Ohio","Great Lakes",8,7,1,23,2.875,782,97.75,368,26,31,38,11,474,0.12025316455696203]
["Team B","Allen","Product 1","2014-08-01","Ohio","Great Lakes",7.5,7.1,0.40000000000000036,22.1,2.9466666666666668,760.4,101.38666666666667,330.6,21.1,34.700000000000003,30.4,15,431.8,0.12922649374710515]
["Team B","Aubrey","Product 2","2014-09-01","Ohio","Great Lakes",7.6,6.8,0.79999999999999982,19.899999999999999,2.6184210526315788,836.6,110.07894736842105,375.9,22.3,34.1,35.5,12.3,480.1,0.11747552593209748]
["Team B","Phyllis","Product 1","2014-06-01","Wisconsin","Great Lakes",7,6,1,17,2.4285714285714284,578,82.571428571428569,334,29,31,30,11,435,0.13793103448275862]
["Team B","Tatum","Product 2","2014-07-01","Wisconsin","Great Lakes",7.6,6.6,1,18,2.3684210526315792,612,80.526315789473685,370,22,33,32,15,472,0.11652542372881355]
["Team B","Andrea","Product 1","2014-08-01","Wisconsin","Great Lakes",7.8,7.5,0.29999999999999982,17.7,2.2692307692307692,584.4,74.92307692307692,341.7,21.6,32,35.700000000000003,11.1,442.1,0.12123953856593531]
["Team B","Ben","Product 2","2014-09-01","Wisconsin","Great Lakes",7,6.5,0.5,23.3,3.3285714285714287,774.8,110.68571428571428,344.1,24.7,30.7,38.299999999999997,12.9,450.7,0.12291990237408476]
["Team C","Lois","Product 1","2014-06-01","Delaware","Mideast",7.5,6.5,1,16,2.1333333333333333,544,72.533333333333331,327,28,33,37,12,437,0.13958810068649885]
["Team C","Renee","Product 2","2014-07-01","Delaware","Mideast",7,6,1,23,3.2857142857142856,782,111.71428571428571,397,23,32,33,13,498,0.11044176706827309]
["Team C","Adalberto","Product 1","2014-08-01","Delaware","Mideast",7.1,6.3,0.79999999999999982,21,2.9577464788732395,699,98.450704225352112,367.7,28.9,31.9,39.299999999999997,11.2,478.99999999999994,0.1269311064718163]
["Team C","Anthony","Product 2","2014-09-01","Delaware","Mideast",7.5,7.2,0.29999999999999982,20.8,2.7733333333333334,799.1,106.54666666666667,371.5,20.3,35.1,30.8,10.199999999999999,467.90000000000003,0.1184013678136354]
["Team C","Amber","Product 2","2014-06-01","Maryland","Mideast",7.5,6.5,1,19,2.5333333333333332,646,86.13333333333334,323,20,35,34,15,427,0.1288056206088993]
["Team C","Portia","Product 2","2014-07-01","Maryland","Mideast",7.6,6.6,1,16,2.1052631578947367,544,71.578947368421055,396,25,39,37,11,508,0.12598425196850394]
["Team C","Albert","Product 1","2014-08-01","Maryland","Mideast",8.1,7.8999999999999995,0.20000000000000018,24.8,3.0617283950617287,636.29999999999995,78.555555555555557,397.2,25.5,32,34.700000000000003,11.9,501.29999999999995,0.1147017753840016]
["Team C","Ariel","Product 2","2014-09-01","Maryland","Mideast",8.1,7.6,0.5,15.8,1.9506172839506175,672.6,83.037037037037038,375.7,20.100000000000001,31.2,35.6,13.6,476.20000000000005,0.10772784544309112]
["Team C","Pamela","Product 2","2014-06-01","New Jersey","Mideast",7.5,6.5,1,22,2.9333333333333331,748,99.733333333333334,326,29,33,38,13,439,0.14123006833712984]
["Team C","Madeline","Product 1","2014-07-01","New Jersey","Mideast",7,6,1,23,3.2857142857142856,782,111.71428571428571,368,30,40,38,15,491,0.1425661914460285]
["Team C","Alfonzo","Product 1","2014-08-01","New Jersey","Mideast",8.1999999999999993,7.6999999999999993,0.5,19,2.3170731707317076,751.2,91.609756097560989,317.10000000000002,29.3,31.5,33.200000000000003,10.9,422,0.14407582938388624]
["Team C","Art","Product 2","2014-09-01","New Jersey","Mideast",8.1,7.5,0.59999999999999964,20.2,2.4938271604938271,620.20000000000005,76.567901234567913,326.3,27.4,30.9,30,10.9,425.49999999999994,0.13701527614571093]
["Team C","Zenia","Product 2","2014-06-01","New York","Mideast",7.6,6.6,1,21,2.763157894736842,714,93.94736842105263,316,28,36,35,11,426,0.15023474178403756]
["Team C","Britanney","Product 1","2014-07-01","New York","Mideast",7.9,6.9,1,15,1.8987341772151898,510,64.556962025316452,357,27,30,31,12,457,0.12472647702407003]
["Team C","Alfredo","Product 1","2014-08-01","New York","Mideast",7.2,6.6000000000000005,0.59999999999999964,15.8,2.1944444444444446,753.7,104.68055555555556,335.7,27.4,31.8,36.1,10.3,441.3,0.13414910491728982]
["Team C","Arturo","Product 2","2014-09-01","New York","Mideast",7.9,7.7,0.20000000000000018,18,2.2784810126582276,785.9,99.48101265822784,321.39999999999998,28.9,35.299999999999997,34.200000000000003,10.7,430.49999999999994,0.14912891986062718]
["Team C","Darryl","Product 1","2014-06-01","Pennsylvania","Mideast",7.5,6.5,1,20,2.6666666666666665,680,90.666666666666671,394,30,38,35,13,510,0.13333333333333333]
["Team C","Jeremy","Product 1","2014-07-01","Pennsylvania","Mideast",7.6,6.6,1,15,1.9736842105263159,510,67.10526315789474,384,21,37,39,11,492,0.11788617886178862]
["Team C","Alphonse","Product 1","2014-08-01","Pennsylvania","Mideast",7.9,7.2,0.70000000000000018,19.399999999999999,2.4556962025316453,845.2,106.98734177215189,393.4,21.9,36.5,33.4,14.6,499.79999999999995,0.11684673869547819]
["Team C","Augustus","Product 2","2014-09-01","Pennsylvania","Mideast",7.6,7.1999999999999993,0.40000000000000036,23.6,3.1052631578947372,621.70000000000005,81.802631578947384,389.9,21.9,38.200000000000003,36.200000000000003,12.7,498.89999999999992,0.12046502305071159]
["Team D","Dara","Product 1","2014-06-01","Connecticut","New England",8,7,1,18,2.25,612,76.5,364,21,32,37,13,467,0.11349036402569593]
["Team D","Keelie","Product 2","2014-07-01","Connecticut","New England",7.5,6.5,1,24,3.2,816,108.8,365,29,34,36,14,478,0.13179916317991633]
["Team D","Abram","Product 1","2014-08-01","Connecticut","New England",7.4,6.9,0.5,22.2,2.9999999999999996,639.70000000000005,86.445945945945951,391.1,29.9,33.4,37.5,10.1,502,0.12609561752988047]
["Team D","Anibal","Product 2","2014-09-01","Connecticut","New England",7.9,7.6000000000000005,0.29999999999999982,20.6,2.6075949367088609,716.3,90.670886075949355,385.9,28.6,31.6,39,11.6,496.70000000000005,0.12119991946849204]
["Team D","Luke","Product 1","2014-06-01","Maine","New England",7.5,6.5,1,20,2.6666666666666665,680,90.666666666666671,396,24,39,31,10,500,0.126]
["Team D","Giselle","Product 2","2014-07-01","Maine","New England",7,6,1,16,2.2857142857142856,544,77.714285714285708,400,30,32,38,15,515,0.12038834951456311]
["Team D","Alan","Product 1","2014-08-01","Maine","New England",7.2,6.7,0.5,20.7,2.875,563.4,78.25,387.9,23.8,39,32.1,11.9,494.7,0.12694562361026884]
["Team D","Arden","Product 2","2014-09-01","Maine","New England",7.2,6.5,0.70000000000000018,19.3,2.6805555555555558,582.20000000000005,80.861111111111114,343,20.399999999999999,30.9,39.1,10.4,443.79999999999995,0.11559260928346102]
["Team D","Guinevere","Product 2","2014-06-01","Massachusetts","New England",7,6,1,19,2.7142857142857144,646,92.285714285714292,380,21,32,33,11,477,0.1111111111111111]
["Team D","Illiana","Product 2","2014-07-01","Massachusetts","New England",7.9,6.9,{"$f":"G67-H67","v":1},22,{"$f":"J67/G67","v":2.7848101265822782},748,{"$f":"L67/G67","v":94.683544303797461},332,22,39,32,11,{"$f":"SUM(N67:R67)","v":436},{"$f":"SUM(O67:P67)/S67","v":0.13990825688073394}]
["Team D","Alberto","Product 1","2014-08-01","Massachusetts","New England",7.6,7.1,0.5,20.2,2.6578947368421053,654.4,86.10526315789474,394.7,21.7,31.3,32.1,10.8,490.6,0.10803098247044435]
["Team D","Arlen","Product 2","2014-09-01","Massachusetts","New England",7,6.5,0.5,19.3,2.7571428571428571,714.6,102.08571428571429,378.4,23.1,34.299999999999997,38.299999999999997,13.3,487.40000000000003,0.11776774723020106]
["Team D","Riley","Product 2","2014-06-01","New Hampshire","New England",8,7,1,23,2.875,782,97.75,334,30,38,30,11,443,0.15349887133182843]
["Team D","Lacy","Product 1","2014-07-01","New Hampshire","New England",7.9,6.9,1,22,2.7848101265822782,748,94.683544303797461,377,27,30,34,10,478,0.1192468619246862]
["Team D","Alfonso","Product 1","2014-08-01","New Hampshire","New England",8.1999999999999993,7.6999999999999993,0.5,23.1,2.8170731707317076,735.5,89.695121951219519,371.5,25.7,37.6,34.1,13.9,482.8,0.13111019055509526]
["Team D","Arron","Product 2","2014-09-01","New Hampshire","New England",7.2,6.6000000000000005,0.59999999999999964,20.9,2.9027777777777777,644.79999999999995,89.555555555555543,320.89999999999998,26,33.5,36.700000000000003,13.8,430.9,0.13808308192155955]
["Team D","Iona","Product 1","2014-06-01","Rhode Island","New England",7,6,1,23,3.2857142857142856,782,111.71428571428571,369,21,40,34,10,474,0.12869198312236288]
["Team D","Hoyt","Product 1","2014-07-01","Rhode Island","New England",7.6,6.6,1,15,1.9736842105263159,510,67.10526315789474,384,21,37,39,11,492,0.11788617886178862]
["Team D","Alphonso","Product 1","2014-08-01","Rhode Island","New England",7.9,7.5,0.40000000000000036,21.8,2.759493670886076,814.5,103.10126582278481,322,20.8,36.1,32.299999999999997,13,424.20000000000005,0.13413484205563414]
["Team D","Aurelio","Product 2","2014-09-01","Rhode Island","New England",7.5,7.3,0.20000000000000018,21.5,2.8666666666666667,795.4,106.05333333333333,351.1,22.6,35.799999999999997,37.799999999999997,10.6,457.90000000000009,0.12753876392225375]
["Team D","Ivory","Product 1","2014-06-01","Vermont","New England",7.3,6.3,1,19,2.6027397260273974,646,88.493150684931507,316,30,40,36,15,437,0.16018306636155608]
["Team D","Cheyenne","Product 2","2014-07-01","Vermont","New England",7,6,1,19,2.7142857142857144,646,92.285714285714292,307,24,33,40,11,415,0.13734939759036144]
["Team D","Ambrose","Product 1","2014-08-01","Vermont","New England",8,7.6,0.40000000000000036,19.2,2.4,593.1,74.137500000000003,362.2,29.9,39.200000000000003,32,14.1,477.4,0.14474235441977376]
["Team D","Bart","Product 2","2014-09-01","Vermont","New England",7.4,6.9,0.5,19.7,2.6621621621621618,721.2,97.459459459459467,325.5,23.5,38.299999999999997,35.6,14.6,437.50000000000006,0.14125714285714283]
["Team E","Carolyn","Product 1","2014-06-01","Iowa","Plains",7.9,6.9,1,23,2.9113924050632911,782,98.987341772151893,382,23,33,33,11,482,0.11618257261410789]
["Team E","Patricia","Product 2","2014-07-01","Iowa","Plains",7.3,6.3,1,19,2.6027397260273974,646,88.493150684931507,378,24,35,37,13,487,0.12114989733059549]
["Team E","Agustin","Product 1","2014-08-01","Iowa","Plains",7.4,6.8000000000000007,0.59999999999999964,18.100000000000001,2.4459459459459461,610.70000000000005,82.527027027027032,327,24,39.9,31.9,12.5,435.29999999999995,0.14679531357684356]
["Team E","Antonio","Product 2","2014-09-01","Iowa","Plains",8.1999999999999993,7.9999999999999991,0.20000000000000018,15.6,1.902439024390244,749.5,91.402439024390247,382.3,22.9,30.7,35.6,12.5,484,0.11074380165289255]
["Team E","Serena","Product 1","2014-06-01","Kansas","Plains",7.3,6.3,1,15,2.0547945205479454,510,69.863013698630141,359,25,37,34,10,465,0.13333333333333333]
["Team E","Deanna","Product 2","2014-07-01","Kansas","Plains",8.3000000000000007,7.3000000000000007,1,20,2.4096385542168672,680,81.92771084337349,390,21,33,35,13,492,0.10975609756097561]
["Team E","Ahmad","Product 1","2014-08-01","Kansas","Plains",8.1,7.5,0.59999999999999964,16.2,2,640.4,79.061728395061735,305.7,25.8,34.9,35.1,10.7,412.2,0.14725861232411452]
["Team E","Antony","Product 2","2014-09-01","Kansas","Plains",7.2,6.6000000000000005,0.59999999999999964,22,3.0555555555555554,645.6,89.666666666666671,314.8,21.5,34,30,14.6,414.90000000000003,0.13376717281272596]
["Team E","Inez","Product 2","2014-06-01","Minnesota","Plains",7.9,6.9,1,25,3.1645569620253164,850,107.59493670886076,330,24,32,30,10,426,0.13145539906103287]
["Team E","Libby","Product 1","2014-07-01","Minnesota","Plains",7.3,6.3,1,23,3.1506849315068495,782,107.12328767123287,367,27,37,36,12,479,0.1336116910229645]
["Team E","Aldo","Product 1","2014-08-01","Minnesota","Plains",7.4,6.8000000000000007,0.59999999999999964,16.7,2.2567567567567566,654.20000000000005,88.405405405405403,377.5,29.8,34.799999999999997,30.1,11.3,483.50000000000006,0.13360910031023782]
["Team E","Armand","Product 2","2014-09-01","Minnesota","Plains",7.4,7.2,0.20000000000000018,17.5,2.3648648648648649,691.3,93.418918918918905,348.2,25.4,36.4,33.9,13.7,457.59999999999991,0.13505244755244758]
["Team E","Daria","Product 2","2014-06-01","Missouri","Plains",8.3000000000000007,7.3000000000000007,1,20,2.4096385542168672,680,81.92771084337349,357,24,30,39,11,461,0.11713665943600868]
["Team E","Brynne","Product 1","2014-07-01","Missouri","Plains",8,7,1,19,2.375,646,80.75,370,27,38,33,14,482,0.13485477178423236]
["Team E","Alejandro","Product 1","2014-08-01","Missouri","Plains",7.9,7.6000000000000005,0.29999999999999982,18.899999999999999,2.3924050632911391,699.8,88.582278481012651,359.7,20.7,38.6,38.4,14.2,471.59999999999997,0.12574215436810857]
["Team E","Arnold","Product 2","2014-09-01","Missouri","Plains",7.7,7.2,0.5,23.6,3.0649350649350651,824.2,107.03896103896105,314.5,28.9,33.1,30.7,10.4,417.59999999999997,0.14846743295019157]
["Team E","Mercedes","Product 2","2014-06-01","Nebraska","Plains",7.3,6.3,1,25,3.4246575342465753,850,116.43835616438356,338,24,34,33,12,441,0.13151927437641722]
["Team E","Rosalyn","Product 1","2014-07-01","Nebraska","Plains",7,6,1,16,2.2857142857142856,544,77.714285714285708,353,27,37,35,12,464,0.13793103448275862]
["Team E","Alexander","Product 1","2014-08-01","Nebraska","Plains",7.5,7.2,0.29999999999999982,16.899999999999999,2.253333333333333,539.29999999999995,71.906666666666666,348.1,22.3,38.799999999999997,30.9,14.9,455,0.13428571428571429]
["Team E","Arnulfo","Product 2","2014-09-01","Nebraska","Plains",7.4,6.6000000000000005,0.79999999999999982,19.7,2.6621621621621618,519,70.13513513513513,304,20.9,39.299999999999997,37.4,13.6,415.2,0.14499036608863197]
["Team E","Karyn","Product 2","2014-06-01","North Dakota","Plains",7.3,6.3,1,19,2.6027397260273974,646,88.493150684931507,317,25,32,38,13,425,0.13411764705882354]
["Team E","Frances","Product 1","2014-07-01","North Dakota","Plains",8.3000000000000007,7.3000000000000007,1,16,1.9277108433734937,544,65.542168674698786,394,27,37,37,10,505,0.12673267326732673]
["Team E","Allan","Product 1","2014-08-01","North Dakota","Plains",7.5,7.1,0.40000000000000036,17.899999999999999,2.3866666666666663,681.1,90.813333333333333,300.10000000000002,22.3,30.5,31.5,13.6,398.00000000000006,0.13266331658291455]
["Team E","Ashley","Product 2","2014-09-01","North Dakota","Plains",7.5,7,0.5,20.5,2.7333333333333334,550.9,73.453333333333333,318.2,26.5,38,33.299999999999997,11.1,427.1,0.15101849683914773]
["Team E","Jana","Product 1","2014-06-01","South Dakota","Plains",7.9,6.9,1,22,2.7848101265822782,748,94.683544303797461,341,22,30,31,14,438,0.11872146118721461]
["Team E","Quyn","Product 2","2014-07-01","South Dakota","Plains",7.3,6.3,1,21,2.8767123287671232,714,97.808219178082197,381,23,34,36,11,485,0.11752577319587629]
["Team E","Alva","Product 1","2014-08-01","South Dakota","Plains",8.3000000000000007,7.6000000000000005,0.70000000000000018,17.899999999999999,2.1566265060240961,590.79999999999995,71.180722891566248,312.8,24.1,36.9,31.5,13.4,418.7,0.14568903749701456]
["Team E","Avery","Product 2","2014-09-01","South Dakota","Plains",7.4,7,0.40000000000000036,19,2.5675675675675675,630.79999999999995,85.243243243243228,371.2,20.7,37.200000000000003,33.6,12.3,475,0.12189473684210528]
["Team F","Shaine","Product 1","2014-06-01","Colorado","Rocky Mountain",8.3000000000000007,7.3000000000000007,1,19,2.2891566265060237,646,77.831325301204814,356,28,38,40,14,476,0.13865546218487396]
["Team F","Farrah","Product 2","2014-07-01","Colorado","Rocky Mountain",8,7,1,24,3,816,102,321,27,32,40,14,434,0.13594470046082949]
["Team F","Abraham","Product 1","2014-08-01","Colorado","Rocky Mountain",7.8,7.6,0.20000000000000018,19.8,2.5384615384615388,749,96.025641025641022,397.5,21.3,30.4,39.4,11.3,499.9,0.10342068413682738]
["Team F","Angelo","Product 2","2014-09-01","Colorado","Rocky Mountain",7.4,6.6000000000000005,0.79999999999999982,16.5,2.2297297297297298,700.8,94.702702702702695,303.2,23.3,38.1,33.4,14.1,412.1,0.14899296287308905]
["Team F","Shelby","Product 1","2014-06-01","Idaho","Rocky Mountain",7.5,6.5,1,22,2.9333333333333331,748,99.733333333333334,389,20,39,39,13,500,0.11799999999999999]
["Team F","Kendall","Product 2","2014-07-01","Idaho","Rocky Mountain",7.3,6.3,1,24,3.2876712328767126,816,111.78082191780823,338,28,35,39,15,455,0.13846153846153847]
["Team F","Adolfo","Product 1","2014-08-01","Idaho","Rocky Mountain",8.3000000000000007,7.5000000000000009,0.79999999999999982,20.399999999999999,2.4578313253012043,775.5,93.433734939759034,326.3,20.3,31.2,33.200000000000003,10.7,421.7,0.12212473322267015]
["Team F","Anton","Product 2","2014-09-01","Idaho","Rocky Mountain",8,7.7,0.29999999999999982,22.5,2.8125,766.7,95.837500000000006,359.8,20.6,36.299999999999997,33.299999999999997,13.4,463.40000000000003,0.12278808804488561]
["Team F","Madeson","Product 2","2014-06-01","Montana","Rocky Mountain",8,7,1,16,2,544,68,394,29,37,34,11,505,0.1306930693069307]
["Team F","Olympia","Product 1","2014-07-01","Montana","Rocky Mountain",7.5,6.5,1,24,3.2,816,108.8,379,20,36,31,14,480,0.11666666666666667]
["Team F","Alex","Product 1","2014-08-01","Montana","Rocky Mountain",7.6,7,0.59999999999999964,15.5,2.0394736842105265,646.79999999999995,85.10526315789474,398.9,20.7,39.1,36.299999999999997,14.9,509.9,0.11727789762698568]
["Team F","Arnoldo","Product 2","2014-09-01","Montana","Rocky Mountain",7,6.6,0.40000000000000036,22,3.1428571428571428,788.5,112.64285714285714,370.3,20.9,33.5,37.4,11.4,473.49999999999994,0.11488912354804648]
["Team F","Courtney","Product 1","2014-06-01","Utah","Rocky Mountain",7.9,6.9,1,23,2.9113924050632911,782,98.987341772151893,371,29,30,38,12,480,0.12291666666666666]
["Team F","April","Product 2","2014-07-01","Utah","Rocky Mountain",7.5,6.5,1,15,2,510,68,324,25,32,31,14,426,0.13380281690140844]
["Team F","Amado","Product 1","2014-08-01","Utah","Rocky Mountain",7.3,6.8999999999999995,0.40000000000000036,17.899999999999999,2.452054794520548,633.6,86.794520547945211,311.8,26.2,32.4,36,13,419.4,0.139723414401526]
["Team F","Barry","Product 2","2014-09-01","Utah","Rocky Mountain",7.7,7.2,0.5,16.3,2.116883116883117,822.4,106.8051948051948,363.1,27.9,36.200000000000003,39.9,12.8,479.9,0.13356949364450926]
["Team F","Gretchen","Product 1","2014-06-01","Wyoming","Rocky Mountain",7.6,6.6,1,17,2.236842105263158,578,76.05263157894737,323,27,38,36,11,435,0.14942528735632185]
["Team F","Medge","Product 2","2014-07-01","Wyoming","Rocky Mountain",7.9,6.9,1,15,1.8987341772151898,510,64.556962025316452,392,27,30,30,12,491,0.11608961303462322]
["Team F","Andreas","Product 1","2014-08-01","Wyoming","Rocky Mountain",7.6,7.3999999999999995,0.20000000000000018,16.5,2.1710526315789473,775.1,101.98684210526316,366.7,22.7,30.7,31.6,12.3,464,0.11508620689655172]
["Team F","Benedict","Product 2","2014-09-01","Wyoming","Rocky Mountain",8.1,7.3999999999999995,0.70000000000000018,23.6,2.9135802469135808,777.1,95.938271604938279,339.9,21,38.4,36.799999999999997,14.7,450.79999999999995,0.13176574977817215]
["Team G","Sydnee","Product 1","2014-06-01","Alabama","Southeast",4.7162499999999996,4.0424999999999995,0.67375000000000007,14.822499999999998,3.1428571428571428,503.96500000000003,106.85714285714288,241.20249999999999,16.169999999999998,26.950000000000003,21.559999999999995,10.106250000000001,315.98874999999998,0.13646055437100216]
["Team G","Noelani","Product 1","2014-07-01","Alabama","Southeast",5.3226250000000004,4.6488750000000003,{"$f":"G131-H131","v":0.67375000000000007},10.779999999999998,{"$f":"J131/G131","v":2.0253164556962018},366.51999999999992,{"$f":"L131/G131","v":68.860759493670869},245.91874999999999,20.212500000000002,23.581250000000004,22.233750000000001,9.4324999999999992,{"$f":"SUM(N131:R131)","v":321.37874999999997},{"$f":"SUM(O131:P131)/S131","v":0.13626834381551364}]
["Team G","Aaron","Product 1","2014-08-01","Alabama","Southeast",5.0531250000000005,4.5815000000000001,0.47162500000000041,10.645250000000001,2.1066666666666665,403.30674999999997,79.813333333333318,251.37612500000003,15.226749999999999,23.648625000000003,25.333000000000002,8.421875,324.00637500000005,0.11998336452484924]
["Team G","Andres","Product 2","2014-09-01","Alabama","Southeast",5.3899999999999988,4.9183750000000002,0.47162499999999863,10.106250000000001,1.8750000000000007,490.01837499999993,90.912500000000009,227.99699999999999,17.719625000000001,20.414625000000001,23.716000000000001,8.7587499999999991,298.60600000000005,0.12770758122743681]
["Team G","Xantha","Product 1","2014-06-01","Arkansas","Southeast",5.3226250000000004,4.6488750000000003,0.67375000000000007,16.169999999999998,3.0379746835443031,549.78,103.29113924050631,225.70624999999995,18.864999999999998,20.88625,22.233750000000001,10.106250000000001,297.79749999999996,0.13348416289592763]
["Team G","Alec","Product 1","2014-07-01","Arkansas","Southeast",5.5921250000000011,4.9183750000000002,0.67375000000000096,14.14875,2.5301204819277103,481.05749999999995,86.024096385542137,202.12500000000003,15.496249999999998,26.276249999999997,22.907499999999995,9.4324999999999992,276.23750000000001,0.15121951219512192]
["Team G","Abe","Product 1","2014-08-01","Arkansas","Southeast",5.457374999999999,4.9183750000000002,0.53899999999999881,13.070749999999997,2.3950617283950617,438.81337499999995,80.407407407407419,244.43649999999997,13.879250000000001,25.804624999999994,24.591874999999995,6.7375000000000007,315.44974999999999,0.12580093976932932]
["Team G","Andy","Product 2","2014-09-01","Arkansas","Southeast",5.2552500000000002,4.9183750000000002,0.33687500000000004,15.428874999999998,2.9358974358974352,360.79312500000003,68.65384615384616,257.23775000000001,20.212500000000002,23.783374999999999,20.414625000000001,6.8722499999999984,328.52049999999997,0.13392124692370797]
["Team G","Nevada","Product 1","2014-06-01","Florida","Southeast",5.5921250000000011,4.9183750000000002,0.67375000000000096,15.496249999999998,2.7710843373493965,526.87249999999995,94.216867469879489,215.60000000000002,15.496249999999998,20.212500000000002,26.276249999999997,8.0849999999999991,285.67,0.125]
["Team G","Audra","Product 2","2014-07-01","Florida","Southeast",5.1204999999999998,4.4467499999999998,0.67375000000000007,10.779999999999998,2.1052631578947363,366.51999999999992,71.578947368421041,253.32999999999998,18.864999999999998,26.276249999999997,22.233750000000001,8.0849999999999991,328.78999999999996,0.13729508196721313]
["Team G","Adam","Product 1","2014-08-01","Florida","Southeast",4.7162499999999996,4.5141249999999991,0.20212500000000055,16.776374999999998,3.5571428571428569,417.65762499999994,88.55714285714285,257.50724999999994,13.946624999999999,22.031624999999998,21.425249999999998,9.4324999999999992,324.34324999999995,0.11092646447860408]
["Team G","Antione","Product 2","2014-09-01","Florida","Southeast",5.457374999999999,5.0531250000000005,0.40424999999999844,12.194875,2.2345679012345681,451.47987499999999,82.728395061728406,226.38,15.428874999999998,20.953624999999999,23.177,9.2303749999999987,295.16987499999999,0.12325952978771967]
["Team G","Miriam","Product 1","2014-06-01","Georgia","Southeast",5.3899999999999988,4.7162499999999996,0.67374999999999918,16.169999999999998,3.0000000000000004,549.78,102.00000000000001,228.40125,20.212500000000002,26.950000000000003,20.212500000000002,7.411249999999999,303.1875,0.15555555555555559]
["Team G","Hermione","Product 2","2014-07-01","Georgia","Southeast",5.3226250000000004,4.6488750000000003,0.67375000000000007,10.779999999999998,2.0253164556962018,366.51999999999992,68.860759493670869,268.15249999999997,19.538749999999997,20.88625,22.233750000000001,7.411249999999999,338.22249999999997,0.11952191235059761]
["Team G","Adan","Product 1","2014-08-01","Georgia","Southeast",5.457374999999999,5.2552500000000002,0.20212499999999878,12.936,2.3703703703703707,366.856875,67.222222222222229,220.45099999999996,14.283499999999998,24.524499999999996,26.343624999999999,7.6807499999999997,293.28337499999992,0.13232253618194351]
["Team G","Antoine","Product 2","2014-09-01","Georgia","Southeast",4.7836249999999998,4.5141249999999991,0.26950000000000074,16.776374999999998,3.5070422535211265,537.1808749999999,112.29577464788731,264.17737499999998,16.102624999999996,21.896875000000001,26.411000000000001,9.2977500000000006,337.885625,0.11246261216350946]
["Team G","Juliet","Product 1","2014-06-01","Kentucky","Southeast",5.5921250000000011,4.9183750000000002,0.67375000000000096,16.169999999999998,2.8915662650602401,549.78,98.313253012048165,220.31624999999997,13.475000000000001,22.907499999999995,21.559999999999995,6.7375000000000007,284.99624999999997,0.1276595744680851]
["Team G","Rae","Product 2","2014-07-01","Kentucky","Southeast",5.3899999999999988,4.7162499999999996,0.67374999999999918,16.84375,3.1250000000000009,572.6875,106.25000000000003,251.30874999999997,18.864999999999998,20.88625,26.950000000000003,6.7375000000000007,324.7475,0.12240663900414937]
["Team G","Ahmed","Product 1","2014-08-01","Kentucky","Southeast",5.3226250000000004,4.9183750000000002,0.40425000000000022,14.14875,2.6582278481012658,359.24350000000004,67.493670886075947,230.75937499999998,17.382750000000001,23.918125,24.659250000000004,7.9502499999999996,304.66974999999991,0.13555948695267586]
["Team G","Antwan","Product 2","2014-09-01","Kentucky","Southeast",4.9183750000000002,4.5815000000000001,0.33687500000000004,15.024625,3.054794520547945,482.60712499999988,98.123287671232845,215.93687500000001,19.875624999999999,23.716000000000001,22.368500000000004,9.2303749999999987,291.12737499999997,0.14973385790326316]
["Team G","Serina","Product 1","2014-06-01","Louisiana","Southeast",5.3899999999999988,4.7162499999999996,0.67374999999999918,16.84375,3.1250000000000009,572.6875,106.25000000000003,224.35874999999999,19.538749999999997,22.907499999999995,23.581250000000004,8.0849999999999991,298.47124999999994,0.14221218961625282]
["Team G","Ashely","Product 2","2014-07-01","Louisiana","Southeast",5.0531250000000005,4.3793749999999996,0.67375000000000096,14.14875,2.8,481.05749999999995,95.199999999999974,263.43624999999997,18.19125,20.88625,23.581250000000004,8.7587499999999991,334.85375000000005,0.11670020120724345]
["Team G","Al","Product 1","2014-08-01","Louisiana","Southeast",5.2552500000000002,4.7162499999999996,0.53900000000000059,11.251625000000001,2.141025641025641,553.35087499999997,105.29487179487178,220.24887499999994,15.428874999999998,21.627375000000001,21.425249999999998,6.8722499999999984,285.60262499999999,0.12974758197688133]
["Team G","Archie","Product 2","2014-09-01","Louisiana","Southeast",5.5921250000000011,5.0531250000000005,0.53900000000000059,14.081374999999998,2.5180722891566254,486.98649999999992,87.084337349397558,225.50412499999996,18.999749999999999,20.684125000000002,21.694749999999999,8.6239999999999988,295.50675000000001,0.13429092567259462]
["Team G","Maris","Product 2","2014-06-01","Mississippi","Southeast",4.9183750000000002,4.2446249999999992,0.67375000000000096,12.80125,2.602739726027397,435.24250000000001,88.493150684931507,238.50749999999999,18.864999999999998,25.602499999999999,24.254999999999999,7.411249999999999,314.64125000000001,0.14132762312633831]
["Team G","Rowan","Product 1","2014-07-01","Mississippi","Southeast",5.5921250000000011,4.9183750000000002,0.67375000000000096,16.84375,3.0120481927710836,572.6875,102.40963855421684,234.465,13.475000000000001,25.602499999999999,20.212500000000002,6.7375000000000007,300.49250000000001,0.13004484304932734]
["Team G","Alec","Product 1","2014-08-01","Mississippi","Southeast",4.9857499999999995,4.6488750000000003,0.33687499999999915,10.577874999999999,2.1216216216216215,401.62237499999998,80.554054054054063,214.85887499999995,14.350875,25.669874999999998,21.627375000000001,7.2765000000000004,283.78349999999995,0.14102564102564105]
["Team G","Armando","Product 2","2014-09-01","Mississippi","Southeast",5.2552500000000002,4.9183750000000002,0.33687500000000004,11.790625000000002,2.2435897435897441,442.72112499999997,84.243589743589737,250.70237500000005,17.989124999999998,21.896875000000001,21.290500000000002,8.0849999999999991,319.96387500000003,0.12465782269951567]
["Team G","Hilary","Product 2","2014-06-01","North Carolina","Southeast",5.3226250000000004,4.6488750000000003,0.67375000000000007,12.80125,2.4050632911392404,435.24250000000001,81.77215189873418,203.4725,18.864999999999998,21.559999999999995,22.907499999999995,10.106250000000001,276.91125,0.145985401459854]
["Team G","Mallory","Product 1","2014-07-01","North Carolina","Southeast",4.9183750000000002,4.2446249999999992,0.67375000000000096,12.80125,2.602739726027397,435.24250000000001,88.493150684931507,222.33749999999998,20.212500000000002,22.233750000000001,26.950000000000003,8.7587499999999991,300.49250000000001,0.14125560538116594]
["Team G","Ali","Product 1","2014-08-01","North Carolina","Southeast",4.851,4.5815000000000001,0.26949999999999985,12.599124999999997,2.5972222222222219,378.78224999999998,78.083333333333329,231.83737500000001,20.212500000000002,21.96425,24.861374999999999,8.8934999999999995,307.76900000000006,0.13704028021015757]
["Team G","Asa","Product 2","2014-09-01","North Carolina","Southeast",4.9183750000000002,4.4467499999999998,0.47162500000000041,14.013999999999999,2.8493150684931505,435.17512499999998,88.479452054794507,257.70937500000002,14.350875,24.389749999999999,26.950000000000003,7.2091249999999993,330.60912499999995,0.11717953943346242]
["Team G","Illana","Product 1","2014-06-01","South Carolina","Southeast",5.1204999999999998,4.4467499999999998,0.67375000000000007,10.106250000000001,1.9736842105263162,343.61249999999995,67.105263157894726,239.85499999999999,14.14875,23.581250000000004,23.581250000000004,6.7375000000000007,307.90375,0.12253829321663021]
["Team G","Tashya","Product 2","2014-07-01","South Carolina","Southeast",5.3226250000000004,4.6488750000000003,0.67375000000000007,16.169999999999998,3.0379746835443031,549.78,103.29113924050631,255.35124999999999,15.496249999999998,24.928749999999997,22.233750000000001,7.411249999999999,325.42124999999993,0.12422360248447206]
["Team G","Alton","Product 1","2014-08-01","South Carolina","Southeast",4.851,4.4467500000000006,0.40424999999999933,15.833124999999999,3.2638888888888888,470.81649999999991,97.055555555555543,206.03274999999999,15.226749999999999,25.130874999999996,22.233750000000001,7.4786250000000001,276.10275000000001,0.14616886285993166]
["Team G","Austin","Product 2","2014-09-01","South Carolina","Southeast",4.7162499999999996,4.2446249999999992,0.47162500000000041,11.992749999999999,2.5428571428571427,347.52024999999998,73.685714285714283,224.22399999999999,15.226749999999999,23.850749999999998,26.747875000000001,7.411249999999999,297.46062499999999,0.13137032842582108]
["Team G","Ariel","Product 1","2014-06-01","Tennessee","Southeast",4.9183750000000002,4.2446249999999992,0.67375000000000096,10.106250000000001,2.0547945205479454,343.61249999999995,69.863013698630127,202.79875000000001,18.19125,26.276249999999997,26.276249999999997,7.411249999999999,280.95375000000001,0.15827338129496402]
["Team G","Sierra","Product 2","2014-07-01","Tennessee","Southeast",5.5921250000000011,4.9183750000000002,0.67375000000000096,10.106250000000001,1.8072289156626504,343.61249999999995,61.445783132530103,203.4725,14.14875,22.907499999999995,24.254999999999999,8.7587499999999991,273.54250000000002,0.13546798029556648]
["Team G","Alvaro","Product 1","2014-08-01","Tennessee","Southeast",5.3899999999999988,4.9183750000000002,0.47162499999999863,14.216125,2.6375000000000006,458.28474999999997,85.02500000000002,245.447125,19.336625000000002,23.109625000000001,23.513874999999995,9.2303749999999987,320.63762499999996,0.13238075225887797]
["Team G","Barney","Product 2","2014-09-01","Tennessee","Southeast",5.5921250000000011,5.3899999999999988,0.20212500000000233,15.294124999999998,2.7349397590361435,500.25937499999998,89.457831325301186,240.66349999999997,13.879250000000001,26.747875000000001,24.996124999999999,9.2977500000000006,315.58449999999999,0.12873612297181897]
["Team G","Cleo","Product 1","2014-06-01","Virginia","Southeast",5.5921250000000011,4.9183750000000002,0.67375000000000096,13.475000000000001,2.4096385542168672,458.15,81.927710843373475,206.84124999999997,18.864999999999998,22.233750000000001,21.559999999999995,8.0849999999999991,277.58499999999998,0.14805825242718446]
["Team G","Heather","Product 2","2014-07-01","Virginia","Southeast",5.1204999999999998,4.4467499999999998,0.67375000000000007,11.453749999999998,2.2368421052631575,389.42749999999995,76.052631578947356,268.15249999999997,18.864999999999998,20.88625,21.559999999999995,6.7375000000000007,336.20125000000002,0.11823647294589178]
["Team G","Amos","Product 1","2014-08-01","Virginia","Southeast",4.9857499999999995,4.6488750000000003,0.33687499999999915,14.95725,3.0000000000000004,471.01862500000004,94.472972972972997,253.936375,20.077750000000002,20.549374999999998,21.223124999999996,7.2091249999999993,322.99574999999993,0.12578222778473094]
["Team G","Barton","Product 2","2014-09-01","Virginia","Southeast",5.2552500000000002,5.1204999999999998,0.13475000000000037,12.80125,2.4358974358974357,423.78874999999994,80.641025641025621,213.30925000000002,15.091999999999999,26.747875000000001,25.400375,9.702,290.25150000000002,0.14415041782729804]
["Team G","Kirby","Product 1","2014-06-01","West Virginia","Southeast",5.0531250000000005,4.3793749999999996,0.67375000000000096,10.779999999999998,2.1333333333333324,366.51999999999992,72.533333333333317,237.15999999999997,15.496249999999998,26.276249999999997,21.559999999999995,9.4324999999999992,309.92499999999995,0.13478260869565217]
["Team G","Shelley","Product 2","2014-07-01","West Virginia","Southeast",4.7162499999999996,4.0424999999999995,0.67375000000000007,13.475000000000001,2.8571428571428577,458.15,97.142857142857153,224.35874999999999,13.475000000000001,20.88625,22.907499999999995,8.7587499999999991,290.38624999999996,0.11832946635730859]
["Team G","Andre","Product 1","2014-08-01","West Virginia","Southeast",5.3226250000000004,4.851,0.47162500000000041,16.574249999999999,3.1139240506329111,378.51274999999993,71.113924050632889,241.60675000000001,18.797624999999996,25.939374999999998,21.762124999999997,8.0176250000000007,316.12349999999998,0.14151747655583971]
["Team G","Beau","Product 2","2014-09-01","West Virginia","Southeast",5.3226250000000004,4.7836249999999998,0.53900000000000059,10.106250000000001,1.89873417721519,455.72449999999998,85.620253164556956,254.13849999999996,18.797624999999996,21.829499999999996,23.31175,7.8828749999999994,325.96024999999997,0.12463828028110788]
["Team H","Flavia","Product 1","2014-06-01","Arizona","Southwest",7.6,6.6,1,15,1.9736842105263159,510,67.10526315789474,302,24,37,33,12,408,0.14950980392156862]
["Team H","Fleur","Product 1","2014-07-01","Arizona","Southwest",7.3,6.3,1,24,3.2876712328767126,816,111.78082191780823,329,26,36,39,10,440,0.1409090909090909]
["Team H","Abdul","Product 1","2014-08-01","Arizona","Southwest",7.9,7.7,0.20000000000000018,23,2.9113924050632911,773.9,97.962025316455694,342.3,25.9,33.1,34.700000000000003,11.7,447.7,0.13178467723922269]
["Team H","Andrew","Product 2","2014-09-01","Arizona","Southwest",7.9,7.4,0.5,23,2.9113924050632911,608.79999999999995,77.063291139240491,380,26.5,34.4,36.700000000000003,12.9,490.49999999999994,0.12415902140672784]
["Team H","Regina","Product 2","2014-06-01","New Mexico","Southwest",7,6,1,20,2.8571428571428572,680,97.142857142857139,372,21,39,35,13,480,0.125]
["Team H","Dai","Product 1","2014-07-01","New Mexico","Southwest",7.6,6.6,1,16,2.1052631578947367,544,71.578947368421055,336,23,38,35,10,442,0.13800904977375567]
["Team H","Alfred","Product 1","2014-08-01","New Mexico","Southwest",7.3,7,0.29999999999999982,16.5,2.2602739726027399,658.1,90.150684931506859,363.7,20.5,34.299999999999997,33.5,14.9,466.9,0.11736988648532877]
["Team H","Arthur","Product 2","2014-09-01","New Mexico","Southwest",7.3,6.5,0.79999999999999982,17.3,2.3698630136986303,666.2,91.260273972602747,333,23.1,38.799999999999997,31.3,10.7,436.90000000000003,0.14168001831082627]
["Team H","Addison","Product 2","2014-06-01","Oklahoma","Southwest",8,7,1,18,2.25,612,76.5,350,29,30,32,12,453,0.13024282560706402]
["Team H","Galena","Product 1","2014-07-01","Oklahoma","Southwest",7.5,6.5,1,17,2.2666666666666666,578,77.066666666666663,397,29,31,32,10,499,0.12024048096192384]
["Team H","Alonso","Product 1","2014-08-01","Oklahoma","Southwest",8.1,7.3999999999999995,0.70000000000000018,19.600000000000001,2.4197530864197532,826.8,102.07407407407408,366.5,28.4,30.2,36,12.7,473.79999999999995,0.12368087800759814]
["Team H","August","Product 2","2014-09-01","Oklahoma","Southwest",7.6,6.8,0.79999999999999982,22.5,2.9605263157894739,772.4,101.63157894736842,315.39999999999998,20.7,33.6,37,11.8,418.5,0.12974910394265232]
["Team H","Ariana","Product 1","2014-06-01","Texas","Southwest",8.3000000000000007,7.3000000000000007,1,24,2.8915662650602405,816,98.313253012048179,369,21,40,34,15,479,0.12734864300626306]
["Team H","Camille","Product 2","2014-07-01","Texas","Southwest",8,7,1,21,2.625,714,89.25,348,22,30,37,14,451,0.11529933481152993]
["Team H","Alvin","Product 1","2014-08-01","Texas","Southwest",7.1,6.6999999999999993,0.40000000000000036,22.9,3.2253521126760565,542.4,76.394366197183103,385.9,27.5,37.799999999999997,33.5,10.1,494.8,0.13197251414713015]
["Team H","Barrett","Product 2","2014-09-01","Texas","Southwest",8.3000000000000007,7.7000000000000011,0.59999999999999964,21.1,2.5421686746987953,758.1,91.337349397590359,340.4,21.3,30.5,32,15,439.2,0.11794171220400729]

{"sheet":"Lookup_Tables","index":2,"n_rows":12,"n_cols":21,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Date",3,null,null,"Metric",5,null,null,"Geo",2,null,null,"Chart Type",1,null,null,"Login Hours","Talk Time","Hold Time"]
["Result",{"$f":"VLOOKUP(B1,A3:B6,2,0)","v":"2014-08-01"},{"$f":"VLOOKUP(B1,A3:C6,3,0)","v":"August 2014"},null,"Result",{"$f":"VLOOKUP(F1,E3:F12,2,0)","v":"Revenue"},null,null,"Result",{"$f":"VLOOKUP(J1,I3:J4,2,0)","v":"By Team"},null,null,"Result",{"$f":"VLOOKUP(N1,M3:N5,2,0)","v":"Hours"},null,null,"Sales","Sales/Hour","Revenue","Revenue/Hour"]
[1,"2014-06-01","June 2014",null,1,"Login Hours",null,null,1,"By State",null,null,1,"Hours",null,"OOO","Total Calls","% Excellent","% Good","% Fair","% Poor"]
[2,"2014-07-01","July 2014",null,2,"Total Talk Time",null,null,2,"By Team",null,null,2,"Sales"]
[3,"2014-08-01","August 2014",null,3,"Total Hold Time",null,null,null,null,null,null,3,"Calls"]
[4,"2014-09-01","Sept. 2014",null,4,"Sales"]
[null,null,null,null,5,"Revenue"]
[null,null,null,null,6,"Total Calls"]
[null,null,null,null,7,"Excellent Calls"]
[null,null,null,null,8,"Good Calls"]
[null,null,null,null,9,"Fair Calls"]
[null,null,null,null,10,"Poor Calls"]

{"sheet":"Data","index":3,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Data"]
[]
["Region","No.","State","Abbreviation","Metric"]
["Southeast",1,"Alabama","AL",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C5,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A5,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["Southeast",{"$f":"B5+1","v":2},"Arkansas","AR",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C6,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A6,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["Southwest",3,"Arizona","AZ",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C7,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A7,LinkData!D:D,Lookup_Tables!$B$2))","v":2801.2000000000003}]
["Far West",4,"California","CA",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C8,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A8,LinkData!D:D,Lookup_Tables!$B$2))","v":2736.9}]
["Rocky Mountain",5,"Colorado","CO",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C9,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A9,LinkData!D:D,Lookup_Tables!$B$2))","v":3580}]
["New England",6,"Connecticut","CT",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C10,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A10,LinkData!D:D,Lookup_Tables!$B$2))","v":4000.6}]
["Mideast",7,"Delaware","DE",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C11,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A11,LinkData!D:D,Lookup_Tables!$B$2))","v":3685.3999999999996}]
["Southeast",8,"Florida","FL",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C12,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A12,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["Southeast",9,"Georgia","GA",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C13,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A13,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["Plains",10,"Iowa","IA",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C14,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A14,LinkData!D:D,Lookup_Tables!$B$2))","v":4416.2999999999993}]
["Rocky Mountain",11,"Idaho","ID",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C15,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A15,LinkData!D:D,Lookup_Tables!$B$2))","v":3580}]
["Great Lakes",12,"Illinois","IL",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C16,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A16,LinkData!D:D,Lookup_Tables!$B$2))","v":3377.5}]
["Great Lakes",13,"Indiana","IN",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C17,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A17,LinkData!D:D,Lookup_Tables!$B$2))","v":3377.5}]
["Plains",14,"Kansas","KS",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C18,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A18,LinkData!D:D,Lookup_Tables!$B$2))","v":4416.2999999999993}]
["Southeast",15,"Kentucky","KY",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C19,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A19,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["Southeast",16,"Louisiana","LA",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C20,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A20,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["New England",17,"Massachusetts","MA",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C21,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A21,LinkData!D:D,Lookup_Tables!$B$2))","v":4000.6}]
["Mideast",18,"Maryland","MD",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C22,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A22,LinkData!D:D,Lookup_Tables!$B$2))","v":3685.3999999999996}]
["New England",19,"Maine","ME",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C23,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A23,LinkData!D:D,Lookup_Tables!$B$2))","v":4000.6}]
["Great Lakes",20,"Michigan","MI",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C24,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A24,LinkData!D:D,Lookup_Tables!$B$2))","v":3377.5}]
["Plains",21,"Minnesota","MN",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C25,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A25,LinkData!D:D,Lookup_Tables!$B$2))","v":4416.2999999999993}]
["Plains",22,"Missouri","MO",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C26,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A26,LinkData!D:D,Lookup_Tables!$B$2))","v":4416.2999999999993}]
["Southeast",23,"Mississippi","MS",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C27,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A27,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["Rocky Mountain",24,"Montana","MT",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C28,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A28,LinkData!D:D,Lookup_Tables!$B$2))","v":3580}]
["Southeast",25,"North Carolina","NC",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C29,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A29,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["Plains",26,"North Dakota","ND",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C30,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A30,LinkData!D:D,Lookup_Tables!$B$2))","v":4416.2999999999993}]
["Plains",27,"Nebraska","NE",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C31,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A31,LinkData!D:D,Lookup_Tables!$B$2))","v":4416.2999999999993}]
["New England",28,"New Hampshire","NH",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C32,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A32,LinkData!D:D,Lookup_Tables!$B$2))","v":4000.6}]
["Mideast",29,"New Jersey","NJ",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C33,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A33,LinkData!D:D,Lookup_Tables!$B$2))","v":3685.3999999999996}]
["Southwest",30,"New Mexico","NM",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C34,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A34,LinkData!D:D,Lookup_Tables!$B$2))","v":2801.2000000000003}]
["Far West",31,"Nevada","NV",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C35,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A35,LinkData!D:D,Lookup_Tables!$B$2))","v":2736.9}]
["Mideast",32,"New York","NY",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C36,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A36,LinkData!D:D,Lookup_Tables!$B$2))","v":3685.3999999999996}]
["Great Lakes",33,"Ohio","OH",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C37,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A37,LinkData!D:D,Lookup_Tables!$B$2))","v":3377.5}]
["Southwest",34,"Oklahoma","OK",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C38,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A38,LinkData!D:D,Lookup_Tables!$B$2))","v":2801.2000000000003}]
["Far West",35,"Oregon","OR",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C39,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A39,LinkData!D:D,Lookup_Tables!$B$2))","v":2736.9}]
["Mideast",36,"Pennsylvania","PA",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C40,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A40,LinkData!D:D,Lookup_Tables!$B$2))","v":3685.3999999999996}]
["New England",37,"Rhode Island","RI",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C41,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A41,LinkData!D:D,Lookup_Tables!$B$2))","v":4000.6}]
["Southeast",38,"South Carolina","SC",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C42,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A42,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["Plains",39,"South Dakota","SD",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C43,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A43,LinkData!D:D,Lookup_Tables!$B$2))","v":4416.2999999999993}]
["Southeast",40,"Tennessee","TN",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C44,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A44,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["Southwest",41,"Texas","TX",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C45,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A45,LinkData!D:D,Lookup_Tables!$B$2))","v":2801.2000000000003}]
["Rocky Mountain",42,"Utah","UT",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C46,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A46,LinkData!D:D,Lookup_Tables!$B$2))","v":3580}]
["Southeast",43,"Virginia","VA",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C47,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A47,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["New England",44,"Vermont","VT",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C48,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A48,LinkData!D:D,Lookup_Tables!$B$2))","v":4000.6}]
["Far West",45,"Washington","WA",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C49,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A49,LinkData!D:D,Lookup_Tables!$B$2))","v":2736.9}]
["Great Lakes",46,"Wisconsin","WI",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C50,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A50,LinkData!D:D,Lookup_Tables!$B$2))","v":3377.5}]
["Southeast",47,"West Virginia","WV",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C51,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A51,LinkData!D:D,Lookup_Tables!$B$2))","v":5098.2662499999988}]
["Rocky Mountain",48,"Wyoming","WY",{"$f":"IF(Lookup_Tables!$J$1=1,SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!E:E,Data!C52,LinkData!D:D,Lookup_Tables!$B$2),SUMIFS(OFFSET(LinkData!A:A,0,MATCH(Lookup_Tables!$F$2,LinkData!$A$1:$Y$1,0)-1),LinkData!F:F,Data!A52,LinkData!D:D,Lookup_Tables!$B$2))","v":3580}]

{"sheet":"Control","index":4,"n_rows":114,"n_cols":17,"rows_kept":114,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Control: Don't Touch"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Darkness",5,"the smaller the darker (max: 5,21)"]
[]
[null,null,"Steps","Threshold","RGB","Min / Max"]
[null,null,{"$f":"C16+$D$12","v":245},{"$f":"F16","v":2736.9},{"$f":"udf_RGB(255,165+C15/3.27,C15)","v":16118015},{"$f":"MAX(Data!$E$5:$E$52)","v":5098.2662499999988}]
[null,null,240,{"$f":"D15+$F$17","v":2786.0951302083336},15789823,{"$f":"MIN(Data!$E$5:$E$52)","v":2736.9}]
[null,null,235,2835.290260416667,15461887,{"$f":"(F15-F16)/(COUNT($C$15:$C$64)-2)","v":49.195130208333303}]
[null,null,230,2884.4853906250005,15133695]
[null,null,225,2933.680520833334,14805759]
[null,null,220,2982.8756510416674,14477567]
[null,null,215,3032.0707812500009,14149631]
[null,null,210,3081.2659114583344,13821439]
[null,null,205,3130.4610416666678,13493503]
[null,null,200,3179.6561718750013,13165311,null,null,null,null,null,null,null,null,null,null,null,{"$f":"240-165","v":75}]
[null,null,195,3228.8513020833348,12837375]
[null,null,190,3278.0464322916682,12509183]
[null,null,185,3327.2415625000017,12181247]
[null,null,180,3376.4366927083352,11853055]
[null,null,175,3425.6318229166686,11525119,null,null,null,null,null,null,null,null,null,null,null,{"$f":"245/75","v":3.2666666666666666}]
[null,null,170,3474.8269531250021,11196927]
[null,null,165,3524.0220833333356,10868735]
[null,null,160,3573.217213541669,10540799]
[null,null,155,3622.4123437500025,10212607]
[null,null,150,3671.607473958336,9884671]
[null,null,145,3720.8026041666694,9556479]
[null,null,140,3769.9977343750029,9228543]
[null,null,135,3819.1928645833364,8900351]
[null,null,130,3868.3879947916698,8572415]
[null,null,125,3917.5831250000033,8244223]
[null,null,120,3966.7782552083368,7916287]
[null,null,115,4015.9733854166702,7588095]
[null,null,110,4065.1685156250037,7260159]
[null,null,105,4114.3636458333367,6931967]
[null,null,100,4163.5587760416702,6604031]
[null,null,95,4212.7539062500036,6275839]
[null,null,90,4261.9490364583371,5947903]
[null,null,85,4311.1441666666706,5619711]
[null,null,80,{"$f":"D47+$F$17","v":4360.339296875004},5291519]
[null,null,75,4409.5344270833375,4963583]
[null,null,70,4458.729557291671,4635391]
[null,null,65,4507.9246875000044,4307455]
[null,null,60,4557.1198177083379,3979263]
[null,null,55,4606.3149479166714,3651327]
[null,null,50,4655.5100781250048,3323135]
[null,null,45,4704.7052083333383,2995199]
[null,null,40,4753.9003385416718,2667007]
[null,null,35,4803.0954687500052,2339071]
[null,null,30,4852.2905989583387,2010879]
[null,null,25,4901.4857291666722,1682943]
[null,null,20,4950.6808593750056,1354751]
[null,null,15,4999.8759895833391,1026815]
[null,null,10,5049.0711197916726,698623]
[null,null,{"$f":"C64+$D$12","v":5},5098.266250000006,370687]
[null,null,0,5147.4613802083395,{"$f":"udf_RGB(255,165+C64/3.27,C64)","v":42495},{"$f":"udf_RGB(C64,C64,C64)","v":0}]
[]
[null,null,"Name","Autoshape"]
[null,null,"D_AL","S_AL"]
[null,null,"D_AR","S_AR"]
[null,null,"D_AZ","S_AZ"]
[null,null,"D_CA","S_CA"]
[null,null,"D_CO","S_CO"]
[null,null,"D_CT","S_CT",null,null,null,null,null,null,null,null,165]
[null,null,"D_DE","S_DE",null,null,null,null,null,null,null,null,240]
[null,null,"D_FL","S_FL",null,null,null,null,null,null,null,null,{"$f":"M73-M72","v":75}]
[null,null,"D_GA","S_GA"]
[null,null,"D_IA","S_IA"]
[null,null,"D_ID","S_ID"]
[null,null,"D_IL","S_IL"]
[null,null,"D_IN","S_IN"]
[null,null,"D_KS","S_KS"]
[null,null,"D_KY","S_KY"]
[null,null,"D_LA","S_LA"]
[null,null,"D_MA","S_MA"]
[null,null,"D_MD","S_MD"]
[null,null,"D_ME","S_ME"]
[null,null,"D_MI","S_MI"]
[null,null,"D_MN","S_MN"]
[null,null,"D_MO","S_MO"]
[null,null,"D_MS","S_MS"]
[null,null,"D_MT","S_MT"]
[null,null,"D_NC","S_NC"]
[null,null,"D_ND","S_ND"]
[null,null,"D_NE","S_NE"]
[null,null,"D_NH","S_NH"]
[null,null,"D_NJ","S_NJ"]
[null,null,"D_NM","S_NM"]
[null,null,"D_NV","S_NV"]
[null,null,"D_NY","S_NY"]
[null,null,"D_OH","S_OH"]
[null,null,"D_OK","S_OK"]
[null,null,"D_OR","S_OR"]
[null,null,"D_PA","S_PA"]
[null,null,"D_RI","S_RI"]
[null,null,"D_SC","S_SC"]
[null,null,"D_SD","S_SD"]
[null,null,"D_TN","S_TN"]
[null,null,"D_TX","S_TX"]
[null,null,"D_UT","S_UT"]
[null,null,"D_VA","S_VA"]
[null,null,"D_VT","S_VT"]
[null,null,"D_WA","S_WA"]
[null,null,"D_WI","S_WI"]
[null,null,"D_WV","S_WV"]
[null,null,"D_WY","S_WY"]

{"sheet":"Dashboard","index":5,"n_rows":14,"n_cols":23,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Lookup_Tables!C2","v":"August 2014"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Team",{"$f":"IF(IF(Lookup_Tables!$N$1=1,Lookup_Tables!Q1,IF(Lookup_Tables!$N$1=2,Lookup_Tables!Q2,IF(Lookup_Tables!$N$1=3,Lookup_Tables!Q3,\"\")))=0,\"\",IF(Lookup_Tables!$N$1=1,Lookup_Tables!Q1,IF(Lookup_Tables!$N$1=2,Lookup_Tables!Q2,IF(Lookup_Tables!$N$1=3,Lookup_Tables!Q3,\"\"))))","v":"Login Hours"},{"$f":"IF(IF(Lookup_Tables!$N$1=1,Lookup_Tables!R1,IF(Lookup_Tables!$N$1=2,Lookup_Tables!R2,IF(Lookup_Tables!$N$1=3,Lookup_Tables!R3,\"\")))=0,\"\",IF(Lookup_Tables!$N$1=1,Lookup_Tables!R1,IF(Lookup_Tables!$N$1=2,Lookup_Tables!R2,IF(Lookup_Tables!$N$1=3,Lookup_Tables!R3,\"\"))))","v":"Talk Time"},{"$f":"IF(IF(Lookup_Tables!$N$1=1,Lookup_Tables!S1,IF(Lookup_Tables!$N$1=2,Lookup_Tables!S2,IF(Lookup_Tables!$N$1=3,Lookup_Tables!S3,\"\")))=0,\"\",IF(Lookup_Tables!$N$1=1,Lookup_Tables!S1,IF(Lookup_Tables!$N$1=2,Lookup_Tables!S2,IF(Lookup_Tables!$N$1=3,Lookup_Tables!S3,\"\"))))","v":"Hold Time"},{"$f":"IF(IF(Lookup_Tables!$N$1=1,Lookup_Tables!T1,IF(Lookup_Tables!$N$1=2,Lookup_Tables!T2,IF(Lookup_Tables!$N$1=3,Lookup_Tables!T3,\"\")))=0,\"\",IF(Lookup_Tables!$N$1=1,Lookup_Tables!T1,IF(Lookup_Tables!$N$1=2,Lookup_Tables!T2,IF(Lookup_Tables!$N$1=3,Lookup_Tables!T3,\"\"))))","v":""},{"$f":"IF(IF(Lookup_Tables!$N$1=1,Lookup_Tables!U1,IF(Lookup_Tables!$N$1=2,Lookup_Tables!U2,IF(Lookup_Tables!$N$1=3,Lookup_Tables!U3,\"\")))=0,\"\",IF(Lookup_Tables!$N$1=1,Lookup_Tables!U1,IF(Lookup_Tables!$N$1=2,Lookup_Tables!U2,IF(Lookup_Tables!$N$1=3,Lookup_Tables!U3,\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Team A: Far West",{"$f":"TEXT(IF(Lookup_Tables!$N$1=1,SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!G:G),IF(Lookup_Tables!$N$1=2,SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!J:J),IF(Lookup_Tables!$N$1=3,SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!S:S)))),\"#,##0\")","v":"137"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!H:H),\"#,##0\"),IF(Lookup_Tables!$N$1=2,N7/SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!G:G),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!O:O)/N7,\"0.00%\"))))","v":"111"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!I:I),\"#,##0\"),IF(Lookup_Tables!$N$1=2,TEXT(SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!L:L),\"$#,##0\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!P:P)/N7,\"0.00%\"))))","v":"26"},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,TEXT(P7/SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!G:G),\"$#,##0.00\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!Q:Q)/N7,\"0.00%\"))))","v":""},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,\"\",IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M7,6),LinkData!R:R)/N7,\"0.00%\"))))","v":""},null,null,null,null,{"$f":"N14/1","v":123}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Team B: Great Lakes",{"$f":"TEXT(IF(Lookup_Tables!$N$1=1,SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!G:G),IF(Lookup_Tables!$N$1=2,SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!J:J),IF(Lookup_Tables!$N$1=3,SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!S:S)))),\"#,##0\")","v":"152"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!H:H),\"#,##0\"),IF(Lookup_Tables!$N$1=2,N8/SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!G:G),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!O:O)/N8,\"0.00%\"))))","v":"137"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!I:I),\"#,##0\"),IF(Lookup_Tables!$N$1=2,TEXT(SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!L:L),\"$#,##0\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!P:P)/N8,\"0.00%\"))))","v":"15"},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,TEXT(P8/SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!G:G),\"$#,##0.00\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!Q:Q)/N8,\"0.00%\"))))","v":""},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,\"\",IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M8,6),LinkData!R:R)/N8,\"0.00%\"))))","v":""},null,null,null,null,{"$f":"N13/1","v":250}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Team C: Mideast",{"$f":"TEXT(IF(Lookup_Tables!$N$1=1,SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!G:G),IF(Lookup_Tables!$N$1=2,SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!J:J),IF(Lookup_Tables!$N$1=3,SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!S:S)))),\"#,##0\")","v":"152"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!H:H),\"#,##0\"),IF(Lookup_Tables!$N$1=2,N9/SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!G:G),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!O:O)/N9,\"0.00%\"))))","v":"138"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!I:I),\"#,##0\"),IF(Lookup_Tables!$N$1=2,TEXT(SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!L:L),\"$#,##0\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!P:P)/N9,\"0.00%\"))))","v":"15"},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,TEXT(P9/SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!G:G),\"$#,##0.00\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!Q:Q)/N9,\"0.00%\"))))","v":""},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,\"\",IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M9,6),LinkData!R:R)/N9,\"0.00%\"))))","v":""},null,null,null,null,{"$f":"N12/1","v":154}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Team D: New England",{"$f":"TEXT(IF(Lookup_Tables!$N$1=1,SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!G:G),IF(Lookup_Tables!$N$1=2,SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!J:J),IF(Lookup_Tables!$N$1=3,SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!S:S)))),\"#,##0\")","v":"180"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!H:H),\"#,##0\"),IF(Lookup_Tables!$N$1=2,N10/SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!G:G),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!O:O)/N10,\"0.00%\"))))","v":"163"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!I:I),\"#,##0\"),IF(Lookup_Tables!$N$1=2,TEXT(SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!L:L),\"$#,##0\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!P:P)/N10,\"0.00%\"))))","v":"18"},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,TEXT(P10/SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!G:G),\"$#,##0.00\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!Q:Q)/N10,\"0.00%\"))))","v":""},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,\"\",IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M10,6),LinkData!R:R)/N10,\"0.00%\"))))","v":""},null,null,null,null,{"$f":"N11/1","v":214}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Team E: Plains",{"$f":"TEXT(IF(Lookup_Tables!$N$1=1,SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!G:G),IF(Lookup_Tables!$N$1=2,SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!J:J),IF(Lookup_Tables!$N$1=3,SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!S:S)))),\"#,##0\")","v":"214"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!H:H),\"#,##0\"),IF(Lookup_Tables!$N$1=2,N11/SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!G:G),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!O:O)/N11,\"0.00%\"))))","v":"194"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!I:I),\"#,##0\"),IF(Lookup_Tables!$N$1=2,TEXT(SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!L:L),\"$#,##0\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!P:P)/N11,\"0.00%\"))))","v":"21"},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,TEXT(P11/SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!G:G),\"$#,##0.00\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!Q:Q)/N11,\"0.00%\"))))","v":""},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,\"\",IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M11,6),LinkData!R:R)/N11,\"0.00%\"))))","v":""},null,null,null,null,{"$f":"N10/1","v":180}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Team F: Rocky Mountain",{"$f":"TEXT(IF(Lookup_Tables!$N$1=1,SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!G:G),IF(Lookup_Tables!$N$1=2,SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!J:J),IF(Lookup_Tables!$N$1=3,SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!S:S)))),\"#,##0\")","v":"154"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!H:H),\"#,##0\"),IF(Lookup_Tables!$N$1=2,N12/SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!G:G),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!O:O)/N12,\"0.00%\"))))","v":"139"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!I:I),\"#,##0\"),IF(Lookup_Tables!$N$1=2,TEXT(SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!L:L),\"$#,##0\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!P:P)/N12,\"0.00%\"))))","v":"15"},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,TEXT(P12/SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!G:G),\"$#,##0.00\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!Q:Q)/N12,\"0.00%\"))))","v":""},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,\"\",IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M12,6),LinkData!R:R)/N12,\"0.00%\"))))","v":""},null,null,null,null,{"$f":"N9/1","v":152}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Team G: Southeast",{"$f":"TEXT(IF(Lookup_Tables!$N$1=1,SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!G:G),IF(Lookup_Tables!$N$1=2,SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!J:J),IF(Lookup_Tables!$N$1=3,SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!S:S)))),\"#,##0\")","v":"250"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!H:H),\"#,##0\"),IF(Lookup_Tables!$N$1=2,N13/SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!G:G),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!O:O)/N13,\"0.00%\"))))","v":"225"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!I:I),\"#,##0\"),IF(Lookup_Tables!$N$1=2,TEXT(SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!L:L),\"$#,##0\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!P:P)/N13,\"0.00%\"))))","v":"25"},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,TEXT(P13/SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!G:G),\"$#,##0.00\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!Q:Q)/N13,\"0.00%\"))))","v":""},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,\"\",IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M13,6),LinkData!R:R)/N13,\"0.00%\"))))","v":""},null,null,null,null,{"$f":"N8/1","v":152}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Team H: Southwest",{"$f":"TEXT(IF(Lookup_Tables!$N$1=1,SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!G:G),IF(Lookup_Tables!$N$1=2,SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!J:J),IF(Lookup_Tables!$N$1=3,SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!S:S)))),\"#,##0\")","v":"123"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!H:H),\"#,##0\"),IF(Lookup_Tables!$N$1=2,N14/SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!G:G),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!O:O)/N14,\"0.00%\"))))","v":"111"},{"$f":"IF(Lookup_Tables!$N$1=1,TEXT(SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!I:I),\"#,##0\"),IF(Lookup_Tables!$N$1=2,TEXT(SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!L:L),\"$#,##0\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!P:P)/N14,\"0.00%\"))))","v":"12"},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,TEXT(P14/SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!G:G),\"$#,##0.00\"),IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!Q:Q)/N14,\"0.00%\"))))","v":""},{"$f":"IF(Lookup_Tables!$N$1=1,\"\",IF(Lookup_Tables!$N$1=2,\"\",IF(Lookup_Tables!$N$1=3,TEXT(SUMIF(LinkData!$A:$A,LEFT($M14,6),LinkData!R:R)/N14,\"0.00%\"))))","v":""},null,null,null,null,{"$f":"N7/1","v":137}]