{"id":816211,"date":"2022-01-27T18:35:28","date_gmt":"2022-01-28T02:35:28","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/research\/?post_type=msr-project&p=816211"},"modified":"2022-03-10T01:03:23","modified_gmt":"2022-03-10T09:03:23","slug":"gridbook","status":"publish","type":"msr-project","link":"https:\/\/www.microsoft.com\/en-us\/research\/project\/gridbook\/","title":{"rendered":"GridBook"},"content":{"rendered":"
\n\t
\n\t\t
\n\t\t\t\"GridBook\t\t<\/div>\n\t\t\n\t\t
\n\t\t\t\n\t\t\t
\n\t\t\t\t\n\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\n

GridBook<\/h1>\n\n\n\n

Natural Language Formulas for the Spreadsheet Grid<\/p>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/section>\n\n\n\n\n\n

Writing formulas on the spreadsheet grid is arguably the most widely practiced form of programming. Still, studies highlight the difficulties experienced by end-user programmers when learning and using traditional formulas, especially for slightly complex tasks. The purpose of GridBook is to ease these difficulties by supporting formulas expressed in natural language within the grid; it is the first system to do so. GridBook builds on a parser utilizing deep learning to understand analysis intents from the natural language input within a spreadsheet cell. GridBook also leverages the spatial context between cells to infer the analysis parameters underspecified in the natural language input. Natural language enables users to analyze data easily and flexibly, to build queries on the results of previous analyses, and to view results intelligibly within the grid\u2014thus taking spreadsheets one step closer to computational notebooks. Our comparative lab study with 20 experienced data analysts, new only to GridBook, shows that data analysis with GridBook is significantly faster on average than with computational notebooks, and no slower than with conventional spreadsheets. Our study uncovers insights into the application of natural language as a special purpose programming language for end-user programming in spreadsheets.<\/p>\n\n\n\n

A web implementation of GridBook is available to try at: https:\/\/microsoft.github.io\/gridbook\/ (opens in new tab)<\/span><\/a><\/p>\n\n\n\n

\"table\"
The GridBook Interface
Section (1) shows the data table.
Section (2) shows progressive exploration of data, column wise.
Section (3) shows a complex query returning multiple columns of results.
Section (4) demonstrates progressive exploration where a query takes its previous query as context. (a) \u2013 (f) are NL formulas.<\/figcaption><\/figure>\n\n\n\n

<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"

Natural Language Formulas for the Spreadsheet Grid Writing formulas on the spreadsheet grid is arguably the most widely practiced form of programming. Still, studies highlight the difficulties experienced by end-user programmers when learning and using traditional formulas, especially for slightly complex tasks. The purpose of GridBook is to ease these difficulties by supporting formulas expressed […]<\/p>\n","protected":false},"featured_media":816292,"template":"","meta":{"msr-url-field":"","msr-podcast-episode":"","msrModifiedDate":"","msrModifiedDateEnabled":false,"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"research-area":[13563,13545,13560],"msr-locale":[268875],"msr-impact-theme":[],"msr-pillar":[],"class_list":["post-816211","msr-project","type-msr-project","status-publish","has-post-thumbnail","hentry","msr-research-area-data-platform-analytics","msr-research-area-human-language-technologies","msr-research-area-programming-languages-software-engineering","msr-locale-en_us","msr-archive-status-active"],"msr_project_start":"","related-publications":[841702],"related-downloads":[],"related-videos":[],"related-groups":[],"related-events":[],"related-opportunities":[],"related-posts":[],"related-articles":[],"tab-content":[],"slides":[],"related-researchers":[{"type":"guest","display_name":"Sruti Srinivasa Ragavan","user_id":814216,"people_section":"Section name 0","alias":""},{"type":"user_nicename","display_name":"Zhitao Hou","user_id":35124,"people_section":"Section name 0","alias":"zhith"},{"type":"user_nicename","display_name":"Yun Wang","user_id":37827,"people_section":"Section name 0","alias":"wangyun"},{"type":"user_nicename","display_name":"Haidong Zhang","user_id":31953,"people_section":"Section name 0","alias":"haizhang"},{"type":"user_nicename","display_name":"Dongmei Zhang","user_id":31665,"people_section":"Section name 0","alias":"dongmeiz"}],"msr_research_lab":[199560,199561],"msr_impact_theme":[],"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/816211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/types\/msr-project"}],"version-history":[{"count":17,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/816211\/revisions"}],"predecessor-version":[{"id":825238,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/816211\/revisions\/825238"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media\/816292"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=816211"}],"wp:term":[{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=816211"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=816211"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=816211"},{"taxonomy":"msr-pillar","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-pillar?post=816211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}