Tuesday, November 4, 2008

PhoneNumberUpdate()

PhoneNumberUpdate()
{
if (phoneBook.exists("Suman") then
phoneBook.update("Suman",9632466866);
else
phoneBook.add("Suman",9632466866);
}

Sunday, August 31, 2008

Maintain shared account in an excel sheet

I created an excel sheet to maintain shared accounts in a room.

U may skip the background --------->

We are 4 ppl staying in same flat and the calculation of money spent every month was becoming very difficult.

We had to do many calculations.

1. Power bill, internet bill, news paper etc should be shared across all ppl.
2. Only 3 of us drink milk, so the milk amount should be shared by only 3 of us.
3. Two of us go out for break fast and two of us prepare at home. The amount spent will be different and should be shared properly.

Let us take A, B, C, D as roommates names.
We had to do totally 11 calculations

ABCD(shared by all), ABC, ACD, ABD, BCD, AB, AC, AD, BC, BD, CD

One day, after doing all calculations, my roommate told me that some numbers are wrong. As a result I had to do all the calculations again.
So, I thought of creating an excel sheet which eases my calculation work.

-----------> Background ends

Explanation of the sheet:

I assumed a person (Finance), who maintains our accounts.

Open the excel sheet.
First column is Date, second column is Item.
3rd, 4th, 5th (Amt Spt, To Fin, YES/NO) column belongs to person #1.

Enter the amount spent by person #1 in 3rd column.
Select YES in the 5th column for the same row.
Select YES for the people who are all involved in spending the amount.



In the above figure, Person#1 pays internet bill which is 750. It is shared by all ppl. So,

every ones share is 150. All ppl except person #1 has to pay 150 to finance(which is showed in red). Person #1 gets 600 from finance (highlighted in green).



Person #1, #2, #3 went for lunch. Now, person #2 pays 300.
It has to be divided across 3 ppl. Person #4, #5 are not involved in this.
So, select YES for person #1, #2, #3. Do not select anything for person #4, #5 (or select NO).

Above figure shows, person #2 gets 200 form finance and Person #2 has to give 150 to finance for internet bill.
So, person #2 gets a total of -150+200 = +50 from finance. Which is indicated in the last row named Total.

After adding the days dinner expenses, the excel sheet looks like below.


After some more entries, the excel sheet looks like



Download the excel sheet here (for 5ppl), excel sheet for 4 ppl. (Note: Enable macros)

Other Features:
1. Enter the item name, the date will be automatically taken as current date. You can modify the date.
2. Enter the amount spent by Person #x, YES will be selected for the person #x in the corresponding row.

Known Limitation:
It is not allowed to enter the details where Person A spends money for personal item of Person B. (where person A spends money, but YES/NO will have NO as person A does not share the item.)
But, there is a round about method:
Multiply the amount by 2 and enter the amount in Person A column and select YES for person A and person B. (in case 2 other ppl are involved, then multiply by 3 and select YES for 3 ppl)

Please share it with your friends.
I would love to hear from you for any doubts or suggestions :-)

Update: There are many sites offering excellent expense management features. www.buxfer.com www.mint.com http://quicken.intuit.com/
Many of the above sites has options to link to your bank account and categorize your spending.
You can continue to use this excel sheet if you do not have internet connection  available all the time.

Saturday, June 28, 2008

God knows the shape of heart

This is a beauty spot on chembra peaks. There is a heart shaped pond. Initially I thought it is man made. But, when I went near to it, I realized that the god created it and he definitely knows the shape of heart.

Thursday, June 26, 2008

Suman is in Flickr too

I wanted to upload my photos in a good place. My roommate suggested me to use flickr. I have an account in flickr but I have not used it. I uploaded some of wayanad tour photos in flickr. my flickr page
Visit my page in flickr, give me ur comments on my photos. 

One year in Philips

Today is a memorable day in my life. I successfully finished one year in Philips. Morning I felt like I joined couple of days back. Days are moving very fast.....

I wished all my colleagues who joined with me. Most of them did not remember that they joined an year back. Everyone felt happy. No celebrations. No cakes. Just enjoyed the day as usual in office.


Sunday, June 1, 2008

My License test got over

I started learning car driving. Total 20 classes of 1/2 hour each. I took Learner License on 25th April. Any one can take a test after 1 month from the date of Lerner License. My classes got over on Friday and I wanted to take a test on Saturday itself.

Me and shankar (my roommate) went to yashwanthpur to give test. I called my driving school for a car. They came at 12'o clock. I gave the test successfully and I will get the license by next week.

Mysore Infosys

Its been a long time since I took a long drive. Me and Kiran (my roommate) planned to visit Mysore on Sunday on his Pulsar. Mysore is 150Km from bangalore. My friend is in Mysore Infosys, so we planned to visit that campus also. Many of my friends told me that the mysore Infy campus is one of the best in India.

We started at 6:30 AM. Our first stop was after 50 KM. The road to mysore is good and we were speeding upto 110KM. We reached mandya (place in karnataka) at 7:45AM. We had breakfast in Mandya.

The next stop was in Srirangapatnam. There is a Madrasah on the way to Ranganatha swamy temple. We went inside and Kiran started taking some photos. Kiran likes photography and he has a big collection maintained in flickr. I also took some photos with my new camera. Then we went to ranganathaswamy temple by 10AM. We were there till 11:30AM. Kiran took some more photos. Then we headed towards Infy campus.

We reached Infy campus by 12'o clock. My friend has come out to the gate and we took visitors pass. They were asked us to fill a form for cameras. My friend got surprised with the camera stuff. Krian has 2 cameras (canon 400D and Sony DSC H2) and 2 lens different zooming lens.

We went to food court-2 and had lunch. The campus was constructed in a very good way. They provided all the facilities and entertainment. There is a multiplex with 4 screens for the employees. The buildings were in different shapes. The hostels were constructed like english alphabets which will show as INFOSYS when we see from bird eye view. That was very good idea.

It was too hot in mysore that day. Luckily we get umbrellas in the campus. We got the permission till 3:30PM. My friend has showed us all the good places in the campus. They are constructing a huge building which has a training capacity of 10000. Already they have 5000 training capacity building. I was surprised with that. We came out of the campus at 4PM.

We visited mysore palace. The wether became cloudy. We thought of staying at the palace till 7PM. At 7PM they will switch on all the lights for the palace. It will be a wonderful experience to see. Kiran also wanted to take some photographs of the palace. But because of the wether we started at 6PM.

A coffee day with pizza hut is there after mandya (almost 60KM from Mysore). But, the pizza hut was not yet opened. They told they are going to open it shortly. That will be a nice location to stop the vehicle and have a break from journey.

We reached bangalore by 8:30PM. We went to near by punjabi mess to have dinner. One more memorable weekend....

Sunday, May 18, 2008

Shankar got a bike...

My roommate shankar bought a UNICORN bike on 17th May 2008.


Tuesday, May 6, 2008

My first cricket match in stadium

Me and my team went to M. Chinnaswamy stadium to see the IPL cricket match between Royal Challengers (Bangalore) and Punjab Kings Eleven (Mohali).

We reached the stadium at 6pm. We got tickets for C stand and we sat just behind the camera. We prepared some placards. The match was started at 8PM. There were very less boundaries. First 10 overs we felt like we were watching a test match. Later it got better little bit. Though the match was not very good, we enjoyed it.

Anuj dropped me at my room as it was very late in the night.

@ Hyderabad - Day 3

I called Nagaraj to know the movie timings. He told me the movie is at 12:10pm. I told shankar to catch a bus and get down at Hyderabad Central. Me and my brother started to PVR and reached there at 11:30 am. We went to a hotel to have breakfast. I told Shankar and Uma maheshwar to come to the hotel. I had breakfast and we went to PVR to watch the movie.

The projector had some problem. So, the show got delayed by 30 minutes. We thought they will cut some movie to manager the subsequent show timings. But, fortunately played full movie. The movie was good. I liked it very much. The movie got over by 2.30 pm

We went to Shanbagh hotel to have lunch. The place was crowded a lot and bearer told us to wait for 20 minutes to get a table. Then we decided to move to some other hotel. We went to Buffet chetnies. The bearer told that kitchen is closed and they cannot make any new items. We found there is not sufficient food is available. So, we moved to some other hotel. They told the rice items are over and they can only supply tiffen items. So, we ordered some tiffens. Some how we filled our stomachs.

We went to HomeTown to buy a memory card for my digital camera. They does not have 4GB cards. Me and my brother left the place. I met my sister in the evening. Then we went to CTC to buy memory card. I bought a Transcend 4GB memory card for my digital camera.

