Make your application compile spreadsheets directly to parametrized, high-performance Java classes for use in your business logic using the Abacus Formula Compiler (http://formulacompiler.org/, available under GPL or commercially).
(Link: Excel on the JVM Generating Fast Code from Spreadsheet Models – Devoxx 2010 - Devoxx)
Excel on the JVM Generating Fast Code from Spreadsheet Models – Devoxx 2010 - Devoxx
roo – read spreadsheets with ruby
This gem allows you to access the content of
* Open-office spreadsheets (.ods)
* Excel spreadsheets (.xls)
* Google (online) spreadsheets
* Excel’s new file format .xlsx
(Link: roo – read spreadsheets with ruby)
Sparklines in Excel 2010
For Excel 2010 we’ve implemented sparklines, “intense, simple, word-sized graphics”, as their inventor Edward Tufte describes them in his book Beautiful Evidence. Sparklines help bring meaning and context to numbers being reported and, unlike a chart, are meant to be embedded into what they are describing:
(Link: Sparklines in Excel 2010)
Acrobat.com Tables – Adobe Labs
With Acrobat.com Tables, you can:
* Easily work with others on the same table at the same time. With simultaneous editing, no one is locked out of the table while others are making changes.
* Simplify collaboration. No need to combine multiple versions, e-mail spreadsheets back and forth, or worry about version control, because everyone has access to the latest information, online, all the time.
* Personalize the display of shared data. Use private views to display the information that is important to you, without affecting others who may be viewing or working with the same table.
* Access your data and information from anywhere. Your table is always available online so you and your team can share a data set and add to it regardless of where you are located.
(Link: Acrobat.com Tables – Adobe Labs)
Free Microsoft Excel Templates and Spreadsheets
Looking for free Microsoft Excel ® templates? Here you will find a list of all the popular spreadsheet templates and calculators available from Vertex42, along with the pages we created specifically to help guide you to where you can find other free Excel templates and spreadsheets.
(Link: Free Microsoft Excel Templates and Spreadsheets)
Manual Gantt Charting in Excel
David Seah’s combination of the Compact Calendar and a Gantt chart
(Link: Manual Gantt Charting in Excel)


October 15, 2010 