Some of you readers are a lot smarter than I am, and I happen to be stuck. I’d be obliged if any of you can wrap your minds around this problem and tell me how to do it.
One of the projects I work on daily involves series regularly scheduled ‘events’ happening across the world. Every day they’re conducted at the same locations and at repeated intervals, several hundred times each day for each location.
I know the precise geographic coordinates for the locations and the local times of the events. But one part of the experiment requires examination and comparisons of simultanious events, say, from a location in Australia, another in NY, another in Rhode Island, to keep it simple.
But two events happening, say, in Rhode Island and New York at the ‘same time’ by the clock are actually several minutes apart. They occupy the same time zone, but events in Rhode Island at 3PM aren’t the same events as those happening in NY at 3PM.
But even without taking DST into the equation, events in Australia might be 15 hours and 30 minutes later by the clock to be simultaneous with New York, or Rhode Island, and only one of the two. The event in one would be simultaneous with Australia several minutes earlier, or later, than the other.
I can calculate minute-by-minute sidereal times for each of the locations, but establishing a baseline for the relationships in terms of simulataneity eludes me. I do all this on a spreadsheet. I know nothing about programming computers.
I’d welcome any suggestions. Particularly if it involves something automatic and repeatable. It’s probably something simple, even stupid, but I’d like to get past trying to figure out how to do it and get around to actually doing it.
Gracias, Old Jules
I’ve got to get going. I’ll be back online sometime later today.
Like this:
Like Loading...