Year-End Chart question

[GordonUM]

First of all, the year-end top 100 charts are now up at R&R's site. And I've got a question that's pretty obvious once you see the AAA chart. What is up with there being two songs for every number? I would figure one is for the monitored chart on the website and one is for the indicator chart, as many songs show up twice. But you still can't piece both charts together from this, as Ben Harper's "With My Own Two Hands" is the first of the two songs listed at both #1 and #16. It is nice to see some good songs listed that never made the monitored top 30 that we get on the website (like the ones by Joseph Arthur and Turin Brakes), but if someone could post one or both of the charts in a clear format, that would be appreciated.

[mst3k]

Looks like they've updated it... now it shows only the top 100 for the monitored chart. Ben Harper is indeed #1 on the yearend indicator chart. (If you saved the double-titled chart, you should be able to piece it together with what's up there now... if not, one of us with the magazine will post the indicator chart). :)

[GordonUM]

Cool, I'll put that together and post it tonight.

[ted11804]

People always talk about "saving the final update" or "saving the triple a c hart"....how DO you save webpages?

[GordonUM]

Alright, if I have this right, here's the indicator top 100:
1 Ben Harper  With My Own Two Hands (Virgin)
2 Lucinda Williams  Righteously (Lost Highway/IDJMG)
3 Jack Johnson  The Horizon Has Been Defeated (Jack Johnson Music/Universal)
4 Coldplay  Clocks (Capitol)
5 Ziggy Marley  True To Myself (Private Music/AAL)
6 Jack Johnson  Wasting Time (Jack Johnson Music/Universal)
7 Jason Mraz  You And I Both (Elektra/EEG)
8 Jason Mraz  The Remedy (I Won't Worry) (Elektra/EEG)
9 Wallflowers  How Good It Can Get (Interscope)
10 David Gray  Be Mine (ATO/RCA)
11 Jayhawks  Save It For A Rainy Day (American/Lost Highway/IDJMG)
12 Ben Harper  Diamonds On The Inside (Virgin)
13 Susan Tedeschi  Alone (Tone-Cool/Artemis)
14 John Hiatt  My Baby Blue (New West)
15 John Mayer  Why Georgia (Aware/Columbia)
16 Johnny Marr & The Healers  Down On The Corner (iMusic)
17 Kathleen Edwards  Six O'Clock News (Zoe/Rounder)
18 Guster  Amsterdam (Gonna Write You A Letter) (Palm/Reprise)
19 Los Lonely Boys  Heaven (Or)
20 Coldplay  The Scientist (Capitol)
21 EastMountainSouth  You Dance (DreamWorks)
22 Dar Williams f. John Popper & John Medeski  I Saw A Bird Fly Away (Razor & Tie)
23 Sting  Send Your Love (A&M/Interscope)
24 John Mayer  Bigger Than My Body (Aware/Columbia)
25 Train  Calling All Angels (Columbia)
26 Thorns  I Can't Remember (Aware/Columbia)
27 Pete Yorn  Crystal Village (Columbia)
28 Bruce Cockburn  Open (True North/Rounder)
29 John Eddie  Let Me Down Hard (Thrill Show)
30 Damien Rice  Volcano (Vector Recordings)
31 Beck  Lost Cause (Geffen/Interscope)
32 Jonny Lang  Red Light (A&M/Interscope)
33 Widespread Panic  Don't Wanna Lose You (Widespread/SRG)
34 R.E.M.  Bad Day (Warner Bros.)
35 Steve Winwood  Different Light (Wincraft/SCI-Fidelity)
36 Pete Yorn  Come Back Home (Columbia)
37 Fleetwood Mac  Peacekeeper (Reprise)
38 George Harrison  Stuck Inside A Cloud (Capitol)
39 Steely Dan  Blues Beach (Reprise)
40 Nickel Creek  Smoothie Song (Sugar Hill)
41 Howie Day  Perfect Time Of Day (Epic)
42 Pretenders  Complex Person (Artemis)
43 Tori Amos  Taxi Ride (Epic)
44 Tracy Chapman  You're The One (Elektra/EEG)
45 Soundtrack Of Our Lives  Sister Surround (Republic/Universal)
46 Michael Franti / Spearhead  Everyone Deserves Music (iMusic)
47 Annie Lennox  Pavement Cracks (J)
48 Phish  46 Days (Elektra/EEG)
49 David Gray  Caroline (ATO/RCA)
50 Richard Thompson  I'll Tag Along (SpinArt/Cooking Vinyl)
51 Paul Simon  Father & Daughter (Nickelodeon/Jive)
52 Dave Matthews  Gravedigger (RCA)
53 Joe Jackson  Awkward Age (Rykodisc)
54 Tori Amos  A Sorta Fairytale (Epic)
55 Rhett Miller  Come Around (Elektra/EEG)
56 Sheryl Crow  C'mon, C'mon (A&M/Interscope)
57 Rosanne Cash  Rules Of Travel (Capitol)
58 North Mississippi Allstars  Eyes (Tone-Cool/ATO)
59 Dar Williams  Closer To Me (Razor & Tie)
60 Joseph Arthur  Honey & The Moon (Enjoy/Universal)
61 Wallflowers  Closer To You (Interscope)
62 Allman Brothers Band  Firing Line (Sanctuary/SRG)
63 Peter Gabriel  More Than This (Geffen/Interscope)
64 Counting Crows  Big Yellow Taxi (Geffen/Interscope)
65 Bruce Springsteen  Lonesome Day (Columbia)
66 Sheryl Crow  The First Cut Is The Deepest (A&M/Interscope)
67 Jayhawks  Tailspin (American/Lost Highway/IDJMG)
68 Robert Randolph  Soul Refreshing (Warner Bros.)
69 Norah Jones  Come Away With Me (Blue Note/Virgin)
70 Mavericks  I Want To Know (Sanctuary/SRG)
71 Beth Orton  Thinking About Tomorrow (Astralwerks/EMC)
72 Patty Larkin  Different World (Vanguard)
73 Van Morrison  Once In A Blue Moon (Blue Note/EMC)
74 Pseudopod  All Over You (Interscope)
75 Phil Roy  Undeniably Human (Or)
76 Sonny Landreth  Hell At Home (Sugar Hill)
77 Radiohead  There There (Capitol)
78 Robert Cray  Back Door Slam (Sanctuary/SRG)
79 Train  When I Look To The Sky (Columbia)
80 Blues Traveler  Let Her & Let Go (Sanctuary/SRG)
81 Kim Richey  The Circus Song (Can't Let Go) (Lost Highway/IDJMG)
82 Fleetwood Mac  Say You Will (Reprise)
83 John Hiatt  Circle Back (New West)
84 Jesse Harris  All My Life (Blue Thumb/VMG)
85 Keller Williams  Love Handles (Sanctuary/SRG)
86 David Gray  The Other Side (ATO/RCA)
87 Lyle Lovett  My Baby Don't Tolerate (Curb/Lost Highway)
88 Sarah McLachlan  Fallen (Arista)
89 Jesse Malin  Queen Of The Underworld (Artemis)
90 O.A.R.  Hey Girl (Lava)
91 Turin Brakes  Pain Killer (Astralwerks/EMC)
92 Warren Zevon  Knockin' On Heaven's Door (Artemis)
93 Joe Firstman  Breaking All The Ground (Atlantic)
94 Shelby Lynne  Telephone (Capitol)
95 Steve Earle  Jerusalem (E-Squared/Artemis)
96 Barenaked Ladies  Another Postcard (Chimps) (Reprise)
97 Steely Dan  Things I Miss The Most (Reprise)
98 Joan Osborne  Only You Know & I Know (Compendia)
99 Ziggy Marley  Dragonfly (Private Music/AAL)
100 Coldplay  Moses (Capitol)

As for saving webpages, there are many ways to go about it. It all depends on how you wanna use them. As I see it though, there are three formats that you can save the charts in: HTML, text, and spreadsheet (like Microsoft Excel). HTML is probably the simplest way to save charts, as you've just gotta go to "Save" under the file menu, or look for the disk icon on your toolbar. It also takes up the most space on your computer.

So I mostly save as text or spreadsheet files. You can save to text either by going to "save" and "save as text" or highlighting and copying the entire page to a text editor like Notepad. Most charts are in a table format and sometimes it's tough to get one line in a table to show up as one line in a text file. They often end up with the title, artist, and everything each on different lines. You've just gotta find what works, and it all depends on lots of factors, like how the website is set up and what browser and version you're using. I use Windows XP right now, and my current method for text files is that for the Mediabase site, I can just go to "Save as text" in the Opera browser (available at http://www.opera.com) and I get a good text file. For R&R's site, however, I need to use Internet Explorer, and I need to copy the text and paste it to Notepad.

Finally, saving to spreadsheets is the method that allows you to do the most with the chart info. Once you've got the table from the website onto your own spreadsheet, you can sort and copy the data in any way you like. Again it can take a while to find a way to end up with data that's in a manageable format. Also, if you're going for the most manageable files, it's important to make sure that you get rid of any special text formatting from the website, which would take up extra space and slow you down. With my setup, I can copy from the Mediabase charts from Opera to Excel and get them in plain text and all lined up, the way I want it. With the R&R charts however, I need to copy from Internet Explorer to Excel, which gives me charts that still have the formatting. Then I copy from that sheet in Excel and "Paste Special" to a new sheet, pasting the values only, and delete the first sheet.'

I hope this hasn't made things more confusing, though it probably has. You've gotta play around with all the software to get things to work, but it's alright to start simple and work up as you want to do more with the charts you save.