Skip to content
View pyRobShrk's full-sized avatar
12 followers · 37 following
  • California

Block or report pyRobShrk

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
pyRobShrk/README.md

Hi, I'm Rob.

I'm not a real programmer. I'm a civil engineer with a coding problem. In 2015, while learning python, I did enough searching to participate in the Google Foobar challenge. I enjoyed the challenge, but it didn't result in an interview, despite being contacted by Google's recruiters twice. In order to continue learning with coding challenges, I have participated in the Advent of Code. Much of my AoC work was run in the browser with python through pyodide. I did all but 2019 in notebooks on starboard.gg/robsh. 2019 (IntCode) was my first live attempt at AoC, and can be found in this repository. I have a working IntCode VM in python, but I also have one in VBA/Excel so I could do maze problems using cells. I completed 2020, and in 2021 I got to Day 22. Years prior to 2019 I only worked through after the fact, until they stumped me.

Most of my interesting code is at on my Gist. A simple USGS NationalMap 10m query at least partially inspired the code at pygeodesy. At the time I created geoid.py, there was no such functionality in pygeodesy. It's possible, but not confirmed, that code inspired the implementation of Geoid 12B in pygeodesy/geoids, as it functions similarly loading the binary file and interpolating with scipy.

Other notable code for Excel I've written:

Pinned Loading

  1. AoC.2022 AoC.2022 Public

    Advent of Code 2022, I'm going to try to use Excel. First with LAMBDA, then maybe VBA or OfficeScripts.

    VBA 3

  2. pyrobshrk.github.io pyrobshrk.github.io Public

    A deployment of starboard-wrap, featuring a tool to convert geotagged images to KML

    HTML

  3. A random assortment of LAMBDA functi... A random assortment of LAMBDA functions for Excel
    1 
    /*
    2 
    Name: Show Moon Phase Emoji (MOONPHASE)
    3 
    Description: Returns a lunar phase character closest matching to any Excel Date/Time value.
    4 
    If you calculate for daily values at midnight, the lunar cycle will be the same for every 3 or 4 days (3.691 days).
    5 
    🌑🌒🌓🌔🌕🌖🌗🌘
  4. aoc2019 aoc2019 Public

    https://adventofcode.com/2019

    Python

  5. Convert Excel Trendline to LINEST Convert Excel Trendline to LINEST
    1 
    Sub ExtractTrendline()
    2 
        Dim outRng As Range
    3 
        Dim useB As String
    4 
        Dim poly As String
    5 
        Dim poly2 As String
  6. Godin Filter jython script for HEC-D... Godin Filter jython script for HEC-DSSVue
    1 
    # name=Godin
    2 
    # description=This jython script reads your DSSVue selection, and performs Godin tidal smoothing.
    3 
    # description=The original 1972 Godin algorithm was to apply successive 25-hour averages to hourly data.
    4 
    # description=This filter is slightly modified for 15-minute data, and specific to the periods of tidal constituents.
    5 
    # description=The 51-period (12.5-hr) filters M4, MS4 and MN4, 97-period (24-hr) filters S2 and K2, and 101-period (25-hr) filters M2, N2, and L2.