High alch/Smithing/Crafting/Cooking/Runecrafting/Herblore/Enchant Bolt tables

leesiupui

They calculate the profit/loss for you as G.E.update, hope this can be useful
F2P
Smelting/Smithing table
Crafting table
Cooking table
High alch table
Runecrafting table ( You need to enter runecrafting level first)

P2P
Herblore table ( Vial of water + Clean herbs + Secondary Items )
Herblore table2 ( Unfinished potion+ Secondary Items )
Enchanted bolts tables

I am a 100% f2p(never been a member), if you want p2p ones, I can make them for you, but you need to tell me what items I need to include , thanks


Note: Items that worth 10k or more may not be so accurate in price, use them carefully

leesiupui

師兄我愛你. ^^
sannyhui 發表於 3-2-2010 06:30

為何稱呼我做師兄?btw,你爭prayer, smithing 同ranged就可以max了,加油= =

leesiupui

師兄貴為樂古二十一級的會員. 想必在此有不少的貢獻. 叫一聲"師兄"也是必然的事.何況這個表對我真的幫助不少.

關於max的問題, 現在小弟正是五行欠水. 正在不斷superheat + cut yew努力中. 多謝你的支持.

p.s. 我 ...
sannyhui 發表於 4-2-2010 07:11

mine runite不就行了,400k+/hr, 怕浪費時間去左個world俾人mine左就開多幾個noob account輪流switch

btw 我不是什麼有貢獻的人,你看我發帖數量低就知了,只是我比你早註冊,nakuz更新了很多次我才會有那麼多積分
之於二十一級會員是因為數年前我經常玩aoc,上nakuz 的ip exchange system,玩時沒有close browser,所以累積了很多在線時間

我都要叫一句大大
我之前想咁樣做不過又唔識
雖然前我黎講未有用住
A VERY GOOD JOB!
Clmak814 發表於 4-2-2010 09:11

不用叫我做大大吧= =
你只要識2個code就識整,你去呢到睇個spreadsheet o既原始版
http://spreadsheets.google.com/ccc?key=tad7isnopCavX2S6iBGakMA

會見到我只係需要用2個code

=Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22Gold Bar%22","table",2),2,3)

同
=Mid(Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22Diamond%22","table",2),8,3),1,4)*1000

前者係for 少於10k o既野,後者係for大於10k o既野(因為database會顯示為e.g.15.9k)

如果你想入gold bar price,可以去http://itemdb-rs.runescape.com/results.ws?query=%22Gold Bar%22, 得一個result,因為個table係果個網頁o既第2個table,所以係"table",2(全部都係2架la)

至於果個2,3就係第2行第3個,如果你個樣野係search result第一行,就係2,3;第二行就係3,3;第n行就係n+1,3

至於大過10k o既野,因為excel唔知道1k=1000,佢會當左15.9k 係0
所以要用=Mid(.....,1,4)*1000
1,4 代表第1至第4個字元,所以佢會將15.9k變左15.9,之後再*1000就係15900
如果你果樣野係238.5k,就用1,5 因為有5個字元 ,如此類推

其他果d加減乘除你識架la= =

leesiupui

Yea i can make one offline..
Clmak814 發表於 4-2-2010 17:36

why offline:lol

leesiupui

強

是真的自動更新嗎

相信對大家都很有幫助 謝謝樓主
jack19921214 發表於 4-2-2010 23:46

yes, it updates when ge updates, if you want to make one, you can see my reply before

leesiupui

加埋EXP EARNED就最好了!
ｔaｉ 發表於 5-2-2010 02:27

Crafting原本已經有,而家其他都加左了,睇下得唔得(high alch不用吧= =)

leesiupui

can u make a herb and pots table plz? would really appreciate if u do
t0psecret 發表於 7-2-2010 15:58

Didnt you see my signature?I am a pure f2p, i dont know nothing about p2p
So if you want me to make one, please give me items name to be included
...like super str potion or whatever you want to be included in the table
because i dont know which potion is worth to made or popular.
Or pm me your msn and i will add you to discuss these stuffs with you lol

leesiupui

Added p2p tables(herblore and enchant bolts), can someone take a look and tell me if it's ok or not?

leesiupui

或者樓主可以整一個runecrafting的?
jack19921214 發表於 11-2-2010 22:59

諗緊點整,俾d時間我,而且新年唔得閒

leesiupui

herblore spreadsheet

- made by Bethanime @ HYST
icy920801 發表於 22-2-2010 23:55

The first i saw is this one:
http://spreadsheets.google.com/pub?key=pWha5KWTPQCo3iureEDFSMw

I wanted to just post that, but its messy. Also many price doesnt show...so i just follow that one....you know i have never been a p2p, i know nothing about herblore. Therefore i use that format and added some potion that topsecret told me. I actually made a new table and only copied the columns name... i typed all codes by myself

btw that table cant use because it used price like "10.5k" , excel is unable to read 10.5k as 10500, so you cant use +,-,x,/ on that. I made it better and displayed as 10500