<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><font color="#002e7a" class="">Thank you Dev for this explanation.</font><div class=""><font color="#002e7a" class=""><br class=""></font></div><div class=""><font color="#002e7a" class="">So you make the manual update for the non automatic change as soon as you are aware of the change.</font></div><div class=""><font color="#002e7a" class="">I have to thank you not only for the effort of developing the tool, but also for your availability to make the necessary update as soon as the change happens.</font></div><div class=""><br class=""><div apple-content-edited="true" class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="orphans: auto; text-align: start; text-indent: 0px; widows: auto; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="orphans: auto; text-align: start; text-indent: 0px; widows: auto; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="orphans: auto; text-align: start; text-indent: 0px; widows: auto; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div apple-content-edited="true" style="color: rgb(0, 0, 0); letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(54, 95, 145);" class="">-----------------------------------------------------------------------------</span></div><div apple-content-edited="true" style="color: rgb(0, 0, 0); letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><b class=""><span style="color: rgb(54, 95, 145);" class="">Tijani BEN JEMAA</span></b></div><div apple-content-edited="true" style="color: rgb(0, 0, 0); letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(54, 95, 145);" class="">Executive Director</span></div><div apple-content-edited="true" style="color: rgb(0, 0, 0); letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(54, 95, 145);" class="">Mediterranean Federation of Internet Associations (</span><b style="color: rgb(54, 95, 145);" class="">FMAI</b><span style="color: rgb(54, 95, 145);" class="">)</span></div><div apple-content-edited="true" style="color: rgb(0, 0, 0); letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(54, 95, 145);" class="">Phone: +216 98 330 114</span></div><div apple-content-edited="true" style="color: rgb(0, 0, 0); letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="color: rgb(54, 95, 145);" class=""> </span> <span style="color: rgb(54, 95, 145);" class="">+216 52 385 114</span></div><div apple-content-edited="true" class=""><span style="color: rgb(54, 95, 145);" class="">-----------------------------------------------------------------------------</span></div><br class=""><br class=""></div></div></div></div></div>
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">Le 23 oct. 2016 à 19:35, Dev Anand Teelucksingh <<a href="mailto:devtee@gmail.com" class="">devtee@gmail.com</a>> a écrit :</div><br class="Apple-interchange-newline"><div class="">Thanks Tijani. Its a combination of both (automatically and manual).<br class=""><br class="">The two sheets for GAC and ccNSO sheets reads the data automatically<br class="">from the GAC and ccNSO websites when the spreadsheet is opened.<br class="">If you scroll to the right of the GAC and ccNSO sheets, you'll see a<br class="">counter of the number of rows of the live data and a history of what<br class="">the numbers were in the past.<br class="">Whenever, there's a change in the current number, I'll know when<br class="">there's been an addition (or an unlikely deletion).<br class=""><br class="">Then I can add the change to the "ICANN-ISO' sheet. I do it this way,<br class="">because of the inconsistency of how the ACs and SOs in ICANN and other<br class="">ICANN groups such as Fellowships use different names for the same<br class="">countries or territories, so I have to map or normalise the<br class="">differences in country names and territories so that comparisons can<br class="">happen on one country name.<br class=""><br class="">A similar sheet was done for At-Large - the At-LargeCheck sheet reads<br class="">the ALS names everytime the spreadsheet is opened - by checking the<br class="">current number of ALSes with the previous number I can see when a<br class="">change occurs.<br class=""><br class="">Dev Anand<br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class="">On Sun, Oct 23, 2016 at 2:44 AM, Tijani BEN JEMAA<br class=""><<a href="mailto:tijani.benjemaa@topnet.tn" class="">tijani.benjemaa@topnet.tn</a>> wrote:<br class=""><blockquote type="cite" class="">Wonderful tool. Thank you very much Dev.<br class=""><br class="">My question: how data are updated? Automatically or manually?<br class="">If manually, how often are they updated.<br class=""><br class="">For your information, I didn’t read everything, so maybe my question is<br class="">answered and I didn’t read it. if it is the case, I do apologize.<br class=""><br class="">-----------------------------------------------------------------------------<br class="">Tijani BEN JEMAA<br class="">Executive Director<br class="">Mediterranean Federation of Internet Associations (FMAI)<br class="">Phone: +216 98 330 114<br class=""> +216 52 385 114<br class="">-----------------------------------------------------------------------------<br class=""><br class=""><br class="">Le 22 oct. 2016 à 08:17, Olivier MJ Crepin-Leblond <<a href="mailto:ocl@gih.com" class="">ocl@gih.com</a>> a écrit :<br class=""><br class="">Thanks Dev.<br class=""><br class="">On a similar line, are you aware of the EURALO dashboard prepared by Oksana<br class="">Prykhodko? It centers on countries, ALSes, GAC reps, ccTLDs etc.<br class=""><br class=""><a href="https://docs.google.com/spreadsheets/d/1-aBfqqQ_Cq0u-i2eFo-H015oC-7Q5qqneDXch6CC-WQ/edit?usp=sharing" class="">https://docs.google.com/spreadsheets/d/1-aBfqqQ_Cq0u-i2eFo-H015oC-7Q5qqneDXch6CC-WQ/edit?usp=sharing</a><br class=""><br class="">Kindest regards,<br class=""><br class="">Olivier<br class=""><br class="">On 22/10/2016 03:26, Dev Anand Teelucksingh wrote:<br class=""><br class="">Dear All,<br class=""><br class="">Completed a fourth version of the Stakeholder Analysis Tool which<br class="">allows for the ability to search by country:<br class="">- At-Large Representation<br class="">- ccNSO membership<br class="">- GAC Membership<br class="">- The Number of Fellowships<br class=""><br class="">See attached screenshot<br class=""><br class="">You can select the country from the dropdown cell in grey and the<br class="">sheet updates automatically.<br class=""><br class="">The link to the tool and a new screencast is at<br class="">https://community.icann.org/display/atlarge/ICANN+Stakeholder+Analysis+Tool<br class=""><br class="">Kind Regards,<br class=""><br class="">Dev Anand<br class=""><br class=""><br class=""><br class="">_______________________________________________<br class="">Alac-sc-outreach mailing list<br class="">Alac-sc-outreach@atlarge-lists.icann.org<br class="">https://mm.icann.org/mailman/listinfo/alac-sc-outreach<br class=""><br class=""><br class="">_______________________________________________<br class="">Alac-sc-outreach mailing list<br class="">Alac-sc-outreach@atlarge-lists.icann.org<br class="">https://mm.icann.org/mailman/listinfo/alac-sc-outreach<br class=""><br class=""><br class=""><br class="">_______________________________________________<br class="">Alac-sc-outreach mailing list<br class="">Alac-sc-outreach@atlarge-lists.icann.org<br class="">https://mm.icann.org/mailman/listinfo/alac-sc-outreach<br class=""><br class=""></blockquote></div></blockquote></div><br class=""></div></body></html>