Here, I show step-by-step a complete weather application built using Python. Along with the critical explanations, the full source code is also included. The app makes a RESTful API call to weather service, gets the results back in JSON, then it parses the information and presents it in locale-specific format. The information we will send […]
Author: tony R.
Parsing date-time string and formatting according to AM/PM (Excel)
Here’s a relatively quick way to parse a date-time string or any string (regardless of data type in your source) containing date and/or time. It doesn’t matter if the time format is in 12 or 24 hour format, this method works. The time portion of the data can be in HH:MM:SS or HH:MM or similar […]
A quick holidays & events calendar (Excel)
A no-frills demonstration (with actual, real data) of building and publishing a calendar of holidays/events in the United States. Covers 2020 through 2023 and includes major religious, political, and federal events and holidays as a quick reference. Below is the dynamic, real-time version: For interactive tables, visualizations, tips, demos and more, please explore this blog: […]
Tracking Actual vs. My Predictions 4/29/20
Back in March 2020, I did some predictive modeling using simple math and Excel where I presented 3 scenarios: Likely, Best-case, Worst-case. You can read the original blog here: What-If Models (COVID-19): Results Let’s take a look at today’s latest data from WHO and compare my Model 1: Likely Scenario numbers. We’ll compare the USA […]
Generating, plotting trajectory and…gamification (Excel)
Reminiscing the old tank game, I wanted to re-create a low-weight, low-code option of that simulation. The game depended on a canon (projectile) shot at your selected speed and angle to hit an enemy tank. The foundational formula is used in missile launch, sports, and many (you guessed it) military applications. Here, using the same […]
COVID-19 Update 4-16-20
Another somber perspective of WHO’s official COVID-19 data released 4/16/2020:
COVID-19 Update 4-14-20
Showing Corona virus cases and deaths across selected countries for March 1st, 2020 to April 14th, 2020.
COVID-19 Trends Update: 4-11-20
GLOBAL VIEW INTERACTIVE CHARTS Data retrieved from official WHO daily publications and worldOmeter.
Some of my faves: Live-Streaming Underwater Cams
Here are some of my favorite live-streams of underwater cams. They range from sharks, to coral reef life, to manatees. Also, there’s a link for an hour-long meditation while watching the apex predator of the underwater. Enjoy! Coral City Camera. Miami (FL, USA) Live stream from an urban coral reef in FL. Great streaming and […]
How close were my initial models?
How close were my initial models? Let’s compare with today’s data. Take a look back on my educated-guess-but-not-official models that I created back in March 22, 2020: What-If Models (COVID-19): Results Today’s numbers for USA from WHO are (on 4/1/2020): # of confirmed cases (infected): 163,199 and confirmed deaths: 2,850 My four models were agnostic […]