The bad thing typing a babble on phone is that there is limited editting that can be done. Can't move pictures around as I like. Such a hassle.
As I have written in the previous post... that I'd babble something up about the tweaks I made to the Access masterfile for the JMu-Chart. It's not just software-related technical stuff, but also in the way I give points. As for the software-related technical stuff, the major tweaks would be the addition of two more column that allows for me to rewatch the video and give points again without changing my initial points and then average it. What comes next would be the function for the average points and what I use to sort the JMu-Weekly. What else? I guess that's about it.
So first... wait... the above paragraph is like a summary, but I can't find words to expand what's it all about. Haha anyway, the addition of two columns. I thought that I could use them in case I relistened or rewatched the videos and had new points to give in mind. In case that my initial points ain't what I thought it should be. LOL but really, all points that I gave are biased.
The difficult part comes after and that is to work out the function that averages the given point and unlike the previous version, I will not have to put in a 0, so then a zero will be a zero and not used as a condition. The only function I used is Iif function in the table. But not just simple Iif function, but nested Iif function of nested Iif function. If that sounds like it makes sense. Anyhow, I had to write down the route. What to return if the expression is true and what to return if otherwise. I made a draft on word and it worked great. The first method I thought was a tad too complicated, but the second one was easy to apply to the table.
What's next was to work out the points difference to help sorting the JMu-Weekly. Honestly though, now that I think about it, it ain't fairly or sensibly done. I just add up the points difference between the oricon and billboad (and not the other way around, so a minus value do also return for this column) for first points I give and the second. It only works for the Weekly one though. The basic monthly is really ranked descendingly by points AND then alphabetically (a to z). Then I thought perhaps for the monthly and whatever comes after, it wouldn't matter too much because at least there should be a number or two after the decimal points.
The difficult part comes after and that is to work out the function that averages the given point and unlike the previous version, I will not have to put in a 0, so then a zero will be a zero and not used as a condition. The only function I used is Iif function in the table. But not just simple Iif function, but nested Iif function of nested Iif function. If that sounds like it makes sense. Anyhow, I had to write down the route. What to return if the expression is true and what to return if otherwise. I made a draft on word and it worked great. The first method I thought was a tad too complicated, but the second one was easy to apply to the table.
What's next was to work out the points difference to help sorting the JMu-Weekly. Honestly though, now that I think about it, it ain't fairly or sensibly done. I just add up the points difference between the oricon and billboad (and not the other way around, so a minus value do also return for this column) for first points I give and the second. It only works for the Weekly one though. The basic monthly is really ranked descendingly by points AND then alphabetically (a to z). Then I thought perhaps for the monthly and whatever comes after, it wouldn't matter too much because at least there should be a number or two after the decimal points.
Those are, more or less, the tweaks... But other changes also include the higher points. I have been thinking since last year (2015) that I should be lowering the bar. Lol not really lowering the bar, just give higher points. 85-90 for potentially the best one I like, 75-80 for potentially the one I like, etc. So that the ranking is more distributed or diverse? Or what am I saying...? Lol
Yeah, the post title. It's no longer including the word chart and then just to be short, it's JMu-****ly. Like, JMu-Weekly, JMu-Monthly, and so on and so forth. Though I wonder how will I do the title for the half of the year chart. JMu-6Monthly? June will be my exams month though, or at least the first two weeks of it as far as I remember. But then again, it will include the last Monday of June, so when is that? 27th. I will be able to do it then if it's 27th. My flight will be 18th July, so there should be time. :)
Yeah, the post title. It's no longer including the word chart and then just to be short, it's JMu-****ly. Like, JMu-Weekly, JMu-Monthly, and so on and so forth. Though I wonder how will I do the title for the half of the year chart. JMu-6Monthly? June will be my exams month though, or at least the first two weeks of it as far as I remember. But then again, it will include the last Monday of June, so when is that? 27th. I will be able to do it then if it's 27th. My flight will be 18th July, so there should be time. :)
Aaahh.... the date in the title is supposed to be 14/02/2016, but I fell asleep, so 15/02/2016. (^_^;) I don't know what else to babble about that is related the Access. Ah, the Billboard video for this week hasn't been uploaded as of now, so I will do the ranking later.
Ah, that reminds me. There is actually something. Like, the video for Billboard Japan Hot 100 is uploaded for the data gathered the week before and usually at the beginning of the current week going on (Monday or Sunday), while the results of the week before comes out every Thursday, or was it Friday? Anyway, then the oricon one,it has two lines above the weekly chart. The first line, as the uploader so kindly told me, is for the date the results is to be released, while the second line is the time period by which the CD singles is counted for the to-be-announced results. And Oricon release the results early on Tuesday/Wednesday and the uploader also uploads every Sunday or Monday which is so close or on the date that's mentioned as the first line above the weekly chart on the Oricon website, which then lead to roughly be uploaded two weeks after the data-gathering week, while the Billboard is only one week after. Anyhow, anyhow, I'll just give points to the video I watch that one week and the videos that I watch that one week is the ones the channel uploaded that week, so my ranking has nothing to do with the actual release date of the act. In other words, I'm ranking the ones I heard that week. Or at least if I'm on time ranking it and not late. If I'm late I just put the Monday date that both the videos has on their titles.
So anyway, that's about it, no.
Ja.
No comments:
Post a Comment