Guys
I have the scenario below where I would like to create a loop to distribute along the columns (G column on) the date that that maintenance will ocurr based on its ID, Frequency and Due date. I will distribute it for a period of 01 year (365 days or 365 Columns)
For instance, the Maintenance for the ID 9960000192374 ocurrs every week and every month (Different maintenance , so my loop will fill an "x" the next due date to 08th Jan, and the next to 15th Jan, etc until reach the last week of a period of a year. After it, will go to the next row performing the next distribution.
The frequency varies, based on values of the frequency column.
<tbody>
</tbody>
The original file contains more than 10k lines, the above table, is a short version of the problem.
Excel Columns reference based on above table:
ID= Column A
Due Date= Column F
(..) Means the others dates until 31st December
How can develop a loop that can distribute these dates?
I have the scenario below where I would like to create a loop to distribute along the columns (G column on) the date that that maintenance will ocurr based on its ID, Frequency and Due date. I will distribute it for a period of 01 year (365 days or 365 Columns)
For instance, the Maintenance for the ID 9960000192374 ocurrs every week and every month (Different maintenance , so my loop will fill an "x" the next due date to 08th Jan, and the next to 15th Jan, etc until reach the last week of a period of a year. After it, will go to the next row performing the next distribution.
The frequency varies, based on values of the frequency column.
ID | Equipment | Discipline | Maintenance | Frequency | Due date | 01/Jan/18 | 02/Jan/18 | (...) |
996000019374 | Equipment A | Mechanical | A | 1 Week | 01/01/2018 | X | ||
996000019374 | Equipment A | Instrumentation | B | 1 Month | 01/01/2018 | X | ||
996000019238 | Equipment C | Electrical | C | 3 Months | 01/01/2018 | X |
<tbody>
</tbody>
The original file contains more than 10k lines, the above table, is a short version of the problem.
Excel Columns reference based on above table:
ID= Column A
Due Date= Column F
(..) Means the others dates until 31st December
How can develop a loop that can distribute these dates?