{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Shunt 2015 Autres","table des données","Feuil1"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Shunt 2015 Autres","index":0,"n_rows":47,"n_cols":4,"rows_kept":47,"merged":[[0,0,0,3],[16,0,16,3],[28,0,28,3]],"flags":["formulas_cached_only"]}
["LE MANS PRCI SECTEUR EST PVSI"]
["Itinéraires","1er type","2e type","3e type"]
["151 - 2","857600 (LLF SA)\n857606 (MA)\n862553 (ME JE)\n857646 (VE)\n857364 (DF)"]
["151 - 3","857606 (LLF)\n862553 (MA)\n857362 (ME JE)\n862463 (VE)\n857312 (SA)\n16775 (DF)"]
["151 - 4","857646 (LLF)\n857658 (MA ME JE)\n862553 (VE)\n16753 (SA)\n720033 (DF)"]
["151 - 5","862553 (LLF)\n857362 (MA)\n16757 (ME JE DF)\n857600 (VE)\n857306 (SA)"]
["151 - 6","862559 (LLF)\n857646 (MA ME)\n857600 (JE)\n857606 (VE)\n857314 (SA)\n720124 (DF)"]
["151 - 7","857362 (LLF VE)\n857600 (MA ME)\n857606 (JE)\n862555 (SA)\n857642 (DF)"]
["7 - 151","857301 (LLF)\n857605 (MA)\n857349 (ME JE)\n857319 (VE)\n857609 (SA)\n857323 (DF)"]
["6 - 151","857653 (LLF MA)\n857605 (ME JE)\n857349 (VE)\n857367 (SA)\n862562 (DF)"]
["5 - 151","857605 (LLF)\n857305 (MA)\n857319 (ME JE)\n16750 (VE)\n16788 (SA)\n720170 (DF)"]
["4 - 151","862554 (LLF)\n16750 (MA ME JE)\n857605 (VE)\n720171 (SA)\n16762 (DF)"]
["3 - 151","720029 (LLF)\n862554 (MA ME VE)\n857305 (JE)\n857319 (SA)\n16786 (DF)"]
["2 - 151","16750 (LLF)\n857349 (MA)\n857305 (ME VE)\n862554 (JE)\n726216 (SA)\n857333 (DF)"]
[]
[]
["LE MANS PRCI SECTEUR EST CHAMPAGNE"]
["Itinéraires","1er type","2e type","3e type"]
["73 - 103",8911]
["73 - 101","Inverse 104-72+\nInverse 72-44"]
["71 - 103","60499 (SF SDF)\n61947 (SA)\n56815 (DF)"]
["71 - 101","Inverse 102-72+\nInverse 72-42"]
["72 - 42",8816]
["72 - 44","61552 (SF DF)\n433550 (DF)"]
["74 - 42","Inverse 45-71+\nInverse 71-103"]
["74 - 44","Inverse 45-73+\nInverse 73-103"]
[]
[]
["LE MANS PRCI SECTEUR EST CONNERRE-RACCORDEMENT"]
["Itinéraires","1er type","2e type","3e type"]
["35 - 45",8911]
["33 - 41","Inverse 42-3262"]
["31 - 45",16757]
["45 - 73",8911]
["45 - 71","60499 (SF SDF)\n61947 (SA)\n56815 (DF)"]
["43 - 73","Inverse 72-44+\nInverse 44-43"]
["43 - 71","Inverse 72-42+\nInverse 42-43"]
["41 - 73","Inverse 72-44+\nInverse 44-3262"]
["41 - 71","Inverse 72-42+\nInverse 42-3262"]
["42 - 3262",8816]
["42 - 43",16762]
["42 - 31","Inverse 31-45+\nInverse 45-71"]
["42 - 3264","Inverse 35-45+\nInverse 45-71"]
["44 - 3262","10406 (LU)\n999310 (SF LU SDF)\n999318 (SA)\n999314 (DF)"]
["44 - 43","61552 (SF DF)\n433550 (DF)"]
["44 - 31","Inverse 31-45+\nInverse 45-73"]
["44 - 3264","Inverse 35-45+\nInverse 45-73"]

