Re: Excel Spreadsheet for tracking Combat Order
Thankyou, I missed that, and have updated it in the sheet. I will post an update with that change made, it can be manually changed by changing the formula by using the Insert menu > Name > Define, then selecting the appropriate formula and changing it
=IF('Combat Order'!$C4>0,INT(('Combat Order'!$C4+1)/3),"")
Is the correct formula for that both OCV and DCV cells.
It orders ties based on what order they show up on the spreadsheet. So, if you put them in descending order based solely on INT it would give you the same effect.
The sidebar only looks at DEX, SPEED, and Character Name
Thank you alot, many of those cells had to be individualy formatted, took a while but it makes it take about two minutes to add three or four villains and print out a sidebar.