New Microsoft Excel Tutorial September 30th, 2005
I've just updated <a href="http://www.thenextwindow.com/exit.php?url_id=750&entry_id=151" title="http://www.terryscomputertips.com" onmouseover="window.status='http://www.terryscomputertips.com';return true;" onmouseout="window.status='';return true;">TerrysComputerTips.com</a>, my computer tips, articles and free newsletter site, with a <a href="http://www.thenextwindow.com/exit.php?url_id=751&entry_id=151" title="http://www.terryscomputertips.com/ms-office/hands-on-excel.php" onmouseover="window.status='http://www.terryscomputertips.com/ms-office/hands-on-excel.php';return true;" onmouseout="window.status='';return true;">Hands-On Excel</a> tutorial for Excel beginners.<br />
<br />
The tutorial starts with an intro that discusses what Excel is and why you might want to use it. The next six parts create a spreadsheet with stock prices across time, shares of stock, and values, including graphing the results.<br />
<br />
While the tutorial focuses on Excel, it would also work very well for the free, open-source <a href="http://www.thenextwindow.com/exit.php?url_id=752&entry_id=151" title="http://www.openoffice.org" onmouseover="window.status='http://www.openoffice.org';return true;" onmouseout="window.status='';return true;">OpenOffice.org</a> office suite.<br />
<br />
<center>Original article posted to <a href="http://www.thenextwindow.com/exit.php?url_id=753&entry_id=151" title="http://www.thenextwindow.com" onmouseover="window.status='http://www.thenextwindow.com';return true;" onmouseout="window.status='';return true;">www.TheNextWindow.com</a></center><br />
Data Recovery – Plan now for future needs September 29th, 2005
What do you do when your hard drive fails? I mean, after you finish the vocabulary test…<br />
<br />
If it is your personal machine, hopefully, you have a recent backup. Worst case, you reinstall from the original disks and lose all your data.<br />
<br />
But, what if the data was your checkbook? Or worse, your business' checkbook? Or the book you've been writing? Or your unbilled work-in-progress for a client?<br />
<br />
Read more in my <a href="http://www.thenextwindow.com/exit.php?url_id=740&entry_id=150" title="http://www.terryscomputertips.com/computers/data-recovery.php" onmouseover="window.status='http://www.terryscomputertips.com/computers/data-recovery.php';return true;" onmouseout="window.status='';return true;">Data Recovery</a> page at <a href="http://www.thenextwindow.com/exit.php?url_id=741&entry_id=150" title="http://www.terryscomputertips.com" onmouseover="window.status='http://www.terryscomputertips.com';return true;" onmouseout="window.status='';return true;">Terry's Computer Tips</a>.<br />
<br />
More Updates at Terry’s Computer Tips September 28th, 2005
I've been busy updating pages at a several of my web sites. The impact of my site being mentioned in Fred Langa's LangaList newsletter has motivated me to make a bunch o changes.<br />
<br />
These pages are new or updated so far this week at <a href="http://www.thenextwindow.com/exit.php?url_id=742&entry_id=149" title="http://www.terryscomputertips.com" onmouseover="window.status='http://www.terryscomputertips.com';return true;" onmouseout="window.status='';return true;">TerrysComputerTips.com</a>:<br />
<table><tr><td><br />
<a href="http://www.thenextwindow.com/exit.php?url_id=743&entry_id=149" title="http://www.terryscomputertips.com/computers/data-recovery.php" onmouseover="window.status='http://www.terryscomputertips.com/computers/data-recovery.php';return true;" onmouseout="window.status='';return true;">Data Recovery</a> — You hope you never need it…<br /><br />
<a href="http://www.thenextwindow.com/exit.php?url_id=744&entry_id=149" title="http://www.terryscomputertips.com/computers/spam-filter.php" onmouseover="window.status='http://www.terryscomputertips.com/computers/spam-filter.php';return true;" onmouseout="window.status='';return true;">Spam Filter</a> — Keeping out Spam<br /><br />
<a href="http://www.thenextwindow.com/exit.php?url_id=744&entry_id=149" title="http://www.terryscomputertips.com/computers/spam-filter.php" onmouseover="window.status='http://www.terryscomputertips.com/computers/spam-filter.php';return true;" onmouseout="window.status='';return true;">Spam Filter 2</a> — Keeping out Spam, part 2<br /><br />
<a href="http://www.thenextwindow.com/exit.php?url_id=746&entry_id=149" title="http://www.terryscomputertips.com/computers/wireless-networking.php" onmouseover="window.status='http://www.terryscomputertips.com/computers/wireless-networking.php';return true;" onmouseout="window.status='';return true;">Wireless Networking</a> — Setting Up Your Wireless Network<br /><br />
<a href="http://www.thenextwindow.com/exit.php?url_id=747&entry_id=149" title="http://www.terryscomputertips.com/computers/wireless-security.php" onmouseover="window.status='http://www.terryscomputertips.com/computers/wireless-security.php';return true;" onmouseout="window.status='';return true;">Wireless Security</a> — Securing Your Wireless Network<br /><br />
<a href="http://www.thenextwindow.com/exit.php?url_id=748&entry_id=149" title="http://www.terryscomputertips.com/computers/anti-virus-programs.php" onmouseover="window.status='http://www.terryscomputertips.com/computers/anti-virus-programs.php';return true;" onmouseout="window.status='';return true;">Anti-Virus Programs</a> & Online Scanners<br /><br />
<a href="http://www.thenextwindow.com/exit.php?url_id=749&entry_id=149" title="http://www.terryscomputertips.com/computers/computer-tips.php" onmouseover="window.status='http://www.terryscomputertips.com/computers/computer-tips.php';return true;" onmouseout="window.status='';return true;">Computer Tips</a> — the section "home page"<br />
</td></tr></table>
LangaList meets Terry’s Computer Tips! September 27th, 2005
<b>WOW!</b><br />
Fred Langa's <a href="http://www.thenextwindow.com/exit.php?url_id=699&entry_id=147" title="http://www.langa.com" onmouseover="window.status='http://www.langa.com';return true;" onmouseout="window.status='';return true;">LangaList and LangaList Plus!</a> newsletters mentioned my <a href="http://www.thenextwindow.com/exit.php?url_id=700&entry_id=147" title="http://www.terryscomputertips.com" onmouseover="window.status='http://www.terryscomputertips.com';return true;" onmouseout="window.status='';return true;">Terry's Computer Tips website</a> in last Sunday afternoon's issue.<br />
<br />
My visitor count for Sunday was about <em>5 times normal</em>. My visitor count for Monday was about <em>12 times normal</em>.<br />
<br />
Many of these visitors signed up for my free <i>Terry's Computer Tips </i> weekly newsletter while they were there — they also visited my advertisers, too.<br />
<br />
THANK YOU FRED!<br />
<br />
All this was the result of Fred's reciprocal link program — I put a link on my site, he puts a link on his site and he mentions my site in his "Loaded the Code" article. This section is simply a listing of about 10 sites, without descriptions, that added links to Langa's site recently.<br />
<br />
<center>Original article posted to <a href="http://www.thenextwindow.com/exit.php?url_id=701&entry_id=147" title="http://www.thenextwindow.com" onmouseover="window.status='http://www.thenextwindow.com';return true;" onmouseout="window.status='';return true;">www.TheNextWindow.com</a></center><br />
Hurricane Rita – little local news September 25th, 2005
As Rita was arriving, the television stations were swamped with Rita information. The local stations and cable news stations focused on Rita.<br />
<br />
Now, the morning after, as we sit here without power except for radios and battery-powered TV stations — what do we have? FOOTBALL!<br />
<br />
Cable was down including cable Internet. If this was like Hurricane Katrina, those people who jumped on cable phone were regretting it. When the cable goes down, there is nothing. Obviously the cable company's repeater stations have batteries that last several hours, but they have been unable maintain the service for longer times.<br />
<br />
What is worse is that, of Baton Rouge's three primary stations, one is UHF. Of course, all the small TV's now come cable-only. They can pick up bad pictures on channels 2-13 if cable is down, because channels 2-13 are identical frequencies for broadcast and cable. All the rest don't match up. That took the NBC affiliate out of contention immediately for most people.<br />
<br />
I can understand WAFB's choice — they are showing two SEC teams so there is a lot of local interest. (They are showing the Alabama / Arkansas game.) Of more importance to those of us still without power — they ran a news banner at the bottom of the screen with hurricane Rita updates from across south Louisiana<br />
<br />
Not so WBRZ, the local ABC affiliate. These fools ran Iowa at Ohio State. Why in the hell was that even broadcast in Baton Rouge, let alone during the aftermath of the hurricane when over 80,000 Baton Rouge homes were without power. No news banner. Nothing but football. These turkeys must be clueless.<br />
<br />
On the local talk radio at WJBO (1150AM, www.wjbo.com), callers were chastizing both VHF stations for running football.<br />
<br />
Our Power came back on, again, about 2:30 for me. Then, it went into flicker & brownout mode for a couple hours. Still no cable tv. Still no cable Internet. It took another hour for cable to return.<br />
<br />
<center>Original article posted to <a href="http://www.thenextwindow.com/exit.php?url_id=698&entry_id=146" title="http://www.thenextwindow.com" onmouseover="window.status='http://www.thenextwindow.com';return true;" onmouseout="window.status='';return true;">www.TheNextWindow.com</a></center><br />
Hurricane Rita — Baton Rouge September 24th, 2005
Southwest Louisiana from the Texas border to New Orleans took the brunt of Hurricane Rita. <br />
<br />
New Orleans, which had just started to let residents back in, suffered renewed flooding in the low-income 9th Ward, which was where the main levee break had occurred after Hurricane Katrina. With Hurricane Rita, the waters overtopped the temporary repairs and washed much of them away as they rushed into the areas that had just been pumped dry.<br />
<br />
In an early view of Baton Rouge after Hurricane Rita, we had different scale of impacts but similar impacts from Rita compared to Katrina.<br />
<br />
Widespread power outages, but more intermittent this time. Wind gusts apparently knocked out some circuits. In my area, power was on, then off, then on, then flickered off-on-off, returned about 1am for 5 minutes, then back off until 8:30am — back on until 8:55 and off until about 9:45. A few attempts to power on again. Then off. Weith Hurricane Katrina, it was off, period.<br />
<br />
Wind: Baton Rouge was much closer to Katrina, so we had much more wind — both in the amount of wind and the strengh of the wind. Before, the winds were from the west and north. With Rita, they are from the East and South, so the impacts are different. Thank goodness we had no appreciable rain between katrina and Rita.<br />
<br />
At 10am, we're having a very few gusts of wind, but mostly light breezes. Rain has stopped for a while. Baton Rouge got only about 1 inch of rain from Katrina. We're about 3 to 4 inches now from Rita — this time we were on the "wet side" (the east side) of the hurricane.<br />
<br />
I can't wait for the power to return. The last few attempts were for 1 or 2 seconnds. Not only are we still having wind gusts, but as the day gets warmer, house air-conditioning systems are triggering as the power comes on. This puts a huge, instantaneous load on the circuit. I thing this overload is what is tripping the systems now.<br />
<br />
[time passes]<br />
12:40 — Power finally returned, maybe for good this time. Using my portable power system (combined battery + inverter to get 120v AC), I saw on our little TV that DEMCO, our power company, had 21,000 people without power in Baton Rouge and that Entergy had 61,000 without power in Baton Rouge. These are almost the same numbers as those reported during Hurricane Katrina 3 weeks ago.<br />
<br />
The rains continued…<br />
<br />
Power went out again shortly after 1pm. It returned again about 2:30, with a number of subsequent blips and brownouts. As frustrating as this has been, I am thankful that I already have power. And, don't have the flooding and wind losses of people south and west of Baton Rouge.<br />
<br />
<center>Original article posted to <a href="http://www.thenextwindow.com/exit.php?url_id=696&entry_id=145" title="http://www.thenextwindow.com" onmouseover="window.status='http://www.thenextwindow.com';return true;" onmouseout="window.status='';return true;">www.TheNextWindow.com</a></center><br />
Cajun Clickers – Katrina Pet Rescue Project – Finished! September 23rd, 2005
Due to the Tropical Storm Warnings for Baton Rouge from Hurricane Rita, we have wrapped up our volunteer project a couple days early. Yesterday, Thursday 9/22, was the last day of the Cajun Clickers Katrina Pet Rescue Project.
Cajun Clickers Computer Club volunteers have been volunteering for the State of Louisiana's Office of Animal Health Services (part fo the Louisiana Department. of Agriculture. & Forestry), and through them, assisting the Louisiana SPCA (www.la-spca.org) and the Humane Society of the United States (www.hsus.org ).
Cajun Clickers volunteers inputted data from Tuesday September 6th through Thursday, September 22nd in the Clickers Computer Lab. We entered data into spreadsheets to log pets to be rescued, reports of lost pets, offers to volunteer, offers to foster and offers to donate goods. We added over 7,000 records to the tracking spreadsheet. We got two batches of data per day, input the data, consolidated the spreadsheets and sent updated spreadsheets to the State and the LA-SPCA and HSUS rescue coordinators each night.
Many thanks to the many Cajun Clickers Computer Club members who volunteered for this huge effort.
Powweb Web Hosting Special — 2 free years with purchase of 2 September 22nd, 2005
<a href="http://www.thenextwindow.com/exit.php?url_id=676&entry_id=143" title="http://www.terryscomputertips.com/computers/web_design.php" onmouseover="window.status='http://www.terryscomputertips.com/computers/web_design.php';return true;" onmouseout="window.status='';return true;">Creating a web site</a> is fun.  Learning that others visit your web site is even better.  But, the web sites you can host for free at your Internet Service Provider are sorely lacking in space (10 MB limit?  That's 6 pictures, unless I resize them!) and in functionality.  When you are ready for the next step, you need a web host that gives you plenty of space and plenty of throughput and <i>no surprise charges</i>.<br />
<br />
<a href="http://www.thenextwindow.com/exit.php?url_id=682&entry_id=143" title="http://terryscomputertips.com?u920139" onmouseover="window.status='http://terryscomputertips.com?u920139';return true;" onmouseout="window.status='';return true;">Powweb</a> offers an extremely affordable web hosting package.    It's a great deal at $93.24 per year (<i>average $7.77 / month</i>).  The price even includes a free domain name for 1 or 2 year hosting period that you purchase.<br />
<br />
<a href="http://www.thenextwindow.com/exit.php?url_id=682&entry_id=143" title="http://terryscomputertips.com?u920139" onmouseover="window.status='http://terryscomputertips.com?u920139';return true;" onmouseout="window.status='';return true;">Powweb</a> offers a large number of features.  A few of these are:  Space –  5 Gigabytes to store your pages, pictures, video files, etc;  Throughput — up to 10 Gigabytes PER DAY (not just per month!);  FrontPage Extensions;   email downsteam (POP3), email upstream (SMTP), webmail access and more for your domain.  ith Powweb, you can even let you host multiple domains within your one package, which I am doing.  Visit <a href="http://www.thenextwindow.com/exit.php?url_id=682&entry_id=143" title="http://terryscomputertips.com?u920139" onmouseover="window.status='http://terryscomputertips.com?u920139';return true;" onmouseout="window.status='';return true;">Powweb</a> to read more about their web hosting package — I think you will like it.  I use <a href="http://www.thenextwindow.com/exit.php?url_id=682&entry_id=143" title="http://terryscomputertips.com?u920139" onmouseover="window.status='http://terryscomputertips.com?u920139';return true;" onmouseout="window.status='';return true;">Powweb</a> for all my web hosting. <br />
<br />
<a href="http://www.thenextwindow.com/exit.php?url_id=682&entry_id=143" title="http://terryscomputertips.com?u920139" onmouseover="window.status='http://terryscomputertips.com?u920139';return true;" onmouseout="window.status='';return true;">Powweb</a> has just started a September Special — <a href="http://www.thenextwindow.com/exit.php?url_id=682&entry_id=143" title="http://terryscomputertips.com?u920139" onmouseover="window.status='http://terryscomputertips.com?u920139';return true;" onmouseout="window.status='';return true;">buy 2 years and get 2 years free!</a><br />
<br />
Want to create a web site but you don't know where to start? Try this book <a href="http://www.thenextwindow.com/exit.php?url_id=683&entry_id=143" title="http://www.amazon.com/exec/obidos/redirect?link_code=ur2&amp;camp=1789&amp;tag=terrystockdal-20&amp;creative=9325&amp;path=tg/detail/-/0321130073/qid=1124933488/sr=2-1/ref=pd_bbs_b_2_1?v=glance%26s=books" onmouseover="window.status='http://www.amazon.com/exec/obidos/redirect?link_code=ur2&amp;camp=1789&amp;tag=terrystockdal-20&amp;creative=9325&amp;path=tg/detail/-/0321130073/qid=1124933488/sr=2-1/ref=pd_bbs_b_2_1?v=glance%26s=books';return true;" onmouseout="window.status='';return true;">HTML for the World Wide Web</a><img src="http://www.assoc-amazon.com/e/ir?t=terrystockdal-20&l=ur2&o=1" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" />. Check out the other <a href="http://www.thenextwindow.com/exit.php?url_id=684&entry_id=143" title="http://www.terryscomputertips.com/computers/web-design-books.php" onmouseover="window.status='http://www.terryscomputertips.com/computers/web-design-books.php';return true;" onmouseout="window.status='';return true;">web design books I recommend</a><br />
Cajun Clickers – Katrina Pet Rescue Project – Still Going! September 22nd, 2005
Volunteers from the Cajun Clickers Computer Club continue our volunteer Katrina Pet Rescue Project work for the State's Office of Animal Health Services.
We're inputting information from emails and phone call notes into a massive spreadsheet that the State, the Louisiana SPCA and the Humane Society of the US are using to coordinate the actual rescues. (we do not take phone calls about pets at Clickers).
We're working again today (Thursday) and, I expect, Friday & Saturday. We start at 12:00 noon and keep going until we finish.
The last couple days, we finished at our Clickers facilities before 4pm, which has been really nice — how long it takes depends on how many volunteers we get! I take the individual spreadsheets home and continue with the consolidation work from home — with a fresh cup of my home-roasted coffee.
How did we get started? If you haven't heard, Louisiana's Assistant State Veterinarian is a Clickers member and called us for help. WE RESPONDED!
Cajun Clickers – Katrina Pet Rescue Project – on TV! September 18th, 2005
WAFB Channel 9 gave us an opportunity to talk about our volunteers' efforts on our Cajun Clickers Katrina Pet Rescue Project this morning on their “Sunday 9 News This Morning” show. Cajun Clickers members are volunteers working for the State's Office of Animal Health Services and providing “pets to be rescued” data to the Louisiana SPCA and HSUS. Lori Main and I represented the Cajun Clickers Computer Club as we were interrviewed by Scott Oswalt on the live show.
That makes two recent news reports about our project. WAFB also interviewed me and filmed in our computer lab on Thursday as Cajun Clickers volunteers were working on our project.
Friday's short piece was combined with a news report about the shelters for rescued animals and was broadcast during Friday's 10pm news and in the “Local News” repeat shows that WAFB does on cable channel 9 on Friday night and Saturday. (Channel 9 is their broadcast channel, but their broadcast is found on Channel 7 on our cable system — channel 9 cable is a WAFB continually-running local news repeat).
The Cajun Clickers Computer Club's facilities include two large lecture rooms with instructor computers and projection systems; a computer lab with 15 student computers, instructor computer and a projection system for the instructor's coputer, a “community computer” area where members can use computers for personal use, and several offices and work areas.
See us in these news reports:
- Friday, 9/16/05 10pm news — Interview excerpt and film of Cajun Clickers at work on our Katrina Pet Rescue Project for the State's Office of Animal Health Services
dialup, 764KB broadband, 4.8MB - Sunday 9/18/05 7am Sunday 9 News This Morning — Interview of Terry Stockdale and Lori Main about the Cajun Clickers Computer Club's Katrina Pet Rescue Project for the State's Office of Animal Health Services (4 minutes)
dialup, 2.8MB broadband, 17.5MB
Many thanks to WAFB Channel 9 for the interviews and filming and for the opportunity to show the recorded videos via the Cajun Clickers Computer Club's web site and via my blog. Also, many thanks to the Cajun Clickers Digital Video Special Interest Group for recording, editing and preparing the files for the websites.