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?
Hi, although coming from europe I am very interested in Australian Charts from 1983 til 1986. I also have some Countdown Shows and they are great.
I found the weekly aria top 50 and a few hints of positions below but I also like to get the complete chart positions from 51 til 100. Has anybody a source where to get them?
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.
One issue with the AMR data is that the National Library's (who have the best collection of KMR/AMR in any of the State libraries) AMR collection stops in early 1993. Last edited:
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
Was Rock 40 based on AMR? I remember listening to it circa 1991 (hosted by Mike Hammond), and thinking it may have been different to both ARIA and AMR.
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
This seems more of a one thread fits all for questions i don't have answers t,but if anyone has the top 50 albums chart for the week of 14th may 1989 can they confirm that the positions are exactly the same as the previous week with no new entries as shown here https://australian-charts.com/weekchart.asp?cat=a&year=1989&date=19890514
If the above chart is incorrect can someone private message me with the correct positions. Just seems odd to have 50 positions exactly the same for two weeks running.
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:
Thank you very much nugs. Trust me,if you felt confused you ought to have seen me today when trying to make sense of the mistakes on this site. I sympathise with you.
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
I don't have the albums charts for this period so can anyone a) tell me what the correct positions are, and what albums are in the incorrect positions for those repeated weeks (24 & 31/7, 7.14 & 21/8)
Huge ask i get, so any help would be very appreciated