Abandoned [RELEASE] Trade Computer Extension

[Bariri]

What Excel version you are using?

Excel 2010 64 bits

 

[bAdbUd]

Eventure,
Found an error 13 for you, type mismatch, code stopped on the pointer shown.

As a result of selecting trade, followed by commodity search, selecting Palladium, resulting in listing 6 or so buying stations.
Selecting the first one in the list, and waiting for the destination system to be displayed, did not show this system, but poped up an error window with the error listed.
Here's the screenshot:
View attachment 22128

Failed in this VBA Code:
Private Sub Show_Goods_Click()

If Me.Show_Goods.Column(1, Me.Show_Goods.ListIndex) <> "" Then
Worksheets("Werte").Cells(55, 2).Value = Me.Show_Goods.Column(1, Me.Show_Goods.ListIndex)
If Worksheets("Werte").Cells(55, 2).Value <> Worksheets("Werte").Cells(15, 2).Value Then
Worksheets("Werte").Cells(12, 2).Value = Worksheets("Werte").Cells(57, 3).Value
Worksheets("Werte").Cells(13, 2).Value = Worksheets("Werte").Cells(57, 2).Value
Call DES_Commodities
Call DES_Display
Call Trade_Advisor
Call Check_Size
If Main_Panel = "TOP" Then
--> Panel_Menu_top.DES_Info.Caption = Worksheets("Werte").Cells(14, 2).Value & " : " & Worksheets("Werte").Cells(15, 2).Value
If Worksheets("Werte").Cells(14, 2).Value = Worksheets("Werte").Cells(4, 2).Value Then
Panel_Menu_top.DES_Distance.Caption = Worksheets("Werte").Cells(18, 5).Text & " LS"
Else
Panel_Menu_top.DES_Distance.Caption = Worksheets("Werte").Cells(16, 5).Value & " LY"
End If
Panel_Menu_top.DES_Juris.Caption = Worksheets("Werte").Cells(16, 2).Value & " SPACE"
Panel_Menu_top.DES_Eco.Caption = Worksheets("Werte").Cells(17, 2).Value
Panel_Menu_top.DES_Label.Caption = "SELECTED DESTINATION"
Else

Hope this is enough info for you, you have the database you fixed earlier it's almost identical.

Is this only once that this has happened, or a few times now?

EDIT >>>>>>>>>>

Ah, now I realise what you meant by pointer, yes I've seen that occasionally in the trade window, it does play up sometimes, when you're changing things. I've also clicked on a station and seen an error, although it doesn't happen all the time so it's difficult to reproduce, I have found.

 

[bAdbUd]

I'm not sure that is true, as I had a similar problem:

- - - - - Additional Content Posted / Auto Merge - - - - -



I had something similar, two things caused my issue.

1: POV was set higher than the game options menu allows, set it to lower than maximum, save and then set it back to maximum.

2: Make sure your monitor were TCE shows is set as the Primary monitor otherwise TCE will be taking a screenshot of the Primary monitor that doesn't have the Commodities menu shown on it. AT least that's what I thought caused the problem as changing that resolved the issue.

So it got fixed by enabling EliteOCR debug mode, I'd be interested to know why that worked?

 

[BennyBoyW]

Yeah - it makes no sense to me unless something in memory got restarted as a result of putting debug mode on.

 

[punkerich]

To my problem:

TCE shows only one of the imported stations, screens below, DB:

View attachment 22169

Destination Preview, sorted by Update:

View attachment 22171

 

[eventure]

To my problem:

TCE shows only one of the imported stations, screens below, DB:

View attachment 22169

Destination Preview, sorted by Update:

View attachment 22171

What is your trade range setting? It seems, its too low, thats why your imported stations are not present. Your Position is LHS 3447, thats why two stations of this star system have a distance of 0 LYs. Please move to an imported station, so your positon got an update. Then you should see the stations, you are missing.

Yeah - it makes no sense to me unless something in memory got restarted as a result of putting debug mode on.

Is your Commodity panel visible at your primary display, or a side display, when clicking on Start OCR Scan? And is you Debug window visible at your primary display, when it opens?

Excel 2010 64 bits

Thanks, i will change the routine from sync to async modus, perhaps it will fix it. Will test it here.

 

[punkerich]

What is your trade range setting? It seems, its too low, thats why your imported stations are not present. Your Position is LHS 3447, thats why two stations of this star system have a distance of 0 LYs. Please move to an imported station, so your positon got an update. Then you should see the stations, you are missing.

uhm, no, i'm not even near lhs 3447, >100ly apart.
I will continue testing this evening.

 

[Githnaur]

auto position not picking up stations intermitently - 1.37e - no way to force reposition

Sorry, i forgot to mention, its temporary disabled. I connected it with the Star System Summary panel. However, its a relic from the early days to TCE, where no auto position recognition was possible. Please tell, why we should preserve it?

I want to transform it into a more detailed position information.

TCE doesnt always correctly detect the registered station I am docked at - currently at Virtanen Hub in the Brani system, TCE shows my current position as "Brani: Near body 59". Being able to manually reset your position is very useful.

 

