2b:null 2c:["$","title",null,{"children":"Day2 #30DayChartChallenge, Waffle chart. Aerial target losses | Roman Sverdan | Observable"}] 31:T5a1,function Grid( data, { columnLength = 20, squareSize = width / columnLength } = {} ) { const dataLength = data.length; const size = squareSize; const columns = columnLength !== null && columnLength > 1 ? columnLength : Math.round(width / size); const height = (dataLength / columns) * size; const svg = DOM.svg(width, height + size); const sel = d3.select(svg); const scaleColumn = d3 .scaleLinear() .domain([0, columns]) .range([0, columns * size]); const scaleRow = d3 .scaleLinear() .domain([0, data.length / columns]) .range([0, height]); const group = sel .selectAll("g") .data(data) .enter() .append("g") .attr("transform", (d, i) => { const x = i % columns; const y = Math.floor(i / columns); return `translate(${scaleColumn(x)}, ${scaleRow(y)})`; }); group .append("rect") .attr("x", 0) .attr("y", 0) .attr("width", squareSize) .attr("height", squareSize) .attr("stroke-width", 0.2) .attr("stroke", "#333") .attr("fill", (d, i) => { return i >= 0 && i <= airTargetLosses.aircrafts.max ? fill.aircrafts : i > airTargetLosses.aircrafts.max && i <= airTargetLosses.helicopters.max ? fill.helicopters : i > airTargetLosses.helicopters.max && i <= airTargetLosses.uav.max ? fill.uav : fill.cruise_missiles; }); return svg; }32:[] 2f:{"id":"22453e62669c9a16","slug":"30daychartchallenge-day-2","title":"Day2 #30DayChartChallenge, Waffle chart. Aerial target losses","thumbnail":"0d0b7c5f90f6145df02a56693f90aaf23e9ec7ada951d90b843d8d856b6cafa6","access_level":"public","create_time":"$D2023-04-02T15:21:17.750Z","update_time":"$D2025-12-28T11:49:23.309Z","view_time":null,"first_public_time":"$D2023-04-02T15:21:17.750Z","fork":false,"stars":2,"starred":false,"owner":{"type":"team","id":"36db9f151dbeb3bc","login":"romansverdan","name":"Roman Sverdan","avatar_url":"https://avatars-next.observableusercontent.com/f10a4afffb8f95850eb88bda500106e7c81993daee3682132a6b9dde86884569","tier":"starter_2024"},"version":77,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"2c1ee78e30fade9b","login":"romansverdan","name":"Roman Sverdan","avatar_url":"https://avatars-next.observableusercontent.com/f10a4afffb8f95850eb88bda500106e7c81993daee3682132a6b9dde86884569","tier":null}],"members":[{"type":"individual","id":"2c1ee78e30fade9b","login":"romansverdan","name":"Roman Sverdan","avatar_url":"https://avatars-next.observableusercontent.com/f10a4afffb8f95850eb88bda500106e7c81993daee3682132a6b9dde86884569","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"6909a3a6854e8e08","slug":"30daychartchallenge-2023","title":"#30DayChartChallenge 2023","owner":{"id":"36db9f151dbeb3bc","login":"romansverdan","name":"Roman Sverdan"}},"type":"notebook","body":{"title":"Day2 #30DayChartChallenge, Waffle chart. Aerial target losses","cells":[{"id":0,"value":"# Day2 #30DayChartChallenge, Waffle chart. Aerial target losses","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":62,"value":"Total number of aerial equipment losses of the \"second army of the world\" during the full scale invasion of Ukraine, since Feb 24, 2022.\n\nOriginal data source @GeneralStaffUA.
\nCleaned and formatted CSV data is available at my Github repo here.

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":39,"value":"

\n Aircrafts
${airTargetLosses.aircrafts.total}\n

\n Helicopters
${airTargetLosses.helicopters.total}\n

\n Unmanned Aerial Vehicle
${airTargetLosses.uav.total}\n

\n Cruise Missiles
${airTargetLosses.cruise_missiles.total}\n

\n Total Lossed
${totalLosed}\n

\n Last data update:
${csvData[csvData.length-1].date.toISOString().slice(0, 10)}\n

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":35,"value":"Grid(d3.range(totalLosed), {\n columnLength: 150\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"$31","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":26,"value":"fill = ({\n aircrafts: \"#74add1\",\n helicopters: \"#abd9e9\",\n uav: \"#fee090\",\n cruise_missiles: \"#fdae61\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"columnLength = 20","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"parseDate = d3.utcParse(\"%Y-%m-%d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"csv = d3.csv(\n \"https://raw.githubusercontent.com/romansverdan/Russian-Losses-in-Ukraine/main/data/russia_losses.csv\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"csvData = {\n const columns = Object.keys(csv[0]);\n let daysCount = 0;\n let res = csv.map((d) => {\n const obj = {};\n columns.forEach((col, i) => {\n if (i === 0) {\n obj[col] = parseDate(d[col]);\n } else if (i === 1) {\n obj[col] = parseInt(d[col]);\n } else {\n if (daysCount === 0) {\n obj[col] = parseInt(d[col]);\n } else {\n obj[col] = parseInt(d[col]) - parseInt(csv[daysCount - 1][col]);\n }\n }\n });\n daysCount++;\n return obj;\n });\n return res;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"airTargetLosses = {\n const aircrafts = d3.sum(\n csvData.filter((el) => el[\"aircrafts\"] != 0),\n (el) => el.aircrafts\n );\n const helicopters = d3.sum(\n csvData.filter((el) => el[\"helicopters\"] != 0),\n (el) => el.helicopters\n );\n const uav = d3.sum(\n csvData.filter((el) => el[\"uav\"] != 0),\n (el) => el.uav\n );\n const cruise_missiles = d3.sum(\n csvData.filter((el) => el[\"cruise_missiles\"] != 0),\n (el) => el.cruise_missiles\n );\n return {\n aircrafts: { type: \"aircrafts\", total: aircrafts, min: 0, max: aircrafts },\n helicopters: {\n type: \"helicopters\",\n total: helicopters,\n min: aircrafts,\n max: aircrafts + helicopters\n },\n uav: {\n type: \"uav\",\n total: uav,\n min: aircrafts + helicopters,\n max: aircrafts + helicopters + uav\n },\n cruise_missiles: {\n type: \"cruise_missiles\",\n total: cruise_missiles,\n min: aircrafts + helicopters + uav,\n max: aircrafts + helicopters + uav + cruise_missiles\n }\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"totalLosed = {\n return d3.sum(Object.values(airTargetLosses), (el) => el.total);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"d3 = require(\"d3@7.8.0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 30:"$2f:body"