Quantity cross-check
Hi All,
I have a challenge in the most of the projects: QTOs from the BIM models does not match the ones from the schedules and cost estimates.
Is there any software I could overlay these quantities and cross-check them? I need to identify the inconsistencies and point them either to design team or the cost estimators.
I do have the established data model for the models and have some possibility to tranfer cost estimate into the data structured data format (YAML, JSON). The minor challenge is to define the cosnistent data model from the schedules ( as XLSX files).
I could create the in-house solution, but would like not to.
Comments
Have you tried with Bonsai?
I couldn't find the workflow.
It's not allways one-to-one mapping, some schedule/CE rows must be either skipped (eg. instalation and commissioning works), some should be split by quantities. It allways depends on the quality of data in all data sources.
It could be a task for the well-trained NN agent, but I don't have one yet. :)
I'm a QS and use Bonsai on daily basis, specifically to extract quantities off .ifc files
I think to overcome your challenge you might need to start from your available data structure you want to validate.
If possible, could you please share more of your
to better understand what you are trying to achieve?
The way I see from your posts you need a cross-reference id to map your cost items (quantities), but it could be something else.
Sometimes a good data wrangling of the dataset to validate using, for instance, Excel Power Query (if the format of original dataset is somehow regular) does the job, or a few lines of Python/Pandas might be a solution.
Cheers