Create Schedule like Excel

Mat.Syaf
Advocate
Advocate

Create Schedule like Excel

Mat.Syaf
Advocate
Advocate

Hi, I have a schedule that I were using it for every project in Excel. Now the company is moving to Revit. So is that a way to make the schedule in Revit same like in Excel. I have attached image of  Excel shcedule.

Basically,

  • SLA Total is the total area of selling department in the store (example: footware, menswear, womenwear, bedding etc).
  • Airlock - Office & Amen is Back of House area
  • NON SLA Total is the total of Airlock - Office & Amen
  • GLA-R is the total of SLA + NON SLA
  • GLA is the total area of the whole store

MatSyaf_0-1662710792454.png

 

0 Likes
Reply
Accepted solutions (2)
1,012 Views
10 Replies
Replies (10)

denisyukJ
Advocate
Advocate

Hello, @Mat.Syaf 

Revit doesn't give you such flexible opportunity to make a schedules. I guess you can standardize schedule format in Revit and formatting data according your needs with a macro in Excel.

MachielAEC
Advocate
Advocate

I would create that as a Generic Annotation family, you can create it as a calculator in the format you like and the - similar to excel - type the info produced from Revit.

https://citizenbim.notion.site/Generic-Annotations-7430b2b507d44cad82cfec9be7646043

Machiel Odendaal
---BIM Enthusiast---
0 Likes

lim.wendy
Community Manager
Community Manager

Hi Asyraf,


Thanks for reaching out to the forum. Have you had a chance to look over the suggestions provided by our experts?

Do you have any questions about it, let us know if you require further assistance.

If the suggestions helped you, please hit the "Accept Solution" button, as it helps make the solution easier to find for others who might have the same issue. Knowing which topics are solved or not can also help our many users find the questions that still need to be answered. It’s also a great way to say thank you and give recognition to whoever helped you. 

 



Wendy Lim

Data Nerd | Community Advocate | AEC Industry


facebook twitter twitter blogs pm


Join the new online Rail Community


Rails Summit




0 Likes

Mat.Syaf
Advocate
Advocate
I try to understand with this solution, but I still don't understand how he make all the area into 1 row.
https://forums.autodesk.com/t5/revit-architecture-forum/area-schedule-presentation/m-p/10427387#M325...
0 Likes

constantin.stroescu
Mentor
Mentor
Accepted solution

you can do it in Excel and then import into Revit...

have a look at my screencast:

 

Constantin Stroescu

EESignature

Mat.Syaf
Advocate
Advocate

@constantin.stroescu Thanks for the screencast. basically what you showed is you export the schedule from revit to excel, then import back to the revit right? My issue is to create the schedule from the revit itself. I need to create the area schedule but in the vertical way like the one in the excel. What I understand right now, Revit don't allow to make schedule vertically.

 

I've I manage to extract the area but the schedule will be in horizontal.

MatSyaf_0-1663122105954.png

 

MachielAEC
Advocate
Advocate
Accepted solution

Yes, Revit does schedules horizontally.

The way I do it is to have the normal schedule that provides me with info and then I input those values into a Generic Annotation that represents the 'excel look'.

machiel_0-1663161799579.png

 

Machiel Odendaal
---BIM Enthusiast---

Mat.Syaf
Advocate
Advocate

Interesting. How do you link paramaters in both schedule and generic annotation? For example, in the schedule, I have created a formula parameter which has formula that combine a few of parameter. How to import that parameter into the generic annotation?

0 Likes

MachielAEC
Advocate
Advocate

Currently it's a manual thing, I only need to type this once or twice per project so no need to automate it.

If I had to do Automate it, I would look at using Dynamo that will transfer information between the 2, however this becomes more complicated as the information per project might look different.

So currently, it's not dynamic at all or automated.

Machiel Odendaal
---BIM Enthusiast---

lim.wendy
Community Manager
Community Manager

Hi Asyraf,


Good day to you. It looks like our experts, Constantin and Machiel have provided you with an explanation on why Revit schedules horizontally and some workaround to transpose it. I am going to mark their response as "Possible Answers." This won't prevent other folks from commenting on this question though, in the event other ideas come up!

 

Remember to mark your posts as having an "Accepted Solution" if a solution is found as it helps other forum users with the same issue – so don't be shy about marking it as a solution! Accepted solutions get viewed more and help more users find the answer to their problems.

You could unmark the post as an accepted solution if the solution did not work. Click the ellipsis menu  > Not the Solution to cancel an accepted answer. 

 

 

 

 



Wendy Lim

Data Nerd | Community Advocate | AEC Industry


facebook twitter twitter blogs pm


Join the new online Rail Community


Rails Summit