Room Layout & Analysis Spreadsheet - AVS Forum | Home Theater Discussions And Reviews
Forum Jump: 
 9Likes
  • 4 Post By knappster007
  • 1 Post By jjcook
  • 1 Post By Javs
  • 1 Post By tjambro
  • 1 Post By Mocs123
  • 1 Post By knappster007
 
Thread Tools
post #1 of 14 Old 05-24-2019, 08:02 AM - Thread Starter
Member
 
knappster007's Avatar
 
Join Date: Aug 2011
Location: Indiana
Posts: 55
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 24 Post(s)
Liked: 51
Room Layout & Analysis Spreadsheet

Linked to this thread is a beta version of a room layout and frequency response estimation spreadsheet. The spreadsheet:

+ Allows entry of room dimensions, listener location and independent placement of right and left speakers
+ Calculates the location of the first reflection points along each of the side walls (for treatment placement purposes)
+ Calculates the speaker boundary interference frequencies
+ Calculates the room modes based on the dimensions of the room
+ Estimates the untreated room frequency response curve at the listener location
+ Estimates the T60 (time for a sound to decay -60db) based on the surfaces in the room (using Sabine's formula)
+ Calculates the Schroeder frequency for the room (room crossover frequency from resonator to reflector)
+ Calculates main speaker listening angles
+ Allows screen size and aspect ratio selection from a dropdown menu and calculates screen viewing angles
+ Calculates Dolby ATMOS ceiling speaker optimal locations given ceiling height (45 degrees from listener ear height)
+ Creates a scaled map of the room with speaker and listener locations marked


This was created to help me do all of these things as I'm designing a new home theater. There are various tools that do some of these things, but I didn't find one (that was free) that did all of them. I have done my best to validate the calculations, but there could be errors. The estimated frequency response curve at the listener is a rough estimate as I had to use linear interpolation for the location on the sinusoidal wave instead of a more precise calculation.

Feel free to use this for your own home theater adventures. Comments are welcome, but please be kind. It may not be perfect, but it meets my needs and might help others as well.

I'm posting this for AVSForum members to use freely because of all of the helpful information and feedback that this forum has provided over the years.
This was originally posted in Audio Theory and Setup but it is more appropriate here as I have added many home theater calculations.

Spreadsheet Link Here

Updates
vb02 - Changed room width data entry to be direct, with secondary entry on listener distance from left wall.
vb10 - Added main speaker angle calculations. For home theater, viewing angle calculations along with a dropdown to select home theater screen size has also been added. The data entry was also simplified.
vb11 - Added Dolby ATMOS ceiling speaker location calcs, added scaled model of the room based on object locations
vb12 - Added main speaker sound transmission time to listener and millisecond delay for side and opposite wall first reflection points
vb14 - Added ability to include up to four subwoofers with independent locations to the analysis. Also reorganized the presentation of data to simplify the visuals.
vb15 - Added front wall first reflection locations and further cleaned up the interface.
Modified delivery to be through the web site, this enables access via mobile devices and computers that do not have Excel.
Javs, Mocs123, Paulukwalsh and 1 others like this.

Eletronics: Yamaha 3050 RX A-3050 | Emotiva XPA-5 | Parasound A21 | Parasound P5 | Auralic Aries Mini (music server) | Oppo 205
Speakers: Paradigm Signature S6 v3 (mains) | Paradigm Signature C3 v3 (center) | Paradigm Signature S2 v3 (surrounds) | Paradigm CI Pro 65-R (Atmos ceiling) | Subs SVS SB Ultra 13
Room Treatments: Acoustimac wall and bass traps

Last edited by knappster007; 06-01-2019 at 11:48 AM. Reason: Version update
knappster007 is offline  
Sponsored Links
Advertisement
 
post #2 of 14 Old 05-24-2019, 07:45 PM
AVS Forum Special Member
 
jjcook's Avatar
 
Join Date: Dec 2004
Location: Portland, OR
Posts: 1,081
Mentioned: 13 Post(s)
Tagged: 0 Thread(s)
Quoted: 463 Post(s)
Liked: 188
+1 nice spreadsheet
knappster007 likes this.

Last edited by jjcook; 05-24-2019 at 07:56 PM.
jjcook is offline  
post #3 of 14 Old 05-24-2019, 08:22 PM - Thread Starter
Member
 
knappster007's Avatar
 
Join Date: Aug 2011
Location: Indiana
Posts: 55
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 24 Post(s)
Liked: 51
Quote:
Originally Posted by jjcook View Post
+1 nice spreadsheet
Thanks, I put a lot of effort in to it. It's been helpful to me during design. If you have any suggestions or ideas for improvement, they are welcomed.

Eletronics: Yamaha 3050 RX A-3050 | Emotiva XPA-5 | Parasound A21 | Parasound P5 | Auralic Aries Mini (music server) | Oppo 205
Speakers: Paradigm Signature S6 v3 (mains) | Paradigm Signature C3 v3 (center) | Paradigm Signature S2 v3 (surrounds) | Paradigm CI Pro 65-R (Atmos ceiling) | Subs SVS SB Ultra 13
Room Treatments: Acoustimac wall and bass traps
knappster007 is offline  
Sponsored Links
Advertisement
 
post #4 of 14 Old 05-25-2019, 02:30 AM
AVS Forum Special Member
 
Javs's Avatar
 
Join Date: Dec 2012
Location: Sydney
Posts: 7,837
Mentioned: 474 Post(s)
Tagged: 0 Thread(s)
Quoted: 6779 Post(s)
Liked: 6393
Awesome. Following.
knappster007 likes this.

JVC X9500 (RS620) | 120" 16:9 | Marantz AV7702 MkII | Emotiva XPA-7 | DIY Modular Towers | DIY TPL-150 Surrounds | DIY Atmos | DIY 18" Subs
-
MadVR Settings | UHD Waveform Analysis | Arve Tool Instructions + V3 Javs Curves
Javs is online now  
post #5 of 14 Old 05-25-2019, 05:52 AM
Senior Member
 
tjambro's Avatar
 
Join Date: May 2003
Location: IN
Posts: 403
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 29 Post(s)
Liked: 73
Thanks for sharing!
knappster007 likes this.
tjambro is offline  
post #6 of 14 Old 05-27-2019, 10:03 AM - Thread Starter
Member
 
knappster007's Avatar
 
Join Date: Aug 2011
Location: Indiana
Posts: 55
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 24 Post(s)
Liked: 51
Sheet updated to add main speaker sound transmission time to listener and millisecond delay for side and opposite wall first reflection points
I'm going to start working on adding subwoofer number, placement and location frequency effects

Eletronics: Yamaha 3050 RX A-3050 | Emotiva XPA-5 | Parasound A21 | Parasound P5 | Auralic Aries Mini (music server) | Oppo 205
Speakers: Paradigm Signature S6 v3 (mains) | Paradigm Signature C3 v3 (center) | Paradigm Signature S2 v3 (surrounds) | Paradigm CI Pro 65-R (Atmos ceiling) | Subs SVS SB Ultra 13
Room Treatments: Acoustimac wall and bass traps
knappster007 is offline  
post #7 of 14 Old 05-29-2019, 01:49 PM - Thread Starter
Member
 
knappster007's Avatar
 
Join Date: Aug 2011
Location: Indiana
Posts: 55
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 24 Post(s)
Liked: 51
Latest version vb14 added ability to include up to four subwoofers with independent locations to the analysis. Also reorganized the presentation of data to simplify the visuals.

This is pretty much the full feature set that I plan to add, unless there are solid suggestions that are in scope of what I planned to do. Error and problem reporting as well as feedback is welcome.

Eletronics: Yamaha 3050 RX A-3050 | Emotiva XPA-5 | Parasound A21 | Parasound P5 | Auralic Aries Mini (music server) | Oppo 205
Speakers: Paradigm Signature S6 v3 (mains) | Paradigm Signature C3 v3 (center) | Paradigm Signature S2 v3 (surrounds) | Paradigm CI Pro 65-R (Atmos ceiling) | Subs SVS SB Ultra 13
Room Treatments: Acoustimac wall and bass traps
knappster007 is offline  
post #8 of 14 Old 05-29-2019, 02:06 PM
Senior Member
 
Mocs123's Avatar
 
Join Date: Sep 2004
Location: Tennessee
Posts: 345
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 102 Post(s)
Liked: 27
Very nice spreadsheet. You are an Excel god.
knappster007 likes this.

7.1.4 Theater Room (In Progress): JVC-RS46U, Silver Ticket AT 2.35:1 142”, Onkyo RZ830, Anthem PVA-7, Panasonic DBT-110, JBL Studio 270’s, NXG-NX BAS 500 (for now)

3.1 Living Room: Samsung 64” F8500 Plasma, Anthem MRX 300, Dynaudio Audience 52’s, Dynaudio Audience 122C, NHT SubOne
Mocs123 is offline  
post #9 of 14 Old 05-29-2019, 08:24 PM
AVS Forum Special Member
 
Bigus's Avatar
 
Join Date: Feb 2003
Location: The South
Posts: 5,528
Mentioned: 13 Post(s)
Tagged: 0 Thread(s)
Quoted: 578 Post(s)
Liked: 535
I haven't had a chance to download and play with it yet but certainly will, sounds like a ton of work went into this. I'm assuming this is only for rectangular rooms?
Bigus is offline  
post #10 of 14 Old 05-30-2019, 03:35 AM - Thread Starter
Member
 
knappster007's Avatar
 
Join Date: Aug 2011
Location: Indiana
Posts: 55
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 24 Post(s)
Liked: 51
Quote:
Originally Posted by Bigus View Post
I haven't had a chance to download and play with it yet but certainly will, sounds like a ton of work went into this. I'm assuming this is only for rectangular rooms?
Yes, it models rectangles only. Just don't have the time to do odd shapes with multiple angles.

Eletronics: Yamaha 3050 RX A-3050 | Emotiva XPA-5 | Parasound A21 | Parasound P5 | Auralic Aries Mini (music server) | Oppo 205
Speakers: Paradigm Signature S6 v3 (mains) | Paradigm Signature C3 v3 (center) | Paradigm Signature S2 v3 (surrounds) | Paradigm CI Pro 65-R (Atmos ceiling) | Subs SVS SB Ultra 13
Room Treatments: Acoustimac wall and bass traps
knappster007 is offline  
post #11 of 14 Old 05-30-2019, 10:05 AM
Newbie
 
Join Date: Mar 2019
Posts: 6
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 7 Post(s)
Liked: 1
Wow,

Would you mind sharing it on the following forum? I think this would help an awfull lot of people, Especially a new builder such as myself.. I don't want to do it as its your thing..

https://www.avforums.com/forums/home...ilding-diy.59/

Regards

Paul

AV: Denon X2300W | Front L/R: Q Acoustic 3050 | Centre: Q Acoustic 3090C | Surround L/R: Q Acoustic 3020 | Sub: Wharefdale Diamond SW150 | Ceiling Middle: Polk RC60i (Directional Tweeters) | Streaming: 4K Fire Stick HDMI | Blu ray: Sony UBP-X800 HDMI | Cable TV: Virgin V6 Box HDMI | Casting: Chromecast HDMI | Server:Universal media server on workstaion Elite 8560W
Paulukwalsh is offline  
post #12 of 14 Old 05-30-2019, 02:19 PM - Thread Starter
Member
 
knappster007's Avatar
 
Join Date: Aug 2011
Location: Indiana
Posts: 55
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 24 Post(s)
Liked: 51
Quote:
Originally Posted by Paulukwalsh View Post
Wow,

Would you mind sharing it on the following forum? I think this would help an awfull lot of people, Especially a new builder such as myself.. I don't want to do it as its your thing..

https://www.avforums.com/forums/home...ilding-diy.59/

Regards

Paul
Posted. I've never used that other forum, it looks interesting. I'll add it to my reading list ;-)
Paulukwalsh likes this.

