{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Récapitulatif","Autofinancement total","Financement par emprunt","Financement par crédit-bail"],"not_rendered":{"defined_names":18,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Récapitulatif","index":0,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[1,1,1,4],[1,6,1,8],[2,1,2,3],[3,1,3,3],[4,1,4,3]]}
[]
[null,"Données",{"$nulls":4},"Coût net de financement"]
[null,"Montant hors taxe du capital investi :",{"$nulls":4},"Autofinancement",{"$f":"autofinancement","v":{"v":0,"d":"0 "}},{"$f":"IF(H3=0,\" \",RANK(H3,$H$3:$H$5,1))","v":" "}]
[null,"Durée d'utilisation prévue : ",{"$nulls":4},"Financement par emprunt",{"$f":"'Financement par emprunt'!I28","v":{"v":0,"d":"0 "}},{"$f":"IF(H4=0,\" \",RANK(H4,$H$3:$H$5,1))","v":" "}]
[null,"Taux d'actualisation : ",{"$nulls":4},"Financement par crédit-bail ",{"$f":"'Financement par crédit-bail'!F26","v":{"v":0,"d":"0 "}},{"$f":"IF(H5=0,\" \",RANK(H5,$H$3:$H$5,1))","v":" "}]
[null,"Amortissement dégressif ?",null,{"$f":"IF(ISBLANK(Récapitulatif!C6),\" \",IF(Récapitulatif!C6=\"Non\",\" \",\" Durée :\"))","v":" "}]
[null,{"$f":"IF(Récapitulatif!E6>0,\"Coefficient dégressif :\",\" \")","v":" "},null,null,{"$f":"IF(ISBLANK(Récapitulatif!E6),\" \",IF(Récapitulatif!$E$6<3,0,IF(Récapitulatif!$E$6<5,C12,IF(Récapitulatif!$E$6<6.67,D12,E12))))","v":" "}]
[]
[null,"Taux d'impôt sur les bénéfices"]
[]
[null,"Durée d'utilisation","3-4 ans","5-6 ans","6,2/3-20 ans"]
[null,"=> Coefficient applicable ",1.25,1.75,2.25]

