Statistics - bend it anyway you like!

[+Porky2]

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.

[+TechnoNut]

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.

 

The GSAK macro, FindStatsGen does that automagically for you.

 

Start using GSAK, its highly worth it! See my profile for what GSAK does

 

[+FlyingSyringe]

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.

 

Well *almost anything* is possible. However if you are wanting to compare other cachers distances it would require one to have all the logs for each user one wishes to compare (Danie may have these, or as complete as is possible at present).

One other bug that creeps in though is that not everyone logs **correctly** this being either in the order that they found their caches or even necessarily on the right day, and that's not even mentioning the fact that there are known logging issues from certain mobile platforms.

 

So in short, yes but with caveats.

[+DRDM & Raider]

I'm curious... who will be able to (Danie?) do the following stats:

 

Archived vs Available caches (based on Traditional, Multi, Wherigo, Letterbox & Mystery caches) for the caches placed in the last year. (per region)

 

ALSO

 

Who is the most sustainable cache planter. (ignore non cache planters of course)Based on Traditional, Multi, Wherigo, Letterbox & Mystery caches

 

 

i.e. Person A planted 1st cache on 1 June 2004, and since planted 100 (of which 40 are archived)

so sustainable factor = 1 / ( {# of archived caches} / {# of total caches} ) / {# of years since 1st cache placed}

SF = 1 / [ ( 40 / 100 ) / 7 ]

SF = 1 / 0.057143

SF = 17.5

 

another example:

Person B planted 1st cache on 1 June 2010, and since planted 30 ( of which 10 are archived )

SF = 1 / [ (10 / 30 ) / 1 ]

SF = 1 / 0.33333

SF = 3

 

Edited June 8, 2011 by DRDM & Raider

[+DamhuisClan]

If Danie doesn't beat me to it, I can have a look. Should be easy with SQLite.

[+DamhuisClan]

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.

[+DamhuisClan]

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.

[+TechnoNut]

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

[+DamhuisClan]

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?

[+DamhuisClan]

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.

[+DamhuisClan]

Ok, I removed 'E' and 'C' type caches.

 

 

In the case of no archived caches , I just take the total divided by the number of years.

[+DamhuisClan]

 

This factor does not seem fair though... paddawan should be higher up then Madsons. as he is more sustainable (offered more to the community over a longer period.

Suggestions?

[+DamhuisClan]

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.

[+DRDM & Raider]

Thanks Anton,

 

Yes - we did think about that.

 

As stated before:

You have to based the caches on Traditional, Multi, Wherigo, Letterbox & Mystery caches (In archived & Total hidden)

[ One has to exclude earth & virtuals - never gets archived theoretically... ] - and then the obvious ones [ event & cito ]

Also, for those who have not archived anything, (They will go on the "cachers to strive towards", so just award say 1000 point (or move to a separate list, they might never archive a cache because of the good hide etc.) [ Theoretically the function will tend to infinity... ]

Another thing, you should strictly not round the years and keep it as a fraction (date of 1st plant - current date = fractional value)

We did think of a more complex solution which will be more accurate.

Assume we give a "grace" for archiving a cache after 10 years, then one could award a archive score for each archived cache.

then Total score = 1 / {sum of archived scores} / { total hidden (Trad,Multi,Wherigo,Letter,Mystery) }

Where archived scores = 1 - ( {age of cache} / 10 ) where the {age of cache} >= 10 = 10

So a cache that last a week will have a age score of ~ 1

And a cache of 9 years will have a score of 0.1

(10 years and above = 0) - linear "depreciation" of a cache

But the first method was the "quickest" and easiest to get a fair indication of what's what...

 

[+DRDM & Raider]

Just thought about your suggestion that padawan should be higher than madsons...

well.. Sustainability is about keeping your caches alive for longer... 2 / 120 = ~ 1% loss, madsons have 0% (so as mentioned before, they might never archive a cache, but they should be moved to a different list as the function will "bomb" out as it will tend towards infinity)

 

Jacques

[+cincol]

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!!

[+DRDM & Raider]

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!!

 

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

 

[+DamhuisClan]

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!!

 

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.

[+DRDM & Raider]

1st draft:

 

SF Stats (One could call it the South African Sustainability Stats)

[+cincol]

1st draft:

 

SF Stats (One could call it the South African Sustainability Stats)

 

Thanks - the stats look interesting. BTW, Turtletoes/Biggie a.k.a. Cache Hunter Enjoying Finds [CHEF] appears to be a USA cacher who slipped into your figures. I cannot find any SA caches that he has hidden. Perhaps "Florida" was read as being east of Krugersdorp!?

Edited June 10, 2011 by cincol

[+MadSons]

Now I feel like Buzz Lightyear: "to infinity and beyond!"

[+DRDM & Raider]

2nd Draft.

 

I forgot to filter the 1st Draft on SA caches only - small mistake....

 

South African SF Stats

 

[+Hesamati]

Must admit I'm not entirely sure what your figures mean, but two theoretical points re your calculations:

1) You should not only take the ratio between archived and active caches into account but also the absolute nr of active ones. As it stands you'll get the same ration (ie same weight in equation) for 1/5 and 2/10, while the nr of active caches are 4 and 8 respectively and surely a higher number of active caches points to a more "sustained contribution". Suggest (1 / 5 x 4)

2) Similarly, using the time between 1st and last cache planted in stead of total time from 1st plant will more accurately reflect continuous (sustained) activity and differentiate from an initial "flash in the pan".

[+cincol]

Must admit I'm not entirely sure what your figures mean, but two theoretical points re your calculations:

1) You should not only take the ratio between archived and active caches into account but also the absolute nr of active ones. As it stands you'll get the same ration (ie same weight in equation) for 1/5 and 2/10, while the nr of active caches are 4 and 8 respectively and surely a higher number of active caches points to a more "sustained contribution". Suggest (1 / 5 x 4)

2) Similarly, using the time between 1st and last cache planted in stead of total time from 1st plant will more accurately reflect continuous (sustained) activity and differentiate from an initial "flash in the pan".

 

