Re: Help me!!

From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 03/02/04 

Date: Tue, 02 Mar 2004 18:13:05 GMT

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
In article <580f01c4007f$fc447d10$a301280a@phx.gbl>, 
anonymous@discussions.microsoft.com says...
> 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
> >> 
> >.
> >
>