Random Data for Testing a Maintenance Optimization Algorithm

This data contains the definitions of the randomly-generated test problems 1-20 in the paper titled "Minimizing Equipment Shutdowns in Oil and Gas Campaign Maintenance", which is currently under review. The data was randomly generated during December 2019 and January 2020. The data file is in xslx spreadsheet format with 20 worksheets, one worksheet for each test problem. Each worksheet has 14 columns containing the following data: Column A: Maintenance item (items are listed 1-3000 in increasing order) Column B: Maintenance plan to which the maintenance item belongs Column C: Shutdown level required for the maintenance item (=6 refers to complete plant shutdown, =5 refers to level 2 shutdown, =4 refers to level 3 shutdown, =3 refers to level 4 shutdown, =2 refers to level 5 shutdown, =1 refers to local isolation, and =0 or blank refers to no isolation required) Column D: Frequency of the maintenance item in months Column E: Duration of the maintenance item in days Column F: First execution date of the maintenance item Column G: Indicator for whether the maintenance item is designated TI (=1 if yes and =0 or blank if no); randomly generated according to a Bernoulli distribution with probability 20% Column H: Node in level 1 of the plant hierarchy tree that contains the maintenance item Column I: Node in level 2 of the plant hierarchy tree that contains the maintenance item Column J: Node in level 3 of the plant hierarchy tree that contains the maintenance item Column K: Node in level 4 of the plant hierarchy tree that contains the maintenance item Column L: Node in level 5 of the plant hierarchy tree that contains the maintenance item Column M: Suppression hierarchy value for the maintenance item Column N: Number of resources required for the maintenance item