DragonAge_Forge

[Sync]

...no...I didn't think about that. I suppose I was thinking of this more in terms of it being an automated record keeper and letting the player do the rolling. In a way, having Excel do the rolling takes away from the Bell Curve that comes of rolling dice - or at least it feels that way, to me.

I guess I could think about making a version that allows for a button push and dice rolls are made for you. That would be a way down the track, though. Maybe when Set 3/4 comes out...I might incorporate dice rolling into the version that will inspire. I'm sure I'll need to pick up my socks for the Excel programming side of things at that point.

Thanks for the positive comments so far, too.

[solaris]

Haven't done more than 1st level but the spreadsheet is awesome! This will really help with NPC generation and I have a couple of players that will also use it for thier characters. Great job

I like how you kept the actual dice rolling as input.

[Admiral Yacob]

...no...I didn't think about that. I suppose I was thinking of this more in terms of it being an automated record keeper and letting the player do the rolling. In a way, having Excel do the rolling takes away from the Bell Curve that comes of rolling dice - or at least it feels that way, to me.

I guess I could think about making a version that allows for a button push and dice rolls are made for you. That would be a way down the track, though. Maybe when Set 3/4 comes out...I might incorporate dice rolling into the version that will inspire. I'm sure I'll need to pick up my socks for the Excel programming side of things at that point.

Thanks for the positive comments so far, too.

If you need help when it comes to that, let me know. I've created multiple dice rolling programs and random character generators over the years. In Excel, to roll a single d6 all you need to do is =INT(6*RAND())+1 on most versions, though on the latest you can use =RANDBETWEEN(1,6).

As mentioned though, I love the sheet and cannot wait to see what other ideas you come up with as you keep working with it.

[Loswaith]

One note I found while looking it over is you may want to move the weapon group selection to the Working page rather than on the Weapons/Armament (I think is where it is), and then taking a copy of the selections over to the curret page.

As for when selecting talents it wasnt initially obvious that there was missing weapon talents due to not having chosen the weapon groups needed for them.

Other wise looks good.

[Sync]

One note I found while looking it over is you may want to move the weapon group selection to the Working page rather than on the Weapons/Armament (I think is where it is), and then taking a copy of the selections over to the curret page.

As for when selecting talents it wasnt initially obvious that there was missing weapon talents due to not having chosen the weapon groups needed for them.

Other wise looks good.

Hmmm... I'll think about that when the major update comes through.

The Workspace tab is left the way it is currently for when Set 3/4 comes out and I have to make room for an extra 10 levels of attribute calculations. :-/

But, yeah, the Weapons tab started out in its own tab because I initially thought there would be a truckload of work to do...and discovered later that there wasn't as much, and by that point didn't really want to move it. I can probably condense a few things, and I'll consider that when Set 3/4 arrives.

Regarding Talents:
* I tried to have the sheet tell you what you DO qualify for, not what you might qualify for if you change your selections a little. If I did the latter, there'd be all sorts of chaos at the end product (output sheets) when they started showing things you shouldn't have. >.>
* The Talents tab has all the talents and their requirements listed for easy reading.

At the same time, though...I've tried to do a balancing act between keeping it simple & accurate for players who are likely to want the sheet to do most things for them (or make it really easy, at least) vs protecting Green Ronin's licences and property. I hope I succeeded.


//EDIT: added an extra thought on talents.

[Admiral Yacob]

