Tau Empire Codex 2013 | Army Builder Program
Dark Angels Codex 2013
Chaos Daemons Codex 2013
Chaos Space Marines Codex 2012

Warhammer 40k Forum Tau Online

 

Warhammer 40K Forum

Kills of the Crisis Part Three: Monsterous Creatures-Completed
Reply
Old 10 Mar 2008, 10:48   #1 (permalink)
Shas'Vre
 
Join Date: Sep 2006
Location: Victoria, Australia
Posts: 1,750
Default Kills of the Crisis Part Three: Monsterous Creatures-Completed

Third and final part of a guide I've created over a long period of time, telling the average wounds a crisis suit will put onto a wide range of monstrous creatures.
Part one and two can be found here and here
As yet this is unfinished, as I ran out of time. Should be finished tomorrow, with all possible weapon combinations and twinlinked.


[hr]
Single Weapons
[hr]

Plasma Rifle
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4 0.44 0.44 0.333333333 0.333333333 0.22 0.22 0.106666667 0.053333333
BS5 0.55 0.55 0.416666667 0.416666667 0.275 0.275 0.133333333 0.066666667
Plasma Rifle Rapid Fire
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3 0.665 0.665 0.5 0.5 0.33 0.5 0.5 0.08
BS4 0.88667 0.88667 0.66667 0.66667 0.44 0.44 0.22 0.106667
BS5 0.443 0.443 0.333 0.33 0.22 0.3330.333333333 0.053333333

Fusion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3 0.415 0.415 0.415 0.415 0.33 0.33 0.25 0.125
BS4 0.553 0.553 0.553 0.553 0.44 0.44 0.333 0.166
BS5 0.691 0.691 0.6916 0.691 0.55 0.55 0.416 0.208333333

Missile Pod
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4 0.36 0.173 0.2933 0.1467 0.2133 0.1067 0.1467 0.1733
BS5 0.45 0.2667 0.367 0.183 0.266 0.1333 0.1833 0.2167

Burst Cannon
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3
BS3 0.25 0.125 0.125 0.0825 0.085 0.425 0.425
BS4 0.3333 0.1667 0.167 0.11 0.11 0.55 0.55
BS5 0.4167 0.2333 0.203 0.1375 0.135 0.6875 0.685

Flamer
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2
0.11 0.055 0.055 0.0275 0.0255 0.01275

Airbursting Fragmentation Projector
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2
0.11 0.055 0.055 0.0275 0.0255 0.01275

Cyclic Ion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2
BS3 0.415 0.415 0.415 0.415
BS4 0.533 0.553 0.553 0.553
BS5 0.691 0.691 0.691 0.691

[hr]
Twinlinked Weapons
[hr]

Plasma Rifle
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3 0.495 0.495 0.375 0.375 0.2475 0.2475 0.12 0.06
BS5 0.586 0.586 0.444 0.444 0.293 0.293 0.142 0.071
BS5 0.641 0.641 0.486 0.486 0.320 0.320 0.155 0.077
Plasma Rifle Rapidfire
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3 0.9975 0.9975 0.75 0.75 0.495 0.495 0.2475 0.12
BS4 1.182 1.182 0.888 0.888 0.586 0.586 0.293 0.142
BS5 1.293 1.293 0.972 0.972 0.641 0.641 0.320 0.155

Fusion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3 0.622 0.622 0.622 0.622 0.495 0.495 0.375 0.1875
BS4 0.737 0.737 0.737 0.737 0.586 0.586 0.444 0.222
BS5 0.806 0.806 0.806 0.806 0.641 0.641 0.486 0.243

Missile Pod
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3 0.405 0.195 0.33 0.165 0.24 0.12 0.165 0.195
BS4 0.48 0.231 0.391 0.195 0.284 0.142 0.195 0.231
BS5 0.525 0.252 0.427 0.213 0.311 0.155 0.213 0.252

Burst Cannon
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3 0.375 0.187 0.187 0.123 0.123 0.061 0.061 0.123
BS4 0.444 0.222 0.222 0.146 0.146 0.073 0.073 0.146
BS5 0.486 0.243 0.243 0.160 0.160 0.080 0.080 0.160

