EBTCheck - notes check online - and a few statistics

[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

[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

[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

[aloxe]

I have to share my new president graph. I don't think anybody has a strange bird like this…

[Montgomery Burns]

That's awesome.

[marty44]

That's awesome.

Yes
But goal should it be to use the notes check to correct the faulty notes

[aloxe]

… when possible

[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 (24.03 KiB) Viewed 4141 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.

[marty44]

fixed

[lmviterbo]

Well done, thanks!

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

[marty44]

the idea is good, but currently I have no idea how to solve this with SQL commands

[lmviterbo]

Here are a few other requests

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

[marty44]

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

[lmviterbo]

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)