Portail THF

Site

Connectez-vous avec votre email professionnel. Un lien magique vous sera envoyé pour accéder au portail.

🔒

Accès non autorisé

Votre compte ne dispose pas des droits nécessaires pour accéder à cette section.
Connecté en tant que —.

⏸

Compte désactivé

Votre compte est temporairement désactivé.
Connecté en tant que —.

THF · Cellnex France · accès restreint
← Hub iLOQ
THF

Suivi ILOQ Shelter Nov 25

Cellnex France · Pose serrures sites shelter · 508 sites
Indicateurs par statut
Sites · Total
508
508 sites suivis
Sites OK
300
Pose réalisée
Sites RAF
201
Reste à faire
Sites NOK
7
Échec / anomalie
Avancement
59.1%
Sites OK / Total
Lot
Pyl + Shelter Nov 25
Mainteneur THF · Parc HIVORY / CELLNEX
Sites terminés
300 / 508
59.1% du lot
Régions
3
CTA · NOE · IDF
Dernière MAJ
30/04/2026
Données opérationnelles
Avancement global du lot
59.1 %
300 sites OK 208 sites restants

Répartition par statut

OK / RAF / NOK sur l'ensemble du lot
508
Sites suivis
Sites OK 300 (59.1%)
Sites RAF 201 (39.6%)
Sites NOK 7 (1.4%)

Par typologie

Distribution des 5 typologies
Typologie 3 101 (35.9%)
Typologie 1 79 (28.1%)
Typologie 2 66 (23.5%)
Typologie 4 26 (9.3%)
Typologie 5 9 (3.2%)

Par parc

CELLNEX vs HIVORY
HIVORY 491 (97.6%)
CELLNEX 12 (2.4%)

Par région opérationnelle

Répartition CTA / NOE / IDF
NOE 338 (67.2%)
CTA 85 (16.9%)
IDF 80 (15.9%)

Top 10 départements

Nombre de sites par département
Dpt 59 56 (19.1%)
Dpt 57 37 (12.6%)
Dpt 62 37 (12.6%)
Dpt 60 32 (10.9%)
Dpt 67 24 (8.2%)
Dpt 77 24 (8.2%)
Dpt 54 23 (7.8%)
Dpt 2 21 (7.2%)
Dpt 91 20 (6.8%)
Dpt 51 19 (6.5%)

Cartographie nationale des sites

