[9/JG54_EZ]

Hey all

I've asked this elsewhere with no luck and hope that someone here might be able to help me with a mission I'm building.

What I want to do is give the file that I need adjusted to someone that can add 1500 to the last set of numbers in my mission file. I don't understand Excel (old dog that refuses to learn new tricks), but imagine what I'm asking is very easy to do for someone that DOES understand how to use it..

What I've got, are 3000 lines that needs 1500 added to the last column (see example below).
I will have to add it the manual method, line by line, three thousand times if I can't find someone that can do this easily using Excel. If there is a volunteer willing to do this, I can send the file asap (want to keep it secret until it's finished).

190_Static vehicles.stationary.Smoke$Smoke13 0 34749.86 9507.21 540.00 110.96
191_Static vehicles.stationary.Smoke$Smoke13 0 34749.92 9506.97 540.00 88.92
192_Static vehicles.stationary.Smoke$Smoke13 0 34749.95 9506.65 540.00 2.86
193_Static vehicles.stationary.Smoke$Smoke13 0 34749.95 9506.34 540.00 2.80
194_Static vehicles.stationary.Smoke$Smoke13 0 34749.94 9506.04 540.00 2.72

_________________


190_Static vehicles.stationary.Smoke$Smoke13 0 34749.86 9507.21 540.00 1610.96
191_Static vehicles.stationary.Smoke$Smoke13 0 34749.92 9506.97 540.00 1588.92
192_Static vehicles.stationary.Smoke$Smoke13 0 34749.95 9506.65 540.00 1502.86
193_Static vehicles.stationary.Smoke$Smoke13 0 34749.95 9506.34 540.00 1502.80
194_Static vehicles.stationary.Smoke$Smoke13 0 34749.94 9506.04 540.00 1502.72

So the question remains... Any volunteers?

EZ

[stuka_40]

I myself do not know much about Excel!
but if you write your numbers beginning with 110.96 in the first cell A1 until A3000 in the first column, then in the first cell (B1) in the second column, type 1500 then select that cell (right-click with your mouse, highlight it with a dashed line around it in the pop up menu, select copy and copy its contents (number 1500), then select the rest of the second column down until the B3000 and then right click the mouse again and choose past, now the second column contains 3000 times numeral 1500 straight downward.
Now put the mouse in cell A1 and select until the C1 and then pull down to the C3000, now you have three columns marked, it's just pressing the auto sum ​​button (the big button with sigma sign on it) and the sum of the first and second column's cells
will appear in the C1 until C3000, now you can copy an past the third column in your mission file.
I think there must be even easier way for this by writing a formula up there, but I do not know which formula!

Code:

A         B     C
1  110,96    1500  1610,96
2  88,92     1500  1588,92
3  2,86       1500  1502,86
4  2,80       1500  1502,8
5  2,72       1500  1502,72

[9/JG54_EZ]

Thanks Stuka but I was looking for someone that could whip it off in a moment's time, and I had no time to try to learn Excel, only to find out that it can't be done. I raised them all by hand because of lack of patience, but would still like someone to confirm whether this can be done or not.

And no guesses please.

[stuka_40]

Well I answered your post the day after if you had checked your post you could avoid a lot of unnecessary addition work by hand, there is no guesses, I can confirm that if you do what I have described it will work in Excel and it only takes a few seconds. what I have described in response to your post, I myself have tried in Excel.

[9/JG54_EZ]

I read your post the day that you posted it, and i thank you for trying to help. My post's question was asking for a favor, and not instructions on how to do it myself (old dog/new tricks).

No worries.