Useless Conversation

[Draegan]

Anyone here really good with excel?  I can't find a way to do this online, so I'm going to ask here.  I have a spreadsheet that has 20 or so columns with fields like Company Name, Street, State, Zip, SIC Code, Title, First Name, Last Name, Email, Title2, First, Last, Email etc.  I want to be able to create multiple sheets in the same workbook based on SIC Code.  It essentially bundles all the same SIC Coded rows in the same, new sheet. 

Halp

[Paelos]

Perhaps this will help? http://en.kioskea.net/forum/affich-22070-auto-generate-and-name-worksheets-from-a-list

[rattran]

Vortex is great, good burgers, beer, terribad service. The Bleu Shroom burger with sweet potato fries is awesome.

Culvers' has been changing their burgers here, they keep getting thinner and greasier. Still the biggest chain in the area, except maybe McDs.

[Salamok]

Anyone here really good with excel?  I can't find a way to do this online, so I'm going to ask here.  I have a spreadsheet that has 20 or so columns with fields like Company Name, Street, State, Zip, SIC Code, Title, First Name, Last Name, Email, Title2, First, Last, Email etc.  I want to be able to create multiple sheets in the same workbook based on SIC Code.  It essentially bundles all the same SIC Coded rows in the same, new sheet. 

Halp

I would just keep it as 1 sheet and autofilter by SIC code.

[Draegan]

Perhaps this will help? http://en.kioskea.net/forum/affich-22070-auto-generate-and-name-worksheets-from-a-list

That seems to just create a new worksheet for each line.  I want to group multiple lines into the same sheet based on whether a certain column is identical.

So if you have a series of data like this:

Code:

IND_CODE	IND_DESC	SIC_CODE	SIC_DESC
10	Food & Beverage	2082	Malt Beverages
12	Industrial Manufacturing	2711	Newspaper: Publishing, or Publishing & Printing
8	Metals & Minerals	3399	Primary Metal Products
3	Transmission (Oil & Gas)	4922	Natural Gas Transmission
7	Chemical Processing (CPI)	2899	Chemicals & Chemical Preparations
8	Metals & Minerals	3316	Cold Rolled Steel Sheets & Bars
10	Food & Beverage	2062	Cane Sugar Refining
7	Chemical Processing (CPI)	2821	Plastics Materials, Elastomers & Resins
7	Chemical Processing (CPI)	2821	Plastics Materials, Elastomers & Resins
1	Power	4931	Electricity/Steam [IPP]
8	Metals & Minerals	3221	Glass Containers
7	Chemical Processing (CPI)	2812	Alkalies & Chlorine
9	Pulp, Paper & Wood	2657	Folding Paperboard Boxes, Including Sanitary

I want to group all the same SIC_Codes together in their own sheet.
--

Salamok: I want to keep them separate because I'll be running mailers off of each sheet.  Also, I want to be able to write notes on each sheet as well.

[Yegolev]

Best Burger in Atlanta is at the Vortex, imo. It's a weird sort of dive bar that's been around for 20 years. I like a bacon burger with the whiskey pimento cheese.

I'll second this, but it's not really a dive.  Well, the one on P'tree isn't, not sure about the one in Little 5.  I was there (P'tree) last month and it was great.  Super scotch selection as well.  Saw Kevin McDonald.  Not his show, just him.  My friend who we took there for his birthday hugged Kevin since he hurt Kevin's feelings telling him we wouldn't be attending his show since we were drinking and eating awesome burgers.

Edit for Excel.  No idea what sort of black magic is required for this in Excel, so I suggest you install cygwin and write a short program to parse/sort CSV.

[rattran]

I've never been to the one on Ptree, but the one in Little 5 qualifies as a dive. Like pretty much everything in Little 5.

[Paelos]

I've never been to the one on Ptree, but the one in Little 5 qualifies as a dive. Like pretty much everything in Little 5.

Yep the one on 5 points (the original) is the dive.

[ghost]

So we're getting the kid a fishtank for his birthday.   

[schild]

The best burger in Phoenix was at Heart Attack Grill before they stopped cooking their burgers on a griddle with all sorts of fatty residue. Now there isn't a good non-fastfood burger in Phoenix. Shame, really, but Phoenix blows so whatever.

Five Guys is a pretty good oldschool shitty diner burger. In-N-Out is still better. But if I want a greasy burger in Austin I'm going to one of fifty different places - like Your Mom's Burger Bar.

Come to think of it, I actually haven't had an actual shitty burger here. Yay Texas. Racism and good beef.

[Ingmar]

Spoiled for good burgers here. Clarke's, Kirk's, the Counter if you want to go snooty.

[Tale]

Gettin hot here: http://www.bom.gov.au/nsw/observations/sydney.shtml

It's so hot they had to add a new color for their temperature maps

Holy fuck.  54C = 129F.  I'd say good thing that's the middle of the landmass but somehow, I don't think that helps much.  Especially not with all the red around which translates to the 90sF?  Ugh.  And I much prefer being warm/hot to being cold.

It was 109f in Sydney yesterday.

I cycled to and from work in it, 14km of hills each way :) Concentrated on hydrating the previous day, and all day at work in the air conditioning, to make sure I would be okay. Went up the hills at a moderate pace, maximum efficiency, trying not to let my body heat up, and used the sweat and rushing air to cool me on the way down. Was pretty tired the next day though.

