Search results

thanks Narayan. Admire your VBA skills.

Hi Narayan, yes your interpretation in correct. thanks

Hi Narayan, the Maximum hours per run is using a similar logic as max qty per run. As the change over time is in hours and cannot be converted to qty to show in the same output column, i converted the max qty per run into equivalent number of hours to have a common unit in the output range...

Hi Narayan, My original query should have been in a common unit. Product Qty Rate/Hr MaxHrsPerRun Hours required A 175000 2000 40 88 B 48000 2000 40 24 C 315000 3000 35 105 Output Product Hrs A 40 Changeover 4 B 24 Changeover 4 C 35 Changeover 4 A 40 Changeover 4 C 35 Changeover 4 A 8...

Thanks @Debraj & @NARAYANK991. Exactly the solution needed. For the VBA solution, is it possible to introduce a standard breaktime (changeover time) say a 2hrs after each change. noted one unit is qty and another is hours but i can modify the code if i know the basic structure. so the example...

Can someone help me with code to breakdown qtys into number of runs. example product A having a total qty of 75K needs to be broken down in 3 runs of 25K each but the output list must do a sequence of each product once before looping to back to the first product. Input Product Qty Run Size...

Is it possible to create a tooltip in Office 2010 as shown in the article below which brings up a table with more data depending on the context of the row and column header. Is anyone aware of more resources to do this...

Hi, Help anyone. regards

Hi SirJB7, Ok i was not very clear. I have uploaded another file which will perhaps clarify http://dl.dropbox.com/u/29802745/List.xlsx a. there is a data sheet which has Day;Product;ProductionLine;Qty b. Produciton line indicate the machine on which the product is produced. c. a...

Hi Anupam, Please find attached a link to the file. http://dl.dropbox.com/u/29802745/samplefiles.xlsx Appreciate your help. regards

@ Narayan, there are 12 ranges which need to be consolidated. all of them are on a single sheet. The length of each range varies, breadth is always 3 Output can be on the same or different sheet. thanks @Anupam I will try your code. Please note all input ranges are in a single sheet. Also...

Hello, Can anyone help with VBA script to conlidate ranges as below First Range Day|Product|Qty 1|ABC|99 1|PRQ|88 2|DEF|55 Second Range Day|Product|Qty 1|EFG|33 2|HIJ|44 2|klm|22 Output Reqd Day|Product|Qty|Day|Product|Qty 1|ABC|99|1|EFG|33 1|PRQ|88|""|""|"" 2|DEF|55|2|HIJ|44...

Can anyone help with this?

Hello, Thanks for the feedback. I am looking for a formula to calculate the days cover given that actual future consumption and closing inventory data is already available. for a given closing inventory and future consumption data, the inventory days cover is to be calculated.

Hello, I have attached a file of the desired output. this is sample data. in reality there are 12 line and 100+proudcts. As you will see the pivot table output is very elaborated. A sheet is attached to show the desired output. http://dl.dropbox.com/u/29802745/samplefile.xlsx

HI Faseeh, The output is a production plan. at a glance the user much be able to see what product/market is being produced on a particular date/line. thanks

Is there a way to Pivot text fields within the values area the data consist of below column. Date|Product|Market|ProductionLine|Qty 01/11|Apples|USA|Line1|100 01/11|Orange|USA|Line2|100 02/11|Apples|USA|Line1|100 02/11|Orange|USA|Line2|100 I need to pivot to show Date in row area...

Need help in calculating future days cover Period Opening Purchase Consumption Closing DaysCover Jan 110 60 40 130 60 Feb 130 40 75 95 45 Mar 95 60 85 70 40 Apr 70 20 50 40 etc May 40 20 60 0 etc etc Each period is a month - assumed 30days. I need to calculate the days cover at the end...

@Luke, Sajan, Sirjb7, Thanks a lot for help.

Hi Sajan & Luke, thanks for ideas. it is indeed what is required. Would be interesting to see a vba based solution as well. the only drawback with the formula is that everytime the order is changed by moving cells the formuals will have to be recopied. A flat out will be helpful in then...

Is there a way to time slot a list into 24 hour schedules. Eg I have a production run scheudled as Product A | 40 hrs Product B | 20 hrs CIP | 5 hrs Product C | 15 hrs etc the output should be on another sheet/area Day 1 | Product A | 24hrs Day 2 | Product A | 16hrs Day 2 | Product B...

Thanks Hui, It worked perfectly. Amazing.

Is there a way to activate the powerpivot window and do a data refresh automatically with a macro. the powerpivot has link to 20 external files which are pooled into excel and then relationship etc defined. I want the file to open every 60minutes and do the powerpivot data refresh, save and...

Does anyone know of resources to understand the Cube functions. some links suggested in previous posts are mentioned below but the number of examples are very limited 1.http://www.powerpivotpro.com/2010/06/using-excel-cube-functions-with-powerpivot/ 2.http://wills-blog.com/?p=390 Regards

Fantastic. Thanks for your help Regards