Alright, here's the thing, I'm making a database, and I'm lowering the stats for every rider because my DB will be starting a couple years ago. Is there any way that I can lower the stats in groups? Like e.g. I select all the numbers and reduce them by 7, or I select all the 80's and reduce them to 73 all together? Because it takes a long time if you want to reduce every rider stat with for example the PCM editor that came with the race...
Yeah yeah, I know about the editor, it's not about that, I'm just wondering if there would be a function in excel or another program where I could reduce the numbers in groups, not 1 by 1
Let's say your stats are in column A. Insert a column on the right-hand side (so B).
Then you can write up a formula in cell B1 such as =A1-7 (which reduces the stats by 7) and slide it down the column B. This is done by selecting the lower right corner of the cell B1 and sliding it down.
When the modifications are done, copy the column B over column A and erase the extra column.
If you have a more complicated formula in mind than just lowering all attributes by 7, you can set up some IF/THEN statements (look up the help in Excel).
Excel has a function called search and replace. There you change multiple values at once. But you have to think it through (or double check) else you end up with many wrong numbers.
Also you can use formulas to calculate (e.g. subtract 1 from the flat stat of all riders). But I really cannot explain it in English. Maybe you can find excel formula tutorials.
Just as I'm reading this I do remember the search and replace (computer lessons are a long way back) I have used it and I have the correct numbers now, thanks for the help lads!
Yeah search and replace works wonders (should have thought of that!)
Be sure to select the column (or columns) where you want to modify values. Otherwise you could change something in the cyclist ID column (for instance) which could lead to an invalid database.
