Super Challenge: questions and discussion

[jeffers]

Edit: downloading a copy of the spreadsheet from the Google Drive link worked for me.

Almost working for me: the button for "French" doesn't work. The two other buttons are working. Strange. Thanks anyway, I'm going to use it.

Strange indeed. However, the number for challenge level can be edited manually.

[DaveAgain]

I expect to read my fair share of Krimis, in particular from the Gereon Rath (Volker Kutscher, basis for the Babylon Berlin TV show) and Bettina Boll (Monika Geier) series, but would also like to try and throw in something a bit more highbrow, whether that's from shortlists for recent literary prizes (e.g. Deutscher Buchpreis or Preis der Leipziger Buchmesse) or some established older "classics". I'd really like to explore older works by female writers, but apart from Christa Wolf I am genuinely struggling to find anything.

Two out of copyright books I've bookmarked but not yet read are Johanna Schopenhauer's travel book about England, and Maria Theresia's letters.

[rdearman]

Edit: downloading a copy of the spreadsheet from the Google Drive link worked for me.

Almost working for me: the button for "French" doesn't work. The two other buttons are working. Strange. Thanks anyway, I'm going to use it.
Edit : LibreOffice on a Debian machine.

I had a try, but the problem I had was I couldn't find any easy place to change the languages! I tried to edit every occurrence of German with Italian, but eventually gave up because it just kept going back to German in the dashboard.

[Arnaud]

I had a try, but the problem I had was I couldn't find any easy place to change the languages! I tried to edit every occurrence of German with Italian, but eventually gave up because it just kept going back to German in the dashboard.

I didn't try to change anything, that's too complicated for me: I use the german tab to log my progress in russian, that's all.

[jeffers]

Edit: downloading a copy of the spreadsheet from the Google Drive link worked for me.

Almost working for me: the button for "French" doesn't work. The two other buttons are working. Strange. Thanks anyway, I'm going to use it.
Edit : LibreOffice on a Debian machine.

I had a try, but the problem I had was I couldn't find any easy place to change the languages! I tried to edit every occurrence of German with Italian, but eventually gave up because it just kept going back to German in the dashboard.

Since I initially made the spreadsheet for myself, I didn't have the chart titles come from the data sheet, but now I've made v2 which does just that. Change the three language names on the data sheet and the charts change on that page and on the dashboard, as in the pic below:

change language titles.JPG (108.64 KiB) Viewed 752 times

The titles will automatically change on the dashboard as well.

And here's the link to the latest version: https://drive.google.com/file/d/11VLMjsk5qwZfLjaSKCczm53oHDIPL_XH/view?usp=sharing

[Arnaud]

Change the three language names on the data sheet and the charts change on that page and on the dashboard

It doesn't work for me.

[jeffers]

Change the three language names on the data sheet and the charts change on that page and on the dashboard

It doesn't work for me.

Darn. But what doesn't work? When I download from the link and open in Excel everything works as I expect it to.

The place to change the language names is in cells A5, A10 and A15. The labels are then created in cells A49:B59, from where the chart labels are drawn.

[Arnaud]

Darn. But what doesn't work? When I download from the link and open in Excel everything works as I expect it to.

The place to change the language names is in cells A5, A10 and A15. The labels are then created in cells A49:B59, from where the chart labels are drawn.

The download is working. When I change the language names in A5, A10 and A15, nothing changes in the charts and on the dashboard; I still see Language 1, L2, L3. The labels in A49:B59 are created correctly but not transmitted to the charts.

Capture.png (200.19 KiB) Viewed 686 times

[kanewai]

I went through and changed the titles manually in each of the charts. Since I was there I went and changed them to "my" colors. I don't think it took more than twenty minutes; it was pretty straightforward. This was using the first iteration of the spreadsheet.

Is everyone downloading the file first, and then editing? A problem I have with my coworkers is that they will often try to edit documents directly within OneDrive, or on their browser. They can make some changes that way, but they lose a lot of functionality.

[IronMike]

Do we have a guesstimate on when the bot might be available?