I put together an excel spreadsheet for myself to determine frame and materials dimensions needed for a very simple DIY screen. It does the math for me, so when I'm going back and forth between screen sizes, I can keep up with how large the frame is going to need to be.
I built the sheet based on my design: a simple wooden frame with a center beam for support. The 'wood' here is plain jane strips of wood. No fancy edge designs. If your screen will have an edge design (like moulding), just keep that in mind.
The general idea is I know my desired screen size and any trim I want to use, such as black felt. Punch it all in, get the frame size, screen material size, and also the size of the wood pieces I need.Here's how to use it:
- Enter all your variables in the green areas: Wall dimensions, screen dimensions, black felt strip width, etc. I put notes for explanation if needed.
- All yellow areas are calculated. The bottom yellow portion of the sheet will provide you with the dimensions you need for screen material and wood.
- Note: All dimensions are in (inches).
Once you go through the process and get your material sizes, look at the other page (tab at the bottom called "Frame + Screen Overlay". This will give you a visual layout, and lay the screen's dimensions over the frame just as a quick sanity check.
It's possible I made a goof somewhere as I was doing this while my daughter was running around the house chasing the dogs and I didn't initially intend to post it up. But, hopefully it helps save you guys a bit of trouble.Here's the link to download it:
Here's a couple screenshots:
LMK if you have any issues or questions.