{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Organization","Individual","Business","Customer","Lead List Generator","Options","Totals","ReturnedBrochures"],"not_rendered":{"charts":0,"images":0,"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":"Organization","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Org. #","Name","Zip Code","# of brochures completed","# of Participants – Monthly","# of individuals participating – Total","Amount of $ raised – Monthly","Amount of $ raised – Total"]
[3,"Wasatch Thunder","84604",18,2,11,300,3478]
[1,"Windridge Elementary","84037",12,12,30,0,2000]
[8,"BYU","84604",5,null,null,1]
[2,"Burton Elementary","84037",6,8,50,1,10000]
[7,"New Org 1",11111]
[6,"Wasatch Thunder U-13",84009]
[5,"Rush U-13",84037]
[4,"Rush U-12","84037"]
[9,"Knowlton Elementary",84098]

{"sheet":"Individual","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["ID #","Name","School/ Organization","$ Raised - Monthly","$ Raised - Total","# of brochures returned – Monthly","# of brochures returned – Total"]
[1,"Zac Wiser","Burton Elementary",0,20,0,16]
[2,"Kylie Hekking","Windridge Elementary",30,5000,3,30]
[3,"Elizabeth Davidson","BYU",0,0,0,0]
[4,"Rob Hilton","BYU",0,0,0,0]
[5,"Trent Anderson","BYU",0,0,0,0]
[6,"Jason Boyd","BYU",0,0,0,5]
[7,"Amy Clegg","BYU",0,0,0,0]
[8,"Tyler White","BYU",0,0,0,0]
[9,"Lance Foutz","BYU",0,0,0,0]
[10,"Lauren Leany","BYU",0,0,0,0]
[11,"Ryan Knight","BYU",0,0,0,0]
[12,"Matthew Poole","BYU",0,0,0,0]
[13,"Kyle Olsen","BYU",0,0,0,0]
[14,"Ford Newsome","BYU",0,0,0,0]
[15,"Kendalson Williams","Wasatch Thunder",null,null,null,3]
[16,"Cam Mason","Wasatch Thunder",null,null,null,3]

{"sheet":"Business","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Customer","index":3,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["#","Name","Zip code","Phone #","Email","Date(s) they completed brochure(s)","# of options checked on most recent brochure","Confirmation call/email","Total revenue per brochure","Total revenue","Individual(s) who gave them brochure","Options checked on brochure","Businesses that purchased their leads"]
[1,"Jerry Wiser",84037,8012999768,"test@wiserguys.net","2016-04-08",10,null,null,null,"Zac Wiser"," Realtor(Sell), Cable/Satellite/Internet, Tree care/removal, Nail Salon, Accounting services, Physician, Massage therapy, Auto insurance, New tires, Home Theatre/Audio Systems"]
[2,"Kris Hekking",22101,7032003360,"kris@gmail.com","2016-04-11",6,null,null,null,"Kylie Hekking","  Carpet purchase,  Roof/gutter work,  Construction, Legal insurance, Legal Services, Dry cleaning"]
[5,"Harry Potter",22101,8015466561,"harry@hogwarts.edu","2016-04-04",8,null,null,null,"Kylie Hekking"," New Dentist, Lawn Care, New Car, test 1, test 2, test 3, test 4, test 5"]
[6,"Ron Weasley",22101,7035466178,"ron@hogwarts.edu","2016-04-08",16,null,null,null,"Zac Wiser"," New Dentist, Lawn Care, New Car, test 1, test 2, test 3, test 4, test 5, Another one, more test, plastic surgery, nose trimming, cobbler, back shave, yet another test, this is hard"]
[7,"Severus Snape",56849,9845556677,"snape@hogwarts.edu","2016-04-11",1,null,null,null,"Jason Boyd"," Realtor(Sell)"]
[8,"Minerva McGonnegal",90876,7032044801,"minerva@hogwarts.edu","2016-01-04",3,null,null,null,"Kylie Hekking","  HVAC purchase/service,  Construction, Dry cleaning"]
[9,"Bruce Mason",84037,2005879034,"bruce@gmail.com","2016-04-11",8,null,null,null,"Cam Mason"," Remodeling/Renovations,  Home energy audit,  Carpet purchase,  Roof/gutter work,  Construction, Fence installation/repair, ID Theft Protection, Dry cleaning"]
[10,"Martha Williams",84037,8013998765,"martha@gmail.com","2016-04-11",5,null,null,null,"Kendalson Williams","  HVAC purchase/service,  Home energy audit,  Carpet purchase,  Construction, Life insurance"]
[11,"Severus Snape",56849,8014999635,"snape@hogwarts.edu","2016-04-11",2,null,null,null,"Jason Boyd"," Realtor(Sell)"]
[12,"Tyler Hansen",84037,8012345678,"tyler@gmail.com","2016-04-11",6,null,null,null,"Cam Mason","  Home appliance Purchase/Repair, Solar Energy,  Roof/gutter work,  Landscaping/yard care, Legal insurance, Clothing"]
[13,"Tyson Hekking",22101,7085554444,"tyson@gmail.com","2016-04-11",3,null,null,null,"Kylie Hekking","  HVAC purchase/service,  Construction, Dry cleaning"]
[14,"Susan Hekking",22101,7038887777,"susan@gmail.com","2016-04-11",20,null,null,null,"Zac Wiser","  Insurance,  Home appliance Purchase/Repair,  Carpet purchase,  Roof/gutter work,  Construction, Legal insurance, Dry cleaning, Hair Salon, Physician, Massage therapy, Life Coach, Health Club/Gym Membership, Car rental, Oil change, Car detailing/wash, Home Playground Equipment, Mostorcycle purchase/repair, Cruises, Bicycle purchase/repair, Business coaching"]
[15,"Pete Tesch",84205,8014887654,"peter@gmal.com","2016-04-12",8,null,null,null,"Zac Wiser"," Water softener/water heater, Home energy audit, Home Security System, Tree care/removal, Landscaping/yard care, Construction, Legal insurance, Jewelry"]

{"sheet":"Lead List Generator","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
[" Realtor(Sell), Insurance, HVAC purchase/service, Home Security System, Roof/gutter work, Auto loan, Home Playground Equipment"]
["Name","Zip code","Phone #","Email","Options checked on brochure"]
["Jerry Wiser",84037,8012999768,"test@wiserguys.net","  Realtor(Sell), Insurance"]
["Kris Hekking",22101,7032003360,"kris@gmail.com"," Insurance, Roof/gutter work"]
["Severus Snape",56849,9845556677,"snape@hogwarts.edu","  Realtor(Sell)"]
["Minerva McGonnegal",90876,7032044801,"minerva@hogwarts.edu"," HVAC purchase/service"]
["Bruce Mason",84037,2005879034,"bruce@gmail.com"," Roof/gutter work"]
["Martha Williams",84037,8013998765,"martha@gmail.com"," Insurance, HVAC purchase/service"]
["Severus Snape",56849,8014999635,"snape@hogwarts.edu","  Realtor(Sell)"]
["Tyler Hansen",84037,8012345678,"tyler@gmail.com"," Insurance, Roof/gutter work"]
["Tyson Hekking",22101,7085554444,"tyson@gmail.com"," HVAC purchase/service"]
["Susan Hekking",22101,7038887777,"susan@gmail.com"," Insurance, Roof/gutter work, Home Playground Equipment"]
["Pete Tesch",84205,8014887654,"peter@gmal.com"," Insurance, Home Security System"]

{"sheet":"Options","index":5,"n_rows":77,"n_cols":2,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Brochure Options:"]
[1,"Realtor(Buy)"]
[2,"Realtor(Sell)"]
[3,"Remodeling/Renovations"]
[4,"Insurance"]
[5,"Cable/Satellite/Internet"]
[6,"Mortgage Lender/Refinance"]
[7,"Water softener/water heater"]
[8,"HVAC purchase/service"]
[9,"Home appliance Purchase/Repair"]
[10,"Solar Energy"]
[11,"Home energy audit"]
[12,"Home Security System"]
[13,"Carpet purchase"]
[14,"Carpet cleaning"]
[15,"Roof/gutter work"]
[16,"Tree care/removal"]
[17,"Landscaping/yard care"]
[18,"Lawn aeration"]
[19,"Construction"]
[20,"Pest control"]
[21,"Fence installation/repair"]
[22,"ID Theft Protection"]
[23,"Legal insurance"]
[24,"Legal Services"]
[25,"Clothing"]
[26,"Dry cleaning"]
[27,"Jewelry"]
[28,"Life insurance"]
[29,"Hair Salon"]
[30,"Nail Salon"]
[31,"Cell phone purchase/repair"]
[32,"Computer purchase/repair"]
[33,"Retirement/investment planning"]
[34,"Swimming Lessons"]
[35,"Animal care/boarding"]
[36,"Daycare/baby-sitting"]
[37,"Online education"]
[38,"Nanny"]
[39,"Accounting services"]
[40,"Piano Lessons"]
[41,"Guitar Lessons"]
[42,"Musical Instrument Lessons"]
[43,"Dentist"]
[44,"Physician"]
[45,"Health/Dental insurance"]
[46,"Personal trainer"]
[47,"Nutritionist"]
[48,"Massage therapy"]
[49,"Esthetician Services"]
[50,"Life Coach"]
[51,"Exercise Equipment/Home gym"]
[52,"Health Club/Gym Membership"]
[53,"Auto purchase"]
[54,"Auto insurance"]
[55,"Car rental"]
[56,"Auto maintenance"]
[57,"Oil change"]
[58,"Auto repair"]
[59,"New tires"]
[60,"Car detailing/wash"]
[61,"Auto loan"]
[62,"Home Playground Equipment"]
[63,"Home Theatre/Audio Systems"]
[64,"Mostorcycle purchase/repair"]
[65,"Travel Agent"]
[66,"Golf instruction/equipment"]
[67,"Sporting event/concert tickets"]
[68,"Cruises"]
[69,"Bicycle purchase/repair"]
[70,"Business Finance/lending"]
[71,"Business coaching"]
[72,"Document shredding"]
[73,"Work from home opportunity"]
[74,"Accounting services"]
[75,"Sales Coaching/Training"]
[76,"Business Legal Services"]

{"sheet":"Totals","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"ReturnedBrochures","index":7,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Brochure #","Customer","Date","Zip","Individual","Organization","Selections"]
[1,"Martha Williams","2016-04-11","84037","Kendalson Williams","Wasatch Thunder","  HVAC purchase/service,  Home energy audit,  Carpet purchase,  Construction, Life insurance"]
[2,"Severus Snape","2016-04-11","84604","Jason Boyd","BYU"," Remodeling/Renovations,  Mortgage Lender/Refinance,  Carpet purchase,  Construction, Clothing"]
[3,"Jerry Wiser","2016-04-11","84037","Zac Wiser","Burton Elementary","  Mortgage Lender/Refinance, Solar Energy, Carpet cleaning,  Landscaping/yard care, Dry cleaning"]
[4,"Severus Snape","2016-04-11","22101","Jason Boyd","BYU"," Realtor(Sell), Realtor(Sell)"]
[5,"Bruce Mason","2016-04-11","84606","Cam Mason","Wasatch Thunder","  HVAC purchase/service, Tree care/removal, Pest control"]
[6,"Bruce Mason","2016-04-11","22101","Cam Mason","Wasatch Thunder","  HVAC purchase/service, Tree care/removal, Pest control"]
[7,"Bruce Mason","2016-04-11","84604","Cam Mason","Wasatch Thunder"," Remodeling/Renovations,  Home energy audit,  Carpet purchase,  Roof/gutter work,  Construction, Fence installation/repair, ID Theft Protection, Dry cleaning"]
[8,"Tyler Hansen","2016-04-11","84037","Cam Mason","Wasatch Thunder","  Home appliance Purchase/Repair, Solar Energy,  Roof/gutter work,  Landscaping/yard care, Legal insurance, Clothing"]
[9,"Tyson Hekking","2016-04-11","22101","Kylie Hekking","Windridge Elementary","  HVAC purchase/service,  Construction, Dry cleaning"]
[10,"Susan Hekking","2016-04-11","22101","Zac Wiser","Burton Elementary","  Insurance,  Home appliance Purchase/Repair,  Carpet purchase,  Roof/gutter work,  Construction, Legal insurance, Dry cleaning, Hair Salon, Physician, Massage therapy, Life Coach, Health Club/Gym Membership, Car rental, Oil change, Car detailing/wash, Home Playground Equipment, Mostorcycle purchase/repair, Cruises, Bicycle purchase/repair, Business coaching"]
[11,"Pete Tesch","2016-04-11","84205","Zac Wiser","Burton Elementary","  HVAC purchase/service, Tree care/removal, Pest control"]
[12,"Kris Hekking","2016-04-11","22101","Kylie Hekking","Windridge Elementary","  Home energy audit, Tree care/removal, ID Theft Protection"]
[13,"Kris Hekking","2016-04-11","22101","Kylie Hekking","Windridge Elementary"," Realtor(Sell),  Cable/Satellite/Internet,  HVAC purchase/service,  Home energy audit,  Roof/gutter work"]
[14,"Kris Hekking","2016-04-11","22101","Kylie Hekking","Windridge Elementary","  Carpet purchase,  Roof/gutter work,  Construction, Legal insurance, Legal Services, Dry cleaning"]
[15,"Pete Tesch","2016-04-12","84205","Zac Wiser","Burton Elementary"," Water softener/water heater, Home energy audit, Home Security System, Tree care/removal, Landscaping/yard care, Construction, Legal insurance, Jewelry"]
[16,"Jerry Wiser","2016-04-08","84037","Zac Wiser","Burton Elementary"," Realtor(Sell), Cable/Satellite/Internet, Tree care/removal, Nail Salon, Accounting services, Physician, Massage therapy, Auto insurance, New tires, Home Theatre/Audio Systems"]