{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Rapport Financier 2024","Analyses Graphiques","Tendances Mensuelles"],"not_rendered":{"charts":3},"read":"whole","date_system":"1900"}

{"sheet":"Rapport Financier 2024","index":0,"n_rows":41,"n_cols":8,"rows_kept":41,"merged":[[0,0,1,7],[2,0,2,7],[40,0,40,1]]}
["RAPPORT FINANCIER ANNUEL 2024\nAnalyse Complète et Prévisions"]
[]
["Département des Ventes - Trimestre Q1-Q4"]
["Région","Produit","Unités Vendues","Prix Unitaire","Chiffre d'Affaires","Coût","Marge Brute","Marge %"]
["Europe du Nord","Ordinateur Portable Premium",165,{"v":484,"d":"$484"},{"$f":"C5*D5","v":null},{"v":290.4,"d":"$290"},{"$f":"E5-F5","v":null},{"$f":"IF(E5>0,G5/E5,0)","v":null}]
["Europe du Nord","Tablette Professionnelle",178,{"v":521,"d":"$521"},{"$f":"C6*D6","v":null},{"v":312.6,"d":"$313"},{"$f":"E6-F6","v":null},{"$f":"IF(E6>0,G6/E6,0)","v":null}]
["Europe du Nord","Smartphone 5G",191,{"v":558,"d":"$558"},{"$f":"C7*D7","v":null},{"v":334.8,"d":"$335"},{"$f":"E7-F7","v":null},{"$f":"IF(E7>0,G7/E7,0)","v":null}]
["Europe du Nord","Écran 4K",204,{"v":595,"d":"$595"},{"$f":"C8*D8","v":null},{"v":357,"d":"$357"},{"$f":"E8-F8","v":null},{"$f":"IF(E8>0,G8/E8,0)","v":null}]
["Europe du Nord","Casque Sans Fil",217,{"v":632,"d":"$632"},{"$f":"C9*D9","v":null},{"v":379.2,"d":"$379"},{"$f":"E9-F9","v":null},{"$f":"IF(E9>0,G9/E9,0)","v":null}]
["Europe du Sud","Ordinateur Portable Premium",230,{"v":669,"d":"$669"},{"$f":"C10*D10","v":null},{"v":401.4,"d":"$401"},{"$f":"E10-F10","v":null},{"$f":"IF(E10>0,G10/E10,0)","v":null}]
["Europe du Sud","Tablette Professionnelle",243,{"v":706,"d":"$706"},{"$f":"C11*D11","v":null},{"v":423.6,"d":"$424"},{"$f":"E11-F11","v":null},{"$f":"IF(E11>0,G11/E11,0)","v":null}]
["Europe du Sud","Smartphone 5G",256,{"v":743,"d":"$743"},{"$f":"C12*D12","v":null},{"v":445.8,"d":"$446"},{"$f":"E12-F12","v":null},{"$f":"IF(E12>0,G12/E12,0)","v":null}]
["Europe du Sud","Écran 4K",269,{"v":780,"d":"$780"},{"$f":"C13*D13","v":null},{"v":468,"d":"$468"},{"$f":"E13-F13","v":null},{"$f":"IF(E13>0,G13/E13,0)","v":null}]
["Europe du Sud","Casque Sans Fil",282,{"v":817,"d":"$817"},{"$f":"C14*D14","v":null},{"v":490.2,"d":"$490"},{"$f":"E14-F14","v":null},{"$f":"IF(E14>0,G14/E14,0)","v":null}]
["Amérique du Nord","Ordinateur Portable Premium",295,{"v":854,"d":"$854"},{"$f":"C15*D15","v":null},{"v":512.4,"d":"$512"},{"$f":"E15-F15","v":null},{"$f":"IF(E15>0,G15/E15,0)","v":null}]
["Amérique du Nord","Tablette Professionnelle",308,{"v":891,"d":"$891"},{"$f":"C16*D16","v":null},{"v":534.6,"d":"$535"},{"$f":"E16-F16","v":null},{"$f":"IF(E16>0,G16/E16,0)","v":null}]
["Amérique du Nord","Smartphone 5G",321,{"v":928,"d":"$928"},{"$f":"C17*D17","v":null},{"v":556.8,"d":"$557"},{"$f":"E17-F17","v":null},{"$f":"IF(E17>0,G17/E17,0)","v":null}]
["Amérique du Nord","Écran 4K",334,{"v":965,"d":"$965"},{"$f":"C18*D18","v":null},{"v":579,"d":"$579"},{"$f":"E18-F18","v":null},{"$f":"IF(E18>0,G18/E18,0)","v":null}]
["Amérique du Nord","Casque Sans Fil",347,{"v":1002,"d":"$1,002"},{"$f":"C19*D19","v":null},{"v":601.1999999999999,"d":"$601"},{"$f":"E19-F19","v":null},{"$f":"IF(E19>0,G19/E19,0)","v":null}]
["Amérique du Sud","Ordinateur Portable Premium",360,{"v":1039,"d":"$1,039"},{"$f":"C20*D20","v":null},{"v":623.4,"d":"$623"},{"$f":"E20-F20","v":null},{"$f":"IF(E20>0,G20/E20,0)","v":null}]
["Amérique du Sud","Tablette Professionnelle",373,{"v":1076,"d":"$1,076"},{"$f":"C21*D21","v":null},{"v":645.6,"d":"$646"},{"$f":"E21-F21","v":null},{"$f":"IF(E21>0,G21/E21,0)","v":null}]
["Amérique du Sud","Smartphone 5G",386,{"v":1113,"d":"$1,113"},{"$f":"C22*D22","v":null},{"v":667.8,"d":"$668"},{"$f":"E22-F22","v":null},{"$f":"IF(E22>0,G22/E22,0)","v":null}]
["Amérique du Sud","Écran 4K",399,{"v":1150,"d":"$1,150"},{"$f":"C23*D23","v":null},{"v":690,"d":"$690"},{"$f":"E23-F23","v":null},{"$f":"IF(E23>0,G23/E23,0)","v":null}]
["Amérique du Sud","Casque Sans Fil",412,{"v":1187,"d":"$1,187"},{"$f":"C24*D24","v":null},{"v":712.1999999999999,"d":"$712"},{"$f":"E24-F24","v":null},{"$f":"IF(E24>0,G24/E24,0)","v":null}]
["Asie Pacifique","Ordinateur Portable Premium",425,{"v":1224,"d":"$1,224"},{"$f":"C25*D25","v":null},{"v":734.4,"d":"$734"},{"$f":"E25-F25","v":null},{"$f":"IF(E25>0,G25/E25,0)","v":null}]
["Asie Pacifique","Tablette Professionnelle",438,{"v":1261,"d":"$1,261"},{"$f":"C26*D26","v":null},{"v":756.6,"d":"$757"},{"$f":"E26-F26","v":null},{"$f":"IF(E26>0,G26/E26,0)","v":null}]
["Asie Pacifique","Smartphone 5G",451,{"v":1298,"d":"$1,298"},{"$f":"C27*D27","v":null},{"v":778.8,"d":"$779"},{"$f":"E27-F27","v":null},{"$f":"IF(E27>0,G27/E27,0)","v":null}]
["Asie Pacifique","Écran 4K",464,{"v":1335,"d":"$1,335"},{"$f":"C28*D28","v":null},{"v":801,"d":"$801"},{"$f":"E28-F28","v":null},{"$f":"IF(E28>0,G28/E28,0)","v":null}]
["Asie Pacifique","Casque Sans Fil",477,{"v":1372,"d":"$1,372"},{"$f":"C29*D29","v":null},{"v":823.1999999999999,"d":"$823"},{"$f":"E29-F29","v":null},{"$f":"IF(E29>0,G29/E29,0)","v":null}]
["Moyen-Orient","Ordinateur Portable Premium",490,{"v":1409,"d":"$1,409"},{"$f":"C30*D30","v":null},{"v":845.4,"d":"$845"},{"$f":"E30-F30","v":null},{"$f":"IF(E30>0,G30/E30,0)","v":null}]
["Moyen-Orient","Tablette Professionnelle",503,{"v":1446,"d":"$1,446"},{"$f":"C31*D31","v":null},{"v":867.6,"d":"$868"},{"$f":"E31-F31","v":null},{"$f":"IF(E31>0,G31/E31,0)","v":null}]
["Moyen-Orient","Smartphone 5G",516,{"v":1483,"d":"$1,483"},{"$f":"C32*D32","v":null},{"v":889.8,"d":"$890"},{"$f":"E32-F32","v":null},{"$f":"IF(E32>0,G32/E32,0)","v":null}]
["Moyen-Orient","Écran 4K",529,{"v":320,"d":"$320"},{"$f":"C33*D33","v":null},{"v":192,"d":"$192"},{"$f":"E33-F33","v":null},{"$f":"IF(E33>0,G33/E33,0)","v":null}]
["Moyen-Orient","Casque Sans Fil",542,{"v":357,"d":"$357"},{"$f":"C34*D34","v":null},{"v":214.2,"d":"$214"},{"$f":"E34-F34","v":null},{"$f":"IF(E34>0,G34/E34,0)","v":null}]
["Afrique","Ordinateur Portable Premium",555,{"v":394,"d":"$394"},{"$f":"C35*D35","v":null},{"v":236.4,"d":"$236"},{"$f":"E35-F35","v":null},{"$f":"IF(E35>0,G35/E35,0)","v":null}]
["Afrique","Tablette Professionnelle",568,{"v":431,"d":"$431"},{"$f":"C36*D36","v":null},{"v":258.6,"d":"$259"},{"$f":"E36-F36","v":null},{"$f":"IF(E36>0,G36/E36,0)","v":null}]
["Afrique","Smartphone 5G",581,{"v":468,"d":"$468"},{"$f":"C37*D37","v":null},{"v":280.8,"d":"$281"},{"$f":"E37-F37","v":null},{"$f":"IF(E37>0,G37/E37,0)","v":null}]
["Afrique","Écran 4K",594,{"v":505,"d":"$505"},{"$f":"C38*D38","v":null},{"v":303,"d":"$303"},{"$f":"E38-F38","v":null},{"$f":"IF(E38>0,G38/E38,0)","v":null}]
["Afrique","Casque Sans Fil",107,{"v":542,"d":"$542"},{"$f":"C39*D39","v":null},{"v":325.2,"d":"$325"},{"$f":"E39-F39","v":null},{"$f":"IF(E39>0,G39/E39,0)","v":null}]
[]
["TOTAL GÉNÉRAL",null,{"$f":"SUM(C5:C39)","v":null},null,{"$f":"SUM(E5:E39)","v":null},null,{"$f":"SUM(G5:G39)","v":null},{"$f":"AVERAGE(H5:H39)","v":null}]

{"sheet":"Analyses Graphiques","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"merged":[[0,0,0,3]]}
["Analyse des Performances par Région"]
[]
["Région","Total Ventes","Objectif","Écart %"]
["Europe",{"v":2500000,"d":"$2,500,000"},{"v":2200000,"d":"$2,200,000"},{"$f":"(B4-C4)/C4","v":null}]
["Amérique",{"v":3200000,"d":"$3,200,000"},{"v":3000000,"d":"$3,000,000"},{"$f":"(B5-C5)/C5","v":null}]
["Asie",{"v":2800000,"d":"$2,800,000"},{"v":2900000,"d":"$2,900,000"},{"$f":"(B6-C6)/C6","v":null}]
["Autres",{"v":1200000,"d":"$1,200,000"},{"v":1100000,"d":"$1,100,000"},{"$f":"(B7-C7)/C7","v":null}]

{"sheet":"Tendances Mensuelles","index":2,"n_rows":8,"n_cols":13,"rows_kept":8,"merged":[[0,0,0,12]]}
["Évolution Mensuelle des Ventes 2024"]
[]
["Mois","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"]
["Laptops",{"v":59872,"d":"$59,872"},{"v":64808,"d":"$64,808"},{"v":69744,"d":"$69,744"},{"v":74680,"d":"$74,680"},{"v":79616,"d":"$79,616"},{"v":54552,"d":"$54,552"},{"v":59488,"d":"$59,488"},{"v":64424,"d":"$64,424"},{"v":69360,"d":"$69,360"},{"v":74296,"d":"$74,296"},{"v":79232,"d":"$79,232"},{"v":54168,"d":"$54,168"}]
["Tablettes",{"v":62340,"d":"$62,340"},{"v":68510,"d":"$68,510"},{"v":74680,"d":"$74,680"},{"v":50850,"d":"$50,850"},{"v":57020,"d":"$57,020"},{"v":63190,"d":"$63,190"},{"v":69360,"d":"$69,360"},{"v":75530,"d":"$75,530"},{"v":51700,"d":"$51,700"},{"v":57870,"d":"$57,870"},{"v":64040,"d":"$64,040"},{"v":70210,"d":"$70,210"}]
["Smartphones",{"v":64808,"d":"$64,808"},{"v":72212,"d":"$72,212"},{"v":79616,"d":"$79,616"},{"v":57020,"d":"$57,020"},{"v":64424,"d":"$64,424"},{"v":71828,"d":"$71,828"},{"v":79232,"d":"$79,232"},{"v":56636,"d":"$56,636"},{"v":64040,"d":"$64,040"},{"v":71444,"d":"$71,444"},{"v":78848,"d":"$78,848"},{"v":56252,"d":"$56,252"}]
["Accessoires",{"v":67276,"d":"$67,276"},{"v":75914,"d":"$75,914"},{"v":54552,"d":"$54,552"},{"v":63190,"d":"$63,190"},{"v":71828,"d":"$71,828"},{"v":50466,"d":"$50,466"},{"v":59104,"d":"$59,104"},{"v":67742,"d":"$67,742"},{"v":76380,"d":"$76,380"},{"v":55018,"d":"$55,018"},{"v":63656,"d":"$63,656"},{"v":72294,"d":"$72,294"}]
["TOTAL",{"$f":"SUM(B4:B7)","v":null},{"$f":"SUM(C4:C7)","v":null},{"$f":"SUM(D4:D7)","v":null},{"$f":"SUM(E4:E7)","v":null},{"$f":"SUM(F4:F7)","v":null},{"$f":"SUM(G4:G7)","v":null},{"$f":"SUM(H4:H7)","v":null},{"$f":"SUM(I4:I7)","v":null},{"$f":"SUM(J4:J7)","v":null},{"$f":"SUM(K4:K7)","v":null},{"$f":"SUM(L4:L7)","v":null},{"$f":"SUM(M4:M7)","v":null}]