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

Thanks Nebu. this is very helpful.

@Nebu Please refer attached example where the first number is 46. in this case the total orders for customer A are 144 pallets, only 96 get to the next table as schedule. Also will it be possible to add the product to this table to show what product mix the load is made of. attached file shows...

@ Naryan - Yes the spillover has to be carried forward. @Nebu - thanks for your help. in this solution, if i change the number to 22 or 46 the output is less than it should be. Perhaps some tweaking in the code is needed.

@NARAYANK991 - yes indeed a vba solution is preferred. @Nebu - yes it would be great if we can consider product as well. however the lot size is at the customer level not the product level else the smaller volume products will never get shipped. Effectively the truck gets loaded on a order date...

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

Hi Narayan, Sure a matrix is good (better). i put it out in a linear manner assuming this would be easier. Updated file with the the matrix. Appreciate your help.

thanks Narayan, the formula works well. One of the reason for asking a VBA solution was that the original plan it self is derived with a script based on certain other constraints like min/max constraints, run sizes etc. as a further refinement to that script i was adding this part of...

Thanks David. this solution requires the output table to created manually and then input of a formula in the change over cells. What i am trying to do is create the output table via a code. take the first element from the first "Plan" table, put it in the output table, the change over time...

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

HI SM, Yes this output is perfect. thanks

HI SM, I have added columns to show the desired output next to your file. the logic is a. each product has a maximum and minumum qty b. If total demand for a product less than the maximum qty but more than the minimum qty, schedule the actual demand. b. if total demand is greater than the...

Hi SM, thanks for your help. very helpful indeed. Can you please fine tune the code in the example for a case like Product C. In this case the "next run qty is less than the max but more than the minimum. in this case it must schedule the full balance. So in the example product C will be...

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.

Yes. Spot on. i am stuck with setting up the analysis services connection without which none of it works.

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.

The idea is to show sales and stock health across a region (north africa and gulf by states and regions). would help as a quick visual indicator of areas where stocks are not healthy or too much

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.

Hi Hui, the number of days in the respective months dont appear correctly. for feb the no. of day must appear in row 15 in this example and so on. do you know of any similar vba solutions. thanks

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