{"id":"https://openalex.org/W368057805","doi":null,"title":"INTRODUCING CONDITIONAL ARRAY FORMULAS IN SPREADSHEET CLASSES","display_name":"INTRODUCING CONDITIONAL ARRAY FORMULAS IN SPREADSHEET CLASSES","publication_year":2012,"publication_date":"2012-01-01","ids":{"openalex":"https://openalex.org/W368057805","mag":"368057805"},"language":"en","primary_location":{"id":"pmh:oai:ganymedesd.lib.unideb.hu:2437/166354","doi":null,"is_oa":false,"landing_page_url":"http://hdl.handle.net/2437/166354","pdf_url":null,"source":{"id":"https://openalex.org/S4306402089","display_name":"University of Debrecen Electronic Archive (University of Debrecen)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I132735039","host_organization_name":"University of Debrecen","host_organization_lineage":["https://openalex.org/I132735039"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"k\u00f6nyvr\u00e9szlet"},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"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/A5023897041","display_name":"M\u00e1ria Csernoch","orcid":"https://orcid.org/0000-0002-7088-7714","observed_orcids":["https://orcid.org/0000-0002-7088-7714"]},"institutions":[{"id":"https://openalex.org/I132735039","display_name":"University of Debrecen","ror":"https://ror.org/02xf66n48","country_code":"HU","type":"education","lineage":["https://openalex.org/I132735039"]}],"countries":["HU"],"is_corresponding":true,"raw_author_name":"M\u00e1ria Csernoch","raw_affiliation_strings":["University of Debrecen;"],"raw_orcid":"https://orcid.org/0000-0002-7088-7714","affiliations":[{"raw_affiliation_string":"University of Debrecen;","institution_ids":["https://openalex.org/I132735039"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5023897041"],"corresponding_institution_ids":["https://openalex.org/I132735039"],"apc_list":null,"apc_paid":null,"fwci":4.0141,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.9362028,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"7270","last_page":"7279"},"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/T10533","display_name":"Teaching and Learning Programming","score":0.0,"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"}},{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"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/spreadsheet-errors","display_name":"spreadsheet errors","score":0.6869999766349792},{"id":"https://openalex.org/keywords/spreadsheet-functions","display_name":"spreadsheet functions","score":0.6000000238418579},{"id":"https://openalex.org/keywords/conditional-functions","display_name":"conditional functions","score":0.6769999861717224},{"id":"https://openalex.org/keywords/secondary-school-students","display_name":"high school students","score":0.6729999780654907},{"id":"https://openalex.org/keywords/college-students","display_name":"university students","score":0.9980000257492065}],"concepts":[{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.6597062349319458},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6322156190872192},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.45260941982269287},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.37692880630493164},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.36733901500701904}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:ganymedesd.lib.unideb.hu:2437/166354","doi":null,"is_oa":false,"landing_page_url":"http://hdl.handle.net/2437/166354","pdf_url":null,"source":{"id":"https://openalex.org/S4306402089","display_name":"University of Debrecen Electronic Archive (University of Debrecen)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I132735039","host_organization_name":"University of Debrecen","host_organization_lineage":["https://openalex.org/I132735039"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"k\u00f6nyvr\u00e9szlet"},{"id":"mag:368057805","doi":null,"is_oa":false,"landing_page_url":"https://library.iated.org/view/CSERNOCH2012INT","pdf_url":null,"source":{"id":"https://openalex.org/S4220651193","display_name":"EDULEARN proceedings","issn_l":"2340-1117","issn":["2340-1117","2340-1125"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-1"],"host_organization":"https://openalex.org/P4310320766","host_organization_name":"International Academy of Technology, Education and Development","host_organization_lineage":["https://openalex.org/P4310320766"],"host_organization_lineage_names":["International Academy of Technology, Education and Development"],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"EDULEARN12 Proceedings","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W196556810","https://openalex.org/W1608596424","https://openalex.org/W1758234765","https://openalex.org/W1976637107","https://openalex.org/W1996473305","https://openalex.org/W2112338634","https://openalex.org/W2116311377"],"related_works":["https://openalex.org/W2889010694","https://openalex.org/W16688517","https://openalex.org/W4310509338","https://openalex.org/W2160322876","https://openalex.org/W7099247078","https://openalex.org/W2710733939","https://openalex.org/W2112360310","https://openalex.org/W2105237266","https://openalex.org/W2154781260","https://openalex.org/W1602297728"],"abstract_inverted_index":{"Reasons":[0],"for":[1,11,20,67],"spreadsheet-errors":[2],"are":[3,17,23,84,145],"many":[4],"folded.":[5],"One":[6,91],"of":[7,36,48,62,92,95,105,123,153,184],"the":[8,31,68,93,103,106,121,129,170,182,185],"main":[9],"reasons":[10],"these":[12,50,77,112,155],"errors":[13],"that":[14,82,169],"spreadsheet":[15],"applications":[16,51],"mainly":[18],"designed":[19],"end-users":[21,70],"who":[22],"not":[24,40,85,142],"specified":[25],"in":[26,100,181],"programming,":[27],"however":[28],"companies":[29],"issuing":[30],"newer":[32,34],"and":[33,60,135,139,163,175],"versions":[35],"their":[37,89,133,137],"programs":[38],"tend":[39],"to":[41,71,147],"take":[42],"into":[43],"consideration":[44],"this":[45],"fact.":[46],"Instead":[47],"making":[49],"more":[52],"\u201cend-user-safe\u201d,":[53],"they":[54,83,144],"introduce":[55],"novel":[56],"functions":[57,80,96,113,125],"with":[58,76,88,114],"names":[59],"lists":[61],"arguments":[63],"which":[64,97],"cause":[65],"difficulties":[66],"non-professional":[69],"apply.":[72],"The":[73,151],"other":[74],"problem":[75],"sprouting":[78],"new":[79,124],"is":[81,102,172],"necessarily":[86],"compatible":[87],"predecessors.":[90],"categories":[94],"keeps":[98],"growing":[99],"size":[101],"set":[104],"built-in":[107],"conditional":[108,115],"functions.":[109],"However,":[110],"substituting":[111],"single-result":[116],"array":[117,156],"formulas":[118,157],"would":[119,127],"make":[120],"introduction":[122],"unnecessary,":[126],"increase":[128],"end-users\u2019":[130],"confidence,":[131],"less":[132],"uncertainty,":[134],"consequently,":[136],"errors,":[138],"last":[140],"but":[141],"least":[143],"proved":[146],"be":[148],"extremely":[149],"flexible.":[150],"method":[152,171],"introducing":[154],"was":[158,179],"tested":[159],"on":[160],"high":[161],"school":[162],"university":[164],"students.":[165],"Results":[166],"clearly":[167],"indicate":[168],"easily":[173],"applicable":[174],"a":[176],"remarkable":[177],"improvement":[178],"detected":[180],"work":[183],"students":[186]},"counts_by_year":[{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2}],"updated_date":"2026-10-31T12:09:11.096373","created_date":"2016-06-24T00:00:00"}