<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Michael,</p>
<p>As soon as you have the time, I'd encourage you to go ahead with
your suggestion of removing the old redundant tabs and recreating
the new graphs based on the new table cells.</p>
<p>I've used the google sheets version history feature to label the
current version, so we can find the old tabs if we need to.</p>
<p>I'd ideally like to keep the URL of the old spreadsheet so we
don't need to locate and update references on the web to the old
spreadsheet. But I tried to move your sheets over to the old new
URL and couldn't work out an easy way to do that. So lets just go
with the new URL. I think there are only 2 places on the web which
reference the old URL.</p>
<p>Thanks for all your effort so far, Cameron<br>
</p>
<p><br>
</p>
<br>
<div class="moz-cite-prefix">On 29/6/18 1:17 am, michael terner
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAFk2e0KxF2_hq95zqgoAr=mYnCDW1buBpQzTjYFAe9bvGSR_sg@mail.gmail.com">
<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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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"
moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true">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"
moz-do-not-send="true">Conference_dev@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/conference_dev"
rel="noreferrer noreferrer" target="_blank"
moz-do-not-send="true">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" moz-do-not-send="true">Conference_dev@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/conference_dev"
rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true"><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>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Cameron Shorter
Technology Demystifier
Open Technologies and Geospatial Consultant
M +61 (0) 419 142 254</pre>
</body>
</html>