TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Show HN: Instantly Understand Any Spreadsheet

192 pointsby f292almost 11 years ago

13 comments

arethuzaalmost 11 years ago
Some feedback:<p>- Getting the license key was a bit slow, I went through the process of getting a reminder before the original turned up (I guess I&#x27;m impatient - but it&#x27;s annoying when I had to hunt around my Junk Mail&#x2F;Deleted Items to see where the license had gone). Why bother with a license for a demo?<p>- I find the appearance is too different to Excel so is a bit jarring<p>- The animations are cute, but not sure that they actually aid usability<p>- Although my initial reaction wasn&#x27;t that positive it did actually grow on me but I think it needs an obvious immediate impact to demonstrate a clear benefit over the standard Trace Precedents&#x2F;Dependents<p>- I can actually think of one scenario where this would have been pretty useful. I was designing a industrial modelling application that had been &quot;prototyped&quot; as an extremely complex Excel application - I had to spend a <i>lot</i> of time showing people that the calculations in the spreadsheet weren&#x27;t what people thought they were - so having some way of automatically generated <i>documentation</i> of parts of a spreadsheet would have been useful.<p>Overall - not bad, but I think you <i>really</i> need to nail the exact pain points this would be useful for. Maybe also drop the Tony Stark&#x2F;Avengers example - it&#x27;s cute but might not appeal to your target market.
评论 #8136233 未加载
excel2flowalmost 11 years ago
I had some trouble reading nested IF functions, so I wrote a piece of code which translates them into flowcharts: <a href="http://excel2flow.asp2.cz/" rel="nofollow">http:&#x2F;&#x2F;excel2flow.asp2.cz&#x2F;</a> (weekend project)
评论 #8137188 未加载
评论 #8136728 未加载
评论 #8136288 未加载
roel_valmost 11 years ago
OK here is my feedback.<p>First some superficial stuff: Installshield is not going to fly with the market you want to make real money off, i.e. big organisations who want to deploy through Active Directory. The Office addin installer can be put as a merge module into an MSI, that will make the overall install experience much slicker. The instructions on the web page that opens after installation say to look in tab &#x27;Add ins&#x27;, but it&#x27;s in separate &#x27;Slate&#x27; tab (Office 2013&#x2F;Win8.1). The introduction tutorial is unintelligibly small on a high dpi screen (Lenovo Yoga Pro 2); so is everything else that doesn&#x27;t scale with ctrl-mousewheel. I just aimed very well with the mouse to make it go away and I tried to figure it out on my own.<p>On to the functionality. I work with Excel models if not daily, then at least a few times a week. These are usually either models I get from partners and which I integrate with other models, or they are data analyses. Over the last few weeks I worked with an economic model and a demographic model I got from outside, and I did several analyses on land use&#x2F;population data myself. They&#x27;re always intricate and on the overall complexity scale (as far as Excel models go) range from &#x27;medium&#x27; to &#x27;high&#x27;. So I think I&#x27;m exactly your target customer.<p>I tried first with a medium-complexity spreadsheet (5 worksheets, couple of dozen &#x27;variables&#x27; where the variables are usually 2d matrices and the analysis is in aggregating and disaggregating the input data in various ways). I tried Slate on several fields, but for none of them I could better understand what they were than by using Excel&#x27;s build-in &#x27;Trace precedents&#x27; or even by just reading the formulas. Slate shows only very little context; you have to scroll out far to see those 2 or 3 steps away, but at that point everything is too small to read. Furthermore, it doesn&#x27;t really dissect formulas; for example, an &#x27;if&#x27; with two VLOOKUPs is just a pink blob with a bunch of arrows coming in, without giving information on how or what. It also takes up half of the width of my screen, so there isn&#x27;t a whole lot more I can see on the screen.<p>What is worse is that there is no description of each &#x27;block&#x27; (could have taken the label in front or above the formulas in the original sheet); nor does there seem to be a way for me to enter them manually. For example, I can see the value in being able to annotate a &#x27;box&#x27; (variable) in my model with &#x27;Plot counts per district&#x27;, then an out arrow with &#x27;multiply with average amount of dwellings in low residential land uses for the transport zone&#x27;, then the box where the arrow ends up with &#x27;dwellings in low residential housing areas per district&#x27;. That doesn&#x27;t seem possible.<p>When &#x27;show detail&#x27; is on, some of the boxes have the upper left corner of some range of cells in them; I&#x27;m not sure how or why. They just seem to take up a lot of space.<p>It doesn&#x27;t look like I can edit anything in the result. For example, I have a lot of &#x27;if(iserror(formula), 0, formula)&#x27;. I don&#x27;t want to see all of that - I just want to see &#x27;formula&#x27;. The rest is an implementation detail.<p>When &#x27;hide detail&#x27; is on, there doesn&#x27;t seem to be a way to jump back to the Excel sheet.<p>I had a more complex sheet I wanted to try it on after this one, but even this medium complexity one was harder to understand (and I wrote it over the last few days, so it&#x27;s still all in my mind) than the original Excel sheet is; so I didn&#x27;t bother with the more complex one.<p>Sorry to rain on your parade, it must have been a lot of work. I don&#x27;t see much added value though in its current form. I&#x27;m sure that with much polishing it can become useful. I think annotations should be first; then abstracting away implementation details of formulas, you have more ideas yourself probably. Slate also loses the spatial relation between e.g. columns next to each other; I&#x27;m not sure what to do about that, but it should make up for that somehow.<p>Lastly, the price is ridiculous at this stage. At first I though &#x27;oh 50$ seems OK, then I saw &#x27;&#x2F;month&#x2F;user&#x27;. $50 one-off seems OK; I don&#x27;t see who will pay 500 a year for this, especially with the basic functionality it has now.<p>Feel free to email me if you want to know more about the spreadsheet I tested it on. I&#x27;d love to be shown what I should look at that would give me more insight in my model; I didn&#x27;t see it myself. A real-world example on your website (as opposed to an Iron Man made up one, which to be honest is quite juvenile) would maybe help, too.<p>Good luck with your product. Please don&#x27;t be discouraged by this - I&#x27;m not trying to put you down, just honestly telling you what my experiences were, as you&#x27;ll get very few reactions from people like me who decide to give up after 10 minutes; while those are exactly the ones you want to hear from to know what to work on.
评论 #8137618 未加载
评论 #8137389 未加载
评论 #8136197 未加载
评论 #8136904 未加载
评论 #8138703 未加载
sean_the_geekalmost 11 years ago
IMHO, the concept is novel. Having worked in BI&#x2F;data analysis fields, I have seen a fair share of large xls files with complex calculations. Can&#x27;t really try now since blocked at work but will definately give it a shot on home pc.
评论 #8136038 未加载
ainlaalmost 11 years ago
It&#x27;s a great idea, but I&#x27;ve been working in multiple enterprise excel hells and most of the places use macros, because the simple stuff just does not allow needed complexity.<p>Now try to visualize that...
评论 #8136119 未加载
jglauchealmost 11 years ago
Looks nice, sadly it&#x27;s not only for Excel and I&#x27;m on Linux, having only LibreOffice or Gnumeric.
评论 #8136854 未加载
f292almost 11 years ago
We&#x27;re the cofounders of Slate. We&#x27;ve just released a stable beta - let us know what you think!
评论 #8136126 未加载
roel_valmost 11 years ago
Preliminary bitching while it&#x27;s downloading: 125mb for an Excel plugin? WTF?
评论 #8136015 未加载
grayclhnalmost 11 years ago
Very minor detail, but numbers should be right aligned &quot;tabular&quot; numbers in your flowcharts. Digits like to be vertically aligned. I&#x27;m on Linux, so I don&#x27;t know if that&#x27;s just an artifact of the example on your homepage or if it&#x27;s baked into the plugin too --- but that goes for the default settings in the plugin too.
heymishyalmost 11 years ago
seems like a really interesting concept, although I do think you might struggle getting that into the enterprise (or even medium&#x2F;large business space) given the heavy installation. Definitely going to see if it helps with me requirements of trying to unpick complex financial models built from spreadsheets.
评论 #8136087 未加载
ahtomskialmost 11 years ago
Have you got anyone in finance actually using this at the moment? I imagine there&#x27;s a pretty high bar to entry in terms of security&#x2F;stability for them to even give a product like this a test drive.
评论 #8136172 未加载
frogpeltalmost 11 years ago
I get:<p><pre><code> Error reading setup initialization file.</code></pre>
eddielee6almost 11 years ago
Fantastic!!