Komonoway

Export To Excel

15 posts in this topic

Would it be possible to allow an "export to excel" or "csv" function. I enjoy plotting the many data-related aspects of my life in statistics software and this would greatly assist! Thank you!

Share this post


Link to post
Share on other sites

Would it be possible to allow an "export to excel" or "csv" function. I enjoy plotting the many data-related aspects of my life in statistics software and this would greatly assist! Thank you!

You can already do this... :cool:

Look in the bottom right of your query. (Your Username and/or Computer ID must match for the export link to appear.)

Also, if you want to, you can actually refine your search down the way you want it... then export what you need.

For instance, if I searched for the last 7 days, upload tests only...

  1. First click on 'your stats'
    post-2-0-97817000-1303800410_thumb.png
  2. Narrow down to 7 days...
    post-2-0-88935100-1303800409_thumb.png
  3. Clicking the up/down arrow in the results will narrow down by type.
    post-2-0-82337000-1303800496_thumb.png
  4. The click export at the bottom..
    post-2-0-75724900-1303799636_thumb.png

Once you get your CSV you can manipulate it yourself from there. :-D

Share this post


Link to post
Share on other sites

Mind = Blown

I know , he's like that, sneaks in features that we don't know we need yet , then when we do he's there to point them out . Wild

Dunealex likes this

Share this post


Link to post
Share on other sites

Mind = Blown

Thanks ;)

I know , he's like that, sneaks in features that we don't know we need yet , then when we do he's there to point them out . Wild

One of my next tasks coming up will be making some videos. A few quick videos outlining how I personally use the site. I'm sure there are a ton of features that you guys haven't even realized are there yet.

Yeah, sorry I haven't been letting you guys know about every little thing. As I said in a previous post, I'd rather spend my time building instead of talking about what I've built. ... 'Cept right now, I'm on a little break. :-)

-CA3LE

Oh... and the export feature has been here for like 5 years. But I have made it recently work better.

Dunealex likes this

Share this post


Link to post
Share on other sites

That is an awesome feature!

Now let´s take it one step further:

I´d like to be able to export the average speeds tested by everyone for my type of connection (50k) in the whole region (i.e. my city).

That would enable me to make statistics about the best time to get full speed in the week and for every day. I´m really interested in which day and time gives the best results.

Thx in advance!

Share this post


Link to post
Share on other sites
1 hour ago, Dunealex said:

That is an awesome feature!

Now let´s take it one step further:

I´d like to be able to export the average speeds tested by everyone for my type of connection (50k) in the whole region (i.e. my city).

That would enable me to make statistics about the best time to get full speed in the week and for every day. I´m really interested in which day and time gives the best results.

Thx in advance!

 

Thanks for the suggestion.  I could make it easier for you and just give you the ability to aggregate results across 24 hours.  I may be able to whip something like that together in a couple hours.

Share this post


Link to post
Share on other sites
3 hours ago, Dunealex said:

I´d like to be able to export the average speeds tested by everyone for my type of connection (50k) in the whole region (i.e. my city).

That would enable me to make statistics about the best time to get full speed in the week and for every day. I´m really interested in which day and time gives the best results.

Thx in advance!

 

Average speed aggregated by hour of day.

 

Here's Vodaphone DSL as a whole...  All numbers in Mbps.  Keep in mind that I can't differentiate between your providers packages.

HOUR Download AVG  
0 11.28
1 11.01
2 13.00
3 12.15
4 9.75
5 10.62
6 10.56
7 10.43
8 11.10
9 10.30
10 8.72
11 8.78
12 8.32
13 7.64
14 7.14
15 8.65
16 9.64
17 9.02
18 10.74
19 8.87
20 10.55
21 10.47
22 10.87
23 13.87
HOUR Upload AVG  
0 1.99
1 1.94
2 3.38
3 1.98
4 1.72
5 1.95
6 1.81
7 2.04
8 1.86
9 1.78
10 1.65
11 1.75
12 3.32
13 1.82
14 1.79
15 1.78
16 2.57
17 1.84
18 1.60
19 1.60
20 2.20
21 1.64
22 1.83
23 2.02

Your detected city is Alzenau DE.  There aren't enough results to make an accurate plot.  So I'm looking to Frankfurt DE.  The largest city close to you.

