09-17-2016, 01:00 PM
(This post was last modified: 10-03-2016, 12:54 PM by TwistedLogic.
Edit Reason: Addressing an issue in the .xls verison
)
I put together a spreadsheet to help people with type balancing their team and identifying any holes that they might have. There's a .ods and a .xls version, though I can't guarantee that the .xls version works. I hope this helps some people out!
~~EDIT~~
For some reason OpenOffice is deleting my formula in the .xls version when I save it.
The formula should be:
In case you don't have much experience with Excel, paste that into Sheet1, C3, then drag it to T3, then drag all of that down to row 8.
~~EDIT~~
For some reason OpenOffice is deleting my formula in the .xls version when I save it.
The formula should be:
=INDEX(Sheet2!$C$2:$T$20,MATCH($A3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))*INDEX(Sheet2!$C$2:$T$20,MATCH($B3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))
In case you don't have much experience with Excel, paste that into Sheet1, C3, then drag it to T3, then drag all of that down to row 8.
