Experienced Softlist User Needed!

You are here

6 posts / 0 new
Last post
Peter
Peter's picture
Experienced Softlist User Needed!
SoftPlan Version:
2014

I’m looking to see if any SP users with direct experience with Softlist and creating complicated custom formulas would be interested in some freelance work to create formula/s to report on the varying block materials.

Though it sounds simple the formula would need to report on a combination of;

  • Half blocks
  • Full blocks
  • Lintel Blocks
  • Sill blocks
  • Knock Out blocks

Ideally the result will allow me to place an order with the supplier and improve the accuracy of my quotes to clients.

The formula/s would of course need to report on varying wall heights, use of different windows and doors.

I have specific information that is to be used with the formula/s that I can email you out directly.

Any help or interested users please drop me a line.

 

Thanks
Peter
Softplan2014 - AUS.

farwood
farwood's picture
I'm not sure it is doable.   

I'm not sure it is doable.    I thought it thru some.    There's no way to judge the distance from corners to openings, and in between openings, Lintel blocks are pretty easy.   PreCast headers pretty easy.     Knock out blocks you could get close, we cut them in Florida.

I could be wrong?

I think this would need to be hard coded, like framing

This would be a valuable formula

 

Peter
Peter's picture
Defined Variable

Hi Farwood,

Thanks for the post.

Definitely a little tricky. I think it might take a little work and with the use of several formulas.

 

Question on the same topic!

I have this formula whereby I’ve created a defined variable called Block_Openings to accumulate the outcome of the working formula. However this is not happening. Any advice as to where I’m going wrong is greatly appreciated. I've underlined the passage where things are going astray.

My formula is;

if wall_exterior

   list ( (rounddn(rough_width,400)/400)*(rounddn(rough_height,200)/200))

   Block_Openings=Block_Openings+((rounddn(rough_width,400)/400)*(rounddn(rough_height,200)/200))

Endif

 

To clarify the formula works fine but I need the outcome to go into Block_Openings for use in another formula.

Any help will be greatly appreciated.

Bill Wimberley
Bill Wimberley's picture
Formula

Perhaps the List function is preventing the second part from running. In other words the list function is run then it jumps to Endif without doing the Block_Openings. Try something like this:

if wall_exterior

   Block_Openings=Block_Openings+((rounddn(rough_width,400)/400)*(rounddn(rough_height,200)/200))

   list ( (rounddn(rough_width,400)/400)*(rounddn(rough_height,200)/200))

Endif

 

​I don't know if that will work but give it a shot.

Bill is the owner and maintainer of SoftPlanTuts.com

farwood
farwood's picture
Peter to accumulate a

Peter to accumulate a material to another, when in the edit for that material, over on the right under "Calculation method" check "accumulate"  and the middle will change to a box call Add to material, and here list the material(Block_opening) you want the block to add to,

I hope this is possible, i do a lot of block, my best method to date is to put my block in 3D and just count them down the wall, and determine, 1/2 blocks etc.  Last job, I ended up with about 20 extra block,  that'll never happen again. But really could if i was more patient.

Seems the program to get blocks is just a square foot of the walls divided by the block area, and if formula does less openings, this is just another sq.ft. thing. 

You could get close to 1/2 blocks with just opening height divided by 8

lintel blocks would be pretty easy.

Knock outs you could kinda get close,or here i do a vertical cell(rebar) pour plan, that I could just have the symbol of this report a quanity.

I haven't tried to do all that formula writing like the if_walls and end_if, as a custom formula, if you know what I mean.   I usually use the List format and write a little formula there.  But I want to grow, and get softlist working better for me.   I still creat too many errors in pricing.

I don't totally understand the formula you have showing, do you have a block size listed in "User Defined Variables"?  What count are you going for with the formula you have here, block count????

I've tried to attach my block formula?   Anyway, i think part of your formula is trying to send to the Block_opening acumulation?

 

Hope you have good eyes to read my formula below

 

 

 

 

 

Peter
Peter's picture
Problem resolved!

Problem resolved!

What I found is if I changed the sequence of the calculation in the actual material definition list before the Block_Openings variable was needed by other formulas it worked fine.

Many Many thanks for all the input:)