{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Info","Jan 2014","Feb 2014","Mar 2014","April 2014","May 2014","June 2014","July 2014","Aug 2014","Sept 2014","Oct 2014","Nov 2014","Dec 2014"],"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":"Info","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Lead Sources",null,"Salesman",null,"Emails"]
["Angie List-Online",null,"Darren",null,"Email #1"]
["Customer Referral",null,"Dave",null,"Email #2"]
["ESPN700 Radio-Broadcast",null,"Jeremy",null,"Email #3"]
["Facebook-Social Media",null,"Katri"]
["Google Search Call In",null,"Office"]
["Home Show",null,"Steve"]
["HomeTown Values Magazine-Print",null,"Tom"]
["K-Bull Radio"]
["KDOJ Oldies Radio-Broadcast"]
["KNRS Radio-Broadcast"]
["KSL Local Listing-Print"]
["Oldies KDOJ"]
["Pepperwood HOA-Direct Mail"]
["Pet Magazine"]
["PPC-Online"]
["TBD-TBD"]
["Value Pages-Direct Mail"]
["Website-Website"]
["Yelp-Online"]
["Other"]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"Jan 2014","index":1,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["2014-01-01","to","2014-01-31",null,0]
["Lead Sources",null,"CallSource Numbers",null,"Salesman","Monthly Referrals","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",null,null,null,"Darren"]
["Customer Referral",null,null,null,"Dave"]
["ESPN700 Radio-Broadcast",null,null,null,"Jeremy"]
["Facebook-Social Media",null,null,null,"Katri"]
["Google Search Call In",null,null,null,"Office"]
["Home Show",null,null,null,"Steve"]
["HomeTown Values Magazine-Print",null,null,null,"Tom"]
["K-Bull Radio"]
["KDOJ Oldies Radio-Broadcast"]
["KNRS Radio-Broadcast"]
["KSL Local Listing-Print"]
["PPC-Online"]
["Oldies KDOJ"]
["Pepperwood HOA-Direct Mail"]
["Pet Magazine"]
["TBD-TBD"]
["Value Pages-Direct Mail"]
["Website-Website"]
["Yelp-Online"]
["Other"]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]

{"sheet":"Feb 2014","index":2,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["2014-02-01","to","2014-02-28",null,0]
["Lead Sources",null,"CallSource Numbers",null,"Salesman","Monthly Referrals","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",null,null,null,"Darren"]
["Customer Referral",null,null,null,"Dave"]
["ESPN700 Radio-Broadcast",null,null,null,"Jeremy"]
["Facebook-Social Media",null,null,null,"Katri"]
["Google Search Call In",null,null,null,"Office"]
["Home Show",null,null,null,"Steve"]
["HomeTown Values Magazine-Print",null,null,null,"Tom"]
["K-Bull Radio"]
["KDOJ Oldies Radio-Broadcast"]
["KNRS Radio-Broadcast"]
["KSL Local Listing-Print"]
["PPC-Online"]
["Oldies KDOJ"]
["Pepperwood HOA-Direct Mail"]
["Pet Magazine"]
["TBD-TBD"]
["Value Pages-Direct Mail"]
["Website-Website"]
["Yelp-Online"]
["Other"]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]

