{"id":"https://openalex.org/W7126415841","doi":"https://doi.org/10.18653/v1/2024.findings-eacl.158","title":"NL2Formula: Generating Spreadsheet Formulas from Natural Language Queries","display_name":"NL2Formula: Generating Spreadsheet Formulas from Natural Language Queries","publication_year":2024,"publication_date":"2024-01-01","ids":{"openalex":"https://openalex.org/W7126415841","doi":"https://doi.org/10.18653/v1/2024.findings-eacl.158"},"language":null,"primary_location":{"id":"doi:10.18653/v1/2024.findings-eacl.158","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2024.findings-eacl.158","pdf_url":"https://aclanthology.org/2024.findings-eacl.158.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Findings of the Association for Computational Linguistics: EACL 2024","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://aclanthology.org/2024.findings-eacl.158.pdf","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5124607864","display_name":"Wei Zhao","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wei Zhao","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025165533","display_name":"Zhitao Hou","orcid":"https://orcid.org/0000-0002-5335-748X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhitao Hou","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5124470630","display_name":"Siyuan Wu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Siyuan Wu","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5124557017","display_name":"Yan Gao","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yan Gao","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042086739","display_name":"Haoyu Dong","orcid":"https://orcid.org/0000-0002-5132-0341"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Haoyu Dong","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5124554564","display_name":"Yao Wan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yao Wan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5124532998","display_name":"Hongyu Zhang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hongyu Zhang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006372770","display_name":"Yulei Sui","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yulei Sui","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5124654951","display_name":"Haidong Zhang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Haidong Zhang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":9,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.55530287,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"2377","last_page":"2388"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9381999969482422,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9381999969482422,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13523","display_name":"Mathematics, Computing, and Information Processing","score":0.010599999688565731,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10126","display_name":"Logic, programming, and type systems","score":0.004100000020116568,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.4471000134944916},{"id":"https://openalex.org/keywords/natural","display_name":"Natural (archaeology)","score":0.2948000133037567},{"id":"https://openalex.org/keywords/feature","display_name":"Feature (linguistics)","score":0.26600000262260437},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.23190000653266907}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7110999822616577},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.4471000134944916},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.41920000314712524},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.40220001339912415},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.4016999900341034},{"id":"https://openalex.org/C2776608160","wikidata":"https://www.wikidata.org/wiki/Q4785462","display_name":"Natural (archaeology)","level":2,"score":0.2948000133037567},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.26600000262260437},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.24639999866485596},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.23190000653266907},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.23100000619888306}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.18653/v1/2024.findings-eacl.158","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2024.findings-eacl.158","pdf_url":"https://aclanthology.org/2024.findings-eacl.158.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Findings of the Association for Computational Linguistics: EACL 2024","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.18653/v1/2024.findings-eacl.158","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2024.findings-eacl.158","pdf_url":"https://aclanthology.org/2024.findings-eacl.158.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Findings of the Association for Computational Linguistics: EACL 2024","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.6783343553543091}],"awards":[{"id":"https://openalex.org/G8363725921","display_name":null,"funder_award_id":"62102157","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7126415841.pdf","grobid_xml":"https://content.openalex.org/works/W7126415841.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Writing":[0],"formulas":[1,21,62],"on":[2,22,66],"spreadsheets,":[3],"such":[4],"as":[5,76],"Microsoft":[6],"Excel":[7],"and":[8,27,91,98,154],"Google":[9],"Sheets,":[10],"is":[11],"a":[12,25,50,67,71,82,110],"widespread":[13],"practice":[14],"among":[15],"users":[16],"performing":[17],"data":[18],"analysis.However,":[19],"crafting":[20],"spreadsheets":[23],"remains":[24],"tedious":[26],"error-prone":[28],"task":[29,53,107,153],"for":[30,156],"many":[31],"end-users,":[32],"particularly":[33],"when":[34],"dealing":[35],"with":[36,43,56,138],"complex":[37],"operations.To":[38],"alleviate":[39],"the":[40,57,105,119,130,151],"burden":[41],"associated":[42],"writing":[44],"spreadsheet":[45,68,93],"formulas,":[46,94],"this":[47],"paper":[48],"introduces":[49],"novel":[51],"benchmark":[52],"called":[54,114],"NL2FORMULA,":[55],"aim":[58],"to":[59,129],"generate":[60],"executable":[61],"that":[63],"are":[64],"grounded":[65],"table,":[69],"given":[70],"Natural":[72],"Language":[73],"(NL)":[74],"query":[75],"input.To":[77],"accomplish":[78],"this,":[79],"we":[80,133,146],"construct":[81],"comprehensive":[83],"dataset":[84],"consisting":[85],"of":[86,101,121],"70,799":[87],"paired":[88],"NL":[89],"queries":[90],"corresponding":[92],"covering":[95],"21,670":[96],"tables":[97],"37":[99],"types":[100],"formula":[102],"functions.We":[103],"realize":[104],"NL2FORMULA":[106,152],"by":[108],"providing":[109],"sequence-to-sequence":[111],"baseline":[112,131],"implementation":[113],"f":[115,122,136],"CODER.Experimental":[116],"results":[117],"validate":[118],"effectiveness":[120],"CODER,":[123],"demonstrating":[124],"its":[125],"superior":[126],"performance":[127],"compared":[128],"models.Furthermore,":[132],"also":[134],"compare":[135],"CODER":[137],"an":[139],"initial":[140],".Lastly,":[141],"through":[142],"indepth":[143],"error":[144],"analysis,":[145],"identify":[147],"potential":[148],"challenges":[149],"in":[150],"advocate":[155],"further":[157],"investigation.":[158]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2026-02-02T00:00:00"}