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

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:

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:

To learn more about the Acceptable Use Policy, please refer to our Help
Center page here:

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 .


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 ?