Trimble Business Center

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

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!

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

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!

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

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

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!

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

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.

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

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!

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

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

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!

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