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-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@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