October 30, 201311 yr Add another column with a indicator of a milestone, say an X then do an If statement to search for the X's?
October 30, 201311 yr Hey guys,I am doing some work in excel and really can't think of a way to search to find my answer.I have some tasks that are labeled with "milestones" (ex: introduction, work, wrap-up)There are 3-5 tasks per milestone, that have beginning and end dates. I want excel to search the task for each milestone for the minimum and maximum dates and place them on a different sheet. However I can't think of the way to make excel check a cell before reading a different cell.simple if statement
October 30, 201311 yr Something I rarely share, but have some that I finally can. Work pics to follow.
October 30, 201311 yr 2014 Corvette<br /><img data-cke-saved-src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0668_zps9d66a381.jpg" src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0668_zps9d66a381.jpg" /><br /><img data-cke-saved-src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0667_zpsbd37521c.jpg" src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0667_zpsbd37521c.jpg" /><br /><br />2014 Acura MDX<br /><img data-cke-saved-src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0670_zpsec5c1733.jpg" src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0670_zpsec5c1733.jpg" /><br /><br /><br />2014 Silverado<br /><img data-cke-saved-src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0672_zps72ffb6fd.jpg" src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0672_zps72ffb6fd.jpg" /><br /><img data-cke-saved-src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0671_zps3a344054.jpg" src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0671_zps3a344054.jpg" /><br /><br />2014 MDZ<br /><img data-cke-saved-src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0675_zps14505a8f.jpg" src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0675_zps14505a8f.jpg" /><br /><img data-cke-saved-src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0674_zps96c38495.jpg" src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0674_zps96c38495.jpg" /><br /><img data-cke-saved-src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0673_zps8a1241df.jpg" src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0673_zps8a1241df.jpg" /><br /><br />2014 Range Rover<br /><img data-cke-saved-src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0669_zpsbb4c1fd9.jpg" src="http://i1238.photobucket.com/albums/ff492/SeansPhototbucket/IMAG0669_zpsbb4c1fd9.jpg" /><br />
October 30, 201311 yr About time you work on something without NDA's. Ha, that doesn't happen really ever, just happened to be invited somewhere that this was all a bit of public domain. This is about the stage where my work normally starts. FEA correlation, noise source identification, damping placement, and more of course.
October 30, 201311 yr The different colors above signify different materials. For instance the dash assembly in the MDX is magnesium, the vette/rover all aluminum. On the Silvy it is mostly different tensile strength steel. ALL of it has to be verified for structural integrity and optimized for NVH behavior. Generically speaking that is what we do.
October 30, 201311 yr Doing some work with active noise cancellation utilizing the audio systems of cars as well. That is public, the techniques however are not.
October 30, 201311 yr Vette was never Mg, had some Mg in it. Currently it is using the single largest hydroformed piece of alum in the world as part of its frame. Cool that they implemented shape memory alloy in the venting system for the rear hatch as well. If you don't know what shape memory alloys are it is worth a google. Super fucking cool. I've been working with a few Nasa spin offs that are making a solid state airplane (ie no motors to run the wings or engine, but it will fly).
October 30, 201311 yr Lots of cool techniques going into making it work too. You can ask questions, but you'll have to google a bunch as I can only share published stuff.
October 30, 201311 yr Hmmm<br /><img data-cke-saved-src="http://www.imaginelifestyles.com/luxuryliving/wp-content/uploads/2012/11/ferrari-f12-front.jpg" src="http://www.imaginelifestyles.com/luxuryliving/wp-content/uploads/2012/11/ferrari-f12-front.jpg" /><br /><img data-cke-saved-src="http://armpictures.com/image/2013/12/corvette-stingray-12510-wallpaper.jpg" src="http://armpictures.com/image/2013/12/corvette-stingray-12510-wallpaper.jpg" />
October 30, 201311 yr FUCK<br /><br />http://armpictures.com/image/2013/12/corvette-stingray-12510-wallpaper.jpg[/img<br /><img data-cke-saved-src="http://www.imaginelifestyles.com/luxuryliving/wp-content/uploads/2012/11/ferrari-f12-front.jpg" src="http://www.imaginelifestyles.com/luxuryliving/wp-content/uploads/2012/11/ferrari-f12-front.jpg" />
October 30, 201311 yr FUCK http://armpictures.com/image/2013/12/corvette-stingray-12510-wallpaper.jpg[/img
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.