Nothing fancy here but something I've made for myself, a calculator for weapons and also armour layering, you'll need to enable macros.http://sites.google.com/site/leonpoiwfr ... ects=0&d=1
The 'Armour' and 'Weapon' tabs are where the user selections are displayed. The corresponding data tabs can be changed to reflect any houserules etc that you may use (or to undo any houserules I've included). The 'Armour' and 'Weapon' tabs are protected so that one doesn't accidental delete something that they need, but there is no password.InstructionsWeapon
- Select weapon type
- Select strength of wielder
- Enter weapon quality
Effective impacts, weights, etc will be displayed for any relevant weapon weight categories (light, average, heavy and a new one massive) based on strength. There are a few semi-houseruled entries to do with STR requirements and HM penalties (actually really just EML penalties for different wielding styles, 1H, off-hand, 2H). If STR is highlighted in red it's because you don't have the minimum strength required and you'll get some form of penalty. You can change the tables used in the calculation on the weapon data tab.Armour
- Filter type allows you filter what armours are shown in the drop-down menus below. Select All to show them all, though it's easier if you step through the layer materials.
- Select body size
- Select armour items and AQ one after the other until you are finished
- Select the armour model: HMA, HM3 or HALF. The selection influences how layering is computed. HM3 is your standard summation, HMA is the square-root of the sum of the squares, and HALF is the greatest number plus a summation of half the other layers.
- Check that layering is valid by looking at the orange message below model. Layering is invalid if more than 1 rigid armour is worn on the same location or otherwise if flexible armour exceeds a layering limit that differs from joints to limbs to body. Use this is a guide only.
- Select STR and STA - this will be used in the ENC calculation. Note that the calculation uses the HMA equation whereby humans have a load rating of STRx2 (like horses who have STRx8).
- Assign equipment and weapon weight so as to obtain a total weight.
- ENC and FR are computed (HMA style). Change the equations to suite whatever rule versions you're using.
You can also unhide a portion of the sheet by clicking on the plus icon at cell AC. This unlocks a series of entries that can be used as a guide for making armour heavier or lighter and for determining manufacture time and material cost etc.
Also in the unhidden section are some rules for monster leather. The equations are coded based on the armour values that I use so just change them to suite whatever rules you are using (e.g. to maintain consistency between AV for cattle and the resulting AVs for leather and kurbul).Armour Data
- This gets a special mention because I've changed the values away from default or even HMA values. Go to the to top-left part of the sheet and assign B,E,P,F wt pr tm and cost values based on your preference. These updated values will automatically be assigned via lookups to every piece of armour.
- % coverage by body part can also be changed (row 13)
- New armour can be added to the list. The easiest way is to insert a new row (between the existing armour list otherwise the lookups won't catch the new armour), copy an existing row into this blank row, and then change it as appropriate. The only things you need to edit are the item name (column B) and the coverage (columns I to AE). Everything else is calculated using lookups.
- You can also change the conditions for valid layering (rows 122-125, but really only cells J122 and L122)
Let me know if you need any assistance and if you find it useful. I use it for calculating AP during character generation, making armour profiles, and computing impacts for adversaries without having to reference tables.