[{"tab":"Report","title":"BDA Activation Report (Delancy)","headline":[{"label":"Total deals","value":4,"format":"General"},{"label":"Active deals","value":3,"format":"General"},{"label":"Activation %","value":0.75,"format":"%"},{"label":"Active balance","value":197754.47,"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":["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":["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":["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":["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":["Opener Transfer Form"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["Opener Transfer Form"],"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":["PTO Applications"],"format":"\"$\"#,##0.00","kind":"detail"},{"label":"%","path":["PTO Applications"],"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":["Opener Transfer Form"],"format":"General","kind":"detail"},{"label":"%","path":["Opener Transfer Form"],"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":["PTO Applications"],"format":"General","kind":"detail"},{"label":"%","path":["PTO Applications"],"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":["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":["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":["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":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[77000.0,0.38937172949870613]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[61232.91,0.30964109180439764]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[59521.56,0.3009871786968962]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[197754.47,1.0]}],"1":[{"label":"Active Client","path":["Active Client"],"level":0,"kind":"detail","cells":[61232.91,0.48507881185659113,77000.0,1.0,59521.56,1.0,197754.47,0.7526207641681606]},{"label":"Appointment Scheduled","path":["Appointment Scheduled"],"level":0,"kind":"detail","cells":[65000.0,0.5149211881434088,null,0.0,null,0.0,65000.0,0.24737923583183954]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[126232.91,1.0,77000.0,1.0,59521.56,1.0,262754.47,1.0]}],"2":[{"label":"Active Client","path":["Active Client"],"level":0,"kind":"detail","cells":[1,0.5,1,1.0,1,1.0,3,0.75]},{"label":"Appointment Scheduled","path":["Appointment Scheduled"],"level":0,"kind":"detail","cells":[1,0.5,0,0.0,0,0.0,1,0.25]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[2,1.0,1,1.0,1,1.0,4,1.0]}],"3":[{"label":"Active Client","path":["Active Client"],"level":0,"kind":"detail","cells":[61232.91,0.48507881185659113,59521.56,1.0,77000.0,1.0,197754.47,0.7526207641681606]},{"label":"Appointment Scheduled","path":["Appointment Scheduled"],"level":0,"kind":"detail","cells":[65000.0,0.5149211881434088,null,0.0,null,0.0,65000.0,0.24737923583183954]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[126232.91,1.0,59521.56,1.0,77000.0,1.0,262754.47,1.0]}],"4":[{"label":"Active Client","path":["Active Client"],"level":0,"kind":"detail","cells":[1,0.5,1,1.0,1,1.0,3,0.75]},{"label":"Appointment Scheduled","path":["Appointment Scheduled"],"level":0,"kind":"detail","cells":[1,0.5,0,0.0,0,0.0,1,0.25]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[2,1.0,1,1.0,1,1.0,4,1.0]}],"5":[{"label":"Active Client","path":["Active Client"],"level":0,"kind":"detail","cells":[59521.56,1.0,1,61232.91,0.48507881185659113,1,77000.0,1.0,1,197754.47,0.7526207641681606,3]},{"label":"Appointment Scheduled","path":["Appointment Scheduled"],"level":0,"kind":"detail","cells":[null,0.0,0,65000.0,0.5149211881434088,1,null,0.0,0,65000.0,0.24737923583183954,1]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[59521.56,1.0,1,126232.91,1.0,2,77000.0,1.0,1,262754.47,1.0,4]}],"6":[{"label":"(blank)","path":["(blank)"],"level":0,"kind":"detail","cells":[0.3009871786968962]},{"label":"Jo Ann Roja","path":["Jo Ann Roja"],"level":0,"kind":"detail","cells":[0.30964109180439764]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[0.38937172949870613]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[1.0]}]},"totals":{"0":[197754.47,1.0],"1":[126232.91,1.0,77000.0,1.0,59521.56,1.0,262754.47,1.0],"2":[2,1.0,1,1.0,1,1.0,4,1.0],"3":[126232.91,1.0,59521.56,1.0,77000.0,1.0,262754.47,1.0],"4":[2,1.0,1,1.0,1,1.0,4,1.0],"5":[59521.56,1.0,1,126232.91,1.0,2,77000.0,1.0,1,262754.47,1.0,4],"6":[1.0]},"tables":[{"id":"0","title":"Balance of Active Clients","anchor":"A13:C18","population":3,"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":4,"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":"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":"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}]],"print_panels":[[1,2,3,4,5,6,7,8]]},{"id":"2","title":"Deal Count by Status & Closer","anchor":"A33:K37","population":4,"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":"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":"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}]],"print_panels":[[1,2,3,4,5,6,7,8]]},{"id":"3","title":"Balance by Status & Source","anchor":"A44:G48","population":4,"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":"Opener Transfer Form","colspan":2,"rowspan":1,"row_label":false},{"label":"Manual Entry","colspan":2,"rowspan":1,"row_label":false},{"label":"PTO Applications","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}]],"print_panels":[[1,2,3,4,5,6,7,8]]},{"id":"4","title":"Deal Count by Status & Closer","anchor":"A55:G59","population":4,"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":"Opener Transfer Form","colspan":2,"rowspan":1,"row_label":false},{"label":"Manual Entry","colspan":2,"rowspan":1,"row_label":false},{"label":"PTO Applications","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}]],"print_panels":[[1,2,3,4,5,6,7,8]]},{"id":"5","title":"Balance by Team/Opener","anchor":"A67:V71","population":4,"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":"Jo Ann Roja","colspan":3,"rowspan":1,"row_label":false},{"label":"Mayette Velasco","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}]],"print_panels":[[1,2,3,4,5,6,7,8],[9,10,11,12]]},{"id":"6","title":"Active Client percent by Team/Opener","anchor":"A86:B93","population":3,"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]]}]}]