Contains:
Bronze -> Obsidian Level Requirements
EXP Gained Per Bar
Required Bars Per Item
Required Wood Per Item
Cost Calculations(Buying bars, selling items)
EXP/Bar Per Item
EXP/GP Per Item
NPC prices for Bronze->Gold (As above sells for 0 to NPC).

For prices above Syriet you will have to enter your own, or if I get the requests I can grab them from Evert's price list.


Accessing it:
Hosted on Google Docs for ease of access on any machine:

Full URL: https://docs.google.com/spreadsheet/ccc?key=0AlyLt2JXN-kldHFHSGdGWFlFZjAtcHpKTy00dXVMNHc

Shortened URL: http://goo.gl/WQ9xJ

For those that do not know Google Docs that well, remember that to change to another sheet(another ore) just hit the buttons at the bottom left of your screen.

General Background Info:
I made this as I am currently smithing and wanted all the information easily accessible on one page. I also wanted to work out the EXP/bar and EXP/gp to get my best money's worth.

Credits:
Me - For having 3 hours to spare
TL - For the information on their wonderful website(Level req's, XP, NPC price)
Evert - Price list on the Market forum(Bar prices)

Suggestions, gripes, errors? Whisper, message, or post here.

Thanks.

Edited on 22-04-2012 15:44

Thanks, this'll come in handy when I bring myself to go back to smithing.

Makeshift I <3 you for this, I hate trying to work it all out with pen and paper!

Thanks a ton
This needs to be stickied.

Stick Please!

Very nice and handy, agreed should be stickied.

Stickied please ;)

sticky it

I'm not all the familiar with google docs. Is there a way I can copy your spreadsheet either onto excel or edit it to have totals for each set?

awesome job MS, perfect for new smiths

I love it Well done, and thank you for taking the time to create it

The xp for iron small shields is incorrect. The manual was incorrect and was fixed. You should change the xp from 6 to 5

@Prome - Thanks Prome, that's been updated.

@kagiscon - You can download your own copy by pressing file up the top left, then clicking Download As -> Excel. Though if you can explain your idea more I could probably add it if you like.

I figured it out and added it to my own copy, thanks My change was just to add a "Total" row at the bottom of each set. That way you know how much a full set of everything costs, will gain you in exp, etc. It wouldn't be all that helpful unless, like me, you wanted full sets of bronze/iron to help clannies get started or after deaths.

The link leads me to a login page. Does everyone except me have a Google account or is something not working right?

Great job on your spreadsheet for smithing. It makes it very convenient to have everything in one place. In the silver section though, I noticed an error for the pickaxe total cost. It should be the same as the hatchet, 13 gold.

22ducky22: I'm not sure, I can still access it whether logged in or not. I just pushed an update, try now?

Kordon: Thanks for pointing that out, seems I put a * instead of a +, fixed

It still leads me to the same login page. In the privacy options, is the radio button that says "let people view without signing in" checked?

Edit: I think I found the problem. I normally reject all cookies unless there's a good reason to have them. When I tested the link with my alternate browser (which is configured to accept everything), I was able to view the document. I didn't see a link to download the document, though.

Edited on 26-09-2011 03:56

Fail > Silver med helms are 8 not 25, Lost around 50K D:

o.O, my local copy doesn't say 25, it says 8. I swear I didn't put that as 25. I generally quadruple-check anything that's green. Sorry Blue

Gold prices?

TL prices say 25gp each Xanger and Shifty, I also frowned on that before:
http://tlgrounds.com/index.php?p=item&id=70

I haven't updated this yet - Having trouble with my Google accounts, working on it.

Added gold NPC prices.

Please check the cost of bars and wood before you set to do anything! They may not be up to date with current markets. Please also CHECK the math, errors have been found before.

Also, those not able to see it before (Issues with Google accounts) should now be able to see it.

Fixed an error on ALL sheets where there was a * instead of + for pickaxes, because I fail at checking for errors before copypasta. The spreadsheet has been updated, please update your local copies to reflect the change to avoid future issues
(Thanks Kagiscon)

Edited on 25-04-2012 17:40

i think mine should be added here

https://docs.google.com/spreadsheet/ccc?key=0AjjaGNHLmZ0VdDB2bzRVM3dCX0tucWk2bVltSVVpeVE#gid=0

Edited on 09-07-2013 03:29

Edited on 09-07-2013 03:29

So which is better? Makeshift's or typo's?

Even though it tastes like ashes in my mouth, I must admit that I like that Typo's shows the experience for smithing multiple items.

I wish their was a spreadsheet that would show the combined experience from smelting and smithing and number of ores needed to gain a level.

EX: If I have x experience and want level x than I need to smelt x number of bars and smith x Cauldrons, or smelt x bars and smith x medium shields and so on.

It would make smithing experience much easier to figure out for us lazy people.

Oh yes, I'd love that one Drago.

But for now, awesome spreadsheets, Make & typo.

I might take a look at updating mine and adding new features in a few days, gotta finish off some work first though

Well since everyone else is doing, I made the Wino version of a smithing spreadsheet Missing a few items for Syriet and Obbi and I have no info on Puranium, since that seems to be a big secret or something. Anyways, let me know what you think and message me if you find any errors. Cheers.

http://tinyurl.com/l5kf9ll

Also,it only works up to level 100. That's as far as I know the experience required per level.

Edited on 12-07-2013 06:35

I would add my information on smithing, gathered by myself and clannies, however I despise the act of smithing so I will have to abstain.

What would be nice if you guys could make a spread sheet that adds the total ore you have then from that it figures out how many of each you have in bars and tools and it figures out what you need to get to the next level in bars and tools and it also adds the exp needed to get to the next level after you are done making bars.

dragosani's spreadsheet copy

https://docs.google.com/spreadsheet/ccc?key=0AjjaGNHLmZ0VdEVhaktpOGpoWWtKUFpGbWFxemN1dlE#gid=0

my spreadsheet

https://docs.google.com/spreadsheet/ccc?key=0AjjaGNHLmZ0VdDB2bzRVM3dCX0tucWk2bVltSVVpeVE#gid=0

Bump