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.
|