Flamer
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
0.183 0.091 0.101 0.050 0.101 0.0509 0 0
Korill is offline   Reply With Quote
Old 12 Mar 2008, 07:13   #2 (permalink)
Shas'Vre
 
Join Date: Sep 2006
Location: Victoria, Australia
Posts: 1,750
Default Re: Kills of the Crisis Part Three: Monsterous Creatures (Twinlinked Done)

Plasma Rifle Combinations
[hr]

Plasma Rifle and Fusion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-24" 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4-24" 0.44 0.44 0.333 0.333 0.22 0.22 0.106 0.053
BS5-24" 0.55 0.55 0.416 0.416 0.275 0.275 0.133 0.066
BS3-12" 1.08 1.08 0.915 0.915 0.66 0.83 0.75 0.205
BS4-12" 1.44 1.44 1.22 1.22 0.88 0.88 0.553 0.273
BS5-12" 1.135 1.135 1.025 1.025 0.77 0.883 0.75 0.261

Plasma Rifle and Missile Pod
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.147 0.213 0.107 0.147 0.173
BS5-36" 0.45 0.217 0.367 0.183 0.267 0.133 0.183 0.217
BS3-24" 0.6 0.46 0.47 0.36 0.325 0.245 0.19 0.17
BS4-24" 0.8 0.613 0.626 0.480 0.433 0.327 0.253 0.226
BS5-24" 1 0.767 0.783 0.599 0.542 0.408 0.31 0.28
BS3-12" 0.935 0.795 0.72 0.61 0.49 0.58 0.61 0.21
BS4-12" 1.246 1.05 0.957 0.813 0.653 0.547 0.367 0.279
BS5-12" 0.893 0.660 0.700 0.516 0.487 0.466 0.516 0.270

Plasma Rifle and Burst Cannon
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-24" 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4-24" 0.44 0.44 0.333 0.333 0.22 0.22 0.106 0.053
BS5-24" 0.55 0.55 0.416 0.416 0.275 0.275 0.133 0.066
BS3-18" 0.58 0.455 0.375 0.332 0.247 0.206 0.121 0.122
BS4-18" 0.773 0.606 0.5 0.443 0.33 0.275 0.161 0.163
BS5-18" 0.967 0.758 0.625 0.554 0.412 0.343 0.202 0.204
BS3-12" 1.58 1.455 1.125 1.082 0.742 0.701 0.371 0.242
BS4-12" 0.998 0.831 0.666 0.61 0.44 0.555 0.555 0.19
BS5-12" 1.303 1.095 0.875 0.804 0.577 0.508 0.288 0.244

Plasma Rifle and Flamer
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-24" 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4-24" 0.44 0.44 0.333 0.333 0.22 0.22 0.106 0.053
BS5-24" 0.55 0.55 0.416 0.416 0.275 0.275 0.133 0.067
BS3-12" 1.33 1.33 1 1 0.66 0.66 0.33 0.16
BS4-12" 0.665 0.665 0.5 0.5 0.33 0.5 0.5 0.08
BS5-12" 0.886 0.886 0.666 0.666 0.44 0.44 0.22 0.106
BS3-8" 1.44 1.385 1.055 1.027 0.715 0.687 0.33 0.16
BS4-8" 0.775 0.72 0.555 0.5275 0.385 0.527 0.5 0.08
BS5-8" 0.996 0.941 0.721 0.694 0.495 0.4675 0.22 0.1066

Plasma Rifle and Airbursting Fragmentation Projector
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-24" 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4-24" 0.44 0.44 0.333 0.333 0.22 0.22 0.106 0.053
BS5-24" 0.55 0.55 0.416 0.416 0.275 0.275 0.133 0.066
BS3-18" 0.44 0.385 0.305 0.275 0.19 0.177 0.08 0.04
BS4-18" 0.55 0.495 0.388 0.36 0.245 0.232 0.106 0.053
BS5-18" 0.66 0.605 0.471 0.444 0.3 0.287 0.133 0.066
BS3-12" 0.77 0.72 0.555 0.527 0.355 0.512 0.5 0.08
BS4-12" 0.996 0.941 0.721 0.694 0.465 0.452 0.22 0.106
BS5-12" 0.553 0.498 0.388 0.360 0.245 0.346 0.333 0.053

