Question about Computers & Internet

1 Answer

Excel formula I have a round disc 1800mm in diameter I want to calculate in excel the surface area of 1800mm in m2 and i have 38 discs. what is the total surface area inn square metres is it 1800*3.14=5652 5.65square metres ?

Posted by on

  • pi314 Feb 28, 2008

    so does that mean 966 sq metres of surface area or less than 1 sq metre .966 ?

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 35 Answers

The formulae for the surface area of round disc is
pi * r * r
where pi=3.14 and r =radious of disc= diametre/2 

for this 1st u have 2 calculate the radious of the disc that is
180/2=90mm
then convert it to  m by dividing 1000 ,so radious=90/1000=0.09 m
finally calculate the area= 3.14 * 0.09 * 0.09=0.025434 sq metres
for 38 disc multiply 38 with the above area that is
0.025434 * 38=0.966492 sq metres

in excel 2007  u can do it more easily by going 2 formulas tab.
Under formla tab click on engineering formula and  then convert
here u can convert from mm to m
after converting use the above formula i just told u.

Posted on Feb 27, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

13 inch round pan 2 inches deep =how many cubic inches


You can view this question as what is the surface area of the 13 inch round pan, and then with it being 2 inches deep, calculate the volume.

Surface area = pi * r ^ 2, where r is the radius of the pan
In this case, the diameter is 13 inches, so the radius will be 6.5 inches.

Putting it into the formula, we get surface area = pi * 6.5 ^ 2.

Because of BEDMAS, we have to do the square before we multiply.

Surface area = pi * (6.5 ^ 2)
= 132.7square inches.

To get the volume, we multiply this surface area by the depth of 2 inches.

Volume = surface area * height
Volume = 132.7 * 2
Volume = 265.4 cubic inches.

Good luck,

Paul

Nov 02, 2016 | Office Equipment & Supplies

2 Answers

What is formula to find percentage of females in my workplace?


      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

      https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
    Feedback

    How to Calculate Percentages in Excel

    www.excelfunctions.net > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet

    https://exceljet.net/formula/get-percentage-of-total
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Computers & Internet

1 Answer

What is the area of a circle if the circumference is 2 pi inches


area formula is PI x r squared
that is 3.1417 times the radius of the circle squared
example is:- 3.1417 times 3 inches squared =3.1417 times 3x3=3.1417x9=28.279 square inches if you want to work back from a circumference measurement, the formula for circumference is 2 x PI x radius or PI x diameter
if you have a circumference of 12 inches then the dia is calculated 12 inches = dia x PI to get the diameter , divide the 12 inches by PI and that will be the diameter so that is 12 divided by 3.1417 =3.819 inches
now you can go from the first formula the radius is the diameter divided by 2 so the radius will be 3.819 divided by 2 = 1.909 inches
so applying the area formula it becomes 3.1417 times 1.909 times 1.909 =11.458 square inches
to find your answer simply substitute the dimensions in place of the example figures.in the relevant formula.

Aug 24, 2015 | Office Equipment & Supplies

1 Answer

Formula for circumference


Circumference of a Circle: 2 x pi x radius - OR - pi x diameter,

or if you need some sphere calculations?

Sphere Surface Area: 4 X pi X radius squared OR
pi X diameter squared Sphere Volume: 4/3 X pi X radius cubed OR
( pi X diameter cubed ) / 6
By the way.......... "pi" = 3.1415926536




f098d442-6e69-493e-8854-abe08bc70bfa.jpg

Apr 29, 2014 | Office Equipment & Supplies

1 Answer

Hexagon calculator


I will not try to guess what that diameter represents, so I will give you all mensuration formulas for the area of a regular polygon.
s is the measure of the side, r the radius of the inscribed circle, R the radius of the circumscribed circle, and n the number of sides.
If the angle unit in your calculator is the degree, use 180 instead of Pi. Use the formulas with PI if angle unit is set to radians.
In the formulas on the last line of the display screen (the formulas with sine functions) the radius r should be R (circumscribed circle radius). cot is the reciprocal of the tangent function (cot(x)=1/tan(x) )

c93df117-a9e7-4633-adb9-0d8d9297b919.png

Apr 14, 2014 | Office Equipment & Supplies

1 Answer

WHAT IS THE AREA OF a circle with a diameter of 20 cm


Come on princess. Use the formula for the area of a circle: Area=PI*D*D/4
where PI can be entered using a key on the calculator, and D is the diameter.
Area =100*Pi cm^2 or about 314.159 cm^2

Feb 03, 2012 | Office Equipment & Supplies

1 Answer

How to calculate surface area using a casio fx -83 ES


You sort out the formula for the surface you have to calculate then substitute the numerical values for the variables (sides, bases, heights), the constants if any (pi, etc.) an press = to get the result
Ex Square with side= 2m
Surface area=side^2
Area : 2 [X^2][=] result is 4 m^2
Circle of radius r=3 cm
Area: Pi* 3[^2]=28.27 cm^2

May 12, 2010 | Casio FX-115ES Scientific Calculator

1 Answer

How do I use sharp EL W531 to solve quadratic equations?


Hello,
This calculator does not have a program to which you give the equation, and which returns the solutions. Sorry. You have to use the formulas you learned.
Let the equation be ax^2 +bx+c=0
You compute the discriminant Call it disc.
disc= (b^2-4*a*c)
1. If discriminant is larger than zero you have two solutions. Let us call them x1 and x2.
Then x1=(-b+square root of disc)/(2*a)
and x2= (-b-square root of disc)/(2*a)

2. If disc=0 , square root of disc =0 and x1=x2=-b/(2*a)
3. If disc is negative, there are no real solutions.

To find the solutions you replace a, b, and c by their numerical values, to calculate disc, its square root, and calculate X1 and X2.

Hope it helps.

Jun 26, 2009 | Sharp EL-531VB Calculator

1 Answer

How do I use sharp EL 531W to solve quadratic equations?


Hello,
This calculator does not have a program to which you give the equation, and which returns the solutions. Sorry. You have to use the formulas you learned.
Let the equation be ax^2 +bx+c=0
You compute the discriminant Callit disc.
disc= (b^2-4*a*c)
1. If discriminant is larger than zero you have two solutions. Let us call them x1 and x2.
Then x1=(-b+square root of disc)/(2*a)
and x2= (-b-square root of disc)/(2*a)

2. If disc=0 , square root of disc =0 and x1=x2=-b/(2*a)
3. If disc is negative, there are no real solutions.

To find the solutions you replace a, b, and c by their numerical values, to calculate disc, its square root, and calculate X1 and X2.

Hope it helps.



May 17, 2009 | Sharp EL-531VB Calculator

1 Answer

How to solve quadratic equation in SHARP EL-531WH


Hello,
This calculator does not have a program to which you give the equation, and which returns the solutions. Sorry. You have to use the formulas you learned.
Let the equation be ax^2 +bx+c=0
You compute the discriminant Call it disc.
disc= (b^2-4*a*c)
1. If discriminant is larger than zero you have two solutions. Let us call them x1 and x2.
Then x1=(-b+square root of disc)/(2*a)
and x2= (-b-square root of disc)/(2*a)

2. If disc=0 , square root of disc =0 and x1=x2=-b/(2*a)
3. If disc is negative, there are no real solutions.

To find the solutions you replace a, b, and c by their numerical values, to calculate disc, its square root, and calculate X1 and X2.

Hope it helps.

May 05, 2009 | Sharp EL-531VB Calculator

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

325 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...