![]() |
CSV statistic
Hi Czechoslovakian Wolfdogs lovers worldwide !
The CSV statistic tool is online, this can be viewed as a "statistic plugin" for the great wolfdog.org. The description page is here: http://www.amicale-chien-loup-tcheco...m/csvstat.html (direct to the tool: http://www.amicale-chien-loup-tcheco...gi-bin/form.py) Unfortunately I no longer have time for forums, for contact info please refer to the contact information on the description page. Hope this will help people, long and healthy live to all your dogs ! Cheers Anthony |
Dear Anthony,
Many thanks for this tool! A few months ago I already used an earlier version you made available, but this one is much more extensive and user friendly; very usefull for breeders as well as statistic lovers and all wolfdog interested in general. Regards Robbert |
Thanks :cool3 95 % of the breeders LOVES you :love the rest probably hates you :lol:
Very best regards / Mikael |
Thank you!
I only found time to have a look at in yet but I think it will be a great tool. Ina |
Hi all, thanks for support !
Feel free to take a look from time to time to the description page as I add features (hopefully) periodically. Last important adds about the coefficient of inbreeding calculation: "- Note: you can see two different parts for the Coefficient of inbreeding calculation, the first uses the formula: Sum (1/2)^n1+n2+1 (formula used by wolfdog.org) which suppose common ancestors have a COI=0% (which is not true most of the cases => the coefficient is under estimated) ; the second uses the complete formula: Sum (1/2)^n1+n2+1 * (1+Fa), this one takes in account the COI of common ancestors (better, but still a bit under estimated: Fa obtained from 8 generations with 3 converging passes. However, the result is now acceptably accurate.)." One exemple of changes: Hathor Crying Wolf: Wright's coefficent on 5 generations: 19.43359375%, becomes with complete formula: 26.2852315791% As you can see the difference between results can be huge, so I encourage breeders to use the complete formula. (BTW: Saarloos lovers, I added same statistic engine site for the Saarloos breed (link on the description page)... interesting to compare the formation of these two breeds). Cheers |
Amazing!
I know here isn't the best place to ask something, that have the mail for this and so on... But have the possibility of add a search by the country where the dog live? |
Good idea, I will try to add this soon.
|
Here it is Paula, just added on the site ("Find dogs living in country:"). I made a quick check, all seems working good, let me know if one find dysfunction. (NB: dogs name, breeder name, date are still clickable fields).
Enjoy ! |
Elf!
You are amazing!!! Thank you!!!:gent Marcy |
I had no time to look at it earlier, but I'm really impressed!!! Congratulations, Elf:cool3 You should get a Laurel Wreath from the breeders for such a useful and user-friendly tool.8)
|
Thanks!
Let me know if one think about other useful options. Cheers |
Quote:
|
Sure, here it is ;).
|
Quote:
|
Quote:
Haha, super cool and super-fast. Is a wonderful tool, I love it. LG Franziska |
Great tool ! Thanks a lot :cool3
|
Added PRA search.
|
You are very fast! Thanks! :cool3
|
Oooopssss, I think there is some error, for example:
http://www.amicale-chien-loup-tcheco...untry=Bulgaria Yes I am Bulgarian, but both with my dog live in Italy ... Below there written Quk and Italian origin but lives in Bulgaria ... I understand it, I've made a mistake to interpret? ps: sorry my English |
pps: you can change, thanks? We live in Ravenna, Italy
For the rest is really great, my compliments |
Hi, here is how it's processed, for each dog if there is owner informations I put for the dog as living place the country the owner entered. I guess this works most of the time, but as we see not 100% (e.g. if the owner entered its contry of origin and lives outside it, or if there is co-ownership).
The best way for changes would be to modify (PM to Admin ?) your informations http://www.wolfdog.org/fra/dbase/o5142.html ; you can also add the city and your dog will be showed (next update) in "Find dogs living in city:". |
Thank's very much, Elf !:Rose
|
Quote:
I added for "Find dogs born in year:" the mean COI (on 5 and 8 generations) for the chosen year. This gives since 1990: Mean COI on 8 generations: http://www.amicale-chien-loup-tcheco...ean_coi_8G.png Mean COI on 5 generations: http://www.amicale-chien-loup-tcheco...ean_coi_5G.png So if the former rule was to try to be less than 10% on 5 generations, let's roll the new rule, less than 5% on 5 generations. |
Nice work Elf.
Would it be possible to have sorting option (or filtering), for for example the country of origin, HD, ED, bonitation code etc? |
Hello Saschia, I added a filter by country for:
"Find dogs born in year:" "Find dogs with HD:" "Find dogs with ED:" "Find dogs with PRA:" "Enter expression to find in bonitation:" "Enter expression to find in training:" If one want no filter by country just select "All countries". |
So fast ;o) thanks!
|
Quote:
Added also average AVK (in "Find dogs born in year:" and "Find breeder"). This gives since 1990: Average AVK on 8 generations: http://www.amicale-chien-loup-tcheco...rage_avk8G.png Average AVK on 5 generations: http://www.amicale-chien-loup-tcheco...rage_avk5G.png |
Quote:
And one thing more, even if I do not wont you to work your self to death ;-) is it possible to add whitch dogs are not alive :| ??? And I just wont to add again, Excellent work Dr Anthony :klatsch The breed loves you Auuuuuuuu-:wolf After all we wont happy wolf not crying wolf :grins Best regards / Mikael |
Quote:
|
Quote:
|
I think this might be a problem, as not all deaths are accounted for and then you wouldn't know which dog is alive and which is just not reported. Unless you took the age of say 18 years as suspected dead unless proven alive.
|
Quote:
But I wonder if will be possible to pass this information also for the statistics in the easy way. |
Hello Antony,
Really a fantastic tool as I already wrote. I've already made several interseting studies with it. Quote:
What worries me a little bit is that I discovered that almost all dogs, even in the last years, have a COI, measured on ALL generations, of about 20% or higher. You rarely see one with a COI less than 17% measured on ALL generations. I wonder if it could be possible to measure the COI of all dogs born in year X measured on all generations? It might be very interesting to discover whether the COI measured on ALL generations in recent years is reduced and to what extent. Anthony, thanks again. Great job! |
Great tool! Well done!
Can you add a search, who find out where the most dogs in a country come original from? For example in France: are the most in foreign countrys bought dogs from Czech Republik or Slovakia or maybe Italy? That will be very interesting. |
Quote:
On the other hand, although the animals from for example one litter are very related, they nevertheless have different genes, different expression levels of the same genes etc. Plus there are always changes in the genome in the form of mutations, deletions, duplications etc. So after some number of generations these changes may have larger effect than the relatedness of the animals. So that's another reason why taking into account all generations is not sensible. So, in breeding it is good to take into account the COI and AVK coefficients, but not use them as the only leading tool - because you can get them closer to ideal values by just breeding a lot with young animals therefore increasing the number of generation in certain time interval, while it is important to select which animals to use according to their health, character and exterior. |
Quote:
Quote:
Quote:
Quote:
Quote:
For the future, I think dog's mean kinship coefficient would be one of the very important coefficient to take into account when one choose how many time to reproduce a dog. I cannot provide this coefficient in real time in the tool because it would require long time of calculation for each dog, but I maybe could do it offline, then add it in the DB. |
More than 10000 connexions, glad people are using it, hope it helps.
Added in "Wolfblood" GSD composing the dog, no reason to forget them :). Exemple for Furcas: Furcas Wolfblood Following graphs representing size repartition (from bonitation code) Female and Male (%/cm): Female: http://www.amicale-chien-loup-tcheco...epartition.png Male: http://www.amicale-chien-loup-tcheco...epartition.png Eventually I calculated mean kinship coefficient for all dogs born after 1995: "A conservation biologist would consider the individual with the lowest mean kinship to be the most genetically valuable in terms of maintaining diversity in the population, and would try to favor that individual in a breeding program." I decided not to publish them as it could represent a kind of ranking that may be used in a wrong way. Anyway if at some point it may be needed in some programs keep in mind that it does exist. Cheers and happy new year to all, two and four legs ! |
Thanks this was very good info :)
Best regards / Mikael |
Elf, is your tool connected to the wolfdog.org database? If not, is it possible to update the data from time to time (every 6 months or every year), or would it be too complicated? I mean, lots of pups were born recently, many dogs were bonitated and tested, many gained breeding rights and this might have changed a bit the overall statistics...
On the other hand, I think it would be interesting to keep the consecutive versions intact in some archives for further comparisons, to see the directions of the breed developement... |
Unfortunately the tool in not connected to the wolfdog database, I can update from time to time (last DB update in October) but it's a bit complicated and I don't success to motivate myself to do this often :(. The best way ahead would be to make this tool a part of wolfdog.org and use directly its database, I can provide help, it's up to the Admin.
|
Quote:
Very best regards / Mikael |
I guess Admin is already overloaded ;).
|
"Character transmission" ; should probably be arranged in categories...
Number of occurrence : Father + Mother => Offspring 107 : Of + Of => Of 54 : Of + Of => Oh 46 : Of + Og => Of 42 : Of + Og => Og 41 : Of + Oh => Oh 40 : Og + Of => Of 34 : Of + Oh => Of 32 : Oh + Of => Of 32 : Of + Of => Og 31 : Og + Og => Of 29 : Of + Oh => Og 25 : Og + Oh => Of 25 : Of + Og => Oh 23 : Oh + Oh => Og 22 : Oh + Oh => Of 22 : Og + Og => Og 21 : Of + Od => Oh 21 : Of + Od => Of 20 : Og + Oc => Og 18 : Oh + Oh => Oh 18 : Of + Oc => Of 18 : Od + Of => Of 17 : Of + Of => Od 16 : Oh + Of => Oh 16 : Og + Of => Og 15 : Oh + Og => Of 15 : Og + Of => Oh 14 : Of + Og => Od 14 : Of + Of => Ob 14 : Of + Oc => Og 13 : Of + Og => Oc 13 : Of + Ob => Oh 12 : Oh + Oh => Od 12 : Of + Od => Og 12 : Of + Ob => Of 11 : Oh + Og => Og 11 : Og + Oh => Oh 11 : Og + Of => Od 11 : Og + Oc => Of 11 : Of + Og => Ob 11 : Of + Of => Oc 10 : Oh + Oc => Oh 10 : Og + Oh => Og 10 : Og + Og => Oh 10 : Of + Oh => Oc 9 : Og + Od => Of 9 : Og + Oc => Od 9 : Of + Oc => Oh 9 : Of + Ob => Ob 8 : Oh + Of => Od 8 : Og + Og => Od 8 : Og + Og => Oc 8 : Of + Oh => Od 8 : Of + Od => Od 8 : Of + Oc => Od 8 : Of + Ob => Og 8 : Of + Ob => Oc 7 : Oh + Of => Og 7 : Oh + Of => Oc 7 : Og + Oh => Od 7 : Og + Oc => Oh 7 : Og + Oc => Oc 7 : Og + Oc => Ob 7 : Of + Oh => Oi 7 : Of + Oh => Ob 7 : Of + Oa => Of 6 : Oh + Oh => Ob 6 : Og + Of => Ob 6 : Of + Oi => Of 6 : Of + Od => Oc 6 : Of + Ob => Od 6 : Od + Of => Og 6 : Oc + Of => Oh 5 : Oh + Oh => Oi 5 : Oh + Og => Oh 5 : Oh + Od => Of 5 : Oh + Oc => Og 5 : Og + Oi => Og 5 : Og + Oh => Oi 5 : Og + Oh => Ob 5 : Og + Od => Og 5 : Of + Of => Oi 5 : Of + Od => Ob 5 : Of + Oc => Oc 5 : Oc + Oh => Of 5 : Ob + Oh => Oh 5 : Ob + Ob => Og 4 : Oh + Oi => Og 4 : Oh + Og => Oc 4 : Oh + Od => Od 4 : Og + Oh => Oc 4 : Og + Od => Od 4 : Og + Ob => Og 4 : Of + Oi => Oi 4 : Of + Oi => Oh 4 : Of + Oc => Oi 4 : Of + Oc => Ob 4 : Of + Oa => Oh 4 : Oe + Of => Of 4 : Od + Ob => Of 4 : Ob + Oi => Og 4 : Ob + Oh => Ob 4 : Ob + Og => Oh 4 : Ob + Og => Og 3 : Oh + Oi => Oh 3 : Oh + Oi => Of 3 : Oh + Oh => Oc 3 : Oh + Of => Oi 3 : Oh + Od => Oh 3 : Oh + Od => Og 3 : Oh + Od => Oc 3 : Oh + Oc => Oi 3 : Oh + Oc => Of 3 : Oh + Oc => Od 3 : Oh + Oc => Ob 3 : Oh + Oa => Oh 3 : Oh + Oa => Og 3 : Oh + Oa => Ob 3 : Of + Oh => Oa 3 : Of + Og => Oi 3 : Of + Og => Oe 3 : Of + Of => Oe 3 : Of + Oe => Og 3 : Of + Oe => Of 3 : Of + Ob => Oi 3 : Oe + Oh => Oh 3 : Oe + Oh => Of 3 : Od + Of => Od 3 : Oc + Oh => Og 3 : Oc + Oh => Oc 3 : Oc + Of => Og 3 : Ob + Od => Og 3 : Ob + Ob => Of 3 : Ob + Oa => Oh 2 : Oi + Oi => Oh 2 : Oi + Oi => Og 2 : Oi + Oi => Od 2 : Oi + Oh => Og 2 : Oi + Oh => Oa 2 : Oi + Og => Oh 2 : Oi + Of => Oh 2 : Oi + Of => Og 2 : Oi + Of => Of 2 : Oh + Og => Od 2 : Oh + Og => Ob 2 : Oh + Of => Ob 2 : Oh + Oc => Oc 2 : Oh + Ob => Oh 2 : Oh + Ob => Of 2 : Oh + Oa => Of 2 : Og + Oh => Oe 2 : Og + Og => Ob 2 : Og + Of => Oc 2 : Og + Od => Oh 2 : Og + Od => Oc 2 : Og + Ob => Oh 2 : Og + Ob => Of 2 : Of + Oi => Od 2 : Of + Oi => Oc 2 : Of + Oe => Oh 2 : Of + Od => Oa 2 : Of + Oa => Og 2 : Of + Oa => Oc 2 : Oe + Og => Oe 2 : Oe + Og => Ob 2 : Oe + Of => Od 2 : Oe + Ob => Od 2 : Oe + Ob => Ob 2 : Od + Oh => Og 2 : Od + Of => Oh 2 : Od + Od => Og 2 : Od + Od => Of 2 : Od + Od => Oc 2 : Od + Oc => Og 2 : Oc + Oh => Oh 2 : Oc + Of => Of 2 : Oc + Oc => Og 2 : Oc + Ob => Og 2 : Ob + Oh => Og 2 : Ob + Oh => Of 2 : Ob + Of => Ob 2 : Ob + Od => Od 2 : Ob + Ob => Ob 1 : Oi + Oi => Of 1 : Oi + Oi => Oc 1 : Oi + Oi => Ob 1 : Oi + Oh => Oi 1 : Oi + Oh => Of 1 : Oi + Oh => Od 1 : Oi + Oh => Ob 1 : Oi + Og => Oi 1 : Oi + Og => Oc 1 : Oi + Og => Ob 1 : Oi + Od => Og 1 : Oi + Oc => Oi 1 : Oi + Oc => Og 1 : Oi + Oc => Oc 1 : Oi + Oc => Ob 1 : Oi + Ob => Ob 1 : Oh + Oi => Oi 1 : Oh + Oi => Oa 1 : Oh + Oh => Oe 1 : Oh + Og => Oi 1 : Oh + Of => Oa 1 : Oh + Oe => Oh 1 : Oh + Oe => Og 1 : Oh + Od => Oi 1 : Oh + Ob => Og 1 : Oh + Oa => Oa 1 : Og + Oi => Oh 1 : Og + Oi => Of 1 : Og + Oi => Ob 1 : Og + Og => Oi 1 : Og + Og => Oe 1 : Og + Og => Oa 1 : Og + Of => Oi 1 : Og + Of => Oa 1 : Og + Od => Ob 1 : Og + Oc => Oi 1 : Og + Ob => Od 1 : Og + Ob => Ob 1 : Og + Oa => Oh 1 : Og + Oa => Og 1 : Of + Oi => Og 1 : Of + Oi => Oe 1 : Of + Oi => Oa 1 : Of + Oh => Oe 1 : Of + Og => Oa 1 : Of + Of => Oa 1 : Of + Oe => Oc 1 : Of + Od => Oi 1 : Of + Oc => Oa 1 : Of + Ob => Oe 1 : Of + Oa => Ob 1 : Of + Oa => Oa 1 : Oe + Oh => Og 1 : Oe + Oh => Oc 1 : Oe + Og => Og 1 : Oe + Og => Od 1 : Oe + Og => Oc 1 : Oe + Of => Oh 1 : Oe + Of => Oe 1 : Oe + Of => Oc 1 : Oe + Of => Ob 1 : Od + Oh => Of 1 : Od + Og => Oh 1 : Od + Og => Of 1 : Od + Of => Oi 1 : Od + Of => Oc 1 : Od + Of => Ob 1 : Od + Od => Oh 1 : Od + Od => Oe 1 : Od + Od => Od 1 : Od + Od => O? 1 : Od + Oc => Od 1 : Od + Oc => Oc 1 : Od + Ob => Oh 1 : Od + Ob => Od 1 : Od + Ob => Ob 1 : Oc + Oh => Ob 1 : Oc + Og => Of 1 : Oc + Og => Oc 1 : Oc + Og => Ob 1 : Oc + Og => Oa 1 : Oc + Of => Oi 1 : Oc + Of => Oc 1 : Oc + Od => Og 1 : Oc + Oc => Od 1 : Oc + Oc => Oc 1 : Oc + Ob => Oh 1 : Oc + Ob => Of 1 : Oc + Ob => Od 1 : Oc + Ob => Oc 1 : Oc + Ob => Ob 1 : Oc + Oa => Oh 1 : Oc + Oa => Og 1 : Oc + Oa => Od 1 : Ob + Oi => Of 1 : Ob + Oi => Ob 1 : Ob + Oi => Oa 1 : Ob + Oh => Od 1 : Ob + Oh => Oa 1 : Ob + Og => Of 1 : Ob + Og => Ob 1 : Ob + Of => Oh 1 : Ob + Of => Og 1 : Ob + Od => Oi 1 : Ob + Od => Of 1 : Ob + Oc => Ob 1 : Ob + Ob => Oi 1 : Ob + Ob => Oh 1 : Ob + Ob => Oa 1 : Ob + Oa => Og 1 : Ob + Oa => Of 1 : Ob + Oa => Oc 1 : Oa + Oc => Og |
This is a little bit difficult for me as a behaviourist. I can remember occasions when I wouldn´t agree with the charactertest-result. We have seen one czech bonitation where dogs that showed severe fear aggression in messurement got OF because they attacked in the learned situation of defense. All in all the charaktertest has a very high "training factor."
I don´t want to discuss this all over again but this is a point where your statistic programm will have a very high amount of mistakes compared to reality. Ina |
This is only raw data (with all it implies), I let humans make the interpretation ;).
|
Dear all,
I lately was wondering about character transmission in the breed. As we can see in bonitation code stats, transmission seems to be high. Also reported by J. Jedlička here: http://www.sky.cz/seda-eminence/povahycsv.pdf : "Because different types of character does not lie on the linear scale is obtained from the frequency to determine the overall character or additive variance and heritability identify methods of regression parents and offspring, or siblings of the correlation. We have, however, subject to overlapping generations, data needed to determine dedivosti realized, and in this way an estimate of heritability interval h2 = <0.40, 0.49>, ie 40 to 49%. In the context of published work referred overview of literature on the value of unexpected high." The values from litterature (exemple paper: The genetic contribution to canine personality : http://www3.interscience.wiley.com/c...18232/PDFSTART ), are really much lower: http://ametiste.ifrance.com/genetic_...ersonality.png So, biais introduced from bonitation, or really breed caracteristic ? |
Posts gathering:
Added "CZ breeding groups" feature in the Stat tool, let me know if it's working properly. You can also use + feature between IDs to simulate a mating. Exemples: Akim z Revíru vlku Akim z Revíru vlku + Arielle la Seven Loup Cie BREEDING GROUPS Here is what can help, I added "Breeding groups" to the tool, basically it search in a dog pedigree (or planned mating) the presence of another dog (and its %). Let say I want to know if Cett Malý Bysterec has Amur z Dáblova kanonu in it's pedigree, I find both dog ID with Find ID, then in "Enter dog ID:" I enter the ID of Cett Malý Bysterec (6382) and in "ID to check in pedigree: " the ID of Amur z Dáblova kanonu (796) It gives: http://www.amicale-chien-loup-tcheco...d_to_check=796 http://www.amicale-chien-loup-tcheco...ng_group_1.PNG => Amur z Dáblova kanonu is not in Cett Malý Bysterec pedigree Check for Káj z Rosíkova CS in Cett Malý Bysterec pedigree: http://www.amicale-chien-loup-tcheco...d_to_check=929 => Káj z Rosíkova CS is in Cett Malý Bysterec pedigree, and we see how. Check for Dinon Dánon Fehérlófia in Oliver Passo del Lupo pedigree: http://www.amicale-chien-loup-tcheco..._to_check=1043 NB: we can also use the + operator to check for a mating, for exemple does Cutt ---dell Irco Sortiere--- (3584) would be in pedigree of Furcas z Peronówki (7818) + Orion Eden severu (7968), I enter 7818+7968 in Enter dog ID and 3584 in ID to check in pedigree: http://www.amicale-chien-loup-tcheco..._to_check=3584 http://www.amicale-chien-loup-tcheco...ng_group_2.PNG Does Cita z Doušova dvora would be in pedigree of Furcas z Peronówki + Orion Eden severu : http://www.amicale-chien-loup-tcheco...d_to_check=924 And so on... |
Aaaaa, thanks I did not know one can + a dog 8) 8) 8)
Very best regards / Mikael |
I made available in the tool the mean kinship of (living) CSV:
"Find dogs mean kinship, display first xxxx dogs [Display matching dogs]" For each dog the calcul has been made against random 2000 (living) CSV. You can see more info here: http://www.canine-genetics.com/relation.htm |
Hello Anthony,
Many thanks for this very valuable addition to your already fantastic program! The possibility for calculating the COI and the AVK, now together with the Mean Kinship (MK), is a very important tool to prevent further narrowing of the gene pool. For those interested in understanding the mean kinship, here's another site where the considerable interest of animals with a low MK value within a (relatively small) closed population, in the context of the importance of genetic variation is clarified. Great job Anthony! Regards, Robbert |
Hi everyone,
I decided not to upgrade the database of the stat tool, so everything will stay as is. I hope you had nice time learning the CSV with it. Cheers A. |
Quote:
Can we pay you for you time to update it ones a year ??? Very best regards / Mikael |
Quote:
Very best regards / Mikael |
Quote:
That I regret very much! Especially now that the inbreeding/puppy tool no longer works for months on wolfdog. In any case, many thanks for all the work you've put in it; I'll still often use it! |
Sorry, but I'm feeling a bit dumb here :?... What do COI and AVK stand for?
|
Quote:
AVK= Ancestor Loss Coefficient two approaches to calculate the degree of inbreeding of a specific dog or a future litter. Important data for example to take into account in finding a suitable partner for a cover; this, of course, among many other factors to take into account. Through google you will easily find the explanation and the differences of the terms and many practical examples. Unfortunately, the statistic tools at Wolfdog are dysfunctional for months now and for this reason alone the tool of Elf is very important as an alternative. Perhaps even a better alternative since it is much more extensive. For example it also includes the possibility of measuring the Mean Kinship (MK). Also an important factor in the preserving the fragile gene pool. Have a nice sunday |
Thanks, you too.
|
Thanks for the feedback, much appreciate.
|
All times are GMT +2. The time now is 02:56. |
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
(c) Wolfdog.org