[bAdbUd]

NOTE: This isn't really a problem, more of a question about Importing db's and my results of what worked and what didn't, I may have misunderstood something, so a clarification would be useful.

TEST SCENARIO: IMPORTING DB's CONTAINED WITH TCE:

Starting with a Clean TCE:

* Unpacked Update 1.37 and added 1.37e Update, no changes made to the db
* Starting TCE without making any changes and has no stations with trade data, even though looking at the db file they are there
* In this default state no trade data is available so I imported the two station db but still no trade data was added
* Imported default database and still no data was available
* POSSIBLE REASON FOR THIS:
* The "STATION_UR" Tables tab doesn't contain any details except Station Name and Star Name, could this be why the trade data isn't imported
* Then I imported the temp db and that errors. In the Import Screen when processing the directory the Station box is available in the import screen and another box with no name, when clicking both or either it fails.

CONCLUSION:

After Using the Default db, and importing the other two db's I still had no Trade data.

Is that intentional?
I thought using the default db or the 2 Station db had trade data?

TEST SCENARIO: IMPORTING MY OWN DB's

I Imported all my 7 db's from oldest to newest, no problems experienced.

CONCLUSION:

Works as expected, all trade data available..

 

[eventure]

NOTE: This isn't really a problem, more of a question about Importing db's and my results of what worked and what didn't, I may have misunderstood something, so a clarification would be useful.

TEST SCENARIO: IMPORTING DB's CONTAINED WITH TCE:

Starting with a Clean TCE:

* Unpacked Update 1.37 and added 1.37e Update, no changes made to the db
* Starting TCE without making any changes and has no stations with trade data, even though looking at the db file they are there

The standard database has 150 stations included with all prices data as well. But if your current position is far away (the distance to the logged stations is greater than the selected trade range), they will not displayed at the Destination panel. If TCE cant find the right station to start with, it selects the first station available. This station is perhaps far away from the logged stations.

* In this default state no trade data is available so I imported the two station db but still no trade data was added

The two station database was included for the reason, some of you didnt want 150 stations in an area, you are not operating. So i included a database with a minimum of stations logged (2), so you can add your stations in the area, you found yourself. Its not intended for import. It a replacement for the standard database. Two stations of the LHS 3447 star system are logged in it, but your distance to LHS 3447 may be greater than the trade range setting. Thats because you cant see them.

* Imported default database and still no data was available

See above.

* POSSIBLE REASON FOR THIS:
* The "STATION_UR" Tables tab doesn't contain any details except Station Name and Star Name, could this be why the trade data isn't imported
* Then I imported the temp db and that errors. In the Import Screen when processing the directory the Station box is available in the import screen and another box with no name, when clicking both or either it fails.

The unregistered stations have no trade data, because they are unregistered. Only registered stations have them. The TCE.mdb_tmp is a clean database with no stations registered. Its only needed for importing from an old database to new, clean database. It will be renamed in the next full version to TCE.mdb_clear.

Because now it is possible to make a new database with only your recorded station through importing makes the two station database provided (TCE.mdb_2Stations) unnecessary. It will be excluded in the next release.

All you have to do for a new, own database is to record two stations in your region with the standard database and then importing only these both to a new database (select "Create new Database" at the import window). I will work for it, that TCE didnt need two stations logged at the start to operate, but in the current state it is necessary.

TEST SCENARIO: IMPORTING MY OWN DB's

I Imported all my 7 db's from oldest to newest, no problems experienced.

CONCLUSION:

Works as expected, all trade data available..

Nice to hear, that the new routine is working.

TCE doesnt always correctly detect the registered station I am docked at - currently at Virtanen Hub in the Brani system, TCE shows my current position as "Brani: Near body 59". Being able to manually reset your position is very useful.

Okay, thats a good reason. I will reactivate it, till the recognition of the actual position is more accurate. BTW, did you use the V1.37e version, when detecting the issue? And i hoped, you have registered Virtanen Hub at Body 59 prior the issue.

 

[mearmortal]

I'm loosing the will to live with my last error, can't get it working at all now.
I've tried re-installing 1.37, addiing in 1.37e, modifying Elite OCR and getting that working fine. I can use the 1.37 beta 1 database and import it fine now(Did have an issue before), I can re-launch the application I can browse cartography, and navigate other options, but still fails after searching for a commodity, when you select a particular station to bring up that stations details in the right side of the screen.

Importing the database creating a new one with two stations I don't want has the same effect, same error.

Using the database fixed for me before, although works, fails to complete the same task.


The only version that works for me at the moment is 1.37 beta 1, but that doesn't have the new commodity or the new station I wanted.
Any Ideas as to what next, should I just start again from scratch?
I've collected 26 stations worth of data and 2100+ commodiity data entries, don't really want to start again.

Link to the databases used is available if you want them.

And what's with the new version displaying locked if the game is not running? not easy to debug and view failure screens.

 

[eventure]

