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

{"sheet":"Feuil1","index":0,"n_rows":3,"n_cols":84,"rows_kept":3}
["Nom de l'entreprise","Nom complet de l'entreprise","Adresse Ent","C.P.","Siret N°","Téléphone","Technicien Sydela","N°Dossier","Ancien N°dossier","DOS GMAO","Année de marché","Date demande","Collectivité","Insee","N° lot","Pétitionnaire","Téléphone2","Lieu dit","Type d'anomalie","info text","Eligible CEE (oui)","Demande DV transmis Ent.","Devis reçu","Ref devis SYDELA","Montant BPU 'ht'","ht' avec coef TP12c","ht' avec coef TP12c+ent","HB 'ht'","BPU+HB 'ht'","Eco-contribution","TOTAL BPU+HB TTC","Info (Imputation)","Imputation","Date de mise à disposition","Régime MO urbain/rural","Participation du Sydela rénovation d'armoire (régime MO)","Participation du Sydela 'ht' hors eco-contrib","TVA sur le montant total 'ht'","Montant a charge du Sydela 'ttc'","Participation de la coll","Participation coll 'ht'","Eco-contribution 'ht'","Montant à la charge de la collectivité 'ht'","Ref entreprise","Devis vérifié Tech","Obs","Devis transmis coll","Devis retour signé coll","Statut","Délai d'éxecution","Date création BC","Exercice","N° Dossier","N° du Bon de Commande","info engagement","Engagement initial Ent.TTC","Date engagement complémentaire","Engagement ComplémentaireTTC","Participation coll 'HT' NE RIEN SAISIR","Engagé dans compta","BC envoyé Ent","Planification","Planif transmise \"Coll\"","Contrôle OK pour facturation \"tech\"","Réserves","Etat envoyé \"Ent\" le","Facture présenté au Sydela ou Mandat saisie le","Montant libérable après mandat","Avis envoyé coll et transmission service compta","Titre saisie le ","Mise à jour SIG","Dossier a Archivé","N°affaire archive ","Côte","Date départ pénalité","Date échéance pénalité","Ecart total","nb de jour pénalisable CCTP","Montant pénalité 'ht'","Applicable","Titré","Marché public","Marché num","Date marché"]
["TOTO","TOTO Service","Rue des galere","44000 Macro compliqué",25,"02.40.01.02.03","Votre serviteur","19-049",null,null,2019,"2019-01-30","MALVILLE",{"$f":"RIGHT(VLOOKUP(M2,[1]listecoll!$B$2:$G$245,2,FALSE),3)","v":"089"},{"$f":"VLOOKUP(M2,[1]listecoll!$B$2:$G$245,4,FALSE)","v":"LOTB"},null,null,"Rue de droite / Ensembles 089_178, 089_179 et 089_219","Devis pour la dépose de 3 candélabres suite aux travaux du restaurant scolaire",null,null,"SANS OBJET","2019-01-31",{"$f":"CONCATENATE(\"DV\",H2)","v":"DV19-049"},{"v":631.8,"d":"631.80 €"},{"$f":"ROUND(Y2*(IF(AND(K2=2019,OR(O2=\"LotA\",O2=\"LotC\")),[1]liste!$G$12,IF(AND(K2=2019,OR(O2=\"LotB\",O2=\"LotD\",O2=\"LotE\")),[1]liste!$F$12,IF(AND(K2=2020,OR(O2=\"LotA\",O2=\"LotC\")),[1]liste!$G$13,IF(AND(K2=2020,OR(O2=\"LotB\",O2=\"LotD\",O2=\"LotE\")),[1]liste!$F$13,))))),2)","v":{"v":654.54,"d":"654.54 €"}},{"$f":"ROUND(Z2*(IF(O2=\"LotA\",1.075,IF(O2=\"LotB\",0.99,IF(O2=\"LotC\",1.039,IF(O2=\"LotD\",0.975,IF(O2=\"LotE\",0.98)))))),2)","v":{"v":647.99,"d":"647.99 €"}},null,{"$f":"ROUND(AA2+AB2,2)","v":{"v":647.99,"d":"647.99 €"}},null,{"$f":"ROUND((AC2+AD2)*1.2,2)","v":{"v":777.59,"d":"777.59 €"}},"fonct avec M.A.D",{"$f":"VLOOKUP(AF2,[1]liste!$H$10:$I$13,2,FALSE)","v":814615232},{"$f":"VLOOKUP(M2,[1]listecoll!$B$2:$J$245,8,FALSE)","v":"2017-01-01"},{"$f":"VLOOKUP(M2,[1]listecoll!$B$2:$J$245,9,TRUE)","v":"rural"},null,{"$f":"AC2*AJ2","v":{"v":0,"d":"0.00 €"}},{"$f":"ROUND(IF(AF2=\"invest avec M.A.D\",((AC2+AD2)*1.2)-(AC2+AD2)),2)","v":{"v":0,"d":"0.00 €"}},{"$f":"ROUND(AK2+AL2,2)","v":{"v":0,"d":"0.00 €"}},{"$f":"100%-AJ2","v":{"v":1,"d":"100%"}},{"$f":"ROUND(IF(AF2=\"invest avec M.A.D\",(AC2-AK2)),2)","v":{"v":0,"d":"0.00 €"}},{"$f":"AD2","v":{"v":0,"d":"0.00 €"}},{"$f":"ROUND(AO2+AP2,2)","v":{"v":0,"d":"0.00 €"}},null,"OK FF","SANS OBJET","2019-01-31","2019-01-31","Tvx En cours","1 mois","2019-02-01",2019,"TS0519",{"$f":"CONCATENATE(IF(AND(K2=2019,OR(O2=\"LotA\",O2=\"LotC\")),\"2018018\",IF(AND(K2=2019,OR(O2=\"LotB\",O2=\"LotD\",O2=\"LotE\")),\"2016003\",IF(AND(K2=2020,OR(O2=\"LotA\",O2=\"LotC\")),\"2018018\",IF(AND(K2=2020,OR(O2=\"LotB\",O2=\"LotD\",O2=\"LotE\")),\"2016003\",)))),\"-\",IF(AND(K2=2019,OR(O2=\"LotA\",O2=\"LotC\")),\"OS1\",IF(AND(K2=2019,OR(O2=\"LotB\",O2=\"LotD\",O2=\"LotE\")),\"OS2\",IF(AND(K2=2020,OR(O2=\"LotA\",O2=\"LotC\")),\"OS1\",IF(AND(K2=2020,OR(O2=\"LotB\",O2=\"LotD\",O2=\"LotE\")),\"OS2\",)))),\"-\", O2,\"-\", N2,\"-\",BA2)","v":"2016003-OS2-LOTB-089-TS0519"},{"$f":"AE2","v":{"v":777.59,"d":"777.59 €"}},{"v":777.59,"d":"777.59 €"},null,null,{"$f":"IF(AQ2>0,AQ2,0)","v":{"v":0,"d":"0.00 €"}},null,"2019-02-01","S06-2019","2019-02-01",{"$nulls":11},{"$f":"V2","v":"SANS OBJET"},"2019-01-31",{"$f":"DATEDIF(BW2,BX2,\"d\")","v":{"$error":"#VALUE!"}},{"$f":"[1]tvx!$BY2-8","v":{"$error":"#NUM!"}},{"$f":"[1]tvx!$BZ2*10","v":{"$error":"#NUM!"}}]
[{"$f":"CONCATENATE(LaDate,\"_MAI_BDC_\",A2,\"_\",BA2)","v":{"$error":"#NAME?"}}]