The computer did not resync because the required time was change to big w32tm /rsync

My computer defaults to a 2002 date when it boots. When I tried to run w32tm /resync it shows this error:

The computer did not resync because the required time was change to big

This is easy to fix. From the command line add one more parameter to the w32tm command:

w32tm /resync /force

Synchronise update time from internet time server Windows command line cmos battery dead

w32tm /resync

My desktop PC’s CMOS battery is dead and each time it boots up the time is set to 2002. I really don’t mind the time being wrong except when web pages do not load showing invalid security certificate.

The above command needs to be run using an administrative privileged command line.

This is same as right clicking the clock (taskbar left) > selecting Adjust date/time > Internet time > Change settings > Update.

My system defaults to 2002 when it boots from a complete power off state. When I tried to do the above command it gave the following error: The computer did not resync because the required time was change to big I’ve a fix here

Google I’m feeling lucky from addressbar in Firefox

Google I’m feeling lucky

  1. Right click on the link and select Bookmark this link (Ctrl+Shif+B)
  2. From the bookmarks menu click Show all bookmarks
  3. Search for “google feeling” to find the page we just bookmarked.
  4. Select the link we bookmarked and click More
  5. In the keyword field give gfl.

Now from the address bar just start the search with gfl search query and it will be similar to pressing the I’m feeling lucky button in Google Homepage.

Google I'm feeling lucky in Firefox bookmark keyword edit

This is a note for future when I reinstall browser/OS.

CPA Exam credential evaluation: ACCA + BSc Oxford Brookes University (OBU)

Getting information about how to appear for CPA Examination of the US is a mess. Each state has its own set of rules and regulations: different citizenship and residency requirements, myriad credential evaluation agencies, different set of requirements for sitting the exam and another set for granting licence so on and so forth.

Generally in many states 120 credit hours will be sufficient to sit for the exam and 150 credit hours to get the license.

Chad Sinclair an ACCA member (FCCA) writes about his attempt at obtaining the CPA certification as an ACCA + BSc from Oxford Brookes University:

In 2012 I started my credential evaluation journey and submitted my Oxford Brookes University Degree obtained through Oxford Brooke’s partnership with the ACCA (Association of Chartered Certified Accountants) to ERES (Educational Records Evaluation Service). I received 120 US Semester Credits which prior to the CBA (California Board of Accountancy) changing the requirements to become a CPA in CA this was more than sufficient.

He got 120 US semester credits which is sufficient to sit for examinations even now. But I have seen people posting in discussion forums that ACCA + Oxford Brokkes BSc (OBU) didn’t earn them 120 credit hours — there are people who got only 90 for both (see the comments under Sinclair’s post). This will depend upon the credential evaluation agency used (and your luck?).

Sinclair advises you to pick the evaluation agency wisely:

So here is my advice on how to pick an evaluation company.

  1. Firstly speak to an evaluator either in person or over the phone.
  2. Make sure they have knowledge of your qualifications
  3. Make sure if you have non-college qualifications i.e. Vocational or Professional Qualifications that require evaluation that the firm knows of the course or credential and ask them if they have evaluated this qualification before.
  4. Pick the firm that is the most knowledgeable about your educational experience.
  5. Complete the necessary paperwork and be as open and transparent as possible to aid the evaluator in reviewing your credentials.

Progress of computing power: time to recalculate in Excel

F9 is used to manually recalculate the sheet in Microsoft Excel.

A little anachronistic though, no?
I was a junior analyst 25 years ago with not one but two PCs.
Compile excel report on PC 1 and hit F9. Start working on different report on PC 2 while PC1 slowly counts down.

Can’t remember the last time I hit F9 – Oliver Thornton @ Financial Director

Shows how big the improvements in the processing power of the computers used now and systems used then. Now, I don’t have to press F9 to manually recalculate and wait for the results at any time. It is all instantaneous. There may be still use cases for this option when doing big modelling tasks that have great quantum of variables and functions and formulas that are complex; but for most users waiting for Excel to finish running a calculation is over.