module 11 integrating macros with your reports

138
Jan Feb Mar Gross Revenue 1.00% Sales 137000000 138370000 139753700 Shipping 26700000 26967000 27236670 Gross Revenue 163700000 165337000 166990370 Cost of Goods Sold Goods 76500000 77265000 78037650 Freight 1300000 1313000 1326130 Miscellaneous 500000 505000 510050 Cost of Goods Total 78300000 79083000 79873830 Gross Profit 85400000 86254000 87116540 Expenses Advertising 18400000 18584000 18769840 Electricity 175000 176750 178520 Food 200000 202000 204020 Heat 162000 163620 165260 Insurance 200000 202000 204020 Interest 3800000 3838000 3876380 Legal Services 300000 303000 306030 Office Supplies 700000 707000 714070 Rent 2300000 2323000 2346230 Salaries 21600000 21816000 22034160 Taxes 1100000 1111000 1122110 Telephone 1300000 1313000 1326130 Training 500000 505000 510050 Travel 900000 909000 918090 Utilities 300000 303000 306030 Water 165000 166650 168320 Total Expenses 52102000 52623020 53149260 Net Profit 33298000 33630980 33967280 Module 11 Assignment 1 - Recording S

Upload: faisal-tariq

Post on 02-Feb-2016

214 views

Category:

Documents


0 download

DESCRIPTION

Macro Integration in Excel based report generation

TRANSCRIPT

Page 1: Module 11 Integrating Macros With Your Reports

Jan Feb Mar 1st Q

Gross Revenue 1.00%Sales 137000000 138370000 139753700 415123700Shipping 26700000 26967000 27236670 80903670

Gross Revenue 163700000 165337000 166990370 496027370

Cost of Goods SoldGoods 76500000 77265000 78037650 231802650Freight 1300000 1313000 1326130 3939130Miscellaneous 500000 505000 510050 1515050

Cost of Goods Total 78300000 79083000 79873830 237256830

Gross Profit 85400000 86254000 87116540 258770540

ExpensesAdvertising 18400000 18584000 18769840 55753840Electricity 175000 176750 178520 530270Food 200000 202000 204020 606020Heat 162000 163620 165260 490880Insurance 200000 202000 204020 606020Interest 3800000 3838000 3876380 11514380Legal Services 300000 303000 306030 909030Office Supplies 700000 707000 714070 2121070Rent 2300000 2323000 2346230 6969230Salaries 21600000 21816000 22034160 65450160Taxes 1100000 1111000 1122110 3333110Telephone 1300000 1313000 1326130 3939130Training 500000 505000 510050 1515050Travel 900000 909000 918090 2727090Utilities 300000 303000 306030 909030Water 165000 166650 168320 499970

Total Expenses 52102000 52623020 53149260 157874280

Net Profit 33298000 33630980 33967280 100896260

Module 11 Assignment 1 - Recording Simple Macro

Page 2: Module 11 Integrating Macros With Your Reports

Apr May Jun 2nd Q Jul3.00% 2.00%

143946310 148264700 152712640 444923650 15576689028053770 28895380 29762240 86711390 30357480

172000080 177160080 182474880 531635040 186124370

80378780 82790140 85273840 248442760 869793201365910 1406890 1449100 4221900 1478080

525350 541110 557340 1623800 56849082270040 84738140 87280280 254288460 8902589089730040 92421940 95194600 277346580 97098480

19332940 19912930 20510320 59756190 20920530183880 189400 195080 568360 198980210140 216440 222930 649510 227390170220 175330 180590 526140 184200210140 216440 222930 649510 227390

3992670 4112450 4235820 12340940 4320540315210 324670 334410 974290 341100735490 757550 780280 2273320 795890

2416620 2489120 2563790 7469530 261507022695180 23376040 24077320 70148540 24558870

1155770 1190440 1226150 3572360 12506701365910 1406890 1449100 4221900 1478080

525350 541110 557340 1623800 568490945630 974000 1003220 2922850 1023280315210 324670 334410 974290 341100173370 178570 183930 535870 187610

54743730 56386050 58077620 169207400 59239190

34986310 36035890 37116980 108139180 37859290

Page 3: Module 11 Integrating Macros With Your Reports

Aug Sep 3rd Q Oct Nov Dec3.00%

158882230 162059870 476708990 166921670 171929320 17708720030964630 31583920 92906030 32531440 33507380 34512600

189846860 193643790 569615020 199453110 205436700 211599800

88718910 90493290 266191520 93208090 96004330 988844601507640 1537790 4523510 1583920 1631440 1680380

579860 591460 1739810 609200 627480 64630090806410 92622540 272454840 95401210 98263250 10121114099040450 101021250 297160180 104051900 107173450 110388660

21338940 21765720 64025190 22418690 23091250 23783990202960 207020 608960 213230 219630 226220231940 236580 695910 243680 250990 258520187880 191640 563720 197390 203310 209410231940 236580 695910 243680 250990 258520

4406950 4495090 13222580 4629940 4768840 4911910347920 354880 1043900 365530 376500 387800811810 828050 2435750 852890 878480 904830

2667370 2720720 8003160 2802340 2886410 297300025050050 25551050 75159970 26317580 27107110 27920320

1275680 1301190 3827540 1340230 1380440 14218501507640 1537790 4523510 1583920 1631440 1680380

579860 591460 1739810 609200 627480 6463001043750 1064630 3131660 1096570 1129470 1163350

347920 354880 1043900 365530 376500 387800191360 195190 574160 201050 207080 213290

60423970 61632470 181295630 63481450 65385920 67347490

38616480 39388780 115864550 40570450 41787530 43041170

Page 4: Module 11 Integrating Macros With Your Reports

4th Q TOTAL

515938190 1852694530100551420 361072510616489610 2213767040

288096880 10345338104895740 175802801882980 6761640

294875600 1058875730321614010 1154891310

69293930 248829150659080 2366670753190 2704630610110 2190850753190 2704630

14310690 513885901129830 40570502636200 94663408661750 31103670

81345010 2921036804142520 148755304895740 175802801882980 67616403389390 121709901129830 4057050

621420 2231420196214860 704592170

125399150 450299140

Page 5: Module 11 Integrating Macros With Your Reports

Name: Willett, Patricia ECompany: Centennial Pueblo - Central LLC

Business Address: 3673 Parker Blvd. Ste. 100City, State, Zip Pueblo, CO 81008Office Phone: (719) 586-8701 , (877) 457-0760

Website: www.willp.comName: Smith, Dee

Company: Cameron Banker Residential BrokerageBusiness Address: 2821 S. Parker Road, Suite 115

City, State, Zip Aurora, CO 80014Office Phone: (313) 340-0242

Website: www.smitd.comName: Anderson, David S

Company: Centennial 100, Inc.Business Address: 710 Kipling St. Ste.110

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444 , (877) 537-0002

Website: www.anded.comName: MacDonald, Mary B

Company: American Dream Home RealtyBusiness Address: 11152 Huron Street, #207

City, State, Zip Westminster, CO 80234Office Phone: (313) 254-5925

Website: www.macdm.comName: Haban, Eileen

Company: Centennial AllianceBusiness Address: 5440 Ward Road, Suite 110

City, State, Zip Arvada, CO 80002Office Phone: (313) 456-2113 , (877) 211-5716

Website: www.habae.comName: Beals, Ronnie V

Company: Cameron Banker Residential BrokerageBusiness Address: 2821 S. Parker Road, Suite 115

City, State, Zip Aurora, CO 80014Office Phone: (313) 750-4500 ext. 1362, (877) 711-0636

Website: www.bealr.comName: Richards, Kent

Company: New Century Realty, Inc.Business Address: 9035 Wadsworth # 4000

City, State, Zip Westminster, CO 80021Office Phone: (313) 422-5200 , (877) 425-5400

Website: www.richk.comName: J, Ronald R

Company: Centennial First AssociatesBusiness Address: 4703 Boardwalk Dr.

City, State, Zip Fort Collins, CO 80525Office Phone: (970) 206-8262 , (877) 571-0703

Website: www.jrr.comName: Miller, Mimi A

Company: Cameron Banker Residential Brokerage

Page 6: Module 11 Integrating Macros With Your Reports

Business Address: 200-141 Union Blvd.City, State, Zip Lakewood, CO 80228Office Phone: (313) 914-4113 , (877) 857-4663

Website: www.millm.comName: Thoeming, Jim

Company: Wedgwood & AssociatesBusiness Address: 6279 W. 38th Ave., Suite #5

City, State, Zip Wheat Ridge, CO 80033Office Phone: (313) 422-1826

Website: www.thoej.comName: Kifer, Jan

Company: Mile Hi Realty ExecutivesBusiness Address: 7120 East County Line Road, #203

City, State, Zip Highlands Ranch, CO 80126Office Phone: (313) 850-7715 , (877) 243-3368

Website: www.kifej.comName: Tran, May

Company: Centennial NorthwestBusiness Address: 12000 Pecos St. #160

City, State, Zip Westminster, CO 80234Office Phone: (313) 255-4325 , (877) 419-3420

Website: www.tranm.comName: Utschig, Julie A

Company: Centennial 100, Inc.Business Address: 710 Kipling St., Suite 100

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444 , (877) 537-0002

Website: www.utscj.comName: Schuttenberg, Shel

Company: The Kentwood Company at Cherry Creek, LLCBusiness Address: 44 Cook Street, 9th Floor

City, State, Zip Denver, CO 80206Office Phone: (313) 336-0353

Website: www.schus.comName: Clark, Cornelious

Company: Centennial AllianceBusiness Address: 5440 Ward Rd.

City, State, Zip Arvada, CO 80002Office Phone: (313) 456-2141 , (877) 887-5184

Website: www.clarc.comName: Repp, Jane

Company: Keller Williams Preferred RealtyBusiness Address: 1401 Bridge St.

City, State, Zip Brighton, CO 80601Office Phone: (313) 478-8037 , (888) 346-3522

Website: www.reppj.comName: Mattys, Susannah

Company: Prudential Colorado Real EstateBusiness Address: 2305 E. Arapahoe Road, #145

City, State, Zip Littleton, CO 80122

Page 7: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 797-1901Website: www.matts.com

Name: Zeller, KellyCompany: Cameron Banker Residential Brokerage

Business Address: 3595 S. Teller St. #200City, State, Zip Lakewood, CO 80235Office Phone: (313) 987-4988 , (877) 401-0856

Website: www.zellk.comName: Carithers, Kay

Company: Maierhofer & Associates/Metro BrokersBusiness Address: 6025 South Quebec Street, Suite 100

City, State, Zip Centennial, CO 80111Office Phone: (313) 740-8100

Website: www.carik.comName: Henry, Melanie

Company: Metro Broker AmeriRealtyBusiness Address: 3835 W. 10th Street, Suite 100E

