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.
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.
Super Challenge: questions and discussion
-
Online
- Blue Belt
- Posts: 870
- 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=19785
- x 2882
- Contact:
Re: Super Challenge: questions and discussion
You do not have the required permissions to view the files attached to this post.
Last edited by jeffers on Sat May 09, 2020 7:33 pm, edited 1 time in total.
18 x
Le mieux est l'ennemi du bien (roughly, the perfect is the enemy of the good)
French SC Books: (0/5000 pp)
French SC Films: (0/9000 mins)
French SC Books: (0/5000 pp)
French SC Films: (0/9000 mins)
- Lianne
- Green Belt
- Posts: 457
- Joined: Mon Jul 20, 2015 3:29 pm
- Location: Canada
- Languages: Speaks: English (N)
Actively studying: French (low int)
Dabbling in: Italian (beginner), ASL (beginner), Ojibwe (beginner), Swahili (beginner)
Wish list: Swedish, Esperanto, Klingon, Brazilian Portuguese
Has also dabbled in: German, Spanish, toki pona - Language Log: https://forum.language-learners.org/vie ... hp?t=12275
- x 1298
- Contact:
Re: Super Challenge: questions and discussion
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!
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.
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
: French SC (Books)
: French SC (Films)
: Italian Half SC (Books)
: Italian Half SC (Films)
Pronouns: they/them
: French SC (Films)
: Italian Half SC (Books)
: Italian Half SC (Films)
Pronouns: they/them
- IronMike
- Black Belt - 2nd Dan
- Posts: 2554
- Joined: Thu May 12, 2016 6:13 am
- Location: Northern Virginia
- Languages: Studying: Esperanto
Maintaining: nada
Tested:
BCS, 1+L/1+R (DLPT5, 2022)
Russian, 3/3 (DLPT5, 2022) 2+ (OPI, 2022)
German, 2L/1+R (DLPT5, 2021)
Italian, 1L/2R (DLPT IV, 2019)
Esperanto, C1 (KER skriba ekzameno, 2017)
Slovene, 2+L/3R (DLPT II in, yes, 1999) - Language Log: viewtopic.php?f=15&t=5189
- x 7266
- Contact:
Re: Super Challenge: questions and discussion
Hopefully rdearman & Co. will have success with their coding and IT stuff they're doing now.
2 x
You're not a C1 (or B1 or whatever) if you haven't tested.
CEFR --> ILR/DLPT equivalencies
My swimming life.
My reading life.
CEFR --> ILR/DLPT equivalencies
My swimming life.
My reading life.
- rdearman
- Site Admin
- Posts: 7259
- Joined: Thu May 14, 2015 4:18 pm
- Location: United Kingdom
- Languages: English (N)
- Language Log: viewtopic.php?f=15&t=1836
- x 23304
- Contact:
Re: Super Challenge: questions and discussion
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...
EDIT: I added the request to the issues on GitHub if anyone would like to have a go themselves!
EDIT: I added the request to the issues on GitHub if anyone would like to have a go themselves!
3 x
: Read 150 books in 2024
My YouTube Channel
The Autodidactic Podcast
My Author's Newsletter
I post on this forum with mobile devices, so excuse short msgs and typos.
My YouTube Channel
The Autodidactic Podcast
My Author's Newsletter
I post on this forum with mobile devices, so excuse short msgs and typos.
- MamaPata
- Brown Belt
- Posts: 1019
- 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 1808
Re: Super Challenge: questions and discussion
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!
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.
- lingua
- Blue Belt
- Posts: 951
- Joined: Sun Mar 13, 2016 11:23 pm
- Languages: English (N)
Maintaining: italiano (B2/C1ish)
Studying: português, Latina
Dabbling: siciliano, Deutsch, français, piemontèis
Abandoned: ไทย, español - Language Log: https://forum.language-learners.org/vie ... 15&t=12257
- x 2024
Re: Super Challenge: questions and discussion
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 2022-23:
DE: books: film:
IT: books: film:
PT: books: film:
Output Challenge 2023:
IT: write: record:
PT: write: record:
PT: Read 100 books:
DE: books: film:
IT: books: film:
PT: books: film:
Output Challenge 2023:
IT: write: record:
PT: write: record:
PT: Read 100 books:
- Lianne
- Green Belt
- Posts: 457
- Joined: Mon Jul 20, 2015 3:29 pm
- Location: Canada
- Languages: Speaks: English (N)
Actively studying: French (low int)
Dabbling in: Italian (beginner), ASL (beginner), Ojibwe (beginner), Swahili (beginner)
Wish list: Swedish, Esperanto, Klingon, Brazilian Portuguese
Has also dabbled in: German, Spanish, toki pona - Language Log: https://forum.language-learners.org/vie ... hp?t=12275
- x 1298
- Contact:
Re: Super Challenge: questions and discussion
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
: French SC (Books)
: French SC (Films)
: Italian Half SC (Books)
: Italian Half SC (Films)
Pronouns: they/them
: French SC (Films)
: Italian Half SC (Books)
: Italian Half SC (Films)
Pronouns: they/them
-
Online
- Blue Belt
- Posts: 870
- 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=19785
- x 2882
- Contact:
Re: Super Challenge: questions and discussion
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
Le mieux est l'ennemi du bien (roughly, the perfect is the enemy of the good)
French SC Books: (0/5000 pp)
French SC Films: (0/9000 mins)
French SC Books: (0/5000 pp)
French SC Films: (0/9000 mins)
-
- Blue Belt
- Posts: 984
- Joined: Sat Jul 18, 2015 11:57 am
- Location: Paris, France
- Languages: Native: French
Intermediate: English, Russian, Italian
Tourist : Breton, Greek, Chinese, Japanese, German, Spanish, Latin - Language Log: viewtopic.php?t=1524
- x 2172
Re: Super Challenge: questions and discussion
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.jeffers wrote:Edit: downloading a copy of the spreadsheet from the Google Drive link worked for me.
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
-
Online
- Blue Belt
- Posts: 870
- 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=19785
- x 2882
- Contact:
Re: Super Challenge: questions and discussion
Arnaud wrote: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.jeffers wrote:Edit: downloading a copy of the spreadsheet from the Google Drive link worked for me.
Strange indeed. However, the number for challenge level can be edited manually.
0 x
Le mieux est l'ennemi du bien (roughly, the perfect is the enemy of the good)
French SC Books: (0/5000 pp)
French SC Films: (0/9000 mins)
French SC Books: (0/5000 pp)
French SC Films: (0/9000 mins)
Return to “Language Challenges”
Who is online
Users browsing this forum: jeffers and 2 guests