A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2011; you can also visit <a rel="external noopener" href="http://www.mit.edu:80/~ebakke/research/related_worksheets_chi2011.pdf">the original URL</a>. The file type is <code>application/pdf</code>.
A spreadsheet-based user interface for managing plural relationships in structured data
<span title="">2011</span>
<i title="ACM Press">
<a target="_blank" rel="noopener" href="https://fatcat.wiki/container/4obeqfuqs5gzbos5ah64a7m57a" style="color: black;">Proceedings of the 2011 annual conference on Human factors in computing systems - CHI '11</a>
</i>
Preserved Fulltext
A key feature of relational database applications is managing plural relationships-one-to-many and many-to-manybetween entities. However, since it is often infeasible to adopt or develop a new database application for any given schema at hand, information workers instead turn to spreadsheets, which lend themselves poorly to schemas requiring multiple related entity sets. In this paper, we propose to reduce the cost-usability gap between spreadsheets and tailor-made relational database
<span class="external-identifiers">
<a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1978942.1979313">doi:10.1145/1978942.1979313</a>
<a target="_blank" rel="external noopener" href="https://dblp.org/rec/conf/chi/BakkeKM11.html">dblp:conf/chi/BakkeKM11</a>
<a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/7npv5ddmn5azrlbxu6no2vjxtm">fatcat:7npv5ddmn5azrlbxu6no2vjxtm</a>
</span>
more »
... ns by extending the spreadsheet paradigm to let the user establish relationships between rows in related worksheets as well as view and navigate the hierarchical cell structure that arises as a result. We present Related Worksheets, a spreadsheet-like prototype application, and evaluate it with a screencast-based user study on 36 Mechanical Turk workers. First-time users of our software were able to solve lookup-type query tasks with the same or higher accuracy as subjects using Microsoft Excel, in one case 40% faster on average.
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20110601124340/http://www.mit.edu:80/~ebakke/research/related_worksheets_chi2011.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext">
<button class="ui simple right pointing dropdown compact black labeled icon button serp-button">
<i class="icon ia-icon"></i>
Web Archive
[PDF]
<div class="menu fulltext-thumbnail">
<img src="https://blobs.fatcat.wiki/thumbnail/pdf/99/bc/99bc4f273204b6e49ba3186418b8562dda13a530.180px.jpg" alt="fulltext thumbnail" loading="lazy">
</div>
</button>
</a>
<a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1978942.1979313">
<button class="ui left aligned compact blue labeled icon button serp-button">
<i class="external alternate icon"></i>
acm.org
</button>
</a>