{"sheet":"Mar 2014","index":3,"n_rows":217,"n_cols":19,"rows_kept":217,"cut":false,"hidden":false,"merged":[]}
["2014-03-01","to","2014-03-31"]
["Lead Sources","Lead Sheet Totals","CallSource Numbers",null,"Salesman","Monthly Leads","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",3,10,null,"Darren",20,3,0.15,7031]
["Customer Referral",4,null,null,"Dave",1,0,0,0]
["ESPN700 Radio-Broadcast",0,1,null,"Jeremy",9,2,0.22222222222222221,4100]
["Facebook-Social Media",0,0,null,"Katri",0,0,null,0]
["Google Search Call In",0,null,null,"Office",0,0,null,0]
["Home Show",2,null,null,"Steve",18,4,0.22222222222222221,5004]
["HomeTown Values Magazine-Print",0,50,null,"Tom",7,0,0,0]
["K-Bull Radio",0]
["KDOJ Oldies Radio-Broadcast",0,7]
["KNRS Radio-Broadcast",0,33]
["KSL Local Listing-Print",0,26]
["PPC-Online",0,16]
["Oldies KDOJ",0]
["Pepperwood HOA-Direct Mail",0,0]
["Pet Magazine",0]
["TBD-TBD",0,1]
["Value Pages-Direct Mail",0,42]
["Website-Website",0,1]
["Yelp-Online",1,0]
["Other",0]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]
[null,"2014-03-03","Richards, Libby",null,"801-898-9003",null,null,null,null,"Angie List-Online",null,null,"Pet Door",null,null,null,null,"2014-03-04",970]
[null,"2014-03-03","Worthen, Veron",null,"801-572-1081",null,null,null,null,"Angie List-Online",12976750422,null,"Not Interested"]
[null,"2014-03-03","Deberham, Mona",null,"801-808-7190",null,null,null,null,null,12977530522,null,"Not Interested",null,null,"Dave"]
[null,"2014-03-03","Phadnis, Nitin",null,"801-277-7389",null,null,null,null,"Value Pages",null,null,"3 Basement Windows",null,"2014-03-06","Steve",null,"2014-03-07",852]
[null,"2014-03-03","McBride, Mike",null,"801-966-0828",null,null,null,null,null,12979454522,null,"Not Interested"]
[null,"2014-03-03","Middleton, Yvonne",null,"801-295-7906",null,null,null,null,null,12980283422,null,"Hung up on me"]
[null,"2014-03-03","Rebecca",null,"801-644-2494",null,null,null,null,"Home Show",null,null,"Wooden PD, Pet Door"]
[null,"2014-03-03","Jackson, Victor",null,"801-319-8998",null,null,null,null,"Yelp-Online",null,null,"Too much$$$"]
[null,"2014-03-03","Ratcliffe, Collette",null,"801-499-4930",null,null,null,null,null,null,null,"Too much$$$"]
[null,"2014-03-03","Taylor, Wendy",null,"801-589-4288",null,null,null,null,null,null,null,"Too much$$$"]
[null,"2014-03-03","Wheeler, Jean",null,"217-714-7188",null,null,null,null,null,null,null,"Not real phone or email"]
[null,"2014-03-03","Piirainen, Neal",null,"N/A",null,null,null,null,null,null,null,"Pet Door",1]
[null,"2014-03-03","Askew, Alyssa",null,"801-628-6140",null,null,null,null,null,null,null,"French Door"]
[null,"2014-03-03","LuAnn",null,"801-243-8572",null,null,null,null,null,null,null,"Price on pet door, she c/b"]
[null,"2014-03-03","Erskine, Jordan",null,"801-856-0784",null,null,null,null,null,null,null,"LM"]
[null,"2014-03-03","Robinson, Lisa",null,"801-253-2114",null,null,null,null,null,null,null,"LM"]
[null,"2014-03-03","Norton, Charles",null,"801-935-0320",null,null,null,null,null,null,null,"Pet Door"]
[null,"2014-03-03","Green, Lisa",null,"801-254-9765",null,null,null,null,null,574962320,null,"LM",1]
[null,"2014-03-03","Bennett, Ralph",null,"801-834-7126",null,null,null,null,null,12982089222,null,"5 Broken Windows"]
[null,"2014-03-03","Tommy",null,"801-372-8879",null,null,33333,null,null,null,null,"French Door talk to his wife."]
[null,"2014-03-03","Schroeder, Jason",null,"801-940-1817",null,null,null,null,null,null,null,"Pet Door"]
[null,"2014-03-03","Fisher, Adam",null,"801-209-4243",null,null,null,null,null,null,null,"On Line Quote",1]
[null,"2014-03-03","Smith, Joann",null,"801-278-0600",null,null,null,null,"Value Pages",null,null,"Pet Door",null,"2014-03-06","Steve",null,"2014-03-06",1070]
[null,"2014-03-03","Orton, Debbie",null,"801-295-3482",null,null,null,null,"Value Pages",null,null,"Patio Door w/blinds",null,"2014-03-10","Steve",null,"2014-03-10",1845]
[null,"2014-03-04","Costa, Steve",null,"801-735-5647",null,null,null,null,null,null,null,"3 Winodws",null,"2014-03-11","Steve",null,"2014-03-11",1237]
[null,"2014-03-04","Collette, Dan",null,"N/A",null,null,null,null,null,null,null,"Warantee Problem"]
[null,"2014-03-04","Wilcox, Frank",null,"801-968-8569",null,null,null,null,null,574961575,null,"Mail box full"]
[null,"2014-03-04","Cook, Susan",null,"801-455-0539",null,null,null,null,null,12983672422,null,"LM",1]
[null,"2014-03-04","Miller, Paul",null,"801-753-1782",null,null,null,null,null,null,null,"Fast Busy",1,null,null,null,"2014-03-17",2295]
[null,"2014-03-04","Stone, San",null,"435-757-2563",null,null,null,null,null,null,null,"LM",1]
[null,"2014-03-04","Montana, Tana",null,"801-707-7327",null,null,null,null,null,12991843322,null,"LM",1]
[null,"2014-03-04","Glauser, Kayley",null,"801-831-5758",null,null,null,null,null,12995131122,null,"LM",1]
[null,"2014-03-05","Brown, Jeannie",null,"801-360-3014",null,null,null,null,null,null,null,"Pool House glass"]
[null,"2014-03-05","Alexander, David",null,"801-830-2955",null,null,null,null,null,null,null,"Wants price"]
[null,"2014-03-05","Shauna & Melka",null,"801-809-8777",null,null,null,null,null,null,null,"Broken Glass"]
[null,"2014-03-05","Pullan, Charles",null,"801-859-7288",null,null,null,null,null,null,null,"Glass in 2 patio w/blinds"]
[null,"2014-03-05","Alexander, David",null,"801-830-2955",null,null,null,null,null,null,null,"10 Windows"]
[null,"2014-03-05","Belisle, Rebecca",null,"801-631-7851",null,null,null,null,"Website",null,null,"1 Window or more",null,"2014-03-11","Darren",null,"2014-03-14",2275]
[null,"2014-03-05","Naffate, Julie",null,"891-987-3731",null,null,null,null,null,null,null,"Front room Window"]
[null,"2014-03-05","Harding, Earl",null,"801-884-8663",null,null,null,null,null,null,null,"20 Windows"]
[null,"2014-03-05","Gomez, Daniel",null,"801-420-8352",null,null,null,null,"Value Pages",null,null,"9 Windows 1 PT",null,"2014-03-10","Darren",null,"2014-03-11",3761]
[null,"2014-03-05","Johnson, Mike",null,"435-730-2251",null,null,null,null,null,null,null,"LM",1]
[null,"2014-03-05","Lawler, Russ",null,"801-865-9321",null,null,null,null,null,13004950622,null,"Architect"]
[null,"2014-03-05","Maxwell, Natalie",null,"801-755-2267",null,null,null,null,null,574980466,null,"LM"]
[null,"2014-03-05","Thomas, Jason",null,"801-891-2514",null,null,null,null,null,null,null,"LM",1]
[null,"2014-03-05","Lindquist, Jesse",null,"801-631-4142",null,null,null,null,null,null,null,"Sending Plans Over"]
[null,"2014-03-05","Bushman, Penny",null,"N/A",null,null,null,null,null,null,null,"Wants price no phone # or size",1]
[null,"2014-03-05","Ondrak, Joanne",null,"801-968-7471",null,null,null,null,null,13002438622,null,"Wants to order on line. $$$"]
[null,"2014-03-05","Karen",null,"801-420-4200",null,null,null,null,null,null,null,"Gave info on pet door."]
[null,"2014-03-05","Chappell, Ashley",null,"801-895-6482",null,null,null,null,null,12999800022,null,"LM",1]
[null,"2014-03-05","Galbraith, Robin",null,"801-836-8470",null,null,null,null,null,null,null,"Glass"]
[null,"2014-03-06","Peck, Zayne",null,"801-414-4886",null,null,null,null,null,null,null,"15 Windows"]
[null,"2014-03-06","Pingree, Anne",null,"801-903-3164",null,null,null,null,null,null,null,"3 Winodws",1]
[null,"2014-03-06","Johnson, Mike",null,"435-730-2251",null,null,null,null,null,null,null,"LM"]
[null,"2014-03-06","Smith, Christy",null,"801-649-8173",null,null,null,null,null,null,null,"Wants window to be patio door"]
[null,"2014-03-06","Johnson, Kim",null,"801-966-5326",null,null,null,null,null,574993164,null,"Fast Busy",1]
[null,"2014-03-06","Pearman, Quincy",null,"801-310-2332",null,null,null,null,null,13010097622,null,"LM",1]
[null,"2014-03-06","Cuthbert, Georgia",null,"801-463-3653",null,null,null,null,null,13014930722,null,"LM",1]
[null,"2014-03-06","Hamilton, Tomas",null,"801-643-3905",null,null,null,null,null,null,null,"1 Pet Door"]
[null,"2014-03-06","Larsen, Dave",null,"801-561-4557",null,null,null,null,null,null,null,"Alum single pane windows."]
[null,"2014-03-06","Daniels, Nicholas",null,"801-815-2260",null,null,null,null,null,null,null,"On Line Quote/ darren"]
[null,"2014-03-06","Lords,Tessie",null,"801-652-6388",null,null,null,null,null,13019998122,null,"Pet Door"]
[null,"2014-03-06","Forsey, Allen",null,"801-573-3925",null,null,null,null,null,1301875992,null,"Wrong #",1]
[null,"2014-03-06","Flores, Walter",null,"801-703-4048",null,null,null,null,null,null,null,"Pet Door"]
[null,"2014-03-06","Deadman, Debbie",null,"801-558-3613",null,null,null,null,null,null,null,"Glass"]
[null,"2014-03-07","Beers, Willie",null,"435-770-0084",null,null,null,null,null,null,null,"wants a french door w/blinds"]
[null,"2014-03-07","Tonga, Michelle",null,"801-577-5794",null,null,null,null,null,null,null,"Wants price on glass"]
[null,"2014-03-07","Early, Ella",null,"801-792-7859",null,null,null,null,null,13024000822,null,"LM",1]
[null,"2014-03-07","Sundstrom, Susan",null,"434-644-4696",null,null,null,null,null,13024209622,null,"Mail box full",1]
[null,"2014-03-07","Burroughs, Kaydee",null,"907-957-1192",null,null,null,null,null,null,null,"Wrong #",1]
[null,"2014-03-10","Isakson, Gina",null,"801-674-5070",null,null,null,null,null,null,null,"Pet Door",1]
[null,"2014-03-10","Hannon, Angie",null,"801-669-2088",null,null,null,null,null,null,null,"Pet Door"]
[null,"2014-03-10","Monson, Natlie",null,"801-628-8838",null,null,null,null,null,null,null,"Complete House"]
[null,"2014-03-10","Stevens, Heather",null,"801-884-9222",null,null,null,null,null,null,null,"10 Windows"]
[null,"2014-03-10","Healy, Dolores",null,"801-750-7393",null,null,null,null,null,null,null,"Pet Door",1]
[null,"2014-03-07","Stookey, Julia",null,"801-864-8666",null,null,null,null,null,null,null,"All windows"]
[null,"2014-03-10","Rose, Richard",null,"435-830-3463",null,null,null,null,null,null,null,"Dog too small for pet door."]
[null,"2014-03-10","Hawkins, Donna",null,"801-253-5154",null,null,null,null,null,575015586,null,"LM"]
[null,"2014-03-10","Buddensick, Heather",null,"801-915-7354",null,null,null,null,null,null,null,"LM"]
[null,"2014-03-10","Bills, Jay",null,"N/A",null,null,null,null,null,null,null,"No way to call. sent email",1]
[null,"2014-03-10","Roberts, Mark",null,"801-910-5270",null,null,null,null,null,null,null,"L/M"]
[null,"2014-03-10","Gaustad, Richard",null,"801-599-8482",null,null,null,null,"Website",null,null,"Dog Door",null,"2014-03-18","Darren",null,"2014-03-14",995]
[null,"2014-03-10","Brian",null,"385-233-7341",null,null,null,null,null,null,null,"Not reachable",1]
[null,"2014-03-10","McCallun Don",null,"307-872-7446",null,null,null,null,null,null,null,"Ordered pet door",1,null,null,null,"2014-03-06"]
[null,"2014-03-10","Gilbert, Rich",null,"435-618-1111",null,null,null,null,null,null,null,"Radio ad/ talk to wife"]
[null,"2014-03-10","Wilson",null,"N/A",null,null,null,null,null,null,null,"On line quote",1]
[null,"2014-03-10","Devey, David",null,"801-502-8545",null,null,null,null,null,null,null,"Not correct phone number"]
[null,"2014-03-11","Cackett, Robert",null,"801-243-4943",null,null,null,null,null,null,null,"Dead"]
[null,"2014-03-11","Jongejan, Eileen",null,"801-566-1928",null,null,null,null,null,575022295,null,"Too Pricey/Dead"]
[null,"2014-03-11","DeLaForre, Jamie",null,"801-448-4494",null,null,null,null,null,575015702,null,"Sliding Door/Office doors"]
[null,"2014-03-11","King, Kelly",null,"801-234-0535",null,null,null,null,null,null,null,"Patio Door"]
[null,"2014-03-11","Maubent, Stephanie",null,"801-628-2210",null,null,null,null,null,null,null,"Walk in quoted new house",1]
[null,"2014-03-12","Cruser, Daryl",null,"213-440-4149",null,null,null,null,null,575031073,null,"Measure house & call"]
[null,"2014-03-12","Woodbury, Tom",null,"801-330-9511",null,null,null,null,null,null,null,"Complete House"]
[null,"2014-03-12","Daniels, Garth",null,"801-910-2877",null,null,null,null,null,null,null,"L/M"]
[null,"2014-03-12","Hendershot, Rich",null,"801-298-1587",null,null,null,null,null,null,null,"Glass Rpr"]
[null,"2014-03-12","Ed",null,"801-222-2222",null,null,null,null,null,null,null,"Not real #",1]
[null,"2014-03-12","Beaty, Bonnie",null,"435-640-7834",null,null,null,null,null,575028560,null,"L/M"]
[null,"2014-03-12","Thornton, Coleen",null,"949-582-1292",null,null,null,null,null,575031233,null,"L/M",1]
[null,"2014-03-12","Kartchner, Theone",null,"801-446-7492",null,null,null,null,null,575034855]
[null,"2014-03-13","Server, Joe",null,"801-766-9126",null,null,null,null,null,575043575,null,"10 Windows",null,"2014-03-25","Steve"]
[null,"2014-03-13","Anderson, Jeff",null,"801-598-7068",null,null,null,null,null,575035084,null,"Condo complete"]
[null,"2014-03-13","Holdaway, Scott",null,"801-243-4887",null,null,null,null,null,null,null,"Bathroom Window"]
[null,"2014-03-13","Jenkins, Helen",null,"307-883-2010",null,null,null,null,null,null,null,"Wants CA or SH",1]
[null,"2014-03-13","Dahl, Tyler",null,"801-473-5418",null,null,null,null,null,null,null,"Needs new windows"]
[null,"2014-03-13","Paul Mary",null,"602-315-2341",null,null,null,null,null,575037531,null,"Message said John"]
[null,"2014-03-13","Carlson, Scott",null,"801-860-7852",null,null,null,null,null,575037382,null,"L/M"]
[null,"2014-03-14","Hales, Mike",null,"801-394-1300",null,null,null,null,null,null,null,"Just rings/Pet door",1]
[null,"2014-03-14","Rees, Nick",null,"801-209-2867",null,null,null,null,null,575047095,null,"L/M"]
[null,"2014-03-14","Ford, Debbie",null,"801-607-5521",null,null,null,null,null,null,null,"Call in Pet door"]
[null,"2014-03-14","Jamie",null,"801-380-3682",null,null,null,null,null,null,null,"Sliding door & French door"]
[null,"2014-03-14","Johnson, Chris",null,"N/A",null,null,null,null,null,"Home Show",null,"Needs new windows"]
[null,"2014-03-14","Gardner, Derek",null,"801-599-9202",null,null,null,null,null,null,null,"15+ windows"]
[null,"2014-03-17","Opoulis, Sandi",null,"801-232-4669",null,null,null,null,null,null,null,"Patio Door/pet",null,"2014-03-24","Jeremy"]
[null,"2014-03-17","Pickens, Amber",null,"801-882-0693",null,null,null,null,"Milgard",575057680,null,"12 plus window",null,"2014-03-25","Steve"]
[null,"2014-03-17","Worthington, Tonya",null,"801-450-2795",null,null,null,null,null,null,null,"Pet Door",null,"2014-03-24","Darren"]
[null,"2014-03-17","Chang, Wei",null,"801-368-9668",null,null,null,null,null,null,null,"52 Windows",null,"2014-03-25","Darren"]
[null,"2014-03-17","Carlson, Dennis",null,"801-842-5247",null,null,null,null,"Website",null,null,"DH windows"]
[null,"2014-03-17","Holz, Melodie",null,"801-466-7124",null,null,null,null,"Milgard",575055917,null,"Patio Doors",1]
[null,"2014-03-17","Brittany",null,"801-380-7390",null,null,null,null,null,null,null,"L/M"]
[null,"2014-03-17","Hay, Glen",null,"801-419-8879",null,null,null,null,"Milgard",575057211,null,"L/M"]
[null,"2014-03-17","Mcdermott, James",null,"801-209-3050",null,null,null,null,"Milgard",575059266,null,"French Door"]
[null,"2014-03-17","Walker, Lori",null,"801-608-9080",null,null,null,null,"Website",null,null,"PW"]
[null,"2014-03-17","Hummer, Bill",null,"612-859-2023",null,null,null,null,"Home Show",null,null,"Complete home",null,"2014-03-25","Darren"]
[null,"2014-03-18","Thompson, Carl",null,"801-819-9655",null,null,null,null,"Website",null,null,"Patio Door w/Pet",null,"2014-03-26","Jeremy"]
[null,"2014-03-18","Mumford, Erik",null,"801-943-8018",null,null,null,null,"Website",null,null,"want quote.",1]
[null,"2014-03-18","Mr. Alder",null,"801-618-9793"]
[null,"2014-03-18","Winterrowd, Paul",null,"801-518-6729",null,null,null,null,"Customer Referral",null,null,"Darren Customer, glass",null,"2014-03-24","Jeremy"]
[null,"2014-03-18","Edwards, Landon",null,"801-910-3947",null,null,null,null,"Customer Referral",null,null,null,null,"2014-03-24","Darren"]
[null,"2014-03-18","Kramer, Hasko",null,"801-557-7125",null,null,null,null,"Website",null,null,"13 Windows",null,"2014-03-27","Darren"]
[null,"2014-03-18","Randall, Lacy",null,"801-295-9131",null,null,null,null,"Website",null,null,"3 Windows",null,"2014-03-27","Darren"]
[null,"2014-03-19","Fisher, Gerald",null,"801-568-1789",null,null,null,null,"Home Town Values",null,null,"5 Windows",null,"2014-03-29","Steve"]
[null,"2014-03-19","Kayma, Jose",null,"801-330-5186",null,null,null,null,"KNRS Radio",null,null,"10 Windows",null,"2014-03-29","Steve"]
[null,"2014-03-19","Adams, Steve",null,"801-706-8450",null,null,null,null,"Milgard","Aron @ Milgard",null,"Patio Door",null,"2014-03-25","Jeremy"]
[null,"2014-03-19","Brown, Carl",null,"801-494-7578",null,null,null,null,"Website",null,null,"Complete home, 1-2 at a time",null,"2014-03-25","Steve"]
[null,"2014-03-19","Peters, Tyler",null,"801-643-8112",null,null,null,null,"Website",null,null,"15-20 Windows",null,"2014-03-28","Steve"]
[null,"2014-03-19","Mike",null,"801-663-9796",null,null,null,null,"Website",null,null,"1windows"]
[null,"2014-03-20","Osterthorpe, Alan",null,"801-641-0324",null,null,null,null,null,null,null,null,null,"2014-03-20","Jeremy",null,"2014-03-20",3000]
[null,"2014-03-25","Wilson, Dennis",null,"801-201-3497",null,null,null,null,"KNRS Radio",null,null,"Pet Door",null,"2014-03-28","Tom"]
[null,"2014-03-20","Malstrom, Cassey",null,"801-231-7336",null,null,null,null,"Customer Referral",null,null,"4 more windows",null,"2014-03-24","Jeremy",null,"2014-03-20",1100]
[null,"2014-03-20","Rolette, Enedina",null,"801-819-5347",null,null,null,null,"KSL Local Listing",null,null,"Rental Unit",null,"2014-03-27","Steve"]
[null,"2014-03-20","Griffiths, Dave",null,"801-682-8109",null,null,null,null,"Website",null,null,"Back of house",null,"2014-03-28","Darren"]
[null,"2014-03-20","Bell, Larry",null,"801-451-7611",null,null,null,null,"KNRS Radio",null,null,"Patio door/pet door",null,"2014-03-31","Darren"]
[null,"2014-03-20","White, Jace",null,"801-513-8909",null,null,null,null,"KNRS Radio",null,null,"Has strom windows",null,"2014-03-31","Darren"]
[null,"2014-03-19","Slaughter, Dan",null,"801-633-4756",null,null,null,null,"Milgard",575078066,null,"L/M"]
[null,"2014-03-20","Jolly, Lauren",null,"646-498-1001",null,null,null,null,"Milgard",575071691,null,"L/M"]
[null,"2014-03-20","Kris",null,"801-782-9668",null,null,null,null,"Website",null,null,"Quoted, just starting"]
[null,"2014-03-20","Mawhinnie, Randall",null,"801-803-9259",null,null,null,null,"Website",null,null,"18 Windows, C/B"]
[null,"2014-03-21","Boyle, Sue",null,"801-619-0942",null,null,null,null,"Milgard",575092582,null,"No mailbox",1]
[null,"2014-03-21","Evans, Lisa",null,"813-484-5564",null,null,null,null,"Website",null,null,"2 Windows now",null,"2014-03-24","Steve"]
[null,"2014-03-24","Slack, Ellis",null,"801-864-5177",null,null,null,null,"Home Town Values",null,null,"Pet Door",null,"2014-03-24","Steve"]
[null,"2014-03-24","Miller, Rick",null,"801-960-7263",null,null,null,null,"Home Town Values",null,null,"20 Windows",null,"2014-03-26","Steve"]
[null,"2014-03-24","Borg, Kevin",null,"801-633-3026",null,null,null,null,"Website",null,null,"Sun Room",null,"2014-03-27","Jeremy"]
[null,"2014-03-24","Hemingway, Laurie",null,"801-808-1738",null,null,null,null,"Website",null,null,"Pet Door in basement window",null,"2014-03-27","Tom"]
[null,"2014-03-24","Phillps, John",null,"801-668-6751",null,null,null,null,"Website",null,null,"1 Bathroom Window",null,"2014-03-27","Steve"]
[null,"2014-03-25","Cassidy, Brooke",null,"801-891-4752",null,null,null,null,"Customer Referral",null,null,"2 Windows/ jennie Olsen",null,"2014-03-28","Darren"]
[null,"2014-03-25","Allen, Dezi",null,"801-458-6015",null,null,null,null,"Website",null,null,"10 Winodws 1 french Door",null,"2014-03-27","Darren"]
[null,"2014-03-24","Pincock, Rick",null,"801-815-6670",null,null,null,null,"Milgard",575111266,null,"1 Winodw"]
[null,"2014-03-25","Hughes, Brad",null,"801-969-7241",null,null,null,null,"Quinn Street",13250840022,null,"L/M"]
[null,"2014-03-25","Query, Mike",null,"801-599-7967",null,null,null,null,"Quinn Street",4627741523,null,"need written quote.",null,"2014-03-27","Tom"]
[null,"2014-03-26","Hansen, Leslie",null,"801-631-5368",null,null,null,null,"Quinn Street",13258233522,null,"L/M"]
[null,"2014-03-26","Quade, Konrad",null,"775-815-2375",null,null,null,null,"Quinn Street",13264399122,null,"Speck House in Nev."]
[null,"2014-03-26","Bryner, Don",null,"801-265-8022",null,null,null,null,"Quinn Street",13258653122,null,"13 Windows 1 PD",null,"2014-04-02","Darren"]
[null,"2014-03-24","Bateman, Debi",null,"801-561-0396",null,null,null,null,"Website",null,null,"Cant leave mess."]
[null,"2014-03-27","Taylor, John",null,"801-563-8018",null,null,null,null,"KNRS Radio",null,null,"14 Windows $98. Mo.",null,"2014-04-02","Darren"]
[null,"2014-03-27","Stappleton, Janet",null,"801-661-2507",null,null,null,null,"Value Pages",null,null,"Basement Windows",null,"2014-04-02","Steve"]
[null,"2014-03-27","Stultz, Dave",null,"435-843-0969",null,null,null,null,"Milgard","Jake",null,"Pet Door w/Pet"]
[null,"2014-03-27","Simpson, Daniel",null,"801-201-0758",null,null,null,null,"Website",null,null,"14 Windows",null,"2014-03-31","Darren"]
[null,"2014-03-27","Mossop, Carrie",null,"801-580-7259",null,null,null,null,"Value Pages",null,null,"Back of home",null,"2014-04-01","Jeremy"]
[null,"2014-03-28","Paulsen Debi",null,"801-651-2557",null,null,null,null,"Website",null,null,"Glass replaced so she can sell home",null,"2014-04-01","Tom"]
[null,"2014-03-28","Bisiar, Kevin",null,"801-916-8100",null,null,null,null,"Website",null,null,"6 Basement Windows",null,"2014-04-01","Steve"]
[null,"2014-03-28","Ford, Debbie",null,"801-607-5521",null,null,null,null,"Home Town Values",null,null,"Pet Door",null,"2014-04-02","Tom"]
[null,"2014-03-28","Wilcox, John",null,"801-292-5475",null,null,null,null,"Quinn Street",13284741822,null,"31 Winodws",null,"2014-03-31","Darren"]
[null,"2014-03-28","LaBach, Karen",null,"801-232-8754",null,null,null,null,"Milgard",574888935,null,"1 Window",null,"2014-04-02","Jeremy"]
[null,"2014-03-28","Rizzardi, Barbara",null,"801-201-2558",null,null,null,null,"Angie's List",null,null,"Patio door/pet door",1,"2014-04-04","Tom"]
[null,"2014-03-28","Nelsen, Sheri",null,"801-615-6450",null,null,null,null,"Quinn Street",13288962022,null,"L/M",1]
[null,"2014-03-28","Farnsworth, Michelle",null,"801-898-8128",null,null,null,null,"Milgard",574787906,null,"L/M"]
[null,"2014-03-28","Ryan, Jarom",null,"801-448-8096",null,null,null,null,"Milgard",574915600,null,"L/M",1]
[null,"2014-03-28","Martin, Jeff",null,"801-403-4626",null,null,null,null,"Quinn Street",4637811723,null,"L/M",1]
[null,"2014-03-28","Larson, Kari",null,"801-244-0058",null,null,null,null,"Quinn Street",13277755222,null,"L/M",1]
[null,"2014-03-28","Miklavcic, Jimmy",null,"801-205-5103",null,null,null,null,"Milgard",57508513,null,"wants to install himself."]
[null,"2014-03-28","Scott, Chris",null,"801-931-8908",null,null,null,null,"Milgard",575145633,null,"L/M",1]
[null,"2014-03-31","Laforett, Suzanne",null,"801-680-3286",null,null,null,null,"Quinn Street",13318661022,null,"Windows",1,"2014-04-02","Steve"]
[null,"2014-03-31","Franson, Colin",null,"801-631-4567",null,null,null,null,"Website",null,null,"Glass replaced so she can sell home",null,"2014-04-02","Tom"]
[null,"2014-03-31","Higginson, Kraig",null,"801-427-1111",null,null,null,null,"Quinn Street",13315208222,null,"mail box full",1]
[null,"2014-03-31","Mineer, Brent",null,"707-337-8000",null,null,null,null,"Quinn Street",13313425722,null,"Placed order",1]
[null,"2014-03-31","Schnauzer, John",null,"no phone",null,null,null,null,"Milgard",575158877,null,"No phone dead",1]
[null,"2014-03-31","Sargent, Anita",null,"801-599-2108",null,null,null,null,"Quinn Street",13317396922,null,"Dead",1]
[null,"2014-03-31","Hinchman, Jennifer",null,"801-583-8227",null,null,null,null,"Milgard",575166855,null,"Old 100 year old windows",41731,"2014-04-02","Darren"]
[null,"2014-03-31","Mica",null,"801-814-3270",null,null,null,null,"Website",null,null,"Quoted3 windows"]
[null,"2014-03-31","Smith, Gordan",null,"801-243-7533",null,null,null,null,"Quinn Street",1057918709,null,"L/M"]
[null,"2014-03-31","Gardner, Brent",null,"435-231-1066",null,null,null,null,"Quinn Street",13320744022,null,"L/M"]
[null,"2001-04-12","Nathan","Dudly","333-333-3333","333 Three Street","Three",33333,"three33@gmail.com","Angie List-Online",null,null,null,"1,2",null,"Darren","Yes"]

