PDA

View Full Version : Auto Calculating Excel D&D 3.5 (Pathfinder mainly) Character sheet



Myrik
2015-07-02, 11:39 AM
Hello fellow gamers.

I have posted this sheet link a few times in various places, but this is a much newer version, with an instruction tab included, since the sheet is a little complicated at first glance.

Some details:
This sheet is designed for touch screens and set up for a 1080 screen size. It can be used on a standard laptop w/ pad or mouse.

It does not have a class or archetype or feat database.

It is designed to AUTO CALCULATE all rolls, and does so very well. It uses a simple macro that manually operates the " calculate " function in excel. You must set, under the formla tab in excel, to manual calculation.

Basically, you fill in a quick and simple data tab and a few other details on the character sheet and then use check boxes to apply modifiers and feats like power attack and so on, then use clickable buttons to activate calculations.

So, if you use tablets and or laptops to game, this is the sheet you may have been looking for. Check it out and let me know what you think!

Google drive download link (https://drive.google.com/folderview?id=0BzPPLvYQtQDGfmJCNm05T1drTEVna2ZGYnJ kaFY1M2daQWx6MGJ1bzl6Z0NZM2tDbjRUcWM&usp=sharing)

Myrik
2015-07-02, 01:17 PM
FYI, if you check out the sheet and have any questions, feel free to ask, I will do my best to answer quickly.

Myrik
2015-07-16, 02:54 PM
Small update made. The "Calculate All" button used to just calculate the entire sheet, updating all modifers and rolling. Now, it just updates all static numbers and modifiers without rolling, so you can add or remove modifiers and make changes without also having to roll.

The Random NPC
2015-07-16, 07:42 PM
Here's the one I use (https://docs.google.com/spreadsheets/d/1gxq3QWfzVUT61BJJhiCcq92ZMu_fxXh65_YwAqqjZCQ/edit?usp=sharing), maybe you can poach some ideas from it.