Sukanya Samriddhi Yojana Account Calculating Maturity Value after 21 Years

Recently Central Government Introduced new scheme for Children., scheme name Sukanya Samriddhi Yojana has received a great initial response from the general public. As the scheme offers 9.1% tax-free rate of interest, investors are finding this scheme to be extremely attractive and want to invest in it as soon as possible. They also need hand holding to invest in this scheme. But, due to lack of required information with the post offices and authorized bank branches, people are finding it difficult to do so.

I have posted two articles about this scheme and both have received over hundred comments from the visitors. I have been getting many queries regarding the maturity value of this scheme. People want to know the value of their investment as the scheme gets matured after 21 years.

Though it is almost impossible to calculate a precise maturity value of this scheme as there are many variables on which its maturity value will depend, I have tried to make a couple of tables in which the maturity value has been calculated keeping those variables to be constant and yearly & monthly contribution to be the only variable.

Certain assumptions have been made for calculating these maturity values and those assumptions are:

1. Rate of Interest has been assumed to be 9.1% for all these 21 years.
2. Yearly contributions have been assumed to be made on April 1 every year i.e. the beginning of the financial year.
3. Monthly contributions have been assumed to be made on 1st day of every month.
4. Although it is not mandatory, a fixed amount of yearly/monthly contribution has been assumed.
5. It is also assumed that no withdrawal is made throughout these 21 years.

Here you have the tables:

Yearly Contribution Table

 Monthly Contribution Table

I hope these two tables help people in deciding how much amount they would like to contribute to this scheme in order to achieve their girl child’s marriage and/or higher education goals.

Before you go ahead and plan to get an account opened, I would like to again highlight the main features of this scheme:

Who can open this account? - Parents or a legal guardian of a girl child up to the age of 10 years, can open this account in the name of the girl child. Up to December 1, 2015, one year grace period has been provided to allow this account to get opened for a girl child who is born on or after December 2, 2003.

9.1% Tax-Free Rate of Interest - This scheme offers 9.1% rate of interest, which has also been exempted from tax in this year’s budget. But, this rate is not fixed at 9.1% for the whole tenure and is subject to a revision every financial year.

2015-2016 Year Govt of India decided  ROI 9.2% for SSA Account.

Scheme Matures in 21 years or on Girl’s Marriage, whichever is earlier - The scheme gets matured on completion of 21 years from the date of opening of the account or as the girl child gets married, whichever is earlier. Please note that the girl attaining the age of 21 years has no relevance to maturity of this scheme.

Deposit for 14 years only - You need to deposit a minimum of Rs. 1,000 and a maximum of Rs. 1,50,000 only for the first 14 years, after which you are not required to deposit any amount. Your account will keep earning the applicable interest rate for the remaining 7 years or till it gets matured on your daughter’s marriage.

Documents Required - You need birth certificate of the girl child, along with the identity proof and residence proof of the guardian, to open an account under this scheme. You can approach any post office or authorised branches of some of the commercial banks to get this account opened.

The following document required to open SSA Account.

1. Child Birth Certificate
2. 2 Photos for Child and Guardian
3. Address Proof : Passport , Aadharcard etc..
4. PAN Card

Uninstall and Install SharePoint Solution - SharePoint 2010/2013

Introduction

how to Uninstall and install a .wsp in SharePoint 2010/2013

Uninstall wsp / Install wsp

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction "SilentlyContinue" $SolutionPackageName = "XXXXX.wsp" $solution = Get-SPSolution | where-object {$_.Name -eq $SolutionPackageName} # check to see if solution package has been installed if ($solution -ne $null) {   # check to see if solution package is currently deployed   if($solution.Deployed -eq $true){     Uninstall-SPSolution -Identity $SolutionPackageName -Local -Confirm:$false     Remove-SPSolution -Identity $SolutionPackageName -Confirm:$false   } } Add-SPSolution -LiteralPath $SolutionPackagePath Install-SPSolution -Identity $SolutionPackageName -Local -GACDeployment

Add a call to Get-SPSolution and conditional logic to determine whether the solution package is currently installed and deployed before attempting to retract or remove it. Once solution is find, then call to Uninstall-SPSolution and Remove-SPSolution will remove solution package.Then use Add-SPSolution and Install-SPSolution to install the solution.

Create Custom List from powershell2.0 in SharePoint 2010

Introduction

In this article explains how to create Custom List from powershell2.0 in SharePoint 2010.

Task

Create a SharePoint Custom List EmpInfo with text columns
FirstName – mandatory
LastName – not mandatory

Remove-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue

Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue

try

