Syrnia the free online RPG game
Home
Game Tour
News
Forum
Manual
Highscore


Forum -> Help -> Full Smithing Calculations Spreadsheet

Only users can reply.


Pages: 1- 2

Makeshift
[Choob]
21-06-2011 17:55



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

Moderator edit:
This spreadsheet appears to be considerably out of date as far as values are concerned, this thread needs a new Author

Please contact the Forum Department if you can run this successfully and keep it up to date, Thank You

Makeshift[Choob]: I'm on a roll! Two days in world and not even a warning :D
(Mod)Moderator: Awards Makeshift a 2 Day Trophy!

[W]14:56 DeSoRDoR[Snake]: Shoop da whoop is stup- BLLAAAARRGHGH!~!!
Mr. Addy
Keeping this game free by adding ads to every topic
Joh
[~TLO~]
21-06-2011 18:25



Thanks, this'll come in handy when I bring myself to go back to smithing.
Thorntree
[Choob]
22-06-2011 03:06



Makeshift I <3 you for this, I hate trying to work it all out with pen and paper!
Proud member of [Choob]

Hotdog killed you at Desert arena 3 :-D
Dreamz of Her
[~Free]
22-06-2011 03:50


Thanks a ton
This needs to be stickied.
Evert
[Pond]
22-06-2011 13:13



Very nice and handy, agreed should be stickied.
R.I.P Anubis 6th February 2011 - Gone but never forgotten.
kagiscon
[]BoS[]
23-06-2011 19:11



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?
King Albatross
[Cyber]
23-06-2011 19:48



awesome job MS, perfect for new smiths
-Innovate, not Imitate-

Light a match, blow it out and then look at what you're doing here.

Alla gillar brudar


[2]21:03 Shinobi[-TL-]: Beard-wise you want a goatee or a full kozmik
Makeshift
[Choob]
24-06-2011 13:47



@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.
Makeshift[Choob]: I'm on a roll! Two days in world and not even a warning :D
(Mod)Moderator: Awards Makeshift a 2 Day Trophy!

[W]14:56 DeSoRDoR[Snake]: Shoop da whoop is stup- BLLAAAARRGHGH!~!!
kagiscon
[]BoS[]
24-06-2011 19:10



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.
22ducky22
[=SoA=]
24-09-2011 04:49


The link leads me to a login page. Does everyone except me have a Google account or is something not working right?
Kordon
[Seek]
24-09-2011 08:51



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.
"I think the biggest problem in the world is that we have a generation of young people, and maybe two, who don't think it's going to get any better." - John Denver
Makeshift
[Choob]
24-09-2011 13:05



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
Makeshift[Choob]: I'm on a roll! Two days in world and not even a warning :D
(Mod)Moderator: Awards Makeshift a 2 Day Trophy!

[W]14:56 DeSoRDoR[Snake]: Shoop da whoop is stup- BLLAAAARRGHGH!~!!
22ducky22
[=SoA=]
26-09-2011 03:48


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
Tike
[1-Sec]
11-10-2011 15:38


Fail > Silver med helms are 8 not 25, Lost around 50K D:
Makeshift
[Choob]
11-10-2011 19:36



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
Makeshift[Choob]: I'm on a roll! Two days in world and not even a warning :D
(Mod)Moderator: Awards Makeshift a 2 Day Trophy!

[W]14:56 DeSoRDoR[Snake]: Shoop da whoop is stup- BLLAAAARRGHGH!~!!
Treize
[AFK]
06-02-2012 16:24



Gold prices?
16-09-2011. You have auctioned 53k seeds, beet to pumpkin!

01-09-2011. You have opened 100 Small chests! 29% cash, 15% grain seeds, 14% corn seeds, 13% moonie, 12% tomato seeds, 9% strawberry seeds, 8% avril.
Slow
[Choob]
06-02-2012 16:38



TL prices say 25gp each Xanger and Shifty, I also frowned on that before:
http://tlgrounds.com/index.php?p=item&id=70
21:10 CaptainSlow[Choob]: Why don't the ogres invade somewhere like.... Ogre caves...
[0]21:10 The Ogres have been tricked! "Goldies" storm Ogre cave to capture Gold Mines!
21:10 thorn[Choob]: haha, Speak of the devil
Makeshift
[Choob]
06-02-2012 18:16



I haven't updated this yet - Having trouble with my Google accounts, working on it.
Makeshift[Choob]: I'm on a roll! Two days in world and not even a warning :D
(Mod)Moderator: Awards Makeshift a 2 Day Trophy!

[W]14:56 DeSoRDoR[Snake]: Shoop da whoop is stup- BLLAAAARRGHGH!~!!
Makeshift
[Choob]
22-04-2012 14:26



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.
(17/04/12)
[2]17:48 (Mod)Moderator: If in doubt, I shall blame Makeshift for everything :P
[2]17:48 Makeshift[Choob]: As it should be!
Makeshift
[Choob]
25-04-2012 17:39



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
(17/04/12)
[2]17:48 (Mod)Moderator: If in doubt, I shall blame Makeshift for everything :P
[2]17:48 Makeshift[Choob]: As it should be!
aussiebeast
[Corps]
09-07-2013 04:37



So which is better? Makeshift's or typo's?
Why would I shoot a bloke BANG, then carry him to the bloody car and wizz him off to the hospital at a hundred miles an hour? It defeats the purpose of having shot him in the first place.
Dragosani
[Wino]
09-07-2013 05:08


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.
Makeshift
[Choob]
10-07-2013 19:32



I might take a look at updating mine and adding new features in a few days, gotta finish off some work first though
(17/04/12)
[2]17:48 (Mod)Moderator: If in doubt, I shall blame Makeshift for everything :P
Dragosani
[Wino]
12-07-2013 06:28


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
Truant
[~FoS~]
12-07-2013 07:20



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.
[1] 04:47 spidey101[D2A]: chris doesnt like me.

"What's up dog, I killed you." - Kenny Powers MFCEO

0/61 The Captain Keelhail struck at Truant and did 69 damage.
Pages: 1- 2

Only users can reply.


Forum -> Help -> Full Smithing Calculations Spreadsheet

Syrnia © 2020 Mobile version