OK 300
RAF 201
NOK 7
Leaflet © OpenStreetMap · © CARTO
Code FR ↕ Nom du site ↕ Ville ↕ Dpt ↕ Statut ↕ Typologie ↕ Parc ↕ Région ↕
FR-02-000374 VAUXBUIN/LIEU DIT LA PLAINE DE PRESLES Acy 2 RAF — CELLNEX NOE
FR-02-700902 BELLEU Belleu 2 RAF — HIVORY NOE
FR-02-700903 CHAUDUN Chaudun 2 RAF — HIVORY NOE
FR-02-700904 VAUDESSON Vaudesson 2 OK Typologie 2 HIVORY NOE
FR-02-700905 CONDE SUR AISNE Condé-sur-Aisne 2 OK Typologie 2 HIVORY NOE
FR-02-700907 TIGNY Parcy-et-Tigny 2 OK Typologie 4 HIVORY NOE
FR-02-700909 CRECY AU MONT Crécy-au-Mont 2 OK Typologie 4 HIVORY NOE
FR-02-700910 FRANQUEVILLE Saint-Gobert 2 RAF — HIVORY NOE
FR-02-700911 STE CROIX (N44) Aubigny-en-Laonnois 2 RAF — HIVORY NOE
FR-02-700912 ERLON Voyenne 2 RAF — HIVORY NOE
FR-02-700913 GUISE Flavigny-le-Grand-et-Beaurain 2 OK Typologie 5 HIVORY NOE
FR-02-700914 ORIGNY STE BENOITE Thenelles 2 OK Typologie 2 HIVORY NOE
FR-02-700916 ETREUX Étreux 2 RAF — HIVORY NOE
FR-02-700917 NESLES LA MONTAGNE Nesles-la-Montagne 2 OK Typologie 3 HIVORY NOE
FR-02-700918 COURCELLES SUR VESLE Courcelles-sur-Vesle 2 RAF — HIVORY NOE
FR-02-700922 NOUVION Le Nouvion-en-Thiérache 2 RAF — HIVORY NOE
FR-02-700930 BUCY LE LONG Bucy-le-Long 2 OK Typologie 2 HIVORY NOE
FR-02-700931 COURMELLES Courmelles 2 OK — HIVORY NOE
FR-02-700932 CUFFIES Cuffies 2 RAF — HIVORY NOE
FR-02-700933 VENIZEL Acy 2 OK Typologie 2 HIVORY NOE
FR-02-700943 MORCOURT ZI Morcourt 2 OK Typologie 2 HIVORY NOE
FR-03-701011 NAVES Naves 3 RAF — HIVORY CTA
FR-03-701018 ST REMY EN ROLLAT Saint-Rémy-en-Rollat 3 RAF — HIVORY CTA
FR-03-701019 BRUNATIERES Sazeret 3 RAF — HIVORY CTA
FR-03-701020 CRESSANGES Cressanges 3 RAF — HIVORY CTA
FR-03-701023 BESSON Besson 3 RAF — HIVORY CTA
FR-03-701024 VARENNES SUR ALLIER Varennes-sur-Allier 3 RAF — HIVORY CTA
FR-03-701025 URCAY Urçay 3 RAF — HIVORY CTA
FR-03-701031 LES ARDELLES Cesset 3 RAF — HIVORY CTA
FR-03-701037 COULANDON Coulandon 3 RAF — HIVORY CTA
FR-03-701041 LES VAUX Molles 3 RAF — HIVORY CTA
FR-03-701042 LODDES Loddes 3 RAF — HIVORY CTA
FR-03-701051 ST JEAN DU HAUT Montluçon 3 RAF — HIVORY CTA
FR-03-701053 MONTLUCON QUINSSAINE SFR Archignat 3 RAF — HIVORY CTA
FR-08-000234 LES MAZURES/FRAY ET MANNESART Les Mazures 8 RAF — CELLNEX NOE
FR-08-700113 LA GENTILLERIE L'Écaille 8 OK Typologie 2 HIVORY NOE
FR-08-700115 CHARLEVILLE LA CROISETTE Charleville-Mézières 8 RAF — HIVORY NOE
FR-08-700116 LUMES (FERME DE L'ESPERAN Nouvion-sur-Meuse 8 RAF — HIVORY NOE
FR-08-700117 RIMOGNE Tremblois-lès-Rocroi 8 RAF — HIVORY NOE
FR-08-700119 LA CROIX AUX BOIS Falaise 8 RAF — HIVORY NOE
FR-08-700120 NOUVION SUR MEUSE Nouvion-sur-Meuse 8 RAF — HIVORY NOE
FR-08-700121 BELLEVILLE SUR BAR Belleville-et-Châtillon-sur-Bar 8 OK Typologie 3 HIVORY NOE
FR-08-700123 HURTEBISE Guincourt 8 OK Typologie 3 HIVORY NOE
FR-08-700125 SEDAN OUEST Glaire 8 RAF — HIVORY NOE
FR-08-700126 GESPUNSART Gespunsart 8 RAF — HIVORY NOE
FR-08-700128 MENIL-ANNELLES Juniville 8 OK Typologie 4 HIVORY NOE
FR-08-700129 BERTHAUCOURT Charleville-Mézières 8 RAF — HIVORY NOE
FR-08-700130 VRIGNE AUX BOIS Vrigne aux Bois 8 RAF — HIVORY NOE
FR-08-700135 AIRE Aire 8 OK Typologie 3 HIVORY NOE
FR-08-700136 LAIFOUR Laifour 8 RAF — HIVORY NOE
FR-08-700159 ZB_ITI_2_S_LANDRES Landres-et-Saint-Georges 8 OK — HIVORY NOE
FR-10-700241 ROUVRE Rouvres-les-Vignes 10 OK Typologie 1 HIVORY NOE
FR-10-700243 VAL D'AUZON Val-d'Auzon 10 OK Typologie 1 HIVORY NOE
FR-10-700244 TROYES BELLEY Villechétif 10 RAF — HIVORY NOE
FR-10-700249 CHAOURCE Lagesse 10 OK Typologie 3 HIVORY NOE
FR-10-700251 CLAIRVAUX Ville-sous-la-Ferté 10 RAF — HIVORY NOE
FR-10-700254 TROYES LA CROIX BLANCHE Saint-André-les-Vergers 10 OK Typologie 1 HIVORY NOE
FR-10-700256 TROYES STADE MUNICIPAL Laines-aux-Bois 10 RAF — HIVORY NOE
FR-21-002699 CHENOVE Chenôve 21 RAF — CELLNEX CTA
FR-21-702743 LE CHAINOT Boussenois 21 OK Typologie 2 HIVORY CTA
FR-21-702748 COURCELLES LES SEMUR Courcelles-lès-Semur 21 OK Typologie 2 HIVORY CTA
FR-21-702749 POUILLY EN AUXOIS Pouilly-en-Auxois 21 OK Typologie 2 HIVORY CTA
FR-21-702753 DIJON LE PARC SUD Dijon 21 RAF — HIVORY CTA
FR-21-702754 DIJON LONGVIC B Longvic 21 RAF — HIVORY CTA
FR-21-702761 DOMPIERRE EN MORVAN Dompierre-en-Morvan 21 RAF — HIVORY CTA
FR-21-702763 LACOUR D ARCENAY Lacour-d'Arcenay 21 RAF — HIVORY CTA
FR-21-702764 CENSEREY CHAPPE Censerey 21 OK Typologie 1 HIVORY CTA
FR-21-702768 CESTRES Saint-Martin-du-Mont 21 OK Typologie 1 HIVORY CTA
FR-21-702769 ST MARC SUR SEINE Saint-Marc-sur-Seine 21 OK Typologie 1 HIVORY CTA
FR-21-702772 AMPILLY LE SEC Ampilly-le-Sec 21 OK Typologie 1 HIVORY CTA
FR-21-702797 PRESILLY 21 Boux-sous-Salmaise 21 OK Typologie 3 HIVORY CTA
FR-21-702802 CORCELLES-LES-CITEAUX Corcelles-lès-Cîteaux 21 OK — HIVORY CTA
FR-21-702809 POTANGEY Aiserey 21 OK — HIVORY CTA
FR-25-703102 JOUGNE LA PIQUEMIETTE Fourcatier-et-Maison-Neuve 25 RAF — HIVORY CTA
FR-25-703106 BUSY Busy 25 RAF — HIVORY CTA
FR-25-703110 LA VRINE Vuillecin 25 RAF — HIVORY CTA
FR-25-703129 COLOMBIER-FONTAINE Colombier-Fontaine 25 OK — HIVORY CTA
FR-25-703131 FRAMBOUHANS Frambouhans 25 NOK — HIVORY CTA
FR-25-703132 FRANOIS Franois 25 OK — HIVORY CTA
FR-25-703137 NANCRAY Bouclans 25 RAF — HIVORY CTA
FR-25-703138 PONT-DE-ROIDE-SALLIERS Écurcey 25 OK Typologie 3 HIVORY CTA
FR-25-703140 SAINT-VIT Berthelange 25 RAF — HIVORY CTA
FR-25-703141 PIERREFONTAINE LES VARANS Domprel 25 RAF — HIVORY CTA
FR-25-703147 POUILLEY LES VIGNES Pouilley-les-Vignes 25 NOK — HIVORY CTA
FR-25-703151 MONTPERRIEUX N57 Fourcatier-et-Maison-Neuve 25 RAF — HIVORY CTA
FR-39-705249 MONT POUPET Abergement-lès-Thésy 39 RAF — HIVORY CTA
FR-39-705253 ST LAURENT EN GRANDVAUX Saint-Laurent-en-Grandvaux 39 RAF — HIVORY CTA
FR-39-705255 LE TABAGNOZ Prémanon 39 OK Typologie 3 HIVORY CTA
FR-39-705256 MONTROND 39 Montrond 39 RAF — HIVORY CTA
FR-39-705272 PETIT CHATEL Lavans-lès-Saint-Claude 39 OK Typologie 3 HIVORY CTA
FR-39-705276 OFFLANGES Offlanges 39 RAF — HIVORY CTA
FR-39-705278 VOUGLANS Cernon 39 OK Typologie 2 HIVORY CTA
FR-39-705287 CESANCEY2 Cesancey 39 OK Typologie 3 HIVORY CTA
FR-51-706493 REIMS TINQUEUX Champigny 51 OK Typologie 4 HIVORY NOE
FR-51-706494 ESTERNAY Esternay 51 OK Typologie 3 HIVORY NOE
FR-51-706495 MONT CHOISY Nuisement-sur-Coole 51 OK Typologie 1 HIVORY NOE
FR-51-706496 MONTIGNY SUR VESLE Montigny-sur-Vesle 51 RAF — HIVORY NOE
FR-51-706497 MONTMORT-LUCY Montmort-Lucy 51 OK Typologie 2 HIVORY NOE
FR-51-706500 SOMMESOUS Sommesous 51 OK Typologie 1 HIVORY NOE
FR-51-706501 SOMME-YEVRE Somme-Yèvre 51 OK Typologie 3 HIVORY NOE
FR-51-706506 REIMS NEUFCHATEL Bétheny 51 OK — HIVORY NOE
FR-51-706508 AUBERIVE Aubérive 51 OK Typologie 3 HIVORY NOE
FR-51-706509 CONNANTRAY Connantray-Vaurefroy 51 OK Typologie 4 HIVORY NOE
FR-51-706514 PARGNY SUR SAULX Pargny-sur-Saulx 51 RAF — HIVORY NOE
FR-51-706515 ST MARTIN D'ABLOIS Saint-Martin-d'Ablois 51 OK Typologie 5 HIVORY NOE
FR-51-706517 JUVIGNY LE MOULIN Juvigny 51 OK Typologie 3 HIVORY NOE
FR-51-706519 MARGERIE HANCOURT Margerie-Hancourt 51 OK Typologie 4 HIVORY NOE
FR-51-706526 REIMS LA HAUBETTE Tinqueux 51 OK — HIVORY NOE
FR-51-706531 COURTISOLS Courtisols 51 OK Typologie 2 HIVORY NOE
FR-51-706538 REIMS COURCELLES Reims 51 OK Typologie 1 HIVORY NOE
FR-51-706549 REIMS BETHENY Bétheny 51 RAF — HIVORY NOE
FR-51-706559 TOURS/MARNE BIS Aigny 51 OK — HIVORY NOE
FR-52-706617 CHALANCEY Vesvres-sous-Chalancey 52 OK Typologie 3 HIVORY NOE
FR-52-706618 BREUVANNE Breuvannes-en-Bassigny 52 OK Typologie 3 HIVORY NOE
FR-52-706620 ECLARON Éclaron-Braucourt-Sainte-Livière 52 OK Typologie 1 HIVORY NOE
FR-52-706621 TRONCHOY Rolampont 52 OK Typologie 3 HIVORY NOE
FR-52-706622 HARREVILLE Harréville-les-Chanteurs 52 OK Typologie 3 HIVORY NOE
FR-52-706623 CORGIRNON Rougeux 52 RAF — HIVORY NOE
FR-52-706624 JUZENNECOURT Juzennecourt 52 OK Typologie 2 HIVORY NOE
FR-52-706630 LONGEVILLE SUR LAINES Rives Dervoises 52 RAF — HIVORY NOE
FR-54-706730 GRIMONVILLER Aboncourt 54 OK Typologie 3 HIVORY NOE
FR-54-706733 BREHAIN LA COUR Bréhain-la-Ville 54 RAF — HIVORY NOE
FR-54-706737 VITRIMONT Vitrimont 54 RAF — HIVORY NOE
FR-54-706738 MAZERULLES Mazerulles 54 RAF — HIVORY NOE
FR-54-706739 ST CLEMENT Saint-Clément 54 RAF — HIVORY NOE
FR-54-706744 CUSTINES Custines 54 RAF — HIVORY NOE
FR-54-706746 OGEVILLER Ogéviller 54 RAF — HIVORY NOE
FR-54-706747 SANCY Sancy 54 RAF — HIVORY NOE
FR-54-706754 JOEUF Val de Briey 54 RAF — HIVORY NOE
FR-54-706758 MONDON Moncel-lès-Lunéville 54 RAF — HIVORY NOE
FR-54-706760 BLAINVILLE SUR L'EAU Blainville-sur-l'Eau 54 RAF — HIVORY NOE
FR-54-706761 GERBEVILLER Gerbéviller 54 RAF — HIVORY NOE
FR-54-706763 MOUTIERS/N103 Moutiers 54 RAF — HIVORY NOE
FR-54-706764 FILLIERES Fillières 54 RAF — HIVORY NOE
FR-54-706765 BREMONCOURT Brémoncourt 54 RAF — HIVORY NOE
FR-54-706769 AVRICOURT Avricourt 54 RAF — HIVORY NOE
FR-54-706770 LEINTREY Leintrey 54 RAF — HIVORY NOE
FR-54-706772 LANEUVILLE AUX BOIS Laneuveville-aux-Bois 54 RAF — HIVORY NOE
FR-54-706781 ST NICOLAS Laneuveville-devant-Nancy 54 RAF — HIVORY NOE
FR-54-706784 FAULX Faulx 54 RAF — HIVORY NOE
FR-54-706791 CEINTREY Ceintrey 54 RAF — HIVORY NOE
FR-54-706801 FLAINVAL Flainval 54 RAF — HIVORY NOE
FR-54-706804 BAINVILLE SUR MADON Bainville-sur-Madon 54 RAF — HIVORY NOE
FR-55-706891 VOID VACON Void-Vacon 55 OK Typologie 3 HIVORY NOE
FR-55-706892 MAULAN Maulan 55 OK Typologie 4 HIVORY NOE
FR-55-706895 VILLERS SUR MEUSE Villers-sur-Meuse 55 OK Typologie 4 HIVORY NOE
FR-55-706896 BUREY Brixey-aux-Chanoines 55 OK Typologie 3 HIVORY NOE
FR-55-706899 HEUDICOURT SOUS LES COTES Heudicourt-sous-les-Côtes 55 OK Typologie 4 HIVORY NOE
FR-55-706900 SAMPIGNY Sampigny 55 OK Typologie 3 HIVORY NOE
FR-55-706903 ST JOIRE Tréveray 55 RAF — HIVORY NOE
FR-55-706906 NANCOIS SUR ORNAIN Nançois-sur-Ornain 55 OK Typologie 3 HIVORY NOE
FR-55-706908 COUSANCES AUX BOIS Cousances-lès-Triconville 55 OK Typologie 3 HIVORY NOE
FR-57-707084 COURCELLES-CHAUSSY Varize-Vaudoncourt 57 RAF — HIVORY NOE
FR-57-707085 GOETZENBRUCK Goetzenbruck 57 RAF — HIVORY NOE
FR-57-707088 AMNEVILLE Amnéville 57 RAF — HIVORY NOE
FR-57-707089 RICHEVAL Saint-Georges 57 RAF — HIVORY NOE
FR-57-707091 HELLIMER Hellimer 57 NOK — HIVORY NOE
FR-57-707095 UCKANGE Uckange 57 RAF — HIVORY NOE
FR-57-707096 LENGELSHEIM Lengelsheim 57 RAF — HIVORY NOE
FR-57-707097 FAMECK Fameck 57 RAF — HIVORY NOE
FR-57-707099 JOUY AUX ARCHES Jouy-aux-Arches 57 RAF — HIVORY NOE
FR-57-707104 WALSCHEID Walscheid 57 RAF — HIVORY NOE
FR-57-707106 SIERSTHAL Siersthal 57 RAF — HIVORY NOE
FR-57-707107 WOELFLING LES SGS Bliesbruck 57 RAF — HIVORY NOE
FR-57-707109 METZ AUGNY Moulins-lès-Metz 57 RAF — HIVORY NOE
FR-57-707116 CREUTZWALD CENTRE Creutzwald 57 RAF — HIVORY NOE
FR-57-707119 PELTRE Peltre 57 RAF — HIVORY NOE
FR-57-707121 IPPLING Nousseviller-Saint-Nabor 57 RAF — HIVORY NOE
FR-57-707128 ST QUIRIN Saint-Quirin 57 OK Typologie 2 HIVORY NOE
FR-57-707130 FOLKLING Folkling 57 RAF — HIVORY NOE
FR-57-707131 BOULAY Ottonville 57 RAF — HIVORY NOE
FR-57-707133 GONDREXANGE Gondrexange 57 OK Typologie 3 HIVORY NOE
FR-57-707134 MACHEREN Macheren 57 RAF — HIVORY NOE
FR-57-707140 GUENANGE Guénange 57 RAF — HIVORY NOE
FR-57-707143 METZ BLORY Marly 57 RAF — HIVORY NOE
FR-57-707149 HAUCONCOURT Hauconcourt 57 RAF — HIVORY NOE
FR-57-707154 MARANGE SILVANGE Marange-Silvange 57 RAF — HIVORY NOE
FR-57-707155 PIERREVILLERS Pierrevillers 57 RAF — HIVORY NOE
FR-57-707156 STE MARIE AUX CHENES Sainte-Marie-aux-Chênes 57 RAF — HIVORY NOE
FR-57-707160 MONTBRONN Enchenberg 57 RAF — HIVORY NOE
FR-57-707166 MERTEN Merten 57 RAF — HIVORY NOE
FR-57-707182 BLIESBRUCK Bliesbruck 57 RAF — HIVORY NOE
FR-57-707183 METZERVISSE Metzervisse 57 RAF — HIVORY NOE
FR-57-707184 RETONFEY Retonfey 57 RAF — HIVORY NOE
FR-57-707185 VIGY Vigy 57 RAF — HIVORY NOE
FR-57-707186 VIGNY Vigny 57 RAF — HIVORY NOE
FR-57-707189 REDANGE 2 Rédange 57 RAF — HIVORY NOE
FR-57-707198 LES FRICHES Langatte 57 OK Typologie 3 HIVORY NOE
FR-57-707211 FAULQUEMONT REDLACH BIS Tritteling-Redlach 57 RAF — HIVORY NOE
FR-58-707291 POUGUES LES EAUX Pougues-les-Eaux 58 RAF — HIVORY CTA
FR-58-707292 TRESNAY Tresnay 58 RAF — HIVORY CTA
FR-58-707301 VILLIERS LE SEC Villiers-le-Sec 58 RAF — HIVORY CTA
FR-59-000176 MOUVAUX/RUE MIRABEAU - LE CIMETIERE Mouvaux 59 RAF — CELLNEX NOE
FR-59-707347 AUBIGNY AU BAC Aubigny-au-Bac 59 OK Typologie 2 HIVORY NOE
FR-59-707348 CAMPHIN EN PEVELE Camphin-en-Pévèle 59 OK Typologie 3 HIVORY NOE
FR-59-707351 BEAUFORT HAUTE BORNE Beaufort 59 OK Typologie 1 HIVORY NOE
FR-59-707354 LESQUIN Lesquin 59 OK Typologie 1 HIVORY NOE
FR-59-707360 WATTEN Holque 59 OK Typologie 3 HIVORY NOE
FR-59-707365 WASQUEHAL VOLTAIRE Wasquehal 59 OK Typologie 1 HIVORY NOE
FR-59-707367 MARQUETTE INDUSTRIE Marquette-lez-Lille 59 RAF — HIVORY NOE
FR-59-707374 HALLUIN Halluin 59 OK Typologie 3 HIVORY NOE
FR-59-707375 MARPENT Marpent 59 OK Typologie 2 HIVORY NOE
FR-59-707376 PETITE FORET Petite-Forêt 59 OK Typologie 3 HIVORY NOE
FR-59-707387 LAMBERSART BRIQUETTERIE Lambersart 59 OK Typologie 3 HIVORY NOE
FR-59-707392 HASNON Hasnon 59 OK Typologie 4 HIVORY NOE
FR-59-707395 ECAILLON Écaillon 59 RAF — HIVORY NOE
FR-59-707396 LALLAING Lallaing 59 OK Typologie 3 HIVORY NOE
FR-59-707397 COURCHELETTES Courchelettes 59 OK Typologie 3 HIVORY NOE
FR-59-707400 WAVRIN Wavrin 59 OK Typologie 1 HIVORY NOE
FR-59-707413 HONDSCHOOTE Hondschoote 59 OK Typologie 2 HIVORY NOE
FR-59-707423 PERONNE EN MELANTOIS Fretin 59 OK Typologie 3 HIVORY NOE
FR-59-707431 TRITH ST LEGER Trith-Saint-Léger 59 RAF — HIVORY NOE
FR-59-707434 LES ETOQUOIS Saint-Amand-les-Eaux 59 OK Typologie 3 HIVORY NOE
FR-59-707435 BACHANT Bachant 59 RAF — HIVORY NOE
FR-59-707437 SYNTHE LE COURGHAIN Grande-Synthe 59 OK Typologie 3 HIVORY NOE
FR-59-707441 FLINES LEZ RACHES Flines-lez-Raches 59 OK Typologie 1 HIVORY NOE
FR-59-707450 WATTRELOS BECK Wattrelos 59 OK Typologie 5 HIVORY NOE
FR-59-707462 AVELIN Avelin 59 OK Typologie 3 HIVORY NOE
FR-59-707467 CHERENG Chéreng 59 OK Typologie 1 HIVORY NOE
FR-59-707476 LOMME GARE SNCF Lille 59 NOK — HIVORY NOE
FR-59-707477 LA CHAPELLE D'ARMENTIERES La Chapelle-d'Armentières 59 OK Typologie 1 HIVORY NOE
FR-59-707491 HAUBOURDIN SUD Haubourdin 59 OK Typologie 3 HIVORY NOE
FR-59-707493 MT DE FACHES Faches-Thumesnil 59 RAF — HIVORY NOE
FR-59-707494 SAINGHIN EN MELANTOIS Anstaing 59 OK Typologie 1 HIVORY NOE
FR-59-707497 VERLINGHEM Verlinghem 59 OK Typologie 3 HIVORY NOE
FR-59-707503 ST POL TRIAGE Dunkerque 59 OK Typologie 1 HIVORY NOE
FR-59-707504 VALENCIENNES HOPITAL Valenciennes 59 OK Typologie 2 HIVORY NOE
FR-59-707506 VIEUX-CONDE Vieux-Condé 59 OK Typologie 1 HIVORY NOE
FR-59-707509 LILLE SEITA Ronchin 59 RAF — HIVORY NOE
FR-59-707531 DOUAI NORD Douai 59 RAF — HIVORY NOE
FR-59-707533 WILLIES Willies 59 RAF — HIVORY NOE
FR-59-707534 GONDECOURT Gondecourt 59 OK Typologie 1 HIVORY NOE
FR-59-707539 BOUSIGNIES Bousignies 59 OK Typologie 1 HIVORY NOE
FR-59-707545 DEULEMONT Deûlémont 59 OK Typologie 3 HIVORY NOE
FR-59-707547 VILLENEUVE D'ASCQ LE RECU Villeneuve-d'Ascq 59 RAF — HIVORY NOE
FR-59-707558 COUDEKERQUE SNCF Coudekerque-Branche 59 RAF — HIVORY NOE
FR-59-707559 VALENCIENNES VERT GAZON Valenciennes 59 OK Typologie 3 HIVORY NOE
FR-59-707560 MARLY GOLF Valenciennes 59 OK Typologie 3 HIVORY NOE
FR-59-707593 BERLAIMONT SNCF Berlaimont 59 OK Typologie 1 HIVORY NOE
FR-59-707725 THALYS CYSOING Wannehain 59 OK Typologie 1 HIVORY NOE
FR-59-707752 DOUAI CIMETIERE Douai 59 OK Typologie 3 HIVORY NOE
FR-59-707769 HOUDAIN LEZ BAVAY Houdain-lez-Bavay 59 OK Typologie 3 HIVORY NOE
FR-59-707770 DOUCHY N30 Douchy-les-Mines 59 OK Typologie 3 HIVORY NOE
FR-59-707771 FOURMIES ZA Fourmies 59 RAF — HIVORY NOE
FR-59-707773 SAULZOIR LES BARAQUES Montrécourt 59 OK Typologie 1 HIVORY NOE
FR-59-707777 VILLERS SIRE NICOLE D228 Villers-Sire-Nicole 59 OK Typologie 3 HIVORY NOE
FR-59-707782 VALENCIENNES ROUGEVILLE Valenciennes 59 OK Typologie 3 HIVORY NOE
FR-59-707786 BOUVIGNIES Beuvry-la-Forêt 59 OK — HIVORY NOE
FR-60-707852 BRESLES Bresles 60 RAF — HIVORY NOE
FR-60-707855 ERMENONVILLE Ermenonville 60 OK Typologie 3 HIVORY NOE
FR-60-707857 ST AUBIN EN B.-LA CHAPELL Saint-Aubin-en-Bray 60 RAF — HIVORY NOE
FR-60-707858 LASSIGNY Lassigny 60 OK Typologie 3 HIVORY NOE
FR-60-707859 MOUY Mouy 60 RAF — HIVORY NOE
FR-60-707860 ERMENONVILLE MER DE SABLE Ermenonville 60 OK Typologie 3 HIVORY NOE
FR-60-707862 ST PIERRE ES CHAMPS Saint-Pierre-es-Champs 60 RAF — HIVORY NOE
FR-60-707863 JOUY /S TH-HARDIVILLERS V Jouy-sous-Thelle 60 RAF — HIVORY NOE
FR-60-707864 VERBERIE - ST VAAST Verberie 60 RAF — HIVORY NOE
FR-60-707867 NEUILLY EN THELLE Neuilly-en-Thelle 60 OK Typologie 1 HIVORY NOE
FR-60-707868 PONCHON Ponchon 60 RAF — HIVORY NOE
FR-60-707869 LAMORLAYE Lamorlaye 60 RAF — HIVORY NOE
FR-60-707870 MAREUIL SUR OURCQ Mareuil-sur-Ourcq 60 OK Typologie 1 HIVORY NOE
FR-60-707871 ST PAUL Saint-Paul 60 RAF — HIVORY NOE
FR-60-707873 RIBECOURT DRESLINCOURT Bailly 60 OK Typologie 4 HIVORY NOE
FR-60-707874 CIRES LES MELLO Cires-lès-Mello 60 OK Typologie 2 HIVORY NOE
FR-60-707875 LA NEUVILLE GARNIER Les Hauts-Talican 60 RAF — HIVORY NOE
FR-60-707877 LITZ Litz 60 RAF — HIVORY NOE
FR-60-707879 VER SUR LAUNETTE Ver-sur-Launette 60 OK Typologie 1 HIVORY NOE
FR-60-707880 AUMONT EN HALATTE Aumont-en-Halatte 60 RAF — HIVORY NOE
FR-60-707883 CINQUEUX Cinqueux 60 RAF — HIVORY NOE
FR-60-707884 ST GERMER DE FLY-GUILLENF Saint-Germer-de-Fly 60 RAF — HIVORY NOE
FR-60-707885 MELICOCQ Mélicocq 60 OK Typologie 1 HIVORY NOE
FR-60-707886 BIERMONT Biermont 60 OK Typologie 2 HIVORY NOE
FR-60-707888 BELLE-EGLISE Belle-Église 60 OK Typologie 4 HIVORY NOE
FR-60-707889 NEUILLY-SOUS-CLERMONT Neuilly-sous-Clermont 60 RAF — HIVORY NOE
FR-60-707891 COYE LA FORET Coye-la-Forêt 60 RAF — HIVORY NOE
FR-60-707895 ZB_MUT_1_S_ST-JEAN-AUX-BO Saint-Jean-aux-Bois 60 RAF — HIVORY NOE
FR-60-707902 CREIL USINE Nogent-sur-Oise 60 RAF — HIVORY NOE
FR-60-707909 CHANTILLY NORD Gouvieux 60 RAF — HIVORY NOE
FR-60-707910 ST JUST DES MARAIS Beauvais 60 RAF — HIVORY NOE
FR-60-707920 BEAUVAIS MARISSEL Allonne 60 RAF — HIVORY NOE
FR-62-006942 GRENAY/RUE DE LA TARGETTE Grenay 62 NOK — CELLNEX NOE
FR-62-708015 ST LEGER Saint-Léger 62 RAF — HIVORY NOE
FR-62-708016 NORTKERQUE Nortkerque 62 RAF — HIVORY NOE
FR-62-708018 BAPAUME Bapaume 62 RAF — HIVORY NOE
FR-62-708020 LICQUES Licques 62 OK Typologie 3 HIVORY NOE
FR-62-708021 MARCK EN CALAISIS Guemps 62 OK Typologie 4 HIVORY NOE
FR-62-708022 AVROULT Avroult 62 OK Typologie 1 HIVORY NOE
FR-62-708029 BEAUMETZ LES LOGES Beaumetz-lès-Loges 62 OK Typologie 1 HIVORY NOE
FR-62-708037 MOLINGHEM Isbergues 62 OK Typologie 2 HIVORY NOE
FR-62-708041 ANNEQUIN Annequin 62 OK Typologie 1 HIVORY NOE
FR-62-708045 WINGLES Wingles 62 OK Typologie 1 HIVORY NOE
FR-62-708047 MERLIMONT Merlimont 62 OK Typologie 3 HIVORY NOE
FR-62-708050 BRIMEUX Brimeux 62 OK Typologie 1 HIVORY NOE
FR-62-708054 ETAPLES (A16) Étaples 62 OK Typologie 1 HIVORY NOE
FR-62-708055 BARLIN Barlin 62 OK Typologie 1 HIVORY NOE
FR-62-708062 MARICHELLES Loos-en-Gohelle 62 OK Typologie 1 HIVORY NOE
FR-62-708063 CALONNE Calonne-Ricouart 62 OK Typologie 2 HIVORY NOE
FR-62-708066 REBREUVIETTE Rebreuviette 62 OK Typologie 4 HIVORY NOE
FR-62-708067 ST MICHEL SOUS BOIS Saint-Michel-sous-Bois 62 OK Typologie 2 HIVORY NOE
FR-62-708068 HERNICOURT Hernicourt 62 OK Typologie 1 HIVORY NOE
FR-62-708071 RODELINGHEM Rodelinghem 62 OK Typologie 1 HIVORY NOE
FR-62-708072 BOUQUEHAULT Guînes 62 RAF — HIVORY NOE
FR-62-708073 LOUCHES Louches 62 OK Typologie 2 HIVORY NOE
FR-62-708076 LOISON Loison-sous-Lens 62 OK Typologie 1 HIVORY NOE
FR-62-708077 MERICOURT Méricourt 62 RAF — HIVORY NOE
FR-62-708078 NOYELLE GODAULT Noyelles-Godault 62 OK Typologie 3 HIVORY NOE
FR-62-708079 ANNAY Pont-à-Vendin 62 RAF — HIVORY NOE
FR-62-708081 BRUAY NORD Bruay-la-Buissière 62 OK Typologie 2 HIVORY NOE
FR-62-708082 HERSIN Hersin-Coupigny 62 OK Typologie 3 HIVORY NOE
FR-62-708086 BETHUNE GARE Béthune 62 RAF — HIVORY NOE
FR-62-708092 AUCHY LES MINES Auchy-les-Mines 62 OK Typologie 3 HIVORY NOE
FR-62-708103 OIGNIES DECLERCQ Oignies 62 RAF — HIVORY NOE
FR-62-708106 SAINS EN GOHELLE Sains-en-Gohelle 62 OK Typologie 1 HIVORY NOE
FR-62-708108 ABLAIN ST-NAZAIRE Carency 62 OK Typologie 1 HIVORY NOE
FR-62-708109 CALAIS TERMINAL Calais 62 OK Typologie 3 HIVORY NOE
FR-62-708110 COULOGNE SUD Coquelles 62 OK — HIVORY NOE
FR-62-708196 CALAIS HOVERPORT BIS Calais 62 OK Typologie 1 HIVORY NOE
FR-67-708770 OBENHEIM Obenheim 67 OK Typologie 3 HIVORY NOE
FR-67-708772 LAMPERTHEIM Lampertheim 67 RAF — HIVORY NOE
FR-67-708775 PFETTISHEIM Pfulgriesheim 67 OK Typologie 2 HIVORY NOE
FR-67-708776 HINSBOURG Hinsbourg 67 OK Typologie 2 HIVORY NOE
FR-67-708777 KRANZHUEBEL Haguenau 67 OK Typologie 2 HIVORY NOE
FR-67-708778 SURBOURG Surbourg 67 OK Typologie 2 HIVORY NOE
FR-67-708779 HERBITZHEIM Altwiller 67 OK Typologie 3 HIVORY NOE
FR-67-708783 BIETLENHEIM Bietlenheim 67 OK Typologie 2 HIVORY NOE
FR-67-708792 GEISPOLSHEIM VILLAGE Geispolsheim 67 OK Typologie 2 HIVORY NOE
FR-67-708808 LEMBACH Lembach 67 OK Typologie 3 HIVORY NOE
FR-67-708813 WOLFISHEIM Wolfisheim 67 RAF — HIVORY NOE
FR-67-708820 PORT SUD Strasbourg 67 OK Typologie 3 HIVORY NOE
FR-67-708823 BRUMATH ECHANGEUR Brumath 67 OK Typologie 2 HIVORY NOE
FR-67-708824 MUSSIG Mussig 67 OK Typologie 3 HIVORY NOE
FR-67-708828 WINGEN SUR MODER Wingen-sur-Moder 67 RAF — HIVORY NOE
FR-67-708829 HUTTENHEIM Huttenheim 67 OK Typologie 4 HIVORY NOE
FR-67-708843 SCHIRRHEIN Schirrhein 67 OK Typologie 3 HIVORY NOE
FR-67-708852 ZINSWILLER Zinswiller 67 OK Typologie 3 HIVORY NOE
FR-67-708853 OBERMODERN Schalkendorf 67 OK Typologie 2 HIVORY NOE
FR-67-708854 REIPERTSWILLER Reipertswiller 67 RAF — HIVORY NOE
FR-67-708857 GRENDELBRUCH Dinsheim-sur-Bruche 67 RAF — HIVORY NOE
FR-67-708861 FEGERSHEIM NORD Fegersheim 67 OK Typologie 2 HIVORY NOE
FR-67-708876 NATZWILLER Natzwiller 67 OK Typologie 3 HIVORY NOE
FR-67-708935 BRUMATH STEPHANSFELD 2 Brumath 67 RAF — HIVORY NOE
FR-68-000380 LA RAINCORNE Lièpvre 68 RAF — CELLNEX NOE
FR-68-708962 ALTKIRCH Altkirch 68 OK Typologie 2 HIVORY NOE
FR-68-708971 SIERENTZ Sierentz 68 OK Typologie 2 HIVORY NOE
FR-68-708973 BALDERSHEIM A36 Baldersheim 68 OK Typologie 3 HIVORY NOE
FR-68-708978 MUESPACH Muespach 68 OK Typologie 3 HIVORY NOE
FR-68-708979 WILLER-SUR-THUR Willer-sur-Thur 68 OK Typologie 5 HIVORY NOE
FR-68-708981 METZERAL Metzeral 68 OK Typologie 3 HIVORY NOE
FR-68-708983 SEPPOIS Seppois-le-Bas 68 RAF — HIVORY NOE
FR-68-708989 MARKSTEIN Linthal 68 OK Typologie 3 HIVORY NOE
FR-68-708991 WAHLBACH Zaessingue 68 RAF — HIVORY NOE
FR-68-709002 LE MITTELFELD Wittenheim 68 OK Typologie 2 HIVORY NOE
FR-68-709007 PFASTATT BSC Pfastatt 68 RAF — HIVORY NOE
FR-68-709010 STE MARIE AUX MINES ST PI Sainte-Marie-aux-Mines 68 OK Typologie 3 HIVORY NOE
FR-68-709012 BRUEBACH Bruebach 68 OK Typologie 3 HIVORY NOE
FR-68-709013 ASPACH-LE-BAS Aspach-le-Bas 68 OK Typologie 3 HIVORY NOE
FR-68-709016 MULHOUSE GARE NORD Mulhouse 68 OK Typologie 3 HIVORY NOE
FR-70-709587 SEMMADON Arbecey 70 OK Typologie 2 HIVORY CTA
FR-70-709588 GENEVREUILLE Genevreuille 70 NOK — HIVORY CTA
FR-70-709592 PERROUSE Aulx-lès-Cromary 70 OK Typologie 2 HIVORY CTA
FR-70-709593 DAMPVALLEY Dampvalley-lès-Colombe 70 OK — HIVORY CTA
FR-70-709599 FOUGEROLLES Fougerolles-Saint-Valbert 70 RAF — HIVORY CTA
FR-70-709601 POMOY Pomoy 70 OK Typologie 1 HIVORY CTA
FR-70-709606 LYOFFANS Magny-Jobert 70 OK Typologie 3 HIVORY CTA
FR-70-709611 AILLEVILLERS Aillevillers-et-Lyaumont 70 RAF — HIVORY CTA
FR-70-709612 ANDELARRE Andelarre 70 OK Typologie 3 HIVORY CTA
FR-70-709614 MONTIGNY-LES-VESOUL Andelarre 70 OK Typologie 2 HIVORY CTA
FR-70-709620 PLANCHER BAS Belfahy 70 OK Typologie 3 HIVORY CTA
FR-70-709621 RIOZ Neuvelle-lès-Cromary 70 OK Typologie 3 HIVORY CTA
FR-70-709624 LES PATEYS Esprels 70 OK Typologie 2 HIVORY CTA
FR-71-000041 MONT BROGNY Bissey-sous-Cruchaud 71 OK Typologie 3 CELLNEX CTA
FR-71-709695 LE BREUIL Le Breuil 71 OK Typologie 2 HIVORY CTA
FR-71-709717 SANVIGNES LES MINES Sanvignes-les-Mines 71 RAF — HIVORY CTA
FR-71-709726 BLANZY Blanzy 71 OK Typologie 4 HIVORY CTA
FR-71-709728 EPERVANS Ouroux-sur-Saône 71 OK — HIVORY CTA
FR-71-709731 LES GONNOFS Ciry-le-Noble 71 RAF — HIVORY CTA
FR-71-709733 MERVANS Mervans 71 OK Typologie 4 HIVORY CTA
FR-71-709745 MONTCEAU LA SORME Blanzy 71 RAF — HIVORY CTA
FR-75-002684 PARIS-18E Paris 18e arrondissement 75 RAF — CELLNEX IDF
FR-75-002764 PARIS-16E Paris 16e arrondissement 75 RAF — CELLNEX IDF
FR-75-713706 PARIS (INSEP_BIS) Paris 75 RAF — HIVORY IDF
FR-77-714068 LE PIN - VILLEVAUDE Le Pin 77 RAF — HIVORY IDF
FR-77-714076 CHAMPAGNE SUR SEINE Champagne-sur-Seine 77 OK Typologie 5 HIVORY IDF
FR-77-714079 LA FERTE GAUCHER La Ferté-Gaucher 77 OK Typologie 3 HIVORY IDF
FR-77-714081 MAISON ROUGE Maison-Rouge 77 OK Typologie 2 HIVORY IDF
FR-77-714082 MONTCEAUX LES PROVINS Montceaux-lès-Provins 77 OK Typologie 3 HIVORY IDF
FR-77-714083 PAMFOU Pamfou 77 OK Typologie 2 HIVORY IDF
FR-77-714087 THORIGNY/MARNE- DAMPMART Thorigny-sur-Marne 77 OK Typologie 1 HIVORY IDF
FR-77-714088 MITRY MORY Mitry-Mory 77 OK Typologie 5 HIVORY IDF
FR-77-714095 ESBLY Esbly 77 OK Typologie 2 HIVORY IDF
FR-77-714099 MOUSSY Moussy-le-Vieux 77 OK Typologie 2 HIVORY IDF
FR-77-714100 ST SIMEON Boissy-le-Châtel 77 OK Typologie 2 HIVORY IDF
FR-77-714101 CHAUMES EN BRIE Chaumes-en-Brie 77 OK Typologie 2 HIVORY IDF
FR-77-714102 MAUPERTHUIS Mauperthuis 77 OK Typologie 2 HIVORY IDF
FR-77-714106 CREVECOEUR EN BRIE Crèvecoeur-en-Brie 77 OK Typologie 1 HIVORY IDF
FR-77-714111 ST SAUVEUR SUR ECOLE Saint-Sauveur-sur-École 77 RAF — HIVORY IDF
FR-77-714132 OISSERY Oissery 77 OK Typologie 1 HIVORY IDF
FR-77-714135 VILLEMER Villemer 77 OK Typologie 1 HIVORY IDF
FR-77-714165 ANNET-SUR-MARNE Annet-sur-Marne 77 OK Typologie 3 HIVORY IDF
FR-77-714166 CONGIS Congis-sur-Thérouanne 77 OK Typologie 1 HIVORY IDF
FR-77-714170 SAACY-SUR-MARNE Saâcy-sur-Marne 77 OK — HIVORY IDF
FR-77-714171 VILLIERS-SUR-MORIN Villiers-sur-Morin 77 OK Typologie 3 HIVORY IDF
FR-77-714269 THORIGNY SUR MARNE Thorigny-sur-Marne 77 OK Typologie 1 HIVORY IDF
FR-77-714278 COMPANS_U Compans 77 OK Typologie 1 HIVORY IDF
FR-78-714323 BONNIERES Bonnières-sur-Seine 78 OK Typologie 2 HIVORY IDF
FR-78-714325 ST NOM LA BRETECHE Saint-Nom-la-Bretèche 78 OK Typologie 4 HIVORY IDF
FR-78-714327 POIGNY LA F-ST LEGER EN Y Poigny-la-Forêt 78 OK — HIVORY IDF
FR-78-714332 MAUREPAS Coignières 78 OK Typologie 3 HIVORY IDF
FR-78-714338 HOUDAN Houdan 78 RAF — HIVORY IDF
FR-78-714339 ROCQUENCOURT Le Chesnay-Rocquencourt 78 OK Typologie 2 HIVORY IDF
FR-78-714359 LE PERRAY EN YVELINES Le Perray-en-Yvelines 78 OK Typologie 2 HIVORY IDF
FR-78-714369 ACHERES GARE Saint-Germain-en-Laye 78 OK Typologie 4 HIVORY IDF
FR-78-714385 RAMBOUILLET-SUD Rambouillet 78 OK Typologie 1 HIVORY IDF
FR-78-714386 LIMAY (FOREST) Limay 78 OK Typologie 4 HIVORY IDF
FR-78-714414 RICHEBOURG ( D 953 ) Richebourg 78 OK Typologie 3 HIVORY IDF
FR-78-714570 DROUE (78) Émancé 78 OK Typologie 3 HIVORY IDF
FR-78-714609 BEYNES_BIS Beynes 78 RAF — HIVORY IDF
FR-80-710388 AIRAINES Airaines 80 OK Typologie 3 HIVORY NOE
FR-80-710391 FLIXECOURT Flixecourt 80 OK Typologie 4 HIVORY NOE
FR-80-710392 BELLOY SUR SOMME Belloy-sur-Somme 80 OK Typologie 2 HIVORY NOE
FR-80-710393 FOREST-MONTIERS Forest-Montiers 80 OK Typologie 1 HIVORY NOE
FR-80-710399 TALMAS Talmas 80 RAF — HIVORY NOE
FR-80-710400 ABBEVILLE LA JUSTICE Abbeville 80 OK Typologie 3 HIVORY NOE
FR-80-710402 VRON Vron 80 OK Typologie 1 HIVORY NOE
FR-80-710407 GAMACHES/LONGROY Gamaches 80 OK Typologie 2 HIVORY NOE
FR-80-710408 ROISEL Aizecourt-le-Bas 80 OK Typologie 1 HIVORY NOE
FR-80-710411 FEUQUIERES EN VIMEU Chépy 80 OK Typologie 3 HIVORY NOE
FR-80-710414 CANAPLES Pernois 80 OK Typologie 3 HIVORY NOE
FR-80-710416 CONTAY Contay 80 OK Typologie 1 HIVORY NOE
FR-80-710418 AILLY SUR SOMME Saint-Sauveur 80 OK Typologie 1 HIVORY NOE
FR-80-710419 CONTALMAISON Contalmaison 80 OK Typologie 1 HIVORY NOE
FR-80-710423 SAINT FUSCIEN Saint-Fuscien 80 OK Typologie 4 HIVORY NOE
FR-80-710430 LAUCOURT Laucourt 80 OK Typologie 1 HIVORY NOE
FR-80-710431 NAMPS AU VAL SNCF Namps-Maisnil 80 OK Typologie 3 HIVORY NOE
FR-80-710432 ST VAAST EN CHAUSSEE Saint-Vaast-en-Chaussée 80 OK Typologie 4 HIVORY NOE
FR-80-710434 BEAUQUESNE Beauquesne 80 OK Typologie 1 HIVORY NOE
FR-88-711280 NOMEXY Nomexy 88 RAF — HIVORY NOE
FR-88-711285 LANDAVILLE Landaville 88 OK Typologie 3 HIVORY NOE
FR-88-711286 VALFROICOURT Valfroicourt 88 RAF — HIVORY NOE
FR-88-711287 DOMBASLE EN XAINTOIS Dombasle-en-Xaintois 88 OK Typologie 2 HIVORY NOE
FR-88-711288 AYDOILLES Longchamp 88 RAF — HIVORY NOE
FR-88-711290 LE THOLY BONNE FONTAINE Le Tholy 88 RAF — HIVORY NOE
FR-88-711292 PLAINFAING Plainfaing 88 RAF — HIVORY NOE
FR-88-711293 MONTHUREUX SUR SAONE Monthureux-sur-Saône 88 OK Typologie 3 HIVORY NOE
FR-88-711295 FAUCOMPIERRE Faucompierre 88 RAF — HIVORY NOE
FR-88-711298 UZEMAIN Uzemain 88 RAF — HIVORY NOE
FR-88-711300 GRANDVILLERS Grandvillers 88 RAF — HIVORY NOE
FR-88-711301 SAPOIS Vagney 88 RAF — HIVORY NOE
FR-88-711304 HADOL Dounoux 88 RAF — HIVORY NOE
FR-89-711387 PROVENCY Provency 89 OK Typologie 2 HIVORY CTA
FR-89-711391 LES GAUDRIS Saint-Loup-d'Ordon 89 OK Typologie 5 HIVORY CTA
FR-89-711392 BAGNEAUX Bagneaux 89 NOK — HIVORY CTA
FR-89-711393 GUERCHY Valravillon 89 OK Typologie 1 HIVORY CTA
FR-89-711397 APPOIGNY Beaumont 89 OK Typologie 1 HIVORY CTA
FR-89-711404 MONT ST SULPICE Beaumont 89 OK Typologie 1 HIVORY CTA
FR-89-711406 VILLIERS VINEUX Méré 89 RAF — HIVORY CTA
FR-89-711407 DYE Dyé 89 OK Typologie 1 HIVORY CTA
FR-89-711411 MARMEAUX Marmeaux 89 RAF — HIVORY CTA
FR-89-711414 ST FLORENTIN ROSIERS Chéu 89 OK Typologie 1 HIVORY CTA
FR-89-711422 CHENEY Dannemoine 89 OK Typologie 3 HIVORY CTA
FR-90-711447 ETUEFFONT Étueffont 90 OK Typologie 4 HIVORY CTA
FR-90-711448 BEAUCOURT CENTRE Beaucourt 90 OK — HIVORY CTA
FR-91-002582 SAINTE-GENEVIEVE-DES-BOIS Sainte-Geneviève-des-Bois 91 RAF — CELLNEX IDF
FR-91-711468 AUVERNAUX-AUXONNETTE Auvernaux 91 OK Typologie 2 HIVORY IDF
FR-91-711479 VILLABE Villabé 91 RAF — HIVORY IDF
FR-91-711485 ST GERMAIN L CORB - TIGER Saint-Germain-lès-Corbeil 91 RAF — HIVORY IDF
FR-91-711488 ETAMPES SUCRERIE Étampes 91 OK Typologie 1 HIVORY IDF
FR-91-711493 LA FERTE ALAIS (CENTRE) La Ferté-Alais 91 OK Typologie 1 HIVORY IDF
FR-91-711494 SERMAISE Sermaise 91 OK Typologie 1 HIVORY IDF
FR-91-711499 BRUNOY Brunoy 91 OK Typologie 2 HIVORY IDF
FR-91-711503 ST MICHEL SUR ORGE Saint-Michel-sur-Orge 91 OK Typologie 3 HIVORY IDF
FR-91-711507 LEUVILLE-SUR-ORGE Leuville-sur-Orge 91 OK Typologie 2 HIVORY IDF
FR-91-711512 CHAMPLAN Champlan 91 RAF — HIVORY IDF
FR-91-711516 RIS-ORANGIS (STADE) Ris-Orangis 91 RAF — HIVORY IDF
FR-91-711518 COURCOURONNES Évry-Courcouronnes 91 OK Typologie 3 HIVORY IDF
FR-91-711528 AVRAINVILLE N20 Avrainville 91 OK Typologie 1 HIVORY IDF
FR-91-711548 VERRIERES-LE-BUISSON Verrières-le-Buisson 91 OK Typologie 3 HIVORY IDF
FR-91-711552 ST GERMAIN LES CORBEIL Saint-Germain-lès-Corbeil 91 OK Typologie 3 HIVORY IDF
FR-91-711554 ORSAY (MONDETOUR) Les Ulis 91 OK — HIVORY IDF
FR-91-711555 EPINAY/ORGE (BAS FOLLETS) Épinay-sur-Orge 91 OK Typologie 1 HIVORY IDF
FR-91-711576 QUINCY (JARCY) Varennes-Jarcy 91 OK Typologie 3 HIVORY IDF
FR-91-711727 ST GERMAIN ARPAJON BIS Brétigny-sur-Orge 91 OK — HIVORY IDF
FR-92-711833 LA GARENNE(PAQUERETTES) Nanterre 92 RAF — HIVORY IDF
FR-93-002810 BONDY/15 RUE JULES GUESDE Bondy 93 OK Typologie 3 CELLNEX IDF
FR-93-712228 LA COURNEUVE (A1) La Courneuve 93 OK Typologie 1 HIVORY IDF
FR-93-712232 VILLEPINTE (CASTORS) Villepinte 93 OK — HIVORY IDF
FR-94-712511 ST MAUR (LES CORNEILLES) Saint-Maur-des-Fossés 94 OK Typologie 1 HIVORY IDF
FR-94-712528 CHAMPIGNY (ZAC) Champigny-sur-Marne 94 RAF — HIVORY IDF
FR-94-712577 CHAMPIGNY (JARDINS) Champigny-sur-Marne 94 OK Typologie 1 HIVORY IDF
FR-94-712609 CRETEIL(PASTEUR V.RADOT) Créteil 94 OK Typologie 1 HIVORY IDF
FR-95-002836 — — 95 RAF — CELLNEX IDF
FR-95-712815 PIERRELAYE Pierrelaye 95 OK Typologie 2 HIVORY IDF
FR-95-712817 MERY SUR OISE Méry-sur-Oise 95 OK Typologie 3 HIVORY IDF
FR-95-712828 ENNERY-PONTOISE(LE CHOU) Ennery 95 OK Typologie 1 HIVORY IDF
FR-95-712832 PIERRELAYE - BEAUCHAMP Pierrelaye 95 OK Typologie 5 HIVORY IDF
FR-95-712838 ANDILLY - SOISY S/ MONT. Montmorency 95 OK Typologie 5 HIVORY IDF
FR-95-712841 PRESLES PR15 Presles 95 OK Typologie 1 HIVORY IDF
FR-95-712927 CORMEILLES_PARISIS(SDIS) Cormeilles-en-Parisis 95 OK Typologie 3 HIVORY IDF
FR-95-712950 OSNY(STADE C.LEON) Osny 95 OK Typologie 3 HIVORY IDF
FR-95-712955 SARCELLES(MONT DE GIF) Sarcelles 95 OK Typologie 4 HIVORY IDF
FR-95-713045 LOUVRES VAL NOEL Louvres 95 OK Typologie 2 HIVORY IDF
FR-95-713049 VIARMES BIS Viarmes 95 OK Typologie 1 HIVORY IDF
FR-77-714125 — — — OK Typologie 1 — —
FR-77-714078 — — — OK Typologie 2 — —
FR-77-714098 — — — OK Typologie 2 — —
FR-54-706734 — — — OK Typologie 4 — —
FR-77-714095 — — 77 OK Typologie 2 HIVORY IDF
FR-75-001933 — PARIS 9 — OK Typologie 2 — —
508 / 508 sites Cliquez sur un en-tête pour trier
DÉTAIL PAR PRESTATION
PRESTATION QTÉ P.U. TOTAL
Intervention (sites OK) 300 330,00 € 99 000,00 €
Pose chaîne Abus 241 45,84 € 11 047,44 €
Pose cadenas Abus 244 49,50 € 12 078,00 €
Pose œillets 87 35,00 € 3 045,00 €
Serrure Typo 1 (ECID) 79 195,28 € 15 427,12 €
↳ Peine & Soins Typo 1 (8%) 79 15,62 € 1 234,17 €
Serrure Typo 2 (ECID) 66 292,76 € 19 322,16 €
↳ Peine & Soins Typo 2 (8%) 66 23,42 € 1 545,77 €
Serrure Typo 3 (ECID) 101 274,61 € 27 735,61 €
↳ Peine & Soins Typo 3 (8%) 101 21,97 € 2 218,85 €
Serrure Typo 4 (ECID) 26 292,76 € 7 611,76 €
↳ Peine & Soins Typo 4 (8%) 26 23,42 € 608,94 €
Serrure Typo 5 (ECID) 9 658,58 € 5 927,22 €
↳ Peine & Soins Typo 5 (8%) 9 52,69 € 474,18 €
Étude documentaire 1 lot 25 150,00 € 25 150,00 €
TOTAL PROJET
€ 232 426
Interventions 99 000 €
Matériel installé 26 170 €
Serrures ECID (PU) 76 024 €
↳ Peine & Soins (8%) 6 082 €
Étude documentaire 25 150 €
↓ CALCUL AUTOMATIQUE BASÉ SUR LES POSES VALIDÉES
📂 Importer les données depuis Excel

Glissez votre fichier Excel .xlsx ci-dessous ou cliquez pour le sélectionner. Les données seront mémorisées localement dans votre navigateur.

📊
Glissez votre fichier ici
ou cliquez pour parcourir · format .xlsx accepté
Feuille attendue : "Tableau de bord" avec colonnes Site, Code site op, Nom du site, Adresse, Ville, X, Y, RAF (statut), Typologie serrure, Pose cylindre ILOQ, Pose chaine, Pose cadenas, Pose cadenas ILOQ, Œillets, Commentaire THF.
';var ro="";function to(e,r){var t=e.match(/[\s\S]*?<\/table>/gi);if(!t||t.length==0)throw new Error("Invalid HTML: could not find ");if(t.length==1)return Ia(Zl(t[0],r),r);var a=hc();t.forEach(function(e,t){pc(a,Zl(e,r),"Sheet"+(t+1))});return a}function ao(e,r,t){var a=[];return a.join("")+""}function no(e,r){var t=r||{};var a=t.header!=null?t.header:eo;var n=t.footer!=null?t.footer:ro;var i=[a];var s=Da(e["!ref"]);t.dense=Array.isArray(e);i.push(ao(e,s,t));for(var l=s.s.r;l<=s.e.r;++l)i.push(Ql(e,s,l,t));i.push("
"+n);return i.join("")}function io(e,r,t){var a=t||{};if(m!=null)a.dense=m;var n=0,i=0;if(a.origin!=null){if(typeof a.origin=="number")n=a.origin;else{var s=typeof a.origin=="string"?Ea(a.origin):a.origin;n=s.r;i=s.c}}var l=r.getElementsByTagName("tr");var o=Math.min(a.sheetRows||1e7,l.length);var c={s:{r:0,c:0},e:{r:n,c:i}};if(e["!ref"]){var f=Da(e["!ref"]);c.s.r=Math.min(c.s.r,f.s.r);c.s.c=Math.min(c.s.c,f.s.c);c.e.r=Math.max(c.e.r,f.e.r);c.e.c=Math.max(c.e.c,f.e.c);if(n==-1)c.e.r=n=f.e.r+1}var u=[],h=0;var p=e["!rows"]||(e["!rows"]=[]);var d=0,v=0,g=0,b=0,w=0,y=0;if(!e["!cols"])e["!cols"]=[];for(;d1||y>1)u.push({s:{r:v+n,c:b+i},e:{r:v+n+(w||1)-1,c:b+i+(y||1)-1}});var T={t:"s",v:C};var E=S.getAttribute("data-t")||S.getAttribute("t")||"";if(C!=null){if(C.length==0)T.t=E||"z";else if(a.raw||C.trim().length==0||E=="s"){}else if(C==="TRUE")T={t:"b",v:true};else if(C==="FALSE")T={t:"b",v:false};else if(!isNaN(wr(C)))T={t:"n",v:wr(C)};else if(!isNaN(kr(C).getDate())){T={t:"d",v:mr(C)};if(!a.cellDates)T={t:"n",v:sr(T.v)};T.z=a.dateNF||X[14]}}if(T.z===undefined&&_!=null)T.z=_;var F="",D=S.getElementsByTagName("A");if(D&&D.length)for(var O=0;O=o)e["!fullref"]=Oa((c.e.r=l.length-d+v-1+n,c));return e}function so(e,r){var t=r||{};var a=t.dense?[]:{};return io(a,e,r)}function lo(e,r){return Ia(so(e,r),r)}function oo(e){var r="";var t=co(e);if(t)r=t(e).getPropertyValue("display");if(!r)r=e.style&&e.style.display;return r==="none"}function co(e){if(e.ownerDocument.defaultView&&typeof e.ownerDocument.defaultView.getComputedStyle==="function")return e.ownerDocument.defaultView.getComputedStyle;if(typeof getComputedStyle==="function")return getComputedStyle;return null}function fo(e){var r=e.replace(/[\t\r\n]/g," ").trim().replace(/ +/g," ").replace(//g," ").replace(//g,function(e,r){return Array(parseInt(r,10)+1).join(" ")}).replace(/]*\/>/g,"\t").replace(//g,"\n");var t=Gr(r.replace(/<[^>]*>/g,""));return[t]}var uo={day:["d","dd"],month:["m","mm"],year:["y","yy"],hours:["h","hh"],minutes:["m","mm"],seconds:["s","ss"],"am-pm":["A/P","AM/PM"],"day-of-week":["ddd","dddd"],era:["e","ee"],quarter:["\\Qm",'m\\"th quarter"']};function ho(e,r){var t=r||{};if(m!=null&&t.dense==null)t.dense=m;var a=xt(e);var n=[],i;var s;var l={name:""},o="",c=0;var f;var u;var h={},p=[];var d=t.dense?[]:{};var v,g;var b={value:""};var w="",y=0,k;var x=[];var S=-1,C=-1,_={s:{r:1e6,c:1e7},e:{r:0,c:0}};var A=0;var T={};var E=[],F={},D=0,O=0;var M=[],N=1,P=1;var I=[];var R={Names:[]};var L={};var B=["",""];var $=[],z={};var U="",W=0;var j=false,H=false;var V=0;St.lastIndex=0;a=a.replace(//gm,"").replace(//gm,"");while(v=St.exec(a))switch(v[3]=v[3].replace(/_.*$/,"")){case"table":;case"工作表":if(v[1]==="/"){if(_.e.c>=_.s.c&&_.e.r>=_.s.r)d["!ref"]=Oa(_);else d["!ref"]="A1:A1";if(t.sheetRows>0&&t.sheetRows<=_.e.r){d["!fullref"]=d["!ref"];_.e.r=t.sheetRows-1;d["!ref"]=Oa(_)}if(E.length)d["!merges"]=E;if(M.length)d["!rows"]=M;f.name=f["名称"]||f.name;if(typeof JSON!=="undefined")JSON.stringify(f);p.push(f.name);h[f.name]=d;H=false}else if(v[0].charAt(v[0].length-2)!=="/"){f=jr(v[0],false);S=C=-1;_.s.r=_.s.c=1e7;_.e.r=_.e.c=0;d=t.dense?[]:{};E=[];M=[];H=true}break;case"table-row-group":if(v[1]==="/")--A;else++A;break;case"table-row":;case"行":if(v[1]==="/"){S+=N;N=1;break}u=jr(v[0],false);if(u["行号"])S=u["行号"]-1;else if(S==-1)S=0;N=+u["number-rows-repeated"]||1;if(N<10)for(V=0;V0)M[S+V]={level:A};C=-1;break;case"covered-table-cell":if(v[1]!=="/")++C;if(t.sheetStubs){if(t.dense){if(!d[S])d[S]=[];d[S][C]={t:"z"}}else d[Fa({r:S,c:C})]={t:"z"}}w="";x=[];break;case"table-cell":;case"数据":if(v[0].charAt(v[0].length-2)==="/"){++C;b=jr(v[0],false);P=parseInt(b["number-columns-repeated"]||"1",10);g={t:"z",v:null};if(b.formula&&t.cellFormula!=false)g.f=xs(Gr(b.formula));if((b["数据类型"]||b["value-type"])=="string"){g.t="s";g.v=Gr(b["string-value"]||"");if(t.dense){if(!d[S])d[S]=[];d[S][C]=g}else{d[Fa({r:S,c:C})]=g}}C+=P-1}else if(v[1]!=="/"){++C;w="";y=0;x=[];P=1;var X=N?S+N-1:S;if(C>_.e.c)_.e.c=C;if(C<_.s.c)_.s.c=C;if(S<_.s.r)_.s.r=S;if(X>_.e.r)_.e.r=X;b=jr(v[0],false);$=[];z={};g={t:b["数据类型"]||b["value-type"],v:null};if(t.cellFormula){if(b.formula)b.formula=Gr(b.formula);if(b["number-matrix-columns-spanned"]&&b["number-matrix-rows-spanned"]){D=parseInt(b["number-matrix-rows-spanned"],10)||0;O=parseInt(b["number-matrix-columns-spanned"],10)||0;F={s:{r:S,c:C},e:{r:S+D-1,c:C+O-1}};g.F=Oa(F);I.push([F,g.F])}if(b.formula)g.f=xs(b.formula);else for(V=0;V=I[V][0].s.r&&S<=I[V][0].e.r)if(C>=I[V][0].s.c&&C<=I[V][0].e.c)g.F=I[V][1]}if(b["number-columns-spanned"]||b["number-rows-spanned"]){D=parseInt(b["number-rows-spanned"],10)||0;O=parseInt(b["number-columns-spanned"],10)||0;F={s:{r:S,c:C},e:{r:S+D-1,c:C+O-1}};E.push(F)}if(b["number-columns-repeated"])P=parseInt(b["number-columns-repeated"],10);switch(g.t){case"boolean":g.t="b";g.v=at(b["boolean-value"]);break;case"float":g.t="n";g.v=parseFloat(b.value);break;case"percentage":g.t="n";g.v=parseFloat(b.value);break;case"currency":g.t="n";g.v=parseFloat(b.value);break;case"date":g.t="d";g.v=mr(b["date-value"]);if(!t.cellDates){g.t="n";g.v=sr(g.v)}g.z="m/d/yy";break;case"time":g.t="n";g.v=ur(b["time-value"])/86400;if(t.cellDates){g.t="d";g.v=fr(g.v)}g.z="HH:MM:SS";break;case"number":g.t="n";g.v=parseFloat(b["数据数值"]);break;default:if(g.t==="string"||g.t==="text"||!g.t){g.t="s";if(b["string-value"]!=null){w=Gr(b["string-value"]);x=[]}}else throw new Error("Unsupported value type "+g.t);}}else{j=false;if(g.t==="s"){g.v=w||"";if(x.length)g.R=x;j=y==0}if(L.Target)g.l=L;if($.length>0){g.c=$;$=[]}if(w&&t.cellText!==false)g.w=w;if(j){g.t="z";delete g.v}if(!j||t.sheetStubs){if(!(t.sheetRows&&t.sheetRows<=S)){for(var G=0;G0)d[S+G][C+P]=gr(g)}else{d[Fa({r:S+G,c:C})]=g;while(--P>0)d[Fa({r:S+G,c:C+P})]=gr(g)}if(_.e.c<=C)_.e.c=C}}}P=parseInt(b["number-columns-repeated"]||"1",10);C+=P-1;P=0;g={};w="";x=[]}L={};break;case"document":;case"document-content":;case"电子表格文档":;case"spreadsheet":;case"主体":;case"scripts":;case"styles":;case"font-face-decls":;case"master-styles":if(v[1]==="/"){if((i=n.pop())[0]!==v[3])throw"Bad state: "+i}else if(v[0].charAt(v[0].length-2)!=="/")n.push([v[3],true]);break;case"annotation":if(v[1]==="/"){if((i=n.pop())[0]!==v[3])throw"Bad state: "+i;z.t=w;if(x.length)z.R=x;z.a=U;$.push(z)}else if(v[0].charAt(v[0].length-2)!=="/"){n.push([v[3],false])}U="";W=0;w="";y=0;x=[];break;case"creator":if(v[1]==="/"){U=a.slice(W,v.index)}else W=v.index+v[0].length;break;case"meta":;case"元数据":;case"settings":;case"config-item-set":;case"config-item-map-indexed":;case"config-item-map-entry":;case"config-item-map-named":;case"shapes":;case"frame":;case"text-box":;case"image":;case"data-pilot-tables":;case"list-style":;case"form":;case"dde-links":;case"event-listeners":;case"chart":if(v[1]==="/"){if((i=n.pop())[0]!==v[3])throw"Bad state: "+i}else if(v[0].charAt(v[0].length-2)!=="/")n.push([v[3],false]);w="";y=0;x=[];break;case"scientific-number":break;case"currency-symbol":break;case"currency-style":break;case"number-style":;case"percentage-style":;case"date-style":;case"time-style":if(v[1]==="/"){T[l.name]=o;if((i=n.pop())[0]!==v[3])throw"Bad state: "+i}else if(v[0].charAt(v[0].length-2)!=="/"){o="";l=jr(v[0],false);n.push([v[3],true])}break;case"script":break;case"libraries":break;case"automatic-styles":break;case"default-style":;case"page-layout":break;case"style":break;case"map":break;case"font-face":break;case"paragraph-properties":break;case"table-properties":break;case"table-column-properties":break;case"table-row-properties":break;case"table-cell-properties":break;case"number":switch(n[n.length-1][0]){case"time-style":;case"date-style":s=jr(v[0],false);o+=uo[v[3]][s.style==="long"?1:0];break;}break;case"fraction":break;case"day":;case"month":;case"year":;case"era":;case"day-of-week":;case"week-of-year":;case"quarter":;case"hours":;case"minutes":;case"seconds":;case"am-pm":switch(n[n.length-1][0]){case"time-style":;case"date-style":s=jr(v[0],false);o+=uo[v[3]][s.style==="long"?1:0];break;}break;case"boolean-style":break;case"boolean":break;case"text-style":break;case"text":if(v[0].slice(-2)==="/>")break;else if(v[1]==="/")switch(n[n.length-1][0]){case"number-style":;case"date-style":;case"time-style":o+=a.slice(c,v.index);break;}else c=v.index+v[0].length;break;case"named-range":s=jr(v[0],false);B=Cs(s["cell-range-address"]);var Y={Name:s.name,Ref:B[0]+"!"+B[1]};if(H)Y.Sheet=p.length;R.Names.push(Y);break;case"text-content":break;case"text-properties":break;case"embedded-text":break;case"body":;case"电子表格":break;case"forms":break;case"table-column":break;case"table-header-rows":break;case"table-rows":break;case"table-column-group":break;case"table-header-columns":break;case"table-columns":break;case"null-date":break;case"graphic-properties":break;case"calculation-settings":break;case"named-expressions":break;case"label-range":break;case"label-ranges":break;case"named-expression":break;case"sort":break;case"sort-by":break;case"sort-groups":break;case"tab":break;case"line-break":break;case"span":break;case"p":;case"文本串":if(["master-styles"].indexOf(n[n.length-1][0])>-1)break;if(v[1]==="/"&&(!b||!b["string-value"])){var J=fo(a.slice(y,v.index),k);w=(w.length>0?w+"\n":"")+J[0]}else{k=jr(v[0],false);y=v.index+v[0].length}break;case"s":break;case"database-range":if(v[1]==="/")break;try{B=Cs(jr(v[0])["target-range-address"]);h[B[0]]["!autofilter"]={ref:B[1]}}catch(K){}break;case"date":break;case"object":break;case"title":;case"标题":break;case"desc":break;case"binary-data":break;case"table-source":break;case"scenario":break;case"iteration":break;case"content-validations":break;case"content-validation":break;case"help-message":break;case"error-message":break;case"database-ranges":break;case"filter":break;case"filter-and":break;case"filter-or":break;case"filter-condition":break;case"list-level-style-bullet":break;case"list-level-style-number":break;case"list-level-properties":break;case"sender-firstname":;case"sender-lastname":;case"sender-initials":;case"sender-title":;case"sender-position":;case"sender-email":;case"sender-phone-private":;case"sender-fax":;case"sender-company":;case"sender-phone-work":;case"sender-street":;case"sender-city":;case"sender-postal-code":;case"sender-country":;case"sender-state-or-province":;case"author-name":;case"author-initials":;case"chapter":;case"file-name":;case"template-name":;case"sheet-name":break;case"event-listener":break;case"initial-creator":;case"creation-date":;case"print-date":;case"generator":;case"document-statistic":;case"user-defined":;case"editing-duration":;case"editing-cycles":break;case"config-item":break;case"page-number":break;case"page-count":break;case"time":break;case"cell-range-source":break;case"detective":break;case"operation":break;case"highlighted-range":break;case"data-pilot-table":;case"source-cell-range":;case"source-service":;case"data-pilot-field":;case"data-pilot-level":;case"data-pilot-subtotals":;case"data-pilot-subtotal":;case"data-pilot-members":;case"data-pilot-member":;case"data-pilot-display-info":;case"data-pilot-sort-info":;case"data-pilot-layout-info":;case"data-pilot-field-reference":;case"data-pilot-groups":;case"data-pilot-group":;case"data-pilot-group-member":break;case"rect":break;case"dde-connection-decls":;case"dde-connection-decl":;case"dde-link":;case"dde-source":break;case"properties":break;case"property":break;case"a":if(v[1]!=="/"){L=jr(v[0],false);if(!L.href)break;L.Target=Gr(L.href);delete L.href;if(L.Target.charAt(0)=="#"&&L.Target.indexOf(".")>-1){B=Cs(L.Target.slice(1));L.Target="#"+B[0]+"!"+B[1]}else if(L.Target.match(/^\.\.[\\\/]/))L.Target=L.Target.slice(3)}break;case"table-protection":break;case"data-pilot-grand-total":break;case"office-document-common-attrs":break;default:switch(v[2]){case"dc:":;case"calcext:":;case"loext:":;case"ooo:":;case"chartooo:":;case"draw:":;case"style:":;case"chart:":;case"form:":;case"uof:":;case"表:":;case"字:":break;default:if(t.WTF)throw new Error(v);};}var q={Sheets:h,SheetNames:p,Workbook:R};if(t.bookSheets)delete q.Sheets;return q}function po(e,r){r=r||{};if(Ar(e,"META-INF/manifest.xml"))yn(Er(e,"META-INF/manifest.xml"),r);var t=Fr(e,"content.xml");if(!t)throw new Error("Missing content.xml in ODS / UOF file");var a=ho(ot(t),r);if(Ar(e,"meta.xml"))a.Props=En(Er(e,"meta.xml"));return a}function mo(e,r){return ho(e,r)}var vo=function(){var e=["",'',"",'',"",'',"",""].join("");var r=""+e+"";return function t(){return Rr+r}}();var go=function(){var e=function(e){return Kr(e).replace(/ +/g,function(e){return''}).replace(/\t/g,"").replace(/\n/g,"").replace(/^ /,"").replace(/ $/,"")};var r=" \n";var t=" \n";var a=function(a,n,i){var s=[];s.push(' \n');var l=0,o=0,c=Da(a["!ref"]||"A1");var f=a["!merges"]||[],u=0;var h=Array.isArray(a);if(a["!cols"]){for(o=0;o<=c.e.c;++o)s.push(" \n")}var p="",d=a["!rows"]||[];for(l=0;l\n")}for(;l<=c.e.r;++l){p=d[l]?' table:style-name="ro'+d[l].ods+'"':"";s.push(" \n");for(o=0;oo)continue;if(f[u].s.r>l)continue;if(f[u].e.c\n")}s.push(" \n");return s.join("")};var n=function(e,r){e.push(" \n");e.push(' \n');e.push(' \n');e.push(" /\n");e.push(' \n');e.push(" /\n");e.push(" \n");e.push(" \n");var t=0;r.SheetNames.map(function(e){return r.Sheets[e]}).forEach(function(r){if(!r)return;if(r["!cols"]){for(var a=0;a\n');e.push(' \n');e.push(" \n");++t}}});var a=0;r.SheetNames.map(function(e){return r.Sheets[e]}).forEach(function(r){if(!r)return;if(r["!rows"]){for(var t=0;t\n');e.push(' \n');e.push(" \n");++a}}});e.push(' \n');e.push(' \n');e.push(" \n");e.push(' \n');e.push(" \n")};return function i(e,r){var t=[Rr];var i=bt({"xmlns:office":"urn:oasis:names:tc:opendocument:xmlns:office:1.0","xmlns:table":"urn:oasis:names:tc:opendocument:xmlns:table:1.0","xmlns:style":"urn:oasis:names:tc:opendocument:xmlns:style:1.0","xmlns:text":"urn:oasis:names:tc:opendocument:xmlns:text:1.0","xmlns:draw":"urn:oasis:names:tc:opendocument:xmlns:drawing:1.0","xmlns:fo":"urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0","xmlns:xlink":"http://www.w3.org/1999/xlink","xmlns:dc":"http://purl.org/dc/elements/1.1/","xmlns:meta":"urn:oasis:names:tc:opendocument:xmlns:meta:1.0","xmlns:number":"urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0","xmlns:presentation":"urn:oasis:names:tc:opendocument:xmlns:presentation:1.0","xmlns:svg":"urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0","xmlns:chart":"urn:oasis:names:tc:opendocument:xmlns:chart:1.0","xmlns:dr3d":"urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0","xmlns:math":"http://www.w3.org/1998/Math/MathML","xmlns:form":"urn:oasis:names:tc:opendocument:xmlns:form:1.0","xmlns:script":"urn:oasis:names:tc:opendocument:xmlns:script:1.0","xmlns:ooo":"http://openoffice.org/2004/office","xmlns:ooow":"http://openoffice.org/2004/writer","xmlns:oooc":"http://openoffice.org/2004/calc","xmlns:dom":"http://www.w3.org/2001/xml-events","xmlns:xforms":"http://www.w3.org/2002/xforms","xmlns:xsd":"http://www.w3.org/2001/XMLSchema","xmlns:xsi":"http://www.w3.org/2001/XMLSchema-instance","xmlns:sheet":"urn:oasis:names:tc:opendocument:sh33tjs:1.0","xmlns:rpt":"http://openoffice.org/2005/report","xmlns:of":"urn:oasis:names:tc:opendocument:xmlns:of:1.2","xmlns:xhtml":"http://www.w3.org/1999/xhtml","xmlns:grddl":"http://www.w3.org/2003/g/data-view#","xmlns:tableooo":"http://openoffice.org/2009/table","xmlns:drawooo":"http://openoffice.org/2010/draw","xmlns:calcext":"urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0","xmlns:loext":"urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0","xmlns:field":"urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0","xmlns:formx":"urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0","xmlns:css3t":"http://www.w3.org/TR/css3-text/","office:version":"1.2"});var s=bt({"xmlns:config":"urn:oasis:names:tc:opendocument:xmlns:config:1.0","office:mimetype":"application/vnd.oasis.opendocument.spreadsheet"});if(r.bookType=="fods"){t.push("\n");t.push(_n().replace(/office:document-meta/g,"office:meta"))}else t.push("\n");n(t,e);t.push(" \n");t.push(" \n");for(var l=0;l!=e.SheetNames.length;++l)t.push(a(e.Sheets[e.SheetNames[l]],e,l,r));t.push(" \n");t.push(" \n");if(r.bookType=="fods")t.push("");else t.push("");return t.join("")}}();function bo(e,r){if(r.bookType=="fods")return go(e,r);var t=Nr();var a="";var n=[];var i=[];a="mimetype";Mr(t,a,"application/vnd.oasis.opendocument.spreadsheet");a="content.xml";Mr(t,a,go(e,r));n.push([a,"text/xml"]);i.push([a,"ContentFile"]);a="styles.xml";Mr(t,a,vo(e,r));n.push([a,"text/xml"]);i.push([a,"StylesFile"]);a="meta.xml";Mr(t,a,Rr+_n());n.push([a,"text/xml"]);i.push([a,"MetadataFile"]);a="manifest.rdf";Mr(t,a,Cn(i));n.push([a,"application/rdf+xml"]);a="META-INF/manifest.xml";Mr(t,a,kn(n));return t}function wo(e){return function r(t){for(var a=0;a!=e.length;++a){var n=e[a];if(t[n[0]]===undefined)t[n[0]]=n[1];if(n[2]==="n")t[n[0]]=Number(t[n[0]])}}}function yo(e){wo([["cellNF",false],["cellHTML",true],["cellFormula",true],["cellStyles",false],["cellText",true],["cellDates",false],["sheetStubs",false],["sheetRows",0,"n"],["bookDeps",false],["bookSheets",false],["bookProps",false],["bookFiles",false],["bookVBA",false],["password",""],["WTF",false]])(e)}function ko(e){wo([["cellDates",false],["bookSST",false],["bookType","xlsx"],["compression",false],["WTF",false]])(e)}function xo(e){if(dn.WS.indexOf(e)>-1)return"sheet";if(dn.CS&&e==dn.CS)return"chart";if(dn.DS&&e==dn.DS)return"dialog";if(dn.MS&&e==dn.MS)return"macro";return e&&e.length?e:"sheet"}function So(e,r){if(!e)return 0;try{e=r.map(function a(r){if(!r.id)r.id=r.strRelID;return[r.name,e["!id"][r.id].Target,xo(e["!id"][r.id].Type)]})}catch(t){return null}return!e||e.length===0?null:e}function Co(e,r,t,a,n,i,s,l,o,c,f,u){try{i[a]=vn(Fr(e,t,true),r);var h=Er(e,r);var p;switch(l){case"sheet":p=Pl(h,r,n,o,i[a],c,f,u);break;case"chart":p=Il(h,r,n,o,i[a],c,f,u);if(!p||!p["!drawel"])break;var d=Ir(p["!drawel"].Target,r);var m=mn(d);var v=qi(Fr(e,d,true),vn(Fr(e,m,true),d));var g=Ir(v,d);var b=mn(g);p=ml(Fr(e,g,true),g,o,vn(Fr(e,b,true),g),c,p);break;case"macro":p=Rl(h,r,n,o,i[a],c,f,u);break;case"dialog":p=Ll(h,r,n,o,i[a],c,f,u);break;default:throw new Error("Unrecognized sheet type "+l);}s[a]=p;var w=[];if(i&&i[a])er(i[a]).forEach(function(t){var n="";if(i[a][t].Type==dn.CMNT){n=Ir(i[a][t].Target,r);var s=Ul(Er(e,n,true),n,o);if(!s||!s.length)return;es(p,s,false)}if(i[a][t].Type==dn.TCMNT){n=Ir(i[a][t].Target,r);w=w.concat(as(Er(e,n,true),o)); }});if(w&&w.length)es(p,w,true,o.people||[])}catch(y){if(o.WTF)throw y}}function _o(e){return e.charAt(0)=="/"?e.slice(1):e}function Ao(e,r){Ue();r=r||{};yo(r);if(Ar(e,"META-INF/manifest.xml"))return po(e,r);if(Ar(e,"objectdata.xml"))return po(e,r);if(Ar(e,"Index/Document.iwa")){if(typeof Uint8Array=="undefined")throw new Error("NUMBERS file parsing requires Uint8Array support");if(typeof parse_numbers_iwa!="undefined"){if(e.FileIndex)return parse_numbers_iwa(e);var t=Ye.utils.cfb_new();Or(e).forEach(function(r){Mr(t,r,Dr(e,r))});return parse_numbers_iwa(t)}throw new Error("Unsupported NUMBERS file")}if(!Ar(e,"[Content_Types].xml")){if(Ar(e,"index.xml.gz"))throw new Error("Unsupported NUMBERS 08 file");if(Ar(e,"index.xml"))throw new Error("Unsupported NUMBERS 09 file");throw new Error("Unsupported ZIP file")}var a=Or(e);var n=hn(Fr(e,"[Content_Types].xml"));var i=false;var s,l;if(n.workbooks.length===0){l="xl/workbook.xml";if(Er(e,l,true))n.workbooks.push(l)}if(n.workbooks.length===0){l="xl/workbook.bin";if(!Er(e,l,true))throw new Error("Could not find workbook");n.workbooks.push(l);i=true}if(n.workbooks[0].slice(-3)=="bin")i=true;var o={};var c={};if(!r.bookSheets&&!r.bookProps){As=[];if(n.sst)try{As=zl(Er(e,_o(n.sst)),n.sst,r)}catch(f){if(r.WTF)throw f}if(r.cellStyles&&n.themes.length)o=$l(Fr(e,n.themes[0].replace(/^\//,""),true)||"",n.themes[0],r);if(n.style)c=Bl(Er(e,_o(n.style)),n.style,o,r)}n.links.map(function(t){try{var a=vn(Fr(e,mn(_o(t))),t);return jl(Er(e,_o(t)),a,t,r)}catch(n){}});var u=Nl(Er(e,_o(n.workbooks[0])),n.workbooks[0],r);var h={},p="";if(n.coreprops.length){p=Er(e,_o(n.coreprops[0]),true);if(p)h=En(p);if(n.extprops.length!==0){p=Er(e,_o(n.extprops[0]),true);if(p)Pn(p,h,r)}}var d={};if(!r.bookSheets||r.bookProps){if(n.custprops.length!==0){p=Fr(e,_o(n.custprops[0]),true);if(p)d=Ln(p,r)}}var m={};if(r.bookSheets||r.bookProps){if(u.Sheets)s=u.Sheets.map(function O(e){return e.name});else if(h.Worksheets&&h.SheetNames.length>0)s=h.SheetNames;if(r.bookProps){m.Props=h;m.Custprops=d}if(r.bookSheets&&typeof s!=="undefined")m.SheetNames=s;if(r.bookSheets?m.SheetNames:r.bookProps)return m}s={};var v={};if(r.bookDeps&&n.calcchain)v=Wl(Er(e,_o(n.calcchain)),n.calcchain,r);var g=0;var b={};var w,y;{var k=u.Sheets;h.Worksheets=k.length;h.SheetNames=[];for(var x=0;x!=k.length;++x){h.SheetNames[x]=k[x].name}}var S=i?"bin":"xml";var C=n.workbooks[0].lastIndexOf("/");var _=(n.workbooks[0].slice(0,C+1)+"_rels/"+n.workbooks[0].slice(C+1)+".rels").replace(/^\//,"");if(!Ar(e,_))_="xl/_rels/workbook."+S+".rels";var A=vn(Fr(e,_,true),_.replace(/_rels.*/,"s5s"));if((n.metadata||[]).length>=1){r.xlmeta=Hl(Er(e,_o(n.metadata[0])),n.metadata[0],r)}if((n.people||[]).length>=1){r.people=is(Er(e,_o(n.people[0])),r)}if(A)A=So(A,u.Sheets);var T=Er(e,"xl/worksheets/sheet.xml",true)?1:0;e:for(g=0;g!=h.Worksheets;++g){var E="sheet";if(A&&A[g]){w="xl/"+A[g][1].replace(/[\/]?xl\//,"");if(!Ar(e,w))w=A[g][1];if(!Ar(e,w))w=_.replace(/_rels\/.*$/,"")+A[g][1];E=A[g][2]}else{w="xl/worksheets/sheet"+(g+1-T)+"."+S;w=w.replace(/sheet0\./,"sheet.")}y=w.replace(/^(.*)(\/)([^\/]*)$/,"$1/_rels/$3.rels");if(r&&r.sheets!=null)switch(typeof r.sheets){case"number":if(g!=r.sheets)continue e;break;case"string":if(h.SheetNames[g].toLowerCase()!=r.sheets.toLowerCase())continue e;break;default:if(Array.isArray&&Array.isArray(r.sheets)){var F=false;for(var D=0;D!=r.sheets.length;++D){if(typeof r.sheets[D]=="number"&&r.sheets[D]==g)F=1;if(typeof r.sheets[D]=="string"&&r.sheets[D].toLowerCase()==h.SheetNames[g].toLowerCase())F=1}if(!F)continue e};}Co(e,w,y,h.SheetNames[g],g,b,s,E,r,u,o,c)}m={Directory:n,Workbook:u,Props:h,Custprops:d,Deps:v,Sheets:s,SheetNames:h.SheetNames,Strings:As,Styles:c,Themes:o,SSF:gr(X)};if(r&&r.bookFiles){if(e.files){m.keys=a;m.files=e.files}else{m.keys=[];m.files={};e.FullPaths.forEach(function(r,t){r=r.replace(/^Root Entry[\/]/,"");m.keys.push(r);m.files[r]=e.FileIndex[t]})}}if(r&&r.bookVBA){if(n.vba.length>0)m.vbaraw=Er(e,_o(n.vba[0]),true);else if(n.defaults&&n.defaults.bin===ls)m.vbaraw=Er(e,"xl/vbaProject.bin",true)}return m}function To(e,r){var t=r||{};var a="Workbook",n=Ye.find(e,a);try{a="/!DataSpaces/Version";n=Ye.find(e,a);if(!n||!n.content)throw new Error("ECMA-376 Encrypted file missing "+a);parse_DataSpaceVersionInfo(n.content);a="/!DataSpaces/DataSpaceMap";n=Ye.find(e,a);if(!n||!n.content)throw new Error("ECMA-376 Encrypted file missing "+a);var i=parse_DataSpaceMap(n.content);if(i.length!==1||i[0].comps.length!==1||i[0].comps[0].t!==0||i[0].name!=="StrongEncryptionDataSpace"||i[0].comps[0].v!=="EncryptedPackage")throw new Error("ECMA-376 Encrypted file bad "+a);a="/!DataSpaces/DataSpaceInfo/StrongEncryptionDataSpace";n=Ye.find(e,a);if(!n||!n.content)throw new Error("ECMA-376 Encrypted file missing "+a);var s=parse_DataSpaceDefinition(n.content);if(s.length!=1||s[0]!="StrongEncryptionTransform")throw new Error("ECMA-376 Encrypted file bad "+a);a="/!DataSpaces/TransformInfo/StrongEncryptionTransform/!Primary";n=Ye.find(e,a);if(!n||!n.content)throw new Error("ECMA-376 Encrypted file missing "+a);parse_Primary(n.content)}catch(l){}a="/EncryptionInfo";n=Ye.find(e,a);if(!n||!n.content)throw new Error("ECMA-376 Encrypted file missing "+a);var o=parse_EncryptionInfo(n.content);a="/EncryptedPackage";n=Ye.find(e,a);if(!n||!n.content)throw new Error("ECMA-376 Encrypted file missing "+a);if(o[0]==4&&typeof decrypt_agile!=="undefined")return decrypt_agile(o[1],n.content,t.password||"",t);if(o[0]==2&&typeof decrypt_std76!=="undefined")return decrypt_std76(o[1],n.content,t.password||"",t);throw new Error("File is password-protected")}function Eo(e,r){if(r.bookType=="ods")return bo(e,r);if(r.bookType=="numbers")return write_numbers_iwa(e,r);if(r.bookType=="xlsb")return Fo(e,r);return Do(e,r)}function Fo(e,r){Zi=1024;if(e&&!e.SSF){e.SSF=gr(X)}if(e&&e.SSF){Ue();ze(e.SSF);r.revssf=ar(e.SSF);r.revssf[e.SSF[65535]]=0;r.ssf=e.SSF}r.rels={};r.wbrels={};r.Strings=[];r.Strings.Count=0;r.Strings.Unique=0;if(Es)r.revStrings=new Map;else{r.revStrings={};r.revStrings.foo=[];delete r.revStrings.foo}var t=r.bookType=="xlsb"?"bin":"xml";var a=fs.indexOf(r.bookType)>-1;var n=un();ko(r=r||{});var i=Nr();var s="",l=0;r.cellXfs=[];Ms(r.cellXfs,{},{revssf:{General:0}});if(!e.Props)e.Props={};s="docProps/core.xml";Mr(i,s,Dn(e.Props,r));n.coreprops.push(s);bn(r.rels,2,s,dn.CORE_PROPS);s="docProps/app.xml";if(e.Props&&e.Props.SheetNames){}else if(!e.Workbook||!e.Workbook.Sheets)e.Props.SheetNames=e.SheetNames;else{var o=[];for(var c=0;c0){s="docProps/custom.xml";Mr(i,s,Bn(e.Custprops,r));n.custprops.push(s);bn(r.rels,4,s,dn.CUST_PROPS)}for(l=1;l<=e.SheetNames.length;++l){var f={"!id":{}};var u=e.Sheets[e.SheetNames[l-1]];var h=(u||{})["!type"]||"sheet";switch(h){case"chart":;default:s="xl/worksheets/sheet"+l+"."+t;Mr(i,s,Xl(l-1,s,r,e,f));n.sheets.push(s);bn(r.wbrels,-1,"worksheets/sheet"+l+"."+t,dn.WS[0]);}if(u){var p=u["!comments"];var d=false;var m="";if(p&&p.length>0){m="xl/comments"+l+"."+t;Mr(i,m,Kl(p,m,r));n.comments.push(m);bn(f,-1,"../comments"+l+"."+t,dn.CMNT);d=true}if(u["!legacy"]){if(d)Mr(i,"xl/drawings/vmlDrawing"+l+".vml",Qi(l,u["!comments"]))}delete u["!comments"];delete u["!legacy"]}if(f["!id"].rId1)Mr(i,mn(s),gn(f))}if(r.Strings!=null&&r.Strings.length>0){s="xl/sharedStrings."+t;Mr(i,s,Jl(r.Strings,s,r));n.strs.push(s);bn(r.wbrels,-1,"sharedStrings."+t,dn.SST)}s="xl/workbook."+t;Mr(i,s,Vl(e,s,r));n.workbooks.push(s);bn(r.rels,1,s,dn.WB);s="xl/theme/theme1.xml";Mr(i,s,Xi(e.Themes,r));n.themes.push(s);bn(r.wbrels,-1,"theme/theme1.xml",dn.THEME);s="xl/styles."+t;Mr(i,s,Yl(e,s,r));n.styles.push(s);bn(r.wbrels,-1,"styles."+t,dn.STY);if(e.vbaraw&&a){s="xl/vbaProject.bin";Mr(i,s,e.vbaraw);n.vba.push(s);bn(r.wbrels,-1,"vbaProject.bin",dn.VBA)}s="xl/metadata."+t;Mr(i,s,ql(s));n.metadata.push(s);bn(r.wbrels,-1,"metadata."+t,dn.XLMETA);Mr(i,"[Content_Types].xml",pn(n,r));Mr(i,"_rels/.rels",gn(r.rels));Mr(i,"xl/_rels/workbook."+t+".rels",gn(r.wbrels));delete r.revssf;delete r.ssf;return i}function Do(e,r){Zi=1024;if(e&&!e.SSF){e.SSF=gr(X)}if(e&&e.SSF){Ue();ze(e.SSF);r.revssf=ar(e.SSF);r.revssf[e.SSF[65535]]=0;r.ssf=e.SSF}r.rels={};r.wbrels={};r.Strings=[];r.Strings.Count=0;r.Strings.Unique=0;if(Es)r.revStrings=new Map;else{r.revStrings={};r.revStrings.foo=[];delete r.revStrings.foo}var t="xml";var a=fs.indexOf(r.bookType)>-1;var n=un();ko(r=r||{});var i=Nr();var s="",l=0;r.cellXfs=[];Ms(r.cellXfs,{},{revssf:{General:0}});if(!e.Props)e.Props={};s="docProps/core.xml";Mr(i,s,Dn(e.Props,r));n.coreprops.push(s);bn(r.rels,2,s,dn.CORE_PROPS);s="docProps/app.xml";if(e.Props&&e.Props.SheetNames){}else if(!e.Workbook||!e.Workbook.Sheets)e.Props.SheetNames=e.SheetNames;else{var o=[];for(var c=0;c0){s="docProps/custom.xml";Mr(i,s,Bn(e.Custprops,r));n.custprops.push(s);bn(r.rels,4,s,dn.CUST_PROPS)}var f=["SheetJ5"];r.tcid=0;for(l=1;l<=e.SheetNames.length;++l){var u={"!id":{}};var h=e.Sheets[e.SheetNames[l-1]];var p=(h||{})["!type"]||"sheet";switch(p){case"chart":;default:s="xl/worksheets/sheet"+l+"."+t;Mr(i,s,pl(l-1,r,e,u));n.sheets.push(s);bn(r.wbrels,-1,"worksheets/sheet"+l+"."+t,dn.WS[0]);}if(h){var d=h["!comments"];var m=false;var v="";if(d&&d.length>0){var g=false;d.forEach(function(e){e[1].forEach(function(e){if(e.T==true)g=true})});if(g){v="xl/threadedComments/threadedComment"+l+"."+t;Mr(i,v,ns(d,f,r));n.threadedcomments.push(v);bn(u,-1,"../threadedComments/threadedComment"+l+"."+t,dn.TCMNT)}v="xl/comments"+l+"."+t;Mr(i,v,ts(d,r));n.comments.push(v);bn(u,-1,"../comments"+l+"."+t,dn.CMNT);m=true}if(h["!legacy"]){if(m)Mr(i,"xl/drawings/vmlDrawing"+l+".vml",Qi(l,h["!comments"]))}delete h["!comments"];delete h["!legacy"]}if(u["!id"].rId1)Mr(i,mn(s),gn(u))}if(r.Strings!=null&&r.Strings.length>0){s="xl/sharedStrings."+t;Mr(i,s,ni(r.Strings,r));n.strs.push(s);bn(r.wbrels,-1,"sharedStrings."+t,dn.SST)}s="xl/workbook."+t;Mr(i,s,Ml(e,r));n.workbooks.push(s);bn(r.rels,1,s,dn.WB);s="xl/theme/theme1.xml";Mr(i,s,Xi(e.Themes,r));n.themes.push(s);bn(r.wbrels,-1,"theme/theme1.xml",dn.THEME);s="xl/styles."+t;Mr(i,s,Ii(e,r));n.styles.push(s);bn(r.wbrels,-1,"styles."+t,dn.STY);if(e.vbaraw&&a){s="xl/vbaProject.bin";Mr(i,s,e.vbaraw);n.vba.push(s);bn(r.wbrels,-1,"vbaProject.bin",dn.VBA)}s="xl/metadata."+t;Mr(i,s,Yi());n.metadata.push(s);bn(r.wbrels,-1,"metadata."+t,dn.XLMETA);if(f.length>1){s="xl/persons/person.xml";Mr(i,s,ss(f,r));n.people.push(s);bn(r.wbrels,-1,"persons/person.xml",dn.PEOPLE)}Mr(i,"[Content_Types].xml",pn(n,r));Mr(i,"_rels/.rels",gn(r.rels));Mr(i,"xl/_rels/workbook."+t+".rels",gn(r.wbrels));delete r.revssf;delete r.ssf;return i}function Oo(e,r){var t="";switch((r||{}).type||"base64"){case"buffer":return[e[0],e[1],e[2],e[3],e[4],e[5],e[6],e[7]];case"base64":t=w(e.slice(0,12));break;case"binary":t=e;break;case"array":return[e[0],e[1],e[2],e[3],e[4],e[5],e[6],e[7]];default:throw new Error("Unrecognized type "+(r&&r.type||"undefined"));}return[t.charCodeAt(0),t.charCodeAt(1),t.charCodeAt(2),t.charCodeAt(3),t.charCodeAt(4),t.charCodeAt(5),t.charCodeAt(6),t.charCodeAt(7)]}function Mo(e,r){if(Ye.find(e,"EncryptedPackage"))return To(e,r);return parse_xlscfb(e,r)}function No(e,r){var t,a=e;var n=r||{};if(!n.type)n.type=y&&Buffer.isBuffer(e)?"buffer":"base64";t=Pr(a,n);return Ao(t,n)}function Po(e,r){var t=0;e:while(t=2&&n[3]===0)return WK_.to_workbook(a,t);if(n[2]===0&&(n[3]===8||n[3]===9))return WK_.to_workbook(a,t)}break;case 3:;case 131:;case 139:;case 140:return zn.to_workbook(a,t);case 123:if(n[1]===92&&n[2]===114&&n[3]===116)return RTF.to_workbook(a,t);break;case 10:;case 13:;case 32:return Io(a,t);case 137:if(n[1]===80&&n[2]===78&&n[3]===71)throw new Error("PNG Image File is not a spreadsheet");break;}if($n.indexOf(n[0])>-1&&n[2]<=12&&n[3]<=31)return zn.to_workbook(a,t);return Bo(e,a,t,i)}function zo(e,r){var t=r||{};t.type="file";return $o(e,t)}function Uo(e,r){switch(r.type){case"base64":;case"binary":break;case"buffer":;case"array":r.type="";break;case"file":return Ze(r.file,Ye.write(e,{type:y?"buffer":""}));case"string":throw new Error("'string' output type invalid for '"+r.bookType+"' files");default:throw new Error("Unrecognized type "+r.type);}return Ye.write(e,r)}function Wo(e,r){var t=gr(r||{});var a=Eo(e,t);return Ho(a,t)}function jo(e,r){var t=gr(r||{});var a=Do(e,t);return Ho(a,t)}function Ho(e,r){var t={};var a=y?"nodebuffer":typeof Uint8Array!=="undefined"?"array":"string";if(r.compression)t.compression="DEFLATE";if(r.password)t.type=a;else switch(r.type){case"base64":t.type="base64";break;case"binary":t.type="string";break;case"string":throw new Error("'string' output type invalid for '"+r.bookType+"' files");case"buffer":;case"file":t.type=a;break;default:throw new Error("Unrecognized type "+r.type);}var n=e.FullPaths?Ye.write(e,{fileType:"zip",type:{nodebuffer:"buffer",string:"binary"}[t.type]||t.type,compression:!!r.compression}):e.generate(t);if(typeof Deno!=="undefined"){if(typeof n=="string"){if(r.type=="binary"||r.type=="base64")return n;n=new Uint8Array(_(n))}}if(r.password&&typeof encrypt_agile!=="undefined")return Uo(encrypt_agile(n,r.password),r);if(r.type==="file")return Ze(r.file,n);return r.type=="string"?ot(n):n}function Vo(e,r){var t=r||{};var a=write_xlscfb(e,t);return Uo(a,t)}function Xo(e,r,t){if(!t)t="";var a=t+e;switch(r.type){case"base64":return b(ct(a));case"binary":return ct(a);case"string":return e;case"file":return Ze(r.file,a,"utf8");case"buffer":{if(y)return k(a,"utf8");else if(typeof TextEncoder!=="undefined")return(new TextEncoder).encode(a);else return Xo(a,{type:"binary"}).split("").map(function(e){return e.charCodeAt(0)})};}throw new Error("Unrecognized type "+r.type)}function Go(e,r){switch(r.type){case"base64":return b(e);case"binary":return e;case"string":return e;case"file":return Ze(r.file,e,"binary");case"buffer":{if(y)return k(e,"binary");else return e.split("").map(function(e){return e.charCodeAt(0)})};}throw new Error("Unrecognized type "+r.type)}function Yo(e,r){switch(r.type){case"string":;case"base64":;case"binary":var t="";for(var a=0;a0)n=0;var u=ya(o.s.r);var h=[];var p=[];var d=0,m=0;var v=Array.isArray(e);var g=o.s.r,b=0;var w={};if(v&&!e[g])e[g]=[];var y=c.skipHidden&&e["!cols"]||[];var k=c.skipHidden&&e["!rows"]||[];for(b=o.s.c;b<=o.e.c;++b){if((y[b]||{}).hidden)continue;h[b]=Ca(b);t=v?e[g][b]:e[h[b]+u];switch(a){case 1:i[b]=b-o.s.c;break;case 2:i[b]=h[b];break;case 3:i[b]=c.header[b-o.s.c];break;default:if(t==null)t={w:"__EMPTY",t:"s"};l=s=Pa(t,null,c);m=w[s]||0;if(!m)w[s]=1;else{do{l=s+"_"+m++}while(w[l]);w[s]=m;w[l]=1}i[b]=l;}}for(g=o.s.r+n;g<=o.e.r;++g){if((k[g]||{}).hidden)continue;var x=rc(e,o,g,h,a,i,v,c);if(x.isempty===false||(a===1?c.blankrows!==false:!!c.blankrows))p[d++]=x.row}p.length=d;return p}var ac=/"/g;function nc(e,r,t,a,n,i,s,l){var o=true;var c=[],f="",u=ya(t);for(var h=r.s.c;h<=r.e.c;++h){if(!a[h])continue;var p=l.dense?(e[t]||[])[h]:e[a[h]+u];if(p==null)f="";else if(p.v!=null){o=false;f=""+(l.rawNumbers&&p.t=="n"?p.v:Pa(p,null,l));for(var d=0,m=0;d!==f.length;++d)if((m=f.charCodeAt(d))===n||m===i||m===34||l.forceQuotes){f='"'+f.replace(ac,'""')+'"';break}if(f=="ID")f='"ID"'}else if(p.f!=null&&!p.F){o=false;f="="+p.f;if(f.indexOf(",")>=0)f='"'+f.replace(ac,'""')+'"'}else f="";c.push(f)}if(l.blankrows===false&&o)return null;return c.join(s)}function ic(e,r){var t=[];var a=r==null?{}:r;if(e==null||e["!ref"]==null)return"";var n=Ma(e["!ref"]);var i=a.FS!==undefined?a.FS:",",s=i.charCodeAt(0);var l=a.RS!==undefined?a.RS:"\n",o=l.charCodeAt(0);var c=new RegExp((i=="|"?"\\|":i)+"+$");var f="",u=[];a.dense=Array.isArray(e);var h=a.skipHidden&&e["!cols"]||[];var p=a.skipHidden&&e["!rows"]||[];for(var d=n.s.c;d<=n.e.c;++d)if(!(h[d]||{}).hidden)u[d]=Ca(d);var m=0;for(var v=n.s.r;v<=n.e.r;++v){if((p[v]||{}).hidden)continue;f=nc(e,n,v,u,s,o,i,a);if(f==null){continue}if(a.strip)f=f.replace(c,"");if(f||a.blankrows!==false)t.push((m++?l:"")+f)}delete a.dense;return t.join("")}function sc(e,r){if(!r)r={};r.FS="\t";r.RS="\n";var t=ic(e,r);if(typeof $cptable=="undefined"||r.type=="string")return t;var a=$cptable.utils.encode(1200,t,"str");return String.fromCharCode(255)+String.fromCharCode(254)+a}function lc(e){var r="",t,a="";if(e==null||e["!ref"]==null)return[];var n=Ma(e["!ref"]),i="",s=[],l;var o=[];var c=Array.isArray(e);for(l=n.s.c;l<=n.e.c;++l)s[l]=Ca(l);for(var f=n.s.r;f<=n.e.r;++f){i=ya(f);for(l=n.s.c;l<=n.e.c;++l){r=s[l]+i;t=c?(e[f]||[])[l]:e[r];a="";if(t===undefined)continue;else if(t.F!=null){r=t.F;if(!t.f)continue;a=t.f;if(r.indexOf(":")==-1)r=r+":"+r}if(t.f!=null)a=t.f;else if(t.t=="z")continue;else if(t.t=="n"&&t.v!=null)a=""+t.v;else if(t.t=="b")a=t.v?"TRUE":"FALSE";else if(t.w!==undefined)a="'"+t.w;else if(t.v===undefined)continue;else if(t.t=="s")a="'"+t.v;else a=""+t.v;o[o.length]=r+"="+a}}return o}function oc(e,r,t){var a=t||{};var n=+!a.skipHeader;var i=e||{};var s=0,l=0;if(i&&a.origin!=null){if(typeof a.origin=="number")s=a.origin;else{var o=typeof a.origin=="string"?Ea(a.origin):a.origin;s=o.r;l=o.c}}var c;var f={s:{c:0,r:0},e:{c:l,r:s+r.length-1+n}};if(i["!ref"]){var u=Ma(i["!ref"]);f.e.c=Math.max(f.e.c,u.e.c);f.e.r=Math.max(f.e.r,u.e.r);if(s==-1){s=u.e.r+1;f.e.r=s+r.length-1+n}}else{if(s==-1){s=0;f.e.r=r.length-1+n}}var h=a.header||[],p=0;r.forEach(function(e,r){er(e).forEach(function(t){if((p=h.indexOf(t))==-1)h[p=h.length]=t;var o=e[t];var f="z";var u="";var d=Fa({c:l+p,r:s+r+n});c=fc(i,d);if(o&&typeof o==="object"&&!(o instanceof Date)){i[d]=o}else{if(typeof o=="number")f="n";else if(typeof o=="boolean")f="b";else if(typeof o=="string")f="s";else if(o instanceof Date){f="d";if(!a.cellDates){f="n";o=sr(o)}u=a.dateNF||X[14]}else if(o===null&&a.nullError){f="e";o=0}if(!c)i[d]=c={t:f,v:o};else{c.t=f;c.v=o;delete c.w;delete c.R;if(u)c.z=u}if(u)c.z=u}})});f.e.c=Math.max(f.e.c,l+h.length-1);var d=ya(s);if(n)for(p=0;p=0&&e.SheetNames.length>r)return r;throw new Error("Cannot find sheet # "+r)}else if(typeof r=="string"){var t=e.SheetNames.indexOf(r);if(t>-1)return t;throw new Error("Cannot find sheet name |"+r+"|")}else throw new Error("Cannot find sheet |"+r+"|")}function hc(){return{SheetNames:[],Sheets:{}}}function pc(e,r,t,a){var n=1;if(!t)for(;n<=65535;++n,t=undefined)if(e.SheetNames.indexOf(t="Sheet"+n)==-1)break;if(!t||e.SheetNames.length>=65535)throw new Error("Too many worksheets");if(a&&e.SheetNames.indexOf(t)>=0){var i=t.match(/(^.*?)(\d+)$/);n=i&&+i[2]||0;var s=i&&i[1]||t;for(++n;n<=65535;++n)if(e.SheetNames.indexOf(t=s+n)==-1)break}Tl(t);if(e.SheetNames.indexOf(t)>=0)throw new Error("Worksheet with name |"+t+"| already exists!");e.SheetNames.push(t);e.Sheets[t]=r;return t}function dc(e,r,t){if(!e.Workbook)e.Workbook={};if(!e.Workbook.Sheets)e.Workbook.Sheets=[];var a=uc(e,r);if(!e.Workbook.Sheets[a])e.Workbook.Sheets[a]={};switch(t){case 0:;case 1:;case 2:break;default:throw new Error("Bad sheet visibility setting "+t);}e.Workbook.Sheets[a].Hidden=t}function mc(e,r){e.z=r;return e}function vc(e,r,t){if(!r){delete e.l}else{e.l={Target:r};if(t)e.l.Tooltip=t}return e}function gc(e,r,t){return vc(e,"#"+r,t)}function bc(e,r,t){if(!e.c)e.c=[];e.c.push({t:r,a:t||"SheetJS"})}function wc(e,r,t,a){var n=typeof r!="string"?r:Ma(r);var i=typeof r=="string"?r:Oa(r);for(var s=n.s.r;s<=n.e.r;++s)for(var l=n.s.c;l<=n.e.c;++l){var o=fc(e,s,l);o.t="n";o.F=i;delete o.v;if(s==n.s.r&&l==n.s.c){o.f=t;if(a)o.D=true}}return e}var yc={encode_col:Ca,encode_row:ya,encode_cell:Fa,encode_range:Oa,decode_col:Sa,decode_row:wa,split_cell:Ta,decode_cell:Ea,decode_range:Da,format_cell:Pa,sheet_add_aoa:Ra,sheet_add_json:oc,sheet_add_dom:io,aoa_to_sheet:La,json_to_sheet:cc,table_to_sheet:so,table_to_book:lo,sheet_to_csv:ic,sheet_to_txt:sc,sheet_to_json:tc,sheet_to_html:no,sheet_to_formulae:lc,sheet_to_row_object_array:tc,sheet_get_cell:fc,book_new:hc,book_append_sheet:pc,book_set_sheet_visibility:dc,cell_set_number_format:mc,cell_set_hyperlink:vc,cell_set_internal_link:gc,cell_add_comment:bc,sheet_set_array_formula:wc,consts:{SHEET_VISIBLE:0,SHEET_HIDDEN:1,SHEET_VERY_HIDDEN:2}};if(typeof parse_xlscfb!=="undefined")e.parse_xlscfb=parse_xlscfb;e.parse_zip=Ao;e.read=$o;e.readFile=zo;e.readFileSync=zo;e.write=Ko;e.writeFile=Zo;e.writeFileSync=Zo;e.writeFileAsync=ec;e.utils=yc;e.writeXLSX=Jo;e.writeFileXLSX=Qo;e.SSF=We;if(typeof __stream!=="undefined")e.stream=__stream;if(typeof Ye!=="undefined")e.CFB=Ye;if(typeof require!=="undefined"){var kc=undefined;if((kc||{}).Readable)set_readable(kc.Readable)}}if(typeof exports!=="undefined")make_xlsx_lib(exports);else if(typeof module!=="undefined"&&module.exports)make_xlsx_lib(module.exports);else if(typeof define==="function"&&define.amd)define("xlsx",function(){if(!XLSX.version)make_xlsx_lib(XLSX);return XLSX});else make_xlsx_lib(XLSX);if(typeof window!=="undefined"&&!window.XLSX)try{window.XLSX=XLSX}catch(e){}