A1:A9 is referencing the mapsheet list for survey township (011-019). The survey township range (021-029) and the PLSS township (04S) output are my variables, which I will alter per county. The formula needs to refer to the list on sheet 2 and if the first 3 characters of the PID for survey township 2 are 021-029, the output for the township cell should be (04S) for township 4 South. The particular county has 20 survey townships. I created a reference list in sheet2 that lists every map sheet in the county (011-209). I'm now working on the township and range. Nine map sheets with 4 sections per sheet is the 36. There are 36 sections in a "survey township". However, each "survey township" falls within the grid of a single township and range square in the PLSS.Įach survey township is made up of 9 "map sheets" from the old days of milar map sheets which held 4 sections per map. However the "survey township" should not be confused with the township and range of the PLSS. 
The PID begins with the 3 digits of the survey township followed by the two section number digits. I'm running Office 2010 and I'm trying to build a function in Excel that derives the section, township and range from the 16 digit parcel identification number (PID) into individual columns. I am a GIS specialist for a cadastral mapping company.
0 kommentar(er)
