Tracing Excel formula errors is tedious, if not guided by the built-in formula auditing tools. The formula bar itself is a good starting place to debug formula errors but when the formula gets longer and more complicated, a visual guide to trace the dependents is a great help.

You can use the Trace Precedents button on the Formula Auditing toolbar to trace all the generations of cells that contribute to the formula in the selected cell (something like tracing all the ancestors in your family tree). Many times, finding the original source of the formula leads you right to the source of all the error values in your spreadsheet.

To activate the tool, click Formulas on the ribbon and then Trace Precedents under the Formula Auditing panel:

In the Fibonacci sequence below, you would see the blue arrows showing the precedents of the result of the formula:

Another example is shown below where the B1 cell is a result of summing A1 and A2:

Now to see the dependents of a value, click a cell that you want to audit then click the Trace Dependents value. If the cell is used by other cells in formula, the arrows will point the to cells that depend on the cell.

To clear the arrows, click the Remove Arrows button and you should see the arrows disappear.

Use the Formula Auditing tools to trace dependents and precedents of your Excel formulas. They are very handy when the cell formulas get very complicated. As of Office 2007, the arrows don’t get automatically refreshed when you change the formula (they get cleared out) so you will need to click the trace buttons again to generate the arrows.

Posted By George October 2, 2009 0 comments

Supernatural Brasil XP Theme

Posted By George 1 comments

I make it a practice to purposely seek out refurbished tech items because I save a ton of money doing so, and the majority of the time the whatever-it-is I buy works just as well as a new item.

There are some people who believe refurbished and used mean the same thing. This is incorrect; there are several differences.

Difference 1: Warranty

All refurbished items come with a warranty. Some used items come with one but most don’t.

Difference 2: Physical condition

Refurbished items are supposed to look exactly like a new item and do most of the time. This usually involves the replacement of things, such as the chassis, faceplates, buttons/knobs, and so on. A used item has had nothing changed on it. It is the same as when it was new, worn and all.

Difference 3: Vendor

It is rare that an OEM will sell anything used. The closest match to this is "off-lease," meaning a corporate customer leased a ton of the whatever-it-is from the OEM, sent them back when the lease expired and then the OEM resells the items. But even this is a rare instance these days because if the items are too old (and therefore cannot be supported directly,) the OEM won’t bother reselling them and instead find other means of liquidating that inventory.

Third-party vendors will sell used items, do so routinely and at times label these items as refurbished when in fact they’re not.

The general rule of thumb is that if you purchase a refurb item direct from an OEM or a large third-party vendor (like NewEgg or TigerDirect,) it is truly refurbished. With smaller vendors you get used. This is especially true if a vendor is selling something labeled as refurbished but there is no warranty and/or is stated to be sold as-is.

Difference 4: Age of item

As noted in #3 above, if there is something in the inventory that is simply too old for an OEM to support, they will find a way to liquidate the inventory otherwise.

If a particular item is still available from the OEM as new, you will find legitimate refurbished versions of it, warranty and all.

If on the other hand the item is discontinued and isn’t available as new any longer, what you will usually find are used versions of that item with no warranty.

The easiest way to check if something is discontinued or not is to go to the OEM’s web site. If you see the item still sold as new, it’s obviously not discontinued. But if it’s not there, it is. Some OEMs are nice enough to tell you this information up front and give you a complete list of what’s discontinued (like Garmin for example.) Others however don’t do this, so you’ll have to go look item-by-item and see for yourself.

Special note on this: There is a period of time right after an item is discontinued where it "rides the fence" for a few months and can still be supported by the OEM, but after that it goes into used-only territory. This all depends on how the OEM handles discontinued product support for newly discontinued items.

Difference 5: Support

This directly relates to #3 and #4 above. Current-model items from the OEM are supported and therefore are available as refurbs. These refurb items have support, so if there’s any issue with it you can call the OEM for help.

Used items have third-party-only support or no support at all. Once you buy it, you’re on your own.

Are refurb items better now compared to before?

Yes. When refurbished items first appeared years ago they were admittedly pretty crappy. This soured a lot of people on the idea of buying anything other than new.

Today the OEMs understand that there is legitimate profit to be made by selling refurbished items. As such, refurb now is a whole lot better compared to yesteryear. These items are good enough to where you get the exact same warranty as you would new. This shows confidence in the refurbished product by the OEM and proves that yes, it will work.

I do recommend people to go refurb instead of new. If the refurbished item has all the features you want, comes with everything the same new product would and is supported by the OEM (which it is,) you can buy with confidence.

Obviously you should exercise common sense when shopping refurbished, because some items are still better new than refurb or "recertified" (I wouldn’t buy a recertified hard drive,) but most of the time the refurb items you buy will serve you just as well as new would.

Posted By George 1 comments

We have shown you a couple of cool free photo editing tools like Irfanview and Google Picasa. Let me show you another freeware that could become part of your essential photo editing toolbox. The freeware is called PhotoScape from www.photoscape.org.

