+ Reply to Thread
Results 1 to 2 of 2

Identifying Wrong Labels on Land Surveying Data Collection File

  1. #1
    Registered User
    Join Date
    04-30-2020
    Location
    Houston, Tx
    MS-Off Ver
    2003
    Posts
    1

    Identifying Wrong Labels on Land Surveying Data Collection File

    Hello,
    I am a land surveyor and our field crews collect their data and is given to our office personnel as a .csv file. Each point collected in the field is stored with 5 values, comma-delimited (point number, northing, easting, elevation, description). The description of each point will always be on the 5th column. Our crews are supposed to follow a code list or description code for each point collected, this point list includes roughly 80 different descriptions. For example if they are surveying a road, the crew will collect all points taken on the edge of road as CNC ED or fire hydrants as FH, etc. If they accidently save that point with a different name like CONC instead of CNC, the survey software will not recognize that code.
    My question is the following, is there something that can be set up to where Excel identifies these “bad” codes and then can be easily fixed instead of scrolling thru looking for mistakes.
    I hope I wasn’t too confusing and thanks for your input.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Identifying Wrong Labels on Land Surveying Data Collection File

    Hi, welcome to the forum.
    'Artificial intelligence' is one thing, but you can help it like let's say you make new sheet with a list of correct codes let's say down column A next to each code you can add codes that you've come up once in a while, the frequent type errors that refer to this code, so while reading you lookup the code in that entire sheet and it's found and it's not in column A you use the corresponding code i column A.
    My explanation is probably not making sense but I've used this when it comes to column headers presented than do not follow the set rules, so i place alternative headers in the rows next to the correct one.
    This is just to trigger the idea, it's way past my bedtime here but give it a thought, I don't know how your VBA experience it but it's quite simple and straight forward because you can keep adding corrections as they come
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mail Merge from excel file for labels not populating labels
    By rcdavis28 in forum Word Formatting & General
    Replies: 1
    Last Post: 10-15-2016, 03:06 PM
  2. Change the caption of labels within a collection
    By ryan.wherry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2016, 03:44 PM
  3. Land surveyor needs help with ascii file and stationing.
    By Ataim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2012, 04:53 PM
  4. 'Labels' Control in Excel (Labels Collection)?
    By danny2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2010, 08:52 AM
  5. Pre-set processing of surveying data
    By hawley in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-04-2008, 04:09 AM
  6. Replies: 0
    Last Post: 05-09-2006, 10:45 AM
  7. X-axis labels wrong
    By QuantumLeap in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-06-2006, 08:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1