Magic Item Crafting Calculator

[tricktroller]

Ok folks, I have been working on writing up a calculator to determine everything you need to know to craft items.

Currently I have scrolls, wands, and then any basic item listed with a base price written up in excel.

It will break down how much a hand of glory will cost by putting in its market price. It will tell you XP needed, materials cost and days to create.

I added in a line for having the feat extraordinary artisan from ECS for a character I am making. If anyone would like a copy of it please let me know and I will send you a copy, or if you want to help me with adding in the rest of the crafting bits and pieces and maybe make my table look a little prettier that would not go amiss.

[GutterFace]

does this calculator also include psionic items, potions as well?

[tricktroller]

Not yet. I am working on potions at the moment on it. Hadn't thought about psionic items. Is the method for crafting them very different?

[MesiDoomstalker]

You should make it calculate the estimated cost of a custom magic item. Just choose the category, the spell(s) you put into it, Caster Level and BLAMO! Price!

[tricktroller]

Haha I am working on doing exactly that eventually. Right now I am making it to where you can calculate custom wands, potions, and scrolls, including spots for expensive material components.

I would eventually like to make a tool that you can click and select drop downs for completely custom magic items but it would take pivot tables to do that probably and I have no idea how to use them yet.

[Lightlawbliss]

I wouldn't mind a copy when your done

[tricktroller]

Right now I have wands, scrolls, potions, and generic items. It will cover 99% of all things needed to be crafted. As long as you can find a base price the generic will be able to calculate it, the others are just for custom items, i.e., a 7th caster level wand of haste.

I am thinking about making the custom magic item one but that is a lot of work to do lol. Requires a bit more skill than I have but I did include the tables for items found in the SRD for all of that.

[GutterFace]

would it also take into account Feats that lower base cost or xp?

just a thought, you're doing a wonderful thing!

keep up the good work!

[tricktroller]

Lol I am learning a lot about excel at the same time. Nested IF statements ROUNDUP statements drop down cells etc etc.

This thing is starting to get some fancy touches now that I have the basic formulas down.

Nested if statements like=IF(C11=" "," ",(IF(C11=0,(((B11*0.5*750)*0.75)/2),(((B11*C11*750)*0.75))/2)))

This is the formula for crafting a wand with Extraordinary Artisan, that can handle 0 level spell with higher than 1 caster level.

You are welcome lmao.

[tricktroller]

Also I am working on adding in Extraordinary Artisan and Legendary Artisan. Maybe I'll even go nuts and have a combined one though you could just put it into both and get your cost from one and xp form the other :P since they no longer stack. Running into a few small issues with the formulas on some of the XP lines at the moment. Hope to resolve those before end of the day.

[tricktroller]

=IF(C17=" "," ",ROUNDDOWN((D17/0.75)*2)/25,0)

Anyone have any clue about excel mind telling me what the hell I am doing wrong here?

[Lightlawbliss]

C17 =/= D17 ?

or maby it is the fact your IF statement has 4 terms and should have 3

oh, and if u want, you could add something for simular and dissimular items

[Cicciograna]

I'd like to get a copy too.

[tricktroller]

c16 is spell level, if it is blank it is supposed to make everything blank, if it is 0 it calculates at .5 and if it is above zero it calculates as normal.

[tricktroller]

what do you mean similar dissimilar items?

[Lightlawbliss]

what do you mean similar dissimilar items?

look at dmg 282 "behind the curtain"

and the more I mess with it, the more certain I am that the prob is the 4 terms in the IF statement.

[tricktroller]

If you are referring to.the 0 at the end that is for the rounddown function.

[tricktroller]

I think I actually got it figured it out now.

=IF(D17=" "," ",ROUNDDOWN(IF(((D17*2)/25)<1,1,((D17*2)/25)),0))

lol took a little bit of work.

[tricktroller]

Ok, so the first portion of this calculator is done. If anyone wants a copy pm me your email.

I am working on a custom magic item calculator that will eventually be part of this calculator but I am working on it still. Lots of bugs.

If anyone sees any bugs in this one please let me know!

[Cicciograna]

If anyone wants a copy pm me your email.


May I suggest, instead, to load it on some hosting site a la Mediafire? This would be much more convenient, instead of a steady influx of email addresses.

[tricktroller]

Pffftttt yeah well ill possibly dp that tomorrow lol

[tricktroller]

ok hold on now some of my cells are freaking out. Ill upload it again in a bit.

[tricktroller]

