{"id":"https://openalex.org/W16688517","doi":null,"title":"How to Make Spreadsheets Error-Proof","display_name":"How to Make Spreadsheets Error-Proof","alternate_titles":[],"publication_year":1996,"publication_date":"1996-05-01","ids":{"openalex":"https://openalex.org/W16688517","mag":"16688517"},"language":"en","primary_location":{"id":"mag:16688517","doi":null,"is_oa":false,"landing_page_url":"https://www.questia.com/library/journal/1G1-18315165/how-to-make-spreadsheets-error-proof","pdf_url":null,"source":{"id":"https://openalex.org/S2764687399","display_name":"Journal of accountancy online/Journal of accountancy","issn_l":"0021-8448","issn":["0021-8448"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["abdc-c","jufo-1"],"host_organization":"https://openalex.org/P4320800682","host_organization_name":"American Institute of Certified Public Accountants","host_organization_lineage":["https://openalex.org/P4320800682"],"host_organization_lineage_names":["American Institute of Certified Public Accountants"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Journal of accountancy online/Journal of accountancy","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W16688517"],"child_works_count":0,"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":null,"display_name":"David M. Freeman","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"David M. Freeman","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.8785,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.91475663,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":86,"max":96},"biblio":{"volume":"181","issue":"5","first_page":"75","last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9990000128746033,"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.9990000128746033,"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/T11734","display_name":"Decision Support System Applications","score":0.00039999998989515007,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T13744","display_name":"Financial Literacy and Behavior","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1402","display_name":"Accounting"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/spreadsheet-errors","display_name":"spreadsheet errors","score":0.8220000267028809},{"id":"https://openalex.org/keywords/spreadsheet-design","display_name":"spreadsheet design","score":0.7350000143051147},{"id":"https://openalex.org/keywords/formula-validation","display_name":"formula validation","score":0.367000013589859},{"id":"https://openalex.org/keywords/error-detection","display_name":"error detection","score":0.36899998784065247},{"id":"https://openalex.org/keywords/data-integrity","display_name":"data integrity","score":0.46399998664855957},{"id":"https://openalex.org/keywords/audit-trail","display_name":"audit trail","score":0.621999979019165},{"id":"https://openalex.org/keywords/microsoft-excel","display_name":"Microsoft Excel","score":0.6000000238418579}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7452254891395569},{"id":"https://openalex.org/C2777179996","wikidata":"https://www.wikidata.org/wiki/Q911222","display_name":"Mistake","level":2,"score":0.6813837885856628},{"id":"https://openalex.org/C199521495","wikidata":"https://www.wikidata.org/wiki/Q181487","display_name":"Audit","level":2,"score":0.5879641175270081},{"id":"https://openalex.org/C143095724","wikidata":"https://www.wikidata.org/wiki/Q515895","display_name":"Odds","level":3,"score":0.5464798212051392},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.5129005908966064},{"id":"https://openalex.org/C80958533","wikidata":"https://www.wikidata.org/wiki/Q1047174","display_name":"Audit trail","level":3,"score":0.5027048587799072},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.4903995990753174},{"id":"https://openalex.org/C2776836400","wikidata":"https://www.wikidata.org/wiki/Q31087","display_name":"Calculator","level":2,"score":0.4357788860797882},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.41394442319869995},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3401758372783661},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.24295490980148315},{"id":"https://openalex.org/C121955636","wikidata":"https://www.wikidata.org/wiki/Q4116214","display_name":"Accounting","level":1,"score":0.2090674340724945},{"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/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C151956035","wikidata":"https://www.wikidata.org/wiki/Q1132755","display_name":"Logistic regression","level":2,"score":0.0},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:16688517","doi":null,"is_oa":false,"landing_page_url":"https://www.questia.com/library/journal/1G1-18315165/how-to-make-spreadsheets-error-proof","pdf_url":null,"source":{"id":"https://openalex.org/S2764687399","display_name":"Journal of accountancy online/Journal of accountancy","issn_l":"0021-8448","issn":["0021-8448"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["abdc-c","jufo-1"],"host_organization":"https://openalex.org/P4320800682","host_organization_name":"American Institute of Certified Public Accountants","host_organization_lineage":["https://openalex.org/P4320800682"],"host_organization_lineage_names":["American Institute of Certified Public Accountants"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Journal of accountancy online/Journal of accountancy","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":0,"referenced_works":[],"related_works":["https://openalex.org/W4236286049","https://openalex.org/W2160322876","https://openalex.org/W7099178134","https://openalex.org/W2339113524","https://openalex.org/W4239128431","https://openalex.org/W2154781260","https://openalex.org/W2138086333","https://openalex.org/W2121305681","https://openalex.org/W1804772808","https://openalex.org/W1169496"],"abstract_inverted_index":{"Making":[0],"those":[1,329,440],"handy":[2],"number-crunches":[3],"more":[4,121,353,467],"productive.":[5],"Commercial":[6],"spreadsheet":[7,32,47,143,160,230,285,319,597],"application":[8],"programs":[9,29],"probably":[10],"are":[11,21,34,36,96,136,145,162,280,312,393,421],"accountants'":[12],"most":[13,159,242],"widely":[14],"used":[15],"computer":[16],"tools.":[17],"But":[18,271,567],"how":[19,126,489],"accurate":[20],"the":[22,27,37,93,97,177,195,206,212,244,294,306,400,437,450,460,479,486,493,513,538,606],"numbers":[23],"they":[24,174,363,471],"generate?":[25],"While":[26,237,463],"underlying":[28],"that":[30,41,57,250,264,277,282,508,518],"run":[31],"software":[33],"flawless,":[35],"myriad":[38],"custom":[39],"formulas":[40,392,469,530],"users":[42],"build":[43],"into":[44,340,500],"a":[45,52,157,216,220,229,259,336,382,404,429,519,571],"typical":[46],"equally":[48],"sound?":[49],"Research":[50],"by":[51,153,497],"major":[53,539],"accounting":[54],"firm":[55],"found":[56,184],"over":[58],"90%":[59],"of":[60,197,208,215,243,296,303,328,347,453,537,552,563,595,610],"spreadsheets":[61,111,297],"larger":[62],"than":[63,381],"150":[64],"rows":[65,367,412,441],"contained":[66],"at":[67,246,326],"least":[68],"one":[69,77,398,536],"significant":[70],"formula":[71,217],"mistake.":[72],"And":[73],"it":[74,238,272,339,433,499],"takes":[75],"just":[76],"small":[78],"error--a":[79],"single":[80],"misplaced":[81],"code--to":[82],"produce":[83,258,586],"wildly":[84],"erroneous":[85],"results.":[86],"Such":[87],"errors":[88],"can":[89,577],"be":[90,276,358],"devastating":[91],"because":[92],"data":[94,210,390,438,507,517],"often":[95,483],"foundation":[98],"on":[99,149,602],"which":[100,134],"many":[101],"organizations":[102],"base":[103],"their":[104,198],"key":[105],"decisions.":[106],"It's":[107],"possible":[108],"to":[109,118,166,170,193,257,268,275,292,448,474,490,558,565],"make":[110],"not":[112,300,422,528,556],"only":[113],"virtually":[114],"error-proof,":[115],"but":[116,317],"easier":[117],"use":[119,167,377],"and":[120,141,168,180,298,344,391,579,608],"understandable.":[122],"This":[123,533,545],"article":[124,311],"tells":[125],"it's":[127,255,262],"done.":[128],"Unlike":[129],"other":[130,318,477,514],"information":[131,187],"system":[132],"programs,":[133],"typically":[135,183],"developed":[137],"through":[138],"extensive":[139],"design":[140,546],"testing,":[142],"files":[144,161],"mostly":[146],"cobbled":[147],"together":[148],"an":[150,549,560],"as-needed":[151],"basis":[152],"ordinary":[154,284],"users.":[155],"As":[156],"result,":[158],"relatively":[163],"inefficient,":[164],"difficult":[165],"hard":[169],"maintain.":[171],"Also,":[172],"since":[173],"generally":[175],"lack":[176],"inherent":[178,550],"controls":[179,203],"audit":[181,561,589],"trails":[182],"in":[185,309,314,352,372,403,439,459,476,481,583],"commercial":[186],"systems,":[188],"there":[189],"is":[190,231,266,350,447,484],"no":[191,365],"way":[192],"ensure":[194],"integrity,":[196],"data.":[199,566],"For":[200,417],"example,":[201,418],"what":[202],"normally":[204],"prevent":[205],"entry":[207],"invalid":[209],"or":[211,368,385,397,406,410,413,427,431,442,511,531,600],"accidental":[213],"overwriting":[214],"cell":[218],"with":[219,541],"number?":[221],"Usually":[222],"none.":[223],"PLAYING":[224],"THE":[225],"ODDS":[226],"Using":[227],"such":[228],"much":[232],"like":[233],"playing":[234],"Russian":[235],"roulette.":[236],"may":[239],"work":[240],"fine":[241],"time,":[245],"some":[247,327],"stage,":[248],"when":[249,424],"minor,":[251],"undetected":[252],"error":[253],"emerges,":[254],"going":[256,267],"wrong":[260],"answer--and":[261],"unlikely":[263],"anyone":[265],"catch":[269],"it.":[270],"doesn't":[273],"have":[274,321],"way.":[278],"There":[279],"techniques":[281],"even":[283],"users--those":[286],"without":[287],"special":[288],"programming":[289],"training--can":[290],"apply":[291],"improve":[293],"quality":[295],"reduce--if":[299],"eliminate--the":[301],"risk":[302],"errors.":[304],"All":[305],"examples":[307],"shown":[308,371],"this":[310,378,464,581],"generated":[313],"Microsoft's":[315],"Excel,":[316],"applications":[320],"similar":[322],"functions.":[323],"Let's":[324],"look":[325],"techniques.":[330],"Basic":[331],"design.":[332],"When":[333],"laying":[334],"out":[335,360],"spreadsheet,":[337],"divide":[338],"three":[341],"areas--input,":[342],"calculation":[343],"output.":[345],"Each":[346],"these":[348],"areas":[349],"discussed":[351],"detail":[354],"later.":[355],"They":[356,554],"should":[357,505,515,527,604],"laid":[359],"diagonally":[361],"so":[362],"share":[364],"common":[366],"columns,":[369],"as":[370],"exhibit":[373],"1,":[374],"below.":[375],"Why":[376],"structure":[379],"rather":[380],"conventional":[383],"vertical":[384],"horizontal":[386],"design,":[387],"where":[388],"all":[389,436],"arranged":[394],"either":[395],"side-by-side":[396,405],"under":[399],"other?":[401],"Because":[402],"stacked":[407],"arrangement,":[408],"adding":[409],"deleting":[411],"columns":[414],"invites":[415],"problems.":[416],"if":[419,568],"you":[420,425,569,576,585],"careful":[423],"delete":[426],"add":[428],"row'":[430],"column,":[432],"could":[434],"affect":[435],"columns.":[443],"An":[444],"alternative":[445],"technique":[446,465],"exploit":[449],"three-dimensional":[451],"capabilities":[452],"today's":[454],"popular":[455],"spreadsheets--using":[456],"multiple":[457],"worksheets":[458],"same":[461],"file.":[462],"requires":[466],"complex":[468],"(because":[470],"must":[472],"refer":[473],"cells":[475],"worksheets),":[478],"payoff":[480],"security":[482],"worth":[485],"effort.":[487],"Here's":[488],"set":[491],"up":[492],"input":[494,525,574],"area:":[495],"Begin":[496],"dividing":[498],"two":[501],"discrete":[502],"parts.":[503],"One":[504],"contain":[506,516,529],"change":[509,522],"infrequently":[510],"never;":[512],"user":[520],"will":[521],"regularly.":[523],"The":[524],"area":[526],"calculations.":[532],"helps":[534],"overcome":[535],"problems":[540],"spreadsheets--":[542],"version":[543],"control.":[544],"also":[547],"addresses":[548],"shortcoming":[551],"spreadsheets:":[553],"were":[555],"designed":[557],"keep":[559],"trail":[562],"changes":[564],"maintain":[570],"separate":[572],"data-only":[573],"area,":[575],"extract":[578],"save":[580],"section;":[582],"effect":[584],"your":[587],"own":[588],"trail.":[590],"To":[591],"enable":[592],"easy":[593],"identification":[594],"different":[596],"versions,":[598],"headers":[599],"footers":[601],"printouts":[603],"show":[605],"date":[607],"time":[609],"printing.":[611],"\u2026":[612]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W16688517","counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
