blog.auctionflex.com

What’s In a Name Anyways?
Well, it doesn’t get any awards for having a catchy name, however Microsoft’s new anti-virus offering titled ‘Microsoft Security Essentials’  is a good product with a great price tag; free. I guess Microsoft Anti-Virus was too self-explanatory a name for the marketing gurus in Redmond. To be fair, however, MSE (my un-official abbreviation for Microsoft Security Essentials) is more than just anti-virus. It protects against spyware and other nasties too.

Liberation with a Capital L
MSE runs quietly, in the background, without pestering prompts, balloons, or any other annoyances. For that alone it deserves kudos. The reality is that you could open notepad and make the same claim. This leads to the most important question: Does MSE do a good job protecting your computer from viruses/spyware/etc.? The answer, so far, seems to be yes. The reviews I’ve read make the case that MSE is as good as other offerings from AVG, McAfee, Symantec, etc. The difference is that MSE is blissfully quiet! And did I mention free?

Bundles of Grief
My biggest complaint against most of the other anti-virus offerings (ahem… McAfee, Symantec) is that they want to bundle their anti-virus with “complete” internet security suites. Yuck! These bundles eat system resources,  slow your computer to a crawl, and cause instability issues. When you install anti-virus it should NOT come with a firewall, intrusion prevention, active web-filtering, pre-emptive cognitive destination avoidance, and a hands-free parallel parking system.  Just say NO to these bloat-ware suites!

My New Number One
I have been recommending AVG for years now but I am officially changing my recommendation to MSE. You heard it here first! I wouldn’t go out of my way to switch from AVG to MSE, but I would definitely uninstall McAfee or Symantec for MSE. Just my two cents.

Download Microsoft Security Essentials

Confessions of an OCD Backup-Maker
I have a confession to make; I habitually make backups…. and then I backup the backup… and then I have a program that automatically backs up my backup to an off-site backup. I’m a little bit OCD like that. But let’s not judge me. Let’s turn this around. When was the last time you made a backup? Was it a good backup or a bad backup (what’s the difference… keep reading)? I’m going to give you some suggestions on making good backups and provide some online tools to make even better backups. You ready? Here we go.

External Hard Drives Are Your Friend
An external hard drive is a type of hard disk drive which is typically connected to your computer via a USB cable. These devices are great for storing backups because they are cheap and large. You can easily find a 500GB external hard drive for $100. At the end of every day you can simply backup all your files to the external hard drive. Because the typical external hard drive is so large you can even keep multiple backups of the same files. For instance, when I backup files I will create a folder and name it based on the date. So, for today I would create a folder called 20091009 (military format for 2009 Oct 9th – it sorts better this way) and then I would backup my important files to that folder. A week from now I would create a folder called 20091016 and I would backup to that folder. I like to make dated backup because if I ever need to go back in time to a revision of a file from weeks (or months) ago, I can. Now, if your computer’s hard drive dies, you have backups of all your important files at the ready. Fix your old computer or buy a new computer, restore those important files and you’re off to the races.

Thumb Drives Are Your Super-Portable Friend
Thumb drives are small (pocket-size) USB devices that, when plugged into your computer, show up as a small hard drive. Thumb drives typically have a much smaller capacity than external hard drives but they have the advantage of being much more portable. Just like an external hard drive, you can copy files from your hard drive onto the USB thumb drive. Again, if your computer dies, you have backups.

Location, Location, Location
So, you’re feeling pretty smug about those backed up files aren’t you? And, a lot of you are going to leave that external hard drive right next to the computer, or you’re going to take that thumb drive and store it in your laptop bag with your laptop. Congratulations; you are now hosed if someone breaks into your office and steals everything, or someone steals your laptop bag on a trip, or if there is a fire, or if your 4 year-old nephew decides your laptop (with the thumbdrive sticking out of the USB port) is a fish and sets it free in the pond out back. In any event you get the idea that storing your backup with your computer is a bad idea. So, when you go to the store to buy that backup device, buy 2 (or more) of them. You need at least 2 because you always, always, want to keep one of them off-site, away from the computer that you are backing up. Now, if someone steals your laptop bag, or the entire contents of your office, or you have a fire, or a flood, or whatever; you’ve got an offsite backup. 

