{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T04:30:36Z","timestamp":1750221036950,"version":"3.41.0"},"publisher-location":"New York, NY, USA","reference-count":18,"publisher":"ACM","license":[{"start":{"date-parts":[[2018,10,26]],"date-time":"2018-10-26T00:00:00Z","timestamp":1540512000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"name":"Newton Advanced Fellowship","award":["NAF\\R1\\180142 International Exchange: IE 150982"],"award-info":[{"award-number":["NAF\\R1\\180142 International Exchange: IE 150982"]}]},{"name":"EPSRC grant DAASE","award":["EP\/J017515\/"],"award-info":[{"award-number":["EP\/J017515\/"]}]},{"name":"National Key Research and Development Program of China","award":["No. 2017YFB1001803"],"award-info":[{"award-number":["No. 2017YFB1001803"]}]},{"name":"National Natural Science Foundation of China","award":["61861130363"],"award-info":[{"award-number":["61861130363"]}]}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2018,10,26]]},"DOI":"10.1145\/3236024.3275532","type":"proceedings-article","created":{"date-parts":[[2018,10,29]],"date-time":"2018-10-29T12:06:00Z","timestamp":1540814760000},"page":"833-838","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":7,"title":["Automated refactoring of nested-IF formulae in spreadsheets"],"prefix":"10.1145","author":[{"given":"Jie","family":"Zhang","sequence":"first","affiliation":[{"name":"Peking University, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shi","family":"Han","sequence":"additional","affiliation":[{"name":"Microsoft Research, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Dan","family":"Hao","sequence":"additional","affiliation":[{"name":"Peking University, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Lu","family":"Zhang","sequence":"additional","affiliation":[{"name":"Peking University, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Dongmei","family":"Zhang","sequence":"additional","affiliation":[{"name":"Microsoft Research, China"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2018,10,26]]},"reference":[{"key":"e_1_3_2_1_1_1","unstructured":"wiki. End user development. https:\/\/en.wikipedia.org\/wiki\/End-user_ development 2015.  wiki. End user development. https:\/\/en.wikipedia.org\/wiki\/End-user_ development 2015."},{"key":"e_1_3_2_1_2_1","unstructured":"Margaret M Burnett and Christopher Scaffidi. 10. end-user development.  Margaret M Burnett and Christopher Scaffidi. 10. end-user development."},{"key":"e_1_3_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10664-013-9296-2"},{"key":"e_1_3_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10664-013-9296-2"},{"key":"e_1_3_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSME.2014.33"},{"key":"e_1_3_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1109\/SANER.2016.86"},{"first-page":"414","volume-title":"Proc. ICSE","author":"Tufano Michele","key":"e_1_3_2_1_7_1"},{"key":"e_1_3_2_1_8_1","unstructured":"office. IF function. https:\/\/support.office.com\/en-us\/article\/IF-function-%e2%80% 93-nested-formulas-and-avoiding-pitfalls-0b22ff44-f149-44ba-aeb5-4ef99da241c8? ui=en-US&rs=en-US&ad=US 2015.  office. IF function. https:\/\/support.office.com\/en-us\/article\/IF-function-%e2%80% 93-nested-formulas-and-avoiding-pitfalls-0b22ff44-f149-44ba-aeb5-4ef99da241c8? ui=en-US&rs=en-US&ad=US 2015."},{"first-page":"16","volume-title":"Proc. ICSE","author":"Hermans Felienne","key":"e_1_3_2_1_9_1"},{"key":"e_1_3_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSM.2012.6405299"},{"key":"e_1_3_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/2635868.2661673"},{"key":"e_1_3_2_1_12_1","unstructured":"DJ Hoepelman. Tool-assisted spreadsheet refactoring and parsing spreadsheet formulas. 2015.  DJ Hoepelman. Tool-assisted spreadsheet refactoring and parsing spreadsheet formulas. 2015."},{"key":"e_1_3_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2016.7739679"},{"key":"e_1_3_2_1_14_1","unstructured":"Bas Jansen. Enron versus euses: A comparison of two spreadsheet corpora. arXiv preprint arXiv:1503.04055 2015.  Bas Jansen. Enron versus euses: A comparison of two spreadsheet corpora. arXiv preprint arXiv:1503.04055 2015."},{"key":"e_1_3_2_1_15_1","unstructured":"Thomas Reschenhofer Bernhard Waltl Klym Shumaiev and Florian Matthes. A conceptual model for measuring the complexity of spreadsheets. arXiv preprint arXiv:1704.01147 2017.  Thomas Reschenhofer Bernhard Waltl Klym Shumaiev and Florian Matthes. A conceptual model for measuring the complexity of spreadsheets. arXiv preprint arXiv:1704.01147 2017."},{"key":"e_1_3_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/1082983.1083242"},{"key":"e_1_3_2_1_17_1","unstructured":"Salvatore Aurigemma and Raymond R Panko. The detection of human spreadsheet errors by humans versus inspection (auditing) software. arXiv preprint arXiv:1009.2785 2010.  Salvatore Aurigemma and Raymond R Panko. The detection of human spreadsheet errors by humans versus inspection (auditing) software. arXiv preprint arXiv:1009.2785 2010."},{"key":"e_1_3_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/2950290.2950313"}],"event":{"name":"ESEC\/FSE '18: 26th ACM Joint European Software Engineering Conference and Symposium on the Foundations of Software Engineering","sponsor":["SIGSOFT ACM Special Interest Group on Software Engineering"],"location":"Lake Buena Vista FL USA","acronym":"ESEC\/FSE '18"},"container-title":["Proceedings of the 2018 26th ACM Joint Meeting on European Software Engineering Conference and Symposium on the Foundations of Software Engineering"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3236024.3275532","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3236024.3275532","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T00:43:41Z","timestamp":1750207421000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3236024.3275532"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2018,10,26]]},"references-count":18,"alternative-id":["10.1145\/3236024.3275532","10.1145\/3236024"],"URL":"https:\/\/doi.org\/10.1145\/3236024.3275532","relation":{},"subject":[],"published":{"date-parts":[[2018,10,26]]},"assertion":[{"value":"2018-10-26","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}