Posted on 07 June 2009
Beards are not a topic that you'd think someone would typically write about leave aside holding yearly competitions for. Dyers.org
is Jon Dyer's site where he talk about life, leisure, movies and his experiments with beards. Sometimes its stuff like this that makes you realize that life is so much more fun when you're off the beaten path.
Here is a nice chart of various beard styles on his site that caught my fancy.
Posted on 07 June 2009
Time for a break from the usual Excel stuff......a couple of chosen Dilbert's.....
Posted on 04 June 2009
Retirement planner in Excel will help you calculate your savings at the time of retirement. The Excel retirement planner takes in to consideration your monthly income, expenses, asset purchase over time, saving allocations and expectations of interest rates and asset appreciation to calculate the growth of your savings over a given period. You can download the retirement planner in excel
All of us worry about the impeding retirement. How ...
Posted on 21 May 2009
You can use Excel to make charts using symbols and display unconventional characters. Here's a list of symbols that can be used for making charts in excel
. You can generate these symbols in Excel by formatting normal alpha-numeric characters with in-built or custom fonts (Windings, MS Outlook etc.)
Few quick tips:
To make a bar graph
Use the REPT(char) function in Excel to repeat a character. Choose from the list of symbols ...
Posted on 14 May 2009
Bonavista systems, the makers of Microcharts, have invited entries for this years Excel Dashboard Competition. All you have to do is to present a dashboard which uses nothing more than Excel 2000 (or higher) and no other software other than Bonavista's Chart tamer and micro charts. The dashboards are going to be judged on 'the clarity and effectiveness of their design'. Entries can use any combination of tables, Excel charts, ...
Posted on 13 May 2009
An SQL Statement is a statement written in SQL. Every SQL statement could be classified as either a Data Access Control Statement, Data Definition Statement, Data Manipulation and Retrieval Statement or a Data Transaction Control Statement. You can download a complete set of SQL statements (SQL Satement & Basics.pdf)
here. This handbook describes most of the frequently used SQL statements and contains numerous examples of how to use those statements.
Posted on 12 May 2009
A Six sigma table is a table that depicts the (six) sigma value corresponding to various accuracy levels. The six sigma table
can be downloaded here. By looking down the tabulated values of the accuracy levels, you can find the (six) sigma level that corresponds to your accuracy level.
The sigma table has five columns – the yield or the accuracy level ( 1 – the defect rate), the ...
Posted on 11 May 2009
This Sudoku solver in Excel will help you solve a sudoku puzzle with brute force. This Sudoku solver, has been written in VBA and incorporates a brute force algorithm which helps its solve some of the toughest sudoku puzzles using nothing more than an excel spreadsheet.
You can download the Sudoku Solver in Excel with Code, Logic and Algorithm
In this article we will talk about how to develop a Sudoku solver using code in Excel, discover the tips ...
Posted on 11 May 2009
How do you make a six sigma calculator in Excel? Well it's all really quite simple in excel....the calculator needs only a single formula to generate the sigma level for a process!!! You simply plug the number of opportunities & defects into an excel spreadsheet and calculate the sigma level by using NORMSINV (1 - defect/opportunities). You can download a copy of the six sigma calculator in excel
Posted on 10 May 2009
You can download the house of quality template in excel
here. House of quality is a graphic tool analyzing the relationship between a firm's focus on improvement and the needs of its customers.It is a part of the Quality Function Deployment (QFD). Visually, it looks like a grid with a correlation matrix at its top and left side. The customer needs vs the firm's product features form the main body of the house of quality. Using this template in ...
Posted on 08 May 2009
The results of the "Stress Test - Housing Crisis of Shame" are out. I just saw NY Times publish the stress test figures this morning
. The first thing that came to my mind when I saw the results was, well.......not that they require another $75 billion, that's pretty well known to most of us by now, was ....gosh.....what an opportunity wasted. Here was a important and relevant piece of data that could have really been presented better using ...
Posted on 07 May 2009
This article shows how to make Gantt charts in excel. Though Excel remains the preferred choice for creating simple Gantt charts
, there are other commercial tools available for developing more complex versions of the Gantt chart.
GANTT Charts are an important project management tool. In this article, I will describe how to create gantt chart in excel with a marker for show today's date. Using a stacked chart in excel, we ...
Posted on 05 May 2009
Find out how to create a Pareto chart in Excel. A Pareto chart can be created in Microsoft Excel as a combination of a bar and a line chart. A Pareto chart (also known as the Pareto graph) is a combination of two data series, one set of points representing a set of independent values and the other representing the cumulative sum of those values. The independent values are typically represented by vertical bars in which the values are arranged ...
Posted on 04 May 2009
This tutorial shows how to create a Flow charts in Excel. Flowcharts help you logically represent a sequence of activities in a process. Before you begin, you may want to download and analyze this sample flowchart template created using excel
. Making flowcharts in Excel can be as easy and fast as it is in Microsoft Visio without having to buy a license for the later. If you work in a company where a lot of planning and process engineering ...
Posted on 18 April 2009
Ever wondered how do you convert your excel spreadsheets in to the PDF format? Here are a few tools (mostly free though some are free only during the trail period) that can help you convert from excel to the PDF format (.xls to .pdf).
is a website based online excel to pdf conversion tool. You will need to submit the document to be converted on the website and ...
Posted on 16 April 2009
How do you reach Mahabaleshwar from Mumbai
Well there are two ways to reach Mahabaleshwar from Mumbai
Route 1: Bombay-Panvel -Lonavla-Pune-Shirwal-Khambatki Ghat -Wai-Panchgani-Mahabaleshwar (Total distance around 305 kms, driving time with break 7 hours)
Route 2: Bombay-Kalamboli-Panvel-Pen-Mahad-Pholadpur-Mahabaleshwar (Total distance around 237 kms)
The first one is preferable. That way you cover a major part of the route going along the Mumbai-Pune Expressway and the remaining through reasonably good Pune-Satara bypass. That way you are ...
Posted on 04 April 2009
If you have been wondering how to increase blog views for your blog, the following tips can come in handy. Mind you, the two most important factors to increase your blog views are - great content and large number of good quality links from other blogs to yours. If you can achieve both of these, rest should be easy to manage.
Increase blog views by writing good content on your blog
Posted on 28 March 2009
All too often we let old calender entries and meeting requests accumulate in outlook resulting in the calender folder gradually bloating out of shape (and receiving the dreaded "your mailbox is over its size limit" message from the server)
How do you solve the problem of deleting older calendar entries and meeting requests in outlook - well here's how:
Go to your outlook ...