{"id":"https://openalex.org/W2042806380","doi":"https://doi.org/10.1145/2815833.2815843","title":"A methodology for constructing the calculation model of scientific spreadsheets","display_name":"A methodology for constructing the calculation model of scientific spreadsheets","publication_year":2015,"publication_date":"2015-09-29","ids":{"openalex":"https://openalex.org/W2042806380","doi":"https://doi.org/10.1145/2815833.2815843","mag":"2042806380"},"language":"en","primary_location":{"id":"doi:10.1145/2815833.2815843","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2815833.2815843","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 International Conference on Knowledge Capture","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://research.vu.nl/en/publications/4f9634ab-dc84-41cc-b0e3-eca9fc5b4846","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5101927253","display_name":"Martine de Vos","orcid":"https://orcid.org/0000-0001-5301-1713"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Martine de Vos","raw_affiliation_strings":["Computer Science Network Institute, VU University Amsterdam, The Netherlands"],"affiliations":[{"raw_affiliation_string":"Computer Science Network Institute, VU University Amsterdam, The Netherlands","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052365388","display_name":"Jan Wielemaker","orcid":"https://orcid.org/0000-0001-5574-5673"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jan Wielemaker","raw_affiliation_strings":["Computer Science Network Institute, VU University Amsterdam, The Netherlands"],"affiliations":[{"raw_affiliation_string":"Computer Science Network Institute, VU University Amsterdam, The Netherlands","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085015384","display_name":"Guus Schreiber","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Guus Schreiber","raw_affiliation_strings":["Computer Science Network Institute, VU University Amsterdam, The Netherlands"],"affiliations":[{"raw_affiliation_string":"Computer Science Network Institute, VU University Amsterdam, The Netherlands","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108074656","display_name":"Bob Wielinga","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bob Wielinga","raw_affiliation_strings":["Computer Science Network Institute, VU University Amsterdam, The Netherlands"],"affiliations":[{"raw_affiliation_string":"Computer Science Network Institute, VU University Amsterdam, The Netherlands","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5040057379","display_name":"J.L. Top","orcid":"https://orcid.org/0000-0001-5630-5880"},"institutions":[{"id":"https://openalex.org/I913481162","display_name":"Wageningen University & Research","ror":"https://ror.org/04qw24q55","country_code":"NL","type":"education","lineage":["https://openalex.org/I913481162"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Jan Top","raw_affiliation_strings":["Wageningen University and Research Centre, Food and Biobased Research, The Netherlands","Wageningen University and Research Centre, Food and Biobased Research, The Netherlands#TAB#"],"affiliations":[{"raw_affiliation_string":"Wageningen University and Research Centre, Food and Biobased Research, The Netherlands","institution_ids":["https://openalex.org/I913481162"]},{"raw_affiliation_string":"Wageningen University and Research Centre, Food and Biobased Research, The Netherlands#TAB#","institution_ids":["https://openalex.org/I913481162"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5101927253"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.6681,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.84645062,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"8"},"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.9998999834060669,"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.9998999834060669,"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.951200008392334,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/workflow","display_name":"Workflow","score":0.8400843143463135},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8053776025772095},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.7630739808082581},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5149756073951721},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.48506417870521545},{"id":"https://openalex.org/keywords/trace","display_name":"TRACE (psycholinguistics)","score":0.4786897301673889},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.4365129768848419},{"id":"https://openalex.org/keywords/dependency-graph","display_name":"Dependency graph","score":0.43158721923828125},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.42208677530288696},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.41541337966918945},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.41492363810539246},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.33787208795547485},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.33208826184272766},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2602572441101074},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2242685854434967}],"concepts":[{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.8400843143463135},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8053776025772095},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.7630739808082581},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5149756073951721},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.48506417870521545},{"id":"https://openalex.org/C75291252","wikidata":"https://www.wikidata.org/wiki/Q1315756","display_name":"TRACE (psycholinguistics)","level":2,"score":0.4786897301673889},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.4365129768848419},{"id":"https://openalex.org/C16311509","wikidata":"https://www.wikidata.org/wiki/Q4148050","display_name":"Dependency graph","level":3,"score":0.43158721923828125},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.42208677530288696},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.41541337966918945},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.41492363810539246},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.33787208795547485},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.33208826184272766},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2602572441101074},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2242685854434967},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/2815833.2815843","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2815833.2815843","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 International Conference on Knowledge Capture","raw_type":"proceedings-article"},{"id":"pmh:oai:research.vu.nl:publications/4f9634ab-dc84-41cc-b0e3-eca9fc5b4846","is_oa":true,"landing_page_url":"https://research.vu.nl/en/publications/4f9634ab-dc84-41cc-b0e3-eca9fc5b4846","pdf_url":"https://research.vu.nl/en/publications/4f9634ab-dc84-41cc-b0e3-eca9fc5b4846","source":{"id":"https://openalex.org/S4306401107","display_name":"VU Research Portal","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I865915315","host_organization_name":"Vrije Universiteit Amsterdam","host_organization_lineage":["https://openalex.org/I865915315"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":"de Vos, M G, Wielemaker, J, Schreiber, A, Wielinga, B J & Top, J L 2015, A methodology for constructing the calculation model of scientific spreadsheets. in Proceedings of the 8th International Conference on Knowledge Capture. ACM, Palisades, NY, International Conference on Knowledge Capture (KCAP), 1/01/15.","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"pmh:oai:library.wur.nl:wurpubs/493751","is_oa":true,"landing_page_url":"https://research.wur.nl/en/publications/a-methodology-for-constructing-the-calculation-model-of-scientifi","pdf_url":null,"source":{"id":"https://openalex.org/S4210201231","display_name":"Socio-Environmental Systems Modeling","issn_l":"2663-3027","issn":["2663-3027"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"Article in monograph or in proceedings"},{"id":"pmh:oai:dare.ubvu.vu.nl:1871/54154","is_oa":false,"landing_page_url":"http://hdl.handle.net/1871/54154","pdf_url":null,"source":{"id":"https://openalex.org/S4306400546","display_name":"Digital Academic REpository of VU University Amsterdam (Vrije Universiteit Amsterdam)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I865915315","host_organization_name":"Vrije Universiteit Amsterdam","host_organization_lineage":["https://openalex.org/I865915315"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings of the 8th International Conference on Knowledge Capture","raw_type":"Article in monograph or in proceedings"}],"best_oa_location":{"id":"pmh:oai:research.vu.nl:publications/4f9634ab-dc84-41cc-b0e3-eca9fc5b4846","is_oa":true,"landing_page_url":"https://research.vu.nl/en/publications/4f9634ab-dc84-41cc-b0e3-eca9fc5b4846","pdf_url":"https://research.vu.nl/en/publications/4f9634ab-dc84-41cc-b0e3-eca9fc5b4846","source":{"id":"https://openalex.org/S4306401107","display_name":"VU Research Portal","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I865915315","host_organization_name":"Vrije Universiteit Amsterdam","host_organization_lineage":["https://openalex.org/I865915315"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":"de Vos, M G, Wielemaker, J, Schreiber, A, Wielinga, B J & Top, J L 2015, A methodology for constructing the calculation model of scientific spreadsheets. in Proceedings of the 8th International Conference on Knowledge Capture. ACM, Palisades, NY, International Conference on Knowledge Capture (KCAP), 1/01/15.","raw_type":"info:eu-repo/semantics/publishedVersion"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/12","display_name":"Responsible consumption and production","score":0.5699999928474426}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2042806380.pdf","grobid_xml":"https://content.openalex.org/works/W2042806380.grobid-xml"},"referenced_works_count":20,"referenced_works":["https://openalex.org/W1489484265","https://openalex.org/W1533980247","https://openalex.org/W1659044373","https://openalex.org/W1970665021","https://openalex.org/W2003710746","https://openalex.org/W2022114557","https://openalex.org/W2031192929","https://openalex.org/W2032969662","https://openalex.org/W2035212488","https://openalex.org/W2095148351","https://openalex.org/W2119896264","https://openalex.org/W2126677287","https://openalex.org/W2126777664","https://openalex.org/W2146736600","https://openalex.org/W2149107096","https://openalex.org/W2169917840","https://openalex.org/W2172240163","https://openalex.org/W2995055431","https://openalex.org/W6629197434","https://openalex.org/W6631891737"],"related_works":["https://openalex.org/W2280422768","https://openalex.org/W3143197806","https://openalex.org/W4252555497","https://openalex.org/W3121175838","https://openalex.org/W3016293053","https://openalex.org/W1690653314","https://openalex.org/W2401723157","https://openalex.org/W2065055572","https://openalex.org/W2784269775","https://openalex.org/W3200266554"],"abstract_inverted_index":{"Spreadsheets":[0],"models":[1,12,40,189],"are":[2,13,46,56,145,204],"frequently":[3],"used":[4],"by":[5,158],"scientists":[6],"to":[7,49,62,140],"analyze":[8],"research":[9,32,54,169],"data.":[10],"These":[11],"typically":[14],"described":[15],"in":[16,38,104,171,197],"a":[17,20,69,78,126,206],"paper":[18,67],"or":[19],"report,":[21],"which":[22],"serves":[23],"as":[24],"single":[25],"source":[26],"of":[27,80,85,112,119,128,165,174,199],"information":[28],"on":[29,117,132,162],"the":[30,35,53,63,74,89,105,113,120,149,172,191],"underlying":[31,64,77],"project.":[33],"As":[34],"calculation":[36,75,150,188,194],"workflow":[37,76],"these":[39,181],"is":[41,88],"not":[42,47,205],"made":[43],"explicit,":[44],"readers":[45],"able":[48],"fully":[50],"understand":[51],"how":[52],"results":[55],"calculated,":[57],"and":[58,97,110,137,154,176,201],"trace":[59],"them":[60],"back":[61],"spreadsheets.":[65,81],"This":[66],"proposes":[68],"methodology":[70,87,157],"for":[71,147],"semi-automatically":[72],"deriving":[73],"set":[79,127],"The":[82],"starting":[83],"point":[84],"our":[86,156,186],"cell":[90],"dependency":[91],"graph,":[92],"representing":[93],"all":[94,102],"spreadsheet":[95,133],"cells":[96,103],"connections.":[98],"We":[99,152],"automatically":[100],"aggregate":[101],"graph":[106],"that":[107,144,185],"represent":[108],"instances":[109],"duplicates":[111],"same":[114],"quantities,":[115,143],"based":[116],"analysis":[118],"formula":[121],"syntax.":[122],"Subsequently,":[123],"we":[124],"use":[125],"heuristics,":[129],"incorporating":[130],"knowledge":[131],"design,":[134],"computational":[135],"procedures":[136],"domain":[138],"knowledge,":[139],"select":[141],"those":[142],"relevant":[146],"understanding":[148],"workflow.":[151],"explain":[153],"illustrate":[155],"actually":[159],"applying":[160],"it":[161],"three":[163],"sets":[164],"spreadsheets":[166],"from":[167,180],"existing":[168],"projects":[170],"domains":[173],"environmental":[175],"life":[177],"science.":[178],"Results":[179],"case":[182],"studies":[183],"show":[184],"constructed":[187],"approximate":[190],"ground":[192],"truth":[193],"workflows,":[195],"both":[196],"terms":[198],"content":[200],"size,":[202],"but":[203],"perfect":[207],"match.":[208]},"counts_by_year":[{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}