Time In Fractional Day As Used In Astronomy (e.g., MPC)– Excel Spreadsheet For Conversion (Both Ways).
Click to ENLARGE.
Time that comets are discovered are specified in this ‘fractional day’ format.
So, for example, time when C/2020 F3 (NEOWISE) was discovered per the ‘Minor Planet Center’ (MPC).
The .67810 used above is FROM this example.
The Excel FORMULAS used in the Spreadsheet.
So, now you can quickly & easily create your own Spreadsheet.
Click to ENLARGE.
I then dashed off a quick Excel for MY use. Then I decided I should create a version that I can SHARE.
Yes, of course, I could make it a download — but many would be leary of downloading it. So, intead, I am sharing the simple Excel formulas you will need to create your own. Yes, it can be made simpler. SMILE. I just wanted to show YOU the steps so you could see where I was going. SMILE. Plus, I am, at 67, not the hotshot programmer I was when I was in my 20s. SMILE.
That said, for the at least the last 25-years or more I have been using, at a minimum, Microsoft Word on a daily basis (other than when I am travelling). Most days I would use Word, Excel and PowerPoint. There was also a period of about 10-years when I used FrontPage on a fairly regular basis. And I have to confess I have taught Microsoft Office classes! Plus, I, alas, use Windows — though there was a time I was a devout Apple fanatic. Then, in 1997 I had to start using PowerPoint on Windows for some of my consulting work. At that time I had 6 Macs in the house. I had to go out and get a Windows 95 PC — for PowerPoint. Within 11-months I had multiple PCs and I was giving away my Macs.
But, I always try to avoid using new MS products.
That was the case with OneDrive. I am a heavy Google Drive user and have been for years.
But, I resisted OneDrive.
But, a couple of days ago I have to start rethinking my MS plans because, ALAS, I am planning to get a new PC with Windows 10. OneDrive is very much a part of Windows 10. I noticed that THOUGH I was not using it, my MS Office applications, e.g., Word, had me logged onto OneDrive.
So, two-days ago I decided to use OneDrive. It is really no different to Google Drive. So, there was no learning curve to speak of. Yes, it is easier to backup my Office files directly to OneDrive without having to upload them, manually, to Google Drive. NO, I do not believe in auto-backup. No siree. I like to have control,
Anywho … So far, so good. I am even impressed. It is easy enough to use and quite convenient.
Click picture to ENLARGE.
For centurial years it is NOT enough to be divisible just by 4. It also has to be divisible by 400. This is was another major improvement to the Gregorian calendar to keep the year lengths as close to 365.242199 days as possible.
So, 1700, 1800, 1900 were NOT LEAP YEARS since they are NOT divisible by 400.
But, 2000 was, because it is divisible by 400.
Excel has 1900 as a LEAP YEAR.
Yes, I am probably the ONLY one in the whole world that would NOTICE and CARE.
But, I do a LOT of date span calculations — example when I am working out ICE-OUTS for lakes. In such calculations, being the pedant I am, I take into account Leap Years. Otherwise you are mistating some date spans.
That is how I noticed.
You can check it out.
Ahead Of Pope Francis’ June 28, 2017 Cardinal Creating Consistory — A List Of All 61 Prior Consistories Since 1900.
Click to ENLARGE.
I had let this very informative Cardinal Creating Consistory Excel spreadsheet lapse after Pope Benedict XVI’s last in November 2012. That it was out-of-date always bothered me. So, I rectified that over the last few days. I also rationalized and simplified it. There is more work required BUT this is good start for this version.
I wanted to share it with you. Shows some interesting trends.
I plan to do more posts specific to the upcoming June 28, 2017 consistory over the next few days. So, stay tuned.
++++ Search ‘pope’ or ‘consistory’ for MANY other posts >>>>
++++ Check Category ‘religion’ >>>>
Do NOT follow the above Microsoft instructions.
At least on Windows 7.
It will automatically result in ALL Office 360/2016 apps, i.e., Word, PowerPoint, Excel etc. being removed from your computer — without you being asked or told.
It is not funny.
It is bloody diabolical.
Satya Nadella is such a bloody FRAUD.
Another scheming, money-grabbing FAKIR of the worst type,
with no shame.
I hate Microsoft.
++++ Search on ‘Microsoft’ for other related posts >>>>
I have been very negligent on the “College of Cardinals” front!
There are limits to what I can get done in a day.
And of late it is my papal work that suffers.
But over the last 3 days I made a concerted effort to get
MY spreadsheet up to-date, accurate and verified.
I think I am in good shape now.
It is NOT a small task.
This, albeit reduced, is what it looks like.
++++ Check Categories ‘Religion‘ on sidebar for lots of other posts >>>>
++++ Search on ‘cardinal‘ for other posts >>>>
by Anura Guruge
Alton is not alone. The fully tally of towns is 224 — or that was what it was last year. Today, November 7, 2014, we have 143 towns reporting. So we are 81 short — Alton plus 80 more.
Last year, i.e., 2013, we had the 224 in on November 9th.
Well Sunday is November 9th and we know that these numbers will NOT get posted over the weekend. They get posted on Fridays. So it will be November 14, 2014. So at least 5 days behind. If Alton makes that cut, as it probably should, they still wouldn’t be able to get the tax bills out before November 20th, if that. So, joy of joys, Alton property tax, for those of us that bother to pay, will be due just before Christmas.