The Rate & Graphics Help Desk | Page 6 | The Popjustice Forum

The Rate & Graphics Help Desk

Discussion in 'Charts, rates etc' started by ohnostalgia, Jun 8, 2018.

  1. For what it's worth, I Wanna Dance With Somebody won the Whitney singles rate.
  2. @londonrain lending knowledge and expertise to the collective. King!

    Just another 2 cents on the commentary compiling front. For the Agnes rate, I ended up making a Google webform with all of the song names and commentary, such that I ended up with a spreadsheet with all the commenters' names in the first column, and then I could go through 2 columns by 2 columns to cut and paste the scores and comments. I'm not sure that was necessarily the easiest way to do it; I probably trusted myself not to screw up a webform more than I would a spreadsheet when it comes to cutting/pasting.

    I definitely co-sign on the "do everything at once" message that @soratami shared. Personally, I have found myself easily distracted trying to work through things, so I might add "do everything the same at the same time." For example, enter all your averages into your document at the same time, enter all the high/low scorers at the same time, enter all the graphics or YouTube links at the same time, (insert what applies to your rate) etc.

    Lastly to quote our thread creator:
    Speaking only for myself, I know that we all have stuff going on outside the forum and life is bound to happen. If there is going to be a delay in the rate, or you need a breather, I would like to believe that most people on here would be okay with it, provided that it was communicated. Along the same lines, we are all human beings (except for me, I'm part robot), and there is always the potential for errors--especially the larger your rate gets. Your voters ought to be understanding; after all, they've committed their time to participating, and therefore they should be rooting for you to succeed. (Obviously this doesn't apply if you're deliberately messing things up.)
  3. I love this thread and think your opening should be mandatory for all first time rate hosts (especially as a first time rate host!). I’ve been very lucky that all my voters have been super understanding of the life events that have bumped a smooth elimination process but it’s definitely way more work than I imagined!
  4. Yes.

    This is such a great and helpful thread. @beyoncésweave's Sugababes' Rate was already mentioned, but it certainly made me want to do better by Kumi, when I started her rate. Part I was definitely a bit of learning experience and in Part II I went all out with the write-ups, each taking me at least an hour to finish. We'll see if I'll be able to keep this up with two more Parts, dddd.
  5. One the best things you can do for commentary is what @soratami mentioned. I make a Google Document (the one like Microsoft Word) with all the names of the songs in headline font and have the outline show on the left side. When I get a ballot I prevent having to type a person's username a bunch of times by making an autocorrect like if I type a 'd' it types out 'djhazey' for example. Now i can quickly type d, the score i gave and paste in my comment for each song under its headline on the document. Do this for ballots as the come in. The outline makes it easy to click to the song you are working on without having to scroll.
  6. londonrain

    londonrain Staff Member

    Yeah, that’s what I did for my 1998 rate too. So much quicker and easier when you’re doing the eliminations!
    soratami likes this.
  7. ohnostalgia

    ohnostalgia Staff Member

    I just want to say it’s okay to host things on the fly too. Like I do the scoring and commentary document, but I do all my write ups and graphics the day of the elimination. You should do some prep work, but don’t be intimidated that you need to have everything planned and written out before you start.
  8. londonrain

    londonrain Staff Member

    Oh, that’s what I do now. I put the commentary document together in advance, but every elimination for my 2018 rate was written on the day.
  9. ohnostalgia

    ohnostalgia Staff Member

    Like in theory I know it makes sense to pre-write some eliminations, but I just can’t do it. I need to feed off what’s been happening in the thread.
  10. londonrain

    londonrain Staff Member

    I pre-wrote a few of them for my first rate, but it’s not really practical. I did, however, do all my graphics in advance for the first rate, whereas I just chose promo photos from the relevant era for the second rate until you kindly offered to do the last stretch of graphics.
  11. ohnostalgia

    ohnostalgia Staff Member

    Generally I save a lot of photos for an artist ahead of time and then do the graphic the day of. I did that for the Taylor rate.
  12. I usually try to make as many graphics ahead of time as possible, but that's also because it's one of the parts I enjoy the most about running a rate dd.
  13. I've literally done all the 130+ artworks for my future rate (I mean I love to use Photoshop so not a problem) but if I won't get enough partecipants I will scream.
  14. Yes. Honestly, as enjoyable as it's been doing the long histories of each artist for the One-Hit Wonders rate, I'm not sure that I'd want to put myself through writing commentaries that extensive again, especially as I'll have a lot more time commitments over the coming months. (And it fell way behind the schedule I wanted it to, but that's mostly because I expanded it waaaay beyond what I originally thought it would be.)

    That's why, with my next idea for a rate, it's going to be one with quick-to-do posts where multiple results can be revealed at once, more along the lines of one of @DJHazey 's "Ultimate AlbumJustice/Ultimate Popstars" ones. The main challenges there would be formatting the spreadsheet, probably!
  15. Thank you @londonrain for that spreadsheet example! As someone who failed accounting in high school, I find the spreadsheet to be the most challenging part of rate hosting ddd. I will be stealing some of those formulas.

    Also how did you make it so that when you scroll, the text and average rows stay still?
  16. ohnostalgia

    ohnostalgia Staff Member

    Freeze paning.
  17. How do you go about activating that, by the way? I have never worked it out Dddddd
  18. This is what I did for the Sabrina rate, and it did help.
    I prefer your/@ohnostalgia/mine/etc rate style over standard bare bones ones, but I've never had a problem with any rate style.

    This is such a great thread @londonrain.
  19. ohnostalgia

    ohnostalgia Staff Member

    View -> Freeze Pane. Should be similar in google sheets and excel.
  20. This is a rate spreadsheet template based on the one @londonrain posted in the opening post. It's easy to use and gives you a ton of information without requiring any effort aside from inputting people's scores. It might come in handy for people wanting to host their first rate or experienced hosts who have been using a more basic spreadsheet in previous rates.

    The first sheet is divided into sections (which can be, for example, albums or acts), and can readily give you information such as album averages and a lot more. It's currently divided into 8 sections of 9 songs each, but you can easily increase or decrease the number of sections, songs or songs per section. You just have to make sure the averages for each section are being calculated correctly (for example, if your first section has 12 songs instead of 9, the "Section 1 average" cell, C81, should read =AVERAGE(C2:C13) instead of =AVERAGE(C2:C10)).

    The second sheet is a more simplified version of the first one, and can be useful for, for example, sorting the songs in elimination order while keeping the first sheet in default order.

    Credit goes to @londonrain for creating this, all I did was clean it up and make some minor tweaks. If anyone does use the spreadsheet and has some trouble with it, feel free to bring it up in this thread as I'm sure people will be able to help.
    Last edited: Jan 30, 2020
    Maki, myblood, Remorque and 10 others like this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.