Great! I hope one day someone will make a similar plugin for LibreOffice Calc.
Visualise the structure of a spreadsheet
71–76 of 76 posts
Re: Visualise the structure of a spreadsheet
#72I love the way you've presented the underlying structure so much, I found myself wishing you would replace the spreadsheet itself!
Well, maybe one day...
I think you will really love this video : http://worrydream.com/dbx/
It's a conference about programming languages in general. It's interesting, with cool materials, and fun to watch.
Also if you need to have more ideas, you can take a look at the Unreal Engine and Cryengine. They built similar tools to allow artists to code graphically scripts for video games.
Cool idea anyway.
Re: Visualise the structure of a spreadsheet
#73This doesn't seem worlds away from LiveSheets.
Re: Visualise the structure of a spreadsheet
#74Earlier quoted context omitted.
You are just a small step away from the concepts in Subtext: http://www.subtext-lang.org I highly recommend watching the screencasts, especially the demo: http://www.subtext-lang.org/demo1.html I have wanted a graphical interface for functional programming in environments like Excel for a long time. In my experience, most of the pseudo-programming that has dominated software engineering (object-oriented/MVC/message-b…
...nobody has successfully made functional code approachable I'm not totally sure what to make of this statement. I think of functional programming as an extension of the expression-based computation almost everyone (in the first world anyway) learns in pre-algebra. What could be more approachable? Yet I always have trouble recommending a specific functional language to someone who's curious. I'd say scheme if sexprs…
I use Haskell, but for many data manipulation problems it is still clearer to do them in Excel, mostly because of the bigger emphasis on the data itself, easier visualisation and eyeball-verification intermediate results, and simpler data-garbage-fixing in case a data point "raises an exception".
Re: Visualise the structure of a spreadsheet
#75Earlier quoted context omitted.
Oh don't you dare! Run an a/b test first, before you disable autoplay. If autoplay gets more signups then keep it. You're not here to be our friend and drink tea, you're running a business. From a design point of view, I LOVE your desaturated forest look with the logo. It's all very memorable
Fair point. My miserableness may not be typical.
I know what you mean though. I have chrome plugins installed that prevent autoplay, flash, widgets, facebook, and a whole lot of other things. It's awesome I can have 40+ tabs open and not have to worry about lag.
Re: Visualise the structure of a spreadsheet
#76From the video, this looks like a graphical spreadsheet debugger. That is a fucking fantastic idea. It's been a while sine I used a lot of excel, but this would have been great. I think you'd want to target non-programmers who use a lot of excel (so people in "business") and just bring them more debugging features. An excel IDE would be an ambitious potential next step.
I'm not sure I agree with the second point. Excel has tons of debugging features, too many. It means most people don't know about all the tools and they're all really badly designed. This is about getting rid of all that and creating one new feature, the tree view. Which offers way more functionality on it's own.
While Excel has SOME debugging features, they really don't work well at ALL for large formulas. I don't need something to help me debug some multiplication.
But when I'm offsetting to an array upon which I'm selecting and summing a subset of these cells with an if-driven sumproduct, and maybe dynamically looking up all of the ranges with more index/matches.... its impossible to look at in the little formula tracing box.
I can't wait to try this out.