Quote:
Originally Posted by pmulcahy11b
I need some Excel books (preferably Excel 360 books, and online, or as least use the .xlsx and .XLSM extensions). What I'd like is to modify the existing worksheets, or preferably, make my own spreadsheets. I have what I think are some good ideas, but don't have a clue as to how to implement them.
Anybody have any ideas for online books or tutorials for this?
|
I'm interested and available to help. Are you still looking for help? (
Vlookup, Index(Match) and
SumIf are probably formulas that can help.)
Have similarly been tinkering with excel and have reached the point where building the data tables are necessary next steps. Currently working on a calculator the PC could use to support the calculations for automatic fire - recoil, range, dice removed, RoF, burst size, strength, small arms asset, etc. are all variables that could be plugged into excel to help resolve the action.
Does anyone have the weapons data in tabular format ... if not, no worries ... I'll get to typing.