CX NOW! is a powerful dashboard tool from BusinessObjects. Check out their demo. Prices start at 195$

Neopoleon : Excel as a database
“As a developer, you’ve probably, at some unfortunate point in your life (possibly several points, actually), been handed an Excel file that has been crammed full of “data” by someone in marketing and told to “do something with it.”"

My First BillG Review

If you are building a solution that runs in a server-side context, you should attempt wherever possible to use components that have been made safe for unattended execution, or find alternatives that allow at least a part of the code to run client-side. If you choose to use an Office application from a server-side solution, you will find that it lacks many of the necessary capabilities to run successfully, and you will be taking risks with the stability of your overall solution.”

Further incentives on quitting Office Automation would be useless.

1. Conditional Formatting
2. More rows
3. Previewing
4. Ribbon and menu bars
5. Charting

vs

1. Sharing
2. Search

“Why do people keep putting data in spreadsheets that obviously belongs in a database? Oddly enough, part of the reason came to me in a fairly unlikely place, reading to my kids before bed. We had just plopped on the couch to read a book when my kindergartener made me back up and read the cover of the book, pointing out to me the author and the illustrator. That was an enlightening moment; from a very early age we start learning the structure of documents. Title, author, and date of publication, page number, etc, etc is reinforced at every grade level.”

This article points out one major mistake that most users do when using spreadsheets: mistaking them for a database.

Document Centric

Contextures.com shows how you can display different images based on an cell value input. Via DashBoardSpy

The course can be completed in one day, or over four separate sessions. Content includes four 75 minute lectures and four 30 minute labs. The actual time needed to complete the labs may vary, depending on the attendees’  programming experience.

Graduates will have a good high-level understanding of the new capabilities of .NET 3.0, and are welcome to take the content and re-present it to their peers, in either an official or unofficial capacity.

.NET U

Excel has the ability to put code in three places. If the code is in a standard module the key to stopping the dialog is to remove the entire module(s), not simply delete the code in it. To do this:

1. Open the VBE (Alt+F11)
2. In the project explorer look for the name of the workbook. Below this you should see a folder called …

Read the rest at Nick Hodge