But I Am Lazy, and/or Forgetful
I don’t know about you, but I don’t trust myself to make backups manually. If you are like me, and just want the backups to create themselves then you are in luck; there is a solution. Online Backups. There are quite a few online backup providers out there. The big players are Mozy and Carbonite. They will provide a small program that you install that will automatically backup your important files to a secure offsite location via the internet. Their programs allow you to simply choose what files/folders to backup, when to back them up, and you are done.  Mozy even offers a free personal account that includes 2 gigabytes of disk space! The caveat here is that your computer needs an internet connection and needs to be turned on to make the backups… but the backups are automatic and that is worth the price of admission (which can be free). Now, if something bad happens, you have an online backup that you can access from anywhere.

How Do I Choose?
Here’s the thing about backups. There is no such thing as too many of them. Make backups to an external hard drive, and backup to thumb drives, and use an online backup service.

Safety, Security, & Serendipity
There are many dangers inherent with computing on the internet. Viruses, worms, and spyware are the most omnipresent. It is a choice to engage in safe practices that protect you from these threats. Rather than approach this topic generically, I thought I would let you know specifically what setup and programs I use, and let you glean from it what you will.

The Hated One
Despite the fact that Windows Vista is a much-maligned operating system, the fact remains that it is more difficult to hack than Windows XP. In Vista there is a separation of regular processes and administrative-level processes that is lacking in Windows XP. I use Windows Vista and I won’t hesitate to use Windows 7 when it becomes available.

Anti-Virus
My favorite anti-virus program is AVG (there is a free version available for personal use). I have used many anti-virus programs in the past, but AVG has found the sweet-spot between performance and protection. Other anti-virus programs (ahem… McAfee & Norton) have reputations for being resource hogs. Beyond that, McAfee & Norton want to install a whole suite of add-on programs and I just don’t want them. AVG provides a simple, anti-virus-only software solution without all the rest of the garbage.

SpyWare
My choice here is Ad-Aware and they also have a free version for personal use. That isn’t to say Ad-Aware is any better than the dozens of other products out there. It’s just the one I use.

Safe Browsing
I use FireFox with NoScript for everyday browsing and I use Internet Explorer when I’m going to known sites (webmail, fedex.com, etc.).  What is NoScript? NoScript is an add-on to FireFox that disallows scripts from running automatically. Since a majority of vulnerabilities depend on scripting, the NoScript add-on makes your random internet browsing much, much safer. I would like to warn you, however, that it can make browsing some sites difficult. In those instances, you can always pop open IE to view that particular page/site and then go back to FireFox/NoScript when you are done.

Windows Updates
It goes without saying that you need to keep your version of Windows up-to-date by running Windows Updates. The sooner you install patches, the better off you are. The moment Microsoft releases a patch, hackers are reverse-engineering the patch with the goal of exploiting the vulnerability. In some instances, these exploits arrive within days of the patch being released. That is your window of safety… days.

The Finish
So there you have it. A little peek into my setup and practices. These combined safety measures are a lot like hiking through bear-country with pepper-spray. You are safer, but if you think they make you invincible, you are going to get eaten. Just as you wouldn’t slap a grizzly bear in the face, don’t download anything from a website that you don’t know and trust, otherwise you’re just asking for trouble.

Drag-and-Drop Dirge
A typical process for creating an auction catalog with images consists of 2 steps.
Step 1: Describe all the lots.
                  Lot#1 – Brown chair with garnet velvet piping.
                  Lot#2 – Large white cow with horns. 
                  Lot#3 - Two front-and-center tickets to Springsteen.
                  And so on. And so on.
