How do I use a macro / script to add a new contact (data line) across multiple sheets in Google Sheets?

I have a Google Sheets file that allows me to track people in a workshop / program I run. I use a sheet for main contact information and other sheets for more details on the program. A person name can be displayed in three or four different sheets to keep track of different information. The other sheets are drawn from the master list by referencing.

I would like to set up a script that adds a new contact line to each sheet in the file and automatically adds the reference to this new line. I want to be able to type a name in one place, and that name will be inserted at all places where data is displayed.

How could I do that?

A few questions:

  1. I am using IMPORTRANGE in another file to reference these contacts. Is there a way to link two files in this macro?

    1. What if I want to archive / remove a contact? Could this be done, where it is removed over the leaves and the line is deleted?

Thank you for your help!

Data Structures – Difference between quick sorting, merge sorting, and heap sorting

We know that all of the above sorting algorithms assume O (nlogn). Merge Sort and Heap Sort algorithms need O (nlogn) at worst, while Quicksort needs O (n ^ 2). What is the main difference between these algorithms? Which algorithm is preferable for sorting at any time?

Actually, I was asked in an interview. I replied Merge Sort is not good with space. So we can consider Quicksort. But I could not figure out the difference between fast sorting and heap sorting. I need your help to find out.

ServersBase.Com – Fully managed | Cloud Instances | SSD storage | Europe & USA Data Centers | WJunktion

Our shared hosting platform is designed to deliver the quality, reliability and speed you need for your professional Web presence. Our servers are not overloaded and we monitor them very closely to ensure a high level of service. If you are tired of the empty promises of other web hosting companies to attract customers, you will be very happy with us. If we make you a promise, we hold it.

Let's get straight to our offers:

VCS1 for 30 USD / month
1 GB of dedicated memory
20 GB SSD storage space
1TB bandwidth
1000 Mbps port
1 own IPv4
1 vCPU
Fully managed Managed
Technical support around the clock
Get yours now

VCS2 For 40 USD / month
3 GB of dedicated memory
50 GB SSD storage space
5 TB bandwidth
1000 Mbps port
1 own IPv4
1 vCPU
Fully managed
Technical support around the clock
Get yours now

VCS3 For 55 USD / month
4 GB of dedicated memory
100 GB SSD storage space
10 TB bandwidth
1000 Mbps port
1 own IPv4
2 vCPU
Fully managed
Technical support around the clock
Get yours now

WordPress VCS For $ 50 / m
2 GB of dedicated memory
100 GB SSD storage space
5 TB bandwidth
1000 Mbps port
1 own IPv4
2 vCPU
Fully managed
Technical support around the clock
Get yours now

Payment Methods:
PayPal, Bitcoins and AltCoins

Bank Transfer:
We accept bank transfers from Indian users [just send a ticket for details]

More questions?
Browse our website:
Contact our sales department

mysql – Error while inserting data with MYSQL_CONNECT and PHP

