﻿SHEETS: Database Fields, Transportation Report, Sorting Report by Client, Sort Report by Date, Current Data

=== Database Fields ===
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TMB Training | TMB Reachout
 | Bold | is a database field
 | Red | Is a database field looked up from another table or calculated
 | Blue | Is field type
Municipality Table
 | JurisCode |  |  |  | Lookup |  |  | Lookup from Clerk List
 | Municipality Name |  |  |  | Lookup |  |  | Lookup from Clerk List
 | Address |  |  |  | Lookup |  |  | Lookup from Clerk List
 | County |  |  |  | Lookup |  |  | Lookup from Clerk List
 | Phone Number |  |  |  | Alpha Numeric |  |  | Data Entry for now
 | Delivery Address if different from BRE |  |  |  | Alpha Numeric |  |  | Data Entry
 | PS Cust # |  |  |  | Alpha Numeric |  |  | Data Entry for now
 | PCS # |  |  |  | Alpha Numeric |  |  | Data Entry for now
 | NetSort FC # |  |  |  | Alpha Numeric |  |  | Data Entry
 | NetSort NP/STD # |  |  |  | Alpha Numeric |  |  | Data Entry
 | CRID |  |  |  | Alpha Numeric |  |  | Data Entry
 | NP Auth# |  |  |  | Alpha Numeric |  |  | Data Entry
 | Contact name 1 (primary) |  |  |  | Alpha Numeric |  |  | Data Entry
 | Contact email 1 (snailworks) |  |  |  | Alpha Numeric |  |  | Data Entry
 | Contact name 2 |  |  |  | Alpha Numeric |  |  | Data Entry
 | Other Contact emails |  |  |  | Alpha Numeric |  |  | Data Entry
Election Table | JurisCode |  |  |  | Lookup |  |  | Lookup from Municipality Table
 | Municipality Name |  |  |  | Lookup |  |  | Lookup from Municipality Table
 | Contact name 1 (primary) |  |  |  | Lookup |  |  | Lookup from Municipality Table
 | Contact email 1 (snailworks) |  |  |  | Lookup |  |  | Lookup from Municipality Table
 | Contact name 2 |  |  |  | Lookup |  |  | Lookup from Municipality Table
 | Other Contact emails |  |  |  | Lookup |  |  | Lookup from Municipality Table
 | Addressing | Y/N |  |  |  |  |  | Data Entry
 |  | If Y | Addressing Qty | Qty |  |  |  | Data Entry | Default from last election
 |  | If Y | Data Files Scheduled | Date |  |  |  | Data Entry
 |  | If Y | KCI Env Purple | Y/N |  |  |  | Data Entry | Default from last election
 |  | If Y | Customer Envelope PU Date | Date |  |  |  | Data Entry
 |  | If Y | Proof Sent | Date |  |  |  | Data Entry
 |  | If Y | Proof Approved | Date |  |  |  | Data Entry
 |  | If Y | KCI Purple Env Delivery | Date |  |  |  | Data Entry
 |  | If Y | Office Copies | Qty |  |  |  | Data Entry
 |  | If Y | Address File Tracking | Y/N |  |  |  | Data Entry | Default from last election
 |  |  | If Y | Snailworks login created | Date / Prevously setup |  |  | Data Entry
 |  | If Y | KCI Provided Blue | Y/N |  |  |  | Data Entry
 |  |  | If Y | Blue Quantity | Qty |  |  | Calculated | Total of other quantities
 |  |  | If Y | KCI Blue Generic | Qty |  |  | Data Entry
 |  |  | If Y | KCI Blue NP Permit | Qty |  |  | Data Entry
 |  |  | If Y | KCI Blue Custom | Qty |  |  | Data Entry
 |  |  | If Y | Blue KCI Delivery Date | Date |  |  | Data Entry
 | KCI Sorting | Y/N
 |  | If Y | Sort Qty | Qty |  |  |  | Data Entry | Default from last election
 |  | If Y | Ballot Sort PU Date | Date |  |  |  | Data Entry
 |  | If Y | MailDate | Date |  |  |  | Data Entry
 |  | If Y | Class | NP / Std / First |  |  |  | Data Entry | Default from last election
 |  | If Y | Sort File Tracking | Y/N |  |  |  | Data Entry
 |  | If Y | Daily Sort | Y/N |  |  |  | Data Entry | Default from last election
 |  | If Y | Permit/Meter | Permit / Meter |  |  |  | Data Entry | Default from last election
 |  | If Y | Tray Delivery Date | Date |  |  |  | Data Entry

