Help me!!

[skc]

Hi

I am using Excel 2000 and wish to know how I can graph
some data.

The data is car data, these arrive in batches - assigned
by a batch number. The batches differ in size, one batch
could have 20 records, yet another could have 3. The
values of the cars differ too.

The whole emphasis here is to find out how much (money-
wise) cars have been issued in the batches, and find out
whether they are getting less and less.

I want to create normalised graphs and %'ages of total
amounts within the batch - as I feel that the cars we are
receiving are worthless compared to before. What I mean
by this is that Batch 1-3 were high valued cars, such as
Mercedes, and now we are getting run-of-the-mill cheapies -
such as Fords that are 1/3 of the price of a Mercedes -
hence why this is affecting our profits - we make higher
profits on the bigger cars.

My Excel sheet has these fields:

1. Batch Number : e.g. 001
2. Area where vehicle came from : AB3
3. Value of the vehicle : £20,000

I have not got a batch count field - as I said earlier,
batches are of different sizes, they could be 20, 2, 43
etc...

What graphs can I make or additional mathematical formulae
to make my results look professional, as I know for a fact
that our supplier is now passing onto us rubbish cars.

I need some stats fields and normalised graphs etc... but
I do not know where to start - I need help!!

Please help.

skc

 

[Tushar Mehta]

As a first pass...

If the data are in a table (column 1 has batch #, col. 2 has the area,
col. 3 has the value field), create a PivotTable with the batch # as
the row field and the average of the value as the data field. Now, if
the batch number field also reflects a chronological sequence, check if
the computed average is trending down.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[skc]

Sorry - I need help!

Here are my column headings transposed:

BATCH# I001
COMPANY xxx ltd
ZIP W1K 6NR
ZIP_NONUM WK
MONEY 894.91
BATCH 20030729_I001_LEI
BATCH_ORIGIN LEI
BATCHDATE 20030729

HELP!!

There are around 20 batches. No of records differ in each
batch, so I need money as percentage of total for the
batch, I need normalised graphs to show values.

skc

 

[Tushar Mehta]

I'm sure your description makes sense to you, but I am totally at sea.
I don't understand the format of the data (or what you transposed and
why). Nor do I understand the concept of "money as percentage of total
for the batch" or "normalised graphs to show values." Hopefully,
someone else will be able to help out.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions