A way to plan Packet Canvassing with the GOP Primary Voter List

1.         Copy your streets labeled precinct map.

2.         Draw zones or sections of the map that apply for canvassing.

3.         Label the zones with a pencil using the alphabet. I planned 8 zones A-H.

4.         Type a sheet with the zones/streets matching. Example; Zone A with the appropriate streets, etc.

5.         Using an Excel spread sheet, open the software for the Primary Voter List.

6.         Copy it to another Excel spread sheet and use it to work with so you will have a backup.

7.         Sort the voter list using STREET (alpha identifier) behind the street number. Some voters have a mailing name for a different location. You can use that column if no different address applies.

8.         Begin at the top of the list of the first voter and look for their STREET name and look on your sheet of the zoned streets. Place the found zone ID at the end of the voter line and mark it with yellow hi-lite or print it red (my choice because I could not get the hi-lite to work).

9.         When you have finished all of the voter’s zones, you can sort using the zone column and have the zones separate.

10.         Copy and paste the individual zones on separate spreads so you can print each zone for the Zone Captain.

11.         Go through each zone by putting the number 1 (for one packet) in the column next to the zone of the voter at the end of the line. Omit marking voters where there is more than one voter per household.

12.         Total the 1s you listed using the Excel calculation for each zone.

13.         Calculate the total of packets you need for distribution.

14.         Take water and snacks and get ready for the Victory Party.

EXAMPLE:

Name-Last,First

House #

Street

Mailing_Address

Pct.

Party

Date voted

Code

Zone

Packets

BASS, LISA

24

 GREENTWIG PL

24 GREENTWIG PL THE WOODLANDS, TX 77381

49

REP

3/6/2018

P

A

1

BASS, RANDALL

24

 GREENTWIG PL

24 GREENTWIG PL THE WOODLANDS, TX 77381

49

REP

3/6/2018

P

A

BROWN, DALE

12

 GREENTWIG PL

12 GREENTWIG PL THE WOODLANDS, TX 77381

49

REP

3/6/2018

P

A

1

 

 

 

 

 

 

 

 

TOTAL

2