V
vijaya
Hi,
I have a list of ITems Unit quantity and prices. I need to use this data to
estimate the cost of the items for different quantity using the previous
costs.
I used the forecast funtion, but the problem is i have lot of items,
If a new item is considered it has to check all the items present in the
data base, check the quantity and costs, use that information and estimate
the cost of the items new quantity.
Example:
Item quantity Cost
Apples 2 20
Cherries 3 10
Guavas 1 5
Peaches 2 6
Apples 3 30
Guavas 3 10
ORanges 5 6
Peaches 3 10
Cherries 5 40
Apples 4 40
Guavas 5 15
Peaches 10 35
ORanges 10 15
Cherries 6 45
Guavas 2 5
PEaches 5 14
The data is arranged in the above manner with different item names, quantity
and cost,
Now I have the following data in another sheet, or i can put it in the same
sheet as above.
Data:
ITem Quantity
Peaches 40
ORanges 30
Cherries 10
Apples 20
Bananas 30
The cost of 40 peaches has to be estimated/forecasted using the previous
list of data. It has to see the qunatity and cost for peaches and has to
estimate for the present quantity. And as bananas is not in the list it has
to return as Forecast not available/// Same sort of estimation of price for
all the remaining items also has to be done
I could use the forecasting technique if i have less data, by arranging the
data incolumns, but i had so much of data that i had to arrange in rows, i
got
nearly 25000 rows of data containing quantity and cost.
Any clue how to do this..
Either using the addins, statistical functions and arrays...
I have a list of ITems Unit quantity and prices. I need to use this data to
estimate the cost of the items for different quantity using the previous
costs.
I used the forecast funtion, but the problem is i have lot of items,
If a new item is considered it has to check all the items present in the
data base, check the quantity and costs, use that information and estimate
the cost of the items new quantity.
Example:
Item quantity Cost
Apples 2 20
Cherries 3 10
Guavas 1 5
Peaches 2 6
Apples 3 30
Guavas 3 10
ORanges 5 6
Peaches 3 10
Cherries 5 40
Apples 4 40
Guavas 5 15
Peaches 10 35
ORanges 10 15
Cherries 6 45
Guavas 2 5
PEaches 5 14
The data is arranged in the above manner with different item names, quantity
and cost,
Now I have the following data in another sheet, or i can put it in the same
sheet as above.
Data:
ITem Quantity
Peaches 40
ORanges 30
Cherries 10
Apples 20
Bananas 30
The cost of 40 peaches has to be estimated/forecasted using the previous
list of data. It has to see the qunatity and cost for peaches and has to
estimate for the present quantity. And as bananas is not in the list it has
to return as Forecast not available/// Same sort of estimation of price for
all the remaining items also has to be done
I could use the forecasting technique if i have less data, by arranging the
data incolumns, but i had so much of data that i had to arrange in rows, i
got
nearly 25000 rows of data containing quantity and cost.
Any clue how to do this..
Either using the addins, statistical functions and arrays...