{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Sommaire","Stock","Devis","Tarif"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Sommaire","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Stock","index":1,"n_rows":6,"n_cols":14,"rows_kept":6,"merged":[[2,1,2,5],[4,4,4,9],[5,13,6,13]]}
[]
[]
[null,"Stock réel présent chez xxxx",{"$nulls":9},"PAL15001"]
[]
[null,null,"N° de Palette","Date d'envoi","Durée de stockage prévue",{"$nulls":5},"Date de sortie prévue des échantillons","Demande d'essais concernée","Nombre d'échantillons stockés","Contenu"]
[{"$nulls":5},"an(s)",null,"jour(s)",null,"mois",{"$f":"IF(D6=\"\",\"\",DATE(YEAR(D6)+E6,MONTH(D6)+I6,DAY(D6)+G6))","v":""}]

{"sheet":"Devis","index":2,"n_rows":68,"n_cols":33,"rows_kept":68,"merged":[[1,1,2,7],[2,8,2,33],[4,11,4,33],[5,2,5,29],[5,30,5,33],[9,19,9,25],[9,26,9,27],[9,29,9,30],[9,32,9,33],[11,26,15,27],[11,29,11,30],[11,32,11,33],[14,2,14,16],[17,7,17,9],[17,26,17,27],[17,28,17,31],[17,32,17,33],[18,7,18,9],[18,26,18,27],[18,28,18,31],[18,32,18,33],[19,26,19,27],[19,32,19,33],[22,9,22,10],[22,16,26,33],[24,7,24,10],[26,6,26,10],[30,2,30,10],[30,28,30,33],[31,2,35,10],[32,28,32,33],[34,28,34,33],[36,28,36,33],[37,2,37,10],[38,2,61,10],[47,16,61,33]]}
[]
[]
[{"$nulls":8},"Proposition de stockage / Devis"]
[]
[{"$nulls":11},"LABO xx"]
[null,null,"Stockage d'échantillons "]
[]
[null,null,"1- Liste des tests réalisables et coûts des essais"]
[]
[{"$nulls":19},"Durée",{"$nulls":6},"Transport",null,null,"Nbre de palettes",null,null,"Coût total"]
[]
[null,null,"Stockage d'échantillons en entrepot externe",{"$nulls":17},"j",null,"mois",null,"année(s)",null,"Prix HT AVEC transport  AMONT ET AVAL"]
[]
[]
[]
[]
[]
[null,null,"Date de la proposition :",{"$nulls":4},{"$f":"TODAY()","v":"2015-03-05"},{"$nulls":20},"Coût global du stockage",{"$nulls":3},{"$f":"IF(AA12=D65,Tarif!L26,IF(Devis!AA12=Devis!D66,Tarif!N26,IF(Devis!AA12=Devis!D67,Tarif!P26,IF(Devis!AA12=Devis!D68,Tarif!R26))))","v":""}]
[]
[]
[null,null,"2 - Validation de la proposition d'essais"]
[]
[null,null,"Proposition validée (oui/non) :",{"$nulls":13},"Modifications à apporter si la proposition est invalidée"]
[]
[null,null,"Date de la validation :"]
[]
[null,null,"Prénom / nom :"]
[]
[null,null,"3 - Liste des produits à stocker",{"$nulls":13},"4 - Identité / Coordonnées du demandeur"]
[{"$nulls":28},"Test de performance"]
[null,null,"Type de produit",{"$nulls":13},"Prénom / Nom du demandeur"]
[]
[{"$nulls":16},"Intitulé de la mission"]
[]
[{"$nulls":16},"Rayon / service / site"]
[]
[{"$nulls":16},"("]
[null,null,"Liste des échantillons"]
[{"$nulls":16},"5 - Coordonnées des interlocuteurs du laboratoire"]
[]
[]
[]
[]
[]
[]
[{"$nulls":16},"6 - Commentaires divers"]
[]
[]
[null,""]
[]
[null,""]
[]
[null,""]
[]
[null,""]
{"$rows_empty":9}
[{"$nulls":3},{"$f":"\"Prix HT SANS transport\"","v":"Prix HT SANS transport"}]
[{"$nulls":3},{"$f":"\"Prix HT AVEC transport  AMONT ET DESTRUCTION\"","v":"Prix HT AVEC transport  AMONT ET DESTRUCTION"}]
[{"$nulls":3},{"$f":"\"Prix HT AVEC transport  AVAL OU AMONT\"","v":"Prix HT AVEC transport  AVAL OU AMONT"}]
[{"$nulls":3},{"$f":"\"Prix HT AVEC transport  AMONT ET AVAL\"","v":"Prix HT AVEC transport  AMONT ET AVAL"}]

