Table of passage geography 2022

—
GEO PASSAGE
—

This file presents all the changes in communal geography from 1968 to 2022.
A change in geography consists of the merger or division of one or more municipalities.

Dictionary of variables:

Former municipality: INSEE code of the former municipality
New municipality: INSEE code of the new municipality
Year: year of change of geography of the municipality
COM: INSEE code of municipalities in geography 2022

User Guide:

1. In cell D2, paste the following formula: “=IERREUR(RECHERCHEV(E2;A:B;2;FALSE);E2)”
2. Set the formula to cell D45000 (or maximum number of communes possible)
3. In cell E2, paste the column of common codes in previous geography
4. In cell F2, paste the column of data corresponding to this ancient geography
5. In cell I2, paste the following formula: “=SUM.SI($D:$D;$H2;F:F)”
6. Set the formula to the last common code of column H.
   (if last common code in H35001, then stretch to I35001)
7. Column I represents data from previous geography in geography 2022.