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

Best excel pranks

Do you like pranks ? well i do..so i am sharing few pranks and tricks that can surprise your friends and sub-ordinates. As they have been picked from different sources like forums and websites.   DISCLAIMER: Though i have avoided any sort of VBA pranks still, Neither myself, nor other contributors to this post are to be held responsible for you losing your job/suffering injury from a disgruntled colleague. Here are few pranks that you might like.   1) Scroll lock…

Read More

How to remove excel macros completely at once ?

Unhide the sheet first  : just in case it is hidden right-click on the name of any sheet and select Unhide from the popup menu.This will show up the unhide sheet dialog box.Now choose the sheet and click ok and follow the steps given below. First of all press Alt+F11 to display the VBA Editor. At the side bar there will be a part that says Modules or forms.Now right click the module or form and hit Remove If you don’t…

Read More

Spreadsheet on how to attack popular th9 bases

How to attack on the popular th9 bases all in one single spreadsheet good collection for clash of clans players. List TH9 Kamikaze’s Bacon Maker TH9 Tsunami TH9 Sir-Mix-Alot TH9 Tesla X / The Kardashian TH9 Sudoku TH9 Anti-Valkyrie War Base: Turtle TH9 White Flag TH9 SahandsProject / Gamatrix TH9 Sucker Punch TH9 Can’t Touch This TH9 WDM “Walls Don’t Matter” TH9 Chris Anti Hog TH9 Giza TH9 Ringus TH9 The General v3.1 TH9 The Shield TH9 Dimond Tesla Moat…

Read More