Like Irfanview and Picasa, this software packs a lot of functionality: picture viewer, editor, animated gif creator, color picker, raw format converter, picture frame maker and others. The first thing a user will see on the GUI is an arranged shortcut to these functions.

The tool covers the basics of a photo editing app like the capability to zoom in/out, rotate, crop, level, contrast, midtone adjustments and others. It has auto level and auto contrast capabilities – something similar to Microsoft Office’s auto-enhance image feature.

You can also add decorative frames built-in from the tool:

The tool also makes collage frames easy to create. You can choose from a lot of frame designs and then just drag and drop pictures to each section of the frame.

Arranging pictures for printing to a single photo paper is also easy.

This tool offers a lot of goodies. For users who want to combine pictures into frames – this might be the best freeware for them.

Posted By George October 1, 2009 3 comments

Another set contains some Flowers doodle brushes for Photoshop.

Download

Posted By George 0 comments

This set contains some Flowers doodle brushes for Photoshop.

Download

Posted By George 0 comments

This set contains Fashion Girls Silhouettes brushes for Photoshop with high-resolution. There are a total of 15 brushes, made in Photoshop CS3.

Download

Posted By George 0 comments

Luna ported to Windows 7 Aero and Basic.

The original Luna is © Microsoft.
I claim no ownership over the original theme and I am not affiliated with Microsoft.
Also, it would be kind of nice for Win7 to have it’s own category.

*note* satukoro is branded into the preview for watermark purposes, it’s not in the actual image. Also, the startbutton will come soon if I can get it to look right.

Download

Posted By George 1 comments

Many unfortunately remember the infamous "Vista Capable" logo disaster. A whole bunch of new computers at the time Windows Vista was launched had a little logo that was supposed to indicate yes, they were capable of running Vista. But as we all found out, many of those new computers were barely "capable." Instead computer owners were treated to a less-than-pleasant computing experience – putting it very nicely.

One of the best things Microsoft ever did was release Windows 7 RC to the general public for testing. A ton of people, including myself, use this OS. I use it as my primary right now. This allowed everybody on both sides (corporate and consumer) to do the best live field testing of Windows since the product came into existence; this has served everybody very well.

Microsoft will be using a logo program again for Windows 7, so you will see those little stickers on new computers if you haven’t already. This time around the requirements to get the sticker are far more stringent compared to the Vista logo debacle.

The logo means the product must work with both 32 and 64-bit editions. This is particularly important for peripheral devices, because it means the driver disc included will have 32 and 64-bit versions included. It also means more rigorous testing has been performed to ensure that yes, it will work.

Part of this program includes "Ready. Set. 7." You can check out right now what developers are building 7-compatible items at www.readyset7.com. The list is extensive, and that’s great because it means that many of the products on store shelves will be compatible right out of the box.

In the end however, what has mattered most concerning 7’s readiness has been end-user testing from Win 7 RC use. I use 7 RC, and this OS proved its worth beyond any doubt by running nearly flawlessly on my Dell Inspiron Mini 10v netbook, which houses only a single core 1.6GHz Intel Atom CPU, 1GB of RAM, shared video memory and a 160GB 5400rpm HDD.

As far as I’m concerned, if Win 7 can run on this smoothly (which it does,) it can run on just about any computer made in the last 5 years without the need to upgrade.

The logo program is good and is being far better managed, granted, but it’s been the users of this OS that have had the most influence on people. If I thought Win 7 sucked, I would say so without hesitation. If other people thought it sucked, they would say so as well. We’ve all been nothing but honest in our reviews of this OS. And it’s the general consensus that Win 7 doesn’t suck. Not in the slightest. In fact, we all really like it. That’s why we dare to run an RC as our primary operating system. Ordinarily that’s considered computer suicide, but the blunt honest truth is that 7 really is that good.

Posted By George 0 comments

You may have seen in tech news articles in the past that Microsoft was working on it’s own release of an anti-virus product to compliment Windows Defender. A couple of days ago their solution, Security Essentials, was released (from beta).

Microsoft Security Essentials provides real-time protection for your home PC that guards against viruses, spyware, and other malicious software.

Microsoft Security Essentials is a free* download from Microsoft that is simple to install, easy to use, and always kept up to date so you can be assured your PC is protected by the latest technology. It’s easy to tell if your PC is secure — when you’re green, you’re good. It’s that simple.

Microsoft Security Essentials runs quietly and efficiently in the background so that you are free to use your Windows-based PC the way you want—without interruptions or long computer wait times.

If you google Security Essentials, you will see it gets a mixed bag of reviews. Although the sites I tend to frequent have given it more positive evalutations.

Posted By George 0 comments

Is your download speed as fast as it should be? If you recall the days of the “speed demon” 56k dial-up modem, waiting on something as simple as a small digital picture file seemed to take eons. This is when you would get up from your computer and wander off to perform various other tasks to pass the time.

Now that more people have higher speed connections (Cable, DSL, Fiber), as of late, one would imagine that downloading a trial copy of Halo would be fast and steady. Well, not always. Instead of the person carefully watching their connectivity status while running their download, it is the group distributing the software, that is monitoring their bandwidth use.

