Abandoned [RELEASE] Trade Computer Extension

[Bragolatch]

There is something weird happening with stations being both unregisted and registered.

I've been deleting the unregistered ones when I have a duplicate but TCE doesn't really update until I shut it down and restart it !

It's probably not a current bug but something from my fixed db.

I'll report again if it turns out to be more then that.

 

[Maedhros]

Here a proposal for the new UI:

Spoiler

Minimized:
View attachment 22946
Opened
View attachment 22948
View attachment 22949
View attachment 22950

Summery:
1. Obscure less
2. Bigger Position/Destination panel
3. Repetitive mouse movements
4. Full access to all buttons at once
5. Easier to code
6. Possible separation of menu buttons and Position/Destination panel (no more top/down menu handling, independent positioning)
7. Easier to expand

Perhaps i can deliever a test version with this new UI. But please lets discuss this UI to find the best, intuitive layout.



Good to hear. I will add a codeline, that will activate the main panel before making the screenshot. So make a test in returning the Commodity panel to your side monitor, when i release the V1.38 beta 1 at weekend.

Side question to all, who had problems with the hotkey function: Did you use 64bit Excel version?

Looks good to me I'm eagerly awaiting the new functionality but as has already been said all in your own time.

 

[Pyke]

I modify the .ini file with = key. It works. I use 64bits version of Excel.

 

[Bragolatch]

There is something weird happening with stations being both unregisted and registered.

I've been deleting the unregistered ones when I have a duplicate but TCE doesn't really update until I shut it down and restart it !

It's probably not a current bug but something from my fixed db.

I'll report again if it turns out to be more then that.

It worked for most of them but one got stuck even thought I used the same actions for all of them !

Keltim Tomita Hub


appears twice in destination :


but is not in the unregistered station list :





Any Idea what would be the best/safest way to remove the duplicate ?
I guess I could just leave it there but I'm afraid it might cause more problems later !



Also, no big deal, but here is another instance where long station names overlap other information:




I wonder how hard it would be to program something similar to windows help bubble.
So we would see only what fits in the box until we'd put our mouse over it,
Then a "bubble" would extend the box to show the full text over everything else
but it would go back to the partial version as soon as we would move the mouse away.


Possible ???

 

[Distance]

I keep getting crashed when I enter lugh.

Runtime error 9

Debug :

Panel_Menu_top.DES_Distance.Caption = Ar_DBRegStations(ActualStationID, 11) & " LS"

When I loaded it from Lugh i got this debug :

If Worksheets("DB_Config").Cells(2, 15).Value = True Then

 

[eventure]

It worked for most of them but one got stuck even thought I used the same actions for all of them !

Keltim Tomita Hub
appears twice in destination

Yep, its not up-to-date as it should. A restart should fix this for the moment, but will be fixed in next update.

Also, no big deal, but here is another instance where long station names overlap other information:

I wonder how hard it would be to program something similar to windows help bubble.
So we would see only what fits in the box until we'd put our mouse over it,
Then a "bubble" would extend the box to show the full text over everything else
but it would go back to the partial version as soon as we would move the mouse away.

Yes, but i will enlarge the panel to fix this. Maybe it makes into the next update, but could be later.

I keep getting crashed when I enter lugh.

Runtime error 9

Previously noted, fixed in next update

When I loaded it from Lugh i got this debug :

Its the codeline for database backup at start. What is the error message? And please show me the full code block, thats a little bit short.

 

[Bragolatch]

Yep, its not up-to-date as it should. A restart should fix this for the moment, but will be fixed in next update.

That is the problem, when I deleted the other unregistered doubles, I had to restart to get them to disappear.

But I've restarted several time since deleting this station and it is still there !

I have no unregistered station left for that system.

But I still have 2 Keltim Tomita Hub

 

[Distance]

Its the codeline for database backup at start. What is the error message? And please show me the full code block, thats a little bit short.

