Horizons Prospector Log-Materials
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKAL
1
Horizons Prospector Log - Materials and PPOI (The Monster)
To View Summaries and Analysis of the data entered here, please use one of the links below
Some background facts:
2
The document is the data entry point and source of many other analysis applications. Please do contribute dataIn Depth Data Analysis - Here
3
1) Start by opening the Systems sheet, scroll to the bottom and add a new System. Skip to 2 if done already.Distant Worlds Expedition Material Lists - HereMount Everest Elevation:8848 m
4
Canonn Material and PPOI - Materials for those in the BubbleMount Fuji: 3766 m
5
2) Next open the Worlds spreadsheet, scroll to the bottom, select the System you just added, and add the Body in that system that you intend to land on. Skip to 3 if already done.To Import From This Sheet (With More Data) - HereMariana Trench:Length: 2550 km
6
Avg. Width: 69 km
7
3) Open the Surveys sheet, scroll to the bottom and add your system to your Survey entry, completing any interesting info on your landing zone, e.g. terrain type, terrain colour, etc. (for definition of terrain type names see the Ranges worksheet).Flow Chart Explaining Where Everything Is - HereDepth: 10994 m
8
9
4) Choose the Survey ID in the log and start adding entries (You should only need maximum of 5 lines pr. survey, one pr. source type, e.g. metallic meteorite etc.) If you copy and paste into the log, please paste special >> values only.For when doing "fast" prospecting, i.e. only recording elements pr. planet; please use the "BINARY" source option so this can be separated when making statistic.
10
11
Please use the options in the top right to request Write Access quoting your CMDR Name
12
13
CMDR Eoran
14
15
NOTE: a) Any grey cells are auto-generated, so it's best not to enter data there directly, and b) the extent of the formula may need to be copied down to other cells as more data is added.
16
17
To add surface calculation:
18
19
Follow steps 1) to 3)
20
Record Distance from Sol:
65 373.72 Ly
21
i) Go to Surface Log worksheet and choose the Survey ID.CMDRs, it has come to our attention that to futher contribute to this scientific endaviour, this database is in dire need of more data from:
Olympus Mons Elevation:
25 000 m
22
Grand Canyon Depth1857 m
23
ii) Add coordinates from first position (latitude and longitude, displayed above gravity) as well as angle from current position to your next planned position (this is not required if you don't want the height difference).Surface Type:Rocky Ice WorldEarth-Sol Distance:500ls
24
Terrain Type:Chasm
25
iii) Go to the next plannet position and record position coordinates there as well. The length between the positions and heigh difference should now be calculated.Reserve Type:Depleted
26
27
iv) For a second length measurement use the next pair of coordinate pairs. E.g. if the first measurements were of the width and height of a vallis, the last measurement could be of its length.
28
Overview of skew of data:
29
Surface Type:
30
Change LogMetal RichHigh Metal ContentRocky WorldIcy WorldRocky Ice World
31
Dommarraa : Fixed the Graph to Pick up values for Yttrium11/12/201511.94%38.96%24.23%21.30%3.36%
32
33
Nexolek: Added star class and age to Worlds sheet (and a ton of data)12/12/2015
34
35
Eoran: Added Lat/Long coordinate columns to Survey sheet12/12/2015
36
37
Rutherford: Added: background facts, surface log, world paramteres, calculation of albedo, system parameteres, calculation of inner and outer CHZ (Goldilocks zone), added constants sheet for calculations, changed terrain types to established scientific definitions12/12/0215
38
39
Rutherford: Added a new sheet based on the Materials sheet, but that compares number of materials vs. terrain type13/12/2015
40
41
Inga Stevenson: Added borders between the rarity types on the log sheet.13/12/2015
42
43
Rutherford: Added explanation of Surface Log, Fixed yttrium not being included when calculating sum in Materials, added chart for distribution vs. terrain type, added note on requirements on some of the calculated quantities.13/12/2015
44
45
Rutherford: Hypothesis of an error in the calculation of distributions. Corrections will follow.14/12/2015
46
47
Dommaarraa : Started the DWELocations Range so Systems at Way points can be easily identified
48
Dommaarraa : Added Surface Distribution. it is just Distribution by Surface Type pivoted. Allows you to identify target planet types for your hunting of specific materials, unbiased by the hunt profile.
49
Terrain Type:
50
Rutherford: Fixed Distribution by Surface Type chart and Distribution by Terrain Type to give distribution of materials and conditional probabilities of classes. Note that for this not to be biased the probabilites of different classes has to be equal.CraterValleyChasmPlain
Hilly / Mountainous
51
10,191.003,725.001,947.0024,370.006,395.00
52
Rutherford: Fixed calculation in Surface Log to be able to use longitude and latitude and the canonical angle convention. Fixed worlds column in survey sheet to not show NA. Added "In CHZ" column in worlds sheet to conveniently see if the world is in the Goldilocks zone. Added "Beige" to Terrain Hue range. Added "Ideal Jump" and "Good Jump" columns to Log worksheet which scans each row to see if it contains the 5 rarest and 3 rarest materials used in Jumponium respectively. Note that this is not a replacement for going throught the entries manually since it doesn't take into account if some of the necessary materials are hidden in different rows.It is Mary.
53
54
Rutherford: Fixed the Ideal Jump and Good Jump to look for all rows with world name. Now this search replaces manual search. Also changed them to work as stated in notes.17/12/2015
55
56
Rutherford: Restored earlier version after massive deletion of system worksheet. Re-inserted data inserted after deletion.19/12/2015
57
58
Rutherford: Added a new worksheet called "Rarity given Source Type" to try to analyse what the probability of a given rarity e.g. "Very Rare" is given that the planet has a given Source Type, e.g. "Metallic Meteorite". This also filters by Terrain Type and Surface Type since these variables are expected to influence the probability distribution.20/12/2015
59
60
Rutherford: Added a couple of tables and streamlines the formulas in the Rarity sheet. Changed the sheets formatting for easier distinction between tables by adding borders and removing colour in between tables. Stilll not enough data to control for Surface Type, terrain type and reserve.20/12/2015
61
62
Rutherford: Added protection to sheetes and columns that should not be edited when inserting new data so that it will show a warning if someone tries to do this (but you can still do it), so that it's less probable to edit automatically generated formulas by mistake.20/12/2015
63
64
Nexolek: Cleaned up many single node entries. There should only be a max of 5 per survey - one for each node type.21/12/2015
65
66
Dommaarraa : Shopping List Template Added - Enter your required number of each charges and you current cargo, will tell you want you need to hunt for. Please Duplicate the Sheet to store your own values21/12/2015
67
68
Rutherford: Added an overview of how skewed the data is. We would like all the bars in the charts to be equal.21/12/2015
69
70
Rutherford: Added a records worksheet that has an overview of various records from the data21/12/2015
71
72
Rutherford: Added some missing data that dissapeared after the revision and corrected some of the entries of Andrew Gespurr that seemed to not reference the planet correctly.22/12/2015
73
Reserve Type:
74
Dommaarraa : Worlds now has Materials Totals and %s. Might be a better source of Jumponium lookup that the big lookups on the Log Page24/12/2015N/ADepletedLowCommonMajorPristine
75
64.52%1.57%4.17%5.79%9.81%14.14%
76
Nexolek: Formatting cleanup in the Log sheet. Added 3/2/1 check.25/12/201532288784208828984909707950046
77
78
Alex Traut: Corrected some bad date data, mostly 2015 entered as 2016. Also, please don't enter secondary stars as their own system. This screws up the data and makes it impossible to programmatically extract the actual system name.27/12/2015
79
80
Nexolek: Added all DW waypoints and updated named range. Added column for distance to waypoint in Systems sheet. Log sheet will now show waypoint and distance to it, if added.
Fixed two broken surveys. Removed two duplicate systems (Fine Ring Sector IR-W D1-141 & HR 6421).
28/12/2015
81
82
Nexolek: Added Arrival Point to Worlds sheet and cleaned up a couple of world names.02/01/2016
83
84
Nexolek / Michael Darkmoor: Added coordinate calculations for distance from Sol and DW Waypoints. Constants updated with waypoint coordinates. Those that are still unannounced will be updated when we know exactly which system they are.02/01/2016
85
86
Dommaarraa : fixed the material summary on planets sheet, someone had inserted a column
87
88
Nexolek: Summary on Worlds sheet no longer misbehaves if columns are added. The errors have been banished as well.03/01/2016
89
90
Michael Darkmoor: Completed back-filling all system coordinates for systems in sheet to date09/01/2016
91
92
Michael Darkmoor: Added "Totals" page and began populating summary totalsĀ for certain data points (Stars, Planets, Rocks) 19/01/2016
93
94
Rutherford: Changed to easier terrain type definitions. Set the previous definitions to a range called AdvTerrainTypes. Deleted Distribution by Terrain Type and surface type charts since they were misleading because of biases. Edited Materias / Terrain and added filtering to eliminate biases as well as charts to compare different terrain types. Added source type chart to help to see this bias.21/01/2016
95
96
Rutherford: Updated the records tab to account for multiple entries with the same record value. Added a chart in the vein of Janichsan to Materials tab.21/01/2016
97
98
Rutherford: Created a binary source type, for people who only wants to insert if a material exists on a world or not.22/01/2016
Source Type:
99
Metallic Meteorite
Mesosiderite
Bronzite Chondrite
Outcrop 1Outcrop 2
100
Nexolek: Some housecleaning. Removed blank lines and combined unnecessary lines in Log sheet.23/01/2016931516704606065218917
Loading...
Main menu