Wood Perforated Shear Wall Design

This is nice, but what are the forces around the opening? Is it possible to get this information?

What it is New in this Version?
If it is an update?
S.Vega

I like the look of the spreadsheet. How did you create the graphics? They don't appear to be excel drawing tools.
Why have so much of the calculation buried in hidden columns? Wouldn't it be more meaningful for a reviewer, i.e. city, county or state plans examiner, to see all of the calculations that go into F. The comments have a lot of useful information in them, but none of that will show up when the sheet is printed out to submit to the plans examiner.
Several of your equations appear to be a special function called embed. Is this an excel function or from an add-in?
Have you considered highlighting the cells that require input to differentiate them from calculated results? Any thoughts of including the shear tables?

The program allows for an unlimited number of segments. The segments can be of any size that does not violate the aspect ratio. The figure is only presented as an example of the application.