2f:Tc22,container=htl.html`

No of companies

${TotalCompanies[0].TotalCompanies}

Median Revenue

${"$"+parseInt(MedianRevenue[0]["Median Revenue"])+"M"}

Median Employee Size

${parseInt(MedianEmployeeSize[0]["Median Employee Size"])}

Target Indutries

${horiPlot}

What Industries Are Buyers Originated From?

${viewof top50target}

${radar123}

${sunburstdemo}

${activeBuyers}

`30:T8dc, radar123= Plot.plot({ width: 450, projection: { type: "azimuthal-equidistant", rotate: [0, -90], // Note: 0.625° corresponds to max. length (here, 0.5), plus enough room for the labels domain: d3.geoCircle().center([0, 90]).radius(0.625)() }, color: { legend: true }, marks: [ // grey discs Plot.geo([0.5, 0.4, 0.3, 0.2, 0.1], { geometry: (r) => d3.geoCircle().center([0, 90]).radius(r)(), stroke: "black", fill: "black", strokeOpacity: 0.3, fillOpacity: 0.03, strokeWidth: 0.5 }), // white axes Plot.link(longitude.domain(), { x1: longitude, y1: 90 - 0.57, x2: 0, y2: 90, stroke: "white", strokeOpacity: 0.5, strokeWidth: 2.5 }), // tick labels Plot.text([0.3, 0.4, 0.5], { x: 180, y: (d) => 90 - d, dx: 2, textAnchor: "start", text: (d) => `${100 * d}%`, fill: "currentColor", stroke: "white", fontSize: 8 }), // axes labels Plot.text(longitude.domain(), { x: longitude, y: 90 - 0.57, text: Plot.identity, lineWidth: 5 }), // areas Plot.area(filteredList, { x1: ({ key }) => longitude(key), y1: ({ value }) => 90 - value, x2: 0, y2: 90, fill: "name", stroke: "name", curve: "cardinal-closed" }), // points Plot.dot(filteredList, { x: ({ key }) => longitude(key), y: ({ value }) => 90 - value, fill: "name", stroke: "white" }), // interactive labels Plot.text( filteredList, Plot.pointer({ x: ({ key }) => longitude(key), y: ({ value }) => 90 - value, text: (d) => `${(100 * d.value).toFixed(0)}%`, textAnchor: "start", dx: 4, fill: "currentColor", stroke: "white", maxRadius: 10 }) ), // interactive opacity on the areas () => svg``32:T1013,sunburstdemo = { // Specify the chart’s dimensions. const width = 928; const height = width; const radius = width / 6; // Create the color scale. const color = d3.scaleOrdinal(d3.quantize(d3.interpolateRainbow, finalData.children.length + 1)); // Compute the layout. const hierarchy = d3.hierarchy(finalData) .sum(d => d.value) .sort((a, b) => b.value - a.value); const root = d3.partition() .size([2 * Math.PI, hierarchy.height + 1]) (hierarchy); root.each(d => d.current = d); // Create the arc generator. const arc = d3.arc() .startAngle(d => d.x0) .endAngle(d => d.x1) .padAngle(d => Math.min((d.x1 - d.x0) / 2, 0.005)) .padRadius(radius * 1.5) .innerRadius(d => d.y0 * radius) .outerRadius(d => Math.max(d.y0 * radius, d.y1 * radius - 1)) // Create the SVG container. const svg = d3.create("svg") .attr("viewBox", [-width / 2, -height / 2, width, width]) .style("font", "10px sans-serif"); // Append the arcs. const path = svg.append("g") .selectAll("path") .data(root.descendants().slice(1)) .join("path") .attr("fill", d => { while (d.depth > 1) d = d.parent; return color(d.data.name); }) .attr("fill-opacity", d => arcVisible(d.current) ? (d.children ? 0.6 : 0.4) : 0) .attr("pointer-events", d => arcVisible(d.current) ? "auto" : "none") .attr("d", d => arc(d.current)); // Make them clickable if they have children. path.filter(d => d.children) .style("cursor", "pointer") .on("click", clicked); const format = d3.format(",d"); path.append("title") .text(d => `${d.ancestors().map(d => d.data.name).reverse().join("/")}\n${format(d.value)}`); const label = svg.append("g") .attr("pointer-events", "none") .attr("text-anchor", "middle") .style("user-select", "none") .selectAll("text") .data(root.descendants().slice(1)) .join("text") .attr("dy", "0.35em") .attr("fill-opacity", d => +labelVisible(d.current)) .attr("transform", d => labelTransform(d.current)) .text(d => d.data.name); const parent = svg.append("circle") .datum(root) .attr("r", radius) .attr("fill", "none") .attr("pointer-events", "all") .on("click", clicked); // Handle zoom on click. function clicked(event, p) { parent.datum(p.parent || root); root.each(d => d.target = { x0: Math.max(0, Math.min(1, (d.x0 - p.x0) / (p.x1 - p.x0))) * 2 * Math.PI, x1: Math.max(0, Math.min(1, (d.x1 - p.x0) / (p.x1 - p.x0))) * 2 * Math.PI, y0: Math.max(0, d.y0 - p.depth), y1: Math.max(0, d.y1 - p.depth) }); const t = svg.transition().duration(750); // Transition the data on all arcs, even the ones that aren’t visible, // so that if this transition is interrupted, entering arcs will start // the next transition from the desired position. path.transition(t) .tween("data", d => { const i = d3.interpolate(d.current, d.target); return t => d.current = i(t); }) .filter(function(d) { return +this.getAttribute("fill-opacity") || arcVisible(d.target); }) .attr("fill-opacity", d => arcVisible(d.target) ? (d.children ? 0.6 : 0.4) : 0) .attr("pointer-events", d => arcVisible(d.target) ? "auto" : "none") .attrTween("d", d => () => arc(d.current)); label.filter(function(d) { return +this.getAttribute("fill-opacity") || labelVisible(d.target); }).transition(t) .attr("fill-opacity", d => +labelVisible(d.target)) .attrTween("transform", d => () => labelTransform(d.current)); } function arcVisible(d) { return d.y1 <= 3 && d.y0 >= 1 && d.x1 > d.x0; } function labelVisible(d) { return d.y1 <= 3 && d.y0 >= 1 && (d.y1 - d.y0) * (d.x1 - d.x0) > 0.03; } function labelTransform(d) { const x = (d.x0 + d.x1) / 2 * 180 / Math.PI; const y = (d.y0 + d.y1) / 2 * radius; return `rotate(${x - 90}) translate(${y},0) rotate(${x < 180 ? 0 : 180})`; } return svg.node(); }33:[{"id":"fb39ed6e86eb1f243083b3441e3422902f61a4fd0d082e23168283e77502e728a562624ad2e2781f1b8e18962184346eeeb3bb75bde5790b1af3c4b28edcae56","href":"https://static.observableusercontent.com/files/fb39ed6e86eb1f243083b3441e3422902f61a4fd0d082e23168283e77502e728a562624ad2e2781f1b8e18962184346eeeb3bb75bde5790b1af3c4b28edcae56","name":"Radar@5.csv","type":"text/csv","lastModified":1699012864849.223,"size":6281174},{"id":"4c0f9ce10ac37b1aaaf4c8f12098cd24079561f784f919813b968b7501ed75658369a8cdce3e3606a74ac59aab24b061a9e7c4b7c7606551730781a2251618df","href":"https://static.observableusercontent.com/files/4c0f9ce10ac37b1aaaf4c8f12098cd24079561f784f919813b968b7501ed75658369a8cdce3e3606a74ac59aab24b061a9e7c4b7c7606551730781a2251618df","name":"Top50@2.csv","type":"text/csv","lastModified":1699012898811.608,"size":47019498},{"id":"70aa34c99268ca47009bcff13cfb122c9a74d78cd1326e0166d3cbb22bc1a119a470c22d2dad95df734b7ffee031cb169ae4539eb892c6ef0e1735a6f80da607","href":"https://static.observableusercontent.com/files/70aa34c99268ca47009bcff13cfb122c9a74d78cd1326e0166d3cbb22bc1a119a470c22d2dad95df734b7ffee031cb169ae4539eb892c6ef0e1735a6f80da607","name":"Test.csv","type":"text/csv","lastModified":1698820549879.302,"size":40534016},{"id":"0b3670c8ee729989dec8acc51528ba593f1b7eaf5d74a710162f1eeb5267eb06dfc1fb7e6eca58a322d3b6a5f47a0b9794a5469e773dece0d0780539ed1a31c0","href":"https://static.observableusercontent.com/files/0b3670c8ee729989dec8acc51528ba593f1b7eaf5d74a710162f1eeb5267eb06dfc1fb7e6eca58a322d3b6a5f47a0b9794a5469e773dece0d0780539ed1a31c0","name":"Buyers table.csv","type":"text/csv","lastModified":1698820549879.302,"size":3041977},{"id":"30036c356479fbbb0cde4e3e39e3a5d2a415b955f6dfd730e1066e3768236a580e6f66a3f3ac5cae13f1ef1ad0ae15e1dcb138fa971d69655432dec71e7f63fd","href":"https://static.observableusercontent.com/files/30036c356479fbbb0cde4e3e39e3a5d2a415b955f6dfd730e1066e3768236a580e6f66a3f3ac5cae13f1ef1ad0ae15e1dcb138fa971d69655432dec71e7f63fd","name":"sunburst.csv","type":"text/csv","lastModified":1698909319028.243,"size":3039194}] 2d:{"title":"","cells":[{"id":277,"value":"viewof filterValue = Inputs.select(details.map(item=>item.masterID).filter((value, index, self) => self.indexOf(value) === index), {label: \"Master ID\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":99,"value":"viewof selectedCountry = Inputs.select(Countries.map(x=>x.Country), {label: \"Country\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":465,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":119,"value":"header1=htl.html`

Target Industries

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"horiPlot=Plot.plot({\n marginLeft:320,\n width:600,\n marginTop:8,\n x: {\n axis: null,\n percent: true,\n label:null \n },\n y : {\n label:null \n },\n marks: [\n Plot.areaX({tickSize:0}),\n Plot.barX(TargetIndustries, \n {x: \"NoOfCompanies\", \n y: \"IndustryLevel3\", \n sort: {y: \"x\", reverse: true},\n fill:\"#027148\",\n insetTop:2\n }\n )]\n})\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":606,"value":"\n","pinned":false,"hidden":false,"mode":"html"},{"id":255,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"activeBuyers = Inputs.table(buyersTable, {\n columns: [\n \"Id\",\n \"Buyers Name\",\n \"# Deals Matching Criteria\",\n \"# Deals\",\n \"Buyer Country\",\n \"Buyer Simple Industry (Level 3)\",\n \"Buyer Type\",\n \"Sectors of Interest\"\n ],\n header: {\n \"Id\":\"Index\",\n \"Buyers Name\":\"Buyers Name\",\n \"# Deals Matching Criteria\":\"# Deals Matching Criteria\",\n \"# Deals\": \"# Deals\",\n \"Buyer Country\": \"Buyer Country\",\n \"Buyer Simple Industry (Level 3)\": \"Buyer Simple Industry (Level 3)\",\n \"Buyer Type\": \"uyer Type\",\n \"Sectors of Interest\":\"Sectors of Interest\"\n },\n Pagination:true\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":452,"value":"html`css `","pinned":false,"hidden":false,"mode":"ojs"},{"id":31,"value":"test = await FileAttachment(\"Test.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":667,"value":"MedianRevenue[0][\"Median Revenue\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":447,"value":"bootstrap = require('bootstrap@4.4.1')","pinned":false,"hidden":false,"mode":"ojs"},{"id":638,"value":"SELECT avg(CAST(REPLACE(REPLACE(case when \"financial Total Revenues\" = '' then 0 else REPLACE(\"financial Total Revenues\", '$', '') end, 'M', ''),',','') as int)) as \"Median Revenue\" from test where \"Revenue group\"= 'nonnull revenue'","pinned":false,"hidden":false,"mode":"sql","output":"MedianRevenue","database":"var:test"},{"id":655,"value":"SELECT avg(CAST(REPLACE(REPLACE(case when \"core Employee size\" = 'NaN' then 0 else REPLACE(\"core Employee size\", '$', '') end, 'M', ''),',','') as int)) as \"Median Employee Size\" from test where \"employee size group\"= 'nonnull employee size'","pinned":false,"hidden":false,"mode":"sql","output":"MedianEmployeeSize","database":"var:test"},{"id":682,"value":"select distinct \"core Employee size\" from test where \"core Employee size\" = 'NaN'","pinned":false,"hidden":false,"mode":"sql","output":"","database":"var:test"},{"id":102,"value":"select 'All' as Country \n UNION\nselect distinct Country from test","pinned":false,"hidden":false,"mode":"sql","output":"Countries","database":"var:test"},{"id":692,"value":"import {set} from \"@observablehq/synchronized-inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":690,"value":"function Table(data, keys = Object.keys(data[0])) {\n const onclick = (e, row) => {\n for (const row of node.querySelectorAll(\"tbody tr\")) row.style.background = \"none\";\n e.currentTarget.style.background = \"#eee\";\n set(node, row);\n };\n const node = htl.html`

\n \n \n \n ${keys.map(key => htl.html``)}\n \n \n \n ${data.map(row => htl.html` onclick(e, row)}>\n ${keys.map(key => htl.html``)}\n `)}\n \n

\n ${key}\n
\n ${row[key]}\n

`;\n set(node, null);\n return node;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"d3.select(horiPlot).selectAll(\"svg > g > text\").attr(\"style\",\"font-size:12px;font-weight:bold\");","pinned":false,"hidden":false,"mode":"ojs"},{"id":9,"value":"data1 = FileAttachment(\"Test.csv\").csv({typed:true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":188,"value":"data = selectedCountry ==\"All\" ? data1 : data1.filter(x=>x['Country']==selectedCountry)","pinned":false,"hidden":false,"mode":"ojs"},{"id":22,"value":"select distinct Count(TRIM(\"Company ID\")) as NoOfCompanies, TRIM(\"Simple Industry (Level 3)\") As IndustryLevel3 from data group by \"Simple Industry (Level 3)\" Order by Count(TRIM(\"Company ID\")) desc","pinned":false,"hidden":false,"mode":"sql","output":"TargetIndustries","database":"var:data"},{"id":26,"value":"select Count(\"Company ID\") as TotalCompanies from data","pinned":false,"hidden":false,"mode":"sql","output":"TotalCompanies","database":"var:data"},{"id":36,"value":"library = import(\"https://cdn.observableusercontent.com/npm/apache-arrow@11.0.0/+esm\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":55,"value":"buyersTable1 = await FileAttachment(\"Buyers table.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":38,"value":"select ROW_NUMBER() OVER (ORDER BY \"Buyer Country\") AS Id, * FROM buyersTable1","pinned":false,"hidden":false,"mode":"sql","output":"buyersTable","database":"var:buyersTable1"},{"id":41,"value":"select 'Buyers Name', '# Deals Matching Criteria', '# Deals', 'Buyer Country', 'Buyer Simple Industry (Level 3)', 'Buyer Type', 'Sectors of Interest' FROM buyersTable1","pinned":false,"hidden":false,"mode":"sql","output":"Buyers","database":"var:buyersTable1"},{"id":48,"value":"import {table} from \"@tmcw/tables@513\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":72,"value":"import { jQuery as $ } from \"@ddspog/useful-libs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":178,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":83,"value":"top50 = await FileAttachment(\"Top50@2.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":85,"value":"data50csv = FileAttachment(\"Top50@2.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":299,"value":"select concat(concat(CAST(\"Company ID\" AS INT), '-'), \"Company Name\") AS \"Company Name\",* from data50csv","pinned":false,"hidden":false,"mode":"sql","output":"data50","database":"var:data50csv"},{"id":203,"value":"Target50 = selectedCountry ==\"All\"? data50 : data50.filter(x=>x['Country'] == selectedCountry)","pinned":false,"hidden":false,"mode":"ojs"},{"id":867,"value":"mutable companyfilter= '0'","pinned":true,"hidden":false,"mode":"ojs"},{"id":804,"value":"viewof top50target=Inputs.table(data50, {\n columns: [\n \"Company Name\",\n \"Founded Year\",\n \"Country\",\n \"State/Province\",\n \"Simple Industry (Level 3)\",\n \"Company Type (Private/Public)\",\n \"Ultimate Parent Company\",\n \"core Company description\"\n ],\n header: {\n \"Company Name\": \"Company Name\",\n \"Founded Year\": \"Founded Year\",\n \"Country\": \"Country\",\n \"State/Province\": \"State/Province\",\n \"Simple Industry (Level 3)\":\"Simple Industry (Level 3)\",\n \"Company Type (Private/Public)\":\"Company Type (Private/Public)\",\n \"Ultimate Parent Company\":\"Ultimate Parent Company\",\n \"Description\":\"Description\",\n },\n format:{\n \"Company Name\" :x=>htl.html`

mutable companyfilter=x.split('-')[0]}>${x.split('-')[1]}

`,\n \"core Company description\":x=>htl.html`

${x}

View Description`\n }\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":237,"value":"selectedCompany = new Array(1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":208,"value":"{\n$(document).ready(function() {\n $(\".viewMore\").mouseover(function(){\n $(\".hover-box\").show();\n});\n $(\".viewMore\").mouseleave(function(){\n $(\".hover-box\").hide();\n});\n $(\".hover-box\").change(function() {\n $(\".hover-box\").width(\"auto\");\n})\n $(\".c-name\").on('click',function (){\n this.selectedCompany.pop();\n this.selectedCompany.push(parseInt($(this).attr(\"val\")));\n })\n})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":259,"value":"radarfile = await FileAttachment(\"Radar@5.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":260,"value":"radar = FileAttachment(\"Radar@5.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":262,"value":"details=radar.map(item=>({name:\"Measure 1\",key:item[\"Feature Name - x1-x2\"], value1:item[\"Shap Value - Y1\"],masterID:item[\"Master Id\"], value2:item[\"Feature Value-y2\"]}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":266,"value":"filteredList= details.map(item=>({name:\"Measure 1\",key:item[\"key\"], value:item[\"value1\"],masterID:item[\"masterID\"]})).filter(item=>item.masterID== parseInt(companyfilter))","pinned":false,"hidden":false,"mode":"ojs"},{"id":268,"value":"filteredList2= details.map(item=>({name:\"Measure 2\",key:item[\"key\"], value:item[\"value2\"],masterID:item[\"masterID\"]})).filter(item=>item.masterID== parseInt(companyfilter))","pinned":false,"hidden":false,"mode":"ojs"},{"id":272,"value":"Array.prototype.push.apply(filteredList,filteredList2)","pinned":false,"hidden":false,"mode":"ojs"},{"id":274,"value":"longitude = d3.scalePoint(new Set(Plot.valueof(filteredList, \"key\")), [180, -180]).padding(0.5).align(1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":569,"value":"import {Sunburst} from \"@d3/sunburst-component\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":532,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":548,"value":"sunburst = await FileAttachment(\"sunburst.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":945,"value":"select avg(CAST(REPLACE(REPLACE(case when \"Disclosed Deal Value\" = '' then 0 else REPLACE(\"Disclosed Deal Value\", '$', '') end, 'M', ''),',','') as double)) as 'Deal Disclosed Value', \"CTRL - Buyer/target Continent\", \"Buyer Simple Industry (Level 3)\", \"Deal ID\" from sunburst where \"Buyer Simple Industry (Level 3)\" <>'' group by \"CTRL - Buyer/target Continent\", \"Buyer Simple Industry (Level 3)\", \"Deal ID\" order by \"CTRL - Buyer/target Continent\" asc","pinned":true,"hidden":false,"mode":"sql","output":"Datatemp","database":"sunburst.csv"},{"id":957,"value":"listofContinent=Datatemp.map(x=>x['CTRL - Buyer/target Continent']).filter((item, i, ar) => ar.indexOf(item) === i).map(x=>({'name':x}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":963,"value":"level1 =listofContinent.map(x=> ({'name':x['name'], 'children':Datatemp.filter(y=>y['CTRL - Buyer/target Continent']==x['name'])}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":967,"value":"level2 =level1.map(x=> ({'name':x['name'],'children':x['children'].map(y=>({'name':y['Buyer Simple Industry (Level 3)'], 'value':y['Deal Disclosed Value']}))}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":549,"value":"select (sum(case when \"Regex Count -Buyer Only\" = 'NaN' then 0 else \"Regex Count -Buyer Only\" end)/sum(\"Number of Records\")) as \"P(B) (Buyer only)\", \"Buyer Simple Industry (Level 3)\" from sunburst group by \"Buyer Simple Industry (Level 3)\" having \"Buyer Simple Industry (Level 3)\" <> ''","pinned":false,"hidden":false,"mode":"sql","output":"pbbuyersonly","database":"var:sunburst"},{"id":555,"value":"select avg(case when \"P(AnB)/P(A) (Buyer Only)\" = 'NaN' then 0 else \"P(AnB)/P(A) (Buyer Only)\" end) AS \"P(AnB)/P(A) (Buyer Only)\", \"Buyer Simple Industry (Level 3)\" from sunburst group by \"Buyer Simple Industry (Level 3)\" having \"Buyer Simple Industry (Level 3)\" <> ''","pinned":false,"hidden":false,"mode":"sql","output":"regexbuyersonly","database":"var:sunburst"},{"id":563,"value":"SELECT avg(CAST(REPLACE(REPLACE(case when \"Disclosed Deal Value\" = '' then 0 else REPLACE(\"Disclosed Deal Value\", '$', '') end, 'M', ''),',','') as double)) as \"Deal Disclosed Value\", \"Deal ID\", \"Buyer Simple Industry (Level 3)\" from sunburst GROUP BY \"Deal ID\", \"Disclosed deal value Group\", \"Disclosed Deal Value\", \"Buyer Simple Industry (Level 3)\" HAVING \"Disclosed deal value Group\" = 'deal value' AND \"Buyer Simple Industry (Level 3)\" <> '' order by \"Buyer Simple Industry (Level 3)\" asc","pinned":false,"hidden":false,"mode":"sql","output":"DealDisclosedValue","database":"var:sunburst"},{"id":969,"value":"finalData = ({'name':'Core', 'children':level2})","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}