• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Recent content by stim

  1. S

    Budget Build for a Friend ($600)

    Thanks a ton for the reply, Danny. When I said "wiggle room", I was thinking that, if we went with a standalone video card, we could step down a level or two on the cpu. On the ram, since the board supports dual-channel memory, does it make sense to get a second stick? What are the...
  2. S

    Budget Build for a Friend ($600)

    Hey guys, I am starting to map out a new rig for my coworker. Here are the standard answers, but I have also asked some additional questions down at the bottom. Thanks! 1) What will you be doing with this PC? Gaming? Photoshop? Web browsing? etc general browsing, streaming video...
  3. S

    Excel 2010 - Cell Stuck Open on Inaccessible Workbook

    nevermind. It seems to be a different issue where I try to open a workbook with the same name while the cell is open. I'm just going to kill the process and start over.
  4. S

    Excel 2010 - Cell Stuck Open on Inaccessible Workbook

    So I have done this to myself a few times and haven't been able to back out of it cleanly. I always end up having to kill all my Excel processes and open things up again. My issue is: I F2 into a cell to modify the contents. I click on another window for some reason I switch back into excel...
  5. S

    How to Speed Up VBA for Text-Cleaning?

    I've been playing around with Python and Ruby and have run into regexes a few times. Definitely worth adding to the repertoire. Heh, the novelty of excel keyboard shortcuts has run out for me, so obviously I would prefer never to do manual reconciliation, but this type of request (trying to...
  6. S

    How to Speed Up VBA for Text-Cleaning?

    Thanks, PTNL. 1 - Done 2 - I actually wrapped it around r.Value when assigning it initially. That way it cleans the input before it tries to replace.
  7. S

    How to Speed Up VBA for Text-Cleaning?

    We end up doing a lot of Vlookup-type stuff on lists below 10,000 rows pretty often, which isnt an issue. These types of projects pop up when we have clients looking to match their internal database contacts to ours. We end up being the ones trying to map their names to our standardized...
  8. S

    How to Speed Up VBA for Text-Cleaning?

    Let me be the first to say, "holy crap that's zippy". (and thank you) Here is the comparison in runtime for 3 different implementations: Application.WorksheetFunction.Substitute (6.7s) Replace (6.6s) Replace + caching (.19s) So apparently the old and new implementations of the...
  9. S

    How to Speed Up VBA for Text-Cleaning?

    Thanks for the quick reply. I will give these a shot and see if i can squeeze in a little testing. I thought I had read that REPLACE was deprecated, but I actually got it backward. REPLACE was added in Excel 2000 and you had to do the "Application.WorksheetFunction.Substitute" to call that...
  10. S

    How to Speed Up VBA for Text-Cleaning?

    Hey Guys, I am working on cleaning and matching a spreadsheet with 22,000 rows with a column of formal business names (ex, My Company, LLC), and I am trying to clean them up so that all of the legal entity suffixes are removed. My big issue is that, while I can write a massive, nested...
  11. S

    Learning Python

    Glad to see the MIT OpenCourseWare item show up here, but I like this class over there better. http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-00-introduction-to-computer-science-and-programming-fall-2008/ This one has a video series that goes through all the...
  12. S

    new google search sucks, i want a classic version

    If you are logged in, there is an option in "Search Settings" (which is a link at the top right of the window) that allows you to turn off "Google Instant" It looks like that gets rid of the previewing and auto-populating searches.
  13. S

    website loads from some pcs and not others

    Yea, Windows 7 shipped with telnet turned off. Here's how to get telnet active again: 1) Go to the Control Panel and select "Programs". 2) Select the "Turn Windows features on or off" link in the left pane. 3) Check the box next to "Telnet Client" 4) Click OK to save your changes. Putty...
  14. S

    Language/Framework Rec for New Build (RoR too much, but Python?)

    Yea, doing DB checks and updates on each entry. Output for first-attempt program is just new a text string delivered back into the main page. (there's a little AJAX magic, eh?) Yea, definitely check it out. There are a bunch of random classes, but the intro to python course is under "Intro...
  15. S

    Language/Framework Rec for New Build (RoR too much, but Python?)

    Hey all, I'm in the initial stages of planning out a new website and I really want to make sure I get the inside scoop on my options when it comes to implementation. My background includes only rudimentary coding experience, but I do have a few years of SQL and basic HTML/CSS under my...
See more
Back
Top