***** 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.
