{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["REMPLACEMENTS COURANTS","Maintenance","Reparation mecanique","Reparation tolerie","RECAP"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"REMPLACEMENTS COURANTS","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[24,1,24,2]]}
["CADRE DES PRESTATIONS ET BORDEREAU DES PRIX UNITAIRES  DES PRESTATIONS DE  VERIFICATION PERIODIQUE DES VEHICULES"]
[]
["Nature des travaux à effectuer","TYPE VEHICULE","Temps nécessaire pour intervention","Coût de la main d’oeuvre","Coût des consommables","COUT TOTAL EN XAF","Délais de garantie"]
["Service Mini A : tous les 5,000 km ","-Berline",null,null,null,{"$f":"+D4+E4","v":0}]
["1-Remplacement de l’huile de moteur","-Prado",null,null,null,{"$f":"+D5+E5","v":0}]
["2-Nettoyage du filtre à air","-Hard Top",null,null,null,0]
["3-Contrôle de l’huile de pont","-Hilux",null,null,null,0]
["4-Contôle de la suspension","-Break",null,null,null,0]
["5-Contrôle des signeaux lumineux",{"$nulls":4},0]
["Sous-total A",{"$nulls":4},{"$f":"+SUM(F1:F9)","v":0}]
["Service Filtre B : tous les 10,000 km service","-Berline",null,null,null,0]
["1-A+","-Prado",null,null,null,0]
["2-Changement du filtre à gas-oil","-Land Cruiser",null,null,null,0]
["3-Changement du filtre à huile","-Hilux",null,null,null,0]
["4-Vérification des ponts AR & AV","-Break",null,null,null,0]
["5-Nettoyage du radiateur",{"$nulls":4},0]
["Sous-total B",{"$nulls":4},{"$f":"+SUM(F11:F16)","v":0}]
[]
["Service complet C : tous les 20,000 km ","-Berline",null,null,null,{"$f":"+D19+E19","v":0}]
["1-B+","-Prado",null,null,null,0]
["2-Changement de l’huile de la boite de vitesse et de pont AR et AV","-Land Cruiser",null,null,null,0]
["3-Graissage complet","-Hilux",null,null,null,0]
["4-Contrôle des plaquettes AR et AV(changement  si nécessaire","-Break",null,null,null,0]
["5-contrôle des peneumatiques et changement si nécessaire",{"$nulls":4},0]
["6-Changement du filtre à air",{"$nulls":4},0]
["Sous-total service C",{"$nulls":4},{"$f":"+SUM(F19:F25)","v":0}]
[]
["Tous les 100,000 km"]
["Changement de la courroie de distribution","-Berline",null,null,null,{"$f":"+D29+E29","v":0}]
[null,"-Prado",null,null,null,0]
[null,"-Land Cruiser",null,null,null,0]
[null,"-Hilux",null,null,null,0]
[null,"-Break",null,null,null,0]
["Sous-total contrôle 100.000 km",{"$nulls":4},{"$f":"SUM(F29:F33)","v":0}]
[]
["GRAND TOTAL REMPLACEMENTS COURANTS",{"$nulls":4},{"$f":"F34+F26+F17+F10","v":0}]

{"sheet":"Maintenance","index":1,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,0,7,0],[8,0,14,0],[15,0,17,0],[18,0,45,0]]}
["BORDEREAU DES PRIX UNITAIRES  DES PRESTATIONS DE  MAINTENANCE ET CONTRÔLE  DES VEHICULES"]
[]
["CATEGORIE A ","SERVICES DE MAINTENANCE ET DE CONTROLE ","PRIX DE LA PRESTATION EN XAF"]
[1,"GENERAL"]
[null,"Nettoyage du véhicule (moteur, réservoir, etc…) "]
[null,"Graissage général"]
[null,"Inspection complète"]
[null,"Diagnostic spécialisé"]
[2,"NIVEAUX",{"$f":"SUM(C10:C15)","v":0}]
[null,"Radiateur"]
[null,"Huile"]
[null,"Lave glace"]
[null,"Batterie"]
[null,"Liquide de frein"]
[null,"Assistance de direction"]
[3,"ROUES"]
[null,"Pression des pneus et de la roue de secours"]
[null,"Etat de la jante et du pneu"]
[4,"CONTROLES",{"$f":"SUM(C20:C46)","v":0}]
[null,"Propreté et états des connexions électriques"]
[null,"Etats des cosses de batterie"]
[null,"Propreté du radiateur"]
[null,"Tension et état des courroies"]
[null,"Absence de fuite dans le bloc moteur et sous le véhicule"]
[null,"Fonctionnement des feux d'éclairages et de signalisation"]
[null,"Etanchéité et état des circuits hydrauliques "]
[null,"Etanchéité des durits et des carters"]
[null,"Etat du pré-filtre et du filtre à essence"]
[null,"Etat et tension des courroies"]
[null,"Etat des graisseurs"]
[null,"Course d'embrayage"]
[null,"Course du frein à main"]
[null,"Etat des protecteurs caoutchouc"]
[null,"Usure des plaquettes"]
[null,"Jeux des moyeux, biellettes et rotules"]
[null,"Etats des articulations élastiques"]
[null,"Pompe injection "]
[null,"Attaches des différents éléments du moteur"]
[null,"VIDANGE "]
[null,"Huile moteur"]
[null,"Boite de vitesse"]
[null,"Huile boite Pont AV et AR"]
[null,"Huile  freins "]
[null,"Huile de direction "]
[null,"Eau distillée"]
[null,"Liquide de refroidissement"]
["sous-total A",null,{"$f":"+C19+C16+C9+C4","v":0}]

