i'm working on a database compiling all the new entries of the 90's and tracking their chart run and was curious as to what i should do with the songs that re-entered that had charted in 89. Should i include these and mark them as re-entries or just focus on the debuts?
has anyone created any databases for the album charts of the 90s and the AMR top 100 up till the end of it being used. I can eventually put together a top 50 albums database but the AMR info looks to not exist on the web in any form.
and AMR went on till at least 1998. I used to have a tape of the Rock 40 countdown from june 1995 that was compiled by the australian music report but it only went from 23-6. I can pretty much remember the positions of those songs,which i mention just because i can,,not that it's of any help
In a clip from 1994 where give it up by cut 'n' move was number 1 at the end of the show the announcer says that the rock 40 countdown is compiled by the australian music report. The show from 1995 was hosted by someone else
I must have had my dates wrong,yet i'm going by this website. If you can post the week after which is the one where all the positions are repeated i'd be extremely grateful. Interesting to get the previous weeks positions for albums outside the top 50. Whatever you are able to do nugs. Thank you.
The chart nugs posted for w/c 1st may is the same chart listed here for the w/c 24-30th april. Word for word it's precisely the same perhaps with some of the previous weeks positions inaccurate. Last edited:
Apologies if this is a little off topic but on the subject of chart databases and spreadsheets, I recently found a solution to a problem that others may find helpful.
I've always found it frustrating that the weekly ARIA chart doesn't separate Title & Artist into separate columns but combines them into one string of text (with the title all in uppercase).
I had an excel spreadsheet with all of the top 100 singles charts since 1999 showing the title & artist in one column but I wanted to split them into separate columns. To manually go through 115,000+ lines was going to take a LONG time. Then I stumbled across a formula that was able to do most of the work for me.
I used the following formula (where E2 is the cell with the title/artist): =MATCH(1,IF(ABS(CODE(MID(E2,ROW(INDIRECT("1:"&LEN(E2))),1))-109.5)<=12.5,1),0)
This formula identifies the position of the first lowercase letter in the text string in cell E2. In most cases, the first lowercase letter is the 2nd letter of the artists name. Obviously this isn't always the case. Some artists have no lowercase letters (U2, REM, N*E*R*D, etc.) and some artists have lowercase letters but not in the right position for this formula (2Pac, J. Cole, BLACKstreet, 24kGoldn, etc.).
However in about 97% of cases, the first lowercase letter is the 2nd letter of the artist's name. So adding -2 to the end of the formula above will give you the position of the SPACE between the title and artist (two positions back from the first lowercase letter).
For example, using the above formula on "DANCE MONKEY Tones and I" would return the number 13 which correlates to the space between MONKEY and Tones (i.e. the space between title & artist).
Now we can use another formula to replace that space with a semicolon. Using the Dance Monkey example (where E2 is the title/artist field and L2 is the cell containing the first formula): =REPLACE(E2,L2,1,";")
The result of this 2nd formula is "DANCE MONKEY;Tones and I"
From here you can copy and paste your data as values then use 'text to columns' in the data menu to separate the data (using semicolon as your delimiter) which will shift everything after the semicolon into the next column.
For the other 3% of cases where this formula didn't work, I had to separate the data manually but that was a far better scenario than doing 100%!
Note: to move the certification at the end of the title/artist into it's own column you can use find/replace (Ctrl-F). Cut and paste the certification symbol into the 'Find what' box and then paste it again into the 'Replace with' box then type a semicolon in front of it. Then you can use text to columns as explained above to move it into the next column.
For anyone who has the 88-2002 spreadsheet, for the week of the 8th october 1995 you might want to make these corrections, as i've compared them to the actual ARIA chart
The spreadsheet lists 'Baby Baby' by corona as dropping from 97 to 100, the correction is it left the chart from the previous weeks position of 98
'Greg The Stop Sign' by TISM listed on the spreadsheet as dropping out It goes from the previous weeks position of #97 to #100
and finally 'Devil's Diary (Bigger Than Jesus Now' by The Caufields is listed on the spreadsheet as leaving the chart from #98, it actually leaves from #96.
Normally i tend not to post these kinds of corrections if it's only just one, but since i'm working on my own spreadsheet compiling chart runs of new entries from this period i noticed it for the first time. I posted this here as i couldn't find the corrections thread and also it's related to the spreadsheet/database. Last edited:
Another database correction this time for the 1991 spreadsheet. The week of 3/2 the person who compiled it mentions the chart is missing and there are positions which are guesswork,however the songs leaving the chart do not match up. six are correct,two are left blank. So change the two blank entries for the following
83 From out of nowhere - faith no more 81 The great song of indifference - bob geldof