next »

[Raybras]

yeah i downloaded it, trying it out.

EDIT 1: when using the point buy system, it doesnt take into account the 10s. it counts it as a 9.

[Sphynx]

1) Brain Fart: On your sheet you can change the 2 occurences +COUNTIF's on that cell into -COUNTIF's.  I've changed it on the future 2.0 sheet for when this baby is finished.  Thanks for the headsup.

[Lost In Thyme]

1) Brain Fart: On your sheet you can change the 2 occurences +COUNTIF's on that cell into -COUNTIF's.  I've changed it on the future 2.0 sheet for when this baby is finished.  Thanks for the headsup.

I've downloaded the sheets, trying to use them to build a Shadow that has Use of Ki, can't seem to find out how to do that.

edit: It should be noted that I am using Open Office 3.2.1

[Sphynx]

Assuming he has the Martial Knowledge to learn it (the advantage !artial Mastery may be needed), go to the 3rd tab, Equipment-n-Supernatural (Green tabs are for building, others are for printing things out), add it, then go to Ki and Martial Arts if you want it in a printout.

[Raybras]

in the Database Tab, G514 to G524 have an Error in the formula. i fixed it for myself, just thought i'd let you know.

this is what it looks like before
=COUNTIF($Printout.$B$16:$B$26;#REF!)*B516)
here's how it should look like
=COUNTIF($Printout.$B$16:$B$26;A516)*B516

i took off the parenthesis at the end of the formula, it was causing errors for me in oppenoffice, don't know if it does it for excel.


EDIT 1: there's also a problem with BP Expenditures. i tried to fix it but it's not working.
in CharacterBuilder, the slots 20 23 and 26 for each level, it shows N/A when that level is attained.

EDIT 2: i fixed the problem for row 20
the formula in row 22 is something like this
=IF(D13>0;D12*INDEX($Database.$A$1:$Z$132;MATCH("Combat Percentage";$Database.$A$1:$A$132);MATCH(D13;$Database.$A$1:$Z$1))/100;0)
whereas i did this
=IF(D13>0;D12*INDEX($Database.$A$1:$Z$132;MATCH("Combat Percentage";$Database.$A$1:$A$132;0);MATCH(D13;$Database.$A$1:$Z$1;0))/100;0)

[Sphynx]

Ok, fixed the Database problem for the next release.  Not sure why OpenOffice added a ) at the end, but that does not exist in my version of the formulas.  And just to make sure all is right... just an FYI, that B516 should match the row all the way down (so B516 only on the 516th line).  I assume you mean as much, just wanted to make sure.

As for the other problem with CharacterBuilder, excel doesn't require the use of the tertiary variable within Match, and that index(match/match) is the core of the sheet, meaning hundreds of changes (with a great chance that some are just missed)...  I don't mind going through and changing them all if I can find them all, but it will be a helluva task to do.

[Sphynx]

Ok, my first day back and I've started making characters with the sheet to debug it, and WOW... lotsa brokedness!  Ok, skills should work now, the Ki Abilities mentioned, fixed so the next release will let you have some sort of Ki Abilities at 1st level.    All sorts of other things fixed as I've now finished making 2 characters on the sheets and discovered a tonage of non-working.

FYI, the layout for the Supernatural and Equipment will be changing drastically as I make it so you can spend all your points (Psychic Points as well as Magic Levels for Schools or Specific Spells).  But I might wait til 2.01 to do that... so you guys can have an actually-works sheet to play with.    You can expect a release tomorrow of 2.0 if all goes well.

[pyroprogramer]

found a small bug, everyone loves ( )
=IF(G3="Rolled";"";CONCATENATE("Remaining: ";G4-SUM(E5:E8;G5:G8)+COUNTIF(E5:E8;">=10")+COUNTIF(G5:G8;">=10")))
needs to be
=IF(G3="Rolled";"";CONCATENATE("Remaining: ";G4-(SUM(E5:E8;G5:G8)+COUNTIF(E5:E8;">=10")+COUNTIF(G5:G8;">=10"))))
for d3 on the charcater builder, otherwise, 10 is free
as I missed the post that you said that...
Other then that, its looking better and better from the last time I looked at this, Great JOB!

EDIT:
found another
Database G514-5-24 has $REF

[BlacPhoenix]

As this has seemingly been on-hold for 3 month now... whats the current state?
The first version we got was "working" but what about the updates and the stuff missing?

Made any progress so far thats worth it being posted about ^^?

[Dynaes]

I spoke to Sphynx and I don't believe he's working on this at all as his group is not playing Anima right now.  That said, I've picked it up and started fixing some bugs and adding some additional functionality (primarily working on adding Dominus Exxet into it at the moment).  I'm in the middle of revamping Martial Arts to include the multiple levels in DE, and that will hopefully be done shortly.  Once I've finished the major revamps I will post a link to the sheet and any of you who are interested can playtest it. 

I probably couldn't have come up with the bare-bones neccesitites for this sheet on my own, but I'm having a lot of success with updating/tweaking it. Thanks to Sphynx for laying the groundwork to a really great sheet.  I take no credit for most of what will be in the sheet that I release.  I did "Americanize" it with regards to Armor vs Armour and BP vs DP.  None of that should bother anyone too much, I trust.

[Perago]

Could someone e-mail me this sheet, or link the most up to date one to download please?

[Dynaes]

I can send you the most recent one when I get home from work this evening.

[Tarrant12]

I'd love the new sheet too, I've used one that I built for a while but it still requires a lot of hand filled stuff since I gave up on it lol. Still great for spending DP, interested in seeing how you've progressed with the sheet.

[Dynaes]

Arikail made some major progress on it before it came into my hands, so I've mostly been cleaning up little things.  I know there lots of little tweaks needed here and there.  I am working on getting it hosted on my site (first time having a personal site since my angelfire days, so figuring out how to get it working as I'd like).  As soon as I get that figured out, it will be available at files.dynaesdarksbane.com.

If you do download and use it, please note any bugs or issues in this thread, and I'll work on cleanup.  At the moment, I know Opposite magic is not calculating correctly when you take the advantage.  That's my next order of business when I have a few minutes to sit down and play with it.

EDIT: files.dynaesdarksbane.com should be up and running.  Download it and play as you wish!

[Sphynx]

Hey guys... I'm back.  Our GM got tired of Anima after a bit and we were playing L5R, but we've all been pushing him to do Anima again, and he gave in.    So... will take a look-see at the new sheet.  Thanks to the guys who didn't let the sheet die in my absence. 

Looking forward to playing a new character, and we get to start at 800DP, so not having to start all over from scratch again.