Validation rules for reformatted cadres_ sheets

[rhanIDM]

"StartYear" + cadre role + ScenarioID from "CadreRoles" sheet should uniquely identify a column of workload allocation on the "Cadres_Scenario" sheets.

[MeWu-IDM]

@rhanIDM let's calrify this
For example: if CadreRoles sheet define a startYear = 2020 endYear=2029 for RoleID=HEW1 for BasicModel (Cadres_Basic)
We should anticipate these columns appear in Cadres_Basic to cover all years , correct?
startYear2020/HEW1
startYear2025/HEW1
startYear2030/HEW1

[rhanIDM]

The validations rules are:
1.) Sheet CadreRoles: columns StartYear and EndYear can not be outside of the model default range. (Error, "unable to finish", print the rows violating this rule)
2.) Sheet CadreRoles: for each "ScenarioID", (EndYear+1) must appear in StartYear (Error, "unable to finish", print the rows with EndYear violating this rule)
3.) Sheet CadreRoles: columns "ScenarioID" + "RoleID" + "StartYear" must appear in the corresponding cadre_ sheets' headers (Error, continue)
4.) Sheet CadreRoles: for each "ScenarioID", rows with no "EndYear" must appear in the max(StartYear) section in the corresponding cadre_ sheets' (Error, print the row violating this rule)
5.) Range check: each "RoleID" should appear in continuous sections on the cadre_ sheets' headers in between StartYear and EndYear.

[rhanIDM]

Revision for rule 5.) Also include CadreRoles rows with no "EndYear".
Add rule 6.) [the inverse of rule 3] on each scenario-specific cadre_sheet, the pair "StartYear" + "RoleID" must appear in CadreRoles for the corresponding ScenarioID (Error, print the StartYear and RoleID)

[rhanIDM]

Successfully implemented in v1.0.7.