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