Right… That is the intention. One issue may arise, if there are more areas of same number what should happen… actually they should add in to single area for that floor.
See how this looks…
Thanks for the efforts. Basically this is in line of requirements, only thing is that the area types are getting repeated on the columns. They should align as per the area name.05-09.xlsx (10.2 KB)
I am hoping that you will help out on the last leg of this
Area Statement export to Excel-other aproach-MKA-3.dyn (80.7 KB)
Thanks at tone for this. For some reason it is showing “unresolved” in two nodes. Probably due to that the results are not showing.
Try installing the Orchid package…
Be aware that you need to install Orchid from GitHub… Instruction are in the one node in the package from the Package Manager oh… and both Dynamo and Revit need to be shut down when installing…
I installed Orchid package… but still getting this error.
Installed by following steps:
- Shut down dynamo and revit
- Downloaded the installation from this link https://raw.githubusercontent.com/erfajo/OrchidForDynamo/master/OrchidForDynamo.exe
which I believe is the latest version.
Then started revit and dynamo.
Have I missed anything?
Please read this…
I think you did what you are supposed to, perhaps a full PC restart is required, if not head to Erik’s github and raise a query…
If you can’t get it working we can look at a Python solution
You should drag the List.Replace node from the library and erase the List.Replace node contained in the graph.
The “unresolved” error is probably there because of 2 different versions of the Orchid package.
@Mark.Ackerley To some extent this is working, but not entirely. I am attaching excel, modified .dyn (those two nodes replaced) and screenshot showing the difference between schedule and excel. Thanks a lot for efforts.
No worries, fingers crossed with this one!
Area Statement export to Excel-other aproach-MKA-4.dyn (87.1 KB)
Yessssss… it works.
Only some tweaking is required.
- The floors where there is no area need not come in schedule.
- When there are multiple areas of same name… they are not adding up.
I feel really embarrassed that I am asking you too much to do. I would have loved to do some bit, but I am new so haven’t understood manipulating lists much.Thanks very Much.
(Shuts eyes) Area Statement export to Excel-other aproach-MKA-5.dyn (98.4 KB)
Thanks a lot. Here is the result:
Now I will go through this in detail and try to understand what magic you did.
No worries, let me know if you can’t work it out.
If you could click on the final one as the Solution, it helps others who want to replicate your schedule.
Ticking on solution done. Just one more question… can you tell me where I can read / view more about the highlighted thing… I think called levels, and maintain structure ?
1. We will start with a simple 3D grid of points. 2. Since the grid is constructed with a Range for X, Y and Z, we know that the data is structured with 3 tiers: an X List, Y List and Z List. 3. These tiers exist at different **Levels** . The Levels are indicated at the bottom of the Preview Bubble. The list Levels columns correspond to the list data above to help identify which level to work within. 4. The List Levels are organized in reverse order so that the lowest level data is always in “L1”. This will help ensure that your graphs will work as planned, even if anything is changed upstream.