<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style></style></head><body lang=EN-US link=blue vlink="#954F72"><div class=WordSection1><p class=MsoNormal>Hi guys,</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>LARPs has basically the same workflow Shane just described—we use a spreadsheet and then a mailmerge that moves the information into a template in Word. Everything was made for us by Ryan, so altering it is painstaking and slow. We add the information for the fields not currently provided by the site that I hope the site may someday proc for all LARP submissions (genre, combat, costume, time period). </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Best,</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Tara</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='border:none;padding:0in'><b>From: </b><a href="mailto:deptheads@strategicon.net">Strategicon Department Heads</a><br><b>Sent: </b>Wednesday, August 28, 2019 3:39 PM<br><b>To: </b><a href="mailto:deptheads@strategicon.net">Strategicon Department Heads</a><br><b>Subject: </b>Re: [Deptheads] Sign-in Sheets Event Data</p></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica",sans-serif'>Hi everyone! :)<br><br>I cut and past the data from the Sign In Sheet Event Page into an Excel Spreadsheet. I then edit the database slightly, and copy and past it into several different sheets and edit again. Then I use Microsoft Word to create mail merge documents using the different sheets withing the file to populate the information into my paperwork. If you would like examples, I can send them.<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica",sans-serif'>Shane Sauby<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica",sans-serif'>Boardgames Supervisor<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p></div><div id="yahoo_quoted_7971132589"><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>On Wednesday, August 28, 2019, 12:08:20 PM PDT, Strategicon Department Heads <deptheads@strategicon.net> wrote: <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><div><div id=yiv7960085823><div id=yiv7960085823yqt95304><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>Video Gaming - I have some pre-made blanks that I got from somewhere else (more than a decade ago, don't remember the details), and then imported into Google Docs and cleaned up a little bit. <o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>On Wed, Aug 28, 2019 at 10:59 AM Strategicon Department Heads <<a href="mailto:deptheads@strategicon.net" target="_blank">deptheads@strategicon.net</a>> wrote:<o:p></o:p></span></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>Message From: Tanya Aldrich <a href="mailto:taldrich@strategicon.net" target="_blank">taldrich@strategicon.net</a><o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>At least you have 5 months to make the changes.<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>Different priorities when the page was created. The field names are changing across the whole site, and I’m trying to be consistent.<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>I didn’t realize how significant the order or labeling was, and you were the first to comment about it.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>You may have to adapt some more when we add your requested fields, because the pre-reg list is always going to be last. At that point, the checkbox will become the ability to turn on or off those extra fields.<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>By the way, what does each department use (as in software to do the merge) to generate their sheets? If all goes as planned, I’ll need to generate my own sheets starting Orccon.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>Tanya<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>On Aug 28, 2019, at 8:58 AM, Strategicon Department Heads <<a href="mailto:deptheads@strategicon.net" target="_blank">deptheads@strategicon.net</a>> wrote:<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>Message From: Tara Leederman <a href="mailto:taleederman@gmail.com" target="_blank">taleederman@gmail.com</a><o:p></o:p></span></p><div><div><p class=MsoNormal><span style='color:#26282A'>Alright, I guess I’ll also spend a bit changing my templates around. Was there some reason the columns got mixed up in the first place? And why can’t we keep the checkbox?</span><span style='color:#26282A'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:#26282A'>Tara<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><div><p class=MsoNormal><b><span style='color:#26282A'>From:<span class=yiv7960085823gmail-m-8256194103810754553apple-converted-space> </span></span></b><span style='color:#26282A'><a href="mailto:deptheads@strategicon.net" target="_blank">Strategicon Department Heads</a><br><b>Sent:<span class=yiv7960085823gmail-m-8256194103810754553apple-converted-space> </span></b>Wednesday, August 28, 2019 8:40 AM<br><b>To:<span class=yiv7960085823gmail-m-8256194103810754553apple-converted-space> </span></b><a href="mailto:deptheads@strategicon.net" target="_blank">deptheads@strategicon.net</a><br><b>Subject:<span class=yiv7960085823gmail-m-8256194103810754553apple-converted-space> </span></b>Re: [Deptheads] Sign-in Sheets Event Data<o:p></o:p></span></p></div></div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:#26282A'>I’d prefer to use the order you just spent 3 days adapting to.<o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'>I’ve added a checkbox for this con to give those who still haven’t printed the ability to use the old format. It won’t be there for Orccon.<o:p></o:p></span></p></div></div><div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'>Tanya<o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal><span style='color:#26282A'>On Aug 28, 2019, at 8:20 AM, Strategicon Department Heads <<a href="mailto:deptheads@strategicon.net" target="_blank">deptheads@strategicon.net</a>> wrote:<o:p></o:p></span></p></div></div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='color:#26282A'>Message From: Mike James <a href="mailto:minis.tyrant@gmail.com" target="_blank">minis.tyrant@gmail.com</a><o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='color:#26282A'>So, which order will we be using in the future? I just spent 3 days fixing all my spreadsheets to fit the new data order.<o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'>Mike<o:p></o:p></span></p></div></div></div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div><div><div><div><p class=MsoNormal><span style='color:#26282A'>On Wed, Aug 28, 2019 at 7:48 AM Strategicon Department Heads <<a href="mailto:deptheads@strategicon.net" target="_blank">deptheads@strategicon.net</a>> wrote:<o:p></o:p></span></p></div></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'><div><p class=MsoNormal><span style='color:#26282A'>Message From: Tanya Aldrich <span class=yiv7960085823gmail-m-8256194103810754553apple-converted-space> </span><a href="mailto:taldrich@strategicon.net" target="_blank">taldrich@strategicon.net</a><o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='color:#26282A'>Ok, good point. Hold the presses. I will change the order back.<o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'>The new order reads more like all the other pages, which in the long term probably better. Anyone have an issue switching to the new order for Orccon, let me know.<o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'>Tanya<o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal><span style='color:#26282A'>On Aug 28, 2019, at 2:36 AM, Strategicon Department Heads <<a href="mailto:deptheads@strategicon.net" target="_blank">deptheads@strategicon.net</a>> wrote:<o:p></o:p></span></p></div></div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>Message From: Tara Leederman </span><span style='color:#26282A'><a href="mailto:taleederman@gmail.com" target="_blank"><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>taleederman@gmail.com</span></a><o:p></o:p></span></p></div><div><div><div><p class=MsoNormal><span style='color:#26282A'>Hi Tanya,<o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'>For some reason, the event data we use for the sign-up sheets now has the columns mixed up such that it breaks our workflow for creating and printing sign-up sheets. Now, we managed to fix it manually, but I wanted to let you know that the columns had been moved around and that this may result in some headaches for other departments as they go to make and then print their sheets. I have included what it looks like in an intermediate state once I pull down the data, before fixing it and before performing our mailmerge. You’ll see at the top of the column what that column was originally and what it has been changed to. We did ours tonight because we have among the fewest events, and headaches are the easiest for us to fix, so we make a good guinea pig; I thought that would give you a nice early heads up if one was needed.<o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'>Other departments: If you use a template, just be sure to check what ended up where this time around, and note you may have to move columns around before making your sheets.<o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'>Best,<o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'>Tara<o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div></div><div><p class=MsoNormal><span style='color:#26282A'><2019-08 Event Listing Out of Order.xlsx></span><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>_______________________________________________<br>Deptheads mailing list<br></span><span style='color:#26282A'><a href="mailto:Deptheads@strategicon.net" target="_blank"><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>Deptheads@strategicon.net</span></a></span><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><br></span><span style='color:#26282A'><a href="https://strategicon.net/cgi-bin/mailman/listinfo/deptheads" target="_blank"><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>https://strategicon.net/cgi-bin/mailman/listinfo/deptheads</span></a><o:p></o:p></span></p></div></div></blockquote></div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div></div></div><div><p class=MsoNormal><span style='color:#26282A'>_______________________________________________<br>Deptheads mailing list<br><a href="mailto:Deptheads@strategicon.net" target="_blank">Deptheads@strategicon.net</a><br><a href="https://strategicon.net/cgi-bin/mailman/listinfo/deptheads" target="_blank">https://strategicon.net/cgi-bin/mailman/listinfo/deptheads</a><o:p></o:p></span></p></div></blockquote></div><div><p class=MsoNormal><span style='color:#26282A'>_______________________________________________<br>Deptheads mailing list<br><a href="mailto:Deptheads@strategicon.net" target="_blank">Deptheads@strategicon.net</a><br><a href="https://strategicon.net/cgi-bin/mailman/listinfo/deptheads" target="_blank">https://strategicon.net/cgi-bin/mailman/listinfo/deptheads</a><o:p></o:p></span></p></div></div></blockquote></div></div></div></div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:#26282A'> <o:p></o:p></span></p></div></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>_______________________________________________<br>Deptheads mailing list<br><a href="mailto:Deptheads@strategicon.net" target="_blank">Deptheads@strategicon.net</a><br><a href="https://strategicon.net/cgi-bin/mailman/listinfo/deptheads" target="_blank">https://strategicon.net/cgi-bin/mailman/listinfo/deptheads</a><o:p></o:p></span></p></div></blockquote></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div></div></div></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>_______________________________________________<br>Deptheads mailing list<br><a href="mailto:Deptheads@strategicon.net" target="_blank">Deptheads@strategicon.net</a><br><a href="https://strategicon.net/cgi-bin/mailman/listinfo/deptheads" target="_blank">https://strategicon.net/cgi-bin/mailman/listinfo/deptheads</a><o:p></o:p></span></p></blockquote></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><br clear=all><o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>-- <o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>"Would you like another drink, sir?" asked the bartender.<br>"I think not," replied Descartes, and promptly vanished.<o:p></o:p></span></p></div></div></div></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>Message From: Jason DuVall <a href="mailto:nekojin@gmail.com">nekojin@gmail.com</a><o:p></o:p></span></p></div></div></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>_______________________________________________<br>Deptheads mailing list<br><a href="mailto:Deptheads@strategicon.net">Deptheads@strategicon.net</a><br><a href="https://strategicon.net/cgi-bin/mailman/listinfo/deptheads" target="_blank">https://strategicon.net/cgi-bin/mailman/listinfo/deptheads</a><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>