Perhaps removing those with less than 10 hidden caches might also help as it should indicate that those cachers are more "committed" to hiding??

Edited June 13, 2011 by cincol

[+FlyingSyringe]

Must admit I'm not entirely sure what your figures mean, but two theoretical points re your calculations:

1) You should not only take the ratio between archived and active caches into account but also the absolute nr of active ones. As it stands you'll get the same ration (ie same weight in equation) for 1/5 and 2/10, while the nr of active caches are 4 and 8 respectively and surely a higher number of active caches points to a more "sustained contribution". Suggest (1 / 5 x 4)

2) Similarly, using the time between 1st and last cache planted in stead of total time from 1st plant will more accurately reflect continuous (sustained) activity and differentiate from an initial "flash in the pan".

 

Indeed this is probably a more "definitive" approach to the STF values that DrDM & Raider and FlyingSyringe have decided to create. The one thing though is that the query to produce those more spot on results will require quite a bit of coding to create the algorithm. So for now the stats as displayed will give us an indication of how cache placers are putting back into the sport. In time when one of has the spare time, then the algorithm may be written.

[+DRDM & Raider]

Must admit I'm not entirely sure what your figures mean, but two theoretical points re your calculations:

1) You should not only take the ratio between archived and active caches into account but also the absolute nr of active ones. As it stands you'll get the same ration (ie same weight in equation) for 1/5 and 2/10, while the nr of active caches are 4 and 8 respectively and surely a higher number of active caches points to a more "sustained contribution". Suggest (1 / 5 x 4)

2) Similarly, using the time between 1st and last cache planted in stead of total time from 1st plant will more accurately reflect continuous (sustained) activity and differentiate from an initial "flash in the pan".

 

 

hmm - on point 1)

