Another f2p guide :P Best items to Smith this time.

[Jimmyw3000]

Jimmy's badly set out guide for smithing.

 

 

 

I made a spreadsheet in Microsoft Excel to tell me which f2p items are the best to smith using the cost per exp value. I know it looks horrible, but at the end of the day, it gets the job done. At the start. I didnt make it for anyone but myself, but I wanted to share it with the rest of the TIF community, so here it is.

 

 

 

Here's a screenie.

 

[hide=][/hide]

 

 

 

Here's the new link: http://rapidshare.com/files/143027114/S ... alues2.xls

 

Just follow the instructions.

 

Thanks to b9sully for some corrections.

 

Users who've downloaded the old link may want to delete that file and use this one, as the C-E R4 column for iron had wrong formulae.

 

 

 

Why I made this.

 

 

 

Well i made this after a discussion in my clan about the cheapest way to train smithing by buying bars, smithing at varrock and then alching, with no superheating or smelting invloved. I origionally made this just for myself, but I've changed some formulaes to make it easier for someone who's just come accross this to use and understand. I know that some cells are empty, and that's for you to fill out as:

 

A: I dont need to know the cost per exp of bronze kites and

 

B: I'm too lazy to fill out every single high alch, low alch and market value of every single f2p smithable item.

 

 

 

Well if you download it, and read the comments clearly, it should make sense... i hope. Post any questions here.

 

 

 

 

 

Short Explanation:

 

 

 

TC1 means Total cost of method 1. This method is buying all bars, smithing then alching with a free nat (from a monster drop or w/e)

 

TC2 means Total cost of method 2. This is buying all bars for the item, and 1 nat; smithing and then alching, asssuming you have a firestaff.

 

TC3 means Total cost of method 3. This method is buying all bars, smithing and then low alching with the lumbridge ring.

 

TC4 means Total cost of method 4. This method is buying all bars, smithing and then selling the item on the grand exchange for market price. You will probably need to update and write in the market price of items if you want to know this.

 

 

 

C-E R1 is the Cost -exp ratio(no'1), with exp as 1. It gives the price per exp (in gp). A value of -54.3 would mean that each exp gained using that method cost you 54.3gp (or 55gp if you round up.)

 

 

 

 

 

FAQ:

 

 

 

Why are some high alch/low alch value cells blank?

 

 

 

I'm too lazy to fill out the alch values for everysingle f2p smithable item. If you are curious and want to know, use the alch calculator on Tipit, or use the !alch function on Runescript. The same aplies to the market values of items.

 

 

 

NOTES

 

The link should be safe.

 

C/C is always good to hear.

 

I will not be writing in the missing values, so dont tell me to.

 

Dont flame me. I'll just report it, wasting your time, my time and a mod's time.

 

I wrote this for my own benefit, but decided to share it with you guys. If you dont like it, leave a reason saying why not. I understand it's not really userfriendly, but as i've said, it was for my own use, not for everyones. I've made it as userfriendly as I could with my skills. I'm sure many poeple couldve done better.

 

Yes, it's probably a bad guide and written badly, but once you see the file, you should understand.

 

Please dont steal the code.

 

If you dont want to download the file, but you are interested in the cost per exp for a specific item, just leave a post saying which one, and i'll try my best to give you the values. Market prices are always fluctuating, so note the date and time of my posts regarding those items.

 

To change the price of bars and nats, go the the Costs sheet.

 

If you have any questions, feel free to ask.

 

 

 

Thanks for your time.

[Xenolith]

Really good idea.

 

 

 

I think that the equation for cell P36 is wrong.

 

It's K36/L18 when it should be K36/L36, if I'm not mistaken.

 

 

 

In fact, all of the Iron's C-E R4 are messed up. Same mistake though.

 

Too bad it's a read-me only =[

 

 

 

Again, great idea.

[manitstinks]

I dont get it... Which thing is the best to smith then?

[Inuashakent]

Efficiency is speed and cost, not just cost.

[Jimmyw3000]

Really good idea.

 

 

 

I think that the equation for cell P36 is wrong.

 

It's K36/L18 when it should be K36/L36, if I'm not mistaken.

 

 

 

In fact, all of the Iron's C-E R4 are messed up. Same mistake though.

 

Too bad it's a read-me only =[

 

 

 

Again, great idea.

 

 

 

Thanks : . I'll have a look into that.

I dont get it... Which thing is the best to smith then?

 

 

 

Look through the C-E R1, C-E R2, C-E R3, C-E R4 columns. The items with the lowest values (ignore the little - sign infront of them) are the ones that cost the least gp per exp.

 

 

 

Efficiency is speed and cost, not just cost.

 

I know that, but i couldnt really find a way to include the amount of time taken per trip, time taken to earn the cash etc etc and work that into the formulae, seeing as I dont know the time to takes to make an invent of addy med helms. Obviously I couldve left it blank, and let you fill it out yourself, but I think i've left enough cells blank as it is.

 

 

 

Going to check on the mistakes b9sully gave me. Thanks for the feedback. :

[Inuashakent]

I can tell you this guide doesn't matter after your 30% done with 99. Addy plates owns every method. Ever.

 

 

 

And why did you do bronze/iron? This guide is never going to be used much... try mith/addy/gold.

[Jimmyw3000]

I can tell you this guide doesn't matter after your 30% done with 99. Addy plates owns every method. Ever.

 

 

 

And why did you do bronze/iron? This guide is never going to be used much... try mith/addy/gold.

 

 

 

Hm? I dont understand what you mean. the screenshot i've provided is just the first page. It does go on to rune. Gold cant be smithed at an anvil in f2p which is why i havent included it.

 

 

 

http://rapidshare.com/files/143027114/S ... alues2.xls

 

 

 

Here's the updated table. Thanks to b9sully for corrections.

[Inuashakent]

Then it's a great guide. It would be better if you could keep the prices updated.

[Jimmyw3000]

Then it's a great guide. It would be better if you could keep the prices updated.

 

 

 

I know i probably shouldve included more values, but tbh, I just dont have the time, and if you want to know something, you can just download the table and then fill out the relevant cells yourself.

 

 

 

Market values are always changing, so I cant really update them as it's a spreadsheet written in Excel, and i'm useless at writing macros. Still, there's nothing stopping you from updating the cells yourself manually.

[ssbmbeliever]

for one, all these ideas use alching I think, so grand exchange values don't change alch amount too much. well maybe they do, but i don't think so.

 

Anyway, I hate rapidshare, and decided to help some people out with this, a mediafire link, it the same thing just different uploader.CLICK HERE.

[Deathmath]

Efficiency is speed and cost, not just cost.

 

 

 

Add an exp per hour section 7/10 :thumbsup: