New camping POIs spreadsheet - Motorhome Forums, Motorhome Discussion, Motorhome Chat

User Tag List

 7Likes
Reply
 
LinkBack Thread Tools
post #1 of 111 (permalink) Old 20-02-2014, 07:36 Thread Starter
Senior Member
 
Join Date: Apr 2010
Location: Essex
Posts: 505
Thanks: 0
Thanked 1 Time in 1 Post
New camping POIs spreadsheet

Hi,

Well our last potential ski day was a no-go so, bored again, I've produced an enhanced version of a camping POI Excel preadsheet.

The main enhancements are:

- I've added in the latest Archies Camping POIs (so 49,000+ entries in total with the Camping Car Info data)

- There's a button to filter the POIs just to show those based on a target longitude/latitude and a radius (in miles)

Other points to note are:

- The sheet is protected, to prevent accidentally changing/deleting the POI information but, if you want to poke around, there is no protection password

- The Google Maps hyperlinks are no longer dynamically created using formulae (it took too long to recalculate when the data was filtered) but, if you do change any coordinates or, indeed, add your own entries, then there is a button ('Refresh Hyperlinks') that runs a program that will sweep through the entries and regenerates the hyperlinks. This can take a good few minutes! Oh... and if you do add any new entries of your own then don't leave any empty rows - the Refresh Hyperlinks logic will stop at the first blank row

- The calculation of what POIs are within the search 'radius' is not 100% accurate. It's based on the approximation that 1 degree of latitude or longitude = 68.055 miles (1/360th of the Earth's average circumference). So if you were to enter a search 'radius' of 68.055 miles it will filter in all POIs with a longitude and latitude of +/- 1.0 degrees. A search 'radius' of 34 miles will filter in all POIs with a longitude and latitude of +/- 0.5 degrees. You get the picture.

I reckon it should be accurate to with half a mile or less anyway.

I put 'radius' in inverted commas because it's actually filtering out POIs within a square around the search long/lat rather than a circle.

Please note that this spreadsheet will only work in versions Excel 2002 and above and you will need to enable macros. Again, I'm not sure if it will work correctly in Mac Numbers.

You can download the new sheet HERE

Rgds
CD
Attached Images
File Type: jpg 2014-02-19_11_51_51-microsoft_excel_-_camping_pois_2014.xls_465.jpg (85.9 KB, 20 views)
Pudsey_Bear likes this.
uncleswede is offline  
The Following User Says Thank You to uncleswede For This Useful Post:
Pudsey_Bear (10-07-2021)
Sponsored Links
Advertisement
 
post #2 of 111 (permalink) Old 20-02-2014, 20:18
Member
 
Whatton's Avatar
 
Join Date: Feb 2010
Posts: 86
Thanks: 0
Thanked 0 Times in 0 Posts
Thank you for your time and effort. Much appreciated

The copy that downloaded has no hyperlinks or buttons as per the screenshot?
Whatton is offline  
post #3 of 111 (permalink) Old 20-02-2014, 20:23
Senior Member
 
cabby's Avatar
 
Join Date: May 2005
Location: Elegant Eastbourne
My Motorhome: Sold it.
Posts: 20,116
Thanks: 248
Thanked 401 Times in 381 Posts
Personal Aire
Thank you for that.

cabby
cabby is offline  
 
post #4 of 111 (permalink) Old 21-02-2014, 13:37 Thread Starter
Senior Member
 
Join Date: Apr 2010
Location: Essex
Posts: 505
Thanks: 0
Thanked 1 Time in 1 Post
Oh... Been off wifi for a couple of days. Looks like I linked to the old spreadsheet I'll fix it this evening when we get home.
Rgds CD
uncleswede is offline  
post #5 of 111 (permalink) Old 21-02-2014, 14:15 Thread Starter
Senior Member
 
Join Date: Apr 2010
Location: Essex
Posts: 505
Thanks: 0
Thanked 1 Time in 1 Post
Actually we're slightly delayed at the Eurotunnel so quickly using their wifi to correct this...

The download link to the correct spreadsheet (with the extra data and buttons) is:

https://dl.dropboxusercontent.com/u/...OIs%202014.xls

This is a 20MB download, by the way.

Enjoy,

Rgds
CD
uncleswede is offline  
post #6 of 111 (permalink) Old 21-02-2014, 16:13
Senior Member
 
Pudsey_Bear's Avatar
 
Join Date: Sep 2008
Location: Keighley, Still in Gods County.
My Motorhome: 2007 Ace Siena
Posts: 40,288
Thanks: 1,613
Thanked 1,058 Times in 995 Posts
Send a message via AIM to Pudsey_Bear Send a message via Yahoo to Pudsey_Bear
Thank you for taking the time and the trouble, I know it was not an easy task.
Pudsey_Bear is offline  
post #7 of 111 (permalink) Old 21-02-2014, 16:17
Senior Member
 
Pudsey_Bear's Avatar
 
Join Date: Sep 2008
Location: Keighley, Still in Gods County.
My Motorhome: 2007 Ace Siena
Posts: 40,288
Thanks: 1,613
Thanked 1,058 Times in 995 Posts
Send a message via AIM to Pudsey_Bear Send a message via Yahoo to Pudsey_Bear
I'm getting a warning message
Attached Images
File Type: jpg camping_warning_310.jpg (69.2 KB, 6 views)
Pudsey_Bear is offline  
post #8 of 111 (permalink) Old 21-02-2014, 19:26 Thread Starter
Senior Member
 
Join Date: Apr 2010
Location: Essex
Posts: 505
Thanks: 0
Thanked 1 Time in 1 Post
Kev: You have your Excel macro security levels set too high to run uncertificated macros (in this case the programs I've embedded to do the filtering). That's fine, of course, but I don't have a security certificate - I'm just a casual programmer and certificates cost money, I believe.

Unless anyone else has any suggestions you can either temporarily lower your Excel macro security level in order to use the spreadsheet, then restore it afterwards. Or just ignore the error and use the data in the spreadsheet, without the ability to use the buttons of course.

Or you could copy all the data into another blank spreadsheet and use it from there.

Rgds
CD
uncleswede is offline  
post #9 of 111 (permalink) Old 21-02-2014, 19:53
Senior Member
 
deckboy's Avatar
 
Join Date: Sep 2011
Location: Bonnie Dundee
My Motorhome: East Neuk Fifer S
Posts: 138
Thanks: 11
Thanked 15 Times in 13 Posts
Personal Aire
Quote:
Originally Posted by uncleswede
Actually we're slightly delayed at the Eurotunnel so quickly using their wifi to correct this...

The download link to the correct spreadsheet (with the extra data and buttons) is:

https://dl.dropboxusercontent.com/u/...OIs%202014.xls

This is a 20MB download, by the way.

Enjoy,

Rgds
CD
Sorry, but dropbox link goes nowhere for me
deckboy is offline  
post #10 of 111 (permalink) Old 21-02-2014, 20:19 Thread Starter
Senior Member
 
Join Date: Apr 2010
Location: Essex
Posts: 505
Thanks: 0
Thanked 1 Time in 1 Post
Deckboy:

Oh... it's definitely in my public dropbox folder so should be available to all...

Do you get some sort of 'denied access' or 'permission' error or is it like a broken link?

Can you try this shortened link?
https://db.tt/OMzZIeGO

If still no good PM me and I'll sort out out some other way of getting it to you

Rgds
CD
uncleswede is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Motorhome Forums, Motorhome Discussion, Motorhome Chat forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome