Welcome to the IHoP v.2

[topgun 262]

Add another column with a indicator of a milestone, say an X then do an If statement to search for the X's?  

[The enD 467]

[///M5 2,833]

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

[Penguin4x4 1,761]

[Penguin4x4 1,761]

[The enD 467]

[Penguin4x4 1,761]

[Godsmack 361]

Nice wrestling .gif's LOL

J

[///M5 2,833]

Something I rarely share, but have some that I finally can. Work pics to follow.

[topgun 262]

About time you work on something without NDA's.  

[///M5 2,833]

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 />

[///M5 2,833]

Aargh, sometimes I really hate this forum software

Test

[///M5 2,833]

[///M5 2,833]

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.

[///M5 2,833]

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.

[///M5 2,833]

Doing some work with active noise cancellation utilizing the audio systems of cars as well. That is public, the techniques however are not.

[Quentin Jarrell 671]

When did they switch the Bette from Mg to Al ?

[///M5 2,833]

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).

[///M5 2,833]

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.

[///M5 2,833]

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" />

[///M5 2,833]

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" />

[///M5 2,833]

FUCK

http://armpictures.com/image/2013/12/corvette-stingray-12510-wallpaper.jpg[/img

[///M5 2,833]

Serious bullshit

[///M5 2,833]

[///M5 2,833]

I give up