Logic with date in excel

3

People, I am developing a spreadsheet to better control the production of the factory in which I work, I do not understand much of excel and I am with a doubt that it might be simple to solve. Next, I have 35 machines available for production, and I know how long it takes for this machine to complete a production order with an X quantity, I have a list of orders, and I calculate the production time on the machine, and I would like to fit it the date of the next request based on the term of the previous one: I will show:
order 1 = 6 machines (there are 35 plus 26) starts on 04/06
order 2 = 37 machines (there are 26 left, I can start to produce simultaneous), it also starts 4/06 but as the first order it will end, on the 5th I can pick up the 6 machines to continue the order 2, and so on, it will add up these dates, so I will have a production gantt, and still in order 2 I will have 2 pending production orders (37- 35). Any ideas on how to do it?

Thank you!

    
asked by anonymous 31.05.2015 / 23:33

2 answers

1

What the @bp002 user said may be the only solution if you want the system to actually "count" the time - in which case you would be developing an application using the Visual Basic language. But you can round the split to have the amount of cycles that would be needed for each production order using the ceiling () function. I think that would solve your problem.

    
27.05.2016 / 13:04
0

Yes, it is possible using vba, imagine a list of size N where you add the OPS to the machines, and a thread that looks at that list, takes a position from the list, processes, and marks with 0, hence you a one global timer, and an internal within the thread of the machines, so you use a repeat loop start the threads that will read the list, from the 35, the thread needs to know what position! = 0, if it can process the position, position = = 0, it has already been processed, so it should look for another position if it does not find the thread closes.

    
01.06.2015 / 16:56