{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Quotats","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","infos"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Quotats","index":0,"n_rows":47,"n_cols":29,"rows_kept":47,"cut":false,"hidden":true,"merged":[[21,0,25,0],[27,0,30,0],[31,0,34,0],[2,28,2,29],[3,28,3,29],[4,28,4,29],[5,28,5,29],[11,0,15,0],[9,2,9,4],[16,0,20,0],[35,0,38,0],[47,0,50,0],[39,0,42,0],[51,0,54,0],[43,0,46,0]]}
["Jour","VILLETTE","BEDIER","MENILMONTANT","MARAUDE 93","MARAUDE 75","DENFERT","NATION","ST LAZARE","GARE DE L'EST","SALPETRIERE","INVALIDES","REPUBLIQUE","R. LENOIR","SAINT-OUEN","MENILMONTANT SOIR","ST ROCH",null,"Nb/soir","Quotas/soir",null,"Nb/midi","Quotas/midi",null,"Nb m/m","Quotas m/midi"]
["Lundi",170,400,600,600,20,160,200,200,300,50,null,null,null,null,90,90,null,{"$f":"COUNT(G2:Q2)","v":7},{"$f":"SUM(G2:Q2)","v":1090},null,{"$f":"COUNT(B2:D2)","v":3},{"$f":"SUM(B2:D2)","v":1170},null,{"$f":"COUNT(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":2},{"$f":"SUM(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":620}]
["Mardi",170,400,650,600,20,140,null,null,null,null,210,280,130,120,90,90,null,7,1060,null,3,1220,null,{"$f":"COUNT(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":2},{"$f":"SUM(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":620},65535,{"$f":"SOMME_SI_COULEUR(Tableau1[[VILLETTE]:[ST ROCH]])","v":520},"EXCELLENT EXCEDENTS"]
["Mercredi",170,400,650,600,20,220,280,210,350,null,null,null,null,150,75,80,null,7,1365,null,3,1220,null,{"$f":"COUNT(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":2},{"$f":"SUM(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":620},15773696,{"$f":"SOMME_SI_COULEUR(Tableau1[[VILLETTE]:[ST ROCH]])","v":1050},"MENUS SANS VIANDE"]
["Jeudi",170,400,650,600,20,null,null,null,null,65,220,300,190,180,90,85,null,7,1130,null,3,1220,null,{"$f":"COUNT(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":2},{"$f":"SUM(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":620},5287936,{"$f":"SOMME_SI_COULEUR(Tableau1[[VILLETTE]:[ST ROCH]])","v":4825},"SUBSTITUTION"]
["Vendredi",170,400,650,1200,20,250,160,180,400,null,null,null,null,250,80,85,null,7,1405,null,3,1220,null,{"$f":"COUNT(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":2},{"$f":"SUM(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":1220},49407,{"$f":"SOMME_SI_COULEUR(Tableau1[[VILLETTE]:[ST ROCH]])","v":8410},"SOGERES"]
["Samedi",null,null,null,null,null,null,null,null,null,null,220,400,150,null,75,80,null,5,925,null,0,0,null,{"$f":"COUNT(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":0},{"$f":"SUM(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":0}]
["Dimanche",null,null,null,null,null,200,null,null,500,null,220,null,null,null,80,100,null,5,1100,null,0,0,null,{"$f":"COUNT(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":0},{"$f":"SUM(Tableau1[[#This Row],[MARAUDE 93]:[MARAUDE 75]])","v":0}]
[]
[null,null,"SOGERES"]
[null,null,"Midi","Soir","Sans viande","EXCELLENT EXCEDENTS","Substitution"]
["Lundi","Protéine","Veau","Poisson","Thon","Agneau","Steack"]
[null,"Conditionnement protéine",6,4,4,6,4]
[null,"Quantité indiquée"]
[null,"Accompagnement","Riz","purée","Riz","purée","Riz"]
[null,"Conditionnement accompagnement",6,4,4,4,4]
["Lundi","Café"]
[null,"Soupe"]
[null,"Lait"]
[null,"Eau Chaude"]
[null,"Eau Froide"]
["Mardi","Protéine","Veau","Poisson","HOKI"]
[null,"Conditionnement protéine",6,4,10]
[]
[null,"Accompagnement","Riz","purée","PATE"]
[null,"Conditionnement accompagnement",6,3,6]
[]
["Mercredi","Protéine","Veau","Poisson","COLIN ALASKA "]
[null,"Conditionnement protéine",6,4,6]
[null,"Accompagnement","Riz","purée","H.VERT"]
[null,"Conditionnement accompagnement",6,3,5]
["Jeudi","Protéine","Veau","Poisson"]
[null,"Conditionnement protéine",6,4]
[null,"Accompagnement","Riz","purée"]
[null,"Conditionnement accompagnement",6,3]
["Vendredi","Protéine","Veau","Poisson",null,null,null,null,null,"Mardi","INVALIDES","REPUBLIQUE","DENFERT","R. LENOIR","SOLEIL","ST ROCH","LA CHAPELLE","MARAUDE 93"]
[null,"Conditionnement protéine",6,4,null,null,null,null,null,"Mercredi","NATION","DENFERT","ST LAZARE","G. L'EST","SOLEIL","ST ROCH","LA CHAPELLE","MARAUDE 93"]
[null,"Accompagnement","Riz","purée",null,null,null,null,null,"Jeudi","INVALIDES","REPUBLIQUE","SALPETRIERE","R. LENOIR","SOLEIL","ST ROCH","LA CHAPELLE","MARAUDE 93"]
[null,"Conditionnement accompagnement",6,3,null,null,null,null,null,"Vendredi","NATION","DENFERT","ST LAZARE","G. DE L'EST","SOLEIL","ST ROCH","LA CHAPELLE","MARAUDE 93"]
["Samedi","Protéine","Veau","Poisson",null,null,null,null,null,"Samedi","INVALIDES","REPUBLIQUE","R. LENOIR","SOLEIL","ST ROCH","MARAUDE 93"]
[null,"Conditionnement protéine",6,4,null,null,null,null,null,"Dimanche","INVALIDES","DENFERT","G. L'EST","SOLEIL","ST ROCH"]
[null,"Accompagnement","Riz","purée"]
[null,"Conditionnement accompagnement",6,3]
["Dimanche","Protéine","Veau","Poisson"]
[null,"Conditionnement protéine",6,4]
[null,"Accompagnement","Riz","purée"]
[null,"Conditionnement accompagnement",6,3]

