/* VLD Revenus Excel Export */
function exportRevenusExcel(data, year) {
if (!data || !data.length) return;
var h = ["VLD","Artiste","Q1","Q2","Q3","Q4","Total","Total YT","Total PL","Total INV"];
var rows = data.map(function(r) {
return [r.vld||"", r.artist||"", (r.q1||0).toFixed(2), (r.q2||0).toFixed(2), (r.q3||0).toFixed(2), (r.q4||0).toFixed(2), (r.total||0).toFixed(2), (r.tYT||0).toFixed(2), (r.tPL||0).toFixed(2), (r.tINV||0).toFixed(2)];
});
var csv = "\xEF\xBB\xBF" + h.join(";") + "\n" + rows.map(function(r){return r.join(";");}).join("\n");
var blob = new Blob([csv], {type: "application/vnd.ms-excel;charset=utf-8"});
var url = URL.createObjectURL(blob);
var a = document.createElement("a");
a.href = url;
a.download = "revenus_" + year + ".xls";
a.click();
URL.revokeObjectURL(url);
}