{"sheet":"Autofinancement total","index":1,"n_rows":26,"n_cols":10,"rows_kept":26,"merged":[[1,1,1,9],[2,1,3,1],[2,2,2,5],[2,6,3,6],[2,7,3,7],[2,8,2,9]]}
[]
[null,"Autofinancement total"]
[null,"Années ","Amortissements",{"$nulls":3},"Amortis. comptables","Economie \nd'impôt \nsur \namortis.","Décaissements"]
[null,null,"Economiques","Dégressifs","Restant à amortir","Dérogatoires",null,null,"Nets","actualisés"]
[null,"Année 0",{"$nulls":6},{"$f":"capital_investi","v":{"v":0,"d":"0.00 "}},{"$f":"I5","v":{"v":0,"d":"0.00 "}}]
[null,{"v":1,"d":"1ère année"},{"$f":"IF(B6>du,0,capital_investi/du)","v":{"v":0,"d":"0.00 "}},{"$f":"IF(OR(du=0,capital_investi=0),0,IF(dégressif=\"Oui\",(capital_investi/durée_amort)*coef_dégressif,0))","v":{"v":0,"d":"0.00 "}},{"$f":"IF(B6>=du,0,capital_investi-D6)","v":{"v":0,"d":"0.00 "}},{"$f":"IF(Récapitulatif!$C$6=\"Oui\",D6-C6,0)","v":{"v":0,"d":"0.00 "}},{"$f":"C6+F6","v":{"v":0,"d":"0.00 "}},{"$f":"ROUND(G6*IS,2)","v":{"v":0,"d":"0.00 "}},{"$f":"-H6","v":{"v":0,"d":"0.00 "}},{"$f":"I6/(POWER((1+tx_actualisation),B6))","v":{"v":0,"d":"0.00 "}}]
[null,{"$f":"B6+1","v":{"v":2,"d":"2ème année"}},{"v":0,"d":"0.00 "},{"$f":"IF(OR(du=0,capital_investi=0,E6=0),0,IF(dégressif=\"Oui\",MAX(E6/(da-B6),(E6/da)*K),0))","v":{"v":0,"d":"0.00 "}},{"$f":"IF(B7>=du,0,E6-D7)","v":{"v":0,"d":"0.00 "}},{"$f":"IF(Récapitulatif!$C$6=\"Oui\",D7-C7,0)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"$f":"ROUND(G7*IS,2)","v":{"v":0,"d":"0.00 "}},{"$f":"-H7","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "}]
[null,{"v":3,"d":"3ème année"},{"v":0,"d":"0.00 "},{"$f":"IF(OR(du=0,capital_investi=0,E7=0),0,IF(dégressif=\"Oui\",MAX(E7/(durée_amort-B7),(E7/durée_amort)*coef_dégressif),0))","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"$f":"IF(dégressif=\"Oui\",D8-C8,0)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":4,"d":"4ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":5,"d":"5ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":6,"d":"6ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":7,"d":"7ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":8,"d":"8ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":9,"d":"9ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":10,"d":"10ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":11,"d":"11ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":12,"d":"12ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"$f":"ROUND(G17*IS,2)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":13,"d":"13ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":14,"d":"14ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":15,"d":"15ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":16,"d":"16ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":17,"d":"17ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":18,"d":"18ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":19,"d":"19ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":20,"d":"20ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Total",{"$f":"SUM(C5:C25)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(D5:D25)","v":{"v":0,"d":"0.00 "}},null,{"$f":"SUM(F5:F25)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(G5:G25)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(H5:H25)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(I5:I25)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(J5:J25)","v":{"v":0,"d":"0.00 "}}]

{"sheet":"Financement par emprunt","index":2,"n_rows":28,"n_cols":9,"rows_kept":28,"merged":[[1,1,1,2],[1,4,1,6],[2,1,5,1],[2,2,2,3],[2,6,2,7],[3,4,3,5],[4,2,5,2],[4,3,4,4],[4,5,5,5],[4,6,5,6],[4,7,4,8]]}
[]
[null,"Financement par emprunt",null,{"$f":"IF(ISBLANK(E3),1,0)","v":1},{"$f":"IF(ISBLANK(E3),\"Si le montant autofinancé est nul, inscrire 0\",\" \")","v":"Si le montant autofinancé est nul, inscrire 0"},{"$nulls":3},{"$f":"IF(ISBLANK(frais_dossier),1,0)","v":1}]
[null,"Années ","Montant autofinancé",{"$nulls":3},"Montant emprunté",null,{"$f":"IF(ISBLANK(E3),0,capital_investi-'Financement par emprunt'!E3)","v":{"v":0,"d":"0 €"}}]
[null,null," Durée",null,"Taux d'intérêt + assurance",null,null," Frais dossier"]
[null,null,"Annuités de \nl'emprunt","Remboursements",null,"Amortis. Comptables","Economie d'impôt","Décaissements"]
[{"$nulls":3},"capital","intérêts",null,null,"nets","actualisés"]
[null,"Année 0",{"$nulls":5},{"$f":"E3+(frais_dossier*(1-IS))","v":{"v":0,"d":"0.00 "}},{"$f":"E3+(frais_dossier*(1-IS))","v":{"v":0,"d":"0.00 "}}]
[null,{"v":1,"d":"1ère année"},{"$f":"IF(B8>durée_emprunt,0,-PMT($G$4,durée_emprunt,capital_emprunté))","v":{"v":0,"d":"0.00 "}},{"$f":"C8-E8","v":{"v":0,"d":"0.00 "}},{"$f":"C8*(1-(1/(1+taux_emprunt)^(durée_emprunt-B8+1)))","v":{"v":0,"d":"0.00 "}},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G6)","v":{"v":0,"d":"0.00 "}},{"$f":"ROUND((E8+F8)*IS,2)","v":{"v":0,"d":"0.00 "}},{"$f":"C8-G8","v":{"v":0,"d":"0.00 "}},{"$f":"H8/(POWER((1+tx_actualisation),B8))","v":{"v":0,"d":"0.00 "}}]
[null,{"$f":"B8+1","v":{"v":2,"d":"2ème année"}},{"$f":"IF(B9>durée_emprunt,0,-PMT($G$4,durée_emprunt,capital_emprunté))","v":{"v":0,"d":"0.00 "}},{"$f":"C9-E9","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G7)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":3,"d":"3ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G8)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":4,"d":"4ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G9)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":5,"d":"5ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G10)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":6,"d":"6ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G11)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":7,"d":"7ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G12)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":8,"d":"8ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G13)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":9,"d":"9ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G14)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":10,"d":"10ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G15)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":11,"d":"11ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G16)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":12,"d":"12ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G17)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":13,"d":"13ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G18)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":14,"d":"14ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G19)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":15,"d":"15ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G20)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":16,"d":"16ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G21)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":17,"d":"17ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G22)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":18,"d":"18ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G23)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":19,"d":"19ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G24)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":20,"d":"20ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(capital_emprunté=0,0,'Autofinancement total'!G25)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Total",{"$f":"SUM(C7:C27)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(D7:D27)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(E7:E27)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(F7:F27)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(G7:G27)","v":{"v":0,"d":"0.00 "}},{"$f":"E3+SUM(H8:H27)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(I7:I27)","v":{"v":0,"d":"0.00 "}}]

{"sheet":"Financement par crédit-bail","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[1,1,1,2],[2,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,5]]}
[]
[null,"Financement par crédit-bail"]
[null,"Années "," Durée",null,"Taux"]
[null,null,"Loyers de crédit-bail","Economie d'impôt","Décaissements"]
[{"$nulls":4},"nets","actualisés"]
[null,{"v":1,"d":"1ère année"},{"$f":"ROUND(IF(B6>durée_créditbail,0,PMT(Taux_creditbail,durée_créditbail,-capital_investi,0)),2)","v":{"v":0,"d":"0.00 "}},{"$f":"ROUND(C6*IS,2)","v":{"v":0,"d":"0.00 "}},{"$f":"C6-D6","v":{"v":0,"d":"0.00 "}},{"$f":"E6/(POWER((1+tx_actualisation),B6))","v":{"v":0,"d":"0.00 "}}]
[null,{"$f":"B6+1","v":{"v":2,"d":"2ème année"}},{"v":0,"d":"0.00 "},{"$f":"ROUND(C7*IS,2)","v":{"v":0,"d":"0.00 "}},{"$f":"C7-D7","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "}]
[null,{"v":3,"d":"3ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":4,"d":"4ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":5,"d":"5ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":6,"d":"6ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":7,"d":"7ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":8,"d":"8ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":9,"d":"9ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":10,"d":"10ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":11,"d":"11ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":12,"d":"12ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":13,"d":"13ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":14,"d":"14ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":15,"d":"15ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":16,"d":"16ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":17,"d":"17ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":18,"d":"18ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":19,"d":"19ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,{"v":20,"d":"20ème année"},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Total",{"$f":"SUM(C6:C25)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(D6:D25)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(E6:E25)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(F6:F25)","v":{"v":0,"d":"0.00 "}}]