Google Sheets formula – web application pack exchange

I use Google Sheets, make a table named in column a, the company in column b, and column f, I need their email.

I have 3 companies and they have slightly different email formats. The first is first, the second is the same, but the third is

Is there a way to format Google Sheets to fill in the emails with the addresses for me?

There are a few similar questions, but they all have separate first and last names, or all have the same e-mail format?

Thank you very much

Java – Best way to give the least privilege to a given JAR application on Linux

Suppose I have a Java application running on the host and can perform various tasks. Now I've created a JAR file that records network traffic. When reading What is a path with least privilege to allow node.js to access network adapters on Linux? The best way seems to me to apply the least privilege to being the use of setcap:

setcap 'cap_net_raw,cap_net_admin=eip' /usr/local/bin/java

But here is the problem, if I set cap on Java, it gives all Java applications the possibility to capture the traffic. Is there a better way to do it?

Wi-Fi – Access AP Beacons from Android application

I was wondering if an Android app could have access to nearby beacon data, preferably while the phone is connected to an AP.

My ultimate goal is to read all (or most) bits of the frame body from (almost) all beacons of a particular (or known) AP located on a different channel than the channel of the AP to which the phone is assigned is. So I mean to receive almost every beacon that the AP sends (usually 10 Hz). Although I know that some beacons would be lost due to interference.

background: I know the monitoring mode, the scan request, the active and passive scan and the fact that the startup scan is outdated on Android. I've reviewed the Wifi RTT API, but it does not seem to provide any beacon information other than RSSI and BSSID.

Even if the phone is not connected to an AP, the chances do not seem big, as even a foreground app can only scan a few times in a minute. I am also not interested in scanning the full frequency range.

I understand that the question is too specific, but I would be open to any solution that accomplishes the purpose even remotely and a little bit.

Thank you for any hints or hints in advance!

Application of individual vectors in parametric diagrams

I'm trying to draw something like the Frenet-Serret formulas with a parametric plot:

    r[t_] := {t, t^2, 2 t^3/3}
    t[t_] := r'
      PlotRange -> {{-0.1, 1.1}, {-0.1, 1.1}, {-0.1, 1.1}}], {p, 10^-10, 1}]

Now I want to have the function t[x] also drawn, but as a single vector at the coordinates of the current point r[p],

This probably helps to visualize what I am trying, since it is exactly the same: frenet-serret frame moving along a parametric helix

The helix would be my function r and t is the first of these three vectors that I would like to see moved.

I tried two things, first with

      PlotRange -> {{-0.1, 1.1}, {-0.1, 1.1}, {-0.1, 1.1}},
 Epilog -> {Arrow[{r[p], t[p]}]}], {p, 10^-10, 1}]

However, the arrow will be displayed as a 2D overlay above the plot

      PlotRange -> {{-0.1, 1.1}, {-0.1, 1.1}, {-0.1, 1.1}},
 Epilog -> {ParametricPlot3D[t[p]*u, {u, 0, 1}] /. Line -> Arrow}], {p, 10^-10, 1}]

what I can not get to work there ParametricPlot3D is not a primitive in which to show Epilog

So any ideas? I'm sure because I'm just a noob.

Thanks in advance guys and have a nice day :]

Extract the videos from the Video Play Subscription application in Android

I subscribed to a movie subscription, paid the subscription fee and can download the videos and later play in offline mode.
The videos are stored in the data of the apk (checked by Settings => App Info).
I want to extract these videos because the internet is limited and I want to watch the same videos on my Android home projector.
How can the video files be retrieved from the data folder of the app? Let me know all possible options.

Java – Basic design and architecture of an application with a form and a database backend

I have to submit an application for a customer. The requirements are –
1.Create forms for the user to fill in the details.
2. Save the data from the form
3.Browse the application to view and search the datastores through the forms.
4. Only the customer's company can access this application. Should not be open for public use.

Budget of the customer – Low

I need help choosing the best solution for designing this application and selecting technologies for the front end of the UI and the backend of the database.

1.Should this be a desktop application:

Front end : Java or .NET or HTML

Rear end : Database stored on the desktop or on the AWS server (Options – Microsoft Access / SQL Lite / MySQL).

I'm not very fond of this solution because the application needs to be installed on all systems and upgrading the system will be difficult. Note that there are not many end users.

SecondShould this be a web based application : HTML front-end on a web site with back-end database (MySQL on an AWS server).

Front end : HTML

Rear end : Database-hosted AWS server (Options – Microsoft Access / SQL Lite / MySQL).

I prefer this solution, but I do not know how to privatize the website, d. H. That it is only accessible to the customer and is not open to the public.

Which is the best solution and with which technologies can I create the front-end and the back-end?

Running Windows 10 on the Parallels Virtual Machine – The poker application desktop is visible, but not individual tables

I just started using Parallels Virtual Machine to run Windows 10 and a poker application from Best Poker. When I start the application, all content is visible and I can not interact with it. However, when I open a single table, it's black and no content is visible. At the same time I can hear the action sounds. As I float across the screen, I can find and interact with buttons even when I'm not seeing them. I tried to mess around with the resolution and update drivers, but can not get them up and running.
Does anyone know this problem and has a solution?

Greetings rubber

adb – Android application not executable. 64-bit ELF error in the emulator

I'm building C code android-ndk-r20b/toolchains/llvm/prebuilt/linux-x86_64/bin/aarch64-linux-android29-clang It works on Android devices, but not on emulators. I need a different kernel, so an emulator is required. I'm on Android Studio not executable: 64-bit ELF file if I tried to run it through adb shell. The code is POC for Android here

io – Which ADC modes should I use in a signal processing application for STM32?

I'm writing an application for the STM32f407 discovery board that uses the existing ADCs. I want to have access to all 17 input channels and will use the HAL library to write to a DMA buffer so my parent libraries can use buffered input.

STM32 ADC modes (see Application Notes) state that the ADCs can all be sequenced to convert "continuous capture" – think of a read buffer, and the inputs can be sequenced for acquisition hardware-aided, with EOF after a single one Channel (which I will use). or end of the group survey. ADC1 and ADC2 can be operated in a "dual regular simultaneous mode".

The signals in question are analog approximations of square waves and some analog level sensors (this is an automotive application).

Precision is nice, but takes a backseat to capture the speed.

TLDR: What configuration of the 3 ADCs on an STM32f407 Discovery card should be used for an STM32 application that uses buffered I / O?

HAL library documents for STM32F4

Application notes for the ADC STM32F4 / 2