google sheets – Using IMPORTRANGE to juxtapose lists of varying lengths

Suppose I have two Google sheets, Doc1 and Doc2, both of which have only one sheet with two lists with the same schema, say two columns Name and Age. The number of entries in the lists is unknown, but if it makes the task easier, we can assume that they have at most 5 entries:

Two sheets of Google

I want to bring the two lists together and display them in a third "Summary" document, one after the other. I can show them using these formulas, in the Summary cells A1 and A6, respectively:

= IMPORTRANGE ("1cLqgopAWG ...", "Sheet1! A1: B5")
= IMPORTRANGE ("1564EXoW-s ...", "Sheet1! A1: B5")

However, this leaves a boring variable number of blank lines between the two:

Unwanted blank lines

while I would like to show them one directly above the other, as if (manually copied values ​​here to show what I want):

What I would like to achieve

If I try to use IMPORTRANGE in two contiguous rows (i.e. A1 and A2), I have a #REF! error ("The result of the array was not expanded because it would overwrite the data in A2."):

#REF! Fault

Is it possible to achieve what I want?
(Bonus points to remove the constraint on the maximum number of items.)

geocoding – gives a new waitforsecond (1) counter time varying after launching the roll of the dice

in ludo game 2d i am using player turn timer 30 seconds using yield new waitforsecond (1) every time the timer goes to 0 and the player does not roll the dice, the dice are transferred to the player after my problem is that the start of the timer works perfectly The player's chances are ignored if they do not roll the dice and that the timer works perfectly for the 4 players until they launch them but when I roll the dice, I mean that the animation starts after the timer and varies very quickly every time the dice turn and that the breasts look like waitforsecond (1) depend on rolling dice and after a few dice the rolling time goes to 0 from 30 in a few seconds and I want in 30 seconds the timer goes from 30 to 0.

here I've changed code twice

first with waitforsecond (1)

float currCountdownValue;
public IEnumerator StartCountdown (float countdownValue = 30)
{
currCountdownValue = countdownValue;
while (currCountdownValue> 0)
{
Debug.Log ("Countdown:" + currCountdownValue);
return return new WaitForSeconds (1.0f);
currCountdownValue--;
}

if (! isdicerolled) {

if (playerTurn == "RED") {
playerTurn = "BLUE";
InitializeDice ();
}
else if (playerTurn == "BLUE") {
playerTurn = "GREEN";
InitializeDice ();
}
else if (playerTurn == "GREEN") {
playerTurn = "YELLOW";
InitializeDice ();
}
Ielse si (playerTurn == "YELLOW") {
playerTurn = "RED";
InitializeDice ();
}
}


}

and the second time I used time.deltatime but he also gives me the same exit

So, what should I do now, I want a timer like the teen game Patti, poker
everything works but after throwing the dice the time varies, pls help me

Image processing: Detect certain characteristics of contours with varying contrasts

Pictures and description-

• Images are obtained from the images of a video (> 1000 images)

• As indicated, there are contrast variations between images.

• The bubble moves horizontally in the given cylindrical tube

enter the description of the image here

enter the description of the image here

enter the description of the image here

Final goal

To extract 2 main features for all images-

• Contact angles with the locking cylinder [all possible corners] (red)

• Position of the tops of the bubble. [all possible sides] (White)

enter the description of the image here

Previously explored directions-

                (* Where "cropped" is the second image in the description *)
Manipulate[
     Column[{(componentImg =
         (testImg1 =
    cropped
         // ImageSubtract[#, LaplacianFilter[#, 1]]And
// ImageAdjust
// MorphologicalBinarize[#, {a, 0.5}] And
// DeleteSmallComponents[#, Method -> "Median"] And
// erosion[#, blurradius] &)
// morphological components[#, 0.3] &);

testImg1,

eachComponent = (ComponentMeasurements[{componentImg, testImg1}, 
          "MaskedImage", #Elongation > elongation &])
}],
{{a, 0.4389, "Threshold"}, .4, .5},
{{elongation, .8, "Search for elongation"}, .5, 1},
{{blurradius, 0, "blur radius"}, 0, 5},
TrackedSymbols:> {a, elongation, blurradius},
ContinuousAction -> False,
ControlPlacement -> Top,
SaveDefinitions -> True
]

And I have something like that

enter the description of the image here

But that could not give me information about the details of the edge, nor apply it successfully for the other two images.

Any help is welcome,

Thanks and greetings,

Sathvik

google sheets – Including insignificant zeros at the beginning of numbers of varying lengths

I'm trying to digitize numbers in Google spreadsheets, but some of those numbers start with a zero. Currently, my spreadsheet automatically removes zeros, but I want to keep them. The plain text will allow me to do this, but I can not format it in plain text and format my custom number at the same time. My current numeric formatting is "asterisk"0"asterisk"… it's essential because I have to start and end all the numbers in the sheet with an asterisk." All solutions consulted online recommend adding more zeros to my formatting, such as "asterisk"000000"asterisk"… but all the numbers in my spreadsheet do not include zeros at the beginning, I do not want to add zeros at the beginning of every number in the spreadsheet, I just want to keep them at the beginning of For example, some of the numbers I scan in the sheet should look like "12345", while others should look like "012345" I do not want to add zeros, just keep only existing zeros that I scan into the sheet.