{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["GARDE","SOMMAIRE","recap","Graphe magasin","graphe pole","masque","POINTS DIRECTEURS","RECEPTION","Zone commune","RETRAIT","FRUIT ET LEGUMES","EPICERIE","POISSON","PLS BOUCHERIE","technique","liste"],"not_rendered":{"charts":11,"images":0,"macros":1,"external_links":3,"defined_names":34,"comments":0,"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":"GARDE","index":0,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[48,4,50,6],[51,4,53,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Audit Conseil "]
[]
[null,null,null,null,null,"Check List Cash and Carry"]
[]
[null,null,null,null,null,"EVALUATION DE LA "]
[null,null,null,null,null,"MAITRISE"]
[null,null,null,null,null,"DES POINTS CRITIQUES"]
[]
[null,null,null,null,null,"selon le Référentiel Qualité "]
[null,null,null,null,null,"Cash and Carry"]
[]
[null,null,null,null,null,2017]
[]
[]
[null,null,null,null,{"$f":"\"Nom du magasin : \"&masque!E14","v":"Nom du magasin : Cash and Carry Sousse"}]
[null,null,null,null,{"$f":"\"Adresse du magasin :\"& MID(masque!E14,15,30)","v":"Adresse du magasin : Sousse"}]
[null,null,null,null,{"$f":"\"Date de la visite : \"&TEXT(masque!E12,\"jj/mm/aaaa\")","v":"Date de la visite : 14/06/2017"}]
[null,null,null,null,{"$f":"\"Heure de début de visite : \"&masque!E13","v":"Heure de début de visite : 08h"}]
[null,null,null,null,"Heure de fin de visite : ",null,"13h"]
[null,null,null,null,"Laboratoire conseil : Quali-Consult"]
[null,null,null,null,{"$f":"\"Nom de l'intervenant : \"&masque!E15","v":"Nom de l'intervenant : Mme Meriam CHOUCHENE"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Service Qualité UHD "]

{"sheet":"SOMMAIRE","index":1,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["SOMMAIRE"]
[]
[null,"Récapitulatif des notes"]
[null,"Récapitulatif des objectifs"]
[null,"Evolution de la note globale hygiène et du % de réalisation plans d'action "]
[null,"Evolution des notes par Pôle"]
[null,"Réception"]
[null,"Zone Commune"]
[null,"Retrait / Alerte"]
[null,"Epicerie"]
[null,"Poisson"]
[null,"Fruits et légumes/Epices, Olives"]
[null,"P.L.S./ BOUCHERIE "]
[null,"Service technique"]
[null,"Points directeurs"]

{"sheet":"recap","index":2,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[[13,6,16,6],[9,6,12,6],[41,6,44,6],[53,9,53,10],[54,9,54,10],[17,6,20,6],[54,7,54,8],[33,6,36,6],[37,6,40,6],[53,7,53,8],[21,6,24,6],[25,6,28,6],[29,6,32,6]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Visites","V1","V2","V3","V4","V5"]
[null,null,null,null,null,null,null,null,"Note ","Note","Note","Note","Note"]
[null,null,null,null,null,null,null,"Date de la visite ",{"$f":"IFERROR(masque!AU21,\"\")","v":"2017-02-17"},{"$f":"IFERROR(masque!CD21,\"\")","v":"2017-06-14"},{"$f":"IFERROR(masque!CE21,\"\")","v":"00:00:00"},{"$f":"IFERROR(masque!CF21,\"\")","v":"00:00:00"},{"$f":"IFERROR(masque!CG21,\"\")","v":"00:00:00"}]
[null,null,null,null,null,null,"RECEPTION","Note sur 100",{"$f":"IF(masque!AU22=\"\",\"\",masque!AU22)","v":0.28570000000000001},{"$f":"IF(masque!AT22=\"\",\"\",masque!AT22)","v":0.5357142857142857},{"$f":"IF(masque!AS22=\"\",\"\",masque!AS22)","v":""},{"$f":"IF(masque!AR22=\"\",\"\",masque!AR22)","v":""},{"$f":"IF(masque!AQ22=\"\",\"\",masque!AQ22)","v":""}]
[null,null,null,null,null,null,null,"Note tech",{"$f":"IF(masque!AU23=\"\",\"\",masque!AU23)","v":1},{"$f":"IF(masque!AT23=\"\",\"\",masque!AT23)","v":-1.5},{"$f":"IF(masque!AS23=\"\",\"\",masque!AS23)","v":""},{"$f":"IF(masque!AR23=\"\",\"\",masque!AR23)","v":""},{"$f":"IF(masque!AQ23=\"\",\"\",masque!AQ23)","v":""}]
[null,null,null,null,null,null,null,"Note F",{"$f":"IF(masque!AU24=\"\",\"\",masque!AU24)","v":0.36},{"$f":"IF(masque!AT24=\"\",\"\",masque!AT24)","v":0.69230769230769229},{"$f":"IF(masque!AS24=\"\",\"\",masque!AS24)","v":""},{"$f":"IF(masque!AR24=\"\",\"\",masque!AR24)","v":""},{"$f":"IF(masque!AQ24=\"\",\"\",masque!AQ24)","v":""}]
[null,null,null,null,null,null,null,"% réalisation plans d'action",{"$f":"IF(masque!AU25=\"\",\"\",masque!AU25)","v":0.4},{"$f":"IF(masque!AT25=\"\",\"\",masque!AT25)","v":0.625},{"$f":"IF(masque!AS25=\"\",\"\",masque!AS25)","v":""},{"$f":"IF(masque!AR25=\"\",\"\",masque!AR25)","v":""},{"$f":"IF(masque!AQ25=\"\",\"\",masque!AQ25)","v":""}]
[null,null,null,null,null,null,"ZONE COMMUNE","Note sur 100",{"$f":"IF(masque!AU26=\"\",\"\",masque!AU26)","v":0.76},{"$f":"IF(masque!AT26=\"\",\"\",masque!AT26)","v":0.56521739130434778},{"$f":"IF(masque!AS26=\"\",\"\",masque!AS26)","v":""},{"$f":"IF(masque!AR26=\"\",\"\",masque!AR26)","v":""},{"$f":"IF(masque!AQ26=\"\",\"\",masque!AQ26)","v":""}]
[null,null,null,null,null,null,null,"Note tech",{"$f":"IF(masque!AU27=\"\",\"\",masque!AU27)","v":0.30769999999999997},{"$f":"IF(masque!AT27=\"\",\"\",masque!AT27)","v":0.66666666666666663},{"$f":"IF(masque!AS27=\"\",\"\",masque!AS27)","v":""},{"$f":"IF(masque!AR27=\"\",\"\",masque!AR27)","v":""},{"$f":"IF(masque!AQ27=\"\",\"\",masque!AQ27)","v":""}]
[null,null,null,null,null,null,null,"Note F",{"$f":"IF(masque!AU28=\"\",\"\",masque!AU28)","v":0.68569999999999998},{"$f":"IF(masque!AT28=\"\",\"\",masque!AT28)","v":0.5},{"$f":"IF(masque!AS28=\"\",\"\",masque!AS28)","v":""},{"$f":"IF(masque!AR28=\"\",\"\",masque!AR28)","v":""},{"$f":"IF(masque!AQ28=\"\",\"\",masque!AQ28)","v":""}]
[null,null,null,null,null,null,null,"% réalisation plans d'action",{"$f":"IF(masque!AU29=\"\",\"\",masque!AU29)","v":0.5},{"$f":"IF(masque!AT29=\"\",\"\",masque!AT29)","v":0.25},{"$f":"IF(masque!AS29=\"\",\"\",masque!AS29)","v":""},{"$f":"IF(masque!AR29=\"\",\"\",masque!AR29)","v":""},{"$f":"IF(masque!AQ29=\"\",\"\",masque!AQ29)","v":""}]
[null,null,null,null,null,null,"POISSON ","Note sur 100",{"$f":"IF(masque!AU30=\"\",\"\",masque!AU30)","v":0.68},{"$f":"IF(masque!AT30=\"\",\"\",masque!AT30)","v":0.81818181818181823},{"$f":"IF(masque!AS30=\"\",\"\",masque!AS30)","v":""},{"$f":"IF(masque!AR30=\"\",\"\",masque!AR30)","v":""},{"$f":"IF(masque!AQ30=\"\",\"\",masque!AQ30)","v":""}]
[null,null,null,null,null,null,null,"Note tech",{"$f":"IF(masque!AU31=\"\",\"\",masque!AU31)","v":0.15379999999999999},{"$f":"IF(masque!AT31=\"\",\"\",masque!AT31)","v":0.96226415094339623},{"$f":"IF(masque!AS31=\"\",\"\",masque!AS31)","v":""},{"$f":"IF(masque!AR31=\"\",\"\",masque!AR31)","v":""},{"$f":"IF(masque!AQ31=\"\",\"\",masque!AQ31)","v":""}]
[null,null,null,null,null,null,null,"Note F",{"$f":"IF(masque!AU32=\"\",\"\",masque!AU32)","v":0.34},{"$f":"IF(masque!AT32=\"\",\"\",masque!AT32)","v":0.23076923076923078},{"$f":"IF(masque!AS32=\"\",\"\",masque!AS32)","v":""},{"$f":"IF(masque!AR32=\"\",\"\",masque!AR32)","v":""},{"$f":"IF(masque!AQ32=\"\",\"\",masque!AQ32)","v":""}]
[null,null,null,null,null,null,null,"% réalisation plans d'action",{"$f":"IF(masque!AU33=\"\",\"\",masque!AU33)","v":0.66669999999999996},{"$f":"IF(masque!AT33=\"\",\"\",masque!AT33)","v":0.42857142857142855},{"$f":"IF(masque!AS33=\"\",\"\",masque!AS33)","v":""},{"$f":"IF(masque!AR33=\"\",\"\",masque!AR33)","v":""},{"$f":"IF(masque!AQ33=\"\",\"\",masque!AQ33)","v":""}]
[null,null,null,null,null,null,"FRUITS ET LEGUMES/ OLIVES EPICES","Note sur 100",{"$f":"IF(masque!AU34=\"\",\"\",masque!AU34)","v":0.85419999999999996},{"$f":"IF(masque!AT34=\"\",\"\",masque!AT34)","v":0.77083333333333337},{"$f":"IF(masque!AS34=\"\",\"\",masque!AS34)","v":""},{"$f":"IF(masque!AR34=\"\",\"\",masque!AR34)","v":""},{"$f":"IF(masque!AQ34=\"\",\"\",masque!AQ34)","v":""}]
[null,null,null,null,null,null,null,"Note tech",{"$f":"IF(masque!AU35=\"\",\"\",masque!AU35)","v":0.125},{"$f":"IF(masque!AT35=\"\",\"\",masque!AT35)","v":0.375},{"$f":"IF(masque!AS35=\"\",\"\",masque!AS35)","v":""},{"$f":"IF(masque!AR35=\"\",\"\",masque!AR35)","v":""},{"$f":"IF(masque!AQ35=\"\",\"\",masque!AQ35)","v":""}]
[null,null,null,null,null,null,null,"Note F",{"$f":"IF(masque!AU36=\"\",\"\",masque!AU36)","v":0.89470000000000005},{"$f":"IF(masque!AT36=\"\",\"\",masque!AT36)","v":0.85},{"$f":"IF(masque!AS36=\"\",\"\",masque!AS36)","v":""},{"$f":"IF(masque!AR36=\"\",\"\",masque!AR36)","v":""},{"$f":"IF(masque!AQ36=\"\",\"\",masque!AQ36)","v":""}]
[null,null,null,null,null,null,null,"% réalisation plans d'action",{"$f":"IF(masque!AU37=\"\",\"\",masque!AU37)","v":0.8},{"$f":"IF(masque!AT37=\"\",\"\",masque!AT37)","v":0.66666666666666663},{"$f":"IF(masque!AS37=\"\",\"\",masque!AS37)","v":""},{"$f":"IF(masque!AR37=\"\",\"\",masque!AR37)","v":""},{"$f":"IF(masque!AQ37=\"\",\"\",masque!AQ37)","v":""}]
[null,null,null,null,null,null,"SERVICE TECHNIQUE","Note sur 100",{"$f":"IF(masque!AU38=\"\",\"\",masque!AU38)","v":0.4783},{"$f":"IF(masque!AT38=\"\",\"\",masque!AT38)","v":0.45454545454545453},{"$f":"IF(masque!AS38=\"\",\"\",masque!AS38)","v":""},{"$f":"IF(masque!AR38=\"\",\"\",masque!AR38)","v":""},{"$f":"IF(masque!AQ38=\"\",\"\",masque!AQ38)","v":""}]
[null,null,null,null,null,null,null,"Note tech",{"$f":"IF(masque!AU39=\"\",\"\",masque!AU39)","v":0.57889999999999997},{"$f":"IF(masque!AT39=\"\",\"\",masque!AT39)","v":0.45454545454545453},{"$f":"IF(masque!AS39=\"\",\"\",masque!AS39)","v":""},{"$f":"IF(masque!AR39=\"\",\"\",masque!AR39)","v":""},{"$f":"IF(masque!AQ39=\"\",\"\",masque!AQ39)","v":""}]
[null,null,null,null,null,null,null,"Note F",{"$f":"IF(masque!AU40=\"\",\"\",masque!AU40)","v":""},{"$f":"IF(masque!AT40=\"\",\"\",masque!AT40)","v":""},{"$f":"IF(masque!AS40=\"\",\"\",masque!AS40)","v":""},{"$f":"IF(masque!AR40=\"\",\"\",masque!AR40)","v":""},{"$f":"IF(masque!AQ40=\"\",\"\",masque!AQ40)","v":""}]
[null,null,null,null,null,null,null,"% réalisation plans d'action",{"$f":"IF(masque!AU41=\"\",\"\",masque!AU41)","v":0.28570000000000001},{"$f":"IF(masque!AT41=\"\",\"\",masque!AT41)","v":0.5},{"$f":"IF(masque!AS41=\"\",\"\",masque!AS41)","v":""},{"$f":"IF(masque!AR41=\"\",\"\",masque!AR41)","v":""},{"$f":"IF(masque!AQ41=\"\",\"\",masque!AQ41)","v":""}]
[null,null,null,null,null,null,"PLS/ BOUCHERIE","Note sur 100",{"$f":"IF(masque!AU42=\"\",\"\",masque!AU42)","v":0.8367},{"$f":"IF(masque!AT42=\"\",\"\",masque!AT42)","v":0.78082191780821919},{"$f":"IF(masque!AS42=\"\",\"\",masque!AS42)","v":""},{"$f":"IF(masque!AR42=\"\",\"\",masque!AR42)","v":""},{"$f":"IF(masque!AQ42=\"\",\"\",masque!AQ42)","v":""}]
[null,null,null,null,null,null,null,"Note tech",{"$f":"IF(masque!AU43=\"\",\"\",masque!AU43)","v":1},{"$f":"IF(masque!AT43=\"\",\"\",masque!AT43)","v":0.66666666666666663},{"$f":"IF(masque!AS43=\"\",\"\",masque!AS43)","v":""},{"$f":"IF(masque!AR43=\"\",\"\",masque!AR43)","v":""},{"$f":"IF(masque!AQ43=\"\",\"\",masque!AQ43)","v":""}]
[null,null,null,null,null,null,null,"Note F",{"$f":"IF(masque!AU44=\"\",\"\",masque!AU44)","v":0.85370000000000001},{"$f":"IF(masque!AT44=\"\",\"\",masque!AT44)","v":0.81818181818181823},{"$f":"IF(masque!AS44=\"\",\"\",masque!AS44)","v":""},{"$f":"IF(masque!AR44=\"\",\"\",masque!AR44)","v":""},{"$f":"IF(masque!AQ44=\"\",\"\",masque!AQ44)","v":""}]
[null,null,null,null,null,null,null,"% réalisation plans d'action",{"$f":"IF(masque!AU45=\"\",\"\",masque!AU45)","v":0.77780000000000005},{"$f":"IF(masque!AT45=\"\",\"\",masque!AT45)","v":0.5},{"$f":"IF(masque!AS45=\"\",\"\",masque!AS45)","v":""},{"$f":"IF(masque!AR45=\"\",\"\",masque!AR45)","v":""},{"$f":"IF(masque!AQ45=\"\",\"\",masque!AQ45)","v":""}]
[null,null,null,null,null,null,"RETRAIT ALERTE","Note sur 100",{"$f":"IF(masque!AU46=\"\",\"\",masque!AU46)","v":1},{"$f":"IF(masque!AT46=\"\",\"\",masque!AT46)","v":1},{"$f":"IF(masque!AS46=\"\",\"\",masque!AS46)","v":""},{"$f":"IF(masque!AR46=\"\",\"\",masque!AR46)","v":""},{"$f":"IF(masque!AQ46=\"\",\"\",masque!AQ46)","v":""}]
[null,null,null,null,null,null,null,"Note tech",{"$f":"IF(masque!AU47=\"\",\"\",masque!AU47)","v":""},{"$f":"IF(masque!AT47=\"\",\"\",masque!AT47)","v":""},{"$f":"IF(masque!AS47=\"\",\"\",masque!AS47)","v":""},{"$f":"IF(masque!AR47=\"\",\"\",masque!AR47)","v":""},{"$f":"IF(masque!AQ47=\"\",\"\",masque!AQ47)","v":""}]
[null,null,null,null,null,null,null,"Note F",{"$f":"IF(masque!AU48=\"\",\"\",masque!AU48)","v":1},{"$f":"IF(masque!AT48=\"\",\"\",masque!AT48)","v":1},{"$f":"IF(masque!AS48=\"\",\"\",masque!AS48)","v":""},{"$f":"IF(masque!AR48=\"\",\"\",masque!AR48)","v":""},{"$f":"IF(masque!AQ48=\"\",\"\",masque!AQ48)","v":""}]
[null,null,null,null,null,null,null,"% réalisation plans d'action",{"$f":"IF(masque!AU49=\"\",\"\",masque!AU49)","v":0},{"$f":"IF(masque!AT49=\"\",\"\",masque!AT49)","v":0},{"$f":"IF(masque!AS49=\"\",\"\",masque!AS49)","v":""},{"$f":"IF(masque!AR49=\"\",\"\",masque!AR49)","v":""},{"$f":"IF(masque!AQ49=\"\",\"\",masque!AQ49)","v":""}]
[null,null,null,null,null,null,"EPICERIE","Note sur 100",{"$f":"IF(masque!AU50=\"\",\"\",masque!AU50)","v":-0.1333},{"$f":"IF(masque!AT50=\"\",\"\",masque!AT50)","v":0.65517241379310343},{"$f":"IF(masque!AS50=\"\",\"\",masque!AS50)","v":""},{"$f":"IF(masque!AR50=\"\",\"\",masque!AR50)","v":""},{"$f":"IF(masque!AQ50=\"\",\"\",masque!AQ50)","v":""}]
[null,null,null,null,null,null,null,"Note tech",{"$f":"IF(masque!AU51=\"\",\"\",masque!AU51)","v":1},{"$f":"IF(masque!AT51=\"\",\"\",masque!AT51)","v":-1},{"$f":"IF(masque!AS51=\"\",\"\",masque!AS51)","v":""},{"$f":"IF(masque!AR51=\"\",\"\",masque!AR51)","v":""},{"$f":"IF(masque!AQ51=\"\",\"\",masque!AQ51)","v":""}]
[null,null,null,null,null,null,null,"Note F",{"$f":"IF(masque!AU52=\"\",\"\",masque!AU52)","v":0.56520000000000004},{"$f":"IF(masque!AT52=\"\",\"\",masque!AT52)","v":1},{"$f":"IF(masque!AS52=\"\",\"\",masque!AS52)","v":""},{"$f":"IF(masque!AR52=\"\",\"\",masque!AR52)","v":""},{"$f":"IF(masque!AQ52=\"\",\"\",masque!AQ52)","v":""}]
[null,null,null,null,null,null,null,"% réalisation plans d'action",{"$f":"IF(masque!AU53=\"\",\"\",masque!AU53)","v":0.6},{"$f":"IF(masque!AT53=\"\",\"\",masque!AT53)","v":1},{"$f":"IF(masque!AS53=\"\",\"\",masque!AS53)","v":""},{"$f":"IF(masque!AR53=\"\",\"\",masque!AR53)","v":""},{"$f":"IF(masque!AQ53=\"\",\"\",masque!AQ53)","v":""}]
[null,null,null,null,null,null,"POINTS DIRECEURS","Note sur 101",{"$f":"IF(masque!AU55=\"\",\"\",masque!AU55)","v":1},{"$f":"IF(masque!AT55=\"\",\"\",masque!AT55)","v":0.83333333333333337},{"$f":"IF(masque!AS55=\"\",\"\",masque!AS55)","v":""},{"$f":"IF(masque!AR55=\"\",\"\",masque!AR55)","v":""},{"$f":"IF(masque!AQ55=\"\",\"\",masque!AQ55)","v":""}]
[null,null,null,null,null,null,null,"Note tech",{"$f":"IF(masque!AU56=\"\",\"\",masque!AU56)","v":""},{"$f":"IF(masque!AT56=\"\",\"\",masque!AT56)","v":""},{"$f":"IF(masque!AS56=\"\",\"\",masque!AS56)","v":""},{"$f":"IF(masque!AR56=\"\",\"\",masque!AR56)","v":""},{"$f":"IF(masque!AQ56=\"\",\"\",masque!AQ56)","v":""}]
[null,null,null,null,null,null,null,"Note F",{"$f":"IF(masque!AU57=\"\",\"\",masque!AU57)","v":1},{"$f":"IF(masque!AT57=\"\",\"\",masque!AT57)","v":0.83333333333333337},{"$f":"IF(masque!AS57=\"\",\"\",masque!AS57)","v":""},{"$f":"IF(masque!AR57=\"\",\"\",masque!AR57)","v":""},{"$f":"IF(masque!AQ57=\"\",\"\",masque!AQ57)","v":""}]
[null,null,null,null,null,null,null,"% réalisation plans d'action",{"$f":"IF(masque!AU54=\"\",\"\",masque!AU54)","v":0},{"$f":"IF(masque!AT54=\"\",\"\",masque!AT54)","v":0},{"$f":"IF(masque!AS54=\"\",\"\",masque!AS54)","v":""},{"$f":"IF(masque!AR54=\"\",\"\",masque!AR54)","v":""},{"$f":"IF(masque!AQ54=\"\",\"\",masque!AQ54)","v":""}]
[null,null,null,null,null,null,null,"MOY Rayons",{"$f":"IFERROR(AVERAGE(I10,I14,I18,I22,I26,I30,I34,I38,I42),\"\")","v":0.64017777777777773},{"$f":"IFERROR(AVERAGE(J10,J14,J18,J22,J26,J30,J34,J38,J42),\"\")","v":0.71264666089043283},"","",""]
[null,null,null,null,null,null,null,"MOY technique",0.59505714285714284,8.9306134117454833E-2,"","",""]
[null,null,null,null,null,null,null,"MOY foncionnel",0.7124125,0.7405740093240093,"","",""]
[null,null,null,null,null,null,null,"MOY Plans d'actions",0.44779999999999998,0.44113756613756616,"","",""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"NOTE GLOBALE MAGASIN",null,{"$f":"IFERROR(AVERAGE(I46,J46,K46,L46,M46),\"\")","v":0.67641221933410534}]
[null,null,null,null,null,null,null,"MOYENNE DES % DE REALISATION\nDES PLANS D'ACTION",null,{"$f":"IFERROR(AVERAGE(I49,J49,K49,L49,M49),\"\")","v":0.44446878306878307}]

{"sheet":"Graphe magasin","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"graphe pole","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"masque","index":5,"n_rows":226,"n_cols":85,"rows_kept":226,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Note Rayon",null,"Accompagnateur","Rayons","Constat",null,null,null,"max F","max T","global",null,"Rapport CM El Menzah 9122013",null,"Checklist CM Houmet Souk011900"]
[{"$f":"$AP$22","v":0.58620689655172409},null,null,null,null,null,null,null,0.53569999999999995,null,"Moncef SMAOUI","RECEPTION","NOK",null,null,"REC",{"$f":"SUM(IF((BDRayon=$P2)*(FouS=\"F\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":27},{"$f":"SUM(IF((BDRayon=$P2)*(FouS=\"S\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":2},{"$f":"+Q2+R2","v":29}]
[null,null,null,null,null,null,null,null,1,null,"dir magasin","RETRAIT / ALERTE",null,null,null,"RET",{"$f":"SUM(IF((BDRayon=$P3)*(FouS=\"F\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":8},{"$f":"SUM(IF((BDRayon=$P3)*(FouS=\"S\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":0},{"$f":"+Q3+R3","v":8}]
[null,null,null,null,null,null,null,null,0.81820000000000004,null,"Ahmed ben Salem","POISSON",null,null,null,"POI",{"$f":"SUM(IF((BDRayon=$P4)*(FouS=\"F\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":37},{"$f":"SUM(IF((BDRayon=$P4)*(FouS=\"S\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":13},50]
[null,null,null,"Masque de saisie audit d'un magasin Carrefour Tunisie",null,null,null,null,0.77080000000000004,null,"slama nizar","FRUITS ET LEGUMES/OLIVES EPICES",null,null,null,"FRL",{"$f":"SUM(IF((BDRayon=$P5)*(FouS=\"F\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":40},{"$f":"SUM(IF((BDRayon=$P5)*(FouS=\"S\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":8},48]
[null,null,null,null,null,null,null,null,0.6552,null,"Hamza BRAIEK","EPICERIE /LIQUIDES",null,null,null,"EPL",{"$f":"SUM(IF((BDRayon=$P6)*(FouS=\"F\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":20},{"$f":"SUM(IF((BDRayon=$P6)*(FouS=\"S\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":5},25]
[null,null,null,null,null,null,null,null,0.78080000000000005,null,"Brahim brongi","PLS/BOUCHERIE",null,null,null,"PBO",{"$f":"SUM(IF((BDRayon=$P7)*(FouS=\"F\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":45},{"$f":"SUM(IF((BDRayon=$P7)*(FouS=\"S\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":14},59]
[null,null,null,"Pas toucher aux zones grisées",null,null,null,null,0.83330000000000004,null,"dir magasin","POINTS DIRECTEURS",null,null,null,"PDR",{"$f":"SUM(IF((BDRayon=$P8)*(FouS=\"F\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":14},{"$f":"SUM(IF((BDRayon=$P8)*(FouS=\"S\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":0},14]
[null,null,null,null,null,null,null,null,0.56520000000000004,null,"aymen Salah","ZONE COMMUNE",null,null,null,"ZOM",{"$f":"SUM(IF((BDRayon=$P9)*(FouS=\"F\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":16},{"$f":"SUM(IF((BDRayon=$P9)*(FouS=\"S\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":13},29]
[null,null,null,null,null,null,null,null,0.45450000000000002,null,"aymen Salah","SERVICE TECHNIQUE",null,null,null,"TEC",{"$f":"SUM(IF((BDRayon=$P10)*(FouS=\"F\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":0},{"$f":"SUM(IF((BDRayon=$P10)*(FouS=\"S\")*(RIGHT(Constat,2)=\"OK\"),SiOk))","v":22},22]
[null,null,null,"Code visite","V2"]
[null,null,null,"Date","2017-06-14"]
[null,null,null,"Heure début","08h"]
[null,null,null,"Magasin","Cash and Carry Sousse","CAC"]
[null,null,null,"Auditeurs","Mme Meriam CHOUCHENE"]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Rayon"]
[null,null,null,null,null,null,"Note global :",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,null,null,null,null,null,"% realisation plan d'action"]
[null,null,null,null,null,null,0.6764,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,null,null,null,null,null,"Visite :",{"$f":"E11","v":"V2"},"V5","V4","V3","V2","V1",null,"Rayons","NC levé","NC total","% realisation",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,"Visite","V1","V2","V3","V4","V5"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Date :",{"$f":"E12","v":"2017-06-14"},null,null,null,"2017-04-17","2017-02-17",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,null,null,null,null,"Date",{"$f":"INDEX($AP$21:$AU$21,,MATCH(CC20,$AP$20:$AU$20,))","v":"2017-02-17"},{"$f":"INDEX($AP$21:$AU$21,,MATCH(CD20,$AP$20:$AU$20,))","v":"2017-06-14"},{"$f":"INDEX($AP$21:$AU$21,,MATCH(CE20,$AP$20:$AU$20,))","v":"00:00:00"},{"$f":"INDEX($AP$21:$AU$21,,MATCH(CF20,$AP$20:$AU$20,))","v":"00:00:00"},{"$f":"INDEX($AP$21:$AU$21,,MATCH(CG20,$AP$20:$AU$20,))","v":"00:00:00"}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"RECEPTION",{"$f":"RECEPTION!F35","v":0.58620689655172409},null,null,null,0.5357142857142857,0.28570000000000001,null,"Réception",5,8,{"$f":"IFERROR(IF(AY22=0,0,AX22/AY22),\"\")","v":0.625},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(INDEX($AP22:$AU22,,MATCH($CC$20,$AP$20:$AU$20,))=0,\" \",INDEX($AP22:$AU22,,MATCH($CC$20,$AP$20:$AU$20,)))","v":0.28570000000000001},{"$f":"INDEX($AP22:$AU22,,MATCH($CD$20,$AP$20:$AU$20,))","v":0.58620689655172409},{"$f":"INDEX($AP22:$AU22,,MATCH($CE$20,$AP$20:$AU$20,))","v":0},{"$f":"INDEX($AP22:$AU22,,MATCH($CF$20,$AP$20:$AU$20,))","v":0},{"$f":"INDEX($AP22:$AU22,,MATCH($CG$20,$AP$20:$AU$20,))","v":0}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"TECH",{"$f":"RECEPTION!G34","v":-1.5},null,null,null,-1.5,1,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,null,null,null,null,null,1,-1.5,0,0,0]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"EXP",{"$f":"RECEPTION!F34","v":0.7407407407407407},null,null,null,0.69230769230769229,0.36,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,null,null,null,null,null,0.36,0.7407407407407407,0,0,0]
["ordre","CodVisite","BdDate","Heure","Magasin","Auditeur","BDRayon","Rayon","Srayon","Code","FouS","Texte","Penalite","SiOk","Constat","Points","NC","ActCor","Fixé_le","Responsable","Global","Region",null,"Ordre","CodVisite","BdDate","Magasin","Region","Auditeur","BDRayon","Srayon","Code","FouS","Texte","Penalite","NC","ActCor","Fixé_le","Responsable",null,"TAUX",{"$f":"AZ22","v":0.625},null,null,null,0.625,0.4,null,"ZONE COMMUNE",1,4,{"$f":"IFERROR(IF(AY25=0,0,AX25/AY25),\"\")","v":0.25},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,0.4,0.625,0,0,0]
[1,{"$f":"$E$11","v":"V2"},{"$f":"$E$12","v":"2017-06-14"},{"$f":"$E$13","v":"08h"},{"$f":"$F$14","v":"CAC"},{"$f":"$E$15","v":"Mme Meriam CHOUCHENE"},"REC","RECEPTION","RECEPTION","REC001","F","Présence et bon fonctionnement du thermomètre à sonde et infrarouge ",-2,2,"NOK",{"$f":"IF((O26=\"Nobs\")+(O26=\"NA\"),O26,IF(O26=\"ok\",N26,N26+M26))","v":0},"Absence de thermomètre à infra rouge. Achat en cours.+S38Q24:S44Q24:T164","Prévoir un thermomètre infra rouge.","2013-10-23","Moncef SMAOUI",{"$f":"P26","v":0},"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZONE COMMUNE",{"$f":"'Zone commune'!F34","v":0.72413793103448276},null,null,null,0.56521739130434778,0.76,null,"POISSON ",3,7,0.42857142857142855,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,0.76,0.72413793103448276,0,0,0]
[2,{"$f":"$E$11","v":"V2"},{"$f":"$E$12","v":"2017-06-14"},{"$f":"$E$13","v":"08h"},{"$f":"$F$14","v":"CAC"},{"$f":"$E$15","v":"Mme Meriam CHOUCHENE"},"REC","RECEPTION","RECEPTION","REC002","F","Thermomètre rangé avec son matériel de désinfection",-1,1,"NOK",0,"Absence de  matériel de désinfection","Prévoir du matériel de désinfection","2013-10-23",null,{"$f":"P27","v":0},"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECH",{"$f":"'Zone commune'!G33","v":0.69230769230769229},null,null,null,0.66666666666666663,0.30769999999999997,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,null,null,null,null,null,0.30769999999999997,0.69230769230769229,0,0,0]
[3,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","RECEPTION","REC003","F","Réalisation de la vérification  mensuelle du thermomètre",-1,1,"NOK",0,"L'enregistrement de suivi est réalisé mais le protocole n'est pas maitrisé; ","Une sensibilisation sur cet écart a eu lieu le jour de l'audit.","2017-06-14",null,0,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXP",{"$f":"'Zone commune'!F33","v":0.75},null,null,null,0.5,0.68569999999999998,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,null,null,null,null,null,{"$f":"IF(INDEX($AP28:$AU28,,MATCH($CC$20,$AP$20:$AU$20,))=0,\"\",INDEX($AP28:$AU28,,MATCH($CC$20,$AP$20:$AU$20,)))","v":0.68569999999999998},0.75,{"$f":"INDEX($AP28:$AU28,,MATCH($CE$20,$AP$20:$AU$20,))","v":0},0,0]
[4,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","RECEPTION","REC004","F","Affichage du tableau des températures réglementaires",-1,1,"OK",1,null,null,null,"",1,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ25","v":0.25},null,null,null,0.25,0.5,null,"FRUITS ET LEGUMES/ OLIVES EPICES",2,3,0.66666666666666663,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(INDEX($AP29:$AU29,,MATCH($CC$20,$AP$20:$AU$20,))=0,\"\",INDEX($AP29:$AU29,,MATCH($CC$20,$AP$20:$AU$20,)))","v":0.5},0.25,{"$f":"INDEX($AP29:$AU29,,MATCH($CE$20,$AP$20:$AU$20,))","v":0},0,0]
[5,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","RECEPTION","REC005","F","Vérification de la Présence des documents sanitaires des denrées d'origine animal frais ou congelés (documents de transport, AMM, certificat de salubrité, étiquetage conforme ,quittance d'abbaoir)",-5,2,"OK",2,null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POISSON ",{"$f":"POISSON!E63","v":0.86},null,null,null,0.81818181818181823,0.68,null,"SERVICE TECHNIQUE",4,8,0.5,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(INDEX($AP30:$AU30,,MATCH($CC$20,$AP$20:$AU$20,))=0,\"\",INDEX($AP30:$AU30,,MATCH($CC$20,$AP$20:$AU$20,)))","v":0.68},0.86,0,0,0]
[6,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","RECEPTION","REC006","F","Contrôle complet des températures",-5,2,"OK",2,null,null,null,null,2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECH",{"$f":"POISSON!E62","v":0.94594594594594594},null,null,null,0.96226415094339623,0.15379999999999999,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,null,null,null,null,null,{"$f":"INDEX($AP31:$AU31,,MATCH($CC$20,$AP$20:$AU$20,))","v":0.15379999999999999},0.94594594594594594,0,0,0]
[7,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","RECEPTION","REC007","F","Refus des marchandises hors critères d'acceptation",-5,2,"OK",2,null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXP",{"$f":"POISSON!F62","v":0.61538461538461542},null,null,null,0.23076923076923078,0.34,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,null,null,null,null,null,0.34,0.61538461538461542,0,0,0]
[8,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","RECEPTION","REC008","F","Absence d'attente en réception des marchandises ",-2,2,"OK",2,null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ26","v":0.42857142857142855},null,null,null,0.42857142857142855,0.66669999999999996,null,"PLS/ BOUCHERIE",2,4,0.5,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,0.66669999999999996,0.42857142857142855,0,0,0]
[9,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","RECEPTION","REC009","F","Retours correctement identifiés et balisés",-2,2,"OK",2,null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FRUITS ET LEGUMES/ OLIVES EPICES",{"$f":"'FRUIT ET LEGUMES'!E44","v":0.9375},null,null,null,0.77083333333333337,0.85419999999999996,null,"RETRAIT ALERTE",0,0,0,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,0.85419999999999996,0.9375,0,0,0]
[10,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","EXTERIEUR ET AIRE DE RECEPTION","REC010","F","Absence d'accumulation de nuisances",-5,2,"OK",2,null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECH",{"$f":"'FRUIT ET LEGUMES'!F43","v":1},null,null,null,0.375,0.125,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,null,null,null,null,null,0.125,1,0,0,0]
[11,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","EXTERIEUR ET AIRE DE RECEPTION","REC011","F","Absence de stockage sauvage",-2,2,"OK",2,null,null,null,null,2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXP",{"$f":"'FRUIT ET LEGUMES'!E43","v":0.92500000000000004},null,null,null,0.85,0.89470000000000005,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,null,null,null,null,null,0.89470000000000005,0.92500000000000004,0,0,0]
[12,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","EXTERIEUR ET AIRE DE RECEPTION","REC012","F","Propreté correcte des alentours de la benne.",-1,1,"NOK",0,"Les bennes ne sont pas correctement protégées. \nElles sont entreposées à proximité de la porte d'accès au magasin.","Protéger les bennes et améliorer la gestion des déchets.","2012-03-16","Moncef SMAOUI",0,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ29","v":0.66666666666666663},null,null,null,0.66666666666666663,0.8,null,"EPICERIE",1,1,1,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,0.8,0.66666666666666663,0,0,0]
[13,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","EXTERIEUR ET AIRE DE RECEPTION","REC013","F","Absence de nuisible",-2,2,"NOK",0,"Présence de nid d'hirondelle au plafond du quai de réception.\nPrésence de mouches.","Renforcer la lutte contre les nuisibles à ce niveau.","2017-06-14","Moncef SMAOUI",0,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SERVICE TECHNIQUE",{"$f":"technique!E43","v":0.40909090909090912},null,null,null,0.45454545454545453,0.4783,null,"POINTS DIRECEURS",0,1,0,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,0.4783,0.40909090909090912,0,0,0]
[14,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","EXTERIEUR ET AIRE DE RECEPTION","REC014","F","Absence d'odeur nauséabonde",-1,1,"OK",1,null,null,null,"",1,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECH",{"$f":"technique!F42","v":0.40909090909090912},null,null,null,0.45454545454545453,0.57889999999999997,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,null,null,null,null,null,0.57889999999999997,0.40909090909090912,0,0,0]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","PROPRETE ET ENTRETIEN DES LOCAUX","REC014","F","Entretien et propreté du sas  de réception, des sols, plinthes, murs, plafonds, portes satisfaisants, des évacuations au sol satisfaisants",-5,2,"OK",2,null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXP",{"$f":"technique!E42","v":""},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,null,null,null,null,null,null,null,null,null,null,0,"",0,0,0]
[15,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","PROPRETE ET ENTRETIEN DES LOCAUX","REC014","S","Entretien et propreté du sas  de réception, des sols, plinthes, murs, plafonds, portes satisfaisants, des évacuations au sol satisfaisants",-5,2,"NOK",-3,"Absence de station de nettoyage pour la zone de réception; cette opération est réalisée par l'eau du RIA.\nPrésence de crevasses dans les murs du sas.","Prévoir une station de nettoyage dans la zone de réception.\nColmater les trous aux murs.","2017-06-14",null,-3,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ30","v":0.5},null,null,null,0.5,0.28570000000000001,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,null,null,null,null,null,0.28570000000000001,0.5,0,0,0]
[18,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","PROPRETE ET ENTRETIEN DES LOCAUX","REC018","F","Les résultats d'audits externes sont affichés à la réception",-1,1,"OK",1,null,null,null,"",1,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLS/ BOUCHERIE",{"$f":"'PLS BOUCHERIE'!E65","v":0.81355932203389836},null,null,null,0.78082191780821919,0.8367,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,null,null,null,null,null,0.8367,0.81355932203389836,0,0,0]
[19,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","REC","RECEPTION","PROPRETE ET ENTRETIEN DES LOCAUX","REC019","F","Mise en place de Plan d'action suite aux audits",-1,1,"OK",1,null,null,null,"",1,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECH",{"$f":"'PLS BOUCHERIE'!F64","v":0.6428571428571429},null,null,null,0.66666666666666663,1,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,null,null,null,null,null,1,0.6428571428571429,0,0,0]
[20,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","RET","RETRAIT / ALERTE","RETRAIT / ALERTE","REC020","F","Existence d'un classeur Alertes / Retraits et de la procédure ",-5,2,"OK",2,null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXP",{"$f":"'PLS BOUCHERIE'!E64","v":0.8666666666666667},null,null,null,0.81818181818181823,0.85370000000000001,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,null,null,null,null,null,0.85370000000000001,0.8666666666666667,0,0,0]
[21,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","RET","RETRAIT / ALERTE","RETRAIT / ALERTE","REC021","F","Connaisance et affichage de la procédure de retrait \n",-5,2,"OK",2,null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ33","v":0.5},null,null,null,0.5,0.77780000000000005,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,null,null,null,null,null,0.77780000000000005,0.5,0,0,0]
[22,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","RET","RETRAIT / ALERTE","RETRAIT / ALERTE","REC022","F","Existence de zones de consignation",-2,2,"OK",2,null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETRAIT ALERTE",{"$f":"RETRAIT!F26","v":1},null,null,null,1,1,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,null,null,null,null,null,1,1,0,0,0]
[23,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","RET","RETRAIT / ALERTE","RETRAIT / ALERTE","REC023","F","Les produits concernés par ces alertes et retraits sont retirés de la vente ",-2,2,"OK",2,null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECH",{"$f":"RETRAIT!G25","v":""},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,null,null,null,null,null,null,null,null,null,null,0,"",0,0,0]
[24,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC024","F","Equipement propre (table. Balance, Caisse)",-2,2,"OK",2,"\n",null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXP",{"$f":"RETRAIT!F25","v":1},null,null,null,1,1,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,null,null,null,null,null,1,1,0,0,0]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC025","F","Entretien et propreté des sols, plinthes, murs plafonds, portes satisfaisants",-5,2,"OK",{"$f":"IF((O49=\"Nobs\")+(O49=\"NA\"),O49,IF(O49=\"ok\",N49,N49+M49))","v":2},null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ34","v":0},null,null,null,0,0,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,null,null,null,null,null,0,0,0,0,0]
[25,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC025","S","Entretien et propreté des sols, plinthes, murs plafonds, portes satisfaisants",-5,2,"NOK",-3,"\nPrésence de fuite d'eau au niveau de l'évier.","Réparer la fuite","2017-06-14","Ahmed ben Salem",-3,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EPICERIE",{"$f":"EPICERIE!K34","v":0.48},null,null,null,0.65517241379310343,-0.1333,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,null,null,null,null,null,-0.1333,0.48,0,0,0]
[26,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC026","F","Entretien et propreté des évacuations au sol satisfaisants",-1,1,"OK",{"$f":"IF((O51=\"Nobs\")+(O51=\"NA\"),O51,IF(O51=\"ok\",N51,N51+M51))","v":1},null,null,null,"",1,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECH",{"$f":"EPICERIE!L33","v":1},null,null,null,-1,1,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,null,null,null,null,null,1,1,0,0,0]
[26,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC026","S","Entretien et propreté des évacuations au sol satisfaisants",-1,1,"OK",1,null,null,null,"",1,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXP",{"$f":"EPICERIE!K33","v":0.35},null,null,null,1,0.56520000000000004,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,null,null,null,null,null,0.56520000000000004,0.35,0,0,0]
[27,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC027","S","Présence et bon fonctionnement du thermomètre enregistreur",-1,1,"OK",1,null,null,null,"",1,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ37","v":1},null,null,null,1,0.6,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,null,null,null,null,null,0.6,1,0,0,0]
[28,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC028","S","Entretien et Nettoyage des évaporateurs",-2,2,"OK",2,null," ",null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ38","v":0},null,null,null,0,0,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,null,null,null,null,null,0,0,0,0,0]
[29,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC029","F","Présence d'une poubelle conforme",-1,1,"OK",1,null,null,null,"",1,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POINTS DIRECEURS",{"$f":"'POINTS DIRECTEURS'!E22","v":0.9285714285714286},null,null,null,0.83333333333333337,1,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,null,null,null,null,null,1,0.9285714285714286,0,0,0]
[30,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC030","F","Respect des DLC ",-20,2,"OK",2,null,null,null,"",2,"SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECH",{"$f":"'POINTS DIRECTEURS'!F21","v":""},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,null,null,null,null,null,null,null,null,null,null,0,"",0,0,0]
[31,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC031","F","Absence de charge excessive",-1,1,"NA","NA","Absence de vente de poissons frais le jour de l'audit",null,null,"","NA","SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXP",{"$f":"'POINTS DIRECTEURS'!E21","v":0.9285714285714286},null,null,null,0.83333333333333337,1,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,null,null,null,null,null,1,0.9285714285714286,0,0,0]
[32,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC032","F","Absence de produits non identifiés",-5,2,"NA","NA",null,null,null,"","NA","SOUSSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moyenne",{"$f":"AVERAGE(inigraphe,AP26,AP30,AP34,AP38,AP42,AP46,AP50)","v":0.72631188233887678},null,null,null,0.69756082683507026,0.62649999999999995,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,null,null,null,null,null,0.62649999999999995,0.72631188233887678,0,0,0]
[33,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC033","F","Présentation satisfaisante des produits au niveau du pole: Poissons entiers/mollusques",-1,1,"NA","NA",null,null,null,"","NA","SOUSSE"]
[34,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC034","F","Présentation satisfaisante des produits au niveau du pole: Coquillages vivants",-1,1,"NA","NA",null,null,null,"","NA","SOUSSE"]
[35,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC035","F","Présentation satisfaisante des produits au niveau du pole: Crustacés vivants",-1,1,"NA","NA",null,null,null,"","NA","SOUSSE"]
[36,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC036","F","Respect des températures réglementaires ",-2,2,"NA","NA",null,null,null,"","NA","SOUSSE"]
[37,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC037","F","Absence de décoration au contact des produits",-2,2,"NA","NA",null,null,null,"","NA","SOUSSE"]
[38,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC038","F","Produits correctement glacés ou présentés.",-2,2,"NA","NA",null,null,null,"","NA","SOUSSE"]
[39,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC039","F","Etiquetage et balisage conformes et complets",-5,2,"NA","NA",null,null,null,"","NA","SOUSSE"]
[40,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC040","F","Absence d’étiquettes piquées dans les produits",-5,2,"NA","NA",null,null,null,"","NA","SOUSSE"]
[41,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","POLE","REC041","F","Balances tarées",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[42,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","LINEAIRE SURGELE","REC042","F","Absence d'attente hors froid",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[43,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","LINEAIRE SURGELE","REC043","F","Propreté des meubles satisfaisants",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[44,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","LINEAIRE SURGELE","REC044","S","entretien des meubles satisfaisants",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[45,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","LINEAIRE SURGELE","REC045","F","Absence de charge excessive",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[46,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","LINEAIRE SURGELE","REC046","F","Respect des DLC ",-10,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[47,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","LINEAIRE SURGELE","REC047","S","Température  adaptée (-18°C)",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[48,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","LINEAIRE SURGELE","REC048","F","Aspect satisfaisant des produits",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[49,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","METHODES DE TRAVAIL","REC049","F","Glaçage hygiénique des caisses",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[50,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","METHODES DE TRAVAIL","REC050","F","Manipulations rigoureuses.",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[51,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","METHODES DE TRAVAIL","REC051","F","présence d'une pelle à glace pas à meme le sol.",-1,1,"NOK",0,"La pelle à glace est abimée","Remplacer la pelle.",null,"Ahmed ben Salem",0,"SOUSSE"]
[53,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","METHODES DE TRAVAIL","REC053","F","Entretien, propreté et stockage satisfaisants des pics prix",-1,1,"Nobs","Nobs",null,null,null,"","Nobs","SOUSSE"]
[54,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","HYGIENE","REC054","F","Produits d’entretien conformes et correctement utilisés et rangés",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[56,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","HYGIENE","REC056","F","Présence du planning de nettoyage",-1,1,"NA","NA",null,null,null,"","NA","SOUSSE"]
[null,"V4","2015-12-01","10h00","CAC","Dr Hend KAMOUN","POI","POISSON","HYGIENE","REC057","F","Propreté et entretien  des évacuations au sol satisfaisants",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[57,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","HYGIENE","REC057","S","Propreté et entretien  des évacuations au sol satisfaisants",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[58,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","HYGIENE","REC058","F","Entretien et propreté des bacs à glace satisfaisants",-1,1,"Nobs","Nobs",null,null,null,"","Nobs","SOUSSE"]
[59,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","HYGIENE","REC059","F","Poubelles propres",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[60,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","HYGIENE","REC060","F","Mains propres et protection des plaies",-1,1,"NOK",0,"absence de distributeur papier et distributeur savon liquide. ","Fixer les distributeurs.","2017-02-17","Ahmed ben Salem",0,"SOUSSE"]
[61,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","HYGIENE","REC061","S","Lave-mains équipés réglementairement",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[62,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","AUTOCONTROLES","REC062","F","Présence du référentiel qualité.",-2,2,"OK",{"$f":"IF((O87=\"Nobs\")+(O87=\"NA\"),O87,IF(O87=\"ok\",N87,N87+M87))","v":2},null,null,null,"",2,"SOUSSE"]
[63,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","AUTOCONTROLES","REC063","F","Suivi des autocontrôles de nettoyage",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[64,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","AUTOCONTROLES","REC064","F","Autocontrôle des températures",-5,5,"OK",5,null,null,null,"",5,"SOUSSE"]
[65,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","AUTOCONTROLES","REC065","F","Les résultats d'audits externes sont affichés au pole",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[66,{"$f":"$E$11","v":"V2"},{"$f":"$E$12","v":"2017-06-14"},{"$f":"$E$13","v":"08h"},{"$f":"$F$14","v":"CAC"},{"$f":"$E$15","v":"Mme Meriam CHOUCHENE"},"POI","POISSON","AUTOCONTROLES","REC066","F","Mise en place de Plan d'action suite aux audits",-1,1,"Nobs","Nobs",null,null,null,"",{"$f":"P91","v":"Nobs"},"SOUSSE"]
[67,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","POI","POISSON","AUTOCONTROLES","REC067","F","Mise en place d'actions correctives suite aux analyses non conformes (surgelés)",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[68,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC068","F","Linéaires propres.",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC069","F","Entretien et propreté des sols, plinthes, murs plafonds, portes satisfaisants",-5,2,"OK",{"$f":"IF((O94=\"Nobs\")+(O94=\"NA\"),O94,IF(O94=\"ok\",N94,N94+M94))","v":2},null,null,null,null,2,"SOUSSE"]
[69,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC069","S","Entretien et propreté des sols, plinthes, murs plafonds, portes satisfaisants",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC070","F","Suivi des autocontrôles de nettoyage",-1,1,"NOK",{"$f":"IF((O96=\"Nobs\")+(O96=\"NA\"),O96,IF(O96=\"ok\",N96,N96+M96))","v":0},"Absence de séparation dans le temps pour la sortie des produits casse à partir de la CF FLEG. ","Fixer les horaires de sortie des produits casse (passant par les chambres froides.)",null,null,0,"SOUSSE"]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC070","F","Entretien et propreté des évacuations au sol satisfaisants",-1,1,"OK",{"$f":"IF((O97=\"Nobs\")+(O97=\"NA\"),O97,IF(O97=\"ok\",N97,N97+M97))","v":1},null,null,null,"",1,"SOUSSE"]
[70,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC070","S","Entretien et propreté des évacuations au sol satisfaisants",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[71,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC071","S","Entretien et Nettoyage des évaporateurs",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[72,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC072","F","Absence de produits non identifiés",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[73,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC073","S","Présence et bon fonctionnement du thermomètre enregistreur",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[74,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC074","F","Respect des DLC /DLUO (olives) ",-10,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[75,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC075","F","Respect des DLC /DLUO (fruits et légumes emballés) ",-10,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[76,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC076","F","Respect des DLC /DLUO (fruits secs, épices) ",-10,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[77,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC077","S","Respect des températures réglementaires",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[78,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC078","F","Lisibilité de l'étiquetage et balisage complet",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[79,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC079","F","Affichage du prix",-1,1,"NOK",0,"présence de traces de rouille sur les étagères","Procéder à un traitement anti rouille et peinture pour les étagères.","2017-02-17",null,0,"SOUSSE"]
[81,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC081","F","Matériel propre (caisse, table, balance,etagere)",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[82,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC082","F","Tri des produits effectué.",-10,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[83,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC083","F","Rotation des produits effectuée.",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[84,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC084","F","Absence de stockage au sol",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[85,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC085","F","Absence de mélange de produits différents.",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[86,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","POLE","REC086","F","Balances tarées",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[88,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","HYGIENE ","REC088","F","Produits d’entretien conformes et correctement utilisés et rangés",-5,2,"OK",2,null,null,null,null,2,"SOUSSE"]
[89,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","HYGIENE ","REC089","F","Présence du planning de nettoyage ",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[90,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","AUTOCONTROLES","REC090","F","Présence du référentiel qualité",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[91,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","AUTOCONTROLES","REC091","F","Autocontrôle des températures",-5,5,"OK",5,null,null,null,"",5,"SOUSSE"]
[92,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","AUTOCONTROLES","REC092","F","Mise en place des auto-controles du nettoyage",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[93,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","AUTOCONTROLES","REC093","F","Les résultats d'audits externes sont affichés au pole",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[94,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","FRL","FRUITS ET LEGUMES/OLIVES EPICES","AUTOCONTROLES","REC094","F","Mise en place de Plan d'action suite aux audits",-1,1,"NOK",0,"Bien que la quantité de ferraille et les restes d'emballage a diminué, une partie  demeure  au niveau de la réserve.\nPrésence des fientes d'oiseaux aux murs de la réserve.","Eliminer la totalité de la ferraille.\nNettoyer les murs.","14/06/2017\n17/02/2017","Hamza BRAIEK",0,"SOUSSE"]
[95,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","RESERVE","REC095","F","Réserve propre et rangée.",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[96,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","RESERVE","REC096","F","Zone de retour produit balisée",-2,2,"NOK",0,"Entreposage des sacs de farine sur des palettes en bois abimées\n","Utiliser des palettes en bois en bon état.",null,"Hamza BRAIEK",0,"SOUSSE"]
[97,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","RESERVE","REC097","F","Absence de stockage au sol",-1,1,"NOK",0,"Stockage du lait dans le couloir destiné à l'entreposage des produits casse (couloir derrière les chambres froides). \n","Stocker le lait dans la zone de stockage des liquides.\n","2017-06-14","Hamza BRAIEK",0,"SOUSSE"]
[98,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","RESERVE","REC098","F","Produits consignés isolés et balisés",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[99,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","RESERVE","REC099","F","Respect des DLUO",-20,2,"NA","NA",null,null,null,null,"NA","SOUSSE"]
[100,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","HYGIENE","REC100","F","Présence du planning de nettoyage",-1,1,"OK",1,null,null,null,null,1,"SOUSSE"]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","LINEAIRE ","REC101","S","Entretien des linéaires",-10,5,"OK",{"$f":"IF((O127=\"Nobs\")+(O127=\"NA\"),O127,IF(O127=\"ok\",N127,N127+M127))","v":5},null,null,null,"",5,"SOUSSE"]
[101,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","LINEAIRE ","REC101","F","Linéaires propres et rangés",-10,5,"NOK",-5,"Présence de rouille sur les boites de tomate pelée (DLUO 15/07/2019).\nPrésence des éclaboussures de confiture sur l'étagère suite à un éclatement de la boite. ","Eliminer les boites de conserve rouillées.","2017-06-14","Hamza BRAIEK",-5,"SOUSSE"]
[102,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","LINEAIRE ","REC102","F","Aspect satisfaisant des produits.",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[103,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","LINEAIRE ","REC103","F","Absence de produits non identifiés",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[104,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","LINEAIRE ","REC104","F","RESPECT DES DLUO ",-20,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[105,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","AUTOCONTROLES","REC105","F","Présence du référentiel Qualité",-2,2,"Nobs","Nobs",null,null,null,null,"Nobs","SOUSSE"]
[106,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","AUTOCONTROLES","REC106","F","Suivi des autocontrôles de nettoyage",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[107,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","AUTOCONTROLES","REC107","F","Les résultats d'audits externes sont affichés au pole",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[108,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","EPL","EPICERIE /LIQUIDES","AUTOCONTROLES","REC108","F","Mise en place de Plan d'action suite aux audits",-1,1,"NA","NA",null,null,null,"","NA","SOUSSE"]
[109,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","CHAMBRE FROIDE PLS","REC109","S","Température adaptée (+4°C)",-1,1,"NA","NA",null,null,null,"","NA","SOUSSE"]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","CHAMBRE FROIDE PLS","REC110","F","Propreté et entretien de la chambre froide satisfaisant Sols, évacuations, Murs, plafonds, portes, Etagères",-5,2,"NA",{"$f":"IF((O137=\"Nobs\")+(O137=\"NA\"),O137,IF(O137=\"ok\",N137,N137+M137))","v":"NA"},null,null,null,null,"NA","SOUSSE"]
[110,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","CHAMBRE FROIDE PLS","REC110","S","Propreté et entretien de la chambre froide satisfaisant Sols, évacuations, Murs, plafonds, portes, Etagères",-5,2,"NA","NA",null,null,null,"","NA","SOUSSE"]
[113,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","CHAMBRE FROIDE PLS","REC113","F","Rangement satisfaisant",-1,1,"NA","NA",null,null,null,"","NA","SOUSSE"]
[114,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","CHAMBRE FROIDE PLS","REC114","F","Absence de stockage au sol",-1,1,"NA","NA",null,null,null,"","NA","SOUSSE"]
[115,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","CHAMBRE FROIDE PLS","REC115","F","Absence de déchets non isolés/ non identifiés",-10,2,"NA","NA",null,null,null,"","NA","SOUSSE"]
[116,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","CHAMBRE FROIDE PLS","REC116","F","Respect des DLC/DLUO",-10,2,"NA","NA",null,null,null,"","NA","SOUSSE"]
[117,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","CHAMBRE FROIDE PLS","REC117","F","Absence de palette en bois, de carton",-1,1,"NA","NA",null,null,null,"","NA","SOUSSE"]
[118,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","CHAMBRE FROIDE PLS","REC118","F","Absence de produit non identifié en chambre froide",-2,2,"NA","NA",null,null,null,"","NA","SOUSSE"]
[119,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","CHAMBRE FROIDE PLS","REC119","S","Présence et bon fonctionnement du thermomètre enregistreur",-1,1,"NA","NA",null,null,null,"","NA","SOUSSE"]
[120,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","CHAMBRE FROIDE PLS","REC120","F","Porte fermée",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[121,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","HYGIENE ","REC121","F","Produits d’entretien conformes et correctement utilisés et rangés",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[123,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","HYGIENE ","REC123","F","Présence du planning de nettoyage",-1,1,"NOK",0,"Linéaires rouillées","Repeindre les étagères.",null,"Brahim brongi",0,"SOUSSE"]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC124","S","Entretien des linéaires",-5,2,"OK",{"$f":"IF((O149=\"Nobs\")+(O149=\"NA\"),O149,IF(O149=\"ok\",N149,N149+M149))","v":2},null,null,null,"",2,"SOUSSE"]
[124,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC124","F","Linéaires propres.",-5,2,"NOK",-3,"Résine écaillée\nla vitre de la porte est brisée.","Fixer le revêtement du sol.\nRemplacer la vitre brisée.",null,"Brahim brongi",-3,"SOUSSE"]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC125","S","Entretien et propreté des sols, plinthes, murs plafonds, portes satisfaisants",-5,2,"NOK",{"$f":"IF((O151=\"Nobs\")+(O151=\"NA\"),O151,IF(O151=\"ok\",N151,N151+M151))","v":-3},"Présence de piqûres de moisissures sur la porte.","Renforcer le nettoyage à ce niveau.",null,"Brahim brongi",-3,"SOUSSE"]
[125,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC125","F","Entretien et propreté des sols, plinthes, murs plafonds, portes satisfaisants",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC126","F","Entretien et propreté des évacuations au sol satisfaisants",-1,1,"OK",{"$f":"IF((O153=\"Nobs\")+(O153=\"NA\"),O153,IF(O153=\"ok\",N153,N153+M153))","v":1},null,null,null,"",1,"SOUSSE"]
[126,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC126","S","Entretien et propreté des évacuations au sol satisfaisants",-1,1,"OK",{"$f":"IF((O154=\"Nobs\")+(O154=\"NA\"),O154,IF(O154=\"ok\",N154,N154+M154))","v":1},null,null,null,"",1,"SOUSSE"]
[127,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC127","S","Présence et bon fonctionnement du thermomètre enregistreur",-1,1,"OK",1,null,null,null,"",{"$f":"P155","v":1},"SOUSSE"]
[128,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC128","S","Entretien et Nettoyage des évaporateurs",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[129,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC129","F","Absence de produits non identifiés",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[130,{"$f":"$E$11","v":"V2"},{"$f":"$E$12","v":"2017-06-14"},{"$f":"$E$13","v":"08h"},{"$f":"$F$14","v":"CAC"},{"$f":"$E$15","v":"Mme Meriam CHOUCHENE"},"PBO","PLS/BOUCHERIE","POLE","REC130","F","Absence de palette en bois, de carton",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[131,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC131","F","Respect des DLC (crèmerie et ultra frais) ",-10,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[132,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC132","F","Respect des DLC (charcuterie) ",-10,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[133,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC133","F","Respect des DLC (Boucherie) ",-10,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[134,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC134","F","Respect des DLC/DLUO (viennoiserie industrielle) ",-10,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[135,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC135","S","Respect des températures réglementaires",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[136,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC136","F","Etiquetage conforme",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[137,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC137","F","Absence de charge excessive",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[138,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC138","F","Absence de stockage au sol",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[139,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","POLE","REC139","F","Aspect des produits satisfaisant.",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[140,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","LINEAIRE SURGELE","REC140","F","Absence d'attente hors froid",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[141,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","LINEAIRE SURGELE","REC141","F","Propreté des meubles satisfaisants",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[142,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","LINEAIRE SURGELE","REC142","S","entretien des meubles satisfaisants",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[143,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","LINEAIRE SURGELE","REC143","F","Absence de charge excessive",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[144,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","LINEAIRE SURGELE","REC144","F","Respect des DLC  (PLS) ",-10,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[145,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","LINEAIRE SURGELE","REC145","F","Respect des DLC (Boucherie) ",-10,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[146,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","LINEAIRE SURGELE","REC146","S","Température  adaptée (-18°C)",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[147,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","LINEAIRE SURGELE","REC147","F","Aspect satisfaisant des produits",-1,1,"OK",1,null,null,null,null,1,"SOUSSE"]
[148,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","AUTOCONTROLES","REC148","F","Présence du référentiel qualité",-2,2,"OK",2,null,null,null,null,2,"SOUSSE"]
[149,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","AUTOCONTROLES","REC149","F","Mise en place des autocontrôles des températures",-5,5,"OK",5,null,null,null,null,5,"SOUSSE"]
[150,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","AUTOCONTROLES","REC150","F","Mise en place des auto-contrôles du nettoyage",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[151,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","AUTOCONTROLES","REC151","F","Les résultats d'audits externes sont affichés au pole",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[152,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","AUTOCONTROLES","REC152","F","Mise en place de Plan d'action suite aux audits",-1,1,"NA","NA",null,null,null,"","NA","SOUSSE"]
[153,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PBO","PLS/BOUCHERIE","AUTOCONTROLES","REC153","F","Mise en place d'actions correctives suite aux analyses non conformes (surgelés)",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[154,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PDR","POINTS DIRECTEURS","POINTS DIRECTEURS","REC154","F","Armoire à pharmacie conforme",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[155,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PDR","POINTS DIRECTEURS","POINTS DIRECTEURS","REC155","F","Présence de la réglementation en vigueur",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[156,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PDR","POINTS DIRECTEURS","POINTS DIRECTEURS","REC156","F","Classement des dossiers de retrait",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[157,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PDR","POINTS DIRECTEURS","POINTS DIRECTEURS","REC157","F","Classement des contrôles officiels",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[158,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PDR","POINTS DIRECTEURS","POINTS DIRECTEURS","REC158","F","Classement des rapports d'audits internes et des plans d'action",-1,1,"NOK",0,"Absence de plan de formation 2017.","Dresser un plan de formation relatif aux BPH.","2017-06-14","dir magasin",0,"SOUSSE"]
[159,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PDR","POINTS DIRECTEURS","POINTS DIRECTEURS","REC159","F","Présence du plan de formations de l'année en cours",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[160,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PDR","POINTS DIRECTEURS","POINTS DIRECTEURS","REC160","F","Suivi de l'état de santé du personnel à jour (analyses copro, visites médicales…)",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[161,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","PDR","POINTS DIRECTEURS","POINTS DIRECTEURS","REC161","F","Etalonnage des balances effectué",-15,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[162,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","INTERIEURS ET CORRIDORS","REC162","F","Absence d'entreposage sauvage ",-2,2,"NOK",0,"Présence  des oiseaux au niveau de la réserve sèche et surface de vente","Renforcer la lutte contre les nuisibles.","2017-02-17","aymen Salah",0,"SOUSSE"]
[163,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","INTERIEURS ET CORRIDORS","REC163","F","Absence de nuisible",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[164,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","INTERIEURS ET CORRIDORS","REC164","F","Propreté des intérieurs / corridors",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","VESTIAIRES ET TOILETTES ","REC165","F","Vestiaires propres et rangés",-2,2,"OK",{"$f":"IF((O193=\"Nobs\")+(O193=\"NA\"),O193,IF(O193=\"ok\",N193,N193+M193))","v":2},null,null,null,"",2,"SOUSSE"]
[165,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","VESTIAIRES ET TOILETTES ","REC165","S","Casiers en bon état",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[166,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","VESTIAIRES ET TOILETTES ","REC166","F","Couloirs non encombrés et propres,salle de pause propre et rangée",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","VESTIAIRES ET TOILETTES ","REC167","S","Propreté et équipement des toilettes satisfaisants",-2,2,"OK",{"$f":"IF((O196=\"Nobs\")+(O196=\"NA\"),O196,IF(O196=\"ok\",N196,N196+M196))","v":2},null,null,null,"",2,"SOUSSE"]
[167,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","VESTIAIRES ET TOILETTES ","REC167","F","Propreté et équipement des toilettes satisfaisants",-2,2,"NOK",0,"Absence de dispositifs de séchage des mains.","Fixer le dispositif","2017-02-17","aymen Salah",0,"SOUSSE"]
[168,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","VESTIAIRES ET TOILETTES ","REC168","S","Equipement des lave-mains reglementaire(à commande non manuelle , savon)",-2,2,"NOK",0,"Absence de savon liquide aux sanitaires femmes.","Prévoir du savon liquide aux sanitaires.",null,null,0,"SOUSSE"]
[null,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","VESTIAIRES ET TOILETTES ","REC169","F","Propreté Entretien satisfaisant des bouches d'aération des sanitaires et des vestiaires et équipement des douches satisfaisants",-1,1,"NOK",{"$f":"IF((O199=\"Nobs\")+(O199=\"NA\"),O199,IF(O199=\"ok\",N199,N199+M199))","v":0},"Le revêtement du sol des vestiaires est détérioré.\nAbsence de dispositif frigorifique pour le stockage des repas.\nprésence de rouille sur les casiers","Fixer le revêtement du sol.\nPrévoir un dispositif frigorifique pour le stockage des repas.","2016-03-17",null,0,"SOUSSE"]
[169,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","VESTIAIRES ET TOILETTES ","REC169","S","Propreté Entretien satisfaisant des bouches d'aération des sanitaires et des vestiaires et équipement des douches satisfaisants et des salles de pauses",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[171,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","VESTIAIRES ET TOILETTES ","REC171","F","Présence  d'une poubelle propre",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[172,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","PROPRETE GENERALE ","REC172","F","Propreté des abords du magasin",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[174,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","ZOM","ZONE COMMUNE","PROPRETE GENERALE ","REC174","S","Nettoyage des évaporateurs",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[198,"V4B","2013-12-26","14h31","CAC","Dr Hend KAMOUN","ZOM","ZONE COMMUNE","Engins de Livraison","REC198","S","Entretien du Camion",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[199,"V4B","2013-12-27","14h32","CAC","Dr Hend KAMOUN","ZOM","ZONE COMMUNE","Engins de Livraison","REC199","F","Propreté du Camion",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[null,"V4B","2013-12-27","14h32","CAC","Dr Hend KAMOUN","ZOM","ZONE COMMUNE","Engins de Livraison","REC199","F","chargement conforme des produits dans le camion",-2,2,"NA","NA",null,null,null,"","NA","SOUSSE"]
[200,"V4B","2013-12-28","14h33","CAC","Dr Hend KAMOUN","ZOM","ZONE COMMUNE","Engins de Livraison","REC200","S","Etat de Fonctionnement du Thermométre Afficheur/ Conformité de la température",-5,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[175,{"$f":"$E$11","v":"V2"},{"$f":"$E$12","v":"2017-06-14"},{"$f":"$E$13","v":"08h"},{"$f":"$F$14","v":"CAC"},{"$f":"$E$15","v":"Mme Meriam CHOUCHENE"},"TEC","SERVICE TECHNIQUE","MAITRISE DU FROID","REC175","S","Présence / bon fonctionnement thermoenregistreurs pole Poisson",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[176,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAITRISE DU FROID","REC176","S","Présence / bon fonctionnement thermoenregistreurs pole Fruits et Légumes",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[177,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAITRISE DU FROID","REC177","S","Présence / bon fonctionnement thermoenregistreurs pole PLS/boucherie",-1,1,"NOK",0,"La GTC est en panne.","Réparer la GTC.",null,null,0,"SOUSSE"]
[178,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAITRISE DU FROID","REC178","S","Présence / bon fonctionnement thermoenregistreurs réserves froides PLS",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[179,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAITRISE DU FROID","REC179","S","Présence et bon état des joints  porte ch froide",-1,1,"Nobs","Nobs",null,null,null,null,"Nobs","SOUSSE"]
[180,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAITRISE DU FROID","REC180","S","Positionnement de la sonde extérieure des meubles surgelés conforme",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[181,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAITRISE DU FROID","REC181","S","Absence de thermomètre en panne sur les linéaires surgelés",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[182,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAITRISE DU FROID","REC182","S","gestion des alarmes du froid ",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[183,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAITRISE DU FROID","REC183","S","Absence de fuite de fluide frigorigène",-1,1,"NOK",{"$f":"IF((O216=\"Nobs\")+(O216=\"NA\"),O216,IF(O216=\"ok\",N216,N216+M216))","v":0},"Absence de DEIV dans tout le magasin.","Prévoir des DEIV au magasin.",null,null,0,"SOUSSE"]
[184,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAINTENANCE GENERALE","REC184","S","Présence d'un poste de nettoyage désinfection au niveau de la réception",-5,2,"NOK",-3,"Absence d'un local poubelle.","Prévoir un local adapté pour l'entreposage des poubelles ",null,null,-3,"SOUSSE"]
[185,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAINTENANCE GENERALE","REC185","S","Entretien des écoulements / évacuations satisfaisant",-2,2,"OK",2,null,null,null,"",2,"SOUSSE"]
[186,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAINTENANCE GENERALE","REC186","S","Maintenance satisfaisante des meubles (concerne état général, rouille...) ",-1,1,"NOK",0,"Présence de fuite au niveau du bac de la poissonnerie","Réparer la fuite d'eau.",null,"aymen Salah",{"$f":"P219","v":0},"SOUSSE"]
[190,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","MAINTENANCE GENERALE","REC190","S","Maintenance et propreté satisfaisantes des évaporateurs et ventilateurs",-1,1,"NOK",0,"Absence d'un planning de maintenance préventive: technique /nettoyage","Etablir un planning de maintenance préventive: Nettoyage ",null,null,0,"SOUSSE"]
[191,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","AUTRES","REC191","S","Présence du plan de positionnement des appats raticides (emplacement et nombre)",-2,2,"OK",2,null,null,null,null,2,"SOUSSE"]
[192,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","AUTRES","REC192","S","Présence du local poubelle",-2,2,"NOK",0,"Les poubelles sont à l'air libre","prévoir un local climatisé et équipé d'une source d'eau chaude et froide","2014-03-04",{"$f":"IF(O222<>\"NOK\",\"\",INDEX($K$2:$K$11,MATCH(G223,$P$2:$P$11,)))","v":"aymen Salah"},0,"SOUSSE"]
[193,"V2","2017-06-14","08h","CAC","Mme Meriam CHOUCHENE","TEC","SERVICE TECHNIQUE","AUTRES","REC193","S","bon fonctionnement des lave-mains",-1,1,"NOK",0,"2 lave main non fonctionnel en vestiaire femme,  Absence des distributeurs savon liquide et papier hygiénique au niveau du poste lave-mains du poissonnerie","reparer les lave mains et prevoir les ditributeurs","2016-10-24","aymen Salah",0,"SOUSSE"]
[194,{"$f":"$E$11","v":"V2"},{"$f":"$E$12","v":"2017-06-14"},{"$f":"$E$13","v":"08h"},{"$f":"$F$14","v":"CAC"},{"$f":"$E$15","v":"Mme Meriam CHOUCHENE"},"TEC","SERVICE TECHNIQUE","AUTRES","REC194","S","Absence de fuite d'eau",-1,1,"OK",1,null,null,null,"",1,"SOUSSE"]
[195,{"$f":"$E$11","v":"V2"},{"$f":"$E$12","v":"2017-06-14"},{"$f":"$E$13","v":"08h"},{"$f":"$F$14","v":"CAC"},{"$f":"$E$15","v":"Mme Meriam CHOUCHENE"},"TEC","SERVICE TECHNIQUE","GESTION DOCUMENTAIRE","REC195","S","Existence d'un planning de maintenance préventive technique et Nettoyage",-1,1,"OK",{"$f":"IF((O225=\"Nobs\")+(O225=\"NA\"),O225,IF(O225=\"ok\",N225,N225+M225))","v":1},"z",null,null,"",1,"SOUSSE"]
[197,{"$f":"$E$11","v":"V2"},{"$f":"$E$12","v":"2017-06-14"},{"$f":"$E$13","v":"08h"},{"$f":"$F$14","v":"CAC"},{"$f":"$E$15","v":"Mme Meriam CHOUCHENE"},"TEC","SERVICE TECHNIQUE","GESTION DOCUMENTAIRE","REC197","S","Existence d'un planning de maintenance préventive:dératisation-désinsectisation",-1,1,"NOK",0,"Présence de jour important sous la porte de livraison, ceci favorise l’accès des nuisibles","fermer cette ouverture sous la porte","2016-11-22",null,0,"SOUSSE"]

{"sheet":"POINTS DIRECTEURS","index":6,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,4,21,5]]}
[null,{"$f":"\"Accompagné par :  \" &masque!K8","v":"Accompagné par :  dir magasin"},null,"POINTS DIRECTEURS",null,null,null,null,"PDR"]
[null,null,null,null,"Visite "]
[null,null,null,"Visite",{"$f":"masque!$E$11","v":"V2"}]
[null,null,null,"Date",{"$f":"masque!$E$12","v":"2017-06-14"}]
[null,null,null,"Heure"]
[null,null,"Pénalités","Base",null,null,"Non-conformité","Action corrective","Fixé le","Responsable"]
["011.","POINTS DIRECTEURS",null,null,"F","T"]
["0111.",{"$f":"masque!L182","v":"Armoire à pharmacie conforme"},{"$f":"masque!M182","v":-2},{"$f":"masque!N182","v":2},{"$f":"masque!P182","v":2},"NA",{"$f":"IF(masque!Q182=0,\"\",masque!Q182)","v":""},{"$f":"IF(masque!R182=0,\"\",masque!R182)","v":""},{"$f":"IF(masque!S182=0,\"\",masque!S182)","v":""},{"$f":"IF(masque!T182=0,\"\",masque!T182)","v":""}]
["0112a",{"$f":"masque!L183","v":"Présence de la réglementation en vigueur"},{"$f":"masque!M183","v":-2},{"$f":"masque!N183","v":2},{"$f":"masque!P183","v":2},"NA",{"$f":"IF(masque!Q183=0,\"\",masque!Q183)","v":""},{"$f":"IF(masque!R183=0,\"\",masque!R183)","v":""},{"$f":"IF(masque!S183=0,\"\",masque!S183)","v":""},{"$f":"IF(masque!T183=0,\"\",masque!T183)","v":""}]
["0112b",{"$f":"masque!L184","v":"Classement des dossiers de retrait"},{"$f":"masque!M184","v":-1},{"$f":"masque!N184","v":1},{"$f":"masque!P184","v":1},"NA",{"$f":"IF(masque!Q184=0,\"\",masque!Q184)","v":""},{"$f":"IF(masque!R184=0,\"\",masque!R184)","v":""},{"$f":"IF(masque!S184=0,\"\",masque!S184)","v":""},{"$f":"IF(masque!T184=0,\"\",masque!T184)","v":""}]
["0112c",{"$f":"masque!L185","v":"Classement des contrôles officiels"},{"$f":"masque!M185","v":-2},{"$f":"masque!N185","v":2},{"$f":"masque!P185","v":2},"NA",{"$f":"IF(masque!Q185=0,\"\",masque!Q185)","v":""},{"$f":"IF(masque!R185=0,\"\",masque!R185)","v":""},{"$f":"IF(masque!S185=0,\"\",masque!S185)","v":""},{"$f":"IF(masque!T185=0,\"\",masque!T185)","v":""}]
["0114.",{"$f":"masque!L186","v":"Classement des rapports d'audits internes et des plans d'action"},{"$f":"masque!M186","v":-1},{"$f":"masque!N186","v":1},{"$f":"masque!P186","v":0},"NA",{"$f":"IF(masque!Q186=0,\"\",masque!Q186)","v":"Absence de plan de formation 2017."},{"$f":"IF(masque!R186=0,\"\",masque!R186)","v":"Dresser un plan de formation relatif aux BPH."},{"$f":"IF(masque!S186=0,\"\",masque!S186)","v":"2017-06-14"},{"$f":"IF(masque!T186=0,\"\",masque!T186)","v":"dir magasin"}]
["0114b.",{"$f":"masque!L187","v":"Présence du plan de formations de l'année en cours"},{"$f":"masque!M187","v":-2},{"$f":"masque!N187","v":2},{"$f":"masque!P187","v":2},"NA",{"$f":"IF(masque!Q187=0,\"\",masque!Q187)","v":""},{"$f":"IF(masque!R187=0,\"\",masque!R187)","v":""},{"$f":"IF(masque!S187=0,\"\",masque!S187)","v":""},{"$f":"IF(masque!T187=0,\"\",masque!T187)","v":""}]
["0115.",{"$f":"masque!L188","v":"Suivi de l'état de santé du personnel à jour (analyses copro, visites médicales…)"},{"$f":"masque!M188","v":-2},{"$f":"masque!N188","v":2},{"$f":"masque!P188","v":2},"NA",{"$f":"IF(masque!Q188=0,\"\",masque!Q188)","v":""},{"$f":"IF(masque!R188=0,\"\",masque!R188)","v":""},{"$f":"IF(masque!S188=0,\"\",masque!S188)","v":""},{"$f":"IF(masque!T188=0,\"\",masque!T188)","v":""}]
["0116a.","Etalonnage des balances effectué",{"$f":"masque!M189","v":-15},{"$f":"masque!N189","v":2},{"$f":"masque!P189","v":2},"NA",{"$f":"IF(masque!Q189=0,\"\",masque!Q189)","v":""},{"$f":"IF(masque!R189=0,\"\",masque!R189)","v":""},{"$f":"IF(masque!S189=0,\"\",masque!S189)","v":""},{"$f":"IF(masque!T189=0,\"\",masque!T189)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D8:D15)","v":14},{"$f":"SUM(E8:E15)","v":13},{"$f":"SUM(F8:F15)","v":0}]
[null,null,"Max",{"$f":"E17+F17","v":14},{"$f":"masque!Q8","v":14},{"$f":"masque!R8","v":0}]
[]
[null,null,null,null,"Note F","Note T"]
[null,"TOTAL  : ",null,null,{"$f":"E16","v":13},{"$f":"F16","v":0}]
[null,"NOTE : ",null,"/100",{"$f":"IF(E17=0,\"\",E20/E17)","v":0.9285714285714286},{"$f":"IF(F17=0,\"\",F20/F17)","v":""}]
[null,null,null,null,{"$f":"IF(D17=0,\"\",(E20+F20)/D17)","v":0.9285714285714286}]

{"sheet":"RECEPTION","index":7,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,3,0,6],[2,5,2,6],[3,5,3,6],[34,5,34,6]]}
[{"$f":"\"Accompagné par :  \" &masque!K2","v":"Accompagné par :  Moncef SMAOUI"},null,null,"RECEPTION",null,null,null,"REC"]
[null,null,"2011-05-13",null,null,null,"Visite "]
[null,null,null,null,"Visite",{"$f":"masque!$E$11","v":"V2"}]
[null,null,null,null,"Date",{"$f":"masque!$E$12","v":"2017-06-14"}]
[null,null,null,null,"Heure"]
[null,null,null,"Pénalités","Base",null,null,"Non-conformité","Action corrective","Fixé le","Responsable"]
["01.","RECEPTION",null,null,null,"F","T"]
["011",{"$f":"masque!L26","v":"Présence et bon fonctionnement du thermomètre à sonde et infrarouge "},{"$f":"masque!M26","v":-2},{"$f":"masque!M26","v":-2},{"$f":"masque!N26","v":2},{"$f":"masque!P26","v":0},"NA",{"$f":"IF(masque!Q26=0,\"\",masque!Q26)","v":"Absence de thermomètre à infra rouge. Achat en cours.+S38Q24:S44Q24:T164"},{"$f":"IF(masque!R26=0,\"\",masque!R26)","v":"Prévoir un thermomètre infra rouge."},{"$f":"IF(masque!S26=0,\"\",masque!S26)","v":"2013-10-23"},{"$f":"IF(masque!T26=0,\"\",masque!T26)","v":"Moncef SMAOUI"}]
["012",{"$f":"masque!L27","v":"Thermomètre rangé avec son matériel de désinfection"},null,{"$f":"masque!M27","v":-1},{"$f":"masque!N27","v":1},{"$f":"masque!P27","v":0},"NA",{"$f":"IF(masque!Q27=0,\"\",masque!Q27)","v":"Absence de  matériel de désinfection"},{"$f":"IF(masque!R27=0,\"\",masque!R27)","v":"Prévoir du matériel de désinfection"},{"$f":"IF(masque!S27=0,\"\",masque!S27)","v":"2013-10-23"},{"$f":"IF(masque!T27=0,\"\",masque!T27)","v":""}]
["013",{"$f":"masque!L28","v":"Réalisation de la vérification  mensuelle du thermomètre"},null,{"$f":"masque!M28","v":-1},{"$f":"masque!N28","v":1},{"$f":"masque!P28","v":0},"NA",{"$f":"IF(masque!Q28=0,\"\",masque!Q28)","v":"L'enregistrement de suivi est réalisé mais le protocole n'est pas maitrisé; "},{"$f":"IF(masque!R28=0,\"\",masque!R28)","v":"Une sensibilisation sur cet écart a eu lieu le jour de l'audit."},{"$f":"IF(masque!S28=0,\"\",masque!S28)","v":"2017-06-14"},{"$f":"IF(masque!T28=0,\"\",masque!T28)","v":""}]
["014",{"$f":"masque!L29","v":"Affichage du tableau des températures réglementaires"},null,{"$f":"masque!M29","v":-1},{"$f":"masque!N29","v":1},{"$f":"masque!P29","v":1},"NA",{"$f":"IF(masque!Q29=0,\"\",masque!Q29)","v":""},{"$f":"IF(masque!R29=0,\"\",masque!R29)","v":""},{"$f":"IF(masque!S29=0,\"\",masque!S29)","v":""},{"$f":"IF(masque!T29=0,\"\",masque!T29)","v":""}]
[142,{"$f":"masque!L30","v":"Vérification de la Présence des documents sanitaires des denrées d'origine animal frais ou congelés (documents de transport, AMM, certificat de salubrité, étiquetage conforme ,quittance d'abbaoir)"},null,{"$f":"masque!M30","v":-5},{"$f":"masque!N30","v":2},{"$f":"masque!P30","v":2},"NA",{"$f":"IF(masque!Q30=0,\"\",masque!Q30)","v":""},{"$f":"IF(masque!R30=0,\"\",masque!R30)","v":""},{"$f":"IF(masque!S30=0,\"\",masque!S30)","v":""},{"$f":"IF(masque!T30=0,\"\",masque!T30)","v":""}]
["015",{"$f":"masque!L31","v":"Contrôle complet des températures"},null,{"$f":"masque!M31","v":-5},{"$f":"masque!N31","v":2},{"$f":"masque!P31","v":2},"NA",{"$f":"IF(masque!Q31=0,\"\",masque!Q31)","v":""},{"$f":"IF(masque!R31=0,\"\",masque!R31)","v":""},{"$f":"IF(masque!S31=0,\"\",masque!S31)","v":""},{"$f":"IF(masque!T31=0,\"\",masque!T31)","v":""}]
["016",{"$f":"masque!L32","v":"Refus des marchandises hors critères d'acceptation"},null,{"$f":"masque!M32","v":-5},{"$f":"masque!N32","v":2},{"$f":"masque!P32","v":2},"NA",{"$f":"IF(masque!Q32=0,\"\",masque!Q32)","v":""},{"$f":"IF(masque!R32=0,\"\",masque!R32)","v":""},{"$f":"IF(masque!S32=0,\"\",masque!S32)","v":""},{"$f":"IF(masque!T32=0,\"\",masque!T32)","v":""}]
["017",{"$f":"masque!L33","v":"Absence d'attente en réception des marchandises "},null,{"$f":"masque!M33","v":-2},{"$f":"masque!N33","v":2},{"$f":"masque!P33","v":2},"NA",{"$f":"IF(masque!Q33=0,\"\",masque!Q33)","v":""},{"$f":"IF(masque!R33=0,\"\",masque!R33)","v":""},{"$f":"IF(masque!S33=0,\"\",masque!S33)","v":""},{"$f":"IF(masque!T33=0,\"\",masque!T33)","v":""}]
["018",{"$f":"masque!L34","v":"Retours correctement identifiés et balisés"},null,{"$f":"masque!M34","v":-2},{"$f":"masque!N34","v":2},{"$f":"masque!P34","v":2},"NA",{"$f":"IF(masque!Q34=0,\"\",masque!Q34)","v":""},{"$f":"IF(masque!R34=0,\"\",masque!R34)","v":""},{"$f":"IF(masque!S34=0,\"\",masque!S34)","v":""},{"$f":"IF(masque!T34=0,\"\",masque!T34)","v":""}]
[null,"Sous Total :",null,null,{"$f":"SUM(E8:E16)","v":15},{"$f":"SUM(F8:F16)","v":11},{"$f":"SUM(G8:G16)","v":0}]
["02","EXTERIEUR ET AIRE DE RECEPTION"]
["020",{"$f":"masque!L35","v":"Absence d'accumulation de nuisances"},{"$f":"masque!M35","v":-5},{"$f":"masque!M35","v":-5},{"$f":"masque!N35","v":2},{"$f":"masque!P35","v":2},"NA",{"$f":"IF(masque!Q35=0,\"\",masque!Q35)","v":""},{"$f":"IF(masque!R35=0,\"\",masque!R35)","v":""},{"$f":"IF(masque!S35=0,\"\",masque!S35)","v":""},{"$f":"IF(masque!T35=0,\"\",masque!T35)","v":""}]
["021",{"$f":"masque!L36","v":"Absence de stockage sauvage"},null,{"$f":"masque!M36","v":-2},{"$f":"masque!N36","v":2},{"$f":"masque!P36","v":2},"NA",{"$f":"IF(masque!Q36=0,\"\",masque!Q36)","v":""},{"$f":"IF(masque!R36=0,\"\",masque!R36)","v":""},{"$f":"IF(masque!S36=0,\"\",masque!S36)","v":""},{"$f":"IF(masque!T36=0,\"\",masque!T36)","v":""}]
["022",{"$f":"masque!L37","v":"Propreté correcte des alentours de la benne."},null,{"$f":"masque!M37","v":-1},{"$f":"masque!N37","v":1},{"$f":"masque!P37","v":0},"NA",{"$f":"IF(masque!Q37=0,\"\",masque!Q37)","v":"Les bennes ne sont pas correctement protégées. \nElles sont entreposées à proximité de la porte d'accès au magasin."},{"$f":"IF(masque!R37=0,\"\",masque!R37)","v":"Protéger les bennes et améliorer la gestion des déchets."},{"$f":"IF(masque!S37=0,\"\",masque!S37)","v":"2012-03-16"},{"$f":"IF(masque!T37=0,\"\",masque!T37)","v":"Moncef SMAOUI"}]
["023",{"$f":"masque!L38","v":"Absence de nuisible"},null,{"$f":"masque!M38","v":-2},{"$f":"masque!N38","v":2},{"$f":"masque!P38","v":0},"NA",{"$f":"IF(masque!Q38=0,\"\",masque!Q38)","v":"Présence de nid d'hirondelle au plafond du quai de réception.\nPrésence de mouches."},{"$f":"IF(masque!R38=0,\"\",masque!R38)","v":"Renforcer la lutte contre les nuisibles à ce niveau."},{"$f":"IF(masque!S38=0,\"\",masque!S38)","v":"2017-06-14"},{"$f":"IF(masque!T38=0,\"\",masque!T38)","v":"Moncef SMAOUI"}]
["024",{"$f":"masque!L39","v":"Absence d'odeur nauséabonde"},null,{"$f":"masque!M39","v":-1},{"$f":"masque!N39","v":1},{"$f":"masque!P39","v":1},"NA",{"$f":"IF(masque!Q39=0,\"\",masque!Q39)","v":""},{"$f":"IF(masque!R39=0,\"\",masque!R39)","v":""},{"$f":"IF(masque!S39=0,\"\",masque!S39)","v":""},{"$f":"IF(masque!T39=0,\"\",masque!T39)","v":""}]
[null,"Sous Total :",null,null,{"$f":"SUM(E19:E23)","v":8},{"$f":"SUM(F19:F23)","v":5},{"$f":"SUM(G19:G23)","v":0}]
["03","PROPRETE ET ENTRETIEN DES LOCAUX"]
["030",{"$f":"masque!L40","v":"Entretien et propreté du sas  de réception, des sols, plinthes, murs, plafonds, portes satisfaisants, des évacuations au sol satisfaisants"},null,{"$f":"masque!M40","v":-5},{"$f":"masque!N40","v":2},{"$f":"masque!P40","v":2},{"$f":"masque!P41","v":-3},{"$f":"IF(masque!Q40=0,IF(masque!Q41=0,\"\",\"  S : \"&masque!Q41),IF(masque!Q41=0,\"F: \"&masque!Q40,\"F: \"&masque!Q40&\"//    S : \"&masque!Q41))","v":"  S : Absence de station de nettoyage pour la zone de réception; cette opération est réalisée par l'eau du RIA.\nPrésence de crevasses dans les murs du sas."},{"$f":"IF(masque!R40=0,IF(masque!R41=0,\"\",\"  S : \"&masque!R41),IF(masque!R41=0,\"F: \"&masque!R40,\"F: \"&masque!R40&\"//    S : \"&masque!R41))","v":"  S : Prévoir une station de nettoyage dans la zone de réception.\nColmater les trous aux murs."},{"$f":"IF(masque!S40=0,IF(masque!S41=0,\"\",\"  S : \"&masque!S41),IF(masque!S41=0,\"F: \"&masque!S40,\"F: \"&masque!S40&\"//    S : \"&masque!S41))","v":"  S : 42900"},{"$f":"IF(masque!T40=0,IF(masque!T41=0,\"\",\"  S : \"&masque!T41),IF(masque!T41=0,\"F: \"&masque!T40,\"F: \"&masque!T40&\"//    S : \"&masque!T41))","v":"F: "}]
["033",{"$f":"masque!L42","v":"Les résultats d'audits externes sont affichés à la réception"},null,{"$f":"masque!M42","v":-1},{"$f":"masque!N42","v":1},{"$f":"masque!P42","v":1},"NA",{"$f":"IF(masque!Q42=0,\"\",masque!Q42)","v":""},{"$f":"IF(masque!R42=0,\"\",masque!R42)","v":""},{"$f":"IF(masque!S42=0,\"\",masque!S42)","v":""},{"$f":"IF(masque!T42=0,\"\",masque!T42)","v":""}]
["034",{"$f":"masque!L43","v":"Mise en place de Plan d'action suite aux audits"},null,{"$f":"masque!M43","v":-1},{"$f":"masque!N43","v":1},{"$f":"masque!P43","v":1},"NA",{"$f":"IF(masque!Q43=0,\"\",masque!Q43)","v":""},{"$f":"IF(masque!R43=0,\"\",masque!R43)","v":""},{"$f":"IF(masque!S43=0,\"\",masque!S43)","v":""},{"$f":"IF(masque!T43=0,\"\",masque!T43)","v":""}]
[null,"Sous Total :",null,null,{"$f":"SUM(E26:E28)","v":4},{"$f":"SUM(F26:F28)","v":4},{"$f":"SUM(G26:G28)","v":-3}]
[null,null,null,"Max",{"$f":"F30+G30","v":29},{"$f":"masque!Q2","v":27},{"$f":"masque!R2","v":2}]
[]
[null,null,null,null,null,"Note F","Note T"]
[null,"TOTAL  : ",null,null,null,{"$f":"SUM(F29,F24,F17)","v":20},{"$f":"SUM(G29,G24,G17)","v":-3}]
[null,"NOTE : ",null,null,"/100",{"$f":"IF(F30=0,\"\",F33/F30)","v":0.7407407407407407},{"$f":"IF(G30=0,\"\",G33/G30)","v":-1.5}]
[null,"Note Globale :",null,null,null,{"$f":"IF(E30=0,\"\",(G33+F33)/E30)","v":0.58620689655172409}]

{"sheet":"Zone commune","index":8,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,5,33,6]]}
[{"$f":"\"Accompagné par :  \" &masque!K9","v":"Accompagné par :  aymen Salah"},null,"ZONE COMMUNE"]
[null,null,null,null,null,"Visite "]
[null,null,null,null,"Visite",{"$f":"masque!$E$11","v":"V2"}]
[null,null,null,null,"Date",{"$f":"masque!$E$12","v":"2017-06-14"}]
[null,null,null,null,"Heure"]
[null,null,null,null,"Base",null,null,"Non-conformité","Action corrective","Fixé le","Responsable"]
["03.","INTERIEURS ET CORRIDORS",null,null,null,"F","T"]
["031",{"$f":"masque!L190","v":"Absence d'entreposage sauvage "},null,{"$f":"masque!M190","v":-2},{"$f":"masque!N190","v":2},{"$f":"masque!P190","v":0},"NA",{"$f":"IF(masque!Q190=0,\"\",masque!Q190)","v":"Présence  des oiseaux au niveau de la réserve sèche et surface de vente"},{"$f":"IF(masque!R190=0,\"\",masque!R190)","v":"Renforcer la lutte contre les nuisibles."},{"$f":"IF(masque!S190=0,\"\",masque!S190)","v":"2017-02-17"},{"$f":"IF(masque!T190=0,\"\",masque!T190)","v":"aymen Salah"}]
["033",{"$f":"masque!L191","v":"Absence de nuisible"},null,{"$f":"masque!M191","v":-2},{"$f":"masque!N191","v":2},{"$f":"masque!P191","v":2},"NA",{"$f":"IF(masque!Q191=0,\"\",masque!Q191)","v":""},{"$f":"IF(masque!#REF!=0,\"\",masque!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(masque!S191=0,\"\",masque!S191)","v":""},{"$f":"IF(masque!T191=0,\"\",masque!T191)","v":""}]
["034",{"$f":"masque!L192","v":"Propreté des intérieurs / corridors"},null,{"$f":"masque!M192","v":-1},{"$f":"masque!N192","v":1},{"$f":"masque!P192","v":1},"NA",{"$f":"IF(masque!Q192=0,\"\",masque!Q192)","v":""},{"$f":"IF(masque!R192=0,\"\",masque!R192)","v":""},{"$f":"IF(masque!S192=0,\"\",masque!S192)","v":""},{"$f":"IF(masque!T192=0,\"\",masque!T192)","v":""}]
[null,"Sous Total :",null,null,{"$f":"SUM(E8:E10)","v":5},{"$f":"SUM(F8:F10)","v":3},{"$f":"SUM(G8:G10)","v":0}]
["04.","VESTIAIRES ET TOILETTES "]
["041",{"$f":"masque!L194","v":"Casiers en bon état"},null,{"$f":"masque!M194","v":-2},{"$f":"masque!N194","v":2},"NA",{"$f":"masque!P194","v":2},{"$f":"IF(masque!Q194=0,\"\",masque!Q194)","v":""},{"$f":"IF(masque!R194=0,\"\",masque!R194)","v":""},{"$f":"IF(masque!S194=0,\"\",masque!S194)","v":""},{"$f":"IF(masque!T194=0,\"\",masque!T194)","v":""}]
[null,{"$f":"masque!L195","v":"Couloirs non encombrés et propres,salle de pause propre et rangée"},null,{"$f":"masque!M195","v":-1},{"$f":"masque!N195","v":1},{"$f":"masque!P195","v":1},"NA",{"$f":"IF(masque!Q195=0,\"\",masque!Q195)","v":""},{"$f":"IF(masque!R195=0,\"\",masque!R195)","v":""},{"$f":"IF(masque!S195=0,\"\",masque!S195)","v":""},{"$f":"IF(masque!T195=0,\"\",masque!T195)","v":""}]
["042",{"$f":"masque!L197","v":"Propreté et équipement des toilettes satisfaisants"},null,{"$f":"masque!M197","v":-2},{"$f":"masque!N197","v":2},{"$f":"masque!P197","v":0},{"$f":"masque!P196","v":2},{"$f":"IF(masque!Q197=0,IF(masque!Q196=0,\"\",\"  S : \"&masque!Q196),IF(masque!Q196=0,\"F: \"&masque!Q197,\"F: \"&masque!Q197&\"//    S : \"&masque!Q197))","v":"F: Absence de dispositifs de séchage des mains."},{"$f":"IF(masque!R197=0,IF(masque!R196=0,\"\",\"  S : \"&masque!R196),IF(masque!R196=0,\"F: \"&masque!R197,\"F: \"&masque!R197&\"//    S : \"&masque!R197))","v":"F: Fixer le dispositif"},{"$f":"IF(masque!S197=0,IF(masque!S196=0,\"\",\"  S : \"&masque!S196),IF(masque!S196=0,\"F: \"&masque!S197,\"F: \"&masque!S197&\"//    S : \"&masque!S197))","v":"F: 42783"},{"$f":"IF(masque!T197=0,IF(masque!T196=0,\"\",\"  S : \"&masque!T196),IF(masque!T196=0,\"F: \"&masque!T197,\"F: \"&masque!T197&\"//    S : \"&masque!T197))","v":"F: aymen Salah//    S : aymen Salah"}]
["043",{"$f":"masque!L198","v":"Equipement des lave-mains reglementaire(à commande non manuelle , savon)"},null,{"$f":"masque!M198","v":-2},{"$f":"masque!N198","v":2},"NA",{"$f":"masque!P198","v":0},{"$f":"IF(masque!Q198=0,\"\",masque!Q198)","v":"Absence de savon liquide aux sanitaires femmes."},{"$f":"IF(masque!R198=0,\"\",masque!R198)","v":"Prévoir du savon liquide aux sanitaires."},{"$f":"IF(masque!S198=0,\"\",masque!S198)","v":""},{"$f":"IF(masque!T198=0,\"\",masque!T198)","v":""}]
["045",{"$f":"masque!L200","v":"Propreté Entretien satisfaisant des bouches d'aération des sanitaires et des vestiaires et équipement des douches satisfaisants et des salles de pauses"},null,{"$f":"masque!M200","v":-1},{"$f":"masque!N200","v":1},{"$f":"masque!P200","v":1},{"$f":"masque!P200","v":1},{"$f":"IF(masque!Q199=0,IF(masque!Q200=0,\"\",\"  S : \"&masque!Q200),IF(masque!Q200=0,\"F: \"&masque!Q199,\"F: \"&masque!Q199&\"//    S : \"&masque!Q200))","v":"F: Le revêtement du sol des vestiaires est détérioré.\nAbsence de dispositif frigorifique pour le stockage des repas.\nprésence de rouille sur les casiers"},{"$f":"IF(masque!R199=0,IF(masque!R200=0,\"\",\"  S : \"&masque!R200),IF(masque!R200=0,\"F: \"&masque!R199,\"F: \"&masque!R199&\"//    S : \"&masque!R200))","v":"F: Fixer le revêtement du sol.\nPrévoir un dispositif frigorifique pour le stockage des repas."},{"$f":"IF(masque!S199=0,IF(masque!S200=0,\"\",\"  S : \"&masque!S200),IF(masque!S200=0,\"F: \"&masque!S199,\"F: \"&masque!S199&\"//    S : \"&masque!S200))","v":"F: 42446"},{"$f":"IF(masque!T199=0,IF(masque!T200=0,\"\",\"  S : \"&masque!T200),IF(masque!T200=0,\"F: \"&masque!T199,\"F: \"&masque!T199&\"//    S : \"&masque!T200))","v":"  S : "}]
["047",{"$f":"masque!L201","v":"Présence  d'une poubelle propre"},null,{"$f":"masque!M201","v":-1},{"$f":"masque!N201","v":1},{"$f":"masque!P201","v":1},"NA",{"$f":"IF(masque!Q201=0,\"\",masque!Q201)","v":""},{"$f":"IF(masque!R201=0,\"\",masque!R201)","v":""},{"$f":"IF(masque!S201=0,\"\",masque!S201)","v":""},{"$f":"IF(masque!T201=0,\"\",masque!T201)","v":""}]
[null,"Sous Total :",null,null,{"$f":"SUM(E13:E18)","v":9},{"$f":"SUM(F13:F18)","v":3},{"$f":"SUM(G13:G18)","v":5}]
["041.","PROPRETE GENERALE "]
["0411",{"$f":"masque!L202","v":"Propreté des abords du magasin"},null,{"$f":"masque!M202","v":-2},{"$f":"masque!N202","v":2},{"$f":"masque!P202","v":2},"NA",{"$f":"IF(masque!Q202=0,\"\",masque!Q202)","v":""},{"$f":"IF(masque!R202=0,\"\",masque!R202)","v":""},{"$f":"IF(masque!S202=0,\"\",masque!S202)","v":""},{"$f":"IF(masque!T202=0,\"\",masque!T202)","v":""}]
[null,{"$f":"masque!L203","v":"Nettoyage des évaporateurs"},null,{"$f":"masque!M203","v":-2},{"$f":"masque!N203","v":2},"NA",{"$f":"masque!P203","v":2},{"$f":"IF(masque!Q203=0,\"\",masque!Q203)","v":""},{"$f":"IF(masque!R203=0,\"\",masque!R203)","v":""},{"$f":"IF(masque!S203=0,\"\",masque!S203)","v":""},{"$f":"IF(masque!T203=0,\"\",masque!T203)","v":""}]
[null,"Sous Total :",null,null,{"$f":"SUM(E21:E22)","v":4},{"$f":"SUM(F21:F22)","v":2},{"$f":"SUM(G21:G22)","v":2}]
[null,{"$f":"masque!I204","v":"Engins de Livraison"}]
[null,{"$f":"masque!L204","v":"Entretien du Camion"},null,{"$f":"masque!M204","v":-2},{"$f":"masque!N204","v":2},{"$f":"masque!P204","v":2},{"$f":"masque!P204","v":2},{"$f":"IF(masque!Q204=0,\"\",masque!Q204)","v":""},{"$f":"IF(masque!R204=0,\"\",masque!R204)","v":""},{"$f":"IF(masque!S204=0,\"\",masque!S204)","v":""},{"$f":"IF(masque!T204=0,\"\",masque!T204)","v":""}]
[null,{"$f":"masque!L205","v":"Propreté du Camion"},null,{"$f":"masque!M205","v":-2},{"$f":"masque!N205","v":2},{"$f":"masque!P205","v":2},"NA",{"$f":"IF(masque!Q205=0,\"\",masque!Q205)","v":""},{"$f":"IF(masque!R205=0,\"\",masque!R205)","v":""},{"$f":"IF(masque!S205=0,\"\",masque!S205)","v":""},{"$f":"IF(masque!T205=0,\"\",masque!T205)","v":""}]
[null,{"$f":"masque!L206","v":"chargement conforme des produits dans le camion"},null,{"$f":"masque!M206","v":-2},{"$f":"masque!N206","v":2},{"$f":"masque!P206","v":"NA"},"NA",{"$f":"IF(masque!Q206=0,\"\",masque!Q206)","v":""},{"$f":"IF(masque!R206=0,\"\",masque!R206)","v":""},{"$f":"IF(masque!S206=0,\"\",masque!S206)","v":""},{"$f":"IF(masque!T206=0,\"\",masque!T206)","v":""}]
[null,{"$f":"masque!L207","v":"Etat de Fonctionnement du Thermométre Afficheur/ Conformité de la température"},null,{"$f":"masque!M207","v":-5},{"$f":"masque!N207","v":2},{"$f":"masque!P207","v":2},{"$f":"masque!P207","v":2},{"$f":"IF(masque!Q207=0,\"\",masque!Q207)","v":""},{"$f":"IF(masque!R207=0,\"\",masque!R207)","v":""},{"$f":"IF(masque!S207=0,\"\",masque!S207)","v":""},{"$f":"IF(masque!T207=0,\"\",masque!T207)","v":""}]
[null,"Sous Total :",null,null,{"$f":"SUM(E25:E28)","v":8},{"$f":"SUM(F25:F27)","v":4},{"$f":"SUM(G25:G27)","v":2}]
[null,null,null,"Max",{"$f":"F30+G30","v":29},{"$f":"masque!Q9","v":16},{"$f":"masque!R9","v":13}]
[null,null,null,null,null,"Note F","Note T"]
[null,"TOTAL  : ",null,null,null,{"$f":"SUM(F11,F19,F23,F29)","v":12},{"$f":"SUM(G11,G19,G23,G29)","v":9}]
[null,"NOTE : ",null,null,"/100",{"$f":"IF(F30=0,\"\",F32/F30)","v":0.75},{"$f":"IF(G30=0,\"\",G32/G30)","v":0.69230769230769229}]
[null,null,null,null,null,{"$f":"IF(E30=0,\"\",(F32+G32)/E30)","v":0.72413793103448276}]

{"sheet":"RETRAIT","index":9,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,3,0,5],[25,5,25,6]]}
[{"$f":"\"Accompagné par :  \" &masque!K3","v":"Accompagné par :  dir magasin"},null,null,"RETRAIT / ALERTE",null,null,null,"RET"]
[null,null,null,null,null,"Visite "]
[null,null,null,null,"Visite",{"$f":"masque!$E$11","v":"V2"}]
[null,null,null,null,"Date",{"$f":"masque!$E$12","v":"2017-06-14"}]
[null,null,null,null,"Heure"]
[null,null,null,"Pénalités","Base",null,null,"Non-conformité","Action corrective","Fixé le","Responsable"]
["030.","RETRAIT / ALERTE",null,null,null,"F","T"]
[300,{"$f":"masque!L44","v":"Existence d'un classeur Alertes / Retraits et de la procédure "},null,{"$f":"masque!M44","v":-5},{"$f":"masque!N44","v":2},{"$f":"masque!P44","v":2},"NA",{"$f":"IF(masque!Q44=0,\"\",masque!Q44)","v":""},{"$f":"IF(masque!R44=0,\"\",masque!R44)","v":""},null,{"$f":"IF(masque!T44=0,\"\",masque!T44)","v":""}]
["072.",{"$f":"masque!L45","v":"Connaisance et affichage de la procédure de retrait \n"},null,{"$f":"masque!M45","v":-5},{"$f":"masque!N45","v":2},{"$f":"masque!P45","v":2},"NA",{"$f":"IF(masque!Q45=0,\"\",masque!Q45)","v":""},{"$f":"IF(masque!R45=0,\"\",masque!R45)","v":""},null,{"$f":"IF(masque!T45=0,\"\",masque!T45)","v":""}]
["0301.",{"$f":"masque!L46","v":"Existence de zones de consignation"},null,{"$f":"masque!M46","v":-2},{"$f":"masque!N46","v":2},{"$f":"masque!P46","v":2},"NA",{"$f":"IF(masque!Q46=0,\"\",masque!Q46)","v":""},{"$f":"IF(masque!R46=0,\"\",masque!R46)","v":""},null,{"$f":"IF(masque!T46=0,\"\",masque!T46)","v":""}]
["0302.",{"$f":"masque!L47","v":"Les produits concernés par ces alertes et retraits sont retirés de la vente "},null,{"$f":"masque!M47","v":-2},{"$f":"masque!N47","v":2},{"$f":"masque!P47","v":2},"NA",{"$f":"IF(masque!Q47=0,\"\",masque!Q47)","v":""},{"$f":"IF(masque!R47=0,\"\",masque!R47)","v":""},null,{"$f":"IF(masque!T47=0,\"\",masque!T47)","v":""}]
[null,"Sous Total :",null,null,{"$f":"SUM(E8:E11)","v":8},{"$f":"SUM(F8:F11)","v":8},{"$f":"SUM(G8:G11)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Max",{"$f":"F22+G22","v":8},{"$f":"masque!Q3","v":8},{"$f":"masque!R3","v":0}]
[null,null,null,null,null,"Note F","Note T"]
[null,"TOTAL  : ",null,null,null,{"$f":"F12","v":8},{"$f":"G12","v":0}]
[null,"NOTE : ",null,null,"/100",{"$f":"IF(F22=0,\"\",F24/F22)","v":1},{"$f":"IF(G22=0,\"\",G24/G22)","v":""}]
[null,null,null,null,null,{"$f":"IF(E22=0,\"\",(G24+F24)/E22)","v":1}]

{"sheet":"FRUIT ET LEGUMES","index":10,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,4,43,5]]}
[{"$f":"\"Accompagné par :  \" &masque!K5","v":"Accompagné par :  slama nizar"},null,null,"FRUITS ET LEGUMES/OLIVES EPICES",null,null,null,"FRL"]
[null,null,null,null,"Visite "]
[null,null,null,"Visite",{"$f":"masque!$E$11","v":"V2"}]
[null,null,null,"Date",{"$f":"masque!$E$12","v":"2017-06-14"}]
[null,null,null,"Heure"]
[null,null,"Pénalités","Base",null,null,"Non-conformité","Action corrective","Fixé le","Responsable"]
["18.","POLE",null,null,"F","T"]
[181,{"$f":"masque!L93","v":"Linéaires propres."},{"$f":"masque!M93","v":-5},{"$f":"masque!N93","v":2},{"$f":"masque!P93","v":2},"NA",{"$f":"IF(masque!Q93=0,\"\",masque!Q93)","v":""},{"$f":"IF(masque!R93=0,\"\",masque!R93)","v":""},{"$f":"IF(masque!S93=0,\"\",masque!S93)","v":""},{"$f":"IF(masque!T93=0,\"\",masque!T93)","v":""}]
[182,{"$f":"masque!L95","v":"Entretien et propreté des sols, plinthes, murs plafonds, portes satisfaisants"},{"$f":"masque!M94","v":-5},{"$f":"masque!N94","v":2},{"$f":"masque!P94","v":2},{"$f":"masque!P95","v":2},{"$f":"IF(masque!Q94=0,IF(masque!Q95=0,\"\",\"  S : \"&masque!Q95),IF(masque!Q95=0,\"F: \"&masque!Q94,\"F: \"&masque!Q94&\"//    S : \"&masque!Q95))","v":""},{"$f":"IF(masque!R94=0,IF(masque!R95=0,\"\",\"  S : \"&masque!R95),IF(masque!R95=0,\"F: \"&masque!R94,\"F: \"&masque!R94&\"//    S : \"&masque!R95))","v":""},{"$f":"IF(masque!S94=0,IF(masque!S95=0,\"\",\"  S : \"&masque!S95),IF(masque!S95=0,\"F: \"&masque!S94,\"F: \"&masque!S94&\"//    S : \"&masque!S95))","v":""},{"$f":"IF(masque!T94=0,IF(masque!T95=0,\"\",\"  S : \"&masque!T95),IF(masque!T95=0,\"F: \"&masque!T94,\"F: \"&masque!T94&\"//    S : \"&masque!T95))","v":"  S : "}]
[null,"Suivi des autocontrôles de nettoyage",{"$f":"masque!M96","v":-1},{"$f":"masque!N96","v":1},{"$f":"masque!P96","v":0},"NA",{"$f":"IF(masque!Q96=0,\"\",masque!Q96)","v":"Absence de séparation dans le temps pour la sortie des produits casse à partir de la CF FLEG. "},{"$f":"IF(masque!R96=0,\"\",masque!R96)","v":"Fixer les horaires de sortie des produits casse (passant par les chambres froides.)"},{"$f":"IF(masque!S96=0,\"\",masque!S96)","v":""},{"$f":"IF(masque!T96=0,\"\",masque!T96)","v":""}]
[null,{"$f":"masque!L98","v":"Entretien et propreté des évacuations au sol satisfaisants"},{"$f":"masque!M97","v":-1},{"$f":"masque!N97","v":1},{"$f":"masque!P97","v":1},{"$f":"masque!P98","v":1},{"$f":"IF(masque!Q97=0,IF(masque!Q98=0,\"\",\"  S : \"&masque!Q98),IF(masque!Q98=0,\"F: \"&masque!Q97,\"F: \"&masque!Q97&\"//    S : \"&masque!Q98))","v":""},{"$f":"IF(masque!R97=0,IF(masque!R98=0,\"\",\"  S : \"&masque!R98),IF(masque!R98=0,\"F: \"&masque!R97,\"F: \"&masque!R97&\"//    S : \"&masque!R98))","v":""},{"$f":"IF(masque!S97=0,IF(masque!S98=0,\"\",\"  S : \"&masque!S98),IF(masque!S98=0,\"F: \"&masque!S97,\"F: \"&masque!S97&\"//    S : \"&masque!S98))","v":""},{"$f":"IF(masque!T97=0,IF(masque!T98=0,\"\",\"  S : \"&masque!T98),IF(masque!T98=0,\"F: \"&masque!T97,\"F: \"&masque!T97&\"//    S : \"&masque!T98))","v":"F: //    S : "}]
[null,{"$f":"masque!L99","v":"Entretien et Nettoyage des évaporateurs"},{"$f":"masque!M99","v":-2},{"$f":"masque!N99","v":2},"NA",{"$f":"masque!P99","v":2},{"$f":"IF(masque!Q99=0,\"\",masque!Q99)","v":""},{"$f":"IF(masque!R99=0,\"\",masque!R99)","v":""},{"$f":"IF(masque!S99=0,\"\",masque!S99)","v":""},{"$f":"IF(masque!T99=0,\"\",masque!T99)","v":""}]
["183a",{"$f":"masque!L100","v":"Absence de produits non identifiés"},{"$f":"masque!M100","v":-5},{"$f":"masque!N100","v":2},{"$f":"masque!P100","v":2},"NA",{"$f":"IF(masque!Q100=0,\"\",masque!Q100)","v":""},{"$f":"IF(masque!R100=0,\"\",masque!R100)","v":""},{"$f":"IF(masque!S100=0,\"\",masque!S100)","v":""},{"$f":"IF(masque!T100=0,\"\",masque!T100)","v":""}]
[null,{"$f":"masque!L101","v":"Présence et bon fonctionnement du thermomètre enregistreur"},{"$f":"masque!M101","v":-1},{"$f":"masque!N101","v":1},"NA",{"$f":"masque!P101","v":1},{"$f":"IF(masque!Q101=0,\"\",masque!Q101)","v":""},{"$f":"IF(masque!R101=0,\"\",masque!R101)","v":""},{"$f":"IF(masque!S101=0,\"\",masque!S101)","v":""},{"$f":"IF(masque!T101=0,\"\",masque!T101)","v":""}]
[null,{"$f":"masque!L102","v":"Respect des DLC /DLUO (olives) "},{"$f":"masque!M102","v":-10},{"$f":"masque!N102","v":2},{"$f":"masque!P102","v":2},"NA",{"$f":"IF(masque!Q102=0,\"\",masque!Q102)","v":""},{"$f":"IF(masque!R102=0,\"\",masque!R102)","v":""},{"$f":"IF(masque!S102=0,\"\",masque!S102)","v":""},{"$f":"IF(masque!T102=0,\"\",masque!T102)","v":""}]
[null,{"$f":"masque!L103","v":"Respect des DLC /DLUO (fruits et légumes emballés) "},{"$f":"masque!M103","v":-10},{"$f":"masque!N103","v":2},{"$f":"masque!P103","v":2},"NA",{"$f":"IF(masque!Q103=0,\"\",masque!Q103)","v":""},{"$f":"IF(masque!R103=0,\"\",masque!R103)","v":""},{"$f":"IF(masque!S103=0,\"\",masque!S103)","v":""},{"$f":"IF(masque!T103=0,\"\",masque!T103)","v":""}]
["185a",{"$f":"masque!L104","v":"Respect des DLC /DLUO (fruits secs, épices) "},{"$f":"masque!M104","v":-10},{"$f":"masque!N104","v":2},{"$f":"masque!P104","v":2},"NA",{"$f":"IF(masque!Q104=0,\"\",masque!Q104)","v":""},{"$f":"IF(masque!R104=0,\"\",masque!R104)","v":""},{"$f":"IF(masque!S104=0,\"\",masque!S104)","v":""},{"$f":"IF(masque!T104=0,\"\",masque!T104)","v":""}]
["185b",{"$f":"masque!L105","v":"Respect des températures réglementaires"},{"$f":"masque!M105","v":-2},{"$f":"masque!N105","v":2},"NA",{"$f":"masque!P105","v":2},{"$f":"IF(masque!Q105=0,\"\",masque!Q105)","v":""},{"$f":"IF(masque!R105=0,\"\",masque!R105)","v":""},{"$f":"IF(masque!S105=0,\"\",masque!S105)","v":""},{"$f":"IF(masque!T105=0,\"\",masque!T105)","v":""}]
["185f",{"$f":"masque!L106","v":"Lisibilité de l'étiquetage et balisage complet"},{"$f":"masque!M106","v":-1},{"$f":"masque!N106","v":1},{"$f":"masque!P106","v":1},"NA",{"$f":"IF(masque!Q106=0,\"\",masque!Q106)","v":""},{"$f":"IF(masque!R106=0,\"\",masque!R106)","v":""},{"$f":"IF(masque!S106=0,\"\",masque!S106)","v":""},{"$f":"IF(masque!T106=0,\"\",masque!T106)","v":""}]
[null,{"$f":"masque!L107","v":"Affichage du prix"},{"$f":"masque!M107","v":-1},{"$f":"masque!N107","v":1},{"$f":"masque!P107","v":0},"NA",{"$f":"IF(masque!Q107=0,\"\",masque!Q107)","v":"présence de traces de rouille sur les étagères"},{"$f":"IF(masque!R107=0,\"\",masque!R107)","v":"Procéder à un traitement anti rouille et peinture pour les étagères."},{"$f":"IF(masque!S107=0,\"\",masque!S107)","v":42783},{"$f":"IF(masque!T107=0,\"\",masque!T107)","v":""}]
["185g",{"$f":"masque!L108","v":"Matériel propre (caisse, table, balance,etagere)"},{"$f":"masque!M108","v":-1},{"$f":"masque!N108","v":1},{"$f":"masque!P108","v":1},"NA",{"$f":"IF(masque!Q108=0,\"\",masque!Q108)","v":""},{"$f":"IF(masque!R108=0,\"\",masque!R108)","v":""},{"$f":"IF(masque!S108=0,\"\",masque!S108)","v":""},{"$f":"IF(masque!T108=0,\"\",masque!T108)","v":""}]
[1810,{"$f":"masque!L109","v":"Tri des produits effectué."},{"$f":"masque!M109","v":-10},{"$f":"masque!N109","v":2},{"$f":"masque!P109","v":2},"NA",{"$f":"IF(masque!Q109=0,\"\",masque!Q109)","v":""},{"$f":"IF(masque!R109=0,\"\",masque!R109)","v":""},{"$f":"IF(masque!S109=0,\"\",masque!S109)","v":""},{"$f":"IF(masque!T109=0,\"\",masque!T109)","v":""}]
[null,{"$f":"masque!L110","v":"Rotation des produits effectuée."},{"$f":"masque!M110","v":-2},{"$f":"masque!N110","v":2},{"$f":"masque!P110","v":2},"NA",{"$f":"IF(masque!Q110=0,\"\",masque!Q110)","v":""},{"$f":"IF(masque!R110=0,\"\",masque!R110)","v":""},{"$f":"IF(masque!S110=0,\"\",masque!S110)","v":""},{"$f":"IF(masque!T110=0,\"\",masque!T110)","v":""}]
[null,{"$f":"masque!L111","v":"Absence de stockage au sol"},{"$f":"masque!M111","v":-1},{"$f":"masque!N111","v":1},{"$f":"masque!P111","v":1},"NA",{"$f":"IF(masque!Q111=0,\"\",masque!Q111)","v":""},{"$f":"IF(masque!R111=0,\"\",masque!R111)","v":""},{"$f":"IF(masque!S111=0,\"\",masque!S111)","v":""},{"$f":"IF(masque!T111=0,\"\",masque!T111)","v":""}]
[null,{"$f":"masque!L112","v":"Absence de mélange de produits différents."},{"$f":"masque!M112","v":-2},{"$f":"masque!N112","v":2},{"$f":"masque!P112","v":2},"NA",{"$f":"IF(masque!Q112=0,\"\",masque!Q112)","v":""},{"$f":"IF(masque!R112=0,\"\",masque!R112)","v":""},{"$f":"IF(masque!S112=0,\"\",masque!S112)","v":""},{"$f":"IF(masque!T112=0,\"\",masque!T112)","v":""}]
[null,{"$f":"masque!L113","v":"Balances tarées"},{"$f":"masque!M113","v":-5},{"$f":"masque!N113","v":2},{"$f":"masque!P113","v":2},"NA",{"$f":"IF(masque!Q113=0,\"\",masque!Q113)","v":""},{"$f":"IF(masque!R113=0,\"\",masque!R113)","v":""},{"$f":"IF(masque!S113=0,\"\",masque!S113)","v":""},{"$f":"IF(masque!T113=0,\"\",masque!T113)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D8:D26)","v":31},{"$f":"SUM(E8:E26)","v":24},{"$f":"SUM(F8:F26)","v":8}]
["17.","HYGIENE "]
[472,{"$f":"masque!L114","v":"Produits d’entretien conformes et correctement utilisés et rangés"},{"$f":"masque!M114","v":-5},{"$f":"masque!N114","v":2},{"$f":"masque!P114","v":2},"NA",{"$f":"IF(masque!Q114=0,\"\",masque!Q114)","v":""},{"$f":"IF(masque!R114=0,\"\",masque!R114)","v":""},{"$f":"IF(masque!S114=0,\"\",masque!S114)","v":""},{"$f":"IF(masque!T114=0,\"\",masque!T114)","v":""}]
[473,{"$f":"masque!L115","v":"Présence du planning de nettoyage "},{"$f":"masque!M115","v":-1},{"$f":"masque!N115","v":1},{"$f":"masque!P115","v":1},"NA",{"$f":"IF(masque!Q115=0,\"\",masque!Q115)","v":""},{"$f":"IF(masque!R115=0,\"\",masque!R115)","v":""},{"$f":"IF(masque!S115=0,\"\",masque!S115)","v":""},{"$f":"IF(masque!T115=0,\"\",masque!T115)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D29:D30)","v":3},{"$f":"SUM(E29:E30)","v":3},{"$f":"SUM(F29:F30)","v":0}]
[]
[22,"AUTOCONTROLES"]
[221,{"$f":"masque!L116","v":"Présence du référentiel qualité"},{"$f":"masque!M116","v":-2},{"$f":"masque!N116","v":2},{"$f":"masque!P116","v":2},"NA",{"$f":"IF(masque!Q116=0,\"\",masque!Q116)","v":""},{"$f":"IF(masque!R116=0,\"\",masque!R116)","v":""},{"$f":"IF(masque!S116=0,\"\",masque!S116)","v":""},{"$f":"IF(masque!T116=0,\"\",masque!T116)","v":""}]
["222b",{"$f":"masque!L117","v":"Autocontrôle des températures"},{"$f":"masque!M117","v":-5},{"$f":"masque!N117","v":5},{"$f":"masque!P117","v":5},"NA",{"$f":"IF(masque!Q117=0,\"\",masque!Q117)","v":""},{"$f":"IF(masque!R117=0,\"\",masque!R117)","v":""},{"$f":"IF(masque!S117=0,\"\",masque!S117)","v":""},{"$f":"IF(masque!T117=0,\"\",masque!T117)","v":""}]
[null,{"$f":"masque!L118","v":"Mise en place des auto-controles du nettoyage"},{"$f":"masque!M118","v":-2},{"$f":"masque!N118","v":2},{"$f":"masque!P118","v":2},"NA",{"$f":"IF(masque!Q118=0,\"\",masque!Q118)","v":""},{"$f":"IF(masque!R118=0,\"\",masque!R118)","v":""},{"$f":"IF(masque!S118=0,\"\",masque!S118)","v":""},{"$f":"IF(masque!T118=0,\"\",masque!T118)","v":""}]
[null,{"$f":"masque!L119","v":"Les résultats d'audits externes sont affichés au pole"},{"$f":"masque!M119","v":-1},{"$f":"masque!N119","v":1},{"$f":"masque!P119","v":1},"NA",{"$f":"IF(masque!Q119=0,\"\",masque!Q119)","v":""},{"$f":"IF(masque!R119=0,\"\",masque!R119)","v":""},{"$f":"IF(masque!S119=0,\"\",masque!S119)","v":""},{"$f":"IF(masque!T119=0,\"\",masque!T119)","v":""}]
[224,{"$f":"masque!L120","v":"Mise en place de Plan d'action suite aux audits"},{"$f":"masque!M120","v":-1},{"$f":"masque!N120","v":1},{"$f":"masque!P120","v":0},"NA",{"$f":"IF(masque!Q120=0,\"\",masque!Q120)","v":"Bien que la quantité de ferraille et les restes d'emballage a diminué, une partie  demeure  au niveau de la réserve.\nPrésence des fientes d'oiseaux aux murs de la réserve."},{"$f":"IF(masque!R120=0,\"\",masque!R120)","v":"Eliminer la totalité de la ferraille.\nNettoyer les murs."},{"$f":"IF(masque!S120=0,\"\",masque!S120)","v":"14/06/2017\n17/02/2017"},{"$f":"IF(masque!T120=0,\"\",masque!T120)","v":"Hamza BRAIEK"}]
[null,"Sous Total :",null,{"$f":"SUM(D34:D38)","v":11},{"$f":"SUM(E34:E38)","v":10},{"$f":"SUM(F34:F38)","v":0}]
[null,null,"Max",{"$f":"E40+F40","v":48},{"$f":"masque!Q5","v":40},{"$f":"masque!R5","v":8}]
[null,null,null,null,"Note F","Note T"]
[null,"TOTAL  : ",null,null,{"$f":"SUM(E39,E31,E27)","v":37},{"$f":"SUM(F39,F31,F27)","v":8}]
[null,"NOTE : ",null,"/100",{"$f":"IF(E40=0,\"\",E42/E40)","v":0.92500000000000004},{"$f":"IF(F40=0,\"\",F42/F40)","v":1}]
[null,null,null,null,{"$f":"IF(D40=0,\"\",(E42+F42)/D40)","v":0.9375}]

{"sheet":"EPICERIE","index":11,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,8,0,10],[31,0,31,7],[32,0,32,7],[33,10,33,11]]}
[{"$f":"\"Accompagné par :  \" &masque!K6","v":"Accompagné par :  Hamza BRAIEK"},null,null,null,null,null,null,null,"EPICERIE /LIQUIDES",null,null,null,"EPI"]
[null,null,null,null,null,null,null,null,null,null,"Visite "]
[null,null,null,null,null,null,null,null,null,"Visite",{"$f":"masque!$E$11","v":"V2"}]
[null,null,null,null,null,null,null,null,null,"Date",{"$f":"masque!$E$12","v":"2017-06-14"}]
[null,null,null,null,null,null,null,null,null,"Heure"]
[null,null,null,null,null,null,null,null,"Pénalités","Base",null,null,"Non-conformité","Action corrective","Fixé le","Responsable"]
["11.","RESERVE",null,null,null,null,null,null,null,null,"F","T"]
[112,{"$f":"masque!L121","v":"Réserve propre et rangée."},{"$f":"masque!M121","v":-5},{"$f":"masque!N121","v":2},{"$f":"masque!O121","v":"OK"},{"$f":"masque!P121","v":2},{"$f":"masque!Q121","v":0},{"$f":"masque!R128","v":"Eliminer les boites de conserve rouillées."},{"$f":"masque!M121","v":-5},{"$f":"masque!N121","v":2},{"$f":"masque!P121","v":2},"NA",{"$f":"IF(masque!Q121=0,\"\",masque!Q121)","v":""},{"$f":"IF(masque!R128=0,\"\",masque!R128)","v":"Eliminer les boites de conserve rouillées."},{"$f":"IF(masque!S128=0,\"\",masque!S128)","v":"2017-06-14"},{"$f":"IF(masque!T121=0,\"\",masque!T121)","v":""}]
[113,{"$f":"masque!L122","v":"Zone de retour produit balisée"},null,null,null,null,null,null,{"$f":"masque!M122","v":-2},{"$f":"masque!N122","v":2},{"$f":"masque!P122","v":0},"NA",{"$f":"IF(masque!Q122=0,\"\",masque!Q122)","v":"Entreposage des sacs de farine sur des palettes en bois abimées\n"},{"$f":"IF(masque!R122=0,\"\",masque!R122)","v":"Utiliser des palettes en bois en bon état."},{"$f":"IF(masque!S122=0,\"\",masque!S122)","v":""},{"$f":"IF(masque!T122=0,\"\",masque!T122)","v":"Hamza BRAIEK"}]
[114,{"$f":"masque!L123","v":"Absence de stockage au sol"},"nb produit",null,null,null,null,null,{"$f":"masque!M123","v":-1},{"$f":"masque!N123","v":1},{"$f":"masque!P123","v":0},"NA",{"$f":"IF(masque!Q123=0,\"\",masque!Q123)","v":"Stockage du lait dans le couloir destiné à l'entreposage des produits casse (couloir derrière les chambres froides). \n"},{"$f":"IF(masque!R123=0,\"\",masque!R123)","v":"Stocker le lait dans la zone de stockage des liquides.\n"},{"$f":"IF(masque!S123=0,\"\",masque!S123)","v":"2017-06-14"},{"$f":"IF(masque!T123=0,\"\",masque!T123)","v":"Hamza BRAIEK"}]
[115,{"$f":"masque!L124","v":"Produits consignés isolés et balisés"},null,null,null,null,null,null,{"$f":"masque!M124","v":-2},{"$f":"masque!N124","v":2},{"$f":"masque!P124","v":2},"NA",{"$f":"IF(masque!Q124=0,\"\",masque!Q124)","v":""},{"$f":"IF(masque!R124=0,\"\",masque!R124)","v":""},{"$f":"IF(masque!S124=0,\"\",masque!S124)","v":""},{"$f":"IF(masque!T124=0,\"\",masque!T124)","v":""}]
[116,{"$f":"masque!L125","v":"Respect des DLUO"},null,null,null,null,null,null,{"$f":"masque!M125","v":-20},{"$f":"masque!N125","v":2},{"$f":"masque!P125","v":"NA"},"NA",{"$f":"IF(masque!Q131=0,\"\",masque!Q131)","v":""},{"$f":"IF(masque!R131=0,\"\",masque!R131)","v":""},{"$f":"IF(masque!S125=0,\"\",masque!S125)","v":""},{"$f":"IF(masque!T125=0,\"\",masque!T125)","v":""}]
[null,"Sous Total :",null,null,null,null,null,null,null,{"$f":"SUM(J8:J12)","v":9},{"$f":"SUM(K8:K12)","v":4},{"$f":"SUM(L8:L12)","v":0}]
[null,"HYGIENE "]
[null,{"$f":"masque!L126","v":"Présence du planning de nettoyage"},{"$f":"masque!M126","v":-1},{"$f":"masque!N126","v":1},{"$f":"masque!O126","v":"OK"},{"$f":"masque!P126","v":1},{"$f":"masque!Q126","v":0},{"$f":"masque!R126","v":0},{"$f":"masque!M126","v":-1},{"$f":"masque!N126","v":1},{"$f":"masque!P126","v":1},"NA",{"$f":"IF(masque!Q126=0,\"\",masque!Q126)","v":""},{"$f":"IF(masque!R126=0,\"\",masque!R126)","v":""},{"$f":"IF(masque!S126=0,\"\",masque!S126)","v":""},{"$f":"IF(masque!T126=0,\"\",masque!T126)","v":""}]
[null,"Sous Total :",null,null,null,null,null,null,null,{"$f":"SUM(J15)","v":1},{"$f":"SUM(K15)","v":1},{"$f":"SUM(L15)","v":0}]
["18.","LINEAIRE "]
[null,{"$f":"masque!L127","v":"Entretien des linéaires"},null,null,null,null,null,null,{"$f":"masque!M127","v":-10},{"$f":"masque!N127","v":5},"NA",{"$f":"masque!P127","v":5},{"$f":"IF(masque!Q127=0,\"\",masque!Q127)","v":""},{"$f":"IF(masque!R127=0,\"\",masque!R127)","v":""},{"$f":"IF(masque!S127=0,\"\",masque!S127)","v":""},{"$f":"IF(masque!T127=0,\"\",masque!T127)","v":""}]
[181,{"$f":"masque!L128","v":"Linéaires propres et rangés"},{"$f":"masque!M128","v":-10},{"$f":"masque!N128","v":5},{"$f":"masque!O128","v":"NOK"},{"$f":"masque!P128","v":-5},{"$f":"masque!Q128","v":"Présence de rouille sur les boites de tomate pelée (DLUO 15/07/2019).\nPrésence des éclaboussures de confiture sur l'étagère suite à un éclatement de la boite. "},{"$f":"masque!#REF!","v":{"$error":"#REF!"}},{"$f":"masque!M128","v":-10},{"$f":"masque!N128","v":5},{"$f":"masque!P128","v":-5},"NA",{"$f":"IF(masque!Q128=0,\"\",masque!Q128)","v":"Présence de rouille sur les boites de tomate pelée (DLUO 15/07/2019).\nPrésence des éclaboussures de confiture sur l'étagère suite à un éclatement de la boite. "},{"$f":"IF(masque!#REF!=0,\"\",masque!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(masque!#REF!=0,\"\",masque!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(masque!T128=0,\"\",masque!T128)","v":"Hamza BRAIEK"}]
[183,{"$f":"masque!L129","v":"Aspect satisfaisant des produits."},null,null,null,null,null,null,{"$f":"masque!M129","v":-1},{"$f":"masque!N129","v":1},{"$f":"masque!P129","v":1},"NA",{"$f":"IF(masque!Q129=0,\"\",masque!Q129)","v":""},{"$f":"IF(masque!R129=0,\"\",masque!R129)","v":""},{"$f":"IF(masque!S129=0,\"\",masque!S129)","v":""},{"$f":"IF(masque!T129=0,\"\",masque!T129)","v":""}]
[null,{"$f":"masque!L130","v":"Absence de produits non identifiés"},null,null,null,null,null,null,{"$f":"masque!M130","v":-1},{"$f":"masque!N130","v":1},{"$f":"masque!P130","v":1},"NA",{"$f":"IF(masque!Q130=0,\"\",masque!Q130)","v":""},{"$f":"IF(masque!R130=0,\"\",masque!R130)","v":""},{"$f":"IF(masque!S130=0,\"\",masque!S130)","v":""},{"$f":"IF(masque!T130=0,\"\",masque!T130)","v":""}]
[null,{"$f":"masque!L131","v":"RESPECT DES DLUO "},null,null,null,null,null,null,{"$f":"masque!M131","v":-20},{"$f":"masque!N131","v":2},{"$f":"masque!P131","v":2},"NA",{"$f":"IF(masque!#REF!=0,\"\",masque!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(masque!#REF!=0,\"\",masque!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(masque!S131=0,\"\",masque!S131)","v":""},{"$f":"IF(masque!T131=0,\"\",masque!T131)","v":""}]
[null,"Sous Total :",null,null,null,null,null,null,null,{"$f":"SUM(J18:J22)","v":14},{"$f":"SUM(K18:K22)","v":-1},{"$f":"SUM(L18:L22)","v":5}]
[56,"AUTOCONTROLES"]
[null,{"$f":"masque!L132","v":"Présence du référentiel Qualité"},{"$f":"masque!M132","v":-2},{"$f":"masque!N132","v":2},{"$f":"masque!O132","v":"Nobs"},{"$f":"masque!P132","v":"Nobs"},{"$f":"masque!Q132","v":0},{"$f":"masque!R132","v":0},{"$f":"masque!M132","v":-2},{"$f":"masque!N132","v":2},{"$f":"masque!P132","v":"Nobs"},"NA",{"$f":"IF(masque!Q132=0,\"\",masque!Q132)","v":""},{"$f":"IF(masque!R132=0,\"\",masque!R132)","v":""},{"$f":"IF(masque!S132=0,\"\",masque!S132)","v":""},{"$f":"IF(masque!T132=0,\"\",masque!T132)","v":""}]
[null,{"$f":"masque!L133","v":"Suivi des autocontrôles de nettoyage"},null,null,null,null,null,null,{"$f":"masque!M133","v":-2},{"$f":"masque!N133","v":2},{"$f":"masque!P133","v":2},"NA",{"$f":"IF(masque!Q133=0,\"\",masque!Q133)","v":""},{"$f":"IF(masque!R133=0,\"\",masque!R133)","v":""},{"$f":"IF(masque!S133=0,\"\",masque!S133)","v":""},{"$f":"IF(masque!T133=0,\"\",masque!T133)","v":""}]
[null,{"$f":"masque!L134","v":"Les résultats d'audits externes sont affichés au pole"},-1,1,null,null,null,null,{"$f":"masque!M134","v":-1},{"$f":"masque!N134","v":1},{"$f":"masque!P134","v":1},"NA",{"$f":"IF(masque!Q134=0,\"\",masque!Q134)","v":""},{"$f":"IF(masque!R134=0,\"\",masque!R134)","v":""},{"$f":"IF(masque!S134=0,\"\",masque!S134)","v":""},{"$f":"IF(masque!T134=0,\"\",masque!T134)","v":""}]
[null,{"$f":"masque!L135","v":"Mise en place de Plan d'action suite aux audits"},-1,1,null,null,null,null,{"$f":"masque!M135","v":-1},{"$f":"masque!N135","v":1},{"$f":"masque!P135","v":"NA"},"NA",{"$f":"IF(masque!Q135=0,\"\",masque!Q135)","v":""},{"$f":"IF(masque!R135=0,\"\",masque!R135)","v":""},{"$f":"IF(masque!S135=0,\"\",masque!S135)","v":""},{"$f":"IF(masque!T135=0,\"\",masque!T135)","v":""}]
[null,"Sous Total :",null,null,null,null,null,null,null,{"$f":"SUM(J25:J28)","v":6},{"$f":"SUM(K25:K28)","v":3},{"$f":"SUM(L25:L28)","v":0}]
[null,null,null,null,null,null,null,null,"Max",{"$f":"K30+L30","v":25},{"$f":"masque!Q6","v":20},{"$f":"masque!R6","v":5}]
[null,null,null,null,null,null,null,null,null,null,"Note F","Note T"]
["TOTAL  : ",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K29,K23,K16,K13)","v":7},{"$f":"SUM(L29,L23,L16,L13)","v":5}]
["NOTE : ",null,null,null,null,null,null,null,null,"/100",{"$f":"IF(K30=0,\"\",K32/K30)","v":0.35},{"$f":"IF(L30=0,\"\",L32/L30)","v":1}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J30=0,\"\",(K32+L32)/J30)","v":0.48}]

{"sheet":"POISSON","index":12,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[62,4,62,5]]}
[null,null,"POISSON",null,null,null,null,"POI"]
[null,null,null,null,"Visite "]
[{"$f":"\"Accompagné par :  \" &masque!K4","v":"Accompagné par :  Ahmed ben Salem"},null,null,"Visite",{"$f":"masque!$E$11","v":"V2"}]
[null,null,null,"Date",{"$f":"masque!$E$12","v":"2017-06-14"}]
[null,null,null,"Heure"]
[null,null,"Décote","Base",null,null,"Non-conformité","Action corrective","Fixé le","Responsable"]
[null,"POLE",null,null,"F","T"]
[null,{"$f":"masque!L48","v":"Equipement propre (table. Balance, Caisse)"},{"$f":"masque!M48","v":-2},{"$f":"masque!N48","v":2},{"$f":"masque!P48","v":2},"NA",{"$f":"IF(masque!Q48=0,\"\",masque!Q48)","v":"\n"},{"$f":"IF(masque!R48=0,\"\",masque!R48)","v":""},{"$f":"IF(masque!S48=0,\"\",masque!S48)","v":""},{"$f":"IF(masque!T48=0,\"\",masque!T48)","v":""}]
[null,{"$f":"masque!L50","v":"Entretien et propreté des sols, plinthes, murs plafonds, portes satisfaisants"},{"$f":"masque!M49","v":-5},{"$f":"masque!N49","v":2},{"$f":"masque!P49","v":2},{"$f":"masque!P50","v":-3},{"$f":"IF(masque!Q49=0,IF(masque!Q50=0,\"\",\"  S : \"&masque!Q50),IF(masque!Q50=0,\"F: \"&masque!Q49,\"F: \"&masque!Q49&\"//    S : \"&masque!Q50))","v":"  S : \nPrésence de fuite d'eau au niveau de l'évier."},{"$f":"IF(masque!R49=0,IF(masque!R50=0,\"\",\"  S : \"&masque!R50),IF(masque!R50=0,\"F: \"&masque!R49,\"F: \"&masque!R49&\"//    S : \"&masque!R50))","v":"  S : Réparer la fuite"},{"$f":"IF(masque!S49=0,IF(masque!S50=0,\"\",\"  S : \"&masque!S50),IF(masque!S50=0,\"F: \"&masque!S49,\"F: \"&masque!S49&\"//    S : \"&masque!S50))","v":"  S : 42900"},{"$f":"IF(masque!T49=0,IF(masque!T50=0,\"\",\"  S : \"&masqueT47),IF(masque!T50=0,\"F: \"&masque!T49,\"F: \"&masque!T49&\"//    S : \"&masque!T50))","v":"F: //    S : Ahmed ben Salem"}]
[null,{"$f":"masque!L52","v":"Entretien et propreté des évacuations au sol satisfaisants"},{"$f":"masque!M51","v":-1},{"$f":"masque!N51","v":1},{"$f":"masque!P51","v":1},{"$f":"masque!P52","v":1},{"$f":"IF(masque!Q51=0,IF(masque!Q52=0,\"\",\"  S : \"&masque!Q52),IF(masque!Q52=0,\"F: \"&masque!Q51,\"F: \"&masque!Q51&\"//    S : \"&masque!Q52))","v":""},{"$f":"IF(masque!R51=0,IF(masque!R52=0,\"\",\"  S : \"&masque!R52),IF(masque!R52=0,\"F: \"&masque!R51,\"F: \"&masque!R51&\"//    S : \"&masque!R52))","v":""},{"$f":"IF(masque!S51=0,IF(masque!S52=0,\"\",\"  S : \"&masque!S52),IF(masque!S52=0,\"F: \"&masque!S51,\"F: \"&masque!S51&\"//    S : \"&masque!S52))","v":""},{"$f":"IF(masque!T51=0,IF(masque!T52=0,\"\",\"  S : \"&masqueT49),IF(masque!T52=0,\"F: \"&masque!T51,\"F: \"&masque!T51&\"//    S : \"&masque!T52))","v":"F: //    S : "}]
[null,{"$f":"masque!L53","v":"Présence et bon fonctionnement du thermomètre enregistreur"},{"$f":"masque!M53","v":-1},{"$f":"masque!N53","v":1},"NA",{"$f":"masque!P53","v":1},{"$f":"IF(masque!Q53=0,\"\",masque!Q53)","v":""},{"$f":"IF(masque!R53=0,\"\",masque!R53)","v":""},{"$f":"IF(masque!S53=0,\"\",masque!S53)","v":""},{"$f":"IF(masque!T53=0,\"\",masque!T53)","v":""}]
[null,{"$f":"masque!L54","v":"Entretien et Nettoyage des évaporateurs"},{"$f":"masque!M54","v":-2},{"$f":"masque!N54","v":2},"NA",{"$f":"masque!P54","v":2},{"$f":"IF(masque!Q54=0,\"\",masque!Q54)","v":""},{"$f":"IF(masque!R54=0,\"\",masque!R54)","v":" "},{"$f":"IF(masque!S54=0,\"\",masque!S54)","v":""},{"$f":"IF(masque!T54=0,\"\",masque!T54)","v":""}]
[null,{"$f":"masque!L55","v":"Présence d'une poubelle conforme"},{"$f":"masque!M55","v":-1},{"$f":"masque!N55","v":1},{"$f":"masque!P55","v":1},"NA",{"$f":"IF(masque!Q55=0,\"\",masque!Q55)","v":""},{"$f":"IF(masque!R55=0,\"\",masque!R55)","v":""},{"$f":"IF(masque!S55=0,\"\",masque!S55)","v":""},{"$f":"IF(masque!T55=0,\"\",masque!T55)","v":""}]
[null,{"$f":"masque!L56","v":"Respect des DLC "},{"$f":"masque!M56","v":-20},{"$f":"masque!N56","v":2},{"$f":"masque!P56","v":2},"NA",{"$f":"IF(masque!Q56=0,\"\",masque!Q56)","v":""},{"$f":"IF(masque!R56=0,\"\",masque!R56)","v":""},{"$f":"IF(masque!S56=0,\"\",masque!S56)","v":""},{"$f":"IF(masque!T56=0,\"\",masque!T56)","v":""}]
[null,{"$f":"masque!L57","v":"Absence de charge excessive"},{"$f":"masque!M57","v":-1},{"$f":"masque!N57","v":1},{"$f":"masque!P57","v":"NA"},"NA",{"$f":"IF(masque!Q57=0,\"\",masque!Q57)","v":"Absence de vente de poissons frais le jour de l'audit"},{"$f":"IF(masque!R57=0,\"\",masque!R57)","v":""},{"$f":"IF(masque!S57=0,\"\",masque!S57)","v":""},{"$f":"IF(masque!T57=0,\"\",masque!T57)","v":""}]
[null,{"$f":"masque!L58","v":"Absence de produits non identifiés"},{"$f":"masque!M58","v":-5},{"$f":"masque!N58","v":2},{"$f":"masque!P58","v":"NA"},"NA",{"$f":"IF(masque!Q58=0,\"\",masque!Q58)","v":""},{"$f":"IF(masque!R58=0,\"\",masque!R58)","v":""},{"$f":"IF(masque!S58=0,\"\",masque!S58)","v":""},{"$f":"IF(masque!T58=0,\"\",masque!T58)","v":""}]
[null,{"$f":"masque!L59","v":"Présentation satisfaisante des produits au niveau du pole: Poissons entiers/mollusques"},{"$f":"masque!M59","v":-1},{"$f":"masque!N59","v":1},{"$f":"masque!P59","v":"NA"},"NA",{"$f":"IF(masque!Q64=0,\"\",masque!Q64)","v":""},{"$f":"IF(masque!R64=0,\"\",masque!R64)","v":""},{"$f":"IF(masque!S64=0,\"\",masque!S64)","v":""},{"$f":"IF(masque!T59=0,\"\",masque!T59)","v":""}]
[null,{"$f":"masque!L60","v":"Présentation satisfaisante des produits au niveau du pole: Coquillages vivants"},{"$f":"masque!M60","v":-1},{"$f":"masque!N60","v":1},{"$f":"masque!P60","v":"NA"},"NA",{"$f":"IF(masque!Q60=0,\"\",masque!Q60)","v":""},{"$f":"IF(masque!R60=0,\"\",masque!R60)","v":""},{"$f":"IF(masque!S60=0,\"\",masque!S60)","v":""},{"$f":"IF(masque!T60=0,\"\",masque!T60)","v":""}]
[null,{"$f":"masque!L61","v":"Présentation satisfaisante des produits au niveau du pole: Crustacés vivants"},{"$f":"masque!M61","v":-1},{"$f":"masque!N61","v":1},{"$f":"masque!P61","v":"NA"},"NA",{"$f":"IF(masque!Q61=0,\"\",masque!Q61)","v":""},{"$f":"IF(masque!R61=0,\"\",masque!R61)","v":""},{"$f":"IF(masque!S61=0,\"\",masque!S61)","v":""},{"$f":"IF(masque!T61=0,\"\",masque!T61)","v":""}]
[null,{"$f":"masque!L62","v":"Respect des températures réglementaires "},{"$f":"masque!M62","v":-2},{"$f":"masque!N62","v":2},{"$f":"masque!P62","v":"NA"},"NA",{"$f":"IF(masque!Q62=0,\"\",masque!Q62)","v":""},{"$f":"IF(masque!R62=0,\"\",masque!R62)","v":""},{"$f":"IF(masque!S62=0,\"\",masque!S62)","v":""},{"$f":"IF(masque!T62=0,\"\",masque!T62)","v":""}]
[null,{"$f":"masque!L63","v":"Absence de décoration au contact des produits"},{"$f":"masque!M63","v":-2},{"$f":"masque!N63","v":2},{"$f":"masque!P63","v":"NA"},"NA",{"$f":"IF(masque!Q63=0,\"\",masque!Q63)","v":""},{"$f":"IF(masque!R63=0,\"\",masque!R63)","v":""},{"$f":"IF(masque!S63=0,\"\",masque!S63)","v":""},{"$f":"IF(masque!T63=0,\"\",masque!T63)","v":""}]
[null,{"$f":"masque!L64","v":"Produits correctement glacés ou présentés."},{"$f":"masque!M64","v":-2},{"$f":"masque!N64","v":2},{"$f":"masque!P64","v":"NA"},"NA",{"$f":"IF(masque!#REF!=0,\"\",masque!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(masque!#REF!=0,\"\",masque!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(masque!#REF!=0,\"\",masque!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(masque!T64=0,\"\",masque!T64)","v":""}]
[null,{"$f":"masque!L65","v":"Etiquetage et balisage conformes et complets"},{"$f":"masque!M65","v":-5},{"$f":"masque!N65","v":2},{"$f":"masque!P65","v":"NA"},"NA",{"$f":"IF(masque!Q65=0,\"\",masque!Q65)","v":""},{"$f":"IF(masque!R65=0,\"\",masque!R65)","v":""},{"$f":"IF(masque!S65=0,\"\",masque!S65)","v":""},{"$f":"IF(masque!T65=0,\"\",masque!T65)","v":""}]
[null,{"$f":"masque!L66","v":"Absence d’étiquettes piquées dans les produits"},{"$f":"masque!M66","v":-5},{"$f":"masque!N66","v":2},{"$f":"masque!P66","v":"NA"},"NA",{"$f":"IF(masque!Q66=0,\"\",masque!Q66)","v":""},{"$f":"IF(masque!R66=0,\"\",masque!R66)","v":""},{"$f":"IF(masque!S66=0,\"\",masque!S66)","v":""},{"$f":"IF(masque!T66=0,\"\",masque!T66)","v":""}]
[null,{"$f":"masque!L67","v":"Balances tarées"},{"$f":"masque!M67","v":-5},{"$f":"masque!N67","v":2},{"$f":"masque!P67","v":2},"NA",{"$f":"IF(masque!Q67=0,\"\",masque!Q67)","v":""},{"$f":"IF(masque!R67=0,\"\",masque!R67)","v":""},{"$f":"IF(masque!S67=0,\"\",masque!S67)","v":""},{"$f":"IF(masque!T67=0,\"\",masque!T67)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D8:D25)","v":29},{"$f":"SUM(E8:E25)","v":10},{"$f":"SUM(F8:F25)","v":1}]
[null,"LINEAIRE SURGELE"]
[null,{"$f":"masque!L68","v":"Absence d'attente hors froid"},{"$f":"masque!M68","v":-1},{"$f":"masque!N68","v":1},{"$f":"masque!P68","v":1},"NA",{"$f":"IF(masque!Q68=0,\"\",masque!Q68)","v":""},{"$f":"IF(masque!R68=0,\"\",masque!R68)","v":""},{"$f":"IF(masque!S68=0,\"\",masque!S68)","v":""},{"$f":"IF(masque!T68=0,\"\",masque!T68)","v":""}]
[null,{"$f":"masque!L69","v":"Propreté des meubles satisfaisants"},{"$f":"masque!M69","v":-5},{"$f":"masque!N69","v":2},{"$f":"masque!P69","v":2},"NA",{"$f":"IF(masque!Q69=0,\"\",masque!Q69)","v":""},{"$f":"IF(masque!R69=0,\"\",masque!R69)","v":""},{"$f":"IF(masque!S69=0,\"\",masque!S69)","v":""},{"$f":"IF(masque!T69=0,\"\",masque!T69)","v":""}]
[null,{"$f":"masque!L70","v":"entretien des meubles satisfaisants"},{"$f":"masque!M70","v":-5},{"$f":"masque!N70","v":2},"NA",{"$f":"masque!P70","v":2},{"$f":"IF(masque!Q70=0,\"\",masque!Q70)","v":""},{"$f":"IF(masque!R70=0,\"\",masque!R70)","v":""},{"$f":"IF(masque!S70=0,\"\",masque!S70)","v":""},{"$f":"IF(masque!T70=0,\"\",masque!T70)","v":""}]
[null,{"$f":"masque!L71","v":"Absence de charge excessive"},{"$f":"masque!M71","v":-1},{"$f":"masque!N71","v":1},{"$f":"masque!P71","v":1},"NA",{"$f":"IF(masque!Q71=0,\"\",masque!Q71)","v":""},{"$f":"IF(masque!R71=0,\"\",masque!R71)","v":""},{"$f":"IF(masque!S71=0,\"\",masque!S71)","v":""},{"$f":"IF(masque!T71=0,\"\",masque!T71)","v":""}]
[null,{"$f":"masque!L72","v":"Respect des DLC "},{"$f":"masque!M72","v":-10},{"$f":"masque!N72","v":2},{"$f":"masque!P72","v":2},"NA",{"$f":"IF(masque!Q72=0,\"\",masque!Q72)","v":""},{"$f":"IF(masque!R72=0,\"\",masque!R72)","v":""},{"$f":"IF(masque!S72=0,\"\",masque!S72)","v":""},{"$f":"IF(masque!T72=0,\"\",masque!T72)","v":""}]
[null,{"$f":"masque!L73","v":"Température  adaptée (-18°C)"},{"$f":"masque!M73","v":-2},{"$f":"masque!N73","v":2},"NA",{"$f":"masque!P73","v":2},{"$f":"IF(masque!Q73=0,\"\",masque!Q73)","v":""},{"$f":"IF(masque!R73=0,\"\",masque!R73)","v":""},{"$f":"IF(masque!S73=0,\"\",masque!S73)","v":""},{"$f":"IF(masque!T73=0,\"\",masque!T73)","v":""}]
[null,{"$f":"masque!L74","v":"Aspect satisfaisant des produits"},{"$f":"masque!M74","v":-1},{"$f":"masque!N74","v":1},{"$f":"masque!P74","v":1},"NA",{"$f":"IF(masque!Q74=0,\"\",masque!Q74)","v":""},{"$f":"IF(masque!R74=0,\"\",masque!R74)","v":""},{"$f":"IF(masque!S74=0,\"\",masque!S74)","v":""},{"$f":"IF(masque!T74=0,\"\",masque!T74)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D28:D34)","v":11},{"$f":"SUM(E28:E34)","v":7},{"$f":"SUM(F28:F34)","v":4}]
[12,"METHODES DE TRAVAIL"]
[123,{"$f":"masque!L75","v":"Glaçage hygiénique des caisses"},{"$f":"masque!M75","v":-1},{"$f":"masque!N75","v":1},{"$f":"masque!P75","v":1},"NA",{"$f":"IF(masque!Q75=0,\"\",masque!Q75)","v":""},{"$f":"IF(masque!R75=0,\"\",masque!R75)","v":""},{"$f":"IF(masque!S75=0,\"\",masque!S75)","v":""},{"$f":"IF(masque!T75=0,\"\",masque!T75)","v":""}]
["124a",{"$f":"masque!L76","v":"Manipulations rigoureuses."},{"$f":"masque!M76","v":-2},{"$f":"masque!N76","v":2},{"$f":"masque!P76","v":2},"NA",{"$f":"IF(masque!Q76=0,\"\",masque!Q76)","v":""},{"$f":"IF(masque!R76=0,\"\",masque!R76)","v":""},{"$f":"IF(masque!S76=0,\"\",masque!S76)","v":""},{"$f":"IF(masque!T76=0,\"\",masque!T76)","v":""}]
["124b",{"$f":"masque!L77","v":"présence d'une pelle à glace pas à meme le sol."},{"$f":"masque!M77","v":-1},{"$f":"masque!N77","v":1},{"$f":"masque!P77","v":0},"NA",{"$f":"IF(masque!Q77=0,\"\",masque!Q77)","v":"La pelle à glace est abimée"},{"$f":"IF(masque!R77=0,\"\",masque!R77)","v":"Remplacer la pelle."},{"$f":"IF(masque!S77=0,\"\",masque!S77)","v":""},{"$f":"IF(masque!T77=0,\"\",masque!T77)","v":"Ahmed ben Salem"}]
[124,{"$f":"masque!L78","v":"Entretien, propreté et stockage satisfaisants des pics prix"},{"$f":"masque!M78","v":-1},{"$f":"masque!N78","v":1},{"$f":"masque!P78","v":"Nobs"},"NA",{"$f":"IF(masque!Q78=0,\"\",masque!Q78)","v":""},{"$f":"IF(masque!R78=0,\"\",masque!R78)","v":""},{"$f":"IF(masque!S78=0,\"\",masque!S78)","v":""},{"$f":"IF(masque!T78=0,\"\",masque!T78)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D37:D40)","v":5},{"$f":"SUM(E37:E40)","v":3},{"$f":"SUM(F37:F40)","v":0}]
["16.","HYGIENE"]
[1531,{"$f":"masque!L79","v":"Produits d’entretien conformes et correctement utilisés et rangés"},{"$f":"masque!M79","v":-1},{"$f":"masque!N79","v":1},{"$f":"masque!P79","v":1},"NA",{"$f":"IF(masque!Q79=0,\"\",masque!Q79)","v":""},{"$f":"IF(masque!R79=0,\"\",masque!R79)","v":""},null,{"$f":"IF(masque!T79=0,\"\",masque!T79)","v":""}]
[null,{"$f":"masque!L80","v":"Présence du planning de nettoyage"},{"$f":"masque!M80","v":-1},{"$f":"masque!N80","v":1},{"$f":"masque!P80","v":"NA"},"NA",{"$f":"IF(masque!Q80=0,\"\",masque!Q80)","v":""},{"$f":"IF(masque!R80=0,\"\",masque!R80)","v":""},null,{"$f":"IF(masque!T80=0,\"\",masque!T80)","v":""}]
[null,{"$f":"masque!L82","v":"Propreté et entretien  des évacuations au sol satisfaisants"},{"$f":"masque!M81","v":-1},{"$f":"masque!N81","v":1},{"$f":"masque!P81","v":1},{"$f":"masque!P82","v":1},{"$f":"IF(masque!Q81=0,IF(masque!Q82=0,\"\",\"  S : \"&masque!Q82),IF(masque!Q82=0,\"F: \"&masque!Q81,\"F: \"&masque!Q81&\"//    S : \"&masque!Q82))","v":""},{"$f":"IF(masque!R81=0,IF(masque!R82=0,\"\",\"  S : \"&masque!R82),IF(masque!R82=0,\"F: \"&masque!R81,\"F: \"&masque!R81&\"//    S : \"&masque!R82))","v":""},{"$f":"IF(masque!S81=0,IF(masque!S82=0,\"\",\"  S : \"&masque!S82),IF(masque!S82=0,\"F: \"&masque!S81,\"F: \"&masque!S81&\"//    S : \"&masque!S82))","v":""},{"$f":"IF(masque!T81=0,IF(masque!T82=0,\"\",\"  S : \"&masque!T82),IF(masque!T82=0,\"F: \"&masque!T81,\"F: \"&masque!T81&\"//    S : \"&masque!T82))","v":"F: //    S : "}]
[null,{"$f":"masque!L83","v":"Entretien et propreté des bacs à glace satisfaisants"},{"$f":"masque!M83","v":-1},{"$f":"masque!N83","v":1},{"$f":"masque!P83","v":"Nobs"},"NA",{"$f":"IF(masque!Q83=0,\"\",masque!Q83)","v":""},{"$f":"IF(masque!R83=0,\"\",masque!R83)","v":""},{"$f":"IF(masque!S83=0,\"\",masque!S83)","v":""},{"$f":"IF(masque!T83=0,\"\",masque!T83)","v":""}]
[null,{"$f":"masque!L84","v":"Poubelles propres"},{"$f":"masque!M84","v":-1},{"$f":"masque!N84","v":1},{"$f":"masque!P84","v":1},"NA",{"$f":"IF(masque!Q84=0,\"\",masque!Q84)","v":""},{"$f":"IF(masque!R84=0,\"\",masque!R84)","v":""},{"$f":"IF(masque!S84=0,\"\",masque!S84)","v":""},{"$f":"IF(masque!T84=0,\"\",masque!T84)","v":""}]
[153,{"$f":"masque!L85","v":"Mains propres et protection des plaies"},{"$f":"masque!M85","v":-1},{"$f":"masque!N85","v":1},{"$f":"masque!P85","v":0},"NA",{"$f":"IF(masque!Q85=0,\"\",masque!Q85)","v":"absence de distributeur papier et distributeur savon liquide. "},{"$f":"IF(masque!R85=0,\"\",masque!R85)","v":"Fixer les distributeurs."},{"$f":"IF(masque!S85=0,\"\",masque!S85)","v":42783},{"$f":"IF(masque!T85=0,\"\",masque!T85)","v":"Ahmed ben Salem"}]
[164,{"$f":"masque!L86","v":"Lave-mains équipés réglementairement"},{"$f":"masque!M86","v":-5},{"$f":"masque!N86","v":2},"NA",{"$f":"masque!P86","v":2},{"$f":"IF(masque!Q86=0,\"\",masque!Q86)","v":""},{"$f":"IF(masque!R86=0,\"\",masque!R86)","v":""},{"$f":"IF(masque!S86=0,\"\",masque!S86)","v":""},{"$f":"IF(masque!T86=0,\"\",masque!T86)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D43:D49)","v":8},{"$f":"SUM(E43:E49)","v":3},{"$f":"SUM(F43:F49)","v":3}]
["22.","AUTOCONTROLES"]
[221,{"$f":"masque!L87","v":"Présence du référentiel qualité."},{"$f":"masque!M87","v":-2},{"$f":"masque!N87","v":2},{"$f":"masque!P87","v":2},"NA",{"$f":"IF(masque!Q87=0,\"\",masque!Q87)","v":""},{"$f":"IF(masque!R87=0,\"\",masque!R87)","v":""},{"$f":"IF(masque!S87=0,\"\",masque!S87)","v":""},{"$f":"IF(masque!T87=0,\"\",masque!T87)","v":""}]
["222a",{"$f":"masque!L88","v":"Suivi des autocontrôles de nettoyage"},{"$f":"masque!M88","v":-2},{"$f":"masque!N88","v":2},{"$f":"masque!P88","v":2},"NA",{"$f":"IF(masque!Q88=0,\"\",masque!Q88)","v":""},{"$f":"IF(masque!R88=0,\"\",masque!R88)","v":""},{"$f":"IF(masque!S88=0,\"\",masque!S88)","v":""},{"$f":"IF(masque!T88=0,\"\",masque!T88)","v":""}]
[null,{"$f":"masque!L89","v":"Autocontrôle des températures"},{"$f":"masque!M89","v":-5},{"$f":"masque!N89","v":5},{"$f":"masque!P89","v":5},"NA",{"$f":"IF(masque!Q89=0,\"\",masque!Q89)","v":""},{"$f":"IF(masque!R89=0,\"\",masque!R89)","v":""},{"$f":"IF(masque!S89=0,\"\",masque!S89)","v":""},{"$f":"IF(masque!T89=0,\"\",masque!T89)","v":""}]
["222b",{"$f":"masque!L90","v":"Les résultats d'audits externes sont affichés au pole"},{"$f":"masque!M90","v":-1},{"$f":"masque!N90","v":1},{"$f":"masque!P90","v":1},"NA",{"$f":"IF(masque!Q90=0,\"\",masque!Q90)","v":""},{"$f":"IF(masque!R90=0,\"\",masque!R90)","v":""},{"$f":"IF(masque!S90=0,\"\",masque!S90)","v":""},{"$f":"IF(masque!T90=0,\"\",masque!T90)","v":""}]
[null,{"$f":"masque!L91","v":"Mise en place de Plan d'action suite aux audits"},{"$f":"masque!M91","v":-1},{"$f":"masque!N91","v":1},{"$f":"masque!P91","v":"Nobs"},"NA",{"$f":"IF(masque!Q91=0,\"\",masque!Q91)","v":""},{"$f":"IF(masque!R91=0,\"\",masque!R91)","v":""},{"$f":"IF(masque!S91=0,\"\",masque!S91)","v":""},{"$f":"IF(masque!T91=0,\"\",masque!T91)","v":""}]
[223,{"$f":"masque!L92","v":"Mise en place d'actions correctives suite aux analyses non conformes (surgelés)"},{"$f":"masque!M92","v":-2},{"$f":"masque!N92","v":2},{"$f":"masque!P92","v":2},"NA",{"$f":"IF(masque!Q92=0,\"\",masque!Q92)","v":""},{"$f":"IF(masque!R92=0,\"\",masque!R92)","v":""},{"$f":"IF(masque!S92=0,\"\",masque!S92)","v":""},{"$f":"IF(masque!T92=0,\"\",masque!T92)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D52:D57)","v":13},{"$f":"SUM(E52:E57)","v":12},{"$f":"SUM(F52:F57)","v":0}]
[null,null,"Max",{"$f":"E59+F59","v":50},{"$f":"masque!Q4","v":37},{"$f":"masque!R4","v":13}]
[null,null,null,null,"Note F","Note T"]
[null,"TOTAL  DE LA NOTE :",null,null,{"$f":"SUM(E58,E50,E41,E35,E26)","v":35},{"$f":"SUM(F58,F50,F41,F35,F26)","v":8}]
[null,"NOTE : ",null,"/100",{"$f":"IF(E59=0,\"\",E61/E59)","v":0.94594594594594594},{"$f":"IF(F59=0,\"\",F61/F59)","v":0.61538461538461542}]
[null,null,null,null,{"$f":"IF(D59=0,\"\",(E61+F61)/D59)","v":0.86}]

{"sheet":"PLS BOUCHERIE","index":13,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[[64,4,64,5]]}
[{"$f":"\"Accompagné par :  \" &masque!K7","v":"Accompagné par :  Brahim brongi"},null,null,"PLS/BOUCHERIE",null,null,null,"PLS"]
[null,null,null,null,"Visite "]
[null,null,null,"Visite",{"$f":"masque!$E$11","v":"V2"}]
[null,null,null,"Date",{"$f":"masque!$E$12","v":"2017-06-14"}]
[null,null,null,"Heure"]
[null,null,"Pénalités","Base",null,null,"Non-conformité","Action corrective","Fixé le","Responsable"]
[11,"CHAMBRE FROIDE PLS",null,null,"F","T"]
[111,{"$f":"masque!L136","v":"Température adaptée (+4°C)"},{"$f":"masque!M136","v":-1},{"$f":"masque!N136","v":1},{"$f":"masque!P136","v":"NA"},"NA",{"$f":"IF(masque!Q136=0,\"\",masque!Q136)","v":""},{"$f":"IF(masque!R136=0,\"\",masque!R136)","v":""},{"$f":"IF(masque!S136=0,\"\",masque!S136)","v":""},{"$f":"IF(masque!T136=0,\"\",masque!T136)","v":""}]
[null,{"$f":"masque!L138","v":"Propreté et entretien de la chambre froide satisfaisant Sols, évacuations, Murs, plafonds, portes, Etagères"},{"$f":"masque!M137","v":-5},{"$f":"masque!N137","v":2},{"$f":"masque!P137","v":"NA"},{"$f":"masque!P138","v":"NA"},{"$f":"IF(masque!Q137=0,IF(masque!Q138=0,\"\",\"  S : \"&masque!Q138),IF(masque!Q138=0,\"F: \"&masque!Q137,\"F: \"&masque!Q137&\"//    S : \"&masque!Q138))","v":""},{"$f":"IF(masque!R137=0,IF(masque!R138=0,\"\",\"  S : \"&masque!R138),IF(masque!R138=0,\"F: \"&masque!R137,\"F: \"&masque!R137&\"//    S : \"&masque!R138))","v":""},{"$f":"IF(masque!S137=0,IF(masque!S138=0,\"\",\"  S : \"&masque!S138),IF(masque!S138=0,\"F: \"&masque!S137,\"F: \"&masque!S137&\"//    S : \"&masque!S138))","v":""},{"$f":"IF(masque!T137=0,IF(masque!T138=0,\"\",\"  S : \"&masque!T138),IF(masque!T138=0,\"F: \"&masque!T137,\"F: \"&masque!T137&\"//    S : \"&masque!T138))","v":"  S : "}]
["112b",{"$f":"masque!L139","v":"Rangement satisfaisant"},{"$f":"masque!M139","v":-1},{"$f":"masque!N139","v":1},{"$f":"masque!P139","v":"NA"},"NA",{"$f":"IF(masque!Q139=0,\"\",masque!Q139)","v":""},{"$f":"IF(masque!R139=0,\"\",masque!R139)","v":""},{"$f":"IF(masque!S139=0,\"\",masque!S139)","v":""},{"$f":"IF(masque!T139=0,\"\",masque!T139)","v":""}]
[null,{"$f":"masque!L140","v":"Absence de stockage au sol"},{"$f":"masque!M140","v":-1},{"$f":"masque!N140","v":1},{"$f":"masque!P140","v":"NA"},"NA",{"$f":"IF(masque!Q140=0,\"\",masque!Q140)","v":""},{"$f":"IF(masque!R140=0,\"\",masque!R140)","v":""},{"$f":"IF(masque!S140=0,\"\",masque!S140)","v":""},{"$f":"IF(masque!T140=0,\"\",masque!T140)","v":""}]
[null,{"$f":"masque!L141","v":"Absence de déchets non isolés/ non identifiés"},{"$f":"masque!M141","v":-10},{"$f":"masque!N141","v":2},{"$f":"masque!P141","v":"NA"},"NA",{"$f":"IF(masque!Q141=0,\"\",masque!Q141)","v":""},{"$f":"IF(masque!R141=0,\"\",masque!R141)","v":""},{"$f":"IF(masque!S141=0,\"\",masque!S141)","v":""},{"$f":"IF(masque!T141=0,\"\",masque!T141)","v":""}]
["112c",{"$f":"masque!L142","v":"Respect des DLC/DLUO"},{"$f":"masque!M142","v":-10},{"$f":"masque!N142","v":2},{"$f":"masque!P142","v":"NA"},"NA",{"$f":"IF(masque!Q142=0,\"\",masque!Q142)","v":""},{"$f":"IF(masque!R142=0,\"\",masque!R142)","v":""},{"$f":"IF(masque!S142=0,\"\",masque!S142)","v":""},{"$f":"IF(masque!T142=0,\"\",masque!T142)","v":""}]
[null,{"$f":"masque!L143","v":"Absence de palette en bois, de carton"},{"$f":"masque!M143","v":-1},{"$f":"masque!N143","v":1},{"$f":"masque!P143","v":"NA"},"NA",{"$f":"IF(masque!Q143=0,\"\",masque!Q143)","v":""},{"$f":"IF(masque!R143=0,\"\",masque!R143)","v":""},{"$f":"IF(masque!S143=0,\"\",masque!S143)","v":""},{"$f":"IF(masque!T143=0,\"\",masque!T143)","v":""}]
[null,{"$f":"masque!L144","v":"Absence de produit non identifié en chambre froide"},{"$f":"masque!M144","v":-2},{"$f":"masque!N144","v":2},{"$f":"masque!P144","v":"NA"},"NA",{"$f":"IF(masque!Q144=0,\"\",masque!Q144)","v":""},{"$f":"IF(masque!R144=0,\"\",masque!R144)","v":""},{"$f":"IF(masque!S144=0,\"\",masque!S144)","v":""},{"$f":"IF(masque!T144=0,\"\",masque!T144)","v":""}]
[113,{"$f":"masque!L145","v":"Présence et bon fonctionnement du thermomètre enregistreur"},{"$f":"masque!M145","v":-1},{"$f":"masque!N145","v":1},"NA",{"$f":"masque!P145","v":"NA"},{"$f":"IF(masque!Q145=0,\"\",masque!Q145)","v":""},{"$f":"IF(masque!R145=0,\"\",masque!R145)","v":""},{"$f":"IF(masque!S145=0,\"\",masque!S145)","v":""},{"$f":"IF(masque!T145=0,\"\",masque!T145)","v":""}]
[114,{"$f":"masque!L146","v":"Porte fermée"},{"$f":"masque!M146","v":-1},{"$f":"masque!N146","v":1},{"$f":"masque!P146","v":1},"NA",{"$f":"IF(masque!Q146=0,\"\",masque!Q146)","v":""},{"$f":"IF(masque!R146=0,\"\",masque!R146)","v":""},{"$f":"IF(masque!S146=0,\"\",masque!S146)","v":""},{"$f":"IF(masque!T146=0,\"\",masque!T146)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D8:D17)","v":14},{"$f":"SUM(E8:E17)","v":1},{"$f":"SUM(F8:F17)","v":0}]
[11,"HYGIENE "]
[111,{"$f":"masque!L147","v":"Produits d’entretien conformes et correctement utilisés et rangés"},{"$f":"masque!M147","v":-1},{"$f":"masque!N147","v":1},{"$f":"masque!P147","v":1},"NA",{"$f":"IF(masque!Q147=0,\"\",masque!Q147)","v":""},{"$f":"IF(masque!R147=0,\"\",masque!R147)","v":""},{"$f":"IF(masque!S147=0,\"\",masque!S147)","v":""},{"$f":"IF(masque!T147=0,\"\",masque!T147)","v":""}]
["112.3",{"$f":"masque!L148","v":"Présence du planning de nettoyage"},{"$f":"masque!M148","v":-1},{"$f":"masque!N148","v":1},{"$f":"masque!P148","v":0},"NA",{"$f":"IF(masque!Q148=0,\"\",masque!Q148)","v":"Linéaires rouillées"},{"$f":"IF(masque!R148=0,\"\",masque!R148)","v":"Repeindre les étagères."},{"$f":"IF(masque!S148=0,\"\",masque!S148)","v":""},{"$f":"IF(masque!T148=0,\"\",masque!T148)","v":"Brahim brongi"}]
[null,"Sous Total :",null,{"$f":"SUM(D20:D21)","v":2},{"$f":"SUM(E20:E21)","v":1},{"$f":"SUM(F20:F21)","v":0}]
[18,"POLE"]
[null,{"$f":"masque!L149","v":"Entretien des linéaires"},{"$f":"masque!M149","v":-5},{"$f":"masque!N149","v":2},"NA",{"$f":"masque!P149","v":2},{"$f":"IF(masque!Q149=0,\"\",masque!Q149)","v":""},{"$f":"IF(masque!R191=0,\"\",masque!R191)","v":""},{"$f":"IF(masque!S149=0,\"\",masque!S149)","v":""},{"$f":"IF(masque!T149=0,\"\",masque!T149)","v":""}]
[null,{"$f":"masque!L150","v":"Linéaires propres."},{"$f":"masque!M150","v":-5},{"$f":"masque!N150","v":2},{"$f":"masque!P150","v":-3},"NA",{"$f":"IF(masque!Q150=0,\"\",masque!Q150)","v":"Résine écaillée\nla vitre de la porte est brisée."},{"$f":"IF(masque!R150=0,\"\",masque!R150)","v":"Fixer le revêtement du sol.\nRemplacer la vitre brisée."},{"$f":"IF(masque!S150=0,\"\",masque!S150)","v":""},{"$f":"IF(masque!T150=0,\"\",masque!T150)","v":"Brahim brongi"}]
[null,{"$f":"masque!L152","v":"Entretien et propreté des sols, plinthes, murs plafonds, portes satisfaisants"},{"$f":"masque!M152","v":-5},{"$f":"masque!N152","v":2},{"$f":"masque!P152","v":2},{"$f":"masque!P151","v":-3},{"$f":"IF(masque!Q151=0,IF(masque!#REF!=0,\"\",\"  S : \"&masque!#REF!),IF(masque!#REF!=0,\"F: \"&masque!Q151,\"F: \"&masque!Q151&\"//    S : \"&masque!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(masque!R151=0,IF(masque!#REF!=0,\"\",\"  S : \"&masque!#REF!),IF(masque!#REF!=0,\"F: \"&masque!R151,\"F: \"&masque!R151&\"//    S : \"&masque!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(masque!S151=0,IF(masque!#REF!=0,\"\",\"  S : \"&masque!#REF!),IF(masque!#REF!=0,\"F: \"&masque!S151,\"F: \"&masque!S151&\"//    S : \"&masque!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(masque!T152=0,IF(masque!T151=0,\"\",\"  S : \"&masque!T151),IF(masque!T151=0,\"F: \"&masque!T152,\"F: \"&masque!T152&\"//    S : \"&masque!T151))","v":"F: //    S : Brahim brongi"}]
[null,{"$f":"masque!L154","v":"Entretien et propreté des évacuations au sol satisfaisants"},{"$f":"masque!M154","v":-1},{"$f":"masque!N154","v":1},{"$f":"masque!P153","v":1},{"$f":"masque!P154","v":1},{"$f":"IF(masque!Q153=0,IF(masque!Q154=0,\"\",\"  S : \"&masque!Q154),IF(masque!Q154=0,\"F: \"&masque!Q153,\"F: \"&masque!Q153&\"//    S : \"&masque!Q154))","v":""},{"$f":"IF(masque!R153=0,IF(masque!R154=0,\"\",\"  S : \"&masque!R154),IF(masque!R154=0,\"F: \"&masque!R153,\"F: \"&masque!R153&\"//    S : \"&masque!R154))","v":""},{"$f":"IF(masque!S153=0,IF(masque!S154=0,\"\",\"  S : \"&masque!S154),IF(masque!S154=0,\"F: \"&masque!S153,\"F: \"&masque!S153&\"//    S : \"&masque!S154))","v":""},{"$f":"IF(masque!T153=0,IF(masque!T154=0,\"\",\"  S : \"&masque!T154),IF(masque!T154=0,\"F: \"&masque!T153,\"F: \"&masque!T153&\"//    S : \"&masque!T154))","v":"F: //    S : "}]
[null,{"$f":"masque!L155","v":"Présence et bon fonctionnement du thermomètre enregistreur"},{"$f":"masque!M155","v":-1},{"$f":"masque!N155","v":1},"NA",{"$f":"masque!P155","v":1},{"$f":"IF(masque!Q155=0,\"\",masque!Q155)","v":""},{"$f":"IF(masque!R155=0,\"\",masque!R155)","v":""},{"$f":"IF(masque!S155=0,\"\",masque!S155)","v":""},{"$f":"IF(masque!T155=0,\"\",masque!T155)","v":""}]
[null,{"$f":"masque!L156","v":"Entretien et Nettoyage des évaporateurs"},{"$f":"masque!M156","v":-2},{"$f":"masque!N156","v":2},"NA",{"$f":"masque!P156","v":2},{"$f":"IF(masque!Q156=0,\"\",masque!Q156)","v":""},{"$f":"IF(masque!R156=0,\"\",masque!R156)","v":""},{"$f":"IF(masque!S156=0,\"\",masque!S156)","v":""},{"$f":"IF(masque!T156=0,\"\",masque!T156)","v":""}]
[null,{"$f":"masque!L157","v":"Absence de produits non identifiés"},{"$f":"masque!M157","v":-5},{"$f":"masque!N157","v":2},{"$f":"masque!P157","v":2},"NA",{"$f":"IF(masque!Q157=0,\"\",masque!Q157)","v":""},{"$f":"IF(masque!R157=0,\"\",masque!R157)","v":""},{"$f":"IF(masque!S157=0,\"\",masque!S157)","v":""},{"$f":"IF(masque!T157=0,\"\",masque!T157)","v":""}]
[null,{"$f":"masque!L158","v":"Absence de palette en bois, de carton"},{"$f":"masque!M158","v":-1},{"$f":"masque!N158","v":1},{"$f":"masque!P158","v":1},"NA",{"$f":"IF(masque!Q158=0,\"\",masque!Q158)","v":""},{"$f":"IF(masque!R158=0,\"\",masque!R158)","v":""},{"$f":"IF(masque!S158=0,\"\",masque!S158)","v":""},{"$f":"IF(masque!T158=0,\"\",masque!T158)","v":""}]
[null,{"$f":"masque!L159","v":"Respect des DLC (crèmerie et ultra frais) "},{"$f":"masque!M159","v":-10},{"$f":"masque!N159","v":2},{"$f":"masque!P159","v":2},"NA",{"$f":"IF(masque!Q159=0,\"\",masque!Q159)","v":""},{"$f":"IF(masque!R159=0,\"\",masque!R159)","v":""},{"$f":"IF(masque!S159=0,\"\",masque!S159)","v":""},{"$f":"IF(masque!T159=0,\"\",masque!T159)","v":""}]
[null,{"$f":"masque!L160","v":"Respect des DLC (charcuterie) "},{"$f":"masque!M160","v":-10},{"$f":"masque!N160","v":2},{"$f":"masque!P160","v":2},"NA",{"$f":"IF(masque!Q160=0,\"\",masque!Q160)","v":""},{"$f":"IF(masque!R160=0,\"\",masque!R160)","v":""},{"$f":"IF(masque!S160=0,\"\",masque!S160)","v":""},{"$f":"IF(masque!T160=0,\"\",masque!T160)","v":""}]
[null,{"$f":"masque!L161","v":"Respect des DLC (Boucherie) "},{"$f":"masque!M161","v":-10},{"$f":"masque!N161","v":2},{"$f":"masque!P161","v":2},"NA",{"$f":"IF(masque!Q161=0,\"\",masque!Q161)","v":""},{"$f":"IF(masque!R161=0,\"\",masque!R161)","v":""},{"$f":"IF(masque!S161=0,\"\",masque!S161)","v":""},{"$f":"IF(masque!T161=0,\"\",masque!T161)","v":""}]
[null,{"$f":"masque!L162","v":"Respect des DLC/DLUO (viennoiserie industrielle) "},{"$f":"masque!M162","v":-10},{"$f":"masque!N162","v":2},{"$f":"masque!P162","v":2},"NA",{"$f":"IF(masque!Q162=0,\"\",masque!Q162)","v":""},{"$f":"IF(masque!R162=0,\"\",masque!R162)","v":""},{"$f":"IF(masque!S162=0,\"\",masque!S162)","v":""},{"$f":"IF(masque!T162=0,\"\",masque!T162)","v":""}]
[null,{"$f":"masque!L163","v":"Respect des températures réglementaires"},{"$f":"masque!M163","v":-2},{"$f":"masque!N163","v":2},"NA",{"$f":"masque!P163","v":2},{"$f":"IF(masque!Q163=0,\"\",masque!Q163)","v":""},{"$f":"IF(masque!R163=0,\"\",masque!R163)","v":""},{"$f":"IF(masque!S163=0,\"\",masque!S163)","v":""},{"$f":"IF(masque!T163=0,\"\",masque!T163)","v":""}]
[null,{"$f":"masque!L164","v":"Etiquetage conforme"},{"$f":"masque!M164","v":-2},{"$f":"masque!N164","v":2},{"$f":"masque!P164","v":2},"NA",{"$f":"IF(masque!Q164=0,\"\",masque!Q164)","v":""},{"$f":"IF(masque!R164=0,\"\",masque!R164)","v":""},{"$f":"IF(masque!S164=0,\"\",masque!S164)","v":""},{"$f":"IF(masque!T164=0,\"\",masque!T164)","v":""}]
[null,{"$f":"masque!L165","v":"Absence de charge excessive"},{"$f":"masque!M165","v":-1},{"$f":"masque!N165","v":1},{"$f":"masque!P165","v":1},"NA",{"$f":"IF(masque!Q165=0,\"\",masque!Q165)","v":""},{"$f":"IF(masque!R165=0,\"\",masque!R165)","v":""},{"$f":"IF(masque!S165=0,\"\",masque!S165)","v":""},{"$f":"IF(masque!T165=0,\"\",masque!T165)","v":""}]
[null,{"$f":"masque!L166","v":"Absence de stockage au sol"},{"$f":"masque!M166","v":-1},{"$f":"masque!N166","v":1},{"$f":"masque!P166","v":1},"NA",{"$f":"IF(masque!Q166=0,\"\",masque!Q166)","v":""},{"$f":"IF(masque!R166=0,\"\",masque!R166)","v":""},{"$f":"IF(masque!S166=0,\"\",masque!S166)","v":""},{"$f":"IF(masque!T166=0,\"\",masque!T166)","v":""}]
[null,{"$f":"masque!L167","v":"Aspect des produits satisfaisant."},{"$f":"masque!M167","v":-1},{"$f":"masque!N167","v":1},{"$f":"masque!P167","v":1},"NA",{"$f":"IF(masque!Q167=0,\"\",masque!Q167)","v":""},{"$f":"IF(masque!R167=0,\"\",masque!R167)","v":""},{"$f":"IF(masque!S167=0,\"\",masque!S167)","v":""},{"$f":"IF(masque!T167=0,\"\",masque!T167)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D24:D40)","v":28},{"$f":"SUM(E24:E40)","v":16},{"$f":"SUM(F24:F40)","v":5}]
[null,"LINEAIRE SURGELE"]
[null,{"$f":"masque!L168","v":"Absence d'attente hors froid"},{"$f":"masque!M168","v":-1},{"$f":"masque!N168","v":1},{"$f":"masque!P168","v":1},"NA",{"$f":"IF(masque!Q168=0,\"\",masque!Q168)","v":""},{"$f":"IF(masque!R168=0,\"\",masque!R168)","v":""},{"$f":"IF(masque!S168=0,\"\",masque!S168)","v":""},{"$f":"IF(masque!T168=0,\"\",masque!T168)","v":""}]
[null,{"$f":"masque!L169","v":"Propreté des meubles satisfaisants"},{"$f":"masque!M169","v":-5},{"$f":"masque!N169","v":2},{"$f":"masque!P169","v":2},"NA",{"$f":"IF(masque!Q169=0,\"\",masque!Q169)","v":""},{"$f":"IF(masque!R169=0,\"\",masque!R169)","v":""},{"$f":"IF(masque!S169=0,\"\",masque!S169)","v":""},{"$f":"IF(masque!T169=0,\"\",masque!T169)","v":""}]
[null,{"$f":"masque!L170","v":"entretien des meubles satisfaisants"},{"$f":"masque!M170","v":-5},{"$f":"masque!N170","v":2},"NA",{"$f":"masque!P170","v":2},{"$f":"IF(masque!Q170=0,\"\",masque!Q170)","v":""},{"$f":"IF(masque!R170=0,\"\",masque!R170)","v":""},{"$f":"IF(masque!S170=0,\"\",masque!S170)","v":""},{"$f":"IF(masque!T170=0,\"\",masque!T170)","v":""}]
[null,{"$f":"masque!L171","v":"Absence de charge excessive"},{"$f":"masque!M171","v":-1},{"$f":"masque!N171","v":1},{"$f":"masque!P171","v":1},"NA",{"$f":"IF(masque!Q171=0,\"\",masque!Q171)","v":""},{"$f":"IF(masque!R171=0,\"\",masque!R171)","v":""},{"$f":"IF(masque!S171=0,\"\",masque!S171)","v":""},{"$f":"IF(masque!T171=0,\"\",masque!T171)","v":""}]
[null,{"$f":"masque!L172","v":"Respect des DLC  (PLS) "},{"$f":"masque!M172","v":-10},{"$f":"masque!N172","v":2},{"$f":"masque!P172","v":2},"NA",{"$f":"IF(masque!Q172=0,\"\",masque!Q172)","v":""},{"$f":"IF(masque!R172=0,\"\",masque!R172)","v":""},{"$f":"IF(masque!S172=0,\"\",masque!S172)","v":""},{"$f":"IF(masque!T172=0,\"\",masque!T172)","v":""}]
[null,{"$f":"masque!L173","v":"Respect des DLC (Boucherie) "},{"$f":"masque!M173","v":-10},{"$f":"masque!N173","v":2},{"$f":"masque!P173","v":2},"NA",{"$f":"IF(masque!Q173=0,\"\",masque!Q173)","v":""},{"$f":"IF(masque!R173=0,\"\",masque!R173)","v":""},{"$f":"IF(masque!S173=0,\"\",masque!S173)","v":""},{"$f":"IF(masque!T173=0,\"\",masque!T173)","v":""}]
[null,{"$f":"masque!L174","v":"Température  adaptée (-18°C)"},{"$f":"masque!M174","v":-2},{"$f":"masque!N174","v":2},"NA",{"$f":"masque!P174","v":2},{"$f":"IF(masque!Q174=0,\"\",masque!Q174)","v":""},{"$f":"IF(masque!R174=0,\"\",masque!R174)","v":""},{"$f":"IF(masque!S174=0,\"\",masque!S174)","v":""},{"$f":"IF(masque!T174=0,\"\",masque!T174)","v":""}]
[null,{"$f":"masque!L175","v":"Aspect satisfaisant des produits"},{"$f":"masque!M175","v":-1},{"$f":"masque!N175","v":1},{"$f":"masque!P175","v":1},"NA",{"$f":"IF(masque!Q175=0,\"\",masque!Q175)","v":""},{"$f":"IF(masque!R175=0,\"\",masque!R175)","v":""},{"$f":"IF(masque!S175=0,\"\",masque!S175)","v":""},{"$f":"IF(masque!T175=0,\"\",masque!T175)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D43:D50)","v":13},{"$f":"SUM(E43:E50)","v":9},{"$f":"SUM(F43:F50)","v":4}]
[]
[22,"AUTOCONTROLES"]
[221,{"$f":"masque!L176","v":"Présence du référentiel qualité"},{"$f":"masque!M176","v":-2},{"$f":"masque!N176","v":2},{"$f":"masque!P176","v":2},"NA",{"$f":"IF(masque!Q176=0,\"\",masque!Q176)","v":""},{"$f":"IF(masque!R176=0,\"\",masque!R176)","v":""},{"$f":"IF(masque!S176=0,\"\",masque!S176)","v":""},{"$f":"IF(masque!T176=0,\"\",masque!T176)","v":""}]
["222b",{"$f":"masque!L177","v":"Mise en place des autocontrôles des températures"},{"$f":"masque!M177","v":-5},{"$f":"masque!N177","v":5},{"$f":"masque!P177","v":5},"NA",{"$f":"IF(masque!Q177=0,\"\",masque!Q177)","v":""},{"$f":"IF(masque!R177=0,\"\",masque!R177)","v":""},{"$f":"IF(masque!S177=0,\"\",masque!S177)","v":""},{"$f":"IF(masque!T177=0,\"\",masque!T177)","v":""}]
["222c",{"$f":"masque!L178","v":"Mise en place des auto-contrôles du nettoyage"},{"$f":"masque!M178","v":-2},{"$f":"masque!N178","v":2},{"$f":"masque!P178","v":2},"NA",{"$f":"IF(masque!Q178=0,\"\",masque!Q178)","v":""},{"$f":"IF(masque!R178=0,\"\",masque!R178)","v":""},{"$f":"IF(masque!S178=0,\"\",masque!S178)","v":""},{"$f":"IF(masque!T178=0,\"\",masque!T178)","v":""}]
[null,{"$f":"masque!L179","v":"Les résultats d'audits externes sont affichés au pole"},{"$f":"masque!M179","v":-1},{"$f":"masque!N179","v":1},{"$f":"masque!P179","v":1},"NA",{"$f":"IF(masque!Q179=0,\"\",masque!Q179)","v":""},{"$f":"IF(masque!R179=0,\"\",masque!R179)","v":""},{"$f":"IF(masque!S179=0,\"\",masque!S179)","v":""},{"$f":"IF(masque!T179=0,\"\",masque!T179)","v":""}]
[null,{"$f":"masque!L180","v":"Mise en place de Plan d'action suite aux audits"},{"$f":"masque!M180","v":-1},{"$f":"masque!N180","v":1},{"$f":"masque!P180","v":"NA"},"NA",{"$f":"IF(masque!Q180=0,\"\",masque!Q180)","v":""},{"$f":"IF(masque!R180=0,\"\",masque!R180)","v":""},{"$f":"IF(masque!S180=0,\"\",masque!S180)","v":""},{"$f":"IF(masque!T180=0,\"\",masque!T180)","v":""}]
[223,{"$f":"masque!L181","v":"Mise en place d'actions correctives suite aux analyses non conformes (surgelés)"},{"$f":"masque!M181","v":-2},{"$f":"masque!N181","v":2},{"$f":"masque!P181","v":2},"NA",{"$f":"IF(masque!Q181=0,\"\",masque!Q181)","v":""},{"$f":"IF(masque!R181=0,\"\",masque!R181)","v":""},{"$f":"IF(masque!S181=0,\"\",masque!S181)","v":""},{"$f":"IF(masque!T181=0,\"\",masque!T181)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D54:D59)","v":13},{"$f":"SUM(E54:E59)","v":12},{"$f":"SUM(F54:F59)","v":0}]
[null,null,"Max",{"$f":"E61+F61","v":59},{"$f":"masque!Q7","v":45},{"$f":"masque!R7","v":14}]
[null,null,null,null,"Note F","Note T"]
[null,"TOTAL  : ",null,null,{"$f":"SUM(E60,E51,E41,E22,E18)","v":39},{"$f":"SUM(F60,F51,F41,F22,F18)","v":9}]
[null,"NOTE : ",null,"/100",{"$f":"IF(E61=0,\"\",E63/E61)","v":0.8666666666666667},{"$f":"IF(F61=0,\"\",F63/F61)","v":0.6428571428571429}]
[null,null,null,null,{"$f":"IF(D61=0,\"\",(E63+F63)/D61)","v":0.81355932203389836}]

{"sheet":"technique","index":14,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,4,42,5]]}
[{"$f":"\"Accompagné par :  \" &masque!K10","v":"Accompagné par :  aymen Salah"},null,null,"SERVICE TECHNIQUE",null,null,null,"TEC"]
[null,null,null,null,"Visite "]
[null,null,null,"Visite",{"$f":"masque!$E$11","v":"V2"}]
[null,null,null,"Date",{"$f":"masque!$E$12","v":"2017-06-14"}]
[null,null,null,"Heure"]
[null,null,"Pénalités","Base",null,null,"Non-conformité","Action corrective","Fixé le","Responsable"]
[6,"MAITRISE DU FROID",null,null,"F","T"]
["62c",{"$f":"masque!L208","v":"Présence / bon fonctionnement thermoenregistreurs pole Poisson"},{"$f":"masque!M208","v":-1},{"$f":"masque!N208","v":1},"NA",{"$f":"masque!P208","v":1},{"$f":"IF(masque!Q208=0,\"\",masque!Q208)","v":""},{"$f":"IF(masque!R208=0,\"\",masque!R208)","v":""},{"$f":"IF(masque!S208=0,\"\",masque!S208)","v":""},{"$f":"IF(masque!T208=0,\"\",masque!T208)","v":""}]
["62f",{"$f":"masque!L209","v":"Présence / bon fonctionnement thermoenregistreurs pole Fruits et Légumes"},{"$f":"masque!M209","v":-1},{"$f":"masque!N209","v":1},"NA",{"$f":"masque!P209","v":1},{"$f":"IF(masque!Q209=0,\"\",masque!Q209)","v":""},{"$f":"IF(masque!R209=0,\"\",masque!R209)","v":""},{"$f":"IF(masque!S209=0,\"\",masque!S209)","v":""},{"$f":"IF(masque!T209=0,\"\",masque!T209)","v":""}]
["62j",{"$f":"masque!L210","v":"Présence / bon fonctionnement thermoenregistreurs pole PLS/boucherie"},{"$f":"masque!M210","v":-1},{"$f":"masque!N210","v":1},"NA",{"$f":"masque!P210","v":0},{"$f":"IF(masque!Q210=0,\"\",masque!Q210)","v":"La GTC est en panne."},{"$f":"IF(masque!R210=0,\"\",masque!R210)","v":"Réparer la GTC."},{"$f":"IF(masque!S210=0,\"\",masque!S210)","v":""},{"$f":"IF(masque!T210=0,\"\",masque!T210)","v":""}]
[null,{"$f":"masque!L211","v":"Présence / bon fonctionnement thermoenregistreurs réserves froides PLS"},{"$f":"masque!M211","v":-1},{"$f":"masque!N211","v":1},"NA",{"$f":"masque!P211","v":1},{"$f":"IF(masque!Q211=0,\"\",masque!Q211)","v":""},{"$f":"IF(masque!R211=0,\"\",masque!R211)","v":""},{"$f":"IF(masque!S211=0,\"\",masque!S211)","v":""},{"$f":"IF(masque!T211=0,\"\",masque!T211)","v":""}]
[64,{"$f":"masque!L212","v":"Présence et bon état des joints  porte ch froide"},{"$f":"masque!M212","v":-1},{"$f":"masque!N212","v":1},"NA",{"$f":"masque!P212","v":"Nobs"},{"$f":"IF(masque!Q212=0,\"\",masque!Q212)","v":""},{"$f":"IF(masque!R212=0,\"\",masque!R212)","v":""},{"$f":"IF(masque!S212=0,\"\",masque!S212)","v":""},{"$f":"IF(masque!T212=0,\"\",masque!T212)","v":""}]
[66,{"$f":"masque!L213","v":"Positionnement de la sonde extérieure des meubles surgelés conforme"},{"$f":"masque!M213","v":-1},{"$f":"masque!N213","v":1},"NA",{"$f":"masque!P213","v":1},{"$f":"IF(masque!Q213=0,\"\",masque!Q213)","v":""},{"$f":"IF(masque!R213=0,\"\",masque!R213)","v":""},{"$f":"IF(masque!S213=0,\"\",masque!S213)","v":""},{"$f":"IF(masque!T213=0,\"\",masque!T213)","v":""}]
["0611a",{"$f":"masque!L214","v":"Absence de thermomètre en panne sur les linéaires surgelés"},{"$f":"masque!M214","v":-1},{"$f":"masque!N214","v":1},"NA",{"$f":"masque!P214","v":1},{"$f":"IF(masque!Q214=0,\"\",masque!Q214)","v":""},{"$f":"IF(masque!R214=0,\"\",masque!R214)","v":""},{"$f":"IF(masque!S214=0,\"\",masque!S214)","v":""},{"$f":"IF(masque!T214=0,\"\",masque!T214)","v":""}]
["0611j",{"$f":"masque!L215","v":"gestion des alarmes du froid "},{"$f":"masque!M215","v":-1},{"$f":"masque!N215","v":1},"NA",{"$f":"masque!P215","v":1},{"$f":"IF(masque!Q215=0,\"\",masque!Q215)","v":""},{"$f":"IF(masque!R215=0,\"\",masque!R215)","v":""},{"$f":"IF(masque!S215=0,\"\",masque!S215)","v":""},{"$f":"IF(masque!T215=0,\"\",masque!T215)","v":""}]
["0612",{"$f":"masque!L216","v":"Absence de fuite de fluide frigorigène"},{"$f":"masque!M216","v":-1},{"$f":"masque!N216","v":1},"NA",{"$f":"masque!P216","v":0},{"$f":"IF(masque!Q216=0,\"\",masque!Q216)","v":"Absence de DEIV dans tout le magasin."},{"$f":"IF(masque!R216=0,\"\",masque!R216)","v":"Prévoir des DEIV au magasin."},{"$f":"IF(masque!S216=0,\"\",masque!S216)","v":""},{"$f":"IF(masque!T216=0,\"\",masque!T216)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D8:D16)","v":9},{"$f":"SUM(E8:E16)","v":0},{"$f":"SUM(F8:F16)","v":6}]
[7,"MAINTENANCE GENERALE"]
[70,{"$f":"masque!L217","v":"Présence d'un poste de nettoyage désinfection au niveau de la réception"},{"$f":"masque!M217","v":-5},{"$f":"masque!N217","v":2},"NA",{"$f":"masque!P217","v":-3},{"$f":"IF(masque!Q217=0,\"\",masque!Q217)","v":"Absence d'un local poubelle."},{"$f":"IF(masque!R217=0,\"\",masque!R217)","v":"Prévoir un local adapté pour l'entreposage des poubelles "},{"$f":"IF(masque!S217=0,\"\",masque!S217)","v":""},{"$f":"IF(masque!T217=0,\"\",masque!T217)","v":""}]
[71,{"$f":"masque!L218","v":"Entretien des écoulements / évacuations satisfaisant"},{"$f":"masque!M218","v":-2},{"$f":"masque!N218","v":2},"NA",{"$f":"masque!P218","v":2},{"$f":"IF(masque!Q218=0,\"\",masque!Q218)","v":""},{"$f":"IF(masque!R218=0,\"\",masque!R218)","v":""},{"$f":"IF(masque!S218=0,\"\",masque!S218)","v":""},{"$f":"IF(masque!T218=0,\"\",masque!T218)","v":""}]
["73c",{"$f":"masque!L219","v":"Maintenance satisfaisante des meubles (concerne état général, rouille...) "},{"$f":"masque!M219","v":-1},{"$f":"masque!N219","v":1},"NA",{"$f":"masque!P219","v":0},{"$f":"IF(masque!Q219=0,\"\",masque!Q219)","v":"Présence de fuite au niveau du bac de la poissonnerie"},{"$f":"IF(masque!R219=0,\"\",masque!R219)","v":"Réparer la fuite d'eau."},{"$f":"IF(masque!S219=0,\"\",masque!S219)","v":""},{"$f":"IF(masque!T219=0,\"\",masque!T219)","v":"aymen Salah"}]
["75b",{"$f":"masque!L220","v":"Maintenance et propreté satisfaisantes des évaporateurs et ventilateurs"},{"$f":"masque!M220","v":-1},{"$f":"masque!N220","v":1},"NA",{"$f":"masque!P220","v":0},{"$f":"IF(masque!Q220=0,\"\",masque!Q220)","v":"Absence d'un planning de maintenance préventive: technique /nettoyage"},{"$f":"IF(masque!R220=0,\"\",masque!R220)","v":"Etablir un planning de maintenance préventive: Nettoyage "},{"$f":"IF(masque!S220=0,\"\",masque!S220)","v":""},{"$f":"IF(masque!T220=0,\"\",masque!T220)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D19:D22)","v":6},{"$f":"SUM(E19:E22)","v":0},{"$f":"SUM(F19:F22)","v":-1}]
["Accompagné par : ",null,null,"SERVICE TECHNIQUE"]
[null,null,null,"Visite",{"$f":"+E3","v":"V2"}]
[null,null,null,"Date","V4B"]
[null,null,null,"Heure",{"$f":"E5","v":"00:00:00"}]
[null,null,"Pénalités","Base"]
["08.","AUTRES"]
["81a",{"$f":"masque!L221","v":"Présence du plan de positionnement des appats raticides (emplacement et nombre)"},{"$f":"masque!M221","v":-2},{"$f":"masque!N221","v":2},"NA",{"$f":"masque!P221","v":2},{"$f":"IF(masque!Q221=0,\"\",masque!Q221)","v":""},{"$f":"IF(masque!R221=0,\"\",masque!R221)","v":""},{"$f":"IF(masque!S221=0,\"\",masque!S221)","v":""},{"$f":"IF(masque!T221=0,\"\",masque!T221)","v":""}]
["81b",{"$f":"masque!L222","v":"Présence du local poubelle"},{"$f":"masque!M222","v":-2},{"$f":"masque!N222","v":2},"NA",{"$f":"masque!P222","v":0},{"$f":"IF(masque!Q222=0,\"\",masque!Q222)","v":"Les poubelles sont à l'air libre"},{"$f":"IF(masque!R222=0,\"\",masque!R222)","v":"prévoir un local climatisé et équipé d'une source d'eau chaude et froide"},{"$f":"IF(masque!S222=0,\"\",masque!S222)","v":41702},{"$f":"IF(masque!T222=0,\"\",masque!T222)","v":"aymen Salah"}]
["81f",{"$f":"masque!L223","v":"bon fonctionnement des lave-mains"},{"$f":"masque!M223","v":-1},{"$f":"masque!N223","v":1},"NA",{"$f":"masque!P223","v":0},{"$f":"IF(masque!Q223=0,\"\",masque!Q223)","v":"2 lave main non fonctionnel en vestiaire femme,  Absence des distributeurs savon liquide et papier hygiénique au niveau du poste lave-mains du poissonnerie"},{"$f":"IF(masque!R223=0,\"\",masque!R223)","v":"reparer les lave mains et prevoir les ditributeurs"},{"$f":"IF(masque!S223=0,\"\",masque!S223)","v":42667},{"$f":"IF(masque!T223=0,\"\",masque!T223)","v":"aymen Salah"}]
["81g",{"$f":"masque!L224","v":"Absence de fuite d'eau"},{"$f":"masque!M224","v":-1},{"$f":"masque!N224","v":1},"NA",{"$f":"masque!P224","v":1},{"$f":"IF(masque!Q224=0,\"\",masque!Q224)","v":""},{"$f":"IF(masque!R224=0,\"\",masque!R224)","v":""},{"$f":"IF(masque!S224=0,\"\",masque!S224)","v":""},{"$f":"IF(masque!T224=0,\"\",masque!T224)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D30:D33)","v":6},{"$f":"SUM(E30:E33)","v":0},{"$f":"SUM(F30:F33)","v":3}]
[9,"GESTION DOCUMENTAIRE"]
["91a",{"$f":"masque!L225","v":"Existence d'un planning de maintenance préventive technique et Nettoyage"},{"$f":"masque!M225","v":-1},{"$f":"masque!N225","v":1},"NA",{"$f":"masque!P225","v":1},{"$f":"IF(masque!Q225=0,\"\",masque!Q225)","v":"z"},{"$f":"IF(masque!R225=0,\"\",masque!R225)","v":""},{"$f":"IF(masque!S225=0,\"\",masque!S225)","v":""},{"$f":"IF(masque!T225=0,\"\",masque!T225)","v":""}]
["91c",{"$f":"masque!L226","v":"Existence d'un planning de maintenance préventive:dératisation-désinsectisation"},{"$f":"masque!M226","v":-1},{"$f":"masque!N226","v":1},"NA",{"$f":"masque!P226","v":0},{"$f":"IF(masque!Q226=0,\"\",masque!Q226)","v":"Présence de jour important sous la porte de livraison, ceci favorise l’accès des nuisibles"},{"$f":"IF(masque!R226=0,\"\",masque!R226)","v":"fermer cette ouverture sous la porte"},{"$f":"IF(masque!S226=0,\"\",masque!S226)","v":42696},{"$f":"IF(masque!T226=0,\"\",masque!T226)","v":""}]
[null,"Sous Total :",null,{"$f":"SUM(D36:D37)","v":2},{"$f":"SUM(E36:E37)","v":0},{"$f":"SUM(F36:F37)","v":1}]
[null,null,"Max",{"$f":"E39+F39","v":22},{"$f":"masque!Q10","v":0},{"$f":"masque!R10","v":22}]
[null,null,null,null,"Note F","Note T"]
[null,"TOTAL  : ",null,null,{"$f":"SUM(E17,E23,E34,E38)","v":0},{"$f":"SUM(F17,F23,F34,F38)","v":9}]
[null,"NOTE : ",null,"/100",{"$f":"IF(E39=0,\"\",E41/E39)","v":""},{"$f":"IF(F39=0,\"\",F41/F39)","v":0.40909090909090912}]
[null,null,null,null,{"$f":"IF(D39=0,\"\",(E41+F41)/D39)","v":0.40909090909090912}]

{"sheet":"liste","index":15,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Visite",{"$f":"MATCH(masque!E11,listvisit)","v":2},{"$f":"IF(B1=1,2,1)","v":1},{"$f":"C1+1","v":2},{"$f":"D1+1","v":3},5]
["V1"]
["V2"]
["V3"]
["V4"]
["V5"]