{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Loyers constants"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Loyers constants","index":0,"n_rows":93,"n_cols":7,"rows_kept":93,"merged":[[1,1,1,2],[1,3,1,5],[3,3,3,4],[4,3,4,4],[5,3,5,4]]}
[]
[null,"Nom de l'entreprise"]
[]
[null,"Montant",null," Durée du contrat"]
[null,"Taux",null," Valeur résiduelle"]
[null,"Périodicité",null," Nombre de loyers",null,{"$f":"IF(C6=\"annuelle\",F4,IF(C6=\"mensuelle\",F4*12,IF(C6=\"trimestrielle\",F4*4,0)))","v":0},{"$f":"F6+1","v":1}]
[null,"N°","Encours","Capital","Intérêts","Loyer HT",{"$f":"IF(C6=\"annuelle\",C5,IF(C6=\"mensuelle\",C5/12,IF(C6=\"trimestrielle\",C5/4,0)))","v":{"v":0,"d":"0.00%"}}]
[1,{"$f":"IF(AND(A8=$G$6,$F$5>0),\"VR\",IF(AND(A8=$G$6,$F$5=0),0,(IF(A8>$G$6,0,A8))))","v":0},{"$f":"IF(F6=0,0,C4)","v":{"v":0,"d":"0.00 "}},{"$f":"IF(A8=$G$6,$F$5,IF(A8>$G$6,0,F8-E8))","v":{"v":0,"d":"0.00 "}},{"$f":"IF(A8>$F$6,0,C8*$G$7)","v":{"v":0,"d":"0.00 "}},{"$f":"IF(ISERROR(PMT(G7,F6,-C4,F5,0)),0,PMT(G7,F6,-C4,F5,0))","v":{"v":0,"d":"0.00 "}}]
[{"$f":"A8+1","v":2},0,{"$f":"IF(A9>$G$6,0,C8-D8)","v":{"v":0,"d":"0.00 "}},{"$f":"IF(A9=$G$6,$F$5,IF(A9>$G$6,0,F9-E9))","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"$f":"IF(B9=0,0,IF(B9=\"VR\",D9,F8))","v":{"v":0,"d":"0.00 "}}]
[{"$f":"A9+1","v":3},0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(B10=0,0,IF(B10=\"VR\",D10,F9))","v":{"v":0,"d":"0.00 "}}]
[4,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[5,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[6,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[7,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[8,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[9,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[10,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[11,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[12,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[13,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[14,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[15,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[16,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[17,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[18,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[19,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[20,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[21,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[22,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[23,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[24,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[25,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[26,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[27,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[28,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[29,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[30,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[31,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[32,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[33,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(A40>$F$6,0,C40*$G$7)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "}]
[34,0,{"$f":"IF(A41>$G$6,0,C40-D40)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[35,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[36,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[37,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[38,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[39,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[40,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[41,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[42,0,{"v":0,"d":"0.00 "},{"$f":"IF(A49=$G$6,$F$5,IF(A49>$G$6,0,F49-E49))","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[43,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[44,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[45,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[46,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[47,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[48,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[49,{"$f":"IF(AND(A56=$G$6,$F$5>0),\"VR\",IF(AND(A56=$G$6,$F$5=0),0,(IF(A56>$G$6,0,A56))))","v":0},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[50,{"$f":"IF(AND(A57=$G$6,$F$5>0),\"VR\",IF(AND(A57=$G$6,$F$5=0),0,(IF(A57>$G$6,0,A57))))","v":0},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[51,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[52,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[53,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[54,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[55,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[56,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[57,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[58,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[59,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[60,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[61,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[62,0,{"$f":"IF(A69>$G$6,0,C68-D68)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[63,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[64,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[65,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(A72>$F$6,0,C72*$G$7)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "}]
[66,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[{"$f":"A73+1","v":67},0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(B74=0,0,IF(B74=\"VR\",D74,F73))","v":{"v":0,"d":"0.00 "}}]
[68,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[69,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[70,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[71,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[72,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[73,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[74,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[75,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[76,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[77,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"IF(B84=0,0,IF(B84=\"VR\",D84,F83))","v":{"v":0,"d":"0.00 "}}]
[78,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[79,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[80,0,{"$f":"IF(A87>$G$6,0,C86-D86)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[81,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[82,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[83,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[84,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[85,0,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,null,"Total",{"$f":"SUM(D8:D92)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(E8:E92)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(F8:F92)","v":{"v":0,"d":"0.00 "}}]