{"id":"https://openalex.org/W4386928577","doi":"https://doi.org/10.1287/ited.2018.0195csu","title":"An Update to Converting Zip Code Data into Distances Using Microsoft Excel Geography Data Type, Maps, and Including Driving Distances","display_name":"An Update to Converting Zip Code Data into Distances Using Microsoft Excel Geography Data Type, Maps, and Including Driving Distances","publication_year":2023,"publication_date":"2023-09-21","ids":{"openalex":"https://openalex.org/W4386928577","doi":"https://doi.org/10.1287/ited.2018.0195csu"},"language":"en","primary_location":{"id":"doi:10.1287/ited.2018.0195csu","is_oa":true,"landing_page_url":"https://doi.org/10.1287/ited.2018.0195csu","pdf_url":null,"source":{"id":"https://openalex.org/S155575560","display_name":"INFORMS Transactions on Education","issn_l":"1532-0545","issn":["1532-0545"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310315699","host_organization_name":"Institute for Operations Research and the Management Sciences","host_organization_lineage":["https://openalex.org/P4310315699"],"host_organization_lineage_names":["Institute for Operations Research and the Management Sciences"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"INFORMS Transactions on Education","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://doi.org/10.1287/ited.2018.0195csu","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5013647208","display_name":"Eric Huggins","orcid":"https://orcid.org/0000-0001-9724-4682"},"institutions":[{"id":"https://openalex.org/I149471917","display_name":"Fort Lewis College","ror":"https://ror.org/00aad7q36","country_code":"US","type":"education","lineage":["https://openalex.org/I149471917"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Eric Huggins","raw_affiliation_strings":["School of Business Administration, Fort Lewis College, Durango, Colorado 81301;"],"raw_orcid":"https://orcid.org/0000-0001-9724-4682","affiliations":[{"raw_affiliation_string":"School of Business Administration, Fort Lewis College, Durango, Colorado 81301;","institution_ids":["https://openalex.org/I149471917"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5001732874","display_name":"Ivan G. Guardiola","orcid":"https://orcid.org/0000-0002-7381-5441"},"institutions":[{"id":"https://openalex.org/I149471917","display_name":"Fort Lewis College","ror":"https://ror.org/00aad7q36","country_code":"US","type":"education","lineage":["https://openalex.org/I149471917"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ivan Guardiola","raw_affiliation_strings":["School of Administration, Fort Lewis College, Durango, Colorado 81301"],"raw_orcid":"https://orcid.org/0000-0002-7381-5441","affiliations":[{"raw_affiliation_string":"School of Administration, Fort Lewis College, Durango, Colorado 81301","institution_ids":["https://openalex.org/I149471917"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5013647208"],"corresponding_institution_ids":["https://openalex.org/I149471917"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.1806905,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"25","issue":"1","first_page":"35","last_page":"40"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9372000098228455,"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"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9372000098228455,"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/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9140999913215637,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/zip-code","display_name":"Zip code","score":0.8032678961753845},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6979994773864746},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.6474900245666504},{"id":"https://openalex.org/keywords/microsoft-excel","display_name":"Microsoft excel","score":0.614089846611023},{"id":"https://openalex.org/keywords/source-code","display_name":"Source code","score":0.5257932543754578},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4991171360015869},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.49838685989379883},{"id":"https://openalex.org/keywords/data-file","display_name":"Data file","score":0.4882557690143585},{"id":"https://openalex.org/keywords/data-type","display_name":"Data type","score":0.47720417380332947},{"id":"https://openalex.org/keywords/type","display_name":"Type (biology)","score":0.4412076473236084},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3896472454071045},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.37792131304740906},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.23553964495658875}],"concepts":[{"id":"https://openalex.org/C3018590553","wikidata":"https://www.wikidata.org/wiki/Q136208","display_name":"Zip code","level":2,"score":0.8032678961753845},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6979994773864746},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.6474900245666504},{"id":"https://openalex.org/C3019730874","wikidata":"https://www.wikidata.org/wiki/Q11272","display_name":"Microsoft excel","level":2,"score":0.614089846611023},{"id":"https://openalex.org/C43126263","wikidata":"https://www.wikidata.org/wiki/Q128751","display_name":"Source code","level":2,"score":0.5257932543754578},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4991171360015869},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.49838685989379883},{"id":"https://openalex.org/C171730128","wikidata":"https://www.wikidata.org/wiki/Q5227290","display_name":"Data file","level":2,"score":0.4882557690143585},{"id":"https://openalex.org/C138958017","wikidata":"https://www.wikidata.org/wiki/Q190087","display_name":"Data type","level":2,"score":0.47720417380332947},{"id":"https://openalex.org/C2777299769","wikidata":"https://www.wikidata.org/wiki/Q3707858","display_name":"Type (biology)","level":2,"score":0.4412076473236084},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3896472454071045},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.37792131304740906},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.23553964495658875},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1287/ited.2018.0195csu","is_oa":true,"landing_page_url":"https://doi.org/10.1287/ited.2018.0195csu","pdf_url":null,"source":{"id":"https://openalex.org/S155575560","display_name":"INFORMS Transactions on Education","issn_l":"1532-0545","issn":["1532-0545"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310315699","host_organization_name":"Institute for Operations Research and the Management Sciences","host_organization_lineage":["https://openalex.org/P4310315699"],"host_organization_lineage_names":["Institute for Operations Research and the Management Sciences"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"INFORMS Transactions on Education","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:inm:orited:v:25:y:2024:i:1:p:35-40","is_oa":false,"landing_page_url":"http://doi.org/10.1287/ited.2018.0195csu","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"doi:10.1287/ited.2018.0195csu","is_oa":true,"landing_page_url":"https://doi.org/10.1287/ited.2018.0195csu","pdf_url":null,"source":{"id":"https://openalex.org/S155575560","display_name":"INFORMS Transactions on Education","issn_l":"1532-0545","issn":["1532-0545"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310315699","host_organization_name":"Institute for Operations Research and the Management Sciences","host_organization_lineage":["https://openalex.org/P4310315699"],"host_organization_lineage_names":["Institute for Operations Research and the Management Sciences"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"INFORMS Transactions on Education","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.5799999833106995,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W270927586","https://openalex.org/W2763815264","https://openalex.org/W4233387348","https://openalex.org/W1565501066","https://openalex.org/W2952657391","https://openalex.org/W3124438825","https://openalex.org/W2137137834","https://openalex.org/W1581208478","https://openalex.org/W2936432042","https://openalex.org/W1480879962"],"abstract_inverted_index":{"In":[0,54],"the":[1,23,70,84,88,102,110,120,194],"article":[2,122],"\u201cConverting":[3],"Zip":[4],"Code":[5],"Data":[6,76,165],"into":[7,35],"Distances:":[8],"A":[9],"Case":[10],"Study":[11],"for":[12],"Teaching":[13,201],"Business":[14],"Analytics\u201d":[15],"[Huggins":[16],"E":[17],"(2019)":[18],"INFORMS":[19],"Trans.":[20],"Ed.":[21],"19(2):105\u2013107],":[22],"author":[24],"demonstrates":[25],"how":[26,107,129],"to":[27,86,108,115,130,185],"convert":[28],"a":[29,39,50,168],"column":[30],"of":[31,152,171],"zip":[32,41,51,89,98,136],"code":[33,42,52,90,99],"data":[34,204],"approximate":[36,124],"distances":[37,133,176],"from":[38,101],"default":[40],"using":[43,69,138],"standard":[44],"Microsoft":[45],"(MS)":[46],"Excel":[47,74,112],"functions":[48],"and":[49,141,203],"database.":[53],"this":[55,116],"case":[56,61,195],"article,":[57],"we":[58,67,105,127],"update":[59],"that":[60],"in":[62,79,193],"three":[63],"specific":[64],"areas.":[65],"First,":[66],"explore":[68],"relatively":[71],"new":[72],"MS":[73,111,147],"Geography":[75,164],"Type":[77,166],"that,":[78],"theory":[80],"at":[81,208],"least,":[82],"eliminates":[83],"need":[85],"use":[87],"database":[91],"by":[92],"accessing":[93],"required":[94],"information":[95],"about":[96],"each":[97],"directly":[100],"web.":[103],"Second,":[104],"show":[106,128],"apply":[109],"Maps":[113],"feature":[114],"data.":[117],"Third,":[118],"although":[119,174],"original":[121],"uses":[123],"straight-line":[125],"distances,":[126],"extract":[131],"driving":[132,175],"between":[134],"two":[135],"codes":[137],"public":[139],"maps":[140],"an":[142],"application":[143],"programming":[144],"interface":[145],"with":[146],"Excel\u2019s":[148],"=WEBSERVICE()":[149],"function.":[150],"Two":[151],"these":[153,191],"updates":[154],"are":[155,206],"not":[156],"as":[157,159],"straightforward":[158],"one":[160],"might":[161],"hope:":[162],"The":[163,200],"returns":[167],"significant":[169],"number":[170],"errors":[172],"and,":[173],"can":[177],"be":[178],"determined,":[179],"there":[180],"is":[181],"no":[182],"\u201ceasy\u201d":[183],"way":[184],"do":[186],"so":[187],"yet.":[188],"We":[189],"discuss":[190],"issues":[192],"teaching":[196],"note.":[197],"Supplemental":[198],"Material:":[199],"Note":[202],"files":[205],"available":[207],"https://www.informs.org/Publications/Subscribe/Access-Restricted-Materials":[209],".":[210]},"counts_by_year":[],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}