DHTMLX Spreadsheet. Dynamic color change in themes example
This demo shows how to change DHTMLX Spreadsheet theme colors dynamically at runtime by modifying CSS HSL variables on the :root or [data-dhx-theme] selector.
Live example
const spreadsheet = new dhx.Spreadsheet("spreadsheet");
spreadsheet.parse(dataset);
spreadsheet.selection.setSelectedCell("A1:C5");
const colorpicker = new dhx.Colorpicker(null, {
css: "dhx_widget--bordered",
});
const popup = new dhx.Popup();
popup.attach(colorpicker);
popup.hide();
function showColorpicker(container) {
popup.show(container);
};
colorpicker.events.on("change", hex => {
const { h, s, l } = hexToHSLChema(hex);
const style = document.getElementById("themes");
style.textContent = `
:root, [data-dhx-theme] {
--dhx-h-primary: ${h};
--dhx-s-primary: ${s}%;
--dhx-l-primary: ${l}%;
}
`;
popup.hide();
});
function hexToHSLChema(HEX) {
let r = 0, g = 0, b = 0;
if (HEX.length == 4) {
r = "0x" + HEX[1] + HEX[1];
g = "0x" + HEX[2] + HEX[2];
b = "0x" + HEX[3] + HEX[3];
} else if (HEX.length == 7) {
r = "0x" + HEX[1] + HEX[2];
g = "0x" + HEX[3] + HEX[4];
b = "0x" + HEX[5] + HEX[6];
}
// Then to HSL
r /= 255;
g /= 255;
b /= 255;
let cmin = Math.min(r,g,b),
cmax = Math.max(r,g,b),
delta = cmax - cmin,
h = 0,
s = 0,
l = 0;
if (delta == 0)
h = 0;
else if (cmax == r)
h = ((g - b) / delta) % 6;
else if (cmax == g)
h = (b - r) / delta + 2;
else
h = (r - g) / delta + 4;
h = Math.round(h * 60);
if (h < 0) h += 360;
l = (cmax + cmin) / 2;
s = delta == 0 ? 0 : delta / (1 - Math.abs(2 * l - 1));
s = +(s * 100).toFixed(1);
l = +(l * 100).toFixed(1);
return {
h,
s,
l
}
}<!-- auxiliary controls for interacting with the sample -->
<link rel="stylesheet" href="https://snippet.dhtmlx.com/codebase/assets/css/auxiliary_controls.css">
<style id="themes"></style>
<!-- Icons -->
<link href="https://cdnjs.cloudflare.com/ajax/libs/MaterialDesign-Webfont/7.0.96/css/materialdesignicons.css"
media="all" rel="stylesheet" type="text/css">
<section class="dhx_sample-controls">
<button onclick="showColorpicker(this)" class="dhx_sample-btn dhx_sample-btn--flat">Select primary color</button>
</section>
<!-- component container -->
<section id="spreadsheet" style="height: calc(100% - 60px);"></section>
<!-- dataset -->
<script>
var dataset={
styles:{
red_text: {
"color": "#E94633"
},
bold: {
"font-weight": "bold",
},
text_end: {
"justify-content": "flex-end",
"text-align": "right",
}
},
sheets:[
{
name: "Country report",
data: [
{cell:"A1",css:"bold", value:"Country"},
{cell:"B1",css:"bold text_end",value:"Population"},
{cell:"C1",css:"bold text_end",value:"Yearly\nChange"},
{cell:"D1",css:"bold text_end",value:"Net\nChange"},
{cell:"E1",css:"bold text_end",value:"Density\n(P/KmВІ)"},
{cell:"F1",css:"bold text_end",value:"Land Area\n(KmВІ)"},
{cell:"G1",css:"bold text_end",value:"Migrants\n(net)"},
{cell:"H1",css:"bold text_end",value:"Urban\nPop %"},
{cell:"I1",css:"bold text_end",value:"World\nShare"},
{cell:"A2",css:"bold",value:"China"},
{cell:"B2", css: "text_end", value:"1,415,045,928"},
{cell:"C2", css: "text_end", value:"0.39 %"},
{cell:"D2", css: "text_end", value:"5,528,531"},
{cell:"E2", css: "text_end", value:"151"},
{cell:"F2", css: "text_end", value:"9,388,211"},
{cell:"G2", css: "text_end", value:"-339,690"},
{cell:"H2", css: "text_end", value:"58 %"},
{cell:"I2", css: "text_end", value:"18.54 %"},
{cell:"A3",css:"bold",value:"India"},
{cell:"B3", css: "text_end", value:"1,354,051,854"},
{cell:"C3", css: "text_end", value:"1.11 %"},
{cell:"D3", css: "text_end", value:"14,871,727"},
{cell:"E3", css: "text_end", value:"455"},
{cell:"F3", css: "text_end", value:"2,973,190"},
{cell:"G3", css: "text_end", value:"-515,643"},
{cell:"H3", css: "text_end", value:"32 %"},
{cell:"I3", css: "text_end", value:"17.74 %"},
{cell:"A4",css:"bold",value:"U.S."},
{cell:"B4", css: "text_end", value:"326,766,748"},
{cell:"C4", css: "text_end", value:"0.71 %"},
{cell:"D4", css: "text_end", value:"2,307,285"},
{cell:"E4", css: "text_end", value:"36"},
{cell:"F4", css: "text_end", value:"9,147,420"},
{cell:"G4", css: "text_end", value:"900,000"},
{cell:"H4", css: "text_end", value:"83 %"},
{cell:"I4", css: "text_end", value:"4.28 %"},
{cell:"A5",css:"bold",value:"Indonesia"},
{cell:"B5", css: "text_end", value:"266,794,980"},
{cell:"C5", css: "text_end", value:"1.06 %"},
{cell:"D5", css: "text_end", value:"2,803,601"},
{cell:"E5", css: "text_end", value:"147"},
{cell:"F5", css: "text_end", value:"1,811,570"},
{cell:"G5", css: "text_end", value:"-167,000"},
{cell:"H5", css: "text_end", value:"54 %"},
{cell:"I5", css: "text_end", value:"3.50 %"},
{cell:"A6",css:"bold",value:"Brazil"},
{cell:"B6", css: "text_end", value:"210,867,954"},
{cell:"C6", css: "text_end", value:"0.75 %"},
{cell:"D6", css: "text_end", value:"1,579,676"},
{cell:"E6", css: "text_end", value:"25"},
{cell:"F6", css: "text_end", value:"8,358,140"},
{cell:"G6", css: "text_end", value:"3,185"},
{cell:"H6", css: "text_end", value:"84 %"},
{cell:"I6", css: "text_end", value:"2.76 %"},
{cell:"A7",css:"bold",value:"Pakistan"},
{cell:"B7", css: "text_end", value:"200,813,818"},
{cell:"C7", css: "text_end", value:"1.93 %"},
{cell:"D7", css: "text_end", value:"3,797,863"},
{cell:"E7", css: "text_end", value:"260"},
{cell:"F7", css: "text_end", value:"770,880"},
{cell:"G7", css: "text_end", value:"-236,384"},
{cell:"H7", css: "text_end", value:"38 %"},
{cell:"I7", css: "text_end", value:"2.63 %"},
{cell:"A8",css:"bold",value:"Nigeria"},
{cell:"B8", css: "text_end", value:"195,875,237"},
{cell:"C8", css: "text_end", value:"2.61 %"},
{cell:"D8", css: "text_end", value:"4,988,926"},
{cell:"E8", css: "text_end", value:"215"},
{cell:"F8", css: "text_end", value:"910,770"},
{cell:"G8", css: "text_end", value:"-60,000"},
{cell:"H8", css: "text_end", value:"49 %"},
{cell:"I8", css: "text_end", value:"2.57 %"},
{cell:"A9",css:"bold",value:"Bangladesh"},
{cell:"B9", css: "text_end", value:"166,368,149"},
{cell:"C9", css: "text_end", value:"1.03 %"},
{cell:"D9", css: "text_end", value:"1,698,398"},
{cell:"E9", css: "text_end", value:"1,278"},
{cell:"F9", css: "text_end", value:"130,170"},
{cell:"G9", css: "text_end", value:"-505,297"},
{cell:"H9", css: "text_end", value:"35 %"},
{cell:"I9", css: "text_end", value:"2.18 %"},
{cell:"A10",css:"bold",value:"Russia"},
{cell:"B10", css: "text_end", value:"143,964,709"},
{cell:"C10", css: "text_end", value:"-0.02 %"},
{cell:"D10", css: "text_end", value:"-25,045"},
{cell:"E10", css: "text_end", value:"9"},
{cell:"F10", css: "text_end", value:"16,376,870"},
{cell:"G10", css: "text_end", value:"203,577"},
{cell:"H10", css: "text_end", value:"73 %"},
{cell:"I10", css: "text_end", value:"1.89 %"},
{cell:"A11",css:"bold",value:"Mexico"},
{cell:"B11", css: "text_end", value:"130,759,074"},
{cell:"C11", css: "text_end", value:"1.24 %"},
{cell:"D11", css: "text_end", value:"1,595,798"},
{cell:"E11", css: "text_end", value:"67"},
{cell:"F11", css: "text_end", value:"1,943,950"},
{cell:"G11", css: "text_end", value:"-60,000"},
{cell:"H11", css: "text_end", value:"78 %"},
{cell:"I11", css: "text_end", value:"1.71 %"},
{cell:"A12",css:"bold",value:"Japan"},
{cell:"B12", css: "text_end", value:"127,185,332"},
{cell:"C12", css: "text_end", value:"-0.23 %"},
{cell:"D12", css: "text_end", value:"-299,118"},
{cell:"E12", css: "text_end", value:"349"},
{cell:"F12", css: "text_end", value:"364,555"},
{cell:"G12", css: "text_end", value:"71,627"},
{cell:"H12", css: "text_end", value:"94 %"},
{cell:"I12", css: "text_end", value:"1.67 %"},
{cell:"A13",css:"bold",value:"Ethiopia"},
{cell:"B13", css: "text_end", value:"107,534,882"},
{cell:"C13", css: "text_end", value:"2.46 %"},
{cell:"D13", css: "text_end", value:"2,577,444"},
{cell:"E13", css: "text_end", value:"108"},
{cell:"F13", css: "text_end", value:"1,000,000"},
{cell:"G13", css: "text_end", value:"-12,000"},
{cell:"H13", css: "text_end", value:"20 %"},
{cell:"I13", css: "text_end", value:"1.41 %"},
{cell:"A14",css:"bold",value:"Philippines"},
{cell:"B14", css: "text_end", value:"106,512,074"},
{cell:"C14", css: "text_end", value:"1.52 %"},
{cell:"D14", css: "text_end", value:"1,593,984"},
{cell:"E14", css: "text_end", value:"357"},
{cell:"F14", css: "text_end", value:"298,170"},
{cell:"G14", css: "text_end", value:"-130,000"},
{cell:"H14", css: "text_end", value:"44 %"},
{cell:"I14", css: "text_end", value:"1.40 %"},
{cell:"A15",css:"bold",value:"Egypt"},
{cell:"B15", css: "text_end", value:"99,375,741"},
{cell:"C15", css: "text_end", value:"1.87 %"},
{cell:"D15", css: "text_end", value:"1,822,590"},
{cell:"E15", css: "text_end", value:"100"},
{cell:"F15", css: "text_end", value:"995,450"},
{cell:"G15", css: "text_end", value:"-55,005"},
{cell:"H15", css: "text_end", value:"38 %"},
{cell:"I15", css: "text_end", value:"1.30 %"},
{cell:"A16",css:"bold",value:"Viet Nam"},
{cell:"B16", css: "text_end", value:"96,491,146"},
{cell:"C16", css: "text_end", value:"0.99 %"},
{cell:"D16", css: "text_end", value:"950,346"},
{cell:"E16", css: "text_end", value:"311"},
{cell:"F16", css: "text_end", value:"310,070"},
{cell:"G16", css: "text_end", value:"-40,000"},
{cell:"H16", css: "text_end", value:"34 %"},
{cell:"I16", css: "text_end", value:"1.26 %"},
{cell:"A17",css:"bold",value:"DR Congo"},
{cell:"B17", css: "text_end", value:"84,004,989"},
{cell:"C17", css: "text_end", value:"3.28 %"},
{cell:"D17", css: "text_end", value:"2,665,001"},
{cell:"E17", css: "text_end", value:"37"},
{cell:"F17", css: "text_end", value:"2,267,050"},
{cell:"G17", css: "text_end", value:"3,012"},
{cell:"H17", css: "text_end", value:"39 %"},
{cell:"I17", css: "text_end", value:"1.10 %"},
{cell:"A18",css:"bold",value:"Germany"},
{cell:"B18", css: "text_end", value:"82,293,457"},
{cell:"C18", css: "text_end", value:"0.22 %"},
{cell:"D18", css: "text_end", value:"179,233"},
{cell:"E18", css: "text_end", value:"236"},
{cell:"F18", css: "text_end", value:"348,560"},
{cell:"G18", css: "text_end", value:"355,425"},
{cell:"H18", css: "text_end", value:"76 %"},
{cell:"I18", css: "text_end", value:"1.08 %"},
{cell:"A19",css:"bold",value:"Iran"},
{cell:"B19", css: "text_end", value:"82,011,735"},
{cell:"C19", css: "text_end", value:"1.05 %"},
{cell:"D19", css: "text_end", value:"848,947"},
{cell:"E19", css: "text_end", value:"50"},
{cell:"F19", css: "text_end", value:"1,628,550"},
{cell:"G19", css: "text_end", value:"-80,000"},
{cell:"H19", css: "text_end", value:"74 %"},
{cell:"I19", css: "text_end", value:"1.07 %"},
{cell:"A20",css:"bold",value:"Turkey"},
{cell:"B20", css: "text_end", value:"81,916,871"},
{cell:"C20", css: "text_end", value:"1.45 %"},
{cell:"D20", css: "text_end", value:"1,171,851"},
{cell:"E20", css: "text_end", value:"106"},
{cell:"F20", css: "text_end", value:"769,630"},
{cell:"G20", css: "text_end", value:"325,434"},
{cell:"H20", css: "text_end", value:"71 %"},
{cell:"I20", css: "text_end", value:"1.07 %"},
{cell:"A21",css:"bold",value:"Thailand"},
{cell:"B21", css: "text_end", value:"69,183,173"},
{cell:"C21", css: "text_end", value:"0.21 %"},
{cell:"D21", css: "text_end", value:"145,660"},
{cell:"E21", css: "text_end", value:"135"},
{cell:"F21", css: "text_end", value:"510,890"},
{cell:"G21", css: "text_end", value:"33,463"},
{cell:"H21", css: "text_end", value:"52 %"},
{cell:"I21", css: "text_end", value:"0.91 %"},
{cell:"A22",css:"bold",value:"U.K."},
{cell:"B22", css: "text_end", value:"66,573,504"},
{cell:"C22", css: "text_end", value:"0.59 %"},
{cell:"D22", css: "text_end", value:"391,919"},
{cell:"E22", css: "text_end", value:"275"},
{cell:"F22", css: "text_end", value:"241,930"},
{cell:"G22", css: "text_end", value:"198,000"},
{cell:"H22", css: "text_end", value:"81 %"},
{cell:"I22", css: "text_end", value:"0.87 %"},
{cell:"A23",css:"bold",value:"France"},
{cell:"B23", css: "text_end", value:"65,233,271"},
{cell:"C23", css: "text_end", value:"0.39 %"},
{cell:"D23", css: "text_end", value:"253,723"},
{cell:"E23", css: "text_end", value:"119"},
{cell:"F23", css: "text_end", value:"547,557"},
{cell:"G23", css: "text_end", value:"72,344"},
{cell:"H23", css: "text_end", value:"80 %"},
{cell:"I23", css: "text_end", value:"0.85 %"},
{cell:"A24",css:"bold",value:"Italy"},
{cell:"B24", css: "text_end", value:"59,290,969"},
{cell:"C24", css: "text_end", value:"-0.12 %"},
{cell:"D24", css: "text_end", value:"-68,931"},
{cell:"E24", css: "text_end", value:"202"},
{cell:"F24", css: "text_end", value:"294,140"},
{cell:"G24", css: "text_end", value:"52,829"},
{cell:"H24", css: "text_end", value:"72 %"},
{cell:"I24", css: "text_end", value:"0.78 %"},
{cell:"A25",css:"bold",value:"Tanzania"},
{cell:"B25", css: "text_end", value:"59,091,392"},
{cell:"C25", css: "text_end", value:"3.11 %"},
{cell:"D25", css: "text_end", value:"1,781,373"},
{cell:"E25", css: "text_end", value:"67"},
{cell:"F25", css: "text_end", value:"885,800"},
{cell:"G25", css: "text_end", value:"-40,000"},
{cell:"H25", css: "text_end", value:"31 %"},
{cell:"I25", css: "text_end", value:"0.77 %"},
{cell:"A26",css:"bold",value:"South Africa"},
{cell:"B26", css: "text_end", value:"57,398,421"},
{cell:"C26", css: "text_end", value:"1.20 %"},
{cell:"D26", css: "text_end", value:"681,265"},
{cell:"E26", css: "text_end", value:"47"},
{cell:"F26", css: "text_end", value:"1,213,090"},
{cell:"G26", css: "text_end", value:"161,300"},
{cell:"H26", css: "text_end", value:"62 %"},
{cell:"I26", css: "text_end", value:"0.75 %"},
{cell:"A27",css:"bold",value:"Myanmar"},
{cell:"B27", css: "text_end", value:"53,855,735"},
{cell:"C27", css: "text_end", value:"0.91 %"},
{cell:"D27", css: "text_end", value:"485,126"},
{cell:"E27", css: "text_end", value:"82"},
{cell:"F27", css: "text_end", value:"653,290"},
{cell:"G27", css: "text_end", value:"-94,856"},
{cell:"H27", css: "text_end", value:"36 %"},
{cell:"I27", css: "text_end", value:"0.71 %"},
{cell:"A28",css:"bold",value:"South Korea"},
{cell:"B28", css: "text_end", value:"51,164,435"},
{cell:"C28", css: "text_end", value:"0.36 %"},
{cell:"D28", css: "text_end", value:"182,223"},
{cell:"E28", css: "text_end", value:"526"},
{cell:"F28", css: "text_end", value:"97,230"},
{cell:"G28", css: "text_end", value:"33,927"},
{cell:"H28", css: "text_end", value:"81 %"},
{cell:"I28", css: "text_end", value:"0.67 %"},
{cell:"A29",css:"bold",value:"Kenya"},
{cell:"B29", css: "text_end", value:"50,950,879"},
{cell:"C29", css: "text_end", value:"2.52 %"},
{cell:"D29", css: "text_end", value:"1,251,017"},
{cell:"E29", css: "text_end", value:"90"},
{cell:"F29", css: "text_end", value:"569,140"},
{cell:"G29", css: "text_end", value:"-10,000"},
{cell:"H29", css: "text_end", value:"26 %"},
{cell:"I29", css: "text_end", value:"0.67 %"},
{cell:"A30",css:"bold",value:"Colombia"},
{cell:"B30", css: "text_end", value:"49,464,683"},
{cell:"C30", css: "text_end", value:"0.81 %"},
{cell:"D30", css: "text_end", value:"399,068"},
{cell:"E30", css: "text_end", value:"45"},
{cell:"F30", css: "text_end", value:"1,109,500"},
{cell:"G30", css: "text_end", value:"-29,000"},
{cell:"H30", css: "text_end", value:"79 %"},
{cell:"I30", css: "text_end", value:"0.65 %"},
{cell:"A31",css:"bold",value:"Spain"},
{cell:"B31", css: "text_end", value:"46,397,452"},
{cell:"C31", css: "text_end", value:"0.09 %"},
{cell:"D31", css: "text_end", value:"43,131"},
{cell:"E31", css: "text_end", value:"93"},
{cell:"F31", css: "text_end", value:"498,800"},
{cell:"G31", css: "text_end", value:"-114,000"},
{cell:"H31", css: "text_end", value:"82 %"},
{cell:"I31", css: "text_end", value:"0.61 %"},
{cell:"A32",css:"bold",value:"Argentina"},
{cell:"B32", css: "text_end", value:"44,688,864"},
{cell:"C32", css: "text_end", value:"0.94 %"},
{cell:"D32", css: "text_end", value:"417,823"},
{cell:"E32", css: "text_end", value:"16"},
{cell:"F32", css: "text_end", value:"2,736,690"},
{cell:"G32", css: "text_end", value:"6,000"},
{cell:"H32", css: "text_end", value:"88 %"},
{cell:"I32", css: "text_end", value:"0.59 %"},
{cell:"A33",css:"bold",value:"Uganda"},
{cell:"B33", css: "text_end", value:"44,270,563"},
{cell:"C33", css: "text_end", value:"3.28 %"},
{cell:"D33", css: "text_end", value:"1,407,605"},
{cell:"E33", css: "text_end", value:"222"},
{cell:"F33", css: "text_end", value:"199,810"},
{cell:"G33", css: "text_end", value:"-30,000"},
{cell:"H33", css: "text_end", value:"16 %"},
{cell:"I33", css: "text_end", value:"0.58 %"},
{cell:"A34",css:"bold",value:"Ukraine"},
{cell:"B34", css: "text_end", value:"44,009,214"},
{cell:"C34", css: "text_end", value:"-0.48 %"},
{cell:"D34", css: "text_end", value:"-213,733"},
{cell:"E34", css: "text_end", value:"76"},
{cell:"F34", css: "text_end", value:"579,320"},
{cell:"G34", css: "text_end", value:"-40,000"},
{cell:"H34", css: "text_end", value:"70 %"},
{cell:"I34", css: "text_end", value:"0.58 %"},
{cell:"A35",css:"bold",value:"Algeria"},
{cell:"B35", css: "text_end", value:"42,008,054"},
{cell:"C35", css: "text_end", value:"1.67 %"},
{cell:"D35", css: "text_end", value:"689,912"},
{cell:"E35", css: "text_end", value:"18"},
{cell:"F35", css: "text_end", value:"2,381,740"},
{cell:"G35", css: "text_end", value:"-28,654"},
{cell:"H35", css: "text_end", value:"72 %"},
{cell:"I35", css: "text_end", value:"0.55 %"},
{cell:"A36",css:"bold",value:"Sudan"},
{cell:"B36", css: "text_end", value:"41,511,526"},
{cell:"C36", css: "text_end", value:"2.41 %"},
{cell:"D36", css: "text_end", value:"978,196"},
{cell:"E36", css: "text_end", value:"24"},
{cell:"F36", css: "text_end", value:"1,765,048"},
{cell:"G36", css: "text_end", value:"-117,877"},
{cell:"H36", css: "text_end", value:"34 %"},
{cell:"I36", css: "text_end", value:"0.54 %"},
{cell:"A37",css:"bold",value:"Iraq"},
{cell:"B37", css: "text_end", value:"39,339,753"},
{cell:"C37", css: "text_end", value:"2.78 %"},
{cell:"D37", css: "text_end", value:"1,065,135"},
{cell:"E37", css: "text_end", value:"91"},
{cell:"F37", css: "text_end", value:"434,320"},
{cell:"G37", css: "text_end", value:"92,733"},
{cell:"H37", css: "text_end", value:"67 %"},
{cell:"I37", css: "text_end", value:"0.52 %"},
{cell:"A38",css:"bold",value:"Poland"},
{cell:"B38", css: "text_end", value:"38,104,832"},
{cell:"C38", css: "text_end", value:"-0.17 %"},
{cell:"D38", css: "text_end", value:"-65,880"},
{cell:"E38", css: "text_end", value:"124"},
{cell:"F38", css: "text_end", value:"306,230"},
{cell:"G38", css: "text_end", value:"-14,799"},
{cell:"H38", css: "text_end", value:"61 %"},
{cell:"I38", css: "text_end", value:"0.50 %"},
{cell:"A39",css:"bold",value:"Canada"},
{cell:"B39", css: "text_end", value:"36,953,765"},
{cell:"C39", css: "text_end", value:"0.90 %"},
{cell:"D39", css: "text_end", value:"329,566"},
{cell:"E39", css: "text_end", value:"4"},
{cell:"F39", css: "text_end", value:"9,093,510"},
{cell:"G39", css: "text_end", value:"229,144"},
{cell:"H39", css: "text_end", value:"81 %"},
{cell:"I39", css: "text_end", value:"0.48 %"},
{cell:"A40",css:"bold",value:"Afghanistan"},
{cell:"B40", css: "text_end", value:"36,373,176"},
{cell:"C40", css: "text_end", value:"2.37 %"},
{cell:"D40", css: "text_end", value:"843,095"},
{cell:"E40", css: "text_end", value:"56"},
{cell:"F40", css: "text_end", value:"652,860"},
{cell:"G40", css: "text_end", value:"89,601"},
{cell:"H40", css: "text_end", value:"25 %"},
{cell:"I40", css: "text_end", value:"0.48 %"},
{cell:"A41",css:"bold",value:"Morocco"},
{cell:"B41", css: "text_end", value:"36,191,805"},
{cell:"C41", css: "text_end", value:"1.27 %"},
{cell:"D41", css: "text_end", value:"452,225"},
{cell:"E41", css: "text_end", value:"81"},
{cell:"F41", css: "text_end", value:"446,300"},
{cell:"G41", css: "text_end", value:"-61,422"},
{cell:"H41", css: "text_end", value:"59 %"},
{cell:"I41", css: "text_end", value:"0.47 %"},
{cell:"A42",css:"bold",value:"Saudi Arabia"},
{cell:"B42", css: "text_end", value:"33,554,343"},
{cell:"C42", css: "text_end", value:"1.87 %"},
{cell:"D42", css: "text_end", value:"616,130"},
{cell:"E42", css: "text_end", value:"16"},
{cell:"F42", css: "text_end", value:"2,149,690"},
{cell:"G42", css: "text_end", value:"318,000"},
{cell:"H42", css: "text_end", value:"77 %"},
{cell:"I42", css: "text_end", value:"0.44 %"},
{cell:"A43",css:"bold",value:"Peru"},
{cell:"B43", css: "text_end", value:"32,551,815"},
{cell:"C43", css: "text_end", value:"1.20 %"},
{cell:"D43", css: "text_end", value:"386,330"},
{cell:"E43", css: "text_end", value:"25"},
{cell:"F43", css: "text_end", value:"1,280,000"},
{cell:"G43", css: "text_end", value:"-48,000"},
{cell:"H43", css: "text_end", value:"78 %"},
{cell:"I43", css: "text_end", value:"0.43 %"},
{cell:"A44",css:"bold",value:"Venezuela"},
{cell:"B44", css: "text_end", value:"32,381,221"},
{cell:"C44", css: "text_end", value:"1.26 %"},
{cell:"D44", css: "text_end", value:"404,156"},
{cell:"E44", css: "text_end", value:"37"},
{cell:"F44", css: "text_end", value:"882,050"},
{cell:"G44", css: "text_end", value:"-13,824"},
{cell:"H44", css: "text_end", value:"88 %"},
{cell:"I44", css: "text_end", value:"0.42 %"},
{cell:"A45",css:"bold",value:"Uzbekistan"},
{cell:"B45", css: "text_end", value:"32,364,996"},
{cell:"C45", css: "text_end", value:"1.42 %"},
{cell:"D45", css: "text_end", value:"454,355"},
{cell:"E45", css: "text_end", value:"76"},
{cell:"F45", css: "text_end", value:"425,400"},
{cell:"G45", css: "text_end", value:"-13,294"},
{cell:"H45", css: "text_end", value:"34 %"},
{cell:"I45", css: "text_end", value:"0.42 %"},
{cell:"A46",css:"bold",value:"Malaysia"},
{cell:"B46", css: "text_end", value:"32,042,458"},
{cell:"C46", css: "text_end", value:"1.32 %"},
{cell:"D46", css: "text_end", value:"418,194"},
{cell:"E46", css: "text_end", value:"98"},
{cell:"F46", css: "text_end", value:"328,550"},
{cell:"G46", css: "text_end", value:"156,330"},
{cell:"H46", css: "text_end", value:"75 %"},
{cell:"I46", css: "text_end", value:"0.42 %"},
{cell:"A47",css:"bold",value:"Angola"},
{cell:"B47", css: "text_end", value:"30,774,205"},
{cell:"C47", css: "text_end", value:"3.32 %"},
{cell:"D47", css: "text_end", value:"990,012"},
{cell:"E47", css: "text_end", value:"25"},
{cell:"F47", css: "text_end", value:"1,246,700"},
{cell:"G47", css: "text_end", value:"17,464"},
{cell:"H47", css: "text_end", value:"36 %"},
{cell:"I47", css: "text_end", value:"0.40 %"},
{cell:"A48",css:"bold",value:"Mozambique"},
{cell:"B48", css: "text_end", value:"30,528,673"},
{cell:"C48", css: "text_end", value:"2.90 %"},
{cell:"D48", css: "text_end", value:"859,839"},
{cell:"E48", css: "text_end", value:"39"},
{cell:"F48", css: "text_end", value:"786,380"},
{cell:"G48", css: "text_end", value:"-5,000"},
{cell:"H48", css: "text_end", value:"31 %"},
{cell:"I48", css: "text_end", value:"0.40 %"},
{cell:"A49",css:"bold",value:"Nepal"},
{cell:"B49", css: "text_end", value:"29,624,035"},
{cell:"C49", css: "text_end", value:"1.09 %"},
{cell:"D49", css: "text_end", value:"319,037"},
{cell:"E49", css: "text_end", value:"207"},
{cell:"F49", css: "text_end", value:"143,350"},
{cell:"G49", css: "text_end", value:"-74,474"},
{cell:"H49", css: "text_end", value:"19 %"},
{cell:"I49", css: "text_end", value:"0.39 %"},
{cell:"A50",css:"bold",value:"Ghana"},
{cell:"B50", css: "text_end", value:"29,463,643"},
{cell:"C50", css: "text_end", value:"2.18 %"},
{cell:"D50", css: "text_end", value:"630,014"},
{cell:"E50", css: "text_end", value:"129"},
{cell:"F50", css: "text_end", value:"227,540"},
{cell:"G50", css: "text_end", value:"-10,000"},
{cell:"H50", css: "text_end", value:"53 %"},
{cell:"I50", css: "text_end", value:"0.39 %"},
{cell:"A51",css:"bold",value:"Yemen"},
{cell:"B51", css: "text_end", value:"28,915,284"},
{cell:"C51", css: "text_end", value:"2.35 %"},
{cell:"D51", css: "text_end", value:"664,864"},
{cell:"E51", css: "text_end", value:"55"},
{cell:"F51", css: "text_end", value:"527,970"},
{cell:"G51", css: "text_end", value:"-15,002"},
{cell:"H51", css: "text_end", value:"33 %"},
{cell:"I51", css: "text_end", value:"0.38 %"},
{cell:"A52",css:"bold",value:"Madagascar"},
{cell:"B52", css: "text_end", value:"26,262,810"},
{cell:"C52", css: "text_end", value:"2.71 %"},
{cell:"D52", css: "text_end", value:"691,915"},
{cell:"E52", css: "text_end", value:"45"},
{cell:"F52", css: "text_end", value:"581,795"},
{cell:"G52", css: "text_end", value:"-1,500"},
{cell:"H52", css: "text_end", value:"35 %"},
{cell:"I52", css: "text_end", value:"0.34 %"},
{cell:"A53",css:"bold",value:"North Korea"},
{cell:"B53", css: "text_end", value:"25,610,672"},
{cell:"C53", css: "text_end", value:"0.47 %"},
{cell:"D53", css: "text_end", value:"119,707"},
{cell:"E53", css: "text_end", value:"213"},
{cell:"F53", css: "text_end", value:"120,410"},
{cell:"G53", css: "text_end", value:"-5,403"},
{cell:"H53", css: "text_end", value:"61 %"},
{cell:"I53", css: "text_end", value:"0.34 %"},
{cell:"A54",css:"bold",value:"CГґte d'Ivoire"},
{cell:"B54", css: "text_end", value:"24,905,843"},
{cell:"C54", css: "text_end", value:"2.52 %"},
{cell:"D54", css: "text_end", value:"611,093"},
{cell:"E54", css: "text_end", value:"78"},
{cell:"F54", css: "text_end", value:"318,000"},
{cell:"G54", css: "text_end", value:"12,000"},
{cell:"H54", css: "text_end", value:"50 %"},
{cell:"I54", css: "text_end", value:"0.33 %"},
{cell:"A55",css:"bold",value:"Australia"},
{cell:"B55", css: "text_end", value:"24,772,247"},
{cell:"C55", css: "text_end", value:"1.32 %"},
{cell:"D55", css: "text_end", value:"321,686"},
{cell:"E55", css: "text_end", value:"3"},
{cell:"F55", css: "text_end", value:"7,682,300"},
{cell:"G55", css: "text_end", value:"182,621"},
{cell:"H55", css: "text_end", value:"89 %"},
{cell:"I55", css: "text_end", value:"0.32 %"},
{cell:"A56",css:"bold",value:"Cameroon"},
{cell:"B56", css: "text_end", value:"24,678,234"},
{cell:"C56", css: "text_end", value:"2.60 %"},
{cell:"D56", css: "text_end", value:"624,507"},
{cell:"E56", css: "text_end", value:"52"},
{cell:"F56", css: "text_end", value:"472,710"},
{cell:"G56", css: "text_end", value:"-7,200"},
{cell:"H56", css: "text_end", value:"55 %"},
{cell:"I56", css: "text_end", value:"0.32 %"},
{cell:"A57",css:"bold",value:"Taiwan"},
{cell:"B57", css: "text_end", value:"23,694,089"},
{cell:"C57", css: "text_end", value:"0.29 %"},
{cell:"D57", css: "text_end", value:"67,633"},
{cell:"E57", css: "text_end", value:"669"},
{cell:"F57", css: "text_end", value:"35,410"},
{cell:"G57", css: "text_end", value:"34,000"},
{cell:"H57", css: "text_end", value:"77 %"},
{cell:"I57", css: "text_end", value:"0.31 %"},
{cell:"A58",css:"bold",value:"Niger"},
{cell:"B58", css: "text_end", value:"22,311,375"},
{cell:"C58", css: "text_end", value:"3.88 %"},
{cell:"D58", css: "text_end", value:"834,027"},
{cell:"E58", css: "text_end", value:"18"},
{cell:"F58", css: "text_end", value:"1,266,700"},
{cell:"G58", css: "text_end", value:"-5,699"},
{cell:"H58", css: "text_end", value:"18 %"},
{cell:"I58", css: "text_end", value:"0.29 %"},
{cell:"A59",css:"bold",value:"Sri Lanka"},
{cell:"B59", css: "text_end", value:"20,950,041"},
{cell:"C59", css: "text_end", value:"0.35 %"},
{cell:"D59", css: "text_end", value:"73,124"},
{cell:"E59", css: "text_end", value:"334"},
{cell:"F59", css: "text_end", value:"62,710"},
{cell:"G59", css: "text_end", value:"-96,954"},
{cell:"H59", css: "text_end", value:"19 %"},
{cell:"I59", css: "text_end", value:"0.27 %"},
{cell:"A60",css:"bold",value:"Burkina Faso"},
{cell:"B60", css: "text_end", value:"19,751,651"},
{cell:"C60", css: "text_end", value:"2.91 %"},
{cell:"D60", css: "text_end", value:"558,269"},
{cell:"E60", css: "text_end", value:"72"},
{cell:"F60", css: "text_end", value:"273,600"},
{cell:"G60", css: "text_end", value:"-25,000"},
{cell:"H60", css: "text_end", value:"30 %"},
{cell:"I60", css: "text_end", value:"0.26 %"},
{cell:"A61",css:"bold",value:"Romania"},
{cell:"B61", css: "text_end", value:"19,580,634"},
{cell:"C61", css: "text_end", value:"-0.50 %"},
{cell:"D61", css: "text_end", value:"-98,672"},
{cell:"E61", css: "text_end", value:"85"},
{cell:"F61", css: "text_end", value:"230,170"},
{cell:"G61", css: "text_end", value:"-59,999"},
{cell:"H61", css: "text_end", value:"60 %"},
{cell:"I61", css: "text_end", value:"0.26 %"},
{cell:"A62",css:"bold",value:"Malawi"},
{cell:"B62", css: "text_end", value:"19,164,728"},
{cell:"C62", css: "text_end", value:"2.91 %"},
{cell:"D62", css: "text_end", value:"542,624"},
{cell:"E62", css: "text_end", value:"203"},
{cell:"F62", css: "text_end", value:"94,280"},
{cell:"G62", css: "text_end", value:"-6,000"},
{cell:"H62", css: "text_end", value:"16 %"},
{cell:"I62", css: "text_end", value:"0.25 %"},
{cell:"A63",css:"bold",value:"Mali"},
{cell:"B63", css: "text_end", value:"19,107,706"},
{cell:"C63", css: "text_end", value:"3.05 %"},
{cell:"D63", css: "text_end", value:"565,726"},
{cell:"E63", css: "text_end", value:"16"},
{cell:"F63", css: "text_end", value:"1,220,190"},
{cell:"G63", css: "text_end", value:"-60,490"},
{cell:"H63", css: "text_end", value:"38 %"},
{cell:"I63", css: "text_end", value:"0.25 %"},
{cell:"A64",css:"bold",value:"Kazakhstan"},
{cell:"B64", css: "text_end", value:"18,403,860"},
{cell:"C64", css: "text_end", value:"1.10 %"},
{cell:"D64", css: "text_end", value:"199,361"},
{cell:"E64", css: "text_end", value:"7"},
{cell:"F64", css: "text_end", value:"2,699,700"},
{cell:"G64", css: "text_end", value:"31,961"},
{cell:"H64", css: "text_end", value:"49 %"},
{cell:"I64", css: "text_end", value:"0.24 %"},
{cell:"A65",css:"bold",value:"Syria"},
{cell:"B65", css: "text_end", value:"18,284,407"},
{cell:"C65", css: "text_end", value:"0.08 %"},
{cell:"D65", css: "text_end", value:"14,539"},
{cell:"E65", css: "text_end", value:"100"},
{cell:"F65", css: "text_end", value:"183,630"},
{cell:"G65", css: "text_end", value:"-831,579"},
{cell:"H65", css: "text_end", value:"75 %"},
{cell:"I65", css: "text_end", value:"0.24 %"},
{cell:"A66",css:"bold",value:"Chile"},
{cell:"B66", css: "text_end", value:"18,197,209"},
{cell:"C66", css: "text_end", value:"0.79 %"},
{cell:"D66", css: "text_end", value:"142,483"},
{cell:"E66", css: "text_end", value:"24"},
{cell:"F66", css: "text_end", value:"743,532"},
{cell:"G66", css: "text_end", value:"16,164"},
{cell:"H66", css: "text_end", value:"90 %"},
{cell:"I66", css: "text_end", value:"0.24 %"},
{cell:"A67",css:"bold",value:"Zambia"},
{cell:"B67", css: "text_end", value:"17,609,178"},
{cell:"C67", css: "text_end", value:"3.01 %"},
{cell:"D67", css: "text_end", value:"515,048"},
{cell:"E67", css: "text_end", value:"24"},
{cell:"F67", css: "text_end", value:"743,390"},
{cell:"G67", css: "text_end", value:"-6,898"},
{cell:"H67", css: "text_end", value:"39 %"},
{cell:"I67", css: "text_end", value:"0.23 %"},
{cell:"A68",css:"bold",value:"Guatemala"},
{cell:"B68", css: "text_end", value:"17,245,346"},
{cell:"C68", css: "text_end", value:"1.96 %"},
{cell:"D68", css: "text_end", value:"331,843"},
{cell:"E68", css: "text_end", value:"161"},
{cell:"F68", css: "text_end", value:"107,160"},
{cell:"G68", css: "text_end", value:"-10,026"},
{cell:"H68", css: "text_end", value:"52 %"},
{cell:"I68", css: "text_end", value:"0.23 %"},
{cell:"A69",css:"bold",value:"Netherlands"},
{cell:"B69", css: "text_end", value:"17,084,459"},
{cell:"C69", css: "text_end", value:"0.28 %"},
{cell:"D69", css: "text_end", value:"48,521"},
{cell:"E69", css: "text_end", value:"507"},
{cell:"F69", css: "text_end", value:"33,720"},
{cell:"G69", css: "text_end", value:"12,537"},
{cell:"H69", css: "text_end", value:"91 %"},
{cell:"I69", css: "text_end", value:"0.22 %"},
{cell:"A70",css:"bold",value:"Zimbabwe"},
{cell:"B70", css: "text_end", value:"16,913,261"},
{cell:"C70", css: "text_end", value:"2.32 %"},
{cell:"D70", css: "text_end", value:"383,357"},
{cell:"E70", css: "text_end", value:"44"},
{cell:"F70", css: "text_end", value:"386,850"},
{cell:"G70", css: "text_end", value:"-50,000"},
{cell:"H70", css: "text_end", value:"30 %"},
{cell:"I70", css: "text_end", value:"0.22 %"},
{cell:"A71",css:"bold",value:"Ecuador"},
{cell:"B71", css: "text_end", value:"16,863,425"},
{cell:"C71", css: "text_end", value:"1.44 %"},
{cell:"D71", css: "text_end", value:"238,567"},
{cell:"E71", css: "text_end", value:"68"},
{cell:"F71", css: "text_end", value:"248,360"},
{cell:"G71", css: "text_end", value:"-7,600"},
{cell:"H71", css: "text_end", value:"64 %"},
{cell:"I71", css: "text_end", value:"0.22 %"},
{cell:"A72",css:"bold",value:"Senegal"},
{cell:"B72", css: "text_end", value:"16,294,270"},
{cell:"C72", css: "text_end", value:"2.80 %"},
{cell:"D72", css: "text_end", value:"443,703"},
{cell:"E72", css: "text_end", value:"85"},
{cell:"F72", css: "text_end", value:"192,530"},
{cell:"G72", css: "text_end", value:"-19,999"},
{cell:"H72", css: "text_end", value:"43 %"},
{cell:"I72", css: "text_end", value:"0.21 %"},
{cell:"A73",css:"bold",value:"Cambodia"},
{cell:"B73", css: "text_end", value:"16,245,729"},
{cell:"C73", css: "text_end", value:"1.50 %"},
{cell:"D73", css: "text_end", value:"240,356"},
{cell:"E73", css: "text_end", value:"92"},
{cell:"F73", css: "text_end", value:"176,520"},
{cell:"G73", css: "text_end", value:"-30,000"},
{cell:"H73", css: "text_end", value:"21 %"},
{cell:"I73", css: "text_end", value:"0.21 %"},
{cell:"A74",css:"bold",value:"Chad"},
{cell:"B74", css: "text_end", value:"15,353,184"},
{cell:"C74", css: "text_end", value:"3.04 %"},
{cell:"D74", css: "text_end", value:"453,190"},
{cell:"E74", css: "text_end", value:"12"},
{cell:"F74", css: "text_end", value:"1,259,200"},
{cell:"G74", css: "text_end", value:"20,000"},
{cell:"H74", css: "text_end", value:"21 %"},
{cell:"I74", css: "text_end", value:"0.20 %"},
{cell:"A75",css:"bold",value:"Somalia"},
{cell:"B75", css: "text_end", value:"15,181,925"},
{cell:"C75", css: "text_end", value:"2.98 %"},
{cell:"D75", css: "text_end", value:"439,402"},
{cell:"E75", css: "text_end", value:"24"},
{cell:"F75", css: "text_end", value:"627,340"},
{cell:"G75", css: "text_end", value:"-45,374"},
{cell:"H75", css: "text_end", value:"31 %"},
{cell:"I75", css: "text_end", value:"0.20 %"},
{cell:"A76",css:"bold",value:"Guinea"},
{cell:"B76", css: "text_end", value:"13,052,608"},
{cell:"C76", css: "text_end", value:"2.64 %"},
{cell:"D76", css: "text_end", value:"335,432"},
{cell:"E76", css: "text_end", value:"53"},
{cell:"F76", css: "text_end", value:"245,720"},
{cell:"G76", css: "text_end", value:"-50,000"},
{cell:"H76", css: "text_end", value:"38 %"},
{cell:"I76", css: "text_end", value:"0.17 %"},
{cell:"A77",css:"bold",value:"South Sudan"},
{cell:"B77", css: "text_end", value:"12,919,053"},
{cell:"C77", css: "text_end", value:"2.73 %"},
{cell:"D77", css: "text_end", value:"343,339"},
{cell:"E77", css: "text_end", value:"21"},
{cell:"F77", css: "text_end", value:"610,952"},
{cell:"G77", css: "text_end", value:"85,000"},
{cell:"H77", css: "text_end", value:"19 %"},
{cell:"I77", css: "text_end", value:"0.17 %"},
{cell:"A78",css:"bold",value:"Rwanda"},
{cell:"B78", css: "text_end", value:"12,501,156"},
{cell:"C78", css: "text_end", value:"2.40 %"},
{cell:"D78", css: "text_end", value:"292,749"},
{cell:"E78", css: "text_end", value:"507"},
{cell:"F78", css: "text_end", value:"24,670"},
{cell:"G78", css: "text_end", value:"-15,820"},
{cell:"H78", css: "text_end", value:"32 %"},
{cell:"I78", css: "text_end", value:"0.16 %"},
{cell:"A79",css:"bold",value:"Tunisia"},
{cell:"B79", css: "text_end", value:"11,659,174"},
{cell:"C79", css: "text_end", value:"1.10 %"},
{cell:"D79", css: "text_end", value:"127,047"},
{cell:"E79", css: "text_end", value:"75"},
{cell:"F79", css: "text_end", value:"155,360"},
{cell:"G79", css: "text_end", value:"-13,193"},
{cell:"H79", css: "text_end", value:"66 %"},
{cell:"I79", css: "text_end", value:"0.15 %"},
{cell:"A80",css:"bold",value:"Belgium"},
{cell:"B80", css: "text_end", value:"11,498,519"},
{cell:"C80", css: "text_end", value:"0.61 %"},
{cell:"D80", css: "text_end", value:"69,183"},
{cell:"E80", css: "text_end", value:"380"},
{cell:"F80", css: "text_end", value:"30,280"},
{cell:"G80", css: "text_end", value:"51,734"},
{cell:"H80", css: "text_end", value:"96 %"},
{cell:"I80", css: "text_end", value:"0.15 %"},
{cell:"A81",css:"bold",value:"Cuba"},
{cell:"B81", css: "text_end", value:"11,489,082"},
{cell:"C81", css: "text_end", value:"0.04 %"},
{cell:"D81", css: "text_end", value:"4,446"},
{cell:"E81", css: "text_end", value:"108"},
{cell:"F81", css: "text_end", value:"106,440"},
{cell:"G81", css: "text_end", value:"-14,654"},
{cell:"H81", css: "text_end", value:"75 %"},
{cell:"I81", css: "text_end", value:"0.15 %"},
{cell:"A82",css:"bold",value:"Benin"},
{cell:"B82", css: "text_end", value:"11,485,674"},
{cell:"C82", css: "text_end", value:"2.77 %"},
{cell:"D82", css: "text_end", value:"309,982"},
{cell:"E82", css: "text_end", value:"102"},
{cell:"F82", css: "text_end", value:"112,760"},
{cell:"G82", css: "text_end", value:"-8,454"},
{cell:"H82", css: "text_end", value:"45 %"},
{cell:"I82", css: "text_end", value:"0.15 %"},
{cell:"A83",css:"bold",value:"Burundi"},
{cell:"B83", css: "text_end", value:"11,216,450"},
{cell:"C83", css: "text_end", value:"3.24 %"},
{cell:"D83", css: "text_end", value:"352,205"},
{cell:"E83", css: "text_end", value:"437"},
{cell:"F83", css: "text_end", value:"25,680"},
{cell:"G83", css: "text_end", value:"-14,000"},
{cell:"H83", css: "text_end", value:"13 %"},
{cell:"I83", css: "text_end", value:"0.15 %"},
{cell:"A84",css:"bold",value:"Bolivia"},
{cell:"B84", css: "text_end", value:"11,215,674"},
{cell:"C84", css: "text_end", value:"1.48 %"},
{cell:"D84", css: "text_end", value:"164,074"},
{cell:"E84", css: "text_end", value:"10"},
{cell:"F84", css: "text_end", value:"1,083,300"},
{cell:"G84", css: "text_end", value:"-12,359"},
{cell:"H84", css: "text_end", value:"70 %"},
{cell:"I84", css: "text_end", value:"0.15 %"},
{cell:"A85",css:"bold",value:"Greece"},
{cell:"B85", css: "text_end", value:"11,142,161"},
{cell:"C85", css: "text_end", value:"-0.16 %"},
{cell:"D85", css: "text_end", value:"-17,612"},
{cell:"E85", css: "text_end", value:"86"},
{cell:"F85", css: "text_end", value:"128,900"},
{cell:"G85", css: "text_end", value:"-32,360"},
{cell:"H85", css: "text_end", value:"78 %"},
{cell:"I85", css: "text_end", value:"0.15 %"},
{cell:"A86",css:"bold",value:"Haiti"},
{cell:"B86", css: "text_end", value:"11,112,945"},
{cell:"C86", css: "text_end", value:"1.20 %"},
{cell:"D86", css: "text_end", value:"131,716"},
{cell:"E86", css: "text_end", value:"403"},
{cell:"F86", css: "text_end", value:"27,560"},
{cell:"G86", css: "text_end", value:"-30,000"},
{cell:"H86", css: "text_end", value:"60 %"},
{cell:"I86", css: "text_end", value:"0.15 %"},
{cell:"A87",css:"bold",value:"Dominican Republic"},
{cell:"B87", css: "text_end", value:"10,882,996"},
{cell:"C87", css: "text_end", value:"1.08 %"},
{cell:"D87", css: "text_end", value:"115,998"},
{cell:"E87", css: "text_end", value:"225"},
{cell:"F87", css: "text_end", value:"48,320"},
{cell:"G87", css: "text_end", value:"-30,602"},
{cell:"H87", css: "text_end", value:"81 %"},
{cell:"I87", css: "text_end", value:"0.14 %"},
{cell:"A88",css:"bold",value:"Czech Republic"},
{cell:"B88", css: "text_end", value:"10,625,250"},
{cell:"C88", css: "text_end", value:"0.07 %"},
{cell:"D88", css: "text_end", value:"6,947"},
{cell:"E88", css: "text_end", value:"138"},
{cell:"F88", css: "text_end", value:"77,240"},
{cell:"G88", css: "text_end", value:"11,999"},
{cell:"H88", css: "text_end", value:"74 %"},
{cell:"I88", css: "text_end", value:"0.14 %"},
{cell:"A89",css:"bold",value:"Portugal"},
{cell:"B89", css: "text_end", value:"10,291,196"},
{cell:"C89", css: "text_end", value:"-0.37 %"},
{cell:"D89", css: "text_end", value:"-38,310"},
{cell:"E89", css: "text_end", value:"112"},
{cell:"F89", css: "text_end", value:"91,590"},
{cell:"G89", css: "text_end", value:"-28,000"},
{cell:"H89", css: "text_end", value:"67 %"},
{cell:"I89", css: "text_end", value:"0.13 %"},
{cell:"A90",css:"bold",value:"Sweden"},
{cell:"B90", css: "text_end", value:"9,982,709"},
{cell:"C90", css: "text_end", value:"0.73 %"},
{cell:"D90", css: "text_end", value:"72,008"},
{cell:"E90", css: "text_end", value:"24"},
{cell:"F90", css: "text_end", value:"410,340"},
{cell:"G90", css: "text_end", value:"50,792"},
{cell:"H90", css: "text_end", value:"85 %"},
{cell:"I90", css: "text_end", value:"0.13 %"},
{cell:"A91",css:"bold",value:"Azerbaijan"},
{cell:"B91", css: "text_end", value:"9,923,914"},
{cell:"C91", css: "text_end", value:"0.98 %"},
{cell:"D91", css: "text_end", value:"96,325"},
{cell:"E91", css: "text_end", value:"120"},
{cell:"F91", css: "text_end", value:"82,658"},
{cell:"G91", css: "text_end", value:"0"},
{cell:"H91", css: "text_end", value:"54 %"},
{cell:"I91", css: "text_end", value:"0.13 %"},
{cell:"A92",css:"bold",value:"Jordan"},
{cell:"B92", css: "text_end", value:"9,903,802"},
{cell:"C92", css: "text_end", value:"2.08 %"},
{cell:"D92", css: "text_end", value:"201,449"},
{cell:"E92", css: "text_end", value:"112"},
{cell:"F92", css: "text_end", value:"88,780"},
{cell:"G92", css: "text_end", value:"195,057"},
{cell:"H92", css: "text_end", value:"67 %"},
{cell:"I92", css: "text_end", value:"0.13 %"},
{cell:"A93",css:"bold",value:"Hungary"},
{cell:"B93", css: "text_end", value:"9,688,847"},
{cell:"C93", css: "text_end", value:"-0.34 %"},
{cell:"D93", css: "text_end", value:"-32,712"},
{cell:"E93", css: "text_end", value:"107"},
{cell:"F93", css: "text_end", value:"90,530"},
{cell:"G93", css: "text_end", value:"6,000"},
{cell:"H93", css: "text_end", value:"73 %"},
{cell:"I93", css: "text_end", value:"0.13 %"},
{cell:"A94",css:"bold",value:"United Arab Emirates"},
{cell:"B94", css: "text_end", value:"9,541,615"},
{cell:"C94", css: "text_end", value:"1.50 %"},
{cell:"D94", css: "text_end", value:"141,470"},
{cell:"E94", css: "text_end", value:"114"},
{cell:"F94", css: "text_end", value:"83,600"},
{cell:"G94", css: "text_end", value:"96,000"},
{cell:"H94", css: "text_end", value:"90 %"},
{cell:"I94", css: "text_end", value:"0.13 %"},
{cell:"A95",css:"bold",value:"Belarus"},
{cell:"B95", css: "text_end", value:"9,452,113"},
{cell:"C95", css: "text_end", value:"-0.17 %"},
{cell:"D95", css: "text_end", value:"-16,225"},
{cell:"E95", css: "text_end", value:"47"},
{cell:"F95", css: "text_end", value:"202,910"},
{cell:"G95", css: "text_end", value:"15,160"},
{cell:"H95", css: "text_end", value:"75 %"},
{cell:"I95", css: "text_end", value:"0.12 %"},
{cell:"A96",css:"bold",value:"Honduras"},
{cell:"B96", css: "text_end", value:"9,417,167"},
{cell:"C96", css: "text_end", value:"1.64 %"},
{cell:"D96", css: "text_end", value:"152,100"},
{cell:"E96", css: "text_end", value:"84"},
{cell:"F96", css: "text_end", value:"111,890"},
{cell:"G96", css: "text_end", value:"-3,000"},
{cell:"H96", css: "text_end", value:"52 %"},
{cell:"I96", css: "text_end", value:"0.12 %"},
{cell:"A97",css:"bold",value:"Tajikistan"},
{cell:"B97", css: "text_end", value:"9,107,211"},
{cell:"C97", css: "text_end", value:"2.08 %"},
{cell:"D97", css: "text_end", value:"185,868"},
{cell:"E97", css: "text_end", value:"65"},
{cell:"F97", css: "text_end", value:"139,960"},
{cell:"G97", css: "text_end", value:"-20,000"},
{cell:"H97", css: "text_end", value:"27 %"},
{cell:"I97", css: "text_end", value:"0.12 %"},
{cell:"A98",css:"bold",value:"Serbia"},
{cell:"B98", css: "text_end", value:"8,762,027"},
{cell:"C98", css: "text_end", value:"-0.32 %"},
{cell:"D98", css: "text_end", value:"-28,547"},
{cell:"E98", css: "text_end", value:"100"},
{cell:"F98", css: "text_end", value:"87,460"},
{cell:"G98", css: "text_end", value:"-20,000"},
{cell:"H98", css: "text_end", value:"59 %"},
{cell:"I98", css: "text_end", value:"0.11 %"},
{cell:"A99",css:"bold",value:"Austria"},
{cell:"B99", css: "text_end", value:"8,751,820"},
{cell:"C99", css: "text_end", value:"0.19 %"},
{cell:"D99", css: "text_end", value:"16,367"},
{cell:"E99", css: "text_end", value:"106"},
{cell:"F99", css: "text_end", value:"82,409"},
{cell:"G99", css: "text_end", value:"53,434"},
{cell:"H99", css: "text_end", value:"65 %"},
{cell:"I99", css: "text_end", value:"0.11 %"},
{cell:"A100",css:"bold",value:"Switzerland"},
{cell:"B100", css: "text_end", value:"8,544,034"},
{cell:"C100", css: "text_end", value:"0.80 %"},
{cell:"D100", css: "text_end", value:"68,029"},
{cell:"E100", css: "text_end", value:"216"},
{cell:"F100", css: "text_end", value:"39,516"},
{cell:"G100", css: "text_end", value:"79,453"},
{cell:"H100", css: "text_end", value:"73 %"},
{cell:"I100", css: "text_end", value:"0.11 %"},
{cell:"A101",css:"bold",value:"Israel"},
{cell:"B101", css: "text_end", value:"8,452,841"},
{cell:"C101", css: "text_end", value:"1.58 %"},
{cell:"D101", css: "text_end", value:"131,271"},
{cell:"E101", css: "text_end", value:"391"},
{cell:"F101", css: "text_end", value:"21,640"},
{cell:"G101", css: "text_end", value:"3,899"},
{cell:"H101", css: "text_end", value:"89 %"},
{cell:"I101", css: "text_end", value:"0.11 %"},
{cell:"A102",css:"bold",value:"Papua New Guinea"},
{cell:"B102", css: "text_end", value:"8,418,346"},
{cell:"C102", css: "text_end", value:"2.03 %"},
{cell:"D102", css: "text_end", value:"167,184"},
{cell:"E102", css: "text_end", value:"19"},
{cell:"F102", css: "text_end", value:"452,860"},
{cell:"G102", css: "text_end", value:"-200"},
{cell:"H102", css: "text_end", value:"12 %"},
{cell:"I102", css: "text_end", value:"0.11 %"},
{cell:"A103",css:"bold",value:"Togo"},
{cell:"B103", css: "text_end", value:"7,990,926"},
{cell:"C103", css: "text_end", value:"2.48 %"},
{cell:"D103", css: "text_end", value:"193,232"},
{cell:"E103", css: "text_end", value:"147"},
{cell:"F103", css: "text_end", value:"54,390"},
{cell:"G103", css: "text_end", value:"-1,999"},
{cell:"H103", css: "text_end", value:"39 %"},
{cell:"I103", css: "text_end", value:"0.10 %"},
{cell:"A104",css:"bold",value:"Sierra Leone"},
{cell:"B104", css: "text_end", value:"7,719,729"},
{cell:"C104", css: "text_end", value:"2.15 %"},
{cell:"D104", css: "text_end", value:"162,517"},
{cell:"E104", css: "text_end", value:"107"},
{cell:"F104", css: "text_end", value:"72,180"},
{cell:"G104", css: "text_end", value:"-4,200"},
{cell:"H104", css: "text_end", value:"35 %"},
{cell:"I104", css: "text_end", value:"0.10 %"},
{cell:"A105",css:"bold",value:"Hong Kong"},
{cell:"B105", css: "text_end", value:"7,428,887"},
{cell:"C105", css: "text_end", value:"0.87 %"},
{cell:"D105", css: "text_end", value:"64,004"},
{cell:"E105", css: "text_end", value:"7,075"},
{cell:"F105", css: "text_end", value:"1,050"},
{cell:"G105", css: "text_end", value:"14,978"},
{cell:"H105", css: "text_end", value:"N.A."},
{cell:"I105", css: "text_end", value:"0.10 %"},
{cell:"A106",css:"bold",value:"Bulgaria"},
{cell:"B106", css: "text_end", value:"7,036,848"},
{cell:"C106", css: "text_end", value:"-0.67 %"},
{cell:"D106", css: "text_end", value:"-47,723"},
{cell:"E106", css: "text_end", value:"65"},
{cell:"F106", css: "text_end", value:"108,560"},
{cell:"G106", css: "text_end", value:"-4,894"},
{cell:"H106", css: "text_end", value:"74 %"},
{cell:"I106", css: "text_end", value:"0.09 %"},
{cell:"A107",css:"bold",value:"Laos"},
{cell:"B107", css: "text_end", value:"6,961,210"},
{cell:"C107", css: "text_end", value:"1.50 %"},
{cell:"D107", css: "text_end", value:"103,050"},
{cell:"E107", css: "text_end", value:"30"},
{cell:"F107", css: "text_end", value:"230,800"},
{cell:"G107", css: "text_end", value:"-35,498"},
{cell:"H107", css: "text_end", value:"42 %"},
{cell:"I107", css: "text_end", value:"0.09 %"},
{cell:"A108",css:"bold",value:"Paraguay"},
{cell:"B108", css: "text_end", value:"6,896,908"},
{cell:"C108", css: "text_end", value:"1.26 %"},
{cell:"D108", css: "text_end", value:"85,611"},
{cell:"E108", css: "text_end", value:"17"},
{cell:"F108", css: "text_end", value:"397,300"},
{cell:"G108", css: "text_end", value:"-17,340"},
{cell:"H108", css: "text_end", value:"63 %"},
{cell:"I108", css: "text_end", value:"0.09 %"},
{cell:"A109",css:"bold",value:"Libya"},
{cell:"B109", css: "text_end", value:"6,470,956"},
{cell:"C109", css: "text_end", value:"1.51 %"},
{cell:"D109", css: "text_end", value:"96,340"},
{cell:"E109", css: "text_end", value:"4"},
{cell:"F109", css: "text_end", value:"1,759,540"},
{cell:"G109", css: "text_end", value:"-86,681"},
{cell:"H109", css: "text_end", value:"79 %"},
{cell:"I109", css: "text_end", value:"0.08 %"},
{cell:"A110",css:"bold",value:"El Salvador"},
{cell:"B110", css: "text_end", value:"6,411,558"},
{cell:"C110", css: "text_end", value:"0.53 %"},
{cell:"D110", css: "text_end", value:"33,705"},
{cell:"E110", css: "text_end", value:"309"},
{cell:"F110", css: "text_end", value:"20,720"},
{cell:"G110", css: "text_end", value:"-48,083"},
{cell:"H110", css: "text_end", value:"69 %"},
{cell:"I110", css: "text_end", value:"0.08 %"},
{cell:"A111",css:"bold",value:"Nicaragua"},
{cell:"B111", css: "text_end", value:"6,284,757"},
{cell:"C111", css: "text_end", value:"1.08 %"},
{cell:"D111", css: "text_end", value:"67,176"},
{cell:"E111", css: "text_end", value:"52"},
{cell:"F111", css: "text_end", value:"120,340"},
{cell:"G111", css: "text_end", value:"-27,000"},
{cell:"H111", css: "text_end", value:"61 %"},
{cell:"I111", css: "text_end", value:"0.08 %"},
{cell:"A112",css:"bold",value:"Kyrgyzstan"},
{cell:"B112", css: "text_end", value:"6,132,932"},
{cell:"C112", css: "text_end", value:"1.45 %"},
{cell:"D112", css: "text_end", value:"87,815"},
{cell:"E112", css: "text_end", value:"32"},
{cell:"F112", css: "text_end", value:"191,800"},
{cell:"G112", css: "text_end", value:"-27,580"},
{cell:"H112", css: "text_end", value:"35 %"},
{cell:"I112", css: "text_end", value:"0.08 %"},
{cell:"A113",css:"bold",value:"Lebanon"},
{cell:"B113", css: "text_end", value:"6,093,509"},
{cell:"C113", css: "text_end", value:"0.18 %"},
{cell:"D113", css: "text_end", value:"11,152"},
{cell:"E113", css: "text_end", value:"596"},
{cell:"F113", css: "text_end", value:"10,230"},
{cell:"G113", css: "text_end", value:"250,000"},
{cell:"H113", css: "text_end", value:"73 %"},
{cell:"I113", css: "text_end", value:"0.08 %"},
{cell:"A114",css:"bold",value:"Turkmenistan"},
{cell:"B114", css: "text_end", value:"5,851,466"},
{cell:"C114", css: "text_end", value:"1.62 %"},
{cell:"D114", css: "text_end", value:"93,391"},
{cell:"E114", css: "text_end", value:"12"},
{cell:"F114", css: "text_end", value:"469,930"},
{cell:"G114", css: "text_end", value:"-10,000"},
{cell:"H114", css: "text_end", value:"48 %"},
{cell:"I114", css: "text_end", value:"0.08 %"},
{cell:"A115",css:"bold",value:"Singapore"},
{cell:"B115", css: "text_end", value:"5,791,901"},
{cell:"C115", css: "text_end", value:"1.45 %"},
{cell:"D115", css: "text_end", value:"83,057"},
{cell:"E115", css: "text_end", value:"8,274"},
{cell:"F115", css: "text_end", value:"700"},
{cell:"G115", css: "text_end", value:"67,586"},
{cell:"H115", css: "text_end", value:"N.A."},
{cell:"I115", css: "text_end", value:"0.08 %"},
{cell:"A116",css:"bold",value:"Denmark"},
{cell:"B116", css: "text_end", value:"5,754,356"},
{cell:"C116", css: "text_end", value:"0.36 %"},
{cell:"D116", css: "text_end", value:"20,805"},
{cell:"E116", css: "text_end", value:"136"},
{cell:"F116", css: "text_end", value:"42,430"},
{cell:"G116", css: "text_end", value:"21,368"},
{cell:"H116", css: "text_end", value:"87 %"},
{cell:"I116", css: "text_end", value:"0.08 %"},
{cell:"A117",css:"bold",value:"Finland"},
{cell:"B117", css: "text_end", value:"5,542,517"},
{cell:"C117", css: "text_end", value:"0.35 %"},
{cell:"D117", css: "text_end", value:"19,286"},
{cell:"E117", css: "text_end", value:"18"},
{cell:"F117", css: "text_end", value:"303,890"},
{cell:"G117", css: "text_end", value:"16,283"},
{cell:"H117", css: "text_end", value:"84 %"},
{cell:"I117", css: "text_end", value:"0.07 %"},
{cell:"A118",css:"bold",value:"Slovakia"},
{cell:"B118", css: "text_end", value:"5,449,816"},
{cell:"C118", css: "text_end", value:"0.04 %"},
{cell:"D118", css: "text_end", value:"2,154"},
{cell:"E118", css: "text_end", value:"113"},
{cell:"F118", css: "text_end", value:"48,088"},
{cell:"G118", css: "text_end", value:"2,269"},
{cell:"H118", css: "text_end", value:"54 %"},
{cell:"I118", css: "text_end", value:"0.07 %"},
{cell:"A119",css:"bold",value:"Congo"},
{cell:"B119", css: "text_end", value:"5,399,895"},
{cell:"C119", css: "text_end", value:"2.64 %"},
{cell:"D119", css: "text_end", value:"139,145"},
{cell:"E119", css: "text_end", value:"16"},
{cell:"F119", css: "text_end", value:"341,500"},
{cell:"G119", css: "text_end", value:"-12,000"},
{cell:"H119", css: "text_end", value:"60 %"},
{cell:"I119", css: "text_end", value:"0.07 %"},
{cell:"A120",css:"bold",value:"Norway"},
{cell:"B120", css: "text_end", value:"5,353,363"},
{cell:"C120", css: "text_end", value:"0.90 %"},
{cell:"D120", css: "text_end", value:"47,980"},
{cell:"E120", css: "text_end", value:"15"},
{cell:"F120", css: "text_end", value:"365,268"},
{cell:"G120", css: "text_end", value:"44,363"},
{cell:"H120", css: "text_end", value:"79 %"},
{cell:"I120", css: "text_end", value:"0.07 %"},
{cell:"A121",css:"bold",value:"Eritrea"},
{cell:"B121", css: "text_end", value:"5,187,948"},
{cell:"C121", css: "text_end", value:"2.35 %"},
{cell:"D121", css: "text_end", value:"119,117"},
{cell:"E121", css: "text_end", value:"51"},
{cell:"F121", css: "text_end", value:"101,000"},
{cell:"G121", css: "text_end", value:"-32,000"},
{cell:"H121", css: "text_end", value:"32 %"},
{cell:"I121", css: "text_end", value:"0.07 %"},
{cell:"A122",css:"bold",value:"State of Palestine"},
{cell:"B122", css: "text_end", value:"5,052,776"},
{cell:"C122", css: "text_end", value:"2.68 %"},
{cell:"D122", css: "text_end", value:"132,052"},
{cell:"E122", css: "text_end", value:"839"},
{cell:"F122", css: "text_end", value:"6,020"},
{cell:"G122", css: "text_end", value:"-8,750"},
{cell:"H122", css: "text_end", value:"72 %"},
{cell:"I122", css: "text_end", value:"0.07 %"},
{cell:"A123",css:"bold",value:"Costa Rica"},
{cell:"B123", css: "text_end", value:"4,953,199"},
{cell:"C123", css: "text_end", value:"0.97 %"},
{cell:"D123", css: "text_end", value:"47,430"},
{cell:"E123", css: "text_end", value:"97"},
{cell:"F123", css: "text_end", value:"51,060"},
{cell:"G123", css: "text_end", value:"3,932"},
{cell:"H123", css: "text_end", value:"81 %"},
{cell:"I123", css: "text_end", value:"0.06 %"},
{cell:"A124",css:"bold",value:"Liberia"},
{cell:"B124", css: "text_end", value:"4,853,516"},
{cell:"C124", css: "text_end", value:"2.57 %"},
{cell:"D124", css: "text_end", value:"121,610"},
{cell:"E124", css: "text_end", value:"50"},
{cell:"F124", css: "text_end", value:"96,320"},
{cell:"G124", css: "text_end", value:"-4,000"},
{cell:"H124", css: "text_end", value:"49 %"},
{cell:"I124", css: "text_end", value:"0.06 %"},
{cell:"A125",css:"bold",value:"Oman"},
{cell:"B125", css: "text_end", value:"4,829,946"},
{cell:"C125", css: "text_end", value:"4.18 %"},
{cell:"D125", css: "text_end", value:"193,684"},
{cell:"E125", css: "text_end", value:"16"},
{cell:"F125", css: "text_end", value:"309,500"},
{cell:"G125", css: "text_end", value:"163,500"},
{cell:"H125", css: "text_end", value:"72 %"},
{cell:"I125", css: "text_end", value:"0.06 %"},
{cell:"A126",css:"bold",value:"Ireland"},
{cell:"B126", css: "text_end", value:"4,803,748"},
{cell:"C126", css: "text_end", value:"0.88 %"},
{cell:"D126", css: "text_end", value:"42,091"},
{cell:"E126", css: "text_end", value:"70"},
{cell:"F126", css: "text_end", value:"68,890"},
{cell:"G126", css: "text_end", value:"-27,999"},
{cell:"H126", css: "text_end", value:"64 %"},
{cell:"I126", css: "text_end", value:"0.06 %"},
{cell:"A127",css:"bold",value:"New Zealand"},
{cell:"B127", css: "text_end", value:"4,749,598"},
{cell:"C127", css: "text_end", value:"0.93 %"},
{cell:"D127", css: "text_end", value:"43,780"},
{cell:"E127", css: "text_end", value:"18"},
{cell:"F127", css: "text_end", value:"263,310"},
{cell:"G127", css: "text_end", value:"18,179"},
{cell:"H127", css: "text_end", value:"85 %"},
{cell:"I127", css: "text_end", value:"0.06 %"},
{cell:"A128",css:"bold",value:"Central African Republic"},
{cell:"B128", css: "text_end", value:"4,737,423"},
{cell:"C128", css: "text_end", value:"1.68 %"},
{cell:"D128", css: "text_end", value:"78,343"},
{cell:"E128", css: "text_end", value:"8"},
{cell:"F128", css: "text_end", value:"622,980"},
{cell:"G128", css: "text_end", value:"-79,226"},
{cell:"H128", css: "text_end", value:"43 %"},
{cell:"I128", css: "text_end", value:"0.06 %"},
{cell:"A129",css:"bold",value:"Mauritania"},
{cell:"B129", css: "text_end", value:"4,540,068"},
{cell:"C129", css: "text_end", value:"2.71 %"},
{cell:"D129", css: "text_end", value:"119,884"},
{cell:"E129", css: "text_end", value:"4"},
{cell:"F129", css: "text_end", value:"1,030,700"},
{cell:"G129", css: "text_end", value:"8,000"},
{cell:"H129", css: "text_end", value:"57 %"},
{cell:"I129", css: "text_end", value:"0.06 %"},
{cell:"A130",css:"bold",value:"Kuwait"},
{cell:"B130", css: "text_end", value:"4,197,128"},
{cell:"C130", css: "text_end", value:"1.46 %"},
{cell:"D130", css: "text_end", value:"60,600"},
{cell:"E130", css: "text_end", value:"236"},
{cell:"F130", css: "text_end", value:"17,820"},
{cell:"G130", css: "text_end", value:"134,000"},
{cell:"H130", css: "text_end", value:"88 %"},
{cell:"I130", css: "text_end", value:"0.05 %"},
{cell:"A131",css:"bold",value:"Croatia"},
{cell:"B131", css: "text_end", value:"4,164,783"},
{cell:"C131", css: "text_end", value:"-0.59 %"},
{cell:"D131", css: "text_end", value:"-24,570"},
{cell:"E131", css: "text_end", value:"74"},
{cell:"F131", css: "text_end", value:"55,960"},
{cell:"G131", css: "text_end", value:"-6,554"},
{cell:"H131", css: "text_end", value:"60 %"},
{cell:"I131", css: "text_end", value:"0.05 %"},
{cell:"A132",css:"bold",value:"Panama"},
{cell:"B132", css: "text_end", value:"4,162,618"},
{cell:"C132", css: "text_end", value:"1.56 %"},
{cell:"D132", css: "text_end", value:"64,031"},
{cell:"E132", css: "text_end", value:"56"},
{cell:"F132", css: "text_end", value:"74,340"},
{cell:"G132", css: "text_end", value:"5,621"},
{cell:"H132", css: "text_end", value:"66 %"},
{cell:"I132", css: "text_end", value:"0.05 %"},
{cell:"A133",css:"bold",value:"Moldova"},
{cell:"B133", css: "text_end", value:"4,041,065"},
{cell:"C133", css: "text_end", value:"-0.25 %"},
{cell:"D133", css: "text_end", value:"-10,147"},
{cell:"E133", css: "text_end", value:"123"},
{cell:"F133", css: "text_end", value:"32,850"},
{cell:"G133", css: "text_end", value:"-1,906"},
{cell:"H133", css: "text_end", value:"38 %"},
{cell:"I133", css: "text_end", value:"0.05 %"},
{cell:"A134",css:"bold",value:"Georgia"},
{cell:"B134", css: "text_end", value:"3,907,131"},
{cell:"C134", css: "text_end", value:"-0.13 %"},
{cell:"D134", css: "text_end", value:"-4,930"},
{cell:"E134", css: "text_end", value:"56"},
{cell:"F134", css: "text_end", value:"69,490"},
{cell:"G134", css: "text_end", value:"-61,054"},
{cell:"H134", css: "text_end", value:"59 %"},
{cell:"I134", css: "text_end", value:"0.05 %"},
{cell:"A135",css:"bold",value:"Puerto Rico"},
{cell:"B135", css: "text_end", value:"3,659,007"},
{cell:"C135", css: "text_end", value:"-0.11 %"},
{cell:"D135", css: "text_end", value:"-4,124"},
{cell:"E135", css: "text_end", value:"413"},
{cell:"F135", css: "text_end", value:"8,870"},
{cell:"G135", css: "text_end", value:"-20,706"},
{cell:"H135", css: "text_end", value:"94 %"},
{cell:"I135", css: "text_end", value:"0.05 %"},
{cell:"A136",css:"bold",value:"Bosnia & Herzegovina"},
{cell:"B136", css: "text_end", value:"3,503,554"},
{cell:"C136", css: "text_end", value:"-0.10 %"},
{cell:"D136", css: "text_end", value:"-3,463"},
{cell:"E136", css: "text_end", value:"69"},
{cell:"F136", css: "text_end", value:"51,000"},
{cell:"G136", css: "text_end", value:"-32,274"},
{cell:"H136", css: "text_end", value:"44 %"},
{cell:"I136", css: "text_end", value:"0.05 %"},
{cell:"A137",css:"bold",value:"Uruguay"},
{cell:"B137", css: "text_end", value:"3,469,551"},
{cell:"C137", css: "text_end", value:"0.37 %"},
{cell:"D137", css: "text_end", value:"12,801"},
{cell:"E137", css: "text_end", value:"20"},
{cell:"F137", css: "text_end", value:"175,020"},
{cell:"G137", css: "text_end", value:"-6,000"},
{cell:"H137", css: "text_end", value:"95 %"},
{cell:"I137", css: "text_end", value:"0.05 %"},
{cell:"A138",css:"bold",value:"Mongolia"},
{cell:"B138", css: "text_end", value:"3,121,772"},
{cell:"C138", css: "text_end", value:"1.50 %"},
{cell:"D138", css: "text_end", value:"46,125"},
{cell:"E138", css: "text_end", value:"2"},
{cell:"F138", css: "text_end", value:"1,553,560"},
{cell:"G138", css: "text_end", value:"-3,000"},
{cell:"H138", css: "text_end", value:"71 %"},
{cell:"I138", css: "text_end", value:"0.04 %"},
{cell:"A139",css:"bold",value:"Albania"},
{cell:"B139", css: "text_end", value:"2,934,363"},
{cell:"C139", css: "text_end", value:"0.14 %"},
{cell:"D139", css: "text_end", value:"4,176"},
{cell:"E139", css: "text_end", value:"107"},
{cell:"F139", css: "text_end", value:"27,400"},
{cell:"G139", css: "text_end", value:"-18,685"},
{cell:"H139", css: "text_end", value:"65 %"},
{cell:"I139", css: "text_end", value:"0.04 %"},
{cell:"A140",css:"bold",value:"Armenia"},
{cell:"B140", css: "text_end", value:"2,934,152"},
{cell:"C140", css: "text_end", value:"0.13 %"},
{cell:"D140", css: "text_end", value:"3,702"},
{cell:"E140", css: "text_end", value:"103"},
{cell:"F140", css: "text_end", value:"28,470"},
{cell:"G140", css: "text_end", value:"-6,107"},
{cell:"H140", css: "text_end", value:"64 %"},
{cell:"I140", css: "text_end", value:"0.04 %"},
{cell:"A141",css:"bold",value:"Jamaica"},
{cell:"B141", css: "text_end", value:"2,898,677"},
{cell:"C141", css: "text_end", value:"0.29 %"},
{cell:"D141", css: "text_end", value:"8,378"},
{cell:"E141", css: "text_end", value:"268"},
{cell:"F141", css: "text_end", value:"10,830"},
{cell:"G141", css: "text_end", value:"-18,619"},
{cell:"H141", css: "text_end", value:"54 %"},
{cell:"I141", css: "text_end", value:"0.04 %"},
{cell:"A142",css:"bold",value:"Lithuania"},
{cell:"B142", css: "text_end", value:"2,876,475"},
{cell:"C142", css: "text_end", value:"-0.48 %"},
{cell:"D142", css: "text_end", value:"-13,822"},
{cell:"E142", css: "text_end", value:"46"},
{cell:"F142", css: "text_end", value:"62,674"},
{cell:"G142", css: "text_end", value:"-29,243"},
{cell:"H142", css: "text_end", value:"69 %"},
{cell:"I142", css: "text_end", value:"0.04 %"},
{cell:"A143",css:"bold",value:"Qatar"},
{cell:"B143", css: "text_end", value:"2,694,849"},
{cell:"C143", css: "text_end", value:"2.11 %"},
{cell:"D143", css: "text_end", value:"55,638"},
{cell:"E143", css: "text_end", value:"232"},
{cell:"F143", css: "text_end", value:"11,610"},
{cell:"G143", css: "text_end", value:"120,400"},
{cell:"H143", css: "text_end", value:"91 %"},
{cell:"I143", css: "text_end", value:"0.04 %"},
{cell:"A144",css:"bold",value:"Namibia"},
{cell:"B144", css: "text_end", value:"2,587,801"},
{cell:"C144", css: "text_end", value:"2.13 %"},
{cell:"D144", css: "text_end", value:"54,007"},
{cell:"E144", css: "text_end", value:"3"},
{cell:"F144", css: "text_end", value:"823,290"},
{cell:"G144", css: "text_end", value:"-274"},
{cell:"H144", css: "text_end", value:"47 %"},
{cell:"I144", css: "text_end", value:"0.03 %"},
{cell:"A145",css:"bold",value:"Botswana"},
{cell:"B145", css: "text_end", value:"2,333,201"},
{cell:"C145", css: "text_end", value:"1.81 %"},
{cell:"D145", css: "text_end", value:"41,540"},
{cell:"E145", css: "text_end", value:"4"},
{cell:"F145", css: "text_end", value:"566,730"},
{cell:"G145", css: "text_end", value:"3,000"},
{cell:"H145", css: "text_end", value:"52 %"},
{cell:"I145", css: "text_end", value:"0.03 %"},
{cell:"A146",css:"bold",value:"Lesotho"},
{cell:"B146", css: "text_end", value:"2,263,010"},
{cell:"C146", css: "text_end", value:"1.33 %"},
{cell:"D146", css: "text_end", value:"29,671"},
{cell:"E146", css: "text_end", value:"75"},
{cell:"F146", css: "text_end", value:"30,360"},
{cell:"G146", css: "text_end", value:"-5,000"},
{cell:"H146", css: "text_end", value:"27 %"},
{cell:"I146", css: "text_end", value:"0.03 %"},
{cell:"A147",css:"bold",value:"Gambia"},
{cell:"B147", css: "text_end", value:"2,163,765"},
{cell:"C147", css: "text_end", value:"3.01 %"},
{cell:"D147", css: "text_end", value:"63,197"},
{cell:"E147", css: "text_end", value:"214"},
{cell:"F147", css: "text_end", value:"10,120"},
{cell:"G147", css: "text_end", value:"-2,695"},
{cell:"H147", css: "text_end", value:"59 %"},
{cell:"I147", css: "text_end", value:"0.03 %"},
{cell:"A148",css:"bold",value:"TFYR Macedonia"},
{cell:"B148", css: "text_end", value:"2,085,051"},
{cell:"C148", css: "text_end", value:"0.09 %"},
{cell:"D148", css: "text_end", value:"1,891"},
{cell:"E148", css: "text_end", value:"83"},
{cell:"F148", css: "text_end", value:"25,220"},
{cell:"G148", css: "text_end", value:"-1,771"},
{cell:"H148", css: "text_end", value:"58 %"},
{cell:"I148", css: "text_end", value:"0.03 %"},
{cell:"A149",css:"bold",value:"Slovenia"},
{cell:"B149", css: "text_end", value:"2,081,260"},
{cell:"C149", css: "text_end", value:"0.06 %"},
{cell:"D149", css: "text_end", value:"1,284"},
{cell:"E149", css: "text_end", value:"103"},
{cell:"F149", css: "text_end", value:"20,140"},
{cell:"G149", css: "text_end", value:"3,314"},
{cell:"H149", css: "text_end", value:"50 %"},
{cell:"I149", css: "text_end", value:"0.03 %"},
{cell:"A150",css:"bold",value:"Gabon"},
{cell:"B150", css: "text_end", value:"2,067,561"},
{cell:"C150", css: "text_end", value:"2.09 %"},
{cell:"D150", css: "text_end", value:"42,424"},
{cell:"E150", css: "text_end", value:"8"},
{cell:"F150", css: "text_end", value:"257,670"},
{cell:"G150", css: "text_end", value:"17,088"},
{cell:"H150", css: "text_end", value:"78 %"},
{cell:"I150", css: "text_end", value:"0.03 %"},
{cell:"A151",css:"bold",value:"Latvia"},
{cell:"B151", css: "text_end", value:"1,929,938"},
{cell:"C151", css: "text_end", value:"-1.01 %"},
{cell:"D151", css: "text_end", value:"-19,732"},
{cell:"E151", css: "text_end", value:"31"},
{cell:"F151", css: "text_end", value:"62,200"},
{cell:"G151", css: "text_end", value:"-16,665"},
{cell:"H151", css: "text_end", value:"70 %"},
{cell:"I151", css: "text_end", value:"0.03 %"},
{cell:"A152",css:"bold",value:"Guinea-Bissau"},
{cell:"B152", css: "text_end", value:"1,907,268"},
{cell:"C152", css: "text_end", value:"2.47 %"},
{cell:"D152", css: "text_end", value:"45,985"},
{cell:"E152", css: "text_end", value:"68"},
{cell:"F152", css: "text_end", value:"28,120"},
{cell:"G152", css: "text_end", value:"-2,001"},
{cell:"H152", css: "text_end", value:"50 %"},
{cell:"I152", css: "text_end", value:"0.02 %"},
{cell:"A153",css:"bold",value:"Bahrain"},
{cell:"B153", css: "text_end", value:"1,566,993"},
{cell:"C153", css: "text_end", value:"4.99 %"},
{cell:"D153", css: "text_end", value:"74,409"},
{cell:"E153", css: "text_end", value:"2,062"},
{cell:"F153", css: "text_end", value:"760"},
{cell:"G153", css: "text_end", value:"8,400"},
{cell:"H153", css: "text_end", value:"80 %"},
{cell:"I153", css: "text_end", value:"0.02 %"},
{cell:"A154",css:"bold",value:"Swaziland"},
{cell:"B154", css: "text_end", value:"1,391,385"},
{cell:"C154", css: "text_end", value:"1.76 %"},
{cell:"D154", css: "text_end", value:"24,131"},
{cell:"E154", css: "text_end", value:"81"},
{cell:"F154", css: "text_end", value:"17,200"},
{cell:"G154", css: "text_end", value:"-1,200"},
{cell:"H154", css: "text_end", value:"20 %"},
{cell:"I154", css: "text_end", value:"0.02 %"},
{cell:"A155",css:"bold",value:"Trinidad and Tobago"},
{cell:"B155", css: "text_end", value:"1,372,598"},
{cell:"C155", css: "text_end", value:"0.25 %"},
{cell:"D155", css: "text_end", value:"3,473"},
{cell:"E155", css: "text_end", value:"268"},
{cell:"F155", css: "text_end", value:"5,130"},
{cell:"G155", css: "text_end", value:"-1,000"},
{cell:"H155", css: "text_end", value:"8 %"},
{cell:"I155", css: "text_end", value:"0.02 %"},
{cell:"A156",css:"bold",value:"Timor-Leste"},
{cell:"B156", css: "text_end", value:"1,324,094"},
{cell:"C156", css: "text_end", value:"2.14 %"},
{cell:"D156", css: "text_end", value:"27,783"},
{cell:"E156", css: "text_end", value:"89"},
{cell:"F156", css: "text_end", value:"14,870"},
{cell:"G156", css: "text_end", value:"-10,001"},
{cell:"H156", css: "text_end", value:"31 %"},
{cell:"I156", css: "text_end", value:"0.02 %"},
{cell:"A157",css:"bold",value:"Equatorial Guinea"},
{cell:"B157", css: "text_end", value:"1,313,894"},
{cell:"C157", css: "text_end", value:"3.64 %"},
{cell:"D157", css: "text_end", value:"46,205"},
{cell:"E157", css: "text_end", value:"47"},
{cell:"F157", css: "text_end", value:"28,050"},
{cell:"G157", css: "text_end", value:"18,000"},
{cell:"H157", css: "text_end", value:"26 %"},
{cell:"I157", css: "text_end", value:"0.02 %"},
{cell:"A158",css:"bold",value:"Estonia"},
{cell:"B158", css: "text_end", value:"1,306,788"},
{cell:"C158", css: "text_end", value:"-0.22 %"},
{cell:"D158", css: "text_end", value:"-2,844"},
{cell:"E158", css: "text_end", value:"31"},
{cell:"F158", css: "text_end", value:"42,390"},
{cell:"G158", css: "text_end", value:"-2,103"},
{cell:"H158", css: "text_end", value:"66 %"},
{cell:"I158", css: "text_end", value:"0.02 %"},
{cell:"A159",css:"bold",value:"Mauritius"},
{cell:"B159", css: "text_end", value:"1,268,315"},
{cell:"C159", css: "text_end", value:"0.25 %"},
{cell:"D159", css: "text_end", value:"3,177"},
{cell:"E159", css: "text_end", value:"625"},
{cell:"F159", css: "text_end", value:"2,030"},
{cell:"G159", css: "text_end", value:"-2,416"},
{cell:"H159", css: "text_end", value:"39 %"},
{cell:"I159", css: "text_end", value:"0.02 %"},
{cell:"A160",css:"bold",value:"Cyprus"},
{cell:"B160", css: "text_end", value:"1,189,085"},
{cell:"C160", css: "text_end", value:"0.81 %"},
{cell:"D160", css: "text_end", value:"9,534"},
{cell:"E160", css: "text_end", value:"129"},
{cell:"F160", css: "text_end", value:"9,240"},
{cell:"G160", css: "text_end", value:"4,502"},
{cell:"H160", css: "text_end", value:"67 %"},
{cell:"I160", css: "text_end", value:"0.02 %"},
{cell:"A161",css:"bold",value:"Djibouti"},
{cell:"B161", css: "text_end", value:"971,408"},
{cell:"C161", css: "text_end", value:"1.51 %"},
{cell:"D161", css: "text_end", value:"14,423"},
{cell:"E161", css: "text_end", value:"42"},
{cell:"F161", css: "text_end", value:"23,180"},
{cell:"G161", css: "text_end", value:"1,200"},
{cell:"H161", css: "text_end", value:"74 %"},
{cell:"I161", css: "text_end", value:"0.01 %"},
{cell:"A162",css:"bold",value:"Fiji"},
{cell:"B162", css: "text_end", value:"912,241"},
{cell:"C162", css: "text_end", value:"0.74 %"},
{cell:"D162", css: "text_end", value:"6,739"},
{cell:"E162", css: "text_end", value:"50"},
{cell:"F162", css: "text_end", value:"18,270"},
{cell:"G162", css: "text_end", value:"-5,744"},
{cell:"H162", css: "text_end", value:"54 %"},
{cell:"I162", css: "text_end", value:"0.01 %"},
{cell:"A163",css:"bold",value:"RГ©union"},
{cell:"B163", css: "text_end", value:"883,247"},
{cell:"C163", css: "text_end", value:"0.76 %"},
{cell:"D163", css: "text_end", value:"6,685"},
{cell:"E163", css: "text_end", value:"353"},
{cell:"F163", css: "text_end", value:"2,500"},
{cell:"G163", css: "text_end", value:"-2,828"},
{cell:"H163", css: "text_end", value:"99 %"},
{cell:"I163", css: "text_end", value:"0.01 %"},
{cell:"A164",css:"bold",value:"Comoros"},
{cell:"B164", css: "text_end", value:"832,347"},
{cell:"C164", css: "text_end", value:"2.26 %"},
{cell:"D164", css: "text_end", value:"18,435"},
{cell:"E164", css: "text_end", value:"447"},
{cell:"F164", css: "text_end", value:"1,861"},
{cell:"G164", css: "text_end", value:"-2,000"},
{cell:"H164", css: "text_end", value:"28 %"},
{cell:"I164", css: "text_end", value:"0.01 %"},
{cell:"A165",css:"bold",value:"Bhutan"},
{cell:"B165", css: "text_end", value:"817,054"},
{cell:"C165", css: "text_end", value:"1.17 %"},
{cell:"D165", css: "text_end", value:"9,444"},
{cell:"E165", css: "text_end", value:"21"},
{cell:"F165", css: "text_end", value:"38,117"},
{cell:"G165", css: "text_end", value:"2,000"},
{cell:"H165", css: "text_end", value:"39 %"},
{cell:"I165", css: "text_end", value:"0.01 %"},
{cell:"A166",css:"bold",value:"Guyana"},
{cell:"B166", css: "text_end", value:"782,225"},
{cell:"C166", css: "text_end", value:"0.56 %"},
{cell:"D166", css: "text_end", value:"4,366"},
{cell:"E166", css: "text_end", value:"4"},
{cell:"F166", css: "text_end", value:"196,850"},
{cell:"G166", css: "text_end", value:"-5,456"},
{cell:"H166", css: "text_end", value:"30 %"},
{cell:"I166", css: "text_end", value:"0.01 %"},
{cell:"A167",css:"bold",value:"Macao"},
{cell:"B167", css: "text_end", value:"632,418"},
{cell:"C167", css: "text_end", value:"1.58 %"},
{cell:"D167", css: "text_end", value:"9,851"},
{cell:"E167", css: "text_end", value:"21,081"},
{cell:"F167", css: "text_end", value:"30"},
{cell:"G167", css: "text_end", value:"8,470"},
{cell:"H167", css: "text_end", value:"95 %"},
{cell:"I167", css: "text_end", value:"0.01 %"},
{cell:"A168",css:"bold",value:"Montenegro"},
{cell:"B168", css: "text_end", value:"629,219"},
{cell:"C168", css: "text_end", value:"0.04 %"},
{cell:"D168", css: "text_end", value:"259"},
{cell:"E168", css: "text_end", value:"47"},
{cell:"F168", css: "text_end", value:"13,450"},
{cell:"G168", css: "text_end", value:"-622"},
{cell:"H168", css: "text_end", value:"64 %"},
{cell:"I168", css: "text_end", value:"0.01 %"},
{cell:"A169",css:"bold",value:"Solomon Islands"},
{cell:"B169", css: "text_end", value:"623,281"},
{cell:"C169", css: "text_end", value:"1.95 %"},
{cell:"D169", css: "text_end", value:"11,938"},
{cell:"E169", css: "text_end", value:"22"},
{cell:"F169", css: "text_end", value:"27,990"},
{cell:"G169", css: "text_end", value:"-2,374"},
{cell:"H169", css: "text_end", value:"23 %"},
{cell:"I169", css: "text_end", value:"0.01 %"},
{cell:"A170",css:"bold",value:"Luxembourg"},
{cell:"B170", css: "text_end", value:"590,321"},
{cell:"C170", css: "text_end", value:"1.18 %"},
{cell:"D170", css: "text_end", value:"6,866"},
{cell:"E170", css: "text_end", value:"228"},
{cell:"F170", css: "text_end", value:"2,590"},
{cell:"G170", css: "text_end", value:"9,741"},
{cell:"H170", css: "text_end", value:"86 %"},
{cell:"I170", css: "text_end", value:"0.01 %"},
{cell:"A171",css:"bold",value:"Suriname"},
{cell:"B171", css: "text_end", value:"568,301"},
{cell:"C171", css: "text_end", value:"0.87 %"},
{cell:"D171", css: "text_end", value:"4,899"},
{cell:"E171", css: "text_end", value:"4"},
{cell:"F171", css: "text_end", value:"156,000"},
{cell:"G171", css: "text_end", value:"-1,000"},
{cell:"H171", css: "text_end", value:"65 %"},
{cell:"I171", css: "text_end", value:"0.01 %"},
{cell:"A172",css:"bold",value:"Western Sahara"},
{cell:"B172", css: "text_end", value:"567,421"},
{cell:"C172", css: "text_end", value:"2.68 %"},
{cell:"D172", css: "text_end", value:"14,793"},
{cell:"E172", css: "text_end", value:"2"},
{cell:"F172", css: "text_end", value:"266,000"},
{cell:"G172", css: "text_end", value:"572"},
{cell:"H172", css: "text_end", value:"92 %"},
{cell:"I172", css: "text_end", value:"0.01 %"},
{cell:"A173",css:"bold",value:"Cabo Verde"},
{cell:"B173", css: "text_end", value:"553,335"},
{cell:"C173", css: "text_end", value:"1.27 %"},
{cell:"D173", css: "text_end", value:"6,947"},
{cell:"E173", css: "text_end", value:"137"},
{cell:"F173", css: "text_end", value:"4,030"},
{cell:"G173", css: "text_end", value:"-2,210"},
{cell:"H173", css: "text_end", value:"62 %"},
{cell:"I173", css: "text_end", value:"0.01 %"},
{cell:"A174",css:"bold",value:"Guadeloupe"},
{cell:"B174", css: "text_end", value:"449,173"},
{cell:"C174", css: "text_end", value:"-0.09 %"},
{cell:"D174", css: "text_end", value:"-395"},
{cell:"E174", css: "text_end", value:"266"},
{cell:"F174", css: "text_end", value:"1,690"},
{cell:"G174", css: "text_end", value:"-2,001"},
{cell:"H174", css: "text_end", value:"N.A."},
{cell:"I174", css: "text_end", value:"0.01 %"},
{cell:"A175",css:"bold",value:"Maldives"},
{cell:"B175", css: "text_end", value:"444,259"},
{cell:"C175", css: "text_end", value:"1.82 %"},
{cell:"D175", css: "text_end", value:"7,929"},
{cell:"E175", css: "text_end", value:"1,481"},
{cell:"F175", css: "text_end", value:"300"},
{cell:"G175", css: "text_end", value:"4,383"},
{cell:"H175", css: "text_end", value:"40 %"},
{cell:"I175", css: "text_end", value:"0.01 %"},
{cell:"A176",css:"bold",value:"Brunei"},
{cell:"B176", css: "text_end", value:"434,076"},
{cell:"C176", css: "text_end", value:"1.25 %"},
{cell:"D176", css: "text_end", value:"5,379"},
{cell:"E176", css: "text_end", value:"82"},
{cell:"F176", css: "text_end", value:"5,270"},
{cell:"G176", css: "text_end", value:"406"},
{cell:"H176", css: "text_end", value:"79 %"},
{cell:"I176", css: "text_end", value:"0.01 %"},
{cell:"A177",css:"bold",value:"Malta"},
{cell:"B177", css: "text_end", value:"432,089"},
{cell:"C177", css: "text_end", value:"0.29 %"},
{cell:"D177", css: "text_end", value:"1,254"},
{cell:"E177", css: "text_end", value:"1,350"},
{cell:"F177", css: "text_end", value:"320"},
{cell:"G177", css: "text_end", value:"1,889"},
{cell:"H177", css: "text_end", value:"96 %"},
{cell:"I177", css: "text_end", value:"0.01 %"},
{cell:"A178",css:"bold",value:"Bahamas"},
{cell:"B178", css: "text_end", value:"399,285"},
{cell:"C178", css: "text_end", value:"0.99 %"},
{cell:"D178", css: "text_end", value:"3,924"},
{cell:"E178", css: "text_end", value:"40"},
{cell:"F178", css: "text_end", value:"10,010"},
{cell:"G178", css: "text_end", value:"1,934"},
{cell:"H178", css: "text_end", value:"83 %"},
{cell:"I178", css: "text_end", value:"0.01 %"},
{cell:"A179",css:"bold",value:"Martinique"},
{cell:"B179", css: "text_end", value:"385,065"},
{cell:"C179", css: "text_end", value:"0.04 %"},
{cell:"D179", css: "text_end", value:"169"},
{cell:"E179", css: "text_end", value:"363"},
{cell:"F179", css: "text_end", value:"1,060"},
{cell:"G179", css: "text_end", value:"-3,354"},
{cell:"H179", css: "text_end", value:"94 %"},
{cell:"I179", css: "text_end", value:"0.01 %"},
{cell:"A180",css:"bold",value:"Belize"},
{cell:"B180", css: "text_end", value:"382,444"},
{cell:"C180", css: "text_end", value:"2.07 %"},
{cell:"D180", css: "text_end", value:"7,763"},
{cell:"E180", css: "text_end", value:"17"},
{cell:"F180", css: "text_end", value:"22,810"},
{cell:"G180", css: "text_end", value:"1,519"},
{cell:"H180", css: "text_end", value:"42 %"},
{cell:"I180", css: "text_end", value:"0.01 %"},
{cell:"A181",css:"bold",value:"Iceland"},
{cell:"B181", css: "text_end", value:"337,780"},
{cell:"C181", css: "text_end", value:"0.82 %"},
{cell:"D181", css: "text_end", value:"2,755"},
{cell:"E181", css: "text_end", value:"3"},
{cell:"F181", css: "text_end", value:"100,250"},
{cell:"G181", css: "text_end", value:"-433"},
{cell:"H181", css: "text_end", value:"96 %"},
{cell:"I181", css: "text_end", value:"0.00 %"},
{cell:"A182",css:"bold",value:"French Guiana"},
{cell:"B182", css: "text_end", value:"289,763"},
{cell:"C182", css: "text_end", value:"2.49 %"},
{cell:"D182", css: "text_end", value:"7,032"},
{cell:"E182", css: "text_end", value:"4"},
{cell:"F182", css: "text_end", value:"82,200"},
{cell:"G182", css: "text_end", value:"1,200"},
{cell:"H182", css: "text_end", value:"80 %"},
{cell:"I182", css: "text_end", value:"0.00 %"},
{cell:"A183",css:"bold",value:"Barbados"},
{cell:"B183", css: "text_end", value:"286,388"},
{cell:"C183", css: "text_end", value:"0.23 %"},
{cell:"D183", css: "text_end", value:"669"},
{cell:"E183", css: "text_end", value:"666"},
{cell:"F183", css: "text_end", value:"430"},
{cell:"G183", css: "text_end", value:"436"},
{cell:"H183", css: "text_end", value:"32 %"},
{cell:"I183", css: "text_end", value:"0.00 %"},
{cell:"A184",css:"bold",value:"French Polynesia"},
{cell:"B184", css: "text_end", value:"285,859"},
{cell:"C184", css: "text_end", value:"1.01 %"},
{cell:"D184", css: "text_end", value:"2,852"},
{cell:"E184", css: "text_end", value:"78"},
{cell:"F184", css: "text_end", value:"3,660"},
{cell:"G184", css: "text_end", value:"-1,000"},
{cell:"H184", css: "text_end", value:"56 %"},
{cell:"I184", css: "text_end", value:"0.00 %"},
{cell:"A185",css:"bold",value:"Vanuatu"},
{cell:"B185", css: "text_end", value:"282,117"},
{cell:"C185", css: "text_end", value:"2.13 %"},
{cell:"D185", css: "text_end", value:"5,873"},
{cell:"E185", css: "text_end", value:"23"},
{cell:"F185", css: "text_end", value:"12,190"},
{cell:"G185", css: "text_end", value:"121"},
{cell:"H185", css: "text_end", value:"26 %"},
{cell:"I185", css: "text_end", value:"0.00 %"},
{cell:"A186",css:"bold",value:"New Caledonia"},
{cell:"B186", css: "text_end", value:"279,821"},
{cell:"C186", css: "text_end", value:"1.29 %"},
{cell:"D186", css: "text_end", value:"3,566"},
{cell:"E186", css: "text_end", value:"15"},
{cell:"F186", css: "text_end", value:"18,280"},
{cell:"G186", css: "text_end", value:"1,132"},
{cell:"H186", css: "text_end", value:"69 %"},
{cell:"I186", css: "text_end", value:"0.00 %"},
{cell:"A187",css:"bold",value:"Mayotte"},
{cell:"B187", css: "text_end", value:"259,682"},
{cell:"C187", css: "text_end", value:"2.62 %"},
{cell:"D187", css: "text_end", value:"6,637"},
{cell:"E187", css: "text_end", value:"692"},
{cell:"F187", css: "text_end", value:"375"},
{cell:"G187", css: "text_end", value:"-300"},
{cell:"H187", css: "text_end", value:"44 %"},
{cell:"I187", css: "text_end", value:"0.00 %"},
{cell:"A188",css:"bold",value:"Sao Tome & Principe"},
{cell:"B188", css: "text_end", value:"208,818"},
{cell:"C188", css: "text_end", value:"2.20 %"},
{cell:"D188", css: "text_end", value:"4,491"},
{cell:"E188", css: "text_end", value:"218"},
{cell:"F188", css: "text_end", value:"960"},
{cell:"G188", css: "text_end", value:"-1,120"},
{cell:"H188", css: "text_end", value:"67 %"},
{cell:"I188", css: "text_end", value:"0.00 %"},
{cell:"A189",css:"bold",value:"Samoa"},
{cell:"B189", css: "text_end", value:"197,695"},
{cell:"C189", css: "text_end", value:"0.64 %"},
{cell:"D189", css: "text_end", value:"1,255"},
{cell:"E189", css: "text_end", value:"70"},
{cell:"F189", css: "text_end", value:"2,830"},
{cell:"G189", css: "text_end", value:"-2,538"},
{cell:"H189", css: "text_end", value:"19 %"},
{cell:"I189", css: "text_end", value:"0.00 %"},
{cell:"A190",css:"bold",value:"Saint Lucia"},
{cell:"B190", css: "text_end", value:"179,667"},
{cell:"C190", css: "text_end", value:"0.46 %"},
{cell:"D190", css: "text_end", value:"823"},
{cell:"E190", css: "text_end", value:"295"},
{cell:"F190", css: "text_end", value:"610"},
{cell:"G190", css: "text_end", value:"8"},
{cell:"H190", css: "text_end", value:"19 %"},
{cell:"I190", css: "text_end", value:"0.00 %"},
{cell:"A191",css:"bold",value:"Channel Islands"},
{cell:"B191", css: "text_end", value:"166,083"},
{cell:"C191", css: "text_end", value:"0.47 %"},
{cell:"D191", css: "text_end", value:"769"},
{cell:"E191", css: "text_end", value:"874"},
{cell:"F191", css: "text_end", value:"190"},
{cell:"G191", css: "text_end", value:"731"},
{cell:"H191", css: "text_end", value:"31 %"},
{cell:"I191", css: "text_end", value:"0.00 %"},
{cell:"A192",css:"bold",value:"Guam"},
{cell:"B192", css: "text_end", value:"165,718"},
{cell:"C192", css: "text_end", value:"0.91 %"},
{cell:"D192", css: "text_end", value:"1,489"},
{cell:"E192", css: "text_end", value:"307"},
{cell:"F192", css: "text_end", value:"540"},
{cell:"G192", css: "text_end", value:"-1,519"},
{cell:"H192", css: "text_end", value:"N.A."},
{cell:"I192", css: "text_end", value:"0.00 %"},
{cell:"A193",css:"bold",value:"CuraГ§ao"},
{cell:"B193", css: "text_end", value:"161,577"},
{cell:"C193", css: "text_end", value:"0.65 %"},
{cell:"D193", css: "text_end", value:"1,038"},
{cell:"E193", css: "text_end", value:"364"},
{cell:"F193", css: "text_end", value:"444"},
{cell:"G193", css: "text_end", value:"1,363"},
{cell:"H193", css: "text_end", value:"93 %"},
{cell:"I193", css: "text_end", value:"0.00 %"},
{cell:"A194",css:"bold",value:"Kiribati"},
{cell:"B194", css: "text_end", value:"118,414"},
{cell:"C194", css: "text_end", value:"1.73 %"},
{cell:"D194", css: "text_end", value:"2,016"},
{cell:"E194", css: "text_end", value:"146"},
{cell:"F194", css: "text_end", value:"810"},
{cell:"G194", css: "text_end", value:"-426"},
{cell:"H194", css: "text_end", value:"41 %"},
{cell:"I194", css: "text_end", value:"0.00 %"},
{cell:"A195",css:"bold",value:"St. Vincent & Grenadines"},
{cell:"B195", css: "text_end", value:"110,200"},
{cell:"C195", css: "text_end", value:"0.28 %"},
{cell:"D195", css: "text_end", value:"303"},
{cell:"E195", css: "text_end", value:"283"},
{cell:"F195", css: "text_end", value:"390"},
{cell:"G195", css: "text_end", value:"-1,000"},
{cell:"H195", css: "text_end", value:"51 %"},
{cell:"I195", css: "text_end", value:"0.00 %"},
{cell:"A196",css:"bold",value:"Tonga"},
{cell:"B196", css: "text_end", value:"109,008"},
{cell:"C196", css: "text_end", value:"0.91 %"},
{cell:"D196", css: "text_end", value:"988"},
{cell:"E196", css: "text_end", value:"151"},
{cell:"F196", css: "text_end", value:"720"},
{cell:"G196", css: "text_end", value:"-1,616"},
{cell:"H196", css: "text_end", value:"24 %"},
{cell:"I196", css: "text_end", value:"0.00 %"},
{cell:"A197",css:"bold",value:"Grenada"},
{cell:"B197", css: "text_end", value:"108,339"},
{cell:"C197", css: "text_end", value:"0.48 %"},
{cell:"D197", css: "text_end", value:"514"},
{cell:"E197", css: "text_end", value:"319"},
{cell:"F197", css: "text_end", value:"340"},
{cell:"G197", css: "text_end", value:"-855"},
{cell:"H197", css: "text_end", value:"35 %"},
{cell:"I197", css: "text_end", value:"0.00 %"},
{cell:"A198",css:"bold",value:"Micronesia"},
{cell:"B198", css: "text_end", value:"106,227"},
{cell:"C198", css: "text_end", value:"0.65 %"},
{cell:"D198", css: "text_end", value:"683"},
{cell:"E198", css: "text_end", value:"152"},
{cell:"F198", css: "text_end", value:"700"},
{cell:"G198", css: "text_end", value:"-1,638"},
{cell:"H198", css: "text_end", value:"23 %"},
{cell:"I198", css: "text_end", value:"0.00 %"},
{cell:"A199",css:"bold",value:"Aruba"},
{cell:"B199", css: "text_end", value:"105,670"},
{cell:"C199", css: "text_end", value:"0.39 %"},
{cell:"D199", css: "text_end", value:"406"},
{cell:"E199", css: "text_end", value:"587"},
{cell:"F199", css: "text_end", value:"180"},
{cell:"G199", css: "text_end", value:"251"},
{cell:"H199", css: "text_end", value:"41 %"},
{cell:"I199", css: "text_end", value:"0.00 %"},
{cell:"A200",css:"bold",value:"U.S. Virgin Islands"},
{cell:"B200", css: "text_end", value:"104,914"},
{cell:"C200", css: "text_end", value:"0.01 %"},
{cell:"D200", css: "text_end", value:"13"},
{cell:"E200", css: "text_end", value:"300"},
{cell:"F200", css: "text_end", value:"350"},
{cell:"G200", css: "text_end", value:"-900"},
{cell:"H200", css: "text_end", value:"97 %"},
{cell:"I200", css: "text_end", value:"0.00 %"},
{cell:"A201",css:"bold",value:"Antigua and Barbuda"},
{cell:"B201", css: "text_end", value:"103,050"},
{cell:"C201", css: "text_end", value:"1.02 %"},
{cell:"D201", css: "text_end", value:"1,038"},
{cell:"E201", css: "text_end", value:"234"},
{cell:"F201", css: "text_end", value:"440"},
{cell:"G201", css: "text_end", value:"-11"},
{cell:"H201", css: "text_end", value:"21 %"},
{cell:"I201", css: "text_end", value:"0.00 %"},
{cell:"A202",css:"bold",value:"Seychelles"},
{cell:"B202", css: "text_end", value:"95,235"},
{cell:"C202", css: "text_end", value:"0.53 %"},
{cell:"D202", css: "text_end", value:"498"},
{cell:"E202", css: "text_end", value:"207"},
{cell:"F202", css: "text_end", value:"460"},
{cell:"G202", css: "text_end", value:"-440"},
{cell:"H202", css: "text_end", value:"54 %"},
{cell:"I202", css: "text_end", value:"0.00 %"},
{cell:"A203",css:"bold",value:"Isle of Man"},
{cell:"B203", css: "text_end", value:"84,831"},
{cell:"C203", css: "text_end", value:"0.65 %"},
{cell:"D203", css: "text_end", value:"544"},
{cell:"E203", css: "text_end", value:"149"},
{cell:"F203", css: "text_end", value:"570"},
{cell:"H203", css: "text_end", value:"54 %"},
{cell:"I203", css: "text_end", value:"0.00 %"},
{cell:"A204", css: "text_end", css:"bold",value:"Andorra"},
{cell:"B204", css: "text_end", value:"76,953"},
{cell:"C204", css: "text_end", value:"-0.02 %"},
{cell:"D204", css: "text_end", value:"-12"},
{cell:"E204", css: "text_end", value:"164"},
{cell:"F204", css: "text_end", value:"470"},
{cell:"H204", css: "text_end", value:"90 %"},
{cell:"I204", css: "text_end", value:"0.00 %"},
{cell:"A205", css: "text_end", css:"bold",value:"Dominica"},
{cell:"B205", css: "text_end", value:"74,308"},
{cell:"C205", css: "text_end", value:"0.52 %"},
{cell:"D205", css: "text_end", value:"383"},
{cell:"E205", css: "text_end", value:"99"},
{cell:"F205", css: "text_end", value:"750"},
{cell:"H205", css: "text_end", value:"69 %"},
{cell:"I205", css: "text_end", value:"0.00 %"},
{cell:"A206", css: "text_end", css:"bold",value:"Cayman Islands"},
{cell:"B206", css: "text_end", value:"62,348"},
{cell:"C206", css: "text_end", value:"1.28 %"},
{cell:"D206", css: "text_end", value:"789"},
{cell:"E206", css: "text_end", value:"260"},
{cell:"F206", css: "text_end", value:"240"},
{cell:"H206", css: "text_end", value:"98 %"},
{cell:"I206", css: "text_end", value:"0.00 %"},
{cell:"A207", css: "text_end", css:"bold",value:"Bermuda"},
{cell:"B207", css: "text_end", value:"61,070"},
{cell:"C207", css: "text_end", value:"-0.45 %"},
{cell:"D207", css: "text_end", value:"-279"},
{cell:"E207", css: "text_end", value:"1,221"},
{cell:"F207", css: "text_end", value:"50"},
{cell:"H207", css: "text_end", value:"N.A."},
{cell:"I207", css: "text_end", value:"0.00 %"},
{cell:"A208", css: "text_end", css:"bold",value:"Greenland"},
{cell:"B208", css: "text_end", value:"56,565"},
{cell:"C208", css: "text_end", value:"0.15 %"},
{cell:"D208", css: "text_end", value:"85"},
{cell:"E208", css: "text_end", value:"0"},
{cell:"F208", css: "text_end", value:"410,450"},
{cell:"H208", css: "text_end", value:"88 %"},
{cell:"I208", css: "text_end", value:"0.00 %"},
{cell:"A209", css: "text_end", css:"bold",value:"Saint Kitts & Nevis"},
{cell:"B209", css: "text_end", value:"55,850"},
{cell:"C209", css: "text_end", value:"0.91 %"},
{cell:"D209", css: "text_end", value:"505"},
{cell:"E209", css: "text_end", value:"215"},
{cell:"F209", css: "text_end", value:"260"},
{cell:"H209", css: "text_end", value:"33 %"},
{cell:"I209", css: "text_end", value:"0.00 %"},
{cell:"A210", css: "text_end", css:"bold",value:"American Samoa"},
{cell:"B210", css: "text_end", value:"55,679"},
{cell:"C210", css: "text_end", value:"0.07 %"},
{cell:"D210", css: "text_end", value:"38"},
{cell:"E210", css: "text_end", value:"278"},
{cell:"F210", css: "text_end", value:"200"},
{cell:"H210", css: "text_end", value:"88 %"},
{cell:"I210", css: "text_end", value:"0.00 %"},
{cell:"A211", css: "text_end", css:"bold",value:"Northern Mariana Islands"},
{cell:"B211", css: "text_end", value:"55,194"},
{cell:"C211", css: "text_end", value:"0.09 %"},
{cell:"D211", css: "text_end", value:"50"},
{cell:"E211", css: "text_end", value:"120"},
{cell:"F211", css: "text_end", value:"460"},
{cell:"H211", css: "text_end", value:"90 %"},
{cell:"I211", css: "text_end", value:"0.00 %"},
{cell:"A212", css: "text_end", css:"bold",value:"Marshall Islands"},
{cell:"B212", css: "text_end", value:"53,167"},
{cell:"C212", css: "text_end", value:"0.08 %"},
{cell:"D212", css: "text_end", value:"40"},
{cell:"E212", css: "text_end", value:"295"},
{cell:"F212", css: "text_end", value:"180"},
{cell:"H212", css: "text_end", value:"74 %"},
{cell:"I212", css: "text_end", value:"0.00 %"},
{cell:"A213", css: "text_end", css:"bold",value:"Faeroe Islands"},
{cell:"B213", css: "text_end", value:"49,489"},
{cell:"C213", css: "text_end", value:"0.40 %"},
{cell:"D213", css: "text_end", value:"199"},
{cell:"E213", css: "text_end", value:"35"},
{cell:"F213", css: "text_end", value:"1,396"},
{cell:"H213", css: "text_end", value:"43 %"},
{cell:"I213", css: "text_end", value:"0.00 %"},
{cell:"A214", css: "text_end", css:"bold",value:"Sint Maarten"},
{cell:"B214", css: "text_end", value:"40,552"},
{cell:"C214", css: "text_end", value:"1.08 %"},
{cell:"D214", css: "text_end", value:"432"},
{cell:"E214", css: "text_end", value:"1,193"},
{cell:"F214", css: "text_end", value:"34"},
{cell:"H214", css: "text_end", value:"N.A."},
{cell:"I214", css: "text_end", value:"0.00 %"},
{cell:"A215", css: "text_end", css:"bold",value:"Monaco"},
{cell:"B215", css: "text_end", value:"38,897"},
{cell:"C215", css: "text_end", value:"0.52 %"},
{cell:"D215", css: "text_end", value:"202"},
{cell:"E215", css: "text_end", value:"26,105"},
{cell:"F215", css: "text_end", value:"1"},
{cell:"H215", css: "text_end", value:"N.A."},
{cell:"I215", css: "text_end", value:"0.00 %"},
{cell:"A216", css: "text_end", css:"bold",value:"Liechtenstein"},
{cell:"B216", css: "text_end", value:"38,155"},
{cell:"C216", css: "text_end", value:"0.61 %"},
{cell:"D216", css: "text_end", value:"233"},
{cell:"E216", css: "text_end", value:"238"},
{cell:"F216", css: "text_end", value:"160"},
{cell:"H216", css: "text_end", value:"14 %"},
{cell:"I216", css: "text_end", value:"0.00 %"},
{cell:"A217", css: "text_end", css:"bold",value:"Turks and Caicos"},
{cell:"B217", css: "text_end", value:"35,963"},
{cell:"C217", css: "text_end", value:"1.46 %"},
{cell:"D217", css: "text_end", value:"517"},
{cell:"E217", css: "text_end", value:"38"},
{cell:"F217", css: "text_end", value:"950"},
{cell:"H217", css: "text_end", value:"91 %"},
{cell:"I217", css: "text_end", value:"0.00 %"},
{cell:"A218", css: "text_end", css:"bold",value:"Gibraltar"},
{cell:"B218", css: "text_end", value:"34,733"},
{cell:"C218", css: "text_end", value:"0.47 %"},
{cell:"D218", css: "text_end", value:"162"},
{cell:"E218", css: "text_end", value:"3,473"},
{cell:"F218", css: "text_end", value:"10"},
{cell:"H218", css: "text_end", value:"85 %"},
{cell:"I218", css: "text_end", value:"0.00 %"},
{cell:"A219", css: "text_end", css:"bold",value:"San Marino"},
{cell:"B219", css: "text_end", value:"33,557"},
{cell:"C219", css: "text_end", value:"0.47 %"},
{cell:"D219", css: "text_end", value:"157"},
{cell:"E219", css: "text_end", value:"559"},
{cell:"F219", css: "text_end", value:"60"},
{cell:"H219", css: "text_end", value:"90 %"},
{cell:"I219", css: "text_end", value:"0.00 %"},
{cell:"A220", css: "text_end", css:"bold",value:"British Virgin Islands"},
{cell:"B220", css: "text_end", value:"31,719"},
{cell:"C220", css: "text_end", value:"1.68 %"},
{cell:"D220", css: "text_end", value:"523"},
{cell:"E220", css: "text_end", value:"211"},
{cell:"F220", css: "text_end", value:"150"},
{cell:"H220", css: "text_end", value:"43 %"},
{cell:"I220", css: "text_end", value:"0.00 %"},
{cell:"A221", css: "text_end", css:"bold",value:"Caribbean Netherlands"},
{cell:"B221", css: "text_end", value:"25,702"},
{cell:"C221", css: "text_end", value:"1.20 %"},
{cell:"D221", css: "text_end", value:"304"},
{cell:"E221", css: "text_end", value:"78"},
{cell:"F221", css: "text_end", value:"328"},
{cell:"H221", css: "text_end", value:"60 %"},
{cell:"I221", css: "text_end", value:"0.00 %"},
{cell:"A222", css: "text_end", css:"bold",value:"Palau"},
{cell:"B222", css: "text_end", value:"21,964"},
{cell:"C222", css: "text_end", value:"1.08 %"},
{cell:"D222", css: "text_end", value:"235"},
{cell:"E222", css: "text_end", value:"48"},
{cell:"F222", css: "text_end", value:"460"},
{cell:"H222", css: "text_end", value:"87 %"},
{cell:"I222", css: "text_end", value:"0.00 %"},
{cell:"A223", css: "text_end", css:"bold",value:"Cook Islands"},
{cell:"B223", css: "text_end", value:"17,411"},
{cell:"C223", css: "text_end", value:"0.18 %"},
{cell:"D223", css: "text_end", value:"31"},
{cell:"E223", css: "text_end", value:"73"},
{cell:"F223", css: "text_end", value:"240"},
{cell:"H223", css: "text_end", value:"91 %"},
{cell:"I223", css: "text_end", value:"0.00 %"},
{cell:"A224", css: "text_end", css:"bold",value:"Anguilla"},
{cell:"B224", css: "text_end", value:"15,045"},
{cell:"C224", css: "text_end", value:"0.91 %"},
{cell:"D224", css: "text_end", value:"136"},
{cell:"E224", css: "text_end", value:"167"},
{cell:"F224", css: "text_end", value:"90"},
{cell:"H224", css: "text_end", value:"99 %"},
{cell:"I224", css: "text_end", value:"0.00 %"},
{cell:"A225", css: "text_end", css:"bold",value:"Wallis & Futuna"},
{cell:"B225", css: "text_end", value:"11,683"},
{cell:"C225", css: "text_end", value:"-0.76 %"},
{cell:"D225", css: "text_end", value:"-90"},
{cell:"E225", css: "text_end", value:"83"},
{cell:"F225", css: "text_end", value:"140"},
{cell:"H225", css: "text_end", value:"0 %"},
{cell:"I225", css: "text_end", value:"0.00 %"},
{cell:"A226", css: "text_end", css:"bold",value:"Nauru"},
{cell:"B226", css: "text_end", value:"11,312"},
{cell:"C226", css: "text_end", value:"-0.41 %"},
{cell:"D226", css: "text_end", value:"-47"},
{cell:"E226", css: "text_end", value:"566"},
{cell:"F226", css: "text_end", value:"20"},
{cell:"H226", css: "text_end", value:"90 %"},
{cell:"I226", css: "text_end", value:"0.00 %"},
{cell:"A227", css: "text_end", css:"bold",value:"Tuvalu"},
{cell:"B227", css: "text_end", value:"11,287"},
{cell:"C227", css: "text_end", value:"0.85 %"},
{cell:"D227", css: "text_end", value:"95"},
{cell:"E227", css: "text_end", value:"376"},
{cell:"F227", css: "text_end", value:"30"},
{cell:"H227", css: "text_end", value:"54 %"},
{cell:"I227", css: "text_end", value:"0.00 %"},
{cell:"A228", css: "text_end", css:"bold",value:"Saint Pierre & Miquelon"},
{cell:"B228", css: "text_end", value:"6,342"},
{cell:"C228", css: "text_end", value:"0.35 %"},
{cell:"D228", css: "text_end", value:"22"},
{cell:"E228", css: "text_end", value:"28"},
{cell:"F228", css: "text_end", value:"230"},
{cell:"H228", css: "text_end", value:"86 %"},
{cell:"I228", css: "text_end", value:"0.00 %"},
{cell:"A229", css: "text_end", css:"bold",value:"Montserrat"},
{cell:"B229", css: "text_end", value:"5,203"},
{cell:"C229", css: "text_end", value:"0.50 %"},
{cell:"D229", css: "text_end", value:"26"},
{cell:"E229", css: "text_end", value:"52"},
{cell:"F229", css: "text_end", value:"100"},
{cell:"H229", css: "text_end", value:"9 %"},
{cell:"I229", css: "text_end", value:"0.00 %"},
{cell:"A230", css: "text_end", css:"bold",value:"Saint Helena"},
{cell:"B230", css: "text_end", value:"4,074"},
{cell:"C230", css: "text_end", value:"0.62 %"},
{cell:"D230", css: "text_end", value:"25"},
{cell:"E230", css: "text_end", value:"10"},
{cell:"F230", css: "text_end", value:"390"},
{cell:"H230", css: "text_end", value:"40 %"},
{cell:"I230", css: "text_end", value:"0.00 %"},
{cell:"A231", css: "text_end", css:"bold",value:"Falkland Islands"},
{cell:"B231", css: "text_end", value:"2,922"},
{cell:"C231", css: "text_end", value:"0.41 %"},
{cell:"D231", css: "text_end", value:"12"},
{cell:"E231", css: "text_end", value:"0"},
{cell:"F231", css: "text_end", value:"12,170"},
{cell:"H231", css: "text_end", value:"81 %"},
{cell:"I231", css: "text_end", value:"0.00 %"},
{cell:"A232", css: "text_end", css:"bold",value:"Niue"},
{cell:"B232", css: "text_end", value:"1,624"},
{cell:"C232", css: "text_end", value:"0.37 %"},
{cell:"D232", css: "text_end", value:"6"},
{cell:"E232", css: "text_end", value:"6"},
{cell:"F232", css: "text_end", value:"260"},
{cell:"H232", css: "text_end", value:"33 %"},
{cell:"I232", css: "text_end", value:"0.00 %"},
{cell:"A233", css: "text_end", css:"bold",value:"Tokelau"},
{cell:"B233", css: "text_end", value:"1,319"},
{cell:"C233", css: "text_end", value:"1.46 %"},
{cell:"D233", css: "text_end", value:"19"},
{cell:"E233", css: "text_end", value:"132"},
{cell:"F233", css: "text_end", value:"10"},
{cell:"H233", css: "text_end", value:"0 %"},
{cell:"I233", css: "text_end", value:"0.00 %"},
{cell:"A234", css: "text_end", css:"bold",value:"Holy See"},
{cell:"B234", css: "text_end", value:"801"},
{cell:"C234", css: "text_end", value:"1.14 %"},
{cell:"D234", css: "text_end", value:"9"},
{cell:"E234", css: "text_end", value:"2,003"},
{cell:"F234", css: "text_end", value:"0"},
{cell:"H234", css: "text_end", value:"N.A."},
{cell:"I234", css: "text_end", value:"0.00 %"}
]
},
{
name: "Report",
data: [
{
cell: "B1",
css: "text_end bold",
format: "General",
value: "Average",
},
{
cell: "C1",
css: "text_end bold",
format: "General",
value: "Product's Share",
},
{
cell: "D1",
css: "text_end bold",
format: "General",
value: "Min",
},
{
cell: "E1",
css: "text_end bold",
format: "General",
value: "Max",
},
{
cell: "F1",
css: "text_end bold",
format: "General",
value: "NET",
},
{
cell: "A2",
css: "bold",
format: "General",
value: "Drone",
},
{
cell: "B2",
css: "text_end",
format: "currency",
value: "=AVERAGE(Income!B2:M2)",
},
{
cell: "C2",
format: "percent",
css: "text_end",
value: "=Income!B2/Income!B12",
},
{
cell: "D2",
format: "currency",
css: "text_end",
value: "=MIN(Income!B2:M2)",
},
{
cell: "E2",
format: "currency",
css: "text_end",
value: "=MAX(Income!B2:M2)",
},
{
cell: "F2",
format: "currency",
css: "text_end",
value: "=Income!N2-Expenses!E2",
},
{
cell: "A3",
format: "General",
css: "bold",
value: "VR Glasses",
},
{
cell: "B3",
format: "currency",
css: "text_end",
value: "=AVERAGE(Income!B3:M3)",
},
{
cell: "C3",
format: "percent",
css: "text_end",
value: "=Income!B3/Income!B12",
},
{
cell: "D3",
format: "currency",
css: "text_end",
value: "=MIN(Income!B3:M3)",
},
{
cell: "E3",
format: "currency",
css: "text_end",
value: "=MAX(Income!B3:M3)",
},
{
cell: "F3",
format: "currency",
css: "text_end",
value: "=Income!N3-Expenses!E3",
},
{
cell: "A4",
format: "General",
css: "bold",
value: "Voice Remote Control",
},
{
cell: "B4",
format: "currency",
css: "text_end",
value: "=AVERAGE(Income!B4:M4)",
},
{
cell: "C4",
format: "percent",
css: "text_end",
value: "=Income!B4/Income!B12",
},
{
cell: "D4",
format: "currency",
css: "text_end",
value: "=MIN(Income!B4:M4)",
},
{
cell: "E4",
format: "currency",
css: "text_end",
value: "=MAX(Income!B4:M4)",
},
{
cell: "F4",
format: "currency",
css: "text_end",
value: "=Income!N4-Expenses!E4",
},
{
cell: "A5",
format: "General",
css: "bold",
value: "Touch Projector",
},
{
cell: "B5",
format: "currency",
css: "text_end",
value: "=AVERAGE(Income!B5:M5)",
},
{
cell: "C5",
format: "percent",
css: "text_end",
value: "=Income!B5/Income!B12",
},
{
cell: "D5",
format: "currency",
css: "text_end",
value: "=MIN(Income!B5:M5)",
},
{
cell: "E5",
format: "currency",
css: "text_end",
value: "=MAX(Income!B5:M5)",
},
{
cell: "F5",
format: "currency",
css: "red_text text_end",
value: "=Income!N5-Expenses!E5",
},
{
cell: "A6",
format: "General",
css: "bold",
value: "Smart Band",
},
{
cell: "B6",
format: "currency",
css: "text_end",
value: "=AVERAGE(Income!B6:M6)",
},
{
cell: "C6",
format: "percent",
css: "text_end",
value: "=Income!B6/Income!B12",
},
{
cell: "D6",
format: "currency",
css: "text_end",
value: "=MIN(Income!B6:M6)",
},
{
cell: "E6",
format: "currency",
css: "text_end",
value: "=MAX(Income!B6:M6)",
},
{
cell: "F6",
format: "currency",
css: "text_end",
value: "=Income!N6-Expenses!E6",
},
{
cell: "A7",
format: "General",
css: "bold",
value: "Video Doorbell",
},
{
cell: "B7",
format: "currency",
css: "text_end",
value: "=AVERAGE(Income!B7:M7)",
},
{
cell: "C7",
format: "percent",
css: "text_end",
value: "=Income!B7/Income!B12",
},
{
cell: "D7",
format: "currency",
css: "text_end",
value: "=MIN(Income!B7:M7)",
},
{
cell: "E7",
format: "currency",
css: "text_end",
value: "=MAX(Income!B7:M7)",
},
{
cell: "F7",
format: "currency",
css: "text_end",
value: "=Income!N7-Expenses!E7",
},
{
cell: "A8",
format: "General",
css: "bold",
value: "Smart TV",
},
{
cell: "B8",
css: "text_end",
format: "currency",
value: "=AVERAGE(Income!B8:M8)",
},
{
cell: "C8",
format: "percent",
css: "text_end",
value: "=Income!B8/Income!B12",
},
{
cell: "D8",
format: "currency",
css: "text_end",
value: "=MIN(Income!B8:M8)",
},
{
cell: "E8",
format: "currency",
css: "text_end",
value: "=MAX(Income!B8:M8)",
},
{
cell: "F8",
format: "currency",
css: "text_end",
value: "=Income!N8-Expenses!E8",
},
{
cell: "A9",
format: "General",
css: "bold",
value: "Robot Vacuum",
},
{
cell: "B9",
format: "currency",
css: "text_end",
value: "=AVERAGE(Income!B9:M9)",
},
{
cell: "C9",
format: "percent",
css: "text_end",
value: "=Income!B9/Income!B12",
},
{
cell: "D9",
format: "currency",
css: "text_end",
value: "=MIN(Income!B9:M9)",
},
{
cell: "E9",
format: "currency",
css: "text_end",
value: "=MAX(Income!B9:M9)",
},
{
cell: "F9",
format: "currency",
css: "text_end",
value: "=Income!N9-Expenses!E9",
},
{
cell: "A10",
format: "General",
css: "bold",
value: "Air Purifier",
},
{
cell: "B10",
format: "currency",
css: "text_end",
value: "=AVERAGE(Income!B10:M10)",
},
{
cell: "C10",
format: "percent",
css: "text_end",
value: "=Income!B10/Income!B12",
},
{
cell: "D10",
format: "currency",
css: "text_end",
value: "=MIN(Income!B10:M10)",
},
{
cell: "E10",
format: "currency",
css: "text_end",
value: "=MAX(Income!B10:M10)",
},
{
cell: "F10",
format: "currency",
css: "text_end",
value: "=Income!N10-Expenses!E10",
},
{
cell: "A11",
format: "General",
css: "bold",
value: "Baby Monitor",
},
{
cell: "B11",
format: "currency",
css: "text_end",
value: "=AVERAGE(Income!B11:M11)",
},
{
cell: "C11",
format: "percent",
css: "text_end",
value: "=Income!B11/Income!B12",
},
{
cell: "D11",
format: "currency",
css: "text_end",
value: "=MIN(Income!B11:M11)",
},
{
cell: "E11",
format: "currency",
css: "text_end",
value: "=MAX(Income!B11:M11)",
},
{
cell: "F11",
format: "currency",
css: "text_end",
value: "=Income!N11-Expenses!E11",
},
{
cell: "A12",
format: "General",
value: "Total",
css: "bold"
},
{
cell: "B12",
},
{
cell: "C12",
},
{
cell: "D12",
},
{
cell: "E12",
},
{
cell: "F12",
css: "green_text",
format: "currency",
css: "text_end bold",
value: "=Income!N12-Expenses!E12",
},
],
},
{
name: "Income",
data: [
{
cell: "B1",
css: "text_end bold",
format: "General",
value: "Jan",
},
{
cell: "C1",
css: "text_end bold",
format: "General",
value: "Feb",
},
{
cell: "D1",
css: "text_end bold",
format: "General",
value: "Mar",
},
{
cell: "E1",
css: "text_end bold",
format: "General",
value: "Apr",
},
{
cell: "F1",
css: "text_end bold",
format: "General",
value: "May",
},
{
cell: "G1",
css: "text_end bold",
format: "General",
value: "Jun",
},
{
cell: "H1",
css: "text_end bold",
format: "General",
value: "Jul",
},
{
cell: "I1",
css: "text_end bold",
format: "General",
value: "Aug",
},
{
cell: "J1",
css: "text_end bold",
format: "General",
value: "Sep",
},
{
cell: "K1",
css: "text_end bold",
format: "General",
value: "Oct",
},
{
cell: "L1",
css: "text_end bold",
format: "General",
value: "Nov",
},
{
cell: "M1",
css: "text_end bold",
format: "General",
value: "Dec",
},
{
cell: "N1",
css: "text_end bold",
format: "General",
value: "Total" ,
},
{
cell: "A2",
format: "General",
css: "bold",
value: "Drone",
},
{
cell: "B2",
css: "text_end",
format: "currency",
value: 500000,
},
{
cell: "C2",
css: "text_end",
format: "currency",
value: 200000,
},
{
cell: "D2",
css: "text_end",
format: "currency",
value: 700000,
},
{
cell: "E2",
css: "text_end",
format: "currency",
value: 750000,
},
{
cell: "F2",
css: "text_end",
format: "currency",
value: 600000,
},
{
cell: "G2",
css: "text_end",
format: "currency",
value: 800000,
},
{
cell: "H2",
css: "text_end",
format: "currency",
value: 500000,
},
{
cell: "I2",
css: "text_end",
format: "currency",
value: 100000,
},
{
cell: "J2",
css: "text_end",
format: "currency",
value: 750000,
},
{
cell: "K2",
css: "text_end",
format: "currency",
value: 900000,
},
{
cell: "L2",
css: "text_end",
format: "currency",
value: 200000,
},
{
cell: "M2",
css: "text_end",
format: "currency",
value: 950000,
},
{
cell: "N2",
css: "text_end",
format: "currency",
value: "=SUM(B2:M2)",
},
{
cell: "A3",
css: "bold",
format: "General",
value: "VR Glasses",
},
{
cell: "B3",
css: "text_end",
format: "currency",
value: 80000,
},
{
cell: "C3",
css: "text_end",
format: "currency",
value: 75000,
},
{
cell: "D3",
css: "text_end",
format: "currency",
value: 90000,
},
{
cell: "E3",
css: "text_end",
format: "currency",
value: 100000,
},
{
cell: "F3",
css: "text_end",
format: "currency",
value: 95000,
},
{
cell: "G3",
css: "text_end",
format: "currency",
value: 105000,
},
{
cell: "H3",
css: "text_end",
format: "currency",
value: 102500,
},
{
cell: "I3",
css: "text_end",
format: "currency",
value: 75000,
},
{
cell: "J3",
css: "text_end",
format: "currency",
value: 85000,
},
{
cell: "K3",
css: "text_end",
format: "currency",
value: 90000,
},
{
cell: "L3",
css: "text_end",
format: "currency",
value: 120000,
},
{
cell: "M3",
css: "text_end",
format: "currency",
value: 112500,
},
{
cell: "N3",
css: "text_end",
format: "currency",
value: "=SUM(B3:M3)",
},
{
cell: "A4",
css: "bold",
format: "General",
value: "Voice Remote Control",
},
{
cell: "B4",
css: "text_end",
format: "currency",
value: 20000,
},
{
cell: "C4",
css: "text_end",
format: "currency",
value: 25000,
},
{
cell: "D4",
css: "text_end",
format: "currency",
value: 26500,
},
{
cell: "E4",
css: "text_end",
format: "currency",
value: 25750,
},
{
cell: "F4",
css: "text_end",
format: "currency",
value: 23500,
},
{
cell: "G4",
css: "text_end",
format: "currency",
value: 21000,
},
{
cell: "H4",
css: "text_end",
format: "currency",
value: 21500,
},
{
cell: "I4",
css: "text_end",
format: "currency",
value: 19800,
},
{
cell: "J4",
css: "text_end",
format: "currency",
value: 21500,
},
{
cell: "K4",
css: "text_end",
format: "currency",
value: 25000,
},
{
cell: "L4",
css: "text_end",
format: "currency",
value: 27500,
},
{
cell: "M4",
css: "text_end",
format: "currency",
value: 26000,
},
{
cell: "N4",
css: "text_end",
format: "currency",
value: "=SUM(B4:M4)",
},
{
cell: "A5",
css: "bold",
format: "General",
value: "Touch Projector",
},
{
cell: "B5",
css: "text_end",
format: "currency",
value: "=7000",
},
{
cell: "C5",
css: "text_end",
format: "currency",
value: 9250,
},
{
cell: "D5",
css: "text_end",
format: "currency",
value: 8000,
},
{
cell: "E5",
css: "text_end",
format: "currency",
value: 9000,
},
{
cell: "F5",
css: "text_end",
format: "currency",
value: 10000,
},
{
cell: "G5",
css: "text_end",
format: "currency",
value: 8500,
},
{
cell: "H5",
css: "text_end",
format: "currency",
value: 9000,
},
{
cell: "I5",
css: "text_end",
format: "currency",
value: 7200,
},
{
cell: "J5",
css: "text_end",
format: "currency",
value: 9500,
},
{
cell: "K5",
css: "text_end",
format: "currency",
value: 10000,
},
{
cell: "L5",
css: "text_end",
format: "currency",
value: 11000,
},
{
cell: "M5",
css: "text_end",
format: "currency",
value: 9000,
},
{
cell: "N5",
css: "text_end",
format: "currency",
value: "=SUM(B5:M5)",
},
{
cell: "A6",
css: "bold",
format: "General",
value: "Smart Band",
},
{
cell: "B6",
css: "text_end",
format: "currency",
value: 50000,
},
{
cell: "C6",
css: "text_end",
format: "currency",
value: 52000,
},
{
cell: "D6",
css: "text_end",
format: "currency",
value: 53000,
},
{
cell: "E6",
css: "text_end",
format: "currency",
value: 53500,
},
{
cell: "F6",
css: "text_end",
format: "currency",
value: 52500,
},
{
cell: "G6",
css: "text_end",
format: "currency",
value: 51000,
},
{
cell: "H6",
css: "text_end",
format: "currency",
value: 50000,
},
{
cell: "I6",
css: "text_end",
format: "currency",
value: 49000,
},
{
cell: "J6",
css: "text_end",
format: "currency",
value: 51000,
},
{
cell: "K6",
css: "text_end",
format: "currency",
value: 52500,
},
{
cell: "L6",
css: "text_end",
format: "currency",
value: 56000,
},
{
cell: "M6",
css: "text_end",
format: "currency",
value: 53000,
},
{
cell: "N6",
css: "text_end",
format: "currency",
value: "=SUM(B6:M6)",
},
{
cell: "A7",
css: "bold",
format: "General",
value: "Video Doorbell",
},
{
cell: "B7",
css: "text_end",
format: "currency",
value: 18000,
},
{
cell: "C7",
css: "text_end",
format: "currency",
value: 19500,
},
{
cell: "D7",
css: "text_end",
format: "currency",
value: 20500,
},
{
cell: "E7",
css: "text_end",
format: "currency",
value: 20250,
},
{
cell: "F7",
css: "text_end",
format: "currency",
value: 20500,
},
{
cell: "G7",
css: "text_end",
format: "currency",
value: 19000,
},
{
cell: "H7",
css: "text_end",
format: "currency",
value: 18000,
},
{
cell: "I7",
css: "text_end",
format: "currency",
value: 16500,
},
{
cell: "J7",
css: "text_end",
format: "currency",
value: 17000,
},
{
cell: "K7",
css: "text_end",
format: "currency",
value: 18500,
},
{
cell: "L7",
css: "text_end",
format: "currency",
value: 19000,
},
{
cell: "M7",
css: "text_end",
format: "currency",
value: 18500,
},
{
cell: "N7",
css: "text_end",
format: "currency",
value: "=SUM(B7:M7)",
},
{
cell: "A8",
css: "bold",
format: "General",
value: "Smart TV",
},
{
cell: "B8",
css: "text_end",
format: "currency",
value: 310000,
},
{
cell: "C8",
css: "text_end",
format: "currency",
value: 295000,
},
{
cell: "D8",
css: "text_end",
format: "currency",
value: 315000,
},
{
cell: "E8",
css: "text_end",
format: "currency",
value: 320000,
},
{
cell: "F8",
css: "text_end",
format: "currency",
value: 295000,
},
{
cell: "G8",
css: "text_end",
format: "currency",
value: 280000,
},
{
cell: "H8",
css: "text_end",
format: "currency",
value: 290000,
},
{
cell: "I8",
css: "text_end",
format: "currency",
value: 285000,
},
{
cell: "J8",
css: "text_end",
format: "currency",
value: 300000,
},
{
cell: "K8",
css: "text_end",
format: "currency",
value: 315000,
},
{
cell: "L8",
css: "text_end",
format: "currency",
value: 340000,
},
{
cell: "M8",
css: "text_end",
format: "currency",
value: 335000,
},
{
cell: "N8",
css: "text_end",
format: "currency",
value: "=SUM(B8:M8)",
},
{
cell: "A9",
css: "bold",
format: "General",
value: "Robot Vacuum",
},
{
cell: "B9",
css: "text_end",
format: "currency",
value: 50000,
},
{
cell: "C9",
css: "text_end",
format: "currency",
value: 55000,
},
{
cell: "D9",
css: "text_end",
format: "currency",
value: 57500,
},
{
cell: "E9",
css: "text_end",
format: "currency",
value: 60000,
},
{
cell: "F9",
css: "text_end",
format: "currency",
value: 62500,
},
{
cell: "G9",
css: "text_end",
format: "currency",
value: 57500,
},
{
cell: "H9",
css: "text_end",
format: "currency",
value: 55000,
},
{
cell: "I9",
css: "text_end",
format: "currency",
value: 50000,
},
{
cell: "J9",
css: "text_end",
format: "currency",
value: 57500,
},
{
cell: "K9",
css: "text_end",
format: "currency",
value: 60000,
},
{
cell: "L9",
css: "text_end",
format: "currency",
value: 62500,
},
{
cell: "M9",
css: "text_end",
format: "currency",
value: 65000,
},
{
cell: "N9",
css: "text_end",
format: "currency",
value: "=SUM(B9:M9)",
},
{
cell: "A10",
css: "bold",
format: "General",
value: "Air Purifier",
},
{
cell: "B10",
css: "text_end",
format: "currency",
value: 15000,
},
{
cell: "C10",
css: "text_end",
format: "currency",
value: 20000,
},
{
cell: "D10",
css: "text_end",
format: "currency",
value: 25000,
},
{
cell: "E10",
css: "text_end",
format: "currency",
value: 30000,
},
{
cell: "F10",
css: "text_end",
format: "currency",
value: 25000,
},
{
cell: "G10",
css: "text_end",
format: "currency",
value: 27500,
},
{
cell: "H10",
css: "text_end",
format: "currency",
value: 25000,
},
{
cell: "I10",
css: "text_end",
format: "currency",
value: 20000,
},
{
cell: "J10",
css: "text_end",
format: "currency",
value: 25000,
},
{
cell: "K10",
css: "text_end",
format: "currency",
value: 30000,
},
{
cell: "L10",
css: "text_end",
format: "currency",
value: 27500,
},
{
cell: "M10",
css: "text_end",
format: "currency",
value: 30000,
},
{
cell: "N10",
css: "text_end",
format: "currency",
value: "=SUM(B10:M10)",
},
{
cell: "A11",
css: "bold",
format: "General",
value: "Baby Monitor",
},
{
cell: "B11",
css: "text_end",
format: "currency",
value: 25000,
},
{
cell: "C11",
css: "text_end",
format: "currency",
value: 27000,
},
{
cell: "D11",
css: "text_end",
format: "currency",
value: 27500,
},
{
cell: "E11",
css: "text_end",
format: "currency",
value: 26500,
},
{
cell: "F11",
css: "text_end",
format: "currency",
value: 28000,
},
{
cell: "G11",
css: "text_end",
format: "currency",
value: 29000,
},
{
cell: "H11",
css: "text_end",
format: "currency",
value: 29500,
},
{
cell: "I11",
css: "text_end",
format: "currency",
value: 25000,
},
{
cell: "J11",
css: "text_end",
format: "currency",
value: 26000,
},
{
cell: "K11",
css: "text_end",
format: "currency",
value: 27000,
},
{
cell: "L11",
css: "text_end",
format: "currency",
value: 27500,
},
{
cell: "M11",
css: "text_end",
format: "currency",
value: 25000,
},
{
cell: "N11",
css: "text_end",
format: "currency",
value: "=SUM(B11:M11)",
},
{
cell: "A12",
format: "General",
value: "Total" ,
css: "bold",
},
{
cell: "B12",
css: "text_end bold",
format: "currency",
value: "=SUM(B2:B11)",
},
{
cell: "C12",
css: "text_end bold",
format: "currency",
value: "=SUM(C2:C11)",
},
{
cell: "D12",
css: "text_end bold",
format: "currency",
value: "=SUM(D2:D11)",
},
{
cell: "E12",
css: "text_end bold",
format: "currency",
value: "=SUM(E2:E11)",
},
{
cell: "F12",
css: "text_end bold",
format: "currency",
value: "=SUM(F2:F11)",
},
{
cell: "G12",
css: "text_end bold",
format: "currency",
value: "=SUM(G2:G11)",
},
{
cell: "H12",
css: "text_end bold",
format: "currency",
value: "=SUM(H2:H11)",
},
{
cell: "I12",
css: "text_end bold",
format: "currency",
value: "=SUM(I2:I11)",
},
{
cell: "J12",
css: "text_end bold",
format: "currency",
value: "=SUM(J2:J11)",
},
{
cell: "K12",
css: "text_end bold",
format: "currency",
value: "=SUM(K2:K11)",
},
{
cell: "L12",
css: "text_end bold",
format: "currency",
value: "=SUM(L2:L11)",
},
{
cell: "M12",
css: "text_end bold",
format: "currency",
value: "=SUM(M2:M11)",
},
{
cell: "N12",
css: "text_end bold",
format: "currency",
value: "=SUM(N2:N11)",
length: 167,
},
],
},
{
name: "Expenses",
data: [
{
cell: "B1",
css: "text_end bold",
format: "General",
value: "PPC Campaigns",
},
{
cell: "C1",
css: "text_end bold",
format: "General",
value: "Sponsored Articles",
},
{ cell: "D1", css: "text_end bold", format: "General", value: "SMM" },
{ cell: "E1", format: "General", value: "Total" , css: "bold text_end" },
{
cell: "A2",
css: "bold",
format: "General",
value: "Drone",
},
{ cell: "B2", css: "text_end", format: "currency", value: 150000 },
{ cell: "C2", css: "text_end", format: "currency", value: 25000 },
{ cell: "D2", css: "text_end", format: "currency", value: 150000 },
{
cell: "E2",
css: "text_end",
format: "currency",
value: "=SUM(B2:D2)",
},
{
cell: "A3",
css: "bold",
format: "General",
value: "VR Glasses",
},
{
cell: "B3",
css: "text_end",
format: "currency",
value: 40000,
},
{
cell: "C3",
css: "text_end",
format: "currency",
value: 0,
},
{
cell: "D3",
css: "text_end",
format: "currency",
value: 15000,
},
{
cell: "E3",
css: "text_end",
format: "currency",
value: "=SUM(B3:D3)",
},
{
cell: "A4",
format: "General",
css: "bold",
value: "Voice Remote, Control",
},
{
cell: "B4",
css: "text_end",
format: "currency",
value: 25000,
},
{
cell: "C4",
css: "text_end",
format: "currency",
value: 5000,
},
{
cell: "D4",
css: "text_end",
format: "currency",
value: 5000,
},
{
cell: "E4",
css: "text_end",
format: "currency",
value: "=SUM(B4:D4)",
},
{
cell: "A5",
format: "General",
css: "bold",
value: "Touch Projec,tor",
},
{
cell: "B5",
css: "text_end",
format: "currency",
value: 105500,
},
{
cell: "C5",
css: "text_end",
format: "currency",
value: 3500,
},
{
cell: "D5",
css: "text_end",
format: "currency",
value: 3000,
},
{
cell: "E5",
css: "text_end",
format: "currency",
value: "=SUM(B5:D5)",
},
{
cell: "A6",
format: "General",
css: "bold",
value: "Smart Band",
},
{
cell: "B6",
css: "text_end",
format: "currency",
value: 50000,
},
{
cell: "C6",
css: "text_end",
format: "currency",
value: 0,
},
{
cell: "D6",
css: "text_end",
format: "currency",
value: 5000,
},
{
cell: "E6",
css: "text_end",
format: "currency",
value: "=SUM(B6:D6)",
},
{
cell: "A7",
format: "General",
css: "bold",
value: "Video Doorbe,ll",
},
{
cell: "B7",
css: "text_end",
format: "currency",
value: 5000,
},
{
cell: "C7",
css: "text_end",
format: "currency",
value: 5000,
},
{
cell: "D7",
css: "text_end",
format: "currency",
value: 500,
},
{
cell: "E7",
css: "text_end",
format: "currency",
value: "=SUM(B7:D7)",
},
{
cell: "A8",
format: "General",
css: "bold",
value: "Smart TV",
},
{
cell: "B8",
css: "text_end",
format: "currency",
value: 50000,
},
{
cell: "C8",
css: "text_end",
format: "currency",
value: 30000,
},
{
cell: "D8",
css: "text_end",
format: "currency",
value: 10000,
},
{
cell: "E8",
css: "text_end",
format: "currency",
value: "=SUM(B8:D8)",
},
{
cell: "A9",
format: "General",
css: "bold",
value: "Robot Vacuum",
},
{
cell: "B9",
css: "text_end",
format: "currency",
value: 50000,
},
{
cell: "C9",
css: "text_end",
format: "currency",
value: 0,
},
{
cell: "D9",
css: "text_end",
format: "currency",
value: 5000,
},
{
cell: "E9",
css: "text_end",
format: "currency",
value: "=SUM(B9:D9)",
},
{
cell: "A10",
format: "General",
css: "bold",
value: "Air Purifier",
},
{
cell: "B10",
css: "text_end",
format: "currency",
value: 30000,
},
{
cell: "C10",
css: "text_end",
format: "currency",
value: 10000,
},
{
cell: "D10",
css: "text_end",
format: "currency",
value: 50000,
},
{
cell: "E10",
css: "text_end",
format: "currency",
value: "=SUM(B10:D10)",
},
{
cell: "A11",
format: "General",
css: "bold",
value: "Baby Monitor",
},
{
cell: "B11",
css: "text_end",
format: "currency",
value: 80000,
},
{
cell: "C11",
css: "text_end",
format: "currency",
value: 5000,
},
{
cell: "D11",
css: "text_end",
format: "currency",
value: 2500,
},
{
cell: "E11",
css: "text_end",
format: "currency",
value: "=SUM(B11:D11)",
},
{
cell: "A12",
format: "General",
value: "Total" ,
css: "bold",
},
{
cell: "B12",
css: "text_end bold",
format: "currency",
value: "=SUM(B2:B11)",
},
{
cell: "C12",
css: "text_end bold",
format: "currency",
value: "=SUM(C2:C11)",
},
{
cell: "D12",
css: "text_end bold",
format: "currency",
value: "=SUM(D2:D11)",
},
{
cell: "E12",
css: "bold text_end",
format: "currency",
value: "=SUM(E2:E11)",
},
],
},
{
name: "Formulas cheat sheet",
cols: [
{width: 120},
{width: 260},
],
rows: [
{height: 160},
],
data: [
{cell: "A1", value: "Check sample"},
{cell: "B1", value: "https://snippet.dhtmlx.com/wux2b35b"}
]
}
],
}
</script>White-label products and user-facing dashboards often need runtime color customization, letting administrators pick brand colors from a color picker and see the entire UI update instantly. CSS variable-based theming makes this possible without reloading the page or rebuilding stylesheets.
This example updates :root CSS variables (--dhx-h-primary, --dhx-s-primary, --dhx-l-primary) at runtime by writing new values into a <style id="themes"> element. The Spreadsheet recalculates all derived colors automatically because its internal styles reference these HSL variables. A color picker converts the selected hex color to HSL values and injects the updated CSS.
Solution overview
- Initialize the Spreadsheet with
new dhx.Spreadsheet("spreadsheet", config) - Convert the user-selected color from HEX to HSL components (hue, saturation, lightness)
- Write the updated variables into a
<style>tag targeting:rootor a specific[data-dhx-theme]selector - The Spreadsheet re-renders automatically using the new variable values
Key points
- HSL-based system: The theme uses
--dhx-h-primary,--dhx-s-primary,--dhx-l-primary. All derived colors recalculate from these three values - Per-theme overrides: Target
[data-dhx-theme='dark']instead of:rootto override colors only for a specific theme - No repaint needed: CSS variable changes take effect immediately. The browser recalculates styles without requiring manual repaint calls
API reference
- dhx.setTheme(): Applies a named theme to the Spreadsheet or a specific container.
- Themes guide: Full list of overridable CSS variables.