{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Base"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"Instructions","index":0,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Gestion des tableaux"]
["Objectifs"]
[null,"Utiliser au maximum l'automatisation du classeur"]
[null,"Calcul et analyse des données"]
[]
["Travail à faire"]
[{"$f":"MAX($A$6:A6)+1","v":1},"Remplir la colonne [A] jusqu'au \"Salarié 100\""]
[null,"Méthode"]
[null,"Utiliser le glisser-copier avec le clic gauche de la souris en étirant le coin inférieur droit de la cellule de départ"]
[]
[{"$f":"MAX($A$6:A10)+1","v":2},"Remplir la colonne [B] de façon aléatoire avec un nombre compris entre 1 et 5"]
[null,"Méthode"]
[null,"Utiliser la fonction =ALEA.ENTRE.BORNES(). Les \"bornes étant 1 et 5. Le signe égal en début est indispensable pour que le tableur utilise la fonction."]
[null,"Utiliser le glisser-copier avec le clic gauche de la souris en étirant le coin inférieur droit de la cellule de départ"]
[null,"Sélectionner la colonne entière et faire un copier/coller en valeur"]
[]
[{"$f":"MAX($A$6:A16)+1","v":3},"Remplir la colonne [O] avec la moyenne annuelle de chaque salarié"]
[null,"Méthode"]
[null,"Utiliser la fonction =MOYENNE(). Le signe égal en début est indispensable pour que le tableur utilise la fonction."]
[null,"Utiliser le glisser-copier avec le clic gauche de la souris en étirant le coin inférieur droit de la cellule de départ"]
[]
[{"$f":"MAX($A$6:A21)+1","v":4},"Remplir la colonne [Q] avec le rang obtenu par chaque salarié sur sa moyenne annuelle."]
[null,"Méthode"]
[null,"Utiliser la fonction =RANG(). Le signe égal en début est indispensable pour que le tableur utilise la fonction."]
[null,"Utiliser le glisser-copier avec le clic gauche de la souris en étirant le coin inférieur droit de la cellule de départ"]
[]
[{"$f":"MAX($A$6:A26)+1","v":5},"Faire apparaitre automatiquement dans la colonne [Q] le rang 1 et le rang 100 en mettant le premier en écriture blanche sur fond rouge et le dernier en écriture blanche sur fond noir."]
[null,"Méthode"]
[null,"Sélectionner les données de la colonne [Q]"]
[null,"Dans le menu \"ACCUEIL\", chercher \"mise en forme conditionelle\" puis \"Règles de mise en subrillance des cellules\""]
[null,"Trouver la règle ou les règles adéquates."]
[]
[{"$f":"MAX($A$6:A32)+1","v":6},"Masquer/afficher les mois"]
[null,"Méthode"]
[null,"Sélectionner les colonnes entières contenant les mois de janvier à décembre"]
[null,null,"Click droit puis [Masquer]"]
[null,"Pour afficher, sélectionner les colonnes adjacentes"]
[null,null,"Click droit puis [Afficher]"]
[]
[{"$f":"MAX($A$6:A39)+1","v":7},"Réaliser une macrocommande pour automatiser le processus"]
[null,"Méthode"]
[null,"Suivre les instructions données au vidéo projecteur."]
[]
[{"$f":"MAX($A$6:A43)+1","v":8},"Réaliser un tutoriel avec le logiciel screenpresso"]
[null,"Méthode"]
[null,"Suivre les instructions données au vidéo projecteur."]

{"sheet":"Base","index":1,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,14,1,14],[0,15,1,15]]}
[null,"Mois","janvier","Fév","mars","avril","mai","juin","Juil.","août","septembre","octobre","novembre","décembre","Moy. Annuelle/Salarié","Rang "]
["Salarié","           Coeff.\nEquipe",1,1,1,1,3,3,3,1,12,1,1,1]
["Salarié 1",null,670,421,630,437,818,708,894,158,512,413,690,256]
["Salarié 2",null,347,634,867,650,717,717,739,345,205,639,863,803]
["Salarié 3",null,186,320,449,569,888,184,230,874,470,577,787,397]
["Salarié 4",null,457,460,449,234,601,677,720,845,255,127,674,175]
["Salarié 5",null,605,533,180,496,855,240,355,143,385,194,101,100]
[null,null,231,270,892,470,870,416,672,874,314,267,583,341]
[null,null,694,546,874,738,508,333,283,331,221,263,822,126]
[null,null,653,656,218,607,168,253,898,213,735,567,384,100]
[null,null,836,714,360,776,229,852,143,349,663,837,849,590]
[null,null,428,805,594,659,643,637,768,595,147,185,204,575]
[null,null,460,174,899,519,347,279,852,519,106,756,315,248]
[null,null,380,238,664,594,196,234,896,619,153,683,174,792]
[null,null,427,499,826,611,696,284,549,785,102,352,664,249]
[null,null,815,425,890,428,261,839,252,765,158,824,694,128]
[null,null,272,397,573,826,648,118,889,419,485,640,561,406]
[null,null,225,324,110,219,289,174,581,281,483,312,727,204]
[null,null,687,262,189,442,627,857,867,415,128,730,621,155]
[null,null,614,359,522,486,723,507,216,597,267,721,193,701]
[null,null,302,219,319,865,850,462,152,490,297,214,573,837]
[null,null,849,771,851,837,159,639,222,643,459,352,822,683]
[null,null,739,266,387,117,351,454,383,429,545,113,279,418]
[null,null,389,248,665,813,182,593,756,756,420,372,607,605]
[null,null,716,301,804,481,116,235,781,243,148,205,374,879]
[null,null,636,224,131,354,376,586,743,136,517,865,377,460]
[null,null,175,594,300,135,732,281,373,458,766,786,642,600]
[null,null,210,320,711,446,619,582,689,221,325,596,601,220]
[null,null,705,586,490,786,670,730,236,469,170,657,788,471]
[null,null,530,346,801,730,199,346,412,418,427,108,335,625]
[null,null,385,307,817,703,335,783,673,344,732,678,185,793]
[null,null,742,862,883,444,113,565,748,617,843,242,449,729]
[null,null,692,366,262,773,282,187,683,442,234,815,471,355]
[null,null,883,820,452,715,890,596,843,638,445,345,201,536]
[null,null,567,585,296,773,383,150,688,357,881,794,292,527]
[null,null,217,103,235,587,100,280,107,633,260,564,112,373]
[null,null,166,303,659,666,493,369,807,256,682,348,785,383]
[null,null,569,792,227,860,386,809,898,721,210,193,488,763]
[null,null,727,704,483,197,657,381,519,361,875,428,681,126]
[null,null,418,238,200,728,373,441,330,694,360,554,564,313]
[null,null,242,491,274,426,105,841,597,785,419,493,185,577]
[null,null,575,474,152,864,636,833,705,780,252,636,118,422]
[null,null,594,665,864,228,234,281,367,781,233,523,578,165]
[null,null,312,449,899,519,583,666,644,350,716,799,270,622]
[null,null,799,792,403,817,403,867,639,304,604,493,759,202]
[null,null,349,879,744,820,561,745,519,779,243,606,416,241]
[null,null,407,609,129,659,764,771,884,336,237,808,550,417]
[null,null,603,826,466,257,459,252,730,463,799,137,819,458]
[null,null,252,466,343,648,752,529,137,210,186,643,386,681]
[null,null,255,367,495,250,428,649,410,573,416,136,657,428]
[null,null,345,207,339,739,887,194,801,363,594,735,575,246]
[null,null,762,372,649,688,165,561,204,731,617,215,302,132]
[null,null,141,594,254,290,407,237,192,814,486,120,662,848]
[null,null,230,496,497,732,870,183,679,776,674,382,259,140]
[null,null,737,801,795,486,539,572,523,425,624,568,454,581]
[null,null,786,561,643,631,875,885,778,446,159,558,342,319]
[null,null,170,521,517,845,704,368,167,106,854,466,886,428]
[null,null,377,575,604,869,240,699,680,790,146,580,422,852]
[null,null,730,609,764,452,475,564,703,576,187,532,206,325]
[null,null,206,803,546,388,586,570,298,358,226,789,167,703]
[null,null,816,398,144,759,642,555,693,871,718,826,143,340]
[null,null,140,292,474,619,804,793,511,546,621,772,625,348]
[null,null,871,657,814,834,287,235,682,210,681,732,636,316]
[null,null,886,371,528,597,632,386,360,604,562,361,560,101]
[null,null,630,783,890,704,515,629,769,866,807,252,590,803]
[null,null,141,524,338,744,846,205,310,278,216,602,596,364]
[null,null,714,751,404,234,670,695,691,575,316,765,803,265]
[null,null,232,797,282,866,166,531,160,246,877,817,565,226]
[null,null,832,309,474,386,599,319,252,673,137,499,713,871]
[null,null,794,458,634,611,494,213,241,287,676,583,565,124]
[null,null,605,147,577,370,327,641,236,746,754,212,429,379]
[null,null,355,268,249,500,662,131,277,302,639,444,814,509]
[null,null,421,576,141,856,572,526,150,717,313,385,691,165]
[null,null,134,533,549,233,196,195,258,224,758,888,311,802]
[null,null,355,474,299,139,183,877,686,190,200,663,270,833]
[null,null,446,824,211,349,550,424,866,835,229,395,452,273]
[null,null,556,793,506,770,566,780,132,411,170,309,353,748]
[null,null,659,820,871,783,250,533,160,257,835,852,504,781]
[null,null,187,115,695,290,737,150,755,677,866,837,513,251]
[null,null,444,378,201,874,555,124,764,428,205,554,311,240]
[null,null,363,876,253,139,160,671,701,547,744,149,532,216]
[null,null,288,205,663,411,462,392,859,294,259,355,734,765]
[null,null,295,330,276,694,479,214,437,501,835,870,494,290]
[null,null,266,299,313,847,533,319,343,463,469,420,739,891]
[null,null,424,745,684,574,653,439,178,130,761,481,730,666]
[null,null,815,284,588,584,598,743,539,681,592,658,591,130]
[null,null,851,363,545,299,363,326,755,775,244,863,890,556]
[null,null,546,246,840,442,233,508,240,354,690,588,622,823]
[null,null,772,760,202,655,864,829,745,113,526,898,749,365]
[null,null,889,354,760,218,478,195,371,542,444,810,775,302]
[null,null,181,861,159,719,444,735,568,382,895,369,265,893]
[null,null,196,463,619,650,400,824,248,423,508,562,557,298]
[null,null,158,649,261,346,235,127,159,181,140,817,418,577]
[null,null,881,227,393,898,655,604,194,181,608,398,613,505]
[null,null,582,279,371,682,132,653,108,812,603,318,384,440]
[null,null,304,561,221,721,615,784,307,474,827,691,888,643]
[null,null,844,677,698,170,315,397,406,787,686,646,736,128]
[null,null,668,619,288,150,647,136,295,797,258,816,551,315]
[null,null,633,824,310,692,835,259,215,401,811,744,205,389]
[null,null,542,595,425,623,301,193,403,806,214,593,174,100]
[null,null,408,807,246,823,809,693,186,585,782,263,609,201]
[null,null,100,858,661,326,621,427,734,212,669,321,820,821]
["Moyenne/mois",null,{"$f":"AVERAGE(C3:C102)","v":497},506.99,495.93,565.6,501.08,484.55,504.48,495.83,472.02,529.13,520.65,448.82]
[null,null,"=MOYENNE(C3:C126)"]