A
Arrownight
Hi I'm a rank amateur and I'm trying to work on something for leisure
its a Rifts Initiative chart for my role playing game.
What Id like it to do:
it takes the dice roll of the initiative (1-32)
the divides that by the number of attacks (1-15)
to get the exact initiative segment that the character acts on
For instance if the player rolls a 20 initiative, and has 5 attacks,
then he acts on segments 20,16,12,8, and 4
I have managed to stumble my way into getting excel to show me th
segments,
how to I make a chart with /name/initiative/attacks/and the number
counting down 32, 31, 30, 29, etc
And get the cell to auto-populate and "X" or color mark in th
characters active segments and leave the rest blank.
Thank you for any advice you can provide, I don't know if this may b
extreme for some, but it passed my ape brain long ago.
Can anyone help
its a Rifts Initiative chart for my role playing game.
What Id like it to do:
it takes the dice roll of the initiative (1-32)
the divides that by the number of attacks (1-15)
to get the exact initiative segment that the character acts on
For instance if the player rolls a 20 initiative, and has 5 attacks,
then he acts on segments 20,16,12,8, and 4
I have managed to stumble my way into getting excel to show me th
segments,
how to I make a chart with /name/initiative/attacks/and the number
counting down 32, 31, 30, 29, etc
And get the cell to auto-populate and "X" or color mark in th
characters active segments and leave the rest blank.
Thank you for any advice you can provide, I don't know if this may b
extreme for some, but it passed my ape brain long ago.
Can anyone help