Correct Formulas for Mathematical Equations.

[siash69]

Could someone please check that my formulas are correct please.

<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas></v:stroke></v:shapetype>
<v:shape id="_x0000_i1025" style="width: 52.5pt; height: 15pt;" type="#_x0000_t75">Thanks.


<v:imagedata o:title="" chromakey="white" src="file:///C:/Users/Ashburn/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png">




<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"></o:lock></vath></v:stroke></v:shapetype><v:shape id="_x0000_i1025" style="width: 59.25pt; height: 15pt;" type="#_x0000_t75"> <v:imagedata o:title="" chromakey="white" src="file:///C:/Users/Ashburn/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png"></v:imagedata></v:shape><o></o>

</v:imagedata>

</v:shape>

<o>
<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"></o:lock></vath></v:stroke></v:shapetype><v:shape id="_x0000_i1025" style="width: 52.5pt; height: 15pt;" type="#_x0000_t75"> <v:imagedata o:title="" chromakey="white" src="file:///C:/Users/Ashburn/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png"></v:imagedata></v:shape><o></o>
<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"></o:lock></vath></v:stroke></v:shapetype><v:shape id="_x0000_i1025" style="width: 59.25pt; height: 15pt;" type="#_x0000_t75"> <v:imagedata o:title="" chromakey="white" src="file:///C:/Users/Ashburn/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png"></v:imagedata></v:shape><o></o>

</o>

 

[J.Ty.]

The last two formulas seem OK to me. The first two ones, to the contrary, seem wrong - I attach my versions below.

J.Ty.
[TABLE="width: 85%"]
<tbody>[TR]
[TD][TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A1[/TH]
[TD="align: left"]=(PI()*D1^2)/4[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A2[/TH]
[TD="align: left"]=0.25/(LOG10(K1/(3.7*D1)+5.74/(R1^0.9)))^2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[joeu2004]

Almost every formula has errors, or they can simplified.

In the last two formulas, we cannot write "g", unless it is a named reference. But since G can be a column reference in some contexts, I suggest that you put the value of "g" into a cell.

It appears that "g" is the gravitational acceleration constant.

Suppose G1 is "g" for the proper units: either 9.80665 (m/s^2) or =980.665/(12*2.54) (ft/s^2). It is better to calculate the latter than to enter an approximate constant.

Assuming B5 is "D", C5 is "L", F5 is "K", G5 is "v" and H5 is "Re", and the following are to be calculated: A5 is "A", I5 is lambda, J5 is "hf" and K5 is "hl":

A5: =PI() * B5^2 / 4

I5: =0.25 / LOG10(F5/(3.7*B5) + 5.74/H5^0.9)^2

J5: =(I5 * C5/B5) * G5^2 / (2*$G$1)
or
J5: =I5 * C5 * G5^2 / (B5 * 2*$G$1)

K5: =F5 * G5^2 / (2*$G$1)

 

[siash69]

Thanks for the help, much appreciated.