{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data Control","Summary Results"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data Control","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
["Sales Represntatives","Cancellation Reason Code","Campaigns"]
["Al Michalchuk","Collections / Non Payment","Alarm.com Lead"]
["Hailey Litchfield","Show Home","Brookfield Customer (Sold)"]
["Jared Steed","Move Outside Canada","Brookfield Show Home"]
["Justin De Rush","Move Within Canada","Customer Referral"]
["Lisa Schwager","Deceased","Door to Door"]
["Nathan Baldry","Competitor Switchover","DTD - Family & Friends"]
["Pat Kickham","No Perceived Value","Employee Referral"]
["Russell Keddie","Pull Equipment / Rip-Out","Family/Friends"]
["Sarah Depew","Closed Business","Homeshow"]
["Taylor Wolsey","Moved HOUSE to PTRON","Homexx Show Home"]
["Troy Cole","Retirement Home","HOUSE - Move Outside (1) Year"]
["D2D Accounts","J&J Northstar ","HOUSE - Move Within (1) Year"]
["J&J Northstar Accounts",null,"HOUSE - Takeover Outside (1) Year"]
[null,null,"HOUSE - Takeover Within (1) Year"]
[null,null,"HouseMaster"]
[null,null,"Insure Your Way Inc."]
[null,null,"InterNet Search"]
[null,null,"J&J Northstar HOUSE Accounts"]
[null,null,"Landmark Customers (Sold)"]
[null,null,"Landmark Employee"]
[null,null,"Landmark Show Home - Calgary"]
[null,null,"Landmark Show Home - Edmonton"]
[null,null,"Liberty Security Website"]
[null,null,"Meadows Park Project"]
[null,null,"PERS Customer Accounts"]
[null,null,"Self Generated"]
[null,null,"Twilite Music"]
[null,null,"UrbanAge Show Home"]

{"sheet":"Summary Results","index":1,"n_rows":111,"n_cols":5,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
["SUMMARY RESULT OF HOUSE ACCOUNTS REVIEW:"]
["Created 02/12/2013"]
[]
["LIBERTY SECURITY ACCOUNTS OVERVIEW:"]
[]
[null,"2014-12-13","2014-01-01","2014-02-01"]
["Opening Balance",1253,{"$f":"B13","v":1279},{"$f":"C13","v":1319}]
["Customer Account Cancellations",6,5,0]
["Show Home Cancellations",2,1,0]
["Sub Total of Active HOUSE Accounts",{"$f":"B8-B9-B10","v":1245},{"$f":"C8-C9-C10","v":1273},{"$f":"D8-D9-D10","v":1319}]
["New Active HOUSE Accounts",34,46,13]
["Total Active HOUSE Accuonts",{"$f":"B11+B12","v":1279},{"$f":"C11+C12","v":1319},{"$f":"D11+D12","v":1332}]
[]
["J&J NORTHSTAR ACCOUNTS OVERVIEW:"]
[]
[null,"2013-12-01","2014-01-01","2014-02-14"]
["Opening Balance",146,{"$f":"B21","v":146},{"$f":"C21","v":145}]
["J&J Customer Account Cancellations",0,1,1]
["J&J New Active HOUSE Accounts",0,0,0]
["Total Active J&J HOUSE Accuonts",{"$f":"B18-B19+B20","v":146},{"$f":"C18-C19+C20","v":145},{"$f":"D18-D19+D20","v":144}]
[]
["SHOW HOME ACCOUNTS OVERVIEW:"]
[]
[null,"2014-12-13","2014-01-14","2014-02-14"]
["*Artisan Homes",1,1,1]
["**Brookfield Homes",22,22,22]
["*Homexx Homes",2,3,3]
["**Jaya Homes",1,1,1]
["*Landmark Homes",42,41,41]
["*UrbanAge Homes",1,1,0]
["Total Active Show Home Accounts",{"$f":"SUM(B26:B31)","v":69},69,{"$f":"SUM(D26:D31)","v":68}]
["*Free Monitoring Show Homes"]
["**Paying Monitoring Show Homes"]
[]
["OVERALL HOUSE ACCOUNT OVERVIEW:"]
[]
[null,"2013-12-01","2014-01-01","2014-02-01","Running Totals"]
["Opening Balance",{"$f":"B8+B18","v":1399},{"$f":"C8+C18","v":1425},{"$f":"C42","v":1464}]
["Total Customer Account Cancellations",{"$f":"B9+B10+B19","v":8},{"$f":"C9+C10+C19","v":7},{"$f":"D9+D10+D19","v":1},{"$f":"SUM($B40:D40)","v":16}]
["Total NEW Active HOUSE Accounts",{"$f":"B12+B20","v":34},{"$f":"C12+C20","v":46},{"$f":"D12+D20","v":13},{"$f":"SUM($B41:D41)","v":93}]
["Total Active HOUSE Accounts",{"$f":"B39-B40+B41","v":1425},{"$f":"C39-C40+C41","v":1464},{"$f":"D39-D40+D41","v":1476},{"$f":"E39-E40+E41","v":77}]
[]
[]
["Sales Results Based on Campaign Breakdown:"]
[]
["Campaign","2013-12-01","2014-01-01","2014-02-01","Running Totals"]
["Alarm.com Lead",0,0,1,{"$f":"SUM($B48:D48)","v":1}]
["Brookfield Customer (Sold)",0,0,0,{"$f":"SUM($B49:D49)","v":0}]
["Brookfield Show Home",0,1,3,{"$f":"SUM($B50:D50)","v":4}]
["Customer Referral",3,4,0,{"$f":"SUM($B51:D51)","v":7}]
["Door to Door",5,7,5,{"$f":"SUM($B52:D52)","v":17}]
["DTD - Family & Friends",0,0,4,{"$f":"SUM($B53:D53)","v":4}]
["Employee Referral",0,1,0,{"$f":"SUM($B54:D54)","v":1}]
["Family/Friends",3,3,3,{"$f":"SUM($B55:D55)","v":9}]
["Homeshow",0,2,0,{"$f":"SUM($B56:D56)","v":2}]
["Homexx Show Home",0,0,1,{"$f":"SUM($B57:D57)","v":1}]
["HOUSE - Move Outside (1) Year",0,0,0,{"$f":"SUM($B58:D58)","v":0}]
["HOUSE - Move Within (1) Year",0,0,1,{"$f":"SUM($B59:D59)","v":1}]
["HOUSE - Takeover Outside (1) Year",0,0,2,{"$f":"SUM($B60:D60)","v":2}]
["HOUSE - Takeover Within (1) Year",0,0,0,{"$f":"SUM($B61:D61)","v":0}]
["HouseMaster",0,0,1,{"$f":"SUM($B62:D62)","v":1}]
["Insure Your Way Inc.",0,0,0,{"$f":"SUM($B63:D63)","v":0}]
["InterNet Search",4,3,4,{"$f":"SUM($B64:D64)","v":11}]
["J&J Northstar HOUSE Accounts",0,0,0,{"$f":"SUM($B65:D65)","v":0}]
["Landmark Customers (Sold)",0,5,1,{"$f":"SUM($B66:D66)","v":6}]
["Landmark Employee",2,1,0,{"$f":"SUM($B67:D67)","v":3}]
["Landmark Show Home - Calgary",0,0,0,{"$f":"SUM($B68:D68)","v":0}]
["Landmark Show Home - Edmonton",3,0,2,{"$f":"SUM($B69:D69)","v":5}]
["Liberty Security Website",0,0,0,{"$f":"SUM($B70:D70)","v":0}]
["Meadows Park Project",4,2,2,{"$f":"SUM($B71:D71)","v":8}]
["PERS Customer Accounts",1,1,0,{"$f":"SUM($B72:D72)","v":2}]
["Self Generated",9,16,11,{"$f":"SUM($B73:D73)","v":36}]
["Twilite Music",0,0,0,{"$f":"SUM($B74:D74)","v":0}]
["UrbanAge Show Home",0,0,0,{"$f":"SUM($B75:D75)","v":0}]
["Total Add HOUSE Accounts",{"$f":"SUM(B48:B75)","v":34},{"$f":"SUM(C48:C75)","v":46},{"$f":"SUM(D48:D75)","v":41},{"$f":"SUM(E48:E75)","v":121}]
[]
["Sales Results Based on Sales Representative Breakdown:"]
[]
["Sales Representative Name","2013-12-01","2014-01-01","2014-02-01","Running Totals"]
["Al Michalchuk",5,2,2,{"$f":"SUM($B81:D81)","v":9}]
["Hailey Litchfield",0,0,1,{"$f":"SUM($B82:D82)","v":1}]
["Jared Steed",6,11,9,{"$f":"SUM($B83:D83)","v":26}]
["Justin De Rush",4,14,6,{"$f":"SUM($B84:D84)","v":24}]
["Lisa Schwager",0,2,5,{"$f":"SUM($B85:D85)","v":7}]
["Nathan Baldry",0,0,8,{"$f":"SUM($B86:D86)","v":8}]
["Pat Kickham",0,0,0,{"$f":"SUM($B87:D87)","v":0}]
["Russell Keddie",3,0,2,{"$f":"SUM($B88:D88)","v":5}]
["Sarah Depew",0,0,4,{"$f":"SUM($B89:D89)","v":4}]
["Taylor Wolsey",1,0,1,{"$f":"SUM($B90:D90)","v":2}]
["Troy Cole",6,8,2,{"$f":"SUM($B91:D91)","v":16}]
["D2D Accounts",9,9,3,{"$f":"SUM($B92:D92)","v":21}]
["J&J Northstar Accounts",0,0,0,{"$f":"SUM($B93:D93)","v":0}]
["Totals",{"$f":"SUM(B81:B93)","v":34},{"$f":"SUM(C81:C93)","v":46},{"$f":"SUM(D81:D93)","v":43},{"$f":"SUM(E81:E93)","v":123}]
[]
["Cancellation Reasons - Running Results:"]
[]
["Cancellation Reason Code","2013-12-01","2014-01-01","2014-02-01","Running Totals"]
["Collections / Non Payment",0,0,1,{"$f":"SUM($B99:D99)","v":1}]
["Show Home",2,1,2,{"$f":"SUM($B100:D100)","v":5}]
["Move Outside Canada",0,0,1,{"$f":"SUM($B101:D101)","v":1}]
["Move Within Canada",3,2,0,{"$f":"SUM($B102:D102)","v":5}]
["Deceased",0,0,0,{"$f":"SUM($B103:D103)","v":0}]
["Competitor Switchover",2,1,0,{"$f":"SUM($B104:D104)","v":3}]
["No Perceived Value",1,2,1,{"$f":"SUM($B105:D105)","v":4}]
["Pull Equipment / Rip-Out",0,0,0,{"$f":"SUM($B106:D106)","v":0}]
["Closed Business",0,0,1,{"$f":"SUM($B107:D107)","v":1}]
["Moved HOUSE to PTRON",0,0,2,{"$f":"SUM($B108:D108)","v":2}]
["Retirement Home",0,0,1,{"$f":"SUM($B109:D109)","v":1}]
["J&J Northstar ",0,1,0,{"$f":"SUM($B110:D110)","v":1}]
["Total Monthly Cancellations",{"$f":"SUM(B99:B110)","v":8},{"$f":"SUM(C99:C110)","v":7},{"$f":"SUM(D99:D110)","v":9},{"$f":"SUM(E99:E110)","v":24}]