Archive for September, 2007

27
Sep

Excel 07 Bug

Author: admin

There is apparently a bug in the new version of Excel that returns the wrong number when you multiply certain numbers. An ex-MS programmer addresses the issue…

The first thing you have to understand is that Excel keeps numbers, internally, in a binary format, but displays them as strings. For example, when you type 77.1, Excel stores this internally using 64 bits:

0100 0000 0101 0011 0100 0110 0110 0110
0110 0110 0110 0110 0110 0110 0110 0110

The display is showing you four characters: “7″, “7″, “.”, and “1″.

Somewhere inside Excel is a function that converts binary numbers to strings for displaying. This is the code that has the bug that causes a few numbers which are extremely close to 65,535 to be formatted incorrectly as 100,000.

For more: Excel Bug

26
Sep

Build a compas

Author: admin

Its not really tech support, but you never know when it might come in handy…

13
Sep

Hi I’m…

Author: admin

as seen on Craigs List

Hi! I’m your Technical Support Rep. I have a considerable amount of control over one or more important aspects of your daily life: television, telephone, and internet. Sometimes one, sometimes all three. Before we interact, I’d like to share some thoughts with you:

* I am here, simply put, to fix your shit. My job is not complete until said shit is fixed. Please just help me fix this shit.

* With that out of the way, know that I hate you exactly as much as you hate me. No more, no less. If you are at least relatively pleasant, I’m happy to help you- even to make small talk as I attend to the issue at hand. Conversely, if you are a total and complete jackass, I will make this the worst 10 minutes of your week.

* Neither I, nor any of my coworkers, are out to fuck you. We are not idiots. We are college graduates in technical disciplines, the vast majority of whom are here to work their way up the IT ladder to more fulfilling positions. Sometimes we have off days, sure, but we know EXACTLY what we are doing. Note that this does not apply to anyone outside of our department. They are, in all reality, idiots who are out to fuck you.

* So you’ve already unplugged the “internet box” and plugged it back in? Brace yourself, you’re going to do it again. Most of the time I do this for a reason…unless you’re a dick. Then I do it to see how mad it makes you.

* Don’t lie to me- I can tell you have a router. It isn’t illegal.

* To those who think they are “computer illiterate”: The vast majority of the time, you are lovely customers: Patient, willing to learn, and most importantly, willing to listen. Thank you!

* To those who think they are CompSci PHD’s: The vast majority of the time, you are retarded: If you already cycled your equipment and it didn’t work, why did it work when I made you do it again? If you are so well educated, stay the hell out of the queue so that people who need help can get it.

* Supervisors don’t have a magic wand that they can wave to make everything better. They are governed by the same protocol and use the same utilities as I do. In fact, supervisors are more likely to tell you to fuck off- believe it or not, they have other pressing issues to attend to. If a node goes down, they WILL put those 200 subscribers before you in Priorityland.

* Threatening to cancel does not intimidate us. We have an entire department that is paid to care about that, which means that I don’t have to. Harsh? Sure, but I have more than enough work to do fixing shit, yelling at field techs, following up on cases, and explaining the concept of email to your grandmother that it won’t cause me to lose any sleep.

* It worked fine yesterday? Oh, then I must be wrong. Let me reconsider the 40 minutes I spent troubleshooting your Win98 box. Check it out: Shit breaks (see point 1); If shit did not break, I would be mowing your lawn instead of sitting in this office.

* Speakerphone? Turn it the fuck off.

* Don’t call back and have another rep troubleshoot the same problem. He will read the notes I left about how you spilled coke into your cable box. Even if he didn’t, he would come to the same conclusion, and more people with undiagnosed problems would be stuck listening to that god-awful hold music.

* I am not blowing smoke when I say that I understand how frustrating it is to wait on hold, get transferred, and deal with bad agents. I too have called Dell’s tech support line. The difference is that I actually DO care about your problem, so please just calm down before I kill your family.

* My company has over 20 million subscribers. I handle a region of about 2 million. To this day, none of them have ever called in to say “I just wanted you to know that my shit is working correctly.” Maybe someday?

So what can I help you with today?

12
Sep

Bring ls to Windows!

Author: admin

How many times have you been working in windows and go to use your *nix commands on the command prompt? I know I have and it always annoys me when it doesn’t work. I’ve looked at installing cgywin to get the commands but its a pain in the ass to make it work. Now I don’t have to worry. Thanks to utools.com, I can have LS on windows with a simple tool. GNU ls for Microsoft Windows is a wonderful tool that will make many a tech happy.

Download it. Try it out. Love it.

11
Sep

Improve your Net speed

Author: admin

I attended a Microsoft technet event today and while I did glean some good information about a program of their’s (have you ever heard of System Center Operations Manager?), I gleaned some information that was even more valuable.

In vista (and apparently in server 2008) the tcp stack has drastically changed. The catch is that the changes, when implemented will improve your network connection between vista and 2008 (and even a little between server 2003). The problem is that its not enabled by default. But I now know what to do…

Open a Command Shell:

C:\ Netsh
netsh> interface tcp
netsh interface tcp> set global congestionprovider=ctcp
netsh interface tcp> set global ecncapability=enabled
netsh interface tcp> show global

Type the stuff in bold

If you did it right, when you run show global, you’ll see:

Microsoft Windows [Version 6.0.6000]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.

C:\Users\mcangeli>netsh
netsh>interface tcp
netsh interface tcp>show global
Querying active state…

TCP Global Parameters
———————————————-
Receive-Side Scaling State : enabled
Chimney Offload State : enabled
Receive Window Auto-Tuning Level : normal
Add-On Congestion Control Provider : ctcp
ECN Capability : enabled
RFC 1323 Timestamps : disabled

netsh interface tcp>

How much this gains you, I have yet to learn… just thought I’d share…