{"sheet":"table des données","index":1,"n_rows":33,"n_cols":14,"rows_kept":33,"merged":[[2,4,2,13],[3,1,4,1],[5,1,6,1],[7,1,8,1],[9,1,10,1],[11,1,12,1],[13,1,14,1],[15,1,16,1],[17,1,18,1],[19,1,20,1],[21,1,22,1],[23,1,24,1],[25,1,26,1],[27,1,28,1],[29,1,30,1],[31,1,32,1]],"flags":["formulas_cached_only"]}
[null,"SECTEUR EST"]
[]
[null,"Vanne","Position","Commut à actionner","CIRCUIT à fermer"]
[null,"31a","O","C31","31-45"]
[null,null,"F","C35 C42 C44","35-45","42-3364","44-3364"]
[null,"31c","O","C31","31-45"]
[null,null,"F","C35 C42 C44","35-45","42-3364","44-3364"]
[null,"45a","O","C45 C44","43-71","43-73","41-71","41-73","45-73","42-36","44-36","42-3362","44-3362","44-3364"]
[null,null,"F","C45 C42","45-71","42-3364"]
[null,"45b","O","Cv43 C42 C44","43-71","43-73","45-73","42-36","44-36","44-3364"]
[null,null,"F","C45 C42","45-71","42-3364"]
[null,"46a","O","C41 C42 C44","41-71","41-73","42-3362","44-3362"]
[null,null,"F","Cv43 C45 C42 C44","43-71","43-73","45-71","42-36","42-3364","44-36"]
[null,"46c","O","C41 C42 C44","41-71","41-73","42-3362","44-3362"]
[null,null,"F","Cv43 C45 C42 C44","43-71","43-73","45-71","42-36","42-3364","44-36"]
[null,"47a","O","C41 Cv43 C44","41-73","43-73","44-36","44-3362"]
[null,null,"F","C41 C43 C45 C42","41-71","43-71","45-71","45-73","42-36","42-3362","42-3364","44-3364"]
[null,"47b","O","C41 Cv43 C44","41-73","43-73","44-36","44-3362"]
[null,null,"F","C45 C44","45-73","42-36","42-3362","42-3364","44-3364"]
[null,"27a","O","C29","27-43","27-7107","29-31","34-20","36-20"]
[null,null,"F","C29","29-7107","34-29(FSO)","36-29(FSO)"]
[null,"27b","O","Cv27 C34 C36","27-43","27-7107","29-31","34-20","36-20"]
[null,null,"F","C29","29-7107","34-29(FSO)","36-29(FSO)"]
[null,29,"O","Cv27 C36","27-43","36-20","36-29(FSO)"]
[null,null,"F","Cv27 C29 C34","27-7107","29-7107","34-20","34-29(FSO)"]
[null,"73a","O","C73 C74","73-103","71-103","71-101","72-42","74-42","74-44"]
[null,null,"F","C73 C72","73-101","72-44"]
[null,"73b","O","C71 C72 C74","73-103","71-103","71-101","72-42","74-42","74-44"]
[null,null,"F","C73 C72","73-101","72-44"]
[null,"74a","O","C71 C74","71-103","74-42"]
[null,null,"F","C73 C71 C72","73-103","73-101","71-101","72-42","72-44","74-44"]
[null,"74b","O","C71 C74","71-103","74-42"]
[null,null,"F","C73 C74 ","73-103","73-101","71-101","72-42","72-44","74-44"]

{"sheet":"Feuil1","index":2,"n_rows":11,"n_cols":15,"rows_kept":11,"flags":["formulas_cached_only"]}
[]
[null,null,"vanne recherchée ",null,null,"45a"]
[null,null,"Position de la vanne (O ou F)",null,null,"O"]
[]
[]
[null,"Resultat : ","45a","O","C45 C44","43-71","43-73","41-71","41-73","45-73","42-36","44-36","42-3362","44-3362","44-3364"]
[]
[]
[]
[null,null,"la question à résoudre par une formule"]
[null,null,"je recherche dans la feuille de calcul \"table des données\", la vanne en défaut (col.B) et si elle est ouverte ou fermé (col. C) je protège par la fermeture du commutateur (col.C) et je condamne les circuits (col. E à N)"]