Presenting the Second Life Fashion & Shopping Events Spreadsheet!

Posted on Updated on

EverAfterr's SL Fashion & Shopping Events Spreadsheet!

Hi everyone! I was so amazed and delighted with the response to my recent post about my Second Life events spreadsheet that I researched my buns off and figured out not only how to share and embed this spreadsheet for others to enjoy, but also how to allow people to have their own personalized copy. So excited! Please click the link below to check it out:

Second Life Fashion & Shopping Events Schedule

There was a bit of discussion about additionally creating a calendar-based format in the comments of my post. Out of curiosity, I began setting one up to see how different it would function, and I personally find it to be more cumbersome and it requires more time to update and more clicks to get to to the relevant information. The main issue I was concerned with is that Google Calendars appear to truncate data if too many events begin overlapping, which as we know is extremely common in Second Life. Here’s a screenshot for reference:

Google Calender

I had only added 12 events to the calendar before I stopped; the screenshot is taken with a resized browser window so I could fit it to a reasonable size, but even with my browser maximized to my full 1920×1080 resolution, and the calendar set to the “Compact” sizing option, at most we would be able to view 7 concurrent events at a time. That’s why you see the little “+5 more” or similar links beneath the dates. Also if you needed a SLURL, which I included in the “Where” field for each event I added to the calendar, you’d have to open the event information and copy the link either into another browser window or into the Location bar of the viewer. As best I could tell, there was no way to make those SLURLs clickable without adding HTML code.

TL;DR – Spreadsheets are at-a-glance and super easy to update, so that’s what I’m stickin’ to! ♥

You can learn more about the formatting and how it updates on the spreadsheet page, but I wanted to add a neat trick here: there’s a way that you can have your own personal version of the spreadsheet that will auto-update for you, usually in as little as 30 seconds after I make a change. How cool is that? There are some limitations however: if you make any changes to the sheet, like highlighting certain rows, or adding notes in a specific event’s row, that information will all get overwritten or shifted around the next time the sheet is updated. If anyone knows how to get the information to dynamically update into someone’s personalized sheet and yet allow changes that they’ve made to specific rows to “travel” with the updates, I’d love to know!

So how would a personal version be helpful? Probably the best way to use it would be to set up a new Google Sheets document, have my event schedule auto-populate into one of the sheets, and then use an additional sheet to store information about your sponsors, which events they’re participating in, your most-used SLURLs for post credits, and so on. I know this might make your head spin if you’re not too familiar with spreadsheets (I’m an Excel throwback, so Google Sheets were somewhat familiar but still completely new to me). However, if you’re somewhat comfortable with working with them, here’s how you would set up your own, auto-updating copy of the data:

❖ Go to Google Drive, click on the red New button, and choose Google Sheets.

❖ In the first cell of the sheet, A1, paste in the following code snippet:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UAupdzbtEhoDJtJWQRulbuGiRGJKE9QtQKyugBb_8yA","Second Life Fashion & Shopping Events!A1:D200")

❖ Hit your Enter button. At this point, you may see a #REF! cell, or a pop-up asking you to give permission to the master sheet to enter data into your personal sheet. Click the “Allow” button, and that should do it!

You may need to fancy-up the formatting a bit (add bold text, realign the columns, etc) but once that’s complete, the sheet should automatically update itself with new or changed event and dates as I work on the master sheet. Awesome-sauce!

I’m flirting with the idea of adding additional sheets to the master. These might include a similar schedule that covers ongoing hunts; SLURLs and Marketplace links for active designers and brands; scenic destinations to help bloggers and Flickr photographers find locales for special shots; and so on. That’s me – once I get the seed of an idea for a project, it just grows and grows! Let me know in the comments if any of these additional options would be useful, and please do enjoy the spreadsheet/schedule. Thank you to all of the lovely commenters who inspired and motivated me to make it a resource that everyone could benefit from! ♥

Second Life Fashion & Shopping Events Schedule

Advertisements

15 thoughts on “Presenting the Second Life Fashion & Shopping Events Spreadsheet!

    rainbowmubble said:
    June 30, 2015 at 10:47 pm

    What a great idea! I already use a spreadsheet to keep track of my blog posts for sponsors and stuff so this will be a great addition as I’m always having to hunt down slurls and dates :D

    Liked by 1 person

      Ever Afterr responded:
      June 30, 2015 at 11:15 pm

      Thank you so much, Rainbow! I’m so happy it will be useful to you; please let me know if you have any suggestions or improvements I can make! ♥

      Like

    readmeri said:
    July 1, 2015 at 3:43 am

    Well done Ever, it’s like a present for us <3

    Liked by 1 person

      Ever Afterr responded:
      July 1, 2015 at 6:30 am

      Thank you so much, Meri! Please let me know if you think of any improvements or additions I can make. Cheers for the inspiration!! <3

      Liked by 1 person

    annagibby33 said:
    July 1, 2015 at 4:38 am

    Ever you are too kind! I have a love and *frowns* with this post as I am going to blame all my extra spending in SL on you! haha Seriously though this is awesome, thank you!

    Liked by 1 person

      Ever Afterr responded:
      July 1, 2015 at 6:29 am

      Hahaha, Anna! I’m so sorry I’m not sorry. :D Go forth and shop, lovely lady! Thank you so much for your kind words! <3

      Liked by 1 person

    Kess Crystal said:
    July 1, 2015 at 5:52 am

    oh you totall rock Ever This, and you, are amazing! <3

    Liked by 1 person

      Ever Afterr responded:
      July 1, 2015 at 6:30 am

      You’re so kind and lovely to say that Kess, thank you so much! So happy it will be useful for you! <3

      Like

    […] And I want to sneak in a sincere thank you to the kind soul(s) who shared my Second Life Fashion & Shopping Events Spreadsheet post on Facebook! I don’t have an account there myself, and I noticed a lot of visitors […]

    Like

    sunglo said:
    July 4, 2015 at 3:57 am

    great idea!

    Liked by 2 people

      Ever Afterr responded:
      July 4, 2015 at 5:50 am

      Thank you so much, I really appreciate it! xoxo

      Like

    […] Presenting the Second Life Fashion & Shopping Events Spreadsheet! […]

    Like

    Imogen Jie said:
    July 21, 2015 at 7:20 pm

    Thank you so much for sharing this. I made a dated list with SLURLS for my blog a while back but this is sooo much better! ♡

    Liked by 1 person

      Ever Afterr responded:
      July 22, 2015 at 12:44 pm

      Awww, you’re so welcome! Thank you so much for your comment, I’m thrilled to know that it’s helpful for people, and any suggestions for additions or improvements are always welcome! ♥

      Like

    Dykoda Desmoulins said:
    July 24, 2015 at 12:38 pm

    Reblogged this on Dykoda's Domain and commented:
    It took me awhile to re-locate this post in my email, but I finally did and wanted to share it. I get SOOO many group/event notices in my email that often, I must admit, I will get click happy and many go unseen prior to finding their way into the trash folder. This is simple, but very useful…hope you find it as helpful as I do.

    Like

Share Your Thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s