---
priority: 10
type: project
tags: ["project"]
univers: PRO
title: "PILOTAGE-BUDGET"
aliases: ["Budget DGE 2026"]
status: closed
urgence: "haute"     # Options: haute, normale, basse
category: "PILOTAGE"
start: "2026-03-20"
due: "2026-03-20"
end: "2026-03-20"
review: "2026-03-20"
---
# PILOTAGE-BUDGET

## Todo

* [x] [[90_ARCHIVES/CLOS/PRO/BUDGET-DGE-2026]] - Transmettre synthèse à MVA (cf. mail transmis à MCS et FMA le 10/07/2026) [date: 2026-07-20]
* [x] [[90_ARCHIVES/CLOS/PRO/BUDGET-DGE-2026]] - Exporter les données de GEF et utiliser Mistral pour générer un schéma relationnel des tables pour construire une BDD SQLite
  L’objectif est de pouvoir importer les données de GEF au fur et à mesure et d’y accéder pour produire des analyses automatiques
* [x] [[90_ARCHIVES/CLOS/PRO/BUDGET-DGE-2026]] - Etablir cadre local pour une gestion sous Excel
  Utilisation de Gemini pour définir ce cadre : https://gemini.google.com/app/412bde7e64e97a05?hl=fr
  Cf. synthèse : [[04_NOTES/PILOTAGE-BUDGET_Excel]]
  


## HISTORIQUE

### [[01_JOURNAL/2026/2026-07-29]]
* Création d’une documentation d’analyse des export de GEF (uniquement structure de fichiers CSV)
  Cf. [[04_NOTES/PILOTAGE-BUDGET_Documentation]]


## NOTES

Projets => Tranche => Engagement (argent réservé ?)

[[04_NOTES/Budget_collectivite]]

${query[[
  from p = index.pages()
  limit 10
  where p.projects and string.find(p.name, "%[%[" .. _CTX.currentPage.ref .. "%]%]")
]]}



### Urgent
${TaskManager(query[[from o = index.tag "task" where not o.done and table.includes(o.itags, 'URGENT')
and string.find(o.name, "%[%[" .. _CTX.currentPage.ref .. "%]%]") order by o.name limit 20]], {
  {"Tags", "tags", "string"},
  --{"Priority", "priority", "string"},
  --{"Due Date", "due", "YY-MM-DD"},
  --{"Scheduled", "scheduled", "date"},
  --{"Completed", "completed", "dateTime"},
  --{"Estimate", "est", "string"}
})}

### Next
${TaskManager(query[[from o = index.tag "task" where not o.done and table.includes(o.itags, 'next')
and string.find(o.name, "%[%[" .. _CTX.currentPage.ref .. "%]%]") order by o.name limit 20]], {
  {"Tags", "tags", "string"},
  --{"Priority", "priority", "string"},
  --{"Due Date", "due", "YY-MM-DD"},
  --{"Scheduled", "scheduled", "date"},
  --{"Completed", "completed", "dateTime"},
  --{"Estimate", "est", "string"}
})}

### Other
${TaskManager(query[[from o = index.tag "task" where not o.done and string.find(o.name, "%[%[" .. _CTX.currentPage.ref .. "%]%]") and not table.includes(o.itags, 'next') and not table.includes(o.itags, 'URGENT') order by o.name limit 20]], {
  {"Tags", "tags", "string"},
  --{"Priority", "priority", "string"},
  --{"Due Date", "due", "YY-MM-DD"},
  --{"Scheduled", "scheduled", "date"},
  --{"Completed", "completed", "dateTime"},
  --{"Estimate", "est", "string"}
})}

### Done
${TaskManager(query[[from o = index.tag "task" where o.done and string.find(o.name, "%[%[" .. _CTX.currentPage.ref .. "%]%]") order by o.completed limit 20]], {
  {"Tags", "tags", "string"},
  --{"Priority", "priority", "string"},
  --{"Due Date", "due", "YY-MM-DD"},
  --{"Scheduled", "scheduled", "date"},
  --{"Completed", "completed", "dateTime"},
  --{"Estimate", "est", "string"}
})}

## Evénements
${query[[from o = index.tag "header" where table.includes(o.tags, "event")
and string.find(string.gsub(o.name, '%-', '_'), "%[%[" .. string.gsub(_CTX.currentPage.name, '%-', '_') .. "%]%]") order by o.page desc limit 10 select table.select(o, 'ref', 'name')]]}


## DONE

- [x] [[03_PROJETS/PILOTAGE-BUDGET]] - Envoyer récapitulatifs des services faits validés à MCS [date:2025-11-13]