Super Challenge: questions and discussion

Ongoing language-learning challenges, and team challenge logs (but not individual logs)
User avatar
Serpent
Black Belt - 3rd Dan
Posts: 3591
Joined: Sat Jul 18, 2015 10:54 am
Location: Moskova
Languages: heritage
Russian (native); Belarusian, Polish

fluent or close: Finnish+ (certified C1), English; Portuguese, Spanish, German+, Italian+
learning: Croatian+, Ukrainian, Czech; Romanian+, Galician; Danish, Swedish
exploring: Latin, Karelian, Catalan, Dutch, Chaucer's English
+ means exploring the dialects/variants
x 4891
Contact:

Re: Super Challenge: questions and discussion

Postby Serpent » Tue May 05, 2020 9:46 pm

Wouldn't it be easier to make sure the bot actually responds to tweets, and then to resend the tweet if there's no response in 5 minutes?

Also there's a separate thread in the technical subforum :)
0 x
LyricsTraining now has Finnish and Polish :)
Corrections welcome

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 » Wed May 06, 2020 8:51 pm

I made a tracking spreadsheet with a dashboard that sums up challenge progress with charts, and has speedometers to show you if you are on track, behind or ahead. I'm happy for anyone to use it for themselves, to change it all they like, etc.

Here's the link to the file: https://drive.google.com/file/d/11VLMjsk5qwZfLjaSKCczm53oHDIPL_XH/view?usp=sharing It will open an online version of the file, which you can download to your own computer. (EDIT: new link to v2)

The timeline at the top will fill up as the challenge progresses. The column charts will show how much of your chosen challenge you have completed in total (and will probably break when you go over 100%). The speedometers are based on a calculation of how much you should have read or watched to date. If you are exactly on target they will point straight up, and if you are double your target or above the needle will be to the right.

You can also change your challenge level using the buttons below each set of charts. They change by 0.5 in the range from 0 to 3.

dashboard example.JPG
dashboard example.JPG (102.83 KiB) Viewed 839 times


To use it for your own challenge just go to the tabs for X books or X films and enter your information. The number from pages/minutes is picked up by the data tab. You can obviously rename the tabs to whatever language(s) you are studying, as well as renaming the labels on the charts. To change labels, just click on them to highlight the label, click on it again to be within the label, and change the text as you please.

I would avoid changing most things on the data sheet. However, if you want to customize the labels on the speedometer just scroll down to that part of the data sheet and put in whatever labels you want.

EDIT: chart titles are now populated automatically. Set your language names in cells A5, A10 and A15, and the rest should work in Excel. No idea what other spreadsheet programs will do with it.
Last edited by jeffers on Sat May 09, 2020 7:33 pm, edited 1 time in total.
18 x
Starting the new Super Challenge!

User avatar
Lianne
Green Belt
Posts: 423
Joined: Mon Jul 20, 2015 3:29 pm
Location: Canada
Languages: Speaks: English (N)
Actively studying: French (low int), Italian (beginner)
Dabbling in: ASL (beginner)
Wish list: Swedish, Esperanto, Klingon, Brazilian Portuguese
Has also dabbled in: German, Spanish, toki pona, Swahili
Language Log: https://forum.language-learners.org/vie ... hp?t=12275
x 1128
Contact:

Re: Super Challenge: questions and discussion

Postby Lianne » Wed May 06, 2020 9:44 pm

Thanks, jeffers!! That is such a cool tool! Looks like so far I'm just a tiny bit behind on reading for both my challenges, and I'm in the super range for films for both! :D

I love the visual, and I also really like the data tab, particularly how it shows the pace you need to keep up from now until the end to reach your goal.
1 x
: 2 / 100 French SC (Books)
: 4 / 100 French SC (Films)
: 1 / 50 Italian Half SC (Books)
: 3 / 50 Italian Half SC (Films)

: 377 / 2500 Reading 2500 pages of French in 2020 (updated June 5)

Pronouns: she/her

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 » Wed May 06, 2020 10:08 pm

Hopefully rdearman & Co. will have success with their coding and IT stuff they're doing now.
2 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 » Thu May 07, 2020 9:30 am

I was thinking about adding some metrics like Jeffers has on his spreadsheet, but given all the stuff I have on my plate at the moment... :geek:


EDIT: I added the request to the issues on GitHub if anyone would like to have a go themselves!
3 x

User avatar
MamaPata
Brown Belt
Posts: 1022
Joined: Tue Jun 21, 2016 9:25 am
Location: London
Languages: English (N), French (C1*), Russian (B1), Spanish (B1).

Long lost: Arabic and Latin.
Language Log: viewtopic.php?f=15&t=3004
x 1800

Re: Super Challenge: questions and discussion

Postby MamaPata » Fri May 08, 2020 11:00 am

Thank you all for this work - I can't imagine what it must involve!

Also Jeffers, that spreadsheet is gorgeous, I love it! I had a version for the time before last which did give me some metrics, but it was not half as pretty! Switching immediately!
1 x
Corrections appreciated.

User avatar
lingua
Blue Belt
Posts: 657
Joined: Sun Mar 13, 2016 11:23 pm
Languages: English (N)
Maintaining italiano (intermediate)
Studying português & Deutsch (beginner)
Dabbling in siciliano, Latin, piemontèis
Language Log: https://forum.language-learners.org/vie ... 15&t=12257
x 879

Re: Super Challenge: questions and discussion

Postby lingua » Fri May 08, 2020 6:21 pm

I had written elsewhere that I was able to use Jeffers spreadsheet in LibreOffice if I kept it in the excel format. But, after playing with it for a bit I wouldn't advise it. The behavior is not very stable and it would be easy to mess it up. It also renders a little differently in some places.
1 x
Super Challenge:
IT film: 2282 / 18000 read: 2691 / 10000
DE film: 3086 / 9000 read: 0 / 5000
Romance Family film: 3026 / 9000 read: 0 / 5000 (FR, PT, PMS, SCN)

Output Challenge:
IT wrote: 1905 / 100000 recorded: 62 / 6000
DE wrote: 553 / 50000 recorded: 21 / 3000
PT wrote: 1741 / 50000 recorded: 13 / 3000
FR wrote: 31 / 50000 recorded: 0 / 3000

User avatar
Lianne
Green Belt
Posts: 423
Joined: Mon Jul 20, 2015 3:29 pm
Location: Canada
Languages: Speaks: English (N)
Actively studying: French (low int), Italian (beginner)
Dabbling in: ASL (beginner)
Wish list: Swedish, Esperanto, Klingon, Brazilian Portuguese
Has also dabbled in: German, Spanish, toki pona, Swahili
Language Log: https://forum.language-learners.org/vie ... hp?t=12275
x 1128
Contact:

Re: Super Challenge: questions and discussion

Postby Lianne » Fri May 08, 2020 6:41 pm

lingua wrote:I had written elsewhere that I was able to use Jeffers spreadsheet in LibreOffice if I kept it in the excel format. But, after playing with it for a bit I wouldn't advise it. The behavior is not very stable and it would be easy to mess it up. It also renders a little differently in some places.

It has fancy stuff in it, which always makes spreadsheets hard to move around. Even just in the process of downloading it to my computer and opening it in Excel, I lost the little up and down arrows to choose your challenge level, despite never using anything that wasn't Microsoft Excel on it! *shrugs*
0 x
: 2 / 100 French SC (Books)
: 4 / 100 French SC (Films)
: 1 / 50 Italian Half SC (Books)
: 3 / 50 Italian Half SC (Films)

: 377 / 2500 Reading 2500 pages of French in 2020 (updated June 5)

Pronouns: she/her

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:07 pm

Lianne wrote:
lingua wrote:I had written elsewhere that I was able to use Jeffers spreadsheet in LibreOffice if I kept it in the excel format. But, after playing with it for a bit I wouldn't advise it. The behavior is not very stable and it would be easy to mess it up. It also renders a little differently in some places.

It has fancy stuff in it, which always makes spreadsheets hard to move around. Even just in the process of downloading it to my computer and opening it in Excel, I lost the little up and down arrows to choose your challenge level, despite never using anything that wasn't Microsoft Excel on it! *shrugs*


Yeah, I wouldn't have expected it to work in other systems. Edit: having said that, all of the important information is on the data sheet which should work on any spreadsheet app. "Pres target" is how many pages/minutes you should have logged by the present day, and "% pres" is your progress on that target. If it's 100% or above, you're grand.

However, I'm surprised the buttons didn't work. One solution might be to right click anywhere in the "ribbon" (the area at the top of Excel with all the buttons and tools), choose "customize ribbon" and add in the Developer toolbar. That's where the buttons come from, so it might bring it back.

Alternatively, I've placed a copy of the spreadsheet in my Google Drive: https://drive.google.com/file/d/1CjDEe-vWdMM6wapu60mZ1iBGtZOVCa5o/view?usp=sharing That may work better than sharing via One Drive, which I always find to be a bit "twitchy".

Edit: downloading a copy of the spreadsheet from the Google Drive link worked for me.
4 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 » Fri May 08, 2020 8:34 pm

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.
Last edited by Arnaud on Fri May 08, 2020 8:50 pm, edited 2 times in total.
0 x


Return to “Language Challenges”

Who is online

Users browsing this forum: No registered users and 2 guests