Plasma Rifle and Cyclic Ion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-24" 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4-24" 0.44 0.44 0.333 0.333 0.22 0.22 0.106 0.053
BS5-24" 0.55 0.55 0.416 0.4167 0.275 0.275 0.133 0.066
BS3-18" 0.745 0.745 0.665 0.665 0.165 0.165 0.08 0.04
BS4-18" 0.993 0.993 0.886 0.886 0.22 0.22 0.106 0.0533
BS5-18" 1.241 1.241 1.108 1.108 0.275 0.275 0.133 0.066
BS3-12" 1.08 1.08 0.915 0.915 0.33 0.5 0.5 0.08
BS4-12" 1.44 1.44 1.22 1.22 0.44 0.44 0.22 0.106
BS5-12" 1.135 1.135 1.025 1.025 0.22 0.333 0.3333 0.053

[hr]
Fusion Blaster Combinations
[hr]

Fusion Blaster and Plasma Rifle
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-24" 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4-24" 0.44 0.44 0.333 0.333 0.22 0.22 0.106 0.053
BS5-24" 0.55 0.55 0.416 0.416 0.275 0.275 0.133 0.066
BS3-12" 1.08 1.08 0.915 0.915 0.66 0.83 0.75 0.205
BS4-12" 1.44 1.44 1.22 1.22 0.88 0.88 0.553 0.273
BS5-12" 1.135 1.135 1.025 1.025 0.77 0.883 0.75 0.261

Fusion Blaster and Missile Pod
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-36" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-12" 0.685 0.545 0.635 0.525 0.49 0.41 0.36 0.255
BS4-12" 0.913 0.726 0.846 0.7 0.653 0.546 0.48 0.34
BS5-12" 1.146 0.908 1.058 0.875 0.816 0.683 0.6 0.425

Fusion Blaster and Burst Cannon
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.25 0.125 0.125 0.082 0.082 0.041 0.041 0.082
BS4-18" 0.333 0.166 0.166 0.11 0.11 0.055 0.055 0.11
BS5-18" 0.416 0.208 0.208 0.137 0.137 0.068 0.068 0.137
BS3-12" 0.665 0.54 0.54 0.497 0.412 0.371 0.291 0.207
BS4-12" 0.886 0.72 0.72 0.663 0.55 0.495 0.388 0.276
BS5-12" 1.108 0.9 0.9 0.829 0.687 0.618 0.485 0.345

Fusion Blaster and Flamer
t5 SV 3t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-12" 0.415 0.415 0.415 0.415 0.33 0.33 0.25 0.125
BS4-12" 0.553 0.553 0.553 0.553 0.44 0.44 0.333 0.166
BS5-12" 0.691 0.691 0.691 0.691 0.55 0.55 0.416 0.208
BS3-8" 0.525 0.47 0.47 0.442 0.385 0.357 0.25 0.125
BS4-8 0.663 0.608 0.608 0.580 0.495 0.467 0.333 0.166
BS5-8" 0.801 0.746 0.746 0.719 0.605 0.577 0.416 0.208

Fusion Blaster and Airbursting Fragmentation Projector
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.11 0.055 0.055 0.027 0.025 0.012 0 0
BS4-18" 0.11 0.055 0.055 0.027 0.025 0.0127 0 0
BS5-18" 0.11 0.055 0.055 0.027 0.025 0.0127 0 0
BS3-12" 0.525 0.47 0.47 0.442 0.385 0.357 0.25 0.125
BS4-12" 0.663 0.608 0.608 0.580 0.495 0.467 0.333 0.166
BS5-12" 0.801 0.746 0.746 0.719 0.605 0.577 0.416 0.208

Fusion Blaster and Cyclic Ion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.415 0.415 0.415 0.415 0 0 0 0
BS4-18" 0.553 0.553 0.553 0.553 0 0 0 0
BS5-18" 0.691 0.691 0.691 0.691 0 0 0 0
BS3-12" 0.83 0.83 0.83 0.83 0.33 0.33 0.25 0.125
BS4-12" 1.106 1.106 1.106 1.106 0.44 0.44 0.333 0.166
BS5-12" 1.383 1.383 1.383 1.383 0.55 0.55 0.416 0.208
Korill is offline   Reply With Quote
Old 12 Mar 2008, 07:48   #3 (permalink)
Shas'Saal
 
