Author Topic: "Blog of the week"  (Read 1291 times)

Ahiku

  • Administrator
  • No. 6 - Wall Breaker
  • *
  • Posts: 1798
  • Location: Germany
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #15 on: October 23, 2014, 11:23:02 am »
@Lawl, that's a very good idea. We can do it like that. ^^

@Yuneyn: Oh, yes, please! That would be great! :3 You can put it in another thread then and make it sticky, so that we always see the important stuff first.
Thank you! 

I'll draw the banner, we will use for this each month soon. ^^

Then we just need some kind of text source... So that we just need to add the "winners" then each month.

Yuneyn

  • Administrator
  • CF - Intruder
  • *
  • Posts: 262
  • 再会を必ず
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #16 on: October 23, 2014, 11:28:54 am »
I'm creating something, just figured out how to make the top 3 things with the most recommendations appear in green, so that we can decide later if we want to have a top 3 or just one depending on the number of suggestions.


Since I don't have everyone's email, you can send me yours by MP and then I'll invite you to edit the doc once I finished the template page!
“How do you pick up the threads of an old life? How do you go on, when in your heart, you begin to understand, there is no going back?
There are some things that time cannot mend. Some hurts that go too deep... that have taken hold.”

Ahiku

  • Administrator
  • No. 6 - Wall Breaker
  • *
  • Posts: 1798
  • Location: Germany
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #17 on: October 23, 2014, 11:30:40 am »
@Yuneyn, you should see the other's mails when you visit their profiles... o.o

Yuneyn

  • Administrator
  • CF - Intruder
  • *
  • Posts: 262
  • 再会を必ず
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #18 on: October 23, 2014, 11:32:28 am »
Lol, sorry, I didn't even think of that *facepalm* I'll do that^^
“How do you pick up the threads of an old life? How do you go on, when in your heart, you begin to understand, there is no going back?
There are some things that time cannot mend. Some hurts that go too deep... that have taken hold.”

lawlya

  • Global Moderator
  • No. 6 - Wall Breaker
  • *
  • Posts: 634
  • Location: Berlin
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #19 on: October 23, 2014, 11:42:22 am »
Wow, I didn't even know it's possible that Excel does that on its own xD Apparently I still have a lot to find out about this programm ^^"

Yuneyn

  • Administrator
  • CF - Intruder
  • *
  • Posts: 262
  • 再会を必ず
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #20 on: October 23, 2014, 11:45:44 am »
Ok it's done.

I've sent both of you invitations, now I'll also send one to everyone who said they wanted to help with the blog, but since you two are here now I wanted to know your thoughts beforehand.

Basically, the conditional formatting only works if there are at least 3 entries. But I guess when there's less it's easy to see for ourselves the best ones^^
I've tried in the last column to have 3 entries with the same number and another higher one, and the 4 do appear in green so this is taken into account.
For now I've only put a limited amount of lines, but if we get a lot of suggestions it's very easy to add the formatting to more lines.
Then we can create a new spreadsheet for every month, and here we go^^

Now though, it's also possible to have only one spreadsheet per art type, and add new columns for each month. I chose the other format because I thought it would be easier to have directly all the results for the current month in one sheet, but if you prefer something else it's easy to change. (Excel was probably the only thing I liked at my former job lol)

I'm not sure about a sticky post though, as we will directly invite people to the document when they are part of the blog, right? If we let it viewable on the forum, it will ruin the suspense ^^ As you want!