Step 2: Take pictures of all the lots with a digital camera. 
                  Select all images for lot#1 and drag-and-drop the images onto lot#1.
                  Select all images for lot#2 and drag-and-drop the images onto lot#2.
                  Select all images for lot#3 and drag-and-drop the images onto lot#3.
                  And so on. And so on.

You load 16 pictures and what do you get? Another day older and carpal tunnel wrist. Needless to say, the lot-by-lot drag-and-drop process is time consuming and ripe for optimization.

Image as you Go-Go
One alternative to the post-describing drag-and-drop dirge is to take pictures as you describe instead of after. You can accomplish this with a webcam or a linked video camera (for higher image resolution). Start by going to Auction Lots & Preview and then click on the Detailed Entry button. Now go to the Images tab and click the Add From Capture Device button. This will start an Active Video Monitor form which allows you to rapidly capture pictures as you catalog. So, type in your Lead and description for your item, then click on the Images tab and click that same button again to take a picture. You can monitor the video feed from the Active Video Monitor (which you can drag where you want) and rapidly add multiple pictures to each lot. If your computer’s monitor is higher resolution (1280×1024 or larger) try clicking the Linked button at the bottom left. This will open up a second linked form that allows you to view the Images tab at the same time as you view the Information tab in the first form. Heck, if you need to dynamically add expenses to each lot as you catalog, click that Linked button again. Now you can view the Information, Images, & Expenses without switching back and forth between tabs. This makes for very fast, very detailed cataloging in real time with no tab-toggling. We call this Productivity with a Capital P!

Barcode Wizardry
Let’s assume that you are dealing with a pasture full of larger items that don’t work well trying to capture the image as you describe, so you want yet a different alternative to the drag-and-drop dirge. To start, we need barcoded labels. Lucky for us, Auction Flex has the built in capability to print lot labels with barcodes. So as you describe the lots you stick a lot label on each item. When you’re done describing, every lot is tagged with a matching barcoded label. Here’s where the wizardry starts: Auction Flex can actually read those barcode labels from a picture! So, here’s the process: Start each lot by taking a relatively close-up picture of the lot label. Then, take as many pictures of the lot as you want. Now, with the next lot, again start with a picture of the barcoded lot label, then take pictures of the lot. Repeat. Repeat. Repeat. Now, open Auction Lots & Preview and go to the Advanced tab. Click the Import Images button, select the appropriate options and Auction Flex will read the barcodes from your images and automatically assign the images to the appropriate lots. Every camera is different and it takes a little practice, but you can achieve 80%+ accuracy using this process. For more information on this check the Auction Flex help file.

Non-Barcode Non-Wizardry
You can use the same Image Import form described above to rapidly manually assign lot numbers to images. Instead of drag-and-dropping the images to each lot, you can simply scroll down a thumbnailed grid of your images and enter their appropriate lot#’s in bulk. Then, when you get to the bottom of your list you simply click the import images button to import all the images to the assigned lot#’s. While this method is not as fancy as reading barcodes from images, it is still faster than the lot-by-lot drag-and-drop method.

Voilà not Wallah
My goal is to give you the best tools I can to help you conduct business as efficiently as possible. Only you can decide which method works best in conjunction with your in-house processes but hopefully I’ve given you a few ideas that have started your gears turning.

These instructions are applicable to Auction Flex version 6.10. If you don’t have some of the buttons or options I’ve mentioned, you’re probably on an older version of Auction Flex and need to upgrade.

Three-digit bidder numbers
I’m going to make the case that larger auctions should start their bidder numbers at 100. More specifically, there should be no two-digit bidder numbers. If you need four-digit bidder numbers (1000+) for your floor bidders congratulations, you’re having one big auction!

Clerking
With everything that it takes to facilitate a successful auction I want to focus on a very specific function; clerking. From an auction software perspective, the most important person on auction day is the clerk. Why the clerk? No other position (again, limited to auction software) has as much impact on a bidder’s experience. The clerk must be fast. The clerk must be accurate. In fact, a clerk with O.C.D. is probably worth their weight in gold!