Join Date: Feb 2008
Location: NYC
Posts: 164
Send a message via AIM to YakmastermaxIG
Default Re: Kills of the Crisis Part Three: Monsterous Creatures-FB,PR,TL combinations done

wow impresive. although ive never had to deal with a monstrouse creature before with crisis suits. i leave them to the mercy of the broadsides.
__________________
"Out, out, brief candle! Life's but a walking shadow, a poor player that struts and frets his hour upon the stage and then is heard no more: it is a tale told by an idiot, full of sound and fury, signifying nothing"

"due to my retardivity" - myself

"never argue with an idiot, they will only bring you down to thier level, and beat you with experience"
YakmastermaxIG is offline   Reply With Quote
Old 12 Mar 2008, 08:21   #4 (permalink)
AC
Shas'Ui
 
Join Date: Feb 2008
Location: Scotland
Posts: 751
Default Re: Kills of the Crisis Part Three: Monsterous Creatures-FB,PR,TL combinations d

WOW. How long did that take you?
__________________
Exitus Acta Probat "the Outcome justifies the Deed"
- Vindicare Assassin Temple Motto

There are three things that matter in marksmanship. Location, Location, Location - Vindicare Assassin Training Dogma.

I do not know what World War Three will be fought with, but I know that World War Four will be fought with sticks and stones - Albert Einstein

Semper Fi
AC is offline   Reply With Quote
Old 12 Mar 2008, 08:47   #5 (permalink)
Shas'Vre
 
Join Date: Sep 2006
Location: Victoria, Australia
Posts: 1,750
Default Re: Kills of the Crisis Part Three: Monsterous Creatures-FB,PR,TL combinations d

Not that long. Thanks to excels formulas it was mostly just copy pasting things like =SUM(A3,A50). Took a bit to get the kills for individual weapons. Longest part now is deleting the extra numbers, as excel rounds to nine decimal places, which i need to delete. Probably been 3-4 hours so far, won't take long to copy/paste the rest of my database into this post. Maybe 45 minutes.

Part 1 was really long, as I didn't know much about excel at the time, and I used a calculator to individually work out each individual number. Painful.

[hr]
Missile Pod Combinations
[hr]

Missile Pod and Plasma Rifle
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.147 0.213 0.107 0.147 0.173
BS5-36" 0.45 0.217 0.367 0.183 0.267 0.133 0.183 0.217
BS3-24" 0.6 0.46 0.47 0.36 0.325 0.245 0.19 0.17
BS4-24" 0.8 0.613 0.626 0.480 0.433 0.327 0.253 0.226
BS5-24" 1 0.767 0.783 0.599 0.542 0.408 0.31 0.28
BS3-12" 0.935 0.795 0.72 0.61 0.49 0.58 0.61 0.21
BS4-12" 1.246 1.05 0.957 0.813 0.653 0.547 0.367 0.279
BS5-12" 0.893 0.660 0.700 0.516 0.487 0.466 0.516 0.270

Missile Pod and Fusion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-36" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-12" 0.685 0.545 0.635 0.525 0.49 0.41 0.36 0.255
BS4-12" 0.913 0.726 0.846 0.7 0.653 0.546 0.48 0.34
BS5-12" 1.146 0.908 1.058 0.875 0.816 0.683 0.6 0.425

Missile Pod and Burst Cannon
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-36" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-18" 0.52 0.255 0.345 0.192 0.242 0.121 0.151 0.212
BS4-18" 0.693 0.34 0.46 0.256 0.323 0.161 0.201 0.283
BS5-18" 0.866 0.425 0.575 0.320 0.404 0.202 0.252 0.354

Missile Pod and Flamer
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-36" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-8" 0.38 0.185 0.275 0.1375 0.215 0.1075 0.11 0.13
BS4-8" 0.47 0.228 0.348 0.174 0.268 0.134 0.146 0.173
BS5-8" 0.56 0.271 0.421 0.210 0.321 0.160 0.183 0.216

Missile Pod and Airbursting Fragmentation Projector
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-36" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-18" 0.38 0.185 0.275 0.137 0.185 0.092 0.11 0.13
BS4-18" 0.47 0.228 0.348 0.174 0.238 0.119 0.146 0.173
BS5-18" 0.56 0.271 0.421 0.210 0.292 0.146 0.183 0.216

