{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["FEUILLE DE TRAVAIL VIERGE","Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"comments":0,"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":"FEUILLE DE TRAVAIL VIERGE","index":0,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[[40,0,40,1],[42,0,42,1],[36,0,36,1],[15,0,15,1],[31,0,31,3],[16,0,16,1],[16,2,16,3],[18,0,18,1],[18,2,18,3],[38,0,38,1],[5,0,8,5],[0,2,1,3],[0,4,0,5],[1,4,1,5],[2,2,3,2],[4,0,4,5],[9,0,9,5],[32,0,32,3],[33,0,33,3],[34,0,34,5],[11,0,11,1],[13,0,13,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[11,2,11,3],[13,2,13,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[15,2,15,3],[73,0,73,5],[76,0,76,5],[74,2,75,3],[61,0,61,3],[48,0,48,3],[49,0,49,5],[62,0,62,3],[63,0,63,5]]}
["CLIENT ",null,"AVANCE",null,"NUMERO DOSSIER"]
["COLLABORATEUR"]
["RCP",null,"CABINET","COMMANDE PUBLIQUE"]
["ASSOCIE RESPONSABLE",null,null,null,"DATE :"]
[]
["Objectifs:\n\n"]
[]
[]
[]
["INFORMATIONS"]
[]
["Type de consultation",null,1]
[]
[{"$f":"IF(C12=2,\"Montant du marché ordinaire ou marché subséquent (en €) \",\"\")","v":""},null,51000]
[]
[{"$f":"IF(C12=3,\"Accord-cadre à bons de commande avec ou sans minimum\",\"\")","v":""},null,1]
[{"$f":"IF(C16=2,\"Montant minimum de l'accord-cadre (en €)\",IF(C16=3,\"Montant du bon de commande (en €)\",\"\"))","v":""}]
[]
[{"$f":"IF(C12=4,\"Montant du marché à tranches en (€)\",\"\")","v":""}]
[]
["Durée du marché / de l'accord-cadre / de la tranche (en mois)",null,24]
[]
["Part sous-traité (en €)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(E14=\"x\",\"ok\",IF(AND(OR(E24=\"x\",E25=\"x\",E26=\"x\",E27=\"x\",E28=\"x\",E29=\"x\",E30=\"x\")),\"ok\",\"à effectuer\"))","v":"à effectuer"}]
[]
[]
["MONTANT DE L'AVANCE DU TITULAIRE"]
[]
["L'avance est possible?",null,{"$f":"IF(C21>2,IF(AND(OR(C14>50000,C17>50000,C19>50000)),\"OUI\",\"NON\"))","v":"OUI"}]
[]
[{"$f":"IF(C12=2,\"Montant de l'avance en cas de marché ordinaire ou marché subséquent\",\"\")","v":""},null,{"$f":"IF(AND(C37=\"oui\",C12=2),IF(C21<12,C14*5%,(C14/C21)*12*5%))","v":false}]
[]
[{"$f":"IF(C12=3,\"Montant de l'avance en cas d'accord-cadre à bon de commande\",\"\")","v":""},null,{"$f":"IF(AND(C37=\"oui\",C12=3),IF(C21<12,C17*5%,(C17/C21)*12*5%))","v":false}]
[]
[{"$f":"IF(C12=4,\"Montant de l'avance en cas de marché à tranches\",\"\")","v":""},null,{"$f":"IF(AND(C37=\"oui\",C12=4),IF(C21<12,C19*5%,(C14/C19)*12*5%))","v":false}]
[]
[]
[]
[]
[]
[]
["MONTANT DE L'AVANCE DU SOUS-TRAITANT"]

{"sheet":"Feuil1","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["marché ordinaire ou marché subséquent","16,17,19",null,"inf a 12 mois","sup à 12 mois"]
["accord-cadre à bons de commande","14,19",null,"inf a 12 mois","sup à 12 mois"]
["marché à tranches","16,17,14"]
[]
[]
[]
["avec minimum"]
["sans montant minimum"]