List total values from Schedules in Revit

[daotangluc]

Hi everyone,

I’m a freshman in Dynamo. I need your help to reduce my freshness :).

I’m in trouble with Schedule in Revit. I have a lot of schedules to calculate the value of: Site Coverage, Garden Area, Site Permeability with both in Area and Percentage.

Now I want to create a list of that total calculate Parameters, somethings like below:

SITE AREA_____________: X m2 (Get from Project Parameter on Area + Project Information)
SITE COVERAGE_______: X1 m2_________Y1% (Total value from Site coverage Schedule)
SITE PERMEABILITY____: X2 m2_________Y2% (Total value from Site Permeability Schedule)
GARDEN AREA________: X3 m2_________Y3% (Total value from Garden Area Schedule)

Could you please show me the right way to do?

Many thanks,

[salvatoredragotta]

Hi @daotangluc ,

Welcome to the forum

How to get help on the Dynamo forums

Here are some more additions. First, do not ask anyone to do your job! This is a help forum to ask for help with things that you cannot figure out on your own, but actually tried. Most important, please remember always come back if anyone is trying to help you. If your graph provides you an error messages, please reveal the content of it as a part of the image. Please put ‘Watch’ nodes and notes in the graph describing what essential parts does. The notes will help you to remember what you did…

[daotangluc]

Thanks for your guidelines. I’m working on that. Still struggle but have some small steps.

[daotangluc]

I started to create on Dynamo like the image.
I can export the value from Site Area (Project Parameter) to Excel file
but how could I get the total value of other Calculate Parameter (Site Coverage, Site Permeability, Garden Area)

Thanks in advance,

[salvatoredragotta]

@daotangluc You can create a list of all parameters like this:

Set lacing to longest

[daotangluc]

Thank you so much,

I discover another issue, SITE AREA is Project Information, but the others are Areas

So I change the codes, but the new issue is how could I get the total value of one Calculate Parameter?

[salvatoredragotta]

@daotangluc

This could help ?

Can Dynamo pull data from a calculate value parameter?

Bill, Here is how i was able to achieve what your looking for. Try using the “code block” node, i always seem to have better results. For some reason it extracted an extra value blank so i had to remove it from the list. The best way i know to add all values of a list together is used Lunchbox tool “Mass Addition” for this you have to convert your area to a Number via String then back to number. Let me know if you find an easier workflow Thanks, William [2015-01-16_18-45-12]

[daotangluc]

@salvatoredragotta
Thank you so much.
Now, I can get the value from schedule, but I can’t summarize the value with SUM
Which is my mistake?

[salvatoredragotta]

@daotangluc

Use a Object.Type node and check your data. Math.Sum can just add integers/doubles

[daotangluc]

I check, but the object type is null.

What happened with the values?

Thanks,

[salvatoredragotta]

@daotangluc

[daotangluc]

@salvatoredragotta: thanks for your help,

So I succeeded to export to excel as image.

But now, how could I import that excel to drafting view/Legend?

Or could I put the values to Text parameter and show in another schedule?

[salvatoredragotta]

@daotangluc Glad you to hear!. Please mark this topic as solved and start a new topic for your new issue.