I was tired with the heat and city pollution. I asked my brother to drive me to a good hotel. We went to paradise hotel and ate chicken biryani.

We reached home at 11pm. I enjoyed the day.

@ Hyderabad - Day 2

I went to my cousin(Srikanth) room. I was in the room only, as the weather is too hot outside.

Nagaraj called me in the afternoon and said that he booked tickets for IRON MAN movie in PVR. I told him to book tickets for afternoon show. I told him to book tickets for my brother and Shankar also.

I got French beard. The barber spent almost 20 minutes to give me a good look with French beard.

In the evening me and jalendar met near Paradise hotel and bought a Nirmal painting for Kiran from Lepakshi. We reached the function hall at 9pm. All my colleagues were arrived before us. We all went up to the stage and greeted him. We all presented the gift to him.

The dinner arrangements were good. After the dinner me and Jalendar went back to begumpet. I went to my brothers room.

@ Hyderabad - Day 1

I went to Hyderabad to attend kiran's marriage. Me, Jalendar, Shankar went together in Kachiguda train. I met jalendar after a long time(almost after 2 months). 12 of our colleagues also came in the same train to attend the marriage.

I went to Ranjith's room directly after getting down the train. I got fresh up and we went out side to have breakfast. Then I went to Nagaraju's home. I thought of enjoying the 4 days upto the maximum extent. I called Kranthi, Nagaraju, Uma maheshwar and Om prakash almost one week before. They told me to come there and we will plan something. But, all my expectations were reversed.

Kranthi did not lift the phone. I tried on 30th and 1st. I called him almost 100 times, but there was no one to pick up his phone. Uma maheshwar did not apply for a leave. He told he cannot meet me the same day. Om prakash went home. When I called him, I got strange response that "Mama, When did u come?". I was shocked with the response. Nagaraju told me that he has some work outside. But, he slept at home till noon (So he neither went out nor called me).
Wonderful receiving from my friends and excellent planning.

I went to Nagaraju's home at noon. I met him and dont know what to do. Becoz, no one is there with us. It was too hot outside, so I did not feel like going out. I played couple of AOE games with Nagaraju's brother. In the evening, Uma maheshwar came there. We went out to drop nagaraju's uncle.

My cousin(Naresh) called me and asked me to come to his home. He came to lakdikapool to pick me up. My another cousin (Srikanth) also came to the same place. We went to Cafe Bahar to eat biryani. We went home at 12'o clock in the night after dinner.

Saturday, March 15, 2008

I met my friend again...

I went to hyderabad on tuesday. I had lunch with my sister and went to my uncles home.

My train is from kacheguda at 7'o clock. I went to Kacheguda at 6'o clock. In one shop I saw a person, who was like my classmate in diploma. But guess was right. The person is Gunjon. He was my classmate and roommate in diploma.

I met my friend after 6 years. I felt very happy to see him again. I recognized me. He tole me that he started business. We remembered those days again. He told me about other diploma friends. I talked with him for half an hour and left to railway station. I felt very happy to meet him.

Day @ Karimnagar

I went home on saturday. I got a nose infection last week. It got cured. On sunday, I observed that the nose is swelling again.

My dad told me to consult an ENT specialist. I got an appointment on monday. I went with my dad friends (satish and diwakar). Doctor told me to get an X-Ray.

I got an X-Ray @ 2'o clock. The doctor was not available in the clinic. I lost my spectacles in venad tour. So, I thought of taking new spectacles. I went for an eye check-up also. Doc told me that both eyes are with point 0.5. I went with my dad to buy new spectacles.

I met the ENT doctor at 6'o clock. He told me that the swelling is not a big problem. He gave some medicines. I felt a bit happy about that.

I got the train ticket to bangalore for tuesday train. Its very comfortable to come by train than by bus. My berth got confirmed.

10,000 BC

With lot of expectations I went to the movie 10000 B.C. But, all my expectations are ruined. I was eagerly watching the movie. Soon I realized that I already know the story. Yes, it was almost a copy of Appocolypto. I was very much disappointed.

The first 30 minutes of the movie was very slow. After that the movie was little good. But, I did not satisfied with the movie. Very few scenes were good.

Immediately I called some of my friends and told the story is same as Appocolypto. They were also disappointed and told me that they will not waste 2 hours.

