AutoPlant - Generating Reports/BOM - removing the feet/inches symbols for export to excel

Hi,

Using AutoPlant V8i (SS5) and generating BOM reports for PM.  He is specifically looking for pipe lengths and would like to easily total them up in Excel.

When the report is generated in Imperial it tags the lengths with the feet and inches symbols ('-") which isn't user friendly when importing to Excel.  Is there a setting or another way to remove the symbols and only produce a numerical value?

Thanks.

Parents
  • We had this same issue and I was able to get around it by changing my report to pull the pipe_len field instead of the cut_len field.  Cut_len is converted into feet and inches, where as pipe_len will remain in decimal inches.  I applied a formula in excel to divide pipe_len by 12 so it would report in decimal feet.

    You may want to consider how precise you need your report to be, as there are instances where cut_len will differ from pipe_len.  In general, it has served us well so far.

    Hope it helps!

    Jesse

Reply
  • We had this same issue and I was able to get around it by changing my report to pull the pipe_len field instead of the cut_len field.  Cut_len is converted into feet and inches, where as pipe_len will remain in decimal inches.  I applied a formula in excel to divide pipe_len by 12 so it would report in decimal feet.

    You may want to consider how precise you need your report to be, as there are instances where cut_len will differ from pipe_len.  In general, it has served us well so far.

    Hope it helps!

    Jesse

Children
No Data