Initiative Spreadsheet

[Wonko the Sane]

Here's a little spreadsheet for tracking initiative. The Analysis Toolpak (Tools-->Add-Ins)must be installed, and macros must be enabled for it to work. Check the Read Me tab for instructions.

WtS

 

[dvvega]

Unfortunately your spreadsheet does not work on Excel for Mac.

I had a quick look at your code to try and figure out what you did ...

Question: did you basically do a Record Macro and use that code?

D

 

[Wonko the Sane]

Unfortunately your spreadsheet does not work on Excel for Mac.

I had a quick look at your code to try and figure out what you did ...

Question: did you basically do a Record Macro and use that code?

Yup, that's exactly what I did. Way to out me as a hack

WtS

Edit: What about it doesn't work? I don't now, nor shall I in the future, have access to a Mac, fwiw.

 

[dvvega]

Its the whole recording a macro thing. Different versions of Excel record macros differently depending on environment etc.

I've written a spreadsheet that sorts initiative etc just as you have, but since I know VBA I manually programmed it. It seems to work on any OS, the only requirement is that Windows/Mac versions create buttons differently. Thus you have to recreate buttons in each one and assign macros.

There are a number of ways around this, however its not a big deal.

D

 

[orionlethe13]

Its the whole recording a macro thing. Different versions of Excel record macros differently depending on environment etc.

I've written a spreadsheet that sorts initiative etc just as you have, but since I know VBA I manually programmed it. It seems to work on any OS, the only requirement is that Windows/Mac versions create buttons differently. Thus you have to recreate buttons in each one and assign macros.

There are a number of ways around this, however its not a big deal.

D

I DM on a Mac, any chance that I can get a copy of this sheet?

 

[orionlethe13]

FYI, I need this because I am rolling Init. every round, and I need a easy way to handle it. Sorry about dragging up a old chain!