{"id":"https://openalex.org/W150820355","doi":null,"title":"A dynamic graph-based visualization for spreadsheets","display_name":"A dynamic graph-based visualization for spreadsheets","alternate_titles":[],"publication_year":2008,"publication_date":"2008-02-29","ids":{"openalex":"https://openalex.org/W150820355","mag":"150820355"},"language":"en","primary_location":{"id":"mag:150820355","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=1722359.1722396","pdf_url":null,"source":{"id":"https://openalex.org/S4306419507","display_name":"International Conference on Human-Computer Interaction","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"International Conference on Human-Computer Interaction","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W150820355"],"child_works_count":0,"type":"conference-paper","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/A5022792110","display_name":"Bennett Kankuzi","orcid":"https://orcid.org/0000-0002-8604-5255","observed_orcids":["https://orcid.org/0000-0002-8604-5255"]},"institutions":[{"id":"https://openalex.org/I157273133","display_name":"University of Botswana","ror":"https://ror.org/01encsj80","country_code":"BW","type":"education","lineage":["https://openalex.org/I157273133"]}],"countries":["BW"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Bennett Kankuzi","raw_affiliation_strings":["University of Botswana; Gaborone; Botswana"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Botswana; Gaborone; Botswana","institution_ids":["https://openalex.org/I157273133"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5057719012","display_name":"Yirsaw Ayalew","orcid":"https://orcid.org/0000-0002-8461-4952","observed_orcids":["https://orcid.org/0000-0002-8461-4952"]},"institutions":[{"id":"https://openalex.org/I157273133","display_name":"University of Botswana","ror":"https://ror.org/01encsj80","country_code":"BW","type":"education","lineage":["https://openalex.org/I157273133"]}],"countries":["BW"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Yirsaw Ayalew","raw_affiliation_strings":["University of Botswana; Gaborone; Botswana"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Botswana; Gaborone; Botswana","institution_ids":["https://openalex.org/I157273133"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I157273133"],"apc_list":null,"apc_paid":null,"fwci":0.5744,"has_fulltext":false,"cited_by_count":3,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.58443423,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"198","last_page":"203"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.9848999977111816,"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"}},"topics":[{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.9848999977111816,"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"}},{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.014499999582767487,"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/T10260","display_name":"Software Engineering Research","score":9.999999747378752e-05,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/dynamic-graph-visualization","display_name":"dynamic graph visualization","score":0.7760000228881836},{"id":"https://openalex.org/keywords/markov-clustering-algorithm","display_name":"Markov clustering algorithm","score":0.902999997138977},{"id":"https://openalex.org/keywords/treemaps","display_name":"treemaps","score":0.9589999914169312},{"id":"https://openalex.org/keywords/spreadsheet-debugging","display_name":"spreadsheet debugging","score":0.6620000004768372},{"id":"https://openalex.org/keywords/program-comprehension","display_name":"program comprehension","score":0.6980000138282776},{"id":"https://openalex.org/keywords/graph-clustering","display_name":"graph clustering","score":0.699999988079071}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8267693519592285},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.7899126410484314},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.7568854093551636},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.671559751033783},{"id":"https://openalex.org/C2911174283","wikidata":"https://www.wikidata.org/wiki/Q739462","display_name":"Graph Layout","level":4,"score":0.610303521156311},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.5918729901313782},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.5424273014068604},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5352606773376465},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5336331725120544},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.4243812561035156},{"id":"https://openalex.org/C112953755","wikidata":"https://www.wikidata.org/wiki/Q739462","display_name":"Graph drawing","level":3,"score":0.30650293827056885},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.300229012966156},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.18162691593170166},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.16991356015205383}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:150820355","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=1722359.1722396","pdf_url":null,"source":{"id":"https://openalex.org/S4306419507","display_name":"International Conference on Human-Computer Interaction","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"International Conference on Human-Computer Interaction","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":52,"referenced_works":["https://openalex.org/W93717786","https://openalex.org/W233411397","https://openalex.org/W1507053129","https://openalex.org/W1511796393","https://openalex.org/W1520197059","https://openalex.org/W1522006088","https://openalex.org/W1564138918","https://openalex.org/W1578962373","https://openalex.org/W1598564712","https://openalex.org/W1632502354","https://openalex.org/W1842847600","https://openalex.org/W1899639145","https://openalex.org/W1901581747","https://openalex.org/W1969600276","https://openalex.org/W1973994007","https://openalex.org/W1974084458","https://openalex.org/W1974503980","https://openalex.org/W1986518717","https://openalex.org/W1999504357","https://openalex.org/W2004681315","https://openalex.org/W2034957383","https://openalex.org/W2042031818","https://openalex.org/W2046652934","https://openalex.org/W2050278100","https://openalex.org/W2054217028","https://openalex.org/W2077329627","https://openalex.org/W2081143970","https://openalex.org/W2086679600","https://openalex.org/W2093987194","https://openalex.org/W2095148351","https://openalex.org/W2097326999","https://openalex.org/W2102664288","https://openalex.org/W2104706725","https://openalex.org/W2107686020","https://openalex.org/W2111469656","https://openalex.org/W2112338634","https://openalex.org/W2112360310","https://openalex.org/W2113956163","https://openalex.org/W2114269784","https://openalex.org/W2119896264","https://openalex.org/W2121564430","https://openalex.org/W2121840944","https://openalex.org/W2124166542","https://openalex.org/W2124378517","https://openalex.org/W2135473121","https://openalex.org/W2149107096","https://openalex.org/W2153018767","https://openalex.org/W2172240163","https://openalex.org/W2188743916","https://openalex.org/W2320036734","https://openalex.org/W2810135441","https://openalex.org/W3204635089"],"related_works":["https://openalex.org/W2032969662","https://openalex.org/W2346851664","https://openalex.org/W2060168898","https://openalex.org/W2172240163","https://openalex.org/W2149107096","https://openalex.org/W1659044373","https://openalex.org/W1533980247","https://openalex.org/W2054870688","https://openalex.org/W1598564712","https://openalex.org/W2119896264"],"abstract_inverted_index":{"Spreadsheet":[0],"systems":[1],"are":[2,11,143],"widely":[3],"used":[4,12],"and":[5,26,32,73,88,102],"highly":[6],"popular":[7],"end-user":[8],"systems.":[9],"They":[10],"for":[13],"a":[14,36,81,126,147,171],"variety":[15],"of":[16,39,46,53,66,90,115,125,170],"important":[17],"tasks":[18],"such":[19],"as":[20],"mathematical":[21],"modelling,":[22],"scientific":[23],"computation,":[24],"tabular":[25],"graphical":[27],"data":[28,30,55,68],"presentation,":[29],"analysis":[31],"decision":[33],"making.":[34],"However,":[35],"significant":[37],"proportion":[38],"them":[40],"have":[41],"severe":[42],"quality":[43],"problems.":[44],"One":[45],"the":[47,51,54,67,97,140,158,166],"contributing":[48],"factors":[49],"is":[50,59],"invisibility":[52,65],"flow":[56,69],"structure":[57],"which":[58,163],"associated":[60],"with":[61,133,165],"cell":[62],"formulas.":[63],"The":[64,104],"makes":[70],"program":[71],"understanding":[72,87],"debugging":[74,89],"very":[75],"difficult.\r\n\r\nThis":[76],"paper":[77],"aims":[78],"to":[79,122,138],"provide":[80],"visualization":[82,156],"approach":[83],"that":[84,154],"can":[85],"simplify":[86],"spreadsheets":[91],"based":[92],"on":[93],"compound":[94],"fisheye":[95,118],"views,":[96],"Markov":[98],"Clustering":[99],"(MCL)":[100],"algorithm,":[101],"Treemaps.":[103],"MCL":[105,159],"algorithm":[106,160],"helps":[107],"in":[108],"visualizing":[109],"large":[110],"graphs":[111],"by":[112],"generating":[113],"clusters":[114,162],"cells.":[116],"Compound":[117],"views":[119],"allows":[120],"us":[121],"view":[123],"members":[124],"particular":[127],"cluster":[128,148],"while":[129,145],"showing":[130],"their":[131],"linkages":[132],"other":[134],"clusters.":[135],"Treemaps":[136],"help":[137],"visualize":[139],"depth":[141],"we":[142],"at":[144],"navigating":[146],"tree.":[149],"Our":[150],"initial":[151],"experiment":[152],"shows":[153],"graph-based":[155],"using":[157],"generates":[161],"match":[164],"corresponding":[167],"logical":[168],"areas":[169],"spreadsheet.":[172]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W150820355","counts_by_year":[{"year":2016,"cited_by_count":1}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2016-06-24T00:00:00"}
