mikefrizzell

import csv
import random
from datetime import datetime, timedelta

names = ["Person1", "Person2", "Person3", "Person4", "Person5"]
request_types = ["Continuing care", "Patient", "Insurance", "Attorney", "Work comp", "Law enforcement", "Regulatory"]

# Set the start and end dates
start_date = datetime.strptime('1/1/2022', '%m/%d/%Y')
end_date = datetime.strptime('12/31/2023', '%m/%d/%Y')

mikefrizzell

# They added a CAPTCHA to the form, so this won't work anymore
# There is a better version of this here: https://github.com/mikefrizzell/mo_ag_form

import requests
import random
import string
import urllib.request
import re

# URL of the webpage

mikefrizzell

// DAX code to combine multiple columns in Power BI

Combined Table = 
UNION(
   SELECTCOLUMNS(Table1, "Type", [category_a], "Number", [number_done_a]),
   SELECTCOLUMNS(Table1, "Type", [category_b], "Number", [number_done_b])
)

mikefrizzell

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim cell As Range
    Dim table As ListObject
    Dim column As Integer
    Dim emailDict As Object
    Dim email As String
    
    Set table = Me.ListObjects("Table1")
    column = table.ListColumns("User").Index