excel

Installing RExcelXML from The Omega Project in R

1
398 days
by in computing, excel, linux, R

A quick post to capture the resolution to the past 20 minutes I have spent in frustration trying to install RExcelXML from Omegahat (The Omega Project for Statistical Computing). As this is a source package, the dependencies need to be satisfied manually (which is a bit baffling, frankly — surely there is a workaround for this using a makefile-like facility in install.packages()). The package depends on ROOXML, Rcompression and XML. The solution is two-staged:

> install.packages(c('Rcompression', 'XML'))
> install.packages(c('ROOXML', 'RExcelXML'), repos = 'http://www.omegahat.org/R', type = 'source')

Back to the grind …

Excel Progress Indicator & Check-List Proof of Concept

3
1601 days
by in excel

Recently I was asked by the project management of a client to create a check-list in Excel for an initiative they are heading. While I cannot disclose the exact solution I provided them — due to non-disclosure agreements in effect — I can share the proof of concept I built for the spreadsheet. As a part of my brainstorming about what would be useful in such a spreadsheet, I devised a rather novel progress indicator which updates automatically as tasks are completed.

The proof of concept spreadsheet can be found hererent a car bulgaria. Credit is due to the guys at Juice Analyticsкомпютри for pioneering the concept of representing values graphically within a cell.

Go to Top