Friday, June 16, 2017

Land Measurements in Andhra Pradesh & Telangana | Real estate conversion

§  1 Acre = 40 Gunta
§  1 Acre = 100 Cents
§  1 Acre = 4,840 Sq. Yards
§  1 Acre = 4,067.23 Sq. Metres
§  1 Acre = 43,560 Sq. Feets
§  1 Acre = 56.21 Aankadam
§  1 Acre  = 14.86 Perch
§  1 Acre = 8.99 Chatak

§  1 Hector= 2.47 Acres




●1 Gajam = 1 Sq Yard = 9 sq feet
●1 Cent = 48.4 sq. Yards
●1 Cent = 435.60 Sq. ft (ft2)
●1 Cent = 40.467 sq. mt (mt2)
●100 Cents = 1 acre
●1 Cent = 1/100 acre
●1 feet (Ft) = 12 inches
●1 hectare = 2.47 acre = 10,000 sq mt (100mt X 100mt)
●1 sq. mile = 640 acre
●1 ankanam = 36 sq ft = 4 sq yd = 3.3 m2 (in Tirupathi area)
•1 ankanam = 72 sq ft = 8 sq yd = 6.7 m2 (in Nellore area)

100 Cents = 1 Acre
1 Cent =1/100 Acre
1 Cent = 40.468 Sq. meter (m2)
1 Cent = 435.60 Sq. feet (FT2)
1 Cent = 48.4 Gajam
1 Cent = 48.4 Sq Yards
1 Cent = 2.471 Cents
1 Gajam = 1 Sq. Yard
1 Gajam = 1Sq. yard = 9Sq. feet
1 Kolu = 3 Feet
1 Feet = 12 Inch 
1 Inch= 2.54 Cm
And Gunta also Guntha is a Measure of an area this unit is typically used to measure the size of a peace of land mostly in Telangana area people used this kind of measurements in India.

1 Gunta = 121 Sqare Yards
1 Gunta = 101.17 Square Meters
1 Gunta  = 2.5 Cents
40 Gunta = 1 Acre


Thursday, May 25, 2017

How to Compare two Excel Workbooks on Single click By Using Macro

          When you have two similar Excel workbooks, or better say two versions of the same workbook, what's the first thing you usually want to do with them? Right, compare those files for differences. There were many solutions given on the internet, but everyone had their own drawback, e.g. viewing files side by side and then visually finding out the differences, well definitely no one would like to do this at least for the large files, or by using Excel formula like ="IF(Sheet1!A1<> Sheet2!A1,"Sheet1:"&Sheet1!A1&" vs Sheet2:"&Sheet2!A1"), this also not gonna work, for alternatively we can use Vlookup, Index Match function  if there is any common unique value in two workbooks but doing for all columns it took more time and less accuracy.

 if there are multiple sheets doing this all the pair of sheets is a huge task. Also, there are software which compares two files, I have used few of them but they can compare only one sheet and if there are multiple sheets then one by one we can do it. And many other solutions which I am not going you through. But I was not looking for this kind of solutions, so I came up with this Macro to compare two Excel workbooks files not matter if you have a single sheet or multiple sheets, which I am going to show you. The differences will be high lighted in Red color for both workbooks.
   Steps to RUN Macro: 

 Click here

                                                               

Saturday, November 5, 2016

Gogasani's Wedding invitation గోగసాని వారి కళ్యాణ ఆహ్వానం On 05-11-2016

                                          గోగసాని వారి కళ్యాణ ఆహ్వానం  
                                                       Click on image for go to the  website link
My Wedding Invitation

Monday, August 29, 2016

Online Digital marketing V/s Offline marketing promotions // Internet marketing Vs. Offline marketing

Digital marketing is an umbrella term for the marketing of products or services using digital technologies, mainly on the Internet, but also including mobile phones, display advertising, and any other digital medium.
The way in which digital marketing has developed since the 1990s and 2000s has changed the way brands and businesses utilize technology and digital marketing for their marketing.Digital marketing campaigns are becoming more prevalent, as digital platforms are increasingly incorporated into marketing plans,and as people use digital devices instead of going to physical shops.
Online marketing promotion ways

Online V.s Offline
In the current era, there is a rapid shift from traditional advertising to digital media and for marketers to be well versed with the ins and outs of online marketing, they should know how to utilize the digital marketing assets, tools and techniques so that they can improve their customer value proposal, create insightful strategies and help succeed in their organizational goals and objectives. It won’t be wise for people to consider advertising and marketing as the same thing because the rise in E-commerce has drastically transformed the way people communicate with potential and existing clients. Digital media has made the world a small place and it does not matter where you start your business from, you can sell your goods and services all over the world. 
 What is digital marketing?
