***** To join INSNA, visit http://www.insna.org ***** Cut and paste works for me!! Hartti Suomela <[log in to unmask]> Sent by: Social Networks Discussion Forum <[log in to unmask]> 01/09/06 12:40 PM Please respond to Hartti Suomela To: [log in to unmask] cc: Subject: Re: Converting Excell into UCINET ***** To join INSNA, visit http://www.insna.org ***** Have you tried copy-paste from Excel to the UCINET's Spreadsheet view (select Data->Spreadsheets) and saving then this file as UCINET file Hartti On 1/9/06, Maksim Tsvetovat <[log in to unmask]> wrote: > ***** To join INSNA, visit http://www.insna.org ***** > > > I am trying to convert affiliation matrix from EXCELL into UCINET6. The > > program does not do it. What could be the reason for it ? I have varying > > sizes of matrices , some of them are 1200 actors x 300 events, but the > > smaller (145X49) are not converted as well. > > Excel filter seems to depend on certain Microsoft-isms that no longer > exist in modern > versions of MS Office; exporting Excel into an older format (Excel > '97) might help but most > likely will not - it looks like certain "features" in the format were > "fixed" by MS. > > I would suggest exporting to a text file (CSV) and importing that - > or, if all else fails, exporting > to a text file, writing DL headers by hand and importing the resulting > DL file (see manual for > DL format). > > Yes, this is a pain. And a bug in the software. Steve Borgatti, can > you hear us? :-) > > Max > > _____________________________________________________________________ > 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. > _____________________________________________________________________ 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. _____________________________________________________________________ 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.