{"sheet":"April 2014","index":4,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["2014-04-01","to","2014-04-30","_","_","_","_","_"]
["Lead Sources",null,"CallSource Numbers",null,"Salesman","Monthly Leads","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",null,5,null,"Darren",0,0,null,0]
["Customer Referral",null,0,null,"Dave",0,0,null,0]
["ESPN700 Radio-Broadcast",null,1,null,"Jeremy",0,0,null,0]
["Facebook-Social Media",null,0,null,"Katri",0,0,null,0]
["Google Search Call In",null,0,null,"Office",0,0,null,0]
["Home Show",null,0,null,"Steve",0,0,null,0]
["HomeTown Values Magazine-Print",null,84,null,"Tom"]
["K-Bull Radio",null,0]
["KDOJ Oldies Radio-Broadcast",null,6]
["KNRS Radio-Broadcast",null,7]
["KSL Local Listing-Print",null,10]
["Oldies KDOJ",null,0]
["Pepperwood HOA-Direct Mail",null,0]
["Pet Magazine",null,0]
["PPC-Online",null,12]
["TBD-TBD",null,8]
["Value Pages-Direct Mail",null,50]
["Website-Website",null,0]
["Yelp-Online",null,0]
["Other",null,0]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]

{"sheet":"May 2014","index":5,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["2014-05-01","to","2014-05-31",null,0]
["Lead Sources",null,"CallSource Numbers",null,"Salesman","Monthly Leads","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",null,null,null,"Darren"]
["Customer Referral",null,null,null,"Dave"]
["ESPN700 Radio-Broadcast",null,null,null,"Jeremy"]
["Facebook-Social Media",null,null,null,"Katri"]
["Google Search Call In",null,null,null,"Office"]
["Home Show",null,null,null,"Steve"]
["HomeTown Values Magazine-Print",null,null,null,"Tom"]
["K-Bull Radio"]
["KDOJ Oldies Radio-Broadcast"]
["KNRS Radio-Broadcast"]
["KSL Local Listing-Print"]
["Oldies KDOJ"]
["Pepperwood HOA-Direct Mail"]
["Pet Magazine"]
["PPC-Online"]
["TBD-TBD"]
["Value Pages-Direct Mail"]
["Website-Website"]
["Yelp-Online"]
["Other"]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]

