I'm having trouble coming up with a good way to calculate firing arc mods in a spreadsheet (Google Docs, though I also have Excel if that ends up being the only way to do it).
My data has the number of weapons in the battery in one column, and the next column has the arcs (i.e. 4 | FH2,PH3,SH3)

I want some way to calculate the firing arc multipliers so I can calculate battery (and therefore ship) ORAT.

I've already put in over 150 ship designs with firing arcs (converting ships from my Star Fleet Battles collection) so I'm loathe to manually put in each design into the drydock to do the calculations for me.

Any ideas or suggestions?