Missile Pod and Cyclic Ion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-36" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-18" 0.685 0.545 0.635 0.525 0.16 0.08 0.11 0.13
BS4-18" 0.913 0.726 0.846 0.7 0.213 0.106 0.146 0.173
BS5-18" 1.141 0.908 1.058 0.875 0.266 0.133 0.183 0.216

[hr]
Burst Cannon Combinations
[hr]

Burst Cannon and Plasma Rifle
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-24" 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4-24" 0.44 0.44 0.333 0.333 0.22 0.22 0.106 0.053
BS5-24" 0.55 0.55 0.416 0.416 0.275 0.275 0.133 0.066
BS3-18" 0.58 0.455 0.375 0.332 0.247 0.206 0.121 0.122
BS4-18" 0.773 0.606 0.5 0.443 0.33 0.275 0.161 0.163
BS5-18" 0.967 0.758 0.625 0.554 0.412 0.343 0.202 0.204
BS3-12" 1.58 1.455 1.125 1.082 0.742 0.701 0.371 0.242
BS4-12" 0.998 0.831 0.666 0.61 0.44 0.555 0.555 0.19
BS5-12" 1.303 1.095 0.875 0.804 0.577 0.508 0.288 0.244

Burst Cannon and Fusion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.25 0.125 0.125 0.082 0.082 0.041 0.041 0.082
BS4-18" 0.333 0.166 0.166 0.11 0.11 0.055 0.055 0.11
BS5-18" 0.416 0.208 0.208 0.137 0.137 0.068 0.068 0.137
BS3-12" 0.665 0.54 0.54 0.497 0.412 0.371 0.291 0.207
BS4-12" 0.886 0.72 0.72 0.663 0.55 0.495 0.388 0.276
BS5-12" 1.108 0.9 0.9 0.829 0.687 0.618 0.485 0.345

Burst Cannon and Missile Pod
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-36" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-18" 0.52 0.255 0.345 0.192 0.242 0.121 0.151 0.212
BS4-18" 0.693 0.34 0.46 0.256 0.323 0.161 0.201 0.283
BS5-18" 0.866 0.425 0.575 0.320 0.404 0.202 0.252 0.354

Burst Cannon and Flamer
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-18" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-18" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-8" 0.36 0.18 0.18 0.11 0.137 0.068 0.041 0.082
BS4-8" 0.443 0.221 0.221 0.137 0.165 0.082 0.055 0.11
BS5-8" 0.526 0.263 0.263 0.165 0.192 0.096 0.068 0.137

Burst Cannon and Airbursting Fragmentation Projector
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.36 0.18 0.18 0.11 0.108 0.054 0.041 0.082
BS4-18" 0.443 0.221 0.221 0.137 0.135 0.067 0.055 0.11
BS5-18" 0.526 0.263 0.263 0.165 0.163 0.081 0.0687 0.137

Burst Cannon and Cyclic Ion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.665 0.54 0.54 0.497 0.082 0.041 0.041 0.082
BS4-18" 0.886 0.72 0.72 0.663 0.11 0.055 0.055 0.11
BS5-18" 1.108 0.9 0.9 0.829 0.137 0.068 0.068 0.137
Korill is offline   Reply With Quote
Old 13 Mar 2008, 08:14   #6 (permalink)
Shas'Vre
 
Join Date: Sep 2006
Location: Victoria, Australia
Posts: 1,750
Default Re: Kills of the Crisis Part Three: Monsterous Creatures-FB,PR,MP,BC,TL done

Flamer Combinations
[hr]

Flamer and Plasma Rifle
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-24" 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4-24" 0.44 0.44 0.333 0.333 0.22 0.22 0.106 0.053
BS5-24" 0.55 0.55 0.416 0.416 0.275 0.275 0.133 0.067
BS3-12" 1.33 1.33 1 1 0.66 0.66 0.33 0.16
BS4-12" 0.665 0.665 0.5 0.5 0.33 0.5 0.5 0.08
BS5-12" 0.886 0.886 0.666 0.666 0.44 0.44 0.22 0.106
BS3-8" 1.44 1.385 1.055 1.027 0.715 0.687 0.33 0.16
BS4-8" 0.775 0.72 0.555 0.5275 0.385 0.527 0.5 0.08
BS5-8" 0.996 0.941 0.721 0.694 0.495 0.4675 0.22 0.1066

