Google suspends its 30% cut in India's region Playstore

As reported by Techcrunch, After Google trying to enforce its 30% pay cut on its regional Playstore in India, no less than 150 startups companies in the country formed a coalition in order to halt the policy. They also began to look for alternative store which has lower store cut. Because of the protest Google decided to suspend the cut rate in India even though the company would still go with the same rate everywhere else.

Google Authenticator on two devices showing different codes after scanning the same QR code

When I scan my QR code to enable my 2FA security on some of my trading accounts, I do it on 2 devices (my old phone, and new phone) for safety in case I lose my new phone. My issue is that the two devices then show two different codes and only one of them is correct/works.

I have updated all the apps on both so that should not be the issue.

Has anyone else encountered this problem or got any advice on it?

vlookup – Categorize text in Google Sheets based on matching partial text in the Category index

I’m looking to match, with VLOOKUP, part of the words in a column in the main sheet to an index of keywords/categories where partial words are stored for ease in another sheet.

Here’s an example worksheet:
https://docs.google.com/spreadsheets/d/13QrS1nDjTN6oxIoXhvdyoiqAa4lf8x3eSY3566_eTJ8/edit?usp=sharing

  1. The Expenses sheet has the data as we receive it, in columns A to C.
  2. In Column D, we’d like to auto-assign a category to these expenses. If we do this with exact text in the column B, for example, BANK VISA PREAUTH PYMT, then it’s easy. The VLOOKUP formula in column D works by getting this precise reference from the ‘Categories’ tab (cell A1 is worded exactly this way). This formula works: =IFERROR(VLOOKUP(B2,Categories!A:B,2,FALSE),"")
  3. The challenge is that our expenses of a similar type won’t always follow the exact text. For example: SEND E-TFR US***ke5 and SEND E-TFR US***xja. As such, we’d like to match just the text SEND E-TFR.

This means the VLOOKUP needs to match partials in the ‘Categories’ tab first column. How does adjust the VLOOKUP formula to achieve this?

PS. My question is quite similar to this one with the vital distinction of wanting to match substrings.
Categorize cells in Google Spreadsheets

java – APP não compatível com o meu dispositivo google play

Olá,
Tentei colocar meu aplicativo na google play ele gera o link e tudo,porém quando eu entro no link diz que o meu app não é compatível com aquele dispositivo, não funcionou em nenhum sabe.Será que alguém poderia me auxiliar?

Atualmente estou usando essa configuração.
compileSdkVersion 29
buildToolsVersion “29.0.2”

defaultConfig {
    applicationId "com.apptocacomigo.tocacomigoapp"
    minSdkVersion 16
    targetSdkVersion 29
    versionCode 6
    versionName "6.0"

    testInstrumentationRunner "androidx.test.runner.AndroidJUnitRunner"
}

buildTypes {
    release {
        minifyEnabled false
        proguardFiles getDefaultProguardFile('proguard-android-optimize.txt'), 'proguard-rules.pro'
    }
}
compileOptions {
    sourceCompatibility JavaVersion.VERSION_1_8
    targetCompatibility JavaVersion.VERSION_1_8
}

}

