This is a spreadsheet I developed to easily figure out loads on individual beams as well as the total load on the roof. I originally wrote this in a NUMBERS format and I still have a few bugs to figure out, but it is still functional. I was really hoping to get it all functioning but there is still one formula I can’t get to transpose correctly. If you send me an email I’m happy to share the fully functioning NUMBERS version.

I’ll start by saying, I originally developed this just to make my life easier, it’s based on my buildings roof which has equal height beams and most of the bridles run on and off stage. The system will work best with a similar roof but I’ve found it useful in arched roof and truss situations as well. I think it serves as a solid base with room for customization. It's not particularly intuitive at first but its very simple to use once you understand it. Its based on Cartesian coordinates so you should familiarize yourself with that system first.

Once you have clicked on the link to open a blank RLC(Roof Load Calculator), open a copy and work from that. There will be default beam information that you will replace with your venue information. Click on the tab on the bottom labeled Beam Table X. Cell A2 will be your first beam on the X axis(furthest left of center). You can name it whatever you choose, e.g. Beam 1, Truss 1, 6, etc. Cell B2 will be the location of  your furthest up/down beam left of center, e.g. -60(make sure your measurements are to the center of the beam). Cell C2 will be the Z axis, or height, of the beam, e.g. 100. Cell D2 will be your load limit on the beam e.g. 5000.

Once you enter those four cells row 1 is set, the rest of the cells contain formulas. Continue to add your X axis beams, one beam per row making sure to use a negative sign on beams left of center, beams right of center will be positive (no notation necessary on positive numbers). Once your X axis table is complete you can click on the Beam Table Y tab at the bottom of the sheet and enter your beams on the Y axis the same way. To enter your Y axis beam locations you will have to pick a datum location or zero point in the room. I use the main cross stage beam as my zero point in my RLC as it's usually pretty close to the incoming shows datum line. You can pick any point in the room though, just make sure you are entering your beam locations accurately from that point with locations upstage of zero being notated in the negative axis e.g. -40.

The next thing you'll need to do is enter some information in the General Table cell A2 will be the difference between the shows datum line and the datum line you picked for your venue e.g.-20, 20, this number can be changed at any point and the formulas will rework the show in it's current position. Cell B2 will be the hook height you need e.g. 60. Cell C2 will be the stinger length you will be using on bridled points e.g 20. At this point you should save your file with your venue name as a blank template. You may need to make multiple templates if your roof is broken down into sections, I have a template for my Upstage section, Midstage section, Scoreboard section and down stage section, as we have four different beam layouts. You only need to enter this information once, now you have a template to lay all future shows into.

Now you can make a copy, label it for the current show and enter your show points into it. Click on the table that you bridle the majority of your points from. If your bridles run cross stage you will use Point Table X, if your bridles run up and downstage you will use Point Table Y. If you run bridles in both directions you will be able to set up both tables by copying and pasting points from one table to the other so start by putting all of your points into the table that most of your bridles will be on. If you have an XY sheet in excel you can simply copy and paste your sheet into cell A2, just make sure your columns are ordered Point Name, Load Weight, X, Y. Alternatively you can enter the information manually, one row per point, you only need to enter information in the first four cells, the rest contain formulas.