Mass Combat Spreadsheet

[Revanche]

A bit of thread necrophilia here, by about 6.5 years.

I found this spreadsheet here about 2 weeks ago and shared it with my buddy, Jimmy the Tulip. We found a few things broken, and like any spreadsheet he comes across, JtT couldn't not make it better.

So, I present GURPS Mass Combat:

Version 2.02.05

Note: it DOES require the user to have Macros enabled.

Check the Fix List from c2.02.01 and further, but here's a brief list:
- re-sorted the Element lists, to a pure alphabetical list
- added ability to modify the TL without overwriting the formula (yay!)
- added cosmetics to assist in determining dropdown menus and user entry fields
- re-tasked the Risk section to make it usable for any PC (or important NPC)
- corrected tons of errors
- built in some options
- added a Battle Round Length calculator, based on the smaller army's size (my favorite bell and/or whistle)
- All calculations (including user entries) are now automatically calculated
- Added a manual Battle Roll button, so new results don't happen with each individual entry (yay! part 2)

Hope this helps! I know it will help me.

[Grey_Fox]

Originally Posted by Revanche

A bit of thread necrophilia here, by about 6.5 years.

I found this spreadsheet here about 2 weeks ago and shared it with my buddy, Jimmy the Tulip. We found a few things broken, and like any spreadsheet he comes across, JtT couldn't not make it better.

So, I present GURPS Mass Combat:

Version 2.02.05

Note: it DOES require the user to have Macros enabled.

Check the Fix List from c2.02.01 and further, but here's a brief list:
- re-sorted the Element lists, to a pure alphabetical list
- added ability to modify the TL without overwriting the formula (yay!)
- added cosmetics to assist in determining dropdown menus and user entry fields
- re-tasked the Risk section to make it usable for any PC (or important NPC)
- corrected tons of errors
- built in some options
- added a Battle Round Length calculator, based on the smaller army's size (my favorite bell and/or whistle)
- All calculations (including user entries) are now automatically calculated
- Added a manual Battle Roll button, so new results don't happen with each individual entry (yay! part 2)

Hope this helps! I know it will help me.

Wow long time since I thought about this sheet. Great catches and additions though. I will add the link to the first post so people can grab your version as the official default :)

[Revanche]

Thank you! And honestly didn't expect a response from anyone this quickly, much less than OP.

This is a great tool and a great idea.

(Jimmy the Tulip is the updater; I'm just the conduit, as he isn't on here.)

[Grey_Fox]

Originally Posted by Revanche

Thank you! And honestly didn't expect a response from anyone this quickly, much less than OP.

This is a great tool and a great idea.

(Jimmy the Tulip is the updater; I'm just the conduit, as he isn't on here.)

No worries man, I haven't been on these forums in a while but the alert for the thread is still hooked up to my email :). I will edit the first post and credit Jimmy as well then.

[pialgo]

Originally Posted by Revanche

A bit of thread necrophilia here, by about 6.5 years.

I found this spreadsheet here about 2 weeks ago and shared it with my buddy, Jimmy the Tulip. We found a few things broken, and like any spreadsheet he comes across, JtT couldn't not make it better.

So, I present GURPS Mass Combat:

Version 2.02.05

Hello, sorry for the necro but the link of the spreadsheet is dead. Does any one have the file ? Thanks in advance !

[Grey_Fox]

Originally Posted by pialgo

Hello, sorry for the necro but the link of the spreadsheet is dead. Does any one have the file ? Thanks in advance !

Here you go (note: I haven't used or updated it in forever, so I can't guarantee that it works)

Latest Version

[pialgo]

Thank you ! But it's seem it is the 03 version when you posted previously the 06 version (the link of the 06 version worked by the way, i have it and it's very useful). I was curious about the changes made by "Jimmy the Tulip" on the version "2.02.05".

Anyway, thanks for the work on this spreadsheet, very useful !

[Grey_Fox]

Originally Posted by pialgo

Thank you ! But it's seem it is the 03 version when you posted previously the 06 version (the link of the 06 version worked by the way, i have it and it's very useful). I was curious about the changes made by "Jimmy the Tulip" on the version "2.02.05".

Anyway, thanks for the work on this spreadsheet, very useful !

Looks like I don't have a copy of the Jimmy the Tulip version unfortunately (and thanks for the heads up about the wrong version, I will update the link for version 6). Maybe you could message Revanche directly and see if he still has a copy?

[tetrahedron]

Originally Posted by Grey_Fox

Looks like I don't have a copy of the Jimmy the Tulip version unfortunately (and thanks for the heads up about the wrong version, I will update the link for version 6). Maybe you could message Revanche directly and see if he still has a copy?

Reached out to Revanche and here's the requested document: https://drive.google.com/file/d/1BC1...ew?usp=sharing

T