DIY Screen Frame/Materials Excel Sheet - AVS Forum
Forum Jump: 
 
Thread Tools
post #1 of 3 Old 11-22-2013, 05:34 PM - Thread Starter
Senior Member
 
bikinpunk's Avatar
 
Join Date: Jan 2007
Posts: 222
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 19 Post(s)
Liked: 16
Hey, guys.

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:
https://www.dropbox.com/s/amfxdb30oza4plz/HT%20screen%20calcs.xlsx



Here's a couple screenshots:

ScreenCalcs.png


ScreenCalcGraphic.png




LMK if you have any issues or questions.

- Erin
superleo, quamosa and john171 like this.

--------------------------------------------------------------------

If you like speaker science, have a look at my website:
www.medleysmusings.com

- Erin
bikinpunk is offline  
Sponsored Links
Advertisement
 
post #2 of 3 Old 11-27-2013, 01:06 PM
Advanced Member
 
Dradius's Avatar
 
Join Date: Apr 2007
Posts: 526
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 22
Awesome. Thanks for taking the time to share this.
Dradius is offline  
post #3 of 3 Old 11-29-2013, 11:04 PM
Newbie
 
Alx2057's Avatar
 
Join Date: Aug 2013
Location: Texas
Posts: 3
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 11
Thanks! Cool!
Alx2057 is offline  
Reply DIY Screen Section

Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page


Forum Jump: 

Posting Rules  
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off