nodes = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data let names =[]; let tmp = 0; let cluster = "other" let clusterid = 1 let clusterX = 0 let clusterY = 0 let m = 10 const spreadsheet = await d3.tsv(url).then(nodes => nodes.forEach(function (d,i) { if(!isNaN(d.month3) && !isNaN(d["PL%"])){ d["PL%"] = parseFloat(d["PL%"]) d.PL = +d.PL switch (true) { case (d["PL%"] > 200): cluster = ">200" clusterid = 1 clusterX = 100 clusterY = 10 break; case ((d["PL%"] > 100) && (d["PL%"] < 200)): cluster = ">100<200" clusterid = 2 clusterX = 100 clusterY = 250 break; case ((d["PL%"] > 50) && (d["PL%"] <100)): cluster = ">50<100" clusterid = 3 clusterX = 100 clusterY = 450 break; case ((d["PL%"] > 0) && (d["PL%"] <50)): cluster = ">0<50" clusterid = 3 clusterX = 100 clusterY = 250 break; case ((d["PL%"] < 0) && (d["PL%"] > -25)): cluster = "<0>-25" clusterid = 4 clusterX = 800 clusterY = 250 break; case ((d["PL%"] < -25) && (d["PL%"] > -50)): cluster = "<-25>-50" clusterid = 5 clusterX = 800 clusterY = 450 break; case ((d["PL%"] < -50) && (d["PL%"] > -75)): cluster = "<-50>-75" clusterid = 6 clusterX = 800 clusterY = 250 break; case (d["PL%"] < -75): cluster = "<-75" clusterid = 6 clusterX = 800 clusterY = 10 break; } let focusX = 110 * Math.cos(clusterid / m * Math.PI * 2) let focusY = 110 * Math.sin(clusterid / m * Math.PI * 2) return names.push({"id": i,"cluster": cluster, "radius": ((Math.abs(d["PL%"]))/10)+10||10, "name": d.ShortCode, "m3": +d.month3,"m6": +d.month6,"m9": +d.month9,"m12": +d.month12,"focusX": clusterX,"focusY": clusterY, "PL%": d["PL%"]||0,"PL": +d.PL, "value":+d.PL}) }})) //((Math.abs(d["PL%"]))/10)+20||0 BY PERCENTAGE return names; }