How to change the SPT Blow Count appearance in OpenGround Cloud Professional and Template Studio

When entering blow counts into the ASTM American Default configuration in OpenGround Cloud Professional where there is SPT refusal, the Blow Counts column auto-populates in feet (e.g., 10-20-50/0.25' or 50/0.167' ), this is also how it shows up when I generate a boring log. How do I change the display in Professional and most importantly, what expression/method should I be using in Template Studio to make the boring log template show it in inches (e.g., 10-20-50/3" or 50/2" )?

Thanks in advance!

Parents
  • Hi Allison

    Thanks for asking about this. I think you need to replace the expression with the one below:

    ConcatenateWith('-',[Blows1st],[Blows2nd],[Blows3rd])+
    if(if(isnull([Blows1st]),0,1)*0.5 +if(isnull([Blows2nd]),0,1)*0.5 +if(isnull([Blows3rd]),0,1)*0.5 +if(isnull([Blows4th]),0,1)*0.5>(numberordefault([DepthBase],0)-numberordefault([DepthTop],0)),
    '/' + fixed(text((numberordefault([DepthBase],0)-
    numberordefault([DepthTop],0)) - (if(isnull([Blows1st]),0,1)*0.5 +if(isnull([Blows2nd]),0,1)*0.5 +if(isnull([Blows3rd]),0,1)*0.5 +if(isnull([Blows4th]),0,1)*0.5) + 0.5)*12,1,false) + chr(39) + chr(39)
    ,null)
    I hope this helps.
    Martyn
Reply
  • Hi Allison

    Thanks for asking about this. I think you need to replace the expression with the one below:

    ConcatenateWith('-',[Blows1st],[Blows2nd],[Blows3rd])+
    if(if(isnull([Blows1st]),0,1)*0.5 +if(isnull([Blows2nd]),0,1)*0.5 +if(isnull([Blows3rd]),0,1)*0.5 +if(isnull([Blows4th]),0,1)*0.5>(numberordefault([DepthBase],0)-numberordefault([DepthTop],0)),
    '/' + fixed(text((numberordefault([DepthBase],0)-
    numberordefault([DepthTop],0)) - (if(isnull([Blows1st]),0,1)*0.5 +if(isnull([Blows2nd]),0,1)*0.5 +if(isnull([Blows3rd]),0,1)*0.5 +if(isnull([Blows4th]),0,1)*0.5) + 0.5)*12,1,false) + chr(39) + chr(39)
    ,null)
    I hope this helps.
    Martyn
Children
No Data