As the title says I got bored. I decided to do a little excel project to calculate the average damage on a ranged attack for each damage category.
It has 5 tabs, one for each damage category and a column on the right to enter SAL, BRa, World bias level, Personal bias level, hand/eye, intuition, targets density, agility, intuition, will power, resistance, and stamina.
With that information it calculates the % chance to hit, the avg damage on an attack (it ignores damage category bumps, you have to click the right tab), your RSV and the opponents TV and DV. I made it so that when making an NPC I can figure out how deadly I want to make it.
I posted it here:
https://spreadsheets.google.com/ccc?key=0Ap6ZkjMZe6UCdDFYQV9yN0hnY3c0ZkNPTHZHVkIzaHc&hl=en&authkey=CL-PyqUP
Just download it to an excel sheet and let me know what you think.
I like working with excel, if anyone wants me to do something similar on something else I'm willing to give it a go. I think I'm going to try and create a martial arts one now.