QuietJourney Forums
Boundary Waters / Quetico Discussion Forums >> General Boundary Waters / Quetico Discussion >> Important new concerning PCD
https://quietjourney.com/community/YABB.cgi?num=1397756183

Message started by azalea on Apr 17th, 2014 at 5:36pm

Title: Re: Important new concerning PCD
Post by Joe_Schmeaux on May 11th, 2014 at 7:38pm
Anyone can save a permanent record of the average ratings for each campsite in pcd by downloading the oziexplorer file. There is one file for inuks and one for non-inuks, and you only get the average rating for each campsite, not the individual ratings or the text comments, but maybe that's good enough.

If you don't want to use Oziexplorer or Memory-Map, the Oziexplorer file data can also be read in in Excel. Go to "Data" - "From Text" - (select the Oziexplorer file) - select "delimited"and check the "comma" box, then import the data into a new worksheet, making sure the data type of column B is "text".

Azalea's help file tells you what each column refers to. The only one that's a bit of a nuisance is the one ending up in "column K" in the Excel sheet. If you want to parse that column into something a bit cleaner, you can create six new columns, with the following formulas:

Column K: Already contains a string like this:    ?:?:Namakan River    :-m---
Columns V through Z should be blank, so enter the following formulas into line 5 and copy them to the other rows in the sheet:
Column V: =TRIM(LEFT(K5,FIND(":",K5,1)-1))
Column W: =MID(K5,LEN(LEFT(K5,FIND(":",K5,1)-1))+2,100)
Column X: =LEFT(W5,FIND(":",W5,1)-1)
Column Y:=MID(W5,LEN(X5)+2,100)
Column Z: =LEFT(Y5,FIND(":",Y5,1)-1)
Column AA: =MID(Y5,LEN(Z5)+2,100)

Columns W and Y can be hidden; Columns V, X, Z and AA contain the average rating, number of tent pads, lake name, and original data source for each site respectively.

I won't promise anything, but this should work with free spreadsheet programs like Open Office if you don't have Excel.

QuietJourney Forums » Powered by YaBB 2.6.0!
YaBB Forum Software © 2000-2025. All Rights Reserved.