'if' formula

I would be tempted to write it this way in math.js

[Point Count]*[Pile Depth]*(if*([Diameter]==,.30,0.1563)+if([Diameter]==.35,.222,0)+if([Diameter]==.40,.2778,0))

I stopped at .40 cause I am tired... but you could keep going if this works... I use this for calculating weight on rebar with a linear measurement....

But this will choose the correct answer and ignore the wrong answers with the 0

Let me know how this turns out, I will be around tomorrow morning if you have questions.

Thank you, Todd!

Unfortunately, it appears to not be working. The red triangle with an exclamation mark on the last row highlights the problem.

Have a good night’s sleep, Todd. I’m confident you’ll have it fixed in no time.

Hi again, Todd,

Thanks to your help, I was able to make it work. I removed the multiplication sign (*) between "if" and "Diameter," and added a '0' after 0.1563 and now it looks like this. I’ll continue working on the rest and let you know how it goes. Thanks again!

[Point Count]*[Pile Depth]*(if([Diameter]==0.30,0.1563,0)+if([Diameter]==0.35,0.222,0)+if([Diameter]==0.40,0.2778,0)+if([Diameter]==0.45,0.3125,0))

Hi again, Todd,

Here it is, completed. I have attached it for everyone to review and learn from, as I did. I would like to mention that these are the production rates per Vertical linear meter I use in normal soils, which may not be the same for everyone else, but I wouldn't mind if somebody would like to share their prod rates.

Thank you,

Regards Steve G.

Nice work on sniffing out the missing and extra items

i was tired

i I would recommend turning that formula into a custom variable to protect it from accidental change

I can show how in a zoom meet

email me todd@zztakeoff.com

You should put that in our project showcase

nice work!!

I also wanted to say that you can condense this formula by making it a drop down, "Value-Name" variable. This will help eliminate any accidental changes to this.

I can show you how to do this if you schedule a free half hour on my calendar.

https://calendly.com/training-zztakeoff/30min

It is a pretty slick way of making this formula protected as well less cluttered in your formula window.

You can also reach out through our chat during the week and ask for me... thanks and again awesome work on that formula!

I'm curious - do you know if these pile depth values are taken from an engineering reference table, or is there a specific formula or calculation used to determine the depth based on the diameter?

Hi @Sam,

Pile Depth Values

Pile depth values are determined through a combination of engineering recommendations and the results obtained from geotechnical reports. In certain situations, it is possible to calculate an average depth (as I did with this one), provided that the project requirements allow for such an approach.

Design of Bored Piers

Bored piers, which are vertical structural elements designed to support substantial loads, are engineered using principles from soil mechanics, structural engineering, and relevant Australian code-based guidelines. The diameter and depth of these piers are established according to both the magnitude of the imposed loads and the geotechnical characteristics of the foundation soil.

Take care Sam and I hope this answers your questions.

I'm not an engineer, but I had to learn all this during my 47 years in constructions.