{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["DIRECT","DTVCOMM","DISH","DISHCOM","Totals"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"DIRECT","index":0,"n_rows":6,"n_cols":18,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Customer","Area","SaleDate","InstallDate","Acct#","Inv#","WOType","Promotion","WOExpect","WOPaid","CommExpect","CommPaid","CommChrgbk","LeadPay","RepPay","TechPay","COGS","Tax"]
["GARY GARDNER","American Fork","2016-01-07","2016-01-08",10709,16131,"Service Call",null,350,350,0,0,0,0,0,0,0,0]
["EVAN ASTLE","American Fork","2016-01-20","2016-01-20",7430,16174,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["ALEX STEPANOV","Las Vegas","2016-01-20","2016-01-21",13428,16176,"Service Call",null,80,80,0,0,0,0,0,0,0,0]
["ROGER WHITE","Pahrump","2016-01-14","2016-01-14",13412,16155,"New Activation","DIRECTV 24 month",0,0,390,510,0,0,125,100,75,0]
["TAMMY SCOTT","Pahrump","2016-01-16","2016-01-18",13419,16163,"New Activation","DIRECTV 24 month",0,0,15,535,0,0,125,100,398.99,0]

{"sheet":"DTVCOMM","index":1,"n_rows":62,"n_cols":18,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Customer","Area","SaleDate","InstallDate","Acct#","Inv#","WOType","Promotion","WOExpect","WOPaid","CommExpect","CommPaid","CommChrgbk","LeadPay","RepPay","TechPay","COGS","Tax"]
["ZOEY RILEY","American Fork","2015-12-30","2016-01-07",13363,16081,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["BILL BRUCE","American Fork","2015-12-31","2016-01-11",13370,16094,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["LARAINE  CHRISTENS...","American Fork","2016-01-04","2016-01-04",13373,16097,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["MEG  COLLINS","American Fork","2016-01-04","2016-01-04",13374,16098,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["SUSAN  TANNER","American Fork","2016-01-04","2016-01-04",13375,16099,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,274,0]
["ERIN  LEWIS","American Fork","2016-01-04","2016-01-04",13376,16100,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["LANNY  WILLIE","American Fork","2016-01-04","2016-01-07",13377,16101,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,0,0]
["MARIA  BERNAL","American Fork","2016-01-04","2016-01-12",13378,16102,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["MELVIN  OLSEN","American Fork","2016-01-04","2016-01-04",13379,16103,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["TYMME HERBERT ","American Fork","2016-01-04","2016-01-04",13380,16104,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["SAIDA  CHRISTOPHER...","American Fork","2016-01-04","2016-01-04",13381,16105,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,199.98,0]
["CHRIS PETERSEN","American Fork","2016-01-04","2016-01-04",13382,16106,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["RUTH  VREEKEN","American Fork","2016-01-04","2016-01-04",13383,16107,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["JOHN  BLAND","American Fork","2016-01-04","2016-01-04",13384,16108,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["GEORGE  DOHERTY","American Fork","2016-01-05","2016-01-05",13388,16114,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["ANA JOHANSON","American Fork","2016-01-05","2016-01-07",13389,16115,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["SONIA MACHAVO","American Fork","2016-01-05","2016-01-07",13390,16116,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,199.98,0]
["HOLIDAY INN EXPRESS","American Fork","2016-01-05","2016-01-06",9151,16119,"Trouble Call",null,0,0,0,0,0,0,0,0,0,0]
["SUNDANCE MOUNTAIN ...","American Fork","2016-01-05","2016-01-04",12443,16120,"Trouble Call",null,100,100,0,0,0,0,0,100,0,0]
["JOHN  BLAND","American Fork","2016-01-06","2016-01-07",13384,16121,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["ELVIRA GRANADOS","American Fork","2016-01-07","2016-01-07",13394,16126,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["IAN CUMMINGS","American Fork","2016-01-11","2016-01-12",13404,16140,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["SUNDANCE MOUNTAIN ...","American Fork","2016-01-11","2016-01-09",12443,16141,"Trouble Call",null,719.98,719.98,0,0,0,0,0,0,0,0]
["SUNDANCE FITNESS C...","American Fork","2016-01-15","2016-01-23",13418,16161,"New Activation","Business Viewing",524.91,524.91,300,0,0,0,0,0,375,0]
["RIVERVIEW APARTMENTS","American Fork","2016-01-15","2016-01-15",13398,16162,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,0,0]
["SUNDANCE MOUNTAIN ...","American Fork","2016-01-17","2016-01-17",12443,16164,"Trouble Call",null,400,400,0,0,0,0,0,0,0,0]
["HOLIDAY INN EXPRESS","American Fork","2016-01-17","2016-01-17",9151,16165,"Trouble Call",null,250,0,0,0,0,0,0,0,0,0]
["DEREK  CLARKE","American Fork","2016-01-18","2016-01-18",13420,16166,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["CRISTINA  BARRIONU...","American Fork","2016-01-18","2016-01-18",13421,16167,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["WILLIAM  SKAGGS ","American Fork","2016-01-18","2016-01-18",13422,16168,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,0,0]
["ANA  DIAZ","American Fork","2016-01-18","2016-01-18",13423,16169,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99.99,0]
["RIVERVIEW APARTMENTS","American Fork","2016-01-21","2016-01-29",13398,16179,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["SUSAN  MAXFIELD","American Fork","2016-01-25","2016-01-28",13431,16184,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,274.99,0]
["ROBERT MURPHY","Las Vegas","2015-08-03","2016-01-18",13066,15539,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,447,0]
["STEPHEN SCHRUHL ","Las Vegas","2015-12-07","2016-01-14",13129,16017,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["RYAN WYNN","Las Vegas","2015-12-30","2016-01-05",13295,16086,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["ALEXIS  BARNES","Las Vegas","2016-01-04","2016-01-04",13385,16109,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,249,0]
["BLAKE  FERRON","Las Vegas","2016-01-07","2016-01-08",13393,16124,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,225,0]
["BRYAN GOOD","Las Vegas","2016-01-07","2016-01-07",13357,16125,"Service Call",null,0,0,0,0,0,0,0,0,225,0]
["NADINE  CELESTE ","Las Vegas","2016-01-07","2016-01-08",13395,16127,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,225,0]
["KWESI  STEPHENSON","Las Vegas","2016-01-11","2016-01-12",13401,16136,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,75,0]
["JESSICA  BROOKS","Las Vegas","2016-01-11","2016-01-11",13402,16137,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,150,0]
["JAMES  DONOHUE","Las Vegas","2016-01-11","2016-01-11",13403,16138,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["ERIC  VESCUSO","Las Vegas","2016-01-11","2016-01-13",13396,16139,"Service Call",null,0,0,0,0,0,0,0,0,150,0]
["LEVEL 25 AT DURANGO","Las Vegas","2016-01-11","2016-01-11",13405,16144,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["JAMES  DONOHUE","Las Vegas","2016-01-12","2016-01-12",13403,16145,"Service Call",null,0,0,0,0,0,0,0,0,75,0]
["CENTRAL CHRISTIAN ...","Las Vegas","2016-01-12","2016-01-13",11955,16147,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["BRITTANY  FINDRICK ","Las Vegas","2016-01-13","2016-01-14",13409,16151,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,297,0]
["KELLY RYAN","Las Vegas","2016-01-14","2016-01-14",13413,16156,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99,0]
["NATHAN  GREENE ","Las Vegas","2016-01-14","2016-01-15",13414,16157,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["NEMATOLAH  KASHANIAN","Las Vegas","2016-01-14","2016-01-15",13415,16158,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,0,0]
["SARAH  JACOBSEN ","Las Vegas","2016-01-14","2016-01-15",13416,16159,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,0,0]
["LAUREN  MASTON","Las Vegas","2016-01-19","2016-01-21",13424,16171,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99,0]
["HENRY WEBB","Las Vegas","2016-01-19","2016-01-20",13425,16172,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,99,0]
["TANIA  FLORES","Las Vegas","2016-01-21","2016-01-22",13429,16177,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,0,0]
["JUSTIN FRANK","Las Vegas","2016-01-25","2016-01-26",13179,16186,"Trouble Call (no pay)",null,0,0,0,0,0,0,0,0,0,0]
["JOHN  CASTRO ","Las Vegas","2016-01-27","2016-01-27",13434,16191,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,0,0]
["ASHLEY  JEROME ","Las Vegas","2016-01-27","2016-01-29",13435,16192,"New Activation","MDU Residential",0,0,0,0,0,0,0,0,0,0]
["BARBRA BRUCE","Las Vegas","2016-01-27","2016-01-28",13059,16193,"Trouble Call (no pay)",null,0,0,0,0,0,0,0,0,0,0]
["LEVEL 25 AT DURANGO","Las Vegas","2016-01-28","2016-01-28",13405,16210,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["PRIMM VALLEY RESOR...","Las Vegas","2016-01-13","2016-01-13",105,16333,"Service Call",null,1800,0,0,0,0,0,0,0,0,0]

{"sheet":"DISH","index":2,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Customer","Area","SaleDate","InstallDate","Acct#","Inv#","WOType","Promotion","WOExpect","WOPaid","CommExpect","CommPaid","CommChrgbk","LeadPay","RepPay","TechPay","COGS","Tax"]
["LEROY PAGE","American Fork","2015-11-23","2016-01-06",13307,15987,"Upgrade","DISH'n It Up Plan A",50,50,423,423,0,0,0,0,298,0]
["DAVID CRAWLEY","American Fork","2015-12-28","2016-01-06",10630,16066,"Upgrade","DISH'n It Up Plan C",50,50,119,70,0,0,0,0,148,0]
["GRANT LOADER","American Fork","2015-12-29","2016-01-04",12451,16069,"Service Call",null,60,60,0,0,0,0,0,0,0,0]
["ANDREW WILLIAMS","American Fork","2016-01-07","2016-01-11",12781,16134,"Upgrade","DISH'n It Up Plan A",75,75,119,176,0,0,0,0,99,0]
["KARREN HYNEK","American Fork","2016-01-08","2016-01-12",11088,16135,"Service Call",null,75,75,0,0,0,0,0,0,0,0]
["SUZANNE  CARSON","American Fork","2016-01-12","2016-01-12",13408,16149,"Sale",null,26.69,26.69,0,0,0,0,0,0,0,1.69]
["LYNN  HALLIDAY","American Fork","2016-01-13","2016-01-13",13325,16150,"Service Call",null,50,50,0,0,0,0,0,0,0,0]
["ENSIGN FINANCIAL","American Fork","2016-01-15","2016-01-19",13417,16160,"New Activation","DHA Plus 24 Month",263.49,263.49,772,757,0,0,0,0,147,13.5]
["RANDY ROSKELLEY","American Fork","2016-01-19","2016-01-21",13426,16173,"New Activation","DHA Plus 24 Month",0,0,774,889,0,0,0,0,199,0]
["WILLIAM BOUSFIELD","American Fork","2016-01-25","2016-01-26",11546,16182,"Trouble Call",null,0,0,0,0,0,0,0,0,199,0]
["ROBERT MARENGO","Las Vegas","2016-01-05","2016-01-08",13392,16118,"Service Call",null,75,75,0,0,0,0,0,0,0,0]
["JENSINE FAUBUS","Las Vegas","2016-01-07","2016-01-11",13399,16130,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["VICKI GARCIA","Las Vegas","2016-01-20","2016-01-20",13427,16175,"Sale",null,54.06,54.06,0,0,0,0,0,0,0,4.07]
["MARIANNE GUNDERMAN","Las Vegas","2016-01-21","2016-01-22",7822,16180,"Trouble Call",null,0,0,0,0,0,0,0,0,0,0]
["JAY BERNARDONI","Las Vegas","2016-01-22","2016-01-22",13347,16181,"Refund",null,-117.02,-117.02,0,0,0,0,0,0,0,0]
["CRAIG TAKEMOTO","Las Vegas","2016-01-25","2016-01-28",12660,16185,"Dish Mover","DISH Mover Plan B",0,0,50,0,0,0,0,0,0,0]
["BENNY  LOPEZ ","Las Vegas","2016-01-26","2016-01-28",13433,16189,"Service Call",null,0,0,0,0,0,0,0,0,0,0]

{"sheet":"DISHCOM","index":3,"n_rows":4,"n_cols":18,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Customer","Area","SaleDate","InstallDate","Acct#","Inv#","WOType","Promotion","WOExpect","WOPaid","CommExpect","CommPaid","CommChrgbk","LeadPay","RepPay","TechPay","COGS","Tax"]
["UTAH VALLEY REGION...","American Fork","2016-01-04","2016-01-05",9800,16111,"Service Call",null,0,0,0,0,0,0,0,0,0,0]
["COLVILLE CORRECTIO...","American Fork","2016-01-06","2016-01-06",8000,16122,"Sale",null,469.97,469.97,0,0,0,0,0,0,0,0]
["PRIMM VALLEY RESOR...","Las Vegas","2015-11-24","2016-01-08",105,15993,"Service Call",null,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Totals","index":4,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"WO Expected","Comm Exp","Pay(Lead,Rep,Tech)","COGS"]
["DirectTV",430,405,450,473.99]
["DirectTV Commercial",3794.89,300,100,5238.8]
["Dish",662.22,2257,0,1090]
["Dish Commercial",469.97,0,0,0]