Excel: Track PBs & compare to WRs (w/ import function)

General discussion about DSJ3.
Bjørn
Posts: 13
Joined: 21 Feb 2010, 20:06
Location: Norway

Excel: Track PBs & compare to WRs (w/ import function)

Post by Bjørn »

EDIT: Updated March 7, 2010

The latest version can be found here.

(Use this link if your Excel version is older than 2007. There may be some loss of functionality, since it had to be converted to an older file format.)

WHAT DOES IT DO?

Imports
- your personal best (PB) records (Mediamond web site)
- the national records (NR) (Mediamond web site)
- the (true) world records (WR) (koti.mbnet.fi web site)
- your national and world ranking for each hill
- the date of your records
- online and peak online rating
- world and national cup points

Compares
- your PBs with the HS (hill size), NRs and WRs
- in both meters and percentage

Visual feedback
- color codes the differences, so it's easy to see where you can improve
- color codes the dates, so you can see how long it's been since you got your PB
- three graphs show how your total length compares to total HS, NR and WR length
- a graph shows how each of your PBs compare to each HS

Sortable
- easy to sort by hill name, hill size, national ranking or whatever you like

WHAT DOES IT LOOK LIKE?

Click on the image below to take a look.

Image

In the screenshot, I've sorted by hill size (HS), and hidden my player name.

HOW TO MAKE IT WORK

- Go to http://www.mediamond.fi/dsj3/personalhillrecords, enter your name and click show
- Copy the address that appears in your address bar (where you type in www.mediamond.fi for example). It will look something like this: - Paste it in the B1 cell of the Excel sheet

Remember to activate macros and data connections when you open the file, or else the import functions won't work!

And that's a wrap... :)




----------------------------------------------------
ORIGINAL POST (Outdated)
Hi!

I'm a new user; just downloaded and registered DSJ3 yesterday, so first of all, hello everyone! :D

I missed a way of better keeping track of my personal records, and also wanted to compare them to the (true) WRs. Therefore I created a little Excel sheet where I can insert my own records, and get the difference between my records and the current WRs, both in meters and in percentage. I also color coded the difference so it's easy to see where I can most easily improve my scores (this happens automatically).

Take a look at this screenshot to get a feel of it (I've inserted some of my poor records!)
Image

Source of the true WRs:
http://koti.mbnet.fi/kahoset/true_world ... hp?list=41

Source of the K-points (is this displayed somewhere in the game?):
http://dsj3.net/index.php?page=rekordy

Is this something anyone else would use? If so, please tell me, and I will upload an Excel template to the web so you can use it too. Both .xlsx and .xls version if needed. Also, is there anything else that I should include or you think is missing?

- Bjørn
Last edited by Bjørn on 07 Mar 2010, 21:01, edited 7 times in total.
Schnitzel
Posts: 95
Joined: 24 Mar 2009, 19:55

Post by Schnitzel »

This looks interesting :wink:
Hills won in WC: 43
Bjørn
Posts: 13
Joined: 21 Feb 2010, 20:06
Location: Norway

Post by Bjørn »

Hi again!

Just wanted to let you know that I've updated the Excel sheet:

It now includes an import function. If you copy your scores from http://www.mediamond.fi/dsj3/personalhillrecords into the sheet, a macro will import your data correctly, including your PB, your national and world ranking for that hill, and also the date of the record.

I also included a graph that compares the total length of the true WRs with the total length of your own records.

The following screenshots show the process of importing the scores, and how they will show up when you've imported them:

1) The default template without any scores:
Image

2) What to copy from the Mediamond web site:
Image

3) Where to put these scores in the Excel sheet:
Image

4) After importing:
Image

PS: I've only been playing for two days, and most of the hills I've tried only once, so no teasing! :D
Bjørn
Posts: 13
Joined: 21 Feb 2010, 20:06
Location: Norway

Post by Bjørn »

You can now download the file from here:
http://uploading.com/files/7cb498fa/DSJ ... heet.xlsm/

I've made it easier to import your scores. The only thing you need to do is go to http://www.mediamond.fi/dsj3/personalhillrecords, type in your name, and copy the link you get in the address field into the Excel sheet. The address will look something like this:

http://www.mediamond.fi/dsj3/personalhi ... ersion=1.6