I've not been able to replicate it but if I do I'll post it, cheers

 

[eventure]

That is the problem, when I deleted the other unregistered doubles, I had to restart to get them to disappear.

But I've restarted several time since deleting this station and it is still there !

I have no unregistered station left for that system.

But I still have 2 Keltim Tomita Hub

Understood, i am working on that at the moment, some completely new routines to set up position and destination(reg and unreg) stations. It takes me deep into TCE, so an update today will be not possible.

 

[Bragolatch]

Understood, i am working on that at the moment, some completely new routines to set up position and destination(reg and unreg) stations. It takes me deep into TCE, so an update today will be not possible.

I'll just leave it there for now, we can use it to test your new routines when they are ready.

No stress, I think you are already doing more then is humanly possible !

and TCE is actually pretty stable already, it minor bugs and improvements from now on

Unless you decide to redesign the hole thing from the ground up lol

 

[RichardT]

Hi,

After starting ED and then TCE I always receive an Error 1004 on first startup of TCE.

After shutting TCE down and restarting everything starts and works as expected.

This is the debug code I receive when the error occurs.

Ar_DBStars = Worksheets("DB_Stars").Range("A2:G" & AzStars + 1)
Ar_DBRegStations = Worksheets("DB_Stations").Range("A2:Q" & AzRegStations + 1)
Ar_DBURegStations = Worksheets("DB_Stations_UR").Range("A2:Q" & AzURegStations + 1)
Ar_DBPrices = Worksheets("DB_StPrices").Range("A2:F" & AzPrices + 1)
Ar_DBGoods = Worksheets("DB_Goods").Range("A2:F" & AzGoods + 1)
Ar_DBCategory = Worksheets("DB_Category").Range("A2:B" & AzCategory + 1)
Ar_DBEconomy = Worksheets("DB_Economy").Range("A2:G" & AzEconomy + 1)
Ar_DBJurisdiction = Worksheets("DB_Jurisdiction").Range("A2:B" & AzJurisdiction + 1)
Ar_Type = Worksheets("DB_Stationtype").Range("A2:C" & AzType + 1)

The AR_DBstars line is highlighted.

Cheers.

 

[eventure]

Hi,

After starting ED and then TCE I always receive an Error 1004 on first startup of TCE.

After shutting TCE down and restarting everything starts and works as expected.

This is the debug code I receive when the error occurs.

Ar_DBStars = Worksheets("DB_Stars").Range("A2:G" & AzStars + 1)
Ar_DBRegStations = Worksheets("DB_Stations").Range("A2:Q" & AzRegStations + 1)
Ar_DBURegStations = Worksheets("DB_Stations_UR").Range("A2:Q" & AzURegStations + 1)
Ar_DBPrices = Worksheets("DB_StPrices").Range("A2:F" & AzPrices + 1)
Ar_DBGoods = Worksheets("DB_Goods").Range("A2:F" & AzGoods + 1)
Ar_DBCategory = Worksheets("DB_Category").Range("A2:B" & AzCategory + 1)
Ar_DBEconomy = Worksheets("DB_Economy").Range("A2:G" & AzEconomy + 1)
Ar_DBJurisdiction = Worksheets("DB_Jurisdiction").Range("A2:B" & AzJurisdiction + 1)
Ar_Type = Worksheets("DB_Stationtype").Range("A2:C" & AzType + 1)

The AR_DBstars line is highlighted.

Cheers.

Please install the Access Runtime for your Excel version, look under prerequistites for the download link.

 

[RichardT]

Please install the Access Runtime for your Excel version, look under prerequistites for the download link.

Yes, Already done that but after further testing it may have something to do with setting the hide interface button to F5. Setting it to Right Control made it worse, could not get past the error until I fixed up the ini file, then started no problems. Will do further testing with various other keys set.

Cheers,
Richard.

Just to add, setting it to * key starts up first time, bit strange I know.

 

[Distance]

Here's the debug from starting in Lugh (line that was highlighted is bold) :

Sub Chk_distance_UR()

Dim SX As Double, SY As Double, SZ As Double, ZX As Double, ZY As Double, ZZ As Double, SID As Long, ZID As Long, z As Long, SZD As Double, ArDistance(1 To 50000) As Double
' Dim t As Double
' t = Timer
' MsgBox Timer - t & " sec", , "Makrolaufzeit"

If ActualStarID = 0 Then
SID = Worksheets("Werte").Cells(2, 2).Value
Else
SID = ActualStarID
End If

SX = Ar_DBStars(SID, 3)
SY = Ar_DBStars(SID, 4)
SZ = Ar_DBStars(SID, 5)

For z = 1 To AzURegStations
ZID = Ar_DBURegStations(z, 17) ' Ziel Stern
ZX = Ar_DBStars(ZID, 3)
ZY = Ar_DBStars(ZID, 4)
ZZ = Ar_DBStars(ZID, 5)
ArDistance(z) = Round(Sqr(WorksheetFunction.Power((SX - ZX), 2) + WorksheetFunction.Power((SY - ZY), 2) + WorksheetFunction.Power((SZ - ZZ), 2)) + 0.000001, 2)
Next z
With Application.WorksheetFunction
Worksheets("Pre_Select_UR").Range("I2:I" & Worksheets("Werte").Cells(39, 3).Value + 1) = .Transpose(ArDistance)
End With

End Sub

 

[Martin Lauridsen]

I keep getting 1004 error now after i made the mistake installing MS Access, so i tried the install of AccessRuntime_x64_en-us.exe did not work either, tried uninstalling MS Access and did not help either

Anyone know what i need to do now ?


ARRF i was unable to post a picture cause of spam filter

 

[eventure]

I keep getting 1004 error now after i made the mistake installing MS Access, so i tried the install of AccessRuntime_x64_en-us.exe did not work either, tried uninstalling MS Access and did not help either

Anyone know what i need to do now ?


ARRF i was unable to post a picture cause of spam filter

Perhaps you should uninstall office completely and adds too. Install it again, till it is up-to-date.

 

[Martin Lauridsen]

Perhaps you should uninstall office completely and adds too. Install it again, till it is up-to-date.

Ah yeah forgot to say that i also tried that, and then i had to update officer 2013 completely again around 2200 mb updates, and did not work

And at the same time i installed TCE at the same time.

 

[eventure]

Ah yeah forgot to say that i also tried that, and then i had to update officer 2013 completely again around 2200 mb updates, and did not work

And at the same time i installed TCE at the same time.

Hmm.... how about going back to a restore point, otherwise its difficult to say, where your problem lie. Sorry.

 

[Bragolatch]

Ah yeah forgot to say that i also tried that, and then i had to update officer 2013 completely again around 2200 mb updates, and did not work

And at the same time i installed TCE at the same time.

A problem I had when I first started with this is that you can't run multiple version of Office on the same OS.
And you can't run any mix of x86 and x64.

I actually had to reformat to fix the problems once I had installed office 2007 on the same windows as office 2013.
No amount of un-installing was able to clean up the registry properly.

So, hopefully you have save those update files somewhere safe !

It might be a great time to do a major spring cleaning to your hard drive.

Reformatting is not as hard or time consuming as it use to be and it will speed up you pc some
if you don't re-install all the crap you don't need right away lol

Good Luck and don't forget to back up your ED folder if you don't want to have to re-download it, and it's two folders under:

C:\Users\**YOUR NAME**\AppData\Local

 

[Martin Lauridsen]

Restore point i newer use, so cant go back any steps (i figured you meant Windows restore point)

And its under 14 days since i last did a reinstall of win, but well might have to to that again then.
Or try first uninstall MS Office again and then clean my registery with a program and hope it can get rid of unwanted stuff.