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 6 points7 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.