{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["FormA+B","N°Projet","Base"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":2,"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":"FormA+B","index":0,"n_rows":62,"n_cols":34,"rows_kept":62,"cut":false,"hidden":false,"merged":[[42,0,42,36],[43,1,43,36],[44,1,44,36],[40,0,40,1],[40,2,40,21],[40,26,40,29],[40,30,40,32],[40,33,40,36],[41,0,41,1],[41,2,41,21],[41,26,41,29],[41,30,41,32],[41,33,41,36],[40,22,40,25],[41,22,41,25],[37,33,37,36],[39,0,39,1],[39,2,39,21],[39,26,39,29],[39,30,39,32],[39,33,39,36],[38,0,38,1],[38,2,38,21],[38,22,38,25],[38,26,38,29],[38,30,38,32],[38,33,38,36],[37,22,37,25],[39,22,39,25],[37,0,37,1],[37,2,37,21],[37,26,37,29],[37,30,37,32],[33,0,33,1],[33,2,33,21],[33,26,33,29],[33,30,33,32],[33,33,33,36],[36,0,36,1],[36,2,36,21],[36,26,36,29],[36,30,36,32],[36,33,36,36],[33,22,33,25],[36,22,36,25],[34,0,34,1],[34,2,34,21],[34,22,34,25],[34,26,34,29],[34,30,34,32],[34,33,34,36],[35,0,35,1],[35,2,35,21],[35,22,35,25],[35,26,35,29],[35,30,35,32],[35,33,35,36],[31,0,31,1],[31,2,31,21],[31,26,31,29],[31,30,31,32],[31,33,31,36],[32,0,32,1],[32,2,32,21],[32,26,32,29],[32,30,32,32],[32,33,32,36],[31,22,31,25],[32,22,32,25],[29,0,29,1],[29,2,29,21],[29,26,29,29],[29,30,29,32],[29,33,29,36],[30,0,30,1],[30,2,30,21],[30,26,30,29],[30,30,30,32],[30,33,30,36],[29,22,29,25],[30,22,30,25],[27,0,27,1],[27,2,27,21],[27,26,27,29],[27,30,27,32],[27,33,27,36],[28,0,28,1],[28,2,28,21],[28,26,28,29],[28,30,28,32],[28,33,28,36],[27,22,27,25],[28,22,28,25],[25,0,25,21],[25,22,25,25],[25,26,25,29],[25,30,25,36],[26,0,26,1],[26,2,26,21],[26,26,26,29],[26,30,26,32],[26,33,26,36],[26,22,26,25],[23,5,23,9],[15,2,15,4],[16,24,16,36],[17,10,17,17],[17,18,17,23],[21,2,21,4],[21,10,21,17],[21,18,21,23],[21,24,21,36],[22,2,22,4],[19,24,19,36],[20,24,20,36],[18,2,18,4],[22,10,22,17],[22,18,22,23],[22,24,22,36],[14,9,14,21],[12,22,12,36],[13,22,13,36],[14,22,14,36],[18,10,18,17],[18,18,18,23],[18,24,18,36],[15,10,15,17],[15,18,15,23],[15,24,15,36],[17,24,17,36],[16,10,16,17],[16,18,16,23],[15,5,15,9],[16,5,16,9],[17,5,17,9],[18,5,18,9],[19,5,19,9],[1,0,1,36],[3,0,3,6],[3,7,3,36],[4,0,4,6],[4,7,4,36],[5,0,5,6],[5,7,5,36],[6,0,6,6],[6,7,6,20],[6,21,6,24],[6,25,6,36],[10,0,10,6],[10,7,10,36],[53,0,53,36],[56,24,56,36],[56,0,56,16],[7,0,7,6],[7,7,7,20],[7,21,8,24],[7,25,7,36],[8,0,8,6],[8,7,8,20],[8,25,8,36],[9,0,9,6],[9,7,9,36],[11,0,11,6],[11,7,11,8],[11,9,11,21],[11,22,11,36],[12,0,14,6],[12,7,12,8],[13,7,13,8],[14,7,14,8],[12,9,12,21],[13,9,13,21],[16,2,16,4],[17,2,17,4],[61,1,61,16],[56,17,56,23],[57,17,57,23],[58,17,58,23],[59,17,59,23],[60,17,60,23],[61,17,61,23],[19,2,19,4],[20,2,20,4],[20,10,20,17],[20,18,20,23],[19,10,19,17],[19,18,19,23],[24,0,24,36],[23,10,23,17],[23,18,23,23],[23,24,23,36],[23,2,23,4],[15,0,23,1],[20,5,20,9],[21,5,21,9],[22,5,22,9],[57,24,57,36],[58,24,58,36],[59,24,59,36],[60,24,60,36],[61,24,61,36],[57,1,57,16],[58,1,58,16],[59,1,59,16],[60,1,60,16]]}
[]
["Marché public - Formulaire A + B"]
[]
["N° projet"]
["Projet",null,null,null,null,null,null,{"$f":"IF(H4=\"\",\"\",VLOOKUP(H4,Tableau1[],2,FALSE))","v":""}]
["Procédure"]
["Type de marché",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cahier d'offre",null,null,null,"Services sans estimation des heures"]
["Genre de prestation ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPV",null,null,null,"GC APR"]
["Complexité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CPV=\"\",\"\",VLOOKUP(CPV,Base!B2:C14,2,FALSE))","v":"71311220-9-03"}]
["Type de contrat"]
["Objet du marché "]
["Montant (HT)",null,null,null,null,null,null,"CHF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Selon estimation"]
["Composition EEO",null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,3]
["Organisation du mandat",null,"Fonction",null,null,"Groupement",null,null,null,null,"Nom et prénom",null,null,null,null,null,null,null,"Téléphone",null,null,null,null,null,"Courriel"]
[null,null,"PL-PM"]
[null,null,"BL-PM"]
[null,null,"Juriste"]
[null,null,"BAMO"]
[]
[]
[]
[]
["Planification"]
["Procédure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date prévue",null,null,null,"Jour",null,null,null,"Intervalle entre étapes"]
[1,null,"Rendu du masque SIMAP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W27=\"\",\"\",TEXT(W27,\"jjjj\"))","v":""}]
[2,null,"Séance EEO* pour validation des critères d'évaluation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(W28=\"\",\"\",W28-W27)","v":""}]
[3,null,"Rendu du DAO complet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[4,null,"Retour remarques PL et juriste",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[5,null,"Rendu du DAO complet et validé ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[6,null,"Publication SIMAP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[7,null,"Questions adressées à l'OFROU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,{"$f":"IF(W33=\"\",\"\",W33-W32)","v":""}]
[8,null,"Réponses aux soumissionnaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,{"$f":"IF(W34=\"\",\"\",(W34-W33)+AH33)","v":""}]
[9,null,"Questions adressées à l'OFROU - 2ème ronde (facultatif)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W35=\"\",\"\",TEXT(W35,\"jjjj\"))","v":""},null,null,null,{"$f":"IF(W35=\"\",\"\",W35-W34)","v":""},null,null,{"$f":"IF(W35=\"\",\"\",IF(W35=\"\",\"\",(W35-W34)+AH34))","v":""}]
[10,null,"Réponses aux soumissionnaires - 2ème ronde (facultatif)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,{"$f":"IF(W36=\"\",\"\",IF(W36=\"\",\"\",(W36-W35)+AH35))","v":""}]
[11,null,"Dépôt des offres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(W36=\"\",IF(OR(W37=\"\",W34=\"\"),\"\",W37-W34),W37-W36)","v":""},null,null,{"$f":"IF(W37=\"\",\"\",(W37-W32))","v":""}]
[12,null,"Ouverture des offres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(W38=\"\",\"\",W38-W37)","v":""}]
[13,null,"Envoi du protocol d'ouverture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W39=\"\",\"\",TEXT(W39,\"jjjj\"))","v":""},null,null,null,{"$f":"IF(W39=\"\",\"\",W39-W38)","v":""}]
[14,null,"Séance EEO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(W40=\"\",\"\",W40-W39)","v":""}]
[15,null,"Publication de l'adjudication",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[16,null,"Expiration du délai de recours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
["Remarques :"]
[null,"Les dates ne doivent pas tomber sur des week-ends, des jours fériés."]
[null,"Prévoir un peu plus de temps quand il s'agit de mois avec beaucoup de jours fériés, etc. "]
[]
[]
[]
[]
[]
[]
[]
[]
["Entreprises invitées"]
[]
[]
["Nom entreprise et adresse ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personne de contact",null,null,null,null,null,null,"Courriel de contact"]
[1]
[2]
[3]
[4]
[5]

{"sheet":"N°Projet","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["N° Projet","Projet"]
["MP-200004","N12.76.200004 - Jct Bulle réaménagement"]

{"sheet":"Base","index":2,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Colonne1","Colonne2","Colonne3",null,"Colonne1","Colonne2",null,"Genre de prestation ","Cahier d'offre","Complexité","Procédure","Type de contrat","Type de marché","CPV"]
["Services","BAMO","71311220-9-01",null,"Invitation","Service jusqu'à 230'000",null,"Appui au maître d'ouvrage","Services sans estimation des heures","Faible",{"$f":"_xlfn.UNIQUE(TAB_Proc[Colonne1],FALSE)","v":"Invitation"},{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(TAB_Proc[Colonne2],TAB_Proc[Colonne1]=Procédure,\"\"),FALSE)","v":""},{"$f":"_xlfn.UNIQUE(TAB_CPV[Colonne1],FALSE)","v":"Services"},{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(TAB_CPV[Colonne2],TAB_CPV[Colonne1]=Marché,\"\"),FALSE)","v":""}]
["Services","GC APR","71311220-9-03",null,"Invitation","Appui au maître d'ouvrage",null,"Auteur de projet (avec DLT)","Services avec estimation des heures","Moyenne","Ouverte",null,"Fournitures"]
["Services","GC DLT","71311220-9-04",null,"Invitation","Construction jusqu'à 2'000'000",null,"Auteur de projet (sans DLT)","Construction ","Grande","Mini Tender (invitation)",null,"Construction"]
["Services","Trafic APR","71310000-4-02",null,"Invitation","Document contractuel EES",null,"Construction (avec entrave au trafic)","BSA"]
["Services","Bruit APR","71313100-6-01",null,"Ouverte","Service dès 230'000",null,"Construction (sans entrave au trafic)"]
["Services","SER","71313450-4-01",null,"Ouverte","Appui au maître d'ouvrage",null,"Construction BSA"]
["Services","Géométre","71355000-1-01",null,"Ouverte","Construction dès 2'000'000"]
["Services","Laboratoires","71900000-7-01",null,"Ouverte","Document contractuel EES"]
["Services","BSA APR","71300000-1-01",null,"Mini Tender (invitation)","Document contractuel EES"]
["Services","BSA DLT","71300000-1-07"]
["Fournitures"]
["Construction","GC Travaux","45200000-9-01"]
["Construction","BSA Travaux","45300000-0-01"]