X3TC Stats and Resources Compendium V3.3.1 (28/09/2011) - links live again
Moderator: Moderators for English X Forum
There isn't a list in the spreadsheet.pamme wrote:...is there a list of "Suns" or solar yield per sector?
I would use Xadrian for this: http://forum.egosoft.com/viewtopic.php?t=239659
When you start Xadrian. click to select a sector, select the view mode as 'suns' and you will have a map of the sun percentages.
Win10 Home 64-bit, Intel i7-9750H @ 2.6GHz. NVidia GeForce RTX 2070 (8 GB). 16 GB ram.
Click on select sector.Kwaio wrote:Thanks for this tool, never found anything that usefull
Only thing missing : Sun coverage of sectors on the map.
You get a map.
Top right hand selection box "View Mode"
Select "suns"
The map is then color-coded to show %age of sun.
Put cursor over any sector that looks interesting
It will tell you basic sector information
Name
grid reference
Race ownership
Sun %age
Silicon yield per roid
Ore yield per roid.
There are other options there too , such as showing which sectors have the most silicon , if you select silicon instead of suns
Yes I broke the VBA code in V3.3 so those sort buttons didn't work.Tarthrin wrote:I can't seem to get the columns to sort properly.
I can sort ships by "Race" but it won't let me sort by "Speed" or "Cargo"
I am using excel 2007 and have macros enabled. Am I missing something?
Fixed in this version (3.3.1).
Win10 Home 64-bit, Intel i7-9750H @ 2.6GHz. NVidia GeForce RTX 2070 (8 GB). 16 GB ram.
- SkullCowboy
- Posts: 137
- Joined: Mon, 23. Aug 10, 01:37
- nponoBegHuk
- Posts: 474
- Joined: Thu, 6. Mar 08, 19:55
Shall you decide to include DLC Harmony of Perpetuity sector to your map, the shortcuts are W^^^ or EEE^ (among others, less useful ones).
Last edited by nponoBegHuk on Sat, 1. Oct 11, 13:38, edited 1 time in total.
Fast sector selection on the Universe Map | Rock locations for Mobile/OOS mining | Botting for max speed Hyperion | Complete list of ship sources | Capturing smaller ships
My current ship collection:
11 out of 11 *retired* ships found
17 out of 17 *unique* ships found
9 out of 9 *limited* ships found
16 out of 16 *rare* ships found
My current ship collection:
11 out of 11 *retired* ships found
17 out of 17 *unique* ships found
9 out of 9 *limited* ships found
16 out of 16 *rare* ships found
-
- Posts: 595
- Joined: Tue, 13. Jul 04, 13:03
- nponoBegHuk
- Posts: 474
- Joined: Thu, 6. Mar 08, 19:55
erm.... yep, thanks, typo correctedblackfire83 wrote:Isn't it Harmony of Perpetuity?
Fast sector selection on the Universe Map | Rock locations for Mobile/OOS mining | Botting for max speed Hyperion | Complete list of ship sources | Capturing smaller ships
My current ship collection:
11 out of 11 *retired* ships found
17 out of 17 *unique* ships found
9 out of 9 *limited* ships found
16 out of 16 *rare* ships found
My current ship collection:
11 out of 11 *retired* ships found
17 out of 17 *unique* ships found
9 out of 9 *limited* ships found
16 out of 16 *rare* ships found
- SkullCowboy
- Posts: 137
- Joined: Mon, 23. Aug 10, 01:37
- TheRealBix
- Posts: 400
- Joined: Thu, 2. Jul 09, 14:34
On the Open Office version, your coding for player and race ranks does not work. I was able to fix it by putting
in cell B37 and copying that to D37, as well as using data validation based on a cell range from the above named ranks on B36 and D36. I also did something similar (range was smaller) on the Race Ranks page to fix that as well.
As it sits now you have a drop down menu to select the rank and then you enter the numerical % as you progress through the rank below it.
Just thought that I might help you out with Open Office work here. I do think though that the MATCH function works the same in Excel, though I do not have Excel here to verify.
Code: Select all
=MATCH(B36;B3:B33;0)
As it sits now you have a drop down menu to select the rank and then you enter the numerical % as you progress through the rank below it.
Just thought that I might help you out with Open Office work here. I do think though that the MATCH function works the same in Excel, though I do not have Excel here to verify.
-
- Posts: 84
- Joined: Mon, 13. Feb 12, 08:22
I am just starting out in X3, playing humble trader for my first playthrough. I have a couple questions.
1. Is it possible to save a single sheet (or just 2-4) as a seperate spreadsheet? This spreadsheet is massive, and has tons of useful information, but if I just wanted to look at the wares or resources sheet, it takes a minute to load. I am using LibreOffice, if it makes any difference.
2. Is there a way on the wares or resources sheet, to enter my maximum cargo space, and then have it tell me how much I would get for a full cargo hold of each item (assuming buy at minimum and sell at maximum) I don't know how to use spreadsheets or formulas.
I have been using a calculator and doing 3000 (cargo space) / volume of item = # of items I can hold, and then multiplying that by difference cell on the resources sheet. Anyway to make the spreadsheet do that for me?
Thank you for the awesome spreadsheet.
1. Is it possible to save a single sheet (or just 2-4) as a seperate spreadsheet? This spreadsheet is massive, and has tons of useful information, but if I just wanted to look at the wares or resources sheet, it takes a minute to load. I am using LibreOffice, if it makes any difference.
2. Is there a way on the wares or resources sheet, to enter my maximum cargo space, and then have it tell me how much I would get for a full cargo hold of each item (assuming buy at minimum and sell at maximum) I don't know how to use spreadsheets or formulas.
I have been using a calculator and doing 3000 (cargo space) / volume of item = # of items I can hold, and then multiplying that by difference cell on the resources sheet. Anyway to make the spreadsheet do that for me?
Thank you for the awesome spreadsheet.
All - I'm all spreadsheeted out. I'm currently playing other games until X Rebirth comes along and I've not even tried X3AP.
So,
'TheRealBix' - No plans to create an AP version.
'Zippo342' - If you want to update the spreadsheet for a specific Open Office version and email it to me I'll add it here - message me.
'SkullCowboy' - If I get the above update I'll update the other versions for your correction.
'RustInPieces' - Can't you just delete the sheets you don't want and save as another file name? The full cargo addition sounds easy enough just using the spreadsheet formulas but I guess you are not familiar with them - difficult to explain here. Again I'll take a look if I'm making other updates.
So,
'TheRealBix' - No plans to create an AP version.
'Zippo342' - If you want to update the spreadsheet for a specific Open Office version and email it to me I'll add it here - message me.
'SkullCowboy' - If I get the above update I'll update the other versions for your correction.
'RustInPieces' - Can't you just delete the sheets you don't want and save as another file name? The full cargo addition sounds easy enough just using the spreadsheet formulas but I guess you are not familiar with them - difficult to explain here. Again I'll take a look if I'm making other updates.
Win10 Home 64-bit, Intel i7-9750H @ 2.6GHz. NVidia GeForce RTX 2070 (8 GB). 16 GB ram.
-
- Posts: 2
- Joined: Sun, 26. Aug 07, 01:04
Seriously, from someone who "over indulged" on adjusting their T/files without making a vanilla backup of them, I thank you from the bottom of my Engine capacitors for taking the time and labour to make this.
It has saved me considerable time and frustration to restore alot of stats back to their correct settings.
It has saved me considerable time and frustration to restore alot of stats back to their correct settings.