29:null 2a:["$","title",null,{"children":"The EECS Graduate Funding Handbook | David Cao | Observable"}] 2f:T544,{ if (firstYearIntro.length > 0) { return md`Do you remember seeing this passage in your email: > We commit that the minimum additional financial support that you would be receiving for each of your years in the program is $34,000 as long as you meet the terms and conditions of the funding. > > _—EECS Funding Email_ Do you remember thinking, "why wouldn't they give me a clear answer on how much they're gonna pay me?" I have an answer for you. **They're underpaying you.** During the 2023-24 school year, you will be paid **${ d3.format("$,.2f")(d3.cumsum(monthlyPay(gsrSteps, [ { appointment: 0.5, step: 7, ...schoolYear[2023] }, ]), d => d.value).slice(-1)[0]) }**, not $34,000. Over the course of your entire first year, summer included, **you will lose ≥ ${ d3.format("$,.2f")(d3.cumsum(vals(2023, 9), d => d.value).slice(-1)[0] - d3.cumsum(vals(2023, 7), d => d.value).slice(-1)[0]) }** in earnings. They didn't want you to know this when you were comparing funding offers to other schools, who were willing to pay you more. Don't believe me? Want to learn more? Read on to find out. `; } else { return md`Did you know that the department is trying to pay you less over the summer to _erase the wage gains you made during the last round of strikes?_ Don't believe me? Want to learn more? Read on to find out.` } }30:T5e2,raises = { let calcSum = (year, fyAdj = true, summerAdj = true) => { let step = (year >= 2023 && fyAdj) ? 7 : 9; let appt = (year >= 2023) ? 0.5 : 0.48; let summerAppt = (year >= 2023 && summerAdj) ? summerTA[1] / 100 : 1.0; let v = [ { ...falls[year], appointment: fallTA[0] != "No" && year >= 2023 && summerAdj ? fallTA[1] / 100 : appt, step: summerAdj ? getTAStep(fallTA[0], step) : step, ta: fallTA[0] != "No" && summerAdj }, { ...springs[year], appointment: springTA[0] != "No" && year >= 2023 && summerAdj ? springTA[1] / 100 : appt, step: summerAdj ? getTAStep(springTA[0], step) : step, ta: springTA[0] != "No" && summerAdj }, { ...summers(year), appointment: summerTA[0] != "No" && year >= 2023 && summerAdj ? summerTA[1] / 100 : summerAppt, step: summerAdj ? getTAStep(summerTA[0], step) : step, ta: summerTA[0] != "No" && summerAdj }, ] return cumulPay(monthlyPay(gsrSteps, v)); }; let result = []; for (let year = 2013; year <= 2024; year++) { result.push({ date: new Date(schoolYear[year].start), value: d3.max([calcSum(year, false, false), calcSum(year, false, true)]), typ: "Ideal circumstances", }); result.push({ date: new Date(schoolYear[year].start), value: calcSum(year, false, true), typ: "Continuing student", }); result.push({ date: new Date(schoolYear[year].start), value: calcSum(year, true, true), typ: "First year", }); } return result; }31:T458,// input is in the form: // [{ start, end, step, appointment, ta? }, ...] // start and end are js Dates // step is a number 1 through 10, corresponding to old step amounts // appointment is a number 0 to 1. monthlyPay = (stepLevels, input) => { if (input.length === 0) { return []; } let result = {}; for (let item of input) { let is = moment(item.start); let ie = moment(item.end); while (is.isBefore(ie)) { let startOfMonth = is.clone().startOf('month'); let endOfMonth = is.clone().endOf('month'); let s = moment.max([is, startOfMonth]); let e = moment.min([ie, endOfMonth]); if (!(endOfMonth in result)) { result[endOfMonth] = 0; } if ('ta' in item && item['ta']) { result[endOfMonth] += wageFromTable(ta2023, item.step, item.appointment, s, e); } else { result[endOfMonth] += wageFromTable(stepLevels, item.step, item.appointment, s, e); } is = startOfMonth.clone().add(1, 'months'); } } return Object.entries(result).map((e) => ( { date: new Date(e[0]), value: e[1] } )); }32:T6fa,inflationGraph = (until, extraMarks = [], studentType = "Continuing, post-quals", summerAppt = 1.0) => { if (until < 2013) { return; } let years = until - 2013 + 1; let tgtCpi = cpiProj.orderby(aq.desc("date")).object(0).cpi let lines = d3.transpose([...Array(years).keys()].map((i) => { let isLowerStep = studentType.includes("First") && 2013 + i >= 2023 let isLowerAppt = !studentType.includes("post-quals") && 2013 + i <= 2022 let useCustomSummer = 2013 + i >= 2023 return vals(2013 + i, isLowerStep ? 7 : 9, isLowerAppt ? 0.48 : 0.5, useCustomSummer ? summerAppt : 1).map(v => { // Get current cpi let curCpi = cpiProj.filter(aq.escape(d => d.date <= v.date)).orderby(aq.desc("date")).object(0).cpi return v.value * tgtCpi / curCpi }) })) let data = vals(2023, 9).map((v, i) => { let vals = lines[i] let res = Object.fromEntries(vals.map((v, i) => [i + 2013, v])) res.date = new Date(v.date) return res }) data = aq .from(data) .fold(aq.not("date")) .groupby("key") .derive({ value: aq.rolling(d => op.sum(d.value)) }) data = data .derive({ value: aq.escape(d => { let v2013 = data.filter(aq.escape(i => i.key == 2013 && i.date <= d.date)).orderby(aq.desc("date")).object(0).value return d.value - v2013 }) }) return Plot.plot({ x: { inset: 4, tickFormat: "%b" }, y: { grid: true, label: "difference in earnings v. 2013 (2023 USD)" }, color: { type: "sequential", scheme: "Viridis", label: "Year", legend: true, }, marks: [ Plot.lineY(data, { x: "date", y: "value", stroke: "key", tip: true, }), ].concat(extraMarks) }); }33:T975,inflationGraph2 = (until, extraMarks = [], studentType = "Continuing, post-quals", summerAppt = 1.0) => { if (until < 2013) { return; } let years = until - 2013 + 1; let tgtCpi = cpiProj.orderby(aq.desc("date")).object(0).cpi let lines = d3.transpose([...Array(years).keys()].map((i) => { let calcSum = (year, fyAdj = true, summerAdj = true) => { let step = (year >= 2023 && fyAdj) ? 7 : 9; let appt = (year >= 2023) ? 0.5 : 0.48; let summerAppt = (year >= 2023 && summerAdj) ? summerTA[1] / 100 : 1.0; let v = [ { ...falls[year], appointment: fallTA[0] != "No" && year >= 2023 && summerAdj ? fallTA[1] / 100 : appt, step: summerAdj ? getTAStep(fallTA[0], step) : step, ta: fallTA[0] != "No" && summerAdj }, { ...springs[year], appointment: springTA[0] != "No" && year >= 2023 && summerAdj ? springTA[1] / 100 : appt, step: summerAdj ? getTAStep(springTA[0], step) : step, ta: springTA[0] != "No" && summerAdj }, { ...summers(year), appointment: summerTA[0] != "No" && year >= 2023 && summerAdj ? summerTA[1] / 100 : summerAppt, step: summerAdj ? getTAStep(summerTA[0], step) : step, ta: summerTA[0] != "No" && summerAdj }, ] return monthlyPay(gsrSteps, v); }; let isLowerStep = studentType.includes("First") && 2013 + i >= 2023 let isLowerAppt = !studentType.includes("post-quals") && 2013 + i <= 2022 let useCustomSummer = 2013 + i >= 2023 return calcSum(2013 + i, isLowerStep, true).map(v => { // Get current cpi let curCpi = cpiProj.filter(aq.escape(d => d.date <= v.date)).orderby(aq.desc("date")).object(0).cpi return v.value * tgtCpi / curCpi }) })) let data = vals(2023, 9).map((v, i) => { let vals = lines[i] let res = Object.fromEntries(vals.map((v, i) => [i + 2013, v])) // res.date = new Date(summers()) return res }) data = aq .from(data) .fold(aq.not("date")) .groupby("key") .derive({ value: aq.rolling(d => op.sum(d.value)) }) .slice(-1) .derive({ date: aq.escape(d => new Date(schoolYear[parseInt(d.key)].start)) }) return Plot.plot({ marginLeft: 56, y: { grid: true, label: `Amount (2023 USD)` }, subtitle: `Inflation-adjusted yearly salary, 2013-${until}`, marks: [ Plot.lineY(data, { x: "date", y: "value", tip: true, }), ].concat(extraMarks) }); }34:[{"id":"0272cebb2ece74bde7d29f212220f57ac4c8d569eec26f006c3151f6b88845c9a5127a46fda4fdd8f52a45181c3c1d17b52ef94732b0e9c5a9ba2338eaa14530","href":"https://static.observableusercontent.com/files/0272cebb2ece74bde7d29f212220f57ac4c8d569eec26f006c3151f6b88845c9a5127a46fda4fdd8f52a45181c3c1d17b52ef94732b0e9c5a9ba2338eaa14530","name":"food-inflation-sf.csv","type":"text/csv","lastModified":1695680405844.642,"size":701},{"id":"a916d57572f952d209732d21a7cfffb914bd6bfb2a4c36e7f9554b9299082e1d810de0999679655f26428b1f13c87c756cdf8383f0418b002617acbb918787fc","href":"https://static.observableusercontent.com/files/a916d57572f952d209732d21a7cfffb914bd6bfb2a4c36e7f9554b9299082e1d810de0999679655f26428b1f13c87c756cdf8383f0418b002617acbb918787fc","name":"overall_inflation_2023_12.csv","type":"text/csv","lastModified":1705379782525.817,"size":751},{"id":"e89346c14073a4f5fa690165f5ea751eebc8dbd2ee6e0f9b9d6ad695b6a18e1af5ef947e24e882732792af6bd60a3a36df4fd39397b8aa65d341a8a31eca519f","href":"https://static.observableusercontent.com/files/e89346c14073a4f5fa690165f5ea751eebc8dbd2ee6e0f9b9d6ad695b6a18e1af5ef947e24e882732792af6bd60a3a36df4fd39397b8aa65d341a8a31eca519f","name":"eecs_steps.csv","type":"text/csv","lastModified":1694637933504.034,"size":1107},{"id":"8d2cb10e9e5ebc1abae0c5023569ade8557ac29e10be10a0f81c40ee1eea42fa78ad94dbc6c8eddb6b92b3870cf9a008dd74bdf7c2520fe4f1c7bf10094c5b54","href":"https://static.observableusercontent.com/files/8d2cb10e9e5ebc1abae0c5023569ade8557ac29e10be10a0f81c40ee1eea42fa78ad94dbc6c8eddb6b92b3870cf9a008dd74bdf7c2520fe4f1c7bf10094c5b54","name":"eecs_steps@2.csv","type":"text/csv","lastModified":1694847086788.493,"size":917},{"id":"3c9af8c95e085e4c3da4f4c1e4dca57f39806fe827123231600fc6f2fa3c93ed39d188fb9b0f2a67ba45a64544f14496a72d281d4fbe76b6ab1c12b77df9b698","href":"https://static.observableusercontent.com/files/3c9af8c95e085e4c3da4f4c1e4dca57f39806fe827123231600fc6f2fa3c93ed39d188fb9b0f2a67ba45a64544f14496a72d281d4fbe76b6ab1c12b77df9b698","name":"inflation-sf.csv","type":"text/csv","lastModified":1694850274335.953,"size":701},{"id":"0b3bdef748b5864f390cbd90f58297474657153655c4e2df906a7cd77af9608c7062532a45cf89e0039fed3bcca56aaf5940b53269947c52c0a6a87900e2d983","href":"https://static.observableusercontent.com/files/0b3bdef748b5864f390cbd90f58297474657153655c4e2df906a7cd77af9608c7062532a45cf89e0039fed3bcca56aaf5940b53269947c52c0a6a87900e2d983","name":"eecs_steps@3.csv","type":"text/csv","lastModified":1694853634351.696,"size":850},{"id":"2e226d66e4b664b41541998eba65cf3bdf618932523590c5bacc2721bdb931b4cc5fa90c4288ac4dc4aeaf8c855922f02d36d482b02668bb9955a32112b69873","href":"https://static.observableusercontent.com/files/2e226d66e4b664b41541998eba65cf3bdf618932523590c5bacc2721bdb931b4cc5fa90c4288ac4dc4aeaf8c855922f02d36d482b02668bb9955a32112b69873","name":"eecs_steps@4.csv","type":"text/csv","lastModified":1694853666871.559,"size":851},{"id":"cd305bf48f1e271843b238f48efa0e12bda4a2bcbeb4a5a71f211f58bcd2ff58ee4551d339a44d1989448411955897cee919b74ea27f837538835783763227b9","href":"https://static.observableusercontent.com/files/cd305bf48f1e271843b238f48efa0e12bda4a2bcbeb4a5a71f211f58bcd2ff58ee4551d339a44d1989448411955897cee919b74ea27f837538835783763227b9","name":"rent-inflation-sf.csv","type":"text/csv","lastModified":1695070496465.393,"size":1149}] 2d:{"id":"6b1364543ef260d9","slug":"eecs-graduate-funding-handbook","title":"The EECS Graduate Funding Handbook","thumbnail":"55e63b4b28688a88256d6cdd72299d6ca05e846ad95f26b7c8fb6f96cffcac1c","access_level":"public","create_time":"$D2023-09-13T05:01:26.722Z","update_time":"$D2025-08-25T19:00:59.181Z","view_time":null,"first_public_time":"$D2023-09-13T05:01:26.722Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"e3ce707e1f046767","login":"dcao","name":"David Cao","avatar_url":"https://avatars-next.observableusercontent.com/0f67222e9f8d2b106a9074ba7adb0c1ab2bdb75396bd04aa54430a025d82691f","tier":"starter_2024"},"version":3934,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"c8f2489426bdf163","login":"dcao","name":"David Cao","avatar_url":"https://avatars-next.observableusercontent.com/0f67222e9f8d2b106a9074ba7adb0c1ab2bdb75396bd04aa54430a025d82691f","tier":null}],"members":[{"type":"individual","id":"c8f2489426bdf163","login":"dcao","name":"David Cao","avatar_url":"https://avatars-next.observableusercontent.com/0f67222e9f8d2b106a9074ba7adb0c1ab2bdb75396bd04aa54430a025d82691f","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"The EECS Graduate Funding Handbook","cells":[{"id":14,"value":"# The EECS Graduate Funding Handbook\n\nor: **how much money am I supposed to be making a year?**\n\n${note(md`**Note**! There is a newer version of this document available: https://eecs-funding.cao.sh/.\n\nThis version is left here for archival purposes\n`)}\n\n---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2321,"value":"md`Hey! You there! I got a question for you:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2323,"value":"viewof firstYearIntro = Inputs.checkbox([\"Yes, I am!\"], {label: \"Are you a first year?\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2413,"value":"try_it(md`This document is interactive! You can interact with the checkbox, along with many other interactive controls, in this document!`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2326,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"toc(\"h2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":508,"value":"toc(\"span.date\", md`**In a hurry? Jump to an interactive:**`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2191,"value":"Graduate student funding can be a confusing topic! This document aims to be a one-stop resource for all of your questions surrounding how much we **are** and **should** be getting paid. In particular, this document aims to cover a bunch of different topics, including:\n\n1. **How grad school funding works in general.** Where does our money come from? What's a GSR and a GSI? How do fellowships play into this? What if I'm an international student?\n2. **How EECS grad student pay used to work before the 2022 strikes.** This includes exact dollar amounts and policies around appointments.\n3. **How much we're supposed to be making now.**\n4. **Why we're making less than what we're supposed to be making.** Post-strike, we were supposed to get some pretty big raises! The department doesn't like this, and has been using different tactics to pay us arbitrarily less.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1758,"value":"If you're looking to get a full understanding of how funding works and what changes the department has made over time, we'd recommend reading this document from top-to-bottom. It contains full prose explanations accompanied by interactive charts and visuals.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1760,"value":"If you're looking for quick calculators for how much you should be making, use the table of contents and charts & calculators links at the top of this page to quickly navigate to the relevant calculators!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":96,"value":"This document is also **interactive**! This page has many interactive inputs, figures, graphics, and charts to help make this issue tangible. Use the different inputs and sliders to build a better intuition for how the funding math works! Importantly, since this is an interactive code notebook, you can look at all of the code and data used to produce the numbers, figures, and charts in this document yourself. We want to stay transparent and accountable, and hopefully seeing all of the backend of this document can give you confidence that what you're seeing is the real deal.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2188,"value":"This document draws heavily from a number of different sources, including a variety of different online documents. Where possible, we've linked to sources that we draw on for our data.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1680,"value":"This document borrows extremely heavily from—in prose, calculations, and structure—from the [EECS Wages Spreadsheet](https://docs.google.com/spreadsheets/d/1VELwnXpVpCdVvoE-5puANkEcVu0E_L5QqGD0dkFIYoM/edit#gid=512003886).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3403,"value":"---\n\n## But why speak out? Don't EECS students already have it good?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3406,"value":"I completely agree with you! This is 100% correct.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3409,"value":"Every graduate program has its own unique rules about how graduate students are funded, and in general, EECS students do have a lot of privileges. As students, our funding sources are, for the most part, more stable. Although there are certainly many exceptions, we can make stronger assumptions about if we will be funded (with fee remissions) during the course of our program. And relative to other grad students, we're generally paid at the higher end of the grad student scale.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3421,"value":"But if anything, this is even _more_ of a reason to make information about funding public and advocate for changes! Our working conditions didn't come from nowhere; they were fought and advocated for by countless generations of past grad students, putting their time and effort into making sure that future grad students---us!---would be able to enjoy better conditions and protections as grad students.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3870,"value":"And there's still so much further to go, both for EECS students and for other graduate students. As we'll see in the rest of this guide, EECS students still face a ton of challenges to their quality of living, and the department is _actively trying to make our quality of living worse!_ And this is to say nothing about folks in other departments, where funding can be harder to come by and more limited. We will discuss this further in the conclusion, but in short: talking about our funding situation, and where we're being let down, can help all of us aspire to a world where _all grad students_, in EECS and across the Berkeley campus, are paid fairly for their work.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3737,"value":"In particular, I want to mention a few reasons why we'd want to talk about this:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3410,"value":"#### Funding is incredibly opaque and constantly changing, and info is often passed by word-of-mouth.\n\nFunding can be an incredibly opaque issue, and info about funding is often acquired passed on implicitly, often through word-of-mouth and knowing the right people. This document aspires to provide a comprehensive resource for questions, drawn from the accumulated knowledge of many different graduate folks within EECS. In particular, this page aims to be a **living document**, one which will change and adapt as the funding situation evolves.\n\nAdditionally, for folks outside the EECS department—grad students or curious onlookers—this document hopefully provides a window into the nuts and bolts of how funding within our department works. Hopefully, this document can give a useful insight for what policies you want to push for in your own department, and what things to look out for.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3414,"value":"#### This is an equity issue. This lack of information hurts under-privileged students the most.\n\nFor folks more reliant on graduate funding for basic necessities, and folks who are less familiar with the unspoken norms of (computing) academia, these folks are impacted the most by changes (or as we will see soon, reductions) in funding.\n\nAnd for students in other departments, where funding is harder to come by, lack of access to information about how funding works can be a serious deterrent to wanting to engage with or pursue work in academia.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3417,"value":"#### This issue has history behind it, and all grad students---EECS and other departments included---deserve better.\n\nWe acknowledge that Berkeley EECS grad students are privileged in many ways. The purpose of this document isn't to take these things for granted; instead, this document is an aspirational project to show where the university falls short for all of us grad students, EECS and beyond, and to illustrate what we should expect from the university.\n\nIndeed, many of the privileges we enjoy now are the result of past generations of graduate students working and fighting tirelessly for better working conditions; this document hopefully serves as a reminder and continuation of that tradition.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2120,"value":"We also hope this document can contextualize and historicize how our current pay conditions came to be. The privileges we enjoy today—like tuition/fee remissions—didn't come out of nowhere or because of department benevolence, but because of past generations of graduate students working to guarantee better conditions.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":59,"value":"---\n\n## The funding model & pay pre-2023\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":204,"value":"Broadly speaking, graduate students are funded by a combination of funding from three sources:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":209,"value":"- _Your advisor_. Your advisor has a research budget, drawn from outside grants from the government or other companies. They can use this budget to pay your tuition and stipend (salary).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":217,"value":"- _The university_. When you're employed by the university to teach a course as a TA/GSI, or when the university provides you a fellowship, that money comes out of the university directly.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":221,"value":"- _Other sources_. For outside fellowships (e.g. NSF GRFP), this funding is provided by outside sources. Normally, you have to apply for this funding yourself.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":262,"value":"As an EECS grad student, your tuition and fees are _guaranteed to be covered_ (though the source of your funding depends on specific circumstances, e.g. if you're receiving certain fellowships like the NSF GRFP). As a grad student, you also receive an additional _salary or stipend_ for your work. There are several different ways you can be employed by the university to do your research/teaching work, and the specific title you're given determines where you get your funding from.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":287,"value":"details(md`One difficulty with writing about funding in general is that funding situations can vary pretty drastically. In particular, fellowships have wildly different terms.`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":254,"value":"### GSRs, GSIs, step levels, and appointments","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":256,"value":"The most common situation is to be employed as a **graduate student researcher (GSR)**. In this scenario, you are essentially employed by the university for that semester/period to do research. If you are employed as a GSR, your funding comes out of your advisor's research funds.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":277,"value":"You could also be a **graduate student instructor (GSI)** or **teaching assistant (TA)**, which means that you're employed for a semester to help teach a course. GSI salaries are paid by the university.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":278,"value":"note(md`**Warning!** Berkeley is currently phasing out the term \"GSI\" for \"TA.\" However, as we explain in the section \"Changes in pay to GSIs/TAs,\" these terms aren't _entirely_ synonymous. The formal pay code for TAs actually pays us _lower_ than the pay code for GSIs, and departments across Berkeley are using this as an excuse to pay us less than we're supposed to be paid. See \"Changes in pay to GSIs/TAs\" below for more details on this.`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2213,"value":"details(md`**Sidenote!** You may also hear the acronym **academic student employee (ASE)** mentioned. ASEs include GSRs, GSIs, tutors (normally undergrads who help with classes), and readers (people hired to read/grade assignments).`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":270,"value":"GSRs and GSIs can be funded at different **step levels**, which are standardized graduate student pay amounts set by the University of California for the whole UC system.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2256,"value":"gsrSteps = aq\n .fromCSV(await FileAttachment(\"eecs_steps@4.csv\").text())\n .derive({ Date: aq.escape(d => new Date(d.Date)) })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2206,"value":"We've taken the liberty of compiling historical data on GSR pay, which has been manually compiled from [info on this page regarding GSR salary scales](https://apo.ucsc.edu/compensation/salary-scales/index.html) from the UC Santa Cruz website. Even though the info is from UCSC, the numbers hold across all UCs.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2264,"value":"details(md`Throughout this document, you'll see small code snippets, like the one above, interspersed throughout the document. You can expand them, along with any tables/charts/figures you see, to look at the full source code of how we calculate and build this data!`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":343,"value":"At the end of 2022, a large strike held by graduate workers across the UCs resulted in changes in this funding structure. We will go over this in the next section. In a world where graduate students were paid for full-time work the whole year, this is how much each step level would be making yearly in salary:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":331,"value":"oldGsr = gsrSteps\n .params({ thres: new Date(\"1/1/23\") })\n .filter((d, $) => d.Date < $.thres)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"oldGsr\n .fold(aq.not(\"Date\"))\n .derive({ adjValue: aq.escape(d => {\n return d3.format(\"$,.0f\")(d.value);\n })})\n .groupby(\"Date\")\n .pivot(\"key\", [\"adjValue\"])\n .derive({ Date: aq.escape(d => d3.timeFormat(\"%B %Y\")(d.Date)) })\n .select(\"Date\", \"1\", \"2\", \"3\", \"4\", \"5\", \"6\", \"7\", \"8\", \"9\", \"10\")\n .rename({ Date: \"Date of salary increase\" })\n .view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2427,"value":"However, to be clear: **this is not how much grad students at each step actually make**.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":750,"value":"As a grad student, your job is to do research work during the school year (i.e. fall and spring semesters). You are compensated for this work either through a GSR/GSI appointment, and/or through fellowship payments. However, **students aren't paid for full-time work during the school year**. During fall and spring semesters, you're expected to split your time roughly 50/50 between research work (paid) and being a student (taking classes etc., which is unpaid).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":752,"value":"Thus, during the school year, you're employed at a **part-time (i.e. ~20 hrs / wk) rate**. Additionally, during the summer, you have the **option** of being employed **full-time** by the university to do research work. Historically, the expectation is that if students wanted, they could take a full-time position working for the university, and be paid full-time, at full-time rates.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3172,"value":"Anyways, here are the table amounts again, but showing monthly rates, and accurately reflecting part-time and full-time monthly rates. This is more accurate to what folks across the university are experiencing (but not quite right, as we'll discuss below!)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":433,"value":"Table: what was each step level's listed part-time and full-time monthly rates before 2023? ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3178,"value":"viewof isPartTime = Inputs.radio([\"Part-time (school year)\", \"Full-time (summer)\"], { value: \"Part-time (school year)\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3175,"value":"oldGsr\n .fold(aq.not(\"Date\"))\n .derive({ adjValue: aq.escape(d => {\n return d3.format(\"$,.2f\")(d.value / ((isPartTime.startsWith(\"Part\")) ? 24 : 12));\n })})\n .groupby(\"Date\")\n .pivot(\"key\", [\"adjValue\"])\n .derive({ Date: aq.escape(d => d3.timeFormat(\"%B %Y\")(d.Date)) })\n .select(\"Date\", \"1\", \"2\", \"3\", \"4\", \"5\", \"6\", \"7\", \"8\", \"9\", \"10\")\n .rename({ Date: \"Date of salary increase\" })\n .view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2462,"value":"Note that these amounts also don't include tuition or fee remission. As we mentioned above, the EECS department guarantees tuition and fee remission for all students, and generally speaking across all departments, appointed GSRs and GSIs receive tuition and fee coverage.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":415,"value":"**Appointment levels** are the percent of your time you're expected to do research work during a period, and thus what percent of the full pay amount you will receive. Thus, you would expect that during the school year, you'd be appointed at 50%, and during the summer, you'd be appointed at 100%.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2246,"value":"Notice I said \"full-time\" three times! This is foreshadowing.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":382,"value":"Importantly, each department at each school sets the policy for what step level and appointment level its students should be funded at, and whether this should change based on student seniority.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":299,"value":"So, what step level and appointment levels did EECS students get? **Prior to 2023**, EECS students operated under the following guidance from the department:\n\n- **EECS funded all students at GSR Step 9**.\n- By contract, **departments are not allowed to reduce students' step levels over time, only increase them**.\n- Since GSIs are paid less than GSRs, **the department required faculty to cover the difference between GSI and GSR pay (GSI top-ups)**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":417,"value":"- During the school year, EECS grad students are paid for part-time work (i.e. 20 hrs/week).\n - EECS grad students yet to pass their qualifying exam were appointed at **48%** during the school year. This is a totally arbitrary amount. EECS PhD students were not doing 2% less work than candidates. The department just wanted a way to pay pre-quals students less.\n - EECS PhD candidates (i.e. those who have passed quals) were appointed at **50%** during the school year.\n- All EECS students were appointed **full-time** at 100% during the summer.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":420,"value":"One consequence of the appointment tomfoolery is that more junior EECS students were actually paid ~4% less compared to their more senior counterparts during the school year, since it's 2% out of a 50% correct appointment.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2454,"value":"We can look at how monthly earnings during the summer and school year have changed from 2013 to 2021:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":425,"value":"Table: how much would an EECS grad student actually make monthly during the school year, pre-2023? ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":442,"value":"oldGsrAppt = oldGsr\n .select(\"Date\", \"9\")\n .derive({\n \"Pre-quals\": d => d['9'] * 0.48 / 12,\n \"Post-quals\": d => d['9'] * 0.5 / 12,\n \"Summer\": d => d['9'] / 12,\n })\n .derive({\n \"Lost wages\": d => d[\"Post-quals\"] - d[\"Pre-quals\"]\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":472,"value":"oldGsrAppt\n .fold(aq.not(\"Date\"))\n .derive({\n Date: aq.escape(d => d3.timeFormat(\"%B %Y\")(d.Date)),\n value: aq.escape(d => d3.format(\"$,.2f\")(d.value))\n })\n .groupby(\"Date\")\n .pivot(\"key\", [\"value\"])\n .select(\"Date\", \"Pre-quals\", \"Post-quals\", \"Lost wages\", \"Summer\")\n .rename({ \"Lost wages\": \"Missing wages / mo (if pre-quals)\" })\n .view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":505,"value":"### Calculating pre-2023 salaries","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3215,"value":"Putting this all together, we can look at how much you'd expect to make as an EECS grad student over the course of a school year:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1477,"value":"Calculator: how much were grad students paid pre-2023?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1746,"value":"note(md`**Warning**: This calculator assumes a graduate student is paid at a 50% GSR appointment during the school year, and a 100% GSR appointment during summer. Thus, **this calculator will likely overestimate wages for folks outside of EECS**. The step slider is provided to give a rough estimate for upper bounds on earnings.`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1486,"value":"viewof year = Inputs.bind(Inputs.range([2013, 2021], {value: 2021, step: 1, label: \"Year\"}), viewof newYear)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1373,"value":"viewof preStepLevel = Inputs.range([1, 10], {value: 9, step: 1, label: \"Step level (EECS is Step 9)\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1378,"value":"viewof studentStatus = Inputs.radio([\"First year\", \"Continuing, pre-quals\", \"Continuing, post-quals\"], {label: \"Student status\", value: \"First year\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1399,"value":"trueAppt = (studentStatus.includes(\"post-quals\")) ? 0.5 : 0.48;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1503,"value":"Given the inputs above, this is how much folks in ${year} could expect to make for each month in the school year:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1438,"value":"Inputs.table(\n vals(year, preStepLevel),\n {\n format: {\n value: sparkbar(d3.max(vals(2021, 10, 0.5), d => d.value)),\n date: d => d3.timeFormat(\"%B %Y\")(d),\n },\n header: {\n date: \"Month\",\n value: \"Monthly salary\"\n },\n maxWidth: 400,\n maxHeight: 1000,\n },\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1518,"value":"And this is how much you could expect to make cumulatively over the course of the year. The red line represents pay at the current selected step level. For reference, we've also provided what pay amounts would look like if we were paid at other step levels, but with the same appointment level. If you hover over the chart, you can see cumulative values for each month for the current selected step level.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1647,"value":"

