Published
Edited
Sep 29, 2022
1 star
Insert cell
Insert cell
Insert cell
Insert cell
architects = FileAttachment("Table2bArchitects.xlsx").xlsx()
Insert cell
designers = FileAttachment("Table2eDesigners.xlsx").xlsx()
Insert cell
Insert cell
allRacesArchitects = architects.sheet("All-Races")
Insert cell
allRacesDesigners = designers.sheet("All-Races")
Insert cell
Insert cell
allRacesArchitects[3]
Insert cell
allRacesDesigners[3]
Insert cell
Insert cell
Insert cell
architectData = allRacesArchitects
.slice(6)
.filter((d) => d.A)
.map((s) => ({
state: s.A,
abbreviation: stateLabels.find((d) => d.name == s.A),
allWorkers: s.B,
creatorCount: s.C,
creatorPercentage: s.C / s.B,
creatorLabel: "Architect"
}))
Insert cell
designerData = allRacesDesigners
.slice(6)
.filter((d) => d.A)
.map((s) => ({
state: s.A,
abbreviation: stateLabels.find((d) => d.name == s.A),
allWorkers: s.B,
creatorCount: s.C,
creatorPercentage: s.C / s.B,
creatorLabel: "Designer"
}))
Insert cell
allCreatorData = architectData.concat(designerData)
Insert cell
Inputs.table(allCreatorData)
Insert cell
Insert cell
Insert cell
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more