Home » Uncategorized » Ferreting out Bad Map Points using MS Excel, Open Office, or Google Sheets

Ferreting out Bad Map Points using MS Excel, Open Office, or Google Sheets

Follow World Hum Map and Database Project on WordPress.com
Follow World Hum Map and Database Project on WordPress.com

A small percentage of Hum Map points are invalid or malformed. Here is one thing that people can do to find those bad points, or points that have formatting issues.

Point to the Hum Database at https://www.google.com/fusiontables/DataSource?docid=1EyjVZqUPpoXGQDa_cry9DqFaBVMOgEyq-3qo85bx#rows:id=1

Click on File, and then Download. Go with the default choices, and when the file is downloaded, open it in Excel, Open Office Spreadsheet, or Google Sheets.

You can now sort columns – by age, for example, which can reveal typos and nonsense answers. Sorting columns also reveals rows that have data placed into the wrong columns. You may also spot some dates that are not written correctly. Dates should be given as mm/dd/yyyy. For example, “04/25/2016”, not “April 25, 2016”.

Please email me at glen.macpherson@gmail.com with your concerns. Please refer to the timestamp and reported hum location.


2 Comments

  1. […] Note: As part of this process you can also keep an eye out for invalid entries. […]

  2. […] of potential data points to sift through. Before I even consider my next update, we need to ferret out the bad map points. If every read of this blog would commit to examining 10 Hum Map points, we can […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: