Augmenting Space Planning Graph with a Mandrill Donut Chart

[daniel.tran]

Hello,

I’m trying to augment the Kyle Martin + Shepley + Bulfinch Space Planning Graph

Space Planning with Dynamo by Kyle Martin-Shepley Bulfinch

Hi Kyle, I have replicated your Space Planning Dynamo routine, but it is not working. I get an error in the first two nodes that regroup the “Width and Length values by Department.” This generates other null values. I have created a Mass family and materials specific for this routine. I have only added two rooms to my Excel file to test it. Could you please give me a hand with it? Kind regards, Mr. Haley Bueno. [Space Planing Excel 10-03-16]

with a corresponding Mandrill Donut Chart that would use the same Space Planning Excel spreadsheet as its inputs. Having a Donut Chart HUD that would update as programmatic blocks were adjusted in a Revit Space Planning exercise would be a great dashboard tool.

This is what I have so far:
Revit project file - This Revit file has materials specified that correlate to the Excel sheet and Dynamo Graph. It also hosts the Revit Mass Family.
Excel sheet - per the Mandrill primer, must the linked excel file be a CSV with only 2 columns or can it integrate with the excel file formatted for the Shepley + Bulfinch Space Planning Graph
Space Planning_sample program.xlsx (22.6 KB)

Revit Mass Family
MSS-Program-SpaceType-Box-UH_2019.02.28.rfa (392 KB)

Dynamo Graph
space planning_mandrill_2019.03.05.dyn (834.1 KB)