I did originally think of that, but Sustainability is defined as maintaining something. In the case of 1/5 vs 2/10 - in both cases the person only managed to maintain 20% of their caches, meaning that the SF 'should' be the same... the year factor was brought in to balance long standing caches. (So if you have 1/5 after year 1, and 1/5 after year 2, the latter should have a higher SF)

 

Ultimately, one should assume a cache lifespan is say 10 years. Then give each archived cache a Archived Score - that follows a depreciation line over 10 years (i.e. a cache that lasted 1 min will have a AS = 1, and those that lasted 10 years will have a AS = 0. [ Then sum them all up and divide by your total caches ] - but this is more complex to code for...

 

2) You could, but then you will need to work on {Archived - 1}, since that would be the 'gap' between the 1st and last.

 

I do agree that one has to discard some outliers due to too few hides etc, but as a quick check - it's a fair indication...

[+TechnoNut]

1) You should not only take the ratio between archived and active caches into account but also the absolute nr of active ones.

2) Similarly, using the time between 1st and last cache planted in stead of total time

 

1) Sustainability is defined as maintaining something.

 

2) You could, but then you will need to work on {Archived - 1}, since that would be the 'gap' between the 1st and last.

 

I do agree that one has to discard some outliers due to too few hides etc, but as a quick check - it's a fair indication...

 

I would like to see this topic as a 'Work in Progress'. With good constructive input, we can get something out of this.

 

One also needs to look at the percentage of placements archived (in the html table) - this is an indication of 'how well a cache is placed'. Archives are invariably due to muggling and / or extreme weather so attention to these points is an indication of the degree of preparation going into the cache placement.

 

A 'placement activity' factor can be calculated by determining average placements per year of caching. (also now in the html table)

 

2c.

[+Danie Viljoen]

Bolandl was the 7000th cacher to log something in South Africa, on 14 June 2011.

[+Wazat]

How many copy and paste logs are there in South Africa... LoL

[+DamhuisClan]

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.

[+Danie Viljoen]

I assume you calculated the distance using the sequence the caches have been logged? (This is of course a huge assumption...)

[+DamhuisClan]

I assume you calculated the distance using the sequence the caches have been logged? (This is of course a huge assumption...)

 

Correct. First ordered it by Date, and then by LogID, both in Ascending order.

[+DamhuisClan]

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.

[+Wazat]

How many copy and paste logs are there in South Africa... LoL

 

Wow ... the results are nothing as expected:

 

By Type Count

Fish Eagle Publish Listing 2469

Blah

Blah

Blah

Blah

Blah

Blah

(yes I copied and pasted that)

geoaware Publish Listing 100

 

If you exclude Found it and Published etc?

[+Wazat]

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.

 

19 44,681.61 Wazat

 

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

Is that all? Eish. Just over 10% of my Odometer reading in the car. But then I must take off about 5000 km for my trips to the EC and WC cause there i flew down. Also about 100km of walking on trails and such. And add about 100 000km for driving in circles. Hee hee

[+TechnoNut]

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

25 40,209.16 RedGlobe

175 7,262.67 PORKY2

etc

 

 

Anton - how did you calculate this? I have a TB - TB3MEAJ - that I dip into every found cache (in the correct order) and this TB has

40728 km according to GS. It is also a reason for my multiple write note c&p logs - I had already done plenty caches when I got the TB and and retrospectively dipped it.

 

PT

[+Hesamati]

 

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......

 

 

Assume you only used Southern African logs to calculate this...? Had a quick look at some profiles which have GSAK stats and although some (e.g. DiePienaars yours=85,578km GSAK 85,158km) are very similar others are way off (e.g. GlobalRat yours=95,014km GSAK=313,670km & Hesamati yours=74,224km GSAK=211,531).

If it's only SA caches the more than 3-fold difference between TV&M and iPajero is also surprising. 11Mkm to sign log sheets...!! Interesting indeed - thanks!

[+FlyingSyringe]

 

