For those of you who know Revit, you probably understand that this software sometimes acts like a child and doesn't behave just like we want to. So, like educating a child, we also need to learn to educate and manipulate Revit to acquire the results we expect from this Project Manager that has so much potential. Anyway, i hope you don't automatically assume the revit is bad… it's just an expression to control it better. The result is this blog i created like many other bloggers did on this theme. I think i'm just trying to leave my footprint in the growth of this solution that i believe it's the future of architecture software.

26 January 2010

a tip about windows schedule cost field

Welcome to my first blog and my first post!

I could start with any kind of tip or article about Revit Architecture... so i'll start with a simple question that a former student asked me today.

This is a tip for newbies... but very useful!

question:
in a window schedule, how can i have a cost per unit field and a total cost field? (assuming i'm not using the "itemize every instance" check box)

answer:

first step we have to create a window schedule. (the project must have windows!)

Now, when you reach the schedule properties, add some fields like family and type, count an cost.

goto Grouping/Sorting tab, sort by: family and type and uncheck itemize every instance

and if you click ok, this is the result so far:

Now what we want to do is create a new field with the total cost of every type of windows we have. Go to the fields in view properties and select calculated values.
Create a name for the field, select currency in the Type option and in the formula just type the name of the Cost field. Basically we are just duplicating the Cost field.

Finally, select the formatting tab, chose the new field called Total Cost and check the Calculated Totals.

If you didn't select a currency in the project units, you can definite here just for this field by choosing Field Format and unchecking the "use project settings".

This is the final look of your sechedule with both cost per unit field and total cost per type of window:

If you have any question or anything to add, please comment and i'll try to help you anyway i can.

14 comments:

  1. VOU ESTREAR OS COMMENTS!YEAH!

    Grande David!Força isso!

    Muito bem escolhido o nome!Realmente pegaste no factor crítico do programa...é preciso muita paciência e destreza, acima de tudo, para contornar as dificuldades!

    É sempre bom voltar a ter aulas com o mestre...;)

    E foste escolher um tema que ainda não explorei mas que é de grande utilidade.

    Prometo que vou estar atento e lançar a discórdia sempre que for possível! ;)

    Grande abraço!

    Uma questão:

    Que novidades nos vai trazer o Revit Architecture 2011?Já espreitaste qualquer coisita?

    ReplyDelete
  2. thanks for you comment João but next time do it in English so anyone can read it.

    regarding revit 2011, i have no idea about the improvements... i no longer have access to alpha or beta versions.

    keep commenting! ;)

    ReplyDelete
  3. there is a clip in another blog about applying costs in schedules that i think it's extremely important.
    check it out:

    http://revitrocks.blogspot.com/2010/01/adding-cost-and-currency-to-revit.html

    ReplyDelete
  4. you should say "very inteligent newbies" ;) hehe

    waiting for news... :D

    ReplyDelete
  5. David,
    Thank you and I hope to see more of your tips!

    ReplyDelete
  6. Nice first post David.
    In the future, I look forward to see some advanced tips.
    And please, do not replicate tips from other blogs! I get tired of reading the some tip in 3 or 4 different blogs, all pointing to the original.
    As for these type of schedules, I usually modify the headers in it. I rename the native cost parameter to rate and what you call total cost to cost.

    ReplyDelete
  7. hi Gonçalo,
    thank you for your post.
    i try to follow all the blogs about revit so i hope not to replicate any article already posted.

    ReplyDelete
  8. ...and since that day, I always like to refer to my good friend David about this exact tip.
    You solve the great mistery to me!
    yours truly,
    abuginthebug (yet a newby, I know)...

    ReplyDelete
  9. e novidades? :P

    tradução:
    nice blog david! :)

    hehe

    ReplyDelete
  10. Hi nice for sharing but I don't think that cost information should be embedded a revit file. I find it much more practical to take a schedule or an databse extraction out of revit and add costs there. Cost information can be rather sensitive information and you might not want to share it. Also if prices changes its a hassle having to go to all the families.

    ReplyDelete
  11. Daniel:
    i don't think the purpose of this exercise is to use cost or not. it's more a an increased possibility for our schedules...

    Marisa:
    i'm sorry for not posting another article but i have been so stressed at work...

    soon i'll post another interesting tip!

    ReplyDelete
  12. So this means that Windows 8 and Revit AutoDesk are compatible. Using Revit for Mac.

    ReplyDelete
  13. This is a great inspiring .I am pretty much pleased with your good work. You put really very helpful information. I am looking to reading your next post.
    Commodity Tips

    ReplyDelete
  14. Inbuilding.org are running a free online Q&A on BIM and Autodesk Revit.

    Come and have a look

    ReplyDelete