Loading...
  OR  Zero-K Name:    Password:   

Post edit history

Zero-K Unit Stats Spreadsheet (0.1)

To display differences between versions, select one or more edits in the list using checkboxes and click "diff selected"
Post edit history
Date Editor Before After
10/19/2020 3:15:06 AMUSrankTitanShadow12 before revert after revert
Before After
1 [quote]Well done on the sheet, is there some way to make the columns sortable?[/quote] 1 [quote]Well done on the sheet, is there some way to make the columns sortable?[/quote]
2 Thank you! I appreciate the praise from the lead dev :) 2 Thank you! I appreciate the praise from the lead dev :)
3 The sheet should be sortable if you mouse over the column label ( A, B, etc) , or you can use Data -> Create New Filter View for some more customization. For more freedom, make a copy ( File - Make a Copy) . 3 The sheet should be sortable if you mouse over the column label ( A, B, etc) , or you can use Data -> Create New Filter View for some more customization. For more freedom, make a copy ( File -> Make a Copy) .
4 \n 4 \n
5 [quote]freezing the header would be nice[/quote] 5 [quote]freezing the header would be nice[/quote]
6 Done! 6 Done!
7 \n 7 \n
8 [quote]A pretty useful stat for comparing units in Zero-K is strength as I called it. 8 [quote]A pretty useful stat for comparing units in Zero-K is strength as I called it.
9 Which is (DPS*HealthPoints)/cost^2.[/quote] 9 Which is (DPS*HealthPoints)/cost^2.[/quote]
10 This is interesting. It would be pretty simple to add a column like this. What value do you see in a stat like this? What does it represent, why square the cost? Is it related to Lanchester's square law? 10 This is interesting. It would be pretty simple to add a column like this. What value do you see in a stat like this? What does it represent, why square the cost? Is it related to Lanchester's square law?
11 \n 11 \n
12 [quote]I also made some unit specific match-up tables which compares how units do for cost against eachother.[/quote] 12 [quote]I also made some unit specific match-up tables which compares how units do for cost against eachother.[/quote]
13 I was considering adding a tab to the sheet that allows you to pick two units and have the formula calculate their matchup. I can work on that if anyone is interested, though there are other things on the sheet that need fixing as well! 13 I was considering adding a tab to the sheet that allows you to pick two units and have the formula calculate their matchup. I can work on that if anyone is interested, though there are other things on the sheet that need fixing as well!
14 \n 14 \n