software

Hi,
I'm trying to sort through a very large amount of data, and to get averages
from it. (14800 ows in the full version !!). What I need to do is

1) Find out how many times each DELAY (column B1) appears for each AIRLINE
(A1) and give a total for each airlines (This is to show which delay affects
individual airlines the most)

2) Add up the CPU time spent on delays for each airline

3) Collate the number of ABENDs-periairline, and CPU time-per-airlines in to
a grand total

I need hedlp with this one as it is totally out of my depth.

A1 B1 C1
AIRLINE DELAY TIME
______ _____ ____
Air MarocALTGET -0.19
CLIMM -0.55
ALTGET -0.06
FLPOSS -0.04
FPCLC -0.08
NALSL -0.63
PARMAA -0.02
PRTPLN -2.69
RCRFFL -0.02
SECDES -0.03
TRGIN1 -0.02
XSPTPT -0.01
ZCRTAB -0.02
Total4.36

Air indiaALTGET -0.27
CH2INT -0.03
CLCALC -0.02
CLIMM -0.65
FLPDT -0.07
FPCLC -0.02
PARMWX -0.15
PRTPLN -0.3
VERALT -0.01
YSTART -0.04
TotalThanks for reading this - i hope you can help,
Brgds - Nick

Hi
Have you had a look at Data / Sort,
Data / subtotals and Data / filtering

HTH
Michael

quot;daviesncquot; wrote:

gt; Hi,
gt; I'm trying to sort through a very large amount of data, and to get averages
gt; from it. (14800 ows in the full version !!). What I need to do is
gt;
gt; 1) Find out how many times each DELAY (column B1) appears for each AIRLINE
gt; (A1) and give a total for each airlines (This is to show which delay affects
gt; individual airlines the most)
gt;
gt; 2) Add up the CPU time spent on delays for each airline
gt;
gt; 3) Collate the number of ABENDs-periairline, and CPU time-per-airlines in to
gt; a grand total
gt;
gt; I need hedlp with this one as it is totally out of my depth.
gt;
gt; A1 B1 C1
gt; AIRLINE DELAY TIME
gt; ______ _____ ____
gt; Air MarocALTGET -0.19
gt; CLIMM -0.55
gt; ALTGET -0.06
gt; FLPOSS -0.04
gt; FPCLC -0.08
gt; NALSL -0.63
gt; PARMAA -0.02
gt; PRTPLN -2.69
gt; RCRFFL -0.02
gt; SECDES -0.03
gt; TRGIN1 -0.02
gt; XSPTPT -0.01
gt; ZCRTAB -0.02
gt; Total4.36
gt;
gt; Air indiaALTGET -0.27
gt; CH2INT -0.03
gt; CLCALC -0.02
gt; CLIMM -0.65
gt; FLPDT -0.07
gt; FPCLC -0.02
gt; PARMWX -0.15
gt; PRTPLN -0.3
gt; VERALT -0.01
gt; YSTART -0.04
gt; Total
gt;
gt;
gt; Thanks for reading this - i hope you can help,
gt; Brgds - Nick