This courtesy of Windmill Software….Dan
Excel has a little-used feature that provides great flexibility when analysing tables of data. It is called an Array Formula.
You can use an array formula

To return several values
To apply a function only to values matching your conditions.
To perform calculations on values matching two or
more criteria

An array formula […]

Agilent Technologies has introduced two modules for its N6700 Modular Power System family that measure microamp current for a device under test (DUT). For R&D engineers designing integrated circuits and electronic devices that run on batteries, these power supplies measure current consumption and its effect on battery run time. When used in Automatic Test Equipment […]

From the March 18, 2008 issue of NIST Tech Beat:
A new report published today identifies and describes research and development priorities for the future of three critical, high-tech U.S. manufacturing areas – hydrogen energy technologies, nanomanufacturing, and intelligent and integrated manufacturing. The report, Manufacturing the Future: Federal Priorities for Manufacturing R&D, was prepared by the […]

DATAQ Instruments DI-785 and DI-788 connect to and synchronize over an Ethernet to provide high performance and high channel density. Multiple units, separated by over 100 meters, can synchronize at samples rates as high as 180 KHz per unit by simply daisy-chaining ordinary CAT-5 cables between them. With up to 32 fully isolated channels per […]

Dassault Systèmes has released the Abaqus BioRID II dummy model for use with SIMULA. This model will be used by the automotive engineers during the design phase of seats and head restraints to assess and reduce the risk of neck injuries resulting from rear-end vehicle collisions.
The new Abaqus BioRID II has been developed and validated […]

The Sensor Development 01367 rotating torque sensor family feature a bearing system that allows the structure to be exposed to very high radial loads without damage. Most standard torque sensors require their housings to float to minimize any extraneous loading other than the torque applied to the shaft.
This sensor allows for extraneous […]

The Arizona Republic reports that Volvo, Nissan and Volkswagen are upgrading their Arizona proving grounds even as GM is selling off its test tracks. The article notes:
While General Motors and other car companies with proving grounds in the Valley sold thousands of acres to developers, anticipating ever-encroaching rooftops, Volvo went against the grain. It decided […]

PCB Piezotronics’ new series of pedal effort load cells are aimed at automotive test applications, including brake development, drivability, vehicle handling, and legislative & safety testing. Designed to measure the force required to operate a vehicle’s primary brake, clutch, or floor-mounted emergency brake pedals, the Series 1515 brake pedal effort sensor with integral cable is […]

LeCroy’s FlexRay physical layer test package that provides eye diagram mask testing and physical layer measurement parameters to help make LeCroy’s WaveRunner Xi an oscilloscope-based solution for FlexRay testing. These new capabilities combine with LeCroy’s existing FlexRay protocol trigger and decode tools to create a single instrument that can conduct advanced triggering, protocol decoding and […]

The Vision Research Phantom® V5.2 captures up to 1,000 pictures-per-second (pps) at full-resolution of 1152×896 and up to 148,000 pps at lower resolutions. It is available with either a monochrome CMOS sensor, which yields a sensitivity rated at ISO 2400, or a color CMOS sensor, which features an ISO of 600. As with all Vision […]