All you want to know about PNB Scam

Posted from "The Hindu" dated 28.02.2018

Wise Words- 4

Two impressive and thought-provoking dialogues from the movie “Vikram Vedha”

·      Dei… Vidhi, vidhi nu aayiram thadavai sollitiru.. Life chance-a eduthutu vandhu “sedhu.. indha pidinu kaila kodukadhu”. Unnaku onnu thevaina, adhukaga try panama irukradhudhan thappu.

·   Eppayum prachanai-na prachanai ennanu paarkadha.. Prachanaikaana kaaranam ennanu paaru.

Wise Words- 3

·             Have the courage to follow your heart and intuition. They somehow know what you truly want to become

·         Don’t be trapped by dogma – which is living with the results of other people’s thinking.

·         Your time is limited, so don’t waste it living someone else’s life.

·             If you don’t love something, you’re not going to go the extra mile, work the extra weekend, challenge the status quo as much

VBA in Excel - Properties, Methods and Events - 2

1.

Selection.SpecialCells(xlCellTypeBlanks).Select

This statement selects the blank special cells of the original selection. (The word SpecialCells is a method that handles many of the options in the Go To Special dialog box.)

2. 

Selection.FormulaR1C1 = "=R[-1]C"

This statement assigns =R[-1]C as the formula for the entire selection. When you entered the formula, the formula you saw was =C2, not =R[-1]C. The formula =C2 really means "get the value from the cell just above me," but only if the active cell happens to be cell C3. The formula =R[-1]C also means "get the value from the cell just above me," but without regard for which cell is active.

You could change this statement to Selection.Formula = "=C2" and the macro would work exactly the same—provided that the order file you use when you run the macro is identical to the order file you used when you recorded the macro and that the active cell happens to be cell C3 when the macro runs. However, if the command that selects blanks produces a different active cell, the revised macro will fail. The macro recorder uses R1C1 notation so that your macro will always work correctly.

3. 

Selection.CurrentRegion.Select

Selection.Copy

Selection.PasteSpecial Paste:=xlPasteValues, _

    Operation:=xlNone, SkipBlanks:=False, Transpose:=False

Application.CutCopyMode = False

Range("A1").Select

These statements select the current region, convert the formulas to values, cancel copy mode, and select cell A1.

4.

Sub AddDates()

    Range("A1").Select

    Selection.EntireColumn.Insert

    ActiveCell.FormulaR1C1 = "Date"

    Range("A2").Select

    Selection.CurrentRegion.Select

    Selection.SpecialCells(xlCellTypeBlanks).Select

    Selection.FormulaR1C1 = "Nov-2007"

    Range("A1").Select

End Sub

This macro is pretty straightforward. Notice that the statement that enters the word Date uses the word ActiveCell as the object, changing the "formula" of only the active cell, whereas the statement that enters the actual date uses the word Selection as the object, changing the "formula" of the entire range of selected cells. When you enter a formula using the Enter key alone, the macro uses the word ActiveCell. When you enter a formula using Ctrl+Enter, the macro uses the word Selection. (If the selection consists of only a single cell, ActiveCell and Selection are equivalent.)

In addition, using just the Enter key changes the selection to the next cell down. That's why the Range("A2").Select statement is in the macro. It doesn't hurt anything, but it is also unnecessary. Removing unnecessary statements from a recorded macro makes it easier to read, and easier to modify in the future if you ever need to.

5. 

Selection.End(xlDown).Select

This statement is equivalent to pressing Ctrl+Down Arrow. It starts with the active cell, searches down to the last nonblank cell, and selects that cell.

6.

 Workbooks.Open Filename:="C:\MSP\ExcelVBA07SBS\Orders.xlsx"

In the Visual Basic editor window, the statement that opens the master list should be highlighted:

Workbooks.Open Filename:="C:\MSP\ExcelVBA07SBS\Orders.xlsx"

This statement opens the master list workbook.

TIP

If you remove the path from the file name, leaving only the actual file, the macro looks for the file in the current folder. That would be useful if you move the project to a new folder. However, if the master list is always in the same location, but the source file may be in different locations, it is better to leave the full path of the master file.

7.

ActiveWorkbook.Close SaveChanges:=False

The SaveChanges argument answers the dialog box's question before it even gets asked. While testing, you can have the macro not save the workbook. Once you're ready to really use the macro, you can change the argument to True.

8.

ActiveWindow.SelectedSheets.Delete

The statement refers to the "selected sheets of the active window" because it's possible to select and delete multiple sheets at the same time. (Press and hold the Ctrl key as you click several sheet tabs to see how you can select multiple sheets. Then click an unselected sheet without using the Ctrl key to deselect the sheets.) Because you're deleting only one sheet, you could change the statement to ActiveSheet.Delete if you wanted, but that isn't necessary.

9.

Application.DisplayAlerts = False

DisplayAlerts is a property of the Excel application. When you set the value of this property to False, any confirmation prompts that you would normally see are treated as if you had selected the default answer. The DisplayAlerts setting lasts only until the macro finishes running, so you don't need to set it back to True. You do, however, need to be careful to never run this macro when the active sheet is something you care about. Naturally, you should also be careful to save your work often and keep backup copies.

(From the book

Microsoft® Office Excel® 2007 Visual Basic® for Applications Step by Step 

by Reed Jacobson)

VBA in Excel - Properties, Methods and Events - 1

       One of the best way to learn programing is to learn from the already written codes. As I start to learn VBA for Excel, I feel it extremely difficult to put together the arguments and form a clear knowledge base. The exercise of putting together the  myriad arguments and syntax for programming appears like solving a jigsaw  puzzle.

    In this Excel VBA series, I will posting my learnings of the commonly used properties, methods and events.

   Thanks to my gurus Professor Charlie Nuttelman of  University of collorado and Lokesh Jayasankar sir of BNP Paribas for being of kind guidance in helping me to learn.

    These are basically sample codings. Explanation is appended to codings wherever I felt they are necessary.

1)   msgbox range("d22")

2)   Range("a3:aa5000").AutoFilter Field:=5, Criteria1:="OS-sal"

3)   range("G:G").select

4)   sales = WorksheetFunction.Sum(Range("J:J"))

Range("a1") = sales

5) Displays the color index for the color in the cell

   msgbox range("A1").interior.colorindex

6)   Application.workbooks("Project6).Worksheets("Main").Range(B16")

7)   range("a3").offset(1000,1000)

8)   Copy data from one worksheet and paste into another worksheet

Worksheets("Commands").Range("A1").copy

Worksheets("Feuil3").select

Range("A1").select

Activesheet.paste

9)

Sub Example9( )

Dim DIV as double

Sheet1.Select

ActiveSheet.Range("A8:S60000").autofilter field:=5, Criteria1:="DIV"

With wksT.autofilter.Range

Range("J" & .Offset(1, 0).SpecialCells(xlCellTypeVisible)(1).Row).Select

Range(Selection, Selection.End(xlDown)).Select

DIV = Application.WorksheetFunction.Sum(Selection)

End With

Range("P8:P" & Cells(Rows.Count, "B").End(xlUp).Row)

End sub

10)  msgbox(" the square is "&y&" only.")

11)  msgbox(" the square is "& formatnumber(y,2)&" only.")

12)  Get the value in active cell

Activecell = formatnumber (y,2)

13)   Get the value from cell A1 and output the value to cell C3

Input

x = range("a1")

Output

range("c3")=formatnumber(y,2)

​

14)  Msgbox range("b2:d3").count * activecell + cells(5,2)* inputbox("Please enter a number:")

15)  set w1=worksheets("sheet1)

16)  Pick a cell from existing selection

Selection. Cells(2,2)

17)  Count the number of rows and columns in a selection

nr= selection.rows.count

nc=selection.columns.count

18)  x = inputbox()

19)Get a value of 5 into a cell some rows/columns from activecells

  activecell.offset(2,2) = 5

20)  sub example20()

dim x ,y ,z

x=inputbox()

y=activecell

z= x+y

activecell.offset(2,2) = z

End sub

TED Talk by Sam Berns

Sampson Gordon "Sam" Berns (October 23, 1996 – January 10, 2014) was an American teen who had progeria and helped raise awareness about the disease. He was the subject of the HBO documentary Life According to Sam, which was first screened in January 2013. He died one year later, after appearing in a TEDx Talks video titled "My philosophy for a happy life."

Be Ok with what you can't do (now), because there is so much you can do (now)

  

Wise Words - 2