(It's a little less sexy than with a real Excel file, but Google docs has less formatting options *sighs*)
“How do you pick up the threads of an old life? How do you go on, when in your heart, you begin to understand, there is no going back?
There are some things that time cannot mend. Some hurts that go too deep... that have taken hold.”

lawlya

  • Global Moderator
  • No. 6 - Wall Breaker
  • *
  • Posts: 634
  • Location: Berlin
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #21 on: October 23, 2014, 11:55:25 am »
I really like it :D It's great that the top three are green, really ^^ If only my laptop wasn't so agonizingly slow ...

Okay, I see. Yep, I'd go with spreadsheets for each month - makes the whole thing more clearly. And it shouldn't be too hard to copy and paste the suggestions that didn't got to be "Best of the month" to the new sheet either.

Apparently we're all children of Microsoft Office xD

Ahiku

  • Administrator
  • No. 6 - Wall Breaker
  • *
  • Posts: 1798
  • Location: Germany
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #22 on: October 23, 2014, 12:04:23 pm »
Quote
If only my laptop wasn't so agonizingly slow ...

I think something's wrong with this hoster, too... it's incredibly slow oO and the header is gone. ^^°

@Yuneyn:
Wow, thanks, that's really cool. XD Hah, I absolutely have no clue when it comes to Excel. Never really worked with that program, just a little bit. ^^° It seems to be pretty useful.
Quote
I'm not sure about a sticky post though, as we will directly invite people to the document when they are part of the blog, right? If we let it viewable on the forum, it will ruin the suspense ^^ As you want!

Ah, you're right... but we could have a post for suggestions... When people want to suggest something, and also for us to preorder befor putting it in the excel sheet. ^^

I think it's great to see all results of the current month. (Why is it Nov 13? o.o)
Thank you for your effort!

Yuneyn

  • Administrator
  • CF - Intruder
  • *
  • Posts: 262
  • 再会を必ず
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #23 on: October 23, 2014, 12:07:00 pm »
Thanks :-)
Well, as you like it, I'll also send it to Weisel, Curiousscarleteyes and Listenforthelove. And then anyone who wants to join^^

Ah, and November13 for November 2013 ^^ But I can change it if it's too confusing?

Ok for a sticky suggestion post then... in this category as well?


EDIT: WE ARE IN 2014 I HAVE NO IDEA WHAT HAPPENED MY BRAIN HAS ISSUES I'M SORRY
« Last Edit: October 23, 2014, 12:18:31 pm by Yuneyn »
“How do you pick up the threads of an old life? How do you go on, when in your heart, you begin to understand, there is no going back?
There are some things that time cannot mend. Some hurts that go too deep... that have taken hold.”

lawlya

  • Global Moderator
  • No. 6 - Wall Breaker
  • *
  • Posts: 634
  • Location: Berlin
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #24 on: October 23, 2014, 12:26:08 pm »
I'd say Nov for November is enough. Makes it shorter ^^

AND DON'T WORRY ABOUT YOUR BRAIN I DIDN'T NOTICE EITHER UNTIL I READ YOUR EDIT xD

Yuneyn

  • Administrator
  • CF - Intruder
  • *
  • Posts: 262
  • 再会を必ず
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #25 on: October 23, 2014, 12:28:31 pm »
Tab names changed^^ You're right, shorter is better ;)

(And thanks! I'm not even 30 yet it can't be old age dammit!!!!)
“How do you pick up the threads of an old life? How do you go on, when in your heart, you begin to understand, there is no going back?
There are some things that time cannot mend. Some hurts that go too deep... that have taken hold.”

Ahiku

  • Administrator
  • No. 6 - Wall Breaker
  • *
  • Posts: 1798
  • Location: Germany
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #26 on: October 23, 2014, 12:45:05 pm »
It's alright XD 2013 was better, anyway... since Nezumi and Shion had their first meeting then. ^^

Vox

  • Administrator
  • No. 6 - Wall Breaker
  • *
  • Posts: 844
    • View Profile
    • My tumblr o3o
Re: "Blog of the week"
« Reply #27 on: October 24, 2014, 04:55:51 pm »
If we're going to be exchanging documents, maybe we should set up a Google Drive or something?

Yuneyn

  • Administrator
  • CF - Intruder
  • *
  • Posts: 262
  • 再会を必ず
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #28 on: October 25, 2014, 02:42:42 am »
Do you mean like a joined Google Account? But then wouldn't freak out if like 10 different people from different locations log in at the same time? (I know mine freaked when I did Japan - New Zealand - Japan - France in like one month)
“How do you pick up the threads of an old life? How do you go on, when in your heart, you begin to understand, there is no going back?
There are some things that time cannot mend. Some hurts that go too deep... that have taken hold.”

Weisel

  • Restructural Committee
  • No. 6 - Wall Breaker
  • *
  • Posts: 895
  • Location: United States
    • View Profile
Re: "Blog of the week"
« Reply #29 on: October 25, 2014, 11:06:05 am »
It would just be the documents that are shared, not the account. I've had google documents open at the same time as other people who were in other countries and it was no problem.