[{"tab":"Table","title":"BDA Closed Deals Report","headline":[{"label":"Total balance","value":571756.58,"format":"$"},{"label":"Total deals","value":3,"format":"General"},{"label":"Avg. deal","value":190585.52666666664,"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":["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":["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":"Victor Greaves","path":["Victor Greaves"],"level":0,"kind":"detail","cells":[null,null,494319.13,494319.13]},{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[null,41637.15,null,41637.15]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[35800.3,null,null,35800.3]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[35800.3,41637.15,null,77437.45000000001]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[null,null,494319.13,494319.13]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[35800.3,41637.15,494319.13,571756.58]}],"1":[{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[0,1,0,1]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[1,0,0,1]},{"label":"Victor Greaves","path":["Victor Greaves"],"level":0,"kind":"detail","cells":[0,0,1,1]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[1,1,0,2]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[0,0,1,1]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[1,1,1,3]}],"2":[{"label":"Opener Transfer Form (READYMODE) - TRANSFER","path":["Opener Transfer Form (READYMODE) - TRANSFER"],"level":0,"kind":"detail","cells":[77437.45000000001,2,0.0,38718.725000000006]},{"label":"SMS","path":["SMS"],"level":0,"kind":"detail","cells":[494319.13,1,0.0,494319.13]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[77437.45000000001,2,0.0,38718.725000000006]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[494319.13,1,0.0,494319.13]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[571756.58,3,0.0,190585.52666666664]}],"3":[{"label":"Velocify TEAM Majd","path":["Velocify TEAM Majd"],"level":0,"kind":"subtotal","cells":[35800.3,1,0.0,35800.3]},{"label":"Ardjie Docallos GE31","path":["Velocify TEAM Majd","Ardjie Docallos GE31"],"level":1,"kind":"detail","cells":[35800.3,1,0.0,35800.3]},{"label":"BDA TEAM Mid-Level","path":["BDA TEAM Mid-Level"],"level":0,"kind":"subtotal","cells":[494319.13,1,0.0,494319.13]},{"label":"Jenikka Calanno","path":["BDA TEAM Mid-Level","Jenikka Calanno"],"level":1,"kind":"detail","cells":[494319.13,1,0.0,494319.13]},{"label":"ReadyMode TEAM Majd","path":["ReadyMode TEAM Majd"],"level":0,"kind":"subtotal","cells":[41637.15,1,0.0,41637.15]},{"label":"Lizbeth Tepeyac GE49","path":["ReadyMode TEAM Majd","Lizbeth Tepeyac GE49"],"level":1,"kind":"detail","cells":[41637.15,1,0.0,41637.15]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[77437.45000000001,2,0.0,38718.725000000006]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[494319.13,1,0.0,494319.13]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[571756.58,3,0.0,190585.52666666664]}],"4":[{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[0,1,1]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[0,1,1]},{"label":"Victor Greaves","path":["Victor Greaves"],"level":0,"kind":"detail","cells":[0,0,0]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[0,2,2]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[0,0,0]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[0,2,2]}],"5":[{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[0.0,1]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[0.0,1]},{"label":"Victor Greaves","path":["Victor Greaves"],"level":0,"kind":"detail","cells":[null,0]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[0.0,2]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[null,0]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[0.0,2]}]},"totals":{"0":[35800.3,41637.15,494319.13,571756.58],"1":[1,1,1,3],"2":[571756.58,3,0.0,190585.52666666664],"3":[571756.58,3,0.0,190585.52666666664],"4":[0,2,2],"5":[0.0,2]},"tables":[{"id":"0","title":"Balance by Status & Closer","anchor":"A11:I20","population":3,"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":"Grand Total","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3,4]]},{"id":"1","title":"Deal Count by Status & Closer","anchor":"A28:I37","population":3,"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":"Grand Total","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3,4]]},{"id":"2","title":"Deals by Lead Source","anchor":"A46:E55","population":3,"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":3,"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":3,"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":3,"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":571756.58,"format":"$"},{"label":"Total deals","value":3,"format":"General"},{"label":"Avg. deal","value":190585.52666666664,"format":"$"}],"columns":{"0":[{"label":"Row Labels","path":[],"format":"text","kind":"label"},{"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":["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":["Heather Henson"],"format":"General","kind":"detail"},{"label":"Count of Final Balance","path":["Jennifer Porter"],"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":[null,35800.3,null,35800.3]},{"label":"Active Client","path":["Active Client"],"level":0,"kind":"detail","cells":[null,null,494319.13,494319.13]},{"label":"Approved","path":["Approved"],"level":0,"kind":"detail","cells":[41637.15,null,null,41637.15]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[41637.15,35800.3,null,77437.45000000001]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[null,null,494319.13,494319.13]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[41637.15,35800.3,494319.13,571756.58]}],"1":[{"label":"App Signed","path":["App Signed"],"level":0,"kind":"detail","cells":[0,1,0,1]},{"label":"Active Client","path":["Active Client"],"level":0,"kind":"detail","cells":[0,0,1,1]},{"label":"Approved","path":["Approved"],"level":0,"kind":"detail","cells":[1,0,0,1]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[1,1,0,2]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[0,0,1,1]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[1,1,1,3]}],"2":[{"label":"Opener Transfer Form (READYMODE) - TRANSFER","path":["Opener Transfer Form (READYMODE) - TRANSFER"],"level":0,"kind":"detail","cells":[77437.45000000001,2,0.0,38718.725000000006]},{"label":"SMS","path":["SMS"],"level":0,"kind":"detail","cells":[494319.13,1,0.0,494319.13]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[77437.45000000001,2,0.0,38718.725000000006]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[494319.13,1,0.0,494319.13]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[571756.58,3,0.0,190585.52666666664]}],"3":[{"label":"Velocify TEAM Majd","path":["Velocify TEAM Majd"],"level":0,"kind":"subtotal","cells":[35800.3,1,0.0,35800.3]},{"label":"Ardjie Docallos GE31","path":["Velocify TEAM Majd","Ardjie Docallos GE31"],"level":1,"kind":"detail","cells":[35800.3,1,0.0,35800.3]},{"label":"BDA TEAM Mid-Level","path":["BDA TEAM Mid-Level"],"level":0,"kind":"subtotal","cells":[494319.13,1,0.0,494319.13]},{"label":"Jenikka Calanno","path":["BDA TEAM Mid-Level","Jenikka Calanno"],"level":1,"kind":"detail","cells":[494319.13,1,0.0,494319.13]},{"label":"ReadyMode TEAM Majd","path":["ReadyMode TEAM Majd"],"level":0,"kind":"subtotal","cells":[41637.15,1,0.0,41637.15]},{"label":"Lizbeth Tepeyac GE49","path":["ReadyMode TEAM Majd","Lizbeth Tepeyac GE49"],"level":1,"kind":"detail","cells":[41637.15,1,0.0,41637.15]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[77437.45000000001,2,0.0,38718.725000000006]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[494319.13,1,0.0,494319.13]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[571756.58,3,0.0,190585.52666666664]}],"4":[{"label":"(blank)","path":["(blank)"],"level":0,"kind":"detail","cells":[77437.45000000001,2,0.0,38718.725000000006]},{"label":"IN","path":["IN"],"level":0,"kind":"detail","cells":[494319.13,1,0.0,494319.13]},{"label":"CR","path":[],"level":0,"kind":"program","program":"cr","cells":[77437.45000000001,2,0.0,38718.725000000006]},{"label":"DEL","path":[],"level":0,"kind":"program","program":"delancey","cells":[494319.13,1,0.0,494319.13]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[571756.58,3,0.0,190585.52666666664]}]},"totals":{"0":[41637.15,35800.3,494319.13,571756.58],"1":[1,1,1,3],"2":[571756.58,3,0.0,190585.52666666664],"3":[571756.58,3,0.0,190585.52666666664],"4":[571756.58,3,0.0,190585.52666666664]},"tables":[{"id":"0","title":"Balance by Status & Closer","anchor":"A11:F15","population":3,"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":"Heather Henson","colspan":1,"rowspan":1,"row_label":false},{"label":"Jennifer Porter","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]]},{"id":"1","title":"Deal Count by Status & Closer","anchor":"A20:F24","population":3,"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":"Heather Henson","colspan":1,"rowspan":1,"row_label":false},{"label":"Jennifer Porter","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]]},{"id":"2","title":"Deals by Lead Source","anchor":"A29:E34","population":3,"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":3,"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":3,"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]]}]}]