{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Intérêt simple","Prêt personnel","Feuil3"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Intérêt simple","index":0,"n_rows":37,"n_cols":18,"rows_kept":37,"merged":[[1,1,1,6],[3,2,3,4]]}
[]
[null,"Calcul d'intérêts simples"]
[]
[null,null,"Données",{"$nulls":3},"Solutions"]
[null,null,"Capital",{"$f":"IF(E5=0,\"?\",\"\")","v":""},1000,"fr",{"$f":"IF(D5=\"?\",E8*36000/(E6*E7),\"\")","v":""}]
[null,"donner 3 ","Taux",{"$f":"IF(E6=0,\"?\",\"\")","v":"?"},null,"%",{"$f":"IF(D6=\"?\",E8*36000/(E5*E7),\"\")","v":{"$error":"#DIV/0!"}}]
[null,"valeurs sur 4","Nb de jours",{"$f":"IF(E7=0,\"?\",\"\")","v":"?"},null,"n",{"$f":"IF(D7=\"?\",E8*36000/(E5*E6),\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,"Intérêt brut",{"$f":"IF(E8=0,\"?\",\"\")","v":"?"},null,"fr",{"$f":"IF(D8=\"?\",E5*E6*E7/36000,\"\")","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"Cap + int ","fr",{"$f":"SUM(R5:R8)","v":0}]
[]
[null,"Impôt anticipé"]
[]
[null,"donner 1 des","Intérêt brut",{"$f":"IF(E13=0,\"?\",\"\")","v":"?"},null,"fr",{"$f":"IF(D13=\"?\",IF(D14=\"?\",E15/65*100,E14/35*100),E13)","v":{"v":0,"d":"0.00"}}]
[null,"3 valeurs","Impôt ant.",{"$f":"IF(E14=0,\"?\",\"\")","v":"?"},null,"fr",{"$f":"IF(D14=\"?\",IF(D15=\"?\",E13/100*35,E15/65*35),E14)","v":{"v":0,"d":"0.00"}}]
[null,null,"Intérêt net",{"$f":"IF(E15=0,\"?\",\"\")","v":"?"},null,"fr",{"$f":"IF(D15=\"?\",IF(D14=\"?\",E13/100*65,E14/35*65),E15)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Capital + Intérêt connus"]
[]
[null,"donner les","C+i",{"$f":"IF(E19=0,\"?\",\"\")","v":"?"},null,"fr"]
[null,"3 valeurs","Taux",{"$f":"IF(E20=0,\"?\",\"\")","v":"?"},null,"%"]
[null,null,"Nb de jours",{"$f":"IF(E21=0,\"?\",\"\")","v":"?"},null,"n"]
[]
[null,null,"Capital ",null,"-------->","fr",{"$f":"(36000*E19)/(36000+(E20*E21))","v":{"v":0,"d":"0.00"}}]
[null,null,"Intérêt",null,"-------->","fr ",{"$f":"E19-G23","v":{"v":0,"d":"0.00"}}]
[]
[null,"Recherche de la durée entre deux dates"]
[]
[null,"Entrer les dates","du",{"$f":"IF(E28=\"\",\"?\",\"\")","v":"?"}]
[null,"comme indiqué","au",{"$f":"IF(E29=\"\",\"?\",\"\")","v":"?"}]
[null,"dans l'exemple",{"$nulls":7},"date réelle",null,null,"correction",null,"année"]
[null,"ci-dessous :",null,null,"année",{"$nulls":4},"j.","m.","a.","j.","m.","bissextile",null,"calculs"]
[null," 6.3.93",null,null,"commerciale",null,"civile",null,"Début",{"$f":"DAY(E28)","v":0},{"$f":"MONTH(E28)","v":1},{"$f":"YEAR(E28)+1900","v":3800},{"$f":"IF(K32=2,IF(O32=1,IF(J32=29,30,J32),IF(J32=28,30,J32)),IF(J32=31,30,J32))","v":0},{"$f":"K32","v":1},{"$f":"IF(L32/100=INT(L32/100),IF(L32/400=INT(L32/400),1,0),IF(L32/4=INT(L32/4),1,0))","v":0}]
[null,null,"Nb. de jours :",null,{"$f":"J36","v":0},null,{"$f":"J37","v":0},null,"fin",{"$f":"DAY(E29)","v":0},{"$f":"MONTH(E29)","v":1},{"$f":"YEAR(E29)+1900","v":3800},{"$f":"IF(K33=2,IF(O33=1,IF(J33=29,30,J33),IF(J33=28,30,J33)),IF(J33=31,30,J33))","v":0},{"$f":"IF(L33-L32>0,K33+12,K33)","v":1},{"$f":"IF(L33/100=INT(L33/100),IF(L33/400=INT(L33/400),1,0),IF(L33/4=INT(L33/4),1,0))","v":0},null,"nb j.",{"$f":"30-M32+M33","v":30}]
[{"$nulls":16},"nb m.",{"$f":"(N33-N32-1)*30","v":-30}]
[{"$nulls":8},"nb. de jours",{"$nulls":7},"nb a.",{"$f":"IF(L33-L32>1,(L33-L32-1)*360,0)","v":0}]
[{"$nulls":8},"année commer.",{"$f":"R36","v":0},{"$nulls":4},"total :",null,null,{"$f":"SUM(R33:R35)","v":0}]
[{"$nulls":8},"année civile",{"$f":"E29-E28","v":"00:00:00"}]

{"sheet":"Prêt personnel","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"merged":[[1,1,1,7]]}
[]
[null,"Prêt personnel"]
[]
[]
[null,"Montant de l'emprunt :",null,{"v":9000,"d":"9,000.00"},"CHF",null,"à compléter"]
[null,"Nombre de remboursements :",null,12,"mois"]
[null,"Premier versement dans :",null,2,"mois"]
[null,"Taux réel :",null,8,"%"]
[]
[]
[null,"Durée du crédit :",null,{"$f":"D6+D7","v":14},"mois",null,"solution"]
[null,"Durée moyenne du crédit :",null,{"$f":"D7+((D6-1)/2)","v":7.5},"mois"]
[null,"Coût de l'emprunt :",null,{"$f":"D5*D8*D12/1200","v":450},"CHF"]
[null,"Montant à rembourser :",null,{"$f":"D5+D13","v":{"v":9450,"d":"9,450.00"}},"CHF"]
[null,"Montant d'une mensualité",null,{"$f":"D14/D6","v":787.5},"CHF"]
[]
[null,"Taux des imbéciles",null,{"$f":"(D13*1200)/(D5*D11)","v":{"v":4.285714285714286,"d":"4.286"}},"%",null,"information"]

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}