I'm loosing the will to live with my last error, can't get it working at all now.
I've tried re-installing 1.37, addiing in 1.37e, modifying Elite OCR and getting that working fine. I can use the 1.36 beta 1 database and import it fine now(Did have an issue before), I can re-launch the application I can browse cartography, and navigate other options, but still fails after searching for a commodity, when you select a particular station to bring up that stations details in the right side of the screen.

Importing the database creating a new one with two stations I don't want has the same effect, same error.

Using the database fixed for me before, although works, fails to complete the same task.


The only version that works for me at the moment is 1.37 beta 1, but that doesn't have the new commodity or the new station I wanted.
Any Ideas as to what next, should I just start again from scratch?
I've collected 26 stations worth of data and 2100+ commodiity data entries, don't really want to start again.

Link to the databases used is available if you want them.

And what's with the new version displaying locked if the game is not running? not easy to debug and view failure screens.

Please PM me for the link, i will check this.

 

[mearmortal]

Any chance of a version that works with LibreOffice's Excel equivalent? Pretty please?

I believe for now this requires VBA in Excel, which may not exist in other Excel type applications. SQL version has been discussed, but I don't see anything in the forum that says it's actually being developed at the moment.

 

[bAdbUd]

Found the issue, its the calculation function. Will be fixed soon.

Additional Information:

Clean Install off 1.37
Updated to 1.37b
All 150 Station Trade Data is shown, no Profit values
Updated to 1.37e
All 150 Station Trade Data is shown, Profit values
Imported Yesterdays db - 107 Stations Added
The included 150 Stations Data is still shown as positive Profit values
The 107 I've added all show as negative Profit values

 

[eventure]

Update (V1.37f) released:
- Bugfix for issue of negative profits and #N/A values
- Modified hotkey function, to check if hide/unhide issue is gone
- Reactivated Position panel
- New TCE.mdb_clear database, please delete the TCE.mdb_tmp file at your DB folder

 

[punkerich]

Update (V1.37f) released:
- Bugfix for issue of negative profits and #N/A values
- Modified hotkey function, to check if hide/unhide issue is gone
- Reactivated Position panel

if i try to import, create new db option, i get an error now:

error, line 10, 53 datei nicht gefunden.

typo, perhaps?

 

[eventure]

if i try to import, create new db option, i get an error now:

error, line 10, 53 datei nicht gefunden.

typo, perhaps?

Oooh, sorry, i forgot to mention, that you need to rename the TCE.mdb_tmp to TCE.mdb_clear. I will add the file to the update now. Sorry

 

[punkerich]

Oooh, sorry, i forgot to mention, that you need to rename the TCE.mdb_tmp to TCE.mdb_clear. I will add it to the update now. Sorry

no prob, dude!
lean back, have a drink on the house!

 

[eventure]

no prob, dude!
lean back, have a drink on the house!

Thanks, i need that now

 

[RadBlaster]

I just update my TCE to 1.37f and when i start the program I get this error.

---------------------------
Microsoft Visual Basic for Applications
---------------------------
Compile error:

Sub or Function not defined
---------------------------
OK Help
---------------------------

This is code it highlight (in yellow)

Sub WaitonKey()

Dim SKey As Long

Do Until HKey = ""
SKey = 0
SKey = GetAsyncKeyState(HotKey)
If CBool(SKey And &H8000) Then
If Main_Hide = True Then
If Main_Panel = "TOP" Then
Panel_Menu_top.Show
Else
Panel_Menu_bottom.Show
End If
Main_Hide = False
DelayMs (1000)
Else
If Main_Panel = "TOP" Then
Panel_Menu_top.Hide
Panel_Menu_top.BTN_DB_Stations.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Stations_Layer.BackColor = &H101010
Panel_Menu_top.BTN_DB_Stars.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Stars_Layer.BackColor = &H101010
Panel_Menu_top.BTN_DB_Commodities.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Commodities_Layer.BackColor = &H101010
Panel_Menu_top.BTN_Control.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_Control_Layer.BackColor = &H101010
Panel_Menu_top.BTN_Database_Layer.BackColor = &H101010
Panel_Menu_top.BTN_Database.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Stations_Layer.BackColor = &H101010
Panel_Menu_top.BTN_DB_Stations.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Stations.Visible = False
Panel_Menu_top.BTN_DB_Stations_Layer.Visible = False
Panel_Menu_top.BTN_DB_Stars_Layer.BackColor = &H101010
Panel_Menu_top.BTN_DB_Stars.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Stars.Visible = False
Panel_Menu_top.BTN_DB_Stars_Layer.Visible = False
Panel_Menu_top.BTN_DB_Commodities_Layer.BackColor = &H101010
Panel_Menu_top.BTN_DB_Commodities.ForeColor = &HFFFFFF
Panel_Menu_top.BTN_DB_Commodities.Visible = False
Panel_Menu_top.BTN_DB_Commodities_Layer.Visible = False
Panel_Menu_top.BG_Database_Add.Visible = False
....

I currently using Excel 2013
Running on Windows 8.1