Latest Diablo 3 News
DiabloWiki Updates
Support the site! Become a Diablo: IncGamers PAL - Remove ads and more!

Upgrading runes

Discussion in 'Single Player Forum' started by TomSilver, Jan 28, 2004.

  1. TomSilver

    TomSilver IncGamers Member

    Joined:
    Jul 31, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    5
    Upgrading runes

    Hi Folks,

    until now I've never found any high end runes (just one UM in 2 years D2). But I have tons of medium and low end runes collecting dust in stashes. I can now start a complete week of rune cubing and upgrading, and see what comes out. But I'm lazy ;). Is there a way of calculating the result before I do the work? I'm thinking of a spreadsheet or something else, just type in the numbers of all runes you have, and the spreadsheet tells you the highest possible result.

    Is anything like that out there?

    Thanks,
    Tom
     
  2. Zarhrezz

    Zarhrezz IncGamers Member

    Joined:
    Jul 3, 2003
    Messages:
    1,349
    Likes Received:
    0
    Trophy Points:
    255
    Never seen one, but I doubt it'd take more than half an hour to make...bit more if you'll also let it calculate the required gems to upgrade. And no, I don't have time for it now, I need to work =)
     
  3. Borlag

    Borlag IncGamers Member

    Joined:
    Nov 12, 2003
    Messages:
    1,243
    Likes Received:
    1
    Trophy Points:
    165
    I remember someone here made excel spreadsheet for this, not sure if I have it stored, but it'd be at home anyway so can't check now (at work).
     
  4. Butzull

    Butzull IncGamers Member

    Joined:
    Jun 22, 2003
    Messages:
    1,106
    Likes Received:
    1
    Trophy Points:
    120
    I read this thread and decided I should make one. If you just enter the actual number you have in the imaginatively named "# you have" column, then the likewise inspired named "Effective Amount" column will tell you what the final result would be, including the leftovers. The # of gems and type is listed too.

    Rune-calc.zip (right click and save as on the link).

    Butz. :teeth:

    Edit: Although for some reason the site is really labouring at the moment. :(
     
  5. TomSilver

    TomSilver IncGamers Member

    Joined:
    Jul 31, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    5
    Got it, thanks Butzull :)

    But (as expected) the result is quite disappointing for me. No chance for an Enigma Armor :(
     
  6. nemar

    nemar IncGamers Member

    Joined:
    Jun 27, 2003
    Messages:
    593
    Likes Received:
    0
    Trophy Points:
    120
    I think there is a trouble with you're program, you can't have more one zod lol :)
     
  7. ULTIMATER

    ULTIMATER IncGamers Member

    Joined:
    Jun 27, 2003
    Messages:
    1,040
    Likes Received:
    0
    Trophy Points:
    120
    Wow, i have a SUR when i upgrade!! :surprise:

    Anyone have another for me? :teeth:
     
  8. Butzull

    Butzull IncGamers Member

    Joined:
    Jun 22, 2003
    Messages:
    1,106
    Likes Received:
    1
    Trophy Points:
    120
    Oops, you're right, I didn't bother with handling Zod properly.

    If you want to fix it cut and paste "=MOD(C33,2)+B34" without the "'s into cell D34. If anyone is lucky enough to need those results. ;)

    Butz. :teeth:
     
  9. burke615

    burke615 IncGamers Member

    Joined:
    Nov 17, 2003
    Messages:
    176
    Likes Received:
    1
    Trophy Points:
    26
    Nice work, Butz! Now all I need to do is collect 14,281,869,000,000 El runes to get my Zod!!! :teeth:

    Cheers!
    Burke
     
  10. nemar

    nemar IncGamers Member

    Joined:
    Jun 27, 2003
    Messages:
    593
    Likes Received:
    0
    Trophy Points:
    120
    and if you put
    G2
    =ENT((MAX(0;B2-1))/3)
    H2
    =B2-3*G2
    G3 and next
    =ENT((MAX(0;B3+G2-1))/3)
    H3 and next
    =(B3+G2)-3*G3

    with change 3 by 2 for pul

    you'll have the same , but with keep one rune of each (if I didn't make a mistake
     
  11. nemar

    nemar IncGamers Member

    Joined:
    Jun 27, 2003
    Messages:
    593
    Likes Received:
    0
    Trophy Points:
    120
    and for 28 561 995 000 000 you'll have all the runes, so you can have the runeword you want !
     
  12. Butzull

    Butzull IncGamers Member

    Joined:
    Jun 22, 2003
    Messages:
    1,106
    Likes Received:
    1
    Trophy Points:
    120
    Don't be silly mate, if you have that many it's overkill, you only need:
    14,281,868,906,496 ;)

    You can save yourself the effort of the extra 93,504 you didn't need (or about 0.000001% of the overall effort!) ;)

    Butz. :teeth:
     
  13. LprMan

    LprMan IncGamers Member

    Joined:
    Oct 11, 2003
    Messages:
    2,951
    Likes Received:
    0
    Trophy Points:
    165
    Bahh, I shouldn't download that... :teeth:

    If I cube all my runes, I will get Vex, Gul, Um and some mid-rare runes...

    This proves how insane it is to try cubing a Zod :)
     
  14. whomhead

    whomhead IncGamers Member

    Joined:
    Jun 26, 2003
    Messages:
    2,094
    Likes Received:
    0
    Trophy Points:
    165
    its funny because if i cube ALL of my ~175 mid-level runes, i get a vex. also, if i cube only my top four runes, i get a vex. i guess i don't need all those trillions of els, eh?
     
  15. burke615

    burke615 IncGamers Member

    Joined:
    Nov 17, 2003
    Messages:
    176
    Likes Received:
    1
    Trophy Points:
    26
    Now how did I *know* someone was going to call me on that??? I must be psychic! :D

    Cheers!
    Burke
     
  16. Death_Dealer

    Death_Dealer IncGamers Member

    Joined:
    Jun 22, 2003
    Messages:
    196
    Likes Received:
    0
    Trophy Points:
    41
    Hey Butzull, the link seems to be broken. Could you shoot me a copy at
    [email protected]

    Thanks mate!
     
  17. LprMan

    LprMan IncGamers Member

    Joined:
    Oct 11, 2003
    Messages:
    2,951
    Likes Received:
    0
    Trophy Points:
    165
    I can send you that, in fact im just doing that :)
     
  18. Death_Dealer

    Death_Dealer IncGamers Member

    Joined:
    Jun 22, 2003
    Messages:
    196
    Likes Received:
    0
    Trophy Points:
    41
    Got it, TYVM!
     
  19. Starving Poet

    Starving Poet Member

    Joined:
    Dec 29, 2003
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    0
    Ooohh, can I get in on the action too? ;)

    starvingpoet at comcast dot net
     
  20. Death_Dealer

    Death_Dealer IncGamers Member

    Joined:
    Jun 22, 2003
    Messages:
    196
    Likes Received:
    0
    Trophy Points:
    41
    Forwarded onto you
     

Share This Page