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.
Transference of data into NONMEM
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.
_______________________________________________________