{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["EMISSION","FR","NL","EN"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":4,"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":"EMISSION","index":0,"n_rows":1242,"n_cols":30,"rows_kept":1242,"cut":false,"hidden":false,"merged":[]}
["References Rules",null,null,null,null,"DOSSIER"," ISIN 1",null," ISIN 2",null," ISIN 3",null," ISIN 4",null," ISIN 5",null," ISIN 6",null," ISIN 7",null," ISIN 8",null," ISIN 9",null," ISIN 10",null," ISIN 11",null," ISIN 12"]
["Annex 19.1",null,"Unit rate","TOTALS",null,"Input column","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee"]
["Issue Fee"]
[null,null,null,null,null,{"$f":"IF(F5<500,\"minimum 500\",\" \")","v":"minimum 500"}]
["I.1","Handling charges                  (minimum 500 and per multiple of 250)",null,{"$f":"F5","v":0},"(a)",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR"]
[null,"(One-off fee)",null,null,null,{"$f":"IF(AND($E$1000<>0,G6=\"DEVISES\"),\"par tranche de 250\",IF(AND($E$1000<>0,G6=\"ANDERE MUNT\"),\"per schijf van 250\",IF(AND($E$1000<>0,G6=\"CURRENCY\"),\"per multiple of 250\",\" \")))","v":" "},"FOR CURR",null,"FOR CURR",null,"FOR CURR",null,"FOR CURR",null,"FOR CURR",null,"FOR CURR",null,"FOR CURR",null,"FOR CURR",null,"FOR CURR",null,"FOR CURR",null,"FOR CURR",null,"FOR CURR"]
[null,"One-off invoice"]
["II.1","Creation of the ISIN code",100,{"$f":"SUM(H8,,J8,L8,N8,P8,R8,T8,V8,X8,Z8,AB8,AD8)","v":0},null,null,null,{"$f":"IF(G992=TRUE,$C8,0)","v":0},null,{"$f":"IF(I992=TRUE,$C8,0)","v":0},null,{"$f":"IF(K992=TRUE,$C8,0)","v":0},null,{"$f":"IF(M992=TRUE,$C8,0)","v":0},null,{"$f":"IF(O992=TRUE,$C8,0)","v":0},null,{"$f":"IF(Q992=TRUE,$C8,0)","v":0},null,{"$f":"IF(S992=TRUE,$C8,0)","v":0},null,{"$f":"IF(U992=TRUE,$C8,0)","v":0},null,{"$f":"IF(W992=TRUE,$C8,0)","v":0},null,{"$f":"IF(Y992=TRUE,$C8,0)","v":0},null,{"$f":"IF(AA992=TRUE,$C8,0)","v":0},null,{"$f":"IF(AC992=TRUE,$C8,0)","v":0}]
["II.3","Creation of the ISIN code : data of the coupons known before the issue",100,{"$f":"SUM(H9,,J9,L9,N9,P9,R9,T9,V9,X9,Z9,AB9,AD9)","v":0},null,null,null,{"$f":"IF(G993=TRUE,$C9,0)","v":0},null,{"$f":"IF(I993=TRUE,$C9,0)","v":0},null,{"$f":"IF(K993=TRUE,$C9,0)","v":0},null,{"$f":"IF(M993=TRUE,$C9,0)","v":0},null,{"$f":"IF(O993=TRUE,$C9,0)","v":0},null,{"$f":"IF(Q993=TRUE,$C9,0)","v":0},null,{"$f":"IF(S993=TRUE,$C9,0)","v":0},null,{"$f":"IF(U993=TRUE,$C9,0)","v":0},null,{"$f":"IF(W993=TRUE,$C9,0)","v":0},null,{"$f":"IF(Y993=TRUE,$C9,0)","v":0},null,{"$f":"IF(AA993=TRUE,$C9,0)","v":0},null,{"$f":"IF(AC993=TRUE,$C9,0)","v":0}]
["II.4","Creation of the ISIN code : bond factors provided for",250,{"$f":"SUM(H10,,J10,L10,N10,P10,R10,T10,V10,X10,Z10,AB10,AD10)","v":0},null,null,null,{"$f":"IF(G994=TRUE,$C10,0)","v":0},null,{"$f":"IF(I994=TRUE,$C10,0)","v":0},null,{"$f":"IF(K994=TRUE,$C10,0)","v":0},null,{"$f":"IF(M994=TRUE,$C10,0)","v":0},null,{"$f":"IF(O994=TRUE,$C10,0)","v":0},null,{"$f":"IF(Q994=TRUE,$C10,0)","v":0},null,{"$f":"IF(S994=TRUE,$C10,0)","v":0},null,{"$f":"IF(U994=TRUE,$C10,0)","v":0},null,{"$f":"IF(W994=TRUE,$C10,0)","v":0},null,{"$f":"IF(Y994=TRUE,$C10,0)","v":0},null,{"$f":"IF(AA994=TRUE,$C10,0)","v":0},null,{"$f":"IF(AC994=TRUE,$C10,0)","v":0}]
[null,"Subtotal one-off invoice",null,{"$f":"SUM(D8:D10)","v":0},"(b)",null,null,{"$f":"SUM(H8:H10)","v":0},null,{"$f":"SUM(J8:J10)","v":0},null,{"$f":"SUM(L8:L10)","v":0},null,{"$f":"SUM(N8:N10)","v":0},null,{"$f":"SUM(P8:P10)","v":0},null,{"$f":"SUM(R8:R10)","v":0},null,{"$f":"SUM(T8:T10)","v":0},null,{"$f":"SUM(V8:V10)","v":0},null,{"$f":"SUM(X8:X10)","v":0},null,{"$f":"SUM(Z8:Z10)","v":0},null,{"$f":"SUM(AB8:AB10)","v":0},null,{"$f":"SUM(AD8:AD10)","v":0}]
["III.1","Repayment in EUR of the capital on the final due date",10,{"$f":"SUM(H12,,J12,L12,N12,P12,R12,T12,V12,X12,Z12,AB12,AD12)","v":0},"(c)",null,null,{"$f":"IF(AND(G1000=2,G995=TRUE,G6=\"DEVISES\"),\"DEVISES\",IF(AND(G1000=2,G995=TRUE,G6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(G1000=2,G995=TRUE,G6=\"CURRENCY\"),\"CURRENCY\",IF(G995=TRUE,$C12,0))))","v":0},null,{"$f":"IF(AND(I1000=2,I995=TRUE,I6=\"DEVISES\"),\"DEVISES\",IF(AND(I1000=2,I995=TRUE,I6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(I1000=2,I995=TRUE,I6=\"CURRENCY\"),\"CURRENCY\",IF(I995=TRUE,$C12,0))))","v":0},null,{"$f":"IF(AND(K1000=2,K995=TRUE,K6=\"DEVISES\"),\"DEVISES\",IF(AND(K1000=2,K995=TRUE,K6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(K1000=2,K995=TRUE,K6=\"CURRENCY\"),\"CURRENCY\",IF(K995=TRUE,$C12,0))))","v":0},null,{"$f":"IF(AND(M1000=2,M995=TRUE,M6=\"DEVISES\"),\"DEVISES\",IF(AND(M1000=2,M995=TRUE,M6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(M1000=2,M995=TRUE,M6=\"CURRENCY\"),\"CURRENCY\",IF(M995=TRUE,$C12,0))))","v":0},null,{"$f":"IF(AND(O1000=2,O995=TRUE,O6=\"DEVISES\"),\"DEVISES\",IF(AND(O1000=2,O995=TRUE,O6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(O1000=2,O995=TRUE,O6=\"CURRENCY\"),\"CURRENCY\",IF(O995=TRUE,$C12,0))))","v":0},null,{"$f":"IF(AND(Q1000=2,Q995=TRUE,Q6=\"DEVISES\"),\"DEVISES\",IF(AND(Q1000=2,Q995=TRUE,Q6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(Q1000=2,Q995=TRUE,Q6=\"CURRENCY\"),\"CURRENCY\",IF(Q995=TRUE,$C12,0))))","v":0},null,{"$f":"IF(AND(S1000=2,S995=TRUE,S6=\"DEVISES\"),\"DEVISES\",IF(AND(S1000=2,S995=TRUE,S6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(S1000=2,S995=TRUE,S6=\"CURRENCY\"),\"CURRENCY\",IF(S995=TRUE,$C12,0))))","v":0},null,{"$f":"IF(AND(U1000=2,U995=TRUE,U6=\"DEVISES\"),\"DEVISES\",IF(AND(U1000=2,U995=TRUE,U6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(U1000=2,U995=TRUE,U6=\"CURRENCY\"),\"CURRENCY\",IF(U995=TRUE,$C12,0))))","v":0},null,{"$f":"IF(AND(W1000=2,W995=TRUE,W6=\"DEVISES\"),\"DEVISES\",IF(AND(W1000=2,W995=TRUE,W6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(W1000=2,W995=TRUE,W6=\"CURRENCY\"),\"CURRENCY\",IF(W995=TRUE,$C12,0))))","v":0},null,{"$f":"IF(AND(Y1000=2,Y995=TRUE,Y6=\"DEVISES\"),\"DEVISES\",IF(AND(Y1000=2,Y995=TRUE,Y6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(Y1000=2,Y995=TRUE,Y6=\"CURRENCY\"),\"CURRENCY\",IF(Y995=TRUE,$C12,0))))","v":0},null,{"$f":"IF(AND(AA1000=2,AA995=TRUE,AA6=\"DEVISES\"),\"DEVISES\",IF(AND(AA1000=2,AA995=TRUE,AA6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(AA1000=2,AA995=TRUE,AA6=\"CURRENCY\"),\"CURRENCY\",IF(AA995=TRUE,$C12,0))))","v":0},null,{"$f":"IF(AND(AC1000=2,AC995=TRUE,AC6=\"DEVISES\"),\"DEVISES\",IF(AND(AC1000=2,AC995=TRUE,AC6=\"ANDERE MUNT\"),\"ANDERE MUNT\",IF(AND(AC1000=2,AC995=TRUE,AC6=\"CURRENCY\"),\"CURRENCY\",IF(AC995=TRUE,$C12,0))))","v":0}]
[null,"Interventions without automatic standard procedures"]
["II.7","Complete cancellation of the circulation ",250,{"$f":"SUM(H14,J14,L14,N14,P14,R14,T14,V14,X14,Z14,AB14,AD14)","v":0},null,null,null,{"$f":"IF(AND(G997=TRUE,G998=TRUE,G6=\"DEVISES\"),\"1 seul choix\",IF(AND(G997=TRUE,G998=TRUE,G6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(G997=TRUE,G998=TRUE,G6=\"CURRENCY\"),\"only 1 choice\",IF(G997=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(I997=TRUE,I998=TRUE,I6=\"DEVISES\"),\"1 seul choix\",IF(AND(I997=TRUE,I998=TRUE,I6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(I997=TRUE,I998=TRUE,I6=\"CURRENCY\"),\"only 1 choice\",IF(I997=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(K997=TRUE,K998=TRUE,K6=\"DEVISES\"),\"1 seul choix\",IF(AND(K997=TRUE,K998=TRUE,K6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(K997=TRUE,K998=TRUE,K6=\"CURRENCY\"),\"only 1 choice\",IF(K997=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(M997=TRUE,M998=TRUE,M6=\"DEVISES\"),\"1 seul choix\",IF(AND(M997=TRUE,M998=TRUE,M6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(M997=TRUE,M998=TRUE,M6=\"CURRENCY\"),\"only 1 choice\",IF(M997=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(O997=TRUE,O998=TRUE,O6=\"DEVISES\"),\"1 seul choix\",IF(AND(O997=TRUE,O998=TRUE,O6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(O997=TRUE,O998=TRUE,O6=\"CURRENCY\"),\"only 1 choice\",IF(O997=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(Q997=TRUE,Q998=TRUE,Q6=\"DEVISES\"),\"1 seul choix\",IF(AND(Q997=TRUE,Q998=TRUE,Q6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(Q997=TRUE,Q998=TRUE,Q6=\"CURRENCY\"),\"only 1 choice\",IF(Q997=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(S997=TRUE,S998=TRUE,S6=\"DEVISES\"),\"1 seul choix\",IF(AND(S997=TRUE,S998=TRUE,S6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(S997=TRUE,S998=TRUE,S6=\"CURRENCY\"),\"only 1 choice\",IF(S997=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(U997=TRUE,U998=TRUE,U6=\"DEVISES\"),\"1 seul choix\",IF(AND(U997=TRUE,U998=TRUE,U6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(U997=TRUE,U998=TRUE,U6=\"CURRENCY\"),\"only 1 choice\",IF(U997=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(W997=TRUE,W998=TRUE,W6=\"DEVISES\"),\"1 seul choix\",IF(AND(W997=TRUE,W998=TRUE,W6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(W997=TRUE,W998=TRUE,W6=\"CURRENCY\"),\"only 1 choice\",IF(W997=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(Y997=TRUE,Y998=TRUE,Y6=\"DEVISES\"),\"1 seul choix\",IF(AND(Y997=TRUE,Y998=TRUE,Y6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(Y997=TRUE,Y998=TRUE,Y6=\"CURRENCY\"),\"only 1 choice\",IF(Y997=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(AA997=TRUE,AA998=TRUE,AA6=\"DEVISES\"),\"1 seul choix\",IF(AND(AA997=TRUE,AA998=TRUE,AA6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(AA997=TRUE,AA998=TRUE,AA6=\"CURRENCY\"),\"only 1 choice\",IF(AA997=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(AC997=TRUE,AC998=TRUE,AC6=\"DEVISES\"),\"1 seul choix\",IF(AND(AC997=TRUE,AC998=TRUE,AC6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(AC997=TRUE,AC998=TRUE,AC6=\"CURRENCY\"),\"only 1 choice\",IF(AC997=TRUE,250,0))))","v":0}]
["III.5","Complete cancellation of the circulation and full capital repayment  ",250,{"$f":"SUM(H15,J15,L15,N15,P15,R15,T15,V15,X15,Z15,AB15,AD15)","v":0},null,null,null,{"$f":"IF(AND(G997=TRUE,G998=TRUE,G6=\"DEVISES\"),\"1 seul choix\",IF(AND(G997=TRUE,G998=TRUE,G6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(G997=TRUE,G998=TRUE,G6=\"CURRENCY\"),\"only 1 choice\",IF(G998=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(I997=TRUE,I998=TRUE,I6=\"DEVISES\"),\"1 seul choix\",IF(AND(I997=TRUE,I998=TRUE,I6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(I997=TRUE,I998=TRUE,I6=\"CURRENCY\"),\"only 1 choice\",IF(I998=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(K997=TRUE,K998=TRUE,K6=\"DEVISES\"),\"1 seul choix\",IF(AND(K997=TRUE,K998=TRUE,K6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(K997=TRUE,K998=TRUE,K6=\"CURRENCY\"),\"only 1 choice\",IF(K998=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(M997=TRUE,M998=TRUE,M6=\"DEVISES\"),\"1 seul choix\",IF(AND(M997=TRUE,M998=TRUE,M6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(M997=TRUE,M998=TRUE,M6=\"CURRENCY\"),\"only 1 choice\",IF(M998=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(O997=TRUE,O998=TRUE,O6=\"DEVISES\"),\"1 seul choix\",IF(AND(O997=TRUE,O998=TRUE,O6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(O997=TRUE,O998=TRUE,O6=\"CURRENCY\"),\"only 1 choice\",IF(O998=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(Q997=TRUE,Q998=TRUE,Q6=\"DEVISES\"),\"1 seul choix\",IF(AND(Q997=TRUE,Q998=TRUE,Q6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(Q997=TRUE,Q998=TRUE,Q6=\"CURRENCY\"),\"only 1 choice\",IF(Q998=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(S997=TRUE,S998=TRUE,S6=\"DEVISES\"),\"1 seul choix\",IF(AND(S997=TRUE,S998=TRUE,S6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(S997=TRUE,S998=TRUE,S6=\"CURRENCY\"),\"only 1 choice\",IF(S998=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(U997=TRUE,U998=TRUE,U6=\"DEVISES\"),\"1 seul choix\",IF(AND(U997=TRUE,U998=TRUE,U6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(U997=TRUE,U998=TRUE,U6=\"CURRENCY\"),\"only 1 choice\",IF(U998=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(W997=TRUE,W998=TRUE,W6=\"DEVISES\"),\"1 seul choix\",IF(AND(W997=TRUE,W998=TRUE,W6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(W997=TRUE,W998=TRUE,W6=\"CURRENCY\"),\"only 1 choice\",IF(W998=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(Y997=TRUE,Y998=TRUE,Y6=\"DEVISES\"),\"1 seul choix\",IF(AND(Y997=TRUE,Y998=TRUE,Y6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(Y997=TRUE,Y998=TRUE,Y6=\"CURRENCY\"),\"only 1 choice\",IF(Y998=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(AA997=TRUE,AA998=TRUE,AA6=\"DEVISES\"),\"1 seul choix\",IF(AND(AA997=TRUE,AA998=TRUE,AA6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(AA997=TRUE,AA998=TRUE,AA6=\"CURRENCY\"),\"only 1 choice\",IF(AA998=TRUE,250,0))))","v":0},null,{"$f":"IF(AND(AC997=TRUE,AC998=TRUE,AC6=\"DEVISES\"),\"1 seul choix\",IF(AND(AC997=TRUE,AC998=TRUE,AC6=\"ANDERE MUNT\"),\"enkel 1 keuze\",IF(AND(AC997=TRUE,AC998=TRUE,AC6=\"CURRENCY\"),\"only 1 choice\",IF(AC998=TRUE,250,0))))","v":0}]
[null,"Subtotal interventions without automatic standard procedures",null,{"$f":"SUM(D14:D15)","v":0},"(d)",null,null,{"$f":"SUM(H14:H15)","v":0},null,{"$f":"SUM(J14:J15)","v":0},null,{"$f":"SUM(L14:L15)","v":0},null,{"$f":"SUM(N14:N15)","v":0},null,{"$f":"SUM(P14:P15)","v":0},null,{"$f":"SUM(R14:R15)","v":0},null,{"$f":"SUM(T14:T15)","v":0},null,{"$f":"SUM(V14:V15)","v":0},null,{"$f":"SUM(X14:X15)","v":0},null,{"$f":"SUM(Z14:Z15)","v":0},null,{"$f":"SUM(AB14:AB15)","v":0},null,{"$f":"SUM(AD14:AD15)","v":0}]
[null,"Annual invoice"]
["II.2","Number of coupons created / Year",50,{"$f":"SUM(H18,,J18,L18,N18,P18,R18,T18,V18,X18,Z18,AB18,AD18)","v":0},null,null,null,{"$f":"IF(AND(G993=TRUE,G18>0,G6=\"DEVISES\"),\"Facture unique\",IF(AND(G993=TRUE,G18>0,G6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(G993=TRUE,G18>0,G6=\"CURRENCY\"),\"One-off invoice\",$C18*G18)))","v":0},null,{"$f":"IF(AND(I993=TRUE,I18>0,I6=\"DEVISES\"),\"Facture unique\",IF(AND(I993=TRUE,I18>0,I6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(I993=TRUE,I18>0,I6=\"CURRENCY\"),\"One-off invoice\",$C18*I18)))","v":0},null,{"$f":"IF(AND(K993=TRUE,K18>0,K6=\"DEVISES\"),\"Facture unique\",IF(AND(K993=TRUE,K18>0,K6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(K993=TRUE,K18>0,K6=\"CURRENCY\"),\"One-off invoice\",$C18*K18)))","v":0},null,{"$f":"IF(AND(M993=TRUE,M18>0,M6=\"DEVISES\"),\"Facture unique\",IF(AND(M993=TRUE,M18>0,M6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(M993=TRUE,M18>0,M6=\"CURRENCY\"),\"One-off invoice\",$C18*M18)))","v":0},null,{"$f":"IF(AND(O993=TRUE,O18>0,O6=\"DEVISES\"),\"Facture unique\",IF(AND(O993=TRUE,O18>0,O6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(O993=TRUE,O18>0,O6=\"CURRENCY\"),\"One-off invoice\",$C18*O18)))","v":0},null,{"$f":"IF(AND(Q993=TRUE,Q18>0,Q6=\"DEVISES\"),\"Facture unique\",IF(AND(Q993=TRUE,Q18>0,Q6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(Q993=TRUE,Q18>0,Q6=\"CURRENCY\"),\"One-off invoice\",$C18*Q18)))","v":0},null,{"$f":"IF(AND(S993=TRUE,S18>0,S6=\"DEVISES\"),\"Facture unique\",IF(AND(S993=TRUE,S18>0,S6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(S993=TRUE,S18>0,S6=\"CURRENCY\"),\"One-off invoice\",$C18*S18)))","v":0},null,{"$f":"IF(AND(U993=TRUE,U18>0,U6=\"DEVISES\"),\"Facture unique\",IF(AND(U993=TRUE,U18>0,U6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(U993=TRUE,U18>0,U6=\"CURRENCY\"),\"One-off invoice\",$C18*U18)))","v":0},null,{"$f":"IF(AND(W993=TRUE,W18>0,W6=\"DEVISES\"),\"Facture unique\",IF(AND(W993=TRUE,W18>0,W6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(W993=TRUE,W18>0,W6=\"CURRENCY\"),\"One-off invoice\",$C18*W18)))","v":0},null,{"$f":"IF(AND(Y993=TRUE,Y18>0,Y6=\"DEVISES\"),\"Facture unique\",IF(AND(Y993=TRUE,Y18>0,Y6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(Y993=TRUE,Y18>0,Y6=\"CURRENCY\"),\"One-off invoice\",$C18*Y18)))","v":0},null,{"$f":"IF(AND(AA993=TRUE,AA18>0,AA6=\"DEVISES\"),\"Facture unique\",IF(AND(AA993=TRUE,AA18>0,AA6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(AA993=TRUE,AA18>0,AA6=\"CURRENCY\"),\"One-off invoice\",$C18*AA18)))","v":0},null,{"$f":"IF(AND(AC993=TRUE,AC18>0,AC6=\"DEVISES\"),\"Facture unique\",IF(AND(AC993=TRUE,AC18>0,AC6=\"ANDERE MUNT\"),\"Unieke factuur\",IF(AND(AC993=TRUE,AC18>0,AC6=\"CURRENCY\"),\"One-off invoice\",$C18*AC18)))","v":0}]
["II.5","Number of bond factors entered / Year",100,0,null,null,null,{"$f":"IF(AND(G10=1,G19>0,G6=\"DEVISES\"),\"Facturation unique\",IF(AND(G10=1,G19>0,G6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(G10=1,G19>0,G6=\"CURRENCY\"),\"One-off invoice\",$C19*G19)))","v":0},null,{"$f":"IF(AND(I10=1,I19>0,I6=\"DEVISES\"),\"Facturation unique\",IF(AND(I10=1,I19>0,I6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(I10=1,I19>0,I6=\"CURRENCY\"),\"One-off invoice\",$C19*I19)))","v":0},null,{"$f":"IF(AND(K10=1,K19>0,K6=\"DEVISES\"),\"Facturation unique\",IF(AND(K10=1,K19>0,K6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(K10=1,K19>0,K6=\"CURRENCY\"),\"One-off invoice\",$C19*K19)))","v":0},null,{"$f":"IF(AND(M10=1,M19>0,M6=\"DEVISES\"),\"Facturation unique\",IF(AND(M10=1,M19>0,M6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(M10=1,M19>0,M6=\"CURRENCY\"),\"One-off invoice\",$C19*M19)))","v":0},null,{"$f":"IF(AND(O10=1,O19>0,O6=\"DEVISES\"),\"Facturation unique\",IF(AND(O10=1,O19>0,O6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(O10=1,O19>0,O6=\"CURRENCY\"),\"One-off invoice\",$C19*O19)))","v":0},null,{"$f":"IF(AND(Q10=1,Q19>0,Q6=\"DEVISES\"),\"Facturation unique\",IF(AND(Q10=1,Q19>0,Q6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(Q10=1,Q19>0,Q6=\"CURRENCY\"),\"One-off invoice\",$C19*Q19)))","v":0},null,{"$f":"IF(AND(S10=1,S19>0,S6=\"DEVISES\"),\"Facturation unique\",IF(AND(S10=1,S19>0,S6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(S10=1,S19>0,S6=\"CURRENCY\"),\"One-off invoice\",$C19*S19)))","v":0},null,{"$f":"IF(AND(U10=1,U19>0,U6=\"DEVISES\"),\"Facturation unique\",IF(AND(U10=1,U19>0,U6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(U10=1,U19>0,U6=\"CURRENCY\"),\"One-off invoice\",$C19*U19)))","v":0},null,{"$f":"IF(AND(W10=1,W19>0,W6=\"DEVISES\"),\"Facturation unique\",IF(AND(W10=1,W19>0,W6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(W10=1,W19>0,W6=\"CURRENCY\"),\"One-off invoice\",$C19*W19)))","v":0},null,{"$f":"IF(AND(Y10=1,Y19>0,Y6=\"DEVISES\"),\"Facturation unique\",IF(AND(Y10=1,Y19>0,Y6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(Y10=1,Y19>0,Y6=\"CURRENCY\"),\"One-off invoice\",$C19*Y19)))","v":0},null,{"$f":"IF(AND(AA10=1,AA19>0,AA6=\"DEVISES\"),\"Facturation unique\",IF(AND(AA10=1,AA19>0,AA6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(AA10=1,AA19>0,AA6=\"CURRENCY\"),\"One-off invoice\",$C19*AA19)))","v":0},null,{"$f":"IF(AND(AC10=1,AC19>0,AC6=\"DEVISES\"),\"Facturation unique\",IF(AND(AC10=1,AC19>0,AC6=\"ANDERE MUNT\"),\"Eenmalige facturering\",IF(AND(AC10=1,AC19>0,AC6=\"CURRENCY\"),\"One-off invoice\",$C19*AC19)))","v":0}]
["II.6","Number of partial diminutions of the circulation without bond factor / Year",250,0,null,null,null,{"$f":"G20*$C20","v":0},null,{"$f":"I20*$C20","v":0},null,{"$f":"K20*$C20","v":0},null,{"$f":"M20*$C20","v":0},null,{"$f":"O20*$C20","v":0},null,{"$f":"Q20*$C20","v":0},null,{"$f":"S20*$C20","v":0},null,{"$f":"U20*$C20","v":0},null,{"$f":"W20*$C20","v":0},null,{"$f":"Y20*$C20","v":0},null,{"$f":"AA20*$C20","v":0},null,{"$f":"AC20*$C20","v":0}]
["III.2","Number of payments of coupon interest / Year",100,0,null,null,null,{"$f":"G21*$C21","v":0},null,{"$f":"I21*$C21","v":0},null,{"$f":"K21*$C21","v":0},null,{"$f":"M21*$C21","v":0},null,{"$f":"O21*$C21","v":0},null,{"$f":"Q21*$C21","v":0},null,{"$f":"S21*$C21","v":0},null,{"$f":"U21*$C21","v":0},null,{"$f":"W21*$C21","v":0},null,{"$f":"Y21*$C21","v":0},null,{"$f":"AA21*$C21","v":0},null,{"$f":"AC21*$C21","v":0}]
["III.3","Number of partial repayments of capital with bond factor / Year",100,0,null,null,null,{"$f":"G22*$C22","v":0},null,{"$f":"I22*$C22","v":0},null,{"$f":"K22*$C22","v":0},null,{"$f":"M22*$C22","v":0},null,{"$f":"O22*$C22","v":0},null,{"$f":"Q22*$C22","v":0},null,{"$f":"S22*$C22","v":0},null,{"$f":"U22*$C22","v":0},null,{"$f":"W22*$C22","v":0},null,{"$f":"Y22*$C22","v":0},null,{"$f":"AA22*$C22","v":0},null,{"$f":"AC22*$C22","v":0}]
["III.4","Number of partial repayments of capital without bond factor / Year",250,0,null,null,null,{"$f":"G23*$C23","v":0},null,{"$f":"I23*$C23","v":0},null,{"$f":"K23*$C23","v":0},null,{"$f":"M23*$C23","v":0},null,{"$f":"O23*$C23","v":0},null,{"$f":"Q23*$C23","v":0},null,{"$f":"S23*$C23","v":0},null,{"$f":"U23*$C23","v":0},null,{"$f":"W23*$C23","v":0},null,{"$f":"Y23*$C23","v":0},null,{"$f":"AA23*$C23","v":0},null,{"$f":"AC23*$C23","v":0}]
["IV.1","Fee for physical securities",250,0,null,null,2,{"$f":"IF(G996=TRUE,$C24,0)","v":0},null,{"$f":"IF(I996=TRUE,$C24,0)","v":0},null,{"$f":"IF(K996=TRUE,$C24,0)","v":0},null,{"$f":"IF(M996=TRUE,$C24,0)","v":0},null,{"$f":"IF(O996=TRUE,$C24,0)","v":0},null,{"$f":"IF(Q996=TRUE,$C24,0)","v":0},null,{"$f":"IF(S996=TRUE,$C24,0)","v":0},null,{"$f":"IF(U996=TRUE,$C24,0)","v":0},null,{"$f":"IF(W996=TRUE,$C24,0)","v":0},null,{"$f":"IF(Y996=TRUE,$C24,0)","v":0},null,{"$f":"IF(AA996=TRUE,$C24,0)","v":0},null,{"$f":"IF(AC996=TRUE,$C24,0)","v":0}]
[null,"Subtotal annual invoice",null,{"$f":"SUM(D18:D24)","v":0},"(e)",null,null,{"$f":"SUM(H18:H24)","v":0},null,{"$f":"SUM(J18:J24)","v":0},null,{"$f":"SUM(L18:L24)","v":0},null,{"$f":"SUM(N18:N24)","v":0},null,{"$f":"SUM(P18:P24)","v":0},null,{"$f":"SUM(R18:R24)","v":0},null,{"$f":"SUM(T18:T24)","v":0},null,{"$f":"SUM(V18:V24)","v":0},null,{"$f":"SUM(X18:X24)","v":0},null,{"$f":"SUM(Z18:Z24)","v":0},null,{"$f":"SUM(AB18:AB24)","v":0},null,{"$f":"SUM(AD18:AD24)","v":0}]
["V.4","Leveled out fee depending of the nominal circulation"]
[null,"Outstanding amount"]
[null,"Start date"]
[null,"End date"]
[null,"Reminder : fee without application of the leveling out of 0,005 °/°° year * nominal circulation",null,{"$f":"SUM(H30+J30+L30+N30+P30+R30+T30+V30+X30+Z30+AB30+AD30)","v":0},null,null,null,{"$f":"G988","v":0},null,{"$f":"I988","v":0},null,{"$f":"K988","v":0},null,{"$f":"M988","v":0},null,{"$f":"O988","v":0},null,{"$f":"Q988","v":0},null,{"$f":"S988","v":0},null,{"$f":"U988","v":0},null,{"$f":"W988","v":0},null,{"$f":"Y988","v":0},null,{"$f":"AA988","v":0},null,{"$f":"AC988","v":0}]
[null,"Leveled out fee depending of the nominal circulation 1st year",null,{"$f":"SUM(H31+J31+L31+N31+P31+R31+T31+V31+X31+Z31+AB31+AD31)","v":0},"(f)",null,null,{"$f":"G991","v":0},null,{"$f":"I991","v":0},null,{"$f":"K991","v":0},null,{"$f":"M991","v":0},null,{"$f":"O991","v":0},null,{"$f":"Q991","v":0},null,{"$f":"S991","v":0},null,{"$f":"U991","v":0},null,{"$f":"W991","v":0},null,{"$f":"Y991","v":0},null,{"$f":"AA991","v":0},null,{"$f":"AC991","v":0}]
[null,"Leveled out fee depending of the nominal circulation for a complete year > 1 year",null,{"$f":"SUM(H32+J32+L32+N32+P32+R32+T32+V32+X32+Z32+AB32+AD32)","v":0},"(g)",null,null,{"$f":"IF(G986>1,G989,0)","v":0},null,{"$f":"IF(I986>1,I989,0)","v":0},null,{"$f":"IF(K986>1,K989,0)","v":0},null,{"$f":"IF(M986>1,M989,0)","v":0},null,{"$f":"IF(O986>1,O989,0)","v":0},null,{"$f":"IF(Q986>1,Q989,0)","v":0},null,{"$f":"IF(S986>1,S989,0)","v":0},null,{"$f":"IF(U986>1,U989,0)","v":0},null,{"$f":"IF(W986>1,W989,0)","v":0},null,{"$f":"IF(Y986>1,Y989,0)","v":0},null,{"$f":"IF(AA986>1,AA989,0)","v":0},null,{"$f":"IF(AC986>1,AC989,0)","v":0}]
[null,"Leveled out fee depending of the nominal circulation remaining fraction",null,{"$f":"SUM(H33+J33+L33+N33+P33+R33+T33+V33+X33+Z33+AB33+AD33)","v":0},"(h)",null,null,{"$f":"G990","v":0},null,{"$f":"I990","v":0},null,{"$f":"K990","v":0},null,{"$f":"M990","v":0},null,{"$f":"O990","v":0},null,{"$f":"Q990","v":0},null,{"$f":"S990","v":0},null,{"$f":"U990","v":0},null,{"$f":"W990","v":0},null,{"$f":"Y990","v":0},null,{"$f":"AA990","v":0},null,{"$f":"AC990","v":0}]
[null,"Other facturations"]
["V.1","Contractual services                                                             (ad hoc)",null,{"$f":"SUM(H35,J35,L35,N35,P35,R35,T35,V35,X35,Z35,AB35,AD35)","v":0},"(i)",null,null,{"$f":"G35","v":0},null,{"$f":"I35","v":0},null,{"$f":"K35","v":0},null,{"$f":"M35","v":0},null,{"$f":"O35","v":0},null,{"$f":"Q35","v":0},null,{"$f":"S35","v":0},null,{"$f":"U35","v":0},null,{"$f":"W35","v":0},null,{"$f":"Y35","v":0},null,{"$f":"AA35","v":0},null,{"$f":"AC35","v":0}]
["-","Correction",null,{"$f":"SUM(H36,J36,L36,N36,P36,R36,T36,V36,X36,Z36,AB36,AD36)","v":0},"(j)",null,null,{"$f":"G36","v":0},null,{"$f":"I36","v":0},null,{"$f":"K36","v":0},null,{"$f":"M36","v":0},null,{"$f":"O36","v":0},null,{"$f":"Q36","v":0},null,{"$f":"S36","v":0},null,{"$f":"U36","v":0},null,{"$f":"W36","v":0},null,{"$f":"Y36","v":0},null,{"$f":"AA36","v":0},null,{"$f":"AC36","v":0}]
[null,"S U M M A R Y     (excl VAT)"]
[null,"TOTAL 1st YEAR  (a + b + e + f + i + j)",null,{"$f":"D5+D11+D25+D31+D35+D36","v":0},"(A)",{"$f":"F5","v":0},null,{"$f":"H11+H25+H31+H35+H36","v":0},null,{"$f":"J11+J25+J31+J35+J36","v":0},null,{"$f":"L11+L25+L31+L35+L36","v":0},null,{"$f":"N11+N25+N31+N35+N36","v":0},null,{"$f":"P11+P25+P31+P35+P36","v":0},null,{"$f":"R11+R25+R31+R35+R36","v":0},null,{"$f":"T11+T25+T31+T35+T36","v":0},null,{"$f":"V11+V25+V31+V35+V36","v":0},null,{"$f":"X11+X25+X31+X35+X36","v":0},null,{"$f":"Z11+Z25+Z31+Z35+Z36","v":0},null,{"$f":"AB11+AB25+AB31+AB35+AB36","v":0},null,{"$f":"AD11+AD25+AD31+AD35+AD36","v":0}]
[null,"TOTAL FOR A COMPLETE YEAR > 1 YEAR ",null,{"$f":"SUM(H39,J39,L39,N39,P39,R39,T39,V39,X39,Z39,AB39,AD39)","v":0},null,null,null,{"$f":"IF(G986>1,(G989+H25),0)","v":0},null,{"$f":"IF(I986>1,(I989+J25),0)","v":0},null,{"$f":"IF(K986>1,(K989+L25),0)","v":0},null,{"$f":"IF(M986>1,(M989+N25),0)","v":0},null,{"$f":"IF(O986>1,(O989+P25),0)","v":0},null,{"$f":"IF(Q986>1,(Q989+R25),0)","v":0},null,{"$f":"IF(S986>1,(S989+T25),0)","v":0},null,{"$f":"IF(U986>1,(U989+V25),0)","v":0},null,{"$f":"IF(W986>1,(W989+X25),0)","v":0},null,{"$f":"IF(Y986>1,(Y989+Z25),0)","v":0},null,{"$f":"IF(AA986>1,(AA989+AB25),0)","v":0},null,{"$f":"IF(AC986>1,(AC989+AD25),0)","v":0}]
[null,"TOTAL FOLLOW. YEARS + MATURITY ((e * period > 1 year) + (g * number of years  > 1 year) + h) + (c)",null,{"$f":"SUM(H40,J40,L40,N40,P40,R40,T40,V40,X40,Z40,AB40,AD40)","v":0},"(B)",null,null,{"$f":"IF(G984-365>0,ROUND(((((G984-365)/365)*H25)+(((G984-365)/365)*G987))+H12,2),H12)","v":0},null,{"$f":"IF(I984-365>0,ROUND(((((I984-365)/365)*J25)+(((I984-365)/365)*I987))+J12,2),J12)","v":0},null,{"$f":"IF(K984-365>0,ROUND(((((K984-365)/365)*L25)+(((K984-365)/365)*K987))+L12,2),L12)","v":0},null,{"$f":"IF(M984-365>0,ROUND(((((M984-365)/365)*N25)+(((M984-365)/365)*M987))+N12,2),N12)","v":0},null,{"$f":"IF(O984-365>0,ROUND(((((O984-365)/365)*P25)+(((O984-365)/365)*O987))+P12,2),P12)","v":0},null,{"$f":"IF(Q984-365>0,ROUND(((((Q984-365)/365)*R25)+(((Q984-365)/365)*Q987))+R12,2),R12)","v":0},null,{"$f":"IF(S984-365>0,ROUND(((((S984-365)/365)*T25)+(((S984-365)/365)*S987))+T12,2),T12)","v":0},null,{"$f":"IF(U984-365>0,ROUND(((((U984-365)/365)*V25)+(((U984-365)/365)*U987))+V12,2),V12)","v":0},null,{"$f":"IF(W984-365>0,ROUND(((((W984-365)/365)*X25)+(((W984-365)/365)*W987))+X12,2),X12)","v":0},null,{"$f":"IF(Y984-365>0,ROUND(((((Y984-365)/365)*Z25)+(((Y984-365)/365)*Y987))+Z12,2),Z12)","v":0},null,{"$f":"IF(AA984-365>0,ROUND(((((AA984-365)/365)*AB25)+(((AA984-365)/365)*AA987))+AB12,2),AB12)","v":0},null,{"$f":"IF(AC984-365>0,ROUND(((((AC984-365)/365)*AD25)+(((AC984-365)/365)*AC987))+AD12,2),AD12)","v":0}]
[null,"TOTAL INTERVENTIONS WITHOUT AUTOMATIC STANDARD PROCEDURES (c)",null,{"$f":"D16","v":0},"(C)",null,null,{"$f":"H16","v":0},null,{"$f":"J16","v":0},null,{"$f":"L16","v":0},null,{"$f":"N16","v":0},null,{"$f":"P16","v":0},null,{"$f":"R16","v":0},null,{"$f":"T16","v":0},null,{"$f":"V16","v":0},null,{"$f":"X16","v":0},null,{"$f":"Z16","v":0},null,{"$f":"AB16","v":0},null,{"$f":"AD16","v":0}]
[null,"TOTAL AMOUNT FOR THE PROGRAM (A + B + C)",null,{"$f":"D38+D40+D41","v":0},null,{"$f":"F5","v":0},null,{"$f":"H38+H40+H41","v":0},null,{"$f":"J38+J40+J41","v":0},null,{"$f":"L38+L40+L41","v":0},null,{"$f":"N38+N40+N41","v":0},null,{"$f":"P38+P40+P41","v":0},null,{"$f":"R38+R40+R41","v":0},null,{"$f":"T38+T40+T41","v":0},null,{"$f":"V38+V40+V41","v":0},null,{"$f":"X38+X40+X41","v":0},null,{"$f":"Z38+Z40+Z41","v":0},null,{"$f":"AB38+AB40+AB41","v":0},null,{"$f":"AD38+AD40+AD41","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," ISIN 1",null," ISIN 2",null," ISIN 3",null," ISIN 4",null," ISIN 5",null," ISIN 6",null," ISIN 7",null," ISIN 8",null," ISIN 9",null," ISIN 10",null," ISIN 11",null," ISIN 12"]
[null,null,null,null,984,"jours base 365",{"$f":"IF(AND(G28<40968,G29<40968),G985,IF(AND(G28<40968,G29<51195),H988,IF(AND(G28<40968,G29>=51195),H989,IF(AND(G28>=40968,G29<51195),H991,IF(AND(G28>=40968,G29>=51195),H992)))))","v":0},null,{"$f":"IF(AND(I28<40968,I29<40968),I985,IF(AND(I28<40968,I29<51195),J988,IF(AND(I28<40968,I29>=51195),J989,IF(AND(I28>=40968,I29<51195),J991,IF(AND(I28>=40968,I29>=51195),J992)))))","v":0},null,{"$f":"IF(AND(K28<40968,K29<40968),K985,IF(AND(K28<40968,K29<51195),L988,IF(AND(K28<40968,K29>=51195),L989,IF(AND(K28>=40968,K29<51195),L991,IF(AND(K28>=40968,K29>=51195),L992)))))","v":0},null,{"$f":"IF(AND(M28<40968,M29<40968),M985,IF(AND(M28<40968,M29<51195),N988,IF(AND(M28<40968,M29>=51195),N989,IF(AND(M28>=40968,M29<51195),N991,IF(AND(M28>=40968,M29>=51195),N992)))))","v":0},null,{"$f":"IF(AND(O28<40968,O29<40968),O985,IF(AND(O28<40968,O29<51195),P988,IF(AND(O28<40968,O29>=51195),P989,IF(AND(O28>=40968,O29<51195),P991,IF(AND(O28>=40968,O29>=51195),P992)))))","v":0},null,{"$f":"IF(AND(Q28<40968,Q29<40968),Q985,IF(AND(Q28<40968,Q29<51195),R988,IF(AND(Q28<40968,Q29>=51195),R989,IF(AND(Q28>=40968,Q29<51195),R991,IF(AND(Q28>=40968,Q29>=51195),R992)))))","v":0},null,{"$f":"IF(AND(S28<40968,S29<40968),S985,IF(AND(S28<40968,S29<51195),T988,IF(AND(S28<40968,S29>=51195),T989,IF(AND(S28>=40968,S29<51195),T991,IF(AND(S28>=40968,S29>=51195),T992)))))","v":0},null,{"$f":"IF(AND(U28<40968,U29<40968),U985,IF(AND(U28<40968,U29<51195),V988,IF(AND(U28<40968,U29>=51195),V989,IF(AND(U28>=40968,U29<51195),V991,IF(AND(U28>=40968,U29>=51195),V992)))))","v":0},null,{"$f":"IF(AND(W28<40968,W29<40968),W985,IF(AND(W28<40968,W29<51195),X988,IF(AND(W28<40968,W29>=51195),X989,IF(AND(W28>=40968,W29<51195),X991,IF(AND(W28>=40968,W29>=51195),X992)))))","v":0},null,{"$f":"IF(AND(Y28<40968,Y29<40968),Y985,IF(AND(Y28<40968,Y29<51195),Z988,IF(AND(Y28<40968,Y29>=51195),Z989,IF(AND(Y28>=40968,Y29<51195),Z991,IF(AND(Y28>=40968,Y29>=51195),Z992)))))","v":0},null,{"$f":"IF(AND(AA28<40968,AA29<40968),AA985,IF(AND(AA28<40968,AA29<51195),AB988,IF(AND(AA28<40968,AA29>=51195),AB989,IF(AND(AA28>=40968,AA29<51195),AB991,IF(AND(AA28>=40968,AA29>=51195),AB992)))))","v":0},null,{"$f":"IF(AND(AC28<40968,AC29<40968),AC985,IF(AND(AC28<40968,AC29<51195),AD988,IF(AND(AC28<40968,AC29>=51195),AD989,IF(AND(AC28>=40968,AC29<51195),AD991,IF(AND(AC28>=40968,AC29>=51195),AD992)))))","v":0}]
[null,null,null,null,985,"nbre jours réels",{"$f":"G29-G28","v":0},null,{"$f":"I29-I28","v":0},null,{"$f":"K29-K28","v":0},null,{"$f":"M29-M28","v":0},null,{"$f":"O29-O28","v":0},null,{"$f":"Q29-Q28","v":0},null,{"$f":"S29-S28","v":0},null,{"$f":"U29-U28","v":0},null,{"$f":"W29-W28","v":0},null,{"$f":"Y29-Y28","v":0},null,{"$f":"AA29-AA28","v":0},null,{"$f":"AC29-AC28","v":0}]
[null,null,null,null,986,"nbre années",{"$f":"IF(AND(G28<40968,G29<51195),ROUNDDOWN(H988/365,0),IF(AND(G28<40968,G29>=51195),ROUNDDOWN(H989/365,0),IF(AND(G28>=40968,G29<51195),ROUNDDOWN(H991/365,0),IF(AND(G28>=40968,G29>=51195),ROUNDDOWN(H992/365,0)))))","v":0},"année bissextile",{"$f":"IF(AND(I28<40968,I29<51195),ROUNDDOWN(J988/365,0),IF(AND(I28<40968,I29>=51195),ROUNDDOWN(J989/365,0),IF(AND(I28>=40968,I29<51195),ROUNDDOWN(J991/365,0),IF(AND(I28>=40968,I29>=51195),ROUNDDOWN(J992/365,0)))))","v":0},"année bissextile",{"$f":"IF(AND(K28<40968,K29<51195),ROUNDDOWN(L988/365,0),IF(AND(K28<40968,K29>=51195),ROUNDDOWN(L989/365,0),IF(AND(K28>=40968,K29<51195),ROUNDDOWN(L991/365,0),IF(AND(K28>=40968,K29>=51195),ROUNDDOWN(L992/365,0)))))","v":0},"année bissextile",{"$f":"IF(AND(M28<40968,M29<51195),ROUNDDOWN(N988/365,0),IF(AND(M28<40968,M29>=51195),ROUNDDOWN(N989/365,0),IF(AND(M28>=40968,M29<51195),ROUNDDOWN(N991/365,0),IF(AND(M28>=40968,M29>=51195),ROUNDDOWN(N992/365,0)))))","v":0},"année bissextile",{"$f":"IF(AND(O28<40968,O29<51195),ROUNDDOWN(P988/365,0),IF(AND(O28<40968,O29>=51195),ROUNDDOWN(P989/365,0),IF(AND(O28>=40968,O29<51195),ROUNDDOWN(P991/365,0),IF(AND(O28>=40968,O29>=51195),ROUNDDOWN(P992/365,0)))))","v":0},"année bissextile",{"$f":"IF(AND(Q28<40968,Q29<51195),ROUNDDOWN(R988/365,0),IF(AND(Q28<40968,Q29>=51195),ROUNDDOWN(R989/365,0),IF(AND(Q28>=40968,Q29<51195),ROUNDDOWN(R991/365,0),IF(AND(Q28>=40968,Q29>=51195),ROUNDDOWN(R992/365,0)))))","v":0},"année bissextile",{"$f":"IF(AND(S28<40968,S29<51195),ROUNDDOWN(T988/365,0),IF(AND(S28<40968,S29>=51195),ROUNDDOWN(T989/365,0),IF(AND(S28>=40968,S29<51195),ROUNDDOWN(T991/365,0),IF(AND(S28>=40968,S29>=51195),ROUNDDOWN(T992/365,0)))))","v":0},"année bissextile",{"$f":"IF(AND(U28<40968,U29<51195),ROUNDDOWN(V988/365,0),IF(AND(U28<40968,U29>=51195),ROUNDDOWN(V989/365,0),IF(AND(U28>=40968,U29<51195),ROUNDDOWN(V991/365,0),IF(AND(U28>=40968,U29>=51195),ROUNDDOWN(V992/365,0)))))","v":0},"année bissextile",{"$f":"IF(AND(W28<40968,W29<51195),ROUNDDOWN(X988/365,0),IF(AND(W28<40968,W29>=51195),ROUNDDOWN(X989/365,0),IF(AND(W28>=40968,W29<51195),ROUNDDOWN(X991/365,0),IF(AND(W28>=40968,W29>=51195),ROUNDDOWN(X992/365,0)))))","v":0},"année bissextile",{"$f":"IF(AND(Y28<40968,Y29<51195),ROUNDDOWN(Z988/365,0),IF(AND(Y28<40968,Y29>=51195),ROUNDDOWN(Z989/365,0),IF(AND(Y28>=40968,Y29<51195),ROUNDDOWN(Z991/365,0),IF(AND(Y28>=40968,Y29>=51195),ROUNDDOWN(Z992/365,0)))))","v":0},"année bissextile",{"$f":"IF(AND(AA28<40968,AA29<51195),ROUNDDOWN(AB988/365,0),IF(AND(AA28<40968,AA29>=51195),ROUNDDOWN(AB989/365,0),IF(AND(AA28>=40968,AA29<51195),ROUNDDOWN(AB991/365,0),IF(AND(AA28>=40968,AA29>=51195),ROUNDDOWN(AB992/365,0)))))","v":0},"année bissextile",{"$f":"IF(AND(AC28<40968,AC29<51195),ROUNDDOWN(AD988/365,0),IF(AND(AC28<40968,AC29>=51195),ROUNDDOWN(AD989/365,0),IF(AND(AC28>=40968,AC29<51195),ROUNDDOWN(AD991/365,0),IF(AND(AC28>=40968,AC29>=51195),ROUNDDOWN(AD992/365,0)))))","v":0},"année bissextile"]
[null,null,null,null,987,"calcul plafond",{"$f":"IF(G27<=500000000,G27*0.000005,IF(AND(G27>500000000,G27<=1000000000),2500,IF(AND(G27>1000000000,G27<=2000000000),3000,IF(AND(G27>2000000000,G27<=3000000000),3500,IF(AND(G27>3000000000,G27<=5000000000),4000,IF(AND(G27>5000000000,G27<=10000000000),5000,IF(G27>10000000000,7000)))))))","v":0},"set < 29/02/12",{"$f":"IF(I27<=500000000,I27*0.000005,IF(AND(I27>500000000,I27<=1000000000),2500,IF(AND(I27>1000000000,I27<=2000000000),3000,IF(AND(I27>2000000000,I27<=3000000000),3500,IF(AND(I27>3000000000,I27<=5000000000),4000,IF(AND(I27>5000000000,I27<=10000000000),5000,IF(I27>10000000000,7000)))))))","v":0},"set < 29/02/12",{"$f":"IF(K27<=500000000,K27*0.000005,IF(AND(K27>500000000,K27<=1000000000),2500,IF(AND(K27>1000000000,K27<=2000000000),3000,IF(AND(K27>2000000000,K27<=3000000000),3500,IF(AND(K27>3000000000,K27<=5000000000),4000,IF(AND(K27>5000000000,K27<=10000000000),5000,IF(K27>10000000000,7000)))))))","v":0},"set < 29/02/12",{"$f":"IF(M27<=500000000,M27*0.000005,IF(AND(M27>500000000,M27<=1000000000),2500,IF(AND(M27>1000000000,M27<=2000000000),3000,IF(AND(M27>2000000000,M27<=3000000000),3500,IF(AND(M27>3000000000,M27<=5000000000),4000,IF(AND(M27>5000000000,M27<=10000000000),5000,IF(M27>10000000000,7000)))))))","v":0},"set < 29/02/12",{"$f":"IF(O27<=500000000,O27*0.000005,IF(AND(O27>500000000,O27<=1000000000),2500,IF(AND(O27>1000000000,O27<=2000000000),3000,IF(AND(O27>2000000000,O27<=3000000000),3500,IF(AND(O27>3000000000,O27<=5000000000),4000,IF(AND(O27>5000000000,O27<=10000000000),5000,IF(O27>10000000000,7000)))))))","v":0},"set < 29/02/12",{"$f":"IF(Q27<=500000000,Q27*0.000005,IF(AND(Q27>500000000,Q27<=1000000000),2500,IF(AND(Q27>1000000000,Q27<=2000000000),3000,IF(AND(Q27>2000000000,Q27<=3000000000),3500,IF(AND(Q27>3000000000,Q27<=5000000000),4000,IF(AND(Q27>5000000000,Q27<=10000000000),5000,IF(Q27>10000000000,7000)))))))","v":0},"set < 29/02/12",{"$f":"IF(S27<=500000000,S27*0.000005,IF(AND(S27>500000000,S27<=1000000000),2500,IF(AND(S27>1000000000,S27<=2000000000),3000,IF(AND(S27>2000000000,S27<=3000000000),3500,IF(AND(S27>3000000000,S27<=5000000000),4000,IF(AND(S27>5000000000,S27<=10000000000),5000,IF(S27>10000000000,7000)))))))","v":0},"set < 29/02/12",{"$f":"IF(U27<=500000000,U27*0.000005,IF(AND(U27>500000000,U27<=1000000000),2500,IF(AND(U27>1000000000,U27<=2000000000),3000,IF(AND(U27>2000000000,U27<=3000000000),3500,IF(AND(U27>3000000000,U27<=5000000000),4000,IF(AND(U27>5000000000,U27<=10000000000),5000,IF(U27>10000000000,7000)))))))","v":0},"set < 29/02/12",{"$f":"IF(W27<=500000000,W27*0.000005,IF(AND(W27>500000000,W27<=1000000000),2500,IF(AND(W27>1000000000,W27<=2000000000),3000,IF(AND(W27>2000000000,W27<=3000000000),3500,IF(AND(W27>3000000000,W27<=5000000000),4000,IF(AND(W27>5000000000,W27<=10000000000),5000,IF(W27>10000000000,7000)))))))","v":0},"set < 29/02/12",{"$f":"IF(Y27<=500000000,Y27*0.000005,IF(AND(Y27>500000000,Y27<=1000000000),2500,IF(AND(Y27>1000000000,Y27<=2000000000),3000,IF(AND(Y27>2000000000,Y27<=3000000000),3500,IF(AND(Y27>3000000000,Y27<=5000000000),4000,IF(AND(Y27>5000000000,Y27<=10000000000),5000,IF(Y27>10000000000,7000)))))))","v":0},"set < 29/02/12",{"$f":"IF(AA27<=500000000,AA27*0.000005,IF(AND(AA27>500000000,AA27<=1000000000),2500,IF(AND(AA27>1000000000,AA27<=2000000000),3000,IF(AND(AA27>2000000000,AA27<=3000000000),3500,IF(AND(AA27>3000000000,AA27<=5000000000),4000,IF(AND(AA27>5000000000,AA27<=10000000000),5000,IF(AA27>10000000000,7000)))))))","v":0},"set < 29/02/12",{"$f":"IF(AC27<=500000000,AC27*0.000005,IF(AND(AC27>500000000,AC27<=1000000000),2500,IF(AND(AC27>1000000000,AC27<=2000000000),3000,IF(AND(AC27>2000000000,AC27<=3000000000),3500,IF(AND(AC27>3000000000,AC27<=5000000000),4000,IF(AND(AC27>5000000000,AC27<=10000000000),5000,IF(AC27>10000000000,7000)))))))","v":0},"set < 29/02/12"]
[null,null,null,null,988,"sans plafond",{"$f":"IF(OR(G28<1,G29<1),0,IF(G986>=1,G27*0.000005,G27*G984*0.000005/365))","v":0},{"$f":"IF(G29<42429,G985-1,IF(AND(G29>=42429,G29<43890),G985-2,IF(AND(G29>=43890,G29<45351),G985-3,IF(AND(G29>=45351,G29<46812),G985-4,IF(AND(G29>=46812,G29<48273),G985-5,IF(AND(G29>=48273,G29<49734),G985-6,IF(AND(G29>=49734,G29<51195),G985-7)))))))","v":-1},{"$f":"IF(OR(I28<1,I29<1),0,IF(I986>=1,I27*0.000005,I27*I984*0.000005/365))","v":0},{"$f":"IF(I29<42429,I985-1,IF(AND(I29>=42429,I29<43890),I985-2,IF(AND(I29>=43890,I29<45351),I985-3,IF(AND(I29>=45351,I29<46812),I985-4,IF(AND(I29>=46812,I29<48273),I985-5,IF(AND(I29>=48273,I29<49734),I985-6,IF(AND(I29>=49734,I29<51195),I985-7)))))))","v":-1},{"$f":"IF(OR(K28<1,K29<1),0,IF(K986>=1,K27*0.000005,K27*K984*0.000005/365))","v":0},{"$f":"IF(K29<42429,K985-1,IF(AND(K29>=42429,K29<43890),K985-2,IF(AND(K29>=43890,K29<45351),K985-3,IF(AND(K29>=45351,K29<46812),K985-4,IF(AND(K29>=46812,K29<48273),K985-5,IF(AND(K29>=48273,K29<49734),K985-6,IF(AND(K29>=49734,K29<51195),K985-7)))))))","v":-1},{"$f":"IF(OR(M28<1,M29<1),0,IF(M986>=1,M27*0.000005,M27*M984*0.000005/365))","v":0},{"$f":"IF(M29<42429,M985-1,IF(AND(M29>=42429,M29<43890),M985-2,IF(AND(M29>=43890,M29<45351),M985-3,IF(AND(M29>=45351,M29<46812),M985-4,IF(AND(M29>=46812,M29<48273),M985-5,IF(AND(M29>=48273,M29<49734),M985-6,IF(AND(M29>=49734,M29<51195),M985-7)))))))","v":-1},{"$f":"IF(OR(O28<1,O29<1),0,IF(O986>=1,O27*0.000005,O27*O984*0.000005/365))","v":0},{"$f":"IF(O29<42429,O985-1,IF(AND(O29>=42429,O29<43890),O985-2,IF(AND(O29>=43890,O29<45351),O985-3,IF(AND(O29>=45351,O29<46812),O985-4,IF(AND(O29>=46812,O29<48273),O985-5,IF(AND(O29>=48273,O29<49734),O985-6,IF(AND(O29>=49734,O29<51195),O985-7)))))))","v":-1},{"$f":"IF(OR(Q28<1,Q29<1),0,IF(Q986>=1,Q27*0.000005,Q27*Q984*0.000005/365))","v":0},{"$f":"IF(Q29<42429,Q985-1,IF(AND(Q29>=42429,Q29<43890),Q985-2,IF(AND(Q29>=43890,Q29<45351),Q985-3,IF(AND(Q29>=45351,Q29<46812),Q985-4,IF(AND(Q29>=46812,Q29<48273),Q985-5,IF(AND(Q29>=48273,Q29<49734),Q985-6,IF(AND(Q29>=49734,Q29<51195),Q985-7)))))))","v":-1},{"$f":"IF(OR(S28<1,S29<1),0,IF(S986>=1,S27*0.000005,S27*S984*0.000005/365))","v":0},{"$f":"IF(S29<42429,S985-1,IF(AND(S29>=42429,S29<43890),S985-2,IF(AND(S29>=43890,S29<45351),S985-3,IF(AND(S29>=45351,S29<46812),S985-4,IF(AND(S29>=46812,S29<48273),S985-5,IF(AND(S29>=48273,S29<49734),S985-6,IF(AND(S29>=49734,S29<51195),S985-7)))))))","v":-1},{"$f":"IF(OR(U28<1,U29<1),0,IF(U986>=1,U27*0.000005,U27*U984*0.000005/365))","v":0},{"$f":"IF(U29<42429,U985-1,IF(AND(U29>=42429,U29<43890),U985-2,IF(AND(U29>=43890,U29<45351),U985-3,IF(AND(U29>=45351,U29<46812),U985-4,IF(AND(U29>=46812,U29<48273),U985-5,IF(AND(U29>=48273,U29<49734),U985-6,IF(AND(U29>=49734,U29<51195),U985-7)))))))","v":-1},{"$f":"IF(OR(W28<1,W29<1),0,IF(W986>=1,W27*0.000005,W27*W984*0.000005/365))","v":0},{"$f":"IF(W29<42429,W985-1,IF(AND(W29>=42429,W29<43890),W985-2,IF(AND(W29>=43890,W29<45351),W985-3,IF(AND(W29>=45351,W29<46812),W985-4,IF(AND(W29>=46812,W29<48273),W985-5,IF(AND(W29>=48273,W29<49734),W985-6,IF(AND(W29>=49734,W29<51195),W985-7)))))))","v":-1},{"$f":"IF(OR(Y28<1,Y29<1),0,IF(Y986>=1,Y27*0.000005,Y27*Y984*0.000005/365))","v":0},{"$f":"IF(Y29<42429,Y985-1,IF(AND(Y29>=42429,Y29<43890),Y985-2,IF(AND(Y29>=43890,Y29<45351),Y985-3,IF(AND(Y29>=45351,Y29<46812),Y985-4,IF(AND(Y29>=46812,Y29<48273),Y985-5,IF(AND(Y29>=48273,Y29<49734),Y985-6,IF(AND(Y29>=49734,Y29<51195),Y985-7)))))))","v":-1},{"$f":"IF(OR(AA28<1,AA29<1),0,IF(AA986>=1,AA27*0.000005,AA27*AA984*0.000005/365))","v":0},{"$f":"IF(AA29<42429,AA985-1,IF(AND(AA29>=42429,AA29<43890),AA985-2,IF(AND(AA29>=43890,AA29<45351),AA985-3,IF(AND(AA29>=45351,AA29<46812),AA985-4,IF(AND(AA29>=46812,AA29<48273),AA985-5,IF(AND(AA29>=48273,AA29<49734),AA985-6,IF(AND(AA29>=49734,AA29<51195),AA985-7)))))))","v":-1},{"$f":"IF(OR(AC28<1,AC29<1),0,IF(AC986>=1,AC27*0.000005,AC27*AC984*0.000005/365))","v":0},{"$f":"IF(AC29<42429,AC985-1,IF(AND(AC29>=42429,AC29<43890),AC985-2,IF(AND(AC29>=43890,AC29<45351),AC985-3,IF(AND(AC29>=45351,AC29<46812),AC985-4,IF(AND(AC29>=46812,AC29<48273),AC985-5,IF(AND(AC29>=48273,AC29<49734),AC985-6,IF(AND(AC29>=49734,AC29<51195),AC985-7)))))))","v":-1}]
[null,null,null,null,989,"1 année complète",{"$f":"IF(OR(G28<1,G29<1),0,IF(G986>=1,G987,0))","v":0},{"$f":"IF(AND(G29>=51195,G29<52656),G985-8,IF(AND(G29>=52656,G29<54117),G985-9,IF(AND(G29>=54117,G29<55578),G985-10,IF(AND(G29>=55578,G29<57039),G985-11,IF(AND(G29>=57039,G29<58500),G985-12,IF(AND(G29>=58500,G29<59961),G985-13))))))","v":false},{"$f":"IF(OR(I28<1,I29<1),0,IF(I986>=1,I987,0))","v":0},{"$f":"IF(AND(I29>=51195,I29<52656),I985-8,IF(AND(I29>=52656,I29<54117),I985-9,IF(AND(I29>=54117,I29<55578),I985-10,IF(AND(I29>=55578,I29<57039),I985-11,IF(AND(I29>=57039,I29<58500),I985-12,IF(AND(I29>=58500,I29<59961),I985-13))))))","v":false},{"$f":"IF(OR(K28<1,K29<1),0,IF(K986>=1,K987,0))","v":0},{"$f":"IF(AND(K29>=51195,K29<52656),K985-8,IF(AND(K29>=52656,K29<54117),K985-9,IF(AND(K29>=54117,K29<55578),K985-10,IF(AND(K29>=55578,K29<57039),K985-11,IF(AND(K29>=57039,K29<58500),K985-12,IF(AND(K29>=58500,K29<59961),K985-13))))))","v":false},{"$f":"IF(OR(M28<1,M29<1),0,IF(M986>=1,M987,0))","v":0},{"$f":"IF(AND(M29>=51195,M29<52656),M985-8,IF(AND(M29>=52656,M29<54117),M985-9,IF(AND(M29>=54117,M29<55578),M985-10,IF(AND(M29>=55578,M29<57039),M985-11,IF(AND(M29>=57039,M29<58500),M985-12,IF(AND(M29>=58500,M29<59961),M985-13))))))","v":false},{"$f":"IF(OR(O28<1,O29<1),0,IF(O986>=1,O987,0))","v":0},{"$f":"IF(AND(O29>=51195,O29<52656),O985-8,IF(AND(O29>=52656,O29<54117),O985-9,IF(AND(O29>=54117,O29<55578),O985-10,IF(AND(O29>=55578,O29<57039),O985-11,IF(AND(O29>=57039,O29<58500),O985-12,IF(AND(O29>=58500,O29<59961),O985-13))))))","v":false},{"$f":"IF(OR(Q28<1,Q29<1),0,IF(Q986>=1,Q987,0))","v":0},{"$f":"IF(AND(Q29>=51195,Q29<52656),Q985-8,IF(AND(Q29>=52656,Q29<54117),Q985-9,IF(AND(Q29>=54117,Q29<55578),Q985-10,IF(AND(Q29>=55578,Q29<57039),Q985-11,IF(AND(Q29>=57039,Q29<58500),Q985-12,IF(AND(Q29>=58500,Q29<59961),Q985-13))))))","v":false},{"$f":"IF(OR(S28<1,S29<1),0,IF(S986>=1,S987,0))","v":0},{"$f":"IF(AND(S29>=51195,S29<52656),S985-8,IF(AND(S29>=52656,S29<54117),S985-9,IF(AND(S29>=54117,S29<55578),S985-10,IF(AND(S29>=55578,S29<57039),S985-11,IF(AND(S29>=57039,S29<58500),S985-12,IF(AND(S29>=58500,S29<59961),S985-13))))))","v":false},{"$f":"IF(OR(U28<1,U29<1),0,IF(U986>=1,U987,0))","v":0},{"$f":"IF(AND(U29>=51195,U29<52656),U985-8,IF(AND(U29>=52656,U29<54117),U985-9,IF(AND(U29>=54117,U29<55578),U985-10,IF(AND(U29>=55578,U29<57039),U985-11,IF(AND(U29>=57039,U29<58500),U985-12,IF(AND(U29>=58500,U29<59961),U985-13))))))","v":false},{"$f":"IF(OR(W28<1,W29<1),0,IF(W986>=1,W987,0))","v":0},{"$f":"IF(AND(W29>=51195,W29<52656),W985-8,IF(AND(W29>=52656,W29<54117),W985-9,IF(AND(W29>=54117,W29<55578),W985-10,IF(AND(W29>=55578,W29<57039),W985-11,IF(AND(W29>=57039,W29<58500),W985-12,IF(AND(W29>=58500,W29<59961),W985-13))))))","v":false},{"$f":"IF(OR(Y28<1,Y29<1),0,IF(Y986>=1,Y987,0))","v":0},{"$f":"IF(AND(Y29>=51195,Y29<52656),Y985-8,IF(AND(Y29>=52656,Y29<54117),Y985-9,IF(AND(Y29>=54117,Y29<55578),Y985-10,IF(AND(Y29>=55578,Y29<57039),Y985-11,IF(AND(Y29>=57039,Y29<58500),Y985-12,IF(AND(Y29>=58500,Y29<59961),Y985-13))))))","v":false},{"$f":"IF(OR(AA28<1,AA29<1),0,IF(AA986>=1,AA987,0))","v":0},{"$f":"IF(AND(AA29>=51195,AA29<52656),AA985-8,IF(AND(AA29>=52656,AA29<54117),AA985-9,IF(AND(AA29>=54117,AA29<55578),AA985-10,IF(AND(AA29>=55578,AA29<57039),AA985-11,IF(AND(AA29>=57039,AA29<58500),AA985-12,IF(AND(AA29>=58500,AA29<59961),AA985-13))))))","v":false},{"$f":"IF(OR(AC28<1,AC29<1),0,IF(AC986>=1,AC987,0))","v":0},{"$f":"IF(AND(AC29>=51195,AC29<52656),AC985-8,IF(AND(AC29>=52656,AC29<54117),AC985-9,IF(AND(AC29>=54117,AC29<55578),AC985-10,IF(AND(AC29>=55578,AC29<57039),AC985-11,IF(AND(AC29>=57039,AC29<58500),AC985-12,IF(AND(AC29>=58500,AC29<59961),AC985-13))))))","v":false}]
[null,null,null,null,990,"fraction > 1 an",{"$f":"IF(OR(G28<1,G29<1),0,IF(AND(G986>0,G28<40968,G29<51195),(H988-(G986*365))*G987/365,IF(AND(G986>0,G28<40968,G29>=51195,G29<62883),(H989-(G986*365))*G987/365,IF(AND(G986>0,G28>=40968,G29<51195),(H991-(G986*365))*G987/365,IF(AND(G986>0,G28>=40968,G29>=51195,G29<62883),(H992-(G986*365))*G987/365,0)))))","v":0},"set >= 29/02/12",{"$f":"IF(OR(I28<1,I29<1),0,IF(AND(I986>0,I28<40968,I29<51195),(J988-(I986*365))*I987/365,IF(AND(I986>0,I28<40968,I29>=51195,I29<62883),(J989-(I986*365))*I987/365,IF(AND(I986>0,I28>=40968,I29<51195),(J991-(I986*365))*I987/365,IF(AND(I986>0,I28>=40968,I29>=51195,I29<62883),(J992-(I986*365))*I987/365,0)))))","v":0},"set >= 29/02/12",{"$f":"IF(OR(K28<1,K29<1),0,IF(AND(K986>0,K28<40968,K29<51195),(L988-(K986*365))*K987/365,IF(AND(K986>0,K28<40968,K29>=51195,K29<62883),(L989-(K986*365))*K987/365,IF(AND(K986>0,K28>=40968,K29<51195),(L991-(K986*365))*K987/365,IF(AND(K986>0,K28>=40968,K29>=51195,K29<62883),(L992-(K986*365))*K987/365,0)))))","v":0},"set >= 29/02/12",{"$f":"IF(OR(M28<1,M29<1),0,IF(AND(M986>0,M28<40968,M29<51195),(N988-(M986*365))*M987/365,IF(AND(M986>0,M28<40968,M29>=51195,M29<62883),(N989-(M986*365))*M987/365,IF(AND(M986>0,M28>=40968,M29<51195),(N991-(M986*365))*M987/365,IF(AND(M986>0,M28>=40968,M29>=51195,M29<62883),(N992-(M986*365))*M987/365,0)))))","v":0},"set >= 29/02/12",{"$f":"IF(OR(O28<1,O29<1),0,IF(AND(O986>0,O28<40968,O29<51195),(P988-(O986*365))*O987/365,IF(AND(O986>0,O28<40968,O29>=51195,O29<62883),(P989-(O986*365))*O987/365,IF(AND(O986>0,O28>=40968,O29<51195),(P991-(O986*365))*O987/365,IF(AND(O986>0,O28>=40968,O29>=51195,O29<62883),(P992-(O986*365))*O987/365,0)))))","v":0},"set >= 29/02/12",{"$f":"IF(OR(Q28<1,Q29<1),0,IF(AND(Q986>0,Q28<40968,Q29<51195),(R988-(Q986*365))*Q987/365,IF(AND(Q986>0,Q28<40968,Q29>=51195,Q29<62883),(R989-(Q986*365))*Q987/365,IF(AND(Q986>0,Q28>=40968,Q29<51195),(R991-(Q986*365))*Q987/365,IF(AND(Q986>0,Q28>=40968,Q29>=51195,Q29<62883),(R992-(Q986*365))*Q987/365,0)))))","v":0},"set >= 29/02/12",{"$f":"IF(OR(S28<1,S29<1),0,IF(AND(S986>0,S28<40968,S29<51195),(T988-(S986*365))*S987/365,IF(AND(S986>0,S28<40968,S29>=51195,S29<62883),(T989-(S986*365))*S987/365,IF(AND(S986>0,S28>=40968,S29<51195),(T991-(S986*365))*S987/365,IF(AND(S986>0,S28>=40968,S29>=51195,S29<62883),(T992-(S986*365))*S987/365,0)))))","v":0},"set >= 29/02/12",{"$f":"IF(OR(U28<1,U29<1),0,IF(AND(U986>0,U28<40968,U29<51195),(V988-(U986*365))*U987/365,IF(AND(U986>0,U28<40968,U29>=51195,U29<62883),(V989-(U986*365))*U987/365,IF(AND(U986>0,U28>=40968,U29<51195),(V991-(U986*365))*U987/365,IF(AND(U986>0,U28>=40968,U29>=51195,U29<62883),(V992-(U986*365))*U987/365,0)))))","v":0},"set >= 29/02/12",{"$f":"IF(OR(W28<1,W29<1),0,IF(AND(W986>0,W28<40968,W29<51195),(X988-(W986*365))*W987/365,IF(AND(W986>0,W28<40968,W29>=51195,W29<62883),(X989-(W986*365))*W987/365,IF(AND(W986>0,W28>=40968,W29<51195),(X991-(W986*365))*W987/365,IF(AND(W986>0,W28>=40968,W29>=51195,W29<62883),(X992-(W986*365))*W987/365,0)))))","v":0},"set >= 29/02/12",{"$f":"IF(OR(Y28<1,Y29<1),0,IF(AND(Y986>0,Y28<40968,Y29<51195),(Z988-(Y986*365))*Y987/365,IF(AND(Y986>0,Y28<40968,Y29>=51195,Y29<62883),(Z989-(Y986*365))*Y987/365,IF(AND(Y986>0,Y28>=40968,Y29<51195),(Z991-(Y986*365))*Y987/365,IF(AND(Y986>0,Y28>=40968,Y29>=51195,Y29<62883),(Z992-(Y986*365))*Y987/365,0)))))","v":0},"set >= 29/02/12",{"$f":"IF(OR(AA28<1,AA29<1),0,IF(AND(AA986>0,AA28<40968,AA29<51195),(AB988-(AA986*365))*AA987/365,IF(AND(AA986>0,AA28<40968,AA29>=51195,AA29<62883),(AB989-(AA986*365))*AA987/365,IF(AND(AA986>0,AA28>=40968,AA29<51195),(AB991-(AA986*365))*AA987/365,IF(AND(AA986>0,AA28>=40968,AA29>=51195,AA29<62883),(AB992-(AA986*365))*AA987/365,0)))))","v":0},"set >= 29/02/12",{"$f":"IF(OR(AC28<1,AC29<1),0,IF(AND(AC986>0,AC28<40968,AC29<51195),(AD988-(AC986*365))*AC987/365,IF(AND(AC986>0,AC28<40968,AC29>=51195,AC29<62883),(AD989-(AC986*365))*AC987/365,IF(AND(AC986>0,AC28>=40968,AC29<51195),(AD991-(AC986*365))*AC987/365,IF(AND(AC986>0,AC28>=40968,AC29>=51195,AC29<62883),(AD992-(AC986*365))*AC987/365,0)))))","v":0},"set >= 29/02/12"]
[null,null,null,null,991,"1ère année",{"$f":"IF(OR(G28<1,G29<1),0,IF(G984<=365,G984*G987/365,G989))","v":0},{"$f":"IF(G29<42429,G985,IF(AND(G29>=42429,G29<43890),G985-1,IF(AND(G29>=43890,G29<45351),G985-2,IF(AND(G29>=45351,G29<46812),G985-3,IF(AND(G29>=46812,G29<48273),G985-4,IF(AND(G29>=48273,G29<49734),G985-5,IF(AND(G29>=49734,G29<51195),G985-6)))))))","v":0},{"$f":"IF(OR(I28<1,I29<1),0,IF(I984<=365,I984*I987/365,I989))","v":0},{"$f":"IF(I29<42429,I985,IF(AND(I29>=42429,I29<43890),I985-1,IF(AND(I29>=43890,I29<45351),I985-2,IF(AND(I29>=45351,I29<46812),I985-3,IF(AND(I29>=46812,I29<48273),I985-4,IF(AND(I29>=48273,I29<49734),I985-5,IF(AND(I29>=49734,I29<51195),I985-6)))))))","v":0},{"$f":"IF(OR(K28<1,K29<1),0,IF(K984<=365,K984*K987/365,K989))","v":0},{"$f":"IF(K29<42429,K985,IF(AND(K29>=42429,K29<43890),K985-1,IF(AND(K29>=43890,K29<45351),K985-2,IF(AND(K29>=45351,K29<46812),K985-3,IF(AND(K29>=46812,K29<48273),K985-4,IF(AND(K29>=48273,K29<49734),K985-5,IF(AND(K29>=49734,K29<51195),K985-6)))))))","v":0},{"$f":"IF(OR(M28<1,M29<1),0,IF(M984<=365,M984*M987/365,M989))","v":0},{"$f":"IF(M29<42429,M985,IF(AND(M29>=42429,M29<43890),M985-1,IF(AND(M29>=43890,M29<45351),M985-2,IF(AND(M29>=45351,M29<46812),M985-3,IF(AND(M29>=46812,M29<48273),M985-4,IF(AND(M29>=48273,M29<49734),M985-5,IF(AND(M29>=49734,M29<51195),M985-6)))))))","v":0},{"$f":"IF(OR(O28<1,O29<1),0,IF(O984<=365,O984*O987/365,O989))","v":0},{"$f":"IF(O29<42429,O985,IF(AND(O29>=42429,O29<43890),O985-1,IF(AND(O29>=43890,O29<45351),O985-2,IF(AND(O29>=45351,O29<46812),O985-3,IF(AND(O29>=46812,O29<48273),O985-4,IF(AND(O29>=48273,O29<49734),O985-5,IF(AND(O29>=49734,O29<51195),O985-6)))))))","v":0},{"$f":"IF(OR(Q28<1,Q29<1),0,IF(Q984<=365,Q984*Q987/365,Q989))","v":0},{"$f":"IF(Q29<42429,Q985,IF(AND(Q29>=42429,Q29<43890),Q985-1,IF(AND(Q29>=43890,Q29<45351),Q985-2,IF(AND(Q29>=45351,Q29<46812),Q985-3,IF(AND(Q29>=46812,Q29<48273),Q985-4,IF(AND(Q29>=48273,Q29<49734),Q985-5,IF(AND(Q29>=49734,Q29<51195),Q985-6)))))))","v":0},{"$f":"IF(OR(S28<1,S29<1),0,IF(S984<=365,S984*S987/365,S989))","v":0},{"$f":"IF(S29<42429,S985,IF(AND(S29>=42429,S29<43890),S985-1,IF(AND(S29>=43890,S29<45351),S985-2,IF(AND(S29>=45351,S29<46812),S985-3,IF(AND(S29>=46812,S29<48273),S985-4,IF(AND(S29>=48273,S29<49734),S985-5,IF(AND(S29>=49734,S29<51195),S985-6)))))))","v":0},{"$f":"IF(OR(U28<1,U29<1),0,IF(U984<=365,U984*U987/365,U989))","v":0},{"$f":"IF(U29<42429,U985,IF(AND(U29>=42429,U29<43890),U985-1,IF(AND(U29>=43890,U29<45351),U985-2,IF(AND(U29>=45351,U29<46812),U985-3,IF(AND(U29>=46812,U29<48273),U985-4,IF(AND(U29>=48273,U29<49734),U985-5,IF(AND(U29>=49734,U29<51195),U985-6)))))))","v":0},{"$f":"IF(OR(W28<1,W29<1),0,IF(W984<=365,W984*W987/365,W989))","v":0},{"$f":"IF(W29<42429,W985,IF(AND(W29>=42429,W29<43890),W985-1,IF(AND(W29>=43890,W29<45351),W985-2,IF(AND(W29>=45351,W29<46812),W985-3,IF(AND(W29>=46812,W29<48273),W985-4,IF(AND(W29>=48273,W29<49734),W985-5,IF(AND(W29>=49734,W29<51195),W985-6)))))))","v":0},{"$f":"IF(OR(Y28<1,Y29<1),0,IF(Y984<=365,Y984*Y987/365,Y989))","v":0},{"$f":"IF(Y29<42429,Y985,IF(AND(Y29>=42429,Y29<43890),Y985-1,IF(AND(Y29>=43890,Y29<45351),Y985-2,IF(AND(Y29>=45351,Y29<46812),Y985-3,IF(AND(Y29>=46812,Y29<48273),Y985-4,IF(AND(Y29>=48273,Y29<49734),Y985-5,IF(AND(Y29>=49734,Y29<51195),Y985-6)))))))","v":0},{"$f":"IF(OR(AA28<1,AA29<1),0,IF(AA984<=365,AA984*AA987/365,AA989))","v":0},{"$f":"IF(AA29<42429,AA985,IF(AND(AA29>=42429,AA29<43890),AA985-1,IF(AND(AA29>=43890,AA29<45351),AA985-2,IF(AND(AA29>=45351,AA29<46812),AA985-3,IF(AND(AA29>=46812,AA29<48273),AA985-4,IF(AND(AA29>=48273,AA29<49734),AA985-5,IF(AND(AA29>=49734,AA29<51195),AA985-6)))))))","v":0},{"$f":"IF(OR(AC28<1,AC29<1),0,IF(AC984<=365,AC984*AC987/365,AC989))","v":0},{"$f":"IF(AC29<42429,AC985,IF(AND(AC29>=42429,AC29<43890),AC985-1,IF(AND(AC29>=43890,AC29<45351),AC985-2,IF(AND(AC29>=45351,AC29<46812),AC985-3,IF(AND(AC29>=46812,AC29<48273),AC985-4,IF(AND(AC29>=48273,AC29<49734),AC985-5,IF(AND(AC29>=49734,AC29<51195),AC985-6)))))))","v":0}]
[null,null,null,null,null,null,false,{"$f":"IF(AND(G29>=51195,G29<52656),G985-7,IF(AND(G29>=52656,G29<54117),G985-8,IF(AND(G29>=54117,G29<55578),G985-9,IF(AND(G29>=55578,G29<57039),G985-10,IF(AND(G29>=57039,G29<58500),G985-11,IF(AND(G29>=58500,G29<59961),G985-12))))))","v":false},false,{"$f":"IF(AND(I29>=51195,I29<52656),I985-7,IF(AND(I29>=52656,I29<54117),I985-8,IF(AND(I29>=54117,I29<55578),I985-9,IF(AND(I29>=55578,I29<57039),I985-10,IF(AND(I29>=57039,I29<58500),I985-11,IF(AND(I29>=58500,I29<59961),I985-12))))))","v":false},false,{"$f":"IF(AND(K29>=51195,K29<52656),K985-7,IF(AND(K29>=52656,K29<54117),K985-8,IF(AND(K29>=54117,K29<55578),K985-9,IF(AND(K29>=55578,K29<57039),K985-10,IF(AND(K29>=57039,K29<58500),K985-11,IF(AND(K29>=58500,K29<59961),K985-12))))))","v":false},false,{"$f":"IF(AND(M29>=51195,M29<52656),M985-7,IF(AND(M29>=52656,M29<54117),M985-8,IF(AND(M29>=54117,M29<55578),M985-9,IF(AND(M29>=55578,M29<57039),M985-10,IF(AND(M29>=57039,M29<58500),M985-11,IF(AND(M29>=58500,M29<59961),M985-12))))))","v":false},false,{"$f":"IF(AND(O29>=51195,O29<52656),O985-7,IF(AND(O29>=52656,O29<54117),O985-8,IF(AND(O29>=54117,O29<55578),O985-9,IF(AND(O29>=55578,O29<57039),O985-10,IF(AND(O29>=57039,O29<58500),O985-11,IF(AND(O29>=58500,O29<59961),O985-12))))))","v":false},false,{"$f":"IF(AND(Q29>=51195,Q29<52656),Q985-7,IF(AND(Q29>=52656,Q29<54117),Q985-8,IF(AND(Q29>=54117,Q29<55578),Q985-9,IF(AND(Q29>=55578,Q29<57039),Q985-10,IF(AND(Q29>=57039,Q29<58500),Q985-11,IF(AND(Q29>=58500,Q29<59961),Q985-12))))))","v":false},false,{"$f":"IF(AND(S29>=51195,S29<52656),S985-7,IF(AND(S29>=52656,S29<54117),S985-8,IF(AND(S29>=54117,S29<55578),S985-9,IF(AND(S29>=55578,S29<57039),S985-10,IF(AND(S29>=57039,S29<58500),S985-11,IF(AND(S29>=58500,S29<59961),S985-12))))))","v":false},false,{"$f":"IF(AND(U29>=51195,U29<52656),U985-7,IF(AND(U29>=52656,U29<54117),U985-8,IF(AND(U29>=54117,U29<55578),U985-9,IF(AND(U29>=55578,U29<57039),U985-10,IF(AND(U29>=57039,U29<58500),U985-11,IF(AND(U29>=58500,U29<59961),U985-12))))))","v":false},false,{"$f":"IF(AND(W29>=51195,W29<52656),W985-7,IF(AND(W29>=52656,W29<54117),W985-8,IF(AND(W29>=54117,W29<55578),W985-9,IF(AND(W29>=55578,W29<57039),W985-10,IF(AND(W29>=57039,W29<58500),W985-11,IF(AND(W29>=58500,W29<59961),W985-12))))))","v":false},false,{"$f":"IF(AND(Y29>=51195,Y29<52656),Y985-7,IF(AND(Y29>=52656,Y29<54117),Y985-8,IF(AND(Y29>=54117,Y29<55578),Y985-9,IF(AND(Y29>=55578,Y29<57039),Y985-10,IF(AND(Y29>=57039,Y29<58500),Y985-11,IF(AND(Y29>=58500,Y29<59961),Y985-12))))))","v":false},false,{"$f":"IF(AND(AA29>=51195,AA29<52656),AA985-7,IF(AND(AA29>=52656,AA29<54117),AA985-8,IF(AND(AA29>=54117,AA29<55578),AA985-9,IF(AND(AA29>=55578,AA29<57039),AA985-10,IF(AND(AA29>=57039,AA29<58500),AA985-11,IF(AND(AA29>=58500,AA29<59961),AA985-12))))))","v":false},false,{"$f":"IF(AND(AC29>=51195,AC29<52656),AC985-7,IF(AND(AC29>=52656,AC29<54117),AC985-8,IF(AND(AC29>=54117,AC29<55578),AC985-9,IF(AND(AC29>=55578,AC29<57039),AC985-10,IF(AND(AC29>=57039,AC29<58500),AC985-11,IF(AND(AC29>=58500,AC29<59961),AC985-12))))))","v":false}]
[null,null,null,null,null,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false]
[null,null,null,null,null,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false]
[null,null,null,null,null,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false]
[null,null,null,null,null,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false]
[null,null,null,null,null,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false]
[null,null,null,null,null,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false]
[null,null,{"$f":"$F$5/250","v":0},{"$f":"ROUNDDOWN($F$5/250,0)","v":0},{"$f":"$C$1000-$D$1000","v":0}]
[3,null,{"$f":"$F$5/250","v":0},{"$f":"ROUNDDOWN($F$5/250,0)","v":0},{"$f":"$C$1000-$D$1000","v":0},"DEVISES",1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1]
["Réf. Règlement",null,null,null,null,"DOSSIER"]
["Annexe 19.1",null,"Tarif unitaire","TOTAUX",null,"Colonne de saisie","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations"]
["Tarif d'émission"]
[null,null,null,null,null,{"$f":"IF(F1005<500,\"minimum 500\",IF(AND($E$1000<>0,G1006=\"DEVISES\"),\"par tranche de 250\",IF(AND($E$1000<>0,G1006=\"DEVIES\"),\"per schijf van 250\",\" \")))","v":"minimum 500"},{"$f":"IF(AND(G999>2,G1006=\"DEVISES\"),\"MONNAIE\",IF(AND(G999>2,G1006=\"DEVIES\"),\"VALUTA\",\" \"))","v":" "}]
["I.1","Frais de dossier                    (minimum 500 et ensuite par tranche de 250)",null,{"$f":"F1005","v":0},"(a)",0,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF"]
[null,"(rémunération unique)",null,null,null,null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES"]
[null,"Facturation unique"]
["II.1","Création du code ISIN",10,{"$f":"SUM(H1008,,J1008,L1008,N1008,P1008,R1008,T1008,V1008,X1008,Z1008,AB1008,AD1008)","v":0},null,null,null,{"$f":"IF(G1008>1,\"ERROR\",$C1008*G1008)","v":0}]
["II.3","Coupons (toutes les données connues lors de l'émission)",100,{"$f":"SUM(H1009,,J1009,L1009,N1009,P1009,R1009,T1009,V1009,X1009,Z1009,AB1009,AD1009)","v":0},null,null,null,{"$f":"IF(G1009>1,\"ERROR\",$C1009*G1009)","v":0}]
["II.4","Bond factors possibles",250,{"$f":"SUM(H1010,,J1010,L1010,N1010,P1010,R1010,T1010,V1010,X1010,Z1010,AB1010,AD1010)","v":0},null,null,null,{"$f":"IF(G1010>1,\"ERROR\",$C1010*G1010)","v":0}]
[null,"Sous-Total facturation unique",null,{"$f":"SUM(H1011,,J1011,L1011,N1011,P1011,R1011,T1011,V1011,X1011,Z1011,AB1011,AD1011)","v":0},"(b)",null,null,{"$f":"IF(AND(G999=2,G1011=1,G1006=\"DEVISES\"),\"DEVISES\",IF(AND(G999=2,G1011=1,G1006=\"DEVIES\"),\"DEVIES\",IF(G1011>1,\"ERROR\",$C1011*G1011)))","v":0}]
["III.1","Payement du capital à l'échéance finale",10,{"$f":"SUM(D1008:D1011)","v":0},"(c)",null,null,{"$f":"SUM(H1008:H1011)","v":0}]
[null,"Interventions sans procédures automatiques standards"]
["II.7","Annulation complète de l'encours",250,{"$f":"SUM(H1014,J1014,L1014,N1014,P1014,R1014,T1014,V1014,X1014,Z1014,AB1014,AD1014)","v":0},null,null,null,{"$f":"IF(G1014>1,\"ERROR\",$C1014*G1014)","v":0}]
["III.5","Annulation complète de l'encours et remboursement du capital",250,{"$f":"SUM(H1015,J1015,L1015,N1015,P1015,R1015,T1015,V1015,X1015,Z1015,AB1015,AD1015)","v":250},null,null,null,{"$f":"IF($G$1000>1,0,(IF(G$11=1,0,250)))","v":250}]
[null,"Sous-Total interventions sans procédures automatiques standards",null,{"$f":"SUM(D1014:D1015)","v":250},"(d)"]
[null,"Facturation annuelle"]
["II.2","Nombre de coupons créés/ Année",50,{"$f":"SUM(H1018,,J1018,L1018,N1018,P1018,R1018,T1018,V1018,X1018,Z1018,AB1018,AD1018)","v":0},null,null,null,{"$f":"G1018*$C1018","v":0}]
["II.5","Nombre de bond factors enregistrés / Année",100,0,null,null,null,0]
["II.6","Nombre de diminutions partielles de titres sans bond factor / Année",250,0,null,null,null,0]
["III.2","Nombre de payements de coupons exécutés / Année",100,0,null,null,null,0]
["III.3","Nombre de remboursements partiels du capital via bond factor / Année",100,0,null,null,null,0]
["III.4","Nombre de remboursements partiels du capital sans bond factor / Année",250,0,null,null,null,0]
["IV.1","Rémunération pour titres physiques",250,0,null,null,null,{"$f":"IF(G1024>1,\"ERROR\",G1024*$C1024)","v":0}]
[null,"Sous-Total facturation annuelle",null,{"$f":"SUM(D1018:D1024)","v":0},"(e)"]
["V.4","Rémunération plafonnée suivant encours"]
[null,"Encours"]
[null,"Date début"]
[null,"Date fin"]
[null,"Pour info : rémunération sans application du plafond  de 0,005 °/°° an * encours",null,{"$f":"SUM(H1030+J1030+L1030+N1030+P1030+R1030+T1030+V1030+X1030+Z1030+AB1030+AD1030)","v":0}]
[null,"Rémunération plafonnée suivant encours 1ère année",null,{"$f":"SUM(H1031+J1031+L1031+N1031+P1031+R1031+T1031+V1031+X1031+Z1031+AB1031+AD1031)","v":0},"(f)",null,null,{"$f":"H1029*G1030","v":0}]
[null,"Rémunération plafonnée suivant encours par année complète > 1 an",null,null,"(g)"]
[null,"Rémunération plafonnée suivant encours fraction restante",null,{"$f":"SUM(H1033+J1033+L1033+N1033+P1033+R1033+T1033+V1033+X1033+Z1033+AB1033+AD1033)","v":0},"(h)"]
[null,"Autres facturations"]
["V.1","Services contractuels                                                             (ad hoc)",null,{"$f":"SUM(H1035,J1035,L1035,N1035,P1035,R1035,T1035,V1035,X1035,Z1035,AB1035,AD1035)","v":0},"(i)",null,null,{"$f":"G1035","v":0}]
["-","Correction",null,{"$f":"SUM(H1036,J1036,L1036,N1036,P1036,R1036,T1036,V1036,X1036,Z1036,AB1036,AD1036)","v":0},"(j)"]
[null,"R E C A P I T U L A T I F     (TVA excl)",null,null,null,{"$f":"F1005","v":0},null,{"$f":"H1005+H1012+H1029+H1035","v":0}]
[null,"TOTAL 1ère ANNEE  (a + b + e + f + i + j)",null,{"$f":"D1005+D1012+D1025+D1031+D1035+D1036","v":0},"(A)"]
[null,"TOTAL PAR ANNEE COMPLETE > 1 AN "]
[null,"TOTAL ANNEES SUIVANTES + ECHEANCE ((e * durée > 1 an) + (g * nombre d'années > 1 an) + h) + (c)",null,{"$f":"SUM(H1040,J1040,L1040,N1040,P1040,R1040,T1040,V1040,X1040,Z1040,AB1040,AD1040)","v":0},"(B)"]
[null,"TOTAL INTERVENTIONS SANS PROCEDURES AUTOMATIQUES STANDARDS (d)",null,{"$f":"D1016","v":250},"(C)",{"$f":"F1005","v":0},null,{"$f":"H1005+H1012+H1031+H1035","v":0}]
[null,"TOTAL GENERAL POUR LE PROGRAMME (A + B + C)",null,{"$f":"D1038+D1040+D1041","v":250}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"$F$5/250","v":0},{"$f":"ROUNDDOWN($F$5/250,0)","v":0},{"$f":"$C$1000-$D$1000","v":0}]
["Referte Reglement",null,null,null,null,"DOSSIER"]
["Bijlage 19.1",null,"Eenheidsprijs","TOTALEN",null,"Gegevensinvoer","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen"]
["Uitgiftevergoeding"]
[null,null,null,null,null,{"$f":"IF(F1105<500,\"minimum 500\",IF($E$1000<>0,\"par tranche de 250\",\" \"))","v":"minimum 500"},{"$f":"IF(AND(G1100>2,G1106=\"DEVISES\"),\"MONNAIE\",IF(AND(G1100>2,G1106=\"ANDERE MUNT\"),\"VALUTA\",\" \"))","v":" "}]
["I.1"," Dossierkosten                         (minimum 500 en dan per schijf van 250)",null,{"$f":"F1105","v":0},"(a)",0,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF"]
[null,"(eenmalige vergoeding)",null,null,null,null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT"]
[null,"Eenmalige  facturering"]
["II.1","Creatie van een ISIN-code",10,{"$f":"SUM(H1108,,J1108,L1108,N1108,P1108,R1108,T1108,V1108,X1108)","v":0}]
["II.3","Coupons (alle gegevens gekend bij de uitgifte)",100,0]
["II.4","Bond factors mogelijk",250,0]
[null,"Tussentotaal eenmalige facturering",null,{"$f":"SUM(D1107:D1110)","v":0},"(b)"]
["III.1","Terugbetaling van het kapitaal op eindvervaldag",10,{"$f":"SUM(D1108:D1111)","v":0},"(c)"]
[null,"Interventies buiten de automatische standaardprocedures"]
["II.7","Volledige annulatie van de omloop",250,0]
["III.5","Volledige annulatie van de omloop en kapitaalsterugbetaling",250,0]
[null,"Tussentotaal interventies buiten de automatische standaardprocedures",null,{"$f":"SUM(D1114:D1115)","v":0},"(d)"]
[null,"Jaarlijkse facturering"]
["II.2","Aantal gecreëerde coupons / Jaar",50,{"$f":"SUM(H1118,,J1118,L1118,N1118,P1118,R1118,T1118,V1118,X1118)","v":0}]
["II.5","Aantal geregistreerde bond factors / Jaar",100,0]
["II.6","Aantal gedeeltelijke omloopverminderingen zonder bond factor / Jaar",250,0]
["III.2","Aantal uitgevoerde couponbetalingen / Jaar",100,0]
["III.3","Aantal gedeeltelijke kapitaalsterugbetalingen via bond factor / Jaar",100,0]
["III.4","Aantal gedeeltelijke kapitaalsterugbetalingen zonder bond factor / Jaar",250,0]
["IV.1","Vergoeding voor fysieke effecten",250,0]
[null,"Tussentotaal jaarlijkse facturering",null,null,"(e)"]
["V.4","Geplafonneerde omloopvergoeding",null,0]
[null,"Omloop"]
[null,"Begin datum"]
[null,"Eind datum"]
[null,"Ter info : vergoeding zonder toepassing van het plafond van 0,005 °/°° Jaar * omloop"]
[null,"Geplafonneerde omloopvergoeding 1e jaar",null,{"$f":"SUM(D1118:D1126)","v":0},"(f)"]
[null,"Geplafonneerde omloopvergoeding per volledig jaar > 1 jaar",null,null,"(g)"]
[null,"Geplafonneerde omloopvergoeding restfractie",null,null,"(h)"]
[null,"Andere factureringen"]
["V.1","Overeengekomen diensten                                                         (ad hoc)",null,{"$f":"SUM(H1135,,J1135,L1135,N1135,P1135,R1135,T1135,V1135,X1135)","v":0},"(i)"]
["-","Correctie",null,null,"(j)"]
[null,"S A M E N V A T T I N G     (excl BTW)"]
[null,"TOTAAL 1e JAAR (a + b + e + f + i + j)",null,null,"(A)"]
[null,"TOTAAL PER VOLLEDIG JAAR > 1 JAAR "]
[null,"TOTAAL VOLGENDE JAREN ((e * looptijd > 1 jaar) + (g * aantal jaren > 1 jaar) + h) + (c)",null,null,"(B)"]
[null,"TOTAAL INTERVENTIES BUITEN DE AUTOMATISCHE STANDAARDPROCEDURES (d)",null,null,"(C)"]
[null,"ALGEMEEN TOTAAL VOOR HET PROGRAMMA (A + B + C)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"$F$5/250","v":0},{"$f":"ROUNDDOWN($F$5/250,0)","v":0},{"$f":"$C$1000-$D$1000","v":0}]
["References Rules",null,null,null,null,"DOSSIER"]
["Annex 19.1",null,"Unit rate","TOTALS",null,"Input column","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee"]
["Issue Fee"]
[null,null,null,null,null,{"$f":"IF(F1205<500,\"minimum 500\",IF(AND($E$1000<>0,G1206=\"DEVISES\"),\"par tranche de 250\",IF(AND($E$1000<>0,G1206=\"ANDERE MUNT\"),\"per schijf van 250\",IF(AND($E$1000<>0,G1206=\"CURRENCY\"),\"per multiple of 250\",\" \"))))","v":" "},{"$f":"IF(AND(G1200>2,G1206=\"DEVISES\"),\"MONNAIE\",IF(AND(G1200>2,G1206=\"DEVIES\"),\"VALUTA\",\" \"))","v":" "}]
["I.1","Handling charges                  (minimum 500 and per multiple of 250)",null,{"$f":"F1205","v":600},"(a)",600,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF",null,"EUR / BEF"]
[null,"(One-off fee)",null,null,null,null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY"]
[null,"One-off invoice"]
["II.1","Creation of the ISIN code",10,{"$f":"SUM(H1208,,J1208,L1208,N1208,P1208,R1208,T1208,V1208,X1208)","v":0}]
["II.3","Creation of the ISIN code : data of the coupons known before the issue",100,0]
["II.4","Creation of the ISIN code : bond factors provided for",250,0]
[null,"Subtotal one-off invoice",null,0,"(b)"]
["III.1","Repayment in EUR of the capital on the final due date",10,0,"(c)"]
[null,"Interventions without automatic standard procedures"]
["II.7","Complete cancellation of the circulation ",250,0]
["III.5","Complete cancellation of the circulation and full capital repayment  ",250,0]
[null,"Subtotal interventions without automatic standard procedures",null,{"$f":"SUM(D1208:D1215)","v":0},"(d)"]
[null,"Annual invoice"]
["II.2","Number of coupons created / Year",50,{"$f":"SUM(H1218,,J1218,L1218,N1218,P1218,R1218,T1218,V1218,X1218)","v":0}]
["II.5","Number of bond factors entered / Year",100,0]
["II.6","Number of partial diminutions of the circulation without bond factor / Year",250,0]
["III.2","Number of payments of coupon interest / Year",100,0]
["III.3","Number of partial repayments of capital with bond factor / Year",100,0]
["III.4","Number of partial repayments of capital without bond factor / Year",250,0]
["IV.1","Fee for physical securities",250,0]
[null,"Subtotal annual invoice",null,{"$f":"SUM(D1215:D1223)","v":0},"(e)"]
["V.4","Leveled out fee depending of the nominal circulation"]
[null,"Outstanding amount"]
[null,"Start date"]
[null,"End date"]
[null,"Reminder : fee without application of the leveling out of 0,005 °/°° year * nominal circulation"]
[null,"Leveled out fee depending of the nominal circulation 1st year",null,null,"(f)"]
[null,"Leveled out fee depending of the nominal circulation for a complete year > 1 year",null,null,"(g)"]
[null,"Leveled out fee depending of the nominal circulation remaining fraction",null,null,"(h)"]
[null,"Other facturations"]
["V.1","Contractual services                                                             (ad hoc)",null,null,"(i)"]
["-","Correction",null,null,"(j)"]
[null,"S U M M A R Y     (excl VAT)"]
[null,"TOTAL 1st YEAR  (a + b + e + f + i + j)",null,null,"(A)"]
[null,"TOTAL FOR A COMPLETE YEAR > 1 YEAR "]
[null,"TOTAL FOLLOW. YEARS + MATURITY ((e * period > 1 year) + (g * number of years  > 1 year) + h) + (c)",null,null,"(B)"]
[null,"TOTAL INTERVENTIONS WITHOUT AUTOMATIC STANDARD PROCEDURES (c)",null,null,"(C)"]
[null,"TOTAL AMOUNT FOR THE PROGRAM (A + B + C)"]

{"sheet":"FR","index":1,"n_rows":188,"n_cols":30,"rows_kept":188,"cut":false,"hidden":true,"merged":[]}
[]
["Référence Règlement",null,null,null,null,null,"Code ISIN 1",null,"Code ISIN 2",null,"Code ISIN 3",null,"Code ISIN 4",null,"Code ISIN 5",null,"Code ISIN 6",null,"Code ISIN 7",null,"Code ISIN 8",null,"Code ISIN 9",null,"Code ISIN 10",null,"Code ISIN 11",null,"Code ISIN 12"]
["Annexe 19.1"]
["Rémunération d'émission",null,"Tarif unitaire","TOTAUX",null,"Colonne de saisie","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations","Colonne de saisie","Rémunérations"]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(F9<500,\"minimum 500\",IF(AND($E$12<>0,G10=\"DEVISES\"),\"par tranche de 250\",IF(AND($E$12<>0,G10=\"DEVIES\"),\"per schijf van 250\",\" \")))","v":"minimum 500"},{"$f":"IF(AND(G12>2,G10=\"DEVISES\"),\"MONNAIE\",IF(AND(G12>2,G10=\"DEVIES\"),\"VALUTA\",\" \"))","v":" "}]
["I.1","Frais de dossier                    (minimum 500 et ensuite par tranche de 250)",null,{"$f":"F9","v":0},"(a)",0,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR"]
[null,"(rémunération unique)",null,null,null,null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES",null,"DEVISES"]
[]
[null,null,{"$f":"$F$9/250","v":0},{"$f":"ROUNDDOWN($F$9/250,0)","v":0},{"$f":"$C$12-$D$12","v":0}]
[null,"Facturation unique"]
["II.1","Création du code ISIN",10,{"$f":"SUM(H14,,J14,L14,N14,P14,R14,T14,V14,X14)","v":0},null,null,null,{"$f":"IF(G14>1,\"ERROR\",$C14*G14)","v":0}]
["II.3","Création du code ISIN : coupons connus lors de l'émission",100,{"$f":"SUM(H15,,J15,L15,N15,P15,R15,T15,V15,X15)","v":0},null,null,null,{"$f":"IF(G15>1,\"ERROR\",$C15*G15)","v":0}]
["II.4","Création du code ISIN : bond factors prévus",250,{"$f":"SUM(H16,,J16,L16,N16,P16,R16,T16,V16,X16)","v":0},null,null,null,{"$f":"IF(G16>1,\"ERROR\",$C16*G16)","v":0}]
["III.1","Payement en EUR du capital à l'échéance finale",10,{"$f":"SUM(H17,,J17,L17,N17,P17,R17,T17,V17,X17)","v":0},null,null,null,{"$f":"IF(AND(G12=2,G17=1,G10=\"DEVISES\"),\"DEVISES\",IF(AND(G12=2,G17=1,G10=\"DEVIES\"),\"DEVIES\",IF(G17>1,\"ERROR\",$C17*G17)))","v":0}]
["II.7","Annulation complète de l'encours",250,{"$f":"SUM(H18,,J18,L18,N18,P18,R18,T18,V18,X18)","v":0},null,null,null,{"$f":"IF(G18>1,\"ERROR\",$C18*G18)","v":0}]
[null,"(sans procédure automatique standard) "]
["III.5","Remboursement complet du capital",250,{"$f":"SUM(H20,,J20,L20,N20,P20,R20,T20,V20,X20)","v":250},null,null,null,{"$f":"IF($G$12>1,0,(IF(G$17=1,0,250)))","v":250}]
[null,"(sans procédure automatique standard) "]
[]
[null,"Sous-Total facturation unique",null,{"$f":"SUM(D14:D21)","v":250},"(b)",null,null,{"$f":"SUM(H14:H21)","v":250}]
[]
[]
[null,"Facturation annuelle"]
["II.2","Nombre de coupons créés/ Année",50,{"$f":"SUM(H27,,J27,L27,N27,P27,R27,T27,V27,X27)","v":0},null,null,null,{"$f":"G27*$C27","v":0}]
["II.5","Nombre de bond factors enregistrés / Année",100,0,null,null,null,0]
["II.6","Nombre de diminutions partielles de titres sans bond factor / Année",250,0,null,null,null,0]
["III.2","Nombre de payements de coupons exécutés / Année",100,0,null,null,null,0]
["III.3","Nombre de remboursements partiels du capital via bond factor / Année",100,0,null,null,null,0]
["III.4","Nombre de remboursements partiels du capital sans bond factor / Année",250,0,null,null,null,0]
["IV.1","Rémunération pour titres physiques",250,0,null,null,null,{"$f":"IF(G33>1,\"ERROR\",G33*$C33)","v":0}]
["V.4","Rémunération plafonnée suivant encours",null,0,null,null,null,{"$f":"IF(G34<=500000000,G34*0.000005,IF(AND(G34>500000000,G34<=1000000000),2500,IF(AND(G34>1000000000,G34<=2000000000),3000,IF(AND(G34>2000000000,G34<=3000000000),3500,IF(AND(G34>3000000000,G34<=5000000000),4000,IF(AND(G34>5000000000,G34<=10000000000),5000,IF(G34>10000000000,7000)))))))","v":0}]
[null,"Pour mémoire : rémunération sans application du plafond  0,005 °/°° an * encours",null,null,null,null,null,{"$f":"G34*0.000005","v":0}]
[]
[null,"Sous-Total facturation annuelle",null,{"$f":"SUM(D27:D34)","v":0},"(c)",null,null,{"$f":"SUM(H27:H34)","v":0}]
[null,"Nombre d'années"]
[null,"Sous-Total facturation annuelle * nombre d'années",null,{"$f":"SUM(H39,J39,L39,N39,P39,R39,T39,V39,X39)","v":0},"(d)",null,null,{"$f":"H37*G38","v":0}]
[]
[]
[null,"Autres facturations"]
["V.1","Services contractuels                                                             (ad hoc)",null,{"$f":"SUM(H43,,J43,L43,N43,P43,R43,T43,V43,X43)","v":0},"(e)",null,null,{"$f":"G43","v":0}]
[]
[]
[]
[null,"TOTAL 1ère ANNEE  (a + b + c + e)",null,{"$f":"D9+D23+D37+D43","v":250},null,{"$f":"F9","v":0},null,{"$f":"H9+H23+H37+H43","v":250}]
[]
[null,"TOTAL GENERAL POUR TOUTE L'EMISSION (a + b + d + e)",null,{"$f":"D9+D23+D39+D43","v":250},null,{"$f":"F9","v":0},null,{"$f":"H9+H23+H39+H43","v":250}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"EUR"]
[null,null,null,null,null,null,"DEVISES"]

{"sheet":"NL","index":2,"n_rows":188,"n_cols":30,"rows_kept":188,"cut":false,"hidden":true,"merged":[]}
[]
["Referte Reglement",null,null,null,null,null,"ISIN-code 1",null,"ISIN-code 2",null,"ISIN-code 3",null,"ISIN-code 4",null,"ISIN-code 5",null,"ISIN-code 6",null,"ISIN-code 7",null,"ISIN-code 8",null,"ISIN-code 9",null,"ISIN-code 10",null,"ISIN-code 11",null,"ISIN-code 12"]
["Bijlage 19.1"]
["Uitgiftevergoeding",null,"Eenheidsprijs","TOTALEN",null,"Gegevensinvoer","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen","Gegevensinvoer","Vergoedingen"]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(F9<500,\"minimum 500\",IF($E$12<>0,\"par tranche de 250\",\" \"))","v":"minimum 500"},{"$f":"IF(AND(G12>2,G10=\"DEVISES\"),\"MONNAIE\",IF(AND(G12>2,G10=\"ANDERE MUNT\"),\"VALUTA\",\" \"))","v":" "}]
["I.1"," Dossierskosten                         (minimum 500 en dan per schijf van 250)",null,{"$f":"F9","v":0},"(a)",0,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR"]
[null,"(eenmalige vergoeding)",null,null,null,null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT",null,"ANDERE MUNT"]
[]
[null,null,{"$f":"$F$9/250","v":0},{"$f":"ROUNDDOWN($F$9/250,0)","v":0},{"$f":"$C$12-$D$12","v":0}]
[null,"Eenmalige  facturering"]
["II.1","Creatie van een ISIN-code",10,{"$f":"SUM(H14,,J14,L14,N14,P14,R14,T14,V14,X14)","v":0},null,null,null,{"$f":"IF(G14>1,\"ERROR\",$C14*G14)","v":0}]
["II.3","Creatie van een ISIN-code : coupons gekend bij de uitgifte",100,{"$f":"SUM(H15,,J15,L15,N15,P15,R15,T15,V15,X15)","v":0},null,null,null,{"$f":"IF(G15>1,\"ERROR\",$C15*G15)","v":0}]
["II.4","Creatie van een ISIN-code : bond factors voorzien",250,{"$f":"SUM(H16,,J16,L16,N16,P16,R16,T16,V16,X16)","v":0},null,null,null,{"$f":"IF(G16>1,\"ERROR\",$C16*G16)","v":0}]
["III.1","Terugbetaling in EUR van het kapitaal op eindvervaldag",10,{"$f":"SUM(H17,,J17,L17,N17,P17,R17,T17,V17,X17)","v":0},null,null,null,{"$f":"IF(AND(G12=2,G17=1,G10=\"DEVISES\"),\"DEVISES\",IF(AND(G12=2,G17=1,G10=\"DEVIES\"),\"DEVIES\",IF(G17>1,\"ERROR\",$C17*G17)))","v":0}]
["II.7","Volledige annulatie van de omloop",250,{"$f":"SUM(H18,,J18,L18,N18,P18,R18,T18,V18,X18)","v":0},null,null,null,{"$f":"IF(G18>1,\"ERROR\",$C18*G18)","v":0}]
[null,"(buiten de automatische standaardprocedures)"]
["III.5","Volledige kapitaalsterugbetaling",250,{"$f":"SUM(H20,,J20,L20,N20,P20,R20,T20,V20,X20)","v":250},null,null,null,{"$f":"IF($G$12>1,0,(IF(G$17=1,0,250)))","v":250}]
[null,"(buiten de automatische standaardprocedures)"]
[]
[null,"Tussentotaal unieke facturering",null,{"$f":"SUM(D14:D21)","v":250},"(b)",null,null,{"$f":"SUM(H14:H21)","v":250}]
[]
[]
[null,"Jaarlijkse facturering"]
["II.2","Aantal gecreëerde coupons / Jaar",50,{"$f":"SUM(H27,,J27,L27,N27,P27,R27,T27,V27,X27)","v":0},null,null,null,{"$f":"G27*$C27","v":0}]
["II.5","Aantal geregistreerde bond factors / Jaar",100,0,null,null,null,0]
["II.6","Aantal gedeeltelijke omloopvermindering zonder bond factor / Jaar",250,0,null,null,null,0]
["III.2","Aantal uitgevoerde couponbetalingen / Jaar",100,0,null,null,null,0]
["III.3","Aantal gedeeltelijke kapitaalsterugbetalingen via bond factor / Jaar",100,0,null,null,null,0]
["III.4","Aantal gedeeltelijke kapitaalsterugbetalingen zonder bond factor / Jaar",250,0,null,null,null,0]
["IV.1","Vergoeding voor fysieke effecten",250,0,null,null,null,{"$f":"IF(G33>1,\"ERROR\",G33*$C33)","v":0}]
["V.4","Geplafonneerde omloopsvergoeding",null,0,null,null,null,{"$f":"IF(G34<=500000000,G34*0.000005,IF(AND(G34>500000000,G34<=1000000000),2500,IF(AND(G34>1000000000,G34<=2000000000),3000,IF(AND(G34>2000000000,G34<=3000000000),3500,IF(AND(G34>3000000000,G34<=5000000000),4000,IF(AND(G34>5000000000,G34<=10000000000),5000,IF(G34>10000000000,7000)))))))","v":0}]
[null,"Herinnering : vergoeding zonder toepassing van het plafond 0,005 °/°° Jaar * omloop",null,null,null,null,null,{"$f":"G34*0.000005","v":0}]
[]
[null,"Tussentotaal jaarlijkse facturering",null,{"$f":"SUM(D27:D34)","v":0},"(c)",null,null,{"$f":"SUM(H27:H34)","v":0}]
[null,"Aantal jaren"]
[null,"Tussentotaal jaarlijkse facturering * aantal jaren",null,{"$f":"SUM(H39,J39,L39,N39,P39,R39,T39,V39,X39)","v":0},"(d)",null,null,{"$f":"H37*G38","v":0}]
[]
[]
[null,"Andere factureringen"]
["V.1","Overeengekomen diensten                                                         (ad hoc)",null,{"$f":"SUM(H43,,J43,L43,N43,P43,R43,T43,V43,X43)","v":0},"(e)",null,null,{"$f":"G43","v":0}]
[]
[]
[]
[null,"TOTAAL 1e JAAR (a + b + c + e)",null,{"$f":"D9+D23+D37+D43","v":250},null,{"$f":"F9","v":0},null,{"$f":"H9+H23+H37+H43","v":250}]
[]
[null,"ALGEMENE TOTAAL VOOR DE UITGIFTE (a + b + d + e)",null,{"$f":"D9+D23+D39+D43","v":250},null,{"$f":"F9","v":0},null,{"$f":"H9+H23+H39+H43","v":250}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"EUR"]
[null,null,null,null,null,null,"DEVISES"]

{"sheet":"EN","index":3,"n_rows":188,"n_cols":30,"rows_kept":188,"cut":false,"hidden":true,"merged":[]}
[]
["References Rules",null,null,null,null,null,"ISIN code 1",null,"ISIN code 2",null,"ISIN code 3",null,"ISIN code 4",null,"ISIN code 5",null,"ISIN code 6",null,"ISIN code 7",null,"ISIN code 8",null,"ISIN code 9",null,"ISIN code 10",null,"ISIN code 11",null,"ISIN code 12"]
["Annex 19.1"]
["Issue Fee",null,"Unit rate","TOTALS",null,"Input column","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee","Input column","Fee"]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(F9<500,\"minimum 500\",IF(AND($E$12<>0,G10=\"DEVISES\"),\"par tranche de 250\",IF(AND($E$12<>0,G10=\"ANDERE MUNT\"),\"per schijf van 250\",IF(AND($E$12<>0,G10=\"CURRENCY\"),\"per multiple of 250\",\" \"))))","v":"per multiple of 250"},{"$f":"IF(AND(G12>2,G10=\"DEVISES\"),\"MONNAIE\",IF(AND(G12>2,G10=\"DEVIES\"),\"VALUTA\",\" \"))","v":" "}]
["I.1","Handling charges                  (minimum 500 with price bracket of 250))",null,{"$f":"F9","v":600},"(a)",600,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR",null,"EUR"]
[null,"(One-off fee)",null,null,null,null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY",null,"CURRENCY"]
[]
[null,null,{"$f":"$F$9/250","v":2.4},{"$f":"ROUNDDOWN($F$9/250,0)","v":2},{"$f":"$C$12-$D$12","v":0.39999999999999991}]
[null,"One-off invoice"]
["II.1","Creation of the ISIN code",10,{"$f":"SUM(H14,,J14,L14,N14,P14,R14,T14,V14,X14)","v":0},null,null,null,{"$f":"IF(G14>1,\"ERROR\",$C14*G14)","v":0}]
["II.3","Creation of the ISIN code : data of the coupons known before the issue",100,{"$f":"SUM(H15,,J15,L15,N15,P15,R15,T15,V15,X15)","v":0},null,null,null,{"$f":"IF(G15>1,\"ERROR\",$C15*G15)","v":0}]
["II.4","Creation of the ISIN code : bond factors provided for",250,{"$f":"SUM(H16,,J16,L16,N16,P16,R16,T16,V16,X16)","v":0},null,null,null,{"$f":"IF(G16>1,\"ERROR\",$C16*G16)","v":0}]
["III.1","Repayment in EUR of the capital on the final due date",10,{"$f":"SUM(H17,,J17,L17,N17,P17,R17,T17,V17,X17)","v":0},null,null,null,{"$f":"IF(AND(G12=2,G17=1,G10=\"DEVISES\"),\"DEVISES\",IF(AND(G12=2,G17=1,G10=\"DEVIES\"),\"DEVIES\",IF(G17>1,\"ERROR\",$C17*G17)))","v":0}]
["II.7","Complete cancellation of the circulation",250,{"$f":"SUM(H18,,J18,L18,N18,P18,R18,T18,V18,X18)","v":0},null,null,null,{"$f":"IF(G18>1,\"ERROR\",$C18*G18)","v":0}]
[null,"(without automatic standard procedures)"]
["III.5","Full capital repayment",250,{"$f":"SUM(H20,,J20,L20,N20,P20,R20,T20,V20,X20)","v":250},null,null,null,{"$f":"IF($G$12>1,0,(IF(G$17=1,0,250)))","v":250}]
[null,"(without automatic standard procedures)"]
[]
[null,"Subtotal one-off invoice",null,{"$f":"SUM(D14:D21)","v":250},"(b)",null,null,{"$f":"SUM(H14:H21)","v":250}]
[]
[]
[null,"Annual invoice"]
["II.2","Number of coupons created / Year",50,{"$f":"SUM(H27,,J27,L27,N27,P27,R27,T27,V27,X27)","v":0},null,null,null,{"$f":"G27*$C27","v":0}]
["II.5","Number of bond factors entered / Year",100,0,null,null,null,0]
["II.6","Number of partial diminutions of the circulation without bond factor / Year",250,0,null,null,null,0]
["III.2","Number of payments of coupon interest / Year",100,0,null,null,null,0]
["III.3","Number of partial repayment of capital with bond factor / Year",100,0,null,null,null,0]
["III.4","Number of partial repayments of capital without bond factor / Year",250,0,null,null,null,0]
["IV.1","Fee for physical securities",250,0,null,null,null,{"$f":"IF(G33>1,\"ERROR\",G33*$C33)","v":0}]
["V.4","Leveled out fee depending of the nominal circulation",null,0,null,null,null,{"$f":"IF(G34<=500000000,G34*0.000005,IF(AND(G34>500000000,G34<=1000000000),2500,IF(AND(G34>1000000000,G34<=2000000000),3000,IF(AND(G34>2000000000,G34<=3000000000),3500,IF(AND(G34>3000000000,G34<=5000000000),4000,IF(AND(G34>5000000000,G34<=10000000000),5000,IF(G34>10000000000,7000)))))))","v":0}]
[null,"Reminder : fee without application of the leveling out 0,005 °/°° year * nominal circulation",null,null,null,null,null,{"$f":"G34*0.000005","v":0}]
[]
[null,"Subtotal annual invoice",null,{"$f":"SUM(D27:D34)","v":0},"(c)",null,null,{"$f":"SUM(H27:H34)","v":0}]
[null,"Number of years"]
[null,"Subtotal annual invoice * number of years",null,{"$f":"SUM(H39,J39,L39,N39,P39,R39,T39,V39,X39)","v":0},"(d)",null,null,{"$f":"H37*G38","v":0}]
[]
[]
[null,"Other facturations"]
["V.1","Contractual services                                                             (ad hoc)",null,{"$f":"SUM(H43,,J43,L43,N43,P43,R43,T43,V43,X43)","v":0},"(e)",null,null,{"$f":"G43","v":0}]
[]
[]
[]
[null,"TOTAL 1st YEAR  (a + b + c + e)",null,{"$f":"D9+D23+D37+D43","v":850},null,{"$f":"F9","v":600},null,{"$f":"H9+H23+H37+H43","v":250}]
[]
[null,"TOTAL AMOUNT FOR THE ISSUE (a + b + d + e)",null,{"$f":"D9+D23+D39+D43","v":850},null,{"$f":"F9","v":600},null,{"$f":"H9+H23+H39+H43","v":250}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"EUR"]
[null,null,null,null,null,null,"DEVISES"]