Repeat 1 to 10 in excel column

Sometimes, we may need to repeat a set of values in excel. Manually typing will take more time. Inorder to ease the process, you can follow any one of the following steps.

First type 1 to 10 in each column.

Now in the eleventh column, use the formula where the eleventh cell is equal to first cell.

Now drag it until you need the set of numbers to be repeated.

Tha another classic way of repeating a set of values is, first set you have to manually. Then copy the sets and paste it to get next set. Now copy both sets to get 3 and 4 th set.Now copy 4 sets to get 8 , followed by 16,32,64,128..

Even though it looks time consuming, believe me, it will not take more than 5 minutes,since it copies exponentially.

Solved: Youtube Options Not Hiding Auomatically in Android

Recently Android smartphone users are facing this difficulty in Youtube app.

While playing videos in Youtube app in Android , the controls should hide automatically within two or three seconds if the screen remains untouched.

But for some users, the controls like play button, pause button, three dots, close symbol etc remains over the screen and does not disappear automatically.

To solve this issue and to hide the controls automatically, follow these steps.

1. In your Youtube App, Go to Settings →Accessibility
2. Now, Disable the Accessibility player

Now, you can go back to Youtube homescreen and notice that the Youtube options over the video will hide automatically with 1 second.

How does ASD (Additional Security Deposit) is calculated in TNEB | ASD Notice in TNEB Bill Meaning

The Tamil Nadu Electricity Supply Code mandates a review of the Additional Security Deposit (ASD) every two years under Regulation 5(5)(i). Below is a detailed breakdown of how ASD is calculated, what actions you need to take, and how to resolve discrepancies in your ASD notice.

1. How is Additional Security Deposit (ASD) Calculated?

The ASD amount is determined based on the monthly average electricity charges over the last 12 months, depending on your billing cycle:

For Bi-Monthly Billing Consumers

• ASD = 3 times the monthly average electricity charges over the past 12 months.
• Example: If your average bill is ₹500, your ASD will be ₹1,500.

For Monthly Billing Consumers

• ASD = 2 times the monthly average electricity charges over the past 12 months.
• Example: If your average bill is ₹500, your ASD will be ₹1,000.

2. What to Do If Your ASD Notice Shows a Higher Amount?

If you receive an ASD notice where the deposit amount is higher than required, you can request an adjustment in your next bill by visiting your respective TNEB office.

3. What Happens If Your Current Deposit is Less Than the New ASD Amount?

If your existing Security Deposit (SD) is lower than the newly calculated ASD, you must:

• Pay the additional amount in the next billing cycle or by the due date mentioned in the notice.
• Failure to pay within the due date may result in service disconnection.

4. When is the Security Deposit Reviewed?

• The adequacy of Security Deposit (SD) is reviewed every two years for LT consumers.
• Interest earned on the existing deposit will be adjusted.
• If the available deposit is less than the required ASD, the balance will be collected as Additional Security Deposit (ASD).

Country Code - DOM | Which country code is DOM

• Dominican Republic is shortly denoted as DOM.
• Dominican Republic is a country located at Carribbean Region in the island of Hispaniola.
• Capital city of DOM is Santo Domingo. 
• Calling code of DOM : +1-809, +1-829, +1-849
• Population Estimation (2019) : 10735896 (1 Crore People in approximate)
• The currency of the country is Dominican Peso , which is denote by the symbol $

Standarad Chartered Online 360 Rewards - Order tracking Meaning for status

If you have redeemed your online reward points that is earned through standard chartered debit card or credit card in exchange of some rewards, you can track the status of your order in official website of standard chartered 360 rewards page.

Following the meaning for each status for your order tracking.

Order Status	Description
PENDING	Your order has been received and is pending confirmation.
ORDER	Your Order has been confirmed and is currently being processed.
ISSUE	Your order has been processed and fulfillment is in progress.
REDEEMED	Your order has been processed and will be delivered within 15 working days of your Order Date unless otherwise stated in rewards descriptions.
REJECT	More information is needed before we can process your order. Please submit your order again or contact the Standard Chartered Customer Service for assistance. Your points for this order will be re-credited.
RETURN	Your order has been successfully returned and your points have been re-credited.
RECREDIT	Your order is unsuccessful due to invalid information provided or you have cancelled your order. Please submit your order again or contact the Standard Chartered Customer Service for assistance. Your points for this order have been re-credited.

 

NX : Sketch line turns blue after doing Mirror curve operation | NX Sketch Constraints - Color Meaning

In NX Sketching mode, by default the sketch lines will be green in color.

Once you select any dimension tool to mark the dimensions of the sketch, then you may notice that the sketch lines may appear in three different colors.

Yellow - Indicates that the sketch curve is partially constrained or not constrained. (Not recommended)
Blue - Indicates that the sketch curve is fully constrained. (Recommended)
Grey with Brown dimensions - Indicates the the sketch is over constrained. (Not recommended)

So, Incase if the sketch curve turns into blue color after mirror operation, then it means the sketch you have drawin is fully constrained. It is the best practice in the industry 
to sketch the constrain fully.

Fully Constrained Sketch in NX

Partially constrianed sketch in NX

The first picture shown above is fully constrained after mirroring. But once I remove a dimension in the sketch , some curves turns into yellow (second image) that means they need to be constrained properly.

Are Choclates Poisonous to Dogs - Why ?

Yes, choclates are poisonous to dogs.

Choclates contains theobromine which can be easily metabolized by human digestive system, but for Dogs, theobromine ll be digested very slowly.

A small amount of chocolate intake can cause diarrhoea,  stomach upset, Vomiting etc.

But if your dog unknowingly took larger amount of Choclates, then it has a potential to kill the dog.