Category Archives: Uncategorized

Got extra 10G free google drive space via Quickoffice

After 1 – 2 weeks waiting , today I got extra 10G google drive space , google is a promised company

I knew that if installed quick office on mobile before Sep.28, 2013 , there is an extra bonus 10G for two years , then I tried to install on Sep.25, but at that time , my mobile does not have google play or google frame , even I rooted it , reinstalled those missing software , I can not login with quickbox . 

At last , I decided to replace whole android system for the first time . After a nervous waiting , my mobile started to work again , I installed google play & frame again , it is WORK !

Before Sep.28 , I logged in for  Quickbox for several time then wait until today . Oct. 04 , 2013 , I see the space raise as below picture 10G GG drive promotion

Although the promotion expires in Oct.03,2015 , I will like to use google drive more than dropbox .

Why jewelry factory does not have laser cutting machine

These two days I try to find a Jewel factory which has YAG laser cutting ,but hard to find , at last I give up . I think it is rare in China
An experienced laser cutting seller tell me below Reasons :

1. Expensive : laser cut for Silver is more expensive than metal , because metal is less reflection , but silver is more .

2. Loss rate : Laser cut on Silver will burn the silver , cause the loss of each silver is far more than handmade one , for silver or gold material , loss rate means money .

3. Machine error rate: Because silver has bigger reflection , so machine watt is up , so as heat up , but when laser light reflect from silver surface , it burn on laser head too , so the machine error rate raise .

4. Other reason like : labor price is lower than lasers , processing method / skill / range , those limit laser cut on silver and gold .

So only laser mark is work on silver / gold market now .

Google established my Authorship

I got an email with excitement that Google allow my authorship .
———————————————
You’ve established your Authorship, which means your photo and a link to your profile can now appear next to your content in search results.
———————————————-
It will benefit my future market promotion , I really have many things to publish later , see below to know why :
———————————————-
When your Authorship information appears, it will look something like this:

Your page title

Methods to find duplicate text in Google doc spreadsheet column’s cell then delete it


by Winsion Liang – in 41 Google+ circles.
A relevant snippet from the page will appear here. The excerpt will depend on the user’s search terms.
———————————————–
I hope my name “Winsion Liang” will become a brand in internet in the future . Good night everybody

Your account has been limited —- Paypal is unreasonable on this case !

Firstly got :

Dear ,

We are hereby notifying you that, after a recent review of your account
activity, it has been determined that you are in violation of PayPal’s
Acceptable Use Policy regarding your sales / offers on
http://www.s********.com/.

Therefore, your account has been permanently limited.

Per the User Agreement, when PayPal permanently limits an account due to an
Acceptable Use Policy violation, we may hold your funds up to 180 days. In
addition, you will be liable to PayPal for the amount of PayPal’s damages
for each violation of the Acceptable Use Policy.

To read more about your liability, the actions we may take and other
relevant information pertaining to the User Agreement, please refer to the
following URL:
https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=ua/UserAgreement_full&locale.x=en_US

You will need to remove all references to PayPal from your website/s and/or
auction/s. This includes not only removing PayPal as a payment option, but
also the PayPal logo and/or shopping cart.

The PayPal User Agreement states that PayPal, at its sole discretion,
reserves the right to limit an account for any violation of the User
Agreement, including the Acceptable Use Policy.

Under the Acceptable Use Policy, PayPal at its discretion, may not be used
to send or receive payments for (this list includes but isn’t limited to)
ammunition, firearms, certain firearm parts or accessories, or certain
weapons or knives regulated under applicable law. For a more complete list,
please see our Help Centre on firearms and weapons.

The complete Acceptable Use Policy can be found at the following URL:
https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=ua/AcceptableUse_full&locale.x=en_US

To learn more about the Acceptable Use Policy, please refer to our Help
Center page here:
https://www.paypal.com/us/cgi-bin/helpweb?cmd=_help

We thank you in advance for your cooperation. If you have any questions,
please contact the PayPal Brand Risk Management Department at
[email protected]

Here is my answer :

 Hello , sir ,
I noice my 6 – 8 years old paypal account has been limited Case ID: PP**********  without clear reason .
S**********.com start in 2006 – 2007 and sell none brand products until today , now it limit because of the site ? .

I have some questions:

1. I have clean background for 6- 7 years , I didn’t like to sell any illegal products that avoid paypal policy , so please let me know which / where to violate paypal which rules ?
2. I didn’t get any warning or notifcation of update / change of any rules that I will suffer account limit because of violate paypal rules . So I can not delete or change site as soon as possible .
3. I have clear talking with paypal staff in “021-28913888” , and she is agree I might suffer a mistake strike too .
4. You might review my selling records from 2011 until today or earlier , I didn’t sell any thing from that site because I am going to give up it .
5. I have removed any Paypal logos from my site , and have no plan to use this site in a short time .

So , can you review my site again then determind if limit my account ?

His reply again :

PayPal appeal denied

Thank you for contacting PayPal with your concern regarding the limitation
on your account.

We regret to inform you that we cannot overturn the limitation on your
account. Due to the violation of PayPal’s Acceptable Use Policy, your
account has been permanently limited.