Clerking accuracy
The more accurate the clerk is, the less problems you will have at checkout. Every time a bidder disputes the price of a bid, or a wrong item is on their invoice, or an item is missing from their invoice what effect does that have? It sloooooows things down. It causes everyone else in line to wait that much longer as the staff rifles through the manual clerking sheets or listens to the taped recording of the auction.

Fast checkout
If a bidder knows that they are going to have to wait in line to checkout what do they do? They checkout early to avoid the rush. If the bidder is checking out early what are they not doing? They are NOT bidding! If a bidder knows that checkout will be fast, even at the end of the auction, then that bidder is more likely to stay on the floor and keep bidding. If the bidder is bidding the consignor is realizing maximum dollar and so is the auctioneer. Win-win.

What does all this have to do with bidder numbers?
We’re all human and we all make mistakes. We transpose numbers, we miss numbers, we mess up. One thing we can do to help our clerks is to always hand out three-digit bidder numbers. That means we start with bidder number 100 and go from there. This helps because the clerk knows that every bidder number should be three digits. If the clerk mis-hears bidder number 23 they automatically know there is no bidder number 23 and they can ask the auctioneer to repeat the number.

But I already have permanent bidder numbers with two digits!
If you already have permanent bidder numbers with two digits there is still something that can be done to help the clerk. Have the auctioneer say the zero in front of the two-digit number. So instead of bidder twenty-three, say bidder zero-two-three or oh-twenty-three. 

Exceptions to the rule
If you rarely exceed 100 bidders at your auctions then I recommend starting at bidder 10. Why ten instead of one? Because your clerk knows there should be two digits. Clerk hears bidder 7, knows there is no bidder 7 and asks auctioneer to repeat… but you already knew that didn’t you? In this case it makes no sense to add the burden of typing three-digit bidder numbers if you don’t need to.

Change is good
This simple change might only eliminate a few clerking errors each auction but every little bit counts. The point of auction software on auction day is to provide a pleasant experience for the bidders. Fast + Accurate = Happy Bidder and happy bidders come back to your auction. All else being equal, if you and another auctioneer are having an auction on the same day, which auction will the bidder attend? Yours with the fast checkout line or your competitor’s auction where they have to wait 40 minutes to checkout? Your fast and accurate clerk can actually bring more bidders to your auction which gives you a competitive advantage.

Office 2007

When I first installed Microsoft Office 2007  I hated the new ribbons that replaced the old toolbars and drop-down menus. I especially despised the new ribbons in my favorite Office application, Excel. Determined to not be averse to change - to instead embrace change with the knowledge that change is good - I plodded ahead with the ribbons. I endured the lost productivity of constantly searching out where my commonly used functions were relocated. I justified the slow-going with the knowledge that once I conquered the learning curve I would be just as efficient as I used to be. Well, 18 months later I still can’t find anything without searching, and searching, and searching and I’ve finally given up. Office 2007 ribbons just plain stink! I’m a power-user, and if after 18 months my productivity is still hurting, then it’s not my fault. I gave it a fair chance.

I can live with the idea that some user interface team at Microsoft provided evidence through diligent research that the new ribbon interface helps a subset of users… heck, it might even help the majority of users. What I can’t forgive, however, is knowing that same group of UI experts was responsible for NOT including classic menus too. I HATE the ribbons. HATE. HATE. HATE. If you do a Google search on the phrase ”Office Ribbons Suck” you will get thousands of results indicating I’m not alone. The vitriol for the ribbon is widespread and we will be heard! Microsoft should have absolutely, positively included the ability to show classic menus… but they didn’t. Shame on you, Microsoft. 

The beauty of capitalism is that where there is a void, there is someone willing to fill the void. Several companies have come to the rescue with add-ons to Office that will re-create our classic and beloved menus and toolbars. Unfortunately they are not free… but I can assure you they are worth every penny of the $20 bucks or so that they cost. If you are ready to end your misery check these out:

Office – Toolbar Toggle

Excel Only – MrExcel