D@W Database

5 posts / 0 new
Last post
EHamilton
Dwimmermount BackerDomains At War BackerSinister Stone of Sakkara BackerLairs And Encounters BackerBarbarian Conquerors of Kanahu BackerACKS Heroic Fantasy Handbook Backer
Joined: 2012-04-27 16:03
D@W Database

Announcing: A hopefully helpful resource!

I loaded all the troop/unit data from the Campaigns and Battles tables into a single Excel spreadsheet, for ease of use. Then I added a nice front-end template that can be used for printing out "unit cards" four at a time, to hand out to prospective players during playtesting. I wish I could fit some nifty graphics onto the cards, too...

https://drive.google.com/file/d/0B9zRKIFi3z7tNGpIWnNKMTZZQzA/edit?usp=sh...

Instructions:
There are four cells that you need to enter.

* In the "Number" cell, enter the number of troops in the unit.

* In the "Scale" cell, enter the scale at which the unit is being represented. Note that quantities will be calculated relative to the chosen scale. For example, a Platoon of 30 infantry is at full strength, but a Company of 30 infantry is seriously understrength.

* In the "Race/Exp" cell, enter either "Veteran" for veteran troops, or the race of any non-human troops ("Elven" or "Gnoll"). If the race is an exotic type with only one troop type, then enter the name as a plural ("Hill Giants").

* In the "Type" cell, enter any troop type available to that race ("Light Infantry A").

Everything else should work automatically. The quantities that are scaled proportionally based on size are the BR, any wages/costs, the uhp, and the number of attacks. If you enter a size above the maximum allowed for that scale, the unit will be flagged as "oversized".

koewn
koewn's picture
Patreon SupporterDomains At War BackerSinister Stone of Sakkara BackerLairs And Encounters BackerBarbarian Conquerors of Kanahu BackerACKS Heroic Fantasy Handbook Backer
Joined: 2012-07-17 20:11

Oh, look at you my new favorite internet accessible human being*. That is wunderbar!

*(don't worry, it won't get weird.)

Antiquities
Joined: 2013-07-05 19:55

Oh my. This is very, very useful. And it appears it should be possible to add other troop types to the table, since you extended the VLOOKUPs to row 401, which will be useful to people tweaking things for their own settings (like golan's Swords and Sorcery or Kiero's Mercenary, Liberator, Tyrant). Thank you very much for writing this up and making it available to the community.

bobloblah
Patreon SupporterDomains At War BackerDomains At War ContributorSinister Stone of Sakkara BackerSinister Stone of Sakkara ContributorLairs And Encounters BackerLairs And Encounters ContributorBarbarian Conquerors of Kanahu BackerACKS Heroic Fantasy Handbook Backer
Joined: 2013-03-22 16:16

<looks at file>
<head a'splodes>

moorcrys
Patreon SupporterPlayer&#039;s Companion ContributorDwimmermount ContributorDomains At War ContributorSinister Stone of Sakkara ContributorLairs And Encounters ContributorBarbarian Conquerors of Kanahu ContributorACKS Heroic Fantasy Handbook Contributor
Joined: 2012-02-22 22:34

That is so great! Thanks for sharing it. This community is fantastic.