What's that? You wanna chit chat? Welcome to the whore thread!

Aatish · 10-13-2016, 01:36 PM

Quote:

Originally Posted by anglo

Dakar yellow > Austin Yellow

Phoenix Yellow

Dang3r · 10-13-2016, 01:41 PM

Those yellow colors make me puke

Yas Marina is a nice color but nothing comes above Blue Estoril II

Banana Hammock · 10-13-2016, 01:43 PM

Phoenix Yellow takes the win. Austin Yellow is just gross.

Aatish · 10-13-2016, 01:48 PM

E46 factory color options were legendary

UncleWede · 10-13-2016, 01:51 PM

Quote:

Originally Posted by Biorin

Can we get some more information? Are you saying, for example, Column A has unique identifiers 1-10, and you want to create one sheet with identifier 1, one sheet with identifier 2, etc?

Both sheets have something akin to SSN. I need to group by that, to match up the person's name (sheet A) with their address (sheet B), based on SSN.

///M Power-Belgium · 10-13-2016, 01:57 PM

Quote:

Originally Posted by duck fat

I need to take my pants off first so I don't make the same mistake twice.

Oh my god: http://www.goo-net-exchange.com/used...001/index.html

Why you didn't bought one ?
Or sell your ///M3 , the S65 has bad bearings anyway and buy the Skyline ?

RJ_ · 10-13-2016, 01:58 PM

Quote:

Originally Posted by UncleWede

Both sheets have something akin to SSN. I need to group by that, to match up the person's name (sheet A) with their address (sheet B), based on SSN.

This is basically a vlookup based on the unique ID, is it not?

shoei · 10-13-2016, 02:00 PM

Quote:

Originally Posted by anglo

Quote:

Originally Posted by duck fat

Ahh crap I knew I was forgetting something.

It's hard to capture but looks really good in person.

Le Mans is nice, but this is easily my favorite blue... This and Tanzanite...

UncleWede · 10-13-2016, 02:03 PM

Quote:

Originally Posted by RJ_

This is basically a vlookup based on the unique ID, is it not?

Like I said, I could do this no problem in dBaseIII. I'll start looking at vlookup now. That lets me merge the contents into a third sheet?

Banana Hammock · 10-13-2016, 02:04 PM

Quote:

Originally Posted by ///M Power-Belgium

Why you didn't bought one ?
Or sell your ///M3 , the S65 has bad bearings anyway and buy the Skyline ?

The R34 is very taboo in California. There was a whole scandal where a company was illegally importing them and were eventually seized and crushed. So these models are very much on the radar for the cops. The only ones, at the moment, that can be legally imported and registered are the 32s because they fall under a special 25 year exemption. By the time the 34s are old enough to fall under this exemption, I'm sure all of the good ones will be stored away by some rich bastard long before it could be registered and that's assuming the 34s can get registered.

UncleWede · 10-13-2016, 02:07 PM

Quote:

Originally Posted by duck fat

By the time the 34s are old enough to fall under this exemption.

No more falling off, currently. That's why my son's 77 beetle has to keep FI engine and be smogged STILL.

suntanlinus · 10-13-2016, 02:08 PM

Tanzanite blue wins right behind space grey

Aatish · 10-13-2016, 02:11 PM

Quote:

Originally Posted by duck fat

The R34 is very taboo in California. There was a whole scandal where a company was illegally importing them and were eventually seized and crushed. So these models are very much on the radar for the cops. The only ones, at the moment, that can be legally imported and registered are the 32s because they fall under a special 25 year exemption. By the time the 34s are old enough to fall under this exemption, I'm sure all of the good ones will be stored away by some rich bastard long before it could be registered and that's assuming the 34s can get registered.

You can bring one over under show/racing use. Have to keep it under 2500 a year.

Bring one over, store it for 8 years. Profit on price increase.

Biorin · 10-13-2016, 02:11 PM

Quote:

Originally Posted by RJ_

This is basically a vlookup based on the unique ID, is it not?

Quote:

Originally Posted by UncleWede

Like I said, I could do this no problem in dBaseIII. I'll start looking at vlookup now. That lets me merge the contents into a third sheet?

No! Fuck Vlookup! Index/Match is GREATLY superior. I feel strongly about this.

I think you need to involve Indirect to pick up across different sheets, though.

Banana Hammock · 10-13-2016, 02:11 PM

Quote:

