While that was the picture I previously intended for the ranking posts to be started with, now it's different. The corner is renamed to "Mai's JMu-Chart" and new covers/pictures will be used.
These are the new ones. The first one is just sorta the header picture for the introductory page (click here) and the second is the post picture (post header, sorta?).
So... The important points has been written down on the JMu-Chart intro page, but this post is to babble about the process and all those gibberish stuffs. So, how do I start?
There are the corner title, the header pictures, the chart posts structure, the convenient chart documents and...?
The title: Mai's JMu-Chart
First, as it can be seen on the picture at the beginning of this post, I intended to use "Mai's Gibberish J-Ranking" until I changed my though. Gibberish, sure, but J-Ranking? J-Ranking didn't sound much related to music while the whole chart idea was to see my bias ranking of the charts. J is sure, Japanese, but where is the music? Then I though of using "Mu", but with the macro symbol or the greek symbol. But for easier typing, I just used Mu and then combined with J and then -Chart. I don't know why it isn't just Chart without dash, but oh whatever.
The header pictures:
It's the same one as the background picture of this entire blog, but the color was changed. Since I already set up the access reports to have pink shades, I just went with the flow, not wanting to change the color of the 7 reports, one by one. Maybe later? But who knows when, or if I'll actually get on to working on it.
The chart posts structure:
I have not yet picture on how to structure the chart posts, but for sure it will include the post header picture, the body consisting of a little introduction, a picture of the chart, and comments, then ending with a link to the introductory page and the Drive folder.
The convenient chart documents:
When I said convenient, I want the data entry to be convenient. I just enter the data, and voila the report will be ready to be exported and replace the outdated documents in the JMu-Charts Drive folder. This is the biggest part of the corner. The documentation. And for this, I used Microsoft Access since that's the software I'm most familiar with on how to manage databases, even though I wouldn't know how to apply it outside of Access, as in I have to make data entry into the table on the access file itself. And Excel won't give the same convenience of Access reports to look at the outcome.
First, I would need to come up with the necessary fields, and then ideas for the convenient looking data entry. So, for the convenience, I made two tables on Access itself, one for the whole compiled database and the other just to input the data, a short table of just the date (as a primary key field) and notes, if there are any to be taken. Then, a relationship between the two tables is established, and that was between the primary key Date field in the short table and the Date field in the compiled table. That way, I just choose a date, and a collapsable section is made accessible to input the data. Also, knowing what fields to include in the compiled table will need a lot of trials here and there, there and here and messing up with reports and see how it goes.
Next, the reports. I want the reports to have Weekly, Monthly, 6 Monthsly and Yearly edition. The tricky part is the sorting of the charts, thus I implemented Points, that averaged the points I have given when I see it rank on BillboardJK and/or Manzo a.k.a videos. According to the points, it will be sorted descendingly. For the Weekly edition, it was easy. But for the Monthly, 6 Monthsly and Yearly, it was tricky, and that's because during the time period, an act was given points repeatedly if it ranked repeatedly in the videos. I would have to think on how to average the several points of one act and then sort it descendingly for the certain time period. I didn't know how to make a function of that in the table, thus I used the report. I grouped it according to the the desired time period (monthly, 6 monthsly or yearly) and add the average points as an expression and put it in the header. I thought and thought and researched on how to sort it using the expression that would be put in the header, but it was not possible. What I surrendered to was to have two versions of each editions (minus Weekly), Basic version and Unsorted version. The basic version would only include the ranking, but sorted, while the unsorted version will include the ranking, plus details of when it has ranked in the videos, and what ranks it had in either videos and the points, but it can not be sorted. The basic is the trickiest in the whole Access ordeal. I'd have to one draft report for the time period, which has filtered the wanted field. But after completing the report wizard, I deleted all of the content field. For example, the Monthly report, it was supposed to be sorted by year then month and then grouped by the act, but to sort by month, I'd have to use the number month and then rewrite the box with an expression that will return the month name, and the act was replaced with a text box that includes a function to average out the points and the act. I'm not quite sure why I chose the word act for the title, but oh wells, I needed to combine the artist with the song title so it can be easily filtered out. And then the average function are so it can be sorted descendingly according to the points. Anyway, back to the report structure, all the content in the details part is deleted and since it was grouped by act and month, the month and year content was put in the act header. With the details nowhere to be seen, it looks like an easy-looking table, unsorted and repeated year and month values per act, then per month, then per year (not the other way around. yes, it's different the other way around. or I just don't know what I'm talking about). This report version is the draft. This report is then exported to excel and then imported again to be a table and then from the table, the final basic version of the edition is made, with the monthly chart sorted descendingly by year, then by month, then by the text box. The text box format is looking like "00 XXXXXXXXXXXXX", 00 as the points and X's as the act. The final outcome is that, as the name "Basic" suggests, basic-looking. Then similar procedure is done for the 1/2Yearly and Yearly edition. The loop for any update is to export the draft report to excel, import to access table which has to replace the previous version if there are any, and the report is ready to be exported and uploaded into the Drive folder.
Yes, the most important part and mind-boggling is access as it can be discerned by the block of text above. Lol the making process wasn't convenient, but the outcome is as much convenient as I can make it out to be.
This post looks like a report of what I have done, but then again the point of this blog to babble about anything, gibberishly.
So, let's see if I can start working with the chart posts tomorrow. Tehehehe
No comments:
Post a Comment