|
Post by knoffles on May 21, 2020 9:53:12 GMT
Hey gents,
Following on from my recent flurry on the wood elf tactics section and the loss of the enchanted arrow damage probability spreadsheet on Asrai (I say loss, I was never able to get hold of it). With @strutsaggets help I’ve been creating a new spreadsheet to show what arrows give the most benefit in various situations.
It will take 2 forms:
1) the ability to plug in: Your unit size, enemy toughness & armour save and any hit modifiers to then automatically calculate the probably damage from your archers 2) some prepopulated tables so you can cross reference a selection of the items in the plug in table.
But I need your help.
Before I post the tables and link to the spreadsheet in the tactica, I would like a few peeps to cross check the calculations (if that’s your cup of tea). I’m pretty sure they are all spot on but getting a second or third set of eyes would be appreciated.
|
|
|
Post by FvonSigmaringen on May 21, 2020 11:32:32 GMT
|
|
|
Post by knoffles on May 21, 2020 19:17:33 GMT
. Cheers for that. It’s a bit annoying that he defaulted everything to have a 6++ Ward but factoring that into my calculations is allowing me to cross reference my results against his
|
|
|
Post by strutsagget on May 21, 2020 20:54:33 GMT
Awesome, do you have the chart?
|
|
|
Post by FvonSigmaringen on May 21, 2020 21:28:35 GMT
It is in the linked dropbox.
|
|
|
Post by knoffles on May 21, 2020 23:02:38 GMT
This is my version. It has a few fixed tables (where you can enter the wood elf unit size to adjust the stats). The second page allows you to enter: - Wood Elf unit size (manually key the size)
- Targets Toughness (1-10 from a drop down)
- Targets Armour (1+ to 0/none from a drop down)
- Targets Ward (2++ to 0/none from a drop down)
- Any 'to-hit' modifiers (+2 to -4 from a drop down)
This should then generate the probable damage for each of the different arrows/waystalker shots, based on the variables entered. Happy to take any feedback. www.dropbox.com/s/cwdgw0bhcnvz4la/Knoffles_Wood_Elf_ArrowChart.xlsx?dl=0
|
|
|
Post by strutsagget on May 22, 2020 7:43:01 GMT
It is in the linked dropbox. No not the jpg image, the real chart/spreadsheet/excel file?
|
|
|
Post by knoffles on May 22, 2020 7:59:55 GMT
It is in the linked dropbox. No not the jpg image, the real chart/spreadsheet/excel file? On the Asrai site, the chap only posts a jpg, not the excel file.
|
|