=== Transportation Report ===
Transportation Report
Can we output in an Excel or CSV file?
Run by date - all dates today or greater - sort by date earliest to latest
Run for all dates that exist in Customer Envelope PU Date or Blue KCI Delivery Date or Tray Delivery Date or Ballot Sort PU Date
Date 1
 | County | sort alpha
 |  | Municipality Name | sort apha
 |  | JurisCode
 |  | Address
 |  | County
 |  | Delivery Address if different from BRE
 |  | Phone Number
 |  | Contact name 1 (primary)
 |  | Contact email 1 (snailworks)
 |  | Contact name 2
 |  | Other Contact emails
 |  | Customer Envelope Pickup
 |  | If Customer Envelope PU Date = Date 1 | Addressing Qty
 |  | Blue Envelope Delivery
 |  | If Blue KCI Delivery Date = Date 1 | Blue Quantity
 |  | Tray Delivery Date
 |  | if Tray Delivery Date = Date 1 | Create note to deliver trays
 |  | Ballot Pickup Date (sorting)
 |  | if Ballot Sort PU Date = Date 1 | Sort Qty
Date 2 = next date after date 1
 | County | sort alpha
 |  | Municipality Name | sort apha
 |  | JurisCode
 |  | Address
 |  | County
 |  | Delivery Address if different from BRE
 |  | Phone Number
 |  | Contact name 1 (primary)
 |  | Contact email 1 (snailworks)
 |  | Contact name 2
 |  | Other Contact emails
 |  | Customer Envelope Pickup
 |  | If Customer Envelope PU Date = Date 2 | Addressing Qty
 |  | Purple Envelope Delivery
 |  | If KCI Purple Env Delivery = Date 2 | Addressing Qty
 |  | Blue Envelope Delivery
 |  | If Blue KCI Delivery Date = Date 2 | Blue Quantity
 |  | Tray Delivery Date
 |  | if Tray Delivery Date = Date 2 | Create note to deliver trays
 |  | Ballot Pickup Date (sorting)
 |  | if Ballot Sort PU Date = Date 2 | Sort Qty
Date 3â€¦...

=== Sorting Report by Client ===
Sorting Report by Municipality
Can we output in an Excel or CSV file?
Run for all KCI Sorting = Y
 | Municipality Name | sort apha
 | Contact name 1 (primary)
 | Contact email 1 (snailworks)
 | Contact name 2
 | Other Contact emails
 | MailDate
 | Ballot Sort PU Date
 | Sort Qty
 | Class
 | Sort File Tracking | 
 | Daily Sort
 | Permit/Meter
 | PS Cust #
 | PCS #
 | NetSort FC #
 | NetSort NP/STD # | 
 | CRID
 | NP Auth#

=== Sort Report by Date ===
Sorting Report by Mail Date
Can we output in an Excel or CSV file?
Run for all KCI Sorting = Y
 | Municipality Name
 | Contact name 1 (primary)
 | Contact email 1 (snailworks)
 | Contact name 2
 | Other Contact emails
 | MailDate | sort earliest to latest
 | Ballot Sort PU Date
 | Sort Qty
 | Class
 | Sort File Tracking | 
 | Daily Sort
 | Permit/Meter
 | PS Cust #
 | PCS #
 | NetSort FC #
 | NetSort NP/STD # | 
 | CRID
 | NP Auth#

