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

PS: please can the moderator translate ?

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

tak sa pokúsim v skratke aspoň preložiť, i keď myslím, že asi všetci vedia o čo ide.

bol vytvorený štatistický program pre čsv (v nasledujúcom príspevku sa píše, že boli pridaní aj saarloos vlčiaci - skôr pre zaujímavosť).

na uvedenom linku si vložíte meno psa a dostanete jeho ID, toto vkladáte do okienok a vyhodí vám rôzne štatistiky a údaje.

ďalej sa píše o dvoch rôznych spôsoboch výpočtu wrightovho koeficientu, ktorý je na stránke k dispozícii, jeden, čo používa aj wolfdog a druhý všeobecný a sú možné aj veľké rozdiely, ako je uvedené na príklade psa Hathor Crying wolf. preto odporúča viac používať všeobecný vzorec, ktorý je presnejší.

------------------
myslím, že je to zaujímavá stránka, resp. program, dá sa tam veľa toho zistiť, podiel vlčej krvi toho ktorého vlka u daného jedinca a dajú sa vyfiltrovať napr. psy podľa DBK výsledkov a podobne.

Petra

nema este psika zatial len zhanam informacie pocul som ze tieto psi su plache a ze ztekaju je to pravda

to akoby si sa spytal, ci ludia maju vlasy a obliekaju si tricka
a ani temu si netrafil
vela stastia pri studiu plemena, potom sa skus vratit a spytat sa nieco k veci

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.

COI predpokladam ze je Coefficient of inbreeding, cize v laickom preklade miera pribuzenskej plemenitby. Pekne ze je mozne sledovat trendy v case. Pokial viem, Elf vytvoril (alebo pracuje) na moznosti vyhladavania aj podla krajiny, takze by sa teoreticky dalo sledovat rozne tendy v roznych krajinach.

Thanks for traduction Saschia.

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

Takze dalsie info pre tych co by sa pobavkali so statistikou - pridane filtre na krajinu vo vyhladavani psov a pridany vypocet priemerneho AVK = Ancestor Loss Coefficient - co znamena ake percento moznych predkov v skutocnosti existuje - v idealnom pripade je to 100%, ale ak niektory z predkov figuruje na viacerych poziciach rodostromu tak sa koeficient znizuje.

Ahoj, ty grafíky jsou velmi zajímavé. Mě by velmi zajímal ten graf podle krajin, ale nevím jak na to. Ty ano?

Musis si v tej polozke Dogs born in year vybrat rok a krajinu a potom v hornej casti tabulky su priemerne hodnoty COI a AVK. Alternativa je vybrat vsetky krajiny, exportovat si to do excelu alebo databazy a potom si to sortovat a spracovavat offline.

CSV size repartition (%pop / cm):

Female

http://www.amicale-chien-loup-tcheco...epartition.png


Male

http://www.amicale-chien-loup-tcheco...epartition.png

Preklad prispevku od elf:

grafy zobrazuju rozdelenie danych vysok v populacii CSV (pre znalych statistiky histogram distribucie). Horny graf suky, dolny graf psy.

Zajímavé by určitě bylo, kdyby " elf " zpracoval kohoutkovou výšku psů a fen narozených v určitém období až po současnost....generace po generaci.
Takhle to je celkem " nic neříkající " ale i snaha se cení :)

Monika

Monika, dam elfovi vediet o zaujme o takyto graf, ale upozornujem ze v principe pri troche snahy to dokaze kazdy, databaza je volne dostupna, jedine co treba je poprenasat v nej vytvorene statisticke data do tabuliek a potom graficky zobrazit.
Este drobna otazka - co myslite generaciu po generacii? Statistiky vzdy sa nejakych 4-6 rokov spolu?

toto presne napadlo aj mna - zachytit vyvoj pocas rokov a sucasny trend, ci a ako vazne ide ta vyska dole (pripadne hore)

What should be most interesting ? Possible slices (one fixed boundary, or not):

- 2010->2005, 2010->2000, 2010->1995 etc...

or

- 1975->1980, 1975->1985, 1975->1990 etc...

or

- 1975->1980, 1980->1985, 1985->1990 ...

What are your thoughts ?

I think no fixed boundaries - just to see the differences among following half-decades. Or, always 5-year groups but with the first and last year overlapping with previous/next groups.

I wonder also, with how large statistical ensemble you are working? Interesting would be divide even by country of birth......exist many possibilities, I know.
I wonder the last option 1975 - 1980, 1980 - 1985, 1985 -1990, 1990 -1995 ...etc
Thanks for interest and time.

Monika

Here we go for more interesting ;)

Here are the slice I choose, I choose those ones because they are about equivalent in number of dogs (300-450). [The whole statistical ensemble is the 2200-2300 bonitated dogs entered in WD.]

Slices: 1970->1990 ; 1990->1995 ; 1995->2000 ; 2000->2003 ; 2003->2006 ; 2006->2010


Female 1970->1990

http://ametiste.ifrance.com/csv_heig...1990-01-01.png

Female 1990->1995

http://ametiste.ifrance.com/csv_heig...1995-01-01.png

Female 1995->2000

http://ametiste.ifrance.com/csv_heig...2000-01-01.png

Female 2000->2003

http://ametiste.ifrance.com/csv_heig...2003-01-01.png

Female 2003->2006

http://ametiste.ifrance.com/csv_heig...2006-01-01.png

Female 2006->2010

http://ametiste.ifrance.com/csv_heig...2010-01-01.png

Female 1970->2010 (sum up)

http://ametiste.ifrance.com/csv_heig...2010-01-01.png


Male 1970->1990

http://ametiste.ifrance.com/csv_heig...1990-01-01.png

Male 1990->1995

http://ametiste.ifrance.com/csv_heig...1995-01-01.png

Male 1995->2000

http://ametiste.ifrance.com/csv_heig...2000-01-01.png

Male 2000->2003

http://ametiste.ifrance.com/csv_heig...2003-01-01.png

Male 2003->2006

http://ametiste.ifrance.com/csv_heig...2006-01-01.png

Male 2006->2010

http://ametiste.ifrance.com/csv_heig...2010-01-01.png

Male 1970->2010 (sum up)

http://ametiste.ifrance.com/csv_heig...2010-01-01.png

Other interesting slices, showing dogs under 15yrs, under 10yrs, under 8years, and under 6years (under 4years can be found in previous post). Who knows how to make a gif animation ?

Female 1995->2010

http://ametiste.ifrance.com/csv_heig...2010-01-01.png

Female 2000->2010

http://ametiste.ifrance.com/csv_heig...2010-01-01.png

Female 2002->2010

http://ametiste.ifrance.com/csv_heig...2010-01-01.png

Female 2004->2010

http://ametiste.ifrance.com/csv_heig...2010-01-01.png



Male 1995->2010

http://ametiste.ifrance.com/csv_heig...2010-01-01.png

Male 2000->2010

http://ametiste.ifrance.com/csv_heig...2010-01-01.png

Male 2002->2010

http://ametiste.ifrance.com/csv_heig...2010-01-01.png

Male 2004->2010

http://ametiste.ifrance.com/csv_heig...2010-01-01.png

Hi Elf, if you would send me the numbers in a table then I can make a 3-D graph.

Hi, 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

Saschia, does Slovakia uses also such groups ?

Yes, but our new groups are currently under construction... :(

Good news indeed, but difficult to do it "by hands" as pedigrees exploration on large number of dogs is task dedicated to computer program, let me know if you need help regarding this.

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