Here is the link (http://www.mediafire.com/view/?2lw8rwaj1acw3hv) folks!

Enjoy!

[Metahuman1]

If it hasn't been brought up already I'd suggest making it so you can enter costs of flaws on items.

Has to have a certain alignment, a certain race, a certain class, so on.

[tricktroller]

lol That is way down the road. At the moment getting everything to work the way it is supposed to and look pretty is more important than adding in every single option :P But thank you for the suggestion I'm sure I will add it in later on.

[tricktroller]

making some serious progress on the custom calculator. figured out how to do charges per day in each equation.

[tricktroller]

Anyone have any thoughts on it so far?

[Lightlawbliss]

might be more versatile with just restricting the values of some of the cells to being number then have a drop down. and having one cell feed multiple lines might streamline the process.

[thompsja]

You may want to look at:

http://www.nzcomputers.net/heroforge/default35.asp

There's a magic item calculator and a number of other tools to help with the complexity of 3.5

[tricktroller]

I can't find their calculator on that page maybe you could link the correct link to it?

[Crazysaneman]

I'm working on one in C# myself, I'm having a particular problem getting scrolls to work properly though...

[tricktroller]

I have no clue about c# lol what's the line you are writing and what is it doing though?

[Lightlawbliss]

it's called magic item creator. 19 Aug 09

[thompsja]

You're looking for the "magic Item generator" changed 28 NOV 2010 or Magic Item Creator changed 20 NOV 2009

[Crazysaneman]

I have no clue about c# lol what's the line you are writing and what is it doing though?

I'm using visual studio 2010, and I'm having trouble getting the final cost variable to scale based on user selections in numericUpDown boxes.

[tricktroller]

That magic item generator is a random generator..... it makes 50 items at random from the dmg..... So not at all what I am talking about making. Thanks for the post though, that might come in useful next time I dm and need to make crap loot tables.

[tricktroller]

W00t! With some help from an excel forum I was able to get the calculations for similar/dissimilar items added in! Works like a champ now. go LARGE function.

[tricktroller]

found the one that is the actual crafting calculator. Its pretty spiffy. Its certainly fancier than mine is right now. However it has a few issues of its own.

[tricktroller]

Have updated all of my entries to be tables to look a bit fancier, and I am started to learn C++ so I can then program this in C++ or C#.

[tricktroller]

SO working with my DBadmin at work I was able to get Staves working like a champ. vlookup is an amazing function. I will upload the latest version of the calculator to mediafire later tonight probably.

[tricktroller]

http://www.mediafire.com/view/2lw8rwaj1acw3hv/Crafting_Calculator.xlsx

Here is the link again. Please let me know what you think. I fixed some of the issues I found with the other calculator so far. Their Staves page doesn't scale correctly based on XP or material components if the spell requires them. The custom item calculator is on here as well but it is not completed fully yet.

[tricktroller]

So much work done on this thing and so many new ways of doing things in excel learned. Due to life, my C++ learning is going on the backburner for the moment. Going to finish this thing in Excel since I only have to finish setting up my custom item calculator portion, though, in all honesty, it will be the hardest part of the calculator.

However, I must say this thing is getting to be pretty sexy.

[Geomancer]

If you complete this you will be a hero, good sir, it is fantastic. Custom Wondrous Items, however, have always been my Kryptonite.

[tricktroller]

I actually have incorporated the custom magic item calculator into the original document so it is all one piece now, but I haven't finished it yet. I have been too busy writing two books, 7 short stories, and a 1-20 Dnd campaign as well as being Daddy haha.

[tricktroller]

lmao, so I showed the custom item calculator and the item crafting calculator to one of our programmers and he told me to learn visual basic or C because it would be easier programming than what I was writing in Excel....

[Honjuden]

I would tack a small disclaimer onto the calculator noting that some items have multiple ways of getting the same price. For example a continuous item of Shield at CL 3 costs 12,000 via the Continuous Spell rules (1 spell level * 3 caster level * 2 minutes per level * 2000). This same item priced via the Other AC item rules would be 40,000 (4 AC ^2 * 2500) without including the protection from magic missiles and effectiveness against incorporeal creatures.

[tricktroller]

Which is why I broke the table into two types of functions for the first section; Spell effect, or general effect. Those break down into the different things you can do with each of those types. and then break down into a bonus list from 1 to 10 though I suppose I should make it out to 30 or something.

[bardliam]

Which is why I broke the table into two types of functions for the first section; Spell effect, or general effect. Those break down into the different things you can do with each of those types. and then break down into a bonus list from 1 to 10 though I suppose I should make it out to 30 or something.

This would be awesome, if I could figure out how to use it to make an item with multiple similar abilities (i.e. Belt of STR, DEX, and CON +4) As it is, I am very confused.

[tricktroller]

That is because it isn't done yet haha.

[The Grue]

Thanks for sharing this. I posted a thread over a year ago asking if such a utility existed and received zero replies - I'm pleased to finally have found one. :smallbiggrin:

[unseenmage]

Remember that Constructs are Magic Items too, and even for those DMs that don't buy into their dovetailing into the Magic item modification/creation rules they are still created with a unique subset of Magic Item Creation feats.

[tricktroller]

Oh well I will probably not add in constructs to this tool unless someone wants to modify it and repost it with that themselves.