diameter

I have set up a table with 5 columns such as below; <tbody> DIAMETER WALL Low Ø HI Ø LO HI OD ± 0.000 12.740 0.510 1.240 0.100 12.700 25.400 0.510 1.650 0.130 12.700 25.400 1.660 3.400 0.250 25.400 38.100 0.640 1.650 0.200 25.400 38.100 1.660 3.400 0.250 38.100 50.800 0.640...

I've created a formula for figuring out the capacity of a section of oil pipeline in US barrels using the formula for area, pi*radius squared*length. The diameter of the pipe is in Column E and is displayed there in inches. The length of the pipe is in Column F and is displayed in feet. My...

I am confused as to why my Excel 2016 is pulling the wrong data. I think I have the formula set up correctly. IF(G4="2A",VLOOKUP(H4,C17:K30,9),IF(G4="3A",VLOOKUP(H4,M17:U30,9))) FYI - I have noticed other spreadsheets where I have a Vlookup in the cell is failing. It forces me to type in the...

i ve a circle with 18 nodes and i want to plot it in excel may be using chart.it can be done. now suppose i plotted a circle of diameter 2m then i have 18 nodes equally divided on its perimeter.what if i want to reduce the circle diameter to 1.8m how to generate its coordinate any easy way to do...

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...

Hi Guys, The example is as follows. Diameter which has more numbers than one needs to be splitten into rows. <tbody> Number Number2 Name Diameter Diameter-total Some num 114 114 Tree1 23 + 45 + 23 91 91 115 115 Tree2 24 + 56 80 80 116 116 Tree3 23 23 23 117 117 Tree4 45 45 45 118 118...

Hi all, I need help to write codes for the following situation. <colgroup><col><col></colgroup><tbody> Fix rebar Up to 12mm diameter. 37,060.00 16mm diameter. 224,740.00 20mm diameter. 25mm diameter. 32mm diameter. 7,140.00 Concrete Grade </tbody> I need to sum...