Replacing Primary Drive with Solid State Drive

I have recently converted both my wife’s laptop and my desktop to an SSD as the primary drive.  SSD pricing has come down to where converting your primary drive to speed up your machine is worth considering.  My machines are all using SATA 3, and don’t support NVMe, so the fastest SSDs can’t be used, but SATA SSDs still give a much appreciated speed improvement.  I put a Western Digital Blue 1 TB in her laptop, and a SanDisk 1 TB in my desktop.  These two SSDs are the same unit (SanDisk is owned by Western Digital) but the SanDisk was two dollars cheaper.  May have been overkill, but we won’t run out of space, and the bigger drives have a little better performance.

There is one caveat I have to pass on.  It concerns any instance where the current machine contains a small SSD as a speed up device for a normal HDD installation.  This was the case with my Dell XPS 8700 SE, which was purchased from Costco in late 2013, and contained a 32 GB Samsung PM830 SSD mounted in an mSATA socket on the motherboard.  It never reported as a separate drive in Windows, but is listed in the Dell BIOS.  A casual user would never be aware of it.  It contained some of the Windows boot files, and led to some speed up but only when booting Windows.  The only other place I was aware of any improvement was with CCleaner, which evidently used some of it as a cache.

I have one problem to report, which appeared with the SanDisk.  The instructions suggested downloading and installing SanDisk Dashboard software for measuring SSD performance.  When I used that software to report on my new SanDisk, it gave blank results.  I later discovered that this was caused by the small 32 GB SSD, which confused the software.  I had cloned my HDD to the new SanDisk SSD using MiniTool Partition Wizard on my laptop.  All the Windows boot files had been on a reserved partition of the HDD, and were now on the new SanDisk.  I no longer needed the small SSD, so I removed it physically from the motherboard socket and rebooted into Windows.  Everything works OK, and the SanDisk Dashboard now reports as it should.

The point I am making is that if anyone who has a system that might have a small SSD in it for fast boot, such as a Dell XPS or similar, and is considering switching to an full size SSD for drive C, the small SSD will be superfluous, and is no longer needed.  Just a heads up.

Bob

Decision Making Using Excel

Abstract

This course is intended for those students who are familiar with the fundamentals of working with spreadsheets, but want to know more about using Excel logic functions to solve problems.

For those of you who have taken my older 2016 Basic Excel class, it is a total replacement for all the material related to the file “StockPurchasingTable.xls”, and contains many enhancements.  So even if you understood the older file, you will probably benefit from examining this new course.

All files and documents pertaining to StockPurchasingTable are now deleted.

The material in the new course is based on an investing concept (the same as before) but is considerably expanded, and appears to possibly have application in other areas, such as retail sales.  I am working on the retail aspect, but it is not mature enough yet to be included in the course at this time.  If anyone is interested in working with me on the possibilities for a retail application, please contact me.

This course uses four new Excel files and three Word supporting files, listed below:

For Part 1:

1. Decision Making Using Excel-Part 1.docx
2. Redistributing A-Z – Initial.xlsx
3. Redistributing A-Z – Equalized.xlsx
4. Formulas Used in Redistributing A-Z.docx

For Part 2:

1. Decision Making Using Excel-Part 2.docx
2. Redistributing A-Z – Final1.xlsx
3. Redistributing A-Z – Final2.xlsx

This abstract, course documents, and Excel files are available for download here===>> Download Files

Contact Bob Mugge at  bob.mugge@tvcuc.org