=== Current Data ===
JurisCode | Municipality Name | County | PS Cust # | PCS # | Addressing | Tracking | Class | NetSort FC # | NetSort NP/STD # | CRID | NP Auth# | KCI Env | Env P-UpDate | Data Files | Return Env | KCI Sorting | Daily Sort | Permit/Meter | MailDate | Contacted? | Proof Sent | Proof Approved | SnailworksLogin | Contact email 1 (snailworks) | Other Contact emails | Contact name 1 (primary) | Contact name 2 | TMB Training | TMB Reachout
1160 | Algoma Twp | Kent | 10861 | 10861 |  | N | NP |  | 201160 | 2467155 | 1835562 | Yes |  |  |  |  |  | meter |  |  |  |  |  | dclerk@algomatwp.org |  | Heidi McCann |  |  | 
1360 | Allendale Twp | Ottawa | 4736 | 47361 |  | Y | NP | 401360 | 201360, 101360 | 8083010 | 1000085 | Yes |  |  |  |  |  | meter |  |  |  |  |  | clerk@allendalemi.gov |  | Jody Hansen |  |  | 
1840 | Alpine Twp | Kent | 5665 | 5665 |  | Y | NP |  | 201840 | 2409356 | 1928026 | Yes |  |  |  |  |  | meter |  |  |  |  |  | M.Jespersen@alpinetwp.org |  | Michelle Jespersen |  |  | 
8940 | Blendon Twp | Ottawa | 11791 | 11791 |  | n | NP |  | 208940 | 8083009 | 1882388 | yes |  |  |  |  |  | meter |  |  |  |  |  | Clerk@blendontownship-mi.gov | deputyclerk@blendontownship-mi.gov | Robin Overway | Jennifer Mokma |  | 
9110 | Bloomfield Township | Oakland | N/A | N/A |  | Kit Promi | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  |  |  | N/A |  |  |  |  |  | dmondock@bloomfieldtwp.org |  | Deana Mondock |  |  | 
12240 | Byron Twp | Kent | 6667 | 6667 |  | n | NP |  | 112240 | 2409448 | 771449 | Yes |  |  |  |  |  | permit |  |  |  |  |  | peggy@byrontownship.org | Heather@byrontownship.org | Peggy Sattler |  |  | 
12500 | Caledonia Twp | Kent | 6336 | 6336 |  | n | NP | 412500 | 212500 | 23692775 | 1833695 | yes |  |  |  |  |  | meter |  |  |  |  |  | sskidmore@caledoniatownship.org |  | Stephanie Skidmore |  |  | 
13080 | Cannon Twp | Kent | 9488 | 9488 |  | n | NP | 413080 | 213080 | 2466477 | 1837258 | Yes |  |  |  |  |  | meter |  |  |  |  |  | nancyp@CANNONTWP.ORG |  | Nancy Popma |  |  | 
13120 | Canton Twp | Wayne | 10756 | dont need |  | N | N/A | N/A | N/A |  | N/A | Yes |  |  |  |  |  | N/A |  |  |  |  |  | not tracking | katherine.baker@cantonmi.gov | Katie Baker |  |  | 
13660 | Cascade Charter Twp | Kent | 8898 | 8898 |  | N | NP | 413660 | 213660, 113660 | 6857595 | 1835610 | YES |  |  |  |  |  | meter |  |  |  |  |  | jjager@cascadetwp.org |  | Jennifer Jager |  |  | 
17680 | Charter Township of Comstock | Kalamazoo | 12792 | 12792 | yes | YES | std |  | 217680 | 7781407 | N/A | no | 46107 | 46090 |  |  |  | meter |  |  |  |  |  |  |  |  |  |  | 
59000 | Charter Township of Northville | Wayne | N/A | N/A |  | Kit Promi | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  |  |  | N/A |  |  |  |  |  | kanderson@twp.northville.mi.us |  | Katie Anderson |  |  | 
5920 | City of Battle Creek | Calhoun | 9307 | 9307 |  | Y | std |  | 205920 | 12729386 | N/A | no |  |  |  |  |  | meter |  |  |  |  |  | vlhouser@battlecreekmi.gov | cityclerk@battlecreekmi.gov | Victoria Houser |  |  | 
17020 | City of Coldwater | Branch | 12544 | 12544 |  | Y | NP |  | 217020 | 3179938 | 876699 | No |  |  |  |  |  |  |  |  |  |  |  | schavez@coldwater.org |  | Shauna Chavez |  |  | 
24120 | City of East Lansing | Ingham | 9090 | 9090 | yes | n | NP | 424120 | 224120 | 4365352 | 613996 | Yes | 46107 | 46090 | 46100 | yes | yes | Meter | 46108 | yes |  |  |  | agordon@cityofeastlansing.com |  | Amy Gordon |  |  | 
27380 | City of Farmington | Oakland | 12704 | 12704 |  | n | std |  | 227380 | 42044680 | STD mail | Yes |  |  |  |  |  | meter |  |  |  |  |  | mbachman@farmgov.com |  | Meaghan Bachman |  |  | 
27440 | City of Farmington Hills | Oakland | 9218 | 9218 |  | N | NP |  | 227440 | 3569620 | 716814 | no |  |  |  |  |  | meter |  |  |  |  |  | ahopper@fhgov.com |  | Ashley Hopper |  |  | 
33340 | City of Grand Haven | Ottawa | 3446 | 3446 |  | n | NP |  | 233340 | 5016184 | 919979 | n |  |  |  |  |  | meter |  |  |  |  |  | mariaboersma@grandhaven.org |  | Maria Boersma |  |  | 
33420 | City of Grand Ledge | Eaton | 11535 | 11535 |  | y |  | 433420 | 233420, 133420 | 31216124 | 1835615 | Y |  |  |  |  |  |  |  |  |  |  |  | gnewman@cityofgrandledge.com | DHengesbach@cityofgrandledge.com | Gregory Newman |  |  | 
34000 | City of Grand Rapids | Kent | 11988 | 11988 |  | Yes | NP | 434000 | 234000, 134000 | 5098256 | 727255 | N |  |  |  |  |  |  |  |  |  |  |  | jhondorp@grand-rapids.mi.us | amorgan@grand-rapids.mi.us | Joel Hondorp |  |  | 
34160 | City of Grandville | Kent | 5602 | not yet |  | y | NP | 434160 | 134160 | 3376063 | 719553 | n |  |  |  |  |  | meter |  |  |  |  |  | poleym@cityofgrandville.com |  | Marci Poley | Brittany Cooley |  | 
35520 | City of Grosse Pointe Farms | Wayne | 12637 |  |  | n |  |  |  |  |  | yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 
39800 | City of Hudsonville | Ottawa | 7332 | 7332 |  | n | NP |  | 239800 | 2410934 | 1006657 | Yes |  |  |  |  |  | meter |  |  |  |  |  | Jgruppen@hudsonville.org |  | Jill Gruppen |  |  | 
40000 | City of Huntington Woods | Oakland | 11991 | 11991 |  | n | NP | 440000 | 240000 | 3804310 | 1836644 | no |  |  |  |  |  | meter |  |  |  |  |  | hbarckholtz@hwmi.org |  | Heidi Barckholtz |  |  | 
42160 | City of Kalamazoo | Kalamazoo | 11792 | 11792 |  | no | n/a |  | 242160 | 42032302 | N/A | Yes |  |  |  |  |  | n/a |  |  |  |  |  | mcmillonam@kalamazoocity.org |  | Amanda McMillon |  |  | 
46000 | City of Lansing | Ingham | 9159 | 91502 |  | Yes | NP | 446000 | 246000, 146000 | 3030341 | 719997 | No | 46107 | 46083 | tbd/insert test | yes | yes | permit | 46108 | yes |  |  |  | chris.swope@lansingmi.gov | Robin.Stites@lansingmi.gov | Chris Swope |  |  | 
49000 | City of Livonia | Wayne | 9530 | dont need |  | N | NP | N/A | N/A |  | N/A | no |  |  |  |  |  |  |  |  |  |  |  | lmiller@livonia.gov | ddemarco@livonia.gov | Lori Miller |  |  | 
50560 | City of Madison Hts | Oakland | 12734 | dont need |  | n | NP |  |  |  |  | no |  |  |  |  |  | n/a |  |  |  |  |  | CherylRottmann@Madison-Heights.org |  | Cheryl Rottman |  |  | 
55280 | City of Montrose | Genesee | N/A | N/A |  | Kit Promi | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  |  |  | N/A |  |  |  |  |  | CLERK@CITYOFMONTROSE.US |  | Tina Rush |  |  | 
56320 | City of Muskegon | Muskegon | 10532 | 10532 |  | N | NP/Out of state FC |  | 256320 | 4711835 | 721891 | No | 45004 |  |  |  |  | meter |  |  |  |  |  |  |  | Shelly Stibitz |  |  | 
58980 | City of Northville | Wayne | 11434 | 11434 |  | Y | std |  | 258980 | 2630908 |  | Yes |  |  |  |  |  | meter |  |  |  |  |  | msmith@ci.northville.mi.us |  | Mike Smith |  |  | 
59140 | City of Norton Shores | Muskegon | 8905 | 89051 |  | N | NP |  | 259140, 159140 | 2835194 | 718268 | No |  |  |  |  |  | METER |  |  |  |  |  |  |  | Rachel Pavlich |  |  | 
59440 | City of Novi | Oakland | 9222 | 9222 |  | n | NP |  | 259440 | 2725509 | 718944 | No |  |  |  |  |  | meter |  |  |  |  |  |  |  |  |  |  | 
59920 | City of Oak Park | Oakland | 12729 | 12729 |  | N | NP |  | 259920 | 4119986 | 765065 | Yes |  |  |  |  |  | meter |  |  |  |  |  | jlwilliams@oakparkmi.gov | enorris@oakparkmi.gov | Ed Norris | Jo Lynn Williams-Elliott |  | 
65060 | City of Plymouth | Wayne | 10762 | dont need |  | Yes | Confirm |  |  |  | N/A | yes |  |  |  |  |  | N/A |  |  |  |  |  | sbridgman@plymouthmi.gov | nanderson@plymouthmi.gov | Sydney Bridgman | Nancy Anderson |  | 
69080 | City of Rockford | Kent | 5942 | 59421 |  | n | NP |  | 269080 | 36543032 | 1916530 | no |  |  |  |  |  | meter |  |  |  |  |  |  |  | Kris Murphy |  |  | 
69420 | City of Romulus | Wayne | 9385 | dont need |  | Y | n/a |  |  |  |  | no |  |  |  |  |  | n/a |  |  |  |  |  | dhockenhull@romulusgov.com | ebragg@romulusgov.com | Dâ€™Sjonaun Hockenhull | Ellen Craig-Bragg |  | 
70040 | City of Royal Oak | Oakland | 9179 | 9179 |  | Yes | NP | 370040 | 170040, 270040 | 4581404 | 698086 | YES |  |  |  |  |  | Mix/Meter out of region, permit in region |  |  |  |  |  | DeannaB@romi.gov |  | Deanna Braswell |  |  | 
79000 | City of Taylor | Wayne | N/A | N/A |  | Kit Promi | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  |  |  | N/A |  |  |  |  |  | sel-rifaai@ci.taylor.mi.us |  | Sara El-Rifaai |  |  | 
80700 | City of Troy | Oakland | 9939 | 9939 |  | n | NP | 480700 | 180700 | 2414883 | 727724 | no |  |  |  |  |  | meter |  |  |  |  |  | Cheryl.Stewart@troymi.gov |  | Cheryl Stewart |  |  | 
82960 | City of Walker | Kent | 2301 | 82960 |  | n | NP | 482960 | 282960 | 3415884 | 915252 | yes |  |  |  |  |  |  |  |  |  |  |  | jmarion@walker.city |  | Jessica Marion |  |  | 
84000 | City of Warren | Macomb | 10606 | run LS job |  | N | NP P127 |  | 184000 | 5175213 | 714827 | n/a |  |  |  |  |  | 127 Theirs |  |  |  |  |  | sBuffa@cityofwarren.org |  | Sonja Buffa |  |  | 
88940 | City of wyoming | Kent | 4003 | 40031 |  | n | NP | 388940 | 288940 | 7579559 | 766179 | yes | 46107 |  |  | y |  | meter |  |  |  |  |  |  |  | Kelli VandenBerg | Rhonda Galligan |  | 
89260 | City of Zeeland | Ottawa | 11188 | 11188 |  | n | std |  | 289260 | 8083005 | N/A | YES |  |  |  |  |  | meter |  |  |  |  |  | CHumphrey@cityofzeeland.com |  | Cindy Humphrey |  |  | 
18500 | Courtland twp | Kent | 4245 | 4245 |  | n | NP |  | 218500 | 14380003 | 765302 | yes |  |  |  |  |  | meter |  |  |  |  |  | clerk@courtlandtwpmi.gov |  | Susan Hartman |  |  | 
19660 | Dalton Township | Muskegon | 8986 | 8986 |  | no | NP |  | 119660/219660 | 29384512 | 1833688 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 
21420 | Delhi Township | Ingham | 11870 | 11870 | yes | n | NP |  | 221420 | 3150019 | 793190 | YES | 46111 | 46090 | 46097 | y |  | meter |  |  |  |  |  | evan.hope@delhitownshipmi.gov | gloria.loongo@delhitowshipmi.gov | Evan Hope | Gloria Loongo |  | 
23800 | East Bay Twp | Grand Traverse | 9540 | dont need |  | Y | NP |  |  |  |  | no |  |  |  |  |  |  |  |  |  |  |  | scourtade@eastbaytwp.org | HCouturier@eastbaytwp.org | Sue Courtade | Holly Couturier |  | 
26320 | Erie Township | Monroe | N/A | N/A |  | Kit Promi | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  |  |  | N/A |  |  |  |  |  | kcousino@erietownship.com |  | Kimberly Cousino |  |  | 
31240 | Gaines Twp | Kent | 6283 | 6283 |  | n | NP |  | 131240 | 2410908 | 1835609 | y |  |  |  |  |  | meter |  |  |  |  |  |  |  | Michael Brew | Amber Vandermolen |  | 
33300 | Grand Blanc Township | Genesee | N/A | N/A |  | Kit Promi | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  |  |  | N/A |  |  |  |  |  | henry@twp.grand-blanc.mi.us |  | Lynn Henry |  |  | 
33360 | Grand Haven Twp | Ottawa | 9484 | 9484 |  | n | NP |  | 233360 | 3439808 | 1216398 | n |  |  |  |  |  | Permit |  |  |  |  |  | mariaboersma@grandhaven.org |  | Maria Boersma |  |  | 
34020 | Grand Rapids Charter Twp | Kent | 8596 | 34020 |  | Yes | NP | 434020 | 234020 | 3804323 | 1835636 | Yes |  |  |  |  |  | meter |  |  |  |  |  | erobinette@grandrapidstwp.org | dknoll@grandrapidstwp.org | Ed Robinette (added "1") | Deborah Knoll |  | 
34560 | Grattan Twp | Kent | 4191 | 4191 |  | n | PS FIRST |  | 234560 | 25138151 | 1923510 | Yes |  |  |  |  |  | meter |  |  |  |  |  | clerk@grattantownship.org |  | Otto McLaughlin |  |  | 
38660 | Holland Charter Township | Ottawa | 12308 | 12308 | yes | n | std |  | 238660 | 13416692 | N/A | tbd |  | 46083 | 46100 |  |  | meter |  |  |  |  |  |  |  |  |  |  | 
40400 | Independence Township | Oakland | N/A | N/A |  | Kit Promi | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  |  |  | N/A |  |  |  |  |  | ELECTIONS@INDTWP.COM |  | Cari Neubeck |  |  | 
41520 | Jamestown Twp | Ottawa | 11997 | 11997 |  | n | NP |  | 241520 | 20582361 | 1836943 | n |  |  |  |  |  | meter |  |  |  |  |  |  |  | Candy DeHaan |  |  | 
42180 | Kalamazoo Township | Kalamazoo | 11969 | 11969 | yes | n | NP |  | 242180, 142180 | 3136307 | 768528 | no | 3.16.26 | 3.17.26 | 3.2 | y |  | meter |  |  |  |  |  |  |  |  |  |  | 
47600 | Lincoln Charter Township | Berrien | N/A | N/A |  | Kit Promi | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  |  |  | N/A |  |  |  |  |  | sloar-porter@lctberrien.org |  | Stacy Loar-Porter |  |  | 
53140 | Meridian Twp | Ingham | 10270 | 10270 | yes | Y | NP | 453140 | 153140 | 3401212 | 705120 | Yes | 3.26 | 46090 | 46100 | y |  |  |  |  |  |  |  | gordon@meridian.mi.us |  | Emily Gordon |  |  | 
54980 | Monitor Twp | Bay |  | dont need |  | Y | n/a |  |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  | clerk@monitortwp.org |  | Linda Ferguson |  |  | 
56920 | Nelson Twp | Kent | 9349 | 9349 | yes | N | NP |  | 256920 | 3427046 | 1933122 | YES | 3.26 |  |  | y |  | meter |  |  |  |  |  | clerk@nelsontownship.org |  | Laura Hoffman |  |  | 
59580 | Oakfield Township | Kent | 3501 | 3501 |  | n | NP |  | 259580, 459580 | 31322157 | 1839642 | yes |  |  |  |  |  | meter |  |  |  |  |  | clerk@oakfieldtwp.org |  | Sue Trainer |  |  | 
61100 | Orion Township | Oakland | 11151 | 11151 |  | n | NP |  | 261100 | 3005103 | 705939 | n |  |  |  |  |  | meter |  |  |  |  |  |  |  |  |  |  | 
61400 | Oshtemo Charter Township | Kalamazoo | 11636 | 11636 | NO | n | NP |  | 261400 | 3153071 | 854585 | n | 46111 |  |  | y |  | meter |  |  |  |  |  |  |  |  |  |  | 
62460 | Park Township | Ottawa | 9781 | 9781 | yes | Y | np |  | 262460 | 2490943 | 1934964 | no | 46107 |  |  |  |  |  |  |  |  |  |  | kgreendyke@parktownship.org |  | Krista Greendyke |  |  | 
64660 | Plainfield Twp | Kent | 3410 | 3410 | yes | n | NP |  | 264660 | 3823044 | 750973 | YES | 3.26 | 3.9 | 46100 | y |  | meter |  |  |  |  |  | porzondekt@plainfieldmi.org |  | Tina Porzondek |  |  | 
75560 | Spencer Twp | Kent | 11187 | 11187 |  | n | NP |  | 275560 | 12749130 | 1874968 | yes |  |  |  |  |  | meter |  |  |  |  |  | clerk@spencertwp.org |  | Lisa Wright |  |  | 
75840 | Spring Lake Twp | Ottawa | 8681 | 86811 |  | Y | FC |  | 275840 | 4579356 |  | Yes |  |  |  |  |  |  |  |  |  |  |  | amuskovin@springlaketwp.org |  | Andria Muskovin |  |  | 
77980 | Tallmadge Charter Township | Kent | 9713 |  |  | n | std |  | 277980 | 7214186 | N/A | yes |  |  |  |  |  | meter |  |  |  |  |  |  |  |  |  |  | 
79300 | Texas Township | Kalamazoo | 12572 | 12572 | yes | n | std |  | 279300 | 3135114 | N/A | Yes | 46111 | 46091 | 46100 | yes |  | meter |  |  |  |  |  | emilyb@texastownship.org |  | Emily Beutel |  |  | 
 | this color means double check |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 
