[{"tab":"Table","title":"BDA Closed Deals Report","headline":[{"label":"Total balance","value":6924944.27,"format":"$"},{"label":"Total deals","value":75,"format":"General"},{"label":"Avg. deal","value":92332.59026666667,"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":["Canceled"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["High Risk"],"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":["No Appointment Scheduled"],"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":["Canceled"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["High Risk"],"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":["No Appointment Scheduled"],"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":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[503670.17000000004,null,1003423.6,null,null,65472.04,86744.36,null,1659310.17]},{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[251062.5,55494.49,899255.18,0.0,null,104953.53,107665.0,86820.26,1505250.96]},{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[198806.91,131730.57,542939.37,93074.9,null,91447.55,68673.5,null,1126672.8]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[98647.99,null,721702.1,null,null,83322.03,null,null,903672.12]},{"label":"Victor Greaves","path":["Victor Greaves"],"level":0,"kind":"detail","cells":[333666.66,null,494319.13,null,null,null,null,null,827985.79]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[173663.51,null,341051.79,null,42648.0,44813.55,null,null,602176.85]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[80908.62,76649.1,null,null,null,null,null,null,157557.72]},{"label":"Geof Reusch","path":["Geof Reusch"],"level":0,"kind":"detail","cells":[null,null,142317.86,null,null,null,null,null,142317.86]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[790068.22,263874.16000000003,3160605.39,93074.9,42648.0,390008.7,263082.86,null,5003362.23]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[850358.14,null,984403.64,null,null,null,null,86820.26,1921582.04]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[1640426.36,263874.16000000003,4145009.03,93074.9,42648.0,390008.7,263082.86,86820.26,6924944.27]}],"1":[{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[1,1,7,1,0,1,1,0,12]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[1,0,7,0,0,2,0,0,10]},{"label":"Geof Reusch","path":["Geof Reusch"],"level":0,"kind":"detail","cells":[0,0,2,0,0,0,0,0,2]},{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[1,1,12,1,0,2,1,1,19]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[3,0,11,0,0,1,1,0,16]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[4,0,5,0,1,1,0,0,11]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[2,1,0,0,0,0,0,0,3]},{"label":"Victor Greaves","path":["Victor Greaves"],"level":0,"kind":"detail","cells":[1,0,1,0,0,0,0,0,2]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[10,3,40,2,1,7,3,0,66]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[3,0,5,0,0,0,0,1,9]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[13,3,45,2,1,7,3,1,75]}],"2":[{"label":"Opener Transfer Form (READYMODE) - TRANSFER","path":["Opener Transfer Form (READYMODE) - TRANSFER"],"level":0,"kind":"detail","cells":[3946368.73,45,0.0,87697.0828888889]},{"label":"Opener Transfer Form (VICIDIALER) - TRANSFER","path":["Opener Transfer Form (VICIDIALER) - TRANSFER"],"level":0,"kind":"detail","cells":[561359.11,4,0.0,140339.7775]},{"label":"SMS","path":["SMS"],"level":0,"kind":"detail","cells":[1108230.41,9,0.0,123136.71222222221]},{"label":"ConduYt Consultation Request Form","path":["ConduYt Consultation Request Form"],"level":0,"kind":"detail","cells":[32713.0,1,0.0,32713.0]},{"label":"BDA NEW Webform Submission","path":["BDA NEW Webform Submission"],"level":0,"kind":"detail","cells":[119993.95000000001,3,0.0,39997.98333333334]},{"label":"DK Applications","path":["DK Applications"],"level":0,"kind":"detail","cells":[109543.62,2,0.0,54771.81]},{"label":"LFO Applications - TRANSFERS","path":["LFO Applications - TRANSFERS"],"level":0,"kind":"detail","cells":[102071.76999999999,2,0.0,51035.884999999995]},{"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":[484952.72,2,0.0,242476.36]},{"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":"Kloudi SMS","path":["Kloudi SMS"],"level":0,"kind":"detail","cells":[86820.26,1,0.0,86820.26]},{"label":"LF 2 Applications","path":["LF 2 Applications"],"level":0,"kind":"detail","cells":[47010.66,1,0.0,47010.66]},{"label":"MCA PT Applications - TRANSFERS","path":["MCA PT Applications - TRANSFERS"],"level":0,"kind":"detail","cells":[65472.04,1,0.0,65472.04]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[5003362.23,66,0.0,75808.51863636365]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[1921582.04,9,0.0,213509.11555555556]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[6924944.27,75,0.0,92332.59026666667]}],"3":[{"label":"Velocify TEAM Majd","path":["Velocify TEAM Majd"],"level":0,"kind":"subtotal","cells":[1220908.02,14,0.0,87207.71571428572]},{"label":"John Kendrick Limikid G96","path":["Velocify TEAM Majd","John Kendrick Limikid G96"],"level":1,"kind":"detail","cells":[398239.03,4,0.0,99559.7575]},{"label":"Jeffrey Ellaga GE6","path":["Velocify TEAM Majd","Jeffrey Ellaga GE6"],"level":1,"kind":"detail","cells":[234253.37000000002,2,0.0,117126.68500000001]},{"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":"Brett Maxwell","path":["Velocify TEAM Majd","Brett Maxwell"],"level":1,"kind":"detail","cells":[109498.31,1,0.0,109498.31]},{"label":"Vangee Dyer GE46","path":["Velocify TEAM Majd","Vangee Dyer GE46"],"level":1,"kind":"detail","cells":[95839.45,1,0.0,95839.45]},{"label":"Joseph Ferrante GE26","path":["Velocify TEAM Majd","Joseph Ferrante GE26"],"level":1,"kind":"detail","cells":[83322.03,2,0.0,41661.015]},{"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":[1068699.12,15,0.0,71246.60800000001]},{"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":[263112.63,4,0.0,65778.1575]},{"label":"Christian Martinez GE57","path":["ReadyMode TEAM Benjamin","Christian Martinez GE57"],"level":1,"kind":"detail","cells":[148946.1,1,0.0,148946.1]},{"label":"Roxana Rojas GE54","path":["ReadyMode TEAM Benjamin","Roxana Rojas GE54"],"level":1,"kind":"detail","cells":[108007.78,2,0.0,54003.89]},{"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":[58156.020000000004,2,0.0,29078.010000000002]},{"label":"ReadyMode TEAM Almira","path":["ReadyMode TEAM Almira"],"level":0,"kind":"subtotal","cells":[1750797.56,14,0.0,125056.96857142857]},{"label":"Rosemarie Bautista GE7","path":["ReadyMode TEAM Almira","Rosemarie Bautista GE7"],"level":1,"kind":"detail","cells":[654667.11,5,0.0,130933.42199999999]},{"label":"Carl Xidjir Docallos GE26","path":["ReadyMode TEAM Almira","Carl Xidjir Docallos GE26"],"level":1,"kind":"detail","cells":[486630.76999999996,2,0.0,243315.38499999998]},{"label":"Richie Simbajon GE19","path":["ReadyMode TEAM Almira","Richie Simbajon GE19"],"level":1,"kind":"detail","cells":[171080.27000000002,2,0.0,85540.13500000001]},{"label":"Nina Andrea Galvan G84","path":["ReadyMode TEAM Almira","Nina Andrea Galvan G84"],"level":1,"kind":"detail","cells":[139493.44,1,0.0,139493.44]},{"label":"Januario Castellano GE33","path":["ReadyMode TEAM Almira","Januario Castellano GE33"],"level":1,"kind":"detail","cells":[129938.47,1,0.0,129938.47]},{"label":"Jeffrey Guiao GE35","path":["ReadyMode TEAM Almira","Jeffrey Guiao GE35"],"level":1,"kind":"detail","cells":[124173.95,2,0.0,62086.975]},{"label":"Catherine Joy Del Mundo GE49","path":["ReadyMode TEAM Almira","Catherine Joy Del Mundo GE49"],"level":1,"kind":"detail","cells":[44813.55,1,0.0,44813.55]},{"label":"BDA TEAM Mid-Level","path":["BDA TEAM Mid-Level"],"level":0,"kind":"subtotal","cells":[1666835.75,16,0.0,104177.234375]},{"label":"Jenikka Calanno","path":["BDA TEAM Mid-Level","Jenikka Calanno"],"level":1,"kind":"detail","cells":[1216323.73,10,0.0,121632.37299999999]},{"label":"Heather Henson","path":["BDA TEAM Mid-Level","Heather Henson"],"level":1,"kind":"detail","cells":[342103.62,4,0.0,85525.905]},{"label":"Rizaline Cueto","path":["BDA TEAM Mid-Level","Rizaline Cueto"],"level":1,"kind":"detail","cells":[108408.4,2,0.0,54204.2]},{"label":"N/A","path":["N/A"],"level":0,"kind":"subtotal","cells":[188541.8,4,0.0,47135.45]},{"label":"Almira Jane Mactal","path":["N/A","Almira Jane Mactal"],"level":1,"kind":"detail","cells":[160925.56,3,0.0,53641.85333333333]},{"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":"BDA TEAM Closer","path":["BDA TEAM Closer"],"level":0,"kind":"subtotal","cells":[295556.05,2,0.0,147778.025]},{"label":"Jennifer Porter","path":["BDA TEAM Closer","Jennifer Porter"],"level":1,"kind":"detail","cells":[233890.22,1,0.0,233890.22]},{"label":"Geof Reusch","path":["BDA TEAM Closer","Geof Reusch"],"level":1,"kind":"detail","cells":[61665.83,1,0.0,61665.83]},{"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":[696165.97,9,0.0,77351.77444444444]},{"label":"Lizbeth Tepeyac GE49","path":["ReadyMode TEAM Majd","Lizbeth Tepeyac GE49"],"level":1,"kind":"detail","cells":[496415.24,6,0.0,82735.87333333334]},{"label":"Roberto Guerrero GE54","path":["ReadyMode TEAM Majd","Roberto Guerrero GE54"],"level":1,"kind":"detail","cells":[173726.93,2,0.0,86863.465]},{"label":"Damaris Diaz GE46","path":["ReadyMode TEAM Majd","Damaris Diaz GE46"],"level":1,"kind":"detail","cells":[26023.8,1,0.0,26023.8]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[5003362.23,66,0.0,75808.51863636365]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[1921582.04,9,0.0,213509.11555555556]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[6924944.27,75,0.0,92332.59026666667]}],"4":[{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[6,5,11]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[6,3,9]},{"label":"Geof Reusch","path":["Geof Reusch"],"level":0,"kind":"detail","cells":[2,0,2]},{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[9,9,18]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[5,7,12]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[11,0,11]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[3,0,3]},{"label":"Victor Greaves","path":["Victor Greaves"],"level":0,"kind":"detail","cells":[0,0,0]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[42,24,66]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[0,0,0]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[42,24,66]}],"5":[{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[0.9090909090909091,11]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[2.5714285714285716,9]},{"label":"Geof Reusch","path":["Geof Reusch"],"level":0,"kind":"detail","cells":[5.5,2]},{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[3.4444444444444446,18]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[1.5,12]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[3.272727272727273,11]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[5.333333333333333,3]},{"label":"Victor Greaves","path":["Victor Greaves"],"level":0,"kind":"detail","cells":[null,0]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[2.671875,66]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[null,0]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[2.671875,66]}]},"totals":{"0":[1640426.36,263874.16000000003,4145009.03,93074.9,42648.0,390008.7,263082.86,86820.26,6924944.27],"1":[13,3,45,2,1,7,3,1,75],"2":[6924944.27,75,0.0,92332.59026666667],"3":[6924944.27,75,0.0,92332.59026666667],"4":[42,24,66],"5":[2.671875,66]},"tables":[{"id":"0","title":"Balance by Status & Closer","anchor":"A11:I20","population":75,"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":"Canceled","colspan":1,"rowspan":1,"row_label":false},{"label":"High Risk","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":"No Appointment Scheduled","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,7,8],[9]]},{"id":"1","title":"Deal Count by Status & Closer","anchor":"A28:I37","population":75,"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":"Canceled","colspan":1,"rowspan":1,"row_label":false},{"label":"High Risk","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":"No Appointment Scheduled","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,7,8],[9]]},{"id":"2","title":"Deals by Lead Source","anchor":"A46:E55","population":75,"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":75,"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":75,"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":75,"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]]}]},{"tab":"MTD","title":"BDA Closed Deals Report (Delancy)","headline":[{"label":"Total balance","value":6924944.27,"format":"$"},{"label":"Total deals","value":75,"format":"General"},{"label":"Avg. deal","value":92332.59026666667,"format":"$"}],"columns":{"0":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"Sum of Final Balance","path":["Dedra Jefferies"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Dewayne Callaham"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Geof Reusch"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Heather Henson"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Jennifer Porter"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Mayette Velasco"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Samantha Pryce"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Victor Greaves"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum of Final Balance","path":["Grand Total"],"format":"\"$\"#,##0.00","kind":"total"}],"1":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"Count of Final Balance","path":["Dedra Jefferies"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Dewayne Callaham"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Geof Reusch"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Heather Henson"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Jennifer Porter"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Mayette Velasco"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Samantha Pryce"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Victor Greaves"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Grand Total"],"format":"General","kind":"total"}],"2":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"Sum of Final Balance","path":[],"format":"\"$\"#,##0.00","kind":"total"},{"label":"Count","path":[],"format":"General","kind":"total"},{"label":"AWS","path":[],"format":"General","kind":"total"},{"label":"Average","path":[],"format":"\"$\"#,##0.00","kind":"total"}],"3":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"Sum of Final Balance","path":[],"format":"\"$\"#,##0.00","kind":"total"},{"label":"Count","path":[],"format":"General","kind":"total"},{"label":"AWS","path":[],"format":"General","kind":"total"},{"label":"Average","path":[],"format":"\"$\"#,##0.00","kind":"total"}],"4":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"Sum of Final Balance","path":[],"format":"\"$\"#,##0.00","kind":"total"},{"label":"Count","path":[],"format":"General","kind":"total"},{"label":"AWS","path":[],"format":"General","kind":"total"},{"label":"Average","path":[],"format":"\"$\"#,##0.00","kind":"total"}]},"rows":{"0":[{"label":"App Signed","path":["App Signed"],"level":0,"kind":"detail","cells":[198806.91,98647.99,null,251062.5,503670.17000000004,173663.51,80908.62,333666.66,1640426.36]},{"label":"Active Client","path":["Active Client"],"level":0,"kind":"detail","cells":[542939.37,721702.1,142317.86,899255.18,1003423.6,341051.79,null,494319.13,4145009.03]},{"label":"Approved","path":["Approved"],"level":0,"kind":"detail","cells":[131730.57,null,null,55494.49,null,null,76649.1,null,263874.16000000003]},{"label":"Canceled","path":["Canceled"],"level":0,"kind":"detail","cells":[93074.9,null,null,0.0,null,null,null,null,93074.9]},{"label":"Payment Plan Hold","path":["Payment Plan Hold"],"level":0,"kind":"detail","cells":[91447.55,83322.03,null,104953.53,65472.04,44813.55,null,null,390008.7]},{"label":"Payment NSF","path":["Payment NSF"],"level":0,"kind":"detail","cells":[68673.5,null,null,107665.0,86744.36,null,null,null,263082.86]},{"label":"High Risk","path":["High Risk"],"level":0,"kind":"detail","cells":[null,null,null,null,null,42648.0,null,null,42648.0]},{"label":"No Appointment Scheduled","path":["No Appointment Scheduled"],"level":0,"kind":"detail","cells":[null,null,null,86820.26,null,null,null,null,86820.26]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[927865.89,750708.01,142317.86,1418430.7,1004305.2,602176.85,157557.72,null,5003362.23]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[198806.91,152964.11,null,86820.26,655004.97,null,null,827985.79,1921582.04]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[1126672.8,903672.12,142317.86,1505250.96,1659310.17,602176.85,157557.72,827985.79,6924944.27]}],"1":[{"label":"App Signed","path":["App Signed"],"level":0,"kind":"detail","cells":[1,1,0,1,3,4,2,1,13]},{"label":"Active Client","path":["Active Client"],"level":0,"kind":"detail","cells":[7,7,2,12,11,5,0,1,45]},{"label":"Approved","path":["Approved"],"level":0,"kind":"detail","cells":[1,0,0,1,0,0,1,0,3]},{"label":"Canceled","path":["Canceled"],"level":0,"kind":"detail","cells":[1,0,0,1,0,0,0,0,2]},{"label":"Payment Plan Hold","path":["Payment Plan Hold"],"level":0,"kind":"detail","cells":[1,2,0,2,1,1,0,0,7]},{"label":"Payment NSF","path":["Payment NSF"],"level":0,"kind":"detail","cells":[1,0,0,1,1,0,0,0,3]},{"label":"High Risk","path":["High Risk"],"level":0,"kind":"detail","cells":[0,0,0,0,0,1,0,0,1]},{"label":"No Appointment Scheduled","path":["No Appointment Scheduled"],"level":0,"kind":"detail","cells":[0,0,0,1,0,0,0,0,1]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[11,9,2,18,12,11,3,0,66]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[1,1,0,1,4,0,0,2,9]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[12,10,2,19,16,11,3,2,75]}],"2":[{"label":"Opener Transfer Form (READYMODE) - TRANSFER","path":["Opener Transfer Form (READYMODE) - TRANSFER"],"level":0,"kind":"detail","cells":[3946368.73,45,0.0,87697.0828888889]},{"label":"SMS","path":["SMS"],"level":0,"kind":"detail","cells":[1108230.41,9,0.0,123136.71222222221]},{"label":"BDA Velocify","path":["BDA Velocify"],"level":0,"kind":"detail","cells":[107665.0,1,0.0,107665.0]},{"label":"Opener Transfer Form (VICIDIALER) - TRANSFER","path":["Opener Transfer Form (VICIDIALER) - TRANSFER"],"level":0,"kind":"detail","cells":[561359.11,4,0.0,140339.7775]},{"label":"Asad Afzal","path":["Asad Afzal"],"level":0,"kind":"detail","cells":[484952.72,2,0.0,242476.36]},{"label":"BDA NEW Webform Submission","path":["BDA NEW Webform Submission"],"level":0,"kind":"detail","cells":[119993.95000000001,3,0.0,39997.98333333334]},{"label":"AS Applications","path":["AS Applications"],"level":0,"kind":"detail","cells":[115303.0,2,0.0,57651.5]},{"label":"DK Applications","path":["DK Applications"],"level":0,"kind":"detail","cells":[109543.62,2,0.0,54771.81]},{"label":"LFO Applications - TRANSFERS","path":["LFO Applications - TRANSFERS"],"level":0,"kind":"detail","cells":[102071.76999999999,2,0.0,51035.884999999995]},{"label":"Kloudi SMS","path":["Kloudi SMS"],"level":0,"kind":"detail","cells":[86820.26,1,0.0,86820.26]},{"label":"MCA PT Applications - TRANSFERS","path":["MCA PT Applications - TRANSFERS"],"level":0,"kind":"detail","cells":[65472.04,1,0.0,65472.04]},{"label":"LF 2 Applications","path":["LF 2 Applications"],"level":0,"kind":"detail","cells":[47010.66,1,0.0,47010.66]},{"label":"DRIPS PT Applications","path":["DRIPS PT Applications"],"level":0,"kind":"detail","cells":[37440.0,1,0.0,37440.0]},{"label":"ConduYt Consultation Request Form","path":["ConduYt Consultation Request Form"],"level":0,"kind":"detail","cells":[32713.0,1,0.0,32713.0]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[5003362.23,66,0.0,75808.51863636365]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[1921582.04,9,0.0,213509.11555555556]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[6924944.27,75,0.0,92332.59026666667]}],"3":[{"label":"Velocify TEAM Majd","path":["Velocify TEAM Majd"],"level":0,"kind":"subtotal","cells":[1220908.02,14,0.0,87207.71571428572]},{"label":"John Kendrick Limikid G96","path":["Velocify TEAM Majd","John Kendrick Limikid G96"],"level":1,"kind":"detail","cells":[398239.03,4,0.0,99559.7575]},{"label":"Jeffrey Ellaga GE6","path":["Velocify TEAM Majd","Jeffrey Ellaga GE6"],"level":1,"kind":"detail","cells":[234253.37000000002,2,0.0,117126.68500000001]},{"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":"Brett Maxwell","path":["Velocify TEAM Majd","Brett Maxwell"],"level":1,"kind":"detail","cells":[109498.31,1,0.0,109498.31]},{"label":"Vangee Dyer GE46","path":["Velocify TEAM Majd","Vangee Dyer GE46"],"level":1,"kind":"detail","cells":[95839.45,1,0.0,95839.45]},{"label":"Joseph Ferrante GE26","path":["Velocify TEAM Majd","Joseph Ferrante GE26"],"level":1,"kind":"detail","cells":[83322.03,2,0.0,41661.015]},{"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":"BDA TEAM Mid-Level","path":["BDA TEAM Mid-Level"],"level":0,"kind":"subtotal","cells":[1666835.75,16,0.0,104177.234375]},{"label":"Jenikka Calanno","path":["BDA TEAM Mid-Level","Jenikka Calanno"],"level":1,"kind":"detail","cells":[1216323.73,10,0.0,121632.37299999999]},{"label":"Heather Henson","path":["BDA TEAM Mid-Level","Heather Henson"],"level":1,"kind":"detail","cells":[342103.62,4,0.0,85525.905]},{"label":"Rizaline Cueto","path":["BDA TEAM Mid-Level","Rizaline Cueto"],"level":1,"kind":"detail","cells":[108408.4,2,0.0,54204.2]},{"label":"ReadyMode TEAM Benjamin","path":["ReadyMode TEAM Benjamin"],"level":0,"kind":"subtotal","cells":[1068699.12,15,0.0,71246.60800000001]},{"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":[263112.63,4,0.0,65778.1575]},{"label":"Christian Martinez GE57","path":["ReadyMode TEAM Benjamin","Christian Martinez GE57"],"level":1,"kind":"detail","cells":[148946.1,1,0.0,148946.1]},{"label":"Roxana Rojas GE54","path":["ReadyMode TEAM Benjamin","Roxana Rojas GE54"],"level":1,"kind":"detail","cells":[108007.78,2,0.0,54003.89]},{"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":[58156.020000000004,2,0.0,29078.010000000002]},{"label":"ReadyMode TEAM Almira","path":["ReadyMode TEAM Almira"],"level":0,"kind":"subtotal","cells":[1750797.56,14,0.0,125056.96857142857]},{"label":"Rosemarie Bautista GE7","path":["ReadyMode TEAM Almira","Rosemarie Bautista GE7"],"level":1,"kind":"detail","cells":[654667.11,5,0.0,130933.42199999999]},{"label":"Carl Xidjir Docallos GE26","path":["ReadyMode TEAM Almira","Carl Xidjir Docallos GE26"],"level":1,"kind":"detail","cells":[486630.76999999996,2,0.0,243315.38499999998]},{"label":"Richie Simbajon GE19","path":["ReadyMode TEAM Almira","Richie Simbajon GE19"],"level":1,"kind":"detail","cells":[171080.27000000002,2,0.0,85540.13500000001]},{"label":"Nina Andrea Galvan G84","path":["ReadyMode TEAM Almira","Nina Andrea Galvan G84"],"level":1,"kind":"detail","cells":[139493.44,1,0.0,139493.44]},{"label":"Januario Castellano GE33","path":["ReadyMode TEAM Almira","Januario Castellano GE33"],"level":1,"kind":"detail","cells":[129938.47,1,0.0,129938.47]},{"label":"Jeffrey Guiao GE35","path":["ReadyMode TEAM Almira","Jeffrey Guiao GE35"],"level":1,"kind":"detail","cells":[124173.95,2,0.0,62086.975]},{"label":"Catherine Joy Del Mundo GE49","path":["ReadyMode TEAM Almira","Catherine Joy Del Mundo GE49"],"level":1,"kind":"detail","cells":[44813.55,1,0.0,44813.55]},{"label":"N/A","path":["N/A"],"level":0,"kind":"subtotal","cells":[188541.8,4,0.0,47135.45]},{"label":"Almira Jane Mactal","path":["N/A","Almira Jane Mactal"],"level":1,"kind":"detail","cells":[160925.56,3,0.0,53641.85333333333]},{"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":"BDA TEAM Closer","path":["BDA TEAM Closer"],"level":0,"kind":"subtotal","cells":[295556.05,2,0.0,147778.025]},{"label":"Jennifer Porter","path":["BDA TEAM Closer","Jennifer Porter"],"level":1,"kind":"detail","cells":[233890.22,1,0.0,233890.22]},{"label":"Geof Reusch","path":["BDA TEAM Closer","Geof Reusch"],"level":1,"kind":"detail","cells":[61665.83,1,0.0,61665.83]},{"label":"ReadyMode TEAM Majd","path":["ReadyMode TEAM Majd"],"level":0,"kind":"subtotal","cells":[696165.97,9,0.0,77351.77444444444]},{"label":"Lizbeth Tepeyac GE49","path":["ReadyMode TEAM Majd","Lizbeth Tepeyac GE49"],"level":1,"kind":"detail","cells":[496415.24,6,0.0,82735.87333333334]},{"label":"Roberto Guerrero GE54","path":["ReadyMode TEAM Majd","Roberto Guerrero GE54"],"level":1,"kind":"detail","cells":[173726.93,2,0.0,86863.465]},{"label":"Damaris Diaz GE46","path":["ReadyMode TEAM Majd","Damaris Diaz GE46"],"level":1,"kind":"detail","cells":[26023.8,1,0.0,26023.8]},{"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":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[5003362.23,66,0.0,75808.51863636365]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[1921582.04,9,0.0,213509.11555555556]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[6924944.27,75,0.0,92332.59026666667]}],"4":[{"label":"(blank)","path":["(blank)"],"level":0,"kind":"detail","cells":[6065874.91,71,0.0,85434.85788732395]},{"label":"TX","path":["TX"],"level":0,"kind":"detail","cells":[79123.06,1,0.0,79123.06]},{"label":"CA","path":["CA"],"level":0,"kind":"detail","cells":[198806.91,1,0.0,198806.91]},{"label":"IN","path":["IN"],"level":0,"kind":"detail","cells":[494319.13,1,0.0,494319.13]},{"label":"SC","path":["SC"],"level":0,"kind":"detail","cells":[86820.26,1,0.0,86820.26]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[5003362.23,66,0.0,75808.51863636365]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[1921582.04,9,0.0,213509.11555555556]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[6924944.27,75,0.0,92332.59026666667]}]},"totals":{"0":[1126672.8,903672.12,142317.86,1505250.96,1659310.17,602176.85,157557.72,827985.79,6924944.27],"1":[12,10,2,19,16,11,3,2,75],"2":[6924944.27,75,0.0,92332.59026666667],"3":[6924944.27,75,0.0,92332.59026666667],"4":[6924944.27,75,0.0,92332.59026666667]},"tables":[{"id":"0","title":"Balance by Status & Closer","anchor":"A11:F15","population":75,"label_width":44.25,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":1,"row_label":true},{"label":"Dedra Jefferies","colspan":1,"rowspan":1,"row_label":false},{"label":"Dewayne Callaham","colspan":1,"rowspan":1,"row_label":false},{"label":"Geof Reusch","colspan":1,"rowspan":1,"row_label":false},{"label":"Heather Henson","colspan":1,"rowspan":1,"row_label":false},{"label":"Jennifer Porter","colspan":1,"rowspan":1,"row_label":false},{"label":"Mayette Velasco","colspan":1,"rowspan":1,"row_label":false},{"label":"Samantha Pryce","colspan":1,"rowspan":1,"row_label":false},{"label":"Victor Greaves","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,7,8],[9]]},{"id":"1","title":"Deal Count by Status & Closer","anchor":"A20:F24","population":75,"label_width":44.25,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":1,"row_label":true},{"label":"Dedra Jefferies","colspan":1,"rowspan":1,"row_label":false},{"label":"Dewayne Callaham","colspan":1,"rowspan":1,"row_label":false},{"label":"Geof Reusch","colspan":1,"rowspan":1,"row_label":false},{"label":"Heather Henson","colspan":1,"rowspan":1,"row_label":false},{"label":"Jennifer Porter","colspan":1,"rowspan":1,"row_label":false},{"label":"Mayette Velasco","colspan":1,"rowspan":1,"row_label":false},{"label":"Samantha Pryce","colspan":1,"rowspan":1,"row_label":false},{"label":"Victor Greaves","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,7,8],[9]]},{"id":"2","title":"Deals by Lead Source","anchor":"A29:E34","population":75,"label_width":44.25,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":1,"row_label":true},{"label":"Sum of Final Balance","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","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":"A40:E51","population":75,"label_width":44.25,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":1,"row_label":true},{"label":"Sum of Final Balance","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","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":"Deals by State","anchor":"A58:E63","population":75,"label_width":44.25,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":1,"row_label":true},{"label":"Sum of Final Balance","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","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]]}]}]