[Alac-sc-outreach] Version 4 of the Stakeholder Analysis Tool - now shows At-Large, ccNSO, GAC and Fellowship tool

[Dev Anand Teelucksingh]

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 at 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 at 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-7Q5qqneDXch6CC-WQ/edit?usp=sharing
>
> 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 at atlarge-lists.icann.org
> https://mm.icann.org/mailman/listinfo/alac-sc-outreach
>
>
> _______________________________________________
> Alac-sc-outreach mailing list
> Alac-sc-outreach at atlarge-lists.icann.org
> https://mm.icann.org/mailman/listinfo/alac-sc-outreach
>
>
>
> _______________________________________________
> Alac-sc-outreach mailing list
> Alac-sc-outreach at atlarge-lists.icann.org
> https://mm.icann.org/mailman/listinfo/alac-sc-outreach
>