EBTCheck - notes check online - and a few statistics

Various EBT statistics can be posted here

Moderators: Fons, Phaseolus

Post Reply
User avatar
marty44
Euro-Expert
Euro-Expert
Posts: 555
Joined: Tue Jun 27, 2006 12:33 pm
Location: Mainz, Germany
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by marty44 »

Another little update at information page. If you have unknown notes, they will be shown in both charts. E.g: http://ebtcheck.marty44.net/ebtcheck/st ... /index.php
User avatar
marty44
Euro-Expert
Euro-Expert
Posts: 555
Joined: Tue Jun 27, 2006 12:33 pm
Location: Mainz, Germany
Contact:

EBTCheck - should be ready for Christine Lagarde notes

Post by marty44 »

I think you saw all the news. Notes signed by Christine Lagarde will be issued in the next few days.
I think I updated all relevant code parts.

If some of you got a new CL note and have uploaded the CSV file, please give me a PN so I can verify that everything works as expected :)

marty
User avatar
marty44
Euro-Expert
Euro-Expert
Posts: 555
Joined: Tue Jun 27, 2006 12:33 pm
Location: Mainz, Germany
Contact:

EBTCheck - added a new chart to travel stats page

Post by marty44 »

I played a little bit around with gnuplot. Travel stats page will now generate one time per month a chart like this:
http://ebtcheck.marty44.net/ebtcheck/st ... 0x1080.png
User avatar
aloxe
Euro-Master
Euro-Master
Posts: 1402
Joined: Sun Aug 03, 2008 8:22 pm
Location: Libeň
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by aloxe »

I have to share my new president graph. I don't think anybody has a strange bird like this…
Attachments
SignaturesHistoric1000x400.png
SignaturesHistoric1000x400.png (22.53 KiB) Viewed 4216 times
a̳l̳o̳x̳e̳ • my other statsmy map of France
User avatar
marty44
Euro-Expert
Euro-Expert
Posts: 555
Joined: Tue Jun 27, 2006 12:33 pm
Location: Mainz, Germany
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by marty44 »

Montgomery Burns wrote:
Sat Jul 11, 2020 3:21 am
That's awesome. :lol:
Yes :)
But goal should it be to use the notes check to correct the faulty notes :)
User avatar
aloxe
Euro-Master
Euro-Master
Posts: 1402
Joined: Sun Aug 03, 2008 8:22 pm
Location: Libeň
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by aloxe »

… when possible
a̳l̳o̳x̳e̳ • my other statsmy map of France
User avatar
lmviterbo
Euro-Master
Euro-Master
Posts: 5241
Joined: Thu Aug 21, 2003 5:23 pm
Location: Lisboa, Portugal
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by lmviterbo »

I just tested the new version, with Lagarde's notes.

In the game "What are you still missing?", Lagarde's combinations aren't bundled (as they are for the previous signatures).
lmviterbo 2020-07-20 122140.png
lmviterbo 2020-07-20 122140.png (24.03 KiB) Viewed 3657 times
Apart from this, everything seems to work smoothly. Well, except the user0 stats, whose heavy pages (Locations and Huge table) crash on every one of my browsers except Firefox.
User avatar
marty44
Euro-Expert
Euro-Expert
Posts: 555
Joined: Tue Jun 27, 2006 12:33 pm
Location: Mainz, Germany
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by marty44 »

fixed :)
User avatar
lmviterbo
Euro-Master
Euro-Master
Posts: 5241
Joined: Thu Aug 21, 2003 5:23 pm
Location: Lisboa, Portugal
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by lmviterbo »

Well done, thanks!
User avatar
lmviterbo
Euro-Master
Euro-Master
Posts: 5241
Joined: Thu Aug 21, 2003 5:23 pm
Location: Lisboa, Portugal
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by lmviterbo »

I have a request that I don't know how difficult it is to implement: a user0 combination of all "nice serial numbers" stats. Of course, this means your have to add these stats first...

If I can help with the mathematical part of it, please pm me.
User avatar
marty44
Euro-Expert
Euro-Expert
Posts: 555
Joined: Tue Jun 27, 2006 12:33 pm
Location: Mainz, Germany
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by marty44 »

