Jump to content

JSngry

Moderator
  • Posts

    86,214
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by JSngry

  1. Seeing Eye Dog Eagle Eye Cherry Eye Candy
  2. Off the top of my head, I know I've got a least one.
  3. Gus Johnson Budd Johnson Butter Jackson
  4. Not exactly a...crisp performance by the Rangers, but hell, after the felonious beat-downs they've endured the last five games, a little wobbliness is to be expected. It's a win! Kind of a psycho performance from the (hopefully) Inner Mounting Colby Lewis, looks unhittable for long stretches, loses it completely, and then gets it right back. All's well that wins well, but this guy's been wack (and whacked) all year. Hopefully when the wheel stops spinning it'll land on Good Colby. Good Colby is good. Also good to see a totally in-form Feliz close out. We'll need more of that. Harrison goes tomorrow, Ogando on Sunday. Both lost it before they had it the last time out, & Ogando is in uncharted waters for season's innings pitched. We might end up knocked right back on our asses. But that's things to come. Have a look at what happened tonight! an honest-to-god SWEEP!
  5. Looks really cool...don't know if I can install it on the corporate PC, but if I can...
  6. Ah, but Sunflower has "This Whole World", which in every regard (and in less than 120 seconds!) is about as close to a musical manifestation of The Benevolent Comforting & Loving Universal God We All Would Love To Believe In as White American Pop music is ever gonna be able to muster. http://www.youtube.com/watch?v=1xz5QDsYSto It also has "All I Wanna To Do", the only song (out of more than a few) that was able to bring me down from the one bad acid trip I had. So Sunflower is ok with me.
  7. There's been a cottage-industry of people doing that for years now, although it was going on before the material was officially released, and there was/is more material available than what was on the box. But yeah, there's dozens, if not more, versions of Smile floating around out there, all using pretty much the same sources, just with different sequencings, transitions, and occasionally EQ-ing. My favorite single outtake that I've heard is "George Fell Into His French Horn", a really goofy track where Brian gets the horn players to start talking into their horns. One thing leads to another, and before you know it, it gets pretty out there. Hopefully it'll be on this upcoming box.
  8. I guess you could make the argument that anything other than a single-character is "plural" in nature, i.e. - "16" = two characters, and therefore in the context of a spreadsheet could be classified as the data in a cell. I guess... Besides, "datum" is subliminally suggestive of "rectum", which is what so much data ends up being used to assault, so we probably postpone the inevitable as much as possible through linguistic aversion.
  9. Oh, but I do know where the data is coming from! And they send it specifically to me, because I'm the one guy that does something with it for them. It's coming form a disparate group of lower managers & upper-level frontline people who are copying & pasting off of intranet websites and/or spreadsheets that they complied themselves from copying out of word docs & emails & already sloppy spreadsheets. That's how you get data with spaces at the beginning and at the end. And live email hyperlinks. I hate a bigass column of live email addresses, it's like walking through a minefield, one stray twitch of the finger and BOOM you're looking a new letter that you don't want/need to sent to somebody you probably don't want/need to know. GRRRRR!!!!!! That's the first thing I do, remove all those hyperlinks, and the happiest day of my recent life was when I found out how to do them all at once. What that says about my recent life is pretty obvious, but I'm jsut sayin', it was a good day. Your link is interesting. That's not the way I do it, I use Text-To-Columns (we use Office '07, and the feature is significantly more flexible than it was in previous versions, as is Excel in general), but the LEN formula is one with which I was not familiar, so hey, something learned, always a good thing. Thanks!
  10. You'll note that Sonny never once implied that it was the people's fault for losing contact with those songs, like people are degenerating because they don't respond as much to standards anymore. Instead, he's saying that times have changed, and those songs, great as they are, don't automatically "hit the spot" with people like they used to, that it's ok for that to be happening, perhaps even natural/inevitable, and that it's more important to communicate your message than it is to expound on your medium. A pretty prescient observation, i think that is.
  11. "I Just Wasn't Made For These Times" is one of the most guileless pop songs ever written and also one of the most amazingly produced pop records ever made. That the two qualities co exist as naturally as they do is nothing shot of miraculous, what with human nature and the record business interacting like they do.
  12. Ok, here's one that's a little more variable, but still a pain. If you're putting the whole name into one cell, be consistent with whether or not a middle initial is used. Because when you use a space delimiter, you end up with all the first names in one column, most of the last names in the next column, but a few middle initials in that second column, with those last names being in a third column all by their lonesomes, Which results in the need for further cleanup. If you're asked to provide this type data, ask the person who's ultimately going to work it how they'd like it presented, but for me, if a middle initial is essential for an individual, like if it's just gotta be Roberto Q. Lewis, then your safest bet is to put first & last names in separate cells. Then it's easy to concatenate the two cells and get a single full name in a single cell, no problem with a middle initial being in there or not.. Same thing with "nicknames", like if it's "Robert (Bob) Q. Lewis" Put all that other auxiliary stuff in the same cell as the first name, or else just make it Bob Lewis and let it go at that. I'm not the only person in the world who has to deal with this, believe me. I'm not even a "tech guy", I just fell into the gig and grew with it as I went. As a result I've picked up a lot of pointers from the people who are truly to this manner born, and trust me, it matters. But like most natural geeks, they keep their complaints to themselves, because they figure they would fall on deaf ears. But I believe that the good people of this world WANT to do the right thing by their coworkers, and that is why I bring my plea here, to this forum, where some of the most influentially conscientious citizenry of the free world reside. Together, we CAN make a difference!
  13. That's about it, although a lot of what I do involves shipping out pieces of my master spreadsheet to various access departments so they can run a script to do their thing. A field or two with an errant space in it throws their program off, and then they gotta clean it up. So I like to make sure it right going in. I don't want to be "that guy", the one who always sends in the jacked-up data. I think more people should try to not be "that guy", no matter what the context. "That guy" is not somebody good to be! In corporate jargon, I've become known as a "gatekeeper", but in all honesty, I prefer to think of myself as a greeter, The Greeter to the Clean Data Club.
  14. Text-to-columns should never have to be used as a mere clean-up tool. Same with the Upper, Lower, and Proper functions. The Left & Right functions should return proper values first time out. Find an replace should be an editing tool, not a way to get dots where slashes should be and vice-versa. Concatenate is a gift from god, but only if what you're concatenating is consistent and clean. Then again, all that stuff is in there for a reason, they know how people gonna do!. I just think that people should be more conscious, to know that when they're asked to provide data, it doesn't mean to promiscuously run your mouse over whatever you have, then gleefully paste it all into a spreadsheet, and then think you're done with it, pass it on, game over, that was only took five seconds, EASY! Take 15 or 20 peopl doing that with data that's supposed to end up as one, consistent document, and you might as well get ready to clean up a New Orleans whorehouse on New Year's morning... It's kinda like sending session tapes to the pressing plant and expecting them to edit and master them there. No, do that first. Then again, when you're one of a handful (it seems) out of a thousand or so who knows how to do this stuff, hey - job security. Because most folks are lazy and/or scared and don't want to be bothered to learn that yes, concatenate is a real word!
  15. Reformatting a whole spreadsheet, yeah. Easy. But the data needs to be consistent throughout each cell. No extraneous spaces before and/or after values, names all in the same format, consistent usages of commas,dots,slashes in dates and phone #s, names either first, last or first last all the way thorough, please don't put some full names in one cell, others divided up between cells, please take the hyperlinks out of the email addresses, stuff like that. It's all fixable, but it's also preventable on the front. The work on the back end to fix it grows exponentially as various inputs need to be combined into one output. Get it right the first time, please. Please?
  16. JSngry

    Duke Pearson

    The front LP cover says 1969 in Roman numerals.
  17. My guess would be that the additional symbols require tri-functionality of some keys. Pretty cool, actually. I really don't dig how there's no ¢ key on my keyboard. My pleasure!
  18. Does this help? http://www3.uakron.edu/modlang/french/keyboard.html Also:
  19. What is that, that you have the license kill somebody, resurrect them, and then kill them again? Hell, if I could get that #, I'd order the Four Freshmen set!
  20. Believe it now, know it whenever it's time.
  21. http://forums.military.com/eve/forums/a/frm/f/380190923
  22. My first thought re: archiving the material: http://en.wikipedia.org/wiki/Acid-free_paper
  23. Well, if you can't hear it at all, there's a defect somewhere!
  24. Linkin Park Salty Parker Lot
×
×
  • Create New...