[{"tab":"Report","title":"BDA Activation Report (Delancy)","headline":[{"label":"Total deals","value":42,"format":"General"},{"label":"Active deals","value":40,"format":"General"},{"label":"Activation %","value":0.9523809523809523,"format":"%"},{"label":"Active balance","value":8896655.01,"format":"$"}],"columns":{"0":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"Sum","path":[],"format":"\"$\"#,##0.00","kind":"total"},{"label":"%","path":[],"format":"0.00%","kind":"total"}],"1":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"Sum","path":["(blank)"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["(blank)"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Dedra Jefferies"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Dedra Jefferies"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Dewayne Callaham"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Dewayne Callaham"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Geof Reusch"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Geof Reusch"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Heather Henson"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Heather Henson"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Jennifer Porter"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Jennifer Porter"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Mayette Velasco"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Mayette Velasco"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Samantha Pryce"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Samantha Pryce"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Victor Greaves"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Victor Greaves"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Grand Total"],"format":"\"$\"#,##0.00","kind":"total"},{"label":"%","path":["Grand Total"],"format":"0.00%","kind":"total"}],"2":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"Count","path":["(blank)"],"format":"General","kind":"detail"},{"label":"%","path":["(blank)"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Dedra Jefferies"],"format":"General","kind":"detail"},{"label":"%","path":["Dedra Jefferies"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Dewayne Callaham"],"format":"General","kind":"detail"},{"label":"%","path":["Dewayne Callaham"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Geof Reusch"],"format":"General","kind":"detail"},{"label":"%","path":["Geof Reusch"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Heather Henson"],"format":"General","kind":"detail"},{"label":"%","path":["Heather Henson"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Jennifer Porter"],"format":"General","kind":"detail"},{"label":"%","path":["Jennifer Porter"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Mayette Velasco"],"format":"General","kind":"detail"},{"label":"%","path":["Mayette Velasco"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Samantha Pryce"],"format":"General","kind":"detail"},{"label":"%","path":["Samantha Pryce"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Victor Greaves"],"format":"General","kind":"detail"},{"label":"%","path":["Victor Greaves"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Grand Total"],"format":"General","kind":"total"},{"label":"%","path":["Grand Total"],"format":"0.00%","kind":"total"}],"3":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"Sum","path":["Random"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Random"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Opener Transfer Form"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Opener Transfer Form"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["PT Applications"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["PT Applications"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["(blank)"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["(blank)"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["AEM Data"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["AEM Data"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["ConduYt SMS – GSM"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["ConduYt SMS – GSM"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["ConduYt SMS – Infobip"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["ConduYt SMS – Infobip"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["ConduYt SMS – Kloudi"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["ConduYt SMS – Kloudi"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Manual Entry"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Manual Entry"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["NRP62926"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["NRP62926"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["PTO Applications"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["PTO Applications"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Referrals"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Referrals"],"format":"0.00%","kind":"detail"},{"label":"Sum","path":["Grand Total"],"format":"\"$\"#,##0.00","kind":"total"},{"label":"%","path":["Grand Total"],"format":"0.00%","kind":"total"}],"4":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"Count","path":["Random"],"format":"General","kind":"detail"},{"label":"%","path":["Random"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Opener Transfer Form"],"format":"General","kind":"detail"},{"label":"%","path":["Opener Transfer Form"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["PT Applications"],"format":"General","kind":"detail"},{"label":"%","path":["PT Applications"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["(blank)"],"format":"General","kind":"detail"},{"label":"%","path":["(blank)"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["AEM Data"],"format":"General","kind":"detail"},{"label":"%","path":["AEM Data"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["ConduYt SMS – GSM"],"format":"General","kind":"detail"},{"label":"%","path":["ConduYt SMS – GSM"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["ConduYt SMS – Infobip"],"format":"General","kind":"detail"},{"label":"%","path":["ConduYt SMS – Infobip"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["ConduYt SMS – Kloudi"],"format":"General","kind":"detail"},{"label":"%","path":["ConduYt SMS – Kloudi"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Manual Entry"],"format":"General","kind":"detail"},{"label":"%","path":["Manual Entry"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["NRP62926"],"format":"General","kind":"detail"},{"label":"%","path":["NRP62926"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["PTO Applications"],"format":"General","kind":"detail"},{"label":"%","path":["PTO Applications"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Referrals"],"format":"General","kind":"detail"},{"label":"%","path":["Referrals"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Grand Total"],"format":"General","kind":"total"},{"label":"%","path":["Grand Total"],"format":"0.00%","kind":"total"}],"5":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"Sum","path":["(blank)"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["(blank)"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["(blank)"],"format":"General","kind":"detail"},{"label":"Sum","path":["Almira Jane Mactal"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Almira Jane Mactal"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Almira Jane Mactal"],"format":"General","kind":"detail"},{"label":"Sum","path":["Ardjie Docallos"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Ardjie Docallos"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Ardjie Docallos"],"format":"General","kind":"detail"},{"label":"Sum","path":["Cathy Zamora"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Cathy Zamora"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Cathy Zamora"],"format":"General","kind":"detail"},{"label":"Sum","path":["Cesar Villarruel"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Cesar Villarruel"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Cesar Villarruel"],"format":"General","kind":"detail"},{"label":"Sum","path":["Christina Strickland"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Christina Strickland"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Christina Strickland"],"format":"General","kind":"detail"},{"label":"Sum","path":["Dedra Jefferies"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Dedra Jefferies"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Dedra Jefferies"],"format":"General","kind":"detail"},{"label":"Sum","path":["Jenikka Calanno"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Jenikka Calanno"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Jenikka Calanno"],"format":"General","kind":"detail"},{"label":"Sum","path":["Jesse Hernandez"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Jesse Hernandez"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Jesse Hernandez"],"format":"General","kind":"detail"},{"label":"Sum","path":["Jo Ann Roja"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Jo Ann Roja"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Jo Ann Roja"],"format":"General","kind":"detail"},{"label":"Sum","path":["John Kendrick Limikid"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["John Kendrick Limikid"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["John Kendrick Limikid"],"format":"General","kind":"detail"},{"label":"Sum","path":["Jojan Bueno"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Jojan Bueno"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Jojan Bueno"],"format":"General","kind":"detail"},{"label":"Sum","path":["Joseph Ferrante"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Joseph Ferrante"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Joseph Ferrante"],"format":"General","kind":"detail"},{"label":"Sum","path":["Mayette Velasco"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Mayette Velasco"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Mayette Velasco"],"format":"General","kind":"detail"},{"label":"Sum","path":["Monica Vijarro"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"Sum %","path":["Monica Vijarro"],"format":"0.00%","kind":"detail"},{"label":"Count","path":["Monica Vijarro"],"format":"General","kind":"detail"},{"label":"Sum","path":["Grand Total"],"format":"\"$\"#,##0.00","kind":"total"},{"label":"Sum %","path":["Grand Total"],"format":"0.00%","kind":"total"},{"label":"Count","path":["Grand Total"],"format":"General","kind":"total"}],"6":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"label":"%","path":[],"format":"0.00%","kind":"total"}]},"rows":{"0":[{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[null,null]}],"1":[{"label":"App Signed","path":["App Signed"],"level":0,"kind":"detail","cells":[null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]},{"label":"Appointment Scheduled","path":["Appointment Scheduled"],"level":0,"kind":"detail","cells":[null,0.0,null,0.0,91298.97,0.24251990963494657,null,0.0,null,0.0,65000.0,0.199800052402943,null,0.0,null,0.0,null,0.0,156298.97,0.01744085995562108]},{"label":"(blank)","path":["(blank)"],"level":0,"kind":"detail","cells":[4796756.71,1.0,254362.36,1.0,79115.42,0.21015641807493385,237782.0,1.0,98505.0,1.0,260325.24000000002,0.8001999475970571,77000.0,1.0,59521.56,1.0,2735942.45,1.0,8599310.74,0.959567259664016]},{"label":"Transfer","path":["Transfer"],"level":0,"kind":"detail","cells":[null,0.0,null,0.0,206045.3,0.5473236722901196,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,206045.3,0.02299188038036291]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[4796756.71,1.0,254362.36,1.0,376459.69,1.0,237782.0,1.0,98505.0,1.0,325325.24,1.0,77000.0,1.0,59521.56,1.0,2735942.45,1.0,8961655.01,1.0]}],"2":[{"label":"App Signed","path":["App Signed"],"level":0,"kind":"detail","cells":[0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0]},{"label":"Appointment Scheduled","path":["Appointment Scheduled"],"level":0,"kind":"detail","cells":[0,0.0,0,0.0,1,0.2,0,0.0,0,0.0,1,0.25,0,0.0,0,0.0,0,0.0,2,0.04878048780487805]},{"label":"(blank)","path":["(blank)"],"level":0,"kind":"detail","cells":[17,1.0,1,1.0,2,0.4,1,1.0,1,1.0,3,0.75,1,1.0,1,1.0,10,1.0,37,0.9024390243902439]},{"label":"Transfer","path":["Transfer"],"level":0,"kind":"detail","cells":[0,0.0,0,0.0,2,0.4,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,2,0.04878048780487805]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[17,1.0,1,1.0,5,1.0,1,1.0,1,1.0,4,1.0,1,1.0,1,1.0,10,1.0,41,1.0]}],"3":[{"label":"App Signed","path":["App Signed"],"level":0,"kind":"detail","cells":[null,0.0,null,0.0,null,0.0,null,0.0,null,null,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]},{"label":"Appointment Scheduled","path":["Appointment Scheduled"],"level":0,"kind":"detail","cells":[null,0.0,65000.0,0.03368638234057431,null,0.0,null,0.0,null,null,null,0.0,null,0.0,null,0.0,null,0.0,91298.97,1.0,null,0.0,null,0.0,156298.97,0.01744085995562108]},{"label":"(blank)","path":["(blank)"],"level":0,"kind":"detail","cells":[758119.01,1.0,1658517.79,0.8595302214243743,921848.73,1.0,4211501.96,1.0,null,null,34890.85,1.0,30620.0,1.0,48495.42,1.0,357118.89,1.0,null,0.0,77000.0,1.0,501198.09,1.0,8599310.74,0.959567259664016]},{"label":"Transfer","path":["Transfer"],"level":0,"kind":"detail","cells":[null,0.0,206045.3,0.10678339623505131,null,0.0,null,0.0,null,null,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,206045.3,0.02299188038036291]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[758119.01,1.0,1929563.09,1.0,921848.73,1.0,4211501.96,1.0,null,null,34890.85,1.0,30620.0,1.0,48495.42,1.0,357118.89,1.0,91298.97,1.0,77000.0,1.0,501198.09,1.0,8961655.01,1.0]}],"4":[{"label":"App Signed","path":["App Signed"],"level":0,"kind":"detail","cells":[0,0.0,0,0.0,0,0.0,0,0.0,0,null,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0]},{"label":"Appointment Scheduled","path":["Appointment Scheduled"],"level":0,"kind":"detail","cells":[0,0.0,1,0.1111111111111111,0,0.0,0,0.0,0,null,0,0.0,0,0.0,0,0.0,0,0.0,1,1.0,0,0.0,0,0.0,2,0.04878048780487805]},{"label":"(blank)","path":["(blank)"],"level":0,"kind":"detail","cells":[3,1.0,6,0.6666666666666666,3,1.0,16,1.0,0,null,1,1.0,1,1.0,1,1.0,4,1.0,0,0.0,1,1.0,1,1.0,37,0.9024390243902439]},{"label":"Transfer","path":["Transfer"],"level":0,"kind":"detail","cells":[0,0.0,2,0.2222222222222222,0,0.0,0,0.0,0,null,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,2,0.04878048780487805]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[3,1.0,9,1.0,3,1.0,16,1.0,0,null,1,1.0,1,1.0,1,1.0,4,1.0,1,1.0,1,1.0,1,1.0,41,1.0]}],"5":[{"label":"App Signed","path":["App Signed"],"level":0,"kind":"detail","cells":[null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0]},{"label":"Appointment Scheduled","path":["Appointment Scheduled"],"level":0,"kind":"detail","cells":[null,0.0,0,null,0.0,0,91298.97,0.41648620628196925,1,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,65000.0,0.5149211881434088,1,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,156298.97,0.01744085995562108,2]},{"label":"(blank)","path":["(blank)"],"level":0,"kind":"detail","cells":[4568620.85,1.0,20,278695.0,1.0,1,null,0.0,0,699514.25,1.0,3,245733.68,1.0,1,237782.0,1.0,1,501198.09,1.0,1,437155.38,1.0,3,416851.89,1.0,1,61232.91,0.48507881185659113,1,null,0.0,0,257225.33,1.0,1,254362.36,1.0,1,198384.05,1.0,2,442554.95,1.0,1,8599310.74,0.959567259664016,37]},{"label":"Transfer","path":["Transfer"],"level":0,"kind":"detail","cells":[null,0.0,0,null,0.0,0,127913.5,0.5835137937180307,1,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,78131.8,1.0,1,null,0.0,0,null,0.0,0,null,0.0,0,null,0.0,0,206045.3,0.02299188038036291,2]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[4568620.85,1.0,20,278695.0,1.0,1,219212.47,1.0,2,699514.25,1.0,3,245733.68,1.0,1,237782.0,1.0,1,501198.09,1.0,1,437155.38,1.0,3,416851.89,1.0,1,126232.91,1.0,2,78131.8,1.0,1,257225.33,1.0,1,254362.36,1.0,1,198384.05,1.0,2,442554.95,1.0,1,8961655.01,1.0,41]}],"6":[{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[null]}]},"totals":{"0":[null,null],"1":[4796756.71,1.0,254362.36,1.0,376459.69,1.0,237782.0,1.0,98505.0,1.0,325325.24,1.0,77000.0,1.0,59521.56,1.0,2735942.45,1.0,8961655.01,1.0],"2":[17,1.0,1,1.0,5,1.0,1,1.0,1,1.0,4,1.0,1,1.0,1,1.0,10,1.0,41,1.0],"3":[758119.01,1.0,1929563.09,1.0,921848.73,1.0,4211501.96,1.0,null,null,34890.85,1.0,30620.0,1.0,48495.42,1.0,357118.89,1.0,91298.97,1.0,77000.0,1.0,501198.09,1.0,8961655.01,1.0],"4":[3,1.0,9,1.0,3,1.0,16,1.0,0,null,1,1.0,1,1.0,1,1.0,4,1.0,1,1.0,1,1.0,1,1.0,41,1.0],"5":[4568620.85,1.0,20,278695.0,1.0,1,219212.47,1.0,2,699514.25,1.0,3,245733.68,1.0,1,237782.0,1.0,1,501198.09,1.0,1,437155.38,1.0,3,416851.89,1.0,1,126232.91,1.0,2,78131.8,1.0,1,257225.33,1.0,1,254362.36,1.0,1,198384.05,1.0,2,442554.95,1.0,1,8961655.01,1.0,41],"6":[null]},"tables":[{"id":"0","title":"Balance of Active Clients","anchor":"A13:C18","population":0,"label_width":17.375,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":1,"row_label":true},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2]]},{"id":"1","title":"Balance by Status & Closer","anchor":"A23:K27","population":42,"label_width":17.375,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":2,"row_label":true},{"label":"(blank)","colspan":2,"rowspan":1,"row_label":false},{"label":"Dedra Jefferies","colspan":2,"rowspan":1,"row_label":false},{"label":"Dewayne Callaham","colspan":2,"rowspan":1,"row_label":false},{"label":"Geof Reusch","colspan":2,"rowspan":1,"row_label":false},{"label":"Heather Henson","colspan":2,"rowspan":1,"row_label":false},{"label":"Jennifer Porter","colspan":2,"rowspan":1,"row_label":false},{"label":"Mayette Velasco","colspan":2,"rowspan":1,"row_label":false},{"label":"Samantha Pryce","colspan":2,"rowspan":1,"row_label":false},{"label":"Victor Greaves","colspan":2,"rowspan":1,"row_label":false},{"label":"Grand Total","colspan":2,"rowspan":1,"row_label":false}],[{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3,4,5,6,7,8],[9,10,11,12,13,14,15,16],[17,18,19,20]]},{"id":"2","title":"Deal Count by Status & Closer","anchor":"A33:K37","population":42,"label_width":17.375,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":2,"row_label":true},{"label":"(blank)","colspan":2,"rowspan":1,"row_label":false},{"label":"Dedra Jefferies","colspan":2,"rowspan":1,"row_label":false},{"label":"Dewayne Callaham","colspan":2,"rowspan":1,"row_label":false},{"label":"Geof Reusch","colspan":2,"rowspan":1,"row_label":false},{"label":"Heather Henson","colspan":2,"rowspan":1,"row_label":false},{"label":"Jennifer Porter","colspan":2,"rowspan":1,"row_label":false},{"label":"Mayette Velasco","colspan":2,"rowspan":1,"row_label":false},{"label":"Samantha Pryce","colspan":2,"rowspan":1,"row_label":false},{"label":"Victor Greaves","colspan":2,"rowspan":1,"row_label":false},{"label":"Grand Total","colspan":2,"rowspan":1,"row_label":false}],[{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3,4,5,6,7,8],[9,10,11,12,13,14,15,16],[17,18,19,20]]},{"id":"3","title":"Balance by Status & Source","anchor":"A44:G48","population":42,"label_width":17.375,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":2,"row_label":true},{"label":"Random","colspan":2,"rowspan":1,"row_label":false},{"label":"Opener Transfer Form","colspan":2,"rowspan":1,"row_label":false},{"label":"PT Applications","colspan":2,"rowspan":1,"row_label":false},{"label":"(blank)","colspan":2,"rowspan":1,"row_label":false},{"label":"AEM Data","colspan":2,"rowspan":1,"row_label":false},{"label":"ConduYt SMS – GSM","colspan":2,"rowspan":1,"row_label":false},{"label":"ConduYt SMS – Infobip","colspan":2,"rowspan":1,"row_label":false},{"label":"ConduYt SMS – Kloudi","colspan":2,"rowspan":1,"row_label":false},{"label":"Manual Entry","colspan":2,"rowspan":1,"row_label":false},{"label":"NRP62926","colspan":2,"rowspan":1,"row_label":false},{"label":"PTO Applications","colspan":2,"rowspan":1,"row_label":false},{"label":"Referrals","colspan":2,"rowspan":1,"row_label":false},{"label":"Grand Total","colspan":2,"rowspan":1,"row_label":false}],[{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3,4,5,6,7,8],[9,10,11,12,13,14,15,16],[17,18,19,20,21,22,23,24],[25,26]]},{"id":"4","title":"Deal Count by Status & Closer","anchor":"A55:G59","population":42,"label_width":17.375,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":2,"row_label":true},{"label":"Random","colspan":2,"rowspan":1,"row_label":false},{"label":"Opener Transfer Form","colspan":2,"rowspan":1,"row_label":false},{"label":"PT Applications","colspan":2,"rowspan":1,"row_label":false},{"label":"(blank)","colspan":2,"rowspan":1,"row_label":false},{"label":"AEM Data","colspan":2,"rowspan":1,"row_label":false},{"label":"ConduYt SMS – GSM","colspan":2,"rowspan":1,"row_label":false},{"label":"ConduYt SMS – Infobip","colspan":2,"rowspan":1,"row_label":false},{"label":"ConduYt SMS – Kloudi","colspan":2,"rowspan":1,"row_label":false},{"label":"Manual Entry","colspan":2,"rowspan":1,"row_label":false},{"label":"NRP62926","colspan":2,"rowspan":1,"row_label":false},{"label":"PTO Applications","colspan":2,"rowspan":1,"row_label":false},{"label":"Referrals","colspan":2,"rowspan":1,"row_label":false},{"label":"Grand Total","colspan":2,"rowspan":1,"row_label":false}],[{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"%","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3,4,5,6,7,8],[9,10,11,12,13,14,15,16],[17,18,19,20,21,22,23,24],[25,26]]},{"id":"5","title":"Balance by Team/Opener","anchor":"A67:V71","population":42,"label_width":17.375,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":2,"row_label":true},{"label":"(blank)","colspan":3,"rowspan":1,"row_label":false},{"label":"Almira Jane Mactal","colspan":3,"rowspan":1,"row_label":false},{"label":"Ardjie Docallos","colspan":3,"rowspan":1,"row_label":false},{"label":"Cathy Zamora","colspan":3,"rowspan":1,"row_label":false},{"label":"Cesar Villarruel","colspan":3,"rowspan":1,"row_label":false},{"label":"Christina Strickland","colspan":3,"rowspan":1,"row_label":false},{"label":"Dedra Jefferies","colspan":3,"rowspan":1,"row_label":false},{"label":"Jenikka Calanno","colspan":3,"rowspan":1,"row_label":false},{"label":"Jesse Hernandez","colspan":3,"rowspan":1,"row_label":false},{"label":"Jo Ann Roja","colspan":3,"rowspan":1,"row_label":false},{"label":"John Kendrick Limikid","colspan":3,"rowspan":1,"row_label":false},{"label":"Jojan Bueno","colspan":3,"rowspan":1,"row_label":false},{"label":"Joseph Ferrante","colspan":3,"rowspan":1,"row_label":false},{"label":"Mayette Velasco","colspan":3,"rowspan":1,"row_label":false},{"label":"Monica Vijarro","colspan":3,"rowspan":1,"row_label":false},{"label":"Grand Total","colspan":3,"rowspan":1,"row_label":false}],[{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum","colspan":1,"rowspan":1,"row_label":false},{"label":"Sum %","colspan":1,"rowspan":1,"row_label":false},{"label":"Count","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3,4,5,6,7,8],[9,10,11,12,13,14,15,16],[17,18,19,20,21,22,23,24],[25,26,27,28,29,30,31,32],[33,34,35,36,37,38,39,40],[41,42,43,44,45,46,47,48]]},{"id":"6","title":"Active Client percent by Team/Opener","anchor":"A86:B93","population":0,"label_width":17.375,"lane":0,"note":"","header_fill":"0B1220","section_fill":"101826","headers":[[{"label":"Row Labels","colspan":1,"rowspan":1,"row_label":true},{"label":"%","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1]]}]}]