Hi Susan, Well, if I remember right from my clinical days, the way I did it was something like this: In Cell Quest, it is important to keep files incrementing by value 001 and keep each patient files in separate folder. Then you go to menu Batch, under Setup tick "Export statistics", under "New File..." button choose where to save it. Set pause after each file increment to "manual" so you can adjust any regions between files, if necessary. When you run Batch, you'll see funny play/pause/stop control bar and just "play" file by file. Every time you press play, export file is being added with a new row for that data file and parameters (%gated, %total...) in its columns. It's useful to turn off any stats you don't need in "Stats/Edit region Stats", otherwise you get staff like "no gate", "linear values" as a column for each file. Once you finish batching, you can open generated file in Excel or Claris Works (it's just tab-deliminated) and copy desirable percentage columns into the patient form. I kept forms standardised as a Claris Spreadsheet templates and had a rigid panels (even order of tubes shouldn't change) to make this work. Hope it'll help, Sasha. ************ Dr Sasha Sreckovic Dept Path & Micro University of Bristol University Walk Bristol, BS8 1TD, UK Sasa.Sreckovic@bristol.ac.uk +44-(0)117-928-8606 ************ > From: sschmitt@idecpharm.com > Date: Mon, 13 Nov 2000 11:10:05 -0800 > To: Cytometry Mailing List <cytometry@flowcyt.cyto.purdue.edu> > Subject: Reports from Cell Quest? > > > Hello! > > I will be getting a FACS Calibur shortly. We are running anything but > routine panels on the samples we analyze. I would like to print reports > easily based on the Cell Quest Data. I know the Cell Quest data can be > dumped to an Excel spreadsheet. But I do not have experience getting it > from there into a summary report by patient (this report will need to have > the demographic information as well). Is there anyone out there who any > experience or advice as to how to end up with a patient report from Cell > Quest data? Any vendors software or consultant recommendations would be > greatly appreciated. > > > I have worked with Coulter XL--and they have a reporting software which > works fairly easily from data directly analyzed on the Coulter. > > Thanks for your help in advance. > > Sue > > Susan M. Schmitt > Manager, Clinical Immunology > IDEC Pharmaceuticals > 3010 Science Park Road > PO Box 919080 > San Diego, CA 92191-9080 > Ext. 8492 > > >
This archive was generated by hypermail 2b29 : Wed Apr 03 2002 - 11:56:14 EST