Consider the possibility that greater bandwidth for the end user can mean greater amounts of requests for a target website. The chances that your download can be slowed down, or broken, increase. With larger websites, like Download.com, they take step to build infrastructure around maintaining the bandwidth necessary to support many thousands of active connections. However, for less frequented, or newer download or file sharing sites, the same environment may not be available.

To help you get the most out of your down stream speed on your Internet connection, tools like Download Accelerator Plus (found here) are available to boost your file grabbing speed and download connection quality. Download Accelerator Plus (also known as DAP) does more than simply make downloading files faster though. It also allows you to effectively pause a download and restart one, should a link set become broken.

Historically, this tool was an add-on for Internet Explorer, and now it has evolved into a suite of products. Included in Download Accelerator Plus is an FTP connection tool, a download dashboard, and a web browser. A simple tabbed interface allows the user to bounce between the three views.

The main draw behind this tool is the multiple download threads it utilizes when downloading a file. It does not simply get the download information from one site, and begin transferring the file. Download Accelerator Plus looks at other websites for the same file, and pulls from the as well. When you use DAP to get a file, it will display a multi-colored progress bar, showing several file connections.

When looking at Download tab, you can view the controls to Pause and Resume your downloads. You may select one or several streams for the purposes of stopping and starting the file transfers, or you may do all of them at once. One could see the practicality in this, because you could pause downloads that are taking longer then others, allowing DAP to focus on finishing certain transfers first.

When you pause an active download, a small icon pops up next to the selected transfer. This icon appears in the Status column and viewable while you are in the Download tab. The paused status remains until Resume is clicked.

For the purposes of downloading a file from a website, most people will navigate to the website, and locate the file on the site itself. This is tried and true method for finding file you wish to get at. That and the Google search engine covers most bases. However, if someone sends you a HTTP address link in an email, for instance, you can copy and paste the whole address into Download Accelerator Plus. All you have to do is click on the green Add icon in the Download tab, and a text box will appear for you to enter the website address of the download.

Please keep in mind that the version of Download Accelerator Plus reviewed here was the Free Version. There is a paid version of this software, and depending on what you click on within DAP, it will remind you frequently of this fact. The premium version does offer some nice privacy tools to help clean up Internet tracks with respect to downloaded files.

Is Download Accelerator Plus right for you? That is a determination that you will have to make for yourself. If you have a 265k DSL type connection, adding a tool like DAP will boost your file download time; whereas if you have a fiber connection of 20mb and upwards, DAP may not have the impact you want. Even if the speed is unattractive, the ability to effectively manage file downloads is reason enough to get this tool.

Posted By George September 30, 2009 0 comments

This set contains some Sexy Lady Silhouettes brushes for Photoshop.

Download

Posted By George 0 comments

This set contains 30 Sunbrush Custom Shapes for Photoshop.

Download

Posted By George 0 comments

This is my Zuney Blue Theme. Its basically the blue version of the Zune Final theme but the black parts are lighter, and I didn’t know about it at the time. I scratched my name out, so thats what the red is. No, I’m not crazy or paranoid. I just dont want people to see my account name, because it might offend some people.

Download

Posted By George 0 comments

This may offer a bit of comfort to some with slower broadband connections. For US internet users, your tax dollars have now proven that the speed of broadband is 50% slower than what it’s claimed to be.

For those that would say, "Did we need to spend a bunch of tax money to figure something out everybody already knew?" In fact, yes. The problem needed to be identified in absolute fashion so plans can be made to actually do something about it. Saying something is slow and proving it as such are two different things. And now it’s proven.

A few other things have been proven as well.

First, what ISPs claim to be "fast" really doesn’t sound believable anymore due to the fact more and more US customers are saying, "I paid for ‘fast’ internet and I’m not getting it." When you download web pages, files and so on at the same speed you did with your "slow" broadband, you feel cheated. And you are being cheated. Fast should be legitimately fast, and it isn’t.

Second, internet today is no longer a luxury. For many it’s increasingly becoming a necessity. While it’s true you can go through daily life without it, it is becoming more difficult to do so and in the long run can cost you.

A simple example of this is paying bills online instead of mailing them out. The current cost of a US stamp is 44¢, and this doesn’t include the cost of envelopes. If you mail out 10 letters a month, that costs you $4.40 each time. Sending out bill payments online is completely free, and for payments that you cannot pay electronically, the bank will cover the cost of the postage and mail it for you.

This is just a single example as there are obviously many more.

The US is grossly behind the times when it comes to our broadband speed. The last time I wrote about this, the US ranked 15th in the world, with an extremely poor last-mile average download rate of 2.3mbps.

Thank the FCC for at least identifying our slow broadband as a legitimate problem. Plans to improve the network in the US will start soon in 2010. This is very late to the party concerning other countries are beating the pants off us right now in the broadband dept., but at least the problem has been identified and steps will be taken to resolve it, hopefully in short order.

Posted By George 0 comments

Get updates via email