The Around the World challenge is going into its second year and I’m still overwhelmed by the response it got last year. I hope just as many are going to join me in exploring the world through books again in 2016.
The goal of the Around the World challenge is to visit as many different places in the world through books, especially places that are rather rare, and not the kind of settings you see in 95% of all the books you read. We’re are going to do this by creating a google map where every pin on the map stands for one book. The goal is to have as many pins as possible and they shouldn’t be very close to each other but spread all over.
The mini-challenges are additional challenges that can help you archive your goal in different ways, but they are completely optional and you can do as many of them as you want. For many of them you can set your own goal, some of them have fixed numbers of books that are to be read:
During the 2015 challenge I had the problem that I often forgot to enter the places of my books. That’s why I have added an additional feature to this year’s spreadsheet. Not only will you be able to track the books, their locations and the mini-challenges in this spreadsheet but you can also use this spreadsheet to import the places into your map.
The “Read” tab is for keeping tracks of all books. Here you have a row for each book with its location and the mini challenges. The mini-challenge cell can be filled with a comma separated list of all challenges it counts for, using the short names: C01,C02,…,C15.
If you are going to import your books’ locations directly from this spreadsheet then you can only add one location per book or you have to add a book multiple times, once for every location! And if you want to make use of my script (see below) you do not enter anything in the “in map” column, that will happen automatically. If you don’t, you use that column to keep track of whether you’ve marked a location on your map yet.
In the “Overview” tab, you will the see the progress of each mini challenge. Here you can set your own goal for each challenge. and the number of books read will automaticall be counted.
You can only import locations into a new layer of a map, so I for example am only going to import my locations once a month to not have too many layers in the end.
The spreadsheet has a menu item “Import” > “Get books to import” (Note: google might ask permission that the script is allowed to access your spreadsheet).
If you use that one, all books that aren’t marked with an “X” for “in map” (in the Read tab) will be copied to the “To import” tab. They will now be marked with an X and books previously listed in the “to import” tab will be deleted.
After you have the list of locations that are not yet part of your map you go to your map and create a new layer. You’ll then see the option to import data.
You’ll then have to choose a file to import from. Here you choose your spreadsheet from Google Drive.
(Important: only the first tab is automatically chosen. That is why the “to import” tab has to be the first. Do not change the order of the tabs if you want to use this.)
Then you are asked to choose a column for the place marks. Choose “Location” and continue.
Then you are asked to choose a column for the title of the marks. Here you chose “Title”.
IF your locations can be found, they’ll be added to the spreadsheet. That’s why it is important to have a detailed location, for example adding the country or state instead of using just the name of a city.
Get the spreadsheet here (this is a read-only file. You have to make a copy for yourself via File>Make a copy)
SIGN UP HERE.