Jump to content


Photo

jack stud count


  • Please log in to reply
5 replies to this topic

#1 Morgan Reitz

Morgan Reitz

    Advanced Member

  • Members
  • PipPipPip
  • 30 posts

Posted 03 October 2017 - 11:13 AM

Hello,

I am trying to figure out a formula to count all my studs. I do not want to split up the jack studs from the other precut studs. Our framers take a precut and cut it down to a jack stud, so I want my take off to reflect that. I am attaching screen shots of the formulas and the softlist report. 

 

One formula has:

if not (stud type=jack) 

and the other formula I took that line out hoping it would include those jack studs in my overall stud count.

 

But...both formulas are giving me the same count.

 

Any suggestions? Thanks!

Attached Thumbnails

  • SOFTLIST.png
  • COUNTING JACK STUD.png
  • NOT COUNTING JACK STUDS.png


#2 Allen McDonnell

Allen McDonnell

    Advanced Member

  • Members
  • PipPipPip
  • 115 posts

Posted 03 October 2017 - 12:07 PM

I agree....Please let me know what you come up with.

 

It would also be nice if the "wall stud" formula counted those members as regular studs as well.  (The members on top and bottom of a window)

Attached Thumbnails

  • aaaaaaaaaaaaaaaaaaaaa.jpg


#3 Morgan Reitz

Morgan Reitz

    Advanced Member

  • Members
  • PipPipPip
  • 30 posts

Posted 04 October 2017 - 09:39 AM

I am getting close....I've tried lots and lots of different formulas.

What I have that works is two formulas. One for studs and one for jacks that both report my precut lengths. I am attaching a formula that is close that should combine the two, but isn't working just right. yet. Once I export the material list to Excel, I can easily combine the studs and the jacks together using the product code I input, but I would like SoftList to do that for me!

I am not sure how to use accumulate for a custom formula. Once I click on accumulate, my custom formula goes away and I have to input the information in List form. But list form doesn't give me as many options as custom formula does.

Attached Thumbnails

  • 1.png
  • 2.png
  • 3.png
  • 4.png


#4 Allen McDonnell

Allen McDonnell

    Advanced Member

  • Members
  • PipPipPip
  • 115 posts

Posted 04 October 2017 - 11:42 AM

I have Steve at SP working on some options.  Ill let you know what i (he) comes up with.



#5 Allen McDonnell

Allen McDonnell

    Advanced Member

  • Members
  • PipPipPip
  • 115 posts

Posted 04 October 2017 - 11:47 AM

It is a little baffling and frustrating that this has not already been figured out.  I drew and estimated in a lumber yard for 10 years.  We would send out precuts by the bunk and then some..... and then long lengths for balloon framed walls and garage walls.  All this "jack stud", combined wall stud, wall stud, is not realistic.

 

Here you go framer.  Only use these wall wall framing....and then jacks get cut out of 8', and then take this other 8' and cut 14 16" sections....blah blah blah.



#6 Morgan Reitz

Morgan Reitz

    Advanced Member

  • Members
  • PipPipPip
  • 30 posts

Posted 06 October 2017 - 11:31 AM

Here is the formula that tech shared with me today. It should count studs, jacks, and cripples. Just duplicate this formula for 2x4/6 precut A,B,C but change the dimensions. Hope this helps! Let me know if this works for you, I am still testing it out to make sure it works for how our company builds.

 

if between (stud_width,3",5") and within(stud_thickness,0.5", 1.5")
   if matches(stud_type, common,backer,king)
      if between(stud_height,precut_A-1.125",precut_A+1.125") or matches(stud_height,precut_A-1.125",precut_A+1.125")
         set_dimens(inches,inches,inches)
         list(1,2",4",precut_A)
      else
         if stud_height<precut_A+1.125"
            set_dimens(inches,inches,inches)
            list(stud_height/precut_A,2",4",precut_A)
         endif
      endif
   endif
   if num_heights=2
      if between(max_height,precut_A-1.125",precut_A+1.125") or matches(max_height,precut_A-1.125",precut_A+1.125")       
         if stud_type=jack
            set_dimens(inches,inches,inches)
            list(1,2",4",precut_A)
         else
            if matches(stud_type,cripple,sill_jack)
               set_dimens(inches,inches,inches)
               list(stud_height/precut_A,2",4",precut_A)
            endif
         endif
      endif
   endif
endif

  • Allen McDonnell likes this




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users