From koffice-devel Mon Jul 19 19:26:15 2004 From: Tomas Mecir Date: Mon, 19 Jul 2004 19:26:15 +0000 To: koffice-devel Subject: Re: [patch] KSpread: RANDNORM function Message-Id: <492258b10407191226539cc796 () mail ! gmail ! com> X-MARC-Message: https://marc.info/?l=koffice-devel&m=109026519117526 MIME-Version: 1 Content-Type: multipart/mixed; boundary="------=_Part_139_9278739.1090265175557" ------=_Part_139_9278739.1090265175557 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Sun, 18 Jul 2004 14:35:49 +0200, Ariya Hidayat wrote: > No need to peek on Python, this is the normal Box-M=FCller transformation > (see http://ariya.pandu.org/blog/2004-01.htm#30). However, you could try > the Polar form as it's faster and more stable. Check > http://www.taygeta.com/random/gaussian.html. Ahh I see, thanks :) Improved version attached. / Tomas ------=_Part_139_9278739.1090265175557 Content-Type: application/octet-stream; name="kspread_randnorm-v2.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="kspread_randnorm-v2.patch" SW5kZXg6IGtzcHJlYWRfZnVuY3Rpb25zX21hdGguY2MKPT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQpSQ1MgZmlsZTogL2hv bWUva2RlL2tvZmZpY2Uva3NwcmVhZC9rc3ByZWFkX2Z1bmN0aW9uc19tYXRoLmNjLHYKcmV0cmll dmluZyByZXZpc2lvbiAxLjM3CmRpZmYgLXUgLTMgLXAgLXIxLjM3IGtzcHJlYWRfZnVuY3Rpb25z X21hdGguY2MKLS0tIGtzcHJlYWRfZnVuY3Rpb25zX21hdGguY2MJMTMgTWF5IDIwMDQgMTY6MzI6 MTMgLTAwMDAJMS4zNworKysga3NwcmVhZF9mdW5jdGlvbnNfbWF0aC5jYwkxOSBKdWwgMjAwNCAx OToyMTowNSAtMDAwMApAQCAtOTIsNiArOTIsNyBAQCBib29sIGtzcHJlYWRmdW5jX3JhbmRiZXJu b3VsbGkoIEtTQ29udGV4CiBib29sIGtzcHJlYWRmdW5jX3JhbmRiaW5vbSggS1NDb250ZXh0ICYg Y29udGV4dCApOwogYm9vbCBrc3ByZWFkZnVuY19yYW5kZXhwKCBLU0NvbnRleHQgJiBjb250ZXh0 ICk7CiBib29sIGtzcHJlYWRmdW5jX3JhbmRuZWdiaW5vbSggS1NDb250ZXh0ICYgY29udGV4dCAp OworYm9vbCBrc3ByZWFkZnVuY19yYW5kbm9ybSggS1NDb250ZXh0ICYgY29udGV4dCApOwogYm9v bCBrc3ByZWFkZnVuY19yYW5kcG9pc3NvbiggS1NDb250ZXh0ICYgY29udGV4dCApOwogYm9vbCBr c3ByZWFkZnVuY19yb290biggS1NDb250ZXh0JiBjb250ZXh0ICk7CiBib29sIGtzcHJlYWRmdW5j X3JvdW5kKCBLU0NvbnRleHQmIGNvbnRleHQgKTsKQEAgLTE2NCw2ICsxNjUsNyBAQCB2b2lkIEtT cHJlYWRSZWdpc3Rlck1hdGhGdW5jdGlvbnMoKQogICByZXBvLT5yZWdpc3RlckZ1bmN0aW9uKCAi UkFOREJJTk9NIiwgICAgIGtzcHJlYWRmdW5jX3JhbmRiaW5vbSApOwogICByZXBvLT5yZWdpc3Rl ckZ1bmN0aW9uKCAiUkFOREVYUCIsICAgICAgIGtzcHJlYWRmdW5jX3JhbmRleHAgKTsKICAgcmVw by0+cmVnaXN0ZXJGdW5jdGlvbiggIlJBTkRORUdCSU5PTSIsICBrc3ByZWFkZnVuY19yYW5kbmVn Ymlub20gKTsKKyAgcmVwby0+cmVnaXN0ZXJGdW5jdGlvbiggIlJBTkROT1JNIiwgICAgICBrc3By ZWFkZnVuY19yYW5kbm9ybSApOwogICByZXBvLT5yZWdpc3RlckZ1bmN0aW9uKCAiUkFORFBPSVNT T04iLCAgIGtzcHJlYWRmdW5jX3JhbmRwb2lzc29uICk7CiAgIHJlcG8tPnJlZ2lzdGVyRnVuY3Rp b24oICJST09UTiIsICAgICAgICAga3NwcmVhZGZ1bmNfcm9vdG4gKTsKICAgcmVwby0+cmVnaXN0 ZXJGdW5jdGlvbiggIlJPVU5EIiwgICAgICAgICBrc3ByZWFkZnVuY19yb3VuZCApOwpAQCAtMTI0 NCw2ICsxMjQ2LDQxIEBAIGJvb2wga3NwcmVhZGZ1bmNfcmFuZGJlcm5vdWxsaSggS1NDb250ZXgK ICAgcmV0dXJuIHRydWU7CiB9CiAKK2Jvb2wga3NwcmVhZGZ1bmNfcmFuZG5vcm0oIEtTQ29udGV4 dCAmIGNvbnRleHQgKQoreworICBRVmFsdWVMaXN0PEtTVmFsdWU6OlB0cj4gJiBhcmdzID0gY29u dGV4dC52YWx1ZSgpLT5saXN0VmFsdWUoKTsKKworICBpZiAoICFLU1V0aWw6OmNoZWNrQXJndW1l bnRzQ291bnQoIGNvbnRleHQsIDIsICJSQU5ETk9STSIsIHRydWUgKSApCisgICAgcmV0dXJuIGZh bHNlOworCisgIGlmKCAhS1NVdGlsOjpjaGVja1R5cGUoIGNvbnRleHQsIGFyZ3NbMF0sIEtTVmFs dWU6OkRvdWJsZVR5cGUsIHRydWUgKSApCisgICAgcmV0dXJuIGZhbHNlOworICBpZiggIUtTVXRp bDo6Y2hlY2tUeXBlKCBjb250ZXh0LCBhcmdzWzFdLCBLU1ZhbHVlOjpEb3VibGVUeXBlLCB0cnVl ICkgKQorICAgIHJldHVybiBmYWxzZTsKKworICBkb3VibGUgbXUgPSBhcmdzWzBdLT5kb3VibGVW YWx1ZSgpOworICBkb3VibGUgc2lnbWEgPSBhcmdzWzFdLT5kb3VibGVWYWx1ZSgpOworCisgIC8v dXNpbmcgcG9sYXIgZm9ybSBvZiB0aGUgQm94LU11bGxlciB0cmFuc2Zvcm1hdGlvbgorICAvL3Jl ZmVyIHRvIGh0dHA6Ly93d3cudGF5Z2V0YS5jb20vcmFuZG9tL2dhdXNzaWFuLmh0bWwgZm9yIG1v cmUgaW5mbworCisgIGRvdWJsZSB4MSwgeDIsIHc7CisgIGRvIHsKKyAgICB4MSA9IChkb3VibGUp IHJhbmQoKSAvIChSQU5EX01BWCArIDEuMCk7CisgICAgeDIgPSAoZG91YmxlKSByYW5kKCkgLyAo UkFORF9NQVggKyAxLjApOworICAgIHgxID0gMi4wICogeDEgLSAxLjA7CisgICAgeDIgPSAyLjAg KiB4MiAtIDEuMDsKKyAgICB3ID0geDEgKiB4MSArIHgyICogeDI7CisgIH0gd2hpbGUgKHcgPj0g MS4wKTsKKworICB3ID0gc3FydCAoKC0yLjAgKiBsb2cgKHcpKSAvIHcpOworICBkb3VibGUgcmVz ID0geDEgKiB3OworCisgIHJlcyA9IHJlcyAqIHNpZ21hICsgbXU7CisgIGNvbnRleHQuc2V0VmFs dWUoIG5ldyBLU1ZhbHVlKCByZXMgKSApOworICByZXR1cm4gdHJ1ZTsKK30KKwogYm9vbCBrc3By ZWFkZnVuY19yYW5kcG9pc3NvbiggS1NDb250ZXh0ICYgY29udGV4dCApCiB7CiAgIFFWYWx1ZUxp c3Q8S1NWYWx1ZTo6UHRyPiAmIGFyZ3MgPSBjb250ZXh0LnZhbHVlKCktPmxpc3RWYWx1ZSgpOwpJ bmRleDogZXh0ZW5zaW9ucy9tYXRoLnhtbAo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09ClJDUyBmaWxlOiAvaG9tZS9rZGUv a29mZmljZS9rc3ByZWFkL2V4dGVuc2lvbnMvbWF0aC54bWwsdgpyZXRyaWV2aW5nIHJldmlzaW9u IDEuMzAKZGlmZiAtdSAtMyAtcCAtcjEuMzAgbWF0aC54bWwKLS0tIGV4dGVuc2lvbnMvbWF0aC54 bWwJNCBBdWcgMjAwMyAwODo1MjoxOSAtMDAwMAkxLjMwCisrKyBleHRlbnNpb25zL21hdGgueG1s CTE5IEp1bCAyMDA0IDE5OjIxOjA2IC0wMDAwCkBAIC04NzYsNiArODc2LDI1IEBACiAgICAgPC9G dW5jdGlvbj4KIAogICAgIDxGdW5jdGlvbj4KKyAgICAgIDxOYW1lPlJBTkROT1JNPC9OYW1lPgor ICAgICAgPFR5cGU+RmxvYXQ8L1R5cGU+CisgICAgICA8UGFyYW1ldGVyPgorCTxDb21tZW50Pk1l YW4gdmFsdWUgb2YgdGhlIG5vcm1hbCBkaXN0cmlidXRpb248L0NvbW1lbnQ+CisJPFR5cGU+Rmxv YXQ8L1R5cGU+CisgICAgICA8L1BhcmFtZXRlcj4KKyAgICAgIDxQYXJhbWV0ZXI+CisJPENvbW1l bnQ+RGlzcGVyc2lvbiBvZiB0aGUgbm9ybWFsIGRpc3RyaWJ1dGlvbjwvQ29tbWVudD4KKwk8VHlw ZT5GbG9hdDwvVHlwZT4KKyAgICAgIDwvUGFyYW1ldGVyPgorICAgICAgPEhlbHA+CisJPFRleHQ+ VGhlIFJBTkROT1JNKCkgZnVuY3Rpb24gcmV0dXJucyBhIE5vcm1hbChHYXVzc2lhbiktZGlzdHJp YnV0ZWQgcHNldWRvLXJhbmRvbSBudW1iZXIuPC9UZXh0PgorCTxTeW50YXg+UkFORE5PUk0obXUs c2lnbWEpPC9TeW50YXg+CisJPEV4YW1wbGU+UkFORE5PUk0oMCwxKTwvRXhhbXBsZT4KKyAgICAg ICAgPFJlbGF0ZWQ+UkFORDwvUmVsYXRlZD4KKyAgICAgIDwvSGVscD4KKyAgICA8L0Z1bmN0aW9u PgorCisgICAgPEZ1bmN0aW9uPgogICAgICAgPE5hbWU+UkFOREJFVFdFRU48L05hbWU+CiAgICAg ICA8VHlwZT5GbG9hdDwvVHlwZT4KICAgICAgIDxQYXJhbWV0ZXI+Cg== ------=_Part_139_9278739.1090265175557 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ koffice-devel mailing list koffice-devel@mail.kde.org https://mail.kde.org/mailman/listinfo/koffice-devel ------=_Part_139_9278739.1090265175557--