{"sheet":"June 2014","index":6,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["2014-06-01","to","2014-06-30",null,0]
["Referral Sources",null,"CallSource Numbers",null,"Salesman","Monthly Referrals","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",null,null,null,"Darren"]
["Customer Referral",null,null,null,"Dave"]
["ESPN700 Radio-Broadcast",null,null,null,"Jeremy"]
["Facebook-Social Media",null,null,null,"Katri"]
["Google Search Call In",null,null,null,"Office"]
["Home Show",null,null,null,"Steve"]
["HomeTown Values Magazine-Print",null,null,null,"Tom"]
["K-Bull Radio"]
["KDOJ Oldies Radio-Broadcast"]
["KNRS Radio-Broadcast"]
["KSL Local Listing-Print"]
["Oldies KDOJ"]
["Pepperwood HOA-Direct Mail"]
["Pet Magazine"]
["PPC-Online"]
["TBD-TBD"]
["Value Pages-Direct Mail"]
["Website-Website"]
["Yelp-Online"]
["Other"]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]

{"sheet":"July 2014","index":7,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["2014-07-01","to","2014-07-31",null,0]
["Referral Sources",null,"CallSource Numbers",null,"Salesman","Monthly Referrals","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",null,"Darren",null,"Darren"]
["Customer Referral",null,"Dave",null,"Dave"]
["ESPN700 Radio-Broadcast",null,"Jeremy",null,"Jeremy"]
["Facebook-Social Media",null,"Office",null,"Katri"]
["Google Search Call In",null,"Steve",null,"Office"]
["Home Show",null,"Tom",null,"Steve"]
["HomeTown Values Magazine-Print",null,null,null,"Tom"]
["K-Bull Radio"]
["KDOJ Oldies Radio-Broadcast"]
["KNRS Radio-Broadcast"]
["KSL Local Listing-Print"]
["Oldies KDOJ"]
["Pepperwood HOA-Direct Mail"]
["Pet Magazine"]
["PPC-Online"]
["TBD-TBD"]
["Value Pages-Direct Mail"]
["Website-Website"]
["Yelp-Online"]
["Other"]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]

