Re: Help me!!

From: skc (anonymous_at_discussions.microsoft.com)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 09:58:36 -0800

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

>-----Original Message-----
>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
>
>In article <575f01c40072$035c0310$a501280a@phx.gbl>,
>anonymous@discussions.microsoft.com says...
>> 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 *** 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
>>
>.
>

Loading