Matches in SemOpenAlex for { <https://semopenalex.org/work/W1729872521> ?p ?o ?g. }
- W1729872521 abstract "Spreadsheets are software programs which are typically created by end-users and often used for business-critical tasks. Many studies indicate that errors in spreadsheets are very common. Thus, a number of vendors offer auditing tools which promise to detect errors by checking spreadsheets against so-called Best Practices such as Don't put constants in fomulae. Unfortunately, it is largely unknown which Best Practices have which actual effects on which spreadsheet quality aspects in which settings. We have conducted a controlled experiment with 42 subjects to investigate the question whether observance of three commonly suggested Best Practices is correlated with desired positive effects regarding correctness and maintainability: Do not put constants in formulae, keep formula complexity low and refer to the left and above. The experiment was carried out in two phases which covered the creation of new and the modification of existing spreadsheets. It was evaluated using a novel construction kit for spreadsheet auditing tools called Spreadsheet Inspection Framework. The experiment produced a small sample of directly comparable spreadsheets which all try to solve the same task. Our analysis of the obtained spreadsheets indicates that the correctness of bottom-line results is not affected by the observance of the three Best Practices. However, initially correct spreadsheets with high observance of these Best Practices tend to be the ones whose later modifications yield the most correct results." @default.
- W1729872521 created "2016-06-24" @default.
- W1729872521 creator A5043952344 @default.
- W1729872521 creator A5065439975 @default.
- W1729872521 date "2012-11-29" @default.
- W1729872521 modified "2023-09-27" @default.
- W1729872521 title "Investigating Effects of Common Spreadsheet Design Practices on Correctness and Maintainability" @default.
- W1729872521 cites W1497877802 @default.
- W1729872521 cites W1503338760 @default.
- W1729872521 cites W1512164621 @default.
- W1729872521 cites W1524044080 @default.
- W1729872521 cites W1559906461 @default.
- W1729872521 cites W1889354467 @default.
- W1729872521 cites W1987842730 @default.
- W1729872521 cites W2113956163 @default.
- W1729872521 cites W2121561597 @default.
- W1729872521 cites W2135473121 @default.
- W1729872521 cites W2150704968 @default.
- W1729872521 cites W2154781260 @default.
- W1729872521 cites W2161047290 @default.
- W1729872521 cites W2205899869 @default.
- W1729872521 cites W2214436761 @default.
- W1729872521 cites W2279604287 @default.
- W1729872521 cites W93717786 @default.
- W1729872521 hasPublicationYear "2012" @default.
- W1729872521 type Work @default.
- W1729872521 sameAs 1729872521 @default.
- W1729872521 citedByCount "5" @default.
- W1729872521 countsByYear W17298725212014 @default.
- W1729872521 countsByYear W17298725212015 @default.
- W1729872521 countsByYear W17298725212016 @default.
- W1729872521 countsByYear W17298725212019 @default.
- W1729872521 crossrefType "posted-content" @default.
- W1729872521 hasAuthorship W1729872521A5043952344 @default.
- W1729872521 hasAuthorship W1729872521A5065439975 @default.
- W1729872521 hasConcept C111472728 @default.
- W1729872521 hasConcept C115903868 @default.
- W1729872521 hasConcept C121955636 @default.
- W1729872521 hasConcept C127413603 @default.
- W1729872521 hasConcept C138885662 @default.
- W1729872521 hasConcept C144133560 @default.
- W1729872521 hasConcept C160713754 @default.
- W1729872521 hasConcept C162324750 @default.
- W1729872521 hasConcept C184356942 @default.
- W1729872521 hasConcept C185592680 @default.
- W1729872521 hasConcept C187736073 @default.
- W1729872521 hasConcept C198531522 @default.
- W1729872521 hasConcept C199360897 @default.
- W1729872521 hasConcept C199521495 @default.
- W1729872521 hasConcept C201995342 @default.
- W1729872521 hasConcept C2778143727 @default.
- W1729872521 hasConcept C2779530757 @default.
- W1729872521 hasConcept C2780451532 @default.
- W1729872521 hasConcept C41008148 @default.
- W1729872521 hasConcept C43617362 @default.
- W1729872521 hasConcept C55439883 @default.
- W1729872521 hasConceptScore W1729872521C111472728 @default.
- W1729872521 hasConceptScore W1729872521C115903868 @default.
- W1729872521 hasConceptScore W1729872521C121955636 @default.
- W1729872521 hasConceptScore W1729872521C127413603 @default.
- W1729872521 hasConceptScore W1729872521C138885662 @default.
- W1729872521 hasConceptScore W1729872521C144133560 @default.
- W1729872521 hasConceptScore W1729872521C160713754 @default.
- W1729872521 hasConceptScore W1729872521C162324750 @default.
- W1729872521 hasConceptScore W1729872521C184356942 @default.
- W1729872521 hasConceptScore W1729872521C185592680 @default.
- W1729872521 hasConceptScore W1729872521C187736073 @default.
- W1729872521 hasConceptScore W1729872521C198531522 @default.
- W1729872521 hasConceptScore W1729872521C199360897 @default.
- W1729872521 hasConceptScore W1729872521C199521495 @default.
- W1729872521 hasConceptScore W1729872521C201995342 @default.
- W1729872521 hasConceptScore W1729872521C2778143727 @default.
- W1729872521 hasConceptScore W1729872521C2779530757 @default.
- W1729872521 hasConceptScore W1729872521C2780451532 @default.
- W1729872521 hasConceptScore W1729872521C41008148 @default.
- W1729872521 hasConceptScore W1729872521C43617362 @default.
- W1729872521 hasConceptScore W1729872521C55439883 @default.
- W1729872521 hasLocation W17298725211 @default.
- W1729872521 hasOpenAccess W1729872521 @default.
- W1729872521 hasPrimaryLocation W17298725211 @default.
- W1729872521 hasRelatedWork W147588521 @default.
- W1729872521 hasRelatedWork W1504065802 @default.
- W1729872521 hasRelatedWork W1590752308 @default.
- W1729872521 hasRelatedWork W1594763921 @default.
- W1729872521 hasRelatedWork W1605018304 @default.
- W1729872521 hasRelatedWork W2101778378 @default.
- W1729872521 hasRelatedWork W2130699277 @default.
- W1729872521 hasRelatedWork W2131932522 @default.
- W1729872521 hasRelatedWork W2138086333 @default.
- W1729872521 hasRelatedWork W2171814918 @default.
- W1729872521 hasRelatedWork W2247660088 @default.
- W1729872521 hasRelatedWork W2299890247 @default.
- W1729872521 hasRelatedWork W2520986311 @default.
- W1729872521 hasRelatedWork W2770662258 @default.
- W1729872521 hasRelatedWork W2901549551 @default.
- W1729872521 hasRelatedWork W2963404592 @default.
- W1729872521 hasRelatedWork W2985203584 @default.
- W1729872521 hasRelatedWork W2995297220 @default.
- W1729872521 hasRelatedWork W3021105036 @default.
- W1729872521 hasRelatedWork W3178253611 @default.