Hello.
I work with very large arrays (50000 x 15) that often have to be transferred
through my network.
What is the cheapest way (resource-wise) way to transfer this array from one
computer to the other?
Should I create a CSV?
Should I transfer it as an Excel workbook?
Is there a better way?
I thank you in advance for your advice.
Albert C.

Using .cvs files allows transfers:

1. without worrying about the version of Excel in the recipient's computers
2. without worrying about the security levels in the recipient's computers
3. in a form that can be manually inspected
4. in a form that can usually be ZIP'ed to a high level of compression

The issue is why wouldn't you ?
--
Gary's Student


"Albert" wrote:

> Hello.
> I work with very large arrays (50000 x 15) that often have to be transferred
> through my network.
> What is the cheapest way (resource-wise) way to transfer this array from one
> computer to the other?
> Should I create a CSV?
> Should I transfer it as an Excel workbook?
> Is there a better way?
> I thank you in advance for your advice.
> Albert C.

I think I'd just keep the data in an excel file. If the data is used in several
workbooks, I'd think about putting that common data in a single workbook,
though.

I gotta believe you'd save more resources ($$$) by not having to fiddle with the
data--and not having the recipient fiddle with it at his/her end.


Albert wrote:
>
> Hello.
> I work with very large arrays (50000 x 15) that often have to be transferred
> through my network.
> What is the cheapest way (resource-wise) way to transfer this array from one
> computer to the other?
> Should I create a CSV?
> Should I transfer it as an Excel workbook?
> Is there a better way?
> I thank you in advance for your advice.
> Albert C.

--

Dave Peterson

This is the road I've taken, but it's kind of a hassle opening a file this
big (>6MB and growing) through the network so many times each day.

"Dave Peterson" wrote:

> I think I'd just keep the data in an excel file. If the data is used in several
> workbooks, I'd think about putting that common data in a single workbook,
> though.
>
> I gotta believe you'd save more resources ($$$) by not having to fiddle with the
> data--and not having the recipient fiddle with it at his/her end.
>
>
> Albert wrote:
> >
> > Hello.
> > I work with very large arrays (50000 x 15) that often have to be transferred
> > through my network.
> > What is the cheapest way (resource-wise) way to transfer this array from one
> > computer to the other?
> > Should I create a CSV?
> > Should I transfer it as an Excel workbook?
> > Is there a better way?
> > I thank you in advance for your advice.
> > Albert C.
>
> --
>
> Dave Peterson
>

Save it as a text file and give the users a workbook that opens the text file
and imports it each time they need it???

Albert wrote:
>
> This is the road I've taken, but it's kind of a hassle opening a file this
> big (>6MB and growing) through the network so many times each day.
>
> "Dave Peterson" wrote:
>
> > I think I'd just keep the data in an excel file. If the data is used in several
> > workbooks, I'd think about putting that common data in a single workbook,
> > though.
> >
> > I gotta believe you'd save more resources ($$$) by not having to fiddle with the
> > data--and not having the recipient fiddle with it at his/her end.
> >
> >
> > Albert wrote:
> > >
> > > Hello.
> > > I work with very large arrays (50000 x 15) that often have to be transferred
> > > through my network.
> > > What is the cheapest way (resource-wise) way to transfer this array from one
> > > computer to the other?
> > > Should I create a CSV?
> > > Should I transfer it as an Excel workbook?
> > > Is there a better way?
> > > I thank you in advance for your advice.
> > > Albert C.
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson