Feuil1InfoMaths MicroMoyenneTP 7Coef433Nadia 1091410.9Samir1215711.4Mouna13121112.1

Feuil2Colonne1Note d'infoNote MathNote de StatistiqueTotalMoyenne IndividuelRangeMentionCoeff12.536.5XXXSara812113110.92307692313 Passable Mohcine1015833112 Passable Bouchra1216103812.61538461541 Assez Bien Samia14014288.61538461544 Mdiocre Moy. ClasseXTP8

Feuil31234561123456TP9224681012336912151844812162024551015202530661218243036Fixer Les Colonnes( par ex $A1 ) et on va fixer les lignes (par ex B$1 )

Feuil4Grille de rnumrationAnciennet/etude012345030003000300030004000500014000400040004000500060002500050005000500060007000580008000800080009000100001013000130001300013000140001500015180001800018000180001900020000salaire de rfrence1000TP 10

Feuil5Ref serviceServiceEffectifsPrvision en %Montant en MADConsomm% ConsommCrdit restantPERGestion person 918.00%72,000.00 [$MAD]830.00 [$MAD]1.15%71,170.00 [$MAD]FINfinances 1020.00%80,000.00 [$MAD]933.00 [$MAD]1.17%79,067.00 [$MAD]COMCommerciaux1020.00%80,000.00 [$MAD]0.00 [$MAD]0.00%80,000.00 [$MAD]400,000.00 [$MAD]TECTechniques1122.00%88,000.00 [$MAD]0.00 [$MAD]0.00%88,000.00 [$MAD]DIRDirection1020.00%80,000.00 [$MAD]840.00 [$MAD]1.05%79,160.00 [$MAD]Liste Des AchatsDateDsignation ServicePuQtMontant1/12/13StylosPER1,20 MAD100120.00 [$MAD]1/15/13GommesFIN1.55 [$MAD]6093.00 [$MAD]1/18/13Lampes BureauDIR210.00 [$MAD]4840.00 [$MAD]1/21/13ClasseursPER12.00 [$MAD]25450.00 [$MAD]1/24/13Cartouches LaserFIN420.00 [$MAD]2840.00 [$MAD]1/27/13PapierPER32.50 [$MAD]6260.00 [$MAD]

Feuil6