Calculate Effective Rate Of Interest In Excel

Calculating part in excel is easy we are providing you some example / sample sheets that will help you understand it much better even if you are new to it. First of all you have to find what do we mean by effective rate of interest, actually it is the total cost of borrowing there are various tuts available showing what this stuff means. If you are newbie to excel you can learn how to create your own spreadsheet and formula…

Read More

Calculate Your Net Worth

This is more than a simple portfolio management spreadsheet as one can input assets viz cash,investments,property and retirement at one side and then compare them with the liabilities ahead. Nice way to determine how much you worth today.Though it is not a difficult task but still i think that a excel sheet proves to be a lot useful.Your net worth is everything that you own  that means all of your assets minus your liabilities that you have to pay in…

Read More

Loan EMI Calculator Excel Sheet

This spreadsheet sample will allow user to understand how the EMI will work out for them. In how much time and what will be the amount deducted in each EMI. User has to fill in Loan Amount,Annual Interest Rate,loan period in years, and the start Date of Loan. It will auto calculate the monthly EMI payment that you have to pay along with total cost of loan that you will be paying that means the amount of debt along with…

Read More

Download Duckworth Lewis Excel calculator

Here is the excel spreadsheet that can help you in understanding the required and approx number of all stats including run rate,wickets and other stuff, all according to the Duckworth lewis law of cricket. User have to click on the image to download the excel sheet. This method sometimes create a lot of confusion among spectators as well as players.Actually it is a mathmetical formulation which was made for calculating the target score of the cricket team which bats second in…

Read More

Matched Betting Spreadsheet Calculator

Here i am providing you some of the matched betting spreadsheets.Here is a guide on what this fuzz is all about.If you already know what it is then you can directly view and download the spreadsheets. I am not into gambling business but some people would love to have these sheets so here they are. 1) This one looks a bit pro, this sheet will calculate profit and your chances. Use the above link to know more about this sheet.…

Read More

Horse racing spreadsheet

It will help you determine approx profit from horse race. The first tab consist of the intro part where it tells us how it works. As it performs only a guess part one should not take it seriously.user can modify and alter the betting price for  each race. While the other tabs perform calc part for different races.One can input race variables and odds references in other tabs given. Note : This sheet consists macro

Read More

Tennis Sports Betting Spreadsheet

I really liked it. User can input values and then as per probabilities this sheet will associate it with the anticipated results.User has to input the probability of winning on a player in the top cell.Then choose 1 -set score and the other values will be auto calculated.   You have to click on the above image to view and download the sheet. Keep sharing.  

Read More

How To Speedify Your Excel VBA calculation

Some good coding habits can keep your workbook calculations work faster,so i am sharing here some of the excel sources that will allow you to save time next time.   1)Avoid reading values cell by cell from a spreadsheet – Read/write in bulk here is an example set   2)From chandoo – 75 different tricks that users have submitted ..quity handy http://chandoo.org/wp/2012/03/27/75-excel-speeding-up-tips/ 3) Avoid autocalculations during VBA code is executing. You can use this code to avoid any auto calc in…

Read More