Flamer and Fusion Blaster
t5 SV 3t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-12" 0.415 0.415 0.415 0.415 0.33 0.33 0.25 0.125
BS4-12" 0.553 0.553 0.553 0.553 0.44 0.44 0.333 0.166
BS5-12" 0.691 0.691 0.691 0.691 0.55 0.55 0.416 0.208
BS3-8" 0.525 0.47 0.47 0.442 0.385 0.357 0.25 0.125
BS4-8 0.663 0.608 0.608 0.580 0.495 0.467 0.333 0.166
BS5-8" 0.801 0.746 0.746 0.719 0.605 0.577 0.416 0.208

Flamer and Missile Pod
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-36" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-8" 0.38 0.185 0.275 0.1375 0.215 0.1075 0.11 0.13
BS4-8" 0.47 0.228 0.348 0.174 0.268 0.134 0.146 0.173
BS5-8" 0.56 0.271 0.421 0.210 0.321 0.160 0.183 0.216

Flamer and Burst Cannon
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-18" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-18" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-8" 0.36 0.18 0.18 0.11 0.137 0.068 0.041 0.082
BS4-8" 0.443 0.221 0.221 0.137 0.165 0.082 0.055 0.11
BS5-8" 0.526 0.263 0.263 0.165 0.192 0.096 0.068 0.137

Flamer and Airbursting Fragmentation Projector
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2
18" 0.11 0.055 0.055 0.027 0.025 0.012
8" 0.22 0.11 0.11 0.055 0.080 0.040

Flamer and Cyclic Ion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2
BS3-18" 0.415 0.415 0.415 0.415 0 0
BS4-18" 0.553 0.553 0.553 0.553 0 0
BS5-18" 0.691 0.691 0.691 0.691 0 0
BS3-8" 0.525 0.47 0.47 0.442 0.055 0.027
BS4-8" 0.663 0.608 0.608 0.580 0.055 0.027
BS5-8" 0.801 0.746 0.746 0.719 0.055 0.027

[hr]
Airbursting Fragmentation Projector Combinations
[hr]

Airbursting Fragmentation Projector and Plasma Rifle
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-24" 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4-24" 0.44 0.44 0.333 0.333 0.22 0.22 0.106 0.053
BS5-24" 0.55 0.55 0.416 0.416 0.275 0.275 0.133 0.066
BS3-18" 0.44 0.385 0.305 0.275 0.19 0.177 0.08 0.04
BS4-18" 0.55 0.495 0.388 0.36 0.245 0.232 0.106 0.053
BS5-18" 0.66 0.605 0.471 0.444 0.3 0.287 0.133 0.066
BS3-12" 0.77 0.72 0.555 0.527 0.355 0.512 0.5 0.08
BS4-12" 0.996 0.941 0.721 0.694 0.465 0.452 0.22 0.106
BS5-12" 0.553 0.498 0.388 0.360 0.245 0.346 0.333 0.053

Airbursting Fragmentation Projector and Fusion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.11 0.055 0.055 0.027 0.025 0.012 0 0
BS4-18" 0.11 0.055 0.055 0.027 0.025 0.0127 0 0
BS5-18" 0.11 0.055 0.055 0.027 0.025 0.0127 0 0
BS3-12" 0.525 0.47 0.47 0.442 0.385 0.357 0.25 0.125
BS4-12" 0.663 0.608 0.608 0.580 0.495 0.467 0.333 0.166
BS5-12" 0.801 0.746 0.746 0.719 0.605 0.577 0.416 0.208

Airbursting Fragmentation Projector and Missile Pod
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-36" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-18" 0.38 0.185 0.275 0.137 0.185 0.092 0.11 0.13
BS4-18" 0.47 0.228 0.348 0.174 0.238 0.119 0.146 0.173
BS5-18" 0.56 0.271 0.421 0.210 0.292 0.146 0.183 0.216

Airbursting Fragmentation Projector and Burst Cannon
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.36 0.18 0.18 0.11 0.108 0.054 0.041 0.082
BS4-18" 0.443 0.221 0.221 0.137 0.135 0.067 0.055 0.11
BS5-18" 0.526 0.263 0.263 0.165 0.163 0.081 0.0687 0.137

