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

Yuneyn

  • Administrator
  • CF - Intruder
  • *
  • Posts: 262
  • 再会を必ず
    • View Profile
    • Tumblr
Re: "Blog of the week"
« Reply #15 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.”