google sheets – How to organize a line search (COUNTIF, or MATCH, or …)

Try to search for a value for a given line, but want to create an ARRAYFORMULA so that whenever a new line is added, the search will be performed on that line.

We are currently using = IF (COUNTIF ($ A2: $ EI2, "=" & EO $ 1)> 0,1,0) to search for the line and if the value is found at least once, return 1, otherwise return 0 In this way, I have a value to reference for a conditional trigger elsewhere. The problem is that to apply this to a new line, I have to drag it down. The sheet is populated by responses to Google Form. So I'm going to have an indeterminate number of lines and I want the formula to work automatically on future lines without having to drag it.

Is there a way to perform a line search as ARRAYFORMULA? If it helps, I do not really need to look in the entire line, I only need to look in all the columns with some header (the header is the same as the question is repeated in the form because the respondents will not complete each section of the form).

command line – How to install uTorrent v3.3 on 14.04

Install uTorrent Server 3.3

Step 1: Download the latest uTorrent server from here

Note: (You need to download uTorrent Server for 13.04, also works for Ubuntu 14.04)

Step 2: Extract the uTorrent files

  • Launch Terminal (with Ctrl+Alt+T or search Terminal in dash and click to open it)

    Change the directory in the Downloads folder

    cd ~ / Downloads /
  • Extract the uTorrent files in the / opt directory

    sudo tar -xvzf utserver.tar.gz -C / opt /

Step 3: Set the permission

Step 4: Define the symbolic link

Step 5: Start uTorrent

Note: If you get an error about missing package, then

  • Run the command below to install it:

    sudo apt-get install libssl0.9.8: i386

    then try restarting it.

Step 6: Sign in to uTorrent

enter the description of the image here

Original message from

Note 2 : Yes libssl0.9.8: i386 does not work, try libssl0.9.8,
if it does not work, you probably need libssl1.0.0 (Ubuntu 16.04).

Dg.Differential Geometry – Finds the local coordinates of the ends of a time-varying line (two other objects) to minimize line length variance

  1. Line A 'rotates cyclically around point A' according to a time-varying pattern and coordinates of point A & # 39; are fixed (that is, line A has only one degree of freedom).
  2. The BB line can move along the x and y axes (translational motion) and can also rotate around the B point with the constraint that the distance between points A and B remains constant.
  3. The simultaneous translation and rotation of the BB line also occurs cyclically according to a fixed time variant model, the cycle time corresponding to that of A +.
  4. Due to points 1, 2 and 3 above, the angles AB & ABB vary over time and are cyclic.

