{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Feuil1","index":0,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[9,4,9,7],[9,12,9,13],[11,4,11,7],[11,12,11,13],[24,13,24,14],[15,9,15,11],[16,9,16,11],[17,9,17,11],[22,9,22,11],[21,4,21,7],[21,9,21,11],[21,12,21,14],[22,12,22,13],[22,5,22,6]]}
[]
[null,null,"IMMO BOX",null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-03-01"}]
[]
[]
[null,null,null,null,null,"REPORT CONTRACTUEL D'ECHEANCE PRIMO"]
[]
[]
[null,null,"identification du dossier de crédit immobilier"]
[]
[null,null,"nom du client",null,null,null,null,null,null,null,null,"n° du crédit"]
[]
[null,null,"Instructeur commercial",null,null,null,null,null,null,null,null,"Agence"]
[]
[null,null,"1er partie : la saisie des données financières"]
[]
[null,null,"échéance mensuelle actuelle ",null,null,null,null,null,null,"Date de prise d'effet"]
[null,null,"dont prime CNP",null,null,null,null,null,null,"taux du crédit actuel"]
[null,null,"durée restante (mois) ",null,null,null,null,null,null,"durée de report en mois"]
[]
[null,null,"2nd partie : le montant des échéances période par période (après report)"]
[]
[null,null,"Échéance habituelle",null,"zone de report",null,null,null,null,"Échéances habituelles",null,null,"Échéances majorées"]
[null,null,{"$f":"E16","v":0},null,null,{"$f":"E29","v":0},null,null,null,{"$f":"C23","v":0},null,null,{"$f":"E32","v":0}]
[]
[null,null,{"$f":"M16","v":"00:00:00"},null,{"$f":"IF(M18=\"\",\"\",E28)","v":""},null,null,{"$f":"E30","v":"00:00:00"},null,null,null,{"$f":"IF(M18=\"\",\"\",E31)","v":""},null,{"$f":"IF(M18=\"\",\"\",E36)","v":""}]
[]
[]
[null,null,"prochaine échéance au ",null,{"$f":"EDATE(M16,1)","v":"1900-01-31"}]
[null,null,"montant (accessoires seuls) ",null,{"$f":"+E17","v":0}]
[null,null,"retour à l'échéance d'origine au ",null,{"$f":"EDATE(M16,M18)","v":"00:00:00"}]
[null,null,"échéances reportées au ",null,{"$f":"EDATE(M16,E18+1)","v":"1900-01-31"}]
[null,null,"montant mensuel ",null,{"$f":"SUM(E33:E35)","v":0}]
[null,null,"dont échéance hors accessoires",null,{"$f":"+E16-E17","v":0}]
[null,null,"dont accessoires (assurances) ",null,{"$f":"+E17","v":0}]
[null,null,"dont intérêts sur échéances reportées ",null,{"$f":"+E$33*M$17*E$18/12","v":0}]
[null,null,"jusqu'au ",null,{"$f":"EDATE(E31,M18)","v":"1900-01-31"}]
[null,null,"coût total du report ",null,{"$f":"+(E32-E33)*M18","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Estimation du cout du report : ",null,{"$f":"E37","v":0}]
[]
[null,null,"(simulation non contractuelle ayant valeur de renseignement administratif) ",null,null,null,null,null,null,null,null,"nouvelle saisie","impression"]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}