{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Bordereaux de prix V_14_7","Cadre d'offre V_14_7","Chiffre_Lettre"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":44,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chiffre_Lettre","index":2,"reason":"part_missing"}],"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":"Bordereaux de prix V_14_7","index":0,"n_rows":90,"n_cols":29,"rows_kept":90,"cut":false,"hidden":false,"merged":[[89,0,89,5],[32,1,32,4],[34,1,35,4],[36,1,37,4],[2,0,2,5],[3,0,3,5],[4,0,4,5],[10,0,10,5],[5,0,5,5],[7,0,7,5],[30,0,30,5],[19,0,19,5],[28,0,28,5],[24,0,24,5],[20,0,23,5],[11,0,11,5],[12,0,12,5],[5,60,5,65],[5,66,5,71],[5,72,5,77],[5,78,5,83],[5,36,5,41],[5,42,5,47],[5,48,5,53],[5,54,5,59],[6,60,6,65],[6,66,6,71],[6,72,6,77],[6,78,6,83],[5,108,5,113],[5,114,5,119],[5,120,5,125],[5,126,5,131],[5,84,5,89],[5,90,5,95],[5,96,5,101],[5,102,5,107],[5,168,5,173],[5,174,5,179],[5,132,5,137],[5,138,5,143],[5,144,5,149],[5,150,5,155],[5,240,5,245],[5,246,5,251],[5,204,5,209],[5,210,5,215],[5,216,5,221],[5,222,5,227],[5,228,5,233],[5,234,5,239],[5,180,5,185],[5,186,5,191],[5,192,5,197],[5,198,5,203],[6,84,6,89],[6,90,6,95],[6,96,6,101],[6,102,6,107],[6,192,6,197],[6,198,6,203],[6,156,6,161],[6,162,6,167],[6,168,6,173],[6,174,6,179],[5,156,5,161],[5,162,5,167],[5,252,5,255],[6,0,6,5],[6,36,6,41],[6,42,6,47],[6,48,6,53],[6,54,6,59],[6,132,6,137],[6,138,6,143],[6,144,6,149],[6,150,6,155],[6,108,6,113],[6,114,6,119],[6,120,6,125],[6,126,6,131],[6,180,6,185],[6,186,6,191],[6,204,6,209],[6,210,6,215],[6,216,6,221],[6,246,6,251],[6,252,6,255],[6,222,6,227],[6,228,6,233],[6,234,6,239],[6,240,6,245]]}
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(C1),\"N\",\"O\")","v":"N"}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(C2),\"N\",\"O\")","v":"N"}]
["DÉLÉGATION GÉNÉRALE ADJOINTE",null,null,null,null,null,"N"]
["Ville plus Verte et plus Durable",null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
["Direction de l'Architecture et de la Valorisation des Equipements et de leurs Usage",null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
["DIAGNOSTICS DES RESEAUX D'EAU INTERIEURS",null,null,null,null,null,"N"]
["POUR LES RISQUES DE LEGIONELLES",null,null,null,null,null,"N"]
["DANS LES BATIMENTS DE LA VILLE DE MARSEILLE",null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
["Bordereau de Prix Unitaires",null,null,null,null,null,"N"]
["DIAGNOSTICS DES RESEAUX D'EAU INTERIEURS POUR LES RISQUES DE LEGIONELLES - CARNETS SANITAIRES",null,null,null,null,null,{"$f":"IF(ISBLANK(#REF!),\"N\",\"O\")","v":"O"}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(#REF!),\"N\",\"O\")","v":"O"}]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(C21),\"N\",\"O\")","v":"N"}]
["Consultation N° 2022_50001_0022",null,null,null,null,null,{"$f":"IF(ISBLANK(C22),\"N\",\"O\")","v":"N"}]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
["LOT N° 2 : 2ème, 3ème, 4ème, 5ème, 13ème, 14ème, 15ème et 16ème arrondissements",null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
["1 SEUL PRIX MANQUANT ENTRAINERA LE REJET DE L'OFFRE",null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,"NOM ENTREPRISE",null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N",{"$f":"COUNTA(G1:G40)","v":40}]
[null,null,null,null,null,null,"N"]
[null,null,null,"PRIX","Prix unitaire en € HT",null,{"$f":"IF(ISBLANK(C42),\"N\",\"O\")","v":"N"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verif.","allignement","alligement","Nbr caract"]
["N° ARTICLE","PRESTATIONS","UNITE","UNITAIRE € HT","en toutes lettres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prix","article/prix","article/uo","N° article"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,{"$f":"IF(ISNUMBER(D45),Lettre(D45),\"\")","v":""},null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(C45),IF(ISBLANK(D45),\"\",\"prix mal renseigné\"),IF(ISBLANK(D45),\"prix non renseigné\",\"\"))","v":""},{"$f":"IF(ISBLANK(D45),IF(ISBLANK(C45),\"ok\",\"Probleme\"),IF(ISBLANK(C45),\"Probleme\",\"ok\"))","v":"ok"},{"$f":"IF(ISBLANK(A45),IF(ISBLANK(C45),\"ok\",\"Probleme\"),IF(ISBLANK(C45),\"Probleme\",\"ok\"))","v":"ok"},{"$f":"IF(LEN(A45)<>0,IF(LEN(A45)<>14,\"Probleme\",\"ok\"),\"ok\")","v":"ok"}]
["T 99 00 000 00","PRESTATION COMMUNES ET ANNEXES A CHAQUE CORPS D'ETAT",null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(C46),IF(ISBLANK(D46),\"\",\"prix mal renseigné\"),IF(ISBLANK(D46),\"prix non renseigné\",\"\"))","v":""},{"$f":"IF(ISBLANK(D46),IF(ISBLANK(C46),\"ok\",\"Probleme\"),IF(ISBLANK(C46),\"Probleme\",\"ok\"))","v":"ok"},{"$f":"IF(ISBLANK(A46),IF(ISBLANK(C46),\"ok\",\"Probleme\"),IF(ISBLANK(C46),\"Probleme\",\"ok\"))","v":"Probleme"},{"$f":"IF(LEN(A46)<>0,IF(LEN(A46)<>14,\"Probleme\",\"ok\"),\"ok\")","v":"ok"}]
["T 99 01 060 00","DISPOSITIONS PARTICULIERES CONCERNANT L' ARCHIPEL DU FRIOUL",null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","Probleme","ok"]
["T 99 01 060 01","ILE DU FRIOUL TITRE DE TRANSPORT ET TEMPS DEPLACEMENT","U",null,"",null,"O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prix non renseigné","Probleme","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
["P CL 00 001 00","ETAT DES LIEUX ET DES INSTALLATIONS",null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","Probleme","ok"]
["P CL 00 001 01","Schéma sur la base d'un fond de plan fourni","U",null,"",null,"O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prix non renseigné","Probleme","ok","ok"]
["P CL 00 001 02","Schéma sans fond de plan fourni","m2",null,"",null,"O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prix non renseigné","Probleme","ok","ok"]
["P CL 00 001 03","Rapport d'audit-assistance et préconisations","U",null,"",null,"O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prix non renseigné","Probleme","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
["P CL 00 002 00","HISTORIQUE TECHNIQUE DE L’INSTALLATION",null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","Probleme","ok"]
["P CL 00 002 01","Analyse des documents de l'installation inspectée","U",null,"",null,"O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prix non renseigné","Probleme","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,{"$f":"IF(ISBLANK(C66),\"N\",\"O\")","v":"N"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
["P CL 00 003 00","MESURES ET ANALYSES",null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","Probleme","ok"]
["P CL 00 003 01","Mesures des performances hydrauliques","le point",null,"",null,"O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prix non renseigné","Probleme","ok","ok"]
["P CL 00 003 02","Analyse du risque de retour d'eau","U",null,"",null,"O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prix non renseigné","Probleme","ok","ok"]
["P CL 00 003 03","Analyse de conformité générale","U",null,"",null,"O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prix non renseigné","Probleme","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
["P CL 00 004 00","CARNET DE SUIVI SANITAIRE",null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","Probleme","ok"]
["P CL 00 004 01","Elaboration d'un carnet sanitaire","U",null,"",null,"O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prix non renseigné","Probleme","ok","ok"]
["P CL 00 004 02","Mise à jour d'un carnet sanitaire","U",null,"",null,"O",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prix non renseigné","Probleme","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,null,{"$f":"IF(ISERROR(J80),\"\",J80)","v":""},{"$f":"IF(ISERROR(K80),\"\",K80)","v":""},{"$f":"IF(ISERROR(L80),\"\",L80)","v":""},"/",{"$f":"IF(ISERROR(N80),\"\",N80)","v":""},{"$f":"IF(ISERROR(O80),\"\",O80)","v":""},{"$f":"IF(ISERROR(P80),\"\",P80)","v":""},"/",{"$f":"IF(ISERROR(R80),\"\",R80)","v":""},{"$f":"IF(ISERROR(S80),\"\",S80)","v":""},{"$f":"IF(ISERROR(T80),\"\",T80)","v":""},"/",{"$f":"IF(ISERROR(V80),\"\",V80)","v":""},{"$f":"IF(ISERROR(W80),\"\",W80)","v":""},null,null,"","ok","ok","ok"]
[null,null,null,null,"",null,"N",null,{"$f":"LEN(I80)","v":0},13,12,11,10,9,8,7,6,5,4,3,2,1,0,null,null,"","ok","ok","ok"]
[{"$f":"\"T 00 00 0SM \" & TEXT(X80,\"00\")","v":"T 00 00 0SM 01"},{"$f":"\"Code de contrôle \"&TEXT(X80,\"00\")&\" : \"&J78&K78&L78&M78&N78&O78&P78&Q78&R78&S78&T78&U78&V78&W78","v":"Code de contrôle 01 : ///"},null," ","",null,"O",{"$f":"COUNTA(G41:G80)","v":39},{"$f":"IF(FIXED(SUM(D45:D79),2,FALSE)=\"0,00\",\"\",FIXED(SUM(D45:D79),2,FALSE))","v":""},{"$f":"IF((VALUE(MID(I80,I79-J79,1)))<4,IF((MID(I80,I79-J79,1))=\"0\",\"A\",IF(MID(I80,I79-J79,1)=\"1\",\"B\",IF(MID(I80,I79-J79,1)=\"2\",\"C\",IF(MID(I80,I79-J79,1)=\"3\",\"D\",)))),IF(MID(I80,I79-J79,1)=\"4\",\"E\",IF(MID(I80,I79-J79,1)=\"5\",\"F\",IF(MID(I80,I79-J79,1)=\"6\",\"G\",IF(MID(I80,I79-J79,1)=\"7\",\"H\",IF(MID(I80,I79-J79,1)=\"8\",\"I\",IF(MID(I80,I79-J79,1)=\"9\",\"J\",\"zz\")))))))","v":{"$error":"#VALUE!"}},{"$f":"IF((VALUE(MID(I80,I79-K79,1)))<4,IF((MID(I80,I79-K79,1))=\"0\",\"A\",IF(MID(I80,I79-K79,1)=\"1\",\"B\",IF(MID(I80,I79-K79,1)=\"2\",\"C\",IF(MID(I80,I79-K79,1)=\"3\",\"D\",)))),IF(MID(I80,I79-K79,1)=\"4\",\"E\",IF(MID(I80,I79-K79,1)=\"5\",\"F\",IF(MID(I80,I79-K79,1)=\"6\",\"G\",IF(MID(I80,I79-K79,1)=\"7\",\"H\",IF(MID(I80,I79-K79,1)=\"8\",\"I\",IF(MID(I80,I79-K79,1)=\"9\",\"J\",\"zz\")))))))","v":{"$error":"#VALUE!"}},{"$f":"IF((VALUE(MID(I80,I79-L79,1)))<4,IF((MID(I80,I79-L79,1))=\"0\",\"A\",IF(MID(I80,I79-L79,1)=\"1\",\"B\",IF(MID(I80,I79-L79,1)=\"2\",\"C\",IF(MID(I80,I79-L79,1)=\"3\",\"D\",)))),IF(MID(I80,I79-L79,1)=\"4\",\"E\",IF(MID(I80,I79-L79,1)=\"5\",\"F\",IF(MID(I80,I79-L79,1)=\"6\",\"G\",IF(MID(I80,I79-L79,1)=\"7\",\"H\",IF(MID(I80,I79-L79,1)=\"8\",\"I\",IF(MID(I80,I79-L79,1)=\"9\",\"J\",\"zz\")))))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF((VALUE(MID(I80,I79-N79,1)))<4,IF((MID(I80,I79-N79,1))=\"0\",\"A\",IF(MID(I80,I79-N79,1)=\"1\",\"B\",IF(MID(I80,I79-N79,1)=\"2\",\"C\",IF(MID(I80,I79-N79,1)=\"3\",\"D\",)))),IF(MID(I80,I79-N79,1)=\"4\",\"E\",IF(MID(I80,I79-N79,1)=\"5\",\"F\",IF(MID(I80,I79-N79,1)=\"6\",\"G\",IF(MID(I80,I79-N79,1)=\"7\",\"H\",IF(MID(I80,I79-N79,1)=\"8\",\"I\",IF(MID(I80,I79-N79,1)=\"9\",\"J\",\"zz\")))))))","v":{"$error":"#VALUE!"}},{"$f":"IF((VALUE(MID(I80,I79-O79,1)))<4,IF((MID(I80,I79-O79,1))=\"0\",\"A\",IF(MID(I80,I79-O79,1)=\"1\",\"B\",IF(MID(I80,I79-O79,1)=\"2\",\"C\",IF(MID(I80,I79-O79,1)=\"3\",\"D\",)))),IF(MID(I80,I79-O79,1)=\"4\",\"E\",IF(MID(I80,I79-O79,1)=\"5\",\"F\",IF(MID(I80,I79-O79,1)=\"6\",\"G\",IF(MID(I80,I79-O79,1)=\"7\",\"H\",IF(MID(I80,I79-O79,1)=\"8\",\"I\",IF(MID(I80,I79-O79,1)=\"9\",\"J\",\"zz\")))))))","v":{"$error":"#VALUE!"}},{"$f":"IF((VALUE(MID(I80,I79-P79,1)))<4,IF((MID(I80,I79-P79,1))=\"0\",\"A\",IF(MID(I80,I79-P79,1)=\"1\",\"B\",IF(MID(I80,I79-P79,1)=\"2\",\"C\",IF(MID(I80,I79-P79,1)=\"3\",\"D\",)))),IF(MID(I80,I79-P79,1)=\"4\",\"E\",IF(MID(I80,I79-P79,1)=\"5\",\"F\",IF(MID(I80,I79-P79,1)=\"6\",\"G\",IF(MID(I80,I79-P79,1)=\"7\",\"H\",IF(MID(I80,I79-P79,1)=\"8\",\"I\",IF(MID(I80,I79-P79,1)=\"9\",\"J\",\"zz\")))))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF((VALUE(MID(I80,I79-R79,1)))<4,IF((MID(I80,I79-R79,1))=\"0\",\"A\",IF(MID(I80,I79-R79,1)=\"1\",\"B\",IF(MID(I80,I79-R79,1)=\"2\",\"C\",IF(MID(I80,I79-R79,1)=\"3\",\"D\",)))),IF(MID(I80,I79-R79,1)=\"4\",\"E\",IF(MID(I80,I79-R79,1)=\"5\",\"F\",IF(MID(I80,I79-R79,1)=\"6\",\"G\",IF(MID(I80,I79-R79,1)=\"7\",\"H\",IF(MID(I80,I79-R79,1)=\"8\",\"I\",IF(MID(I80,I79-R79,1)=\"9\",\"J\",\"zz\")))))))","v":{"$error":"#VALUE!"}},{"$f":"IF((VALUE(MID(I80,I79-S79,1)))<4,IF((MID(I80,I79-S79,1))=\"0\",\"A\",IF(MID(I80,I79-S79,1)=\"1\",\"B\",IF(MID(I80,I79-S79,1)=\"2\",\"C\",IF(MID(I80,I79-S79,1)=\"3\",\"D\",)))),IF(MID(I80,I79-S79,1)=\"4\",\"E\",IF(MID(I80,I79-S79,1)=\"5\",\"F\",IF(MID(I80,I79-S79,1)=\"6\",\"G\",IF(MID(I80,I79-S79,1)=\"7\",\"H\",IF(MID(I80,I79-S79,1)=\"8\",\"I\",IF(MID(I80,I79-S79,1)=\"9\",\"J\",\"zz\")))))))","v":{"$error":"#VALUE!"}},{"$f":"IF((VALUE(MID(I80,I79-T79,1)))<4,IF((MID(I80,I79-T79,1))=\"0\",\"A\",IF(MID(I80,I79-T79,1)=\"1\",\"B\",IF(MID(I80,I79-T79,1)=\"2\",\"C\",IF(MID(I80,I79-T79,1)=\"3\",\"D\",)))),IF(MID(I80,I79-T79,1)=\"4\",\"E\",IF(MID(I80,I79-T79,1)=\"5\",\"F\",IF(MID(I80,I79-T79,1)=\"6\",\"G\",IF(MID(I80,I79-T79,1)=\"7\",\"H\",IF(MID(I80,I79-T79,1)=\"8\",\"I\",IF(MID(I80,I79-T79,1)=\"9\",\"J\",\"zz\")))))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF((VALUE(MID(I80,I79-V79,1)))<4,IF((MID(I80,I79-V79,1))=\"0\",\"A\",IF(MID(I80,I79-V79,1)=\"1\",\"B\",IF(MID(I80,I79-V79,1)=\"2\",\"C\",IF(MID(I80,I79-V79,1)=\"3\",\"D\",)))),IF(MID(I80,I79-V79,1)=\"4\",\"E\",IF(MID(I80,I79-V79,1)=\"5\",\"F\",IF(MID(I80,I79-V79,1)=\"6\",\"G\",IF(MID(I80,I79-V79,1)=\"7\",\"H\",IF(MID(I80,I79-V79,1)=\"8\",\"I\",IF(MID(I80,I79-V79,1)=\"9\",\"J\",\"zz\")))))))","v":{"$error":"#VALUE!"}},{"$f":"IF((VALUE(MID(I80,LEN(I80),1)))<4,IF((MID(I80,I79,1))=\"0\",\"A\",IF(MID(I80,I79,1)=\"1\",\"B\",IF(MID(I80,I79,1)=\"2\",\"C\",IF(MID(I80,I79,1)=\"3\",\"D\",)))),IF(MID(I80,I79,1)=\"4\",\"E\",IF(MID(I80,I79,1)=\"5\",\"F\",IF(MID(I80,I79,1)=\"6\",\"G\",IF(MID(I80,I79,1)=\"7\",\"H\",IF(MID(I80,I79,1)=\"8\",\"I\",IF(MID(I80,I79,1)=\"9\",\"J\",\"zz\")))))))","v":{"$error":"#VALUE!"}},1]
[null,null,null,null,null,null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","ok","ok","ok"]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"derniere page du bordereau de prix :  \" &A21 &\"  \"&A29","v":"derniere page du bordereau de prix :  DIAGNOSTICS DES RESEAUX D'EAU INTERIEURS POUR LES RISQUES DE LEGIONELLES - CARNETS SANITAIRES  LOT N° 2 : 2ème, 3ème, 4ème, 5ème, 13ème, 14ème, 15ème et 16ème arrondissements"}]

{"sheet":"Cadre d'offre V_14_7","index":1,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[[2,0,2,5],[3,0,3,5],[4,0,4,5],[10,0,10,5],[5,0,5,5],[7,0,7,5],[5,12,5,17],[5,18,5,23],[28,0,28,5],[11,0,11,5],[12,0,12,5],[19,0,19,5],[20,0,20,5],[32,1,32,4],[34,1,35,4],[36,1,37,4],[23,0,26,5],[5,48,5,53],[5,54,5,59],[5,60,5,65],[5,66,5,71],[5,24,5,29],[5,30,5,35],[5,36,5,41],[5,42,5,47],[5,96,5,101],[5,102,5,107],[5,108,5,113],[5,114,5,119],[5,72,5,77],[5,78,5,83],[5,84,5,89],[5,90,5,95],[5,156,5,161],[5,162,5,167],[5,120,5,125],[5,126,5,131],[5,132,5,137],[5,138,5,143],[5,252,5,255],[6,0,6,5],[6,12,6,17],[6,18,6,23],[6,24,6,29],[6,30,6,35],[6,36,6,41],[5,216,5,221],[6,66,6,71],[6,72,6,77],[6,78,6,83],[6,84,6,89],[6,42,6,47],[6,48,6,53],[5,222,5,227],[5,228,5,233],[6,114,6,119],[6,120,6,125],[6,126,6,131],[5,240,5,245],[5,246,5,251],[5,234,5,239],[5,192,5,197],[5,198,5,203],[5,204,5,209],[5,210,5,215],[5,168,5,173],[5,174,5,179],[5,180,5,185],[5,186,5,191],[5,144,5,149],[5,150,5,155],[6,90,6,95],[6,96,6,101],[6,102,6,107],[6,108,6,113],[6,54,6,59],[6,60,6,65],[6,186,6,191],[6,192,6,197],[6,198,6,203],[6,204,6,209],[6,132,6,137],[6,174,6,179],[6,180,6,185],[6,138,6,143],[6,144,6,149],[6,150,6,155],[6,156,6,161],[6,162,6,167],[6,168,6,173],[6,252,6,255],[6,210,6,215],[6,216,6,221],[6,222,6,227],[6,228,6,233],[6,234,6,239],[6,240,6,245],[6,246,6,251]]}
[null,null,null,null,null,null,{"$f":"IF(ISNUMBER(D1),\"O\",\"N\")","v":"N"}]
[null,null,null,null,null,null,{"$f":"IF(ISNUMBER(D2),\"O\",\"N\")","v":"N"}]
["DÉLÉGATION GÉNÉRALE ADJOINTE",null,null,null,null,null,"N"]
["Ville plus Verte et plus Durable",null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
["Direction de l'Architecture et de la Valorisation des Equipements et de leurs Usages",null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[{"$f":"'Bordereaux de prix V_14_7'!A11:F11","v":"DIAGNOSTICS DES RESEAUX D'EAU INTERIEURS"},null,null,null,null,null,{"$f":"IF(ISNUMBER(A11),\"O\",\"N\")","v":"N"}]
[{"$f":"'Bordereaux de prix V_14_7'!A12:F12","v":"POUR LES RISQUES DE LEGIONELLES"},null,null,null,null,null,{"$f":"IF(ISNUMBER(A12),\"O\",\"N\")","v":"N"}]
[{"$f":"'Bordereaux de prix V_14_7'!A13:F13","v":"DANS LES BATIMENTS DE LA VILLE DE MARSEILLE"},null,null,null,null,null,{"$f":"IF(ISNUMBER(A13),\"O\",\"N\")","v":"N"}]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
["Cadre d'offre",null,null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),\"O\",\"N\")","v":"N"}]
[{"$f":"'Bordereaux de prix V_14_7'!A25:F25","v":"Consultation N° 2022_50001_0022"},null,null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),\"O\",\"N\")","v":"N"}]
[null,null,null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),\"O\",\"N\")","v":"N"}]
[null,null,null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),\"O\",\"N\")","v":"N"}]
[{"$f":"'Bordereaux de prix V_14_7'!A21:F21","v":"DIAGNOSTICS DES RESEAUX D'EAU INTERIEURS POUR LES RISQUES DE LEGIONELLES - CARNETS SANITAIRES"},null,null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),\"O\",\"N\")","v":"N"}]
[null,null,null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),\"O\",\"N\")","v":"N"}]
[null,null,null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),\"O\",\"N\")","v":"N"}]
[null,null,null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),\"O\",\"N\")","v":"N"}]
[null,null,null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),\"O\",\"N\")","v":"N"}]
[{"$f":"'Bordereaux de prix V_14_7'!A29:F29","v":"LOT N° 2 : 2ème, 3ème, 4ème, 5ème, 13ème, 14ème, 15ème et 16ème arrondissements"},null,null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),\"O\",\"N\")","v":"N"}]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,"NOM ENTREPRISE",null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,{"$f":"IF(ISBLANK('Bordereaux de prix V_14_7'!B35:E36),\"\",'Bordereaux de prix V_14_7'!B35:E36)","v":""},null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,{"$f":"IF(ISBLANK('Bordereaux de prix V_14_7'!B37:E38),\"\",'Bordereaux de prix V_14_7'!B37:E38)","v":""},null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N",{"$f":"COUNTA(G1:G40)","v":40}]
[null,null,null,null,null,null,"N"]
[{"$f":"'Bordereaux de prix V_14_7'!A42","v":0},{"$f":"'Bordereaux de prix V_14_7'!B42","v":0},{"$f":"'Bordereaux de prix V_14_7'!C42","v":0},{"$f":"'Bordereaux de prix V_14_7'!D42","v":"PRIX"},"QUANTITE",{"$f":"'Bordereaux de prix V_14_7'!F42","v":0},"N"]
[{"$f":"'Bordereaux de prix V_14_7'!A43","v":"N° ARTICLE"},{"$f":"'Bordereaux de prix V_14_7'!B43","v":"PRESTATIONS"},{"$f":"'Bordereaux de prix V_14_7'!C43","v":"UNITE"},{"$f":"'Bordereaux de prix V_14_7'!D43","v":"UNITAIRE € HT"},"Estimée Annuelle","TOTAL en € HT","N"]
[{"$f":"'Bordereaux de prix V_14_7'!A44","v":0},{"$f":"'Bordereaux de prix V_14_7'!B44","v":0},{"$f":"'Bordereaux de prix V_14_7'!C44","v":0},{"$f":"'Bordereaux de prix V_14_7'!D44","v":0},null,null,{"$f":"IF(ISTEXT(C44),\"O\",\"N\")","v":"N"}]
[{"$f":"'Bordereaux de prix V_14_7'!A45","v":0},{"$f":"'Bordereaux de prix V_14_7'!B45","v":0},{"$f":"'Bordereaux de prix V_14_7'!C45","v":0},{"$f":"'Bordereaux de prix V_14_7'!D45","v":0},null,{"$f":"D45*E45","v":0},{"$f":"IF(ISTEXT(C45),\"O\",\"N\")","v":"N"},null,null,{"$f":"IF(G45=\"O\",IF(E45=0,\"Quantitée et article décalé\",\"\"),IF(ISBLANK(E45),\"\",\"Quantité et article décalé\"))","v":""}]
[{"$f":"'Bordereaux de prix V_14_7'!A46","v":"T 99 00 000 00"},{"$f":"'Bordereaux de prix V_14_7'!B46","v":"PRESTATION COMMUNES ET ANNEXES A CHAQUE CORPS D'ETAT"},{"$f":"'Bordereaux de prix V_14_7'!C46","v":0},{"$f":"'Bordereaux de prix V_14_7'!D46","v":0},null,{"$f":"D46*E46","v":0},"N",null,null,{"$f":"IF(G46=\"O\",IF(E46=0,\"Quantitée et article décalé\",\"\"),IF(ISBLANK(E46),\"\",\"Quantité et article décalé\"))","v":""}]
[{"$f":"'Bordereaux de prix V_14_7'!A47","v":"T 99 01 060 00"},{"$f":"'Bordereaux de prix V_14_7'!B47","v":"DISPOSITIONS PARTICULIERES CONCERNANT L' ARCHIPEL DU FRIOUL"},{"$f":"'Bordereaux de prix V_14_7'!C47","v":0},{"$f":"'Bordereaux de prix V_14_7'!D47","v":0},null,{"$f":"D47*E47","v":0},"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A48","v":"T 99 01 060 01"},{"$f":"'Bordereaux de prix V_14_7'!B48","v":"ILE DU FRIOUL TITRE DE TRANSPORT ET TEMPS DEPLACEMENT"},{"$f":"'Bordereaux de prix V_14_7'!C48","v":"U"},{"$f":"'Bordereaux de prix V_14_7'!D48","v":0},1,0,"O",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A49","v":0},{"$f":"'Bordereaux de prix V_14_7'!B49","v":0},{"$f":"'Bordereaux de prix V_14_7'!C49","v":0},{"$f":"'Bordereaux de prix V_14_7'!D49","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A50","v":0},{"$f":"'Bordereaux de prix V_14_7'!B50","v":0},{"$f":"'Bordereaux de prix V_14_7'!C50","v":0},{"$f":"'Bordereaux de prix V_14_7'!D50","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A51","v":0},{"$f":"'Bordereaux de prix V_14_7'!B51","v":0},{"$f":"'Bordereaux de prix V_14_7'!C51","v":0},{"$f":"'Bordereaux de prix V_14_7'!D51","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A52","v":0},{"$f":"'Bordereaux de prix V_14_7'!B52","v":0},{"$f":"'Bordereaux de prix V_14_7'!C52","v":0},{"$f":"'Bordereaux de prix V_14_7'!D52","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A53","v":"P CL 00 001 00"},{"$f":"'Bordereaux de prix V_14_7'!B53","v":"ETAT DES LIEUX ET DES INSTALLATIONS"},{"$f":"'Bordereaux de prix V_14_7'!C53","v":0},{"$f":"'Bordereaux de prix V_14_7'!D53","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A54","v":"P CL 00 001 01"},{"$f":"'Bordereaux de prix V_14_7'!B54","v":"Schéma sur la base d'un fond de plan fourni"},{"$f":"'Bordereaux de prix V_14_7'!C54","v":"U"},{"$f":"'Bordereaux de prix V_14_7'!D54","v":0},50,0,"O",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A55","v":"P CL 00 001 02"},{"$f":"'Bordereaux de prix V_14_7'!B55","v":"Schéma sans fond de plan fourni"},{"$f":"'Bordereaux de prix V_14_7'!C55","v":"m2"},{"$f":"'Bordereaux de prix V_14_7'!D55","v":0},25,0,"O",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A56","v":"P CL 00 001 03"},{"$f":"'Bordereaux de prix V_14_7'!B56","v":"Rapport d'audit-assistance et préconisations"},{"$f":"'Bordereaux de prix V_14_7'!C56","v":"U"},{"$f":"'Bordereaux de prix V_14_7'!D56","v":0},20,0,"O",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A57","v":0},{"$f":"'Bordereaux de prix V_14_7'!B57","v":0},{"$f":"'Bordereaux de prix V_14_7'!C57","v":0},{"$f":"'Bordereaux de prix V_14_7'!D57","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A58","v":0},{"$f":"'Bordereaux de prix V_14_7'!B58","v":0},{"$f":"'Bordereaux de prix V_14_7'!C58","v":0},{"$f":"'Bordereaux de prix V_14_7'!D58","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A59","v":0},{"$f":"'Bordereaux de prix V_14_7'!B59","v":0},{"$f":"'Bordereaux de prix V_14_7'!C59","v":0},{"$f":"'Bordereaux de prix V_14_7'!D59","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A60","v":"P CL 00 002 00"},{"$f":"'Bordereaux de prix V_14_7'!B60","v":"HISTORIQUE TECHNIQUE DE L’INSTALLATION"},{"$f":"'Bordereaux de prix V_14_7'!C60","v":0},{"$f":"'Bordereaux de prix V_14_7'!D60","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A61","v":"P CL 00 002 01"},{"$f":"'Bordereaux de prix V_14_7'!B61","v":"Analyse des documents de l'installation inspectée"},{"$f":"'Bordereaux de prix V_14_7'!C61","v":"U"},{"$f":"'Bordereaux de prix V_14_7'!D61","v":0},15,0,"O",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A62","v":0},{"$f":"'Bordereaux de prix V_14_7'!B62","v":0},{"$f":"'Bordereaux de prix V_14_7'!C62","v":0},{"$f":"'Bordereaux de prix V_14_7'!D62","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A63","v":0},{"$f":"'Bordereaux de prix V_14_7'!B63","v":0},{"$f":"'Bordereaux de prix V_14_7'!C63","v":0},{"$f":"'Bordereaux de prix V_14_7'!D63","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A64","v":0},{"$f":"'Bordereaux de prix V_14_7'!B64","v":0},{"$f":"'Bordereaux de prix V_14_7'!C64","v":0},{"$f":"'Bordereaux de prix V_14_7'!D64","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A65","v":0},{"$f":"'Bordereaux de prix V_14_7'!B65","v":0},{"$f":"'Bordereaux de prix V_14_7'!C65","v":0},{"$f":"'Bordereaux de prix V_14_7'!D65","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A66","v":0},{"$f":"'Bordereaux de prix V_14_7'!B66","v":0},{"$f":"'Bordereaux de prix V_14_7'!C66","v":0},{"$f":"'Bordereaux de prix V_14_7'!D66","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A67","v":"P CL 00 003 00"},{"$f":"'Bordereaux de prix V_14_7'!B67","v":"MESURES ET ANALYSES"},{"$f":"'Bordereaux de prix V_14_7'!C67","v":0},{"$f":"'Bordereaux de prix V_14_7'!D67","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A68","v":"P CL 00 003 01"},{"$f":"'Bordereaux de prix V_14_7'!B68","v":"Mesures des performances hydrauliques"},{"$f":"'Bordereaux de prix V_14_7'!C68","v":"le point"},{"$f":"'Bordereaux de prix V_14_7'!D68","v":0},75,0,"O",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A69","v":"P CL 00 003 02"},{"$f":"'Bordereaux de prix V_14_7'!B69","v":"Analyse du risque de retour d'eau"},{"$f":"'Bordereaux de prix V_14_7'!C69","v":"U"},{"$f":"'Bordereaux de prix V_14_7'!D69","v":0},50,0,"O",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A70","v":"P CL 00 003 03"},{"$f":"'Bordereaux de prix V_14_7'!B70","v":"Analyse de conformité générale"},{"$f":"'Bordereaux de prix V_14_7'!C70","v":"U"},{"$f":"'Bordereaux de prix V_14_7'!D70","v":0},50,0,"O",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A71","v":0},{"$f":"'Bordereaux de prix V_14_7'!B71","v":0},{"$f":"'Bordereaux de prix V_14_7'!C71","v":0},{"$f":"'Bordereaux de prix V_14_7'!D71","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A72","v":0},{"$f":"'Bordereaux de prix V_14_7'!B72","v":0},{"$f":"'Bordereaux de prix V_14_7'!C72","v":0},{"$f":"'Bordereaux de prix V_14_7'!D72","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A73","v":"P CL 00 004 00"},{"$f":"'Bordereaux de prix V_14_7'!B73","v":"CARNET DE SUIVI SANITAIRE"},{"$f":"'Bordereaux de prix V_14_7'!C73","v":0},{"$f":"'Bordereaux de prix V_14_7'!D73","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A74","v":"P CL 00 004 01"},{"$f":"'Bordereaux de prix V_14_7'!B74","v":"Elaboration d'un carnet sanitaire"},{"$f":"'Bordereaux de prix V_14_7'!C74","v":"U"},{"$f":"'Bordereaux de prix V_14_7'!D74","v":0},150,0,"O",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A75","v":"P CL 00 004 02"},{"$f":"'Bordereaux de prix V_14_7'!B75","v":"Mise à jour d'un carnet sanitaire"},{"$f":"'Bordereaux de prix V_14_7'!C75","v":"U"},{"$f":"'Bordereaux de prix V_14_7'!D75","v":0},200,0,"O",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A76","v":0},{"$f":"'Bordereaux de prix V_14_7'!B76","v":0},{"$f":"'Bordereaux de prix V_14_7'!C76","v":0},{"$f":"'Bordereaux de prix V_14_7'!D76","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A77","v":0},{"$f":"'Bordereaux de prix V_14_7'!B77","v":0},{"$f":"'Bordereaux de prix V_14_7'!C77","v":0},{"$f":"'Bordereaux de prix V_14_7'!D77","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A78","v":0},{"$f":"'Bordereaux de prix V_14_7'!B78","v":0},{"$f":"'Bordereaux de prix V_14_7'!C78","v":0},{"$f":"'Bordereaux de prix V_14_7'!D78","v":0},null,0,"N",null,null,""]
[{"$f":"'Bordereaux de prix V_14_7'!A79","v":0},{"$f":"'Bordereaux de prix V_14_7'!B79","v":0},{"$f":"'Bordereaux de prix V_14_7'!C79","v":0},{"$f":"'Bordereaux de prix V_14_7'!D79","v":0},null,0,"N",null,null,""]
[{"$f":"\"T 00 00 ST\" & MID(TEXT(I80,\"000\"),1,1)&\" \"&MID(TEXT(I80,\"000\"),2,2)","v":"T 00 00 ST0 01"},{"$f":"\"Sous total \" & FIXED(I80,0)","v":"Sous total 1"},null,null,null,{"$f":"SUM(F45:F79)","v":0},"O",{"$f":"COUNTA(G41:G80)","v":40},1]
[null,null,null,null,null,null,{"$f":"IF(ISTEXT(C81),\"O\",\"N\")","v":"N"}]
[null,null,null,null,"Sous total 1",{"$f":"Sous_total_Page_1","v":0},"N"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"N"]
[null,"Récapitulatif",null,null,null,null,"N"]
[null,"du ",null,null,null,null,"N"]
[null,"cadre d'offre",null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"N"]
[null,"Total Cadre d'offre en € HT",null,null,null,{"$f":"SUM(F82:F103)","v":0},"N"]
[]
[null,null,null,null,null,null,"N"]