11–20 of 76 posts
I've been working on this myself and would really love to get some feedback. Would this be useful for the problems you have with Excel?
it's a great idea - much better than the old built-in formula dependency tracker. definitely loving your idea! I've been in the Excel business myself for years (having worked in finance) and always love when someone comes up with a fresh tool for the mighty Excel (yeah, I know most developer's views on Excel...). I've recently started www.spreadgit.com which is a GitHub-like service for spreadsheets. looking forward…
Don't mean to hijack the thread, but I've been toying with the idea of having users use a data flow diagram to structure complex spreadsheets. Still have a pre-prototype stage and I'ld love to get your expert feedback on that idea. If interested please drop me a note.
Earlier quoted context omitted.
hmm, what's wrong with uploading it? I would actually prefer the no-Addin solution: the Excel Addin 'deployment' is a bit messy (with references stuck in the Addin-manager) + no Addins in the Mac world (though I guess that >95% of Excel users are on windows)
We were definitely pursuing the add-on route. Although add-ons can be clunky we felt people would want to switch between the two views quickly and often. For example, if you make a change in the spreadsheet view you might want to see what effect that had on the tree. What do you think?
Interesting. As I understand it, you use a spreadsheet as input and then create the data flow diagram. I certainly see how seeing the data flow diagram means better clarity and error-finding. So here is a question for you? What if we take it a step further and have users actually entered their complex spreadsheets in a tidy graphical data flow diagram which mapped back?
> id: 1100 the reason is: Event [Event type="fontLoadError" bubbles=false cancelable=false eventPhase=2]
> try to look at the prezi thing > id: 1100 the reason is: Event [Event type="fontLoadError" bubbles=false cancelable=false eventPhase=2]
Earlier quoted context omitted.
Great idea! Do you have to upload the spreadsheet? If yes then a big downer. Better if you could release and sell as Excel Plugin
hmm, what's wrong with uploading it? I would actually prefer the no-Addin solution: the Excel Addin 'deployment' is a bit messy (with references stuck in the Addin-manager) + no Addins in the Mac world (though I guess that >95% of Excel users are on windows)
Interesting. As I understand it, you use a spreadsheet as input and then create the data flow diagram. I certainly see how seeing the data flow diagram means better clarity and error-finding. So here is a question for you? What if we take it a step further and have users actually entered their complex spreadsheets in a tidy graphical data flow diagram which mapped back?