I think I may have found something (or I'm doing something wrong). Here's what I did:
Background: High-born Dwarf
Class: Warrior
Current Level: 4
Chose Strength to be my primary attribute raise for levels 2 and 4, also started with a 3 base and 1 from background. It took me straight to a 6 in Strength instead of going with a half (which it accurately beyond a 6 in the stat). Since you are supposed to move to 2-per-stat when trying to reach a 6, this seems like it might be a minor issue.

[Sync]

Hmmm...

*looks up Set 2 Player's Guide PDF - text page 34 and table page 35*

For abilities up to 5, it costs a single advancement. For abilities from 6 to 8, it costs two advancements. For abilities from 9 to 12, it costs three advancements.

Could go either way, as the book doesn't specifically mention how you get from 5 to 6, and from 8 to 9. When you're below 5, it's easy; when you're on 6, it's easy.

I chose to implement the second part of the statement: the "From..." part. So, when your attribute hits 6, you're on 2 advancements. Below 6, you're on single advancements.

This may be something the GR writers want to clarify for the print run (or make an errata if it's too late to beat the run). *heads to typos thread*

[Admiral Yacob]

Yup, I see where it could go either way, except the example is what clarified it for me. Specifically the part in quotes below (on pages 34-35 of the Players Guide)

"...He wants to raise his Magic, which is currently 5. It takes two advancements to raise his Magic to 6, so Lorrahn spends one now to start the process..."

[Elfie]

I agree that it's already pretty clear as written, but the table on page 35 makes it even more clear by using the heading "New Ability Rating" indicating that to gain level 6, you need 2 advancements and to gain level 9, you need 3.

[Sync]

Okay, not a huge problem to fix.

(Can't believe you guys are complaining about getting higher attributes more quickly. )

[Sync]

New version 1.10 uploaded and the link added to the OP of this thread.

V 1.10 Contains:
* corrections to attribute calculations, as above
* an additional comment regarding talent selections
* version history tab

[solaris]

Only 1 minor addition I would recommend for next update. The character sheet tab has the defense adjusted for use with shield and it's great but could you add a space for defense without shield.

[Scion of Haven]

Now that I've had some time to play around with it and figure out where everything is, I'm really enjoying the program. There have been no bugs or problems so far, and if I could make one suggestion about user-friendliness, it would be that it's hard to notice the specialization selection drop-down menu, since it's not labelled "CHOOSE" like the other drop-down menus, and it doesn't have a tab until you click on the (blank) box in the "level 6" space for the talent selection column. There's also a minor typographical quirk that bothered me, though I don't think it qualifies as a "typo". If you make a dwarf duster, despite the fact that you don't choose a caste (the caste bars are empty), there are still empty parentheses on the character sheet where a caste should go in the "backgrounds" box.

[Sync]

I've made the suggested changes from the pervious two posts, as well as adding a few extra cosmetic changes & enhancements.

I'll not upload at this time as people have already downloaded my last version change from yesterday; I'll hold off for content changes and/or bugfixes...unless you really want me to upload the new version.

[CinderellaManJJ]

First off, Sync, great job on this character sheet. I love it. I loved it so much I posted about it over at the Dragon Age Oracle blog. Go check it out. I look forward to seeing how this character sheet grows and changes as more of the community uses it.

Regards,
JJ

[Sync]

First off, Sync, great job on this character sheet. I love it. I loved it so much I posted about it over at the Dragon Age Oracle blog. Go check it out. I look forward to seeing how this character sheet grows and changes as more of the community uses it.

Regards,
JJ

Gosh...thanks... *blushes*

That's a more generous review than I thought it might have warranted...but thank you.

( // EDIT: ...but your sample characters all link to the same one - Gorim. )

I started to include the effects of superior materials fromthe Set 2 GM guide...then realised I'd first have to figure out how to get around the circular problem that would be induced. So they'll be included, but likely not immediately.

And I think I've realised, in considering the above problem, that I've got another potential flaw (likely only minor, but still... ) in my sheet...I'll have to check it out. Maybe I'll get to release a new version shortly after all.

[Sync]

Well...I think I talked myself into it.

Version 1.15 is uploaded, and a new link posted in the OP of this thread.

There are no mechanical changes in this version, but there are a good number of cosmetic changes (like COLOUR...! ) which will, hopefully, increase the user-friendliness of the 'Forge.

For future versions I will be trying to figure out how to implement the Improved Materials section of the Set 2 GM's guide - because so far I see it getting bogged down in an ugly circle of attribute-checking...

[CinderellaManJJ]

( // EDIT: ...but your sample characters all link to the same one - Gorim. )

Yes, that is an editorial issue that should be addressed soon. For now, if you look in the comments you'll see the three links so you can see the output for all three characters.

Plus it's your passion to continue to improve the sheet that I really love. Even minor things don't bug me because I'm confident you'll work through them.

Again, great job.

[MacGrein]

Great Job on this Forge!
So much useful!
As the DAOracle review, it's fastened the PC creation, really.

I've got only one problem, but I don't know if it's really a problem.

I've created an Apostate elf Mage and he got 3 starting spells, but I could select more than this on the Spell tab.
Aside that, everything is fine!

Thanks for the creativity and effort!

[raskal]

i would like translate the (excellent) excel file in french but most of cells are locked. So is it possible to get the file unlocked for translating it ?

[solaris]

I downloaded the newest version 1.5 and when i get choose a focus it displays a number not the name of the focus. this also translate to the character sheet it list a number. don't know if this is an error in the formula or if it is my version of excel acting up.

[Sync]

Great Job on this Forge!
So much useful!
As the DAOracle review, it's fastened the PC creation, really.

I've got only one problem, but I don't know if it's really a problem.

I've created an Apostate elf Mage and he got 3 starting spells, but I could select more than this on the Spell tab.
Aside that, everything is fine!

Thanks for the creativity and effort!

Thanks, and you're welcome.

Well...I did say that some thought on the part of the player was required.

I'll have a look and see what's going on. That shouldn't be too hard to fix up and make sure that only the right number of spells are added to the output sheets.

i would like translate the (excellent) excel file in french but most of cells are locked. So is it possible to get the file unlocked for translating it ?

Hmmm... *thinks* I'll PM you privately with a link for the unlocked version.

I downloaded the newest version 1.5 and when i get choose a focus it displays a number not the name of the focus. this also translate to the character sheet it list a number. don't know if this is an error in the formula or if it is my version of excel acting up.

Ummm...it may be that a couple of lookup formulas got messed up when I added that extra feature. I'll check it out.

[Sync]

Version 1.16 uploaded and the link added to the OP:

* Fixed the broken Focus selection.
* Added a counter to warn when too many spells are chosen (that was easier than adding an extra level into the lookup formula for every spell-related cell in CharSheet2 )

[Sync]

Side note:

A friend of mine tried using the 'Forge (v 1.16) in Open Office.

Let's say that his results were interesting, and not consistent with the same results gained from making the same choices in Excel.

Not sure why Open Office didn't give the correct results when the formulas were all correct...

[CinderellaManJJ]

Not sure why Open Office didn't give the correct results when the formulas were all correct...

Could be that the formula syntax is just a little bit off. If you use any macros or VBA I doubt it translates well to the Google docs.