Laserfiche WebLink
_ collection sheet,such as the one in the exhibit below,can be used to record zip codes by hand. <br /> As clerks check out customers,they can enter their zip codes on the sheet. While it is more <br /> labor intensive,the trade area definition sheet also offers the ability to recorded additional <br /> information with the zip code(such as date,time,gender, age range,and amount of sale). <br /> Example of a Trade Area Definition Data Collection Sheet <br /> Community <br /> Business <br /> Trade Area Definition Data Collection Sheet3272 <br /> Amount Sex Age Day Time Day <br /> of Sale M F 1 2 3 4 5 6 1 2 1 2 3 <br /> <20 20-29 30-39 40-49 50-59 60+ Wkday Wkend Morn 12-5 Eve <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> `N.- M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F I 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> M F 1 2 3 4 5 6 1 2 1 2 3 <br /> (SRI UW-Extension Center for Community Economic Development and the UW System Board of Regents All lights reserved. <br /> Once zip codes have been collected,they can be entered into a spreadsheet program such as <br /> Microsoft Excel.The spreadsheet allows categorizing customers by the number and percentage <br /> of people originating in each zip code. The zip code percentages can then be grouped together <br /> to construct a trade area. Most often,the trade area is defined as those with zip codes that <br /> comprise about 75 percent of total customers. If you are creating both convenience and <br /> destination trade areas,you will need to create two separate tables. <br /> Return to top <br /> 19 <br />