Originally Posted by UncleWede

No more falling off, currently. That's why my son's 77 beetle has to keep FI engine and be smogged STILL.

Sorry I was in a rush when I wrote that. The 25 year states that the car can be imported but the car still has to be registered. In order to register the car, it still has to pass smog.

///M Power-Belgium · 10-13-2016, 02:13 PM

Quote:

Originally Posted by Dang3r

Those yellow colors make me puke

Yas Marina is a nice color but nothing comes above Blue Estoril II

Most people get tired quickly from any kind of yellow ...

But I need to say my friend his yellow Gallardo is a eyecatcher , but he says he regrets yellow ...
He has a quality body shop for German performance cars and 2 weeks ago he said to me...Maybe I will paint the Gallardo in Miami Blue from the Turbo-S..
What do you think Philippe ?
I said to him ...It's your car and so your dicision , because I really don't know and it's really personal .Actually every color!

Biorin · 10-13-2016, 02:13 PM

Quote:

Originally Posted by RJ_

That does sound generous. No way my hourly teaching rate matches yours. If I ever find myself broken down in your neck of the woods I'll keep that in mind.

I think you should go with steelies, baller on a budget style. It's sad that you're going to miss out on driving season.

I can teach you violin, taxes, and driving like a lunatic (my coworker said coffee runs with me are like being in Formula 1). Those things don't come cheap.

Anything with hubcaps will do.

Banana Hammock · 10-13-2016, 02:13 PM

Quote:

Originally Posted by Aatish

You can bring one over under show/racing use. Have to keep it under 2500 a year.

Bring one over, store it for 8 years. Profit on price increase.

You have rekindled my determination to own one of these things.

I had already given up on it and was thinking about settling with a 33 or 32.

Aatish · 10-13-2016, 02:16 PM

Quote:

Originally Posted by duck fat

You have rekindled my determination to own one of these things.

I had already given up on it and was thinking about settling with a 33 or 32.

R34 is on my list for sure. Maybe in a couple years. Was thinking Supra, but said "F that".

UncleWede · 10-13-2016, 02:23 PM

Quote:

Originally Posted by Biorin

No! Fuck Vlookup! Index/Match is GREATLY superior. I feel strongly about this.

I think you need to involve Indirect to pick up across different sheets, though.

ASAP Tools help me do this, or do I have to actually LEARN something?

RJ_ · 10-13-2016, 02:24 PM

Quote:

Originally Posted by UncleWede

Like I said, I could do this no problem in dBaseIII. I'll start looking at vlookup now. That lets me merge the contents into a third sheet?

Something like this:

ASBSECU E93 · 10-13-2016, 02:25 PM

suntanlinus - I am partial to Space Gray as well....

...and Crimson Red

10-13-2016, 01:41 PM	#40526
Dang3r Schmollbraten 12484 Rep 1,985 Posts Drives: M4CPC // HP4 Comp. Join Date: Jun 2015 Location: Liandri Central Core iTrader: (0)	Those yellow colors make me puke Yas Marina is a nice color but nothing comes above Blue Estoril II __________________ Citizen of ///M - Town, where too much is just right Some say, that my scrotum has its own small gravity field and when Im slowing down that brake lights come on at my buttox
	Appreciate 1 Aatish3471.00

10-13-2016, 01:43 PM	#40527
Banana Hammock Beefcake 3738 Rep 711 Posts Drives: R32 GTR Join Date: Apr 2016 Location: Los Angeles iTrader: (2)	Phoenix Yellow takes the win. Austin Yellow is just gross.
	Appreciate 1 Aatish3471.00

10-13-2016, 01:48 PM	#40528
Aatish Lofty 3471 Rep 849 Posts Drives: i4 M50, 991.2 C2, RRS Diesel Join Date: Dec 2013 Location: ORD <> ATX iTrader: (0)	E46 factory color options were legendary __________________ F30 335 (FBO and BM3 OG) 991.2 C2 Range Rover Sport Diesel I4 M50 (coming soon)
	Appreciate 1 silvergray5452342.50

10-13-2016, 02:08 PM	#40536
suntanlinus Private 20 Rep 68 Posts Drives: 335is coupe space grey/coral r Join Date: Mar 2016 Location: Chicago iTrader: (0)	Tanzanite blue wins right behind space grey __________________ ST
	Appreciate 1 ASBSECU E935640.50