Automated Rebellion Sheet (Excel)

[Rune]

After DMing a very long Kingmaker campaign, I learned to appreciate excel sheets to handle most of the heavy load involved in Kingdom Building. So when I got to the Rebellion part of Hell's Rebels I thought I would help out my DM and hash out a functioning automated sheet to cut down on his work. A few sleepless nights of banging my head on the keyboard in frustration resulted on this and, seeing as I used a LOT of material produced by awesome people at these forums, I'd love to share it with you:

Rune's Automated Rebellion Sheet.

If there are any problems/miscalculations/bugs, please let me know (by posting on this thread or direct messaging me). A few notes about the sheet:

• Open it in Excel for better formatting. I have not tried it in any other medium (it looks awful on Dropbox). It uses the fonts SeriaRegular, Source Sans Pro and Newcomen Bold (for the title).
• It is locked to protect the formulas; any entry fields are unlocked and can be edited. These include: # of Supporters (which is used to calculate Rank), Population, Notoriety, Membership, Treasury, "OTHER" category of bonuses to Loyalty/Secrecy/Security (both the number and the name, so you can indicate the source of the bonus), Allies (and Boons), Number of Safe Houses, Officers (and their bonuses).
• My DM said we can have multiple people in Officer positions, but only one provides the bonus. So only the first Officer adds his/her bonus to the relevant stat (the Recruiter is an exception).
• You choose the teams from a drop-down menu; the team listing is on the second tab. You can enter custom (or bonus) teams by replacing the placeholder Bonus Teams.
• The checkbox for the possible Rebellion actions needs to be manually checked positive or negative (I'll work on that if I get the time - if you know the solution lemme know).
• As I'm not sure how Allies and their Boons work I'll wait for the adventure to progress before I try to implement their bonuses to the sheet - they'll need to be added manually.
• Please beware of spoilers - I'm playing this game and we literally just started using the Rebellion rules.

[Dahgda]

Thanks for this - I am about to start running the AP, and this will speed things up, I hope.

[taks]

Cool. If we ever get around to playing this I'll give it a more detailed look. I have a spreadsheet I made myself, but it isn't as nice, and it's confusing even to me (I actually stepped it week by week along the columns).

[Scharlata]

Hi, Rune,

good work, speeds things up. Made my own, too.

Good luck and have fun playing the Rebellion!

[Cheryl Sahawneh]

I'm just starting to run Hell's Rebels. We've only gotten through our first session so far but I'm trying to get familiar with the rebellion sheet in hopes that we'll be ready for it in a session or two. I'm having problems with the teams on the first page that don't seem to be linking over to the second page. I'm using Open Office which usually does okay with the files from Microsoft Office. Can you give me any advice?