Excel Parslets

I used a PEG grammar as implemented in Ruby's Parselet to parse Excel expressions to track the data flow through a complex collection of workbooks. gem

A web of data flows represented as excel formulas parsed and rendered as a web pages encoded in svg.

I generated a collection of Graphviz dot files from the parse and rendered them in a hierarchal clickable SVG. I found several inconsistencies by looking at patterns in these pictures. svg

I had hoped to translate excel formulas to wiki plugins but found excel's computational model (query semantics and iterative solution) way too complex. Hand translation to hypertext eliminated need for both complexities.