{"id":360434,"date":"2017-02-01T14:41:34","date_gmt":"2017-02-01T22:41:34","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/research\/?post_type=msr-project&#038;p=360434"},"modified":"2017-06-12T09:32:43","modified_gmt":"2017-06-12T16:32:43","slug":"flash-fill-excel-feature-office-2013","status":"publish","type":"msr-project","link":"https:\/\/www.microsoft.com\/en-us\/research\/project\/flash-fill-excel-feature-office-2013\/","title":{"rendered":"Flash Fill (Excel feature in Office 2013)"},"content":{"rendered":"<p>Our programming by example work (<a href=\"https:\/\/www.microsoft.com\/en-us\/research\/publication\/automating-string-processing-spreadsheets-using-input-output-examples\/\">POPL 2011<\/a>), also recognized as CACM Research Highlights (<a href=\"https:\/\/www.microsoft.com\/en-us\/research\/publication\/spreadsheet-data-manipulation-using-examples\/\">CACM 2012<\/a>), ships as part of the Flash Fill feature in Excel in Office 2013. Here&#8217;s a <a href=\"https:\/\/www.microsoft.com\/en-us\/research\/video\/programming-examples-pbe-flash-fill\/\">small video<\/a> illustrating this feature. Here&#8217;s another <a href=\"https:\/\/www.microsoft.com\/en-us\/research\/video\/programming-examples-pbe-flash-fill-extensions\/\">small video<\/a> illustrating potential extensions.<\/p>\n<p>Here&#8217;s the inside story of how it came about: <a href=\"https:\/\/www.microsoft.com\/en-us\/research\/blog\/flash-fill-gives-excel-smart-charge\/\">Flash Fill Gives Excel a Smart Charge<\/a><\/p>\n<h2>Here are some other videos on FlashFill<\/h2>\n<ul type=\"disc\">\n<li>You-tube: <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.youtube.com\/watch?v=qHkgJFJR5cM\">Excel 2013 Flash Fill: 23 Amazing Examples<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.youtube.com\/watch?v=LbK-FfCEBOw\">Excel 2013- Flash Fill<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.youtube.com\/watch?v=ate6GDd1NSk\">Meet new Excel&#8217;s Flash Fill<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/vimeo.com\/56007469\">Dutch video<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.youtube.com\/watch?v=b0rXlnJoqYU\">French Video<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.youtube.com\/watch?v=D2LTzAmyZPk\">German video<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.youtube.com\/watch?v=E81KfTGpmy8\">Japanese video<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.youtube.com\/watch?v=FT6k0kmejBo\">Polish video<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.youtube.com\/watch?v=vCFXxNETanU\">Romanian video<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.youtube.com\/watch?v=TnhJmMvB0iQ\">Urdu video<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.youtube.com\/watch?v=PCddNPHEVg8\">Musical<span class=\"sr-only\"> (opens in new tab)<\/span><\/a><\/li>\n<li>Microsoft: <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.youtube.com\/watch?v=SHKFVUAamQY&t=35m24s\">Rick Rashid on FlashFill<span class=\"sr-only\"> (opens in new tab)<\/span><\/a> (in conversation with John Markoff of New York Times), <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/blogs.office.com\/b\/microsoft-excel\/archive\/2012\/08\/08\/flash-fill.aspx\">Office Blog<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <a href=\"http:\/\/www.microsoft.com\/office\/preview\/en\">Customer Preview Video<\/a> (See the video segment from 0:35-0:40), Peter Lee on FlashFill (in his Keynote Speech on the 14th Computing in the 21st Century Conference &#8211; See the video segment from 22:22-27:20)<\/li>\n<li>CNet: <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/news.cnet.com\/8301-10805_3-57473260-75\/microsofts-jazzed-up-office-to-run-on-tablets-cloud\/\">Microsoft gives new Office a Windows 8 look<span class=\"sr-only\"> (opens in new tab)<\/span><\/a> (This video is at the bottom of the page. See the video segment from 2:00-3:01)<\/li>\n<\/ul>\n<h2>Here is what popular media says about this feature<\/h2>\n<ul type=\"disc\">\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.pcmag.com\/article2\/0,2817,2417132,00.asp\">PC Magazine<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: My favorite new feature, because it saves a tremendous amount of time-wasting effort, is called Flash Fill, and it&#8217;s one of many features where Excel acts as it it&#8217;s using its brain, not just its raw number-crunching power. With some experimentation, you may find that Flash Fill is smarter than you expect.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/cnnmoneytech.tumblr.com\/post\/27346588168\/excel-2013s-coolest-new-feature-that-should-have-been?iid=EL\">CNN Money<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: &#8220;Excel 2013\u2019s coolest new feature that should have been available years ago&#8221;<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.techradar.com\/reviews\/pc-mac\/software\/business-and-finance-software\/office-2013-1089108\/review\/page:3\">Tech Radar <span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: &#8220;If you&#8217;re trying to paste in data from a badly formatted report or an online credit card statement, the new Flash Fill feature is vastly easier than trying to work out how to split data into columns in just the right place. In fact it&#8217;s so good it feels like magic. Paste in the messy data, then start typing the piece of information you want to extract, like the date or the name of the company you made the payment to (without the unwanted details like the business number or foreign currency).&#8221;<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.lifehacker.com.au\/2012\/07\/excel-flash-fill-is-a-brilliant-time-saver\/\">Life Hacker Australia<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: &#8220;Excel Flash Fill Is A Brilliant Time Saver&#8221;<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.pcpro.co.uk\/blogs\/2012\/07\/17\/microsoft-excel-2013-review-first-look\/\">PC Pro<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: Simply type your intended target text in the next field, hit the Flash Fill button on the Data Ribbon, and Excel will complete the job for you, splitting out the text all down the appropriate column. Genius.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.newsignature.com\/blog\/2012\/07\/25\/excel-2013-flash-fill-pattern-recognition\/\">New Signature<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: Excel may not seem like the most exciting part of the recent Office 2013 Preview, but one of the new features is quite clever, and is worth a second look.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/arstechnica.com\/information-technology\/2012\/07\/first-look-excel-2013\/\">Ars Technica<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: If you work with comma-separated data or other bulk-imported information in Excel\u2014for example, Web analytics logs or server error logs or (heaven forbid) columnar format mainframe reports in text form\u2014you probably spend a lot of time trying to extract bits of data stuck together with odd separators to get them into separate columns for analysis. Apparently, Microsoft&#8217;s Excel team heard about this. One of the shock-and-awe features of the Excel 2013 demo was the &#8220;flash fill&#8221; feature. This is a piece of background logic that watches what you&#8217;re putting into cells in a column and looks for patterns. If it recognizes the data as being extracted from text in an adjacent cell, it will automatically &#8220;ghost&#8221; the rest of the matching content into the column as you type<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.bighungrygeek.com\/2012\/10\/18\/excel-2013-flash-fill\/\">Big Hungry Geek<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: I\u2019ve been playing around with the Excel 2013 preview, and damn. It\u2019s nice.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.sociableblog.com\/2012\/10\/25\/know-about-microsoft-office-2013\/\">Sociable Blog<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: Flash Fill Kiss formulas and macros goodbye, and say hello to Flash Fill. This new feature is the current buzz among Excel power users. From just one keyboard shortcut (CTRL+E), it learns your first move and fills in the rest of the data in the same way.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/timesofindia.indiatimes.com\/tech\/itslideshow\/15015129.cms\">Times Of India<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: Apart from the Metro interface and tight integration with Sky Drive, different programs part of Office 2013 have received some minor but useful features. The most notable feature in Excel is Flash fill. It reformats data automatically based on how you use Excel 2013 and auto-completes the remaining entries without needing a formula. Microsoft gives an example of a list that contains email ids with a pattern of firstname.lastname. Once a user fills two or three email ids, the others are prepared by Flash fill and the blank slots in front of the each name are automatically populated.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.iotechie.com\/2012\/07\/office-2013-cloud-subscriptions-metro-flair-and-touch-improvements\/\">IoTechie<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: &#8220;Flash fill is perhaps one of the biggest improvements to make Excel easier. The option will reformat and rearrange data automatically based on your own use of Excel 2013 and auto-complete remaining data with no formulas or macros required&#8221;<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.crn.com\/news\/applications-os\/240003799\/two-thumbs-up-office-2013-enhanced-for-tablets-thumb-control.htm?pgno=3\">CRN<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: For those who have done a fair amount of importing into Excel, you&#8217;ve undoubtedly had at least one encounter with the dreaded conundrum of having all the data go into a single column. Now, a feature in Excel 2013 called Flash Fill takes care of that. As you manually correct the import, moving it piece-by-piece into separate columns, this impressive feature observes your activity and offers to finish the job for you. That&#8217;s right. Excel 2013 moves data that was incorrectly placed into a single column and automatically moves it to multiple columns. In fact, Flash Fill recognizes any repetitive behavior pattern and offers to replicate it without macros or scripts.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.zdnet.com\/office-2013-a-pleasant-surprise_p2-7000000968\/\">ZDNet<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: &#8220;One of the more useful features is Flash Fill, a technique that automatically formats pasted and manually entered data. If you&#8217;re adding data to a column, but haven&#8217;t explicitly used data formatting, Flash Fill will interpret your choices and automatically apply an appropriate format to additional content&#8221;<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.techspot.com\/news\/49415-microsoft-announces-cloud-based-office-365.html\">TechSpot<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: \u201cExcel&#8217;s particularly noteworthy new feature includes the new &#8220;Flash Fill&#8221; tool, which automatically separates data pasted from sites into separate columns\u201d<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.pcworld.com\/businesscenter\/article\/259260\/microsoft_office_2013_preview_hands_on.html\">PC World<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: Microsoft has added several new whiz-bang data-analysis tools, including one called Flash Fill. When you take an element of data that you&#8217;ve already entered in one column and enter it in a second column, Flash Fill will predict that you intend to do that for every value in the second column, and will offer to fill in the second column for you accordingly.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/win8review.com\/2012\/07\/excel-2013-hands-on-review\/\">Win8 Review: <span class=\"sr-only\"> (opens in new tab)<\/span><\/a>The new Flash Fill feature will likely be of interest to just about anybody using this program. Excel now keeps track of what is present in your spreadsheet already and tries to help out when it sees you filling in data using a pattern it sees in place elsewhere. The pattern analysis is quite accurate and will save a great deal of time in breaking fields apart or copying chains of information. To Flash Fill the column you\u2019re working on, just select this option from the pull down Fill button on the Home ribbon.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.pchelps.com\/2013\/03\/quick-look-excel-2013s-flash-fill-feature\/\">pchelps: <span class=\"sr-only\"> (opens in new tab)<\/span><\/a>Quick Look: Excel 2013\u2019s Flash Fill Feature<br \/>\nThis feature is on every tech journalist\u2019s favorite Excel 2013 features list, and it\u2019s no wonder.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.pchelpsblog.com\/2012\/07\/a-dozen-things-you-should-know-about-office-2013\/\">pchelps blog: <span class=\"sr-only\"> (opens in new tab)<\/span><\/a>A Dozen Things You Should Know About Office 2013<br \/>\nExcel\u2019s new Flash Fill feature is getting ample buzz. No wonder: It automates processes such as splitting first and last name that used to require multiple steps using Text to Columns and\/or lengthy nested formulas.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.wired.com\/gadgetlab\/2012\/07\/first-look-at-microsoft-office-2013-and-office-365-going-to-the-cloud\/2\/\">Wired<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: Excel is now a lot easier for people who aren\u2019t spreadsheet- and chart-making pros. The application\u2019s new Flash Fill feature recognizes patterns, and will offer auto-complete options for your data. For example, if you have a column of first names and a column of last names, and want to create a new column of initials, you\u2019ll only need to type in the first few boxes before Excel recognizes what you\u2019re doing and lets you press Enter to complete the rest of the column.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/slideshow.techworld.com\/3372966\/5-hot-features-of-microsoft-office-2013\/5\/\">TechWorld:<span class=\"sr-only\"> (opens in new tab)<\/span><\/a> 5 hot features of Microsoft Office 2013<br \/>\nIntroducing&#8230; Excel Flash Fill<br \/>\nWhen downloading data to a spreadsheet, often it arrives with multiple pieces of information per cell that needs to be sorted out. With a new feature called Flash Fill, Excel figures out what information users are trying to pull into a separate column and automatically fills up a new column with that data. So if the task is to create a column of first names from a column of email addresses with the format firstname.lastname@business.com, users would type in the first name of the top address in a new column, then the second name and then Excel would fill out the rest of the new column with the rest of the first names, saving the bulk of the manual transcription.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/www.computerworlduk.com\/slideshow\/applications\/3406335\/office-2013--ten-best-features-according-to-microsoft\/9\/\">Computer World UK<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: &#8220;Office 2013 &#8211; Ten best features, according to Microsoft&#8221;<br \/>\nDress up your Excel data: New Flash Fill reformatting in Excel makes rearranging data much easier<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/seattletimes.nwsource.com\/html\/technologybrierdudleysblog\/2018702913_cool_new_tricks_in_office_2013.html\">Seattle Times<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: 10 cool new tricks in Office 15<\/li>\n<\/ul>\n<h2>Here is what some blogs says about this feature<\/h2>\n<ul type=\"disc\">\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/blog.computationalcomplexity.org\/2012\/12\/flash-fill.html\">Computational Complexity Blog<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: Sometimes it just takes a simple new feature in a popular piece of software to remind us how computer science just does cool stuff.<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/blogs.softchoice.com\/microsoftnavigator\/2013\/02\/08\/big-improvements-hidden-in-plain-sight-with-excel-2013\/\">Big Improvements Hidden in Plain Sight with Excel 2013<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>: This is by far my favorite, yet subtle, improvement in Excel 2013<\/li>\n<li><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"http:\/\/blog.jonudell.net\/2013\/02\/18\/flash-fill-text-wrangling-for-non-programmers\/\">Flash Fill: Text wrangling for non-programmers<span class=\"sr-only\"> (opens in new tab)<\/span><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Our programming by example work (POPL 2011), also recognized as CACM Research Highlights (CACM 2012), ships as part of the Flash Fill feature in Excel in Office 2013. Here&#8217;s a small video illustrating this feature. Here&#8217;s another small video illustrating potential extensions. Here&#8217;s the inside story of how it came about: Flash Fill Gives Excel [&hellip;]<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"msr-url-field":"","msr-podcast-episode":"","msrModifiedDate":"","msrModifiedDateEnabled":false,"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"research-area":[13560],"msr-locale":[268875],"msr-impact-theme":[],"msr-pillar":[],"class_list":["post-360434","msr-project","type-msr-project","status-publish","hentry","msr-research-area-programming-languages-software-engineering","msr-locale-en_us","msr-archive-status-active"],"msr_project_start":"2012-01-01","related-publications":[],"related-downloads":[],"related-videos":[189000,359486,359489,875508],"related-groups":[],"related-events":[],"related-opportunities":[],"related-posts":[620838],"related-articles":[],"tab-content":[],"slides":[],"related-researchers":[{"type":"user_nicename","value":"sumitg","display_name":"Sumit Gulwani","author_link":"<a href=\"https:\/\/www.microsoft.com\/en-us\/research\/people\/sumitg\/\" aria-label=\"Visit the profile page for Sumit Gulwani\">Sumit Gulwani<\/a>","is_active":false,"user_id":33755,"last_first":"Gulwani, Sumit","people_section":0,"alias":"sumitg"}],"msr_research_lab":[],"msr_impact_theme":[],"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/360434","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":1,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/360434\/revisions"}],"predecessor-version":[{"id":360443,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/360434\/revisions\/360443"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=360434"}],"wp:term":[{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=360434"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=360434"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=360434"},{"taxonomy":"msr-pillar","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-pillar?post=360434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}