{"sheet":"Reparation mecanique","index":2,"n_rows":69,"n_cols":3,"rows_kept":69,"cut":false,"hidden":false,"merged":[[3,0,52,0],[53,0,67,0]]}
["BORDEREAU DE PRIX UNITAIRES DES PRESTATIONS DE REPARATION - MECANIQUE GENERALE - DES VEHICULES "]
[]
["CATEGORIE B ","SERVICE DE REPARATION ET DE REMPLACEMENT ","PRIX UNITAIRE DE LA PRESTATION EN XAF"]
[1," REMPLACEMENT ",{"$f":"SUM(C5:C53)","v":0}]
[null,"Filtre à huile"]
[null,"Filtre à air"]
[null,"Filtre à gasoil"]
[null,"Acide Batterie"]
[null,"Bougies pour les véhicules à essence "]
[null,"Bougies de préchauffage pour les véhicules Diesel "]
[null,"Elément du filtre à essence"]
[null,"Elément du pré-filtre à essence"]
[null,"Elément du filtre à gasoil "]
[null,"Elément du pré-filtre à gasoil "]
[null,"Démarreur "]
[null,"Batterie"]
[null,"Radiateur "]
[null,"Moteur lave glace "]
[null,"Lave glace"]
[null,"Boîtier de direction "]
[null,"Bavette "]
[null,"Rotule de barre "]
[null,"Jante "]
[null,"Joint Pont AV et AR  "]
[null,"Suspension "]
[null,"Trompette AV et AR "]
[null,"Rétroviseur "]
[null,"Pneus "]
[null,"Chambres à air "]
[null,"Moteur "]
[null,"Amortisseurs AV"]
[null,"Amortisseurs AR"]
[null,"Cardan "]
[null,"Pot d’Echappement "]
[null,"Porte AV et AR "]
[null,"Evaporateur "]
[null,"Condenseur "]
[null,"Charge gaz  "]
[null,"Silent bloc échappement "]
[null,"Silent bloc de barre stab AV "]
[null,"Silent bloc de barre  stab AR"]
[null,"Croisillon "]
[null,"Injecteurs "]
[null,"Rotule "]
[null,"Pompe injection "]
[null,"Courroies"]
[null,"Pompe d’amorçage "]
[null,"Carburateur "]
[null,"Joints "]
[null,"Ampoules de phares AV AR"]
[null,"Phares AV et AR "]
[null,"Klaxon "]
[null,"Chassis "]
[2,"REPARATION ",{"$f":"+SUM(C55:C68)","v":0}]
[null,"Démarreur "]
[null,"Batterie"]
[null,"Radiateur "]
[null,"Moteur lave glace "]
[null,"Lave glace"]
[null,"Boîtier de direction "]
[null,"Moteur "]
[null,"Pot d’Echappement "]
[null,"Porte AV et AR "]
[null,"Evaporateur "]
[null,"Condenseur "]
[null,"Charge gaz  "]
[null,"Pompe injection "]
[null,"Klaxon "]
["TOTAL B.",null,{"$f":"C54+C4","v":0}]

{"sheet":"Reparation tolerie","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["PRESTATIONS DES PRIX UNITAIRES DE  REPARATION TOLERIE DES VEHICULES "]
[]
["CATEGORIE C ","TOLERIE ET PEINTURE ","PRIX UNITAIRE DE LA PRESTATION EN XAF"]
[1,"TOLERIE ( CARROSSERIE)",{"$f":"SUM(C5:C8)","v":0}]
[null,"Tôlerie Aile Gauche"]
[null,"Tôlerie Aile Droite "]
[null,"Tôlerie Capot AV et AR "]
[null,"Tôlerie Toit "]
[2," PEINTURE ",{"$f":"SUM(C10:C13)","v":0}]
[null,"Peinture aile Gauche"]
[null,"!:cx;,v"]
[null,"XC"]
[null,"Peinture Toit "]
["TOTAL",null,{"$f":"+C9+C4","v":0}]

{"sheet":"RECAP","index":4,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["RECAPITULATIF DES PRIX UNITAIRES:OFFRE FINANCIERE"]
[]
["Catégorie","PRESTATION","TOTAL DES PRIX UNITAIRES"]
["0.","Remplacements courants",{"$f":"'REMPLACEMENTS COURANTS'!$F$36","v":0}]
["A","Maintenance et contrôle des véhicules",{"$f":"Maintenance!$C$47","v":0}]
["B","Réparation mécanique",{"$f":"'Reparation mecanique'!$C$69","v":0}]
["C","Tôlerie et peinture",{"$f":"'Reparation tolerie'!$C$14","v":0}]
["/","TOTAL",{"$f":"SUM(C4:C7)","v":0}]
[]
["Arrêté la présente offre financière au montant de XAF__________________________________________./."]
[]
[null,"Fait à ________________, le ___________________"]
[]
[]
[null,"Noms et prénoms suivi du titre de la personne"]
[null,"autorisée à engager la structure soumissionnaire (société ou groupe de sociétés)"]