MS Excel Formula Help

[Andy_con]

ive created a spread sheet to calculate this -

got everything done apart from A. A refers to a gradient so if there isnt one then its 0. times something by 0 and you get 0 and ive just been struggling to get a working.

here is the spread sheet ive done can anyone help

here

due to my lack of excel knowledge ive split each part of the sum up.

 

[DB.]

Spreadsheet link doesn't work pal.

 

[Nickson]

[h=1]Not Found[/h]The requested URL /test/mfs/MfS_-_SSD.xlsx was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

[Andy_con]

fixed

 

[chris_182]

what's the problem? D + nothing is D. Just make sure the calculation of D + A is in the same cell.

 

[iain187]

for a start AL5 says =AH4*2


AH4 has nothing in it. no formula or anything?

 

[Andy_con]

what's the problem? D + nothing is D. Just make sure the calculation of D + A is in the same cell.

d what?

its a im struggling with

 

[Andy_con]

for a start AL5 says =AH4*2


AH4 has nothing in it. no formula or anything?

not got a clue on what you just said lol

 

[iain187]

did you make those formulas?

 

[Andy_con]

um if you mean in the spread sheet then yes

 

[chris_182]

d what?

its a im struggling with

D in your formula

 

[Andy_con]

now if i do this in excel = D (cell B15) + 0.1 * A (cell B16) i get 5.01 i dont think i get the correct anwser

im using figures D = 4.41 and A= 6

 

[LukeW]

Doesnt 0.1 * 6 = 0.6 therefore it is right?

 

[Andy_con]

um yeah you are right maybe im looking at it the wrong way round

4.41 + 0.1 = 4.51 * 6 = 27.06

 

[LukeW]

Nah if 0.1 and A are in the same cell it'll do that multiplication first and then add it to the value in the other cell, like each cell is in a set of brackets.

 

[chris_182]

just do it all in the same cell.

 

[sbridgey]

I made this. http://www.mediafire.com/?3btkmps336u8m9i

with this Algorithm.

(V * T) + ((V * V) / 2) * (D + (0.1 * A));

I can change the algorithm if it is wrong.

 

[Andy_con]

Um when i put this in im getting an answer of 2029, when it should be around 147

I made this. http://www.mediafire.com/?3btkmps336u8m9i

with this Algorithm.

(V * T) + ((V * V) / 2) * (D + (0.1 * A));

I can change the algorithm if it is wrong.

 

[Tim.]

I can't seem to open your attachment, all I get is a zip file full of various xml files.

In any case, I understand your question - what if a is zero then (d+0.1a) is the same as writing (d+ (0.1*0)). As you said, anything multiplied by zero is zero, therefore in the instance of no gradient the final part of the equation (d+0.1a) is the same as writing (d+0), which in my opinion is absolutely fine.

If the equation is correct then that's what it should be. Try to amend it and you'll get inaccurate results.

Also I'm not sure sbridgey's Algorithm is correct. Personally I think it's:

(V * T) + (V * V) / (2 * (D + (0.1 * A)))

 

[LukeW]

Also I'm not sure sbridgey's Algorithm is correct. Personally I think it's:

(V * T) + (V * V) / (2 * (D + (0.1 * A)))

^ This.

 

[Andy_con]

that one works perfect many thanks all

 

[sbridgey]

Is this one working?

http://www.mediafire.com/?7izi0hm8y707zx3

 

[Andy_con]

??? got the spread sheet i did working