Excel Data Quality Toolkit: Revision history

25 April 2024

• curprev 17:3317:33, 25 April 2024‎ Cearl talk contribs‎ m 25,137 bytes +55‎ →‎Mismatched Geographic Terms
• curprev 17:3317:33, 25 April 2024‎ Cearl talk contribs‎ m 25,082 bytes +55‎ →‎Incorrect Line Endings
• curprev 17:3117:31, 25 April 2024‎ Cearl talk contribs‎ m 25,027 bytes +55‎ →‎Mismatched Country and CountryCode Values

10 April 2024

• curprev 17:1217:12, 10 April 2024‎ Kds15e talk contribs‎ 24,972 bytes +504‎ →‎Unknown Higher Taxonomy
• curprev 17:1017:10, 10 April 2024‎ Kds15e talk contribs‎ 24,468 bytes +55‎ →‎Invalid Coordinates
• curprev 17:1017:10, 10 April 2024‎ Kds15e talk contribs‎ 24,413 bytes +55‎ →‎Improperly Negated Latitudes/Longitudes
• curprev 17:1017:10, 10 April 2024‎ Kds15e talk contribs‎ 24,358 bytes +55‎ →‎Georeference Metadata with no Associated Georeference
• curprev 17:1017:10, 10 April 2024‎ Kds15e talk contribs‎ 24,303 bytes +55‎ →‎Coordinates Do Not Fall Within Named Geographic Unit

29 March 2024

