Connected Action
Menu
  • Services
    • Buy a social media network map and report
    • Training
    • Conferences
    • Data Reporting
    • Log in or Join us
    • Customize NodeXL
    • NodeXL
    • Marc Smith
    • About Us
  • Buy maps
    • Twitter Search Network Map and Report
    • Graph Server Twitter Search Network Map and Report
    • Other products and services
  • Sample maps
  • Blog
    • Books
    • NodeXL
    • Events
  • Newsletter
  • Videos
  • Contact
  • Log In

User interface

Trust issues and Excel: how to open other people’s NodeXL documents

Trust issues and Excel: how to open other people’s NodeXL documents

15MarMay 7, 2015 By Marc Smith

How to open a NodeXL Workbook created on a different machine

By Marc Smith and Derek Hansen

Microsoft Office applications have trust issues.

When you download a NodeXL workbook from a different machine (perhaps from http://nodexlgraphgallery.org) you may get an error like this one that mentions “trusted locations”.

************** Exception Text **************
Microsoft.VisualStudio.Tools.Applications.Runtime.
CannotCreateCustomizationDomainException: 
This document contains custom code that cannot be 
loaded because the location is not in your trusted
locations list: Sample_Facebook_Egonetwork.xlsx. If you
trust this document you can save and open it from a
location on your computer.
For more information, 
see http://go.microsoft.com/fwlink/?LinkId=99104.
******************************************

This problem is caused by a lack of trust. Excel documents may contain harmful code (“malware”) and the solution Microsoft created was the idea of “Trusted Locations”. Only folders that have been identified as “trusted locations” will allow you to open Excel files that run embedded code, which are needed by NodeXL to run.

Below are the steps needed to make a folder a trusted location. Once you have done that, NodeXL files stored in that folder will no longer display this error when they are opened.

Step 1: Open Excel Options from the File Menu in Excel

Select: Excel File Menu>Options


The Excel Options dialog. Select “Trust Center”.

Step 2: Choose the Trust Center tab on the menu on the left


The Excel Trust Center dialog. Select “Trust Center Settings”.

Step 3: Add a new trusted location where you will store your NodeXL files

Step 4. The Excel Trusted Locations dialog. Select “Add new location…”.


The Excel Trusted Location dialog. Enter the path to your NodeXL directory here.

Select the “Subfolders of this location are also trusted”. Select OK to every dialog.

It is not recommended that the download directory for your browser be granted Trusted location status.  This will require NodeXL users to download files and then copy or move them to a Trusted Location in order to open and use the complete NodeXL functionality in the file.

Posted in 2015, All posts, Foundation, NodeXL, SMRF, Social Media, Social Media Research Foundation, User interface Tagged Bug, Can't open file, convert, Dataset, Error, Excel, File, Import, Issue, NodeXL, Open, Problem, SNA, Trust, Trust Center, Trusted Location

October 2-3, 2014: Digital Strategies for Development Summit, Asian Institute of Management, Makati City, Philippines – Mapping social media networks

22SepMay 7, 2015 By Marc Smith

20141002-AIM-DSDS-Banner

 

I attended and participated in the October 2-3, 2014 Digital Strategies for Development Summit hosted by the Asian Institute of Management and held in Makati City, Philippines.

The event gathered 50 speakers from around the world and more than 300 participants to focus on the role of digital and social technologies for civic needs.  The summit focused on bringing people from many communities into a discussion of how technology can be used for:

“…enabling a better society and an empowered community? How can various stakeholders, including Government, Private Sector and Civil Society gain more momentum for their core mandates by leveraging the use of digital technology enabled solutions? Can Digital Technology create a platform for better collaboration and cooperation amongst various stakeholders?”

I spoke about the role social network analysis can play in understanding the emerging world of social media and computer mediated collective action.

15451723266_1c67c46ebf_z

20141002-Digital Strategies for Development Summit-Sheet

Posted in 2014, All posts, Collective Action, Common Goods, Conference, Foundation, Measuring social media, Metrics, Network clusters and communities, Network Data Archives, Network data providers (spigots), Network metrics and measures, Network visualization layouts, NodeXL, Performance scale parallel and cloud computing, Presentation, Research, SMRF, SNA, Social Interaction, Social Media, Social Media Research Foundation, Social network, Social Network Analysis, Social Theories and concepts, Sociology, Talk, Talks, User interface, Visualization, Workshop

NodeXL Office Hours: Thursday 10-12 Pacific Time in Google Hangout

13JunMay 7, 2015 By Marc Smith

2013-NodeXL Office Hours in Google Hangout

Hello!  Each Thursday at 10AM to noon (Pacific Time), I will be taking questions and providing support to NodeXL users in a Google Hangout.  Join me for a Q&A about NodeXL, SNA, Social Media, Networks, Mapping, Visualization and Analytics.

Posted in 2013, All posts, Measuring social media, Network Data Archives, Network data providers (spigots), Network metrics and measures, Network visualization layouts, NodeXL, Performance scale parallel and cloud computing, Presentation, Social Interaction, Social Media, Social Media Research Foundation, Social network, Social Network Analysis, Talks, User interface, Visualization, Workshop Tagged Google, Hangout, NodeXL, Office Hours, Support, Technical 5 Comments

How to create a random network in NodeXL

03MarMay 7, 2015 By Marc Smith

It can be useful to create networks randomly to use as training data sets.  A simple way to create a random network is to use the Excel RAND() function.  To create a random network of ten nodes use the following formula in a ten by two array:

=INT(RAND()*10)

the “INT” part removes the decimal places, leaving an “Integer” whole number value.

Then copy the grid of Random Value 1 and Random Value 2 to the Vertex1 and Vertex 2 columns (starting in A3) (use Paste Values to just get the current values of the random number generator!).  You can control the number of edges by copying the formula to as many rows as you want.  You can control the number of nodes by changing the value the random result is multiplied by.  The current formula multiplies by ten, creating up to 10 vertex values (after being reduced to an integer).  Increase this value to 100 for that many different nodes.  You could get much more sophisticated, creating weighted probabilities for each vertex to appear, but this is a first, simple way to “just get a network data set” fast.

2013-03-03-NodeXL-Random Network Edges

When you show the graph, you may get a network visualization that looks somewhat like this:2013-03-03-NodeXL-Random Network Edges Visualization

Posted in All posts, Network data providers (spigots), NodeXL, Social Network Analysis, Social Theories and concepts, User interface, Visualization Tagged Chart, Edge, Example, graph, Link, Map, network, NodeXL, Random, SNA, Visualization 2 Comments

NodeXL describes the networks you create: Graph Summary in v.203

09MarMay 7, 2015 By Marc Smith

Here is a map of connections among people who recently tweeted the term “peoplebrowsr”.

20120308-NodeXL-Twitter-peoplebrowsr

“But what does that picture mean?”

I hear this reaction frequently when I show people maps I have made of social media connections.

I often point out that the map and the data can reveal people who occupy important locations in the network as well as emergent clusters and groups.

“So why didn’t you just say so?”

I hear this reaction frequently when I explain what is important about a network.

In NodeXL version 203 we have released a new feature called Graph Summary.  Our goal is to “just say so”.

In this version we introduce the basics of automatic captioning.  In the NodeXL>Graph menu we now have a “Summary” button:

NodeXL will collect information about the creation and configuration of the network.  The dialog box looks like this:

20120309-NodeXL-Caption-Graph Summary

Note that NodeXL>Data>Save Import Details in Graph Summary must be selected in the Import menu for the “Data Import” field to be populated.

Selecting “Copy to Clipboard” will load a copy of these text fields into the buffer.  An example of that caption is here:

The graph represents a network of up to 1000 Twitter
users whose recent tweets contained "peoplebrowsr". 

The network was obtained on
Friday, 09 March 2012 at 01:21 UTC. 

There is an edge for each follows relationship. 
There is an edge for each "replies-to" relationship
in a tweet. 

There is an edge for each "mentions"
relationship in a tweet. 

There is a self-loop edge for each tweet that is
not a "replies-to" or "mentions". 

The earliest tweet in the network was tweeted on
Friday, 02 March 2012 at 02:39 UTC. 

The latest tweet in the network was tweeted on
Friday, 09 March 2012 at 00:47 UTC.

The graph is directed.

The graph was laid out using the
Harel-Koren Fast Multiscale layout algorithm.

The edge colors are based on relationship values. 
The vertex sizes are based on followers values.

Overall Graph Metrics:
Vertices: 74
Unique Edges: 172
Edges With Duplicates: 123
Total Edges: 295
Self-Loops: 42
Connected Components: 15
Single-Vertex Connected Components: 13
Maximum Vertices in a Connected Component: 58
Maximum Edges in a Connected Component: 276
Maximum Geodesic Distance (Diameter): 4
Average Geodesic Distance: 2.014176
Graph Density: 0.036653091447612
Modularity: 0.288302

Top 10 Vertices, Ranked by Betweenness Centrality:
@peoplebrowsr
@andrewgrill
@traviswallis
@thenickfrost
@jas
@alexbudge
@getmingly
@milener
@jeffreyhayzlett
@johnnosta

The graph's vertices were grouped by cluster using the
Clauset-Newman-Moore cluster algorithm.

More NodeXL network visualizations are here:
www.flickr.com/photos/marc_smith/sets/72157622437066929/
and here:
www.nodexlgraphgallery.org/Pages/Default.aspx

A gallery of NodeXL network data sets is available here:
nodexlgraphgallery.org/Pages/Default.aspx?search=twitter

NodeXL is free and open and available from www.codeplex.com/nodexl

NodeXL is developed by the Social Media Research Foundation
(www.smrfoundation.org) - which is dedicated to
open tools, open data, and open scholarship.

Donations to support NodeXL are welcome through PayPal:
https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=J5AERGAAN552S

The book, Analyzing social media networks with NodeXL:
Insights from a connected world, is available from Morgan Kaufmann and from Amazon.
http://www.amazon.com/gp/product/0123822297?ie=utf8&tag=conneactio-20&linkcode=as2&camp=1789&creative=390957&creativeasin=0123822297

This caption will expand in our next several releases to include information about the top URLs, hashtags, and @usernames in text fields associated with nodes and edges. Following that we will release a series of features to allow for the extraction of keyword pairs in those text fields (our current version of this feature is described here: Keyword Networks: create word association networks from text with NodeXL (with a macro)).

Posted in All posts, Foundation, Measuring social media, Metrics, Network clusters and communities, Network metrics and measures, NodeXL, SMRF, Social Media, Social Media Research Foundation, Social network, Social Network Analysis, Social Theories and concepts, User interface Tagged 2012, 203, Automate, Automatic, Automation, Caption, Chart, Description, Feature, graph, Graph Summary, Narrative, network, NodeXL, SNA< Map, Social Media Research Foundation, Summary, Text, v.203, Visualization

October 19-20, 2011: NYC – Predictive Analytics World: Network Maps for End Users: Collect, Analyze, Visualize and Communicate Network Insights with Zero Coding

17OctMay 7, 2015 By Marc Smith

 

I presented on social media network analysis on October 20, 2011 in New York City at Predictive Analytics World.

A map of the connections among the people tweeting about the #Pawcon hashtag is below.

Network Maps for End Users: Collect, Analyze, Visualize and Communicate Network Insights with Zero Coding

Abstract: Networks are everywhere except the end user desktop.  NodeXL, the free and open network overview, discovery and exploration add-in for the popular and familiar Excel (2007/2010) spreadsheet allows users who are comfortable making pie charts to now make useful network visualizations.  Developed and released by the Social Media Research Foundation, NodeXL uses Excel as a framework, providing a GUI network browser (a “web browser”?) that novices can use quickly and experts can use to generate sophisticated results.  Data importers provide access to a range of social media network data sources like Twitter, flickr, YouTube, Facebook, email, the WWW, and more through standard file formats (CSV, GraphML, Matrix).  Simple to use tools can automatically analyze, visualize and highlight insights in complex network graphs.  Using NodeXL, researchers have been collecting a wide range of network data sets from various social media services.  These images reveal a range of common social formations in social media and point to people who occupy strategic locations in these graphs.

This is a map of the connections among the people who tweeted the term “PAWCON” on the first day of the event:

[flickr id=”6261006732″ thumbnail=”medium” overlay=”true” size=”large” group=”” align=”none”]

These are the connections among the Twitter users who recently tweeted the word #pawcon when queried on October 19, 2011, scaled by numbers of followers (with outliers thresholded). Connections created when users reply, mention or follow one another.

A larger version of the image is here: www.flickr.com/photos/marc_smith/6261006732/sizes/l/in/ph…

Top most between users:
@tapan_patel
@pawcon
@sasanalytics
@deloitteba
@kristinevick
@jamet123
@zementis
@kdnuggets
@tibcospotfire
@saspublishing

Graph Metric: Value
Graph Type: Directed
Vertices: 41
Unique Edges: 233
Edges With Duplicates: 120
Total Edges: 353
Self-Loops: 44
Connected Components: 2
Single-Vertex Connected Components: 1
Maximum Vertices in a Connected Component: 40
Maximum Edges in a Connected Component: 352
Maximum Geodesic Distance (Diameter): 4
Average Geodesic Distance: 1.87133
Graph Density: 0.15304878
NodeXL Version: 1.0.1.179

Here is an example map of the connections among the people who tweeted the term “pawcon” in Twitter on September 14th, a week prior to the event.

[flickr id=”6274836259″ thumbnail=”small” overlay=”true” size=”large” group=”” align=”none”] [flickr id=”6274836151″ thumbnail=”small” overlay=”true” size=”large” group=”” align=”none”]

Manu Sharma, Principle Research Scientist at LinkedIn gave a great presentation on the patterns found in their data.  Big data, for example, showed that most of the people who previously worked at recently failed banks and financial institutions have updated their profiles to show that they mostly have new jobs at some of the remaining companies in the industry.

The event was held at the New York Hilton: Maps & Directions

Posted in All posts, Companies, Conference, Connected Action, Foundation, Measuring social media, Metrics, Network clusters and communities, Network Data Archives, Network data providers (spigots), Network metrics and measures, Network visualization layouts, NodeXL, SMRF, Social Media, Social Media Research Foundation, Social network, Social Network Analysis, Sociology, Talks, User interface, Visualization, Web Application Tagged 2011, Analysis, BI, Chart, Event, graph, Map, Marc Smith, Measure, network, New York, NodeXL, NYC, October, PAW, Predictive Analytics World, Presentation, SNA, Social Media, Social network, Talk, Visualization

NodeXL Graph Gallery on the web: Collectively Authored Archives of Networks

07SepMay 7, 2015 By Marc Smith

The NodeXL team from the Social Media Research Foundation has released a web application that allows users to upload network files and download files other users have uploaded.

The Social Media Research Foundation is dedicated to Open Tools, Open Data, and Open Scholarship.

The NodeXL Graph Gallery on the Web enables the research community to collectively gather and share data sets.

Users of NodeXL will notice a new NodeXL>Data>Export>To Web Gallery menu option which opens this dialog box:

Users will be able to browse the NodeXL Web Gallery for graphs that were recently uploaded:

Users will be able to search for graphs that contain certain keywords:

Users can then get details about the network graph and download those files they would like to investigate.

 

 

Posted in All posts, Foundation, Measuring social media, Network Data Archives, Network data providers (spigots), NodeXL, SMRF, Social Media, Social Media Research Foundation, Social network, User interface, Visualization, Web Application Tagged 2011, Analysis, April, Archive, Collection, Data, Dataset, Download, Federated, Gallery, network, NodeXL, SMRF, SMRFoundation, SNA, Social Media Research Foundation, Social network, Upload, WWW

9 August 2011 – Social Media SNA Workshop – Association for Education in Journalism and Mass Communication (http://www.aejmc.com/)

31JulMay 7, 2015 By Marc Smith

Here is a map of the connections among the people who tweeted the term “AEJMC” on August 7, 2011:

The top most between people in this network are:@aejmc, @jlab, @karenrussell, @terryflynn, @natcomm, @tmccorkindale, @derigansilver, @tkell, @aejmconlineads, and @jeremyhl:

I will present a Workshop on Social Media Network Analysis and NodeXL at the 9 August 2011 – Association for Education in Journalism and Mass Communication (http://www.aejmc.com) in St. Louis, Missouri along with my colleague Professor Hernando Rojas, from the School of Journalism & Mass Communication, University of Wisconsin – Madison.

See: http://www.aejmc.com/home/events/annual-convention/

The Association for Education in Journalism and Mass Communication (AEJMC) is a nonprofit, educational association of journalism and mass communication educators, students and media professionals. The Association’s mission is to promote the highest possible standards for journalism and mass communication education, to cultivate the widest possible range of communication research, to encourage the implementation of a multi-cultural society in the classroom and curriculum, and to defend and maintain freedom of communication in an effort to achieve better professional practice and a better informed public.

Our session is:

Using NodeXL for Social Network Analysis
Tuesday — 
2 pm to 5 pm
Presented by Communication Theory and Methodology Division
This pre-conference workshop examines social network analysis. Social network analysis can be used to examine message boards, blogs, and friend networks (amongmany other phenomena). Participants will learn to use the NodeXL program to conduct a network analysis. For information, contact Michel M. Haigh, Pennsylvania State University at mmh25@psu.edu.

 

Posted in All posts, Collective Action, Common Goods, Community, Conference, Foundation, Measuring social media, Metrics, Network clusters and communities, Network data providers (spigots), Network metrics and measures, Network visualization layouts, NodeXL, Performance scale parallel and cloud computing, SMRF, Social Media, Social network, Social Network Analysis, Social Roles, Social Theories and concepts, Sociology, Technology, User interface, Visualization Tagged 2011, AEJMC, Analysis, August, Chart, Conference, Diagram, Education, Journalism, Map, Marc, Marc Smith, Marc_Smith, Mass Communication, network, NodeXL, Smith, SNA, Social Media, Social network, Visualization, workshop

A legend in your own network graph: NodeXL legend describes data elements

12JunMay 7, 2015 By Marc Smith

Every network visualization should have a legend that explains what the colors, edge widths, and filters are that define the network graph.

NodeXL automatically generates a network legend and displays it when the Graph Elements menu is opened:

And the “Legend” option is selected.

This will place a legend at the bottom of the visualization canvas:

Posted in All posts, Foundation, Network visualization layouts, NodeXL, SMRF, Social Media Research Foundation, Social network, User interface, Visualization Tagged 2011, April, Chart, Design, Feature, graph, Infovis, Legend, Map, network, NodeXL, SMRF, SMRFoundation, Social Media Research Foundation, v.166, View, Visualization

A Sample Settings File for NodeXL: An automated recipie for making Twitter network visualizations

12JunMay 7, 2015 By Marc Smith

Starting in version .165 of NodeXL we have supported the idea of an options file that can be imported, exported and exchanged among users.

If you have set all the knobs and dials of your copy of NodeXL just right, you can export these adjustments and configurations into a single file.  Use the NodeXL>Options>Export feature to create a named file containing your settings.  You can now exchange this file with others.  If you receive an options file, you can use the NodeXL>Options>Import feature to pick it out from the file system and set your copy of NodeXL to the settings defined in that file.

If you use the related NodeXL>Options>Use Current for New feature you can set the defaults for NodeXL to the settings contained in any imported options file.

I have been fine tuning a settings file that generates network visualizations that are tailored for the Twitter networks I have been making many of.  I have saved these sample settings file for NodeXL and you can try them yourself here: NodeXL-Twitter Network-Options Settings.NodeXLOptions.

Download this file, rename it by removing the .txt extension and load it into your copy of NodeXL.

Posted in All posts, Network metrics and measures, Network visualization layouts, NodeXL, User interface Tagged Analysis, Chart, Map, NodeXL, Options, Sample, Settings, Shared Settings, SMRF, SMRFoundation, SNA, Social Media Research Foundation, Social network, Visualization

Posts navigation

Older Posts

Connected Action Services

  • Buy a social media network map
  • Log in or Join us
  • My Cart
  • Training
  • Conferences
  • Data Reporting
  • Customize NodeXL
  • Marc Smith
  • About Us

Subscribe to Connected Action

Get updates when there is new content from Connected Action.

Related content:

Twitter Facebookflickrlinkedin
slidesharedeliciousdeliciousVimeo


Social Media Research Foundation

Help support the Social Media Research Foundation

Book: Analyzing Social Media Networks with NodeXL: Insights from a connected world

The book Analyzing Social Media Networks with NodeXL: Insights from a connected world is now available from Morgan-Kaufman and Amazon.

Communities in Cyberspace

Communities in Cyberspace

Recent Posts

  • Buy a map
  • Book: Transparency in Social Media Edited by Sorin Matei, Martha Russell and Elisa Bertino – with a chapter on NodeXL
  • June 5, 2015: Personal Democracy Forum – Talk on taking pictures of virtual crowds
  • Trust issues and Excel: how to open other people’s NodeXL documents
  • May 1st, 2015 at LSU: NodeXL social media networks talk at the “Telling Stories and Using Visuals for Coastal Environmental Communication” workshop

Tags

2009 2010 2011 2013 2014 2015 Analysis Analytics April Chart Conference Data Event Excel graph June Lecture Map March Marc Smith May Media network NodeXL October Paper Presentation Research San Francisco SMRF SMRFoundation SNA social Social Media socialmedia Social Media Research Foundation Social network Sociology Talk Training Twitter University Video Visualization workshop

Categories

Archives

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Jul    

Transparency in Social Media

2015-07-30-Transparency in Social Media-Structures of Twitter Crowds and COnversations
Transparency in Social Media
Sorin Adam Matei, Martha G. Russell, Elisa Bertino

CÓMO ENCONTRAR LOS HASHTAGS MÁS POTENTES: Para convertir LEADS a VENTAS (SEOHashtag nº 1) (Spanish Edition)

Apply NodeXL in espanol!

CÓMO ENCONTRAR LOS HASHTAGS MÁS POTENTES - Para convertir LEADS a VENTAS (SEOHashtag nº 1) (Spanish Edition)
By: Vivian Francos from #SEOHashtag Comparto algunas de las mejores formas de elegir los hashtags más poderosos y
que puedan generar tráfico a tus redes sociales para aprovechar el poder del
hashtag.
Si quieres aumentar tus interacciones, debes aprender a utilizar los hashtags como herramienta.

https://amzn.to/305Hpsv

Networked


Networked By Lee Rainie and Barry Wellman

Social Media in the Public Sector

2015-07-31Social Media in the Public Sector-Cover
Ines Mergel

Ways of Knowing in HCI

2014-Ways of Knowing in HCI - Olson and Kellogg

The Virtual Community


Virtual Community

The Evolution of Cooperation


The Evolution of Cooperation

Governing the Commons


Governing the Commons

SmartMobs


SmartMobs

Networks, Crowds, and Markets


Networks, Crowds, and Markets

Development of Social Network Analysis


Development of Social Network Analysis: A Study in the Sociology of Science

Search

Services

  • Buy a social media network map
  • Log in or Join us
  • My Cart
  • Training
  • Conferences
  • Data Reporting
  • Customize NodeXL
  • Marc Smith
  • About Us
© 2023 Connected Action
AccessPress Parallax by AccessPress Themes
0

Your Cart