79620 | Thornapple Township | Barry | 11641 | 11641 |  | Y | NP |  | 279620 | 8799409 | 1836688 | Yes |  |  |  |  |  | meter |  |  |  |  |  | clerk@thornapple-twp.org |  | Cindy Ordway |  |  | 
81140 | Tyrone Township | Kent | 12587 | 12587 |  | n | NP |  | 281140 | 20737717 | 1879982 | yes |  |  |  |  |  | meter |  |  |  |  |  | sworley@tyronetownship.org |  |  |  |  | 
81920 | Vergennes Twp | Kent | 6242 | 6242 |  | n | NP |  | 281920 | 6652537 | 1914002 | YES |  |  |  |  |  | meter |  |  |  |  |  | clerk@vergennestwp.org |  | Shantell Ford |  |  | 
87440 | Williamstown Twp | Ingham | 10141 | 10141 |  | Y | NP |  | 287440 | 326746 | N/A | YES |  |  |  |  |  | meter |  |  |  |  |  | robin@williamstownmi.gov |  | Robin Cleavland |  |  | 
88820 | Wright Township | Ottawa | 12005 | 12005 |  | Y | PS FC |  | 288820 | 5983487 |  | YES |  |  |  |  |  |  |  |  |  |  |  | clerk@ocwrighttwp.org | deputyclerk@ocwrighttwp.org | Theresa Frank | Denise Terpstra |  | 
89280 | Zeeland Twp | Ottawa | 10267 | 10267 | yes | n | std |  | 289280 | 2466991 |  | yes | tbd 3.26.26 |  |  |  |  | meter |  |  |  |  |  | kate.kraak@zeelandtwp.org | kate.kraak@zeelandtwp.org | Kate Kraak |  |  | 
65940 | Port Sheldon Township | Ottawa | 11716 | 11716 | yes | n | NP |  | 265940 | 4594979 | 1927501 | yes |  | 46083 | 46100 | tbd |  |  |  |  |  |  |  |  |  |  |  |  | 
65560 | City of Portage | Kalamazoo | 9496 | 9496 | yes | n | NP |  | 265560 | 3804308 | 727793 | yes | 3.26.26 | 46090 | 46099 | yes |  | meter |  | y | y | y |  |  |  |  |  |  | 
52180 | City of Mason |  | 11556 | 11556 | yes | n | std |  | 252180 | 36061083 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.18 | yes |  | meter |  | y | y | y |  |  |  |  |  |  | 
