{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Methode 1 - Analyse données","Méthode 2 - Obs continue","Méthode 2 - Calcul TRS"],"not_rendered":{"charts":3,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":1},"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":"Methode 1 - Analyse données","index":0,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"METHODE N°1 - Calcul du TRS par l'analyse de données globales."]
[]
[null,null,"Complétez uniquement les cases jaunes"]
[]
[null,"Données de production"]
[null,"Durée de travail ",8,"heures",{"$f":"C7*60","v":480},"minutes au total"]
[null,"Courtes pauses ",1,"pauses de ",30,"minutes chacunes = ",{"$f":"C8*E8","v":30},"minutes au total"]
[null,"Pause repas ",1,"pauses de ",30,"minutes chacunes = ",{"$f":"C9*E9","v":30},"minutes au total"]
[null,"Temps d'arrêt ",30,"minutes"]
[null,"Taux de production idéal",2,"PPM (pièces par minute)"]
[null,"Nombre total de pièces",450,"pièces"]
[null,"Pièces rejetées",23,"pièces"]
[]
[null,"Calculs intermédiaires","Détails",null,null,null,null,"Résultats"]
[null,"Temps de production planifié","= (Durée de travail) - (Pauses)",null,null,null,null,{"$f":"E7-G8-G9","v":420},"minutes"]
[null,"Temps d'exécution","= (Temps de production prévu) - (Temps d'arrêts)",null,null,null,null,{"$f":"H16-C10","v":390},"minutes"]
[null,"Temps net","= (Temps utile) + (Nombre de pièces rejetées) x (Temps de cyle idéal)",null,null,null,null,{"$f":"H20+C13/C11","v":225},"minutes"]
[null,"Pièces bonnes du 1er coup","= (Nombre total de pièces) - (Pièces rejetées)",null,null,null,null,{"$f":"C12-C13","v":427},"pièces"]
[null,"Temps utile","= (Nombre de pièces bonnes du 1er coup) x (Temps de cycle idéal)",null,null,null,null,{"$f":"H19/C11","v":213.5},"minutes"]
[]
[null,"Composantes TRS","Détails",null,null,null,null,"Votre TRS détaillés"]
[null,"Disponibilité des équipements","= (Temps d'exécution) / (Temps de production planifié)",null,null,null,null,{"$f":"H17/H16","v":0.9285714285714286}]
[null,"Performance opérationnelle","= (Temps de cycle idéal × Nombre de pièces total) / (Temps d'exécution)",null,null,null,null,{"$f":"(C12/C11)/H17","v":0.57692307692307687}]
[null,"Qualité des produits","= (Nombre de pièces bonnes du 1er coup) / (Nombre de pièces total)",null,null,null,null,{"$f":"H19/C12","v":0.94888888888888889}]
[null,"TRS","= (Disponibilité) x (Performance) x (Qualité)",null,null,null,null,{"$f":"H23*H24*H25","v":0.5083333333333333}]

