[{"tab":"Table","title":"BDA Closed Deals Report","headline":[{"label":"Total balance","value":1808934.05,"format":"$"},{"label":"Total deals","value":22,"format":"General"},{"label":"Avg. deal","value":82224.27500000001,"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":["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":["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":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[573461.48,177594.81,751056.29]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[340585.02,80088.75,420673.77]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[98647.99,148946.1,247594.09000000003]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[155320.52,null,155320.52]},{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[null,122253.06,122253.06]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[80908.62,null,80908.62]},{"label":"Christian Aguilar","path":["Christian Aguilar"],"level":0,"kind":"detail","cells":[31127.7,null,31127.7]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[1280051.33,528882.72,1808934.05]}],"1":[{"label":"Christian Aguilar","path":["Christian Aguilar"],"level":0,"kind":"detail","cells":[1,0,1]},{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[0,1,1]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[1,1,2]},{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[3,3,6]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[5,2,7]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[3,0,3]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[2,0,2]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[15,7,22]}],"2":[{"label":"Opener Transfer Form (READYMODE) - TRANSFER","path":["Opener Transfer Form (READYMODE) - TRANSFER"],"level":0,"kind":"detail","cells":[1128860.82,16,0.0,70553.80125]},{"label":"SMS","path":["SMS"],"level":0,"kind":"detail","cells":[78783.61,2,0.0,39391.805]},{"label":"Asad Afzal","path":["Asad Afzal"],"level":0,"kind":"detail","cells":[563849.62,3,0.0,187949.87333333332]},{"label":"DRIPS PT Applications","path":["DRIPS PT Applications"],"level":0,"kind":"detail","cells":[37440.0,1,0.0,37440.0]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[1808934.05,22,0.0,82224.27500000001]}],"3":[{"label":"Velocify TEAM Majd","path":["Velocify TEAM Majd"],"level":0,"kind":"subtotal","cells":[150611.71000000002,3,0.0,50203.90333333334]},{"label":"Ardjie Docallos GE31","path":["Velocify TEAM Majd","Ardjie Docallos GE31"],"level":1,"kind":"detail","cells":[116324.68000000001,2,0.0,58162.340000000004]},{"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":[505367.59,6,0.0,84227.93166666667]},{"label":"Raul Arturo De La Cruz GE53","path":["ReadyMode TEAM Benjamin","Raul Arturo De La Cruz GE53"],"level":1,"kind":"detail","cells":[153380.76,2,0.0,76690.38]},{"label":"Christian Martinez GE57","path":["ReadyMode TEAM Benjamin","Christian Martinez GE57"],"level":1,"kind":"detail","cells":[148946.1,1,0.0,148946.1]},{"label":"Cesar Villarruel GE53","path":["ReadyMode TEAM Benjamin","Cesar Villarruel GE53"],"level":1,"kind":"detail","cells":[142936.44,2,0.0,71468.22]},{"label":"Pedro Salgado GE53","path":["ReadyMode TEAM Benjamin","Pedro Salgado GE53"],"level":1,"kind":"detail","cells":[60104.29,1,0.0,60104.29]},{"label":"ReadyMode TEAM Almira","path":["ReadyMode TEAM Almira"],"level":0,"kind":"subtotal","cells":[318825.47000000003,4,0.0,79706.36750000001]},{"label":"Rosemarie Bautista GE7","path":["ReadyMode TEAM Almira","Rosemarie Bautista GE7"],"level":1,"kind":"detail","cells":[151498.57,1,0.0,151498.57]},{"label":"Jeffrey Guiao GE35","path":["ReadyMode TEAM Almira","Jeffrey Guiao GE35"],"level":1,"kind":"detail","cells":[83440.0,1,0.0,83440.0]},{"label":"Richie Simbajon GE19","path":["ReadyMode TEAM Almira","Richie Simbajon GE19"],"level":1,"kind":"detail","cells":[49141.98,1,0.0,49141.98]},{"label":"Nina Andrea Galvan G84","path":["ReadyMode TEAM Almira","Nina Andrea Galvan G84"],"level":1,"kind":"detail","cells":[34744.92,1,0.0,34744.92]},{"label":"BDA TEAM Mid-Level","path":["BDA TEAM Mid-Level"],"level":0,"kind":"subtotal","cells":[536405.72,3,0.0,178801.90666666665]},{"label":"Heather Henson","path":["BDA TEAM Mid-Level","Heather Henson"],"level":1,"kind":"detail","cells":[492937.1,2,0.0,246468.55]},{"label":"Jenikka Calanno","path":["BDA TEAM Mid-Level","Jenikka Calanno"],"level":1,"kind":"detail","cells":[43468.62,1,0.0,43468.62]},{"label":"N/A","path":["N/A"],"level":0,"kind":"subtotal","cells":[35314.99,1,0.0,35314.99]},{"label":"Almira Jane Mactal","path":["N/A","Almira Jane Mactal"],"level":1,"kind":"detail","cells":[35314.99,1,0.0,35314.99]},{"label":"BDA TEAM Closer","path":["BDA TEAM Closer"],"level":0,"kind":"subtotal","cells":[70912.52,1,0.0,70912.52]},{"label":"Jennifer Porter","path":["BDA TEAM Closer","Jennifer Porter"],"level":1,"kind":"detail","cells":[70912.52,1,0.0,70912.52]},{"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":[154056.05,3,0.0,51352.01666666666]},{"label":"Lizbeth Tepeyac GE49","path":["ReadyMode TEAM Majd","Lizbeth Tepeyac GE49"],"level":1,"kind":"detail","cells":[117490.51999999999,2,0.0,58745.259999999995]},{"label":"Gerardo Diaz GE58","path":["ReadyMode TEAM Majd","Gerardo Diaz GE58"],"level":1,"kind":"detail","cells":[36565.53,1,0.0,36565.53]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[1808934.05,22,0.0,82224.27500000001]}],"4":[{"label":"Christian Aguilar","path":["Christian Aguilar"],"level":0,"kind":"detail","cells":[1,0,1]},{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[1,0,1]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[2,0,2]},{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[3,3,6]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[1,6,7]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[3,0,3]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[2,0,2]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[13,9,22]}],"5":[{"label":"Christian Aguilar","path":["Christian Aguilar"],"level":0,"kind":"detail","cells":[7.0,1]},{"label":"Dedra Jefferies","path":["Dedra Jefferies"],"level":0,"kind":"detail","cells":[0.0,1]},{"label":"Dewayne Callaham","path":["Dewayne Callaham"],"level":0,"kind":"detail","cells":[null,2]},{"label":"Heather Henson","path":["Heather Henson"],"level":0,"kind":"detail","cells":[2.3333333333333335,6]},{"label":"Jennifer Porter","path":["Jennifer Porter"],"level":0,"kind":"detail","cells":[1.1428571428571428,7]},{"label":"Mayette Velasco","path":["Mayette Velasco"],"level":0,"kind":"detail","cells":[3.0,3]},{"label":"Samantha Pryce","path":["Samantha Pryce"],"level":0,"kind":"detail","cells":[4.5,2]},{"label":"Grand Total","path":[],"level":0,"kind":"total","cells":[2.35,22]}]},"totals":{"0":[1280051.33,528882.72,1808934.05],"1":[15,7,22],"2":[1808934.05,22,0.0,82224.27500000001],"3":[1808934.05,22,0.0,82224.27500000001],"4":[13,9,22],"5":[2.35,22]},"tables":[{"id":"0","title":"Balance by Status & Closer","anchor":"A11:I20","population":22,"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":"Active Client","colspan":1,"rowspan":1,"row_label":false},{"label":"Grand Total","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3]]},{"id":"1","title":"Deal Count by Status & Closer","anchor":"A28:I37","population":22,"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":"Active Client","colspan":1,"rowspan":1,"row_label":false},{"label":"Grand Total","colspan":1,"rowspan":1,"row_label":false}]],"print_panels":[[1,2,3]]},{"id":"2","title":"Deals by Lead Source","anchor":"A46:E55","population":22,"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":22,"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":22,"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":22,"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]]}]}]