{"sheet":"Tarif","index":3,"n_rows":70,"n_cols":20,"rows_kept":70,"merged":[[2,2,2,19],[4,14,4,16],[19,7,19,8]]}
[]
[]
[null,null,"Tarif de stockage /xxx / Mise à jour du 16/12/14"]
[]
[null,null,"1 - Calcul des coûts de stockage"]
[]
[]
[null,null,"Nombre de palettes à stocker :",{"$nulls":8},{"$f":"IF(Devis!AD12=\"\",\"\",Devis!AD12)","v":""},{"$nulls":3},{"$f":"IF(L12<>\"\",L12,IF(L14<>\"\",(L14*7+P14),IF(L16<>\"\",(L16*30+P16*7),IF(L18<>\"\",(L18*365+P18*30),0))))","v":0}]
[]
[null,null,"Durée de stockage :"]
[]
[null,null,"Entrez le nombre de jours,",{"$nulls":8},{"$f":"IF(Devis!T12=\"\",\"\",Devis!T12)","v":""},null,"jour(s)",{"$nulls":5},{"$f":"L12","v":""}]
[]
[null,null,"ou entrez le nombre de semaines,",{"$nulls":10},"semaine(s)","et",null,null,"jour(s)",null,{"$f":"L14*7+P14","v":0}]
[]
[null,null,"ou le nombre de mois,",{"$nulls":8},{"$f":"IF(Devis!V12=\"\",\"\",Devis!V12)","v":""},null,"mois","et",null,null,"semaine(s)",null,{"$f":"L16*30+7*P16","v":{"$error":"#VALUE!"}}]
[]
[null,null,"ou le nombre d'années.",{"$nulls":8},{"$f":"IF(Devis!X12=\"\",\"\",Devis!X12)","v":""},null,"année(s)","et",null,null,"mois",null,{"$f":"L18*365+P18*30","v":{"$error":"#VALUE!"}}]
[]
[{"$nulls":11},{"$f":"\"Prix HT SANS transport \n\"&$L$8&\" palette(s)\"","v":"Prix HT SANS transport \n palette(s)"},null,{"$f":"\"Prix HT AVEC transport  AMONT ET DESTRUCTION\n\"&$L$8&\" palette(s)\"","v":"Prix HT AVEC transport  AMONT ET DESTRUCTION\n palette(s)"},null,{"$f":"\"Prix HT AVEC transport  AVAL OU AMONT\n\"&$L$8&\" palette(s)\"","v":"Prix HT AVEC transport  AVAL OU AMONT\n palette(s)"},null,{"$f":"\"Prix HT AVEC transport  AMONT ET AVAL\n\"&$L$8&\" palette(s)\"","v":"Prix HT AVEC transport  AMONT ET AVAL\n palette(s)"}]
[]
[null,null,"Inf à 4 palettes et sup à 2 ans",{"$nulls":8},{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$49+2*$L$50)+2*$L$51)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$49+2*$L$50)+2*$L$51+1*$L$59)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$49+2*$L$50)+2*$L$51+$L$59)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$49+2*$L$50)+2*$L$51+2*$L$59)","v":""}]
[null,null,"Inf à 4 palettes et inf à 2 ans",{"$nulls":8},{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$48+2*$L$50)+2*$L$51)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$48+2*$L$50)+2*$L$51+1*$L$59)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$48+2*$L$50)+2*$L$51+$L$59)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$48+2*$L$50)+2*$L$51+2*$L$59)","v":""}]
[null,null,"Sup à 4 palettes et sup à 2 ans",{"$nulls":8},{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$49+2*$L$50)+2*$L$51)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$49+2*$L$50)+2*$L$51+1*$L$60)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$49+2*$L$50)+2*$L$51+$L$60)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$49+2*$L$50)+2*$L$51+2*$L$60)","v":""}]
[null,null,"sup à  4 palettes et inf à 2 ans",{"$nulls":8},{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$48+2*$L$50)+2*$L$51)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$48+2*$L$50)+2*$L$51+1*$L$60)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$48+2*$L$50)+2*$L$51+$L$60)","v":""},null,{"$f":"IF(OR($L$8=\"\",$L$8=0,$P$8=\"\",$P$8=0),\"\",$L$8*($P$8*$L$48+2*$L$50)+2*$L$51+2*$L$60)","v":""}]
[null,null,"Coûts de stockage  SANS / AVEC transport",{"$nulls":8},{"$f":"IF(AND($L$8<=4,$P$8>=730),L22,IF(AND($L$8<=4,$P$8<730),L23,IF(AND($L$8>4,$P$8>=730),L24,IF(AND($L$8>4,$P$8<730),L25,\"\"))))","v":""},null,{"$f":"IF(AND($L$8<=4,$P$8>=730),N22,IF(AND($L$8<=4,$P$8<730),N23,IF(AND($L$8>4,$P$8>=730),N24,IF(AND($L$8>4,$P$8<730),N25,\"\"))))","v":""},null,{"$f":"IF(AND($L$8<=4,$P$8>=730),P22,IF(AND($L$8<=4,$P$8<730),P23,IF(AND($L$8>4,$P$8>=730),P24,IF(AND($L$8>4,$P$8<730),P25,\"\"))))","v":""},null,{"$f":"IF(AND($L$8<=4,$P$8>=730),R22,IF(AND($L$8<=4,$P$8<730),R23,IF(AND($L$8>4,$P$8>=730),R24,IF(AND($L$8>4,$P$8<730),R25,\"\"))))","v":""}]
[]
[null,null,"N.B : transport affrété par xx depuis et/ou vers xxxx"]
[]
[null,null,"2 - Exemples de tarifs de stockage pour 1 palette AVEC ou SANS transport",{"$nulls":12},"Prix HT SANS transport",null,"Prix HT AVEC transport A/R"]
[]
[null,null,"Manutention et stockage d'une palette durant :",{"$nulls":8},1,null,"semaine(s)","–",{"$f":"T32*$L$48+2*$L$50+2*$L$51","v":{"v":14.834999999999999,"d":"14.84 €"}},null,{"$f":"P32+2*$L$59","v":{"v":104.835,"d":"104.84 €"}},null,{"v":7,"d":"7.00"}]
[]
[{"$nulls":11},1,null,"mois","–",{"$f":"T34*$L$48+2*$L$50+2*$L$51","v":{"v":19.549999999999997,"d":"19.55 €"}},null,{"$f":"P34+2*$L$59","v":{"v":109.55,"d":"109.55 €"}},null,{"v":30,"d":"30.00"}]
[]
[{"$nulls":11},3,null,"mois","–",{"$f":"T36*$L$48+2*$L$50+2*$L$51","v":{"v":31.85,"d":"31.85 €"}},null,{"$f":"P36+2*$L$59","v":{"v":121.85,"d":"121.85 €"}},null,{"v":90,"d":"90.00"}]
[]
[{"$nulls":11},6,null,"mois","–",{"$f":"T38*$L$48+2*$L$50+2*$L$51","v":{"v":50.3,"d":"50.30 €"}},null,{"$f":"P38+2*$L$59","v":{"v":140.3,"d":"140.30 €"}},null,{"v":180,"d":"180.00"}]
[]
[{"$nulls":11},12,null,"mois","–",{"$f":"T40*$L$48+2*$L$50+2*$L$51","v":{"v":88.22499999999998,"d":"88.23 €"}},null,{"$f":"P40+2*$L$59","v":{"v":178.22499999999997,"d":"178.23 €"}},null,{"$f":"L40*(365/12)","v":{"v":365,"d":"365.00"}}]
[]
[{"$nulls":11},24,null,"mois","–",{"$f":"T42*$L$49+2*$L$50+2*$L$51","v":{"v":148.45000000000002,"d":"148.45 €"}},null,{"$f":"P42+2*$L$59","v":{"v":238.45000000000002,"d":"238.45 €"}},null,{"$f":"L42*(365/12)","v":{"v":730,"d":"730.00"}}]
[]
[{"$nulls":11},36,null,"mois","–",{"$f":"T44*$L$49+2*$L$50+2*$L$51","v":{"v":215.975,"d":"215.98 €"}},null,{"$f":"P44+2*$L$59","v":{"v":305.975,"d":"305.98 €"}},null,{"$f":"L44*(365/12)","v":{"v":1095,"d":"1095.00"}}]
[]
[]
[null,null,"Conditions tarifaires :"]
[null,null," - Stockage à la journée ( si 2 ans de stockage maxi)",{"$nulls":8},{"v":0.205,"d":"0.205 €"},null," / palette","HT"]
[null,null," - Stockage à la journée (si 2 ans de stockage mini)",{"$nulls":8},{"v":0.185,"d":"0.185 €"},null," / palette","HT"]
[null,null," - Coût de fourche entrée/sortie",{"$nulls":8},{"v":2.15,"d":"2.15 €"},null," / palette","HT"]
[null,null," - Forfait administratif entrée/sortie",{"$nulls":8},{"v":4.55,"d":"4.55 €"},null," / palette","HT"]
[]
[null,null,"Coûts de transport :"]
[]
[null,null,"Transport par le labo xx (emprunt navette réception xx)"]
[null,null," - Gratuit"]
[]
[null,null,"Affrètement par la réception xx"]
[null,null," - Jusqu'à 4 palettes (navette) : ",{"$nulls":8},{"v":45,"d":"45 €"}]
[null,null," - Supérieur à 4 palettes (camion) :",{"$nulls":8},{"v":300,"d":"300 €"}]
[]
[null,null,"Affrètement par xx"]
[null,null," - 2 palettes (exemple) : ",{"$nulls":8},{"v":65,"d":"65 €"}]
[]
[null,null,"Prestations :"]
[null,null," - Réception des marchandises arrivant sur palette. Vérification des quantités et mise en stock."]
[null,null," - Recyclage possible des produits stockés : gratuit pour les produits D3E, rétrocession possible pour la ferraille "]
[null,null,"   mais facturation à prévoir pour les matières dangereuses (devis à demander)."]
[null,null," - Forfait administratif de 4.55 € pour l'entrée et idem pour la sortie de palettes (1 forfait par réception ou retour)."]
[null,null," - En cas de recyclage, forfait d'un coût de fourche par palette recyclée et d'un forfait administratif global de 4.55 €."]