In answer to your specific questions in your email:

The violation was a laser pointer which violates PayPal’s AUP policy.

In regards to a warning, there is currently no warning procedure, if you
are in violation, PayPal places a limitation as we did with your account.

I have re-reviewed the issue and the violation is valid, the customer
service representative (who does not work in this department) was mistaken.

Even with you removing PayPal from the site the limitation will stand.

If you have any questions, please contact the PayPal Brand Risk Management
Department at  [email protected].

——————— I won’t waste time to appeal that .

Methods to find duplicate text in Google doc spreadsheet column’s cell then delete it

I have a column A has lots of different number , I need to find out which one is duplicate , highlight it then delete it according my choose  ,  here is some methods I am testing :

Method A :  Check if a cell appear in last all cells above . 

1. Add a B column and place this formula in B2 :  =countif(A$1:A1;A2)>0 , Copy the formula for all B cells that are adjacent to A cells containing data. A TRUE value in the B column tells you that the value in the A column is a duplicate.

     That means : if A10  found A1 – A9 has duplicate , it count + 1 , if the value > 0 , the system tell you True ,  Or False .

2. Use condition format , if TRUE , highlight the background . You can see some color are there , those are duplicate items in Column A.

3.  You have to use Ctrl+F , to copy and find where is the duplicate item appears , then delete it .

Uncategorized-Methods to find duplicate text in Google doc spreadsheet column’s cell then delete it -1

My comments :

This is a good method to solve small quantity data , but I have 10 thousands line to check , and each line has to check above again . you can imagine ,  in Line 9999 , he must check countif() in 1 – 9998 ,  it might be slow because there are too much repeat calculation to evaluate if it is repeat .

So I think this is a slow method to solve big quantity column data .

Method B: Sort the column from A – Z , then check last cell’s if duplicate

1. Sort column A from A – Z,

2. In column B2 , input : =IF(A2=A1, “Duplicate”, “”) 

3. All duplicate cell in Column A , display text “Duplicate”  in Column B ,  and they list side by side .

4. Find duplicate easier then delete according your choose .

Uncategorized-Methods to find duplicate text in Google doc spreadsheet column’s cell then delete it -2

My comments :

This is a good method to solve big quantity data duplicate issue , because each data just compare the one above it , but another issue is : It might be long time to sort column A from  A to Z  , especially when you are sharing this sheet to other partners who is inputting data !  ( Unlucky that I am in this situation .)

Of course I know the UNIQUE formula to solve automatically , but it won’t let me choose delete which row . See below Gif :

Uncategorized-Methods to find duplicate text in Google doc spreadsheet column’s cell then delete it -3

