Super Challenge: questions and discussion

Ongoing language-learning challenges, and team challenge logs (but not individual logs)
jeffers
Green Belt
Posts: 377
Joined: Sat Aug 22, 2015 4:12 pm
Location: UK
Languages: Speaks: English (N), Hindi (A2-B1)

Learning: The above, plus French (A2-B1), German (A1), Ancient Greek (?), Sanskrit (beginner)
Language Log: https://forum.language-learners.org/vie ... 15&t=13383
x 821
Contact:

Re: Super Challenge: questions and discussion

Postby jeffers » Fri May 08, 2020 8:42 pm

Arnaud wrote:
jeffers wrote: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.
0 x
Starting the new Super Challenge!

DaveAgain
Blue Belt
Posts: 816
Joined: Mon Aug 27, 2018 11:26 am
Languages: Eng (n)
x 1409

Re: Super Challenge: questions and discussion

Postby DaveAgain » Sat May 09, 2020 4:33 am

gsbod wrote:
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.
1 x

User avatar
rdearman
Site Admin
Posts: 5290
Joined: Thu May 14, 2015 4:18 pm
Location: United Kingdom
Languages: English (N)
Language Log: viewtopic.php?f=15&t=1836
x 13391
Contact:

Re: Super Challenge: questions and discussion

Postby rdearman » Sat May 09, 2020 8:46 am

Arnaud wrote:
jeffers wrote: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.
0 x

Arnaud
Blue Belt
Posts: 965
Joined: Sat Jul 18, 2015 11:57 am
Location: France
Languages: French (N), Russian (И), Japanese/Chinese (Zzz)
Language Log: viewtopic.php?t=1524
x 2082

Re: Super Challenge: questions and discussion

Postby Arnaud » Sat May 09, 2020 9:28 am

rdearman wrote: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.
2 x

jeffers
Green Belt
Posts: 377
Joined: Sat Aug 22, 2015 4:12 pm
Location: UK
Languages: Speaks: English (N), Hindi (A2-B1)

Learning: The above, plus French (A2-B1), German (A1), Ancient Greek (?), Sanskrit (beginner)
Language Log: https://forum.language-learners.org/vie ... 15&t=13383
x 821
Contact:

Re: Super Challenge: questions and discussion

Postby jeffers » Sat May 09, 2020 12:09 pm

rdearman wrote:
Arnaud wrote:
jeffers wrote: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
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
3 x
Starting the new Super Challenge!

Arnaud
Blue Belt
Posts: 965
Joined: Sat Jul 18, 2015 11:57 am
Location: France
Languages: French (N), Russian (И), Japanese/Chinese (Zzz)
Language Log: viewtopic.php?t=1524
x 2082

Re: Super Challenge: questions and discussion

Postby Arnaud » Sat May 09, 2020 5:39 pm

jeffers wrote: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.
0 x

jeffers
Green Belt
Posts: 377
Joined: Sat Aug 22, 2015 4:12 pm
Location: UK
Languages: Speaks: English (N), Hindi (A2-B1)

Learning: The above, plus French (A2-B1), German (A1), Ancient Greek (?), Sanskrit (beginner)
Language Log: https://forum.language-learners.org/vie ... 15&t=13383
x 821
Contact:

Re: Super Challenge: questions and discussion

Postby jeffers » Sat May 09, 2020 7:31 pm

Arnaud wrote:
jeffers wrote: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.
0 x
Starting the new Super Challenge!

Arnaud
Blue Belt
Posts: 965
Joined: Sat Jul 18, 2015 11:57 am
Location: France
Languages: French (N), Russian (И), Japanese/Chinese (Zzz)
Language Log: viewtopic.php?t=1524
x 2082

Re: Super Challenge: questions and discussion

Postby Arnaud » Sat May 09, 2020 8:20 pm

jeffers wrote:
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
Capture.png (200.19 KiB) Viewed 686 times
0 x

User avatar
kanewai
Blue Belt
Posts: 510
Joined: Fri May 22, 2015 9:10 pm
Location: Honolulu
Languages: Native: English
Current: French, Italian, Spanish
Past: Indonesian, Pááfang (Micronesian), Latin, Arabic, Epic Greek, German, Turkish
x 1805
Contact:

Re: Super Challenge: questions and discussion

Postby kanewai » Sun May 10, 2020 12:24 am

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.
Last edited by kanewai on Sun May 10, 2020 11:15 am, edited 2 times in total.
2 x
Super Challenge Reading:
Spanish: 18 / 100
French: 14 / 100
Italian: 7 / 100

IronMike
Black Belt - 1st Dan
Posts: 1836
Joined: Thu May 12, 2016 6:13 am
Location: Earth
Languages: Some. Not as many as I'd like.
Language Log: viewtopic.php?f=15&t=5189
x 4280
Contact:

Re: Super Challenge: questions and discussion

Postby IronMike » Sun May 10, 2020 12:25 am

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


Return to “Language Challenges”

Who is online

Users browsing this forum: No registered users and 1 guest