City, State, Zip Greeley, CO 80634Office Phone: (970) 351-0405 ext. `

Website: www.henrm.comName: Hay, Sally

Company: Centennial Professionals, Inc.Business Address: 1745 Shea Center Dr. #110

City, State, Zip Highlands Ranch, CO 80129Office Phone: (313) 638-1497 , (877) 533-6837

Website: www.hays.comName: Mason, Beth

Company: Centennial NorthwestBusiness Address: 12000 Pecos St. #160

City, State, Zip Westminster, CO 80234Office Phone: (313) 457-4800 , (877) 433-0043

Website: www.masob.comName: Cucchi, Anne

Company: Centennial Professionals, Inc.Business Address: 390 Union Blvd

City, State, Zip Lakewood, CO 80028Office Phone: (313) 985-4555

Website: www.cucca.comName: Murphy, Rose Marie

Company: Home Real EstateBusiness Address: 1599 Walnut Drive

City, State, Zip Brighton, CO 80601Office Phone: (313) 252-7700

Website: www.murpr.comName: Coburn, Sue

Company: Centennial Properties, Inc.Business Address: 3215 Austin Bluffs Parkway

City, State, Zip Colorado Springs, CO 80918Office Phone: (719) 637-7227 , (877) 243-8181

Website: www.cobus.com

Page 8: Module 11 Integrating Macros With Your Reports

Name: Serafini, Robin JCompany: Sage Realty

Business Address: 6855 Omaha BoulevardCity, State, Zip Colorado Springs, CO 80916Office Phone: (719) 477-1180 , (877) 599-7242

Website: www.serar.comName: Clark, Laurie

Company: Cameron Banker Residential BrokerageBusiness Address: 12303 Airport Way, #270

City, State, Zip Broomfield, CO 80021Office Phone: (313) 449-5000

Website: www.clarl.comName: Campbell, Jancy

Company: Centennial 100, Inc.Business Address: 710 Kipling Street, Suite 110

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444

Website: www.campj.comName: Lynch, Peggy

Company: Cameron Banker ResidentialBusiness Address: 451 - 21st Avenue

City, State, Zip Longmont, CO 80501Office Phone: (313) 772-7478 ext. 5957, (866) 699-0876 ext. 5957

Website: www.lyncp.comName: Doud, Pat

Company: Keller Williams Realty ProfessionalsBusiness Address: 9191 Sheridan Blvd. #310

City, State, Zip Westminster, CO 80031Office Phone: (313) 579-8692

Website: www.doudp.comName: Hickerson, Judy

Company: Centennial Pueblo West, Inc.Business Address: 19 E. Abarr Drive

City, State, Zip Pueblo West, CO 81007Office Phone: (719) 547-1756 , (866) 546-3250

Website: www.hickj.comName: Brownlee, Lloyd J

Company: Centennial of Longmont Inc.Business Address: 2350 17th Avenue

City, State, Zip Longmont, CO 80503Office Phone: (313) 772-3811 ext. 146, (877) 228-0995

Website: www.browl.comName: Kos, Christine A

Company: Mock RealtyBusiness Address: 825 S. Broadway

City, State, Zip Boulder, CO 80303Office Phone: (313) 497-0625 , (877) 447-4250

Website: www.kosc.comName: Broderick, Deborah L

Company: Centennial Horizons Group @ Interlocken

Page 9: Module 11 Integrating Macros With Your Reports

Business Address: 11001 W. 120th Avenue #240City, State, Zip Broomfield, CO 80021Office Phone: (313) 456-8361 ext. 6505, (888) 851-6250

Website: www.brodd.comName: Barnard, Elaine J

Company: Rusinak Real EstateBusiness Address: 7150 N. Academy Blvd.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 590-6108 , (877) 727-7820

Website: www.barne.comName: Blake, Miriam N

Company: Centennial of Longmont, IncBusiness Address: 2350 17th Ave.

City, State, Zip Longmont, CO 80503Office Phone: (313) 772-3800 ext. 123, (877) 228-0995

Website: www.blakm.comName: Christensen, John H

Company: Centennial Professionals, Inc.Business Address: 8760 S. Garland Court

City, State, Zip Littleton, CO 80128Office Phone: (313) 972-2555

Website: www.chrij.comName: Ricciardi, Margene

Company: Classic Advantage RealtyBusiness Address: 102 E. Girard Avenue #C-150

City, State, Zip Denver, CO 80231Office Phone: (313) 756-4161

Website: www.riccm.comName: Browning, Jennifer D

Company: Cameron Banker Residential BrokerageBusiness Address: 1202 Bergen Parkway

City, State, Zip Evergreen, CO 80439Office Phone: (313) 674-2418 , (877) 574-6667

Website: www.browj.comName: Hill, Roger

Company: United Property BrokersBusiness Address: 16731 E. Iliff Avenue, #1100

City, State, Zip Aurora, CO 80013Office Phone: (313) 671-9311 , (877) 370-1497

Website: www.hillr.comName: Bettin, Janene

Company: Cameron Banker Residential BrokerageBusiness Address: 3300 28th St.

City, State, Zip Boulder, CO 80301Office Phone: (313) 441-2436 , (877) 654-4788

Website: www.bettj.comName: Jarrell, L Coleman

Company: The Bashor Connection Real Estate ConsultantsBusiness Address: 1020 - G Ken Pratt Blvd., Suite G

City, State, Zip Longmont, CO 80501

Page 10: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 651-6334 , (866) 651-6334Website: www.jarrl.com

Name: Schwartz, Kennard RCompany: Millennium Dinkel & Associates

Business Address: 5445 Montebello LaneCity, State, Zip Colorado Springs, CO 80918Office Phone: (719) 599-4445

Website: www.schwk.comName: Maier, Amy

Company: Centennial ProfessionalsBusiness Address: 390 Union

City, State, Zip Lakewood, CO 80028Office Phone: (313) 423-5220

Website: www.maiea.comName: Benson, Ariel

Company: Dixie Trimble Realty CompanyBusiness Address: 2038 Gaylord St.

City, State, Zip Denver, CO 80205Office Phone: (313) 320-4266

Website: www.bensa.comName: Carter, Sherrill

Company: Metro Brokers - Beals & CompanyBusiness Address: 11150 Huron Street, Suite 100

City, State, Zip Northglenn, CO 80234Office Phone: (313) 452-5853 ext. 352

Website: www.carts.comName: White, Judy E

Company: Keller Williams RealtyBusiness Address: 3880 N. Grant Ave. Ste. 140

City, State, Zip Loveland, CO 80537Office Phone: (970) 278-4127

Website: www.whitj.comName: Harris, John

Company: Realty Executives MetroNorthBusiness Address: 20 W. 84th Avenue, Suite 220

City, State, Zip Denver, CO 80260Office Phone: (313) 429-1234

Website: www.harrj.comName: Trimble, Dixie Lee

Company: Centennial Masters Inc.Business Address: 6400 S. FiddlersGreen Circle #108

City, State, Zip Englewood, CO 80111Office Phone: (313) 771-9400 ext. 5207, (877) 766-1669

Website: www.trimd.comName: Wilson, Joyce A

Company: The Kentwood CompanyBusiness Address: 5690 D.T.C. Blvd

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 773-3399 , (877) 723-7653

Website: www.wilsj.com

Page 11: Module 11 Integrating Macros With Your Reports

Name: Danzl, James JCompany: Metro Brokers - Priority Properties, Inc

Business Address: 6377 S. Revere ParkwayCity, State, Zip Centennial, CO 80111Office Phone: (313) 799-8100 ext. 222, (877) 799-8100

Website: www.danzj.comName: Cunningham, Carrie A

Company: Centennial Pueblo West Inc.Business Address: 19 E. Abarr Drive

City, State, Zip Pueblo West, CO 81007Office Phone: (719) 547-1739 ext. 1739, (877) 699-1716

Website: www.cunnc.comName: Smith, Karon L

Company: Leeper & AssociatesBusiness Address: 10157 Owens Drive

City, State, Zip Westminster, CO 80021Office Phone: (313) 469-6723 , (877) 626-1419

Website: www.smitk.comName: Parker, Carlyn L

Company: Centennial AllianceBusiness Address: 10375 Park Meadows, Suite 100

City, State, Zip Lone Tree, CO 80124Office Phone: (313) 850-1916 , (866) 820-6457

Website: www.parkc.comName: King, Larry J

Company: Centennial Properties, IncBusiness Address: 2630 Tenderfoot Hill St.

City, State, Zip Colorado Springs, CO 80901Office Phone: (719) 576-5000

Website: www.kingl.comName: Ward, Suzanne M

Company: Cameron BankerBusiness Address: 101 University Blvd. #100

City, State, Zip Denver, CO 80206Office Phone: (313) 320-5733 , (877) 856-8355

Website: www.wards.comName: Segreti, Margaret

Company: A.H. Leffler & Assoc., LLCBusiness Address: 628 Main

City, State, Zip Windsor, CO 80550Office Phone: (970) 353-6088

Website: www.segrm.comName: Barros, Christina de

Company: Agi RealtyBusiness Address: 4020 Delcon Court

City, State, Zip Loveland, CO 80538Office Phone: (970) 581-9667

Website: www.barrc.comName: Arnold, Darlene Joyce

Company: ERA Shields Real Estate

Page 12: Module 11 Integrating Macros With Your Reports

Business Address: 5475 Tech Center Drive, Suite 300City, State, Zip Colorado Springs, CO 80919Office Phone: (719) 593-1000 , (877) 888-8208

Website: www.arnod.comName: Ranes, Kim

Company: Centennial Horizons GroupBusiness Address: 6343 W. 120th Ave., Ste. 100

City, State, Zip Broomfield, CO 80020Office Phone: (313) 469-6723 , (877) 626-1419

Website: www.ranek.comName: McBride, Nancy

Company: Anne Hunter & Co. Metro BrokersBusiness Address: 355 Union Blvd., Suite 10

City, State, Zip Lakewood, CO 80228Office Phone: (313) 987-0404 ext. 303

Website: www.mcbrn.comName: French, Vicki

Company: Cameron Banker Residential BrokerageBusiness Address: 2553 S. Colorado Blvd. Unit 106

City, State, Zip Denver, CO 80222Office Phone: (313) 302-4600

Website: www.frenv.comName: Newton, Kay

Company: Centennial Alliance, DTCBusiness Address: 5350 S Roslyn Street, Suite 150

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 773-3885 ext. 1230

Website: www.newtk.comName: Russel, Sheila

Company: Home Real EstateBusiness Address: 13111 E. Briarwood

City, State, Zip Centennial, CO 80112Office Phone: (313) 910-9778 , (866) 650-9040

Website: www.russs.comName: Cramer, Steve

Company: Marx Real Estate Corp.Business Address: 1295 W. Littleton Blvd.

City, State, Zip Littleton, CO 80120Office Phone: (313) 761-4006

Website: www.crams.comName: Whatley, Walt F

Company: A Better Way Realty, LLCBusiness Address: 1777 South Harrison #911

City, State, Zip Denver, CO 80210Office Phone: (313) 759-2222 , (877) 559-1884

Website: www.whatw.comName: Smith, Jim

Company: Cameron Banker Residential BrokerageBusiness Address: 8490 E. Crescent Pkwy. Ste. 100

City, State, Zip Greenwood Village, CO 80111

Page 13: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 409-6319 , (877) 856-9004Website: www.smitj.com

Name: DiVito, JoeCompany: Brokers West Real Estate & Development

Business Address: 8101 E. Prentice Avenue, Suite 815City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 956-7940

Website: www.divij.comName: Belhumeur, Gary

Company: Centennial AllianceBusiness Address: 10375 Park Meadows Drive, Suite 100

City, State, Zip Lone Tree, CO 80124Office Phone: Pager

Website: www.belhg.comName: Leffler, Ann Harding

Company: Centennial 100, Inc.Business Address: 710 Kipling St. Ste.110

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444 , (877) 537-0002

Website: www.leffa.comName: Leeper, Mike

Company: Keller Williams Preferred RealtyBusiness Address: 1333 W. 120th Ave. Ste. 216

City, State, Zip Westminster, CO 80234Office Phone: (313) 452-3300

Website: www.leepm.comName: Mikoda, Nancy

Company: Centennial Masters, Inc.Business Address: 6400 S Fiddlers Green Cir, Suite 100

City, State, Zip Centennial, CO 80111Office Phone: (313) 483-2325

Website: www.mikon.comName: Stow, Diane

Company: Centennial AllianceBusiness Address: 13770 E. Rice

City, State, Zip Aurora, CO 90026Office Phone: (313) 693-6666

Website: www.stowd.comName: Hunter, Anne

Company: Cameron Banker Commerical NRTBusiness Address: 3300 28th Street

City, State, Zip Boulder, CO 80301Office Phone: (313) 413-2388 , (877) 654-4788

Website: www.hunta.comName: Thatcher, Shirley

Company: Centennial AllianceBusiness Address: 10375 Park Meadows Drive.. Suite 100

City, State, Zip Littleton, CO 80124Office Phone: (313) 796-1298 , (866) 820-6457 ext. 1298

Website: www.thats.com

Page 14: Module 11 Integrating Macros With Your Reports

Name: Salek, DeboraCompany: ReAction Realty

Business Address: 12000 Zuni St.City, State, Zip Westminster, CO 80234Office Phone: (313) 667-3055

Website: www.saled.comName: Monet, Judy

Company: Centennial Horizons GroupBusiness Address: 11001 W. 120th Avenue, Suite 240

City, State, Zip Broomfield, CO 80021Office Phone: (313) 327-6500 ext. 6566, (888) 851-6250 ext. 6566

Website: www.monej.comName: Walton, Ron

Company: Centennial Alliance EvergreenBusiness Address: 30480 Stagecoach Blvd.

City, State, Zip Evergreen, CO 80439Office Phone: (313) 670-6399 , (877) 568-6120

Website: www.waltr.comName: Pierce, Patrice D

Company: Real Estate by Repp, Inc.Business Address: 12000 Suni St.

City, State, Zip Westminster, CO 80234Office Phone: (313) 301-7124

Website: www.pierp.comName: Myers, Billie

Company: Keller Williams Realty DTCBusiness Address: 6300 S. Syracuse Way, #150

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 785-1384

Website: www.myerb.comName: Fast, Mary Marjorie

Company: Cameron Banker Residential BrokerageBusiness Address: 3300 28th Street

City, State, Zip Boulder, CO 80301Office Phone: (313) 449-5000 ext. 380, (877) 654-4788 ext. 380

Website: www.fastm.comName: Lovell, Trudy

Company: Centennial southeast, Inc.Business Address: 8821 East Hampden Avenue, Suite 110

City, State, Zip Denver, CO 80231Office Phone: (313) 759-5400

Website: www.lovet.comName: McDonald, Brian R

Company: ERA Werner Realty, Inc.Business Address: 2099 Highway 50 West, Suite 150

City, State, Zip Pueblo, CO 81008Office Phone: (719) 250-9880

Website: www.mcdob.comName: Linsenbigler, Nancy

Company: Realty Executives Metro North

Page 15: Module 11 Integrating Macros With Your Reports

Business Address: 20 W. 84th Avenue #220City, State, Zip Denver, CO 80260Office Phone: (313) 429-1234 , (877) 843-4663

Website: www.linsn.comName: Phelps, Jane L

Company: Centennial 100, Inc.Business Address: 710 Kipline #110

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444 ext. 264, (877) 537-0002

Website: www.phelj.comName: Christner, Allen B

Company: Centennial Alliance CentralBusiness Address: 1873 S. Bellaire Street, #700

City, State, Zip Denver, CO 80207Office Phone: (313) 759-6647 , (877) 747-7362

Website: www.chria.comName: Novak, Kathryn M

Company: UnknownBusiness Address: Pager

City, State, Zip , COOffice Phone: (313) 420-2121

Website: www.novak.comName: Gipson, Beverly S

Company: Centennial 100, Inc.Business Address: 710 Kipling, #118

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444 , (877) 537-0002

Website: www.gipsb.comName: Donahue, Agi J

Company: Realty Executives Twin PeaksBusiness Address: 630 Coffman Street, Suite B

City, State, Zip Longmont, CO 80501Office Phone: (313) 776-2500 , (877) 776-0013

Website: www.donaa.comName: Trout, Judy

Company: Realty Executives Twin PeaksBusiness Address: 630 Coffman Street, Suite B

City, State, Zip Longmont, CO 80501Office Phone: (313) 651-6959 , (877) 776-0013

Website: www.trouj.comName: Trujillo, Karen L

Company: Centennial AffiliatesBusiness Address: 1019 8th Street

City, State, Zip Golden, CO 80401Office Phone: (313) 759-6676 , (877) 747-7362

Website: www.trujk.comName: Frech, Peter C

Company: Centennial Alliance EvergreenBusiness Address: 30480 Stagecoach Blvd.

City, State, Zip Evergreen, CO 80439

Page 16: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 670-6358 ext. 40, (877) 568-6120Website: www.frecp.com

Name: Yost, RonCompany: Centennial Horizons Group, Inc.

Business Address: 6343 W. 120th AvenueCity, State, Zip Broomfield, CO 80020Office Phone: (313) 460-6721 ext. 6721, (877) 626-1419

Website: www.yostr.comName: Childers, Jeanene Y

Company: Centennial All StarsBusiness Address: 1975 Research Parkway, Suite 150

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 599-7575 , (888) 887-5343

Website: www.chilj.comName: Downie, Alice B

Company: Centennial Properties, Inc.Business Address: 2630 Tenderfoot Hill Street

City, State, Zip Colorado Springs, CO 80906Office Phone: (719) 540-6406 , (877) 325-0466

Website: www.downa.comName: Jennings, Sylvia

Company: Premier Marketing ServicesBusiness Address: 6377 S. Revere Parkway, Suite 400

City, State, Zip Centennial, CO 80111Office Phone: (313) 799-8100 ext. 146, (866) 799-8100 ext. 146

Website: www.jenns.comName: Richardson, Trudy

Company: Centennial AllianceBusiness Address: 10375 Park Meadows Drive, #100

City, State, Zip Littleton, CO 80124Office Phone: (313) 796-1222 , (888) 694-4834

Website: www.richt.comName: Hamilton, Darrell G

Company: Rusinak Real EstateBusiness Address: 7880 N. Academy Blvd.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 590-6102 , (877) 727-7820

Website: www.hamid.comName: Taylor, Darris L

Company: Centennial AllianceBusiness Address: 3000 Youngfield, Ste 350

City, State, Zip Lakewood, CO 80215Office Phone: (313) 202-3076

Website: www.tayld.comName: Wesley, Bettie

Company: Realty Link, Inc.Business Address: 12000 N, Zuni St. Ste. 1

City, State, Zip Westminster, CO 80234Office Phone: (313) 301-7132

Website: www.weslb.com

Page 17: Module 11 Integrating Macros With Your Reports

Name: Hamlin, KarenCompany: Centennial of Cherry Creek, Inc

Business Address: 3773 Chenny Creek North Drive, Suite 801 East ToweCity, State, Zip Denver, CO 80209Office Phone: (313) 331-4529 , (877) 765-7110

Website: www.hamlk.comName: Mallard, Raymond

Company: Cameron Banker Residential BrokerageBusiness Address: 8490 E. Crescent Pkwy. Suite 100

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 409-6134 , (877) 574-8800

Website: www.mallr.comName: Munro, Mark C

Company: Centennial Northwest, Inc.Business Address: 12000 Pecos Street #160

City, State, Zip Westminster, CO 80234Office Phone: (313) 457-4800 , (877) 433-0043

Website: www.munrm.comName: Hale, Carma J

Company: Centennial Masters, IncBusiness Address: 6400 S Fiddlers Green Circle, Suite 100

City, State, Zip Englewood, CO 80111Office Phone: (313) 660-8600 , (866) 204-0998

Website: www.halec.comName: Prickett, Terri

Company: Centennial AllianceBusiness Address: 5440 Ward Rd. Ste. 110

City, State, Zip Arvada, CO 80002Office Phone: (313) 277-0431

Website: www.prict.comName: Hazelwood, Kevin

Company: Keller Williams Front Range Properties LLCBusiness Address: 1690 - 30th Street

City, State, Zip Boulder, CO 80301Office Phone: (313) 440-8080

Website: www.hazek.comName: Bashor, Barb

Company: Centennial AllianceBusiness Address: 5350 S. Roslyn Ste. 150

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 796-1238

Website: www.bashb.comName: Billmayer, Serena

Company: Centennial Alliance BoulderBusiness Address: 4770 Baseline Road, Suite 200

City, State, Zip Boulder, CO 80303Office Phone: (313) 543-3087 , (877) 373-1282 ext. 1193

Website: www.bills.comName: Kempe, Cindy

Company: Bahl Marketing Group MB

Page 18: Module 11 Integrating Macros With Your Reports

Business Address: 1745 Shea Center Drive, #400City, State, Zip Highlands Ranch, CO 80129Office Phone: (733) 344-6644

Website: www.kempc.comName: Bassett, Harold G

Company: Prudential LTM RealtorsBusiness Address: 275 S. Main Street

City, State, Zip Longmont, CO 80501Office Phone: (313) 772-2222 ext. 256

Website: www.bassh.comName: Frazee, Robert S

Company: Centennial Pueblo West, Inc.Business Address: 19 E. Abarr Ave.

City, State, Zip Pueblo West, CO 81007Office Phone: (719) 547-1730 , (877) 699-1716

Website: www.frazr.comName: Weitz, Gerald A

Company: Centennial Mountain BrokersBusiness Address: 1180 Graves Ave.

City, State, Zip Estes Park, CO 80517Office Phone: (970) 586-1000 , (866) 311-1880

Website: www.weitg.comName: Jarrett, Lori

Company: Centennial Alliance Park MeadowsBusiness Address: 10375 Park Meadows Drive

City, State, Zip Lone Tree, CO 80124Office Phone: (313) 850-1844 ext. 269, (866) 820-6457

Website: www.jarrl.comName: Fischer, Bev

Company: Realty Executives Twin PeaksBusiness Address: 630 Coffman Street, Suite B

City, State, Zip Longmont, CO 80501Office Phone: (313) 766-2500 , (877) 776-0013

Website: www.fiscb.comName: Brennan, Linda

Company: Terry Golden RealtorsBusiness Address: PO Box 1433

City, State, Zip Colorado Springs, CO 80901Office Phone: (719) 520-9812

Website: www.brenl.comName: Ryerson, Robert W

Company: Cameron Banker Residential BrokerageBusiness Address: 3300 28th Street

City, State, Zip Boulder, CO 80301Office Phone: (313) 449-5000 , (877) 654-4788

Website: www.ryerr.comName: Bates, Chris

Company: ERA Tradewind Real EstateBusiness Address: 351 Coffman Street, Suite 200

City, State, Zip Longmont, CO 80501

Page 19: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 772-9620 ext. 7709, (877) 257-6581 ext. 7709Website: www.batec.com

Name: Reinpold, Linda KCompany: Centennial Properties, Inc.

Business Address: 2630 Tenderfoot Hill StreetCity, State, Zip Colorado Springs, CO 80906Office Phone: (719) 576-5000 ext. 1716, (877) 325-0466

Website: www.reinl.comName: Cuney, Jac

Company: The Kentwood Company at Cherry Creek, LLCBusiness Address: 44 Cook Street, 9th Floor

City, State, Zip Denver, CO 80206Office Phone: (313) 336-0362 , (877) 279-1535 ext. 1362

Website: www.cunej.comName: Salem, Joanne H

Company: Centennial Alliance, DTCBusiness Address: 5350 kS. Roslyn St. #150

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 773-3885 , (877) 766-1669 ext. 0300

Website: www.salej.comName: Swanson, Jerry L

Company: Preferred Properties, Inc.Business Address: 1041 S. Gaylord Street

City, State, Zip Denver, CO 80209Office Phone: (313) 778-8222 ext. 105, (877) 978-8222 ext. 105

Website: www.swanj.comName: Miller, Gary

Company: Millennium - Golden West RealtyBusiness Address: P.O. Box 876

City, State, Zip Golden, CO 80402Office Phone: (313) 877-8487 , (877) 279-7688

Website: www.millg.comName: Soesbe, Linda

Company: Centennial Mountain BrokersBusiness Address: 1180 Graves Avenue

City, State, Zip Estes Park, CO 80517Office Phone: (970) 586-0421 , (877) 827-8780

Website: www.soesl.comName: McKee, Rick

Company: Cameron BankerBusiness Address: 2821 East Parker Road, #115

City, State, Zip Aurora, CO 80014Office Phone: (313) 306-0342 , (866) 759-2084

Website: www.mcker.comName: Briggs, Vicky S

Company: Millennium Dinkel & Associates, Inc.Business Address: 300 E. 128th Avenue

City, State, Zip Thornton, CO 80241Office Phone: , (877) 525-7680

Website: www.brigv.com

Page 20: Module 11 Integrating Macros With Your Reports

Name: Sterner, SusanCompany: Keller Williams Realty

Business Address: 1283 Kelly Johnson Blvd.City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 535-0355 , (877) 535-0359

Website: www.sters.comName: Kraatz, Nancy A

Company: Realty Executives - Choice City Real EstateBusiness Address: 208 S. College

City, State, Zip Fort Colins, CO 80524Office Phone: (970) 472-8888 , (877) 472-8580

Website: www.kraan.comName: Dixon, Diane

Company: The Group Inc.Business Address: 5401 Stonecreek

City, State, Zip Loveland, CO 80538Office Phone: (970) 613-0700 ext. 1572

Website: www.dixod.comName: Upton, Linda M

Company: Centennial AllianceBusiness Address: 4770 Baseline Road

City, State, Zip Boulder, CO 80303Office Phone: (313) 530-4970 , (877) 373-1282 ext. 1136

Website: www.uptol.comName: Lyke, Judy

Company: Centennial Masters, Inc.Business Address: 6400 South Fiddlers Green Circle, #100

City, State, Zip Englewood, CO 80111Office Phone: (313) 771-9400

Website: www.lykej.comName: Engebretson, Lois

Company: Centennial Masters, Inc.Business Address: 6400 S. Fiddlers Gr. Circle

City, State, Zip Englewood, CO 80111Office Phone: (313) 930-5278 ext. 2916, (877) 766-1669

Website: www.engel.comName: Roadarmel, Ann

Company: Realty Link, Inc.Business Address: 12000 N, Zuni St. Ste. 1

City, State, Zip Westminster, CO 80234Office Phone: (313) 301-7250

Website: www.roada.comName: Nussbaum, James P

Company: Cherry Creek South LTDBusiness Address: 2305 E. Arapahoe Rd. #145

City, State, Zip Littleton, CO 80134Office Phone: (313) 797-1901

Website: www.nussj.comName: Cutrell, Karen

Company: Keller Williams Clients Choice Realty

Page 21: Module 11 Integrating Macros With Your Reports

Business Address: 1283 Kelly Johnson Blvd.City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 535-0355 , (877) 535-0355

Website: www.cutrk.comName: Crook, Dick

Company: Home Real EstateBusiness Address: 3609 South Wadsworth Blvd #110

City, State, Zip Lakewood, CO 80227Office Phone: (313) 858-8100

Website: www.crood.comName: Schwartz, Claudine

Company: Centennial AllianceBusiness Address: 9298 Ute Dr.

City, State, Zip Golden, CO 80403Office Phone: (313) 642-7777

Website: www.schwc.comName: Snyder, Betty

Company: Centennial AllianceBusiness Address: 4770 Baseline #200

City, State, Zip Boulder, CO 80303Office Phone: (313) 543-3088 , (877) 373-1282

Website: www.snydb.comName: Hamilton, Jeannie

Company: Centennial Horizons GroupBusiness Address: 11001 W. 120th Avenue, Suite 240

City, State, Zip Broomfield, CO 80021Office Phone: (313) 327-6500 ext. 6571

Website: www.hamij.comName: Gilroy, Linda

Company: Hall Properties, IncBusiness Address: 12520 Latigo Place

City, State, Zip Elbert, CO 80106Office Phone: (719) 339-3990

Website: www.gilrl.comName: Hoffman, Renee L

Company: Keller Williams Realty ProfessionalsBusiness Address: 9191 Sheridan Blvd., Suite 310

City, State, Zip Westminster, CO 80031Office Phone: (313) 467-8264

Website: www.hoffr.comName: Kuchars, Daniel

Company: Centennial Professionals Inc.Business Address: 390 Union Boulevard

City, State, Zip Lakewood, CO 80228Office Phone: (313) 716-3671

Website: www.kuchd.comName: Becker, Craig T

Company: Home Source Realty, Inc.Business Address: 5716 W. 81st Place

City, State, Zip Arvada, CO 80003

Page 22: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 429-1887 , (866) 295-4977Website: www.beckc.com

Name: Alpers, RichardCompany: Rusinak Real Estate, Inc.

Business Address: 7150 N. Academy Blvd.City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 590-6101 , (877) 571-0378

Website: www.alper.comName: Hesse, Mike

Company: Cameron Banker Residential BrokerageBusiness Address: 141 Union Boulevard.

City, State, Zip Lakewood, CO 80228Office Phone: (313) 914-4129 , (877) 780-3364

Website: www.hessm.comName: Fenney, Cynthia

Company: Centennial ProfessionalsBusiness Address: 1745 Shea Center Drive #110

City, State, Zip Highlands Ranch, CO 80129Office Phone: (313) 791-2882 , (877) 533-6837

Website: www.fennc.comName: Shoup, Tom

Company: Storz Real EstateBusiness Address: 3835 W 10th Street

City, State, Zip Greeley, CO 80634Office Phone: (970) 686-0136 , (888) 576-9595

Website: www.shout.comName: Ackerman, Vance

Company: Centennial Pueblo West Inc.Business Address: 19 E. Abarr Drive

City, State, Zip Pueblo West, CO 81007Office Phone: (719) 547-1717 ext. 724, (877) 699-1716

Website: www.ackev.comName: Golden, Terence M

Company: Centennial 100Business Address: 710 Kipling Street

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444

Website: www.goldt.comName: Storz, June

Company: Centennial Unlimited, IncBusiness Address: 3300 S. Parker Rd #100

City, State, Zip Aurora, CO 80014Office Phone: (313) 671-3035 , (888) 237-4208

Website: www.storj.comName: Mares, Ted R

Company: Prudential Professional REALTORSBusiness Address: 4065 Sinton Road N, Suite 100

City, State, Zip Colorado Springs, CO 80907Office Phone: (719) 785-1243 , (877) 208-6492

Website: www.maret.com

Page 23: Module 11 Integrating Macros With Your Reports

Name: Leeper, CindyCompany: Cameron Banker Residential Brokerage

Business Address: 11859 Pecos St.City, State, Zip Westminster, CO 80234Office Phone: (313) 469-7848

Website: www.leepc.comName: Tugaoen, Mimi

Company: Centennial AllianceBusiness Address: 13770 E Rice Place

City, State, Zip Aurora, CO 80015Office Phone: (313) 680-3027 ext. 1904

Website: www.tugam.comName: Schimmel, Anita C

Company: Cameron Banker Residential NRTBusiness Address: 8610 Explorer Dr. #15

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 550-2400 , (866) 477-3843

Website: www.schia.comName: Zimmerman, Jennifer

Company: United Property Brokers, Inc.Business Address: 3515 S. Tamarac Drive, Suite 100

City, State, Zip Denver, CO 80237Office Phone: (313) 956-5955 , (877) 584-0870

Website: www.zimmj.comName: Owens, Beth Baker

Company: Centennial AllianceBusiness Address: 13770 East Rice Place

City, State, Zip Aurora, CO 80015Office Phone: (313) 680-3044 , (877) 365-2479

Website: www.owenb.comName: Dvorak, Vern

Company: Cameron Banker Residential BrokerageBusiness Address: 6430 So Fiddlers Green Circle

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 771-3311

Website: www.dvorv.comName: Hall, Lennes H

Company: Sterling Real Estate GroupBusiness Address: 7175 West Jefferson Avenue, #4700

City, State, Zip Lakewood, CO 80235Office Phone: (313) 274-7724 ext. 1505

Website: www.halll.comName: Bruder, Patti

Company: Centennial Professionals Inc.Business Address: 7761 S. Shaffer Parkway, Suite 110

City, State, Zip Littleton, CO 80127Office Phone: (733) 922-2003 , (877) 866-7719

Website: www.brudp.comName: Mathis, Dawn

Company: Cameron Banker Residential Brokerage

Page 24: Module 11 Integrating Macros With Your Reports

Business Address: 1100 Haxton DriveCity, State, Zip Fort Collins, CO 80525Office Phone: (970) 223-2300 , (877) 276-2365

Website: www.mathd.comName: Maxwell, Vanecea K

Company: Centennial Pueblo WestBusiness Address: 19 E. Abarr Dr.

City, State, Zip Pueblo West, CO 81007Office Phone: (719) 547-1708 , (877) 699-1716

Website: www.maxwv.comName: Briggs, Tupper S

Company: Keller Williams Clients Choice RealtyBusiness Address: 1283 Kelly Johnson Blvd.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 535-0355 , (887) 535-0355

Website: www.brigt.comName: Masciotro, Nick

Company: ERA Tradewind Real EstateBusiness Address: 4999 Pearl E. Circle, Suite 100

City, State, Zip Boulder, CO 80301Office Phone: (313) 402-2643 , (877) 443-6050

Website: www.mascn.comName: Padalecki, Bobbye

Company: ERA Tradewind Real EstateBusiness Address: 4999 Pearl East Circle, Suite 100

City, State, Zip Boulder, CO 80301Office Phone: (313) 545-1981 , (877) 443-6050

Website: www.padab.comName: Pratt, Sue

Company: Cameron Banker Residential BrokerageBusiness Address: 3595 S. Teller #200

City, State, Zip Lakewood, CO 80465Office Phone: (313) 888-2244

Website: www.prats.comName: Tuohy, Liz Grazi

Company: Realty ExecutivesBusiness Address: 208 S. College Ave.

City, State, Zip Fort Collins, CO 80526Office Phone: (970) 472-8888 , (877) 472-8580

Website: www.tuohl.comName: Maierhofer, Andy

Company: Stix & Stones Fine Colorado PropertiesBusiness Address: 5299 DTC Blvd. Ste. 330

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 770-2409

Website: www.maiea.comName: Kelce, Martha

Company: Crockett Mountain RealtyBusiness Address: 2100 Fall River Road

City, State, Zip Estes Park, CO 80517

Page 25: Module 11 Integrating Macros With Your Reports

Office Phone: (970) 586-2850Website: www.kelcm.com

Name: Tracy, Charlene MarieCompany: Prestige Real Estate Group

Business Address: 520 Zang St. #200City, State, Zip Broomfield, CO 80021Office Phone: (313) 450-0860 , (888) 887-7617

Website: www.tracc.comName: Head, Betty

Company: Centennial Properties, Inc.Business Address: 1740 Chapel Hills Dr.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 495-8007 , (888) 773-6031

Website: www.headb.comName: Reed, Peggy B

Company: Mile Hi Realty ExecutivesBusiness Address: 7120 East County Line Road, #203

City, State, Zip Highlands Ranch, CO 80126Office Phone: (313) 850-7715 , (877) 243-3368

Website: www.reedp.comName: Corken, Kay

Company: Cameron Banker Residential BrokerageBusiness Address: 2821 South Parker Road, #115

City, State, Zip Aurora, CO 80014Office Phone: (313) 755-4313 , (877) 711-0636

Website: www.corkk.comName: Peltier, Diane

Company: Cameron Banker Residential NRTBusiness Address: 8610 Explorer Dr. #15

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 290-1000 , (866) 477-3843

Website: www.peltd.comName: Manley, Linda

Company: Keller Williams PreferredBusiness Address: 1333 W. 120th Avenue, #216

City, State, Zip Westminster, CO 80234Office Phone: (313) 452-3300 ext. 549

Website: www.manll.comName: Bell, Bob

Company: Millennium Properties, Inc.Business Address: 299 Joe Martinez Blvd.

City, State, Zip Pueblo West, CO 81007Office Phone: (719) 248-6632 , (888) 672-2727

Website: www.bellb.comName: Stephens-Douglass, Ana

Company: Centennial Properties, Inc.Business Address: 1740 Chapel Hills Drive

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 264-5451 , (888) 566-7199

Website: www.stepa.com

Page 26: Module 11 Integrating Macros With Your Reports

Name: Urben, A DonCompany: Centennial Northwest, Inc.

Business Address: 12000 Pecos St. #160City, State, Zip Denver, CO 80234Office Phone: (313) 255-4368 , (877) 433-0043

Website: www.urbea.comName: Tobin, Laurie

Company: Millennium Target RealtyBusiness Address: 2750 S. Wadsworth Blvd., Suite D-100

City, State, Zip Denver, CO 80227Office Phone: (313) 989-2121 , (877) 327-0349

Website: www.tobil.comName: King, Susan E

Company: Realty Executives of AuroraBusiness Address: 18851 E. Hampten #184

City, State, Zip Aurora, CO 80013Office Phone: (313) 690-2322

Website: www.kings.comName: Surkes, David

Company: Rusinak Real Estate, Inc.Business Address: 7880 N. Academy Blvd.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 590-6122 , (877) 727-7820

Website: www.surkd.comName: Casey, Mary L

Company: Centennial of LongmontBusiness Address: 2350 - 17th Avenue

City, State, Zip Longmont, CO 80503Office Phone: (313) 772-3800 ext. 155, (877) 228-0995 ext. 155

Website: www.casem.comName: Wood, Jerry D

Company: McGinnis GMACBusiness Address: 2025 Research Parkway, Suite A

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 527-4300

Website: www.woodj.comName: Pliley, Dianne

Company: ERA Tradewing Real EstateBusiness Address: 4999 Pearl East Circle, #100

City, State, Zip Boulder, CO 80301Office Phone: (313) 402-2654 , (877) 443-9212

Website: www.plild.comName: Greenwood, Jackie

Company: Cameron Banker Residential BrokerageBusiness Address: 3595 S. Teller St., Suite 200

City, State, Zip Lakewood, CO 80235Office Phone: (313) 987-4991 , (877) 433-5511

Website: www.greej.comName: Schmidt, Diane

Company: Centennial Advantage Realty

Page 27: Module 11 Integrating Macros With Your Reports

Business Address: 5590 North Academy BlvdCity, State, Zip Colorado Springs, CO 80918Office Phone: (719) 548-8600 , (877) 870-4804

Website: www.schmd.comName: Krauss, Arlene

Company: Centennial AllianceBusiness Address: 5440 Ward Road

City, State, Zip Arvada, CO 80002Office Phone: (313) 420-5352

Website: www.kraua.comName: Wedgwood, Lee

Company: Gold Star Realty, Inc.Business Address: 105 W. 4th

City, State, Zip Rifle, CO 81650Office Phone: (970) 625-1616 , (888) 264-6128

Website: www.wedgl.comName: Harris, Vanessa C

Company: Realty Executives Metro NorthBusiness Address: 20 W. 84th Avenue, Suite 220

City, State, Zip Denver, CO 80260Office Phone: (313) 429-1234 ext. 204, (877) 842-4663

Website: www.harrv.comName: Kane, Jean

Company: Carrie & Co.Business Address: 9187 W. Jewell Ave.

City, State, Zip Lakewood, CO 80232Office Phone: (313) 988-7771

Website: www.kanej.comName: Batteiger, Linda K

Company: Wedgwood & AssociatesBusiness Address: 6279 W. 38th Ave., Suite #5

City, State, Zip Wheat Ridge, CO 80033Office Phone: (313) 422-1826

Website: www.battl.comName: Melichar, Nancy A

Company: Heritage RealtorsBusiness Address: 5265 N. Academy, Suite 3300

City, State, Zip Colorado Springs, CO 80918Office Phone: (719) 598-1078 , (877) 873-3303

Website: www.melin.comName: Finley, Terry E

Company: Gold Star Realty, Inc.Business Address: 105 W. 4th

City, State, Zip Rifle, CO 81650Office Phone: (970) 625-1616 , (888) 264-6128

Website: www.finlt.comName: Nokes, Margaret

Company: Centennial AllianceBusiness Address: 3000 Youngfield Street, #350

City, State, Zip Lakewood, CO 80215

Page 28: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 525-1851 , (877) 666-3393Website: www.nokem.com

Name: Fry, RoselynCompany: Centennial First Associates

Business Address: 3459 W. 20th Street, Suite 113City, State, Zip Greeley, CO 80634Office Phone: (970) 378-2615 , (866) 671-8907

Website: www.fryr.comName: Skelton, Holly C

Company: Centennial 100, Inc.Business Address: 710 Kipling St.

City, State, Zip Lakewood, CO 80215Office Phone: (313) 202-2282 ext. 282, (877) 571-0385

Website: www.skelh.comName: Donahue, William A

Company: Metro Brokers: Sunny Homes & Associates Inc.Business Address: 13900 E. Harvard Avenue, #200

City, State, Zip Aurora, CO 80014Office Phone: (313) 588-9994

Website: www.donaw.comName: Olson, Pam

Company: ERA Tradewind Real EstateBusiness Address: 4999 Pearl East Circle, Suite 100

City, State, Zip Boulder, CO 80301Office Phone: (313) 545-1971 , (877) 443-6050

Website: www.olsop.comName: Myron, Margaret

Company: The Group Inc.Business Address: 5401 Stone Creek Circle

City, State, Zip Loveland, CO 80538Office Phone: (970) 679-1578

Website: www.myrom.comName: Hug, Donald O

Company: Thatcher PropertiesBusiness Address: 1413 Washburn St.

City, State, Zip Erie, CO 80516Office Phone: (313) 828-5331

Website: www.hugd.comName: Brush-Garcia, Debbie

Company: Centennial AllianceBusiness Address: 25871 Duran Ave

City, State, Zip Conifer, CO 80433Office Phone: (313) 948-8151

Website: www.brusd.comName: Brownlee, Gerri

Company: Centennial AllianceBusiness Address: 5440 Ward Road, Suite 110

City, State, Zip Arvada, CO 80002Office Phone: (313) 456-2132 , (877) 541-6376

Website: www.browg.com

Page 29: Module 11 Integrating Macros With Your Reports

Name: Whisler, DuaneCompany: Sears Real Estate

Business Address: 2021 Clubhouse Dr.City, State, Zip Greeley, CO 80634Office Phone: (970) 330-7700 ext. 221, (877) 253-2231 ext. 221

Website: www.whisd.comName: Stone, Valene K

Company: Centennial AllianceBusiness Address: 5440 Ward Road, #110

City, State, Zip Arvada, CO 80002Office Phone: (313) 888-3384

Website: www.stonv.comName: Nabors, Dot

Company: Keller Williams Executives RealtyBusiness Address: 200 W. Plaza Drive #200

City, State, Zip Highlands Ranch, CO 80129Office Phone: (313) 522-0184 , (877) 369-0358

Website: www.nabod.comName: Geis, Theresa L

Company: Acsent Property GroupBusiness Address: 12000 Zuni St. Ste. 1

City, State, Zip Westminster, CO 80234Office Phone: (313) 301-7114

Website: www.geist.comName: Beltran, William

Company: Wedgwood & AssociatesBusiness Address: 6279 W. 38th Ave., Suite #5

City, State, Zip Wheat Ridge, CO 80033Office Phone: (313) 422-1826

Website: www.beltw.comName: Schmidt, Ricky

Company: Mile Hi Realty ExecutivesBusiness Address: 7120 East County Line Road, #203

City, State, Zip Highlands Ranch, CO 80126Office Phone: (313) 850-7715 , (877) 243-3368

Website: www.schmr.comName: Vigil, Andrea

Company: Centennial NorthwestBusiness Address: 12000 Pecos St. #160

City, State, Zip Westminster, CO 80234Office Phone: (313) 255-4325 , (877) 419-3420

Website: www.vigia.comName: Finger, David

Company: Centennial 100, Inc.Business Address: 710 Kipling St., Suite 100

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444 , (877) 537-0002

Website: www.fingd.comName: Karaoulis, Rick

Company: The Kentwood Company at Cherry Creek, LLC

Page 30: Module 11 Integrating Macros With Your Reports

Business Address: 44 Cook Street, 9th FloorCity, State, Zip Denver, CO 80206Office Phone: (313) 336-0353

Website: www.karar.comName: DeCrowe, Debra

Company: Centennial AllianceBusiness Address: 5440 Ward Rd.

City, State, Zip Arvada, CO 80002Office Phone: (313) 456-2141 , (877) 887-5184

Website: www.decrd.comName: Schutt, Nathaniel

Company: Centennial Pueblo - Central LLCBusiness Address: 3673 Parker Blvd. Ste. 100

City, State, Zip Pueblo, CO 81008Office Phone: (719) 586-8701 , (877) 457-0760

Website: www.schun.comName: Bertch, Erik

Company: Cameron Banker Residential BrokerageBusiness Address: 2821 S. Parker Road, Suite 115

City, State, Zip Aurora, CO 80014Office Phone: (313) 340-0242

Website: www.berte.comName: Shortreed, Herb

Company: American Dream Home RealtyBusiness Address: 11152 Huron Street, #207

City, State, Zip Westminster, CO 80234Office Phone: (313) 254-5925

Website: www.shorh.comName: Kolb, Richard

Company: Centennial AllianceBusiness Address: 5440 Ward Road, Suite 110

City, State, Zip Arvada, CO 80002Office Phone: (313) 456-2113 , (877) 211-5716

Website: www.kolbr.comName: Lombardi, Jill

Company: Cameron Banker Residential BrokerageBusiness Address: 2821 S. Parker Road, Suite 115

City, State, Zip Aurora, CO 80014Office Phone: (313) 750-4500 ext. 1362, (877) 711-0636

Website: www.lombj.comName: Cabeen, Letitia

Company: New Century Realty, Inc.Business Address: 9035 Wadsworth # 4000

City, State, Zip Westminster, CO 80021Office Phone: (313) 422-5200 , (877) 425-5400

Website: www.cabel.comName: Gardner, Kimberly

Company: Centennial First AssociatesBusiness Address: 4703 Boardwalk Dr.

City, State, Zip Fort Collins, CO 80525

Page 31: Module 11 Integrating Macros With Your Reports

Office Phone: (970) 206-8262 , (877) 571-0703Website: www.gardk.com

Name: Waslo, JohnCompany: Cameron Banker Residential Brokerage

Business Address: 200-141 Union Blvd.City, State, Zip Lakewood, CO 80228Office Phone: (313) 914-4113 , (877) 857-4663

Website: www.waslj.comName: Jones, Matthew

Company: Keller Williams Preferred RealtyBusiness Address: 1401 Bridge St.

City, State, Zip Brighton, CO 80601Office Phone: (313) 478-8037 , (888) 346-3522

Website: www.jonem.comName: Shively, Svetlana

Company: Prudential Colorado Real EstateBusiness Address: 2305 E. Arapahoe Road, #145

City, State, Zip Littleton, CO 80122Office Phone: (313) 797-1901

Website: www.shivs.comName: Smith, Anthony

Company: Cameron Banker Residential BrokerageBusiness Address: 3595 S. Teller St. #200

City, State, Zip Lakewood, CO 80235Office Phone: (313) 987-4988 , (877) 401-0856

Website: www.smita.comName: Whitesell, Dawn

Company: Maierhofer & Associates/Metro BrokersBusiness Address: 6025 South Quebec Street, Suite 100

City, State, Zip Centennial, CO 80111Office Phone: (313) 740-8100

Website: www.whitd.comName: Ryland, Allan

Company: Metro Broker AmeriRealtyBusiness Address: 3835 W. 10th Street, Suite 100E

City, State, Zip Greeley, CO 80634Office Phone: (970) 351-0405 ext. `

