Trimble Business Center

 View Only
Back to discussions
Expand all | Collapse all

Creating Cut Sheets in TBC

  • 1.  Creating Cut Sheets in TBC

    Posted 04-05-2023 11:19

    I've been exploring reports in TBC and an As-Staked report almost does what I want, but not exactly, so I decided to make a custom report. We currently make our cut sheets in excel and include: Station & Hub #, Design Elevation, Stake Elevation, Difference (in decimal feet), difference (in feet & inches), cut/fill, and a location/description (4' off set, edge pave, etc.) . My question to you is this: Is there a way to have the report give feet & inches? I've only been able to get it to output decimals, and contractors don't like that, or has anybody made a report that matches this and wants to share it?

    Thanks



    ------------------------------
    James Bronico, Jr.
    Senior Survey Technician
    NJ, USA
    ------------------------------


  • 2.  RE: Creating Cut Sheets in TBC

    Posted 04-06-2023 07:37

    I have not seen anything like you're asking as the reports use the units that are set up in the project settings from my understanding. However, if you're using Excel and have a column for the decimal feet, use this formula in bold to create the conversion to feet-inches. Change the 'A1' in the formula to match the cell your decimal feet is in. Then drag this formula down the column to match the rest of your data. =INT(A1)+(12*MOD(A1,1)>=11.5)&"'"&IF(12*MOD(A1,1)>=11.5,0,ROUND(12*MOD(A1,1),0))&"""" 
    I hope this helps!



    ------------------------------
    Riana Hendrickson
    ------------------------------



  • 3.  RE: Creating Cut Sheets in TBC

    Posted 04-06-2023 13:24

    That's a nice formula for Excel, but it rounds everything to the nearest inch.  Do you have a formula that rounds to the nearest 1/16" ?  That's what contractors are looking for, both in format and in accuracy.

     

    Ex.  5.286' = 5'-3-7/16"

     

    I realize that will be a much more complex formula, but the accuracy is necessary in most cases.

     

    ============

    Brian C

    ============

     




    Original Message


  • 4.  RE: Creating Cut Sheets in TBC

    Posted 04-06-2023 14:23

    See if this will do what you need:
    =INT(A1) & "'" & TEXT(MOD(A1,1)*12, "# ??/16 """"")&""""



    ------------------------------
    Riana Hendrickson
    ------------------------------

    Original Message


  • 5.  RE: Creating Cut Sheets in TBC

    Posted 04-07-2023 05:12

    I'm using this as a reply to all of you. Thanks for your responses, but unfortunately they did not help. Our existing excel cutsheet does have the 1/16 inch conversion and does everything we want it to. I think maybe my actual question got kind of jumbled, but I'm trying to recreate what excel does in a TBC report. After spending some more time on it, I have not figured out the inch conversion, but have found another issue in that the cut/fill command returns "?" in every row. Not sure why that is either.



    ------------------------------
    James Bronico, Jr.
    Senior Survey Technician
    NJ, USA
    ------------------------------

    Original Message


  • 6.  RE: Creating Cut Sheets in TBC

    Posted 04-10-2023 20:14
    If you're comfortable working with Excel stylesheets, you can try modifying the StakeoutReport.xslt file located in C:\Program Files\Trimble\Trimble Business Center\Support\iv. Within this file, you should be able to add the necessary unit conversion formula to the stakeout point deltas.
     
    I understand this may seem a bit complicated, but it's worth giving it a try if you're comfortable working with stylesheets.


    ------------------------------
    Ramin Rad
    ------------------------------

    Original Message


  • 7.  RE: Creating Cut Sheets in TBC

    Posted 04-07-2023 09:01

    That's 95% of it Riana.  Very nice work!

     

    The only minor issue is it doesn't show least common denominators.

     

    Ex. 6.4583' = 6'-5-1/2" (not 6'-5-8/16")

     

    Anything requiring 1/32" or tighter accuracy should probably be rounded down to the nearest 1/16th as contractor tape measures stop at 1/16".

    They'll be confused by 4/16", and they'll lose their minds if they see a dimension like 37/256".

     

    I saw someone had 1/3" on a jobsite print once.  It ended up getting rounded down to 5/16" for the sake of sanity.

     

    Please know your help here is appreciated!

     

    James – Sorry for your frustrations.

     

    Thank you,

     

    ============

    Brian C

    ============

     




    Original Message