teaching:corrections13
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
teaching:corrections13 [2012/08/26 12:39] – created sbolay | teaching:corrections13 [2012/11/26 14:55] (current) – [AJ24] sbolay | ||
---|---|---|---|
Line 4: | Line 4: | ||
)) | )) | ||
- | Janvier | + | ===== Janvier |
- | + | ==== A1 ==== | |
- | A1 | + | < |
Format: Standard | Format: Standard | ||
Formule: =$Annuelle.$F$1 | Formule: =$Annuelle.$F$1 | ||
- | D1 | + | </ |
+ | ==== D1 ==== | ||
+ | < | ||
Format: Date (MMMM AA) | Format: Date (MMMM AA) | ||
Formule: =DATE(ANNEE($Annuelle.$F$2), | Formule: =DATE(ANNEE($Annuelle.$F$2), | ||
- | B4 | + | </ |
+ | ==== B4 ==== | ||
+ | < | ||
Format: standard | Format: standard | ||
Formule: =SI(MOIS($D$1)=1, | Formule: =SI(MOIS($D$1)=1, | ||
- | G4 | + | </ |
+ | ==== G4 ==== | ||
+ | < | ||
Format: standard | Format: standard | ||
Formule: =SI(FEUILLE()> | Formule: =SI(FEUILLE()> | ||
+ | </ | ||
+ | |||
ou | ou | ||
+ | < | ||
Format: standard | Format: standard | ||
Formule: =SI(FEUILLE()> | Formule: =SI(FEUILLE()> | ||
+ | </ | ||
+ | |||
avec la macro | avec la macro | ||
+ | <code vb> | ||
REM ***** BASIC ***** | REM ***** BASIC ***** | ||
' | ' | ||
Line 49: | Line 60: | ||
End Function | End Function | ||
+ | </ | ||
+ | |||
http:// | http:// | ||
- | Ligne 5 | + | ==== Ligne 5 ==== |
- | + | === Formatage conditionnel | |
- | Formatage conditionnel | + | < |
Condition 1: SI($A5> | Condition 1: SI($A5> | ||
Condition 2: SI(OU(JOURSEM(DATE(ANNEE($D$1), | Condition 2: SI(OU(JOURSEM(DATE(ANNEE($D$1), | ||
Condition 3: NB.SI($Fériés.$A$2: | Condition 3: NB.SI($Fériés.$A$2: | ||
- | A5 | + | </ |
+ | ==== A5 ==== | ||
+ | < | ||
Format: Entier numérique | Format: Entier numérique | ||
Valeur: 1 | Valeur: 1 | ||
- | B5, C5, D5 et E5 | + | </ |
- | Format: | + | ==== B5, C5, D5 et E5 ==== |
+ | < | ||
+ | Format: | ||
Valeur: - | Valeur: - | ||
- | F5 | + | </ |
- | Format: | + | ==== F5 ==== |
+ | < | ||
+ | Format: | ||
Formule: =SI(OU(JOURSEM(DATE(ANNEE($D$1), | Formule: =SI(OU(JOURSEM(DATE(ANNEE($D$1), | ||
- | G5 | + | </ |
- | Format: | + | ==== G5 ==== |
+ | < | ||
+ | Format: | ||
Formule: =SOMME((C5-B5)+(E5-D5))-F5 | Formule: =SOMME((C5-B5)+(E5-D5))-F5 | ||
- | B36 | + | </ |
+ | ==== B36 ==== | ||
+ | < | ||
Format: standard | Format: standard | ||
Formule: =CONCATENER(" | Formule: =CONCATENER(" | ||
- | G36 | + | </ |
- | Format: | + | ==== G36 ==== |
+ | < | ||
+ | Format: | ||
Formule: =SOMME(G4: | Formule: =SOMME(G4: | ||
- | B37 | + | </ |
+ | ==== B37 ==== | ||
+ | < | ||
Format: standard | Format: standard | ||
Formule: =CONCATENER(" | Formule: =CONCATENER(" | ||
- | G37 | + | </ |
- | Format: | + | ==== G37 ==== |
+ | < | ||
+ | Format: | ||
Formule: =D43 | Formule: =D43 | ||
- | B38 | + | </ |
+ | ==== B38 ==== | ||
+ | < | ||
Format: standard | Format: standard | ||
Formule: =CONCATENER(" | Formule: =CONCATENER(" | ||
- | G38 | + | </ |
- | Format: | + | ==== G38 ==== |
+ | < | ||
+ | Format: | ||
Formule: =G36-G37 | Formule: =G36-G37 | ||
- | D41 | + | </ |
- | Format: | + | ==== D41 ==== |
+ | < | ||
+ | Format: | ||
Formule: =D42/C42 | Formule: =D42/C42 | ||
- | E41 | + | </ |
- | Format: | + | ==== E41 ==== |
+ | < | ||
+ | Format: | ||
Formule: =$Annuelle.$AJ$23 | Formule: =$Annuelle.$AJ$23 | ||
- | F41 | + | </ |
- | Format: | + | ==== F41 ==== |
+ | < | ||
+ | Format: | ||
Formule: =D41-E41 | Formule: =D41-E41 | ||
- | D42 | + | </ |
- | Format: | + | ==== D42 ==== |
+ | < | ||
+ | Format: | ||
Formule: =$Annuelle.$AG$24 | Formule: =$Annuelle.$AG$24 | ||
- | E42 | + | </ |
- | Format: | + | ==== E42 ==== |
+ | < | ||
+ | Format: | ||
Formule: =C42*E41 | Formule: =C42*E41 | ||
- | F42 | + | </ |
- | Format: | + | ==== F42 ==== |
+ | < | ||
+ | Format: | ||
Formule: =D42-E42 | Formule: =D42-E42 | ||
- | C43 | + | </ |
+ | ==== C43 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =NB.JOURS.OUVRES($D$1, | Formule: =NB.JOURS.OUVRES($D$1, | ||
- | D43 | + | </ |
+ | ==== D43 ==== | ||
+ | < | ||
Format: Heure ([HH]:MM) | Format: Heure ([HH]:MM) | ||
Formule: =C43*D41 | Formule: =C43*D41 | ||
- | E43 | + | </ |
+ | ==== E43 ==== | ||
+ | < | ||
Format: Heure ([HH]:MM) | Format: Heure ([HH]:MM) | ||
Formule: =C43*E41 | Formule: =C43*E41 | ||
- | F43 | + | </ |
+ | ==== F43 ==== | ||
+ | < | ||
Format: Heure ([HH]:MM) | Format: Heure ([HH]:MM) | ||
Formule: =D43-E43 | Formule: =D43-E43 | ||
- | Annuelle | + | </ |
- | + | ||
- | AH6 | + | |
+ | ===== Annuelle ===== | ||
+ | ==== AH6 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =F3+F4 | Formule: =F3+F4 | ||
- | AO6 | + | </ |
+ | ==== AO6 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =F5 | Formule: =F5 | ||
- | A8 - A19 | + | </ |
+ | ==== A8 - A19 ==== | ||
+ | < | ||
Format: Date (MMM) | Format: Date (MMM) | ||
Formule: =DATE(ANNEE($F$2), | Formule: =DATE(ANNEE($F$2), | ||
- | B8 | + | </ |
- | + | ||
- | Formatage conditionnel | + | |
+ | ==== B8 ==== | ||
+ | === Formatage conditionnel === | ||
+ | < | ||
Condition 1 - fin_mois: SI(B$7> | Condition 1 - fin_mois: SI(B$7> | ||
Condition 2 - weekends: SI(OU(JOURSEM(DATE(ANNEE($F$2), | Condition 2 - weekends: SI(OU(JOURSEM(DATE(ANNEE($F$2), | ||
Condition 3 - vacances: NB.SI($Fériés.$A$2: | Condition 3 - vacances: NB.SI($Fériés.$A$2: | ||
- | AH8 | + | </ |
+ | ==== AH8 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =NB.SI($B8: | Formule: =NB.SI($B8: | ||
- | AI8 | + | </ |
+ | ==== AI8 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =NB.SI($B8: | Formule: =NB.SI($B8: | ||
- | AJ8 | + | </ |
+ | ==== AJ8 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =NB.SI($B8: | Formule: =NB.SI($B8: | ||
- | AK8 | + | </ |
+ | ==== AK8 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =NB.SI($B8: | Formule: =NB.SI($B8: | ||
- | AL8 | + | </ |
+ | ==== AL8 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =NB.SI($B8: | Formule: =NB.SI($B8: | ||
- | AM8 | + | </ |
+ | ==== AM8 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =NB.SI($B8: | Formule: =NB.SI($B8: | ||
- | AN8 | + | </ |
+ | ==== AN8 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =SOMME(B8: | Formule: =SOMME(B8: | ||
- | AO8 | + | </ |
+ | ==== AO8 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =AN8-($AM8*$AG$23*60) | Formule: =AN8-($AM8*$AG$23*60) | ||
- | A20 | + | </ |
+ | ==== A20 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =CONCATENER(" | Formule: =CONCATENER(" | ||
- | AH20 | + | </ |
+ | ==== AH20 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =$AH$6-SOMME($AH$8: | Formule: =$AH$6-SOMME($AH$8: | ||
- | AI20 | + | </ |
+ | ==== AI20 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =SOMME($AI$8: | Formule: =SOMME($AI$8: | ||
- | AJ20 | + | </ |
+ | ==== AJ20 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =SOMME($AJ$8: | Formule: =SOMME($AJ$8: | ||
- | AK20 | + | </ |
+ | ==== AK20 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =SOMME($AK$8: | Formule: =SOMME($AK$8: | ||
- | AL20 | + | </ |
+ | ==== AL20 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =SOMME($AL$8: | Formule: =SOMME($AL$8: | ||
- | AM20 | + | </ |
+ | ==== AM20 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =SOMME($AM$8: | Formule: =SOMME($AM$8: | ||
- | AN20 | + | </ |
+ | ==== AN20 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =SOMME($AN$8: | Formule: =SOMME($AN$8: | ||
- | AO20 | + | </ |
+ | ==== AO20 ==== | ||
+ | < | ||
Format: Standard | Format: Standard | ||
Formule: =$AO$6+SOMME(AO$8: | Formule: =$AO$6+SOMME(AO$8: | ||
- | AG23 | + | </ |
+ | ==== AG23 ==== | ||
+ | < | ||
Format: Heure (HH:MM) | Format: Heure (HH:MM) | ||
Formule: =AG24/AE24 | Formule: =AG24/AE24 | ||
- | AJ24 | + | </ |
+ | ==== AJ24 ==== | ||
+ | < | ||
Format: Heure ([HH]:MM) | Format: Heure ([HH]:MM) | ||
Formule: =AE24*AJ23 | Formule: =AE24*AJ23 | ||
+ | </ | ||
+ | ===== Fériés ===== | ||
+ | ==== A1 à L1 ==== | ||
+ | < | ||
+ | Format: Date (MMMM AA) | ||
+ | Formule: =DATE(ANNEE($Annuelle.$F$2); | ||
+ | </ |
teaching/corrections13.1345984755.txt.gz · Last modified: 2012/08/26 12:39 by sbolay