column News and Other Resources

Blog Post

10 cool ways to use Excel's conditional formatting feature

April 11, 2012 2:06pm PDT

Excel's conditional formatting feature can do a whole lot more than many people realize. Susan Harkins runs through 10 practical ways to put this tool to work.

23 Latest comment by EleanorSugden

Blog Post

Office solution: Why Excel sometimes displays dates instead of values

April 11, 2012 1:43pm PDT

This week, learn the possible solutions to last week's challenge: Why is Excel displaying a date instead of a numeric value?

1

Discussion Threads

A quick and dirty way to compare columns of Excel data

April 6, 2012 8:55pm PDT

A quick and dirty way to compare columns of Excel data article root Nice Handy tip. :) Very Useful Tip Thanks for posting this... What version of Excel? Unfortunately, some of us are still...

25 Started by lehnerus2000 | Latest comment by HAL 9000

Blog Post

A quick and dirty way to compare columns of Excel data

April 6, 2012 11:41am PDT

Using this little-known feature in Excel, you can quickly compare one column of data to another.

25 Latest comment by HAL 9000

Discussion Threads

Office challenge: Why is Excel displaying a date instead of a numeric value?

April 5, 2012 8:45am PDT

Office challenge: Why is Excel displaying a date instead of a numeric value? article root Cell Formatted in date format Change to general or number.. Option is mis-picked Under (2010) File...

16 Started by jamesski | Latest comment by Marshwiggle

White Papers

Design and Analysis of Hybrid CMOS SRAM Sense Amplifier

April 5, 2012 12:00am PDT

Sense amplifiers are one of the very important peripheral components of CMOS memories. In a Hybrid Sense amplifier both current and voltage sensing techniques are used which makes it a better...

Provided by: Centre for Development of Advanced Computing

Downloads

Cache Monitor 0.34 (Windows)

April 5, 2012 12:00am PDT

Cache Monitor is a SQL development tool designed for InterSystems database Cache. It supports developers with features, like: Advanced SQL Query Editor,Cache-SQL Syntax highlighting,SQL Code...

Provided by: ixdb

Whitepapers

Database Architecture with Row and Column Stores

April 1, 2012 12:00am PDT

Operational reporting differs from informational reporting in that its scope is on day-to-day operations and thus requires data on the detail of individual transactions. It is often not desirable...

Provided by: IJCER

Blog Post

How to repeat pivot table headings when printing Excel documents

March 28, 2012 11:03am PDT

A pivot table that spans more than one printed page will be confusing without its column headings. Use this tip to print column headings on every sheet.

3 Latest comment by jensqox@...

Blog Post

Tutorial: Take your minimalist web design from Photoshop to HTML, part 3

March 22, 2012 9:00am PDT

Ryan Boudreaux completes his three-part series on taking a minimalist web design from Photoshop to HTML. Here, he adds the finishing touches to the code for the footer section.

White Papers

Horizontal Aggregations for Mining Relational Databases

March 15, 2012 12:00am PDT

Existing SQL aggregations have limitations to prepare data sets because they return one column per aggregated group using group functions. A significant manual effort using a compliant programming...

Provided by: International Journal of Computer Science and Information Technologies

Whitepapers

Uniquely Decodable Code-Division Via Augmented Sylvester-Hadamard Matrices

March 12, 2012 12:00am PDT

The authors consider the problem of designing binary antipodal uniquely decodable (errorless) code sets for overloaded code-division multiplexing applications where the number of signals K is...

Provided by: State Street Corporation

Q&A

excel 2007

March 1, 2012 4:23am PST

excel 2007 hi i want to compare sheets in one excel 2007 file for duplicate names to see if there are any, how do i do this anyone??? try a formula what you can do within a worksheet is to first...

4 Started by sallydj | Latest comment by Al Kostiuk

Whitepapers

Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores

March 1, 2012 12:00am PST

Modern business applications and scientific databases call for inherently dynamic data storage environments. Such environments are characterized by two challenging features: they have little idle...

Provided by: VLD Digital

Whitepapers

Implementing a Novel Data Structure for Maintaining Cumulative Frequency of Symbols

March 1, 2012 12:00am PST

A new data structure, namely "Cumulative Frequency Matrix (CFM)", is proposed here for maintaining cumulative frequencies. For an order-0 model having 256 symbols, CFM is a 2-D array of 16 rows...

Provided by: International Journal of Computer Applications

White Papers

Study of Performance and Mechanism of Sandwich Protection Devices for Bridges

March 1, 2012 12:00am PST

In the paper, the rectangular column sandwich plate protective device is developed to resist the impact loading without the bridge's damage. And its behavior is studied. The ANSYS/LS-DYNA, which...

Provided by: AICIT

Discussion Threads

CSS3 styling for data tables

February 29, 2012 8:55am PST

CSS3 styling for data tables article root Oops! I referenced some html5 tags in angled brackets & they disappeared... [Quote marks this time...] According to the validator.w3.org it appears the...

2 Started by jeffrey.bollman@... | Latest comment by jeffrey.bollman@...

Blog Post

Office solution: How to sum every other value in a column

February 23, 2012 8:59am PST

This week, learn the solution to last week's challenge: How would you sum every other value in a column?

Discussion Threads

Office challenge: How would you sum every other value in a column?

February 17, 2012 12:18pm PST

Office challenge: How would you sum every other value in a column? article root SUMPRODUCT(MOD(ROW())) is one answer The formula =MOD(B1,2) would return 0 if the number is even and 1 if it's odd,...

11 Started by Darryl~ | Latest comment by sk.tomar@...