My thought: And let the goal be selfless

GST Yathra- 18- Time of Supply of Goods

Section 12- Time Of Supply Of Goods

Sub-section 2- Forward charge cases

1. The time of supply of goods shall be the earlier of the following dates:

a) Date of issue of invoice by the supplier or the last date for issuance of the invoice as per Section 31

b) Date of receipt of payment

1. However, where the supplier receives an amount up to one thousand rupees in excess of the amount indicated in the invoice, to the extent of such payment the time of supply shall be the date of issue of invoice at the option of the said supplier.
2. The Date of receipt of payment shall be the

a) date on which the payment is entered in his books of account or
 

b) date on which the payment is credited to his bank account, whichever is earlier

Sub-section 3- Reverse charge cases

1. Time of supply shall be the earliest of the following dates:

a) date of the receipt of the goods or

b) date of payment as entered in the books of account of the recipient or the date on which the payment is debited in his bank account, whichever is earlier or

c) date immediately following thirty days from the date of issue of invoice or any other document, by whatever name called, in lieu thereof by the supplier

      2. Where it is not possible to determine the time of supply as above, the time of supply shall be the date of entry in the books of account of the recipient of supply

Sub-section 4- Where goods are obtained through redeeming a voucher

1. Date of issue of voucher, if the supply is identifiable at that point
2. The date of redemption of voucher, in all other cases.

Sub-section 5- Other cases

In a case where a periodical return has to be filed

The date on which such return is to filed.

In other cases

The date on which the tax is paid

Sub-section 6- In relation to an addition in the value of supply by way of interest, late fee or penalty for delayed payment

Date on which the supplier receives such addition in value.

Section 31- Date of issuance of invoice

1. Invoice shall be issued:

In case of supply involves movement of goods

Before or at the time of the removal of goods

In any other case

Before or at the time of making available the goods

2. Invoice shall mention the description, quantity and value of goods, the tax charged thereon and such other particulars as may be prescribed
3. In case of continuous supply of goods, where successive statements of accounts or successive payments are involved, the invoice shall be issued before or at the time each such statement is issued or each such payment is received.
4. Notwithstanding anything contained in sub-section (1), where the goods being sent or taken on approval for sale or return are removed before the supply takes place, the invoice shall be issued before or at the time of supply or six months from the date of removal, whichever is earlier.

Wise Words -1

The Ever Genrous Devah...

Maithreem Bhajatha , Akhila Hrujjethreem,

Atmavadeva paraanapi pashyatha

Jananee Pruthivee Kaamadughaastey

JanakO Devah Sakala Dayaaluh

Sreyo Bhooyaath Sakala Janaanaam 

Maithreem Bhajatha Akila Hrith Jeththreem

Atmavat Eva Paraan api pashyata

Yuddham Tyajata , Spardhaam Tyajata, Tyajata Pareshwa akrama akramanam

Jananee Prthivee Kaamadughaastey

JanakO Deva: Sakala Dayaalu

Daamyata Datta Dayathvam Janathaa

Sreyo Bhooyaath Sakala Janaanaam

Sreyo Bhooyaath Sakala Janaanaam

Sreyo Bhooyaath Sakala Janaanaam. With friendship please serve,

And conquer all the hearts,

Please think that others are like you,

Please forsake war for ever,

Please forsake competition for ever,

Please forsake force to get, Some one else’s property,

For mother earth is a wish giving animal,

And God our father is most merciful,

Restrain, donate and be kind,

To all the people of this world.

Let all the people, live with bliss,

Let all the people live with bliss,

Let all the people live with bliss.

Budget 2018 - Impact Points for Common Man

General

• Education cess of 3% has been replaced by the Health and Education cess of 4%.
• Henceforth, 40% of the sum withdrawn from NPS by senior citizens is exempt non-salaried assessees too. Hitherto it was exempt only for salaried assessees.

For Salaried persons

• For assessees with salary income, a standard deduction of Rs.40,000/- will be allowed
• Currently, Medical reimbursement and transport allowance is exempt upto Rs. 15,000 and  Rs.19,200 respectively.  This has been replaced with introduction of Standard deduction.

For Senior citizens

