{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sommaire","Score AFS","AFSE","Least Function Score","EFI","Résumé"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sommaire","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Nom patiente"]
[null,"Prénom"]
[null,"Date de naissance"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Conception","Dr Jean VIALARD"]
["Réalisation","Dr Philippe ARVIS","Dernière Révision le 16/10/2018"]

{"sheet":"Score AFS","index":1,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[[18,12,19,12],[23,12,24,12],[29,12,30,12],[34,12,35,12]]}
[null,null,null,null,null,null,null,null,null,null,"?",null,"1  - Lésions péritonéales"]
["Score AFS","Taille","Profondeur",null,null,null,null,"Taille","Profondeur",null,0,null,"Ne coter que la lésion la plus sévère (superficielle ou profonde)"]
["Péritoine","?","?","                 Ne coter que la lésion la plus sévère (superficielle ou profonde)",null,null,"Péritoine",{"$f":"IF(B3=\"?\",\"\",IF(B3=0,0,IF(B3=\"< 1 cm\",1,IF(B3=\"1 à 3 cm\",2,IF(B3=\"> 3 cm\",4)))))","v":""},{"$f":"IF(C3=\"?\",\"\",IF(B3=\"\",\"\",IF(C3=\"Superficielles\",2,IF(C3=\"profondes\",4))))","v":""},null,"< 1 cm",null,"Péritoine","Superficielles","Profondes"]
["Lésions ovariennes",null,null,null,null,null,"Lésions ovariennes",null,null,null,"1 à 3 cm",null,"< 1 cm",1,2]
["Ovaire droit","?","?",null,null,null,"Ovaire droit",{"$f":"IF(B5=\"?\",\"\",(IF(B5=0,0,IF(B5=\"< 1 cm\",1,IF(B5=\"1 à 3 cm\",2,IF(B5=\"> 3 cm\",4))))))","v":""},{"$f":"IF(B5=\"?\",\"\",IF(B5<1,0,IF(AND(C5=\"Superficielles\",B5=\"< 1 cm\"),1,IF(AND(C5=\"Superficielles\",B5=\"1 à 3 cm\"),2,IF(AND(C5=\"Superficielles\",B5=\"> 3 cm\"),4,IF(AND(C5=\"Profondes\",B5=\"< 1 cm\"),4,IF(AND(C5=\"Profondes\",B5=\"1 à 3 cm\"),16,IF(AND(C5=\"Profondes\",B5=\"> 3 cm\"),20))))))))","v":""},null,"> 3 cm",null,"1 à 3 cm",2,4]
["Ovaire gauche","?","?",null,null,null,"Ovaire gauche",{"$f":"IF(B6=\"?\",\"\",IF(B6=\"< 1 cm\",1,IF(B6=\"1 à 3 cm\",2,IF(B6=\"> 3 cm\",4))))","v":""},{"$f":"IF(C6=\"?\",\"\",IF(AND(C6=\"Superficielles\",B6=\"< 1 cm\"),1,IF(AND(C6=\"Superficielles\",B6=\"1 à 3 cm\"),2,IF(AND(C6=\"Superficielles\",B6=\"> 3 cm\"),4,IF(AND(C6=\"Profondes\",B6=\"< 1 cm\"),4,IF(AND(C6=\"Profondes\",B6=\"1 à 3 cm\"),16,IF(AND(C6=\"Profondes\",B6=\"> 3 cm\"),20)))))))","v":""},null,null,null,"> 3 cm",4,6]
["Adhérences",null,null,null,null,null,null,null,null,null,"?",null,"2  - Lésions ovariennes"]
["Ovaire droit","?","?",null,null,null,"Adhérences",null,null,null,"non",null,"Ne coter que la lésion la plus sévère et ajouter les scores des ovaires droit et gauche"]
["Ovaire gauche","?","?",null,null,null,"Ovaire droit",{"$f":"IF(B8=\"?\",\"\",IF(B8=\"< 1/3\",1,IF(B8=\"1/3 à 2/3\",2,IF(B8=\"> 2/3\",4))))","v":""},{"$f":"IF(B8=\"?\",\"\",IF(B8<1,0,IF(AND(C8=\"Superficielles ou transparentes\",B8=\"< 1/3\"),1,IF(AND(C8=\"Superficielles ou transparentes\",B8=\"1/3 à 2/3\"),2,IF(AND(C8=\"Superficielles ou transparentes\",B8=\"> 2/3\"),4,IF(AND(C8=\"Profondes ou opaques\",B8=\"< 1/3\"),4,IF(AND(C8=\"Profondes ou opaques\",B8=\"1/3 à 2/3\"),8,IF(AND(C8=\"Profondes ou opaques\",B8=\"> 2/3\"),16))))))))","v":""},null,"Superficielles",null,"Ovaire droit","Superficielles","Profondes"]
["Trompe droite","?","?",null,null,null,"Ovaire gauche",{"$f":"IF(B9=\"?\",\"\",IF(B9=\"< 1/3\",1,IF(B9=\"1/3 à 2/3\",2,IF(B9=\"> 2/3\",4))))","v":""},{"$f":"IF(C9=\"?\",\"\",IF(AND(C9=\"Superficielles ou transparentes\",B9=\"< 1/3\"),1,IF(AND(C9=\"Superficielles ou transparentes\",B9=\"1/3 à 2/3\"),2,IF(AND(C9=\"Superficielles ou transparentes\",B9=\"> 2/3\"),4,IF(AND(C9=\"Profondes ou opaques\",B9=\"< 1/3\"),4,IF(AND(C9=\"Profondes ou opaques\",B9=\"1/3 à 2/3\"),8,IF(AND(C9=\"Profondes ou opaques\",B9=\"> 2/3\"),16)))))))","v":""},null,"Profondes",null,"< 1 cm",1,4]
["Trompe gauche","?","?","                 Si le pavillon de la trompe est complètement immobilisé (adhèrent sur toute la circonférence), compter \"> 2/3 et Profondes\"",null,null,"Trompe droite",{"$f":"IF(B10=\"?\",\"\",IF(B10=\"< 1/3\",1,IF(B10=\"1/3 à 2/3\",2,IF(B10=\"> 2/3\",4))))","v":""},{"$f":"IF(C10=\"?\",\"\",IF(AND(C10=\"Superficielles ou transparentes\",B10=\"< 1/3\"),1,IF(AND(C10=\"Superficielles ou transparentes\",B10=\"1/3 à 2/3\"),2,IF(AND(C10=\"Superficielles ou transparentes\",B10=\"> 2/3\"),4,IF(AND(C10=\"Profondes ou opaques\",B10=\"< 1/3\"),4,IF(AND(C10=\"Profondes ou opaques\",B10=\"1/3 à 2/3\"),8,IF(AND(C10=\"Profondes ou opaques\",B10=\"> 2/3\"),16)))))))","v":""},null,null,null,"1 à 3 cm",2,16]
["Oblitération du Douglas","?",null,null,null,null,"Trompe gauche",{"$f":"IF(B11=\"?\",\"\",IF(B11=\"< 1/3\",1,IF(B11=\"1/3 à 2/3\",2,IF(B11=\"> 2/3\",4))))","v":""},{"$f":"IF(C11=\"?\",\"\",IF(AND(C11=\"Superficielles ou transparentes\",B11=\"< 1/3\"),1,IF(AND(C11=\"Superficielles ou transparentes\",B11=\"1/3 à 2/3\"),2,IF(AND(C11=\"Superficielles ou transparentes\",B11=\"> 2/3\"),4,IF(AND(C11=\"Profondes ou opaques\",B11=\"< 1/3\"),4,IF(AND(C11=\"Profondes ou opaques\",B11=\"1/3 à 2/3\"),8,IF(AND(C11=\"Profondes ou opaques\",B11=\"> 2/3\"),16)))))))","v":""},null,"?",null,"> 3 cm",4,20]
["Score AFS",{"$f":"H16","v":""},{"$f":"IF(B13=\"\",\"\",IF(B13=0,0,IF(AND(B13>0,B13<6),\"Stade I\",IF(AND(B13>5,B13<16),\"Stade II\",IF(AND(B13>15,B13<=40),\"Stade III\",IF(B13>40,\"Stade IV\"))))))","v":""},null,null,null,null,null,null,null,0,null,"Ovaire gauche","Superficielles","Profondes"]
[null,null,null,null,null,null,"Oblitération du Douglas",{"$f":"IF(B12=\"?\",\"\",IF(B12=\"Partielle\",4,IF(B12=\"Totale\",40)))","v":""},null,null,"< 1/3",null,"< 1 cm",1,4]
[null,null,null,null,null,null,null,null,null,null,"1/3 à 2/3",null,"1 à 3 cm",2,16]
[null,null,null,null,null,null,"Total",{"$f":"IF(I16=24,\"\",SUM(H3:I14))","v":""},{"$f":"COUNTBLANK(H3:I14)","v":24},null,"> 2/3",null,"> 3 cm",4,20]
[null,null,null,null,null,null,null,null,null,null,null,null,"3  - Adhérences annexielles selon la circonférence"]
[null,null,null,null,null,null,null,null,null,null,"?",null,"ajouter les scores des ovaires droit et gauche et des trompes droite et gauche"]
[null,null,null,null,null,null,null,null,null,null,"non",null,"Ovaire droit","Superficielles","Profondes"]
[null,null,null,null,null,null,null,null,null,null,"Superficielles ou transparentes",null,null,"(ou transparentes)","(ou opaques)"]
[null,null,null,null,null,null,null,null,null,null,"Profondes ou opaques",null,"< 1/3",1,4]
[null,null,null,null,null,null,null,null,null,null,null,null,"1/3 à 2/3",2,8]
[null,null,null,null,null,null,null,null,null,null,"?",null,"> 2/3",4,16]
[null,null,null,null,null,null,null,null,null,null,"non",null,"Ovaire gauche","Superficielles","Profondes"]
[null,null,null,null,null,null,null,null,null,null,"Partielle",null,null,"(ou transparentes)","(ou opaques)"]
[null,null,null,null,null,null,null,null,null,null,"Totale",null,"< 1/3",1,4]
[null,null,null,null,null,null,null,null,null,null,null,null,"1/3 à 2/3",2,8]
[null,null,null,null,null,null,null,null,null,null,null,null,"> 2/3",4,16]
[null,null,null,null,null,null,null,null,null,null,null,null,"Si le pavillon de la trompe est complètement immobilisé (adhèrent sur toute la circonférence), compter 16"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Trompe droite","Superficielles","Profondes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(ou transparentes)","(ou opaques)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"< 1/3",1,4]
[null,null,null,null,null,null,null,null,null,null,null,null,"1/3 à 2/3",2,8]
[null,null,null,null,null,null,null,null,null,null,null,null,"> 2/3",4,16]
[null,null,null,null,null,null,null,null,null,null,null,null,"Trompe gauche","Superficielles","Profondes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(ou transparentes)","(ou opaques)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"< 1/3",1,4]
[null,null,null,null,null,null,null,null,null,null,null,null,"1/3 à 2/3",2,8]
[null,null,null,null,null,null,null,null,null,null,null,null,"> 2/3",4,16]
[null,null,null,null,null,null,null,null,null,null,null,null,"4  - Oblitération du Douglas"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Partielle",4]
[null,null,null,null,null,null,null,null,null,null,null,null,"Totale",40]

{"sheet":"AFSE","index":2,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Score AFS des lésions endométriose les plus sévères (AFSE)",null,null,null,null,"?"]
[null,"Présence","Score",null,null,"oui"]
["Endométriome > 1 cm","?",{"$f":"IF(B3=\"?\",\"\",IF(B3=\"oui\",16,0))","v":""},null,null,"non"]
["Oblitération complète du Douglas","?",{"$f":"IF(B4=\"?\",\"\",IF(B4=\"oui\",16,0))","v":""}]
["Nodule recto-vaginal","?",{"$f":"IF(B5=\"?\",\"\",IF(B5=\"oui\",16,0))","v":""}]
["Lésions péritonéales profondes+oblitération partielle Douglas","?",{"$f":"IF(B6=\"?\",\"\",IF(B6=\"oui\",16,0))","v":""}]
["Score AFSE",{"$f":"IF(C7=\"\",\"\",IF(C7<16,2,0))","v":""},{"$f":"IF(AND(C3=\"\",C4=\"\",C5=\"\",C6=\"\"),\"\",SUM(C3:C6))","v":""}]

{"sheet":"Least Function Score","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Least Function Score","Gauche","Droit",null,"?"]
["Trompe","?","?",null,"Normal"]
["Pavillon","?","?",null,"Atteinte légère"]
["Ovaire","?","?",null,"Atteinte modérée"]
["Score le plus bas",{"$f":"F12","v":""},{"$f":"G12","v":""},null,"Atteinte sévère"]
["Score LFS total",{"$f":"IF(OR(B5=\"\",C5=\"\"),\"\",B5+C5)","v":""},null,null,"Non fonctionnel ou absent"]
[]
[null,null,null,null,null,"Gauche","Droit"]
[null,null,null,null,"Trompe",{"$f":"IF(B2=\"?\",\"\",IF(B2=\"normal\",4,IF(B2=\"Atteinte légère\",3,IF(B2=\"Atteinte modérée\",2,IF(B2=\"Atteinte sévère\",1,IF(B2=\"Non fonctionnel ou absent\",0))))))","v":""},{"$f":"IF(C2=\"?\",\"\",IF(C2=\"normal\",4,IF(C2=\"Atteinte légère\",3,IF(C2=\"Atteinte modérée\",2,IF(C2=\"Atteinte sévère\",1,IF(C2=\"Non fonctionnel ou absent\",0))))))","v":""}]
[null,null,null,null,"Pavillon",{"$f":"IF(B3=\"?\",\"\",IF(B3=\"normal\",4,IF(B3=\"Atteinte légère\",3,IF(B3=\"Atteinte modérée\",2,IF(B3=\"Atteinte sévère\",1,IF(B3=\"Non fonctionnel ou absent\",0))))))","v":""},""]
[null,null,null,null,"Ovaire",{"$f":"IF(B4=\"?\",\"\",IF(B4=\"normal\",4,IF(B4=\"Atteinte légère\",3,IF(B4=\"Atteinte modérée\",2,IF(B4=\"Atteinte sévère\",1,IF(B4=\"Non fonctionnel ou absent\",0))))))","v":""},""]
[null,null,null,null,"Score le plus bas",{"$f":"IF(F13=3,\"\",MIN(F9:F11))","v":""},{"$f":"IF(G13=3,\"\",MIN(G9:G11))","v":""}]
[null,null,null,null,null,{"$f":"COUNTBLANK(F9:F11)","v":3},{"$f":"COUNTBLANK(G9:G11)","v":3}]

{"sheet":"EFI","index":4,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Endometriosis Fertility Index  (EFI)"]
["Facteurs d'anamnèse",null,null,"Facteurs chirurgicaux",null,null,"Facteur d'anamnèse",null,"Facteur chirurgicaux"]
["Description",null,"Points","Facteur","Points",null,"Description","Points","Facteur","Description","Points"]
["Âge","?",{"$f":"IF(B4=\"?\",\"\",IF(B4=\"<35 ans\",2,IF(B4=\"36 - 39 ans\",1,IF(B4=\"> 40 ans\",0))))","v":""},"Least Fonction score",{"$f":"IF(LFS=0,\"\",IF(LFS<4,2,IF(AND(LFS>3,LFS<7),1,IF(LFS>=7,0))))","v":0},null,"Âge",null,"Least Fonction score"]
["Durée d'infertilité","?",{"$f":"IF(B5=\"?\",\"\",IF(B5=\"< 3 ans\",2,IF(B5=\"> 3 ans\",0)))","v":""},"Score AFSE des lésions endométriose",{"$f":"IF(AFSE=\"\",\"\",AFSE)","v":""},null,"Si âge <35 ans",2,null,"Si LF score =7 ou 8 (score élevé)",2]
["Antécédent de grossesse","?",{"$f":"IF(B6=\"?\",\"\",IF(B6=\"oui\",1,IF(B6=\"non\",0)))","v":""},"Score AFS total",{"$f":"IF(AFS=\"\",\"\",IF(AFS<71,1,0))","v":""},null,"Si âge entre 36 et 39 ans",1,null,"Si LF score-4 à 6 (score moyen)",1]
[null,"Total facteurs d'anamnèse",{"$f":"IF(AND(C4=\"\",C5=\"\",C6=\"\"),\"\",SUM(C4:C6))","v":""},"Total facteurs chirurgicaux",{"$f":"SUM(E4:E6)","v":0},null,"Si durée <3 ans",2,null,"Si score AFS lésion endométriose <16",2]
["EFI total ",{"$f":"IF(OR(C7=\"\",E7=\"\"),\"\",C7+E7)","v":""},null,null,null,null,"Si durée > 3 ans",0,null,"Si score AFS lésion endométriose> 16",0]
[null,null,null,null,null,null,"Antécédent de grossesse",null,"Score AFS total"]
[null,null,null,null,null,null,"Si antécédent de grossesse",1,null,"Si score AFS total <71",1]
[null,null,null,null,null,null,"Si pas d'antécédent de grossesse",0,null,"Si score AFS total >71",0]
[null,null,null,null,null,null,"Total facteur d'anamnèse",null,"Total facteurs chirurgicaux"]
[]
[null,null,null,null,null,null,"EFI = total facteur d'anamnèse + total facteurs chirurgicaux",{"$f":"H12+K12","v":0}]
[]
[null,null,null,null,null,null,"?"]
[null,null,null,null,null,null,"<35 ans"]
[null,null,null,null,null,null,"36 - 39 ans"]
[null,null,null,null,null,null,"> 40 ans"]
[]
[null,null,null,null,null,null,"?"]
[null,null,null,null,null,null,"< 3 ans"]
[null,null,null,null,null,null,"> 3 ans"]
[]
[null,null,null,null,null,null,"?"]
[null,null,null,null,null,null,"oui"]
[null,null,null,null,null,null,"non"]

{"sheet":"Résumé","index":5,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Scores Endométriose"]
[]
[{"$f":"\"Mme \" &TEXT(Sommaire!C2,\"0\")&\" \"&TEXT(Sommaire!C3,\"0\")","v":"Mme 0 0"},null," Date de naissance =",{"$f":"Sommaire!C4","v":"00:00:00"}]