Click an empty cell, type =UNIQUE(, select the range of cells you want to filter and thenclose the parenthesis. Simple.

Uncategorized-Methods to find duplicate text in Google doc spreadsheet column’s cell then delete it -4

Step 1: Assuming that our original data is in columns A, B & C, go to cell D1 and write a formula to concatenate the data in three columns. We’ll use a pipe separator to distinguish between a row like “a1, b, c” and “a, 1b, c”.

=CONCATENATE(A1, “|”, B1, “|”, C1) – drag the cell handle to fill the formula in other cells.

Step 2: Sort the D column by clicking the header as shown in the screencast.

Step 3: We now need a function to compare two adjacent values in column D. If the values are same, one of them is a duplicate for sure. Type this in E2:

=IF(D2=D1, “Duplicate”, “”) – drag to fill all cells until E5.

That’s it. All rows in column E that have value “Duplicate” are duplicate rows.

My comments : 

Can not choose which one is good to delete , not what I want .

Finally , A fantasy Script comes !!!!

Very easy , just in Column B1, write down : =arrayformula(countif(if(A:A<>””,A:A),A:A)>1)           ———– note : be ware of space in the front and bottom , it might cause not work .

Then use conditional formatting , if True highlight as yellow color , see attachment ,

Uncategorized-Methods to find duplicate text in Google doc spreadsheet column’s cell then delete it -5

Now you can consider sort column A or not .

My comments : 

Very easy to use , fast , accurate , optional of future control , no need to sort it before finding , able to sort after checking , you can choose if need delete .  Because data list beside .

Another thing is , once you wrote this formula and highlight formatting , it is 100% automatically check, whether you insert further data inside or not .

More !!!

Another guy write a scripts here to solve , but it seems hard to understand and not easy to manual delete .

https://developers.google.com/apps-script/articles/removing_duplicates

Thanks for reading my long article so patiently !

Change to use winsionliang.com

Today I decide to forget own-business.org , and change to use winsionliang.com

When I register this site in godaddy.com , everything seems smooth before checkout , but in last step , after click checkout ,

Godaddy website reply :

Unfortunately, we are unable to process your purchase using this form of payment. Please utilize another form of payment, or contact (480) 505-8855 for further assistance.

Such a thing happen on all payment via Credit card , paypal from China , what do you think about this ?

Check on internet , some people says there is a method to solve :

1. Write email to godaddy , ask why can not pay , get this reply :

a.The items that you have in the cart that you are attempting to order.
b.Your confirmation that you authorize the charge shown in the cart (include the exact amount).
c.The last 4 digits of the payment method you are attempting to use (Adding and Updating the Credit Card Information for Your Account).
d.That you have read and agree to our Universal Terms of Service.
e.Please also include your account’s 4 Digit Support PIN.

2. Reply one by one , must tell customer service staff clearly , like what is inside the cart , what is the paying method ..  For example :

a. Winsionliang.com – 1 year $2.95+$0.18=$3.13
b.yes,i confirm authorize.$3.13
c. my last 4 digits payment is 1234
d. yes,i have read and agree to Universal Terms of Service.
e. my account 4 Digit Support PIN is 4321

3.  Then he will reply an email ask some permission on your account , like :

Accept Domain name registration agreement?  Agree to the Domain name registration agreemen ?

Of course you have to accept all .  Some one solve it .

 

But I hate this method ! I pay more without coupon by Alipay ,  just a small money , why do such things ?

 

Strange issue:Google does not index renew website

Hi , long time not to talk , because I jump to a new company dealing outdoor products ,

Recently I make the website in magento 1.6.2.0 ,  for testing purpose , I make the URL link as www.xxxx.com/manufacturing/camping-tent/

I had thought that this looks like Word press blog URL , but unknow why google does not index ???

—————————————————————————————————————————–

The website was ASP before , I moved the domain from  China to USA , then install magento , but unfortunately after install the magento , I am too busy , have to pause working for about 2 weeks , the site was set as “NO INDEX , NO FOLLOW” during this period .

In these two days , I upload products but notice nothing index … Now you can see the old links are all in ASP if “site:www.kycamp.com” , and there is no main website in first link ….

I hope it was not banned . Hope that some one can give me and idea .

The website link is http://www.kycamp.com , welcome to test it . Thanks

 

 

Filled with emotion after seeing Google Science Fair

Today when i open my gmail , i found a special link on page linked to Google Science Fair page .  When I open it and view what is that , I am impact with lots of wonder thinking ,  for what we did when we were young .

Uncategorized-Filled with emotion after seeing Google Science Fair

    In Google Science Fair page , it just wrote this in the beginning :

Have you asked a question today? What did you do with it?

Did it take you somewhere new? Did it bring you here?

The Google Science Fair is an online science competition seeking curious minds from the four corners of the globe. Anybody and everybody between 13 and 18 can enter. All you need is an idea.

Geniuses are not always A-grade students. We welcome all mavericks, square-pegs and everybody who likes to ask questions. Simply upload your project here to win some life changing prizes.

Everyone has a question. What’s yours?

Yes , I was too , when I am young , I had lots of question and wanted to research by myself , but at that age , 13 ~ 18 years old , we were in the middle school ,  13 ~15 in  junior high school , 16 ~ 18 in senior high school . So in China , what is the student doing ? Let me talk to you .

Junior high school : We spend 60~70% time on study bored course (proof useless in future working ) , recite useless history issue for examination .  The rest time 30% , we play bored games , like football , ping pong , basketball …. ( sorry for the word “bored games” because we repeat everyday , but have 0% of any creative project , and thanks for 30% time of sports , I get a health body )

Senior high school ,  We spend 99% time on study on “Chinese , Math ,  English , Physics , Chemistry” , we must get the highest score to enter university . We can not play , we can not think or even have other idea  , Only repeat study bored things  ( Sorry for the word “bored things , because most of the course are proved useless after graduation , I like math , physics , chemistry more , but at last i get sick because of STUDY HARD )

So that is our life in Chinese course , everyone have to waste time to learn useless course … ( A good example is , if you are major in English course in University , the teach require student to learn Japanese , if Japanese not pass , can not get bachelor degree , but remember , major in English ! Why must learn Japanese ???)  , We have no choice .

Yes , “Geniuses are not always A-grade students. ” , I agree but in our country , only A-grade students can get university course .  B , C, D grade students have not much support ,  in fact , the education system is bad here .

Maybe complain this too much …..

It is regret that I am too old and must work hard for lives , can not join google science fair ,  if ask what is my question , i have to say : How to make our education system as better as google’s idea ?

OK , Finally , thanks for google talents , you did a good job !

Happy Valentine’s Day in China

Yesterday is The Valentine’s Day (European version ) , I notice these years this festival is more and more hot in China , and lots of boys buy roses , go to restaurant  , watch film in cimena , make an offer of marriage …..

Maybe I am old  , I have to focus on own business today , have not much moods on this . Before 10 years , this festival is just hot in Hongkong . Now the Merchant adviser notice people love to play foreign country’s festival , they publish more and more advertisement to focus Valentine’s day .

Besides this festival , in China , there is a similar holiday as  Lanterns Festival  , so men have to pay both !

As a man , I start to feel some pressure on it , because everything seems quite expensive today .  Chinese living price is raising fast in these 3 years .

The Valentine’s day in China become more and more hot today , but remember this holiday is not an official holiday yet …..

I heard in recently years , Foreign country has less atmosphere on Valentine’s day , I can not confirm and don’t know why .

Here , some interesting propose method :

 Uncategorized-Happy Valentine’s Day in China