{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ReadMe","Dashboard","Team Performance","Calculation_Sheet"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"comments":1,"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":"ReadMe","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,1,6,6],[3,7,6,8]]}
[]
[]
[]
[null,"Reading this document will help you navigate the dashboard"]

{"sheet":"Dashboard","index":1,"n_rows":26,"n_cols":26,"rows_kept":26,"cut":false,"hidden":false,"merged":[[18,7,19,7],[18,14,19,14],[18,22,19,22],[22,22,22,23],[23,6,23,7],[23,12,23,13],[23,14,23,15],[23,18,23,19],[23,20,23,21],[23,22,23,23],[22,6,22,7],[22,12,22,13],[22,14,22,15],[22,18,22,19],[22,20,22,21],[20,14,21,15],[20,16,21,16],[20,20,21,21],[20,22,21,23],[20,24,21,24],[20,6,21,7],[20,8,21,8],[20,9,21,9],[20,10,21,10],[20,12,21,13],[13,12,14,13],[13,8,14,8],[11,9,11,19],[13,6,14,7],[13,24,14,24],[13,16,14,16],[0,0,27,0],[0,2,0,3],[3,15,3,16],[3,17,3,18],[3,19,3,20],[11,1,11,3],[18,1,18,3],[25,1,25,3],[2,1,2,3],[4,1,4,3],[4,4,27,4],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[0,4,1,24],[1,1,1,3],[14,2,15,3],[12,2,13,3],[14,1,15,1],[3,21,3,22],[2,4,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[13,10,14,10],[13,9,14,9],[2,5,2,24],[3,23,3,24],[13,14,14,15],[15,18,15,19],[16,18,16,19],[16,2,17,3],[15,6,15,7],[16,6,16,7],[15,14,15,15],[16,14,16,15],[15,12,15,13],[16,12,16,13],[15,22,15,23],[16,22,16,23],[13,22,14,23],[13,20,14,21],[15,20,15,21],[16,20,16,21]]}
[null,"Region:","Alabama"]
[]
[null,"Overall Statistics",null,null,null,"Team Wise Analysis"]
[null,null,null,null,null,"Team A",null,"Team B",null,"Team C",null,"Team D",null,"Team E",null,"Team F",null,"Team G",null,"Team H",null,"Team I",null,"Team J"]
[null,{"$f":"INDEX(Products,MATCH($C$1,Regions,0))","v":"Product 1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IFERROR(MAX((J7:U7=G7)*(J8:U8)),0)> IFERROR(MAX((J7:U7=G7)*(J9:U9)),0),I8,I9)","v":"Flavia"}]
[null,"Calls",{"$f":"SUMIF('Team Performance'!$E$2:$E$103,Dashboard!$C$1,'Team Performance'!$M$2:$M$103)","v":5921},null,null,"Top Rep By","Login Hrs",{"$f":"\"->\"","v":"->"},"Name","Login Hrs","Talk Time","Calls","Sales/Hr","Total Sales","Rev/Hr","Total Rev","Excellent","Good","Fair","Poor","CSAT"]
[null,"Sales",{"$f":"SUMIF('Team Performance'!$E$2:$E$103,Dashboard!$C$1,'Team Performance'!$I$2:$I$103)","v":351},null,null,null,null,null,{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!B\"&    Calculation_Sheet!$K$25 &\":\"&\"B\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":"Sydnee"},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!F\"&    Calculation_Sheet!$K$25 &\":\"&\"F\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":7},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!G\"&    Calculation_Sheet!$K$25 &\":\"&\"G\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":6},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!M\"&    Calculation_Sheet!$K$25 &\":\"&\"M\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":358},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!J\"&    Calculation_Sheet!$K$25 &\":\"&\"J\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":3.1428571428571428},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!I\"&    Calculation_Sheet!$K$25 &\":\"&\"I\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":22},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!L\"&    Calculation_Sheet!$K$25 &\":\"&\"L\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":106.85714285714286},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!K\"&    Calculation_Sheet!$K$25 &\":\"&\"K\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":748},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!N\"&    Calculation_Sheet!$K$25 &\":\"&\"N\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":24},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!O\"&    Calculation_Sheet!$K$25 &\":\"&\"O\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":40},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!P\"&    Calculation_Sheet!$K$25 &\":\"&\"P\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":32},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!Q\"&    Calculation_Sheet!$K$25 &\":\"&\"Q\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":15},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!S\"&    Calculation_Sheet!$K$25 &\":\"&\"S\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y11)-ROW($Y$11)),\"\")","v":0.13646055437100213}]
[null,"Revenue",{"$f":"SUMIF('Team Performance'!$E$2:$E$103,Dashboard!$C$1,'Team Performance'!$K$2:$K$103)","v":11934},null,null,null,null,null,{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!B\"&    Calculation_Sheet!$K$25 &\":\"&\"B\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":"Flavia"},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!F\"&    Calculation_Sheet!$K$25 &\":\"&\"F\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":7.6},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!G\"&    Calculation_Sheet!$K$25 &\":\"&\"G\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":6.6},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!M\"&    Calculation_Sheet!$K$25 &\":\"&\"M\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":302},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!J\"&    Calculation_Sheet!$K$25 &\":\"&\"J\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":1.9736842105263159},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!I\"&    Calculation_Sheet!$K$25 &\":\"&\"I\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":15},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!L\"&    Calculation_Sheet!$K$25 &\":\"&\"L\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":67.10526315789474},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!K\"&    Calculation_Sheet!$K$25 &\":\"&\"K\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":510},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!N\"&    Calculation_Sheet!$K$25 &\":\"&\"N\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":24},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!O\"&    Calculation_Sheet!$K$25 &\":\"&\"O\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":37},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!P\"&    Calculation_Sheet!$K$25 &\":\"&\"P\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":33},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!Q\"&    Calculation_Sheet!$K$25 &\":\"&\"Q\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":12},{"$f":"IF(INDEX(INDIRECT(\"'Team Performance'!A\"&    Calculation_Sheet!$K$25 &\":\"&\"A\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)) = Calculation_Sheet!$J$26,INDEX(INDIRECT(\"'Team Performance'!S\"&    Calculation_Sheet!$K$25 &\":\"&\"S\"&  Calculation_Sheet!$L$25), Calculation_Sheet!$K$26+ ROW($Y12)-ROW($Y$11)),\"\")","v":0.14950980392156862}]
[]
[]
[null,"Talk Time Productvity",null,null,null,null,null,null,null,{"$f":"  \"Comparison of \" & Calculation_Sheet!$J$26  &  \"  against overall performance of  \" & Dashboard!C1  & \" region\"","v":"Comparison of Team A  against overall performance of  Alabama region"}]
[null,"Total Login Hrs",{"$f":"$C$15","v":0.87022900763358779}]
[null,{"$f":"SUMIF('Team Performance'!$E$2:$E$103,Dashboard!$C$1,'Team Performance'!$F$2:$F$103)","v":131},null,null,null,"Name",{"$f":"\"Avg Login Time for \" & $C$1","v":"Avg Login Time for Alabama"},null,"Avg Login time by Rep","% \nDifference",null,"Name",{"$f":"\"Avg Sales/hr \nfor \" & $C$1","v":"Avg Sales/hr \nfor Alabama"},null,"Avg Sales made by Rep",null,"% \nDifference",null,null,"Name",{"$f":"\" Avg Rev/hr for \" & $C$1","v":" Avg Rev/hr for Alabama"},null,"Avg Rev/hr made by Rep",null,"% \nDifference"]
[null,null,{"$f":"$B$18/$B$14","v":0.87022900763358779}]
[null,null,null,null,null,{"$f":"$I$8","v":"Sydnee"},{"$f":"AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Login Hours])","v":7.7058823529411766},null,{"$f":"$J$8","v":7},{"$f":"((I16*100)/G16)-100","v":-9.1603053435114532},null,{"$f":"$I$8","v":"Sydnee"},{"$f":"AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Sales Per Hour])","v":2.678901987738282},null,{"$f":"$M$8","v":3.1428571428571428},null,{"$f":"((O16*100)/M16)-100","v":17.318855159406723},null,{"$f":"$I$8","v":"Sydnee"},null,{"$f":"AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Revenue Per Hour])","v":91.082667583101582},null,{"$f":"$O$8","v":106.85714285714286},null,{"$f":"((W16*100)/U16)-100","v":17.318855159406738}]
[null,"Talk Time Hrs",null,null,null,{"$f":"$I$9","v":"Flavia"},{"$f":"IF(F17<>\"\", AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Login Hours]),\"\")","v":7.7058823529411766},null,{"$f":"$J$9","v":7.6},{"$f":"IF(I17<>\"\",((I17*100)/G17)-100,\"\")","v":-1.3740458015267194},null,{"$f":"$I$9","v":"Flavia"},{"$f":"IF(L17<>\"\", AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Sales Per Hour]),\"\")","v":2.678901987738282},null,{"$f":"$M$9","v":1.9736842105263159},null,{"$f":"IF(M17<>\"\",((O17*100)/M17)-100,\"\")","v":-26.324881628363002},null,{"$f":"$I$9","v":"Flavia"},null,{"$f":"IF($S$17<>\"\", AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Revenue Per Hour]),\"\")","v":91.082667583101582},null,{"$f":"$O$9","v":67.10526315789474},null,{"$f":"IF(W17<>\"\",((W17*100)/U17)-100,\"\")","v":-26.324881628362988}]
[null,{"$f":"SUMIF('Team Performance'!$E$2:$E$103,Dashboard!$C$1,'Team Performance'!$G$2:$G$103)","v":114}]
[null,"Call Quality",null,null,null,null,null,{"$f":"\"--->\"","v":"--->"},null,null,null,null,null,null,{"$f":"\"--->\"","v":"--->"},null,null,null,null,null,null,null,{"$f":"\"--->\"","v":"--->"}]
[]
[null,"Excellent",{"$f":"INDEX(Calculation_Sheet!$B$17:$G$21,ROW(2:2),MATCH($C$1,Calculation_Sheet!$B$17:$G$17,0))","v":426},null,null,"Name",{"$f":"\"Avg calls for \" & $C$1","v":"Avg calls for Alabama"},null,"Calls made\nby Rep","% \nDifference",null,"Name",{"$f":"\"Avg sales \nfor \" & $C$1","v":"Avg sales \nfor Alabama"},null,"Sales made By Rep",null,"% \nDifference",null,null,"Name",{"$f":"\" Avg Rev for \" & $C$1","v":" Avg Rev for Alabama"},null,"Avg Rev made\nby Rep",null,"% \nDifference"]
[null,"Good",{"$f":"INDEX(Calculation_Sheet!$B$17:$G$21,ROW(3:3),MATCH($C$1,Calculation_Sheet!$B$17:$G$17,0))","v":590}]
[null,"Fair",{"$f":"INDEX(Calculation_Sheet!$B$17:$G$21,ROW(4:4),MATCH($C$1,Calculation_Sheet!$B$17:$G$17,0))","v":589},null,null,{"$f":"$I$8","v":"Sydnee"},{"$f":"AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Calls])","v":348.29411764705884},null,{"$f":"$L$8","v":358},{"$f":"((I23*100)/G23)-100","v":2.7866914372572182},null,{"$f":"$I$8","v":"Sydnee"},{"$f":"AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Sales])","v":20.647058823529413},null,{"$f":"$N$8","v":22},null,{"$f":"((O23*100)/M23)-100","v":6.5527065527065531},null,{"$f":"$I$8","v":"Sydnee"},null,{"$f":"AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Revenue])","v":702},null,{"$f":"$P$8","v":748},null,{"$f":"((W23*100)/U23)-100","v":6.5527065527065531}]
[null,"Poor",{"$f":"INDEX(Calculation_Sheet!$B$17:$G$21,ROW(5:5),MATCH($C$1,Calculation_Sheet!$B$17:$G$17,0))","v":210},null,null,{"$f":"$I$9","v":"Flavia"},{"$f":"IF(F24<>\"\", AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Calls]),\"\")","v":348.29411764705884},null,{"$f":"$L$9","v":302},{"$f":"IF(I24<>\"\",((I24*100)/G24)-100,\"\")","v":-13.291673703766264},null,{"$f":"$I$9","v":"Flavia"},{"$f":"IF(L24<>\"\", AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Sales]),\"\")","v":20.647058823529413},null,{"$f":"$N$9","v":15},null,{"$f":"IF(M24<>\"\",((O24*100)/M24)-100,\"\")","v":-27.350427350427353},null,{"$f":"$I$9","v":"Flavia"},null,{"$f":"IF($S$17<>\"\", AVERAGEIF(Data[Region],Dashboard!$C$1,Data[Revenue]),\"\")","v":702},null,{"$f":"$P$9","v":510},null,{"$f":"IF(W24<>\"\",((W24*100)/U24)-100,\"\")","v":-27.350427350427353}]
[]
[null,"Customer Statisfaction"]

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

{"sheet":"Calculation_Sheet","index":3,"n_rows":85,"n_cols":14,"rows_kept":85,"cut":false,"hidden":false,"merged":[[15,0,15,6],[23,0,23,2],[23,4,23,6],[22,8,22,11]]}
["Region","Product"]
["Alabama","Product 1"]
["California","Product 2"]
["Colorado","Product 1"]
["Connecticut","Product 2"]
["Florida","Product 1"]
["Hawaii","Product 2"]
[]
[]
[]
[]
[]
[]
[]
[]
["Call Quality Summation"]
["Region","Alabama","California","Colorado","Connecticut","Florida","Hawaii"]
["Excellent",426,426,441,445,431,404]
["Good",590,582,607,584,604,571]
["Fair",589,589,579,605,607,585]
["Poor",210,204,211,212,202,212]
[]
[null,null,null,null,null,null,null,null,"For Agent Display in Grid"]
["Customer Satisfaction (Excellent/Good) Results",null,null,null,"CSAT Graph Data",null,null,null,null,null,"Starting Row","Total Rows",null,"Top Agent By"]
["Region","Team","CSAT",null,"Region",{"$f":"Dashboard!C1","v":"Alabama"},"Sparkline",null,"Selected Country",{"$f":"Dashboard!$C$1","v":"Alabama"},{"$f":"MATCH(Calculation_Sheet!$J$25,Data[Region],0)+1","v":2},{"$f":"COUNTA(Data[Team]) + 1","v":103},null,"Login Hrs"]
["Alabama","Team A",0.28597035829257078,null,"Team A",{"$f":"INDEX(Calculation_Sheet!$A$26:$C$85,MATCH($F$25,Calculation_Sheet!$A$26:$A$85,0)+ ROW($E26)-ROW($E$26),3)","v":0.28597035829257078},null,null,"Selected Team","Team A",{"$f":"MATCH(Calculation_Sheet!$J$26,INDIRECT(\"'Team Performance'!A\"&  Calculation_Sheet!$K$25&\":\"&\"A\"&Calculation_Sheet!$L$25),0)","v":1},{"$f":"COUNTA(Data[Team]) + 1","v":103},null,"Talk Time"]
["Alabama","Team B",0.27803392592910292,null,"Team B",{"$f":"INDEX(Calculation_Sheet!$A$26:$C$85,MATCH($F$25,Calculation_Sheet!$A$26:$A$85,0)+ ROW($E27)-ROW($E$26),3)","v":0.27803392592910292},null,null,null,null,null,null,null,"Calls"]
["Alabama","Team C",0.13865546218487396,null,"Team C",{"$f":"INDEX(Calculation_Sheet!$A$26:$C$85,MATCH($F$25,Calculation_Sheet!$A$26:$A$85,0)+ ROW($E28)-ROW($E$26),3)","v":0.13865546218487396},null,null,null,null,null,null,null,"Sales/Hr"]
["Alabama","Team D",0.25307846471219475,null,"Team D",{"$f":"INDEX(Calculation_Sheet!$A$26:$C$85,MATCH($F$25,Calculation_Sheet!$A$26:$A$85,0)+ ROW($E29)-ROW($E$26),3)","v":0.25307846471219475},null,null,null,null,null,null,null,"Total Sales"]
["Alabama","Team E",0.28055555555555556,null,"Team E",{"$f":"INDEX(Calculation_Sheet!$A$26:$C$85,MATCH($F$25,Calculation_Sheet!$A$26:$A$85,0)+ ROW($E30)-ROW($E$26),3)","v":0.28055555555555556},null,null,null,null,null,null,null,"Rev/Hr"]
["Alabama","Team F",0.11799999999999999,null,"Team F",{"$f":"INDEX(Calculation_Sheet!$A$26:$C$85,MATCH($F$25,Calculation_Sheet!$A$26:$A$85,0)+ ROW($E31)-ROW($E$26),3)","v":0.11799999999999999},null,null,null,null,null,null,null,"Total Rev"]
["Alabama","Team G",0.24061030665193039,null,"Team G",{"$f":"INDEX(Calculation_Sheet!$A$26:$C$85,MATCH($F$25,Calculation_Sheet!$A$26:$A$85,0)+ ROW($E32)-ROW($E$26),3)","v":0.24061030665193039},null,null,null,null,null,null,null,"Excellent"]
["Alabama","Team H",0.24951590594744122,null,"Team H",{"$f":"INDEX(Calculation_Sheet!$A$26:$C$85,MATCH($F$25,Calculation_Sheet!$A$26:$A$85,0)+ ROW($E33)-ROW($E$26),3)","v":0.24951590594744122},null,null,null,null,null,null,null,"Good"]
["Alabama","Team I",0.26987176408433788,null,"Team I",{"$f":"INDEX(Calculation_Sheet!$A$26:$C$85,MATCH($F$25,Calculation_Sheet!$A$26:$A$85,0)+ ROW($E34)-ROW($E$26),3)","v":0.26987176408433788},null,null,null,null,null,null,null,"Fair"]
["Alabama","Team J",0.126,null,"Team J",{"$f":"INDEX(Calculation_Sheet!$A$26:$C$85,MATCH($F$25,Calculation_Sheet!$A$26:$A$85,0)+ ROW($E35)-ROW($E$26),3)","v":0.126},null,null,null,null,null,null,null,"Poor"]
["California","Team A",0.23991673172001041,null,null,null,null,null,null,null,null,null,null,"CSAT"]
["California","Team B",0.25645539906103287]
["California","Team C",0.14132762312633834]
["California","Team D",0.24782972874293938]
["California","Team E",0.24705712298199489]
["California","Team F",0.15349887133182843]
["California","Team G",0.26623006833712981]
["California","Team H",0.29622014324389156]
["California","Team I",0.13411764705882354]
["California","Team J",0.2494347447989832]
["Colorado","Team A",0.28139158576051782]
["Colorado","Team B",0.12869198312236288]
["Colorado","Team C",0.24125975440384478]
["Colorado","Team D",0.28562202430122707]
["Colorado","Team E",0.12291666666666666]
["Colorado","Team F",0.3082413187887405]
["Colorado","Team G",0.26403430937592431]
["Colorado","Team H",0.13793103448275862]
["Colorado","Team I",0.28569363117183544]
["Colorado","Team J",0.29212860310421285]
["Connecticut","Team A",0.27682229861325447]
["Connecticut","Team B",0.13179916317991633]
["Connecticut","Team C",0.24773684903548621]
["Connecticut","Team D",0.25798345081213608]
["Connecticut","Team E",0.13129102844638948]
["Connecticut","Team F",0.24384928383366297]
["Connecticut","Team G",0.23216273656512498]
["Connecticut","Team H",0.11670020120724346]
["Connecticut","Team I",0.24637260148306706]
["Connecticut","Team J",0.29120849328735332]
["Florida","Team A",0.1336116910229645]
["Florida","Team B",0.26489961483355973]
["Florida","Team C",0.25459770114942526]
["Florida","Team D",0.13333333333333333]
["Florida","Team E",0.2618130533707147]
["Florida","Team F",0.26273552679782569]
["Florida","Team G",0.14125560538116591]
["Florida","Team H",0.24698583782428876]
["Florida","Team I",0.26898189972622588]
["Florida","Team J",0.23577235772357724]
["Hawaii","Team A",0.12422360248447205]
["Hawaii","Team B",0.25299375349144282]
["Hawaii","Team C",0.24910215171293837]
["Hawaii","Team D",0.13734939759036144]
["Hawaii","Team E",0.23446454312133036]
["Hawaii","Team F",0.23485489008612215]
["Hawaii","Team G",0.11608961303462322]
["Hawaii","Team H",0.28826490995165693]
["Hawaii","Team I",0.26692940079667771]
["Hawaii","Team J",0.27188940092165897]