Tag Archive | Excel

Time In Fractional Day As Used In Astronomy (e.g., MPC)– Excel Spreadsheet For Conversion (Both Ways).

by Anura Guruge

Click to ENLARGE.

What my Excel spreadsheet looks like. It is converting ‘.67810’ into a time format we can understand.

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.

Click to ENLARGE.

The Excel FORMULAS used in the Spreadsheet.

So, now you can quickly & easily create your own Spreadsheet.

Click to ENLARGE.

I had trouble deciphering this time format. I had to seek help from a professional astronomer — Jeff Mangum. [Thank YOU, Jeff.]

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.

Related posts:
Check Category ‘Astronomy.

by Anura Guruge


I Started Using Microsoft’s OneDrive Cold-Turkey & To My Horror, Kind Of Enjoying It.

by Anura Guruge

I have had a love-hate relationship with Microsoft for the last 30-years. To begin with it was my loyalty to IBM. But, much of it was due to my distrust of them.

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.

Related Posts:
Search ‘Microsoft’.

by Anura Guruge

Error In MS Excel 2016 — Treats ‘1900’ As A Leap Year, And It Was NOT!

by Anura Guruge

Click picture to ENLARGE.

IF you really were a Year 2000 aficionado and followed all of the Y2K drama you would know that all centurial years are NOT Leap Years.

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.

Related posts:
Search ‘Excel’.

by Anura Guruge

Ahead Of Pope Francis’ June 28, 2017 Cardinal Creating Consistory — A List Of All 61 Prior Consistories Since 1900.

by Anura Guruge

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.

Related posts:
++++ Search ‘popeor ‘consistory’ for MANY other posts >>>>
++++ Check Category ‘religion’ >>>>

by Anura Guruge

Do NOT Attempt To Repair Microsoft Office 360 or 2016 Using Microsoft Instructions!

by Anura Guruge


This is from Microsoft. Click on image to access the page at “support.office.com” though I do NOT recommend it.

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. 

Related Posts:
Search on ‘Microsoft’ for other related posts >>>>

by Anura Guruge

After A 5 Month Hiatus I Finally Updated My Master “College of Cardinals” Excel Spreadsheet.

by Anura Guruge

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.

cce1 cce2 cce3 cce4

Related posts:
++++ Check Categories  ‘Religion‘ on sidebar for lots of other posts >>>>

++++ Search on ‘cardinal‘ for other posts >>>>

by Anura Guruge

Social Security Administration: Needs 3 Months To Manually Calculate Child Benefits?

.Anura Guruge December 2014 thumbnail

by Anura Guruge

Related posts:
Kudos to SSA office Concord, N.H.
Workman’s Comp. offset.



Well, as I have shared with YOU a few times I applied for my Social Security pension now that I (to my utter amazement) lived to see 62. I don’t care what all the so called experts claim, I was NOT going to wait a day beyond my 62nd birthday. Waiting any longer seems very stupid and shortsighted. As the saying goes: “A bird in bed is worth four at the bar”.

I went to the local Social Security office, in Concord, in June, and did all the paperwork. Yes, they made me jump through some hoops but I managed.

I was TOLD that since I had two eligible kids under 18 that they too can get some of the benefits. I did not complain. I, over the years, had paid a lot of money into SSA.

Well, I have yet to see a check (let alone a proper cheque) BUT my first one is said to be on Wednesday, November 10, 2015. There were some scuffles along the way but eventually it appeared that I was all set. I do have a letter to say that — though I know it means diddly.

So that was June. We are now in October. 4 months.

Not a word about the kids benefits.

We have called 3 times — and it has to be ‘WE’ since they will only tell Deanna the information about the kids!

Last but one time we called, in September, we were told that ‘they’ will start looking into the kids’ benefits on October 8, 2015. On Monday, October 26 we called.

We were told that they have to MANUALLY compute the benefits because Deanna is on disability and that this could take 3 months to complete.

That blows my mind.

How can any computation, even by hand, take 3 months? We are talking about computing the value of Pi to trillion decimal points.

This is beyond STUPID.

Tell me the parameters and I will create an Excel spreadsheet for them in a few hours.

Amazing. Amazing.

New Hampshire (N.H.) 2014 – 2015 Property Tax Rates: 40 More Towns Report, But Not Alton.

Anura Guruge, June 8, 2013.20142015logo671


by Anura Guruge

Related posts:
2014 – 2015 rates for 103 towns.

1/ N.H. 2013 – 2014 tax rates — Nov. 9, 2014.
2/ N.H. 2012 – 2013 tax rates — Nov. 26, 2012.
++++ Search on ‘tax’ for other posts >>>>

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. 

<span>%d</span> bloggers like this: