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

Block or report pyRobShrk

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.