jump to navigation

How to Compare Pentium 4 to Celeron Processors | eHow.com April 22, 2010

Posted by John Ruby in Solutions.
add a comment

How to Compare Pentium 4 to Celeron Processors | eHow.com
Base your decision on your needs. If you only use your computer for simple tasks like web browsing and word processing, you may not want or need to spend the extra money on a P4. If you place big demands on your computer, such as graphics-intense gaming, you may need to go with the better performance of the P4.Keep in mind that a simple clock speed statistic is not sufficient to compare two processors of different architecture

  1. Step 1

    Look at the number of cores in each processor. This is one area in which the two processors are the same–they both feature quad core technology. In a simplistic sense, they both function as 4 processors in one. As you will see, this is where the similarities end.

  2. Step 2

    Compare the cache memory. The Pentium 4 (P4) is a chip with a cache memory range up to 2 megabytes, while the Celeron usually comes with 28 or 256 kilobytes. The cache memory has a big impact on computer performance, and the Pentium 4 has around four times more than the Celeron.

  3. Step 3

    Look at the clock speeds of the P4 versus the Celeron. This is in effect a measure of how fast the processor is running. The P4 models top out at around 3.8 gigahertz. The Celeron’s top speed is about 2.8 gigahertz.

  4. Step 4

    Evaluate the difference in BUS speeds for the two processors. These speeds indicate how fast data moves on the motherboard of the computer, and the P4 generally runs about 30 percent faster than the Celeron.

HP Slate to cost $549, have 1.6GHz Atom Z530, 5 hour battery? — Engadget April 19, 2010

Posted by John Ruby in Computers, Slate, Tablet.
add a comment

HP Slate to cost $549, have 1.6GHz Atom Z530, 5 hour battery? — Engadget
HP Slate to cost $549, have 1.6GHz Atom Z530, 5 hour battery?

Well, well — what’s this? We just got our hands on what looks like an internal HP Slate presentation given to cool down some of the iPad hype amongst HP employees, and it just happens to have specs and pricing details on the elusive Windows 7 tablet. As we’d heard, the Slate will run $549 in its base configuration, which has a 8.9-inch 1024 x 600 capacitive multitouch display, a 1.6GHz Atom Z530 processor with UMA graphics and an accelerator for 1080p video playback (we’re assuming it’s a Broadcom Crystal HD chip), 32GB of flash storage and 1GB of non-upgradeable RAM. There’s also a $599 version with 64GB of storage, and both models will have a five-hour battery, an SDHC slot, two camera, a USB port, a SIM card slot for the optional 3G modem, and a dock connector for power, audio, and HDMI out. Of course, what this spec list doesn’t cover is software, and we still haven’t seen much of how HP plans to make Windows 7 on a full slate device with netbook-class internals perform as smoothly or as intuitively as its demo videos. That’s not a small challenge, especially since the iPad is out now and setting some pretty high expectations for how this new breed of tablets should work. We’ve got our fingers crossed — show us something good, HP.

Excel — Create an Order Form April 15, 2010

Posted by John Ruby in Solutions.
add a comment

Excel — Create an Order Form
Excel — Create an Order Form

In this order form, Data Validation is used to create a dropdown list of available products. In adjacent cells, VLookup formulas return the price of the selected products.

Set up the Workbook

Two worksheets are required in this workbook.

  1. Delete all sheets except Sheet1 and Sheet2
  2. Rename Sheet1 as Order Form
  3. Rename Sheet2 as Products

Create the Product List

  1. On the Products sheet, type the list of products and prices, as shown at right.
  2. Select the list of products in cells A2:A6
  3. Name the range ProductList (there are Naming instructions here: Name a Range)
  4. Select the list of products and prices in cells A2:B6
  5. Name the range ProductLookup. 


Create a Data Validation Dropdown List

The next step is to create the data validation dropdown lists, to make it easy to enter a product in the order form. There are detailed instructions here: Data Validation — Introduction 

  1. On the Order Form worksheet, select cells B5:B12
  2. Choose Data | Validation
  3. From the Allow dropdown, choose List
  4. In the Source box, type:   =ProductList
  5. Click the OK button  

Add the VLookup Formula

VLookup formulas in column C will return the price for each product selected in the order form. The VLookup formula is wrapped with an IF formula, to prevent errors if no product has been selected in a row. For more information on the VLookup formula, see Worksheet Functions — VLookup

  1. On the Order Form worksheet, select cells C5:C12
  2. Type the formula:
  3. Press Ctrl + Enter, to enter the formula in all the selected cells.





Calculate the Row Total

