Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forecasting/Estimation using arrays
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula required for elapsed days for fund estimation | Excel Discussion (Misc queries) | |||
Calculation Time estimation | Excel Discussion (Misc queries) | |||
Forecasting with arrays | Excel Programming | |||
Forecasting using arrays | Excel Worksheet Functions | |||
maximum likelihood estimation of weibull parameters | Excel Programming |