[Latingp] Corrected median in Underlining Analysis

Thu Jun 20 15:49:15 UTC 2019

Part of the problem is that some cells must be text, because otherwise the Unicodes get messed up.  Not just dropping leading zeros, but changing some into exponentials.
Bill Jouris
Inside Products
bill.jouris at insidethestack.com
831-659-8360
925-855-9512 (direct) 

    On Thursday, June 20, 2019, 7:46:31 AM PDT, Mats Dufberg <mats.dufberg at internetstiftelsen.se> wrote:  

 #yiv5715931304 #yiv5715931304 -- _filtered #yiv5715931304 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv5715931304 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv5715931304 {font-family:New Roman;panose-1:2 2 6 3 5 4 5 2 3 4;} _filtered #yiv5715931304 {panose-1:2 0 5 3 0 0 0 2 0 4;}#yiv5715931304 #yiv5715931304 p.yiv5715931304MsoNormal, #yiv5715931304 li.yiv5715931304MsoNormal, #yiv5715931304 div.yiv5715931304MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv5715931304 a:link, #yiv5715931304 span.yiv5715931304MsoHyperlink {color:blue;text-decoration:underline;}#yiv5715931304 a:visited, #yiv5715931304 span.yiv5715931304MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv5715931304 p.yiv5715931304msonormal0, #yiv5715931304 li.yiv5715931304msonormal0, #yiv5715931304 div.yiv5715931304msonormal0 {margin-right:0cm;margin-left:0cm;font-size:11.0pt;font-family:sans-serif;}#yiv5715931304 p.yiv5715931304msonormal, #yiv5715931304 li.yiv5715931304msonormal, #yiv5715931304 div.yiv5715931304msonormal {margin-right:0cm;margin-left:0cm;font-size:11.0pt;font-family:sans-serif;}#yiv5715931304 span.yiv5715931304msohyperlink {}#yiv5715931304 span.yiv5715931304msohyperlinkfollowed {}#yiv5715931304 span.yiv5715931304emailstyle17 {}#yiv5715931304 p.yiv5715931304msonormal1, #yiv5715931304 li.yiv5715931304msonormal1, #yiv5715931304 div.yiv5715931304msonormal1 {margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:sans-serif;}#yiv5715931304 p.yiv5715931304msonormal2, #yiv5715931304 li.yiv5715931304msonormal2, #yiv5715931304 div.yiv5715931304msonormal2 {margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:sans-serif;}#yiv5715931304 span.yiv5715931304msohyperlink1 {color:#0563C1;text-decoration:underline;}#yiv5715931304 span.yiv5715931304msohyperlinkfollowed1 {color:#954F72;text-decoration:underline;}#yiv5715931304 span.yiv5715931304emailstyle171 {color:windowtext;font-weight:normal;font-style:normal;}#yiv5715931304 span.yiv5715931304EmailStyle27 {color:windowtext;font-weight:normal;font-style:normal;}#yiv5715931304 .yiv5715931304MsoChpDefault {font-size:10.0pt;} _filtered #yiv5715931304 {margin:70.85pt 70.85pt 70.85pt 70.85pt;}#yiv5715931304 div.yiv5715931304WordSection1 {}#yiv5715931304 
Or even integer value.I think at least one case change from 2 to 3. It is confusing when some cells in a spread sheet hold numbers that are text and other hold numbers that are -- numbers.

Mats

---

Mats Dufberg

DNS Specialist

Internetstiftelsen (The Swedish Internet Foundation)

Mobile: +46 73 065 3899

https://internetstiftelsen.se/

From: Bill Jouris <bill.jouris at insidethestack.com>
Reply-To: Bill Jouris <bill.jouris at insidethestack.com>
Date: Thursday, 20 June 2019 at 16:42
To: ICANN Latin GP <Latingp at icann.org>, Mats Dufberg <mats.dufberg at internetstiftelsen.se>
Subject: Re: [Latingp] Corrected median in Underlining Analysis

Hi Mats. 

Thanks for working that out.  I had wondered why (how?) the median function was getting a non-integer result.  But couldn't it figure out.  So I tried to just count the 2s and 3s, but obviously the manual method is more subject to error.  (That's why I used the function, after all.)  Sigh 

In the case of N with circumflex below, I'm assuming that was one of the cases with the non-integer result initially. 

Bill Jouris
Inside Products
bill.jouris at insidethestack.com
831-659-8360
925-855-9512 (direct)

On Thursday, June 20, 2019, 4:43:53 AM PDT, Mats Dufberg <mats.dufberg at internetstiftelsen.se> wrote:

I noticed that the median calculation was wrong in some instances. Finally I found out how to fix it. I selected all cells G5:M73 and selected Format->Number and ticked "automatic". Some of the cells were "text" so that is why they were not included in the medians.

Now all of medians are correct, and Bill should re-review them. I think Latin Small Letter N vs. Latin Small Letter N with Circumflex Below should probably go from "Variant" to "Not a Variant". I think there are other cases.

https://docs.google.com/spreadsheets/d/19FZmntXOan_7LF0ckzKZNLrla0L8eC_GxWEfAmmOMkU/edit#gid=1543789122

Mats

---

Mats Dufberg

DNS Specialist

Internetstiftelsen (The Swedish Internet Foundation)

Mobile: +46 73 065 3899

https://internetstiftelsen.se/

_______________________________________________
Latingp mailing list
Latingp at icann.org
https://mm.icann.org/mailman/listinfo/latingp

_______________________________________________
By submitting your personal data, you consent to the processing of your personal data for purposes of subscribing to this mailing list accordance with the ICANN Privacy Policy (https://www.icann.org/privacy/policy) and the website Terms of Service (https://www.icann.org/privacy/tos). You can visit the Mailman link above to change your membership status or configuration, including unsubscribing, setting digest-style delivery or disabling delivery altogether (e.g., for a vacation), and so on.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mm.icann.org/pipermail/latingp/attachments/20190620/442ab38d/attachment.html>