Anton - how did you calculate this? I have a TB - TB3MEAJ - that I dip into every found cache (in the correct order) and this TB has

40728 km according to GS. It is also a reason for my multiple write note c&p logs - I had already done plenty caches when I got the TB and and retrospectively dipped it.

 

PT

 

Obviously not speaking for Anton, but I presume that he has based his calculations on South ( perhaps Southern ) Africa caches. So your TB distance is probably based on trips including trips to Europe / America so the extra thousands of km's come from the spanning distances.

 

It also depends on if *all* your found logs are present ( and you logged in the correct order to be accurate ) in Anton's Data Base which is not a guarantee with the way that GS only includes 5 logs in each pocket query, so there may be gaps here and there. This would probably compound for older caching teams, depending on how long Anton has been keeping logs on caches.

 

As to Wazat's quip, the caching distance is only a small percentage of actual distance covered as the calculations are based on Great Circle distances between caches. There would be no way to accurately get road distance, as no one knows which roads you actually took and how many circles you drove before you reached GZ .

Edited June 22, 2011 by FlyingSyringe

[+DamhuisClan]

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.

[+DamhuisClan]

Wow ... the results are nothing as expected:

 

If you exclude Found it and Published etc?

 

Anything more on this I think would become a "blame game", so I'll leave the results where they are.

 

I think 99% of the "duplicate logs" are all fair use of duplication.

[+DamhuisClan]

 

By Type Count

Fish Eagle Publish Listing 2469

.....

geoaware Publish Listing 100

 

Please IGNORE the stats above they are WRONG!

Some people have contacted me, asking me to check my facts ... as something did not look right.

Digging deeper, I came up with quite a few hundred empty logs in my database, and double checking 5 entries for various cachers to see that there are NON-DUPLICATE entries on the web page.

This means my database does not have all the correct info for these stats.... and it seems I maybe should never have opened this can of worms.

I am not sure how to delete the post to stop further misunderstandings.

[+Wazat]

It was actually tounge in cheek from my side. Just rustling some feathers... Not to worry. Is there a way of seeing which cachers seem to get the most frequent finds on new caches. To put it this way:

 

Cache gets published and cachers rush out to get it. Who are the most prolific chasers of new caches in other words. Maybe focus on the day a cache gets published and finds on that particular day.

[+DiePienaars]

 

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......

 

 

Hi Anton, How about a similar calculation, but only the distance between Events and CITO’s, so that we can see who is the most travelled social cacher in SA.

[+DamhuisClan]

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......

 

 

Hi Anton, How about a similar calculation, but only the distance between Events and CITO's, so that we can see who is the most travelled social cacher in SA.

 

Again a huge surprise. ... so much to that I think there is maybe an error.

TOTAL Distance for Southern Africa: 268,704 km

 

Top event cache distance visitors according do my calculations:

 

DamhuisClan 8901.024006

Noddy 8483.315898

GEO936 8267.681125

Discombob 8258.984758

RedGlobe 7588.371661

Wazat 7435.409473

Fish Eagle 7202.037354

Tricky Vicky & Mickey 6093.851535

gerhardoosMPsa 5990.347845

ZAlandyman & Susieq 5871.430397

Jors 5683.843704

cache-fan 5192.124821

cownchicken 4729.975466

iPajero 4659.209001

BruceTP 4652.250881

CrystalFairy 4404.670074

DiePienaars 4250.444473

Goofster 4216.520666

rodnjoan 3966.207902

cincol 3825.312019

MadSons 3540.019806

Ysbeer 3539.161729

Sonsoekster 3351.443795

JPMZA 3198.146542

Whostops 2923.582075

I&J 2908.769686

g.i.s. 2878.871712

iNokia 2770.940884

JohnDou 2751.755118

peterch0204 2623.386266

Jesscat0204 2622.200018

Carbon Hunter 2588.126758

Far-Jar-Hug 2555.513641

 

I would have expected iPajero, and Fish Eagle to be at the top.

Maybe it implies they plan better?

