Custom Excel Structure/Template

Hello, The requirements for this is to structure an excel file that will be used to store and manage some data. The detailed requirements are: Sheet1: Column 1: flag true/false Column 2: flag true/false Column 3 to 8: string values flowing from left to right. Basically a representation of a hierarchy tree, where each row formed by the Columns 3 to 8, represents a hierarchy tree element. Example hierarchy: - L1 - L1.1 - L1.1.1 - L1.1.2 - L1.2 - L1.3 - L2 Translated into excel L1 L1 L1.1 L1 L1.1 L1.1.1 L1 L1.1 L1.1.2 L1 L1.2 L1 L1.3 L2 Column 9 is calculated as the concatenation of Column 3 to 8, separated by "/", which should be the unique key of a row. Validations needed: Column 9 should be unique: popup message Values have to flow in order. For example, in order to add an element like "L1 L1.1 L1.1.3" in the example hierarchy, a validation has to be shown if user wants to input something like case 1. Case 2 is valid: L1 L1 L1.1 L1 L1.1 L1.1.1 L1 L1.1 L1.1.2 L1 L1.2 L1 L1.3 L2 L1 L1.1 L1.1.3 => bad. throw validation message as soon as this is detected. L1 L1 L1.1 L1 L1.1 L1.1.1 L1 L1.1 L1.1.2 L1 L1.1 L1.1.3 L1 L1.2 L1 L1.3 L2 Other notes: We should be able to add new columns (like a flag true/false) that will not break the logic. Don't need to follow the same column numbers, as long as they make sense. Sheet2: Column1: Field name, string, has to be unique Column2: Flag true false Column 3: Label, does not have to be unique Column 4: has to represent a 1 to many relationship to the elements in Sheet 1. The desired use case is to have each cell in this column: - When in edit mode (when clicked) display something like a searchable list of checkboxes representing the value in Column 9 in Sheet 1 (user can select multiple or none) - When in read mode, the cell should display each value selected from Column 9 in Sheet1, on a new line. (same cell) Validations: Column 1 has to be unique. Column 4 has to be calculated and the edit has to be made only with selections. User should not be able to write at will). Notes: Implementation is not strict (applies to Column 4). As long as the described use case is reflected. We should be able to add new columns (like a flag true/false) that will not break the logic. Don't need to follow the same column numbers, as long as they make sense. Sheet 3: Column 1: Unique string value Column 2: String value. Column 3: Same explanation as Sheet2.Column4. Should reference values in Sheet1.Column9. Column 4: Same explanation as Sheet2.Column4. Should reference values in Sheet2.Column1. Column 5: Same explanation as Sheet2.Column4. Should reference values in Sheet1.Column9. (looks the same as Column3, but has a different business purpose) Validations: Column 1 has to be unique. Columns 3,4,5 hves to be calculated and the edit has to be made only with selections. User should not be able to write at will). Notes: We should be able to add new columns (like a flag true/false) that will not break the logic. Don't need to follow the same column numbers, as long as they make sense. Requirements: Excel has to be built in, or compatible with, Excel 2013.