• curprev 15:4415:44, 29 March 2024‎ Jegelewicz talk contribs‎ 24,248 bytes +34‎ →‎Lower Geography Values are Provided, but No Higher Geography
• curprev 13:5713:57, 29 March 2024‎ Jegelewicz talk contribs‎ 24,214 bytes +127‎ →‎Non-standardized BasisOfRecord Values
• curprev 13:5713:57, 29 March 2024‎ Jegelewicz talk contribs‎ 24,087 bytes +127‎ →‎Minimum and Maximum Elevation Values Mismatched
• curprev 13:5613:56, 29 March 2024‎ Jegelewicz talk contribs‎ 23,960 bytes +127‎ →‎Lower Geography Values are Provided, but No Higher Geography
• curprev 13:5613:56, 29 March 2024‎ Jegelewicz talk contribs‎ 23,833 bytes +127‎ →‎Year, Month, and Day Values Do Not Match Date
• curprev 13:5613:56, 29 March 2024‎ Jegelewicz talk contribs‎ 23,706 bytes +127‎ →‎Identified Date Earlier than Collected Date
• curprev 13:5513:55, 29 March 2024‎ Jegelewicz talk contribs‎ 23,579 bytes +127‎ →‎Date Hasn't Happened Yet
• curprev 13:2213:22, 29 March 2024‎ Jegelewicz talk contribs‎ 23,452 bytes 0‎ →‎Lower Geography Values are Provided, but No Higher Geography
• curprev 13:2213:22, 29 March 2024‎ Jegelewicz talk contribs‎ 23,452 bytes +3‎ →‎Lower Geography Values are Provided, but No Higher Geography
• curprev 13:2213:22, 29 March 2024‎ Jegelewicz talk contribs‎ 23,449 bytes +43‎ →‎Lower Geography Values are Provided, but No Higher Geography
• curprev 13:2113:21, 29 March 2024‎ Jegelewicz talk contribs‎ 23,406 bytes +231‎ →‎Lower Geography Values are Provided, but No Higher Geography
• curprev 13:1713:17, 29 March 2024‎ Jegelewicz talk contribs‎ 23,175 bytes +127‎ →‎Lower Geography Values are Provided, but No Higher Geography
• curprev 13:1513:15, 29 March 2024‎ Jegelewicz talk contribs‎ 23,048 bytes +219‎ →‎Lower Geography Values are Provided, but No Higher Geography
• curprev 12:5512:55, 29 March 2024‎ Jegelewicz talk contribs‎ 22,829 bytes −1,696‎ →‎Lower Geography Values are Provided, but No Higher Geography Tag: Manual revert
• curprev 12:5112:51, 29 March 2024‎ Jegelewicz talk contribs‎ 24,525 bytes +1,696‎ →‎Lower Geography Values are Provided, but No Higher Geography
• curprev 12:5012:50, 29 March 2024‎ Jegelewicz talk contribs‎ 22,829 bytes +1,696‎ →‎Misspelled Geographic Unit Names
• curprev 12:3412:34, 29 March 2024‎ Jegelewicz talk contribs‎ 21,133 bytes 0‎ →‎Taxonomy
• curprev 12:3312:33, 29 March 2024‎ Jegelewicz talk contribs‎ 21,133 bytes +764‎ →‎Misspelled or Invalid Taxonomic Names
• curprev 12:3012:30, 29 March 2024‎ Jegelewicz talk contribs‎ 20,369 bytes +877‎ →‎Misspelled or Invalid Taxonomic Names
• curprev 12:2612:26, 29 March 2024‎ Jegelewicz talk contribs‎ 19,492 bytes +6‎ →‎Non-standardized BasisOfRecord Values
• curprev 12:2612:26, 29 March 2024‎ Jegelewicz talk contribs‎ 19,486 bytes −6‎ →‎Non-standardized BasisOfRecord Values
• curprev 12:2512:25, 29 March 2024‎ Jegelewicz talk contribs‎ 19,492 bytes +2‎ →‎Non-standardized BasisOfRecord Values
• curprev 12:2412:24, 29 March 2024‎ Jegelewicz talk contribs‎ 19,490 bytes +90‎ →‎Non-standardized BasisOfRecord Values
• curprev 12:2112:21, 29 March 2024‎ Jegelewicz talk contribs‎ 19,400 bytes +12‎ →‎Non-standardized BasisOfRecord Values
• curprev 12:2012:20, 29 March 2024‎ Jegelewicz talk contribs‎ 19,388 bytes +73‎ →‎Non-standardized BasisOfRecord Values
• curprev 12:1612:16, 29 March 2024‎ Jegelewicz talk contribs‎ 19,315 bytes +2,263‎ →‎Non-standardized BasisOfRecord Values
• curprev 11:3111:31, 29 March 2024‎ Jegelewicz talk contribs‎ 17,052 bytes +204‎ →‎Non-standardized BasisOfRecord Values
• curprev 11:2411:24, 29 March 2024‎ Jegelewicz talk contribs‎ 16,848 bytes +166‎ →‎Minimum and Maximum Elevation Values Mismatched
• curprev 11:1811:18, 29 March 2024‎ Jegelewicz talk contribs‎ 16,682 bytes −1‎ →‎Date Hasn't Happened Yet
• curprev 11:1711:17, 29 March 2024‎ Jegelewicz talk contribs‎ 16,683 bytes −1‎ →‎Year, Month, and Day Values Do Not Match Date
• curprev 11:1711:17, 29 March 2024‎ Jegelewicz talk contribs‎ 16,684 bytes +2‎ →‎Year, Month, and Day Values Do Not Match Date
• curprev 11:1711:17, 29 March 2024‎ Jegelewicz talk contribs‎ 16,682 bytes +2‎ →‎Year, Month, and Day Values Do Not Match Date
• curprev 11:1611:16, 29 March 2024‎ Jegelewicz talk contribs‎ 16,680 bytes 0‎ →‎Identified Date Earlier than Collected Date
• curprev 11:1511:15, 29 March 2024‎ Jegelewicz talk contribs‎ 16,680 bytes +155‎ →‎Year, Month, and Day Values Do Not Match Date
• curprev 11:0311:03, 29 March 2024‎ Jegelewicz talk contribs‎ 16,525 bytes +171‎ →‎Identified Date Earlier than Collected Date
• curprev 10:4410:44, 29 March 2024‎ Jegelewicz talk contribs‎ 16,354 bytes +122‎ →‎Date Hasn't Happened Yet

