How to Automate a Non-Standard Aerospace Standard BOM

I just started working for a company that has an interesting looking aerospace/military style BOM that they're not willing to change.  I guess they think it worked well in Autocad and CADDS, so why should it change just because SW automated BOMS don't follow the standard?  Anyhow, here are the rules:

  1. The first line(s) are reserved for each dash number variant (configuration) of the assembly, even if there is only one dash number.
  2. Each dash number variant requires its own column for qty (this is the only part SW can do automatically).
  3. The Part Number column reports part number for assembly components, but reports dash number for the first line(s) mentioned previously.
  4. Each dash number line must have its respective qty cell crossed out.

I've attached an example screenshot.  Hopefully, someone else out there has had some experience automating this type of BOM.  If not then I'll be having lots of fun with manual BOM details like:

  • Each dash number row must be added manually
  • The Part Number field for each dash number row must be manually edited to read "-1", "-2", etc
  • Each crossed out cell has to be done manually using sketch lines since SW won't do Excel style crossouts.
  • Make sure the item numbers are correct since dash numbers use up item numbers.

On a side note, every part drawing has to have a BOM as well that's basically a design table.  I'm sure I can finagle a way to take care of displaying different materials/dims for each config, but if anyone has a proven method I'd be happy to test it out.

Thanks.

SolidworksBill Of Materials