Trinketing calculator

  • Thread starter Deleted member 4013
  • Start date
D

Deleted member 4013

Guest
Added a worksheet to calculate seals -> metal.

Check it out :)

(i.e. now you can check how many items you can buy from them DF shop merchants by using those seals, and get a total amount of metal bars how much you get when you buy those items, and salvage 'em).
 

Grayh

Fledgling Freddie
Joined
May 10, 2004
Messages
89
Could always add another column, E will be suitable I guess, with how much gold that amount of diamonds would yield.

eg.

_____A __________B __________C ____________D__________E________
item to buy | nr of seals | remaining seals | nr of bars | amount of gold
______________________________________________________________
 
D

Deleted member 4013

Guest
Grayh said:
Could always add another column, E will be suitable I guess, with how much gold that amount of diamonds would yield.

eg.

_____A __________B __________C ____________D__________E________
item to buy | nr of seals | remaining seals | nr of bars | amount of gold
______________________________________________________________


Mm well txs for the suggestion :) , but I thought that person would copy paste the amount of bars information to the first worksheet - to get that information of how much that makes in gold.
 

Funkdocta

Fledgling Freddie
Joined
Jan 16, 2004
Messages
668
your get 4.47g per asterite hinge youve put 4.54g i believe. Is there a merchant somewhere giving more caah? :D
 
D

Deleted member 4013

Guest
Funkdocta said:
your get 4.47g per asterite hinge youve put 4.54g i believe. Is there a merchant somewhere giving more caah? :D

Prices are estimates mate. But thanks for the correction :) I'll fix that soon..
 

Grayh

Fledgling Freddie
Joined
May 10, 2004
Messages
89
Ixoth said:
Mm well txs for the suggestion :) , but I thought that person would copy paste the amount of bars information to the first worksheet - to get that information of how much that makes in gold.

why copy&paste when you're doing such an excellent job with the cells :worthy:
 

Iceforge

Can't get enough of FH
Joined
Dec 24, 2003
Messages
1,861
Grayh said:
why copy&paste when you're doing such an excellent job with the cells :worthy:

Add a cell under Asterite amouth (at txt and number), make it into Bars from Seals.

Asume everyone use sleeves/helms from diamonds and sapphires (best payout), add 2handed swords for emeralds (give asterite bars) , and make the field equal to (this string dont contain 2handed swords)

Amouth of Asterite from DF seals:

='Seals to DF items'!D25+'Seals to DF items'!D19

Change field C22 (before C21) to:

=IF(C20+C21>1;(C20+C21)/2;0)

and it should auto-transfer amouth..
 
D

Deleted member 4013

Guest
Iceforge said:
Add a cell under Asterite amouth (at txt and number), make it into Bars from Seals.

Asume everyone use sleeves/helms from diamonds and sapphires (best payout), add 2handed swords for emeralds (give asterite bars) , and make the field equal to (this string dont contain 2handed swords)

Amouth of Asterite from DF seals:

='Seals to DF items'!D25+'Seals to DF items'!D19

Change field C22 (before C21) to:

=IF(C20+C21>1;(C20+C21)/2;0)

and it should auto-transfer amouth..

Txs for tips. I'll implement those asap :cheers:
 
D

Deleted member 4013

Guest
New v1.02 available here

V1.02 changes:
-added version history worksheet
-added buttons to append max values of metals bars of given metal categoria to first worksheet corresponding field (note it appends over previous value, not replace).

MD5: 1f067ff463797e4cdadd01d3ef44cf69
 

Iceforge

Can't get enough of FH
Joined
Dec 24, 2003
Messages
1,861
Ixoth said:
Txs for tips. I'll implement those asap :cheers:

Np, was bored in English class :p

And ty btw, not that I use sheets that much, but thought that 2handed swords was best buy for all catagories... more money pr. seal now xD
 

Nausilus^^

Can't get enough of FH
Joined
Dec 25, 2003
Messages
1,745
Could be wrong, but I've always gotten 4g 45s per asterite hinge and not 4g 47s or 4g 54s
 

Iceforge

Can't get enough of FH
Joined
Dec 24, 2003
Messages
1,861
Nausilus^^ said:
Could be wrong, but I've always gotten 4g 45s per asterite hinge and not 4g 47s or 4g 54s

Bronze = 16c
Iron = 2s 76c
Steel = 11s 4c
Alloy = 33s 4c
Fine Alloy = 99s 36c
Mithril = 1g 98s 72c
Adamantium = 2g 98s, 8c
Asterite = 4g 47s 12c

just tested it...
 
D

Deleted member 4013

Guest
Nausilus^^ said:
Could be wrong, but I've always gotten 4g 45s per asterite hinge and not 4g 47s or 4g 54s

Already said in this topic mate that prices are estimates.
 
D

Deleted member 4013

Guest
Iceforge said:
Bronze = 16c
Iron = 2s 76c
Steel = 11s 4c
Alloy = 33s 4c
Fine Alloy = 99s 36c
Mithril = 1g 98s 72c
Adamantium = 2g 98s, 8c
Asterite = 4g 47s 12c

just tested it...

Txs for those infoes. I'll update them to my excel. :cheers:
 
D

Deleted member 4013

Guest
Iceforge said:
Bronze = 16c
Iron = 2s 76c
Steel = 11s 4c
Alloy = 33s 4c
Fine Alloy = 99s 36c
Mithril = 1g 98s 72c
Adamantium = 2g 98s, 8c
Asterite = 4g 47s 12c

just tested it...

Could someone check the prices for remaining item types.. arcanium and the different woods for me - so I then could update my excel.
 

Users who are viewing this thread

Top Bottom