Trimble Business Center

 View Only
Expand all | Collapse all

Totals by siteimprovement AND Aoi, Possible?

  • 1.  Totals by siteimprovement AND Aoi, Possible?

    Posted 11-19-2020 02:18

    Hi.

     

    Probably this is possible but i just dont understand how to do it or configure the take off report correct. 

    This is my problem:

     

    I have a project with 3 different houses and 3 different customers, i will give the one quote each for the project but i want do to the finish design for the whole area. This means i need to use AOI:s and siteimprovements.

    I did just 2 AOI:s for testing, one for area 2 and one for area 3.

    In my report i will get the summary for cut and fill for area 2 and 3 to "FD with subgrades adjusted", thats perfect. 

    I will also, in the last page, get the summary for all specific materials. "material totals by site improvement". Thats also good.

     

    But, i am missing "material totals by site improvement" for area 2 and 3 separate. 

    I will get this number but i need to add them manually. Lets say that i have a lot of small areas with the same site improvement i will get many pages in the report with volume for each area and that is not so interesting. I would like to get the volumes in the last page separated by AOI:S i have choosed, is that possible?  

     



  • 2.  Re: Totals by siteimprovement AND Aoi, Possible?

    Posted 11-19-2020 06:53

    I export my reports to excel. Then I can come up with the totals I need.



  • 3.  Re: Totals by siteimprovement AND Aoi, Possible?

    Posted 11-19-2020 07:01

    Hmm. 

    So if you, like me, have 2 separate AOI:s and inside thoose have 5 siteimprovements wich is the same. Can you see the total volume of each material inside each 2 AOI:s? 



  • 4.  Re: Totals by siteimprovement AND Aoi, Possible?

    Posted 11-19-2020 07:13
      |   view attached

    I don't do much with material but it is on the excel file.

    We just do dirt. 

    Attached is an old report file.

    Attachment(s)

    xlsx
    Takeoff Report.xlsx   30 KB 1 version


  • 5.  Re: Totals by siteimprovement AND Aoi, Possible?

    Posted 11-19-2020 07:18

    Note I have overlapping areas of interest.



  • 6.  Re: Totals by siteimprovement AND Aoi, Possible?

    Posted 11-19-2020 08:32

    Thanks.



  • 7.  Re: Totals by siteimprovement AND Aoi, Possible?

    Posted 11-19-2020 09:04

    I think the way to do this is to do one report for every AOI, is that correct? 



  • 8.  Re: Totals by siteimprovement AND Aoi, Possible?

    Posted 11-19-2020 10:31

    The takeoff reports do have some flaws in totaling, especially the demo reports!  For improvement totals of each individual AOI you have to "trick" the software.  I create a NULL AOI (using approx 2 sf boundary) within each AOI you want to total.   Then, when you run reports, be sure to export to excel and select the NULL AOI and the AOI you are trying to total.  Works for me every time!



  • 9.  Re: Totals by siteimprovement AND Aoi, Possible?

    Posted 11-19-2020 11:42

    Aha, thanks! That one i couldnt figure out my self.