{

$TestSiteUrl = "http://xxxxxx:xxxx/mysite" #provide site url in this variable

$ListName = "EmpInfo"   #listName

$ListDescription = "Employee information list" #list description

$myTestWeb = Get-SPWeb -identity $TestSiteUrl   #Get web object

$listTemplate = [Microsoft.SharePoint.SPListTemplateType]::GenericList  #GenericList template

write-host "Adding list" $ListName

#column1 schema xml

$firstNameColXml = "<Field Type='Text' DisplayName='FirstName' Required='TRUE' EnforceUniqueValues='FALSE'
MaxLength='255′ StaticName='FirstName' Name='FirstName' />"

#column2 schema xml

$lastNameColXml = "<Field Type='Text' DisplayName='LastName' Required='FALSE' EnforceUniqueValues='FALSE'
MaxLength='255′ StaticName='LastName' Name='LastName' />"

#build the list url

$listUrl = $myTestWeb.ServerRelativeUrl + "/lists/" + $ListName;

#we can't use getlist here as the method raises filenotfoundexception if the list url is not there

$myCustomList = $myTestWeb.Lists[$ListName]

if($myCustomList -eq $null)

{

  $lstId = $myTestWeb.Lists.Add($ListName,$ListDescription,$listTemplate)

  $myCustomList = $myTestWeb.GetList($listUrl) # use getlist here as  the list already exists

#Add columns

$myCustomList.Fields.AddFieldAsXml($firstNameColXml,$true,
[Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView)

$myCustomList.Fields.AddFieldAsXml($lastNameColXml,$true,
[Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView)

 $myCustomList.Update()

 write-host "list created successfully" $ListName

}

else

{

  write-host "List already exists" $ListName

}

}

catch

{

  write-host "Error" $_.exception

  $errorlabel = $true

}

finally

{

  if($myTestWeb -ne $null)
 {$myTestWeb.Dispose()}

  if($errorlabel -eq $true){exit 1}

  else {exit 0}

}exit 0

In the above code

1. Remove-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue
2. Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue

These commands will make the PowerShell to refer SharePoint dlls and identity the commands we have written. Sometimes if the dll is already referred; you may not get error. But, remember this is the best way to add so that you will never encounter error.


These commands will make the PowerShell to refer SharePoint dlls and identity the commands we have written. Sometimes if the dll is already referred; you may not get error. But, remember this is the best way to add so that you will never encounter error.

1. $myCustomList = $myTestWeb.Lists[$ListName]

Better coding practice says that not to use web.Lists[listname]. But, here we are using this to check if the list exists or not. So, if we use GetList method to get the list object; FileNotFoundException exception will raise if the list is not there.

This is documented in msdn also SPWeb.GetList Method.

We have to use GetList method only when we are sure that List is available
firstNameColXml & lastNameColXml are the schema xmls as per our scenario. We can add respective schema xml for the new columns
to create

Reference:

http://adicodes.com/create-custom-list-with-powershell-in-sharepoint-2010/

Add Fields To SharePoint List with PowerShell in SharePoint 2010 (Part1)

Adding field of type ‘Single line of text’

$TestSiteUrl = "http://XXXXXXXXX:XXXX/sites/XXXXX"
$NewWebobj = Get-SPWeb -identity $TestSiteUrl
$newListName = "EmpList"
$newListDescription = "Employee Information"
$listTemplate = [Microsoft.SharePoint.SPListTemplateType]::GenericList
$lstId = $NewWebobj.Lists.Add($newListName,$newListDescription,$listTemplate)
write-host "list " $ListName " created successfully" $ListName -ForegroundColor Green

$listUrl = $NewWebobj.ServerRelativeUrl + "/lists/" + $newListName;
$myCustomList = $NewWebobj.GetList($listUrl)

#column of type 'Single line of text'
$firstNameColXml = "<Field Type='Text' DisplayName='FirstName' Required='TRUE' MaxLength='255'
StaticName='FirstName' Name='First Name' />"

$myCustomList.Fields.AddFieldAsXml($firstNameColXml,$true,
[Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView)

$myCustomList.Update()

Above code will create SharePoint custom list ‘EmpList’ with column ‘FirstName’ which is of type ‘Single line of text’. 

Adding field of type ‘Multiple lines of text’

$multiLineCol1 = "<Field Type='Note' DisplayName='MultiLineCol1' Required='FALSE' NumLines='6' RichText='FALSE'
Sortable='FALSE' StaticName='MultiLineCol1' Name='MultiLineCol1' />"

$myCustomList.Fields.AddFieldAsXml($multiLineCol1,$true,
[Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView)

Adding field of type ‘Choice’

$choiceCol1 = "<Field Type='Choice' DisplayName='ChoiceCol1' Required='FALSE' Format='Dropdown'
FillInChoice='FALSE' StaticName='ChoiceCol1' Name='ChoiceCol1'>
            <Default>MyChoice1</Default>
            <CHOICES>
                <CHOICE>MyChoice1</CHOICE>
                <CHOICE>MyChoice2</CHOICE>
            </CHOICES>
           </Field>"

$myCustomList.Fields.AddFieldAsXml($choiceCol1,$true,
[Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView)

Adding field of type ‘Number’

$numCol1 = "<Field Type='Number' DisplayName='NumCol1' Required='FALSE' Name='NumCol1'/>"
$myCustomList.Fields.AddFieldAsXml($numCol1,$true,
[Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView)


Adding field of type ‘Date and Time’

$fldXml = "<Field Type='DateTime' DisplayName='DataTimeCol1' Format='DateOnly'   Name='DataTimeCol1'/>"
$myCustomList.Fields.AddFieldAsXml($fldXml,$true,
[Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView)

InfoPath: Restrict visibility to users in a SharePoint Group

http://info.akgroup.com/blog-0/bid/69277/InfoPath-Restrict-visibility-to-users-in-a-SharePoint-Group

World’s largest SharePint? It will happen ‘all week’ at Microsoft Ignite!

World’s largest SharePint? It will happen ‘all week’ at Microsoft Ignite!

As promised in our blog post on the evolution of SharePoint a few weeks ago, this morning we released the complete list of SharePoint-related sessions that will be offered at Microsoft Ignite in Chicago, IL, May 4-8 2015.  Ignite is the premier Microsoft event for IT pros, and the only one that brings the vast community of people who work with SharePoint every day together with the people at Microsoft who build SharePoint. Be there as we lift the curtain on SharePoint 2016, announce new Office 365 innovations, and share our overall technology vision and strategy. It will be a week of SharePoint and Office 365 community events—like one, giant week-long #SharePint, with SharePoint community experts mingling, presenting, learning, sharing and grabbing a pint or two together.

Deep technical content

At Ignite, we’ll publicly demo SharePoint Server 2016 for the first time. In addition, you’ll have your choice of 50+ breakout sessions dedicated to SharePoint on-premises and online, 24 hands-on-labs—including several new hybrid labs—and two important pre-day training offerings for IT pros and developers. Many of all these offerings will be presented for the first time at Ignite. If you add in SharePoint-related technologies, there will be 130+ sessions to choose from, similar to the breadth of what you would have experienced at the SharePoint Conference of the past. So go deep with leading experts from Microsoft and the community on topics ranging from product overview, best practices, how-tos and deep-dives, to vision and roadmap—all tailored by role, level and specific interests.
Here’s a sampling of SharePoint breakout sessions (links take you to the individual Ignite session page):

Title	Speaker	Level
The Evolution of SharePoint (Overview and Roadmap)	Bill Baer	200
MVP Panel: SharePoint On-Premises, Online and Everything in Between	Chris McNulty; Christian Buckley; Dan Holme; Jennifer Mason; Laura Rogers	200
Build Solutions with Office Graph APIs	Helge Solheim; Jon Meling	300
I Sync, Therefore I Am – a Deep Dive on OneDrive Sync Capabilities and Roadmap	Jason Moore	300
The Social Intranet – Integrate Yammer into Your SharePoint Experience	Eric Overfield; Naomi Moneypenny	300
SharePoint 2013 and Azure IaaS: Better Together	Brian Alderman	300
Designing and Applying Information Architecture for SharePoint and Office 365	Scott Jamison	300
Transforming Your SharePoint Full Trust Code to the Office App Model	Bob German; Chris O’Brien	400
Bose Turns Up the Volume with Microsoft Office 365	Brian Maher, Bose	200
Properly Scale and Deploy Enterprise Search	Corey Roth; Matthew McDermott	300
Customizing NextGen Portals Using the New Video APIs, Doc Types and App Parts	Daniel Kogan; Jeremy Kelly	300
What’s New for IT Professionals in SharePoint Server 2016	Bill Baer	200
Troubleshooting Hybrid Configurations and Workloads with SharePoint 2013 and Office 365	Aimme Triplett; Manas  Biswas; Neil Hodgkinson	300

View all SharePoint and related sessions here.

Unrivaled community and networking opportunities

If you’ve been to any of our past conferences, you know the real magic happens with the connections you make onsite—joining the SharePoint runners, ad-hoc syncs during session breaks and afterhours at the big and small parties.

“You start meeting people and making friends, then you find out they have the same problems and issues and you start figuring out how to solve those things. You go to learn about what’s new from Microsoft, and you stay for the community.” – Naomi Moneypenny, Ignite Speaker, and past SharePoint Conference Speaker, @nmoneypenny

We’re hosting six large theaters in the event’s ginormous expo hall to serve as community zones. These provide a platform for community leaders to share their knowledge and experience with attendees, as well as comfortable meeting places for the spontaneous conversations that crop up. The content in these theaters is 100 percent community-driven. You can expect community-run panel discussions, short fire-starter sessions, where you can share an idea with the community and get immediate feedback, and birds of a feather session in which people with similar interests gather for discussion and maybe some of that ‘controlled chaos with clarity’ this community is known for.

“We have this organic community in SharePoint. Being at the event, anyone can just jump in and be part of the conversation.”  – Laura Rogers, SharePoint Conference Alumni, @WonderLaura

Mealtimes and after hours provide a whole new slew of opportunities to network and make connections, from scheduled events including the Welcome Reception Monday night and Attendee Party Thursday night to more informal gatherings including meal-time mashups with seating by topic or geography so every meal at the conference becomes a chance to meet someone with similar interests.
And the legendary SharePint tradition will continue at Ignite with what no doubt will be the biggest SharePint ever. Three cheers to that!
Register today and join us at Ignite!

Reference:
http://blogs.office.com/2015/03/02/worlds-largest-sharepint-will-happen-week-microsoft-ignite/