Steve Jackson Games - Site Navigation
Home General Info Follow Us Search Illuminator Store Forums What's New Other Games Ogre GURPS Munchkin Our Games: Home

Go Back   Steve Jackson Games Forums > Roleplaying > GURPS

Reply
 
Thread Tools Display Modes
Old 03-12-2020, 04:02 PM   #21
Revanche
 
Join Date: Feb 2020
Default Re: Mass Combat Spreadsheet

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.

Last edited by Revanche; 03-12-2020 at 04:16 PM.
Revanche is offline   Reply With Quote
Old 03-12-2020, 04:27 PM   #22
Grey_Fox
 
Join Date: Jun 2011
Default Re: Mass Combat Spreadsheet

Quote:
Originally Posted by Revanche View Post
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 :)
Grey_Fox is offline   Reply With Quote
Old 03-12-2020, 04:53 PM   #23
Revanche
 
Join Date: Feb 2020
Default Re: Mass Combat Spreadsheet

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.)
Revanche is offline   Reply With Quote
Old 03-13-2020, 06:36 PM   #24
Grey_Fox
 
Join Date: Jun 2011
Default Re: Mass Combat Spreadsheet

Quote:
Originally Posted by Revanche View Post
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.
Grey_Fox is offline   Reply With Quote
Reply

Tags
mass combat

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Fnords are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 01:01 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2021, vBulletin Solutions, Inc.