{"id":"https://openalex.org/W2107686020","doi":"https://doi.org/10.1145/1140335.1140346","title":"Type inference for spreadsheets","display_name":"Type inference for spreadsheets","publication_year":2006,"publication_date":"2006-07-10","ids":{"openalex":"https://openalex.org/W2107686020","doi":"https://doi.org/10.1145/1140335.1140346","mag":"2107686020"},"language":"en","primary_location":{"id":"doi:10.1145/1140335.1140346","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1140335.1140346","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 8th ACM SIGPLAN international conference on Principles and practice of declarative programming","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5028532226","display_name":"Robin Abraham","orcid":"https://orcid.org/0000-0003-1915-8118"},"institutions":[{"id":"https://openalex.org/I131249849","display_name":"Oregon State University","ror":"https://ror.org/00ysfqy60","country_code":"US","type":"education","lineage":["https://openalex.org/I131249849"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Robin Abraham","raw_affiliation_strings":["Oregon State University","Oregon State University>"],"affiliations":[{"raw_affiliation_string":"Oregon State University","institution_ids":["https://openalex.org/I131249849"]},{"raw_affiliation_string":"Oregon State University>","institution_ids":["https://openalex.org/I131249849"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5078733350","display_name":"Martin Erwig","orcid":"https://orcid.org/0000-0002-7471-4554"},"institutions":[{"id":"https://openalex.org/I131249849","display_name":"Oregon State University","ror":"https://ror.org/00ysfqy60","country_code":"US","type":"education","lineage":["https://openalex.org/I131249849"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Martin Erwig","raw_affiliation_strings":["Oregon State University","Oregon State University>"],"affiliations":[{"raw_affiliation_string":"Oregon State University","institution_ids":["https://openalex.org/I131249849"]},{"raw_affiliation_string":"Oregon State University>","institution_ids":["https://openalex.org/I131249849"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5028532226"],"corresponding_institution_ids":["https://openalex.org/I131249849"],"apc_list":null,"apc_paid":null,"fwci":2.9117,"has_fulltext":false,"cited_by_count":30,"citation_normalized_percentile":{"value":0.91152163,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"73","last_page":"84"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":1.0,"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":1.0,"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/T11875","display_name":"Statistics Education and Methodologies","score":0.948199987411499,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9041000008583069,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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/computer-science","display_name":"Computer science","score":0.84627366065979},{"id":"https://openalex.org/keywords/type-inference","display_name":"Type inference","score":0.8156541585922241},{"id":"https://openalex.org/keywords/inference","display_name":"Inference","score":0.6847809553146362},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.6190420389175415},{"id":"https://openalex.org/keywords/declarative-programming","display_name":"Declarative programming","score":0.45368990302085876},{"id":"https://openalex.org/keywords/programming-paradigm","display_name":"Programming paradigm","score":0.4530848562717438},{"id":"https://openalex.org/keywords/procedural-programming","display_name":"Procedural programming","score":0.4336743950843811},{"id":"https://openalex.org/keywords/inductive-programming","display_name":"Inductive programming","score":0.3964202404022217},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.35519325733184814},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3135039210319519}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.84627366065979},{"id":"https://openalex.org/C198370458","wikidata":"https://www.wikidata.org/wiki/Q586459","display_name":"Type inference","level":3,"score":0.8156541585922241},{"id":"https://openalex.org/C2776214188","wikidata":"https://www.wikidata.org/wiki/Q408386","display_name":"Inference","level":2,"score":0.6847809553146362},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6190420389175415},{"id":"https://openalex.org/C146206909","wikidata":"https://www.wikidata.org/wiki/Q531152","display_name":"Declarative programming","level":4,"score":0.45368990302085876},{"id":"https://openalex.org/C34165917","wikidata":"https://www.wikidata.org/wiki/Q188267","display_name":"Programming paradigm","level":2,"score":0.4530848562717438},{"id":"https://openalex.org/C120558287","wikidata":"https://www.wikidata.org/wiki/Q1418502","display_name":"Procedural programming","level":4,"score":0.4336743950843811},{"id":"https://openalex.org/C50033165","wikidata":"https://www.wikidata.org/wiki/Q15712089","display_name":"Inductive programming","level":3,"score":0.3964202404022217},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.35519325733184814},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3135039210319519}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1140335.1140346","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1140335.1140346","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 8th ACM SIGPLAN international conference on Principles and practice of declarative programming","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.6600000262260437}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W43120215","https://openalex.org/W93717786","https://openalex.org/W1484482023","https://openalex.org/W1497393863","https://openalex.org/W1497542708","https://openalex.org/W1551326568","https://openalex.org/W1571097741","https://openalex.org/W1578962373","https://openalex.org/W1808011207","https://openalex.org/W1969600276","https://openalex.org/W1970665021","https://openalex.org/W1973994007","https://openalex.org/W1974084458","https://openalex.org/W1996473305","https://openalex.org/W1999504357","https://openalex.org/W2014439598","https://openalex.org/W2034957383","https://openalex.org/W2042031818","https://openalex.org/W2043918190","https://openalex.org/W2058580210","https://openalex.org/W2075811056","https://openalex.org/W2093987194","https://openalex.org/W2095148351","https://openalex.org/W2097864578","https://openalex.org/W2107137616","https://openalex.org/W2109545181","https://openalex.org/W2111469656","https://openalex.org/W2112338634","https://openalex.org/W2119723190","https://openalex.org/W2121840944","https://openalex.org/W2135473121","https://openalex.org/W2138633813","https://openalex.org/W2142181967","https://openalex.org/W2153018767","https://openalex.org/W2159745859","https://openalex.org/W2168075363","https://openalex.org/W2170917596","https://openalex.org/W3122827791","https://openalex.org/W3124066374","https://openalex.org/W4230945824","https://openalex.org/W4231799929","https://openalex.org/W4242277969"],"related_works":["https://openalex.org/W2039406101","https://openalex.org/W1828224469","https://openalex.org/W2161156675","https://openalex.org/W2169841379","https://openalex.org/W2560787608","https://openalex.org/W1644865499","https://openalex.org/W2172209430","https://openalex.org/W4296878212","https://openalex.org/W180441780","https://openalex.org/W2060445097"],"abstract_inverted_index":{"Spreadsheets":[0],"are":[1,12,67],"the":[2,19,30,35,40,101,127,143],"most":[3],"popular":[4],"programming":[5,83,133],"systems":[6,72,94],"in":[7,33,43,79,82,99,135,165],"use":[8],"today.":[9],"Since":[10],"spreadsheets":[11,22,44,66,120],"visual,":[13],"first-order":[14],"functional":[15],"languages,":[16,84],"research":[17],"into":[18],"foundations":[20],"of":[21,37,104],"is":[23,45,87],"therefore":[24,88],"a":[25,76,111,115],"highly":[26],"relevant":[27],"topic":[28],"for":[29,119,155],"principles":[31],"and,":[32],"particular,":[34],"practice,":[36],"declarative":[38],"programming.Since":[39],"error":[41],"rate":[42],"very":[46,68],"high":[47],"and":[48,56,62,85,114,121,126],"since":[49],"those":[50],"errors":[51,64,81,134,164],"have":[52,73],"significant":[53],"impact,":[54],"methods":[55],"tools":[57],"that":[58],"can":[59,131,147,158],"help":[60],"detect":[61],"remove":[63],"from":[65],"much":[69],"needed.":[70],"Type":[71],"traditionally":[74],"played":[75],"strong":[77],"role":[78],"detecting":[80],"it":[86],"reasonable":[89],"to":[90,150,161],"ask":[91],"whether":[92],"type":[93,112,116,144],"could":[95],"not":[96],"be":[97,148,159],"helpful":[98],"improving":[100],"current":[102],"situation":[103],"spreadsheet":[105],"programming.In":[106],"this":[107,124],"paper":[108],"we":[109,139],"introduce":[110],"system":[113],"inference":[117,145],"algorithm":[118,125,146],"demonstrate":[122,141],"how":[123,142],"underlying":[128],"typing":[129],"concept":[130],"identify":[132],"spreadsheets.":[136,166],"In":[137],"addition,":[138],"also":[140],"employed":[149],"infer":[151],"models,":[152],"or":[153],"specifications,":[154],"spreadsheets,":[156],"which":[157],"used":[160],"prevent":[162],"future":[163]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":4}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}