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
Old 09-23-2021, 08:17 AM   #25
pialgo
 
Join Date: Mar 2021
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

Hello, sorry for the necro but the link of the spreadsheet is dead. Does any one have the file ? Thanks in advance !
pialgo is offline   Reply With Quote
Old 09-23-2021, 04:35 PM   #26
Grey_Fox
 
Join Date: Jun 2011
Default Re: Mass Combat Spreadsheet

Quote:
Originally Posted by pialgo View Post
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
Grey_Fox is offline   Reply With Quote
Old 09-24-2021, 03:24 AM   #27
pialgo
 
Join Date: Mar 2021
Default Re: Mass Combat Spreadsheet

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 !
pialgo is offline   Reply With Quote
Old 09-24-2021, 04:45 PM   #28
Grey_Fox
 
Join Date: Jun 2011
Default Re: Mass Combat Spreadsheet

Quote:
Originally Posted by pialgo View Post
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?
Grey_Fox is offline   Reply With Quote
Old 10-04-2021, 09:48 AM   #29
tetrahedron
 
Join Date: Jun 2006
Location: Toronto, ON, Canada
Default Re: Mass Combat Spreadsheet

Quote:
Originally Posted by Grey_Fox View Post
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
tetrahedron 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 02:13 AM.


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