I found it to be a very complete summary of the possibilities of schedules in Revit. Usually I export the tables with TAB as a separator, open a new excel file and from the Data tab I use the get text/CSV data function. This allows you to create a data table directly and edit it from power query.
I use schedules on regular basis but I’ve never tried key schedules as I didn’t know what they they where for. Looks pretty powerful. I mainly use schedules for pile foundation plans, the ability to have them count and sort is pretty handy. About a year ago I discovered that it’s possible to embed type images in certain families which is really handy in the context of a pile schedule. The only thing I’m kind of missing is the ability to automatically set mark fields or to renumber them. I always have to do this by hand.
Yes key schedules have a lot of amazing use cases, especially once they allowed them to drive shared parameters in Revit 2022. Type images are a great feature as well, I use them sometimes for various purposes - can technically achieve an ArchiCAD-esque door schedule using them also. Autonumber/mark certainly sounds like a potential automation opportunity!
Excellent video! one thing i´ve found usefull is to have two schedules of the same topc, one with the final formatting and the other as the work in progress
Thank you for this video; it was quite helpful. I was wondering if you could share some of your templates with us, like the template you use for the schedules and your Architectural template.
@@nasimkhosravi5292 my broader system is a product i sell via my course platform. There are a few free sample models on the platform also (including the one I use in many of my videos): courses.bimguru.education/
This is good timing, i working on button that auto create some schedules and here I have nice ideas. It is shame that grand total can't be base on size. for pipes grand total lose point If we sum it up DN 15 and DN 100
Hello Aussie Bim guru! Love your videos. Are you able to create a space planning from excel room programme video for us? You are the most comprehensive dynamoer out there, and I really wish I could follow your logic and build up of it in a video.
Unfortunately this is a very complex workflow to put together for TH-cam. I develop scrips at work in this space and they take weeks to prepare, but I'd recommend looking into dynaspace as a starting point if you need to do it in Dynamo. I generally use Grasshopper, Kangaroo physics engine a lot of python code to undertake space logic routines. The hard part with space logic is unless all your buildings are very similar you will be writing algorithms each time for new projects, or the results might be quite abstract (e.g. bubble diagrams). It may be worth exploring proprietary tools on the market first before diving in as it's a difficult topic.
Thanks a lot for your video, learning a lot from all of them. There is one thing that i would like to ask about: is there any tricks that able to push the Elevation parameter from Level Schedule into Area Schedule? Did you try it before?
Unfortunately elevation is a property of the level which is unavailable in area schedules beyond the Level parameter that the area has. An app like Dynamo or an addin could set this data to a custom parameter but it would be out of date between runs.
@@AussieBIMGuru Thanks a million on your reply. I have been researching a bit on this issue but seems like impossible to push the data without dynamo. I watched and learned quite a lot from your videos, thanks again.
You didn't get a prompt when opening .txt in excel since it was already converted by drag & drop method. You needed to close excel completely and then do File/Open. But great video on schedules, I haven't used option to schedule link and certainly wouldn't guess that both models need to have same shared param.
hi i really love that most of your videos are more than basics level and kinda advanced level. i want to ask you about if you know a way to be able to have a schedule adding the room number parameter to it. yes i saw how you add the parameter and i did as well but my problem is what if the rooms are from a link (like for example architect link) and my schedule is for electrical fixtures or mechanical equipments that exist in my model (mep model) which dont have rooms. is there a way to schedule by room without adding the rooms to my mep model ? (extra question xD - i tried also making schedules to system families like cable tray or ducts but the Room field of parameters dont even show. i think its somehow limit the system families from being in the room since they are not point based families to be existed as i fixture in the room where the start could be inside the room and the end could be outside. but it still would be a nice thing if we can achieve to get the schedule that would calculate the total length of cable tray only in that room. i wonder if you have any idea how to do it )
Unfortunately linked rooms dont support native room report and as you guessed some elements do not naturally report to rooms. The next nearest workaround is to utilize dynamo and the revit API to ask which room is at a point. You would need to get what that point is relative to the element so for a wall for example you would need to decide if that is its midpoint, although it might be between 2 rooms so not really in one. Youd need to account for a lot of cases potentially. This is the API method which can interrogate linked models also: www.revitapidocs.com/2017/7dbcac93-ec82-5f60-4a54-a427f3e1cc1e.htm
how to add parameter to floor family for calculating shuttering area in schedule and its cost? Beam bottom shuttering is having different rate per sqm than slab shuttering.
Well done! Q U E S T I O N: Do you know how to take a Graphic Scale family and have it "married" to the "View Scale" of a plan View? i'd like to have a Graphic Scale on all plan views and have the Graphic scale change to the proper graphic scale if i change the View Scale of a plan view. (ie. 1/8"=1'-0" < 3/16"='-0"). Any help would be awesome! And, i know many others would benefit from knowing how to get that done. :) LET'S SEE A VIDEO ON THAT PLEASE. :)
Unfortunately the view scale parameter cannot be accessed by families. The closest approach is to use dynamo or addins to check for the view scales on sheets and then set parameter values of scale bar/key plans to suit. I have a video using this type of technique here: th-cam.com/video/Gl-qA2RufXA/w-d-xo.htmlfeature=shared
@9:27 don't use shortcuts! You just change the title of the row. (Which you can see happens) Dot ask me how many schedules I've published with a shortcut in the title. (I don't know, but that's because it happens without realising)
@@AussieBIMGuru Yes Revit is sneaky sometimes. I have a topic that might be interesting for at least 5 of your followers. I'm an MEP engineer, AMD use spaces based on the Architects Rooms. But once they start working and move rooms around and *gasp* delete some of them, my carefully added data disappears. Besides me making all my spaces manually, are there any workarounds, for me or the architect?
@mariepindstruplinde1671 certainly are, I'll add it to my list. The main one is to ensure you use a piece of data common to the room (e.g. a number), then you can generate spaces from them, and separators from their boundaries. Tracking boundaries is a bit harder and would involve storing their id lists to the space itself (as they cant hold data of their own), but ill look into it... The script would then run through the steps below: 1. Make new spaces (using space/room numbers to check/get spaces) 2. If on same level, just move them 3. Pass data to them 4. Unplace (delete) those not placed. Report those not unplaced by architect 5. Delete all space separators 6. Recreate new space separators, store their ids as a list to their space The catch would be that spaces are 100% automated and not edited by anyone manually from there aside from data not being pushed over. It would work off a linked model.
Hey buddy, you really doing great job and your contents are very nice. But the problem is your speaking tone is not clear, I request you please change your mic or tone. You will get more subscribers. Thanks!
Yes ive struggled to find a good mic unfortunately. Some people say subtitles helps them on the less clear vids but i appreciate thats not fun to deal with for viewers. Thanks for the tip, noted. Im about to go on a break for a while so will see if I can sort it out...
Nice video showing some of the power of schedules!
Once you start harness this power, you will become the BIM Guru of your office.
Thanks, and that you will!
I found it to be a very complete summary of the possibilities of schedules in Revit.
Usually I export the tables with TAB as a separator, open a new excel file and from the Data tab I use the get text/CSV data function. This allows you to create a data table directly and edit it from power query.
Yes tabs make for great delimiters i find, far more reliable than commas!
I use schedules on regular basis but I’ve never tried key schedules as I didn’t know what they they where for. Looks pretty powerful. I mainly use schedules for pile foundation plans, the ability to have them count and sort is pretty handy. About a year ago I discovered that it’s possible to embed type images in certain families which is really handy in the context of a pile schedule. The only thing I’m kind of missing is the ability to automatically set mark fields or to renumber them. I always have to do this by hand.
Yes key schedules have a lot of amazing use cases, especially once they allowed them to drive shared parameters in Revit 2022. Type images are a great feature as well, I use them sometimes for various purposes - can technically achieve an ArchiCAD-esque door schedule using them also.
Autonumber/mark certainly sounds like a potential automation opportunity!
Excellent video! one thing i´ve found usefull is to have two schedules of the same topc, one with the final formatting and the other as the work in progress
Yes great tip! Helps avoid losing all the hard work of formatting documentation schedules.
What an amazing video. You covered a lot of methods✅
Glad you think so!
Thank you for this video; it was quite helpful.
I was wondering if you could share some of your templates with us, like the template you use for the schedules and your Architectural template.
@@nasimkhosravi5292 my broader system is a product i sell via my course platform.
There are a few free sample models on the platform also (including the one I use in many of my videos):
courses.bimguru.education/
This is good timing, i working on button that auto create some schedules and here I have nice ideas.
It is shame that grand total can't be base on size.
for pipes grand total lose point If we sum it up DN 15 and DN 100
Sounds fun! Yes grand total cannot although you can do header by type and sub-total by type/size I guess.
Thank you for the helpful tutorial. Could you please create a advance level tutorial on parameters?
Yep I have one here:
th-cam.com/video/ORUJqpIGkIU/w-d-xo.htmlfeature=shared
Hello Aussie Bim guru!
Love your videos.
Are you able to create a space planning from excel room programme video for us?
You are the most comprehensive dynamoer out there, and I really wish I could follow your logic and build up of it in a video.
Unfortunately this is a very complex workflow to put together for TH-cam. I develop scrips at work in this space and they take weeks to prepare, but I'd recommend looking into dynaspace as a starting point if you need to do it in Dynamo. I generally use Grasshopper, Kangaroo physics engine a lot of python code to undertake space logic routines.
The hard part with space logic is unless all your buildings are very similar you will be writing algorithms each time for new projects, or the results might be quite abstract (e.g. bubble diagrams). It may be worth exploring proprietary tools on the market first before diving in as it's a difficult topic.
Great tips in there mate. Nice to see your BimGuru template flexing its muscles as well!
Cheers, always nice to bring it out when it doesn't limit the video reproducibility for others.
Thanks a lot for your video, learning a lot from all of them. There is one thing that i would like to ask about: is there any tricks that able to push the Elevation parameter from Level Schedule into Area Schedule? Did you try it before?
Unfortunately elevation is a property of the level which is unavailable in area schedules beyond the Level parameter that the area has. An app like Dynamo or an addin could set this data to a custom parameter but it would be out of date between runs.
@@AussieBIMGuru Thanks a million on your reply. I have been researching a bit on this issue but seems like impossible to push the data without dynamo. I watched and learned quite a lot from your videos, thanks again.
You didn't get a prompt when opening .txt in excel since it was already converted by drag & drop method. You needed to close excel completely and then do File/Open.
But great video on schedules, I haven't used option to schedule link and certainly wouldn't guess that both models need to have same shared param.
Ah yes it does seem to store that behaviour in session... good catch!
Informative video
Thanks!
very helpful
Glad to hear!
hi
i really love that most of your videos are more than basics level and kinda advanced level. i want to ask you about if you know a way to be able to have a schedule adding the room number parameter to it. yes i saw how you add the parameter and i did as well but my problem is what if the rooms are from a link (like for example architect link) and my schedule is for electrical fixtures or mechanical equipments that exist in my model (mep model) which dont have rooms. is there a way to schedule by room without adding the rooms to my mep model ?
(extra question xD - i tried also making schedules to system families like cable tray or ducts but the Room field of parameters dont even show. i think its somehow limit the system families from being in the room since they are not point based families to be existed as i fixture in the room where the start could be inside the room and the end could be outside. but it still would be a nice thing if we can achieve to get the schedule that would calculate the total length of cable tray only in that room. i wonder if you have any idea how to do it )
Unfortunately linked rooms dont support native room report and as you guessed some elements do not naturally report to rooms.
The next nearest workaround is to utilize dynamo and the revit API to ask which room is at a point. You would need to get what that point is relative to the element so for a wall for example you would need to decide if that is its midpoint, although it might be between 2 rooms so not really in one. Youd need to account for a lot of cases potentially.
This is the API method which can interrogate linked models also:
www.revitapidocs.com/2017/7dbcac93-ec82-5f60-4a54-a427f3e1cc1e.htm
@@AussieBIMGuru thanks
Can't wait to steal most of this ideas :D
Haha it isnt really stealing if i put it out there in public!
❤
:)
how to add parameter to floor family for calculating shuttering area in schedule and its cost? Beam bottom shuttering is having different rate per sqm than slab shuttering.
I would recommend adding a project parameter to the intended categories at a type level.
Hello, is it possible to add a .dyn file to the tab that my personally created in the Revit like a Bimlize program?
Yes generally either pyrevit, nonica or relay addin can add scritlpts to ribbon buttons and panels.
@@AussieBIMGuru Thank you for your answer
Well done! Q U E S T I O N: Do you know how to take a Graphic Scale family and have it "married" to the "View Scale" of a plan View? i'd like to have a Graphic Scale on all plan views and have the Graphic scale change to the proper graphic scale if i change the View Scale of a plan view. (ie. 1/8"=1'-0" < 3/16"='-0"). Any help would be awesome! And, i know many others would benefit from knowing how to get that done. :) LET'S SEE A VIDEO ON THAT PLEASE. :)
Unfortunately the view scale parameter cannot be accessed by families. The closest approach is to use dynamo or addins to check for the view scales on sheets and then set parameter values of scale bar/key plans to suit.
I have a video using this type of technique here:
th-cam.com/video/Gl-qA2RufXA/w-d-xo.htmlfeature=shared
@9:27 don't use shortcuts! You just change the title of the row. (Which you can see happens)
Dot ask me how many schedules I've published with a shortcut in the title. (I don't know, but that's because it happens without realising)
Haha yep whoops good catch! Sneaky Revit...
@@AussieBIMGuru Yes Revit is sneaky sometimes.
I have a topic that might be interesting for at least 5 of your followers.
I'm an MEP engineer, AMD use spaces based on the Architects Rooms. But once they start working and move rooms around and *gasp* delete some of them, my carefully added data disappears.
Besides me making all my spaces manually, are there any workarounds, for me or the architect?
@mariepindstruplinde1671 certainly are, I'll add it to my list. The main one is to ensure you use a piece of data common to the room (e.g. a number), then you can generate spaces from them, and separators from their boundaries. Tracking boundaries is a bit harder and would involve storing their id lists to the space itself (as they cant hold data of their own), but ill look into it...
The script would then run through the steps below:
1. Make new spaces (using space/room numbers to check/get spaces)
2. If on same level, just move them
3. Pass data to them
4. Unplace (delete) those not placed. Report those not unplaced by architect
5. Delete all space separators
6. Recreate new space separators, store their ids as a list to their space
The catch would be that spaces are 100% automated and not edited by anyone manually from there aside from data not being pushed over. It would work off a linked model.
@@AussieBIMGuru Now that got you started... As always, are the best for bringing the solutions ! Great video and thanks for the insight !
Hey buddy, you really doing great job and your contents are very nice. But the problem is your speaking tone is not clear, I request you please change your mic or tone. You will get more subscribers.
Thanks!
Yes ive struggled to find a good mic unfortunately. Some people say subtitles helps them on the less clear vids but i appreciate thats not fun to deal with for viewers.
Thanks for the tip, noted. Im about to go on a break for a while so will see if I can sort it out...