{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Ventes régionales"],"not_rendered":{"charts":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Ventes régionales","index":0,"n_rows":12,"n_cols":17,"rows_kept":12,"merged":[[0,0,0,14],[1,0,1,12],[1,13,1,14]]}
["VENTES RÉGIONALES",{"$nulls":15}," "]
["Le Graphique Ventes régionales représente les ventes de jusqu’à huit régions de janvier à décembre. Entrez les notes dans la cellule N2 à droite, et les données de ventes mensuelles dans les cellules en dessous.",{"$nulls":12},"\nNOTES :\nL’Amérique du Nord poursuit sa belle course en août, mais nous devons suivre de près l’Asie."]
["RÉGION","JAN","FÉV","MAR","AVR","MAI","JUIN","JUIL","AOÛ","SEPT","OCT","NOV","DÉC","TOTAL","%","Étiquette"]
["Amérique du Nord",{"v":23000,"d":"23,000 €"},{"v":25000,"d":"25,000 €"},{"v":19000,"d":"19,000 €"},{"v":13000,"d":"13,000 €"},{"v":18000,"d":"18,000 €"},{"v":22000,"d":"22,000 €"},{"v":26000,"d":"26,000 €"},{"$nulls":5},{"$f":"SUM('Ventes régionales'!$B4:$M4)","v":{"v":146000,"d":"146,000.00 €"}},{"$f":"'Ventes régionales'!$N4/SUM('Ventes régionales'!$N$4:$N$11)","v":{"v":0.42196531791907516,"d":"0 €"}},{"$f":"'Ventes régionales'!$A4 & \" (\" & TEXT('Ventes régionales'!$O4,\"0%\") & \")\"","v":"Amérique du Nord (42%)"}]
["Asie",{"v":14000,"d":"14,000 €"},{"v":18000,"d":"18,000 €"},{"v":14000,"d":"14,000 €"},{"v":12000,"d":"12,000 €"},{"v":14000,"d":"14,000 €"},{"v":18000,"d":"18,000 €"},{"v":12000,"d":"12,000 €"},{"$nulls":5},{"$f":"SUM('Ventes régionales'!$B5:$M5)","v":{"v":102000,"d":"102,000.00 €"}},{"$f":"'Ventes régionales'!$N5/SUM('Ventes régionales'!$N$4:$N$11)","v":{"v":0.2947976878612717,"d":"0 €"}},{"$f":"'Ventes régionales'!$A5 & \" (\" & TEXT('Ventes régionales'!$O5,\"0%\") & \")\"","v":"Asie (29%)"}]
["Europe",{"v":20000,"d":"20,000 €"},{"v":12000,"d":"12,000 €"},{"v":13000,"d":"13,000 €"},{"v":10000,"d":"10,000 €"},{"v":11000,"d":"11,000 €"},{"v":15000,"d":"15,000 €"},{"v":17000,"d":"17,000 €"},{"$nulls":5},{"$f":"SUM('Ventes régionales'!$B6:$M6)","v":{"v":98000,"d":"98,000.00 €"}},{"$f":"'Ventes régionales'!$N6/SUM('Ventes régionales'!$N$4:$N$11)","v":{"v":0.2832369942196532,"d":"0 €"}},{"$f":"'Ventes régionales'!$A6 & \" (\" & TEXT('Ventes régionales'!$O6,\"0%\") & \")\"","v":"Europe (28%)"}]
[{"$nulls":13},{"$f":"SUM('Ventes régionales'!$B7:$M7)","v":{"v":0,"d":"0.00 €"}},{"$f":"'Ventes régionales'!$N7/SUM('Ventes régionales'!$N$4:$N$11)","v":{"v":0,"d":"0 €"}},{"$f":"'Ventes régionales'!$A7 & \" (\" & TEXT('Ventes régionales'!$O7,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Ventes régionales'!$B8:$M8)","v":{"v":0,"d":"0.00 €"}},{"$f":"'Ventes régionales'!$N8/SUM('Ventes régionales'!$N$4:$N$11)","v":{"v":0,"d":"0 €"}},{"$f":"'Ventes régionales'!$A8 & \" (\" & TEXT('Ventes régionales'!$O8,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Ventes régionales'!$B9:$M9)","v":{"v":0,"d":"0.00 €"}},{"$f":"'Ventes régionales'!$N9/SUM('Ventes régionales'!$N$4:$N$11)","v":{"v":0,"d":"0 €"}},{"$f":"'Ventes régionales'!$A9 & \" (\" & TEXT('Ventes régionales'!$O9,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Ventes régionales'!$B10:$M10)","v":{"v":0,"d":"0.00 €"}},{"$f":"'Ventes régionales'!$N10/SUM('Ventes régionales'!$N$4:$N$11)","v":{"v":0,"d":"0 €"}},{"$f":"'Ventes régionales'!$A10 & \" (\" & TEXT('Ventes régionales'!$O10,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Ventes régionales'!$B11:$M11)","v":{"v":0,"d":"0.00 €"}},{"$f":"'Ventes régionales'!$N11/SUM('Ventes régionales'!$N$4:$N$11)","v":{"v":0,"d":"0 €"}},{"$f":"'Ventes régionales'!$A11 & \" (\" & TEXT('Ventes régionales'!$O11,\"0%\") & \")\"","v":" (0%)"}]
["TOTAL",{"$f":"SUBTOTAL(109,Région[JAN])","v":{"v":57000,"d":"57,000 €"}},{"$f":"SUBTOTAL(109,Région[FÉV])","v":{"v":55000,"d":"55,000 €"}},{"$f":"SUBTOTAL(109,Région[MAR])","v":{"v":46000,"d":"46,000 €"}},{"$f":"SUBTOTAL(109,Région[AVR])","v":{"v":35000,"d":"35,000 €"}},{"$f":"SUBTOTAL(109,Région[MAI])","v":{"v":43000,"d":"43,000 €"}},{"$f":"SUBTOTAL(109,Région[JUIN])","v":{"v":55000,"d":"55,000 €"}},{"$f":"SUBTOTAL(109,Région[JUIL])","v":{"v":55000,"d":"55,000 €"}},{"$f":"SUBTOTAL(109,Région[AOÛ])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Région[SEPT])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Région[OCT])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Région[NOV])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Région[DÉC])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Région[TOTAL])","v":{"v":346000,"d":"346,000.00 €"}},{"$f":"SUBTOTAL(109,Région[%])","v":{"v":1,"d":"1 €"}}]