Character Generating Spreadsheet

Since no one raised any problems, here's the link!

So, I've started playing Ars Magica again after a break, and I've wanted to learn to use spreadsheets properly, so I thought it would be a good learning experience to build a character generator in a spreadsheet. It's been fun, and it's gotten to the point where I quite like what I have, and I was wondering a) if anyone here would be interested in having a look at it, and b) if Atlas Games has a problem with me posting it online.

At the moment, all it includes is the main rulebook, and there are no descriptions of the Virtues, Flaws, Abilities and so forth - just the names to choose from, and calculations based on that. So I don't think there's a copyright issue or anything like that, but I don't want to step on toes or anything like that. Please let me know if there are any issues.

Also worth mentioning is that I make no promises of accuracy - I am learning as I go, and while I'm trying to catch any problems, I may have failed...

It's worth posting this over in the Ask Atlas section too (assuming you've not already done it).

And welcome back to Ars Magica.


I hadn't thought of that, I'll post there too. Thanks!

I'd like a copy, math not being my forte.. :slight_smile:

I'll hold off a little longer, in case anyone at Atlas has a problem - but if not, then sure! :slight_smile:

No one's posted an objection, so here's a link to my blog with the spreadsheet.

Enjoy, and please let me know what you think!

I'll edit the link into the first post too.

Updated to v1.1, with a more functional Grimoire sheet and several bugfixes.

(I do hope this is being some use to someone!)

Tried building Conscientia of Bonisagus (from MoH). Used Excel 97 (because that's the only version I have, old, but still works).
Seems to be missing Difficult Spontaneous Magic, and Affinity with Magic Theory. Otherwise, I "think" it was ok, but that's more excel than I like to use, so didn't try anything more.

Thanks for putting in the work, it looks hard.

Thanks for the feedback :slight_smile: It was tricky, but surprisingly fun!

Also, damn. Looks like I missed adding Difficult Spontaneous Magic, and Magic Theory from the list of available abilities for Virtues. I will add those to the bug list, should be easy to fix.

The sheet's updated to version 1.15: I've made a few bug fixes, and I strongly recommend getting the new version if anyone's using these - the printable sheet wasn't displaying all skills!
I've also added a Companion sheet - it's the same sheet without the Magus-only parts.

Downloads are at the link in the first post.


You can have MS Excel print only those Abilities the character has if you want. You don't need to print all skills (even if just as 0's). I find this particularly useful with Spell Mastery since some characters (Flawless Magic) will likely have over 20 versions of this Ability, while others will have few.

Edit: Speaking of Spell Mastery, I see you didn't list it among the Abilities, only with the spells. It does not seem that the points have been integrated properly with those of the rest of the Abilities.


Thanks for the feedback!

Now, as I test it, the character sheet doesn't print any abilities that are at 0 xp. However, I don't have Excel to test it in, I'm using LibreOffice - is it coming up with all the abilities for you? That would be problematic, as I don't think all the skills will display! The OpenDocument version only shows those abilities which have more than 0 xp in them.

Spell Mastery is something I haven's addressed at all yet; I confess it had pretty much slipped my mind that it's relevant at character generation. My next project for is going to be to make the Grimoire sheet more useful, and I'll include Spell Mastery skills in that update.

I use Excel. The empty Ability slot all show up as 0's instead of blanks. So there are lots of columns filled with 0's.

I will see what I can do about that. Excel viewer doesn't give that error, though, so I won't be able to find it until I get hold of a machine with Excel.

Are you using the most recent version of the spreadsheet?

I saw that behavior with the newest version of your spreadsheet on both the newest and the previous versions of MS Excel on the Mac.

Damn. Thanks for letting me know!

I guess I'll have to find a computer with Excel to give it a go on, and see what's up.

I don't see a way to calculate XP after early childhood and before apprenticeship separate from after apprenticeship.

Also, where do I put in the abilities worksheet how much XP I spent on Arts during apprenticeship?

Great job regardless, it's very useful!

What should happen (and does when I test it) is that it calculates your Magus' Later Life xp by subtracting 20 years from your age. So first 5 years = Childhood (5 years), then any Later Life (age - 20 years), then Apprenticeship (15 years). What it doesn't do yet is offer a way to add years after Apprenticeship - I will try to add that in in a later update, it's what the Magus column is for in theory. But that's complicated, as you can spend those points on spells as well as Abilities and Arts, and you can also spend that time on lab activities... I am trying to work out how I want to deal with that.

The amount spent on Arts... should be there but I see it is not. Damn. I will fix that in the next update!

Thank you very much for the feedback.

Well, I can confirm it works on the PC version of Excel 2007 for what that's worth. Sorry it's not working for you!

If you are interested in going to the effort... LibreOffice is free to use, and since it's what I use to make the sheets, that should work (though I'm using a PC, and have no Mac to test on, so no promises).

The childhood abilities doesn't show/work right for me (excel97). It has Carouse instead of Charm, and is missing Stealth, Survival and Swim. I also don't seem to be able to add any additional xp from the childhood allotment onto native language, but i'm not actually sure if that's a bug, or raw (I doubt it's something that would often arise).