Digital marketing is about promoting products and services using digital distribution, communication and social media channels to connect and interact with potential customers in a timely and cost effective manner. 
Interesting fact: More than 80% of population using internet have purchased something online 
Under the digital marketing course, you will develop a solid base on Digital Marketing approaches including: Search Engine Marketing, Social Media marketing, Email Marketing, content optimization, crafting your website, SEO and how to use Google Webmaster and Analytics to increase the number of leads and Conversions on your website.
Link
https://www.youtube.com/user/gogasani2009/videos

.


Friday, July 1, 2016

Best Analytics tools,Business analytics, Career in analytics, Big data,

Data analytics is the use of advanced analytic techniques against very large, diverse data sets that include different types such as structured/unstructured and streaming/batch and different sizes from terabytes to zettabytes
Analytics is a fast growing field that promises exciting careers for those with strong quantitative skills. In his bestselling book ‘Competing on analytics’, Thomas Davenport defines analytics as “the extensive use of data, statistical and quantitative analysis, exploratory and predictive models, and fact-based management to drive decisions and actions.” Analytics can range from a simple exploration into how many sales were made last year to a complex neural network model predicting which customers to target for this year’s marketing campaign.
Analytics is used in a variety of industries. Industries like financial services, retail and travel are naturally amenable to analytics as they generate a lot of transactions and hence a lot of data. No wonder these industries were among the leaders in adopting analytics. However, less obvious industries like manufacturing and sports are also making innovative use of analytic applications to drive competitive advantage.


Commercial software:-
MS Excel: Almost every business user has access to MS Office suite and Excel. Excel is an excellent reporting and dash boarding tool. For most business projects, even if you run the heavy statistical analysis on different software but you will still end up using Excel for the reporting and presentation of results.
While most people are aware of its excellent reporting and graphing abilities, excel can be a powerful analytic tool in the hands of an experienced user. Latest versions of Excel can handle tables with up to 1 million rows making it a powerful yet versatile tool.
SAS: SAS is the 5000 pound gorilla of the analytics world and claims to be the largest independent vendor in the business intelligence market. It is the most commonly used software in the Indian analytics market despite its monopolistic pricing. SAS software has wide ranging capabilities from data management to advanced analytics.
.
R: R is a programming language and software environment for statistical computing and graphics. The R language is an open source tool and is widely used by the academia. For business users, the programming language does represent a hurdle. However, there are many GUIs available that can sit on R and enhance its user-friendliness.

SPSS Modeler: (Clementine): SPSS Modeler is a data mining software tool by SPSS Inc., an IBM company. It was originally named SPSS Clementine. This tool has an intuitive GUI and its point-and-click modelling capabilities are very comprehensive.

Statistica: is a statistics and analytics software package developed by StatSoft. It provides data analysis, data management, data mining, and data visualization procedures. Statistica supports a wide variety of analytic techniques and is capable of meeting most needs of the business users. The GUI is not the most user-friendly and it may take a little more time to learn than some tools but it is a competitively priced product that is value for money.

Salford systems: provides a host of predictive analytics and data mining tools for businesses. The company specialises in classification and regression tree algorithms. Its MARS algorithm was originally developed by world-renowned Stanford statistician and physicist, Jerome Friedman. The software is easy to use and learn.

KXEN: is one of the few companies that is driving automated analytics. Their products, largely based on algorithms developed by the Russian mathematician Vladimir Vapnik, are easy to use, fast and can work with large amounts of data. Some users may not like the fact that KXEN works like a ‘black box’ and in most cases, it is difficult to understand and explain the results.
Angoss: Like Salford systems, Angoss has developed its products around classification and regression decision tree algorithms. The advantage of this is that the tools are easy to learn and use, and the results easy to understand and explain. The GUI is very user friendly and a lot of features have been added over the years to make this a powerful tool.
MATLAB: is a statistical computing software developed by MathWorks, MATLAB allows matrix manipulations, plotting of functions and data, implementation of algorithms and creation of user interfaces. There are many add-on toolboxes that extend MATLAB to specific areas of functionality, such as statistics, finance, image processing, bioinformatics, etc. Matlab is not a free software. However, there are clones like Octave and Scilab which are free and have similar functionality.
Weka: Weka (Waikato Environment for Knowledge Analysis) is a popular suite of machine learning software, developed at the University of Waikato, New Zealand. Weka, along with R, is amongst the most popular open source software used by the business community. The software is written in the Java language and contains a GUI for interacting with data files and producing visual results and graphs.
Organizations use a variety of products to extract insights from the data. The complete spectrum of the products ranges from simple tools like excel to number crunching mammoths like SAS or R.
Let us take a look at some other popular data analytics tools today, not mentioned in the lists above.
SQL: It is the primary data storage tool across all organizations. It is still being used to manipulate data and produce reports. Anyone who wishes to be in the analytics industry needs to know SQL.

  Tableau: Tableau as a tool has been adopted by most analytics companies. Its visualization capabilities are well recognized in the industry. It is used mostly to produce visualizations and reports. It also allows users to explore the data before beginning the task of predictive modelling.
