Portal   Forum   Members   Market   Gallery   Events

Weapon speed calculation spreadsheet.

Discussion in 'Diablo 2' started by olon97, Oct 11, 2001.

  1. olon97

    olon97 Peasant

    Joined:
    Jul 6, 2000
    Messages:
    626
    Likes Received:
    0
    Market Rating:
    0
  2. Spike

    Spike Banned

    Joined:
    Feb 23, 2001
    Messages:
    430
    Likes Received:
    0
    Market Rating:
    0
    Cant wait to check it out.

    Can anyone convert that to a non-microsoft format so I can look at it?

    Thanks.
     
  3. Draco_Auric

    Draco_Auric Peasant

    Joined:
    Aug 25, 2000
    Messages:
    1,098
    Likes Received:
    0
    Market Rating:
    0
    Awsome dude, thanks so much.
     
  4. olon97

    olon97 Peasant

    Joined:
    Jul 6, 2000
    Messages:
    626
    Likes Received:
    0
    Market Rating:
    0
    I don't know how the Apple works converters do, but the "Excel compatible" Mesa for OS X didn't cary over equations very well last time I tried it. That was several versions ago, however.

    You might want to try the demo accessibly from the version tracker page.
     
  5. olon97

    olon97 Peasant

    Joined:
    Jul 6, 2000
    Messages:
    626
    Likes Received:
    0
    Market Rating:
    0
  6. olon97

    olon97 Peasant

    Joined:
    Jul 6, 2000
    Messages:
    626
    Likes Received:
    0
    Market Rating:
    0
    Re: small version

    Tried the Mesa for myself, and it converted the excel file just fine. Uploaded a mesa version of the document (with no ".xls" on it, if you're a hardcore purist). It should work just fine with the free demo. If you don't have OS X - you have no right to call yourself a Die Hard, Microsoft boycotting, mac user.

    Here's the link:
    Olon's midget Mesa version of his weapon speed calculating spreadsheet
     
  7. Elbereth

    Elbereth MSC Commander and Donator

    Joined:
    Jun 17, 2000
    Messages:
    3,356
    Likes Received:
    14
    Market Rating:
    0
    Wow, thanks for doing the work Olon.
     
  8. Spike

    Spike Banned

    Joined:
    Feb 23, 2001
    Messages:
    430
    Likes Received:
    0
    Market Rating:
    0
    Thanks yet again Olon.

    Now I just got to understand it.

    Appleworks 6.1.2 imported the xls, but when I compared it with the Mesa version, the formula were different. Ill go by the Mesa version.
     
  9. olon97

    olon97 Peasant

    Joined:
    Jul 6, 2000
    Messages:
    626
    Likes Received:
    0
    Market Rating:
    0
    It's easy - just fill in the credit card numbers and expiration dates where it asks, make sure you have microsoft outlook installed, then hit the button marked "execute macro". :evil:

    Oh wait! You're not viewing it in excel. :(

    In that case -
    1. Look up the weapon base speed at the Arreat Summit. Change the sign on the speed it lists (ex. arreat summit lists -30 for phase blade speed - enter 30, or it lists 20 for battle hammer speed - enter -20) and put that number in the "wp. speed" field.

    2. Look up the character base frames for the weapon type you're using and enter them in the "base" field.

    3. If you're not using a speed boosting skill like fanatacism or frenzy, leave the "skill mod" as zero.

    4. Try out different values of IAS in the "IAS" field to see what the calculated frames per attack and attacks per second will be.

    In general, if there's just a number in the field - go ahead and play around with it (within reason). If there's an equation in the field - leave it alone.
     
  10. dapork

    dapork Peasant

    Joined:
    Jan 21, 2001
    Messages:
    1,424
    Likes Received:
    1
    Market Rating:
    0
    well i can't view it, u said the max exel requires os X i use os 9
     
  11. olon97

    olon97 Peasant

    Joined:
    Jul 6, 2000
    Messages:
    626
    Likes Received:
    0
    Market Rating:
    0
    Dinosaur. :p
     
  12. coolstream

    coolstream Banned

    Joined:
    Oct 3, 2001
    Messages:
    47
    Likes Received:
    0
    Market Rating:
    0
    wow man u use 9
     
  13. Wran

    Wran Peasant

    Joined:
    Jun 15, 2000
    Messages:
    336
    Likes Received:
    0
    Market Rating:
    0
    Dudes

    How can you use X when our favorite game sucks in classic. Sadly enough, 90% of my computer time is spent with D2X, which means it's no use for me to boot in X (I do have it though :)).

    Wran
     
  14. Moose

    Moose Peasant

    Joined:
    Jul 8, 2000
    Messages:
    1,612
    Likes Received:
    2
    Market Rating:
    0
    I am right there with you. I at least have to get 10.1 on the system before I will consider booting straight into X. I won't have that till I get my broadband and then I have to download it from a clan member, if all goes well.
     
  15. dapork

    dapork Peasant

    Joined:
    Jan 21, 2001
    Messages:
    1,424
    Likes Received:
    1
    Market Rating:
    0
    doesn't X cost like a $100 tho? i'm not about to blow all my money on it if it's not that important... i'd also have to get that extra ram...
     

Hitometer: 54,784,617 since 1995