Oops, sorry, missed out

A5= Kiwi
B5= 0.66667
C5= 40
A6 = Grapes
B6= 0.6667
C6= 80

Rgds


On 26 Apr 2006 16:21:06 -0700, "Richard" <[email protected]>
wrote:

>Perhaps a more generalised solution would be preferable. Try the
>following
>
>B1 = No of Cartons
>C1= 70
>D1= 40
>B2= Carton Size (grams)
>C2= 200
>D2= 400
>B3= Waste Factor
>E3= Total Purchase Weight (Kg)
>A4= Pineapple
>B4= 0.66667
>C4= 80
>D4= 400
>E4= =SUMPRODUCT(C4:D4,$C$1:$D$1)/1000*1/(1-B4)
>Copy E4 down to E5 & F5
>
>E4:E6 represents the total weight of each of your fruits.
>
>I've assumed the waste factor is the same for each fruit, i.e. 0.6667,
>but just change B4:B6 where necessary if they are different.
>
>You might also like to put in a sum of C4:C6 and D4:D6 in say C8 & D8
>just to check that the individual fruit weights add up to the carton
>weight.
>
>Hope this is useful. Next time I'm your way I'll come and sample some
>:-)
>
>Regards,
>
>Richard Buttrey

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________