Website: www.rylaa.comName: Peneton, Daniel

Company: Centennial Professionals, Inc.Business Address: 1745 Shea Center Dr. #110

City, State, Zip Highlands Ranch, CO 80129Office Phone: (313) 638-1497 , (877) 533-6837

Website: www.pened.comName: Mitchell, Cynthia

Company: Centennial NorthwestBusiness Address: 12000 Pecos St. #160

City, State, Zip Westminster, CO 80234Office Phone: (313) 457-4800 , (877) 433-0043

Website: www.mitcc.com

Page 32: Module 11 Integrating Macros With Your Reports

Name: Rhodes, TimothyCompany: Centennial Professionals, Inc.

Business Address: 390 Union BlvdCity, State, Zip Lakewood, CO 80028Office Phone: (313) 985-4555

Website: www.rhodt.comName: Busby, Diane

Company: Home Real EstateBusiness Address: 1599 Walnut Drive

City, State, Zip Brighton, CO 80601Office Phone: (313) 252-7700

Website: www.busbd.comName: Bilodeau, Mike

Company: Centennial Properties, Inc.Business Address: 3215 Austin Bluffs Parkway

City, State, Zip Colorado Springs, CO 80918Office Phone: (719) 637-7227 , (877) 243-8181

Website: www.bilom.comName: Martin, Guy

Company: Sage RealtyBusiness Address: 6855 Omaha Boulevard

City, State, Zip Colorado Springs, CO 80916Office Phone: (719) 477-1180 , (877) 599-7242

Website: www.martg.comName: Leslie, Leonard

Company: Cameron Banker Residential BrokerageBusiness Address: 12303 Airport Way, #270

City, State, Zip Broomfield, CO 80021Office Phone: (313) 449-5000

Website: www.lesll.comName: Keller, Richard

Company: Centennial 100, Inc.Business Address: 710 Kipling Street, Suite 110

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444

Website: www.kellr.comName: Krivjansky, Chris

Company: Cameron Banker ResidentialBusiness Address: 451 - 21st Avenue

City, State, Zip Longmont, CO 80501Office Phone: (313) 772-7478 ext. 5957, (866) 699-0876 ext. 5957

Website: www.krivc.comName: Granato, Richelle

Company: Keller Williams Realty ProfessionalsBusiness Address: 9191 Sheridan Blvd. #310

City, State, Zip Westminster, CO 80031Office Phone: (313) 579-8692

Website: www.granr.comName: Zias, Greg

Company: Centennial Pueblo West, Inc.

Page 33: Module 11 Integrating Macros With Your Reports

Business Address: 19 E. Abarr DriveCity, State, Zip Pueblo West, CO 81007Office Phone: (719) 547-1756 , (866) 546-3250

Website: www.ziasg.comName: Gida, Cole

Company: Centennial of Longmont Inc.Business Address: 2350 17th Avenue

City, State, Zip Longmont, CO 80503Office Phone: (313) 772-3811 ext. 146, (877) 228-0995

Website: www.gidac.comName: Quirk, Janine

Company: Mock RealtyBusiness Address: 825 S. Broadway

City, State, Zip Boulder, CO 80303Office Phone: (313) 497-0625 , (877) 447-4250

Website: www.quirj.comName: Markey, Juli

Company: Centennial Horizons Group @ InterlockenBusiness Address: 11001 W. 120th Avenue #240

City, State, Zip Broomfield, CO 80021Office Phone: (313) 456-8361 ext. 6505, (888) 851-6250

Website: www.markj.comName: Derlein, Marcia

Company: Rusinak Real EstateBusiness Address: 7150 N. Academy Blvd.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 590-6108 , (877) 727-7820

Website: www.derlm.comName: Prince, Kevin

Company: Centennial of Longmont, IncBusiness Address: 2350 17th Ave.

City, State, Zip Longmont, CO 80503Office Phone: (313) 772-3800 ext. 123, (877) 228-0995

Website: www.prink.comName: Mers, Garret

Company: Centennial Professionals, Inc.Business Address: 8760 S. Garland Court

City, State, Zip Littleton, CO 80128Office Phone: (313) 972-2555

Website: www.mersg.comName: Gildenmeister, Anne

Company: Classic Advantage RealtyBusiness Address: 102 E. Girard Avenue #C-150

City, State, Zip Denver, CO 80231Office Phone: (313) 756-4161

Website: www.gilda.comName: Cook, Jeanne

Company: Cameron Banker Residential BrokerageBusiness Address: 1202 Bergen Parkway

City, State, Zip Evergreen, CO 80439

Page 34: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 674-2418 , (877) 574-6667Website: www.cookj.com

Name: McEnery, BrianCompany: United Property Brokers

Business Address: 16731 E. Iliff Avenue, #1100City, State, Zip Aurora, CO 80013Office Phone: (313) 671-9311 , (877) 370-1497

Website: www.mcenb.comName: Siegmund, Jeffrey

Company: Cameron Banker Residential BrokerageBusiness Address: 3300 28th St.

City, State, Zip Boulder, CO 80301Office Phone: (313) 441-2436 , (877) 654-4788

Website: www.siegj.comName: Kroskey, Richard

Company: The Bashor Connection Real Estate ConsultantsBusiness Address: 1020 - G Ken Pratt Blvd., Suite G

City, State, Zip Longmont, CO 80501Office Phone: (313) 651-6334 , (866) 651-6334

Website: www.krosr.comName: Hunt, Edward

Company: Millennium Dinkel & AssociatesBusiness Address: 5445 Montebello Lane

City, State, Zip Colorado Springs, CO 80918Office Phone: (719) 599-4445

Website: www.hunte.comName: Rowe, David

Company: Centennial ProfessionalsBusiness Address: 390 Union

City, State, Zip Lakewood, CO 80028Office Phone: (313) 423-5220

Website: www.rowed.comName: Hutton, Roque

Company: Dixie Trimble Realty CompanyBusiness Address: 2038 Gaylord St.

City, State, Zip Denver, CO 80205Office Phone: (313) 320-4266

Website: www.huttr.comName: Razo, Lisa

Company: Metro Brokers - Beals & CompanyBusiness Address: 11150 Huron Street, Suite 100

City, State, Zip Northglenn, CO 80234Office Phone: (313) 452-5853 ext. 352

Website: www.razol.comName: Cobb, Christopher

Company: Keller Williams RealtyBusiness Address: 3880 N. Grant Ave. Ste. 140

City, State, Zip Loveland, CO 80537Office Phone: (970) 278-4127

Website: www.cobbc.com

Page 35: Module 11 Integrating Macros With Your Reports

Name: McClung, PeteCompany: Realty Executives MetroNorth

Business Address: 20 W. 84th Avenue, Suite 220City, State, Zip Denver, CO 80260Office Phone: (313) 429-1234

Website: www.mcclp.comName: Bricker, Diane

Company: Centennial Masters Inc.Business Address: 6400 S. FiddlersGreen Circle #108

City, State, Zip Englewood, CO 80111Office Phone: (313) 771-9400 ext. 5207, (877) 766-1669

Website: www.bricd.comName: Legg, Christopher

Company: The Kentwood CompanyBusiness Address: 5690 D.T.C. Blvd

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 773-3399 , (877) 723-7653

Website: www.leggc.comName: Brin, Alfred

Company: Metro Brokers - Priority Properties, IncBusiness Address: 6377 S. Revere Parkway

City, State, Zip Centennial, CO 80111Office Phone: (313) 799-8100 ext. 222, (877) 799-8100

Website: www.brina.comName: Larsen, Shira

Company: Centennial Pueblo West Inc.Business Address: 19 E. Abarr Drive

City, State, Zip Pueblo West, CO 81007Office Phone: (719) 547-1739 ext. 1739, (877) 699-1716

Website: www.larss.comName: Tupman, Lateef

Company: Leeper & AssociatesBusiness Address: 10157 Owens Drive

City, State, Zip Westminster, CO 80021Office Phone: (313) 469-6723 , (877) 626-1419

Website: www.tupml.comName: Ross-Kramer, Koleen

Company: Centennial AllianceBusiness Address: 10375 Park Meadows, Suite 100

City, State, Zip Lone Tree, CO 80124Office Phone: (313) 850-1916 , (866) 820-6457

Website: www.rossk.comName: Gara, Anthony

Company: Centennial Properties, IncBusiness Address: 2630 Tenderfoot Hill St.

City, State, Zip Colorado Springs, CO 80901Office Phone: (719) 576-5000

Website: www.garaa.comName: Campbell, Bennet

Company: Cameron Banker

Page 36: Module 11 Integrating Macros With Your Reports

Business Address: 101 University Blvd. #100City, State, Zip Denver, CO 80206Office Phone: (313) 320-5733 , (877) 856-8355

Website: www.campb.comName: Huss, Keith

Company: A.H. Leffler & Assoc., LLCBusiness Address: 628 Main

City, State, Zip Windsor, CO 80550Office Phone: (970) 353-6088

Website: www.hussk.comName: Sparhawk, Carey

Company: Agi RealtyBusiness Address: 4020 Delcon Court

City, State, Zip Loveland, CO 80538Office Phone: (970) 581-9667

Website: www.sparc.comName: Wilson, Keith

Company: ERA Shields Real EstateBusiness Address: 5475 Tech Center Drive, Suite 300

City, State, Zip Colorado Springs, CO 80919Office Phone: (719) 593-1000 , (877) 888-8208

Website: www.wilsk.comName: Briggs, Mary

Company: Centennial Horizons GroupBusiness Address: 6343 W. 120th Ave., Ste. 100

City, State, Zip Broomfield, CO 80020Office Phone: (313) 469-6723 , (877) 626-1419

Website: www.brigm.comName: Collier, Traci

Company: Anne Hunter & Co. Metro BrokersBusiness Address: 355 Union Blvd., Suite 10

City, State, Zip Lakewood, CO 80228Office Phone: (313) 987-0404 ext. 303

Website: www.collt.comName: Dunehew, Richard

Company: Cameron Banker Residential BrokerageBusiness Address: 2553 S. Colorado Blvd. Unit 106

City, State, Zip Denver, CO 80222Office Phone: (313) 302-4600

Website: www.duner.comName: Covington, Brian D

Company: Centennial Alliance, DTCBusiness Address: 5350 S Roslyn Street, Suite 150

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 773-3885 ext. 1230

Website: www.covib.comName: Helden, Todd

Company: Home Real EstateBusiness Address: 13111 E. Briarwood

City, State, Zip Centennial, CO 80112

Page 37: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 910-9778 , (866) 650-9040Website: www.heldt.com

Name: Harding, KevinCompany: Marx Real Estate Corp.

Business Address: 1295 W. Littleton Blvd.City, State, Zip Littleton, CO 80120Office Phone: (313) 761-4006

Website: www.hardk.comName: Vaughn, David

Company: A Better Way Realty, LLCBusiness Address: 1777 South Harrison #911

City, State, Zip Denver, CO 80210Office Phone: (313) 759-2222 , (877) 559-1884

Website: www.vaugd.comName: Manzanares, Vicky

Company: Cameron Banker Residential BrokerageBusiness Address: 8490 E. Crescent Pkwy. Ste. 100

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 409-6319 , (877) 856-9004

Website: www.manzv.comName: Kallivrousis, John

Company: Brokers West Real Estate & DevelopmentBusiness Address: 8101 E. Prentice Avenue, Suite 815

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 956-7940

Website: www.kallj.comName: Grinker, Steven

Company: Centennial AllianceBusiness Address: 10375 Park Meadows Drive, Suite 100

City, State, Zip Lone Tree, CO 80124Office Phone: Pager

Website: www.grins.comName: Angers, James

Company: Centennial 100, Inc.Business Address: 710 Kipling St. Ste.110

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444 , (877) 537-0002

Website: www.angej.comName: Konshak, William

Company: Keller Williams Preferred RealtyBusiness Address: 1333 W. 120th Ave. Ste. 216

City, State, Zip Westminster, CO 80234Office Phone: (313) 452-3300

Website: www.konsw.comName: Thorpe, Dale

Company: Centennial Masters, Inc.Business Address: 6400 S Fiddlers Green Cir, Suite 100

City, State, Zip Centennial, CO 80111Office Phone: (313) 483-2325

Website: www.thord.com

Page 38: Module 11 Integrating Macros With Your Reports

Name: Little-Keene, GeorgeCompany: Centennial Alliance

Business Address: 13770 E. RiceCity, State, Zip Aurora, CO 90026Office Phone: (313) 693-6666

Website: www.littg.comName: Roeder, Donald

Company: Cameron Banker Commerical NRTBusiness Address: 3300 28th Street

City, State, Zip Boulder, CO 80301Office Phone: (313) 413-2388 , (877) 654-4788

Website: www.roedd.comName: Hiner, Tony

Company: Centennial AllianceBusiness Address: 10375 Park Meadows Drive.. Suite 100

City, State, Zip Littleton, CO 80124Office Phone: (313) 796-1298 , (866) 820-6457 ext. 1298

Website: www.hinet.comName: Brown, Marc

Company: ReAction RealtyBusiness Address: 12000 Zuni St.

City, State, Zip Westminster, CO 80234Office Phone: (313) 667-3055

Website: www.browm.comName: Doud, John

Company: Centennial Horizons GroupBusiness Address: 11001 W. 120th Avenue, Suite 240

City, State, Zip Broomfield, CO 80021Office Phone: (313) 327-6500 ext. 6566, (888) 851-6250 ext. 6566

Website: www.doudj.comName: Frazier, Jack

Company: Centennial Alliance EvergreenBusiness Address: 30480 Stagecoach Blvd.

City, State, Zip Evergreen, CO 80439Office Phone: (313) 670-6399 , (877) 568-6120

Website: www.frazj.comName: Valentine, Jeremy

Company: Real Estate by Repp, Inc.Business Address: 12000 Suni St.

City, State, Zip Westminster, CO 80234Office Phone: (313) 301-7124

Website: www.valej.comName: Meyer, Nathan

Company: Keller Williams Realty DTCBusiness Address: 6300 S. Syracuse Way, #150

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 785-1384

Website: www.meyen.comName: Bartels, Gayla

Company: Cameron Banker Residential Brokerage

Page 39: Module 11 Integrating Macros With Your Reports

Business Address: 3300 28th StreetCity, State, Zip Boulder, CO 80301Office Phone: (313) 449-5000 ext. 380, (877) 654-4788 ext. 380

Website: www.bartg.comName: Irby, Roger

Company: Centennial southeast, Inc.Business Address: 8821 East Hampden Avenue, Suite 110

City, State, Zip Denver, CO 80231Office Phone: (313) 759-5400

Website: www.irbyr.comName: Pratchett, Laura

Company: ERA Werner Realty, Inc.Business Address: 2099 Highway 50 West, Suite 150

City, State, Zip Pueblo, CO 81008Office Phone: (719) 250-9880

Website: www.pratl.comName: Kreider, Scott

Company: Realty Executives Metro NorthBusiness Address: 20 W. 84th Avenue #220

City, State, Zip Denver, CO 80260Office Phone: (313) 429-1234 , (877) 843-4663

Website: www.kreis.comName: McHone, Gary

Company: Centennial 100, Inc.Business Address: 710 Kipline #110

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444 ext. 264, (877) 537-0002

Website: www.mchog.comName: Wright, Jerry

Company: Centennial Alliance CentralBusiness Address: 1873 S. Bellaire Street, #700

City, State, Zip Denver, CO 80207Office Phone: (313) 759-6647 , (877) 747-7362

Website: www.wrigj.comName: Emery, Richard

Company: UnknownBusiness Address: Pager

City, State, Zip , COOffice Phone: (313) 420-2121

Website: www.emerr.comName: Reno, John

Company: Centennial 100, Inc.Business Address: 710 Kipling, #118

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444 , (877) 537-0002

Website: www.renoj.comName: Daly, Scott

Company: Realty Executives Twin PeaksBusiness Address: 630 Coffman Street, Suite B

City, State, Zip Longmont, CO 80501

Page 40: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 776-2500 , (877) 776-0013Website: www.dalys.com

Name: Mandel, StephanieCompany: Realty Executives Twin Peaks

Business Address: 630 Coffman Street, Suite BCity, State, Zip Longmont, CO 80501Office Phone: (313) 651-6959 , (877) 776-0013

Website: www.mands.comName: Brennan, Glenn

Company: Centennial AffiliatesBusiness Address: 1019 8th Street

City, State, Zip Golden, CO 80401Office Phone: (313) 759-6676 , (877) 747-7362

Website: www.breng.comName: Waugh, David

Company: Centennial Alliance EvergreenBusiness Address: 30480 Stagecoach Blvd.

City, State, Zip Evergreen, CO 80439Office Phone: (313) 670-6358 ext. 40, (877) 568-6120

Website: www.waugd.comName: Nguyen, Ruben

Company: Centennial Horizons Group, Inc.Business Address: 6343 W. 120th Avenue

City, State, Zip Broomfield, CO 80020Office Phone: (313) 460-6721 ext. 6721, (877) 626-1419

Website: www.nguyr.comName: Dittemore, Gregory

Company: Centennial All StarsBusiness Address: 1975 Research Parkway, Suite 150

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 599-7575 , (888) 887-5343

Website: www.dittg.comName: Romero, Lisa

Company: Centennial 100, Inc.Business Address: 710 Kipling St. Ste.110

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444 , (877) 537-0002

Website: www.romel.comName: Muenks, Jingwen

Company: Centennial Properties, Inc.Business Address: 2630 Tenderfoot Hill Street

City, State, Zip Colorado Springs, CO 80906Office Phone: (719) 540-6406 , (877) 325-0466

Website: www.muenj.comName: Lathrop, Robert

Company: Premier Marketing ServicesBusiness Address: 6377 S. Revere Parkway, Suite 400

City, State, Zip Centennial, CO 80111Office Phone: (313) 799-8100 ext. 146, (866) 799-8100 ext. 146

Website: www.lathr.com

Page 41: Module 11 Integrating Macros With Your Reports

Name: Wollert, JanetCompany: Centennial Alliance

Business Address: 10375 Park Meadows Drive, #100City, State, Zip Littleton, CO 80124Office Phone: (313) 796-1222 , (888) 694-4834

Website: www.wollj.comName: Culver, Brian

Company: Rusinak Real EstateBusiness Address: 7880 N. Academy Blvd.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 590-6102 , (877) 727-7820

Website: www.culvb.comName: Dodson, Michael

Company: Centennial AllianceBusiness Address: 3000 Youngfield, Ste 350

City, State, Zip Lakewood, CO 80215Office Phone: (313) 202-3076

Website: www.dodsm.comName: Chapman, Elizabeth

Company: Realty Link, Inc.Business Address: 12000 N, Zuni St. Ste. 1

City, State, Zip Westminster, CO 80234Office Phone: (313) 301-7132

Website: www.chape.comName: Mathias, Steven

Company: Centennial of Cherry Creek, IncBusiness Address: 3773 Chenny Creek North Drive, Suite 801 East Towe

City, State, Zip Denver, CO 80209Office Phone: (313) 331-4529 , (877) 765-7110

Website: www.maths.comName: Gamber, Kent

Company: Cameron Banker Residential BrokerageBusiness Address: 8490 E. Crescent Pkwy. Suite 100

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 409-6134 , (877) 574-8800

Website: www.gambk.comName: Ornellas, Brad

Company: Centennial Northwest, Inc.Business Address: 12000 Pecos Street #160

City, State, Zip Westminster, CO 80234Office Phone: (313) 457-4800 , (877) 433-0043

Website: www.orneb.comName: Drake, Aron

Company: Centennial Masters, IncBusiness Address: 6400 S Fiddlers Green Circle, Suite 100

City, State, Zip Englewood, CO 80111Office Phone: (313) 660-8600 , (866) 204-0998

Website: www.draka.comName: Petig, Eric

Company: Centennial Alliance

Page 42: Module 11 Integrating Macros With Your Reports

Business Address: 5440 Ward Rd. Ste. 110City, State, Zip Arvada, CO 80002Office Phone: (313) 277-0431

Website: www.petie.comName: Diffenderfer, Michael

Company: Keller Williams Front Range Properties LLCBusiness Address: 1690 - 30th Street

City, State, Zip Boulder, CO 80301Office Phone: (313) 440-8080

Website: www.diffm.comName: Taylor, Thomas

Company: Centennial AllianceBusiness Address: 5350 S. Roslyn Ste. 150

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 796-1238

Website: www.taylt.comName: Bartolomeo, Jessica

Company: Centennial Alliance BoulderBusiness Address: 4770 Baseline Road, Suite 200

City, State, Zip Boulder, CO 80303Office Phone: (313) 543-3087 , (877) 373-1282 ext. 1193

Website: www.bartj.comName: Stough, Debra

Company: Bahl Marketing Group MBBusiness Address: 1745 Shea Center Drive, #400

City, State, Zip Highlands Ranch, CO 80129Office Phone: (733) 344-6644

Website: www.stoud.comName: Pyle, Karen

Company: Prudential LTM RealtorsBusiness Address: 275 S. Main Street

City, State, Zip Longmont, CO 80501Office Phone: (313) 772-2222 ext. 256

Website: www.pylek.comName: Morales, Elaine

Company: Centennial Pueblo West, Inc.Business Address: 19 E. Abarr Ave.

City, State, Zip Pueblo West, CO 81007Office Phone: (719) 547-1730 , (877) 699-1716

Website: www.morae.comName: DeSilva, Mark

Company: Centennial Mountain BrokersBusiness Address: 1180 Graves Ave.

City, State, Zip Estes Park, CO 80517Office Phone: (970) 586-1000 , (866) 311-1880

Website: www.desim.comName: Mitchell, Sheela

Company: Centennial Alliance Park MeadowsBusiness Address: 10375 Park Meadows Drive

City, State, Zip Lone Tree, CO 80124

Page 43: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 850-1844 ext. 269, (866) 820-6457Website: www.mitcs.com

Name: Knott, LoriCompany: Realty Executives Twin Peaks

Business Address: 630 Coffman Street, Suite BCity, State, Zip Longmont, CO 80501Office Phone: (313) 766-2500 , (877) 776-0013

Website: www.knotl.comName: Foster, Michael

Company: Terry Golden RealtorsBusiness Address: PO Box 1433

City, State, Zip Colorado Springs, CO 80901Office Phone: (719) 520-9812

Website: www.fostm.comName: Martindale, Matthew

Company: Cameron Banker Residential BrokerageBusiness Address: 3300 28th Street

City, State, Zip Boulder, CO 80301Office Phone: (313) 449-5000 , (877) 654-4788

Website: www.martm.comName: Johnson, John

Company: ERA Tradewind Real EstateBusiness Address: 351 Coffman Street, Suite 200

City, State, Zip Longmont, CO 80501Office Phone: (313) 772-9620 ext. 7709, (877) 257-6581 ext. 7709

Website: www.johnj.comName: Amador, Christine

Company: Centennial Properties, Inc.Business Address: 2630 Tenderfoot Hill Street

City, State, Zip Colorado Springs, CO 80906Office Phone: (719) 576-5000 ext. 1716, (877) 325-0466

Website: www.amadc.comName: Petrowsky, Yvonne

Company: The Kentwood Company at Cherry Creek, LLCBusiness Address: 44 Cook Street, 9th Floor

City, State, Zip Denver, CO 80206Office Phone: (313) 336-0362 , (877) 279-1535 ext. 1362

Website: www.petry.comName: McClure, Timothy

Company: Centennial Alliance, DTCBusiness Address: 5350 kS. Roslyn St. #150

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 773-3885 , (877) 766-1669 ext. 0300

Website: www.mcclt.comName: Rangel, Lorna

Company: Preferred Properties, Inc.Business Address: 1041 S. Gaylord Street

City, State, Zip Denver, CO 80209Office Phone: (313) 778-8222 ext. 105, (877) 978-8222 ext. 105

Website: www.rangl.com

Page 44: Module 11 Integrating Macros With Your Reports

Name: Parker, MarkCompany: Millennium - Golden West Realty

Business Address: P.O. Box 876City, State, Zip Golden, CO 80402Office Phone: (313) 877-8487 , (877) 279-7688

Website: www.parkm.comName: Larsen, Sally

Company: Centennial Mountain BrokersBusiness Address: 1180 Graves Avenue

City, State, Zip Estes Park, CO 80517Office Phone: (970) 586-0421 , (877) 827-8780

Website: www.larss.comName: Liu, Vicki

Company: Cameron BankerBusiness Address: 2821 East Parker Road, #115

City, State, Zip Aurora, CO 80014Office Phone: (313) 306-0342 , (866) 759-2084

Website: www.liuv.comName: Ferdinand, Kenneth

Company: Millennium Dinkel & Associates, Inc.Business Address: 300 E. 128th Avenue

City, State, Zip Thornton, CO 80241Office Phone: , (877) 525-7680

Website: www.ferdk.comName: Cox, Andrew

Company: Keller Williams RealtyBusiness Address: 1283 Kelly Johnson Blvd.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 535-0355 , (877) 535-0359

Website: www.coxa.comName: Morell, Randy

Company: Realty Executives - Choice City Real EstateBusiness Address: 208 S. College

City, State, Zip Fort Colins, CO 80524Office Phone: (970) 472-8888 , (877) 472-8580

Website: www.morer.comName: Weber, Sheri

Company: The Group Inc.Business Address: 5401 Stonecreek

City, State, Zip Loveland, CO 80538Office Phone: (970) 613-0700 ext. 1572

Website: www.webes.comName: Cieslar, Hsi

Company: Centennial AllianceBusiness Address: 4770 Baseline Road

City, State, Zip Boulder, CO 80303Office Phone: (313) 530-4970 , (877) 373-1282 ext. 1136

Website: www.ciesh.comName: Ball, Michael

Company: Centennial Masters, Inc.

Page 45: Module 11 Integrating Macros With Your Reports

Business Address: 6400 South Fiddlers Green Circle, #100City, State, Zip Englewood, CO 80111Office Phone: (313) 771-9400

Website: www.ballm.comName: Fisher, Randall

Company: Centennial Masters, Inc.Business Address: 6400 S. Fiddlers Gr. Circle

City, State, Zip Englewood, CO 80111Office Phone: (313) 930-5278 ext. 2916, (877) 766-1669

Website: www.fishr.comName: Cox, Sonia

Company: Realty Link, Inc.Business Address: 12000 N, Zuni St. Ste. 1

City, State, Zip Westminster, CO 80234Office Phone: (313) 301-7250

Website: www.coxs.comName: Gillis, Carol

Company: Cherry Creek South LTDBusiness Address: 2305 E. Arapahoe Rd. #145

City, State, Zip Littleton, CO 80134Office Phone: (313) 797-1901

Website: www.gillc.comName: Seely, Diane

Company: Keller Williams Clients Choice RealtyBusiness Address: 1283 Kelly Johnson Blvd.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 535-0355 , (877) 535-0355

Website: www.seeld.comName: Wong, Scott

Company: Home Real EstateBusiness Address: 3609 South Wadsworth Blvd #110

City, State, Zip Lakewood, CO 80227Office Phone: (313) 858-8100

Website: www.wongs.comName: Mundhenke, Emily

Company: Centennial AllianceBusiness Address: 9298 Ute Dr.

City, State, Zip Golden, CO 80403Office Phone: (313) 642-7777

Website: www.munde.comName: Holifield, Tamara

Company: Centennial AllianceBusiness Address: 4770 Baseline #200

City, State, Zip Boulder, CO 80303Office Phone: (313) 543-3088 , (877) 373-1282

Website: www.holit.comName: Nicolaus, Cliff

Company: Centennial Horizons GroupBusiness Address: 11001 W. 120th Avenue, Suite 240

City, State, Zip Broomfield, CO 80021

Page 46: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 327-6500 ext. 6571Website: www.nicoc.com

Name: Bichon, GeraldCompany: Hall Properties, Inc

Business Address: 12520 Latigo PlaceCity, State, Zip Elbert, CO 80106Office Phone: (719) 339-3990

Website: www.bichg.comName: August, Mark

Company: Keller Williams Realty ProfessionalsBusiness Address: 9191 Sheridan Blvd., Suite 310

City, State, Zip Westminster, CO 80031Office Phone: (313) 467-8264

Website: www.augum.comName: Miller, Martin

Company: Centennial Professionals Inc.Business Address: 390 Union Boulevard

City, State, Zip Lakewood, CO 80228Office Phone: (313) 716-3671

Website: www.millm.comName: Melton, Timothy

Company: Home Source Realty, Inc.Business Address: 5716 W. 81st Place

City, State, Zip Arvada, CO 80003Office Phone: (313) 429-1887 , (866) 295-4977

Website: www.meltt.comName: Masterson, Bacardi

Company: Rusinak Real Estate, Inc.Business Address: 7150 N. Academy Blvd.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 590-6101 , (877) 571-0378

Website: www.mastb.comName: Thornburg, Lynn

Company: Cameron Banker Residential BrokerageBusiness Address: 141 Union Boulevard.

City, State, Zip Lakewood, CO 80228Office Phone: (313) 914-4129 , (877) 780-3364

Website: www.thorl.comName: Adkins, Grazyna

Company: Centennial ProfessionalsBusiness Address: 1745 Shea Center Drive #110

City, State, Zip Highlands Ranch, CO 80129Office Phone: (313) 791-2882 , (877) 533-6837

Website: www.adkig.comName: Harvey, Harlon

Company: Storz Real EstateBusiness Address: 3835 W 10th Street

City, State, Zip Greeley, CO 80634Office Phone: (970) 686-0136 , (888) 576-9595

Website: www.harvh.com

Page 47: Module 11 Integrating Macros With Your Reports

Name: Sugadhan, ChristopherCompany: Centennial Pueblo West Inc.

Business Address: 19 E. Abarr DriveCity, State, Zip Pueblo West, CO 81007Office Phone: (719) 547-1717 ext. 724, (877) 699-1716

Website: www.sugac.comName: Thomas, Don

Company: Centennial 100Business Address: 710 Kipling Street

City, State, Zip Lakewood, CO 80215Office Phone: (313) 232-4444

Website: www.thomd.comName: Griffin, Jill

Company: Centennial Unlimited, IncBusiness Address: 3300 S. Parker Rd #100

City, State, Zip Aurora, CO 80014Office Phone: (313) 671-3035 , (888) 237-4208

Website: www.grifj.comName: Rhodes, Jennifer

Company: Prudential Professional REALTORSBusiness Address: 4065 Sinton Road N, Suite 100

City, State, Zip Colorado Springs, CO 80907Office Phone: (719) 785-1243 , (877) 208-6492

Website: www.rhodj.comName: Velasquez, Colleen

Company: Cameron Banker Residential BrokerageBusiness Address: 11859 Pecos St.

City, State, Zip Westminster, CO 80234Office Phone: (313) 469-7848

Website: www.velac.comName: Harker, James

Company: Centennial AllianceBusiness Address: 13770 E Rice Place

City, State, Zip Aurora, CO 80015Office Phone: (313) 680-3027 ext. 1904

Website: www.harkj.comName: Shaw, Karen

Company: Cameron Banker Residential NRTBusiness Address: 8610 Explorer Dr. #15

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 550-2400 , (866) 477-3843

Website: www.shawk.comName: Zink, Patrick

Company: United Property Brokers, Inc.Business Address: 3515 S. Tamarac Drive, Suite 100

City, State, Zip Denver, CO 80237Office Phone: (313) 956-5955 , (877) 584-0870

Website: www.zinkp.comName: Sanford, Donald

Company: Centennial Alliance

Page 48: Module 11 Integrating Macros With Your Reports

Business Address: 13770 East Rice PlaceCity, State, Zip Aurora, CO 80015Office Phone: (313) 680-3044 , (877) 365-2479

Website: www.sanfd.comName: Grivoyiannis, Nancy

Company: Cameron Banker Residential BrokerageBusiness Address: 6430 So Fiddlers Green Circle

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 771-3311

Website: www.grivn.comName: Stempel, Charles

Company: Sterling Real Estate GroupBusiness Address: 7175 West Jefferson Avenue, #4700

City, State, Zip Lakewood, CO 80235Office Phone: (313) 274-7724 ext. 1505

Website: www.stemc.comName: Kromer, Barbara

Company: Centennial Professionals Inc.Business Address: 7761 S. Shaffer Parkway, Suite 110

City, State, Zip Littleton, CO 80127Office Phone: (733) 922-2003 , (877) 866-7719

Website: www.kromb.comName: Lawson, David

Company: Cameron Banker Residential BrokerageBusiness Address: 1100 Haxton Drive

City, State, Zip Fort Collins, CO 80525Office Phone: (970) 223-2300 , (877) 276-2365

Website: www.lawsd.comName: Schmotzer, Desiree

Company: Centennial Pueblo WestBusiness Address: 19 E. Abarr Dr.

City, State, Zip Pueblo West, CO 81007Office Phone: (719) 547-1708 , (877) 699-1716

Website: www.schmd.comName: Dyer, John

Company: Keller Williams Clients Choice RealtyBusiness Address: 1283 Kelly Johnson Blvd.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 535-0355 , (887) 535-0355

Website: www.dyerj.comName: Conarro, Shannon

Company: ERA Tradewind Real EstateBusiness Address: 4999 Pearl E. Circle, Suite 100

City, State, Zip Boulder, CO 80301Office Phone: (313) 402-2643 , (877) 443-6050

Website: www.conas.comName: Rinna, Florianne

Company: ERA Tradewind Real EstateBusiness Address: 4999 Pearl East Circle, Suite 100

City, State, Zip Boulder, CO 80301

Page 49: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 545-1981 , (877) 443-6050Website: www.rinnf.com

Name: Simpson, RobbieCompany: Cameron Banker Residential Brokerage

Business Address: 3595 S. Teller #200City, State, Zip Lakewood, CO 80465Office Phone: (313) 888-2244

Website: www.simpr.comName: McCabe, Danny

Company: Realty ExecutivesBusiness Address: 208 S. College Ave.

City, State, Zip Fort Collins, CO 80526Office Phone: (970) 472-8888 , (877) 472-8580

Website: www.mccad.comName: Razo, Kevin

Company: Stix & Stones Fine Colorado PropertiesBusiness Address: 5299 DTC Blvd. Ste. 330

City, State, Zip Greenwood Village, CO 80111Office Phone: (313) 770-2409

Website: www.razok.comName: Byron, Timothy

Company: Crockett Mountain RealtyBusiness Address: 2100 Fall River Road

City, State, Zip Estes Park, CO 80517Office Phone: (970) 586-2850

Website: www.byrot.comName: Shepherd, Dominic

Company: Prestige Real Estate GroupBusiness Address: 520 Zang St. #200

City, State, Zip Broomfield, CO 80021Office Phone: (313) 450-0860 , (888) 887-7617

Website: www.shepd.comName: Fulop, Timothy

Company: Centennial Properties, Inc.Business Address: 1740 Chapel Hills Dr.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 495-8007 , (888) 773-6031

Website: www.fulot.comName: Amundrud, Al

Company: Mile Hi Realty ExecutivesBusiness Address: 7120 East County Line Road, #203

City, State, Zip Highlands Ranch, CO 80126Office Phone: (313) 850-7715 , (877) 243-3368

Website: www.amuna.comName: Brady, David

Company: Cameron Banker Residential BrokerageBusiness Address: 2821 South Parker Road, #115

City, State, Zip Aurora, CO 80014Office Phone: (313) 755-4313 , (877) 711-0636

Website: www.bradd.com

Page 50: Module 11 Integrating Macros With Your Reports

Name: Brown, DavidCompany: Cameron Banker Residential NRT

Business Address: 8610 Explorer Dr. #15City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 290-1000 , (866) 477-3843

Website: www.browd.comName: Burtchell, Dwight

Company: Keller Williams PreferredBusiness Address: 1333 W. 120th Avenue, #216

City, State, Zip Westminster, CO 80234Office Phone: (313) 452-3300 ext. 549

Website: www.burtd.comName: Westcott, Adam

Company: Millennium Properties, Inc.Business Address: 299 Joe Martinez Blvd.

City, State, Zip Pueblo West, CO 81007Office Phone: (719) 248-6632 , (888) 672-2727

Website: www.westa.comName: Blackhurst, Deborah

Company: Centennial Properties, Inc.Business Address: 1740 Chapel Hills Drive

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 264-5451 , (888) 566-7199

Website: www.blacd.comName: Bolte, Michael

Company: Centennial Northwest, Inc.Business Address: 12000 Pecos St. #160

City, State, Zip Denver, CO 80234Office Phone: (313) 255-4368 , (877) 433-0043

Website: www.boltm.comName: Rivera, Fiona

Company: Millennium Target RealtyBusiness Address: 2750 S. Wadsworth Blvd., Suite D-100

City, State, Zip Denver, CO 80227Office Phone: (313) 989-2121 , (877) 327-0349

Website: www.rivef.comName: Frazier, Ignacio

Company: Realty Executives of AuroraBusiness Address: 18851 E. Hampten #184

City, State, Zip Aurora, CO 80013Office Phone: (313) 690-2322

Website: www.frazi.comName: Barnes, Kevin

Company: Rusinak Real Estate, Inc.Business Address: 7880 N. Academy Blvd.

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 590-6122 , (877) 727-7820

Website: www.barnk.comName: Bolish, Kevin

Company: Centennial of Longmont

Page 51: Module 11 Integrating Macros With Your Reports

Business Address: 2350 - 17th AvenueCity, State, Zip Longmont, CO 80503Office Phone: (313) 772-3800 ext. 155, (877) 228-0995 ext. 155

Website: www.bolik.comName: Marshall, Laura

Company: McGinnis GMACBusiness Address: 2025 Research Parkway, Suite A

City, State, Zip Colorado Springs, CO 80920Office Phone: (719) 527-4300

Website: www.marsl.comName: Pyle, John

Company: ERA Tradewing Real EstateBusiness Address: 4999 Pearl East Circle, #100

City, State, Zip Boulder, CO 80301Office Phone: (313) 402-2654 , (877) 443-9212

Website: www.pylej.comName: Jones, Brett

Company: Cameron Banker Residential BrokerageBusiness Address: 3595 S. Teller St., Suite 200

City, State, Zip Lakewood, CO 80235Office Phone: (313) 987-4991 , (877) 433-5511

Website: www.joneb.comName: Carmichael, Phillip

Company: Centennial Advantage RealtyBusiness Address: 5590 North Academy Blvd

City, State, Zip Colorado Springs, CO 80918Office Phone: (719) 548-8600 , (877) 870-4804

Website: www.carmp.comName: Lozano, John

Company: Centennial AllianceBusiness Address: 5440 Ward Road

City, State, Zip Arvada, CO 80002Office Phone: (313) 420-5352

Website: www.lozaj.comName: Stephens, Mark

Company: Gold Star Realty, Inc.Business Address: 105 W. 4th

City, State, Zip Rifle, CO 81650Office Phone: (970) 625-1616 , (888) 264-6128

Website: www.stepm.comName: Dempsey, Madelyn

Company: Realty Executives Metro NorthBusiness Address: 20 W. 84th Avenue, Suite 220

City, State, Zip Denver, CO 80260Office Phone: (313) 429-1234 ext. 204, (877) 842-4663

Website: www.dempm.comName: Smith, Christopher

Company: Carrie & Co.Business Address: 9187 W. Jewell Ave.

City, State, Zip Lakewood, CO 80232

Page 52: Module 11 Integrating Macros With Your Reports

Office Phone: (313) 988-7771Website: www.smitc.com

Name: O'Donnell, JohnCompany: Wedgwood & Associates

Business Address: 6279 W. 38th Ave., Suite #5City, State, Zip Wheat Ridge, CO 80033Office Phone: (313) 422-1826

Website: www.o'doj.comName: Tyler, Gary

Company: Heritage RealtorsBusiness Address: 5265 N. Academy, Suite 3300

City, State, Zip Colorado Springs, CO 80918Office Phone: (719) 598-1078 , (877) 873-3303

Website: www.tyleg.comName: Aubin, Lincoln

Company: Gold Star Realty, Inc.Business Address: 105 W. 4th

City, State, Zip Rifle, CO 81650Office Phone: (970) 625-1616 , (888) 264-6128

Website: www.aubil.comName: Carrillo, Barbara

Company: Centennial AllianceBusiness Address: 3000 Youngfield Street, #350

City, State, Zip Lakewood, CO 80215Office Phone: (313) 525-1851 , (877) 666-3393

Website: www.carrb.comName: Greenlee, Gary

Company: Centennial First AssociatesBusiness Address: 3459 W. 20th Street, Suite 113

City, State, Zip Greeley, CO 80634Office Phone: (970) 378-2615 , (866) 671-8907

Website: www.greeg.comName: Walters, Melissa

Company: Centennial 100, Inc.Business Address: 710 Kipling St.

City, State, Zip Lakewood, CO 80215Office Phone: (313) 202-2282 ext. 282, (877) 571-0385

Website: www.waltm.comName: Etschmaier, Jaime

Company: Metro Brokers: Sunny Homes & Associates Inc.Business Address: 13900 E. Harvard Avenue, #200

City, State, Zip Aurora, CO 80014Office Phone: (313) 588-9994

Website: www.etscj.comName: Lara, Kevin

Company: ERA Tradewind Real EstateBusiness Address: 4999 Pearl East Circle, Suite 100

City, State, Zip Boulder, CO 80301Office Phone: (313) 545-1971 , (877) 443-6050

Website: www.larak.com

Page 53: Module 11 Integrating Macros With Your Reports

Trans Number Name Date Product Units Dollars Location10 Betsy 7-Aug-06 Printers 24 1337 east11 Ashley 29-Nov-04 Scanner 43 6446 west15 Zaret 20-Sep-06 Projector -8 5268 south16 Emilee 12-Apr-04 Scanner 45 3637 north45 Emilee 20-Sep-06 Printers 2 2454 east46 Ashley 9-Aug-05 Scanner 93 5012 west58 Cristina 12-Apr-04 Projector 34 3051 south60 Jen 27-Oct-04 Scanner 89 1946 north69 Cristina 23-Jan-05 Laptop 73 1232 east77 Cristina 15-Jan-04 Scanner 27 2253 west81 Jen 10-Jan-06 Printers 69 7952 south86 Jen 9-Aug-05 Laptop -2 9332 north87 Emilee 31-Aug-05 Laptop 5 3649 east98 Jen 12-Apr-04 Printers 92 1680 west

108 AASIM 31-Aug-05 Printers -10 8395 south114 Betsy 22-Sep-05 Speaker 77 1804 north116 Zaret 24-Jun-06 Laptop 22 4970 east119 Colleen 22-May-06 Laptop 20 9174 west131 Jen 29-Nov-04 Scanner 56 2186 south133 Betsy 9-Jul-04 Scanner 11 4571 north140 Jen 28-Jun-04 Laptop 80 8593 east145 AASIM 24-Sep-04 Scanner 89 3940 west147 Emilee 8-Mar-05 Speaker 90 9662 south149 AASIM 8-Mar-05 Speaker 37 4364 north164 Hallagan 12-Oct-06 Laptop 16 4455 east165 Hallagan 19-Dec-05 Projector 25 3824 west169 Ashley 17-Feb-04 Printers 63 8920 south178 Ashley 19-Dec-05 Scanner 19 9562 north180 Colleen 26-May-04 Speaker 60 1330 east186 Betsy 25-Nov-06 Scanner 74 9798 west196 Jen 19-Mar-05 Laptop 5 8485 south197 Colleen 6-Feb-04 Scanner -5 7069 north201 AASIM 26-Jun-05 Laptop 21 4346 east207 Colleen 6-Feb-04 Scanner 60 7686 west212 Colleen 11-May-06 Projector 31 5327 south215 Betsy 1-Jan-05 Speaker 51 8049 north216 Hallagan 23-Feb-06 Scanner 1 2244 east219 Colleen 3-Feb-05 Projector 41 7703 west234 Emilee 7-Nov-04 Scanner 59 2203 south237 Cristina 24-Sep-04 Laptop -4 4559 north239 AASIM 1-Oct-06 Printers 43 7685 east

Page 54: Module 11 Integrating Macros With Your Reports

244 Cristina 25-Feb-05 Laptop 8 3621 west245 AASIM 9-Jul-04 Scanner 5 3432 south247 Betsy 14-Nov-06 Scanner 36 2329 north249 Betsy 19-Mar-05 Scanner 7 1505 east250 Colleen 3-Nov-06 Scanner 64 6919 west252 Ashley 10-Apr-05 Laptop 41 4475 south253 Ashley 24-Sep-04 Projector 84 2654 north254 Emilee 30-Mar-05 Laptop 3 4932 east257 Hallagan 7-Jul-05 Scanner 10 6743 west268 Cristina 7-Nov-04 Laptop 1 3252 south269 Cristina 15-Jun-05 Projector 26 9582 north271 Hallagan 2-May-05 Laptop 74 6684 east279 AASIM 15-May-04 Projector 63 5207 west280 Jen 1-Oct-06 Printers 67 3344 south281 Cristina 29-Jul-05 Laptop 3 7585 north282 Hallagan 10-Dec-04 Laptop 65 6846 east288 Ashley 11-Sep-05 Speaker -8 6798 west297 Betsy 6-Mar-06 Projector 71 9492 south301 Zaret 21-Apr-05 Printers 60 4918 north306 Zaret 25-Feb-05 Projector -7 9721 east308 AASIM 15-May-04 Printers 7 9536 west311 Betsy 28-Feb-04 Printers 43 2832 south316 Cristina 5-Nov-05 Scanner 6 8810 north317 Cristina 15-Jan-04 Laptop 0 5061 east318 Jen 16-Oct-04 Laptop 20 1072 west320 Jen 15-May-04 Laptop 94 9444 south322 Jen 26-Jun-05 Scanner 27 7968 north324 Emilee 20-Sep-06 Projector 84 7080 east332 Cristina 3-Nov-06 Projector 13 3520 west342 Cristina 17-Dec-06 Printers 37 2394 south343 Colleen 14-Feb-05 Speaker 15 7370 north352 Colleen 12-Jan-05 Laptop 85 8415 east356 Ashley 29-Aug-06 Laptop 76 1582 west357 Ashley 15-Jun-05 Printers 31 5963 south361 Cristina 29-Nov-04 Projector -4 4107 north366 Emilee 14-Oct-05 Printers -9 6327 east369 Hallagan 28-Feb-04 Projector 20 6905 west374 Hallagan 18-Aug-06 Scanner 89 9710 south378 Emilee 23-Feb-06 Laptop 76 4249 north383 Jen 26-Jun-05 Laptop 35 1715 east393 Betsy 1-Apr-04 Printers 37 3872 west400 Colleen 14-Feb-05 Projector 36 9830 south409 Betsy 16-Oct-04 Scanner 74 2291 north416 Zaret 7-Jul-05 Laptop 2 2240 east417 Cristina 3-Oct-05 Projector -9 9764 west

Page 55: Module 11 Integrating Macros With Your Reports

420 Hallagan 29-Nov-04 Projector 79 5753 south423 Jen 12-Feb-06 Projector -10 7255 north425 Colleen 23-Jan-05 Projector 17 8025 east431 Ashley 11-May-06 Projector 8 3328 west436 Betsy 28-Feb-04 Laptop 22 8956 south442 AASIM 26-Jan-04 Projector 19 2900 north448 AASIM 15-Jan-04 Scanner 4 2779 east449 Ashley 6-Jun-04 Laptop 81 8288 west452 Zaret 4-May-04 Printers 48 2258 south454 Jen 17-Jun-04 Printers 32 5259 north457 Jen 6-Mar-06 Scanner 63 9174 east460 Colleen 23-Apr-04 Scanner 74 4828 west462 Cristina 28-Feb-04 Printers 63 7675 south468 AASIM 26-Jun-05 Scanner 22 9909 north470 Betsy 5-Oct-04 Projector 29 4557 east476 Ashley 9-Sep-06 Projector 12 7599 west479 Emilee 24-May-05 Projector 2 1356 south480 Zaret 22-May-06 Speaker 10 2241 north483 AASIM 12-Oct-06 Scanner 91 1954 east484 Jen 5-Jul-06 Printers 12 3551 west495 Jen 23-Feb-06 Scanner 90 8418 south497 Betsy 13-May-05 Scanner 64 8548 north498 Zaret 6-Mar-06 Laptop 79 5384 east501 Colleen 12-Oct-06 Printers -10 5530 west504 Colleen 21-Dec-04 Scanner 86 6074 south505 Cristina 28-Jun-04 Laptop -6 8155 north509 Jen 19-Mar-05 Speaker 6 3732 east510 Zaret 28-Feb-04 Laptop 4 7511 west515 Jen 17-Feb-04 Speaker 67 4674 south526 Betsy 26-Jan-04 Printers 73 7071 north528 Zaret 24-Jun-06 Scanner 11 6063 east534 Zaret 25-Nov-06 Laptop 38 8988 west535 Cristina 20-Aug-05 Printers 82 9647 south538 Hallagan 11-Aug-04 Laptop 50 2575 north539 Colleen 1-Apr-04 Speaker 7 6596 east540 Ashley 19-Mar-05 Printers 50 6916 west542 Jen 25-Feb-05 Projector 37 5522 south543 Zaret 2-Sep-04 Scanner 58 7908 north547 Betsy 1-Oct-06 Speaker 63 3552 east552 Cristina 29-Nov-04 Speaker 10 7431 west553 Zaret 17-Dec-06 Scanner 19 3580 south556 Jen 30-Apr-06 Laptop 46 6442 north559 Jen 9-Sep-06 Laptop 86 5671 east571 Hallagan 27-Jul-06 Speaker 60 5593 west578 Hallagan 7-Nov-04 Printers 7 7688 south

Page 56: Module 11 Integrating Macros With Your Reports

583 AASIM 16-Nov-05 Printers 0 9799 north587 Ashley 4-Jun-05 Laptop 39 8033 east593 Emilee 15-Jan-04 Projector 94 1064 west598 Hallagan 6-Dec-06 Laptop 14 3351 south599 AASIM 3-Nov-06 Projector 33 9255 north605 Colleen 3-Oct-05 Scanner 94 8328 east608 Colleen 24-Sep-04 Projector 58 6219 west610 Zaret 11-Sep-05 Laptop 50 4976 south613 Ashley 27-Jul-06 Scanner 17 5791 north638 Hallagan 31-Jul-04 Scanner 94 7568 east639 Jen 29-Jul-05 Scanner 70 3758 west659 Zaret 9-Jul-04 Laptop 25 2247 south660 Zaret 30-Mar-05 Laptop 11 9675 north663 Hallagan 14-Nov-06 Laptop 27 1764 east672 Jen 27-Nov-05 Scanner -1 2825 west673 Hallagan 17-Mar-06 Laptop 26 8567 south676 Hallagan 6-Feb-04 Speaker 8 1553 north678 Jen 3-Feb-05 Projector 79 7100 east680 Cristina 12-Oct-06 Printers 22 7192 west697 Jen 6-Mar-06 Speaker 36 9778 south699 Emilee 30-Apr-06 Laptop 84 1461 north700 Cristina 21-Mar-04 Printers 38 4237 east701 Betsy 26-May-04 Printers 13 2683 west704 AASIM 31-Jul-04 Laptop 11 8156 south706 Ashley 10-Mar-04 Printers 32 4389 north708 Ashley 23-Jan-05 Speaker 71 7841 east713 Betsy 6-Dec-06 Scanner 50 6111 west715 Jen 13-Jun-06 Printers 9 7687 south721 Ashley 23-Oct-06 Printers 40 6782 north722 Cristina 15-Jan-04 Laptop 75 3517 east739 Hallagan 23-Jan-05 Printers 56 3358 west743 Colleen 7-Jul-05 Projector 8 8803 south747 Betsy 19-Apr-06 Projector 83 2489 north752 Colleen 25-Oct-05 Printers -5 4966 east757 Betsy 29-Nov-04 Laptop -10 8142 west759 AASIM 25-Oct-05 Scanner 52 4629 south763 Emilee 11-May-06 Scanner 84 3840 north768 Colleen 26-Jun-05 Scanner -1 7713 east769 Jen 23-Jan-05 Speaker 12 8632 west770 Colleen 21-Mar-04 Speaker 25 5823 south771 Cristina 26-Jun-05 Scanner 33 6356 north773 Emilee 9-Aug-05 Laptop 52 5186 east784 Betsy 14-Oct-05 Projector 51 8235 west785 Ashley 10-Apr-05 Laptop 92 2932 south790 AASIM 16-Nov-05 Laptop 11 8088 north

Page 57: Module 11 Integrating Macros With Your Reports

792 Colleen 12-Apr-04 Projector 36 7041 east794 Hallagan 12-Apr-04 Printers 39 7923 west797 Zaret 1-Jan-05 Scanner 47 9393 south801 Cristina 10-Jan-06 Printers 14 6881 north805 Hallagan 8-Dec-05 Printers -1 9486 east807 Zaret 4-Jan-04 Laptop 67 9693 west811 Emilee 21-Mar-04 Projector 76 1261 south815 Colleen 21-Jan-06 Printers 73 2488 north817 Betsy 8-Apr-06 Projector 69 4588 east824 Hallagan 1-Apr-04 Projector 76 6230 west829 Colleen 14-Nov-06 Scanner 77 1809 south832 Zaret 22-May-06 Laptop 20 6737 north834 Hallagan 10-Jan-06 Projector 34 9387 east839 Zaret 17-Feb-04 Printers -9 6345 west843 Hallagan 21-Mar-04 Projector 25 9609 south845 AASIM 22-Aug-04 Laptop 37 9915 north852 Jen 27-Jul-06 Speaker 34 5962 east854 Emilee 22-May-06 Scanner 44 7422 west856 Colleen 12-Apr-04 Projector 11 7791 south857 Hallagan 22-Aug-04 Printers 74 3963 north869 AASIM 5-Jul-06 Laptop 47 7550 east873 Ashley 7-Nov-04 Laptop 41 6546 west881 Emilee 10-Apr-05 Scanner 45 6271 south884 Zaret 16-Nov-05 Scanner -3 6756 north887 Jen 8-Mar-05 Projector 11 5267 east901 Betsy 6-Dec-06 Projector 0 3993 west902 Jen 1-Oct-06 Projector 69 5498 south908 Betsy 3-Feb-05 Projector 76 8470 north913 Jen 21-Apr-05 Printers 3 7215 east915 Ashley 13-Jun-06 Laptop 25 8154 west917 Zaret 16-Jul-06 Printers 19 7926 south921 Zaret 10-Apr-05 Printers 80 4701 north926 AASIM 19-Dec-05 Printers 47 7752 east931 Zaret 14-Oct-05 Projector 75 9208 west934 Zaret 1-Apr-04 Speaker 57 4842 south938 Ashley 20-Jul-04 Printers 56 7454 north942 Zaret 6-Feb-04 Laptop 32 6936 east943 Jen 12-Jan-05 Laptop 85 4722 west948 Ashley 25-Nov-06 Printers 6 4424 south954 Zaret 3-Nov-06 Scanner 17 8947 north957 Ashley 30-Dec-05 Printers 83 4563 east960 Emilee 20-Sep-06 Printers 53 8106 west965 Betsy 31-Aug-05 Laptop 53 8528 south969 Betsy 25-Feb-05 Printers 35 6709 north972 AASIM 12-Feb-06 Scanner 52 4006 east

Page 58: Module 11 Integrating Macros With Your Reports

973 AASIM 18-Aug-06 Scanner 44 1449 west974 Ashley 12-Oct-06 Speaker 72 7792 south975 Emilee 13-Sep-04 Scanner 13 3507 north984 Emilee 28-Dec-06 Projector 39 3180 east987 Emilee 11-May-06 Printers 94 7707 west989 Jen 15-May-04 Laptop -6 5157 south995 Betsy 12-Feb-06 Printers 24 2702 north998 Emilee 3-Oct-05 Laptop 78 1107 east

1000 Cristina 13-May-05 Printers 68 7738 west1004 Zaret 8-Apr-06 Projector 62 6905 south1007 AASIM 12-Apr-04 Projector 17 7670 north1008 Ashley 8-Dec-05 Laptop 51 7007 east1016 AASIM 12-Oct-06 Laptop 62 2628 west1018 Zaret 22-Aug-04 Projector 55 7387 south1021 Colleen 31-Aug-05 Projector 28 1396 north1029 AASIM 7-Jul-05 Speaker 78 8968 east1031 AASIM 14-Feb-05 Scanner 94 6901 west1035 Emilee 10-Apr-05 Projector 8 6699 south1044 Zaret 30-Apr-06 Laptop 32 3485 north1049 Colleen 11-Aug-04 Printers 79 8126 east1056 Betsy 18-Nov-04 Printers 57 8514 west1057 Colleen 24-Sep-04 Projector 63 6365 south1060 Hallagan 28-Mar-06 Projector 31 6362 north1061 Cristina 10-Mar-04 Laptop 55 7622 east1063 Zaret 23-Apr-04 Printers 28 1460 west1066 Betsy 6-Mar-06 Projector 94 7472 south1067 Jen 19-Mar-05 Projector 1 5641 north1074 Betsy 14-Nov-06 Printers 83 8907 east1076 Jen 28-Jun-04 Printers 36 4823 west1078 Ashley 29-Aug-06 Projector 18 3250 south1081 AASIM 30-Apr-06 Laptop 51 8307 north1083 Emilee 21-Apr-05 Laptop 93 5827 east1096 Emilee 4-May-04 Laptop 89 5529 west1102 Zaret 16-Nov-05 Printers 23 2462 south1110 Colleen 6-Mar-06 Scanner -1 2088 north1111 Ashley 31-Aug-05 Scanner 24 1853 east1112 Hallagan 1-Feb-06 Laptop 80 1116 west1114 Jen 30-Dec-05 Projector 1 3062 south1116 Betsy 16-Jul-06 Scanner 12 7029 north1117 AASIM 10-Dec-04 Laptop 54 8515 east1123 AASIM 28-Mar-06 Laptop 53 4134 west1124 Ashley 14-Feb-05 Scanner 29 9542 south1133 Jen 2-May-05 Laptop 84 3158 north1140 Ashley 17-Dec-06 Printers 60 1203 east1143 Zaret 1-Feb-06 Projector 66 1970 west

Page 59: Module 11 Integrating Macros With Your Reports

1145 Hallagan 10-Dec-04 Laptop 65 1646 south1147 Zaret 9-Jul-04 Speaker 8 1649 north1148 Ashley 10-Jan-06 Speaker 42 2211 east1162 AASIM 15-Jun-05 Projector 7 5281 west1170 Emilee 2-Sep-04 Laptop 2 3162 south1173 Emilee 7-Nov-04 Laptop 30 9408 north1175 Jen 22-Aug-04 Laptop 73 4293 east1176 Betsy 21-Jan-06 Printers 28 9637 west1179 Ashley 10-Apr-05 Speaker 70 3465 south1182 Colleen 22-Aug-04 Printers 88 3197 north1183 Emilee 1-Jan-05 Scanner 39 4218 east1185 Jen 24-Jun-06 Printers 0 1774 west1188 Betsy 13-Jun-06 Projector 76 1673 south1192 Hallagan 6-Feb-04 Speaker 40 2380 north1196 Betsy 17-Jun-04 Speaker 15 7255 east1197 AASIM 9-Sep-06 Laptop 39 1728 west1200 AASIM 21-Jan-06 Laptop 65 4142 south1202 Emilee 13-May-05 Scanner 84 8266 north1206 Jen 27-Jul-06 Laptop 80 6181 east1212 Jen 2-Sep-04 Laptop 22 7554 west1220 Jen 23-Jan-05 Scanner 75 8799 south1224 Emilee 4-Jan-04 Laptop -8 6182 north1226 Hallagan 29-Aug-06 Laptop 55 5963 east1232 Colleen 21-Jan-06 Speaker 52 2050 west1238 Jen 24-Sep-04 Speaker 92 1302 south1242 Colleen 10-Apr-05 Laptop 9 3892 north1244 Emilee 4-May-04 Printers 47 1081 east1249 Betsy 24-Jun-06 Scanner 42 9241 west1252 Betsy 12-Feb-06 Scanner 26 3625 south1253 Betsy 19-Dec-05 Laptop 52 1345 north1255 Ashley 11-Aug-04 Scanner 18 4694 east1256 Hallagan 25-Nov-06 Scanner 87 8049 west1261 Cristina 18-Nov-04 Projector 47 2220 south1272 Hallagan 25-Oct-05 Scanner -7 1443 north1277 Cristina 11-Sep-05 Projector 45 6025 east1283 Colleen 23-Jan-05 Laptop 23 9801 west1285 Emilee 1-Jan-05 Laptop -2 5588 south1288 Ashley 29-Nov-04 Speaker 84 1639 north1290 Betsy 7-Jul-05 Laptop 95 1200 east1301 Jen 18-Aug-06 Laptop 5 1304 west1303 Emilee 30-Dec-05 Printers 38 4823 south1307 Betsy 1-Feb-06 Scanner 28 1066 north1308 Zaret 29-Aug-06 Scanner 39 7054 east1314 Betsy 7-Nov-04 Printers 88 5174 west1320 Zaret 7-Nov-04 Scanner 25 4856 south

Page 60: Module 11 Integrating Macros With Your Reports

1326 Ashley 18-Nov-04 Scanner 89 1001 north1330 Cristina 28-Dec-06 Scanner 9 4904 east1331 Cristina 19-Apr-06 Projector 73 5471 west1335 Betsy 1-Apr-04 Projector 17 9334 south1338 Ashley 9-Sep-06 Speaker 50 2748 north1342 Hallagan 11-May-06 Scanner 21 5519 east1347 Cristina 10-Apr-05 Laptop 23 9981 west1349 Betsy 17-Feb-04 Scanner 56 4277 south1350 AASIM 19-Apr-06 Printers 26 1782 north1367 Betsy 17-Mar-06 Printers 32 2776 east1374 Cristina 29-Aug-06 Scanner 9 1500 west1375 Zaret 22-May-06 Projector 78 2119 south1383 Cristina 18-Aug-06 Printers 91 5911 north1390 Colleen 6-Feb-04 Scanner -7 1772 east1404 Betsy 15-Jun-05 Printers 27 4508 west1407 Ashley 18-Aug-06 Printers 24 1274 south1409 Zaret 18-Nov-04 Scanner 10 2555 north1414 Zaret 10-Dec-04 Projector 78 3380 east1415 Jen 5-Nov-05 Scanner 22 3568 west1417 Betsy 16-Oct-04 Printers 8 9865 south1419 Colleen 11-May-06 Scanner 81 2978 north1420 Zaret 21-Dec-04 Printers 72 8584 east1429 Hallagan 30-Mar-05 Speaker 24 7430 west1432 Zaret 23-Oct-06 Projector 0 5372 south1433 Cristina 17-Jun-04 Scanner 92 2605 north1434 Emilee 23-Oct-06 Scanner 22 7733 east1441 Zaret 17-Mar-06 Projector 93 6053 west1446 AASIM 1-Apr-04 Laptop 23 5849 south1451 Colleen 23-Oct-06 Scanner 91 4794 north1454 Colleen 21-Dec-04 Scanner 17 2593 east1455 Zaret 31-Jul-04 Laptop -7 9100 west1458 Zaret 19-Apr-06 Speaker 84 5646 south1462 AASIM 10-Jan-06 Projector 48 6029 north1464 Betsy 5-Jul-06 Projector 42 2898 east1467 Jen 26-Jan-04 Scanner 46 9458 west1469 Ashley 4-Jun-05 Projector 53 2927 south1471 Cristina 19-Dec-05 Scanner 64 4135 north1473 Zaret 1-Apr-04 Speaker 33 4704 east1475 Ashley 19-Dec-05 Speaker 51 1834 west1476 Cristina 18-Aug-06 Projector -7 6856 south1477 Ashley 13-May-05 Laptop 37 6025 north1493 Betsy 22-May-06 Projector 13 6017 east1499 Betsy 2-Jun-06 Printers 48 1223 west1505 Betsy 30-Dec-05 Projector 37 4000 south1511 Betsy 29-Nov-04 Printers 13 7166 north

Page 61: Module 11 Integrating Macros With Your Reports

1512 Emilee 16-Nov-05 Projector 9 5275 east1520 Hallagan 4-May-04 Projector 55 7805 west1547 AASIM 21-Dec-04 Laptop 34 7433 south1550 AASIM 19-Dec-05 Laptop 45 4538 north1551 Emilee 16-Oct-04 Printers 26 4849 east1563 Zaret 21-Dec-04 Laptop 59 9255 west1570 AASIM 27-Jul-06 Scanner 32 8369 south1573 Colleen 29-Nov-04 Laptop 91 1233 north1578 Colleen 12-Oct-06 Projector 82 1487 east1579 Ashley 6-Jun-04 Laptop 87 9980 west1582 Jen 16-Oct-04 Scanner 11 2764 south1584 Betsy 18-Aug-06 Projector 93 9270 north1589 Colleen 16-Jul-06 Printers 26 1808 east1591 Emilee 14-Feb-05 Printers 61 8736 west1607 Cristina 28-Jun-04 Laptop 15 8405 south1608 Emilee 10-Mar-04 Projector 81 9229 north1609 Betsy 10-Apr-05 Laptop 94 7909 east1614 Zaret 9-Jul-04 Projector 9 7620 west1620 AASIM 6-Feb-04 Laptop 6 3304 south1626 Emilee 1-Jan-05 Laptop 30 5386 north1627 Emilee 16-Jul-06 Laptop -1 4287 east1629 Betsy 8-Mar-05 Projector 42 1394 west1633 AASIM 4-May-04 Scanner 5 2377 south1638 Ashley 5-Oct-04 Scanner 15 7582 north1641 AASIM 18-Aug-06 Projector 56 3514 east1642 Zaret 22-May-06 Laptop 91 4309 west1646 Hallagan 19-Dec-05 Printers 0 9092 south1650 Colleen 10-Mar-04 Scanner 82 9251 north1653 Ashley 4-May-04 Laptop 56 1415 east1656 Betsy 1-Jan-05 Laptop 67 8001 west1661 Hallagan 4-Jun-05 Projector 28 5813 south1665 Hallagan 23-Jan-05 Printers 6 8530 north1666 Hallagan 25-Feb-05 Projector 63 7237 east1669 Colleen 10-Dec-04 Projector 16 6299 west1673 Jen 1-Oct-06 Projector 74 2303 south1674 Emilee 12-Apr-04 Printers 60 3817 north1676 Hallagan 28-Feb-04 Projector 41 6870 east1678 Ashley 5-Jul-06 Printers 89 6350 west1679 Hallagan 6-Jun-04 Scanner 12 6493 south1689 Colleen 20-Sep-06 Projector 18 7717 north1690 Zaret 19-Mar-05 Laptop 90 6093 east1691 Colleen 3-Oct-05 Scanner 12 2405 west1694 Zaret 6-Dec-06 Projector 74 5472 south1699 Zaret 8-Mar-05 Scanner 17 8840 north1709 AASIM 25-Nov-06 Printers -5 5764 east

Page 62: Module 11 Integrating Macros With Your Reports

1710 AASIM 29-Jul-05 Projector 34 8753 west1714 Hallagan 9-Sep-06 Scanner 65 3745 south1717 Zaret 10-Apr-05 Projector -9 4081 north1720 Emilee 24-Jun-06 Printers 40 1618 east1724 Zaret 24-May-05 Scanner 72 7577 west1726 Emilee 5-Jul-06 Laptop 35 3625 south1729 Cristina 17-Jun-04 Laptop 68 8624 north1731 Betsy 31-Aug-05 Speaker 84 8052 east1735 Betsy 8-Dec-05 Laptop 29 1862 west1737 Ashley 28-Mar-06 Laptop 88 3918 south1739 Jen 14-Feb-05 Projector 59 5250 north1742 AASIM 19-Apr-06 Printers 75 6621 east1743 Betsy 22-Aug-04 Scanner 40 6856 west1748 Ashley 4-May-04 Laptop 85 9168 south1751 AASIM 17-Dec-06 Projector 47 6965 north1768 Zaret 13-Sep-04 Projector -10 6249 east1772 Emilee 19-Dec-05 Printers 13 3129 west1774 AASIM 14-Feb-05 Projector 81 9942 south1778 Colleen 17-Mar-06 Scanner 7 1898 north1779 Emilee 10-Apr-05 Scanner 9 2460 east1781 Ashley 25-Feb-05 Printers 37 8718 west1783 Betsy 20-Sep-06 Speaker 43 9090 south1786 Betsy 10-Jan-06 Printers -9 6320 north1787 Jen 31-Aug-05 Speaker 24 4019 east1790 Emilee 21-Mar-04 Printers 90 3135 west1795 Ashley 3-Oct-05 Printers 93 1874 south1799 Betsy 28-Dec-06 Printers 31 5611 north1804 Ashley 10-Dec-04 Projector 62 4497 east1806 Ashley 11-Aug-04 Scanner 43 4466 west1820 Cristina 27-Nov-05 Printers 71 8127 south1821 Jen 22-May-06 Speaker 67 9260 north1825 Betsy 12-Feb-06 Speaker 73 5955 east1826 AASIM 18-Aug-06 Speaker 30 4382 west1828 Jen 4-Jun-05 Laptop 48 6639 south1829 Hallagan 22-May-06 Scanner -8 5945 north1833 Zaret 12-Jan-05 Printers 12 5013 east1834 Zaret 6-Mar-06 Laptop 54 2281 west1836 Zaret 9-Aug-05 Laptop 89 7234 south1837 Cristina 11-Sep-05 Projector 10 4173 north1838 Betsy 4-Jan-04 Projector 52 2793 east1849 Zaret 29-Jul-05 Printers 12 3605 west1853 AASIM 23-Apr-04 Printers 87 8477 south1855 Emilee 18-Jul-05 Printers 50 6754 north1860 Emilee 11-Aug-04 Printers -9 1250 east1863 Zaret 6-Mar-06 Laptop 73 5420 west

Page 63: Module 11 Integrating Macros With Your Reports

1867 Cristina 18-Aug-06 Scanner 73 7249 south1869 Betsy 3-Oct-05 Speaker 18 3622 north1877 AASIM 13-Sep-04 Laptop 66 1954 east1881 Emilee 3-Oct-05 Projector 0 3311 west1883 Betsy 20-Jul-04 Printers -6 9602 south1890 AASIM 15-Jun-05 Projector 16 3086 north1891 Betsy 10-Apr-05 Projector 39 5546 east1894 Colleen 15-May-04 Printers 60 1550 west1895 Emilee 27-Nov-05 Laptop 15 2856 south1896 Ashley 14-Feb-05 Projector 36 4597 north

2 Hallagan 10-Mar-04 Projector 50 9900 east3 Ashley 25-Feb-05 Speaker 9 3465 west5 Zaret 17-Jun-04 Printers 43 5033 south6 Colleen 27-Nov-05 Laptop 58 8212 north7 Cristina 21-Mar-04 Laptop 8 4979 east8 Colleen 17-Dec-06 Printers 72 7498 west

18 Jen 31-Aug-05 Printers 88 4759 south20 Zaret 27-Nov-05 Printers 57 6748 north22 Betsy 24-Sep-04 Laptop 28 7721 east23 Colleen 1-Feb-06 Scanner 25 4682 west27 Jen 12-Apr-04 Speaker 38 2406 south28 Cristina 22-Sep-05 Projector 77 5721 north32 Cristina 28-Mar-06 Printers 53 1448 east42 Emilee 10-Apr-05 Scanner 19 7575 west44 Colleen 6-Jun-04 Printers 55 4095 south51 Zaret 15-Jun-05 Laptop 24 6917 north52 Hallagan 4-Jan-04 Laptop 83 7855 east53 AASIM 7-Jul-05 Laptop 49 8401 west57 AASIM 28-Jun-04 Scanner 49 1669 south59 Cristina 8-Dec-05 Printers 8 6609 north61 Colleen 16-Nov-05 Projector 62 5816 east63 AASIM 17-Jun-04 Laptop 95 3661 west65 Ashley 10-Apr-05 Printers -6 4970 south70 Emilee 21-Dec-04 Laptop 95 4139 north75 Jen 23-Jan-05 Laptop -7 3231 east82 Colleen 29-Jul-05 Projector 67 8473 west89 AASIM 19-Mar-05 Projector 1 6023 south92 Jen 26-May-04 Scanner 33 7637 north94 Colleen 11-May-06 Laptop 58 7420 east

105 Cristina 13-Sep-04 Speaker 51 7603 west107 Emilee 21-Mar-04 Printers 9 9900 south110 Ashley 8-Mar-05 Scanner 35 7710 north117 Zaret 2-Jun-06 Projector 68 4384 east118 AASIM 24-May-05 Projector 59 6134 west125 Hallagan 16-Nov-05 Printers 41 6878 south

Page 64: Module 11 Integrating Macros With Your Reports

127 Emilee 7-Jul-05 Speaker 9 7701 north132 AASIM 21-Mar-04 Speaker 28 1439 east148 Ashley 3-Nov-06 Speaker 17 5039 west152 Zaret 2-Sep-04 Speaker 6 8294 south158 Jen 15-May-04 Projector -3 3407 north161 Cristina 17-Feb-04 Printers 46 3165 east166 Emilee 30-Mar-05 Laptop 49 9725 west181 Hallagan 14-Oct-05 Speaker 51 6531 south182 Ashley 4-May-04 Printers 78 5858 north184 Jen 22-Aug-04 Laptop 13 8330 east191 Jen 6-Feb-04 Scanner 63 2152 west193 Cristina 10-Jan-06 Speaker 68 4954 south195 Hallagan 10-Dec-04 Speaker 62 3689 north206 Hallagan 6-Dec-06 Speaker 20 5267 east209 Jen 1-Apr-04 Laptop 7 2815 west210 Betsy 6-Mar-06 Printers -6 1221 south217 AASIM 24-Sep-04 Projector 67 9031 north218 AASIM 30-Mar-05 Scanner 23 8131 east221 Cristina 20-Sep-06 Projector 56 8111 west232 Ashley 6-Jun-04 Printers 63 2146 south233 Emilee 11-Aug-04 Scanner 57 9277 north235 Jen 21-Dec-04 Projector -3 7869 east241 Emilee 2-May-05 Scanner 85 6800 west242 Emilee 21-Apr-05 Laptop 52 6345 south260 Zaret 15-Jan-04 Laptop 25 8881 north262 Jen 29-Aug-06 Projector 2 7495 east263 Zaret 3-Nov-06 Printers 62 3868 west272 AASIM 11-May-06 Printers 22 6868 south274 AASIM 27-Nov-05 Projector 83 5496 north276 AASIM 9-Aug-05 Scanner 0 6690 east285 Jen 18-Aug-06 Scanner -5 1536 west290 Emilee 16-Nov-05 Projector 94 3701 south291 Zaret 1-Oct-06 Scanner 83 9649 north293 Betsy 7-Aug-06 Scanner 33 6461 east294 Betsy 28-Feb-04 Laptop -1 7343 west296 Jen 21-Apr-05 Projector 76 5567 south303 Colleen 4-May-04 Projector 70 8719 north304 AASIM 22-May-06 Scanner 18 5941 east307 Zaret 20-Aug-05 Projector 55 2633 west309 AASIM 18-Nov-04 Laptop 63 6994 south313 Colleen 30-Dec-05 Laptop -9 2155 north314 AASIM 28-Jun-04 Projector -1 5346 east325 Hallagan 6-Jun-04 Laptop 83 2294 west326 Hallagan 11-Aug-04 Speaker 89 8941 south330 AASIM 26-Jan-04 Laptop 90 1685 north

Page 65: Module 11 Integrating Macros With Your Reports

338 Zaret 27-Jul-06 Projector 80 2010 east341 Hallagan 30-Mar-05 Laptop 21 6157 west344 Ashley 26-May-04 Scanner 94 9345 south349 Jen 31-Aug-05 Projector 72 8691 north362 Jen 16-Nov-05 Printers 28 3305 east368 Colleen 5-Jul-06 Projector 37 8202 west373 AASIM 30-Apr-06 Laptop 84 7006 south386 Jen 6-Mar-06 Projector 88 6114 north387 Ashley 28-Mar-06 Projector 45 3821 east388 Ashley 21-Mar-04 Printers 37 3668 west389 Colleen 10-Apr-05 Printers 12 6945 south390 Jen 15-May-04 Scanner 18 5878 north395 Betsy 15-May-04 Speaker 56 9100 east396 Jen 10-Dec-04 Laptop 53 6669 west398 Ashley 30-Mar-05 Scanner 90 7454 south399 Ashley 15-Jan-04 Laptop 30 3906 north403 Colleen 10-Dec-04 Speaker 26 8882 east405 Zaret 4-May-04 Projector 44 9003 west408 Jen 22-May-06 Printers 69 1439 south411 Betsy 9-Sep-06 Speaker 34 7680 north414 AASIM 23-Apr-04 Projector 37 8382 east419 Cristina 10-Mar-04 Scanner 0 1047 west421 Ashley 12-Jan-05 Projector 48 4191 south429 Jen 24-Jun-06 Speaker -4 6225 north440 Colleen 30-Apr-06 Speaker 78 7322 east445 Cristina 7-Aug-06 Speaker 17 6098 west464 Hallagan 29-Aug-06 Scanner 26 2442 south466 Zaret 12-Feb-06 Printers 2 9972 north467 Colleen 7-Aug-06 Printers 36 8325 east469 AASIM 9-Aug-05 Printers 92 1825 west473 Colleen 19-Mar-05 Projector 40 6912 south481 Jen 14-Oct-05 Laptop 6 1818 north489 Zaret 27-Jul-06 Laptop 58 3971 east493 Ashley 23-Apr-04 Laptop -1 4790 west496 Jen 25-Oct-05 Speaker 61 5358 south500 Colleen 13-Jun-06 Scanner 17 4410 north521 Hallagan 5-Nov-05 Projector 86 6225 east533 Hallagan 24-Sep-04 Printers 32 2585 west541 Cristina 25-Feb-05 Speaker 20 6434 south545 Hallagan 1-Apr-04 Laptop 34 3192 north546 Betsy 23-Oct-06 Projector 3 4796 east548 Betsy 10-Jan-06 Laptop 44 7374 west549 AASIM 12-Apr-04 Laptop 87 2584 south551 Ashley 19-Apr-06 Projector 93 5878 north557 Cristina 2-Sep-04 Projector 44 1267 east

Page 66: Module 11 Integrating Macros With Your Reports

