Master Song List - Wiki album list - World Tour Master List!

**sideshow** · Joined: 04 Mar 2007 Posts: 138 Location: Glasgow

Cygnusx1? As in THE four-DT-in-a-shuttle Cygnusx1?

EDIT: oops, and the relevant stuff:

OpenOffice should be able to open a .xls, and is free and available on all platforms. So long as you aren't using any macros in your sheet, which I don't think you are.

EDIT2: Also, you might like this: select all the cells in your header row, then go to data->filter->autofilter.
_________________

**djcardshark** · Joined: 31 May 2007 Posts: 335 Location: NEPA

That auto-filter is unbelievably awesome. You'll now see on the sheet drop-down arrows across the header row, making it extremely easy to see all of Metallica's songs in the game, or look at all 7th tier vocal songs, or the list of songs that will be released when Who's Next comes out. This also kind of eliminates the need to sort the data, which is good, cause that was a pain. Thanks, sideshow.

The OpenOffice site wasn't loading for me, so I haven't gotten a chance to look at that yet.

**sideshow** · Joined: 04 Mar 2007 Posts: 138 Location: Glasgow

No probs. You might want to add a column for any info you are representing purely through formatting: for example, I think you are representing master tracks only by bolding them? If you have a column then it can be filtered the same as everything else.

You know you can select your table and then data->sort...? Sorting shouldn't be a chore!

The OpenOffice site is here.
_________________

**djcardshark** · Joined: 31 May 2007 Posts: 335 Location: NEPA

Good call, done and done. I also grabbed David Bowie and Cherry Bomb difficulties from hiddenzombie's thread (thanks, dude).

The only problem I see with OpenOffice is that I don't know how many people would actually download a program just to look at this thing. *shrugs* The option's there though.

**sideshow** · Joined: 04 Mar 2007 Posts: 138 Location: Glasgow

Well, that's up to them, isn't it

You can always do a Save As... and save as HTML. Excel's HTML is a horrific thing to behold, but it will display, just like the sheet does in excel, in any web browser. You will lose the autofilter, but hey.
_________________

**djcardshark** · Joined: 31 May 2007 Posts: 335 Location: NEPA

Man, I just keep learning. HTML page now available in addition to Excel sheet, which can do more, like the amazing filters.

**sunshine** · Joined: 03 Oct 2006 Posts: 1945

Didn't look at your Excel sheet (only the HTML one), but here's some confirmation/correction of your decades with stars beside them, according to the game:

Fortunate Son - 1970s
Moonage Daydream - 1970s
Roxanne - 1970s (yours says 80s)
Bang A Gong - 1970s
Queens of the Stone Age - all 2000s
Joker and the Thief - 2000s

**tdchewy** · Joined: 24 Jan 2007 Posts: 243 Location: Orlando, FL

**b08smith** · Joined: 18 Aug 2007 Posts: 1140 Location: Portsmouth, UK

great list, nice work

_________________

**Morik** · Joined: 16 Sep 2007 Posts: 274

How about a Legend? For instance, what do the different colors represent? What's the dif between bold and standard (OK, I know this already)...etc...
_________________

Morik

Women love HONESTY and INTEGRITY. If you can fake those, you're in! - Cosmo

Real guitars don't Click!!!

**djcardshark** · Joined: 31 May 2007 Posts: 335 Location: NEPA

**Sully** · Joined: 12 Nov 2006 Posts: 4570 Location: Tampa, FL

Great resource. Good work.

Vote for sticky.

**TehBanStick** · Joined: 06 Dec 2006 Posts: 2709

Sabbath DLC?
Now I have to decide whether to buy songs or the Halo 3 map pack.
_________________

Also known as Lord Zedd now
GH Customs | RB Customs | Youtube | Audition Mode Customs Guide

**Headbang** · Joined: 28 Sep 2007 Posts: 474

One was recorded in 1988, as you haven't got that on your HTML list

_________________

Justin Hawkins signed my butt.

**Pengwyns** · Joined: 08 May 2007 Posts: 311 Location: Gainesville, FL

Thank you so much. The spreadsheet is absolutely amazing. I will be referring to it very often. Thanks again.

I second Sticky.