Spreadsheet of Magic Items by Value Buffed, Type, and Cost


Pathfinder First Edition General Discussion


4 people marked this as a favorite.

I took some time in between gigs to create a spreadsheet of magic items organized by value buffed, with their cost, the the type and value of the buff.

Notes:

In all but 3-5 cases, I discarded items that only granted a permanent bonus in some situations. The goal was to have a list of items that granted bonuses to any character in any situation the roll/value it grants a bonus to could be used. There are a lot of items that grant pretty sweet bonuses that characters have to be of a specific build to use, are only usable in specific applications, or specific situations. They're not on this spreadsheet. If that seems dumb to you, copy the sheet, and add in the stuff I passed over.

The AC and Saves sheets are weird with price, as I entered prices based on the cost to upgrade the base item, instead of its total cost. The reason is that the spreadsheet started as a simple reference to look at the most cost-effective way to upgrade values as a character levels, and then turned into something more comprehensive. If that is bad-wrong for you, just copy it to your Drive and adjust it.

I also discriminated against buffs that were of a limited duration. Some things, like Fly Speed, you have to accept a limited duration, but I erred on the side of discarding temporary buffs for everything I could.

If you see an error (and I know I must have made some, because this was uninteresting work that took longer than I'd thought) post here and I'll fix it.


Nice. I'll add these:

Damage: Amulet of Mighty Fists
Feats: Quarterstaff of Entwined Serpents -> Eschew Materials
Feats: Perfectionist Shavtoosh -> Improved Unarmed Strike
Fly Speed: Ring of Seven Lovely Colors
Water Breathing: Bottle of Air
acrobatics: Boots of Striding and Springing
cha skills: Circlet of Persuasion
knowledge(any one at a time): Pathfinder's Chronicle
knowledge(local), Bluff, and Diplomacy: blue book
Diplomacy, Linguistics: Book of Letters
Attack: Headband of Ninjitsu -> +2 Insight for sneak attacks
Spelcasting: Ring of Eloquence -> allow V component in any form
Leadership: Suzerain Scepter
Leadership: Ring of the Ecclesiarch
Leadership: Imperial Army Greathelm
Leadership: Crown of Conquest

Also, check out Improving Your Class With Items.
You may find other guides have some good stuff.

/cevah


Found some errors:

miss chance: swirling smoke tattoo -- where is this?
resistance: shad'gorum nugget -- listed twice: should be neck slot
acrobatics: ring of unquenchable passions -- ring slot
disguise: mundane robe -- where is this?
disguise: ring of chameleon power -- competence bonus
spellcraft: armillary amulet -- missing

While you find the delta price convenient for comparison of the upgrade cost, it makes the pricing column fail to properly sort, since you need to have the N-1 item to get the N item. Perhaps the delta should be a separate column.

With all the skills having the same set of ioun stones, it might be better to treat the skills as a single page with additional columns for what skill is modified.

/cevah


Blade Of Three Fancies -- +4 sacred Perform(Select one when made)
Spear Of The Watchful Guardian -- a +2 insight bonus on Perception checks

/cevah


Thanks for the reply, and sorry to take so long getting back to you; work got in the way of working on the spreadsheet.

I went ahead and added a Leadership tab to the sheet based on your (excellent) suggestion. Thanks for all the new entries.

Cevah wrote:

Found some errors:

miss chance: swirling smoke tattoo -- where is this?

Blood of Shadows

Cevah wrote:

resistance: shad'gorum nugget -- listed twice: should be neck slot

The item says it's often used as a mace head or greatsword counterweight. If used that way, it'd have no slot, that's why I have it in there twice.

Cevah wrote:

acrobatics: ring of unquenchable passions -- ring slot

Fixed. Thanks.

Cevah wrote:

disguise: mundane robe -- where is this?

It showed up in Hero Lab when I was searching for bonuses, but it's not tagged with its book as everything outside CRB is. Neither pfsrd or aon seem to know anything about it, sorry.

Cevah wrote:

disguise: ring of chameleon power -- competence bonus

I have it as competence under Stealth, but its Disguise bonus comes from Disguise Self, and that grants an untyped bonus.

Cevah wrote:

spellcraft: armillary amulet -- missing

Nice. Hero Lab doesn't have this, for some reason. Thanks.

Cevah wrote:

While you find the delta price convenient for comparison of the upgrade cost, it makes the pricing column fail to properly sort, since you need to have the N-1 item to get the N item. Perhaps the delta should be a separate column.

You know, I totally see what you're saying, but I think I like it like this.

To me, this is a tool to find the best bang for your buck when trying to upgrade stats, and doing prices this way makes it obvious that for the cost of upgrading your armor to +3, you could get an insight or luck bonus to AC instead of just an armor bonus.

I do see your point, and the inconsistency of it has bugged me for a while, believe it or not. It's possible I'll make this change in the future, but right now, I'm focusing on combing through all the other sources of bonuses (races, spells, mundane gear, etc.).

Cevah wrote:

With all the skills having the same set of ioun stones, it might be better to treat the skills as a single page with additional columns for what skill is modified.

Yeah, it'd been simpler for me to set it up that way, but it'd be more work now to condense them all into one tab than to leave it. I'd had separate tabs for Crafts, Professions, Performances, and Knowledges, and it took me some time to concatenate those into one tab each. Besides, it's nice for people to be able to go to the tab for the skill they're interested in (at least I think it is, maybe it'd be more usable with fewer tabs).

Community / Forums / Pathfinder / Pathfinder First Edition / General Discussion / Spreadsheet of Magic Items by Value Buffed, Type, and Cost All Messageboards

Want to post a reply? Sign in.
Recent threads in General Discussion