HOUR Download AVG  
0 24.93
1 28.93
2 41.31
3 30.63
4 23.94
5 35.25
6 38.32
7 39.03
8 28.17
9 10.00
10 16.33
11 38.49
12 69.68
13 18.31
14 11.56
15 18.29
16 19.24
17 6.07
18 24.01
19 26.02
20 5.47
21 7.43
22 3.60
23 16.32
HOUR Upload AVG  
0 5.59
1 7.69
2 6.06
3 7.11
4 4.36
5 5.11
6 6.78
7 5.23
8 6.44
9 4.18
10 6.15
11 4.45
12 2.99
13 5.04
14 4.57
15 2.61
16 9.35
17 1.43
18 7.83
19 7.23
20 0.72
21 4.05
22 2.88
23 0.79

Vodaphone DSL, Germany (DE) only

HOUR Download AVG  
0 6.84
1 9.78
2 20.56
3 14.71
4 6.27
5 8.47
6 17.10
7 11.12
8 15.94
9 19.06
10 7.74
11 9.41
12 7.94
13 8.91
14 4.11
15 9.96
16 11.72
17 4.69
18 6.41
19 4.56
20 4.54
21 4.52
22 9.51
23 9.98
HOUR Upload AVG  
0 0.72
1 1.58
2 4.93
3 2.09
4 1.46
5 1.77
6 1.45
7 1.48
8 2.62
9 4.69
10 1.54
11 1.16
12 1.37
13 1.83
14 3.14
15 2.56
16 3.29
17 1.98
18 1.46
19 3.49
20 3.29
21 1.38
22 0.90
23 2.48

 

Thought I'd just get you the numbers for now.  Hope this helps.  I'll give you the ability to run these queries yourself and plot it out on graphs with the next major database release.  

Dunealex and Sean like this

Share this post


Link to post
Share on other sites

Dude, you are seriously awesome! That was quick and uncomplicated!

Those are the avg numbers sorted by time for every day of the week in a whole, right?

I´ll have enough numbers to work with for now :)

Thank you very much!

CA3LE likes this

Share this post


Link to post
Share on other sites
17 minutes ago, Dunealex said:

Dude, you are seriously awesome! That was quick and uncomplicated!

 

Thanks!  If you want to really thank me please share TMN with your friends.  :headbang:

 

17 minutes ago, Dunealex said:

Those are the avg numbers sorted by time for every day of the week in a whole, right?

I´ll have enough numbers to work with for now :)

Thank you very much!

 

Yes, that's all days combined.  We can also aggregate days of the week... and break the days down by hour too.  Great idea.

 

Dunealex likes this

Share this post


Link to post
Share on other sites
Just now, CA3LE said:

 

Thanks!  If you want to thank me please share TMN with your friends.  :headbang:

I already do :) You deserve it! And Frankfurt is actually closer than this "Atzenau" (I never heared of)^^

 

1 minute ago, CA3LE said:

 

We can also aggregate days of the week... and break the days down by hour too.  Great idea.

 

That would be exactly what I´ve been looking for. It´ll be a lot of work for me, but I love doing such stuff. Kinda geeky hobby of mine...

:D 

Sean likes this

Share this post


Link to post
Share on other sites
14 minutes ago, Dunealex said:

I already do :) You deserve it! And Frankfurt is actually closer than this "Atzenau" (I never heared of)^^

 

That would be exactly what I´ve been looking for. It´ll be a lot of work for me, but I love doing such stuff. Kinda geeky hobby of mine...

:D 

 

You'll fit in perfectly here.  I'll work on that function for you.

 

Sorry it doesn't detect your city better, uses GeoIP.  Less accurate at the city level in some regions.  According to MaxMind (TMN uses MaxMind databases) 17% are incorrectly resolved in Germany.  Usually when it's incorrect it will resolve a city >50 miles away.

Dunealex likes this

Share this post


Link to post
Share on other sites
2 minutes ago, CA3LE said:

 

I'll work on that function for you.

 

Ok, now I´m legit impressed^^

3 minutes ago, CA3LE said:

 

You'll fit in perfectly here.

 

 

I´d love living in Colorado ;)

CA3LE likes this

Share this post


Link to post
Share on other sites

I threw a sloppy graph for my provider together, if you´re interested. It seconds my feel about the speed/daytime. But the night surprised me. It was worth while. I´m interested in the results for the whole week day by day now. Maybe there are more surprises :)

 

Have a nice we!

Internetspeed.xlsx

Share this post


Link to post
Share on other sites
8 hours ago, Dunealex said:

I threw a sloppy graph for my provider together, if you´re interested. It seconds my feel about the speed/daytime. But the night surprised me. It was worth while. I´m interested in the results for the whole week day by day now. Maybe there are more surprises :)

 

Have a nice we!

Internetspeed.xlsx

 

Very nice, remember however, 0 in my results is the first hour of the day.. not the 24th.   ... programmers logic. 

mudmanc4 likes this

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now