558 Betsy 27-Oct-04 Laptop 47 2269 west560 Jen 27-Jul-06 Projector 76 4961 south564 Ashley 26-Jan-04 Projector 73 1702 north568 AASIM 23-Jan-05 Laptop 73 7816 east572 Emilee 6-Dec-06 Printers 40 8649 west573 Jen 29-Jul-05 Printers -7 9909 south574 Betsy 24-Sep-04 Projector 39 4304 north580 AASIM 14-Oct-05 Scanner 51 5521 east584 Jen 14-Feb-05 Scanner 81 1598 west585 Emilee 10-Apr-05 Speaker 93 2595 south592 AASIM 7-Aug-06 Laptop 47 7417 north594 Hallagan 2-Jun-06 Projector 92 6939 east596 Jen 21-Mar-04 Printers 37 7528 west604 Colleen 19-Dec-05 Speaker 89 2072 south609 Jen 17-Jun-04 Scanner 77 5358 north614 Cristina 2-May-05 Scanner 90 6429 east616 Cristina 21-Jan-06 Scanner 66 1013 west617 Jen 28-Jun-04 Laptop 6 6874 south620 Cristina 5-Oct-04 Scanner 3 1780 north621 Emilee 12-Apr-04 Projector -4 8306 east624 Hallagan 24-Sep-04 Scanner 72 1781 west632 Betsy 26-Jun-05 Projector 61 8577 south634 Jen 9-Sep-06 Laptop 31 3479 north635 Betsy 23-Apr-04 Scanner 6 3537 east637 Hallagan 7-Jul-05 Laptop 14 5262 west642 Ashley 30-Dec-05 Scanner 2 3558 south649 Zaret 1-Feb-06 Projector 43 9739 north650 Ashley 2-Sep-04 Scanner 40 8030 east656 AASIM 22-May-06 Projector -1 2051 west665 Cristina 20-Sep-06 Projector 27 4866 south668 Colleen 31-Aug-05 Laptop 43 1328 north670 Betsy 13-Sep-04 Printers 32 2628 east671 Zaret 8-Apr-06 Printers 89 8968 west674 Jen 25-Feb-05 Projector 56 5013 south675 Betsy 22-Aug-04 Printers 10 8566 north682 Emilee 7-Nov-04 Projector 94 1950 east688 Betsy 12-Apr-04 Speaker 56 3541 west694 Betsy 3-Oct-05 Printers 22 5558 south702 Emilee 19-Apr-06 Projector 40 3224 north703 Colleen 17-Jun-04 Speaker 46 4889 east707 AASIM 15-Jan-04 Projector 78 9010 west709 Colleen 23-Apr-04 Printers 36 1567 south712 Hallagan 15-Jan-04 Projector 38 4893 north723 Zaret 22-Aug-04 Printers 30 3885 east728 Hallagan 13-Jun-06 Printers 95 9047 west

Page 67: Module 11 Integrating Macros With Your Reports

732 Hallagan 7-Jul-05 Scanner 62 3658 south733 Betsy 11-Aug-04 Speaker 92 4140 north738 Zaret 19-Mar-05 Projector 34 5435 east742 Cristina 2-May-05 Projector -3 8037 west754 Cristina 12-Jan-05 Laptop 47 3985 south761 Cristina 29-Jul-05 Laptop 52 3544 north777 AASIM 28-Feb-04 Projector -5 1295 east780 Jen 12-Oct-06 Scanner 48 7136 west781 Betsy 6-Dec-06 Scanner 36 1319 south786 AASIM 21-Apr-05 Laptop 93 2496 north788 Ashley 12-Oct-06 Printers -9 1224 east796 Emilee 6-Mar-06 Printers 3 9640 west799 Colleen 6-Dec-06 Scanner 26 5673 south803 Hallagan 18-Aug-06 Projector 95 3133 north806 Emilee 18-Aug-06 Laptop 26 1267 east808 Emilee 17-Feb-04 Printers 15 1738 west818 Hallagan 12-Apr-04 Laptop 86 4173 south820 Cristina 21-Apr-05 Scanner -2 3391 north823 Colleen 18-Aug-06 Laptop 54 4603 east825 Betsy 31-Aug-05 Laptop 10 3762 west827 Jen 20-Sep-06 Laptop 83 1918 south833 Emilee 26-Jan-04 Laptop 31 6551 north841 Jen 2-Sep-04 Projector -3 9622 east847 Cristina 12-Apr-04 Printers 28 5591 west851 AASIM 7-Nov-04 Projector 31 5497 south862 Hallagan 15-Jun-05 Scanner 69 6960 north863 Ashley 20-Aug-05 Laptop 34 8234 east864 Betsy 9-Aug-05 Scanner 29 3231 west865 Colleen 17-Feb-04 Projector -10 5672 south866 AASIM 27-Oct-04 Speaker 42 3994 north868 Emilee 10-Mar-04 Projector 27 1823 east874 Emilee 7-Jul-05 Speaker 57 4988 west882 Cristina 10-Dec-04 Scanner 85 3008 south883 Emilee 7-Jul-05 Speaker 57 5901 north885 AASIM 7-Aug-06 Projector -9 4217 east886 Zaret 23-Apr-04 Laptop 86 4183 west888 Colleen 15-Jan-04 Scanner 87 2805 south893 Colleen 8-Dec-05 Speaker 11 5026 north899 Emilee 26-Jan-04 Laptop 19 6654 east900 Colleen 21-Mar-04 Printers 80 8584 west903 Emilee 16-Jul-06 Scanner 84 4248 south906 Ashley 30-Mar-05 Printers 79 2787 north907 Jen 24-Jun-06 Laptop 22 5517 east909 Ashley 5-Oct-04 Laptop 0 9072 west919 Jen 5-Jul-06 Speaker 8 7869 south

Page 68: Module 11 Integrating Macros With Your Reports

920 Emilee 10-Jan-06 Scanner -2 6340 north928 Jen 27-Nov-05 Printers 65 6101 east933 Jen 23-Jan-05 Scanner 34 8471 west947 Colleen 26-Jan-04 Speaker -1 5028 south955 Zaret 12-Jan-05 Laptop -1 8209 north958 Emilee 4-May-04 Scanner 54 5277 east963 Colleen 20-Aug-05 Scanner 11 3660 west967 Cristina 18-Nov-04 Projector 24 4843 south979 Emilee 12-Feb-06 Printers 2 3518 north981 Colleen 20-Aug-05 Projector -6 1529 east982 Ashley 30-Mar-05 Scanner 70 3326 west991 Cristina 15-Jan-04 Laptop -1 9930 south

1001 Cristina 17-Feb-04 Projector 20 2118 north1009 Betsy 30-Apr-06 Scanner 70 3867 east1011 Colleen 10-Dec-04 Scanner 70 3810 west1013 Colleen 14-Oct-05 Printers 26 8223 south1014 AASIM 8-Dec-05 Laptop 8 9649 north1015 Ashley 1-Feb-06 Projector 8 1093 east1019 Hallagan 2-Sep-04 Speaker 71 7295 west1027 Colleen 17-Mar-06 Printers 15 3376 south1033 Hallagan 6-Dec-06 Printers 42 3413 north1038 AASIM 24-Sep-04 Laptop 3 1392 east1039 Emilee 15-Jun-05 Speaker 76 4558 west1045 Cristina 2-Sep-04 Scanner 46 6093 south1046 AASIM 6-Feb-04 Printers 28 8107 north1050 Betsy 10-Dec-04 Scanner 31 6569 east1052 Colleen 28-Mar-06 Projector 91 1117 west1058 Betsy 4-May-04 Scanner 37 6294 south1064 Emilee 20-Aug-05 Laptop 93 3801 north1065 Jen 14-Oct-05 Speaker 13 7465 east1075 AASIM 14-Oct-05 Scanner 45 1180 west1077 Hallagan 19-Dec-05 Projector 82 6324 south1087 Colleen 21-Apr-05 Projector 58 6121 north1088 Ashley 4-Jan-04 Scanner 50 1391 east1093 Betsy 10-Dec-04 Printers 25 9208 west1097 Cristina 13-May-05 Projector 32 7105 south1098 Cristina 5-Jul-06 Printers 78 9590 north1100 Colleen 28-Dec-06 Projector 80 6120 east1101 AASIM 3-Feb-05 Scanner 72 5327 west1107 Colleen 10-Mar-04 Speaker -9 3682 south1125 Betsy 12-Apr-04 Printers 75 6288 north1130 AASIM 14-Nov-06 Laptop 72 2252 east1135 Emilee 21-Jan-06 Printers -4 6066 west1144 Zaret 21-Dec-04 Printers 77 6936 south1146 Hallagan 21-Apr-05 Scanner 29 4410 north

Page 69: Module 11 Integrating Macros With Your Reports

1149 Betsy 28-Feb-04 Projector 93 7777 east1153 Hallagan 1-Jan-05 Printers -1 5108 west1159 Jen 15-May-04 Projector 71 9139 south1164 Ashley 29-Nov-04 Projector -10 3565 north1167 Zaret 11-Sep-05 Laptop 18 8578 east1168 Cristina 24-Sep-04 Speaker 83 8203 west1177 AASIM 17-Mar-06 Scanner 40 3606 south1180 Betsy 19-Dec-05 Laptop 3 4405 north1181 Betsy 10-Dec-04 Laptop 33 9257 east1184 AASIM 26-Jun-05 Speaker 64 9645 west1189 Emilee 27-Oct-04 Laptop 75 3443 south1191 AASIM 18-Jul-05 Laptop -2 8913 north1195 Jen 28-Mar-06 Laptop 86 7389 east1198 Betsy 4-May-04 Projector 94 6502 west1205 Colleen 10-Apr-05 Printers 26 6502 south1208 Hallagan 27-Jul-06 Scanner 47 5647 north1211 Ashley 31-Jul-04 Scanner 33 6466 east1214 AASIM 13-Jun-06 Speaker 81 6698 west1217 Hallagan 22-May-06 Scanner 35 1166 south1222 Cristina 16-Nov-05 Scanner 30 6502 north1229 Zaret 21-Apr-05 Speaker 19 4284 east1239 Zaret 22-May-06 Scanner -5 5717 west1241 Emilee 28-Dec-06 Scanner 54 9930 south1246 AASIM 15-May-04 Scanner 90 2910 north1247 Betsy 6-Feb-04 Projector 48 8938 east1257 Colleen 16-Oct-04 Laptop 46 5041 west1258 Betsy 16-Jul-06 Scanner 54 7213 south1265 Hallagan 8-Apr-06 Printers 95 2884 north1267 AASIM 5-Oct-04 Laptop 47 3363 east1274 Hallagan 5-Oct-04 Speaker 91 5559 west1279 Colleen 2-Sep-04 Scanner 28 5869 south1282 Cristina 23-Apr-04 Scanner 11 7824 north1284 Betsy 19-Apr-06 Laptop 2 1299 east1287 Emilee 24-Jun-06 Scanner 10 9802 west1289 Hallagan 21-Dec-04 Scanner 88 4300 south1291 Zaret 14-Feb-05 Scanner 3 1984 north1293 AASIM 8-Mar-05 Laptop 58 2003 east1299 Colleen 5-Nov-05 Laptop 29 2347 west1300 Colleen 23-Apr-04 Projector 88 7663 south1313 Ashley 7-Jul-05 Scanner 8 8919 north1315 Ashley 22-Aug-04 Printers 12 9313 east1316 Jen 27-Nov-05 Scanner 79 8423 west1324 Ashley 1-Oct-06 Scanner 81 7944 south1327 Zaret 3-Feb-05 Scanner 6 4216 north1332 Betsy 15-Jan-04 Printers 13 1573 east

Page 70: Module 11 Integrating Macros With Your Reports

1333 Colleen 8-Mar-05 Laptop 14 4717 west1334 Betsy 24-May-05 Speaker 33 1010 south1337 Jen 23-Feb-06 Scanner 15 6338 north1343 AASIM 7-Jul-05 Scanner 80 7519 east1346 Jen 27-Nov-05 Speaker 50 2806 west1348 Jen 6-Jun-04 Printers 77 9498 south1354 Colleen 25-Feb-05 Speaker 61 2747 north1364 AASIM 17-Jun-04 Scanner 31 7498 east1365 Hallagan 5-Oct-04 Laptop 36 7816 west1380 Hallagan 19-Apr-06 Scanner 6 7117 south1381 AASIM 24-May-05 Laptop 18 5362 north1395 AASIM 25-Feb-05 Projector 83 3992 east1402 Ashley 22-May-06 Projector 55 1379 west1406 AASIM 5-Nov-05 Printers 17 1782 south1410 Cristina 16-Oct-04 Scanner 0 1484 north1411 Cristina 23-Jan-05 Printers 73 1548 east1412 Hallagan 21-Mar-04 Printers 66 7482 west1425 Zaret 8-Apr-06 Laptop 5 6442 south1427 Emilee 8-Dec-05 Scanner -10 4684 north1428 Ashley 6-Dec-06 Laptop 53 8671 east1430 Cristina 16-Jul-06 Printers 27 8918 west1438 Colleen 18-Aug-06 Scanner 10 6673 south1439 Cristina 26-Jun-05 Projector 15 2675 north1449 Hallagan 1-Oct-06 Speaker 45 9140 east1452 Emilee 17-Dec-06 Scanner 33 5190 west1453 Colleen 7-Aug-06 Projector 90 4857 south1457 Jen 9-Aug-05 Projector 14 8614 north1481 AASIM 8-Dec-05 Scanner 20 6073 east1483 Betsy 29-Jul-05 Laptop 94 1803 west1484 Betsy 9-Sep-06 Projector 41 4613 south1497 Zaret 25-Oct-05 Scanner 65 1650 north1498 Zaret 21-Dec-04 Laptop 16 7089 east1500 Hallagan 31-Aug-05 Laptop 78 8410 west1503 Ashley 28-Mar-06 Projector 73 5025 south1509 Betsy 30-Apr-06 Laptop 83 5787 north1518 Colleen 28-Jun-04 Laptop 9 8807 east1525 Zaret 29-Nov-04 Speaker -8 3897 west1529 Zaret 27-Jul-06 Printers 88 4490 south1534 Hallagan 10-Dec-04 Laptop 49 9994 north1538 Ashley 17-Jun-04 Laptop 1 9305 east1556 Colleen 3-Nov-06 Scanner 84 5908 west1564 Emilee 16-Nov-05 Projector 34 7913 south1565 Emilee 29-Nov-04 Scanner 27 9036 north1575 Betsy 19-Mar-05 Scanner -7 9167 east1580 AASIM 14-Feb-05 Scanner 93 6552 west

Page 71: Module 11 Integrating Macros With Your Reports

1586 Ashley 24-Sep-04 Printers 66 5020 south1588 Zaret 7-Jul-05 Scanner 61 7790 north1595 AASIM 4-Jun-05 Speaker 58 9730 east1599 Cristina 1-Feb-06 Printers 42 6373 west1605 Colleen 14-Nov-06 Laptop 6 5408 south1610 Zaret 15-Jan-04 Scanner 11 9527 north1612 Hallagan 31-Aug-05 Laptop 85 3317 east1616 Jen 6-Jun-04 Laptop 79 5727 west1617 Hallagan 26-May-04 Laptop 83 6165 south1619 AASIM 23-Feb-06 Scanner 62 1224 north1621 Ashley 8-Apr-06 Scanner 13 6111 east1624 Cristina 16-Oct-04 Laptop 61 6016 west1628 Betsy 1-Jan-05 Speaker 5 4670 south1630 Zaret 2-May-05 Laptop 14 1711 north1636 AASIM 9-Sep-06 Scanner 11 4835 east1639 Cristina 6-Feb-04 Laptop 53 1632 west1640 Zaret 20-Aug-05 Printers 70 9489 south1643 Jen 21-Dec-04 Speaker 55 1911 north1648 Colleen 1-Apr-04 Laptop 13 1247 east1651 Emilee 14-Feb-05 Projector 27 4951 west1658 Emilee 22-Sep-05 Laptop 14 8459 south1664 Cristina 1-Oct-06 Projector -5 7709 north1667 Emilee 13-Jun-06 Projector 33 2306 east1670 Jen 2-Jun-06 Laptop 15 5687 west1675 Cristina 2-May-05 Scanner 26 8701 south1684 Ashley 13-Sep-04 Scanner 94 1962 north1692 Colleen 26-Jan-04 Printers 39 8392 east1693 Colleen 17-Feb-04 Speaker 45 5403 west1697 Betsy 16-Oct-04 Scanner -3 7569 south1698 Cristina 24-May-05 Speaker 92 8619 north1702 Zaret 27-Oct-04 Projector 52 7957 east1707 AASIM 13-May-05 Projector -8 4113 west1715 AASIM 5-Jul-06 Printers 77 6145 south1718 Jen 30-Mar-05 Scanner 17 8010 north1719 Ashley 10-Apr-05 Laptop 11 9408 east1727 Ashley 3-Nov-06 Printers 39 8176 west1730 Emilee 27-Oct-04 Laptop 86 3374 south1734 Cristina 8-Apr-06 Printers 22 2490 north1738 Emilee 25-Feb-05 Laptop 41 5185 east1745 Zaret 19-Mar-05 Laptop 38 3483 west1750 Emilee 3-Nov-06 Laptop 86 4957 south1754 Cristina 7-Nov-04 Scanner -10 2834 north1759 Zaret 11-Sep-05 Projector 91 7766 east1760 Betsy 11-May-06 Printers 17 9509 west1762 Cristina 6-Dec-06 Scanner 8 4550 south

Page 72: Module 11 Integrating Macros With Your Reports

1764 Hallagan 4-Jun-05 Printers 52 6850 north1765 AASIM 31-Aug-05 Scanner 50 7905 east1767 Emilee 2-Jun-06 Scanner -10 4584 west1769 Jen 25-Oct-05 Scanner 90 2358 south1773 Colleen 20-Jul-04 Projector -10 8939 north1777 Betsy 19-Dec-05 Laptop 95 9135 east1784 AASIM 5-Jul-06 Scanner -5 1969 west1788 AASIM 4-May-04 Printers 30 8459 south1792 Hallagan 25-Oct-05 Laptop 51 7298 north1796 Jen 12-Oct-06 Laptop -3 4666 east1798 Cristina 5-Oct-04 Speaker 79 5154 west1802 Emilee 10-Mar-04 Printers 82 6255 south1807 Cristina 7-Nov-04 Printers 78 2232 north1814 Betsy 10-Mar-04 Speaker 31 3409 east1819 Zaret 9-Sep-06 Laptop 4 6208 west1824 Zaret 24-Jun-06 Printers 50 9085 south1842 Colleen 12-Apr-04 Printers 80 5340 north1846 Jen 12-Feb-06 Printers 55 3336 east1851 Ashley 23-Apr-04 Printers 37 1098 west1854 Cristina 1-Feb-06 Scanner 16 9120 south1857 AASIM 26-May-04 Projector 61 3245 north1861 Cristina 17-Mar-06 Laptop 74 2938 east1871 AASIM 1-Jan-05 Scanner 21 8008 west1875 Cristina 28-Feb-04 Speaker 54 3157 south1879 Ashley 18-Aug-06 Laptop 90 2490 north1882 Jen 21-Mar-04 Projector 72 9668 east1887 Zaret 21-Apr-05 Printers 61 3910 west1893 AASIM 31-Jul-04 Projector 20 5536 south1900 Cristina 13-Jun-06 Laptop 54 2908 north

1 Betsy 1-Apr-04 Printers 45 4783 east9 Ashley 5-Jul-06 Laptop 75 5536 west

14 Hallagan 1-Jan-05 Laptop 18 3176 south17 Colleen 30-Apr-06 Scanner 66 9260 north19 Jen 27-Oct-04 Laptop 78 1900 east40 Hallagan 24-Jun-06 Projector 38 5872 west41 Emilee 6-Feb-04 Laptop 25 5970 south48 Emilee 24-May-05 Laptop 37 6101 north56 Cristina 12-Apr-04 Printers 8 6490 east62 Emilee 11-Aug-04 Projector 23 3370 west64 Emilee 11-May-06 Laptop 41 4203 south66 Betsy 1-Jan-05 Scanner 84 9136 north67 Hallagan 5-Nov-05 Projector 63 1799 east72 Zaret 17-Jun-04 Speaker 54 2917 west73 Cristina 26-Jun-05 Projector 33 9546 south78 Emilee 17-Dec-06 Projector 56 2366 north

Page 73: Module 11 Integrating Macros With Your Reports

79 Cristina 14-Feb-05 Scanner 70 1872 east85 AASIM 17-Feb-04 Projector 80 1583 west88 Zaret 19-Dec-05 Laptop 26 9265 south90 AASIM 13-Jun-06 Speaker -3 1417 north91 Betsy 18-Aug-06 Laptop 83 3147 east95 Emilee 20-Aug-05 Projector 28 3660 west97 Cristina 25-Nov-06 Projector 92 8082 south99 Colleen 21-Jan-06 Printers 75 4935 north

102 Cristina 11-Aug-04 Projector 16 3640 east106 Jen 30-Mar-05 Projector -7 5841 west109 Ashley 16-Jul-06 Projector 10 3695 south112 AASIM 18-Nov-04 Scanner 38 2034 north115 Emilee 21-Jan-06 Projector 39 2204 east120 Hallagan 25-Oct-05 Scanner 61 7092 west121 Zaret 6-Mar-06 Projector 30 3007 south123 Zaret 30-Apr-06 Laptop 72 6543 north128 AASIM 13-May-05 Printers 1 8777 east134 Cristina 17-Dec-06 Printers 11 3686 west139 Betsy 24-May-05 Speaker 50 4381 south141 Jen 28-Dec-06 Laptop 83 1532 north143 Colleen 3-Feb-05 Projector 46 8243 east144 Ashley 23-Oct-06 Scanner 55 1343 west150 Cristina 17-Mar-06 Projector -4 2792 south154 Jen 11-Aug-04 Speaker 16 1969 north155 Betsy 3-Feb-05 Scanner 22 4746 east157 Emilee 11-Sep-05 Printers 85 2933 west159 Emilee 23-Jan-05 Printers 51 6979 south160 AASIM 1-Jan-05 Printers 72 6962 north162 Hallagan 25-Feb-05 Scanner -10 1203 east163 AASIM 9-Aug-05 Projector -5 4190 west168 Cristina 22-May-06 Printers 29 7480 south170 Jen 13-Jun-06 Printers 21 6699 north172 Colleen 28-Feb-04 Projector 55 1937 east173 Emilee 16-Jul-06 Projector 14 7666 west174 Jen 10-Mar-04 Speaker 91 3486 south175 Emilee 23-Apr-04 Laptop 80 4807 north176 Betsy 27-Nov-05 Laptop 70 2009 east179 Hallagan 22-Sep-05 Projector 38 2878 west185 Emilee 7-Jul-05 Scanner 2 1475 south187 Colleen 17-Mar-06 Projector 57 5480 north190 AASIM 1-Oct-06 Printers 28 2848 east200 Cristina 17-Mar-06 Laptop 21 9178 west202 Hallagan 30-Dec-05 Projector -3 9304 south211 Jen 30-Apr-06 Printers 35 5817 north226 Jen 6-Jun-04 Printers -1 4451 east

Page 74: Module 11 Integrating Macros With Your Reports

227 Hallagan 21-Jan-06 Laptop 37 2215 west228 Betsy 23-Feb-06 Projector 63 7119 south236 AASIM 1-Oct-06 Printers 86 4419 north240 Emilee 5-Nov-05 Printers 2 7933 east243 Colleen 9-Jul-04 Speaker -3 3690 west246 Hallagan 29-Aug-06 Scanner 90 8673 south256 Hallagan 6-Feb-04 Laptop 1 3914 north259 Colleen 14-Feb-05 Speaker 65 6334 east261 AASIM 16-Jul-06 Scanner -1 8049 west265 Hallagan 18-Jul-05 Laptop 55 9169 south266 Colleen 15-Jun-05 Printers 28 8629 north267 Cristina 29-Jul-05 Projector 5 5862 east270 Zaret 6-Jun-04 Projector 47 8655 west273 Ashley 24-Jun-06 Speaker 70 4461 south286 Jen 30-Mar-05 Projector 31 9920 north287 Ashley 17-Dec-06 Scanner 21 8142 east292 Ashley 11-Aug-04 Scanner 16 2629 west298 Zaret 26-May-04 Speaker 56 5777 south299 Hallagan 31-Aug-05 Printers 81 3990 north300 Zaret 28-Jun-04 Laptop 3 9726 east302 Jen 23-Oct-06 Projector 81 5084 west312 Zaret 31-Jul-04 Laptop 67 2684 south315 Betsy 12-Jan-05 Projector 21 6388 north319 Ashley 7-Nov-04 Projector 70 3223 east323 Colleen 17-Mar-06 Speaker 43 8056 west327 Emilee 12-Oct-06 Printers 7 5819 south328 Hallagan 9-Jul-04 Projector 68 2120 north334 Zaret 6-Jun-04 Projector 40 5037 east340 Hallagan 28-Mar-06 Scanner 89 3870 west345 AASIM 18-Jul-05 Scanner 85 4366 south347 Emilee 24-May-05 Speaker 25 5207 north353 Emilee 11-Sep-05 Laptop 85 5937 east354 Ashley 14-Oct-05 Printers 79 1386 west355 Jen 9-Sep-06 Printers 81 4674 south358 Zaret 22-Sep-05 Laptop 44 6347 north360 Cristina 26-May-04 Scanner 70 7186 east363 Ashley 12-Oct-06 Scanner 83 3941 west364 AASIM 5-Jul-06 Printers 46 4509 south371 Ashley 20-Aug-05 Laptop 36 2521 north375 Zaret 1-Feb-06 Printers 31 4312 east382 Zaret 17-Mar-06 Speaker 11 1232 west384 Emilee 17-Mar-06 Projector 72 7672 south391 Hallagan 21-Jan-06 Printers 75 1483 north392 Jen 25-Feb-05 Projector 8 2831 east394 Ashley 21-Dec-04 Printers -6 9299 west

Page 75: Module 11 Integrating Macros With Your Reports

397 Cristina 26-May-04 Printers 62 6863 south402 Emilee 10-Apr-05 Printers -4 3459 north406 Colleen 17-Feb-04 Scanner 91 1141 east410 Zaret 29-Jul-05 Projector 71 3909 west412 Jen 4-Jun-05 Scanner 93 5388 south415 Jen 28-Jun-04 Laptop 26 2883 north426 Jen 20-Aug-05 Laptop -4 1655 east430 Emilee 13-Sep-04 Projector 6 8222 west433 Betsy 6-Jun-04 Laptop 47 3944 south434 Hallagan 18-Aug-06 Printers 13 3274 north437 Zaret 17-Mar-06 Laptop 87 1944 east441 AASIM 19-Mar-05 Scanner 27 1074 west444 Betsy 10-Dec-04 Laptop 30 5509 south446 Hallagan 4-Jun-05 Printers 36 4521 north447 Hallagan 21-Jan-06 Projector -4 8636 east450 Cristina 21-Dec-04 Laptop 87 7249 west451 Betsy 6-Feb-04 Laptop 13 8159 south459 Colleen 10-Apr-05 Scanner 71 7600 north465 Ashley 13-Jun-06 Laptop 58 7855 east471 Ashley 12-Oct-06 Printers 42 1653 west472 Cristina 23-Apr-04 Printers 25 7480 south474 AASIM 4-May-04 Printers 3 4603 north475 Betsy 18-Jul-05 Projector -1 7202 east477 AASIM 17-Jun-04 Laptop 0 7838 west478 Hallagan 12-Feb-06 Printers 35 5650 south488 Betsy 20-Jul-04 Laptop 37 5236 north490 Jen 12-Feb-06 Laptop 74 2437 east491 Hallagan 6-Jun-04 Projector 64 2643 west492 Betsy 27-Nov-05 Speaker 53 6494 south502 Cristina 4-May-04 Scanner 61 2425 north512 Betsy 4-May-04 Projector 76 1680 east513 Hallagan 7-Jul-05 Speaker 27 9658 west514 Betsy 19-Dec-05 Projector 58 5655 south516 Colleen 11-Sep-05 Printers 79 4233 north517 Cristina 13-Sep-04 Scanner 38 9185 east518 Betsy 1-Apr-04 Scanner 4 5479 west519 Zaret 17-Mar-06 Laptop 45 8307 south527 Jen 15-Jan-04 Projector 62 8437 north529 Hallagan 19-Dec-05 Scanner 28 6886 east531 AASIM 10-Dec-04 Laptop 34 2940 west536 Jen 26-May-04 Projector 29 7391 south544 Colleen 21-Jan-06 Projector 25 4047 north550 Jen 25-Feb-05 Speaker 4 9459 east554 Hallagan 18-Jul-05 Laptop 30 6226 west555 Ashley 14-Nov-06 Scanner -1 9138 south

Page 76: Module 11 Integrating Macros With Your Reports