{"sheet":"Lundi","index":1,"n_rows":230,"n_cols":18,"rows_kept":230,"cut":false,"hidden":false,"merged":[[8,0,8,4],[8,7,8,11],[140,2,169,2],[170,2,197,2],[43,0,45,0],[47,0,49,0],[50,0,52,0],[53,0,55,0],[56,0,58,0],[59,0,61,0],[62,0,64,0],[198,2,217,2],[218,2,229,2],[16,0,18,0],[19,0,21,0],[22,0,24,0],[25,0,27,0],[28,0,30,0],[31,0,33,0],[34,0,36,0],[37,0,39,0],[40,0,42,0],[80,0,82,0],[83,0,85,0],[65,0,67,0],[68,0,70,0],[71,0,73,0],[74,0,76,0],[77,0,79,0]]}
[null,{"$f":"Quotats!B1","v":"VILLETTE"},{"$f":"Quotats!C1","v":"BEDIER"},{"$f":"Quotats!D1","v":"MENILMONTANT"},{"$f":"Quotats!E1","v":"MARAUDE 93"},{"$f":"Quotats!F1","v":"MARAUDE 75"},null,{"$f":"Quotats!G1","v":"DENFERT"},{"$f":"Quotats!H1","v":"NATION"},{"$f":"Quotats!I1","v":"ST LAZARE"},{"$f":"Quotats!J1","v":"GARE DE L'EST"},{"$f":"Quotats!K1","v":"SALPETRIERE"},{"$f":"Quotats!L1","v":"INVALIDES"},{"$f":"Quotats!M1","v":"REPUBLIQUE"},{"$f":"Quotats!N1","v":"R. LENOIR"},{"$f":"Quotats!O1","v":"SAINT-OUEN"},{"$f":"Quotats!P1","v":"MENILMONTANT SOIR"},{"$f":"Quotats!Q1","v":"ST ROCH"}]
["Lundi",{"$f":"Quotats!B2","v":170},{"$f":"Quotats!C2","v":400},{"$f":"Quotats!D2","v":600},{"$f":"Quotats!E2","v":600},{"$f":"Quotats!F2","v":20},null,{"$f":"Quotats!G2","v":160},{"$f":"Quotats!H2","v":200},{"$f":"Quotats!I2","v":200},{"$f":"Quotats!J2","v":300},{"$f":"Quotats!K2","v":50},{"$f":"Quotats!L2","v":0},{"$f":"Quotats!M2","v":0},{"$f":"Quotats!N2","v":0},{"$f":"Quotats!O2","v":0},{"$f":"Quotats!P2","v":90},{"$f":"Quotats!Q2","v":90}]
["Choix menu","Midi","Midi","Midi","Substitution","Substitution",null,"Substitution","Substitution","Sans viande","Sans viande","Substitution","Subsitution","Subsitution","Subsitution","Subsitution","Soir","EXCELLENT EXCEDENTS"]
["Nb barquettes",{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(B$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(B$3,Quotats!$C$11:$G$11,0)),0)","v":29},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(C$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(C$3,Quotats!$C$11:$G$11,0)),0)","v":67},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(D$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(D$3,Quotats!$C$11:$G$11,0)),0)","v":100},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(E$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(E$3,Quotats!$C$11:$G$11,0)),0)","v":150},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(F$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(F$3,Quotats!$C$11:$G$11,0)),0)","v":5},null,{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(H$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(H$3,Quotats!$C$11:$G$11,0)),0)","v":40},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(I$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(I$3,Quotats!$C$11:$G$11,0)),0)","v":50},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(J$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(J$3,Quotats!$C$11:$G$11,0)),0)","v":50},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(K$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(K$3,Quotats!$C$11:$G$11,0)),0)","v":75},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(L$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(L$3,Quotats!$C$11:$G$11,0)),0)","v":13},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(M$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(M$3,Quotats!$C$11:$G$11,0)),0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(N$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(N$3,Quotats!$C$11:$G$11,0)),0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(O$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(O$3,Quotats!$C$11:$G$11,0)),0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(P$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(P$3,Quotats!$C$11:$G$11,0)),0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(Q$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(Q$3,Quotats!$C$11:$G$11,0)),0)","v":23},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(R$1,$B$1:$R$1,0))/INDEX(Quotats!$C$16:$G$16,MATCH(R$3,Quotats!$C$11:$G$11,0)),0)","v":23}]
["accompagnement",{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!B3,Quotats!$C$11:$G$11,0))","v":"Riz"},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!C3,Quotats!$C$11:$G$11,0))","v":"Riz"},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!D3,Quotats!$C$11:$G$11,0))","v":"Riz"},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!E3,Quotats!$C$11:$G$11,0))","v":"Riz"},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!F3,Quotats!$C$11:$G$11,0))","v":"Riz"},null,{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!H3,Quotats!$C$11:$G$11,0))","v":"Riz"},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!I3,Quotats!$C$11:$G$11,0))","v":"Riz"},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!J3,Quotats!$C$11:$G$11,0))","v":"Riz"},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!K3,Quotats!$C$11:$G$11,0))","v":"Riz"},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!L3,Quotats!$C$11:$G$11,0))","v":"Riz"},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!M3,Quotats!$C$11:$G$11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!N3,Quotats!$C$11:$G$11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!O3,Quotats!$C$11:$G$11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!P3,Quotats!$C$11:$G$11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!Q3,Quotats!$C$11:$G$11,0))","v":"purée"},{"$f":"INDEX(Quotats!$C$15:$G$15,MATCH(Lundi!R3,Quotats!$C$11:$G$11,0))","v":"purée"}]
["Nb barquettes ",{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(B$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(B$3,Quotats!$C$11:$G$11,0)),0)","v":29},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(C$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(C$3,Quotats!$C$11:$G$11,0)),0)","v":67},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(D$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(D$3,Quotats!$C$11:$G$11,0)),0)","v":100},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(E$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(E$3,Quotats!$C$11:$G$11,0)),0)","v":150},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(F$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(F$3,Quotats!$C$11:$G$11,0)),0)","v":5},null,{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(H$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(H$3,Quotats!$C$11:$G$11,0)),0)","v":40},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(I$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(I$3,Quotats!$C$11:$G$11,0)),0)","v":50},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(J$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(J$3,Quotats!$C$11:$G$11,0)),0)","v":50},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(K$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(K$3,Quotats!$C$11:$G$11,0)),0)","v":75},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(L$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(L$3,Quotats!$C$11:$G$11,0)),0)","v":13},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(M$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(M$3,Quotats!$C$11:$G$11,0)),0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(N$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(N$3,Quotats!$C$11:$G$11,0)),0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(O$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(O$3,Quotats!$C$11:$G$11,0)),0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(P$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(P$3,Quotats!$C$11:$G$11,0)),0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(Q$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(Q$3,Quotats!$C$11:$G$11,0)),0)","v":23},{"$f":"ROUNDUP(INDEX($B$2:$R$2,MATCH(R$1,$B$1:$R$1,0))/INDEX(Quotats!$C$13:$G$13,MATCH(R$3,Quotats!$C$11:$G$11,0)),0)","v":15}]
["protéine",{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!B3,Quotats!$C$11:$G$11,0))","v":"Veau"},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!C3,Quotats!$C$11:$G$11,0))","v":"Veau"},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!D3,Quotats!$C$11:$G$11,0))","v":"Veau"},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!E3,Quotats!$C$11:$G$11,0))","v":"Steack"},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!F3,Quotats!$C$11:$G$11,0))","v":"Steack"},null,{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!H3,Quotats!$C$11:$G$11,0))","v":"Steack"},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!I3,Quotats!$C$11:$G$11,0))","v":"Steack"},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!J3,Quotats!$C$11:$G$11,0))","v":"Thon"},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!K3,Quotats!$C$11:$G$11,0))","v":"Thon"},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!L3,Quotats!$C$11:$G$11,0))","v":"Steack"},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!M3,Quotats!$C$11:$G$11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!N3,Quotats!$C$11:$G$11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!O3,Quotats!$C$11:$G$11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!P3,Quotats!$C$11:$G$11,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!Q3,Quotats!$C$11:$G$11,0))","v":"Poisson"},{"$f":"INDEX(Quotats!$C$12:$G$12,MATCH(Lundi!R3,Quotats!$C$11:$G$11,0))","v":"Agneau"}]
[]
["MIDI",null,null,null,null,null,null,"SOIR"]
["TOTAL COMMANDÉ",{"$f":"SUMIF($B$3:$F$3,\"Midi\",$B$2:$F$2)+SUMIF($B$3:$F$3,\"Soir\",$B$2:$F$2)","v":1170},{"$f":"SUMIF($B$3:$F$3,\"Substitution\",$B$2:$F$2)","v":620},{"$f":"SUMIF($B$3:$F$3,\"Sans viande\",$B$2:$F$2)","v":0},{"$f":"SUMIF($B$3:$F$3,\"EXCEDENT EXCELLENTS\",$B$2:$F$2)","v":0},null,null,"TOTAL COMMANDÉ",{"$f":"SUMIF($H$3:$R$3,\"Midi\",$H$2:$R$2)+SUMIF($H$3:$R$3,\"Soir\",$H$2:$R$2)","v":90},{"$f":"SUMIF($H$3:$R$3,\"Substitution\",$H$2:$R$2)","v":410},{"$f":"SUMIF($H$3:$R$3,\"Sans viande\",$H$2:$R$2)","v":500},{"$f":"SUMIF($H$3:$R$3,\"EXCELLENT EXCEDENTS\",$H$2:$R$2)","v":90}]
["TOTAL FAIT",null,null,null,null,null,null,"TOTAL FAIT"]
["TOTAL À FAIRE",{"$f":"IF(B10-B11>0,B10-B11,0)","v":1170},{"$f":"IF(C10-C11>0,C10-C11,0)","v":620},0,0,null,null,"TOTAL À FAIRE",{"$f":"IF(I10-I11>0,I10-I11,0)","v":90},{"$f":"IF(J10-J11>0,J10-J11,0)","v":410},{"$f":"IF(K10-K11>0,K10-K11,0)","v":500},{"$f":"IF(L10-L11>0,L10-L11,0)","v":90}]
["TOTAL RESTE ",{"$f":"IF(B10-B11>0,0,B11-B10)","v":0},{"$f":"IF(C10-C11>0,0,C11-C10)","v":0},0,0,null,null,"TOTAL RESTE ",{"$f":"IF(I10-I11>0,0,I11-I10)","v":0},{"$f":"IF(J10-J11>0,0,J11-J10)","v":0},0,0]
[]
["Nb max par contenairs","Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine",null,"Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine","Nb contenairs pleins protéine"]
[18,{"$f":"INT(B$6/$A$16)","v":1},{"$f":"INT(C$6/$A$16)","v":3},{"$f":"INT(D$6/$A$16)","v":5},{"$f":"INT(E$6/$A$16)","v":8},{"$f":"INT(F$6/$A$16)","v":0},null,{"$f":"INT(H$6/$A$16)","v":2},{"$f":"INT(I$6/$A$16)","v":2},{"$f":"INT(J$6/$A$16)","v":2},{"$f":"INT(K$6/$A$16)","v":4},{"$f":"INT(L$6/$A$16)","v":0},{"$f":"INT(M$6/18)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"INT(Q$6/$A$16)","v":1},{"$f":"INT(R$6/$A$16)","v":0}]
[1,{"$f":"IF(B$6=0,\"\",B$1)","v":"VILLETTE"},{"$f":"IF(C$6=0,\"\",C$1)","v":"BEDIER"},"MENILMONTANT","MARAUDE 93","MARAUDE 75",null,"DENFERT","NATION","ST LAZARE","GARE DE L'EST","SALPETRIERE",{"$f":"M1","v":"INVALIDES"},"REPUBLIQUE","R. LENOIR","SAINT-OUEN","MENILMONTANT SOIR","ST ROCH"]
[null,{"$f":"IF(B$6=0,\"\",B$7)","v":"Veau"},{"$f":"IF(C$6=0,\"\",C$7)","v":"Veau"},"Veau","Steack","Steack",null,"Steack","Steack","Thon","Thon","Steack",{"$f":"M7","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"Poisson","Agneau"]
[null,{"$f":"IF(B$6=0,\"\",IF(B$16=$A$17-1,MOD(B$6,$A$16),$A$16))","v":18},{"$f":"IF(C$6=0,\"\",IF(C$16=$A$17-1,MOD(C$6,$A$16),$A$16))","v":18},{"$f":"IF(D$6=0,\"\",IF(D$16=$A$17-1,MOD(D$6,$A$16),$A$16))","v":18},{"$f":"IF(E$6=0,\"\",IF(E$16=$A$17-1,MOD(E$6,$A$16),$A$16))","v":18},{"$f":"IF(F$6=0,\"\",IF(F$16=$A$17-1,MOD(F$6,$A$16),$A$16))","v":5},null,{"$f":"IF(H$6=0,\"\",IF(H$16=$A$17-1,MOD(H$6,$A$16),$A$16))","v":18},{"$f":"IF(I$6=0,\"\",IF(I$16=$A$17-1,MOD(I$6,$A$16),$A$16))","v":18},{"$f":"IF(J$6=0,\"\",IF(J$16=$A$17-1,MOD(J$6,$A$16),$A$16))","v":18},{"$f":"IF(K$6=0,\"\",IF(K$16=$A$17-1,MOD(K$6,$A$16),$A$16))","v":18},{"$f":"IF(L$6=0,\"\",IF(L$16=$A$17-1,MOD(L$6,$A$16),$A$16))","v":13},{"$f":"IF(M$16<$A$17-1,\"\",IF(M$16=$A$17-1,MOD(M$6,$A$16),$A$16))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},18,15]
[2,{"$f":"IF(B$16>=$A17,B$1,\"\")","v":"VILLETTE"},{"$f":"IF(C$16>=$A17,C$1,\"\")","v":"BEDIER"},{"$f":"IF(D$16>=$A17,D$1,\"\")","v":"MENILMONTANT"},{"$f":"IF(E$16>=$A17,E$1,\"\")","v":"MARAUDE 93"},{"$f":"IF(F$16>=$A17,F$1,\"\")","v":""},null,{"$f":"IF(H$16>=$A17,H$1,\"\")","v":"DENFERT"},"NATION","ST LAZARE","GARE DE L'EST","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"MENILMONTANT SOIR",""]
[null,{"$f":"IF(B$16>=$A17,B$7,\"\")","v":"Veau"},{"$f":"IF(C$16>=$A17,C$7,\"\")","v":"Veau"},{"$f":"IF(D$16>=$A17,D$7,\"\")","v":"Veau"},{"$f":"IF(E$16>=$A17,E$7,\"\")","v":"Steack"},{"$f":"IF(F$16>=$A17,F$7,\"\")","v":""},null,{"$f":"IF(H$16>=$A17,H$7,\"\")","v":"Steack"},"Steack","Thon","Thon","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"Poisson",""]
[null,{"$f":"IF(B$16<$A20-1,\"\",IF(B$16=$A20-1,MOD(B$6,$A$16),$A$16))","v":11},{"$f":"IF(C$16<$A20-1,\"\",IF(C$16=$A20-1,MOD(C$6,$A$16),$A$16))","v":18},{"$f":"IF(D$16<$A20-1,\"\",IF(D$16=$A20-1,MOD(D$6,$A$16),$A$16))","v":18},{"$f":"IF(E$16<$A20-1,\"\",IF(E$16=$A20-1,MOD(E$6,$A$16),$A$16))","v":18},{"$f":"IF(F$16<$A20-1,\"\",IF(F$16=$A20-1,MOD(F$6,$A$16),$A$16))","v":""},null,{"$f":"IF(H$16<$A20-1,\"\",IF(H$16=$A20-1,MOD(H$6,$A$16),$A$16))","v":18},18,18,18,"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},5,""]
[3,{"$f":"IF(B$16>=$A20,B$1,\"\")","v":""},{"$f":"IF(C$16>=$A20,C$1,\"\")","v":"BEDIER"},{"$f":"IF(D$16>=$A20,D$1,\"\")","v":"MENILMONTANT"},{"$f":"IF(E$16>=$A20,E$1,\"\")","v":"MARAUDE 93"},{"$f":"IF(F$16>=$A20,F$1,\"\")","v":""},null,{"$f":"IF(H$16>=$A20,H$1,\"\")","v":"DENFERT"},"NATION","ST LAZARE","GARE DE L'EST","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16>=$A20,B$7,\"\")","v":""},{"$f":"IF(C$16>=$A20,C$7,\"\")","v":"Veau"},{"$f":"IF(D$16>=$A20,D$7,\"\")","v":"Veau"},{"$f":"IF(E$16>=$A20,E$7,\"\")","v":"Steack"},{"$f":"IF(F$16>=$A20,F$7,\"\")","v":""},null,{"$f":"IF(H$16>=$A20,H$7,\"\")","v":"Steack"},"Steack","Thon","Thon","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16<$A23-1,\"\",IF(B$16=$A23-1,MOD(B$6,$A$16),$A$16))","v":""},{"$f":"IF(C$16<$A23-1,\"\",IF(C$16=$A23-1,MOD(C$6,$A$16),$A$16))","v":18},{"$f":"IF(D$16<$A23-1,\"\",IF(D$16=$A23-1,MOD(D$6,$A$16),$A$16))","v":18},{"$f":"IF(E$16<$A23-1,\"\",IF(E$16=$A23-1,MOD(E$6,$A$16),$A$16))","v":18},{"$f":"IF(F$16<$A23-1,\"\",IF(F$16=$A23-1,MOD(F$6,$A$16),$A$16))","v":""},null,{"$f":"IF(H$16<$A23-1,\"\",IF(H$16=$A23-1,MOD(H$6,$A$16),$A$16))","v":4},14,14,18,"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[4,{"$f":"IF(B$16>=$A23,B$1,\"\")","v":""},{"$f":"IF(C$16>=$A23,C$1,\"\")","v":"BEDIER"},{"$f":"IF(D$16>=$A23,D$1,\"\")","v":"MENILMONTANT"},{"$f":"IF(E$16>=$A23,E$1,\"\")","v":"MARAUDE 93"},{"$f":"IF(F$16>=$A23,F$1,\"\")","v":""},null,{"$f":"IF(H$16>=$A23,H$1,\"\")","v":""},"","","GARE DE L'EST","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16>=$A23,B$7,\"\")","v":""},{"$f":"IF(C$16>=$A23,C$7,\"\")","v":"Veau"},{"$f":"IF(D$16>=$A23,D$7,\"\")","v":"Veau"},{"$f":"IF(E$16>=$A23,E$7,\"\")","v":"Steack"},{"$f":"IF(F$16>=$A23,F$7,\"\")","v":""},null,{"$f":"IF(H$16>=$A23,H$7,\"\")","v":""},"","","Thon","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16<$A26-1,\"\",IF(B$16=$A26-1,MOD(B$6,$A$16),$A$16))","v":""},{"$f":"IF(C$16<$A26-1,\"\",IF(C$16=$A26-1,MOD(C$6,$A$16),$A$16))","v":13},{"$f":"IF(D$16<$A26-1,\"\",IF(D$16=$A26-1,MOD(D$6,$A$16),$A$16))","v":18},{"$f":"IF(E$16<$A26-1,\"\",IF(E$16=$A26-1,MOD(E$6,$A$16),$A$16))","v":18},{"$f":"IF(F$16<$A26-1,\"\",IF(F$16=$A26-1,MOD(F$6,$A$16),$A$16))","v":""},null,{"$f":"IF(H$16<$A26-1,\"\",IF(H$16=$A26-1,MOD(H$6,$A$16),$A$16))","v":""},"","",18,"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[5,{"$f":"IF(B$16>=$A26,B$1,\"\")","v":""},{"$f":"IF(C$16>=$A26,C$1,\"\")","v":""},{"$f":"IF(D$16>=$A26,D$1,\"\")","v":"MENILMONTANT"},{"$f":"IF(E$16>=$A26,E$1,\"\")","v":"MARAUDE 93"},{"$f":"IF(F$16>=$A26,F$1,\"\")","v":""},null,{"$f":"IF(H$16>=$A26,H$1,\"\")","v":""},"","","GARE DE L'EST","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16>=$A26,B$7,\"\")","v":""},{"$f":"IF(C$16>=$A26,C$7,\"\")","v":""},{"$f":"IF(D$16>=$A26,D$7,\"\")","v":"Veau"},{"$f":"IF(E$16>=$A26,E$7,\"\")","v":"Steack"},{"$f":"IF(F$16>=$A26,F$7,\"\")","v":""},null,{"$f":"IF(H$16>=$A26,H$7,\"\")","v":""},"","","Thon","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16<$A29-1,\"\",IF(B$16=$A29-1,MOD(B$6,$A$16),$A$16))","v":""},{"$f":"IF(C$16<$A29-1,\"\",IF(C$16=$A29-1,MOD(C$6,$A$16),$A$16))","v":""},{"$f":"IF(D$16<$A29-1,\"\",IF(D$16=$A29-1,MOD(D$6,$A$16),$A$16))","v":18},{"$f":"IF(E$16<$A29-1,\"\",IF(E$16=$A29-1,MOD(E$6,$A$16),$A$16))","v":18},{"$f":"IF(F$16<$A29-1,\"\",IF(F$16=$A29-1,MOD(F$6,$A$16),$A$16))","v":""},null,{"$f":"IF(H$16<$A29-1,\"\",IF(H$16=$A29-1,MOD(H$6,$A$16),$A$16))","v":""},"","",3,"",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[6,{"$f":"IF(B$16>=$A29,B$1,\"\")","v":""},{"$f":"IF(C$16>=$A29,C$1,\"\")","v":""},{"$f":"IF(D$16>=$A29,D$1,\"\")","v":"MENILMONTANT"},{"$f":"IF(E$16>=$A29,E$1,\"\")","v":"MARAUDE 93"},{"$f":"IF(F$16>=$A29,F$1,\"\")","v":""},null,{"$f":"IF(H$16>=$A29,H$1,\"\")","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16>=$A29,B$7,\"\")","v":""},{"$f":"IF(C$16>=$A29,C$7,\"\")","v":""},{"$f":"IF(D$16>=$A29,D$7,\"\")","v":"Veau"},{"$f":"IF(E$16>=$A29,E$7,\"\")","v":"Steack"},{"$f":"IF(F$16>=$A29,F$7,\"\")","v":""},null,{"$f":"IF(H$16>=$A29,H$7,\"\")","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16<$A32-1,\"\",IF(B$16=$A32-1,MOD(B$6,$A$16),$A$16))","v":""},{"$f":"IF(C$16<$A32-1,\"\",IF(C$16=$A32-1,MOD(C$6,$A$16),$A$16))","v":""},{"$f":"IF(D$16<$A32-1,\"\",IF(D$16=$A32-1,MOD(D$6,$A$16),$A$16))","v":10},{"$f":"IF(E$16<$A32-1,\"\",IF(E$16=$A32-1,MOD(E$6,$A$16),$A$16))","v":18},{"$f":"IF(F$16<$A32-1,\"\",IF(F$16=$A32-1,MOD(F$6,$A$16),$A$16))","v":""},null,{"$f":"IF(H$16<$A32-1,\"\",IF(H$16=$A32-1,MOD(H$6,$A$16),$A$16))","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[7,{"$f":"IF(B$16>=$A32,B$1,\"\")","v":""},{"$f":"IF(C$16>=$A32,C$1,\"\")","v":""},{"$f":"IF(D$16>=$A32,D$1,\"\")","v":""},{"$f":"IF(E$16>=$A32,E$1,\"\")","v":"MARAUDE 93"},{"$f":"IF(F$16>=$A32,F$1,\"\")","v":""},null,{"$f":"IF(H$16>=$A32,H$1,\"\")","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16>=$A32,B$7,\"\")","v":""},{"$f":"IF(C$16>=$A32,C$7,\"\")","v":""},{"$f":"IF(D$16>=$A32,D$7,\"\")","v":""},{"$f":"IF(E$16>=$A32,E$7,\"\")","v":"Steack"},{"$f":"IF(F$16>=$A32,F$7,\"\")","v":""},null,{"$f":"IF(H$16>=$A32,H$7,\"\")","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16<$A35-1,\"\",IF(B$16=$A35-1,MOD(B$6,$A$16),$A$16))","v":""},{"$f":"IF(C$16<$A35-1,\"\",IF(C$16=$A35-1,MOD(C$6,$A$16),$A$16))","v":""},{"$f":"IF(D$16<$A35-1,\"\",IF(D$16=$A35-1,MOD(D$6,$A$16),$A$16))","v":""},{"$f":"IF(E$16<$A35-1,\"\",IF(E$16=$A35-1,MOD(E$6,$A$16),$A$16))","v":18},{"$f":"IF(F$16<$A35-1,\"\",IF(F$16=$A35-1,MOD(F$6,$A$16),$A$16))","v":""},null,{"$f":"IF(H$16<$A35-1,\"\",IF(H$16=$A35-1,MOD(H$6,$A$16),$A$16))","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[8,{"$f":"IF(B$16>=$A35,B$1,\"\")","v":""},{"$f":"IF(C$16>=$A35,C$1,\"\")","v":""},{"$f":"IF(D$16>=$A35,D$1,\"\")","v":""},{"$f":"IF(E$16>=$A35,E$1,\"\")","v":"MARAUDE 93"},{"$f":"IF(F$16>=$A35,F$1,\"\")","v":""},null,{"$f":"IF(H$16>=$A35,H$1,\"\")","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16>=$A35,B$7,\"\")","v":""},{"$f":"IF(C$16>=$A35,C$7,\"\")","v":""},{"$f":"IF(D$16>=$A35,D$7,\"\")","v":""},{"$f":"IF(E$16>=$A35,E$7,\"\")","v":"Steack"},{"$f":"IF(F$16>=$A35,F$7,\"\")","v":""},null,{"$f":"IF(H$16>=$A35,H$7,\"\")","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16<$A38-1,\"\",IF(B$16=$A38-1,MOD(B$6,$A$16),$A$16))","v":""},{"$f":"IF(C$16<$A38-1,\"\",IF(C$16=$A38-1,MOD(C$6,$A$16),$A$16))","v":""},{"$f":"IF(D$16<$A38-1,\"\",IF(D$16=$A38-1,MOD(D$6,$A$16),$A$16))","v":""},{"$f":"IF(E$16<$A38-1,\"\",IF(E$16=$A38-1,MOD(E$6,$A$16),$A$16))","v":18},{"$f":"IF(F$16<$A38-1,\"\",IF(F$16=$A38-1,MOD(F$6,$A$16),$A$16))","v":""},null,{"$f":"IF(H$16<$A38-1,\"\",IF(H$16=$A38-1,MOD(H$6,$A$16),$A$16))","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[9,{"$f":"IF(B$16>=$A38,B$1,\"\")","v":""},{"$f":"IF(C$16>=$A38,C$1,\"\")","v":""},{"$f":"IF(D$16>=$A38,D$1,\"\")","v":""},{"$f":"IF(E$16>=$A38,E$1,\"\")","v":"MARAUDE 93"},{"$f":"IF(F$16>=$A38,F$1,\"\")","v":""},null,{"$f":"IF(H$16>=$A38,H$1,\"\")","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16>=$A38,B$7,\"\")","v":""},{"$f":"IF(C$16>=$A38,C$7,\"\")","v":""},{"$f":"IF(D$16>=$A38,D$7,\"\")","v":""},{"$f":"IF(E$16>=$A38,E$7,\"\")","v":"Steack"},{"$f":"IF(F$16>=$A38,F$7,\"\")","v":""},null,{"$f":"IF(H$16>=$A38,H$7,\"\")","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16<$A41-1,\"\",IF(B$16=$A41-1,MOD(B$6,$A$16),$A$16))","v":""},{"$f":"IF(C$16<$A41-1,\"\",IF(C$16=$A41-1,MOD(C$6,$A$16),$A$16))","v":""},{"$f":"IF(D$16<$A41-1,\"\",IF(D$16=$A41-1,MOD(D$6,$A$16),$A$16))","v":""},{"$f":"IF(E$16<$A41-1,\"\",IF(E$16=$A41-1,MOD(E$6,$A$16),$A$16))","v":6},{"$f":"IF(F$16<$A41-1,\"\",IF(F$16=$A41-1,MOD(F$6,$A$16),$A$16))","v":""},null,{"$f":"IF(H$16<$A41-1,\"\",IF(H$16=$A41-1,MOD(H$6,$A$16),$A$16))","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[10,{"$f":"IF(B$16>=$A41,B$1,\"\")","v":""},{"$f":"IF(C$16>=$A41,C$1,\"\")","v":""},{"$f":"IF(D$16>=$A41,D$1,\"\")","v":""},{"$f":"IF(E$16>=$A41,E$1,\"\")","v":""},{"$f":"IF(F$16>=$A41,F$1,\"\")","v":""},null,{"$f":"IF(H$16>=$A41,H$1,\"\")","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16>=$A41,B$7,\"\")","v":""},{"$f":"IF(C$16>=$A41,C$7,\"\")","v":""},{"$f":"IF(D$16>=$A41,D$7,\"\")","v":""},{"$f":"IF(E$16>=$A41,E$7,\"\")","v":""},{"$f":"IF(F$16>=$A41,F$7,\"\")","v":""},null,{"$f":"IF(H$16>=$A41,H$7,\"\")","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,{"$f":"IF(B$16<$A44-1,\"\",IF(B$16=$A44-1,MOD(B$6,$A$16),$A$16))","v":""},{"$f":"IF(C$16<$A44-1,\"\",IF(C$16=$A44-1,MOD(C$6,$A$16),$A$16))","v":""},{"$f":"IF(D$16<$A44-1,\"\",IF(D$16=$A44-1,MOD(D$6,$A$16),$A$16))","v":""},{"$f":"IF(E$16<$A44-1,\"\",IF(E$16=$A44-1,MOD(E$6,$A$16),$A$16))","v":""},{"$f":"IF(F$16<$A44-1,\"\",IF(F$16=$A44-1,MOD(F$6,$A$16),$A$16))","v":""},null,{"$f":"IF(H$16<$A44-1,\"\",IF(H$16=$A44-1,MOD(H$6,$A$16),$A$16))","v":""},"","","","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"",""]
[null,"Lancer la macro sansvides depuis le ruban ou avec le raccourci Ctrl + s"]
[1]
[]
[]
[2]
[]
[]
[3]
[]
[]
[4]
[]
[]
[5]
[]
[]
[6]
[]
[]
[7]
[]
[]
[8]
[]
[]
[9]
[]
[]
[10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(D142=0,\" \",D141)","v":"SOLEIL"},{"$f":"IF(E142=0,\" \",E141)","v":"SOLEIL"},"LEGUMES","SOLEIL","SOLEIL","SOLEIL",null,"SOLEIL"]
[{"$f":"IF(D142=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&D142))","v":{"$error":"#REF!"}},{"$f":"IF(E142=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&E142))","v":{"$error":"#REF!"}},null,18,11,0,null,0]
[{"$f":"IF(F142=0,\" \",F141)","v":" "},{"$f":"IF(H142=0,\" \",H141)","v":" "}]
[{"$f":"IF(F142=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&F142))","v":" "},{"$f":"IF(H142=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&H142))","v":" "}]
[{"$f":"IF(I148=0,\" \",I147)","v":"BEDIER"},{"$f":"IF(J148=0,\" \",J147)","v":" "}]
[{"$f":"IF(I148=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&I148))","v":{"$error":"#REF!"}},{"$f":"IF(J148=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&J148))","v":" "}]
[{"$f":"IF(D148=0,\" \",D147)","v":"BEDIER"},{"$f":"IF(E148=0,\" \",E147)","v":"BEDIER"},null,"BEDIER","BEDIER","BEDIER",null,"BEDIER","BEDIER","BEDIER","BEDIER"]
[{"$f":"IF(D148=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&D148))","v":{"$error":"#REF!"}},{"$f":"IF(E148=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&E148))","v":{"$error":"#REF!"}},null,18,18,18,null,18,3,0,0]
[{"$f":"IF(F148=0,\" \",F147)","v":"BEDIER"},{"$f":"IF(H148=0,\" \",H147)","v":"BEDIER"}]
[{"$f":"IF(F148=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&F148))","v":{"$error":"#REF!"}},{"$f":"IF(H148=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&H148))","v":{"$error":"#REF!"}}]
[{"$f":"IF(D152=0,\" \",D151)","v":"LAVILLETTE"},{"$f":"IF(E152=0,\" \",E151)","v":"LAVILLETTE"},null,"LAVILLETTE","LAVILLETTE","LAVILLETTE",null,"LAVILLETTE","LAVILLETTE","LAVILLETTE","LAVILLETTE"]
[{"$f":"IF(D152=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&D152))","v":{"$error":"#REF!"}},{"$f":"IF(E152=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&E152))","v":{"$error":"#REF!"}},null,18,18,18,null,18,18,18,9]
[{"$f":"IF(F152=0,\" \",F151)","v":"LAVILLETTE"},{"$f":"IF(H152=0,\" \",H151)","v":"LAVILLETTE"}]
[{"$f":"IF(F152=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&F152))","v":{"$error":"#REF!"}},{"$f":"IF(H152=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&H152))","v":{"$error":"#REF!"}}]
[{"$f":"IF(I152=0,\" \",I151)","v":"LAVILLETTE"},{"$f":"IF(J152=0,\" \",J151)","v":"LAVILLETTE"},null,"","","",null,""]
[{"$f":"IF(I152=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&I152))","v":{"$error":"#REF!"}},{"$f":"IF(J152=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&J152))","v":{"$error":"#REF!"}},null,0,0,0,null,0]
[{"$f":"IF(K152=0,\" \",K151)","v":"LAVILLETTE"},{"$f":"IF(#REF!=0,\" \",#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"IF(K152=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&K152))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&#REF!))","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0,\" \",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,\" \",#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&#REF!))","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0,\" \",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,\" \",#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&#REF!))","v":{"$error":"#REF!"}}]
[{"$f":"IF(D164=0,\" \",D163)","v":"MARAUDE 1"},{"$f":"IF(E164=0,\" \",E163)","v":" "},null,"MARAUDE 1","MARAUDE 1","MARAUDE 1",null,"MARAUDE 1"]
[{"$f":"IF(D164=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&D164))","v":{"$error":"#REF!"}},{"$f":"IF(E164=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&E164))","v":" "},null,4,0,0,null,0]
[{"$f":"IF(D166=0,\" \",D165)","v":"MARAUDE 2"},{"$f":"IF(E166=0,\" \",E165)","v":" "},null,"MARAUDE 2","MARAUDE 2","MARAUDE 2",null,"MARAUDE 2"]
[{"$f":"IF(D166=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&D166))","v":{"$error":"#REF!"}},{"$f":"IF(E166=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&E166))","v":" "},null,4,0,0,null,0]
[{"$f":"IF(D168=0,\" \",D167)","v":" "},{"$f":"IF(E168=0,\" \",E167)","v":" "},null,"PENICHE","PENICHE","PENICHE",null,"PENICHE"]
[{"$f":"IF(D168=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&D168))","v":" "},{"$f":"IF(E168=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&E168))","v":" "},null,0,0,0,null,0]
[{"$f":"IF(F168=0,\" \",F167)","v":" "},{"$f":"IF(H168=0,\" \",H167)","v":" "}]
[{"$f":"IF(F168=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&F168))","v":" "},{"$f":"IF(H168=0,\" \",IF(#REF!=1,\"plats de substitution\",\"légumes\"&\" \"&H168))","v":" "}]
["SOLEIL"," ","CAFE"]
["Café"," "]
[" "," "]
[" "," "]
["BEDIER","BEDIER"]
["Café","Café"]
[" "," "]
[" "," "]
["LAVILLETTE","LAVILLETTE"]
["Café","Café"]
["LAVILLETTE","LAVILLETTE"]
["Café","Café"]
[" "," "]
[" "," "]
[" "," "]
[" "," "]
["MARAUDE 1"," "]
["Café"," "]
["MARAUDE 2"," "]
["Café"," "]
[" "," "]
[" "," "]
[" "," "]
[" "," "]
[" "," "]
[" "," "]
[" "," "]
[" "," "]
["SOLEIL","SOLEIL","SOUPE"]
["Soupe","Soupe"]
["SOLEIL"," "]
["Soupe"," "]
["BEDIER","BEDIER"]
["Soupe","Soupe"]
[" "," "]
[" "," "]
["LAVILLETTE","LAVILLETTE"]
["Soupe","Soupe"]
["LAVILLETTE"," "]
["Soupe"," "]
[" "," "]
[" "," "]
[" "," "]
[" "," "]
["MARAUDE 1"," "]
["Soupe"," "]
["MARAUDE 2"," "]
["Soupe"," "]
["SOLEIL"," ","EAU CHAUDE"]
["Eau Chaude"," "]
["BEDIER"," "]
["Eau Chaude"," "]
["LAVILLETTE","LAVILLETTE"]
["Eau Chaude","Eau Chaude"]
[" "," "]
[" "," "]
["MARAUDE 1"," "]
["Eau Chaude"," "]
["MARAUDE 2"," "]
["Eau Chaude"," "]

{"sheet":"Mardi","index":2,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":true,"merged":[[5,0,5,4],[5,6,5,10]]}
[null,{"$f":"Quotats!B1","v":"VILLETTE"},{"$f":"Quotats!C1","v":"BEDIER"},{"$f":"Quotats!D1","v":"MENILMONTANT"},{"$f":"Quotats!E1","v":"MARAUDE 93"},{"$f":"Quotats!F1","v":"MARAUDE 75"},{"$f":"Quotats!G1","v":"DENFERT"},{"$f":"Quotats!H1","v":"NATION"},{"$f":"Quotats!I1","v":"ST LAZARE"},{"$f":"Quotats!J1","v":"GARE DE L'EST"},{"$f":"Quotats!K1","v":"SALPETRIERE"},{"$f":"Quotats!L1","v":"INVALIDES"},{"$f":"Quotats!M1","v":"REPUBLIQUE"},{"$f":"Quotats!N1","v":"R. LENOIR"},{"$f":"Quotats!O1","v":"SAINT-OUEN"},{"$f":"Quotats!P1","v":"MENILMONTANT SOIR"},{"$f":"Quotats!Q1","v":"ST ROCH"}]
["Mardi",{"$f":"Quotats!B3","v":170},{"$f":"Quotats!C3","v":400},{"$f":"Quotats!D3","v":650},{"$f":"Quotats!E3","v":600},{"$f":"Quotats!F3","v":20},{"$f":"Quotats!G3","v":140},{"$f":"Quotats!H3","v":0},{"$f":"Quotats!I3","v":0},{"$f":"Quotats!J3","v":0},{"$f":"Quotats!K3","v":0},{"$f":"Quotats!L3","v":210},{"$f":"Quotats!M3","v":280},{"$f":"Quotats!N3","v":130},{"$f":"Quotats!O3","v":120},{"$f":"Quotats!P3","v":90},{"$f":"Quotats!Q3","v":90}]
[]
[]
[]
["MIDI",null,null,null,null,null,"SOIR"]
["TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":1220},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":620},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},null,"TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":360},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":490},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":120},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":90}]
["TOTAL FAIT",null,null,null,null,null,"TOTAL FAIT"]
["TOTAL À FAIRE",null,null,null,null,null,"TOTAL À FAIRE"]
["TOTAL RESTE ",null,null,null,null,null,"TOTAL RESTE "]

{"sheet":"Mercredi","index":3,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":true,"merged":[[5,0,5,4],[5,6,5,10]]}
[null,{"$f":"Quotats!B1","v":"VILLETTE"},{"$f":"Quotats!C1","v":"BEDIER"},{"$f":"Quotats!D1","v":"MENILMONTANT"},{"$f":"Quotats!E1","v":"MARAUDE 93"},{"$f":"Quotats!F1","v":"MARAUDE 75"},{"$f":"Quotats!G1","v":"DENFERT"},{"$f":"Quotats!H1","v":"NATION"},{"$f":"Quotats!I1","v":"ST LAZARE"},{"$f":"Quotats!J1","v":"GARE DE L'EST"},{"$f":"Quotats!K1","v":"SALPETRIERE"},{"$f":"Quotats!L1","v":"INVALIDES"},{"$f":"Quotats!M1","v":"REPUBLIQUE"},{"$f":"Quotats!N1","v":"R. LENOIR"},{"$f":"Quotats!O1","v":"SAINT-OUEN"},{"$f":"Quotats!P1","v":"MENILMONTANT SOIR"},{"$f":"Quotats!Q1","v":"ST ROCH"}]
["Mercredi",{"$f":"Quotats!B4","v":170},{"$f":"Quotats!C4","v":400},{"$f":"Quotats!D4","v":650},{"$f":"Quotats!E4","v":600},{"$f":"Quotats!F4","v":20},{"$f":"Quotats!G4","v":220},{"$f":"Quotats!H4","v":280},{"$f":"Quotats!I4","v":210},{"$f":"Quotats!J4","v":350},{"$f":"Quotats!K4","v":0},{"$f":"Quotats!L4","v":0},{"$f":"Quotats!M4","v":0},{"$f":"Quotats!N4","v":0},{"$f":"Quotats!O4","v":150},{"$f":"Quotats!P4","v":75},{"$f":"Quotats!Q4","v":80}]
[]
[]
[]
["MIDI",null,null,null,null,null,"SOIR"]
["TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":1220},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":620},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},null,"TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":355},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":430},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":500},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":80}]
["TOTAL FAIT",null,null,null,null,null,"TOTAL FAIT"]
["TOTAL À FAIRE",null,null,null,null,null,"TOTAL À FAIRE"]
["TOTAL RESTE ",null,null,null,null,null,"TOTAL RESTE "]

{"sheet":"Jeudi","index":4,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":true,"merged":[[5,0,5,4],[5,6,5,10]]}
[null,{"$f":"Quotats!B1","v":"VILLETTE"},{"$f":"Quotats!C1","v":"BEDIER"},{"$f":"Quotats!D1","v":"MENILMONTANT"},{"$f":"Quotats!E1","v":"MARAUDE 93"},{"$f":"Quotats!F1","v":"MARAUDE 75"},{"$f":"Quotats!G1","v":"DENFERT"},{"$f":"Quotats!H1","v":"NATION"},{"$f":"Quotats!I1","v":"ST LAZARE"},{"$f":"Quotats!J1","v":"GARE DE L'EST"},{"$f":"Quotats!K1","v":"SALPETRIERE"},{"$f":"Quotats!L1","v":"INVALIDES"},{"$f":"Quotats!M1","v":"REPUBLIQUE"},{"$f":"Quotats!N1","v":"R. LENOIR"},{"$f":"Quotats!O1","v":"SAINT-OUEN"},{"$f":"Quotats!P1","v":"MENILMONTANT SOIR"},{"$f":"Quotats!Q1","v":"ST ROCH"}]
["Jeudi",{"$f":"Quotats!B5","v":170},{"$f":"Quotats!C5","v":400},{"$f":"Quotats!D5","v":650},{"$f":"Quotats!E5","v":600},{"$f":"Quotats!F5","v":20},{"$f":"Quotats!G5","v":0},{"$f":"Quotats!H5","v":0},{"$f":"Quotats!I5","v":0},{"$f":"Quotats!J5","v":0},{"$f":"Quotats!K5","v":65},{"$f":"Quotats!L5","v":220},{"$f":"Quotats!M5","v":300},{"$f":"Quotats!N5","v":190},{"$f":"Quotats!O5","v":180},{"$f":"Quotats!P5","v":90},{"$f":"Quotats!Q5","v":85}]
[]
[]
[]
["MIDI",null,null,null,null,null,"SOIR"]
["TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":1220},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":620},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},null,"TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":610},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":255},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":180},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":85}]
["TOTAL FAIT",null,null,null,null,null,"TOTAL FAIT"]
["TOTAL À FAIRE",null,null,null,null,null,"TOTAL À FAIRE"]
["TOTAL RESTE ",null,null,null,null,null,"TOTAL RESTE "]

{"sheet":"Vendredi","index":5,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":true,"merged":[[5,0,5,4],[5,6,5,10]]}
[null,{"$f":"Quotats!B1","v":"VILLETTE"},{"$f":"Quotats!C1","v":"BEDIER"},{"$f":"Quotats!D1","v":"MENILMONTANT"},{"$f":"Quotats!E1","v":"MARAUDE 93"},{"$f":"Quotats!F1","v":"MARAUDE 75"},{"$f":"Quotats!G1","v":"DENFERT"},{"$f":"Quotats!H1","v":"NATION"},{"$f":"Quotats!I1","v":"ST LAZARE"},{"$f":"Quotats!J1","v":"GARE DE L'EST"},{"$f":"Quotats!K1","v":"SALPETRIERE"},{"$f":"Quotats!L1","v":"INVALIDES"},{"$f":"Quotats!M1","v":"REPUBLIQUE"},{"$f":"Quotats!N1","v":"R. LENOIR"},{"$f":"Quotats!O1","v":"SAINT-OUEN"},{"$f":"Quotats!P1","v":"MENILMONTANT SOIR"},{"$f":"Quotats!Q1","v":"ST ROCH"}]
["Vendredi",{"$f":"Quotats!B6","v":170},{"$f":"Quotats!C6","v":400},{"$f":"Quotats!D6","v":650},{"$f":"Quotats!E6","v":1200},{"$f":"Quotats!F6","v":20},{"$f":"Quotats!G6","v":250},{"$f":"Quotats!H6","v":160},{"$f":"Quotats!I6","v":180},{"$f":"Quotats!J6","v":400},{"$f":"Quotats!K6","v":0},{"$f":"Quotats!L6","v":0},{"$f":"Quotats!M6","v":0},{"$f":"Quotats!N6","v":0},{"$f":"Quotats!O6","v":250},{"$f":"Quotats!P6","v":80},{"$f":"Quotats!Q6","v":85}]
[]
[]
[]
["MIDI",null,null,null,null,null,"SOIR"]
["TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":1220},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":1220},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},null,"TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":1070},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":0},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":250},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":85}]
["TOTAL FAIT",null,null,null,null,null,"TOTAL FAIT"]
["TOTAL À FAIRE",null,null,null,null,null,"TOTAL À FAIRE"]
["TOTAL RESTE ",null,null,null,null,null,"TOTAL RESTE "]

{"sheet":"Samedi","index":6,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":true,"merged":[[5,0,5,4],[5,6,5,10]]}
[null,{"$f":"Quotats!B1","v":"VILLETTE"},{"$f":"Quotats!C1","v":"BEDIER"},{"$f":"Quotats!D1","v":"MENILMONTANT"},{"$f":"Quotats!E1","v":"MARAUDE 93"},{"$f":"Quotats!F1","v":"MARAUDE 75"},{"$f":"Quotats!G1","v":"DENFERT"},{"$f":"Quotats!H1","v":"NATION"},{"$f":"Quotats!I1","v":"ST LAZARE"},{"$f":"Quotats!J1","v":"GARE DE L'EST"},{"$f":"Quotats!K1","v":"SALPETRIERE"},{"$f":"Quotats!L1","v":"INVALIDES"},{"$f":"Quotats!M1","v":"REPUBLIQUE"},{"$f":"Quotats!N1","v":"R. LENOIR"},{"$f":"Quotats!O1","v":"SAINT-OUEN"},{"$f":"Quotats!P1","v":"MENILMONTANT SOIR"},{"$f":"Quotats!Q1","v":"ST ROCH"}]
["Samedi",{"$f":"Quotats!B7","v":0},{"$f":"Quotats!C7","v":0},{"$f":"Quotats!D7","v":0},{"$f":"Quotats!E7","v":0},{"$f":"Quotats!F7","v":0},{"$f":"Quotats!G7","v":0},{"$f":"Quotats!H7","v":0},{"$f":"Quotats!I7","v":0},{"$f":"Quotats!J7","v":0},{"$f":"Quotats!K7","v":0},{"$f":"Quotats!L7","v":220},{"$f":"Quotats!M7","v":400},{"$f":"Quotats!N7","v":150},{"$f":"Quotats!O7","v":0},{"$f":"Quotats!P7","v":75},{"$f":"Quotats!Q7","v":80}]
[]
[]
[]
["MIDI",null,null,null,null,null,"SOIR"]
["TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},null,"TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":475},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":370},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":0},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":80}]
["TOTAL FAIT",null,null,null,null,null,"TOTAL FAIT"]
["TOTAL À FAIRE",null,null,null,null,null,"TOTAL À FAIRE"]
["TOTAL RESTE ",null,null,null,null,null,"TOTAL RESTE "]

{"sheet":"Dimanche","index":7,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":true,"merged":[[5,0,5,4],[5,6,5,10]]}
[null,{"$f":"Quotats!B1","v":"VILLETTE"},{"$f":"Quotats!C1","v":"BEDIER"},{"$f":"Quotats!D1","v":"MENILMONTANT"},{"$f":"Quotats!E1","v":"MARAUDE 93"},{"$f":"Quotats!F1","v":"MARAUDE 75"},{"$f":"Quotats!G1","v":"DENFERT"},{"$f":"Quotats!H1","v":"NATION"},{"$f":"Quotats!I1","v":"ST LAZARE"},{"$f":"Quotats!J1","v":"GARE DE L'EST"},{"$f":"Quotats!K1","v":"SALPETRIERE"},{"$f":"Quotats!L1","v":"INVALIDES"},{"$f":"Quotats!M1","v":"REPUBLIQUE"},{"$f":"Quotats!N1","v":"R. LENOIR"},{"$f":"Quotats!O1","v":"SAINT-OUEN"},{"$f":"Quotats!P1","v":"MENILMONTANT SOIR"},{"$f":"Quotats!Q1","v":"ST ROCH"}]
["Dimanche",{"$f":"Quotats!B8","v":0},{"$f":"Quotats!C8","v":0},{"$f":"Quotats!D8","v":0},{"$f":"Quotats!E8","v":0},{"$f":"Quotats!F8","v":0},{"$f":"Quotats!G8","v":200},{"$f":"Quotats!H8","v":0},{"$f":"Quotats!I8","v":0},{"$f":"Quotats!J8","v":500},{"$f":"Quotats!K8","v":0},{"$f":"Quotats!L8","v":220},{"$f":"Quotats!M8","v":0},{"$f":"Quotats!N8","v":0},{"$f":"Quotats!O8","v":0},{"$f":"Quotats!P8","v":80},{"$f":"Quotats!Q8","v":100}]
[]
[]
[]
["MIDI",null,null,null,null,null,"SOIR"]
["TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},{"$f":"SOMME_SI_COULEUR($B$2:$F$2)","v":0},null,"TOTAL COMMANDÉ",{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":800},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":200},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":0},{"$f":"SOMME_SI_COULEUR($G$2:$Q$2)","v":100}]
["TOTAL FAIT",null,null,null,null,null,"TOTAL FAIT"]
["TOTAL À FAIRE",null,null,null,null,null,"TOTAL À FAIRE"]
["TOTAL RESTE ",null,null,null,null,null,"TOTAL RESTE "]

{"sheet":"infos","index":8,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"si imprévu pas assez, montrer le stock dispo, puis remonter l'info pour modifier les stocks futurs"]
[]
[null,"Calendrier hebdo avec ce qui a déjà été fait, ce qui est à faire, s'il y en a trop ou pas assez"]
[null,null,"s'il y en a trop, le sortir et le mettre en subs"]
[null,null,"Si y en a pas assez, par quoi on compense (SOGERES) puis le remonter "]
[]
[null,"Ils font les échelles, ils indiquent cb, puis ils recoivent l'info de quoi mettre sur le papier "]
[null,null,"l'excel génère les étiquettes"]
[null,null,"la cuisine colle les étiquettes "]
[]
[]
[]
[null,"étape 1 "]
[null,"base de données"]
[]
[null,"étape 2"]
[null,"liens logiques"]