<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/atom10full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><feed xmlns="http://www.w3.org/2005/Atom" xmlns:openSearch="http://a9.com/-/spec/opensearch/1.1/" xmlns:georss="http://www.georss.org/georss" xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr="http://purl.org/syndication/thread/1.0" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" gd:etag="W/&quot;CkUCQ3c7eip7ImA9WhRRFEk.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324</id><updated>2011-11-28T00:31:02.902Z</updated><category term="Solutions" /><category term="Opinion" /><category term="Tips" /><category term="Home Automation" /><category term="Cool" /><title>Chris's Blog</title><subtitle type="html">I am the Technical Sales Manager for one of the countries leading specialists in Whole House Automation and Entertainment systems. Below is a blend of my thoughts and opinions about Home Automation and some technical solutions that I have found over the years. For more visit my website 
&lt;a href="http://www.chrisnew.co.uk"&gt;www.chrisnew.co.uk&lt;/a&gt;.</subtitle><link rel="http://schemas.google.com/g/2005#feed" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/posts/default" /><link rel="alternate" type="text/html" href="http://chrisnewcouk.blogspot.com/" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><generator version="7.00" uri="http://www.blogger.com">Blogger</generator><openSearch:totalResults>14</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/atom+xml" href="http://feeds.feedburner.com/blogspot/WHeyd" /><feedburner:info uri="blogspot/wheyd" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><entry gd:etag="W/&quot;AkUMSX4_fCp7ImA9WhdXEE8.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-6245714867233088056</id><published>2011-08-22T16:46:00.001+01:00</published><updated>2011-08-22T16:51:28.044+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-08-22T16:51:28.044+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Tips" /><category scheme="http://www.blogger.com/atom/ns#" term="Home Automation" /><category scheme="http://www.blogger.com/atom/ns#" term="Solutions" /><title>Living Room Acoustics for Beginners</title><content type="html">&lt;span id="internal-source-marker_0.30851550353167745" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;I  would like to start by saying that although I have some knowledge on  this subject I am by no means an expert. I covered acoustics whilst at  Uni but in a very specific way, aimed purely at room acoustics and  recording studios. There is much more to this ‘dark art’ than what I  covered, however I do know enough to write this article.&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;I  write this because in my line of work I come across people who claim to  know about acoustics, room treatments and in particular how to make a  cinema “sound good”. I aim to dispel some of the myths and give a simple  guide to ways in which you can go about improving the acoustics of you  living room to suite a surround sound system or hi-fi.&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;So, lets start at the beginning.&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;How does sound behave in my Living Room?&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;To  answer this we need to consider the room its self and what we have in  that room. We of course have four walls, each of which will reflect  sound. Very simply two parallel walls reflect low frequencies, these are  known as Axial Modes, and are the most powerful and troublesome echos  we have to deal with.&lt;/span&gt;&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://4.bp.blogspot.com/-fzsByZuWDd8/TlJ60PjgpxI/AAAAAAAAAMQ/1PTttDjaOBw/s1600/Axial+Modes.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="318" src="http://4.bp.blogspot.com/-fzsByZuWDd8/TlJ60PjgpxI/AAAAAAAAAMQ/1PTttDjaOBw/s320/Axial+Modes.jpg" width="320" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class="separator" style="clear: both; text-align: center;"&gt;&amp;nbsp;&lt;/div&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;The  simplest solution is to have no parallel surfaces, however we all know  in our living room this is impossible. The ceiling and the floor will  always be parallel even if the walls are not. The next best thing is  absorption, acoustic specialists will tell you to invest in “bass bins”.  They are absolutely right technically, but this is your living room not  a recording studio, the best this to do is add as many soft furnishings  as possible, no leather sofas, plush deep carpets, heavy curtains big  cushions etc. This will be no means cure the problem, but it will help.&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;Sound  does not just bounce in one direction, it can bounce of at angles. If  the sound remains on one plane, i.e. x or y or z then we say these are  Tangential Modes. These are made up predominantly by mid frequencies.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://4.bp.blogspot.com/-Es0WqtaK-UU/TlJ61zXdmvI/AAAAAAAAAMU/3tMJY9JZmA0/s1600/Tangentile+Modes.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="316" src="http://4.bp.blogspot.com/-Es0WqtaK-UU/TlJ61zXdmvI/AAAAAAAAAMU/3tMJY9JZmA0/s320/Tangentile+Modes.jpg" width="320" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://2.bp.blogspot.com/-6T5Z-6mKsB4/TlJ5gAaggaI/AAAAAAAAAMI/eefLBk10PK4/s1600/Tangentile+Modes.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;br /&gt;
&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;If  the sound bounces randomly across all planes, i.e. x, y and z then we  say they are Oblique Modes and are generally high frequencies.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;&lt;a href="http://2.bp.blogspot.com/-vadAzotZdbE/TlJ63fxNt-I/AAAAAAAAAMY/cCedcS7SJAo/s1600/Oblique+Modes.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="317" src="http://2.bp.blogspot.com/-vadAzotZdbE/TlJ63fxNt-I/AAAAAAAAAMY/cCedcS7SJAo/s320/Oblique+Modes.jpg" width="320" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;This  is of course highly simplified, but the principle will ring true. The  best way to deal with the frequencies bouncing around that we don’t want  is absorption, things like canvas paintings are good for mid  frequencies as are light curtains, blinds and even fabric wall paper.  The other option is to use diffusers, these scatter the Tangential Modes  into the least problematic Oblique Modes, some diffusers can be make to  look quite nice. If you want to go down the diffuser route, hunt around  but don’t forget, you still want your living room to look homey or your  wife will kill you!&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;I wouldn’t worry too much about Oblique Modes as they scatter and die out very quickly.&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;The next question to ask is; does it make a difference where I put my speakers?&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;The short answer is yes. The long answer is it depends on what speakers you have and what you hope to achieve.&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;If you are looking at setting out your Surround Sound have a read of one of my previous posts &lt;/span&gt;&lt;a href="http://chrisnewcouk.blogspot.com/2010/12/how-to-setup-your-surround-sound.html"&gt;&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; vertical-align: baseline;"&gt;How to Setup Your Surround Sound&lt;/span&gt;&lt;/a&gt;&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;.  If you are setting up a Hi-fi or are creating a listening environment  then you need to place your speakers at about ear height and 30 - 40  degrees apart as viewed from the desired sweet spot. You should also  bring them away from the wall slightly as if they are too close you get  something called comb filtering (for the super geeks follow this link to  &lt;/span&gt;&lt;a href="http://en.wikipedia.org/wiki/Comb_filter" style="color: black;"&gt;&lt;span style="background-color: transparent; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; vertical-align: baseline;"&gt;Wikipedia&lt;/span&gt;&lt;/a&gt;&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;).  The best way to check if you have got it right is to have a listen, if  the music sounds muddy move the speakers further from the wall. Another  tip is if your speakers sound a little weak in the bass area to put them  in corners as this will give a 3dB lift to bass frequencies. If the  speakers have a port you can also experiment with putting different  kinds of foam in the port, this will change the way air flows in and out  and consequently how the speakers respond to bass.&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;As far as setting up the room goes that’s it! Remember to listed to your work and save using your EQ for minor tweaks.&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-6245714867233088056?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/ULt2sfzgnwtlX9I5KrQbXUyFSBg/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/ULt2sfzgnwtlX9I5KrQbXUyFSBg/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/ULt2sfzgnwtlX9I5KrQbXUyFSBg/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/ULt2sfzgnwtlX9I5KrQbXUyFSBg/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/5xAT107oc5c" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/6245714867233088056/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2011/08/living-room-acoustics-for-beginners.html#comment-form" title="2 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/6245714867233088056?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/6245714867233088056?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/5xAT107oc5c/living-room-acoustics-for-beginners.html" title="Living Room Acoustics for Beginners" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://4.bp.blogspot.com/-fzsByZuWDd8/TlJ60PjgpxI/AAAAAAAAAMQ/1PTttDjaOBw/s72-c/Axial+Modes.jpg" height="72" width="72" /><thr:total>2</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2011/08/living-room-acoustics-for-beginners.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CEYMSHozfip7ImA9WhdQFUU.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-2816626450789346568</id><published>2010-12-03T16:31:00.002Z</published><updated>2011-08-17T12:56:29.486+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-08-17T12:56:29.486+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Tips" /><category scheme="http://www.blogger.com/atom/ns#" term="Home Automation" /><category scheme="http://www.blogger.com/atom/ns#" term="Solutions" /><category scheme="http://www.blogger.com/atom/ns#" term="Opinion" /><title>How to Setup Your Surround Sound</title><content type="html">&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;We’ve all been there, having just bought an all-in-one DVD/Blu-ray with surround sound, complete with speakers, got it home all excited and can’t wait to get it going. Most of us will have just spent a few hundred or even a few thousand pounds on our new exciting purchase, but how do we get the most out of it?&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;The first thing is to take things slow, don’t rush into anything, make a cup of tea and get out the instructions. Yes guys I know, instructions are for losers, but trust me, if you new system has a handy button for setting up the surround sound you’ll want to know about it.&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;Once we’re au fait with our new systems features we can start to consider our setup. I’m sure we are all aware that a surround sound system has three front speakers, two rear speakers and a sub woofer, though some may have a pair of side speakers as well. Before we consider placing our speakers we must first consider the room in which they are going. Where do we want the “sweet spot” to be? Will the system be setup around the room or will the room be set be around the TV? For best results I recommend setting the room up around the system.&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;Now to business...&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;First lets consider the fronts, assuming that the television is all setup (I recommend 1400mm from floor to screen center by the way) we can place the center speaker. When placing speakers be aware that for best results the tweeters should be at about ear height when seated, generally this will be about 1400mm from the floor (see how that matches the TV?).&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;The center speaker is where the dialogue comes from and so should be unobstructed or speech will sound muffled. Place this either above or below the screen, this can be hard up against the edge of the screen or a little distance away, but remember if it is too far from the screen then it won’t sound like the actors are talking from the screen but from somewhere else.&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;Now lets look at the front left and front right speakers, these create the stereo effect. They play a small amount of dialogue, but predominantly are for sound effects. As with setting up any stereo system these should be about 30 - 40 degrees from the center speaker measured from the sweet spot, the further they are placed from the sweet spot the further apart they will need to be. You may wish to adjust the angle of these to get a clear sound at the sweet spot, generally pointing the tweeter towards the sweet spot will achieve this.&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;Now the rears, these create the surround effect and are only rarely heard. The thing to consider here is that you want the sound to wash behind you, in other words fill the space behind the sweet spot with a wide stereo effect. These can be placed at about 100 - 120 degrees measured from the sweet spot when facing the screen, pointing the tweeters at the back of the persons head. Di-pole speakers are ideal as surround sound rears, however these rarely come in the kits. Mounting a conventional speaker on the ceiling just behind the listening position can create a similar effect, though not many of us will go to that extreme.&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;The Sub woofer fills in the low frequencies that the surround speakers cannot produce. Sub frequencies are omnidirectional and so it is not hugely important where the sub is placed. Some will tell you to be wary of null points, though for most of us this isn’t a huge issue. The human ear can her frequencies as low as approximately 20Hz, as this has a wavelength of 17m it is unlikely that most of us are going to fit this in our living rooms. However this can still be heard as we feel the vibrations created at these low frequencies, this is called psychoacoustics and we can use this to our advantage. If the sub is placed say under a seat or downward firing then less volume is required for us to hear these sub-frequencies as we will feel them more readily. This has the added advantage of not pissing off the neighbours.&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;Finally the sides, if you have these in your system i.e. 7.1 they go parallel with the ears of the person sitting in the sweet spot.&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;Think we’re done? Not quite!&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style="color: black; font-family: Verdana,sans-serif;"&gt;Now we have to set up the levels (relative volume of each speaker) and if possible distances. Setting the distances is easy, measure from each speaker to the sweet spot and put in the values, this helps prevent sound cancellation. When setting levels you will want the centre speaker to be slightly louder than the left and right so that dialogue will be clear, also the rears and sides will want to be a little quieter than the fronts so that they can be heard but are not distracting. The best way to get this all sounding great is to put on a film that you love with lots of surround sound action in and experiment. Personally I do not recommend boosting (amplifying) any speaker channel by more than 3dB, if a speaker is too quiet turn the others down to suit rather than turning the quiet one up. This will help to improve audio quality as sound will distort less as the volume is turned up.&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-2816626450789346568?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/a7XFStbQSgvg8seaNvjp11eOBY8/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/a7XFStbQSgvg8seaNvjp11eOBY8/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/a7XFStbQSgvg8seaNvjp11eOBY8/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/a7XFStbQSgvg8seaNvjp11eOBY8/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/iVLFWZCG9dU" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/2816626450789346568/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/12/how-to-setup-your-surround-sound.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/2816626450789346568?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/2816626450789346568?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/iVLFWZCG9dU/how-to-setup-your-surround-sound.html" title="How to Setup Your Surround Sound" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/12/how-to-setup-your-surround-sound.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CEUGQ306cSp7ImA9WhdQFUU.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-411240589194289024</id><published>2010-10-15T13:03:00.003+01:00</published><updated>2011-08-17T12:57:02.319+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-08-17T12:57:02.319+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Home Automation" /><category scheme="http://www.blogger.com/atom/ns#" term="Opinion" /><title>Multi-room Audio on a Budget</title><content type="html">&lt;div style="color: black;"&gt;&lt;div id="internal-source-marker_0.12630307743532831" style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;Before  I launch into this one I should explain a little about what multi-room  audio is forgive me if this seems a little obvious but we should all be  on the same page to start. Multi-room audio is the ability to listen to a  single source or group of sources in multiple rooms in the house at the  same time. That is to say one radio can be listened to from speakers in  several different rooms, not having a radio in each room.&lt;/div&gt;&lt;br /&gt;
&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;Believe  it or not multi-room audio is nothing new, systems have been around for  at least 25 years with the earliest having push buttons to switch  between sources and a volume knob on each control panel. These were in  the days before you could remotely control devices so to change radio  stations you would have to switch between different radios permanently  set on a station. Thankfully times have moved on and you can get systems  that are easy to use and can control devices with that all important  feedback, i.e. display track/station names fairly cheaply.&lt;/div&gt;&lt;br /&gt;
&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;So  lets say that I’ve decided to get a Multi-room audio system, I have  four rooms that I want to hook up, I want to have an iPod dock, DAB/FM  radio, play songs from my iTunes library and maybe Internet radio as  well, where do I go from here?&lt;/div&gt;&lt;br /&gt;
&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;First  you need to know what you really want, do you want an audiophile grade  system or are you the kind of person that listens to their iPod through  tiny headphones and are perfectly happy with that level or quality or  are you somewhere in between?&amp;nbsp;&lt;/div&gt;&lt;br /&gt;
&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;Audiophiles;  go to a professional and expect to spend around £30,000 or more for  your system. Yes that sounds a lot, but you will have an incredible  system. If this is you then stop reading this blog because you will  probably hate everything else that I am going to suggest.&lt;/div&gt;&lt;br /&gt;
&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;iPod  with small headphone listeners; there are more options than what you  can get from Curry’s/PC World/Play.com. Watch this space and pay  attention.&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;In  betweeners; you may want to spend a little more than what I’m going to  suggest, the principle is the same, you will simply need better  speakers, amps and possibly sources.&lt;/div&gt;&lt;br /&gt;
&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;O.k. here goes...&lt;/div&gt;&lt;br /&gt;
&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;Possibly  the cheapest system that is even worth mentioning is &lt;a href="http://www.sonos.com/"&gt;Sonos&lt;/a&gt;. This is  fairly low quality, though can be improved with better amps and  speakers, but you get a lot of bang for you buck. You can have an iPod  dock, play from you iTunes library and listen to Internet radio, which  kind of makes DAB radio superfluous. Use Zone Player 120s and all you  need do is plug in your speakers. Use Zone Player 90s and you can add  you own amps and speakers and up the quality. This is very easy to  install and you shouldn’t need a professional to get your system off the  ground. The down side to this is, you can’t easily add you own sources.  This system will cost around £600 - £700 per room.&amp;nbsp;&lt;/div&gt;&lt;br /&gt;
&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;The  next step up will probably require some input from a professional and  you would be looking at a system similar to &lt;a href="http://www.nuvotechnologies.com/"&gt;NuVo&lt;/a&gt;. This offers multi-room  audio that has all of the things that I spoke about in my brief above,  iPod Dock, DAB/FM Radio, the ability to play from iTunes and Internet  radio! All you need do is add speakers and you are away, though this  requires cabling to be installed as well as a degree of programming so  you will need professional help. This system would cost around £1,000  per room but offers better sound quality than the above system and the  ability to add equipment of your choice, such as CD players, Turn Tables  etc.&lt;/div&gt;&lt;br /&gt;
&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;You  can of course achieve a system similar to or the same as the NuVo one  with systems such as &lt;a href="http://www.crestron.com/"&gt;Crestron&lt;/a&gt;, &lt;a href="http://www.control4.com/"&gt;Control4&lt;/a&gt; or &lt;a href="http://www.amx.com/"&gt;AMX&lt;/a&gt;. However, unless your are  in pursuit of audiophile sound quality or want to integrate anything  other than music into the system, you cant really justify the added  expense of these systems.&lt;/div&gt;&lt;br /&gt;
&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;One final note...&lt;/div&gt;&lt;br /&gt;
&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;If  you are seeking the help of a professional with your system don’t ask  them to install a complete Sonos system. By all means ask to have Sonos  integrated but expect to be told that you would be better off with a  different option. True professional will tell you this for the following  reasons.&lt;/div&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;/div&gt;&lt;ol style="color: black;"&gt;&lt;li style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; list-style-type: decimal; text-decoration: none; vertical-align: baseline;"&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;They can make very little money on Sonos, it is designed to be purchased and installed by the end user.&lt;/div&gt;&lt;/li&gt;
&lt;li style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; list-style-type: decimal; text-decoration: none; vertical-align: baseline;"&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;Sonos  offers fairly low quality sound and those with a reputation to maintain  will not want to stake their reputation on what Sonos has to offer.&lt;/div&gt;&lt;/li&gt;
&lt;li style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; list-style-type: decimal; text-decoration: none; vertical-align: baseline;"&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;Any wireless system will have reliability issues and most installers don't want to be hampered with constant call-outs.&lt;/div&gt;&lt;/li&gt;
&lt;/ol&gt;&lt;div style="color: black;"&gt;&lt;div style="background-color: transparent; font-family: Verdana; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;Having  said that, Sonos is an excellent option if you are on a budget and are  happy to install the system yourself. It has a very simple interface, is  easy to install and it does work very well. If you are having problems you can always add in a zone bridge and that usually sorts things out.&lt;/div&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-411240589194289024?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/bySZznUT1dughwsmVrj6mDX7i20/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/bySZznUT1dughwsmVrj6mDX7i20/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/bySZznUT1dughwsmVrj6mDX7i20/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/bySZznUT1dughwsmVrj6mDX7i20/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/u2I1gkHLRXc" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/411240589194289024/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/10/multi-room-audio-on-budget.html#comment-form" title="2 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/411240589194289024?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/411240589194289024?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/u2I1gkHLRXc/multi-room-audio-on-budget.html" title="Multi-room Audio on a Budget" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>2</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/10/multi-room-audio-on-budget.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CEUDQn44eCp7ImA9WhdQFUU.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-2394757350531111720</id><published>2010-10-01T18:25:00.008+01:00</published><updated>2011-08-17T12:57:53.030+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-08-17T12:57:53.030+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Home Automation" /><category scheme="http://www.blogger.com/atom/ns#" term="Opinion" /><title>Apple’s iPad as a Home Control device</title><content type="html">&lt;div style="color: black; text-align: justify;"&gt;&lt;div id="internal-source-marker_0.6937741359184402" style="background-color: transparent; font-family: Arial; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;Apples  latest offering, the iPad, has achieved great acclaim. People love it,  it’s easy to use and with the multitude of apps on offer, it can do  virtually anything. As home automation technology becomes more available  to the common man, is the iPad really the only control device you’ll  need?&lt;/div&gt;&lt;/div&gt;&lt;div style="color: black; text-align: justify;"&gt;&lt;div style="background-color: transparent; font-family: Arial; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;/div&gt;&lt;div style="color: black; text-align: justify;"&gt;&lt;div style="background-color: transparent; font-family: Arial; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;The  iPad has many great features, not least the enormous and constantly  growing library of apps. This sleek, cool device can be made to do  virtually anything, and that, in the world of home automation may be  it’s down fall. I am constantly being asked what I think of the iPad in  the context of Home Automation or if I can control someones home with  only an iPad. My answer is always the same, the iPad is great but first  lets think about what you want to use it for. You may wish to subscribe  to a paper and read it on the train every day, you might want to browse  the Internet, play games, listen to music, watch movies and more. The  iPad can do all of this and control you home, a truly fantastic device I  think you’ll agree.&lt;/div&gt;&lt;/div&gt;&lt;div style="color: black; text-align: justify;"&gt;&lt;div style="background-color: transparent; font-family: Arial; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;/div&gt;&lt;div style="color: black; text-align: justify;"&gt;&lt;div style="background-color: transparent; font-family: Arial; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;What  happens then if you take you iPad on the train and someone left at home  wants to watch TV? What if you have a Movie playing at full volume  whilst you are browsing the Internet and the phone rings? What happens  when the battery goes flat? All of this must be considered before  choosing the iPad as a home control device. The simple answer is to have  multiple iPads that are solely used as home control devices. That’s  great but you’ve invested your money into a device that can do a great  many things, then use it to a fraction of it’s capabilities.&lt;/div&gt;&lt;/div&gt;&lt;div style="color: black; text-align: justify;"&gt;&lt;div style="background-color: transparent; font-family: Arial; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;&lt;/div&gt;&lt;/div&gt;&lt;div style="color: black; text-align: justify;"&gt;&lt;div style="background-color: transparent; font-family: Arial; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"&gt;My  personal opinion is that the iPad should be used in conjunction with  traditional home controllers. By all means choose the less feature rich,  cheaper alternatives to the pricey touch screens. But remember that  when you need to press mute quickly, switch the lights on early in the  morning or use you door entry system simplicity is the key, and it  doesn’t get more simple or reliable than a wired, solid push button.  You’ve got all the great features of the iPad, now back them up with  sensible, reliable and easy to use controllers.&lt;/div&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-2394757350531111720?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/fZxdhsVlK4DQcSBhCZ_ih8JhDxw/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/fZxdhsVlK4DQcSBhCZ_ih8JhDxw/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/fZxdhsVlK4DQcSBhCZ_ih8JhDxw/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/fZxdhsVlK4DQcSBhCZ_ih8JhDxw/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/Pf5X2uW3R6o" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/2394757350531111720/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/10/apples-ipad-as-home-control-device.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/2394757350531111720?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/2394757350531111720?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/Pf5X2uW3R6o/apples-ipad-as-home-control-device.html" title="Apple’s iPad as a Home Control device" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/10/apples-ipad-as-home-control-device.html</feedburner:origLink></entry><entry gd:etag="W/&quot;C0YNRnw7fCp7ImA9WxFUEkk.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-1508228876059869309</id><published>2010-06-22T20:21:00.008+01:00</published><updated>2010-06-22T22:13:17.204+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2010-06-22T22:13:17.204+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Tips" /><category scheme="http://www.blogger.com/atom/ns#" term="Solutions" /><title>Speeding up VBA Macros in Excel</title><content type="html">I have stumbled upon a good way to speed up macros in Excel. If you use  the Application.ScreenUpdating = False argument at the beginning of the  macro, then the macro will not display what it is doing. Then when you  use the argument Application.ScreenUpdating = True at the end of the  macro everything the macro has done will become visible. This works well  in speeding up long and complex macros.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-1508228876059869309?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/yYSFAx1AykpK5w_1rBmXUHjsmNY/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/yYSFAx1AykpK5w_1rBmXUHjsmNY/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/yYSFAx1AykpK5w_1rBmXUHjsmNY/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/yYSFAx1AykpK5w_1rBmXUHjsmNY/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/WaEoTBI7CgA" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/1508228876059869309/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/06/speeding-up-vba-macros-in-excel.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/1508228876059869309?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/1508228876059869309?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/WaEoTBI7CgA/speeding-up-vba-macros-in-excel.html" title="Speeding up VBA Macros in Excel" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/06/speeding-up-vba-macros-in-excel.html</feedburner:origLink></entry><entry gd:etag="W/&quot;C0YMQ3o9fip7ImA9WxFUEkk.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-8850874551637619701</id><published>2010-06-22T20:21:00.007+01:00</published><updated>2010-06-22T22:13:02.466+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2010-06-22T22:13:02.466+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Tips" /><category scheme="http://www.blogger.com/atom/ns#" term="Solutions" /><title>Problems with double sided printing in adobe acrobat pro</title><content type="html">In my office we were having a problem printing double sided a document  with a mixture of portrait and landscape pages. The solution was to  un check the "Auto rotate and centre" box. What this does is to automatically print portrait pages in portrait and landscape pages in landscape. When you un check the box you will need to set the paper up yourself and for any pages that are on a different orientation you will need to manually rotate or print separately. This cured the problem for me.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-8850874551637619701?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/faKjqhPUX8zxlgbEmUlslSMTIeU/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/faKjqhPUX8zxlgbEmUlslSMTIeU/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/faKjqhPUX8zxlgbEmUlslSMTIeU/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/faKjqhPUX8zxlgbEmUlslSMTIeU/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/7Vzd3FOIKKI" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/8850874551637619701/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/06/problems-with-double-sided-printing-in.html#comment-form" title="2 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/8850874551637619701?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/8850874551637619701?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/7Vzd3FOIKKI/problems-with-double-sided-printing-in.html" title="Problems with double sided printing in adobe acrobat pro" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>2</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/06/problems-with-double-sided-printing-in.html</feedburner:origLink></entry><entry gd:etag="W/&quot;DkAESXo9fyp7ImA9WxFUEk4.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-4735900556224164833</id><published>2010-06-22T20:20:00.004+01:00</published><updated>2010-06-22T20:25:08.467+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2010-06-22T20:25:08.467+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Solutions" /><title>Highlight Duplicates in Excel 2003</title><content type="html">In Excel 2003 there isn't a way to highlight duplicate items so i have  written this VBA script to do it for you, just copy and past the script  below. You will need to sort the data before you can run this script.  You can change the values in the colour argument to change the colour  that the cells will be high lighted in.&lt;br /&gt;
&lt;br /&gt;
Sub FindDuplicates()&lt;br /&gt;
'&lt;br /&gt;
'  !!NOTE: You MUST select the FIRST cell in the column and&lt;br /&gt;
' make sure  that the column is SORTED before running this macro!!&lt;br /&gt;
'&lt;br /&gt;
Application.ScreenUpdating  = False&lt;br /&gt;
&lt;br /&gt;
colour = RGB(255, 0, 0)&lt;br /&gt;
FirstItem = ActiveCell.Value&lt;br /&gt;
SecondItem  = ActiveCell.Offset(1, 0).Value&lt;br /&gt;
Offsetcount = 1&lt;br /&gt;
Do While  ActiveCell &amp;lt;&amp;gt; ""&lt;br /&gt;
If FirstItem = SecondItem Then&lt;br /&gt;
ActiveCell.Offset(Offsetcount,  0).Interior.Color = colour&lt;br /&gt;
Offsetcount = Offsetcount + 1&lt;br /&gt;
SecondItem  = ActiveCell.Offset(Offsetcount, 0).Value&lt;br /&gt;
Else&lt;br /&gt;
ActiveCell.Offset(Offsetcount,  0).Select&lt;br /&gt;
FirstItem = ActiveCell.Value&lt;br /&gt;
SecondItem =  ActiveCell.Offset(1, 0).Value&lt;br /&gt;
Offsetcount = 1&lt;br /&gt;
End If&lt;br /&gt;
Loop&lt;br /&gt;
&lt;br /&gt;
ActiveCell.Offset(-1,  0).Select&lt;br /&gt;
&lt;br /&gt;
FirstItem = ActiveCell.Value&lt;br /&gt;
SecondItem =  ActiveCell.Offset(-1, 0).Value&lt;br /&gt;
Offsetcount = -1&lt;br /&gt;
Do While  ActiveCell &amp;lt;&amp;gt; ""&lt;br /&gt;
If FirstItem = SecondItem Then&lt;br /&gt;
ActiveCell.Offset(Offsetcount,  0).Interior.Color = colour&lt;br /&gt;
Offsetcount = Offsetcount - 1&lt;br /&gt;
SecondItem  = ActiveCell.Offset(Offsetcount, 0).Value&lt;br /&gt;
Else&lt;br /&gt;
ActiveCell.Offset(Offsetcount,  0).Select&lt;br /&gt;
FirstItem = ActiveCell.Value&lt;br /&gt;
SecondItem =  ActiveCell.Offset(Offsetcount, 0).Value&lt;br /&gt;
Offsetcount = -1&lt;br /&gt;
End If&lt;br /&gt;
Loop&lt;br /&gt;
&lt;br /&gt;
Application.ScreenUpdating  = True&lt;br /&gt;
&lt;br /&gt;
End Sub&lt;br /&gt;
&lt;br /&gt;
This macro will process one column at a  time and it will process the entire column.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-4735900556224164833?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/ByX4E36BvABCfpeyou3a8oCwwTw/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/ByX4E36BvABCfpeyou3a8oCwwTw/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/ByX4E36BvABCfpeyou3a8oCwwTw/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/ByX4E36BvABCfpeyou3a8oCwwTw/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/iQXeN-5Dsao" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/4735900556224164833/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/06/highlight-duplicates-in-excel-2003.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/4735900556224164833?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/4735900556224164833?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/iQXeN-5Dsao/highlight-duplicates-in-excel-2003.html" title="Highlight Duplicates in Excel 2003" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/06/highlight-duplicates-in-excel-2003.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CkINQnszfyp7ImA9WxFUEkk.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-4018841951705512565</id><published>2010-06-22T20:19:00.002+01:00</published><updated>2010-06-22T22:03:13.587+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2010-06-22T22:03:13.587+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Solutions" /><title>Move a Sheet in Ecxel using VBA</title><content type="html">I recently found the need to make a little button that would copy an  entire sheet from a template document into a target document the VBA  code needed to simply select and copy a sheet is:&lt;br /&gt;
&lt;br /&gt;
Sheets("sheet  name").Select&lt;br /&gt;
Sheets("sheet name").Copy Before:=Workbooks("target  workbook name").Sheets("sheet name")&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-4018841951705512565?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/xuNS5y36PpPGYE9QshtzXBGCAOE/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/xuNS5y36PpPGYE9QshtzXBGCAOE/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/xuNS5y36PpPGYE9QshtzXBGCAOE/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/xuNS5y36PpPGYE9QshtzXBGCAOE/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/I5ZPnhs-orQ" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/4018841951705512565/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/06/move-sheet-in-ecxel-using-vba.html#comment-form" title="1 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/4018841951705512565?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/4018841951705512565?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/I5ZPnhs-orQ/move-sheet-in-ecxel-using-vba.html" title="Move a Sheet in Ecxel using VBA" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>1</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/06/move-sheet-in-ecxel-using-vba.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CkEGSHk9eyp7ImA9WxFUEkk.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-8182470165492316452</id><published>2010-06-22T20:18:00.003+01:00</published><updated>2010-06-22T22:03:49.763+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2010-06-22T22:03:49.763+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Tips" /><category scheme="http://www.blogger.com/atom/ns#" term="Solutions" /><title>Adobe InDesign 'Falure to PDF' error</title><content type="html">I have created a template in Adobe &lt;span class="goog-spellcheck-word"&gt;InDesign&lt;/span&gt; for a style of document that  is used quite frequently. Recently the completed documents have started  throwing up a 'Failure to PDF' error when exporting to &lt;span class="goog-spellcheck-word"&gt;PDF&lt;/span&gt;. As far as I  can tell the reason this happens is due to the security features related  to any &lt;span class="goog-spellcheck-word"&gt;PDFs&lt;/span&gt; linked into the document. The copyright security features  prevent the document from creating a new &lt;span class="goog-spellcheck-word"&gt;PDF&lt;/span&gt; incorporating any &lt;span class="goog-spellcheck-word"&gt;PDFs&lt;/span&gt; in  the document. The best way to solve this I have discovered is to change  the &lt;span class="goog-spellcheck-word"&gt;PDF&lt;/span&gt; files into &lt;span class="goog-spellcheck-word"&gt;jpegs&lt;/span&gt;, a really easy way to do this is to download &lt;a href="http://www.download.com/Virtual-Image-Printer-Free/3000-2084_4-10653927.html?tag=mncol" target="_blank"&gt;Virtual Image Printer&lt;/a&gt; from www.download.com, it's  free and creates pretty good quality &lt;span class="goog-spellcheck-word"&gt;jpegs&lt;/span&gt;, the relink all of the &lt;span class="goog-spellcheck-word"&gt;PDF&lt;/span&gt;  files to the new &lt;span class="goog-spellcheck-word"&gt;jpeg&lt;/span&gt; version you have created, this should solve the  problem. More info can be found on the &lt;a href="http://community.adobe.com/help/search.html?q=failure+to+pdf&amp;amp;x=0&amp;amp;y=0&amp;amp;lbl=indesign_product_adobelr&amp;amp;self=0&amp;amp;hl=en_US&amp;amp;area=0" target="_blank"&gt;Adobe Forums&lt;/a&gt;.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-8182470165492316452?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/bLCH3p-wSoS4BAqXm4tyZ748Eos/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/bLCH3p-wSoS4BAqXm4tyZ748Eos/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/bLCH3p-wSoS4BAqXm4tyZ748Eos/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/bLCH3p-wSoS4BAqXm4tyZ748Eos/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/nQUz4M_kEeA" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/8182470165492316452/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/06/adobe-indesign-falure-to-pdf-error.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/8182470165492316452?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/8182470165492316452?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/nQUz4M_kEeA/adobe-indesign-falure-to-pdf-error.html" title="Adobe InDesign 'Falure to PDF' error" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/06/adobe-indesign-falure-to-pdf-error.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CkEARno9fyp7ImA9WxFUEkk.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-3573433076376874125</id><published>2010-06-22T20:17:00.001+01:00</published><updated>2010-06-22T22:04:07.467+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2010-06-22T22:04:07.467+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Tips" /><title>Rendering Glass and other Transparent Materials in Indigo from Sketchup</title><content type="html">Lately I have been trying to render a few items that include some glass  parts using the &lt;a href="http://www.indigorenderer.com/" target="_blank"&gt;Indigo  Render&lt;/a&gt; Engine. Every time I rendered the image the glass would come  out black. I was using the &lt;a href="http://sketchup.google.com/" target="_blank"&gt;Sketchup&lt;/a&gt; Background Black environment as i wanted to  use my own light sources. By chance I tried to render the same image  using the Sun and Sky environment and the glass magically became  transparent. I have found that the preset glass material only works well  with the Sun and Sky environment. If you want to use your own light  source it's a bit more complicated.&lt;br /&gt;
&lt;br /&gt;
First create a new colour  that is the shade you want you glass to be, i.e. with a slight blue hint  or tinted black etc. and make it a phong material (or use the car paint  preset). Then create another new material, this one we will paint the  surface with, make this a blend material and select the A material as  none and the B material as you glass colour. you can adjust the  transparency of the glass by changing the blend ratio of these materials  (1 being opaque and 0 being completely transparent) i suggest a value  of between 0.3 and 0.5 as this gives a good reflection and colour in the  glass but maintains transparency.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-3573433076376874125?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/4dGarINvJc8W3WY3UeKEUauhUbI/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/4dGarINvJc8W3WY3UeKEUauhUbI/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/4dGarINvJc8W3WY3UeKEUauhUbI/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/4dGarINvJc8W3WY3UeKEUauhUbI/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/BE2kvEiM9is" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/3573433076376874125/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/06/rendering-glass-and-other-transparent.html#comment-form" title="1 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/3573433076376874125?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/3573433076376874125?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/BE2kvEiM9is/rendering-glass-and-other-transparent.html" title="Rendering Glass and other Transparent Materials in Indigo from Sketchup" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>1</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/06/rendering-glass-and-other-transparent.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CkEDR3czcSp7ImA9WxFUEkk.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-4053102500263338281</id><published>2010-06-22T20:16:00.003+01:00</published><updated>2010-06-22T22:04:36.989+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2010-06-22T22:04:36.989+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Tips" /><title>Combining Cells in Excel</title><content type="html">A while back I was asked if there was a way to combine cells in Excel.  The answer is there isn't, what you have to do is write a formula in the  destination cell that reads '=A&amp;amp; &amp;amp;B&amp;amp; &amp;amp;C&amp;amp; &amp;amp;...'  or you can use the 'Concentiate' function. Either way the cells that you  want to combine must still exist as discreet cells you simply add an  extra cell to combine the others together in.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-4053102500263338281?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/6Vhjf4MeFFylPCzh32SC2mrrg7w/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/6Vhjf4MeFFylPCzh32SC2mrrg7w/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/6Vhjf4MeFFylPCzh32SC2mrrg7w/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/6Vhjf4MeFFylPCzh32SC2mrrg7w/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/_ehib8w3Wqw" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/4053102500263338281/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/06/combining-cells-in-excel.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/4053102500263338281?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/4053102500263338281?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/_ehib8w3Wqw/combining-cells-in-excel.html" title="Combining Cells in Excel" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/06/combining-cells-in-excel.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CkAERXszeip7ImA9WxFUEkk.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-4170200687879872091</id><published>2010-06-22T20:15:00.001+01:00</published><updated>2010-06-22T22:05:04.582+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2010-06-22T22:05:04.582+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Solutions" /><title>Creating a Date Stamp in Excel</title><content type="html">Strictly speaking the date stamp in Excel is done by pressing Ctrl + ;  however if you would like to place a date stamp automatically when data  is entered into a specific cell the i find that the following formula  works well.&lt;br /&gt;
&lt;br /&gt;
=NOW()&lt;br /&gt;
&lt;br /&gt;
This will place the current date and  time e.g. 15/08/2008 13:57. The down side is that every time the sheet  recalculates i.e. any time enter or return is pressed the date stamp is  updated. The easiest way around this is to create a circular statement.  For example if when data is entered in to cell A1 you want to place a  date stamp in B1 then the following formula will work.&lt;br /&gt;
&lt;br /&gt;
=IF(A1="","",IF(B1="",NOW(),B1))&lt;br /&gt;
&lt;br /&gt;
However  due to the circular reference which basically stop the cell  recalculating an error will be returned. To stop this go to  Tools&amp;gt;Option select the Calculation tab and tick the Iterations  box. This will solve the circular reference problem.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-4170200687879872091?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/5COXxerfDUQy8W93fykwTHVIuu4/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/5COXxerfDUQy8W93fykwTHVIuu4/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/5COXxerfDUQy8W93fykwTHVIuu4/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/5COXxerfDUQy8W93fykwTHVIuu4/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/VP_POZCEm44" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/4170200687879872091/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/06/creating-date-stamp-in-excel.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/4170200687879872091?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/4170200687879872091?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/VP_POZCEm44/creating-date-stamp-in-excel.html" title="Creating a Date Stamp in Excel" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/06/creating-date-stamp-in-excel.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CkAAR3Y6eSp7ImA9WxFUEkk.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-4161045249487512614</id><published>2010-06-22T20:14:00.004+01:00</published><updated>2010-06-22T22:05:46.811+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2010-06-22T22:05:46.811+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Tips" /><category scheme="http://www.blogger.com/atom/ns#" term="Solutions" /><title>Removing alert Messages in VBA</title><content type="html">I had written a VBA script that copied information from one workbook to  another, every time the info was copies an alert popped up that had to be  confirmed. This was tiresome to say the least, after much research and a  little help form the Microsoft Forums writing the line&lt;br /&gt;
&lt;br /&gt;
Application.DisplayAlert  = False &lt;br /&gt;
&lt;br /&gt;
just before the 'paste' command prevents this alert from  popping up.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-4161045249487512614?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/hYSbMacVf-uA61eqBSrfdyfXyTU/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/hYSbMacVf-uA61eqBSrfdyfXyTU/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/hYSbMacVf-uA61eqBSrfdyfXyTU/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/hYSbMacVf-uA61eqBSrfdyfXyTU/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/Hue6adFjrhQ" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/4161045249487512614/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/06/removing-alert-messages-in-vba.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/4161045249487512614?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/4161045249487512614?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/Hue6adFjrhQ/removing-alert-messages-in-vba.html" title="Removing alert Messages in VBA" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/06/removing-alert-messages-in-vba.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CkADQX8yeip7ImA9WxFUEkk.&quot;"><id>tag:blogger.com,1999:blog-4370033892924632324.post-450907014167218515</id><published>2010-06-22T20:13:00.001+01:00</published><updated>2010-06-22T22:06:10.192+01:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2010-06-22T22:06:10.192+01:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Cool" /><title>3D Wii</title><content type="html">I've just been show this awesome video of this guy who has basically  reversed the Wii and turned it from being a 2D into a 3D device. Just  check it out, you'll see what  mean.&lt;br /&gt;
&lt;a href="http://www.youtube.com/watch?v=Jd3-eiid-Uw" target="_blank"&gt;Wii  Head Tracking&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4370033892924632324-450907014167218515?l=chrisnewcouk.blogspot.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/crFpqZZTiJbGzFCMRjHcQX4IxsI/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/crFpqZZTiJbGzFCMRjHcQX4IxsI/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/crFpqZZTiJbGzFCMRjHcQX4IxsI/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/crFpqZZTiJbGzFCMRjHcQX4IxsI/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/WHeyd/~4/I0cP0LgZwqw" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://chrisnewcouk.blogspot.com/feeds/450907014167218515/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://chrisnewcouk.blogspot.com/2010/06/3d-wii.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/450907014167218515?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/4370033892924632324/posts/default/450907014167218515?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/blogspot/WHeyd/~3/I0cP0LgZwqw/3d-wii.html" title="3D Wii" /><author><name>Chris New</name><uri>http://www.blogger.com/profile/11865064747123629845</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="16" height="16" src="http://img2.blogblog.com/img/b16-rounded.gif" /></author><thr:total>0</thr:total><feedburner:origLink>http://chrisnewcouk.blogspot.com/2010/06/3d-wii.html</feedburner:origLink></entry></feed>

