Hi
I have included a reference data to give info on which colm is where in data. I hope that will be helpful.
DO let me know if any clarification required in any of the text. I given my best shot here ;)
I could continue only as with previous case!
>> About that. I feel its a different...
Hi vletm
You are correct. these are connected. Its actually a first part to...:)
I didn't find from any sheet's table PDNO ...
>> I should have specified. PDNO = Main item Pdno = Q colm of Order data sheet.
LOOP 1 Select Each PDNO in ascending order (priortization)...
>> A slight change here...
Hi Ninjas!
I seek help from this community to help me with one of the macros I wish to make.
I have summed up the context and the requirements in the attached workbook.
Yeah, its good amount of information. But I feel you will be able to connect better with the objectives this way and guide...
Let me try to add context as well.
As you would have guessed, we are manufacturers. SO ontime supply is of great importance. Currently everything is tracked using one final Delivery date.
In case order is a bulk qty order, the order needs to start early. for that we need the date when the order...
'Type Mismatch' ...
1) Did You select 'target date'?
-- yes I did.
2) Did You get anything else information?
- No other error.
Vletm suggestion: ...
Try to give more information of that Error.
Error was straight forward dialog box- Type mismatch. Nothing else.
eg then there even the ops...
Hi @vletm
Thanks a lot!
However, I get below error after pressing Do-IT in the last two versions.
Your sheet in #9 solved my requirements already. I wanted to see solver work but this error is coming.
"Mismatch type"
---------------
That previous version has some challenges ... You'll get...
Responding to your questions:
Question:
> When those UIDs list has made?
... any new UID to list means 'rush' somewhere ... means gotta calculate!
Yes if all capacity is utilized and new UID get added. It will be rush. Now the additional manhours feature will help me plan that! All thanks to...
WOW! Thankyou!! I want to know & learn how you do all this so fast.
Sample 'report'-sheet:
Psc ... shows those values 'my way' as long as I'll know how to solve those!
--> The report is already showing pieces in ratio of manhours. You have already covered this! or am i missing something here...
Thanks for your help! Much appreciated.
Question:
When those UIDs list has made?
--> This is open Order position taken in 31st Oct End of day. The execution can start from 1st Nov.
I See that the macro assigns work before 1st Nov also. I understand that the capacity do not allow the work to be...
Hi Gurus!
I have a order position data here. What I wish to achieve is to create a datewise report for execution of orders with two prime objectives.
- Ensure that priroities are met. No order (UID) overshoots its respective Delivery date.
- Ensure the full utilization of capacities.
The...