Search results

Hello, I have a table with monthly demand and another table with stocks and their expiry dates. Demand can be satisfied with stocks that have not expired. the output needed is to show the good stocks that are consumed and stocks that expire separately. If demand is more than stock, the...

I have a workbook with 20+ Power queries for sourcing data. It takes over 10minutes to refresh. How can i find out which particular query is causing the issue? is it possible to log via VBA or any other technique the time taken by each of the queries for refreshing.

Need help in creating a pick list by date/product and customer - a table which has the max load per day per customer - a table which was a priority list per customer the output to contain by date the product to be loaded based on the max capacity in table and as per priority list. there could...

Need help in creating a pick list by date/product and customer - a table which has the max load per day per customer - a table which was a priority list per customer the output to contain by date the product to be loaded based on the max capacity in table and as per priority list. there could...

Hello, Trying to put a service KPI (reaction time) from when orders are placed. a. there is a lot size per customer in number of pallets - 24 or 22 or 20 etc b. everyday orders arrive from various customers in various pallet multiples which will be more or less than a lot size c. whenever the...

Can someone please help with a VBA code for this a. there is a list of product running for certain hours in a sequence b. for each product change, the change over time is listed in a matrix. eg. Orange to Mango 2 hrs. c. i need a output list which takes the original list and inserts a row and...

Can some help me with code for this a. Each product has a minimum and maximum qty b. demand for each varies. c. Code required to schedule the maximum of each provide total demand is higher than the max. d. Move to the next product and repeat e. after all products are run once, repeat steps c & d...

Is it possible to create a list of all possible routes if for example you can go from A to B1 or B2, from B1 to C1 or C2, from B2 to C2 or c3 etc till you reach a final destination. Need to list all possible route options - A - b1 - c1 etc.

A data mining addin was introduced by excel which requires access to analysis services. Can anyone give some guidance how to set this up on a personal pc.

Can maps like the one in the link below be created in excel. there are some references to choropleth maps over here and other websites however the base maps itself are difficult to find for non-usa countries. appreciate any help or links to create this...

Can anyone provide files / links that can be used to test the excel proficiency of a candidate. the position is for a data analyst in demand planning.

Hello, Could someone help in providing a VBA solution to break down demand number by weeks. Input range Product demand is listed in monthly buckets per day demand is to be calculated excluding all Fridays. So for jan no of days is 26. Output range needed is demand broken down into weekly...

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...

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...

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...

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...

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

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...