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