If u already saw appocolypto, dont expect anything from this movie. Otherwise, its OK to spend 2 hours.

Thursday, January 24, 2008

Convocation...

I went to calicut to attend convocation. Kranthi, Nagaraju, Om Prakash came to bangalore on 17th Jan morning. I took them to my flat. Prepared maggi for them and returned to office.

They went to RT Nagar to buy a gift for Gurudatha as his birthday is on 19th Jan. He is the one who celebrated his birthday thrice in NITC from M.tech.

We started from my flat in the evening. Gurudatha joined us at majestic. Guru's sister also coming to calicut to see convacation. We bought sweets for our professors.

Our bus was at 10pm. It came a bit late and started at 10:30pm. There was some problem with the bus, the driver took us to bangalore bus depot and changed the bus. I felt the bus is going very slow and making so much sound. By bad luck, we got front seats in the bus. We reached MYSORE at 3AM. Generally it takes max 3 hours to reach mysore from bangalore.

The driver and conductor went to get another bus from depot. My self and two passengers got down from the bus and started discussing about the kerala and karnataka busses. Another bus came at 4AM. We got into the new bus and I slept for a while.

We thought by 10AM we will be in the college. But, the driver took us very fast. We got down at kunnamangalam and reached college at 9AM. We directly went to canteen. Srinu, aravind and other batch mates were at canteen. I felt very happy to see them after a long time. We went to chanakya to collect our convocation dress. We met some of our batch mates near chanakya hall. BPR came to chanakya hall, we met him and gave him some bumps. It was fun meeting BPR after a long time.

We collected the convocation dress and went to G-Hostel. On the way, we met our juniors sri krishna, Gopi etc. Nagaraju came to college with his wife. Most of my batch mates came to attend convocation.

we went to srikrishna room and got freshed. I forgot formal dress for convocation. Kranthi and others were telling that we should wear formals and only formal shoes. I started searching for a formal dress and shoes. I got it from my juniors and MCA ppl. Thanks to them...

We went to our department to meet our lecturers. Luckily all the lecturers were in the college. First, we met Madhu kumar sir. We started talking with him, Priya chandran madam also came there. We gave sweets to them.

Vineeth paleri sir was on the first floor. We went there and met him. We took couple of snaps with him. We gave sweets to him. We met nazeer sir, saleena madam and kaladi sir. Every one felt very happy.

Then we went to meet our HOD, sebastian sir. He was also at his chamber. We went there and greeted him. After that we went to canteen to have lunch.

After the lunch we came back to hostel and got ready with convocation dress. Everyone was looking different with the dress and the faces were glowing with smile.

We went to convocation hall at 2:30pm. All the ppl were assembled there. Function started at 3:30. I felt a bit uneasy with the dress. And the hall was packed and does not have proper fans etc. There was a speech by our director and chief guest. Chief guest speech was for 1/2 hr. After the speeches, our director distributed degrees to all graduates. The function got over by 6pm. Kranthi got a gold medal. We felt very happy and he deserves it.

We took some photos out side the convocation hall and went to chankya hall to return dress. We took some photos at chanakya hall also. Then I met some of my batch mates there. Congratulated all of them for completing the post graduation.

We went back to hostel after returning the convocation dress. We were planning to arrange a cake for guru. Srinu called me and told that he ordered a cake in kattangal(next stop to our college). We went to kattangal after dinner and collected the cake.

Guru also came to kattangal and gave a juice party to all of our friends.

Our junior pramod came to us and asked us to play age of empires. We agreed. We were playing AOE almost after 9 months. Kranthi, nagaraju, sumith played in one team against our juniors. I was with kranthi and helped him in playing the game. It was fun.

Its 12'o clock. Guru birthday. We came to first floor and our juniors arranged a table, knife etc. We gave some bumps to datha and wished him. Guru distributed the cake. As there were very few ppl, so much of cake was there. I gave some stills with the cake. Suddenly, srinu took the cake and rubbed on my face. BPR and me ran behind him to catch, but we could not catch him. We came back to hostel and started chatting with juniors and our classmates.

We all enjoyed the convocation. All are happy to meet our batch mates after a long time. Some people were saying that college should conduct a convocation every year and should invite all so that we can meet our batch mates at least once in a year. Every one remembered the happy days in college once again.
Custom Search