Bits excel d20 sheet

Bitom · Post subject: Bits excel d20 sheet Posted: Mon Jul 20, 2009 10:20 am

Since much of the site has started using these, I'm starting this thread for bug reporting:

Sheets are available at: brennor.dyndns.org/~bitom/Sheets/

For those familiar with excell, there are many rows and columns that will be hidden in the final version, but I've left them out in the open for the beta.

Bitom · Post subject: Re: Bits excell d20 sheet Posted: Mon Jul 20, 2009 10:24 am

Items in red have been addressed in Version 3 (unreleased)

Errors reported (Confirmed)

Knowledge Arcana not giving Synergy for Spellcraft skill

Suggestions under consideration for next version:

Expanded temporary attributes section (Anybody remember what this meant?)
Magic item tab (Tracks which item is in which slot, and supplies a place for magic item buying)
handling of Flurry of blows and Multishot
Place to represent energy/spell resistance
Hit die for classes
Trogdor's additions for psionics and spells
Printable sheet that looks as much like the WOTC sheets as possible
Add an instruction tab (To be deleted once player is familiar with the sheet)
lock auto-calculated cells

Bitom · Post subject: Re: Bits excell d20 sheet Posted: Tue Oct 27, 2009 3:30 pm

Update: I've started work on V3

So far, it includes:

Bugfix: Knowledge Arcana not giving Synergy for Spellcraft skill

Upgrade: Trogdor's additions for psionics and spontaneous spells
Upgrade: Hit Dice per class
Upgrade: BAB and Save autocalculation based on pattern

Vardaen · Post subject: Re: Bits excell d20 sheet Posted: Wed Oct 28, 2009 7:59 am

Expanded temporary attributes section (Anybody remember what this meant?)

I think that means a place for bonus just to Ref, or Fort, or Will saves, and not All Saves.

Two Weapon Fighting?

Bitom · Post subject: Re: Bits excell d20 sheet Posted: Wed Oct 28, 2009 4:09 pm

Vardaen wrote:

Expanded temporary attributes section (Anybody remember what this meant?)

I think that means a place for bonus just to Ref, or Fort, or Will saves, and not All Saves.

Nope... I know it had to do just with attributes (Plus I already put in separate saves last version)

Vardaen wrote:

Two Weapon Fighting?

Hm... I'll have to think about how I'd like to do this.

The only good thing I can think of involves dropdown lists and won't work in Google Docs.

Vardaen · Post subject: Re: Bits excell d20 sheet Posted: Thu Oct 29, 2009 8:03 am

Guess I don't have that sheet version.

Bitom · Post subject: Re: Bits excell d20 sheet Posted: Thu Oct 29, 2009 8:26 am

Yeah, looks like it was a late addition. Most of my chars don't have it, either, but it's there in the v2 sheet that I started with when I started on v3, so *shrug* It'll be there.

Brennor · Post subject: Re: Bits excel d20 sheet Posted: Thu Oct 29, 2009 9:04 am

I think that means that there was a separate version than what was in your sheet location. The sheets I've got also don't have the separate saves, either.

Is there some place to pick up a beta of v3?

Bitom · Post subject: Re: Bits excel d20 sheet Posted: Thu Oct 29, 2009 9:28 am

Well, V3 is nowhere near ready for beta, but since the features I've added seem to be working ok, I've made the current working version available at brennor.dyndns.org/~bitom/Sheets/

It's called D20CharSheetv3A1.xls even though it's not really an Alpha release, either. But nobody releases alphas anymore, so close enough.

Brennor · Post subject: Re: Bits excel d20 sheet Posted: Thu Oct 29, 2009 9:48 am

Cool, thanks. I wanted to see what Trogdor's psionic tracking sheet addition was like and also start playing with it. I was late to the party with the other sheet, but this time would like to be a little bit more involved with the testing.

Bitom · Post subject: Re: Bits excel d20 sheet Posted: Thu Oct 29, 2009 10:00 am

Well, I'll warn you that the tracking sheet at the moment only covers daily use. No changes have been made to the mostly non-existant means of recording the psionic powers you have access to.

Bitom · Post subject: Re: Bits excel d20 sheet Posted: Fri Nov 06, 2009 12:32 pm

A new alpha is up on my share at brennor.dyndns.org/~bitom/Sheets/

This one has the much-requested handling of flurry, greater flurry, rapid shot, many shot, and all the two-weapon fighting variations.

Please beat on this one to make sure I got the calculations right.