562 Ashley 26-May-04 Laptop -1 9945 north570 Emilee 19-Mar-05 Projector 43 5752 east577 Hallagan 3-Oct-05 Scanner 68 2787 west579 Zaret 12-Oct-06 Laptop -9 4161 south581 Hallagan 27-Nov-05 Printers 59 1395 north586 AASIM 1-Feb-06 Printers 20 4556 east588 Cristina 27-Oct-04 Projector 6 1176 west589 Cristina 17-Feb-04 Projector 34 7708 south595 Colleen 12-Jan-05 Printers 68 7501 north597 Emilee 20-Jul-04 Laptop 78 3818 east601 Zaret 7-Aug-06 Printers 6 3980 west603 Betsy 15-Jan-04 Scanner 24 6344 south606 Zaret 8-Dec-05 Projector 67 4603 north607 Colleen 11-Aug-04 Scanner 7 6744 east611 Betsy 7-Aug-06 Printers 10 6680 west615 Hallagan 25-Nov-06 Projector 58 5764 south618 Colleen 19-Apr-06 Printers 90 4715 north627 Colleen 22-May-06 Projector -8 1574 east630 Hallagan 10-Jan-06 Projector 55 1707 west633 Hallagan 15-Jun-05 Laptop 40 3039 south636 Hallagan 25-Oct-05 Projector -6 8123 north640 Emilee 7-Nov-04 Printers -8 6384 east641 Emilee 3-Nov-06 Printers -8 5881 west643 Hallagan 4-Jan-04 Speaker 10 3175 south644 AASIM 2-May-05 Laptop 51 1141 north645 AASIM 1-Apr-04 Laptop 5 2351 east646 Emilee 2-Jun-06 Laptop 39 5719 west648 Emilee 29-Nov-04 Projector 29 9663 south651 Emilee 12-Feb-06 Projector 36 1878 north652 Emilee 23-Jan-05 Laptop 88 6042 east653 Betsy 3-Feb-05 Scanner 55 4483 west657 Jen 20-Sep-06 Projector 32 8476 south658 Hallagan 21-Jan-06 Scanner 17 5460 north661 Zaret 17-Feb-04 Scanner 51 3522 east677 Colleen 2-May-05 Laptop 75 8447 west679 Colleen 13-May-05 Projector 25 2304 south683 Jen 3-Oct-05 Scanner 58 8275 north684 Emilee 4-Jun-05 Printers 66 3909 east686 Hallagan 1-Oct-06 Projector 94 2597 west689 Emilee 19-Apr-06 Scanner 82 5354 south690 Emilee 11-Sep-05 Scanner 7 6356 north692 Ashley 28-Dec-06 Projector 15 1769 east693 Jen 5-Oct-04 Projector 39 1958 west696 Betsy 20-Jul-04 Scanner 47 7623 south719 AASIM 13-Sep-04 Projector 71 6008 north

Page 77: Module 11 Integrating Macros With Your Reports

720 Cristina 3-Nov-06 Scanner 28 1224 east724 Jen 8-Dec-05 Printers 78 1820 west725 Colleen 9-Aug-05 Scanner 15 4078 south729 Jen 17-Feb-04 Projector 62 6352 north734 Zaret 17-Dec-06 Projector 35 2041 east736 Cristina 9-Jul-04 Scanner 21 5311 west737 Colleen 21-Jan-06 Scanner 49 5720 south745 Colleen 14-Feb-05 Printers 3 4760 north750 AASIM 11-May-06 Laptop -2 8203 east751 Cristina 29-Nov-04 Printers 6 1152 west753 Betsy 21-Jan-06 Laptop 42 8073 south758 Ashley 10-Mar-04 Laptop 21 8835 north760 Cristina 12-Apr-04 Speaker 5 2934 east762 Colleen 30-Mar-05 Scanner 38 5530 west764 AASIM 6-Dec-06 Speaker 18 8550 south767 Colleen 6-Dec-06 Projector 59 9938 north775 Cristina 29-Jul-05 Projector 66 3408 east776 Cristina 31-Jul-04 Speaker 10 1833 west778 Ashley 9-Aug-05 Scanner 89 8582 south779 AASIM 10-Apr-05 Projector 5 6037 north795 Hallagan 26-May-04 Laptop 72 5374 east800 Zaret 5-Oct-04 Laptop 47 1488 west802 Zaret 26-Jun-05 Scanner 71 5055 south804 AASIM 6-Mar-06 Scanner 37 1090 north809 Jen 23-Feb-06 Printers 73 9384 east812 AASIM 6-Jun-04 Laptop -9 1554 west814 Ashley 26-May-04 Projector 11 9600 south816 Jen 16-Oct-04 Speaker 93 8256 north819 Betsy 2-Jun-06 Scanner 54 1879 east828 Zaret 3-Nov-06 Projector 6 4232 west831 Ashley 6-Dec-06 Printers 80 3799 south836 Jen 12-Feb-06 Projector 17 5080 north837 Emilee 2-Jun-06 Laptop 16 1248 east844 Ashley 23-Oct-06 Printers 29 5476 west849 Ashley 2-Jun-06 Speaker 84 9669 south853 AASIM 16-Nov-05 Scanner 66 3883 north855 Betsy 23-Jan-05 Laptop 94 7107 east860 Cristina 6-Feb-04 Printers 34 1577 west861 Betsy 11-Sep-05 Laptop 38 4576 south870 Emilee 6-Feb-04 Projector 29 6586 north871 AASIM 11-May-06 Scanner 28 5553 east872 Betsy 20-Sep-06 Laptop 79 8588 west880 Ashley 20-Sep-06 Projector 4 5106 south889 Colleen 31-Jul-04 Laptop 86 5132 north892 Colleen 20-Jul-04 Speaker 11 4079 east

Page 78: Module 11 Integrating Macros With Your Reports

894 AASIM 5-Nov-05 Laptop -4 4394 west896 Cristina 28-Jun-04 Printers 51 8164 south897 Colleen 20-Jul-04 Projector 91 3817 north905 Zaret 31-Aug-05 Laptop 11 9601 east911 Zaret 7-Nov-04 Projector 14 8598 west916 Cristina 31-Aug-05 Projector 46 2258 south922 Jen 2-May-05 Projector 19 3915 north923 Betsy 10-Apr-05 Speaker 27 4617 east925 Jen 10-Jan-06 Projector 57 1006 west927 AASIM 7-Nov-04 Printers 9 7448 south930 AASIM 13-Sep-04 Scanner 48 5907 north935 Emilee 28-Mar-06 Printers 62 5294 east936 Cristina 5-Jul-06 Speaker 17 6257 west941 Betsy 18-Jul-05 Projector 44 6549 south945 Emilee 3-Feb-05 Speaker 31 1466 north946 AASIM 22-Aug-04 Laptop -7 8307 east950 Ashley 27-Oct-04 Printers 70 9912 west952 Cristina 19-Apr-06 Scanner 18 2442 south953 Cristina 23-Feb-06 Laptop 30 3146 north956 Jen 19-Mar-05 Projector 50 8307 east959 Ashley 21-Apr-05 Printers 16 7445 west962 Ashley 4-Jan-04 Scanner 74 6149 south966 Zaret 27-Jul-06 Printers 1 5233 north970 Betsy 22-May-06 Laptop 33 7843 east971 Emilee 1-Feb-06 Scanner 65 9814 west976 Zaret 9-Sep-06 Projector 16 3348 south980 Zaret 2-Jun-06 Scanner 28 4081 north983 Hallagan 23-Feb-06 Printers 65 5081 east990 Colleen 17-Feb-04 Laptop 38 2953 west994 Colleen 26-May-04 Projector 62 9582 south

1002 Colleen 5-Oct-04 Printers -10 1237 north1003 Zaret 24-Sep-04 Laptop 94 4114 east1017 Jen 18-Aug-06 Laptop -9 6447 west1020 Emilee 17-Mar-06 Scanner 5 7856 south1022 Emilee 11-May-06 Speaker 95 2670 north1023 Betsy 22-Sep-05 Laptop 56 6736 east1024 AASIM 25-Oct-05 Projector 79 8805 west1025 AASIM 29-Jul-05 Laptop 10 6453 south1030 Hallagan 24-May-05 Scanner 89 4029 north1036 Betsy 11-Aug-04 Projector 69 7592 east1037 Cristina 12-Oct-06 Scanner 2 3291 west1047 AASIM 3-Feb-05 Speaker 58 3448 south1048 Emilee 16-Nov-05 Printers 19 5446 north1051 AASIM 16-Nov-05 Laptop 4 2218 east1053 Hallagan 15-Jun-05 Printers 51 5827 west

Page 79: Module 11 Integrating Macros With Your Reports

1054 Emilee 15-Jan-04 Laptop 2 7364 south1059 Betsy 10-Mar-04 Printers 30 7910 north1062 Jen 19-Dec-05 Laptop -5 8985 east1069 Colleen 2-Jun-06 Scanner 60 1638 west1070 Hallagan 20-Jul-04 Printers 67 9816 south1071 Hallagan 10-Dec-04 Projector 87 7449 north1073 Jen 9-Aug-05 Printers 74 8700 east1079 Emilee 12-Apr-04 Projector 21 2619 west1080 Colleen 26-Jun-05 Projector 56 5220 south1085 Colleen 21-Apr-05 Laptop 30 3636 north1086 Jen 19-Dec-05 Projector 81 4681 east1089 Zaret 28-Jun-04 Printers 92 7196 west1090 Ashley 14-Nov-06 Projector 27 5484 south1091 Zaret 22-Aug-04 Projector 61 6584 north1092 Colleen 27-Jul-06 Scanner 7 9776 east1094 Ashley 22-Aug-04 Printers 84 5237 west1104 Colleen 5-Oct-04 Printers 81 1988 south1106 Betsy 1-Jan-05 Scanner 81 9286 north1113 Zaret 5-Oct-04 Printers 82 9063 east1120 Betsy 17-Feb-04 Laptop 6 9208 west1122 Colleen 1-Feb-06 Printers 55 9012 south1126 Ashley 29-Nov-04 Projector 78 2777 north1127 Zaret 20-Sep-06 Projector 6 9821 east1129 Hallagan 10-Apr-05 Laptop 35 3546 west1131 Jen 17-Jun-04 Scanner 79 6261 south1142 Colleen 26-Jun-05 Projector 95 1362 north1150 Zaret 6-Jun-04 Projector 69 7312 east1151 Colleen 5-Jul-06 Scanner 91 6174 west1152 Hallagan 3-Feb-05 Laptop 11 4603 south1154 Jen 21-Dec-04 Scanner 52 5044 north1155 Betsy 6-Mar-06 Speaker -10 2872 east1156 Zaret 25-Nov-06 Scanner 33 8279 west1160 Hallagan 18-Nov-04 Printers 88 2460 south1163 Emilee 24-Sep-04 Scanner 46 2130 north1166 Jen 17-Mar-06 Printers 85 5610 east1169 AASIM 25-Nov-06 Printers 71 8716 west1172 Zaret 22-Sep-05 Speaker 68 3243 south1186 Cristina 21-Mar-04 Speaker 26 6210 north1190 Emilee 17-Jun-04 Printers 61 1130 east1194 Colleen 20-Sep-06 Laptop 57 1293 west1199 Betsy 28-Mar-06 Printers 78 6392 south1201 Ashley 17-Dec-06 Laptop 66 4207 north1203 Betsy 17-Mar-06 Scanner 35 1152 east1213 AASIM 25-Oct-05 Printers 81 4684 west1215 Ashley 31-Jul-04 Projector 30 2688 south

Page 80: Module 11 Integrating Macros With Your Reports

1219 Betsy 7-Aug-06 Printers 15 8347 north1221 Emilee 12-Oct-06 Laptop 12 7900 east1227 Ashley 25-Feb-05 Printers 53 5634 west1230 AASIM 23-Jan-05 Scanner 23 8494 south1231 Betsy 6-Mar-06 Projector 68 3404 north1233 Ashley 18-Jul-05 Laptop 40 4448 east1236 Colleen 8-Apr-06 Scanner 30 5493 west1243 Zaret 13-May-05 Laptop 6 5175 south1245 Ashley 16-Nov-05 Scanner -10 4333 north1248 Emilee 10-Apr-05 Projector 55 2010 east1251 Colleen 16-Nov-05 Scanner 26 8696 west1254 Colleen 18-Nov-04 Projector 19 1662 south1259 Zaret 28-Feb-04 Scanner 21 4658 north1264 Jen 17-Dec-06 Printers 14 9055 east1266 Cristina 17-Feb-04 Laptop 64 1541 west1275 Colleen 10-Mar-04 Scanner 57 2727 south1276 AASIM 24-Sep-04 Projector -8 5512 north1278 Zaret 27-Oct-04 Laptop 92 6876 east1295 Betsy 21-Apr-05 Scanner 35 8758 west1297 Cristina 26-Jan-04 Laptop 26 4320 south1310 Betsy 23-Apr-04 Projector 72 1227 north1311 Colleen 22-Aug-04 Printers 63 6235 east1317 Colleen 17-Jun-04 Speaker 39 9258 west1321 AASIM 27-Nov-05 Projector 82 2031 south1323 Ashley 17-Dec-06 Speaker 22 8722 north1325 Zaret 25-Feb-05 Laptop 34 3127 east1328 Jen 26-Jun-05 Laptop 78 9761 west1329 AASIM 13-May-05 Printers 9 2931 south1336 Hallagan 5-Jul-06 Printers 9 4389 north1341 Betsy 30-Dec-05 Printers 77 8731 east1344 Hallagan 7-Nov-04 Scanner 56 6522 west1351 Ashley 17-Feb-04 Projector 18 4386 south1352 Cristina 17-Feb-04 Printers 40 6604 north1353 Hallagan 17-Feb-04 Scanner 75 8964 east1357 Hallagan 18-Nov-04 Laptop 47 1635 west1358 Ashley 16-Oct-04 Scanner 74 6033 south1361 Ashley 28-Jun-04 Projector 75 4250 north1363 Ashley 19-Dec-05 Printers 79 6471 east1366 Jen 28-Jun-04 Scanner 80 5285 west1373 Jen 23-Oct-06 Scanner 32 8580 south1377 Hallagan 22-Aug-04 Scanner 79 1387 north1378 Hallagan 4-Jan-04 Laptop 9 3116 east1384 Zaret 8-Dec-05 Laptop 74 6050 west1386 Colleen 3-Nov-06 Projector 28 3010 south1388 Cristina 30-Mar-05 Projector 52 3450 north

Page 81: Module 11 Integrating Macros With Your Reports

1389 Zaret 28-Jun-04 Speaker 33 9947 east1391 Cristina 1-Apr-04 Printers 12 1869 west1392 Zaret 28-Feb-04 Laptop 1 2007 south1393 Betsy 26-Jan-04 Scanner 56 9594 north1394 Cristina 26-Jun-05 Projector 34 2305 east1396 Colleen 19-Mar-05 Laptop -4 9046 west1397 Cristina 3-Feb-05 Projector 9 2273 south1399 AASIM 15-May-04 Printers 13 9465 north1400 Zaret 23-Apr-04 Printers 9 4322 east1403 Jen 2-Jun-06 Speaker 64 4773 west1416 Emilee 5-Oct-04 Scanner 21 8780 south1422 Betsy 31-Aug-05 Speaker 52 8290 north1424 Cristina 21-Mar-04 Laptop 82 1426 east1437 AASIM 15-May-04 Laptop -10 6811 west1440 Ashley 26-Jun-05 Speaker 0 1107 south1444 AASIM 30-Dec-05 Projector 53 5970 north1445 Ashley 23-Oct-06 Speaker 67 2323 east1461 Zaret 13-May-05 Printers 73 6787 west1463 AASIM 10-Dec-04 Laptop 72 8050 south1466 Zaret 31-Aug-05 Projector 56 5312 north1478 Betsy 15-Jun-05 Projector 43 6297 east1479 AASIM 22-May-06 Scanner 63 9468 west1485 Betsy 23-Jan-05 Laptop 45 5996 south1487 Ashley 1-Apr-04 Scanner 48 3805 north1489 Betsy 21-Jan-06 Printers 49 7210 east1491 Ashley 18-Jul-05 Projector 93 2132 west1496 Zaret 11-Sep-05 Laptop 89 3207 south1504 Betsy 20-Jul-04 Scanner 93 1822 north1506 Colleen 29-Jul-05 Printers 23 6473 east1508 Jen 23-Feb-06 Laptop 39 8476 west1510 Emilee 29-Aug-06 Projector 65 2412 south1513 Cristina 17-Dec-06 Laptop -4 9342 north1514 Ashley 27-Oct-04 Scanner 22 4575 east1515 Hallagan 30-Mar-05 Scanner -3 5519 west1516 Colleen 31-Jul-04 Scanner 58 5983 south1517 Cristina 22-Aug-04 Laptop 65 3244 north1519 Emilee 23-Oct-06 Speaker 18 8021 east1521 Cristina 12-Jan-05 Laptop 69 1653 west1523 Ashley 21-Jan-06 Speaker 23 3196 south1530 Jen 22-May-06 Laptop 62 2150 north1531 Hallagan 4-Jan-04 Speaker 80 5404 east1535 AASIM 20-Jul-04 Printers 45 2281 west1539 AASIM 29-Jul-05 Scanner 33 3766 south1540 Hallagan 31-Aug-05 Speaker 37 4546 north1542 Betsy 6-Feb-04 Projector 71 1261 east

Page 82: Module 11 Integrating Macros With Your Reports

1552 Ashley 26-Jan-04 Laptop 72 7100 west1554 Colleen 21-Mar-04 Projector 31 4687 south1555 AASIM 4-Jan-04 Printers 48 1147 north1557 Zaret 23-Feb-06 Laptop 54 1508 east1559 Cristina 27-Oct-04 Printers 40 6516 west1561 Emilee 28-Feb-04 Printers -8 6500 south1566 AASIM 23-Oct-06 Projector 3 4619 north1568 Hallagan 13-May-05 Laptop 58 7968 east1571 Cristina 11-Sep-05 Scanner 3 2518 west1574 Zaret 12-Feb-06 Projector -8 8583 south1577 Colleen 13-May-05 Printers -7 8313 north1581 Cristina 14-Oct-05 Projector 72 9610 east1583 Colleen 16-Jul-06 Printers 18 8127 west1592 Hallagan 13-Jun-06 Scanner -3 2741 south1593 AASIM 10-Jan-06 Projector 40 5343 north1597 AASIM 28-Dec-06 Laptop 14 9417 east1598 Emilee 21-Apr-05 Scanner 85 7672 west1601 Jen 26-Jan-04 Printers 32 5904 south1602 Hallagan 23-Jan-05 Printers 79 2422 north1613 Zaret 25-Nov-06 Laptop 39 2950 east1618 Hallagan 8-Dec-05 Projector -3 6389 west1631 Cristina 9-Aug-05 Laptop -4 9039 south1632 AASIM 21-Jan-06 Projector 27 5677 north1634 Ashley 19-Mar-05 Scanner 57 2845 east1637 Cristina 5-Oct-04 Printers 55 6155 west1644 Cristina 25-Oct-05 Scanner 1 3340 south1654 Betsy 28-Feb-04 Speaker 92 3719 north1663 AASIM 2-May-05 Printers 50 9926 east1668 AASIM 24-Sep-04 Laptop 61 2973 west1671 Colleen 27-Jul-06 Laptop -1 2330 south1677 Ashley 15-May-04 Printers -1 4456 north1680 Cristina 16-Oct-04 Laptop 21 7295 east1682 AASIM 30-Mar-05 Projector -7 4245 west1683 Betsy 10-Mar-04 Projector 35 5828 south1685 Ashley 5-Nov-05 Laptop 88 3038 north1686 Ashley 10-Mar-04 Speaker 26 9689 east1687 AASIM 9-Jul-04 Projector 83 6148 west1695 Colleen 18-Jul-05 Projector 95 5493 south1700 Hallagan 27-Oct-04 Printers 45 6531 north1701 Cristina 12-Oct-06 Speaker 62 4713 east1703 Hallagan 26-May-04 Speaker 73 6205 west1704 AASIM 18-Jul-05 Speaker 38 1179 south1706 Jen 16-Oct-04 Laptop 70 6023 north1712 Jen 3-Feb-05 Laptop -1 8910 east1716 Jen 19-Apr-06 Scanner 51 4339 west

Page 83: Module 11 Integrating Macros With Your Reports

1722 AASIM 29-Jul-05 Speaker 79 8129 south1723 Zaret 15-May-04 Projector -7 6821 north1728 Colleen 9-Jul-04 Scanner -7 7180 east1733 Betsy 10-Jan-06 Speaker -5 4305 west1736 AASIM 7-Nov-04 Printers 3 8128 south1740 Jen 5-Oct-04 Scanner 29 6404 north1744 AASIM 18-Nov-04 Scanner 78 4727 east1752 Colleen 13-Jun-06 Speaker 20 7950 west1755 AASIM 6-Dec-06 Printers 40 4924 south1756 Emilee 20-Jul-04 Projector 13 4392 north1757 Ashley 29-Aug-06 Printers 20 4722 east1761 Zaret 7-Nov-04 Printers 77 8813 west1763 Ashley 20-Aug-05 Laptop -1 5735 south1766 AASIM 24-Jun-06 Projector 69 6639 north1770 Ashley 14-Nov-06 Projector -4 7755 east1776 Cristina 21-Dec-04 Printers 7 8045 west1780 Emilee 4-May-04 Projector 16 4962 south1791 Colleen 30-Mar-05 Laptop 82 8948 north1794 Emilee 30-Dec-05 Scanner 29 8738 east1797 Ashley 9-Sep-06 Printers -2 6374 west1800 Hallagan 13-May-05 Projector 46 6449 south1803 AASIM 6-Dec-06 Speaker 87 9789 north1805 Cristina 21-Dec-04 Projector 31 6164 east1808 Cristina 31-Jul-04 Printers -1 8791 west1809 Zaret 10-Mar-04 Speaker 5 9584 south1810 Cristina 22-May-06 Speaker 30 4313 north1812 AASIM 11-May-06 Scanner 14 5516 east1815 Betsy 19-Apr-06 Scanner 25 1071 west1816 Betsy 19-Mar-05 Speaker 11 9107 south1823 AASIM 26-Jun-05 Printers 12 3164 north1827 Ashley 13-Sep-04 Scanner 19 1137 east1830 AASIM 18-Aug-06 Printers -8 3126 west1831 AASIM 30-Mar-05 Printers 28 2891 south1835 Zaret 24-May-05 Projector 70 2253 north1840 Ashley 26-Jun-05 Projector 31 3703 east1841 Emilee 17-Mar-06 Scanner 36 8248 west1844 Cristina 4-May-04 Projector 46 5119 south1845 Cristina 20-Jul-04 Projector 29 7823 north1847 Emilee 13-Sep-04 Scanner 2 6701 east1850 Jen 15-May-04 Scanner 52 8332 west1852 Ashley 24-Sep-04 Speaker 36 3284 south1856 Hallagan 1-Feb-06 Scanner 53 6240 north1858 Ashley 7-Jul-05 Projector 95 1902 east1859 Colleen 22-Aug-04 Speaker -6 8400 west1862 Hallagan 8-Dec-05 Printers 18 8229 south

Page 84: Module 11 Integrating Macros With Your Reports

1865 Colleen 5-Jul-06 Projector -2 5556 north1866 Cristina 1-Oct-06 Projector -7 5945 east1868 Hallagan 10-Apr-05 Laptop 24 9153 west1872 Colleen 15-May-04 Projector 2 3557 south1873 AASIM 18-Nov-04 Projector 83 6427 north1874 Colleen 1-Jan-05 Printers 63 6389 east1878 Betsy 26-May-04 Printers 60 7568 west1880 Emilee 17-Dec-06 Printers 59 5198 south1886 Cristina 9-Aug-05 Scanner 89 2349 north1899 Hallagan 3-Nov-06 Laptop 28 2613 east

4 Hallagan 22-May-06 Printers 55 1447 west12 Ashley 18-Nov-04 Printers 23 7198 south13 Emilee 31-Aug-05 Printers 49 8588 north21 Zaret 2-Jun-06 Scanner 12 2057 east26 Emilee 6-Dec-06 Printers 24 8493 west33 AASIM 17-Jun-04 Scanner 41 1717 south34 Zaret 9-Sep-06 Scanner 19 9073 north39 AASIM 23-Feb-06 Projector -9 9063 east43 Betsy 1-Apr-04 Projector 86 5707 west47 Zaret 24-Sep-04 Laptop 14 3545 south49 Betsy 18-Nov-04 Projector 63 2939 north50 Zaret 18-Nov-04 Printers 1 7234 east54 Cristina 10-Apr-05 Printers 26 8880 west55 Jen 22-May-06 Printers 35 8167 south68 Zaret 16-Jul-06 Printers 0 6250 north71 Ashley 16-Nov-05 Speaker 93 6577 east74 Ashley 12-Apr-04 Scanner 48 1947 west76 Colleen 6-Mar-06 Projector -2 4873 south80 Jen 30-Mar-05 Scanner 16 6100 north83 AASIM 7-Nov-04 Projector 82 6993 east84 Ashley 1-Oct-06 Laptop 73 7943 west93 Zaret 12-Apr-04 Projector 62 1931 south96 Jen 17-Dec-06 Printers 33 4347 north

100 Betsy 3-Oct-05 Laptop 74 8102 east101 Zaret 15-Jan-04 Projector 67 6335 west103 Hallagan 13-May-05 Projector 90 8615 south104 Jen 17-Mar-06 Speaker -8 2383 north111 AASIM 5-Oct-04 Scanner 81 6664 east113 Emilee 6-Dec-06 Scanner 26 3566 west122 Jen 27-Jul-06 Scanner 10 4943 south124 Ashley 10-Jan-06 Laptop 57 3955 north126 Zaret 23-Apr-04 Laptop 54 4160 east129 Zaret 12-Feb-06 Scanner -10 9911 west130 Ashley 14-Nov-06 Projector -9 3872 south135 Cristina 14-Feb-05 Laptop 67 5370 north

Page 85: Module 11 Integrating Macros With Your Reports

136 Colleen 30-Mar-05 Printers 10 9808 east137 Emilee 27-Oct-04 Projector 40 4390 west138 Colleen 7-Jul-05 Scanner 77 2710 south142 Betsy 1-Feb-06 Printers -4 2911 north146 Emilee 7-Jul-05 Laptop 59 2502 east151 Emilee 7-Jul-05 Printers -8 9562 west153 AASIM 16-Oct-04 Speaker 63 6398 south156 Emilee 30-Dec-05 Projector 81 1169 north167 Betsy 21-Mar-04 Printers 21 2836 east171 Betsy 14-Oct-05 Projector 93 7190 west177 AASIM 20-Jul-04 Scanner 54 5298 south183 Hallagan 29-Nov-04 Projector 17 9668 north188 Jen 4-May-04 Scanner 79 6160 east189 Colleen 15-Jun-05 Projector 82 9697 west192 Cristina 3-Oct-05 Projector 72 7846 south194 Emilee 21-Jan-06 Laptop 8 2050 north198 Colleen 22-May-06 Scanner -4 4319 east199 Cristina 25-Nov-06 Scanner 81 9530 west203 AASIM 28-Dec-06 Printers 57 6976 south204 AASIM 18-Aug-06 Printers 86 2121 north205 Jen 19-Apr-06 Projector 14 7153 east208 Jen 5-Jul-06 Laptop 45 3845 west213 Jen 16-Nov-05 Printers 19 7937 south214 Zaret 12-Feb-06 Laptop 35 4595 north220 Ashley 15-Jan-04 Scanner 27 7224 east222 Ashley 20-Jul-04 Scanner 67 2703 west223 Betsy 13-Sep-04 Projector 94 9259 south224 Cristina 5-Oct-04 Laptop 52 3648 north225 Zaret 6-Feb-04 Speaker 24 2462 east229 AASIM 12-Apr-04 Printers 13 4495 west230 Hallagan 25-Nov-06 Printers 7 5922 south231 Zaret 21-Mar-04 Printers 64 1880 north238 Ashley 1-Jan-05 Printers 7 8739 east248 Zaret 20-Aug-05 Scanner 25 5703 west251 Colleen 4-May-04 Scanner 71 4273 south255 Ashley 1-Apr-04 Projector 15 1830 north258 Emilee 12-Jan-05 Laptop 77 7005 east264 Colleen 13-May-05 Projector 28 3719 west275 Hallagan 8-Dec-05 Laptop 59 1209 south277 Hallagan 12-Jan-05 Laptop 82 6557 north278 Betsy 8-Mar-05 Laptop 29 5201 east283 Emilee 26-May-04 Speaker 75 1473 west284 Emilee 22-Aug-04 Printers 79 8161 south289 Jen 7-Jul-05 Speaker 88 7887 north295 Betsy 27-Jul-06 Scanner 94 9869 east