Eletronics: Yamaha 3050 RX A-3050 | Emotiva XPA-5 | Parasound A21 | Parasound P5 | Auralic Aries Mini (music server) | Oppo 205
Speakers: Paradigm Signature S6 v3 (mains) | Paradigm Signature C3 v3 (center) | Paradigm Signature S2 v3 (surrounds) | Paradigm CI Pro 65-R (Atmos ceiling) | Subs SVS SB Ultra 13
Room Treatments: Acoustimac wall and bass traps
knappster007 is offline  
post #13 of 14 Old 05-30-2019, 04:33 PM
AVS Forum Special Member
 
Bigus's Avatar
 
Join Date: Feb 2003
Location: The South
Posts: 5,528
Mentioned: 13 Post(s)
Tagged: 0 Thread(s)
Quoted: 578 Post(s)
Liked: 535
It's probably a fine forum, but just because of the name I've always thought of it as bizarro world.
Bigus is offline  
post #14 of 14 Old 06-01-2019, 11:49 AM - Thread Starter
Member
 
knappster007's Avatar
 
Join Date: Aug 2011
Location: Indiana
Posts: 55
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 24 Post(s)
Liked: 51
Modified the link to enable access to the spreadsheet via a web interface. This enables users of mobile, tablet and devices that do not have Excel to use the sheet. (I'm a little shocked that it worked, but it does!)

Eletronics: Yamaha 3050 RX A-3050 | Emotiva XPA-5 | Parasound A21 | Parasound P5 | Auralic Aries Mini (music server) | Oppo 205
Speakers: Paradigm Signature S6 v3 (mains) | Paradigm Signature C3 v3 (center) | Paradigm Signature S2 v3 (surrounds) | Paradigm CI Pro 65-R (Atmos ceiling) | Subs SVS SB Ultra 13
Room Treatments: Acoustimac wall and bass traps
knappster007 is offline  
Sponsored Links
Advertisement
 
Reply Dedicated Theater Design & Construction

Tags
acoustical treatments , layout , room modes , simulation , speaker placement

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