Edited June 26, 2011 by DamhuisClan

[+DamhuisClan]

What is the most common log entry?

 

1st : "TFTC" with 1086 entries.

2nd : "Logged from my phone using the Geocache Navigator by Trimble" with 275 entries.

3rd : "TFTC!" with 169 entries.

4th : "tftc" with 99 entries

5th : "TNLNSL" with 94 entries.

6th : "Easy find" with 76 entries.

7th : "Tftc" with 74 entries

8th : "Easy find. TFTC" with 68 entries.

9th : "Found it" with 65 entries

10th: "Thanks" with 61 entries.

 

In this in a total of 292,719 log entries (Finds, Notes, etc).

 

I have omitted a few "TB visits" and the likes such as "Maintenance reminder..." etc.

 

The second one might be that the owner of the log entry later on updated his log entry on the web site, but the newest GPX file received only had the last 5 entries, and thus my DB was never updated.

 

[+Danie Viljoen]

Most active cachers over the past year:

The following cachers have found (or attended) the most African caches in the period 21 July 2010 to 20 July 2011:

1. iPajero: 1526 caches

2. MadSons: 1253 caches

3. Leon St: 994 caches

3. B and C inc: 994 caches

5. TechnoNut: 746 caches

6. Danie Viljoen: 742 caches

7. Antron: 694 caches

8. AndyT1: 650 caches

9. Elsies: 640 caches

10. Tricky Vicky & Mickey: 631 caches

[+Danie Viljoen]

Most popular African caches over the past year:

The following caches have been found the most during the period 21 July 2010 to 20 July 2011:

1. GC2GG2C Nobel Square, Cape Trio, Cape Town: 154 finds

2. GC1DB1F Marracache, the Mailers, Morocco: 123 finds

3. GCMYYZ Table Top Trove, Richter Family, Cape Town: 119 finds

4. GC1956A Valley of the Kings, marzcz, Egypt: 115 finds

5. GC2AA8R SS: RMS Athens, paddawan, Cape Town: 110 finds

6. GC2G27Z "O".... I'm famous, blitsseun, Cape Town: 105 finds

6. GC2EE3W SS: De Visch, paddawan, Cape Town: 105 finds

8. GC2CG7X Bertram Garden TB Hotel, mr panda, Cape Town: 102 finds

9. GC114RH Cape Town TB Hotel, The Huskies, Cape Town: 94 finds

10. GC1A0PP Hurghada Sunrise, kpihus, Egypt: 92 finds

[+Danie Viljoen]

Most finds on own caches:

The following cache planters have received the most find (and attended) logs:

1. louwtjievdw: 7279

2. CrystalFairy: 6266

3. dakardrix: 4847

4. Fish Eagle: 4343

5. GEO936: 3756

6. paddawan: 3707

7. NotBlonde: 3633

8. cache-fan: 3573

9. Noddy: 3163

10. The Huskies: 2823

[+Danie Viljoen]

Most prolific cache planters:

1. Fish Eagle: 209

2. louwtjievdw: 170

3. CrystalFairy: 166

4. Wazat: 144

5. paddawan: 123

6. GEO936: 116

6. dakardrix: 116

8. NotBlonde: 105

8. SawaSawa: 105

10. iPajero: 104

[+Danie Viljoen]

Number of active caches per province:

1. Western Cape: 1389

2. Gauteng: 1277

3. Kwazulu Natal: 1011

4. Eastern Cape: 611

5. Mpumalanga: 547

6. Free State: 364

7. Limpopo: 257

8. North West: 220

9. Northern Cape: 101

 

Rest of Africa: 1009

 

Municipalities with the most active caches:

1. City of Cape Town: 792

2. City of Tshwane: 520

3. City of Johannesburg: 439

4. eThekwini: 403

5. Ehlanzeni: 395

6. Amatole: 218

7. Motheo: 188

8. Overberg: 178

9. Cacadu: 175

10. Cape Winelands: 161