{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Plumitif","Calcul des points","Listes"],"read":"whole","date_system":"1900"}

{"sheet":"Plumitif","index":0,"n_rows":54,"n_cols":12,"rows_kept":54}
[null,null,"Joueurs :"]
["Tour",null,"Calendrier","Demandeur","PA","Nullité","Prescription","Défendeur","PA","Nullité","Prescription","Greffe"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]

{"sheet":"Calcul des points","index":1,"n_rows":26,"n_cols":7,"rows_kept":26}
["Incidents"]
["Assignation caduque",false]
["Assignation nulle",false]
["Demande prescrite",false]
["Pièces non communiquées",false]
["ARA",false]
[]
["Durée"]
[]
["Noms des Joueurs"]
[null,"Demandeur",null,null,"Défendeur"]
["Nombre de cartes déposées",null,"A1","sauf  Nullité, Prescription",null,"A2"," sauf Nullité, Prescription"]
["Points de procédure",{"$f":"IF(OR(B2:B3),0,B12)","v":0},"B1","B1= A1\nB1= 0 si Assignation caduque ou nulle",{"$f":"E12","v":0},"B2","B2=A2"]
[]
["Assignation",null,"C1"]
["Conclusions",null,"D1","D1=PA divisé par 2",null,"D2"]
["Plaidoiries",null,"E1",null,null,"E2"]
["Total points d'argumentation",{"$f":"B15+B16/2+B17","v":0},"F1","F1=C1+D1/2+E1",{"$f":"E16+E17","v":0},"F2","F2=D2+E2"]
["Différence",{"$f":"B18-E18","v":0},"G1","G1=F1-F2",{"$f":"E18-B18","v":0},"G2","G2=F2-F1"]
["Gain du procès (si positifs)",{"$f":"IF(OR($B$2,$B$3,$B$5,B19<=0),0,B19)","v":0},"H1","H1=G1 si  G1>0 et\nH1=0 si Pièces du Demandeur non communiquées\nH1=0 si Assignation caduque ou nulle",{"$f":"IF(OR($B$2,$B$3,$B$5,E19<=0),0,E19)","v":0},"H2","H2=G=2 si  G2>0 et\nH2=0 si Pièces du Demandeur non communiquées\nH2=0 si Assignation caduque ou nulle"]
[]
["Jugement",{"$f":"IF($B$6,10,IF($B$4,0,B20))","v":0},"I1","I1=H1\nI1=0 si Prescription\nI1= 10 si ARA",{"$f":"IF($B$6,10,IF($B$4,5,E20))","v":0},"I2","I2=H2\nI2=5 si Prescription\nI2= 10 si ARA"]
[]
["Points de célérité",{"$f":"IF(OR(B2,B3,B5),0,(IF($B$8<15,15-$B$8,0)))","v":15},"J1","J1=15-Durée si Durée<15\nJ1=0 si Pièces du Demandeur non communiquées\nJ1=0 si Assignation cadure ou nulle",{"$f":"IF($B$8>15,$B$8-15,0)","v":0},"J2","J2=15-Durée-15 si Durée>15"]
[]
["Total",{"$f":"B13+B22+B24","v":15},"K1","K1=B1+I1+J1",{"$f":"E13+E22+E24","v":0},"K2","K2=B2+I2+J2"]

{"sheet":"Listes","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"hidden":true}
["Joueur","Demandeur","Défendeur","Greffe","Délais","Moyens"]
["Primus","Assignation","Constitution","Audience d'orientation","D<=: Constitution","Nullité"]
["Secundus","Enrôlement","Enrôlement","Ordonnance de clôture","D>=: Enrôlement","Prescription"]
[null,"Pièces","Conclusions et Pièces","Jugement","D<= Pièces du Demandeur"]
[null,"Conclusions en réponse","Ordonnance de clôture",null,"D<= Conclusions et Pièces du Défendeur"]
[null,"Ordonnance de clôture","Plaidoirie",null,"D<=: Conclusions en réponse du Demandeur"]
[null,"Plaidoirie","ARA",null,"D<=: Ordonnance de clôture"]
[null,"ARA","Jugement",null,"D=: Audience de plaidoirie"]
[null,"Jugement",null,null,"D<= : Jugement"]