the idea is good, but currently I have no idea how to solve this with SQL commands :(
User avatar
lmviterbo
Euro-Master
Euro-Master
Posts: 5241
Joined: Thu Aug 21, 2003 5:23 pm
Location: Lisboa, Portugal
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by lmviterbo »

Here are a few other requests :D :roll:

Under the "Locations" menu:
Locations — "city, country (postcode)": 2283
(I have 2283 unique combinations of city+country+postcode.)

Under the "Shortcode bingo" menu:
Unique shortcodes (regardless of denomination): 15823 (19.10% of all notes = 5.23 notes/shortcode)
(This is a different — and naturally smaller — figure than the only one which at present is being calculated, which for me, reads now "Found 25010 (37.96%) of 65884 possible short codes.")

Under the "Combinations bingo" menu:
Variants — series + value + plate + serial letter(s) + signature: 1448 (89.16%) of 1624 possible variants.
(If I'm not mistaken, there are 470 Europa variants, which added to the 1154 of the 1st series, make 1624 variants. Note that, for this purpose, on Europa S/S and U/U notes, second letter should not be counted.)
Value (cost) of complete collection of variants: 65950 € (3.23% of 2040960 € total value of registered notes, or 89.71% of a collection including all known variants)
(I hope this is clear.)

Under the "Time analysis" menu:
Timestamps: 16385 (19.78% of all notes = 5.06 notes/timestamp)
(I registered my 82833 notes in 16385 different timestamps.)

Under the hopefully coming "Nice serials" menu :mrgreen: :
Repeated serials:
(I have zero repeated serials but it's not impossible — for some combinations — to have the same serial across more than one denomination.)
User avatar
marty44
Euro-Expert
Euro-Expert
Posts: 555
Joined: Tue Jun 27, 2006 12:33 pm
Location: Mainz, Germany
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by marty44 »

lmviterbo wrote:
Sat Aug 15, 2020 4:21 am
Under the "Locations" menu:
Locations — "city, country (postcode)": 2283
(I have 2283 unique combinations of city+country+postcode.)
Hi lmviterbo,
Please have a look at http://ebtcheck.marty44.net/ebtcheck/st ... ations.php
Is it so as you expected?

At which place should be the general "Locations — "city, country (postcode)": 2283" ?

marty

PS: this location page is only temporary, it is not yet in production
User avatar
lmviterbo
Euro-Master
Euro-Master
Posts: 5241
Joined: Thu Aug 21, 2003 5:23 pm
Location: Lisboa, Portugal
Contact:

Re: EBTCheck - notes check online - and a few statistics

Post by lmviterbo »

marty44 wrote:
Sun Aug 16, 2020 7:42 am
Is it so as you expected?
Wow, you really like challenges!

Thanks for the work. It is very detailed and that's nice. However, you are detailing but not counting what I call Locations (which is also the name they get in EBT's database manager "citymanager", and is the combination of country+city+postcode). To include this, your "Number of notes by location" should probably be renamed, and for each country a small tweak is needed, as follows.

Instead of

Number of notes by location (566)
Austria (123 notes, 14 locations)
France (136 notes, 19 locations)
Germany (36975 notes, 405 locations)
Netherlands (34 notes, 11 locations)
Portugal (17 notes, 1 location)
Singapore (190 notes, 1 location)

it should be

Number of notes by city (total cities: 566) and location (total locations: 683)
Austria (123 notes, 14 cities, 16 locations)
France (136 notes, 19 cities, 21 locations)
Germany (36975 notes, 405 cities, 506 locations)
Netherlands (34 notes, 11 cities, 12 locations)
Portugal (17 notes, 1 city, 3 locations)
Singapore (190 notes, 1 city, 10 locations)


If you find this a little confusing, as I do (especially considering that you use the term "Location" elsewhere — at least under Travel stats and Hit locations), you might keep "locations" for what officially is known as cities, and use "places" or "addresses" or "geocodes" or the more precise "geolocated places".

The headers would then look like this:

Number of notes (total 38110) by location (total 566) and geolocated places (total 683)
Austria (123 notes, 14 locations, 16 geolocated places)
France (136 notes, 19 locations, 21 geolocated places)
Germany (36975 notes, 405 locations, 506 geolocated places)
Netherlands (34 notes, 11 locations, 12 geolocated places)
Portugal (17 notes, 1 location, 3 geolocated places)
Singapore (190 notes, 1 location, 10 geolocated places)
Post Reply

Return to “EuroBillTracker Statistics”