Airbursting Fragmentation Projector and Cyclic Ion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2
BS3-18" 0.525 0.47 0.47 0.442 0.0255 0.012
BS4-18" 0.663 0.608 0.608 0.580 0.0255 0.012
BS5-18" 0.801 0.746 0.746 0.719 0.0255 0.012

[hr]
Cyclic Ion Blaster Combinations
[hr]

Cyclic Ion Blaster and Plasma Rifle
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-24" 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4-24" 0.44 0.44 0.333 0.333 0.22 0.22 0.106 0.053
BS5-24" 0.55 0.55 0.416 0.4167 0.275 0.275 0.133 0.066
BS3-18" 0.745 0.745 0.665 0.665 0.165 0.165 0.08 0.04
BS4-18" 0.993 0.993 0.886 0.886 0.22 0.22 0.106 0.0533
BS5-18" 1.241 1.241 1.108 1.108 0.275 0.275 0.133 0.066
BS3-12" 1.08 1.08 0.915 0.915 0.33 0.5 0.5 0.08
BS4-12" 1.44 1.44 1.22 1.22 0.44 0.44 0.22 0.106
BS5-12" 1.135 1.135 1.025 1.025 0.22 0.333 0.3333 0.053

Cyclic Ion Blaster and Fusion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.415 0.415 0.415 0.415 0 0 0 0
BS4-18" 0.553 0.553 0.553 0.553 0 0 0 0
BS5-18" 0.691 0.691 0.691 0.691 0 0 0 0
BS3-12" 0.83 0.83 0.83 0.83 0.33 0.33 0.25 0.125
BS4-12" 1.106 1.106 1.106 1.106 0.44 0.44 0.333 0.166
BS5-12" 1.383 1.383 1.383 1.383 0.55 0.55 0.416 0.208

Cyclic Ion Blaster and Missile Pod
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-36" 0.27 0.13 0.22 0.11 0.16 0.08 0.11 0.13
BS4-36" 0.36 0.173 0.293 0.146 0.213 0.106 0.146 0.173
BS5-36" 0.45 0.216 0.366 0.183 0.266 0.133 0.183 0.216
BS3-18" 0.685 0.545 0.635 0.525 0.16 0.08 0.11 0.13
BS4-18" 0.913 0.726 0.846 0.7 0.213 0.106 0.146 0.173
BS5-18" 1.141 0.908 1.058 0.875 0.266 0.133 0.183 0.216

Cyclic Ion Blaster and Burst Cannon
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-18" 0.665 0.54 0.54 0.497 0.082 0.041 0.041 0.082
BS4-18" 0.886 0.72 0.72 0.663 0.11 0.055 0.055 0.11
BS5-18" 1.108 0.9 0.9 0.829 0.137 0.068 0.068 0.137

Cyclic Ion Blaster and Flamer
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2
BS3-18" 0.415 0.415 0.415 0.415 0 0
BS4-18" 0.553 0.553 0.553 0.553 0 0
BS5-18" 0.691 0.691 0.691 0.691 0 0
BS3-8" 0.525 0.47 0.47 0.442 0.055 0.027
BS4-8" 0.663 0.608 0.608 0.580 0.055 0.027
BS5-8" 0.801 0.746 0.746 0.719 0.055 0.027

Cyclic Ion Blaster and Airbursting Fragmentation Projector
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2
BS3-18" 0.525 0.47 0.47 0.442 0.0255 0.012
BS4-18" 0.663 0.608 0.608 0.580 0.0255 0.012
BS5-18" 0.801 0.746 0.746 0.719 0.0255 0.012
Korill is offline   Reply With Quote
Old 13 Mar 2008, 09:24   #7 (permalink)
Kroot Warrior
 
Join Date: Dec 2007
Posts: 12
Default Re: Kills of the Crisis Part Three: Monsterous Creatures-Completed

If you put this around the formula:

=round((insert formula here),3)

That will round it to the decimal places for you ;D
Vaughany is offline   Reply With Quote
Old 13 Mar 2008, 09:52   #8 (permalink)
Shas'Vre
 
Join Date: Sep 2006
Location: Victoria, Australia
Posts: 1,750
Default Re: Kills of the Crisis Part Three: Monsterous Creatures-Completed