Quantity will be entered in column D, and the row total calculated in column E. The formula is wrapped with an IF formula, to prevent a zero calculation if no product has been selected in a row.

  1. On the Order Form worksheet, select cells E5:E12
  2. Type the formula:      =IF(C5="","",C5*D5)
  3. Press Ctrl + Enter, to enter the formula in all the selected cells.



Total the Order

The SUM function is used to total all the rows in the Order Form.

  1. On the Order Form worksheet, select cell E14
  2. Type the formula:      =SUM(E5:E12)
  3. Press Enter, to complete the formula.



Format the Order Form

Add cell borders and font formatting, to make the Order Form more attractive, and easy to use.

  1. On the Order Form worksheet, add column headings in row 4, as shown at right.
  2. Add the main heading, "Order Form", in cell B2
  3. In cell C14, type "Total"
  4. In cell E2, type the formula:       =TODAY()
  5. Select cells B4:E12, and add borders.
  6. Add fill colour to columns B and D, where data entry is required.
  7. Format the heading fonts as bold
  8. Format the date as desired.


Add a Customer List

To enhance the order form, you can add a worksheet with customer names and addresses. Then, select a customer name on the order form, and have their address fill in automatically.

Add the Customer List

  1. Insert a new worksheet, and name it Customers
  2. On the Customers sheet, in row 1, and the headings, Name, Street, City, Prov, PostalCode, DateEntered.
  3. In the following rows, enter data for a few sample customers.
  4. To name the customer list (for the dropdown list), select cell A2
  5. Choose Insert | Name | Define
  6. Type the name: CustList
  7. In the Refers to box, type:
  8. Click Add
  9. To name the Customer lookup table (for the address lookup), type the name: CustLookup
  10. In the Refers to box, type:
  11. Click OK


Create the Customer Dropdown and Lookup

  1. On the Order Form worksheet, select rows 3:7
  2. Choose Insert | Rows
  3. In cell B4, type: Ship to:
  4. In cell B5, add a Data Validation list, with CustList as the source
  5. Select cells B6:E6, and choose Format | Cells
  6. On the Alignment tab, add a check mark to the Merge Cells box, click OK
  7. Select cells B7:E7, and press the F4 key, to repeat the previous formatting
  8. In cell B6, type the formula:
  9. In cell B7, type the formula that will lookup city, province, and postal code:
    =IF(B5="","",VLOOKUP(B5,CustLookup,3,FALSE)&", " &VLOOKUP(B5,CustLookup,4,FALSE)&" " &VLOOKUP(B5,CustLookup,5,FALSE))
  10. To test the formulas, select a customer from the dropdown list in cell B5, and the address should appear in B6 and B7.

DELL 3050, Dual Core Xeon, 2.13GHz 2MB Cache, 1066MHz FSB, PE860 April 13, 2010

Posted by John Ruby in Components, Hardware.
add a comment

DELL 3050, Dual Core Xeon, 2.13GHz 2MB Cache, 1066MHz FSB, PE860 Customer Install : Desktop Accessor
3050, Dual Core Xeon, 2.13GHz 2MB Cache, 1066MHz FSB, PE860 Customer Install


  • Features 2.13 GHz processor frequency and 2 MB cache
  • Front side bus speed of 1066 MHz
  • Extended Memory 64 Technology (EM64T) offers flexibility for 64-bit and 32-bit applications and operating systems
  • Execute Disable Bit allows the processor to classify areas in memory by where application code can execute and where it cannot


The 2.13 GHz Dual Core Xeon® Processor 3050 from Dell is designed for multi-processor systems. The dual-core processor architecture places two execution cores, or computational engines, within a single processor. This processor, with 1066 MHz bus speed, offers excellent performance and headroom for peak Internet server loads, resulting in fast response times, support for more users and improved scalability. The incorporated Virtualization technology provides hardware-assistance to virtualization software enhancing virtual environment. In addition, the Enhanced Speedstep® Technology helps reduce average system power consumption and enhances system acoustics. This processor is supported by Dell Technical Support when used with a Dell system.

Manufacturer Part# : DN518
Dell Part# : 311-6835

Wingspan Bank – Wikipedia, the free encyclopedia April 9, 2010

Posted by John Ruby in News and politics.
add a comment

Wingspan Bank – Wikipedia, the free encyclopedia
Wingspan Bank

Wingspan Bank was a U.S. bank operating solely via the Internet from 1999 to 2000. It was a wholly owned subsidiary of Bank One. The CEO was Jim Stewart, previously of the parent bank’s First USA division.