{"sheet":"Aug 2014","index":8,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["2014-08-01","to","2014-08-31",null,0]
["Referral Sources",null,"CallSource Numbers",null,"Salesman","Monthly Referrals","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",null,null,null,"Darren"]
["Customer Referral",null,null,null,"Dave"]
["ESPN700 Radio-Broadcast",null,null,null,"Jeremy"]
["Facebook-Social Media",null,null,null,"Katri"]
["Google Search Call In",null,null,null,"Office"]
["Home Show",null,null,null,"Steve"]
["HomeTown Values Magazine-Print",null,null,null,"Tom"]
["K-Bull Radio"]
["KDOJ Oldies Radio-Broadcast"]
["KNRS Radio-Broadcast"]
["KSL Local Listing-Print"]
["Oldies KDOJ"]
["Pepperwood HOA-Direct Mail"]
["Pet Magazine"]
["PPC-Online"]
["TBD-TBD"]
["Value Pages-Direct Mail"]
["Website-Website"]
["Yelp-Online"]
["Other"]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]

{"sheet":"Sept 2014","index":9,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["2014-09-01","to","2014-09-30",null,0]
["Referral Sources",null,"CallSource Numbers",null,"Salesman","Monthly Referrals","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",null,null,null,"Darren"]
["Customer Referral",null,null,null,"Dave"]
["ESPN700 Radio-Broadcast",null,null,null,"Jeremy"]
["Facebook-Social Media",null,null,null,"Katri"]
["Google Search Call In",null,null,null,"Office"]
["Home Show",null,null,null,"Steve"]
["HomeTown Values Magazine-Print",null,null,null,"Tom"]
["K-Bull Radio"]
["KDOJ Oldies Radio-Broadcast"]
["KNRS Radio-Broadcast"]
["KSL Local Listing-Print"]
["Oldies KDOJ"]
["Pepperwood HOA-Direct Mail"]
["Pet Magazine"]
["PPC-Online"]
["TBD-TBD"]
["Value Pages-Direct Mail"]
["Website-Website"]
["Yelp-Online"]
["Other"]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]