${d3.format(\"$,.2f\")(cumulPay(vals(year, preStepLevel)))}

Cumulative yearly salary

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1386,"value":"Plot.plot({\n subtitle: `Cumulative pay for ${year}-${year + 1}`,\n marginLeft: 56,\n y: {\n grid: true,\n label: \"Pay amount ($)\",\n domain: [0, d3.cumsum(vals(2021, 10, 0.5), d => d.value).slice(-1)[0]],\n },\n marks: stepMarks(year).concat([\n Plot.lineY(\n vals(year, preStepLevel),\n Plot.mapY('cumsum', {x: \"date\", y: \"value\", stroke: \"red\", tip: true})\n )\n ]),\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1539,"value":"We can also calculate your _effective hourly wage_: how much you'd make hourly if you were working a regular job (i.e. 40 hours a week) and made ${$fmt(cumulPay(vals(year, preStepLevel)))} in yearly salary.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1541,"value":"

${$fmt(cumulPay(vals(year, preStepLevel)) / networkdays(moment(schoolYear[year].start), moment(schoolYear[year + 1].start).subtract(1, 'days')) / 8)} / hr

Effective hourly across the full year

${$fmt(cumulPay(monthlyPay(gsrSteps, [{ appointment: trueAppt, step: preStepLevel, ...schoolYear[year] }])) / networkdays(moment(schoolYear[year].start), moment(schoolYear[year].end)) / 8)} / hr

Effective hourly wage during school year

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1620,"value":"For reference, Berkeley's minimum wage in 2021 was **$16.32**. Note that folks being paid at lower step levels would earn **less than minimum wage** during the year. And this is an optimistic calculation for them too! Folks in other departments aren't always given GSR appointments & don't always receive higher appointment levels.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":200,"value":"### Fellowships","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":513,"value":"Fellowships are a particularly complicated case, since every fellowship is slightly different and different fellowships can interact with each other in a bunch of different ways. We try to discuss _in general_ how fellowships work, along with some more common specific examples.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":516,"value":"_In general_, if you are paid by fellowship, this means you are funded by an outside source, either the university or somebody else. For the most part, this means instead of being paid in salary (i.e. monthly), you'll receive large lump sum stipends (normally at the start of each semester).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2142,"value":"Fellowships tend to be prestigious things that look good for individuals and the university. Thus, to encourage students to pursue fellowships, the EECS department had a _written policy_ of ensuring that **students on fellowships are paid ~10% more than students without**.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":403,"value":"### Taxes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":790,"value":"The above wages are **pre-tax**; they don't include taxes taken away from your paycheck. Part of your paycheck is withheld from you to pay income tax and social security. Additionally, during tax season, you will have to pay part of your pay in federal and state taxes.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":422,"value":"Taxes are complicated as hell and we can't afford to explain them all here, so we're presenting pre-tax figures. As a rule of thumb, you can expect 10-20% of your paycheck to go towards paying taxes.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2220,"value":"details(md`_Don't quote us on those numbers_. This is not legal tax advice, etc.`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"### We've gotten raises, but they haven't kept up with inflation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1801,"value":"One other piece of information of note is that, as you can see from before, there has been a steady increase in wages from 2013 to 2021. For the most part, this results in ~3% yearly wage increases, as we can see if we do some math:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":577,"value":"oldGsr\n .fold(aq.range(1, 10))\n .groupby(\"key\")\n .derive({ value: d => d.value / op.lag(d.value, 1, 0) - 1 })\n .derive({ Date: aq.escape(d => d3.timeFormat(\"%B %Y\")(d.Date)), value: aq.escape(d => d3.format(\".2%\")(d.value)) })\n .groupby(\"Date\")\n .pivot(\"key\", [\"value\"])\n .slice(1)\n .view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1822,"value":"Before fairly recently (circa 2020), GSRs were not part of any union or bargaining unit. Other ASEs, including GSIs and other research employees, had to engage in [organizing in the early 2010s](https://livinghistory.as.ucsb.edu/tag/uaw-local-2865/) in order to get these same gains for themselves.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":584,"value":"This might seem nice, but in practice we have _inflation_ to contend with; prices increase over time! The Bureau of Labor Statistics (BLS) publishes [public information](https://www.bls.gov/cpi/data.htm) on inflation, so let's chart our wage increases compared to inflation over time. Here's some inflation data provided by the BLS for the San Francisco Bay Area region, both for overall inflation and for individual subcomponents (e.g. rent inflation):","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":979,"value":"viewof inflationType = Inputs.select([\"Overall\", \"Rent\", \"Food\"], { label: \"Inflation dataset\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":604,"value":"viewof cpiInc = {\n let files = {\n \"Overall\": await FileAttachment(\"overall_inflation_2023_12.csv\").text(),\n \"Rent\": await FileAttachment('rent-inflation-sf.csv').text(),\n \"Food\": await FileAttachment('food-inflation-sf.csv').text(),\n };\n \n let cpi = aq // viewof shows the table view, but assigns the table value\n .fromCSV(files[inflationType]);\n\n return cpi\n .fold(aq.not('Year'), { as: ['Month', 'cpi'] })\n .filter(x => x['cpi'])\n .derive({\n date: aq.escape(d => d3.timeParse(\"%b %Y\")(d.Month + \" \" + d.Year))\n })\n .filter(aq.escape(x => x.date > oldGsrAppt.object(0).Date))\n // .filter(aq.escape(x => x.date < oldGsrAppt.object(oldGsrAppt.numRows() - 1).Date))\n .derive({ cpiCumul: aq.rolling(d => d.cpi / op.first_value(d.cpi)) })\n .select(\"date\", \"cpi\", \"cpiCumul\")\n .view(100000)\n};","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1050,"value":"details(md`The numbers in the table represent **CPI**, which is an index proportional to the price of goods during that time. We've also calculated a new field, \\`cpiCumul\\`, which represents cumulative increase in CPI value since ${d3.timeFormat(\"%B %Y\")(cpiInc.object(0).date)}.`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":929,"value":"To compare inflation rates with pre-2023 wages, we will project this 3% yearly increase forwards to the present day:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":990,"value":"Calculator: how did pay raises compare to inflation pre-2023? ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1525,"value":"Inputs.bind(Inputs.select([\"Overall\", \"Rent\", \"Food\"], { label: \"Inflation dataset\" }), viewof inflationType)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":632,"value":"{\n return Plot.plot({\n subtitle: `Cumulative increase of wages and ${inflationType.toLowerCase()} inflation`,\n y: {\n grid: true,\n label: \"Change in price (%)\",\n tickFormat: ((f) => (x) => f((x - 1) * 100))(d3.format(\"+d\"))\n },\n marks: [\n Plot.lineY(cpiInc, {x: \"date\", y: \"cpiCumul\", stroke: \"red\"}),\n Plot.lineY(oldGsrInc, {x: \"Date\", y: \"cumul\", stroke: \"gray\", curve: \"step-after\", filter: d => d.Date <= new Date(\"10/1/21\")}),\n Plot.lineY(oldGsrInc, {x: \"Date\", y: \"cumul\", stroke: \"gray\", curve: \"step-after\", filter: d => d.Date >= new Date(\"10/1/21\"), strokeDasharray: [3]}),\n Plot.dotY(oldGsrInc, {x: \"Date\", y: \"cumul\"}),\n ]\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":875,"value":"Plot.plot({\n subtitle: `Wage increases, accounting for ${inflationType.toLowerCase()} inflation`,\n y: {\n grid: true,\n label: \"Increase (%)\",\n tickFormat: ((f) => (x) => f(x * 100))(d3.format(\"+d\"))\n },\n marks: [\n Plot.lineY(cpiIncComp, {x: \"date\", y: \"comp\", filter: d => d.date <= new Date(\"10/1/21\")}),\n Plot.lineY(cpiIncComp, {x: \"date\", y: \"comp\", filter: d => d.date >= new Date(\"10/1/21\"), strokeDasharray: [5]}),\n Plot.areaY(cpiIncComp, {x: \"date\", y: \"comp\", fillOpacity: 0.3})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":711,"value":"oldGsrInc = {\n let last = oldGsrAppt.object(oldGsrAppt.numRows() - 1)[\"9\"];\n \n return oldGsrAppt\n .insert(aq.table({\n Date: [new Date(\"10/1/22\"), new Date(\"10/1/23\")],\n \"9\": [last * 1.03, last * 1.03 * 1.03]\n }))\n .derive({ cumul: aq.rolling(d => d['9'] / op.first_value(d['9'])) })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":853,"value":"cpiIncComp = cpiInc\n .derive({\n comp: aq.escape(d => {\n let tgt = oldGsrInc\n .filter(aq.escape(x => x.Date <= d.date))\n .orderby(aq.desc(\"Date\"))\n .object(0)\n .cumul;\n\n return tgt - d.cpiCumul;\n }\n )})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":561,"value":"As we can see, when taking into account inflation, **wages have not measurably increased since 2013**. Furthermore, **our effective wages would have fallen during the pandemic** given these projected wage increases.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1012,"value":"This is exacerbated by increases in renting costs over the past decade (change the selection above to see this for yourself!). **Rent prices in the SF Bay Area have increased by ~50%, compared to a projected 36% for wages.**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2818,"value":"Here's another way of visualizing this information. Let's look at how much a student would stand to make for each academic year that they are a student, adjusted for inflation.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3366,"value":"Inputs.bind(Inputs.select([\"Overall\", \"Rent\", \"Food\"], { label: \"Inflation dataset\" }), viewof inflationType)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3043,"value":"inflationGraph2(2021)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3046,"value":"Yearly salaries have stayed **virtually stagnant** since 2013.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":61,"value":"---\n\n## Pay, 2023 and after (in theory)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":140,"value":"note(md`**Summary**: As grad students, we should be appointed at **Step 6** and making around **${d3.format(\"$,.2f\")(d3.cumsum(vals(2023, 9, 0.5), d => d.value).slice(-1)[0])} yearly**. This comes from 50% appointments during the school year, and 100% appointments during summer.`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2460,"value":"As you may be able to tell from the charts above, the conditions EECS graduate students were facing before 2023 were becoming increasingly less tenable. This is to say nothing of the struggles graduate students in other departments face; many of whom are given lower step-level GSR or GSI positions, if they're guaranteed appointments at all.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":803,"value":"Because of these conditions, at the end of 2022, graduate student workers across the UC system all simultaneously went on strike, in what became the _largest grad student strike in history_. Basically, graduate students across the UCs all decided to stop working to force the university to negotiate with us for better pay. In particular, _this was the first time graduate student researchers (GSRs) were part of union organizing activity._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3726,"value":"Because of this historic act of graduate student labor solidarity, we were able to get the university to negotiate with us for some pretty substantial changes in how all grad students at the university are paid. Turns out, when you stop working? the university pays attention :^)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1056,"value":"The result of this effort was a **new contract** that specifies new conditions of work for graduate students. There were a _ton_ of wins for grad students, including better recourse for cases of harassment, as well as wins in health and childcare coverage. Of interest for us are three changes.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":805,"value":"First: **step levels changed to promote more equitable pay**. Graduate students at the lower steps were criminally underpaid, as we discussed above. In response to this, the new contract reduces the number of steps from ten to six. **The old step 4 is now the new lowest step level, step 1**, and **steps 9-10 became the new step 6**. For EECS students, this means that **old Step 9 is equivalent to new Step 6**.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1071,"value":"| Old step level (before 2023) | New step level (after 2023) |\n| ---------------------------- | --------------------------- |\n| Step 1 | Step 1 |\n| Step 2 | Step 1 |\n| Step 3 | Step 1 |\n| Step 4 | Step 1 |\n| Step 5 | Step 2 |\n| Step 6 | Step 3 |\n| Step 7 | Step 4 |\n| Step 8 | Step 5 |\n| **Step 9** | **Step 6** |\n| Step 10 | Step 6 |","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1080,"value":"Second, **we got big raises**. For us in step 9, we received 11% in April 2023, then ~6.4% in both October 2023 and 2024. Folks in lower step levels, because of the changes in the step system, got even bigger gains: nearing 40% in April 2023! Here's the table from before with the old step levels:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1830,"value":"gsrSteps\n .fold(aq.range(1, 10))\n .groupby(\"key\")\n .derive({ value: d => d.value / op.lag(d.value, 1, 0) - 1 })\n .derive({ Date: aq.escape(d => d3.timeFormat(\"%B %Y\")(d.Date)), value: aq.escape(d => d3.format(\".2%\")(d.value)) })\n .groupby(\"Date\")\n .pivot(\"key\", [\"value\"])\n .slice(1)\n .view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2492,"value":"note(md`**Note!** In the new agreed-to contract, the university was required to provide 6.4% raises during 2023 and 2024. Note that in 2024, they actually didn't give us 6.4% though; they gave us 6.37%, which technically rounds to 6.4%. Sneaky business...`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1844,"value":"And as a result of these gains, we've received **true gains in wages relative to inflation**! Here is how our wages over time compare with inflation since 2013:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2503,"value":"Calculator: how much have wages increased under the new contract?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1872,"value":"Inputs.bind(Inputs.select([\"Overall\", \"Rent\", \"Food\"], { label: \"Inflation dataset\" }), viewof inflationType)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3072,"value":"We've also added an extra control here: _projected yearly inflation_. You can adjust what you think yearly inflation will look like, and see how that will affect our future wage gains.. For reference, the historical average is about 3% yearly.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3059,"value":"viewof projectedInflation = Inputs.range([0, 0.07], {value: 0.03, label: \"Projected yearly inflation (%)\", format: x => (x * 100).toFixed(2)})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1850,"value":"Plot.plot({\n subtitle: `Cumulative increase of wages and ${inflationType.toLowerCase()} inflation`,\n y: {\n grid: true,\n label: \"Change in prices/salary (%)\",\n tickFormat: ((f) => (x) => f((x - 1) * 100))(d3.format(\"+d\"))\n },\n marks: [\n Plot.lineY(cpiProj, {x: \"date\", y: \"cpiCumul\", stroke: \"red\", filter: d => d.date <= cpiInc.object(cpiInc.numRows() - 1).date }),\n Plot.lineY(cpiProj, {x: \"date\", y: \"cpiCumul\", stroke: \"red\", filter: d => d.date >= cpiInc.object(cpiInc.numRows() - 1).date , strokeDasharray: [4]}),\n Plot.lineY(gsrInc, {x: \"Date\", y: \"cumul\", stroke: \"gray\", curve: \"step-after\"}),\n Plot.dotY(gsrInc, {x: \"Date\", y: \"cumul\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1858,"value":"Plot.plot({\n subtitle: `Wage increases, accounting for ${inflationType.toLowerCase()} inflation`,\n y: {\n grid: true,\n label: \"Salary increase (%)\",\n tickFormat: ((f) => (x) => f(x))(d3.format(\"+d\"))\n },\n color: {scheme: \"BuRd\"},\n marks: [\n Plot.lineY(newCpiComp, {x: \"date\", y: \"comp\", tip: true, filter: d => d.date <= cpiInc.object(cpiInc.numRows() - 1).date}),\n Plot.lineY(newCpiComp, {x: \"date\", y: \"comp\", tip: true, filter: d => d.date >= cpiInc.object(cpiInc.numRows() - 1).date, strokeDasharray: [4]}),\n Plot.areaY(newCpiComp, {x: \"date\", y: \"comp\", fillOpacity: 0.3})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1846,"value":"gsrInc = {\n return gsrSteps\n .derive({ cumul: aq.rolling(d => d['9'] / op.first_value(d['9'])) })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3076,"value":"cpiProj = {\n let cpiCur = cpiInc\n let tgtDate = moment(schoolYear[2024].end)\n let ogCpi = cpiInc.object(0).cpi\n\n while (true) {\n let prev = cpiCur.object(cpiCur.numRows() - 1)\n let newMon = moment(prev.date).add(1, 'months')\n\n if (newMon.isAfter(tgtDate)) {\n break;\n }\n \n let newCpi = prev.cpi * Math.pow(1 + projectedInflation, 1/12)\n\n cpiCur = cpiCur.insert(aq.table({\n date: [newMon.toDate()],\n cpi: [newCpi],\n cpiCumul: [newCpi / ogCpi],\n }))\n }\n\n return cpiCur\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1860,"value":"newCpiComp = cpiProj\n .derive({\n comp: aq.escape(d => {\n let tgt = gsrInc\n .filter(aq.escape(x => x.Date <= d.date))\n .orderby(aq.desc(\"Date\"))\n .object(0)\n .cumul;\n\n return (tgt - d.cpiCumul) * 100;\n }\n )})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1875,"value":"Compared to overall inflation since 2013, we've had a 5% increase in purchasing power. For continuing students, this reprieve unfortunately came at the cost of having to bear huge effective wage losses during the strikes (which was the choice of the department to not provide any raises during this period!)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3142,"value":"Inputs.form([\n Inputs.bind(Inputs.select([\"Overall\", \"Rent\", \"Food\"], { label: \"Inflation dataset\" }), viewof inflationType),\n Inputs.bind(Inputs.range([0, 0.07], {value: 0.03, label: \"Projected yearly inflation (%)\", format: x => (x * 100).toFixed(2)}), viewof projectedInflation)\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3056,"value":"inflationGraph2(2024)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3146,"value":"Regardless, the gains in 2023 and beyond are clear. Assuming a ${d3.format(\".2%\")(projectedInflation)} yearly inflation rate, in 2023 we would stand to make ~$6,000 more compared to previous years when looking at overall inflation.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":828,"value":"Third, **no more 48% appointments**. By contract, the department is now required to pay us at appointment %s commensurate with the work we're doing. In other words: _Full-time grad students should be paid 100%, and part-time grad students should be paid 50%_. In theory, this should prevent the department from appointing junior graduate students at 48% and paying us less than other grad students.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1615,"value":"And here is the new chart for pay:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1752,"value":"Calculator: how much should grad students be paid under the new contract?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1749,"value":"details(md`Assumptions: no fellowships, GSR pay scale, 50% school year appointment, 100% summer appointment`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1701,"value":"viewof newYear = Inputs.range([2013, 2024], {value: 2023, step: 1, label: \"Year\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1689,"value":"Inputs.form([\n Inputs.bind(Inputs.range([1, 10], {value: 9, step: 1, label: \"Old step level\"}), viewof preStepLevel),\n Inputs.bind(Inputs.range([4, 9], {value: 9, step: 1, label: \"New step level\", format: d => d - 3}), viewof preStepLevel)\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1721,"value":"Inputs.table(\n vals(newYear, preStepLevel, 0.5),\n {\n format: {\n value: sparkbar(d3.max(vals(2024, 10, 0.5), d => d.value)),\n date: d => d3.timeFormat(\"%B %Y\")(d),\n },\n header: {\n date: \"Month\",\n value: \"Earnings\",\n },\n maxWidth: 400,\n maxHeight: 1000,\n },\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1733,"value":"Plot.plot({\n subtitle: `Cumulative pay for ${newYear}-${newYear + 1}`,\n marginLeft: 56,\n y: {\n grid: true,\n label: \"Pay amount ($)\",\n domain: [0, d3.cumsum(vals(2024, 10, 0.5), d => d.value).slice(-1)[0]],\n },\n marks: stepMarks(newYear).concat([\n Plot.lineY(\n vals(newYear, preStepLevel, 0.5),\n Plot.mapY('cumsum', {x: \"date\", y: \"value\", stroke: \"red\", tip: true})\n )\n ]),\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3266,"value":"

${$fmt(cumulPay(vals(newYear, preStepLevel)))}

Yearly salary

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1742,"value":"

${$fmt(cumulPay(vals(newYear, preStepLevel)) / networkdays(moment(schoolYear[newYear].start), moment(schoolYear[newYear + 1].start).subtract(1, 'days')) / 8)} / hr

Effective hourly across the full year

${$fmt(cumulPay(monthlyPay(gsrSteps, [{ appointment: 0.5, step: preStepLevel, ...schoolYear[newYear] }])) / networkdays(moment(schoolYear[newYear].start), moment(schoolYear[newYear].end)) / 8)} / hr

Effective hourly during school year

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2147,"value":"For reference, Berkeley's minimum wage in 2023 was **$18.38**.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2710,"value":"Note that many of the wage increases don't really reflect in yearly salaries until 2023, since the wage increases happen so late into the 2022-23 school year.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1756,"value":"This is how much you _should_ be making. However...","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":64,"value":"---\n\n## How the department has responded (i.e. what you'll _actually_ make)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1783,"value":"In response to these wage increases, the department (i.e. a majority of EECS faculty) have voted on several policies to **reduce graduate student pay going forwards.**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1879,"value":"These steps amount to an effort to _erase the pay gains graduate students won during the most recent strike._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3594,"value":"missingTable = (v) => {\n let ideal = vals(2023, 9, 0.5, 1.0);\n \n return Inputs.table(\n v.map((m, i) => { return { lost: ideal[i].value - m.value, ...m } }),\n {\n columns: [\n \"date\", \"value\", \"lost\"\n ],\n format: {\n value: sparkbar(d3.max(vals(2024, 10, 0.5), d => d.value)),\n lost: sparkbar(d3.max(vals(2024, 10, 0.5), d => d.value)),\n date: d => d3.timeFormat(\"%B %Y\")(d),\n },\n header: {\n date: \"Month\",\n value: \"Earnings\",\n lost: \"Missing\",\n },\n maxWidth: 400,\n maxHeight: 1000,\n },\n )\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3599,"value":"missingChart = (v, title) => {\n return Plot.plot({\n subtitle: title,\n marginLeft: 56,\n y: {\n grid: true,\n label: \"Pay amount ($)\",\n domain: [0, d3.cumsum(vals(2024, 10, 0.5), d => d.value).slice(-1)[0]],\n },\n marks: [\n Plot.lineY(\n v,\n Plot.mapY('cumsum', {x: \"date\", y: \"value\", stroke: \"red\"})\n ),\n Plot.lineY(\n vals(2023, 9, 0.5, 1.0),\n Plot.mapY('cumsum', {x: \"date\", y: \"value\", stroke: \"black\", strokeDasharray: [5], tip: true})\n ),\n Plot.areaY(\n v,\n Plot.mapY('cumsum', {x: \"date\", y: \"value\", fillOpacity: 0.1, fill: \"red\", strokeDasharray: [5], tip: true})\n ),\n ],\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3605,"value":"missingText = (v) => md`\n

${$fmt(cumulPay(v))}

Yearly salary

${d3.format(\"$,.2f\")(d3.cumsum(vals(2023, 9, 0.5, 1.0), d => d.value).slice(-1)[0] - d3.cumsum(v, d => d.value).slice(-1)[0])}

Missing wages in 2023-24

${$fmt(cumulPay(v) / networkdays(moment(schoolYear[2023].start), moment(schoolYear[2023 + 1].start).subtract(1, 'days')) / 8)} / hr

Effective hourly across the full year

\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"### Underpaying all students","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":198,"value":"#### Underpaying for summer appointments","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2066,"value":"As we noted above, the department previously advised its faculty members to fund students full-time appointment during the summer. Since the beginning of the new contract, the department _has withdrawn this advisory_, with faculty members free to choose whatever summer appointment they wish for their students.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2069,"value":"Note that we also noted above that _by contract, grad students must be appointed at a percent commensurate with their expected work_. Since students are employed full time over the summer, this means that even though students _should_ be appointed at 100%, they might be appointed less for no clear reason.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2071,"value":"Some faculty members have already decided to take advantage of this ambiguity to pay their students less. See the [Survey Wages sheet of the EECS Wages spreadsheet](https://docs.google.com/spreadsheets/d/1VELwnXpVpCdVvoE-5puANkEcVu0E_L5QqGD0dkFIYoM/edit#gid=2030995179) to see how much your faculty advisor pays their students during the summer, and use the slider below to see how much in wages this difference causes:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":102,"value":"viewof summerApptLevel = Inputs.range([20, 100], {label: \"summer appt. %\", step: 2.5, value: 92.5})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2597,"value":"missingTable(vals(2023, 9, 0.5, summerApptLevel / 100))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1892,"value":"missingChart(vals(2023, 9, 0.5, summerApptLevel / 100), `Lost pay for 2023-24 for current students by summer appointment %`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1903,"value":"missingText(vals(2023, 9, 0.5, summerApptLevel / 100))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2082,"value":"The dotted line denotes ideal wage earnings, while the red area represents true earnings.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":196,"value":"#### Changes in pay to GSIs/TAs","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3397,"value":"As a result of changes in pay to TAs, folks who are TA-ing will be paid less than they made previously. This is on account of two changes.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3457,"value":"First, as we mentioned above, the department used to cover the difference between GSI and GSR step levels during semesters when a student teaches, since GSI step level pay amounts are lower than GSR amounts. Now, the department has removed this advice, meaning that during semesters that you are teaching, **the department will no longer cover the difference between TA and GSR pay**.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3460,"value":"Second, UC Berkeley as a whole has decided to change the job title that TAs are appointed as. While the earnings under the new job title do constitute a wage over previous TA wages, the raises are **less** than if TAs had retained their previous job title. [This Google Doc](https://docs.google.com/document/d/19U8uS3Zp9jz1hpjaIhxtKJ5WJC8AcvhgXb1iUbAeUBU/edit) has more info about this.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3513,"value":"Here are the yearly amounts for 100% TA appointments that we'll be using, taken from [Berkeley's HR website](https://hr.berkeley.edu/labor/contracts/BX/current-rates) and [this table](https://docs.google.com/spreadsheets/d/12OzrSUxEuHsi8DPurq7HywIqefiJ51cwm1jmQUiO0cw/edit#gid=901793577) provided by UAW organizers.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3774,"value":"viewof ta2023new = aq.table({\n Date: [new Date(schoolYear[2023].start), new Date(\"10/1/23\"), new Date(\"10/1/24\")],\n 1: [34909.55 * 2, 41700 * 2, 48668 * 2],\n 2: [35588.23 * 2, 42951 * 2, 50128 * 2],\n 3: [36396.63 * 2, 44240 * 2, 51633 * 2],\n}).select(\"Date\", \"1\", \"2\", \"3\").view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3814,"value":"Because we're now dealing with multiple step-level charts, we now have to do a lot more math to figure everything out:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3747,"value":"ta2023 = gsrSteps\n .filter(aq.escape(d => d.Date < new Date(\"10/1/23\")))\n .insert(ta2023new)\n .derive({\n 1: aq.escape(d => d.Date < new Date(\"2023-08-01\") ? d['9'] : d['1']),\n 2: aq.escape(d => d.Date < new Date(\"2023-08-01\") ? d['9'] : d['2']),\n 3: aq.escape(d => d.Date < new Date(\"2023-08-01\") ? d['9'] : d['3']),\n })\n .select(\"Date\", \"1\", \"2\", \"3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3531,"value":"taCurAdj = [\n { appointment: fallTA[1] / 100, step: getTAStep(fallTA[0]), start: \"8/16/23\", end: \"1/8/24\", ta: fallTA[0] != \"No\" },\n { appointment: springTA[1] / 100, step: getTAStep(springTA[0]), start: \"1/9/24\", end: \"5/10/24\", ta: springTA[0] != \"No\" },\n { appointment: summerTA[1] / 100, step: getTAStep(summerTA[0]), ...summers(2023), ta: summerTA[0] != \"No\" },\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3547,"value":"taSel = (sem, def = 50) => Inputs.form([\n Inputs.radio([`No`, `0-1 sem.`, `2-3 sem.`, `>3 sem.`], {label: `TA ${sem} semester?`, value: `No`}),\n Inputs.range([0, def], {label: `${sem} appt. %`, step: 2.5, value: def})\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3806,"value":"getTAStep = (sel, def = 9) => {\n if (sel == \"No\") return def;\n if (sel == \"0-1 sem.\") return 1;\n if (sel == \"2-3 sem.\") return 2;\n return 3;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3590,"value":"taVals = monthlyPay(gsrSteps, taCurAdj)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3570,"value":"Buckle up: we have a lot more sliders we have to deal with now! In particular, for each semester, if you are TAing, you must select your prior experience level, i.e., how many semesters have you TA'ed before? More experienced TAs earn more on the step scale.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3907,"value":"Calculator: how much in earnings are continuing students missing for 2023?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3559,"value":"viewof fallTA = taSel(\"fall\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3562,"value":"viewof springTA = taSel(\"spring\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3567,"value":"viewof summerTA = taSel(\"summer\", 100)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3631,"value":"missingTable(taVals)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3634,"value":"missingChart(taVals, \"Lost pay for 2023-24 for current students by appointment %, TAship\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3651,"value":"missingText(taVals)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":72,"value":"### Underpaying first years","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1131,"value":"Recall that we said earlier that **the department cannot reduce the step level of current students**. Unfortunately, the department is attempting to find a workaround to this: only underpaying new students.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1789,"value":"During the summer, UC Berkeley's Labor Relations department informed the EECS department, along with other departments on campus, that they could start new students at a lower step level. Because of this, a majority of EECS faculty voted to *start new (≥ 2023 cohort) graduate students at Step 4, with a promotion to Step 5 after qualifying exams*. This means that **all new students are paid two step levels lower than existing students**. Additionally, even after quals, we will still be paid less than existing students.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3668,"value":"newCurAdj = [\n { appointment: fallTA[1] / 100, step: getTAStep(fallTA[0], 7), start: \"8/16/23\", end: \"1/8/24\", ta: fallTA[0] != \"No\" },\n { appointment: springTA[1] / 100, step: getTAStep(springTA[0], 7), start: \"1/9/24\", end: \"5/10/24\", ta: springTA[0] != \"No\" },\n { appointment: summerTA[1] / 100, step: getTAStep(summerTA[0], 7), ...summers(2023), ta: summerTA[0] != \"No\" },\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3671,"value":"newVals = monthlyPay(gsrSteps, newCurAdj)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2616,"value":"Calculator: how much in earnings are new students missing for 2023?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3658,"value":"Inputs.bind(taSel(\"fall\"), viewof fallTA)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3661,"value":"Inputs.bind(taSel(\"spring\"), viewof springTA)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3663,"value":"Inputs.bind(taSel(\"summer\", 100), viewof summerTA)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2608,"value":"missingTable(newVals)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1945,"value":"missingChart(newVals, \"Lost pay in 2023-24 for new students\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1954,"value":"missingText(newVals)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3296,"value":"### Aside: how did the department get to $34,000 for first years?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3278,"value":"Now, if you're a first year, you might be wondering what kind of math the department used to come with the $34,000 number referenced in that infamous email. In short, the department is guaranteeing us a \"20% appointment\" during the summer. During the course of the actual school year, we actually stand to make **${$fmt(cumulPay(monthlyPay(gsrSteps, [{ ...schoolYear[2023], step: 7, appointment: 0.5 }])))}**. During the summer, this 20% appointment is worth ${$fmt(cumulPay(monthlyPay(gsrSteps, [{ ...summers(2023), step: 7, appointment: 0.2 }])))}, resulting in a total earnings of ~${$fmt(cumulPay(monthlyPay(gsrSteps, [{ ...schoolYear[2023], step: 7, appointment: 0.5 }, { ...summers(2023), step: 7, appointment: 0.20}])))}.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3302,"value":"If you want proof of this, look at [slide 3 of the funding presentation from orientation](https://www2.eecs.berkeley.edu/Protected/Grads/Newgrad-handouts/2023/EECS-Funding.pdf).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3290,"value":"I hope you can see why this doesn't make any sense. If you're working for the university over the summer, you will be doing full-time work, since you don't have classes or anything to worry about. In essence, if full-time work is 40 hours a week, the department is guaranteeing they'll pay you for 8 hours a week of work.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1981,"value":"This is why we were told \"at least $34,000.\" For one, the department was busy coming up with proposals to pay us less. For another, they didn't want us to know the exact amount less we were being paid. The department did this to convince us that they were matching other schools' pay offers, even if this wasn't the case in reality.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2621,"value":"### The upshot: you are missing your effective wage gains","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1983,"value":"Taking these pay reductions into account, this **erases our wage gains from the 2022-23 strikes.** Here's a chart showing expected yearly salaries for a grad student entering in a particular academic year:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1988,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2706,"value":"Calculator: what do grad students' starting yearly salaries look like over time?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3820,"value":"Inputs.bind(taSel(\"fall\"), viewof fallTA)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3817,"value":"Inputs.bind(taSel(\"spring\"), viewof springTA)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3823,"value":"Inputs.bind(taSel(\"summer\", 100), viewof summerTA)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2631,"value":"Plot.plot({\n subtitle: `Expected starting yearly salary, 2013-2024`,\n marginLeft: 56,\n color: { legend: true, label: \"Scenario\" },\n y: {\n grid: true,\n label: \"Yearly pay amount ($)\",\n },\n marks: [\n Plot.lineY(\n raises,\n {x: \"date\", y: \"value\", stroke: \"typ\", tip: true}\n ),\n ],\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3307,"value":"These charts get even more depressing if we compare against inflation again.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2168,"value":"Inputs.form([\n Inputs.bind(Inputs.select([\"Overall\", \"Rent\", \"Food\"], { label: \"Inflation dataset\" }), viewof inflationType),\n Inputs.bind(Inputs.range([0, 0.07], {value: 0.03, label: \"Projected yearly inflation (%)\", format: x => (x * 100).toFixed(2)}), viewof projectedInflation),\n Inputs.bind(Inputs.radio([\"First year\", \"Continuing, pre-quals\", \"Continuing, post-quals\"], {label: \"Student status\", value: \"First year\"}), viewof studentStatus)\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3316,"value":"inflationGraph2(2024, [], studentStatus, summerTA[1] / 100)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"---\n\n## What can we do about this?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":81,"value":"As we've alluded to briefly throughout this document, this problem isn't isolated to the EECS department. Many different departments across Berkeley (e.g. Physics) have been facing similar issues with their departments trying to bend the rules over how much students should be paid.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2719,"value":"Additionally, this is to say nothing of graduate students in other departments who don't receive the same guaranteed step level appointments that students in EECS receive. Some students _have_ to TA in order to receive fee remission and pay. And many students are paid at the lower step levels. I would encourage you to go back up to the earlier interactives and examine pay for folks at the lower step levels. _Does this seem like fair compensation for their labor to you?_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2723,"value":"The hope is that this document makes you somewhat angry about all this, but also that this document gives you _hope_ that a better future is possible. As we've mentioned before, students have previously gotten together to rally around improving working conditions, to great effect. The wage gains we've won recently wouldn't have happened if grad students hadn't gone out to demand what they deserve! And when that does happen, change follows!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2728,"value":"So what can you do?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2730,"value":"### Talk to your colleagues about pay","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2732,"value":"Particularly in the U.S., there's a taboo about speaking openly about how much you're making. Financial information is treated as a secret that shouldn't be discussed openly. But in reality, this lack of transparency serves nobody but the people trying to pay you less!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2736,"value":"Of course, you're the expert on how hostile or friendly your immediate workspace—your office, your lab, and your department adminstration—is regarding discussions of pay. And this is in no way meant to invalidate concerns of retaliation or reprisal; your safety, security, and stability come first. But if you can and are comfortable, talk to your other folks about what y'all are getting paid! You could even send them this document 🙆‍♀️","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2744,"value":"Knowledge is power, and having people know what's going on is the first step to broader action.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2746,"value":"### Consider joining the union","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2748,"value":"In the past, as we've alluded to in the document, the _union_ has been instrumental in fighting for the gains we currently have. A union is an organized collective of workers (in this case, grad students) empowered to bargain and negotiate with the university for better working conditions. On occasion, unions can call for _strikes_, asking its members to stop working to force the other party (in this case, the university) to agree to better working conditions for its employees.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2754,"value":"In the present, UAW 2865 (the UC grad students' union) was the organization who won us our wage increases in 2023, and they are currently in arbitrartion with the university over the above departmental issues over pay we've mentioned. Becoming a union member can be a great way to increase the bargaining power of graduate students overall (particularly in EECS).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":135,"value":"---\n\n## Appendix: formulas and such","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2129,"value":"### Convenience functions for calculating pay amounts","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2445,"value":"networkdays\t= function(startDate,endDate){ \n\tvar startDate\t= startDate.toDate();\n\tvar endDate\t= endDate.toDate();\n\tif (endDate > startDate){\n\t\tvar days \t= Math.ceil((endDate.setHours(23,59,59,999) - startDate.setHours(0,0,0,1)) / (86400 * 1000));\n\t\tvar weeks \t= Math.floor(Math.ceil((endDate.setHours(23,59,59,999) - startDate.setHours(0,0,0,1)) / (86400 * 1000)) / 7);\n\n\t\tdays = days - (weeks * 2);\n\t\tdays = startDate.getDay() - endDate.getDay() > 1 ? days - 2 : days;\n\t\tdays = startDate.getDay() == 0 && endDate.getDay() != 6 ? days - 1 : days;\n\t\tdays = endDate.getDay() == 6 && startDate.getDay() != 0 ? days - 1 : days; \n\n\t\treturn days;\n\t}\n\treturn null;\n};","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1166,"value":"// Calculates # of months, multiplies by monthly rate\nwage = (monthly, start, end) => {\n let s = moment(start);\n let e = moment(end);\n\n let ss = s.clone().startOf('month');\n let se = s.clone().endOf('month');\n let es = e.clone().startOf('month');\n let ee = e.clone().endOf('month');\n\n let first = networkdays(s, moment.min([se, e])) / networkdays(ss, se);\n let mid = (se < es) ? -se.clone().diff(es.clone().add(1, 'day'), 'months') : 0;\n let last = (se < e) ? networkdays(es, e) / networkdays(es, ee) : 0;\n\n let months = first + mid + last;\n\n return (s > e) ? NaN : parseFloat((monthly * months).toFixed(2));\n}\n// see https://gist.github.com/jcbagtas/8c622d294fe8ad12bb4af59f8543ce71 for getting working days","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1266,"value":"wageFromTable = (stepLevels, step, appointment, start, end) => {\n // First, get our step level data as a list of objects\n let levels = stepLevels.objects();\n\n let s = moment(start);\n let e = moment(end);\n\n let curSum = 0;\n let found = false;\n\n let i;\n for (i = 1; i < levels.length; i++) {\n let curStep = levels[i];\n let stepDate = moment(curStep.Date);\n if (stepDate.isAfter(s)) {\n curSum += wage(levels[i - 1][step.toString()] / 12 * appointment, s, e);\n \n if (stepDate.isAfter(e)) { \n return curSum;\n } else {\n s = stepDate.clone();\n }\n }\n }\n\n // If we haven't found a stepdate that's after end, return and add from last step\n curSum += wage(levels[levels.length - 1][step.toString()] * appointment / 12, s, e)\n\n return curSum;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1157,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2537,"value":"cumulPay = (monthlies) => {\n return d3.cumsum(monthlies, d => d.value).slice(-1)[0];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3877,"value":"### Visualization helpers","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1388,"value":"stepMarks = (year) => [...Array(10).keys()].map(i => {\n return Plot.lineY(\n vals(year, i + 1),\n Plot.mapY('cumsum', {x: \"date\", y: \"value\", stroke: \"lightgray\"})\n )\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1453,"value":"function sparkbar(max) {\n return x => htl.html`

${d3.format(\"$,.2f\")(x)}`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2561,"value":"$$fmt = d3.format(\"$,.2f\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3023,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3467,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1456,"value":"vals = (year, step, appt = trueAppt, summer = 1.0, steps = gsrSteps) => monthlyPay(steps, [\n { appointment: appt, step: step, ...schoolYear[year] },\n { appointment: summer, step: step, ...summers(year) },\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3882,"value":"### Academic year values\n\nFor this information, I manually looked through the PDFs for Berkeley's academic calendars from 2013-14 to 2024-25. The final day of the fall semester is the day before spring semester begins. The final day of the spring semester is the written end of semester date. The final day of the summer term is the day before the start of the next year's fall semester.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3679,"value":"falls = {\n return {\n 2013: { start: \"8/22/13\", end: \"1/13/14\" },\n 2014: { start: \"8/21/14\", end: \"1/12/15\" },\n 2015: { start: \"8/19/15\", end: \"1/11/16\" },\n 2016: { start: \"8/17/16\", end: \"1/10/17\" },\n 2017: { start: \"8/15/17\", end: \"1/8/18\" },\n 2018: { start: \"8/15/18\", end: \"1/14/19\" },\n 2019: { start: \"8/21/19\", end: \"1/12/20\" },\n 2020: { start: \"8/19/20\", end: \"1/11/21\" },\n 2021: { start: \"8/18/21\", end: \"1/10/22\" },\n 2022: { start: \"8/17/22\", end: \"1/9/23\" },\n 2023: { start: \"8/16/23\", end: \"1/8/24\" },\n 2024: { start: \"8/21/24\", end: \"1/14/25\" },\n 2025: { start: \"8/20/25\", end: \"1/12/25\" },\n }\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3684,"value":"springs = {\n return {\n 2013: { start: \"1/14/14\", end: \"5/16/14\" },\n 2014: { start: \"1/13/15\", end: \"5/15/15\" },\n 2015: { start: \"1/12/16\", end: \"5/13/16\" },\n 2016: { start: \"1/11/17\", end: \"5/12/17\" },\n 2017: { start: \"1/9/18\" , end: \"5/11/18\" },\n 2018: { start: \"1/15/19\", end: \"5/17/19\" },\n 2019: { start: \"1/13/20\", end: \"5/15/20\" },\n 2020: { start: \"1/12/21\", end: \"5/14/21\" },\n 2021: { start: \"1/11/22\", end: \"5/13/22\" },\n 2022: { start: \"1/10/23\", end: \"5/12/23\" },\n 2023: { start: \"1/9/24\" , end: \"5/10/24\" },\n 2024: { start: \"1/15/25\", end: \"5/16/25\" },\n 2025: { start: \"1/13/26\", end: \"5/15/26\" },\n }\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2313,"value":"summers = (year) => {\n let start = moment(schoolYear[year].end).clone().add(1, 'days')\n let end = moment(schoolYear[year + 1].start).clone().subtract(1, 'days')\n\n return { start: start, end: end }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2297,"value":"schoolYear = {\n return {\n 2013: { start: falls[2013].start, end: springs[2013].end },\n 2014: { start: falls[2014].start, end: springs[2014].end },\n 2015: { start: falls[2015].start, end: springs[2015].end },\n 2016: { start: falls[2016].start, end: springs[2016].end },\n 2017: { start: falls[2017].start, end: springs[2017].end },\n 2018: { start: falls[2018].start, end: springs[2018].end },\n 2019: { start: falls[2019].start, end: springs[2019].end },\n 2020: { start: falls[2020].start, end: springs[2020].end },\n 2021: { start: falls[2021].start, end: springs[2021].end },\n 2022: { start: falls[2022].start, end: springs[2022].end },\n 2023: { start: falls[2023].start, end: springs[2023].end },\n 2024: { start: falls[2024].start, end: springs[2024].end },\n 2025: { start: falls[2025].start, end: springs[2025].end },\n }\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2127,"value":"### Imports, etc.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":137,"value":"import {note, details, try_it} from \"@observablehq/callout-boxes\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"import {toc} from \"@mbostock/toc\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":602,"value":"import {aq, op} from \"@uwdata/arquero\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1170,"value":"moment = require('moment')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":770,"value":"aq.addPackage({\n tableMethods: {\n delete: (table, other, joinKey) => table.antijoin(other, joinKey),\n insert: (table, other, joinKey) => table.concat(other.antijoin(table, joinKey)),\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":427,"value":"html`\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 2e:"$2d:body"