UAs, Barnacles & More Thread 6 - The Canonn

Status
Thread Closed: Not open for further replies.
Still managing the sheet recently entered the IH-V C2-16 system data into it.

I could use some help with conditional formatting however.

I'd like it so that if a planets Surface Temp. falls within the known ranges of barnacles found then highlight the value

Then I would like to apply similar conditions to things like composition

This way explorers can choose planets to search based on how many of these values are highlighted.

As the range increases it could dynamically highlight more candidates for searching.
 
Still managing the sheet recently entered the IH-V C2-16 system data into it.

I could use some help with conditional formatting however.

I'd like it so that if a planets Surface Temp. falls within the known ranges of barnacles found then highlight the value

Then I would like to apply similar conditions to things like composition

This way explorers can choose planets to search based on how many of these values are highlighted.

As the range increases it could dynamically highlight more candidates for searching.

I'll request edit access when I get back to my PC. That's not a difficult highlighter conditional format.
 
Things I still have to do in the is real? world for today.
Send off for a replacement passport, after someone accidentally fired a little wave through it, destroying the identification circuit, burning a few pages and only just missing the owley.
It also needs an up to the minute photo attached because the last time I used it, I looked like I hadn't eated in weeks and as a lone traveler, it was considered inappropriate to let me in.
It didn't help that I was misunderstood when it was suggested I had skipped my medication for two weeks, when what was meant was that I had not been assigned any prescriptions for at least that long (there was a bit of a language barrier going on and I got confused in the excitement of having made it to the aeroport).
Even now, now that I have booked another week's vacation time, I have a pregnant friend, due to give birth in a week and a half or so, an appointment with someone, whom, if they see me incorrectly will declare me unfit to fly and a couple of anniversaries are around the corner taking up a lot of my thinking time.

I get little time to glance at the daily rags to test the state of the nations but I'm getting there! :)
 
Been to Lagoon, Barnard's Loop, Orion, Taurus Dark Region, Witches Head and few more, searching for Barnacles, no such luck, found only UAs at HR 1445. So decided to go to Maia Pleiades to try my luck, was constantly interdicted so I left. I then decided to visit Merope 5c to visit the barnacle found originally. Whilst at the barnacle site with my SRV, I noticed a ship approaching with raised weapons, next thing he was firing at my ship and eventually destroyed it, he then came for my SRV and destroyed it as well, didn't stand a chance! Bit cowardly I thought. Just to warn other players if planning to go to Merope 5c barnacle site, to go with a wing. :(

That Pleiades Nebula is full of joyful griefers is a well known fact. I always play in open and I had to deal with them a couple times.
But an Asp with 2 Class 2 and 2 Class 1 RailGuns, 30% overpowered thanks to materials, plus 2 Class 1 Beams, could easily manage a small griefer ship: I was able to vaporize a wing of two stealth DB Scouts with them.

Against a big ship, high waking is the only chance.

Anyway, situation awareness about surrounding ships in the area, is always a good thing ;)
 
Last edited:
Meanwhile, in my spare time, I am writing a story about how I believe I know where the twin to Maia is located.
In between that and checking up on the status of Agent Foxes' progress at the super special secret awesome espying club under the high school, I've got to keep the big kids distracted with some massive pompom circumstances and sporting events.
Amongst these rambling posts are actual ship status update reports for where I am in-game as I try and reach the hidden treasure chest for a couple of little cherubs I'm watching over (apparently, they rotate!) :p
 
I'll request edit access when I get back to my PC. That's not a difficult highlighter conditional format.

I would need help specifically highlighting an entire row and making a planet a candidate if composition and surface temperature are within known ranges.

I have the formula that highlights a single value if it falls within the range.

=and(and(J10<=indirect("'Compare Barnacle Locations'!L5"), J10>=indirect("'Compare Barnacle Locations'!L6")),H10="Yes")

Basically tests: greater than min temp, Less than Max temp, Landable. If all thee are true then highlight it.

but I'd like it to use normal distribution and allow temps that fall within some Standard Deviation of the mean.

This would encourage people to search outside the known ranges.

Right know people keep a dice blind and have no idea how many sides the dice has. All they know is that so far they've thrown a 2, 3 and a 5... many many times.

But that's not to say a 12 or a 1 won't appear. If that makes sense?

This should be reflected in planet candidacy.

Appreciate the help bro!
 
Last edited:
I tried it for a while now...but am i the only one here who has no idea what Rekah is talking about?
Is there a "story" behind all the random stuff?

Well, it's "slightly" off-topic TBH, but I'm finding it somehow entertaining, and I like the prose ;)
Anyway, better not to overdo with it, Rekah...
 
My normal location is Great Britain so it's quite possible some people won't understand what I'm talking about.
There are some kids down at Mi9 whom would know that a carefully aimed rock cutter pointing from a mountain of olive groves roughly due West would allow access to a place where a beacon could be planted in an underground chamber that would allow me to park a helo right next to a golden dome in the space of three minutes but some would find such talk either insightful or full of incense.
I'd prefer not to start a riot on that level and would advise any bystanders carrying anything other than video recording devices to stay clear and stand down.
In terms of relative distances it's possible nobody will even notice anything is taking place.
On the other hand, in a game of asteroids it's possible to lauch an event from Alpha Centauri that swerves around little floating balls, passes through the lensing effect of a black hole, calcaltating the exact density over mass multiplied by acceleration (assuming I remembered that correctly - I learn fast but Hu knows the outcome, well He does but that may be too Ivrit for some), taking into consideration the amount of energy needed from asking Watts up when the current's down by some Ohms and other such sundries...
We just have to say mazel tov and keep mining data until we're either exhausted or the 'verse runs out of fuel and collapses upon itself in an anti-quasar field collapse of quantal sting confuddlement

There's an old UKTV programme that exaggerates the effect quite well; it's called Threads and I believe the BBC made it.
Then there's the pacts that Russians and Americans played with that came to the threat of mutual distraction some thirty-odd years ago (local Earth-Sol-Milky Whey time) but the less said about pacts the better unless you want everyone looking for amir and datum points to correlate the state of the 'verse from an attempted objective attitude when most people are too busy subjecting themselves to extremes if the media is to be bothered with such trivialities.

Personally, it's time for me to imagine myself down at the well, fetching water for the camels, or by the pumps at the filling station, loading legless carriagers.
Reember, there's yolks and there's artychokes on the Great British Bake Off, especially when it comes to marital law.

So listen up youse guys (and I'm counting at least two billion of youse lots) bystanders will be presented with shields to protect against the glaring of the shiners, there will be a macroscopic fight at the loci canal just as sure as there's six pense in halfe a schilling, twelve pence for a bob, twenty leaves in a pound and an olive branch wrapped around a sword orbiting Epsilon somewhere or other.

Grow up, Mankind [not a user name meant, but the organic humanoids many consider are evolved from amoeba], we're currently experiencing what may be considered as the middle of a long chain of events that could easily be expressed as a mobius strip of time that when thrown into a garbage pail leaves everyone completely unnoticed.

I've got work to do.
shalom, for now :)
 
Back on track (just stress and sleep deprivation going on) I am now at 38 altitude, 47, -54, Maia B1BA, heading 66 at 83 speed. Looking to pick up Ishmael.
Based on how this game is rolling out like a series of entertainment events and basing human writing talent on television series I've seen on telly, I'm looking for the geographic co-ordinates of the Dome of the Rock on Earth in Israel as a guide for where's he's located.

I'm very tired, have things to do and don't want to have to pull a slide rule out to work out the correct course calculated over a sphere and stuff right now. I just want to park up, and go grab some snoozes before the ship smashes all the shields on a mountain side.

So any help from the community in this side story would be appreciated.
Forgive me if I sounded angry, it's just been a long few days.
 
Last edited:
Now at 2.89km altitude at co-ordinates 48.0767, -48.9746, pointing at 0 degrees, presumably North but I hear that drifts.

I have two POI underneath the ship.
They form an overlap arc on the scanner and the arc bounces, rather than sliding smoothly as I move sideways in relation to the viewing window.
I have oriented the ship so that the overlap point is 180 degrees behind the ship (so I can be facing it when I get the buggy out the back).
Has anyone noticed bouncing POI before and am I even at the right place?

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

