Matches in SemOpenAlex for { <https://semopenalex.org/work/W2057960458> ?p ?o ?g. }
Showing items 1 to 70 of
70
with 100 items per page.
- W2057960458 endingPage "474" @default.
- W2057960458 startingPage "469" @default.
- W2057960458 abstract "Electronic spreadsheets play an indispensable role in the simulation, modeling, and analysis of bioenergy systems, and their results have the ability to affect decision-making significantly. Prior research has shown that spreadsheets are highly error-prone, and that a large percentage of these errors are difficult to detect. To that end, we developed computer code (implemented in Visual Basic for Applications, running under Microsoft Excel) to detect a particularly insidious form of spreadsheet error: the hard-coding error. These errors are defined as the presence of one or more unreferenced numerical values in a cell formula. The code was used to audit six engineering spreadsheets relevant to bioenergy systems, three developed in our lab (and reported on in other sessions at the AIM), and three in the public domain. The preliminary audit results were analyzed to understand the nature and distribution of hard-coding errors. The preponderance and diversity of hard-coding errors in these spreadsheets motivated us to subcategorize them. Together, the hard-coding error detection program and sub-categorization program provide a robust and rapid means of detecting and categorizing multiple types of hard-coding errors. Use of these programs could increase the reliability of spreadsheet software used in simulation, modeling, and analysis of bioenergy systems." @default.
- W2057960458 created "2016-06-24" @default.
- W2057960458 creator A5009605365 @default.
- W2057960458 creator A5065089841 @default.
- W2057960458 creator A5068328966 @default.
- W2057960458 date "2011-01-01" @default.
- W2057960458 modified "2023-09-26" @default.
- W2057960458 title "Technical Note: Detecting and Subcategorizing Hard-coding Errors in Bioenergy-relevant Spreadsheets Using Visual Basic for Applications (VBA)" @default.
- W2057960458 cites W1539402909 @default.
- W2057960458 cites W1571097741 @default.
- W2057960458 cites W2038436770 @default.
- W2057960458 cites W2113234297 @default.
- W2057960458 cites W2133801508 @default.
- W2057960458 cites W2150704968 @default.
- W2057960458 cites W93717786 @default.
- W2057960458 doi "https://doi.org/10.13031/2013.37064" @default.
- W2057960458 hasPublicationYear "2011" @default.
- W2057960458 type Work @default.
- W2057960458 sameAs 2057960458 @default.
- W2057960458 citedByCount "1" @default.
- W2057960458 countsByYear W20579604582015 @default.
- W2057960458 crossrefType "journal-article" @default.
- W2057960458 hasAuthorship W2057960458A5009605365 @default.
- W2057960458 hasAuthorship W2057960458A5065089841 @default.
- W2057960458 hasAuthorship W2057960458A5068328966 @default.
- W2057960458 hasConcept C105795698 @default.
- W2057960458 hasConcept C115199736 @default.
- W2057960458 hasConcept C124101348 @default.
- W2057960458 hasConcept C162324750 @default.
- W2057960458 hasConcept C179518139 @default.
- W2057960458 hasConcept C187736073 @default.
- W2057960458 hasConcept C199360897 @default.
- W2057960458 hasConcept C199521495 @default.
- W2057960458 hasConcept C2777904410 @default.
- W2057960458 hasConcept C33923547 @default.
- W2057960458 hasConcept C41008148 @default.
- W2057960458 hasConcept C43126263 @default.
- W2057960458 hasConceptScore W2057960458C105795698 @default.
- W2057960458 hasConceptScore W2057960458C115199736 @default.
- W2057960458 hasConceptScore W2057960458C124101348 @default.
- W2057960458 hasConceptScore W2057960458C162324750 @default.
- W2057960458 hasConceptScore W2057960458C179518139 @default.
- W2057960458 hasConceptScore W2057960458C187736073 @default.
- W2057960458 hasConceptScore W2057960458C199360897 @default.
- W2057960458 hasConceptScore W2057960458C199521495 @default.
- W2057960458 hasConceptScore W2057960458C2777904410 @default.
- W2057960458 hasConceptScore W2057960458C33923547 @default.
- W2057960458 hasConceptScore W2057960458C41008148 @default.
- W2057960458 hasConceptScore W2057960458C43126263 @default.
- W2057960458 hasIssue "3" @default.
- W2057960458 hasLocation W20579604581 @default.
- W2057960458 hasOpenAccess W2057960458 @default.
- W2057960458 hasPrimaryLocation W20579604581 @default.
- W2057960458 hasRelatedWork W1997701371 @default.
- W2057960458 hasRelatedWork W2082601134 @default.
- W2057960458 hasRelatedWork W2348097614 @default.
- W2057960458 hasRelatedWork W2357561908 @default.
- W2057960458 hasRelatedWork W2359324206 @default.
- W2057960458 hasRelatedWork W2367368021 @default.
- W2057960458 hasRelatedWork W2369673098 @default.
- W2057960458 hasRelatedWork W2380602769 @default.
- W2057960458 hasRelatedWork W2389176847 @default.
- W2057960458 hasRelatedWork W3210523558 @default.
- W2057960458 hasVolume "27" @default.
- W2057960458 isParatext "false" @default.
- W2057960458 isRetracted "false" @default.
- W2057960458 magId "2057960458" @default.
- W2057960458 workType "article" @default.