<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif"><font color="#0000ff">Cameron:</font></div><div class="gmail_default" style="font-family:tahoma,sans-serif"><font color="#0000ff">Glad to hear that this seems to be heading in the right direction. Below and in-line are my comments and suggestions for next steps:</font></div><div class="gmail_default" style="font-family:tahoma,sans-serif"><ul><li>There are a few glitches with the data still: As you suggested, I agree that the old tabs (after "2006 Lausanne") should be removed. However, your current graphs point to data from these tabs to be removed.<br></li><ul><li><font color="#0000ff">YES, good point and I knew (but didn't recall) there was a reason I hadn't already move them. Ultimately, I think the cleanliness of the data (and removal of the PII in the older tabs) warrants "losing" those charts. And indeed, it would be relatively easy to recreate them based on the new tab.</font></li></ul><li>Re: Ownership:<span style="font-family:sans-serif"> </span>I think it should be owned by the OSGeo conference committee. Members of the conference committee who wish to update the spreadsheet should be provided with write access. The general public should be provided with read access.</li><ul><li><font color="#0000ff">That is fine by me. I'm not sure if the Conference Committee has it's own GMail account, or who would control it. Right now, I own the document on my personal email account, and I am on the Conference Committee and am in a position to grant whatever access is determined to be best (including transferring ownership).</font></li></ul><li>Re: Regional events: As yet, I'm not aware of anyone collecting FOSS4G regional metrics, but I think they would be valuable to collect. The question is: Should we have a spreadsheet for each FOSS4G region, or should we have one spreadsheet which contains all regions and all years, or should we include into our current spreadsheet which only includes international events? I'd err on having one spreadsheet for each region.</li><ul><li><font color="#0000ff">I would concur, that we shouldn't try and move regional events into this same spreadsheets. There is a tipping point for spreadsheets where they get bloated and unruly. Perhaps this kind of "one-tab-for-each-event, plus a summary tab" could be suggested for regional events that wish to track attendance?</font></li></ul></ul><div><font color="#0000ff">Please let me know what comes next. If you'd like view only access to the sheet for the short term, feel free to ping me, or just make a "request for access" through the Google mechanism and I will abide...</font></div><div><font color="#0000ff"><br></font></div><div><font color="#0000ff">MT</font></div><div><font color="#0000ff"><br></font></div><div><font color="#0000ff">PS: If you're curious, I've attached PDF that shows the "summary tab" of this new spreadsheet. This summary is powered by a separate tab that has the raw data for each preceding conference.</font></div></div><div class="gmail_default" style="font-family:tahoma,sans-serif"><font color="#0000ff"><br></font></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Jun 27, 2018 at 1:20 AM Cameron Shorter <<a href="mailto:cameron.shorter@gmail.com" target="_blank">cameron.shorter@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<p>Michael,</p>
<p>I've just reviewed your updated FOSSG4G metrics spreadsheet.
<a class="m_-7703186842938560786m_-5282312690019902930moz-txt-link-freetext" href="https://docs.google.com/spreadsheets/d/1ux_hFq-C165140ZD48RRImPTHSpXj42OG3nBr9cyZYo/edit#gid=1782600951" target="_blank">https://docs.google.com/spreadsheets/d/1ux_hFq-C165140ZD48RRImPTHSpXj42OG3nBr9cyZYo/edit#gid=1782600951</a><br>
</p>
<p>I like where you are heading with this, with an all years summary
tab, followed by a tab for each conference.</p>
<p>There are a few glitches with the data still: As you suggested, I
agree that the old tabs (after "2006 Lausanne") should be
removed. However, your current graphs point to data from these
tabs to be removed.</p>
<p>Re: Ownership: <br>
</p>
<p>I think it should be owned by the OSGeo conference committee.
Members of the conference committee who wish to update the
spreadsheet should be provided with write access. The general
public should be provided with read access.</p>
<p>Re: Regional events:</p>
<p>As yet, I'm not aware of anyone collecting FOSS4G regional
metrics, but I think they would be valuable to collect.</p>
<p>The question is:</p>
<p>* Should we have a spreadsheet for each FOSS4G region, or should
we have one spreadsheet which contains all regions and all years,
or should we include into our current spreadsheet which only
includes international events?</p>
<p>* I'd err on having one spreadsheet for each region.<br>
</p>
<p><br>
</p>
<br>
<div class="m_-7703186842938560786m_-5282312690019902930moz-cite-prefix">On 21/6/18 7:57 am, María Arias de
Reyna wrote:<br>
</div>
<blockquote type="cite">
<div dir="auto">Thanks!!! </div>
<br>
<div class="gmail_quote">
<div dir="ltr">El mié., 20 jun. 2018 23:57, Cameron Shorter <<a href="mailto:cameron.shorter@gmail.com" target="_blank">cameron.shorter@gmail.com</a>>
escribió:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<p>OSGeo conference committee,</p>
<p>I'm bringing two conversations into this public
conference email list. <br>
</p>
<p>Some ideas here about updating metrics for the latest
FOSS4G events.<br>
</p>
<div class="m_-7703186842938560786m_-5282312690019902930m_-3665627893485232507moz-cite-prefix">On
21/6/18 2:47 am, michael terner wrote:<br>
</div>
<blockquote type="cite">As per your second question on
Boston metric, you and I exchanged emails late last year
(December, I believe) about a <a href="https://docs.google.com/spreadsheets/d/1ux_hFq-C165140ZD48RRImPTHSpXj42OG3nBr9cyZYo/edit?usp=sharing" rel="noreferrer" target="_blank">new
version of the sheet</a> [1] that I created after noting
that the older version you sent me had accumulated
significant clutter and detritus over the years (while
remaining very useful). Boston data is here, and there are
placeholders for the missing Bonn data as well as for Dar
es Salaam and Bucharest. I think this sheet is ready to be
put in play, but would trust your judgment and welcome
your input. Perhaps we can take this conversation to a
separate thread and make some plans (e.g., Where does it
live? Who should have edit access? How to announce its
existence? Etc.).</blockquote>
<br>
[1]
<a class="m_-7703186842938560786m_-5282312690019902930m_-3665627893485232507moz-txt-link-freetext" href="https://docs.google.com/spreadsheets/d/1ux_hFq-C165140ZD48RRImPTHSpXj42OG3nBr9cyZYo/edit#gid=1782600951" rel="noreferrer" target="_blank">https://docs.google.com/spreadsheets/d/1ux_hFq-C165140ZD48RRImPTHSpXj42OG3nBr9cyZYo/edit#gid=1782600951</a><br>
<br>
<div class="m_-7703186842938560786m_-5282312690019902930m_-3665627893485232507moz-cite-prefix">On
21/6/18 12:51 am, Till Adams wrote:<br>
</div>
<blockquote type="cite">
<pre>Hi Cameron,
ups, just forgot about these. I will try to deliver these ASAP!
Thanks for reminding,
Till
Am 20.06.2018 um 01:05 schrieb Cameron Shorter:
</pre>
<blockquote type="cite">
<pre>Hi Till,
I just noticed that we don't seem to have metrics for FOSS4G Bonn in
our aggregate spreadsheet:
<a class="m_-7703186842938560786m_-5282312690019902930m_-3665627893485232507moz-txt-link-freetext" href="https://docs.google.com/spreadsheets/d/1BpkO5WOFQ_DZEWNMLj_hAhEre0m0io_j-JGf7geAW5Y/edit#gid=57" rel="noreferrer" target="_blank">https://docs.google.com/spreadsheets/d/1BpkO5WOFQ_DZEWNMLj_hAhEre0m0io_j-JGf7geAW5Y/edit#gid=57</a>
Do you have such metrics available, and able to be depersonalised and
put into this spreadsheet?
</pre>
</blockquote>
</blockquote>
<br>
<pre class="m_-7703186842938560786m_-5282312690019902930m_-3665627893485232507moz-signature" cols="72">--
Cameron Shorter
Technology Demystifier
Open Technologies and Geospatial Consultant
M +61 (0) 419 142 254</pre>
</div>
_______________________________________________<br>
Conference_dev mailing list<br>
<a href="mailto:Conference_dev@lists.osgeo.org" rel="noreferrer" target="_blank">Conference_dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/conference_dev" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/conference_dev</a></blockquote>
</div>
</blockquote>
<br>
<pre class="m_-7703186842938560786m_-5282312690019902930moz-signature" cols="72">--
Cameron Shorter
Technology Demystifier
Open Technologies and Geospatial Consultant
M +61 (0) 419 142 254</pre>
</div>
_______________________________________________<br>
Conference_dev mailing list<br>
<a href="mailto:Conference_dev@lists.osgeo.org" target="_blank">Conference_dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/conference_dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/conference_dev</a></blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="m_-7703186842938560786gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><font face="tahoma, sans-serif">Michael Terner</font></div><div><a href="mailto:ternergeo@gmail.com" target="_blank"><font face="tahoma, sans-serif">ternergeo@gmail.com</font></a></div><div><font face="tahoma, sans-serif">(M) 978-631-6602</font></div></div></div></div></div></div></div></div>