Search results

HI Debraj, The real life situation - we will juices, 10 different flavours - orange, peach etc, on 11 different production lines - cans, bottles, pet, etc. there is a restriction on the combination of different flavours than can run simultaneously. i.e we cannot run a mango flavour on more...

HI BOB, thanks for responding. I am looking for a formula or code that will actually generate that list of 60 combinations.

I have 3 lists of products which are produced on a line Line1 Line2 Line3 Apple Mango Mango Mango Orange Orange Orange Guava Pineapple Pineapple Guava Guava the total number of combinations for the three lines are 5 x 3 x 4 = 60 i.e eg Apple Mango Mango;Apple Mango Orange etc... Is...

Recently Chandoo posted a article on highlighting Row/column of selected cell. A simple and yet very elegant step. I am trying to apply the trick to a pivot table. How can this be done on a pivot table? It works fine as a first step however when a field in expanded / collapsed the formating...

How are the charts shown in the link below created. Can this be done in Excel. It has many interesting features a. as you move the cursor it shown the various metrics for that point b. we can choose the period of display 1 day, 1 month, 3 months etc c. at the bottom there is a slider from...

I have a pivot table with 4 different page filters. How can the filters be reset to show data based on what is selected in the other page filters. Example 1st filter is Country - say India, US, UAE 2nd filter is states within the respective country - Maharashtram, MP etc for India, dubai...

We get our forecast as per gregorian calendar ProductA Jan 5000units ProductA Feb 7000units etc WE run MRP by calendar weeks and follow a 4-4-5 week pattern. Which means there will be a overflow of days across calendar months. A week begins on saturday and ends on a friday. example...

Any good resources on excel Cube functions. With the increasing popularity "Powerpivot" mastering these functions will be helpful in creating asymmetric reports. Would like to see more topics on Powerpivot on this forum.

I have two sheet, the first has the demand of each product Product Qty a 5 b 6 The second sheet has the bill of material (what is needed to make the product) for each product Product Material Qty a Materia a 1 a Materia c 2 a Materia g 4 a Materia g 7 b Materia a 1 b Materia c 2 b...

Guys any help possible?

Thanks Luke, the formulas did work fine. With the same data set i need to generate more statistics like the maximum and minimum gaps between two runs ("x"). Please help

HI Luke, Thanks for your response. the above formula is not working. Let me try to explain my question. The first column is a series of dates, with no gaps. i.e 1st Jan to 31st Jan (31 rows with no missing dates) The second column contains the quantity of a particular product produced on a...

I need to count the number of runs of each product in a range. Each run could span over 1 to 4 days. How can this be done Proudct A 01-Jan 5000 First Run 02-Jan 15000 First Run 03-Jan 04-Jan 05-Jan 3000 Second Run 06-Jan 12000 Second Run 07-Jan 08-Jan 15000 Third run 09-Jan 15000...

TYPE PRODUCT Period1 Period2 Period3 FCST APPLE 10 15 20 FCST ORANGE 20 15 10 FCST MANGO 15 15 15 Profit APPLE 2 2.25 1.75 Profit ORANGE 3 1 3 Profit MANGO 4 4 4 Result Area Total Profit Apple(B13)=SUMPRODUCT("FCST"&B13,"PROFIT"&B13) result = #VALUE...

Ulrik, this gives a #ref error. Please note the numbers "1111" are not cell references but product names, they could have been "apple","mango". Efficitenly my range name could be FCSTApple, FCSTMango, ProfitApple, ProfitMango, etc. Therefore when the user selects to view the total profit for...

=SUMPRODUCT(FCAST1111,PROFIT1111) This works =SUMPRODUCT("FCAST"&B14,"PROFIT"&B14) This does not. b14 = 1111

Hi, I get a #value error. I have put below an example of ranges etc that are defined. Type Product Jan Feb Mar FORECAST 1111 25 25 25 FORECAST 2222 10 20 20 FORECAST 3333 20 20 20 PROFIT 1111 2 2 2 PROFIT 2222 3 3 3 PROFIT 3333 5 5 5 Product sum product 1111 150 This works 1111...

I have two tables a. Forecfast table b. Profit table Product Jan Feb Mar FORECAST 1111 25 25 25 FORECAST 2222 10 20 20 FORECAST 3333 20 20 20 PROFIT 1111 2 2 2 PROFIT 2222 3 3 3 PROFIT 3333 5 5 5 I have macro to create names based on product like - forecast1111, forecast2222...

I have two tables like 1st table - to make a produce i need components a, b,c Item;Qty a;5 b;2 c;4 In turn component c needs another 3 items aa;ab;ac 2nd table c;aa;2 c;ab;3 c;aa;4 I need to combine the two tables to get the total components needed like a;5 b;2 aa;8 ab;12 aa;16

Is anyone aware of resources to do Production scheduling in Excel which takes into account min/max run sizes, sequencing options and graphical representation of a schedule.