Landed at 48.0780, -48.9846.
Guess I should drive due South.
(and of course, now I'm paranoid over the fact the SRV launch command is referred to as "deploy")

-----Manual Merge-----

I'm currently on the surface with music volume set to zero in game, yet I am getting changing ambient sounds from the scanner (presumably this is from a sounds of space radiation algorithm thingy).
I have aquired a static yellow square on my scanner, which while moving is a series of flickering yellow squares (they do appear in predictable positions as I move)
Has anybody else noticed this sort of audio/graphical artifact?
(I've seen people posting clipping shots of Borg ships and stuff but that's just object hit detector boundaries struggling with varied terrain textures)
 
Last edited:
So, i was speaking with my boss, and we came to the following conclusion :

An olympic-grade pool is 50mx25mx3m, wich means a volume of 3750m3 (lenght*width*height).
A regular-sized cookie is around 7,5cm in diameter and 1cm in height at highest point.
That is 42,99cm3 of volume (radius²*height*Pi), assuming perfect cylindrical shape for simplification.

Therefore, an olympic swimming pool can contain roughly 87230 regular-sized cookies (+- around 2500 cookies to account for the not perfect cylindrical shape).

So, sorry again for the bit off-topic thinking, i just thougt it might be a useful intel out therein the threadnaught.
You may now resume your daily tasks :D
 
An Update on the Sheet I managed to get candidacy highlighting sorted... more improvements in the future.

In the image below you will see some values highlighted 'Orange and Bold'.
These values highlighted, are between the minimum and maximum of planets that have barnacles on them.

For example the current Max recorded Surface Temp of all planets with barnacles... is 379K
The Minimum is 194K

Any Surface Temp Values that are in this range are highlighted.

Same applies to Composition of Rock/Metal/Ice and gravity values.

If Values for Composition Gravity and Surface temp are all highlighted...(and the planet is 'landable') the planet will be marked as a Candidate.


9PIMacV.jpg

This should streamline searches for barnacles...

Should anyone wish to submit data for a system please PM ME! It really helps!
Hiring all explorers! You will be paid in biscuits! \o/
 
So, i was speaking with my boss, and we came to the following conclusion :

An olympic-grade pool is 50mx25mx3m, wich means a volume of 3750m3 (lenght*width*height).
A regular-sized cookie is around 7,5cm in diameter and 1cm in height at highest point.
That is 42,99cm3 of volume (radius²*height*Pi), assuming perfect cylindrical shape for simplification.

Therefore, an olympic swimming pool can contain roughly 87230 regular-sized cookies (+- around 2500 cookies to account for the not perfect cylindrical shape).

So, sorry again for the bit off-topic thinking, i just thougt it might be a useful intel out therein the threadnaught.
You may now resume your daily tasks :D

Suggest you make square cookies. Is more efficient.
 
Maia b1ba deep sea diving

I have been cruising Maia b1ba looking for Palin's wreck for nearly a week now. Yesterday I realized that, what with just the black hole and brown dwarf nearby, most of this moon is pretty dark and, as my work schedule allows, half of it stays in the black 100% of the time. So that lead me to think, "If I were FD, I would hide this wreck in the darkest place I could." There is nothing darker than the canyons on the dark side of this map.

http://imgur.com/6iXcEXq.jpg

It's like really really deep sea diving! My question is, does everything show up as a blue poi above 2k? Like barnies, wrecks, etc? And second, am I right in thinking half of this moon is perpetually dark or is it just my work schedule that keeps my searching side night time?

CMDR Ignatius J Reilly o7
 
An Update on the Sheet I managed to get candidacy highlighting sorted... more improvements in the future.

In the image below you will see some values highlighted 'Orange and Bold'.
These values highlighted, are between the minimum and maximum of planets that have barnacles on them.

For example the current Max recorded Surface Temp of all planets with barnacles... is 379K
The Minimum is 194K

Any Surface Temp Values that are in this range are highlighted.

Same applies to Composition of Rock/Metal/Ice and gravity values.

If Values for Composition Gravity and Surface temp are all highlighted...(and the planet is 'landable') the planet will be marked as a Candidate.



This should streamline searches for barnacles...

Should anyone wish to submit data for a system please PM ME! It really helps!
Hiring all explorers! You will be paid in biscuits! \o/

Out of rep, but it really looks great now.

Thank you.
icon14.gif
 
You may be pleased to know I am now at 35.1573 by 31.7500 at 48 metres.
We are proceeding to land and shall deploy the baby buggy for a few minutes before taking a break.
 
Status
Thread Closed: Not open for further replies.
Back
Top Bottom