HF Member Dispersal Spreadsheet

**Hobopelican** · 11-02-2016, 12:55

Flatline, If got time to work on this, if it would help. I would start a new sheet, copy all names from each sheet and then delete dups from each state. Once done, we would delete the other sheets. We both could keep a backup offline for recovery. What do you think?

**HalMc** · 11-02-2016, 19:01

I skipped the middle of the thread, but what about having us add our Zipcodes so you can make it into a heat map?

**flatline** · 11-02-2016, 19:06

Originally Posted by Hobopelican

Flatline, If got time to work on this, if it would help. I would start a new sheet, copy all names from each sheet and then delete dups from each state. Once done, we would delete the other sheets. We both could keep a backup offline for recovery. What do you think?

Sounds good Hobo... I'm on the late shift this week so my time is limited this week. I would appreciate any help you could provide.
You're a good guy! We gotta hang sometime!

**Afterparty** · 11-02-2016, 19:33

I'm in Kansas

**Hobopelican** · 11-02-2016, 22:39

Afterparty added.

Flatline, I think I have it updated on the far right tab. You might want to do a few random checks to make sure I was awake throughout!

If it looks good, You could delete the other tabs. I have a back up on my laptop just in case.I deleted all the formatting and adjust some names with leading blanks. Let me know if this looks good or if anything else needs done!

**Hobopelican** · 11-02-2016, 23:27

Originally Posted by HalMc

I skipped the middle of the thread, but what about having us add our Zipcodes so you can make it into a heat map?

Interesting idea, but I'm guessing it's a bit late for that. With over 2700 entries, we'd be basically starting from scratch. Additionally, I think a lot of people would prefer not to be that specific.

**Karla "with a k"** · 11-02-2016, 23:35

Originally Posted by HalMc

I skipped the middle of the thread, but what about having us add our Zipcodes so you can make it into a heat map?

Isn't that why there is a Google map of members?

**HalMc** · 11-03-2016, 02:05

There's a who with the what now?

I should seek out said map!

Sent from my iPhone using Tapatalk

**Karla "with a k"** · 11-03-2016, 07:03

Originally Posted by HalMc

There's a who with the what now?

I should seek out said map!

Sent from my iPhone using Tapatalk

You can add yourself to the map. It's found on the main "forum" page on the right side below the Google Calendar (I believe that is the correct location )