{"sheet":"Oct 2014","index":10,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[13,6,19,11]]}
["2014-10-01","to","2014-10-31",null,0]
["Referral Sources",null,"CallSource Numbers",null,"Salesman","Monthly Referrals","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",null,null,null,"Darren"]
["Customer Referral",null,null,null,"Dave"]
["ESPN700 Radio-Broadcast",null,null,null,"Jeremy"]
["Facebook-Social Media",null,null,null,"Katri"]
["Google Search Call In",null,null,null,"Office"]
["Home Show",null,null,null,"Steve"]
["HomeTown Values Magazine-Print",null,null,null,"Tom"]
["K-Bull Radio"]
["KDOJ Oldies Radio-Broadcast"]
["KNRS Radio-Broadcast"]
["KSL Local Listing-Print"]
["Oldies KDOJ",null,null,null,null,"Instructions:"," In order to open the Lead Information Form,  double click on a the cell that you want to edit or  the cell where you want to create a new lead.  If you accidentally click on a cell outside of the lead information area or on a cell that you did not wish to edit, press cancel. If you do choose to edit inforatmion in the Lead Information form, keep the following in mind in order for the program to run properly: \"Email #1,2,3\" must always have 1,2,3 format.  The only vaild values are \"1\" \"1,2\" or \"1,2,3\".  (Do not put a comma after the last number.)  Lead Source and Salesman Assigned are picked from a drop down box. Do not choose or write anything in this area that is not found in this drop down box.  The on ly valid entries for \"Phone Quote Only\" column are \"Yes\" or \"No\".  Ignore the \"ID\" column.  Do not change the \"Referral Sources\" column in the top right-hand corner nor the \"Salesman\" summary columns.  If you wish to edit this information, change it on the \"Info\" sheet.  "]
["Pepperwood HOA-Direct Mail"]
["Pet Magazine"]
["PPC-Online"]
["TBD-TBD"]
["Value Pages-Direct Mail"]
["Website-Website"]
["Yelp-Online"]
["Other"]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]

