Log in

View Full Version : Sable Wyvern's Charts, Tables and Cheat Sheets



Sable Wyvern
08-01-2015, 01:44 PM
I've been working on a number of play aids for use in my upcoming game, which some of you may find of use:

Battle Manoeuvre Summary
All manoeuvres in one page, with most of the pertinent details included. There are a few tweaks from what appears in Book of Battle 2, mostly to align contradictory entries.

The most substantive change I've made is to remove the "Engaged" requirement from Pull Back and Withdraw because otherwise there is no way to move your unit backwards while Disengaged unless you Run Away, win the Battle roll or are in a non-combat zone.

PDF: https://drive.google.com/file/d/0B_v5gnUhLoEUS29XcmduaV90UEk/view?usp=sharing
Excel: https://drive.google.com/file/d/0B_v5gnUhLoEUNjRwOTVnNktscTA/view?usp=sharing

Battle Cheat Sheet
The manoeuvre choice summary from BoB2, with some missing options added and incorrect entries removed.

Page two has a number of tables, charts and summaries likely to prove useful in play.

PDF: https://drive.google.com/file/d/0B_v5gnUhLoEUbU5SakdKTTlUazg/view?usp=sharing
.docx: https://drive.google.com/file/d/0B_v5gnUhLoEUX05DcVlQVDRLcjg/view?usp=sharing

Feast Events Table
A slightly cleaned up version of the same file I posted elsewhere on the forums (there were an embarrassingly large number of typos and misspellings in the original). Credit to Sir Pramalot for originally designing the Feast Cards, and to Taliesin for posting the entries in the Feast Card Thread.

Enter the number of knights up the top. The sheet can handle up to six -- if you need more, anyone with some basic excel skills should be able to add extra lines with some copy pasting, although the conditional formatting will require a bit more work.

Hit F9 to generate a new set of events.

I've made a few minor modifications to some of the events. You can always go to sheet two and modify them yourself if you want to tweak them.

The biggest overall change I made is that instead of having a yes/no for refuse, there is Yes (refuse with no repercussion), Courtesy (make a courtesy roll if you wish to refuse) and No (you can't refuse). I've also noted where refusal may require testing a trait.

I've tended towards granting checks for decisions, instead of mandating rolls to determining the PK's actions. Famous traits would, of course, require rolls to go against type.

https://drive.google.com/file/d/0B_v5gnUhLoEUTWtZR1NQWldoOTg/view?usp=sharing

Excel Character Sheet

The sheets found at http://www.adnd3egame.com/pendragon.htm form the basis for this one, but one of my players has made substantive changes and added a lot of extra pages.

They are built for Cymric knights, and have a drop-down selection for religion. In order to get the religious bonus to calculate correctly, you need to use the fields in the Gen & Track page to enter your trait values. Everything else will work if you just choose to override the values on the main page. Note that the Gen&Track page only has you enter the "Positive" trait value, not the contrary "Negative" trait. The Famous and Adj columns are designed to assist with character gen, otherwise you can just use the Override column.

Note that there is a check-box that is used to activate the Chivalry bonus once it becomes available in game. Chivalry and Religious bonuses are added automatically once earned.

Armour values use Greg's alternative +6 for Full Plate, but you can edit these values in the Lists sheet.

Most of the rest is fairly self-explanatory. Note that you need to populate your stable (and name your horses) for all the various horse drop-down menus to work properly.

There are pages for squires, estate management, stables and family and retainers.

I think there are a few final tweaks to be made.

https://drive.google.com/file/d/0B73WfIDZesBNSExMME9zRjdEcms/view?usp=sharing

Other Sheets To Come
I'm currently working on a Battle Record in Excel, that will automate a few of the details, including the Glory calculations, and copy relevant data back and forth across the two sheets for Leaders.

At some point, I should also have a general 1-page cheat sheet ready, and a Winter Phase summary that covers just about every Winter Phase option I plan to use (the latter might be of limited general utility, given the range of possible Winter Phase options and house rules).

Sable Wyvern
08-02-2015, 11:22 AM
Player's Battle Record

The Excel sheet should be fairly self explanatory.

When starting a new battle round, enter the round number, unit intensity and orders. Then use one line for each enemy being faced that round. When you select your result, it will automatically adjust the Glory earned.

You can select "out of battle" or "reserve" instead of a result, and will be awarded the appropriate amount of Glory for that round.

It does not calculate extra Glory for reserve troops going into action -- this will need to be done manually by entering an appropriate Base Glory.

Cells in blue in the top section are required fields for various Glory calculations.

https://drive.google.com/file/d/0B_v5gnUhLoEUbXJfQUlxS3RrUm8/view?usp=sharing

Sable Wyvern
08-02-2015, 12:53 PM
GM's Battle Record

Well, it turns out that the GM's Battle Record was much, much simpler to put together.

Tick the round check-box when the round starts, and the auto-calculate features for that round will start working. Everything else is just straight data entry (the shaded cells are all the self-calculating ones).

https://drive.google.com/file/d/0B_v5gnUhLoEUb3dqRHBianRXUVE/view?usp=sharing

Combining both sheets into a single two-page Leader's Battle Record is going to be more challenging.

luckythirteen
08-02-2015, 03:45 PM
These are great, thanks!

Sable Wyvern
08-09-2015, 01:05 PM
The character sheet link above now links to a slightly updated (and mostly final) version of the character sheet.

Sable Wyvern
08-16-2015, 12:23 PM
General Cheat Sheet

This is mostly by the book, with a few notes:

I'm leaning towards using less extreme results for Passions under 11.

Skirmish results use an opposed resolution, but are otherwise identical to the way they're presented in KAP5.0.

I've added a bit of detail to the Melee in the Standard Tournament Resolution.

I don't have my copy of KAP5.1 handy, so I'm not sure if the modifiers included match up with the official 5.1 rules. In any event, I have rebated weapons doing full knockback, but held blows only doing half.

Feasting and Social Modifiers are my own take on various house rules floating around, and are based on the use of APP vs APP rolls to gain the attention of important personages.

Fine Amour is mostly as written, although RF does not equal months (I can't see how that can possibly work in conjunction with the rest of the system being based on annual tasks), and I'm using APP vs APP instead of a roll against Amour.

PDF: https://drive.google.com/file/d/0B_v5gnUhLoEUUXNQOW9EeV9sS3c/view?usp=sharing
.docx: https://drive.google.com/file/d/0B_v5gnUhLoEUU08zSGVXcU55c2c/view?usp=sharing

Winter Phase Summary

Mostly based off of Book of the Estate.

Shortage results for an Ordinary Knight is my own extrapolation.

Grades of Maintenance include a few tweaks from KAP5.1.

Marriage rolls based on Book of the Entourage.

Childbirth based on tables developed by a number of posters here.

PDF: https://drive.google.com/file/d/0B_v5gnUhLoEUcUhmSkdVcWJZY0k/view?usp=sharing
.docx: https://drive.google.com/file/d/0B_v5gnUhLoEUNV9KbXBZaGFJMVE/view?usp=sharing