|
Excel Editor (Version 6, July 2nd)
|
| valverde321 |
Posted on 16-08-2012 16:26
|
World Champion
Posts: 12986
Joined: 20-05-2009
PCM$: 530.00
|
Hi, I am trying to use a formula to reduce the RES of all rows in the column by (-5).
However, if I type in =SUM (BJ2)-5 I just end up getting 0. I dont know what I am doing wrong, although I'm sure I am. Could anyone guide me on how to reduce a whole columnow by -5 please? (correct formula etc.)
I will attach my db in case anyone wants to fix it for me, without bothering to tell. 
Edited by valverde321 on 16-08-2012 16:41
|
| |
|
|
| lluuiiggii |
Posted on 16-08-2012 16:52
|
Grand Tour Champion
Posts: 8542
Joined: 30-07-2010
PCM$: 200.00
|
Well, here's what I'd do (it's probably a very crappy method, but it works ): add a new column next to resistance and, in the first cell (line 2), type "=BJ2-5" (since resistance, at least on the Excel I just opened, is column BJ). Then copy and paste it to the whole column. Now copy the whole column with new values, paste it in Notepad, copy from notepad and paste it in correct resistance column. Now delete the created column and that's it! 
|
| |
|
|
| valverde321 |
Posted on 16-08-2012 17:19
|
World Champion
Posts: 12986
Joined: 20-05-2009
PCM$: 530.00
|
Thanks a lot luigi Its worked so far, but I haven't loaded it in game yet! Handy trick indeed, although scrolling in notepad is a pain
|
| |
|
|
| lluuiiggii |
Posted on 16-08-2012 17:30
|
Grand Tour Champion
Posts: 8542
Joined: 30-07-2010
PCM$: 200.00
|
valverde321 wrote:
Thanks a lot luigi Its worked so far, but I haven't loaded it in game yet! Handy trick indeed, although scrolling in notepad is a pain
Really? Damn, I wasn't sure if I should mention it in my earlier post, decided not to do it "ah, if he knows an excel formula, pretty sure he'll know this". You can select all in notepad with Ctrl + A
|
| |
|
|
| Lachi |
Posted on 16-08-2012 18:21
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
No notepad needed:
1. Add new column
2. Enter formula
(3. Copy formula to all cells if Excel does not do it automatically)
4. Select column having formula
5. Copy
6. Select column you want to paste the data into
7. Paste values (This depends on the excel version you are using, use the manual or ask google if you do not know how to paste values)
8. Delete added column
Edited by Lachi on 16-08-2012 18:22
|
| |
|
|
| zmiguel91 |
Posted on 10-03-2013 17:15
|
Junior Rider
Posts: 38
Joined: 05-07-2009
PCM$: 200.00
|
Hi! first time using this editor... what I have to do to merge two DB's?
I want to copy some races to the Daily DB, but after I click Build and save the new db, the changes do not appear in the new DB. |
| |
|
|
| Lachi |
Posted on 11-03-2013 00:11
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
Make sure that there is an X in the first column of all the tables you want to include in the new build.
If that is not your problem, you have to be more specific because the problems could be everywhere even outside my tool.
Also remember to never use spaces in the file names because the builder from Cyanide does not like it. |
| |
|
|
| zmiguel91 |
Posted on 11-03-2013 09:03
|
Junior Rider
Posts: 38
Joined: 05-07-2009
PCM$: 200.00
|
Never mind, I got it.
After copying the lines for STA_race / STA_stage tables had to cover these new lines with that thing on the bottom right, if not excel does not accept the new lines when saving.
Thanks.  |
| |
|
|
| fickman |
Posted on 11-03-2013 21:27
|
Sprinter
Posts: 1627
Joined: 25-07-2011
PCM$: 200.00
|
Hi,
I did a lot of editing on the 2013 DB and I dont know what I did but now everything is gone. I have an weekly save and im tryying to copy the info fron that save to the DB in the Mod folder but i cant have 2 db open at the same time so that i can copy things from one db to the other. Any Ideas??? I dont want to copy one by one everything. |
| |
|
|
| Ad Bot |
Posted on 21-11-2024 19:39
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| Lachi |
Posted on 11-03-2013 21:35
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
You can make copy of the excel file, then open one DB in each excel. Like this, you can copy and paste from one to the other.
(Make sure to avoid the problem zmiguel91 experienced) |
| |
|
|
| fickman |
Posted on 11-03-2013 21:55
|
Sprinter
Posts: 1627
Joined: 25-07-2011
PCM$: 200.00
|
Lachi ur a genius. U save me a couple of hours of work. Thnxs.
Edited by fickman on 11-03-2013 21:55
|
| |
|
|
| daloe |
Posted on 07-09-2013 11:23
|
Free Agent
Posts: 145
Joined: 13-10-2012
PCM$: 200.00
|
Also compatible with PCM2013?
Dutch
Playing PCM 2013 - PCM.daily Real Name DB
Belkin fan!
|
| |
|
|
| Jesleyh |
Posted on 07-09-2013 11:24
|
Tour de France Champion
Posts: 15274
Joined: 21-07-2012
PCM$: 200.00
|
daloe wrote:
Also compatible with PCM2013?
Works for me, though I only use it for copying stuff from one to an other DB.
Feyenoord(football) and Kelderman fanboy
PCMdaily Awards: 12x nomination, 9x runner-up, 0x win.
|
| |
|
|
| daloe |
Posted on 07-09-2013 11:27
|
Free Agent
Posts: 145
Joined: 13-10-2012
PCM$: 200.00
|
Jesleyh wrote:
daloe wrote:
Also compatible with PCM2013?
Works for me, though I only use it for copying stuff from one to an other DB.
Yeah, I just want to use it to add stages, because that doesn't work very good with lachi's editor
Dutch
Playing PCM 2013 - PCM.daily Real Name DB
Belkin fan!
|
| |
|
|
| daloe |
Posted on 07-09-2013 11:33
|
Free Agent
Posts: 145
Joined: 13-10-2012
PCM$: 200.00
|
How do I get a DB in the excel file? I don't get your first step in the instructions...
Dutch
Playing PCM 2013 - PCM.daily Real Name DB
Belkin fan!
|
| |
|
|
| Lachi |
Posted on 07-09-2013 18:28
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
Do you mean these instructions?
Lachi wrote:
How to use it:
1. Extract the files from the archive into one folder
2. Open the Excel file (Exporter.xls)
3. Use the buttons to Extract the DB, open additional tables and finally Build a new DB
The file you downloaded, you have to extract it. Create a folder on your desktop and put the files there. |
| |
|
|
| maxime86 |
Posted on 20-09-2013 04:11
|
Classics Specialist
Posts: 2950
Joined: 01-03-2012
PCM$: 200.00
|
Hey Lachi, everytime I try to export a db it crashes, my file has no spaces its just called thedb and it doesnt work i really need some help |
| |
|
|
| Wieltjesplakker |
Posted on 31-12-2013 10:37
|
Under 23
Posts: 72
Joined: 19-10-2010
PCM$: 200.00
|
Hi Lachi. I have been using the excel editor a lot but since a few days the buttons on the start up sheet are not working anymore. In other words, the macros are not loading. Do you have any suggestions how to solve this? I am using Excel 2010 with Windows 8. |
| |
|
|
| Lachi |
Posted on 31-12-2013 17:23
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
Did you try to re-download the editor? Did it work in W8 before?
If you moved the file, you might have to re-enable the workbook and/or the macros (There should a button below the ribbon).
Edited by Lachi on 31-12-2013 17:25
|
| |
|
|
| Wieltjesplakker |
Posted on 01-01-2014 11:38
|
Under 23
Posts: 72
Joined: 19-10-2010
PCM$: 200.00
|
Thanks for the reply. Yes, it worked perfectly before. I found the problem in Excel. Rolled back the installation of Office 2010 Service Pack 2 and now the editor works perfectly again.
Edited by Wieltjesplakker on 01-01-2014 13:36
|
| |
|
