extracting values from log file to excel

[donny008]

Hello All

I am trying to write a macro so that i can extract specific values from the
log file to an excel file. I did try to understand the macro
CustomTabStatFromResults but guess its too much of info for me.

The image sg0000.bmp
is being processed. Kindly wait ...
Initial-  Mean 154.7636, Min 30, Max246, STD9.3166
Modified Min103, Max188
Final details- Mean154.3191, Min 31, Max242, STD8.7668
The image sg0001.bmp
is being processed. Kindly wait ...
Initial-  Mean 155.1983, Min 29, Max245, STD9.5013
Modified Min103, Max188
Final details- Mean154.7540, Min 31, Max242, STD8.9154
The image sg0002.bmp
is being processed. Kindly wait ...
Initial-  Mean 155.5076, Min 30, Max245, STD8.9303
Modified Min103, Max188
Final details- Mean155.0632, Min 33, Max242, STD8.2322


this is the info which i have to save on to an excel file, in different
columns with file name, respective mean, min, max etc

is there any macro already existing so that i could absorb some motivation
from. kindly help

thanks in advance
--
Donny George

[dpoburko]

Hi Donny,

 Have you considered saving all of you data in rows of a text file in
ImageJ then simply import the file into Excel and use the transpose
function in Excel to swap rows for columns? This doesn't exactly address
the problem, but it would quite fast.

Cheers,
Damon

Donny George wrote:

> Hello All
>
> I am trying to write a macro so that i can extract specific values from the
> log file to an excel file. I did try to understand the macro
> CustomTabStatFromResults but guess its too much of info for me.
>
> The image sg0000.bmp
> is being processed. Kindly wait ...
> Initial-  Mean 154.7636, Min 30, Max246, STD9.3166
> Modified Min103, Max188
> Final details- Mean154.3191, Min 31, Max242, STD8.7668
> The image sg0001.bmp
> is being processed. Kindly wait ...
> Initial-  Mean 155.1983, Min 29, Max245, STD9.5013
> Modified Min103, Max188
> Final details- Mean154.7540, Min 31, Max242, STD8.9154
> The image sg0002.bmp
> is being processed. Kindly wait ...
> Initial-  Mean 155.5076, Min 30, Max245, STD8.9303
> Modified Min103, Max188
> Final details- Mean155.0632, Min 33, Max242, STD8.2322
>
>
> this is the info which i have to save on to an excel file, in different
> columns with file name, respective mean, min, max etc
>
> is there any macro already existing so that i could absorb some motivation
> from. kindly help
>
> thanks in advance
>  

--

Damon Poburko, PhD
Postdoctoral Research Fellow
Stanford University School of Medicine
Dept. of Molecular & Cellular Physiology
279 Campus Dr., Beckman B103, Stanford, CA 94305
Ph: 650 725 7564, fax: [phone]

[donny008]

hey damon

thankyou for the post. i think this also would be one possibility. just that
may be i shud arrange my log file in a better way so that the excel
conversion happens without much complexity. but yes macro would be what i am
trying for guess it wud need more effort and time


don

On Fri, Apr 24, 2009 at 6:52 PM, Damon Poburko <[hidden email]>wrote:

> Hi Donny,
>
> Have you considered saving all of you data in rows of a text file in ImageJ
> then simply import the file into Excel and use the transpose function in
> Excel to swap rows for columns? This doesn't exactly address the problem,
> but it would quite fast.
>
> Cheers,
> Damon
>
>
> Donny George wrote:
>
>> Hello All
>>
>> I am trying to write a macro so that i can extract specific values from
>> the
>> log file to an excel file. I did try to understand the macro
>> CustomTabStatFromResults but guess its too much of info for me.
>>
>> The image sg0000.bmp
>> is being processed. Kindly wait ...
>> Initial-  Mean 154.7636, Min 30, Max246, STD9.3166
>> Modified Min103, Max188
>> Final details- Mean154.3191, Min 31, Max242, STD8.7668
>> The image sg0001.bmp
>> is being processed. Kindly wait ...
>> Initial-  Mean 155.1983, Min 29, Max245, STD9.5013
>> Modified Min103, Max188
>> Final details- Mean154.7540, Min 31, Max242, STD8.9154
>> The image sg0002.bmp
>> is being processed. Kindly wait ...
>> Initial-  Mean 155.5076, Min 30, Max245, STD8.9303
>> Modified Min103, Max188
>> Final details- Mean155.0632, Min 33, Max242, STD8.2322
>>
>>
>> this is the info which i have to save on to an excel file, in different
>> columns with file name, respective mean, min, max etc
>>
>> is there any macro already existing so that i could absorb some motivation
>> from. kindly help
>>
>> thanks in advance
>>
>>
>
>
> --
>
> Damon Poburko, PhD
> Postdoctoral Research Fellow
> Stanford University School of Medicine
> Dept. of Molecular & Cellular Physiology
> 279 Campus Dr., Beckman B103, Stanford, CA 94305
> Ph: 650 725 7564, fax: [phone]
>

--
Donny George

[Fernando Sales]

Hi Donny,

try to use the ResultsTable from IJ. After throw your results there, you can
use a command to automatically save your results into a .xls file. It's an
easy, fast and simple solution to your problem.

Best regards,
Fernando

On Mon, Apr 27, 2009 at 9:27 AM, Donny George <[hidden email]> wrote:

> hey damon
>
> thankyou for the post. i think this also would be one possibility. just
> that
> may be i shud arrange my log file in a better way so that the excel
> conversion happens without much complexity. but yes macro would be what i
> am
> trying for guess it wud need more effort and time
>
>
> don
>
> On Fri, Apr 24, 2009 at 6:52 PM, Damon Poburko <[hidden email]
> >wrote:
>
> > Hi Donny,
> >
> > Have you considered saving all of you data in rows of a text file in
> ImageJ
> > then simply import the file into Excel and use the transpose function in
> > Excel to swap rows for columns? This doesn't exactly address the problem,
> > but it would quite fast.
> >
> > Cheers,
> > Damon
> >
> >
> > Donny George wrote:
> >
> >> Hello All
> >>
> >> I am trying to write a macro so that i can extract specific values from
> >> the
> >> log file to an excel file. I did try to understand the macro
> >> CustomTabStatFromResults but guess its too much of info for me.
> >>
> >> The image sg0000.bmp
> >> is being processed. Kindly wait ...
> >> Initial-  Mean 154.7636, Min 30, Max246, STD9.3166
> >> Modified Min103, Max188
> >> Final details- Mean154.3191, Min 31, Max242, STD8.7668
> >> The image sg0001.bmp
> >> is being processed. Kindly wait ...
> >> Initial-  Mean 155.1983, Min 29, Max245, STD9.5013
> >> Modified Min103, Max188
> >> Final details- Mean154.7540, Min 31, Max242, STD8.9154
> >> The image sg0002.bmp
> >> is being processed. Kindly wait ...
> >> Initial-  Mean 155.5076, Min 30, Max245, STD8.9303
> >> Modified Min103, Max188
> >> Final details- Mean155.0632, Min 33, Max242, STD8.2322
> >>
> >>
> >> this is the info which i have to save on to an excel file, in different
> >> columns with file name, respective mean, min, max etc
> >>
> >> is there any macro already existing so that i could absorb some
> motivation
> >> from. kindly help
> >>
> >> thanks in advance
> >>
> >>
> >
> >
> > --
> >
> > Damon Poburko, PhD
> > Postdoctoral Research Fellow
> > Stanford University School of Medicine
> > Dept. of Molecular & Cellular Physiology
> > 279 Campus Dr., Beckman B103, Stanford, CA 94305
> > Ph: 650 725 7564, fax: [phone]
> >
>
>
>
> --
> Donny George
>