Rajender's Blog
I maintain this blog to share my experience on path of love to God. Also to share my technical skills as a software engineer.
Monday, May 27, 2013
Sunday, July 25, 2010
SUMPRODUCT
SUMPRODUCT(array1,array2[,array3,...]) Multiplies the corresponding elements in the specified
arrays and then sums the resulting products
e.g.
| dd | bb | Cc |
| 0 | 2 | 2 |
| 3 | 5 | 3 |
| 4 | 8 | 4 |
| 5 | 5 | 5 |
| 6 | 6 | 6 |
| 7 | 7 | 7 |
| 8 | 8 | 8 |
| 9 | 9 | 9 |
| 0 | 10 | 10 |
Let’s say we have three ranges dd, bb, cc as shown above in table.
Let say we have following formula
=SUMPRODUCT(--(dd=bb),--(cc))
Let’s walk through row by row
Row 1
=SUMPRODUCT(--(1=1),--(1)) : (1=1) Equals (=) will return 1
=SUMPRODUCT(--(1),--(1)) : 1*1 = 1
Row 2
=SUMPRODUCT(--(0=2),--(1)) : (0=2) Equals (=) will return 0
=SUMPRODUCT(--(0),--(2)) : 0*2 = 0
And so on …
Friday, April 9, 2010
more store mahadevpura
In case you need the address
Bengaluru
Address : Survey # 14, Mahadevpura Outer Ring Road, Near Shiva Ganga Layout, Bengaluru East, Bengaluru – 560048.
Tel : (080) 67611601
Open : 08:30 am to 10:00 pm - 7 days a week
Bengaluru
Address : Survey # 14, Mahadevpura Outer Ring Road, Near Shiva Ganga Layout, Bengaluru East, Bengaluru – 560048.
Tel : (080) 67611601
Open : 08:30 am to 10:00 pm - 7 days a week
Monday, April 5, 2010
OCS installation
I have started working on OCS installation. I will keep posting errors and other problem faced by me.
While installing ocs on windows 2008, I was getting strange error.
This was happening when i was adding forntend server to the pool.It was asking for windows media formats which are bundled with the ocs setup. when i tried running wmfdist64.exe under AMD64 folder. i was getting follwoing error
"Not Enough storage is available to process this command"
Strange enough when i installed the Desktop Experience feature which install the windows media player fixed this problem.
While installing ocs on windows 2008, I was getting strange error.
This was happening when i was adding forntend server to the pool.It was asking for windows media formats which are bundled with the ocs setup. when i tried running wmfdist64.exe under AMD64 folder. i was getting follwoing error
"Not Enough storage is available to process this command"
Strange enough when i installed the Desktop Experience feature which install the windows media player fixed this problem.
Thursday, March 18, 2010
Monday, November 16, 2009
Best coding practices
Over the many years of my programming experience. I have found common mistakes which people make again and again. In this series of articles I will post some of best practices one by one and common mistake which you will avoid by using it.
1) Read the API documentation carefully.
It is very common that programmer does not read API documentation carefully. Which include what are parameter boundaries. What are side effect of passing certain parameters.
Under what condition function will fail. What are error code or exceptions thrown by the api. If programmer take 10 min of extra time and reread the documentation once again carefully. I can bet many of programming errors can be avoided.
2) There should be very good logging mechanism in place.
While developing any piece of software there should be very good logging in place. Log statement should be well thought. These should give comprehensive description about the event. I have seen logger statement like enter the function exit the function. these are really of no value. There should be different log levels which should be configurable. In case of failure log should give clear picture why the failure has happened.
3) Write simple code
We should write as simple code as possible. We should avoid complex code. One hint for complex code could be, if one has to write comments to make the code understandable it is time to review the lines of code you have written. See if you can make these lines simpler.
4) Use standard libraries and api's :-
Many programmer keep inventing same thing again and again. e.g function to reverse a strings etc. There many standard functions for many tasks like this. Read all the standard api's and try to use already tested and used api's
1) Read the API documentation carefully.
It is very common that programmer does not read API documentation carefully. Which include what are parameter boundaries. What are side effect of passing certain parameters.
Under what condition function will fail. What are error code or exceptions thrown by the api. If programmer take 10 min of extra time and reread the documentation once again carefully. I can bet many of programming errors can be avoided.
2) There should be very good logging mechanism in place.
While developing any piece of software there should be very good logging in place. Log statement should be well thought. These should give comprehensive description about the event. I have seen logger statement like enter the function exit the function. these are really of no value. There should be different log levels which should be configurable. In case of failure log should give clear picture why the failure has happened.
3) Write simple code
We should write as simple code as possible. We should avoid complex code. One hint for complex code could be, if one has to write comments to make the code understandable it is time to review the lines of code you have written. See if you can make these lines simpler.
4) Use standard libraries and api's :-
Many programmer keep inventing same thing again and again. e.g function to reverse a strings etc. There many standard functions for many tasks like this. Read all the standard api's and try to use already tested and used api's
Saturday, November 7, 2009
Plasama vs LCD
Here is quick comparison
| S.NO | Plasma | LCD |
| 1.Life | 15years | 20 years |
| 2.Picture quality | Best as good as CRT | Blur |
| 3.Power | More | less |
| 4.Moving picture | Best | Blur |
| 5.Weight | More | less |
| 6.Heat | More | Less |
| 7.Still picture | Create pixel burns | Good |
| 8.Moving picture | Good | Create ghosts |
Subscribe to:
Posts (Atom)