@\ David Bourne \HB d MbP?"*+_%1 Geneva1 Geneva1 Geneva1 Geneva1 Geneva&FPage &P&?'?(?)? @ NONMEM-Data# AL384A097E,YV General00.00#,##0 #,##0.00#,##0_);\(#,##0\)#,##0_);[Red]\(#,##0\)#,##0.00_);\(#,##0.00\)#,##0.00_);[Red]\(#,##0.00\)"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)0%0.00% 0.00E+00 #\ ?/? #\ ??/?? m/d/yy  d\-mmm\-yy d\-mmm mmm\-yy h:mm\ AM/PMh:mm:ss\ AM/PMh:mm h:mm:ss m/d/yy\ h:mm chartChart1 ( curr_id#  data NONMEM-Data    delete_text,( delzero,4 ids make_chart,@ amake_nonmem_chart, aposition a a aput,I aa total_datawhichcC C  C  C  C  C C C C C C C C C C C  C  C  C  C  C  U } I}  \X o6D0o> eH3 / 2 + e o're%S 8a%7$"(?~FO @2kcGraphing NONMEM Tables with EXCEL by Mark Sales, Department of Pharmacology, Georgetown University.Readme: To use this macro, the data must be parsed into columns. To parse data, use the parse or the smart parse command (in flatfile.xla)@8Id number in column 1, x axis in column 2, y in column 3,$All lines with text will be deleted.kcIf you chose to, all lines with 0 in column 2 (i.e., doses) will also be deleted from the data set.aYTo use this macro, the following cells must be defined as commands (formula, define name)D<Define A13 to be a command (any name, cntrl key if you like)/'Define A41 to be delete_text, a command+#Define A53 to be delzero, a command. &Define A65 to be make_chart, a command' Define A74 to be put, a command make_nonmem_chart() BWaOCWarning, data set will be changed, lines with text will be deleted!Bv@ %WYA#dataBBX!*#B4"DX #"B!*# B3!curr_id/ $BX whichBX idsBX$ total_datBX;))$BNABzh^Please delete first blank column (or run smart parse with "Remove extra blank spaces" checked)BvB7AB0q$CBNAAK9U$CABNC/ A. idsC BX4"  total_datCBX 0 !"%6#$%% >&4()*'+I,G-J./70o17er2 S4a56'7F8H9J:;7<=7> A!!*#B"A!#CBg$S1Bm0%B T&B7( delete_text#)positionBXE*3$C BNAA&AC+1$C mBNABF,4I$C "NBm-B63.! positionC BX/A30! positionC eBX1A2B74delzero#5positionBXB60$C BNAAD72$C aBN BF84 $C "NBm9B63:! positionC BX;A3<! positionC UBX=A>B7@ AB.6C D(E> F%G.IJK^L%M#N+O%P3oQ%reR0S S%aT"UMWXPY[T@ make_chart*A $BmB Bw$CchartBBXD BH!ECBg*F !$BmGB7 IputZJH $CC (C D7"NB2!KCBgL B5'MCBP!NCB`/OC C SBP!PC B`,QwhichC ( BX!RC BgS idsBXIT7curr_idK$C 9&"NBXUB7~ WI@~ WI@~ Wy@~ Wb@W Delete Doses~ X*@~ XI@~ XQ@~ Xy@~ XN@)X!delete rows with 0's in column 2?X~ Y?~ Y>@~ Y>@~ YI@~ Y>@ YOK+[#Modified (slightly) by David Bourne= ,+`> \\\"