Then all you have to do is click the "Import now!" button. Hope you'll enjoy! :)

PS: Be sure to enable macros and data connections once you open the file, or else the import function won't work.
Stuttgarter
Posts: 7
Joined: 23 Feb 2010, 12:00

Post by Stuttgarter »

Thank you !!! This tool is excelent !!!

If you plan a update of this excel sheet: It is possible to get in the natinal records. For me the WR are not realy a target - at the fist step I plan to get a good national ranking :o) ...
TPo
Posts: 549
Joined: 12 Jan 2010, 20:15
Location: Finland

Post by TPo »

The TWR list seems to be outdated.
Bjørn
Posts: 13
Joined: 21 Feb 2010, 20:06
Location: Norway

Post by Bjørn »

Stuttgarter wrote:Thank you !!! This tool is excelent !!!

If you plan a update of this excel sheet: It is possible to get in the natinal records. For me the WR are not realy a target - at the fist step I plan to get a good national ranking :o) ...
No problem, I've now included a function that imports the national records as well.

Here's a new screen shot of how things look after you've imported both your personal records and the national records. I've taken the liberty to use Severin Freund as an example (hope you don't mind!):

http://img202.imagevenue.com/aAfkjfp01f ... _551lo.jpg

Just remember to copy your personal record link (as described earlier) into the B1-cell, and everything will work as it should.

Here's the link to the new version:
http://uploading.com/files/adbaa9ca/DSJ ... 2529.xlsm/

Tell me what you think, and if it needs improvements.

Enjoy! :)
Bjørn
Posts: 13
Joined: 21 Feb 2010, 20:06
Location: Norway

Post by Bjørn »

TPo wrote:The TWR list seems to be outdated.
Do you know where to find an updated TWR list? I just included the first one I found. Of course, you can change the true world records to your own liking if you choose to download the file :)
TPo
Posts: 549
Joined: 12 Jan 2010, 20:15
Location: Finland

Post by TPo »

Bjørn wrote:
TPo wrote:The TWR list seems to be outdated.
Do you know where to find an updated TWR list? I just included the first one I found. Of course, you can change the true world records to your own liking if you choose to download the file :)
The 4th record in the world list would do fine, i think.
Jose_Bach
Posts: 348
Joined: 02 Feb 2009, 22:45
Location: Finland
Contact:

Post by Jose_Bach »

Björn, I can update TWR list. It's my brother's site and I and he can upload it always when we just remember :)

edit: now should be updated.
Petri Kähkönen
My YouTube-channel (piano videos, for example my own compositions, arrangements etc.): http://www.youtube.com/user/BachJose -
promaster
Posts: 109
Joined: 26 Feb 2010, 17:56
Location: Poland
Contact:

Post by promaster »

Hey, Bjoern, this tool is fantastic! I didn't used the original sheet, I've just created my own. I've included also average jump lenght on the graph. You can also make some other summarys, now I haven't got any ideas for something neew, but if I've got one, I'll tell you.
Motz Kolosowski
Posts: 24
Joined: 02 Feb 2010, 02:08

Post by Motz Kolosowski »

:D
Last edited by Motz Kolosowski on 27 Feb 2010, 01:50, edited 1 time in total.
Motz Kolosowski
Total Length: 7732,05m
Bjørn
Posts: 13
Joined: 21 Feb 2010, 20:06
Location: Norway

Post by Bjørn »

Jose_Bach wrote:Björn, I can update TWR list. It's my brother's site and I and he can upload it always when we just remember :)

edit: now should be updated.
Thank you! I've added a function that automatically updates the TWRs. The function checks the TWR list on your site, and copies them to the sheet.

I'll probably upload the new version tomorrow.
Bjørn
Posts: 13
Joined: 21 Feb 2010, 20:06
Location: Norway

Post by Bjørn »

I've uploaded a new version and updated my first post on the top of the page with new information.
promaster
Posts: 109
Joined: 26 Feb 2010, 17:56
Location: Poland
Contact:

Post by promaster »

Hi, Bjørn!

I've just wanted to look at new version of your tool. So, I've downloaded it, and... I can't open it, because you are using Excel 2007 or higher, so you save in xlsm file, and I'm using Excel 97, which can't open this file. Could you save this file in xls file, please?

-Promaster.
Post Reply