Litcube's Excel TShip Editor 0.64b
Moderators: Moderators for English X Forum, Scripting / Modding Moderators
-
- Posts: 628
- Joined: Tue, 13. Apr 10, 20:03
Excel 1: Opened a custom TShips file (vanilla + imp's cockpit mod)
Excel 2: Opened the SRM Tships file
Excel 2: Marked all "Max Transport Class" entries down to line 374 and copied them into the clipboard
Excel 1: Pasted them in the same column
Then this error showed up:
Runtime Error '1004':
Application or object defined error.
Excel 2: Opened the SRM Tships file
Excel 2: Marked all "Max Transport Class" entries down to line 374 and copied them into the clipboard
Excel 1: Pasted them in the same column
Then this error showed up:
Runtime Error '1004':
Application or object defined error.
-
- Posts: 628
- Joined: Tue, 13. Apr 10, 20:03
-
- Posts: 628
- Joined: Tue, 13. Apr 10, 20:03
-
- Posts: 628
- Joined: Tue, 13. Apr 10, 20:03
The Cockpit mod only changes TShips and Animations.
SRM changes some files, yes. But I do not need them. I didn't modify or save the SRM Tships file.
I tried it anyway and I still get the same error.
Looks like I have to modify all dropdown fields one by one. It works that way without errors.
EDIT:
Then it's my Excel version (Excel 2010). Sorry to steal your valuable time. You did a great job with this tool.
SRM changes some files, yes. But I do not need them. I didn't modify or save the SRM Tships file.
I tried it anyway and I still get the same error.
Looks like I have to modify all dropdown fields one by one. It works that way without errors.
EDIT:
Then it's my Excel version (Excel 2010). Sorry to steal your valuable time. You did a great job with this tool.
-
- Posts: 628
- Joined: Tue, 13. Apr 10, 20:03
-
- Posts: 628
- Joined: Tue, 13. Apr 10, 20:03
-
- Posts: 295
- Joined: Sat, 19. Nov 05, 19:26
Does not work with Open Office 3+
I have version 3.3 Open Office (latest version) and the buttons that open, copy, etc., do not show up....wish this worked but it does not.
-
- Posts: 2262
- Joined: Tue, 23. Dec 03, 22:32
Re: Does not work with Open Office 3+
TrixX pointed out to me that it will not work with OpenOffice.LarryBurstyn wrote:I have version 3.3 Open Office (latest version) and the buttons that open, copy, etc., do not show up....wish this worked but it does not.
stu
Transcend Mod Team - AP, TC, Reunion
I'm surprised anyone expected it to work with anything other than Excel.
Also,
Update!
0.60b:
- Acceleration column was accidentally named Column 1. Woops.
- Added "link" checkbox for RelVal NPC. All values for RelVal NPC and Player are the same, so I just put a checkbox in there that enable the sheet to auto-update all these values to match the Player RelVal values.
- Added Price column. If you enable the edit button here, you'll be able to enter a price (in game price), and the RelVal will be automatically calculated off of that. This formula is accurate to within ~7 credits. A few things need to happen before you can use this properly. Price Mod 1 & 2 all need to be set to 1, and RelVal NPC Link enabled. Vanilla uses 25, which causes an error near the 107 million mark caused by wrapping errors. You'll have to re-calculate your prices if you decide to use this. Note price does not take into account the built-in wares. Those will be added to the cost of the ship in game.
Also,
Update!
0.60b:
- Acceleration column was accidentally named Column 1. Woops.
- Added "link" checkbox for RelVal NPC. All values for RelVal NPC and Player are the same, so I just put a checkbox in there that enable the sheet to auto-update all these values to match the Player RelVal values.
- Added Price column. If you enable the edit button here, you'll be able to enter a price (in game price), and the RelVal will be automatically calculated off of that. This formula is accurate to within ~7 credits. A few things need to happen before you can use this properly. Price Mod 1 & 2 all need to be set to 1, and RelVal NPC Link enabled. Vanilla uses 25, which causes an error near the 107 million mark caused by wrapping errors. You'll have to re-calculate your prices if you decide to use this. Note price does not take into account the built-in wares. Those will be added to the cost of the ship in game.
-
- Posts: 628
- Joined: Tue, 13. Apr 10, 20:03
@Litcube
0.60b doesn't import SRM. Error message:
EDIT: You know what? I will uninstall Office 2010 and try 2007.
0.60b doesn't import SRM. Error message:
"Debug" leads me to this line:Runtime Error '6':
Overflow
It loaded fine with the older version.NextPos = InStr(Pos, WholeLine, Sep)
EDIT: You know what? I will uninstall Office 2010 and try 2007.
Last edited by fallenwizard on Sat, 12. Mar 11, 05:53, edited 1 time in total.
Was that a stock SRM TShips? Also what version?fallenwizard wrote:@Litcube
0.60b doesn't import SRM. Error message:
"Debug" leads me to this line:Runtime Error '6':
Overflow
It loaded fine with the older version.NextPos = InStr(Pos, WholeLine, Sep)
I just loaded up 0.88b 0.84 and the current SRM without incident. Did you make any alterations?
"If you’re not prepared to be wrong, you’ll never come up with anything original."
Sir Ken Robinson
Sir Ken Robinson
-
- Posts: 5
- Joined: Sat, 27. Dec 08, 04:28
-
- Posts: 2062
- Joined: Thu, 18. Aug 05, 13:04