Monster spreadsheets has been linked to OP for completness. List will be updated later or tomorrow.
[DISTANT WORLDS] Cartographic & Prospecting Public Service
- Thread starter CMDR AKIRA MASAKARI
- Start date
- Status
Thank you SO much for this! I've duplicated those particular sheets into my own Exploration Sheet and modified the links so the functions work.
BTW, you can specify a range in Google Sheet.
Instead of =counta(A1,B1,C1,D1,E1) you could use =counta(A1:E1)
You have a lot of cell concatenation going on, so I thought it would make things simpler if it used ranges instead.
Oh yeah, how do you copypasta the table from the Forum Export sheet into the forum and maintain the formatting?
Thx for the tips, I didn't think of it while doing it
You simply copy the whole table and paste it in the post. In advanced mode I increase width to 1200 and surround it with border.
Ohoho! I can see this being VERY useful!
I've extended the functionality by taking the table on "Forum Export" and adding the following to cell U2. I then copied it into the whole column U.
It checks that there is a planet identifier entered in column F and displays the BBcode for the table row with the cells populated with the data.
All you need to do is create the table in Advanced edit, then copy the rows in column U that you want to paste between the TABLE /TABLE tags.
It's too late to do it tonight, but instead of 2 sheets (Work & Forum export) I'll see if I can compress the extraction, formatting and output into a single cell per row to copy directly to the forum from the "Work" sheet.
I've extended the functionality by taking the table on "Forum Export" and adding the following to cell U2. I then copied it into the whole column U.
Code:
=if(F2<>"","[tr][td][/td][td]"&C2&"[/td][td]"&D2&"[/td][td]"&E2&"[/td][td]"&F2&"[/td][td]"&G2&"[/td][td]"&H2&"[/td][td]"&I2&"[/td][td]"&J2&"[/td][td]"&K2&"[/td][td]"&L2&"[/td][td]"&M2&"[/td][td]"&N2&"[/td][/tr]","")All you need to do is create the table in Advanced edit, then copy the rows in column U that you want to paste between the TABLE /TABLE tags.
It's too late to do it tonight, but instead of 2 sheets (Work & Forum export) I'll see if I can compress the extraction, formatting and output into a single cell per row to copy directly to the forum from the "Work" sheet.
| 287.99ly from NGC 6530 WFI 16706 | NGC 6530 CDZ 114 | B | 1 A | Rocky | 0.23G | 1605.12ls | Vanadium Arsenic , no premium boost | NO | NO | NO | ||
| B | 2 | HMC | 1.3G | 1642.71ls | Niobium Vanadium Germanium , no premium boost | YES | NO | NO | ||||
| B | 3 E | Rocky | 0.26G | 2086.6ls | Niobium Vanadium Arsenic , no premium boost | NO | NO | NO | ||||
| 283.02ly from NGC 6530 WFI 16706 | NGC 6530 CDZ 32 | B, B | AB 9 A | Metal Rich | 0.33G | 2041.83ls | Niobium Germanium | VR | NO | NO | NO | |
| 269.12ly from NGC 6530 WFI 16706 | NGC 6530 CDZ 80 | B, B | 2 | Rocky | 1.08G | 529.2ls | Niobium Arsenic | VR | NO | NO |
Last edited:
| 28LY from Herschel 36 | Lagoon Sector BQ-Y D137 | F, F | A1 (Metal Rich) (43LS) (0.94G) A2 (HMC) (76LS) (0.79G) A3 (HMC) (132LS) (1.03G) A4 (HMC) (222LS) (1.05G) A7A (Rocky) (1961LS) (0.11G) A7B (Rocky) (1960LS) (0.14G) A7C (Rocky) (1966LS) (0.13G) A7D (Rocky) (1954LS) (0.12G) | Arsenic Polonium Cadmium, Polonium Vanadium, Germanium, Niobium Germanium, Cadmium, Niobium, Yttrium Arsenic, Vanadium, Yttrium Germanium, Vanadium Arsenic, Niobium |
Thanks a lot, I've put order in the list following your suggestions and now the entry should be complete and accurate. I've added a pic of a wing prospecting there for the sake of it.
Tonigh i rock ratted too, from prospecting side an horrible entry, but a nice superficial feature I will post in next update.
Update is incomplete yet
70 LY from Herschel 36 / CD-24 13837 / B, NS, NS, NS / ABCD1 (Icy) (2g) (16170LS)
Huge Sunflower Crater with thick mist at the bottom @ roughly -10/20 in a TRIPLE NS SYSTEM
We have fully prospected the planet, only to find Niobium and nothing else interesting for jump mats.
CMDRs Eisen, Anuranium, Myshka, Akira Masakari.
Huge Sunflower Crater with thick mist at the bottom @ roughly -10/20 in a TRIPLE NS SYSTEM
We have fully prospected the planet, only to find Niobium and nothing else interesting for jump mats.
CMDRs Eisen, Anuranium, Myshka, Akira Masakari.
Last edited:
Ohoho! I can see this being VERY useful!
I've extended the functionality by taking the table on "Forum Export" and adding the following to cell U2. I then copied it into the whole column U.
It checks that there is a planet identifier entered in column F and displays the BBcode for the table row with the cells populated with the data.Code:=if(F2<>"","[tr][td][/td][td]"&C2&"[/td][td]"&D2&"[/td][td]"&E2&"[/td][td]"&F2&"[/td][td]"&G2&"[/td][td]"&H2&"[/td][td]"&I2&"[/td][td]"&J2&"[/td][td]"&K2&"[/td][td]"&L2&"[/td][td]"&M2&"[/td][td]"&N2&"[/td][/tr]","")
All you need to do is create the table in Advanced edit, then copy the rows in column U that you want to paste between the TABLE /TABLE tags.
It's too late to do it tonight, but instead of 2 sheets (Work & Forum export) I'll see if I can compress the extraction, formatting and output into a single cell per row to copy directly to the forum from the "Work" sheet.
287.99ly from NGC 6530 WFI 16706 NGC 6530 CDZ 114 B 1 A Rocky 0.23G 1605.12ls Vanadium Arsenic , no premium boost NO NO NO B 2 HMC 1.3G 1642.71ls Niobium Vanadium Germanium , no premium boost YES NO NO B 3 E Rocky 0.26G 2086.6ls Niobium Vanadium Arsenic , no premium boost NO NO NO 283.02ly from NGC 6530 WFI 16706 NGC 6530 CDZ 32 B, B AB 9 A Metal Rich 0.33G 2041.83ls Niobium Germanium VR NO NO NO 269.12ly from NGC 6530 WFI 16706 NGC 6530 CDZ 80 B, B 2 Rocky 1.08G 529.2ls Niobium Arsenic VR NO NO
Will update this tomorrow, thank you very much
That was quite an intense day with Elite yesterday for me, first nearly dying on a 0.16g-moon (Yeah, shame on me), then dashing back to the bubble, meeting with a commander on the way to take his found occupied escape-pods back to the bubble, repaired my ship at HR6241, then picking up some Waters of Shinrarta for our flagship CMDR Olivia Vespera, dashing back and crowning this exceptional day with our meeting on this 2g Icy-World. One of the best days in Elite ever!
Myshka
That was a great system! Even though I very nearly pancaked into CMDR Eisen's ship on approach (did someone say they had a video?) - and this after landing in a nearby system on a 2.56G world without shields.. Please kids, don't fly while sleep-deprived!
Btw, Lagoon Sector BQ-Y d84 which is nearby has an ELW, sorry, forgot to get a system screenshot.
Ohoho! I can see this being VERY useful!
I've extended the functionality by taking the table on "Forum Export" and adding the following to cell U2. I then copied it into the whole column U.
It checks that there is a planet identifier entered in column F and displays the BBcode for the table row with the cells populated with the data.Code:=if(F2<>"","[tr][td][/td][td]"&C2&"[/td][td]"&D2&"[/td][td]"&E2&"[/td][td]"&F2&"[/td][td]"&G2&"[/td][td]"&H2&"[/td][td]"&I2&"[/td][td]"&J2&"[/td][td]"&K2&"[/td][td]"&L2&"[/td][td]"&M2&"[/td][td]"&N2&"[/td][/tr]","")
All you need to do is create the table in Advanced edit, then copy the rows in column U that you want to paste between the TABLE /TABLE tags.
It's too late to do it tonight, but instead of 2 sheets (Work & Forum export) I'll see if I can compress the extraction, formatting and output into a single cell per row to copy directly to the forum from the "Work" sheet.
287.99ly from NGC 6530 WFI 16706 NGC 6530 CDZ 114 B 1 A Rocky 0.23G 1605.12ls Vanadium Arsenic , no premium boost NO NO NO B 2 HMC 1.3G 1642.71ls Niobium Vanadium Germanium , no premium boost YES NO NO B 3 E Rocky 0.26G 2086.6ls Niobium Vanadium Arsenic , no premium boost NO NO NO 283.02ly from NGC 6530 WFI 16706 NGC 6530 CDZ 32 B, B AB 9 A Metal Rich 0.33G 2041.83ls Niobium Germanium VR NO NO NO 269.12ly from NGC 6530 WFI 16706 NGC 6530 CDZ 80 B, B 2 Rocky 1.08G 529.2ls Niobium Arsenic VR NO NO
Hi Zenith, feel free to do what you want with it, if you want I can create edit rights for you, if you want to share idea's and stuff.
The most important missing feature for me right now is an auto export to the monster sheet.
Been thinking on how to approach that.
Could make Excell sheet for it. Not made up my mind yet.
Since there is also EDSM which acts as a database and has an API. How do EDSM and monster sheet relate in future ? No clue.
They're working on it! The prospecting section of EDDiscovery is going to pull from the monster sheet in the future...um, Soon™. Not sure if it's going to tie in to EDSM, but they have something worked out for storing that information in an online database. Finwen and Marlon Blake have been working on it (as far as I know at least). Very excited for that!
Few more hits from the monster:
| 14.07ly from Herschel 36 | NGC 6530 CDZ 199 | A | 2 A | Rocky World | 0.12g | Niobium Germanium Vanadium | J1 | |
| 14.17ly from Herschel 36 | NGC 6530 WFI 16706 | M | A 4 F | Icy World | 0.16g | 1,884.00ls | Yttrium Cadmium Germanium Arsenic | Yttrium+3 |
| 14.17ly from Herschel 36 | NGC 6530 WFI 16706 | M | A 5 C | Icy World | 0.08g | 1,742.00ls | Cadmium Germanium Vanadium | J1 |
Last edited:
Nice find Nexolek ! A +3 Yttrium!
Name corrected!!!!! I have a vid but it's not very good, I'll try to edit just for the record!Myshka
That was a great system! Even though I very nearly pancaked into CMDR Eisen's ship on approach (did someone say they had a video?) - and this after landing in a nearby system on a 2.56G world without shields.. Please kids, don't fly while sleep-deprived!
Btw, Lagoon Sector BQ-Y d84 which is nearby has an ELW, sorry, forgot to get a system screenshot.
Thanks a lot Zenith! I would remeber you that reference system to calculate distance from is different from campbase, and for lagoon nebula is herschel 36. I've put your findings without distance in the bottom of the tableOhoho! I can see this being VERY useful!
I've extended the functionality by taking the table on "Forum Export" and adding the following to cell U2. I then copied it into the whole column U.
It checks that there is a planet identifier entered in column F and displays the BBcode for the table row with the cells populated with the data.Code:=if(F2<>"","[tr][td][/td][td]"&C2&"[/td][td]"&D2&"[/td][td]"&E2&"[/td][td]"&F2&"[/td][td]"&G2&"[/td][td]"&H2&"[/td][td]"&I2&"[/td][td]"&J2&"[/td][td]"&K2&"[/td][td]"&L2&"[/td][td]"&M2&"[/td][td]"&N2&"[/td][/tr]","")
All you need to do is create the table in Advanced edit, then copy the rows in column U that you want to paste between the TABLE /TABLE tags.
It's too late to do it tonight, but instead of 2 sheets (Work & Forum export) I'll see if I can compress the extraction, formatting and output into a single cell per row to copy directly to the forum from the "Work" sheet.
287.99ly from NGC 6530 WFI 16706 NGC 6530 CDZ 114 B 1 A Rocky 0.23G 1605.12ls Vanadium Arsenic , no premium boost NO NO NO B 2 HMC 1.3G 1642.71ls Niobium Vanadium Germanium , no premium boost YES NO NO B 3 E Rocky 0.26G 2086.6ls Niobium Vanadium Arsenic , no premium boost NO NO NO 283.02ly from NGC 6530 WFI 16706 NGC 6530 CDZ 32 B, B AB 9 A Metal Rich 0.33G 2041.83ls Niobium Germanium VR NO NO NO 269.12ly from NGC 6530 WFI 16706 NGC 6530 CDZ 80 B, B 2 Rocky 1.08G 529.2ls Niobium Arsenic VR NO NO
Woot! Another green system!!!!!
I'm starting to think that, as already suggested, if a system has enough bodies it tends to go green. For this reasons the real treasures seems to be the polonium+4 systems and little less the Yttrium+4 systems. Probably is faster to bounch between 2 close systems that have these planets than to go in a gree a system and have to change planet frequently.
Horizon is new, we learn as we go, and nevertheless green systems are always welcome, but red systems (polonium +3 or better) seems to be the more difficult to find.
Going on with updates.
Ohoho! I can see this being VERY useful!
I've extended the functionality by taking the table on "Forum Export" and adding the following to cell U2. I then copied it into the whole column U.
It checks that there is a planet identifier entered in column F and displays the BBcode for the table row with the cells populated with the data.Code:=if(F2<>"","[tr][td][/td][td]"&C2&"[/td][td]"&D2&"[/td][td]"&E2&"[/td][td]"&F2&"[/td][td]"&G2&"[/td][td]"&H2&"[/td][td]"&I2&"[/td][td]"&J2&"[/td][td]"&K2&"[/td][td]"&L2&"[/td][td]"&M2&"[/td][td]"&N2&"[/td][/tr]","")
All you need to do is create the table in Advanced edit, then copy the rows in column U that you want to paste between the TABLE /TABLE tags.
It's too late to do it tonight, but instead of 2 sheets (Work & Forum export) I'll see if I can compress the extraction, formatting and output into a single cell per row to copy directly to the forum from the "Work" sheet.
287.99ly from NGC 6530 WFI 16706 NGC 6530 CDZ 114 B 1 A Rocky 0.23G 1605.12ls Vanadium Arsenic , no premium boost NO NO NO B 2 HMC 1.3G 1642.71ls Niobium Vanadium Germanium , no premium boost YES NO NO B 3 E Rocky 0.26G 2086.6ls Niobium Vanadium Arsenic , no premium boost NO NO NO 283.02ly from NGC 6530 WFI 16706 NGC 6530 CDZ 32 B, B AB 9 A Metal Rich 0.33G 2041.83ls Niobium Germanium VR NO NO NO 269.12ly from NGC 6530 WFI 16706 NGC 6530 CDZ 80 B, B 2 Rocky 1.08G 529.2ls Niobium Arsenic VR NO NO
Thanks CMDR! repped and list is up-to-date!
| 119.03ly away from Omega Sector PD-S b4-0 | PW2010 83 | B, Neutron, Neutron, B, Neutron | CDE 2 | HMC | 2.48G | 76099.73ls | Polonium Cadmium Germanium Arsenic |
https://trello.com/c/8ii5jbBT
Here is your Polonium+3 (you never said anything about LY limitation
)Rock Rats rule
Last edited:
There must be a typo here. The system i've underlined in red it's the same name than basecamp 02, wich is not 195LY from Herschel 36, but 10 or less. So it's either wrong the system name or the distance from Herschel 36
I'd better PM nexolek, not touching the tab untill tomorrow tough
| 15 LY from CL PISMIS 2 | NGC 6357 Sector TJ-Q B5-10 A6 | M | High Metallic,0.15,54 | Carbon, Phosphorus,Sulphur, Nickel,Iron,Germanium,Manganese,Zirconium,Niobium,Tungsten,Yttrium |
| 14.7 from CL PISMIS 2 | NGC 6357 Sector RY-R b4-6 A1 | M | High Metallic,0.13,25 | Carbon, Phosphorus,Sulphur, Nickel,Iron,Germanium,Chromium, Vanadium, Molybdenum,Niobium,Antimony |
Here's some more from the first system I did in NGC and one a bit further across in the other direction. I think that finishes off the close by Planets in NGC 6357 Sector TJ-Q B5-10 and leaves you with a system containing all jump mats (I think!)
- Status