Take the 2-minute tour ×
Arqade is a question and answer site for passionate videogamers on all platforms. It's 100% free, no registration required.

The Questions

  1. What are my character's derived stats? (regen time etc)
  2. What will each magicka and destruction enchanting effect do to my overall character?
  3. How is my damage output affected by choosing different spells?
  4. How does cast speed effect my damage? (very important at -100% cost)
  5. What is my effective spell cost after perks, equipment and skills?

Soon after I started playing Skyrim I wondered whether it was more efficient to get more magicka or more magicka regen.

How should I balance them? Ahhhhh

I then started delving more deeply into it, and started also considering issues like sustainable damage output (from regen) vs. high initial damage output (from a large magicka pool). I also was no way near being able to enchant -100% cost equipment, and so I still had a major trade-off to decide on.

Higher ranked Spells get more magicka inefficient. I then had to try and see how much additional DPS that extra cost was worth, and how it effects my sustainable effectiveness.

Choices, choices and choices.

I attempted to answer these questions. In the spirit of sharing useful information, I have uploaded my spreadsheet where you can see how your own character is doing - what her vitals are!

And dispelling myths over destruction: DPS with Thunderbolt is ~187/s, at range - not too bad, eh?

share|improve this question
    
@sjohnston thanks for "effect" to "affect". I never get it right :) –  Anon Dec 18 '11 at 16:32
    
Simple rule of thumb: Affect verb, Effect noun. The exceptions are for the most part weird enough that you'll never screw it up unless you're a psychologist. –  LessPop_MoreFizz Dec 18 '11 at 17:04
1  
A person can affect an effect. If you can remember that sentence, the words in question have to be in alphabetical order for the sentence to make sense. –  Gumbz Dec 19 '11 at 12:11
    
effect is also a verb meaning "cause to be", but it isn't common. The verb effect goes beyond mere influence; it refers to actual achievement of a final result: "the new administration hopes to effect a peace settlement." merriam-webster.com/dictionary/effect –  flies Jul 8 '13 at 20:17

1 Answer 1

up vote 27 down vote accepted
+150

Edit: various rebalances in patches since the below was posted (such as a particular spell's damage per cast) has made it inaccurate. I am afraid, therefore, that it seems that the author of the spreadsheet has taken down the link.

A Solution

I developed a basic spreadsheet that allows you to find out all the above questions, and more. V1 provides a full workup of magicka and all related enchanting effects, and provides detailed damage info for destruction spells.

A better VBA model I was 30% through is on hold while I enjoy a DLC to my favourite game :D

An basic example with my current mage: Magistra Circe

enter image description here

Mirror 1: SkyrimNexus

EDIT: the sheet is locked to prevent accidental deletion of a formula. You can unlock it (no password) under the "Review" Tab (in Excel).

share|improve this answer
4  
...VBA? Are you... sure? That thing's my nightmare fuel. On Error Resume Next nightmare. –  badp Dec 18 '11 at 16:11
    
Yep :D. I wasted the time I had on silly things like trying to ensure the UI was soft-coded. I also had a hellish time dealing with VB6, as I am used to VB.NET –  Anon Dec 18 '11 at 16:19
    
and as someone who just occasionally knocks out a few lines of code for fun I don't have the discipline of a pro, and I fell foul of feature creep. 300 lines of VBA trying to be flexible to make the final functionality easy to implement. Zero end-user functionality...whoops!! :D –  Anon Dec 18 '11 at 16:29
1  
Eh. I'm hardly a pro ;) Don't listen to me, just do what you like to do, then learn Python and look back in shame :P –  badp Dec 18 '11 at 16:43
    
the link says the file has been hidden by the author. I looked into registering to see if that'd help, but I'd have to pay for that (just 1 GBP but still). –  flies Jul 8 '13 at 20:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.