dependencies {
implementation fileTree(dir: “libs”, include: (“*.jar”))
implementation ‘androidx.appcompat:appcompat:1.2.0’
implementation ‘androidx.constraintlayout:constraintlayout:2.0.4’

I will publish 150+ google maps citation to rank website, directory submission, business listing for $1

I will publish 150+ google maps citation to rank website, directory submission, business listing

I will make 150 + google map citations for local businesses with any country in the world. my service is

a very special service if you order me then you will understand .. why it’s

special? .. because I have been working for google map citation minimum of 3

years. I have many experiences with google Maps’ local business

>>Whole Worldwide Wise Work 100% Accuracy and accuratelyService>>

  • 100% best for Glocal & G map ranking
  • a very high-quality backlink for local SEO
  • address on G map
  • Map Located Name on Gmap
  • the phone number on the G map
  • 100% manually guaranteed
  • increase your google map
  • Money-back guarantee 50%
  • Unlimited Revisions.

All I need from you is :
* Your link OR Url
* 3-4 tags OR Targeted keyword
* 200-300 description
* Title
you may place orders. I am ready to work for you

>>>>See my other Service<<<<<

Top 40 Pdf Submission service manually forbacklinks or traffic
I Will Create 50 Local Citations Or LocalListing For Any Country, Rank Your Business Website.I will Create 80 High DA SEO profilebacklinks

.

I will create 40 dofollow profile backlinks for $1

I will create 40 dofollow profile backlinks

Do you wanna get 40 dofollow profile backlinks for $1!

You have come to the right place. I will create all profile backlinks manually, using white hat method. Profile backlinks increase your site authority. High-Quality backlink is the most important element that must help your site to rank #1 page on google. A proverb goes that ” high quality content will get you to the table, high quality backlinks will secure a seat.”
What you will get:

  • Manually created backlinks.
  • White hat method.
  • High DA/PA links.
  • Anchor text backlinks.
  • Natural mix of dofollow & nofollow.
  • Friendly with search engines.
  • Friendly with google panda & penguin.
  • Permanent backlinks.
  • 0-2 keyword promotion.
  • Finally, I will provide full reports with login details.

Note: We will not allow related porn, Casino, alcohol, gambling, or illegal websites.
If you want,i will give you some sample of my previous work!
Feel free to contact me before Place an Order.

.

python – Google Foobar Level 1 – Minion Task Schedule

I recently just stumbled upon a post regarding Google Foobar Level 2 and decided to try it out myself but starting from Level 1. The description and code are shown below.

Write a function called answer(data, n) that takes in a list of less than 100
integers and a number n, and returns that same list but with all of the numbers
that occur more than n times removed entirely. The returned list should retain
the same ordering as the original list - you don't want to mix up those carefully
planned shift rotations! For instance, if data was (5, 10, 15, 10, 7) and n was 1,
answer(data, n) would return the list (5, 15, 7) because 10 occurs twice, and was
thus removed from the list entirely.

Constrains:
Standard libraries are supported except for bz2, crypt, fcntl, mmap, pwd, pyexpat,
select, signal, termios, thread, time, unicodedata, zipimport, zlib.

Test Cases:
Inputs:
(int list) data = (1, 2, 3)
(int) n = 0

Output:
(int list) ()

Inputs:
(int list) data = (1, 2, 2, 3, 3, 3, 4, 5, 5)
(int) n = 1

Output:
(int list) (1, 4)

Inputs:
(int list) data = (1, 2, 3)
(int) n = 6

Output:
(int list) (1, 2, 3)

Code:

def answer(data, n):
    if len(data) > 99:
        exit('List contains more than 100 elements')
    print('data:n', data) #for error-checking

    count = dict()
    for i in data:
        count.setdefault(i, 0)
        count(i) += 1
    print('count:n', count) #for error-checking

    for k, v in count.items():
        if v > n:
            for i in range(v):
                data.remove(k)

    return data

I decided to also test the code myself by using test cases and a new list containing random numbers

data1 = (1, 2, 3)
n1 = 0

data2 = (1, 2, 2, 3, 3, 3, 4, 5, 5)
n2 = 1

data3 = (1, 2, 3)
n3 = 6

data4 = (random.randint(1, 15) for i in range(0, 99))
n4 = 6

ans1 = answer(data1, n1)
print('ans1:n', ans1, 'n')

ans2 = answer(data2, n2)
print('ans2:n', ans2, 'n')

ans3 = answer(data3, n3)
print('ans3:n', ans3, 'n')

ans4 = answer(data4, n4)
print('ans4:n', ans4, 'n')

Output:

data:
 (1, 2, 3)
count:
 {1: 1, 2: 1, 3: 1}
ans1:
 ()

data:
 (1, 2, 2, 3, 3, 3, 4, 5, 5)
count:
 {1: 1, 2: 2, 3: 3, 4: 1, 5: 2}
ans2:
 (1, 4)

data:
 (1, 2, 3)
count:
 {1: 1, 2: 1, 3: 1}
ans3:
 (1, 2, 3)

data:
 (15, 9, 14, 10, 13, 8, 7, 2, 10, 3, 10, 11, 9, 9, 10, 7, 5, 11, 12, 14, 1, 5, 14, 15, 11, 2, 13, 2, 6, 1, 6, 8, 3, 15, 8, 6, 6, 13, 14, 14, 2, 14, 12, 6, 15, 4, 7, 5, 13, 8, 8, 4, 7, 15, 6, 1, 2, 11, 14, 6, 8, 4, 10, 4, 2, 9, 6, 14, 11, 12, 8, 15, 7, 15, 6, 1, 14, 8, 5, 14, 6, 10, 8, 1, 4, 15, 11, 9, 11, 10, 13, 13, 9, 7, 7, 4, 4, 12, 12)
count:
 {15: 8, 9: 6, 14: 10, 10: 7, 13: 6, 8: 9, 7: 7, 2: 6, 3: 2, 11: 7, 5: 4, 12: 5, 1: 5, 6: 10, 4: 7}
ans4:
 (9, 13, 2, 3, 9, 9, 5, 12, 1, 5, 2, 13, 2, 1, 3, 13, 2, 12, 5, 13, 1, 2, 2, 9, 12, 1, 5, 1, 9, 13, 13, 9, 12, 12)

Any input is appreciated. Thank you 🙂

google sheets – How to get the previous edit of a cell in another cell using formula or script

I’m trying to figure out a way to bring the previous edit of a particular cell in another cell. I cannot use version history because every cell may e edited at a different time in different versions. I cannot take all version create subsheet and do a vlookup, So is there any way to run script or update a formula for the same?