Orange: It uses the concept of visual programming and simplifies the task of predictive modelling. All major predictive algorithms are built into the software. One can also add functionalities by writing scripts in python. The fact that it is open source makes it all the more attractive.
KNIME: The Company behind KNIME provides a suite of products catering to different needs. It also like orange makes use of visual programming.
Azure ML: This is one product from Microsoft that is poised to be the next big thing. This product is actually an ecosystem that gives users the ability to create data products by integrating machine learning module (mostly R libraries) with a robust backend and a pretty frontend. The data connections can be made from different sources, SQL servers, Hadoop clusters.

Career in analytics.

Thursday, June 9, 2016

Account Number Structure in Indian Banks & number of digits.


Bank account number identifies a relationship between a customer or an entity and a bank. The Committee observed that there is no uniform format / standard structure followed by banks in allotting account numbers to their customers. Each bank has devised its own structure with varying lengths and structure. Further, the account number may or may not be unique within the bank. A few banks use branch code as part of account number to achieve account number uniqueness and use both the account number and branch code fields to correctly identify the customer.

Ø  Most of the banks have unique account numbers.
Ø  Account number length varies from 9 digits to 18 digits.
Ø  Most of the banks (67 out of 78) have included branch code as part of the account number structure. Some banks have product code as part of the account number structure.
Ø  40 out of 78 banks do not have check digit as part of the account number structure.
Ø  All banks have purely numeric account numbers, except one or two foreign banks.
Ø  Only in the case of 20 banks, account numbers are formed without any pattern with a unique running serial number.

As can be seen above, there are lot of variations among the account numbers allotted by the banks – in terms of length (varying from 9 to 18 digits), contents (alpha / numeric) and structure. There is hence a case for standardization of account numbers across the system. As part of the structure, various characteristics such as account type, account status, product code, bank code, branch code, check digits, year of opening etc., are embedded. A few banks have built branch code and other intelligence in the account number where as some banks have used a running number. Again, some banks have built check digit in their account numbers where as others do not have any check digit as a part of account numbers.

Structure of Account Numbers across Indian banks:
No
Bank
Total
Branch
Product/type of account
Ext
Ac No
Length degits
Count
1
State Bank of India
11
5n
0
0
11n
2
ICICI Bank Ltd.
12
4(n)
2(n)
0
6(n)
3
Axis Bank (NEW A/c Number)
15
1(n)
2(n)
2(n)
9(n)
4
Kotak Mahindra Bank
10
0
0
0
10(n)
5
Bank of India
15
4(n)
4(n)
0
7(n)
6
HSBC
12
3(n)
3(n)
0
5(n)
7
IOB
15
4n
2n
0
9n
8
ING Vyasya Bank
12
4(n)
2(n)
0
1000-10-123456
9
Catholic Syrian Bank
18
4(n)
6(n)
0
8(n)
10
Nagpur Nagrik Sahakari Bank Limited
15
3(n)
4(n)
0
8(n)
11
Dena Bank
16
4n
2n
0
12(n)
12
Andhra Bank
15
4 (n)
2 (n)
0
8 (n)
13
Almora Urban Co-operative Bank Ltd
15
3(n)
4(n)
0
8(n)
14
The Bharat Co-operative Bank (Mumbai) Ltd
15
3(n)
4(n)
0(n)
8(n)
15
United Bank of India
13
4(n)
2(n)
0
6(n)
16
Bank of Maharashtra
11
0
0
0
10(n)
17
The Federal Bank Ltd.
14
4(n)
2(n)
0
7(n)
18
The Cosmos Co-Op Bank Ltd
16
3(n)
5(n) to 6(n)
NIL (covered under br code)
2(n) to 8(n)
19
South Indian Bank
16
4(n)
3(n)
0
9(n)
20
Bank of Baroda
14
4(N)
2(n)
0
8(N)_
21
ANZ Bank
14
0
5(n)
0
14(x)
22
Corporation Bank
15
4(n)
3(n)
2(n)
6(n)
23
Indian Bank
17
0
0
0
16(n)
24
Jalgaon Janata Sahakari Bank Ltd. Jalgaon
11
2(n)
3(n)
0
6(n)
25
Punjab National Bank
16
4(n)
2(x)
2(n)
7(n)
26
Credit Agricole Corporate And Investment Bank
14
2(n)
3(n)
0
6(n)
27
Capital Local Area Bank Ltd.
12
3(n)
3(n)
0
6(n)
28
UCO Bank
14
4(n)
2(n)
0
8(n)
29
Rajkot Nagarik Sahakari Bank Ltd.
14
2(n)
4(n)
0
8(n)
30
NKGSB Co-op Bank Ltd.
15
3(n)
2(n)
2(n)
8(n)
31
Lakshmi Vilas Bank
16
4(n)
3(n)
No
8(n)
32
Tamilnad Mercantile Bank Ltd
15
3(n)
5(n)
1(n)
6(n)
33
The Shamrao Vithal Co-operative Bank Ltd
15
3(n)
4(n)
0
7(n)
34
The Ahmedabad Mercantile Bank Ltd.
15
3(n)
3(n)
3(x)
0
35
Union Bank of India
15
5(n)
3(n)
0
7(n)
36
Karur Vysya Bank
16
4
3
NA
9
37
Allahabad Bank
11
0
0
0
10(n)
38