The bank began operations in June 1999, with the marketing slogan "If your bank could start over, this is what it would be." An aggressive online marketing campaign was carried out to promote the bank, which also received wide coverage in mainstream financial press. The venture also benefited from its parent’s existing marketing agreements with major web portals such as America Online, MSN, and Excite. A marketing agreement was also entered into with then-major search engine/portal Lycos. An additional incentive was the promise of a $100 reward to the first 10,000 customers.

Despite being owned by Bank One, an existing brick and mortar banking institution in the Chicago area, Wingspan was branded wholly separately and with minimal acknowledgment of the relationship. As a result, Wingspan’s online-only operation effectively competed with Bank One’s own online presence, particularly as the online bank’s lack of physical presence allowed it to provide better fees and rates for customers. The bank provided most traditional financial services from interest-bearing checking accounts to credit cards, Individual Retirement Accounts and HELOCs. It also provided bill pay, with on-time payment guarantee, although the payment was physically done via the bank mailing a check to the payee in most cases.

The lack of physical presence was ultimately a negative for the bank. While customers were able to use Bank One ATMs for free, they could not use any physical bank branches. Non-electronic deposits had to be made via postal mail. The bank refunded up to $5 in ATM fees per month for customers not living near Bank One locations.

By September 2000, Bank One discontinued the Wingspan brand and rolled the online bank’s customers into Bank One’s existing online service as regular account holders. The parent company cited the online bank’s inability to attract a sufficient number of customers as the reason for its closure. The reintegration of Bank One’s online venture followed a similar action by Citibank with its Citi/fi brand, and other online banks such as Telebank merged with or entered into service agreements with physical banks.

CEO Jim Stewart left Wingspan in late 1999 to form Juniper Financial.

Cloud Computing | Business Application | Infrastructure Services April 8, 2010

Posted by John Ruby in Solutions.
add a comment

Cloud Computing | Business Application | Infrastructure Services
The world’s most widely used software is now available in the cloud.Twenty million businesses and over a billion people use Microsoft cloud services. We and our partners are committed to delivering a broad set of enterprise-ready products and services that build on what you already know. We’re all in.

Windows Azure offers a flexible, familiar environment designed to create applications and services for the cloud. With Windows Azure, you can shorten your time to market and adapt as demand for your service grows.

Windows Live ID – with 460 million users – is the identity and authentication system provided by Windows Live. The system lets you create universal sign in credentials across diverse applications

Microsoft SQL Azure provides a highly scalable, multi-tenant database that you don’t have to install, setup, patch or manage. Kelley Blue Book, 3M, Siemens and other leading companies are using SQL Azure today.

Microsoft Exchange Online is highly secure hosted e-mail with "anywhere access" for your employees, starting at just $5 per user per month.

Microsoft SharePoint Online gives your business a highly secure, central location where employees can collaborate and share documents. That means more managed workflow, better version control, and "anywhere access" to business critical data.

Microsoft Office Live Meeting provides real-time, Web-hosted conferencing so you can connect with colleagues and engage clients from almost anywhere – without the cost of travel.

Microsoft Office Communications Online delivers robust messaging functionality for real-time communication via text, voice, and video.

Microsoft Office Web Apps are online companions to Word, Excel, PowerPoint, and OneNote, giving you the freedom to access, edit, and share Microsoft Office documents from virtually anywhere.

Microsoft Dynamics CRM Online helps you find, keep, and grow business relationships by centralizing customer information and streamlining processes with a system that quickly adapts to new demands.


DeWALT Heavy-Duty 2.4 Amp Orbital 1/4 Sheet Sander w/ Cloth Dust Bag April 4, 2010

Posted by John Ruby in Hardware.
add a comment


DeWALT Heavy-Duty 2.4 Amp Orbital 1/4 Sheet Sander w/ Cloth Dust Bag

The D26441K Features

  • 2.4 Amp motor sands at 14,000 opm, providing a superior finish.
  • Textured anti-slip top & body grip provides ultimate comfort and control during use.
  • Dust sealed switch for increased durability.
  • Sealed 100% ball-bearing construction provides longer life.
  • High capacity dust bag with built in vacuum adapter provides maximum dust collection with or without vacuum.
  • Dual plane counter-balanced low-vibration design reduces fatigue.


  • Amps 2.4 Amps
  • Orbits/Min 14,000 opm
  • Orbit Diameter 1/16 "
  • Dust Collection Yes
  • Paper Size/Type 1/4 Sheet
  • SFPM N/A
  • Dust Sealed Switch Yes
  • Pad N/A
  • Pad Break N/A


  • dust bag with vacuum adapter
  • sandpaper punch
  • heavy-duty kit box

