From: Paul Westwood pwestwood02@qub.ac.uk
Subject: [NMusers] Transference of data into NONMEM
Date: 21 Aug 2006 13:12:55 +0000

Hello all,

I know this is an age old question, but one that i'm still having problems
with. How does one transfer data over from, say, excel, without having to
manipulate the data after? I'm just starting work on a large data file, and
it would be nice not to have to replace all the tabs with spaces etc.
Thanks in advance.

Paul Westwood,
QUB. 
_______________________________________________________

From: "Bachman, William (MYD)" bachmanw@iconus.com
Subject: RE: [NMusers] Transference of data into NONMEM
Date: Mon, 21 Aug 2006 09:44:23 -0400

Just save it as a .csv file (preferably) or a space delimited file.  But
not tab-delimited.
_______________________________________________________

From: Mark Sale - Next Level Solutions com
Subject: RE: [NMusers] Transference of data into NONMEM
Date: Mon, 21 Aug 2006 06:59:47 -0700

Use Excel Save As.. then under Save As Type (near bottom) choose
Formatte Text (space delimited).  

Mark Sale MD
Next Level Solutions, LLC
www.NextLevelSolns.com
_______________________________________________________

From: Mark Sale - Next Level Solutions com
Subject: RE: [NMusers] Transference of data into NONMEM
Date: Mon, 21 Aug 2006 07:46:18 -0700 

Paul, 
  If interested, I just put up an excel macro for creation of NONMEM
data sets
http://www.nextlevelsolns.com/downloads.html

Mark Sale MD
Next Level Solutions, LLC
www.NextLevelSolns.com
_______________________________________________________

From: Paul Westwood pwestwood02@qub.ac.uk
Subject: RE: [NMusers] Transference of data into NONMEM
Date: 21 Aug 2006 15:06:32 +0000

Thanks for the replies. Tried what you suggested, and it was saved as a .prn file, but i was then
unable to open it. Ran NONMEM and it got so far, but then there seemed to be no space between the
dose and the concentration values which caused an error with MDV and the number of characters. Can
you think what's happening, or what i'm doing wrong?

Paul.
_______________________________________________________

From: Mark Sale - Next Level Solutions com
Subject: RE: [NMusers] Transference of data into NONMEM
Date: Mon, 21 Aug 2006 08:19:02 -0700

Paul,
   You need to right justify everything (except any rows that are
commented out, as the first character in these rows must be in column
1.)  Excel, by default left justifies text and right justifies numbers.
 So, if you don't right justify everything, the numbers (on the right)
will be adjacent to (no space between) any "." text, for missing DVs or
doses, following it.  I prefer .prn file over .csv, since I can read
them more easily, (and I always hand verify some fraction of the data).
BTW, you need to close the file in Excel before running NONMEM.  NONMEM
doesn't know about sharing (sort of like my children) when it comes to
files - if it is open in Excel, NONMEM will be unable to open it.

Mark Sale MD
Next Level Solutions, LLC
www.NextLevelSolns.com
_______________________________________________________

From: "Bachman, William (MYD)" bachmanw@iconus.com
Subject: RE: [NMusers] Transference of data into NONMEM
Date: Mon, 21 Aug 2006 11:49:53 -0400

The .csv files are preferred because Excel can screw up .prn files.  (If
lines are too long it takes the remainder of the line and puts them
under the first part of the line.  ALL of the "remainders", under ALL of
the "first parts" of the lines.
_______________________________________________________

From: "TRANCHAND BRIGITTE" Brigitte.TRANCHAND@adm.univ-lyon1.fr
Subject: RE : [NMusers] Transference of data into NONMEM 
Date: Tue, 22 Aug 2006 09:02:01 +0200

In excel, if columns are too narrow to visually separate the numbers, saving in
ASCII (.prn, .txt,..) lead to no space between the numbers. 
Transform the formula into numbers. Fix the number of digits (regarding what is
reasonably significant), enlarge the columns up to separate visually the numbers,
and save as you prefer .prn, .txt, .csv. 

Hope this help
Brigitte
_______________________________________________________

From: Paul Westwood pwestwood02@qub.ac.uk
Subject: RE: [NMusers] Transference of data into NONMEM
Date: 22 Aug 2006 10:54:46 +0000

Dear all,

The way the data was presented in the excel file and the way it was formatted was the
problem, so thanks for that. I never would have thought that the way a data set was
presented visually can have any effect on the transference of the data (and I also
wondered how many times you threw your laptop at the wall before you figured it out,
Brigitte...). Thanks again to all for your help.

Paul. 
_______________________________________________________