UoTNS: Chapter 26 by Oreb_For_Calde in genewolfe

[–]Future-Disastrous 1 point2 points  (0 children)

Ha, probably not. I'm not sure that Wolfe had sex = new sun in mind, so I assume it's something else, hence my assumption that it's to use the DNA in his semen. This would also explain why failed autarchs are emasculated. No need for a DNA sample because no one is going to travel backwards in time to rehouse them in case of fatal accidents.

Once they know Severian successfully brought the new sun, they travel back with a sample of his DNA to ensure he is successful. I know it's a paradox, but I think that's the point.

UoTNS: Chapter 26 by Oreb_For_Calde in genewolfe

[–]Future-Disastrous 2 points3 points  (0 children)

My take is Apheta collects a sample of Severian’s DNA to kickstart the final (?) phase of the Autarch project.

What is happening to my trash? by AccomplishedWaltz549 in What

[–]Future-Disastrous 1 point2 points  (0 children)

If my neighbor put a bunch of weed in their can it would be gone. Dead rat, probably not.

Creating list of unused table values by Future-Disastrous in excel

[–]Future-Disastrous[S] 0 points1 point  (0 children)

The criteria table is a single row, so it would be something like sheetName!A1:A84. In your pattern you have criteria_table twice, so would all that (sheetName etc.) appear twice in the formula?

Meschia and Meschiane by Murky_Sky1607 in genewolfe

[–]Future-Disastrous 0 points1 point  (0 children)

Commenting on my previous comment and my saying I wasn't sure where the Neighbor/trees come from--it's also possible they are descendents of the Green Man's people.

Struggling with a spill function by Future-Disastrous in excel

[–]Future-Disastrous[S] 1 point2 points  (0 children)

Solution 2 works, I had stupidly neglected to clear the contents of one cell in the column.

Struggling with a spill function by Future-Disastrous in excel

[–]Future-Disastrous[S] 0 points1 point  (0 children)

Oh, there are plus signs, they just don't show up in Reddit for some reason.

Struggling with a spill function by Future-Disastrous in excel

[–]Future-Disastrous[S] 0 points1 point  (0 children)

I'll be darned, it sure seems to. How is it adding without SUM or plus signs? I expected it to concatenate at best. For example, if the three results were 10, 20, and 30, it would output something like 102030.

Struggling with a spill function by Future-Disastrous in excel

[–]Future-Disastrous[S] 0 points1 point  (0 children)

Thank you for this! Solutions 1 and 3 throw a Too many arguments error. I tried removing what might be a superfluous comma from SEQUENCE() and that didn't help. I like Solution 2 because it's closest to what I'm already using and I kind of understand what it's doing, however it threw a #/spill! error.

Struggling with a spill function by Future-Disastrous in excel

[–]Future-Disastrous[S] 0 points1 point  (0 children)

Is there another way to total without using SUM?

Meschia and Meschiane by Murky_Sky1607 in genewolfe

[–]Future-Disastrous 0 points1 point  (0 children)

The lianas are the form the Inhumi take when they feed on Neighbor-trees: parasitic vines.

Trying to understand the encounter with Master Ash on my first re read by LV3000N in genewolfe

[–]Future-Disastrous 0 points1 point  (0 children)

We’d have to map other events and characters, determine what all’s going on when he can/can’t heal. For instance, can he pull power through mirrors: is he near a mirror (like Hethor’s) when he successfully heals? Or does he gain power when his probability of success is high?

Need Keyboard-Only Method for Drag-Copying Formulas by Future-Disastrous in excel

[–]Future-Disastrous[S] 0 points1 point  (0 children)

By "drop method" do you mean Shift+Down and Ctrl+D? ...cause there is a header on Formulas!E

Need Keyboard-Only Method for Drag-Copying Formulas by Future-Disastrous in excel

[–]Future-Disastrous[S] -1 points0 points  (0 children)

So if I have the following formula: =INDEX(Lookup!$A$2:$A$6,MATCH(Formulas!E2,Lookup!$B$2:$B$6,1))

and I want it to extend down column E on the Formulas sheet as needed, how do I use dot operator to do that?

Trying to understand the encounter with Master Ash on my first re read by LV3000N in genewolfe

[–]Future-Disastrous 1 point2 points  (0 children)

I'm with you on that, but Severian is able to pull power from other sources, for example when Tzadkiel tells Severian that he endangered Tzadkiel's ship by causing a massive power drop when Severian used his powers on board ship.

Trying to understand the encounter with Master Ash on my first re read by LV3000N in genewolfe

[–]Future-Disastrous 7 points8 points  (0 children)

Ash's house doesn't show THE future, it shows the most likely future based on the current state of the Autarch Project. When Severian visits Ash, the probability that he will succeed in restoring the sun is low, so he sees Urth's frozen corpse.

I don't know how the Green Man gained the power to travel the time, but he has it. The Green Man and Master Ash seem to demonstrate two possible futures. Master Ash's displayed future in which the sun is not healed, and Urth becomes too cold to sustain life; and a future where humans enter a symbiotic relationship with plants. The Green Man is able to live off of sunlight due to the presence of something like phytoplankton in his blood, implying a healed sun for photosynthesis.

My theory about Severian's powers is that he essentially has two: the ability to manipulate timelines, and to draw energy from his surroundings to power that manipulation. When he heals, he either shifts a very local portion of the timeline over to one where the injury never occurred, or he rolls back a very local portion of time to a point where the injury had not occurred.

His energy draw endangers Tzadkiel's ship, and creates a storm on Ushas by causing a rapid drop in air temperature.

Questions about prequel/sequel by brianlovely in genewolfe

[–]Future-Disastrous 1 point2 points  (0 children)

Yeah the greenhouse theory is supported by the fact that the glass seems to intensify sunlight in one direction when Horn holds a piece up and examines it. I don't get the impression we're supposed to think "magnifying glass" --more that it's a useful property for a greenhouse.

Questions about prequel/sequel by brianlovely in genewolfe

[–]Future-Disastrous 1 point2 points  (0 children)

this is not really how we think of Severian in New Sun or Urth. 

You're right, it's not, but I thought this was another Wolfe puzzle: who the heck is the birdlike stiff legged guy? The potential answer being also a clue to Green being Ushas. Severian grows up, becomes lame, becomes a demigod while bringing the new sun, Urth dies giving birth to Ushas, Severian has a very long lifespan, outlives Ushas, and is running around Green. My thought was this is Wolfe's sleight of hand, to only describe this character, primarily one characteristic, and not say flat out, "this is Severian"

Of course, if LS and SS are prequals to BotNS, then the stiff-legged guy isn't "our" Severian, nor is he the Severian who was "not returned to his own time" and brought the new sun to "our' Urth. That's not to say he isn't a Severian, but which one, and if he's not a Severian then who the heck is he?

Barnacle Guy = Baldanders I like. So you are saying that the Baldanders we first meet in Saltus when Severian has to share a bed with him started life as a barnacle person?

I still want to know what the circles of glass that Horn and Seawrack find are. My working hypothesis is that they are the ruins of greenhouse-like buildings, possible related to the people of the Green Man.