|
Question about Excel & DYN_cyclist
|
| timpiej |
Posted on 11-08-2011 19:46
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
Hi there guys
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...
Greetings |
| |
|
|
| pienet |
Posted on 11-08-2011 20:38
|
Under 23
Posts: 53
Joined: 05-08-2008
PCM$: 200.00
|
You could try this Excel editor. I haven't tried it personally though.
https://pcmdaily.c...d_id=17692 |
| |
|
|
| timpiej |
Posted on 11-08-2011 20:52
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
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 |
| |
|
|
| Ad Bot |
Posted on 08-12-2025 12:24
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| pienet |
Posted on 11-08-2011 21:08
|
Under 23
Posts: 53
Joined: 05-08-2008
PCM$: 200.00
|
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).
Hopefully that helps.
|
| |
|
|
| Lachi |
Posted on 11-08-2011 21:09
|
Grand Tour Champion
Posts: 8360
Joined: 29-06-2007
PCM$: 200.00
|
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.
|
| |
|
|
| timpiej |
Posted on 11-08-2011 21:58
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
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! |
| |
|
|
| pienet |
Posted on 11-08-2011 23:00
|
Under 23
Posts: 53
Joined: 05-08-2008
PCM$: 200.00
|
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. |
| |
|
