spreadsheet

Module: sheetnode

This Drupal module allows to create and edit spreadsheets on the Web, much like Google Docs. Because it is integrated within Drupal, though, these spreadsheets can now be categorized and manipulated just like any other content. Plus, the module imports and exports Excel and OpenOffice.org files. It brings me closer to my vision of Deep Excel I had a few year ago.

Check it out: http://drupal.org/project/sheetnode

Matrix programming in Excel

Excel is like a giant matrix programming pad. Take a financial statement for example: I am just learning to read one and I am discovering the logic behind the usage of the tool.

The statement can be considered a computer program made up of arithmetic and logic operations on matrices. One of its output is the Balance Sheet, that pulls results (i.e., invokes functions) from the various other sheets, namely: Income Statement, Cash Flow Statement, Revenues, Expenses, etc.

Deep Excel

Actually this should be called DEEP 1-2-3, or perhaps DEEP SHEEEET.

Introduction

One interesting observation about the business world is that managers love Excel. They want to use it to do everything. Except that Excel is not ready to do everything, however Microsoft is trying to beef it up.

Specifically, what is Excel used for?

  • Tallying numbers
  • Creating forms
  • Simulating models
  • Analyzing data
  • Creating reports

Pretty impressive.

Syndicate content