Services & ResourcesWolfram ForumsMathGroup Archive

[Date Index] [Thread Index] [Author Index]

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>