-
Notifications
You must be signed in to change notification settings - Fork 0
Leg Tech
Create an inflation calculator for Google sheets drawing on Bureau of Labor Statistics (or another source) to calculate inflation. As inputs you should be able to assign a particular row or column as indicating the starting comparison date (as a year) and a finishing comparison date (as a year). To make this work you should be able to drag down the row to automatically inflate all the elements in that row.
The formula should be something like =(source monetary amount cell, original year to be inflated cell, final year to be inflated cell)
When a button on Firefox is pressed, it should create a new google document in a pre-set folder. A window should pop up prompting for the name of the person being met with. The new file should be named in the format of date and the person's name -- e.g.: 2025-01-15 Jane Smith. The new Google doc should be opened with the person's name centered in the first row, the date centered in the second row, and the cursor left aligned on the fourth row.
I've already built the script but I can't get it to deploy permanently on firefox.
Congress does a poor job of publishing relevant information about hearings in one place.
Step 1 is to create a spreadsheet that pulls in the following data:
- Hearing date
- Whether it's a hearing or markup
- The title of the proceeding (probably separate column for event ID)
- The name of the committee of jurisdiction (probably separate column for unique ID of the committee)
- Whether it is a full committee or subcommittee proceeding
- The webpage for the proceeding from the committee
- The webpage for the proceeding from docs.house.gov (if it's the House) // Senate info comes from the senate committee info page
- Where the video is available (youtube or akami)
- Where you can find the transcript
This is regularly updated as new information is added on: Congress.gov, docs.house.gov, the relevant committee youtube page, the relevant committee webpage
Also note that committees often forget to put the event ID in the YouTube page, so you'll have to do fuzzy logic to match some of the committee proceeding video names with the official committee proceeding name available on the House or Senate committee pages (or via the Congress.gov API)
Step 2 is to update a Wiki page (like this one) to publish the information as prose and update the hyperlinks as appropriate.
Step 3 may be to provide notice to the user when new information regarding a relevant committee of jurisdiction is published.
I care particularly for House Admin and Senate Rules.
As mentioned in Unified Hearing & Markup Data, committees do not always do a good job of putting the event ID on Youtube videos.
The purpose is to either encourage committees to put event IDs in their video descriptions on youtube or alert committees when they've failed to do so.
We should track all the various committee youtube videos and crosscheck them against official event id information either from congress.gov (API?) or docs.house.gov.
There should be a dashboard that lists all committee names. Under each committee it should indicate how many proceedings the committee has held and whether the youtube video includes the event ID. (If it does not, the video won't show up on congress.gov). We can match the existence of the videos by looking at the date of the video and its title and fuzzy match against official notice of hearings from the committee. Probably should look at video length to make sure it's the full proceeding.
You then want the dashboard that does a few thing
-
Ranks committee consistency of putting event ids on videos. Committees with the highest consistency get a good grade, those with low consistency get a bad grade.
-
Also consider a feature where once a week the committee is emailed with a list of videos that don't have event IDs, with a link to the youtube page for the video and the event ID they should include.