<html><head></head><body><div class="ydp78f85e35yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div>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.</div><div><br></div><div class="ydp78f85e35signature">Bill Jouris<br>Inside Products<br>bill.jouris@insidethestack.com<br>831-659-8360<br>925-855-9512 (direct)</div></div>
<div><br></div><div><br></div>
</div><div id="yahoo_quoted_1494462696" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Thursday, June 20, 2019, 7:46:31 AM PDT, Mats Dufberg <mats.dufberg@internetstiftelsen.se> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv5715931304"><style>#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 </style><div>
<div class="yiv5715931304WordSection1">
<p class="yiv5715931304MsoNormal"><span style="">Or even integer value.
</span><span lang="EN-US" style="">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.</span></p>
<p class="yiv5715931304MsoNormal"><span lang="EN-US" style=""> </span></p>
<p class="yiv5715931304MsoNormal"><span lang="EN-US" style=""> </span></p>
<p class="yiv5715931304MsoNormal"><span lang="EN-US" style="">Mats</span></p>
<p class="yiv5715931304MsoNormal"><span lang="EN-US" style=""> </span></p>
<p class="yiv5715931304MsoNormal"><span lang="EN-US" style=""> </span></p>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:10.0pt;">---</span><span style="font-size:12.0pt;color:black;"></span></p>
<p class="yiv5715931304MsoNormal"><span style="font-size:10.0pt;">Mats Dufberg</span><span style="font-size:12.0pt;color:black;"></span></p>
<p class="yiv5715931304MsoNormal"><span style="font-size:10.0pt;">DNS Specialist</span></p>
<p class="yiv5715931304MsoNormal"><span style="font-size:10.0pt;">Internetstiftelsen (The Swedish Internet Foundation)</span></p>
<p class="yiv5715931304MsoNormal"><span style="font-size:10.0pt;">Mobile: +46 73 065 3899</span><span style="font-size:12.0pt;color:black;"></span></p>
<p class="yiv5715931304MsoNormal"><span style="font-size:10.0pt;"><a rel="nofollow" shape="rect" target="_blank" href="https://internetstiftelsen.se/"><span style="color:#954F72;">https://internetstiftelsen.se/</span></a></span><span style="font-size:12.0pt;color:black;"></span></p>
</div>
<p class="yiv5715931304MsoNormal"><span style=""> </span></p>
<p class="yiv5715931304MsoNormal"><span style=""> </span></p>
<div class="yiv5715931304yqt8354086252" id="yiv5715931304yqt21655"><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm;">
<p class="yiv5715931304MsoNormal"><b><span style="font-size:12.0pt;color:black;">From: </span></b><span style="font-size:12.0pt;color:black;">Bill Jouris <bill.jouris@insidethestack.com><br clear="none">
<b>Reply-To: </b>Bill Jouris <bill.jouris@insidethestack.com><br clear="none">
<b>Date: </b>Thursday, 20 June 2019 at 16:42<br clear="none">
<b>To: </b>ICANN Latin GP <Latingp@icann.org>, Mats Dufberg <mats.dufberg@internetstiftelsen.se><br clear="none">
<b>Subject: </b>Re: [Latingp] Corrected median in Underlining Analysis</span></p>
</div>
<div>
<p class="yiv5715931304MsoNormal"> </p>
</div>
<div>
<div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:12.0pt;">Hi Mats. </span></p>
</div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:12.0pt;"> </span></p>
</div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:12.0pt;">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<span style="color:black;"> 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 </span></span></p>
</div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:12.0pt;"> </span></p>
</div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:12.0pt;">In the case of N with circumflex below, I'm assuming that was one of the cases with the non-integer result initially. </span></p>
</div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:12.0pt;"> </span></p>
</div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:12.0pt;">Bill Jouris<br clear="none">
Inside Products<br clear="none">
bill.jouris@insidethestack.com<br clear="none">
831-659-8360<br clear="none">
925-855-9512 (direct)</span></p>
</div>
</div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:12.0pt;"> </span></p>
</div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:12.0pt;"> </span></p>
</div>
</div>
<div id="yiv5715931304yahoo_quoted_1542544345">
<div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:10.0pt;">On Thursday, June 20, 2019, 4:43:53 AM PDT, Mats Dufberg <mats.dufberg@internetstiftelsen.se> wrote:
</span></p>
</div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:10.0pt;"> </span></p>
</div>
<div>
<p class="yiv5715931304MsoNormal"><span style="font-size:10.0pt;"> </span></p>
</div>
<div>
<div id="yiv5715931304">
<div>
<div>
<p class="yiv5715931304msonormal"><span lang="EN-US" style="">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.</span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style=""> </span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style="">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.</span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style=""> </span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style=""> </span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style=""><a rel="nofollow" shape="rect" target="_blank" href="https://docs.google.com/spreadsheets/d/19FZmntXOan_7LF0ckzKZNLrla0L8eC_GxWEfAmmOMkU/edit#gid=1543789122">https://docs.google.com/spreadsheets/d/19FZmntXOan_7LF0ckzKZNLrla0L8eC_GxWEfAmmOMkU/edit#gid=1543789122</a></span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style=""> </span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style=""> </span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style=""> </span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style="">Mats</span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style=""> </span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style="font-size:10.0pt;">---</span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style="font-size:10.0pt;">Mats Dufberg</span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style="font-size:10.0pt;">DNS Specialist</span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style="font-size:10.0pt;">Internetstiftelsen (The Swedish Internet Foundation)</span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style="font-size:10.0pt;">Mobile: +46 73 065 3899</span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span style="font-size:10.0pt;"><a rel="nofollow" shape="rect" target="_blank" href="https://internetstiftelsen.se/"><span lang="EN-US" style="color:#954F72;">https://internetstiftelsen.se/</span></a></span><span style="font-size:10.0pt;"></span></p>
<p class="yiv5715931304msonormal"><span lang="EN-US" style="font-size:10.0pt;"> </span><span style="font-size:10.0pt;"></span></p>
</div>
</div>
</div>
<p class="yiv5715931304MsoNormal"><span style="font-size:10.0pt;">_______________________________________________<br clear="none">
Latingp mailing list<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:Latingp@icann.org" target="_blank" href="mailto:Latingp@icann.org">Latingp@icann.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="https://mm.icann.org/mailman/listinfo/latingp">https://mm.icann.org/mailman/listinfo/latingp</a><br clear="none">
<br clear="none">
_______________________________________________<br clear="none">
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 (<a rel="nofollow" shape="rect" target="_blank" href="https://www.icann.org/privacy/policy">https://www.icann.org/privacy/policy</a>)
and the website Terms of Service (<a rel="nofollow" shape="rect" target="_blank" href="https://www.icann.org/privacy/tos">https://www.icann.org/privacy/tos</a>). 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.</span></p>
</div>
</div>
</div></div>
</div>
</div></div></div>
</div>
</div></body></html>