{"sheet":"Nov 2014","index":11,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["2014-11-01","to","2014-11-30",null,0]
["Referral Sources",null,"CallSource Numbers",null,"Salesman","Monthly Referrals","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",null,null,null,"Darren"]
["Customer Referral",null,null,null,"Dave"]
["ESPN700 Radio-Broadcast",null,null,null,"Jeremy"]
["Facebook-Social Media",null,null,null,"Katri"]
["Google Search Call In",null,null,null,"Office"]
["Home Show",null,null,null,"Steve"]
["HomeTown Values Magazine-Print",null,null,null,"Tom"]
["K-Bull Radio"]
["KDOJ Oldies Radio-Broadcast"]
["KNRS Radio-Broadcast"]
["KSL Local Listing-Print"]
["Oldies KDOJ"]
["Pepperwood HOA-Direct Mail"]
["Pet Magazine"]
["PPC-Online"]
["TBD-TBD"]
["Value Pages-Direct Mail"]
["Website-Website"]
["Yelp-Online"]
["Other"]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]

{"sheet":"Dec 2014","index":12,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["2014-12-01","to","2014-12-31",null,0]
["Referral Sources",null,"CallSource Numbers",null,"Salesman","Monthly Referrals","Closed","Closing Ratio","Gross Sales"]
["Angie List-Online",null,null,null,"Darren"]
["Customer Referral",null,null,null,"Dave"]
["ESPN700 Radio-Broadcast",null,null,null,"Jeremy"]
["Facebook-Social Media",null,null,null,"Katri"]
["Google Search Call In",null,null,null,"Office"]
["Home Show",null,null,null,"Steve"]
["HomeTown Values Magazine-Print",null,null,null,"Tom"]
["K-Bull Radio"]
["KDOJ Oldies Radio-Broadcast"]
["KNRS Radio-Broadcast"]
["KSL Local Listing-Print"]
["Oldies KDOJ"]
["Pepperwood HOA-Direct Mail"]
["Pet Magazine"]
["PPC-Online"]
["TBD-TBD"]
["Value Pages-Direct Mail"]
["Website-Website"]
["Yelp-Online"]
["Other"]
[]
["ID","Date","First Name","Last Name","Phone #","Address","City","Zip","Email","Lead Source","Lead Id#","Follow Up Calls","Notes:","Email #1,2,3","Appointment Date","Salesman Assigned","Phone Quote Only","Sold Date","Amount"]