Jump to content

DamhuisClan

+Premium Members
 View Profile  See their activity

  • Posts

    1064

  • Joined

  • Last visited

 Content Type 

Posts posted by DamhuisClan

    Statistics - bend it anyway you like!

    in South Africa

    Posted

    The distances are only based on "Found it" and "Attended" logs, and is for Southern Africa only.

     

    I am sure I am missing lots of logs though, as I only get the last 5 logs per pocket query. To mitigate this I try and run it on Saturday and Sunday then again on Wednesday, thus getting 3 sets of South Africa logs per week. I run our neighbouring countries only once a week.

     

    So as soon as a cacher has left Southern Africa to go cache, the distance will be wrong.

     

    I also ordered the results first by Date, and then LogID (Each log we make gets a unique ID associated with it)

    Then I calculate using the specified formula the distance between the cache and the previous cache (for the same user ID of course)

     

    So the distance is as the crow flies from Cache Find to Cache Find.

     

    I had a total of 227,999 entries in Excel which Excel had to calculate a distance for. It slowed my machine right down to a crawl.

    Statistics - bend it anyway you like!

    in South Africa

    Posted

    Is it possible to get the distances travelled by cachers, the same way that distances are reported for the TB's.It will be interesting to compare that list to the numbers found.

     

    I took the challenge, and came up with a result. However I could not use a pure SQLite solution, and had to copy the basic results into a spreadsheet, and do some trigonometry functions from there.

     

    Here is the Distance Calculations I used. If there is a better one please let me know, and I'll re-calculate.

     

    The combined total distance every cacher in Southern Africa has travelled is 11,590,239.73 km.

     

    The top 100 distance cachers are (and I added Porky2 and their position as they requested the stats):

     

    ......drum roll......

     

    Pos, Distance, Name

    1 246,366.41 Tricky Vicky & Mickey

    .....

    64 26,323.04 DamhuisClan

    ......

    175 7,262.67 PORKY2

     

    If anybody would like the spreadsheet let me know and I'll email it to you.

     

    As an interesting side note, I use a program called FizzyCalc to calculate my Cache to Cache distance, on a seperate spreadsheet.

    I just updated it and that distance is 25,936.94 .... so for me the above stats are out by about 400 km.

    Statistics - bend it anyway you like!

    in South Africa

    Posted

    Is it possible to get the distances travelled by cachers, the same way that distances are reported for the TB's.It will be interesting to compare that list to the numbers found.

     

    I took the challenge, and came up with a result. However I could not use a pure SQLite solution, and had to copy the basic results into a spreadsheet, and do some trigonometry functions from there.

     

    Here is the Distance Calculations I used. If there is a better one please let me know, and I'll re-calculate.

     

    The combined total distance every cacher in Southern Africa has travelled is 11,590,239.73 km.

     

    The top 100 distance cachers are (and I added Porky2 and their position as they requested the stats):

     

    ......drum roll......

     

    Pos, Distance, Name

    1 246,366.41 Tricky Vicky & Mickey

    2 115,297.48 cownchicken

    3 95,013.99 GlobalRat

    4 85,578.04 DiePienaars

    5 80,221.04 Noddy

    6 77,915.02 gerhardoosMPsa

    7 75,907.90 iPajero

    8 74,224.20 Hesamati

    9 71,348.80 Colinbo

    10 70,104.61 Larks

    11 67,916.34 Trackinfind

    12 65,227.42 haggishound

    13 62,839.01 speedstripe

    14 60,160.41 The Huskies

    15 54,025.58 battlerat and pussycat

    16 53,197.38 miking

    17 50,532.50 Fish Eagle

    18 45,949.95 Ysbeer

    19 44,681.61 Wazat

    20 44,250.34 Brick

    21 43,985.47 Discombob

    22 43,963.38 iNokia

    23 43,736.65 cache-fan

    24 40,682.66 CrystalFairy

    25 40,209.16 RedGlobe

    26 39,504.35 Bjbez

    27 38,518.89 Carbon Hunter

    28 37,527.97 Jin & Tonic

    29 35,717.54 Far-Jar-Hug

    30 35,373.13 warthog

    31 34,845.43 Team_Olo

    32 34,616.91 Urban Hunters

    33 34,408.69 Danie Viljoen

    34 34,033.80 Megaben

    35 33,694.01 Elsies

    36 33,401.26 KeithWood

    37 33,366.14 McBirdie

    38 33,107.04 besem

    39 32,767.07 Wildbirds

    40 32,163.72 Stormers

    41 31,380.63 ddpisani

    42 31,258.34 veer-ini-hoed

    43 31,237.25 stephennb

    44 30,580.05 HeinG

    45 30,547.82 Boris

    46 30,547.82 boris

    47 30,528.55 rodnjoan

    48 29,755.16 Goofster

    49 29,611.22 W@lly

    50 29,362.97 Leon St

    51 29,053.08 GEO936

    52 28,485.09 Stefanoodle

    53 28,414.96 Blackjack Bailey

    54 28,305.68 Gerald

    55 27,528.64 DRDM & Raider

    56 27,309.74 g.i.s.

    57 27,216.60 Littleclan

    58 27,180.64 adysally

    59 27,128.36 B and C Inc

    60 27,082.93 BAKGAT

    61 27,082.47 dakardrix

    62 26,791.90 QFC

    63 26,432.94 Wormgeocash

    64 26,323.04 DamhuisClan

    65 26,242.47 Kwenda Tafuta

    66 26,186.13 gwily

    67 25,908.31 CapeDoc

    68 25,907.59 I&J

    69 25,657.86 hennieventer

    70 25,463.98 series land rover

    71 25,413.17 carlstein

    72 25,324.45 colinaly

    73 25,157.10 bosveldklong

    74 24,851.64 Henzz

    75 24,820.67 Team Ginger

    76 24,478.06 Thrips

    77 24,474.00 ZAlandyman & Susieq

    78 24,230.01 Tugelaklip

    79 24,119.97 vespax

    80 23,799.53 Antron

    81 23,267.17 GS&Dogs

    82 23,267.17 GS&Dogs

    83 22,820.83 Harryhound

    84 22,753.95 Seeker Two

    85 22,726.25 StirfS

    86 22,721.60 Rhino and Hedgehog

    87 22,415.28 MadSons

    88 22,331.36 the pooks

    89 22,327.06 Zambesiboy

    90 22,314.03 Wespresso

    91 22,282.84 j4pos

    92 22,237.88 Orgulas

    93 22,208.41 Starsky&Hutch

    94 22,167.75 Skola & Lingiwe

    95 21,941.00 Krazong

    96 21,864.68 JustinDett

    97 21,796.34 Rensburg

    98 21,678.10 tomtwogates

    175 7,262.67 PORKY2

     

    If anybody would like the spreadsheet let me know and I'll email it to you.

    Statistics - bend it anyway you like!

    in South Africa

    Posted

    These stats look very interesting. How would this affect cachers who cache [live] in different countries but have a high percentage of finds and hides in SA? Just a thought and maybe a challenge for the geeks like Damhuisclan!! :unsure:

     

    Hi,

     

    I only have stats for inside SA, but that would mean it will be sustainability within SA, which is fine.

     

    I have done the first run (thanks to Anton for the data. I am just working on the SF formula to make it a better representation of the Sustainability, will post results before Monday :)

     

    DRDM & Raider is 100 % correct. We only have data for South Africa. In fact I now have the data for Southern Africa.

    So the stats can only reflect this.

    Statistics - bend it anyway you like!

    in South Africa

    Posted

    Is it possible to get the distances travelled by cachers, the same way that distances are reported for the TB's.It will be interesting to compare that list to the numbers found.

     

    Hi Porky2

     

    This would be very difficult, as I am not sure how to track the exact order of the caches. If the order wasn;t an issue, then the co-ord to distance calcultion becomes an issue.

    I have tried in the past to see if I could calculate it in Excel using Sin, Cos, and Tan, but could not get reliable distances.

     

    Maybe one day when I am bored, and up to date with everything I can have another go at it.

    Statistics - bend it anyway you like!

    in South Africa

    Posted

    Lets try and answer the "Total" portion of the question first. then I'll try and refine it a little further:

     

    I fear though that if no caches have been archived then that person does not show up so the "Ratio" or "Sustainability factor" needs to be refined.

     

    Methinks Anton, that you should exclude 'event' type caches - e.g. CITO and events.

     

    My 2c.

     

    PT

     

    Happiness. I have changed that now, but now iPajero falls through the cracks, as their one cache was an event which was archived.

    And now that 0 div something give a ration of 0. Not sure how to correct this.

     

    Suggestions?

    Statistics - bend it anyway you like!

    in South Africa

    Posted

    I had a quick look last night, I have the numbers, but there seems to be a problem with the final calculation as Archived is sometime 0 (zero), and it seems my current query is only returning whole numbers (even after the calculation). I' hope to look at it in more detail tonight.

    Mark as Found or Not

    in South Africa

    Posted

    I happen to have one of those caches.

     

    Again in PE.

    Its Recife Vista (GCRT26)

     

    As per the cache listing, if one found the old cache at the old location one could find it again at the new location.

    I also claimed a FTF for the find at the new location...

     

    Seems like all the strange caches happens for me in PE. :anicute:

    New eTrex range from Garmin

    in South Africa

    Posted

    I was at Garmin SA the other day to get my new replacement eTrex Legend from an insurance claim, and asked them when they will receive the new eTrex range.

    "What new eTrex range?" I was asked.

    "The new 10, 20 and 30 eTrex", I answered/

    "Never heard of it" was the reply.

     

    Other then that I had great service from Garmin, and had good assistance from them unlocking my new 2011.1 topo & rec map.

     

    Just a pity that there was a muggle selling wares next to the cache close by.

    Mark as Found or Not

    in South Africa

    Posted

    There are some exceptions to the rule I think:

     

    Exception 1:

    I have found a cache a long time ago, and then later adopted it. Then I have "found" my own cache from the adoption

     

    Possible Exception 2:

    I had a cache in PE, which I wanted to archive. I received a request from someone who wanted to adopt it, which we did as well.

    Then the cache was moved, due to it being muggled often. I think.. since it is in a new location that I can "find" it now. As it is a legitimate search for the cache.

    BTW: I still need to go and find it.. possibly on my next trip to PE.

     

    Any comments?

    New eTrex range from Garmin

    in South Africa

    Posted

    Yep I like mine current eTrex Legend as well.

     

    When I got off the bike the other day, it fell, and somehow the power switch broke.

    Took it to Garmin for a quote, and they don't repair but will replace it with a new unit for R950.00.

     

    That is a new unit, and they transfer my current 2009 maps to the new unit (I don't get 2011 maps)

    So now I am ooh-ing and ahh-ing if I should not maybe spend the extra R900.00 and just buy a new one with the new maps, or maybe wait a little bit, and spend even more and get one of the eTrex 10 coming out soon. I wonder when they will arrive in South Africa.

×
×
  • Create New...