6 ms·
Raw: the missing link between spreadsheets and vector graphics
- zekenie 13y agoLooks really neat! Any plans for more data formats other than csv? Also, service is down... must be all that hn traffic :)
- ksrm 13y ago"Dendogram" should be dendrogram.
- nonchalance 13y agoFatal error: Out of memory (allocated 1048576) (tried to allocate 12288 bytes) in /var/www/raw.densitydesign.org/public/wp-includes/option.php on line 553
- gfosco 13y agoI suggest making the landing page a bit more clear... I sat there looking at the single sentence thinking, "What?" It's not so much a missing link between anything, as it is a way to create visualizations from your spreadsheet data, if you feel comfortable enough to paste it on a random website.
- bradleyland 13y agoI felt similar confusion when I read that slug. "Create visualizations from your spreadsheet data" That's what this does. The "missing link" cliché didn't score any points with me, but the product looks extremely cool. One other point of feedback, I clicked the "How it works" link, and when the page scrolled down, the animation was already on step 4, but that text is small, so I didn't realize I was watching the last step. I was a bit confused. Maybe consider using a scroll position detection library to hold the animation until the user has it in view, or use something more clear to indicate which step is being illustrated: [1] 2 3 4 1 [2] 3 4 1 2 [3] 4 1 2 3 [4]
- teamonkey 13y agoFor me the missing link would be a clean way of getting Excel data into a format that could be read by my D3 scripts without needing custom macros, exporting to Excel's flaky CSV format and a manual reload at the end. Writing the graph code is the FUN bit.
- kfk 13y agoWhy are you using Excel and not .txt or .csv directly?
- bazzargh 13y agoOne good reason would be (as he says) that it is flaky. eg how does it handle newlines, commas, tabs and non-ascii characters in data? I've had to pull dirty data between systems before, and csv as the lowest common denominator tends to be lossy as there's no spec on this stuff. Some systems (eg oracle's csv import) do support forms of escaping, but they're not interoperable. I see they support other file formats & json here, but a nice to have would be to use the google spreadsheet url: https://developers.google.com/chart/interactive/docs/spreadsheets#Google_Spreadsheets_as_a_Data_Source https://developers.google.com/chart/interactive/docs/spreads... Grabbing data directly from Office365 is also possible: http://cwebbbi.wordpress.com/2012/07/24/consuming-odata-feeds-from-excel-services-2013-in-powerpivot/ http://cwebbbi.wordpress.com/2012/07/24/consuming-odata-feed...
- teamonkey 13y agoThe worst thing is that I work in a bilingual office. Excel's export to CSV does not work as intended when you have more than one number format.
- teamonkey 13y agoI mean that I want to use Excel as a spreadsheet and use its contents to drive a D3 diagram without the current hassle of getting the data out of Excel into a format that D3 can read cleanly (and continuously - if I update the spreadsheet, the diagram should also update).
- danmaz74 13y agoAbsolutely. There is also no clue that the page should be scrolled down. And the video tutorial should be featured on the landing page.
- OliverM 13y agoMy startup's in a similar space: http://getbulb.com http://getbulb.com (beta is invite only for the next couple of weeks, but if you're curious and want a go, fire an email asking to info@getbulb.com, free to use currently) I adore Density Design's work, and some of it was inspiration for what I'm doing now, so seeing this kind of thing is both validating & scary!
- joliv 13y agoAnyone else getting a 503 error when trying to access the service?
- shortstuffsushi 13y agoYou know what's really crazy about this project? They have two guys named giorgio, on a four man team. But seriously, this project looks pretty cool. It's an interest way to create quick visuals without writing any code.
- danmaz74 13y agoGiorgio is a pretty common name in Italy, where the team is :)
- shortstuffsushi 13y agoInteresting. I figured if I did a bit of research, I might find something like that to be the case.
- TallboyOne 13y agoHow did you make that really cool animation on the homepage? I have been attempting to do this myself with javascript setTimeout mixed with css3 animation but its freakin awful, because it's one just massive callback inside a callback. it must be indented like 60 times near the end of my animation.
- paultannenbaum 13y agoTo handle the callback pyramid of doom, look into javascript promises. Another option is using a timeline based tool like Sencha's Animator: http://www.sencha.com/products/animator http://www.sencha.com/products/animator
- kika 13y agomaybe https://github.com/caolan/async https://github.com/caolan/async is the answer?
- chadyj 13y agoA very high tech animated gif.
- chadyj 13y agoThis is fantastic! I simply created 3 graphs based on email client data featuring a dendogram, circular dendogram, and circular packing. It charts the relationship of OS, device type, email client type, and client name. http://minus.com/m5VsIg2QvP2R3 http://minus.com/m5VsIg2QvP2R3
- kfk 13y agoNice. But the biggest problem of spreadsheets is sharing and organizing data between multiple users, think github for spreadsheets. These visualizations are very good, but they are not a "hair on fire" kind of problem for most of the spreadsheets users.
- Pinatubo 13y agoSite is down now, so I'll check it out later. Is this kind of a plug-and-play version of d3.js?
- zalew 13y agoNice project, but the name is terrible IMO, in terms of being overly generic and possibly ungooglable - it's painful enough to sort out crap when looking for RAW image troubleshooting.
- carlob 13y agoHi from Italy, nice job! To be a little nitpicky: why did you start with obscure high-dimensional visualizations such as alluvial plots, dendrograms, sphere packings? I believe there is much value in the classics: bar charts, histograms, scatter plots; one should only move to more complex visualizations if there is absolutely no way to use a simple one.