• Shipping Weight: 6.45 lbs.
Receive an additional discount at checkout



DeWALT 18V XRP 9 Tool Combo Kit (Right Angle Drill) April 4, 2010

Posted by John Ruby in Hardware.
add a comment


DeWALT 18V XRP 9 Tool Combo Kit (Right Angle Drill)

The DeWALT DCK950X features 9 Heavy Duty tools to take on any project ranging from construction, remodeling, home repair, home projects and much more! DeWALT has always had the toughest tools to help you get your job done. With this DeWALT DCK950X 18 Volt XRP Cordless 9 piece Tool Combo kit, you can make sure that the toughest jobs are done correctly. This DeWALT DCK950X High Performance Industrial Tool comes with a warranty package that includes a 3 Year Limited Warranty, 1 Year Free Service Contract, and a 90 Day Money Back Guarantee.
The DCK950X Features:

  • DCD950 XRP 1/2" hammerdrill/drill/driver
    • DEWALT built high power, high efficiency motor delivers 510 unit watts out of power for maximum performance in all drilling and fastening applications
    • Heavy-Duty 1/2" self-tightening chuck tightens throughout operation providing superior bit gripping torque
    • XRP extended run-time batteries provide long run-time & battery life
    • Patented 3-speed all-metal transmission matches the speed to the application for optimal performance
    • Superior ergonomics optimize balance, size, and weight
  • DC390 XRP circular saw
    • 3,700 RPM for fast rip cuts and cross cuts
    • 6-1/2" carbide tipped blade for 2x cutting capacity at 90° and 45° High strength magnesium shoe and upper guard provides increased durability
    • 0-50° bevel capacity provides additional capacity for a multitude of applications
    • Fan-cooled motor with replaceable brushes for maximum power and durability
    • XRP extended run-time battery provides long run-time & battery life
  • DC385 XRP reciprocating saw
    • 1-1/8" Stroke Length for Faster Cutting Speed
    • 0-3,000 SPM for Faster Cutting Speed
    • 4 Position Blade Clamp allows for flush cutting and increased versatility
    • Lever-Action Keyless Blade Clamp for Quick and Easy Blade Changes
    • Anti-Slip Comfort Grip Provides Increased Comfort and Control
    • XRP Extended Run-Time Battery Provides Long Run-Time & Battery Life
    • Pivoting Adjustable Shoe with Open Top for Maximum Visibility
    • Variable Speed with Trigger Lock for Increased Blade Control
  • DW960 right angle drill
    • 2 speed ranges 0-500/0-1,500 rpm for increased user flexibility providing a wide range of applications
    • 310 in-lbs of maximum torque for heavy-duty applications such as turning large bits and fasteners
    • Durable, right angle transmission with sealed ball bearing for a longer tool life
    • Multi-grip trigger provides comfort and convenience by allowing the user to get into tighter spaces while still having access to the trigger
    • Variable speed and reversing gives the user the ability to control speed for greater accuracy, and the convenience of reverse
  • DC411 cut-off tool
    • 6,500 rpm provides high power for cutting and grinding applications
    • Convenient trigger switch with lock-off button for easier gripping
    • 3 Position side handle offers greater comfort and control
    • Metal gear case dissipates heat for longer bearing, gear and motor life
    • Spindle lock allows users to change their wheels quick and easy
  • DW059 1/2" 18V high torque impact wrench
    • 300 ft-lbs of maximum torque to perform a wide range of heavy-duty fastening applications
    • Preferred rocker switch design for fast and easy fastening
    • 1,650 rpm/2,600 bpm for faster application speed
    • Durable magnesium gear case and all metal transmission for extended durability
    • Comfort grip provides maximum comfort
    • Heavy duty impacting mechanism directs torque to fastener without kickback
  • DC330 XRP 18V variable speed jig saw
    • All-Metal Lever-Action Key less Blade Change Allows for Quick and Easy Blade Changes
    • 4-Position Orbital Action Provides Control of Cut Quality and Speed
    • All-Metal Key less Shoe Bevel with Detents at O, 15, 30 and 45 Degrees Provides Versatility for Easy Bevel Cutting
    • Variable Speed 0-3,000 SPM for Versatility in a Multitude of Materials and Applications
    • Adjustable Dust Blower Keeps Line of Cut Clear of Chips
    • XRP Extended Run-Time Battery Provides Long Run-Time & Battery Life
    • Anti-Slip Comfort Grip for Increased Comfort and Control
  • DC550 18V cut-out tool
    • Tool-free bit change for fast and eay bit changing without a wrench
    • 26,000 rpm motor provides more cutting power
    • Dust sealed switch provides durability and long switch life
  • DW919 flexible floodlight
    • Wide-angle beam is brighter than traditional flashlights
    • Flexible neck allows for hands-free operation and light to be projected in any direction whether it is standing on its base, wrapped around a pipe, or hanging from rafters overhead
    • Lockable head clip offers versatility and convenience of a lantern
    • Extra-bright Xenon bulb maximizes brightness of the beam


  • DCD950 XRP 1/2" hammerdrill/drill/driver
    • Voltage: 18 Volts
    • Max Power: 480 UWO
    • Number of Speed Settings: 3
    • Max RPM: 0-450/0-1,500/0-2,000
    • Max BPM: 0-7,650/0-25,500/0-34,000
    • Clutch Settings: 22
    • Chuck Size: 1/2 Inch
    • Chuck Type: Metal/self-tightening
    • Tool Weight: 6.1 Pounds
  • DC390 XRP circular saw
    • Voltage: 18 Volts
    • No Load Speed: 3,700 rpm
    • Blade Diameter: 6-1/2 Inches
    • Bevel Capacity: 0-50 deg.
    • Arbor Size: 5/8 Inch
    • Depth Of Cut At 45 deg. : 1-5/8 Inches
    • Depth Of Cut At 90 deg. : 2-1/4 Inches
    • Tool Weight: 8.7 Pounds
  • DC385 XRP reciprocating saw
    • Voltage: 18 Volts
    • Keyless Blade Clamp: Yes
    • Strokes Per Minute: 0,3000 spm
    • Stroke Length: 1-1/8 Inches
    • Electric Brake: Yes
    • Tool Weight: 8.2 Pounds
  • DW960 right angle drill
    • Voltage: 18 Volt
    • Max Power: 320 UWO
    • Chuck Size: 3/8 Inch
    • Number of Speed Settings: 2
    • Speed: 0-500/0-1,500 RPM
    • Chuck Type: plastic, 2-sleeve
    • Tool Weight: 4.7 Pounds
  • DC411 cut-off tool
    • Voltage: 18 Volts
    • No Load Speed: 6,500 rpm
    • Spindle Lock: Yes
    • Spindle Thread: 5/8 Inch-11
    • Tool Weight: 7.0 Pounds
    • Use Wheels RPM Above: 10,000 rpm
  • DW059 1/2" 18V high torque impact wrench
    • Voltage: 18 V
    • Drive: 1/2" square with detent pin retention
    • No Load Speed: 1,650 rpm
    • Impacts/Min: 2,600 bpm
    • Max. Torque: 300 ft-lbs
    • Max. Torque: 300 ft-lbs
    • Tool Weight: 7.55 lbs
    • Tool Length: 10-3/4"
  • DC330 XRP 18V variable speed jig saw
    • Voltage: 18 Volt
    • Strokes/Min: 0-3,000 spm
    • Stroke Length: 1 Inch
    • Keyless Blade Clamp: Yes
    • Dust Blower: Yes Tool Weight: 7.5 Pounds
  • DC550 18V cut-out tool
    • Voltage: 18 Volt
    • No Load Speed: 26,000 rpm
    • Collet Diameter: 1/4 or 1/8 Inch
    • Adjustable Guide: Yes
    • Tool Weight: 4.5 Pounds
  • DW919 flexible floodlight
    • Voltage: 18 Volt
    • Bulb: Xenon
    • Run-Time: 3 hours
    • Lux: 325
    • Bulb Life: 110 hours
    • Tool Weight: 0.5 Pounds
  • Battery/Charger
    • Battery Rating: 18 Volt
    • Battery Technology: XRP Ni-Cd batteries
    • Amp Hours: 2.4
    • Charge Time: 1 hour
    • Tool Weight: 0.5 Pounds


  • DCD950 XRP 1/2" 18V hammerdrill/drill/driver
  • DC390 XRP 18V circular saw
  • DC385 XRP 18V reciprocating saw
  • DW059 1/2" 18V high torque impact wrench
  • DC330 XRP 18V variable speed jig saw
  • DW960 18V right angle drill
  • DC411 18V cut-off tool
  • DC550 18V cut-out tool
  • DW919 18V flexible floodlight
  • 1 hour charger
  • (2) 18V XRP batteries
  • 360° side handle
  • Carbide tipped blade
  • Type 1 and Type 27 guards
  • Wrench
  • Backing Flange
  • (1) type 1 wheel
  • (2) contractor bags
  • 2-position side handle

• Shipping Weight: 55.60 lbs.