@steverugi Wow, insightful video, thank you. I was too scared to venture into the 'Costing & Scheduling' tab, a couple of Ds beyond my scope, however I am keen to explore further now, I think I have a book of Quantity Surveying on the shelf that will get a read before my summer holidays are over.
@Nigel said:
@steverugi Wow, insightful video, thank you. I was too scared to venture into the 'Costing & Scheduling' tab, a couple of Ds beyond my scope, however I am keen to explore further now, I think I have a book of Quantity Surveying on the shelf that will get a read before my summer holidays are over.
most welcome @Nigel , happy to help if needed, ciao
Hi @Nigel
@steverugi Wow, insightful video, thank you. I was too scared to venture into the 'Costing & Scheduling' tab, a couple of Ds beyond my scope, however I am keen to explore further now, I think I have a book of Quantity Surveying on the shelf that will get a read before my summer holidays are over.
If you can go through my italian accent I prepared some quick videos on BoQ preparation in BBIM:
- This shows a simple slab and wall, extracting quantities from the model and setting rates manually:
- This shows a different method using a Schedule of Rates to add rates to the Cost Items in the same BoQ
- Finally this video shows the use of a .csv table to import queries to automatically extract quantities from the model into a BoQ, rates are then added like in video 2
I am quite new to all of this (BBIM, video recording, etc) but I hope it can be of help
PS the Schedule of Rates too can be imported as a .csv table
Just one more thing..
Since today I am in the video mood I prepared another one with a different case similar to a rate build-up method
- This shows another way of calculating a rate using resources (labor and material) to be assigned to the cost item in the BoQ
again, it's just a quick way to show what I learned so far, with some grey area for which I hope to receive some feedback from the deus ex machina @SigmaDimensions :D
@Massimo said:
@steverugi thanks for the reported workflow, i think it's very useful!
There is also a nice feature about automating the connection between the cost item and model quantities...
If you specify, in the BoQ csv fiile, the column "Property" with a defined quantity name (for example "GrossVolume") and in the column "Query" specify the query filter (for example IfcWall, location="My Storey" ), you can automate the connection between the cost item and the elements quantities...
For example, in this case, it connects the GrossVolume quantity of all the walls located in My Storey with the cost item ....
@Massimo
do you happen to know what to use in the column properties in the automated BoQ when it comes to counting items?
if I use
I get this (I double checked that window and door are on the GF storey)
thanks
@steverugi so i tried and also looked at the code and i think that atm Count just doesn't work.
I saw in this video at minute 17:17 @SigmaDimensions shows that it is possible but i think it doesn't work because the code looks only at the qto properties (GrossVolume, NetVolume, etc...)
Maybe i'm missing something btw ... :-)
@Massimo said:
@steverugi so i tried and also looked at the code and i think that atm Count just doesn't work.
I saw in this video at minute 17:17 @SigmaDimensions shows that it is possible but i think it doesn't work because the code looks only at the qto properties (GrossVolume, NetVolume, etc...)
Maybe i'm missing something btw ... :-)
I thought as much, thanks for your reply
@steverugi said:
- This shows another way of calculating a rate using resources (labor and material) to be assigned to the cost item in the BoQ
Hey @steverugi , watched your video, very sweet ! Using the resource's base cost in that exact order is a happy accident - not by design... but I like the idea and we should works towards this possibility. Let me think about it and I'll come back to you on it
@steverugi said:
do you happen to know what to use in the column
propertiesin the automated BoQ when it comes to counting items?
@Massimo said:
@steverugi so i tried and also looked at the code and i think that atm Count just doesn't work.
There is a bug atm indeed , I'll fix it up today, ready for tomorrow daily build
@SigmaDimensions said:
@steverugi said:
- This shows another way of calculating a rate using resources (labor and material) to be assigned to the cost item in the BoQ
Hey @steverugi , watched your video, very sweet ! Using the resource's base cost in that exact order is a happy accident - not by design... but I like the idea and we should works towards this possibility. Let me think about it and I'll come back to you on it
Hi @SigmaDimensions
I'll be honored and happy to contributute in any way possible, just let me know how and what suits you best, cheers
On counting elements from cost schedule import:
ping @steverugi , @Massimo , here's the fix:
https://github.com/IfcOpenShell/IfcOpenShell/commit/b6663e9189c5f335736dcbd27767e6f8f913701c.
It now works whether you write Count COUNT count. Also, if you don't write anything at all, and only have a selector query for a given cost item row, this will also be considered as counting.
@SigmaDimensions
On counting elements from cost schedule import:
ping @steverugi , @Massimo , here's the fix:
https://github.com/IfcOpenShell/IfcOpenShell/commit/b6663e9189c5f335736dcbd27767e6f8f913701c.
It now works whether you write
CountCOUNTcount. Also, if you don't write anything at all, and only have a selector query for a given cost item row, this will also be considered as counting.
EDIT I downloaded the latest BBIM and tried it: it worked!
thanks for the quick fix, much appreciated
Hi @SigmaDimensions said:
Hey @steverugi , watched your video, very sweet ! Using the resource's base cost in that exact order is a happy accident - not by design... but I like the idea and we should works towards this possibility. Let me think about it and I'll come back to you on it
would you be able to elaborate it further with some simple explanation? what is the right order?
did you watch my other clip
is it not correct as well?
if you don't mind, what could be the reason why I can have the right amount of the total cost of resources assigned to a task but they do not show like your recent 5D video?
thanks for your help
Hi @SigmaDimensions
OK I sorted out the issue with showing detailes of resource allocation x rate, my mistake was to set quantity value when it is rather calculated by the resource productivity rate.
If a quantity is entered it overrides the calculated one, makes sense!
I still haven't figured out how to calculate material resources quantity through a task assigned to the BoQ, the only solution atm is to use the cost schedule's Elements pane.
I also wonder how materials are tracked through work schedule
maybe on the next video? :)