Page 86: Module 11 Integrating Macros With Your Reports

305 Hallagan 14-Feb-05 Speaker 73 3084 west310 Zaret 7-Jul-05 Printers 83 6941 south321 Hallagan 16-Oct-04 Printers 9 2232 north329 Emilee 14-Oct-05 Laptop 38 3959 east331 AASIM 11-Aug-04 Laptop 10 4251 west333 Jen 17-Jun-04 Printers 68 1836 south335 Jen 4-Jun-05 Projector 17 7969 north336 Cristina 29-Nov-04 Projector 6 8074 east337 Cristina 11-May-06 Projector 27 7336 west339 Colleen 11-Aug-04 Scanner -1 8179 south346 Colleen 18-Nov-04 Printers 95 8020 north348 Hallagan 19-Apr-06 Scanner 69 5730 east350 Zaret 12-Feb-06 Speaker -4 4242 west351 Colleen 26-Jun-05 Speaker 21 6498 south359 Betsy 17-Dec-06 Speaker 44 8515 north365 Jen 22-May-06 Printers 88 3134 east367 Hallagan 9-Aug-05 Projector -8 9178 west370 Cristina 11-Sep-05 Printers 2 6294 south372 Ashley 3-Oct-05 Scanner 34 9446 north376 AASIM 21-Mar-04 Printers 7 6211 east377 Hallagan 6-Feb-04 Printers 7 1922 west379 Zaret 31-Jul-04 Projector 6 2116 south380 Cristina 23-Oct-06 Printers 43 1033 north381 AASIM 15-Jan-04 Scanner 20 3671 east385 AASIM 26-May-04 Projector 49 3068 west401 Cristina 8-Mar-05 Laptop 76 8885 south404 Cristina 13-May-05 Printers -5 5397 north407 Emilee 10-Mar-04 Printers 78 7195 east413 Hallagan 25-Feb-05 Projector 60 5881 west418 Betsy 23-Feb-06 Projector 46 3168 south422 Zaret 21-Jan-06 Laptop 77 6285 north424 Betsy 9-Aug-05 Speaker 45 9119 east427 Zaret 17-Dec-06 Scanner 43 2547 west428 Colleen 5-Oct-04 Laptop 41 9957 south432 Hallagan 9-Jul-04 Laptop 43 7492 north435 Jen 1-Feb-06 Projector 9 9623 east438 Cristina 23-Oct-06 Projector 15 6191 west439 AASIM 23-Oct-06 Laptop 27 1337 south443 Ashley 17-Feb-04 Scanner 0 2220 north453 Betsy 3-Oct-05 Speaker 2 1598 east455 Ashley 31-Aug-05 Printers 13 2657 west456 AASIM 1-Oct-06 Scanner 94 8513 south458 Zaret 13-Jun-06 Projector 45 5095 north461 Ashley 26-Jan-04 Scanner 48 3687 east463 Colleen 21-Apr-05 Printers 48 2363 west

Page 87: Module 11 Integrating Macros With Your Reports

482 Jen 10-Mar-04 Printers 4 9530 south485 Zaret 7-Nov-04 Projector 21 9779 north486 Jen 30-Mar-05 Scanner 44 6874 east487 Betsy 23-Jan-05 Laptop 75 2346 west494 Ashley 6-Mar-06 Scanner 21 4112 south499 Zaret 11-May-06 Projector 11 6481 north503 Ashley 7-Jul-05 Laptop 81 5862 east506 Jen 22-Sep-05 Speaker 75 3220 west507 Zaret 18-Jul-05 Scanner 87 8206 south508 AASIM 16-Jul-06 Projector 15 7771 north511 Jen 8-Apr-06 Laptop 56 9026 east520 Betsy 15-May-04 Projector 10 2679 west522 AASIM 11-May-06 Projector 75 2639 south523 Emilee 19-Mar-05 Laptop 77 4049 north524 Emilee 21-Mar-04 Laptop 10 1816 east525 Cristina 5-Oct-04 Projector 62 2050 west530 Hallagan 22-Aug-04 Scanner 57 3011 south532 Jen 14-Oct-05 Laptop 89 3347 north537 Emilee 1-Oct-06 Speaker 17 5938 east561 Zaret 1-Apr-04 Scanner 55 1790 west563 Ashley 20-Jul-04 Scanner 62 1735 south565 Hallagan 7-Nov-04 Speaker 12 5216 north566 Emilee 22-Aug-04 Scanner 0 4398 east567 AASIM 18-Aug-06 Laptop 23 4378 west569 Jen 4-Jun-05 Printers 73 7450 south575 Colleen 1-Jan-05 Scanner 84 2754 north576 Jen 30-Apr-06 Speaker 92 5249 east582 Cristina 5-Nov-05 Scanner 64 3533 west590 Hallagan 1-Feb-06 Printers 33 3700 south591 Ashley 15-Jan-04 Speaker -10 2860 north600 Emilee 17-Jun-04 Laptop 64 1392 east602 AASIM 2-Jun-06 Speaker 65 9324 west612 Hallagan 31-Aug-05 Scanner 2 6133 south619 Colleen 22-May-06 Printers 38 8220 north622 Ashley 17-Jun-04 Laptop 8 5877 east623 Colleen 1-Apr-04 Scanner -8 3546 west625 Jen 21-Jan-06 Laptop 83 3258 south626 Zaret 2-Jun-06 Projector 12 1191 north628 Betsy 12-Feb-06 Laptop 22 7416 east629 Cristina 3-Nov-06 Scanner -2 7797 west631 Jen 24-Jun-06 Laptop 40 3976 south647 Ashley 21-Mar-04 Laptop 20 3620 north654 Jen 21-Dec-04 Laptop 65 3625 east655 Jen 7-Jul-05 Printers 6 1664 west662 Emilee 3-Nov-06 Speaker 25 5698 south

Page 88: Module 11 Integrating Macros With Your Reports

664 Betsy 15-Jun-05 Printers 38 6585 north666 Jen 13-Jun-06 Laptop 59 4059 east667 AASIM 12-Feb-06 Projector 73 8231 west669 Cristina 5-Jul-06 Scanner 51 5182 south681 Betsy 13-Sep-04 Speaker 88 7983 north685 Jen 7-Aug-06 Laptop 82 3005 east687 Ashley 28-Dec-06 Printers 27 9766 west691 Betsy 10-Jan-06 Printers 25 8761 south695 Zaret 19-Mar-05 Speaker 0 2439 north698 Jen 13-Sep-04 Laptop 46 6983 east705 Ashley 15-Jun-05 Printers -1 9870 west710 Jen 22-Aug-04 Scanner 79 1913 south711 Ashley 9-Aug-05 Speaker 92 9702 north714 Cristina 23-Feb-06 Projector 31 9736 east716 Hallagan 25-Feb-05 Laptop 24 7599 west717 Ashley 12-Jan-05 Printers 50 2041 south718 Jen 12-Feb-06 Speaker 32 6391 north726 Cristina 7-Nov-04 Speaker 30 6909 east727 Zaret 3-Oct-05 Projector 27 4288 west730 Cristina 17-Mar-06 Printers -4 4504 south731 Betsy 20-Jul-04 Scanner -3 5277 north735 Betsy 2-May-05 Laptop 91 1324 east740 Cristina 26-May-04 Laptop 81 6230 west741 Betsy 12-Apr-04 Laptop 63 4356 south744 Jen 1-Apr-04 Printers 46 1325 north746 Colleen 22-May-06 Projector 68 5328 east748 Cristina 14-Feb-05 Laptop 51 6436 west749 AASIM 19-Apr-06 Projector 16 9010 south755 Hallagan 27-Jul-06 Scanner 16 6928 north756 AASIM 15-May-04 Printers 11 1427 east765 Jen 4-May-04 Printers -6 3653 west766 AASIM 1-Apr-04 Printers 5 1520 south772 Betsy 28-Feb-04 Scanner 12 3033 north774 Jen 30-Mar-05 Laptop 34 3872 east782 Cristina 14-Nov-06 Scanner 80 5704 west783 Betsy 25-Nov-06 Printers 64 8597 south787 Jen 3-Feb-05 Projector 36 2952 north789 Jen 24-May-05 Printers 48 1182 east791 AASIM 20-Jul-04 Speaker 8 3409 west793 AASIM 5-Nov-05 Scanner 93 7450 south798 Cristina 28-Dec-06 Scanner 72 7452 north810 Jen 5-Oct-04 Scanner 13 6896 east813 Colleen 4-Jun-05 Speaker 36 9775 west821 Zaret 20-Sep-06 Projector 83 3313 south822 AASIM 14-Oct-05 Scanner 2 8681 north

Page 89: Module 11 Integrating Macros With Your Reports

826 Jen 12-Oct-06 Projector 81 1823 east830 Jen 28-Mar-06 Scanner 41 6925 west835 Ashley 31-Aug-05 Projector 2 6786 south838 Cristina 6-Mar-06 Projector 54 4501 north840 Zaret 30-Apr-06 Laptop 94 2577 east842 Cristina 7-Nov-04 Scanner 9 7252 west846 Zaret 26-Jun-05 Projector 19 8798 south848 Jen 6-Jun-04 Laptop 18 1183 north850 Emilee 16-Oct-04 Projector 79 5146 east858 Jen 6-Dec-06 Scanner 28 9706 west859 Cristina 4-Jun-05 Printers 40 7002 south867 Zaret 17-Mar-06 Scanner 58 6527 north875 AASIM 16-Jul-06 Printers 45 6538 east876 Jen 17-Mar-06 Scanner 91 5570 west877 Emilee 23-Jan-05 Scanner 49 2889 south878 Betsy 24-Sep-04 Printers 68 8849 north879 Colleen 14-Feb-05 Speaker 38 2595 east890 Betsy 1-Feb-06 Printers 62 3103 west891 Emilee 16-Jul-06 Scanner 80 4752 south895 Cristina 10-Dec-04 Speaker 42 5168 north898 Emilee 18-Aug-06 Printers 24 4486 east904 Hallagan 20-Aug-05 Speaker 31 8525 west910 Emilee 19-Mar-05 Printers 94 2255 south912 Emilee 5-Jul-06 Scanner 57 1751 north914 AASIM 5-Jul-06 Printers 50 7218 east918 Emilee 22-May-06 Laptop 6 2616 west924 Ashley 6-Feb-04 Scanner 79 5285 south929 Zaret 10-Mar-04 Projector 58 2063 north932 AASIM 21-Jan-06 Projector 59 9340 east937 Ashley 29-Jul-05 Projector 83 1659 west939 Hallagan 28-Feb-04 Printers 14 5020 south940 Colleen 1-Jan-05 Speaker -9 6898 north944 Betsy 24-Sep-04 Printers -2 5506 east949 Cristina 6-Jun-04 Projector 13 1131 west951 Colleen 17-Jun-04 Projector 15 2484 south961 Cristina 10-Jan-06 Laptop 95 7033 north964 Hallagan 20-Sep-06 Projector 63 3947 east968 Zaret 8-Apr-06 Speaker 5 2695 west977 AASIM 12-Feb-06 Projector 19 6825 south978 Zaret 13-May-05 Scanner 67 7195 north985 Hallagan 29-Aug-06 Projector 72 9117 east986 Betsy 2-May-05 Speaker 47 4360 west988 Betsy 13-May-05 Printers 58 1011 south992 Jen 16-Nov-05 Laptop 34 6660 north993 Zaret 1-Apr-04 Printers 30 7342 east

Page 90: Module 11 Integrating Macros With Your Reports

996 Colleen 13-Sep-04 Laptop 4 4026 west997 Emilee 6-Jun-04 Printers 88 8528 south999 Ashley 14-Oct-05 Laptop 82 5787 north

1005 Emilee 9-Jul-04 Scanner 71 4717 east1006 Ashley 21-Mar-04 Speaker 70 7765 west1010 Zaret 24-Jun-06 Laptop 94 9793 south1012 Ashley 13-May-05 Printers 89 3506 north1026 Hallagan 24-Sep-04 Speaker 69 4653 east1028 AASIM 1-Feb-06 Laptop 0 6311 west1032 Betsy 17-Feb-04 Scanner -5 4868 south1034 Emilee 20-Sep-06 Laptop 9 3241 north1040 Cristina 28-Jun-04 Laptop -7 3180 east1041 Colleen 5-Jul-06 Scanner 24 2806 west1042 Jen 9-Sep-06 Projector 35 3120 south1043 AASIM 21-Mar-04 Projector 23 2914 north1055 Jen 7-Jul-05 Speaker 42 4736 east1068 AASIM 3-Oct-05 Projector 5 2889 west1072 Hallagan 18-Nov-04 Scanner 53 4094 south1082 Cristina 6-Mar-06 Projector 88 4147 north1084 Ashley 24-Sep-04 Printers -4 6528 east1095 Betsy 1-Apr-04 Laptop 66 7285 west1099 Emilee 17-Mar-06 Speaker 56 5231 south1103 AASIM 6-Mar-06 Scanner -2 9664 north1105 Emilee 5-Nov-05 Speaker -4 3003 east1108 Hallagan 8-Mar-05 Laptop 67 1453 west1109 Betsy 3-Feb-05 Scanner 27 8454 south1115 Cristina 12-Apr-04 Projector 11 1884 north1118 Jen 3-Nov-06 Scanner 78 8169 east1119 AASIM 6-Feb-04 Scanner -8 3274 west1121 Zaret 5-Oct-04 Projector 30 6886 south1128 Colleen 29-Jul-05 Printers 57 4173 north1132 AASIM 21-Apr-05 Printers 89 8142 east1134 Cristina 9-Sep-06 Scanner 43 7611 west1136 Emilee 12-Jan-05 Projector 51 3345 south1137 Betsy 22-May-06 Printers 17 7375 north1138 Hallagan 14-Nov-06 Scanner 51 1416 east1139 Jen 6-Mar-06 Laptop 14 6105 west1141 AASIM 18-Nov-04 Scanner -8 4389 south1157 Betsy 5-Oct-04 Speaker -1 8950 north1158 Colleen 29-Aug-06 Scanner 24 1074 east1161 Betsy 29-Jul-05 Printers 16 9003 west1165 Hallagan 24-Jun-06 Printers 83 9918 south1171 Betsy 14-Nov-06 Projector 71 1592 north1174 Hallagan 1-Feb-06 Speaker 72 9669 east1178 Emilee 6-Dec-06 Projector -8 7933 west

Page 91: Module 11 Integrating Macros With Your Reports

1187 Ashley 10-Mar-04 Printers 0 7907 south1193 Colleen 14-Feb-05 Laptop 5 6538 north1204 Cristina 6-Jun-04 Scanner 94 2969 east1207 Cristina 26-May-04 Printers 7 3044 west1209 Colleen 13-Sep-04 Printers 32 1035 south1210 Hallagan 27-Nov-05 Printers 8 8303 north1216 Zaret 13-Sep-04 Printers -1 6384 east1218 AASIM 17-Mar-06 Scanner 78 9628 west1223 Cristina 13-May-05 Laptop 42 1788 south1225 Jen 12-Apr-04 Speaker 93 1833 north1228 Emilee 5-Jul-06 Laptop 20 6231 east1234 Colleen 23-Feb-06 Scanner 22 6409 west1235 Colleen 10-Apr-05 Speaker 5 7935 south1237 Colleen 1-Apr-04 Laptop 6 6856 north1240 Cristina 11-May-06 Printers 20 2365 east1250 AASIM 1-Feb-06 Laptop 39 7391 west1260 Colleen 6-Feb-04 Projector -6 8584 south1262 Jen 23-Apr-04 Projector 14 6692 north1263 Jen 1-Oct-06 Projector 73 8038 east1268 Cristina 29-Nov-04 Projector 20 3652 west1269 Zaret 21-Dec-04 Printers 71 2591 south1270 Cristina 14-Oct-05 Laptop 66 7544 north1271 Hallagan 5-Oct-04 Projector 79 4109 east1273 Betsy 3-Oct-05 Projector 72 5818 west1280 Betsy 23-Jan-05 Speaker 79 7319 south1281 Jen 23-Jan-05 Projector 92 1869 north1286 Hallagan 4-Jun-05 Printers 33 6231 east1292 Betsy 30-Apr-06 Printers 72 6742 west1294 Ashley 6-Jun-04 Laptop 19 3778 south1296 Hallagan 29-Nov-04 Projector 80 7189 north1298 Zaret 7-Jul-05 Printers 93 2857 east1302 Colleen 9-Aug-05 Scanner 64 1104 west1304 Jen 16-Oct-04 Projector 21 1810 south1305 Hallagan 18-Jul-05 Laptop 61 8283 north1306 Zaret 4-May-04 Laptop 53 2659 east1309 Zaret 3-Nov-06 Printers 89 5595 west1312 Cristina 28-Dec-06 Projector 47 3806 south1318 Jen 12-Feb-06 Scanner 61 5841 north1319 Jen 20-Sep-06 Printers 12 2277 east1322 Ashley 21-Dec-04 Scanner 4 9134 west1339 Jen 7-Nov-04 Speaker 13 9614 south1340 Hallagan 13-Sep-04 Printers 24 9406 north1345 Cristina 10-Apr-05 Projector 28 9175 east1355 Ashley 21-Dec-04 Speaker 35 7765 west1356 AASIM 29-Jul-05 Projector 42 3997 south

Page 92: Module 11 Integrating Macros With Your Reports

1359 Ashley 24-May-05 Scanner 55 8880 north1360 Zaret 22-Sep-05 Printers 87 2633 east1362 Emilee 13-Jun-06 Projector 91 5838 west1368 Zaret 28-Jun-04 Speaker 29 7846 south1369 Hallagan 13-May-05 Projector 64 6922 north1370 Cristina 10-Mar-04 Printers 27 5197 east1371 AASIM 24-Sep-04 Printers 36 9936 west1372 Betsy 6-Dec-06 Scanner 36 5364 south1376 Zaret 23-Jan-05 Speaker 55 6785 north1379 Betsy 17-Dec-06 Projector 4 3485 east1382 Zaret 25-Oct-05 Laptop 14 6733 west1385 Betsy 31-Jul-04 Printers 47 3925 south1387 Colleen 20-Sep-06 Laptop 21 4483 north1398 Hallagan 15-May-04 Laptop 64 7208 east1401 Emilee 20-Sep-06 Printers 6 5393 west1405 Jen 16-Oct-04 Printers 4 4638 south1408 Emilee 8-Dec-05 Printers 87 7075 north1413 Betsy 18-Aug-06 Printers 70 7509 east1418 Ashley 17-Feb-04 Scanner 62 4014 west1421 Hallagan 12-Oct-06 Laptop 13 5683 south1423 Cristina 21-Jan-06 Laptop 49 9838 north1426 Jen 22-Sep-05 Scanner 45 4503 east1431 Jen 30-Apr-06 Projector 52 9987 west1435 AASIM 30-Apr-06 Laptop 67 5967 south1436 Zaret 14-Oct-05 Scanner 7 5752 north1442 Hallagan 21-Jan-06 Projector 57 5545 east1443 Cristina 24-Sep-04 Printers 69 4562 west1447 Colleen 17-Jun-04 Scanner 43 5712 south1448 Jen 23-Oct-06 Printers 69 5982 north1450 Zaret 5-Nov-05 Laptop 70 6210 east1456 Ashley 2-Sep-04 Scanner 21 1416 west1459 Cristina 21-Jan-06 Speaker 92 5062 south1460 Zaret 23-Oct-06 Printers -1 7930 north1465 Zaret 21-Dec-04 Projector 80 5274 east1468 Betsy 2-Jun-06 Laptop 45 4137 west1470 Ashley 3-Oct-05 Laptop 51 8463 south1472 Betsy 7-Nov-04 Laptop 15 6971 north1474 Emilee 11-May-06 Laptop 31 2980 east1480 Colleen 9-Jul-04 Laptop 29 1275 west1482 Emilee 28-Mar-06 Laptop 48 5574 south1486 Jen 13-May-05 Printers 69 1861 north1488 Cristina 23-Jan-05 Scanner 38 2415 east1490 Colleen 2-Sep-04 Projector 79 9049 west1492 Colleen 21-Dec-04 Projector 67 1057 south1494 Ashley 14-Oct-05 Printers 71 2201 north

Page 93: Module 11 Integrating Macros With Your Reports

1495 Betsy 23-Oct-06 Projector 15 1875 east1501 AASIM 26-Jan-04 Printers 5 3925 west1502 Emilee 10-Jan-06 Printers 33 8593 south1507 Colleen 27-Nov-05 Printers -3 4833 north1522 Zaret 12-Apr-04 Laptop 51 2569 east1524 Betsy 19-Apr-06 Printers 38 6083 west1526 Hallagan 23-Oct-06 Laptop 20 4987 south1527 Cristina 7-Jul-05 Printers 25 5427 north1528 Betsy 23-Oct-06 Laptop -6 1306 east1532 AASIM 10-Mar-04 Speaker 66 8450 west1533 Emilee 7-Nov-04 Projector 34 1707 south1536 Cristina 19-Dec-05 Projector 16 2110 north1537 Jen 20-Aug-05 Speaker 45 1968 east1541 Ashley 7-Jul-05 Laptop 46 8618 west1543 Zaret 29-Nov-04 Scanner 59 6009 south1544 Zaret 21-Apr-05 Speaker 84 4157 north1545 Zaret 24-Jun-06 Laptop 91 5527 east1546 Cristina 10-Mar-04 Printers 33 3450 west1548 Zaret 23-Oct-06 Printers 1 2143 south1549 Hallagan 28-Feb-04 Laptop 42 6046 north1553 Zaret 27-Jul-06 Laptop -5 9887 east1558 Colleen 15-Jan-04 Scanner 44 6382 west1560 Betsy 31-Aug-05 Printers 25 2654 south1562 Cristina 11-May-06 Laptop 59 3775 north1567 Hallagan 20-Aug-05 Scanner 89 7031 east1569 AASIM 12-Jan-05 Speaker 52 5040 west1572 Zaret 18-Nov-04 Laptop 45 3866 south1576 Hallagan 5-Nov-05 Projector 33 1051 north1585 Hallagan 20-Aug-05 Projector 56 7057 east1587 Ashley 12-Jan-05 Printers 95 3566 west1590 Emilee 8-Dec-05 Scanner 29 2832 south1594 Hallagan 16-Jul-06 Projector 86 4631 north1596 Hallagan 14-Feb-05 Laptop 13 2965 east1600 AASIM 14-Nov-06 Speaker 11 5126 west1603 Emilee 17-Jun-04 Printers 25 7491 south1604 Cristina 27-Nov-05 Projector 94 9878 north1606 Zaret 15-Jun-05 Speaker 15 1200 east1611 Colleen 1-Apr-04 Laptop 12 8449 west1615 Zaret 3-Feb-05 Scanner 25 1013 south1622 Emilee 22-Sep-05 Laptop 88 6654 north1623 Emilee 12-Apr-04 Laptop 35 1433 east1625 Hallagan 29-Jul-05 Laptop 95 3220 west1635 Hallagan 5-Oct-04 Printers 78 9361 south1645 Cristina 3-Feb-05 Laptop 23 2239 north1647 Cristina 21-Dec-04 Scanner 86 2445 east

Page 94: Module 11 Integrating Macros With Your Reports

1649 Ashley 19-Apr-06 Scanner 54 8749 west1652 Zaret 12-Oct-06 Speaker 84 4822 south1655 Betsy 15-Jan-04 Printers 25 8998 north1657 AASIM 12-Apr-04 Speaker 75 4841 east1659 Cristina 19-Dec-05 Printers 48 3964 west1660 Colleen 15-May-04 Projector 73 3130 south1662 Ashley 27-Nov-05 Laptop 12 2105 north1672 Hallagan 4-Jun-05 Printers 28 6755 east1681 Jen 24-Jun-06 Scanner 23 4284 west1688 Emilee 2-Jun-06 Scanner 11 2273 south1696 Hallagan 6-Jun-04 Printers 48 1468 north1705 Hallagan 19-Dec-05 Laptop 0 4880 east1708 AASIM 30-Apr-06 Laptop 65 8967 west1711 Colleen 28-Mar-06 Printers 72 7865 south1713 Emilee 8-Dec-05 Printers 40 4302 north1721 Ashley 20-Aug-05 Projector 67 3816 east1725 Colleen 29-Jul-05 Laptop 53 6077 west1732 Cristina 25-Nov-06 Scanner 6 6744 south1741 Ashley 17-Feb-04 Scanner 43 2480 north1746 Emilee 4-Jun-05 Scanner -3 6149 east1747 Hallagan 23-Apr-04 Projector 34 9593 west1749 Cristina 16-Nov-05 Projector 70 8519 south1753 Jen 15-May-04 Scanner 33 4056 north1758 Emilee 28-Feb-04 Laptop 22 2636 east1771 Betsy 18-Aug-06 Printers 14 3960 west1775 Betsy 1-Jan-05 Projector 91 7337 south1782 AASIM 1-Oct-06 Printers 38 3298 north1785 Emilee 14-Nov-06 Laptop 9 9748 east1789 Cristina 8-Dec-05 Printers 83 9612 west1793 AASIM 4-Jan-04 Printers 66 9174 south1801 Emilee 28-Dec-06 Projector 93 5752 north1811 Hallagan 19-Apr-06 Laptop 65 8999 east1813 AASIM 27-Nov-05 Projector 10 5807 west1817 Betsy 15-Jan-04 Projector 62 5602 south1818 Ashley 26-Jan-04 Projector 4 4189 north1822 Emilee 21-Apr-05 Printers 19 1288 east1832 Zaret 22-Sep-05 Scanner 81 1200 west1839 Cristina 7-Jul-05 Scanner 85 3387 south1843 Colleen 29-Jul-05 Scanner 27 4744 north1848 Betsy 24-Jun-06 Projector 60 3025 east1864 Emilee 10-Dec-04 Laptop 62 9443 west1870 Hallagan 25-Nov-06 Scanner 49 1239 south1876 Colleen 13-Sep-04 Printers 19 9463 north1884 Hallagan 22-May-06 Printers 89 2799 east1885 Ashley 11-May-06 Printers 12 9919 west

Page 95: Module 11 Integrating Macros With Your Reports

1888 Colleen 18-Jul-05 Laptop 24 4983 south1889 Emilee 25-Nov-06 Laptop 76 6686 north1892 AASIM 23-Feb-06 Scanner 92 4169 east1897 Colleen 5-Nov-05 Printers 46 6181 west1898 Zaret 15-Jan-04 Speaker 72 6254 south