樂古Nakuz

標題: High alch/Smithing/Crafting/Cooking/Runecrafting/Herblore/Enchant Bolt tables [打印本頁]

作者: leesiupui 時間: 2-2-2010 20:33
標題: High alch/Smithing/Crafting/Cooking/Runecrafting/Herblore/Enchant Bolt tables
本帖最後由 leesiupui 於 2-5-2010 01:45 編輯

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

作者: 乂呀仁乂 時間: 2-2-2010 22:57
本帖最後由乂呀仁乂於 2-2-2010 23:00 編輯

Very Nice Job , Its Helpful , i gonna get 80 smithing and crafting too >.> thx u

作者: t0psecret 時間: 2-2-2010 23:46
wow nice....

作者: sannyhui 時間: 3-2-2010 06:30
師兄我愛你. ^^

作者: aclet0821 時間: 3-2-2010 07:31
nice work mate =]

作者: leesiupui 時間: 3-2-2010 11:52

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

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

作者: sannyhui 時間: 4-2-2010 07:11
師兄貴為樂古二十一級的會員. 想必在此有不少的貢獻. 叫一聲"師兄"也是必然的事. 何況這個表對我真的幫助不少.

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

p.s. 我是merchant noob.

作者: Clmak814 時間: 4-2-2010 09:11

為何稱呼我做師兄?btw,你爭prayer, smithing 同ranged就可以max了,加油= =
leesiupui 發表於 3-2-2010 11:52

我都要叫一句大大
我之前想咁樣做不過又唔識
雖然前我黎講未有用住
A VERY GOOD JOB!

作者: leesiupui 時間: 4-2-2010 10:12
本帖最後由 leesiupui 於 4-2-2010 10:31 編輯

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

關於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= =

作者: Clmak814 時間: 4-2-2010 17:36
Yea i can make one offline..

作者: leesiupui 時間: 4-2-2010 18:10

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

why offline:lol

作者: jack19921214 時間: 4-2-2010 23:46
強

是真的自動更新嗎

相信對大家都很有幫助謝謝樓主

作者: leesiupui 時間: 5-2-2010 00:22

強

是真的自動更新嗎

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

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

作者: ｔaｉ 時間: 5-2-2010 02:27
加埋EXP EARNED就最好了!

作者: leesiupui 時間: 5-2-2010 02:43

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

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

作者: t0psecret 時間: 7-2-2010 15:58
can u make a herb and pots table plz? would really appreciate if u do

作者: leesiupui 時間: 8-2-2010 02:35

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 時間: 11-2-2010 02:57
Added p2p tables(herblore and enchant bolts), can someone take a look and tell me if it's ok or not?

作者: t0psecret 時間: 11-2-2010 19:02
this is excellent push push push

作者: jack19921214 時間: 11-2-2010 22:59
或者樓主可以整一個runecrafting的? :handshake

作者: leesiupui 時間: 13-2-2010 19:48

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

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

作者: dbsbookg 時間: 17-2-2010 01:11
樓上兩位non member都咁勁 -.-.....
98 rc點樣練出黎架.....

作者: sannyhui 時間: 17-2-2010 23:07
以前我係咁練既 - Body rune -> GOP + Water rune -> 9 x Air Assisting

而家嘛.... 大慨是 FOG -> GOP -> FOG -> GOP ...........

搵日問吓d RC friend 再 update.

作者: icy920801 時間: 22-2-2010 23:55
http://spreadsheets.google.com/pub?key=psIHV_3jO_sM12v_zp4uLLg
herblore spreadsheet

- made by Bethanime @ HYST

作者: leesiupui 時間: 23-2-2010 00:29
本帖最後由 leesiupui 於 23-2-2010 00:37 編輯

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

作者: icy920801 時間: 23-2-2010 00:56
本帖最後由 icy920801 於 23-2-2010 01:00 編輯

The first i saw is this one:

I wanted to just post that, but its messy. Also many price doesnt s ...
leesiupui 發表於 23-2-2010 00:29

Loss per xp seems too inaccurate :/

作者: leesiupui 時間: 23-2-2010 01:03
回復 26# icy920801

do you mean 2 decimal places problem...or the calculation is wrong?

作者: icy920801 時間: 23-2-2010 14:21

回復 icy920801

do you mean 2 decimal places problem...or the calculation is wrong?
leesiupui 發表於 23-2-2010 01:03

由一欄叫 "selling price of finished product" 開始就無法理解你用緊咩公式計出黎
super energy (3) 唔係 14xx GP, 高好多.. 大約 4K 左右
因而令到打後, 特別係 GP/XP 內的數值與事實不符

我唔識 spreadsheet 既野所以我唔知點改...

作者: leesiupui 時間: 23-2-2010 14:27

由一欄叫 "selling price of finished product" 開始就無法理解你用緊咩公式計出黎
super energy (3) 唔 ...
icy920801 發表於 23-2-2010 14:21

下...我果個係顯示4241 wor
http://spreadsheets.google.com/p ... 8qA&output=html

作者: icy920801 時間: 23-2-2010 18:40
囧 !!! was refering to this one
http://spreadsheets.google.com/pub?key=pWha5KWTPQCo3iureEDFSMw

作者: leesiupui 時間: 23-2-2010 19:05

囧 !!! was refering to this one
icy920801 發表於 23-2-2010 18:40

呢個係人地整架嘛= =,佢整到錯哂我先整過個

作者: Hk_Alexander 時間: 23-2-2010 22:20
真係幾 Useful=.="~ 下次我有需要時就搵你整過個 table 先~~
Thx, mate~

作者: leesiupui 時間: 4-3-2010 20:55
Push,我想知有冇試過level 65 smithing以上smelt iron bar?係唔係100%得?我買唔到iron ore 試

作者: icy920801 時間: 4-3-2010 21:26

Push,我想知有冇試過level 65 smithing以上smelt iron bar?係唔係100%得?我買唔到iron ore 試 ...
leesiupui 發表於 4-3-2010 20:55

no

最高 45 lvl 80%

作者: leesiupui 時間: 4-3-2010 23:12

no

最高 45 lvl 80%
icy920801 發表於 4-3-2010 21:26

thanks, 之前睇錯,以為45之後每level加1%

作者: Zplus05 時間: 19-4-2010 19:44
WOW,超詳細

作者: Megarunes 時間: 29-5-2010 02:07
As this is a very useful post I am not 9 bumping, bump

作者: Hk_Alexander 時間: 29-5-2010 09:55
本帖最後由 Hk_Alexander 於 29-5-2010 09:56 編輯

依家對你來說，看來整 table 跟吃飯一樣簡單=.="

作者: pet88 時間: 29-5-2010 22:42
thanks

作者: jack19921214 時間: 18-4-2011 18:51
updated? COOL

作者: kingtom 時間: 24-4-2011 22:19
dude, this one is very useful. Thank you

歡迎光臨樂古Nakuz (http://eee.nakuz.com/)