[{"tab":"Table","title":"BDA Closed Deals Report","headline":[{"label":"Total balance","value":3270465.37,"format":"$"},{"label":"Total deals","value":39,"format":"General"},{"label":"Avg. deal","value":83858.08641025641,"format":"$"}],"columns":{"0":[{"label":"Closer","path":[],"format":"text","kind":"label"},{"label":"Sum of Final Balance","path":["App Signed"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Approved"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Active Client"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Payment Plan Hold"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Payment NSF"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Grand Total"],"format":"\"$\"#,##0.00","kind":"total"}],"1":[{"label":"Closer","path":[],"format":"text","kind":"label"},{"label":"Count of Final Balance","path":["App Signed"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Approved"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Active Client"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Payment Plan Hold"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Payment NSF"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Grand Total"],"format":"General","kind":"total"}],"2":[{"label":"Lead Source","path":[],"format":"text","kind":"label"},{"label":"Balance","path":[],"format":"\"$\"#,##0.00","kind":"total"},{"label":"Deals","path":[],"format":"General","kind":"total"},{"label":"AWS","path":[],"format":"General","kind":"total"},{"label":"Average","path":[],"format":"\"$\"#,##0.00","kind":"total"}],"3":[{"label":"Opener","path":[],"format":"text","kind":"label"},{"label":"Balance","path":[],"format":"\"$\"#,##0.00","kind":"total"},{"label":"Deals","path":[],"format":"General","kind":"total"},{"label":"AWS","path":[],"format":"General","kind":"total"},{"label":"Average","path":[],"format":"\"$\"#,##0.00","kind":"total"}],"4":[{"label":"Closer","path":[],"format":"text","kind":"label"},{"label":" ","path":["NO"],"format":"0","kind":"detail"},{"label":" ","path":["YES"],"format":"0","kind":"detail"},{"label":" ","path":["Grand Total"],"format":"0","kind":"total"}],"5":[{"label":"Closer","path":[],"format":"text","kind":"label"},{"label":"Average Days","path":[],"format":"0.0","kind":"total"},{"label":"Deals","path":[],"format":"General","kind":"total"}]},"rows":{"0":[{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[251062.5,55494.49,441677.33999999997,52483.28,107665.0,908382.61]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[185785.6,null,556804.89,65472.04,86744.36,894806.89]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[98647.99,null,499275.4,null,null,597923.39]},{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[null,null,282769.7,91447.55,68673.5,442890.75]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[118754.98999999999,null,69496.99,null,null,188251.98]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[80908.62,76649.1,null,null,null,157557.72]},{"label":"Geof Reusch","path":["Geof Reusch"],"level":0,"kind":"detail","cells":[null,null,80652.03,null,null,80652.03]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[735159.7,132143.59,1930676.35,209402.87,263082.86,3270465.37]}],"1":[{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[0,0,3,1,1,5]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[1,0,4,0,0,5]},{"label":"Geof Reusch","path":["Geof Reusch"],"level":0,"kind":"detail","cells":[0,0,1,0,0,1]},{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[1,1,6,1,1,10]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[2,0,7,1,1,11]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[2,0,2,0,0,4]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[2,1,0,0,0,3]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[8,2,23,3,3,39]}],"2":[{"label":"Opener Transfer Form (READYMODE) - TRANSFER","path":["Opener Transfer Form (READYMODE) - TRANSFER"],"level":0,"kind":"detail","cells":[2242862.69,26,0.0,86263.94961538461]},{"label":"Opener Transfer Form (VICIDIALER) - TRANSFER","path":["Opener Transfer Form (VICIDIALER) - TRANSFER"],"level":0,"kind":"detail","cells":[55494.49,1,0.0,55494.49]},{"label":"SMS","path":["SMS"],"level":0,"kind":"detail","cells":[329405.25,5,0.0,65881.05]},{"label":"LFO Applications - TRANSFERS","path":["LFO Applications - TRANSFERS"],"level":0,"kind":"detail","cells":[65760.4,1,0.0,65760.4]},{"label":"AS Applications","path":["AS Applications"],"level":0,"kind":"detail","cells":[115303.0,2,0.0,57651.5]},{"label":"Asad Afzal","path":["Asad Afzal"],"level":0,"kind":"detail","cells":[251062.5,1,0.0,251062.5]},{"label":"BDA Velocify","path":["BDA Velocify"],"level":0,"kind":"detail","cells":[107665.0,1,0.0,107665.0]},{"label":"DRIPS PT Applications","path":["DRIPS PT Applications"],"level":0,"kind":"detail","cells":[37440.0,1,0.0,37440.0]},{"label":"MCA PT Applications - TRANSFERS","path":["MCA PT Applications - TRANSFERS"],"level":0,"kind":"detail","cells":[65472.04,1,0.0,65472.04]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[3270465.37,39,0.0,83858.08641025641]}],"3":[{"label":"Velocify TEAM Majd","path":["Velocify TEAM Majd"],"level":0,"kind":"subtotal","cells":[544245.76,6,0.0,90707.62666666666]},{"label":"Jeffrey Ellaga GE6","path":["Velocify TEAM Majd","Jeffrey Ellaga GE6"],"level":1,"kind":"detail","cells":[179017.89,1,0.0,179017.89]},{"label":"Ardjie Docallos GE31","path":["Velocify TEAM Majd","Ardjie Docallos GE31"],"level":1,"kind":"detail","cells":[143465.3,2,0.0,71732.65]},{"label":"Christina Strickland GE31","path":["Velocify TEAM Majd","Christina Strickland GE31"],"level":1,"kind":"detail","cells":[122003.5,1,0.0,122003.5]},{"label":"John Kendrick Limikid G96","path":["Velocify TEAM Majd","John Kendrick Limikid G96"],"level":1,"kind":"detail","cells":[65472.04,1,0.0,65472.04]},{"label":"Jo Ann Roja G84","path":["Velocify TEAM Majd","Jo Ann Roja G84"],"level":1,"kind":"detail","cells":[34287.03,1,0.0,34287.03]},{"label":"ReadyMode TEAM Benjamin","path":["ReadyMode TEAM Benjamin"],"level":0,"kind":"subtotal","cells":[907855.5800000001,11,0.0,82532.32545454545]},{"label":"Raul Arturo De La Cruz GE53","path":["ReadyMode TEAM Benjamin","Raul Arturo De La Cruz GE53"],"level":1,"kind":"detail","cells":[350511.99,4,0.0,87627.9975]},{"label":"Cesar Villarruel GE53","path":["ReadyMode TEAM Benjamin","Cesar Villarruel GE53"],"level":1,"kind":"detail","cells":[234383.99,3,0.0,78127.99666666666]},{"label":"Christian Martinez GE57","path":["ReadyMode TEAM Benjamin","Christian Martinez GE57"],"level":1,"kind":"detail","cells":[148946.1,1,0.0,148946.1]},{"label":"Gabriela Pardio GE46","path":["ReadyMode TEAM Benjamin","Gabriela Pardio GE46"],"level":1,"kind":"detail","cells":[79860.31,1,0.0,79860.31]},{"label":"Pedro Salgado GE53","path":["ReadyMode TEAM Benjamin","Pedro Salgado GE53"],"level":1,"kind":"detail","cells":[60104.29,1,0.0,60104.29]},{"label":"Luis Ocampo GE56","path":["ReadyMode TEAM Benjamin","Luis Ocampo GE56"],"level":1,"kind":"detail","cells":[34048.9,1,0.0,34048.9]},{"label":"ReadyMode TEAM Almira","path":["ReadyMode TEAM Almira"],"level":0,"kind":"subtotal","cells":[461513.33,5,0.0,92302.666]},{"label":"Rosemarie Bautista GE7","path":["ReadyMode TEAM Almira","Rosemarie Bautista GE7"],"level":1,"kind":"detail","cells":[206993.06,2,0.0,103496.53]},{"label":"Richie Simbajon GE19","path":["ReadyMode TEAM Almira","Richie Simbajon GE19"],"level":1,"kind":"detail","cells":[171080.27000000002,2,0.0,85540.13500000001]},{"label":"Jeffrey Guiao GE35","path":["ReadyMode TEAM Almira","Jeffrey Guiao GE35"],"level":1,"kind":"detail","cells":[83440.0,1,0.0,83440.0]},{"label":"BDA TEAM Mid-Level","path":["BDA TEAM Mid-Level"],"level":0,"kind":"subtotal","cells":[687425.85,7,0.0,98203.69285714286]},{"label":"Jenikka Calanno","path":["BDA TEAM Mid-Level","Jenikka Calanno"],"level":1,"kind":"detail","cells":[370602.95,5,0.0,74120.59]},{"label":"Heather Henson","path":["BDA TEAM Mid-Level","Heather Henson"],"level":1,"kind":"detail","cells":[251062.5,1,0.0,251062.5]},{"label":"Rizaline Cueto","path":["BDA TEAM Mid-Level","Rizaline Cueto"],"level":1,"kind":"detail","cells":[65760.4,1,0.0,65760.4]},{"label":"N/A","path":["N/A"],"level":0,"kind":"subtotal","cells":[101721.54,3,0.0,33907.18]},{"label":"Almira Jane Mactal","path":["N/A","Almira Jane Mactal"],"level":1,"kind":"detail","cells":[74105.29999999999,2,0.0,37052.649999999994]},{"label":"Maria April Martos GE58","path":["N/A","Maria April Martos GE58"],"level":1,"kind":"detail","cells":[27616.24,1,0.0,27616.24]},{"label":"Off-Roster","path":["Off-Roster"],"level":0,"kind":"subtotal","cells":[37440.0,1,0.0,37440.0]},{"label":"Old Employee","path":["Off-Roster","Old Employee"],"level":1,"kind":"detail","cells":[37440.0,1,0.0,37440.0]},{"label":"ReadyMode TEAM Majd","path":["ReadyMode TEAM Majd"],"level":0,"kind":"subtotal","cells":[530263.31,6,0.0,88377.21833333334]},{"label":"Lizbeth Tepeyac GE49","path":["ReadyMode TEAM Majd","Lizbeth Tepeyac GE49"],"level":1,"kind":"detail","cells":[449611.28,5,0.0,89922.25600000001]},{"label":"Roberto Guerrero GE54","path":["ReadyMode TEAM Majd","Roberto Guerrero GE54"],"level":1,"kind":"detail","cells":[80652.03,1,0.0,80652.03]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[3270465.37,39,0.0,83858.08641025641]}],"4":[{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[4,1,5]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[3,2,5]},{"label":"Geof Reusch","path":["Geof Reusch"],"level":0,"kind":"detail","cells":[1,0,1]},{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[6,4,10]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[5,6,11]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[4,0,4]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[3,0,3]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[26,13,39]}],"5":[{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[0.6,5]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[1.3333333333333333,5]},{"label":"Geof Reusch","path":["Geof Reusch"],"level":0,"kind":"detail","cells":[10.0,1]},{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[4.3,10]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[1.6363636363636365,11]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[2.75,4]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[5.333333333333333,3]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[2.8378378378378377,39]}]},"totals":{"0":[735159.7,132143.59,1930676.35,209402.87,263082.86,3270465.37],"1":[8,2,23,3,3,39],"2":[3270465.37,39,0.0,83858.08641025641],"3":[3270465.37,39,0.0,83858.08641025641],"4":[26,13,39],"5":[2.8378378378378377,39]},"tables":[{"id":"0","title":"Balance by Status & Closer","anchor":"A11:I20","population":39,"label_width":43.75,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Closer","colspan":1,"rowspan":1,"row_label":true},{"label":"App Signed","colspan":1,"rowspan":1,"row_label":false},{"label":"Approved","colspan":1,"rowspan":1,"row_label":false},{"label":"Active Client","colspan":1,"rowspan":1,"row_label":false},{"label":"Payment Plan Hold","colspan":1,"rowspan":1,"row_label":false},{"label":"Payment NSF","colspan":1,"rowspan":1,"row_label":false},{"label":"Grand Total","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3,4,5,6]]},{"id":"1","title":"Deal Count by Status & Closer","anchor":"A28:I37","population":39,"label_width":43.75,"lane":0,"note":"","header_fill":"101826","section_fill":"101826","headers":[[{"label":"Closer","colspan":1,"rowspan":1,"row_label":true},{"label":"App Signed","colspan":1,"rowspan":1,"row_label":false},{"label":"Approved","colspan":1,"rowspan":1,"row_label":false},{"label":"Active Client","colspan":1,"rowspan":1,"row_label":false},{"label":"Payment Plan Hold","colspan":1,"rowspan":1,"row_label":false},{"label":"Payment NSF","colspan":1,"rowspan":1,"row_label":false},{"label":"Grand Total","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3,4,5,6]]},{"id":"2","title":"Deals by Lead Source","anchor":"A46:E55","population":39,"label_width":43.75,"lane":0,"note":"","header_fill":"101826","section_fill":"101826","headers":[[{"label":"Lead Source","colspan":1,"rowspan":1,"row_label":true},{"label":"Balance","colspan":1,"rowspan":1,"row_label":false},{"label":"Deals","colspan":1,"rowspan":1,"row_label":false},{"label":"AWS","colspan":1,"rowspan":1,"row_label":false},{"label":"Average","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3,4]]},{"id":"3","title":"Deals by Team/Opener","anchor":"A64:E90","population":39,"label_width":43.75,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Opener","colspan":1,"rowspan":1,"row_label":true},{"label":"Balance","colspan":1,"rowspan":1,"row_label":false},{"label":"Deals","colspan":1,"rowspan":1,"row_label":false},{"label":"AWS","colspan":1,"rowspan":1,"row_label":false},{"label":"Average","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3,4]]},{"id":"4","title":"Same Day Wire Stat","anchor":"A101:D110","population":39,"label_width":43.75,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Closer","colspan":1,"rowspan":1,"row_label":true},{"label":"NO","colspan":1,"rowspan":1,"row_label":false},{"label":"YES","colspan":1,"rowspan":1,"row_label":false},{"label":"Grand Total","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3]]},{"id":"5","title":"Average Days to Wire","anchor":"A120:C129","population":39,"label_width":43.75,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Closer","colspan":1,"rowspan":1,"row_label":true},{"label":"Average Days","colspan":1,"rowspan":1,"row_label":false},{"label":"Deals","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2]]}]}]