{"sheet":"Méthode 2 - Obs continue","index":1,"n_rows":404,"n_cols":12,"rows_kept":404,"cut":false,"hidden":false,"merged":[[10,1,12,1],[10,2,12,2],[10,3,12,3],[10,4,12,4],[10,5,12,5],[10,6,12,6],[10,7,12,7],[17,7,18,7],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[19,6,20,6],[19,7,20,7],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,18,6],[13,7,14,7],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,7,16,7],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,6,14,6],[25,7,26,7],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,4,28,4],[27,5,28,5],[27,6,28,6],[27,7,28,7],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[21,7,22,7],[23,1,24,1],[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[23,6,24,6],[23,7,24,7],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[33,7,34,7],[35,1,36,1],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[35,6,36,6],[35,7,36,7],[33,1,34,1],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[33,6,34,6],[29,7,30,7],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[29,1,30,1],[29,2,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[41,7,42,7],[43,1,44,1],[43,2,44,2],[43,3,44,3],[43,4,44,4],[43,5,44,5],[43,6,44,6],[43,7,44,7],[41,1,42,1],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[41,6,42,6],[37,7,38,7],[39,1,40,1],[39,2,40,2],[39,3,40,3],[39,4,40,4],[39,5,40,5],[39,6,40,6],[39,7,40,7],[37,1,38,1],[37,2,38,2],[37,3,38,3],[37,4,38,4],[37,5,38,5],[37,6,38,6],[49,7,50,7],[51,1,52,1],[51,2,52,2],[51,3,52,3],[51,4,52,4],[51,5,52,5],[51,6,52,6],[51,7,52,7],[49,1,50,1],[49,2,50,2],[49,3,50,3],[49,4,50,4],[49,5,50,5],[49,6,50,6],[45,7,46,7],[47,1,48,1],[47,2,48,2],[47,3,48,3],[47,4,48,4],[47,5,48,5],[47,6,48,6],[47,7,48,7],[45,1,46,1],[45,2,46,2],[45,3,46,3],[45,4,46,4],[45,5,46,5],[45,6,46,6],[57,7,58,7],[59,1,60,1],[59,2,60,2],[59,3,60,3],[59,4,60,4],[59,5,60,5],[59,6,60,6],[59,7,60,7],[57,1,58,1],[57,2,58,2],[57,3,58,3],[57,4,58,4],[57,5,58,5],[57,6,58,6],[53,7,54,7],[55,1,56,1],[55,2,56,2],[55,3,56,3],[55,4,56,4],[55,5,56,5],[55,6,56,6],[55,7,56,7],[53,1,54,1],[53,2,54,2],[53,3,54,3],[53,4,54,4],[53,5,54,5],[53,6,54,6],[65,7,66,7],[67,1,68,1],[67,2,68,2],[67,3,68,3],[67,4,68,4],[67,5,68,5],[67,6,68,6],[67,7,68,7],[65,1,66,1],[65,2,66,2],[65,3,66,3],[65,4,66,4],[65,5,66,5],[65,6,66,6],[61,7,62,7],[63,1,64,1],[63,2,64,2],[63,3,64,3],[63,4,64,4],[63,5,64,5],[63,6,64,6],[63,7,64,7],[61,1,62,1],[61,2,62,2],[61,3,62,3],[61,4,62,4],[61,5,62,5],[61,6,62,6],[73,7,74,7],[75,1,76,1],[75,2,76,2],[75,3,76,3],[75,4,76,4],[75,5,76,5],[75,6,76,6],[75,7,76,7],[73,1,74,1],[73,2,74,2],[73,3,74,3],[73,4,74,4],[73,5,74,5],[73,6,74,6],[69,7,70,7],[71,1,72,1],[71,2,72,2],[71,3,72,3],[71,4,72,4],[71,5,72,5],[71,6,72,6],[71,7,72,7],[69,1,70,1],[69,2,70,2],[69,3,70,3],[69,4,70,4],[69,5,70,5],[69,6,70,6],[81,7,82,7],[83,1,84,1],[83,2,84,2],[83,3,84,3],[83,4,84,4],[83,5,84,5],[83,6,84,6],[83,7,84,7],[81,1,82,1],[81,2,82,2],[81,3,82,3],[81,4,82,4],[81,5,82,5],[81,6,82,6],[77,7,78,7],[79,1,80,1],[79,2,80,2],[79,3,80,3],[79,4,80,4],[79,5,80,5],[79,6,80,6],[79,7,80,7],[77,1,78,1],[77,2,78,2],[77,3,78,3],[77,4,78,4],[77,5,78,5],[77,6,78,6],[89,7,90,7],[91,1,92,1],[91,2,92,2],[91,3,92,3],[91,4,92,4],[91,5,92,5],[91,6,92,6],[91,7,92,7],[89,1,90,1],[89,2,90,2],[89,3,90,3],[89,4,90,4],[89,5,90,5],[89,6,90,6],[85,7,86,7],[87,1,88,1],[87,2,88,2],[87,3,88,3],[87,4,88,4],[87,5,88,5],[87,6,88,6],[87,7,88,7],[85,1,86,1],[85,2,86,2],[85,3,86,3],[85,4,86,4],[85,5,86,5],[85,6,86,6],[97,7,98,7],[99,1,100,1],[99,2,100,2],[99,3,100,3],[99,4,100,4],[99,5,100,5],[99,6,100,6],[99,7,100,7],[97,1,98,1],[97,2,98,2],[97,3,98,3],[97,4,98,4],[97,5,98,5],[97,6,98,6],[93,7,94,7],[95,1,96,1],[95,2,96,2],[95,3,96,3],[95,4,96,4],[95,5,96,5],[95,6,96,6],[95,7,96,7],[93,1,94,1],[93,2,94,2],[93,3,94,3],[93,4,94,4],[93,5,94,5],[93,6,94,6],[105,7,106,7],[107,1,108,1],[107,2,108,2],[107,3,108,3],[107,4,108,4],[107,5,108,5],[107,6,108,6],[107,7,108,7],[105,1,106,1],[105,2,106,2],[105,3,106,3],[105,4,106,4],[105,5,106,5],[105,6,106,6],[101,7,102,7],[103,1,104,1],[103,2,104,2],[103,3,104,3],[103,4,104,4],[103,5,104,5],[103,6,104,6],[103,7,104,7],[101,1,102,1],[101,2,102,2],[101,3,102,3],[101,4,102,4],[101,5,102,5],[101,6,102,6],[113,7,114,7],[115,1,116,1],[115,2,116,2],[115,3,116,3],[115,4,116,4],[115,5,116,5],[115,6,116,6],[115,7,116,7],[113,1,114,1],[113,2,114,2],[113,3,114,3],[113,4,114,4],[113,5,114,5],[113,6,114,6],[109,7,110,7],[111,1,112,1],[111,2,112,2],[111,3,112,3],[111,4,112,4],[111,5,112,5],[111,6,112,6],[111,7,112,7],[109,1,110,1],[109,2,110,2],[109,3,110,3],[109,4,110,4],[109,5,110,5],[109,6,110,6],[121,7,122,7],[123,1,124,1],[123,2,124,2],[123,3,124,3],[123,4,124,4],[123,5,124,5],[123,6,124,6],[123,7,124,7],[121,1,122,1],[121,2,122,2],[121,3,122,3],[121,4,122,4],[121,5,122,5],[121,6,122,6],[117,7,118,7],[119,1,120,1],[119,2,120,2],[119,3,120,3],[119,4,120,4],[119,5,120,5],[119,6,120,6],[119,7,120,7],[117,1,118,1],[117,2,118,2],[117,3,118,3],[117,4,118,4],[117,5,118,5],[117,6,118,6],[129,7,130,7],[131,1,132,1],[131,2,132,2],[131,3,132,3],[131,4,132,4],[131,5,132,5],[131,6,132,6],[131,7,132,7],[129,1,130,1],[129,2,130,2],[129,3,130,3],[129,4,130,4],[129,5,130,5],[129,6,130,6],[125,7,126,7],[127,1,128,1],[127,2,128,2],[127,3,128,3],[127,4,128,4],[127,5,128,5],[127,6,128,6],[127,7,128,7],[125,1,126,1],[125,2,126,2],[125,3,126,3],[125,4,126,4],[125,5,126,5],[125,6,126,6],[137,7,138,7],[139,1,140,1],[139,2,140,2],[139,3,140,3],[139,4,140,4],[139,5,140,5],[139,6,140,6],[139,7,140,7],[137,1,138,1],[137,2,138,2],[137,3,138,3],[137,4,138,4],[137,5,138,5],[137,6,138,6],[133,7,134,7],[135,1,136,1],[135,2,136,2],[135,3,136,3],[135,4,136,4],[135,5,136,5],[135,6,136,6],[135,7,136,7],[133,1,134,1],[133,2,134,2],[133,3,134,3],[133,4,134,4],[133,5,134,5],[133,6,134,6],[145,7,146,7],[147,1,148,1],[147,2,148,2],[147,3,148,3],[147,4,148,4],[147,5,148,5],[147,6,148,6],[147,7,148,7],[145,1,146,1],[145,2,146,2],[145,3,146,3],[145,4,146,4],[145,5,146,5],[145,6,146,6],[141,7,142,7],[143,1,144,1],[143,2,144,2],[143,3,144,3],[143,4,144,4],[143,5,144,5],[143,6,144,6],[143,7,144,7],[141,1,142,1],[141,2,142,2],[141,3,142,3],[141,4,142,4],[141,5,142,5],[141,6,142,6],[153,7,154,7],[155,1,156,1],[155,2,156,2],[155,3,156,3],[155,4,156,4],[155,5,156,5],[155,6,156,6],[155,7,156,7],[153,1,154,1],[153,2,154,2],[153,3,154,3],[153,4,154,4],[153,5,154,5],[153,6,154,6],[149,7,150,7],[151,1,152,1],[151,2,152,2],[151,3,152,3],[151,4,152,4],[151,5,152,5],[151,6,152,6],[151,7,152,7],[149,1,150,1],[149,2,150,2],[149,3,150,3],[149,4,150,4],[149,5,150,5],[149,6,150,6],[161,7,162,7],[163,1,164,1],[163,2,164,2],[163,3,164,3],[163,4,164,4],[163,5,164,5],[163,6,164,6],[163,7,164,7],[161,1,162,1],[161,2,162,2],[161,3,162,3],[161,4,162,4],[161,5,162,5],[161,6,162,6],[157,7,158,7],[159,1,160,1],[159,2,160,2],[159,3,160,3],[159,4,160,4],[159,5,160,5],[159,6,160,6],[159,7,160,7],[157,1,158,1],[157,2,158,2],[157,3,158,3],[157,4,158,4],[157,5,158,5],[157,6,158,6],[169,7,170,7],[171,1,172,1],[171,2,172,2],[171,3,172,3],[171,4,172,4],[171,5,172,5],[171,6,172,6],[171,7,172,7],[169,1,170,1],[169,2,170,2],[169,3,170,3],[169,4,170,4],[169,5,170,5],[169,6,170,6],[165,7,166,7],[167,1,168,1],[167,2,168,2],[167,3,168,3],[167,4,168,4],[167,5,168,5],[167,6,168,6],[167,7,168,7],[165,1,166,1],[165,2,166,2],[165,3,166,3],[165,4,166,4],[165,5,166,5],[165,6,166,6],[177,7,178,7],[179,1,180,1],[179,2,180,2],[179,3,180,3],[179,4,180,4],[179,5,180,5],[179,6,180,6],[179,7,180,7],[177,1,178,1],[177,2,178,2],[177,3,178,3],[177,4,178,4],[177,5,178,5],[177,6,178,6],[173,7,174,7],[175,1,176,1],[175,2,176,2],[175,3,176,3],[175,4,176,4],[175,5,176,5],[175,6,176,6],[175,7,176,7],[173,1,174,1],[173,2,174,2],[173,3,174,3],[173,4,174,4],[173,5,174,5],[173,6,174,6],[185,7,186,7],[187,1,188,1],[187,2,188,2],[187,3,188,3],[187,4,188,4],[187,5,188,5],[187,6,188,6],[187,7,188,7],[185,1,186,1],[185,2,186,2],[185,3,186,3],[185,4,186,4],[185,5,186,5],[185,6,186,6],[181,7,182,7],[183,1,184,1],[183,2,184,2],[183,3,184,3],[183,4,184,4],[183,5,184,5],[183,6,184,6],[183,7,184,7],[181,1,182,1],[181,2,182,2],[181,3,182,3],[181,4,182,4],[181,5,182,5],[181,6,182,6],[193,7,194,7],[195,1,196,1],[195,2,196,2],[195,3,196,3],[195,4,196,4],[195,5,196,5],[195,6,196,6],[195,7,196,7],[193,1,194,1],[193,2,194,2],[193,3,194,3],[193,4,194,4],[193,5,194,5],[193,6,194,6],[189,7,190,7],[191,1,192,1],[191,2,192,2],[191,3,192,3],[191,4,192,4],[191,5,192,5],[191,6,192,6],[191,7,192,7],[189,1,190,1],[189,2,190,2],[189,3,190,3],[189,4,190,4],[189,5,190,5],[189,6,190,6],[201,7,202,7],[203,1,204,1],[203,2,204,2],[203,3,204,3],[203,4,204,4],[203,5,204,5],[203,6,204,6],[203,7,204,7],[201,1,202,1],[201,2,202,2],[201,3,202,3],[201,4,202,4],[201,5,202,5],[201,6,202,6],[197,7,198,7],[199,1,200,1],[199,2,200,2],[199,3,200,3],[199,4,200,4],[199,5,200,5],[199,6,200,6],[199,7,200,7],[197,1,198,1],[197,2,198,2],[197,3,198,3],[197,4,198,4],[197,5,198,5],[197,6,198,6],[209,7,210,7],[211,1,212,1],[211,2,212,2],[211,3,212,3],[211,4,212,4],[211,5,212,5],[211,6,212,6],[211,7,212,7],[209,1,210,1],[209,2,210,2],[209,3,210,3],[209,4,210,4],[209,5,210,5],[209,6,210,6],[205,7,206,7],[207,1,208,1],[207,2,208,2],[207,3,208,3],[207,4,208,4],[207,5,208,5],[207,6,208,6],[207,7,208,7],[205,1,206,1],[205,2,206,2],[205,3,206,3],[205,4,206,4],[205,5,206,5],[205,6,206,6],[217,7,218,7],[219,1,220,1],[219,2,220,2],[219,3,220,3],[219,4,220,4],[219,5,220,5],[219,6,220,6],[219,7,220,7],[217,1,218,1],[217,2,218,2],[217,3,218,3],[217,4,218,4],[217,5,218,5],[217,6,218,6],[213,7,214,7],[215,1,216,1],[215,2,216,2],[215,3,216,3],[215,4,216,4],[215,5,216,5],[215,6,216,6],[215,7,216,7],[213,1,214,1],[213,2,214,2],[213,3,214,3],[213,4,214,4],[213,5,214,5],[213,6,214,6],[225,7,226,7],[227,1,228,1],[227,2,228,2],[227,3,228,3],[227,4,228,4],[227,5,228,5],[227,6,228,6],[227,7,228,7],[225,1,226,1],[225,2,226,2],[225,3,226,3],[225,4,226,4],[225,5,226,5],[225,6,226,6],[221,7,222,7],[223,1,224,1],[223,2,224,2],[223,3,224,3],[223,4,224,4],[223,5,224,5],[223,6,224,6],[223,7,224,7],[221,1,222,1],[221,2,222,2],[221,3,222,3],[221,4,222,4],[221,5,222,5],[221,6,222,6],[233,7,234,7],[235,1,236,1],[235,2,236,2],[235,3,236,3],[235,4,236,4],[235,5,236,5],[235,6,236,6],[235,7,236,7],[233,1,234,1],[233,2,234,2],[233,3,234,3],[233,4,234,4],[233,5,234,5],[233,6,234,6],[229,7,230,7],[231,1,232,1],[231,2,232,2],[231,3,232,3],[231,4,232,4],[231,5,232,5],[231,6,232,6],[231,7,232,7],[229,1,230,1],[229,2,230,2],[229,3,230,3],[229,4,230,4],[229,5,230,5],[229,6,230,6],[241,7,242,7],[243,1,244,1],[243,2,244,2],[243,3,244,3],[243,4,244,4],[243,5,244,5],[243,6,244,6],[243,7,244,7],[241,1,242,1],[241,2,242,2],[241,3,242,3],[241,4,242,4],[241,5,242,5],[241,6,242,6],[237,7,238,7],[239,1,240,1],[239,2,240,2],[239,3,240,3],[239,4,240,4],[239,5,240,5],[239,6,240,6],[239,7,240,7],[237,1,238,1],[237,2,238,2],[237,3,238,3],[237,4,238,4],[237,5,238,5],[237,6,238,6],[249,7,250,7],[251,1,252,1],[251,2,252,2],[251,3,252,3],[251,4,252,4],[251,5,252,5],[251,6,252,6],[251,7,252,7],[249,1,250,1],[249,2,250,2],[249,3,250,3],[249,4,250,4],[249,5,250,5],[249,6,250,6],[245,7,246,7],[247,1,248,1],[247,2,248,2],[247,3,248,3],[247,4,248,4],[247,5,248,5],[247,6,248,6],[247,7,248,7],[245,1,246,1],[245,2,246,2],[245,3,246,3],[245,4,246,4],[245,5,246,5],[245,6,246,6],[257,7,258,7],[259,1,260,1],[259,2,260,2],[259,3,260,3],[259,4,260,4],[259,5,260,5],[259,6,260,6],[259,7,260,7],[257,1,258,1],[257,2,258,2],[257,3,258,3],[257,4,258,4],[257,5,258,5],[257,6,258,6],[253,7,254,7],[255,1,256,1],[255,2,256,2],[255,3,256,3],[255,4,256,4],[255,5,256,5],[255,6,256,6],[255,7,256,7],[253,1,254,1],[253,2,254,2],[253,3,254,3],[253,4,254,4],[253,5,254,5],[253,6,254,6],[265,7,266,7],[267,1,268,1],[267,2,268,2],[267,3,268,3],[267,4,268,4],[267,5,268,5],[267,6,268,6],[267,7,268,7],[265,1,266,1],[265,2,266,2],[265,3,266,3],[265,4,266,4],[265,5,266,5],[265,6,266,6],[261,7,262,7],[263,1,264,1],[263,2,264,2],[263,3,264,3],[263,4,264,4],[263,5,264,5],[263,6,264,6],[263,7,264,7],[261,1,262,1],[261,2,262,2],[261,3,262,3],[261,4,262,4],[261,5,262,5],[261,6,262,6],[273,7,274,7],[275,1,276,1],[275,2,276,2],[275,3,276,3],[275,4,276,4],[275,5,276,5],[275,6,276,6],[275,7,276,7],[273,1,274,1],[273,2,274,2],[273,3,274,3],[273,4,274,4],[273,5,274,5],[273,6,274,6],[269,7,270,7],[271,1,272,1],[271,2,272,2],[271,3,272,3],[271,4,272,4],[271,5,272,5],[271,6,272,6],[271,7,272,7],[269,1,270,1],[269,2,270,2],[269,3,270,3],[269,4,270,4],[269,5,270,5],[269,6,270,6],[281,7,282,7],[283,1,284,1],[283,2,284,2],[283,3,284,3],[283,4,284,4],[283,5,284,5],[283,6,284,6],[283,7,284,7],[281,1,282,1],[281,2,282,2],[281,3,282,3],[281,4,282,4],[281,5,282,5],[281,6,282,6],[277,7,278,7],[279,1,280,1],[279,2,280,2],[279,3,280,3],[279,4,280,4],[279,5,280,5],[279,6,280,6],[279,7,280,7],[277,1,278,1],[277,2,278,2],[277,3,278,3],[277,4,278,4],[277,5,278,5],[277,6,278,6],[289,7,290,7],[291,1,292,1],[291,2,292,2],[291,3,292,3],[291,4,292,4],[291,5,292,5],[291,6,292,6],[291,7,292,7],[289,1,290,1],[289,2,290,2],[289,3,290,3],[289,4,290,4],[289,5,290,5],[289,6,290,6],[285,7,286,7],[287,1,288,1],[287,2,288,2],[287,3,288,3],[287,4,288,4],[287,5,288,5],[287,6,288,6],[287,7,288,7],[285,1,286,1],[285,2,286,2],[285,3,286,3],[285,4,286,4],[285,5,286,5],[285,6,286,6],[297,7,298,7],[299,1,300,1],[299,2,300,2],[299,3,300,3],[299,4,300,4],[299,5,300,5],[299,6,300,6],[299,7,300,7],[297,1,298,1],[297,2,298,2],[297,3,298,3],[297,4,298,4],[297,5,298,5]],"merged_total":1379,"flags":["merged_cut"]}
[]
[null,"METHODE N°2 - Calcul du TRS suite à des observations continues."]
[]
[null,"Etape 1","Cliquez sur le bouton à droite pour effacer les données de l'exemple ci-dessous"]
[null,"Etape 2","Complétez le tableau suivant lors de votre observation continue"]
[null,"Etape 3","Allez sur l'onglet \"Méthode 2 - Calcul TRS\""]
[null,"Etape 4","Renseignez la cadence de production (case jaune)"]
[null,"Etape 5","Appuyez sur le bouton \"Calculer le TRS\""]
[null,"Etape 6","Analysez les résultats et dressez un plan d'action pour améliorer le TRS"]
[]
[null,"HEURE","DETAIL DE LA TACHE","NATURE","DUREE","INTERVENANT EXT","QUANTITE PRODUITE","REMARQUE"]
[]
[null,null,null,null,null,null,null,null,null,null,"Liste de choix : NATURE"]
[null,"09:01:00","Détail de la tâche","Changement de format",{"$f":"B16-B14","v":"00:01:00"},"Détail des intervenants",null,"Remarques supplémentaires",null,null,"Production (avec MUDA)"]
[null,null,null,null,null,null,null,null,null,null,"Arrêt programmé"]
[null,"09:02:00",null,"Production (avec MUDA)",{"$f":"B18-B16","v":"00:05:00"},null,489,null,null,null,"Panne"]
[null,null,null,null,null,null,null,null,null,null,"Changement de format"]
[null,"09:07:00",null,"Non qualité",{"$f":"B20-B18","v":"00:04:00"},null,null,null,null,null,"Organisation"]
[null,null,null,null,null,null,null,null,null,null,"Non qualité"]
[null,"09:11:00",null,"Changement de format",{"$f":"B22-B20","v":"00:01:00"}]
[null,null,null,null,null,null,null,null,null,null,"Hors liste :"]
[null,"09:12:00",null,"Changement de format",{"$f":"B24-B22","v":"00:01:00"},null,null,null,null,null,"Ralentissement / Micro-arrêt"]
[null,null,null,null,null,null,null,null,null,null,null,"(Va être determiné par soustraction)"]
[null,"09:13:00",null,"Production (avec MUDA)",{"$f":"B26-B24","v":"00:08:00"},null,630]
[]
[null,"09:21:00",null,"Non qualité",{"$f":"B28-B26","v":"00:04:00"}]
[]
[null,"09:25:00",null,"Changement de format",{"$f":"B30-B28","v":"00:01:00"}]
[]
[null,"09:26:00",null,"Changement de format",{"$f":"B32-B30","v":"00:01:00"}]
[]
[null,"09:27:00",null,"Production (avec MUDA)",{"$f":"B34-B32","v":"00:03:00"},null,307]
[]
[null,"09:30:00",null,"Non qualité",{"$f":"B36-B34","v":"00:03:00"}]
[]
[null,"09:33:00",null,"Changement de format",{"$f":"B38-B36","v":"00:01:00"}]
[]
[null,"09:34:00",null,"Changement de format",{"$f":"B40-B38","v":"00:01:00"}]
[]
[null,"09:35:00",null,"Arrêt programmé",{"$f":"B42-B40","v":"00:16:00"}]
[]
[null,"09:51:00",null,"Production (avec MUDA)",{"$f":"B44-B42","v":"00:04:00"},null,366]
[]
[null,"09:55:00",null,"Non qualité",{"$f":"B46-B44","v":"00:04:00"}]
[]
[null,"09:59:00",null,"Changement de format",{"$f":"B48-B46","v":"00:00:00"}]
[]
[null,"09:59:00",null,"Changement de format",{"$f":"B50-B48","v":"00:01:00"}]
[]
[null,"10:00:00",null,"Production (avec MUDA)",{"$f":"B52-B50","v":"00:05:00"},null,374]
[]
[null,"10:05:00",null,"Non qualité",{"$f":"B54-B52","v":"00:03:00"}]
[]
[null,"10:08:00",null,"Changement de format",{"$f":"B56-B54","v":"00:00:00"}]
[]
[null,"10:08:00",null,"Changement de format",{"$f":"B58-B56","v":"00:01:00"}]
[]
[null,"10:09:00",null,"Production (avec MUDA)",{"$f":"B60-B58","v":"00:05:00"},null,398]
[]
[null,"10:14:00",null,"Non qualité",{"$f":"B62-B60","v":"00:02:00"}]
[]
[null,"10:16:00",null,"Changement de format",{"$f":"B64-B62","v":"00:01:00"}]
[]
[null,"10:17:00",null,"Organisation",{"$f":"B66-B64","v":"00:01:00"}]
[]
[null,"10:18:00",null,"Changement de format",{"$f":"B68-B66","v":"00:01:00"}]
[]
[null,"10:19:00",null,"Panne",{"$f":"B70-B68","v":"00:00:00"}]
[]
[null,"10:19:00",null,"Production (avec MUDA)",{"$f":"B72-B70","v":"00:01:00"},null,0]
[]
[null,"10:20:00",null,"Non qualité",{"$f":"B74-B72","v":"00:01:00"}]
[]
[null,"10:21:00",null,"Production (avec MUDA)",{"$f":"B76-B74","v":"00:03:00"},null,377]
[]
[null,"10:24:00",null,"Non qualité",{"$f":"B78-B76","v":"00:02:00"}]
[]
[null,"10:26:00",null,"Changement de format",{"$f":"B80-B78","v":"00:01:00"}]
[]
[null,"10:27:00",null,"Changement de format",{"$f":"B82-B80","v":"00:00:00"}]
[]
[null,"10:27:00",null,"Production (avec MUDA)",{"$f":"B84-B82","v":"00:05:00"},null,625]
[]
[null,"10:32:00",null,"Non qualité",{"$f":"B86-B84","v":"00:07:00"}]
[]
[null,"10:39:00",null,"Changement de format",{"$f":"B88-B86","v":"00:00:00"}]
[]
[null,"10:39:00",null,"Changement de format",{"$f":"B90-B88","v":"00:01:00"}]
[]
[null,"10:40:00",null,"Production (avec MUDA)",{"$f":"B92-B90","v":"00:04:00"},null,564]
[]
[null,"10:44:00",null,"Non qualité",{"$f":"B94-B92","v":"00:03:00"}]
[]
[null,"10:47:00",null,"Changement de format",{"$f":"B96-B94","v":"00:01:00"}]
[]
[null,"10:48:00",null,"Changement de format",{"$f":"B98-B96","v":"00:00:00"}]
[]
[null,"10:48:00",null,"Production (avec MUDA)",{"$f":"B100-B98","v":"00:05:00"},null,546]
[]
[null,"10:53:00",null,"Non qualité",{"$f":"B102-B100","v":"00:05:00"}]
[]
[null,"10:58:00",null,"Changement de format",{"$f":"B104-B102","v":"00:00:00"}]
[]
[null,"10:58:00",null,"Changement de format",{"$f":"B106-B104","v":"00:01:00"}]
[]
[null,"10:59:00",null,"Production (avec MUDA)",{"$f":"B108-B106","v":"00:05:00"},null,618]
[]
[null,"11:04:00",null,"Non qualité",{"$f":"B110-B108","v":"00:04:00"}]
[]
[null,"11:08:00",null,"Changement de format",{"$f":"B112-B110","v":"00:01:00"}]
[]
[null,"11:09:00",null,"Changement de format",{"$f":"B114-B112","v":"00:01:00"}]
[]
[null,"11:10:00",null,"Production (avec MUDA)",{"$f":"B116-B114","v":"00:06:00"},null,614]
[]
[null,"11:16:00",null,"Non qualité",{"$f":"B118-B116","v":"00:04:00"}]
[]
[null,"11:20:00",null,"Changement de format",{"$f":"B120-B118","v":"00:01:00"}]
[]
[null,"11:21:00",null,"Changement de format",{"$f":"B122-B120","v":"00:00:00"}]
[]
[null,"11:21:00",null,"Production (avec MUDA)",{"$f":"B124-B122","v":"00:04:00"},null,424]
[]
[null,"11:25:00",null,"Non qualité",{"$f":"B126-B124","v":"00:03:00"}]
[]
[null,"11:28:00",null,"Changement de format",{"$f":"B128-B126","v":"00:00:00"}]
[]
[null,"11:28:00",null,"Organisation",{"$f":"B130-B128","v":"00:02:00"}]
[]
[null,"11:30:00",null,"Changement de format",{"$f":"B132-B130","v":"00:03:00"}]
[]
[null,"11:33:00",null,"Arrêt programmé",{"$f":"B134-B132","v":"00:15:00"}]
[]
[null,"11:48:00",null,"Production (avec MUDA)",{"$f":"B136-B134","v":"00:06:00"},null,551]
[]
[null,"11:54:00",null,"Non qualité",{"$f":"B138-B136","v":"00:03:00"}]
[]
[null,"11:57:00",null,"Changement de format",{"$f":"B140-B138","v":"00:01:00"}]
[]
[null,"11:58:00",null,"Changement de format",{"$f":"B142-B140","v":"00:00:00"}]
[]
[null,"11:58:00",null,"Production (avec MUDA)",{"$f":"B144-B142","v":"00:04:00"},null,486]
[]
[null,"12:02:00",null,"Non qualité",{"$f":"B146-B144","v":"00:05:00"}]
[]
[null,"12:07:00",null,"Organisation",{"$f":"B148-B146","v":"00:01:00"}]
[]
[null,"12:08:00",null,"Non qualité",{"$f":"B150-B148","v":"00:02:00"}]
[]
[null,"12:10:00",null,"Changement de format",{"$f":"B152-B150","v":"00:00:00"}]
[]
[null,"12:10:00",null,"Changement de format",{"$f":"B154-B152","v":"00:01:00"}]
[]
[null,"12:11:00",null,"Production (avec MUDA)",{"$f":"B156-B154","v":"00:05:00"},null,618]
[]
[null,"12:16:00",null,"Non qualité",{"$f":"B158-B156","v":"00:06:00"}]
[]
[null,"12:22:00",null,"Changement de format",{"$f":"B160-B158","v":"00:01:00"}]
[]
[null,"12:23:00",null,"Organisation",{"$f":"B162-B160","v":"00:01:00"}]
[]
[null,"12:24:00",null,"Changement de format",{"$f":"B164-B162","v":"00:02:00"}]
[]
[null,"12:26:00",null,"Changement de format",{"$f":"B166-B164","v":"00:00:00"}]
[]
[null,"12:26:00",null,"Panne",{"$f":"B168-B166","v":"00:01:00"}]
[]
[null,"12:27:00",null,"Production (avec MUDA)",{"$f":"B170-B168","v":"00:06:00"},null,525]
[]
[null,"12:33:00",null,"Non qualité",{"$f":"B172-B170","v":"00:04:00"}]
[]
[null,"12:37:00",null,"Changement de format",{"$f":"B174-B172","v":"00:01:00"}]
[]
[null,"12:38:00",null,"Organisation",{"$f":"B176-B174","v":"00:01:00"}]
[]
[null,"12:39:00",null,"Changement de format",{"$f":"B178-B176","v":"00:01:00"}]
[]
[null,"12:40:00",null,"Changement de format",{"$f":"B180-B178","v":"00:00:00"}]
[]
[null,"12:40:00",null,"Production (avec MUDA)",{"$f":"B182-B180","v":"00:06:00"},null,676]
[]
[null,"12:46:00",null,"Non qualité",{"$f":"B184-B182","v":"00:06:00"}]
[]
[null,"12:52:00",null,"Organisation",{"$f":"B186-B184","v":"00:01:00"}]
[]
[null,"12:53:00",null,"Panne",{"$f":"B188-B186","v":"00:02:00"}]
[]
[null,"12:55:00",null,"Organisation",{"$f":"B190-B188","v":"00:03:00"}]
[]
[null,"12:58:00",null,"Organisation",{"$f":"B192-B190","v":"00:02:00"}]
[]
[null,"13:00:00",null,"Organisation",{"$f":"B194-B192","v":"00:02:00"}]
[]
[null,"13:02:00",null,"Organisation",{"$f":"B196-B194","v":"00:01:00"}]
[]
[null,"13:03:00",null,"Changement de format",{"$f":"B198-B196","v":"00:01:00"}]
[]
[null,"13:04:00",null,"Changement de format",{"$f":"B200-B198","v":"00:00:00"}]
[]
[null,"13:04:00",null,"Production (avec MUDA)",{"$f":"B202-B200","v":"00:03:00"},null,312]
[]
[null,"13:07:00",null,"Non qualité",{"$f":"B204-B202","v":"00:04:00"}]
[]
[null,"13:11:00",null,"Changement de format",{"$f":"B206-B204","v":"00:02:00"}]
[]
[null,"13:13:00",null,"Production (avec MUDA)",{"$f":"B208-B206","v":"00:03:00"},null,371]
[]
[null,"13:16:00",null,"Non qualité",{"$f":"B210-B208","v":"00:00:00"}]
[]
[null,"13:16:00",null,"Organisation",{"$f":"B212-B210","v":"00:01:00"}]
[]
[null,"13:17:00",null,"Non qualité",{"$f":"B214-B212","v":"00:03:00"}]
[]
[null,"13:20:00",null,"Changement de format",{"$f":"B216-B214","v":"00:01:00"}]
[]
[null,"13:21:00",null,"Production (avec MUDA)",{"$f":"B218-B216","v":"00:05:00"},null,377]
[]
[null,"13:26:00",null,"Non qualité",{"$f":"B220-B218","v":"00:03:00"}]
[]
[null,"13:29:00",null,"Organisation",{"$f":"B222-B220","v":"00:01:00"}]
[]
[null,"13:30:00",null,"Changement de format",{"$f":"B224-B222","v":"00:02:00"}]
[]
[null,"13:32:00",null,"Production (avec MUDA)",{"$f":"B226-B224","v":"00:10:00"},null,859]
[]
[null,"13:42:00",null,"Non qualité",{"$f":"B228-B226","v":"00:05:00"}]
[]
[null,"13:47:00",null,"Changement de format",{"$f":"B230-B228","v":"00:00:00"}]
[]
[null,"13:47:00",null,"Changement de format",{"$f":"B232-B230","v":"00:01:00"}]
[]
[null,"13:48:00",null,"Production (avec MUDA)",{"$f":"B234-B232","v":"00:04:00"},null,0]
[]
[null,"13:52:00",null,"Panne",{"$f":"B236-B234","v":"00:03:00"}]
[]
[null,"13:55:00",null,"Production (avec MUDA)",{"$f":"B238-B236","v":"00:04:00"},null,656]
[]
[null,"13:59:00",null,"Non qualité",{"$f":"B240-B238","v":"00:06:00"}]
[]
[null,"14:05:00",null,"Changement de format",{"$f":"B242-B240","v":"00:01:00"}]
[]
[null,"14:06:00",null,"Organisation",{"$f":"B244-B242","v":"00:02:00"}]
[]
[null,"14:08:00",null,"Changement de format",{"$f":"B246-B244","v":"00:01:00"}]
[]
[null,"14:09:00",null,"Production (avec MUDA)",{"$f":"B248-B246","v":"00:05:00"},null,472]
[]
[null,"14:14:00",null,"Non qualité",{"$f":"B250-B248","v":"00:07:00"}]
[]
[null,"14:21:00",null,"Changement de format",{"$f":"B252-B250","v":"00:01:00"}]
[]
[null,"14:22:00",null,"Production (avec MUDA)",{"$f":"B254-B252","v":"00:05:00"},null,544]
[]
[null,"14:27:00",null,"Non qualité",{"$f":"B256-B254","v":"00:04:00"}]
[]
[null,"14:31:00",null,"Changement de format",{"$f":"B258-B256","v":"00:01:00"}]
[]
[null,"14:32:00",null,"Production (avec MUDA)",{"$f":"B260-B258","v":"00:04:00"},null,446]
[]
[null,"14:36:00",null,"Non qualité",{"$f":"B262-B260","v":"00:05:00"}]
[]
[null,"14:41:00",null,"Changement de format",{"$f":"B264-B262","v":"00:01:00"}]
[]
[null,"14:42:00",null,"Production (avec MUDA)",{"$f":"B266-B264","v":"00:04:00"},null,427]
[]
[null,"14:46:00",null,"Non qualité",{"$f":"B268-B266","v":"00:05:00"}]
[]
[null,"14:51:00",null,"Changement de format",{"$f":"B270-B268","v":"00:01:00"}]
[]
[null,"14:52:00",null,"Production (avec MUDA)",{"$f":"B272-B270","v":"00:02:00"},null,0]
[]
[null,"14:54:00",null,"Organisation",{"$f":"B274-B272","v":"00:02:00"}]
[]
[null,"14:56:00",null,"Production (avec MUDA)",{"$f":"B276-B274","v":"00:04:00"},null,434]
[]
[null,"15:00:00",null,"Non qualité",{"$f":"B278-B276","v":"00:06:00"}]
[]
[null,"15:06:00",null,"Organisation",{"$f":"B280-B278","v":"00:01:00"}]
[]
[null,"15:07:00",null,"Changement de format",{"$f":"B282-B280","v":"00:00:00"}]
[]
[null,"15:07:00",null,"Production (avec MUDA)",{"$f":"B284-B282","v":"00:03:00"},null,342]
[]
[null,"15:10:00",null,"Non qualité",{"$f":"B286-B284","v":"00:03:00"}]
[]
[null,"15:13:00",null,"Changement de format",{"$f":"B288-B286","v":"00:01:00"}]
[]
[null,"15:14:00",null,"Production (avec MUDA)",{"$f":"B290-B288","v":"00:04:00"},null,473]
[]
[null,"15:18:00",null,"Non qualité",{"$f":"B292-B290","v":"00:05:00"}]
[]
[null,"15:23:00",null,"Changement de format",{"$f":"B294-B292","v":"00:01:00"}]
[]
[null,"15:24:00",null,"Production (avec MUDA)",{"$f":"B296-B294","v":"00:05:00"},null,464]
[]
[null,"15:29:00",null,"Non qualité",{"$f":"B298-B296","v":"00:02:00"}]
[]
[null,"15:31:00",null,"Changement de format",{"$f":"B300-B298","v":"00:01:00"}]
[]
[null,"15:32:00",null,"Production (avec MUDA)",{"$f":"B302-B300","v":"00:05:00"},null,549]
[]
[null,"15:37:00",null,"Non qualité",{"$f":"B304-B302","v":"00:05:00"}]
[]
[null,"15:42:00",null,"Arrêt programmé",{"$f":"B306-B304","v":"00:18:00"}]
[]
[null,"16:00:00",null,"Changement de format",{"$f":"B308-B306","v":"00:02:00"}]
[]
[null,"16:02:00",null,"Production (avec MUDA)",{"$f":"B310-B308","v":"00:04:00"},null,427]
[]
[null,"16:06:00",null,"Non qualité",{"$f":"B312-B310","v":"00:08:00"}]
[]
[null,"16:14:00",null,"Organisation",{"$f":"B314-B312","v":"00:01:00"}]
[]
[null,"16:15:00",null,"Organisation",{"$f":"B316-B314","v":"00:03:00"}]
[]
[null,"16:18:00",null,"Changement de format",{"$f":"B318-B316","v":"00:01:00"}]
[]
[null,"16:19:00",null,"Production (avec MUDA)",{"$f":"B320-B318","v":"00:06:00"},null,482]
[]
[null,"16:25:00",null,"Non qualité",{"$f":"B322-B320","v":"00:04:00"}]
[]
[null,"16:29:00",null,"Changement de format",{"$f":"B324-B322","v":"00:01:00"}]
[]
[null,"16:30:00",null,"Production (avec MUDA)",{"$f":"B326-B324","v":"00:02:00"},null,0]
[]
[null,"16:32:00",null,"Panne",{"$f":"B328-B326","v":"00:01:00"}]
[]
[null,"16:33:00",null,"Organisation",{"$f":"B330-B328","v":"00:01:00"}]
[]
[null,"16:34:00",null,"Production (avec MUDA)",{"$f":"B332-B330","v":"00:02:00"},null,485]
[]
[null,"16:36:00",null,"Non qualité",{"$f":"B334-B332","v":"00:04:00"}]
[]
[null,"16:40:00",null,"Changement de format",{"$f":"B336-B334","v":"00:01:00"}]
[]
[null,"16:41:00",null,"Production (avec MUDA)",{"$f":"B338-B336","v":"00:04:00"},null,462]
[]
[null,"16:45:00",null,"Organisation",{"$f":"B340-B338","v":"00:01:00"}]
[]
[null,"16:46:00",null,"Non qualité",{"$f":"B342-B340","v":"00:06:00"}]
[]
[null,"16:52:00",null,"Changement de format",{"$f":"B344-B342","v":"00:01:00"}]
[]
[null,"16:53:00",null,"Production (avec MUDA)",{"$f":"B346-B344","v":"00:05:00"},null,488]
[]
[null,"16:58:00",null,"Non qualité",{"$f":"B348-B346","v":"00:03:00"}]
[]
[null,"17:01:00"]
[]
[null,null,null,null,{"$f":"B352-B350","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B354-B352","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B356-B354","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B358-B356","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B360-B358","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B362-B360","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B364-B362","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B366-B364","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B368-B366","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B370-B368","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B372-B370","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B374-B372","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B376-B374","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B378-B376","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B380-B378","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B382-B380","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B384-B382","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B386-B384","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B388-B386","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B390-B388","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B392-B390","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B394-B392","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B396-B394","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B398-B396","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B400-B398","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B402-B400","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"B404-B402","v":"00:00:00"}]
[]
[null,null,"Fin",null,{"$f":"SUM(E14:E403)","v":"08:00:00"},null,{"$f":"SUM(G14:G403)","v":18258}]

{"sheet":"Méthode 2 - Calcul TRS","index":2,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[66,1,66,3],[67,1,67,3],[68,1,68,3],[73,1,73,3],[74,1,74,3],[75,1,75,3],[57,1,57,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[61,1,61,3],[62,1,62,3],[63,1,63,3],[64,1,64,3],[65,1,65,3],[69,1,69,3],[70,1,70,3],[71,1,71,3],[72,1,72,3]]}
[]
[null,"METHODE N°2 - Calcul du TRS suite à des observations continues."]
[]
[]
[]
[1,"Actualiser le tableau croisé dynamique"]
[]
[null,"Somme de DUREE",null,null,"! Ne pas modifier les filtres"]
[null,"NATURE","Total"]
[null,"Production (avec MUDA)","03:03:00"]
[null,"Changement de format","00:50:00"]
[null,"Non qualité","02:43:00"]
[null,"Arrêt programmé","00:49:00"]
[null,"Organisation","00:28:00"]
[null,"Panne","00:07:00"]
[null,"Total général","08:00:00"]
[]
[2,"Renseigner la cadence de production"]
[]
[null,"Temps de production",{"$f":"C21/C22","v":152.15}]
[null,"Quantité d'articles produits",{"$f":"'Méthode 2 - Obs continue'!G404","v":18258}]
[null,"Cadence de production (/min)",120,null,"! Quantité par minute"]
[]
[3,"Temps d'ouverture"]
[]
[null,null,"(min)","%"]
[]
[null,"Temps d'observation",{"$f":"'Méthode 2 - Obs continue'!E404:E405*24*60","v":479.99999999999977},1]
[null,null,0]
[null,"Temps de production planifié",{"$f":"C28","v":479.99999999999977},{"$f":"D28","v":1}]
[]
[4,"Temps brut de fonctionnement"]
[]
[null,"Perte de disponibilité",{"$f":"SUM(C35:C38)","v":134},{"$f":"C34/$C$30","v":0.27916666666666679}]
[null,"Organisation",{"$f":"VLOOKUP(B35,$B$10:$C$15,2,FALSE)*24*60","v":27.999999999999993},{"$f":"C35/$C$30","v":5.8333333333333348E-2}]
[null,"Arrêt programmé",{"$f":"VLOOKUP(B36,$B$10:$C$15,2,FALSE)*24*60","v":49},0.10208333333333339]
[null,"Panne",{"$f":"VLOOKUP(B37,$B$10:$C$15,2,FALSE)*24*60","v":7},1.4583333333333341E-2]
[null,"Changement de format",{"$f":"VLOOKUP(B38,$B$10:$C$15,2,FALSE)*24*60","v":50},0.10416666666666671]
[]
[null,"Temps d'exécution",{"$f":"C30-C34","v":345.99999999999977},{"$f":"C40/C30","v":0.72083333333333321}]
[]
[5,"Temps net de fonctionnement"]
[]
[null,"Perte de performance",{"$f":"C45","v":186.84999999999977},{"$f":"D45","v":0.38927083333333301}]
[null,"Ralentissements / micro-arrêts",{"$f":"C30-C34-C51-C20","v":186.84999999999977},{"$f":"C45/C28","v":0.38927083333333301}]
[]
[null,"Temps net",{"$f":"C40-C44","v":159.15},{"$f":"C47/C30","v":0.33156250000000015}]
[]
[6,"Temps utile"]
[]
[null,"Perte de qualité",{"$f":"C52","v":7},{"$f":"C51/C$28","v":1.4583333333333341E-2}]
[null,"Non qualité",{"$f":"C15*24*60","v":7},{"$f":"C52/C$28","v":1.4583333333333341E-2}]
[]
[null,"Temps utile",{"$f":"C20","v":152.15},{"$f":"C54/C30","v":0.31697916666666681}]
[]
[7,"Passer à l'action !"]
[]
[null,"QUOI",null,null,"QUI","QUAND","AVANCEMENT"]