39
Yes Bank
15
4(n)
3(n)
0
7(n)
40
Credit Suisse AG
13
NA
NA
NA
7
41
The Karad Urban Co-Op Bank Ltd. Karad
13
4(n)
3(n)
0
6(n)
42
Dhanlaxmi Bank Ltd
15
4(n)
3(n)
0
07(n)
43
Mehsana Urban Co-op Bank Ltd.
14
4(n)
4(n)
0
6(n)
44
Apna Sahakari Bank Ltd
12
2
0
0
10(n)
45
Karur Vysya Bank
16
4
3
NA
9
46
Karnataka Bank
16
3(n)
5(n)
0
6(n)
47
Mizuho Corporate bank, Ltd.
12
3(n)
3(x)
0
6(n)
48
Punjab & Sind Bank
14
4
2

8
49
Kallappanna Awade Ichalkaranji Janata Sah Bank Ltd
16
0
8(x)
0
8(n)
50
The Saraswat Co-operative Bank Ltd.
15
3(n)
4(n)
0
8(n)
51
Societe Generale
15
0
2(n)
0
6(n)
52
Development Credit Bank
16
3(n)
3(n)
3(n)
14(n)
53
Bank of America N.A.,
12
4
0
0
8
54
Dombivli Nagari Sahakari Bank Ltd.
15
3(n)
4(n)
0
8(n)
55
The West Bengal State Co operative Bank
16
5
8
NA
17
56
Malda DCCB
16
5
8
NA
17
57
Tamluk Ghatal CCB
16
5
8
NA
17
58
Darjeeling DCCB
16
5
8
NA
17
59
Jalpaiguri DCCB
16
5
8
NA
17
60
Raiganj DCCB
16
5
8
NA
17
61
Dakhin Dinajpur DCCB
16
5
8
NA
17
62
Murshidabad DCCB
16
5
8
NA
17
63
Nadia DCCB
16
5
8
NA
17
64
Howrah DCCB
16
5
8
NA
17
65
Mugberia CCB
16
5
8
NA
17
66
Vidyasagar CCB
16
5
8
NA
17
67
Bankura DCCB
16
5
8
NA
17
68
Purulia DCCB
16
5
8
NA
17
69
Barclays Bank PLC
12
0
0
0
12(n)
70
The Tamilnadu State Apex Co-op Bank
9
0
0
0
8(n)
71
TJ Sahakari Bank Ltd.
15
3(n)
4(n)
0(n)
8(n)
72
UBS AG
10
0
0
0
10(n)
73
Canara Bank
13
4(x)
3(n)
0
6(n)
74
Pragathi Gramin Bank
14
2(n)
3(n)
2(n)
6(n)
75
Shreyas Gramin Bank
14
2(n)
3(n)
2(n)
6(n)
76
South Malabar Gramin Bank
14
2(n)
3(n)
2(n)
6(n)
77
Central Bank of India
10
0
0
0
09(n)
78
The Bank of Tokyo-Mitsubishi UFJ Ltd.
17
4(n)
0
0
13(n)

**40 out of 78 banks do not have check digit as part of the account number