PutAppend Command and Data Output
- To: mathgroup at smc.vnet.net
- Subject: [mg49695] PutAppend Command and Data Output
- From: "Daniel Kramer" <boydkramer at hotmail.com>
- Date: Thu, 29 Jul 2004 07:43:02 -0400 (EDT)
- Sender: owner-wri-mathgroup at wolfram.com
There should be a simple solution to this problem, but I am stumped.
Wolfram support is unhelpful as well. I am running a simulation model with
six differential equations. I would like to store the ending values for
these six variables in spreadsheet form as I perform sensitivity analyses on
the parameter values. So I define the ending values for my variables...
hend=Evaluate[h[time]/.sol;
pend=Evaluate[p[time]/.sol;
shend=Evaluate[sh[time]/.sol;
spend=Evaluate[sp[time]/.sol;
aend=Evaluate[a[time]/.sol;
cend=Evaluate[c[time]/.sol;
I then append these values to an existing spreadsheet file. The problem is
that the ending values are always added to my file in a 2 by 3 matrix
instead of a 1 by 6 row matrix. See the ?PutAppend? command line below and
the output. I have tried putting the output in a 6 by 1 column matrix and
this works by using the following in my PutAppend command -
{{hend},{pend},{shend},{spend},{aend},{cend}}. This works fine but data is
appended down the spreadsheet instead of in columns which is as cumbersome
as my original problem. The other minor problem is the brackets in my
output. I wish they weren?t there. Perhaps these two problems are related?
Are the values in a form that Excel has trouble reading? I would greatly
appreciate anyone?s help.
PutAppend[{hend,pend,shend,spend,aend,cend},?output.csv?]
hend pend shend spend aend cend
{{84.44222381154862} {17.295098646610068} {0.9999464544412083}
{0.00005354555879104163} {0.6314412255157023} {0.16406999044034634}}
By the way, if I add the following line as a test, it works perfectly,
adding a 1 by 6 row vector to the spreadsheet file.
PutAppend[{1,2,3,4,5,6},?output.csv?]
Daniel Kramer
_________________________________________________________________
Overwhelmed by debt? Find out how to ?Dig Yourself Out of Debt? from MSN
Money. http://special.msn.com/money/0407debt.armx
- Follow-Ups:
- Re: PutAppend Command and Data Output
- From: DrBob <drbob@bigfoot.com>
- Re: PutAppend Command and Data Output