• Mediclaim deduction has been increased from Rs.30,000 to Rs.50,000
• For ailments specified in Section 80DDB, the deduction limit in respect  treatment for senior citizens and very senior citizens is Rs. 100,000/-
• In respect of interest earned from Savings bank account, Fixed deposit account and Post office deposits accounts a deduction of Rs.50,000/-  would be allowed. However, no deduction under section 80TTA shall be allowed for such assessees.
• No TDS will be deducted on interest income for senior citizens upto Rs. 50,000/-

For Capital asset holders

• Equity shares and units of equity oriented funds held for more than 12 months are taxable at 10% on sales. No indexation benefit will be given in respect of such sales
• Exemption in respect of capital gains through investing in NHAI or REC bonds will be available only if the bonds are redeemable after 5 years (as against 3 years)

GST Yathra-17- Place of Supply of Services

Section 12- Place of supply of services where location of supplier AND recipient is in India

1.   Immovable property related-services including accommodation in hotel/boat/vessel

Location at which the immovable property or boat or vessel is located or intended to be located.

 If located outside India: Location of the recipient

2.  Restaurant and catering services, personal grooming, fitness, beauty treatment and health service

Location where the services are actually performed

3.  Training and performance appraisal

B2B: Location of such registered person

B2C: Location where the services are actually performed

4.   Admission to an event or amusement park

Place where the event is actually held or where the park or the other place is located         

5.  Organization of an event

B2B: Location of such registered person

B2C: Location where the event is actually held

• If the event is held outside India: Location of the recipient

6.  Transportation of goods, including mails

B2B: Location of such registered person

B2C: Location at which such goods are handed over for their transportation

7.   Passenger transportation

B2B: Location of such registered person

 B2C: Place where the passenger embarks on the conveyance for a continuous journey

8.   Services on board a conveyance

Location of the first scheduled point of departure of that conveyance for the journey

9.  Banking and other financial services

Location of the recipient of services on the records of the supplier

 Location of the supplier of services if the location of the recipient of services is not available

10.  Insurance services

B2B: Location of such registered person

B2C: Location of the recipient of services on the records of the supplier

11.   Advertisement services to the Government

Each of States/Union Territory where the advertisement is broadcasted/displayed/run

Proportionate value in case of multiple States

12.   Telecommunication services

 Services involving fixed line, circuits, dish etc: Location of such fixed equipment

 Mobile/ Internet post-paid services: Location of billing address of the recipient

 Sale of pre-paid voucher: Place of sale of such vouchers

 Other cases: Address of the recipient

13. For the rest of the services other than those specified above, the default provision has been prescribed as under:

B2B: Location of such registered person

B2C:  Where the address on record exists: Location of the recipient

14.   Other cases: Location of the supplier of services

Section 13- Place of supply of services where location of supplier OR location of recipient is outside India

1.       Services supplied in respect of goods which are required to be made physically available:

Location where the services are actually performed

Services supplied in respect of goods but from a remote location by way of electronic means:

Location where the goods are situated at the time of supply of services

Above provisions are not applicable in case of goods that are temporarily imported into India for repairs and exported after repairs

2.      Services which require the physical presence of the recipient

Location where the services are actually performed  or the person acting on his behalf with the supplier of services

3. Service supplied directly in relation to an immovable property

Place where the immovable property is located or intended to be located

4. Admission to or organisation of an event

Place where the event is actually held

If the above services are supplied at more than one locations. i.e.,

(i) Goods & individual related

(ii) Immovable property-related

(iii) Event related

a)  At more than one location, including a location in the taxable territory

Location in the taxable territory

b)  In more than one State

Each such State in proportion to the value of services provided in each State

5. Services supplied by a banking company, or a financial institution, or a NBFC to account holders, Intermediary services,  Services consisting of hiring of means of transport, including yachts but excluding aircrafts and vessels, up to a period of one month

Location of the supplier of services

6. Transportation of goods, other than by way of mail or courier

Place of destination of such goods

7. Passenger transportation

Place where the passenger embarks on the conveyance for a continuous journey

8. Services provided on-board a conveyance

First scheduled point of departure of that conveyance for the journey

9. Online information and database access or retrieval services

Location of recipient of service

10.  For the rest of the services other than those specified above, a default provision has been prescribed as under:

Default rule for the cross-border supply of services other than nine specified services

a)  Location of the recipient of service

b)  Location of the supplier of service, if location of recipient is not available in the ordinary course of business