radius

Hi guys I am trying to draw an arc in a 3D bubble scatter plot.I have a code that looks like this Sub insertArc() Dim Arc As Shape Const CenterX = 200 Const CenterY = 200 Const Radius = 10 ActiveSheet.ChartObjects("Chart 15").Activate Set Arc =...

Hi all, I am trying to cap this formula to 15 =IF(B2=1,(C2*12)/1000," ") B column contains number of stems. C contains stem diameter. H contains =IF(B2=1,3.141*(I2^2)," ") which calculates the root protection area and I column contains =IF(B2=1,(C2*12)/1000," ") For example currently: Tree...

I've been working on a formula that counts how many sites fall within the radius of another site. This is the formula I've used. =COUNTIFS('0301 Master'!H:H,"<"&$D2,'0301 Master'!H:H,">"&$F2,'0301 Master'!I:I,">"&$E2,'0301 Master'!I:I,"<"&$G2) Is there a way to list the names of the sites that...

I am looking to calculate the overall pipe length required for manufacturing... For example, the known data is a Pipe (50mm diameter), a bend with a Radius of 600mm and an ANGLE of 45 degrees. The Data is laid out as; Pipe Size 50, Degree 45, Radius 600, Cut Length ??? The sample...

Trying to get a formula to calculate chord when angle and radius are known and would like to be able to calculate distance from chord to center of radius as well. Please......

Hi everybody! I just started to write some code in VBA and I´m looking for a macro to draw a circle with radius written in a cell. I saw various codes but just to draw a generic circle not with specific radius. Is it also possible to decide the circle position? Thanks so much for any...