Random thoughts about using computers to do things. Presently using an Alienware Aurora Desktop (Windows 10) , a Dell XPS 13 developer edition (Ubuntu 19.04) a Dell Precision M2800 laptop (Windows 10), a Mac Mini, an Apple iPhone 7, an Apple iPad 6, a Samsung Galaxy S8, a Samsung Tab A (2018), an iPod Classic 160GB plus CD's, DVD's, USB keys, and zip disks everywhere. Enjoy learning computing with me.
Wednesday, June 25, 2008
Sunday, June 22, 2008
Documenting some chart making in Open Office and Excel.
I downloaded some data that was free. There were only 5 years covered. I have been using years as my X axis for the past two weeks. The data was divided by age groups and I only downloaded 5 year age bands from 45 to 89 and then 90 and over. It was for cause of death data and is published annually. These vital statistics are free for download. I have around 27 causes picked out. I had the data for both sexes and for men and for women. So for each year I had a column and for each age band and each of the 3 gender categories I had the 27 causes in rows. All in all about 750 rows of data.
I downloaded that data into a spreadsheet. I then created a new sheet in that workbook. Editorial Note: When one downloads data it seems the workbook has only the one sheet unlike when one creates a new workbook with three sheets. In the new sheet I copied totals for cause of death for the same age bands and the same gender categories but from all causes of death in Canada. This was copied from a separate download. These two sheets were then not changed and after this step; data were only copied out from these two download sheets. Then in a third sheet I made my own row labels for the genders and age bands matching the second sheet's row ordering. The labels from the database were lengthy and unreadable in the width of my spreadsheet window and the differences between the labels could not be viewed easily. Editorial note: the labels were so long not even a 30 inch monitor would display them completely I am guessing. These new labels were shorter and after much copy and pasting I had made all some 31 rows labels by age bands and gender categories. They were in the same row ordering as the downloaded deaths by all causes. I then made five year columns after these row labels in the first column and copied the totals deaths by all causes by years data to this sheet.
Then I went back to a copy of the death by specific causes download in separate workbook and saved a copy of that download as a text file or comma separated file. I then closed it and imported it. I imported the data as a text file. This is one of my data handling tricks that could also be done with regular expressions if one was using a programming or scripting language. The picking of the appropriate delimiters is the trick. I chose delimiters during the import that would cut the long row labels in this file so that the specific causes' names, age band's names and gender names, were all brought in to this new spreadsheet in separate columns. Actually I used three columns and then copied these labels into a new fourth sheet in my main workbook. The row order for the 750 rows was preserved.
I then went back to the first sheet in the main workbook with all the cause specific data and copied all the data but not the labels into the new fourth sheet. So sheet four was the same as sheet one, but I now had three columns for labels and the labels were short and readable on the screen. I then made new rows in sheet four at the top of the beginning of each specific gender category (both sexes, males, females) and the beginning of each age band (5 year age bands 45-89 and the age band 90 and over). So when for example, the data for both sexes, 45 to 49,and 27 rows of specific causes of death started in the sheet, a new row started the 27 rows for both sexes, 45 to 49 years old. Then going back to sheet three with the total causes of death by genders and age bands, I added two more columns between the labels and the yearly totals columns to make a proper column alignment with the three column labels in sheet four. Then one at a time, the new rows I had created in sheet four were pasted with the rows from the 31 age and gender specific death by all causes data and short labels for gender and age bands from the third sheet.
I was now ready to calculate some results. I created formulas for counts for specific causes over total causes and then made this number a percent. I used the real number for the total but for the specific cause count I used a cell reference. I then filled down the columns into the 27 specific causes effecting the calculation for all five years and all 27 causes for the first set of data which was 45 to 49 both sexes. This was the only data I worked through today. I still had these 27 cause specific rows by 5 years columns of data highlighted after the fill so I then used format cells to change all the numbers to percents with 6 decimal places.
I then charted all non-zero rows basically following the charting techniques in Excel I have learned at work but I did it in Open Office. Somethings are done differently in Open Office charts. I then also did a counts chart that matched the percents charts but makes no reference to total deaths. After a long break, I spent some time formating the charts for printing and printed the two charts out.
I then saved and closed all the workbooks. I thought it would be a good idea and relaxing and good for my intellectual health to document all my work so I have posted this notes.
Wednesday, June 11, 2008
I used Disk Utility to Seven Pass erase a USB key.
I am getting some old SLR lenses
Hard drive space on the Sun Machine.
Sunday, June 08, 2008
Sun machine
Friday, May 30, 2008
Chapter one read now in Solaris 9 for Dummies
Friday, May 09, 2008
The eMac2 finder is working again.
Thursday, May 08, 2008
The eMac2 is having troubles but fixes are being attempted and emergency critical backups have begun for right now in case of further failure.
I did think last night to access the folders remotely using the Macbook1. So slowly late last night I have been copying the email folder and mail download folder off of the eMac2. I have shut off the email and the plan is to use the email software on the Macbook now.
Speaking of changing email software, I did loose a little email for about 1 hour's worth of incoming email on the Linux machine when I thought of switching to Linux for a main email computer. But I should learn to copy Mac Mail to Linux and also to Thunderbird email software on Vista. I still do not have a way of transferring email between operating systems other than Netscape email. I am hoping Thunderbird can do this too as Netscape is now closed as a company. This reminds me I need to access Netscape downloads and download some historical copies of the browser.
After my back up I will try to read all this email in the IBM under both Linux and also Vista. If this works I will try to load all the email into Solaris but I doubt there is room on the old Solaris box
I am also remotely deleting the last folder made on the eMac2 which was the burn folder for the backup I was trying to make. I am hoping that when this burn folder is deleted the finder will work again. If this does work out this way the situation will be less critical.
The only follow up may be simply increases the backup frequency for the eMac in future. I guess I would also stop burning disks on the eMac2 and try to avoid a similar problem in the future. I may also continue to follow through on switching some main computer tasks off of the eMac2 and onto a different but newer computer.
I can also just look up how to manually eject the DVD and that may solve the problem too.
Sunday, April 27, 2008
Still burning backup DVD's from the 2006 state of the Macbook1.
The email from 2006 is all backed up now to six DVD's and properly labeled. The whole user folder is not being backed up to a number of separate DVD's and I am not sure how many DVD's I will need to split the user folder into. So far I have the folders and files decided for two DVD's and the first disk is now burned to six identical copies. The backups continue.
Monday, April 21, 2008
Buying a Tadpole laptop
Saturday, April 19, 2008
My final exam was written. I did so so.
Saturday, April 12, 2008
I enjoyed a creative person's gathering in Second Life or a creativity meeting in a virtual world
Slowly installing the media wiki on the Debian Linux IBM Thinkcentre
I have been using the media wiki quite a bit on the Macbook for my study organisation. I have also been using LATeX much more and have learned to use BibTeX now.
For fun I have been playing Eve Online.
I must focus on school work now so tinkering will have to be put on the back burner for a week or so because it takes a lot of time to do.
Tuesday, March 25, 2008
Fink is now updated and the Macbook has a fresh install of the X code developer tools.
Sunday, March 23, 2008
Drupal is up and running with some issues.
I will now install Drupal on my Macbook.
Saturday, March 22, 2008
Mediawiki is installed on my Macbook now
I am setting up a study wiki on my own computer not to be web based.
To use a Wiki I selected I needed to install it on my Macbook. I first had to start Apache which I have done. I then needed to install MySQL 5.0 which I have downloaded and run two installers and then added the preference panel for MySQL. But so far I can not get MySQL started. I have studied MySQL in the past. I also managed to edit the file httpd.conf for apache so that PHP 5.0 will run now. I had to use vi for the edit and also chmod to change the permissions on the file so I could save my edit. I then changed the permissions back too. I had to use Linux for Dummies to use vi and to use chmod. I will leave this note here and report back later. I did take a break at this point to read some books before documenting this. I am now going back to the install of MediaWiki following the instructions for that software. It promises TeX support and images. I am going to run MediaWiki on my laptop and not serve it over the net.