I create a poll associated with a BDD in MySQL, and I would like to enter the answers via radio buttons, but in the following line there seems to be an error in the connection if (!$enlace = mysql_connect('localhost', 'root', '')) {

The full insertion code is as follows:

Error Guardando los datos");

 echo "

Los datos han sido guardados con exito.


"; ?>

op return – What does it mean that a service or entity sends transactions with OP_RETURN data starting with "LP …"?

There have already been a few OP_RETURN Recent transactions where OP_RETURN data begins in scriptPubKey 4c 50 which is LP as ASCII.

For example, these transactions:
– … and much more (6447 in the last two hours at the time of writing)

Since the first bytes are normally used as identifier (e.g. omni for OmniLayer) I would be curious if someone happens to know where this could come from.

Curated Data – Filter by Stock Exchange in Financial EntityClass

I have an example of filtering the EntityClass, For example, to get the companies with the highest P / E:

EntityClass("Financial", "PriceEarningsRatio" -> TakeLargest(10)) // EntityList

But now I want to assign a field exactly, instead of taking those with the biggest elements. How do I get all the companies that exactly fit the stock market? I tried:

(* Find all Financial Entities with "XTKS" (Tokyo Stock Exchange) as its
   "Exchange" value. *)
EntityClass("Financial", "Exchange" -> SameQ("XTKS")) // EntityList

But I get:

Missing(QueryValueIncompatibleWithProperty, {Financial, Exchange, True})

I suspect it has something to do with the use of it SameQ,

How do I filter for stock market when using a financial instrument? EntityClass?

(Note: I know there are other ways to look up the list of companies listed on a stock exchange, but I just want to know how to filter for exact string in a financial measure EntityClass)

adb – How do I recover a deleted file from / data partition?

First, to clarify root and data:

  • root / Android devices is a read-only pseudo (temporary) file system (rootfs), which lives in RAM and disappears when the device is turned off. When the device is turned on, it will be extracted again initramfs that lives in boot Partition together with the kernel.
    On newer devices with system as root system Partition is hung at the root /,
  • /data Directory is a mount point in which the largest partition, usually named userdata assembled. This partition contains all user apps, their data (settings, databases, caches, temporary files, etc.), the system apps data, and all other configurations we have made Settings, /data/media/0 is the directory we see as /sdcard or /storage/emulated/0 through emulation.

… there was a file in the / data directory I need. Is it possible to create an image (.img or similar) of the root directory?

When a file is deleted from /datayou need to create a dump of data Partition, not the root directory.

You can do this in several ways, which are described below. All need root access,

However, first look at this answer to make sure your data is recoverable.
In short, recovery is more or less possible only if (1):

  • Your deleted data was not TRIMmed or discarded.
  • And you have not reset the factory settings to encrypted /data Partition wall.

What you should do immediately:

  • Turn off the phone to make sure the deleted data is not overwritten.
  • Do not install data recovery apps on the device as this can do more harm than good.
  • Include the file system (if necessary) in recovery mode (or on the PC) only ro,nodiscard Options.

To access it userdata Partition, you must find his block device. If you have root access, you can do this via mounted partitions:

~# mount | grep 'on /data'
/dev/block/mmcblk0p... on /data type f2fs (rw,nosuid,nodev,...)

It is located on Qualcomm devices /dev/block/bootdevice/by-name/userdata (Symlink). For MediaTek (MTK) and other SoCs, the path is slightly different. You will find all block devices or by-name Directory with find Command:

~# find /dev -type b
~# find /dev -type d -name 'by-name'

Or by hit and try:

~# ls -d /dev/*/by-name
~# ls -d /dev/*/*/by-name
~# ls -d /dev/*/*/*/by-name

Note: If your /data Partition has Full Disk Encryption (FDE) and you have it unencrypted during recovery. DMCrypt creates a block device under dev / block / dm-0. Use this instead of userdata,


  • DISK DUMP (dd)
    Once the blocking device is known, you can use it dd Command from:

    • ADB shell (operating system or custom recovery)
    • A terminal emulator app like Termux

    Since the userdata Partition is the largest partition (all other partitions occupy barely 5 GB of total memory). You can not copy it to internal memory. An external SD card with larger capacity is needed.

    To create a dump:

    ~# dd if=/dev/block/bootdevice/by-name/userdata of=/path/to/ext_sdcard/data.img

    To avoid data loss, it is recommended that you create a dump if the partition is not mounted; H. In recovery mode.

  • ADB
    If you do not want to use an external SD card, you can also back up the partition directly on the PC. First, you need a job adb Setup, runs as root. Then it can be used in different ways:

    ~$ adb exec-out dd if=/dev/block/bootdevice/by-name/userdata > data.img  

    * Make sure yours adb binary (on Windows or Linux) supports exec-out.

    However, if you write a whole large partition to this partition, you may get corrupted data STDOUT the terminal, because there are problems with line breaks (CR LF) and STDERR could possibly be added to the file if it is not directed to /dev/null, See this question for reference.
    To avoid unwanted characters, use stty raw:

    ~$ adb shell 'stty raw && dd if=/dev/block/bootdevice/by-name/userdata' > data.img

    The simplest way, however, is:

    ~$ adb pull /dev/block/bootdevice/by-name/userdata data.img

    For more information, see this answer.

    This method is useful if you do not want to create a partition dump but want to directly access the partition on the PC.

    UMS is disabled by default on newer Android devices and only MTP is enabled. However, you can enable this in custom recovery mode:

    ~# mountpoint /data && umount /data
    ~# echo '0' >/sys/class/android_usb/android0/enable
    ~# echo '/dev/block/bootdevice/by-name/userdata' >/sys/class/android_usb/android0/f_mass_storage/lun/file
    ~# echo 'mass_storage' >/sys/class/android_usb/android0/functions
    ~# echo '1' >/sys/class/android_usb/android0/enable

    * Kernel should be created with CONFIG_USB_F_MASS_STORAGE
    * The paths may vary depending on the device

    Now userdata is displayed as a partition on a Linux PC as soon as a USB drive is connected. If /dev/sda is usually the hard drive /dev/sdb will be userdata Partition wall. You can find that by using blkid Command:

    ~# blkid | grep userdata
    /dev/sdb: PARTLABEL="userdata" PARTUUID="..."

    You can run the recovery program directly on the block device or provide the file system (if necessary) or create a dump.

Basically, there are two ways to recover deleted data, as mentioned in this answer: the carving method and the file system.

Recovery tools usually do not require file systems to mount. However, if this is required, it must be done on a Linux PC, as Windows does not support it ext4 or f2fs Therefore, the tools of AFAIK are not readily available.

If someone has successfully accessed the Linux / Android file recovery system on Windows through Ext3Fsd or another driver at the block / journal level, let me know so I can update the response.

On Linux, you can use tools such as Extundelete to recover data using the file system journal:

~# extundelete --restore-all data.img

Or to restore data directly with UMS:

~# extundelete --restore-all /dev/sdb

Because you performed a factory reset that clears the file system, you should consider using the carving method with tools such as testdisk scalpel:

~# testdisk data.img

You can also use other data recovery tools in the same way.


[VernalWeb] Premium US Dedicated Server ✅Multiple Data Center ✅DDoS Protection – 10% DISCOUNT | WJunktion

VernalWeb aims to provide customers with affordable but reliable and lightning fast dedicated webhosting plans, Our servers are located in the USA. We have 99.9% uptime SLA. Combine this with our super fast and friendly support around the clock and it will not be long before you smile! We offer 10% REDUCED for the first month on all dedicated servers.

Coupon Code: DEDICATED10

Data center locations:
New York City | Miami, FL | Los Angeles, California

All of our dedicated server hosting packages include the following fantastic features:

✅ Robust 24/7 support (average response time is less than 30 minutes and we do not camp out) and live chat
✅ High performance and permanent safety
✅ 99.99% availability guarantee
✅ High configuration flexibility and much more!

Best Value Dedicated Server Package:

Intel Core i5 4570
4 x 3.20 GHz CPU
8 GB of DDR3 RAM
250 GB hard disk space
10TB premium bandwidth
Scalable IP addresses
Very configurable
Unmanaged (fully manageable)

Price: 69.99 / month
More info | Order now!

Intel Xeon E3 1245 V2
4 x 3.40 GHz CPU
16 GB of DDR3 RAM
500 GB of hard disk space
10TB premium bandwidth
Scalable IP addresses
Very configurable
Unmanaged (fully manageable)

Price: 89.99 / month
More info | Order now!

Intel Xeon E3 1240 V5
4 x 3.50 GHz CPU
1TB hard disk space
10TB premium bandwidth
Scalable IP addresses
Very configurable
Unmanaged (fully manageable)

Price: 89.99 / month
More info | Order now!

Intel Xeon E3 1240 V6
4 x 3.70 GHz CPU
1TB hard disk space
10TB premium bandwidth
Scalable IP addresses
Very configurable
Unmanaged (fully manageable)

Price: 109.99 / month
More info | Order now!

Intel Xeon E3 1270 V3
4 x 3.50 GHz CPU
512 GB SSD storage
10TB premium bandwidth
Scalable IP addresses
Very configurable
Unmanaged (fully manageable)

Price: 119.99 / month
More info | Order now!

Frequently asked question:

Ask: How long do you need to deliver the server?
ans: The delivery time is 48 hours. But usually we deliver within 24 hours.

Ask: How many dedicated IPs do I get with the server?
ans: Each of our dedicated servers contains 1 IP address and you can order up to 5 IPs with the server
(No explanation required). Purchasing more than 5 IPs may require an ARIN justification.

Ask: Do you have a money back guarantee?
ans: No. For dedicated servers, we offer no money back guarantee.

Ask: Do you offer full root access?
ans: Yes. We do

Ask: Do you offer DDoS protection?
ans: Yes. Each server includes 20 Gbps DDoS protection. You can enlarge it.

Ask: Do you offer a fully managed service?
ans: Yes. You can choose a fully managed service during configuration. You must select cPanel Control Panel in this regard.

Ask: Do you allow KVM access?
ans: Yes. We do

Ask: Do you offer a custom configuration according to my requirements?
ans: Of course, you can also set up a server according to your personal requirements.
You can contact our support team by e-mail / ticket, phone or live chat with your requirements
and we will let you know if we have your preferences or available configurations.

If you need more information or assistance, please send an e-mail to sales (at)

Email: sales (at)
Phone number: +8801711985664

Feel free to contact us:
Facebook | Twitter | Pinterest | LinkedIn