Search results

:awesome:

T Thanks a lot for your help...

Thanks p45cal... this work for multiple sheet tabs now, can you help me getting the sheet tab name too next to workbook name in column B

Hi All, I am looking for help as I am not a pro in VBA but have googled many code and fix my task, however this it is not helping me; I want to merge 184 excel workbook, where each workbook has 3-5 worksheet, with Workbook name stamp in last column and Sheet tab name in next column following...

Thanks Peter for looking into it again, This calculation has evolved a lot with your inputs and help. Can you please update the formula to get the info in Overlapping Time Data sheet tab in cell K 20 and the updated Duration 2x. Then I there will not be further any change required but to be...

@Peter Bartholomew , This returns a minimum value of 0:00 for the start following the final task of the day - This helps and takes care of the requirement. Another thing I came across is enclosed for your reference - Whenever multiplicity is 3 the 2x overlapping time not getting calculated...

Hi @Peter Bartholomew , Hope you are doing fine, we have tested the file/calculation couple of things needs to be amended and I require your help again. Below is the screenshot for your reference, Next start highlighted in pink should be blank as it is picking up the value for next day...

Thank you very much Peter, the updated file fulfills the requirement. I just tested with random data and it worked fine. I will test and it and come back if any help needed. Thanks again Anshul

Hi @Peter Bartholomew, hope you are doing fine. 60000 seems very large number of records, though as or now the max what we can think of is 15000 rows not more than that and If it will take time we are ready to do the task on weekly basis or might be two times a week which will help us with...

Thanks @Peter Bartholomew further inputs are required as we have yet not concluded the solution. The file is working as expected on single tech for single date :awesome: I have changed data for Task 24 highlighted in pink to check 3x overlapping and also added formula to calculate the...

Below are the answers you are looking for; Do You would like to get some format or something which would help You? Yes I would, but first you need to make your understanding clear that you might be champion in Excel and VBA but if someone is providing information in a format which working and...

Sir @vletm What answer you are looking for ?

Please find the enclosed file with data which is populated, though at a given point of time no tech is handling 3 overlapping task. I have tried to show the same with red line I am enclosing the file and graph for your reference. Also the result in OL_Tech sheet column J K L is the result...

I have deleted the data and entered new data but it is not giving result, I have followed the steps.

Thanks @vletm for working this out, here is what I have understood. I have tried using different set of data to validate the results you have populated in the OL_TECH sheet, there seems to be I am missing something out, it is not showing the results. Please find enclosed sheet for your reference.

Please find enclosed sample for your reference, also you can share your thoughts of presenting the data. Also, please note tech calculation is required for each day/date, task is just counter. I think you are checking the overlapping on task level that is the reason it showing more than 3...

My Friend, To be honest it is not that simplified that one can understand. All times by tech is mentioned in one single row,it would have been great, if it would have been in the format which I have shared. So that working on the data becomes easy not complicated. 1. If overall overlapping...

Thank for sharing the new calculation, the file which you have shared earlier is solving the purpose as of now. Thanks again for your great help. It would be great if you can look for a calculation which can work on 3 concurrent task at Tech level. Though I am demanding much I know but if can...

The calculation you have shared is not matching the expectation/result, In first go what @Peter Bartholomew did and the previous file which he has shared are the result and calculation which I am looking for - As stated earlier also each Tech has to treated separately for each day/date. Task...

Hi @vletm , I think the below information will help, this will So for every overlap time for each tech for each overlapping task has to be defined separately, this there in the file at sheet tab "3 Task Multi-Tasking Example" The overlapping time of any activity more than 2 can not be...

Seems there is some confusion as I have tried at my end doing it manually as well as with the first solution provided Peter. As per the image you have shared, it looks like that you have not consider the tech name for checking the overlapping. The motive is to check overlapping time of...

Sorry I misunderstood the graph, there seems to be some problem in Larger Data Sheet tab, as it can not happen as of now. Attached is the updated file for your reference. @vletm If you simply sum up the length of each task, the time will come out to be more than working hours of an...

@vletm Thanks for looking in. The data you have considered for all the tech I can see that from the graph which you have shared. "The situation which you have mention will never arise, As of now the multi-tasking can be performed maximum of 2 task. But it would be great if a dependent cell...

Hi Peter, Hope you are doing good, I was curious to know if you had time have look on the larger data file. Though Narayan is also helping on the same. Regards, Anshul

Please read the note as below Note :For your reference, each day for each tech has to be treated separately (mutually exclusive).