This is a collection of events i learned over the years, which would be useful for others to learn and prevent repeating mistakes.
Wednesday, December 16, 2009
BIAS-5 and BIAS-12 timing at Jayanagar
Timing for volvo vayu vajra in route no 5 and 12 from jayanagar bus stand (as photographed from the stop)
Wednesday, October 28, 2009
LG AMC for Refrigerator
The defrost unit in my fridge failed and i got it replaced. The lower part of the fridge was not getting cold even if we keep at the highest level. The region around the door was getting hot as well.
During this time i got an AMC for my Double door Intellocool LG Refrigerator. It seems this unit is failing so often for most of the users of this range of Refrigerator based on the comments i saw googling the Internet. I paid Rs 1900+ for this AMC and is valid for three year and does not cover some aspect. Read the backside of the bill before you sign up. The replacement of unit atleast worked in my case.
During this time i got an AMC for my Double door Intellocool LG Refrigerator. It seems this unit is failing so often for most of the users of this range of Refrigerator based on the comments i saw googling the Internet. I paid Rs 1900+ for this AMC and is valid for three year and does not cover some aspect. Read the backside of the bill before you sign up. The replacement of unit atleast worked in my case.
Saturday, September 05, 2009
This is a incomplete list of IP address owner's in India
203.94.192.0 - 203.94.219.255 MTNL
203.98.96.0 - 203.98.127.255 Ortel communication
58.68.0.0 - 58.68.127.255 Dishnet Wireless Ltd India
58.146.96.0 - 58.146.96.255 Sainet
59.88.0.0 - 59.99.255.255 BSNLNET (NIB (National Internet Backbone))
59.144.0.0 - 59.144.255.255 BHARTI Airtel LTD.
59.160.0.0 -59.165.255.255 TATA Communications formerly VSNL is Leading ISP
59.176.0.0 - 59.185.255.255 MTNL CAT B ISP
203.94.192.0 - 203.94.219.255 MTNL
203.98.96.0 - 203.98.127.255 Ortel communication
58.68.0.0 - 58.68.127.255 Dishnet Wireless Ltd India
58.146.96.0 - 58.146.96.255 Sainet
59.88.0.0 - 59.99.255.255 BSNLNET (NIB (National Internet Backbone))
59.144.0.0 - 59.144.255.255 BHARTI Airtel LTD.
59.160.0.0 -59.165.255.255 TATA Communications formerly VSNL is Leading ISP
59.176.0.0 - 59.185.255.255 MTNL CAT B ISP
Other IP address allocated to India till date:
60.243.0.0 60.243.255.255
60.254.0.0 60.254.127.255
61.0.0.0 61.3.255.255
61.8.128.0 61.8.159.255
61.11.0.0 61.11.127.255
61.12.0.0 61.12.127.255
61.14.4.0 61.14.6.63
61.14.6.128 61.14.6.255
61.14.12.0 61.14.12.7
61.14.14.64 61.14.14.255
61.14.15.32 61.14.15.63
61.14.18.0 61.14.18.127
61.14.18.200 61.14.18.207
61.14.20.128 61.14.20.255
61.14.22.56 61.14.22.63
61.14.24.128 61.14.24.255
61.14.31.64 61.14.31.127
61.14.31.192 61.14.31.255
61.16.128.0 61.17.255.255
61.95.128.0 61.95.255.255
61.246.0.0 61.246.255.255
61.247.224.0 61.247.255.255
63.80.47.0 63.80.47.255
63.109.245.56 63.109.245.71
63.109.245.80 63.109.245.119
63.109.246.128 63.109.246.255
63.109.249.24 63.109.249.39
63.109.249.48 63.109.249.63
63.171.107.224 63.171.107.255
63.175.182.160 63.175.182.191
63.219.7.0 63.219.7.255
63.240.55.0 63.240.55.255
64.14.52.32 64.14.52.63
64.14.202.0 64.14.202.15
64.35.33.64 64.35.33.95
64.37.64.0 64.37.64.31
64.37.68.128 64.37.68.159
64.37.82.128 64.37.82.159
64.37.88.224 64.37.88.255
64.37.91.128 64.37.91.191
64.37.91.224 64.37.91.255
64.37.93.64 64.37.93.127
64.37.94.96 64.37.94.127
64.37.102.0 64.37.102.63
64.37.108.64 64.37.108.95
64.37.111.0 64.37.111.255
64.37.112.224 64.37.112.255
64.41.252.0 64.41.252.63
64.74.118.0 64.74.118.255
64.77.15.176 64.77.15.191
64.77.29.248 64.77.29.255
64.77.37.24 64.77.37.31
64.77.37.224 64.77.37.247
64.77.39.112 64.77.39.119
64.77.39.128 64.77.39.135
64.77.47.64 64.77.47.95
64.89.42.112 64.89.42.127
64.93.78.0 64.93.78.255
64.106.157.50 64.106.157.59
64.106.200.60 64.106.200.69
64.132.162.192 64.132.162.207
64.225.143.240 64.225.143.254
64.235.47.153 64.235.47.161
64.241.203.32 64.241.203.47
65.98.67.72 65.98.67.79
65.98.88.168 65.98.88.175
65.160.142.128 65.160.142.255
65.175.64.0 65.175.64.255
65.175.77.128 65.175.77.143
65.175.97.128 65.175.97.255
65.175.124.0 65.175.124.127
65.182.162.60 65.182.162.99
65.182.162.221 65.182.162.251
66.35.192.32 66.35.192.47
66.70.20.10 66.70.20.19
66.96.212.2 66.96.212.99
66.96.222.2 66.96.222.14
66.96.231.170 66.96.231.199
66.96.244.145 66.96.244.154
66.96.250.120 66.96.250.139
66.128.48.112 66.128.48.127
66.165.85.128 66.165.85.255
66.165.106.0 66.165.106.31
66.197.167.80 66.197.167.199
66.197.173.50 66.197.173.99
66.197.173.215 66.197.173.254
66.201.66.192 66.201.66.255
66.201.94.0 66.201.94.31
66.201.109.128 66.201.109.255
67.59.182.248 67.59.182.255
67.203.0.192 67.203.0.199
67.219.103.40 67.219.103.47
67.222.149.206 67.222.149.213
67.225.181.155 67.225.181.158
67.225.181.171 67.225.181.178
69.13.105.42 69.13.105.57
69.16.156.0 69.16.156.7
69.16.233.114 69.16.233.121
69.30.254.56 69.30.254.71
69.46.182.160 69.46.182.167
69.67.59.64 69.67.59.95
69.72.142.216 69.72.142.223
69.72.214.240 69.72.214.247
69.72.242.8 69.72.242.15
69.72.242.152 69.72.242.159
69.72.244.88 69.72.244.95
70.224.176.208 70.224.176.223
72.29.0.0 72.29.0.31
72.29.1.224 72.29.1.255
72.29.13.0 72.29.13.255
72.29.17.192 72.29.17.223
72.29.21.128 72.29.21.255
72.29.23.128 72.29.23.159
72.29.23.224 72.29.23.255
72.29.26.0 72.29.26.255
72.29.27.192 72.29.27.223
72.172.83.128 72.172.83.143
74.127.39.0 74.127.39.127
74.127.42.32 74.127.42.63
74.127.60.32 74.127.60.63
76.12.129.144 76.12.129.151
76.12.217.104 76.12.217.111
76.12.248.128 76.12.248.143
78.24.201.208 78.24.201.223
78.24.202.104 78.24.202.111
78.24.203.104 78.24.203.111
78.24.206.104 78.24.206.111
78.129.161.0 78.129.161.255
80.247.138.16 80.247.138.71
80.254.160.16 80.254.160.23
80.255.41.128 80.255.41.135
83.136.5.32 83.136.5.63
87.249.83.0 87.249.83.255
89.248.163.0 89.248.163.31
92.48.109.0 92.48.109.160
92.48.109.163 92.48.109.167
92.48.109.172 92.48.109.255
93.93.100.0 93.93.100.63
94.46.8.224 94.46.8.254
110.5.72.0 110.5.79.255
110.50.32.0 110.50.63.255
110.76.160.0 110.76.175.255
110.93.32.0 110.93.63.255
110.172.16.0 110.172.31.255
110.172.52.0 110.172.55.255
110.172.128.0 110.172.191.255
110.224.0.0 110.227.255.255
110.234.0.0 110.235.255.255
111.90.168.0 111.90.175.255
111.91.0.0 111.91.127.255
111.91.224.0 111.91.231.255
111.92.0.0 111.92.127.255
111.93.0.0 111.93.255.255
111.119.192.0 111.119.255.255
111.125.136.0 111.125.143.255
111.125.192.0 111.125.255.255
112.79.0.0 112.79.255.255
112.110.0.0 112.110.255.255
112.121.48.0 112.121.63.255
112.133.192.0 112.133.255.255
112.137.48.0 112.137.55.255
112.196.0.0 112.196.191.255
113.11.224.0 113.11.231.255
113.19.0.0 113.19.255.255
113.30.128.0 113.30.255.255
113.193.0.0 113.193.255.255
113.197.104.0 113.197.107.255
113.212.64.0 113.212.95.255
114.30.72.0 114.30.79.255
114.31.128.0 114.31.191.255
114.31.224.0 114.31.239.255
114.31.248.0 114.31.255.255
114.69.224.0 114.69.255.255
114.141.64.0 114.141.71.255
114.142.136.0 114.142.143.255
114.143.0.0 114.143.255.255
115.69.80.0 115.69.95.255
115.69.128.0 115.69.159.255
115.69.240.0 115.69.255.255
115.96.0.0 115.99.255.255
115.108.0.0 115.119.255.255
115.124.104.0 115.124.109.255
115.124.112.0 115.124.127.255
115.160.192.0 115.160.255.255
115.178.96.0 115.178.103.255
115.184.0.0 115.185.255.255
115.187.0.0 115.187.15.255
115.187.32.0 115.187.63.255
115.240.0.0 115.255.255.255
116.50.0.0 116.50.7.255
116.50.64.0 116.50.127.255
116.66.140.0 116.66.141.255
116.66.144.0 116.66.159.255
116.68.64.0 116.68.127.255
116.68.240.0 116.68.247.255
116.72.0.0 116.75.255.255
116.90.240.0 116.90.255.255
116.119.0.0 116.119.255.255
116.193.128.0 116.193.143.255
116.193.160.0 116.193.167.255
116.199.168.0 116.199.175.255
116.212.176.0 116.212.183.255
116.214.24.0 116.214.31.255
116.214.114.0 116.214.114.255
117.55.240.0 117.55.247.255
117.96.0.0 117.99.255.255
117.104.232.0 117.104.239.255
117.192.0.0 117.255.255.255
118.67.224.0 118.67.255.255
118.88.0.0 118.88.7.255
118.91.176.0 118.91.191.255
118.91.232.0 118.91.239.255
118.94.0.0 118.95.255.255
118.102.128.0 118.102.255.255
119.31.160.0 119.31.175.255
119.42.152.0 119.42.159.255
119.43.0.0 119.43.255.255
119.82.64.0 119.82.127.255
119.151.0.0 119.151.255.255
119.160.192.0 119.160.199.255
119.226.0.0 119.227.255.255
119.235.48.0 119.235.63.255
119.252.144.0 119.252.159.255
119.252.192.0 119.252.223.255
120.29.232.0 120.29.239.255
120.56.0.0 120.63.255.255
120.72.88.0 120.72.95.255
120.88.32.0 120.88.47.255
120.89.72.0 120.89.79.255
120.138.96.0 120.138.127.255
120.138.192.0 120.138.255.255
121.50.0.0 121.50.15.255
121.58.168.0 121.58.175.255
121.101.144.0 121.101.159.255
121.240.0.0 121.247.255.255
122.50.128.0 122.50.255.255
122.98.0.0 122.98.255.255
122.144.16.0 122.144.23.255
122.160.0.0 122.191.255.255
122.200.16.0 122.200.23.255
122.248.160.0 122.248.160.87
122.252.224.0 122.252.255.255
122.255.72.0 122.255.79.255
123.50.160.0 123.50.191.255
123.100.234.0 123.100.234.255
123.108.32.0 123.108.63.255
123.108.200.0 123.108.207.255
123.108.224.0 123.108.231.255
123.136.16.0 123.136.23.255
123.136.128.0 123.136.255.255
123.176.32.0 123.176.47.255
123.201.0.0 123.201.255.255
123.236.0.0 123.239.255.255
123.242.240.0 123.242.255.255
123.252.128.0 123.252.255.255
123.255.248.0 123.255.255.255
124.4.0.0 124.4.255.255
124.7.0.0 124.7.255.255
124.30.0.0 124.30.255.255
124.47.128.0 124.47.191.255
124.123.0.0 124.125.255.255
124.153.64.0 124.153.127.255
124.247.192.0 124.247.255.255
124.253.0.0 124.253.255.255
125.16.0.0 125.23.255.255
125.62.96.0 125.62.223.255
125.63.64.0 125.63.127.255
125.99.0.0 125.99.255.255
125.252.226.0 125.252.226.255
134.159.98.192 134.159.98.223
134.159.111.72 134.159.111.79
134.159.141.0 134.159.141.15
134.159.142.160 134.159.142.191
134.159.146.0 134.159.146.31
134.159.146.48 134.159.146.63
134.159.165.80 134.159.165.95
134.159.165.104 134.159.165.119
134.159.168.128 134.159.168.255
144.16.0.0 144.16.255.255
157.227.0.0 157.227.255.255
158.144.0.0 158.144.255.255
163.122.0.0 163.122.255.255
164.100.0.0 164.100.255.255
164.164.0.0 164.164.255.255
180.87.192.0 180.87.255.255
180.92.160.0 180.92.175.255
180.92.200.0 180.92.207.255
192.109.194.0 192.109.194.255
192.131.90.0 192.131.91.255
192.136.141.0 192.136.143.255
192.151.129.0 192.151.129.255
194.117.103.3 194.117.103.3
194.117.103.5 194.117.103.5
194.117.103.9 194.117.103.9
194.117.103.47 194.117.103.47
194.117.103.65 194.117.103.65
194.117.103.81 194.117.103.81
194.117.103.88 194.117.103.88
194.117.103.94 194.117.103.94
194.117.103.121 194.117.103.121
194.117.103.130 194.117.103.130
194.117.103.133 194.117.103.133
194.117.103.142 194.117.103.142
194.117.103.147 194.117.103.147
194.117.103.169 194.117.103.169
194.117.103.172 194.117.103.172
194.117.103.180 194.117.103.180
194.117.103.212 194.117.103.212
194.117.103.220 194.117.103.220
194.117.103.222 194.117.103.222
194.117.103.231 194.117.103.231
194.117.103.236 194.117.103.238
194.117.103.243 194.117.103.243
194.117.103.245 194.117.103.246
194.117.103.248 194.117.103.250
195.112.167.28 195.112.167.31
195.112.167.192 195.112.167.195
195.112.167.236 195.112.167.239
195.112.167.248 195.112.167.251
195.112.177.8 195.112.177.11
195.112.177.24 195.112.177.27
195.112.177.56 195.112.177.75
195.112.177.92 195.112.177.95
195.112.177.108 195.112.177.111
195.112.177.132 195.112.177.135
195.112.177.184 195.112.177.187
195.112.177.228 195.112.177.231
195.112.182.69 195.112.182.69
196.1.1.0 196.1.1.255
196.1.68.0 196.1.68.255
196.1.104.0 196.1.106.255
196.1.108.0 196.1.111.255
196.1.113.0 196.1.114.255
196.1.134.0 196.1.134.255
196.3.65.0 196.3.65.255
196.12.32.0 196.12.63.255
196.15.16.0 196.15.31.255
199.106.210.8 199.106.210.31
199.106.212.32 199.106.212.47
202.1.120.0 202.1.127.255
202.3.75.0 202.3.77.255
202.3.80.0 202.3.95.255
202.3.112.0 202.3.127.255
202.4.25.0 202.4.25.255
202.6.80.0 202.6.80.255
202.6.99.0 202.6.99.255
202.7.52.0 202.7.59.255
202.9.112.0 202.9.207.255
202.12.16.0 202.12.16.255
202.12.101.0 202.12.101.255
202.14.69.0 202.14.69.255
202.14.72.0 202.14.72.255
202.21.129.0 202.21.129.255
202.21.134.0 202.21.135.255
202.21.147.0 202.21.147.255
202.27.9.0 202.27.9.255
202.38.180.0 202.38.183.255
202.40.6.0 202.40.6.255
202.41.0.0 202.41.13.255
202.41.16.0 202.41.129.255
202.41.131.0 202.41.133.255
202.41.148.0 202.41.151.255
202.41.192.0 202.41.192.255
202.41.204.0 202.41.207.255
202.41.224.0 202.41.235.191
202.41.235.224 202.41.239.255
202.43.67.0 202.43.67.255
202.43.90.0 202.43.90.255
202.44.56.0 202.44.59.255
202.45.6.0 202.45.7.255
202.45.10.0 202.45.11.255
202.46.19.0 202.46.19.255
202.46.22.0 202.46.23.255
202.46.192.0 202.46.223.255
202.47.124.0 202.47.124.255
202.47.127.0 202.47.127.255
202.52.2.0 202.52.3.255
202.53.8.0 202.53.15.255
202.53.64.0 202.53.111.255
202.54.0.0 202.55.31.255
202.56.0.0 202.56.3.255
202.56.58.0 202.56.59.255
202.56.96.0 202.56.127.255
202.56.192.0 202.56.255.255
202.58.102.0 202.58.103.255
202.58.120.0 202.58.123.255
202.58.125.0 202.58.125.255
202.58.127.0 202.58.127.255
202.58.132.0 202.58.135.255
202.59.2.0 202.59.3.255
202.60.60.0 202.60.63.255
202.60.128.0 202.60.159.255
202.60.208.0 202.60.223.255
202.61.8.0 202.61.11.255
202.62.64.0 202.62.95.255
202.62.116.0 202.62.117.255
202.62.224.0 202.62.239.255
202.62.244.0 202.62.244.255
202.62.246.0 202.62.247.255
202.62.252.0 202.62.252.255
202.63.96.0 202.63.127.255
202.63.160.0 202.63.191.255
202.63.252.0 202.63.253.255
202.65.128.0 202.65.159.255
202.67.4.0 202.67.7.255
202.68.128.0 202.68.159.255
202.70.192.0 202.70.207.255
202.71.128.0 202.71.159.255
202.72.248.0 202.72.251.255
202.75.192.0 202.75.207.255
202.77.137.0 202.77.137.255
202.78.160.0 202.78.175.255
202.78.232.0 202.78.239.255
202.78.251.0 202.78.251.255
202.79.248.0 202.79.251.255
202.80.48.0 202.80.63.255
202.81.128.0 202.81.159.255
202.81.192.0 202.81.207.255
202.83.16.0 202.83.63.255
202.86.4.0 202.86.7.255
202.86.251.0 202.86.251.255
202.87.32.0 202.87.63.255
202.88.128.0 202.88.191.255
202.88.208.0 202.88.255.255
202.89.64.0 202.89.79.255
202.89.104.0 202.89.111.255
202.89.118.0 202.89.119.255
202.90.96.0 202.90.111.255
202.90.192.0 202.90.192.255
202.90.204.0 202.90.204.255
202.91.64.0 202.91.95.255
202.91.132.0 202.91.143.255
202.92.8.0 202.92.15.255
202.92.224.0 202.92.239.255
202.93.154.0 202.93.154.255
202.95.251.0 202.95.251.255
202.122.16.0 202.122.23.255
202.122.134.0 202.122.135.255
202.123.32.0 202.123.47.255
202.129.196.0 202.129.203.255
202.129.209.0 202.129.213.255
202.129.215.0 202.129.215.255
202.129.219.0 202.129.219.255
202.129.239.0 202.129.241.255
202.130.40.0 202.130.43.255
202.131.96.0 202.131.159.255
202.133.48.0 202.133.63.255
202.134.59.0 202.134.59.255
202.134.144.0 202.134.207.255
202.136.248.0 202.136.251.255
202.137.208.0 202.137.223.255
202.137.232.0 202.137.239.255
202.137.248.0 202.137.251.255
202.138.96.0 202.138.127.255
202.140.32.0 202.140.63.255
202.140.128.0 202.140.159.255
202.141.0.0 202.141.159.255
202.142.0.0 202.142.7.255
202.142.64.0 202.142.127.255
202.143.0.0 202.143.1.255
202.143.4.0 202.143.7.255
202.144.0.0 202.144.127.255
202.146.192.0 202.146.207.255
202.148.192.0 202.148.207.255
202.149.32.0 202.149.63.255
202.149.192.0 202.149.223.255
202.150.4.0 202.150.7.255
202.151.128.0 202.151.159.255
202.153.32.0 202.153.47.255
202.154.160.0 202.154.175.255
202.157.64.0 202.157.95.255
202.157.190.0 202.157.191.255
202.159.192.0 202.159.255.255
202.160.160.0 202.160.175.255
202.160.239.0 202.160.239.255
202.162.48.0 202.162.63.255
202.162.188.0 202.162.191.255
202.162.224.0 202.162.255.255
202.164.24.0 202.164.25.255
202.164.32.0 202.164.63.255
202.164.128.0 202.164.159.255
202.165.62.0 202.165.63.255
202.166.184.0 202.166.184.255
202.168.88.0 202.168.91.255
202.168.94.0 202.168.94.255
202.171.234.0 202.171.234.255
202.172.7.0 202.172.7.255
202.174.5.0 202.174.5.255
202.174.92.0 202.174.95.255
202.174.120.0 202.174.120.255
202.174.122.0 202.174.127.255
202.174.148.136 202.174.148.143
202.177.44.0 202.177.47.255
202.177.128.0 202.177.191.255
202.177.224.0 202.177.255.255
202.179.64.0 202.179.95.255
202.183.64.0 202.183.79.255
202.189.224.0 202.189.255.255
202.191.64.0 202.191.95.255
202.242.2.111 202.242.2.111
203.8.109.0 203.8.109.255
203.12.222.0 203.12.223.255
203.13.168.0 203.13.171.255
203.14.18.0 203.14.18.255
203.16.165.0 203.16.165.255
203.18.26.0 203.18.26.255
203.18.137.0 203.18.137.255
203.19.3.0 203.19.3.255
203.21.7.0 203.21.7.255
203.23.186.0 203.23.186.255
203.24.87.0 203.24.87.255
203.27.235.0 203.27.235.255
203.32.4.0 203.32.5.255
203.32.221.0 203.32.221.255
203.33.198.0 203.33.199.255
203.34.116.0 203.34.117.255
203.55.160.0 203.55.160.255
203.55.173.0 203.55.173.255
203.56.241.0 203.56.241.255
203.56.255.224 203.56.255.239
203.62.172.0 203.62.175.255
203.76.128.0 203.76.143.255
203.76.168.0 203.76.171.255
203.76.176.0 203.76.191.255
203.77.177.0 203.77.177.255
203.77.192.0 203.77.207.255
203.78.4.0 203.78.4.255
203.78.128.0 203.78.159.255
203.78.208.0 203.78.223.255
203.82.4.0 203.82.7.255
203.82.218.0 203.82.218.255
203.82.250.0 203.82.251.255
203.83.248.0 203.83.249.255
203.86.96.0 203.86.127.255
203.88.0.0 203.88.31.255
203.88.128.0 203.88.159.255
203.89.4.0 203.89.4.255
203.89.132.0 203.89.132.255
203.89.134.0 203.89.135.255
203.89.151.0 203.89.155.255
203.90.4.0 203.90.5.255
203.90.64.0 203.90.127.255
203.91.192.0 203.91.223.255
203.92.32.0 203.92.63.255
203.92.192.0 203.92.207.255
203.94.192.0 203.94.255.255
203.98.96.0 203.98.127.255
203.98.193.64 203.98.193.127
203.98.193.224 203.98.193.239
203.98.194.128 203.98.195.23
203.98.195.32 203.98.195.39
203.98.205.128 203.98.205.159
203.98.205.176 203.98.205.207
203.98.207.64 203.98.207.79
203.98.207.160 203.98.207.191
203.98.210.112 203.98.210.127
203.98.213.208 203.98.213.255
203.99.40.0 203.99.47.255
203.99.192.0 203.99.223.255
203.100.57.0 203.100.57.255
203.100.64.0 203.100.79.255
203.101.0.0 203.101.127.255
203.104.16.0 203.104.23.255
203.105.160.0 203.105.191.255
203.109.64.0 203.109.127.255
203.110.80.0 203.110.95.255
203.110.208.0 203.110.223.255
203.110.240.0 203.110.247.255
203.111.248.0 203.111.251.255
203.112.128.0 203.112.159.255
203.114.232.0 203.114.235.255
203.114.240.0 203.114.243.255
203.115.64.0 203.115.127.255
203.119.49.0 203.119.50.255
203.122.0.0 203.122.63.255
203.123.32.0 203.123.47.255
203.123.128.0 203.123.191.255
203.123.247.192 203.123.247.195
203.124.16.0 203.124.23.255
203.124.128.0 203.124.175.255
203.124.192.0 203.124.255.255
203.129.192.0 203.129.255.255
203.132.128.0 203.132.159.255
203.132.208.0 203.132.223.255
203.134.192.0 203.134.231.255
203.134.248.0 203.134.251.255
203.135.188.0 203.135.188.255
203.142.220.0 203.142.220.255
203.143.176.0 203.143.191.255
203.144.96.0 203.144.127.255
203.145.128.0 203.145.191.255
203.147.88.0 203.147.91.255
203.153.32.0 203.153.48.255
203.153.52.0 203.153.55.255
203.153.210.0 203.153.211.255
203.158.64.0 203.158.95.255
203.160.129.0 203.160.129.255
203.160.136.0 203.160.136.255
203.160.138.0 203.160.139.255
203.161.54.0 203.161.63.255
203.163.95.24 203.163.95.31
203.163.224.0 203.163.255.255
203.170.25.0 203.170.25.255
203.170.48.0 203.170.48.255
203.170.60.0 203.170.63.255
203.171.209.0 203.171.211.255
203.171.222.0 203.171.222.255
203.171.240.0 203.171.247.255
203.174.6.0 203.174.6.255
203.175.4.0 203.175.7.255
203.175.176.0 203.175.177.255
203.175.180.0 203.175.185.255
203.176.112.0 203.176.113.255
203.185.188.0 203.185.188.255
203.185.191.0 203.185.191.255
203.187.128.0 203.187.159.255
203.187.192.0 203.187.255.255
203.188.224.0 203.188.231.255
203.189.5.0 203.189.5.255
203.189.24.0 203.189.24.255
203.189.90.0 203.189.92.255
203.189.176.0 203.189.183.255
203.190.128.0 203.190.159.255
203.190.216.0 203.190.216.255
203.190.248.0 203.190.248.255
203.191.5.0 203.191.5.255
203.191.34.0 203.191.35.255
203.192.192.0 203.192.255.255
203.193.128.0 203.193.191.255
203.194.96.0 203.194.111.255
203.196.128.0 203.197.255.255
203.199.0.0 203.200.255.255
203.201.60.0 203.201.63.255
203.201.192.0 203.201.255.255
203.207.62.0 203.207.63.255
203.210.92.0 203.210.95.255
203.212.24.0 203.212.27.255
203.212.64.0 203.212.79.255
203.212.192.0 203.212.255.255
203.215.51.0 203.215.55.255
203.217.136.0 203.217.139.255
203.217.144.0 203.217.147.255
203.217.174.0 203.217.174.255
203.222.166.136 203.222.166.143
203.222.171.176 203.222.171.191
203.222.187.128 203.222.187.167
203.222.187.192 203.222.187.255
203.223.176.0 203.223.176.255
203.223.188.0 203.223.191.255
204.176.100.240 204.176.100.255
205.134.225.128 205.134.225.135
205.138.24.128 205.138.24.255
205.214.74.24 205.214.74.39
205.214.74.48 205.214.74.63
205.214.74.80 205.214.74.95
205.214.83.24 205.214.83.31
205.234.150.32 205.234.150.39
205.234.172.192 205.234.172.255
205.234.179.144 205.234.179.151
206.73.45.0 206.73.45.127
206.182.89.128 206.182.89.191
206.182.192.112 206.182.192.127
206.222.7.224 206.222.7.231
206.225.94.243 206.225.94.250
207.198.105.198 207.198.105.211
207.210.211.192 207.210.211.215
207.210.233.0 207.210.233.255
208.91.131.80 208.91.131.87
208.112.115.16 208.112.115.23
208.115.109.0 208.115.109.63
208.116.54.24 208.116.54.31
208.116.54.232 208.116.54.239
208.123.68.64 208.123.68.87
208.149.96.0 208.149.99.255
209.16.208.48 209.16.208.63
209.18.84.220 209.18.84.229
209.51.196.160 209.51.196.167
209.51.198.112 209.51.198.119
209.51.210.48 209.51.210.63
209.67.40.16 209.67.40.31
209.85.12.96 209.85.12.127
209.85.19.224 209.85.19.255
209.85.53.160 209.85.53.175
209.95.103.160 209.95.103.191
209.182.35.64 209.182.35.127
209.182.60.0 209.182.60.255
209.182.61.128 209.182.61.255
209.190.29.16 209.190.29.23
209.190.31.96 209.190.31.103
209.190.88.0 209.190.88.255
209.197.225.48 209.197.225.55
209.200.228.61 209.200.228.69
209.203.226.64 209.203.226.95
209.227.223.160 209.227.223.175
209.250.147.224 209.250.147.255
210.5.200.0 210.5.203.255
210.5.209.192 210.5.209.207
210.5.209.224 210.5.209.231
210.7.64.0 210.7.95.255
210.18.0.0 210.18.191.255
210.56.96.0 210.56.127.255
210.89.32.0 210.89.63.255
210.176.32.32 210.176.32.63
210.176.32.96 210.176.44.63
210.176.44.160 210.176.47.255
210.210.0.0 210.210.127.255
210.211.128.0 210.212.255.255
210.214.0.0 210.214.255.255
212.63.167.124 212.63.167.127
212.63.181.64 212.63.181.67
212.63.181.80 212.63.181.91
212.63.181.108 212.63.181.111
212.63.181.120 212.63.181.131
212.63.181.136 212.63.181.139
212.63.181.152 212.63.181.163
212.63.181.172 212.63.181.179
212.63.181.188 212.63.181.195
212.63.181.220 212.63.181.223
212.63.181.248 212.63.181.251
212.63.182.54 212.63.182.54
212.63.182.76 212.63.182.79
212.63.183.6 212.63.183.6
212.63.183.12 212.63.183.12
212.63.183.17 212.63.183.17
212.63.183.24 212.63.183.25
212.63.183.34 212.63.183.35
212.63.183.41 212.63.183.41
212.63.183.43 212.63.183.43
212.63.183.45 212.63.183.45
212.63.183.54 212.63.183.54
212.63.183.70 212.63.183.70
212.63.183.72 212.63.183.73
212.63.183.78 212.63.183.79
212.63.183.83 212.63.183.84
212.63.183.88 212.63.183.88
212.63.183.90 212.63.183.91
212.63.183.94 212.63.183.94
212.63.183.128 212.63.183.131
212.63.183.136 212.63.183.151
212.63.183.160 212.63.183.167
212.63.183.200 212.63.183.203
212.63.183.232 212.63.183.235
212.63.183.240 212.63.183.243
212.63.183.252 212.63.183.255
212.162.195.0 212.162.195.51
212.162.195.56 212.162.195.59
212.162.196.0 212.162.196.95
212.165.133.0 212.165.133.255
212.165.136.0 212.165.139.255
212.165.146.24 212.165.146.31
212.165.146.120 212.165.146.127
216.6.64.0 216.6.71.255
216.7.173.112 216.7.173.127
216.15.130.160 216.15.130.175
216.15.133.192 216.15.133.223
216.15.154.160 216.15.154.191
216.15.157.0 216.15.157.31
216.15.157.224 216.15.157.255
216.15.160.0 216.15.160.127
216.15.168.0 216.15.168.63
216.15.179.0 216.15.179.31
216.15.179.160 216.15.179.191
216.15.179.226 216.15.179.255
216.15.182.96 216.15.182.127
216.15.192.64 216.15.192.127
216.15.200.128 216.15.200.191
216.15.204.128 216.15.204.159
216.15.223.64 216.15.223.91
216.15.225.128 216.15.225.255
216.15.228.128 216.15.228.255
216.15.230.128 216.15.230.255
216.15.231.128 216.15.231.255
216.15.237.0 216.15.237.127
216.15.239.0 216.15.239.127
216.38.48.46 216.38.48.49
216.38.48.209 216.38.48.212
216.38.50.51 216.38.50.58
216.38.50.251 216.38.50.254
216.38.51.30 216.38.51.33
216.38.51.114 216.38.51.117
216.38.51.128 216.38.51.131
216.38.51.168 216.38.51.171
216.38.51.236 216.38.51.239
216.38.51.253 216.38.51.254
216.38.52.43 216.38.52.47
216.38.53.180 216.38.53.183
216.38.53.252 216.38.53.253
216.38.55.24 216.38.55.27
216.38.55.122 216.38.55.125
216.38.56.88 216.38.56.95
216.38.56.248 216.38.56.255
216.38.62.26 216.38.62.29
216.38.62.246 216.38.62.249
216.38.63.230 216.38.63.233
216.40.100.104 216.40.100.111
216.67.245.96 216.67.245.103
216.131.114.232 216.131.114.239
216.136.178.16 216.136.178.31
216.144.239.64 216.144.239.95
216.151.162.56 216.151.162.63
216.151.162.160 216.151.162.167
216.151.162.184 216.151.162.191
216.151.163.32 216.151.163.63
216.151.163.152 216.151.163.159
216.187.101.128 216.187.101.255
216.198.194.96 216.198.194.127
216.198.194.160 216.198.194.191
216.198.199.64 216.198.199.95
216.198.201.128 216.198.201.225
216.198.202.128 216.198.202.255
216.198.203.128 216.198.203.255
216.198.204.96 216.198.204.127
216.198.210.0 216.198.210.255
216.198.217.0 216.198.217.63
216.198.222.128 216.198.222.255
216.198.235.160 216.198.235.191
216.198.236.0 216.198.236.127
216.198.237.0 216.198.237.127
216.198.241.128 216.198.241.255
216.198.244.8 216.198.244.15
216.198.244.48 216.198.244.55
216.198.251.0 216.198.251.31
216.198.251.96 216.198.251.127
216.198.251.160 216.198.251.191
216.218.236.64 216.218.236.95
216.236.200.136 216.236.200.167
216.236.201.128 216.236.201.135
216.236.203.0 216.236.203.255
216.237.117.128 216.237.117.255
218.100.48.0 218.100.49.255
218.248.0.0 218.248.255.255
219.64.0.0 219.65.255.255
219.83.128.0 219.83.255.255
219.90.96.0 219.90.111.255
219.91.128.0 219.91.255.255
220.156.184.0 220.156.191.255
220.224.0.0 220.227.255.255
221.120.104.0 221.120.111.255
221.128.128.0 221.128.255.255
221.134.0.0 221.135.255.255
Sunday, August 09, 2009
online fixed deposit
Long ago, i remember standing in front of the bank manager to get a Fixed deposit (FD) made. Now with Internet banking you could do this online. But it seems different banks follow different processes:
ICICI Bank
You can start online and the FD receipt is mailed to you. Though u have option to terminate and deposit back the money to savings account, it always renew it.
SBI Bank
You can start it as explained here. But after this you have to go to the corresponding branch to collect the FD receipt. Still it is better as now you can go any day and collect it in few minutes as every other process is done. It is also automatically renewed.
ICICI Bank
You can start online and the FD receipt is mailed to you. Though u have option to terminate and deposit back the money to savings account, it always renew it.
SBI Bank
You can start it as explained here. But after this you have to go to the corresponding branch to collect the FD receipt. Still it is better as now you can go any day and collect it in few minutes as every other process is done. It is also automatically renewed.
Wednesday, July 29, 2009
Which option is good in mutual fund?
In India, we get three options for mutual fund: Growth (where once you buy your investment grows or drops till u decide to sell), Dividend (Regular/irregular money is paid as dividend as a percentage of the face value), Dividend reinvestment option (The dividend so released is reinvested).
Now i have done quite a lot of study on which one is better and i have picked the Dividend option. Let me argue it out in the next few paragraphs. This is valid only for equity mutual fund and not logical for the income/debt mutual fund.
Let us assume that i decide to invest Rs 5000 on a NFO or an existing mutual fund and assuming the face value or the present value is 100 i get 50 shares of mutual fund. The dividend scheme gave 50% dividend in the first year itself as the market was really good. Now i decide to sell after 2 years and take out 3500 due to some unforeseen scenario (Effectively delaying is non-negotiable) and that the market had tanked and my mutual fund return on this day went down by 25% from the face value at which i bought. So let us see how the three different scheme perform:
So till rules of the game change, i will bet on dividend option for Equity.
Now i have done quite a lot of study on which one is better and i have picked the Dividend option. Let me argue it out in the next few paragraphs. This is valid only for equity mutual fund and not logical for the income/debt mutual fund.
Let us assume that i decide to invest Rs 5000 on a NFO or an existing mutual fund and assuming the face value or the present value is 100 i get 50 shares of mutual fund. The dividend scheme gave 50% dividend in the first year itself as the market was really good. Now i decide to sell after 2 years and take out 3500 due to some unforeseen scenario (Effectively delaying is non-negotiable) and that the market had tanked and my mutual fund return on this day went down by 25% from the face value at which i bought. So let us see how the three different scheme perform:
- Option 1 (Growth): End of two year i get 75 per share or my investment is Rs 3500/-. I sell all my shares and get back my 3500.
- Option 2 (Dividend): After the dividend my MF value is 50/- (as 50 was given in first year) in dividend option. I have 2500 as dividend tax free. It gets 5% interest from bank (after catering to Income Tax) and after one year it is 2500+125= 2625/-. On second year, as in growth option my value tanks by 25%. SO it is now Rs 37.5. I have already 2625 in bank. so i need the to sell 24 shares to get the remaining 900/-. So i am still left with 975 rupees (in my mutual fund even after meeting my exigencies) which again can go up.
- Option 3 (Dividend reinvestment option): The 50 i got in dividend is reinvested at 50 per share. so i get additional 48 shares (taking care of entry load of 2.25%). so in total i have 98 shares @ Rs 50 in year 1. Now in Year 2 when i sell as i mentioned earlier market tanked by 25% and share value is 37.5. so to get 3500 for my exigencies i sell 94 shares which is worth 3525/-. So now i have 4 shares with value 150. So advantage over option 1 is i made 175 (25 in cash and 150 worth stock which can go up in future)
So till rules of the game change, i will bet on dividend option for Equity.
Saturday, July 18, 2009
Rating Airlines in India
This is as per my rating with the airlines having flown at least 5+ in each of these flights. I intend to review it as and when i get time. And strangely Indigo charts quite high with their great on time service. They have the unique way to fill up the aircraft well ahead of the boarding time. So never have any delay and are on dot with respect to their time commitments.
The overall rating of mine is highly biased towards ontime!! And sadly now i find the lack of table creation in Blogger a serious drawback.
The overall rating of mine is highly biased towards ontime!! And sadly now i find the lack of table creation in Blogger a serious drawback.
Sunday, July 12, 2009
Chicken pox and local/allopathy medicines
Recently i was down with Chicken pox. I sepnd some time going through the web on some good blog on it. But could not find any. So i thought will write one when i am cured.
Chicken pox was confirmed by my doctor on seeing dew drop shaped blister in stomach and back area. There seems to be many variations of it like Herpes.
Medicine:
I had Acyclovir-200mg 3 times a day (anti-viral has good effect if u start having it as soon as u see the first blisters), Paracetomol (in case i had fever, i never used it as i never got fever), Citrizine (For reducing itching 1 1/2 per day), Amoxicillin (To prevent secondary infection). Check with you doctor for the right medication.
Food:
Chicken pox was confirmed by my doctor on seeing dew drop shaped blister in stomach and back area. There seems to be many variations of it like Herpes.
Medicine:
I had Acyclovir-200mg 3 times a day (anti-viral has good effect if u start having it as soon as u see the first blisters), Paracetomol (in case i had fever, i never used it as i never got fever), Citrizine (For reducing itching 1 1/2 per day), Amoxicillin (To prevent secondary infection). Check with you doctor for the right medication.
Food:
- Avoid spicy food completely as higher chilli, spices and other exothermic food as it makes the body hot.This can causes more blisters to come both within and outside the body
- Have lot of fruits and vegetables
- Lemon is good and can be used as a replacement for salt in salads.
- Have curd. For lunch, rice + curd + salads will be a good combination.
- Take lot of tender coconut water as it is good to build your immune system.
- Take complete rest and avoid reading and any strainful exercise which heats up the body
- Cool your body under fan as the area which locally gets hot will cause the blisters to erupt. Ensure that no area gets hot even when you sleep.
- You can sleep with neem leaves spread on the cot as it allows to keep the body part facing the cot cool.
- Do not break the blisters as it will cause more time to cure.
- Avoid bathing till the blisters dries off which will take 8-12 days (with Acyclovir!!)
- When you bath avoid soap and bath in warm water with neem leaves added to it.
- For few days after the attack bath without soap and use neem leaves.
Tuesday, April 28, 2009
Bigger organisation bound to fail
Nature from its million year history has taught us one important concept. Being bigger need not mean sure survival. I am a great believer of natural selection and if we believe that Humans were "preferred" over dinosaur then nature selects smarter organization over bigger organization. Now if you have tracked the working of a company this is a clear dilemma faced daily by any organization. If i have to grow year after year how do i do it?
The usual process is to enter newer domains, invest in more fields and then naturally the solution for growing/improving your capacity is growing bigger. But nature has taught us that it is a wrong approach. So what is the solution? Partnership.
No one human can do all the diverse work in the world today simultaneously but may be can do all task individually. Then we are good at some thing we concentrate on that and cooperate with others to get all my other tasks done. The more i cooperate the more i grow. May be organizations have to put in place the same philosophy. If i need to grow enter new domain but then you need not do everything in that new domain, get a partner who is really good in that field and see with your own innate skills how can you add value to that partnership and use it grow your organization.
For example, if i am an organization too good to sell soaps through a good sales and distribution channel and now if you have to grow your revenue all you have to do is that get a low cost producer of a shampoo product line who is good at "producing" shampoo but not at distributing it.. Now you have a good distribution channel which does sell soap and majority of the same set of customer also uses shampoo.. and this partnership is a clear winner.. you combined two processes and then you now have an efficient model allowing both the companies to grow.. Why is this better than i making a new division by recruiting the best guys who can make shampoo? I now need zero investment in R&D and then i can leverage the cost advantage of my partner who already has some volumes before the partnership.. I get a great time to market advantage.. The shampoo partner should be good in his field as he has more experience than me in shampoo making..
And is this model a creation of my whims and fancy.. you see organisation which patrnered working far more sucessfully than the one which grew monolithically.. you see jitters in big organisations like GM, Citi than in the newer companies which leverages the partnership models.. Hope this recession kill the dinosaur and restart the era of Humans in business models and organizations..
The usual process is to enter newer domains, invest in more fields and then naturally the solution for growing/improving your capacity is growing bigger. But nature has taught us that it is a wrong approach. So what is the solution? Partnership.
No one human can do all the diverse work in the world today simultaneously but may be can do all task individually. Then we are good at some thing we concentrate on that and cooperate with others to get all my other tasks done. The more i cooperate the more i grow. May be organizations have to put in place the same philosophy. If i need to grow enter new domain but then you need not do everything in that new domain, get a partner who is really good in that field and see with your own innate skills how can you add value to that partnership and use it grow your organization.
For example, if i am an organization too good to sell soaps through a good sales and distribution channel and now if you have to grow your revenue all you have to do is that get a low cost producer of a shampoo product line who is good at "producing" shampoo but not at distributing it.. Now you have a good distribution channel which does sell soap and majority of the same set of customer also uses shampoo.. and this partnership is a clear winner.. you combined two processes and then you now have an efficient model allowing both the companies to grow.. Why is this better than i making a new division by recruiting the best guys who can make shampoo? I now need zero investment in R&D and then i can leverage the cost advantage of my partner who already has some volumes before the partnership.. I get a great time to market advantage.. The shampoo partner should be good in his field as he has more experience than me in shampoo making..
And is this model a creation of my whims and fancy.. you see organisation which patrnered working far more sucessfully than the one which grew monolithically.. you see jitters in big organisations like GM, Citi than in the newer companies which leverages the partnership models.. Hope this recession kill the dinosaur and restart the era of Humans in business models and organizations..
Monday, March 23, 2009
"Gadget.in" Review
I recently wanted to buy a charger for my Olympus camera C-770UZ. I was lazy to go to the market and search for it. I looked for this at few camera distributors and none of them had it. So i searched in the web. What i wanted was a Li-10B battery charger and i found the same in the site Gadget.In. I booked for the charger online after consulting their help desk. Help desk was very cooperative in helping me with all the payment gateway issue.
After three days flat i got the delivery (though they have committed only 5 days) but when i opened it i was in for a surprise. The charger was not original Olympus and was a poor cousin of the same. It was not professional packaging but i thought may be they ad packed it for some extra covering, but it was the actual cover. But i never had hoped to get an OEM product. I then went through the website again and found that they have small note at the end of the product display mentioning that it is not made by Olympus!! also they have mentioned that the image is not the actual image. so be careful when you to buy online as i now paid for my laziness. Does it work? It has a max rating of 600mAh but it took me full 4 hours to charge (rather than theoritical 2 hrs as my battery rating is 1050mAh). Also with my earlier Olympus charger i used to charge in 1-1.5 hrs. So turned out to be a costly mistake!!
After three days flat i got the delivery (though they have committed only 5 days) but when i opened it i was in for a surprise. The charger was not original Olympus and was a poor cousin of the same. It was not professional packaging but i thought may be they ad packed it for some extra covering, but it was the actual cover. But i never had hoped to get an OEM product. I then went through the website again and found that they have small note at the end of the product display mentioning that it is not made by Olympus!! also they have mentioned that the image is not the actual image. so be careful when you to buy online as i now paid for my laziness. Does it work? It has a max rating of 600mAh but it took me full 4 hours to charge (rather than theoritical 2 hrs as my battery rating is 1050mAh). Also with my earlier Olympus charger i used to charge in 1-1.5 hrs. So turned out to be a costly mistake!!
Wednesday, March 18, 2009
Banking ombudsman in India
Recently i had a problem with my cheque. I had put the date on the cheque carelessly as 2008 instead of 2009!! (My mistake..) and when it was given by my client without checking the date i got a fine of around 1% the cheque amount by ICICI. This even though i have enough balance in my account. So is this mistake so deadly to be fined without informing me?
Giving a cheque which can be honored is illegal and is ethical. But giving a cheque which could be honored but with a wrong date does not require to be penalized as i think it is unethical. I filed a compliant to ICICI as i was not aware of this clause which is think is completely unreasonable. They call me for each and everything from credit card to personal loans, and i think it is quite reasonable for them to call me and ask if it is a mistake or not? I got a response from ICICI telling that "cheque out of date" carries this fine and they cannot reimburse it. Hence i filed a case with Banking Ombudsman. I have only heard of institution through the paper and did not know how it work. I got the mail id from their website and filed a complaint as it just means a mail for me (And kudos to Internet without which i would not have bothered with this!!). But in less than a month or so i got a call from ICICI branch Manager telling that the fine is reimbursed based on my compliant to ombudsman. But he insisted that it is depicted properly in the banking charges.
I also got a letter from ICICI on my compliant informing me that the money has been refunded and an attachment of all the charges. This is an exhaustive list and i request all ICICI customers to keep it handy. Then specifically about my charge it comes under a heading "Cheque return due to non-financial reasons" as 50 + Service tax. Now what are the "non-financial reasons" by which one can get a cheque returned? This is not covered. I hope banking ombudsman will come out with some guidlines to bring in more transperancy in all aspect of banking.
Hope this experience of mine would allow each of you to use the institution of Ombudsman so that we make a far better banking system where everything is transparent. Let us learn from the mistakes of US banking system where lack of transparency has got them into a situation where institutions of experience panning 100 years turned moribund. We should ensure such mistakes never gets repeated in India.
Impressed by my experience one of my friend tried this with his insurance premium payment problem and he also got the problem solved in 2 weeks which he through direct phone calls was not able to solve in more than 2 months. So thankyou ombudsman and thanks to all the politicians who framed this law!!
Giving a cheque which can be honored is illegal and is ethical. But giving a cheque which could be honored but with a wrong date does not require to be penalized as i think it is unethical. I filed a compliant to ICICI as i was not aware of this clause which is think is completely unreasonable. They call me for each and everything from credit card to personal loans, and i think it is quite reasonable for them to call me and ask if it is a mistake or not? I got a response from ICICI telling that "cheque out of date" carries this fine and they cannot reimburse it. Hence i filed a case with Banking Ombudsman. I have only heard of institution through the paper and did not know how it work. I got the mail id from their website and filed a complaint as it just means a mail for me (And kudos to Internet without which i would not have bothered with this!!). But in less than a month or so i got a call from ICICI branch Manager telling that the fine is reimbursed based on my compliant to ombudsman. But he insisted that it is depicted properly in the banking charges.
I also got a letter from ICICI on my compliant informing me that the money has been refunded and an attachment of all the charges. This is an exhaustive list and i request all ICICI customers to keep it handy. Then specifically about my charge it comes under a heading "Cheque return due to non-financial reasons" as 50 + Service tax. Now what are the "non-financial reasons" by which one can get a cheque returned? This is not covered. I hope banking ombudsman will come out with some guidlines to bring in more transperancy in all aspect of banking.
Hope this experience of mine would allow each of you to use the institution of Ombudsman so that we make a far better banking system where everything is transparent. Let us learn from the mistakes of US banking system where lack of transparency has got them into a situation where institutions of experience panning 100 years turned moribund. We should ensure such mistakes never gets repeated in India.
Impressed by my experience one of my friend tried this with his insurance premium payment problem and he also got the problem solved in 2 weeks which he through direct phone calls was not able to solve in more than 2 months. So thankyou ombudsman and thanks to all the politicians who framed this law!!
Thursday, March 05, 2009
Renewing expired Gas connection
Recently, i had a shock i was running low on my LPG and then when i placed an order for a new cylinder they told my connection has expired!! If we do not order any new gas cylinder for 6 months it seems the gove gas agency in my case Indane Gas will expire. Now you to do a whole set of procedure as mentioned below:
- Write a letter giving reasons on why you did not buy any new cylinder in last 6 months
- A copy of your original gas connection document
- Carry regulator and tube
Thursday, January 08, 2009
Excel Macro
Below is a macro i have written for excel which goes through multiple sheets one after another and searches for keywords in a specified column and then generate a master sheet with those rows.
Sub CopySearchedResult()
'Authored by Jishnu A under GPL!! :)
Dim sh1 As Worksheet
Dim sh As Worksheet
Dim rng As Range, rng2 As Range
Dim dest As Range, cell As Range
Dim SearchColNum As Integer
Dim SearchString1 As String
Dim SearchString2 As String
Dim OutputFile As String
OutputFile = "Master"
'Before creating master sheet checks if it exist and delete any older version
If SheetExists(OutputFile) = True Then
Sheets(OutputFile).Select
ActiveWindow.SelectedSheets.Delete
Application.StatusBar = "The " & OutputFile & "already exists and is Deleted"
End If
Set sh1 = Worksheets.Add
sh1.Name = OutputFile
Application.StatusBar = "New" & OutputFile & "is Created"
' This is the variable where one needs to mention the column number for search
' For example Column B should have SearchColNum = 2
SearchColNum = 6
'This are the search strings which has to be looked for in the above column number
' These search strings are "Or" ed in the macro below
' Which can be changed as "And" or other expressions
SearchString1 = "keyword1"
SearchString2 = "keyword2"
' Mention the worksheets which needs to be searched with names "Sheet1", "Sheet2" etc
' and the last digit should be mentioned as the last value of i in the expression below
For i = 1 To 8
Set sh = Worksheets("Sheet" & i)
Set rng = sh.Range(sh.Cells(2, SearchColNum), sh.Cells(Rows.Count, SearchColNum).End(xlUp))
Set rng2 = Nothing
For Each cell In rng
If InStr(cell.Value, SearchString1) > 0 Or InStr(cell.Value, SearchString2) > 0 Then
If rng2 Is Nothing Then
Set rng2 = cell
Else
Set rng2 = Union(rng2, cell)
End If
End If
Next
If Not rng2 Is Nothing Then
Set dest = sh1.Range("A" & sh1.Cells(Rows.Count, SearchColNum).End(xlUp).Row + 1)
rng2.EntireRow.Copy dest
End If
Next
Application.StatusBar = "Finished with the process.."
End Sub
' It checks if a particular sheet exist
Function SheetExists(SName As String, Optional ByVal WB As Workbook) As Boolean
On Error Resume Next
If WB Is Nothing Then Set WB = ThisWorkbook
SheetExists = CBool(Len(Sheets(SName).Name))
End Function
Sub CopySearchedResult()
'Authored by Jishnu A under GPL!! :)
Dim sh1 As Worksheet
Dim sh As Worksheet
Dim rng As Range, rng2 As Range
Dim dest As Range, cell As Range
Dim SearchColNum As Integer
Dim SearchString1 As String
Dim SearchString2 As String
Dim OutputFile As String
OutputFile = "Master"
'Before creating master sheet checks if it exist and delete any older version
If SheetExists(OutputFile) = True Then
Sheets(OutputFile).Select
ActiveWindow.SelectedSheets.Delete
Application.StatusBar = "The " & OutputFile & "already exists and is Deleted"
End If
Set sh1 = Worksheets.Add
sh1.Name = OutputFile
Application.StatusBar = "New" & OutputFile & "is Created"
' This is the variable where one needs to mention the column number for search
' For example Column B should have SearchColNum = 2
SearchColNum = 6
'This are the search strings which has to be looked for in the above column number
' These search strings are "Or" ed in the macro below
' Which can be changed as "And" or other expressions
SearchString1 = "keyword1"
SearchString2 = "keyword2"
' Mention the worksheets which needs to be searched with names "Sheet1", "Sheet2" etc
' and the last digit should be mentioned as the last value of i in the expression below
For i = 1 To 8
Set sh = Worksheets("Sheet" & i)
Set rng = sh.Range(sh.Cells(2, SearchColNum), sh.Cells(Rows.Count, SearchColNum).End(xlUp))
Set rng2 = Nothing
For Each cell In rng
If InStr(cell.Value, SearchString1) > 0 Or InStr(cell.Value, SearchString2) > 0 Then
If rng2 Is Nothing Then
Set rng2 = cell
Else
Set rng2 = Union(rng2, cell)
End If
End If
Next
If Not rng2 Is Nothing Then
Set dest = sh1.Range("A" & sh1.Cells(Rows.Count, SearchColNum).End(xlUp).Row + 1)
rng2.EntireRow.Copy dest
End If
Next
Application.StatusBar = "Finished with the process.."
End Sub
' It checks if a particular sheet exist
Function SheetExists(SName As String, Optional ByVal WB As Workbook) As Boolean
On Error Resume Next
If WB Is Nothing Then Set WB = ThisWorkbook
SheetExists = CBool(Len(Sheets(SName).Name))
End Function
Thursday, January 01, 2009
Cool add-ons from Windows
This site provides some cool add-ons to firefox. There is a ClearType Tuner which allows all applications to be moved to a font which you can feel and apply to all the applications including firefox. Using this you can have firefox font look same as IE7 or whatever browser font you like. This will give a uniform view of fonts across all applications. Another is a ALT+TAB replacement which again is better in case you belong to the category of people like me who keeps lots of application opened. I have not tried others, but will comment on it once i have installed those.
Subscribe to:
Posts (Atom)