Thanks Siranush, that would be appreciated. Dev Anand On Sat, Oct 22, 2016 at 7:52 AM, Siranush Vardanyan < siranush.vardanyan@icann.org> wrote:

Dear Dev,

Thanks for this document. Just FYI, some Fellows for Hyderabad are dropped out due to some challenges, thus I will provide the final list to be updated for this file for Hyderabad.

See you all soon in Hyderabad

Best

Siranush

Siranush Vardanyan

*Fellowship Coordinator*

Development and Public Responsibility Dept., ICANN

Mobile: +374 94 947773

E-mail: siranush.vardanyan@icann.org

Skype ID: siranush.vardanyan

*One World. One Internet.*

*From: *<alac-sc-outreach-bounces@atlarge-lists.icann.org> on behalf of Olivier MJ Crepin-Leblond <ocl@gih.com> *Date: *Saturday, October 22, 2016 at 11:17 AM *To: *"alac-sc-outreach@atlarge-lists.icann.org" < alac-sc-outreach@atlarge-lists.icann.org> *Subject: *Re: [Alac-sc-outreach] Version 4 of the Stakeholder Analysis Tool - now shows At-Large, ccNSO, GAC and Fellowship tool

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[docs.google.com] <https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.google.com_spreads...>

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[community.icann.org] <https://urldefense.proofpoint.com/v2/url?u=https-3A__community.icann.org_dis...>

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

Thank you Tijani for acknowledging Dev's work. This tool, now in its 4th version, has been a labour of love for Dev for several years, building on what he was already providing for LACRALO, but expanding it to include information for the other RALOs as well. It came to light in London when Ron Sherwood and I were talking about collating a match between country code TLDs and their ALSes. Dev had already done this for LACRALO. At-Large has been very fortunate to have someone as talented and skilled as Dev working on our behalf to find ways to make ICANN information more accessible. I bet there are people in ICANN who don't know that this information is already within their systems. Great work Dev. On Sat, Oct 22, 2016 at 8:44 PM, 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 athttps://community.icann.org/display/atlarge/ICANN+Stakeholder+Analysis+Tool

Kind Regards,

Dev Anand

_______________________________________________ Alac-sc-outreach mailing listAlac-sc-outreach@atlarge-lists.icann.orghttps://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

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

Well, it can be delegated to other persons willing to do it ;-) Dev Anand On Sun, Oct 23, 2016 at 4:04 PM, Tijani BEN JEMAA <tijani.benjemaa@topnet.tn> wrote:

Thank you Dev for this explanation.

So you make the manual update for the non automatic change as soon as you are aware of the change. 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.

----------------------------------------------------------------------------- Tijani BEN JEMAA Executive Director Mediterranean Federation of Internet Associations (FMAI) Phone: +216 98 330 114 +216 52 385 114 -----------------------------------------------------------------------------

Le 23 oct. 2016 à 19:35, Dev Anand Teelucksingh <devtee@gmail.com> a écrit :

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

Dear Dev, you are absolutely correct on the difficulty to update. The tool you have developed is a lovely tool. Very good indeed. It would be great if the regional dashboard could build themselves up from the same dataset. It's all a case of cross-referenced tables with Excel rules, isn't it? Kindest regards, Olivier On 23/10/2016 21:13, Dev Anand Teelucksingh wrote:

Hi, Olivier, I was peripherally aware that Oksana was attempting to work on this, but hadn't realized on the progress made. Thanks for sharing. My thinking was that the Analysis Tool can be the master sheet, where information is captured once, then could be syndicated to regional dashboards. This would avoid having to update multiple static databases and avoid data inconsistencies.

Its also why after a very long time of copying and pasting GAC contact details so that these details could be displayed on the sheet directly, I realized the impracticality on keeping the GAC contact details up to date. I anticipate a similar problem with the EURALO one, especially when done manually.

Dev Anand

On Sat, Oct 22, 2016 at 3:17 AM, Olivier MJ Crepin-Leblond <ocl@gih.com> wrote:

...

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

-- Olivier MJ Crépin-Leblond, PhD http://www.gih.com/ocl.html

Indeed, separate regional dashboards could be done to reference the SAT (Stakeholder Analysis Tool) so any changes to the SAT would update the regional dashboards. Dev Anand On Sun, Oct 23, 2016 at 5:20 PM, Olivier MJ Crepin-Leblond <ocl@gih.com> wrote:

Dear Dev,

you are absolutely correct on the difficulty to update. The tool you have developed is a lovely tool. Very good indeed. It would be great if the regional dashboard could build themselves up from the same dataset. It's all a case of cross-referenced tables with Excel rules, isn't it? Kindest regards,

Olivier

On 23/10/2016 21:13, Dev Anand Teelucksingh wrote:

...

Hi, Olivier, I was peripherally aware that Oksana was attempting to work on this, but hadn't realized on the progress made. Thanks for sharing. My thinking was that the Analysis Tool can be the master sheet, where information is captured once, then could be syndicated to regional dashboards. This would avoid having to update multiple static databases and avoid data inconsistencies.

Its also why after a very long time of copying and pasting GAC contact details so that these details could be displayed on the sheet directly, I realized the impracticality on keeping the GAC contact details up to date. I anticipate a similar problem with the EURALO one, especially when done manually.

Dev Anand

On Sat, Oct 22, 2016 at 3:17 AM, Olivier MJ Crepin-Leblond <ocl@gih.com> wrote:

...

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

-- Olivier MJ Crépin-Leblond, PhD http://www.gih.com/ocl.html