I prefer to create edge lists for any network greater than 30 nodes. An edge list can be made in Excel by considering each row to be a link. One column should be a source column, and another should be a target column. You can also record information such as the source of data, time of validity, weight, etc. Most SNA packages will read in an edge list. Ian McCulloh, PhD West Point Sent via BlackBerry by AT&T -----Original Message----- From: Brian Keegan <[log in to unmask]> Date: Thu, 4 Mar 2010 09:51:58 To: <[log in to unmask]> Subject: Re: [SOCNET] Matrix bigger than 256*256 ***** To join INSNA, visit http://www.insna.org ***** You might consider using edgelists to store and play with the data in Excel, then using UCINET, Pajek, or other tools to read the edgelists into matrix structures for network analysis. On Thu, Mar 4, 2010 at 6:40 AM, Clement Levallois <[log in to unmask]> wrote: > ***** To join INSNA, visit http://www.insna.org ***** > > Dear list members, > > > > I must betray my ignorance: starting my first social network analysis based > on a survey citing 450+ names, and used to work with Excel, I was wondering > how members of this list create matrices bigger than 256*256? (Excel is > limited to 256 columns). > > > > Solutions would have included switching to Open Office Calc, which accepts > 1022 columns, or using more sophisticated softwares. > > > > But those of you used to Excel and VBA might be interested in the release > of Excel 2010, available for free in beta version, which takes up to ** > 16384** columns: problem solved! > > > > Best wishes, > > > > Clement > > > > > > ___________________ > > Clement Levallois > > Rotterdam School of Management | Erasmus Studio KNAW > > Erasmus University > > Room T10-16 > > Burg. Oudlaan 50, 3062 PA Rotterdam > > The Netherlands > > > > tel +31-10-4082578 | fax +31-10-4089011 > > email [log in to unmask] | www.clementlevallois.net > > > > > > > > > > ------------------------------ > Disclaimer > De informatie verzonden in dit e-mail bericht inclusief de bijlage(n) is > vertrouwelijk en is uitsluitend bestemd voor de geadresseerde van dit > bericht. Lees verder: http://www.eur.nl/email-disclaimer. > > The information in this e-mail message is confidential and may be legally > privileged. Read more: http://www.eur.nl/english/email-disclaimer. > ------------------------------ > > _____________________________________________________________________ > SOCNET is a service of INSNA, the professional association for social > network researchers (http://www.insna.org). To unsubscribe, send an email > message to [log in to unmask] containing the line UNSUBSCRIBE SOCNET > in the body of the message. -- Brian C. Keegan Ph.D. Student - Media, Technology, & Society School of Communication, Northwestern University Science of Networks in Communities, Laboratory for Collaborative Technology, Center for Technology & Social Behavior _____________________________________________________________________ SOCNET is a service of INSNA, the professional association for social network researchers (http://www.insna.org). To unsubscribe, send an email message to [log in to unmask] containing the line UNSUBSCRIBE SOCNET in the body of the message.