Using any numerical method, can we find the X point in the local coordinates of the A line (that is, the distance AX and the angle A (AX) are fixed) and the Y point in the local coordinates of the BB line (that is, the BY distance and the BY angle are fixed) ) so that the coefficient of variation (CV) of the distance between the point X and the point Y is minimal for a given set of snapshots spaced in time over an entire cycle? We need to exclude the trivial solution: the AB line (ie the A point inside the local coordinates of the A & A line and the B point inside the local coordinates of the line BB & # 39;). Please refer to the attached image.

I'm not sure this question is qualified to be part of, so move it to another math group if moderators find it.

calculation and analysis – does Mathematica have a "nice" way to evaluate this double integral on a line segment: $ int_ {[3,3]} ^ {[2,5]} int_ {[3,3]} ^ {[2,5]} log | x-y | dydx $?

I want to do a double integration on a line segment in 2D and I wonder if this can be done in Mathematica. An additional difficulty is that the integral is singular.

$$ I = int_ {[3,3]} ^ {[2,5]} int_ {[3,3]} ^ {[2,5]} log | x-y | dydx. $$

Here, I am not concerned with efficiency, I would simply like to have a good way to integrate these types of integrals with respect to the way I have to do it in Python, which implies to regulate them analytically first of all. deal with singular integrants, then switch to reference intervals before finally coding the actual integration.

Can this be done well in Mathematica?

opencv – Returns the index of a line with the min function in Python

I'm trying to find the index of a numpy array (cut from a detected face to the openv) and draw a line where the sum of the pixels is the minimum value.

I can not return the index.

The code below is

for (x, y, l, a) in facesDetected:
# Cut the resized facial area 200 x 200
face = cv2.resize (frame[y:y + a, x:x + l](200, 200)

# Draw a rectangle in the face area
cv2.rectangle (frame, (x, y), (x + l, y + a), (0,0,255), 2)

face = face.astype (np.uint16)
b, g, r = cv2.split (face)
eyes = (b + g + r)

eyeLines = np.sum (eyes, axis = 0)
markEyes = lineEyes.min (axis = 0)

cv2.rectangle (face, (0, eye mark), (199, eye mark), (0,0,255), 2)

Unity editor, horizontal line in the inspector

Public static class EditorGUILayoutUtility
public static readonly Color DEFAULT_COLOR = new Color (0f, 0f, 0f, 0.3f);
public static read-only Vector2 DEFAULT_LINE_MARGIN = new Vector2 (2f, 2f);

public const float DEFAULT_LINE_HEIGHT = 1f;

public static vacuum HorizontalLine (color, float height, margin Vector2)
GUILayout.Space (margin.x);

EditorGUI.DrawRect (EditorGUILayout.GetControlRect (false, height), color);

GUILayout.Space (margin.y);
blank static public HorizontalLine (Color Color, Floating Height) => EditorGUILoutUtility.HorizontalLine (color, height, DEFAULT_LINE_MARGIN);
blank static public HorizontalLine (Color color, Vector2 margin) => EditorGUILoutUtility.HorizontalLine (color, DEFAULT_LINE_HEIGHT, margin);
public static static HorizontalLine (float height, Vector2 margin) => EditorGUILoutoutUtility.HorizontalLine (DEFAULT_COLOR, height, margin);

public static empty HorizontalLine (Color color) => EditorGUILoutoutUtility.HorizontalLine (color, DEFAULT_LINE_HEIGHT, DEFAULT_LINE_MARGIN);
public static static HorizontalLine (float height) => EditorGUILoutoutUtility.HorizontalLine (DEFAULT_COLOR, height, DEFAULT_LINE_MARGIN);
public static static HorizontalLine (Vector2 margin) => EditorGUILoutoutUtility.HorizontalLine (DEFAULT_COLOR, DEFAULT_LINE_HEIGHT, margin);

public static empty HorizontalLine () => EditorGUILayoutUtility.HorizontalLine (DEFAULT_COLOR, DEFAULT_LINE_HEIGHT, DEFAULT_LINE_MARGIN);

#end if


public override void OnInspectorGUI ()
base.OnInspectorGUI ();

EditorGUILayout.BeginVertical ();

EditorGUILayoutUtility.HorizontalLine (new Vector2 (20f, 20f));

EditorGUILayout.EndVertical ();

Will give this result.

Draw a line Result

command line – How to avoid offsets when listening to music on a Mac?

On a 10.13.6 Mac, I usually listen to music using the command line command. mplayer. However, when the computer is under heavy load, the music sometimes breaks for a fraction of a second or even a second (or more). It's totally disturbing!

How to run mplayer and make sure that does not happen? I want to run the mplayer with the highest possible priority so that these disturbing abandonments do not happen again. All the rest of the computer is less relevant!

ease of use – Extensible lines, fast display or modal to display a large section with the details of a line in a table?

I have a table and in the first version of the implementation, I had extensible lines with information. In the new version, the client wants the expandable sections of the section to be expanded because it contains a lot of information.

What is the best option, in this case, the extensible lines (with other extensible sections inside / text only), the quick view or modal view? Which case offers a better user experience?

I will add some photos from as details for all three cases.
enter the description of the image here

enter the description of the image here

enter the description of the image here

web – Why can contact forms fail to handle line breaks?

From my experience, this all comes down to the developer of the contact form, which does not replace line breaks with appropriate HTML equivalents in the email message (sent in HTML format). Options for formatting this correctly include wrapping text fragments separated by line breaks into paragraphs (p) or simply inserting breakpoints (br) wherever you see a line break.

If the e-mail was sent in plain text, everything would be fine for most. I say "mainly", because even in this case, there are problems with what constitutes a line break. Does it mean a newline (LF, n) only, a carriage return (CR, r) only, or a combination of the two (CRLF, r n)?

What I do in the translation of my emails is to stay true to the RFC standard for plain text e-mail, which prefers CRLF. When sending HTML messages, I first replace explicit CRLF pairs with br tags, then search for CR and LF tags individually to also replace br tags. This usually handles all combinations sent to the server when submitting the form.

It is really wise to keep line breaks when translating an email message. Likewise, some systems store the user's message and display it on a web page for later reference (history). The same thing usually happens on these pages when line breaks are not properly processed (if at all).

How to search and fill a line from a datagridview?

I am completing the details of my form by selecting the product from another form. What I need to speed up the process is that if the user knows the product code, write it manually and fill in the other cells.