Recent content by bluetaurean

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