Who Gives a .... Anyway

Excel Sum of from a cell to the RowAbove, or the next row above I got the idea and concept here: Three Ways to Reduce Errors In Your Excel SUM Formulas Essentially; what I wanted to do was prevent the Insert Row just above the total line to always include the row above. So after playing a bit I found the site above. So here is the process: In the workbook you want to have the sum click on any cell Depending on the version of Excel find where you name a range, for 2007 Formulas, Define Name A new name dialog box is displayed Make Name "RowAbove" Scope: Workbook Add a comment the next row up Delete the sheet name and enter in the row aboves address, in my case I clicked on =MySheet!$B$4, so I replace that with "=!B3" Then anywhere I want to add a sum or subtotal I just use sum(A3:RowAbove), then that will sum from A3 to the row above Now even if a insert row above on the formula it will add it the value to the sum.

I believe that Google sites is one of the best kept secrets. Recently my Mom had asked me to put a site together for her to show here art to prospective buyers. Initially I just threw together a quick and dirty site to get her up and running, but afterwards she kept asking me to upload this pic and that pic, so I started looking around for open source Gallery products. After playing with a few, that look quote good, I found their setup tedious an requiring to many auxiliary downloads, like MySQL (it is now over 100MB to download, that is definitely one reason to go for SQL Express) After playing around a bit when I had time I thought, surely using Picasa and Google sites must be an option. 4 hours later I had a site up and running, nothing brilliant, but she can upload photos of new art when she wants, and can change anything she likes. The site does not work too well on a mobile device but otherwise it is fully functional. Her potential client just need to click on Gail Machanik...

I saw this chap and would love to hear / see more. I had seen a lot of people on Michael McIntyre's roadshow but he is one that stood out. Here is a link the a YouTube clip of that show. YouTube - Michael McIntyre's Comedy Roadshow - Steve Williams : "Steve Williams"> His site looks good too Steve Williams Home Want to try get more.

First it is an estimate So we have all had some expose to this training zone thingy I always wondered what it meant, and how it was calculated when looking at the results of a medical or at a gym. Recently I had the fortune of being given a Polar watch to monitor my exercise, and this got me digging about these zones, since I never seemed to be it the correct one. After a few searches and forum reads I found these articles below: Ten reasons why “220 Minus Age” gets a failing grade: . Which stated that: "The equation was created in the early 1970’s by scientists Fox, Naughton, and Haskell who intended it to be a rough formulation and not meant to be representative of the entire population. All subject in the studies referenced were under 55 years of age and male. Although the equation has become accepted and the standard in the literature and is used widely in clinical and fitness settings, its validity is uncertain." The Myth Of "Maximum Heart Rate = 220-Age , and h...

We all think that a Telkom call is cheaper, but what is always left out of the calculation is the line rent. What is this line rent? Paying rent for a line that was laid years ago, to a place near your place of business or house. Okay so there is some maintenance. Do a little maths an you see why Telkom have been in the the top 5 highest dividend yield companies for the last few years. Next look at the number of calls you actually made, for this exercise add them all together including the cell calls as well. I run a small business and because I have to, I have a ISDN line, so we can have two lines. On average over the last 3 months I have made about 100 calls a month on this line (including redirect to some of my agents cell phones). We make more cell phone calls than telkom calls. I have taken the last three bills added them together and divided by the number of calls made (rounded up to the nearest 10. Guess what it is costing PER call R5.296. OMG as any good American wo...

SMTP Settings Below is a list of SMTP sites in South Africa, using this and the ISP Map you can try and find which one works best for you. Telkom smtp.saix.net (ADSL) smtp.telkomsa.co.za (56k dial up) smtp.telkomsa.net Internet Solutions smtp.isdsl.net (ADSL) smtp.dial-up.net (56k dial up on IS) smtp.layerone.net (3g backbone) Vodacom smtp.vodacom.co.za smtp.vodamail.co.za MTN smtp.mtn.co.za Cell C smtp.cellc.co.za (GPRS) mail.cmobile.co.za (also used by Virgin) ABSA mail.absa.co.za iBurst smtp.wbs.co.za smtp.iburst.co.za @lantic smtp.lantic.net (ADSL,Dialup, ISDN) Sentech smtp.sentech.co.za MWEB smtp.mweb.net (ADSL) - this is to be retired End June 2012, use below instead smtp.mweb.co.za (56k dial-up & ADSL & business) iAfrica smtp.uunet.co.za smtp.iafrica.com Neotel smtp.neotel.co.za Tiscali NOW MWeb smtp.tiscali.co.za Netactive NOW MWeb smtp.netactive.co.za Global smtp.global.co.za Hertzner Use y...

I sometimes use word to publish to my blog, it allows me to do the writing offline and then publish it when I have grammar and spell checked the post. (Believe it or not I sometimes do this J ). So this is how I did it. Firstly I got the picasaweb link that I have my images (if you are logged in to your gmail account click settings, then go to Picasa web albums, click settings) Then find the image that you want to include in the blog. Right click on it and get the image URL. I my case I used a coffee cup Then in word go to insert -> Picture. And paste the URL in the file name box, then click the drop down arrow next to insert and select "Link to File" This does mean that you have to have the image on Picasa Web though. After posting you will probably have to go and re-format the image, in the case above I went to edit the post and then changed the width to 150px. If you publish a picture of the correct size that is a different story.