two part concrete question..

[muleman1]

1> Is it possible to adjust the weight of concrete assigned to volume of concrete in AS? 

2> Is it possible to show cubic yards of concrete in BOM's? AS has to calculating volume to assign weight...right?

maybe @acbsdesign  @Emanuel.Nestor  or @anyonewhocanhelp

[acbsdesign]

---

@muleman1 wrote:

1> Is it possible to adjust the weight of concrete assigned to volume of concrete in AS? 

2> Is it possible to show cubic yards of concrete in BOM's? AS has to calculating volume to assign weight...right?

maybe @acbsdesign  @Emanuel.Nestor  or @anyonewhocanhelp

Hi,

May be @ChristianBlei can help, he is pretty good with API.

---

[Sebastian_Eiche]

1.)

Maybe I misunderstood you, but the weight of concrete is given by the density in the database. It could be changed in the database 'material'.

2.)

The volume could be easily calculate by using a formular in the bom and then devide it by using the density.

If you just give me a few pics what should be the result, if could create a screencast for this.

[acbsdesign]

If the shape is rectangular-yes, formulas may work, but if the shape is any polygon, then there must be a line calculating the weird volume.

[johnjmbennett · Accepted solution]

Volume, Yes it is, but which BOM type, if  via bom editor you need to create a template to do this, in the template you add a formula to create the volume based upon parameters required.

https://youtu.be/be4LcHHPbWI

[muleman1]

@johnjmbennett  thank you, that is almost exactly what I would like to accomplish!  Thanks x1000!!!

Where do I find the density and weight tables so to create our own concrete? We not sure what 20/25. 30/35 etc are?? We need to create 3000 psi / 3/8 aggreate, 3000 psi 3/4 aggreate, 4000 psi. 5000. 6000, etc.... 

Is density some way the same as volume (cubic yards in our case) ?? for example a cubic yard of a certain concrete mix might weigh 4000 pounds.....

[Sebastian_Eiche]

this is definitely not only working with rectangular objects. In the BOM Editor the token for Exact Weight is also working for concrete objects as for plates. 

So by using a calculation Volume=weight/density, this is working for all concrete objects. I made some test in the past with concrete objects which have feature for example for stepped or sloped footings, and as I remember this volume was correct.

[muleman1]

@Sebastian_Eiche  thanks for all the input you provide for us who are far, far less knowledgeable! 

How do we create our own concrete? Let's call it "4000_3/8" that weighs 3800 pounds per cubic yard.

[Sebastian_Eiche · Accepted solution]

first thing to know is: the density is set as metric--kg/m³, so I used a the google search to convert it:

So after this I open the management tools + object property Editor, select an existing material, press new and insert the values:

your post sounds a little bit ironic, so did I miss something? Maybe I mssunderstood the original post?

[muleman1]

this is what we needed. we understand where to add the new concrete. we just had no idea how the density was measured. now we see kilos in your screenshot. In our AS info it says density of concrete is 1.45. We have tried every conversion Google knows to convert 1.45 weight to the reported pounds in our BOM...to no avail.

[acbsdesign]

---

@Sebastian_Eiche wrote:

this is definitely not only working with rectangular objects. In the BOM Editor the token for Exact Weight is also working for concrete objects as for plates. 

So by using a calculation Volume=weight/density, this is working for all concrete objects. I made some test in the past with concrete objects which have feature for example for stepped or sloped footings, and as I remember this volume was correct.

---

I meant to say -A volume of concrete for example that is poured as ballast inside compartments of a barge, If it is plate-like polygon-yes, but I thought the question is calculating the weight based on exact volume (overall volume of the tank minus the volume of the steel members that are cast in concrete, which I am looking to solve for myself too.

If it is just a polygonal contour like a plate with thickness-this is not an issue, we can have the exact weight.

[muleman1]

@johnjmbennett @Sebastian_Eiche @acbsdesign 

I just can't get it to work....

1> Should I have to add anything to AstorBase - UnitsOfDensity?

2> I have our new concrete density (whatever that is) set at 1724 (which is 3800 lbs converted to kilograms)

[muleman1]

@Sebastian_Eiche @johnjmbennett 

Well I had not set my reporting correct in BOM setting...duh.. It working now, but bad calculation some how....???

The test block of concrete is 3ft x 3ft x 3ft and should weigh (density ??) 3800 pounds (not 105,162,635) and should be 1 cubic yard (not 46,656.01)

[muleman1 · Accepted solution]

OK !! I figured it out somehow and accidently!! Could not have even attempted without @Sebastian_Eiche and @johnjmbennett   THANKS!

The density factor turned out to be .08145 (whatever that is a factor of, I have no clue, I just know it works) The formula on the BOM for total Cubic yards worked out to be" |GlobalWeight/3800 " 3800 being the weight of a yard of the concrete in discussion.    

[muleman1]

@johnjmbennett one last question. I used our new BOM in a model and it worked fine, but did not sub total and/or total our column of cubic yards. What formula or tag or whatchamacallit do you use to subtotal and total?

[Sebastian_Eiche · Accepted solution]

the old AKN is not available anymore =(

The problem is, you had to use a little adjustment:

[muleman1]

I am very sorry to be so dull, but I'm not sure what to do from screenshot. I have tried but just am missing something.

[Sebastian_Eiche · Accepted solution]

you use a formula for creating the request. These formula has a number for example: formula1 or formula5
This number had to be used in the datafield of the field, where you want to summarize your formula. then you have to change the the points I show in the screenshot

[muleman1]

@Sebastian_Eiche  Got it! Thanks! Now it all works fine.

[cadman777]

Sebastian,

"ironic"

did you mean "sarcastic"?

Cheers!