JS — Calcul d'indemnité de licenciement

JS — Severance pay calculator

function calcLicenciement() {
  const base = getVal('lic_base'), primes = getVal('lic_primes'), annees = getVal('lic_annees');
  const total = base + primes;
  const jour = total / 26;
  const brute = jour * 10 * annees;
  const plafond = total * 6;
  const result = Math.min(brute, plafond);
  document.getElementById('lic_result').textContent = fmtAr(result);
  updateSolde();
}

— extrait de l'appli Code du travail malgache

— from the Malagasy Labor Code app

JS — Recherche & filtre d'articles

JS — Article search & filter

function filterArticles() {
  const q = document.getElementById('searchArt').value.toLowerCase();
  const theme = document.getElementById('filterTheme').value.toLowerCase();
  const filtered = ARTICLES.filter(a => {
    const matchQ = !q || a.num.toLowerCase().includes(q) ||
                   a.texte.toLowerCase().includes(q) || a.tags.toLowerCase().includes(q);
    const matchT = !theme || a.chap.toLowerCase().includes(theme);
    return matchQ && matchT;
  });
  renderArticles(filtered);
}

— extrait de l'appli Code du travail malgache

— from the Malagasy Labor Code app

Excel — Comptage dynamique par service

Excel — Dynamic per-department count

=COUNTIFS('📋 BASE'!F8:F7998, B10,
          '📋 BASE'!G8:G7998, "EMBAUCHE")

=COUNTIFS('📋 BASE'!F8:F7998, B10,
          '📋 BASE'!G8:G7998, "DEBAUCHE")

— extrait de la base RH NOVA MADA

— from the NOVA MADA HR database

Excel — Validation & mise en forme conditionnelle

Excel — Validation & conditional formatting

' Liste déroulante de statut
Data Validation → List: "EMBAUCHE,DEBAUCHE"

' Coloration automatique de ligne
Conditional Format → Formula: $G8="DEBAUCHE"
Conditional Format → Formula: $G8="EMBAUCHE"

— extrait de la base RH NOVA MADA

— from the NOVA MADA HR database