This sheet must contain one column whose header cell is ID. Example: the following sample sets two possible computations for contiguity, distance-time matrixes will be available for a car and for a lorry.

Table 4.13. Sample input Contiguity sheet

ID
CAR
TRUCK

This sheet must contain four columns whose header cells are CONTIGUITY_ID, Language_ID (see Note about expected languages identifiers), Contiguity_NAME (e.g. the name of this contiguity in this locale) and Contiguity_DESC (a description of this contiguity). Example:

Table 4.14. Sample input ContiguityLanguage sheet

Contiguity_ID	Language_ID	Contiguity_NAME	Contiguity_DESC
CAR	EN	car time	Time between units by car (in minutes)
TRUCK	EN	truck time	Time between units on a truck (minutes)
CAR	FR	temps voiture	Temps entre les unités en voiture (minutes)
TRUCK	FR	temps camion	Temps entre les unités en camion (minutes)

This sheet must contain four columns whose header cells are Neighbourhood_ID (see Note about expected languages identifiers), Contiguity_ID, Distance and Comparator. Possible values for the Comparator cells are:

This sheet must contain four columns whose header cells are Neighbourhood_ID, Language_ID (ISO-639 language in 2 digits, Neighbourhood_NAME (e.g the name of this neighbourhood) and Neighbourhood_DESC (e.g. a description of this neighbourhood). In the following example, neighbourhoods are translated in english (EN) and french (FR):

Table 4.16. Sample input NeighbourhoodLanguage sheet

Neighbourhood_ID	Language_ID	Neighbourhood_NAME	Neighbourhood_DESC
CAR <= 360	EN	6h car	Units at less than 6 hours by car
TRUCK <= 360	EN	6h truck	Units at less than 6 hours on a truck
CAR <= 540	EN	9h car	Units at less than 9 hours by car
TRUCK <= 540	EN	9h truck	Units at less than 9 hours on a truck
CAR <= 180	EN	3h car	Units at less than 3 hours by car
TRUCK <= 180	EN	3h truck	Units at less than 3 hours on a truck
CAR <= 360	FR	6h de voiture	Unités à moins de 6 heures en voiture
TRUCK <= 360	FR	6h de camion	Unités à moins de 6 heures en camion
CAR <= 540	FR	9h voiture	Unités à moins de 9 heures en voiture
TRUCK <= 540	FR	9h de camion	Unités à moins de 9 heures en camion
CAR <= 180	FR	3h de voiture	Unités à moins de 3 heures en voiture
TRUCK <= 180	FR	3h de camion	Unités à moins de 3 heures en voiture

This sheet must contain two columns whose header cells are Contiguity_ID and Zoning_ID. In the following example, the distance-time by car and distance-time by lorry are available for NUTS_2 zoning only:

Table 4.17. Sample input ContiguityZoning sheet

Contiguity_ID	Zoning_ID
CAR	Nuts_2
TRUCK	Nuts_2

	The identifiers that are given in the Zoning_ID column must be coherent with the identifiers that have been given in the Zoning sheet of the structure input, see Content of zoning.

This sheet must contain two columns whose header cells are Contiguity_ID and Area_ID. In the following example, distance-time matrixes by car are available for UE15 and UE25, distance-time matrixes by lorry are available for UE27 and UE29:

Table 4.18. Sample input ContiguityArea sheet

Contiguity_ID	Area_ID
CAR	UE15
CAR	UE25
TRUCK	UE27
TRUCK	UE29

	The identifiers that are given in the Area_ID column must be coherent with the identifiers that have been given in the Area sheet of the structure input, see Content of area.

This sheet must contain at least three columns whose header cells are UT_ID1, UT_ID2, then the identifier of a contiguity.. In the following example, contiguities between units are performed for CAR contiguity and TRUCK contiguity:

Table 4.19. Sample input UnitContiguity sheet

UT_ID1	UT_ID2	CAR	TRUCK
ES12	UKC1	1265.11	1820.5
ES13	UKC1	1138.85	1649.5
ES21	UKC1	1058.92	1529.9

In Excel mode, each UnitContiguity can only contain 216 rows, e.g. 65536. Several sheets can be created to import more results: just name your sheets UnitContiguity1, UnitContiguity2, etc. Note that only 30 UnitContiguityi sheets can be created. Nevertheless, on considering a symetric relationship for a distance between two units (e.g. distance between UT1 and UT2 equals the distance between UT2 and UT1), the number of needed rows can quasi be reduced by half. Thus, the number S of needed sheets for n units can be found by executing the formula which is shown on Figure 4.1: Figure 4.1. Number S of needed sheets for n units S is the number of needed sheets, n is the number of units. On the numerator, "1 +" stands for the header row that must be included on each sheet. Note that contiguities are not aggregable: a distance matrix is set for a given level of mesh. For its upper level, the associated distance matrix must also be given. Table 4.20 provides an example of the number of needed sheets for different levels with several numbers of units. Table 4.20. Example of needed sheets number Mesh Number of UT (n) Number of sheets (S) NUTS_0 29 1 NUTS_1 92 1 NUTS_2 280 2 NUTS_2_3 727 5 NUTS_3 1329 14 Total 23