Ah well, its finished now and I won't be doing another part, unless 5th edition invents some strange unit type that doesn't follow any of the current rules.

But that formula would've saved me a lot of time.
Korill is offline   Reply With Quote
Old 14 Mar 2008, 13:06   #9 (permalink)
Shas'Saal
 
Join Date: Mar 2007
Posts: 176
Default Re: Kills of the Crisis Part Three: Monsterous Creatures-Completed

Korill,

do you have the Excel sheet original somewhere and do you care to share it?

J.
__________________
Tau army builders - click here: Eal'ta - Excel Army List for Tau Army
Joeyeti is offline   Reply With Quote
Old 14 Mar 2008, 13:35   #10 (permalink)
Shas'La
 
Join Date: Feb 2008
Posts: 256
Default Re: Kills of the Crisis Part Three: Monsterous Creatures-Completed

Just curious as to why a Plasma rifle with BS 5 has less chance to hit than the same weapon at lower BS on alot of these..... is it a typo ? ???

EX.
Quote:
Plasma Rifle Rapid Fire
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS4 0.88667 0.88667 0.66667 0.66667 0.44 0.44 0.22 0.106667
BS5 0.443 0.443 0.333 0.33 0.22 0.3330.333333333 0.053333333
Quote:
Fusion Blaster and Plasma Rifle
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-12" 1.08 1.08 0.915 0.915 0.66 0.83 0.75 0.205
BS4-12" 1.44 1.44 1.22 1.22 0.88 0.88 0.553 0.273
BS5-12" 1.135 1.135 1.025 1.025 0.77 0.883 0.75 0.261
Quote:
Plasma Rifle and Cyclic Ion Blaster
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-12" 1.08 1.08 0.915 0.915 0.33 0.5 0.5 0.08
BS4-12" 1.44 1.44 1.22 1.22 0.44 0.44 0.22 0.106
BS5-12" 1.135 1.135 1.025 1.025 0.22 0.333 0.3333 0.053
Quote:
Plasma Rifle and Airbursting Fragmentation Projector
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS4-12" 0.996 0.941 0.721 0.694 0.465 0.452 0.22 0.106
BS5-12" 0.553 0.498 0.388 0.360 0.245 0.346 0.333 0.053
Quote:
Plasma Rifle and Missile Pod
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS4-12" 1.246 1.05 0.957 0.813 0.653 0.547 0.367 0.279
BS5-12" 0.893 0.660 0.700 0.516 0.487 0.466 0.516 0.270
Quote:
Flamer and Plasma Rifle
t5 SV 3 t5 sv 2 t6 sv3 t6 sv 2 t7 sv3 s7 sv2 t8 sv3 t8 sv 4+inv
BS3-24" 0.33 0.33 0.25 0.25 0.165 0.165 0.08 0.04
BS4-24" 0.44 0.44 0.333 0.333 0.22 0.22 0.106 0.053
BS5-24" 0.55 0.55 0.416 0.416 0.275 0.275 0.133 0.067
BS3-12" 1.33 1.33 1 1 0.66 0.66 0.33 0.16
BS4-12" 0.665 0.665 0.5 0.5 0.33 0.5 0.5 0.08
BS5-12" 0.886 0.886 0.666 0.666 0.44 0.44 0.22 0.106
BS3-8" 1.44 1.385 1.055 1.027 0.715 0.687 0.33 0.16
BS4-8" 0.775 0.72 0.555 0.5275 0.385 0.527 0.5 0.08
BS5-8" 0.996 0.941 0.721 0.694 0.495 0.4675 0.22 0.1066
Just figure I'd say something since it seems to only affect Plasma Rifle and Plasma Rifle Combos.
The Gear Mechanic is offline   Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
9 Tyranid Monsterous creatures in 1500pts and 1 FoC.... Gareth Tyranids 10 04 Jan 2008 13:54
Kills of a Crisis, Part 2 VS Vehicles Korill Tau 2 12 Aug 2007 12:40
Kills of the Crisis, Part One: VS Infantry Korill Tau 6 01 Aug 2007 17:21
Crisis suit kills lictor & FW almost takes down Hive Tyrant Falconrider Tau 21 05 Apr 2007 01:28
11 Monsterous Creatures Converted up GreyDeath Conversion 14 16 Dec 2005 19:16