Search results

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

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

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.

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

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

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.

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

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

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

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

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

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.

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

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

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

Hi acesea, My company ended up going with a company called M5 (www.m5net.com). We were moving from an aging, hand-me-down PBX system that couldn't do much of what we wanted. M5 is a little pricier because they require a private point-to-point T1 connection, but it means your calls don't...

So I wake up to a call this morning that our internet is down. It sounds like there is/was something f'ed up on XO's end. The major issues we were having this morning seem to have abated, but we will see if the errant DNS pops up again over the next few days. Thanks, guys!

Hmm. one of my coworkers just found this http://windows.microsoft.com/en-US/windows7/Using-ICS-Internet-Connection-Sharing I wonder if someone's computer is set up to try and use ICS. I guess i will go through the newly added comps first to see if it is enabled once people leave for the...

All computers are set to receive IP and DNS from the router, nothing is set on the specific computer. Everything else stayed the same. We actually use a bare IP address to access one of our servers offsite and this was still functioning, which makes me think that only the DNS address...

Hey guys, Throughout the day today a few of my users have had their internet drop out from under them. This is easily (but temporarily) fixed with a quick ipconfig /renew, but I am trying to see what we can do to stop this from occurring. For some reason the NIC switches to some random...

Hey guys, My company has a My Book World Edition II 1.5T in RAID 1 on our network. This morning one of our employees backed his whole computer up to the drive, and it has been unresponsive since. He said he transferred 1.5GB. The upload seems to have gone fine, however no one was able...

Hi guys, sorry for the delay but i just wanted to say thank you for the discussion and comments. we ended up with a cisco 3560 48-port switch and found a solid local dude to program it up for us. i will be looking over his shoulder more as we repro it for the dual internet connection...

Sorry for the delay, guys, and thanks for all your comments and help. We ended up splurging and going for the 3560 48-port PoE. With time becoming a factor deal hunting went out the window. I'm happy to report though that our install was silky smooth and our only challenge now is...

Hey guys, so i just got a bid on a switch and i wanted to run it by you. after all the talk about low-cost etcetc I think we are looking at this one very seriously. From talking to our voip provider as well, it sounds like we need to go with a Cisco switch (although i really appreciate the...

hey guys, this is a companion post to my other active thread, which has evolved into more of a discussion about how to configure our office to work with a new voip system. I am in the process of evaluating Cisco switches for my small business to work with a new set of Cisco 7961G phones...

Yea i realize they are 10+ years old. Cost is a big roadblock for us, but, if we can justify dropping more cash we could move up. I'll look at the 2960 series to see what's available. any other series that are still supported but may be more affordable? we would also be fine with a single...

Here are a few other minor config questions: Do I need to specify port speed and duplex parameters? A few vendors have said that having speed set to auto is a potential issue. I assume full duplex is fine for both voice/data and data ports. Is there anything specific I need to do for the...

I'll check with the new voip provider to see what the Call Manager situation is. I wonder if their hosted software replaces it? From what I understand, all voicemail, call routing, AutoAttendant, FindMe/FollowMe takes place on their servers. so i can use the syntax you gave, but I still need...

Haha. Fair, dan. Brand/Brand matching seems to be gospel. At least as far as cost, these switches are dirt cheap, especially compared to the ones that are actually currently supported by Cisco.

Are these levels pretty standard for an office environment? are they consistent with our 10/100 setup?

thanks a bunch, shawdowspawn. We will have a hosted PBX through a different company (read: not Cisco). The service will have an AutoAttendant on their server (as well as all the other fancy hosted services), but no UC on our end as far as i know. once i set the ip in the initial...

yea, as tempting as I find it to try to crank on the configuration, I'm sure my boss will rain on my latent sysadmin dreams. But ongoing management may end up in my domain, so I will definitely be scouring the forums.

Yea. I'm starting to work through the 3500X series documentation to get a feel for how the setup and management on the switch works. Any recs as far as configuration go? get a specialist? give it a go on my own?

From my conversations with a few vendors, it sounds like the switch automatically prioritizes Cisco packets (my voice packets in this case) over other traffic. Plus, as i mentioned above, all voice traffic will be going over its own T1 and will be on its own VLAN, completely separated from...

Yes. Cisco VoIP phones on one VLAN and all data traffic over the other VLAN. The only caveat there is that I plan on using the 10/100 switch built into the 7961G phones to tie in the computer at the workstations with phones. This ties into the question from dashpuppy below... Yes. This data...

Routers are being supplied by both ISPs. Each router will handle DHCP on a separate VLAN.

Hey guys, My company is switching to VoIP phone service and I have been tasked with upgrading our infrastructure to cope. We are finally graduating from a nest of 7 WRT54G Netgear routers with DHCP disabled, and are planning on purchasing a Cisco switch to complement our "new" Cisco 7961G...

what kind of motherboard do you have? Is your fan plugged in to the mobo or does it go straight into the power supply? Fans plugged into the PSU will crank at 100%, but if you can find a fan header on the mobo most boards should be able to regulate based on load.

yea, Windows 7 64-bit Home Premium is $75 bucks cheaper. I just got it for my new build, and it seems to be the one that is recommended the most on Gen[H]ardware. Here's an outside perspective on "Ultimate".

Thanks. I guess this means I get to update my sig.