25 March 2024

• curprev 20:1920:19, 25 March 2024‎ Lwalker talk contribs‎ 16,232 bytes −69‎ →‎Missing Geodetic Datum
• curprev 20:1920:19, 25 March 2024‎ Lwalker talk contribs‎ 16,301 bytes −55‎ →‎Coordinates are Zero
• curprev 20:1820:18, 25 March 2024‎ Lwalker talk contribs‎ 16,356 bytes +4‎ →‎Elevation is Unlikely
• curprev 20:1820:18, 25 March 2024‎ Lwalker talk contribs‎ 16,352 bytes −229‎ →‎Elevation is Unlikely
• curprev 20:1720:17, 25 March 2024‎ Lwalker talk contribs‎ 16,581 bytes +912‎ →‎Elevation is Unlikely
• curprev 20:0620:06, 25 March 2024‎ Lwalker talk contribs‎ 15,669 bytes −14‎ →‎Coordinates are Zero
• curprev 20:0520:05, 25 March 2024‎ Lwalker talk contribs‎ 15,683 bytes +791‎ →‎Coordinates are Zero
• curprev 19:5719:57, 25 March 2024‎ Lwalker talk contribs‎ 14,892 bytes −4‎ →‎Missing Latitudes/Longitudes
• curprev 19:5719:57, 25 March 2024‎ Lwalker talk contribs‎ 14,896 bytes −174‎ →‎Missing Latitudes/Longitudes
• curprev 19:5619:56, 25 March 2024‎ Lwalker talk contribs‎ 15,070 bytes +2,276‎ →‎Missing Latitudes/Longitudes
• curprev 19:4319:43, 25 March 2024‎ Lwalker talk contribs‎ 12,794 bytes +5‎ →‎Missing Geodetic Datum
• curprev 19:4119:41, 25 March 2024‎ Lwalker talk contribs‎ 12,789 bytes −1‎ →‎Overview
• curprev 19:4119:41, 25 March 2024‎ Lwalker talk contribs‎ 12,790 bytes +180‎ →‎Overview
• curprev 17:2817:28, 25 March 2024‎ Kds15e talk contribs‎ 12,610 bytes +929‎ →‎Date is Suspiciously Old
• curprev 16:4916:49, 25 March 2024‎ Lwalker talk contribs‎ 11,681 bytes +570‎ →‎Missing Geodetic Datum
• curprev 16:4416:44, 25 March 2024‎ Kds15e talk contribs‎ 11,111 bytes +720‎ →‎Incorrect Character Encodings
• curprev 16:3716:37, 25 March 2024‎ Kds15e talk contribs‎ m 10,391 bytes +1‎ →‎Invalid Individual Count
• curprev 16:3716:37, 25 March 2024‎ Kds15e talk contribs‎ 10,390 bytes +101‎ →‎Invalid Individual Count
• curprev 16:3616:36, 25 March 2024‎ Kds15e talk contribs‎ 10,289 bytes +632‎ →‎Invalid Individual Count

22 March 2024

• curprev 12:5112:51, 22 March 2024‎ Kds15e talk contribs‎ m 9,657 bytes −11‎ →‎Duplicate Catalog Numbers
• curprev 12:4912:49, 22 March 2024‎ Kds15e talk contribs‎ 9,668 bytes +1,452‎ →‎Duplicate Catalog Numbers

19 March 2024

• curprev 09:4109:41, 19 March 2024‎ Kds15e talk contribs‎ 8,216 bytes +8,216‎ Created page with "Category:Data Quality Category:Workshop = Overview = This toolkit contains Excel-specific resources for the Data Quality Toolkit 2024. == Catalog Numbers and Other Identifiers== === Duplicate Catalog Numbers === '''Problem:''' The same catalog number is used multiple times within your dataset. (This problem may or may not be intentional, depending on your collection's policies. It is generally best to not duplicate catalog numbers, when possible). '''So..."