BTW they backtracked on the "new colour on the temperature map". Somebody got a bit carried away.

[Yegolev]

dat quote nesting

[Signe]

NEW CATTOO! 



I'm so happy!  It's still red and a bit swollen but there was a lot of detail and shading.  It took like 3 hours or so.  Once it's healed you can see more of the detail.  It's based on a sculpture my sister made for me and she'll enter it in her next show.  I'm so fucking lucky to have an incredible artist for a sister and a tattoo artist who can do anything.  Too bad you can't see the whole thing... it has a dead rabbit in it's claw.  Dinner.  I have to go back in a week or so for a piercing and I'll get something smaller maybe on my hand.  Suggestions are welcome!  I was thinking maybe of this... not because I love the game, which I do, but because I think the image is awesome.  But probably without the background.

[Tale]

That's amazing Signe. Awesome.

[Salamok]

Perhaps this will help? http://en.kioskea.net/forum/affich-22070-auto-generate-and-name-worksheets-from-a-list

That seems to just create a new worksheet for each line.  I want to group multiple lines into the same sheet based on whether a certain column is identical.

So if you have a series of data like this:

Code:

IND_CODE	IND_DESC	SIC_CODE	SIC_DESC
10	Food & Beverage	2082	Malt Beverages
12	Industrial Manufacturing	2711	Newspaper: Publishing, or Publishing & Printing
8	Metals & Minerals	3399	Primary Metal Products
3	Transmission (Oil & Gas)	4922	Natural Gas Transmission
7	Chemical Processing (CPI)	2899	Chemicals & Chemical Preparations
8	Metals & Minerals	3316	Cold Rolled Steel Sheets & Bars
10	Food & Beverage	2062	Cane Sugar Refining
7	Chemical Processing (CPI)	2821	Plastics Materials, Elastomers & Resins
7	Chemical Processing (CPI)	2821	Plastics Materials, Elastomers & Resins
1	Power	4931	Electricity/Steam [IPP]
8	Metals & Minerals	3221	Glass Containers
7	Chemical Processing (CPI)	2812	Alkalies & Chlorine
9	Pulp, Paper & Wood	2657	Folding Paperboard Boxes, Including Sanitary

I want to group all the same SIC_Codes together in their own sheet.
--

Salamok: I want to keep them separate because I'll be running mailers off of each sheet.  Also, I want to be able to write notes on each sheet as well.

Well then it depends on how many sheets you are going to create, if it is a reasonable amount I would just do it manually and use the autofilter method to select your data then just copy and paste that selection to a new sheet.  Other than that the only way I can think of is to use VBA, maybe newer versions of excel have something built in that does this.

[Yegolev]

I haven't been able to find it in Excel 2012.  Doesn't mean it's not there, but I've given up.

Signe, that's a cool image but I'd suggest getting one of a Dahl loot box on your back so when you go on your shooting rampage you can yell MIDGET LOVER at everyone and then when the cops take you down they'll try to loot you.

[Tale]

[Salamok]

I'm going to call bullshit on that one Tale, I know Fosters is the crap Aussie beer but I was recently being subjected to one of my wife's crappy Australian crime drama's and the drug dealing bikers in the bar were in fact drinking Fosters.  I suppose you could manufacture some conspiracy that the Aussie TV producers knew that this particular crime drama would eventually be seen outside of Australia and purposely put some Fosters in there so non Australians wouldn't come after your good beer but I think that might be reaching a bit.  More likely the beer company paid to have their can spotted in a bar, but even then why do that if you aren't even selling your beer in the country that the show is being made for?

A more accurate Fosters statement is that the shit Fosters we get in the states is made in Canada and is even shittier than the Fosters made in Australia where it is known as the shittiest of Australian beers.

[Yegolev]

Nah, we don't drink it here either.

[JWIV]

I'll just throw as shown in "The Wire" that while Boh isn't made here, Baltimore does in fact drink it.  A lot.   

[Draegan]

I haven't been able to find it in Excel 2012.  Doesn't mean it's not there, but I've given up.

Signe, that's a cool image but I'd suggest getting one of a Dahl loot box on your back so when you go on your shooting rampage you can yell MIDGET LOVER at everyone and then when the cops take you down they'll try to loot you.

The whole sheet is around a 1000 rows long with many different codes.  Doing it manually might take all day long.  Was hoping to find a macro or something to run it.

On a happy note I got my NVidia Surround Working!







Since my high res Shimian Korean monitor does not have the proper sync polarity as my two new dells, I had to use my older HP monitor and it's now sitting on its own stand on the right and doesn't look "cool".  HP is a bunch of retard though as the mounting screw holes in the back are not centered.  There are six holes on the back and most mounting brackets are square, that mount at each corner.  So the monitor will start leaning to the left or right (it's also older so it's heavier).

Anyway, here is my set up.  Things to do in the future:
Buy another Dell monitor.
Buy a taller single arm mount for the fourth monitor so it can be mounted above the triple display.
Use older single mount for new Dell monitor on right hand side.

But for now I think I can survive.

And yes, I was watching MSNBC at the time. 

[bhodi]

There's a whole weird thing going on with Adobe and links to older software on their website being offered for free. Or not. Or something. No one is sure.

But this is the revised link that they put up, which works, directly from their website, for photoshop CS2 and older adobe software. A bit outdated, but great for most people.

http://www.adobe.com/downloads/cs2_downloads/index.html

If you have any interest, I'd get it before it's taken down and declared a misunderstanding.

[RhyssaFireheart]

Someone please tell the gnomes pounding nails into my sinuses to stop.  I'd like to not feel like the front of my face is going to fall off (plus my ears hurt like hell now, too).

[Signe]

Please don't die.      Both my sister and brother in law had this terrible flu going around.  PA is one of the states with the worst outbreak.  I hid upstairs in the closet for three weeks to avoid them!  I hope you feel better soon.  Being sick sucks.  I should have taken out stock in Ricola and Ramen... it's all they ate.

And, just in case you were thinking it, Halle Berry's face is reserved for my transplant!

[Tale]

I'm going to call bullshit on that one Tale, I know Fosters is the crap Aussie beer but I was recently being subjected to one of my wife's crappy Australian crime drama's and the drug dealing bikers in the bar were in fact drinking Fosters..

When was this drama set? You're arguing with me about what's at the local bars and shops! The Wikipedia entry says how it is. It would be possible to obtain, but they've stopped trying to sell it to us. Fosters the company is among the brand owners, but Toohey's New, Victoria Bitter, West End, XXXX, are the basic crap beers, depending on which state you're in.

[Ironwood]

I liked Tooheys.

[Salamok]

I'm going to call bullshit on that one Tale, I know Fosters is the crap Aussie beer but I was recently being subjected to one of my wife's crappy Australian crime drama's and the drug dealing bikers in the bar were in fact drinking Fosters..

When was this drama set? You're arguing with me about what's at the local bars and shops! The Wikipedia entry says how it is. They've stopped trying to sell it to us. Fosters the company is among the brand owners, but Toohey's New, Victoria Bitter, West End, XXXX, are the basic crap beers, depending on which state you're in.

It was one of the apparently endless stream of docudramas covering organized crime and the drug trade from 1980-2005.  I think it was the David Wenham one but maybe it was underbelly or animal kingdom.  The only thing that was remotely interesting to me during this 50 hour diversion was fantasizing that the ending of the Wenham series would be where his character enters into witness protection and gets his name changed to John Spiteri.  It would have been a much more awesome story if it was just a prequel to Gettin' Square, would also explain the Spits eloquence in the court room.

[Engels]

Random tidbit. Amazon just converted any CD purchase since '98 to MP3 in your MP3 library. May want to check your account. It was nice to see my MP3 albums go from 6 to 28 overnight.

[DevilsAdvocate25]

I haven't been able to find it in Excel 2012.  Doesn't mean it's not there, but I've given up.

Signe, that's a cool image but I'd suggest getting one of a Dahl loot box on your back so when you go on your shooting rampage you can yell MIDGET LOVER at everyone and then when the cops take you down they'll try to loot you.

Excel's not really very good at what you are trying to do. It treats each cell as a separate entity. Probably the right thing to do would be to import this into Access or Oracle. Then it would be a true "database" and you could just write SQL to get what you wanted.

If I had to do it in Excel, I would initially try some really convoluted formulas and then just resort to what has already been posted. Basically, duplicate the tab as many times as you have SIC Codes and then filter each one by whatever SIC Code you want for that tab.

[Yegolev]

It's good to confirm that I was right in giving up.

[WayAbvPar]

Random tidbit. Amazon just converted any CD purchase since '98 to MP3 in your MP3 library. May want to check your account. It was nice to see my MP3 albums go from 6 to 28 overnight.

Very cool. Unfortunately I don't seem to have purchased any CDs from Amazon during that time. I am old.

e- I take that back- 3 CD sets I bought as gifts just got Auto-Ripped. Luckily they are bands I also like 

[Sky]

Random tidbit. Amazon just converted any CD purchase since '98 to MP3 in your MP3 library. May want to check your account. It was nice to see my MP3 albums go from 6 to 28 overnight.

Not seeing it in mine yet.

I also have nowhere near enough room in my free 250 songs for the hundreds of albums I've bought since 98. Although I switched to Amazon later, around 2006, after FYE nuked my several thousand-deep wish list in a web upgrade.

edit - ooook. So it took a while to find 590 songs. And it still says I can upload 250. That's cool.

[rattran]

Seems none of the cds I've purchased qualify, except Bad Manners. At least I can stream Special Brew when I need to now.

[Sky]

Looks like I ended up with about 700 songs, 10% of my iTunes library, which is probably a bit over half my actual collection.