Thanks Tijani. Its a combination of both (automatically and manual). The two sheets for GAC and ccNSO sheets reads the data automatically from the GAC and ccNSO websites when the spreadsheet is opened. If you scroll to the right of the GAC and ccNSO sheets, you'll see a counter of the number of rows of the live data and a history of what the numbers were in the past. Whenever, there's a change in the current number, I'll know when there's been an addition (or an unlikely deletion). Then I can add the change to the "ICANN-ISO' sheet. I do it this way, because of the inconsistency of how the ACs and SOs in ICANN and other ICANN groups such as Fellowships use different names for the same countries or territories, so I have to map or normalise the differences in country names and territories so that comparisons can happen on one country name. A similar sheet was done for At-Large - the At-LargeCheck sheet reads the ALS names everytime the spreadsheet is opened - by checking the current number of ALSes with the previous number I can see when a change occurs. Dev Anand On Sun, Oct 23, 2016 at 2:44 AM, Tijani BEN JEMAA <tijani.benjemaa@topnet.tn> wrote:
Wonderful tool. Thank you very much Dev.
My question: how data are updated? Automatically or manually? If manually, how often are they updated.
For your information, I didn’t read everything, so maybe my question is answered and I didn’t read it. if it is the case, I do apologize.
----------------------------------------------------------------------------- Tijani BEN JEMAA Executive Director Mediterranean Federation of Internet Associations (FMAI) Phone: +216 98 330 114 +216 52 385 114 -----------------------------------------------------------------------------
Le 22 oct. 2016 à 08:17, Olivier MJ Crepin-Leblond <ocl@gih.com> a écrit :
Thanks Dev.
On a similar line, are you aware of the EURALO dashboard prepared by Oksana Prykhodko? It centers on countries, ALSes, GAC reps, ccTLDs etc.
https://docs.google.com/spreadsheets/d/1-aBfqqQ_Cq0u-i2eFo-H015oC-7Q5qqneDXc...
Kindest regards,
Olivier
On 22/10/2016 03:26, Dev Anand Teelucksingh wrote:
Dear All,
Completed a fourth version of the Stakeholder Analysis Tool which allows for the ability to search by country: - At-Large Representation - ccNSO membership - GAC Membership - The Number of Fellowships
See attached screenshot
You can select the country from the dropdown cell in grey and the sheet updates automatically.
The link to the tool and a new screencast is at https://community.icann.org/display/atlarge/ICANN+Stakeholder+Analysis+Tool
Kind Regards,
Dev Anand
_______________________________________________ Alac-sc-outreach mailing list Alac-sc-outreach@atlarge-lists.icann.org https://mm.icann.org/mailman/listinfo/alac-sc-outreach
_______________________________________________ Alac-sc-outreach mailing list Alac-sc-outreach@atlarge-lists.icann.org https://mm.icann.org/mailman/listinfo/alac-sc-outreach
_______________________________________________ Alac-sc-outreach mailing list Alac-sc-outreach@atlarge-lists.icann.org https://mm.icann.org/mailman/listinfo/alac-sc-outreach