--000000000000a49ca80616731969 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Chad, Please find the link to the Excel file with 3 tabs: https://docs.google.com/spreadsheets/d/151PcWGhgqon1jfqq262lGU63Yg8ppdOt/ed= it?usp=3Dsharing&ouid=3D101409043019553880832&rtpof=3Dtrue&sd=3Dtrue 1) The initial SF data enriched with counties and other details + changes that were shared by each division 2) The CA related zip codes based on the matching of cities that are currently serviced by local offices (ex if Vancouver was serviced then all zips pertaining to Vancouver were identified and added). There is a column specifying if the zip is already in SF. Heads up, there are nearly 290k non-identified zips for Canada in the cities serviced by local offices. That might take you a while to identify. 3) Same for the US but this time based on the county level. I've identified the missing zips for counties that are serviced by local offices and are not in SF. I've also highlighted in yellow (first column) all zips with over 1,000 estimated population so that you can focus on bigges ones. Approx 350 zip codes are in this sitiuation. I'm traveling today till Tuesday, but I can find some time to have a call either today or on Monday to go through this. Thank you, On Thu, Apr 18, 2024 at 5:01=E2=80=AFPM Chad Everitt wrote: > Yes thanks. Otherwise, we are simply recycling the missing content. > > > *Chad Everitt* > President- East Division & Canada > Mobile: 202.262.8318 > [image: TheKey] > > > On Thu, Apr 18, 2024 at 10:50=E2=80=AFAM Sardar Azimov > wrote: > >> Hello Chad, >> >> I will create a file with the following information: >> >> - US zip codes not in the SF + identify those that are in counties >> that have other zip codes services by a local office (ex 33137 and 33= 136 >> are both in Miami Dade county; 33137 is not in SF but 33136 is in SF;= then >> it would worth checking if the local office could service 33137) >> - CA zip codes not in the SF + identify all city areas that are >> currently in the SF based on the current list of 10k Canadian zip cod= es and >> match it back with the total list 850k zip codes. Ex Zip 1 is in Calg= ary >> and in SF and Zip 2 is also in Calgary but not in SF. This should dec= rease >> the time spent on qualifying the totality of codes but only those wit= hin >> target zones. >> >> I hope this works for you. >> Thank you. >> >> On Wed, Apr 17, 2024 at 6:24=E2=80=AFPM Chad Everitt >> wrote: >> >>> Sardar, >>> >>> Can we externally pull all the Postal Codes within the respective >>> Canadian provinces for review? Pulling from SalesForce may be recycling= the >>> garbage in and producing garbage out. >>> >>> >>> >>> *Chad Everitt* >>> President- East Division & Canada >>> Mobile: 202.262.8318 >>> [image: TheKey] >>> >>> >>> On Wed, Apr 17, 2024 at 12:19=E2=80=AFPM Sardar Azimov >>> wrote: >>> >>>> OK, thank you. >>>> Let me try to narrow down this list and get back to you. With a list o= f >