Trinketing calculator

[Deleted member 4013]

Hi,

I toyed with excel this weekend, and as a result I made this excel sheet to help to figure out how much money would one's bars and wood material yield in gold once trinketed to more useful - hinges etc.

Feel free to try it, and give feedback.

Btw prices are estimates.

http://www.kolumbus.fi/arsi.rantala/DAOC/daoc midgard bar to gold calc.xls

 

[Zedenz]

Very nice, I shall be using this alot.

 

[Grayh]

http://www.aros.net/~fumigatr/daoc/salvagecalculator.htm is also quite useful

 

[Deleted member 4013]

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]

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
______________________________________________________________

 

[Deleted member 4013]

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]

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

 

[Deleted member 4013]

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

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

 

[Funkdocta]

no probs

 

[Grayh]

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]

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..

 

[Deleted member 4013]

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

 

[Deleted member 4013]

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]

Txs for tips. I'll implement those asap

Np, was bored in English class

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^^]

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

 

[Iceforge]

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...

 

[Deleted member 4013]

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.

 

[Deleted member 4013]

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.

 

[Deleted member 4013]

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.

 

[Deleted member 4013]

Version 1.03 now available.

http://www.kolumbus.fi/arsi.rantala/DAOC/daoc midgard bar to gold calc103.zip

Changes:
-Fixed item prices
-Fixed the diamond seal section's "Append amount to 1st sheet" button. It appended to total amount of arcanium metal bars of 1st sheet - was supposed to append to total field of asterite metal bars.

MD5: ad91d9a39645b7ebe906476a67959707