Tuesday, 27 March 2012

Google Spreadsheets And Encounter Assignments

Recently I've been trying to put together online resource that I've generated or have found useful and I want to quick put together a small tutorial on how I've been using Google Spreadsheets to generate assignments and macro for me.

I'm going to assume a small level of understanding when it comes to using spreadsheets but I will make sure to outline stuff that maybe unclear for a typical user.

Let's take a look at my Heroic Madness of Deathwing spreadsheet:

I know it's a bit cramped, here is a direct link Heroic Madness of Deathwing Assignments

So, in Memoirs we have two feral tanks and only one outside major cooldown, Pain Suppression. For the purpose of each platform we take two impales where we need one major and a minor (barkskin) which we will always have up.

So what I needed was a macro that listed the cooldowns for the raid, enter this spreadsheet.

As you can see, the green area (which only I can edit sorry) can be edit and all the assignments will populate and generate my macro. So come next week if my off tank isn't there I will replace his name and cooldown with the third tanks cooldowns and the macro will pop out the end.


I am assuming people have a general idea of how to assign values to cells (ie: =B3 for the first tanks name). I, myself had to look up the macro text and how to assign a value mid sentence or text.


/raid P2: Darksend:  Survival Instincts  / Tova: Pain Surpression

is actuall:

="/raid P2: "&$B$12&": "&$C$12&" / "&$B$13&": "&$C$13&" "

The "&{cell}&" is how I was able to add the values in.

No comments:

Post a Comment